WebSVN – SmartDukaan – Diff – //trunk/PyProj/src/shop2020/model/v1/order/impl/DataAccessors.py

 Created on 29-Mar-2010
 @author: Chandranshu
 '''
+import MySQLdb
+import base64
 from datetime import date, timedelta
+import datetime
 from decimal import Decimal
 from elixir import *
+import httplib
+import logging
 from math import ceil
+import math
+import os
 from random import randrange
+import re
+from reportlab.lib import colors
 from reportlab.lib.enums import TA_CENTER, TA_JUSTIFY
 from reportlab.lib.styles import ParagraphStyle, getSampleStyleSheet
 from reportlab.lib.units import inch, mm
 from reportlab.pdfgen.canvas import Canvas
 from reportlab.platypus import SimpleDocTemplate, Paragraph, Spacer, Image, \
-    BaseDocTemplate, Frame, PageTemplate
+    BaseDocTemplate, Frame, PageTemplate, Table, TableStyle
 from reportlab.rl_config import defaultPageSize
+from sqlalchemy.orm.exc import NoResultFound, MultipleResultsFound
+from sqlalchemy.sql import func
+from sqlalchemy.sql.expression import and_, or_, desc, not_, distinct, cast, \
+    between
+from string import Template
+import sys
-from reportlab.lib import colors
+from textwrap import dedent
+import time
+import traceback
+import urllib
-from reportlab.platypus import Table, TableStyle
+from xml.dom.minidom import parseString
 from shop2020.clients.AlertClient import AlertClient
 from shop2020.clients.CRMClient import CRMClient
 from shop2020.clients.CatalogClient import CatalogClient
 from shop2020.clients.HelperClient import HelperClient
 from shop2020.clients.InventoryClient import InventoryClient
 from shop2020.clients.UserClient import UserClient
 from shop2020.clients.WarehouseClient import WarehouseClient
 from shop2020.config.client.ConfigClient import ConfigClient
 from shop2020.model.v1 import order
 from shop2020.model.v1.order.impl import DataService, RechargeService
-from shop2020.model.v1.order.impl.Convertors import to_t_emi_scheme, to_t_order,\
+from shop2020.model.v1.order.impl.Convertors import to_t_emi_scheme, to_t_order, \
     cutoff_date
 from shop2020.model.v1.order.impl.DataService import Transaction, LineItem, \
     Order, BatchNoGenerator, InvoiceIDGenerator, TransactionRequiringExtraProcessing, \
     OrderInventory, Alert, PaymentSettlement, EBSSettlementSummary, \
     CodVerificationAgent, Attribute, RechargeVoucherTracker, EmiScheme, MiscCharges, \
     RechargeTransaction, HotspotStore, WalletForCompany, WalletHistoryForCompany, \
     FRC, OperatorSeries, SourceDetail, Company, EbayOrder, AmazonFbaSalesSnapshot, \
     AmazonOrder, StoreOrderDetail, EdcBank, StoreOrderCollection, \
     HotspotServiceMatrix, SnapdealOrder, FlipkartOrder, DataInsuranceDetailForOrder, \
     AmazonFbaOrderReturns, FlipkartAdvantageOrder, InvoiceCounterGenerator, \
-    TransactionShipmentSequence, HsOrder, Creditor, UserSanction, CreditHistory, LoanHistory, \
+    TransactionShipmentSequence, HsOrder, Creditor, UserSanction, CreditHistory, \
-    ShipmentLogisticsCostDetail, ReturnOrderInfo, ReturnTransaction , ReturnPickupRequest
+    LoanHistory, ShipmentLogisticsCostDetail, ReturnOrderInfo, ReturnTransaction, \
+    ReturnPickupRequest, SellerWarehouse, Seller, Organisation
 from shop2020.model.v1.order.impl.model.BaseOrder import BaseOrder
 from shop2020.model.v1.order.impl.model.DTHRechargeOrder import DTHRechargeOrder
 from shop2020.model.v1.order.impl.model.MobileRechargeOrder import \
     MobileRechargeOrder
 from shop2020.model.v1.order.impl.model.RechargeDenomination import \
 from shop2020.thriftpy.model.v1.order.ttypes import TransactionServiceException, \
     TransactionStatus, OrderStatus, DelayReason, ExtraTransactionProcessingType, \
     HotspotAction, TimeoutSummary, OrderStatusGroups, OrderType, RechargeOrderStatus, \
     RechargeType, RechargeStatistics, DeviceNumberInfo, EmiChargeType, PayMethod, \
     OrderSource, StorePaymentStatus, ProductCondition, TaxType, \
-    AmazonFCWarehouseLocation, RechargeMode, CreditTxnType, CreditHistory as TCreditHistory, \
+    AmazonFCWarehouseLocation, RechargeMode, CreditTxnType, \
+    CreditHistory as TCreditHistory, LoanHistory as TLoanHistory, \
-    LoanHistory as TLoanHistory, ShipmentLogisticsCostDetail as TShipmentLogisticsCostDetail, \
+    ShipmentLogisticsCostDetail as TShipmentLogisticsCostDetail, \
-    ReturnTransactionStatus, ReturnAction, ReturnTxnResolutionStatus, ReplacementShippingType, \
+    ReturnTransactionStatus, ReturnAction, ReturnTxnResolutionStatus, \
+    ReplacementShippingType, ReturnTxnPickupStatus, ReceivedReturnType, \
-    ReturnTxnPickupStatus, ReceivedReturnType, ReturnPickupType, RefundType
+    ReturnPickupType, RefundType, SellerInfo
 from shop2020.thriftpy.model.v1.user.ttypes import VoucherType, CouponCategory, \
     User, Sex
 from shop2020.thriftpy.payments.ttypes import PaymentException
 from shop2020.thriftpy.utils.ttypes import UserSmsInfo, SmsType
 from shop2020.thriftpy.warehouse.ttypes import ScanType, \
     WarehouseServiceException
 from shop2020.utils.EmailAttachmentSender import mail, get_attachment_part, \
     mail_html
 from shop2020.utils.Utils import to_py_date, to_java_date, \
     getSyncOperatorsForRecharge
-from sqlalchemy.orm.exc import NoResultFound, MultipleResultsFound
-from sqlalchemy.sql import func
-from sqlalchemy.sql.expression import and_, or_, desc, not_, distinct, cast, \
-    between
-from string import Template
 from suds.client import Client
-from textwrap import dedent
-from xml.dom.minidom import parseString
-import base64
-import datetime
-import httplib
-import logging
-import os
-import re
-import sys
-import time
-import traceback
-import urllib
-import MySQLdb
-import math
 #Start:- Added By Manish Sharma for Creating a new Ticket: Category- RTO Refund on 21-Jun-2013
 #End:- Added By Manish Sharma for Creating a new Ticket: Category- RTO Refund on 21-Jun-2013
 #Start:- Added By Manish Sharma for Creating a new Ticket: Category- RTO Refund on 21-Jun-2013
 #End:- Added By Manish Sharma for Creating a new Ticket: Category- RTO Refund on 21-Jun-2013
 logging.basicConfig(level=logging.DEBUG)
 sourceId = int(ConfigClient().get_property("sourceid"))
 capitalFloatPayMethod = 456789
 SaholicHelpEmailId = "Saholic <help@saholic.com>"
                 session.commit()
                 return True
         if billingType == BillingType.OURS or billingType == BillingType.OURS_EXTERNAL:
             #as of now only company 2 - SORPL, 3-New company is operating and cutoff config will decide the company to be used to bill
             #until further change - Amit Gupta
-            companyId = 2
+            seller_id = __get_seller()
-            if cutoff_date <= datetime.datetime.now():
+            order.invoice_number = get_next_invoice_counter(seller_id, order.warehouse_id, order.orderType)
-                companyId = 3
+            order.seller_id = seller_id
-            order.invoice_number = get_next_invoice_counter(companyId, order.orderType, whStateId)
         session.commit()
         return True
     else:
         return False
     entity_id = InvoiceIDGenerator.query.filter(InvoiceIDGenerator.orderType == orderType).with_lockmode("update").one()
     invoice_number = entity_id.id + 1
     entity_id.id = invoice_number
     return invoice_number
-def get_next_invoice_counter(companyId, orderType, stateId):
+def get_next_invoice_counter(seller_id, warehouse_id, orderType):
     if OrderType.B2Cbulk == orderType:
         orderType = OrderType.B2C
-    entity_id = InvoiceCounterGenerator.query.filter(InvoiceCounterGenerator.orderType == orderType).filter(InvoiceCounterGenerator.stateId == stateId).filter(InvoiceCounterGenerator.companyId==companyId).with_lockmode("update").one()
+    #entity_id = InvoiceCounterGenerator.query.filter(InvoiceCounterGenerator.orderType == orderType).filter(InvoiceCounterGenerator.stateId == stateId).filter(InvoiceCounterGenerator.companyId==companyId).with_lockmode("update").one()
+    entity_id = SellerWarehouse.query.filter(SellerWarehouse.orderType == orderType).filter(SellerWarehouse.warehouse_id == warehouse_id).filter(SellerWarehouse.seller_id==seller_id).with_lockmode("update").one()
     invoice_number = entity_id.id + 1
     entity_id.id = invoice_number
     ret_invoiceNo = entity_id.prefix + str(invoice_number)
     return ret_invoiceNo
     if warehouseDbConnection.open:
         warehouseDbConnection.close()
     session.commit()
     if billingType == BillingType.OURS or billingType == BillingType.OURS_EXTERNAL:
-        #as of now only company 1 - SORPL, 3-New company is operating and cutoff config will decide the company to be used to bill
-        #until further change - Amit Gupta
+        #get seller for current warehouse id
-        companyId = 2
-        if cutoff_date <= datetime.datetime.now():
+        seller_id  = __get_seller()
-            companyId = 3
-        invoiceNumber = get_next_invoice_counter(companyId, ordersList[0].orderType, whStateId)
+        invoiceNumber = get_next_invoice_counter(seller_id, ordersList[0].warehouse_id, ordersList[0].orderType)
     invoiceTypeVal = 1
     if not individualInvoice:
         txnShipSeq = TransactionShipmentSequence.query.filter(TransactionShipmentSequence.transactionId==int(transactionShipSeqValues[0])).filter(TransactionShipmentSequence.sequence==int(transactionShipSeqValues[1])).order_by(desc(TransactionShipmentSequence.id)).first()
         txnShipSeq.invoiceFormat = invoiceTypeVal
     for order in ordersList:
         order.invoice_number = invoiceNumber
+        order.seller_id = seller_id
     session.commit()
     return True
 def get_invoice_format_logistics_txn_id(transactionId, shipementSeq):
     returnOrderInfo.masterOrderId = order.logisticsTransactionId
     returnOrderInfo.warehouse_id = order.warehouse_id
     returnOrderInfo.returnAction = returnInfo.returnAction
     returnOrderInfo.freebieItemId = order.freebieItemId
     returnOrderInfo.returnTxnResolutionStatus = ReturnTxnResolutionStatus._VALUES_TO_NAMES[ReturnTxnResolutionStatus.PENDING]
+def get_seller_info(sellerId):
+    sellerInfo = SellerInfo()
+    seller = Seller.get_by(id=sellerId)
+    if seller is None:
+        return None
+    else:
+        sellerInfo.tin = seller.tin
+        org = Organisation.get_by(id=seller.organisation_id)
+        if org is None:
+            return None
+        else:
+            org = Organisation()
+            sellerInfo.organisationName = org.name
+            sellerInfo.regId = org.registered_id
+            sellerInfo.registeredAddress =  org.address
+            if org.type == 'company':
+                sellerInfo.cinNumber = org.registered_id
+            return sellerInfo
+        return "1"
 def split_return_order_info(returnOrderId, splitReturnOrderQty):
     returnOrder = ReturnOrderInfo.get_by(id=returnOrderId)
     if returnOrder is None:
         raise TransactionServiceException(101, "No Return Order is there with this Order Id")
+#Seller would be used to get tin number
+def __get_seller():
+        #As of now we should hardcode the seller
+        return 5
 if __name__ == '__main__':
     print get_orders_by_mobile_number("9650889334")

Subversion Repositories SmartDukaan

(root)//trunk/PyProj/src/shop2020/model/v1/order/impl/DataAccessors.py – Rev 19960 → 19973