(대표님) edp, tbe, dolce 등

1 files changed, 14 insertions, 5 deletions

diff --git a/lib/pq/service.ts b/lib/pq/service.ts
index 67be5398..f58a1d4d 100644
--- a/lib/pq/service.ts
+++ b/lib/pq/service.ts
@@ -94,6 +94,10 @@ export async function getPQDataByVendorId(
   projectId?: number

 ): Promise<PQGroupData[]> {

   try {

+    // 파라미터 유효성 검증

+    if (isNaN(vendorId)) {

+      throw new Error("Invalid vendorId parameter");

+    }

     // 기본 쿼리 구성

     const selectObj = {

       criteriaId: pqCriterias.id,

@@ -1531,6 +1535,7 @@ export async function getAllPQsByVendorId(vendorId: number) {
 // 특정 PQ의 상세 정보 조회 (개별 PQ 페이지용)

 export async function getPQById(pqSubmissionId: number, vendorId: number) {

   try {

+

     const pq = await db

       .select({

         id: vendorPQSubmissions.id,

@@ -1543,12 +1548,15 @@ export async function getPQById(pqSubmissionId: number, vendorId: number) {
         approvedAt: vendorPQSubmissions.approvedAt,

         rejectedAt: vendorPQSubmissions.rejectedAt,

         rejectReason: vendorPQSubmissions.rejectReason,

-        

+

         // 벤더 정보 (추가)

         vendorName: vendors.vendorName,

         vendorCode: vendors.vendorCode,

         vendorStatus: vendors.status,

-        

+        vendorCountry: vendors.country,

+        vendorEmail: vendors.email,

+        vendorPhone: vendors.phone,

+

         // 프로젝트 정보 (조인)

         projectName: projects.name,

         projectCode: projects.code,

@@ -1564,11 +1572,11 @@ export async function getPQById(pqSubmissionId: number, vendorId: number) {
       )

       .limit(1)

       .then(rows => rows[0]);

-    

+

     if (!pq) {

       throw new Error("PQ not found or access denied");

     }

-    

+

     return pq;

   } catch (error) {

     console.error("Error fetching PQ by ID:", error);

@@ -4046,11 +4054,12 @@ export async function updatePqValidToAction(input: UpdatePqValidToInput) {
   }

 }

 

+

 // SHI 참석자 총 인원수 계산 함수

 

 export async function getTotalShiAttendees(shiAttendees: Record<string, unknown> | null): Promise<number> {

   if (!shiAttendees) return 0

-  

+

   let total = 0

   Object.entries(shiAttendees).forEach(([key, value]) => {

     if (value && typeof value === 'object' && 'checked' in value && 'count' in value) {