WebSVN – SmartDukaan – Diff – //trunk/PyProj/src/shop2020/model/v1/catalog/impl/DataAcessors.py



from string import Template
import datetime
import sys
import threading
import urllib2
 
 
sourceId = int(ConfigClient().get_property("sourceid"))
to_addresses = ["khushal.bhatia@shop2020.in", "chandan.kumar@shop2020.in",  "chaitnaya.vats@shop2020.in"]
mail_user = "cnc.center@shop2020.in"
mail_password = "5h0p2o2o"

        flag = "ON" if item.isWarehousePreferenceSticky else "OFF"
        message += "Warehouse preference sticky is {0}.\n".format(flag)
 
    ds_item.isWarehousePreferenceSticky = item.isWarehousePreferenceSticky
    
    ds_item.updatedOn = datetime.datetime.now()
    
#    if item.activeOnStore and  not ds_item.activeOnStore:
#        add_store_pricing(ds_item)
    ds_item.activeOnStore = item.activeOnStore
    

        ds_item.comments = item.comments
    if item.asin:
        ds_item.asin = item.asin
    ds_item.holdInventory = item.holdInventory
    ds_item.defaultInventory = item.defaultInventory    
    ds_item.addedOn = datetime.datetime.now()
    ds_item.updatedOn = datetime.datetime.now()
    if item.startDate:
        ds_item.startDate = to_py_date(item.startDate)
        ds_item.startDate = ds_item.startDate.replace(hour=0,second=0,minute=0)
    if item.retireDate:
        ds_item.retireDate = to_py_date(item.retireDate)

    sp.minPrice = store.minPrice
    sp.minAdvancePrice = store.minAdvancePrice
    sp.maxPrice = store.maxPrice
    return sp
 
 
def get_all_amazon_listed_items():
    return session.query(Amazonlisted).all()
 
def get_amazon_item_details(amazonItemId):
    amazonlisted = Amazonlisted.get_by(itemId=amazonItemId)

    if amazonlisted.category:
        amazon_item.category=amazonlisted.category
    session.commit()
    
def get_asin_items():
    from_date=datetime.datetime.now() - datetime.timedelta(days=10)
    return Item.query.filter(Item.updatedOn > from_date).all()
    
def get_all_fba_listed_items():
    return Amazonlisted.query.filter(Amazonlisted.isFba==True).all()
    

