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.
1656 lines
65 KiB
1656 lines
65 KiB
<?php
|
|
|
|
/**
|
|
* ECSHOP 商品详情
|
|
* ============================================================================
|
|
* * 版权所有 2005-2016 上海商创网络科技有限公司，并保留所有权利。
|
|
* 网站地址: http://www.ecmoban.com；
|
|
* ----------------------------------------------------------------------------
|
|
* 这不是一个自由软件！您只能在不用于商业目的的前提下对程序代码进行修改和
|
|
* 使用；不允许对程序代码以任何形式任何目的的再发布。
|
|
* ============================================================================
|
|
* $Author: liubo $
|
|
* $Id: goods.php 17217 2011-01-19 06:29:08Z liubo $
|
|
*/
|
|
|
|
define('IN_ECS', true);
|
|
|
|
require(dirname(__FILE__) . '/includes/init.php');
|
|
require(dirname(__FILE__) . '/includes/phpqrcode/phpqrcode.php'); //by wu
|
|
require(ROOT_PATH . '/includes/lib_area.php'); //ecmoban模板堂 --zhuo
|
|
|
|
if ((DEBUG_MODE & 2) != 2)
|
|
{
|
|
$smarty->caching = true;
|
|
}
|
|
|
|
$affiliate = unserialize($GLOBALS['_CFG']['affiliate']);
|
|
$smarty->assign('affiliate', $affiliate);
|
|
$factor = intval($_CFG['comment_factor']);
|
|
$smarty->assign('factor',$factor);
|
|
/*------------------------------------------------------ */
|
|
//-- INPUT
|
|
/*------------------------------------------------------ */
|
|
|
|
$goods_id = isset($_REQUEST['id']) ? intval($_REQUEST['id']) : 0;
|
|
|
|
$smarty->assign('category', $goods_id);
|
|
|
|
//商品不存在则跳转回首页
|
|
if(empty($_REQUEST['act'])){
|
|
$goods_date = array('goods_name');
|
|
$goods_where = "goods_id = '$goods_id' AND is_delete=0";
|
|
$goods_name = get_table_date('goods', $goods_where, $goods_date);
|
|
if(empty($goods_name)){
|
|
header("Location: index.php\n");
|
|
exit;
|
|
}
|
|
}
|
|
|
|
//ecmoban模板堂 --zhuo start 仓库
|
|
$pid = isset($_REQUEST['pid']) ? intval($_REQUEST['pid']) : 0;
|
|
$user_id = isset($_SESSION['user_id'])? $_SESSION['user_id'] : 0;
|
|
//ecmoban模板堂 --zhuo end 仓库
|
|
|
|
/* 清空配件购物车 */
|
|
if(!empty($_SESSION['user_id'])){
|
|
$sess_id = " user_id = '" . $_SESSION['user_id'] . "' ";
|
|
}else{
|
|
$sess_id = " session_id = '" . real_cart_mac_ip() . "' ";
|
|
}
|
|
|
|
/* 获得商品的信息 */
|
|
$_SESSION['goods_id'] = $goods_id;
|
|
|
|
/*------------------------------------------------------ */
|
|
//-- 改变属性、数量时重新计算商品价格
|
|
/*------------------------------------------------------ */
|
|
|
|
if (!empty($_REQUEST['act']) && $_REQUEST['act'] == 'price')
|
|
{
|
|
include('includes/cls_json.php');
|
|
|
|
$json = new JSON;
|
|
$res = array('err_msg' => '', 'err_no' => 0, 'result' => '', 'qty' => 1);
|
|
|
|
$attr_id = isset($_REQUEST['attr']) ? explode(',', $_REQUEST['attr']) : array();
|
|
$number = (isset($_REQUEST['number'])) ? intval($_REQUEST['number']) : 1;
|
|
$warehouse_id = (isset($_REQUEST['warehouse_id'])) ? intval($_REQUEST['warehouse_id']) : 0;
|
|
$area_id = (isset($_REQUEST['area_id'])) ? intval($_REQUEST['area_id']) : 0; //仓库管理的地区ID
|
|
|
|
$onload = (isset($_REQUEST['onload'])) ? trim($_REQUEST['onload']) : ''; //仓库管理的地区ID
|
|
|
|
$goods = get_goods_info($goods_id, $warehouse_id, $area_id);
|
|
|
|
if ($goods_id == 0)
|
|
{
|
|
$res['err_msg'] = $_LANG['err_change_attr'];
|
|
$res['err_no'] = 1;
|
|
}
|
|
else
|
|
{
|
|
if ($number == 0)
|
|
{
|
|
$res['qty'] = $number = 1;
|
|
}
|
|
else
|
|
{
|
|
$res['qty'] = $number;
|
|
}
|
|
|
|
//ecmoban模板堂 --zhuo start
|
|
$products = get_warehouse_id_attr_number($goods_id, $_REQUEST['attr'], $goods['user_id'], $warehouse_id, $area_id);
|
|
$attr_number = $products['product_number'];
|
|
|
|
if($goods['model_attr'] == 1){
|
|
$table_products = "products_warehouse";
|
|
$type_files = " and warehouse_id = '$warehouse_id'";
|
|
}elseif($goods['model_attr'] == 2){
|
|
$table_products = "products_area";
|
|
$type_files = " and area_id = '$area_id'";
|
|
}else{
|
|
$table_products = "products";
|
|
$type_files = "";
|
|
}
|
|
|
|
$sql = "SELECT * FROM " .$GLOBALS['ecs']->table($table_products). " WHERE goods_id = '$goods_id'" .$type_files. " LIMIT 0, 1";
|
|
$prod = $GLOBALS['db']->getRow($sql);
|
|
|
|
if(empty($prod)){ //当商品没有属性库存时
|
|
$attr_number = $goods['goods_number'];
|
|
}
|
|
|
|
$attr_number = !empty($attr_number) ? $attr_number : 0;
|
|
|
|
$res['attr_number'] = $attr_number;
|
|
$shop_price = get_final_price($goods_id, $number, true, $attr_id, $warehouse_id, $area_id);
|
|
//ecmoban模板堂 --zhuo end
|
|
|
|
$res['shop_price'] = price_format($shop_price);
|
|
$res['market_price'] = $goods['market_price'];
|
|
|
|
//属性价格
|
|
$spec_price = get_final_price($goods_id, $number, true, $attr_id, $warehouse_id, $area_id, 1);
|
|
$res['marketPrice_amount'] = price_format($spec_price + $goods['marketPrice']);
|
|
|
|
$res['result'] = price_format($shop_price * $number);
|
|
}
|
|
|
|
$goods_fittings = get_goods_fittings_info($goods_id, $warehouse_id, $area_id, '', 1);
|
|
$fittings_list = get_goods_fittings(array($goods_id), $warehouse_id, $area_id);
|
|
|
|
if($fittings_list){
|
|
if(is_array($fittings_list)){
|
|
foreach($fittings_list as $vo){
|
|
$fittings_index[$vo['group_id']] = $vo['group_id'];//关联数组
|
|
}
|
|
}
|
|
ksort($fittings_index);//重新排序
|
|
|
|
$merge_fittings = get_merge_fittings_array($fittings_index, $fittings_list); //配件商品重新分组
|
|
$fitts = get_fittings_array_list($merge_fittings, $goods_fittings);
|
|
|
|
for($i=0; $i<count($fitts); $i++){
|
|
$fittings_interval = $fitts[$i]['fittings_interval'];
|
|
|
|
$res['fittings_interval'][$i]['fittings_minMax'] = price_format($fittings_interval['fittings_min']) ."-". number_format($fittings_interval['fittings_max'], 2, '.', '');
|
|
$res['fittings_interval'][$i]['market_minMax'] = price_format($fittings_interval['market_min']) ."-". number_format($fittings_interval['market_max'], 2, '.', '');
|
|
|
|
if($fittings_interval['save_minPrice'] == $fittings_interval['save_maxPrice']){
|
|
$res['fittings_interval'][$i]['save_minMaxPrice'] = price_format($fittings_interval['save_minPrice']);
|
|
}else{
|
|
$res['fittings_interval'][$i]['save_minMaxPrice'] = price_format($fittings_interval['save_minPrice']) ."-". number_format($fittings_interval['save_maxPrice'], 2, '.', '');
|
|
}
|
|
|
|
$res['fittings_interval'][$i]['groupId'] = $fittings_interval['groupId'];
|
|
}
|
|
}
|
|
|
|
|
|
if($GLOBALS['_CFG']['open_area_goods'] == 1){
|
|
|
|
$area_list = get_goods_link_area_list($goods_id, $goods['user_id']);
|
|
if($area_list['goods_area']){
|
|
if(!in_array($area_id, $area_list['goods_area'])){
|
|
$res['err_no'] = 2;
|
|
}
|
|
} else {
|
|
$res['err_no'] = 2;
|
|
}
|
|
}
|
|
|
|
die($json->encode($res));
|
|
}
|
|
|
|
/*------------------------------------------------------ */
|
|
//-- 评论有用+1
|
|
/*------------------------------------------------------ */
|
|
elseif($_REQUEST['act'] == 'add_useful')
|
|
{
|
|
require_once (dirname(__FILE__) . '/includes/cls_json.php');
|
|
$json = new JSON();
|
|
|
|
$res = array('err_msg' => '', 'content' => '', 'err_no' => 0);
|
|
|
|
$id = empty($_REQUEST['id']) ? 0 : intval($_REQUEST['id']);
|
|
$type = empty($_REQUEST['type']) ? 'comment' : $_REQUEST['type'];
|
|
$goods_id = empty($_REQUEST['goods_id']) ? 0 : intval($_REQUEST['goods_id']);
|
|
$ip = real_ip();
|
|
if(!empty($id))
|
|
{
|
|
if(!isset($_SESSION['user_id']) || $_SESSION['user_id'] == 0){
|
|
$res['url'] = get_return_goods_url($goods_id);
|
|
$res['err_no'] = 1;
|
|
}else{
|
|
|
|
$useful_user = '';
|
|
$sql = 'SELECT useful_user, useful FROM '.$ecs->table('comment')." WHERE comment_id='$id'";
|
|
$comment = $db->getRow($sql);
|
|
|
|
if($comment['useful_user']){
|
|
$useful_user = explode(',', $comment['useful_user']);
|
|
if(in_array($_SESSION['user_id'], $useful_user)){
|
|
$res['err_no'] = 2;
|
|
die($json->encode($res));
|
|
}else{
|
|
array_push($useful_user, $_SESSION['user_id']);
|
|
$useful_user = implode(',', $useful_user);
|
|
}
|
|
}else{
|
|
$useful_user = array(0);
|
|
array_push($useful_user, $_SESSION['user_id']);
|
|
$useful_user = implode(',', $useful_user);
|
|
}
|
|
|
|
$sql = 'SELECT COUNT(*) FROM '.$ecs->table('comment')." WHERE comment_id='$id'";
|
|
$count = $db->getOne($sql);
|
|
|
|
if($count == 1)
|
|
{
|
|
$sql = "UPDATE " . $ecs->table('comment') . " SET useful = useful + 1, useful_user = '$useful_user' WHERE comment_id='$id'";
|
|
if($db->query($sql))
|
|
{
|
|
$res = array('option' => 'true', 'id' => $id, 'type' => $type, 'useful' => $comment['useful'] + 1, 'err_no' => 0);
|
|
}
|
|
else
|
|
{
|
|
$res = array('error' => '', 'id' => $id, 'type' => $type, 'err_no' => 2);
|
|
}
|
|
}
|
|
else
|
|
{
|
|
$res = array('option' => '', 'id' => $id, 'type' => $type, 'err_no' => 2);
|
|
}
|
|
}
|
|
}
|
|
|
|
die($json->encode($res));
|
|
}
|
|
|
|
|
|
//商品评论回复
|
|
else if($_REQUEST['act'] == 'comment_reply'){
|
|
include('includes/cls_json.php');
|
|
$json = new JSON;
|
|
$result = array('err_msg' => '', 'err_no' => 0, 'content' => '');
|
|
|
|
$comment_id = isset($_REQUEST['comment_id']) ? intval($_REQUEST['comment_id']) : 0;
|
|
$reply_content = isset($_REQUEST['reply_content']) ? htmlspecialchars(trim($_REQUEST['reply_content'])) : 0;
|
|
$goods_id = isset($_REQUEST['goods_id']) ? intval($_REQUEST['goods_id']) : 0;
|
|
$comment_user = isset($_REQUEST['user_id']) ? intval($_REQUEST['user_id']) : 0;
|
|
$libType = isset($_REQUEST['libType']) ? intval($_REQUEST['libType']) : 0;
|
|
$type = 0;
|
|
$reply_page = 1;
|
|
|
|
$add_time = gmtime();
|
|
$real_ip = real_ip();
|
|
|
|
$result['comment_id'] = $comment_id;
|
|
$result['reply_content'] = $reply_content;
|
|
|
|
if(!isset($_SESSION['user_id']) || $_SESSION['user_id'] == 0){
|
|
$result['err_no'] = 1;
|
|
}elseif($comment_user == $_SESSION['user_id']){
|
|
$result['err_no'] = 2;
|
|
}else{
|
|
$comment_user_count = $GLOBALS['db']->getOne("SELECT COUNT(*) FROM " .$GLOBALS['ecs']->table('comment'). " WHERE id_value = '$goods_id' AND parent_id = '$comment_id' AND user_id = '" .$_SESSION['user_id']. "'");
|
|
if($comment_user_count > 0){
|
|
$result['err_no'] = 2;
|
|
}else{
|
|
|
|
$comment_user_name = $GLOBALS['db']->getOne("SELECT user_name FROM " .$GLOBALS['ecs']->table('users'). " WHERE user_id = '" .$_SESSION['user_id']. "'");
|
|
$status = 1 - $GLOBALS['_CFG']['comment_check'];
|
|
$sql = "INSERT INTO " .$GLOBALS['ecs']->table('comment'). "(`id_value`,`content`,`comment_type`,`user_name`,`comment_rank`,`comment_server`,`comment_delivery`, `add_time`, `parent_id`, `user_id`, `ip_address`, `status`)".
|
|
"VALUES('$goods_id', '$reply_content', 2, '$comment_user_name', '5', '5', '5', '$add_time', '$comment_id', '" .$_SESSION['user_id']. "', '$real_ip', '$status')";
|
|
$GLOBALS['db']->query($sql);
|
|
|
|
$result['message'] = $GLOBALS['_CFG']['comment_check'] ? $_LANG['cmt_submit_wait'] : $_LANG['cmt_submit_done'];
|
|
}
|
|
}
|
|
|
|
if($libType == 1){
|
|
$size = 10;
|
|
}else{
|
|
$size = 2;
|
|
}
|
|
|
|
if( $result['err_no'] != 1){
|
|
$reply = get_reply_list($goods_id, $comment_id, $type, $reply_page, $libType, $size);
|
|
|
|
$smarty->assign('reply_pager', $reply['reply_pager']);
|
|
$smarty->assign('reply_count', $reply['reply_count']);
|
|
$smarty->assign('reply_list', $reply['reply_list']);
|
|
|
|
if($libType == 1){
|
|
$result['content'] = $smarty->fetch("library/comment_repay.lbi");
|
|
}else{
|
|
$result['content'] = $smarty->fetch("library/comment_reply.lbi");
|
|
}
|
|
}
|
|
|
|
$result['url'] = get_return_goods_url($goods_id);
|
|
|
|
die($json->encode($result));
|
|
}
|
|
|
|
//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));
|
|
|
|
}
|
|
|
|
if (!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();
|
|
|
|
$goods_id = empty($_GET['id']) ? 0 : intval($_GET['id']);
|
|
$province = empty($_GET['province']) ? 1 : intval($_GET['province']);
|
|
$city = empty($_GET['city']) ? 52 : intval($_GET['city']);
|
|
$district = empty($_GET['district']) ? 500 : intval($_GET['district']);
|
|
$d_null = empty($_GET['d_null']) ? 0 : intval($_GET['d_null']);
|
|
$user_id = empty($_GET['user_id']) ? 0 : intval($_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);
|
|
|
|
//清空
|
|
setcookie('type_province', 0, gmtime() + 3600 * 24 * 30);
|
|
setcookie('type_city', 0, gmtime() + 3600 * 24 * 30);
|
|
setcookie('type_district', 0, 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;
|
|
|
|
$flow_warehouse = get_warehouse_goods_region($province);
|
|
setcookie('flow_region', $flow_warehouse['region_id'], gmtime() + 3600 * 24 * 30);
|
|
|
|
die($json->encode($res));
|
|
|
|
}
|
|
|
|
/**
|
|
* 获取商品属性列表 by Leah
|
|
*/
|
|
if($_REQUEST['act']=='ajax_get_spec'){
|
|
require_once(ROOT_PATH . 'includes/cls_json.php');
|
|
|
|
$json = new JSON();
|
|
|
|
$result = array('error' => 0, 'message' => '', 'attr_val' => '');
|
|
|
|
$rec_id = isset($_REQUEST['rec_id']) ? intval($_REQUEST['rec_id']) : 0;
|
|
$g_id = isset($_REQUEST['g_id']) ? intval($_REQUEST['g_id']) : 0;
|
|
$g_number = isset($_REQUEST['g_number']) ? intval($_REQUEST['g_number']) : 0;
|
|
|
|
$sql = "select warehouse_id, area_id from " .$ecs->table('order_goods'). " where rec_id = '$rec_id'";
|
|
$order_goods = $db->getRow($sql);
|
|
|
|
if ($rec_id == 0 || $g_id == 0) {
|
|
|
|
$result['err_msg'] = '获取不到属性值';
|
|
$result['err_no'] = 1;
|
|
} else {
|
|
|
|
$sql = "select goods_attr_id from " .$ecs->table('order_goods'). " where rec_id = '$rec_id'";
|
|
$goods_attr_id = $db->getOne($sql);
|
|
|
|
$goods_attr = array();
|
|
if(!empty($goods_attr_id)){
|
|
$goods_attr = explode(',', $goods_attr_id);
|
|
}
|
|
|
|
$properties = get_goods_properties($g_id, $order_goods['warehouse_id'], $order_goods['area_id']); // 获得商品的规格和属性
|
|
$spec = $properties['spe'];
|
|
|
|
if (!empty($spec)) {
|
|
|
|
foreach ($spec as $key => $value) {
|
|
if($value['is_checked'] == 0){
|
|
continue;
|
|
}
|
|
$result['spec'] .= '<div class="catt"><span class="type_item">' . $value['name'] . '：</span>';
|
|
$result['spec'] .= '<input type="hidden" value="" id="attr_' . $key . '" name="attr_val[]"/>';
|
|
$result['spec'] .= '<span class="type_con">';
|
|
foreach ($value['values'] as $k => $v) {
|
|
|
|
$arr_class = get_user_attr_checked($goods_attr, $v['id']);
|
|
|
|
if($arr_class['class'] == 'cattsel'){
|
|
$result['attr_val'] .= $key .'_' . $arr_class['attr_val'] . ",";
|
|
}
|
|
|
|
if ($value['is_checked'] == 1) {
|
|
$padding = '';
|
|
if(!empty($v['img_flie'])){
|
|
$img_flie = '<img src="' . $v['img_flie'] . '" width="25" height="25">'.$v['label'];
|
|
}else{
|
|
$img_flie = $v['label'];
|
|
$padding = 'style="padding:3px 7px !important;"';
|
|
}
|
|
|
|
$result['spec'] .= '<a '.$padding.' class="'.$arr_class['class'].'" title="' . $v['label'] . '[' . $v['format_price'] . ']" onclick="setChange(' . $v['id'] . ' , this , ' . $key . ')" >'.$img_flie.'<i></i></a>';
|
|
} else {
|
|
|
|
$result['spec'] .= '<a href="javascipt:void(0)" class="'.$arr_class['class'].'" title="' . $v['label'] . '[' . $v['format_price'] . ']" onclick="setChange(' . $v['id'] . ',this , ' . $key . ')" >' . $v['label'] . '<i></i></a>';
|
|
}
|
|
}
|
|
$result['spec'] .= '</span>';
|
|
$result['spec'] .='</div>';
|
|
}
|
|
|
|
}
|
|
|
|
$result['spec'] .= '<div id="back_div">';
|
|
$result['spec'] .= '<div class="type_item">换货数量：</div>';
|
|
$result['spec'] .= '<div class="type_con"><a onclick="buyNumber.minus(this, 2)" href="javascript:;" id="decrease" class="plus_minus">-</a>';
|
|
$result['spec'] .= '<input class="return_num" type="text" id="back_num" value="1" defaultnumber="1" name="attr_num" ' . " onblur=check_attr_num(this.id," . $g_number . "," . $rec_id .") />";
|
|
$result['spec'] .= '</div><a onclick="buyNumber.plus(this, 2)" href="javascript:;" id="increase" class="plus_minus">+</a>';
|
|
$result['spec'] .= '</div>';
|
|
|
|
$result['rec_id'] = $rec_id;
|
|
|
|
if(!empty($result['attr_val'])){
|
|
$result['attr_val'] = substr($result['attr_val'], 0, -1);
|
|
}
|
|
}
|
|
die($json->encode($result));
|
|
}
|
|
|
|
/**
|
|
* ecmoban模板堂 zhuo
|
|
*/
|
|
elseif($_REQUEST['act'] == 'getInfo'){
|
|
|
|
require_once(ROOT_PATH .'includes/cls_json.php');
|
|
|
|
$json = new JSON();
|
|
|
|
$result = array('error' => 0, 'message'=> '');
|
|
|
|
$attr_id = $_POST['attr_id'];
|
|
|
|
$sql = "SELECT attr_gallery_flie FROM " .$GLOBALS['ecs']->table('goods_attr')." WHERE goods_attr_id = '$attr_id' and goods_id = '$goods_id'";
|
|
$row = $db->getRow($sql);
|
|
|
|
$result['t_img'] = $row['attr_gallery_flie'];
|
|
|
|
die($json->encode($result));
|
|
}
|
|
|
|
#需要查询的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);
|
|
|
|
$sellerInfo = get_seller_info_area();
|
|
if(empty($province_id)){
|
|
$province_id = $sellerInfo['province'];
|
|
$city_id = $sellerInfo['city'];
|
|
$district_id = 0;
|
|
|
|
setcookie('province', $province_id, gmtime() + 3600 * 24 * 30);
|
|
setcookie('city', $city_id, gmtime() + 3600 * 24 * 30);
|
|
setcookie('district', $district_id, gmtime() + 3600 * 24 * 30);
|
|
|
|
$goods_warehouse = get_warehouse_goods_region($province_id);
|
|
$region_id = $goods_warehouse['region_id'];
|
|
}
|
|
//ecmoban模板堂 --zhuo end 仓库
|
|
|
|
/*------------------------------------------------------ */
|
|
//-- 商品购买记录ajax处理
|
|
/*------------------------------------------------------ */
|
|
|
|
if (!empty($_REQUEST['act']) && $_REQUEST['act'] == 'gotopage')
|
|
{
|
|
include('includes/cls_json.php');
|
|
|
|
$json = new JSON;
|
|
$res = array('err_msg' => '', 'result' => '');
|
|
|
|
$goods_id = isset($_REQUEST['id']) ? intval($_REQUEST['id']) : 0;
|
|
$page = (isset($_REQUEST['page'])) ? intval($_REQUEST['page']) : 1;
|
|
|
|
if (!empty($goods_id))
|
|
{
|
|
$need_cache = $GLOBALS['smarty']->caching;
|
|
$need_compile = $GLOBALS['smarty']->force_compile;
|
|
|
|
$GLOBALS['smarty']->caching = false;
|
|
$GLOBALS['smarty']->force_compile = true;
|
|
|
|
/* 商品购买记录 */
|
|
$sql = 'SELECT u.user_name, og.goods_number, oi.add_time, IF(oi.order_status IN (2, 3, 4), 0, 1) AS order_status ' .
|
|
'FROM ' . $ecs->table('order_info') . ' AS oi LEFT JOIN ' . $ecs->table('users') . ' AS u ON oi.user_id = u.user_id, ' . $ecs->table('order_goods') . ' AS og ' .
|
|
'WHERE oi.order_id = og.order_id AND ' . gmtime() . ' - oi.add_time < 2592000 AND og.goods_id = ' . $goods_id . ' ORDER BY oi.add_time DESC LIMIT ' . (($page > 1) ? ($page-1) : 0) * 5 . ',5';
|
|
$bought_notes = $db->getAll($sql);
|
|
|
|
foreach ($bought_notes as $key => $val)
|
|
{
|
|
$bought_notes[$key]['add_time'] = local_date("Y-m-d G:i:s", $val['add_time']);
|
|
}
|
|
|
|
$sql = 'SELECT count(*) ' .
|
|
'FROM ' . $ecs->table('order_info') . ' AS oi LEFT JOIN ' . $ecs->table('users') . ' AS u ON oi.user_id = u.user_id, ' . $ecs->table('order_goods') . ' AS og ' .
|
|
'WHERE oi.order_id = og.order_id AND ' . gmtime() . ' - oi.add_time < 2592000 AND og.goods_id = ' . $goods_id;
|
|
$count = $db->getOne($sql);
|
|
|
|
|
|
/* 商品购买记录分页样式 */
|
|
$pager = array();
|
|
$pager['page'] = $page;
|
|
$pager['size'] = $size = 5;
|
|
$pager['record_count'] = $count;
|
|
$pager['page_count'] = $page_count = ($count > 0) ? intval(ceil($count / $size)) : 1;;
|
|
$pager['page_first'] = "javascript:gotoBuyPage(1,$goods_id)";
|
|
$pager['page_prev'] = $page > 1 ? "javascript:gotoBuyPage(" .($page-1). ",$goods_id)" : 'javascript:;';
|
|
$pager['page_next'] = $page < $page_count ? 'javascript:gotoBuyPage(' .($page + 1) . ",$goods_id)" : 'javascript:;';
|
|
$pager['page_last'] = $page < $page_count ? 'javascript:gotoBuyPage(' .$page_count. ",$goods_id)" : 'javascript:;';
|
|
|
|
$smarty->assign('notes', $bought_notes);
|
|
$smarty->assign('pager', $pager);
|
|
|
|
|
|
$res['result'] = $GLOBALS['smarty']->fetch('library/bought_notes.lbi');
|
|
|
|
$GLOBALS['smarty']->caching = $need_cache;
|
|
$GLOBALS['smarty']->force_compile = $need_compile;
|
|
}
|
|
|
|
die($json->encode($res));
|
|
}
|
|
/*------------------------------------------------------ */
|
|
//-- 猜你喜欢--换一组ajax处理
|
|
/*------------------------------------------------------ */
|
|
if (!empty($_REQUEST['act']) && $_REQUEST['act'] == 'guess_goods')
|
|
{
|
|
include('includes/cls_json.php');
|
|
|
|
$json = new JSON;
|
|
$res = array('err_msg' => '', 'result' => '');
|
|
|
|
$page = (isset($_REQUEST['page'])) ? intval($_REQUEST['page']) : 1;
|
|
if($page > 3){
|
|
$page = 1;
|
|
}
|
|
$need_cache = $GLOBALS['smarty']->caching;
|
|
$need_compile = $GLOBALS['smarty']->force_compile;
|
|
$GLOBALS['smarty']->caching = false;
|
|
$GLOBALS['smarty']->force_compile = true;
|
|
|
|
$guess_goods = get_guess_goods($user_id, 1, $page, 7);
|
|
|
|
$smarty->assign('guess_goods', $guess_goods);
|
|
$smarty->assign('pager', $pager);
|
|
|
|
$res['page'] = $page;
|
|
$res['result'] = $GLOBALS['smarty']->fetch('library/guess_goods_love.lbi');
|
|
|
|
$GLOBALS['smarty']->caching = $need_cache;
|
|
$GLOBALS['smarty']->force_compile = $need_compile;
|
|
|
|
die($json->encode($res));
|
|
}
|
|
//@author guan start
|
|
/*------------------------------------------------------ */
|
|
//-- 评论有用+1
|
|
/*------------------------------------------------------ */
|
|
elseif($_REQUEST['act'] == 'comment_reply')
|
|
{
|
|
require_once (dirname(__FILE__) . '/includes/cls_json.php');
|
|
$json = new JSON();
|
|
|
|
$res = array('err_msg' => '', 'content' => '', 'err_no' => 0);
|
|
|
|
$id = empty($_REQUEST['id']) ? 0 : intval($_REQUEST['id']);
|
|
$type = empty($_REQUEST['type']) ? 'comment' : $_REQUEST['type'];
|
|
$ip = real_ip();
|
|
if(!empty($id))
|
|
{
|
|
if(!isset($_SESSION['user_id']) || $_SESSION['user_id'] == 0){
|
|
$res['err_no'] = 1;
|
|
}else{
|
|
|
|
$useful_user = '';
|
|
$sql = 'SELECT useful_user, useful FROM '.$ecs->table('comment')." WHERE comment_id='$id'";
|
|
$comment = $db->getRow($sql);
|
|
|
|
if($comment['useful_user']){
|
|
$useful_user = explode(',', $comment['useful_user']);
|
|
if(in_array($_SESSION['user_id'], $useful_user)){
|
|
$res['err_no'] = 2;
|
|
die($json->encode($res));
|
|
}else{
|
|
array_push($useful_user, $_SESSION['user_id']);
|
|
$useful_user = implode(',', $useful_user);
|
|
}
|
|
}else{
|
|
$useful_user = array(0);
|
|
array_push($useful_user, $_SESSION['user_id']);
|
|
$useful_user = implode(',', $useful_user);
|
|
}
|
|
|
|
$sql = 'SELECT COUNT(*) FROM '.$ecs->table('comment')." WHERE comment_id='$id'";
|
|
$count = $db->getOne($sql);
|
|
|
|
if($count == 1)
|
|
{
|
|
$sql = "UPDATE " . $ecs->table('comment') . " SET useful = useful + 1, useful_user = '$useful_user' WHERE comment_id='$id'";
|
|
if($db->query($sql))
|
|
{
|
|
$res = array('option' => 'true', 'id' => $id, 'type' => $type, 'useful' => $comment['useful'] + 1, 'err_no' => 0);
|
|
}
|
|
else
|
|
{
|
|
$res = array('error' => '', 'id' => $id, 'type' => $type, 'err_no' => 2);
|
|
}
|
|
}
|
|
else
|
|
{
|
|
$res = array('option' => '', 'id' => $id, 'type' => $type, 'err_no' => 2);
|
|
}
|
|
}
|
|
}
|
|
|
|
die($json->encode($res));
|
|
}
|
|
|
|
/**
|
|
* 商品评论
|
|
*/
|
|
elseif($_REQUEST['act'] == 'reply_comment')
|
|
{
|
|
require_once (dirname(__FILE__) . '/includes/cls_json.php');
|
|
$json = new JSON();
|
|
$content = empty($_REQUEST['comment_content']) ? '' : htmlspecialchars($_REQUEST['comment_content']);//评论内容
|
|
$user_name = $_SESSION['user_name'];//当前评论人名称
|
|
$cid = empty($_REQUEST['comment_id']) ? 0 : $_REQUEST['comment_id'];//评论ID
|
|
$sid = empty($_REQUEST['single_id']) ? 0 : $_REQUEST['single_id'];//晒单ID
|
|
$addtime = gmtime();
|
|
$ip = real_ip();
|
|
$is_ajax = empty($_REQUEST['is_ajax']) ? 0 : htmlspecialchars($_REQUEST['is_ajax']);
|
|
|
|
|
|
if(empty($cid))
|
|
{
|
|
$err_msg = '此条评论可能已经被删除';
|
|
$res = array('error' => $err_msg, 'option' => false);
|
|
die($json->encode($res));
|
|
}
|
|
|
|
|
|
/* 判断用户是否登录 */
|
|
if(empty($_SESSION['user_id']))
|
|
{
|
|
if($is_ajax == 1)
|
|
{
|
|
$res['is_user'] = '';
|
|
die($json->encode($res));
|
|
}
|
|
}
|
|
|
|
if($content == "")
|
|
{
|
|
$err_msg = '回复内容不能为空';
|
|
$res = array('error' => $err_msg, 'option' => false);
|
|
die($json->encode($res));
|
|
}
|
|
|
|
$com_user = $db->getRow("SELECT user_name, id_value FROM " . $ecs->table('comment') . " WHERE comment_id=" . $cid);
|
|
if($com_user['user_name'] == $user_name)
|
|
{
|
|
if($is_ajax == 1)
|
|
{
|
|
$err_msg = '不能对自己评论';
|
|
$res = array('error' => $err_msg, 'option' => false);
|
|
die($json->encode($res));
|
|
}
|
|
}
|
|
|
|
$sql = "INSERT INTO " . $ecs->table('comment') . "(comment_type, id_value, email, user_name, content, comment_rank, add_time, ip_address, status, parent_id, user_id, single_id)
|
|
VALUES('0', '$com_user[id_value]', '$_SESSION[email]', '$user_name', '$content', 5, '$addtime', '$ip', '1', '$cid', '$_SESSION[user_id]', '$sid')";
|
|
|
|
if($db->query($sql))
|
|
{
|
|
$res = array('error' => 0, 'option' => true);
|
|
die($json->encode($res));
|
|
}
|
|
else
|
|
{
|
|
$res = array('error' => '评论未成功，请检查网络。', 'option' => false);
|
|
die($json->encode($res));
|
|
}
|
|
}
|
|
|
|
//by li start
|
|
/*------------------------------------------------------ */
|
|
//-- 商品降价通知
|
|
/*------------------------------------------------------ */
|
|
if (!empty($_REQUEST['act']) && $_REQUEST['act'] == 'price_notice')
|
|
{
|
|
include('includes/cls_json.php');
|
|
|
|
$json = new JSON;
|
|
$res = array('msg' => '', 'status' => '');
|
|
|
|
$goods_id = isset($_REQUEST['goods_id']) ? intval($_REQUEST['goods_id']) : 0;
|
|
$user_id = isset($_REQUEST['user_id']) ? intval($_SESSION['user_id']) : 0;
|
|
$email = isset($_REQUEST['email']) ? trim($_REQUEST['email']) : '';
|
|
$cellphone = isset($_REQUEST['cellphone']) ? trim($_REQUEST['cellphone']) : '';
|
|
$hopeDiscount = isset($_REQUEST['hopeDiscount']) ? trim($_REQUEST['hopeDiscount']) : 0;
|
|
$add_time = gmtime();
|
|
|
|
if ($user_id && $email) {
|
|
$sql = "SELECT count(*) FROM " . $ecs->table('sale_notice') . " WHERE goods_id='$goods_id' AND user_id='$user_id'";
|
|
$one = $db->getOne($sql);
|
|
if ($one) {
|
|
$sql = "UPDATE " . $ecs->table('sale_notice') . " SET cellphone='$cellphone',email='$email',hopeDiscount='$hopeDiscount',add_time='$add_time' WHERE goods_id='$goods_id' AND user_id='$user_id'";
|
|
$db->query($sql);
|
|
$res['msg'] = '更新成功！';
|
|
} else {
|
|
$sql = "INSERT INTO " . $ecs->table('sale_notice') . " (user_id,goods_id,cellphone,email,hopeDiscount,add_time)" .
|
|
" VALUES ('$user_id','$goods_id','$cellphone','$email','$hopeDiscount','$add_time')";
|
|
$db->query($sql);
|
|
$res['msg'] = '提交成功！';
|
|
}
|
|
$res['status'] = 0;
|
|
} else {
|
|
$res['msg'] = '提交失败，稍后在提交一次';
|
|
$res['status'] = 1;
|
|
}
|
|
|
|
die($json->encode($res));
|
|
}
|
|
//by li end
|
|
|
|
/*------------------------------------------------------ */
|
|
//-- PROCESSOR
|
|
/*------------------------------------------------------ */
|
|
|
|
$area_info = get_area_info($province_id);
|
|
$goods = get_goods_info($goods_id, $region_id, $area_info['region_id']);
|
|
|
|
if($region_id == NULL){
|
|
$region_id = 0;
|
|
}
|
|
|
|
if($area_info['region_id'] == NULL){
|
|
$area_info['region_id'] = 0;
|
|
}
|
|
|
|
$area = array(
|
|
'region_id' => $region_id, //仓库ID
|
|
'province_id' => $province_id,
|
|
'city_id' => $city_id,
|
|
'district_id' => $district_id,
|
|
'goods_id' => $goods_id,
|
|
'user_id' => $user_id,
|
|
'area_id' => $area_info['region_id'],
|
|
'merchant_id' => $goods['user_id'],
|
|
);
|
|
|
|
$smarty->assign('area', $area);
|
|
|
|
$cache_id = $goods_id . '-' . $_SESSION['user_rank'].'-'.$_CFG['lang'];
|
|
$cache_id = sprintf('%X', crc32($cache_id));
|
|
|
|
$cache_id = '';
|
|
$not = 'not';
|
|
if (!$smarty->is_cached('goods.dwt', $cache_id))
|
|
{
|
|
$smarty->assign('image_width', $_CFG['image_width']);
|
|
$smarty->assign('image_height', $_CFG['image_height']);
|
|
$smarty->assign('helps', get_shop_help()); // 网店帮助
|
|
$smarty->assign('id', $goods_id);
|
|
$smarty->assign('type', 0);
|
|
$smarty->assign('cfg', $_CFG);
|
|
|
|
$promotion = get_promotion_info($goods_id, $goods['user_id']);
|
|
$smarty->assign('promotion', $promotion);//促销信息
|
|
|
|
$promotion_info = get_promotion_info('', $goods['user_id']);
|
|
$smarty->assign('promotion_info', $promotion_info);
|
|
|
|
//ecmoban模板堂 --zhuo start 限购
|
|
$user_id = !empty($_SESSION['user_id']) ? $_SESSION['user_id'] : 0;
|
|
$start_date = $goods['xiangou_start_date'];
|
|
$end_date = $goods['xiangou_end_date'];
|
|
|
|
$nowTime = gmtime();
|
|
if($nowTime > $start_date && $nowTime < $end_date){
|
|
$xiangou = 1;
|
|
}else{
|
|
$xiangou = 0;
|
|
}
|
|
|
|
$order_goods = get_for_purchasing_goods($start_date, $end_date, $goods_id, $user_id);
|
|
$smarty->assign('xiangou', $xiangou);
|
|
$smarty->assign('orderG_number', $order_goods['goods_number']);
|
|
//ecmoban模板堂 --zhuo end 限购
|
|
|
|
//ecmoban模板堂 --zhuo start
|
|
$shop_info = get_merchants_shop_info('merchants_steps_fields', $goods['user_id']);
|
|
$adress = get_license_comp_adress($shop_info['license_comp_adress']);
|
|
|
|
$smarty->assign('shop_info', $shop_info);
|
|
$smarty->assign('adress', $adress);
|
|
//ecmoban模板堂 --zhuo end
|
|
|
|
if ($goods === false)
|
|
{
|
|
/* 如果没有找到任何记录则跳回到首页 */
|
|
ecs_header("Location: ./\n");
|
|
exit;
|
|
}
|
|
else
|
|
{
|
|
//by wang 获得商品扩展信息
|
|
$goods['goods_extends'] = get_goods_extends($goods_id);
|
|
if ($goods['brand_id'] > 0) {
|
|
$brand_act = '';
|
|
$brand = get_goods_brand($goods['brand_id'], $goods['user_id']);
|
|
if ($brand) {
|
|
$goods['brand_id'] = $brand['brand_id'];
|
|
$goods['goods_brand'] = $brand['goods_brand'];
|
|
$brand_act = "merchants_brands";
|
|
}
|
|
|
|
$goods['goods_brand_url'] = build_uri('brand', array('bid' => $goods['brand_id'], 'act' => $brand_act), $goods['goods_brand']);
|
|
}
|
|
|
|
$shop_price = $goods['shop_price'];
|
|
$linked_goods = get_linked_goods($goods_id, $region_id, $area_info['region_id']);
|
|
|
|
$goods['goods_style_name'] = add_style($goods['goods_name'], $goods['goods_name_style']);
|
|
|
|
/* 购买该商品可以得到多少钱的红包 */
|
|
if ($goods['bonus_type_id'] > 0)
|
|
{
|
|
$time = gmtime();
|
|
$sql = "SELECT type_money FROM " . $ecs->table('bonus_type') .
|
|
" WHERE type_id = '$goods[bonus_type_id]' " .
|
|
" AND send_type = '" . SEND_BY_GOODS . "' " .
|
|
" AND send_start_date <= '$time'" .
|
|
" AND send_end_date >= '$time'";
|
|
$goods['bonus_money'] = floatval($db->getOne($sql));
|
|
if ($goods['bonus_money'] > 0)
|
|
{
|
|
$goods['bonus_money'] = price_format($goods['bonus_money']);
|
|
}
|
|
}
|
|
$sql = "SELECT rec_id FROM " .$ecs->table('collect_store'). " WHERE user_id = '$user_id' AND ru_id = '$goods[user_id]' ";//by kong
|
|
$rec_id = $db->getOne($sql);
|
|
if($rec_id>0){
|
|
$goods['error']='1';
|
|
}else{
|
|
$goods['error']='2';
|
|
}
|
|
|
|
//@author guan start
|
|
if($_CFG['two_code'])
|
|
{
|
|
$logo = empty($_CFG['two_code_logo']) ? $goods['goods_img'] : str_replace('../', '', $_CFG['two_code_logo']);
|
|
|
|
$size = '200x200';
|
|
$url = $ecs->url();
|
|
$two_code_links = trim($_CFG['two_code_links']);
|
|
$two_code_links = empty($two_code_links) ? $url : $two_code_links;
|
|
$data = $two_code_links . 'mobile/index.php?r=goods&id=' . $goods['goods_id'];
|
|
$errorCorrectionLevel = 'H'; // 纠错级别：L、M、Q、H
|
|
$matrixPointSize = 4; // 点的大小：1到10
|
|
$filename = "images/weixin_img/weixin_code_" . $goods['goods_id'] . ".png";
|
|
|
|
QRcode::png($data, $filename, $errorCorrectionLevel, $matrixPointSize);
|
|
|
|
$QR = imagecreatefrompng($filename);
|
|
//$QR = imagecreatefrompng('./chart.png');//外面那QR图
|
|
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('weixin_img_url', $filename);
|
|
$smarty->assign('weixin_img_text', trim($_CFG['two_code_mouse']));
|
|
$smarty->assign('two_code', trim($_CFG['two_code']));
|
|
}
|
|
//@author guan end
|
|
|
|
$smarty->assign('goods', $goods);
|
|
|
|
$smarty->assign('goods_name', $goods['goods_name']);
|
|
$smarty->assign('goods_id', $goods['goods_id']);
|
|
$smarty->assign('promote_end_time', $goods['gmt_end_time']);
|
|
|
|
/* meta */
|
|
$smarty->assign('keywords', htmlspecialchars($goods['keywords']));
|
|
$smarty->assign('description', htmlspecialchars($goods['goods_brief']));
|
|
|
|
|
|
$catlist = array();
|
|
foreach(get_parent_cats($goods['cat_id']) as $k=>$v)
|
|
{
|
|
$catlist[] = $v['cat_id'];
|
|
}
|
|
|
|
assign_template('c', $catlist);
|
|
|
|
/* 上一个商品下一个商品 */
|
|
$prev_gid = $db->getOne("SELECT goods_id FROM " .$ecs->table('goods'). " WHERE cat_id=" . $goods['cat_id'] . " AND goods_id > " . $goods['goods_id'] . " AND is_on_sale = 1 AND is_alone_sale = 1 AND is_delete = 0 LIMIT 1");
|
|
if (!empty($prev_gid))
|
|
{
|
|
$prev_good['url'] = build_uri('goods', array('gid' => $prev_gid), $goods['goods_name']);
|
|
$smarty->assign('prev_good', $prev_good);//上一个商品
|
|
}
|
|
|
|
$next_gid = $db->getOne("SELECT max(goods_id) FROM " . $ecs->table('goods') . " WHERE cat_id=".$goods['cat_id']." AND goods_id < ".$goods['goods_id'] . " AND is_on_sale = 1 AND is_alone_sale = 1 AND is_delete = 0");
|
|
if (!empty($next_gid))
|
|
{
|
|
$next_good['url'] = build_uri('goods', array('gid' => $next_gid), $goods['goods_name']);
|
|
$smarty->assign('next_good', $next_good);//下一个商品
|
|
}
|
|
|
|
$position = assign_ur_here($goods['cat_id'], $goods['goods_name'], array(), '', $goods['user_id']);
|
|
|
|
/* current position */
|
|
$smarty->assign('page_title', $position['title']); // 页面标题
|
|
$smarty->assign('ur_here', $position['ur_here']); // 当前位置
|
|
|
|
$categories_pro = get_category_tree_leve_one();
|
|
$smarty->assign('categories_pro', $categories_pro); // 分类树加强版
|
|
|
|
$properties = get_goods_properties($goods_id, $region_id, $area_info['region_id']); // 获得商品的规格和属性 //ecmoban模板堂 --zhuo
|
|
|
|
$smarty->assign('top_goods', get_top10()); // 销售排行
|
|
|
|
$smarty->assign('best_goods', get_recommend_goods('best', '', $region_id, $area_info['region_id'], $goods['user_id'], 1)); // 推荐商品
|
|
$smarty->assign('new_goods', get_recommend_goods('new', '', $region_id, $area_info['region_id'], $goods['user_id'], 1)); // 最新商品
|
|
$smarty->assign('hot_goods', get_recommend_goods('hot', '', $region_id, $area_info['region_id'], $goods['user_id'], 1)); // 最新商品
|
|
|
|
$smarty->assign('properties', $properties['pro']); // 商品规格
|
|
$smarty->assign('specification', $properties['spe']); // 商品属性
|
|
$smarty->assign('attribute_linked', get_same_attribute_goods($properties)); // 相同属性的关联商品
|
|
|
|
$smarty->assign('related_goods', $linked_goods); // 关联商品
|
|
|
|
$smarty->assign('goods_article_list', get_linked_articles($goods_id)); // 关联文章
|
|
$smarty->assign('rank_prices', get_user_rank_prices($goods_id, $shop_price)); // 会员等级价格
|
|
$smarty->assign('pictures', get_goods_gallery($goods_id)); // 商品相册
|
|
$smarty->assign('bought_goods', get_also_bought($goods_id)); // 购买了该商品的用户还购买了哪些商品
|
|
$smarty->assign('goods_rank', get_goods_rank($goods_id)); // 商品的销售排名
|
|
$smarty->assign('guess_goods', get_guess_goods($user_id, 1, $page=1, 7)); //猜你喜欢
|
|
|
|
$cat_info = cat_list(0, 0, false, 0, true, '', 0, $goods['user_id']);
|
|
$goods_store_cat = goods_admin_store_cat_list($cat_info);
|
|
$smarty->assign('goods_store_cat', $goods_store_cat);
|
|
|
|
//by mike start
|
|
//组合套餐名
|
|
$comboTabIndex = get_cfg_group_goods();
|
|
$smarty->assign('comboTab',$comboTabIndex);
|
|
//组合套餐组
|
|
$fittings_list = get_goods_fittings(array($goods_id), $region_id, $area_info['region_id']);
|
|
if(is_array($fittings_list)){
|
|
foreach($fittings_list as $vo){
|
|
$fittings_index[$vo['group_id']] = $vo['group_id'];//关联数组
|
|
}
|
|
}
|
|
ksort($fittings_index);//重新排序
|
|
$smarty->assign('fittings_tab_index', $fittings_index);//套餐数量
|
|
//by mike end
|
|
|
|
$smarty->assign('fittings', $fittings_list); // 配件
|
|
|
|
//获取tag
|
|
$tag_array = get_tags($goods_id);
|
|
$smarty->assign('tags', $tag_array); // 商品的标记
|
|
|
|
//获取关联礼包
|
|
$package_goods_list = get_package_goods_list($goods['goods_id']);
|
|
$smarty->assign('package_goods_list',$package_goods_list); // 获取关联礼包
|
|
|
|
assign_dynamic('goods');
|
|
$volume_price_list = get_volume_price_list($goods['goods_id'], '1');
|
|
$smarty->assign('volume_price_list',$volume_price_list); // 商品优惠价格区间
|
|
|
|
$discuss_list = get_discuss_all_list($goods_id, 0, 1, 10);
|
|
$smarty->assign('discuss_list', $discuss_list);
|
|
}
|
|
}
|
|
|
|
/* 记录浏览历史 */
|
|
if (!empty($_COOKIE['ECS']['history']))
|
|
{
|
|
$history = explode(',', $_COOKIE['ECS']['history']);
|
|
|
|
array_unshift($history, $goods_id);
|
|
$history = array_unique($history);
|
|
|
|
while (count($history) > $_CFG['history_number'])
|
|
{
|
|
array_pop($history);
|
|
}
|
|
|
|
setcookie('ECS[history]', implode(',', $history), gmtime() + 3600 * 24 * 30);
|
|
}
|
|
else
|
|
{
|
|
setcookie('ECS[history]', $goods_id, gmtime() + 3600 * 24 * 30);
|
|
}
|
|
|
|
$smarty->assign('goods_id', $goods_id); //商品ID
|
|
$smarty->assign('region_id', $region_id); //商品仓库region_id
|
|
$smarty->assign('user_id', $user_id);
|
|
$smarty->assign('area_id', $area_info['region_id']); //地区ID
|
|
|
|
/* 更新点击次数 */
|
|
$db->query('UPDATE ' . $ecs->table('goods') . " SET click_count = click_count + 1 WHERE goods_id = '$_REQUEST[id]'");
|
|
|
|
/* 记录浏览历史 ecmoban模板堂 --zhuo start 浏览列表插件*/
|
|
if (!empty($_COOKIE['ECS']['list_history']))
|
|
{
|
|
$list_history = explode(',', $_COOKIE['ECS']['list_history']);
|
|
|
|
array_unshift($list_history, $goods_id);
|
|
$list_history = array_unique($list_history);
|
|
|
|
while (count($list_history) > 100000)
|
|
{
|
|
array_pop($list_history);
|
|
}
|
|
|
|
setcookie('ECS[list_history]', implode(',', $list_history), gmtime() + 3600 * 24 * 30);
|
|
}
|
|
else
|
|
{
|
|
setcookie('ECS[list_history]', $goods_id, gmtime() + 3600 * 24 * 30);
|
|
}
|
|
/* 记录浏览历史 ecmoban模板堂 --zhuo end 浏览列表插件*/
|
|
|
|
//ecmoban模板堂 --zhuo 仓库 start
|
|
$date = array('shipping_code');
|
|
$where = "shipping_id = '" .$goods['default_shipping']. "'";
|
|
$shipping_code = get_table_date('shipping', $where, $date, 2);
|
|
|
|
$cart_num = get_goods_cart_num($goods_id, $region_id);
|
|
$smarty->assign('cart_num', $cart_num);
|
|
|
|
$smarty->assign('area_htmlType', 'goods');
|
|
|
|
//评分 start
|
|
$comment_all = get_comments_percent($goods_id);
|
|
if($goods['user_id'] > 0){
|
|
$merchants_goods_comment = get_merchants_goods_comment($goods['user_id']); //商家所有商品评分类型汇总
|
|
$smarty->assign('merch_cmt', $merchants_goods_comment);
|
|
}
|
|
//评分 end
|
|
|
|
$smarty->assign('comment_all', $comment_all);
|
|
|
|
if($GLOBALS['_CFG']['customer_service'] == 0){
|
|
$goods['user_id'] = 0;
|
|
}
|
|
|
|
$sql="select province, city, kf_type, kf_ww, kf_qq, shop_name from ".$ecs->table('seller_shopinfo')." where ru_id='" .$goods['user_id']. "'";
|
|
$basic_info = $db->getRow($sql);
|
|
|
|
$basic_date = array('region_name');
|
|
$basic_info['province'] = get_table_date('region', "region_id = '" . $basic_info['province'] . "'", $basic_date, 2);
|
|
$basic_info['city'] = get_table_date('region', "region_id= '" . $basic_info['city'] . "'", $basic_date, 2) . "市";
|
|
|
|
$smarty->assign('basic_info', $basic_info);
|
|
|
|
$_SESSION['goods_equal'] = '';
|
|
$db->query('delete from ' . $ecs->table('cart_combo') . " WHERE (parent_id = 0 and goods_id = '$goods_id' or parent_id = '$goods_id') and " . $sess_id);
|
|
|
|
//ecmoban模板堂 --zhuo 仓库 end
|
|
|
|
if ($rank = get_rank_info())
|
|
{
|
|
$smarty->assign('rank_name', $rank['rank_name']);
|
|
}
|
|
|
|
$smarty->assign('info', get_user_default($_SESSION['user_id']));
|
|
|
|
$cart_info = insert_cart_info(1);
|
|
|
|
$smarty->assign('cart_info', $cart_info);
|
|
|
|
$goods_area = 1;
|
|
if($GLOBALS['_CFG']['open_area_goods'] == 1){
|
|
|
|
$area_list = get_goods_link_area_list($goods_id, $goods['user_id']);
|
|
if($area_list['goods_area']){
|
|
if(in_array($area_info['region_id'], $area_list['goods_area'])){
|
|
$goods_area = 1;
|
|
} else {
|
|
$goods_area = 0;
|
|
}
|
|
} else {
|
|
$goods_area = 0;
|
|
}
|
|
}
|
|
//商品运费by wu start
|
|
$region = array(1, $province_id, $city_id, $district_id);
|
|
$shippingFee = goodsShippingFee($goods_id,$region_id,$region);
|
|
$smarty->assign('shippingFee',$shippingFee);
|
|
//商品运费by wu end
|
|
|
|
$smarty->assign('goods_area', $goods_area);
|
|
$GLOBALS['smarty']->assign('shop_price_type', $goods['model_price']); //商品价格运营模式 0代表统一价格（默认） 1、代表仓库价格 2、代表地区价格
|
|
$smarty->assign('freight_model', $GLOBALS['_CFG']['freight_model']); //ecmoban模板堂 --zhuo 运费模式
|
|
$smarty->assign('one_step_buy', $GLOBALS['_CFG']['one_step_buy']); //ecmoban模板堂 --zhuo 一步购物
|
|
$smarty->assign('now_time', gmtime()); // 当前系统时间
|
|
|
|
$smarty->display('goods.dwt', $cache_id, $not);
|
|
|
|
/*------------------------------------------------------ */
|
|
//-- PRIVATE FUNCTION
|
|
/*------------------------------------------------------ */
|
|
|
|
/**
|
|
* 获得指定商品的关联商品
|
|
*
|
|
* @access public
|
|
* @param integer $goods_id
|
|
* @return array
|
|
*/
|
|
function get_linked_goods($goods_id, $warehouse_id = 0, $area_id = 0)
|
|
{
|
|
//ecmoban模板堂 --zhuo start
|
|
$where = '';
|
|
$leftJoin = '';
|
|
|
|
$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']['open_area_goods'] == 1){
|
|
$leftJoin .= " left join " .$GLOBALS['ecs']->table('link_area_goods'). " as lag on g.goods_id = lag.goods_id ";
|
|
$where .= " and lag.region_id = '$area_id' ";
|
|
}
|
|
//ecmoban模板堂 --zhuo end
|
|
|
|
$sql = 'SELECT g.goods_id, g.goods_name, g.goods_thumb, g.goods_img, 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.market_price, g.sales_volume, ' .
|
|
'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.promote_start_date, g.promote_end_date ' .
|
|
'FROM ' . $GLOBALS['ecs']->table('link_goods') . ' lg ' .
|
|
'LEFT JOIN ' . $GLOBALS['ecs']->table('goods') . ' AS g ON g.goods_id = lg.link_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]' ".
|
|
$leftJoin.
|
|
"WHERE lg.goods_id = '$goods_id' AND g.is_on_sale = 1 AND g.is_alone_sale = 1 AND g.is_delete = 0 " .
|
|
$where .
|
|
"LIMIT " . $GLOBALS['_CFG']['related_goods_number'];
|
|
$res = $GLOBALS['db']->query($sql);
|
|
|
|
$arr = array();
|
|
while ($row = $GLOBALS['db']->fetchRow($res))
|
|
{
|
|
$arr[$row['goods_id']]['goods_id'] = $row['goods_id'];
|
|
$arr[$row['goods_id']]['goods_name'] = $row['goods_name'];
|
|
$arr[$row['goods_id']]['short_name'] = $GLOBALS['_CFG']['goods_name_length'] > 0 ?
|
|
sub_str($row['goods_name'], $GLOBALS['_CFG']['goods_name_length']) : $row['goods_name'];
|
|
$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']]['market_price'] = price_format($row['market_price']);
|
|
$arr[$row['goods_id']]['shop_price'] = price_format($row['shop_price']);
|
|
$arr[$row['goods_id']]['url'] = build_uri('goods', array('gid'=>$row['goods_id']), $row['goods_name']);
|
|
$arr[$row['goods_id']]['sales_volume'] = $row['sales_volume'];
|
|
|
|
if ($row['promote_price'] > 0)
|
|
{
|
|
$promote_price = bargain_price($row['promote_price'], $row['promote_start_date'], $row['promote_end_date']);
|
|
}
|
|
else
|
|
{
|
|
$promote_price = 0;
|
|
}
|
|
|
|
$arr[$row['goods_id']]['promote_price'] = ($promote_price > 0) ? price_format($promote_price) : '';
|
|
}
|
|
|
|
return $arr;
|
|
}
|
|
|
|
/**
|
|
* 获得指定商品的关联文章
|
|
*
|
|
* @access public
|
|
* @param integer $goods_id
|
|
* @return void
|
|
*/
|
|
function get_linked_articles($goods_id)
|
|
{
|
|
$sql = 'SELECT a.article_id, a.title, a.file_url, a.open_type, a.add_time ' .
|
|
'FROM ' . $GLOBALS['ecs']->table('goods_article') . ' AS g, ' .
|
|
$GLOBALS['ecs']->table('article') . ' AS a ' .
|
|
"WHERE g.article_id = a.article_id AND g.goods_id = '$goods_id' AND a.is_open = 1 " .
|
|
'ORDER BY a.add_time DESC';
|
|
$res = $GLOBALS['db']->query($sql);
|
|
|
|
$arr = array();
|
|
while ($row = $GLOBALS['db']->fetchRow($res))
|
|
{
|
|
$row['url'] = $row['open_type'] != 1 ?
|
|
build_uri('article', array('aid'=>$row['article_id']), $row['title']) : trim($row['file_url']);
|
|
$row['add_time'] = local_date($GLOBALS['_CFG']['date_format'], $row['add_time']);
|
|
$row['short_title'] = $GLOBALS['_CFG']['article_title_length'] > 0 ?
|
|
sub_str($row['title'], $GLOBALS['_CFG']['article_title_length']) : $row['title'];
|
|
|
|
$arr[] = $row;
|
|
}
|
|
|
|
return $arr;
|
|
}
|
|
|
|
/**
|
|
* 获得指定商品的各会员等级对应的价格
|
|
*
|
|
* @access public
|
|
* @param integer $goods_id
|
|
* @return array
|
|
*/
|
|
function get_user_rank_prices($goods_id, $shop_price)
|
|
{
|
|
if(empty($shop_price)){
|
|
$shop_price = 0;
|
|
}
|
|
$sql = "SELECT rank_id, IFNULL(mp.user_price, r.discount * $shop_price / 100) AS price, r.rank_name, r.discount " .
|
|
'FROM ' . $GLOBALS['ecs']->table('user_rank') . ' AS r ' .
|
|
'LEFT JOIN ' . $GLOBALS['ecs']->table('member_price') . " AS mp ".
|
|
"ON mp.goods_id = '$goods_id' AND mp.user_rank = r.rank_id " .
|
|
"WHERE r.show_price = 1 OR r.rank_id = '$_SESSION[user_rank]'" . $tag_where;
|
|
$res = $GLOBALS['db']->query($sql);
|
|
|
|
$arr = array();
|
|
while ($row = $GLOBALS['db']->fetchRow($res))
|
|
{
|
|
|
|
$arr[$row['rank_id']] = array(
|
|
'rank_name' => htmlspecialchars($row['rank_name']),
|
|
'price' => price_format($row['price']));
|
|
}
|
|
|
|
return $arr;
|
|
}
|
|
|
|
/**
|
|
* 获得购买过该商品的人还买过的商品
|
|
*
|
|
* @access public
|
|
* @param integer $goods_id
|
|
* @return array
|
|
*/
|
|
function get_also_bought($goods_id)
|
|
{
|
|
$sql = 'SELECT COUNT(b.goods_id ) AS num, g.goods_id, g.goods_name, g.goods_thumb, g.goods_img, g.shop_price, g.promote_price, g.promote_start_date, g.promote_end_date ' .
|
|
'FROM ' . $GLOBALS['ecs']->table('order_goods') . ' AS a ' .
|
|
'LEFT JOIN ' . $GLOBALS['ecs']->table('order_goods') . ' AS b ON b.order_id = a.order_id ' .
|
|
'LEFT JOIN ' . $GLOBALS['ecs']->table('goods') . ' AS g ON g.goods_id = b.goods_id ' .
|
|
"WHERE a.goods_id = '$goods_id' AND b.goods_id <> '$goods_id' AND g.is_on_sale = 1 AND g.is_alone_sale = 1 AND g.is_delete = 0 " .
|
|
'GROUP BY b.goods_id ' .
|
|
'ORDER BY num DESC ' .
|
|
'LIMIT ' . $GLOBALS['_CFG']['bought_goods'];
|
|
$res = $GLOBALS['db']->query($sql);
|
|
|
|
$key = 0;
|
|
$arr = array();
|
|
while ($row = $GLOBALS['db']->fetchRow($res))
|
|
{
|
|
$arr[$key]['goods_id'] = $row['goods_id'];
|
|
$arr[$key]['goods_name'] = $row['goods_name'];
|
|
$arr[$key]['short_name'] = $GLOBALS['_CFG']['goods_name_length'] > 0 ?
|
|
sub_str($row['goods_name'], $GLOBALS['_CFG']['goods_name_length']) : $row['goods_name'];
|
|
$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]['shop_price'] = price_format($row['shop_price']);
|
|
$arr[$key]['url'] = build_uri('goods', array('gid'=>$row['goods_id']), $row['goods_name']);
|
|
|
|
if ($row['promote_price'] > 0)
|
|
{
|
|
$arr[$key]['promote_price'] = bargain_price($row['promote_price'], $row['promote_start_date'], $row['promote_end_date']);
|
|
$arr[$key]['formated_promote_price'] = price_format($arr[$key]['promote_price']);
|
|
}
|
|
else
|
|
{
|
|
$arr[$key]['promote_price'] = 0;
|
|
}
|
|
|
|
$key++;
|
|
}
|
|
|
|
return $arr;
|
|
}
|
|
|
|
/**
|
|
* 获得指定商品的销售排名
|
|
*
|
|
* @access public
|
|
* @param integer $goods_id
|
|
* @return integer
|
|
*/
|
|
function get_goods_rank($goods_id)
|
|
{
|
|
/* 统计时间段 */
|
|
$period = intval($GLOBALS['_CFG']['top10_time']);
|
|
if ($period == 1) // 一年
|
|
{
|
|
$ext = " AND o.add_time > '" . local_strtotime('-1 years') . "'";
|
|
}
|
|
elseif ($period == 2) // 半年
|
|
{
|
|
$ext = " AND o.add_time > '" . local_strtotime('-6 months') . "'";
|
|
}
|
|
elseif ($period == 3) // 三个月
|
|
{
|
|
$ext = " AND o.add_time > '" . local_strtotime('-3 months') . "'";
|
|
}
|
|
elseif ($period == 4) // 一个月
|
|
{
|
|
$ext = " AND o.add_time > '" . local_strtotime('-1 months') . "'";
|
|
}
|
|
else
|
|
{
|
|
$ext = '';
|
|
}
|
|
|
|
/* 查询该商品销量 */
|
|
$sql = 'SELECT IFNULL(SUM(g.goods_number), 0) ' .
|
|
'FROM ' . $GLOBALS['ecs']->table('order_info') . ' AS o, ' .
|
|
$GLOBALS['ecs']->table('order_goods') . ' AS g ' .
|
|
"WHERE o.order_id = g.order_id " .
|
|
"AND o.order_status = '" . OS_CONFIRMED . "' " .
|
|
"AND o.shipping_status " . db_create_in(array(SS_SHIPPED, SS_RECEIVED)) .
|
|
" AND o.pay_status " . db_create_in(array(PS_PAYED, PS_PAYING)) .
|
|
" AND g.goods_id = '$goods_id'" . $ext;
|
|
$sales_count = $GLOBALS['db']->getOne($sql);
|
|
|
|
if ($sales_count > 0)
|
|
{
|
|
/* 只有在商品销售量大于0时才去计算该商品的排行 */
|
|
$sql = 'SELECT DISTINCT SUM(goods_number) AS num ' .
|
|
'FROM ' . $GLOBALS['ecs']->table('order_info') . ' AS o, ' .
|
|
$GLOBALS['ecs']->table('order_goods') . ' AS g ' .
|
|
"WHERE o.order_id = g.order_id " .
|
|
"AND o.order_status = '" . OS_CONFIRMED . "' " .
|
|
"AND o.shipping_status " . db_create_in(array(SS_SHIPPED, SS_RECEIVED)) .
|
|
" AND o.pay_status " . db_create_in(array(PS_PAYED, PS_PAYING)) . $ext .
|
|
" GROUP BY g.goods_id HAVING num > $sales_count";
|
|
$res = $GLOBALS['db']->query($sql);
|
|
|
|
$rank = $GLOBALS['db']->num_rows($res) + 1;
|
|
|
|
if ($rank > 10)
|
|
{
|
|
$rank = 0;
|
|
}
|
|
}
|
|
else
|
|
{
|
|
$rank = 0;
|
|
}
|
|
|
|
return $rank;
|
|
}
|
|
|
|
/**
|
|
* 获得商品选定的属性的附加总价格
|
|
*
|
|
* @param integer $goods_id
|
|
* @param array $attr
|
|
*
|
|
* @return void
|
|
*/
|
|
function get_attr_amount($goods_id, $attr)
|
|
{
|
|
$sql = "SELECT SUM(attr_price) FROM " . $GLOBALS['ecs']->table('goods_attr') .
|
|
" WHERE goods_id='$goods_id' AND " . db_create_in($attr, 'goods_attr_id');
|
|
|
|
return $GLOBALS['db']->getOne($sql);
|
|
}
|
|
|
|
/**
|
|
* 取得跟商品关联的礼包列表
|
|
*
|
|
* @param string $goods_id 商品编号
|
|
*
|
|
* @return 礼包列表
|
|
*/
|
|
function get_package_goods_list($goods_id)
|
|
{
|
|
$now = gmtime();
|
|
$sql = "SELECT pg.goods_id, ga.act_id, ga.act_name, ga.act_desc, ga.goods_name, ga.start_time,
|
|
ga.end_time, ga.is_finished, ga.ext_info
|
|
FROM " . $GLOBALS['ecs']->table('goods_activity') . " AS ga, " . $GLOBALS['ecs']->table('package_goods') . " AS pg
|
|
WHERE pg.package_id = ga.act_id
|
|
AND ga.start_time <= '" . $now . "'
|
|
AND ga.end_time >= '" . $now . "'
|
|
AND pg.goods_id = " . $goods_id . "
|
|
GROUP BY ga.act_id
|
|
ORDER BY ga.act_id ";
|
|
$res = $GLOBALS['db']->getAll($sql);
|
|
|
|
foreach ($res as $tempkey => $value)
|
|
{
|
|
$subtotal = 0;
|
|
$row = unserialize($value['ext_info']);
|
|
unset($value['ext_info']);
|
|
if ($row)
|
|
{
|
|
foreach ($row as $key=>$val)
|
|
{
|
|
$res[$tempkey][$key] = $val;
|
|
}
|
|
}
|
|
|
|
$sql = "SELECT pg.package_id, pg.goods_id, pg.goods_number, pg.admin_id, p.goods_attr, g.goods_sn, g.goods_name, g.market_price, g.goods_thumb, IFNULL(mp.user_price, g.shop_price * '$_SESSION[discount]') AS rank_price
|
|
FROM " . $GLOBALS['ecs']->table('package_goods') . " AS pg
|
|
LEFT JOIN ". $GLOBALS['ecs']->table('goods') . " AS g
|
|
ON g.goods_id = pg.goods_id
|
|
LEFT JOIN ". $GLOBALS['ecs']->table('products') . " AS p
|
|
ON p.product_id = pg.product_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 pg.package_id = " . $value['act_id']. "
|
|
ORDER BY pg.package_id, pg.goods_id";
|
|
|
|
$goods_res = $GLOBALS['db']->getAll($sql);
|
|
|
|
foreach($goods_res as $key => $val)
|
|
{
|
|
$goods_id_array[] = $val['goods_id'];
|
|
$goods_res[$key]['goods_thumb'] = get_image_path($val['goods_id'], $val['goods_thumb'], true);
|
|
$goods_res[$key]['market_price'] = price_format($val['market_price']);
|
|
$goods_res[$key]['rank_price'] = price_format($val['rank_price']);
|
|
$subtotal += $val['rank_price'] * $val['goods_number'];
|
|
}
|
|
|
|
/* 取商品属性 */
|
|
$sql = "SELECT ga.goods_attr_id, ga.attr_value
|
|
FROM " .$GLOBALS['ecs']->table('goods_attr'). " AS ga, " .$GLOBALS['ecs']->table('attribute'). " AS a
|
|
WHERE a.attr_id = ga.attr_id
|
|
AND a.attr_type = 1
|
|
AND " . db_create_in($goods_id_array, 'goods_id');
|
|
$result_goods_attr = $GLOBALS['db']->getAll($sql);
|
|
|
|
$_goods_attr = array();
|
|
foreach ($result_goods_attr as $value)
|
|
{
|
|
$_goods_attr[$value['goods_attr_id']] = $value['attr_value'];
|
|
}
|
|
|
|
/* 处理货品 */
|
|
$format = '[%s]';
|
|
foreach($goods_res as $key => $val)
|
|
{
|
|
if ($val['goods_attr'] != '')
|
|
{
|
|
$goods_attr_array = explode('|', $val['goods_attr']);
|
|
|
|
$goods_attr = array();
|
|
foreach ($goods_attr_array as $_attr)
|
|
{
|
|
$goods_attr[] = $_goods_attr[$_attr];
|
|
}
|
|
|
|
$goods_res[$key]['goods_attr_str'] = sprintf($format, implode('，', $goods_attr));
|
|
}
|
|
}
|
|
|
|
$res[$tempkey]['goods_list'] = $goods_res;
|
|
$res[$tempkey]['subtotal'] = price_format($subtotal);
|
|
$res[$tempkey]['saving'] = price_format(($subtotal - $res[$tempkey]['package_price']));
|
|
$res[$tempkey]['package_price'] = price_format($res[$tempkey]['package_price']);
|
|
}
|
|
|
|
return $res;
|
|
}
|
|
?>
|