| Line 355... |
Line 355... |
| 355 |
|
355 |
|
| 356 |
<select id = "getCompleteMovementSerializedInventoryByScans" resultType = "inventoryMovement" parameterType = "map">
|
356 |
<select id = "getCompleteMovementSerializedInventoryByScans" resultType = "inventoryMovement" parameterType = "map">
|
| 357 |
SELECT itemId, brand, model_name as modelName, model_number as modelNumber, color, s.type, count(*) as quantity
|
357 |
SELECT itemId, brand, model_name as modelName, model_number as modelNumber, color, s.type, count(*) as quantity
|
| 358 |
FROM inventoryItem i JOIN scanNew s ON i.id = s.inventoryItemId
|
358 |
FROM inventoryItem i JOIN scanNew s ON i.id = s.inventoryItemId
|
| 359 |
LEFT JOIN catalog.item c ON i.itemId = c.id
|
359 |
LEFT JOIN catalog.item c ON i.itemId = c.id
|
| 360 |
where s.scannedAt between #{startDate} and #{endDate} and c.type = 'SERIALIZED'
|
360 |
where s.scannedAt between #{startDate} and #{endDate} and c.type = 'SERIALIZED'
|
| 361 |
and s.warehouseId not in (select id from inventory.warehouse where vendor_id= 40
|
- |
|
| 362 |
and inventoryType = 'GOOD' and warehouseType ='OURS_THIRDPARTY' and source = 3)
|
- |
|
| 363 |
group by itemId, s.type
|
361 |
group by itemId, s.type
|
| 364 |
</select>
|
362 |
</select>
|
| 365 |
|
363 |
|
| 366 |
<select id = "getCompleteMovementNonSerializedInventoryByScans" resultType = "inventoryMovement" parameterType = "map">
|
364 |
<select id = "getCompleteMovementNonSerializedInventoryByScans" resultType = "inventoryMovement" parameterType = "map">
|
| 367 |
SELECT itemId, brand, model_name as modelName, model_number as modelNumber, color, s.type, sum(quantity) as quantity
|
365 |
SELECT itemId, brand, model_name as modelName, model_number as modelNumber, color, s.type, sum(quantity) as quantity
|
| 368 |
FROM inventoryItem i JOIN scanNew s ON i.id = s.inventoryItemId
|
366 |
FROM inventoryItem i JOIN scanNew s ON i.id = s.inventoryItemId
|
| 369 |
LEFT JOIN catalog.item c ON i.itemId = c.id
|
367 |
LEFT JOIN catalog.item c ON i.itemId = c.id
|
| 370 |
where s.scannedAt between #{startDate} and #{endDate} and c.type = 'NON_SERIALIZED'
|
368 |
where s.scannedAt between #{startDate} and #{endDate} and c.type = 'NON_SERIALIZED'
|
| 371 |
and s.warehouseId not in (select id from inventory.warehouse where vendor_id= 40
|
- |
|
| 372 |
and inventoryType = 'GOOD' and warehouseType ='OURS_THIRDPARTY' and source = 3)
|
- |
|
| 373 |
group by itemId, s.type
|
369 |
group by itemId, s.type
|
| 374 |
</select>
|
370 |
</select>
|
| 375 |
|
371 |
|
| 376 |
<select id = "getTransferrableWarehousesFromWarehouse" resultType = "java.lang.Long" parameterType = "java.lang.Long">
|
372 |
<select id = "getTransferrableWarehousesFromWarehouse" resultType = "java.lang.Long" parameterType = "java.lang.Long">
|
| 377 |
SELECT toWarehouseId
|
373 |
SELECT toWarehouseId
|