diff options
Diffstat (limited to 'lib/rfq-last/service.ts')
| -rw-r--r-- | lib/rfq-last/service.ts | 9 |
1 files changed, 7 insertions, 2 deletions
diff --git a/lib/rfq-last/service.ts b/lib/rfq-last/service.ts index 433f4376..723a69fe 100644 --- a/lib/rfq-last/service.ts +++ b/lib/rfq-last/service.ts @@ -268,7 +268,7 @@ async function generateGeneralRfqCode(userCode: string): Promise<string> { .from(rfqsLast) .where( and( - eq(rfqsLast.rfqType, "일반견적"), + // eq(rfqsLast.rfqType, "일반견적"), like(rfqsLast.rfqCode, `F${userCode}%`) // 같은 userCode로 시작하는 RFQ만 조회 ) ) @@ -450,7 +450,7 @@ export async function previewGeneralRfqCode(picUserId: number): Promise<string> .from(rfqsLast) .where( and( - eq(rfqsLast.rfqType, "일반견적"), + // eq(rfqsLast.rfqType, "일반견적"), like(rfqsLast.rfqCode, `F${userCode}%`) ) ) @@ -459,6 +459,10 @@ export async function previewGeneralRfqCode(picUserId: number): Promise<string> let nextNumber = 1; + console.log(lastRfq,"lastRfq") + console.log(userCode,"userCode") + + if (lastRfq.length > 0 && lastRfq[0].rfqCode) { const rfqCode = lastRfq[0].rfqCode; const serialNumber = rfqCode.slice(-5); @@ -471,6 +475,7 @@ export async function previewGeneralRfqCode(picUserId: number): Promise<string> const paddedNumber = String(nextNumber).padStart(5, '0'); return `F${userCode}${paddedNumber}`; } catch (error) { + console.log(error) return `F???XXXXX`; } } |