asmodeus
/
shop
1
0
Fork 0
Code Issues Pull Requests Projects Releases Wiki Activity
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.
512 Commits
1 Branch
0 Tags
166 MiB
 
 
 
 
Branch: master
Branches Tags
${ item.name }
Create tag ${ searchTerm }
Create branch ${ searchTerm }
from 'master'
${ noResults }
shop/admin/includes/lib_main.php

1755 lines
60 KiB
Raw Permalink Blame History

<?php
/**
* ECSHOP 管理中心公用函数库
* ============================================================================
* * 版权所有 2005-2016 上海商创网络科技有限公司，并保留所有权利。
* 网站地址: http://www.ecmoban.com；
* ----------------------------------------------------------------------------
* 这不是一个自由软件！您只能在不用于商业目的的前提下对程序代码进行修改和
* 使用；不允许对程序代码以任何形式任何目的的再发布。
* ============================================================================
* $Author: liubo $
* $Id: lib_main.php 17217 2011-01-19 06:29:08Z liubo $
*/
if (!defined('IN_ECS'))
{
die('Hacking attempt');
}
/**
* 获得所有模块的名称以及链接地址
*
* @access public
* @param string $directory 插件存放的目录
* @return array
*/
function read_modules($directory = '.')
{
global $_LANG;
$dir = @opendir($directory);
$set_modules = true;
$modules = array();
while (false !== ($file = @readdir($dir)))
{
if (preg_match("/^.*?\.php$/", $file))
{
include_once($directory. '/' .$file);
}
}
@closedir($dir);
unset($set_modules);
foreach ($modules AS $key => $value)
{
ksort($modules[$key]);
}
ksort($modules);
return $modules;
}
/**
* 系统提示信息
*
* @access public
* @param string msg_detail 消息内容
* @param int msg_type 消息类型， 0消息，1错误，2询问
* @param array links 可选的链接
* @param boolen $auto_redirect 是否需要自动跳转
* @return void
*/
function sys_msg($msg_detail, $msg_type = 0, $links = array(), $auto_redirect = true)
{
if (count($links) == 0)
{
$links[0]['text'] = $GLOBALS['_LANG']['go_back'];
$links[0]['href'] = 'javascript:history.go(-1)';
}
assign_query_info();
$GLOBALS['smarty']->assign('ur_here', $GLOBALS['_LANG']['system_message']);
$GLOBALS['smarty']->assign('msg_detail', $msg_detail);
$GLOBALS['smarty']->assign('msg_type', $msg_type);
$GLOBALS['smarty']->assign('links', $links);
$GLOBALS['smarty']->assign('default_url', $links[0]['href']);
$GLOBALS['smarty']->assign('auto_redirect', $auto_redirect);
$GLOBALS['smarty']->display('message.htm');
exit;
}
/**
* 记录管理员的操作内容
*
* @access public
* @param string $sn 数据的唯一值
* @param string $action 操作的类型
* @param string $content 操作的内容
* @return void
*/
function admin_log($sn = '', $action, $content)
{
$log_info = $GLOBALS['_LANG']['log_action'][$action] . $GLOBALS['_LANG']['log_action'][$content] .': '. addslashes($sn);
$sql = 'INSERT INTO ' . $GLOBALS['ecs']->table('admin_log') . ' (log_time, user_id, log_info, ip_address) ' .
" VALUES ('" . gmtime() . "', $_SESSION[admin_id], '" . stripslashes($log_info) . "', '" . real_ip() . "')";
$GLOBALS['db']->query($sql);
}
/**
* 将通过表单提交过来的年月日变量合成为"2004-05-10"的格式。
*
* 此函数适用于通过smarty函数html_select_date生成的下拉日期。
*
* @param string $prefix 年月日变量的共同的前缀。
* @return date 日期变量。
*/
function sys_joindate($prefix)
{
/* 返回年-月-日的日期格式 */
$year = empty($_POST[$prefix . 'Year']) ? '0' : $_POST[$prefix . 'Year'];
$month = empty($_POST[$prefix . 'Month']) ? '0' : $_POST[$prefix . 'Month'];
$day = empty($_POST[$prefix . 'Day']) ? '0' : $_POST[$prefix . 'Day'];
return $year . '-' . $month . '-' . $day;
}
/**
* 设置管理员的session内容
*
* @access public
* @param integer $user_id 管理员编号
* @param string $username 管理员姓名
* @param string $action_list 权限列表
* @param string $last_time 最后登录时间
* @return void
*/
function set_admin_session($user_id, $username, $action_list, $last_time)
{
$_SESSION['admin_id'] = $user_id;
$_SESSION['admin_name'] = $username;
$_SESSION['action_list'] = $action_list;
$_SESSION['last_check'] = $last_time; // 用于保存最后一次检查订单的时间
}
/**
* 插入一个配置信息
*
* @access public
* @param string $parent 分组的code
* @param string $code 该配置信息的唯一标识
* @param string $value 该配置信息值
* @return void
*/
function insert_config($parent, $code, $value)
{
global $ecs, $db, $_LANG;
$sql = 'SELECT id FROM ' . $ecs->table('shop_config') . " WHERE code = '$parent' AND type = 1";
$parent_id = $db->getOne($sql);
$sql = 'INSERT INTO ' . $ecs->table('shop_config') . ' (parent_id, code, value) ' .
"VALUES('$parent_id', '$code', '$value')";
$db->query($sql);
}
/**
* 判断管理员对某一个操作是否有权限。
*
* 根据当前对应的action_code，然后再和用户session里面的action_list做匹配，以此来决定是否可以继续执行。
* @param string $priv_str 操作对应的priv_str
* @param string $msg_type 返回的类型
* @return true/false
*/
function admin_priv($priv_str, $msg_type = '' , $msg_output = true)
{
global $_LANG;
if ($_SESSION['action_list'] == 'all')
{
return true;
}
if (strpos(',' . $_SESSION['action_list'] . ',', ',' . $priv_str . ',') === false)
{
$link[] = array('text' => $_LANG['go_back'], 'href' => 'javascript:history.back(-1)');
if ( $msg_output)
{
sys_msg($_LANG['priv_error'], 0, $link);
}
return false;
}
else
{
return true;
}
}
/**
* 检查管理员权限
*
* @access public
* @param string $authz
* @return boolean
*/
function check_authz($authz)
{
return (preg_match('/,*'.$authz.',*/', $_SESSION['action_list']) || $_SESSION['action_list'] == 'all');
}
/**
* 检查管理员权限，返回JSON格式数剧
*
* @access public
* @param string $authz
* @return void
*/
function check_authz_json($authz)
{
if (!check_authz($authz))
{
make_json_error($GLOBALS['_LANG']['priv_error']);
}
}
/**
* 取得红包类型数组（用于生成下拉列表）
*
* @return array 分类数组 bonus_typeid => bonus_type_name
*/
function get_bonus_type()
{
$bonus = array();
$sql = 'SELECT type_id, type_name, type_money FROM ' . $GLOBALS['ecs']->table('bonus_type') .
' WHERE send_type = 3';
$res = $GLOBALS['db']->query($sql);
while ($row = $GLOBALS['db']->fetchRow($res))
{
$bonus[$row['type_id']] = $row['type_name'].' [' .sprintf($GLOBALS['_CFG']['currency_format'], $row['type_money']).']';
}
return $bonus;
}
/**
* 取得用户等级数组,按用户级别排序
* @param bool $is_special 是否只显示特殊会员组
* @return array rank_id=>rank_name
*/
function get_rank_list($is_special = false)
{
$rank_list = array();
$sql = 'SELECT rank_id, rank_name, min_points FROM ' . $GLOBALS['ecs']->table('user_rank');
if ($is_special)
{
$sql .= ' WHERE special_rank = 1';
}
$sql .= ' ORDER BY min_points';
$res = $GLOBALS['db']->query($sql);
while ($row = $GLOBALS['db']->fetchRow($res))
{
$rank_list[$row['rank_id']] = $row['rank_name'];
}
return $rank_list;
}
/**
* 按等级取得用户列表（用于生成下拉列表）
*
* @return array 分类数组 user_id => user_name
*/
function get_user_rank($rankid, $where)
{
$user_list = array();
$sql = 'SELECT user_id, user_name FROM ' . $GLOBALS['ecs']->table('users') . $where.
' ORDER BY user_id DESC';
$res = $GLOBALS['db']->query($sql);
while ($row = $GLOBALS['db']->fetchRow($res))
{
$user_list[$row['user_id']] = $row['user_name'];
}
return $user_list;
}
function get_cfg_val($arr = array()){
$new_arr = array();
if($arr){
foreach($arr as $row){
array_push($new_arr, $row['code'] . "**" . $row['value']);
}
$new_arr2 = array();
foreach($new_arr as $key=>$rows){
$rows = explode('**', $rows);
$new_arr2[$rows[0]] = $rows[1];
}
$new_arr = $new_arr2;
}
return $new_arr;
}
/**
* 取得广告位置数组（用于生成下拉列表）
*
* @return array 分类数组 position_id => position_name
*/
function get_position_list()
{
//ecmoban模板堂 --zhuo start
$adminru = get_admin_ru_id();
$ruCat = '';
if($adminru['ru_id'] > 0){
$ruCat = " where (user_id = '" .$adminru['ru_id']. "' or is_public = 1) ";
}
//ecmoban模板堂 --zhuo end
$position_list = array();
$sql = 'SELECT position_id, position_name, ad_width, ad_height '.
'FROM ' . $GLOBALS['ecs']->table('ad_position') . $ruCat;
$res = $GLOBALS['db']->query($sql);
while ($row = $GLOBALS['db']->fetchRow($res))
{
$position_list[$row['position_id']] = addslashes($row['position_name']). ' [' .$row['ad_width']. 'x' .$row['ad_height']. ']';
}
return $position_list;
}
/**
* 生成编辑器
* @param string input_name 输入框名称
* @param string input_value 输入框值
*/
function create_html_editor($input_name, $input_value = '')
{
global $_CFG,$smarty;
if($_CFG['editing_tools'] == 'fckeditor'){
$editor = new FCKeditor($input_name);
$editor->BasePath = '../includes/fckeditor/';
$editor->ToolbarSet = 'Normal';
$editor->Width = '100%';
$editor->Height = '320';
$editor->Value = $input_value;
$FCKeditor = $editor->CreateHtml();
}else{
$input_height = $_CFG['editing_tools'] == 'ueditor' ? 586:500;
$FCKeditor = '<input type="hidden" id="'.$input_name.'" name="'.$input_name.'" value="'.htmlspecialchars($input_value).'" /><iframe id="'.$input_name.'_frame" src="../plugins/'.$_CFG['editing_tools'].'/ecmobanEditor.php?item='.$input_name.'" width="100%" height="'.$input_height.'" frameborder="0" scrolling="no"></iframe>';
}
$smarty->assign('FCKeditor', $FCKeditor);
}
/**
* 生成编辑器2
* @param string input_name 输入框名称
* @param string input_value 输入框值
*/
function create_html_editor2($input_name, $output_name , $input_value = '')
{
global $_CFG,$smarty;
if($_CFG['editing_tools'] == 'fckeditor'){
$editor = new FCKeditor($input_name);
$editor->BasePath = '../includes/fckeditor/';
$editor->ToolbarSet = 'Normal';
$editor->Width = '100%';
$editor->Height = '320';
$editor->Value = $input_value;
$FCKeditor = $editor->CreateHtml();
}else{
$input_height = $_CFG['editing_tools'] == 'ueditor' ? 586:500;
$FCKeditor = '<input type="hidden" id="'.$input_name.'" name="'.$input_name.'" value="'.htmlspecialchars($input_value).'" /><iframe id="'.$input_name.'_frame" src="../plugins/'.$_CFG['editing_tools'].'/ecmobanEditor.php?item='.$input_name.'" width="100%" height="'.$input_height.'" frameborder="0" scrolling="no"></iframe>';
}
$smarty->assign($output_name, $FCKeditor);
}
/**
* 取得商品列表：用于把商品添加到组合、关联类、赠品类
* @param object $filters 过滤条件
*/
function get_goods_list($filter){
$filter->keyword = json_str_iconv($filter->keyword);
$where = get_where_sql($filter); // 取得过滤条件
/* 取得数据 */
$sql = 'SELECT goods_id, goods_name, shop_price '.
'FROM ' . $GLOBALS['ecs']->table('goods') . ' AS g ' . $where ;
// .' LIMIT 50';
$row = $GLOBALS['db']->getAll($sql);
return $row;
}
/**
* 取得文章列表：用于商品关联文章
* @param object $filters 过滤条件
*/
function get_article_list($filter)
{
/* 创建数据容器对象 */
$ol = new OptionList();
/* 取得过滤条件 */
$where = ' WHERE a.cat_id = c.cat_id AND c.cat_type = 1 ';
$where .= isset($filter->title) ? " AND a.title LIKE '%" . mysql_like_quote($filter->title) . "%'" : '';
/* 取得数据 */
$sql = 'SELECT a.article_id, a.title '.
'FROM ' .$GLOBALS['ecs']->table('article'). ' AS a, ' .$GLOBALS['ecs']->table('article_cat'). ' AS c ' . $where;
$res = $GLOBALS['db']->query($sql);
while ($row = $GLOBALS['db']->fetchRow($res))
{
$ol->add_option($row['article_id'], $row['title']);
}
/* 生成列表 */
$ol->build_select();
}
/**
* 返回是否
* @param int $var 变量 1, 0
*/
function get_yes_no($var)
{
return empty($var) ? '<img src="images/no.gif" border="0" />' : '<img src="images/yes.gif" border="0" />';
}
/**
* 生成过滤条件：用于 get_goodslist 和 get_goods_list
* @param object $filter
* @return string
*/
function get_where_sql($filter)
{
$adminru = get_admin_ru_id();
$time = date('Y-m-d');
$where = isset($filter->is_delete) && $filter->is_delete == '1' ?
' WHERE is_delete = 1 ' : ' WHERE is_delete = 0 ';
$where .= (isset($filter->real_goods) && ($filter->real_goods > -1)) ? ' AND is_real = ' . intval($filter->real_goods) : '';
$where .= isset($filter->cat_id) && $filter->cat_id > 0 ? ' AND ' . get_children($filter->cat_id) : '';
// 品牌搜索 -qin
$brand_keyword = $filter->brand_keyword;
$sel_mode = $filter->sel_mode;
if($filter->brand_keyword)
{
if ($sel_mode == 1 && !empty($brand_keyword))
{
$new_array = array();
if($adminru['ru_id'] > 0)
{
$sql = "SELECT bid FROM ".$GLOBALS['ecs']->table('merchants_shop_brand')." WHERE brandName LIKE '%$brand_keyword%' ";
$brand_id = $GLOBALS['db']->getALL($sql);
foreach ($brand_id as $key => $value)
{
$new_array[] = $value['bid'];
}
}
else
{
$sql = "SELECT brand_id FROM ".$GLOBALS['ecs']->table('brand')." WHERE brand_name LIKE '%$brand_keyword%' ";
$brand_id = $GLOBALS['db']->getAll($sql);
foreach ($brand_id as $key => $value)
{
$new_array[] = $value['brand_id'];
}
}
$where .= isset($filter->brand_keyword) && trim($filter->brand_keyword) != '' ?
" AND brand_id ".db_create_in($new_array)."" : '';
}
elseif ($sel_mode == 1 && !empty($brand_keyword))
{
$filter->brand_id = 0;
}
}
else
{
$where .= isset($filter->brand_id) && $filter->brand_id > 0 ? " AND brand_id = '" . $filter->brand_id . "'" : '';
}
$where .= isset($filter->intro_type) && $filter->intro_type != '0' ? ' AND ' . $filter->intro_type . " = '1'" : '';
$where .= isset($filter->intro_type) && $filter->intro_type == 'is_promote' ?
" AND promote_start_date <= '$time' AND promote_end_date >= '$time' " : '';
$where .= isset($filter->keyword) && trim($filter->keyword) != '' ?
" AND (goods_name LIKE '%" . mysql_like_quote($filter->keyword) . "%' OR goods_sn LIKE '%" . mysql_like_quote($filter->keyword) . "%' OR goods_id LIKE '%" . mysql_like_quote($filter->keyword) . "%') " : '';
$where .= isset($filter->suppliers_id) && trim($filter->suppliers_id) != '' ?
" AND (suppliers_id = '" . $filter->suppliers_id . "') " : '';
$where .= isset($filter->in_ids) ? ' AND goods_id ' . db_create_in($filter->in_ids) : '';
$where .= isset($filter->exclude) ? ' AND goods_id NOT ' . db_create_in($filter->exclude) : '';
$where .= isset($filter->stock_warning) ? ' AND goods_number <= warn_number' : '';
//预售
$where .= isset($filter->presale) ? " AND is_on_sale = 0 " : '';
if(isset($filter->ru_id)){
$where .= " AND user_id = '" .$filter->ru_id. "'";
}else{
if($adminru['ru_id'] > 0){
$where .= " AND user_id = '" .$adminru['ru_id']. "'";
}
}
return $where;
}
function get_where_sql_unpre($filter)
{
$time = date('Y-m-d');
$where = isset($filter->is_delete) && $filter->is_delete == '1' ?
' WHERE g.is_delete = 1 ' : ' WHERE g.is_delete = 0 ';
$where .= (isset($filter->real_goods) && ($filter->real_goods > -1)) ? ' AND g.is_real = ' . intval($filter->real_goods) : '';
$where .= isset($filter->cat_id) && $filter->cat_id > 0 ? ' AND ' . get_children($filter->cat_id) : '';
$where .= isset($filter->brand_id) && $filter->brand_id > 0 ? " AND b.brand_id = '" . $filter->brand_id . "'" : '';
$where .= isset($filter->intro_type) && $filter->intro_type != '0' ? ' AND ' . $filter->intro_type . " = '1'" : '';
$where .= isset($filter->intro_type) && $filter->intro_type == 'g.is_promote' ?
" AND g.promote_start_date <= '$time' AND g.promote_end_date >= '$time' " : '';
$where .= isset($filter->keyword) && trim($filter->keyword) != '' ?
" AND (g.goods_name LIKE '%" . mysql_like_quote($filter->keyword) . "%' OR g.goods_sn LIKE '%" . mysql_like_quote($filter->keyword) . "%' OR g.goods_id LIKE '%" . mysql_like_quote($filter->keyword) . "%') " : '';
$where .= isset($filter->suppliers_id) && trim($filter->suppliers_id) != '' ?
" AND (g.suppliers_id = '" . $filter->suppliers_id . "') " : '';
$where .= isset($filter->in_ids) ? ' AND g.goods_id ' . db_create_in($filter->in_ids) : '';
$where .= isset($filter->exclude) ? ' AND g.goods_id NOT ' . db_create_in($filter->exclude) : '';
$where .= isset($filter->stock_warning) ? ' AND g.goods_number <= warn_number' : '';
return $where;
}
/**
* 获取地区列表的函数。
*
* @access public
* @param int $region_id 上级地区id
* @return void
*/
function area_list($region_id = 0)
{
$area_arr = array();
$sql = 'SELECT * FROM ' . $GLOBALS['ecs']->table('region').
" WHERE parent_id = '$region_id' ORDER BY region_id";
$res = $GLOBALS['db']->query($sql);
$idx = 0;
while ($row = $GLOBALS['db']->fetchRow($res))
{
$row['type'] = ($row['region_type'] == 0) ? $GLOBALS['_LANG']['country'] : '';
$row['type'] .= ($row['region_type'] == 1) ? $GLOBALS['_LANG']['province'] : '';
$row['type'] .= ($row['region_type'] == 2) ? $GLOBALS['_LANG']['city'] : '';
$row['type'] .= ($row['region_type'] == 3) ? $GLOBALS['_LANG']['cantonal'] : '';
$area_arr[$idx] = $row;
$idx++;
}
return $area_arr;
}
function get_insert_region($regionId, $ecs_region){
foreach($ecs_region as $row){
$sql = "select region_id from " .$GLOBALS['ecs']->table('region_warehouse'). " where regionId = '" .$row['region_id']. "'";
$res = $GLOBALS['db']->getOne($sql);
if($res > 0){
}else{
$other = array(
'regionId' => $row['region_id'],
'parent_id' => $regionId,
'region_name' => $row['region_name'],
'region_type' => $row['region_type'],
'agency_id' => $row['agency_id']
);
$GLOBALS['db']->autoExecute($GLOBALS['ecs']->table('region_warehouse'), $other, 'INSERT');
}
}
}
/**
* 取得图表颜色
*
* @access public
* @param integer $n 颜色顺序
* @return void
*/
function chart_color($n)
{
/* 随机显示颜色代码 */
$arr = array('33FF66', 'FF6600', '3399FF', '009966', 'CC3399', 'FFCC33', '6699CC', 'CC3366', '33FF66', 'FF6600', '3399FF');
if ($n > 8)
{
$n = $n % 8;
}
return $arr[$n];
}
/**
* 获得商品类型的列表
*
* @access public
* @param integer $selected 选定的类型编号
* @return string
*/
function goods_type_list($selected, $goods_id = 0)
{
//ecmoban模板堂 --zhuo start
$adminru = get_admin_ru_id();
$ruCat = '';
if($goods_id > 0){
$sql = "select user_id from " .$GLOBALS['ecs']->table('goods'). " where goods_id = '$goods_id'";
$user_id = $GLOBALS['db']->getOne($sql);
if($GLOBALS['_CFG']['attr_set_up'] == 0){
if($adminru['ru_id'] > 0){
$ruCat = " and user_id = 0";
}
}elseif($GLOBALS['_CFG']['attr_set_up'] == 1){
$ruCat = " and user_id = '$user_id'";
}
}else{
if($GLOBALS['_CFG']['attr_set_up'] == 0){
if($adminru['ru_id'] > 0){
$ruCat = " and user_id = 0";
}
}elseif($GLOBALS['_CFG']['attr_set_up'] == 1){
if($adminru['ru_id'] > 0){
$ruCat = " and user_id = '" .$adminru['ru_id']. "'";
}
}
}
//ecmoban模板堂 --zhuo end
$sql = 'SELECT cat_id, cat_name FROM ' . $GLOBALS['ecs']->table('goods_type') . ' WHERE enabled = 1' . $ruCat;
$res = $GLOBALS['db']->query($sql);
$lst = '';
while ($row = $GLOBALS['db']->fetchRow($res))
{
$lst .= "<option value='$row[cat_id]'";
$lst .= ($selected == $row['cat_id']) ? ' selected="true"' : '';
$lst .= '>' . htmlspecialchars($row['cat_name']). '</option>';
}
return $lst;
}
/**
* 取得货到付款和非货到付款的支付方式
* @return array('is_cod' => '', 'is_not_cod' => '')
*/
function get_pay_ids()
{
$ids = array('is_cod' => '0', 'is_not_cod' => '0');
$sql = 'SELECT pay_id, is_cod FROM ' .$GLOBALS['ecs']->table('payment'). ' WHERE enabled = 1';
$res = $GLOBALS['db']->query($sql);
while ($row = $GLOBALS['db']->fetchRow($res))
{
if ($row['is_cod'])
{
$ids['is_cod'] .= ',' . $row['pay_id'];
}
else
{
$ids['is_not_cod'] .= ',' . $row['pay_id'];
}
}
return $ids;
}
/**
* 清空表数据
* @param string $table_name 表名称
*/
function truncate_table($table_name)
{
$sql = 'TRUNCATE TABLE ' .$GLOBALS['ecs']->table($table_name);
return $GLOBALS['db']->query($sql);
}
/**
* 返回字符集列表数组
*
* @access public
* @param
*
* @return void
*/
function get_charset_list()
{
return array(
'UTF8' => 'UTF-8',
'GB2312' => 'GB2312/GBK',
'BIG5' => 'BIG5',
);
}
/**
* 创建一个JSON格式的数据
*
* @access public
* @param string $content
* @param integer $error
* @param string $message
* @param array $append
* @return void
*/
function make_json_response($content='', $error="0", $message='', $append=array())
{
include_once(ROOT_PATH . 'includes/cls_json.php');
$json = new JSON;
$res = array('error' => $error, 'message' => $message, 'content' => $content);
if (!empty($append))
{
foreach ($append AS $key => $val)
{
$res[$key] = $val;
}
}
$val = $json->encode($res);
exit($val);
}
/**
*
*
* @access public
* @param
* @return void
*/
function make_json_result($content, $message='', $append=array())
{
make_json_response($content, 0, $message, $append);
}
/**
* 创建一个JSON格式的错误信息
*
* @access public
* @param string $msg
* @return void
*/
function make_json_error($msg)
{
make_json_response('', 1, $msg);
}
/**
* 根据过滤条件获得排序的标记
*
* @access public
* @param array $filter
* @return array
*/
function sort_flag($filter)
{
$flag['tag'] = 'sort_' . preg_replace('/^.*\./', '', $filter['sort_by']);
$flag['img'] = '<img src="images/' . ($filter['sort_order'] == "DESC" ? 'sort_desc.gif' : 'sort_asc.gif') . '"/>';
return $flag;
}
/**
* 分页的信息加入条件的数组
*
* @access public
* @return array
*/
function page_and_size($filter)
{
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;
}
/* 每页显示 */
$filter['page'] = (empty($_REQUEST['page']) || intval($_REQUEST['page']) <= 0) ? 1 : intval($_REQUEST['page']);
/* page 总数 */
$filter['page_count'] = (!empty($filter['record_count']) && $filter['record_count'] > 0) ? ceil($filter['record_count'] / $filter['page_size']) : 1;
/* 边界处理 */
if ($filter['page'] > $filter['page_count'])
{
$filter['page'] = $filter['page_count'];
}
$filter['start'] = ($filter['page'] - 1) * $filter['page_size'];
return $filter;
}
/**
* 将含有单位的数字转成字节
*
* @access public
* @param string $val 带单位的数字
*
* @return int $val
*/
function return_bytes($val)
{
$val = trim($val);
$last = strtolower($val{strlen($val)-1});
switch($last)
{
case 'g':
$val *= 1024;
case 'm':
$val *= 1024;
case 'k':
$val *= 1024;
}
return $val;
}
/**
* 获得指定的商品类型下所有的属性分组
*
* @param integer $cat_id 商品类型ID
*
* @return array
*/
function get_attr_groups($cat_id)
{
$sql = "SELECT attr_group FROM " . $GLOBALS['ecs']->table('goods_type') . " WHERE cat_id='$cat_id'";
$grp = str_replace("\r", '', $GLOBALS['db']->getOne($sql));
if ($grp)
{
return explode("\n", $grp);
}
else
{
return array();
}
}
/**
* 生成链接后缀
*/
function list_link_postfix()
{
return 'uselastfilter=1';
}
/**
* 保存过滤条件
* @param array $filter 过滤条件
* @param string $sql 查询语句
* @param string $param_str 参数字符串，由list函数的参数组成
*/
function set_filter($filter, $sql, $param_str = '')
{
$filterfile = basename(PHP_SELF, '.php');
if ($param_str)
{
$filterfile .= $param_str;
}
setcookie('ECSCP[lastfilterfile]', sprintf('%X', crc32($filterfile)), time() + 600);
setcookie('ECSCP[lastfilter]', urlencode(serialize($filter)), time() + 600);
setcookie('ECSCP[lastfiltersql]', base64_encode($sql), time() + 600);
}
/**
* 取得上次的过滤条件
* @param string $param_str 参数字符串，由list函数的参数组成
* @return 如果有，返回array('filter' => $filter, 'sql' => $sql)；否则返回false
*/
function get_filter($param_str = '')
{
$filterfile = basename(PHP_SELF, '.php');
if ($param_str)
{
$filterfile .= $param_str;
}
if (isset($_GET['uselastfilter']) && isset($_COOKIE['ECSCP']['lastfilterfile'])
&& $_COOKIE['ECSCP']['lastfilterfile'] == sprintf('%X', crc32($filterfile)))
{
return array(
'filter' => unserialize(urldecode($_COOKIE['ECSCP']['lastfilter'])),
'sql' => base64_decode($_COOKIE['ECSCP']['lastfiltersql'])
);
}
else
{
return false;
}
}
/**
* URL过滤
* @param string $url 参数字符串，一个urld地址,对url地址进行校正
* @return 返回校正过的url;
*/
function sanitize_url($url , $check = 'http://')
{
if (strpos( $url, $check ) === false)
{
$url = $check . $url;
}
return $url;
}
/**
* 检查分类是否已经存在
*
* @param string $cat_name 分类名称
* @param integer $parent_cat 上级分类
* @param integer $exclude 排除的分类ID
*
* @return boolean
*/
function cat_exists($cat_name, $parent_cat, $exclude = 0, $ru_id = 0)
{
if($ru_id > 0){
$sql = "SELECT COUNT(*) FROM " .$GLOBALS['ecs']->table('category') ." AS c, ".
$GLOBALS['ecs']->table('merchants_category') . " AS mc" .
" WHERE c.parent_id = '$parent_cat' AND c.cat_name = '$cat_name' AND c.cat_id<>'$exclude' AND c.cat_id = mc.cat_id AND mc.user_id = '$ru_id'";
return ($GLOBALS['db']->getOne($sql) > 0) ? true : false;
}else{
$sql = "SELECT COUNT(*) FROM " .$GLOBALS['ecs']->table('category').
" WHERE parent_id = '$parent_cat' AND cat_name = '$cat_name' AND cat_id<>'$exclude'";
return ($GLOBALS['db']->getOne($sql) > 0) ? true : false;
}
}
function brand_exists($brand_name)
{
$sql = "SELECT COUNT(*) FROM " .$GLOBALS['ecs']->table('brand').
" WHERE brand_name = '" . $brand_name . "'";
return ($GLOBALS['db']->getOne($sql) > 0) ? true : false;
}
/**
* 获取当前管理员信息
*
* @access public
* @param
*
* @return Array
*/
function admin_info()
{
$sql = "SELECT * FROM ". $GLOBALS['ecs']->table('admin_user')."
WHERE user_id = '$_SESSION[admin_id]'
LIMIT 0, 1";
$admin_info = $GLOBALS['db']->getRow($sql);
if (empty($admin_info))
{
return $admin_info = array();
}
return $admin_info;
}
/**
* 供货商列表信息
*
* @param string $conditions
* @return array
*/
function suppliers_list_info($conditions = '')
{
$where = '';
if (!empty($conditions))
{
$where .= 'WHERE ';
$where .= $conditions;
}
/* 查询 */
$sql = "SELECT suppliers_id, suppliers_name, suppliers_desc
FROM " . $GLOBALS['ecs']->table("suppliers") . "
$where";
return $GLOBALS['db']->getAll($sql);
}
/**
* 供货商名
*
* @return array
*/
function suppliers_list_name()
{
/* 查询 */
$suppliers_list = suppliers_list_info(' is_check = 1 ');
/* 供货商名字 */
$suppliers_name = array();
if (count($suppliers_list) > 0)
{
foreach ($suppliers_list as $suppliers)
{
$suppliers_name[$suppliers['suppliers_id']] = $suppliers['suppliers_name'];
}
}
return $suppliers_name;
}
//商创版--后台程序开发 start
/* 上传文件 start */
function get_upload_pic($fname)
{
$ret = '';
if (empty($_FILES[$fname]['error']) || (!isset($_FILES[$fname]['error']) && isset($_FILES[$fname]['tmp_name']) && $_FILES[$fname]['tmp_name'] != 'none'))
{
// 检查文件格式
if (!check_file_type($_FILES[$fname]['tmp_name'], $_FILES[$fname]['name'], $GLOBALS['allow_file_types']))
{
show_message('无效的文件类型');
}
// 复制文件
$res = upload_teacher_img($_FILES[$fname]);
if ($res != false)
{
$ret = $res;
}
}
return $ret;
}
/* 上传文件 */
function upload_teacher_img($upload)
{
$img_dir ='/goods_attr_img';
if (!make_dir(DATA_DIR . $img_dir))
{
/* 创建目录失败 */
return false;
}
$filename = $GLOBALS['image']->random_filename() . substr($upload['name'], strpos($upload['name'], '.'));
$path = ROOT_PATH. DATA_DIR . $img_dir .'/' . $filename;
if (move_upload_file($upload['tmp_name'], $path))
{
return DATA_DIR . $img_dir .'/' . $filename;
}
else
{
return false;
}
}
/* 上传文件 end */
//属性值信息
function get_add_attr_values($attr_id, $type = 0, $list = array()){
$sql = "select attr_values from " .$GLOBALS['ecs']->table('attribute'). " where attr_id = '$attr_id'";
$attr_values = $GLOBALS['db']->getOne($sql);
if(!empty($attr_values)){
$attr_values = preg_replace("/\r\n/",",",$attr_values); //替换空格回车换行符 为 英文逗号
$attr_values = explode(',', $attr_values);
$arr = array();
for($i=0; $i<count($attr_values); $i++){
$sql = "select attr_img, attr_site from " .$GLOBALS['ecs']->table('attribute_img'). " where attr_id = '$attr_id' and attr_values = '" .$attr_values[$i]. "'";
$res = $GLOBALS['db']->getRow($sql);
$arr[$i]['values'] = $attr_values[$i];
$arr[$i]['attr_img'] = $res['attr_img'];
$arr[$i]['attr_site'] = $res['attr_site'];
if($type == 1){
if($list){
foreach($list as $lk=>$row){
if($attr_values[$i] == $row[0]){
$arr[$i]['color'] = !empty($row[1]) ? $row[1] : '';
}
}
}
}
}
return $arr;
}else{
return array();
}
}
//添加或修改属性图片
function get_attrimg_insert_update($attr_id, $attr_values){
include_once(ROOT_PATH . '/includes/cls_image.php');
$image = new cls_image($_CFG['bgcolor']);
if(count($attr_values) > 0){
for($i=0; $i<count($attr_values); $i++){
$upload = $_FILES['attr_img_' . $i];
$attr_site = trim($_POST['attr_site_' . $i]);
$upFile = $image->upload_image($upload, 'septs_Image/attr_img_' . $attr_id);
$upFile = !empty($upFile) ? $upFile : '';
$sql = "select id, attr_img from " .$GLOBALS['ecs']->table('attribute_img'). " where attr_id = '$attr_id' and attr_values = '" .$attr_values[$i]['values']. "'";
$res = $GLOBALS['db']->getRow($sql);
$drop_img = 0;
if(empty($upFile)){
$upFile = $res['attr_img'];
}
$other = array(
'attr_id' =>$attr_id,
'attr_values' =>$attr_values[$i]['values'],
'attr_img' =>$upFile,
'attr_site' =>$attr_site,
);
if(!empty($upFile)){
if($res['id'] > 0){
if($upFile != $res['attr_img']){ //更新图片之前将上一张图片删除
@unlink(ROOT_PATH . $res['attr_img']);
}
$GLOBALS['db']->autoExecute($GLOBALS['ecs']->table('attribute_img'), $other, "UPDATE", "attr_id = '$attr_id' and attr_values = '" .$attr_values[$i]['values']. "'");
}else{
$GLOBALS['db']->autoExecute($GLOBALS['ecs']->table('attribute_img'), $other, "INSERT");
}
}
}
}
}
//添加或编辑关联商品ID，实现多商品共同描述内容
function get_add_edit_link_desc($linked_array, $type = 0, $id = 0){
if($linked_array){
$arr['goods_id'] = '';
for($i=0; $i<count($linked_array); $i++){
$arr['goods_id'] .= $linked_array[$i] . ',';
}
if($id > 0){
$sql = "select goods_id from " .$GLOBALS['ecs']->table('link_goods_desc'). " where id = '$id'";
$desc_goods_id = $GLOBALS['db']->getOne($sql);
}
$arr['goods_id'] = substr($arr['goods_id'], 0, -1);
$other['goods_id'] = $arr['goods_id'];
if(!empty($desc_goods_id) && $type != 1){
$other['goods_id'] = $other['goods_id'] . ',' . $desc_goods_id;
$other['goods_id'] = explode(',', $other['goods_id']);
$other['goods_id'] = array_unique($other['goods_id']);
$other['goods_id'] = implode(',', $other['goods_id']);
}
$sql = "select goods_id from " .$GLOBALS['ecs']->table('link_desc_temporary'). " where 1 limit 0, 1";
$tgoods = $GLOBALS['db']->getOne($sql);
if($type == 1){ //删除 由右至左
if(!empty($tgoods)){
$other['goods_id'] = get_del_in_val($tgoods, $other['goods_id']);
$GLOBALS['db']->autoExecute($GLOBALS['ecs']->table('link_desc_temporary'), $other, "UPDATE", "1");
}else{
$other['goods_id'] = get_del_in_val($desc_goods_id, $other['goods_id']);
$GLOBALS['db']->autoExecute($GLOBALS['ecs']->table('link_desc_temporary'), $other, "INSERT");
}
}else{ //添加 由左至右
if(!empty($tgoods)){
$other['goods_id'] .= ',' . $tgoods;
$other['goods_id'] = get_other_goods_id($other['goods_id']);
$GLOBALS['db']->autoExecute($GLOBALS['ecs']->table('link_desc_temporary'), $other, "UPDATE", "1");
}else{
$GLOBALS['db']->autoExecute($GLOBALS['ecs']->table('link_desc_temporary'), $other, "INSERT");
}
}
}
}
//处理重复值
function get_other_goods_id($goods_id){
$goods_id = explode(',', $goods_id);
$goods_id = array_unique($goods_id);
$goods_id = implode(',', $goods_id);
return $goods_id;
}
//查询临时关联商品ID表信息
function get_linked_goods_desc($id = 0){
if($id > 0){
$table = "link_goods_desc";
$where = ' where id = ' . $id;
}else{
$table = "link_desc_temporary";
$where = ' where 1';
}
$sql = "select goods_id from " .$GLOBALS['ecs']->table($table). $where;
$goods_id = $GLOBALS['db']->getOne($sql);
$arr = array();
if(!empty($goods_id)){
$goods_id = explode(',', $goods_id);
for($i=0; $i<count($goods_id); $i++){
$sql = "select goods_name from " .$GLOBALS['ecs']->table('goods'). " where goods_id = '" .$goods_id[$i]. "'";
$goods_name = $GLOBALS['db']->getOne($sql);
$arr[$i]['goods_id'] = $goods_id[$i];
$arr[$i]['goods_name'] = $goods_name;
}
}
return $arr;
}
//添加关联商品ID
function get_add_desc_goodsId($goods_id, $id){
if(!empty($goods_id)){
$goods_id = explode(',', $goods_id);
for($i=0; $i<count($goods_id); $i++){
$other = array(
'goods_id' => $goods_id[$i],
'd_id' => $id,
);
$GLOBALS['db']->autoExecute($GLOBALS['ecs']->table('link_desc_goodsid'), $other, "INSERT");
}
}
}
//去除商家主订单显示
function get_main_order_nodisplay($order_list){
if($order_list['orders']){
$arr = array();
foreach($order_list['orders'] as $key=>$row){
$arr[$key] = $row;
if($arr[$key]['order_child'] > 0){
unset($arr[$key]);
}
}
$order_list['orders'] = $arr;
}
return $order_list;
}
//批量添加分类
function get_bacth_category($cat_name, $cat, $ru_id){
for($i=0; $i<count($cat_name); $i++){
if(!empty($cat_name)){
$cat['cat_name'] = $cat_name[$i];
if ($GLOBALS['db']->autoExecute($GLOBALS['ecs']->table('category'), $cat) !== false)
{
$cat_id = $GLOBALS['db']->insert_id();
if($cat['show_in_nav'] == 1)
{
$vieworder = $GLOBALS['db']->getOne("SELECT max(vieworder) FROM ". $GLOBALS['ecs']->table('nav') . " WHERE type = 'middle'");
$vieworder += 2;
//显示在自定义导航栏中
$sql = "INSERT INTO " . $GLOBALS['ecs']->table('nav') .
" (name,ctype,cid,ifshow,vieworder,opennew,url,type)".
" VALUES('" . $cat['cat_name'] . "', 'c', '$cat_id','1','$vieworder','0', '" . build_uri('category', array('cid'=> $cat_id), $cat['cat_name']) . "','middle')";
$GLOBALS['db']->query($sql);
}
insert_cat_recommend($cat['cat_recommend'], $cat_id);
if($ru_id > 0){
$parent = array(
'cat_id' => $cat_id,
'user_id' => $ru_id,
'is_show' => $cat['is_show_merchants'],
'add_titme' => gmtime()
);
$GLOBALS['db']->autoExecute($GLOBALS['ecs']->table('merchants_category'), $parent, 'INSERT');
}
admin_log($cat['cat_name'], 'add', 'category'); // 记录管理员操作
}
}
}
}
/**
* 检查退换货原因是否有存在
* @param type $cause_name
* @return type
*/
function cause_exists( $cause_name, $c_id = 0){
$where = !empty($c_id) ? " AND cause_id <> '$c_id'" : '';
$sql = "SELECT COUNT(*) FROM " .$GLOBALS['ecs']->table('return_cause').
" WHERE cause_name = '" . $cause_name . "'" . $where;
return ($GLOBALS['db']->getOne($sql) > 0) ? true : false;
}
/**
* 退换货 by Leah
* @return type
*/
function return_order_list() {
$result = get_filter();
$adminru = get_admin_ru_id();
if ($result === false) {
/* 过滤信息 */
$filter['order_sn'] = empty($_REQUEST['order_sn']) ? '' : trim($_REQUEST['order_sn']);
if (!empty($_GET['is_ajax']) && $_GET['is_ajax'] == 1) {
$_REQUEST['consignee'] = json_str_iconv($_REQUEST['consignee']);
//$_REQUEST['address'] = json_str_iconv($_REQUEST['address']);
}
$filter['return_sn'] = isset($_REQUEST['return_sn']) ? trim($_REQUEST['return_sn']) : '';
$filter['order_id'] = isset($_REQUEST['order_id']) ? intval($_REQUEST['order_id']) : 0;
$filter['consignee'] = empty($_REQUEST['consignee']) ? '' : trim($_REQUEST['consignee']);
$filter['email'] = empty($_REQUEST['email']) ? '' : trim($_REQUEST['email']);
$filter['address'] = empty($_REQUEST['address']) ? '' : trim($_REQUEST['address']);
$filter['zipcode'] = empty($_REQUEST['zipcode']) ? '' : trim($_REQUEST['zipcode']);
$filter['tel'] = empty($_REQUEST['tel']) ? '' : trim($_REQUEST['tel']);
$filter['mobile'] = empty($_REQUEST['mobile']) ? 0 : intval($_REQUEST['mobile']);
$filter['country'] = empty($_REQUEST['country']) ? 0 : intval($_REQUEST['country']);
$filter['province'] = empty($_REQUEST['province']) ? 0 : intval($_REQUEST['province']);
$filter['city'] = empty($_REQUEST['city']) ? 0 : intval($_REQUEST['city']);
$filter['district'] = empty($_REQUEST['district']) ? 0 : intval($_REQUEST['district']);
$filter['shipping_id'] = empty($_REQUEST['shipping_id']) ? 0 : intval($_REQUEST['shipping_id']);
$filter['pay_id'] = empty($_REQUEST['pay_id']) ? 0 : intval($_REQUEST['pay_id']);
$filter['order_status'] = isset($_REQUEST['order_status']) ? intval($_REQUEST['order_status']) : -1;
$filter['shipping_status'] = isset($_REQUEST['shipping_status']) ? intval($_REQUEST['shipping_status']) : -1;
$filter['pay_status'] = isset($_REQUEST['pay_status']) ? intval($_REQUEST['pay_status']) : -1;
$filter['user_id'] = empty($_REQUEST['user_id']) ? 0 : intval($_REQUEST['user_id']);
$filter['user_name'] = empty($_REQUEST['user_name']) ? '' : trim($_REQUEST['user_name']);
$filter['composite_status'] = isset($_REQUEST['composite_status']) ? intval($_REQUEST['composite_status']) : -1;
$filter['group_buy_id'] = isset($_REQUEST['group_buy_id']) ? intval($_REQUEST['group_buy_id']) : 0;
$filter['return_type'] = isset($_REQUEST['return_type']) ? intval($_REQUEST['return_type']) : -1;
$filter['sort_by'] = empty($_REQUEST['sort_by']) ? 'ret_id' : trim($_REQUEST['sort_by']);
$filter['sort_order'] = empty($_REQUEST['sort_order']) ? 'DESC' : trim($_REQUEST['sort_order']);
$filter['start_time'] = empty($_REQUEST['start_time']) ? '' : (strpos($_REQUEST['start_time'], '-') > 0 ? local_strtotime($_REQUEST['start_time']) : $_REQUEST['start_time']);
$filter['end_time'] = empty($_REQUEST['end_time']) ? '' : (strpos($_REQUEST['end_time'], '-') > 0 ? local_strtotime($_REQUEST['end_time']) : $_REQUEST['end_time']);
$where = 'WHERE 1 ';
if($adminru['ru_id'] > 0){
$where .= " AND (SELECT og.ru_id FROM " . $GLOBALS['ecs']->table('order_goods') .' as og' . " WHERE og.order_id = o.order_id limit 0, 1) = '" .$adminru['ru_id']. "' ";
$no_main_order = " and (select count(*) from " .$GLOBALS['ecs']->table('order_info'). " as oi2 where oi2.main_order_id = o.order_id) = 0 "; //主订单下有子订单时，则主订单不显示
}
if($filter['order_id']){
$where .= " AND o.order_id = '" .$filter['order_id']. "'";
}
if ($filter['return_sn']) {
$where .= " AND r.return_sn LIKE '%" . mysql_like_quote($filter['return_sn']) . "%'";
}
if ($filter['order_sn']) {
$where .= " AND o.order_sn LIKE '%" . mysql_like_quote($filter['order_sn']) . "%'";
}
if ($filter['consignee']) {
$where .= " AND o.consignee LIKE '%" . mysql_like_quote($filter['consignee']) . "%'";
}
if ($filter['email']) {
$where .= " AND o.email LIKE '%" . mysql_like_quote($filter['email']) . "%'";
}
if ($filter['address']) {
$where .= " AND o.address LIKE '%" . mysql_like_quote($filter['address']) . "%'";
}
if ($filter['zipcode']) {
$where .= " AND o.zipcode LIKE '%" . mysql_like_quote($filter['zipcode']) . "%'";
}
if ($filter['tel']) {
$where .= " AND o.tel LIKE '%" . mysql_like_quote($filter['tel']) . "%'";
}
if ($filter['mobile']) {
$where .= " AND o.mobile LIKE '%" . mysql_like_quote($filter['mobile']) . "%'";
}
if ($filter['country']) {
$where .= " AND o.country = '$filter[country]'";
}
if ($filter['province']) {
$where .= " AND o.province = '$filter[province]'";
}
if ($filter['city']) {
$where .= " AND o.city = '$filter[city]'";
}
if ($filter['district']) {
$where .= " AND o.district = '$filter[district]'";
}
if ($filter['shipping_id']) {
$where .= " AND o.shipping_id = '$filter[shipping_id]'";
}
if ($filter['pay_id']) {
$where .= " AND o.pay_id = '$filter[pay_id]'";
}
if ($filter['order_status'] != -1) {
$where .= " AND o.order_status = '$filter[order_status]'";
}
if ($filter['shipping_status'] != -1) {
$where .= " AND o.shipping_status = '$filter[shipping_status]'";
}
if ($filter['pay_status'] != -1) {
$where .= " AND o.pay_status = '$filter[pay_status]'";
}
if ($filter['user_id']) {
$where .= " AND o.user_id = '$filter[user_id]'";
}
if ($filter['user_name']) {
$where .= " AND u.user_name LIKE '%" . mysql_like_quote($filter['user_name']) . "%'";
}
if ($filter['start_time']) {
$where .= " AND o.add_time >= '$filter[start_time]'";
}
if ($filter['end_time']) {
$where .= " AND o.add_time <= '$filter[end_time]'";
}
if ($filter['return_type'] != -1) {
$where .= " AND r.return_type = '$filter[return_type]'";
}
//综合状态
switch ($filter['composite_status']) {
case CS_AWAIT_PAY :
$where .= order_query_sql('await_pay');
break;
case CS_AWAIT_SHIP :
$where .= order_query_sql('await_ship');
break;
case CS_FINISHED :
$where .= order_query_sql('finished');
break;
case PS_PAYING :
if ($filter['composite_status'] != -1) {
$where .= " AND o.pay_status = '$filter[composite_status]' ";
}
break;
case OS_SHIPPED_PART :
if ($filter['composite_status'] != -1) {
$where .= " AND o.shipping_status = '$filter[composite_status]'-2 ";
}
break;
default:
if ($filter['composite_status'] != -1) {
$where .= " AND o.order_status = '$filter[composite_status]' ";
}
}
/* 团购订单 */
if ($filter['group_buy_id']) {
$where .= " AND o.extension_code = 'group_buy' AND o.extension_id = '$filter[group_buy_id]' ";
}
/* 如果管理员属于某个办事处，只列出这个办事处管辖的订单 */
$sql = "SELECT agency_id FROM " . $GLOBALS['ecs']->table('admin_user') . " WHERE user_id = '$_SESSION[admin_id]'";
$agency_id = $GLOBALS['db']->getOne($sql);
if ($agency_id > 0) {
$where .= " AND o.agency_id = '$agency_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;
}
//管理员查询的权限 -- 店铺查询 start
$filter['store_search'] = !isset($_REQUEST['store_search']) ? -1 : 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 = -1;
$store_where = '';
$store_search_where = '';
if($filter['store_search'] > -1){
if($adminru['ru_id'] == 0){
if($filter['store_search'] > 0){
if($_REQUEST['store_type']){
$store_search_where = "AND msi.shopNameSuffix = '" .$_REQUEST['store_type']. "'";
}
$no_main_order = " and (select count(*) from " .$GLOBALS['ecs']->table('order_info'). " as oi2 where oi2.main_order_id = o.order_id) = 0 "; //主订单下有子订单时，则主订单不显示
if($filter['store_search'] == 1){
$where .= " AND (SELECT og.ru_id FROM " . $GLOBALS['ecs']->table('order_goods') .' as og' . " WHERE og.order_id = o.order_id limit 0, 1) = '" .$filter['merchant_id']. "' ";
}elseif($filter['store_search'] == 2){
$store_where .= " AND msi.rz_shopName LIKE '%" . mysql_like_quote($filter['store_keyword']) . "%'";
}elseif($filter['store_search'] == 3){
$store_where .= " AND msi.shoprz_brandName LIKE '%" . mysql_like_quote($filter['store_keyword']) . "%' " . $store_search_where;
}
if($filter['store_search'] > 1){
$where .= " AND (SELECT og.ru_id FROM " . $GLOBALS['ecs']->table('order_goods') .' as og, ' .
$GLOBALS['ecs']->table('merchants_shop_information') .' as msi ' .
" WHERE og.order_id = o.order_id AND msi.user_id = og.ru_id $store_where limit 0, 1) > 0 ";
}
}else{
$store_search = 0;
}
}
}
//管理员查询的权限 -- 店铺查询 end
if($store_search == 0 && $adminru['ru_id'] == 0){
$where_store = " AND (SELECT COUNT(*) FROM " .$GLOBALS['ecs']->table('order_goods') ." AS og ". " WHERE o.order_id = og.order_id AND og.ru_id = 0 limit 0,1) > 0 ".
" AND (select count(*) from " .$GLOBALS['ecs']->table('order_info'). " as oi2 where oi2.main_order_id = o.order_id) = 0";
}else{
$where_store = '';
}
/* 记录总数 */
if ($filter['user_name']) {
$sql = "SELECT COUNT(*) FROM " . $GLOBALS['ecs']->table('order_return') . " AS o ," .
$GLOBALS['ecs']->table('users') . " AS u " . $where . $where_store;
} else {
$sql = "SELECT COUNT(*) FROM " . $GLOBALS['ecs']->table('order_return') . " AS r, " .$GLOBALS['ecs']->table('order_info'). " as o " . $where . " AND r.order_id = o.order_id";
}
$filter['record_count'] = $GLOBALS['db']->getOne($sql);
$filter['page_count'] = $filter['record_count'] > 0 ? ceil($filter['record_count'] / $filter['page_size']) : 1;
/* 查询 */
$sql = "SELECT o.order_id, o.order_sn, o.add_time, o.order_status, o.shipping_status, o.order_amount, o.money_paid, og.ru_id," .
"o.pay_status, o.consignee, o.address, o.email, o.tel, o.extension_code, o.extension_id," .
"r.ret_id ,r.rec_id , r.back , r.exchange ,r.attr_val , r.cause_id , r.apply_time , r.should_return , r.actual_return , r.remark , r.address , o.sign_time ,r.return_status , r.refound_status , " .
" r.return_type, r.addressee, r.phone, r.return_sn, " .
"(" . order_amount_field('o.') . ") AS total_fee, " .
"IFNULL(u.user_name, '" . $GLOBALS['_LANG']['anonymous'] . "') AS buyer " .
"FROM " . $GLOBALS['ecs']->table('order_return') ." AS r ".
"LEFT JOIN ". $GLOBALS['ecs']->table('order_info') . " AS o ON r.order_id = o.order_id " .
"LEFT JOIN " . $GLOBALS['ecs']->table('order_goods') . " AS og ON og.order_id=o.order_id " .
"LEFT JOIN " . $GLOBALS['ecs']->table('users') . " AS u ON u.user_id=o.user_id " .$where .$where_store.
" GROUP BY r.ret_id ORDER BY $filter[sort_by] $filter[sort_order] " .
" LIMIT " . ($filter['page'] - 1) * $filter['page_size'] . ",$filter[page_size]";
foreach (array('order_sn', 'consignee', 'email', 'address', 'zipcode', 'tel', 'user_name') AS $val) {
$filter[$val] = stripslashes($filter[$val]);
}
set_filter($filter, $sql);
} else {
$sql = $result['sql'];
$filter = $result['filter'];
}
$row = $GLOBALS['db']->getAll($sql);
/* 格式话数据 */
foreach ($row AS $key => $value) {
$row[$key]['formated_order_amount'] = price_format($value['order_amount']);
$row[$key]['formated_money_paid'] = price_format($value['money_paid']);
$row[$key]['formated_total_fee'] = price_format($value['total_fee']);
$row[$key]['short_order_time'] = local_date('m-d H:i', $value['add_time']);
$row[$key]['apply_time'] = local_date('m-d H:i', $value['apply_time']);
$row[$key]['sign_time'] = local_date('m-d H:i', $value['sign_time']);
$row[$key]['user_name'] = get_shop_name($value['ru_id'], 1); //ecmoban模板堂 --zhuo
$sql = "select return_number from " .$GLOBALS['ecs']->table('return_goods'). " where rec_id = '" .$value['rec_id']. "'";
$return_number = $GLOBALS['db']->getOne($sql);
$row[$key]['return_number'] = $return_number;
$row[$key]['address_detail'] = get_consignee_info($value['order_id'], $value['address']);
if ($value['order_status'] == OS_INVALID || $value['order_status'] == OS_CANCELED) {
/* 如果该订单为无效或取消则显示删除链接 */
$row[$key]['can_remove'] = 1;
} else {
$row[$key]['can_remove'] = 0;
}
if($value['return_type'] == 0){
if($value['return_status'] == 4){
$row[$key]['refound_status'] = FF_MAINTENANCE;
}else{
$row[$key]['refound_status'] = FF_NOMAINTENANCE;
}
}else if($value['return_type'] == 1){
if($value['refound_status'] == 1){
$row[$key]['refound_status'] = FF_REFOUND;
}else{
$row[$key]['refound_status'] = FF_NOREFOUND;
}
}else if($value['return_type'] == 2){
if($value['return_status'] == 4){
$row[$key]['refound_status'] = FF_EXCHANGE;
}else{
$row[$key]['refound_status'] = FF_NOEXCHANGE;
}
}
}
$arr = array('orders' => $row, 'filter' => $filter, 'page_count' => $filter['page_count'], 'record_count' => $filter['record_count']);
return $arr;
}
//商创版--后台程序开发 end
/** by li
* 记录降价通知，邮件发送情况
*
* @access public
* @param string $sn 数据的唯一值
* @param string $action 操作的类型
* @param string $content 操作的内容
* @return void
*/
function notice_log($goods_id,$email,$send_ok,$send_type)
{
$sql = 'INSERT INTO ' . $GLOBALS['ecs']->table('notice_log') . ' (goods_id, email, send_ok, send_time, send_type) ' .
" VALUES ('$goods_id', '$email', '$send_ok', '" . gmtime() . "', '$send_type')";
$GLOBALS['db']->query($sql);
}
//体验产品函数 --ecmoban by zhuo
function get_invite_Instantiation($sc_contents = ''){
$row = explode('-', $sc_contents);
$arr['invite_code'] = $row[0];
$arr['active_time'] = $row[1];
$arr['end_time'] = $row[2];
return $arr;
}
//查询插件权限
function get_merchants_permissions($admin_id = 0, $string = ''){
$sql = "SELECT action_list FROM " .$GLOBALS['ecs']->table('admin_user'). " WHERE user_id = '$admin_id'";
$action_list = $GLOBALS['db']->getOne($sql);
if($action_list == 'all'){
return 1;
}else{
$action_list = explode(',', $action_list);
if(in_array($string, $action_list)){
return 1;
}else{
return 0;
}
}
}
//删除商家信息 start
function get_delete_seller_info($table = '', $where = ''){
if(!empty($table) && !empty($where)){
$sql = "DELETE FROM " .$GLOBALS['ecs']->table($table). " WHERE $where";
$GLOBALS['db']->query($sql);
}
}
//删除商家订单
function get_seller_delete_order_list($ru_id){
$sql = "SELECT order_id FROM " .$GLOBALS['ecs']->table('order_goods'). " WHERE ru_id = '$ru_id'";
$order_id = $GLOBALS['db']->getOne($sql);
$sql = "SELECT ret_id FROM " .$GLOBALS['ecs']->table('order_return'). " WHERE order_id = '$order_id'";
$ret_list = $GLOBALS['db']->getAll($sql);
foreach($ret_list as $key=>$row){
$GLOBALS['db']->query("DELETE FROM " .$GLOBALS['ecs']->table('return_goods'). " WHERE rec_id = '" .$row['ret_id']. "'");
$GLOBALS['db']->query("DELETE FROM " .$GLOBALS['ecs']->table('return_action'). " WHERE rec_id = '" .$row['ret_id']. "'");
}
$GLOBALS['db']->query("DELETE FROM " .$GLOBALS['ecs']->table('order_return'). " WHERE order_id = '$order_id'");
$GLOBALS['db']->query("DELETE FROM " .$GLOBALS['ecs']->table('order_info'). " WHERE order_id = '$order_id'");
$GLOBALS['db']->query("DELETE FROM " .$GLOBALS['ecs']->table('order_goods'). " WHERE ru_id = '$ru_id'");
}
//删除商家商品
function get_seller_delete_goods_list($ru_id){
get_delete_seller_info('goods', "user_id = '$ru_id'"); //删除商家商品
//删除商家属性
$sql = "SELECT cat_id FROM " .$GLOBALS['ecs']->table('goods_type'). " WHERE user_id = '$ru_id'";
$goods_type = $GLOBALS['db']->getAll($sql);
foreach($goods_type as $key=>$row){
$sql = "SELECT attr_id FROM " .$GLOBALS['ecs']->table('attribute'). " WHERE cat_id = '" .$row['cat_id']. "'";
$attribute_list = $GLOBALS['db']->getAll($sql);
foreach($attribute_list as $arow){
$GLOBALS['db']->query("DELETE FROM " .$GLOBALS['ecs']->table('goods_attr'). " WHERE attr_id = '" .$row['attr_id']. "'");
}
}
}
//删除商家信息 end
//获取URL文件名称
function get_php_self($type = 0){
$php_self = substr($_SERVER['PHP_SELF'],strrpos($_SERVER['PHP_SELF'],'/')+1);
if($type == 1){
$self = explode('.', $php_self);
$php_self = $self[0];
}
return $php_self;
}
?>