(김준회) 임시 견적요청 및 AVL detail 관련 수정사항 처리

1 files changed, 8 insertions, 0 deletions

diff --git a/lib/projects/service.ts b/lib/projects/service.ts
index acf8b2f5..3f562e20 100644
--- a/lib/projects/service.ts
+++ b/lib/projects/service.ts
@@ -104,4 +104,12 @@ export async function getProjectInfoByProjectCode(projectCode: string) {
     projectHtDivision: projectInfo[0].type || undefined,
   };
   return projectInfoForAvl;
+}
+
+export async function getAllProjectInfoByProjectCode(projectCode: string) {
+  return await db
+    .select()
+    .from(projects)
+    .where(eq(projects.code, projectCode))
+    .limit(1);
 }
\ No newline at end of file