Subversion Repositories SmartDukaan

#!/usr/bin/python

'''
Created on 23-Jun-2011

@author: Chandranshu
'''
import sys
import os
import csv

if __name__ == '__main__' and __package__ is None:
    sys.path.insert(0, os.getcwd())

from shop2020.model.v1.order.impl import DataAccessors, DataService

def main():
    filename = os.getenv("HOME") + os.sep + "ExpectedAndActualDeliveryReport.csv"
    writer = csv.writer(open(filename, "wb"), delimiter=',', quoting=csv.QUOTE_NONE)
    writer.writerow(["Order ID", "Customer Name", "Pin Code", "State", "AWB No", "Order Date", "Expected Date of Delivery", "Delivery Date"])
    DataService.initialize(echoOn=True)
    orders = DataAccessors.get_valid_orders(0)
    orders.reverse()
    for order in orders:
        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])

if __name__ == '__main__':
    main()