asmodeus
/
shop
1
0
Fork 0
Code Issues Pull Requests Projects Releases Wiki Activity
You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
512 Commits
1 Branch
0 Tags
166 MiB
 
 
 
 
Branch: master
Branches Tags
${ item.name }
Create tag ${ searchTerm }
Create branch ${ searchTerm }
from 'master'
${ noResults }
shop/merchants_store.php

1204 lines
51 KiB
Raw Permalink Blame History

<?php
/**
* ECSHOP 购物流程
* ============================================================================
* 版权所有 2005-2016 上海商创网络科技有限公司，并保留所有权利。
* 网站地址: http://www.ecmoban.com；
* ----------------------------------------------------------------------------
* 这不是一个自由软件！您只能在不用于商业目的的前提下对程序代码进行修改和
* 使用；不允许对程序代码以任何形式任何目的的再发布。
* ============================================================================
* $Author: douqinghua $
* $Id: merchants_steps.php 17218 2011-01-24 04:10:41Z douqinghua $
*/
define('IN_ECS', true);
require(dirname(__FILE__) . '/includes/init.php');
require(dirname(__FILE__) . '/includes/phpqrcode/phpqrcode.php'); //by wu
if ((DEBUG_MODE & 2) != 2)
{
$smarty->caching = true;
}
require(ROOT_PATH . 'includes/lib_area.php'); //ecmoban模板堂 --zhuo
define('IN_ECS', true);
/* 初始化分页信息 */
$page = isset($_REQUEST['page']) && intval($_REQUEST['page']) > 0 ? intval($_REQUEST['page']) : 1;
$size = isset($_CFG['page_size']) && intval($_CFG['page_size']) > 0 ? intval($_CFG['page_size']) : 10;
$brand = isset($_REQUEST['brand']) && intval($_REQUEST['brand']) > 0 ? intval($_REQUEST['brand']) : 0;
$price_max = isset($_REQUEST['price_max']) && intval($_REQUEST['price_max']) > 0 ? intval($_REQUEST['price_max']) : 0;
$price_min = isset($_REQUEST['price_min']) && intval($_REQUEST['price_min']) > 0 ? intval($_REQUEST['price_min']) : 0;
$filter_attr_str = isset($_REQUEST['filter_attr']) ? htmlspecialchars(trim($_REQUEST['filter_attr'])) : '0';
$filter_attr_str = trim(urldecode($filter_attr_str));
$filter_attr_str = preg_match('/^[\d\.]+$/',$filter_attr_str) ? $filter_attr_str : '';
$filter_attr = empty($filter_attr_str) ? '' : explode('.', $filter_attr_str);
//正则去掉js代码
$preg = "/<script[\s\S]*?<\/script>/i";
/* 排序、显示方式以及类型 */
$default_display_type = $_CFG['show_order_type'] == '0' ? 'list' : ($_CFG['show_order_type'] == '1' ? 'grid' : 'text');
$default_sort_order_method = $_CFG['sort_order_method'] == '0' ? 'DESC' : 'ASC';
$default_sort_order_type = $_CFG['sort_order_type'] == '0' ? 'goods_id' : ($_CFG['sort_order_type'] == '1' ? 'shop_price' : 'last_update');
$sort = (isset($_REQUEST['sort']) && in_array(trim(strtolower($_REQUEST['sort'])), array('goods_id', 'shop_price', 'last_update','sales_volume'))) ? trim($_REQUEST['sort']) : $default_sort_order_type;
$order = (isset($_REQUEST['order']) && in_array(trim(strtoupper($_REQUEST['order'])), array('ASC', 'DESC'))) ? trim($_REQUEST['order']) : $default_sort_order_method;
$display = isset($_REQUEST['display']) ? strtolower($_REQUEST['display']) : '';
$display=!empty($display)?preg_replace($preg,"",stripslashes($display)):'';
$merchant_id = isset($_REQUEST['merchant_id']) ? intval($_REQUEST['merchant_id']) : 0;
$keyword = trim($_REQUEST['keyword']) ? trim($_REQUEST['keyword']) : '';
$keyword = htmlspecialchars($keyword);
$cat_id = isset($_REQUEST['id']) ? intval($_REQUEST['id']) : 0;
$user_id = isset($_SESSION['user_id'])? $_SESSION['user_id'] : 0;
//商家不存则跳转回首页
$shop_date = array('shop_id');
$shop_where = "user_id = '$merchant_id'";
$shop_id = get_table_date('merchants_shop_information', $shop_where, $shop_date);
if($merchant_id == 0 || $shop_id < 1){
header("Location: index.php\n");
exit;
}
//ecmoban模板堂 --zhuo start 仓库
if (!empty($_REQUEST['act']) && $_REQUEST['act'] == 'in_warehouse'){
include('includes/cls_json.php');
$json = new JSON;
$res = array('err_msg' => '', 'result' => '', 'qty' => 1);
clear_cache_files();
setcookie('region_id', $pid, gmtime() + 3600 * 24 * 30);
setcookie('regionId', $pid, gmtime() + 3600 * 24 * 30);
$area_region = 0;
setcookie('area_region', $area_region, gmtime() + 3600 * 24 * 30);
$res['goods_id'] = $goods_id;
$json = new JSON;
die($json->encode($res));
}elseif (!empty($_REQUEST['act']) && $_REQUEST['act'] == 'in_stock'){
include('includes/cls_json.php');
$json = new JSON;
$res = array('err_msg' => '', 'result' => '', 'qty' => 1);
clear_cache_files();
if(!isset($_COOKIE['province'])){
$area_array = get_ip_area_name();
if($area_array['county_level'] == 2){
$date = array('region_id', 'parent_id', 'region_name');
$where = "region_name = '" .$area_array['area_name']. "' AND region_type = 2";
$city_info = get_table_date('region', $where, $date, 1);
$date = array('region_id', 'region_name');
$where = "region_id = '" .$city_info[0]['parent_id']. "'";
$province_info = get_table_date('region', $where, $date);
$where = "parent_id = '" .$city_info[0]['region_id']. "' order by region_id asc limit 0, 1";
$district_info = get_table_date('region', $where, $date, 1);
}elseif($area_array['county_level'] == 1){
$area_name = $area_array['area_name'];
$date = array('region_id', 'region_name');
$where = "region_name = '$area_name'";
$province_info = get_table_date('region', $where, $date);
$where = "parent_id = '" .$province_info['region_id']. "' order by region_id asc limit 0, 1";
$city_info = get_table_date('region', $where, $date, 1);
$where = "parent_id = '" .$city_info[0]['region_id']. "' order by region_id asc limit 0, 1";
$district_info = get_table_date('region', $where, $date, 1);
}
}
$goods_id = empty($_GET['id']) ? 0 : $_GET['id'];
$province = empty($_GET['province']) ? $province_info['region_id'] : $_GET['province'];
$city = empty($_GET['city']) ? $city_info[0]['region_id'] : $_GET['city'];
$district = empty($_GET['district']) ? $district_info[0]['region_id'] : $_GET['district'];
$d_null = empty($_GET['d_null']) ? 0 : $_GET['d_null'];
$user_id = empty($_GET['user_id']) ? 0 : $_GET['user_id'];
$user_address = get_user_address_region($user_id);
$user_address = explode(",",$user_address['region_address']);
setcookie('province', $province, gmtime() + 3600 * 24 * 30);
setcookie('city', $city, gmtime() + 3600 * 24 * 30);
setcookie('district', $district, gmtime() + 3600 * 24 * 30);
$regionId = 0;
setcookie('regionId', $regionId, gmtime() + 3600 * 24 * 30);
$res['d_null'] = $d_null;
if($d_null == 0){
if(in_array($district,$user_address)){
$res['isRegion'] = 1;
}else{
$res['message'] = "您尚未拥有此配送地区，请您填写配送地址";
$res['isRegion'] = 88; //原为0
}
}else{
setcookie('district', '', gmtime() + 3600 * 24 * 30);
}
$res['goods_id'] = $goods_id;
die($json->encode($res));
}elseif (!empty($_REQUEST['act']) && $_REQUEST['act'] == 'ajax_collect_store') //Ajax取消/关注
{
//修改 by tong
include_once('includes/cls_json.php');
$json = new JSON;
$res = array('err_msg' => '', 'result' => '', 'error' => 0);
$type = isset($_REQUEST['type']) ? intval($_REQUEST['type']) : 0;
$merchant_id = isset($_REQUEST['merchant_id']) ? trim($_REQUEST['merchant_id']) : '';
$execute = isset($_REQUEST['execute']) ? intval($_REQUEST['execute']) : 0;
if((isset($_SESSION['user_id']) && $_SESSION['user_id'] < 1) || !isset($_SESSION['user_id'])){
$res['error'] = 2;
}else{
//判断是否已经关注
$sql = "SELECT rec_id FROM " .$ecs->table('collect_store'). " WHERE user_id = '$user_id' AND ru_id = '$merchant_id' ";
$rec_id = $db->getOne($sql);
if($execute == 1){
// 弹出提示
if($type == 0 || $type == 1){
$res['error'] = 3;
}else if($type == 2){
if($rec_id < 1){
$res['error'] = 3;
}else{
$res['error'] = 1;
}
}
}else{
//取消关注
if($type == 0 || $type == 1){
if(!empty($merchant_id)){
$sql= "DELETE FROM " .$ecs->table('collect_store'). " WHERE ru_id in($merchant_id)";
$db->query($sql);
}
}
//添加关注
if($rec_id < 1){
$is_attention = 1;
$sql = "INSERT INTO " .$ecs->table('collect_store'). "(`user_id`, `ru_id`, `add_time`, `is_attention`)VALUES('$user_id', '$merchant_id', '" .gmtime(). "', '$is_attention')";
$db->query($sql);
}
}
}
$res['type'] = $type;
$res['merchant_id'] = $merchant_id;
die($json->encode($res));
}
#需要查询的IP start
if(!isset($_COOKIE['province'])){
$area_array = get_ip_area_name();
if($area_array['county_level'] == 2){
$date = array('region_id', 'parent_id', 'region_name');
$where = "region_name = '" .$area_array['area_name']. "' AND region_type = 2";
$city_info = get_table_date('region', $where, $date, 1);
$date = array('region_id', 'region_name');
$where = "region_id = '" .$city_info[0]['parent_id']. "'";
$province_info = get_table_date('region', $where, $date);
$where = "parent_id = '" .$city_info[0]['region_id']. "' order by region_id asc limit 0, 1";
$district_info = get_table_date('region', $where, $date, 1);
}elseif($area_array['county_level'] == 1){
$area_name = $area_array['area_name'];
$date = array('region_id', 'region_name');
$where = "region_name = '$area_name'";
$province_info = get_table_date('region', $where, $date);
$where = "parent_id = '" .$province_info['region_id']. "' order by region_id asc limit 0, 1";
$city_info = get_table_date('region', $where, $date, 1);
$where = "parent_id = '" .$city_info[0]['region_id']. "' order by region_id asc limit 0, 1";
$district_info = get_table_date('region', $where, $date, 1);
}
}
#需要查询的IP end
$order_area = get_user_order_area($user_id);
$user_area = get_user_area_reg($user_id); //2014-02-25
if($order_area['province'] && $user_id > 0){
$province_id = $order_area['province'];
}else{
if($user_area['province'] > 0){
$province_id = $user_area['province'];
setcookie('province', $user_area['province'], gmtime() + 3600 * 24 * 30);
$region_id = get_province_id_warehouse($province_id);
}else{
$sql = "select region_name from " .$ecs->table('region_warehouse'). " where regionId = '" .$province_info['region_id']. "'";
$warehouse_name = $db->getOne($sql);
$province_id = $province_info['region_id'];
$cangku_name = $warehouse_name;
$region_id = get_warehouse_name_id(0,$cangku_name);
}
}
if($order_area['province'] && $user_id > 0){
$city_id = $order_area['city'];
}else{
if($user_area['city'] > 0){
$city_id = $user_area['city'];
setcookie('city', $user_area['city'], gmtime() + 3600 * 24 * 30);
}else{
$city_id = $city_info[0]['region_id'];
}
}
if($order_area['province'] && $user_id > 0){
$district_id = $order_area['district'];
}else{
if($user_area['district'] > 0){
$district_id = $user_area['district'];
setcookie('district', $user_area['district'], gmtime() + 3600 * 24 * 30);
}else{
$district_id = $district_info[0]['region_id'];
}
}
$province_id = isset($_COOKIE['province']) ? $_COOKIE['province'] : $province_id;
$child_num = get_region_child_num($province_id);
if($child_num > 0){
$city_id = isset($_COOKIE['city']) ? $_COOKIE['city'] : $city_id;
}else{
$city_id = '';
}
$child_num = get_region_child_num($city_id);
if($child_num > 0){
$district_id = isset($_COOKIE['district']) ? $_COOKIE['district'] : $district_id;
}else{
$district_id = '';
}
$region_id = !isset($_COOKIE['region_id']) ? $region_id : $_COOKIE['region_id'];
$goods_warehouse = get_warehouse_goods_region($province_id); //查询用户选择的配送地址所属仓库
if($goods_warehouse){
$regionId = $goods_warehouse['region_id'];
if($_COOKIE['region_id'] && $_COOKIE['regionId']){
$gw = 0;
}else{
$gw = 1;
}
}
if($gw){
$region_id = $regionId;
setcookie('area_region', $region_id, gmtime() + 3600 * 24 * 30);
}
setcookie('goodsId', $goods_id, gmtime() + 3600 * 24 * 30);
//ecmoban模板堂 --zhuo end 仓库
for($i=1;$i<=$_CFG['auction_ad'];$i++){
$ad_arr .= "'users_a".$i.",";
}
$smarty->assign('adarr', $ad_arr); // 分类广告位
for($i=1;$i<=$_CFG['auction_ad'];$i++){
$adarr_bott .= "'users_b".$i.",";
}
$smarty->assign('adarr_bott', $adarr_bott); // 分类广告位
$shop_info = get_shop_name($merchant_id, 3); //店铺名称
$smarty->assign('shop_info', $shop_info); // 店铺信息
$store_conut = get_merchants_store_info($merchant_id);
$store_info = get_merchants_store_info($merchant_id, 1);
$is_cache = 1;
if($store_conut > 0 && !empty($store_info['seller_theme'])){
if($cat_id > 0){
$dwt = 'merchants_store.dwt';
}elseif($display != ''){
$dwt = 'merchants_store.dwt';
}elseif($brand > 0){
$dwt = 'merchants_store.dwt';
}elseif($filter_attr != ''){
$dwt = 'merchants_store.dwt';
}elseif($keyword != ''){
$dwt = 'merchants_store.dwt';
}elseif($price_max != ''){
$dwt = 'merchants_store.dwt';
}elseif($price_min != ''){
$dwt = 'merchants_store.dwt';
}elseif($cat_id > 0 && $sort != ''){
$dwt = 'merchants_store.dwt';
}else{
$id_name = '_'.$merchant_id."',";
$str_ad = str_replace(',',$id_name,$ad_arr);
$in_ad_arr = substr($str_ad,0,strlen($str_ad)-1);
$ad_child = get_ad_posti_child($in_ad_arr);
$smarty->assign('ad_child', $ad_child);
$shopheader = get_store_header($merchant_id, $store_info['seller_theme']);
$header_content = $shopheader['content'];
$smarty->assign('header_content', $header_content); // 头部内容
$smarty->assign('shopheader', $shopheader); // 头部信息
$store_bg = get_store_bg($merchant_id, $store_info['seller_theme']);
$smarty->assign('store_bg', $store_bg); // 店铺背景
$smarty->assign('store', $store_info); // 店铺背景
$is_cache = 0;
$dwt = $store_info['seller_theme'].'/seller_store.dwt';
}
}else{
$dwt = 'merchants_store.dwt';
}
if($is_cache){
$cache_id = sprintf('%X', crc32($cat_id . '-' . $merchant_id . '-' . $display . '-' . $sort .'-' . $order .'-' . $page . '-' . $size . '-' . $_SESSION['user_rank'] . '-' .
$_CFG['lang'] .'-'. $brand. '-' . $price_max . '-' .$price_min . '-' . $filter_attr_str.'-'.$keyword));
$not = '';
}else{
$cache_id = '';
$not = 'not';
}
if (!$smarty->is_cached($dwt, $cache_id))
{
assign_template();
$smarty->assign('merchant_id', $merchant_id); // 商家ID
$smarty->assign('cat_id', $cat_id); // 分类ID
$parent_id = category_store_parent($cat_id);
$smarty->assign('parent_id', $parent_id); // 分类父级ID
//logo start
$cat['name'] = $cat['cat_name'];
$cat['id'] = $cat['cat_id'];
$smarty->assign('cat', $cat);
//logo end
//筛选 start
$cat = get_store_cat_info($cat_id); // 获得分类的相关信息
//ecmoban模板堂 --zhuo start
if($cat_id == 0){
$cat_where = " g.user_id = '$merchant_id' AND ";
$children = '';
}else{
$children = get_category_parentChild_tree1($cat_id, 1);
$children = arr_foreach($children);
if($children){
$children = implode(",", $children) . "," . $cat_id;
$children = get_children($children, 0, 1);
}else{
$children = "g.cat_id IN ($cat_id)";
}
$cat_where = "($children OR " . get_extension_goods($children) . ") AND ";
}
//ecmoban模板堂 --zhuo end
//地区ID
$province_list = get_warehouse_province();
$smarty->assign('province_list', $province_list); //省、直辖市
$city_list = get_region_city_county($province_id);
$smarty->assign('city_list', $city_list); //省下级市
$district_list = get_region_city_county($city_id);
$smarty->assign('district_list', $district_list);//市下级县
$smarty->assign('province_row', get_region_name($province_id));
$smarty->assign('city_row', get_region_name($city_id));
$smarty->assign('district_row', get_region_name($district_id));
$smarty->assign('user_id', $user_id);
$smarty->assign('region_id', $region_id); //仓库
$area_info = get_area_info($province_id);
$smarty->assign('area_id', $area_info['region_id']); //仓库管理的地区ID
//地区ID
if($cat_id > 0){
if (!empty($cat))
{
$smarty->assign('keywords', htmlspecialchars($cat['keywords']));
$smarty->assign('description', htmlspecialchars($cat['cat_desc']));
$smarty->assign('cat_style', htmlspecialchars($cat['style']));
}
else
{
/* 如果分类不存在则返回首页 */
ecs_header("Location: ./\n");
exit;
}
/* 赋值固定内容 */
if ($brand > 0)
{
$sql = "SELECT brandName FROM " .$GLOBALS['ecs']->table('merchants_shop_brand'). " WHERE bid = '$brand' AND audit_status = 1";
$brand_name = $db->getOne($sql);
}
else
{
$brand_name = '';
}
/* 获取价格分级 */
if ($cat['grade'] == 0 && $cat['parent_id'] != 0)
{
$cat['grade'] = get_store_parent_grade($cat_id); //如果当前分类级别为空，取最近的上级分类
}
if ($cat['grade'] > 1)
{
/* 需要价格分级 */
/*
算法思路：
1、当分级大于1时，进行价格分级
2、取出该类下商品价格的最大值、最小值
3、根据商品价格的最大值来计算商品价格的分级数量级：
价格范围(不含最大值) 分级数量级
0-0.1 0.001
0.1-1 0.01
1-10 0.1
10-100 1
100-1000 10
1000-10000 100
4、计算价格跨度：
取整((最大值-最小值) / (价格分级数) / 数量级) * 数量级
5、根据价格跨度计算价格范围区间
6、查询数据库
可能存在问题：
1、
由于价格跨度是由最大值、最小值计算出来的
然后再通过价格跨度来确定显示时的价格范围区间
所以可能会存在价格分级数量不正确的问题
该问题没有证明
2、
当价格=最大值时，分级会多出来，已被证明存在
*/
//ecmoban模板堂 --zhuo start
$leftJoin = '';
$leftJoin .= " left join " .$GLOBALS['ecs']->table('warehouse_goods'). " as wg on g.goods_id = wg.goods_id and wg.region_id = '$region_id' ";
$leftJoin .= " left join " .$GLOBALS['ecs']->table('warehouse_area_goods'). " as wag on g.goods_id = wag.goods_id and wag.region_id = '" .$area_info['region_id']. "'";
//ecmoban模板堂 --zhuo end
$sql = "SELECT min(IF(g.model_price < 1, g.shop_price, IF(g.model_price < 2, wg.warehouse_price, wag.region_price))) AS min, " .
" max(IF(g.model_price < 1, g.shop_price, IF(g.model_price < 2, wg.warehouse_price, wag.region_price))) as max ".
" FROM " . $ecs->table('goods'). " AS g ". $leftJoin .
" WHERE $cat_where g.is_delete = 0 AND g.is_on_sale = 1 AND g.is_alone_sale = 1 ";
//获得当前分类下商品价格的最大值、最小值
$row = $db->getRow($sql);
// 取得价格分级最小单位级数，比如，千元商品最小以100为级数
$price_grade = 0.0001;
for($i=-2; $i<= log10($row['max']); $i++)
{
$price_grade *= 10;
}
//跨度
$dx = ceil(($row['max'] - $row['min']) / ($cat['grade']) / $price_grade) * $price_grade;
if($dx == 0)
{
$dx = $price_grade;
}
for($i = 1; $row['min'] > $dx * $i; $i ++);
for($j = 1; $row['min'] > $dx * ($i-1) + $price_grade * $j; $j++);
$row['min'] = $dx * ($i-1) + $price_grade * ($j - 1);
for(; $row['max'] >= $dx * $i; $i ++);
$row['max'] = $dx * ($i) + $price_grade * ($j - 1);
$sql = "SELECT (FLOOR((IF(g.model_price < 1, g.shop_price, IF(g.model_price < 2, wg.warehouse_price, wag.region_price)) - $row[min]) / $dx)) AS sn, COUNT(*) AS goods_num ".
" FROM " . $ecs->table('goods') . " AS g ". $leftJoin .
" WHERE $cat_where g.is_delete = 0 AND g.is_on_sale = 1 AND g.is_alone_sale = 1 ".
" GROUP BY sn ";
$price_grade = $db->getAll($sql);
foreach ($price_grade as $key=>$val)
{
$temp_key = $key + 1;
$price_grade[$temp_key]['goods_num'] = $val['goods_num'];
$price_grade[$temp_key]['start'] = $row['min'] + round($dx * $val['sn']);
$price_grade[$temp_key]['end'] = $row['min'] + round($dx * ($val['sn'] + 1));
$price_grade[$temp_key]['price_range'] = $price_grade[$temp_key]['start'] . '&nbsp;-&nbsp;' . $price_grade[$temp_key]['end'];
$price_grade[$temp_key]['formated_start'] = price_format($price_grade[$temp_key]['start']);
$price_grade[$temp_key]['formated_end'] = price_format($price_grade[$temp_key]['end']);
$price_grade[$temp_key]['url'] = build_uri('merchants_store', array('cid'=>$cat_id, 'urid' => $merchant_id, 'bid'=>$brand, 'price_min'=>$price_grade[$temp_key]['start'], 'price_max'=> $price_grade[$temp_key]['end'], 'filter_attr'=>$filter_attr_str), $cat['cat_name']);
/* 判断价格区间是否被选中 */
if (isset($_REQUEST['price_min']) && $price_grade[$temp_key]['start'] == $price_min && $price_grade[$temp_key]['end'] == $price_max)
{
$price_grade[$temp_key]['selected'] = 1;
}
else
{
$price_grade[$temp_key]['selected'] = 0;
}
}
$price_grade[0]['start'] = 0;
$price_grade[0]['end'] = 0;
$price_grade[0]['price_range'] = $_LANG['all_attribute'];
$price_grade[0]['url'] = build_uri('merchants_store', array('cid' => $cat_id, 'urid' => $merchant_id, 'bid'=>$brand, 'price_min'=>0, 'price_max'=> 0, 'filter_attr'=>$filter_attr_str), $cat['cat_name']);
$price_grade[0]['selected'] = empty($price_max) ? 1 : 0;
$smarty->assign('price_grade', $price_grade);
}
/* 品牌筛选 */
$sql = "SELECT msb.* FROM " .$GLOBALS['ecs']->table('merchants_shop_brand') ." AS msb " .
" LEFT JOIN " .$GLOBALS['ecs']->table('goods'). " AS g ON msb.bid = g.brand_id " .
" WHERE $cat_where msb.user_id = '$merchant_id' AND msb.audit_status = 1 group by g.brand_id";
$brands = $GLOBALS['db']->getAll($sql);
foreach ($brands AS $key => $val)
{
$temp_key = $key + 1;
$brands[$temp_key]['brand_name'] = $val['brandName'];
$brands[$temp_key]['bid'] = $val['bid'];
$brands[$temp_key]['url'] = build_uri('merchants_store', array('cid' => $cat_id, 'urid' => $merchant_id, 'bid' => $val['bid'], 'price_min'=>$price_min, 'price_max'=> $price_max, 'filter_attr'=>$filter_attr_str), $cat['cat_name']);
/* 判断品牌是否被选中 */
if ($brand == $brands[$key]['bid'])
{
$brands[$temp_key]['selected'] = 1;
}
else
{
$brands[$temp_key]['selected'] = 0;
}
}
$brands[0]['brand_name'] = $_LANG['all_attribute'];
$brands[0]['url'] = build_uri('merchants_store', array('cid' => $cat_id, 'urid' => $merchant_id, 'bid' => 0, 'price_min'=>$price_min, 'price_max'=> $price_max, 'filter_attr'=>$filter_attr_str), $cat['cat_name']);
$brands[0]['selected'] = empty($brand) ? 1 : 0;
$smarty->assign('brands', $brands);
/* 属性筛选 */
$ext = ''; //商品查询条件扩展
if ($cat['filter_attr'] > 0)
{
$cat_filter_attr = explode(',', $cat['filter_attr']); //提取出此分类的筛选属性
$all_attr_list = array();
foreach ($cat_filter_attr AS $key => $value)
{
$sql = "SELECT a.attr_name FROM " . $ecs->table('attribute') . " AS a, " . $ecs->table('goods_attr') . " AS ga, " . $ecs->table('goods') . " AS g WHERE $cat_where a.attr_id = ga.attr_id AND g.goods_id = ga.goods_id AND g.is_delete = 0 AND g.is_on_sale = 1 AND g.is_alone_sale = 1 AND a.attr_id='$value'";
if($temp_name = $db->getOne($sql))
{
$all_attr_list[$key]['filter_attr_name'] = $temp_name;
$sql = "SELECT a.attr_id, MIN(a.goods_attr_id ) AS goods_id, a.attr_value AS attr_value FROM " . $ecs->table('goods_attr') . " AS a, " . $ecs->table('goods') .
" AS g" .
" WHERE $cat_where g.goods_id = a.goods_id AND g.is_delete = 0 AND g.is_on_sale = 1 AND g.is_alone_sale = 1 ".
" AND a.attr_id='$value' ".
" GROUP BY a.attr_value";
$attr_list = $db->getAll($sql);
$temp_arrt_url_arr = array();
for ($i = 0; $i < count($cat_filter_attr); $i++) //获取当前url中已选择属性的值，并保留在数组中
{
$temp_arrt_url_arr[$i] = !empty($filter_attr[$i]) ? $filter_attr[$i] : 0;
}
$temp_arrt_url_arr[$key] = 0; //“全部”的信息生成
$temp_arrt_url = implode('.', $temp_arrt_url_arr);
$all_attr_list[$key]['attr_list'][0]['attr_value'] = $_LANG['all_attribute'];
$all_attr_list[$key]['attr_list'][0]['url'] = build_uri('merchants_store', array('cid'=>$cat_id, 'urid' => $merchant_id, 'bid'=>$brand, 'price_min'=>$price_min, 'price_max'=>$price_max, 'filter_attr'=>$temp_arrt_url), $cat['cat_name']);
$all_attr_list[$key]['attr_list'][0]['selected'] = empty($filter_attr[$key]) ? 1 : 0;
foreach ($attr_list as $k => $v)
{
$temp_key = $k + 1;
$temp_arrt_url_arr[$key] = $v['goods_id']; //为url中代表当前筛选属性的位置变量赋值,并生成以‘.’分隔的筛选属性字符串
$temp_arrt_url = implode('.', $temp_arrt_url_arr);
$all_attr_list[$key]['attr_list'][$temp_key]['attr_value'] = $v['attr_value'];
$all_attr_list[$key]['attr_list'][$temp_key]['url'] = build_uri('merchants_store', array('cid'=>$cat_id, 'urid' => $merchant_id, 'bid'=>$brand, 'price_min'=>$price_min, 'price_max'=>$price_max, 'filter_attr'=>$temp_arrt_url), $cat['cat_name']);
if (!empty($filter_attr[$key]) AND $filter_attr[$key] == $v['goods_id'])
{
$all_attr_list[$key]['attr_list'][$temp_key]['selected'] = 1;
}
else
{
$all_attr_list[$key]['attr_list'][$temp_key]['selected'] = 0;
}
}
}
}
$smarty->assign('filter_attr_list', $all_attr_list);
// 扩展商品查询条件
if (!empty($filter_attr))
{
$ext_sql = "SELECT DISTINCT(b.goods_id) FROM " . $ecs->table('goods_attr') . " AS a, " . $ecs->table('goods_attr') . " AS b " . "WHERE ";
$ext_group_goods = array();
foreach ($filter_attr AS $k => $v)
{
if (is_numeric($v) && $v !=0 &&isset($cat_filter_attr[$k]))
{
$sql = $ext_sql . "b.attr_value = a.attr_value AND b.attr_id = " . $cat_filter_attr[$k] ." AND a.goods_attr_id = " . $v;
$ext_group_goods = $db->getColCached($sql);
$ext .= ' AND ' . db_create_in($ext_group_goods, 'g.goods_id');
}
}
}
}
//筛选 end
}
$position = assign_ur_here(0, $shop_info['shoprz_brandName'].$shop_info['shopNameSuffix']);
$smarty->assign('page_title', $position['title']); // 页面标题
$smarty->assign('ur_here', $position['ur_here']); // 当前位置
$smarty->assign('helps', get_shop_help()); // 网店帮助
$categories_pro = get_category_tree_leve_one();
$smarty->assign('categories_pro', $categories_pro); // 分类树加强版
$smarty->assign('keyword', htmlspecialchars($keyword));
$smarty->assign('price_min', htmlspecialchars($price_min));
$smarty->assign('price_max', htmlspecialchars($price_max));
$count = get_store_goods_count($children, $brand, $price_min, $price_max, $ext, $merchant_id, $region_id, $area_info['region_id'], $keyword);
$max_page = ($count> 0) ? ceil($count / $size) : 1;
if ($page > $max_page)
{
$page = $max_page;
}
$goodslist = store_get_goods($children, $brand, $price_min, $price_max, $ext, $size, $page, $sort, $order, $merchant_id, $region_id, $area_info['region_id'], $keyword);
//新增分类页商品相册 by mike start 20131128
if(is_array($goodslist)){
foreach($goodslist as $key=>$vo){
$goodslist[$key]['pictures'] = get_goods_gallery($vo['goods_id']);// 商品相册
}
}
//新增分类页商品相册 by mike end
$smarty->assign('goods_list', $goodslist);
$smarty->assign('script_name', 'merchants_store');
$smarty->assign('category', $cat_id);
$smarty->assign('count', $count);
if($merchant_id > 0){
$goods_hot = 'g.store_hot = 1';
$goods_new = 'g.store_new = 1';
}
$goods_hot = get_hot_new_best_goods($goods_hot, $merchant_id, $region_id, $area_info['region_id']);
$smarty->assign('goods_hot', $goods_hot); //热销商品
$goods_new = get_hot_new_best_goods($goods_new, $merchant_id, $region_id, $area_info['region_id']);
$smarty->assign('goods_new', $goods_new); //新品推荐
if(empty($cat_id)){
$cat_id = 0;
}
assign_pager('merchants_store', $cat_id, $count, $size, $sort, $order, $page, '', $brand, $price_min, $price_max, $display, $filter_attr_str, '', '', $merchant_id, $keyword); // 分页
/* 页面中的动态内容 */
assign_dynamic('merchants_store');
}
if($merchant_id > 0){
$merchants_goods_comment = get_merchants_goods_comment($merchant_id); //商家所有商品评分类型汇总
}
$smarty->assign('merch_cmt', $merchants_goods_comment);
$store_category = get_user_store_category($merchant_id); //店铺导航栏
$smarty->assign('store_category', $store_category);
//商家二维码 by wu start
$sql="select ss.*,sq.* from ".$ecs->table('seller_shopinfo')." as ss ".
" left join".$ecs->table('seller_qrcode')." as sq on sq.ru_id=ss.ru_id ".
" where ss.ru_id='$merchant_id'";
$basic_info = $db->getRow($sql);
$logo = str_replace('../', '',$basic_info['qrcode_thumb']);
$size = '155x155';
$url = $ecs->url();
//$data = $url."qrurl.php?type=seller&id=".$merchant_id;
$data = $url."mobile/index.php?r=store/index/shop_info&id=".$merchant_id;
$errorCorrectionLevel = 'Q'; // 纠错级别：L、M、Q、H
$matrixPointSize = 4; // 点的大小：1到10
$filename = "seller_imgs/seller_qrcode/seller_qrcode_" . $merchant_id . ".png";
QRcode::png($data, $filename, $errorCorrectionLevel, $matrixPointSize);
$QR = imagecreatefrompng($filename);
if($logo !== FALSE)
{
$logo = imagecreatefromstring(file_get_contents($logo));
$QR_width = imagesx($QR);
$QR_height = imagesy($QR);
$logo_width = imagesx($logo);
$logo_height = imagesy($logo);
// Scale logo to fit in the QR Code
$logo_qr_width = $QR_width/5;
$scale = $logo_width/$logo_qr_width;
$logo_qr_height = $logo_height/$scale;
$from_width = ($QR_width-$logo_qr_width)/2;
//echo $from_width;exit;
imagecopyresampled($QR, $logo, $from_width, $from_width, 0, 0, $logo_qr_width, $logo_qr_height, $logo_width, $logo_height);
}
imagepng($QR, $filename);
imagedestroy($QR);
$smarty->assign('seller_qrcode_img', $filename);
$smarty->assign('seller_qrcode_text', $basic_info['shop_name']);
//商家二维码 by wu end
$basic_info['shop_logo'] = str_replace('../', '', $basic_info['shop_logo']);
$smarty->assign('basic_info', $basic_info); //店铺详细信息
$sql = "select parent_id from " .$ecs->table('category'). " where cat_id = '$cat_id'";
$parent_id = $db->getOne($sql);
if($parent_id == 0){
$cat_id = 0;
}
$banner_list = get_store_banner_list($merchant_id, $store_info['seller_theme']); //店铺首页轮播图
$smarty->assign('banner_list', $banner_list);
$win_list = get_store_win_list($merchant_id, $region_id, $area_info['region_id'], $store_info['seller_theme']); //店铺橱窗
$smarty->assign('win_list', $win_list);
$nav_cat_info = cat_list(0, 0, false, 0, true, '', 0, $merchant_id);
$nav_cat= goods_admin_store_cat_list($nav_cat_info);
$smarty->assign('nav_cat', $nav_cat);
$suspension_two = get_template_js(array('suspension-two'));
$smarty->assign('suspension_two', $suspension_two);
$smarty->display($dwt, $cache_id, $not);
/*------------------------------------------------------ */
//-- PRIVATE FUNCTION
/*------------------------------------------------------ */
/**
* 获得分类下的商品
*
* @access public
* @param string $children
* @return array
*/
function store_get_goods($children, $brand, $min, $max, $ext, $size, $page, $sort, $order, $merchant_id, $warehouse_id = 0, $area_id = 0, $keyword)
{
//ecmoban模板堂 --zhuo start
if($children == ''){
$cat_where = " AND g.user_id = '$merchant_id' ";
}else{
$cat_where = " AND ($children OR " . get_extension_goods($children) . ") ";
}
$display = $GLOBALS['display'];
$where = "g.is_on_sale = 1 AND g.is_alone_sale = 1 AND ".
"g.is_delete = 0 $cat_where" ;
if ($brand > 0)
{
$where .= "AND g.brand_id=$brand ";
}
//ecmoban模板堂 --zhuo start
$shop_price = "wg.warehouse_price, wg.warehouse_promote_price, wag.region_price, wag.region_promote_price, g.model_price, g.model_attr, ";
$leftJoin .= " left join " .$GLOBALS['ecs']->table('warehouse_goods'). " as wg on g.goods_id = wg.goods_id and wg.region_id = '$warehouse_id' ";
$leftJoin .= " left join " .$GLOBALS['ecs']->table('warehouse_area_goods'). " as wag on g.goods_id = wag.goods_id and wag.region_id = '$area_id' ";
//ecmoban模板堂 --zhuo end
if ($min > 0)
{
$where .= " AND IF(g.model_price < 1, g.shop_price, IF(g.model_price < 2, wg.warehouse_price, wag.region_price)) >= $min ";
}
if ($max > 0)
{
$where .= " AND IF(g.model_price < 1, g.shop_price, IF(g.model_price < 2, wg.warehouse_price, wag.region_price)) <= $max ";
}
$where .= " AND g.user_id = '$merchant_id'";
if(!empty($keyword)){
$where .= " AND g.goods_name LIKE '%" . mysql_like_quote($keyword) . "%'";
}
if($sort == 'last_update'){
$sort ='g.last_update';
}
//ecmoban模板堂 --zhuo start
if($GLOBALS['_CFG']['review_goods'] == 1){
$where .= ' AND g.review_status > 2 ';
}
//ecmoban模板堂 --zhuo end
/* 获得商品列表 */
$sql = 'SELECT g.goods_id, g.goods_name, ' .$shop_price. ' g.goods_name_style, g.comments_number,g.sales_volume,g.market_price, g.is_new, g.is_best, g.is_hot, ' .
' IF(g.model_price < 1, g.shop_price, IF(g.model_price < 2, wg.warehouse_price, wag.region_price)) AS org_price, ' .
"IFNULL(mp.user_price, IF(g.model_price < 1, g.shop_price, IF(g.model_price < 2, wg.warehouse_price, wag.region_price)) * '$_SESSION[discount]') AS shop_price, g.is_promote, " .
"IF(g.model_price < 1, g.promote_price, IF(g.model_price < 2, wg.warehouse_promote_price, wag.region_promote_price)) as promote_price, g.goods_type, " .
'g.promote_start_date, g.promote_end_date, g.goods_brief, g.goods_thumb , g.goods_img ' .
'FROM ' . $GLOBALS['ecs']->table('goods') . ' AS g ' . $leftJoin .
'LEFT JOIN ' . $GLOBALS['ecs']->table('member_price') . ' AS mp ' .
"ON mp.goods_id = g.goods_id AND mp.user_rank = '$_SESSION[user_rank]' " .
"WHERE $where $ext group by g.goods_id ORDER BY $sort $order";
$res = $GLOBALS['db']->selectLimit($sql, $size, ($page - 1) * $size);
$arr = array();
$idx = 0;
while ($row = $GLOBALS['db']->fetchRow($res))
{
if ($row['promote_price'] > 0)
{
$promote_price = bargain_price($row['promote_price'], $row['promote_start_date'], $row['promote_end_date']);
}
else
{
$promote_price = 0;
}
/* 处理商品水印图片 */
$watermark_img = '';
if ($promote_price != 0)
{
$watermark_img = "watermark_promote_small";
}
elseif ($row['is_new'] != 0)
{
$watermark_img = "watermark_new_small";
}
elseif ($row['is_best'] != 0)
{
$watermark_img = "watermark_best_small";
}
elseif ($row['is_hot'] != 0)
{
$watermark_img = 'watermark_hot_small';
}
if ($watermark_img != '')
{
$arr[$idx]['watermark_img'] = $watermark_img;
}
$arr[$idx]['goods_id'] = $row['goods_id'];
if($display == 'grid')
{
$arr[$idx]['goods_name'] = $GLOBALS['_CFG']['goods_name_length'] > 0 ? sub_str($row['goods_name'], $GLOBALS['_CFG']['goods_name_length']) : $row['goods_name'];
}
else
{
$arr[$idx]['goods_name'] = $row['goods_name'];
}
$arr[$idx]['name'] = $row['goods_name'];
$arr[$idx]['goods_brief'] = $row['goods_brief'];
$arr[$idx]['sales_volume'] = $row['sales_volume'];
$arr[$idx]['comments_number'] = $row['comments_number'];
/* 折扣节省计算 by ecmoban start */
if($row['market_price'] > 0)
{
$discount_arr = get_discount($row['goods_id']); //函数get_discount参数goods_id
}
$arr[$idx]['zhekou'] = $discount_arr['discount']; //zhekou
$arr[$idx]['jiesheng'] = $discount_arr['jiesheng']; //jiesheng
/* 折扣节省计算 by ecmoban end */
$arr[$idx]['goods_style_name'] = add_style($row['goods_name'],$row['goods_name_style']);
$goods_id = $row['goods_id'];
$count = $GLOBALS['db']->getOne("SELECT COUNT(*) FROM " . $GLOBALS['ecs']->table('comment') . " where comment_type=0 and id_value ='$goods_id'");
$arr[$idx]['review_count'] = $count;
$arr[$idx]['market_price'] = price_format($row['market_price']);
$arr[$idx]['shop_price'] = price_format($row['shop_price']);
$arr[$idx]['type'] = $row['goods_type'];
$arr[$idx]['is_promote'] = $row['is_promote'];
$arr[$idx]['promote_price'] = ($promote_price > 0) ? price_format($promote_price) : '';
$arr[$idx]['goods_thumb'] = get_image_path($row['goods_id'], $row['goods_thumb'], true);
$arr[$idx]['goods_img'] = get_image_path($row['goods_id'], $row['goods_img']);
$arr[$idx]['url'] = build_uri('goods', array('gid'=>$row['goods_id']), $row['goods_name']);
$arr[$idx]['count'] = selled_count($row['goods_id']);
$mc_all = ments_count_all($row['goods_id']); //总条数
$mc_one = ments_count_rank_num($row['goods_id'],1); //一颗星
$mc_two = ments_count_rank_num($row['goods_id'],2); //两颗星
$mc_three = ments_count_rank_num($row['goods_id'],3); //三颗星
$mc_four = ments_count_rank_num($row['goods_id'],4); //四颗星
$mc_five = ments_count_rank_num($row['goods_id'],5); //五颗星
$arr[$idx]['zconments'] = get_conments_stars($mc_all,$mc_one,$mc_two,$mc_three,$mc_four,$mc_five);
$idx++;
}
return $arr;
}
/**
* 获得分类下的商品总数
*
* @access public
* @param string $cat_id
* @return integer
*/
function get_store_goods_count($children, $brand = 0, $min = 0, $max = 0, $ext='', $merchant_id, $warehouse_id = 0, $area_id = 0, $keyword)
{
//ecmoban模板堂 --zhuo start
if($children == ''){
$cat_where = " AND g.user_id = '$merchant_id' ";
}else{
$cat_where = " AND ($children OR " . get_extension_goods($children) . ") ";
}
$shop_price = "wg.warehouse_price, wg.warehouse_promote_price, wag.region_price, wag.region_promote_price, g.model_price, g.model_attr, ";
$leftJoin .= " left join " .$GLOBALS['ecs']->table('warehouse_goods'). " as wg on g.goods_id = wg.goods_id and wg.region_id = '$warehouse_id' ";
$leftJoin .= " left join " .$GLOBALS['ecs']->table('warehouse_area_goods'). " as wag on g.goods_id = wag.goods_id and wag.region_id = '$area_id' ";
//ecmoban模板堂 --zhuo end
$where = "g.is_on_sale = 1 AND g.is_alone_sale = 1 AND g.is_delete = 0 $cat_where";
if ($brand > 0)
{
$where .= " AND g.brand_id = $brand ";
}
if ($min > 0)
{
$where .= " AND IF(g.model_price < 1, g.shop_price, IF(g.model_price < 2, wg.warehouse_price, wag.region_price)) >= $min ";
}
if ($max > 0)
{
$where .= " AND IF(g.model_price < 1, g.shop_price, IF(g.model_price < 2, wg.warehouse_price, wag.region_price)) <= $max ";
}
$where .= " AND g.user_id = '$merchant_id'";
if(!empty($keyword)){
$where .= " AND g.goods_name LIKE '%" . mysql_like_quote($keyword) . "%'";
}
//ecmoban模板堂 --zhuo start
if($GLOBALS['_CFG']['review_goods'] == 1){
$where .= ' AND g.review_status > 2 ';
}
//ecmoban模板堂 --zhuo end
/* 返回商品总数 */
return $GLOBALS['db']->getOne('SELECT COUNT(*) FROM ' . $GLOBALS['ecs']->table('goods') . " AS g " .$leftJoin. " WHERE $where $ext");
}
//热门商品
function get_hot_new_best_goods($type = '', $merchant_id, $warehouse_id = 0, $area_id = 0){
$arr = array();
$where = '';
if(!empty($type)){
//ecmoban模板堂 --zhuo start
$shop_price = "wg.warehouse_price, wg.warehouse_promote_price, wag.region_price, wag.region_promote_price, g.model_price, g.model_attr, ";
$leftJoin .= " left join " .$GLOBALS['ecs']->table('warehouse_goods'). " as wg on g.goods_id = wg.goods_id and wg.region_id = '$warehouse_id' ";
$leftJoin .= " left join " .$GLOBALS['ecs']->table('warehouse_area_goods'). " as wag on g.goods_id = wag.goods_id and wag.region_id = '$area_id' ";
if($GLOBALS['_CFG']['review_goods'] == 1){
$where .= ' AND g.review_status > 2 ';
}
//ecmoban模板堂 --zhuo end
$sql = "select g.*, " . $shop_price .
"IFNULL(mp.user_price, IF(g.model_price < 1, g.shop_price, IF(g.model_price < 2, wg.warehouse_price, wag.region_price)) * '$_SESSION[discount]') AS shop_price, " .
"IF(g.model_price < 1, g.promote_price, IF(g.model_price < 2, wg.warehouse_promote_price, wag.region_promote_price)) as promote_price " .
" from " .$GLOBALS['ecs']->table('goods'). " as g".
$leftJoin .
'LEFT JOIN ' . $GLOBALS['ecs']->table('member_price') . ' AS mp ' .
"ON mp.goods_id = g.goods_id AND mp.user_rank = '$_SESSION[user_rank]' " .
" where $type and g.user_id = '$merchant_id' " .$where. " order by g.last_update desc";
$res = $GLOBALS['db']->getAll($sql);
foreach($res as $key=>$row){
$arr[$key] = $row;
if ($row['promote_price'] > 0)
{
$promote_price = bargain_price($row['promote_price'], $row['promote_start_date'], $row['promote_end_date']);
}
else
{
$promote_price = 0;
}
/* 处理商品水印图片 */
$watermark_img = '';
if ($promote_price != 0)
{
$watermark_img = "watermark_promote_small";
}
elseif ($row['is_new'] != 0)
{
$watermark_img = "watermark_new_small";
}
elseif ($row['is_best'] != 0)
{
$watermark_img = "watermark_best_small";
}
elseif ($row['is_hot'] != 0)
{
$watermark_img = 'watermark_hot_small';
}
if ($watermark_img != '')
{
$arr[$key]['watermark_img'] = $watermark_img;
}
$arr[$key]['goods_id'] = $row['goods_id'];
if($display == 'grid')
{
$arr[$key]['goods_name'] = $GLOBALS['_CFG']['goods_name_length'] > 0 ? sub_str($row['goods_name'], $GLOBALS['_CFG']['goods_name_length']) : $row['goods_name'];
}
else
{
$arr[$key]['goods_name'] = $row['goods_name'];
}
$arr[$key]['name'] = $row['goods_name'];
$arr[$key]['goods_brief'] = $row['goods_brief'];
$arr[$key]['sales_volume'] = $row['sales_volume'];
$arr[$key]['comments_number'] = $row['comments_number'];
/* 折扣节省计算 by ecmoban start */
if($row['market_price'] > 0)
{
$discount_arr = get_discount($row['goods_id']); //函数get_discount参数goods_id
}
$arr[$key]['zhekou'] = $discount_arr['discount']; //zhekou
$arr[$key]['jiesheng'] = $discount_arr['jiesheng']; //jiesheng
/* 折扣节省计算 by ecmoban end */
$arr[$key]['goods_style_name'] = add_style($row['goods_name'],$row['goods_name_style']);
$goods_id = $row['goods_id'];
$count = $GLOBALS['db']->getOne("SELECT COUNT(*) FROM " . $GLOBALS['ecs']->table('comment') . " where comment_type=0 and id_value ='$goods_id'");
$arr[$key]['review_count'] = $count;
$arr[$key]['market_price'] = price_format($row['market_price']);
$arr[$key]['shop_price'] = price_format($row['shop_price']);
$arr[$key]['type'] = $row['goods_type'];
$arr[$key]['is_promote'] = $row['is_promote'];
$arr[$key]['promote_price'] = ($promote_price > 0) ? price_format($promote_price) : '';
$arr[$key]['goods_thumb'] = get_image_path($row['goods_id'], $row['goods_thumb'], true);
$arr[$key]['goods_img'] = get_image_path($row['goods_id'], $row['goods_img']);
$arr[$key]['url'] = build_uri('goods', array('gid'=>$row['goods_id']), $row['goods_name']);
$arr[$key]['count'] = selled_count($row['goods_id']);
$mc_one = ments_count_rank_num($goods_id,1); //一颗星
$mc_two = ments_count_rank_num($goods_id,2); //两颗星
$mc_three = ments_count_rank_num($goods_id,3); //三颗星
$mc_four = ments_count_rank_num($goods_id,4); //四颗星
$mc_five = ments_count_rank_num($goods_id,5); //五颗星
$arr[$key]['zconments'] = get_conments_stars($mc_all,$mc_one,$mc_two,$mc_three,$mc_four,$mc_five);
}
}
return $arr;
}
//category父级分类ID parent_id
function category_store_parent($cat_id){
$sql = "select parent_id from " .$GLOBALS['ecs']->table('category'). " where cat_id = '$cat_id'";
return $GLOBALS['db']->getOne($sql);
}
//查询店铺基本信息以及店铺信息是否存在
function get_merchants_store_info($merchant_id, $type = 0){
if($type == 0){
$select = "count(*)";
}elseif($type == 1){
$select = "seller_theme, shop_keyword, notice";
}
$sql = "select " .$select. " from " .$GLOBALS['ecs']->table('seller_shopinfo'). " where ru_id = '$merchant_id'";
if($type == 0){
$res = $GLOBALS['db']->getOne($sql);
}elseif($type == 1){
$res = $GLOBALS['db']->getRow($sql);
}
return $res;
}
?>