Subversion Repositories SmartDukaan

Rev

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

Rev 8405 Rev 8732
Line 44... Line 44...
44 
 
 44 
 
45 
    date_style = xlwt.XFStyle()
 45 
    date_style = xlwt.XFStyle()
46 
    date_style.num_format_str = "M/D/YY"
 46 
    date_style.num_format_str = "M/D/YY"
47
47
48 
    sheet.write(0, 0, "Order ID", heading_xf)
 48 
    sheet.write(0, 0, "Order ID", heading_xf)
- 
 
 49 
    sheet.write(0, 1, "Source", heading_xf)
49 
    sheet.write(0, 1, "Mode.", heading_xf)
 50 
    sheet.write(0, 2, "Mode.", heading_xf)
50 
    sheet.write(0, 2, "Brand", heading_xf)
 51 
    sheet.write(0, 3, "Brand", heading_xf)
51 
    sheet.write(0, 3, "Model Name", heading_xf)
 52 
    sheet.write(0, 4, "Model Name", heading_xf)
52 
    sheet.write(0, 4, "Model Number", heading_xf)
 53 
    sheet.write(0, 5, "Model Number", heading_xf)
53 
    sheet.write(0, 5, "Colour", heading_xf)
 54 
    sheet.write(0, 6, "Colour", heading_xf)
54 
    sheet.write(0, 6, "Creation Date", heading_xf)
 55 
    sheet.write(0, 7, "Creation Date", heading_xf)
55 
    sheet.write(0, 7, "Promised Shipping Date", heading_xf)
 56 
    sheet.write(0, 8, "Promised Shipping Date", heading_xf)
56 
    sheet.write(0, 8, "Expected Shipping Date", heading_xf)
 57 
    sheet.write(0, 9, "Expected Shipping Date", heading_xf)
57 
    sheet.write(0, 9, "Delay Reason", heading_xf)
 58 
    sheet.write(0, 10, "Delay Reason", heading_xf)
58 
    sheet.write(0, 10, "Detailed Reason Text", heading_xf)
59 
    sheet.write(0, 11, "Detailed Reason Text", heading_xf)
59
60
60 
    html = """\
 61 
    html = """\
61 
    <html>
 62 
    <html>
62 
        <head>
 63 
        <head>
63 
            <style type="text/css">
 64 
            <style type="text/css">
Line 67... Line 68...
67 
        <body>
 68 
        <body>
68 
            <center><h3>Delayed Orders</h3></center>
 69 
            <center><h3>Delayed Orders</h3></center>
69 
            <table>
 70 
            <table>
70 
                <tr>
 71 
                <tr>
71 
                    <th>Order ID</th>
 72 
                    <th>Order ID</th>
- 
 
 73 
                    <th>Source</th>
72 
                    <th>Mode</th>
 74 
                    <th>Mode</th>
73 
                    <th>Brand</th>
 75 
                    <th>Brand</th>
74 
                    <th>Model Name</th>
 76 
                    <th>Model Name</th>
75 
                    <th>Model Number</th>
 77 
                    <th>Model Number</th>
76 
                    <th>Colour</th>
 78 
                    <th>Colour</th>
Line 84... Line 86...
84
86
85 
    order = Order()
 87 
    order = Order()
86 
    mode = {}
 88 
    mode = {}
87 
    mode[0] = 'Prepaid'
 89 
    mode[0] = 'Prepaid'
88 
    mode[1] = 'COD'
 90 
    mode[1] = 'COD'
- 
 
 91 
    source = {}
- 
 
 92 
    source[1] = 'WEBSITE'
- 
 
 93 
    source[2] = 'STORE'
- 
 
 94 
    source[3] = 'AMAZON'
- 
 
 95 
    source[4] = 'HOMESHOP18'
- 
 
 96 
    source[5] = 'NAAPTOL'
- 
 
 97 
    source[6] = 'EBAY'
- 
 
 98 
    source[7] = 'SNAPDEAL'
- 
 
 99 
    source[8] = 'UNKNOWN'
- 
 
 100 
    source[9] = 'UNKNOWN'
- 
 
 101 
    source[10] = 'UNKNOWN'
89
102
90 
    i = 1
 103 
    i = 1
91 
    for order in slipped_orders:
 104 
    for order in slipped_orders:
