Subversion Repositories SmartDukaan

Rev

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

Rev 4538 Rev 4594
Line 7... Line 7...
7 
 
 7 
 
8 
@author: Rajveer
 8 
@author: Rajveer
9 
'''
 9 
'''
10 
import xlwt
 10 
import xlwt
11 
import datetime
 11 
import datetime
- 
 
 12 
from shop2020.utils.Utils import to_py_date
12 
 
 13 
 
13 
 
 14 
 
14 
if __name__ == '__main__' and __package__ is None:
 15 
if __name__ == '__main__' and __package__ is None:
15 
    import sys
 16 
    import sys
16 
    import os
 17 
    import os
Line 53... Line 54...
53 
    i = 1
 54 
    i = 1
54 
    for order in shipped_orders:
 55 
    for order in shipped_orders:
55 
        sheet.write(i, 0, order.id)
56 
        sheet.write(i, 0, order.id)
56 
        sheet.write(i, 1, order.airwaybill_no)
 57 
        sheet.write(i, 1, order.airwaybill_no)
57 
        sheet.write(i, 2, order.logistics_provider_id)
 58 
        sheet.write(i, 2, order.logistics_provider_id)
58 
        sheet.write(i, 3, order.shipping_timestamp)
 59 
        sheet.write(i, 3, to_py_date(order.shipping_timestamp))
59
60
60 
        lineitem = order.lineitems[0]
 61 
        lineitem = order.lineitems[0]
61 
        sheet.write(i, 4, lineitem.item_id)
 62 
        sheet.write(i, 4, lineitem.item_id)
62 
        sheet.write(i, 5, lineitem.brand)
 63 
        sheet.write(i, 5, lineitem.brand)
63 
        sheet.write(i, 6, lineitem.model_name)
 64 
        sheet.write(i, 6, lineitem.model_name)