phpcms v9 后台增加搜索关键字编辑管理功能

后台使用效果如上,修改方法为:

一,运行sqlalter table v9_search_keyword add keywordid int(16) unsigned NOT NULL auto_increment PRIMARY KEY ;alter table v9_search_keyword add title char(100) ;INSERT INTO v9_menu (name,parentid,m,c,a) VALUES ( 'search_keyword', '977', 'admin', 'search_keyword', 'init');INSERT INTO v9_menu  (name,parentid,m,c,a) VALUES ( 'add_search_keyword', '1571', 'admin', 'search_keyword', 'add');INSERT INTO v9_menu  (name,parentid,m,c,a)VALUES ( 'edit_search_keyword', '1571', 'admin', 'search_keyword', 'edit');INSERT INTO v9_menu  (name,parentid,m,c,a)VALUES ( 'del_search_keyword', '1571', 'admin', 'search_keyword', 'del');2,进\phpcms\modules\admin增加目录中的search_keyword.php  文件3,进\phpcms\modules\admin\templates增加三个模板文件search_keyword_add.tpl.phpsearch_keyword_edit.tpl.phpsearch_keyword_list.tpl.php

一,search_keyword.php文件内容为

<?phpdefined('IN_PHPCMS') or exit('No permission resources.');pc_base::load_app_class('admin','admin',0);class search_keyword extends admin {function __construct() {$this->db = pc_base::load_model('search_keyword_model');parent::__construct();}function init () {$page = $_GET['page'] ? intval($_GET['page']) : '1';//根据搜索数量由大到小排序$infos = $this->db->listinfo('','searchnums DESC',$page ,'20');$pages = $this->db->pages;$big_menu = array('javascript:window.top.art.dialog({id:\'add\',iframe:\'?m=admin&c=search_keyword&a=add\', title:\''.L('search_word_add').'\', width:\'450\', height:\'150\'}, function(){var d = window.top.art.dialog({id:\'add\'}).data.iframe;var form = d.document.getElementById(\'dosubmit\');form.click();return false;}, function(){window.top.art.dialog({id:\'add\'}).close()});void(0);', L('search_word_add'));include $this->admin_tpl('search_keyword_list');}/*** 关键词添加*/function add() {if(isset($_POST['dosubmit'])){if(empty($_POST['info']['keyword'])){echo L('search_word_error_input');return false;}$this->db->insert($_POST['info']);showmessage(L('operation_success'),'?m=admin&c=search_keyword&a=add','', 'add');}else{$show_validator = $show_scroll = $show_header = true;include $this->admin_tpl('search_keyword_add');}}/*** 关键词修改*/function edit() {if(isset($_POST['dosubmit'])){$keywordid = intval($_GET['keywordid']);if(empty($_POST['info']['keyword']) ){echo L('search_word_error_input');return false;}$this->db->update($_POST['info'],array('keywordid'=>$keywordid));showmessage(L('operation_success'),'?m=admin&c=search_keyword&a=edit','', 'edit');}else{$show_validator = $show_scroll = $show_header = true;$info = $this->db->get_one(array('keywordid'=>$_GET['keywordid']));if(!$info) showmessage(L('specified_word_not_exist'));extract($info);include $this->admin_tpl('search_keyword_edit');}}/*** 关键词删除*/function delete() {if(is_array($_POST['keywordid'])){foreach($_POST['keywordid'] as $keywordid_arr) {$this->db->delete(array('keywordid'=>$keywordid_arr));}showmessage(L('operation_success'),'?m=admin&c=search_keyword');} else {$keywordid = intval($_GET['keywordid']);if($keywordid < 1) return false;$result = $this->db->delete(array('keywordid'=>$keywordid));if($result){showmessage(L('operation_success'),'?m=admin&c=search_keyword');}else {showmessage(L("operation_failure"),'?m=admin&c=search_keyword');}}}}?>

二,search_keyword_add.tpl.php模板内容为

<?phpdefined('IN_ADMIN') or exit('No permission resources.');include $this->admin_tpl('header');?><script type="text/javascript">$(function(){$.formValidator.initConfig({formid:"myform",autotip:true,onerror:function(msg,obj){window.top.art.dialog({content:msg,lock:true,width:'200',height:'50'}, function(){this.close();$(obj).focus();})}});})</script><div><table width="100%" cellpadding="2" cellspacing="1" class="table_form"><form action="?m=admin&c=search_keyword&a=add" method="post" name="myform" id="myform"><tr><th width="25%"><?php echo L('search_word_name');?> :</th><td><input type="text" name="info[keyword]" id="word" size="20"></td></tr><tr><th>备注</th><td><input type="text" name="info[title]" value=""  id="title"></td></tr><tr><th><?php echo L('search_word_nums');?> :</th><td><input type="text" name="info[searchnums]" value=""  id="searchnums"></td></tr><tr><th><?php echo L('search_word_some');?> :</th><td><input type="text" name="info[data]" value=""  id="data"></td></tr><input type="submit"  style="display:none"name="dosubmit" id="dosubmit" value=" <?php echo L('submit')?> "></form></table></div></body></html>

三,search_keyword_edit.tpl.php内容为

<?phpdefined('IN_ADMIN') or exit('No permission resources.');include $this->admin_tpl('header');?><script type="text/javascript">$(function(){$.formValidator.initConfig({formid:"myform",autotip:true,onerror:function(msg,obj){window.top.art.dialog({content:msg,lock:true,width:'200',height:'50'}, function(){this.close();$(obj).focus();})}});})</script><div><table cellpadding="2" cellspacing="1" width="100%" class="table_form"><form action="?m=admin&c=search_keyword&a=edit&keywordid=<?php echo $keywordid?>" method="post" name="myform" id="myform"><tr><th width="25%"><?php echo L('search_word_name');?> :</th><td><input type="text" name="info[keyword]"  size="20" value="<?php echo $keyword?>"></td></tr><tr><th>备注</th><td><input type="text" name="info[title]" value="<?php echo $title?>" ></td></tr><tr><th><?php echo L('search_word_nums');?> :</th><td><input type="text" name="info[searchnums]" value="<?php echo $searchnums?>" ></td></tr><tr><th><?php echo L('search_word_some');?> :</th><td><input type="text" name="info[data]" value="<?php echo $data?>"></td></tr><input type="submit" name="dosubmit" style="display:none" id="dosubmit" value=" <?php echo L('submit')?> "></form></table></div></body></html>

四,search_keyword_list.tpl.php内容为

<?phpdefined('IN_ADMIN') or exit('No permission resources.');$show_dialog = 1;include $this->admin_tpl('header','admin');?><div class="pad-lr-10"><form name="myform" id="myform" action="?m=admin&c=search_keyword&a=delete" method="post" onsubmit="checkuid();return false;"><div class="table-list"><table width="100%" cellspacing="0"><thead><tr><th width="35" align="center"><input type="checkbox" value="" id="check_box" onclick="selectall('keywordid[]');"></th><th width="30%"><?php echo L('keyword_name')?></th><th >备注</th><th ><?php echo L('search_word_nums')?></th><th ><?php echo L('search_word_some')?></th><th width="120"><?php echo L('operations_manage')?></th></tr></thead><tbody><?phpif(is_array($infos)){foreach($infos as $info){?><tr><td align="center"><input type="checkbox" name="keywordid[]" value="<?php echo $info['keywordid']?>"></td><td width="30%" align="left"><span ><?php echo $info['keyword']?></span> </td><td align="center"><?php echo $info['title']?></td><td align="center"><?php echo $info['searchnums']?></td><td align="center"><?php echo $info['data']?></td><td align="center"><a href="javascript:edit(<?php echo $info['keywordid']?>, '<?php echo new_addslashes($info['keyword'])?>')"><?php echo L('edit')?></a> | <a href="javascript:confirmurl('?m=admin&c=search_keyword&a=delete&keywordid=<?php echo $info['keywordid']?>', '<?php echo L('search_word_confirm_del')?>')"><?php echo L('delete')?></a> </td></tr><?php}}?></tbody></table><div><a href="#" onClick="javascript:$('input[type=checkbox]').attr('checked', true)"><?php echo L('selected_all')?></a>/<a href="#" onClick="javascript:$('input[type=checkbox]').attr('checked', false)"><?php echo L('cancel')?></a><input type="submit" name="submit" style="display:none" value="<?php echo L('remove_all_selected')?>"  onClick="return confirm('<?php echo L('badword_confom_del')?>')" /></div><div id="pages"><?php echo $pages?></div></div></form></div></body></html><script type="text/javascript">function edit(id, name) {window.top.art.dialog({id:'edit'}).close();window.top.art.dialog({title:'<?php echo L('edit')?> '+name+' ',id:'edit',iframe:'?m=admin&c=search_keyword&a=edit&keywordid='+id,width:'450',height:'150'}, function(){var d = window.top.art.dialog({id:'edit'}).data.iframe;var form = d.document.getElementById('dosubmit');form.click();return false;}, function(){window.top.art.dialog({id:'edit'}).close()});}function checkuid() {var ids='';$("input[name='keywordid[]']:checked").each(function(i, n){ids += $(n).val() + ',';});if(ids=='') {window.top.art.dialog({content:'<?php echo L('badword_pleasechose')?>',lock:true,width:'200',height:'50',time:1.5},function(){});return false;} else {myform.submit();}}</script>