const quotation = await db.query.quotations.findFirst({
with: {
quotationLines: {
with: {
materialVariant: {
with: {
materialVariantsToSuppliers: {
with: {
supplier: true,
},
},
},
},
supplier: true,
},
orderBy: [asc(quotationItemLines.created_at), asc(quotationItemLines.id)],
},
quotationItems: {
with: {
billOfMaterials: true,
},
},
},
where: (table, { eq }) => eq(table.id, id),
})
const quotation = await db.query.quotations.findFirst({
with: {
quotationLines: {
with: {
materialVariant: {
with: {
materialVariantsToSuppliers: {
with: {
supplier: true,
},
},
},
},
supplier: true,
},
orderBy: [asc(quotationItemLines.created_at), asc(quotationItemLines.id)],
},
quotationItems: {
with: {
billOfMaterials: true,
},
},
},
where: (table, { eq }) => eq(table.id, id),
})