def get_pool_product_id_by_name(name, corp_id=None):
product_model = bdd_util.exec_sql("select * from product_product where name = %s", [name])[0]
if corp_id:
pool_product_model = bdd_util.exec_sql("select * from product_pool_product where product_id = %s and corp_id=%s", [product_model['id'], corp_id])[0]
else:
pool_product_model = bdd_util.exec_sql("select * from product_pool_product where product_id = %s order by id asc", [product_model['id']])[0]
return pool_product_model['id']
def get_pool_product_id_by_name(name, corpuser_name=None):
product_model = bdd_util.exec_sql(
"select * from product_product where name = %s", [name])[0]
if corpuser_name:
client = RestClient()
corp_id = step_util.get_corp_id_for_corpuser(client, corpuser_name)
pool_product_model = bdd_util.exec_sql(
"select * from product_pool_product where product_id = %s and corp_id=%s",
[product_model['id'], corp_id])[0]
else:
pool_product_model = bdd_util.exec_sql(
"select * from product_pool_product where product_id = %s order by id asc",
[product_model['id']])[0]
return pool_product_model['id']
def get_product_sku_id_by_name(name):
objs = bdd_util.exec_sql(
"select * from product_sku where name = %s and is_deleted = 0", [name])
if len(objs) > 0:
return objs[0]['id']
else:
return 0
def get_sku_name_from_display_name(sku_name):
if sku_name == 'standard':
return sku_name
objs = bdd_util.exec_sql("select * from product_sku", [])
for obj in objs:
if sku_name in obj['code']:
return obj['name']
def get_product_category_id_by_name(name):
if name == '':
return 0
objs = bdd_util.exec_sql("select * from product_category where name = %s",
[name])
print objs, "objs"
return objs[0]['id']
def get_product_label_id_by_name(name):
objs = bdd_util.exec_sql("select * from product_label where name = %s",
[name])
return objs[0]['id']
def get_product_property_values_for(property_ids):
property_ids_str = ','.join(map(lambda x: "{}".format(x), property_ids))
objs = bdd_util.exec_sql(
"select * from product_sku_property_value where is_deleted = 0 and property_id in ({})"
.format(property_ids_str), [])
return objs
def get_product_properties():
objs = bdd_util.exec_sql(
"select * from product_sku_property where is_deleted = 0", [])
return objs
def get_shopping_cart_item_id_by_product_name(product_name):
pool_product_id = get_pool_product_id_by_name(product_name)
shopping_cart_item = bdd_util.exec_sql("select * from mall_shopping_cart where product_id = %s", [pool_product_id])[0]
return shopping_cart_item['id']
def get_product_property_value_by_value(value):
objs = bdd_util.exec_sql("select * from product_sku_property_value where Text = %s", [value])
return objs[0]['id'], objs[0]['property_id']
def get_ship_info_id_by_address(address):
objs = bdd_util.exec_sql("select * from mall_ship_info where address = %s", [address])
return objs[0]['id']
def get_product_property_value_ids():
objs = bdd_util.exec_sql("select * from product_sku_property_value", [])
return [obj['id'] for obj in objs]
def get_salesman_id_by_username(client, username):
user_id = plutus_steps.get_user_id_by_user_name(username)
objs = bdd_util.exec_sql("select * from mall_salesman where user_id = %s", [user_id])
return objs[0]['id']
def get_sku_code_from_display_name(sku_name):
target_pattern = '_%s' % sku_name
objs = bdd_util.exec_sql("select * from product_sku", [])
for obj in objs:
if target_pattern in obj['code']:
return obj['name']
def get_latest_invoice_bid():
objs = bdd_util.exec_sql("select * from order_order where type = 2 order by id desc limit 1", [])
return objs[0]['bid']
def get_latest_order_bid():
objs = bdd_util.exec_sql("select * from order_order where type = 1 order by id desc limit 1", [])
if len(objs) == 0:
objs = bdd_util.exec_sql("select * from order_order where type = 3 order by id desc limit 1", [])
return objs[0]['bid']
