Subversion Repositories SmartDukaan

'''
Created on Apr 12, 2016

@author: amit
'''
from datetime import datetime
from elixir import *
from random import randint
from shop2020.clients.CatalogClient import CatalogClient
from shop2020.clients.InventoryClient import InventoryClient
from shop2020.clients.PurchaseClient import PurchaseClient
from shop2020.clients.TransactionClient import TransactionClient
from shop2020.clients.UserClient import UserClient
from shop2020.model.v1.catalog.impl import DataService
from shop2020.model.v1.catalog.impl.DataService import CentralGstMaster, \
    StateGstMaster
from shop2020.thriftpy.model.v1.order.ttypes import TransactionStatus
from sqlalchemy import desc, asc
from sqlalchemy.orm import aliased
from sqlalchemy.sql.expression import or_, distinct, func, and_, exists
from sqlalchemy.sql.functions import now



def addHsnCodes():
    hsnCodesRateMap={'39269099':28,'39269099':28,'42022190':28,'84713090':18,'85044090':28,'85171210':12,'85171290':12,'85176290':18,'85182900':18,'85183000':18,'85235100':28,'85441990':28}
    
    for hsnCode, rate in hsnCodesRateMap.iteritems():
        cgs = session.query(CentralGstMaster).filter(CentralGstMaster.hsnCode==hsnCode).filter(CentralGstMaster.gstPercent==rate).first()
        if cgs is None:
            cgs = CentralGstMaster()
            cgs.hsnCode = hsnCode
            cgs.gstPercent = rate
            cgs.startDate = datetime.now()
        for i in range(37):
            sgst = rate/2
            cgst = rate/2
            sgs = session.query(StateGstMaster).filter(StateGstMaster.hsnCode==hsnCode).filter(StateGstMaster.sgstPercent==sgst).filter(StateGstMaster.cgstPercent==cgst).filter(StateGstMaster.stateId==i).first()
            if sgs is None:
                sgs = StateGstMaster()
                sgs.sgstPercent = sgst
                sgs.cgstPercent = cgst
                sgs.hsnCode = hsnCode
                sgs.stateId = i
                sgs.startDate = datetime.now()
        
    session.commit()
    session.close()
#c = CatalogClient().get_client()
#print c.getGstRatesByState(0)
#print c.getInterStateGstRates()
#print c.getHsnCodesByCategory(10006)
#
#ic = InventoryClient().get_client()
#print ic.getStateMaster()
#
#
#pc = PurchaseClient().get_client()
#print pc.getPurchaseOrder(22141)


#uc = UserClient().get_client()
#print uc.getCounterByUserId(120398953)

def main():
    pass
    #DataService.initialize('catalog', 'localhost', False)
    #addHsnCodes()

#tc = TransactionClient().get_client()
#tc.changeTransactionStatus(699979, TransactionStatus.COD_IN_PROCESS, "COD in Process", 0, 0, 1)
#tc.verifyOrderForTransaction(699983)
#tc.acceptOrder(748108)
#tc.addBillingDetailsForGrouppedOrders([748108], 'AMIT2', {748108:'1'}, {748108:['443423432431', '443423432432']}, {}, 'dl-ad-adonis', 1, 0, False, 'BulkInvoice')
                                        #order_ids, invoice_number, itemNumbersMap, serialNumbersMap, {}, 'mp-mmx-admin', 1, 0, False, 'Individual'

tc = TransactionClient().get_client()
print tc.getLatestUserWalletHistory(483649, 0, 20)
                                        
                                        
if __name__ == "__main__":
    main()