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.
778 lines
30 KiB
778 lines
30 KiB
<?php
|
|
|
|
/**
|
|
* ECSHOP 管理中心服务站管理
|
|
* ============================================================================
|
|
* * 版权所有 2005-2016 上海商创网络科技有限公司，并保留所有权利。
|
|
* 网站地址: http://www.ecmoban.com；
|
|
* ----------------------------------------------------------------------------
|
|
* 这不是一个自由软件！您只能在不用于商业目的的前提下对程序代码进行修改和
|
|
* 使用；不允许对程序代码以任何形式任何目的的再发布。
|
|
* ============================================================================
|
|
* $Author: wanglei $
|
|
* $Id: suppliers_server.php 15013 2009-05-13 09:31:42Z wanglei $
|
|
*/
|
|
|
|
define('IN_ECS', true);
|
|
|
|
require(dirname(__FILE__) . '/includes/init.php');
|
|
require_once(ROOT_PATH . 'includes/lib_order.php');
|
|
|
|
define('SUPPLIERS_ACTION_LIST', 'delivery_view,back_view');
|
|
|
|
//ecmoban模板堂 --zhuo start
|
|
$adminru = get_admin_ru_id();
|
|
if($adminru['ru_id'] == 0){
|
|
$smarty->assign('priv_ru', 1);
|
|
}else{
|
|
$smarty->assign('priv_ru', 0);
|
|
}
|
|
//ecmoban模板堂 --zhuo end
|
|
|
|
/*------------------------------------------------------ */
|
|
//-- 服务站列表
|
|
/*------------------------------------------------------ */
|
|
if ($_REQUEST['act'] == 'list')
|
|
{
|
|
/* 检查权限 */
|
|
admin_priv('merchants_commission');
|
|
|
|
/* 模板赋值 */
|
|
$smarty->assign('ur_here', $_LANG['brokerage_amount_list']); // 当前导航
|
|
|
|
$store_list = get_common_store_list();
|
|
$smarty->assign('store_list', $store_list);
|
|
|
|
$result = merchants_commission_list();
|
|
|
|
/* 获得该管理员的权限 */
|
|
$priv_str = $db->getOne("SELECT action_list FROM " .$ecs->table('admin_user'). " WHERE user_id = " . $_SESSION['admin_id']);
|
|
|
|
/* 如果被编辑的管理员拥有了all这个权限，将不能编辑 */
|
|
if ($priv_str != 'all')
|
|
{
|
|
/* 查询 */
|
|
$smarty->assign('no_all', 0);
|
|
$ser_name = $_LANG['suppliers_list_server'];
|
|
}else{
|
|
/* 查询 */
|
|
$smarty->assign('no_all', 1);
|
|
$smarty->assign('action_link', array('href' => 'merchants_commission.php?act=add', 'text' => $_LANG['add_suppliers_server']));
|
|
$smarty->assign('action_link2', array('href' => 'merchants_percent.php?act=list', 'text' => $_LANG['suppliers_percent_list']));
|
|
$ser_name = $_LANG['suppliers_server_center'];
|
|
}
|
|
|
|
$smarty->assign('full_page', 1); // 翻页参数
|
|
|
|
$smarty->assign('merchants_commission_list', $result['result']);
|
|
$smarty->assign('filter', $result['filter']);
|
|
$smarty->assign('record_count', $result['record_count']);
|
|
$smarty->assign('page_count', $result['page_count']);
|
|
$smarty->assign('sort_suppliers_id', '<img src="images/sort_desc.gif">');
|
|
|
|
/* 显示模板 */
|
|
assign_query_info();
|
|
$smarty->display('merchants_commission_list.htm');
|
|
}
|
|
|
|
/*------------------------------------------------------ */
|
|
//-- 排序、分页、查询
|
|
/*------------------------------------------------------ */
|
|
elseif ($_REQUEST['act'] == 'query')
|
|
{
|
|
check_authz_json('merchants_commission');
|
|
|
|
/* 获得该管理员的权限 */
|
|
$priv_str = $db->getOne("SELECT action_list FROM " .$ecs->table('admin_user'). " WHERE user_id = " . $_SESSION['admin_id']);
|
|
|
|
/* 如果被编辑的管理员拥有了all这个权限，将不能编辑 */
|
|
if ($priv_str != 'all')
|
|
{
|
|
$smarty->assign('no_all', 0);
|
|
$ser_name = $_LANG['suppliers_list_server'];
|
|
}else{
|
|
$smarty->assign('no_all', 1);
|
|
}
|
|
|
|
$store_list = get_common_store_list();
|
|
$smarty->assign('store_list', $store_list);
|
|
|
|
/* 查询 */
|
|
$result = merchants_commission_list();
|
|
|
|
$smarty->assign('merchants_commission_list', $result['result']);
|
|
$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('merchants_commission_list.htm'), '',
|
|
array('filter' => $result['filter'], 'page_count' => $result['page_count']));
|
|
}
|
|
|
|
/*------------------------------------------------------ */
|
|
//-- 列表页编辑名称
|
|
/*------------------------------------------------------ */
|
|
elseif ($_REQUEST['act'] == 'edit_suppliers_ser_name')
|
|
{
|
|
check_authz_json('merchants_commission');
|
|
|
|
$id = intval($_POST['id']);
|
|
$name = json_str_iconv(trim($_POST['val']));
|
|
|
|
/* 判断名称是否重复 */
|
|
$sql = "SELECT suppliers_ser_id
|
|
FROM " . $ecs->table('merchants_server') . "
|
|
WHERE suppliers_name = '$name'
|
|
AND suppliers_ser_id <> '$id' ";
|
|
if ($db->getOne($sql))
|
|
{
|
|
make_json_error(sprintf($_LANG['suppliers_name_exist'], $name));
|
|
}
|
|
else
|
|
{
|
|
/* 保存服务站信息 */
|
|
$sql = "UPDATE " . $ecs->table('merchants_server') . "
|
|
SET suppliers_name = '$name'
|
|
WHERE suppliers_ser_id = '$id'";
|
|
if ($result = $db->query($sql))
|
|
{
|
|
/* 记日志 */
|
|
admin_log($name, 'edit', 'suppliers_ser');
|
|
|
|
clear_cache_files();
|
|
|
|
make_json_result(stripslashes($name));
|
|
}
|
|
else
|
|
{
|
|
make_json_result(sprintf($_LANG['agency_edit_fail'], $name));
|
|
}
|
|
}
|
|
}
|
|
|
|
/*------------------------------------------------------ */
|
|
//-- 删除服务站
|
|
/*------------------------------------------------------ */
|
|
elseif ($_REQUEST['act'] == 'remove')
|
|
{
|
|
check_authz_json('merchants_commission');
|
|
|
|
$id = intval($_REQUEST['id']);
|
|
|
|
$sql = "DELETE FROM " . $ecs->table('merchants_server') . "
|
|
WHERE server_id = '$id'";
|
|
$db->query($sql);
|
|
|
|
/* 清除缓存 */
|
|
clear_cache_files();
|
|
|
|
$url = 'merchants_commission.php?act=query&' . str_replace('act=remove', '', $_SERVER['QUERY_STRING']);
|
|
ecs_header("Location: $url\n");
|
|
|
|
exit;
|
|
}
|
|
|
|
/*------------------------------------------------------ */
|
|
//-- 批量操作
|
|
/*------------------------------------------------------ */
|
|
elseif ($_REQUEST['act'] == 'batch')
|
|
{
|
|
/* 取得要操作的记录编号 */
|
|
if (empty($_POST['checkboxes']))
|
|
{
|
|
sys_msg($_LANG['no_record_selected']);
|
|
}
|
|
else
|
|
{
|
|
/* 检查权限 */
|
|
admin_priv('merchants_commission');
|
|
|
|
$ids = $_POST['checkboxes'];
|
|
|
|
if (isset($_POST['remove']))
|
|
{
|
|
$sql = "SELECT *
|
|
FROM " . $ecs->table('merchants_server') . "
|
|
WHERE suppliers_ser_id " . db_create_in($ids);
|
|
$suppliers = $db->getAll($sql);
|
|
|
|
foreach ($suppliers as $key => $value)
|
|
{
|
|
/* 判断服务站是否存在订单 */
|
|
$sql = "SELECT COUNT(*)
|
|
FROM " . $ecs->table('order_info') . "AS O, " . $ecs->table('order_goods') . " AS OG, " . $ecs->table('goods') . " AS G
|
|
WHERE O.order_id = OG.order_id
|
|
AND OG.goods_id = G.goods_id
|
|
AND G.suppliers_ser_id = '" . $value['suppliers_ser_id'] . "'";
|
|
$order_exists = $db->getOne($sql, TRUE);
|
|
if ($order_exists > 0)
|
|
{
|
|
unset($suppliers[$key]);
|
|
}
|
|
|
|
/* 判断服务站是否存在商品 */
|
|
$sql = "SELECT COUNT(*)
|
|
FROM " . $ecs->table('goods') . "AS G
|
|
WHERE G.suppliers_ser_id = '" . $value['suppliers_ser_id'] . "'";
|
|
$goods_exists = $db->getOne($sql, TRUE);
|
|
if ($goods_exists > 0)
|
|
{
|
|
unset($suppliers[$key]);
|
|
}
|
|
}
|
|
if (empty($suppliers))
|
|
{
|
|
sys_msg($_LANG['batch_drop_no']);
|
|
}
|
|
|
|
|
|
$sql = "DELETE FROM " . $ecs->table('merchants_server') . "
|
|
WHERE suppliers_ser_id " . db_create_in($ids);
|
|
$db->query($sql);
|
|
|
|
/* 更新管理员、发货单关联、退货单关联和订单关联的服务站 */
|
|
$table_array = array('admin_user', 'delivery_order', 'back_order');
|
|
foreach ($table_array as $value)
|
|
{
|
|
$sql = "DELETE FROM " . $ecs->table($value) . " WHERE suppliers_ser_id " . db_create_in($ids) . " ";
|
|
$db->query($sql, 'SILENT');
|
|
}
|
|
|
|
/* 记日志 */
|
|
$suppliers_names = '';
|
|
foreach ($suppliers as $value)
|
|
{
|
|
$suppliers_names .= $value['suppliers_name'] . '|';
|
|
}
|
|
admin_log($suppliers_names, 'remove', 'suppliers_ser');
|
|
|
|
/* 清除缓存 */
|
|
clear_cache_files();
|
|
|
|
sys_msg($_LANG['batch_drop_ok']);
|
|
}
|
|
}
|
|
}
|
|
|
|
/*------------------------------------------------------ */
|
|
//-- 添加、编辑服务站
|
|
/*------------------------------------------------------ */
|
|
elseif (in_array($_REQUEST['act'], array('add', 'edit')))
|
|
{
|
|
/* 检查权限 */
|
|
admin_priv('merchants_commission');
|
|
|
|
$smarty->assign('action_link', array('href' => 'merchants_commission.php?act=list', 'text' => $_LANG['suppliers_list_server']));
|
|
if ($_REQUEST['act'] == 'add')
|
|
{
|
|
|
|
$user_list = get_merchants_user_list();
|
|
$suppliers_percent = get_suppliers_percent(); //管理员获取佣金百分比
|
|
|
|
$smarty->assign('ur_here', $_LANG['add_suppliers_server']);
|
|
$smarty->assign('form_action', 'insert');
|
|
$smarty->assign('suppliers_percent', $suppliers_percent);
|
|
$smarty->assign('user_list', $user_list);
|
|
|
|
assign_query_info();
|
|
|
|
$smarty->display('merchants_commission_info.htm');
|
|
|
|
}
|
|
elseif ($_REQUEST['act'] == 'edit')
|
|
{
|
|
$suppliers = array();
|
|
|
|
/* 取得服务站信息 */
|
|
$id = $_REQUEST['id'];
|
|
|
|
$sql = "SELECT * FROM " . $ecs->table('merchants_server') . " WHERE server_id = '$id'";
|
|
$suppliers = $db->getRow($sql);
|
|
if (count($suppliers) <= 0)
|
|
{
|
|
sys_msg('suppliers does not exist');
|
|
}
|
|
|
|
$user_list = get_merchants_user_list();
|
|
$suppliers_percent = get_suppliers_percent(); //管理员获取佣金百分比
|
|
|
|
$date = array('user_id', 'suppliers_percent', 'suppliers_desc');
|
|
$server = get_table_date('merchants_server', "server_id = '$id'", $date);
|
|
|
|
$smarty->assign('ur_here', $_LANG['edit_suppliers_server']);
|
|
|
|
$smarty->assign('form_action', 'update');
|
|
$smarty->assign('user_list', $user_list);
|
|
$smarty->assign('id', $id);
|
|
$smarty->assign('server', $server);
|
|
$smarty->assign('suppliers_percent', $suppliers_percent);
|
|
|
|
assign_query_info();
|
|
|
|
$smarty->display('merchants_commission_info.htm');
|
|
}
|
|
|
|
}
|
|
|
|
/*------------------------------------------------------ */
|
|
//-- 提交添加、编辑服务站
|
|
/*------------------------------------------------------ */
|
|
elseif (in_array($_REQUEST['act'], array('insert', 'update')))
|
|
{
|
|
/* 检查权限 */
|
|
admin_priv('merchants_commission');
|
|
|
|
if ($_REQUEST['act'] == 'insert')
|
|
{
|
|
/* 提交值 */
|
|
$suppliers = array('user_id' => intval($_POST['merchants_name']),
|
|
'suppliers_desc' => trim($_POST['suppliers_desc']),
|
|
'suppliers_percent' => intval($_POST['merchants_percent'])
|
|
);
|
|
|
|
|
|
|
|
/* 判断名称是否重复 */
|
|
$sql = "SELECT server_id
|
|
FROM " . $ecs->table('merchants_server') . "
|
|
WHERE user_id = '" . $suppliers['user_id'] . "' ";
|
|
if ($db->getOne($sql))
|
|
{
|
|
sys_msg($_LANG['suppliers_name_exist']);
|
|
}
|
|
|
|
$db->autoExecute($ecs->table('merchants_server'), $suppliers, 'INSERT');
|
|
$suppliers['server_id'] = $db->insert_id();
|
|
|
|
/* 记日志 */
|
|
admin_log($suppliers['merchants_name'], 'add', 'merchants_server');
|
|
|
|
/* 清除缓存 */
|
|
clear_cache_files();
|
|
|
|
/* 提示信息 */
|
|
$links = array(array('href' => 'merchants_commission.php?act=add', 'text' => $_LANG['continue_add_server_suppliers']),
|
|
array('href' => 'merchants_commission.php?act=list', 'text' => $_LANG['back_suppliers_server_list'])
|
|
);
|
|
sys_msg($_LANG['add_suppliers_server_ok'], 0, $links);
|
|
|
|
}
|
|
|
|
if ($_REQUEST['act'] == 'update')
|
|
{
|
|
/* 提交值 */
|
|
$suppliers = array('id' => trim($_POST['id']));
|
|
|
|
$suppliers['new'] = array('user_id' => intval($_POST['merchants_name']),
|
|
'suppliers_desc' => trim($_POST['suppliers_desc']),
|
|
'suppliers_percent' => intval($_POST['merchants_percent'])
|
|
);
|
|
|
|
/* 判断名称是否重复 */
|
|
$sql = "SELECT server_id
|
|
FROM " . $ecs->table('merchants_server') . "
|
|
WHERE user_id = '" . $suppliers['new']['merchants_name'] . "'
|
|
AND server_id <> '" . $suppliers['id'] . "'";
|
|
if ($db->getOne($sql))
|
|
{
|
|
sys_msg($_LANG['suppliers_name_exist']);
|
|
}
|
|
|
|
/* 保存服务站信息 */
|
|
$db->autoExecute($ecs->table('merchants_server'), $suppliers['new'], 'UPDATE', "server_id = '" . $suppliers['id'] . "'");
|
|
|
|
/* 清除缓存 */
|
|
clear_cache_files();
|
|
|
|
/* 提示信息 */
|
|
$links[] = array('href' => 'merchants_commission.php?act=list', 'text' => $_LANG['back_suppliers_server_list']);
|
|
sys_msg($_LANG['edit_suppliers_server_ok'], 0, $links);
|
|
}
|
|
|
|
}
|
|
|
|
/*------------------------------------------------------ */
|
|
//-- 商家订单别表
|
|
/*------------------------------------------------------ */
|
|
elseif($_REQUEST['act'] == 'order_list')
|
|
{
|
|
/* 检查权限 */
|
|
admin_priv('merchants_commission');
|
|
|
|
$user_id = isset($_REQUEST['id']) ? intval($_REQUEST['id']) : 0;
|
|
$_SESSION['order_userId'] = $user_id;
|
|
|
|
$date = array('suppliers_percent');
|
|
$percent_id = get_table_date('merchants_server', "user_id = '$user_id' ", $date, $sqlType = 2);
|
|
|
|
$date = array('percent_value');
|
|
$percent_value = get_table_date('merchants_percent', "percent_id = '$percent_id'", $date, $sqlType = 2) . '%';
|
|
$smarty->assign('percent_value', $percent_value);
|
|
|
|
if($adminru['ru_id'] > 0){
|
|
$smarty->assign('no_all', 0);
|
|
}else{
|
|
$smarty->assign('no_all', 1);
|
|
}
|
|
|
|
/* 模板赋值 */
|
|
$smarty->assign('ur_here', $_LANG['brokerage_order_list']); // 当前导航
|
|
$smarty->assign('full_page', 1); // 翻页参数
|
|
|
|
$order_list = merchants_order_list($user_id);
|
|
|
|
$smarty->assign('order_list', $order_list['orders']);
|
|
$smarty->assign('filter', $order_list['filter']);
|
|
$smarty->assign('record_count', $order_list['record_count']);
|
|
$smarty->assign('page_count', $order_list['page_count']);
|
|
$smarty->assign('server_id', '<img src="images/sort_desc.gif">');
|
|
|
|
/* 显示模板 */
|
|
assign_query_info();
|
|
$smarty->display('merchants_order_list.htm');
|
|
}
|
|
|
|
/*------------------------------------------------------ */
|
|
//-- 排序、分页、查询
|
|
/*------------------------------------------------------ */
|
|
elseif ($_REQUEST['act'] == 'order_query')
|
|
{
|
|
check_authz_json('merchants_commission');
|
|
|
|
$user_id = $_SESSION['order_userId'];
|
|
$order_list = merchants_order_list($user_id);
|
|
|
|
$date = array('suppliers_percent');
|
|
$percent_id = get_table_date('merchants_server', "user_id = '$user_id' ", $date, $sqlType = 2);
|
|
|
|
$date = array('percent_value');
|
|
$percent_value = get_table_date('merchants_percent', "percent_id = '$percent_id'", $date, $sqlType = 2) . '%';
|
|
$smarty->assign('percent_value', $percent_value);
|
|
|
|
$smarty->assign('order_list', $order_list['orders']);
|
|
$smarty->assign('filter', $order_list['filter']);
|
|
$smarty->assign('record_count', $order_list['record_count']);
|
|
$smarty->assign('page_count', $order_list['page_count']);
|
|
|
|
/* 排序标记 */
|
|
$sort_flag = sort_flag($order_list['filter']);
|
|
$smarty->assign($sort_flag['tag'], $sort_flag['img']);
|
|
|
|
make_json_result($smarty->fetch('merchants_order_list.htm'), '',
|
|
array('filter' => $order_list['filter'], 'page_count' => $order_list['page_count']));
|
|
}
|
|
|
|
/*------------------------------------------------------ */
|
|
//-- 修改结算状态
|
|
/*------------------------------------------------------ */
|
|
elseif ($_REQUEST['act'] == 'toggle_on_settlement')
|
|
{
|
|
check_authz_json('merchants_commission');
|
|
|
|
$order_id = intval($_POST['id']);
|
|
$on_sale = intval($_POST['val']);
|
|
|
|
$sql = "update " .$ecs->table('order_info'). " set is_settlement = '$on_sale' where order_id = '$order_id'";
|
|
$db->query($sql);
|
|
|
|
clear_cache_files();
|
|
make_json_result($on_sale);
|
|
}
|
|
|
|
/*------------------------------------------------------ */
|
|
//-- 查询商家店铺
|
|
/*------------------------------------------------------ */
|
|
elseif ($_REQUEST['act'] == 'query_merchants_info')
|
|
{
|
|
check_authz_json('merchants_commission');
|
|
|
|
$user_id = empty($_REQUEST['user_id']) ? 0 : intval($_REQUEST['user_id']);
|
|
|
|
$date = array('shoprz_brandName, shopNameSuffix');
|
|
$user = get_table_date('merchants_shop_information', "user_id = '$user_id'", $date);
|
|
$user['user_id'] = $user_id;
|
|
|
|
clear_cache_files();
|
|
make_json_result($user);
|
|
}
|
|
|
|
/**
|
|
* 获取商家佣金列表
|
|
*
|
|
* @access public
|
|
* @param
|
|
*
|
|
* @return void
|
|
*/
|
|
function merchants_commission_list()
|
|
{
|
|
$adminru = get_admin_ru_id();
|
|
|
|
$result = get_filter();
|
|
if ($result === false)
|
|
{
|
|
$aiax = isset($_GET['is_ajax']) ? $_GET['is_ajax'] : 0;
|
|
|
|
/* 过滤信息 */
|
|
$filter['sort_by'] = empty($_REQUEST['sort_by']) ? 's.server_id' : trim($_REQUEST['sort_by']);
|
|
$filter['sort_order'] = empty($_REQUEST['sort_order']) ? 'ASC' : trim($_REQUEST['sort_order']);
|
|
|
|
$where = 'WHERE 1 ';
|
|
|
|
if($adminru['ru_id'] > 0){
|
|
$where .= " AND s.user_id = '" .$adminru['ru_id']. "'";
|
|
}
|
|
|
|
//管理员查询的权限 -- 店铺查询 start
|
|
$filter['store_search'] = empty($_REQUEST['store_search']) ? 0 : intval($_REQUEST['store_search']);
|
|
$filter['merchant_id'] = isset($_REQUEST['merchant_id']) ? intval($_REQUEST['merchant_id']) : 0;
|
|
$filter['store_keyword'] = isset($_REQUEST['store_keyword']) ? trim($_REQUEST['store_keyword']) : '';
|
|
|
|
$store_search_where = '';
|
|
if($filter['store_search'] !=0){
|
|
if($adminru['ru_id'] == 0){
|
|
|
|
if($_REQUEST['store_type']){
|
|
$store_search_where = "AND msi.shopNameSuffix = '" .$_REQUEST['store_type']. "'";
|
|
}
|
|
|
|
if($filter['store_search'] == 1){
|
|
$where .= " AND mis.user_id = '" .$filter['merchant_id']. "' ";
|
|
}elseif($filter['store_search'] == 2){
|
|
$where .= " AND mis.rz_shopName LIKE '%" . mysql_like_quote($filter['store_keyword']) . "%'";
|
|
}elseif($filter['store_search'] == 3){
|
|
$where .= " AND mis.shoprz_brandName LIKE '%" . mysql_like_quote($filter['store_keyword']) . "%' " . $store_search_where;
|
|
}
|
|
}
|
|
}
|
|
|
|
$where .= " AND mis.merchants_audit = 1 ";
|
|
//管理员查询的权限 -- 店铺查询 end
|
|
|
|
/* 分页大小 */
|
|
$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('merchants_server') . " as s " .
|
|
" LEFT JOIN " .$GLOBALS['ecs']->table('merchants_shop_information'). " as mis on s.user_id = mis.user_id " . $where;
|
|
$filter['record_count'] = $GLOBALS['db']->getOne($sql);
|
|
$filter['page_count'] = $filter['record_count'] > 0 ? ceil($filter['record_count'] / $filter['page_size']) : 1;
|
|
|
|
/* 查询 */ //ecmoban模板堂 -zhuo suppliers_sn
|
|
$sql = "SELECT u.user_name, mis.*, msf.*, s.server_id, s.user_id, s.suppliers_desc, s.suppliers_percent
|
|
FROM " . $GLOBALS['ecs']->table("merchants_server") . " as s " .
|
|
" LEFT JOIN " .$GLOBALS['ecs']->table('merchants_shop_information'). " as mis on s.user_id = mis.user_id " .
|
|
" LEFT JOIN " .$GLOBALS['ecs']->table('users'). " as u on s.user_id = u.user_id " .
|
|
" LEFT JOIN " .$GLOBALS['ecs']->table('merchants_steps_fields'). " as msf on s.user_id = msf.user_id " .
|
|
" $where " ." group by s.user_id ".
|
|
" 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);
|
|
|
|
$count = count($row);
|
|
for ($i=0; $i<$count; $i++)
|
|
{
|
|
$row[$i]['server_id'] = $row[$i]['server_id'];
|
|
$valid = get_nerchants_order_valid_refund($row[$i]['user_id']); //订单有效总额
|
|
$row[$i]['order_valid_total'] = price_format($valid['total_fee']);
|
|
|
|
$refund = get_nerchants_order_valid_refund($row[$i]['user_id'], 1); //订单退款总额
|
|
$row[$i]['order_refund_total'] = price_format($refund['total_fee']);
|
|
$row[$i]['store_name'] = get_shop_name($row[$i]['user_id'], 1);
|
|
}
|
|
|
|
$arr = array('result' => $row, 'filter' => $filter, 'page_count' => $filter['page_count'], 'record_count' => $filter['record_count']);
|
|
|
|
//get_print_r($arr);
|
|
return $arr;
|
|
}
|
|
|
|
//佣金百分比
|
|
function get_suppliers_percent(){
|
|
$sql = "select percent_id, percent_value from " . $GLOBALS['ecs']->table('merchants_percent') . " where 1 order by sort_order asc";
|
|
$res = $GLOBALS['db']->getAll($sql);
|
|
|
|
return $res;
|
|
}
|
|
|
|
/**
|
|
* 获取商家佣金列表
|
|
*
|
|
* @access public
|
|
* @param
|
|
*
|
|
* @return void
|
|
*/
|
|
function merchants_order_list($user_id = 0)
|
|
{
|
|
$result = get_filter();
|
|
if ($result === false)
|
|
{
|
|
$aiax = isset($_GET['is_ajax']) ? $_GET['is_ajax'] : 0;
|
|
|
|
/* 过滤信息 */
|
|
$filter['sort_by'] = empty($_REQUEST['sort_by']) ? 'o.order_id' : trim($_REQUEST['sort_by']);
|
|
$filter['sort_order'] = empty($_REQUEST['sort_order']) ? 'DESC' : trim($_REQUEST['sort_order']);
|
|
|
|
/* 过滤信息 */
|
|
$filter['start_time'] = empty($_REQUEST['start_time']) ? '' : local_strtotime(trim($_REQUEST['start_time']));
|
|
$filter['end_time'] = empty($_REQUEST['end_time']) ? '' : local_strtotime(trim($_REQUEST['end_time']));
|
|
|
|
$where = 'WHERE 1';
|
|
|
|
if(!empty($filter['start_time'])){
|
|
$where .= " AND o.add_time >= '" .$filter['start_time'] . "'";
|
|
}
|
|
|
|
if(!empty($filter['end_time'])){
|
|
$where .= " AND o.add_time <= '" .$filter['end_time']. "'";
|
|
}
|
|
|
|
/* 分页大小 */
|
|
$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;
|
|
}
|
|
|
|
$where .= order_query_sql('finished', 'o.');
|
|
$where .= " and (select count(*) from " .$GLOBALS['ecs']->table('order_info'). " as oi2 where oi2.main_order_id = o.order_id) = 0 "; //主订单下有子订单时，则主订单不显示
|
|
$where .= " and og.ru_id = '$user_id' group by o.order_id ";
|
|
|
|
/* 记录总数 */
|
|
$sql = "SELECT o.order_id ".
|
|
" FROM " . $GLOBALS['ecs']->table('order_info') . " AS o " .
|
|
" LEFT JOIN " .$GLOBALS['ecs']->table('users'). " AS u ON u.user_id=o.user_id ".
|
|
" LEFT JOIN " .$GLOBALS['ecs']->table('order_goods'). " AS og ON o.order_id=og.order_id ".
|
|
" LEFT JOIN " .$GLOBALS['ecs']->table('goods'). " AS g ON og.goods_id=g.goods_id ".
|
|
$where;
|
|
|
|
$filter['record_count'] = count($GLOBALS['db']->getAll($sql));
|
|
$filter['page_count'] = $filter['record_count'] > 0 ? ceil($filter['record_count'] / $filter['page_size']) : 1;
|
|
|
|
/* 查询 */
|
|
$sql = "SELECT og.ru_id, o.order_id, o.main_order_id, o.order_sn, o.add_time, o.order_status, o.shipping_status, o.order_amount, o.money_paid, o.is_delete, o.is_settlement," .
|
|
"o.shipping_time, o.auto_delivery_time, o.pay_status, o.consignee, o.address, o.email, o.tel, o.extension_code, o.extension_id, " .
|
|
"(" . order_amount_field('o.') . ") AS total_fee, " .
|
|
"IFNULL(u.user_name, '" .$GLOBALS['_LANG']['anonymous']. "') AS buyer ".
|
|
" FROM " . $GLOBALS['ecs']->table('order_info') . " AS o " .
|
|
" LEFT JOIN " .$GLOBALS['ecs']->table('users'). " AS u ON u.user_id=o.user_id ".
|
|
" LEFT JOIN " .$GLOBALS['ecs']->table('order_goods'). " AS og ON o.order_id=og.order_id ".
|
|
" LEFT JOIN " .$GLOBALS['ecs']->table('goods'). " AS g ON og.goods_id=g.goods_id ".
|
|
$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);
|
|
|
|
$count = count($row);
|
|
for ($i=0; $i<$count; $i++)
|
|
{
|
|
$row[$i]['formated_order_amount'] = price_format($row[$i]['order_amount'], true);
|
|
$row[$i]['formated_money_paid'] = price_format($row[$i]['money_paid'], true);
|
|
$row[$i]['formated_total_fee'] = price_format($row[$i]['total_fee'], true);
|
|
$row[$i]['short_order_time'] = local_date('Y-m-d H:i', $row[$i]['add_time']);
|
|
|
|
$date = array('suppliers_percent');
|
|
$percent_id = get_table_date('merchants_server', "user_id = '" .$row[$i]['ru_id']. "' ", $date, $sqlType = 2);
|
|
|
|
$date = array('percent_value');
|
|
$percent_value = get_table_date('merchants_percent', "percent_id = '$percent_id'", $date, $sqlType = 2);
|
|
|
|
if($percent_value == 0){
|
|
$percent_value = 1;
|
|
}else{
|
|
$percent_value = $percent_value/100;
|
|
}
|
|
|
|
$row[$i]['return_amount'] = get_order_return_list($row[$i]['order_id']);
|
|
$row[$i]['formated_return_amount'] = price_format($row[$i]['return_amount'], true);
|
|
$row[$i]['formated_brokerage_amount'] = price_format(($row[$i]['total_fee']-$row[$i]['return_amount']) * $percent_value, true);
|
|
$row[$i]['formated_effective_amount'] = price_format($row[$i]['total_fee']-$row[$i]['return_amount'], true);
|
|
$row['all_brokerage_amount'] += ($row[$i]['total_fee']-$row[$i]['return_amount']) * $percent_value;
|
|
}
|
|
|
|
$row['all_brokerage_amount'] = price_format($row['all_brokerage_amount'], true);
|
|
|
|
$arr = array('orders' => $row, 'filter' => $filter, 'page_count' => $filter['page_count'], 'record_count' => $filter['record_count']);
|
|
|
|
return $arr;
|
|
}
|
|
|
|
//商家订单有效金额和退款金额
|
|
function get_nerchants_order_valid_refund($ru_id, $type = 0){
|
|
|
|
$where = order_query_sql('finished', 'oi.');
|
|
if($type == 1){
|
|
$sql = "SELECT SUM(oreturn.actual_return) AS total_fee FROM " .$GLOBALS['ecs']->table('order_info'). " as oi," .$GLOBALS['ecs']->table('order_return'). " as oreturn " . " WHERE 1" .
|
|
" $where AND oi.order_id = oreturn.order_id AND oreturn.back = 1 AND (SELECT og.ru_id FROM " . $GLOBALS['ecs']->table('order_goods') .' as og' . " WHERE og.order_id = oi.order_id limit 0, 1) = '$ru_id'" .
|
|
" AND (select count(*) from " .$GLOBALS['ecs']->table('order_info'). " as oi2 where oi2.main_order_id = oi.order_id limit 0, 1) = 0"; //主订单下有子订单时，则主订单不显示;
|
|
|
|
$res = $GLOBALS['db']->getRow($sql);
|
|
}else{
|
|
$total_fee = "SUM((" . order_amount_field('oi.') . ")) AS total_fee ";
|
|
|
|
$sql = "SELECT oi.order_id, oi.order_sn, $total_fee FROM " .$GLOBALS['ecs']->table('order_info'). " as oi " .
|
|
" WHERE 1 $where AND (SELECT og.ru_id FROM " . $GLOBALS['ecs']->table('order_goods') .' as og' . " WHERE og.order_id = oi.order_id limit 0, 1) = '$ru_id'" .
|
|
" AND (select count(*) from " .$GLOBALS['ecs']->table('order_info'). " as oi2 where oi2.main_order_id = oi.order_id limit 0, 1) = 0"; //主订单下有子订单时，则主订单不显示;
|
|
|
|
$res = $GLOBALS['db']->getRow($sql);
|
|
}
|
|
|
|
return $res;
|
|
}
|
|
|
|
/*
|
|
* 查询订单退款
|
|
* $type 0-单条数据 1-多条数据
|
|
*/
|
|
function get_order_return_list($order_id, $type = 0){
|
|
$sql = "SELECT SUM(actual_return) FROM " .$GLOBALS['ecs']->table('order_return'). " WHERE order_id = '$order_id'";
|
|
$actual_return = $GLOBALS['db']->getOne($sql);
|
|
|
|
return $actual_return;
|
|
}
|
|
?>
|