92 
        if order.source ==6:
 105 
        #if order.source ==6:
93 
            continue
 106 
            #continue
94 
        html +="<tr>"
 107 
        html +="<tr>"
95 
        sheet.write(i, 0, order.id)
 108 
        sheet.write(i, 0, order.id)
96 
        html +="<td>" + str(order.id) + "</td>"
109 
        html +="<td>" + str(order.id) + "</td>"
- 
 
 110 
        sheet.write(i, 1, source[order.source])
- 
 
 111 
        html +="<td>" + str(source[order.source]) + "</td>"
97 
        sheet.write(i, 1, mode[order.cod])
 112 
        sheet.write(i, 2, mode[order.cod])
98 
        html +="<td>" + str(mode[order.cod]) + "</td>"
 113 
        html +="<td>" + str(mode[order.cod]) + "</td>"
99
- 
 
100 
        lineitem = order.lineitems[0]
 114 
        lineitem = order.lineitems[0]
101 
        sheet.write(i, 2, lineitem.brand)
 115 
        sheet.write(i, 3, lineitem.brand)
102 
        html +="<td>" + str(lineitem.brand) + "</td>"
 116 
        html +="<td>" + str(lineitem.brand) + "</td>"
103 
        sheet.write(i, 3, lineitem.model_name)
 117 
        sheet.write(i, 4, lineitem.model_name)
104 
        html +="<td>" + str(lineitem.model_name) + "</td>"
 118 
        html +="<td>" + str(lineitem.model_name) + "</td>"
105 
        sheet.write(i, 4, lineitem.model_number)
 119 
        sheet.write(i, 5, lineitem.model_number)
106 
        html +="<td>" + str(lineitem.model_number) + "</td>"
 120 
        html +="<td>" + str(lineitem.model_number) + "</td>"
107 
        sheet.write(i, 5, lineitem.color)
 121 
        sheet.write(i, 6, lineitem.color)
108 
        html +="<td>" + str(lineitem.color) + "</td>"
 122 
        html +="<td>" + str(lineitem.color) + "</td>"
109 
        sheet.write(i, 6, to_py_date(order.created_timestamp), date_style)
 123 
        sheet.write(i, 7, to_py_date(order.created_timestamp), date_style)
110 
        html +="<td>" + str(to_py_date(order.created_timestamp)) + "</td>"
 124 
        html +="<td>" + str(to_py_date(order.created_timestamp)) + "</td>"
111 
        sheet.write(i, 7, to_py_date(order.promised_shipping_time), date_style)
 125 
        sheet.write(i, 8, to_py_date(order.promised_shipping_time), date_style)
112 
        html +="<td>" + str(to_py_date(order.promised_shipping_time)) + "</td>"
 126 
        html +="<td>" + str(to_py_date(order.promised_shipping_time)) + "</td>"
113 
        sheet.write(i, 8, to_py_date(order.expected_shipping_time), date_style)
 127 
        sheet.write(i, 9, to_py_date(order.expected_shipping_time), date_style)
114 
        html +="<td>" + str(to_py_date(order.expected_shipping_time)) + "</td>"
 128 
        html +="<td>" + str(to_py_date(order.expected_shipping_time)) + "</td>"
115 
        if order.delayReason:
 129 
        if order.delayReason:
116 
            sheet.write(i, 9, DelayReason._VALUES_TO_NAMES[order.delayReason])
 130 
            sheet.write(i, 10, DelayReason._VALUES_TO_NAMES[order.delayReason])
117 
            html +="<td>" + str(DelayReason._VALUES_TO_NAMES[order.delayReason]) + "</td>"
 131 
            html +="<td>" + str(DelayReason._VALUES_TO_NAMES[order.delayReason]) + "</td>"
118 
        sheet.write(i, 10, order.delayReasonText)
 132 
        sheet.write(i, 11, order.delayReasonText)
119 
        html +="<td>" + str(order.delayReasonText) + "</td>"
 133 
        html +="<td>" + str(order.delayReasonText) + "</td>"
120 
        html +="</tr>"
 134 
        html +="</tr>"
121 
        i= i+1
 135 
        i= i+1
122
136
123 
    today = datetime.date.today()
 137 
    today = datetime.date.today()