Subversion Repositories SmartDukaan

Rev

Rev 9876 | Details | Compare with Previous | Last modification | View Log | RSS feed

Rev Author Line No. Line
9575 kshitij.so 1 
#!/usr/bin/python
2 
 
3 
from elixir import *
4 
from datetime import datetime, timedelta, date
5 
import sys
6 
from shop2020.model.v1.order.impl import DataService
7 
from shop2020.model.v1.order.impl.DataService  import Order, DataInsuranceDetailForOrder
8 
import xlwt
9 
from shop2020.utils import EmailAttachmentSender
10 
from shop2020.utils.EmailAttachmentSender import get_attachment_part
11 
from shop2020.thriftpy.model.v1.order.ttypes import OrderStatus
12 
from shop2020.config.client.ConfigClient import ConfigClient
13 
from shop2020.clients.UserClient import UserClient
14 
 
15 
config_client = ConfigClient()
16 
host = config_client.get_property('transaction_service_db_hostname')
17 
DataService.initialize(db_hostname=host)
18 
 
19 
def deliveredOrders():
9820 kshitij.so 20 
    todate = datetime.now()-timedelta(days = 10)
9575 kshitij.so 21 
    dataInsurances = DataInsuranceDetailForOrder.query.filter(DataInsuranceDetailForOrder.isDeclared==False).filter(DataInsuranceDetailForOrder.startDate >= todate).all()
22 
    if not dataInsurances:
23 
        return
24 
    xstr = lambda s: s or ""
25 
    i=1
9820 kshitij.so 26 
    wbk = xlwt.Workbook(encoding="UTF-8")
9575 kshitij.so 27 
    sheet = wbk.add_sheet('OneAssist Data')
28 
    date_style = xlwt.XFStyle()
29 
    date_style.num_format_str = "D/M/YY"
30 
 
31 
    heading_xf = xlwt.easyxf('font: bold on; align: wrap on, vert centre, horiz center')
32 
    sheet.set_panes_frozen(True)
33 
    sheet.set_horz_split_pos(1)
34 
    sheet.set_remove_splits(True)
35 
 
36 
    excel_integer_format = '0'
37 
    integer_style = xlwt.XFStyle()
38 
    integer_style.num_format_str = excel_integer_format
39 
 
40 
    sheet.write(0, 0, "Record Type", heading_xf)
41 
    sheet.write(0, 1, "account no", heading_xf)
42 
    sheet.write(0, 2, "Mem Start Date", heading_xf)
43 
    sheet.write(0, 3, "Membership Type", heading_xf)
44 
    sheet.write(0, 4, "Level 1", heading_xf)
45 
    sheet.write(0, 5, "Level 2", heading_xf)
46 
    sheet.write(0, 6, "Level 3", heading_xf)
47 
    sheet.write(0, 7, "Plan_id", heading_xf)
48 
    sheet.write(0, 8, "PROMOCODE", heading_xf)
49 
    sheet.write(0, 9, "Payment Mode", heading_xf)
50 
    sheet.write(0, 10, "Credit Card No", heading_xf)
51 
    sheet.write(0, 11, "Expiry Month", heading_xf)
52 
    sheet.write(0, 12, "Expiry Year", heading_xf)
53 
    sheet.write(0, 13, "Name on Card", heading_xf)
9820 kshitij.so 54 
    sheet.write(0, 14, "Level", heading_xf)
9575 kshitij.so 55 
    sheet.write(0, 15, "Issuer Bank", heading_xf)
56 
    sheet.write(0, 16, "Card Brand", heading_xf)
57 
    sheet.write(0, 17, "Address Line 1", heading_xf)
58 
    sheet.write(0, 18, "Address Line 2", heading_xf)
59 
    sheet.write(0, 19, "landmark", heading_xf)
60 
    sheet.write(0, 20, "City", heading_xf)
61 
    sheet.write(0, 21, "State", heading_xf)
