【ECSHOP】ECSHOP搜索添加“品牌名”搜索

来源：互联网发布：linux如何配置时钟同步编辑：程序博客网时间：2024/04/28 20:21

ECSHOP搜索添加“品牌名”搜索：

第一步：在根目录下的search.php找到：

$keywords  .= "(goods_name LIKE '%$val%' OR goods_sn LIKE '%$val%' OR keywords LIKE '%$val%' $sc_dsad)";

更改为：

$keywords  .= "(goods_name LIKE '%$val%' OR goods_sn LIKE '%$val%' OR brand_name LIKE '%$val%' OR keywords LIKE '%$val%' $sc_dsad)";

第二步：找到：

/* 获得符合条件的商品总数 */    $sql   = "SELECT COUNT(*) FROM " .$ecs->table('goods'). " AS g ".        "WHERE g.is_delete = 0 AND g.is_on_sale = 1 AND g.is_alone_sale = 1 $attr_in ".        "AND (( 1 " . $categories . $keywords . $brand . $min_price . $max_price . $intro . $outstock ." ) ".$tag_where." )";    $count = $db->getOne($sql);

更改为：

/* 获得符合条件的商品总数 */    $sql   = "SELECT COUNT(*) FROM " .$ecs->table('goods'). " AS g "."LEFT JOIN " . $GLOBALS['ecs']->table('brand') . " AS b ON b.brand_id =g.brand_id ".        "WHERE g.is_delete = 0 AND g.is_on_sale = 1 AND g.is_alone_sale = 1 $attr_in ".        "AND (( 1 " . $categories . $keywords . $brand . $min_price . $max_price . $intro . $outstock ." ) ".$tag_where." )";    $count = $db->getOne($sql);

第三步：找到：

/* 查询商品 */    $sql = "SELECT g.goods_id, g.goods_name, g.market_price, g.is_new, g.is_best, g.is_hot, g.shop_price AS org_price, ".                "IFNULL(mp.user_price, g.shop_price * '$_SESSION[discount]') AS shop_price, ".                "g.promote_price, g.promote_start_date, g.promote_end_date, g.goods_thumb, g.goods_img, g.original_img, g.goods_brief, g.goods_type ".            "FROM " .$ecs->table('goods'). " AS g ".            "LEFT JOIN " . $GLOBALS['ecs']->table('member_price') . " AS mp ".                    "ON mp.goods_id = g.goods_id AND mp.user_rank = '$_SESSION[user_rank]' ".            "WHERE g.is_delete = 0 AND g.is_on_sale = 1 AND g.is_alone_sale = 1 $attr_in ".                "AND (( 1 " . $categories . $keywords . $brand . $min_price . $max_price . $intro . $outstock . " ) ".$tag_where." ) " .            "ORDER BY $sort $order";    $res = $db->SelectLimit($sql, $size, ($page - 1) * $size);

更改为：

/* 查询商品 */    $sql = "SELECT g.goods_id, g.goods_name, g.market_price, g.is_new, g.is_best, g.is_hot, g.shop_price AS org_price, ".                "IFNULL(mp.user_price, g.shop_price * '$_SESSION[discount]') AS shop_price, ".                "g.promote_price, g.promote_start_date, g.promote_end_date, g.goods_thumb, g.goods_img, g.original_img, g.goods_brief, g.goods_type ".            "FROM " .$ecs->table('goods'). " AS g ".            "LEFT JOIN " . $GLOBALS['ecs']->table('member_price') . " AS mp ".                    "ON mp.goods_id = g.goods_id AND mp.user_rank = '$_SESSION[user_rank]' ".'LEFT JOIN ' . $GLOBALS['ecs']->table('brand') . ' AS b ON b.brand_id = g.brand_id '.             "WHERE g.is_delete = 0 AND g.is_on_sale = 1 AND g.is_alone_sale = 1 $attr_in ".                "AND (( 1 " . $categories . $keywords . $brand . $min_price . $max_price . $intro . $outstock . " ) ".$tag_where." ) " .            "ORDER BY $sort $order";    $res = $db->SelectLimit($sql, $size, ($page - 1) * $size);

至此，完成增加品牌搜索功能。

阅读全文

0 0