|
Server : Apache System : Linux iZ6xhqomji47p1Z 5.10.134-15.al8.x86_64 #1 SMP Thu Jul 20 00:44:04 CST 2023 x86_64 User : www ( 1000) PHP Version : 8.1.30 Disable Function : passthru,exec,system,putenv,chroot,chgrp,chown,shell_exec,popen,proc_open,pcntl_exec,ini_alter,ini_restore,dl,openlog,syslog,readlink,symlink,popepassthru,pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,imap_open,apache_setenv Directory : /www/wwwroot/fsjlkj.cn/application/admin/controller/ |
<?php
/**
* 易优CMS
* ============================================================================
* 版权所有 2016-2028 海南赞赞网络科技有限公司,并保留所有权利。
* 网站地址: http://www.eyoucms.com
* ----------------------------------------------------------------------------
* 如果商业用途务必到官方购买正版授权, 以免引起不必要的法律纠纷.
* ============================================================================
* Author: 小虎哥 <1105415366@qq.com>
* Date: 2018-4-3
*/
namespace app\admin\controller;
use think\Page;
use think\Db;
use think\Config;
class Special extends Base
{
public $nid = 'special';
public $channeltype = '';
public function _initialize()
{
parent::_initialize();
$channeltype_list = config('global.channeltype_list');
$this->channeltype = $channeltype_list[$this->nid];
empty($this->channeltype) && $this->channeltype = 7;
$this->assign('nid', $this->nid);
$this->assign('channeltype', $this->channeltype);
}
//专题列表
public function index()
{
$assign_data = $condition = [];
// 获取到所有GET参数
$param = input('param.');
$typeid = input('typeid/d', 0);
// 搜索、筛选查询条件处理
foreach (['keywords', 'typeid', 'flag', 'is_release','province_id','city_id','area_id'] as $key) {
if ($key == 'typeid' && empty($param['typeid'])) {
$typeids = Db::name('arctype')->where('current_channel', $this->channeltype)->column('id');
$condition['a.typeid'] = array('IN', $typeids);
}
if (isset($param[$key]) && $param[$key] !== '') {
if ($key == 'keywords') {
$keywords = $param[$key];
$condition['a.title'] = array('LIKE', "%{$param[$key]}%");
} else if ($key == 'typeid') {
$typeid = $param[$key];
$hasRow = model('Arctype')->getHasChildren($typeid);
$typeids = get_arr_column($hasRow, 'id');
// 权限控制 by 小虎哥
$admin_info = session('admin_info');
if (0 < intval($admin_info['role_id'])) {
$auth_role_info = $admin_info['auth_role_info'];
if (!empty($typeid) && !empty($auth_role_info) && !empty($auth_role_info['permission']['arctype'])) {
$typeids = array_intersect($typeids, $auth_role_info['permission']['arctype']);
}
}
$condition['a.typeid'] = array('IN', $typeids);
} else if ($key == 'flag') {
if ('is_release' == $param[$key]) {
$condition['a.users_id'] = array('gt', 0);
} else {
$FlagNew = $param[$key];
$condition['a.'.$param[$key]] = array('eq', 1);
}
} else if (in_array($key, ['province_id','city_id','area_id'])) {
if (!empty($param['area_id'])) {
$condition['a.area_id'] = $param['area_id'];
} else if (!empty($param['city_id'])) {
$condition['a.city_id'] = $param['city_id'];
} else if (!empty($param['province_id'])) {
$condition['a.province_id'] = $param['province_id'];
}
} else {
$condition['a.'.$key] = array('eq', $param[$key]);
}
}
}
// 权限控制 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) && isset($auth_role_info['only_oneself']) && 1 == $auth_role_info['only_oneself']) {
$condition['a.admin_id'] = $admin_info['admin_id'];
}
}
// 时间检索条件
$begin = strtotime(input('add_time_begin'));
$end = strtotime(input('add_time_end'));
if ($begin > 0 && $end > 0) {
$condition['a.add_time'] = array('between', "$begin, $end");
} else if ($begin > 0) {
$condition['a.add_time'] = array('egt', $begin);
} else if ($end > 0) {
$condition['a.add_time'] = array('elt', $end);
}
// 必要条件
$condition['a.channel'] = array('eq', $this->channeltype);
$condition['a.lang'] = array('eq', $this->admin_lang);
$condition['a.is_del'] = array('eq', 0);
$conditionNew = "(a.users_id = 0 OR (a.users_id > 0 AND a.arcrank >= 0))";
// 自定义排序
$orderby = input('param.orderby/s');
$orderway = input('param.orderway/s');
if (!empty($orderby) && !empty($orderway)) {
$orderby = "a.{$orderby} {$orderway}, a.aid desc";
} else {
$orderby = "a.aid desc";
}
// 数据查询,搜索出主键ID的值
$SqlQuery = Db::name('archives')->alias('a')->where($condition)->where($conditionNew)->fetchSql()->count('aid');
$count = Db::name('sql_cache_table')->where(['sql_md5'=>md5($SqlQuery)])->getField('sql_result');
$count = ($count < 0) ? 0 : $count;
if (empty($count)) {
$count = Db::name('archives')->alias('a')->where($condition)->where($conditionNew)->count('aid');
/*添加查询执行语句到mysql缓存表*/
$SqlCacheTable = [
'sql_name' => '|special|' . $this->channeltype . '|',
'sql_result' => $count,
'sql_md5' => md5($SqlQuery),
'sql_query' => $SqlQuery,
'add_time' => getTime(),
'update_time' => getTime(),
];
if (!empty($FlagNew)) $SqlCacheTable['sql_name'] = $SqlCacheTable['sql_name'] . $FlagNew . '|';
if (!empty($typeid)) $SqlCacheTable['sql_name'] = $SqlCacheTable['sql_name'] . $typeid . '|';
if (!empty($keywords)) $SqlCacheTable['sql_name'] = '|special|keywords|';
Db::name('sql_cache_table')->insertGetId($SqlCacheTable);
/*END*/
}
$Page = new Page($count, config('paginate.list_rows'));
$list = [];
if (!empty($count)) {
$limit = $count > config('paginate.list_rows') ? $Page->firstRow.','.$Page->listRows : $count;
$list = Db::name('archives')
->field("a.aid")
->alias('a')
->where($condition)
->where($conditionNew)
->order($orderby)
->limit($limit)
->getAllWithIndex('aid');
if (!empty($list)) {
$aids = array_keys($list);
$fields = "b.*, a.*, a.aid as aid";
$row = Db::name('archives')
->field($fields)
->alias('a')
->join('__ARCTYPE__ b', 'a.typeid = b.id', 'LEFT')
->where('a.aid', 'in', $aids)
->getAllWithIndex('aid');
foreach ($list as $key => $val) {
$row[$val['aid']]['arcurl'] = get_arcurl($row[$val['aid']]);
$row[$val['aid']]['litpic'] = handle_subdir_pic($row[$val['aid']]['litpic']);
$list[$key] = $row[$val['aid']];
}
}
}
$show = $Page->show();
$assign_data['page'] = $show;
$assign_data['list'] = $list;
$assign_data['pager'] = $Page;
$assign_data['typeid'] = $typeid;
$assign_data['tab'] = input('param.tab/d', 3);// 选项卡
$assign_data['seo_pseudo'] = tpCache('global.seo_pseudo');// 前台URL模式
$assign_data['archives_flags'] = model('ArchivesFlag')->getList();// 文档属性
$assign_data['arctype_info'] = $typeid > 0 ? Db::name('arctype')->field('typename')->find($typeid) : [];// 当前栏目信息
$this->assign($assign_data);
$recycle_switch = tpSetting('recycle.recycle_switch');//回收站开关
$this->assign('recycle_switch', $recycle_switch);
return $this->fetch();
}
/**
* 添加
*/
public function add()
{
$admin_info = session('admin_info');
$auth_role_info = $admin_info['auth_role_info'];
$this->assign('auth_role_info', $auth_role_info);
$this->assign('admin_info', $admin_info);
if (IS_POST) {
$post = input('post.');
/* 处理TAG标签 */
if (!empty($post['tags_new'])) {
$post['tags'] = !empty($post['tags']) ? $post['tags'] . ',' . $post['tags_new'] : $post['tags_new'];
unset($post['tags_new']);
}
$post['tags'] = explode(',', $post['tags']);
$post['tags'] = array_unique($post['tags']);
$post['tags'] = implode(',', $post['tags']);
/* END */
$content = input('post.addonFieldExt.content', '', null);
// 根据标题自动提取相关的关键字
$seo_keywords = $post['seo_keywords'];
if (!empty($seo_keywords)) {
$seo_keywords = str_replace(',', ',', $seo_keywords);
} else {
// $seo_keywords = get_split_word($post['title'], $content);
}
// 自动获取内容第一张图片作为封面图
$is_remote = !empty($post['is_remote']) ? $post['is_remote'] : 0;
$litpic = '';
if ($is_remote == 1) {
$litpic = $post['litpic_remote'];
} else {
$litpic = $post['litpic_local'];
}
if (empty($litpic)) {
$litpic = get_html_first_imgurl($content);
}
$post['litpic'] = $litpic;
/*是否有封面图*/
if (empty($post['litpic'])) {
$is_litpic = 0; // 无封面图
} else {
$is_litpic = 1; // 有封面图
}
// SEO描述
$seo_description = '';
if (empty($post['seo_description']) && !empty($content)) {
$seo_description = @msubstr(checkStrHtml($content), 0, config('global.arc_seo_description_length'), false);
} else {
$seo_description = $post['seo_description'];
}
// 外部链接跳转
$jumplinks = '';
$is_jump = isset($post['is_jump']) ? $post['is_jump'] : 0;
if (intval($is_jump) > 0) {
$jumplinks = $post['jumplinks'];
}
// 模板文件,如果文档模板名与栏目指定的一致,默认就为空。让它跟随栏目的指定而变
if ($post['type_tempview'] == $post['tempview']) {
unset($post['type_tempview']);
unset($post['tempview']);
}
//处理自定义文件名,仅由字母数字下划线和短横杆组成,大写强制转换为小写
$htmlfilename = trim($post['htmlfilename']);
if (!empty($htmlfilename)) {
$htmlfilename = preg_replace("/[^\x{4e00}-\x{9fa5}\w\-]+/u", "-", $htmlfilename);
// $htmlfilename = strtolower($htmlfilename);
//判断是否存在相同的自定义文件名
$filenameCount = Db::name('archives')->where([
'htmlfilename' => $htmlfilename,
'lang' => $this->admin_lang,
])->count();
if (!empty($filenameCount)) {
$this->error("自定义文件名已存在,请重新设置!");
} else if (preg_match('/^(\d+)$/i', $htmlfilename)) {
$this->error("自定义文件名不能纯数字,会与文档ID冲突!");
}
} else {
// 处理外贸链接
if (is_dir('./weapp/Waimao/')) {
$waimaoLogic = new \weapp\Waimao\logic\WaimaoLogic;
$waimaoLogic->get_new_htmlfilename($htmlfilename, $post, 'add', $this->globalConfig);
}
}
$post['htmlfilename'] = $htmlfilename;
//做自动通过审核判断
if ($admin_info['role_id'] > 0 && $auth_role_info['check_oneself'] < 1) {
$post['arcrank'] = -1;
}
// 副栏目
if (isset($post['stypeid'])) {
$post['stypeid'] = preg_replace('/([^\d\,\,]+)/i', ',', $post['stypeid']);
$post['stypeid'] = str_replace(',', ',', $post['stypeid']);
$post['stypeid'] = trim($post['stypeid'], ',');
$post['stypeid'] = str_replace(",{$post['typeid']},", ',', ",{$post['stypeid']},");
$post['stypeid'] = trim($post['stypeid'], ',');
}
// --存储数据
$newData = array(
'title'=> trim($post['title']),
'typeid'=> empty($post['typeid']) ? 0 : $post['typeid'],
'channel' => $this->channeltype,
'is_b' => empty($post['is_b']) ? 0 : $post['is_b'],
'is_head' => empty($post['is_head']) ? 0 : $post['is_head'],
'is_special' => empty($post['is_special']) ? 0 : $post['is_special'],
'is_recom' => empty($post['is_recom']) ? 0 : $post['is_recom'],
'is_roll' => empty($post['is_roll']) ? 0 : $post['is_roll'],
'is_slide' => empty($post['is_slide']) ? 0 : $post['is_slide'],
'is_diyattr' => empty($post['is_diyattr']) ? 0 : $post['is_diyattr'],
'is_jump' => $is_jump,
'is_litpic' => $is_litpic,
'jumplinks' => $jumplinks,
'origin' => empty($post['origin']) ? '网络' : $post['origin'],
'seo_keywords' => $seo_keywords,
'seo_description' => $seo_description,
'admin_id' => session('admin_info.admin_id'),
'lang' => $this->admin_lang,
'sort_order' => 100,
'add_time' => strtotime($post['add_time']),
'update_time' => strtotime($post['add_time']),
);
$data = array_merge($post, $newData);
$aid = Db::name('archives')->insertGetId($data);
$_POST['aid'] = $aid;
if ($aid) {
// ---------后置操作
model('Special')->afterSave($aid, $data, 'add');
// 添加查询执行语句到mysql缓存表
model('SqlCacheTable')->InsertSqlCacheTable();
// ---------end
adminLog('新增专题:'.$data['title']);
// 生成静态页面代码
$successData = [
'aid' => $aid,
'tid' => $post['typeid'],
];
$this->success("操作成功!", null, $successData);
exit;
}
$this->error("操作失败!");
exit;
}
$typeid = input('param.typeid/d', 0);
$assign_data['typeid'] = $typeid; // 栏目ID
// 栏目信息
$arctypeInfo = Db::name('arctype')->find($typeid);
/*允许发布文档列表的栏目*/
$arctype_html = allow_release_arctype($typeid, array($this->channeltype));
$assign_data['arctype_html'] = $arctype_html;
/*--end*/
// 阅读权限
$arcrank_list = get_arcrank_list();
$assign_data['arcrank_list'] = $arcrank_list;
/*模板列表*/
$archivesLogic = new \app\admin\logic\ArchivesLogic;
$templateList = $archivesLogic->getTemplateList($this->nid);
$this->assign('templateList', $templateList);
/*--end*/
/*默认模板文件*/
$tempview = 'view_'.$this->nid.'.'.config('template.view_suffix');
!empty($arctypeInfo['tempview']) && $tempview = $arctypeInfo['tempview'];
$this->assign('tempview', $tempview);
/*--end*/
// URL模式
$tpcache = config('tpcache');
$assign_data['seo_pseudo'] = !empty($tpcache['seo_pseudo']) ? $tpcache['seo_pseudo'] : 1;
/*--end*/
/*节点允许发布文档列表的栏目*/
$allow_release_channel = config('global.allow_release_channel');
$key_tmp = array_search('7', $allow_release_channel);
if (is_numeric($key_tmp) && 0 <= $key_tmp) {
unset($allow_release_channel[$key_tmp]);
}
$node_select_html = allow_release_arctype(0, $allow_release_channel);
$assign_data['node_select_html'] = $node_select_html;
/*--end*/
/* 节点模型列表 */
$allow_release_channel = config('global.allow_release_channel');
$node_channeltype_list = \think\Cache::get('extra_global_channeltype');
foreach ($node_channeltype_list as $key => $val) {
if (!in_array($val['id'], $allow_release_channel)) {
unset($node_channeltype_list[$val['id']]);
}
}
unset($node_channeltype_list[7]);
$assign_data['node_channeltype_list'] = $node_channeltype_list;
/*--end*/
// 文档默认浏览量
$globalConfig = tpCache('global');
if (isset($globalConfig['other_arcclick']) && 0 <= $globalConfig['other_arcclick']) {
$arcclick_arr = explode("|", $globalConfig['other_arcclick']);
if (count($arcclick_arr) > 1) {
$assign_data['rand_arcclick'] = mt_rand($arcclick_arr[0], $arcclick_arr[1]);
} else {
$assign_data['rand_arcclick'] = intval($arcclick_arr[0]);
}
}else{
$arcclick_config['other_arcclick'] = '500|1000';
tpCache('other', $arcclick_config);
$assign_data['rand_arcclick'] = mt_rand(500, 1000);
}
/*文档属性*/
$assign_data['archives_flags'] = model('ArchivesFlag')->getList();
$channelRow = Db::name('channeltype')->where('id', $this->channeltype)->find();
$assign_data['channelRow'] = $channelRow;
// 来源列表
$system_originlist = tpSetting('system.system_originlist');
$system_originlist = json_decode($system_originlist, true);
$system_originlist = !empty($system_originlist) ? $system_originlist : [];
$assign_data['system_originlist_str'] = implode(PHP_EOL, $system_originlist);
$assign_data['system_originlist_0'] = !empty($system_originlist) ? $system_originlist[0] : "";
// 多站点,当用站点域名访问后台,发布文档自动选择当前所属区域
model('Citysite')->auto_location_select($assign_data);
$this->assign($assign_data);
return $this->fetch();
}
/**
* 编辑
*/
public function edit()
{
$admin_info = session('admin_info');
$auth_role_info = $admin_info['auth_role_info'];
$this->assign('auth_role_info', $auth_role_info);
$this->assign('admin_info', $admin_info);
if (IS_POST) {
$post = input('post.');
$post['aid'] = intval($post['aid']);
/* 处理TAG标签 */
if (!empty($post['tags_new'])) {
$post['tags'] = !empty($post['tags']) ? $post['tags'] . ',' . $post['tags_new'] : $post['tags_new'];
unset($post['tags_new']);
}
$post['tags'] = explode(',', $post['tags']);
$post['tags'] = array_unique($post['tags']);
$post['tags'] = implode(',', $post['tags']);
/* END */
$typeid = input('post.typeid/d', 0);
$content = input('post.addonFieldExt.content', '', null);
// 根据标题自动提取相关的关键字
$seo_keywords = $post['seo_keywords'];
if (!empty($seo_keywords)) {
$seo_keywords = str_replace(',', ',', $seo_keywords);
} else {
// $seo_keywords = get_split_word($post['title'], $content);
}
// 自动获取内容第一张图片作为封面图
$is_remote = !empty($post['is_remote']) ? $post['is_remote'] : 0;
$litpic = '';
if ($is_remote == 1) {
$litpic = $post['litpic_remote'];
} else {
$litpic = $post['litpic_local'];
}
if (empty($litpic)) {
$litpic = get_html_first_imgurl($content);
}
$post['litpic'] = $litpic;
/*是否有封面图*/
if (empty($post['litpic'])) {
$is_litpic = 0; // 无封面图
} else {
$is_litpic = !empty($post['is_litpic']) ? $post['is_litpic'] : 0; // 有封面图
}
// 勾选后SEO描述将随正文内容更新
$basic_update_seo_description = empty($post['basic_update_seo_description']) ? 0 : 1;
if (is_language()) {
$langRow = \think\Db::name('language')->order('id asc')
->cache(true, EYOUCMS_CACHE_TIME, 'language')
->select();
foreach ($langRow as $key => $val) {
tpCache('basic', ['basic_update_seo_description'=>$basic_update_seo_description], $val['mark']);
}
} else {
tpCache('basic', ['basic_update_seo_description'=>$basic_update_seo_description]);
}
/*--end*/
// SEO描述
$seo_description = '';
if (!empty($basic_update_seo_description) || empty($post['seo_description'])) {
$seo_description = @msubstr(checkStrHtml($content), 0, config('global.arc_seo_description_length'), false);
} else {
$seo_description = $post['seo_description'];
}
// --外部链接
$jumplinks = '';
$is_jump = isset($post['is_jump']) ? $post['is_jump'] : 0;
if (intval($is_jump) > 0) {
$jumplinks = $post['jumplinks'];
}
// 模板文件,如果文档模板名与栏目指定的一致,默认就为空。让它跟随栏目的指定而变
if ($post['type_tempview'] == $post['tempview']) {
unset($post['type_tempview']);
unset($post['tempview']);
}
// 同步栏目切换模型之后的文档模型
$channel = Db::name('arctype')->where(['id'=>$typeid])->getField('current_channel');
//处理自定义文件名,仅由字母数字下划线和短横杆组成,大写强制转换为小写
$htmlfilename = trim($post['htmlfilename']);
if (!empty($htmlfilename)) {
$htmlfilename = preg_replace("/[^\x{4e00}-\x{9fa5}\w\-]+/u", "-", $htmlfilename);
// $htmlfilename = strtolower($htmlfilename);
//判断是否存在相同的自定义文件名
$filenameCount = Db::name('archives')->where([
'aid' => ['NEQ', $post['aid']],
'htmlfilename' => $htmlfilename,
'lang' => $this->admin_lang,
])->count();
if (!empty($filenameCount)) {
$this->error("自定义文件名已存在,请重新设置!");
} else if (preg_match('/^(\d+)$/i', $htmlfilename)) {
$this->error("自定义文件名不能纯数字,会与文档ID冲突!");
}
} else {
// 处理外贸链接
if (is_dir('./weapp/Waimao/')) {
$waimaoLogic = new \weapp\Waimao\logic\WaimaoLogic;
$waimaoLogic->get_new_htmlfilename($htmlfilename, $post, 'edit', $this->globalConfig);
}
}
$post['htmlfilename'] = $htmlfilename;
//做未通过审核文档不允许修改文档状态操作
if ($admin_info['role_id'] > 0 && $auth_role_info['check_oneself'] < 1) {
$old_archives_arcrank = Db::name('archives')->where(['aid' => $post['aid']])->getField("arcrank");
if ($old_archives_arcrank < 0) {
unset($post['arcrank']);
}
}
// 副栏目
if (isset($post['stypeid'])) {
$post['stypeid'] = preg_replace('/([^\d\,\,]+)/i', ',', $post['stypeid']);
$post['stypeid'] = str_replace(',', ',', $post['stypeid']);
$post['stypeid'] = trim($post['stypeid'], ',');
$post['stypeid'] = str_replace(",{$typeid},", ',', ",{$post['stypeid']},");
$post['stypeid'] = trim($post['stypeid'], ',');
}
// --存储数据
$newData = array(
'title'=> trim($post['title']),
'typeid'=> $typeid,
'channel' => $channel,
'is_b' => empty($post['is_b']) ? 0 : $post['is_b'],
'is_head' => empty($post['is_head']) ? 0 : $post['is_head'],
'is_special' => empty($post['is_special']) ? 0 : $post['is_special'],
'is_recom' => empty($post['is_recom']) ? 0 : $post['is_recom'],
'is_roll' => empty($post['is_roll']) ? 0 : $post['is_roll'],
'is_slide' => empty($post['is_slide']) ? 0 : $post['is_slide'],
'is_diyattr' => empty($post['is_diyattr']) ? 0 : $post['is_diyattr'],
'is_jump' => $is_jump,
'is_litpic' => $is_litpic,
'jumplinks' => $jumplinks,
'seo_keywords' => $seo_keywords,
'seo_description' => $seo_description,
'add_time' => strtotime($post['add_time']),
'update_time' => getTime(),
);
$data = array_merge($post, $newData);
$r = Db::name('archives')->where([
'aid' => $data['aid'],
'lang' => $this->admin_lang,
])->update($data);
if ($r) {
// ---------后置操作
model('Special')->afterSave($data['aid'], $data, 'edit');
// ---------end
adminLog('编辑专题:'.$data['title']);
// 生成静态页面代码
$successData = [
'aid' => $data['aid'],
'tid' => $typeid,
];
$this->success("操作成功!", null, $successData);
exit;
}
$this->error("操作失败!");
exit;
}
$assign_data = array();
$id = input('id/d');
$info = model('Special')->getInfo($id, null, false);
if (empty($info)) {
$this->error('数据不存在,请联系管理员!');
exit;
}
/*兼容采集没有归属栏目的文档*/
if (empty($info['channel'])) {
$channelRow = Db::name('channeltype')->field('id as channel')
->where('id',$this->channeltype)
->find();
$info = array_merge($info, $channelRow);
}
/*--end*/
$typeid = $info['typeid'];
$assign_data['typeid'] = $typeid;
// 副栏目
$stypeid_arr = [];
if (!empty($info['stypeid'])) {
$info['stypeid'] = trim($info['stypeid'], ',');
$stypeid_arr = Db::name('arctype')->field('id,typename')->where(['id'=>['IN', $info['stypeid']],'is_del'=>0])->select();
}
$assign_data['stypeid_arr'] = $stypeid_arr;
// 栏目信息
$arctypeInfo = Db::name('arctype')->find($typeid);
$info['channel'] = $arctypeInfo['current_channel'];
if (is_http_url($info['litpic'])) {
$info['is_remote'] = 1;
$info['litpic_remote'] = handle_subdir_pic($info['litpic']);
} else {
$info['is_remote'] = 0;
$info['litpic_local'] = handle_subdir_pic($info['litpic']);
}
// SEO描述
// if (!empty($info['seo_description'])) {
// $info['seo_description'] = @msubstr(checkStrHtml($info['seo_description']), 0, config('global.arc_seo_description_length'), false);
// }
$assign_data['field'] = $info;
/*允许发布文档列表的栏目,文档所在模型以栏目所在模型为主,兼容切换模型之后的数据编辑*/
$arctype_html = allow_release_arctype($typeid, array($info['channel']));
$assign_data['arctype_html'] = $arctype_html;
/*--end*/
// 阅读权限
$arcrank_list = get_arcrank_list();
$assign_data['arcrank_list'] = $arcrank_list;
/*模板列表*/
$archivesLogic = new \app\admin\logic\ArchivesLogic;
$templateList = $archivesLogic->getTemplateList($this->nid);
$this->assign('templateList', $templateList);
/*--end*/
/*默认模板文件*/
$tempview = $info['tempview'];
empty($tempview) && $tempview = $arctypeInfo['tempview'];
$this->assign('tempview', $tempview);
/*--end*/
// URL模式
$tpcache = config('tpcache');
$assign_data['seo_pseudo'] = !empty($tpcache['seo_pseudo']) ? $tpcache['seo_pseudo'] : 1;
/*--end*/
/*节点允许发布文档列表的栏目*/
$allow_release_channel = config('global.allow_release_channel');
$key_tmp = array_search('7', $allow_release_channel);
if (is_numeric($key_tmp) && 0 <= $key_tmp) {
unset($allow_release_channel[$key_tmp]);
}
$node_select_html = allow_release_arctype(0, $allow_release_channel);
$assign_data['node_select_html'] = $node_select_html;
/*--end*/
/* 节点模型列表 */
$allow_release_channel = config('global.allow_release_channel');
$node_channeltype_list = \think\Cache::get('extra_global_channeltype');
foreach ($node_channeltype_list as $key => $val) {
if (!in_array($val['id'], $allow_release_channel)) {
unset($node_channeltype_list[$val['id']]);
}
}
unset($node_channeltype_list[7]);
$assign_data['node_channeltype_list'] = $node_channeltype_list;
/*--end*/
/*节点数据*/
$specialNodeList = model('SpecialNode')->getList($id);
$assign_data['specialNodeList'] = $specialNodeList;
/*--end*/
/*文档属性*/
$assign_data['archives_flags'] = model('ArchivesFlag')->getList();
$channelRow = Db::name('channeltype')->where('id', $this->channeltype)->find();
$assign_data['channelRow'] = $channelRow;
// 来源列表
$system_originlist = tpSetting('system.system_originlist');
$system_originlist = json_decode($system_originlist, true);
$system_originlist = !empty($system_originlist) ? $system_originlist : [];
$assign_data['system_originlist_str'] = implode(PHP_EOL, $system_originlist);
$this->assign($assign_data);
return $this->fetch();
}
/**
* 删除
*/
public function del()
{
if (IS_POST) {
$archivesLogic = new \app\admin\logic\ArchivesLogic;
$archivesLogic->del([], 0, 'special');
}
}
/**
* 选择节点文档
* @return [type] [description]
*/
public function ajax_node_archives_list()
{
$assign_data = array();
$condition = array();
// 获取到所有URL参数
$param = input('param.');
$typeid = input('param.typeid/d');
$channels = input('param.channel/s');
// 应用搜索条件
foreach (['keywords','typeid','channel'] as $key) {
if ($key == 'keywords' && !empty($param[$key])) {
$param[$key] = trim($param[$key]);
$condition['a.title'] = array('LIKE', "%{$param[$key]}%");
} else if ($key == 'typeid' && !empty($param[$key])) {
$typeid = $param[$key];
$hasRow = model('Arctype')->getHasChildren($typeid);
$typeids = get_arr_column($hasRow, 'id');
/*权限控制 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']){
$condition['a.admin_id'] = $admin_info['admin_id'];
}
if(! empty($auth_role_info['permission']['arctype'])){
if (!empty($typeid)) {
$typeids = array_intersect($typeids, $auth_role_info['permission']['arctype']);
}
}
}
}
/*--end*/
$condition['a.typeid'] = array('IN', $typeids);
} else if ($key == 'channel') {
if (empty($param[$key])) {
$allow_release_channel = config('global.allow_release_channel');
$key_tmp = array_search('7', $allow_release_channel);
if (is_numeric($key_tmp) && 0 <= $key_tmp) {
unset($allow_release_channel[$key_tmp]);
}
$param[$key] = implode(',', $allow_release_channel);
}
$condition['a.'.$key] = array('in', explode(',', $param[$key]));
} else if (!empty($param[$key])) {
$condition['a.'.$key] = array('eq', $param[$key]);
}
}
// 排除已选中的文档
$aids = input('param.aids/s');
$aidArr = explode(',', trim($aids, ','));
if (!empty($aidArr)) {
$condition['a.aid'] = ['NOT IN', $aids];
}
// 审核通过
$condition['a.arcrank'] = array('gt', -1);
/*多语言*/
$condition['a.lang'] = array('eq', $this->admin_lang);
/*回收站数据不显示*/
$condition['a.is_del'] = array('eq', 0);
/**
* 数据查询,搜索出主键ID的值
*/
$count = Db::name('archives')->alias('a')->where($condition)->count('aid');// 查询满足要求的总记录数
$Page = new Page($count, config('paginate.list_rows'));// 实例化分页类 传入总记录数和每页显示的记录数
$list = Db::name('archives')
->field("a.aid")
->alias('a')
->where($condition)
->order('a.sort_order asc, a.aid desc')
->limit($Page->firstRow.','.$Page->listRows)
->getAllWithIndex('aid');
/**
* 完善数据集信息
* 在数据量大的情况下,经过优化的搜索逻辑,先搜索出主键ID,再通过ID将其他信息补充完整;
*/
if ($list) {
$aids = array_keys($list);
$fields = "b.*, a.*, a.aid as aid";
$row = Db::name('archives')
->field($fields)
->alias('a')
->join('__ARCTYPE__ b', 'a.typeid = b.id', 'LEFT')
->where('a.aid', 'in', $aids)
->getAllWithIndex('aid');
foreach ($list as $key => $val) {
$list[$key] = $row[$val['aid']];
}
}
$show = $Page->show(); // 分页显示输出
$assign_data['page'] = $show; // 赋值分页输出
$assign_data['list'] = $list; // 赋值数据集
$assign_data['pager'] = $Page; // 赋值分页对象
/*允许发布文档列表的栏目*/
$allow_release_channel = !empty($channels) ? explode(',', $channels) : config('global.allow_release_channel');
$key_tmp = array_search('7', $allow_release_channel);
if (is_numeric($key_tmp) && 0 <= $key_tmp) {
unset($allow_release_channel[$key_tmp]);
}
$assign_data['arctype_html'] = allow_release_arctype($typeid, $allow_release_channel);
/*--end*/
$this->assign($assign_data);
return $this->fetch();
}
//帮助
public function help()
{
$system_originlist = tpSetting('system.system_originlist');
$system_originlist = json_decode($system_originlist, true);
$system_originlist = !empty($system_originlist) ? $system_originlist : [];
$assign_data['system_originlist_str'] = implode(PHP_EOL, $system_originlist);
$this->assign($assign_data);
return $this->fetch();
}
}