62 
    sheet.write(0, 22, "Pincode", heading_xf)
9803 kshitij.so 63 
    sheet.write(0, 23, "Primary Cust First Name ", heading_xf)
9575 kshitij.so 64 
    sheet.write(0, 24, "Middle Name", heading_xf)
65 
    sheet.write(0, 25, "Last Name", heading_xf)
66 
    sheet.write(0, 26, "DOB", heading_xf)
67 
    sheet.write(0, 27, "Gender", heading_xf)
68 
    sheet.write(0, 28, "email id", heading_xf)
69 
    sheet.write(0, 29, "mobile 1", heading_xf)
70 
    sheet.write(0, 30, "mobile 2", heading_xf)
71 
    sheet.write(0, 31, "OS", heading_xf)
9803 kshitij.so 72 
    sheet.write(0, 32, "PANNO", heading_xf)
73 
    sheet.write(0, 33, "Relationship", heading_xf)
74 
    sheet.write(0, 34, "Secondary Cust First Name", heading_xf)
75 
    sheet.write(0, 35, "Middle Name", heading_xf)
76 
    sheet.write(0, 36, "Last Name", heading_xf)
77 
    sheet.write(0, 37, "DOB", heading_xf)
78 
    sheet.write(0, 38, "Gender", heading_xf)
79 
    sheet.write(0, 39, "email id", heading_xf)
80 
    sheet.write(0, 40, "mobile 1", heading_xf)
81 
    sheet.write(0, 41, "mobile 2", heading_xf)
82 
    sheet.write(0, 42, "OS", heading_xf)
83 
    sheet.write(0, 43, "PANNO", heading_xf)
84 
    sheet.write(0, 44, "A/c No", heading_xf)
85 
    sheet.write(0, 45, "A/c Type", heading_xf)
86 
    sheet.write(0, 46, "A/c holder name", heading_xf)
87 
    sheet.write(0, 47, "Branch name", heading_xf)
88 
    sheet.write(0, 48, "MICR Code", heading_xf)
89 
    sheet.write(0, 49, "IFSC Code", heading_xf)
90 
    sheet.write(0, 50, "Cheque No", heading_xf)
91 
    sheet.write(0, 51, "Cheque Date", heading_xf)
92 
    sheet.write(0, 52, "Bank Name", heading_xf)
93 
    sheet.write(0, 53, "Cheque Status", heading_xf)
94 
    sheet.write(0, 54, "A/c No", heading_xf)
95 
    sheet.write(0, 55, "A/c Type", heading_xf)
96 
    sheet.write(0, 56, "A/c holder name", heading_xf)
97 
    sheet.write(0, 57, "Branch name", heading_xf)
98 
    sheet.write(0, 58, "MICR Code", heading_xf)
99 
    sheet.write(0, 59, "IFSC Code", heading_xf)
100 
    sheet.write(0, 60, "Cheque No.", heading_xf)
101 
    sheet.write(0, 61, "Cheque Date", heading_xf)
102 
    sheet.write(0, 62, "Bank Name", heading_xf)
103 
    sheet.write(0, 63, "Cheque Status", heading_xf)
104 
    sheet.write(0, 64, "ECS Start Date", heading_xf)
105 
    sheet.write(0, 65, "ECS End Date", heading_xf)
9575 kshitij.so 106 
 
107 
 
108 
    for dataInsurance in dataInsurances:
109 
        order = dataInsurance.order
110 
        if order.status != OrderStatus.DELIVERY_SUCCESS:
111 
            continue
112 
        dataInsurance.isDeclared = True
113 
        sheet.write(i, 0, 'D')
114 
        sheet.write(i, 1, '1')
115 
        sheet.write(i, 2, dataInsurance.startDate, date_style)
116 
        sheet.write(i, 3, 'S')
9876 kshitij.so 117 
        sheet.write(i, 7, '57')
9575 kshitij.so 118 
        sheet.write(i, 17, xstr(order.customer_address1))
