Subversion Repositories SmartDukaan

#!/usr/bin/python

import time

import datetime

import optparse

import sys

import csv

import xlrd

import traceback

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

    import os

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

from shop2020.clients.TransactionClient import TransactionClient

from shop2020.clients.HelperClient import HelperClient

from shop2020.thriftpy.model.v1.order.ttypes import TransactionServiceException

from_user = 'help@saholic.com'

from_pwd = '5h0p2o2o'

to = ['rajveer.singh@shop2020.in']

def create_emails(filename):

    print "Reading order list from:" + filename

    workbook = xlrd.open_workbook(filename)

    sheet = workbook.sheet_by_index(0)

    num_rows = sheet.nrows

    picked_up_orders = {}

    txnClient = TransactionClient().get_client()

    for rownum in range(2, num_rows):

        order_id, product_name = sheet.row_values(rownum)[0:2]

	try:

            order = txnClient.getOrder(int(order_id))

            picked_up_orders[int(order_id)] = [str(product_name), order]

            subject = "Delay in delivery of your order " + str(order.id)

            body = "Dear " + order.customer_name + ",<br/><br/>Thanks for shopping at www.saholic.com.<br/><br/>In reference to your order ID " + str(order.id)  + " for " + str(product_name) + " placed with us, we would like to inform you that due to some unforeseen circumstances at our warehouse, delivery would be delayed by a day or two.<br/><br/>We deeply regret the same.<br/><br/>Thanks & Regards<br/>Saholic Team "

            try:

                helper_client = HelperClient().get_client()

                helper_client.saveUserEmailForSending([order.customer_email], "", subject, body, str(order.id), "TransactionInfo", [], [])

            except Exception as e:

                print order.id

        except TransactionServiceException as tex:

            print tex.message

    print "Picked up Orders:"

    print picked_up_orders

def main():

    parser = optparse.OptionParser()

    parser.add_option("-f", "--file", dest="filename",

                   default="xxx.xls", type="string",

                   help="The FILE this report is for",

                   metavar="FILE")

    (options, args) = parser.parse_args()

    if len(args) != 0:

        parser.error("You've supplied extra arguments. Are you sure you want to run this program?")

    create_emails(options.filename)

if __name__ == '__main__':

    main()