package包php,package.php

/**

* 超值礼包列表

* ============================================================================

；

* ============================================================================

* $Author: liubo $

* $Id: activity.php 16056 2009-05-21 05:44:14Z 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_once(ROOT_PATH . 'languages/' .$_CFG['lang']. '/shopping_flow.php');

require_once(ROOT_PATH . 'languages/' .$_CFG['lang']. '/user.php');

require_once(ROOT_PATH . 'languages/' .$_CFG['lang']. '/admin/package.php');

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

//-- PROCESSOR

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

assign_template();

assign_dynamic('package');

$position = assign_ur_here(0, $_LANG['shopping_package']);

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

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

/* 读出所有礼包信息 */

$now = gmtime();

$sql = "SELECT * FROM " . $ecs->table('goods_activity'). " WHERE `start_time` <= '$now' AND `end_time` >= '$now' AND `act_type` = '4' ORDER BY `end_time`";

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

$ext_arr = unserialize($row['ext_info']);

unset($row['ext_info']);

if ($ext_arr)

{

foreach ($ext_arr as $key=>$val)

{

$row[$key] = $val;

}

}

$sql = "SELECT pg.package_id, pg.goods_id, pg.goods_number, pg.admin_id, ".

" g.goods_sn, g.goods_name, g.shop_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('member_price') . " AS mp ".

"ON mp.goods_id = g.goods_id AND mp.user_rank = '$_SESSION[user_rank]' ".

" WHERE pg.package_id = " . $row['act_id']. " ".

/* 代码增加 By www.68ecshop.com Start */

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

/* 代码增加 By www.68ecshop.com End */

" ORDER BY pg.goods_id";

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

$subtotal = 0;

foreach($goods_res as $key => $val)

{

$goods_res[$key]['goods_thumb'] = get_image_path($val['goods_id'], $val['goods_thumb'], true);

$goods_res[$key]['shop_price'] = price_format($val['shop_price']);

$goods_res[$key]['rank_price'] = price_format($val['rank_price']);

$subtotal += $val['rank_price'] * $val['goods_number'];

}

$row['goods_list'] = $goods_res;

$row['goods_list_count'] = count($row['goods_list']);

$row['subtotal'] = price_format($subtotal);

$row['saving'] = price_format(($subtotal - $row['package_price']));

$row['package_price'] = price_format($row['package_price']);

$list[] = $row;

}

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

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

$smarty->assign('lang', $_LANG);

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

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

一键复制

编辑

Web IDE

原始数据

按行查看

历史