|
Server : Apache System : Linux iZ2vcgyutqttsd1p850kl8Z 3.10.0-1160.92.1.el7.x86_64 #1 SMP Tue Jun 20 11:48:01 UTC 2023 x86_64 User : www ( 1000) PHP Version : 5.6.40 Disable Function : passthru,exec,system,putenv,chroot,chgrp,chown,shell_exec,popen,proc_open,pcntl_exec,ini_alter,ini_restore,dl,openlog,syslog,readlink,symlink,popepassthru,pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,imap_open,apache_setenv Directory : /www/wwwroot/saimikebio.com/includes/ |
<?php
/**
* ECSHOP 用户交易相关函数库
* ============================================================================
* 版权所有 2005-2010 上海商派网络科技有限公司，并保留所有权利。
* 网站地址: http://www.ecshop.com；
* ----------------------------------------------------------------------------
* 这不是一个自由软件！您只能在不用于商业目的的前提下对程序代码进行修改和
* 使用；不允许对程序代码以任何形式任何目的的再发布。
* ============================================================================
* $Author: liuhui $
* $Id: lib_transaction.php 17063 2010-03-25 06:35:46Z liuhui $
*/
/**
* 获取用户指定范围的订单列表
*
* @access public
* @param int $user_id 用户ID号
* @param int $num 列表最大数量
* @param int $start 列表起始位置
* @return array $order_list 订单列表
*/
function get_user_orders_1($user_id, $num = 10, $start = 0,$where='')
{
/* 取得订单列表 */
$arr = array();
$sql = "SELECT o.*, " .
"(goods_amount + shipping_fee + insure_fee + pay_fee + pack_fee + card_fee + tax - discount) AS total_fee ".
" FROM " .$GLOBALS['ecs']->table('order_info') . ' as o '.
" WHERE user_id = '$user_id' $where ORDER BY add_time DESC";
$res = $GLOBALS['db']->SelectLimit($sql, $num, $start);
while ($row = $GLOBALS['db']->fetchRow($res))
{
if ($row['order_status'] == OS_UNCONFIRMED)
{
$row['handler'] = "<a href=\"user.php?act=cancel_order&order_id=" .$row['order_id']. "\" onclick=\"if (!confirm('".$GLOBALS['_LANG']['confirm_cancel']."')) return false;\">".$GLOBALS['_LANG']['cancel']."</a>";
}
else if ($row['order_status'] == OS_SPLITED)
{
/* 对配送状态的处理 */
if ($row['shipping_status'] == SS_SHIPPED)
{
$back_num = $GLOBALS['db']->getOne("SELECT COUNT(*) FROM " . $GLOBALS['ecs']->table('back_order') . " WHERE order_id = " . $row['order_id'] . " AND status_back < 6 AND status_back != 3");
if ($back_num > 0)
{
$back_info = "此单存在正在退货商品，确认收货退货申请将取消。";
}
else
{
$back_info = "";
}
@$okgoods_time = $GLOBALS['db']->getOne("select value from " . $GLOBALS['ecs']->table('shop_config') . " where code='okgoods_time'");
@$row_time = $okgoods_time - (local_date('d',gmtime()) - local_date('d',$row['shipping_time']));
@$row['handler'] = "<div class='clearfix'><i class='endtime-icon fl'></i><em class='endtime-text'>" . $row_time . "天后自动收货</em></div><a href=\"user.php?act=affirm_received&order_id=" .$row['order_id']. "\" onclick=\"if (!confirm('".$back_info.$GLOBALS['_LANG']['confirm_received']."')) return false;\" style='display:inline-block;background:#F60;color:#fff;padding:3px 5px ;margin:3px 0px;'>".$GLOBALS['_LANG']['received']."</a>";
}
elseif ($row['shipping_status'] == SS_RECEIVED)
{
@$row['handler'] = '<span style="color:red">'.$GLOBALS['_LANG']['ss_received'] .'</span>';
}
else
{
if ($row['pay_status'] == PS_UNPAYED)
{
@$row['handler'] = "<a href=\"user.php?act=order_detail&order_id=" .$row['order_id']. '">' .$GLOBALS['_LANG']['pay_money']. '</a>';
}
else
{
@$row['handler'] = "<a href=\"user.php?act=order_detail&order_id=" .$row['order_id']. '">' .$GLOBALS['_LANG']['view_order']. '</a>';
}
}
}
else
{
$row['handler'] = '<span style="color:red">'.$GLOBALS['_LANG']['os'][$row['order_status']] .'</span>';
}
$row['shipping_status'] = ($row['shipping_status'] == SS_SHIPPED_ING) ? SS_PREPARING : $row['shipping_status'];
$row['order_status1'] = $row['order_status'];
$row['order_status'] = $GLOBALS['_LANG']['os'][$row['order_status']] . ',' . $GLOBALS['_LANG']['ps'][$row['pay_status']] . ',' . $GLOBALS['_LANG']['ss'][$row['shipping_status']];
$cod_code = $GLOBALS['db']->getOne("select pay_code from " . $GLOBALS['ecs']->table('payment') . " where pay_id=" . $row['pay_id']);
$weixiu_time = $GLOBALS['db']->getOne("select value from " . $GLOBALS['ecs']->table('shop_config') . " where code='weixiu_time'");
$row['weixiu_time'] = ($weixiu_time - (local_date('d',gmtime()) - local_date('d',$order['shipping_time_end'])) <= 0) ? 0 : 1;
$back_can_a = 1;
$comment_s = 0;
$shaidan_s = 0;
$goods_list_r = get_order_goods($row);
foreach($goods_list_r as $g_val)
{
if ($g_val['back_can'] == 0)
{
$back_can_a = 0;
}
if ($g_val['comment_state'] == 0 && $g_val['is_back'] == 0 && $comment_s == 0)
{
$comment_s = $g_val['rec_id'];
}
if ($g_val['shaidan_state'] == 0 && $g_val['is_back'] == 0 && $shaidan_s == 0)
{
$shaidan_s = $g_val['rec_id'];
}
}
$extension_code = $row['extension_code'];
/* 预售活动 */
if($extension_code == PRE_SALE_CODE)
{
include_once '/includes/lib_goods.php';
$pre_sale = pre_sale_info($row['extension_id']);
$pre_sale_status = $pre_sale['status'];
if($pre_sale['deposit'] > 0)
{
$pre_sale_deposit = $pre_sale['deposit'];
$pre_sale_deposit_format = $pre_sale['formated_deposit'];
}
}
$arr[$row['order_id']] = array('order_id' => $row['order_id'],
'order_sn' => $row['order_sn'],
'order_time' => local_date($GLOBALS['_CFG']['time_format'], $row['add_time']),
'order_status' => str_replace(',','</br>',$row['order_status']),
'consignee' => $row['consignee'], //聊天系统-收货人
'pay_name' => $row['pay_name'], //聊天系统-支付方式
'back_can' => $row['back_can'],
'back_can_a' => $back_can_a,
'comment_s' => $comment_s,
'shaidan_s' => $shaidan_s,
'total_fee' => price_format($row['total_fee'], false),
'goods_list' => $goods_list_r,
'pay_online' => $row['pay_online'],
'pay_status' => $row['pay_status'],
'handler' => $row['handler'],
'shipping_id' => $row['shipping_id'],
'shipping_name' => $row['shipping_name'],
'shipping_status'=> $row['shipping_status'],
'pay_id' => ($cod_code == 'cod' ? '' : $row['pay_id']),
'invoice_no' => $row['invoice_no'],
'order_status1' => $row['order_status1'],
'extension_code' => $row['extension_code'], // 用于前台辨识预售活动
'pre_sale_status' => $pre_sale_status, // 用于前台辨识预售活动状态
'pre_sale_deposit' => $pre_sale_deposit, // 定金
'pre_sale_deposit_format' => $pre_sale_deposit_format, // 格式化定金
'invoices' => $row['invoices'],
'weixiu_time' => $row['weixiu_time']);
}
return $arr;
}
function get_order_goods($order)
{
/* 取得订单商品及货品 */
$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, o.goods_attr_id, g.suppliers_id, IFNULL(b.brand_name, '') AS brand_name, p.product_sn, a.attr_value,g.goods_thumb,g.goods_id
FROM " . $GLOBALS['ecs']->table('order_goods') . " AS o
LEFT JOIN " . $GLOBALS['ecs']->table('products') . " AS p
ON p.product_id = o.product_id
LEFT JOIN " . $GLOBALS['ecs']->table('goods') . " AS g
ON o.goods_id = g.goods_id
LEFT JOIN " . $GLOBALS['ecs']->table('brand') . " AS b
ON g.brand_id = b.brand_id
LEFT JOIN " . $GLOBALS['ecs']->table('goods_attr') . " AS a
ON o.goods_attr_id = a.goods_attr_id
WHERE o.order_id = '$order[order_id]'";
$res = $GLOBALS['db']->query($sql);
while ($row = $GLOBALS['db']->fetchRow($res))
{
/* 虚拟商品支持 */
if ($row['is_real'] == 0)
{
/* 取得语言项 */
$filename = ROOT_PATH . 'plugins/' . $row['extension_code'] . '/languages/common_' . $_CFG['lang'] . '.php';
if (file_exists($filename))
{
include_once($filename);
if (!empty($_LANG[$row['extension_code'].'_link']))
{
$row['goods_name'] = $row['goods_name'] . sprintf($_LANG[$row['extension_code'].'_link'], $row['goods_id'], $order['order_sn']);
}
}
}
$row['formated_subtotal'] = price_format($row['goods_price'] * $row['goods_number']);
$row['formated_goods_price'] = price_format($row['goods_price']);
$row['url'] = build_uri('goods', array('gid' => $row['goods_id']), $row['goods_name']);
$row['thumb'] = get_image_path($row['goods_id'], $row['goods_thumb'],true);
$goods_attr[] = explode(' ', trim($row['goods_attr'])); //将商品属性拆分为一个数组
if ($row['extension_code'] == 'package_buy')
{
$row['storage'] = '';
$row['brand_name'] = '';
$row['package_goods_list'] = get_package_goods($row['goods_id']);
}
$goods_list[] = $row;
}
foreach ($goods_list as $goods_key => $goods_val)
{
$sql_goods = "select bo.*,bg.product_id from ". $GLOBALS['ecs']->table('back_order') . " as bo " .
" left join " . $GLOBALS['ecs']->table('back_goods') . " as bg " .
" on bo.back_id = bg.back_id and bo.goods_id = bg.goods_id" .
" where bo.order_id='$order[order_id]' and bo.goods_id='$goods_val[goods_id]' " .
" and bg.product_id='$goods_val[product_id]' and bo.status_back < 6";
$back_order =$GLOBALS['db']->getRow($sql_goods);
$goods_list[$goods_key]['back_can'] = count($back_order['order_id']) > 0 ? '0' : '1';
switch ($back_order['status_back'])
{
case '3' : $sb = "已完成"; break;
case '5' : $sb = "已申请"; break;
//case '6' : $sb = ""; break;
//case '7' : $sb = ""; break;
default : $sb = "正在"; break;
}
switch ($back_order['back_type'])
{
case '1' : $bt = "退货"; break;
case '3' : $bt = "申请维修"; break;
case '4' : $bt = "退款"; break;
default : break;
}
$goods_list[$goods_key]['back_can_no'] = $sb . " " . $bt;
}
return $goods_list;
}
?>