Subversion Repositories SmartDukaan

from datetime import datetime, timedelta
from dtr.storage.DataService import user_app_cashbacks
import sys
import traceback
import getopt
from dtr.main import tprint, refundToWallet
import time
from dtr.storage import DataService
from elixir import *
import pymongo
from dtr.utils import utils

DataService.initialize(db_hostname="localhost") 
con=None

def get_mongo_connection(host='localhost', port=27017):
    global con
    if con is None:
        print "Establishing connection %s host and port %d" %(host,port)
        try:
            con = pymongo.MongoClient(host, port)
        except Exception, e:
            print e
            return None
    return con

def settleAppOffersPayBack(runtype='dry'):
    if runtype == 'live':
        print 'Live Run:- Amount will be credited in the specific users'
        currentTimestamp = datetime.today()
        currentMonth = currentTimestamp.month
        currentDay = currentTimestamp.day
        currentYear = currentTimestamp.year
        sevenDaysBeforeTimestamp = datetime.today() - timedelta(days=7)
        sevenDaysBeforeYear = sevenDaysBeforeTimestamp.year
        if currentYear > sevenDaysBeforeYear:
            currentMonth = sevenDaysBeforeTimestamp.month
            currentDay = sevenDaysBeforeTimestamp.day
            currentYear = sevenDaysBeforeYear
            fortNight = (currentMonth - 1)*2 + (currentDay/15)+1
        else:
            fortNight = (currentMonth - 1)*2 + (currentDay/15)
            
        print "FortNight: ", fortNight, "Year: ", currentYear
        
        userCashbacksToBeCredited = user_app_cashbacks.query.filter(user_app_cashbacks.user_id>0).filter(user_app_cashbacks.status=='Approved').filter(user_app_cashbacks.fortnightOfYear<fortNight).filter(user_app_cashbacks.yearVal==currentYear).all()
        userCashbacksMap = {}
        for userCashback in userCashbacksToBeCredited:
            if userCashback.user_id >0:
                if userCashbacksMap.has_key(userCashback.user_id):
                    cashBackAmount = userCashbacksMap.get(userCashback.user_id) + userCashback.amount
                    userCashbacksMap[userCashback.user_id] = cashBackAmount
                else:
                    userCashbacksMap[userCashback.user_id] = userCashback.amount
        datetimeNow = datetime.now() 
        batchId = int(time.mktime(datetimeNow.timetuple()))
        if(refundToWallet(batchId, userCashbacksMap)):
            for userCashback in userCashbacksToBeCredited:
                userCashback.status = 'Credited'
                userCashback.batchCreditId = batchId
                userCashback.creditedDate = datetimeNow.date()
            session.commit()
            
            for key, value in userCashbacksMap.iteritems():
                print 'User Id:- ', key, ' Credited Amount:- ', value
                get_mongo_connection().Dtr.refund.insert({"userId": key, "batch":batchId, "userAmount":value, "timestamp":datetime.strftime(datetimeNow,"%Y-%m-%d %H:%M:%S"), "type":utils.CREDIT_TYPE_APP})
                get_mongo_connection().Dtr.user.update({"userId":key}, {"$inc": { "credited": value, utils.CREDIT_TYPE_APP:value}}, upsert=True)
        else:
            print 'Refund Process have been failed'
    else:
        print 'Dry Run:- Only showing user map for which cashback have been updated'
        currentTimestamp = datetime.today()
        currentMonth = currentTimestamp.month
        currentDay = currentTimestamp.day
        currentYear = currentTimestamp.year
        sevenDaysBeforeTimestamp = datetime.today() - timedelta(days=7)
        sevenDaysBeforeYear = sevenDaysBeforeTimestamp.year
        if currentYear > sevenDaysBeforeYear:
            currentMonth = sevenDaysBeforeTimestamp.month
            currentDay = sevenDaysBeforeTimestamp.day
            currentYear = sevenDaysBeforeYear
            fortNight = (currentMonth - 1)*2 + (currentDay/15)+1
        else:
            fortNight = (currentMonth - 1)*2 + (currentDay/15)
            
        print "FortNight: ", fortNight, "Year: ", currentYear
        
        userCashbacksToBeCredited = user_app_cashbacks.query.filter(user_app_cashbacks.user_id>0).filter(user_app_cashbacks.status=='Approved').filter(user_app_cashbacks.fortnightOfYear<fortNight).filter(user_app_cashbacks.yearVal==currentYear).all()
        userCashbacksMap = {}
        for userCashback in userCashbacksToBeCredited:
            if userCashback.user_id >0:
                if userCashbacksMap.has_key(userCashback.user_id):
                    cashBackAmount = userCashbacksMap.get(userCashback.user_id) + userCashback.amount
                    userCashbacksMap[userCashback.user_id] = cashBackAmount
                else:
                    userCashbacksMap[userCashback.user_id] = userCashback.amount
        
        datetimeNow = datetime.now() 
        batchId = int(time.mktime(datetimeNow.timetuple()))
        print 'BatchId:- ', batchId
        
        for key, value in userCashbacksMap.iteritems():
            print 'User Id:- ', key, ' Cashback Value:- ', value
        
def main(argv):
    runtype = 'dry'
    try:
        opts, args = getopt.getopt(argv,"ht:",["runtype="])
    except getopt.GetoptError:
        print 'settlementcron.py -t <dry|live>'
        sys.exit(2)
    for opt, arg in opts:
        if opt == '-h':
            print 'settlementcron.py -t <dry|live>'
            sys.exit()
        elif opt == '-t':
            runtype = arg
        
        tprint("Settling payback", runtype)
        try:
            settleAppOffersPayBack(runtype)
        except:
            tprint("Error")
            traceback.print_exc()
    session.close()
if __name__=='__main__':
    main(sys.argv[1:])