Subversion Repositories SmartDukaan

Rev

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

Rev 8299 Rev 8403
Line 151... Line 151...
151 
    date_style = xlwt.XFStyle()
 151 
    date_style = xlwt.XFStyle()
152 
    date_style.num_format_str = "M/D/YY"
 152 
    date_style.num_format_str = "M/D/YY"
153
153
154 
    sheet.write(0, 0, "Order ID", heading_xf)
 154 
    sheet.write(0, 0, "Order ID", heading_xf)
155 
    sheet.write(0, 1, "Mode.", heading_xf)
 155 
    sheet.write(0, 1, "Mode.", heading_xf)
- 
 
 156 
    sheet.write(0, 2, "Source", heading_xf)
156 
    sheet.write(0, 2, "Brand", heading_xf)
 157 
    sheet.write(0, 3, "Brand", heading_xf)
157 
    sheet.write(0, 3, "Model Name", heading_xf)
 158 
    sheet.write(0, 4, "Model Name", heading_xf)
158 
    sheet.write(0, 4, "Model Number", heading_xf)
 159 
    sheet.write(0, 5, "Model Number", heading_xf)
159 
    sheet.write(0, 5, "Colour", heading_xf)
 160 
    sheet.write(0, 6, "Colour", heading_xf)
160 
    sheet.write(0, 6, "Creation Date", heading_xf)
 161 
    sheet.write(0, 7, "Creation Date", heading_xf)
161 
    sheet.write(0, 7, "Promised Shipping Date", heading_xf)
 162 
    sheet.write(0, 8, "Promised Shipping Date", heading_xf)
162 
    sheet.write(0, 8, "Expected Shipping Date", heading_xf)
 163 
    sheet.write(0, 9, "Expected Shipping Date", heading_xf)
163 
    sheet.write(0, 9, "Cancellation Reason", heading_xf)
 164 
    sheet.write(0, 10, "Cancellation Reason", heading_xf)
164 
    sheet.write(0, 10, "Cancellation Date", heading_xf)
165 
    sheet.write(0, 11, "Cancellation Date", heading_xf)
165 
 
 166 
 
166 
    html = """\
 167 
    html = """\
167 
    <html>
 168 
    <html>
168 
        <head>
 169 
        <head>
169 
            <style type="text/css">
 170 
            <style type="text/css">
Line 174... Line 175...
174 
            <center><h3>Delayed Orders</h3></center>
 175 
            <center><h3>Delayed Orders</h3></center>
175 
            <table>
 176 
            <table>
176 
                <tr>
 177 
                <tr>
177 
                    <th>Order ID</th>
 178 
                    <th>Order ID</th>
178 
                    <th>Mode</th>
 179 
                    <th>Mode</th>
- 
 
 180 
                    <th>Source</th>
179 
                    <th>Brand</th>
 181 
                    <th>Brand</th>
180 
                    <th>Model Name</th>
 182 
                    <th>Model Name</th>
181 
                    <th>Model Number</th>
 183 
                    <th>Model Number</th>
182 
                    <th>Colour</th>
 184 
                    <th>Colour</th>
183 
                    <th>Creation Date</th>
 185 
                    <th>Creation Date</th>
Line 191... Line 193...
191 
 
 193 
 
192 
    order = Order()
 194 
    order = Order()
193 
    mode = {}
 195 
    mode = {}
194 
    mode[0] = 'Prepaid'
 196 
    mode[0] = 'Prepaid'
195 
    mode[1] = 'COD'
 197 
    mode[1] = 'COD'
- 
 
 198 
    source = {}
- 
 
 199 
    source[1] = 'WEBSITE'
- 
 
 200 
    source[2] = 'STORE'
- 
 
 201 
    source[3] = 'AMAZON'
- 
 
 202 
    source[4] = 'HOMESHOP18'
- 
 
 203 
    source[5] = 'NAAPTOL'
- 
 
 204 
    source[6] = 'EBAY'
- 
 
 205 
    source[7] = 'SNAPDEAL'
- 
 
 206 
    source[8] = 'UNKNOWN'
- 
 
 207 
    source[9] = 'UNKNOWN'
- 
 
 208 
    source[10] = 'UNKNOWN'
196
209
197 
    i = 1
 210 
    i = 1
198 
    for order in cancelled_orders:
 211 
    for order in cancelled_orders:
199 
        html +="<tr>"
 212 
        html +="<tr>"
200 
        sheet.write(i, 0, order.id)
