summaryrefslogtreecommitdiff
path: root/lib/knox-api/approval/service.ts
diff options
context:
space:
mode:
Diffstat (limited to 'lib/knox-api/approval/service.ts')
-rw-r--r--lib/knox-api/approval/service.ts30
1 files changed, 15 insertions, 15 deletions
diff --git a/lib/knox-api/approval/service.ts b/lib/knox-api/approval/service.ts
index 6ef1b1f6..0bd817a6 100644
--- a/lib/knox-api/approval/service.ts
+++ b/lib/knox-api/approval/service.ts
@@ -1,7 +1,7 @@
"use server"
import db from '@/db/db';
import { ApprovalLine } from "./approval";
-import { approval } from '@/db/schema/knox/approvals';
+import { approvalLogs } from '@/db/schema/knox/approvals';
import { eq, and } from 'drizzle-orm';
// ========== 데이터베이스 서비스 함수들 ==========
@@ -21,7 +21,7 @@ export async function saveApprovalToDatabase(
aplns: ApprovalLine[]
): Promise<void> {
try {
- await db.insert(approval).values({
+ await db.insert(approvalLogs).values({
apInfId,
userId,
epId,
@@ -51,12 +51,12 @@ export async function updateApprovalStatus(
): Promise<void> {
try {
await db
- .update(approval)
+ .update(approvalLogs)
.set({
status,
updatedAt: new Date(),
})
- .where(eq(approval.apInfId, apInfId));
+ .where(eq(approvalLogs.apInfId, apInfId));
} catch (error) {
console.error('결재 상태 업데이트 실패:', error);
throw new Error('결재 상태를 업데이트하는 중 오류가 발생했습니다.');
@@ -69,15 +69,15 @@ export async function updateApprovalStatus(
export async function getApprovalFromDatabase(
apInfId: string,
includeDeleted: boolean = false
-): Promise<typeof approval.$inferSelect | null> {
+): Promise<typeof approvalLogs.$inferSelect | null> {
try {
const whereCondition = includeDeleted
- ? eq(approval.apInfId, apInfId)
- : and(eq(approval.apInfId, apInfId), eq(approval.isDeleted, false));
+ ? eq(approvalLogs.apInfId, apInfId)
+ : and(eq(approvalLogs.apInfId, apInfId), eq(approvalLogs.isDeleted, false));
const result = await db
.select()
- .from(approval)
+ .from(approvalLogs)
.where(whereCondition)
.limit(1);
@@ -96,17 +96,17 @@ export async function getApprovalsByUser(
limit: number = 50,
offset: number = 0,
includeDeleted: boolean = false
-): Promise<typeof approval.$inferSelect[]> {
+): Promise<typeof approvalLogs.$inferSelect[]> {
try {
const whereCondition = includeDeleted
- ? eq(approval.userId, userId)
- : and(eq(approval.userId, userId), eq(approval.isDeleted, false));
+ ? eq(approvalLogs.userId, userId)
+ : and(eq(approvalLogs.userId, userId), eq(approvalLogs.isDeleted, false));
const result = await db
.select()
- .from(approval)
+ .from(approvalLogs)
.where(whereCondition)
- .orderBy(approval.createdAt)
+ .orderBy(approvalLogs.createdAt)
.limit(limit)
.offset(offset);
@@ -125,12 +125,12 @@ export async function deleteApprovalFromDatabase(
): Promise<void> {
try {
await db
- .update(approval)
+ .update(approvalLogs)
.set({
isDeleted: true,
updatedAt: new Date(),
})
- .where(eq(approval.apInfId, apInfId));
+ .where(eq(approvalLogs.apInfId, apInfId));
} catch (error) {
console.error('결재 데이터 삭제 실패:', error);
throw new Error('결재 데이터를 삭제하는 중 오류가 발생했습니다.');