Subversion Repositories SmartDukaan

Rev

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

Rev 1263 Rev 1265
Line 101... Line 101...
101 
    sheet = workbook.sheet_by_index(0)
 101 
    sheet = workbook.sheet_by_index(0)
102 
    num_rows = sheet.nrows
 102 
    num_rows = sheet.nrows
103 
    delivered_orders = {}
 103 
    delivered_orders = {}
104 
    returned_orders = {}
 104 
    returned_orders = {}
105 
    for rownum in range(1, num_rows):
 105 
    for rownum in range(1, num_rows):
106 
        unused_customer_code, awb, time, date, unused_status, receiver, reason_for_return = sheet.row_values(rownum)[0:7]
 106 
        unused_customer_code, awb, timeval, date, unused_status, receiver, reason_for_return = sheet.row_values(rownum)[0:7]
107 
        delivery_date = str(get_py_datetime(date, time))
 107 
        delivery_date = str(get_py_datetime(date, timeval))
108 
        if receiver: #TODO: Use status for this check
 108 
        if receiver: #TODO: Use status for this check
109 
            delivered_orders[awb] = delivery_date + "|" +  receiver
 109 
            delivered_orders[awb] = delivery_date + "|" +  receiver
110 
        else:
 110 
        else:
111 
            returned_orders[awb] = delivery_date + "|" + reason_for_return
 111 
            returned_orders[awb] = delivery_date + "|" + reason_for_return
112
112
Line 122... Line 122...
122 
    workbook = xlrd.open_workbook(filename)
 122 
    workbook = xlrd.open_workbook(filename)
123 
    sheet = workbook.sheet_by_index(0)
 123 
    sheet = workbook.sheet_by_index(0)
124 
    num_rows = sheet.nrows
 124 
    num_rows = sheet.nrows
125 
    undelivered_orders = {}
 125 
    undelivered_orders = {}
126 
    for rownum in range(1, num_rows):
 126 
    for rownum in range(1, num_rows):
127 
        unused_cusotmer_code, awb, reason, time, date = sheet.row_values(rownum)[0:5]
 127 
        unused_cusotmer_code, awb, reason, timeval, date = sheet.row_values(rownum)[0:5]
128 
        unused_status_date = str(get_py_datetime(date, time))
 128 
        unused_status_date = str(get_py_datetime(date, timeval))
129 
        undelivered_orders[awb] = reason
 129 
        undelivered_orders[awb] = reason
130
130
131 
    print "Undelivered Orders"
 131 
    print "Undelivered Orders"
132 
    print undelivered_orders
 132 
    print undelivered_orders
133
133