Subversion Repositories SmartDukaan

Rev

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

Rev 15401 Rev 15463
Line 3... Line 3...
3
 
3
 
4
@author: amit
4
@author: amit
5
'''
5
'''
6
 
6
 
7
from datetime import datetime, timedelta, date
7
from datetime import datetime, timedelta, date
-
 
8
from dtr.reports.affiliatereco import sendmail
8
import MySQLdb
9
import MySQLdb
9
import copy
10
import copy
10
import xlwt
11
import xlwt
11
 
12
 
12
 
13
 
Line 403... Line 404...
403
    freshSheet = workbook.add_sheet("Fresh Call Summary")
404
    freshSheet = workbook.add_sheet("Fresh Call Summary")
404
    followupSheet = workbook.add_sheet("Followup Call Summary")
405
    followupSheet = workbook.add_sheet("Followup Call Summary")
405
    setWorksheetTemplate(freshSheet, followupSheet)
406
    setWorksheetTemplate(freshSheet, followupSheet)
406
    populateFreshSheet(freshSheet)
407
    populateFreshSheet(freshSheet)
407
    populateFollowupSheet(followupSheet)
408
    populateFollowupSheet(followupSheet)
408
                
-
 
409
        
-
 
410
    workbook.save("/tmp/fresh.xls")
409
    workbook.save("crmacquisition.xls")
411
        
-
 
-
 
410
    sendmail(["amit.gupta@shop2020.in", "rajneesh.arora@saholic.com", "amit.sirohi@shop2020.in"], "", "CRM Acquision Report", "crmacquisition.xls")        
412
def main():
411
def main():
413
    generateCrmAcquisitionReport()
412
    generateCrmAcquisitionReport()
414
 
413
 
415
if __name__ == '__main__':
414
if __name__ == '__main__':
416
    main()
415
    main()