www.gusucode.com > ecShop PHP网上商城系统 粉丝修复版 v2.7.3源码程序 > ecshop_xf_v2.7.3/wholesale.php
<?php
/**
* ECSHOP 批发前台文件
* ============================================================================
* 版权所有 2005-2010 上海商派网络科技有限公司，并保留所有权利。
* 网站地址: http://www.ecshop.com；
* ----------------------------------------------------------------------------
* 这不是一个自由软件！您只能在不用于商业目的的前提下对程序代码进行修改和
* 使用；不允许对程序代码以任何形式任何目的的再发布。
* ============================================================================
* @author: scott ye <scott.yell@gmail.com>
* @version: v2.x
* ---------------------------------------------
* $Author: yehuaixiao $
* $Id: wholesale.php 17218 2011-01-24 04:10:41Z yehuaixiao $
*/
define('IN_ECS', true);
require(dirname(__FILE__) . '/includes/init.php');
/* 如果没登录，提示登录 */
if ($_SESSION['user_rank'] <= 0)
{
show_message($_LANG['ws_user_rank'], $_LANG['ws_return_home'], 'index.php');
}
/*------------------------------------------------------ */
//-- act 操作项的初始化
/*------------------------------------------------------ */
if (empty($_REQUEST['act']))
{
$_REQUEST['act'] = 'list';
}
/*------------------------------------------------------ */
//-- 批发活动列表
/*------------------------------------------------------ */
if ($_REQUEST['act'] == 'list')
{
$search_category = empty($_REQUEST['search_category']) ? 0 : intval($_REQUEST['search_category']);
$search_keywords = isset($_REQUEST['search_keywords']) ? trim($_REQUEST['search_keywords']) : '';
$param = array(); // 翻页链接所带参数列表
/* 查询条件：当前用户的会员等级（搜索关键字） */
$where = " WHERE g.goods_id = w.goods_id
AND w.enabled = 1
AND CONCAT(',', w.rank_ids, ',') LIKE '" . '%,' . $_SESSION['user_rank'] . ',%' . "' ";
/* 搜索 */
/* 搜索类别 */
if ($search_category)
{
$where .= " AND g.cat_id = '$search_category' ";
$param['search_category'] = $search_category;
$smarty->assign('search_category', $search_category);
}
/* 搜索商品名称和关键字 */
if ($search_keywords)
{
$where .= " AND (g.keywords LIKE '%$search_keywords%'
OR g.goods_name LIKE '%$search_keywords%') ";
$param['search_keywords'] = $search_keywords;
$smarty->assign('search_keywords', $search_keywords);
}
/* 取得批发商品总数 */
$sql = "SELECT COUNT(*) FROM " . $ecs->table('wholesale') . " AS w, " . $ecs->table('goods') . " AS g " . $where;
$count = $db->getOne($sql);
if ($count > 0)
{
$default_display_type = $_CFG['show_order_type'] == '0' ? 'list' : 'text';
$display = (isset($_REQUEST['display']) && in_array(trim(strtolower($_REQUEST['display'])), array('list', 'text'))) ? trim($_REQUEST['display']) : (isset($_COOKIE['ECS']['display']) ? $_COOKIE['ECS']['display'] : $default_display_type);
$display = in_array($display, array('list', 'text')) ? $display : 'text';
setcookie('ECS[display]', $display, gmtime() + 86400 * 7);
/* 取得每页记录数 */
$size = isset($_CFG['page_size']) && intval($_CFG['page_size']) > 0 ? intval($_CFG['page_size']) : 10;
/* 计算总页数 */
$page_count = ceil($count / $size);
/* 取得当前页 */
$page = isset($_REQUEST['page']) && intval($_REQUEST['page']) > 0 ? intval($_REQUEST['page']) : 1;
$page = $page > $page_count ? $page_count : $page;
/* 取得当前页的批发商品 */
$wholesale_list = wholesale_list($size, $page, $where);
$smarty->assign('wholesale_list', $wholesale_list);
$param['act'] = 'list';
$pager = get_pager('wholesale.php', array_reverse ($param, TRUE), $count, $page, $size);
$pager['display'] = $display;
$smarty->assign('pager', $pager);
/* 批发商品购物车 */
$smarty->assign('cart_goods', isset($_SESSION['wholesale_goods']) ? $_SESSION['wholesale_goods'] : array());
}
/* 模板赋值 */
assign_template();
$position = assign_ur_here();
$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('top_goods', get_top10()); // 销售排行
assign_dynamic('wholesale');
/* 显示模板 */
$smarty->display('wholesale_list.dwt');
}
/*------------------------------------------------------ */
//-- 下载价格单
/*------------------------------------------------------ */
elseif ($_REQUEST['act'] == 'price_list')
{
$data = $_LANG['goods_name'] . "\t" . $_LANG['goods_attr'] . "\t" . $_LANG['number'] . "\t" . $_LANG['ws_price'] . "\t\n";
$sql = "SELECT * FROM " . $ecs->table('wholesale') .
"WHERE enabled = 1 AND CONCAT(',', rank_ids, ',') LIKE '" . '%,' . $_SESSION['user_rank'] . ',%' . "'";
$res = $db->query($sql);
while ($row = $db->fetchRow($res))
{
$price_list = unserialize($row['prices']);
foreach ($price_list as $attr_price)
{
if ($attr_price['attr'])
{
$sql = "SELECT attr_value FROM " . $ecs->table('goods_attr') .
" WHERE goods_attr_id " . db_create_in($attr_price['attr']);
$goods_attr = join(',', $db->getCol($sql));
}
else
{
$goods_attr = '';
}
foreach ($attr_price['qp_list'] as $qp)
{
$data .= $row['goods_name'] . "\t" . $goods_attr . "\t" . $qp['quantity'] . "\t" . $qp['price'] . "\t\n";
}
}
}
header("Content-type: application/vnd.ms-excel; charset=utf-8");
header("Content-Disposition: attachment; filename=price_list.xls");
if (EC_CHARSET == 'utf-8')
{
echo ecs_iconv('UTF8', 'GB2312', $data);
}
else
{
echo $data;
}
}
/*------------------------------------------------------ */
//-- 加入购物车
/*------------------------------------------------------ */
elseif ($_REQUEST['act'] == 'add_to_cart')
{
/* 取得参数 */
$act_id = intval($_POST['act_id']);
$goods_number = $_POST['goods_number'][$act_id];
$attr_id = isset($_POST['attr_id']) ? $_POST['attr_id'] : array();
if(isset($attr_id[$act_id]))
{
$goods_attr = $attr_id[$act_id];
}
/* 用户提交必须全部通过检查，才能视为完成操作 */
/* 检查数量 */
if (empty($goods_number) || (is_array($goods_number) && array_sum($goods_number) <= 0))
{
show_message($_LANG['ws_invalid_goods_number']);
}
/* 确定购买商品列表 */
$goods_list = array();
if (is_array($goods_number))
{
foreach ($goods_number as $key => $value)
{
if (!$value)
{
unset($goods_number[$key], $goods_attr[$key]);
continue;
}
$goods_list[] = array('number' => $goods_number[$key], 'goods_attr' => $goods_attr[$key]);
}
}
else
{
$goods_list[0] = array('number' => $goods_number, 'goods_attr' => '');
}
/* 取批发相关数据 */
$wholesale = wholesale_info($act_id);
/* 检查session中该商品，该属性是否存在 */
if (isset($_SESSION['wholesale_goods']))
{
foreach ($_SESSION['wholesale_goods'] as $goods)
{
if ($goods['goods_id'] == $wholesale['goods_id'])
{
if (empty($goods_attr))
{
show_message($_LANG['ws_goods_attr_exists']);
}
elseif (in_array($goods['goods_attr_id'], $goods_attr))
{
show_message($_LANG['ws_goods_attr_exists']);
}
}
}
}
/* 获取购买商品的批发方案的价格阶梯 （一个方案多个属性组合、一个属性组合、一个属性、无属性） */
$attr_matching = false;
foreach ($wholesale['price_list'] as $attr_price)
{
// 没有属性
if (empty($attr_price['attr']))
{
$attr_matching = true;
$goods_list[0]['qp_list'] = $attr_price['qp_list'];
break;
}
// 有属性
elseif (($key = is_attr_matching($goods_list, $attr_price['attr'])) !== false)
{
$attr_matching = true;
$goods_list[$key]['qp_list'] = $attr_price['qp_list'];
}
}
if (!$attr_matching)
{
show_message($_LANG['ws_attr_not_matching']);
}
/* 检查数量是否达到最低要求 */
foreach ($goods_list as $goods_key => $goods)
{
if ($goods['number'] < $goods['qp_list'][0]['quantity'])
{
show_message($_LANG['ws_goods_number_not_enough']);
}
else
{
$goods_price = 0;
foreach ($goods['qp_list'] as $qp)
{
if ($goods['number'] >= $qp['quantity'])
{
$goods_list[$goods_key]['goods_price'] = $qp['price'];
}
else
{
break;
}
}
}
}
/* 写入session */
foreach ($goods_list as $goods_key => $goods)
{
// 属性名称
$goods_attr_name = '';
if (!empty($goods['goods_attr']))
{
foreach ($goods['goods_attr'] as $key=> $attr)
{
$attr['attr_name']=htmlspecialchars($attr['attr_name']);
$goods['goods_attr'][$key]['attr_name']=$attr['attr_name'];
$attr['attr_val'] =htmlspecialchars($attr['attr_val']);
$goods['goods_attr'][$key]['attr_name']=$attr['attr_name'];
$goods_attr_name .= $attr['attr_name'] . '：' . $attr['attr_val'] . ' ';
}
}
// 总价
$total = $goods['number'] * $goods['goods_price'];
$_SESSION['wholesale_goods'][] = array(
'goods_id' => $wholesale['goods_id'],
'goods_name' => $wholesale['goods_name'],
'goods_attr_id' => $goods['goods_attr'],
'goods_attr' => $goods_attr_name,
'goods_number' => $goods['number'],
'goods_price' => $goods['goods_price'],
'subtotal' => $total,
'formated_goods_price' => price_format($goods['goods_price'], false),
'formated_subtotal' => price_format($total, false),
'goods_url' => build_uri('goods', array('gid' => $wholesale['goods_id']), $wholesale['goods_name']),
);
}
unset($goods_attr, $attr_id, $goods_list, $wholesale, $goods_attr_name);
/* 刷新页面 */
ecs_header("Location: ./wholesale.php\n");
exit;
}
/*------------------------------------------------------ */
//-- 从购物车删除
/*------------------------------------------------------ */
elseif ($_REQUEST['act'] == 'drop_goods')
{
$key = intval($_REQUEST['key']);
if (isset($_SESSION['wholesale_goods'][$key]))
{
unset($_SESSION['wholesale_goods'][$key]);
}
/* 刷新页面 */
ecs_header("Location: ./wholesale.php\n");
exit;
}
/*------------------------------------------------------ */
//-- 提交订单
/*------------------------------------------------------ */
elseif ($_REQUEST['act'] == 'submit_order')
{
include_once(ROOT_PATH . 'includes/lib_order.php');
/* 检查购物车中是否有商品 */
if (count($_SESSION['wholesale_goods']) == 0)
{
show_message($_LANG['no_goods_in_cart']);
}
/* 检查备注信息 */
if (empty($_POST['remark']))
{
show_message($_LANG['ws_remark']);
}
/* 计算商品总额 */
$goods_amount = 0;
foreach ($_SESSION['wholesale_goods'] as $goods)
{
$goods_amount += $goods['subtotal'];
}
$order = array(
'postscript' => htmlspecialchars($_POST['remark']),
'user_id' => $_SESSION['user_id'],
'add_time' => gmtime(),
'order_status' => OS_UNCONFIRMED,
'shipping_status' => SS_UNSHIPPED,
'pay_status' => PS_UNPAYED,
'goods_amount' => $goods_amount,
'order_amount' => $goods_amount,
);
/* 插入订单表 */
$error_no = 0;
do
{
$order['order_sn'] = get_order_sn(); //获取新订单号
$GLOBALS['db']->autoExecute($GLOBALS['ecs']->table('order_info'), $order, 'INSERT');
$error_no = $GLOBALS['db']->errno();
if ($error_no > 0 && $error_no != 1062)
{
die($GLOBALS['db']->errorMsg());
}
}
while ($error_no == 1062); //如果是订单号重复则重新提交数据
$new_order_id = $db->insert_id();
$order['order_id'] = $new_order_id;
/* 插入订单商品 */
foreach ($_SESSION['wholesale_goods'] as $goods)
{
//如果存在货品
$product_id = 0;
if (!empty($goods['goods_attr_id']))
{
$goods_attr_id = array();
foreach ($goods['goods_attr_id'] as $value)
{
$goods_attr_id[$value['attr_id']] = $value['attr_val_id'];
}
ksort($goods_attr_id);
$goods_attr = implode('|', $goods_attr_id);
$sql = "SELECT product_id FROM " . $ecs->table('products') . " WHERE goods_attr = '$goods_attr' AND goods_id = '" . $goods['goods_id'] . "'";
$product_id = $db->getOne($sql);
}
$sql = "INSERT INTO " . $ecs->table('order_goods') . "( " .
"order_id, goods_id, goods_name, goods_sn, product_id, goods_number, market_price, ".
"goods_price, goods_attr, is_real, extension_code, parent_id, is_gift) ".
" SELECT '$new_order_id', goods_id, goods_name, goods_sn, '$product_id','$goods[goods_number]', market_price, ".
"'$goods[goods_price]', '$goods[goods_attr]', is_real, extension_code, 0, 0 ".
" FROM " .$ecs->table('goods') .
" WHERE goods_id = '$goods[goods_id]'";
$db->query($sql);
}
/* 给商家发邮件 */
if ($_CFG['service_email'] != '')
{
$tpl = get_mail_template('remind_of_new_order');
$smarty->assign('order', $order);
$smarty->assign('shop_name', $_CFG['shop_name']);
$smarty->assign('send_date', date($_CFG['time_format']));
$content = $smarty->fetch('str:' . $tpl['template_content']);
send_mail($_CFG['shop_name'], $_CFG['service_email'], $tpl['template_subject'], $content, $tpl['is_html']);
}
/* 如果需要，发短信 */
if ($_CFG['sms_order_placed'] == '1' && $_CFG['sms_shop_mobile'] != '')
{
include_once('includes/cls_sms.php');
$sms = new sms();
$msg = $_LANG['order_placed_sms'];
$sms->send($_CFG['sms_shop_mobile'], sprintf($msg, $order['consignee'], $order['tel']),'', 13,1);
}
/* 清空购物车 */
unset($_SESSION['wholesale_goods']);
/* 提示 */
show_message(sprintf($_LANG['ws_order_submitted'], $order['order_sn']), $_LANG['ws_return_home'], 'index.php');
}
/**
* 取得某页的批发商品
* @param int $size 每页记录数
* @param int $page 当前页
* @param string $where 查询条件
* @return array
*/
function wholesale_list($size, $page, $where)
{
$list = array();
$sql = "SELECT w.*, g.goods_thumb, g.goods_name as goods_name " .
"FROM " . $GLOBALS['ecs']->table('wholesale') . " AS w, " .
$GLOBALS['ecs']->table('goods') . " AS g " . $where .
" AND w.goods_id = g.goods_id ";
$res = $GLOBALS['db']->selectLimit($sql, $size, ($page - 1) * $size);
while ($row = $GLOBALS['db']->fetchRow($res))
{
if (empty($row['goods_thumb']))
{
$row['goods_thumb'] = $GLOBALS['_CFG']['no_picture'];
}
$row['goods_url'] = build_uri('goods', array('gid'=>$row['goods_id']), $row['goods_name']);
$properties = get_goods_properties($row['goods_id']);
$row['goods_attr'] = $properties['pro'];
$price_ladder = get_price_ladder($row['goods_id']);
$row['price_ladder'] = $price_ladder;
$list[] = $row;
}
return $list;
}
/**
* 商品价格阶梯
* @param int $goods_id 商品ID
* @return array
*/
function get_price_ladder($goods_id)
{
/* 显示商品规格 */
$goods_attr_list = array_values(get_goods_attr($goods_id));
$sql = "SELECT prices FROM " . $GLOBALS['ecs']->table('wholesale') .
"WHERE goods_id = " . $goods_id;
$row = $GLOBALS['db']->getRow($sql);
$arr = array();
$_arr = unserialize($row['prices']);
if (is_array($_arr))
{
foreach(unserialize($row['prices']) as $key => $val)
{
// 显示属性
if (!empty($val['attr']))
{
foreach ($val['attr'] as $attr_key => $attr_val)
{
// 获取当前属性 $attr_key 的信息
$goods_attr = array();
foreach ($goods_attr_list as $goods_attr_val)
{
if ($goods_attr_val['attr_id'] == $attr_key)
{
$goods_attr = $goods_attr_val;
break;
}
}
// 重写商品规格的价格阶梯信息
if (!empty($goods_attr))
{
$arr[$key]['attr'][] = array(
'attr_id' => $goods_attr['attr_id'],
'attr_name' => $goods_attr['attr_name'],
'attr_val' => (isset($goods_attr['goods_attr_list'][$attr_val]) ? $goods_attr['goods_attr_list'][$attr_val] : ''),
'attr_val_id' => $attr_val
);
}
}
}
// 显示数量与价格
foreach($val['qp_list'] as $index => $qp)
{
$arr[$key]['qp_list'][$qp['quantity']] = price_format($qp['price']);
}
}
}
return $arr;
}
/**
* 商品属性是否匹配
* @param array $goods_list 用户选择的商品
* @param array $reference 参照的商品属性
* @return bool
*/
function is_attr_matching(&$goods_list, $reference)
{
foreach ($goods_list as $key => $goods)
{
// 需要相同的元素个数
if (count($goods['goods_attr']) != count($reference))
{
break;
}
// 判断用户提交与批发属性是否相同
$is_check = true;
if (is_array($goods['goods_attr']))
{
foreach ($goods['goods_attr'] as $attr)
{
if (!(array_key_exists($attr['attr_id'], $reference) && $attr['attr_val_id'] == $reference[$attr['attr_id']]))
{
$is_check = false;
break;
}
}
}
if ($is_check)
{
return $key;
break;
}
}
// foreach ($goods_attr as $attr_id => $goods_attr_id)
// {
// if (isset($reference[$attr_id]) && $reference[$attr_id] != 0 && $reference[$attr_id] != $goods_attr_id)
// {
// return false;
// }
// }
return false;
}
///**
// * 购物车中的商品属性与当前购买的商品属性是否匹配
// * @param array $goods_attr 用户选择的商品属性
// * @param array $reference 参照的商品属性
// * @return bool
// */
//function is_attr_same($goods_attr, $reference)
//{
// /* 比较元素个数是否相同 */
// if (count($goods_attr) == count($reference)) {
// }
//
// return true;
//}
?>