213 
        sheet.write(i, 0, order.id)
201 
        html +="<td>" + str(order.id) + "</td>"
214 
        html +="<td>" + str(order.id) + "</td>"
202 
        sheet.write(i, 1, mode[order.cod])
 215 
        sheet.write(i, 1, mode[order.cod])
203 
        html +="<td>" + str(mode[order.cod]) + "</td>"
 216 
        html +="<td>" + str(mode[order.cod]) + "</td>"
204
217 
        sheet.write(i, 2, mode[order.source])
- 
 
 218 
        html +="<td>" + str(mode[order.source]) + "</td>"
205 
        lineitem = order.lineitems[0]
 219 
        lineitem = order.lineitems[0]
206 
        sheet.write(i, 2, lineitem.brand)
 220 
        sheet.write(i, 3, lineitem.brand)
207 
        html +="<td>" + str(lineitem.brand) + "</td>"
 221 
        html +="<td>" + str(lineitem.brand) + "</td>"
208 
        sheet.write(i, 3, lineitem.model_name)
 222 
        sheet.write(i, 4, lineitem.model_name)
209 
        html +="<td>" + str(lineitem.model_name) + "</td>"
 223 
        html +="<td>" + str(lineitem.model_name) + "</td>"
210 
        sheet.write(i, 4, lineitem.model_number)
 224 
        sheet.write(i, 5, lineitem.model_number)
211 
        html +="<td>" + str(lineitem.model_number) + "</td>"
 225 
        html +="<td>" + str(lineitem.model_number) + "</td>"
212 
        sheet.write(i, 5, lineitem.color)
 226 
        sheet.write(i, 6, lineitem.color)
213 
        html +="<td>" + str(lineitem.color) + "</td>"
 227 
        html +="<td>" + str(lineitem.color) + "</td>"
214
228
215 
        sheet.write(i, 6, to_py_date(order.created_timestamp), date_style)
 229 
        sheet.write(i, 7, to_py_date(order.created_timestamp), date_style)
216 
        html +="<td>" + str(to_py_date(order.created_timestamp)) + "</td>"
 230 
        html +="<td>" + str(to_py_date(order.created_timestamp)) + "</td>"
217 
        sheet.write(i, 7, to_py_date(order.promised_shipping_time), date_style)
 231 
        sheet.write(i, 8, to_py_date(order.promised_shipping_time), date_style)
218 
        html +="<td>" + str(to_py_date(order.promised_shipping_time)) + "</td>"
 232 
        html +="<td>" + str(to_py_date(order.promised_shipping_time)) + "</td>"
219 
        sheet.write(i, 8, to_py_date(order.expected_shipping_time), date_style)
 233 
        sheet.write(i, 9, to_py_date(order.expected_shipping_time), date_style)
220 
        html +="<td>" + str(to_py_date(order.expected_shipping_time)) + "</td>"
 234 
        html +="<td>" + str(to_py_date(order.expected_shipping_time)) + "</td>"
221 
        sheet.write(i, 9, order.refundReason)
 235 
        sheet.write(i, 10, order.refundReason)
222 
        html +="<td>" + str(order.refundReason) + "</td>"
 236 
        html +="<td>" + str(order.refundReason) + "</td>"
223 
        sheet.write(i, 10, to_py_date(order.refund_timestamp), date_style)
 237 
        sheet.write(i, 11, to_py_date(order.refund_timestamp), date_style)
224 
        html +="<td>" + str(to_py_date(order.refund_timestamp)) + "</td>"
 238 
        html +="<td>" + str(to_py_date(order.refund_timestamp)) + "</td>"
225 
        html +="<td>" + str(order.delayReasonText) + "</td>"
 239 
        html +="<td>" + str(order.delayReasonText) + "</td>"
226 
        html +="</tr>"
 240 
        html +="</tr>"
227
241
228 
        i= i+1
 242 
        i= i+1
Line 274... Line 288...
274 
    date_style = xlwt.XFStyle()
 288 
    date_style = xlwt.XFStyle()
275 
    date_style.num_format_str = "M/D/YY"
 289 
    date_style.num_format_str = "M/D/YY"
276
290
277 
    sheet.write(0, 0, "Order ID", heading_xf)
 291 
    sheet.write(0, 0, "Order ID", heading_xf)
278 
    sheet.write(0, 1, "Mode.", heading_xf)
 292 
    sheet.write(0, 1, "Mode.", heading_xf)
- 
 
 293 
    sheet.write(0, 2, "Source", heading_xf)
