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

 @author: Chandranshu
 '''
 from datetime import date, timedelta
-from math import ceil
+from decimal import Decimal
 from elixir import *
+from math import ceil
 from random import randrange
+from reportlab.lib.enums import TA_CENTER, TA_JUSTIFY
+from reportlab.lib.styles import ParagraphStyle, getSampleStyleSheet
 from reportlab.lib.units import inch
 from reportlab.pdfgen.canvas import Canvas
-from reportlab.rl_config import defaultPageSize
-from reportlab.lib.enums import TA_CENTER,TA_JUSTIFY
-from reportlab.lib.styles import ParagraphStyle
-from reportlab.lib.styles import getSampleStyleSheet
 from reportlab.platypus import SimpleDocTemplate, Paragraph, Spacer, Image, \
     BaseDocTemplate, Frame, PageTemplate
+from reportlab.rl_config import defaultPageSize
 from shop2020.clients.AlertClient import AlertClient
 from shop2020.clients.CatalogClient import CatalogClient
 from shop2020.clients.HelperClient import HelperClient
 from shop2020.clients.InventoryClient import InventoryClient
 from shop2020.clients.LogisticsClient import LogisticsClient
 from shop2020.clients.PaymentClient import PaymentClient
+from shop2020.clients.PromotionClient import PromotionClient
 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
 from shop2020.model.v1.order.impl.DataService import Transaction, LineItem, \
     Order, BatchNoGenerator, InvoiceIDGenerator, TransactionRequiringExtraProcessing, \
     OrderInventory, Alert, PaymentSettlement, EBSSettlementSummary, \
-    CodVerificationAgent, Attribute, RechargeVoucherTracker, EmiScheme, \
+    CodVerificationAgent, Attribute, RechargeVoucherTracker, EmiScheme, MiscCharges, \
-    MiscCharges, BlockedIpRange, DeniedIpAddress, InsuranceDetailForOrder,\
+    BlockedIpRange, DeniedIpAddress, InsuranceDetailForOrder, DocumentStore, \
-    DocumentStore, RechargeTransaction, HotspotStore, WalletForCompany,\
+    RechargeTransaction, HotspotStore, WalletForCompany, WalletHistoryForCompany, \
-    WalletHistoryForCompany, FRC, OperatorSeries
+    FRC, OperatorSeries
+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 \
+    RechargeDenomination
+from shop2020.model.v1.order.impl.model.RechargeOrder import RechargeOrder
+from shop2020.model.v1.order.impl.model.RechargePlan import RechargePlan
 from shop2020.model.v1.order.impl.model.ReturnOrder import ReturnOrder
+from shop2020.model.v1.order.impl.model.ServiceAvailability import \
+    ServiceAvailability
+from shop2020.model.v1.order.impl.model.ServiceProvider import ServiceProvider
+from shop2020.model.v1.order.impl.model.TelecomCircle import TelecomCircle
+from shop2020.model.v1.order.impl.model.UserWallet import UserWallet
+from shop2020.model.v1.order.impl.model.UserWalletHistory import \
+    UserWalletHistory
 from shop2020.thriftpy.alert.ttypes import MonitoredEntity, EntityType
 from shop2020.thriftpy.logistics.ttypes import DeliveryType, PickUpType
 from shop2020.thriftpy.model.v1.catalog.ttypes import ItemType
 from shop2020.thriftpy.model.v1.inventory.ttypes import BillingType, \
     InventoryServiceException, WarehouseType, InventoryType
 from shop2020.thriftpy.model.v1.order.ttypes import TransactionServiceException, \
     TransactionStatus, OrderStatus, DelayReason, ExtraTransactionProcessingType, \
-    HotspotAction, TimeoutSummary, OrderStatusGroups, OrderType,\
+    HotspotAction, TimeoutSummary, OrderStatusGroups, OrderType, RechargeOrderStatus, \
-    RechargeOrderStatus, RechargeType, RechargeStatistics, DeviceNumberInfo,\
+    RechargeType, RechargeStatistics, DeviceNumberInfo, EmiChargeType, PayMethod
-    EmiChargeType
 from shop2020.thriftpy.model.v1.user.ttypes import VoucherType
 from shop2020.thriftpy.payments.ttypes import PaymentException
 from shop2020.thriftpy.warehouse.ttypes import ScanType, \
     WarehouseServiceException
 from shop2020.utils.EmailAttachmentSender import mail, get_attachment_part
 from shop2020.utils.Utils import to_py_date, to_java_date
 from sqlalchemy.orm.exc import NoResultFound, MultipleResultsFound
 from sqlalchemy.sql import func
-from sqlalchemy.sql.expression import and_, or_, desc, not_, distinct
+from sqlalchemy.sql.expression import and_, or_, desc, not_, distinct, cast, \
+    between
 from string import Template
 from textwrap import dedent
 import datetime
 import httplib
 import logging
 import sys
 import time
 import traceback
 import urllib
-from shop2020.config.client.ConfigClient import ConfigClient
-from shop2020.model.v1.order.impl.model.RechargePlan import RechargePlan
-from shop2020.model.v1.order.impl.model.RechargeOrder import RechargeOrder
-from shop2020.model.v1.order.impl.model.UserWallet import UserWallet
-from shop2020.model.v1.order.impl.model.UserWalletHistory import UserWalletHistory
-from shop2020.model.v1.order.impl.model.ServiceProvider import ServiceProvider
-from shop2020.model.v1.order.impl.model.DTHRechargeOrder import DTHRechargeOrder
-from shop2020.model.v1.order.impl.model.TelecomCircle import TelecomCircle
-from shop2020.model.v1.order.impl.model.ServiceAvailability import ServiceAvailability
-from shop2020.model.v1.order.impl.model.RechargeDenomination import RechargeDenomination
-from shop2020.clients.PromotionClient import PromotionClient
-from decimal import Decimal
-from shop2020.model.v1.order.impl.Convertors import to_t_emi_scheme
-from shop2020.model.v1.order.impl.model.BaseOrder import BaseOrder
 logging.basicConfig(level=logging.DEBUG)
 sourceId = int(ConfigClient().get_property("sourceid"))
 mail_user = 'cnc.center@shop2020.in'
     order = get_order(order_id)
     if order == None or order.status not in [OrderStatus.SHIPPED_FROM_WH, OrderStatus.DELIVERED_AT_STORE, OrderStatus.SHIPPED_TO_LOGST, OrderStatus.SHIPPED_TO_DESTINATION_CITY, OrderStatus.REACHED_DESTINATION_CITY, OrderStatus.FIRST_DELIVERY_ATTEMPT_MADE, OrderStatus.DELIVERY_SUCCESS]:
         return False
     order.status = OrderStatus.RTO_IN_TRANSIT
     order.delivery_timestamp = datetime.datetime.now()
-    order.statusDescription = "Order Returned to Origin:"
+    order.statusDescription = "Order Returned to Origin"
     update_trust_level(order)
     session.commit()
     return True
 def get_order(order_id):
 def get_recharge_transactions(storeId):
     query = RechargeTransaction.query.filter(RechargeTransaction.storeId == storeId)
     return query.all()
+def get_recharge_trans(storeId, startdate,enddate, status):
+    if startdate == -1:
+        startdate = None
+    if enddate == -1:
+        enddate = None
+    if storeId== 0:
+        storeId = None
+    if status == 0:
+        status = None
+    query = RechargeTransaction.query
+    if storeId is not None:
+        query = query.filter(RechargeTransaction.storeId == storeId)
+    if startdate is not None and enddate is not None:
+        startdate = to_py_date(startdate).date()
+        enddate = to_py_date(enddate).date()
+        if startdate == enddate:
+            query = query.filter(cast(RechargeTransaction.transactionTime, DATE) == enddate)
+        elif enddate < startdate:
+            query = query.filter(between(cast(RechargeTransaction.transactionTime, DATE), enddate, startdate))
+        else:
+            query = query.filter(between(cast(RechargeTransaction.transactionTime, DATE), startdate, enddate))
+    elif startdate is not None:
+        startdate = to_py_date(startdate).date()
+        query = query.filter(cast(RechargeTransaction.transactionTime, DATE) >= startdate)
+    elif enddate is not None:
+        enddate = to_py_date(enddate).date()
+        query = query.filter(cast(RechargeTransaction.transactionTime, DATE) <= enddate)
+    if status is not None:
+        query = query.filter(RechargeTransaction.status == status)
+    return query.all()
 def update_recharge_transaction_status(id, status, refundTime):
     rechargeTransaction = RechargeTransaction.get_by(id=id)
     if status == RechargeOrderStatus.RECHARGE_FAILED_REFUNDED:
         rechargeTransaction.status = RechargeOrderStatus.RECHARGE_FAILED_REFUNDED
         rechargeTransaction.responseTime = refundTime
     amount = recharge.amount
     telNum = "+91 " + str(recharge.deviceNum)
     customerName = recharge.name
     invNum = str(recharge.invoiceNumber)
     billingTime = recharge.responseTime
+    payMethod = recharge.payMethod
-    return __printRechargeInvoice(filename, operator, amount, telNum, customerName, invNum, billingTime)
+    return __printRechargeInvoice(filename, operator, amount, telNum, customerName, invNum, billingTime, payMethod)
-def __printRechargeInvoice(filename, operator, amount, telNum, customerName, invNum, billingTime):
+def __printRechargeInvoice(filename, operator, amount, telNum, customerName, invNum, billingTime, payMethod):
     PAGE_HEIGHT=defaultPageSize[1];
     styles = getSampleStyleSheet()
     styles.add(ParagraphStyle(name='prologue', alignment=TA_CENTER, fontName="Courier", rightIndent = 5, fontSize=10), alias='sH')
     styles.add(ParagraphStyle(name='text', alignment=TA_JUSTIFY, fontName="Courier", fontSize=10), alias='text')
     styles.add(ParagraphStyle(name='line', alignment=TA_CENTER, fontName="Courier", fontSize=10), alias='line')
     Story.append(Paragraph('{0:7s}{1:>11s}{2:  %d/%m/%Y  %H:%M:%S}'.format("INV NO:", invNum, billingTime).replace(" ", "&nbsp;"), textStyle))
     drawLine(Story, lineStyle)
     Story.append(Paragraph("{0:<6s}{1:<34s}".format("NAME:", customerName).replace(" ", "&nbsp;"), textStyle))
     Story.append(Paragraph("{0:<9s}{1:<31s}".format("TEL NO.:", telNum).replace(" ", "&nbsp;"), textStyle))
+    Story.append(Paragraph("{0:<9s}{1:<31s}".format("PAYMENT MODE:", PayMethod._VALUES_TO_NAMES[payMethod]).replace(" ", "&nbsp;"), textStyle))
     drawLine(Story, lineStyle)
     Story.append(Paragraph(('{0:<16s}{1:>13s}{2:11.2f}').format(operator, "RECHARGE", amount).replace(' ', '&nbsp;'),textStyle))
     drawLine(Story, lineStyle)
     doc.addPageTemplates([PageTemplate(id='TwoCol',frames=[frame1]), ])

Subversion Repositories SmartDukaan

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