Subversion Repositories SmartDukaan

Rev

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

Rev 9575 Rev 9609
Line 73... Line 73...
73
73
74 
    for dataInsurance in dataInsurances:
 74 
    for dataInsurance in dataInsurances:
75 
        order = dataInsurance.order
 75 
        order = dataInsurance.order
76 
        if order.status != OrderStatus.DELIVERY_SUCCESS:
 76 
        if order.status != OrderStatus.DELIVERY_SUCCESS:
77 
            continue
 77 
            continue
78 
        client = UserClient.get_client()
78 
        client = UserClient().get_client()
79 
        user = client.getUserById(order.customer_id)
 79 
        user = client.getUserById(order.customer_id)
80 
        dataInsurance.isDeclared = True
 80 
        dataInsurance.isDeclared = True
81 
        sheet.write(i, 0, 'D')
 81 
        sheet.write(i, 0, 'D')
82 
        sheet.write(i, 1, '1')
 82 
        sheet.write(i, 1, '1')
83 
        sheet.write(i, 2, dataInsurance.startDate, date_style)
 83 
        sheet.write(i, 2, dataInsurance.startDate, date_style)
Line 100... Line 100...
100 
    datestr = str(today.day) + "-" + str(today.month) + "-" + str(today.year)
 100 
    datestr = str(today.day) + "-" + str(today.month) + "-" + str(today.year)
101 
    filename = "/tmp/data-insurance-" + datestr + ".xls"
 101 
    filename = "/tmp/data-insurance-" + datestr + ".xls"
102 
    wbk.save(filename)
 102 
    wbk.save(filename)
103
103
104 
def returnOrders():
 104 
def returnOrders():
105 
    todate = datetime.datetime.now()-timedelta(days = 2)
 105 
    todate = datetime.now()-timedelta(days = 2)
106 
    orders = Order.query.filter(Order.dataProtectionInsurer > 0).filter(Order.received_return_timestamp >= todate).all()
 106 
    orders = Order.query.filter(Order.dataProtectionInsurer > 0).filter(Order.received_return_timestamp >= todate).all()
107 
    if not orders:
 107 
    if not orders:
108 
        return
 108 
        return
109 
    wbk = xlwt.Workbook()
 109 
    wbk = xlwt.Workbook()
110 
    sheet = wbk.add_sheet('OneAssist Return')
 110 
    sheet = wbk.add_sheet('OneAssist Return')