| 22059 |
amit.gupta |
1 |
'''
|
|
|
2 |
Created on Apr 12, 2016
|
|
|
3 |
|
|
|
4 |
@author: amit
|
|
|
5 |
'''
|
|
|
6 |
from datetime import datetime
|
|
|
7 |
from elixir import *
|
|
|
8 |
from random import randint
|
|
|
9 |
from shop2020.clients.CatalogClient import CatalogClient
|
|
|
10 |
from shop2020.clients.InventoryClient import InventoryClient
|
|
|
11 |
from shop2020.clients.PurchaseClient import PurchaseClient
|
|
|
12 |
from shop2020.clients.TransactionClient import TransactionClient
|
|
|
13 |
from shop2020.clients.UserClient import UserClient
|
|
|
14 |
from shop2020.model.v1.catalog.impl import DataService
|
|
|
15 |
from shop2020.model.v1.catalog.impl.DataService import CentralGstMaster, \
|
|
|
16 |
StateGstMaster
|
|
|
17 |
from shop2020.thriftpy.model.v1.order.ttypes import TransactionStatus
|
|
|
18 |
from sqlalchemy import desc, asc
|
|
|
19 |
from sqlalchemy.orm import aliased
|
|
|
20 |
from sqlalchemy.sql.expression import or_, distinct, func, and_, exists
|
|
|
21 |
from sqlalchemy.sql.functions import now
|
|
|
22 |
|
|
|
23 |
|
|
|
24 |
|
|
|
25 |
def addHsnCodes():
|
|
|
26 |
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}
|
|
|
27 |
|
|
|
28 |
for hsnCode, rate in hsnCodesRateMap.iteritems():
|
|
|
29 |
cgs = session.query(CentralGstMaster).filter(CentralGstMaster.hsnCode==hsnCode).filter(CentralGstMaster.gstPercent==rate).first()
|
|
|
30 |
if cgs is None:
|
|
|
31 |
cgs = CentralGstMaster()
|
|
|
32 |
cgs.hsnCode = hsnCode
|
|
|
33 |
cgs.gstPercent = rate
|
|
|
34 |
cgs.startDate = datetime.now()
|
|
|
35 |
for i in range(37):
|
|
|
36 |
sgst = rate/2
|
|
|
37 |
cgst = rate/2
|
|
|
38 |
sgs = session.query(StateGstMaster).filter(StateGstMaster.hsnCode==hsnCode).filter(StateGstMaster.sgstPercent==sgst).filter(StateGstMaster.cgstPercent==cgst).filter(StateGstMaster.stateId==i).first()
|
|
|
39 |
if sgs is None:
|
|
|
40 |
sgs = StateGstMaster()
|
|
|
41 |
sgs.sgstPercent = sgst
|
|
|
42 |
sgs.cgstPercent = cgst
|
|
|
43 |
sgs.hsnCode = hsnCode
|
|
|
44 |
sgs.stateId = i
|
|
|
45 |
sgs.startDate = datetime.now()
|
|
|
46 |
|
|
|
47 |
session.commit()
|
|
|
48 |
session.close()
|
|
|
49 |
#c = CatalogClient().get_client()
|
|
|
50 |
#print c.getGstRatesByState(0)
|
|
|
51 |
#print c.getInterStateGstRates()
|
|
|
52 |
#print c.getHsnCodesByCategory(10006)
|
|
|
53 |
#
|
|
|
54 |
#ic = InventoryClient().get_client()
|
|
|
55 |
#print ic.getStateMaster()
|
|
|
56 |
#
|
|
|
57 |
#
|
|
|
58 |
#pc = PurchaseClient().get_client()
|
|
|
59 |
#print pc.getPurchaseOrder(22141)
|
|
|
60 |
|
|
|
61 |
|
|
|
62 |
#uc = UserClient().get_client()
|
|
|
63 |
#print uc.getCounterByUserId(120398953)
|
|
|
64 |
|
|
|
65 |
def main():
|
|
|
66 |
pass
|
|
|
67 |
#DataService.initialize('catalog', 'localhost', False)
|
|
|
68 |
#addHsnCodes()
|
|
|
69 |
|
|
|
70 |
#tc = TransactionClient().get_client()
|
|
|
71 |
#tc.changeTransactionStatus(699979, TransactionStatus.COD_IN_PROCESS, "COD in Process", 0, 0, 1)
|
|
|
72 |
#tc.verifyOrderForTransaction(699983)
|
|
|
73 |
#tc.acceptOrder(748108)
|
|
|
74 |
#tc.addBillingDetailsForGrouppedOrders([748108], 'AMIT2', {748108:'1'}, {748108:['443423432431', '443423432432']}, {}, 'dl-ad-adonis', 1, 0, False, 'BulkInvoice')
|
|
|
75 |
#order_ids, invoice_number, itemNumbersMap, serialNumbersMap, {}, 'mp-mmx-admin', 1, 0, False, 'Individual'
|
|
|
76 |
|
|
|
77 |
tc = TransactionClient().get_client()
|
|
|
78 |
print tc.getLatestUserWalletHistory(483649, 0, 20)
|
|
|
79 |
|
|
|
80 |
|
|
|
81 |
if __name__ == "__main__":
|
|
|
82 |
main()
|