| Line 2127... |
Line 2127... |
| 2127 |
def __getOrderTaxType(order):
|
2127 |
def __getOrderTaxType(order):
|
| 2128 |
delhiPincodePrefix = "11";
|
2128 |
delhiPincodePrefix = "11";
|
| 2129 |
maharashtraPincodePrefix = ["40", "41", "42", "43", "44"];
|
2129 |
maharashtraPincodePrefix = ["40", "41", "42", "43", "44"];
|
| 2130 |
karnatakaPincodePrefix = ["56", "57", "58", "59"];
|
2130 |
karnatakaPincodePrefix = ["56", "57", "58", "59"];
|
| 2131 |
telenganaPincodes = ["500001","500002","500003","500004","500005","500006","500007","500008","500009","500010","500011","500012","500013","500014","500015","500016","500017","500018","500019","500020","500021","500022","500023","500024","500025","500026","500027","500028","500029","500030","500031","500032","500033","500034","500035","500036","500037","500038","500039","500040","500041","500042","500043","500044","500045","500046","500047","500048","500049","500050","500051","500052","500053","500054","500055","500056","500057","500058","500059","500060","500061","500062","500063","500064","500065","500066","500067","500068","500069","500070","500071","500072","500073","500074","500075","500076","500077","500078","500079","500080","500081","500082","500083","500084","500085","500086","500087","500088","500089","500090","500091","500092","500093","500094","500095","500096","500097","500098","500178","500409","501218","501301","501401","501510","501511","501512","502307","502319","517501","517502","517503","517505","517507","520001","520002","520003","520004","520005","520006","520007","520008","520009","520010","520011","520012","520013","520014","520015","521108","521225","522001","522002","522003","522004","522005","522006","522007","522019","522509","530001","530002","530003","530004","530005","530007","530008","530009","530010","530010","530011","530012","530013","530014","530015","530016","530017","530018","530020","530021","530022","530023","530024","530026","530027","530028","530029","530032","530035","530040","530041","530043","530044","530045","530046","531001","533101","533103","533104","533105"]
|
2131 |
telenganaPincodes = ["500001","500002","500003","500004","500005","500006","500007","500008","500009","500010","500011","500012","500013","500014","500015","500016","500017","500018","500019","500020","500021","500022","500023","500024","500025","500026","500027","500028","500029","500030","500031","500032","500033","500034","500035","500036","500037","500038","500039","500040","500041","500042","500043","500044","500045","500046","500047","500048","500049","500050","500051","500052","500053","500054","500055","500056","500057","500058","500059","500060","500061","500062","500063","500064","500065","500066","500067","500068","500069","500070","500071","500072","500073","500074","500075","500076","500077","500078","500079","500080","500081","500082","500083","500084","500085","500086","500087","500088","500089","500090","500091","500092","500093","500094","500095","500096","500097","500098","500178","500409","501218","501301","501401","501510","501511","501512","502307","502319","517501","517502","517503","517505","517507","520001","520002","520003","520004","520005","520006","520007","520008","520009","520010","520011","520012","520013","520014","520015","521108","521225","522001","522002","522003","522004","522005","522006","522007","522019","522509","530001","530002","530003","530004","530005","530007","530008","530009","530010","530010","530011","530012","530013","530014","530015","530016","530017","530018","530020","530021","530022","530023","530024","530026","530027","530028","530029","530032","530035","530040","530041","530043","530044","530045","530046","531001","533101","533103","533104","533105"]
|
| - |
|
2132 |
haryanaPincodes = ["133001","134003","123307","133205","125047","122005","131104","132111","121001","132038","134002","124411","132039","124505","124021","124521","132122","121105","133301","125021","132154","133005","123308","124105","125048","122101","124507","125028","131021","123413","124142","124110","125054"
|
| - |
|
2133 |
,"134007","124416","121004","132040","126145","125061","125026","125078","133201","124101","124304","125045","134118","126010","126011","125042","123025","123501","125032","123034","132108","124201","124409","124401","124503","131022","125053","124415","122102","135106","126008","124310","132140","133101","135102","123026","125022","133021","135101","124302","134107","125027","123306","125101","135103","124504","132034","171208","124542","122002","126153","125036","125025","124109","124424","132020","123412","125106","122106","132112","133202","124107","125058","124202","124202","124528","125102","121007","121001","121002","121005","121006","124408","123506","125050","132042","122104","122001","131101","123505","132114","124301","125103","132035","125001","123504","124423","125033","124404","121107","121103","132115","125004","125011","125002","121106","134109","132041","122016","132129","132107","124103","126102","135003","135002","126001","131023","124535","124314","134201","132130","123310","131024","125030","126101","132036","132001","132118","132025","124412","125085","125029","132027","124113","143512","125201","133105","126117","126133","133302","124530","123027","132021","133102","125057","123502","125038","124305","124114","124402","135105","135021","123103","123101","124144","123102","131028","132022","132119","132132","124514","124108","132037","124111","132113","124203","125052","123021","125104","125056","124506","125105","123309","124510","124106","124112","125005","125088","123029","124022","134205","133203","125041","124306","131027","133103","123001","122108","124145","131103","125037","125039","134012","123023","123028","123414","134203","126116","132106","132145","124104","124513","124531","132117","132024","122107","125077","131029","132103","126007","123035","132043","124417","121102","132104","132105","134011","123503","125003","176050","132128","132128","124205","126113","134102","134101","132131","132026","121104","131102","124001","132133","134204","132044","151301","126110","125076","131030","125051","123401","125067","124429","125043","124403","125055","131001","133204","126112","133104","124146","132023","132046","132101","124501","124303","123020","133206","123024","125044","132033","125046","132135","176206","134202","126114","125060","125049","124407","124430","122103","125075","132153","132116","122105","132136","121101","125031","126119","125040","126115","132124","133207","126009","125083","132137","124406"]
|
| 2132 |
|
2134 |
|
| 2133 |
|
2135 |
|
| 2134 |
if order.warehouse_id == 7 or order.warehouse_id == 9:
|
2136 |
if order.warehouse_id == 7 or order.warehouse_id == 9:
|
| 2135 |
if order.customer_pincode.startswith(delhiPincodePrefix):
|
2137 |
if order.customer_pincode.startswith(delhiPincodePrefix):
|
| 2136 |
return 0
|
2138 |
return 0
|
| Line 2145... |
Line 2147... |
| 2145 |
for knkPincodePrefix in karnatakaPincodePrefix:
|
2147 |
for knkPincodePrefix in karnatakaPincodePrefix:
|
| 2146 |
if order.customer_pincode.startswith(knkPincodePrefix):
|
2148 |
if order.customer_pincode.startswith(knkPincodePrefix):
|
| 2147 |
return 0
|
2149 |
return 0
|
| 2148 |
return 1
|
2150 |
return 1
|
| 2149 |
if order.warehouse_id == 3298:
|
2151 |
if order.warehouse_id == 3298:
|
| - |
|
2152 |
if order.customer_pincode in haryanaPincodes:
|
| - |
|
2153 |
return 0
|
| - |
|
2154 |
return 1
|
| - |
|
2155 |
if order.warehouse_id == 7441:
|
| 2150 |
for pincode in telenganaPincodes:
|
2156 |
for pincode in telenganaPincodes:
|
| 2151 |
if order.customer_pincode == pincode:
|
2157 |
if order.customer_pincode == pincode:
|
| 2152 |
return 0
|
2158 |
return 0
|
| 2153 |
return 1
|
2159 |
return 1
|
| 2154 |
return 0
|
2160 |
return 0
|
| Line 8749... |
Line 8755... |
| 8749 |
if not orders:
|
8755 |
if not orders:
|
| 8750 |
orders = []
|
8756 |
orders = []
|
| 8751 |
return orders
|
8757 |
return orders
|
| 8752 |
|
8758 |
|
| 8753 |
def add_billing_details_for_groupped_orders(orderIds, invoice_number, itemNumbersMap, serialNumbersMap, freebieWarehouseIdMap, billed_by, jacketNumber, billingType, authorize, invoiceType):
|
8759 |
def add_billing_details_for_groupped_orders(orderIds, invoice_number, itemNumbersMap, serialNumbersMap, freebieWarehouseIdMap, billed_by, jacketNumber, billingType, authorize, invoiceType):
|
| - |
|
8760 |
# print 'orderIds',orderIds
|
| - |
|
8761 |
# print 'invoice_number', invoice_number
|
| - |
|
8762 |
# print 'itemNumbersMap', itemNumbersMap
|
| - |
|
8763 |
# print 'serialNumbersMap', serialNumbersMap
|
| - |
|
8764 |
# print 'freebieWarehouseIdMap', freebieWarehouseIdMap
|
| - |
|
8765 |
# print 'billed_by', billed_by
|
| - |
|
8766 |
# print 'jacketNumber', jacketNumber
|
| - |
|
8767 |
# print 'billingType', billingType
|
| - |
|
8768 |
# print 'authorize', authorize
|
| - |
|
8769 |
# print 'invoiceType', invoiceType
|
| 8754 |
''' Check for Biller'''
|
8770 |
''' Check for Biller'''
|
| 8755 |
if billed_by is None or billed_by.strip() == "":
|
8771 |
if billed_by is None or billed_by.strip() == "":
|
| 8756 |
raise TransactionServiceException(110, "Invalid Biller")
|
8772 |
raise TransactionServiceException(110, "Invalid Biller")
|
| 8757 |
|
8773 |
|
| 8758 |
ordersList = []
|
8774 |
ordersList = []
|
| Line 8870... |
Line 8886... |
| 8870 |
|
8886 |
|
| 8871 |
lineitem.item_number = itemNumbers[0]
|
8887 |
lineitem.item_number = itemNumbers[0]
|
| 8872 |
serialNumbers = serialNumbersMap.get(order.id)
|
8888 |
serialNumbers = serialNumbersMap.get(order.id)
|
| 8873 |
|
8889 |
|
| 8874 |
if serialNumbers:
|
8890 |
if serialNumbers:
|
| 8875 |
finalSerialNo =''
|
8891 |
if lineitem.serial_number:
|
| 8876 |
for serialNumber in serialNumbers:
|
8892 |
serialNumbers.insert(0, lineitem.serial_number)
|
| 8877 |
finalSerialNo = finalSerialNo +','+ serialNumber
|
- |
|
| 8878 |
|
- |
|
| 8879 |
finalSerialNo = finalSerialNo[1:]
|
- |
|
| 8880 |
|
- |
|
| 8881 |
if lineitem.serial_number is None:
|
- |
|
| 8882 |
lineitem.serial_number = finalSerialNo
|
8893 |
lineitem.serial_number = ','.join(serialNumbers)
|
| 8883 |
else:
|
- |
|
| 8884 |
lineitem.serial_number = lineitem.serial_number + ',' + finalSerialNo
|
- |
|
| 8885 |
order.status = OrderStatus.BILLED
|
8894 |
order.status = OrderStatus.BILLED
|
| 8886 |
order.statusDescription = "Order Billed"
|
8895 |
order.statusDescription = "Order Billed"
|
| 8887 |
order.billing_timestamp = datetime.datetime.now()
|
8896 |
order.billing_timestamp = datetime.datetime.now()
|
| 8888 |
order.billed_by = billed_by
|
8897 |
order.billed_by = billed_by
|
| 8889 |
|
8898 |
|
| Line 9249... |
Line 9258... |
| 9249 |
|
9258 |
|
| 9250 |
|
9259 |
|
| 9251 |
for order in ordersList:
|
9260 |
for order in ordersList:
|
| 9252 |
if billingType == BillingType.OURS:
|
9261 |
if billingType == BillingType.OURS:
|
| 9253 |
scanList = orderscansMap.get(order.id)
|
9262 |
scanList = orderscansMap.get(order.id)
|
| - |
|
9263 |
#print order.id
|
| - |
|
9264 |
#print scanList
|
| 9254 |
inventoryItemList = orderInventoryItemMap.get(order.id)
|
9265 |
inventoryItemList = orderInventoryItemMap.get(order.id)
|
| 9255 |
fulfillmentWarehouse = orderFulfilmentWarehouseMap.get(order.id)
|
9266 |
fulfillmentWarehouse = orderFulfilmentWarehouseMap.get(order.id)
|
| 9256 |
lineItem = order.lineitems[0]
|
9267 |
lineItem = order.lineitems[0]
|
| 9257 |
|
9268 |
|
| 9258 |
whCursor = warehouseDbConnection.cursor()
|
9269 |
whCursor = warehouseDbConnection.cursor()
|
| Line 11085... |
Line 11096... |
| 11085 |
#Seller would be used to get tin number
|
11096 |
#Seller would be used to get tin number
|
| 11086 |
def __get_seller(warehouse_id):
|
11097 |
def __get_seller(warehouse_id):
|
| 11087 |
#As of now we have hardcoded the company and
|
11098 |
#As of now we have hardcoded the company and
|
| 11088 |
#seller would be returned on basis warehouse and company
|
11099 |
#seller would be returned on basis warehouse and company
|
| 11089 |
#Seller changed to HSSPL. Effective Aug-1-2016 - Amit Gupta
|
11100 |
#Seller changed to HSSPL. Effective Aug-1-2016 - Amit Gupta
|
| - |
|
11101 |
#New Organisation has been added to it.
|
| - |
|
11102 |
if warehouse_id ==7441:
|
| - |
|
11103 |
orgId=4
|
| - |
|
11104 |
else:
|
| 11090 |
orgId=3
|
11105 |
orgId=3
|
| 11091 |
(sellerId,) = session.query(Seller.id).join((SellerWarehouse, Seller.id==SellerWarehouse.seller_id)).filter(Seller.organisation_id==orgId).filter(SellerWarehouse.warehouse_id==warehouse_id).first()
|
11106 |
(sellerId,) = session.query(Seller.id).join((SellerWarehouse, Seller.id==SellerWarehouse.seller_id)).filter(Seller.organisation_id==orgId).filter(SellerWarehouse.warehouse_id==warehouse_id).first()
|
| 11092 |
return sellerId
|
11107 |
return sellerId
|
| 11093 |
|
11108 |
|
| 11094 |
def add_shipment_delay(shipmentDelayDetail):
|
11109 |
def add_shipment_delay(shipmentDelayDetail):
|
| 11095 |
returnList = []
|
11110 |
returnList = []
|
| Line 11109... |
Line 11124... |
| 11109 |
|
11124 |
|
| 11110 |
#Buyer can be anyone based on logic
|
11125 |
#Buyer can be anyone based on logic
|
| 11111 |
def __get_buyer(warehouse_id):
|
11126 |
def __get_buyer(warehouse_id):
|
| 11112 |
#As of now we have hardcoded the company and
|
11127 |
#As of now we have hardcoded the company and
|
| 11113 |
#seller would be returned on basis warehouse and company
|
11128 |
#seller would be returned on basis warehouse and company
|
| - |
|
11129 |
if warehouse_id ==7441:
|
| - |
|
11130 |
orgId=4
|
| - |
|
11131 |
else:
|
| 11114 |
orgId=1
|
11132 |
orgId=1
|
| - |
|
11133 |
|
| 11115 |
buyerId=None
|
11134 |
buyerId=None
|
| 11116 |
result = session.query(Seller.id).join((SellerWarehouse, Seller.id==SellerWarehouse.seller_id)).filter(Seller.organisation_id==orgId).filter(SellerWarehouse.warehouse_id==warehouse_id).first()
|
11135 |
result = session.query(Seller.id).join((SellerWarehouse, Seller.id==SellerWarehouse.seller_id)).filter(Seller.organisation_id==orgId).filter(SellerWarehouse.warehouse_id==warehouse_id).first()
|
| 11117 |
if result:
|
11136 |
if result:
|
| 11118 |
buyerId = result[0]
|
11137 |
buyerId = result[0]
|
| 11119 |
return buyerId
|
11138 |
return buyerId
|
| Line 11137... |
Line 11156... |
| 11137 |
buyerInfo.address = to_t_warehouse_address(addressMapping)
|
11156 |
buyerInfo.address = to_t_warehouse_address(addressMapping)
|
| 11138 |
else:
|
11157 |
else:
|
| 11139 |
return None
|
11158 |
return None
|
| 11140 |
return buyerInfo
|
11159 |
return buyerInfo
|
| 11141 |
if __name__ == '__main__':
|
11160 |
if __name__ == '__main__':
|
| - |
|
11161 |
pass
|
| 11142 |
print get_orders_by_mobile_number("9650889334")
|
11162 |
# ordersmap = {'911319502886601':1544266,'911319502890314':1544266,'x911319502903141':1544269,'x911319502916655':1544269,'x911319502950985':1544269,'x911319502836309':1544269,'x911319502972369':1544269,'x911319502950860':1544269,'x911319502918313':1544269,
|
| - |
|
11163 |
# 'x911319502943436':1544269,'x911319502928056':1544269,'x911319502838263':1544269,'911319502794144':1544269,'x911319502821616':1544269,'x911319502974746':1544269,'x911319502821442':1544269,'x911319502903984':1544269,'x911319502820980':1544269,
|
| - |
|
11164 |
# 'x911319502973102':1544269,'x911319502913009':1544269,'x911319502973979':1544269,'x911319502842729':1544269,'x911319502824784':1544269,'x911319502847249':1544269,'x911319502848387':1544269,'x911319502887021':1544269,'x911319502962634':1544269,
|
| - |
|
11165 |
# 'x911319502826268':1544269,'x911319502785761':1544269,'x911319502956750':1544269,'x911319502825195':1544269,'x911319502828298':1544269,'x911319502972054':1544269,'x911319502902044':1544269,'x911319502846498':1544269,'x911319502824305':1544269,
|
| - |
|
11166 |
# 'x911319502891478':1544269,'x911319502962451':1544269,'x911319502929732':1544269,'x911319502834304':1544269,'x911319502830575':1544269,'x911319502889456':1544269,'x911319502842521':1544269,'x911319502900998':1544269,'x911319502890462':1544269,'x911319502881222':1544269,'x911319503523252':1544269}
|
| - |
|
11167 |
#
|
| - |
|
11168 |
# invoice_number=''
|
| - |
|
11169 |
# itemNumbersMap={}
|
| - |
|
11170 |
# serialNumbersMap={}
|
| - |
|
11171 |
# from shop2020.model.v1.order.impl import DataService
|
| - |
|
11172 |
# from shop2020.model.v1.order.impl.DataAccessors import add_billing_details_for_groupped_orders
|
| - |
|
11173 |
# DataService.initialize('transaction','192.168.190.114')
|
| - |
|
11174 |
# for k,v in ordersmap.iteritems():
|
| - |
|
11175 |
# if not serialNumbersMap.has_key(v):
|
| - |
|
11176 |
# serialNumbersMap[v]=[]
|
| - |
|
11177 |
# arr = serialNumbersMap.get(v)
|
| - |
|
11178 |
# arr.append(k)
|
| - |
|
11179 |
# order_ids=serialNumbersMap.keys()
|
| - |
|
11180 |
# for order_id in order_ids:
|
| - |
|
11181 |
# itemNumbersMap[order_id]=['1']
|
| - |
|
11182 |
# add_billing_details_for_groupped_orders(order_ids, invoice_number, itemNumbersMap, serialNumbersMap, {}, 'mp-mmx-admin', '1', 0, False, 'Individual')
|
| - |
|
11183 |
|
| 11143 |
|
11184 |
|