279 
    sheet.write(0, 2, "Airway BillNo", heading_xf)
 294 
    sheet.write(0, 3, "Airway BillNo", heading_xf)
280 
    sheet.write(0, 3, "Current Status", heading_xf)
 295 
    sheet.write(0, 4, "Current Status", heading_xf)
281 
    sheet.write(0, 4, "Shipping Date", heading_xf)
 296 
    sheet.write(0, 5, "Shipping Date", heading_xf)
282 
    sheet.write(0, 5, "Pickup Date", heading_xf)
 297 
    sheet.write(0, 6, "Pickup Date", heading_xf)
283 
    sheet.write(0, 6, "Expected Delivery Date", heading_xf)
 298 
    sheet.write(0, 7, "Expected Delivery Date", heading_xf)
284 
    sheet.write(0, 7, "Warehouse", heading_xf)
 299 
    sheet.write(0, 8, "Warehouse", heading_xf)
285 
    sheet.write(0, 8, "Warehouse ID", heading_xf)
 300 
    sheet.write(0, 9, "Warehouse ID", heading_xf)
286 
    sheet.write(0, 9, "Logistics Provider", heading_xf)
 301 
    sheet.write(0, 10, "Logistics Provider", heading_xf)
287 
    sheet.write(0, 10, "Logistics Provider ID", heading_xf)
 302 
    sheet.write(0, 11, "Logistics Provider ID", heading_xf)
288 
    sheet.write(0, 11, "Customer City", heading_xf)
 303 
    sheet.write(0, 12, "Customer City", heading_xf)
289 
    sheet.write(0, 12, "Customer State", heading_xf)
 304 
    sheet.write(0, 13, "Customer State", heading_xf)
290 
    sheet.write(0, 13, "Customer Pincode", heading_xf)
 305 
    sheet.write(0, 14, "Customer Pincode", heading_xf)
291 
 
 306 
 
292 
    html = """\
 307 
    html = """\
293 
    <html>
 308 
    <html>
294 
        <head>
 309 
        <head>
295 
            <style type="text/css">
 310 
            <style type="text/css">
Line 300... Line 315...
300 
            <center><h3>Delayed Orders</h3></center>
 315 
            <center><h3>Delayed Orders</h3></center>
301 
            <table border=1>
 316 
            <table border=1>
302 
                <tr>
 317 
                <tr>
303 
                    <th>Order ID</th>
 318 
                    <th>Order ID</th>
304 
                    <th>Mode</th>
 319 
                    <th>Mode</th>
- 
 
 320 
                    <th>Source</th>
305 
                    <th>Airway BillNo</th>
 321 
                    <th>Airway BillNo</th>
306 
                    <th>Current Status</th>
 322 
                    <th>Current Status</th>
307 
                    <th>Shipping Date</th>
 323 
                    <th>Shipping Date</th>
308 
                    <th>Pickup Date</th>
 324 
                    <th>Pickup Date</th>
309 
                    <th>Expected Delivery Date</th>
 325 
                    <th>Expected Delivery Date</th>
Line 320... Line 336...
320 
    order = Order()
 336 
    order = Order()
321 
    mode = {}
 337 
    mode = {}
322 
    mode[0] = 'Prepaid'
 338 
    mode[0] = 'Prepaid'
323 
    mode[1] = 'COD'
 339 
    mode[1] = 'COD'
324
340
- 
 
 341 
    source = {}
- 
 
 342 
    source[1] = 'WEBSITE'
- 
 
 343 
    source[2] = 'STORE'
- 
 
 344 
    source[3] = 'AMAZON'
- 
 
 345 
    source[4] = 'HOMESHOP18'
- 
 
 346 
    source[5] = 'NAAPTOL'
- 
 
 347 
    source[6] = 'EBAY'
- 
 
 348 
    source[7] = 'SNAPDEAL'
- 
 
 349 
    source[8] = 'UNKNOWN'
- 
 
 350 
    source[9] = 'UNKNOWN'
- 
 
 351 
    source[10] = 'UNKNOWN'
- 
 
 352
325 
    i = 1
 353 
    i = 1
326 
    for order in orders_not_delivered:
 354 
    for order in orders_not_delivered:
327 
        html +="<tr>"
 355 
        html +="<tr>"
328 
        sheet.write(i, 0, order.id)
356 
        sheet.write(i, 0, order.id)
329 
        html +="<td>" + str(order.id) + "</td>"
 357 
        html +="<td>" + str(order.id) + "</td>"
