From 6459d90482efa57fed6f43204c20fdfbe33ffbd8 Mon Sep 17 00:00:00 2001
From: joonhoekim <26rote@gmail.com>
Date: Tue, 9 Sep 2025 11:59:51 +0000
Subject: (김준회) EDP-Progress 프로젝트 목록 찾기 쿼리 오류 수정, 자재그룹
 싱크 및 테이블 관련 오류 수정
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

---
 lib/forms/stat.ts | 6 +++---
 1 file changed, 3 insertions(+), 3 deletions(-)

(limited to 'lib/forms')

diff --git a/lib/forms/stat.ts b/lib/forms/stat.ts
index 887f1a05..80193c48 100644
--- a/lib/forms/stat.ts
+++ b/lib/forms/stat.ts
@@ -20,12 +20,12 @@ export async function getProjectsWithContracts() {
     const projectList = await db
       .selectDistinct({
         id: projects.id,
-        projectCode: projects.projectCode,
-        projectName: projects.projectName,
+        projectCode: projects.code,
+        projectName: projects.name,
       })
       .from(projects)
       .innerJoin(contracts, eq(contracts.projectId, projects.id))
-      .orderBy(projects.projectCode)
+      .orderBy(projects.code)
 
     return projectList
   } catch (error) {
-- 
cgit v1.2.3