| 2315 |
chandransh |
1 |
#!/usr/bin/python
|
|
|
2 |
|
|
|
3 |
'''
|
|
|
4 |
Created on 23-Jun-2011
|
|
|
5 |
|
|
|
6 |
@author: Chandranshu
|
|
|
7 |
'''
|
|
|
8 |
import sys
|
|
|
9 |
import os
|
|
|
10 |
import csv
|
|
|
11 |
|
|
|
12 |
if __name__ == '__main__' and __package__ is None:
|
|
|
13 |
sys.path.insert(0, os.getcwd())
|
|
|
14 |
|
|
|
15 |
from shop2020.model.v1.order.impl import DataAccessors, DataService
|
|
|
16 |
|
|
|
17 |
def main():
|
|
|
18 |
filename = os.getenv("HOME") + os.sep + "ExpectedAndActualDeliveryReport.csv"
|
|
|
19 |
writer = csv.writer(open(filename, "wb"), delimiter=',', quoting=csv.QUOTE_NONE)
|
|
|
20 |
writer.writerow(["Order ID", "Customer Name", "Pin Code", "State", "AWB No", "Order Date", "Expected Date of Delivery", "Delivery Date"])
|
|
|
21 |
DataService.initialize(echoOn=True)
|
|
|
22 |
orders = DataAccessors.get_valid_orders(0)
|
|
|
23 |
orders.reverse()
|
|
|
24 |
for order in orders:
|
|
|
25 |
writer.writerow([order.id, order.customer_name, order.customer_pincode, order.customer_state, order.airwaybill_no, order.created_timestamp, order.expected_delivery_time, order.delivery_timestamp])
|
|
|
26 |
|
|
|
27 |
if __name__ == '__main__':
|
|
|
28 |
main()
|