2 Star 0 Fork 0

kent45/baixin

加入 Gitee
与超过 1200万 开发者一起发现、参与优秀开源项目,私有仓库也完全免费 :)
免费加入
文件
该仓库未声明开源许可证文件(LICENSE),使用请关注具体项目描述及其代码上游依赖。
克隆/下载
compare.php 5.09 KB
一键复制 编辑 原始数据 按行查看 历史
kent45 提交于 2014-07-21 15:29 . 1.first push
<?php
/**
* ECSHOP 商品比较程序
* ============================================================================
* * 版权所有 2005-2012 上海商派网络科技有限公司,并保留所有权利。
* 网站地址: http://www.ecshop.com;
* ----------------------------------------------------------------------------
* 这不是一个自由软件!您只能在不用于商业目的的前提下对程序代码进行修改和
* 使用;不允许对程序代码以任何形式任何目的的再发布。
* ============================================================================
* $Author: liubo $
* $Id: compare.php 17217 2011-01-19 06:29:08Z liubo $
*/
define('IN_ECS', true);
require(dirname(__FILE__) . '/includes/init.php');
if (!empty($_REQUEST['goods']) && is_array($_REQUEST['goods']) && count($_REQUEST['goods']) > 1)
{
$where = db_create_in($_REQUEST['goods'], 'id_value');
$sql = "SELECT id_value , AVG(comment_rank) AS cmt_rank, COUNT(*) AS cmt_count" .
" FROM " .$ecs->table('comment') .
" WHERE $where AND comment_type = 0".
' GROUP BY id_value ';
$query = $db->query($sql);
$cmt = array();
while ($row = $db->fetch_array($query))
{
$cmt[$row['id_value']] = $row;
}
$where = db_create_in($_REQUEST['goods'], 'g.goods_id');
$sql = "SELECT g.goods_id, g.goods_type, g.goods_name, g.shop_price, g.goods_weight, g.goods_thumb, g.goods_brief, ".
"a.attr_name, v.attr_value, a.attr_id, b.brand_name, ".
"IFNULL(mp.user_price, g.shop_price * '$_SESSION[discount]') AS rank_price " .
"FROM " .$ecs->table('goods'). " AS g ".
"LEFT JOIN " . $ecs->table('goods_attr'). " AS v ON v.goods_id = g.goods_id ".
"LEFT JOIN " . $ecs->table('attribute') . " AS a ON a.attr_id = v.attr_id " .
"LEFT JOIN " . $ecs->table('brand') . " AS b ON g.brand_id = b.brand_id " .
"LEFT JOIN " . $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 $where ".
"ORDER BY a.attr_id";
$res = $db->query($sql);
$arr = array();
$ids = $_REQUEST['goods'];
$attr_name = array();
$type_id = 0;
while ($row = $db->fetchRow($res))
{
$goods_id = $row['goods_id'];
$type_id = $row['goods_type'];
$arr[$goods_id]['goods_id'] = $goods_id;
$arr[$goods_id]['url'] = build_uri('goods', array('gid' => $goods_id), $row['goods_name']);
$arr[$goods_id]['goods_name'] = $row['goods_name'];
$arr[$goods_id]['shop_price'] = price_format($row['shop_price']);
$arr[$goods_id]['rank_price'] = price_format($row['rank_price']);
$arr[$goods_id]['goods_weight'] = (intval($row['goods_weight']) > 0) ?
ceil($row['goods_weight']) . $_LANG['kilogram'] : ceil($row['goods_weight'] * 1000) . $_LANG['gram'];
$arr[$goods_id]['goods_thumb'] = get_image_path($row['goods_id'], $row['goods_thumb'], true);
$arr[$goods_id]['goods_brief'] = $row['goods_brief'];
$arr[$goods_id]['brand_name'] = $row['brand_name'];
$arr[$goods_id]['properties'][$row['attr_id']]['name'] = $row['attr_name'];
if (!empty($arr[$goods_id]['properties'][$row['attr_id']]['value']))
{
$arr[$goods_id]['properties'][$row['attr_id']]['value'] .= ',' . $row['attr_value'];
}
else
{
$arr[$goods_id]['properties'][$row['attr_id']]['value'] = $row['attr_value'];
}
if (!isset($arr[$goods_id]['comment_rank']))
{
$arr[$goods_id]['comment_rank'] = isset($cmt[$goods_id]) ? ceil($cmt[$goods_id]['cmt_rank']) : 0;
$arr[$goods_id]['comment_number'] = isset($cmt[$goods_id]) ? $cmt[$goods_id]['cmt_count'] : 0;
$arr[$goods_id]['comment_number'] = sprintf($_LANG['comment_num'], $arr[$goods_id]['comment_number']);
}
$tmp = $ids;
$key = array_search($goods_id, $tmp);
if ($key !== null && $key !== false)
{
unset($tmp[$key]);
}
$arr[$goods_id]['ids'] = !empty($tmp) ? "goods[]=" . implode('&amp;goods[]=', $tmp) : '';
}
$sql = "SELECT attr_id,attr_name FROM " . $ecs->table('attribute') . " WHERE cat_id='$type_id' ORDER BY attr_id";
$attribute = array();
$query = $db->query($sql);
while ($rt = $db->fetch_array($query))
{
$attribute[$rt['attr_id']] = $rt['attr_name'];
}
$smarty->assign('attribute', $attribute);
$smarty->assign('goods_list', $arr);
}
else
{
show_message($_LANG['compare_no_goods']);
exit;
}
assign_template();
$position = assign_ur_here(0, $_LANG['goods_compare']);
$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()); // 网店帮助
assign_dynamic('compare');
$smarty->display('compare.dwt');
?>
马建仓 AI 助手
尝试更多
代码解读
代码找茬
代码优化
PHP
1
https://gitee.com/kent45/baixin.git
git@gitee.com:kent45/baixin.git
kent45
baixin
baixin
master

搜索帮助

0d507c66 1850385 C8b1a773 1850385