<?php

define('IN_ECS', true);

require(dirname(__FILE__) . '/includes/init.php');

if ((DEBUG_MODE & 2) != 2)

{

$smarty->caching = true;

}

/*------------------------------------------------------ */

//-- INPUT

/*------------------------------------------------------ */

/* 获得请求的分类 ID */

if (isset($_REQUEST['id']))

{

$cat_id = intval($_REQUEST['id']);

}

elseif (isset($_REQUEST['category']))

{

$cat_id = intval($_REQUEST['category']);

}

else

{

/* 如果分类ID为0，则返回首页 */

ecs_header("Location: ./\n");

exit;

}

/* 初始化分页信息 */

$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']) ? trim($_REQUEST['filter_attr']) : '0';

$filter_attr = empty($filter_attr_str) ? '' : explode('.', trim($filter_attr_str));

/* 排序、显示方式以及类型 */

$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'))) ? 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']) && in_array(trim(strtolower($_REQUEST['display'])), array('list', 'grid', 'text'))) ? trim($_REQUEST['display']) : (isset($_COOKIE['ECS']['display']) ? $_COOKIE['ECS']['display'] : $default_display_type);

setcookie('ECS[display]', $display, gmtime() + 86400 * 7);

/*------------------------------------------------------ */

//-- 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));

/*zhong改上*/

$sql = "SELECT parent_id,cat_name FROM ".$GLOBALS['ecs']->table('category') . "WHERE cat_id = '$cat_id'";

$row = $GLOBALS['db']->getRow($sql);

$parent_id = $row['parent_id'];

if($brand!=0)

{

$parent_id=1;

}

if($parent_id)

