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



    query = session.query(Order.status, func.count(Order.id)).group_by(Order.status)
    date = datetime.datetime.now()
    toDate = date-timedelta(days = 1)
    fromDate = toDate-timedelta(days = interval)
    fbasalessnapshot = AmazonFbaSalesSnapshot.query.filter(AmazonFbaSalesSnapshot.dateOfSale.between (fromDate.date(),toDate.date())).order_by(AmazonFbaSalesSnapshot.dateOfSale).all()
 
    return fbasalessnapshot        
    
def create_snapdeal_order(t_snapdeal_order):
    snapdealOrder = SnapdealOrder()
    snapdealOrder.orderId = t_snapdeal_order.orderId

        return True
    else:
        return False
         
def get_amazon_fba_sales_latest_snapshot_for_item(item_id):
    return AmazonFbaSalesSnapshot.query.filter(AmazonFbaSalesSnapshot.item_id==item_id).filter(AmazonFbaSalesSnapshot.dateOfSale!=datetime.datetime.now().date()).order_by(desc(AmazonFbaSalesSnapshot.dateOfSale)).first()
 
def update_latest_fba_prices_for_item(fbaitemprices):
    fbasalessnapshot = AmazonFbaSalesSnapshot.query.filter(AmazonFbaSalesSnapshot.item_id==fbaitemprices.item_id).order_by(desc(AmazonFbaSalesSnapshot.dateOfSale)).first()
    if(fbasalessnapshot.ourPriceSnapshotDate < to_java_date(fbaitemprices.ourPriceSnapshotDate) and fbaitemprices.ourPrice is not None):
        fbasalessnapshot.ourPriceSnapshotDate = to_py_date(fbaitemprices.ourPriceSnapshotDate)

        returnAllFbaSkuDetails[fbaSkuDetail[0]]= saleReturnDetail
    
    return returnAllFbaSkuDetails
 
def get_amazon_fba_sales_latest_snapshot_for_item_location_wise(item_id,location):
    return AmazonFbaSalesSnapshot.query.filter(AmazonFbaSalesSnapshot.item_id==item_id).filter(AmazonFbaSalesSnapshot.fcLocation==location).filter(AmazonFbaSalesSnapshot.dateOfSale!=datetime.datetime.now().date()).order_by(desc(AmazonFbaSalesSnapshot.dateOfSale)).first()
 
def get_verification_pending_orders_fk():
    retOrders = Order.query.filter(Order.source==OrderSource.FLIPKART).filter(Order.status==OrderStatus.COD_VERIFICATION_PENDING).all()
    retFkOrders = []
    order_ids = []

Subversion Repositories SmartDukaan

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

