![".L(](".IMG_PATH."add_content.gif)
' : '';
$workflow_menu .= ''.L('workflow_'.$i).$newimg.'|';
}
if($workflow_menu) {
$current = isset($_GET['reject']) ? 'class=on' : '';
$workflow_menu .= ''.L('reject').'|';
}
//$ = 153fc6d28dda8ca94eaa3686c8eed857;获取模型的thumb字段配置信息
$model_fields = getcache('model_field_'.$modelid, 'model');
$setting = string2array($model_fields['thumb']['setting']);
$args = '1,'.$setting['upload_allowext'].','.$setting['isselectimage'].','.$setting['images_width'].','.$setting['images_height'].','.$setting['watermark'];
$authkey = upload_key($args);
$template = $MODEL['admin_list_template'] ? $MODEL['admin_list_template'] : 'content_list';
include $this->admin_tpl($template);
} else {
include $this->admin_tpl('content_quick');
}
}
public function add() {
if(isset($_POST['dosubmit']) || isset($_POST['dosubmit_continue'])) {
define('INDEX_HTML',true);
$catid = $_POST['info']['catid'] = intval($_POST['info']['catid']);
if(trim($_POST['info']['title'])=='') showmessage(L('title_is_empty'));
$category = $this->categorys[$catid];
if($category['type']==0) {
$modelid = $this->categorys[$catid]['modelid'];
$this->db->set_model($modelid);
//如果该栏目设置了工作流，那么必须走工作流设定
$setting = string2array($category['setting']);
$workflowid = $setting['workflowid'];
if($workflowid && $_POST['status']!=99) {
//如果用户是超级管理员，那么则根据自己的设置来发布
$_POST['info']['status'] = $_SESSION['roleid']==1 ? intval($_POST['status']) : 1;
} else {
$_POST['info']['status'] = 99;
}
$this->db->add_content($_POST['info']);
if(isset($_POST['dosubmit'])) {
showmessage(L('add_success').L('2s_close'),'blank','','','function set_time() {$("#secondid").html(1);}setTimeout("set_time()", 500);setTimeout("window.close()", 1200);');
} else {
showmessage(L('add_success'),HTTP_REFERER);
}
} else {
//单网页
$this->page_db = pc_base::load_model('page_model');
$style_font_weight = $_POST['style_font_weight'] ? 'font-weight:'.strip_tags($_POST['style_font_weight']) : '';
$_POST['info']['style'] = strip_tags($_POST['style_color']).';'.$style_font_weight;
if($_POST['edit']) {
$this->page_db->update($_POST['info'],array('catid'=>$catid));
} else {
$catid = $this->page_db->insert($_POST['info'],1);
}
$this->page_db->create_html($catid,$_POST['info']);
$forward = HTTP_REFERER;
}
showmessage(L('add_success'),$forward);
} else {
$show_header = $show_dialog = $show_validator = '';
//设置cookie 在附件添加处调用
param::set_cookie('module', 'content');
if(isset($_GET['catid']) && $_GET['catid']) {
$catid = $_GET['catid'] = intval($_GET['catid']);
param::set_cookie('catid', $catid);
$category = $this->categorys[$catid];
if($category['type']==0) {
$modelid = $category['modelid'];
//取模型ID，依模型ID来生成对应的表单
require CACHE_MODEL_PATH.'content_form.class.php';
$content_form = new content_form($modelid,$catid,$this->categorys);
$forminfos = $content_form->get();
$formValidator = $content_form->formValidator;
$setting = string2array($category['setting']);
$workflowid = $setting['workflowid'];
$workflows = getcache('workflow_'.$this->siteid,'commons');
$workflows = $workflows[$workflowid];
$workflows_setting = string2array($workflows['setting']);
$nocheck_users = $workflows_setting['nocheck_users'];
$admin_username = param::get_cookie('admin_username');
if(!empty($nocheck_users) && in_array($admin_username, $nocheck_users)) {
$priv_status = true;
} else {
$priv_status = false;
}
include $this->admin_tpl('content_add');
} else {
//单网页
$this->page_db = pc_base::load_model('page_model');
$r = $this->page_db->get_one(array('catid'=>$catid));
if($r) {
extract($r);
$style_arr = explode(';',$style);
$style_color = $style_arr[0];
$style_font_weight = $style_arr[1] ? substr($style_arr[1],12) : '';
}
include $this->admin_tpl('content_page');
}
} else {
include $this->admin_tpl('content_add');
}
header("Cache-control: private");
}
}
public function edit() {
//设置cookie 在附件添加处调用
param::set_cookie('module', 'content');
if(isset($_POST['dosubmit']) || isset($_POST['dosubmit_continue'])) {
define('INDEX_HTML',true);
$id = $_POST['info']['id'] = intval($_POST['id']);
$catid = $_POST['info']['catid'] = intval($_POST['info']['catid']);
if(trim($_POST['info']['title'])=='') showmessage(L('title_is_empty'));
$modelid = $this->categorys[$catid]['modelid'];
$this->db->set_model($modelid);
$this->db->edit_content($_POST['info'],$id);
if(isset($_POST['dosubmit'])) {
showmessage(L('update_success').L('2s_close'),'blank','','','function set_time() {$("#secondid").html(1);}setTimeout("set_time()", 500);setTimeout("window.close()", 1200);');
} else {
showmessage(L('update_success'),HTTP_REFERER);
}
} else {
$show_header = $show_dialog = $show_validator = '';
//从数据库获取内容
$id = intval($_GET['id']);
if(!isset($_GET['catid']) || !$_GET['catid']) showmessage(L('missing_part_parameters'));
$catid = $_GET['catid'] = intval($_GET['catid']);
$this->model = getcache('model', 'commons');
param::set_cookie('catid', $catid);
$category = $this->categorys[$catid];
$modelid = $category['modelid'];
$this->db->table_name = $this->db->db_tablepre.$this->model[$modelid]['tablename'];
$r = $this->db->get_one(array('id'=>$id));
$this->db->table_name = $this->db->table_name.'_data';
$r2 = $this->db->get_one(array('id'=>$id));
if(!$r2) showmessage(L('subsidiary_table_datalost'),'blank');
$data = array_merge($r,$r2);
$data = array_map('htmlspecialchars_decode',$data);
require CACHE_MODEL_PATH.'content_form.class.php';
$content_form = new content_form($modelid,$catid,$this->categorys);
$forminfos = $content_form->get($data);
$formValidator = $content_form->formValidator;
include $this->admin_tpl('content_edit');
}
header("Cache-control: private");
}
/**
* 删除
*/
public function delete() {
if(isset($_GET['dosubmit'])) {
$catid = intval($_GET['catid']);
if(!$catid) showmessage(L('missing_part_parameters'));
$modelid = $this->categorys[$catid]['modelid'];
$sethtml = $this->categorys[$catid]['sethtml'];
$siteid = $this->categorys[$catid]['siteid'];
$html_root = pc_base::load_config('system','html_root');
if($sethtml) $html_root = '';
$setting = string2array($this->categorys[$catid]['setting']);
$content_ishtml = $setting['content_ishtml'];
$this->db->set_model($modelid);
$this->hits_db = pc_base::load_model('hits_model');
$this->queue = pc_base::load_model('queue_model');
if(isset($_GET['ajax_preview'])) {
$ids = intval($_GET['id']);
$_POST['ids'] = array(0=>$ids);
}
if(empty($_POST['ids'])) showmessage(L('you_do_not_check'));
//附件初始化
$attachment = pc_base::load_model('attachment_model');
$this->content_check_db = pc_base::load_model('content_check_model');
$this->position_data_db = pc_base::load_model('position_data_model');
$this->search_db = pc_base::load_model('search_model');
//判断视频模块是否安装
if (module_exists('video') && file_exists(PC_PATH.'model'.DIRECTORY_SEPARATOR.'video_content_model.class.php')) {
$video_content_db = pc_base::load_model('video_content_model');
$video_install = 1;
}
$this->comment = pc_base::load_app_class('comment', 'comment');
$search_model = getcache('search_model_'.$this->siteid,'search');
$typeid = $search_model[$modelid]['typeid'];
$this->url = pc_base::load_app_class('url', 'content');
foreach($_POST['ids'] as $id) {
$r = $this->db->get_one(array('id'=>$id));
if($content_ishtml && !$r['islink']) {
$urls = $this->url->show($id, 0, $r['catid'], $r['inputtime']);
$fileurl = $urls[1];
if($this->siteid != 1) {
$sitelist = getcache('sitelist','commons');
$fileurl = $html_root.'/'.$sitelist[$this->siteid]['dirname'].$fileurl;
}
//删除静态文件，排除htm/html/shtml外的文件
$lasttext = strrchr($fileurl,'.');
$len = -strlen($lasttext);
$path = substr($fileurl,0,$len);
$path = ltrim($path,'/');
$filelist = glob(PHPCMS_PATH.$path.'{_,-,.}*',GLOB_BRACE);
foreach ($filelist as $delfile) {
$lasttext = strrchr($delfile,'.');
if(!in_array($lasttext, array('.htm','.html','.shtml'))) continue;
@unlink($delfile);
//删除发布点队列数据
$delfile = str_replace(PHPCMS_PATH, '/', $delfile);
$this->queue->add_queue('del',$delfile,$this->siteid);
}
} else {
$fileurl = 0;
}
//删除内容
$this->db->delete_content($id,$fileurl,$catid);
//删除统计表数据
$this->hits_db->delete(array('hitsid'=>'c-'.$modelid.'-'.$id));
//删除附件
$attachment->api_delete('c-'.$catid.'-'.$id);
//删除审核表数据
$this->content_check_db->delete(array('checkid'=>'c-'.$id.'-'.$modelid));
//删除推荐位数据
$this->position_data_db->delete(array('id'=>$id,'catid'=>$catid,'module'=>'content'));
//删除全站搜索中数据
$this->search_db->delete_search($typeid,$id);
//删除视频库与内容对应关系数据
if ($video_install ==1) {
$video_content_db->delete(array('contentid'=>$id, 'modelid'=>$modelid));
}
//删除相关的评论,删除前应该判断是否还存在此模块
if(module_exists('comment')){
$commentid = id_encode('content_'.$catid, $id, $siteid);
$this->comment->del($commentid, $siteid, $id, $catid);
}
}
//更新栏目统计
$this->db->cache_items();
showmessage(L('operation_success'),HTTP_REFERER);
} else {
showmessage(L('operation_failure'));
}
}
/**
* 过审内容
*/
public function pass() {
$admin_username = param::get_cookie('admin_username');
$catid = intval($_GET['catid']);
if(!$catid) showmessage(L('missing_part_parameters'));
$category = $this->categorys[$catid];
$setting = string2array($category['setting']);
$workflowid = $setting['workflowid'];
//只有存在工作流才需要审核
if($workflowid) {
$steps = intval($_GET['steps']);
//检查当前用户有没有当前工作流的操作权限
$workflows = getcache('workflow_'.$this->siteid,'commons');
$workflows = $workflows[$workflowid];
$workflows_setting = string2array($workflows['setting']);
//将有权限的级别放到新数组中
$admin_privs = array();
foreach($workflows_setting as $_k=>$_v) {
if(empty($_v)) continue;
foreach($_v as $_value) {
if($_value==$admin_username) $admin_privs[$_k] = $_k;
}
}
if($_SESSION['roleid']!=1 && $steps && !in_array($steps,$admin_privs)) showmessage(L('permission_to_operate'));
//更改内容状态
if(isset($_GET['reject'])) {
//退稿
$status = 0;
} else {
//工作流审核级别
$workflow_steps = $workflows['steps'];
if($workflow_steps>$steps) {
$status = $steps+1;
} else {
$status = 99;
}
}
$modelid = $this->categorys[$catid]['modelid'];
$this->db->set_model($modelid);
$this->db->search_db = pc_base::load_model('search_model');
//审核通过，检查投稿奖励或扣除积分
if ($status==99) {
$html = pc_base::load_app_class('html', 'content');
$this->url = pc_base::load_app_class('url', 'content');
$member_db = pc_base::load_model('member_model');
if (isset($_POST['ids']) && !empty($_POST['ids'])) {
foreach ($_POST['ids'] as $id) {
$content_info = $this->db->get_content($catid,$id);
$memberinfo = $member_db->get_one(array('username'=>$content_info['username']), 'userid, username');
$flag = $catid.'_'.$id;
if($setting['presentpoint']>0) {
pc_base::load_app_class('receipts','pay',0);
receipts::point($setting['presentpoint'],$memberinfo['userid'], $memberinfo['username'], $flag,'selfincome',L('contribute_add_point'),$memberinfo['username']);
} else {
pc_base::load_app_class('spend','pay',0);
spend::point($setting['presentpoint'], L('contribute_del_point'), $memberinfo['userid'], $memberinfo['username'], '', '', $flag);
}
if($setting['content_ishtml'] == '1'){//栏目有静态配置
$urls = $this->url->show($id, 0, $content_info['catid'], $content_info['inputtime'], '',$content_info,'add');
$html->show($urls[1],$urls['data'],0);
}
//更新到全站搜索
$inputinfo = '';
$inputinfo['system'] = $content_info;
$this->db->search_api($id,$inputinfo);
}
} else if (isset($_GET['id']) && $_GET['id']) {
$id = intval($_GET['id']);
$content_info = $this->db->get_content($catid,$id);
$memberinfo = $member_db->get_one(array('username'=>$content_info['username']), 'userid, username');
$flag = $catid.'_'.$id;
if($setting['presentpoint']>0) {
pc_base::load_app_class('receipts','pay',0);
receipts::point($setting['presentpoint'],$memberinfo['userid'], $memberinfo['username'], $flag,'selfincome',L('contribute_add_point'),$memberinfo['username']);
} else {
pc_base::load_app_class('spend','pay',0);
spend::point($setting['presentpoint'], L('contribute_del_point'), $memberinfo['userid'], $memberinfo['username'], '', '', $flag);
}
//单篇审核，生成静态
if($setting['content_ishtml'] == '1'){//栏目有静态配置
$urls = $this->url->show($id, 0, $content_info['catid'], $content_info['inputtime'], '',$content_info,'add');
$html->show($urls[1],$urls['data'],0);
}
//更新到全站搜索
$inputinfo = '';
$inputinfo['system'] = $content_info;
$this->db->search_api($id,$inputinfo);
}
}
if(isset($_GET['ajax_preview'])) {
$_POST['ids'] = $_GET['id'];
}
$this->db->status($_POST['ids'],$status);
}
showmessage(L('operation_success'),HTTP_REFERER);
}
/**
* 排序
*/
public function listorder() {
if(isset($_GET['dosubmit'])) {
$catid = intval($_GET['catid']);
if(!$catid) showmessage(L('missing_part_parameters'));
$modelid = $this->categorys[$catid]['modelid'];
$this->db->set_model($modelid);
foreach($_POST['listorders'] as $id => $listorder) {
$this->db->update(array('listorder'=>$listorder),array('id'=>$id));
}
showmessage(L('operation_success'));
} else {
showmessage(L('operation_failure'));
}
}
/**
* 显示栏目菜单列表
*/
public function public_categorys() {
$show_header = '';
$cfg = getcache('common','commons');
$ajax_show = intval($cfg['category_ajax']);
$from = isset($_GET['from']) && in_array($_GET['from'],array('block')) ? $_GET['from'] : 'content';
$tree = pc_base::load_sys_class('tree');
if($from=='content' && $_SESSION['roleid'] != 1) {
$this->priv_db = pc_base::load_model('category_priv_model');
$priv_result = $this->priv_db->select(array('action'=>'init','roleid'=>$_SESSION['roleid'],'siteid'=>$this->siteid,'is_admin'=>1));
$priv_catids = array();
foreach($priv_result as $_v) {
$priv_catids[] = $_v['catid'];
}
if(empty($priv_catids)) return '';
}
$_GET['menuid'] = intval($_GET['menuid']);
$categorys = array();
if(!empty($this->categorys)) {
foreach($this->categorys as $r) {
if($r['siteid']!=$this->siteid || ($r['type']==2 && $r['child']==0)) continue;
if($from=='content' && $_SESSION['roleid'] != 1 && !in_array($r['catid'],$priv_catids)) {
$arrchildid = explode(',',$r['arrchildid']);
$array_intersect = array_intersect($priv_catids,$arrchildid);
if(empty($array_intersect)) continue;
}
if($r['type']==1 || $from=='block') {
if($r['type']==0) {
$r['vs_show'] = "[".L('content_page')."]";
} else {
$r['vs_show'] ='';
}
$r['icon_type'] = 'file';
$r['add_icon'] = '';
$r['type'] = 'add';
} else {
$r['icon_type'] = $r['vs_show'] = '';
$r['type'] = 'init';
$r['add_icon'] = " ";
}
$categorys[$r['catid']] = $r;
}
}
if(!empty($categorys)) {
$tree->init($categorys);
switch($from) {
case 'block':
$strs = "\$add_icon\$catname \$vs_show";
$strs2 = "![](".IMG_PATH."folder.gif)
\$catname";
break;
default:
$strs = "\$add_icon\$catname";
$strs2 = "\$catname";
break;
}
$categorys = $tree->get_treeview(0,'category_tree',$strs,$strs2,$ajax_show);
} else {
$categorys = L('please_add_category');
}
include $this->admin_tpl('category_tree');
exit;
}
/**
* 检查标题是否存在
*/
public function public_check_title() {
if($_GET['data']=='' || (!$_GET['catid'])) return '';
$catid = intval($_GET['catid']);
$modelid = $this->categorys[$catid]['modelid'];
$this->db->set_model($modelid);
$title = $_GET['data'];
if(CHARSET=='gbk') $title = iconv('utf-8','gbk',$title);
$r = $this->db->get_one(array('title'=>$title));
if($r) {
exit('1');
} else {
exit('0');
}
}
/**
* 修改某一字段数据
*/
public function update_param() {
$id = intval($_GET['id']);
$field = $_GET['field'];
$modelid = intval($_GET['modelid']);
$value = $_GET['value'];
if (CHARSET!='utf-8') {
$value = iconv('utf-8', 'gbk', $value);
}
//检查字段是否存在
$this->db->set_model($modelid);
if ($this->db->field_exists($field)) {
$this->db->update(array($field=>$value), array('id'=>$id));
exit('200');
} else {
$this->db->table_name = $this->db->table_name.'_data';
if ($this->db->field_exists($field)) {
$this->db->update(array($field=>$value), array('id'=>$id));
exit('200');
} else {
exit('300');
}
}
}
/**
* 图片裁切
*/
public function public_crop() {
if (isset($_GET['picurl']) && !empty($_GET['picurl'])) {
$picurl = $_GET['picurl'];
$catid = intval($_GET['catid']);
if (isset($_GET['module']) && !empty($_GET['module'])) {
$module = $_GET['module'];
}
$show_header = '';
include $this->admin_tpl('crop');
}
}
/**
* 相关文章选择
*/
public function public_relationlist() {
pc_base::load_sys_class('format','',0);
$show_header = '';
$model_cache = getcache('model','commons');
if(!isset($_GET['modelid'])) {
showmessage(L('please_select_modelid'));
} else {
$page = intval($_GET['page']);
$modelid = intval($_GET['modelid']);
$this->db->set_model($modelid);
$where = '';
if($_GET['catid']) {
$catid = intval($_GET['catid']);
$where .= "catid='$catid'";
}
$where .= $where ? ' AND status=99' : 'status=99';
if(isset($_GET['keywords'])) {
$keywords = trim($_GET['keywords']);
$field = $_GET['field'];
if(in_array($field, array('id','title','keywords','description'))) {
if($field=='id') {
$where .= " AND `id` ='$keywords'";
} else {
$where .= " AND `$field` like '%$keywords%'";
}
}
}
$infos = $this->db->listinfo($where,'',$page,12);
$pages = $this->db->pages;
include $this->admin_tpl('relationlist');
}
}
public function public_getjson_ids() {
$modelid = intval($_GET['modelid']);
$id = intval($_GET['id']);
$this->db->set_model($modelid);
$tablename = $this->db->table_name;
$this->db->table_name = $tablename.'_data';
$r = $this->db->get_one(array('id'=>$id),'relation');
if($r['relation']) {
$relation = str_replace('|', ',', $r['relation']);
$relation = trim($relation,',');
$where = "id IN($relation)";
$infos = array();
$this->db->table_name = $tablename;
$datas = $this->db->select($where,'id,title');
foreach($datas as $_v) {
$_v['sid'] = 'v'.$_v['id'];
if(strtolower(CHARSET)=='gbk') $_v['title'] = iconv('gbk', 'utf-8', $_v['title']);
$infos[] = $_v;
}
echo json_encode($infos);
}
}
//文章预览
public function public_preview() {
$catid = intval($_GET['catid']);
$id = intval($_GET['id']);
if(!$catid || !$id) showmessage(L('missing_part_parameters'),'blank');
$page = intval($_GET['page']);
$page = max($page,1);
$CATEGORYS = getcache('category_content_'.$this->get_siteid(),'commons');
if(!isset($CATEGORYS[$catid]) || $CATEGORYS[$catid]['type']!=0) showmessage(L('missing_part_parameters'),'blank');
define('HTML', true);
$CAT = $CATEGORYS[$catid];
$siteid = $CAT['siteid'];
$MODEL = getcache('model','commons');
$modelid = $CAT['modelid'];
$this->db->table_name = $this->db->db_tablepre.$MODEL[$modelid]['tablename'];
$r = $this->db->get_one(array('id'=>$id));
if(!$r) showmessage(L('information_does_not_exist'));
$this->db->table_name = $this->db->table_name.'_data';
$r2 = $this->db->get_one(array('id'=>$id));
$rs = $r2 ? array_merge($r,$r2) : $r;
//再次重新赋值，以数据库为准
$catid = $CATEGORYS[$r['catid']]['catid'];
$modelid = $CATEGORYS[$catid]['modelid'];
require_once CACHE_MODEL_PATH.'content_output.class.php';
$content_output = new content_output($modelid,$catid,$CATEGORYS);
$data = $content_output->get($rs);
extract($data);
$CAT['setting'] = string2array($CAT['setting']);
$template = $template ? $template : $CAT['setting']['show_template'];
$allow_visitor = 1;
//SEO
$SEO = seo($siteid, $catid, $title, $description);
define('STYLE',$CAT['setting']['template_list']);
if(isset($rs['paginationtype'])) {
$paginationtype = $rs['paginationtype'];
$maxcharperpage = $rs['maxcharperpage'];
}
$pages = $titles = '';
if($rs['paginationtype']==1) {
//自动分页
if($maxcharperpage < 10) $maxcharperpage = 500;
$contentpage = pc_base::load_app_class('contentpage');
$content = $contentpage->get_data($content,$maxcharperpage);
}
if($rs['paginationtype']!=0) {
//手动分页
$CONTENT_POS = strpos($content, '[page]');
if($CONTENT_POS !== false) {
$this->url = pc_base::load_app_class('url', 'content');
$contents = array_filter(explode('[page]', $content));
$pagenumber = count($contents);
if (strpos($content, '[/page]')!==false && ($CONTENT_POS<7)) {
$pagenumber--;
}
for($i=1; $i<=$pagenumber; $i++) {
$pageurls[$i][0] = 'index.php?m=content&c=content&a=public_preview&steps='.intval($_GET['steps']).'&catid='.$catid.'&id='.$id.'&page='.$i;
}
$END_POS = strpos($content, '[/page]');
if($END_POS !== false) {
if($CONTENT_POS>7) {
$content = '[page]'.$title.'[/page]'.$content;
}
if(preg_match_all("|\[page\](.*)\[/page\]|U", $content, $m, PREG_PATTERN_ORDER)) {
foreach($m[1] as $k=>$v) {
$p = $k+1;
$titles[$p]['title'] = strip_tags($v);
$titles[$p]['url'] = $pageurls[$p][0];
}
}
}
//当不存在 [/page]时，则使用下面分页
$pages = content_pages($pagenumber,$page, $pageurls);
//判断[page]出现的位置是否在第一位
if($CONTENT_POS<7) {
$content = $contents[$page];
} else {
if ($page==1 && !empty($titles)) {
$content = $title.'[/page]'.$contents[$page-1];
} else {
$content = $contents[$page-1];
}
}
if($titles) {
list($title, $content) = explode('[/page]', $content);
$content = trim($content);
if(strpos($content,'')===0) {
$content = ''.$content; } if(stripos($content,'
')===0) { $content = $content.'
'; } } } } include template('content',$template); $pc_hash = $_SESSION['pc_hash']; $steps = intval($_GET['steps']); echo " "; } /** * 审核所有内容 */ public function public_checkall() { $page = isset($_GET['page']) && intval($_GET['page']) ? intval($_GET['page']) : 1; $show_header = ''; $workflows = getcache('workflow_'.$this->siteid,'commons'); $datas = array(); $pagesize = 20; $sql = ''; if (in_array($_SESSION['roleid'], array('1'))) { $super_admin = 1; $status = isset($_GET['status']) ? $_GET['status'] : -1; } else { $super_admin = 0; $status = isset($_GET['status']) ? $_GET['status'] : 1; if($status==-1) $status = 1; } if($status>4) $status = 4; $this->priv_db = pc_base::load_model('category_priv_model');; $admin_username = param::get_cookie('admin_username'); if($status==-1) { $sql = "`status` NOT IN (99,0,-2) AND `siteid`=$this->siteid"; } else { $sql = "`status` = '$status' AND `siteid`=$this->siteid"; } if($status!=0 && !$super_admin) { //以栏目进行循环 foreach ($this->categorys as $catid => $cat) { if($cat['type']!=0) continue; //查看管理员是否有这个栏目的查看权限。 if (!$this->priv_db->get_one(array('catid'=>$catid, 'siteid'=>$this->siteid, 'roleid'=>$_SESSION['roleid'], 'is_admin'=>'1'))) { continue; } //如果栏目有设置工作流，进行权限检查。 $workflow = array(); $cat['setting'] = string2array($cat['setting']); if (isset($cat['setting']['workflowid']) && !empty($cat['setting']['workflowid'])) { $workflow = $workflows[$cat['setting']['workflowid']]; $workflow['setting'] = string2array($workflow['setting']); $usernames = $workflow['setting'][$status]; if (empty($usernames) || !in_array($admin_username, $usernames)) {//判断当前管理，在工作流中可以审核几审 continue; } } $priv_catid[] = $catid; } if(empty($priv_catid)) { $sql .= " AND catid = -1"; } else { $priv_catid = implode(',', $priv_catid); $sql .= " AND catid IN ($priv_catid)"; } } $this->content_check_db = pc_base::load_model('content_check_model'); $datas = $this->content_check_db->listinfo($sql,'inputtime DESC',$page); $pages = $this->content_check_db->pages; include $this->admin_tpl('content_checkall'); } /** * 批量移动文章 */ public function remove() { if(isset($_POST['dosubmit'])) { $this->content_check_db = pc_base::load_model('content_check_model'); $this->hits_db = pc_base::load_model('hits_model'); if($_POST['fromtype']==0) { if($_POST['ids']=='') showmessage(L('please_input_move_source')); if(!$_POST['tocatid']) showmessage(L('please_select_target_category')); $tocatid = intval($_POST['tocatid']); $modelid = $this->categorys[$tocatid]['modelid']; if(!$modelid) showmessage(L('illegal_operation')); $ids = array_filter(explode(',', $_POST['ids']),"is_numeric"); foreach ($ids as $id) { $checkid = 'c-'.$id.'-'.$this->siteid; $this->content_check_db->update(array('catid'=>$tocatid), array('checkid'=>$checkid)); $hitsid = 'c-'.$modelid.'-'.$id; $this->hits_db->update(array('catid'=>$tocatid),array('hitsid'=>$hitsid)); } $ids = implode(',', $ids); $this->db->set_model($modelid); $this->db->update(array('catid'=>$tocatid),"id IN($ids)"); } else { if(!$_POST['fromid']) showmessage(L('please_input_move_source')); if(!$_POST['tocatid']) showmessage(L('please_select_target_category')); $tocatid = intval($_POST['tocatid']); $modelid = $this->categorys[$tocatid]['modelid']; if(!$modelid) showmessage(L('illegal_operation')); $fromid = array_filter($_POST['fromid'],"is_numeric"); $fromid = implode(',', $fromid); $this->db->set_model($modelid); $this->db->update(array('catid'=>$tocatid),"catid IN($fromid)"); $this->hits_db->update(array('catid'=>$tocatid),"catid IN($fromid)"); } showmessage(L('operation_success'),HTTP_REFERER); //ids } else { $show_header = ''; $catid = intval($_GET['catid']); $modelid = $this->categorys[$catid]['modelid']; $tree = pc_base::load_sys_class('tree'); $tree->icon = array(' │ ',' ├─ ',' └─ '); $tree->nbsp = ' '; $categorys = array(); foreach($this->categorys as $cid=>$r) { if($this->siteid != $r['siteid'] || $r['type']) continue; if($modelid && $modelid != $r['modelid']) continue; $r['disabled'] = $r['child'] ? 'disabled' : ''; $r['selected'] = $cid == $catid ? 'selected' : ''; $categorys[$cid] = $r; } $str = ""; $tree->init($categorys); $string .= $tree->get_tree(0, $str); $str = ""; $source_string = ''; $tree->init($categorys); $source_string .= $tree->get_tree(0, $str); $ids = empty($_POST['ids']) ? '' : implode(',',$_POST['ids']); include $this->admin_tpl('content_remove'); } } /** * 同时发布到其他栏目 */ public function add_othors() { $show_header = ''; $sitelist = getcache('sitelist','commons'); $siteid = $_GET['siteid']; include $this->admin_tpl('add_othors'); } /** * 同时发布到其他栏目 异步加载栏目 */ public function public_getsite_categorys() { $siteid = intval($_GET['siteid']); $this->categorys = getcache('category_content_'.$siteid,'commons'); $models = getcache('model','commons'); $tree = pc_base::load_sys_class('tree'); $tree->icon = array(' │ ',' ├─ ',' └─ '); $tree->nbsp = ' '; $categorys = array(); if($_SESSION['roleid'] != 1) { $this->priv_db = pc_base::load_model('category_priv_model'); $priv_result = $this->priv_db->select(array('action'=>'add','roleid'=>$_SESSION['roleid'],'siteid'=>$siteid,'is_admin'=>1)); $priv_catids = array(); foreach($priv_result as $_v) { $priv_catids[] = $_v['catid']; } if(empty($priv_catids)) return ''; } foreach($this->categorys as $r) { if($r['siteid']!=$siteid || $r['type']!=0) continue; if($_SESSION['roleid'] != 1 && !in_array($r['catid'],$priv_catids)) { $arrchildid = explode(',',$r['arrchildid']); $array_intersect = array_intersect($priv_catids,$arrchildid); if(empty($array_intersect)) continue; } $r['modelname'] = $models[$r['modelid']]['name']; $r['style'] = $r['child'] ? 'color:#8A8A8A;' : ''; $r['click'] = $r['child'] ? '' : "onclick=\"select_list(this,'".safe_replace($r['catname'])."',".$r['catid'].")\" class='cu' title='".L('click_to_select')."'"; $categorys[$r['catid']] = $r; } $str = " ";
}
$categorys[$r['catid']] = $r;
}
}
if(!empty($categorys)) {
$tree->init($categorys);
switch($from) {
case 'block':
$strs = "\$add_icon\$catname \$vs_show";
break;
default:
$strs = "\$add_icon\$catname";
break;
}
$data = $tree->creat_sub_json($catid,$strs);
}
echo $data;
}
/**
* 一键清理演示数据
*/
public function clear_data() {
//清理数据涉及到的数据表
if ($_POST['dosubmit']) {
set_time_limit(0);
$models = array('category', 'content', 'hits', 'search', 'position_data', 'video_content', 'video_store', 'comment');
$tables = $_POST['tables'];
if (is_array($tables)) {
foreach ($tables as $t) {
if (in_array($t, $models)) {
if ($t=='content') {
$model = $_POST['model'];
$db = pc_base::load_model('content_model');
//读取网站的所有模型
$model_arr = getcache('model', 'commons');
foreach ($model as $modelid) {
$db->set_model($modelid);
if ($r = $db->count()) { //判断模型下是否有数据
$sql_file = CACHE_PATH.'bakup'.DIRECTORY_SEPARATOR.'default'.DIRECTORY_SEPARATOR.$model_arr[$modelid]['tablename'].'.sql';
$result = $data = $db->select();
$this->create_sql_file($result, $db->db_tablepre.$model_arr[$modelid]['tablename'], $sql_file);
$db->query('TRUNCATE TABLE `phpcms_'.$model_arr[$modelid]['tablename'].'`');
//开始清理模型data表数据
$db->table_name = $db->table_name.'_data';
$sql_file = CACHE_PATH.'bakup'.DIRECTORY_SEPARATOR.'default'.DIRECTORY_SEPARATOR.$model_arr[$modelid]['tablename'].'_data.sql';
$result = $db->select();
$this->create_sql_file($result, $db->db_tablepre.$model_arr[$modelid]['tablename'].'_data', $sql_file);
$db->query('TRUNCATE TABLE `phpcms_'.$model_arr[$modelid]['tablename'].'_data`');
//删除该模型中在hits表的数据
$hits_db = pc_base::load_model('hits_model');
$hitsid = 'c-'.$modelid.'-';
$result = $hits_db->select("`hitsid` LIKE '%$hitsid%'");
if (is_array($result)) {
$sql_file = CACHE_PATH.'bakup'.DIRECTORY_SEPARATOR.'default'.DIRECTORY_SEPARATOR.'hits-'.$modelid.'.sql';
$this->create_sql_file($result, $hits_db->db_tablepre.'hits', $sql_file);
}
$hits_db->delete("`hitsid` LIKE '%$hitsid%'");
//删除该模型在search中的数据
$search_db = pc_base::load_model('search_model');
$type_model = getcache('type_model_'.$model_arr[$modelid]['siteid'], 'search');
$typeid = $type_model[$modelid];
$result = $search_db->select("`typeid`=".$typeid);
if (is_array($result)) {
$sql_file = CACHE_PATH.'bakup'.DIRECTORY_SEPARATOR.'default'.DIRECTORY_SEPARATOR.'search-'.$modelid.'.sql';
$this->create_sql_file($result, $search_db->db_tablepre.'search', $sql_file);
}
$search_db->delete("`typeid`=".$typeid);
//Delete the model data in the position table
$position_db = pc_base::load_model('position_data_model');
$result = $position_db->select('`modelid`='.$modelid.' AND `module`=\'content\'');
if (is_array($result)) {
$sql_file = CACHE_PATH.'bakup'.DIRECTORY_SEPARATOR.'default'.DIRECTORY_SEPARATOR.'position_data-'.$modelid.'.sql';
$this->create_sql_file($result, $position_db->db_tablepre.'position_data', $sql_file);
}
$position_db->delete('`modelid`='.$modelid.' AND `module`=\'content\'');
//清理视频库与内容对应关系表
if (module_exists('video')) {
$video_content_db = pc_base::load_model('video_content_model');
$result = $video_content_db->select('`modelid`=\''.$modelid.'\'');
if (is_array($result)) {
$sql_file = CACHE_PATH.'bakup'.DIRECTORY_SEPARATOR.'default'.DIRECTORY_SEPARATOR.'video_content-'.$modelid.'.sql';
$this->create_sql_file($result, $video_content_db->db_tablepre.'video_content', $sql_file);
}
$video_content_db->delete('`modelid`=\''.$modelid.'\'');
}
//清理评论表及附件表，附件的清理为不可逆操作。
//附件初始化
//$attachment = pc_base::load_model('attachment_model');
//$comment = pc_base::load_app_class('comment', 'comment');
//if(module_exists('comment')){
//$comment_exists = 1;
//}
//foreach ($data as $d) {
//$attachment->api_delete('c-'.$d['catid'].'-'.$d['id']);
//if ($comment_exists) {
//$commentid = id_encode('content_'.$d['catid'], $d['id'], $model_arr[$modelid]['siteid']);
//$comment->del($commentid, $model_arr[$modelid]['siteid'], $d['id'], $d['catid']);
//}
//}
}
}
} elseif ($t=='comment') {
$comment_db = pc_base::load_model('comment_data_model');
for($i=1;;$i++) {
$comment_db->table_name($i);
if ($comment_db->table_exists(str_replace($comment_db->db_tablepre, '', $comment_db->table_name))) {
if ($r = $comment_db->count()) {
$sql_file = CACHE_PATH.'bakup'.DIRECTORY_SEPARATOR.'default'.DIRECTORY_SEPARATOR.'comment_data_'.$i.'.sql';
$result = $comment_db->select();
$this->create_sql_file($result, $comment_db->db_tablepre.'comment_data_'.$i, $sql_file);
$comment_db->query('TRUNCATE TABLE `phpcms_comment_data_'.$i.'`');
}
} else {
break;
}
}
} else {
$db = pc_base::load_model($t.'_model');
if ($r = $db->count()) {
$result = $db->select();
$sql_file = CACHE_PATH.'bakup'.DIRECTORY_SEPARATOR.'default'.DIRECTORY_SEPARATOR.$t.'.sql';
$this->create_sql_file($result, $db->db_tablepre.$t, $sql_file);
$db->query('TRUNCATE TABLE `phpcms_'.$t.'`');
}
}
}
}
}
showmessage(L('clear_data_message'));
} else {
//读取网站的所有模型
$model_arr = getcache('model', 'commons');
include $this->admin_tpl('clear_data');
}
}
/**
* 备份数据到文件
* @param $data array 备份的数据数组
* @param $tablename 数据所属数据表
* @param $file 备份到的文件
*/
private function create_sql_file($data, $db, $file) {
if (is_array($data)) {
$sql = '';
foreach ($data as $d) {
$tag = '';
$sql .= "INSERT INTO `".$db.'` VALUES(';
foreach ($d as $_f => $_v) {
$sql .= $tag.'\''.addslashes($_v).'\'';
$tag = ',';
}
$sql .= ');'."\r\n";
}
file_put_contents($file, $sql);
}
return true;
}
}
?>