const {
_sum: { netSales = 0 },
} = await prisma.returnsItem.aggregate({
where: {
inventory: {
product: {
categoryId: productCategoryId ?? Prisma.skip,
},
},
returns: {
transactionDate: {
gte: start.toDate(),
lte: end.toDate(),
},
salesChannelId: salesChannelId ?? Prisma.skip,
territory: {
id: territoryId ?? Prisma.skip,
district: {
id: districtId ?? Prisma.skip,
region: {
id: regionId ?? Prisma.skip,
},
},
},
},
},
_sum: {
netSales: true,
},
});
const {
_sum: { netSales = 0 },
} = await prisma.returnsItem.aggregate({
where: {
inventory: {
product: {
categoryId: productCategoryId ?? Prisma.skip,
},
},
returns: {
transactionDate: {
gte: start.toDate(),
lte: end.toDate(),
},
salesChannelId: salesChannelId ?? Prisma.skip,
territory: {
id: territoryId ?? Prisma.skip,
district: {
id: districtId ?? Prisma.skip,
region: {
id: regionId ?? Prisma.skip,
},
},
},
},
},
_sum: {
netSales: true,
},
});