def get_pool_product_id_by_name(name, corp_id=None): product_model = bdd_util.exec_sql(bdd_util.DB_PRODUCT, "select * from product_product where name = %s", [name])[0] if corp_id: pool_product_model = bdd_util.exec_sql(bdd_util.DB_PRODUCT, "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(bdd_util.DB_PRODUCT, "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("ginger_product", "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("ginger_product", "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("ginger_product", "select * from product_pool_product where product_id = %s order by id asc", [product_model['id']])[0]
return pool_product_model['id']
def get_latest_order_bid():
objs = bdd_util.exec_sql(
"ginger_order",
"select * from order_order where type = 1 order by id desc limit 1",
[])
if len(objs) == 0:
objs = bdd_util.exec_sql(
"ginger_order",
"select * from order_order where type = 3 order by id desc limit 1",
[])
return objs[0]['bid']
def get_point_product_id_by_name(name):
product_id = product_steps.get_product_id_by_name(name)
objs = bdd_util.exec_sql(
"ginger_promotion",
"select * from point_product where product_id = %s", [product_id])
return objs[0]['id']
def get_sku_name_from_display_name(sku_name):
if sku_name == 'standard':
return sku_name
objs = bdd_util.exec_sql("ginger_product", "select * from product_sku", [])
for obj in objs:
if sku_name in obj['code']:
return obj['name']
def get_customer_id_by_name(name):
if name == '':
return 0
objs = bdd_util.exec_sql("ginger_crm", "select * from customer_customer where name = %s", [name])
return objs[0]['id']
def get_salesman_id_by_username(client, username):
user_id = finance_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_latest_invoice_bid():
objs = bdd_util.exec_sql(
"ginger_order",
"select * from order_order where type = 2 order by id desc limit 1",
[])
return objs[0]['bid']
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(bdd_util.DB_PRODUCT, "select * from cart_item where pool_product_id = %s", [pool_product_id])[0] return shopping_cart_item['id']
def get_product_property_id_by_name(name):
objs = bdd_util.exec_sql(
bdd_util.DB_PRODUCT,
"select * from product_sku_property 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("ginger_product", "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("ginger_product", "select * from product_sku_property where is_deleted = 0", [])
return objs
def get_product_sku_id_by_name(name):
objs = bdd_util.exec_sql("ginger_product", "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_product_property_value_ids():
objs = bdd_util.exec_sql(bdd_util.DB_PRODUCT,
"select * from product_sku_property_value", [])
return [obj['id'] for obj in objs]
def get_product_label_id_by_name(name):
objs = bdd_util.exec_sql("ginger_product", "select * from product_label where name = %s", [name])
return objs[0]['id']
def get_product_property_value_by_value(value):
objs = bdd_util.exec_sql(
bdd_util.DB_PRODUCT,
"select * from product_sku_property_value where Text = %s", [value])
return objs[0]['id'], objs[0]['property_id']
def get_product_category_id_by_name(name):
if name == '':
return 0
objs = bdd_util.exec_sql("ginger_product", "select * from product_category where name = %s", [name])
return objs[0]['id']
def get_ship_info_id_by_address(address): objs = bdd_util.exec_sql(bdd_util.DB_ORDER, "select * from mall_ship_info where address = %s", [address]) return objs[0]['id']
def get_point_rule_id_by_name(name):
if name == '':
return 0
objs = bdd_util.exec_sql("ginger_crm", "select * from point_rule where name = %s", [name])
return objs[0]['id']
