from common import util


def get_bus_line_prod(prod_id):
    """
    获取主线路产品信息
    :param prod_id:
    :return:
    """
    sql = """SELECT
        a.pro_cate_id,
        a.pro_cate_name,
        a.category_id,
        (SELECT category_name  from  base_category b where a.category_id = category_id) 'category_name',
        ifnull(a.sign,'') 'sign'
        from prod_category a
        WHERE a.pro_cate_id = %s"""
    get_info = util.select_row(sql, [prod_id])
    return get_info


def get_prod_array(prod_id):
    """
    获取产品票种数组
    :param prod_id:
    :return:
    """
    sql = """SELECT 
              prod_id,prod_name,prod_price,0 as 'prod_count',99 as 'prod_stock'
              from prod_main 
              WHERE prod_cate_id = %s"""
    get_info = util.select_all(sql, [prod_id])
    return get_info