Files
DentalManagementMHAprilgg/packages/db/shared/schemas/results/ServiceLineTransactionGroupByResult.schema.ts
2026-04-04 22:13:55 -04:00

66 lines
2.1 KiB
TypeScript

import * as z from 'zod';
export const ServiceLineTransactionGroupByResultSchema = z.array(z.object({
id: z.number().int(),
paymentId: z.number().int(),
serviceLineId: z.number().int(),
transactionId: z.string(),
paidAmount: z.number(),
adjustedAmount: z.number(),
receivedDate: z.date(),
payerName: z.string(),
notes: z.string(),
createdAt: z.date(),
_count: z.object({
id: z.number(),
paymentId: z.number(),
serviceLineId: z.number(),
transactionId: z.number(),
paidAmount: z.number(),
adjustedAmount: z.number(),
method: z.number(),
receivedDate: z.number(),
payerName: z.number(),
notes: z.number(),
createdAt: z.number(),
payment: z.number(),
serviceLine: z.number()
}).optional(),
_sum: z.object({
id: z.number().nullable(),
paymentId: z.number().nullable(),
serviceLineId: z.number().nullable(),
paidAmount: z.number().nullable(),
adjustedAmount: z.number().nullable()
}).nullable().optional(),
_avg: z.object({
id: z.number().nullable(),
paymentId: z.number().nullable(),
serviceLineId: z.number().nullable(),
paidAmount: z.number().nullable(),
adjustedAmount: z.number().nullable()
}).nullable().optional(),
_min: z.object({
id: z.number().int().nullable(),
paymentId: z.number().int().nullable(),
serviceLineId: z.number().int().nullable(),
transactionId: z.string().nullable(),
paidAmount: z.number().nullable(),
adjustedAmount: z.number().nullable(),
receivedDate: z.date().nullable(),
payerName: z.string().nullable(),
notes: z.string().nullable(),
createdAt: z.date().nullable()
}).nullable().optional(),
_max: z.object({
id: z.number().int().nullable(),
paymentId: z.number().int().nullable(),
serviceLineId: z.number().int().nullable(),
transactionId: z.string().nullable(),
paidAmount: z.number().nullable(),
adjustedAmount: z.number().nullable(),
receivedDate: z.date().nullable(),
payerName: z.string().nullable(),
notes: z.string().nullable(),
createdAt: z.date().nullable()
}).nullable().optional()
}));