| 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():
|
|
|
20 |
todate = datetime.datetime.now()-timedelta(days = 10)
|
|
|
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
|
|
|
26 |
wbk = xlwt.Workbook()
|
|
|
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)
|
|
|
54 |
sheet.write(0, 14, "Card Level", heading_xf)
|
|
|
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)
|
|
|
63 |
sheet.write(0, 23, "Primary Cust First Name", heading_xf)
|
|
|
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)
|
|
|
72 |
|
|
|
73 |
|
|
|
74 |
for dataInsurance in dataInsurances:
|
|
|
75 |
order = dataInsurance.order
|
|
|
76 |
if order.status != OrderStatus.DELIVERY_SUCCESS:
|
|
|
77 |
continue
|
| 9609 |
kshitij.so |
78 |
client = UserClient().get_client()
|
| 9575 |
kshitij.so |
79 |
user = client.getUserById(order.customer_id)
|
|
|
80 |
dataInsurance.isDeclared = True
|
|
|
81 |
sheet.write(i, 0, 'D')
|
|
|
82 |
sheet.write(i, 1, '1')
|
|
|
83 |
sheet.write(i, 2, dataInsurance.startDate, date_style)
|
|
|
84 |
sheet.write(i, 3, 'S')
|
|
|
85 |
sheet.write(i, 7, '3')
|
|
|
86 |
sheet.write(i, 17, xstr(order.customer_address1))
|
|
|
87 |
sheet.write(i, 18, xstr(order.customer_address2))
|
|
|
88 |
sheet.write(i, 20, order.customer_city)
|
|
|
89 |
sheet.write(i, 21, order.customer_state)
|
|
|
90 |
sheet.write(i, 22, order.customer_pincode)
|
|
|
91 |
sheet.write(i, 23, user.name)
|
|
|
92 |
sheet.write(i, 28, order.customer_email)
|
|
|
93 |
sheet.write(i, 29, order.customer_mobilenumber)
|
|
|
94 |
sheet.write(i, 31, 'android')
|
|
|
95 |
i+=1
|
|
|
96 |
|
|
|
97 |
session.commit()
|
|
|
98 |
|
|
|
99 |
today = date.today()
|
|
|
100 |
datestr = str(today.day) + "-" + str(today.month) + "-" + str(today.year)
|
|
|
101 |
filename = "/tmp/data-insurance-" + datestr + ".xls"
|
|
|
102 |
wbk.save(filename)
|
|
|
103 |
|
|
|
104 |
def returnOrders():
|
| 9609 |
kshitij.so |
105 |
todate = datetime.now()-timedelta(days = 2)
|
| 9575 |
kshitij.so |
106 |
orders = Order.query.filter(Order.dataProtectionInsurer > 0).filter(Order.received_return_timestamp >= todate).all()
|
|
|
107 |
if not orders:
|
|
|
108 |
return
|
|
|
109 |
wbk = xlwt.Workbook()
|
|
|
110 |
sheet = wbk.add_sheet('OneAssist Return')
|
|
|
111 |
|
|
|
112 |
date_style = xlwt.XFStyle()
|
|
|
113 |
date_style.num_format_str = "D/M/YY"
|
|
|
114 |
|
|
|
115 |
heading_xf = xlwt.easyxf('font: bold on; align: wrap on, vert centre, horiz center')
|
|
|
116 |
sheet.set_panes_frozen(True)
|
|
|
117 |
sheet.set_horz_split_pos(1)
|
|
|
118 |
sheet.set_remove_splits(True)
|
|
|
119 |
|
|
|
120 |
excel_integer_format = '0'
|
|
|
121 |
integer_style = xlwt.XFStyle()
|
|
|
122 |
integer_style.num_format_str = excel_integer_format
|
|
|
123 |
|
|
|
124 |
sheet.write(0, 0, "Customer Name", heading_xf)
|
|
|
125 |
sheet.write(0, 1, "Mobile Number", heading_xf)
|
|
|
126 |
sheet.write(0, 2, "Reason", heading_xf)
|
|
|
127 |
|
|
|
128 |
i=1
|
|
|
129 |
|
|
|
130 |
for order in orders:
|
|
|
131 |
dataInsurance = order.dataInsuranceDetails[0]
|
|
|
132 |
if not (dataInsurance.startDate or dataInsurance.expiryDate) or dataInsurance.expiryDate < datetime.now():
|
|
|
133 |
continue
|
|
|
134 |
client = UserClient.get_client()
|
|
|
135 |
user = client.getUserById(order.customer_id)
|
|
|
136 |
dataInsurance.expiryDate = order.received_return_timestamp
|
|
|
137 |
sheet.write(i, 0,user.name)
|
|
|
138 |
sheet.write(i, 1, order.customer_mobilenumber)
|
|
|
139 |
sheet.write(i, 2, '')
|
|
|
140 |
i+=1
|
|
|
141 |
|
|
|
142 |
session.commit()
|
|
|
143 |
today = date.today()
|
|
|
144 |
datestr = str(today.day) + "-" + str(today.month) + "-" + str(today.year)
|
|
|
145 |
filename = "/tmp/data-insurance-return" + datestr + ".xls"
|
|
|
146 |
wbk.save(filename)
|
|
|
147 |
|
|
|
148 |
|
|
|
149 |
|
|
|
150 |
def main():
|
|
|
151 |
deliveredOrders()
|
|
|
152 |
returnOrders()
|
|
|
153 |
|
|
|
154 |
if __name__ == '__main__':
|
|
|
155 |
main()
|