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.
243 lines
9.3 KiB
243 lines
9.3 KiB
<?php
|
|
|
|
/**
|
|
* ECSHOP 活动列表
|
|
* ============================================================================
|
|
* * 版权所有 2005-2016 上海商创网络科技有限公司，并保留所有权利。
|
|
* 网站地址: http://www.ecmoban.com；
|
|
* ----------------------------------------------------------------------------
|
|
* 这不是一个自由软件！您只能在不用于商业目的的前提下对程序代码进行修改和
|
|
* 使用；不允许对程序代码以任何形式任何目的的再发布。
|
|
* ============================================================================
|
|
* $Author: liubo $
|
|
* $Id: activity.php 17217 2011-01-19 06:29:08Z liubo $
|
|
*/
|
|
|
|
define('IN_ECS', true);
|
|
|
|
require(dirname(__FILE__) . '/includes/init.php');
|
|
require_once(ROOT_PATH . 'includes/lib_order.php');
|
|
include_once(ROOT_PATH . 'includes/lib_transaction.php');
|
|
|
|
require(ROOT_PATH . '/includes/lib_area.php'); //ecmoban模板堂 --zhuo
|
|
|
|
/* 载入语言文件 */
|
|
require_once(ROOT_PATH . 'languages/' .$_CFG['lang']. '/shopping_flow.php');
|
|
require_once(ROOT_PATH . 'languages/' .$_CFG['lang']. '/user.php');
|
|
|
|
//判断是否有ajax请求
|
|
include('includes/cls_json.php');
|
|
$json = new JSON;
|
|
$result = array('err_msg' => '', 'err_no' => 0, 'content' => '');
|
|
|
|
//分类树
|
|
if(isset($_REQUEST['act'])){
|
|
if($_REQUEST['act'] == 'rang_gift_list'){ //赠品商品列表
|
|
|
|
$act_id = !empty($_REQUEST['act_id']) ? intval($_REQUEST['act_id']) : 0;
|
|
$type = isset($_REQUEST['type']) ? intval($_REQUEST['type']) : 0;
|
|
$idname = isset($_REQUEST['idname']) ? htmlspecialchars(trim($_REQUEST['idname'])) : 0;
|
|
|
|
$range_gift_list = get_range_gift_list($act_id, $type);
|
|
|
|
$smarty->assign('type', $type);
|
|
$smarty->assign('range_gift_list', $range_gift_list);
|
|
$result['content'] = $smarty->fetch("library/range_gift_list.lbi");
|
|
$result['act_id'] = $act_id;
|
|
$result['idname'] = $idname;
|
|
$result['type'] = $type;
|
|
|
|
if($type == 1){
|
|
$result['name'] = 'range';
|
|
}else{
|
|
$result['name'] = 'gift';
|
|
}
|
|
die($json->encode($result));
|
|
}
|
|
}
|
|
|
|
/*------------------------------------------------------ */
|
|
//-- PROCESSOR
|
|
/*------------------------------------------------------ */
|
|
|
|
assign_template();
|
|
assign_dynamic('activity');
|
|
$position = assign_ur_here();
|
|
//print_arr($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); // 分类树加强版
|
|
|
|
// 数据准备
|
|
|
|
/* 取得用户等级 */
|
|
$user_rank_list = array();
|
|
$user_rank_list[0] = $_LANG['not_user'];
|
|
$sql = "SELECT rank_id, rank_name FROM " . $ecs->table('user_rank');
|
|
$res = $db->query($sql);
|
|
while ($row = $db->fetchRow($res))
|
|
{
|
|
$user_rank_list[$row['rank_id']] = $row['rank_name'];
|
|
}
|
|
|
|
|
|
// 开始工作
|
|
|
|
$sql = "SELECT * FROM " . $ecs->table('favourable_activity'). " ORDER BY `sort_order` ASC,`end_time` DESC";
|
|
$res = $db->query($sql);
|
|
|
|
$list = array();
|
|
while ($row = $db->fetchRow($res))
|
|
{
|
|
$row['start_time'] = local_date('Y-m-d H:i', $row['start_time']);
|
|
$row['end_time'] = local_date('Y-m-d H:i', $row['end_time']);
|
|
|
|
//OSS文件存储ecmoban模板堂 --zhuo start
|
|
if($GLOBALS['_CFG']['open_oss'] == 1 && $row['activity_thumb']){
|
|
$bucket_info = get_bucket_info();
|
|
$row['activity_thumb'] = $bucket_info['endpoint'] . $row['activity_thumb'];
|
|
}
|
|
//OSS文件存储ecmoban模板堂 --zhuo end
|
|
|
|
//享受优惠会员等级
|
|
$user_rank = explode(',', $row['user_rank']);
|
|
$row['user_rank'] = array();
|
|
foreach($user_rank as $val)
|
|
{
|
|
if (isset($user_rank_list[$val]))
|
|
{
|
|
$row['user_rank'][] = $user_rank_list[$val];
|
|
}
|
|
}
|
|
|
|
if($row['userFav_type']){
|
|
$row['shop_name'] = '全场通用'; //商家名称
|
|
}else{
|
|
$row['shop_name'] = get_shop_name($row['user_id'], 1); //店铺名称;
|
|
$row['shop_url'] = build_uri('merchants_store', array('urid'=>$row['user_id']), $row['shop_name']);
|
|
}
|
|
|
|
$row['act_range_type'] = $row['act_range']; //优惠范围
|
|
|
|
//优惠范围类型、内容
|
|
if ($row['act_range'] != FAR_ALL && !empty($row['act_range_ext']))
|
|
{
|
|
if ($row['act_range'] == FAR_CATEGORY)
|
|
{
|
|
$row['act_range'] = $_LANG['far_category'];
|
|
$row['program'] = 'category.php?id=';
|
|
$sql = "SELECT cat_id AS id, cat_name AS name FROM " . $ecs->table('category') .
|
|
" WHERE cat_id " . db_create_in($row['act_range_ext']);
|
|
}
|
|
elseif ($row['act_range'] == FAR_BRAND)
|
|
{
|
|
$lj_brand = '';
|
|
$lj_where = '';
|
|
if($row['user_id'] > 0){
|
|
$lj_brand = ", " . $ecs->table('merchants_shop_brand') ." AS msb, " .$ecs->table('link_brand') ." AS lb ";
|
|
$lj_where = "b.brand_id = lb.brand_id AND msb.bid = lb.bid AND msb.user_id = '" .$row['user_id']. "' AND msb.bid " . db_create_in($row['act_range_ext']);
|
|
}else{
|
|
$lj_where = "b.brand_id " . db_create_in($row['act_range_ext']);
|
|
}
|
|
|
|
$row['act_range'] = $_LANG['far_brand'];
|
|
$row['program'] = 'brand.php?id=';
|
|
$sql = "SELECT b.brand_id AS id, b.brand_name AS name FROM " . $ecs->table('brand') ." AS b " .$lj_brand.
|
|
" WHERE " . $lj_where;
|
|
}
|
|
else
|
|
{
|
|
$row['act_range'] = $_LANG['far_goods'];
|
|
$row['program'] = 'goods.php?id=';
|
|
$sql = "SELECT goods_id AS id, goods_name AS name FROM " . $ecs->table('goods') .
|
|
" WHERE goods_id " . db_create_in($row['act_range_ext']);
|
|
}
|
|
$act_range_ext = $db->getAll($sql);
|
|
$row['act_range_ext'] = $act_range_ext;
|
|
}
|
|
else
|
|
{
|
|
$row['act_range'] = $_LANG['far_all'];
|
|
}
|
|
|
|
//优惠方式
|
|
$row['actType'] = $row['act_type']; //优惠方式
|
|
|
|
switch($row['act_type'])
|
|
{
|
|
case 0:
|
|
$row['act_type'] = $_LANG['fat_goods'];
|
|
$row['gift'] = unserialize($row['gift']);
|
|
if(is_array($row['gift']))
|
|
{
|
|
foreach($row['gift'] as $k=>$v)
|
|
{
|
|
$row['gift'][$k]['thumb'] = get_image_path($v['id'], $db->getOne("SELECT goods_thumb FROM " . $ecs->table('goods') . " WHERE goods_id = '" . $v['id'] . "'"), true);
|
|
}
|
|
}
|
|
break;
|
|
case 1:
|
|
$row['act_type'] = $_LANG['fat_price'];
|
|
$row['act_type_ext'] .= $_LANG['unit_yuan'];
|
|
$row['gift'] = array();
|
|
break;
|
|
case 2:
|
|
$row['act_type'] = $_LANG['fat_discount'];
|
|
$row['act_type_ext'] .= "%";
|
|
$row['gift'] = array();
|
|
break;
|
|
}
|
|
|
|
$list[$row['actType']]['activity_name'] = $row['act_type'];
|
|
$list[$row['actType']]['activity_list'][] = $row;
|
|
}
|
|
|
|
$list = get_cache_site_file('activity', $list);
|
|
ksort($list);
|
|
|
|
//get_print_r($list);
|
|
|
|
$smarty->assign('activity_list', $list);
|
|
|
|
$smarty->assign('helps', get_shop_help()); // 网店帮助
|
|
|
|
$smarty->assign('lang', $_LANG);
|
|
|
|
$smarty->assign('feed_url', ($_CFG['rewrite'] == 1) ? "feed-typeactivity.xml" : 'feed.php?type=activity'); // RSS URL
|
|
$smarty->display('activity.dwt');
|
|
|
|
|
|
function get_range_gift_list($act_id, $type){
|
|
$sql = "SELECT act_range_ext, gift FROM " .$GLOBALS['ecs']->table('favourable_activity'). " WHERE act_id = '$act_id'";
|
|
$row = $GLOBALS['db']->getRow($sql);
|
|
|
|
$arr = array();
|
|
if($type == 1){ //赠品商品列表
|
|
$row['gift'] = unserialize($row['gift']);
|
|
if(is_array($row['gift']))
|
|
{
|
|
foreach($row['gift'] as $k=>$v)
|
|
{
|
|
$goods = $GLOBALS['db']->getRow("SELECT goods_thumb, market_price FROM " . $GLOBALS['ecs']->table('goods') . " WHERE goods_id = '" . $v['id'] . "'");
|
|
$arr[$k]['thumb'] = get_image_path($v['id'], $goods['goods_thumb'], true);
|
|
$arr[$k]['url'] = build_uri('goods', array('gid'=>$v['id']), $v['name']);
|
|
$arr[$k]['market_price'] = price_format($goods['market_price']);
|
|
$arr[$k]['price'] = price_format($v['price']);
|
|
$arr[$k]['name'] = $v['name'];
|
|
}
|
|
}
|
|
}elseif($type == 0){ //优惠方式
|
|
$sql = "SELECT goods_id AS id, goods_name AS name, goods_thumb FROM " . $GLOBALS['ecs']->table('goods') . " WHERE goods_id " . db_create_in($row['act_range_ext']);
|
|
$res = $GLOBALS['db']->getAll($sql);
|
|
|
|
foreach($res as $k=>$v){
|
|
$arr[$k] = $v;
|
|
$arr[$k]['thumb'] = get_image_path($v['id'], $GLOBALS['db']->getOne("SELECT goods_thumb FROM " . $GLOBALS['ecs']->table('goods') . " WHERE goods_id = '" . $v['id'] . "'"), true);
|
|
$arr[$k]['url'] = build_uri('goods', array('gid'=>$v['id']), $v['name']);
|
|
}
|
|
}
|
|
|
|
return $arr;
|
|
}
|