330 
        sheet.write(i, 1, mode[order.cod])
 358 
        sheet.write(i, 1, mode[order.cod])
331 
        html +="<td>" + str(mode[order.cod]) + "</td>"
 359 
        html +="<td>" + str(mode[order.cod]) + "</td>"
- 
 
 360 
        sheet.write(i, 2, mode[order.source])
- 
 
 361 
        html +="<td>" + str(mode[order.source]) + "</td>"
332 
        sheet.write(i, 2, order.airwaybill_no)
 362 
        sheet.write(i, 3, order.airwaybill_no)
333 
        html +="<td>" + str(order.airwaybill_no) + "</td>"
 363 
        html +="<td>" + str(order.airwaybill_no) + "</td>"
334 
        sheet.write(i, 3, order.statusDescription)
 364 
        sheet.write(i, 4, order.statusDescription)
335 
        html +="<td>" + order.statusDescription + "</td>"
 365 
        html +="<td>" + order.statusDescription + "</td>"
336 
        sheet.write(i, 4, to_py_date(order.shipping_timestamp), date_style)
 366 
        sheet.write(i, 5, to_py_date(order.shipping_timestamp), date_style)
337 
        html +="<td>" + str(to_py_date(order.shipping_timestamp)) + "</td>"
 367 
        html +="<td>" + str(to_py_date(order.shipping_timestamp)) + "</td>"
338 
        sheet.write(i, 5, to_py_date(order.pickup_timestamp), date_style)
 368 
        sheet.write(i, 6, to_py_date(order.pickup_timestamp), date_style)
339 
        html +="<td>" + str(to_py_date(order.pickup_timestamp)) + "</td>"
 369 
        html +="<td>" + str(to_py_date(order.pickup_timestamp)) + "</td>"
340 
        sheet.write(i, 6, to_py_date(order.expected_delivery_time), date_style)
 370 
        sheet.write(i, 7, to_py_date(order.expected_delivery_time), date_style)
341 
        html +="<td>" + str(to_py_date(order.expected_delivery_time)) + "</td>"
 371 
        html +="<td>" + str(to_py_date(order.expected_delivery_time)) + "</td>"
342 
        sheet.write(i, 7, warehouses_map.get(order.warehouse_id))
 372 
        sheet.write(i, 8, warehouses_map.get(order.warehouse_id))
343 
        html +="<td>" + str(warehouses_map.get(order.warehouse_id)) + "</td>"
 373 
        html +="<td>" + str(warehouses_map.get(order.warehouse_id)) + "</td>"
344 
        sheet.write(i, 8, order.warehouse_id)
 374 
        sheet.write(i, 9, order.warehouse_id)
345 
        html +="<td>" + str(order.warehouse_id) + "</td>"
 375 
        html +="<td>" + str(order.warehouse_id) + "</td>"
346 
        sheet.write(i, 9, providers_map.get(order.logistics_provider_id))
 376 
        sheet.write(i, 10, providers_map.get(order.logistics_provider_id))
347 
        html +="<td>" + str(providers_map.get(order.logistics_provider_id)) + "</td>"
 377 
        html +="<td>" + str(providers_map.get(order.logistics_provider_id)) + "</td>"
348 
        sheet.write(i, 10, order.logistics_provider_id)
 378 
        sheet.write(i, 11, order.logistics_provider_id)
349 
        html +="<td>" + str(order.logistics_provider_id) + "</td>"
 379 
        html +="<td>" + str(order.logistics_provider_id) + "</td>"
350 
        sheet.write(i, 11, order.customer_city)
 380 
        sheet.write(i, 12, order.customer_city)
351 
        html +="<td>" + str(order.customer_city) + "</td>"
 381 
        html +="<td>" + str(order.customer_city) + "</td>"
352 
        sheet.write(i, 12, order.customer_state)
 382 
        sheet.write(i, 13, order.customer_state)
353 
        html +="<td>" + str(order.customer_state) + "</td>"
 383 
        html +="<td>" + str(order.customer_state) + "</td>"
354 
        sheet.write(i, 13, order.customer_pincode)
 384 
        sheet.write(i, 14, order.customer_pincode)
355 
        html +="<td>" + str(order.customer_pincode) + "</td>"
 385 
        html +="<td>" + str(order.customer_pincode) + "</td>"
356
386
357 
        html +="</tr>"
 387 
        html +="</tr>"
358 
        i= i+1
 388 
        i= i+1
359
389