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



        salesnapshotfordate.fcLocation = amazonfbasalessnapshot.fcLocation
    session.commit()    
    
def get_amazon_fba_sales_snapshot_for_days(interval):
    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()
    print fbasalessnapshot

            amazon_fba_sales_snapshot.minFbaPrice = amazonfbasalessnapshot.minFbaPrice
            #if amazonfbasalessnapshot.minMfnPrice is not None:
            amazon_fba_sales_snapshot.minMfnPriceSnapshotDate = to_py_date(amazonfbasalessnapshot.minMfnPriceSnapshotDate)
            amazon_fba_sales_snapshot.minMfnPrice = amazonfbasalessnapshot.minMfnPrice
            amazon_fba_sales_snapshot.fcLocation = amazonfbasalessnapshot.fcLocation
            amazon_fba_sales_snapshot.asin = amazonfbasalessnapshot.asin
        else:
            if(amazonfbasalessnapshot.totalOrderCount > 0):
                salesnapshotfordate.isOutOfStock = 0
            salesnapshotfordate.promotionOrderCount = amazonfbasalessnapshot.promotionOrderCount
            salesnapshotfordate.totalSale = amazonfbasalessnapshot.totalSale
            salesnapshotfordate.promotionSale = amazonfbasalessnapshot.promotionSale
            salesnapshotfordate.totalOrderCount = amazonfbasalessnapshot.totalOrderCount
            salesnapshotfordate.fcLocation = amazonfbasalessnapshot.fcLocation
            salesnapshotfordate.asin = amazonfbasalessnapshot.asin
    session.commit()
 
def get_created_orders_for_flipkart(flipkartorderids):
    item_ordercount = dict()
    orders = []

Subversion Repositories SmartDukaan

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

Rev 12614		Rev 12618
Line 6382...		Line 6382...
6382	`salesnapshotfordate.fcLocation = amazonfbasalessnapshot.fcLocation`	6382	`salesnapshotfordate.fcLocation = amazonfbasalessnapshot.fcLocation`
6383	`session.commit()`	6383	`session.commit()`
6384		6384
6385	`def get_amazon_fba_sales_snapshot_for_days(interval):`	6385	`def get_amazon_fba_sales_snapshot_for_days(interval):`
6386	`query = session.query(Order.status, func.count(Order.id)).group_by(Order.status)`	6386	`query = session.query(Order.status, func.count(Order.id)).group_by(Order.status)`
6387		-
6388		-
6389	`date = datetime.datetime.now()`	6387	`date = datetime.datetime.now()`
6390	`toDate = date-timedelta(days = 1)`	6388	`toDate = date-timedelta(days = 1)`
6391	`fromDate = toDate-timedelta(days = interval)`	6389	`fromDate = toDate-timedelta(days = interval)`
6392	`fbasalessnapshot = AmazonFbaSalesSnapshot.query.filter(AmazonFbaSalesSnapshot.dateOfSale.between (fromDate.date(),toDate.date())).order_by(AmazonFbaSalesSnapshot.dateOfSale).all()`	6390	`fbasalessnapshot = AmazonFbaSalesSnapshot.query.filter(AmazonFbaSalesSnapshot.dateOfSale.between (fromDate.date(),toDate.date())).order_by(AmazonFbaSalesSnapshot.dateOfSale).all()`
6393	`print fbasalessnapshot`	6391	`print fbasalessnapshot`
Line 6696...		Line 6694...
6696	`amazon_fba_sales_snapshot.minFbaPrice = amazonfbasalessnapshot.minFbaPrice`	6694	`amazon_fba_sales_snapshot.minFbaPrice = amazonfbasalessnapshot.minFbaPrice`
6697	`#if amazonfbasalessnapshot.minMfnPrice is not None:`	6695	`#if amazonfbasalessnapshot.minMfnPrice is not None:`
6698	`amazon_fba_sales_snapshot.minMfnPriceSnapshotDate = to_py_date(amazonfbasalessnapshot.minMfnPriceSnapshotDate)`	6696	`amazon_fba_sales_snapshot.minMfnPriceSnapshotDate = to_py_date(amazonfbasalessnapshot.minMfnPriceSnapshotDate)`
6699	`amazon_fba_sales_snapshot.minMfnPrice = amazonfbasalessnapshot.minMfnPrice`	6697	`amazon_fba_sales_snapshot.minMfnPrice = amazonfbasalessnapshot.minMfnPrice`
6700	`amazon_fba_sales_snapshot.fcLocation = amazonfbasalessnapshot.fcLocation`	6698	`amazon_fba_sales_snapshot.fcLocation = amazonfbasalessnapshot.fcLocation`
-		6699	`amazon_fba_sales_snapshot.asin = amazonfbasalessnapshot.asin`
6701	`else:`	6700	`else:`
6702	`if(amazonfbasalessnapshot.totalOrderCount > 0):`	6701	`if(amazonfbasalessnapshot.totalOrderCount > 0):`
6703	`salesnapshotfordate.isOutOfStock = 0`	6702	`salesnapshotfordate.isOutOfStock = 0`
6704	`salesnapshotfordate.promotionOrderCount = amazonfbasalessnapshot.promotionOrderCount`	6703	`salesnapshotfordate.promotionOrderCount = amazonfbasalessnapshot.promotionOrderCount`
6705	`salesnapshotfordate.totalSale = amazonfbasalessnapshot.totalSale`	6704	`salesnapshotfordate.totalSale = amazonfbasalessnapshot.totalSale`
6706	`salesnapshotfordate.promotionSale = amazonfbasalessnapshot.promotionSale`	6705	`salesnapshotfordate.promotionSale = amazonfbasalessnapshot.promotionSale`
6707	`salesnapshotfordate.totalOrderCount = amazonfbasalessnapshot.totalOrderCount`	6706	`salesnapshotfordate.totalOrderCount = amazonfbasalessnapshot.totalOrderCount`
6708	`salesnapshotfordate.fcLocation = amazonfbasalessnapshot.fcLocation`	6707	`salesnapshotfordate.fcLocation = amazonfbasalessnapshot.fcLocation`
-		6708	`salesnapshotfordate.asin = amazonfbasalessnapshot.asin`
6709	`session.commit()`	6709	`session.commit()`
6710		6710
6711	`def get_created_orders_for_flipkart(flipkartorderids):`	6711	`def get_created_orders_for_flipkart(flipkartorderids):`
6712	`item_ordercount = dict()`	6712	`item_ordercount = dict()`
6713	`orders = []`	6713	`orders = []`