Subversion Repositories SmartDukaan

Rev

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

Rev 14649 Rev 14650
Line 3... Line 3...
3 
 
 3 
 
4 
@author: amit
 4 
@author: amit
5 
'''
 5 
'''
6 
from datetime import date, datetime, timedelta
 6 
from datetime import date, datetime, timedelta
7 
from dtr.main import Store, sourceMap
 7 
from dtr.main import Store, sourceMap
- 
 
 8 
from dtr.reports.amazonreco import generateAmazonReco
8 
from dtr.storage import Mysql
 9 
from dtr.storage import Mysql
9 
from dtr.storage.Mysql import getOrdersAfterDate, getOrdersByTag
 10 
from dtr.storage.Mysql import getOrdersAfterDate, getOrdersByTag
10 
from email import encoders
 11 
from email import encoders
11 
from email.mime.base import MIMEBase
 12 
from email.mime.base import MIMEBase
12 
from email.mime.multipart import MIMEMultipart
 13 
from email.mime.multipart import MIMEMultipart
Line 30... Line 31...
30 
SMTP_PORT = 587
31 
SMTP_PORT = 587
31 
 
 32 
 
32 
XLS_FILENAME = "snapdealaffiliatereco.xls"
 33 
XLS_FILENAME = "snapdealaffiliatereco.xls"
33 
XLS_O_FILENAME = "allorders.xls"
 34 
XLS_O_FILENAME = "allorders.xls"
34 
XLS_F_FILENAME = "flipkartaffiliatereco.xls"
 35 
XLS_F_FILENAME = "flipkartaffiliatereco.xls"
- 
 
 36 
XLS_A_FILENAME = "amazonaffiliatereco.xls"
35 
boldStyle = xlwt.XFStyle()
 37 
boldStyle = xlwt.XFStyle()
36 
f = xlwt.Font()
 38 
f = xlwt.Font()
37 
f.bold = True
 39 
f.bold = True
38 
boldStyle.font = f
 40 
boldStyle.font = f
39 
i = -1
 41 
i = -1
Line 490... Line 492...
490
492
491 
    db=client.Dtr
 493 
    db=client.Dtr
492 
    results = Mysql.fetchResult('''
 494 
    results = Mysql.fetchResult('''
493 
        select ow.*, u.username, crm1.order_count, u.referrer from order_view ow left join users u on u.id = ow.user_id left join (select user_id, count(*) as order_count from order_view where status = 'ORDER_CREATED'  group by user_id) as crm1 on ow.user_id = crm1.user_id where lower(u.referrer) not like 'emp%'
495 
        select ow.*, u.username, crm1.order_count, u.referrer from order_view ow left join users u on u.id = ow.user_id left join (select user_id, count(*) as order_count from order_view where status = 'ORDER_CREATED'  group by user_id) as crm1 on ow.user_id = crm1.user_id where lower(u.referrer) not like 'emp%'
494 
        ''',)
 496 
        ''',)
495 
    orders = []
 - 
 
496 
    orders.append("")
 - 
 
497 
    orderH = []
 - 
 
498 
    row = 0
 497 
    row = 0
499 
    i=-1
 498 
    i=-1
500 
    worksheet.write(row, inc(), 'User Id', boldStyle)
 499 
    worksheet.write(row, inc(), 'User Id', boldStyle)
501 
    worksheet1.write(row, i, 'User Id', boldStyle)
 500 
    worksheet1.write(row, i, 'User Id', boldStyle)
502 
    sh1.write(row, i, 'User Id', boldStyle)
 501 
    sh1.write(row, i, 'User Id', boldStyle)
Line 634... Line 633...
634 
    sheet.write(0, inc(), )
 633 
    sheet.write(0, inc(), )
635 
def main():
 634 
def main():
636
635
637 
    generateSnapDealReco()
 636 
    generateSnapDealReco()
638 
    generateFlipkartReco()
 637 
    generateFlipkartReco()
- 
 
 638 
    generateAmazonReco(XLS_A_FILENAME)
639 
    getUserOrders()
 639 
    getUserOrders()
640 
    sendmail(["amit.gupta@shop2020.in", "rajneesh.arora@saholic.com"], "", "Affiliate Reco", XLS_FILENAME, XLS_F_FILENAME)
 640 
    sendmail(["amit.gupta@shop2020.in"], "", "Affiliate Reco", XLS_FILENAME, XLS_F_FILENAME, XLS_A_FILENAME)
641 
    sendmail(["amit.gupta@shop2020.in", "rajneesh.arora@saholic.com", "chaitnaya.vats@saholic.com", "manoj.kumar@saholic.com"], "", "All DTR Orders", XLS_O_FILENAME)
 641 
    #sendmail(["amit.gupta@shop2020.in", "rajneesh.arora@saholic.com", "chaitnaya.vats@saholic.com", "manoj.kumar@saholic.com"], "", "All DTR Orders", XLS_O_FILENAME)
642 
 
 642 
 
643 
if __name__ == '__main__':
 643 
if __name__ == '__main__':
644 
    main()
 644 
    main()
645
645
646 

            646