|
|
<?php
|
|
|
|
|
|
/**
|
|
|
* shop 订单管理
|
|
|
* ============================================================================
|
|
|
* 版权所有 2005-2010 上海商派网络科技有限公司，并保留所有权利。
|
|
|
* 网站地址: http://www.shop.com；
|
|
|
* ----------------------------------------------------------------------------
|
|
|
* 这不是一个自由软件！您只能在不用于商业目的的前提下对程序代码进行修改和
|
|
|
* 使用；不允许对程序代码以任何形式任何目的的再发布。
|
|
|
* ============================================================================
|
|
|
* $Author: yehuaixiao $
|
|
|
* $Id: order.php 17219 2011-01-27 10:49:19Z yehuaixiao $
|
|
|
*/
|
|
|
|
|
|
define('IN_ASC', true);
|
|
|
|
|
|
require(dirname(__FILE__) . '/includes/init.php');
|
|
|
require_once(ROOT_PATH . 'includes/lib_order.php');
|
|
|
require_once(ROOT_PATH . 'includes/lib_goods.php');
|
|
|
|
|
|
/* 检查权限 */
|
|
|
admin_priv('back_view');
|
|
|
|
|
|
$back_type_arr=array('0'=>'退货-退回', '1'=>'<font color=#ff3300>换货-退回</font>', '2'=>'<font color=#ff3300>换货-换出</font>', '4'=>'退款-无需退货');
|
|
|
|
|
|
|
|
|
//echo date("Y-m-d H:i:s",gmtime());
|
|
|
|
|
|
|
|
|
/*------------------------------------------------------ */
|
|
|
//-- 退货单列表
|
|
|
/*------------------------------------------------------ */
|
|
|
if ($_REQUEST['act'] == 'back_list')
|
|
|
{
|
|
|
/* 检查权限 */
|
|
|
admin_priv('back_view');
|
|
|
|
|
|
/* 查询 */
|
|
|
$result = back_list();
|
|
|
|
|
|
if(intval($_REQUEST['supp']) > 0){
|
|
|
$suppliers_list = get_supplier_list();
|
|
|
$smarty->assign('supp_list', $suppliers_list);
|
|
|
}
|
|
|
|
|
|
/* 模板赋值 */
|
|
|
$smarty->assign('ur_here', $_LANG['10_back_order']);
|
|
|
|
|
|
$smarty->assign('os_unconfirmed', OS_UNCONFIRMED);
|
|
|
$smarty->assign('cs_await_pay', CS_AWAIT_PAY);
|
|
|
$smarty->assign('cs_await_ship', CS_AWAIT_SHIP);
|
|
|
$smarty->assign('full_page', 1);
|
|
|
|
|
|
$smarty->assign('back_list', $result['back']);
|
|
|
$smarty->assign('filter', $result['filter']);
|
|
|
$smarty->assign('record_count', $result['record_count']);
|
|
|
$smarty->assign('page_count', $result['page_count']);
|
|
|
$smarty->assign('sort_update_time', '<img src="images/sort_desc.gif">');
|
|
|
|
|
|
/* 显示模板 */
|
|
|
assign_query_info();
|
|
|
$smarty->display('back_list_2.htm');
|
|
|
}
|
|
|
/*------------------------------------------------------ */
|
|
|
//-- 搜索、排序、分页
|
|
|
/*------------------------------------------------------ */
|
|
|
elseif ($_REQUEST['act'] == 'back_query')
|
|
|
{
|
|
|
/* 检查权限 */
|
|
|
admin_priv('back_view');
|
|
|
|
|
|
$result = back_list();
|
|
|
|
|
|
if(intval($_REQUEST['supp']) > 0){
|
|
|
$suppliers_list = get_supplier_list();
|
|
|
$smarty->assign('supp_list', $suppliers_list);
|
|
|
}
|
|
|
|
|
|
$smarty->assign('back_list', $result['back']);
|
|
|
$smarty->assign('filter', $result['filter']);
|
|
|
$smarty->assign('record_count', $result['record_count']);
|
|
|
$smarty->assign('page_count', $result['page_count']);
|
|
|
|
|
|
$sort_flag = sort_flag($result['filter']);
|
|
|
$smarty->assign($sort_flag['tag'], $sort_flag['img']);
|
|
|
make_json_result($smarty->fetch('back_list_2.htm'), '', array('filter' => $result['filter'], 'page_count' => $result['page_count']));
|
|
|
}
|
|
|
|
|
|
/*------------------------------------------------------ */
|
|
|
//-- 退货单详细
|
|
|
/*------------------------------------------------------ */
|
|
|
elseif ($_REQUEST['act'] == 'back_info')
|
|
|
{
|
|
|
/* 检查权限 */
|
|
|
admin_priv('back_view');
|
|
|
|
|
|
$back_id = intval(trim($_REQUEST['back_id']));
|
|
|
|
|
|
/* 根据发货单id查询发货单信息 */
|
|
|
if (!empty($back_id))
|
|
|
{
|
|
|
$back_order = back_order_info($back_id);
|
|
|
}
|
|
|
else
|
|
|
{
|
|
|
die('order does not exist');
|
|
|
}
|
|
|
|
|
|
if($back_order)
|
|
|
{
|
|
|
$base_order = $db->getRow("select * from ". $ecs->table('order_info') ." where order_id='$back_order[order_id]' ");
|
|
|
if($base_order)
|
|
|
{
|
|
|
$base_order['add_time'] = local_date($GLOBALS['_CFG']['time_format'], $base_order['add_time']);
|
|
|
$base_order['shipping_time'] = local_date($GLOBALS['_CFG']['time_format'], $base_order['shipping_time']);
|
|
|
$base_order['tel'] = $base_order['tel'] ? "电话：".$base_order['tel'] : "";
|
|
|
$base_order['tel'] .= $base_order['tel'] ? " " : "";
|
|
|
$base_order['tel'] .= $base_order['mobile'] ? "手机：".$base_order['mobile'] : "";
|
|
|
/* 是否保价 */
|
|
|
$base_order['insure_yn'] = $base_order['insure_fee']>0 ? 1 : 0;
|
|
|
$smarty->assign('base_order', $base_order);
|
|
|
}
|
|
|
}
|
|
|
else
|
|
|
{
|
|
|
die('order does not exist');
|
|
|
}
|
|
|
|
|
|
/* 获取原订单-產品信息 */
|
|
|
$sql = "select * from ". $ecs->table('order_goods') ." where order_id ='$back_order[order_id]' and goods_id='$back_order[goods_id]' ";
|
|
|
$order_goods = $db->getRow($sql);
|
|
|
$smarty->assign('order_goods', $order_goods);
|
|
|
|
|
|
/* 如果管理员属于某个办事处，检查该订单是否也属于这个办事处 */
|
|
|
$sql = "SELECT agency_id FROM " . $ecs->table('admin_user') . " WHERE user_id = '$_SESSION[admin_id]'";
|
|
|
$agency_id = $db->getOne($sql);
|
|
|
if ($agency_id > 0)
|
|
|
{
|
|
|
if ($back_order['agency_id'] != $agency_id)
|
|
|
{
|
|
|
sys_msg($_LANG['priv_error']);
|
|
|
}
|
|
|
|
|
|
/* 取当前办事处信息*/
|
|
|
$sql = "SELECT agency_name FROM " . $ecs->table('agency') . " WHERE agency_id = '$agency_id' LIMIT 0, 1";
|
|
|
$agency_name = $db->getOne($sql);
|
|
|
$back_order['agency_name'] = $agency_name;
|
|
|
}
|
|
|
|
|
|
/* 取得用户名 */
|
|
|
if ($back_order['user_id'] > 0)
|
|
|
{
|
|
|
$user = user_info($back_order['user_id']);
|
|
|
if (!empty($user))
|
|
|
{
|
|
|
$back_order['user_name'] = $user['user_name'];
|
|
|
}
|
|
|
}
|
|
|
|
|
|
/* 取得区域名 */
|
|
|
$sql = "SELECT concat(IFNULL(c.region_name, ''), ' ', IFNULL(p.region_name, ''), " .
|
|
|
"' ', IFNULL(t.region_name, ''), ' ', IFNULL(d.region_name, '')) AS region " .
|
|
|
"FROM " . $ecs->table('order_info') . " AS o " .
|
|
|
"LEFT JOIN " . $ecs->table('region') . " AS c ON o.country = c.region_id " .
|
|
|
"LEFT JOIN " . $ecs->table('region') . " AS p ON o.province = p.region_id " .
|
|
|
"LEFT JOIN " . $ecs->table('region') . " AS t ON o.city = t.region_id " .
|
|
|
"LEFT JOIN " . $ecs->table('region') . " AS d ON o.district = d.region_id " .
|
|
|
"WHERE o.order_id = '" . $back_order['order_id'] . "'";
|
|
|
$back_order['region'] = $db->getOne($sql);
|
|
|
|
|
|
|
|
|
|
|
|
/* 取得退换货產品 */
|
|
|
$goods_sql = "SELECT * FROM " . $ecs->table('back_goods') .
|
|
|
" WHERE back_id = " . $back_order['back_id']." order by back_type asc";
|
|
|
$res_list = $GLOBALS['db']->query($goods_sql );
|
|
|
$goods_list = array();
|
|
|
while ($row_list = $db->fetchRow($res_list))
|
|
|
{
|
|
|
$row_list['back_type_name'] = $back_type_arr[$row_list['back_type']];
|
|
|
$row_list['back_goods_money'] = price_format($row_list['back_goods_price'] * $row_list['back_goods_number'], false);
|
|
|
$goods_list[] = $row_list;
|
|
|
}
|
|
|
|
|
|
/* 是否存在实体產品 */
|
|
|
$exist_real_goods = 0;
|
|
|
if ($goods_list)
|
|
|
{
|
|
|
foreach ($goods_list as $value)
|
|
|
{
|
|
|
if ($value['is_real'])
|
|
|
{
|
|
|
$exist_real_goods++;
|
|
|
}
|
|
|
}
|
|
|
}
|
|
|
|
|
|
$back_order['country_name'] = $db->getOne("SELECT region_name FROM ".$ecs->table('region')." WHERE region_id = '$back_order[country]'");
|
|
|
$back_order['province_name'] = $db->getOne("SELECT region_name FROM ".$ecs->table('region')." WHERE region_id = '$back_order[province]'");
|
|
|
$back_order['city_name'] = $db->getOne("SELECT region_name FROM ".$ecs->table('region')." WHERE region_id = '$back_order[city]'");
|
|
|
$back_order['district_name'] = $db->getOne("SELECT region_name FROM ".$ecs->table('region')." WHERE region_id = '$back_order[district]'");
|
|
|
$back_order['address'] = $back_order['country_name'].' '.$back_order['province_name'].' '.$back_order['city_name'].' '.$back_order['district_name'].' '.$back_order['address'];
|
|
|
|
|
|
|
|
|
/* 模板赋值 */
|
|
|
$smarty->assign('back_order', $back_order);
|
|
|
$smarty->assign('exist_real_goods', $exist_real_goods);
|
|
|
$smarty->assign('goods_list', $goods_list);
|
|
|
$smarty->assign('back_id', $back_id); // 发货单id
|
|
|
|
|
|
/* 取得能执行的操作列表 */
|
|
|
$operable_list = operable_list($back_order);
|
|
|
$smarty->assign('operable_list', $operable_list);
|
|
|
|
|
|
/* 取得订单操作记录 */
|
|
|
$act_list = array();
|
|
|
$sql = "SELECT * FROM " . $ecs->table('back_action') . " WHERE back_id = '$back_id' ORDER BY log_time DESC,action_id DESC";
|
|
|
$res_act = $db->query($sql);
|
|
|
while ($row_act = $db->fetchRow($res_act))
|
|
|
{
|
|
|
$row_act['status_back'] = $_LANG['bos'][$row_act['status_back']];
|
|
|
$row_act['status_refund'] = $_LANG['bps'][$row_act['status_refund']];
|
|
|
$row_act['action_time'] = local_date($_CFG['time_format'], $row_act['log_time']);
|
|
|
$act_list[] = $row_act;
|
|
|
}
|
|
|
$smarty->assign('action_list', $act_list);
|
|
|
|
|
|
|
|
|
/* 回复留言图片 www.mb5.com.cn增加 */
|
|
|
$res = $db->getAll("SELECT * FROM ".$ecs->table('back_replay')." WHERE back_id = '$back_id' ORDER BY add_time ASC");
|
|
|
foreach ($res as $value)
|
|
|
{
|
|
|
$value['add_time'] = local_date($GLOBALS['_CFG']['time_format'], $value['add_time']);
|
|
|
$back_replay[] = $value;
|
|
|
}
|
|
|
if ($back_order['imgs'])
|
|
|
{
|
|
|
$imgs = explode(",",$back_order['imgs']);
|
|
|
}
|
|
|
$smarty->assign('imgs', $imgs);
|
|
|
$smarty->assign('back_replay', $back_replay);
|
|
|
|
|
|
/* 显示模板 */
|
|
|
$smarty->assign('ur_here', $_LANG['back_operate'] . $_LANG['detail']);
|
|
|
$smarty->assign('action_link', array('href' => 'back.php?act=back_list&' . list_link_postfix(), 'text' => $_LANG['10_back_order']));
|
|
|
assign_query_info();
|
|
|
$smarty->display('back_info_2.htm');
|
|
|
exit; //
|
|
|
}
|
|
|
|
|
|
/* 操作 */
|
|
|
elseif ($_REQUEST['act'] == 'operate')
|
|
|
{
|
|
|
/* 检查权限 */
|
|
|
admin_priv('back_view');
|
|
|
$back_id = intval(trim($_REQUEST['back_id'])); // 退换货订单id
|
|
|
$action_note = isset($_REQUEST['action_note']) ? trim($_REQUEST['action_note']) : '';
|
|
|
|
|
|
/* 查询订单信息 */
|
|
|
$order = back_order_info($back_id);
|
|
|
|
|
|
/* 通过申请 */
|
|
|
if (isset($_POST['ok']))
|
|
|
{
|
|
|
$status_back='5';
|
|
|
update_back($back_id, $status_back, $status_refund);
|
|
|
back_action($back_id, $status_back, $order['status_refund'], $action_note);
|
|
|
}
|
|
|
|
|
|
/* 拒绝申请 */
|
|
|
if (isset($_POST['no']))
|
|
|
{
|
|
|
$status_back='6';
|
|
|
update_back($back_id, $status_back, $status_refund);
|
|
|
back_action($back_id, $status_back, $order['status_refund'], $action_note);
|
|
|
}
|
|
|
|
|
|
/* 确认 */
|
|
|
if (isset($_POST['confirm']))
|
|
|
{
|
|
|
$status_back='1';
|
|
|
update_back($back_id, $status_back, $status_refund);
|
|
|
back_action($back_id, $status_back, $order['status_refund'], $action_note);
|
|
|
}
|
|
|
/* 去退款 */
|
|
|
elseif (isset($_POST['refund']))
|
|
|
{
|
|
|
$smarty->assign('ur_here', $_LANG['back_operate'] . '退款');
|
|
|
$sql="select * from ".$ecs->table('back_order')." where back_id='$back_id' ";
|
|
|
$refund = $db->getRow($sql);
|
|
|
$smarty->assign('back_id', $back_id);
|
|
|
$smarty->assign('refund', $refund);
|
|
|
assign_query_info();
|
|
|
$smarty->display('back_refund.htm');
|
|
|
exit;
|
|
|
}
|
|
|
/* 换出產品寄回 */
|
|
|
if (isset($_POST['backshipping']))
|
|
|
{
|
|
|
$status_back='2';
|
|
|
update_back($back_id, $status_back, $status_refund);
|
|
|
back_action($back_id, $status_back, $order['status_refund'], $action_note);
|
|
|
}
|
|
|
/* 完成退换货 */
|
|
|
if (isset($_POST['backfinish']))
|
|
|
{
|
|
|
$status_back='3';
|
|
|
update_back($back_id, $status_back, $status_refund);
|
|
|
back_action($back_id, $status_back, $order['status_refund'], $action_note);
|
|
|
}
|
|
|
/* 售后 */
|
|
|
if (isset($_POST['after_service']))
|
|
|
{
|
|
|
/* 记录log */
|
|
|
back_action($back_id, $order['status_back'], $order['status_refund'], '[' . $_LANG['op_after_service'] . '] ' . $action_note);
|
|
|
}
|
|
|
|
|
|
$links[] = array('text' => '返回退款/退货及维修详情', 'href' => 'back.php?act=back_info&back_id=' . $back_id);
|
|
|
sys_msg('恭喜，成功操作！', 1, $links);
|
|
|
|
|
|
}
|
|
|
|
|
|
/* 操作--退款 */
|
|
|
elseif ($_REQUEST['act'] == 'operate_refund')
|
|
|
{
|
|
|
/* 检查权限 */
|
|
|
admin_priv('back_view');
|
|
|
$status_refund = '1';
|
|
|
$back_id = intval(trim($_REQUEST['back_id'])); // 退换货订单id
|
|
|
$action_note = isset($_REQUEST['action_note']) ? trim($_REQUEST['action_note']) : '';
|
|
|
$order = back_order_info($back_id);
|
|
|
$sql = "update ". $ecs->table('back_goods') ." set status_refund='$status_refund' where back_id='$back_id' and (back_type='0' or back_type='4') ";
|
|
|
$db->query($sql);
|
|
|
$refund_money_2 = $_REQUEST['refund_money_2'] + $_REQUEST['refund_shipping_fee'];
|
|
|
$refund_desc = $_REQUEST['refund_desc'] . ($_REQUEST['refund_shipping'] ? '\n（已退运费：'. $_REQUEST['refund_shipping_fee']. '）' : '');
|
|
|
$sql2 = "update ". $ecs->table('back_order') ." set status_refund='$status_refund', refund_money_2='$refund_money_2', refund_type='$_REQUEST[refund_type]', refund_desc='$refund_desc' where back_id='$back_id' ";
|
|
|
$db->query($sql2);
|
|
|
|
|
|
/* 退回用户余额 */
|
|
|
if ($_REQUEST['refund_type'] == '1')
|
|
|
{
|
|
|
$desc_back = "订单". $order['order_id'] .'退款';
|
|
|
log_account_change($order['user_id'], $refund_money_2,0,0,0, $desc_back );
|
|
|
}
|
|
|
|
|
|
/* 记录log */
|
|
|
back_action($back_id, $order['status_back'], $status_refund, $action_note);
|
|
|
$links[] = array('text' => '返回退款/退货及维修详情', 'href' => 'back.php?act=back_info&back_id=' . $back_id);
|
|
|
sys_msg('恭喜，成功操作！', 1, $links);
|
|
|
}
|
|
|
|
|
|
/* 删除退换货订单 */
|
|
|
elseif ($_REQUEST['act'] == 'remove_back')
|
|
|
{
|
|
|
$back_id = $_REQUEST['back_id'];
|
|
|
/* 删除退货单 */
|
|
|
if(is_array($back_id))
|
|
|
{
|
|
|
$back_id_list = implode(",", $back_id);
|
|
|
$sql = "DELETE FROM ".$ecs->table('back_order'). " WHERE back_id in ($back_id_list)";
|
|
|
$db->query($sql);
|
|
|
$sql = "DELETE FROM ".$ecs->table('back_goods'). " WHERE back_id in ($back_id_list)";
|
|
|
$db->query($sql);
|
|
|
}
|
|
|
else
|
|
|
{
|
|
|
$sql = "DELETE FROM ".$ecs->table('back_order'). " WHERE back_id = '$back_id'";
|
|
|
$db->query($sql);
|
|
|
$sql = "DELETE FROM ".$ecs->table('back_goods'). " WHERE back_id = '$back_id'";
|
|
|
$db->query($sql);
|
|
|
}
|
|
|
//echo $sql;
|
|
|
|
|
|
/* 返回 */
|
|
|
sys_msg('恭喜，记录删除成功！', 0, array(array('href'=>'back.php?act=back_list' , 'text' =>'返回退款/退货及维修列表')));
|
|
|
}
|
|
|
|
|
|
/* 回复客户留言 */
|
|
|
elseif ($_REQUEST['act'] == 'replay')
|
|
|
{
|
|
|
$back_id = intval($_REQUEST['back_id']);
|
|
|
$message = $_POST['message'];
|
|
|
$add_time = gmtime();
|
|
|
|
|
|
$db->query("INSERT INTO ".$ecs->table('back_replay')." (back_id, message, add_time) VALUES ('$back_id', '$message', '$add_time')");
|
|
|
|
|
|
sys_msg('恭喜，回复成功！', 0, array(array('href'=>'back.php?act=back_info&back_id='.$back_id , 'text' =>'返回')));
|
|
|
|
|
|
}
|
|
|
|
|
|
|
|
|
/**
|
|
|
* 获取退货单列表信息
|
|
|
*
|
|
|
* @access public
|
|
|
* @param
|
|
|
*
|
|
|
* @return void
|
|
|
*/
|
|
|
function back_list()
|
|
|
{
|
|
|
$result = get_filter();
|
|
|
if ($result === false)
|
|
|
{
|
|
|
$aiax = isset($_GET['is_ajax']) ? $_GET['is_ajax'] : 0;
|
|
|
|
|
|
/* 过滤信息 */
|
|
|
$filter['delivery_sn'] = empty($_REQUEST['delivery_sn']) ? '' : trim($_REQUEST['delivery_sn']);
|
|
|
$filter['order_sn'] = empty($_REQUEST['order_sn']) ? '' : trim($_REQUEST['order_sn']);
|
|
|
$filter['order_id'] = empty($_REQUEST['order_id']) ? 0 : intval($_REQUEST['order_id']);
|
|
|
$filter['order_type'] = intval($_REQUEST['order_type']);
|
|
|
|
|
|
|
|
|
if ($aiax == 1 && !empty($_REQUEST['consignee']))
|
|
|
{
|
|
|
$_REQUEST['consignee'] = json_str_iconv($_REQUEST['consignee']);
|
|
|
}
|
|
|
$filter['consignee'] = empty($_REQUEST['consignee']) ? '' : trim($_REQUEST['consignee']);
|
|
|
|
|
|
$filter['sort_by'] = empty($_REQUEST['sort_by']) ? 'back_id DESC, update_time' : trim($_REQUEST['sort_by']);
|
|
|
$filter['sort_order'] = empty($_REQUEST['sort_order']) ? 'DESC' : trim($_REQUEST['sort_order']);
|
|
|
|
|
|
$filter['supp'] = (isset($_REQUEST['supp']) && !empty($_REQUEST['supp']) && intval($_REQUEST['supp'])>0) ? intval($_REQUEST['supp']) : 0;
|
|
|
|
|
|
$filter['suppid'] = (isset($_REQUEST['suppid']) && !empty($_REQUEST['suppid']) && intval($_REQUEST['suppid'])>0) ? intval($_REQUEST['suppid']) : 0;
|
|
|
|
|
|
|
|
|
//$where = 'WHERE 1 ';
|
|
|
$where = ($filter['supp']>0) ? 'WHERE b.supplier_id > 0' : 'WHERE b.supplier_id = 0';
|
|
|
|
|
|
if ($filter['suppid']){
|
|
|
//$where .= " AND o.supplier_id = ".$filter['suppid'];
|
|
|
$where = 'WHERE b.supplier_id = '.$filter['suppid'];
|
|
|
}
|
|
|
if ($filter['order_sn'])
|
|
|
{
|
|
|
$where .= " AND order_sn LIKE '%" . mysql_like_quote($filter['order_sn']) . "%'";
|
|
|
}
|
|
|
if ($filter['consignee'])
|
|
|
{
|
|
|
$where .= " AND consignee LIKE '%" . mysql_like_quote($filter['consignee']) . "%'";
|
|
|
}
|
|
|
if ($filter['delivery_sn'])
|
|
|
{
|
|
|
$where .= " AND delivery_sn LIKE '%" . mysql_like_quote($filter['delivery_sn']) . "%'";
|
|
|
}
|
|
|
if ($filter['order_type'] == 2)
|
|
|
{
|
|
|
$where .= " AND status_back != 3 ";
|
|
|
}
|
|
|
if ($filter['order_type'] == 3)
|
|
|
{
|
|
|
$where .= " AND status_back = 3 ";
|
|
|
}
|
|
|
|
|
|
/* 获取管理员信息 */
|
|
|
$admin_info = admin_info();
|
|
|
|
|
|
/* 如果管理员属于某个办事处，只列出这个办事处管辖的发货单 */
|
|
|
if ($admin_info['agency_id'] > 0)
|
|
|
{
|
|
|
$where .= " AND agency_id = '" . $admin_info['agency_id'] . "' ";
|
|
|
}
|
|
|
|
|
|
/* 如果管理员属于某个供货商，只列出这个供货商的发货单 */
|
|
|
if ($admin_info['suppliers_id'] > 0)
|
|
|
{
|
|
|
$where .= " AND suppliers_id = '" . $admin_info['suppliers_id'] . "' ";
|
|
|
}
|
|
|
|
|
|
/* 分页大小 */
|
|
|
$filter['page'] = empty($_REQUEST['page']) || (intval($_REQUEST['page']) <= 0) ? 1 : intval($_REQUEST['page']);
|
|
|
|
|
|
if (isset($_REQUEST['page_size']) && intval($_REQUEST['page_size']) > 0)
|
|
|
{
|
|
|
$filter['page_size'] = intval($_REQUEST['page_size']);
|
|
|
}
|
|
|
elseif (isset($_COOKIE['ECSCP']['page_size']) && intval($_COOKIE['ECSCP']['page_size']) > 0)
|
|
|
{
|
|
|
$filter['page_size'] = intval($_COOKIE['ECSCP']['page_size']);
|
|
|
}
|
|
|
else
|
|
|
{
|
|
|
$filter['page_size'] = 15;
|
|
|
}
|
|
|
|
|
|
/* 记录总数 */
|
|
|
$sql = "SELECT COUNT(*) FROM " . $GLOBALS['ecs']->table('back_order') ." AS b ". $where;
|
|
|
$filter['record_count'] = $GLOBALS['db']->getOne($sql);
|
|
|
$filter['page_count'] = $filter['record_count'] > 0 ? ceil($filter['record_count'] / $filter['page_size']) : 1;
|
|
|
|
|
|
/* 查询 */
|
|
|
if($filter['supp']){
|
|
|
$sql = "SELECT b.*,s.supplier_name FROM " . $GLOBALS['ecs']->table("back_order") . " AS b LEFT JOIN ". $GLOBALS['ecs']->table("supplier") ." AS s ON b.supplier_id=s.supplier_id ".
|
|
|
" $where ORDER BY " . $filter['sort_by'] . " " . $filter['sort_order'].
|
|
|
" LIMIT " . ($filter['page'] - 1) * $filter['page_size'] . ", " . $filter['page_size'] . " ";
|
|
|
}else{
|
|
|
$sql = "SELECT * FROM " . $GLOBALS['ecs']->table("back_order") . " AS b ".
|
|
|
" $where ORDER BY " . $filter['sort_by'] . " " . $filter['sort_order'].
|
|
|
" LIMIT " . ($filter['page'] - 1) * $filter['page_size'] . ", " . $filter['page_size'] . " ";
|
|
|
}
|
|
|
|
|
|
set_filter($filter, $sql);
|
|
|
}
|
|
|
else
|
|
|
{
|
|
|
$sql = $result['sql'];
|
|
|
$filter = $result['filter'];
|
|
|
}
|
|
|
|
|
|
$row = $GLOBALS['db']->getAll($sql);
|
|
|
|
|
|
/* 格式化数据 */
|
|
|
foreach ($row AS $key => $value)
|
|
|
{
|
|
|
$row[$key]['return_time'] = local_date($GLOBALS['_CFG']['time_format'], $value['return_time']);
|
|
|
$row[$key]['add_time'] = local_date($GLOBALS['_CFG']['time_format'], $value['add_time']);
|
|
|
$row[$key]['update_time'] = local_date($GLOBALS['_CFG']['time_format'], $value['update_time']);
|
|
|
$row[$key]['refund_money_1'] = price_format($value['refund_money_1']);
|
|
|
$row[$key]['refund_money_2'] = price_format($value['refund_money_2']);
|
|
|
$row[$key]['status_back_val'] = $GLOBALS['_LANG']['bos'][(($value['back_type'] == 4) ? $value['back_type'] : $value['status_back'])]."-" . (($value['back_type'] == 3) ? "申请维修" : $GLOBALS['_LANG']['bps'][$value['status_refund']]);
|
|
|
$row[$key]['goods_url'] = "../".build_uri('goods', array('gid'=>$value['goods_id']), $value['goods_name']);
|
|
|
|
|
|
if ($value['status'] == 1)
|
|
|
{
|
|
|
$row[$key]['status_name'] = $GLOBALS['_LANG']['delivery_status'][1];
|
|
|
}
|
|
|
else
|
|
|
{
|
|
|
$row[$key]['status_name'] = $GLOBALS['_LANG']['delivery_status'][0];
|
|
|
}
|
|
|
}
|
|
|
$arr = array('back' => $row, 'filter' => $filter, 'page_count' => $filter['page_count'], 'record_count' => $filter['record_count']);
|
|
|
|
|
|
return $arr;
|
|
|
}
|
|
|
|
|
|
|
|
|
/**
|
|
|
* 取得退货单信息
|
|
|
* @param int $back_id 退货单 id（如果 back_id > 0 就按 id 查，否则按 sn 查）
|
|
|
* @return array 退货单信息（金额都有相应格式化的字段，前缀是 formated_ ）
|
|
|
*/
|
|
|
function back_order_info($back_id)
|
|
|
{
|
|
|
$return_order = array();
|
|
|
if (empty($back_id) || !is_numeric($back_id))
|
|
|
{
|
|
|
return $return_order;
|
|
|
}
|
|
|
|
|
|
$where = '';
|
|
|
/* 获取管理员信息 */
|
|
|
$admin_info = admin_info();
|
|
|
|
|
|
/* 如果管理员属于某个办事处，只列出这个办事处管辖的发货单 */
|
|
|
if ($admin_info['agency_id'] > 0)
|
|
|
{
|
|
|
$where .= " AND agency_id = '" . $admin_info['agency_id'] . "' ";
|
|
|
}
|
|
|
|
|
|
/* 如果管理员属于某个供货商，只列出这个供货商的发货单 */
|
|
|
if ($admin_info['suppliers_id'] > 0)
|
|
|
{
|
|
|
$where .= " AND suppliers_id = '" . $admin_info['suppliers_id'] . "' ";
|
|
|
}
|
|
|
|
|
|
$sql = "SELECT * FROM " . $GLOBALS['ecs']->table('back_order') . "
|
|
|
WHERE back_id = '$back_id'
|
|
|
$where
|
|
|
LIMIT 0, 1";
|
|
|
$back = $GLOBALS['db']->getRow($sql);
|
|
|
if ($back)
|
|
|
{
|
|
|
/* 格式化金额字段 */
|
|
|
$back['formated_insure_fee'] = price_format($back['insure_fee'], false);
|
|
|
$back['formated_shipping_fee'] = price_format($back['shipping_fee'], false);
|
|
|
|
|
|
/* 格式化时间字段 */
|
|
|
$back['formated_add_time'] = local_date($GLOBALS['_CFG']['time_format'], $back['add_time']);
|
|
|
|
|
|
/* 退换货状态 退款状态 */
|
|
|
|
|
|
|
|
|
$return_order = $back;
|
|
|
}
|
|
|
|
|
|
return $return_order;
|
|
|
}
|
|
|
|
|
|
/**
|
|
|
* 返回某个订单可执行的操作列表
|
|
|
*/
|
|
|
function operable_list($order)
|
|
|
{
|
|
|
$os = $order['status_back'];
|
|
|
$ds = $order['status_refund'];
|
|
|
/* 根据状态返回可执行操作 */
|
|
|
$list = array( 'ok' => true,
|
|
|
'no' => true,
|
|
|
'confirm' => true,
|
|
|
'refund' => true,
|
|
|
'backshipping' => true,
|
|
|
'backfinish' => true );
|
|
|
if ($os != 5)
|
|
|
{
|
|
|
$list['ok']=false;
|
|
|
$list['no']=false;
|
|
|
}
|
|
|
if ($os == '1' || $os == '2' || $os == '3' || $ds == '1')
|
|
|
{
|
|
|
$list['confirm']=false;
|
|
|
if ($os=='2')
|
|
|
{
|
|
|
$list['backshipping']=false;
|
|
|
}
|
|
|
if ($os=='3')
|
|
|
{
|
|
|
$list['refund']=false;
|
|
|
$list['backshipping']=false;
|
|
|
$list['backfinish']=false;
|
|
|
}
|
|
|
}
|
|
|
if($ds=='9' || $ds=='1')
|
|
|
{
|
|
|
$list['refund']=false;
|
|
|
}
|
|
|
return $list;
|
|
|
}
|
|
|
|
|
|
/* 更新退换货订单状态 */
|
|
|
function update_back($back_id, $status_back, $status_refund )
|
|
|
{
|
|
|
$setsql = "";
|
|
|
if ($status_back)
|
|
|
{
|
|
|
$setsql .= $setsql ? "," : "";
|
|
|
$setsql .= "status_back='$status_back'";
|
|
|
}
|
|
|
if ($status_refund)
|
|
|
{
|
|
|
$setsql .= $setsql ? "," : "";
|
|
|
$setsql .= "status_refund='$status_refund'";
|
|
|
}
|
|
|
$sql = "update ". $GLOBALS['ecs']->table('back_order') ." set $setsql where back_id='$back_id' ";
|
|
|
$GLOBALS['db']->query($sql);
|
|
|
|
|
|
if($status_back =='5') //通过申请
|
|
|
{
|
|
|
$status_b = $GLOBALS['db']->getOne("select back_type from " . $GLOBALS['ecs']->table('back_order') . " where back_id='$back_id'");
|
|
|
$status_b = ($status_b == 4) ? 4 : 0;
|
|
|
$status_bo = $GLOBALS['db']->getOne("select order_sn from " . $GLOBALS['ecs']->table('back_order') . " where back_id='$back_id'");
|
|
|
$close_order = $GLOBALS['db']->getOne("select shipping_status from " . $GLOBALS['ecs']->table('order_info') . " where order_sn = '" . $status_bo . "'");
|
|
|
if ($close_order < 1)
|
|
|
{
|
|
|
$sql3="update ". $GLOBALS['ecs']->table('order_info') ." set order_status='2', to_buyer='用户对订单内的部分或全部產品申请退款并取消订单' where order_sn = '" . $status_bo . "'";
|
|
|
$GLOBALS['db']->query($sql3);
|
|
|
}
|
|
|
|
|
|
$sql="update ". $GLOBALS['ecs']->table('back_goods') ." set status_back='$status_b' where back_id='$back_id' ";
|
|
|
$GLOBALS['db']->query($sql);
|
|
|
$sql2="update ". $GLOBALS['ecs']->table('back_order') ." set status_back='$status_b' where back_id='$back_id' ";
|
|
|
$GLOBALS['db']->query($sql2);
|
|
|
}
|
|
|
if($status_back =='6') //拒绝申请
|
|
|
{
|
|
|
$sql="update ". $GLOBALS['ecs']->table('back_goods') ." set status_back='$status_back' where back_id='$back_id' ";
|
|
|
$GLOBALS['db']->query($sql);
|
|
|
$sql2="update ". $GLOBALS['ecs']->table('back_order') ." set status_back='$status_back' where back_id='$back_id' ";
|
|
|
$GLOBALS['db']->query($sql2);
|
|
|
}
|
|
|
|
|
|
if($status_back =='1' or $status_back =='3') //收到退换回的货物，完成退换货
|
|
|
{
|
|
|
$sql="update ". $GLOBALS['ecs']->table('back_goods') ." set status_back='$status_back' where back_id='$back_id' ";
|
|
|
$GLOBALS['db']->query($sql);
|
|
|
$sql2="UPDATE ". $GLOBALS['ecs']->table('back_order') ." SET status_back='$status_back' WHERE back_id='$back_id' ";
|
|
|
$GLOBALS['db']->query($sql2);
|
|
|
|
|
|
$get_order_id = $GLOBALS['db']->getOne("SELECT order_id FROM " . $GLOBALS['ecs']->table('back_order') . " WHERE back_id = '" . $back_id . "'");
|
|
|
$get_goods_id = $GLOBALS['db']->getCol("SELECT goods_id FROM " . $GLOBALS['ecs']->table('back_order') . " WHERE order_id = '" . $get_order_id . "' AND status_back = '3' AND back_type <> '3'");
|
|
|
if (count($get_goods_id) > 0)
|
|
|
{
|
|
|
$get_goods_id_c = (count($get_goods_id) == 1 ? ("<> '" . implode(',', $get_goods_id) . "'") : ("NOT IN (" . implode(',', $get_goods_id) . ")"));
|
|
|
$no_back = $GLOBALS['db']->getOne("SELECT COUNT(rec_id) FROM " . $GLOBALS['ecs']->table('order_goods') . " WHERE order_id = '" . $get_order_id . "' AND goods_id " . $get_goods_id_c);
|
|
|
if ($no_back == 0)
|
|
|
{
|
|
|
$sql3="UPDATE ". $GLOBALS['ecs']->table('order_info') ." SET order_status='2' WHERE order_id='" . $get_order_id . "' ";
|
|
|
$GLOBALS['db']->query($sql3);
|
|
|
}
|
|
|
}
|
|
|
$get_goods_info = $GLOBALS['db']->getRow("SELECT goods_id, back_type FROM " . $GLOBALS['ecs']->table('back_goods') . " WHERE back_id = '" . $back_id . "'");
|
|
|
if ($status_back == '3' && $get_goods_info['back_type'] != '3') // 退款退货完成时，改变订单中產品的is_back值
|
|
|
{
|
|
|
$sql4 = "UPDATE " .$GLOBALS['ecs']->table('order_goods') . " SET is_back = 1 WHERE goods_id = '" . $get_goods_info['goods_id'] . "' AND order_id = '" . $get_order_id . "'";
|
|
|
$GLOBALS['db']->query($sql4);
|
|
|
|
|
|
//退款完成后，进行返库
|
|
|
$back_type = $GLOBALS['db']->getOne("SELECT back_type FROM " . $GLOBALS['ecs']->table('back_order') . " WHERE back_id = '" . $back_id . "'");
|
|
|
$stock_dec_time = $GLOBALS['db']->getOne("SELECT value FROM " . $GLOBALS['ecs']->table('shop_config') . " WHERE code = 'stock_dec_time'");
|
|
|
if ($back_type == 4 && $stock_dec_time == 1)
|
|
|
{
|
|
|
$back_go = $GLOBALS['db']->getAll("SELECT * FROM " . $GLOBALS['ecs']->table('order_goods') . " WHERE order_id = " . $get_order_id);
|
|
|
foreach($back_go as $back_g)
|
|
|
{
|
|
|
if ($back_g['product_id'] > 0)
|
|
|
{
|
|
|
$GLOBALS['db']->query("UPDATE " . $GLOBALS['ecs']->table('products') . " SET product_number = product_number + " . $back_g['goods_number'] . " WHERE product_id = " . $back_g['product_id']);
|
|
|
}
|
|
|
$GLOBALS['db']->query("UPDATE " . $GLOBALS['ecs']->table('goods') . " SET goods_number = goods_number + " . $back_g['goods_number'] . " WHERE goods_id = " . $back_g['goods_id']);
|
|
|
}
|
|
|
}
|
|
|
}
|
|
|
}
|
|
|
if($status_back =='2') //换出產品寄回
|
|
|
{
|
|
|
$sql="update ". $GLOBALS['ecs']->table('back_goods') ." set status_back='$status_back' where back_type in(1,2,3) and back_id='$back_id' ";
|
|
|
$GLOBALS['db']->query($sql);
|
|
|
}
|
|
|
if($status_refund=='1') //退款
|
|
|
{
|
|
|
$sql="update ". $GLOBALS['ecs']->table('back_goods') ." set status_refund='$status_refund' where back_type ='0' and back_id='$back_id' ";
|
|
|
$GLOBALS['db']->query($sql);
|
|
|
}
|
|
|
}
|
|
|
|
|
|
function back_action($back_id, $status_back, $status_refund, $note = '', $username = null)
|
|
|
{
|
|
|
if (is_null($username))
|
|
|
{
|
|
|
$username = $_SESSION['admin_name'];
|
|
|
}
|
|
|
|
|
|
$sql = 'INSERT INTO ' . $GLOBALS['ecs']->table('back_action') .
|
|
|
' (back_id, action_user, status_back, status_refund, action_note, log_time) ' .
|
|
|
'SELECT ' .
|
|
|
"$back_id, '$username', '$status_back', '$status_refund', '$note', '" .gmtime() . "' " .
|
|
|
'FROM ' . $GLOBALS['ecs']->table('back_order') . " WHERE back_id = '$back_id'";
|
|
|
$GLOBALS['db']->query($sql);
|
|
|
}
|
|
|
|
|
|
/**
|
|
|
* 取得入驻商列表
|
|
|
* @return array 二维数组
|
|
|
*/
|
|
|
function get_supplier_list()
|
|
|
{
|
|
|
$sql = 'SELECT *
|
|
|
FROM ' . $GLOBALS['ecs']->table('supplier') . '
|
|
|
WHERE status=1
|
|
|
ORDER BY supplier_name ASC';
|
|
|
$res = $GLOBALS['db']->getAll($sql);
|
|
|
|
|
|
if (!is_array($res))
|
|
|
{
|
|
|
$res = array();
|
|
|
}
|
|
|
|
|
|
return $res;
|
|
|
}
|
|
|
|
|
|
?>
|