Rev 13065		Rev 13104
Line 6698...		Line 6698...
6698	`query = session.query(Order.status, func.count(Order.id)).group_by(Order.status)`	6698	`query = session.query(Order.status, func.count(Order.id)).group_by(Order.status)`
6699	`date = datetime.datetime.now()`	6699	`date = datetime.datetime.now()`
6700	`toDate = date-timedelta(days = 1)`	6700	`toDate = date-timedelta(days = 1)`
6701	`fromDate = toDate-timedelta(days = interval)`	6701	`fromDate = toDate-timedelta(days = interval)`
6702	`fbasalessnapshot = AmazonFbaSalesSnapshot.query.filter(AmazonFbaSalesSnapshot.dateOfSale.between (fromDate.date(),toDate.date())).order_by(AmazonFbaSalesSnapshot.dateOfSale).all()`	6702	`fbasalessnapshot = AmazonFbaSalesSnapshot.query.filter(AmazonFbaSalesSnapshot.dateOfSale.between (fromDate.date(),toDate.date())).order_by(AmazonFbaSalesSnapshot.dateOfSale).all()`
6703	`print fbasalessnapshot`	-
6704	`return fbasalessnapshot`	6703	`return fbasalessnapshot`
6705		6704
6706	`def create_snapdeal_order(t_snapdeal_order):`	6705	`def create_snapdeal_order(t_snapdeal_order):`
6707	`snapdealOrder = SnapdealOrder()`	6706	`snapdealOrder = SnapdealOrder()`
6708	`snapdealOrder.orderId = t_snapdeal_order.orderId`	6707	`snapdealOrder.orderId = t_snapdeal_order.orderId`
Line 6753...		Line 6752...
6753	`return True`	6752	`return True`
6754	`else:`	6753	`else:`
6755	`return False`	6754	`return False`
6756		6755
6757	`def get_amazon_fba_sales_latest_snapshot_for_item(item_id):`	6756	`def get_amazon_fba_sales_latest_snapshot_for_item(item_id):`
6758	`return AmazonFbaSalesSnapshot.query.filter(AmazonFbaSalesSnapshot.item_id==item_id).order_by(desc(AmazonFbaSalesSnapshot.dateOfSale)).first()`	6757	`return AmazonFbaSalesSnapshot.query.filter(AmazonFbaSalesSnapshot.item_id==item_id).filter(AmazonFbaSalesSnapshot.dateOfSale!=datetime.datetime.now().date()).order_by(desc(AmazonFbaSalesSnapshot.dateOfSale)).first()`
6759		6758
6760	`def update_latest_fba_prices_for_item(fbaitemprices):`	6759	`def update_latest_fba_prices_for_item(fbaitemprices):`
6761	`fbasalessnapshot = AmazonFbaSalesSnapshot.query.filter(AmazonFbaSalesSnapshot.item_id==fbaitemprices.item_id).order_by(desc(AmazonFbaSalesSnapshot.dateOfSale)).first()`	6760	`fbasalessnapshot = AmazonFbaSalesSnapshot.query.filter(AmazonFbaSalesSnapshot.item_id==fbaitemprices.item_id).order_by(desc(AmazonFbaSalesSnapshot.dateOfSale)).first()`
6762	`if(fbasalessnapshot.ourPriceSnapshotDate < to_java_date(fbaitemprices.ourPriceSnapshotDate) and fbaitemprices.ourPrice is not None):`	6761	`if(fbasalessnapshot.ourPriceSnapshotDate < to_java_date(fbaitemprices.ourPriceSnapshotDate) and fbaitemprices.ourPrice is not None):`
6763	`fbasalessnapshot.ourPriceSnapshotDate = to_py_date(fbaitemprices.ourPriceSnapshotDate)`	6762	`fbasalessnapshot.ourPriceSnapshotDate = to_py_date(fbaitemprices.ourPriceSnapshotDate)`
Line 7269...		Line 7268...
7269	`returnAllFbaSkuDetails[fbaSkuDetail[0]]= saleReturnDetail`	7268	`returnAllFbaSkuDetails[fbaSkuDetail[0]]= saleReturnDetail`
7270		7269
7271	`return returnAllFbaSkuDetails`	7270	`return returnAllFbaSkuDetails`
7272		7271
7273	`def get_amazon_fba_sales_latest_snapshot_for_item_location_wise(item_id,location):`	7272	`def get_amazon_fba_sales_latest_snapshot_for_item_location_wise(item_id,location):`
7274	`return AmazonFbaSalesSnapshot.query.filter(AmazonFbaSalesSnapshot.item_id==item_id).filter(AmazonFbaSalesSnapshot.fcLocation==location).order_by(desc(AmazonFbaSalesSnapshot.dateOfSale)).first()`	7273	`return AmazonFbaSalesSnapshot.query.filter(AmazonFbaSalesSnapshot.item_id==item_id).filter(AmazonFbaSalesSnapshot.fcLocation==location).filter(AmazonFbaSalesSnapshot.dateOfSale!=datetime.datetime.now().date()).order_by(desc(AmazonFbaSalesSnapshot.dateOfSale)).first()`
7275		7274
7276	`def get_verification_pending_orders_fk():`	7275	`def get_verification_pending_orders_fk():`
7277	`retOrders = Order.query.filter(Order.source==OrderSource.FLIPKART).filter(Order.status==OrderStatus.COD_VERIFICATION_PENDING).all()`	7276	`retOrders = Order.query.filter(Order.source==OrderSource.FLIPKART).filter(Order.status==OrderStatus.COD_VERIFICATION_PENDING).all()`
7278	`retFkOrders = []`	7277	`retFkOrders = []`
7279	`order_ids = []`	7278	`order_ids = []`