WebSVN – SmartDukaan – Diff – //trunk/PyDTR/src/dtr/reports/crmoutbound.py



    worksheet.write(row+21,column-1, 'Idle Time (In Hrs)', style)
    worksheet.write(row+22,column-1, 'Links Converted', style)
    worksheet.write(row+23,column-1, 'Link sent yet to be converted', style)        
    columnId=agentId
    while True:
            if agentId >50 :
                break
            else: 
                datesql=AGENT_FRESH_QUERY %(agentId)
                conn = getDbConnection()
                

    worksheet.write(row+16,column-1, 'Call Duration (In Hrs)', style)
    worksheet.write(row+17,column-1, 'Handling Time (In Hrs)', style)
    worksheet.write(row+18,column-1, 'Idle Time (In Hrs)', style)
    columnId=agentId
    while True:
            if agentId >50 :
                break
            else: 
                datesql=AGENT_FOLLOW_UP_QUERY %(agentId)
                conn = getDbConnection()
                

    worksheet.write(row+10,column-1, 'Call Duration (In Hrs)', style)
    worksheet.write(row+11,column-1, 'Handling Time (In Hrs)', style)
    worksheet.write(row+12,column-1, 'Idle Time (In Hrs)', style)
    columnId=agentId
    while True:
            if agentId >50 :
                break
            else: 
                datesql=AGENT_ONBOARDING_QUERY %(agentId)
                conn = getDbConnection()
                

Rev 17440	Rev 17752
Line 485...	Line 485...
485	`worksheet.write(row+21,column-1, 'Idle Time (In Hrs)', style)`	485	`worksheet.write(row+21,column-1, 'Idle Time (In Hrs)', style)`
486	`worksheet.write(row+22,column-1, 'Links Converted', style)`	486	`worksheet.write(row+22,column-1, 'Links Converted', style)`
487	`worksheet.write(row+23,column-1, 'Link sent yet to be converted', style)`	487	`worksheet.write(row+23,column-1, 'Link sent yet to be converted', style)`
488	`columnId=agentId`	488	`columnId=agentId`
489	`while True:`	489	`while True:`
490	`if agentId >20 :`	490	`if agentId >50 :`
491	`break`	491	`break`
492	`else:`	492	`else:`
493	`datesql=AGENT_FRESH_QUERY %(agentId)`	493	`datesql=AGENT_FRESH_QUERY %(agentId)`
494	`conn = getDbConnection()`	494	`conn = getDbConnection()`
495		495
Line 815...	Line 815...
815	`worksheet.write(row+16,column-1, 'Call Duration (In Hrs)', style)`	815	`worksheet.write(row+16,column-1, 'Call Duration (In Hrs)', style)`
816	`worksheet.write(row+17,column-1, 'Handling Time (In Hrs)', style)`	816	`worksheet.write(row+17,column-1, 'Handling Time (In Hrs)', style)`
817	`worksheet.write(row+18,column-1, 'Idle Time (In Hrs)', style)`	817	`worksheet.write(row+18,column-1, 'Idle Time (In Hrs)', style)`
818	`columnId=agentId`	818	`columnId=agentId`
819	`while True:`	819	`while True:`
820	`if agentId >20 :`	820	`if agentId >50 :`
821	`break`	821	`break`
822	`else:`	822	`else:`
823	`datesql=AGENT_FOLLOW_UP_QUERY %(agentId)`	823	`datesql=AGENT_FOLLOW_UP_QUERY %(agentId)`
824	`conn = getDbConnection()`	824	`conn = getDbConnection()`
825		825
Line 1102...	Line 1102...
1102	`worksheet.write(row+10,column-1, 'Call Duration (In Hrs)', style)`	1102	`worksheet.write(row+10,column-1, 'Call Duration (In Hrs)', style)`
1103	`worksheet.write(row+11,column-1, 'Handling Time (In Hrs)', style)`	1103	`worksheet.write(row+11,column-1, 'Handling Time (In Hrs)', style)`
1104	`worksheet.write(row+12,column-1, 'Idle Time (In Hrs)', style)`	1104	`worksheet.write(row+12,column-1, 'Idle Time (In Hrs)', style)`
1105	`columnId=agentId`	1105	`columnId=agentId`
1106	`while True:`	1106	`while True:`
1107	`if agentId >20 :`	1107	`if agentId >50 :`
1108	`break`	1108	`break`
1109	`else:`	1109	`else:`
1110	`datesql=AGENT_ONBOARDING_QUERY %(agentId)`	1110	`datesql=AGENT_ONBOARDING_QUERY %(agentId)`
1111	`conn = getDbConnection()`	1111	`conn = getDbConnection()`
1112		1112

Subversion Repositories SmartDukaan

(root)//trunk/PyDTR/src/dtr/reports/crmoutbound.py – Rev 17440 → 17752