summaryrefslogtreecommitdiff
path: root/lib/material
diff options
context:
space:
mode:
Diffstat (limited to 'lib/material')
-rw-r--r--lib/material/vendor-possible-material-service.ts92
1 files changed, 46 insertions, 46 deletions
diff --git a/lib/material/vendor-possible-material-service.ts b/lib/material/vendor-possible-material-service.ts
index 119f4277..03c914a7 100644
--- a/lib/material/vendor-possible-material-service.ts
+++ b/lib/material/vendor-possible-material-service.ts
@@ -3,7 +3,7 @@
import { unstable_noStore } from "next/cache";
import { and, desc, eq, count } from "drizzle-orm";
import db from "@/db/db";
-import { vendorPossibleMateirals, vendors, vendorTypes } from "@/db/schema/vendors";
+import { vendorPossibleMaterials, vendors, vendorTypes } from "@/db/schema/vendors";
// 타입 정의
export interface VendorPossibleMaterial {
@@ -50,37 +50,37 @@ export async function getAllConfirmedMaterials(
try {
const baseConditions = [
- eq(vendorPossibleMateirals.vendorId, vendorId),
- eq(vendorPossibleMateirals.isConfirmed, true)
+ eq(vendorPossibleMaterials.vendorId, vendorId),
+ eq(vendorPossibleMaterials.isConfirmed, true)
];
const whereCondition = and(...baseConditions);
const data = await db
.select({
- id: vendorPossibleMateirals.id,
- vendorId: vendorPossibleMateirals.vendorId,
- itemCode: vendorPossibleMateirals.itemCode,
- itemName: vendorPossibleMateirals.itemName,
- registerUserId: vendorPossibleMateirals.registerUserId,
- registerUserName: vendorPossibleMateirals.registerUserName,
- isConfirmed: vendorPossibleMateirals.isConfirmed,
- recentPoNo: vendorPossibleMateirals.recentPoNo,
- recentPoDate: vendorPossibleMateirals.recentPoDate,
- recentDeliveryDate: vendorPossibleMateirals.recentDeliveryDate,
- recentOrderDate: vendorPossibleMateirals.recentOrderDate,
- recentOrderUserName: vendorPossibleMateirals.recentOrderUserName,
- purchaseGroupCode: vendorPossibleMateirals.purchaseGroupCode,
- createdAt: vendorPossibleMateirals.createdAt,
- updatedAt: vendorPossibleMateirals.updatedAt,
+ id: vendorPossibleMaterials.id,
+ vendorId: vendorPossibleMaterials.vendorId,
+ itemCode: vendorPossibleMaterials.itemCode,
+ itemName: vendorPossibleMaterials.itemName,
+ registerUserId: vendorPossibleMaterials.registerUserId,
+ registerUserName: vendorPossibleMaterials.registerUserName,
+ isConfirmed: vendorPossibleMaterials.isConfirmed,
+ recentPoNo: vendorPossibleMaterials.recentPoNo,
+ recentPoDate: vendorPossibleMaterials.recentPoDate,
+ recentDeliveryDate: vendorPossibleMaterials.recentDeliveryDate,
+ recentOrderDate: vendorPossibleMaterials.recentOrderDate,
+ recentOrderUserName: vendorPossibleMaterials.recentOrderUserName,
+ purchaseGroupCode: vendorPossibleMaterials.purchaseGroupCode,
+ createdAt: vendorPossibleMaterials.createdAt,
+ updatedAt: vendorPossibleMaterials.updatedAt,
vendorTypeNameEn: vendorTypes.nameEn,
vendorTypeName: vendorTypes.nameKo,
})
- .from(vendorPossibleMateirals)
- .leftJoin(vendors, eq(vendorPossibleMateirals.vendorId, vendors.id))
+ .from(vendorPossibleMaterials)
+ .leftJoin(vendors, eq(vendorPossibleMaterials.vendorId, vendors.id))
.leftJoin(vendorTypes, eq(vendors.vendorTypeId, vendorTypes.id))
.where(whereCondition)
- .orderBy(desc(vendorPossibleMateirals.createdAt));
+ .orderBy(desc(vendorPossibleMaterials.createdAt));
return data;
} catch (error) {
@@ -99,37 +99,37 @@ export async function getAllVendorInputMaterials(
try {
const baseConditions = [
- eq(vendorPossibleMateirals.vendorId, vendorId),
- eq(vendorPossibleMateirals.isConfirmed, false)
+ eq(vendorPossibleMaterials.vendorId, vendorId),
+ eq(vendorPossibleMaterials.isConfirmed, false)
];
const whereCondition = and(...baseConditions);
const data = await db
.select({
- id: vendorPossibleMateirals.id,
- vendorId: vendorPossibleMateirals.vendorId,
- itemCode: vendorPossibleMateirals.itemCode,
- itemName: vendorPossibleMateirals.itemName,
- registerUserId: vendorPossibleMateirals.registerUserId,
- registerUserName: vendorPossibleMateirals.registerUserName,
- isConfirmed: vendorPossibleMateirals.isConfirmed,
- recentPoNo: vendorPossibleMateirals.recentPoNo,
- recentPoDate: vendorPossibleMateirals.recentPoDate,
- recentDeliveryDate: vendorPossibleMateirals.recentDeliveryDate,
- recentOrderDate: vendorPossibleMateirals.recentOrderDate,
- recentOrderUserName: vendorPossibleMateirals.recentOrderUserName,
- purchaseGroupCode: vendorPossibleMateirals.purchaseGroupCode,
- createdAt: vendorPossibleMateirals.createdAt,
- updatedAt: vendorPossibleMateirals.updatedAt,
+ id: vendorPossibleMaterials.id,
+ vendorId: vendorPossibleMaterials.vendorId,
+ itemCode: vendorPossibleMaterials.itemCode,
+ itemName: vendorPossibleMaterials.itemName,
+ registerUserId: vendorPossibleMaterials.registerUserId,
+ registerUserName: vendorPossibleMaterials.registerUserName,
+ isConfirmed: vendorPossibleMaterials.isConfirmed,
+ recentPoNo: vendorPossibleMaterials.recentPoNo,
+ recentPoDate: vendorPossibleMaterials.recentPoDate,
+ recentDeliveryDate: vendorPossibleMaterials.recentDeliveryDate,
+ recentOrderDate: vendorPossibleMaterials.recentOrderDate,
+ recentOrderUserName: vendorPossibleMaterials.recentOrderUserName,
+ purchaseGroupCode: vendorPossibleMaterials.purchaseGroupCode,
+ createdAt: vendorPossibleMaterials.createdAt,
+ updatedAt: vendorPossibleMaterials.updatedAt,
vendorTypeNameEn: vendorTypes.nameEn,
vendorTypeName: vendorTypes.nameKo,
})
- .from(vendorPossibleMateirals)
- .leftJoin(vendors, eq(vendorPossibleMateirals.vendorId, vendors.id))
+ .from(vendorPossibleMaterials)
+ .leftJoin(vendors, eq(vendorPossibleMaterials.vendorId, vendors.id))
.leftJoin(vendorTypes, eq(vendors.vendorTypeId, vendorTypes.id))
.where(whereCondition)
- .orderBy(desc(vendorPossibleMateirals.createdAt));
+ .orderBy(desc(vendorPossibleMaterials.createdAt));
return data;
} catch (error) {
@@ -162,12 +162,12 @@ export async function addConfirmedMaterial(
// 중복 확인 - 같은 vendorId와 itemCode 조합이 이미 확정정보에 있는지 체크
const existingMaterial = await db
.select()
- .from(vendorPossibleMateirals)
+ .from(vendorPossibleMaterials)
.where(
and(
- eq(vendorPossibleMateirals.vendorId, vendorId),
- eq(vendorPossibleMateirals.itemCode, materialData.itemCode),
- eq(vendorPossibleMateirals.isConfirmed, true)
+ eq(vendorPossibleMaterials.vendorId, vendorId),
+ eq(vendorPossibleMaterials.itemCode, materialData.itemCode),
+ eq(vendorPossibleMaterials.isConfirmed, true)
)
)
.limit(1);
@@ -178,7 +178,7 @@ export async function addConfirmedMaterial(
// 새 확정정보 추가
const result = await db
- .insert(vendorPossibleMateirals)
+ .insert(vendorPossibleMaterials)
.values({
vendorId,
itemCode: materialData.itemCode,
generated by cgit v1.2.3 (git 2.39.1) at 2025-12-07 14:50:46 +0000