Subversion Repositories SmartDukaan

'''
Created on Mar 13, 2015

@author: amit
'''
from datetime import date, datetime, timedelta
from dtr.storage.Mysql import getOrdersAfterDate
from email import encoders
from email.mime.base import MIMEBase
from email.mime.multipart import MIMEMultipart
from email.mime.text import MIMEText
from pymongo.mongo_client import MongoClient
import MySQLdb
import smtplib
import time
import xlwt

client = MongoClient('mongodb://localhost:27017/')

SENDER = "cnc.center@shop2020.in"
PASSWORD = "5h0p2o2o"
SUBJECT = "DTR User Segmentation report for " + date.today().isoformat()
SMTP_SERVER = "smtp.gmail.com"
SMTP_PORT = 587    

def generateFlipkartReco():
    pass
def generateSnapDealReco():
    curs = getOrdersAfterDate(datetime.now() - timedelta(days=10), 3)
    db = client.Dtr
    
    workbook = xlwt.Workbook()
    worksheet = workbook.add_sheet("Snapdeal Reco")
    boldStyle = xlwt.XFStyle()
    f = xlwt.Font()
    f.bold = True
    boldStyle.font = f
    column = 0
    row = 0
        
    worksheet.write(row, 0, 'Order Id', boldStyle)
    worksheet.write(row, 1, 'User Id', boldStyle)
    worksheet.write(row, 2, 'Merchant Order Id', boldStyle)
    worksheet.write(row, 3, 'Product Title', boldStyle)
    worksheet.write(row, 4, 'Price', boldStyle)
    worksheet.write(row, 5, 'Quantity', boldStyle)
    worksheet.write(row, 6, 'Status', boldStyle)
    worksheet.write(row, 7, 'Status', boldStyle)
    worksheet.write(row, 8, 'Cashback Status', boldStyle)
    worksheet.write(row, 9, 'Our CashBack', boldStyle)
    worksheet.write(row, 10, 'Sale Date', boldStyle)
    worksheet.write(row, 11, 'SubtagId', boldStyle)
    worksheet.write(row, 12, 'Ad Id', boldStyle)
    worksheet.write(row, 13, 'Affiliate PayOut', boldStyle)
    worksheet.write(row, 14, 'Affiliate Sale Amount', boldStyle)
    worksheet.write(row, 15, 'Affiliate Sale Date', boldStyle)
    
    for row1 in curs:
        orderId = row1[0]
        order = db.merchantOrder.find_one({"orderId":orderId})
        if order is None:
            continue
        print order["subTagId"]
        print order
        saleTime = int(time.mktime(datetime.strptime(order['placedOn'], "%b %d, %Y, %I:%M %p").timetuple()))
        saleTime1 = int(time.mktime((datetime.strptime(order['placedOn'], "%b %d, %Y, %I:%M %p") + timedelta(seconds=-60)).timetuple()))
        aff = list(db.snapdealOrderAffiliateInfo.find({"subTagId":order["subTagId"]}))

        for subOrder in order['subOrders']: 
            row += 1
            worksheet.write(row, 0, orderId)
            worksheet.write(row, 1, row1[1])
            worksheet.write(row, 2, order['merchantOrderId'])
            worksheet.write(row, 3, subOrder['productTitle'])
            worksheet.write(row, 4, subOrder['amountPaid'])
            worksheet.write(row, 5, subOrder['quantity'])
            worksheet.write(row, 6, subOrder['status'])
            worksheet.write(row, 7, subOrder['detailedStatus'])
            worksheet.write(row, 8, subOrder['cashBackStatus'])
            worksheet.write(row, 9, subOrder['cashBackAmount'])
            worksheet.write(row, 10, subOrder['placedOn'])
            worksheet.write(row, 11, order['subTagId'])
            if len(aff)>0:
                worksheet.write(row, 12, aff[0]['adId'])
                worksheet.write(row, 13, aff[0]['payOut'])
                worksheet.write(row, 14, aff[0]['saleAmount'])
                worksheet.write(row, 15, aff[0]['saleDate'])
        workbook.save("snapdealreco.xls")
            
def sendmail(email, message, title):
    if email == "":
        return
    mailServer = smtplib.SMTP(SMTP_SERVER, SMTP_PORT)
    mailServer.ehlo()
    mailServer.starttls()
    mailServer.ehlo()
    
    # Create the container (outer) email message.
    msg = MIMEMultipart()
    msg['Subject'] = title
    msg.preamble = title
    html_msg = MIMEText(message, 'html')
    msg.attach(html_msg)
    
    #snapdeal more to be added here
    snapdeal = MIMEBase('application', 'vnd.ms-excel')
    snapdeal.set_payload(file("snapdealreco.xls").read())
    encoders.encode_base64(snapdeal)
    snapdeal.add_header('Content-Disposition', 'attachment;filename=snapdealreco.xls')
    msg.attach(snapdeal)


    email.append('amit.gupta@shop2020.in')
    MAILTO = email 
    mailServer.login(SENDER, PASSWORD)
    mailServer.sendmail(PASSWORD, MAILTO, msg.as_string())

    
def main():
    generateSnapDealReco()
    sendmail(["amit.gupta@shop2020.in"], "", "DTR Affiliate Reco")

if __name__ == '__main__':
    main()