Subversion Repositories SmartDukaan

Rev

Rev 7154 | Rev 7335 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 7154 Rev 7177
Line 93... Line 93...
93 
    datestr = str(today.year) + "-" + str(today.month) + "-" + str(today.day)
 93 
    datestr = str(today.year) + "-" + str(today.month) + "-" + str(today.day)
94 
    filename = "/tmp/insurance-" + datestr + ".xls"
 94 
    filename = "/tmp/insurance-" + datestr + ".xls"
95 
    wbk.save(filename)
 95 
    wbk.save(filename)
96 
    EmailAttachmentSender.mail("cnc.center@shop2020.in", "5h0p2o2o", ["ab@universalinsurance.co.in", "urmila.phadke@universalinsurace.co.in"], "Insurance Details for date " + datestr, "Please find attached insurance details for today.", [get_attachment_part(filename)], ["pramit.singh@shop2020.in","rbuniversal@gmail.com","rajveer.singh@shop2020.in","anupam.singh@shop2020.in","rajneesh.arora@shop2020.in"], [])
 96 
    EmailAttachmentSender.mail("cnc.center@shop2020.in", "5h0p2o2o", ["ab@universalinsurance.co.in", "urmila.phadke@universalinsurace.co.in"], "Insurance Details for date " + datestr, "Please find attached insurance details for today.", [get_attachment_part(filename)], ["pramit.singh@shop2020.in","rbuniversal@gmail.com","rajveer.singh@shop2020.in","anupam.singh@shop2020.in","rajneesh.arora@shop2020.in"], [])
97 
 
 97 
 
- 
 
 98 
    insurer = client.getInsurer(1)
- 
 
 99 
    EmailAttachmentSender.mail("cnc.center@shop2020.in", "5h0p2o2o", ["pramit.singh@shop2020.in","rajveer.singh@shop2020.in","anupam.singh@shop2020.in","rajneesh.arora@shop2020.in"], "Declaration Status for insurer  " + insurer.name + " as on " + datestr + " : (Declared Amount - " +  str(insurer.declaredAmount) + ")  (Total Amount - " + str(insurer.creditedAmount), "", [], [], [])
- 
 
 100
98 
def returned_orders():
 101 
def returned_orders():
99 
    DataService.initialize(db_hostname="192.168.190.114")
 102 
    DataService.initialize(db_hostname="192.168.190.114")
100 
    todate = datetime.now()
103 
    todate = datetime.now()
101 
    todate = todate-timedelta(days = 2)
 104 
    todate = todate-timedelta(days = 2)
102 
    orders = Order.query.filter(Order.insurer > 0).filter(Order.received_return_timestamp >= todate).all()
 105 
    orders = Order.query.filter(Order.insurer > 0).filter(Order.received_return_timestamp >= todate).all()