Subversion Repositories SmartDukaan

Rev

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

Rev 15516 Rev 15517
Line 952... Line 952...
952 
    boldStyle.font = f
 952 
    boldStyle.font = f
953
953
954 
    column = 0
 954 
    column = 0
955 
    row = 0
 955 
    row = 0
956 
    currentList=[]
 956 
    currentList=[]
- 
 
 957 
    worksheet.write(0,0,'Call Disposition Type',style)
- 
 
 958 
    worksheet.write(0,1,'Count',style)
- 
 
 959 
    worksheet.write(1, column, 'Call Later', newStyle)
- 
 
 960 
    worksheet.write(2,column, 'Ringing No Answer', newStyle)
- 
 
 961 
    worksheet.write(3,column, 'Not Reachable', newStyle)
- 
 
 962 
    worksheet.write(4,column, 'Switched Off', newStyle)
- 
 
 963 
    worksheet.write(5,column, 'Successful', newStyle)
- 
 
 964 
    worksheet.write(6,column, 'Contactable Data', newStyle)
- 
 
 965 
    worksheet.write(7,column, 'Non Contactable Data', newStyle)
- 
 
 966 
    worksheet.write(8,column, 'Agents Logged In', style)
- 
 
 967 
    worksheet.write(9,column, 'Average Login Time (In Hrs)', style)
- 
 
 968 
    worksheet.write(10,column, 'Total Dialed Out', style)
- 
 
 969 
    worksheet.write(11,column, 'Average Dialed Out per agent', style)
- 
 
 970 
    worksheet.write(12,column, 'Average Call Duration (In Hrs)', style)
- 
 
 971 
    worksheet.write(13,column, 'Average Handling Time (In Hrs)', style)
- 
 
 972 
    worksheet.write(14,column, 'Average Idle Time (In Hrs)', style)
957 
    if len(result)==0:
 973 
    if len(result)==0:
958 
        print 'No Data'
 974 
        print 'No Data'
959 
        pass
 975 
        pass
960 
    else:
 976 
    else:
961 
        worksheet.write(0,0,'Call Disposition Type',style)
 - 
 
962 
        worksheet.write(0,1,'Count',style)
 977
963 
        worksheet.write(1, column, 'Call Later', newStyle)
 - 
 
964 
        worksheet.write(2,column, 'Ringing No Answer', newStyle)
 - 
 
965 
        worksheet.write(3,column, 'Not Reachable', newStyle)
 - 
 
966 
        worksheet.write(4,column, 'Switched Off', newStyle)
 - 
 
967 
        worksheet.write(5,column, 'Successful', newStyle)
 - 
 
968 
        worksheet.write(6,column, 'Contactable Data', newStyle)
 - 
 
969 
        worksheet.write(7,column, 'Non Contactable Data', newStyle)
 - 
 
970 
        worksheet.write(8,column, 'Agents Logged In', style)
 - 
 
971 
        worksheet.write(9,column, 'Average Login Time (In Hrs)', style)
 - 
 
972 
        worksheet.write(10,column, 'Total Dialed Out', style)
 - 
 
973 
        worksheet.write(11,column, 'Average Dialed Out per agent', style)
 - 
 
974 
        worksheet.write(12,column, 'Average Call Duration (In Hrs)', style)
 - 
 
975 
        worksheet.write(13,column, 'Average Handling Time (In Hrs)', style)
 - 
 
976 
        worksheet.write(14,column, 'Average Idle Time (In Hrs)', style)
 - 
 
977
978
978 
        contactableData=0
 979 
        contactableData=0
979 
        nonContactableData=0
 980 
        nonContactableData=0
980 
        totalDispositions=0
 981 
        totalDispositions=0
981 
        for r in result:
 982 
        for r in result: