www.gusucode.com > 74cms PHP骑士人才系统 v3.5.1源码程序 > code/upload/admin/admin_explain.php
<?php /* * 74cms 说明页管理 * ============================================================================ * 版权所有: 骑士网络,并保留所有权利。 * 网站地址: http://www.74cms.com; * ---------------------------------------------------------------------------- * 这不是一个自由软件!您只能在不用于商业目的的前提下对程序代码进行修改和 * 使用;不允许对程序代码以任何形式任何目的的再发布。 * ============================================================================ */ define('IN_QISHI', true); require_once(dirname(__FILE__).'/../data/config.php'); require_once(dirname(__FILE__).'/include/admin_common.inc.php'); require_once(ADMIN_ROOT_PATH.'include/admin_explain_fun.php'); $act = !empty($_GET['act']) ? trim($_GET['act']) : 'list'; $smarty->assign('act',$act); $smarty->assign('pageheader',"说明页"); if($act == 'list') { get_token(); check_permissions($_SESSION['admin_purview'],"explain_show"); require_once(QISHI_ROOT_PATH.'include/page.class.php'); $oederbysql=" order BY e.show_order DESC,e.id DESC "; $key=isset($_GET['key'])?trim($_GET['key']):""; $key_type=isset($_GET['key_type'])?intval($_GET['key_type']):""; if ($key && $key_type>0) { if ($key_type===1)$wheresql=" WHERE e.title like '%{$key}%'"; $oederbysql=""; } !empty($_GET['type_id'])? $wheresqlarr['e.type_id']=intval($_GET['type_id']):''; if (is_array($wheresqlarr)) $wheresql=wheresql($wheresqlarr); if (!empty($_GET['settr'])) { $settr=strtotime("-".intval($_GET['settr'])." day"); $wheresql=empty($wheresql)?" WHERE e.addtime> ".$settr:$wheresql." AND e.addtime> ".$settr; } $joinsql=" LEFT JOIN ".table('explain_category')." AS c ON e.type_id=c.id "; $total_sql="SELECT COUNT(*) AS num FROM ".table('explain')." AS e ".$joinsql.$wheresql; $page = new page(array('total'=>$db->get_total($total_sql), 'perpage'=>$perpage)); $currenpage=$page->nowindex; $offset=($currenpage-1)*$perpage; $explain_list = get_explain($offset, $perpage,$joinsql.$wheresql.$oederbysql); $smarty->assign('get_explain_category',get_explain_category()); $smarty->assign('explain_list',$explain_list); $smarty->assign('page',$page->show(3)); $smarty->assign('navlabel',"list"); $smarty->display('explain/admin_explain.htm'); } elseif($act == 'edit') { get_token(); check_permissions($_SESSION['admin_purview'],"explain_edit"); $id = !empty($_GET['id']) ? intval($_GET['id']) : ''; $sql = "select * from ".table('explain')." where id=".$id." LIMIT 1"; $edit_article=$db->getone($sql); $smarty->assign('edit_article',$edit_article);//读取指定ID的说明页 $smarty->assign('get_explain_category',get_explain_category()); $smarty->display('explain/admin_explain_edit.htm'); } elseif($act == 'editsave') { check_token(); check_permissions($_SESSION['admin_purview'],"explain_edit"); $id = !empty($_POST['id']) ? intval($_POST['id']) : adminmsg('参数错误',1); $setsqlarr['title']=trim($_POST['title'])?trim($_POST['title']):adminmsg('说明页名字不能为空!',1); $setsqlarr['type_id']=trim($_POST['type_id'])?intval($_POST['type_id']):0; $setsqlarr['content']=trim($_POST['content']); $setsqlarr['tit_color']=trim($_POST['tit_color']); $setsqlarr['tit_b']=intval($_POST['tit_b']); $setsqlarr['is_display']=intval($_POST['is_display']); $setsqlarr['is_url']=trim($_POST['is_url']); $setsqlarr['seo_keywords']=trim($_POST['seo_keywords']); $setsqlarr['seo_description']=trim($_POST['seo_description']); $setsqlarr['show_order']=intval($_POST['show_order']); $link[0]['text'] = "返回说明页列表"; $link[0]['href'] = '?'; $link[1]['text'] = "查看已修改说明页"; $link[1]['href'] = "?act=edit&id=".$id; !updatetable(table('explain'),$setsqlarr," id=".$id."")?adminmsg("修改失败!",0):adminmsg("修改成功!",2,$link); } elseif($act == 'add') { get_token(); check_permissions($_SESSION['admin_purview'],"explain_add"); $smarty->assign('ty_id',$_GET['ty_id']); $smarty->assign('get_explain_category',get_explain_category()); $smarty->assign('navlabel',"add"); $smarty->display('explain/admin_explain_add.htm'); } elseif($act == 'addsave') { check_token(); check_permissions($_SESSION['admin_purview'],"explain_add"); $setsqlarr['title']=trim($_POST['title'])?trim($_POST['title']):adminmsg('说明页名字不能为空!',1); $setsqlarr['type_id']=trim($_POST['type_id'])?intval($_POST['type_id']):0; $setsqlarr['content']=trim($_POST['content']); $setsqlarr['tit_color']=trim($_POST['tit_color']); $setsqlarr['tit_b']=intval($_POST['tit_b']); $setsqlarr['is_display']=intval($_POST['is_display']); $setsqlarr['is_url']=trim($_POST['is_url']); $setsqlarr['seo_keywords']=trim($_POST['seo_keywords']); $setsqlarr['seo_description']=trim($_POST['seo_description']); $setsqlarr['show_order']=intval($_POST['show_order']); $setsqlarr['addtime']=$timestamp; $link[0]['text'] = "继续添加说明页"; $link[0]['href'] = '?act=add&type_id='.$setsqlarr['type_id']; $link[1]['text'] = "返回说明页列表"; $link[1]['href'] = '?'; !inserttable(table('explain'),$setsqlarr)?adminmsg("添加失败!",0):adminmsg("添加成功!",2,$link); } elseif($act == 'explain_del') { check_token(); check_permissions($_SESSION['admin_purview'],"explain_del"); $id=$_REQUEST['id']; if ($num=del_explain($id)) { adminmsg("删除成功!共删除".$num."行",2); } else { adminmsg("删除失败!",0); } } elseif($act == 'category') { get_token(); check_permissions($_SESSION['admin_purview'],"explain_category"); $smarty->assign('get_explain_category',get_explain_category()); $smarty->assign('navlabel',"category"); $smarty->display('explain/admin_explain_category.htm'); } elseif($act == 'category_add') { get_token(); check_permissions($_SESSION['admin_purview'],"explain_category"); $smarty->assign('navlabel',"category"); $smarty->display('explain/admin_explain_category_add.htm'); } elseif($act == 'add_category_save') { check_token(); check_permissions($_SESSION['admin_purview'],"explain_category"); $num=0; if (is_array($_POST['categoryname']) && count($_POST['categoryname'])>0) { for ($i =0; $i <count($_POST['categoryname']);$i++){ if (!empty($_POST['categoryname'][$i])) { $setsqlarr['categoryname']=trim($_POST['categoryname'][$i]); $setsqlarr['category_order']=intval($_POST['category_order'][$i]); !inserttable(table('explain_category'),$setsqlarr)?adminmsg("添加失败!",0):""; $num=$num+$db->affected_rows(); } } } if ($num==0) { adminmsg("添加失败,数据不完整",1); } else { $link[0]['text'] = "返回分类管理"; $link[0]['href'] = '?act=category'; $link[1]['text'] = "继续添加"; $link[1]['href'] = "?act=category_add"; adminmsg("添加成功!共添加".$num."个分类",2,$link); } } elseif($act == 'edit_category') { get_token(); check_permissions($_SESSION['admin_purview'],"explain_category"); $id=intval($_GET['id']); $smarty->assign('category',get_explain_category_one($id)); $smarty->assign('navlabel',"category"); $smarty->display('explain/admin_explain_category_edit.htm'); } elseif($act == 'edit_category_save') { check_token(); check_permissions($_SESSION['admin_purview'],"explain_category"); $id=intval($_POST['id']); $setsqlarr['categoryname']=trim($_POST['categoryname'])?trim($_POST['categoryname']):adminmsg('请填写分类名称!',1); $setsqlarr['category_order']=intval($_POST['category_order']); $link[0]['text'] = "查看修改结果"; $link[0]['href'] = '?act=edit_category&id='.$id; $link[1]['text'] = "返回分类管理"; $link[1]['href'] = '?act=category'; !updatetable(table('explain_category'),$setsqlarr," id=".$id."")?adminmsg("修改失败!",0):adminmsg("修改成功!",2,$link); } elseif($act == 'del_category') { check_token(); check_permissions($_SESSION['admin_purview'],"explain_category"); $id=$_REQUEST['id']; if ($num=del_category($id)) { adminmsg("删除成功!共删除".$num."行",2); } else { adminmsg("删除失败!",0); } } ?>