| Line 352... |
Line 352... |
| 352 |
and inventoryType = 'GOOD' and warehouseType ='OURS_THIRDPARTY' and source in (3,7,8))
|
352 |
and inventoryType = 'GOOD' and warehouseType ='OURS_THIRDPARTY' and source in (3,7,8))
|
| 353 |
group by itemId, s.type
|
353 |
group by itemId, s.type
|
| 354 |
</select>
|
354 |
</select>
|
| 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, sum(quantity) 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 and inventoryType = 'GOOD' and warehouseType ='OURS_THIRDPARTY' and source in (3,7,8))
|
| 361 |
group by itemId, s.type
|
362 |
group by itemId, s.type
|
| 362 |
</select>
|
363 |
</select>
|
| 363 |
|
364 |
|
| 364 |
<select id = "getCompleteMovementNonSerializedInventoryByScans" resultType = "inventoryMovement" parameterType = "map">
|
365 |
<select id = "getCompleteMovementNonSerializedInventoryByScans" resultType = "inventoryMovement" parameterType = "map">
|
| 365 |
SELECT itemId, brand, model_name as modelName, model_number as modelNumber, color, s.type, sum(quantity) as quantity
|
366 |
SELECT itemId, brand, model_name as modelName, model_number as modelNumber, color, s.type, sum(quantity) as quantity
|
| 366 |
FROM inventoryItem i JOIN scanNew s ON i.id = s.inventoryItemId
|
367 |
FROM inventoryItem i JOIN scanNew s ON i.id = s.inventoryItemId
|
| 367 |
LEFT JOIN catalog.item c ON i.itemId = c.id
|
368 |
LEFT JOIN catalog.item c ON i.itemId = c.id
|
| 368 |
where s.scannedAt between #{startDate} and #{endDate} and c.type = 'NON_SERIALIZED'
|
369 |
where s.scannedAt between #{startDate} and #{endDate} and c.type = 'NON_SERIALIZED'
|
| - |
|
370 |
AND s.warehouseId NOT IN (select id from inventory.warehouse where vendor_id= 40 and inventoryType = 'GOOD' and warehouseType ='OURS_THIRDPARTY' and source in (3,7,8))
|
| 369 |
group by itemId, s.type
|
371 |
group by itemId, s.type
|
| 370 |
</select>
|
372 |
</select>
|
| 371 |
|
373 |
|
| 372 |
<select id = "getTransferrableWarehousesFromWarehouse" resultType = "java.lang.Long" parameterType = "java.lang.Long">
|
374 |
<select id = "getTransferrableWarehousesFromWarehouse" resultType = "java.lang.Long" parameterType = "java.lang.Long">
|
| 373 |
SELECT toWarehouseId
|
375 |
SELECT toWarehouseId
|
| Line 477... |
Line 479... |
| 477 |
AND ii.lastScanType != 'MARKED_BAD' AND (transferStatus is NULL or transferStatus != 'IN_TRANSIT') AND ii.itemId = #{itemId}
|
479 |
AND ii.lastScanType != 'MARKED_BAD' AND (transferStatus is NULL or transferStatus != 'IN_TRANSIT') AND ii.itemId = #{itemId}
|
| 478 |
AND ii.physicalWarehouseId NOT IN (select id from inventory.warehouse where vendor_id= 40 and inventoryType = 'GOOD' and warehouseType ='OURS_THIRDPARTY' and source in (3,7,8))
|
480 |
AND ii.physicalWarehouseId NOT IN (select id from inventory.warehouse where vendor_id= 40 and inventoryType = 'GOOD' and warehouseType ='OURS_THIRDPARTY' and source in (3,7,8))
|
| 479 |
GROUP BY ii.id, ii.itemId, ii.currentQuantity order by ii.id desc;
|
481 |
GROUP BY ii.id, ii.itemId, ii.currentQuantity order by ii.id desc;
|
| 480 |
</select>
|
482 |
</select>
|
| 481 |
|
483 |
|
| - |
|
484 |
<select id="getCompleteMovementForThirdPartyWarehouse" resultType = "inventoryMovement" parameterType = "map">
|
| - |
|
485 |
SELECT itemId, brand, model_name as modelName, model_number as modelNumber, color, s.type, sum(quantity) as quantity
|
| - |
|
486 |
FROM inventoryItem i JOIN scanNew s ON i.id = s.inventoryItemId
|
| - |
|
487 |
LEFT JOIN catalog.item c ON i.itemId = c.id
|
| - |
|
488 |
where s.scannedAt between #{startDate} and #{endDate}
|
| - |
|
489 |
AND s.warehouseId IN (select id from inventory.warehouse where vendor_id= 40 and inventoryType = 'GOOD' and warehouseType ='OURS_THIRDPARTY' and source in (3,7,8))
|
| - |
|
490 |
group by itemId, s.type
|
| - |
|
491 |
</select>
|
| - |
|
492 |
|
| 482 |
</mapper>
|
493 |
</mapper>
|