| Line 83... |
Line 83... |
| 83 |
delivered_orders, returned_orders = read_delivery_report(filename)
|
83 |
delivered_orders, returned_orders = read_delivery_report(filename)
|
| 84 |
if delivered_orders:
|
84 |
if delivered_orders:
|
| 85 |
update_delivered_orders(provider.id, delivered_orders)
|
85 |
update_delivered_orders(provider.id, delivered_orders)
|
| 86 |
if returned_orders:
|
86 |
if returned_orders:
|
| 87 |
update_returned_orders(provider.id, returned_orders)
|
87 |
update_returned_orders(provider.id, returned_orders)
|
| 88 |
|
88 |
try:
|
| - |
|
89 |
returned_orders_file = "/tmp/ReturnedOrders.csv"
|
| - |
|
90 |
print_rto_orders_report(returned_orders_file, returned_orders)
|
| - |
|
91 |
returned_orders_report = [get_attachment_part(returned_orders_file)]
|
| 89 |
mail(from_user, from_pwd, to,\
|
92 |
mail(from_user, from_pwd, to,\
|
| 90 |
"Returned Orders Report for " + provider.name,\
|
93 |
"Returned Orders Report for " + provider.name,\
|
| 91 |
"This is a system generated email.Please don't reply to it.",\
|
94 |
"This is a system generated email.Please don't reply to it.",\
|
| - |
|
95 |
[returned_orders_report])
|
| 92 |
[])
|
96 |
except:
|
| - |
|
97 |
print "Some issue sending the returned orders report"
|
| - |
|
98 |
traceback.print_exc()
|
| 93 |
except:
|
99 |
except:
|
| 94 |
print "Some issue sending the returned orders report"
|
100 |
print "Some issue while processing the returned orders"
|
| 95 |
traceback.print_exc()
|
101 |
traceback.print_exc()
|
| 96 |
finally:
|
102 |
finally:
|
| 97 |
os.remove(filename)
|
103 |
os.remove(filename)
|
| 98 |
|
104 |
|
| 99 |
def process_non_delivery_report(provider):
|
105 |
def process_non_delivery_report(provider):
|
| Line 224... |
Line 230... |
| 224 |
writer = csv.writer(open(filename, "wb"), delimiter=',', quoting=csv.QUOTE_NONE)
|
230 |
writer = csv.writer(open(filename, "wb"), delimiter=',', quoting=csv.QUOTE_NONE)
|
| 225 |
writer.writerow(['Order Id', 'AWB No', 'Shipping timestamp'])
|
231 |
writer.writerow(['Order Id', 'AWB No', 'Shipping timestamp'])
|
| 226 |
for order in orders:
|
232 |
for order in orders:
|
| 227 |
writer.writerow([order.id, order.airwaybill_no, to_py_date(order.shipping_timestamp)])
|
233 |
writer.writerow([order.id, order.airwaybill_no, to_py_date(order.shipping_timestamp)])
|
| 228 |
|
234 |
|
| - |
|
235 |
def print_rto_orders_report(filename, returned_orders):
|
| - |
|
236 |
writer = csv.writer(open(filename, "wb"), delimiter=',', quoting=csv.QUOTE_NONE)
|
| - |
|
237 |
writer.writerow(['AWB No', 'Return date', 'Reason'])
|
| - |
|
238 |
for awb, date_reason in returned_orders.iteritems():
|
| - |
|
239 |
date, reason = date_reason.split('|')
|
| - |
|
240 |
writer.writerow(awb, date, reason)
|
| - |
|
241 |
|
| 229 |
def todays_date_string():
|
242 |
def todays_date_string():
|
| 230 |
today_date = time.strftime("%d-%b-%Y")
|
243 |
today_date = time.strftime("%d-%b-%Y")
|
| 231 |
return '"' + today_date + '"'
|
244 |
return '"' + today_date + '"'
|
| 232 |
|
245 |
|
| 233 |
def get_py_datetime(date, timeval):
|
246 |
def get_py_datetime(date, timeval):
|