WebSVN – SmartDukaan – Diff – /trunk/PyProj/src/shop2020/model/v1/order/script/OneAssistData.py



config_client = ConfigClient()
host = config_client.get_property('transaction_service_db_hostname')
DataService.initialize(db_hostname=host)
 
def deliveredOrders():
    todate = datetime.now()-timedelta(days = 10)
    dataInsurances = DataInsuranceDetailForOrder.query.filter(DataInsuranceDetailForOrder.isDeclared==False).filter(DataInsuranceDetailForOrder.startDate >= todate).all()
    if not dataInsurances:
        return
    xstr = lambda s: s or ""
    i=1
    wbk = xlwt.Workbook(encoding="UTF-8")
    sheet = wbk.add_sheet('OneAssist Data')
    date_style = xlwt.XFStyle()
    date_style.num_format_str = "D/M/YY"
    
    heading_xf = xlwt.easyxf('font: bold on; align: wrap on, vert centre, horiz center')

    sheet.write(0, 9, "Payment Mode", heading_xf)
    sheet.write(0, 10, "Credit Card No", heading_xf)
    sheet.write(0, 11, "Expiry Month", heading_xf)
    sheet.write(0, 12, "Expiry Year", heading_xf)
    sheet.write(0, 13, "Name on Card", heading_xf)
    sheet.write(0, 14, "Level", heading_xf)
    sheet.write(0, 15, "Issuer Bank", heading_xf)
    sheet.write(0, 16, "Card Brand", heading_xf)
    sheet.write(0, 17, "Address Line 1", heading_xf)
    sheet.write(0, 18, "Address Line 2", heading_xf)
    sheet.write(0, 19, "landmark", heading_xf)

    
    for dataInsurance in dataInsurances:
        order = dataInsurance.order
        if order.status != OrderStatus.DELIVERY_SUCCESS:
            continue
 
 
        dataInsurance.isDeclared = True
        sheet.write(i, 0, 'D')
        sheet.write(i, 1, '1')
        sheet.write(i, 2, dataInsurance.startDate, date_style)
        sheet.write(i, 3, 'S')

        sheet.write(i, 17, xstr(order.customer_address1))
        sheet.write(i, 18, xstr(order.customer_address2))
        sheet.write(i, 20, order.customer_city)
        sheet.write(i, 21, order.customer_state)
        sheet.write(i, 22, order.customer_pincode)
        sheet.write(i, 23, order.customer_name)
        sheet.write(i, 28, order.customer_email)
        sheet.write(i, 29, order.customer_mobilenumber)
        sheet.write(i, 31, 'android')
        i+=1
    

    
    today = date.today()
    datestr = str(today.day) + "-" + str(today.month) + "-" + str(today.year)
    filename = "/tmp/mobile-assist-" + datestr + ".xls"
    wbk.save(filename)
    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","rajveer.singh@saholic.com","kshitij.sood@saholic.com","pramit.singh@saholic.com"], [])
 
    
def returnOrders():
    todate = datetime.now()-timedelta(days = 2)
    orders = Order.query.filter(Order.dataProtectionInsurer > 0).filter(Order.received_return_timestamp >= todate).all()

    
    for order in orders:
        dataInsurance = order.dataInsuranceDetails[0]
        if not (dataInsurance.startDate or dataInsurance.expiryDate) or dataInsurance.expiryDate < datetime.now():
            continue
 
 
        dataInsurance.expiryDate = order.received_return_timestamp
        sheet.write(i, 0,order.customer_name)
        sheet.write(i, 1, order.customer_mobilenumber)
        sheet.write(i, 2, '')
        i+=1
        
    session.commit()

        
    
 
def main():
    deliveredOrders()
    #returnOrders()
    
if __name__ == '__main__':
 
    main()


