/**
* 取得订单应该发放的红包
* @param int $order_id 订单id
* @return array
*/
function order_bonus($order_id)
{
/* 查询按商品发的红包 */
$day = getdate();
$today = local_mktime(23, 59, 59, $day['mon'], $day['mday'], $day['year']);
$sql = "SELECT b.type_id, b.type_money, SUM(o.goods_number) AS number " . "FROM " . $GLOBALS['ecs']->table('order_goods') . " AS o, " . $GLOBALS['ecs']->table('goods') . " AS g, " . $GLOBALS['ecs']->table('bonus_type') . " AS b " . " WHERE o.order_id = '{$order_id}' " . " AND o.is_gift = 0 " . " AND o.goods_id = g.goods_id " . " AND g.bonus_type_id = b.type_id " . " AND b.send_type = '" . SEND_BY_GOODS . "' " . " AND b.send_start_date <= '{$today}' " . " AND b.send_end_date >= '{$today}' " . " GROUP BY b.type_id ";
$list = $GLOBALS['db']->getAll($sql);
/* 查询定单中非赠品总金额 */
$amount = order_amount($order_id, false);
/* 查询订单日期 */
$sql = "SELECT add_time " . " FROM " . $GLOBALS['ecs']->table('order_info') . " WHERE order_id = '{$order_id}' LIMIT 1";
$order_time = $GLOBALS['db']->getOne($sql);
/* 查询按订单发的红包 */
$sql = "SELECT type_id, type_money, IFNULL(FLOOR('{$amount}' / min_amount), 1) AS number " . "FROM " . $GLOBALS['ecs']->table('bonus_type') . "WHERE send_type = '" . SEND_BY_ORDER . "' " . "AND send_start_date <= '{$order_time}' " . "AND send_end_date >= '{$order_time}' ";
$list = array_merge($list, $GLOBALS['db']->getAll($sql));
return $list;
}
/**
*
* @access public
* @param int $user_id 用户ID
* @param int $num 列表显示条数
* @param int $start 显示起始位置
*
* @return array $arr 红保列表
*/
function get_user_bouns_list($user_id, $num = 10, $start = 0)
{
$sql = "SELECT u.bonus_sn, u.order_id, b.type_name, b.type_money, b.min_goods_amount, b.use_start_date, b.use_end_date " . " FROM " . $GLOBALS['ecs']->table('user_bonus') . " AS u ," . $GLOBALS['ecs']->table('bonus_type') . " AS b" . " WHERE u.bonus_type_id = b.type_id AND u.user_id = '" . $user_id . "'";
$res = $GLOBALS['db']->selectLimit($sql, $num, $start);
$arr = array();
$day = getdate();
$cur_date = local_mktime(23, 59, 59, $day['mon'], $day['mday'], $day['year']);
while ($row = $GLOBALS['db']->fetchRow($res)) {
/* 先判断是否被使用，然后判断是否开始或过期 */
if (empty($row['order_id'])) {
/* 没有被使用 */
if ($row['use_start_date'] > $cur_date) {
$row['status'] = L('not_start');
} else {
if ($row['use_end_date'] < $cur_date) {
$row['status'] = L('overdue');
} else {
$row['status'] = L('not_use');
}
}
} else {
$row['status'] = '<a href="user.php?act=order_detail&order_id=' . $row['order_id'] . '" >' . L('had_use') . '</a>';
}
$row['use_startdate'] = local_date(C('date_format'), $row['use_start_date']);
$row['use_enddate'] = local_date(C('date_format'), $row['use_end_date']);
$arr[] = $row;
}
return $arr;
}
/**
*
* @access public
* @param int $user_id 用户ID
* @param int $num 列表显示条数
* @param int $start 显示起始位置
*
* @return array $arr 红保列表
*/
function get_user_bouns_list($user_id, $num = 10, $start = 0)
{
$sql = "SELECT u.bonus_sn, u.order_id, b.type_name, b.type_money, b.min_goods_amount, b.use_start_date, b.use_end_date " . " FROM " . $this->pre . "user_bonus AS u ," . $this->pre . "bonus_type AS b" . " WHERE u.bonus_type_id = b.type_id AND u.user_id = '" . $user_id . "' LIMIT {$start} , {$num}";
$res = $this->query($sql);
$arr = array();
$day = getdate();
$cur_date = local_mktime(23, 59, 59, $day['mon'], $day['mday'], $day['year']);
foreach ($res as $row) {
/* 先判断是否被使用，然后判断是否开始或过期 */
if (empty($row['order_id'])) {
/* 没有被使用 */
if ($row['use_start_date'] > $cur_date) {
$row['status'] = L('not_start');
} else {
if ($row['use_end_date'] < $cur_date) {
$row['status'] = L('overdue');
} else {
$row['status'] = L('not_use');
}
}
} else {
$url = url('user/order_detail', array('order_id' => $row['order_id']));
$row['status'] = '<a href="' . $url . '" >' . L('had_use') . '</a>';
}
$row['use_startdate'] = local_date(C('date_format'), $row['use_start_date']);
$row['use_enddate'] = local_date(C('date_format'), $row['use_end_date']);
$arr[] = $row;
}
return $arr;
}
$order['total_weight'] = $weight_price['formated_weight'];
/* 参数赋值：订单 */
$smarty->assign('order', $order);
/* 取得用户信息 */
if ($order['user_id'] > 0) {
/* 用户等级 */
if ($user['user_rank'] > 0) {
$where = " WHERE rank_id = '{$user['user_rank']}' ";
} else {
$where = " WHERE min_points <= " . intval($user['rank_points']) . " ORDER BY min_points DESC ";
}
$sql = "SELECT rank_name FROM " . $ecs->table('user_rank') . $where;
$user['rank_name'] = $db->getOne($sql);
// 用户红包数量
$day = getdate();
$today = local_mktime(23, 59, 59, $day['mon'], $day['mday'], $day['year']);
$sql = "SELECT COUNT(*) " . "FROM " . $ecs->table('bonus_type') . " AS bt, " . $ecs->table('user_bonus') . " AS ub " . "WHERE bt.type_id = ub.bonus_type_id " . "AND ub.user_id = '{$order['user_id']}' " . "AND ub.order_id = 0 " . "AND bt.use_start_date <= '{$today}' " . "AND bt.use_end_date >= '{$today}'";
$user['bonus_count'] = $db->getOne($sql);
$smarty->assign('user', $user);
// 地址信息
$sql = "SELECT * FROM " . $ecs->table('user_address') . " WHERE user_id = '{$order['user_id']}'";
$smarty->assign('address_list', $db->getAll($sql));
}
/* 取得订单商品及货品 */
$goods_list = array();
$goods_attr = array();
$sql = "SELECT o.*, IF(o.product_id > 0, p.product_number, g.goods_number) AS storage, o.goods_attr, g.suppliers_id, IFNULL(b.brand_name, '') AS brand_name, p.product_sn\n FROM " . $ecs->table('order_goods') . " AS o\n LEFT JOIN " . $ecs->table('products') . " AS p\n ON p.product_id = o.product_id\n LEFT JOIN " . $ecs->table('goods') . " AS g\n ON o.goods_id = g.goods_id\n LEFT JOIN " . $ecs->table('brand') . " AS b\n ON g.brand_id = b.brand_id\n WHERE o.order_id = '{$order['order_id']}'";
$res = $db->query($sql);
while ($row = $db->fetchRow($res)) {
/* 虚拟商品支持 */
if ($row['is_real'] == 0) {
<?php
/**
* ECSHOP 注册短信
* ============================================================================
* 版权所有 2005-2011 上海商派网络科技有限公司，并保留所有权利。
* 网站地址: http://www.ecshop.com；
* ----------------------------------------------------------------------------
* 这不是一个自由软件！您只能在不用于商业目的的前提下对程序代码进行修改和
* 使用；不允许对程序代码以任何形式任何目的的再发布。
* ============================================================================
* $Author: liuhui $
* $Id: sms_url.php 16654 2009-09-09 10:29:24Z liuhui $
*/
$url = '';
if (isset($GLOBALS['_CFG']['certificate_id'])) {
if ($GLOBALS['_CFG']['certificate_id'] == '') {
$certi_id = 'error';
} else {
$certi_id = $GLOBALS['_CFG']['certificate_id'];
}
$sess_id = $GLOBALS['sess']->get_session_id();
$auth = local_mktime();
//代码修改 By www.68ecshop.com
$ac = md5($certi_id . 'SHOPEX_SMS' . $auth);
$url = 'http://service.shopex.cn/sms/index.php?certificate_id=' . $certi_id . '&sess_id=' . $sess_id . '&auth=' . $auth . '&ac=' . $ac;
}
/**
* 获得商品的货品列表
*
* @access public
* @params integer $goods_id
* @params string $conditions
* @return array
*/
function product_list($goods_id, $conditions = '')
{
/* 过滤条件 */
$param_str = '-' . $goods_id;
$result = get_filter($param_str);
if ($result === false) {
$day = getdate();
$today = local_mktime(23, 59, 59, $day['mon'], $day['mday'], $day['year']);
$filter['goods_id'] = $goods_id;
$filter['keyword'] = empty($_REQUEST['keyword']) ? '' : trim($_REQUEST['keyword']);
$filter['stock_warning'] = empty($_REQUEST['stock_warning']) ? 0 : intval($_REQUEST['stock_warning']);
if (isset($_REQUEST['is_ajax']) && $_REQUEST['is_ajax'] == 1) {
$filter['keyword'] = json_str_iconv($filter['keyword']);
}
$filter['sort_by'] = empty($_REQUEST['sort_by']) ? 'product_id' : trim($_REQUEST['sort_by']);
$filter['sort_order'] = empty($_REQUEST['sort_order']) ? 'DESC' : trim($_REQUEST['sort_order']);
$filter['extension_code'] = empty($_REQUEST['extension_code']) ? '' : trim($_REQUEST['extension_code']);
$filter['page_count'] = isset($filter['page_count']) ? $filter['page_count'] : 1;
$where = '';
/* 库存警告 */
if ($filter['stock_warning']) {
$where .= ' AND goods_number <= warn_number ';
}
/* 关键字 */
if (!empty($filter['keyword'])) {
$where .= " AND (product_sn LIKE '%" . $filter['keyword'] . "%')";
}
$where .= $conditions;
/* 记录总数 */
$sql = "SELECT COUNT(*) FROM " . $GLOBALS['ecs']->table('products') . " AS p WHERE goods_id = {$goods_id} {$where}";
$filter['record_count'] = $GLOBALS['db']->getOne($sql);
$sql = "SELECT product_id, goods_id, goods_attr, product_sn, product_number\n FROM " . $GLOBALS['ecs']->table('products') . " AS g\n WHERE goods_id = {$goods_id} {$where}\n ORDER BY {$filter['sort_by']} {$filter['sort_order']}";
$filter['keyword'] = stripslashes($filter['keyword']);
//set_filter($filter, $sql, $param_str);
} else {
$sql = $result['sql'];
$filter = $result['filter'];
}
$row = $GLOBALS['db']->getAll($sql);
/* 处理规格属性 */
$goods_attr = product_goods_attr_list($goods_id);
foreach ($row as $key => $value) {
$_goods_attr_array = explode('|', $value['goods_attr']);
if (is_array($_goods_attr_array)) {
$_temp = '';
foreach ($_goods_attr_array as $_goods_attr_value) {
$_temp[] = $goods_attr[$_goods_attr_value];
}
$row[$key]['goods_attr'] = $_temp;
}
}
return array('product' => $row, 'filter' => $filter, 'page_count' => $filter['page_count'], 'record_count' => $filter['record_count']);
}
function insert_id_rebate($supplier_id)
{
$sql = "select supplier_rebate_paytime from " . $GLOBALS['ecs']->table('supplier') . " where supplier_id='{$supplier_id}'";
$supplier_rebate_paytime = $GLOBALS['db']->getOne($sql);
$sql = "select rebate_paytime_start, rebate_paytime_end from " . $GLOBALS['ecs']->table('supplier_rebate') . " where supplier_id= '{$supplier_id}' and is_pay_ok=0 order by rebate_id DESC LIMIT 0,1";
$row = $GLOBALS['db']->getRow($sql);
if (!$row['rebate_paytime_start']) {
$rebate_paytime_start = local_mktime(0, 0, 0, local_date('m'), local_date('d'), local_date('Y'));
}
if (!$row['rebate_paytime_end']) {
switch ($supplier_rebate_paytime) {
case '1':
$rebate_paytime_end = local_strtotime("this Sunday") + 24 * 60 * 60 - 1;
break;
case '2':
$rebate_paytime_end = local_mktime(23, 59, 59, local_date("m"), local_date("t"), local_date("Y"));
break;
case '3':
if (local_date("m") == '1' || local_date("m") == '2' || local_date("m") == '3') {
$rebate_paytime_end = local_mktime(23, 59, 59, 3, 31, local_date("Y"));
} elseif (local_date("m") == '4' || local_date("m") == '5' || local_date("m") == '6') {
$rebate_paytime_end = local_mktime(23, 59, 59, 6, 30, local_date("Y"));
} elseif (local_date("m") == '7' || local_date("m") == '8' || local_date("m") == '9') {
$rebate_paytime_end = local_mktime(23, 59, 59, 9, 30, local_date("Y"));
} elseif (local_date("m") == '10' || local_date("m") == '11' || local_date("m") == '12') {
$rebate_paytime_end = local_mktime(23, 59, 59, 12, 31, local_date("Y"));
}
break;
case '4':
$rebate_paytime_end = local_mktime(23, 59, 59, 12, 31, local_date("Y"));
break;
}
}
if ($row['rebate_paytime_start'] && $row['rebate_paytime_end']) {
$rebate_paytime_start = $row['rebate_paytime_end'] + 1;
switch ($supplier_rebate_paytime) {
case '1':
$rebate_paytime_end = $row['rebate_paytime_end'] + 24 * 60 * 60 * 7;
break;
case '2':
$rebate_paytime_end = local_mktime(23, 59, 59, local_date("m", $rebate_paytime_start), local_date("t", $rebate_paytime_start), local_date("Y", $rebate_paytime_start));
break;
case '3':
if (local_date("m", $rebate_paytime_start) == '1' || local_date("m") == '2' || local_date("m") == '3') {
$rebate_paytime_end = local_mktime(23, 59, 59, 3, 31, local_date("Y"));
} elseif (local_date("m") == '4' || local_date("m") == '5' || local_date("m") == '6') {
$rebate_paytime_end = local_mktime(23, 59, 59, 6, 30, local_date("Y"));
} elseif (local_date("m") == '7' || local_date("m") == '8' || local_date("m") == '9') {
$rebate_paytime_end = local_mktime(23, 59, 59, 9, 30, local_date("Y"));
} elseif (local_date("m") == '10' || local_date("m") == '11' || local_date("m") == '12') {
$rebate_paytime_end = local_mktime(23, 59, 59, 12, 31, local_date("Y"));
}
break;
case '4':
$rebate_paytime_end = local_mktime(23, 59, 59, 12, 31, local_date("Y"));
break;
}
}
$sql = "insert into " . $GLOBALS['ecs']->table('supplier_rebate') . "(rebate_paytime_start, rebate_paytime_end, supplier_id) value('{$rebate_paytime_start}', '{$rebate_paytime_end}', '{$supplier_id}') ";
$GLOBALS['db']->query($sql);
}
$query_type = $_GET['query_type'];
$start_time = $_GET['start_time'];
$end_time = $_GET['end_time'];
}
} else {
if (isset($_POST['query_by_year'])) {
/* 年走势 */
$query_type = 'year';
$start_time = local_mktime(0, 0, 0, 1, 1, intval($_POST['year_beginYear']));
$end_time = local_mktime(23, 59, 59, 12, 31, intval($_POST['year_endYear']));
} else {
/* 月走势 */
$query_type = 'month';
$start_time = local_mktime(0, 0, 0, intval($_POST['month_beginMonth']), 1, intval($_POST['month_beginYear']));
$end_time = local_mktime(23, 59, 59, intval($_POST['month_endMonth']), 1, intval($_POST['month_endYear']));
$end_time = local_mktime(23, 59, 59, intval($_POST['month_endMonth']), date('t', $end_time), intval($_POST['month_endYear']));
}
}
/* 分组统计订单数和销售额：已发货时间为准 */
$format = $query_type == 'year' ? '%Y' : '%Y-%m';
$sql = "SELECT DATE_FORMAT(FROM_UNIXTIME(shipping_time), '{$format}') AS period, COUNT(*) AS order_count, " . "SUM(goods_amount + shipping_fee + insure_fee + pay_fee + pack_fee + card_fee - discount) AS order_amount " . "FROM " . $ecs->table('order_info') . " WHERE (order_status = '" . OS_CONFIRMED . "' OR order_status >= '" . OS_SPLITED . "')" . " AND (pay_status = '" . PS_PAYED . "' OR pay_status = '" . PS_PAYING . "') " . " AND (shipping_status = '" . SS_SHIPPED . "' OR shipping_status = '" . SS_RECEIVED . "') " . " AND shipping_time >= '{$start_time}' AND shipping_time <= '{$end_time}'" . " GROUP BY period ";
$data_list = $db->getAll($sql);
/*------------------------------------------------------ */
//-- 显示统计信息
/*------------------------------------------------------ */
if ($_REQUEST['act'] == 'list') {
/* 赋值查询时间段 */
$smarty->assign('start_time', local_date('Y-m-d', $start_time));
$smarty->assign('end_time', local_date('Y-m-d', $end_time));
/* 赋值统计数据 */
$xml = "<chart caption='' xAxisName='%s' showValues='0' decimals='0' formatNumberScale='0'>%s</chart>";
function get_user_bouns_list2($user_id)
{
$sql = "SELECT u.bonus_sn, u.order_id,u.used_time,b.is_share, b.type_name, b.type_money, b.min_goods_amount, b.use_start_date, b.use_end_date " . " FROM " . $GLOBALS['hhs']->table('user_bonus') . " AS u ," . $GLOBALS['hhs']->table('bonus_type') . " AS b" . " WHERE u.bonus_type_id = b.type_id AND u.user_id = '" . $user_id . "'";
$res = $GLOBALS['db']->getAll($sql);
$arr = array();
$day = getdate();
$cur_date = local_mktime(23, 59, 59, $day['mon'], $day['mday'], $day['year']);
$cur_date_start = local_mktime(0, 0, 0, $day['mon'], $day['mday'], $day['year']);
foreach ($res as $row) {
/* 先判断是否被使用，然后判断是否开始或过期 */
if (empty($row['order_id'])) {
/* 没有被使用 */
if ($row['use_start_date'] > $cur_date) {
$row['status'] = $GLOBALS['_LANG']['not_start'];
} else {
if ($row['use_end_date'] < $cur_date) {
$row['status'] = $GLOBALS['_LANG']['overdue'];
} else {
$row['status'] = $GLOBALS['_LANG']['not_use'];
}
}
} else {
$row['status'] = '<a href="user.php?act=order_detail&order_id=' . $row['order_id'] . '" >' . $GLOBALS['_LANG']['had_use'] . '</a>';
}
$row['use_startdate'] = local_date($GLOBALS['_CFG']['date_format'], $row['use_start_date']);
$row['use_enddate'] = local_date($GLOBALS['_CFG']['date_format'], $row['use_end_date']);
//归类存放 1 使用中 2 可使用 3已使用 4 未激活 5 已过期
if (!empty($row['order_id'])) {
//已使用分为 1 使用中 2 已使用
$row['used_date'] = local_date($GLOBALS['_CFG']['date_format'], $row['used_time']);
//使用中
$sql = "select order_status,pay_status from " . $GLOBALS['hhs']->table('order_info') . " where order_id=" . $row['order_id'];
$order = $GLOBALS['db']->getRow($sql);
if ($order['pay_status'] == 2) {
//已使用
$arr['used'][] = $row;
} else {
$total_fee = " (o.goods_amount - o.discount + o.tax + o.shipping_fee + o.insure_fee + o.pay_fee + o.pack_fee + o.card_fee) AS total_fee ";
$sql = "select g.goods_name,g.goods_thumb," . $total_fee . " from " . $GLOBALS['hhs']->table('order_info') . " as o left join " . $GLOBALS['hhs']->table('order_goods') . " as og on o.order_id=og.order_id left join " . $GLOBALS['hhs']->table('goods') . " as g on og.goods_id=g.goods_id where o.order_id=" . $row['order_id'];
$goods = $GLOBALS['db']->getRow($sql);
$row['goods'] = $goods;
$arr['using'][] = $row;
//使用中
}
} else {
//未使用 ——> 1 可使用 2 未激活 3 已过期
if ($row['use_start_date'] > $cur_date) {
$arr['not_start'][] = $row;
//未开始未激活
} else {
if ($row['use_end_date'] < $cur_date) {
$arr['overdue'][] = $row;
//已过期
} else {
$arr['ok'][] = $row;
}
}
}
}
return $arr;
}
/**
*
* @access public
* @param int $user_id 用户ID
* @param int $num 列表显示条数
* @param int $start 显示起始位置
* @param int $suppid 店铺id
* @return array $arr 红保列表
*/
function get_user_bouns_list($user_id, $num = 10, $start = 0, $suppid = -1)
{
/* $sql = "SELECT u.bonus_sn,u.supplier_id, u.order_id, b.type_name, b.type_money, b.min_goods_amount, b.use_start_date, b.use_end_date ".
" FROM " .$GLOBALS['ecs']->table('user_bonus'). " AS u ,".
$GLOBALS['ecs']->table('bonus_type'). " AS b".
" WHERE u.bonus_type_id = b.type_id AND u.user_id = '" .$user_id. "'";*/
$sql = "SELECT u.bonus_sn,u.supplier_id, u.order_id, b.type_name, b.type_money, b.min_goods_amount, b.use_start_date, b.use_end_date " . " FROM " . $GLOBALS['ecs']->table('user_bonus') . " AS u ," . $GLOBALS['ecs']->table('bonus_type') . " AS b" . " WHERE u.bonus_type_id = b.type_id AND u.user_id = '" . $user_id . "'";
if ($suppid > -1) {
$sql .= " AND u.supplier_id=" . intval($suppid);
}
$res = $GLOBALS['db']->selectLimit($sql, $num, $start);
$arr = array();
$day = getdate();
$cur_date = local_mktime(23, 59, 59, $day['mon'], $day['mday'], $day['year']);
while ($row = $GLOBALS['db']->fetchRow($res)) {
/* 先判断是否被使用，然后判断是否开始或过期 */
if (empty($row['order_id'])) {
/* 没有被使用 */
if ($row['use_start_date'] > $cur_date) {
$row['status'] = $GLOBALS['_LANG']['not_start'];
} else {
if ($row['use_end_date'] < $cur_date) {
$row['status'] = $GLOBALS['_LANG']['overdue'];
} else {
$row['status'] = $GLOBALS['_LANG']['not_use'];
}
}
} else {
$row['status'] = '<a href="user.php?act=order_detail&order_id=' . $row['order_id'] . '" >' . $GLOBALS['_LANG']['had_use'] . '</a>';
}
if ($row['supplier_id'] == '0') {
$row['supplier_id'] = "自营商";
} else {
$supplierid = $row['supplier_id'];
$sql = "SELECT * FROM " . $GLOBALS['ecs']->table('supplier_shop_config') . "WHERE supplier_id = '{$supplierid}' AND code = 'shop_name'";
$supp = $GLOBALS['db']->getRow($sql);
$row['supplier_id'] = $supp['value'];
}
$row['use_startdate'] = local_date($GLOBALS['_CFG']['date_format'], $row['use_start_date']);
$row['use_enddate'] = local_date($GLOBALS['_CFG']['date_format'], $row['use_end_date']);
$arr[] = $row;
}
return $arr;
}
/**
* 取得当前用户应该得到的红包总额
*/
function get_total_bonus() {
$day = getdate();
$today = local_mktime(23, 59, 59, $day['mon'], $day['mday'], $day['year']);
/* 按商品发的红包 */
$sql = "SELECT SUM(c.goods_number * t.type_money)" .
" as count FROM " . $this->pre . "cart AS c, "
. $this->pre . "bonus_type AS t, "
. $this->pre . "goods AS g " .
"WHERE c.session_id = '" . SESS_ID . "' " .
"AND c.is_gift = 0 " .
"AND c.goods_id = g.goods_id " .
"AND g.bonus_type_id = t.type_id " .
"AND t.send_type = '" . SEND_BY_GOODS . "' " .
"AND t.send_start_date <= '$today' " .
"AND t.send_end_date >= '$today' " .
"AND c.rec_type = '" . CART_GENERAL_GOODS . "'";
$res = $this->row($sql);
$goods_total = floatval($res['count']);
/* 取得购物车中非赠品总金额 */
$sql = "SELECT SUM(goods_price * goods_number) " .
" as count FROM " . $this->pre .
"cart WHERE session_id = '" . SESS_ID . "' " .
" AND is_gift = 0 " .
" AND rec_type = '" . CART_GENERAL_GOODS . "'";
$res = $this->row($sql);
$amount = floatval($res['count']);
/* 按订单发的红包 */
$sql = "SELECT FLOOR('$amount' / min_amount) * type_money " .
"as count FROM " . $this->pre .
"bonus_type WHERE send_type = '" . SEND_BY_ORDER . "' " .
" AND send_start_date <= '$today' " .
"AND send_end_date >= '$today' " .
"AND min_amount > 0 ";
$res = $this->row($sql);
$order_total = floatval($res['count']);
return $goods_total + $order_total;
}
/**
* 取得用户当前可用红包
* @param int $user_id 用户id
* @param float $goods_amount 订单商品金额
* @return array 红包数组
*/
function zy_user_bonus($user_id, $goods_amount = 0)
{
$day = getdate();
$today = local_mktime(23, 59, 59, $day['mon'], $day['mday'], $day['year']);
$sql = "SELECT t.type_id, t.type_name, t.type_money, b.bonus_id " .
"FROM " . $GLOBALS['ecs']->table('bonus_type') . " AS t," .
$GLOBALS['ecs']->table('user_bonus') . " AS b " .
"WHERE t.type_id = b.bonus_type_id " .
"AND t.use_start_date <= '$today' " .
"AND t.use_end_date >= '$today' " .
"AND t.min_goods_amount <= '$goods_amount' " .
"AND b.user_id<>0 " .
"AND b.user_id = '$user_id' " .
"AND b.order_id = 0";
return $GLOBALS['db']->getAll($sql);
}
/**
* 获得商品列表
*
* @access public
* @params integer $isdelete
* @params integer $real_goods
* @return array
*/
function goods_list($is_delete, $real_goods = 1)
{
/* 过滤条件 */
$param_str = '-' . $is_delete . '-' . $real_goods;
$result = get_filter($param_str);
if ($result === false) {
$day = getdate();
$today = local_mktime(23, 59, 59, $day['mon'], $day['mday'], $day['year']);
$filter['cat_id'] = empty($_REQUEST['cat_id']) ? 0 : intval($_REQUEST['cat_id']);
$filter['intro_type'] = empty($_REQUEST['intro_type']) ? '' : trim($_REQUEST['intro_type']);
$filter['is_promote'] = empty($_REQUEST['is_promote']) ? 0 : intval($_REQUEST['is_promote']);
$filter['stock_warning'] = empty($_REQUEST['stock_warning']) ? 0 : intval($_REQUEST['stock_warning']);
$filter['brand_id'] = empty($_REQUEST['brand_id']) ? 0 : intval($_REQUEST['brand_id']);
$filter['keyword'] = empty($_REQUEST['keyword']) ? '' : trim($_REQUEST['keyword']);
if ($_REQUEST['is_ajax'] == 1) {
$filter['keyword'] = json_str_iconv($filter['keyword']);
}
$filter['sort_by'] = empty($_REQUEST['sort_by']) ? 'goods_id' : trim($_REQUEST['sort_by']);
$filter['sort_order'] = empty($_REQUEST['sort_order']) ? 'DESC' : trim($_REQUEST['sort_order']);
$filter['extension_code'] = empty($_REQUEST['extension_code']) ? '' : trim($_REQUEST['extension_code']);
$filter['is_delete'] = $is_delete;
$filter['real_goods'] = $real_goods;
$where = $filter['cat_id'] > 0 ? " AND " . get_children($filter['cat_id']) : '';
/* 推荐类型 */
switch ($filter['intro_type']) {
case 'is_best':
$where .= " AND is_best=1";
break;
case 'is_hot':
$where .= ' AND is_hot=1';
break;
case 'is_new':
$where .= ' AND is_new=1';
break;
case 'is_promote':
$where .= " AND is_promote = 1 AND promote_price > 0 AND promote_start_date <= '{$today}' AND promote_end_date >= '{$today}'";
break;
case 'all_type':
$where .= " AND (is_best=1 OR is_hot=1 OR is_new=1 OR (is_promote = 1 AND promote_price > 0 AND promote_start_date <= '" . $today . "' AND promote_end_date >= '" . $today . "'))";
}
/* 库存警告 */
if ($filter['stock_warning']) {
$where .= ' AND goods_number <= warn_number ';
}
/* 品牌 */
if ($filter['brand_id']) {
$where .= " AND brand_id='{$filter['brand_id']}'";
}
/* 扩展 */
if ($filter['extension_code']) {
$where .= " AND extension_code='{$filter['extension_code']}'";
}
/* 关键字 */
if (!empty($filter['keyword'])) {
$where .= " AND (goods_sn LIKE '%" . mysql_like_quote($filter['keyword']) . "%' OR goods_name LIKE '%" . mysql_like_quote($filter['keyword']) . "%')";
}
if ($real_goods > -1) {
$where .= " AND is_real='{$real_goods}'";
}
/* 记录总数 */
$sql = "SELECT COUNT(*) FROM " . $GLOBALS['ecs']->table('goods') . " AS g WHERE is_delete='{$is_delete}' {$where}";
$filter['record_count'] = $GLOBALS['db']->getOne($sql);
/* 分页大小 */
$filter = page_and_size($filter);
$sql = "SELECT goods_id, goods_name, goods_sn, shop_price, is_on_sale, is_best, is_new, is_hot, sort_order, goods_number, integral, " . " (promote_price > 0 AND promote_start_date <= '{$today}' AND promote_end_date >= '{$today}') AS is_promote " . " FROM " . $GLOBALS['ecs']->table('goods') . " AS g WHERE is_delete='{$is_delete}' {$where}" . " ORDER BY {$filter['sort_by']} {$filter['sort_order']} " . " LIMIT " . $filter['start'] . ",{$filter['page_size']}";
$filter['keyword'] = stripslashes($filter['keyword']);
set_filter($filter, $sql, $param_str);
} else {
$sql = $result['sql'];
$filter = $result['filter'];
}
$row = $GLOBALS['db']->getAll($sql);
return array('goods' => $row, 'filter' => $filter, 'page_count' => $filter['page_count'], 'record_count' => $filter['record_count']);
}