| 6908 |
rajveer |
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.DataAccessors import move_orders_to_correct_warehouse
|
|
|
8 |
from shop2020.model.v1.order.impl.DataService import InsuranceDetailForOrder
|
|
|
9 |
import xlwt
|
|
|
10 |
from shop2020.utils import EmailAttachmentSender
|
|
|
11 |
from shop2020.utils.EmailAttachmentSender import get_attachment_part
|
| 6909 |
rajveer |
12 |
from shop2020.thriftpy.model.v1.order.ttypes import OrderStatus
|
| 6908 |
rajveer |
13 |
|
|
|
14 |
|
|
|
15 |
def main():
|
|
|
16 |
DataService.initialize()
|
|
|
17 |
todate = datetime.now()
|
|
|
18 |
todate = todate-timedelta(days = 10)
|
|
|
19 |
insurances = InsuranceDetailForOrder.query.filter(InsuranceDetailForOrder.isDeclared == False).filter(InsuranceDetailForOrder.startDate >= todate).all()
|
|
|
20 |
if not insurances:
|
|
|
21 |
return
|
|
|
22 |
|
|
|
23 |
wbk = xlwt.Workbook()
|
|
|
24 |
sheet = wbk.add_sheet('main')
|
|
|
25 |
|
| 6941 |
rajveer |
26 |
date_style = xlwt.XFStyle()
|
|
|
27 |
date_style.num_format_str = "D/M/YY"
|
|
|
28 |
|
| 6908 |
rajveer |
29 |
heading_xf = xlwt.easyxf('font: bold on; align: wrap on, vert centre, horiz center')
|
|
|
30 |
sheet.set_panes_frozen(True)
|
|
|
31 |
sheet.set_horz_split_pos(1)
|
|
|
32 |
sheet.set_remove_splits(True)
|
|
|
33 |
|
|
|
34 |
excel_integer_format = '0'
|
|
|
35 |
integer_style = xlwt.XFStyle()
|
|
|
36 |
integer_style.num_format_str = excel_integer_format
|
|
|
37 |
|
|
|
38 |
sheet.write(0, 0, "Riskstartdate", heading_xf)
|
|
|
39 |
sheet.write(0, 1, "StoreId", heading_xf)
|
|
|
40 |
sheet.write(0, 2, "SystemInvoiceNumber", heading_xf)
|
|
|
41 |
sheet.write(0, 3, "CustomerName", heading_xf)
|
|
|
42 |
sheet.write(0, 4, "Type", heading_xf)
|
|
|
43 |
sheet.write(0, 5, "Make", heading_xf)
|
|
|
44 |
sheet.write(0, 6, "Model", heading_xf)
|
|
|
45 |
sheet.write(0, 7, "EquipmentIdentificationNumber", heading_xf)
|
|
|
46 |
sheet.write(0, 8, "Qty", heading_xf)
|
|
|
47 |
sheet.write(0, 9, "Rate", heading_xf)
|
|
|
48 |
sheet.write(0, 10, "TaxAmount", heading_xf)
|
|
|
49 |
sheet.write(0, 11, "NetSales", heading_xf)
|
|
|
50 |
sheet.write(0, 12, "FatherName", heading_xf)
|
|
|
51 |
sheet.write(0, 13, "Birthdate", heading_xf)
|
|
|
52 |
sheet.write(0, 14, "SystemInvoiceDate.", heading_xf)
|
|
|
53 |
sheet.write(0, 15, "OrderId", heading_xf)
|
|
|
54 |
sheet.write(0, 16, "OtherDetails3", heading_xf)
|
|
|
55 |
|
|
|
56 |
xstr = lambda s: s or ""
|
|
|
57 |
|
|
|
58 |
i = 1
|
|
|
59 |
for insurance in insurances:
|
|
|
60 |
order = insurance.order
|
| 6909 |
rajveer |
61 |
if order.status != OrderStatus.DELIVERY_SUCCESS:
|
|
|
62 |
continue
|
| 6908 |
rajveer |
63 |
line = order.lineitems[0]
|
|
|
64 |
insurance.isDeclared = True
|
|
|
65 |
|
| 6941 |
rajveer |
66 |
sheet.write(i, 0, insurance.startDate, date_style)
|
| 6908 |
rajveer |
67 |
sheet.write(i, 1, '')
|
|
|
68 |
sheet.write(i, 2, order.invoice_number)
|
|
|
69 |
sheet.write(i, 3, order.customer_name)
|
|
|
70 |
sheet.write(i, 4, 'Mobile Phones')
|
|
|
71 |
sheet.write(i, 5, line.brand)
|
|
|
72 |
sheet.write(i, 6, xstr(line.model_name) + " " + xstr(line.model_number))
|
|
|
73 |
sheet.write(i, 7, line.serial_number)
|
|
|
74 |
sheet.write(i, 8, line.quantity)
|
|
|
75 |
sheet.write(i, 9, line.unit_price)
|
|
|
76 |
sheet.write(i, 10, "0")
|
|
|
77 |
sheet.write(i, 11, line.total_price)
|
|
|
78 |
sheet.write(i, 12, insurance.guardianName)
|
|
|
79 |
sheet.write(i, 13, insurance.dob)
|
| 6941 |
rajveer |
80 |
sheet.write(i, 14, order.billing_timestamp, date_style)
|
| 6908 |
rajveer |
81 |
sheet.write(i, 15, order.id)
|
|
|
82 |
sheet.write(i, 16, '')
|
|
|
83 |
i = i + 1
|
|
|
84 |
|
|
|
85 |
|
|
|
86 |
session.commit()
|
|
|
87 |
|
|
|
88 |
today = date.today()
|
|
|
89 |
datestr = str(today.year) + "-" + str(today.month) + "-" + str(today.day)
|
|
|
90 |
filename = "/tmp/insurance-" + datestr + ".xls"
|
|
|
91 |
wbk.save(filename)
|
|
|
92 |
EmailAttachmentSender.mail("cnc.center@shop2020.in", "5h0p2o2o", ["rajveer.singh@shop2020.in","anupam.singh@shop2020.in"], "Insurance Details for date ", "Please find attached insurance details for today.", [get_attachment_part(filename)], [], [])
|
|
|
93 |
|
|
|
94 |
if __name__ == '__main__':
|
|
|
95 |
main()
|
|
|
96 |
|