Rev 9803	Rev 9820
Line 15...	Line 15...
15	`config_client = ConfigClient()`	15	`config_client = ConfigClient()`
16	`host = config_client.get_property('transaction_service_db_hostname')`	16	`host = config_client.get_property('transaction_service_db_hostname')`
17	`DataService.initialize(db_hostname=host)`	17	`DataService.initialize(db_hostname=host)`
18		18
19	`def deliveredOrders():`	19	`def deliveredOrders():`
20	`todate = datetime.datetime.now()-timedelta(days = 10)`	20	`todate = datetime.now()-timedelta(days = 10)`
21	`dataInsurances = DataInsuranceDetailForOrder.query.filter(DataInsuranceDetailForOrder.isDeclared==False).filter(DataInsuranceDetailForOrder.startDate >= todate).all()`	21	`dataInsurances = DataInsuranceDetailForOrder.query.filter(DataInsuranceDetailForOrder.isDeclared==False).filter(DataInsuranceDetailForOrder.startDate >= todate).all()`
22	`if not dataInsurances:`	22	`if not dataInsurances:`
23	`return`	23	`return`
24	`xstr = lambda s: s or ""`	24	`xstr = lambda s: s or ""`
25	`i=1`	25	`i=1`
26	`wbk = xlwt.Workbook()`	26	`wbk = xlwt.Workbook(encoding="UTF-8")`
27	`sheet = wbk.add_sheet('OneAssist Data')`	27	`sheet = wbk.add_sheet('OneAssist Data')`
28	`date_style = xlwt.XFStyle()`	28	`date_style = xlwt.XFStyle()`
29	`date_style.num_format_str = "D/M/YY"`	29	`date_style.num_format_str = "D/M/YY"`
30		30
31	`heading_xf = xlwt.easyxf('font: bold on; align: wrap on, vert centre, horiz center')`	31	`heading_xf = xlwt.easyxf('font: bold on; align: wrap on, vert centre, horiz center')`
Line 49...	Line 49...
49	`sheet.write(0, 9, "Payment Mode", heading_xf)`	49	`sheet.write(0, 9, "Payment Mode", heading_xf)`
50	`sheet.write(0, 10, "Credit Card No", heading_xf)`	50	`sheet.write(0, 10, "Credit Card No", heading_xf)`
51	`sheet.write(0, 11, "Expiry Month", heading_xf)`	51	`sheet.write(0, 11, "Expiry Month", heading_xf)`
52	`sheet.write(0, 12, "Expiry Year", heading_xf)`	52	`sheet.write(0, 12, "Expiry Year", heading_xf)`
53	`sheet.write(0, 13, "Name on Card", heading_xf)`	53	`sheet.write(0, 13, "Name on Card", heading_xf)`
54	`sheet.write(0, 14, " Level", heading_xf)`	54	`sheet.write(0, 14, "Level", heading_xf)`
55	`sheet.write(0, 15, "Issuer Bank", heading_xf)`	55	`sheet.write(0, 15, "Issuer Bank", heading_xf)`
56	`sheet.write(0, 16, "Card Brand", heading_xf)`	56	`sheet.write(0, 16, "Card Brand", heading_xf)`
57	`sheet.write(0, 17, "Address Line 1", heading_xf)`	57	`sheet.write(0, 17, "Address Line 1", heading_xf)`
58	`sheet.write(0, 18, "Address Line 2", heading_xf)`	58	`sheet.write(0, 18, "Address Line 2", heading_xf)`
59	`sheet.write(0, 19, "landmark", heading_xf)`	59	`sheet.write(0, 19, "landmark", heading_xf)`
Line 107...	Line 107...
107		107
108	`for dataInsurance in dataInsurances:`	108	`for dataInsurance in dataInsurances:`
109	`order = dataInsurance.order`	109	`order = dataInsurance.order`
110	`if order.status != OrderStatus.DELIVERY_SUCCESS:`	110	`if order.status != OrderStatus.DELIVERY_SUCCESS:`
111	`continue`	111	`continue`
112	`client = UserClient().get_client()`	-
113	`user = client.getUserById(order.customer_id)`	-
114	`dataInsurance.isDeclared = True`	112	`dataInsurance.isDeclared = True`
115	`sheet.write(i, 0, 'D')`	113	`sheet.write(i, 0, 'D')`
116	`sheet.write(i, 1, '1')`	114	`sheet.write(i, 1, '1')`
117	`sheet.write(i, 2, dataInsurance.startDate, date_style)`	115	`sheet.write(i, 2, dataInsurance.startDate, date_style)`
118	`sheet.write(i, 3, 'S')`	116	`sheet.write(i, 3, 'S')`
Line 120...	Line 118...
120	`sheet.write(i, 17, xstr(order.customer_address1))`	118	`sheet.write(i, 17, xstr(order.customer_address1))`
121	`sheet.write(i, 18, xstr(order.customer_address2))`	119	`sheet.write(i, 18, xstr(order.customer_address2))`
122	`sheet.write(i, 20, order.customer_city)`	120	`sheet.write(i, 20, order.customer_city)`
123	`sheet.write(i, 21, order.customer_state)`	121	`sheet.write(i, 21, order.customer_state)`
124	`sheet.write(i, 22, order.customer_pincode)`	122	`sheet.write(i, 22, order.customer_pincode)`
125	`sheet.write(i, 23, user.name)`	123	`sheet.write(i, 23, order.customer_name)`
126	`sheet.write(i, 28, order.customer_email)`	124	`sheet.write(i, 28, order.customer_email)`
127	`sheet.write(i, 29, order.customer_mobilenumber)`	125	`sheet.write(i, 29, order.customer_mobilenumber)`
128	`sheet.write(i, 31, 'android')`	126	`sheet.write(i, 31, 'android')`
129	`i+=1`	127	`i+=1`
130		128
Line 132...	Line 130...
132		130
133	`today = date.today()`	131	`today = date.today()`
134	`datestr = str(today.day) + "-" + str(today.month) + "-" + str(today.year)`	132	`datestr = str(today.day) + "-" + str(today.month) + "-" + str(today.year)`
135	`filename = "/tmp/mobile-assist-" + datestr + ".xls"`	133	`filename = "/tmp/mobile-assist-" + datestr + ".xls"`
136	`wbk.save(filename)`	134	`wbk.save(filename)`
137	`EmailAttachmentSender.mail("cnc.center@shop2020.in", "5h0p2o2o", ["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","rajveer.singh@saholic.com","kshitij.sood@saholic.com","pramit.singh@saholic.com"], [])`	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","rajveer.singh@saholic.com","kshitij.sood@saholic.com","pramit.singh@saholic.com"], [])`
138		136
139		137
140	`def returnOrders():`	138	`def returnOrders():`
141	`todate = datetime.now()-timedelta(days = 2)`	139	`todate = datetime.now()-timedelta(days = 2)`
142	`orders = Order.query.filter(Order.dataProtectionInsurer > 0).filter(Order.received_return_timestamp >= todate).all()`	140	`orders = Order.query.filter(Order.dataProtectionInsurer > 0).filter(Order.received_return_timestamp >= todate).all()`
Line 165...	Line 163...
165		163
166	`for order in orders:`	164	`for order in orders:`
167	`dataInsurance = order.dataInsuranceDetails[0]`	165	`dataInsurance = order.dataInsuranceDetails[0]`
168	`if not (dataInsurance.startDate or dataInsurance.expiryDate) or dataInsurance.expiryDate < datetime.now():`	166	`if not (dataInsurance.startDate or dataInsurance.expiryDate) or dataInsurance.expiryDate < datetime.now():`
169	`continue`	167	`continue`
170	`client = UserClient.get_client()`	-
171	`user = client.getUserById(order.customer_id)`	-
172	`dataInsurance.expiryDate = order.received_return_timestamp`	168	`dataInsurance.expiryDate = order.received_return_timestamp`
173	`sheet.write(i, 0,user.name)`	169	`sheet.write(i, 0,order.customer_name)`
174	`sheet.write(i, 1, order.customer_mobilenumber)`	170	`sheet.write(i, 1, order.customer_mobilenumber)`
175	`sheet.write(i, 2, '')`	171	`sheet.write(i, 2, '')`
176	`i+=1`	172	`i+=1`
177		173
178	`session.commit()`	174	`session.commit()`
Line 183...	Line 179...
183		179
184		180
185		181
186	`def main():`	182	`def main():`
187	`deliveredOrders()`	183	`deliveredOrders()`
188	`returnOrders()`	184	`#returnOrders()`
189		185
190	`if __name__ == '__main__':`	186	`if __name__ == '__main__':`
191	`main()`	-
192		187	`main()`
-		188

Subversion Repositories SmartDukaan

(root)/trunk/PyProj/src/shop2020/model/v1/order/script/OneAssistData.py – Rev 9803 → 9820