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
|
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>
|
