Subversion Repositories SmartDukaan

Rev

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

Rev 6909 Rev 6941
Line 21... Line 21...
21 
        return
 21 
        return
22 
 
 22 
 
23 
    wbk = xlwt.Workbook()
 23 
    wbk = xlwt.Workbook()
24 
    sheet = wbk.add_sheet('main')
 24 
    sheet = wbk.add_sheet('main')
25 
 
 25 
 
- 
 
 26 
    date_style = xlwt.XFStyle()
- 
 
 27 
    date_style.num_format_str = "D/M/YY"
- 
 
 28
26 
    heading_xf = xlwt.easyxf('font: bold on; align: wrap on, vert centre, horiz center')
 29 
    heading_xf = xlwt.easyxf('font: bold on; align: wrap on, vert centre, horiz center')
27 
    sheet.set_panes_frozen(True)
 30 
    sheet.set_panes_frozen(True)
28 
    sheet.set_horz_split_pos(1)
 31 
    sheet.set_horz_split_pos(1)
29 
    sheet.set_remove_splits(True)
 32 
    sheet.set_remove_splits(True)
30
33
Line 58... Line 61...
58 
        if order.status != OrderStatus.DELIVERY_SUCCESS:
 61 
        if order.status != OrderStatus.DELIVERY_SUCCESS:
59 
            continue
 62 
            continue
60 
        line = order.lineitems[0]
 63 
        line = order.lineitems[0]
61 
        insurance.isDeclared = True
 64 
        insurance.isDeclared = True
62
65
63 
        sheet.write(i, 0, insurance.startDate)
 66 
        sheet.write(i, 0, insurance.startDate, date_style)
64 
        sheet.write(i, 1, '')
 67 
        sheet.write(i, 1, '')
65 
        sheet.write(i, 2, order.invoice_number)
 68 
        sheet.write(i, 2, order.invoice_number)
66 
        sheet.write(i, 3, order.customer_name)
 69 
        sheet.write(i, 3, order.customer_name)
67 
        sheet.write(i, 4, 'Mobile Phones')
 70 
        sheet.write(i, 4, 'Mobile Phones')
68 
        sheet.write(i, 5, line.brand)
 71 
        sheet.write(i, 5, line.brand)
Line 72... Line 75...
72 
        sheet.write(i, 9, line.unit_price)
 75 
        sheet.write(i, 9, line.unit_price)
73 
        sheet.write(i, 10, "0")
 76 
        sheet.write(i, 10, "0")
74 
        sheet.write(i, 11, line.total_price)
 77 
        sheet.write(i, 11, line.total_price)
75 
        sheet.write(i, 12, insurance.guardianName)
 78 
        sheet.write(i, 12, insurance.guardianName)
76 
        sheet.write(i, 13, insurance.dob)
 79 
        sheet.write(i, 13, insurance.dob)
77 
        sheet.write(i, 14, order.billing_timestamp)
 80 
        sheet.write(i, 14, order.billing_timestamp, date_style)
78 
        sheet.write(i, 15, order.id)
 81 
        sheet.write(i, 15, order.id)
79 
        sheet.write(i, 16, '')
82 
        sheet.write(i, 16, '')
80 
        i = i + 1
 83 
        i = i + 1
81
84
82
85