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')