| Line 30... |
Line 30... |
| 30 |
WHERE orderId = #{orderId}
|
30 |
WHERE orderId = #{orderId}
|
| 31 |
ORDER BY scannedAt
|
31 |
ORDER BY scannedAt
|
| 32 |
</select>
|
32 |
</select>
|
| 33 |
|
33 |
|
| 34 |
<select id="getPurchaseScans" parameterType="map" resultType="detailedPurchaseScan">
|
34 |
<select id="getPurchaseScans" parameterType="map" resultType="detailedPurchaseScan">
|
| 35 |
SELECT p.purchaseOrder_id AS purchaseOrderId, po.createdAt AS poCreatedAt, s.name AS supplierName,
|
35 |
SELECT p.purchaseOrder_id AS purchaseOrderId, 1000 * UNIX_TIMESTAMP(po.createdAt) AS poCreatedAt, s.name AS supplierName,
|
| 36 |
GROUP_CONCAT(DISTINCT(invoiceNumber)) AS invoiceNumbers, i.itemId,
|
36 |
GROUP_CONCAT(DISTINCT(invoiceNumber)) AS invoiceNumbers, i.itemId,
|
| 37 |
CONCAT_WS(" ", brand, modelName, modelNumber, color) AS itemName, unitPrice, COUNT(*) AS quantity
|
37 |
CONCAT_WS(" ", brand, modelName, modelNumber, color) AS itemName, unitPrice, COUNT(*) AS quantity
|
| 38 |
FROM purchase p
|
38 |
FROM purchase p
|
| 39 |
JOIN purchaseorder po
|
39 |
JOIN purchaseorder po
|
| 40 |
ON (po.id = p.purchaseOrder_id)
|
40 |
ON (po.id = p.purchaseOrder_id)
|