Subversion Repositories SmartDukaan

Rev

Rev 13609 | Rev 13632 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 13609 Rev 13627
Line 8398... Line 8398...
8398
8398
8399 
                            lineitem.transfer_price = invItem[13]
 8399 
                            lineitem.transfer_price = invItem[13]
8400 
                            lineitem.nlc = invItem[14]
 8400 
                            lineitem.nlc = invItem[14]
8401 
                            order.vendorId = invItem[12]
 8401 
                            order.vendorId = invItem[12]
8402 
                    else:
 8402 
                    else:
8403 
                        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)
 8403 
                        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 i.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)
8404 
                        whCursor.execute(invItemSql)
 8404 
                        whCursor.execute(invItemSql)
8405 
                        invItems = whCursor.fetchall()
 8405 
                        invItems = whCursor.fetchall()
8406 
                        if invItems is None:
 8406 
                        if invItems is None:
8407 
                            if warehouseDbConnection.open:
 8407 
                            if warehouseDbConnection.open:
8408 
                                warehouseDbConnection.close()
 8408 
                                warehouseDbConnection.close()