| Line 8239... |
Line 8239... |
| 8239 |
lineitem.transfer_price = invItem[13]
|
8239 |
lineitem.transfer_price = invItem[13]
|
| 8240 |
lineitem.nlc = invItem[14]
|
8240 |
lineitem.nlc = invItem[14]
|
| 8241 |
order.vendorId = invItem[12]
|
8241 |
order.vendorId = invItem[12]
|
| 8242 |
|
8242 |
|
| 8243 |
else:
|
8243 |
else:
|
| 8244 |
invItemSql = "select i.id, i.itemId, i.itemNumber, i.serialNumber, i.initialQuantity, i.currentQuantity, i.purchaseId, i.purchaseReturnId, i.currentWarehouseId, i.lastScanType, i.transferStatus, physicalWarehouseId, po.supplierId, l.unitPrice, l.nlc from inventoryItem i join purchase p on i.purchaseId = p.id join purchaseorder po on p.purchaseOrder_id = po.id join lineitem l on (i.itemId = l.itemId and po.id =l.purchaseOrder_id) where i.itemId = %d AND i.currentQuantity > 0 AND i.currentWarehouseId = %d AND i.physicalWarehouseId = %d AND i.lastScanType not in ('MARKED_BAD','DOA_IN','DOA_REJECTED','DOA_REPLACED') AND (i.transferStatus is NULL or i.transferStatus != 'IN_TRANSIT') AND i.itemNumber ='%s'"%(item.id,order.fulfilmentWarehouseId,order.warehouse_id,itemNumbers[0])
|
8244 |
invItemSql = "select i.id, i.itemId, i.itemNumber, i.serialNumber, i.initialQuantity, i.currentQuantity, i.purchaseId, i.purchaseReturnId, i.currentWarehouseId, i.lastScanType, i.transferStatus, physicalWarehouseId, po.supplierId, l.unitPrice, l.nlc from inventoryItem i join purchase p on i.purchaseId = p.id join purchaseorder po on p.purchaseOrder_id = po.id join lineitem l on (i.itemId = l.itemId and po.id =l.purchaseOrder_id) where i.itemId = %d AND i.currentQuantity > 0 AND i.currentWarehouseId = %d AND i.physicalWarehouseId = %d AND i.lastScanType not in ('MARKED_BAD','DOA_IN','DOA_REJECTED','DOA_REPLACED') AND (i.transferStatus is NULL or i.transferStatus != 'IN_TRANSIT') AND i.itemNumber ='%s'"%(item.id,warehouse.id,order.warehouse_id,itemNumbers[0])
|
| 8245 |
whCursor.execute(invItemSql)
|
8245 |
whCursor.execute(invItemSql)
|
| 8246 |
invItems = whCursor.fetchall()
|
8246 |
invItems = whCursor.fetchall()
|
| 8247 |
if invItems is None:
|
8247 |
if invItems is None:
|
| 8248 |
raise TransactionServiceException(317, "No Item in the inventory with this item number " + itemNumbers[0]+" in Vendor Warehouse Id- "+str(warehouse.id)+" Order Id:- "+str(order.id))
|
8248 |
raise TransactionServiceException(317, "No Item in the inventory with this item number " + itemNumbers[0]+" in Vendor Warehouse Id- "+str(warehouse.id)+" Order Id:- "+str(order.id))
|
| 8249 |
if warehouseDbConnection.open:
|
8249 |
if warehouseDbConnection.open:
|
| Line 8368... |
Line 8368... |
| 8368 |
|
8368 |
|
| 8369 |
lineitem.transfer_price = invItem[13]
|
8369 |
lineitem.transfer_price = invItem[13]
|
| 8370 |
lineitem.nlc = invItem[14]
|
8370 |
lineitem.nlc = invItem[14]
|
| 8371 |
order.vendorId = invItem[12]
|
8371 |
order.vendorId = invItem[12]
|
| 8372 |
else:
|
8372 |
else:
|
| 8373 |
invItemSql = "select i.id, i.itemId, i.itemNumber, i.serialNumber, i.initialQuantity, i.currentQuantity, i.purchaseId, i.purchaseReturnId, i.currentWarehouseId, i.lastScanType, i.transferStatus, physicalWarehouseId, po.supplierId, l.unitPrice, l.nlc from inventoryItem i join purchase p on i.purchaseId = p.id join purchaseorder po on p.purchaseOrder_id = po.id join lineitem l on (i.itemId = l.itemId and po.id =l.purchaseOrder_id) where i.itemNumber = '%s' AND itemId = %d AND i.physicalWarehouseId = %d AND i.currentWarehouseId =%d AND lastScanType in ('BAD_SALE', 'MARKED_BAD', 'SALE_RET_UNUSABLE', 'DOA_REJECTED', 'DOA_IN') AND (i.transferStatus is NULL or i.transferStatus != 'IN_TRANSIT')"%(itemNumbers[0],item.id,order.warehouse_id,order.fulfilmentWarehouseId)
|
8373 |
invItemSql = "select i.id, i.itemId, i.itemNumber, i.serialNumber, i.initialQuantity, i.currentQuantity, i.purchaseId, i.purchaseReturnId, i.currentWarehouseId, i.lastScanType, i.transferStatus, physicalWarehouseId, po.supplierId, l.unitPrice, l.nlc from inventoryItem i join purchase p on i.purchaseId = p.id join purchaseorder po on p.purchaseOrder_id = po.id join lineitem l on (i.itemId = l.itemId and po.id =l.purchaseOrder_id) where i.itemNumber = '%s' AND itemId = %d AND i.physicalWarehouseId = %d AND i.currentWarehouseId =%d AND lastScanType in ('BAD_SALE', 'MARKED_BAD', 'SALE_RET_UNUSABLE', 'DOA_REJECTED', 'DOA_IN') AND (i.transferStatus is NULL or i.transferStatus != 'IN_TRANSIT')"%(itemNumbers[0],item.id,order.warehouse_id,warehouse.id)
|
| 8374 |
whCursor.execute(invItemSql)
|
8374 |
whCursor.execute(invItemSql)
|
| 8375 |
invItems = whCursor.fetchall()
|
8375 |
invItems = whCursor.fetchall()
|
| 8376 |
if invItems is None:
|
8376 |
if invItems is None:
|
| 8377 |
if warehouseDbConnection.open:
|
8377 |
if warehouseDbConnection.open:
|
| 8378 |
warehouseDbConnection.close()
|
8378 |
warehouseDbConnection.close()
|