| Line 29... |
Line 29... |
| 29 |
FROM scanNew
|
29 |
FROM scanNew
|
| 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="getScansForOrderAndItem" parameterType="map" resultType="scan">
|
| - |
|
35 |
SELECT s.id as id, s.inventoryItemId as inventoryItemId, s.warehouseId as warehouseId, s.type as type,
|
| - |
|
36 |
s.scannedAt as scannedAt, s.quantity as quantity, s.orderId as orderId
|
| - |
|
37 |
FROM scanNew s
|
| - |
|
38 |
JOIN inventoryItem i
|
| - |
|
39 |
ON (s.inventoryItemId = i.id)
|
| - |
|
40 |
WHERE i.itemId = #{itemId}
|
| - |
|
41 |
AND s.orderId = #{orderId}
|
| - |
|
42 |
ORDER BY scannedAt
|
| - |
|
43 |
</select>
|
| - |
|
44 |
|
| - |
|
45 |
|
| 34 |
<select id="getPurchaseScans" parameterType="map" resultType="detailedPurchaseScan">
|
46 |
<select id="getPurchaseScans" parameterType="map" resultType="detailedPurchaseScan">
|
| 35 |
SELECT p.purchaseOrder_id AS purchaseOrderId, 1000 * UNIX_TIMESTAMP(po.createdAt) AS poCreatedAt, s.name AS supplierName,
|
47 |
SELECT p.purchaseOrder_id AS purchaseOrderId, 1000 * UNIX_TIMESTAMP(po.createdAt) AS poCreatedAt, s.name AS supplierName,
|
| 36 |
GROUP_CONCAT(DISTINCT(p.invoiceNumber)) AS invoiceNumbers, GROUP_CONCAT(DISTINCT(inv.receivedFrom)) AS receivedBy, i.itemId,
|
48 |
GROUP_CONCAT(DISTINCT(p.invoiceNumber)) AS invoiceNumbers, GROUP_CONCAT(DISTINCT(inv.receivedFrom)) AS receivedBy, i.itemId,
|
| 37 |
brand, modelName, modelNumber, color, unitPrice, SUM(initialQuantity) AS quantity, 1000 * UNIX_TIMESTAMP(receivedOn) as purchasedAt, p.id as purchaseId
|
49 |
brand, modelName, modelNumber, color, unitPrice, SUM(initialQuantity) AS quantity, 1000 * UNIX_TIMESTAMP(receivedOn) as purchasedAt, p.id as purchaseId
|
| 38 |
FROM purchase p
|
50 |
FROM purchase p
|