PageRenderTime 52ms CodeModel.GetById 18ms RepoModel.GetById 1ms app.codeStats 0ms

/phpcms/modules/content/content.php

https://github.com/sinfey69/cms
PHP | 1136 lines | 967 code | 50 blank | 119 comment | 251 complexity | 595c8c1691fc1bc258c763ca36828ae5 MD5 | raw file
    

  1. <?php
    2. 

  2. set_time_limit(300);
    3. 

  3. defined('IN_PHPCMS') or exit('No permission resources.');
    4. 

  4. //模型缓存路径
    5. 

  5. define('CACHE_MODEL_PATH',CACHE_PATH.'caches_model'.DIRECTORY_SEPARATOR.'caches_data'.DIRECTORY_SEPARATOR);
    6. 

  6. //定义在单独操作内容的时候，同时更新相关栏目页面
    7. 

  7. define('RELATION_HTML',true);
    8. 

  8. 

  9. pc_base::load_app_class('admin','admin',0);
    10. 

  10. pc_base::load_sys_class('form','',0);
    11. 

  11. pc_base::load_app_func('util');
    12. 

  12. pc_base::load_sys_class('format','',0);
    13. 

  13. 

  14. class content extends admin {
    15. 

  15. 	private $db,$priv_db;
    16. 

  16. 	public $siteid,$categorys;
    17. 

  17. 	public function __construct() {
    18. 

  18. 		parent::__construct();
    19. 

  19. 		$this->db = pc_base::load_model('content_model');
    20. 

  20. 		$this->siteid = $this->get_siteid();
    21. 

  21. 		$this->categorys = getcache('category_content_'.$this->siteid,'commons');
    22. 

  22. 		//权限判断
    23. 

  23. 		if(isset($_GET['catid']) && $_SESSION['roleid'] != 1 && ROUTE_A !='pass' && strpos(ROUTE_A,'public_')===false) {
    24. 

  24. 			$catid = intval($_GET['catid']);
    25. 

  25. 			$this->priv_db = pc_base::load_model('category_priv_model');
    26. 

  26. 			$action = $this->categorys[$catid]['type']==0 ? ROUTE_A : 'init';
    27. 

  27. 			$priv_datas = $this->priv_db->get_one(array('catid'=>$catid,'is_admin'=>1,'action'=>$action));
    28. 

  28. 			if(!$priv_datas) showmessage(L('permission_to_operate'),'blank');
    29. 

  29. 		}
    30. 

  30. 	}
    31. 

  31. 	
    32. 

  32. 	public function init() {
    33. 

  33. 		$show_header = $show_dialog  = $show_pc_hash = '';
    34. 

  34. 		if(isset($_GET['catid']) && $_GET['catid'] && $this->categorys[$_GET['catid']]['siteid']==$this->siteid) {
    35. 

  35. 			$catid = $_GET['catid'] = intval($_GET['catid']);
    36. 

  36. 			$category = $this->categorys[$catid];
    37. 

  37. 			$modelid = $category['modelid'];
    38. 

  38. 			$model_arr = getcache('model', 'commons');
    39. 

  39. 			$MODEL = $model_arr[$modelid];
    40. 

  40. 			unset($model_arr);
    41. 

  41. 			$admin_username = param::get_cookie('admin_username');
    42. 

  42. 			//查询当前的工作流
    43. 

  43. 			$setting = string2array($category['setting']);
    44. 

  44. 			$workflowid = $setting['workflowid'];
    45. 

  45. 			$workflows = getcache('workflow_'.$this->siteid,'commons');
    46. 

  46. 			$workflows = $workflows[$workflowid];
    47. 

  47. 			$workflows_setting = string2array($workflows['setting']);
    48. 

  48. 

  49. 			//将有权限的级别放到新数组中
    50. 

  50. 			$admin_privs = array();
    51. 

  51. 			foreach($workflows_setting as $_k=>$_v) {
    52. 

  52. 				if(empty($_v)) continue;
    53. 

  53. 				foreach($_v as $_value) {
    54. 

  54. 					if($_value==$admin_username) $admin_privs[$_k] = $_k;
    55. 

  55. 				}
    56. 

  56. 			}
    57. 

  57. 			//工作流审核级别
    58. 

  58. 			$workflow_steps = $workflows['steps'];
    59. 

  59. 			$workflow_menu = '';
    60. 

  60. 			$steps = isset($_GET['steps']) ? intval($_GET['steps']) : 0;
    61. 

  61. 			//工作流权限判断
    62. 

  62. 			if($_SESSION['roleid']!=1 && $steps && !in_array($steps,$admin_privs)) showmessage(L('permission_to_operate'));
    63. 

  63. 			$this->db->set_model($modelid);
    64. 

  64. 			if($this->db->table_name==$this->db->db_tablepre) showmessage(L('model_table_not_exists'));;
    65. 

  65. 			$status = $steps ? $steps : 99;
    66. 

  66. 			if(isset($_GET['reject'])) $status = 0;
    67. 

  67. 			$where = 'catid='.$catid.' AND status='.$status;
    68. 

  68. 			//搜索
    69. 

  69. 			
    70. 

  70. 			if(isset($_GET['start_time']) && $_GET['start_time']) {
    71. 

  71. 				$start_time = strtotime($_GET['start_time']);
    72. 

  72. 				$where .= " AND `inputtime` > '$start_time'";
    73. 

  73. 			}
    74. 

  74. 			if(isset($_GET['end_time']) && $_GET['end_time']) {
    75. 

  75. 				$end_time = strtotime($_GET['end_time']);
    76. 

  76. 				$where .= " AND `inputtime` < '$end_time'";
    77. 

  77. 			}
    78. 

  78. 			if($start_time>$end_time) showmessage(L('starttime_than_endtime'));
    79. 

  79. 			if(isset($_GET['keyword']) && !empty($_GET['keyword'])) {
    80. 

  80. 				$type_array = array('title','description','username');
    81. 

  81. 				$searchtype = intval($_GET['searchtype']);
    82. 

  82. 				if($searchtype < 3) {
    83. 

  83. 					$searchtype = $type_array[$searchtype];
    84. 

  84. 					$keyword = strip_tags(trim($_GET['keyword']));
    85. 

  85. 					$where .= " AND `$searchtype` like '%$keyword%'";
    86. 

  86. 				} elseif($searchtype==3) {
    87. 

  87. 					$keyword = intval($_GET['keyword']);
    88. 

  88. 					$where .= " AND `id`='$keyword'";
    89. 

  89. 				}
    90. 

  90. 			}
    91. 

  91. 			if(isset($_GET['posids']) && !empty($_GET['posids'])) {
    92. 

  92. 				$posids = $_GET['posids']==1 ? intval($_GET['posids']) : 0;
    93. 

  93. 				$where .= " AND `posids` = '$posids'";
    94. 

  94. 			}
    95. 

  95. 			
    96. 

  96. 			$datas = $this->db->listinfo($where,'id desc',$_GET['page']);
    97. 

  97. 			$pages = $this->db->pages;
    98. 

  98. 			$pc_hash = $_SESSION['pc_hash'];
    99. 

  99. 			for($i=1;$i<=$workflow_steps;$i++) {
    100. 

  100. 				if($_SESSION['roleid']!=1 && !in_array($i,$admin_privs)) continue;
    101. 

  101. 				$current = $steps==$i ? 'class=on' : '';
    102. 

  102. 				$r = $this->db->get_one(array('catid'=>$catid,'status'=>$i));
    103. 

  103. 				$newimg = $r ? '<img src="'.IMG_PATH.'icon/new.png" style="padding-bottom:2px" onclick="window.location.href=\'?m=content&c=content&a=&menuid='.$_GET['menuid'].'&catid='.$catid.'&steps='.$i.'&pc_hash='.$pc_hash.'\'">' : '';
    104. 

  104. 				$workflow_menu .= '<a href="?m=content&c=content&a=&menuid='.$_GET['menuid'].'&catid='.$catid.'&steps='.$i.'&pc_hash='.$pc_hash.'" '.$current.' ><em>'.L('workflow_'.$i).$newimg.'</em></a><span>|</span>';
    105. 

  105. 			}
    106. 

  106. 			if($workflow_menu) {
    107. 

  107. 				$current = isset($_GET['reject']) ? 'class=on' : '';
    108. 

  108. 				$workflow_menu .= '<a href="?m=content&c=content&a=&menuid='.$_GET['menuid'].'&catid='.$catid.'&pc_hash='.$pc_hash.'&reject=1" '.$current.' ><em>'.L('reject').'</em></a><span>|</span>';
    109. 

  109. 			}
    110. 

  110. 			//$ = 153fc6d28dda8ca94eaa3686c8eed857;获取模型的thumb字段配置信息
    111. 

  111. 			$model_fields = getcache('model_field_'.$modelid, 'model');
    112. 

  112. 			$setting = string2array($model_fields['thumb']['setting']);
    113. 

  113. 			$args = '1,'.$setting['upload_allowext'].','.$setting['isselectimage'].','.$setting['images_width'].','.$setting['images_height'].','.$setting['watermark'];
    114. 

  114. 			$authkey = upload_key($args);
    115. 

  115. 			$template = $MODEL['admin_list_template'] ? $MODEL['admin_list_template'] : 'content_list';
    116. 

  116. 			include $this->admin_tpl($template);
    117. 

  117. 		} else {
    118. 

  118. 			include $this->admin_tpl('content_quick');
    119. 

  119. 		}
    120. 

  120. 	}
    121. 

  121. 	public function add() {
    122. 

  122. 		if(isset($_POST['dosubmit']) || isset($_POST['dosubmit_continue'])) {
    123. 

  123. 			define('INDEX_HTML',true);
    124. 

  124. 			$catid = $_POST['info']['catid'] = intval($_POST['info']['catid']);
    125. 

  125. 			if(trim($_POST['info']['title'])=='') showmessage(L('title_is_empty'));
    126. 

  126. 			$category = $this->categorys[$catid];
    127. 

  127. 			if($category['type']==0) {
    128. 

  128. 				$modelid = $this->categorys[$catid]['modelid'];
    129. 

  129. 				$this->db->set_model($modelid);
    130. 

  130. 				//如果该栏目设置了工作流，那么必须走工作流设定
    131. 

  131. 				$setting = string2array($category['setting']);
    132. 

  132. 				$workflowid = $setting['workflowid'];
    133. 

  133. 				if($workflowid && $_POST['status']!=99) {
    134. 

  134. 					//如果用户是超级管理员，那么则根据自己的设置来发布
    135. 

  135. 					$_POST['info']['status'] = $_SESSION['roleid']==1 ? intval($_POST['status']) : 1;
    136. 

  136. 				} else {
    137. 

  137. 					$_POST['info']['status'] = 99;
    138. 

  138. 				}
    139. 

  139. 				$this->db->add_content($_POST['info']);
    140. 

  140. 				if(isset($_POST['dosubmit'])) {
    141. 

  141. 					showmessage(L('add_success').L('2s_close'),'blank','','','function set_time() {$("#secondid").html(1);}setTimeout("set_time()", 500);setTimeout("window.close()", 1200);');
    142. 

  142. 				} else {
    143. 

  143. 					showmessage(L('add_success'),HTTP_REFERER);
    144. 

  144. 				}
    145. 

  145. 			} else {
    146. 

  146. 				//单网页
    147. 

  147. 				$this->page_db = pc_base::load_model('page_model');
    148. 

  148. 				$style_font_weight = $_POST['style_font_weight'] ? 'font-weight:'.strip_tags($_POST['style_font_weight']) : '';
    149. 

  149. 				$_POST['info']['style'] = strip_tags($_POST['style_color']).';'.$style_font_weight;
    150. 

  150. 				
    151. 

  151. 				if($_POST['edit']) {
    152. 

  152. 					$this->page_db->update($_POST['info'],array('catid'=>$catid));
    153. 

  153. 				} else {
    154. 

  154. 					$catid = $this->page_db->insert($_POST['info'],1);
    155. 

  155. 				}
    156. 

  156. 				$this->page_db->create_html($catid,$_POST['info']);
    157. 

  157. 				$forward = HTTP_REFERER;
    158. 

  158. 			}
    159. 

  159. 			showmessage(L('add_success'),$forward);
    160. 

  160. 		} else {
    161. 

  161. 			$show_header = $show_dialog = $show_validator = '';
    162. 

  162. 			//设置cookie 在附件添加处调用
    163. 

  163. 			param::set_cookie('module', 'content');
    164. 

  164. 

  165. 			if(isset($_GET['catid']) && $_GET['catid']) {
    166. 

  166. 				$catid = $_GET['catid'] = intval($_GET['catid']);
    167. 

  167. 				
    168. 

  168. 				param::set_cookie('catid', $catid);
    169. 

  169. 				$category = $this->categorys[$catid];
    170. 

  170. 				if($category['type']==0) {
    171. 

  171. 					$modelid = $category['modelid'];
    172. 

  172. 					//取模型ID，依模型ID来生成对应的表单
    173. 

  173. 					require CACHE_MODEL_PATH.'content_form.class.php';
    174. 

  174. 					$content_form = new content_form($modelid,$catid,$this->categorys);
    175. 

  175. 					$forminfos = $content_form->get();
    176. 

  176.  					$formValidator = $content_form->formValidator;
    177. 

  177. 					$setting = string2array($category['setting']);
    178. 

  178. 					$workflowid = $setting['workflowid'];
    179. 

  179. 					$workflows = getcache('workflow_'.$this->siteid,'commons');
    180. 

  180. 					$workflows = $workflows[$workflowid];
    181. 

  181. 					$workflows_setting = string2array($workflows['setting']);
    182. 

  182. 					$nocheck_users = $workflows_setting['nocheck_users'];
    183. 

  183. 					$admin_username = param::get_cookie('admin_username');
    184. 

  184. 					if(!empty($nocheck_users) && in_array($admin_username, $nocheck_users)) {
    185. 

  185. 						$priv_status = true;
    186. 

  186. 					} else {
    187. 

  187. 						$priv_status = false;
    188. 

  188. 					}
    189. 

  189. 					include $this->admin_tpl('content_add');
    190. 

  190. 				} else {
    191. 

  191. 					//单网页
    192. 

  192. 					$this->page_db = pc_base::load_model('page_model');
    193. 

  193. 					
    194. 

  194. 					$r = $this->page_db->get_one(array('catid'=>$catid));
    195. 

  195. 					
    196. 

  196. 					if($r) {
    197. 

  197. 						extract($r);
    198. 

  198. 						$style_arr = explode(';',$style);
    199. 

  199. 						$style_color = $style_arr[0];
    200. 

  200. 						$style_font_weight = $style_arr[1] ? substr($style_arr[1],12) : '';
    201. 

  201. 					}
    202. 

  202. 					include $this->admin_tpl('content_page');
    203. 

  203. 				}
    204. 

  204. 			} else {
    205. 

  205. 				include $this->admin_tpl('content_add');
    206. 

  206. 			}
    207. 

  207. 			header("Cache-control: private");
    208. 

  208. 		}
    209. 

  209. 	}
    210. 

  210. 	
    211. 

  211. 	public function edit() {
    212. 

  212. 			//设置cookie 在附件添加处调用
    213. 

  213. 			param::set_cookie('module', 'content');
    214. 

  214. 			if(isset($_POST['dosubmit']) || isset($_POST['dosubmit_continue'])) {
    215. 

  215. 				define('INDEX_HTML',true);
    216. 

  216. 				$id = $_POST['info']['id'] = intval($_POST['id']);
    217. 

  217. 				$catid = $_POST['info']['catid'] = intval($_POST['info']['catid']);
    218. 

  218. 				if(trim($_POST['info']['title'])=='') showmessage(L('title_is_empty'));
    219. 

  219. 				$modelid = $this->categorys[$catid]['modelid'];
    220. 

  220. 				$this->db->set_model($modelid);
    221. 

  221. 				$this->db->edit_content($_POST['info'],$id);
    222. 

  222. 				if(isset($_POST['dosubmit'])) {
    223. 

  223. 					showmessage(L('update_success').L('2s_close'),'blank','','','function set_time() {$("#secondid").html(1);}setTimeout("set_time()", 500);setTimeout("window.close()", 1200);');
    224. 

  224. 				} else {
    225. 

  225. 					showmessage(L('update_success'),HTTP_REFERER);
    226. 

  226. 				}
    227. 

  227. 			} else {
    228. 

  228. 				$show_header = $show_dialog = $show_validator = '';
    229. 

  229. 				//从数据库获取内容
    230. 

  230. 				$id = intval($_GET['id']);
    231. 

  231. 				if(!isset($_GET['catid']) || !$_GET['catid']) showmessage(L('missing_part_parameters'));
    232. 

  232. 				$catid = $_GET['catid'] = intval($_GET['catid']);
    233. 

  233. 				
    234. 

  234. 				$this->model = getcache('model', 'commons');
    235. 

  235. 				
    236. 

  236. 				param::set_cookie('catid', $catid);
    237. 

  237. 				$category = $this->categorys[$catid];
    238. 

  238. 				$modelid = $category['modelid'];
    239. 

  239. 				$this->db->table_name = $this->db->db_tablepre.$this->model[$modelid]['tablename'];
    240. 

  240. 				$r = $this->db->get_one(array('id'=>$id));
    241. 

  241. 				$this->db->table_name = $this->db->table_name.'_data';
    242. 

  242. 				$r2 = $this->db->get_one(array('id'=>$id));
    243. 

  243. 				if(!$r2) showmessage(L('subsidiary_table_datalost'),'blank');
    244. 

  244. 				$data = array_merge($r,$r2);
    245. 

  245. 				$data = array_map('htmlspecialchars_decode',$data);
    246. 

  246. 				require CACHE_MODEL_PATH.'content_form.class.php';
    247. 

  247. 				$content_form = new content_form($modelid,$catid,$this->categorys);
    248. 

  248. 

  249. 				$forminfos = $content_form->get($data);
    250. 

  250. 				$formValidator = $content_form->formValidator;
    251. 

  251. 				include $this->admin_tpl('content_edit');
    252. 

  252. 			}
    253. 

  253. 			header("Cache-control: private");
    254. 

  254. 	}
    255. 

  255. 	/**
    256. 

  256. 	 * 删除
    257. 

  257. 	 */
    258. 

  258. 	public function delete() {
    259. 

  259. 		if(isset($_GET['dosubmit'])) {
    260. 

  260. 			$catid = intval($_GET['catid']);
    261. 

  261. 			if(!$catid) showmessage(L('missing_part_parameters'));
    262. 

  262. 			$modelid = $this->categorys[$catid]['modelid'];
    263. 

  263. 			$sethtml = $this->categorys[$catid]['sethtml'];
    264. 

  264. 			$siteid = $this->categorys[$catid]['siteid'];
    265. 

  265. 			
    266. 

  266. 			$html_root = pc_base::load_config('system','html_root');
    267. 

  267. 			if($sethtml) $html_root = '';
    268. 

  268. 			
    269. 

  269. 			$setting = string2array($this->categorys[$catid]['setting']);
    270. 

  270. 			$content_ishtml = $setting['content_ishtml']; 
    271. 

  271. 			$this->db->set_model($modelid);
    272. 

  272. 			$this->hits_db = pc_base::load_model('hits_model');
    273. 

  273. 			$this->queue = pc_base::load_model('queue_model');
    274. 

  274. 			if(isset($_GET['ajax_preview'])) {
    275. 

  275. 				$ids = intval($_GET['id']);
    276. 

  276. 				$_POST['ids'] = array(0=>$ids);
    277. 

  277. 			}
    278. 

  278. 			if(empty($_POST['ids'])) showmessage(L('you_do_not_check'));
    279. 

  279. 			//附件初始化
    280. 

  280. 			$attachment = pc_base::load_model('attachment_model');
    281. 

  281. 			$this->content_check_db = pc_base::load_model('content_check_model');
    282. 

  282. 			$this->position_data_db = pc_base::load_model('position_data_model');
    283. 

  283. 			$this->search_db = pc_base::load_model('search_model');
    284. 

  284. 			//判断视频模块是否安装 
    285. 

  285. 			if (module_exists('video') && file_exists(PC_PATH.'model'.DIRECTORY_SEPARATOR.'video_content_model.class.php')) {
    286. 

  286. 				$video_content_db = pc_base::load_model('video_content_model');
    287. 

  287. 				$video_install = 1;
    288. 

  288. 			}
    289. 

  289. 			$this->comment = pc_base::load_app_class('comment', 'comment');
    290. 

  290. 			$search_model = getcache('search_model_'.$this->siteid,'search');
    291. 

  291. 			$typeid = $search_model[$modelid]['typeid'];
    292. 

  292. 			$this->url = pc_base::load_app_class('url', 'content');
    293. 

  293. 			
    294. 

  294. 			foreach($_POST['ids'] as $id) {
    295. 

  295. 				$r = $this->db->get_one(array('id'=>$id));
    296. 

  296. 				if($content_ishtml && !$r['islink']) {
    297. 

  297. 					$urls = $this->url->show($id, 0, $r['catid'], $r['inputtime']);
    298. 

  298. 					$fileurl = $urls[1];
    299. 

  299. 					if($this->siteid != 1) {
    300. 

  300. 						$sitelist = getcache('sitelist','commons');
    301. 

  301. 						$fileurl = $html_root.'/'.$sitelist[$this->siteid]['dirname'].$fileurl;
    302. 

  302. 					}
    303. 

  303. 					//删除静态文件，排除htm/html/shtml外的文件
    304. 

  304. 					$lasttext = strrchr($fileurl,'.');
    305. 

  305. 					$len = -strlen($lasttext);
    306. 

  306. 					$path = substr($fileurl,0,$len);
    307. 

  307. 					$path = ltrim($path,'/');
    308. 

  308. 					$filelist = glob(PHPCMS_PATH.$path.'*');
    309. 

  309. 					foreach ($filelist as $delfile) {
    310. 

  310. 						$lasttext = strrchr($delfile,'.');
    311. 

  311. 						if(!in_array($lasttext, array('.htm','.html','.shtml'))) continue;
    312. 

  312. 						@unlink($delfile);
    313. 

  313. 						//删除发布点队列数据
    314. 

  314. 						$delfile = str_replace(PHPCMS_PATH, '/', $delfile);
    315. 

  315. 						$this->queue->add_queue('del',$delfile,$this->siteid);
    316. 

  316. 					}
    317. 

  317. 				} else {
    318. 

  318. 					$fileurl = 0;
    319. 

  319. 				}
    320. 

  320. 				//删除内容
    321. 

  321. 				$this->db->delete_content($id,$fileurl,$catid);
    322. 

  322. 				//删除统计表数据
    323. 

  323. 				$this->hits_db->delete(array('hitsid'=>'c-'.$modelid.'-'.$id));
    324. 

  324. 				//删除附件
    325. 

  325. 				$attachment->api_delete('c-'.$catid.'-'.$id);
    326. 

  326. 				//删除审核表数据
    327. 

  327. 				$this->content_check_db->delete(array('checkid'=>'c-'.$id.'-'.$modelid));
    328. 

  328. 				//删除推荐位数据
    329. 

  329. 				$this->position_data_db->delete(array('id'=>$id,'catid'=>$catid,'module'=>'content'));
    330. 

  330. 				//删除全站搜索中数据
    331. 

  331. 				$this->search_db->delete_search($typeid,$id);
    332. 

  332. 				//删除视频库与内容对应关系数据
    333. 

  333. 				if ($video_install ==1) {
    334. 

  334. 					$video_content_db->delete(array('contentid'=>$id, 'modelid'=>$modelid));
    335. 

  335. 				}
    336. 

  336. 				
    337. 

  337. 				//删除相关的评论,删除前应该判断是否还存在此模块
    338. 

  338. 				if(module_exists('comment')){
    339. 

  339. 					$commentid = id_encode('content_'.$catid, $id, $siteid);
    340. 

  340. 					$this->comment->del($commentid, $siteid, $id, $catid);
    341. 

  341. 				}
    342. 

  342. 				
    343. 

  343.  			}
    344. 

  344. 			//更新栏目统计
    345. 

  345. 			$this->db->cache_items();
    346. 

  346. 			showmessage(L('operation_success'),HTTP_REFERER);
    347. 

  347. 		} else {
    348. 

  348. 			showmessage(L('operation_failure'));
    349. 

  349. 		}
    350. 

  350. 	}
    351. 

  351. 	/**
    352. 

  352. 	 * 过审内容
    353. 

  353. 	 */
    354. 

  354. 	public function pass() {
    355. 

  355. 		$admin_username = param::get_cookie('admin_username');
    356. 

  356. 		$catid = intval($_GET['catid']);
    357. 

  357. 		
    358. 

  358. 		if(!$catid) showmessage(L('missing_part_parameters'));
    359. 

  359. 		$category = $this->categorys[$catid];
    360. 

  360. 		$setting = string2array($category['setting']);
    361. 

  361. 		$workflowid = $setting['workflowid'];
    362. 

  362. 		//只有存在工作流才需要审核
    363. 

  363. 		if($workflowid) {
    364. 

  364. 			$steps = intval($_GET['steps']);
    365. 

  365. 			//检查当前用户有没有当前工作流的操作权限
    366. 

  366. 			$workflows = getcache('workflow_'.$this->siteid,'commons');
    367. 

  367. 			$workflows = $workflows[$workflowid];
    368. 

  368. 			$workflows_setting = string2array($workflows['setting']);
    369. 

  369. 			//将有权限的级别放到新数组中
    370. 

  370. 			$admin_privs = array();
    371. 

  371. 			foreach($workflows_setting as $_k=>$_v) {
    372. 

  372. 				if(empty($_v)) continue;
    373. 

  373. 				foreach($_v as $_value) {
    374. 

  374. 					if($_value==$admin_username) $admin_privs[$_k] = $_k;
    375. 

  375. 				}
    376. 

  376. 			}
    377. 

  377. 			if($_SESSION['roleid']!=1 && $steps && !in_array($steps,$admin_privs)) showmessage(L('permission_to_operate'));
    378. 

  378. 			//更改内容状态
    379. 

  379. 				if(isset($_GET['reject'])) {
    380. 

  380. 				//退稿
    381. 

  381. 					$status = 0;
    382. 

  382. 				} else {
    383. 

  383. 					//工作流审核级别
    384. 

  384. 					$workflow_steps = $workflows['steps'];
    385. 

  385. 					
    386. 

  386. 					if($workflow_steps>$steps) {
    387. 

  387. 						$status = $steps+1;
    388. 

  388. 					} else {
    389. 

  389. 						$status = 99;
    390. 

  390. 					}
    391. 

  391. 				}
    392. 

  392. 				
    393. 

  393. 				$modelid = $this->categorys[$catid]['modelid'];
    394. 

  394. 				$this->db->set_model($modelid);
    395. 

  395. 				$this->db->search_db = pc_base::load_model('search_model');
    396. 

  396. 				//审核通过，检查投稿奖励或扣除积分
    397. 

  397. 				if ($status==99) {
    398. 

  398. 					$html = pc_base::load_app_class('html', 'content');
    399. 

  399. 					$this->url = pc_base::load_app_class('url', 'content');
    400. 

  400. 					$member_db = pc_base::load_model('member_model');
    401. 

  401. 					if (isset($_POST['ids']) && !empty($_POST['ids'])) {
    402. 

  402. 						foreach ($_POST['ids'] as $id) {
    403. 

  403. 							$content_info = $this->db->get_content($catid,$id);
    404. 

  404. 							$memberinfo = $member_db->get_one(array('username'=>$content_info['username']), 'userid, username');
    405. 

  405. 							$flag = $catid.'_'.$id;
    406. 

  406. 							if($setting['presentpoint']>0) {
    407. 

  407. 								pc_base::load_app_class('receipts','pay',0);
    408. 

  408. 								receipts::point($setting['presentpoint'],$memberinfo['userid'], $memberinfo['username'], $flag,'selfincome',L('contribute_add_point'),$memberinfo['username']);
    409. 

  409. 							} else {
    410. 

  410. 								pc_base::load_app_class('spend','pay',0);
    411. 

  411. 								spend::point($setting['presentpoint'], L('contribute_del_point'), $memberinfo['userid'], $memberinfo['username'], '', '', $flag);
    412. 

  412. 							}
    413. 

  413. 							if($setting['content_ishtml'] == '1'){//栏目有静态配置
    414. 

  414.   								$urls = $this->url->show($id, 0, $content_info['catid'], $content_info['inputtime'], '',$content_info,'add');
    415. 

  415.    								$html->show($urls[1],$urls['data'],0);
    416. 

  416.  							}
    417. 

  417. 							//更新到全站搜索
    418. 

  418. 							$inputinfo = '';
    419. 

  419. 							$inputinfo['system'] = $content_info;
    420. 

  420. 							$this->db->search_api($id,$inputinfo);
    421. 

  421. 						}
    422. 

  422. 					} else if (isset($_GET['id']) && $_GET['id']) {
    423. 

  423. 						$id = intval($_GET['id']);
    424. 

  424. 						$content_info = $this->db->get_content($catid,$id);
    425. 

  425. 						$memberinfo = $member_db->get_one(array('username'=>$content_info['username']), 'userid, username');
    426. 

  426. 						$flag = $catid.'_'.$id;
    427. 

  427. 						if($setting['presentpoint']>0) {
    428. 

  428. 							pc_base::load_app_class('receipts','pay',0);
    429. 

  429. 							receipts::point($setting['presentpoint'],$memberinfo['userid'], $memberinfo['username'], $flag,'selfincome',L('contribute_add_point'),$memberinfo['username']);
    430. 

  430. 						} else {
    431. 

  431. 							pc_base::load_app_class('spend','pay',0);
    432. 

  432. 							spend::point($setting['presentpoint'], L('contribute_del_point'), $memberinfo['userid'], $memberinfo['username'], '', '', $flag);
    433. 

  433. 						}
    434. 

  434. 						//单篇审核，生成静态
    435. 

  435. 						if($setting['content_ishtml'] == '1'){//栏目有静态配置
    436. 

  436. 						$urls = $this->url->show($id, 0, $content_info['catid'], $content_info['inputtime'], '',$content_info,'add');
    437. 

  437. 						$html->show($urls[1],$urls['data'],0);
    438. 

  438. 						}
    439. 

  439. 						//更新到全站搜索
    440. 

  440. 						$inputinfo = '';
    441. 

  441. 						$inputinfo['system'] = $content_info;
    442. 

  442. 						$this->db->search_api($id,$inputinfo);
    443. 

  443. 					}
    444. 

  444. 				}
    445. 

  445. 				if(isset($_GET['ajax_preview'])) {
    446. 

  446. 					$_POST['ids'] = $_GET['id'];
    447. 

  447. 				}
    448. 

  448. 				$this->db->status($_POST['ids'],$status);
    449. 

  449. 		}
    450. 

  450. 		showmessage(L('operation_success'),HTTP_REFERER);
    451. 

  451. 	}
    452. 

  452. 	/**
    453. 

  453. 	 * 排序
    454. 

  454. 	 */
    455. 

  455. 	public function listorder() {
    456. 

  456. 		if(isset($_GET['dosubmit'])) {
    457. 

  457. 			$catid = intval($_GET['catid']);
    458. 

  458. 			if(!$catid) showmessage(L('missing_part_parameters'));
    459. 

  459. 			$modelid = $this->categorys[$catid]['modelid'];
    460. 

  460. 			$this->db->set_model($modelid);
    461. 

  461. 			foreach($_POST['listorders'] as $id => $listorder) {
    462. 

  462. 				$this->db->update(array('listorder'=>$listorder),array('id'=>$id));
    463. 

  463. 			}
    464. 

  464. 			showmessage(L('operation_success'));
    465. 

  465. 		} else {
    466. 

  466. 			showmessage(L('operation_failure'));
    467. 

  467. 		}
    468. 

  468. 	}
    469. 

  469. 	/**
    470. 

  470. 	 * 显示栏目菜单列表
    471. 

  471. 	 */
    472. 

  472. 	public function public_categorys() {
    473. 

  473. 		$show_header = '';
    474. 

  474. 		$cfg = getcache('common','commons');
    475. 

  475. 		$ajax_show = intval($cfg['category_ajax']);
    476. 

  476. 		$from = isset($_GET['from']) && in_array($_GET['from'],array('block')) ? $_GET['from'] : 'content';
    477. 

  477. 		$tree = pc_base::load_sys_class('tree');
    478. 

  478. 		if($from=='content' && $_SESSION['roleid'] != 1) {	
    479. 

  479. 			$this->priv_db = pc_base::load_model('category_priv_model');
    480. 

  480. 			$priv_result = $this->priv_db->select(array('action'=>'init','roleid'=>$_SESSION['roleid'],'siteid'=>$this->siteid,'is_admin'=>1));
    481. 

  481. 			$priv_catids = array();
    482. 

  482. 			foreach($priv_result as $_v) {
    483. 

  483. 				$priv_catids[] = $_v['catid'];
    484. 

  484. 			}
    485. 

  485. 			if(empty($priv_catids)) return '';
    486. 

  486. 		}
    487. 

  487. 		$categorys = array();
    488. 

  488. 		if(!empty($this->categorys)) {
    489. 

  489. 			foreach($this->categorys as $r) {
    490. 

  490. 				if($r['siteid']!=$this->siteid ||  ($r['type']==2 && $r['child']==0)) continue;
    491. 

  491. 				if($from=='content' && $_SESSION['roleid'] != 1 && !in_array($r['catid'],$priv_catids)) {
    492. 

  492. 					$arrchildid = explode(',',$r['arrchildid']);
    493. 

  493. 					$array_intersect = array_intersect($priv_catids,$arrchildid);
    494. 

  494. 					if(empty($array_intersect)) continue;
    495. 

  495. 				}
    496. 

  496. 				if($r['type']==1 || $from=='block') {
    497. 

  497. 					if($r['type']==0) {
    498. 

  498. 						$r['vs_show'] = "<a href='?m=block&c=block_admin&a=public_visualization&menuid=".$_GET['menuid']."&catid=".$r['catid']."&type=show' target='right'>[".L('content_page')."]</a>";
    499. 

  499. 					} else {
    500. 

  500. 						$r['vs_show'] ='';
    501. 

  501. 					}
    502. 

  502. 					$r['icon_type'] = 'file';
    503. 

  503. 					$r['add_icon'] = '';
    504. 

  504. 					$r['type'] = 'add';
    505. 

  505. 				} else {
    506. 

  506. 					$r['icon_type'] = $r['vs_show'] = '';
    507. 

  507. 					$r['type'] = 'init';
    508. 

  508. 					$r['add_icon'] = "<a target='right' href='?m=content&c=content&menuid=".$_GET['menuid']."&catid=".$r['catid']."' onclick=javascript:openwinx('?m=content&c=content&a=add&menuid=".$_GET['menuid']."&catid=".$r['catid']."&hash_page=".$_SESSION['hash_page']."','')><img src='".IMG_PATH."add_content.gif' alt='".L('add')."'></a> ";
    509. 

  509. 				}
    510. 

  510. 				$categorys[$r['catid']] = $r;
    511. 

  511. 			}
    512. 

  512. 		}
    513. 

  513. 		if(!empty($categorys)) {
    514. 

  514. 			$tree->init($categorys);
    515. 

  515. 				switch($from) {
    516. 

  516. 					case 'block':
    517. 

  517. 						$strs = "<span class='\$icon_type'>\$add_icon<a href='?m=block&c=block_admin&a=public_visualization&menuid=".$_GET['menuid']."&catid=\$catid&type=list' target='right'>\$catname</a> \$vs_show</span>";
    518. 

  518. 						$strs2 = "<img src='".IMG_PATH."folder.gif'> <a href='?m=block&c=block_admin&a=public_visualization&menuid=".$_GET['menuid']."&catid=\$catid&type=category' target='right'>\$catname</a>";
    519. 

  519. 					break;
    520. 

  520. 

  521. 					default:
    522. 

  522. 						$strs = "<span class='\$icon_type'>\$add_icon<a href='?m=content&c=content&a=\$type&menuid=".$_GET['menuid']."&catid=\$catid' target='right' onclick='open_list(this)'>\$catname</a></span>";
    523. 

  523. 						$strs2 = "<span class='folder'>\$catname</span>";
    524. 

  524. 						break;
    525. 

  525. 				}
    526. 

  526. 			$categorys = $tree->get_treeview(0,'category_tree',$strs,$strs2,$ajax_show);
    527. 

  527. 		} else {
    528. 

  528. 			$categorys = L('please_add_category');
    529. 

  529. 		}
    530. 

  530.         include $this->admin_tpl('category_tree');
    531. 

  531. 		exit;
    532. 

  532. 	}
    533. 

  533. 	/**
    534. 

  534. 	 * 检查标题是否存在
    535. 

  535. 	 */
    536. 

  536. 	public function public_check_title() {
    537. 

  537. 		if($_GET['data']=='' || (!$_GET['catid'])) return '';
    538. 

  538. 		$catid = intval($_GET['catid']);
    539. 

  539. 		$modelid = $this->categorys[$catid]['modelid'];
    540. 

  540. 		$this->db->set_model($modelid);
    541. 

  541. 		$title = $_GET['data'];
    542. 

  542. 		if(CHARSET=='gbk') $title = iconv('utf-8','gbk',$title);
    543. 

  543. 		$r = $this->db->get_one(array('title'=>$title));
    544. 

  544. 		if($r) {
    545. 

  545. 			exit('1');
    546. 

  546. 		} else {
    547. 

  547. 			exit('0');
    548. 

  548. 		}
    549. 

  549. 	}
    550. 

  550. 

  551. 	/**
    552. 

  552. 	 * 修改某一字段数据
    553. 

  553. 	 */
    554. 

  554. 	public function update_param() {
    555. 

  555. 		$id = intval($_GET['id']);
    556. 

  556. 		$field = $_GET['field'];
    557. 

  557. 		$modelid = intval($_GET['modelid']);
    558. 

  558. 		$value = $_GET['value'];
    559. 

  559. 		if (CHARSET!='utf-8') {
    560. 

  560. 			$value = iconv('utf-8', 'gbk', $value);
    561. 

  561. 		}
    562. 

  562. 		//检查字段是否存在
    563. 

  563. 		$this->db->set_model($modelid);
    564. 

  564. 		if ($this->db->field_exists($field)) {
    565. 

  565. 			$this->db->update(array($field=>$value), array('id'=>$id));
    566. 

  566. 			exit('200');
    567. 

  567. 		} else {
    568. 

  568. 			$this->db->table_name = $this->db->table_name.'_data';
    569. 

  569. 			if ($this->db->field_exists($field)) {
    570. 

  570. 				$this->db->update(array($field=>$value), array('id'=>$id));
    571. 

  571. 				exit('200');
    572. 

  572. 			} else {
    573. 

  573. 				exit('300');
    574. 

  574. 			}
    575. 

  575. 		}
    576. 

  576. 	}
    577. 

  577. 	
    578. 

  578. 	/**
    579. 

  579. 	 * 图片裁切
    580. 

  580. 	 */
    581. 

  581. 	public function public_crop() {
    582. 

  582. 		if (isset($_GET['picurl']) && !empty($_GET['picurl'])) {
    583. 

  583. 			$picurl = $_GET['picurl'];
    584. 

  584. 			$catid = intval($_GET['catid']);
    585. 

  585. 			if (isset($_GET['module']) && !empty($_GET['module'])) {
    586. 

  586. 				$module = $_GET['module'];
    587. 

  587. 			}
    588. 

  588. 			$show_header =  '';
    589. 

  589. 			include $this->admin_tpl('crop');
    590. 

  590. 		}
    591. 

  591. 	}
    592. 

  592. 	/**
    593. 

  593. 	 * 相关文章选择
    594. 

  594. 	 */
    595. 

  595. 	public function public_relationlist() {
    596. 

  596. 		pc_base::load_sys_class('format','',0);
    597. 

  597. 		$show_header = '';
    598. 

  598. 		$model_cache = getcache('model','commons');
    599. 

  599. 		if(!isset($_GET['modelid'])) {
    600. 

  600. 			showmessage(L('please_select_modelid'));
    601. 

  601. 		} else {
    602. 

  602. 			$page = intval($_GET['page']);
    603. 

  603. 			
    604. 

  604. 			$modelid = intval($_GET['modelid']);
    605. 

  605. 			$this->db->set_model($modelid);
    606. 

  606. 			$where = '';
    607. 

  607. 			if($_GET['catid']) {
    608. 

  608. 				$catid = intval($_GET['catid']);
    609. 

  609. 				$where .= "catid='$catid'";
    610. 

  610. 			}
    611. 

  611. 			$where .= $where ?  ' AND status=99' : 'status=99';
    612. 

  612. 			
    613. 

  613. 			if(isset($_GET['keywords'])) {
    614. 

  614. 				$keywords = trim($_GET['keywords']);
    615. 

  615. 				$field = $_GET['field'];
    616. 

  616. 				if(in_array($field, array('id','title','keywords','description'))) {
    617. 

  617. 					if($field=='id') {
    618. 

  618. 						$where .= " AND `id` ='$keywords'";
    619. 

  619. 					} else {
    620. 

  620. 						$where .= " AND `$field` like '%$keywords%'";
    621. 

  621. 					}
    622. 

  622. 				}
    623. 

  623. 			}
    624. 

  624. 			$infos = $this->db->listinfo($where,'',$page,12);
    625. 

  625. 			$pages = $this->db->pages;
    626. 

  626. 			include $this->admin_tpl('relationlist');
    627. 

  627. 		}
    628. 

  628. 	}
    629. 

  629. 	public function public_getjson_ids() {
    630. 

  630. 		$modelid = intval($_GET['modelid']);
    631. 

  631. 		$id = intval($_GET['id']);
    632. 

  632. 		$this->db->set_model($modelid);
    633. 

  633. 		$tablename = $this->db->table_name;
    634. 

  634. 		$this->db->table_name = $tablename.'_data';
    635. 

  635. 		$r = $this->db->get_one(array('id'=>$id),'relation');
    636. 

  636. 

  637. 		if($r['relation']) {
    638. 

  638. 			$relation = str_replace('|', ',', $r['relation']);
    639. 

  639. 			$relation = trim($relation,',');
    640. 

  640. 			$where = "id IN($relation)";
    641. 

  641. 			$infos = array();
    642. 

  642. 			$this->db->table_name = $tablename;
    643. 

  643. 			$datas = $this->db->select($where,'id,title');
    644. 

  644. 			foreach($datas as $_v) {
    645. 

  645. 				$_v['sid'] = 'v'.$_v['id'];
    646. 

  646. 				if(strtolower(CHARSET)=='gbk') $_v['title'] = iconv('gbk', 'utf-8', $_v['title']);
    647. 

  647. 				$infos[] = $_v;
    648. 

  648. 			}
    649. 

  649. 			echo json_encode($infos);
    650. 

  650. 		}
    651. 

  651. 	}
    652. 

  652. 

  653. 	//文章预览
    654. 

  654. 	public function public_preview() {
    655. 

  655. 		$catid = intval($_GET['catid']);
    656. 

  656. 		$id = intval($_GET['id']);
    657. 

  657. 		
    658. 

  658. 		if(!$catid || !$id) showmessage(L('missing_part_parameters'),'blank');
    659. 

  659. 		$page = intval($_GET['page']);
    660. 

  660. 		$page = max($page,1);
    661. 

  661. 		$CATEGORYS = getcache('category_content_'.$this->get_siteid(),'commons');
    662. 

  662. 		
    663. 

  663. 		if(!isset($CATEGORYS[$catid]) || $CATEGORYS[$catid]['type']!=0) showmessage(L('missing_part_parameters'),'blank');
    664. 

  664. 		define('HTML', true);
    665. 

  665. 		$CAT = $CATEGORYS[$catid];
    666. 

  666. 		
    667. 

  667. 		$siteid = $CAT['siteid'];
    668. 

  668. 		$MODEL = getcache('model','commons');
    669. 

  669. 		$modelid = $CAT['modelid'];
    670. 

  670. 

  671. 		$this->db->table_name = $this->db->db_tablepre.$MODEL[$modelid]['tablename'];
    672. 

  672. 		$r = $this->db->get_one(array('id'=>$id));
    673. 

  673. 		if(!$r) showmessage(L('information_does_not_exist'));
    674. 

  674. 		$this->db->table_name = $this->db->table_name.'_data';
    675. 

  675. 		$r2 = $this->db->get_one(array('id'=>$id));
    676. 

  676. 		$rs = $r2 ? array_merge($r,$r2) : $r;
    677. 

  677. 

  678. 		//再次重新赋值，以数据库为准
    679. 

  679. 		$catid = $CATEGORYS[$r['catid']]['catid'];
    680. 

  680. 		$modelid = $CATEGORYS[$catid]['modelid'];
    681. 

  681. 		
    682. 

  682. 		require_once CACHE_MODEL_PATH.'content_output.class.php';
    683. 

  683. 		$content_output = new content_output($modelid,$catid,$CATEGORYS);
    684. 

  684. 		$data = $content_output->get($rs);
    685. 

  685. 		extract($data);
    686. 

  686. 		$CAT['setting'] = string2array($CAT['setting']);
    687. 

  687. 		$template = $template ? $template : $CAT['setting']['show_template'];
    688. 

  688. 		$allow_visitor = 1;
    689. 

  689. 		//SEO
    690. 

  690. 		$SEO = seo($siteid, $catid, $title, $description);
    691. 

  691. 		
    692. 

  692. 		define('STYLE',$CAT['setting']['template_list']);
    693. 

  693. 		if(isset($rs['paginationtype'])) {
    694. 

  694. 			$paginationtype = $rs['paginationtype'];
    695. 

  695. 			$maxcharperpage = $rs['maxcharperpage'];
    696. 

  696. 		}
    697. 

  697. 		$pages = $titles = '';
    698. 

  698. 		if($rs['paginationtype']==1) {
    699. 

  699. 			//自动分页
    700. 

  700. 			if($maxcharperpage < 10) $maxcharperpage = 500;
    701. 

  701. 			$contentpage = pc_base::load_app_class('contentpage');
    702. 

  702. 			$content = $contentpage->get_data($content,$maxcharperpage);
    703. 

  703. 		}
    704. 

  704. 		if($rs['paginationtype']!=0) {
    705. 

  705. 			//手动分页
    706. 

  706. 			$CONTENT_POS = strpos($content, '[page]');
    707. 

  707. 			if($CONTENT_POS !== false) {
    708. 

  708. 				$this->url = pc_base::load_app_class('url', 'content');
    709. 

  709. 				$contents = array_filter(explode('[page]', $content));
    710. 

  710. 				$pagenumber = count($contents);
    711. 

  711. 				for($i=1; $i<=$pagenumber; $i++) {
    712. 

  712. 					$pageurls[$i] = $this->url->show($id, $i, $catid, $rs['inputtime']);
    713. 

  713. 				}
    714. 

  714. 				$END_POS = strpos($content, '[/page]');
    715. 

  715. 				if($END_POS !== false) {
    716. 

  716. 					if(preg_match_all("|\[page\](.*)\[/page\]|U", $content, $m, PREG_PATTERN_ORDER)) {
    717. 

  717. 						foreach($m[1] as $k=>$v) {
    718. 

  718. 							$p = $k+1;
    719. 

  719. 							$titles[$p]['title'] = strip_tags($v);
    720. 

  720. 							$titles[$p]['url'] = $pageurls[$p][0];
    721. 

  721. 						}
    722. 

  722. 					}
    723. 

  723. 				} else {
    724. 

  724. 					//当不存在 [/page]时，则使用下面分页
    725. 

  725. 					$pages = content_pages($pagenumber,$page, $pageurls);
    726. 

  726. 				}
    727. 

  727. 				//判断[page]出现的位置是否在第一位 
    728. 

  728. 				if($CONTENT_POS<7) {
    729. 

  729. 					$content = $contents[$page];
    730. 

  730. 				} else {
    731. 

  731. 					$content = $contents[$page-1];
    732. 

  732. 				}
    733. 

  733. 				if($titles) {
    734. 

  734. 					list($title, $content) = explode('[/page]', $content);
    735. 

  735. 					$content = trim($content);
    736. 

  736. 					if(strpos($content,'</p>')===0) {
    737. 

  737. 						$content = '<p>'.$content;
    738. 

  738. 					}
    739. 

  739. 					if(stripos($content,'<p>')===0) {
    740. 

  740. 						$content = $content.'</p>';
    741. 

  741. 					}
    742. 

  742. 				}
    743. 

  743. 			}
    744. 

  744. 		}
    745. 

  745. 		include template('content',$template);
    746. 

  746. 		$pc_hash = $_SESSION['pc_hash'];
    747. 

  747. 		$steps = intval($_GET['steps']);
    748. 

  748. 		echo "
    749. 

  749. 		<link href=\"".CSS_PATH."dialog_simp.css\" rel=\"stylesheet\" type=\"text/css\" />
    750. 

  750. 		<script language=\"javascript\" type=\"text/javascript\" src=\"".JS_PATH."dialog.js\"></script>
    751. 

  751. 		<script type=\"text/javascript\">art.dialog({lock:false,title:'".L('operations_manage')."',mouse:true, id:'content_m', content:'<span id=cloading ><a href=\'javascript:ajax_manage(1)\'>".L('passed_checked')."</a> | <a href=\'javascript:ajax_manage(2)\'>".L('reject')."</a> |　<a href=\'javascript:ajax_manage(3)\'>".L('delete')."</a></span>',left:'100%',top:'100%',width:200,height:50,drag:true, fixed:true});
    752. 

  752. 		function ajax_manage(type) {
    753. 

  753. 			if(type==1) {
    754. 

  754. 				$.get('?m=content&c=content&a=pass&ajax_preview=1&catid=".$catid."&steps=".$steps."&id=".$id."&pc_hash=".$pc_hash."');
    755. 

  755. 			} else if(type==2) {
    756. 

  756. 				$.get('?m=content&c=content&a=pass&ajax_preview=1&reject=1&catid=".$catid."&steps=".$steps."&id=".$id."&pc_hash=".$pc_hash."');
    757. 

  757. 			} else if(type==3) {
    758. 

  758. 				$.get('?m=content&c=content&a=delete&ajax_preview=1&dosubmit=1&catid=".$catid."&steps=".$steps."&id=".$id."&pc_hash=".$pc_hash."');
    759. 

  759. 			}
    760. 

  760. 			$('#cloading').html('<font color=red>".L('operation_success')."<span id=\"secondid\">2</span>".L('after_a_few_seconds_left')."</font>');
    761. 

  761. 			setInterval('set_time()', 1000);
    762. 

  762. 			setInterval('window.close()', 2000);
    763. 

  763. 		}
    764. 

  764. 		function set_time() {
    765. 

  765. 			$('#secondid').html(1);
    766. 

  766. 		}
    767. 

  767. 		</script>";
    768. 

  768. 	}
    769. 

  769. 

  770. 	/**
    771. 

  771. 	 * 审核所有内容
    772. 

  772. 	 */
    773. 

  773. 	public function public_checkall() {
    774. 

  774. 		$page = isset($_GET['page']) && intval($_GET['page']) ? intval($_GET['page']) : 1;
    775. 

  775. 		
    776. 

  776. 		$show_header = '';
    777. 

  777. 		$workflows = getcache('workflow_'.$this->siteid,'commons');
    778. 

  778. 		$datas = array();
    779. 

  779. 		$pagesize = 20;
    780. 

  780. 		$sql = '';
    781. 

  781. 		if (in_array($_SESSION['roleid'], array('1'))) {
    782. 

  782. 			$super_admin = 1;
    783. 

  783. 			$status = isset($_GET['status']) ? $_GET['status'] : -1;
    784. 

  784. 		} else {
    785. 

  785. 			$super_admin = 0;
    786. 

  786. 			$status = isset($_GET['status']) ? $_GET['status'] : 1;
    787. 

  787. 			if($status==-1) $status = 1;
    788. 

  788. 		}
    789. 

  789. 		if($status>4) $status = 4;
    790. 

  790. 		$this->priv_db = pc_base::load_model('category_priv_model');;
    791. 

  791. 		$admin_username = param::get_cookie('admin_username');
    792. 

  792. 		if($status==-1) {
    793. 

  793. 			$sql = "`status` NOT IN (99,0,-2) AND `siteid`=$this->siteid";
    794. 

  794. 		} else {
    795. 

  795. 			$sql = "`status` = '$status' AND `siteid`=$this->siteid";
    796. 

  796. 		}
    797. 

  797. 		if($status!=0 && !$super_admin) {
    798. 

  798. 			//以栏目进行循环
    799. 

  799. 			foreach ($this->categorys as $catid => $cat) {
    800. 

  800. 				if($cat['type']!=0) continue;
    801. 

  801. 				//查看管理员是否有这个栏目的查看权限。
    802. 

  802. 				if (!$this->priv_db->get_one(array('catid'=>$catid, 'siteid'=>$this->siteid, 'roleid'=>$_SESSION['roleid'], 'is_admin'=>'1'))) {
    803. 

  803. 					continue;
    804. 

  804. 				}
    805. 

  805. 				//如果栏目有设置工作流，进行权限检查。
    806. 

  806. 				$workflow = array();
    807. 

  807. 				$cat['setting'] = string2array($cat['setting']);
    808. 

  808. 				if (isset($cat['setting']['workflowid']) && !empty($cat['setting']['workflowid'])) {
    809. 

  809. 					$workflow = $workflows[$cat['setting']['workflowid']];
    810. 

  810. 					$workflow['setting'] = string2array($workflow['setting']);
    811. 

  811. 					$usernames = $workflow['setting'][$status];
    812. 

  812. 					if (empty($usernames) || !in_array($admin_username, $usernames)) {//判断当前管理，在工作流中可以审核几审
    813. 

  813. 						continue;
    814. 

  814. 					}
    815. 

  815. 				}
    816. 

  816. 				$priv_catid[] = $catid;
    817. 

  817. 			}
    818. 

  818. 			if(empty($priv_catid)) {
    819. 

  819. 				$sql .= " AND catid = -1";
    820. 

  820. 			} else {
    821. 

  821. 				$priv_catid = implode(',', $priv_catid);
    822. 

  822. 				$sql .= " AND catid IN ($priv_catid)";
    823. 

  823. 			}
    824. 

  824. 		}
    825. 

  825. 		$this->content_check_db = pc_base::load_model('content_check_model');
    826. 

  826. 		$datas = $this->content_check_db->listinfo($sql,'inputtime DESC',$page);		
    827. 

  827. 		$pages = $this->content_check_db->pages;
    828. 

  828. 		include $this->admin_tpl('content_checkall');
    829. 

  829. 	}
    830. 

  830. 	
    831. 

  831. 	/**
    832. 

  832. 	 * 批量移动文章
    833. 

  833. 	 */
    834. 

  834. 	public function remove() {
    835. 

  835. 		if(isset($_POST['dosubmit'])) {
    836. 

  836. 			$this->content_check_db = pc_base::load_model('content_check_model');
    837. 

  837. 			if($_POST['fromtype']==0) {
    838. 

  838. 				if($_POST['ids']=='') showmessage(L('please_input_move_source'));
    839. 

  839. 				if(!$_POST['tocatid']) showmessage(L('please_select_target_category'));
    840. 

  840. 				$tocatid = intval($_POST['tocatid']);
    841. 

  841. 				$modelid = $this->categorys[$tocatid]['modelid'];
    842. 

  842. 				if(!$modelid) showmessage(L('illegal_operation'));
    843. 

  843. 				$ids = array_filter(explode(',', $_POST['ids']),"intval");
    844. 

  844. 				foreach ($ids as $id) {
    845. 

  845. 					$checkid = 'c-'.$id.'-'.$this->siteid;
    846. 

  846. 					$this->content_check_db->update(array('catid'=>$tocatid), array('checkid'=>$checkid));
    847. 

  847. 				}
    848. 

  848. 				$ids = implode(',', $ids);
    849. 

  849. 				$this->db->set_model($modelid);
    850. 

  850. 				$this->db->update(array('catid'=>$tocatid),"id IN($ids)");
    851. 

  851. 			} else {
    852. 

  852. 				if(!$_POST['fromid']) showmessage(L('please_input_move_source'));
    853. 

  853. 				if(!$_POST['tocatid']) showmessage(L('please_select_target_category'));
    854. 

  854. 				$tocatid = intval($_POST['tocatid']);
    855. 

  855. 				$modelid = $this->categorys[$tocatid]['modelid'];
    856. 

  856. 				if(!$modelid) showmessage(L('illegal_operation'));
    857. 

  857. 				$fromid = array_filter($_POST['fromid'],"intval");
    858. 

  858. 				$fromid = implode(',', $fromid);
    859. 

  859. 				$this->db->set_model($modelid);
    860. 

  860. 				$this->db->update(array('catid'=>$tocatid),"catid IN($fromid)");
    861. 

  861. 			}
    862. 

  862. 			showmessage(L('operation_success'),HTTP_REFERER);
    863. 

  863. 			//ids
    864. 

  864. 		} else {
    865. 

  865. 			$show_header = '';
    866. 

  866. 			$catid = intval($_GET['catid']);
    867. 

  867. 			$modelid = $this->categorys[$catid]['modelid'];
    868. 

  868. 			$tree = pc_base::load_sys_class('tree');
    869. 

  869. 			$tree->icon = array('&nbsp;&nbsp;│ ','&nbsp;&nbsp;├─ ','&nbsp;&nbsp;└─ ');
    870. 

  870. 			$tree->nbsp = '&nbsp;&nbsp;';
    871. 

  871. 			$categorys = array();
    872. 

  872. 			foreach($this->categorys as $cid=>$r) {
    873. 

  873. 				if($this->siteid != $r['siteid'] || $r['type']) continue;
    874. 

  874. 				if($modelid && $modelid != $r['modelid']) continue;
    875. 

  875. 				$r['disabled'] = $r['child'] ? 'disabled' : '';
    876. 

  876. 				$r['selected'] = $cid == $catid ? 'selected' : '';
    877. 

  877. 				$categorys[$cid] = $r;
    878. 

  878. 			}
    879. 

  879. 			$str  = "<option value='\$catid' \$selected \$disabled>\$spacer \$catname</option>";
    880. 

  880. 

  881. 			$tree->init($categorys);
    882. 

  882. 			$string .= $tree->get_tree(0, $str);
    883. 

  883.  			$str  = "<option value='\$catid'>\$spacer \$catname</option>";
    884. 

  884. 			$source_string = '';
    885. 

  885. 			$tree->init($categorys);
    886. 

  886. 			$source_string .= $tree->get_tree(0, $str);
    887. 

  887. 			$ids = empty($_POST['ids']) ? '' : implode(',',$_POST['ids']);
    888. 

  888. 			include $this->admin_tpl('content_remove');
    889. 

  889. 		}
    890. 

  890. 	}
    891. 

  891. 	
    892. 

  892. 	/**
    893. 

  893. 	 * 同时发布到其他栏目
    894. 

  894. 	 */
    895. 

  895. 	public function add_othors() {
    896. 

  896. 		$show_header = '';
    897. 

  897. 		$sitelist = getcache('sitelist','commons');
    898. 

  898. 		$siteid = $_GET['siteid'];
    899. 

  899. 		include $this->admin_tpl('add_othors');
    900. 

  900. 		
    901. 

  901. 	}
    902. 

  902. 	/**
    903. 

  903. 	 * 同时发布到其他栏目 异步加载栏目
    904. 

  904. 	 */
    905. 

  905. 	public function public_getsite_categorys() {
    906. 

  906. 		$siteid = intval($_GET['siteid']);
    907. 

  907. 		$this->categorys = getcache('category_content_'.$siteid,'commons');
    908. 

  908. 		$models = getcache('model','commons');
    909. 

  909. 		$tree = pc_base::load_sys_class('tree');
    910. 

  910. 		$tree->icon = array('&nbsp;&nbsp;&nbsp;│ ','&nbsp;&nbsp;&nbsp;├─ ','&nbsp;&nbsp;&nbsp;└─ ');
    911. 

  911. 		$tree->nbsp = '&nbsp;&nbsp;&nbsp;';
    912. 

  912. 		$categorys = array();
    913. 

  913. 		if($_SESSION['roleid'] != 1) {
    914. 

  914. 			$this->priv_db = pc_base::load_model('category_priv_model');
    915. 

  915. 			$priv_result = $this->priv_db->select(array('action'=>'add','roleid'=>$_SESSION['roleid'],'siteid'=>$siteid,'is_admin'=>1));
    916. 

  916. 			$priv_catids = array();
    917. 

  917. 			foreach($priv_result as $_v) {
    918. 

  918. 				$priv_catids[] = $_v['catid'];
    919. 

  919. 			}
    920. 

  920. 			if(empty($priv_catids)) return '';
    921. 

  921. 		}
    922. 

  922. 		
    923. 

  923. 		foreach($this->categorys as $r) {
    924. 

  924. 			if($r['siteid']!=$siteid || $r['type']!=0) continue;
    925. 

  925. 			if($_SESSION['roleid'] != 1 && !in_array($r['catid'],$priv_catids)) {
    926. 

  926. 				$arrchildid = explode(',',$r['arrchildid']);
    927. 

  927. 				$array_intersect = array_intersect($priv_catids,$arrchildid);
    928. 

  928. 				if(empty($array_intersect)) continue;
    929. 

  929. 			}
    930. 

  930. 			$r['modelname'] = $models[$r['modelid']]['name'];
    931. 

  931. 			$r['style'] = $r['child'] ? 'color:#8A8A8A;' : '';
    932. 

  932. 			$r['click'] = $r['child'] ? '' : "onclick=\"select_list(this,'".safe_replace($r['catname'])."',".$r['catid'].")\" class='cu' title='".L('click_to_select')."'";
    933. 

  933. 			$categorys[$r['catid']] = $r;
    934. 

  934. 		}
    935. 

  935. 		$str  = "<tr \$click >
    936. 

  936. 					<td align='center'>\$id</td>
    937. 

  937. 					<td style='\$style'>\$spacer\$catname</td>
    938. 

  938. 					<td align='center'>\$modelname</td>
    939. 

  939. 				</tr>";
    940. 

  940. 		$tree->init($categorys);
    941. 

  941. 		$categorys = $tree->get_tree(0, $str);
    942. 

  942. 		echo $categorys;
    943. 

  943. 	}
    944. 

  944. 	
    945. 

  945. 	public function public_sub_categorys() {
    946. 

  946. 		$cfg = getcache('common','commons');
    947. 

  947. 		$ajax_show = intval(abs($cfg['category_ajax']));	
    948. 

  948. 		$catid = intval($_POST['root']);
    949. 

  949. 		$modelid = intval($_POST['modelid']);
    950. 

  950. 		$this->categorys = getcache('category_content_'.$this->siteid,'commons');
    951. 

  951. 		$tree = pc_base::load_sys_class('tree');
    952. 

  952. 		if(!empty($this->categorys)) {
    953. 

  953. 			foreach($this->categorys as $r) {
    954. 

  954. 				if($r['siteid']!=$this->siteid ||  ($r['type']==2 && $r['child']==0)) continue;
    955. 

  955. 				if($from=='content' && $_SESSION['roleid'] != 1 && !in_array($r['catid'],$priv_catids)) {
    956. 

  956. 					$arrchildid = explode(',',$r['arrchildid']);
    957. 

  957. 					$array_intersect = array_intersect($priv_catids,$arrchildid);
    958. 

  958. 					if(empty($array_intersect)) continue;
    959. 

  959. 				}
    960. 

  960. 				if($r['type']==1 || $from=='block') {
    961. 

  961. 					if($r['type']==0) {
    962. 

  962. 						$r['vs_show'] = "<a href='?m=block&c=block_admin&a=public_visualization&menuid=".$_GET['menuid']."&catid=".$r['catid']."&type=show' target='right'>[".L('content_page')."]</a>";
    963. 

  963. 					} else {
    964. 

  964. 						$r['vs_show'] ='';
    965. 

  965. 					}
    966. 

  966. 					$r['icon_type'] = 'file';
    967. 

  967. 					$r['add_icon'] = '';
    968. 

  968. 					$r['type'] = 'add';
    969. 

  969. 				} else {
    970. 

  970. 					$r['icon_type'] = $r['vs_show'] = '';
    971. 

  971. 					$r['type'] = 'init';
    972. 

  972. 					$r['add_icon'] = "<a target='right' href='?m=content&c=content&menuid=".$_GET['menuid']."&catid=".$r['catid']."' onclick=javascript:openwinx('?m=content&c=content&a=add&menuid=".$_GET['menuid']."&catid=".$r['catid']."&hash_page=".$_SESSION['hash_page']."','')><img src='".IMG_PATH."add_content.gif' alt='".L('add')."'></a> ";
    973. 

  973. 				}
    974. 

  974. 				$categorys[$r['catid']] = $r;
    975. 

  975. 			}
    976. 

  976. 		}
    977. 

  977. 		if(!empty($categorys)) {
    978. 

  978. 			$tree->init($categorys);
    979. 

  979. 				switch($from) {
    980. 

  980. 					case 'block':
    981. 

  981. 						$strs = "<span class='\$icon_type'>\$add_icon<a href='?m=block&c=block_admin&a=public_visualization&menuid=".$_GET['menuid']."&catid=\$catid&type=list&pc_hash=".$_SESSION['pc_hash']."' target='right'>\$catname</a> \$vs_show</span>";
    982. 

  982. 					break;
    983. 

  983. 

  984. 					default:
    985. 

  985. 						$strs = "<span class='\$icon_type'>\$add_icon<a href='?m=content&c=content&a=\$type&menuid=".$_GET['menuid']."&catid=\$catid&pc_hash=".$_SESSION['pc_hash']."' target='right' onclick='open_list(this)'>\$catname</a></span>";
    986. 

  986. 						break;
    987. 

  987. 				}
    988. 

  988. 			$data = $tree->creat_sub_json($catid,$strs);
    989. 

  989. 		}		
    990. 

  990. 		echo $data;
    991. 

  991. 	}
    992. 

  992. 

  993. 	/**
    994. 

  994. 	 * 一键清理演示数据
    995. 

  995. 	 */
    996. 

  996. 	public function clear_data() {
    997. 

  997. 		//清理数据涉及到的数据表
    998. 

  998. 		
    999. 

  999. 		if ($_POST['dosubmit']) {
    1000. 

  1000. 			set_time_limit(0);
    1001. 

  1001. 			$models = array('category', 'content', 'hits', 'search', 'position_data', 'video_content', 'video_store', 'comment');
    1002. 

  1002. 			$tables = $_POST['tables'];
    1003. 

  1003. 			if (is_array($tables)) {
    1004. 

  1004. 				foreach ($tables as $t) {
    1005. 

  1005. 					if (in_array($t, $models)) {
    1006. 

  1006. 						if ($t=='content') {
    1007. 

  1007. 							$model = $_POST['model'];
    1008. 

  1008. 							$db = pc_base::load_model('content_model');
    1009. 

  1009. 							//读取网站的所有模型
    1010. 

  1010. 							$model_arr = getcache('model', 'commons');
    1011. 

  1011. 							foreach ($model as $modelid) {
    1012. 

  1012. 								$db->set_model($modelid);
    1013. 

  1013. 								if ($r = $db->count()) { //判断模型下是否有数据
    1014. 

  1014. 									$sql_file = CACHE_PATH.'bakup'.DIRECTORY_SEPARATOR.'default'.DIRECTORY_SEPARATOR.$model_arr[$modelid]['tablename'].'.sql';
    1015. 

  1015. 									$result = $data = $db->select();
    1016. 

  1016. 									$this->create_sql_file($result, $db->db_tablepre.$model_arr[$modelid]['tablename'], $sql_file);
    1017. 

  1017. 									$db->query('TRUNCATE TABLE `phpcms_'.$model_arr[$modelid]['tablename'].'`');
    1018. 

  1018. 									//开始清理模型data表数据
    1019. 

  1019. 									$db->table_name = $db->table_name.'_data';
    1020. 

  1020. 									$sql_file = CACHE_PATH.'bakup'.DIRECTORY_SEPARATOR.'default'.DIRECTORY_SEPARATOR.$model_arr[$modelid]['tablename'].'_data.sql';
    1021. 

  1021. 									$result = $db->select();
    1022. 

  1022. 									$this->create_sql_file($result, $db->db_tablepre.$model_arr[$modelid]['tablename'].'_data', $sql_file);
    1023. 

  1023. 									$db->query('TRUNCATE TABLE `phpcms_'.$model_arr[$modelid]['tablename'].'_data`');
    1024. 

  1024. 									//删除该模型中在hits表的数据
    1025. 

  1025. 									$hits_db = pc_base::load_model('hits_model');
    1026. 

  1026. 									$hitsid = 'c-'.$modelid.'-';
    1027. 

  1027. 									$result = $hits_db->select("`hitsid` LIKE '%$hitsid%'");
    1028. 

  1028. 									if (is_array($result)) {
    1029. 

  1029. 										$sql_file = CACHE_PATH.'bakup'.DIRECTORY_SEPARATOR.'default'.DIRECTORY_SEPARATOR.'hits-'.$modelid.'.sql';
    1030. 

  1030. 										$this->create_sql_file($result, $hits_db->db_tablepre.'hits', $sql_file);
    1031. 

  1031. 									}
    1032. 

  1032. 									$hits_db->delete("`hitsid` LIKE '%$hitsid%'");
    1033. 

  1033. 									//删除该模型在search中的数据
    1034. 

  1034. 									$search_db = pc_base::load_model('search_model');
    1035. 

  1035. 									$type_model = getcache('type_model_'.$model_arr[$modelid]['siteid'], 'search');
    1036. 

  1036. 									$typeid = $type_model[$modelid];
    1037. 

  1037. 									$result = $search_db->select("`typeid`=".$typeid);
    1038. 

  1038. 									if (is_array($result)) {
    1039. 

  1039. 										$sql_file = CACHE_PATH.'bakup'.DIRECTORY_SEPARATOR.'default'.DIRECTORY_SEPARATOR.'search-'.$modelid.'.sql';
    1040. 

  1040. 										$this->create_sql_file($result, $search_db->db_tablepre.'search', $sql_file);
    1041. 

  1041. 									}
    1042. 

  1042. 									$search_db->delete("`typeid`=".$typeid);
    1043. 

  1043. 									//Delete the model data in the position table
    1044. 

  1044. 									$position_db = pc_base::load_model('position_data_model');
    1045. 

  1045. 									$result = $position_db->select('`modelid`='.$modelid.' AND `module`=\'content\'');
    1046. 

  1046. 									if (is_array($result)) {
    1047. 

  1047. 										$sql_file = CACHE_PATH.'bakup'.DIRECTORY_SEPARATOR.'default'.DIRECTORY_SEPARATOR.'position_data-'.$modelid.'.sql';
    1048. 

  1048. 										$this->create_sql_file($result, $position_db->db_tablepre.'position_data', $sql_file);
    1049. 

  1049. 									}
    1050. 

  1050. 									$position_db->delete('`modelid`='.$modelid.' AND `module`=\'content\'');
    1051. 

  1051. 									//清理视频库与内容对应关系表
    1052. 

  1052. 									if (module_exists('video')) {
    1053. 

  1053. 										$video_content_db = pc_base::load_model('video_content_model');
    1054. 

  1054. 										$result = $video_content_db->select('`modelid`=\''.$modelid.'\'');
    1055. 

  1055. 										if (is_array($result)) {
    1056. 

  1056. 											$sql_file = CACHE_PATH.'bakup'.DIRECTORY_SEPARATOR.'default'.DIRECTORY_SEPARATOR.'video_content-'.$modelid.'.sql';
    1057. 

  1057. 											$this->create_sql_file($result, $video_content_db->db_tablepre.'video_content', $sql_file);
    1058. 

  1058. 										}
    1059. 

  1059. 										$video_content_db->delete('`modelid`=\''.$modelid.'\'');
    1060. 

  1060. 									}
    1061. 

  1061. 									//清理评论表及附件表，附件的清理为不可逆操作。
    1062. 

  1062. 									//附件初始化
    1063. 

  1063. 									//$attachment = pc_base::load_model('attachment_model');
    1064. 

  1064. 									//$comment = pc_base::load_app_class('comment', 'comment');
    1065. 

  1065. 									//if(module_exists('comment')){
    1066. 

  1066. 										//$comment_exists = 1;
    1067. 

  1067. 									//}
    1068. 

  1068. 									//foreach ($data as $d) {
    1069. 

  1069. 										//$attachment->api_delete('c-'.$d['catid'].'-'.$d['id']);
    1070. 

  1070. 										//if ($comment_exists) {
    1071. 

  1071. 											//$commentid = id_encode('content_'.$d['catid'], $d['id'], $model_arr[$modelid]['siteid']);
    1072. 

  1072. 											//$comment->del($commentid, $model_arr[$modelid]['siteid'], $d['id'], $d['catid']);
    1073. 

  1073. 										//}
    1074. 

  1074. 									//}
    1075. 

  1075. 								}
    1076. 

  1076. 							}
    1077. 

  1077. 							
    1078. 

  1078. 						} elseif ($t=='comment') {
    1079. 

  1079. 							$comment_db = pc_base::load_model('comment_data_model');
    1080. 

  1080. 							for($i=1;;$i++) {
    1081. 

  1081. 								$comment_db->table_name($i);
    1082. 

  1082. 								if ($comment_db->table_exists(str_replace($comment_db->db_tablepre, '', $comment_db->table_name))) {
    1083. 

  1083. 									if ($r = $comment_db->count()) {
    1084. 

  1084. 										$sql_file = CACHE_PATH.'bakup'.DIRECTORY_SEPARATOR.'default'.DIRECTORY_SEPARATOR.'comment_data_'.$i.'.sql';
    1085. 

  1085. 										$result = $comment_db->select();
    1086. 

  1086. 										$this->create_sql_file($result, $comment_db->db_tablepre.'comment_data_'.$i, $sql_file);
    1087. 

  1087. 										$comment_db->query('TRUNCATE TABLE `phpcms_comment_data_'.$i.'`');
    1088. 

  1088. 									}
    1089. 

  1089. 								} else {
    1090. 

  1090. 									break;
    1091. 

  1091. 								}
    1092. 

  1092. 							}
    1093. 

  1093. 						} else {
    1094. 

  1094. 							$db = pc_base::load_model($t.'_model');
    1095. 

  1095. 							if ($r = $db->count()) {
    1096. 

  1096. 								$result = $db->select();
    1097. 

  1097. 								$sql_file = CACHE_PATH.'bakup'.DIRECTORY_SEPARATOR.'default'.DIRECTORY_SEPARATOR.$t.'.sql';
    1098. 

  1098. 								$this->create_sql_file($result, $db->db_tablepre.$t, $sql_file);
    1099. 

  1099. 								$db->query('TRUNCATE TABLE `phpcms_'.$t.'`');
    1100. 

  1100. 							}
    1101. 

  1101. 						}
    1102. 

  1102. 					}
    1103. 

  1103. 				}
    1104. 

  1104. 			}
    1105. 

  1105. 			showmessage(L('clear_data_message'));
    1106. 

  1106. 		} else {
    1107. 

  1107. 			//读取网站的所有模型
    1108. 

  1108. 			$model_arr = getcache('model', 'commons');
    1109. 

  1109. 			include $this->admin_tpl('clear_data');
    1110. 

  1110. 		}
    1111. 

  1111. 	}
    1112. 

  1112. 

  1113. 	/**
    1114. 

  1114. 	 * 备份数据到文件
    1115. 

  1115. 	 * @param $data array 备份的数据数组
    1116. 

  1116. 	 * @param $tablename 数据所属数据表
    1117. 

  1117. 	 * @param $file 备份到的文件
    1118. 

  1118. 	 */
    1119. 

  1119. 	private function create_sql_file($data, $db, $file) {
    1120. 

  1120. 		if (is_array($data)) {
    1121. 

  1121. 			$sql = '';
    1122. 

  1122. 			foreach ($data as $d) {
    1123. 

  1123. 				$tag = '';
    1124. 

  1124. 				$sql .= "INSERT INTO `".$db.'` VALUES(';
    1125. 

  1125. 				foreach ($d as $_f => $_v) {
    1126. 

  1126. 					$sql .= $tag.'\''.addslashes($_v).'\'';
    1127. 

  1127. 					$tag = ',';
    1128. 

  1128. 				}
    1129. 

  1129. 				$sql .= ');'."\r\n";
    1130. 

  1130. 			}
    1131. 

  1131. 			file_put_contents($file, $sql);
    1132. 

  1132. 		}
    1133. 

  1133. 		return true;
    1134. 

  1134. 	}
    1135. 

  1135. }
    1136. 

  1136. ?>
    1137.