Subversion Repositories SmartDukaan

Rev

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

Rev 20046 Rev 20172
Line 75... Line 75...
75 
        cursor.execute(buyergroup)
 75 
        cursor.execute(buyergroup)
76 
        result = cursor.fetchall()
 76 
        result = cursor.fetchall()
77 
        parseResultToSheet(worksheet,result, "Buyer Groups", nextrow)
 77 
        parseResultToSheet(worksheet,result, "Buyer Groups", nextrow)
78
78
79 
        workbook.save("/tmp/cohortreport.xls")
 79 
        workbook.save("/tmp/cohortreport.xls")
80 
        sendmail(['rajneesh.arora@saholic.com','rajender.singh@shop2020.in'], "", "/tmp/cohortreport.xls", "Report for Cohort analysis")
 80 
        sendmail(['rajneesh.arora@saholic.com','rajender.singh@shop2020.in','khushal.bhatia@saholic.com'], "", "/tmp/cohortreport.xls", "Report for Cohort analysis")
81 
    finally:
 81 
    finally:
82 
        conn.close()
 82 
        conn.close()
83 
 
 83 
 
84 
def parseResultToSheet(sheet, result, title, startrow):
 84 
def parseResultToSheet(sheet, result, title, startrow):
85 
    sheet.write(startrow, 0, title, boldStyle)
 85 
    sheet.write(startrow, 0, title, boldStyle)