Changeset 87c9f1e for src/app/api/invoices/totals/route.ts

Timestamp:

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

Author:

Naum Shapkarovski <naumshapkarovski@…>

Branches:

main

Children:

32e9876

Parents:

3c5302a

Message:

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

File:

• src/app/api/invoices/totals/route.ts (modified) (2 diffs)

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
     `;