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']