1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
|
import { createSearchParamsCache,
parseAsArrayOf,
parseAsInteger,
parseAsString,
parseAsStringEnum,parseAsBoolean
} from "nuqs/server"
import * as z from "zod"
import { getFiltersStateParser, getSortingStateParser } from "@/lib/parsers"
export const searchParamsRFQDashboardCache = createSearchParamsCache({
// 공통 플래그
flags: parseAsArrayOf(z.enum(["advancedTable", "floatingBar"])).withDefault([]),
// 페이징
page: parseAsInteger.withDefault(1),
perPage: parseAsInteger.withDefault(10),
// 정렬 - rfqDashboardView 기반
sort: getSortingStateParser<{
rfqId: number;
rfqCode: string;
description: string;
status: string;
dueDate: Date;
projectCode: string;
projectName: string;
packageNo: string;
packageName: string;
picName: string;
totalAttachments: number;
initialVendorCount: number;
finalVendorCount: number;
initialResponseRate: number;
finalResponseRate: number;
overallProgress: number;
daysToDeadline: number;
createdAt: Date;
}>().withDefault([
{ id: "createdAt", desc: true },
]),
// 고급 필터
filters: getFiltersStateParser().withDefault([]),
joinOperator: parseAsStringEnum(["and", "or"]).withDefault("and"),
// 기본 필터
rfqBasicFilters: getFiltersStateParser().withDefault([]),
rfqBasicJoinOperator: parseAsStringEnum(["and", "or"]).withDefault("and"),
basicFilters: getFiltersStateParser().withDefault([]),
basicJoinOperator: parseAsStringEnum(["and", "or"]).withDefault("and"),
// 검색 키워드
search: parseAsString.withDefault(""),
// RFQ 특화 필터
rfqCode: parseAsString.withDefault(""),
projectName: parseAsString.withDefault(""),
projectCode: parseAsString.withDefault(""),
picName: parseAsString.withDefault(""),
packageNo: parseAsString.withDefault(""),
status: parseAsStringEnum([
"DRAFT",
"Doc. Received",
"PIC Assigned",
"Doc. Confirmed",
"Init. RFQ Sent",
"Init. RFQ Answered",
"TBE started",
"TBE finished",
"Final RFQ Sent",
"Quotation Received",
"Vendor Selected"
]),
dueDateFrom: parseAsString.withDefault(""),
dueDateTo: parseAsString.withDefault(""),
progressMin: parseAsInteger.withDefault(0),
progressMax: parseAsInteger.withDefault(100),
});
export type GetRFQDashboardSchema = Awaited<ReturnType<typeof searchParamsRFQDashboardCache.parse>>
export const createRfqServerSchema = z.object({
projectId: z.number().min(1, "프로젝트를 선택해주세요"), // 필수로 변경
dueDate: z.date(), // Date 객체로 직접 받기
picCode: z.string().min(1, "구매 담당자 코드를 입력해주세요"),
picName: z.string().optional(),
engPicName: z.string().optional(),
packageNo: z.string().min(1, "패키지 번호를 입력해주세요"),
packageName: z.string().min(1, "패키지명을 입력해주세요"),
remark: z.string().optional(),
projectCompany: z.string().optional(),
projectFlag: z.string().optional(),
projectSite: z.string().optional(),
createdBy: z.number(),
updatedBy: z.number(),
})
export type CreateRfqInput = z.infer<typeof createRfqServerSchema>
export type RfqAttachment = {
id: number
attachmentType: string
serialNo: string
rfqId: number
fileName: string
originalFileName: string
filePath: string
fileSize: number | null
fileType: string | null
description: string | null
createdBy: number
createdAt: Date
createdByName?: string
responseStats?: {
totalVendors: number
respondedCount: number
pendingCount: number
waivedCount: number
responseRate: number
}
}
// RFQ Attachments용 검색 파라미터 캐시
export const searchParamsRfqAttachmentsCache = createSearchParamsCache({
flags: parseAsArrayOf(z.enum(["advancedTable", "floatingBar"])).withDefault([]),
page: parseAsInteger.withDefault(1),
perPage: parseAsInteger.withDefault(10),
sort: getSortingStateParser<RfqAttachment>().withDefault([
{ id: "createdAt", desc: true },
]),
// 기본 필터
attachmentType: parseAsArrayOf(z.string()).withDefault([]),
fileType: parseAsArrayOf(z.string()).withDefault([]),
search: parseAsString.withDefault(""),
// advanced filter
filters: getFiltersStateParser().withDefault([]),
joinOperator: parseAsStringEnum(["and", "or"]).withDefault("and"),
})
// 스키마 타입들
export type GetRfqAttachmentsSchema = Awaited<ReturnType<typeof searchParamsRfqAttachmentsCache.parse>>
// 첨부파일 레코드 타입
export const attachmentRecordSchema = z.object({
rfqId: z.number().positive(),
attachmentType: z.enum(["구매", "설계"]),
// serialNo: z.string().min(1),
description: z.string().optional(),
fileName: z.string(),
originalFileName: z.string(),
filePath: z.string(),
fileSize: z.number(),
fileType: z.string(),
})
export type AttachmentRecord = z.infer<typeof attachmentRecordSchema>
export const deleteAttachmentsSchema = z.object({
ids: z.array(z.number()).min(1, "삭제할 첨부파일을 선택해주세요."),
})
export type DeleteAttachmentsInput = z.infer<typeof deleteAttachmentsSchema>
//Inital RFQ
export const searchParamsInitialRfqDetailCache = createSearchParamsCache({
// 공통 플래그
flags: parseAsArrayOf(z.enum(["advancedTable", "floatingBar"])).withDefault([]),
// 페이징
page: parseAsInteger.withDefault(1),
perPage: parseAsInteger.withDefault(10),
// 정렬 - initialRfqDetailView 기반
sort: getSortingStateParser<{
rfqId: number;
rfqCode: string;
rfqStatus: string;
initialRfqId: number;
initialRfqStatus: string;
vendorId: number;
vendorCode: string;
vendorName: string;
vendorCountry: string;
vendorBusinessSize: string;
dueDate: Date;
validDate: Date;
incotermsCode: string;
incotermsDescription: string;
shortList: boolean;
returnYn: boolean;
cpRequestYn: boolean;
prjectGtcYn: boolean;
returnRevision: number;
gtc: string;
gtcValidDate: string;
classification: string;
sparepart: string;
createdAt: Date;
updatedAt: Date;
}>().withDefault([
{ id: "createdAt", desc: true },
]),
// 고급 필터
filters: getFiltersStateParser().withDefault([]),
joinOperator: parseAsStringEnum(["and", "or"]).withDefault("and"),
// 기본 필터
basicFilters: getFiltersStateParser().withDefault([]),
basicJoinOperator: parseAsStringEnum(["and", "or"]).withDefault("and"),
// 검색 키워드
search: parseAsString.withDefault(""),
// Initial RFQ Detail 특화 필터
rfqCode: parseAsString.withDefault(""),
rfqStatus: parseAsStringEnum([
"DRAFT",
"Doc. Received",
"PIC Assigned",
"Doc. Confirmed",
"Init. RFQ Sent",
"Init. RFQ Answered",
"TBE started",
"TBE finished",
"Final RFQ Sent",
"Quotation Received",
"Vendor Selected"
]),
initialRfqStatus: parseAsStringEnum([
"PENDING",
"SENT",
"RESPONDED",
"EXPIRED",
"CANCELLED"
]),
vendorName: parseAsString.withDefault(""),
vendorCode: parseAsString.withDefault(""),
vendorCountry: parseAsString.withDefault(""),
vendorBusinessSize: parseAsStringEnum([
"LARGE",
"MEDIUM",
"SMALL",
"STARTUP"
]),
incotermsCode: parseAsString.withDefault(""),
dueDateFrom: parseAsString.withDefault(""),
dueDateTo: parseAsString.withDefault(""),
validDateFrom: parseAsString.withDefault(""),
validDateTo: parseAsString.withDefault(""),
shortList: parseAsStringEnum(["true", "false"]),
returnYn: parseAsStringEnum(["true", "false"]),
cpRequestYn: parseAsStringEnum(["true", "false"]),
prjectGtcYn: parseAsStringEnum(["true", "false"]),
classification: parseAsString.withDefault(""),
sparepart: parseAsString.withDefault(""),
});
export type GetInitialRfqDetailSchema = Awaited<ReturnType<typeof searchParamsInitialRfqDetailCache.parse>>;
|
