| Line 8205... |
Line 8205... |
| 8205 |
raise TransactionServiceException(312, "Trying to Scan In-Transit Inventory " + serialNumber+" and Order Id:- "+str(order.id))
|
8205 |
raise TransactionServiceException(312, "Trying to Scan In-Transit Inventory " + serialNumber+" and Order Id:- "+str(order.id))
|
| 8206 |
if invItem[9]=='MARKED_BAD' or invItem[9]=='DOA_IN' or invItem[9]=='DOA_OUT' or invItem[9]=='DOA_REJECTED' or invItem[9]=='SALE_RET_UNUSABLE' or invItem[9]=='BAD_SALE':
|
8206 |
if invItem[9]=='MARKED_BAD' or invItem[9]=='DOA_IN' or invItem[9]=='DOA_OUT' or invItem[9]=='DOA_REJECTED' or invItem[9]=='SALE_RET_UNUSABLE' or invItem[9]=='BAD_SALE':
|
| 8207 |
if warehouseDbConnection.open:
|
8207 |
if warehouseDbConnection.open:
|
| 8208 |
warehouseDbConnection.close()
|
8208 |
warehouseDbConnection.close()
|
| 8209 |
raise TransactionServiceException(313, "Trying to Scan Bad Inventory Serial Number:- " + serialNumber+" and Order Id:- "+str(order.id))
|
8209 |
raise TransactionServiceException(313, "Trying to Scan Bad Inventory Serial Number:- " + serialNumber+" and Order Id:- "+str(order.id))
|
| 8210 |
scanSql = "select * from scanNew where inventoryItemId =%d"%(invItem[0])
|
8210 |
scanSql = "select * from scanNew where inventoryItemId =%d order by id"%(invItem[0])
|
| 8211 |
whCursor.execute(scanSql)
|
8211 |
whCursor.execute(scanSql)
|
| 8212 |
scans = whCursor.fetchall()
|
8212 |
scans = whCursor.fetchall()
|
| 8213 |
if scans is None:
|
8213 |
if scans is None:
|
| 8214 |
if warehouseDbConnection.open:
|
8214 |
if warehouseDbConnection.open:
|
| 8215 |
warehouseDbConnection.close()
|
8215 |
warehouseDbConnection.close()
|
| Line 8254... |
Line 8254... |
| 8254 |
if warehouseDbConnection.open:
|
8254 |
if warehouseDbConnection.open:
|
| 8255 |
warehouseDbConnection.close()
|
8255 |
warehouseDbConnection.close()
|
| 8256 |
raise TransactionServiceException(318, "Unsufficient Quantity with this item number " + itemNumbers[0]+" in Vendor Warehouse Id- "+str(warehouse.id)+" Order Id:- "+str(order.id))
|
8256 |
raise TransactionServiceException(318, "Unsufficient Quantity with this item number " + itemNumbers[0]+" in Vendor Warehouse Id- "+str(warehouse.id)+" Order Id:- "+str(order.id))
|
| 8257 |
|
8257 |
|
| 8258 |
for invItem in invItems:
|
8258 |
for invItem in invItems:
|
| 8259 |
scanSql = "select * from scanNew where inventoryItemId =%d"%(invItem[0])
|
8259 |
scanSql = "select * from scanNew where inventoryItemId =%d order by id"%(invItem[0])
|
| 8260 |
whCursor.execute(scanSql)
|
8260 |
whCursor.execute(scanSql)
|
| 8261 |
scans = whCursor.fetchall()
|
8261 |
scans = whCursor.fetchall()
|
| 8262 |
|
8262 |
|
| 8263 |
if scans is None:
|
8263 |
if scans is None:
|
| 8264 |
if warehouseDbConnection.open:
|
8264 |
if warehouseDbConnection.open:
|
| Line 8336... |
Line 8336... |
| 8336 |
if invItem[9]!='MARKED_BAD' or invItem[9]!='DOA_IN' or invItem[9]!='DOA_REJECTED' or invItem[9]!='SALE_RET_UNUSABLE':
|
8336 |
if invItem[9]!='MARKED_BAD' or invItem[9]!='DOA_IN' or invItem[9]!='DOA_REJECTED' or invItem[9]!='SALE_RET_UNUSABLE':
|
| 8337 |
if warehouseDbConnection.open:
|
8337 |
if warehouseDbConnection.open:
|
| 8338 |
warehouseDbConnection.close()
|
8338 |
warehouseDbConnection.close()
|
| 8339 |
raise TransactionServiceException(110, "Trying to Scan Good Inventory Serial Number:- " + serialNumber+" and Order Id:- "+str(order.id))
|
8339 |
raise TransactionServiceException(110, "Trying to Scan Good Inventory Serial Number:- " + serialNumber+" and Order Id:- "+str(order.id))
|
| 8340 |
|
8340 |
|
| 8341 |
scanSql = "select * from scanNew where inventoryItemId =%d"%(invItem[0])
|
8341 |
scanSql = "select * from scanNew where inventoryItemId =%d order by id"%(invItem[0])
|
| 8342 |
whCursor.execute(scanSql)
|
8342 |
whCursor.execute(scanSql)
|
| 8343 |
scans = whCursor.fetchall()
|
8343 |
scans = whCursor.fetchall()
|
| 8344 |
if scans is None:
|
8344 |
if scans is None:
|
| 8345 |
if warehouseDbConnection.open:
|
8345 |
if warehouseDbConnection.open:
|
| 8346 |
warehouseDbConnection.close()
|
8346 |
warehouseDbConnection.close()
|
| Line 8384... |
Line 8384... |
| 8384 |
if warehouseDbConnection.open:
|
8384 |
if warehouseDbConnection.open:
|
| 8385 |
warehouseDbConnection.close()
|
8385 |
warehouseDbConnection.close()
|
| 8386 |
raise TransactionServiceException(110, "Unsufficient Quantity with this item number " + itemNumbers[0]+" in Vendor Warehouse Id- "+str(warehouse.id)+" Order Id:- "+str(order.id))
|
8386 |
raise TransactionServiceException(110, "Unsufficient Quantity with this item number " + itemNumbers[0]+" in Vendor Warehouse Id- "+str(warehouse.id)+" Order Id:- "+str(order.id))
|
| 8387 |
|
8387 |
|
| 8388 |
for invItem in invItems:
|
8388 |
for invItem in invItems:
|
| 8389 |
scanSql = "select * from scanNew where inventoryItemId =%d"%(invItem[0])
|
8389 |
scanSql = "select * from scanNew where inventoryItemId =%d order by id"%(invItem[0])
|
| 8390 |
whCursor.execute(scanSql)
|
8390 |
whCursor.execute(scanSql)
|
| 8391 |
scans = whCursor.fetchall()
|
8391 |
scans = whCursor.fetchall()
|
| 8392 |
|
8392 |
|
| 8393 |
if scans is None:
|
8393 |
if scans is None:
|
| 8394 |
if warehouseDbConnection.open:
|
8394 |
if warehouseDbConnection.open:
|