Subversion Repositories SmartDukaan

Rev

Rev 4157 | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 4157 Rev 4176
Line 61... Line 61...
61
61
62 
    txn_client = TransactionClient().get_client()
 62 
    txn_client = TransactionClient().get_client()
63 
    item_wise_risky_orders = txn_client.getItemWiseRiskyOrdersCount()
 63 
    item_wise_risky_orders = txn_client.getItemWiseRiskyOrdersCount()
64
64
65 
    writer = csv.writer(open(args[0], "wb"), delimiter='\t', quoting=csv.QUOTE_MINIMAL)
 65 
    writer = csv.writer(open(args[0], "wb"), delimiter='\t', quoting=csv.QUOTE_MINIMAL)
66 
    writer.writerow(["Category", "Brand", "Model Name", "Model Number", "Color", "Pending Orders", "Minimum Stock Level", "Total Requirement", "Available", "Deficit", "Risky Orders", "Bare Minimum Reqd", "Action", "Estimated Business Days", "Remark"])
 66 
    writer.writerow(["Category", "Brand", "Model Name", "Model Number", "Color", "Pending Orders", "Minimum Stock Level", "Total Requirement", "Computed Availability", "Deficit", "Risky Orders", "Bare Minimum Reqd", "Actual Availability", "Action", "Estimated Business Days", "Remark"])
67 
    rowdata = []
 67 
    rowdata = []
68
68
69 
    for stock in stocks_for_items_with_pending_orders:
 69 
    for stock in stocks_for_items_with_pending_orders:
70 
        itemId = stock.itemId
 70 
        itemId = stock.itemId
71 
        item = inventory_client.getItem(itemId)
 71 
        item = inventory_client.getItem(itemId)
Line 81... Line 81...
81 
        available = stock.available
 81 
        available = stock.available
82 
        deficit = total_requirement - available
 82 
        deficit = total_requirement - available
83 
        risky_orders = item_wise_risky_orders.get(itemId) if item_wise_risky_orders.has_key(itemId) else 0
 83 
        risky_orders = item_wise_risky_orders.get(itemId) if item_wise_risky_orders.has_key(itemId) else 0
84 
        bare_minimum_required = risky_orders - available
 84 
        bare_minimum_required = risky_orders - available
85
85
86 
        rowdata.append((category, brand, model_name, model_number, color, pending_orders, min_stock_level, total_requirement, available, deficit, risky_orders, bare_minimum_required, '', '', ''))
 86 
        rowdata.append((category, brand, model_name, model_number, color, pending_orders, min_stock_level, total_requirement, available, deficit, risky_orders, bare_minimum_required, '', '', '', ''))
87
87
88 
    sorted_rowdata = sorted(rowdata, key=itemgetter(0,1,2,3,4))
 88 
    sorted_rowdata = sorted(rowdata, key=itemgetter(0,1,2,3,4))
89 
    writer.writerows(sorted_rowdata)
 89 
    writer.writerows(sorted_rowdata)
90 
 
 90 
 
91 
if __name__ == '__main__':
 91 
if __name__ == '__main__':