Subversion Repositories SmartDukaan

Rev

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

Rev 16931 Rev 16933
Line 324... Line 324...
324
    worksheet.write(row, 1, 'TRU', boldStyle)
324
    worksheet.write(row, 1, 'TRU', boldStyle)
325
    worksheet.write(row, 2, 'NRU', boldStyle)
325
    worksheet.write(row, 2, 'NRU', boldStyle)
326
    worksheet.write(row, 3, 'DAU', boldStyle)
326
    worksheet.write(row, 3, 'DAU', boldStyle)
327
    worksheet.write(row, 4, 'DAB', boldStyle)
327
    worksheet.write(row, 4, 'DAB', boldStyle)
328
    worksheet.write(row, 5, 'DTO', boldStyle)
328
    worksheet.write(row, 5, 'DTO', boldStyle)
329
    worksheet.write(row, 6, 'DSO', boldStyle)   
329
    worksheet.write(row, 6, 'DVOL', boldStyle)   
330
    worksheet.write(row, 7, 'DTV', boldStyle)
330
    worksheet.write(row, 7, 'DTV', boldStyle)
331
    for r in result:
331
    for r in result:
332
        row += 1
332
        row += 1
333
        column = 0
333
        column = 0
334
        for data in r :
334
        for data in r :
Line 402... Line 402...
402
        result = cursor.fetchall()
402
        result = cursor.fetchall()
403
        for r in result:
403
        for r in result:
404
            quantity= r[0]   
404
            quantity= r[0]   
405
            if quantity is None:
405
            if quantity is None:
406
                quantity=0
406
                quantity=0
-
 
407
        print 'Total Sub order quantity', dateWiseOrderMap.get(x).count,' Flipkart Order', quantity
407
        worksheet.write(row,column,(dateWiseOrderMap.get(x).count)+quantity)
408
        worksheet.write(row,column,(dateWiseOrderMap.get(x).count)+quantity)
408
        column += 1
409
        column += 1
409
 
410
 
410
    row =0
411
    row =0
411
    for x in sorted(dateWiseOrderMap):
412
    for x in sorted(dateWiseOrderMap):
Line 449... Line 450...
449
    worksheet.write(row, 1, 'MTRU', boldStyle)
450
    worksheet.write(row, 1, 'MTRU', boldStyle)
450
    worksheet.write(row, 2, 'MNRU', boldStyle)
451
    worksheet.write(row, 2, 'MNRU', boldStyle)
451
    worksheet.write(row, 3, 'MAU', boldStyle)
452
    worksheet.write(row, 3, 'MAU', boldStyle)
452
    worksheet.write(row, 4, 'MAB', boldStyle)
453
    worksheet.write(row, 4, 'MAB', boldStyle)
453
    worksheet.write(row, 5, 'MTO', boldStyle)
454
    worksheet.write(row, 5, 'MTO', boldStyle)
454
    worksheet.write(row, 6, 'MTS', boldStyle)
455
    worksheet.write(row, 6, 'MVOL', boldStyle)
455
    worksheet.write(row, 7, 'MTV', boldStyle)
456
    worksheet.write(row, 7, 'MTV', boldStyle)
456
    
457
    
457
    for r in result:
458
    for r in result:
458
        row += 1
459
        row += 1
459
        column = 0
460
        column = 0
Line 531... Line 532...
531
        result = cursor.fetchall()
532
        result = cursor.fetchall()
532
        for r in result:
533
        for r in result:
533
            quantity= r[0]
534
            quantity= r[0]
534
            if quantity is None:
535
            if quantity is None:
535
                quantity=0
536
                quantity=0
-
 
537
        print 'Total Sub order quantity Monthly', dateWiseOrderMap.get(x).count,' Flipkart Order', quantity        
536
        worksheet.write(row,column,(monthWiseOrderMap.get(x).count)+quantity)
538
        worksheet.write(row,column,(monthWiseOrderMap.get(x).count)+quantity)
537
        column += 1
539
        column += 1
538
        
540
        
539
    row =0
541
    row =0
540
    for x in sorted(monthWiseOrderMap):
542
    for x in sorted(monthWiseOrderMap):
Line 583... Line 585...
583
    worksheet.write(row, 1, 'WTRU', boldStyle)
585
    worksheet.write(row, 1, 'WTRU', boldStyle)
584
    worksheet.write(row, 2, 'WNRU', boldStyle)
586
    worksheet.write(row, 2, 'WNRU', boldStyle)
585
    worksheet.write(row, 3, 'WAU', boldStyle)
587
    worksheet.write(row, 3, 'WAU', boldStyle)
586
    worksheet.write(row, 4, 'WAB', boldStyle)
588
    worksheet.write(row, 4, 'WAB', boldStyle)
587
    worksheet.write(row, 5, 'WTO', boldStyle)
589
    worksheet.write(row, 5, 'WTO', boldStyle)
588
    worksheet.write(row, 6, 'WTS', boldStyle)
590
    worksheet.write(row, 6, 'WVOL', boldStyle)
589
    worksheet.write(row, 7, 'WTV', boldStyle)
591
    worksheet.write(row, 7, 'WTV', boldStyle)
590
   
592
   
591
    for r in result:
593
    for r in result:
592
        row += 1
594
        row += 1
593
        column = 0
595
        column = 0
Line 663... Line 665...
663
        result = cursor.fetchall()
665
        result = cursor.fetchall()
664
        for r in result:
666
        for r in result:
665
            quantity= r[0]
667
            quantity= r[0]
666
            if quantity is None:
668
            if quantity is None:
667
                quantity=0
669
                quantity=0
-
 
670
        print 'Total Sub order quantity Weekly', dateWiseOrderMap.get(x).count,' Flipkart Order', quantity        
668
        worksheet.write(row,column,(weekWiseOrderMap.get(x).count)+quantity)
671
        worksheet.write(row,column,(weekWiseOrderMap.get(x).count)+quantity)
669
        column+=1
672
        column+=1
670
    row = 0
673
    row = 0
671
    for x in sorted(weekWiseOrderMap):
674
    for x in sorted(weekWiseOrderMap):
672
        row += 1
675
        row += 1