Subversion Repositories SmartDukaan

#!/usr/bin/python 

'''

Created on 13-Apr-2011

@author: ankur

'''

import os

import sys

if __name__ == '__main__' and __package__ is None:

    sys.path.insert(0, os.getcwd())

from shop2020.utils.Utils import to_py_date, to_java_date

from shop2020.utils.EmailAttachmentSender import get_attachment_part, mail

from shop2020.clients.TransactionClient import TransactionClient

import csv

from shop2020.clients.LogisticsClient import LogisticsClient

from_user = 'cnc.center@shop2020.in'

from_pwd = '5h0p2o2o'

to = 'ankur.singhal@shop2020.in'

def get_undelivered_orders(providerId = -1, warehouseId = -1):

    txnClient = TransactionClient().get_client()

    undeliveredOrders = txnClient.getUndeliveredOrders(providerId, warehouseId)

    return undeliveredOrders

def generate_undelivered_orders_report(orders):

    filename = os.getenv("HOME") + os.sep + "UndeliveredOrders.csv"

    logistics_client = LogisticsClient().get_client()

    providers = logistics_client.getAllProviders()

    writer = csv.writer(open(filename, "wb"), delimiter=',', quoting=csv.QUOTE_NONE)

    writer.writerow(['AWB No', 'Shipping Date', 'Courier Name', 'Delivery Location', 'Non-delivery Reason'])

    provider = None

    for order in orders:

        for p in providers:

            if p.id == order.logistics_provider_id:

                provider=p

                break

        writer.writerow([order.airwaybill_no, to_py_date(order.shipping_timestamp), provider.name, order.customer_city, order.statusDescription])

    return filename

def main():

    orders = get_undelivered_orders()

    filename = generate_undelivered_orders_report(orders)

    print "Generated undelivered orders report to:" + filename

    part = get_attachment_part(filename)

    mail(from_user, from_pwd, to, "Undelivered orders", "This is a system generated email.Please don't reply to it.", part)

if __name__ == '__main__':

    main()