<?php
/**
* 对关键词的增删改查
* ======================================================
* 代码生产日期：2016-05-07 21：19
* @author: Abner
* @qq: 346882795
* @website: www.liyanzhi.com
* ======================================================
*
* */
define('IN_ECS', true);
require(dirname(__FILE__) . '/includes/init.php');
include_once(ROOT_PATH . '/includes/cls_image.php');
$exc = new exchange($ecs->table('keyword_url'), $db, 'key_id', 'title');
/* 允许上传的文件类型 */
$allow_file_types = '|GIF|JPG|PNG|BMP|SWF|DOC|XLS|PPT|MID|WAV|ZIP|RAR|PDF|CHM|RM|TXT|';
/**
*************************关键词列表*************************
**/
if ($_REQUEST['act'] == 'list')
{
/* 检查权限 */
admin_priv('keyword');
/* 取得过滤条件 */
$keyword = get_keywordlist();
$smarty->assign('article_list', $keyword['arr']);
$smarty->assign('filter', $keyword['filter']);
$smarty->assign('record_count', $keyword['record_count']);
$smarty->assign('page_count', $keyword['page_count']);
$smarty->assign('full_page', 1);
$smarty->assign('cat_select', article_cat_list(0));
$smarty->assign('action_link', array('text' => $_LANG['02_key_add'], 'href' => 'keyword.php?act=add'));
assign_query_info();
$smarty->display('keyword.htm');
}
/*------------------------------------------------------ */
//-- 添加文章
/*------------------------------------------------------ */
if ($_REQUEST['act'] == 'add')
{
/* 权限判断 */
admin_priv('keyword');
/*初始化*/
$article = array();
$article['is_open'] = 1;
$smarty->assign('article', $article);
$smarty->assign('ur_here', $_LANG['02_key_add']);
$smarty->assign('action_link', array('text' => $_LANG['01_key_list'], 'href' => 'keyword.php?act=list'));
$smarty->assign('form_action', 'insert');
assign_query_info();
$smarty->display('keyword_info.htm');
}
elseif ($_REQUEST['act'] == 'insert')
{
/* 权限判断 */
admin_priv('keyword');
/*检查是否重复*/
// $is_only = $exc->is_only('title', $_POST['title'],0, " cat_id ='$_POST[article_cat]'");
// if (!$is_only)
// {
// sys_msg(sprintf($_LANG['title_exist'], stripslashes($_POST['title'])), 1);
// }
//处理接收来的数据
if(!empty($_POST))
{
$arr = array();
foreach($_POST['title'] as $k => $v){
$arr[] = array(
'title' => $v,
'url' => $_POST['url'][$k],
'num' => $_POST['num'][$k]
);
}
}
/* 拼接数据 */
$val = '';
foreach($arr as $k2 => $v2)
{
$val .= "('{$v2['title']}', '{$v2['url']}', '{$v2['num']}'),";
}
$val = rtrim($val, ',');
$sql = "INSERT INTO " .$ecs->table('keyword_url'). "(`title`, `url`, `num`) VALUES " .$val;
$db->query($sql);
$link[0]['text'] = $_LANG['continue_add'];
$link[0]['href'] = 'keyword.php?act=add';
$link[1]['text'] = $_LANG['back_list'];
$link[1]['href'] = 'keyword.php?act=list';
admin_log($_POST['title'],'add','keyword');
clear_cache_files(); // 清除相关的缓存文件
sys_msg('添加成功',0, $link);
}
/*------------------------------------------------------ */
//-- 编辑字
/*------------------------------------------------------ */
elseif ($_REQUEST['act'] == 'edit_title')
{
check_authz_json('keyword');
$id = intval($_POST['id']);
$title = json_str_iconv(trim($_POST['val']));
/* 检查文章标题是否重复 */
if ($exc->num("title", $title, $id) != 0)
{
make_json_error(sprintf($_LANG['title_exist'], $title));
}
else
{
if ($exc->edit("title = '$title'", $id))
{
clear_cache_files();
admin_log($title, 'edit', 'keyword');
make_json_result(stripslashes($title));
}
else
{
make_json_error($db->error());
}
}
}
/*------------------------------------------------------ */
//-- 编辑url
/*------------------------------------------------------ */
elseif ($_REQUEST['act'] == 'edit_url')
{
check_authz_json('keyword');
$id = intval($_POST['id']);
$url = json_str_iconv(trim($_POST['val']));
/* 检查文章标题是否重复 */
if ($exc->num("title", $title, $id) != 0)
{
make_json_error(sprintf($_LANG['title_exist'], $title));
}
else
{
if ($exc->edit("url = '$url'", $id))
{
clear_cache_files();
admin_log($url, 'edit', 'keyword');
make_json_result(stripslashes($url));
}
else
{
make_json_error($db->error());
}
}
}
/*------------------------------------------------------ */
//-- 编辑数量
/*------------------------------------------------------ */
elseif ($_REQUEST['act'] == 'edit_num')
{
check_authz_json('keyword');
$id = intval($_POST['id']);
$num = json_str_iconv(trim($_POST['val']));
/* 检查文章标题是否重复 */
if ($exc->num("num", $title, $id) != 0)
{
make_json_error(sprintf($_LANG['title_exist'], $title));
}
else
{
if ($exc->edit("num = '$num'", $id))
{
clear_cache_files();
admin_log($num, 'edit', 'keyword');
make_json_result(stripslashes($num));
}
else
{
make_json_error($db->error());
}
}
}
//获得关键字列表
function get_keywordlist()
{
$result = get_filter();
if ($result === false)
{
$filter = array();
$filter['keyword'] = empty($_REQUEST['keyword']) ? '' : trim($_REQUEST['keyword']);
if (isset($_REQUEST['is_ajax']) && $_REQUEST['is_ajax'] == 1)
{
$filter['keyword'] = json_str_iconv($filter['keyword']);
}
$filter['sort_by'] = empty($_REQUEST['sort_by']) ? 'key_id' : trim($_REQUEST['sort_by']);
$filter['sort_order'] = empty($_REQUEST['sort_order']) ? 'DESC' : trim($_REQUEST['sort_order']);
$where = '';
if (!empty($filter['keyword']))
{
$where = " AND a.title LIKE '%" . mysql_like_quote($filter['keyword']) . "%'";
}
/* 关键字总数 */
$sql = 'SELECT COUNT(*) FROM ' .$GLOBALS['ecs'] -> table('keyword_url').' WHERE 1 '.$where;
$filter['record_count'] = $GLOBALS['db'] -> getOne($sql);
$filter = page_and_size($filter);
// var_dump($filter);
/* 获取关键字数据 */
$sql = 'SELECT * FROM ' .$GLOBALS['ecs'] -> table('keyword_url'). ' WHERE 1' .$where. ' ORDER BY ' .$filter['sort_by'].' '.$filter['sort_order'];;
$filter['keyword'] = stripslashes($filter['keyword']);
set_filter($filter, $sql);
}
else
{
$sql = $result['sql'];
$filter = $result['filter'];
}
// var_dump($filter);
$arr = array();
$res = $GLOBALS['db']->selectLimit($sql, $filter['page_size'], $filter['start']);
while ($rows = $GLOBALS['db']->fetchRow($res))
{
$rows['date'] = local_date($GLOBALS['_CFG']['time_format'], $rows['add_time']);
$arr[] = $rows;
}
return array('arr' => $arr, 'filter' => $filter, 'page_count' => $filter['page_count'], 'record_count' => $filter['record_count']);
}
