| Line 197... |
Line 197... |
| 197 |
|
197 |
|
| 198 |
<select id = "getMovementSerializedInventoryByScans" resultType = "inventoryMovement" parameterType = "map">
|
198 |
<select id = "getMovementSerializedInventoryByScans" resultType = "inventoryMovement" parameterType = "map">
|
| 199 |
select itemId, brand, model_name as modelName, model_number as modelNumber, color, s.type, count(*) as quantity
|
199 |
select itemId, brand, model_name as modelName, model_number as modelNumber, color, s.type, count(*) as quantity
|
| 200 |
FROM inventoryItem i JOIN scanNew s ON i.id = s.inventoryItemId
|
200 |
FROM inventoryItem i JOIN scanNew s ON i.id = s.inventoryItemId
|
| 201 |
LEFT JOIN catalog.item c ON i.itemId = c.id
|
201 |
LEFT JOIN catalog.item c ON i.itemId = c.id
|
| 202 |
where s.scannedAt between #{startDate} and #{endDate} and c.type = 'SERIALIZED'
|
202 |
where s.scannedAt between #{startDate} and #{endDate} and c.type = 'SERIALIZED'
|
| - |
|
203 |
and i.currentWarehouseId not in (1,2,6,9)
|
| 203 |
group by itemId, s.type
|
204 |
group by itemId, s.type
|
| 204 |
</select>
|
205 |
</select>
|
| 205 |
|
206 |
|
| 206 |
<select id = "getMovementNonSerializedInventoryByScans" resultType = "inventoryMovement" parameterType = "map">
|
207 |
<select id = "getMovementNonSerializedInventoryByScans" resultType = "inventoryMovement" parameterType = "map">
|
| 207 |
select itemId, brand, model_name as modelName, model_number as modelNumber, color, s.type, sum(quantity) as quantity
|
208 |
select itemId, brand, model_name as modelName, model_number as modelNumber, color, s.type, sum(quantity) as quantity
|
| 208 |
FROM inventoryItem i JOIN scanNew s ON i.id = s.inventoryItemId
|
209 |
FROM inventoryItem i JOIN scanNew s ON i.id = s.inventoryItemId
|
| 209 |
LEFT JOIN catalog.item c ON i.itemId = c.id
|
210 |
LEFT JOIN catalog.item c ON i.itemId = c.id
|
| 210 |
where s.scannedAt between #{startDate} and #{endDate} and c.type = 'NON_SERIALIZED'
|
211 |
where s.scannedAt between #{startDate} and #{endDate} and c.type = 'NON_SERIALIZED'
|
| - |
|
212 |
and i.currentWarehouseId not in (1,2,6,9)
|
| 211 |
group by itemId, s.type
|
213 |
group by itemId, s.type
|
| 212 |
</select>
|
214 |
</select>
|
| 213 |
|
215 |
|
| 214 |
</mapper>
|
216 |
</mapper>
|