119 
        sheet.write(i, 18, xstr(order.customer_address2))
120 
        sheet.write(i, 20, order.customer_city)
121 
        sheet.write(i, 21, order.customer_state)
122 
        sheet.write(i, 22, order.customer_pincode)
9820 kshitij.so 123 
        sheet.write(i, 23, order.customer_name)
9575 kshitij.so 124 
        sheet.write(i, 28, order.customer_email)
125 
        sheet.write(i, 29, order.customer_mobilenumber)
126 
        sheet.write(i, 31, 'android')
127 
        i+=1
128 
 
129 
    session.commit()
130 
 
131 
    today = date.today()
132 
    datestr = str(today.day) + "-" + str(today.month) + "-" + str(today.year)
9803 kshitij.so 133 
    filename = "/tmp/mobile-assist-" + datestr + ".xls"
9575 kshitij.so 134 
    wbk.save(filename)
20172 aman.kumar 135 
    EmailAttachmentSender.mail("build@shop2020.in", "cafe@nes", ["retail-ops@oneassist.in", "abhay.chandak@oneassist.in"], "Mobile Assist data for date " + datestr, "Please find attached details for today.", [get_attachment_part(filename)], ["rajneesh.arora@saholic.com","khushal.bhatia@saholic.com","rajveer.singh@saholic.com","kshitij.sood@saholic.com","pramit.singh@saholic.com"], [])
9803 kshitij.so 136 
 
9575 kshitij.so 137 
 
138 
def returnOrders():
9609 kshitij.so 139 
    todate = datetime.now()-timedelta(days = 2)
9575 kshitij.so 140 
    orders = Order.query.filter(Order.dataProtectionInsurer > 0).filter(Order.received_return_timestamp >= todate).all()
141 
    if not orders:
142 
        return
143 
    wbk = xlwt.Workbook()
144 
    sheet = wbk.add_sheet('OneAssist Return')
145 
 
146 
    date_style = xlwt.XFStyle()
147 
    date_style.num_format_str = "D/M/YY"
148 
 
149 
    heading_xf = xlwt.easyxf('font: bold on; align: wrap on, vert centre, horiz center')
150 
    sheet.set_panes_frozen(True)
151 
    sheet.set_horz_split_pos(1)
152 
    sheet.set_remove_splits(True)
153 
 
154 
    excel_integer_format = '0'
155 
    integer_style = xlwt.XFStyle()
156 
    integer_style.num_format_str = excel_integer_format
157 
 
158 
    sheet.write(0, 0, "Customer Name", heading_xf)
159 
    sheet.write(0, 1, "Mobile Number", heading_xf)
160 
    sheet.write(0, 2, "Reason", heading_xf)
161 
 
162 
    i=1
163 
 
164 
    for order in orders:
165 
        dataInsurance = order.dataInsuranceDetails[0]
166 
        if not (dataInsurance.startDate or dataInsurance.expiryDate) or dataInsurance.expiryDate < datetime.now():
167 
            continue
168 
        dataInsurance.expiryDate = order.received_return_timestamp
9820 kshitij.so 169 
        sheet.write(i, 0,order.customer_name)
9575 kshitij.so 170 
        sheet.write(i, 1, order.customer_mobilenumber)
171 
        sheet.write(i, 2, '')
172 
        i+=1
173 
 
174 
    session.commit()
175 
    today = date.today()
176 
    datestr = str(today.day) + "-" + str(today.month) + "-" + str(today.year)
9803 kshitij.so 177 
    filename = "/tmp/mobile-assist-return" + datestr + ".xls"
9575 kshitij.so 178 
    wbk.save(filename)
179 
 
180 
 
181 
 
182 
def main():
183 
    deliveredOrders()
9820 kshitij.so 184 
    #returnOrders()
9575 kshitij.so 185 
 
186 
if __name__ == '__main__':
9820 kshitij.so 187 
    main()