master

分支 (1)

管理

管理

master

gameshop
/
supplier_search.php

<?php

/**
 * 店铺分类文件
 * ============================================================================
 * * 版权所有 2005-2012 鸿宇多用户商城科技有限公司，并保留所有权利。
 * 网站地址: http://www.hongyuvip.com；
 * ----------------------------------------------------------------------------
 * 这不是一个自由软件！您只能在不用于商业目的的前提下对程序代码进行修改和
 * 使用；不允许对程序代码以任何形式任何目的的再发布。
 * ============================================================================
 * $Author: liubo $
 * $Id: category.php 17217 2016-01-19 06:29:08Z liubo $
*/


/* 获得请求的分类 ID */
if (isset($_REQUEST['id']))
{
   // $cat_id = intval($_REQUEST['id']);
}
else
{
    /* 如果分类ID为0，则返回首页 */
  //  ecs_header("Location: ./\n");

  //  exit;
}


/* 初始化分页信息 */
$cat_id = isset($_REQUEST['id'])   && intval($_REQUEST['id'])  > 0 ? intval($_REQUEST['id'])  : 0;
$keywords = isset($_REQUEST['keywords']) && !empty($_REQUEST['keywords']) ? htmlspecialchars($_REQUEST['keywords']) : '';
$keywords = ($keywords == '请输入你要查找的商品') ? '' : $keywords;
$price = isset($_REQUEST['price']) ? intval($_REQUEST['price']) : 0;
$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;
$sort  = (isset($_REQUEST['sort'])  && in_array(trim(strtolower($_REQUEST['sort'])), array('goods_id', 'shop_price', 'last_update'))) ? 'g.'.trim($_REQUEST['sort'])  : 'g.goods_id';
$order = (isset($_REQUEST['order']) && in_array(trim(strtoupper($_REQUEST['order'])), array('ASC', 'DESC')))                              ? trim($_REQUEST['order']) : 'DESC';
/*------------------------------------------------------ */
//-- PROCESSOR
/*------------------------------------------------------ */

/* 页面的缓存ID */
$cache_id = sprintf('%X', crc32($cat_id . '-' . $display . '-' . $sort  .'-' . $order  .'-' . $page . '-' . $size . '-' . $_SESSION['user_rank'] . '-' .
    $_CFG['lang'] .'-'. $brand. '-' . $price_max . '-' .$price_min . '-' . $filter_attr_str.'-'.$_GET['suppId']));

if (!$smarty->is_cached('search.dwt', $cache_id))
{
    assign_template();
    assign_template_supplier();
    $position = assign_ur_here();


    $smarty->assign('page_title',      $position['title']);    // 页面标题
    //$smarty->assign('ur_here',         $ur_here);  // 当前位置

    $smarty->assign('categories',      get_categories_tree_supplier()); // 分类树

    $s_value = get_search_price($price);

    $children = get_cattype_supplier($cat_id,$keywords);
    if($children === false){
    	ecs_header("Location: supplier.php?suppId=".$_GET['suppId']);
    	exit;
    }
    $count = get_cagtegory_goods_count($children,$keywords,$s_value);
    $max_page = ($count> 0) ? ceil($count / $size) : 1;
	if ($page > $max_page)
    {
        $page = $max_page;
    }
    $goodslist = category_get_goods($children, $size, $page,$keywords,$s_value,$sort, $order);
    if($display == 'grid')
    {
        if(count($goodslist) % 2 != 0)
        {
            $goodslist[] = array();
        }
    }
    assign_pager('supplier',            $cat_id, $count, $size, $sort, $order, $page, $keywords."&price=".$price, '', '', '', $display, ''); // 分页
    $smarty->assign('goods_list',       $goodslist);
    assign_dynamic('search');
}

$smarty->display('search.dwt', $cache_id);

/*------------------------------------------------------ */
//-- PRIVATE FUNCTION
/*------------------------------------------------------ */

/**
 * 获得指定商品属性所属的分类的ID
 *
 * @access  public
 * @param   integer     $cat        (1=>'精品推荐',2=>'新品上市',3=>'热卖商品')
 * @param	string		$keywords    关键字
 * @return  string
 */
function get_cattype_supplier($cat = 0,$keywords='')
{
	if(empty($keywords)){
		$where = "supplier_id=".$_GET['suppId'];
		if($cat > 0){
			$where .= " AND recommend_type=".$cat;
		}
		$sql = "select cat_id  from ". $GLOBALS['ecs']->table('supplier_cat_recommend') ." where ".$where;
		$res = $GLOBALS['db']->getAll($sql);
		$arr = array();
		if(count($res)>0){
			foreach($res as $k => $v){
				$arr[$v['cat_id']] = $v['cat_id'];
			}
		}
		if(empty($arr)){
			return false;
		}
	    return 'sgc.cat_id ' . db_create_in(array_keys($arr));
	}else{
		return "g.goods_name like '%".$keywords."%'";
	}
}

/**
 * 获得分类下的商品
 *
 * @access  public
 * @param   string  $children
 * @param   array      $price_search 搜索价格区间中的商品
 * @return  array
 */
