1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021 |
- <?php
- /**
- * 易优CMS
- * ============================================================================
- * 版权所有 2016-2028 海南赞赞网络科技有限公司,并保留所有权利。
- * 网站地址: http://www.eyoucms.com
- * ----------------------------------------------------------------------------
- * 如果商业用途务必到官方购买正版授权, 以免引起不必要的法律纠纷.
- * ============================================================================
- * Author: 小虎哥 <1105415366@qq.com>
- * Date: 2018-4-3
- */
- namespace app\admin\controller;
- use app\admin\controller\Base;
- use think\Controller;
- use think\Db;
- class Index extends Base
- {
- public function index()
- {
- $language_db = Db::name('language');
- /*多语言列表*/
- $web_language_switch = tpCache('web.web_language_switch');
- $languages = [];
- if (1 == intval($web_language_switch)) {
- $languages = $language_db->field('a.mark, a.title')
- ->alias('a')
- ->where('a.status',1)
- ->getAllWithIndex('mark');
- }
- $this->assign('languages', $languages);
- $this->assign('web_language_switch', $web_language_switch);
- /*--end*/
- /*小程序开关*/
- $web_diyminipro_switch = tpCache('web.web_diyminipro_switch');
- if (!is_dir('./weapp/Diyminipro/') || $this->admin_lang != $this->main_lang) {
- $web_diyminipro_switch = -1;
- }
- $this->assign('web_diyminipro_switch', $web_diyminipro_switch);
- /*end*/
- /*网站首页链接*/
- // 去掉入口文件
- $inletStr = '/index.php';
- $seo_inlet = config('ey_config.seo_inlet');
- 1 == intval($seo_inlet) && $inletStr = '';
- // --end
- $home_default_lang = config('ey_config.system_home_default_lang');
- $admin_lang = $this->admin_lang;
- $home_url = request()->domain().ROOT_DIR.'/'; // 支持子目录
- if ($home_default_lang != $admin_lang) {
- $home_url = $language_db->where(['mark'=>$admin_lang])->getField('url');
- if (empty($home_url)) {
- $seoConfig = tpCache('seo');
- $seo_pseudo = !empty($seoConfig['seo_pseudo']) ? $seoConfig['seo_pseudo'] : config('ey_config.seo_pseudo');
- if (1 == $seo_pseudo) {
- $home_url = request()->domain().ROOT_DIR.$inletStr; // 支持子目录
- if (!empty($inletStr)) {
- $home_url .= '?';
- } else {
- $home_url .= '/?';
- }
- $home_url .= http_build_query(['lang'=>$admin_lang]);
- } else {
- $home_url = request()->domain().ROOT_DIR.$inletStr.'/'.$admin_lang; // 支持子目录
- }
- }
- }
- $this->assign('home_url', $home_url);
- /*--end*/
- $this->assign('admin_info', getAdminInfo(session('admin_id')));
- $this->assign('menu',getMenuList());
- /*检测是否存在会员中心模板*/
- $globalConfig = tpCache('global');
- if ('v1.0.1' > getVersion('version_themeusers') && !empty($globalConfig['web_users_switch'])) {
- $is_syn_theme_users = 1;
- } else {
- $is_syn_theme_users = 0;
- }
- $this->assign('is_syn_theme_users',$is_syn_theme_users);
- /*--end*/
- return $this->fetch();
- }
-
- public function welcome()
- {
- $globalConfig = tpCache('global');
- /*百度分享*/
- /* $share = array(
- 'bdText' => $globalConfig['web_title'],
- 'bdPic' => is_http_url($globalConfig['web_logo']) ? $globalConfig['web_logo'] : request()->domain().$globalConfig['web_logo'],
- 'bdUrl' => $globalConfig['web_basehost'],
- );
- $this->assign('share',$share);*/
- /*--end*/
- /*小程序组件更新*/
- $is_update_component_access = 1;
- if (!is_dir('./weapp/Diyminipro/') || $this->admin_lang != $this->main_lang) {
- $is_update_component_access = 0;
- }
- $this->assign('is_update_component_access', $is_update_component_access);
- /*end*/
- // 纠正上传附件的大小,始终以空间大小为准
- $file_size = $globalConfig['file_size'];
- $maxFileupload = @ini_get('file_uploads') ? ini_get('upload_max_filesize') : 0;
- $maxFileupload = intval($maxFileupload);
- if (empty($file_size) || $file_size > $maxFileupload) {
- /*多语言*/
- if (is_language()) {
- $langRow = Db::name('language')->cache(true, EYOUCMS_CACHE_TIME, 'language')
- ->order('id asc')
- ->select();
- foreach ($langRow as $key => $val) {
- tpCache('basic', ['file_size'=>$maxFileupload], $val['mark']);
- }
- } else { // 单语言
- tpCache('basic', ['file_size'=>$maxFileupload]);
- }
- /*--end*/
- }
- /*未备份数据库提示*/
- $system_explanation_welcome = !empty($globalConfig['system_explanation_welcome']) ? $globalConfig['system_explanation_welcome'] : 0;
- $sqlfiles = glob(DATA_PATH.'sqldata/*');
- foreach ($sqlfiles as $file) {
- if(stristr($file, getCmsVersion())){
- $system_explanation_welcome = 1;
- }
- }
- $this->assign('system_explanation_welcome', $system_explanation_welcome);
- /*--end*/
- /*检查密码复杂度*/
- $admin_login_pwdlevel = -1;
- $system_explanation_welcome_2 = !empty($globalConfig['system_explanation_welcome_2']) ? $globalConfig['system_explanation_welcome_2'] : 0;
- if (empty($system_explanation_welcome_2)) {
- $admin_login_pwdlevel = session('admin_login_pwdlevel');
- if (!session('?admin_login_pwdlevel') || 3 < intval($admin_login_pwdlevel)) {
- $system_explanation_welcome_2 = 1;
- }
- }
- $this->assign('admin_login_pwdlevel', $admin_login_pwdlevel);
- $this->assign('system_explanation_welcome_2', $system_explanation_welcome_2);
- /*end*/
- // 同步导航与内容统计的状态
- $this->syn_open_quickmenu();
- // 快捷导航
- $quickMenu = Db::name('quickentry')->where([
- 'type' => 1,
- 'checked' => 1,
- 'status' => 1,
- ])->order('sort_order asc, id asc')->select();
- foreach ($quickMenu as $key => $val) {
- $quickMenu[$key]['vars'] = !empty($val['vars']) ? $val['vars']."&lang=".$this->admin_lang : "lang=".$this->admin_lang;
- }
- $this->assign('quickMenu',$quickMenu);
- // 内容统计
- $contentTotal = $this->contentTotalList();
- $this->assign('contentTotal',$contentTotal);
- // 服务器信息
- $this->assign('sys_info',$this->get_sys_info());
- // 升级弹窗
- $this->assign('web_show_popup_upgrade', $globalConfig['web_show_popup_upgrade']);
- // 升级系统时,同时处理sql语句
- $this->synExecuteSql();
- $ajaxLogic = new \app\admin\logic\AjaxLogic;
- $ajaxLogic->update_template('users'); // 升级前台会员中心的模板文件
- $ajaxLogic->syn_guestbook_attribute(); // 只同步一次每个留言栏目的字段列表前4个显示(v1.5.1节点去掉)
- $ajaxLogic->syn_wechat_login_config(); // 只同步一次微信登录配置信息(v1.5.1节点去掉)
- $ajaxLogic->system_langnum_file(); // 记录当前是多语言还是单语言到文件里
- $ajaxLogic->syn_admin_logic_sms_template(); // 同步手机短信模板(v1.5.1节点去掉)
- $ajaxLogic->admin_logic_unlink(); // 删除多余Minipro的文件(v1.5.1节点去掉)
- $ajaxLogic->admin_logic_update_basic(); // 纠正允许上传文件类型(v1.5.1节点去掉)
- $ajaxLogic->admin_logic_update_tag(); // 纠正tag标签的阅读权限(v1.5.1节点去掉)
- $ajaxLogic->admin_logic_update_arctype(); // 纠正批量新增栏目的错误层级(v1.5.1节点去掉)
- return $this->fetch();
- }
- /**
- * 升级系统时,同时处理sql语句
- * @return [type] [description]
- */
- private function synExecuteSql()
- {
- // 新增订单提醒的邮箱模板
- if (!tpCache('system.system_smtp_tpl_5')){
- /*多语言*/
- if (is_language()) {
- $langRow = Db::name('language')->cache(true, EYOUCMS_CACHE_TIME, 'language')
- ->order('id asc')
- ->select();
- foreach ($langRow as $key => $val) {
- $r = Db::name('smtp_tpl')->insert([
- 'tpl_name' => '订单提醒',
- 'tpl_title' => '您有新的订单消息,请查收!',
- 'tpl_content' => '${content}',
- 'send_scene' => 5,
- 'is_open' => 1,
- 'lang' => $val['mark'],
- 'add_time' => getTime(),
- ]);
- false !== $r && tpCache('system', ['system_smtp_tpl_5' => 1], $val['mark']);
- }
- } else { // 单语言
- $r = Db::name('smtp_tpl')->insert([
- 'tpl_name' => '订单提醒',
- 'tpl_title' => '您有新的订单消息,请查收!',
- 'tpl_content' => '${content}',
- 'send_scene' => 5,
- 'is_open' => 1,
- 'lang' => $this->admin_lang,
- 'add_time' => getTime(),
- ]);
- false !== $r && tpCache('system', ['system_smtp_tpl_5' => 1]);
- }
- /*--end*/
- }
- }
- /**
- * 内容统计管理
- */
- public function ajax_content_total()
- {
- if (IS_AJAX_POST) {
- $checkedids = input('post.checkedids/a', []);
- $ids = input('post.ids/a', []);
- $saveData = [];
- foreach ($ids as $key => $val) {
- if (in_array($val, $checkedids)) {
- $checked = 1;
- } else {
- $checked = 0;
- }
- $saveData[$key] = [
- 'id' => $val,
- 'checked' => $checked,
- 'sort_order' => intval($key) + 1,
- 'update_time' => getTime(),
- ];
- }
- if (!empty($saveData)) {
- $r = model('Quickentry')->saveAll($saveData);
- if ($r) {
- $this->success('操作成功', url('Index/welcome'));
- }
- }
- $this->error('操作失败');
- }
- /*同步v1.3.9以及早期版本的自定义模型*/
- $this->syn_custom_quickmenu(2);
- /*end*/
- $totalList = Db::name('quickentry')->where([
- 'type' => ['IN', [2]],
- 'status' => 1,
- ])->order('sort_order asc, id asc')->select();
- $this->assign('totalList',$totalList);
- return $this->fetch();
- }
- /**
- * 内容统计 - 数量处理
- */
- private function contentTotalList()
- {
- $archivesTotalRow = null;
- $quickentryList = Db::name('quickentry')->where([
- 'type' => 2,
- 'checked' => 1,
- 'status' => 1,
- ])->order('sort_order asc, id asc')->select();
- foreach ($quickentryList as $key => $val) {
- $code = $val['controller'].'@'.$val['action'].'@'.$val['vars'];
- $quickentryList[$key]['vars'] = !empty($val['vars']) ? $val['vars']."&lang=".$this->admin_lang : "lang=".$this->admin_lang;
- if ($code == 'Guestbook@index@channel=8') // 留言列表
- {
- $map = [
- 'lang' => $this->admin_lang,
- ];
- $quickentryList[$key]['total'] = Db::name('guestbook')->where($map)->count();
- }
- else if (1 == $val['groups']) // 模型内容统计
- {
- if (null === $archivesTotalRow) {
- $map = [
- 'lang' => $this->admin_lang,
- 'status' => 1,
- 'is_del' => 0,
- ];
- /*权限控制 by 小虎哥*/
- $admin_info = session('admin_info');
- if (0 < intval($admin_info['role_id'])) {
- $auth_role_info = $admin_info['auth_role_info'];
- if(! empty($auth_role_info)){
- if(isset($auth_role_info['only_oneself']) && 1 == $auth_role_info['only_oneself']){
- $map['admin_id'] = $admin_info['admin_id'];
- }
- }
- }
- /*--end*/
- $archivesTotalRow = Db::name('archives')->field('channel, count(aid) as total')->where($map)->group('channel')
- ->getAllWithIndex('channel');
- }
- parse_str($val['vars'], $vars);
- $total = !empty($archivesTotalRow[$vars['channel']]['total']) ? intval($archivesTotalRow[$vars['channel']]['total']) : 0;
- $quickentryList[$key]['total'] = $total;
- }
- else if ($code == 'AdPosition@index@') // 广告
- {
- $map = [
- 'lang' => $this->admin_lang,
- 'is_del' => 0,
- ];
- $quickentryList[$key]['total'] = Db::name('ad_position')->where($map)->count();
- }
- else if ($code == 'Links@index@') // 友情链接
- {
- $map = [
- 'lang' => $this->admin_lang,
- ];
- $quickentryList[$key]['total'] = Db::name('links')->where($map)->count();
- }
- else if ($code == 'Tags@index@') // Tags标签
- {
- $map = [
- 'lang' => $this->admin_lang,
- ];
- $quickentryList[$key]['total'] = Db::name('tagindex')->where($map)->count();
- }
- else if ($code == 'Member@users_index@') // 会员
- {
- $map = [
- 'lang' => $this->admin_lang,
- 'is_del' => 0,
- ];
- $quickentryList[$key]['total'] = Db::name('users')->where($map)->count();
- }
- else if ($code == 'Shop@index@') // 订单
- {
- $map = [
- 'lang' => $this->admin_lang,
- ];
- $quickentryList[$key]['total'] = Db::name('shop_order')->where($map)->count();
- }
- }
- return $quickentryList;
- }
- /**
- * 快捷导航管理
- */
- public function ajax_quickmenu()
- {
- if (IS_AJAX_POST) {
- $checkedids = input('post.checkedids/a', []);
- $ids = input('post.ids/a', []);
- $saveData = [];
- foreach ($ids as $key => $val) {
- if (in_array($val, $checkedids)) {
- $checked = 1;
- } else {
- $checked = 0;
- }
- $saveData[$key] = [
- 'id' => $val,
- 'checked' => $checked,
- 'sort_order' => intval($key) + 1,
- 'update_time' => getTime(),
- ];
- }
- if (!empty($saveData)) {
- $r = model('Quickentry')->saveAll($saveData);
- if ($r) {
- $this->success('操作成功', url('Index/welcome'));
- }
- }
- $this->error('操作失败');
- }
- /*同步v1.3.9以及早期版本的自定义模型*/
- $this->syn_custom_quickmenu(1);
- /*end*/
- $menuList = Db::name('quickentry')->where([
- 'type' => ['IN', [1]],
- 'groups' => 0,
- 'status' => 1,
- ])->order('sort_order asc, id asc')->select();
- $this->assign('menuList',$menuList);
- return $this->fetch();
- }
- /**
- * 同步自定义模型的快捷导航
- */
- private function syn_custom_quickmenu($type = 1)
- {
- $row = Db::name('quickentry')->where([
- 'controller' => 'Custom',
- 'type' => $type,
- ])->count();
- if (empty($row)) {
- $customRow = Db::name('channeltype')->field('id,ntitle')
- ->where(['ifsystem'=>0])->select();
- $saveData = [];
- foreach ($customRow as $key => $val) {
- $saveData[] = [
- 'title' => $val['ntitle'],
- 'laytext' => $val['ntitle'].'列表',
- 'type' => $type,
- 'controller' => 'Custom',
- 'action' => 'index',
- 'vars' => 'channel='.$val['id'],
- 'groups' => 1,
- 'sort_order' => 100,
- 'add_time' => getTime(),
- 'update_time' => getTime(),
- ];
- }
- model('Quickentry')->saveAll($saveData);
- }
- }
- /**
- * 同步受开关控制的导航和内容统计
- */
- private function syn_open_quickmenu()
- {
- $tpcacheConfig = tpCache('global');
- $usersConfig = getUsersConfigData('all');
- /*商城中心 - 受本身开关和会员中心开关控制*/
- if (!empty($tpcacheConfig['web_users_switch']) && !empty($usersConfig['shop_open'])) {
- $shop_open = 1;
- } else {
- $shop_open = 0;
- }
- /*end*/
- $saveData = [
- [
- 'id' => 31,
- 'status' => !empty($tpcacheConfig['web_users_switch']) ? 1 : 0,
- 'update_time' => getTime(),
- ],
- [
- 'id' => 32,
- 'status' => (1 == $tpcacheConfig['web_weapp_switch']) ? 1 : 0,
- 'update_time' => getTime(),
- ],
- [
- 'id' => 33,
- 'status' => !empty($tpcacheConfig['web_users_switch']) ? 1 : 0,
- 'update_time' => getTime(),
- ],
- [
- 'id' => 34,
- 'status' => $shop_open,
- 'update_time' => getTime(),
- ],
- [
- 'id' => 35,
- 'status' => $shop_open,
- 'update_time' => getTime(),
- ],
- ];
- model('Quickentry')->saveAll($saveData);
- /*处理模型导航和统计*/
- $channeltypeRow = Db::name('channeltype')->cache(true,EYOUCMS_CACHE_TIME,"channeltype")->select();
- foreach ($channeltypeRow as $key => $val) {
- $updateData = [
- 'groups' => 1,
- 'vars' => 'channel='.$val['id'],
- 'status' => $val['status'],
- 'update_time' => getTime(),
- ];
- Db::name('quickentry')->where([
- 'vars' => 'channel='.$val['id']
- ])->update($updateData);
- }
- /*end*/
- }
- /**
- * 服务器信息
- */
- private function get_sys_info()
- {
- $sys_info['os'] = PHP_OS;
- $sys_info['zlib'] = function_exists('gzclose') ? 'YES' : '<font color="red">NO(请开启 php.ini 中的php-zlib扩展)</font>';//zlib
- $sys_info['safe_mode'] = (boolean) ini_get('safe_mode') ? 'YES' : 'NO';//safe_mode = Off
- $sys_info['timezone'] = function_exists("date_default_timezone_get") ? date_default_timezone_get() : "no_timezone";
- $sys_info['curl'] = function_exists('curl_init') ? 'YES' : '<font color="red">NO(请开启 php.ini 中的php-curl扩展)</font>';
- $sys_info['web_server'] = $_SERVER['SERVER_SOFTWARE'];
- $sys_info['phpv'] = phpversion();
- $sys_info['ip'] = serverIP();
- $sys_info['postsize'] = @ini_get('file_uploads') ? ini_get('post_max_size') :'未知';
- $sys_info['fileupload'] = @ini_get('file_uploads') ? ini_get('upload_max_filesize') :'未开启';
- $sys_info['max_ex_time'] = @ini_get("max_execution_time").'s'; //脚本最大执行时间
- $sys_info['set_time_limit'] = function_exists("set_time_limit") ? true : false;
- $sys_info['domain'] = $_SERVER['HTTP_HOST'];
- $sys_info['memory_limit'] = ini_get('memory_limit');
- $sys_info['version'] = file_get_contents(DATA_PATH.'conf/version.txt');
- $mysqlinfo = Db::query("SELECT VERSION() as version");
- $sys_info['mysql_version'] = $mysqlinfo[0]['version'];
- if(function_exists("gd_info")){
- $gd = gd_info();
- $sys_info['gdinfo'] = $gd['GD Version'];
- }else {
- $sys_info['gdinfo'] = "未知";
- }
- if (extension_loaded('zip')) {
- $sys_info['zip'] = "YES";
- } else {
- $sys_info['zip'] = '<font color="red">NO(请开启 php.ini 中的php-zip扩展)</font>';
- }
- $upgradeLogic = new \app\admin\logic\UpgradeLogic();
- $sys_info['curent_version'] = $upgradeLogic->curent_version; //当前程序版本
- $sys_info['web_name'] = tpCache('global.web_name');
- return $sys_info;
- }
- /**
- * 录入商业授权
- */
- public function authortoken()
- {
- $domain = config('service_ey');
- $domain = base64_decode($domain);
- $vaules = array(
- 'client_domain' => urldecode($this->request->host(true)),
- );
- $url = $domain.'/index.php?m=api&c=Service&a=check_authortoken&'.http_build_query($vaules);
- $context = stream_context_set_default(array('http' => array('timeout' => 3,'method'=>'GET')));
- $response = @file_get_contents($url,false,$context);
- $params = json_decode($response,true);
- if (false === $response || (is_array($params) && 1 == $params['code'])) {
- $web_authortoken = $params['msg'];
- /*多语言*/
- if (is_language()) {
- $langRow = Db::name('language')->cache(true, EYOUCMS_CACHE_TIME, 'language')
- ->order('id asc')
- ->select();
- foreach ($langRow as $key => $val) {
- tpCache('web', ['web_authortoken'=>$web_authortoken], $val['mark']);
- }
- } else { // 单语言
- tpCache('web', array('web_authortoken'=>$web_authortoken));
- }
- /*--end*/
- $source = realpath('public/static/admin/images/logo_ey.png');
- $destination = realpath('public/static/admin/images/logo.png');
- @copy($source, $destination);
- delFile(RUNTIME_PATH.'html'); // 清空缓存页面
- session('isset_author', null);
- adminLog('验证商业授权');
- $this->success('域名授权成功', request()->baseFile(), '', 1, [], '_parent');
- }
- $this->error('域名('.$this->request->domain().')未授权', request()->baseFile(), '', 3, [], '_parent');
- }
- /**
- * 更换后台logo
- */
- public function edit_adminlogo()
- {
- $filename = input('param.filename/s', '');
- if (!empty($filename)) {
- $source = realpath(preg_replace('#^'.ROOT_DIR.'/#i', '', $filename)); // 支持子目录
- $web_is_authortoken = tpCache('web.web_is_authortoken');
- if (empty($web_is_authortoken)) {
- $destination = realpath('public/static/admin/images/logo.png');
- } else {
- $destination = realpath('public/static/admin/images/logo_ey.png');
- }
- if (@copy($source, $destination)) {
- $this->success('操作成功');
- }
- }
- $this->error('操作失败');
- }
- /**
- * 待处理事项
- */
- public function pending_matters()
- {
- $html = '<div style="text-align: center; margin: 20px 0px; color:red;">惹妹子生气了,没啥好处理!</div>';
- echo $html;
- }
-
- /**
- * ajax 修改指定表数据字段 一般修改状态 比如 是否推荐 是否开启 等 图标切换的
- * table,id_name,id_value,field,value
- */
- public function changeTableVal()
- {
- if (IS_AJAX_POST) {
- $url = null;
- $data = [
- 'refresh' => 0,
- ];
- $param = input('param.');
- $table = input('param.table/s'); // 表名
- $id_name = input('param.id_name/s'); // 表主键id名
- $id_value = input('param.id_value/d'); // 表主键id值
- $field = input('param.field/s'); // 修改哪个字段
- $value = input('param.value/s', '', null); // 修改字段值
- $value = eyPreventShell($value) ? $value : strip_sql($value);
- /*插件专用*/
- if ('weapp' == $table) {
- if (1 == intval($value)) { // 启用
- action('Weapp/enable', ['id' => $id_value]);
- } else if (-1 == intval($value)) { // 禁用
- action('Weapp/disable', ['id' => $id_value]);
- }
- }
- /*end*/
- /*处理数据的安全性*/
- if (empty($id_value)) {
- $this->error('查询条件id不合法!');
- }
- foreach ($param as $key => $val) {
- if ('value' == $key) {
- continue;
- }
- if (!preg_match('/^([A-Za-z0-9_-]*)$/i', $val)) {
- $this->error('数据含有非法入侵字符!');
- }
- }
- /*end*/
- switch ($table) {
- // 会员等级表
- case 'users_level':
- {
- $return = model('UsersLevel')->isRequired($id_name,$id_value,$field,$value);
- if (is_array($return)) {
- $this->error($return['msg']);
- }
- }
- break;
-
- // 会员属性表
- case 'users_parameter':
- {
- $return = model('UsersParameter')->isRequired($id_name,$id_value,$field,$value);
- if (is_array($return)) {
- $this->error($return['msg']);
- }
- }
- break;
-
- // 会员中心菜单表
- case 'users_menu':
- {
- if ('is_userpage' == $field) {
- Db::name('users_menu')->where('id','gt',0)->update([
- 'is_userpage' => 0,
- 'update_time' => getTime(),
- ]);
- }
- $data['refresh'] = 1;
- }
- break;
-
- // 会员投稿功能
- case 'archives':
- {
- if ('arcrank' == $field) {
- if (0 == $value) {
- $value = -1;
- }else{
- $value = 0;
- }
- }
- }
- break;
- // 会员产品类型表
- case 'users_type_manage':
- {
- if (empty($value)) {
- $this->error('不可为空');
- }
- }
- break;
- // 留言属性表
- case 'guestbook_attribute':
- {
- $return = model('GuestbookAttribute')->isValidate($id_name,$id_value,$field,$value);
- if (is_array($return)) {
- $time = !empty($return['time']) ? $return['time'] : 3;
- $this->error($return['msg'], null, [], $time);
- }
- }
- break;
- // 小程序页面表
- case 'diyminipro_page':
- {
- $re = Db::name('diyminipro_page')->where([
- 'is_home' => 1,
- $id_name => ['EQ', $id_value],
- ])->count();
- if (!empty($re)) {
- $this->error('禁止取消默认项', null, [], 3);
- }
- }
- break;
- default:
- # code...
- break;
- }
- $savedata = [
- $field => $value,
- 'update_time' => getTime(),
- ];
- switch ($table) {
- case 'diyminipro_page':
- {
- if ('is_home' == $field) {
- if ($value == 1) {
- $savedata['page_type'] = 1;
- } else {
- $savedata['page_type'] = -1;
- }
- }
- break;
- }
- }
- $r = Db::name($table)->where([$id_name => $id_value])->cache(true,null,$table)->save($savedata); // 根据条件保存修改的数据
- if ($r !== false) {
- // 以下代码可以考虑去掉,与行为里的清除缓存重复 AppEndBehavior.php / clearHtmlCache
- switch ($table) {
- case 'auth_modular':
- extra_cache('admin_auth_modular_list_logic', null);
- extra_cache('admin_all_menu', null);
- break;
- case 'diyminipro_page':
- {
- if ('is_home' == $field) {
- $data['refresh'] = 1;
- Db::name('diyminipro_page')->where([
- $id_name => ['NEQ', $id_value],
- 'lang' => $this->admin_lang,
- ])->update([
- 'is_home' => 0,
- 'page_type' => -1,
- 'update_time' => getTime()
- ]);
- }
- break;
- }
-
- // 会员投稿功能
- case 'archives':
- {
- if ('arcrank' == $field) {
- Db::name('taglist')->where('aid', $id_value)->update([
- 'arcrank'=>$value,
- 'update_time' => getTime(),
- ]);
- }
- break;
- }
-
- default:
- // 清除logic逻辑定义的缓存
- extra_cache('admin_'.$table.'_list_logic', null);
- // 清除一下缓存
- // delFile(RUNTIME_PATH.'html'); // 先清除缓存, 否则不好预览
- \think\Cache::clear($table);
- break;
- }
- $this->success('更新成功', $url, $data);
- }
- $this->error('更新失败', null, []);
- }
- }
- /**
- * 功能开关
- */
- public function switch_map()
- {
- if (IS_POST) {
- $inc_type = input('post.inc_type/s');
- $name = input('post.name/s');
- $value = input('post.value/s');
- $data = [];
- switch ($inc_type) {
- case 'pay':
- case 'shop':
- {
- getUsersConfigData($inc_type, [$name => $value]);
- // 开启商城
- if (1 == $value) {
- /*多语言 - 同时开启会员中心*/
- if (is_language()) {
- $langRow = \think\Db::name('language')->order('id asc')
- ->cache(true, EYOUCMS_CACHE_TIME, 'language')
- ->select();
- foreach ($langRow as $key => $val) {
- tpCache('web', ['web_users_switch' => 1], $val['mark']);
- }
- } else { // 单语言
- tpCache('web', ['web_users_switch' => 1]);
- }
- /*--end*/
- // 同时显示发布文档时的价格文本框
- Db::name('channelfield')->where([
- 'name' => 'users_price',
- 'channel_id' => 2,
- ])->update([
- 'ifeditable' => 1,
- 'update_time' => getTime(),
- ]);
- }
- if (in_array($name, ['shop_open'])) {
- // $data['reload'] = 1;
- /*检测是否存在订单中心模板*/
- if ('v1.0.1' > getVersion('version_themeshop') && !empty($value)) {
- $is_syn = 1;
- } else {
- $is_syn = 0;
- }
- $data['is_syn'] = $is_syn;
- /*--end*/
- // 同步会员中心的左侧菜单
- if ('shop_open' == $name) {
- Db::name('users_menu')->where([
- 'mca' => 'user/Shop/shop_centre',
- 'lang' => $this->admin_lang,
- ])->update([
- 'status' => (1 == $value) ? 1 : 0,
- 'update_time' => getTime(),
- ]);
- }
- } else if ('pay_open' == $name) {
- // 同步会员中心的左侧菜单
- Db::name('users_menu')->where([
- 'mca' => 'user/Pay/pay_consumer_details',
- 'lang' => $this->admin_lang,
- ])->update([
- 'status' => (1 == $value) ? 1 : 0,
- 'update_time' => getTime(),
- ]);
- }
- break;
- }
- case 'users':
- {
- // 会员投稿
- $r = Db::name('users_menu')->where([
- 'mca' => 'user/UsersRelease/release_centre',
- 'lang' => $this->admin_lang,
- ])->update([
- 'status' => (1 == $value) ? 1 : 0,
- 'update_time' => getTime(),
- ]);
- if ($r) {
- getUsersConfigData($inc_type, [$name => $value]);
- if (1 == $value) {
- /*多语言 - 同时开启会员中心*/
- if (is_language()) {
- $langRow = \think\Db::name('language')->order('id asc')
- ->cache(true, EYOUCMS_CACHE_TIME, 'language')
- ->select();
- foreach ($langRow as $key => $val) {
- tpCache('web', ['web_users_switch' => 1], $val['mark']);
- }
- } else { // 单语言
- tpCache('web', ['web_users_switch' => 1]);
- }
- /*--end*/
- }
- }
- break;
- }
- case 'level':
- {
- // 会员升级
- $r = Db::name('users_menu')->where([
- 'mca' => 'user/Level/level_centre',
- 'lang' => $this->admin_lang,
- ])->update([
- 'status' => (1 == $value) ? 1 : 0,
- 'update_time' => getTime(),
- ]);
- if ($r) {
- getUsersConfigData($inc_type, [$name => $value]);
- if (1 == $value) {
- /*多语言 - 同时开启会员中心*/
- if (is_language()) {
- $langRow = \think\Db::name('language')->order('id asc')
- ->cache(true, EYOUCMS_CACHE_TIME, 'language')
- ->select();
- foreach ($langRow as $key => $val) {
- tpCache('web', ['web_users_switch' => 1], $val['mark']);
- }
- } else { // 单语言
- tpCache('web', ['web_users_switch' => 1]);
- }
- /*--end*/
- }
- }
- break;
- }
- case 'web':
- {
- /*多语言*/
- if (is_language()) {
- $langRow = \think\Db::name('language')->order('id asc')
- ->cache(true, EYOUCMS_CACHE_TIME, 'language')
- ->select();
- foreach ($langRow as $key => $val) {
- tpCache($inc_type, [$name => $value], $val['mark']);
- }
- } else { // 单语言
- tpCache($inc_type, [$name => $value]);
- }
- /*--end*/
- if (in_array($name, ['web_users_switch'])) {
- // $data['reload'] = 1;
- /*检测是否存在会员中心模板*/
- if ('v1.0.1' > getVersion('version_themeusers') && !empty($value)) {
- $is_syn = 1;
- } else {
- $is_syn = 0;
- }
- $data['is_syn'] = $is_syn;
- /*--end*/
- } else if ($name == 'web_language_switch') { // 多语言开关
- // 统计多语言数量
- model('Language')->setLangNum();
- // 重新生成sitemap.xml
- sitemap_all();
- }
- break;
- }
- }
- $this->success('操作成功', null, $data);
- }
- $globalConfig = tpCache('global');
- $this->assign('globalConfig', $globalConfig);
- $UsersConfigData = getUsersConfigData('all');
- $this->assign('userConfig',$UsersConfigData);
- $is_online = 0;
- if (is_realdomain()) {
- $is_online = 1;
- }
- $this->assign('is_online',$is_online);
- /*检测是否存在会员中心模板*/
- if ('v1.0.1' > getVersion('version_themeusers')) {
- $is_themeusers_exist = 1;
- } else {
- $is_themeusers_exist = 0;
- }
- $this->assign('is_themeusers_exist',$is_themeusers_exist);
- /*--end*/
- /*检测是否存在商城中心模板*/
- if ('v1.0.1' > getVersion('version_themeshop')) {
- $is_themeshop_exist = 1;
- } else {
- $is_themeshop_exist = 0;
- }
- $this->assign('is_themeshop_exist',$is_themeshop_exist);
- /*--end*/
- return $this->fetch();
- }
- }
|