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.
951 lines
32 KiB
951 lines
32 KiB
<?php
|
|
|
|
/**
|
|
* ECSHOP 地区列表管理文件
|
|
* ============================================================================
|
|
* * 版权所有 2005-2016 上海商创网络科技有限公司，并保留所有权利。
|
|
* 网站地址: http://www.ecmoban.com；
|
|
* ----------------------------------------------------------------------------
|
|
* 这不是一个自由软件！您只能在不用于商业目的的前提下对程序代码进行修改和
|
|
* 使用；不允许对程序代码以任何形式任何目的的再发布。
|
|
* ============================================================================
|
|
* $Author: liubo $
|
|
* $Id: area_manage.php 17217 2011-01-19 06:29:08Z liubo $
|
|
*/
|
|
|
|
define('IN_ECS', true);
|
|
|
|
require(dirname(__FILE__) . '/includes/init.php');
|
|
$exc = new exchange($ecs->table('region_warehouse'), $db, 'region_id', 'region_name');
|
|
|
|
/* act操作项的初始化 */
|
|
if (empty($_REQUEST['act']))
|
|
{
|
|
$_REQUEST['act'] = 'list';
|
|
}
|
|
else
|
|
{
|
|
$_REQUEST['act'] = trim($_REQUEST['act']);
|
|
}
|
|
$adminru = get_admin_ru_id();
|
|
/*------------------------------------------------------ */
|
|
//-- 列出某地区下的所有地区列表
|
|
/*------------------------------------------------------ */
|
|
if ($_REQUEST['act'] == 'list')
|
|
{
|
|
/* 检查权限 */
|
|
admin_priv('warehouse_manage');
|
|
|
|
/* 仓库运费模板 by wu */
|
|
$smarty->assign('action_link2', array('href' => 'warehouse.php?act=ship_list', 'text' => '仓库运费模板'));
|
|
/* 取得参数：上级地区id */
|
|
$region_id = empty($_REQUEST['pid']) ? 0 : intval($_REQUEST['pid']);
|
|
$regionId = empty($_REQUEST['regionId']) ? 0 : intval($_REQUEST['regionId']);
|
|
$smarty->assign('parent_id', $region_id);
|
|
|
|
/* 取得列表显示的地区的类型 */
|
|
if ($region_id == 0)
|
|
{
|
|
$region_type = 0;
|
|
}
|
|
else
|
|
{
|
|
$region_type = $exc->get_name($region_id, 'region_type') + 1;
|
|
}
|
|
|
|
$smarty->assign('region_type', $region_type);
|
|
|
|
/* 获取地区列表 */
|
|
$region_arr = area_warehouse_list($region_id);
|
|
|
|
$smarty->assign('region_arr', $region_arr);
|
|
|
|
/* 当前的地区名称 */
|
|
if ($region_id > 0)
|
|
{
|
|
$area_name = $exc->get_name($region_id);
|
|
$area = '[ '. $area_name . ' ] ';
|
|
/*if ($region_arr)
|
|
{
|
|
$area .= $region_arr[0]['type'];
|
|
}*/
|
|
}
|
|
else
|
|
{
|
|
$area = $_LANG['country'];
|
|
}
|
|
$smarty->assign('area_here', $area);
|
|
|
|
//ecmoban模板堂 --zhuo start
|
|
if($regionId > 0){
|
|
$ecs_region = area_list($regionId);
|
|
}else{
|
|
$ecs_region = get_region_type_area();
|
|
}
|
|
$smarty->assign('ecs_region', $ecs_region);
|
|
|
|
$adminru = get_admin_ru_id();
|
|
$ruCat = '';
|
|
if($adminru['ru_id'] == 0){
|
|
$smarty->assign('priv_ru', 1);
|
|
}else{
|
|
$smarty->assign('priv_ru', 0);
|
|
}
|
|
//ecmoban模板堂 --zhuo end
|
|
|
|
/* 返回上一级的链接 */
|
|
if ($region_id > 0)
|
|
{
|
|
$parent_id = $exc->get_name($region_id, 'parent_id');
|
|
$action_link = array('text' => $_LANG['back_page'], 'href' => 'warehouse.php?act=list&&pid=' . $parent_id);
|
|
}
|
|
else
|
|
{
|
|
$action_link = '';
|
|
}
|
|
$smarty->assign('action_link', $action_link);
|
|
|
|
/* 赋值模板显示 */
|
|
|
|
$lang_area_list = $_LANG['05_area_list_01'];
|
|
|
|
if($region_id > 0){
|
|
$lang_area_list .= ' -- ' . $area;
|
|
}
|
|
|
|
$smarty->assign('ur_here', $lang_area_list);
|
|
$smarty->assign('full_page', 1);
|
|
$smarty->assign('freight_model', $GLOBALS['_CFG']['freight_model']);
|
|
|
|
|
|
assign_query_info();
|
|
$smarty->display('warehouse_list.htm');
|
|
}
|
|
|
|
/*------------------------------------------------------ */
|
|
//-- 配送方式列表 by wu
|
|
/*------------------------------------------------------ */
|
|
|
|
elseif ($_REQUEST['act'] == 'ship_list')
|
|
{
|
|
/* 检查权限 */
|
|
admin_priv('warehouse_manage');
|
|
|
|
/* 获取商家设置的配送方式 by wu */
|
|
$sql=" select ru_id, shipping_id from ".$GLOBALS['ecs']->table("seller_shopinfo")." where ru_id='".$adminru['ru_id']."' ";
|
|
$seller_shopinfo=$GLOBALS['db']->getRow($sql);
|
|
$smarty->assign('seller_shopinfo', $seller_shopinfo);
|
|
|
|
//获取配送方式列表
|
|
$sql = "SELECT shipping_id, shipping_name, shipping_desc, insure, support_cod,shipping_order FROM " .$ecs->table('shipping'). " WHERE enabled=1 ORDER BY shipping_order";
|
|
$shipping_list = $db->GetAll($sql);
|
|
$smarty->assign('shipping_list',$shipping_list);
|
|
|
|
$smarty->assign('ur_here','仓库运费模板');
|
|
$smarty->display('warehouse_shipping_list.htm');
|
|
}
|
|
|
|
/*------------------------------------------------------ */
|
|
//-- 删除运费模板 by wu
|
|
/*------------------------------------------------------ */
|
|
elseif($_REQUEST['act'] == 'remove_tpl')
|
|
{
|
|
$id = intval($_REQUEST['id']);
|
|
$sql="DELETE FROM " .$ecs->table('warehouse_freight_tpl'). " WHERE id='$id'";
|
|
if($db->query($sql))
|
|
{
|
|
$data = '删除成功';
|
|
}
|
|
else
|
|
{
|
|
$data = '删除失败';
|
|
}
|
|
die($data);
|
|
}
|
|
|
|
elseif($_REQUEST['act'] == 'multi_remove')
|
|
{
|
|
$ids = implode(',',$_REQUEST['areas']);
|
|
$sql="DELETE FROM " .$ecs->table('warehouse_freight_tpl'). " WHERE id in (".$ids.")";
|
|
if($db->query($sql))
|
|
{
|
|
$data = '移除成功';
|
|
}
|
|
else
|
|
{
|
|
$data = '移除失败';
|
|
}
|
|
$links[0] = array('href'=>'warehouse.php?act=tpl_list&shipping_id=' . intval($_REQUEST['shipping_id']), 'text' => $_LANG['go_back']);
|
|
sys_msg($data, 0, $links);
|
|
}
|
|
|
|
/*------------------------------------------------------ */
|
|
//-- 运费模板列表 by wu
|
|
/*------------------------------------------------------ */
|
|
if ($_REQUEST['act'] == 'tpl_list')
|
|
{
|
|
$shipping_id = intval($_REQUEST['shipping_id']);
|
|
//上门取货
|
|
$sql = "SELECT shipping_code,shipping_name FROM ".$ecs->table("shipping")." WHERE shipping_id=".$shipping_id;
|
|
$shipping = $db->getRow($sql);
|
|
$shipping_code = $shipping['shipping_code'];
|
|
|
|
$list = get_ship_tpl_list($shipping_id,$adminru['ru_id']);
|
|
|
|
/* 自提点名称 */
|
|
/*if(!empty($list) && $shipping_code == "cac"){
|
|
foreach($list as $key=>$val){
|
|
$sql = "SELECT name FROM ".$ecs->table("shipping_point")." WHERE shipping_area_id=".$val['shipping_area_id'];
|
|
$list[$key]['name'] = $db->getAll($sql);
|
|
}
|
|
}*/
|
|
$smarty->assign('areas', $list);
|
|
|
|
$smarty->assign('ur_here','仓库运费模板列表 - '.$shipping['shipping_name']);
|
|
$smarty->assign('action_link2', array('href'=>'warehouse.php?act=ship_tpl&shipping_id='.$shipping_id,
|
|
'text' => '新增运费模板'));
|
|
$smarty->assign('action_link', array('href' => 'warehouse.php?act=ship_list', 'text' => '返回配送列表'));
|
|
$smarty->assign('full_page', 1);
|
|
|
|
assign_query_info();
|
|
$smarty->assign('shipping_id' , $shipping_id);
|
|
$smarty->assign('shipping_code' , $shipping_code);
|
|
$smarty->display('warehouse_shipping_tpl_list.htm');
|
|
}
|
|
|
|
/*------------------------------------------------------ */
|
|
//-- 运费模板编辑 by wu
|
|
/*------------------------------------------------------ */
|
|
|
|
elseif ($_REQUEST['act'] == 'ship_tpl')
|
|
{
|
|
$shipping_id=isset($_REQUEST['shipping_id']) ? $_REQUEST['shipping_id'] : 0;
|
|
$smarty->assign('shipping_id', $shipping_id);
|
|
$id = isset($_REQUEST['id']) ? $_REQUEST['id'] : 0;
|
|
//$region_id = $id;
|
|
|
|
//处理配置信息
|
|
$sql = "SELECT a.shipping_name, a.shipping_code, a.support_cod, b.* ".
|
|
" FROM ".$ecs->table('warehouse_freight_tpl'). " AS b ".
|
|
" left join " .$ecs->table('shipping'). " AS a on a.shipping_id=b.shipping_id ".
|
|
" WHERE b.id='".$id."' and b.shipping_id='".$shipping_id."' and b.user_id='".$adminru['ru_id']."'";
|
|
$row = $db->getRow($sql);
|
|
|
|
if(!empty($row))
|
|
{
|
|
//插入一条记录
|
|
|
|
/* 自提点信息 */
|
|
if(!empty($row) && $row['shipping_code'] == "cac"){
|
|
$sql = "SELECT * FROM ".$ecs->table('shipping_point')." WHERE shipping_area_id='{$row['shipping_area_id']}'";
|
|
$row['point'] = $db->getAll($sql);
|
|
}
|
|
|
|
$set_modules = 1;
|
|
include_once(ROOT_PATH.'includes/modules/shipping/'.$row['shipping_code'].'.php');
|
|
|
|
$fields = unserialize($row['configure']);
|
|
/* 如果配送方式支持货到付款并且没有设置货到付款支付费用，则加入货到付款费用 */
|
|
if ($row['support_cod'] && $fields[count($fields)-1]['name'] != 'pay_fee')
|
|
{
|
|
$fields[] = array('name'=>'pay_fee', 'value'=>0);
|
|
}
|
|
|
|
foreach ($fields AS $key => $val)
|
|
{
|
|
/* 替换更改的语言项 */
|
|
if ($val['name'] == 'basic_fee')
|
|
{
|
|
$val['name'] = 'base_fee';
|
|
}
|
|
if ($val['name'] == 'item_fee')
|
|
{
|
|
$item_fee = 1;
|
|
}
|
|
if ($val['name'] == 'fee_compute_mode')
|
|
{
|
|
$smarty->assign('fee_compute_mode',$val['value']);
|
|
unset($fields[$key]);
|
|
}
|
|
else
|
|
{
|
|
$fields[$key]['name'] = $val['name'];
|
|
$fields[$key]['label'] = $_LANG[$val['name']];
|
|
}
|
|
}
|
|
|
|
if(empty($item_fee))
|
|
{
|
|
$field = array('name'=>'item_fee', 'value'=>'0', 'label'=>empty($_LANG['item_fee']) ? '' : $_LANG['item_fee']);
|
|
array_unshift($fields,$field);
|
|
}
|
|
$smarty->assign('shipping_area', $row);
|
|
}
|
|
else
|
|
{
|
|
$shipping = $db->getRow("SELECT shipping_name, shipping_code FROM " .$ecs->table('shipping'). " WHERE shipping_id='$shipping_id'");
|
|
$set_modules = 1;
|
|
include_once(ROOT_PATH.'includes/modules/shipping/'.$shipping['shipping_code'].'.php');
|
|
$fields = array();
|
|
foreach ($modules[0]['configure'] AS $key => $val)
|
|
{
|
|
$fields[$key]['name'] = $val['name'];
|
|
$fields[$key]['value'] = $val['value'];
|
|
$fields[$key]['label'] = $_LANG[$val['name']];
|
|
}
|
|
$count = count($fields);
|
|
$fields[$count]['name'] = "free_money";
|
|
$fields[$count]['value'] = "0";
|
|
$fields[$count]['label'] = $_LANG["free_money"];
|
|
|
|
/* 如果支持货到付款，则允许设置货到付款支付费用 */
|
|
if ($modules[0]['cod'])
|
|
{
|
|
$count++;
|
|
$fields[$count]['name'] = "pay_fee";
|
|
$fields[$count]['value'] = "0";
|
|
$fields[$count]['label'] = $_LANG['pay_fee'];
|
|
}
|
|
|
|
$shipping_area['shipping_id'] = 0;
|
|
$shipping_area['free_money'] = 0;
|
|
$smarty->assign('shipping_area', array('shipping_id' => $_REQUEST['shipping_id'], 'shipping_code' => $shipping['shipping_code']));
|
|
}
|
|
//处理配置信息
|
|
|
|
/* 仓库运费模板 by wu */
|
|
$smarty->assign('action_link2', array('href' => 'warehouse.php?act=tpl_list&shipping_id='.$shipping_id, 'text' => '返回模板列表'));
|
|
|
|
/*$parent = get_freight_warehouse_id($region_id);
|
|
$parent = get_parent_freight($parent);
|
|
$parent = array_switch($parent);
|
|
$parent_id = $parent[0];
|
|
|
|
$smarty->assign('parent_id', $parent_id);*/
|
|
|
|
$warehouse_list = get_warehouse_list_goods();
|
|
|
|
//设置仓库状态 by wu
|
|
$sql=" SELECT warehouse_id from ".$ecs->table('warehouse_freight_tpl')." where id='$id' and shipping_id='$shipping_id' and user_id='".$adminru['ru_id']."' ";
|
|
$warehouses=$db->getOne($sql);
|
|
foreach($warehouse_list as $key=>$value)
|
|
{
|
|
if(!empty($warehouses))
|
|
{
|
|
if(in_array($value['region_id'],explode(',',$warehouses)))
|
|
{
|
|
$warehouse_list[$key]['check_status']=1;
|
|
}
|
|
}
|
|
}
|
|
$smarty->assign('warehouse_list', $warehouse_list);
|
|
$smarty->assign('warehouse_count', count($warehouse_list)+1); //每增加一个表单，值加1
|
|
|
|
/*$sql = "select region_name from " .$ecs->table('region_warehouse'). " where region_id = '$region_id'";
|
|
$region_name = $db->getOne($sql);
|
|
|
|
$smarty->assign('region_name', $region_name);
|
|
$smarty->assign('region_id', $region_id);*/
|
|
|
|
$smarty->assign('form_action', 'freight_tpl_insert');
|
|
|
|
$shipping_list = warehouse_shipping_list();
|
|
$smarty->assign('shipping_list', $shipping_list);
|
|
|
|
/*$sql = "select regionId from " .$ecs->table('region_warehouse'). " where region_id = '$region_id'";
|
|
$regionId = $db->getOne($sql);
|
|
|
|
$freight_list = get_warehouse_freight_type($regionId);
|
|
|
|
$smarty->assign('freight_list', $freight_list);
|
|
|
|
$smarty->assign('regionId', $regionId);*/
|
|
|
|
/* 获得该区域下的所有地区 */
|
|
$regions = array();
|
|
|
|
$sql = " SELECT region_id from ".$ecs->table('warehouse_freight_tpl')." where id='$id' and shipping_id='$shipping_id' and user_id='".$adminru['ru_id']."' ";
|
|
$region_list=$res = $db->getOne($sql);
|
|
if(!empty($region_list))
|
|
{
|
|
$sql = " SELECT region_id,region_name from ".$ecs->table('region')." where region_id in (".$region_list.") ";
|
|
$res = $db->query($sql);
|
|
while ($arr = $db->fetchRow($res))
|
|
{
|
|
$regions[$arr['region_id']] = $arr['region_name'];
|
|
}
|
|
}
|
|
assign_query_info();
|
|
$smarty->assign('fields', $fields);
|
|
$smarty->assign('countries', get_regions());
|
|
$smarty->assign('regions', $regions);
|
|
$smarty->display('warehouse_shipping_tpl_info.htm');
|
|
}
|
|
|
|
/*------------------------------------------------------ */
|
|
//-- 查询类目列表 by wu
|
|
/*------------------------------------------------------ */
|
|
elseif ($_REQUEST['act'] == 'freight_tpl_insert')
|
|
{
|
|
$warehouse_id = empty($_REQUEST['warehouse_id']) ? '' : implode(',',$_REQUEST['warehouse_id']);
|
|
$shipping_id = empty($_REQUEST['shipping_id']) ? '' : intval($_REQUEST['shipping_id']);
|
|
$tpl_name = empty($_REQUEST['tpl_name']) ? '' : trim($_REQUEST['tpl_name']);
|
|
$id = empty($_REQUEST['id']) ? '' : intval($_REQUEST['id']);
|
|
//$region_id = $id;
|
|
$rId = empty($_REQUEST['regions']) ? '' : implode(',',$_REQUEST['regions']);
|
|
$regionId = $rId;
|
|
|
|
if($shipping_id == 0 || empty($tpl_name) || empty($warehouse_id) || empty($regionId))
|
|
{
|
|
$add_to_mess = "请将信息填写完整";
|
|
$add_edit = "act=ship_tpl&shipping_id=" . $shipping_id;
|
|
$link[] = array('text' => $_LANG['go_back'], 'href'=>'warehouse.php?' . $add_edit);
|
|
sys_msg($add_to_mess, 0, $link);
|
|
}
|
|
else
|
|
{
|
|
$add_to_mess = "运费添加成功";
|
|
}
|
|
//ecmoban模板堂 --zhuo start
|
|
$adminru = get_admin_ru_id();
|
|
if($adminru['ru_id'] > 0){
|
|
$ru_id = $adminru['ru_id'];
|
|
}else{
|
|
$ru_id = 0;
|
|
}
|
|
|
|
$ruCat = " and user_id = '$ru_id'";
|
|
//ecmoban模板堂 --zhuo end
|
|
|
|
/*$sql = "select id from " .$ecs->table('warehouse_freight'). " where warehouse_id = '$warehouse_id' and shipping_id = '$shipping_id' and region_id = '$regionId'" . $ruCat;
|
|
$res = $db->getOne($sql);
|
|
|
|
if($res){
|
|
$add_to_mess = "物流配送地区已存在！";
|
|
$add_edit = "act=ship_tpl&shipping_id=" . $shipping_id;
|
|
$link[] = array('text' => $_LANG['go_back'], 'href'=>'warehouse.php?' . $add_edit);
|
|
sys_msg($add_to_mess, 0, $link);
|
|
}*/
|
|
|
|
if(!empty($id))
|
|
{
|
|
$where=" and id <> $id ";
|
|
}
|
|
else
|
|
{
|
|
$where="";
|
|
}
|
|
$sql = "select warehouse_id,region_id from " .$ecs->table('warehouse_freight_tpl'). " where shipping_id = '$shipping_id' and user_id = '".$adminru['ru_id']."'".$where;
|
|
$res = $db->getAll($sql);
|
|
foreach($res as $key=>$val)
|
|
{
|
|
$warehouse_state=array_intersect(explode(',',$val['warehouse_id']),explode(',',$warehouse_id));
|
|
$region_state=array_intersect(explode(',',$val['region_id']),explode(',',$rId));
|
|
if($warehouse_state&&$region_state)
|
|
{
|
|
$add_to_mess = "模板抵达地区已存在！";
|
|
$add_edit = "act=tpl_list&shipping_id=" . $shipping_id;
|
|
$link[] = array('text' => $_LANG['go_back'], 'href'=>'warehouse.php?' . $add_edit);
|
|
sys_msg($add_to_mess, 0, $link);
|
|
}
|
|
}
|
|
|
|
$shipping_code = $db->getOne("SELECT shipping_code FROM " .$ecs->table('shipping').
|
|
" WHERE shipping_id='$shipping_id'");
|
|
$plugin = '../includes/modules/shipping/'. $shipping_code. ".php";
|
|
|
|
if (!file_exists($plugin))
|
|
{
|
|
sys_msg($_LANG['not_find_plugin'], 1);
|
|
}
|
|
else
|
|
{
|
|
$set_modules = 1;
|
|
include_once($plugin);
|
|
}
|
|
|
|
$config = array();
|
|
foreach ($modules[0]['configure'] AS $key => $val)
|
|
{
|
|
$config[$key]['name'] = $val['name'];
|
|
$config[$key]['value'] = $_POST[$val['name']];
|
|
}
|
|
|
|
$count = count($config);
|
|
$config[$count]['name'] = 'free_money';
|
|
$config[$count]['value'] = empty($_POST['free_money']) ? '' : $_POST['free_money'];
|
|
$count++;
|
|
$config[$count]['name'] = 'fee_compute_mode';
|
|
$config[$count]['value'] = empty($_POST['fee_compute_mode']) ? '' : $_POST['fee_compute_mode'];
|
|
/* 如果支持货到付款，则允许设置货到付款支付费用 */
|
|
if ($modules[0]['cod'])
|
|
{
|
|
$count++;
|
|
$config[$count]['name'] = 'pay_fee';
|
|
$config[$count]['value'] = make_semiangle(empty($_POST['pay_fee']) ? '' : $_POST['pay_fee']);
|
|
}
|
|
|
|
/*$sql = "select regionId from " .$ecs->table('region_warehouse'). " where regionId = '$regionId'";
|
|
$regionId = $db->getOne($sql);*/
|
|
|
|
$adminru = get_admin_ru_id();
|
|
|
|
$other['tpl_name'] = $tpl_name;
|
|
$other['warehouse_id'] = $warehouse_id;
|
|
$other['shipping_id'] = $shipping_id;
|
|
$other['region_id'] = $regionId;
|
|
$other['configure'] = serialize($config);
|
|
$other['user_id'] = $adminru['ru_id'];
|
|
|
|
$sql=" select * from ".$ecs->table('warehouse_freight_tpl')." where shipping_id='$shipping_id' and user_id='".$adminru['ru_id']."' ";
|
|
$tpl_status=$db->getRow($sql);
|
|
if(empty($tpl_status)||empty($id))
|
|
{
|
|
$db->autoExecute($ecs->table('warehouse_freight_tpl'), $other, 'INSERT');
|
|
$add_to_mess = "模板添加成功";
|
|
}
|
|
else
|
|
{
|
|
$db->autoExecute($ecs->table('warehouse_freight_tpl'), $other, 'UPDATE' , ' id= ' . $id . ' and user_id = ' . $adminru['ru_id'] . ' and shipping_id= '.$shipping_id);
|
|
$add_to_mess = "模板修改成功";
|
|
}
|
|
|
|
$add_edit = "act=tpl_list&shipping_id=" . $shipping_id;
|
|
$link[] = array('text' => $_LANG['go_back'], 'href'=>'warehouse.php?' . $add_edit);
|
|
sys_msg($add_to_mess, 0, $link);
|
|
}
|
|
|
|
/*------------------------------------------------------ */
|
|
//-- 添加新的地区
|
|
/*------------------------------------------------------ */
|
|
|
|
elseif ($_REQUEST['act'] == 'add_area')
|
|
{
|
|
check_authz_json('warehouse_manage');
|
|
|
|
$parent_id = intval($_POST['parent_id']);
|
|
$region_name = json_str_iconv(trim($_POST['region_name']));
|
|
$region_type = intval($_POST['region_type']);
|
|
|
|
//ecmoban模板堂 --zhuo start
|
|
$regionId = intval($_POST['regionId']);
|
|
if($regionId > 0){
|
|
$region_name = get_region_name_area($regionId);
|
|
}
|
|
//ecmoban模板堂 --zhuo end
|
|
|
|
if (empty($region_name))
|
|
{
|
|
make_json_error($_LANG['region_name_empty']);
|
|
}
|
|
|
|
/* 查看区域是否重复 */
|
|
$sql = "select region_id from " .$ecs->table('region_warehouse'). " where regionId = '$regionId' ";
|
|
$res = $db->getOne($sql);
|
|
|
|
if($res > 0 && $regionId){
|
|
make_json_error($_LANG['region_name_exist']);
|
|
}else{
|
|
$sql = "select region_id from " .$ecs->table('region_warehouse'). " where region_name = '$region_name' AND region_type <> 1";
|
|
$res = $db->getOne($sql);
|
|
|
|
if($res > 0){
|
|
make_json_error($_LANG['region_name_exist']);
|
|
}
|
|
}
|
|
|
|
$sql = "INSERT INTO " . $ecs->table('region_warehouse') . " (regionId, parent_id, region_name, region_type) ".
|
|
"VALUES ('$regionId', '$parent_id', '$region_name', '$region_type')";
|
|
if ($GLOBALS['db']->query($sql, 'SILENT'))
|
|
{
|
|
admin_log($region_name, 'add','area');
|
|
|
|
/* 获取地区列表 */
|
|
$region_arr = area_warehouse_list($parent_id);
|
|
$smarty->assign('region_arr', $region_arr);
|
|
|
|
$adminru = get_admin_ru_id();
|
|
$ruCat = '';
|
|
if($adminru['ru_id'] == 0){
|
|
$smarty->assign('priv_ru', 1);
|
|
}else{
|
|
$smarty->assign('priv_ru', 0);
|
|
}
|
|
|
|
$smarty->assign('region_type', $region_type);
|
|
|
|
make_json_result($smarty->fetch('warehouse_list.htm'));
|
|
}
|
|
else
|
|
{
|
|
make_json_error($_LANG['add_area_error']);
|
|
}
|
|
}
|
|
|
|
/*------------------------------------------------------ */
|
|
//-- 编辑区域名称
|
|
/*------------------------------------------------------ */
|
|
|
|
elseif ($_REQUEST['act'] == 'edit_area_name')
|
|
{
|
|
check_authz_json('warehouse_manage');
|
|
|
|
$id = intval($_POST['id']);
|
|
$region_name = json_str_iconv(trim($_POST['val']));
|
|
|
|
if (empty($region_name))
|
|
{
|
|
make_json_error($_LANG['region_name_empty']);
|
|
}
|
|
|
|
$msg = '';
|
|
|
|
/* 查看区域是否重复 */
|
|
$parent_id = $exc->get_name($id, 'parent_id');
|
|
if (!$exc->is_only('region_name', $region_name, $id, "parent_id = '$parent_id'"))
|
|
{
|
|
make_json_error($_LANG['region_name_exist']);
|
|
}
|
|
|
|
if ($exc->edit("region_name = '$region_name'", $id))
|
|
{
|
|
admin_log($region_name, 'edit', 'area');
|
|
make_json_result(stripslashes($region_name));
|
|
}
|
|
else
|
|
{
|
|
make_json_error($db->error());
|
|
}
|
|
}
|
|
|
|
/*------------------------------------------------------ */
|
|
//-- 删除区域
|
|
/*------------------------------------------------------ */
|
|
elseif ($_REQUEST['act'] == 'drop_area')
|
|
{
|
|
check_authz_json('warehouse_manage');
|
|
|
|
$id = intval($_REQUEST['id']);
|
|
|
|
$sql = "SELECT * FROM " . $ecs->table('region_warehouse') . " WHERE region_id = '$id'";
|
|
$region = $db->getRow($sql);
|
|
|
|
$region_type=$region['region_type'];
|
|
$delete_region[]=$id;
|
|
$new_region_id =$id;
|
|
if($region_type<6)
|
|
{
|
|
for($i=1;$i<6-$region_type;$i++)
|
|
{
|
|
$new_region_id=new_region_id($new_region_id);
|
|
if(count($new_region_id))
|
|
{
|
|
$delete_region=array_merge($delete_region,$new_region_id);
|
|
}
|
|
else
|
|
{
|
|
continue;
|
|
}
|
|
}
|
|
}
|
|
$sql="DELETE FROM ". $ecs->table("region_warehouse")."WHERE region_id".db_create_in($delete_region);
|
|
$db->query($sql);
|
|
if ($exc->drop($id))
|
|
{
|
|
admin_log(addslashes($region['region_name']), 'remove', 'area');
|
|
|
|
/* 获取地区列表 */
|
|
$region_arr = area_warehouse_list($region['parent_id']);
|
|
$smarty->assign('region_arr', $region_arr);
|
|
$smarty->assign('region_type', $region['region_type']);
|
|
|
|
//ecmoban模板堂 --zhuo start
|
|
$adminru = get_admin_ru_id();
|
|
$ruCat = '';
|
|
if($adminru['ru_id'] == 0){
|
|
$smarty->assign('priv_ru', 1);
|
|
}else{
|
|
$smarty->assign('priv_ru', 0);
|
|
}
|
|
//ecmoban模板堂 --zhuo end
|
|
|
|
make_json_result($smarty->fetch('warehouse_list.htm'));
|
|
}
|
|
else
|
|
{
|
|
make_json_error($db->error());
|
|
}
|
|
}
|
|
|
|
/*------------------------------------------------------ */
|
|
//-- 删除区域
|
|
/*------------------------------------------------------ */
|
|
elseif ($_REQUEST['act'] == 'freight'){
|
|
|
|
/* 获取商家设置的配送方式 by wu */
|
|
$sql=" select ru_id, shipping_id from ".$GLOBALS['ecs']->table("seller_shopinfo")." where ru_id='".$adminru['ru_id']."' ";
|
|
$seller_shopinfo=$GLOBALS['db']->getRow($sql);
|
|
$smarty->assign('seller_shopinfo', $seller_shopinfo);
|
|
//var_dump($seller_shopinfo);
|
|
|
|
$id = isset($_REQUEST['id']) ? $_REQUEST['id'] : 0;
|
|
$region_id = $id;
|
|
|
|
$parent = get_freight_warehouse_id($region_id);
|
|
$parent = get_parent_freight($parent);
|
|
$parent = array_switch($parent);
|
|
$parent_id = $parent[0];
|
|
|
|
$smarty->assign('parent_id', $parent_id);
|
|
|
|
$warehouse_list = get_warehouse_list_goods();
|
|
$smarty->assign('warehouse_list', $warehouse_list);
|
|
|
|
$sql = "select region_name from " .$ecs->table('region_warehouse'). " where region_id = '$region_id'";
|
|
$region_name = $db->getOne($sql);
|
|
|
|
$smarty->assign('region_name', $region_name);
|
|
$smarty->assign('region_id', $region_id);
|
|
|
|
$smarty->assign('form_action', 'freight_insert');
|
|
|
|
$shipping_list = warehouse_shipping_list();
|
|
$smarty->assign('shipping_list', $shipping_list);
|
|
|
|
$sql = "select regionId from " .$ecs->table('region_warehouse'). " where region_id = '$region_id'";
|
|
$regionId = $db->getOne($sql);
|
|
|
|
$freight_list = get_warehouse_freight_type($regionId);
|
|
|
|
$smarty->assign('freight_list', $freight_list);
|
|
|
|
$smarty->assign('regionId', $regionId);
|
|
|
|
assign_query_info();
|
|
$smarty->display('warehouse_freight.htm');
|
|
}
|
|
|
|
//查询类目列表
|
|
elseif ($_REQUEST['act'] == 'freight_insert')
|
|
{
|
|
$warehouse_id = empty($_REQUEST['warehouse_id']) ? '' : intval($_REQUEST['warehouse_id']);
|
|
$shipping_id = empty($_REQUEST['shipping_id']) ? '' : intval($_REQUEST['shipping_id']);
|
|
$id = empty($_REQUEST['id']) ? '' : intval($_REQUEST['id']);
|
|
$region_id = $id;
|
|
$rId = empty($_REQUEST['rId']) ? '' : intval($_REQUEST['rId']);
|
|
$regionId = $rId;
|
|
|
|
if($shipping_id == 0){
|
|
$add_to_mess = "请选择配送方式";
|
|
$add_edit = "act=freight®ion_id=" . $region_id;
|
|
$link[] = array('text' => $_LANG['go_back'], 'href'=>'warehouse.php?' . $add_edit);
|
|
sys_msg($add_to_mess, 0, $link);
|
|
}else{
|
|
$add_to_mess = "运费添加成功";
|
|
}
|
|
|
|
//ecmoban模板堂 --zhuo start
|
|
$adminru = get_admin_ru_id();
|
|
if($adminru['ru_id'] > 0){
|
|
$ru_id = $adminru['ru_id'];
|
|
}else{
|
|
$ru_id = 0;
|
|
}
|
|
|
|
$ruCat = " and user_id = '$ru_id'";
|
|
//ecmoban模板堂 --zhuo end
|
|
|
|
$sql = "select id from " .$ecs->table('warehouse_freight'). " where warehouse_id = '$warehouse_id' and shipping_id = '$shipping_id' and region_id = '$regionId'" . $ruCat;
|
|
$res = $db->getOne($sql);
|
|
|
|
if($res){
|
|
$add_to_mess = "物流配送地区已存在！";
|
|
$add_edit = "act=freight&id=" . $region_id;
|
|
$link[] = array('text' => $_LANG['go_back'], 'href'=>'warehouse.php?' . $add_edit);
|
|
sys_msg($add_to_mess, 0, $link);
|
|
}
|
|
|
|
$shipping_code = $db->getOne("SELECT shipping_code FROM " .$ecs->table('shipping').
|
|
" WHERE shipping_id='$shipping_id'");
|
|
$plugin = '../includes/modules/shipping/'. $shipping_code. ".php";
|
|
|
|
if (!file_exists($plugin))
|
|
{
|
|
sys_msg($_LANG['not_find_plugin'], 1);
|
|
}
|
|
else
|
|
{
|
|
$set_modules = 1;
|
|
include_once($plugin);
|
|
}
|
|
|
|
$config = array();
|
|
foreach ($modules[0]['configure'] AS $key => $val)
|
|
{
|
|
$config[$key]['name'] = $val['name'];
|
|
$config[$key]['value'] = $_POST[$val['name']];
|
|
}
|
|
|
|
$count = count($config);
|
|
$config[$count]['name'] = 'free_money';
|
|
$config[$count]['value'] = empty($_POST['free_money']) ? '' : $_POST['free_money'];
|
|
$count++;
|
|
$config[$count]['name'] = 'fee_compute_mode';
|
|
$config[$count]['value'] = empty($_POST['fee_compute_mode']) ? '' : $_POST['fee_compute_mode'];
|
|
/* 如果支持货到付款，则允许设置货到付款支付费用 */
|
|
if ($modules[0]['cod'])
|
|
{
|
|
$count++;
|
|
$config[$count]['name'] = 'pay_fee';
|
|
$config[$count]['value'] = make_semiangle(empty($_POST['pay_fee']) ? '' : $_POST['pay_fee']);
|
|
}
|
|
|
|
$sql = "select regionId from " .$ecs->table('region_warehouse'). " where regionId = '$regionId'";
|
|
$regionId = $db->getOne($sql);
|
|
|
|
$adminru = get_admin_ru_id();
|
|
|
|
$other['warehouse_id'] = $warehouse_id;
|
|
$other['shipping_id'] = $shipping_id;
|
|
$other['region_id'] = $regionId;
|
|
$other['configure'] = serialize($config);
|
|
$other['user_id'] = $adminru['ru_id'];
|
|
|
|
$db->autoExecute($ecs->table('warehouse_freight'), $other, 'INSERT');
|
|
|
|
$add_edit = "act=freight&id=" . $region_id;
|
|
$link[] = array('text' => $_LANG['go_back'], 'href'=>'warehouse.php?' . $add_edit);
|
|
sys_msg($add_to_mess, 0, $link);
|
|
}
|
|
|
|
//查询运费模式
|
|
elseif ($_REQUEST['act'] == 'get_freight_area')
|
|
{
|
|
check_authz_json('warehouse_manage');
|
|
|
|
$shipping_id = intval($_GET['shipping_id']);
|
|
|
|
$shipping = $db->getRow("SELECT shipping_name, shipping_code FROM " .$ecs->table('shipping'). " WHERE shipping_id='$shipping_id'");
|
|
|
|
$set_modules = 1;
|
|
include_once(ROOT_PATH.'includes/modules/shipping/'.$shipping['shipping_code'].'.php');
|
|
|
|
$fields = array();
|
|
foreach ($modules[0]['configure'] AS $key => $val)
|
|
{
|
|
$fields[$key]['name'] = $val['name'];
|
|
$fields[$key]['value'] = $val['value'];
|
|
$fields[$key]['label'] = $_LANG[$val['name']];
|
|
}
|
|
$count = count($fields);
|
|
$fields[$count]['name'] = "free_money";
|
|
$fields[$count]['value'] = "0";
|
|
$fields[$count]['label'] = $_LANG["free_money"];
|
|
|
|
/* 如果支持货到付款，则允许设置货到付款支付费用 */
|
|
if ($modules[0]['cod'])
|
|
{
|
|
$count++;
|
|
$fields[$count]['name'] = "pay_fee";
|
|
$fields[$count]['value'] = "0";
|
|
$fields[$count]['label'] = $_LANG['pay_fee'];
|
|
}
|
|
|
|
$smarty->assign('shipping_area', array('shipping_id' => $_REQUEST['shipping'], 'shipping_code' => $shipping['shipping_code']));
|
|
$smarty->assign('fields', $fields);
|
|
|
|
make_json_result($smarty->fetch('warehouse_freight_area.htm'));
|
|
}
|
|
|
|
function new_region_id($region_id)
|
|
{
|
|
$regions_id=array();
|
|
if(empty($region_id))
|
|
{
|
|
return $regions_id;
|
|
}
|
|
$sql="SELECT region_id FROM ". $GLOBALS['ecs']->table("region_warehouse")."WHERE parent_id ".db_create_in($region_id);
|
|
$result=$GLOBALS['db']->getAll($sql);
|
|
foreach($result as $val)
|
|
{
|
|
$regions_id[]=$val['region_id'];
|
|
}
|
|
return $regions_id;
|
|
}
|
|
|
|
//查找出一级地区列表 值为1 ecs_region表
|
|
function get_region_type_area($type = 1){
|
|
$sql = "select region_id, region_name from " .$GLOBALS['ecs']->table('region'). " where region_type = '$type'";
|
|
$res = $GLOBALS['db']->getAll($sql);
|
|
|
|
$arr = array();
|
|
foreach($res as $key=>$row){
|
|
$arr[$key] = $row;
|
|
$region_id = get_table_date('region_warehouse', "regionId = '" .$row['region_id']. "'", array('region_id'), 2);
|
|
if($region_id > 0){
|
|
unset($arr[$key]);
|
|
}
|
|
}
|
|
|
|
return $arr;
|
|
}
|
|
|
|
//查找仓库地区名称
|
|
function get_region_name_area($region_id = 0){
|
|
$sql = "select region_name from " .$GLOBALS['ecs']->table('region'). " where region_id = '$region_id'";
|
|
return $GLOBALS['db']->getOne($sql);
|
|
}
|
|
|
|
//查找所属仓库 start
|
|
function get_freight_warehouse_id($region_id){
|
|
$sql = "select region_id, parent_id, region_name from " .$GLOBALS['ecs']->table('region_warehouse'). " where region_id = '$region_id'";
|
|
$res = $GLOBALS['db']->getAll($sql);
|
|
|
|
$arr = array();
|
|
foreach($res as $key=>$row){
|
|
$arr[$key]['region_id'] = $row['region_id'];
|
|
$arr[$key]['parent_id'] = $row['parent_id'];
|
|
$arr[$key]['region_name'] = $row['region_name'];
|
|
$arr[$key]['parent'] = get_freight_warehouse_id($row['parent_id']);
|
|
|
|
if($arr[$key]['parent_id']==0){
|
|
$arr[$key]['parent'] = $row['region_id'];
|
|
}
|
|
}
|
|
|
|
return $arr;
|
|
}
|
|
|
|
function get_parent_freight($parent){
|
|
$arr = array();
|
|
for($i=0;$i<count($parent);$i++){
|
|
if(is_array($parent[$i]['parent'])){
|
|
$arr[$i]['parent'] = get_parent_freight($parent[$i]['parent']);
|
|
}else{
|
|
$arr[$i]['parent'] = $parent[$i]['parent'];
|
|
}
|
|
}
|
|
|
|
return $arr;
|
|
}
|
|
//查找所属仓库 end
|
|
|
|
/*****多维数组转换一维数组****************************/
|
|
function array_switch($array)
|
|
{
|
|
static $result_array=array();
|
|
if(count($array)==0){
|
|
return false;
|
|
}
|
|
foreach($array as $value)
|
|
{
|
|
if(is_array($value))
|
|
{
|
|
array_switch($value);
|
|
}
|
|
else
|
|
$result_array[]=$value;
|
|
}
|
|
return $result_array;
|
|
}
|
|
?>
|