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



    
    session.commit()
    return new_order
 
def add_or_update_amazon_fba_sales_snapshot(amazonfbasalessnapshot):
    salesnapshotfordate = AmazonFbaSalesSnapshot.get_by(item_id = amazonfbasalessnapshot.item_id,dateOfSale=to_py_date(amazonfbasalessnapshot.dateOfSale).date(),fcLocation=amazonfbasalessnapshot.amazonfbasalessnapshot.fcLocation)
    if salesnapshotfordate is None:
        amazon_fba_sales_snapshot = AmazonFbaSalesSnapshot()
        amazon_fba_sales_snapshot.dateOfSale = to_py_date(amazonfbasalessnapshot.dateOfSale).date()
        amazon_fba_sales_snapshot.item_id = amazonfbasalessnapshot.item_id
        amazon_fba_sales_snapshot.totalOrderCount = amazonfbasalessnapshot.totalOrderCount

        amazon_fba_sales_snapshot.minFbaPriceSnapshotDate = to_py_date(amazonfbasalessnapshot.minFbaPriceSnapshotDate)
        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 
    
    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
    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.minFbaPriceSnapshotDate = to_py_date(amazonfbasalessnapshot.minFbaPriceSnapshotDate)
            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
        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
    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 10864 → 11173

Rev 10864		Rev 11173
Line 6273...		Line 6273...
6273		6273
6274	`session.commit()`	6274	`session.commit()`
6275	`return new_order`	6275	`return new_order`
6276		6276
6277	`def add_or_update_amazon_fba_sales_snapshot(amazonfbasalessnapshot):`	6277	`def add_or_update_amazon_fba_sales_snapshot(amazonfbasalessnapshot):`
6278	`salesnapshotfordate = AmazonFbaSalesSnapshot.get_by(item_id = amazonfbasalessnapshot.item_id,dateOfSale=to_py_date(amazonfbasalessnapshot.dateOfSale).date())`	6278	`salesnapshotfordate = AmazonFbaSalesSnapshot.get_by(item_id = amazonfbasalessnapshot.item_id,dateOfSale=to_py_date(amazonfbasalessnapshot.dateOfSale).date(),fcLocation=amazonfbasalessnapshot.amazonfbasalessnapshot.fcLocation)`
6279	`if salesnapshotfordate is None:`	6279	`if salesnapshotfordate is None:`
6280	`amazon_fba_sales_snapshot = AmazonFbaSalesSnapshot()`	6280	`amazon_fba_sales_snapshot = AmazonFbaSalesSnapshot()`
6281	`amazon_fba_sales_snapshot.dateOfSale = to_py_date(amazonfbasalessnapshot.dateOfSale).date()`	6281	`amazon_fba_sales_snapshot.dateOfSale = to_py_date(amazonfbasalessnapshot.dateOfSale).date()`
6282	`amazon_fba_sales_snapshot.item_id = amazonfbasalessnapshot.item_id`	6282	`amazon_fba_sales_snapshot.item_id = amazonfbasalessnapshot.item_id`
6283	`amazon_fba_sales_snapshot.totalOrderCount = amazonfbasalessnapshot.totalOrderCount`	6283	`amazon_fba_sales_snapshot.totalOrderCount = amazonfbasalessnapshot.totalOrderCount`
Line 6296...		Line 6296...
6296	`amazon_fba_sales_snapshot.minFbaPriceSnapshotDate = to_py_date(amazonfbasalessnapshot.minFbaPriceSnapshotDate)`	6296	`amazon_fba_sales_snapshot.minFbaPriceSnapshotDate = to_py_date(amazonfbasalessnapshot.minFbaPriceSnapshotDate)`
6297	`amazon_fba_sales_snapshot.minFbaPrice = amazonfbasalessnapshot.minFbaPrice`	6297	`amazon_fba_sales_snapshot.minFbaPrice = amazonfbasalessnapshot.minFbaPrice`
6298	`#if amazonfbasalessnapshot.minMfnPrice is not None:`	6298	`#if amazonfbasalessnapshot.minMfnPrice is not None:`
6299	`amazon_fba_sales_snapshot.minMfnPriceSnapshotDate = to_py_date(amazonfbasalessnapshot.minMfnPriceSnapshotDate)`	6299	`amazon_fba_sales_snapshot.minMfnPriceSnapshotDate = to_py_date(amazonfbasalessnapshot.minMfnPriceSnapshotDate)`
6300	`amazon_fba_sales_snapshot.minMfnPrice = amazonfbasalessnapshot.minMfnPrice`	6300	`amazon_fba_sales_snapshot.minMfnPrice = amazonfbasalessnapshot.minMfnPrice`
-		6301	`amazon_fba_sales_snapshot.fcLocation = amazonfbasalessnapshot.fcLocation`
6301		6302
6302	`else:`	6303	`else:`
6303	`if(amazonfbasalessnapshot.totalOrderCount > 0):`	6304	`if(amazonfbasalessnapshot.totalOrderCount > 0):`
6304	`salesnapshotfordate.isOutOfStock = 0`	6305	`salesnapshotfordate.isOutOfStock = 0`
6305	`salesnapshotfordate.promotionOrderCount = amazonfbasalessnapshot.promotionOrderCount`	6306	`salesnapshotfordate.promotionOrderCount = amazonfbasalessnapshot.promotionOrderCount`
6306	`salesnapshotfordate.totalSale = amazonfbasalessnapshot.totalSale`	6307	`salesnapshotfordate.totalSale = amazonfbasalessnapshot.totalSale`
6307	`salesnapshotfordate.promotionSale = amazonfbasalessnapshot.promotionSale`	6308	`salesnapshotfordate.promotionSale = amazonfbasalessnapshot.promotionSale`
6308	`salesnapshotfordate.totalOrderCount = amazonfbasalessnapshot.totalOrderCount`	6309	`salesnapshotfordate.totalOrderCount = amazonfbasalessnapshot.totalOrderCount`
-		6310	`salesnapshotfordate.fcLocation = amazonfbasalessnapshot.fcLocation`
6309	`session.commit()`	6311	`session.commit()`
6310		6312
6311	`def get_amazon_fba_sales_snapshot_for_days(interval):`	6313	`def get_amazon_fba_sales_snapshot_for_days(interval):`
-		6314	`query = session.query(Order.status, func.count(Order.id)).group_by(Order.status)`
-		6315
-		6316
6312	`date = datetime.datetime.now()`	6317	`date = datetime.datetime.now()`
6313	`toDate = date-timedelta(days = 1)`	6318	`toDate = date-timedelta(days = 1)`
6314	`fromDate = toDate-timedelta(days = interval)`	6319	`fromDate = toDate-timedelta(days = interval)`
6315	`fbasalessnapshot = AmazonFbaSalesSnapshot.query.filter(AmazonFbaSalesSnapshot.dateOfSale.between (fromDate.date(),toDate.date())).order_by(AmazonFbaSalesSnapshot.dateOfSale).all()`	6320	`fbasalessnapshot = AmazonFbaSalesSnapshot.query.filter(AmazonFbaSalesSnapshot.dateOfSale.between (fromDate.date(),toDate.date())).order_by(AmazonFbaSalesSnapshot.dateOfSale).all()`
6316	`print fbasalessnapshot`	6321	`print fbasalessnapshot`
Line 6599...		Line 6604...
6599	`amazon_fba_sales_snapshot.minFbaPriceSnapshotDate = to_py_date(amazonfbasalessnapshot.minFbaPriceSnapshotDate)`	6604	`amazon_fba_sales_snapshot.minFbaPriceSnapshotDate = to_py_date(amazonfbasalessnapshot.minFbaPriceSnapshotDate)`
6600	`amazon_fba_sales_snapshot.minFbaPrice = amazonfbasalessnapshot.minFbaPrice`	6605	`amazon_fba_sales_snapshot.minFbaPrice = amazonfbasalessnapshot.minFbaPrice`
6601	`#if amazonfbasalessnapshot.minMfnPrice is not None:`	6606	`#if amazonfbasalessnapshot.minMfnPrice is not None:`
6602	`amazon_fba_sales_snapshot.minMfnPriceSnapshotDate = to_py_date(amazonfbasalessnapshot.minMfnPriceSnapshotDate)`	6607	`amazon_fba_sales_snapshot.minMfnPriceSnapshotDate = to_py_date(amazonfbasalessnapshot.minMfnPriceSnapshotDate)`
6603	`amazon_fba_sales_snapshot.minMfnPrice = amazonfbasalessnapshot.minMfnPrice`	6608	`amazon_fba_sales_snapshot.minMfnPrice = amazonfbasalessnapshot.minMfnPrice`
6604		6609	`amazon_fba_sales_snapshot.fcLocation = amazonfbasalessnapshot.fcLocation`
6605	`else:`	6610	`else:`
6606	`if(amazonfbasalessnapshot.totalOrderCount > 0):`	6611	`if(amazonfbasalessnapshot.totalOrderCount > 0):`
6607	`salesnapshotfordate.isOutOfStock = 0`	6612	`salesnapshotfordate.isOutOfStock = 0`
6608	`salesnapshotfordate.promotionOrderCount = amazonfbasalessnapshot.promotionOrderCount`	6613	`salesnapshotfordate.promotionOrderCount = amazonfbasalessnapshot.promotionOrderCount`
6609	`salesnapshotfordate.totalSale = amazonfbasalessnapshot.totalSale`	6614	`salesnapshotfordate.totalSale = amazonfbasalessnapshot.totalSale`
6610	`salesnapshotfordate.promotionSale = amazonfbasalessnapshot.promotionSale`	6615	`salesnapshotfordate.promotionSale = amazonfbasalessnapshot.promotionSale`
6611	`salesnapshotfordate.totalOrderCount = amazonfbasalessnapshot.totalOrderCount`	6616	`salesnapshotfordate.totalOrderCount = amazonfbasalessnapshot.totalOrderCount`
-		6617	`salesnapshotfordate.fcLocation = amazonfbasalessnapshot.fcLocation`
6612	`session.commit()`	6618	`session.commit()`
6613		6619
6614	`def get_created_orders_for_flipkart(flipkartorderids):`	6620	`def get_created_orders_for_flipkart(flipkartorderids):`
6615	`item_ordercount = dict()`	6621	`item_ordercount = dict()`
6616	`orders = []`	6622	`orders = []`