Rev 7291	Rev 7296
Line 29...	Line 29...
29	`from string import Template`	29	`from string import Template`
30	`import datetime`	30	`import datetime`
31	`import sys`	31	`import sys`
32	`import threading`	32	`import threading`
33	`import urllib2`	33	`import urllib2`
34	`from datetime import timedelta,datetime,date`	-
35		34
36	`sourceId = int(ConfigClient().get_property("sourceid"))`	35	`sourceId = int(ConfigClient().get_property("sourceid"))`
37	`to_addresses = ["khushal.bhatia@shop2020.in", "chandan.kumar@shop2020.in", "chaitnaya.vats@shop2020.in"]`	36	`to_addresses = ["khushal.bhatia@shop2020.in", "chandan.kumar@shop2020.in", "chaitnaya.vats@shop2020.in"]`
38	`mail_user = "cnc.center@shop2020.in"`	37	`mail_user = "cnc.center@shop2020.in"`
39	`mail_password = "5h0p2o2o"`	38	`mail_password = "5h0p2o2o"`
Line 253...	Line 252...
253	`flag = "ON" if item.isWarehousePreferenceSticky else "OFF"`	252	`flag = "ON" if item.isWarehousePreferenceSticky else "OFF"`
254	`message += "Warehouse preference sticky is {0}.\n".format(flag)`	253	`message += "Warehouse preference sticky is {0}.\n".format(flag)`
255		254
256	`ds_item.isWarehousePreferenceSticky = item.isWarehousePreferenceSticky`	255	`ds_item.isWarehousePreferenceSticky = item.isWarehousePreferenceSticky`
257		256
258	`ds_item.updatedOn = datetime.now()`	257	`ds_item.updatedOn = datetime.datetime.now()`
259		258
260	`# if item.activeOnStore and not ds_item.activeOnStore:`	259	`# if item.activeOnStore and not ds_item.activeOnStore:`
261	`# add_store_pricing(ds_item)`	260	`# add_store_pricing(ds_item)`
262	`ds_item.activeOnStore = item.activeOnStore`	261	`ds_item.activeOnStore = item.activeOnStore`
263		262
Line 292...	Line 291...
292	`ds_item.comments = item.comments`	291	`ds_item.comments = item.comments`
293	`if item.asin:`	292	`if item.asin:`
294	`ds_item.asin = item.asin`	293	`ds_item.asin = item.asin`
295	`ds_item.holdInventory = item.holdInventory`	294	`ds_item.holdInventory = item.holdInventory`
296	`ds_item.defaultInventory = item.defaultInventory`	295	`ds_item.defaultInventory = item.defaultInventory`
297	`ds_item.addedOn = datetime.now()`	296	`ds_item.addedOn = datetime.datetime.now()`
298	`ds_item.updatedOn = datetime.now()`	297	`ds_item.updatedOn = datetime.datetime.now()`
299	`if item.startDate:`	298	`if item.startDate:`
300	`ds_item.startDate = to_py_date(item.startDate)`	299	`ds_item.startDate = to_py_date(item.startDate)`
301	`ds_item.startDate = ds_item.startDate.replace(hour=0,second=0,minute=0)`	300	`ds_item.startDate = ds_item.startDate.replace(hour=0,second=0,minute=0)`
302	`if item.retireDate:`	301	`if item.retireDate:`
303	`ds_item.retireDate = to_py_date(item.retireDate)`	302	`ds_item.retireDate = to_py_date(item.retireDate)`
Line 1533...	Line 1532...
1533	`sp.minPrice = store.minPrice`	1532	`sp.minPrice = store.minPrice`
1534	`sp.minAdvancePrice = store.minAdvancePrice`	1533	`sp.minAdvancePrice = store.minAdvancePrice`
1535	`sp.maxPrice = store.maxPrice`	1534	`sp.maxPrice = store.maxPrice`
1536	`return sp`	1535	`return sp`
1537		1536
1538		-
1539	`def get_all_amazon_listed_items():`	1537	`def get_all_amazon_listed_items():`
1540	`return session.query(Amazonlisted).all()`	1538	`return session.query(Amazonlisted).all()`
1541		1539
1542	`def get_amazon_item_details(amazonItemId):`	1540	`def get_amazon_item_details(amazonItemId):`
1543	`amazonlisted = Amazonlisted.get_by(itemId=amazonItemId)`	1541	`amazonlisted = Amazonlisted.get_by(itemId=amazonItemId)`
Line 1587...	Line 1585...
1587	`if amazonlisted.category:`	1585	`if amazonlisted.category:`
1588	`amazon_item.category=amazonlisted.category`	1586	`amazon_item.category=amazonlisted.category`
1589	`session.commit()`	1587	`session.commit()`
1590		1588
1591	`def get_asin_items():`	1589	`def get_asin_items():`
1592	`from_date=datetime.now() - timedelta(days=10)`	1590	`from_date=datetime.datetime.now() - datetime.timedelta(days=10)`
1593	`return Item.query.filter(Item.updatedOn > from_date).all()`	1591	`return Item.query.filter(Item.updatedOn > from_date).all()`
1594		1592
1595	`def get_all_fba_listed_items():`	1593	`def get_all_fba_listed_items():`
1596	`return Amazonlisted.query.filter(Amazonlisted.isFba==True).all()`	1594	`return Amazonlisted.query.filter(Amazonlisted.isFba==True).all()`
1597		1595

Subversion Repositories SmartDukaan

(root)//trunk/PyProj/src/shop2020/model/v1/catalog/impl/DataAcessors.py – Rev 7291 → 7296