Changeset 87c9f1e for src/app/api/invoices

Timestamp:

02/27/25 00:42:38 (6 weeks ago)

Author:

Naum Shapkarovski <naumshapkarovski@…>

Branches:

main

Children:

32e9876

Parents:

3c5302a

Message:

update the seed script. update the prisma schema, use mapping

Location:

src/app/api/invoices

Files:

• [id]/route.ts (modified) (1 diff)
• route.ts (modified) (2 diffs)
• totals/route.ts (modified) (2 diffs)

src/app/api/invoices/[id]/route.ts

@@ -100 +100 @@
         data: {
           invoiceNumber: validation.data.invoiceNumber,
-          createDate: validation.data.createDate,
+          issueDate: validation.data.issueDate,
           dueDate: validation.data.dueDate,
           status: validation.data.status,

src/app/api/invoices/route.ts

@@ -45 +45 @@
           ? { equals: validatedFilters.status as InvoiceStatus }
           : undefined,
-        createDate: {
+        issueDate: {
           ...(validatedFilters.startDate && { gte: validatedFilters.startDate }),
           ...(validatedFilters.endDate && { lte: validatedFilters.endDate }),
@@ -108 +108 @@
         quantityType: validatedData.quantityType,
         subTotal: validatedData.subTotal,
-        createDate: validatedData.createDate,
+        issueDate: validatedData.issueDate,
         month: validatedData.month,
         discount: validatedData.discount,

src/app/api/invoices/totals/route.ts

@@ -20 +20 @@
     const searchParams = request.nextUrl.searchParams;
     const startDate = searchParams.get('startDate')
-      ? new Date(searchParams.get('startDate')!)
+      ? new Date(searchParams.get('issueDate')!)
       : null;
 
@@ -32 +32 @@
         status,
         currency,
-        SUM("totalAmount") as total
+        SUM("total_amount") as total
       FROM "Invoice"
-      WHERE "createDate" >= ${startDate}
-        AND "invoiceFromId" = ${tenantId}
+      WHERE "issue_date" >= ${startDate}
+        AND "tenant_id" = ${tenantId}
       GROUP BY status, currency
     `;