{

/*zhong改下*/

if (!$smarty->is_cached('category.dwt', $cache_id))

{

/* 如果页面没有被缓存则重新获取页面的内容 */

$children = get_children($cat_id);

$cat = get_cat_info($cat_id); // 获得分类的相关信息

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 brand_name FROM " .$GLOBALS['ecs']->table('brand'). " WHERE brand_id = '$brand'";

$brand_name = $db->getOne($sql);

}

else

{

$brand_name = '';

}

/* 获取价格分级 */

if ($cat['grade'] == 0 && $cat['parent_id'] != 0)

{

$cat['grade'] = get_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、

当价格=最大值时，分级会多出来，已被证明存在

*/

$sql = "SELECT min(g.shop_price) AS min, max(g.shop_price) as max ".

" FROM " . $ecs->table('goods'). " AS g ".

" WHERE ($children OR " . get_extension_goods($children) . ') AND 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((g.shop_price - $row[min]) / $dx)) AS sn, COUNT(*) AS goods_num ".

" FROM " . $ecs->table('goods') . " AS g ".

" WHERE ($children OR " . get_extension_goods($children) . ') AND 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('category', array('cid'=>$cat_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('category', array('cid'=>$cat_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 b.brand_id, b.brand_name, COUNT(*) AS goods_num ".

"FROM " . $GLOBALS['ecs']->table('brand') . "AS b, ".

$GLOBALS['ecs']->table('goods') . " AS g LEFT JOIN ". $GLOBALS['ecs']->table('goods_cat') . " AS gc ON g.goods_id = gc.goods_id " .

"WHERE g.brand_id = b.brand_id AND ($children OR " . 'gc.cat_id ' . db_create_in(array_unique(array_merge(array($cat_id), array_keys(cat_list($cat_id, 0, false))))) . ") AND b.is_show = 1 " .

" AND g.is_on_sale = 1 AND g.is_alone_sale = 1 AND g.is_delete = 0 ".

"GROUP BY b.brand_id HAVING goods_num > 0 ORDER BY b.sort_order, b.brand_id ASC";

$brands = $GLOBALS['db']->getAll($sql);

foreach ($brands AS $key => $val)

{

$temp_key = $key + 1;

$brands[$temp_key]['brand_name'] = $val['brand_name'];

$brands[$temp_key]['url'] = build_uri('category', array('cid' => $cat_id, 'bid' => $val['brand_id'], 'price_min'=>$price_min, 'price_max'=> $price_max, 'filter_attr'=>$filter_attr_str), $cat['cat_name']);

/* 判断品牌是否被选中 */

if ($brand == $brands[$key]['brand_id'])

{

$brands[$temp_key]['selected'] = 1;

}

else

{

$brands[$temp_key]['selected'] = 0;

}

}

$brands[0]['brand_name'] = $_LANG['all_attribute'];

$brands[0]['url'] = build_uri('category', array('cid' => $cat_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 ($children OR " . get_extension_goods($children) . ") AND 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 ($children OR " . get_extension_goods($children) . ') AND 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('category', array('cid'=>$cat_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('category', array('cid'=>$cat_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) // 查出符合所有筛选属性条件的商品id */

{

if (is_numeric($v) && $v !=0 ) // zhong改 */

{

$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');

}

}

}

}

assign_template('c', array($cat_id));

$position = assign_ur_here($cat_id, $brand_name);

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

$smarty->assign('ur_here', $position['ur_here']); // 当前位置

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

$smarty->assign('categories2', get_categories_tree()); // 分类树

$smarty->assign('helps', get_shop_help()); // 网店帮助

$smarty->assign('top_goods', get_top10()); // 销售排行

$smarty->assign('show_marketprice', $_CFG['show_marketprice']);

$smarty->assign('category', $cat_id);

$smarty->assign('brand_id', $brand);

$smarty->assign('price_max', $price_max);

$smarty->assign('price_min', $price_min);

$smarty->assign('filter_attr', $filter_attr_str);

$smarty->assign('feed_url', ($_CFG['rewrite'] == 1) ? "feed-c$cat_id.xml" : 'feed.php?cat=' . $cat_id); // RSS URL

if ($brand > 0)

{

$arr['all'] = array('brand_id' => 0,

'brand_name' => $GLOBALS['_LANG']['all_goods'],

'brand_logo' => '',

'goods_num' => '',

'url' => build_uri('category', array('cid'=>$cat_id), $cat['cat_name'])

);

}

else

{

$arr = array();

}

$brand_list = array_merge($arr, get_brands($cat_id, 'category'));

$smarty->assign('data_dir', DATA_DIR);

$smarty->assign('brand_list', $brand_list);

$smarty->assign('promotion_info', get_promotion_info());

/* 调查 */

$vote = get_vote();

if (!empty($vote))

{

$smarty->assign('vote_id', $vote['id']);

$smarty->assign('vote', $vote['content']);

}

$smarty->assign('best_goods', get_category_recommend_goods('best', $children, $brand, $price_min, $price_max, $ext));

$smarty->assign('promotion_goods', get_category_recommend_goods('promote', $children, $brand, $price_min, $price_max, $ext));

$smarty->assign('hot_goods', get_category_recommend_goods('hot', $children, $brand, $price_min, $price_max, $ext));

$count = get_cagtegory_goods_count($children, $brand, $price_min, $price_max, $ext);

$max_page = ($count> 0) ? ceil($count / $size) : 1;

if ($page > $max_page)

{

$page = $max_page;

}

$goodslist = category_get_goods($children, $brand, $price_min, $price_max, $ext, $size, $page, $sort, $order);

if($display == 'grid')

{

if(count($goodslist) % 2 != 0)

{

$goodslist[] = array();

}

}

$smarty->assign('goods_list', $goodslist);

$smarty->assign('category', $cat_id);

$smarty->assign('script_name', 'category');

assign_pager('category', $cat_id, $count, $size, $sort, $order, $page, '', $brand, $price_min, $price_max, $display, $filter_attr_str); // 分页

assign_dynamic('category'); // 动态内容

}

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

/* zhong改上 */

}

else

{

$sql = "SELECT cat_id FROM ".$GLOBALS['ecs']->table('category') . "WHERE parent_id = '$cat_id'";

$child = $GLOBALS['db']->getOne($sql);

$sql = "SELECT ac.cat_id,ac.cat_name FROM ".$GLOBALS['ecs']->table('article_cat') ." AS ac " .

'LEFT JOIN ' . $GLOBALS['ecs']->table('article_cat') . ' AS a ' .

" ON a.cat_id = ac.cat_id " .

" WHERE ac.cat_name='".$row['cat_name']."'";

$arr=$GLOBALS['db']->getRow($sql);

$children = get_children($cat_id);

$smarty->assign('cat_article_name', $arr['cat_name']); // 页面标题

if($arr['cat_id'])

{

$smarty->assign('cat_article', get_cat_articles($arr['cat_id'])); // 页面标题

}

$smarty->assign('promotion_goods', get_promote_goods($cat_id));

$cat = get_cat_info($cat_id); // 获得分类的相关信息

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;

}

assign_template('c', array($cat_id));

$position = assign_ur_here($cat_id, $brand_name);

$smarty->assign('cat_name', $row['cat_name']); // 页面标题

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

$smarty->assign('ur_here', $position['ur_here']); // 当前位置

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

$smarty->assign('helps', get_shop_help()); // 网店帮助

$smarty->assign('show_marketprice', $_CFG['show_marketprice']);

$smarty->assign('category', $cat_id);

$smarty->assign('brand_id', $brand);

$smarty->assign('new_articles', index_get_new_articles()); // 最新文章

$smarty->assign('feed_url', ($_CFG['rewrite'] == 1) ? "feed-c$cat_id.xml" : 'feed.php?cat=' . $cat_id); // RSS URL

if ($brand > 0)

{

$arr['all'] = array('brand_id' => 0,

'brand_name' => $GLOBALS['_LANG']['all_goods'],

'brand_logo' => '',

'goods_num' => '',

'url' => build_uri('category', array('cid'=>$cat_id))

);

}

else

{

$arr = array();

}

$brand_list = array_merge($arr, get_brands($cat_id, 'category'));

$smarty->assign('data_dir', DATA_DIR);

$smarty->assign('brand_list', $brand_list);

$smarty->assign('promotion_info', get_promotion_info());

/* 调查 */

$vote = get_vote();

if (!empty($vote))

{

$smarty->assign('vote_id', $vote['id']);

$smarty->assign('vote', $vote['content']);

}

$smarty->assign('best_goods', get_category_recommend_goods('best', $children, $brand, $price_min, $price_max, $ext));

$smarty->assign('promotion_goods', get_promote_goods($cat_id,3));

$smarty->assign('hot_goods', get_category_recommend_goods('hot', $children, $brand, $price_min, $price_max, $ext,6));

$sql = "SELECT cat_id,cat_name FROM ".$GLOBALS['ecs']->table('category') . "WHERE parent_id = '$cat_id' AND is_show_cate = 1 ORDER BY sort_order";

$res = $GLOBALS['db']->getAll($sql);

foreach($res AS $v)

{

$str[$v['cat_id']]['goods']=assign_cat_goods($v['cat_id'], $num = 10,'cate');

$mysql = "SELECT cat_id,cat_name FROM ".$GLOBALS['ecs']->table('category') . "WHERE parent_id = '".$v['cat_id']."' AND is_show_cate = 1";

$result = $GLOBALS['db']->getAll($mysql);

$cat_arr = array();

if($result)

{

foreach($result AS $key => $val)

{

$cat_arr[$key]['url'] = build_uri('category', array('cid' => $val['cat_id']), $val['cat_name']);

$cat_arr[$key]['cat_name'] = $val['cat_name'];

}

$str[$v['cat_id']]['category']=$cat_arr;//子分类

}

else

{

$str[$v['cat_id']]['category']='';

}

$str[$v['cat_id']]['top'] = get_top10($v['cat_id'],5);//分类排行

$str[$v['cat_id']]['name']= $v['cat_name'];//分类名

$str[$v['cat_id']]['cat_id']= $v['cat_id'];//分类id

$str[$v['cat_id']]['url']= build_uri('category', array('cid' => $v['cat_id']), $v['cat_name']);//分类id

}

$smarty->assign('cate_goods',$str);

$smarty->display('category_top.dwt');

}

/* zhong改下 */

/*------------------------------------------------------ */

//-- PRIVATE FUNCTION

/*------------------------------------------------------ */

/**

* 获得分类的信息

*

* @param integer $cat_id

*

* @return void

*/

function get_cat_info($cat_id)

}

/**

* 获得分类下的商品

*

* @access public

* @param string $children

* @return array

*/

function category_get_goods($children, $brand, $min, $max, $ext, $size, $page, $sort, $order)

}

/**

* 获得分类下的商品总数

*

* @access public

* @param string $cat_id

* @return integer

*/

function get_cagtegory_goods_count($children, $brand = 0, $min = 0, $max = 0, $ext='')

}

/**

* 获得最新的文章列表。

*

* @access private

* @return array

*/

function index_get_new_articles()

}

/**

* 取得最近的上级分类的grade值

*

* @access public

* @param int $cat_id //当前的cat_id

*

* @return int

*/

function get_parent_grade($cat_id)

}

?>