Subversion Repositories SmartDukaan

Rev

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

Rev 3477 Rev 4077
Line 136... Line 136...
136 
    sheet = workbook.sheet_by_index(0)
 136 
    sheet = workbook.sheet_by_index(0)
137 
    num_rows = sheet.nrows
 137 
    num_rows = sheet.nrows
138 
    delivered_orders = {}
 138 
    delivered_orders = {}
139 
    returned_orders = {}
 139 
    returned_orders = {}
140 
    for rownum in range(1, num_rows):
 140 
    for rownum in range(1, num_rows):
141 
        unused_customer_code, awb, unused_ref_no, timeval, date, unused_status, receiver, reason_for_return = sheet.row_values(rownum)[0:8]
 141 
        unused_customer_code, awb, unused_ref_no, timeval, date, status, receiver, reason_for_return = sheet.row_values(rownum)[0:8]
142 
        delivery_date = str(get_py_datetime(date, timeval))
 142 
        delivery_date = str(get_py_datetime(date, timeval))
143 
        if receiver: #TODO: Use status for this check
 - 
 
144 
            delivered_orders[awb] = delivery_date + "|" +  receiver
 - 
 
145 
        else:
 143 
        if 'Rto' in status:
146 
            returned_orders[awb] = delivery_date + "|" + reason_for_return
 144 
            returned_orders[awb] = delivery_date + "|" + reason_for_return
- 
 
 145 
        else:
- 
 
 146 
            delivered_orders[awb] = delivery_date + "|" +  receiver
147
147
148 
    print "Delivered Orders:"
 148 
    print "Delivered Orders:"
149 
    print delivered_orders
 149 
    print delivered_orders
150
150
151 
    print "Returned Orders:"
 151 
    print "Returned Orders:"