function category_get_goods($children, $size, $page,$keywords='',$price_search='',$sort, $order)
{
    $display = $GLOBALS['display'];

	$price_str = '';
	if(!empty($price_search)){
		if($price_search['min'] > 0){
			$price_str .= " AND g.shop_price > ".$price_search['min']." ";
		}
		if($price_search['max'] > 0){
			$price_str .= " AND g.shop_price <= ".$price_search['max']." ";
		}
	}

    $where = "g.is_on_sale = 1 AND g.is_alone_sale = 1 AND ".
            "g.is_delete = 0 ".$price_str." AND ($children)";


    /* 获得商品列表 */
    if(empty($keywords)){
    	$where .= " AND sgc.supplier_id=".$_GET['suppId'];
    	$sql = 'SELECT DISTINCT g.goods_id, g.goods_name, g.goods_name_style, 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.goods_type, " .
                'g.promote_start_date, g.promote_end_date, g.goods_brief, g.goods_thumb ,g.original_img , g.goods_img ' .
    		'FROM ' . $GLOBALS['ecs']->table('supplier_goods_cat') . ' AS sgc ' .
            'LEFT JOIN ' . $GLOBALS['ecs']->table('goods') . ' AS g ' .
    			"ON sgc.goods_id = g.goods_id " .
            '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 ORDER BY  $sort $order";
    }else{
    	$where .= " AND g.supplier_id=".$_GET['suppId'];
    	$sql = 'SELECT DISTINCT g.goods_id, g.goods_name, g.goods_name_style, 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.goods_type, " .
                'g.promote_start_date, g.promote_end_date, g.goods_brief, g.goods_thumb ,g.original_img, g.goods_img ' .
    		'FROM ' . $GLOBALS['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 $where ORDER BY  $sort $order";
    }


    $res = $GLOBALS['db']->selectLimit($sql, $size, ($page - 1) * $size);

    $arr = array();
    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[$row['goods_id']]['watermark_img'] =  $watermark_img;
        }

        $arr[$row['goods_id']]['goods_id']         = $row['goods_id'];
        if($display == 'grid')
        {
            $arr[$row['goods_id']]['goods_name']       = $GLOBALS['_CFG']['goods_name_length'] > 0 ? sub_str($row['goods_name'], $GLOBALS['_CFG']['goods_name_length']) : $row['goods_name'];
        }
        else
        {
            $arr[$row['goods_id']]['goods_name']       = $row['goods_name'];
        }
        $arr[$row['goods_id']]['name']             = $row['goods_name'];
        $arr[$row['goods_id']]['goods_brief']      = $row['goods_brief'];
        $arr[$row['goods_id']]['goods_style_name'] = add_style($row['goods_name'],$row['goods_name_style']);
        $arr[$row['goods_id']]['market_price']     = price_format($row['market_price']);
        $arr[$row['goods_id']]['shop_price']       = price_format($row['shop_price']);
        $arr[$row['goods_id']]['type']             = $row['goods_type'];
        $arr[$row['goods_id']]['promote_price']    = ($promote_price > 0) ? price_format($promote_price) : '';
        $arr[$row['goods_id']]['goods_thumb']      = get_image_path($row['goods_id'], $row['goods_thumb'], true);
        $arr[$row['goods_id']]['goods_img']        = get_image_path($row['goods_id'], $row['goods_img']);
		$arr[$row['goods_id']]['original_img']     = get_image_path($row['goods_id'], $row['original_img']);
        $arr[$row['goods_id']]['url']              = build_uri('goods', array('gid'=>$row['goods_id']), $row['goods_name']);
    }

    return $arr;
}

/**
 * 获得分类下的商品总数
 *
 * @access  public
 * @param   string     $children
 * @param   string		$keywords   商品名称查找
 * @param   array      $price_search 搜索价格区间中的商品
 * @return  integer
 */
function get_cagtegory_goods_count($children,$keywords='',$price_search='')
{
   $price_str = '';
	if(!empty($price_search)){
		if($price_search['min'] > 0){
			$price_str .= " AND g.shop_price > ".$price_search['min']." ";
		}
		if($price_search['max'] > 0){
			$price_str .= " AND g.shop_price <= ".$price_search['max']." ";
		}
	}

    /* 返回商品总数 */
    if(empty($keywords)){
    	 $where  = "sgc.supplier_id=".$_GET['suppId']." AND $children";
    	$sql = 'SELECT count(DISTINCT g.goods_id) FROM ' . $GLOBALS['ecs']->table('supplier_goods_cat') . ' AS sgc LEFT JOIN ' . $GLOBALS['ecs']->table('goods') . ' AS g ' .
    			'ON sgc.goods_id = g.goods_id AND g.is_on_sale = 1 AND g.is_alone_sale = 1 AND g.is_delete = 0 '.$price_str.' WHERE '.$where;
    }else{
    	$where  = "g.supplier_id=".$_GET['suppId']." AND $children";
    	$sql = 'SELECT count(DISTINCT g.goods_id) FROM ' . $GLOBALS['ecs']->table('goods') . ' AS g ' .
    			'WHERE g.is_on_sale = 1 AND g.is_alone_sale = 1 AND g.is_delete = 0 '. $price_str .' AND '.$where;
    }
    return $GLOBALS['db']->getOne($sql);
}

/**
 * 获取搜索中用户选择的价格区间
 * @param int  $price  代表价格区间的值
 */
function get_search_price($price=0){
	global $index_price;
	$num = count($index_price);
	$info = explode('-',$index_price[$price]);
	$ret = array('min'=>0,'max'=>0);
	if($price < --$num){
		//搜索中价格第一个条件
		if(count($info) == 1){
			$ret['min'] = intval($info[0]);
			$ret['max'] = 0;
		}else{
			$ret['min'] = intval($info[0]);
			$ret['max'] = intval($info[1]);
		}
	}elseif($price == --$num){
		//搜索中价格最后一个条件
		if(count($info) == 1){
			$ret['min'] = 0;
			$ret['max'] = intval($info[1]);
		}else{
			$ret['min'] = intval($info[0]);
			$ret['max'] = intval($info[1]);
		}
	}else{
		//搜索中价格中间条件
		$ret['min'] = intval($info[0]);
		$ret['max'] = intval($info[1]);
	}
	return $ret;
}

?>