WebSVN – SmartDukaan – Diff – /trunk/PyDTR/src/scripts/ActivityReport.py



    worksheet.write(row, 1, 'TRU', boldStyle)
    worksheet.write(row, 2, 'NRU', boldStyle)
    worksheet.write(row, 3, 'DAU', boldStyle)
    worksheet.write(row, 4, 'DAB', boldStyle)
    worksheet.write(row, 5, 'DTO', boldStyle)
    worksheet.write(row, 6, 'DVOL', boldStyle)   
    worksheet.write(row, 7, 'DTV', boldStyle)
    for r in result:
        row += 1
        column = 0
        for data in r :

        result = cursor.fetchall()
        for r in result:
            quantity= r[0]   
            if quantity is None:
                quantity=0
        print 'Total Sub order quantity', dateWiseOrderMap.get(x).count,' Flipkart Order', quantity
        worksheet.write(row,column,(dateWiseOrderMap.get(x).count)+quantity)
        column += 1
 
    row =0
    for x in sorted(dateWiseOrderMap):

    worksheet.write(row, 1, 'MTRU', boldStyle)
    worksheet.write(row, 2, 'MNRU', boldStyle)
    worksheet.write(row, 3, 'MAU', boldStyle)
    worksheet.write(row, 4, 'MAB', boldStyle)
    worksheet.write(row, 5, 'MTO', boldStyle)
    worksheet.write(row, 6, 'MVOL', boldStyle)
    worksheet.write(row, 7, 'MTV', boldStyle)
    
    for r in result:
        row += 1
        column = 0

        result = cursor.fetchall()
        for r in result:
            quantity= r[0]
            if quantity is None:
                quantity=0
        print 'Total Sub order quantity Monthly', dateWiseOrderMap.get(x).count,' Flipkart Order', quantity        
        worksheet.write(row,column,(monthWiseOrderMap.get(x).count)+quantity)
        column += 1
        
    row =0
    for x in sorted(monthWiseOrderMap):

    worksheet.write(row, 1, 'WTRU', boldStyle)
    worksheet.write(row, 2, 'WNRU', boldStyle)
    worksheet.write(row, 3, 'WAU', boldStyle)
    worksheet.write(row, 4, 'WAB', boldStyle)
    worksheet.write(row, 5, 'WTO', boldStyle)
    worksheet.write(row, 6, 'WVOL', boldStyle)
    worksheet.write(row, 7, 'WTV', boldStyle)
   
    for r in result:
        row += 1
        column = 0

        result = cursor.fetchall()
        for r in result:
            quantity= r[0]
            if quantity is None:
                quantity=0
        print 'Total Sub order quantity Weekly', dateWiseOrderMap.get(x).count,' Flipkart Order', quantity        
        worksheet.write(row,column,(weekWiseOrderMap.get(x).count)+quantity)
        column+=1
    row = 0
    for x in sorted(weekWiseOrderMap):
        row += 1

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`

Subversion Repositories SmartDukaan

(root)/trunk/PyDTR/src/scripts/ActivityReport.py – Rev 16931 → 16933