<?php
use application\ESPCMS_AdminAuthority;
use admin_application\ArticleModelDB;
use admin_application\AdminPublicDB;
use admin_application\link\ArticleLink;
class KeywordsGroups {
public function __construct() {
$exclude_method = array('listKeywordsGroups', 'saveKeywordsGroups', 'setKeywordsGroups', 'KeywordsGroupsSearchOut');
ESPCMS_AdminAuthority::authorityAdminVerify($exclude_method);
}
public static function listKeywordsGroups() {
global $espcms_admin_templates, $espcms_link_db;
$db_table = ESPCMS_DB_PREFIX . "keylink_type";
$admin_member_id = ESPCMS_AdminAuthority::getUserLoginInfo('admin_member_id');
if (empty($admin_member_id) || !espcms_ismatches($admin_member_id)) {
espcms_message_err('public_pack-espcms_input_parameter_fail', array($admin_member_id));
}
$out_type = $_REQUEST['out_type'];
$lng = AdminPublicDB::get_lancode();
$db_where = " AND lng='$lng'";
if ($out_type == 'list') {
$limit = $_REQUEST['limit'] && espcms_ismatches($_REQUEST['limit']) ? $_REQUEST['limit'] : 0;
$per_page_num = $_REQUEST['per_page_num'] && espcms_ismatches($_REQUEST['per_page_num']) ? $_REQUEST['per_page_num'] : 10;
$mid = $_REQUEST['mid'];
if (espcms_ismatches($mid) && $mid) {
$db_where .= " AND mid=$mid";
}
$isclass = $_REQUEST['isclass'];
if (espcms_ismatches($isclass)) {
$db_where .= " AND isclass=$isclass";
}
$searchlist = $_GET['searchlist'];
if ($searchlist == 'true') {
exit(espcms_page_db($db_table, $db_where, true));
}
$sort_key = $_REQUEST['sort_key'];
$sort_key_array = array('ktid', 'mid');
if (isset($sort_key) && in_array($sort_key, $sort_key_array)) {
$order_key = $sort_key;
} else {
$order_key = "ktid";
}
$sort_rank = $_REQUEST['sort_rank'];
$sort_rank_array = array('ASC', 'DESC');
if (isset($sort_rank) && in_array($sort_rank, $sort_rank_array)) {
$order_rank = $sort_rank;
} else {
$order_rank = "DESC";
}
$db_query = $espcms_link_db->db_query(espcms_db_list_out($db_table, $db_where, $order_key, $order_rank, $limit, $per_page_num));
while ($fetch_row = $espcms_link_db->db_array_list($db_query)) {
$fetch_row['edit'] = ArticleLink::KeywordsGroups_link_array('edit', $fetch_row);
$fetch_row['modelname'] = ArticleModelDB::get_mid_view($fetch_row['mid'], 'modelname');
$array[] = $fetch_row;
}
$espcms_admin_templates->into('array', $array);
$list_type = $_GET['list_type'];
$templates = $list_type == 'select' ? 'article/keywords_groups_list_select' : 'article/keywords_groups_list';
} elseif ($out_type == 'select') {
$espcms_admin_templates->into('page_db', espcms_page_db($db_table, $db_where));
$_REQUEST['list_type'] = 'select';
$espcms_admin_templates->into('link', ArticleLink::KeywordsGroups_link_array(false, $_REQUEST));
$espcms_admin_templates->into('inputname', $_GET['inputname']);
$espcms_admin_templates->into('inputname2', $_GET['inputname2']);
$espcms_admin_templates->into('iframes_name', $_GET['iframeName']);
$templates = 'article/keywords_groups_index_select';
} else {
$espcms_admin_templates->into('page_db', espcms_page_db($db_table, $db_where));
$espcms_admin_templates->into('link', ArticleLink::KeywordsGroups_link_array(false, $_REQUEST));
$templates = 'article/keywords_groups_index';
}
$espcms_admin_templates->output($templates);
}
public static function KeywordsGroupsSearchOut() {
$ktid = $_GET['ktid'];
if (!$ktid || !espcms_ismatches($ktid)) {
espcms_message_err('public_pack-espcms_input_parameter_fail', array($ktid));
}
$db_table = ESPCMS_DB_PREFIX . "keylink_type";
$db_where = " WHERE ktid=$ktid";
$talbe_field_array = espcms_field_out($db_table, false);
$read = espcms_db_read($db_table, $db_where, $talbe_field_array);
if (!$read) {
espcms_message_err('public_pack-espcms_input_parameter_fail', array($ktid));
}
$read_json = json_encode($read);
exit($read_json);
}
public static function addKeywordsGroups() {
global $espcms_admin_templates;
$admin_member_id = ESPCMS_AdminAuthority::getUserLoginInfo('admin_member_id');
if (empty($admin_member_id) || !espcms_ismatches($admin_member_id)) {
espcms_message_err('public_pack-espcms_input_parameter_fail', array($admin_member_id));
}
$espcms_admin_templates->into('link', ArticleLink::KeywordsGroups_link_array());
$espcms_admin_templates->into('key_select_link', ArticleLink::KeywordsOptimization_link_array('select'));
$espcms_admin_templates->into('model_list', ArticleModelDB::get_model_list());
$espcms_admin_templates->into('token', token());
$espcms_admin_templates->output('article/keywords_groups_add');
}
public static function editKeywordsGroups() {
global $espcms_admin_templates;
$ktid = $_GET['ktid'];
if (!$ktid || !espcms_ismatches($ktid)) {
espcms_message_err('public_pack-espcms_input_parameter_fail', array($ktid));
}
$db_table = ESPCMS_DB_PREFIX . "keylink_type";
$db_where = " WHERE ktid=$ktid";
$talbe_field_array = espcms_field_out($db_table, false);
$read = espcms_db_read($db_table, $db_where, $talbe_field_array);
if (!$read) {
espcms_message_err('db_pack-espcms_db_read_fail', array($db_where));
}
$espcms_admin_templates->into('key_select_link', ArticleLink::KeywordsOptimization_link_array('select'));
$espcms_admin_templates->into('model_list', ArticleModelDB::get_model_list($read['mid']));
$espcms_admin_templates->into('link', ArticleLink::KeywordsGroups_link_array());
$espcms_admin_templates->into('read', $read);
$espcms_admin_templates->into('token', token());
$espcms_admin_templates->output('article/keywords_groups_edit');
}
public static function saveKeywordsGroups() {
if (!is_token($_POST['token_name'], $_POST['token_key'])) {
espcms_public_dialog('espcms_public_dialog', 'public_pack-espcms_input_repeat_fail', 'false', array($_POST['token_name']));
}
$saveType = $_POST['savetype'] ? $_POST['savetype'] : 'add';
$db_table = ESPCMS_DB_PREFIX . "keylink_type";
$talbe_field_array = espcms_field_out($db_table, true);
if (!espcms_ismatches($_POST['mid']) || empty($_POST['mid'])) {
espcms_public_dialog('espcms_public_dialog', 'public_pack-espcms_input_parameter_fail', 'false');
}
if ($saveType == 'add') {
if (!ESPCMS_AdminAuthority::authorityVerify('addKeywordsGroups')) {
espcms_public_dialog('espcms_public_dialog', 'public_pack-espcms_authority_function_fail', 'false');
}
$_POST['lng'] = AdminPublicDB::get_lancode();
$postvalue = espcms_post($_POST, $talbe_field_array, true);
if (!$postvalue || !is_array($postvalue)) {
espcms_public_dialog('espcms_public_dialog', 'db_pack-espcms_db_install_fail', 'false');
}
$install_id = espcms_db_install_save($db_table, $postvalue);
if (!$install_id) {
espcms_public_dialog('espcms_public_dialog', 'db_pack-espcms_db_install_fail', 'false');
}
espcms_log_install('article_pack-espcms_keywords_groups_button_add', $_POST['keytypename']);
espcms_public_dialog('espcms_info_save_ok', 'article_pack-espcms_keywords_groups_add_save_ok_message', 'true', array($_POST['keytypename']));
} elseif ($saveType == 'edit') {
if (!ESPCMS_AdminAuthority::authorityVerify('editKeywordsGroups')) {
espcms_public_dialog('espcms_public_dialog', 'public_pack-espcms_authority_function_fail', 'false');
}
$ktid = $_POST['ktid'];
if (empty($ktid) || !espcms_ismatches($ktid)) {
espcms_public_dialog('espcms_public_dialog', 'public_pack-espcms_input_parameter_fail', 'false', array($ktid));
}
$db_where = "WHERE ktid=$ktid";
$read = espcms_db_read($db_table, $db_where, $talbe_field_array);
if (!$read) {
espcms_public_dialog('espcms_public_dialog', 'public_pack-espcms_input_parameter_fail', 'false', array($ktid));
}
$postvalue = espcms_post($_POST, $talbe_field_array, true);
if (!$postvalue || !is_array($postvalue)) {
espcms_public_dialog('espcms_public_dialog', 'db_pack-espcms_db_install_fail', 'false');
}
$update_id = espcms_db_update_save($db_table, $db_where, $postvalue);
if (!$update_id) {
espcms_public_dialog('espcms_public_dialog', 'db_pack-espcms_db_install_fail', 'false');
}
espcms_log_install('article_pack-espcms_keywords_groups_button_edit', $_POST['keytypename']);
espcms_public_dialog('espcms_info_save_ok', 'article_pack-espcms_keywords_groups_edit_save_ok_message', 'true', array($_POST['keytypename']));
}
}
public static function delKeywordsGroups() {
$select_id = $_POST['select_id'];
if (!is_array($select_id) || count($select_id) <= 0) {
espcms_public_dialog('info_set_err', 'public_pack-espcms_select_err', 'false', array($select_id));
}
$delcount = 0;
foreach ($select_id as $value) {
$operate_result = self::delKeywordsGroupsDB($value);
if ($operate_result['code'] == 'true') {
$delcount++;
}
}
$espcms_del_id = implode(', ', $select_id);
espcms_log_install('article_pack-espcms_keywords_groups_button_del', $espcms_del_id);
$return['count'] = $delcount;
espcms_public_dialog('espcms_public_dialog', 'article_pack-espcms_keywords_groups_del_message', 'true', array(), 'json', $return);
}
private static function delKeywordsGroupsDB($ktid = 0) {
if (!$ktid || !espcms_ismatches($ktid)) {
$return_array = array('lan' => 'public_pack-espcms_input_parameter_fail', 'code' => 'false', 'key' => $ktid);
return $return_array;
}
$db_table = ESPCMS_DB_PREFIX . "keylink_type";
$del_query = espcms_db_del($db_table, 'ktid', $ktid);
if ($del_query) {
$return_array = array('lan' => 'public_pack-espcms_del_ok', 'code' => 'true', 'key' => $ktid);
return $return_array;
} else {
$return_array = array('lan' => 'public_pack-espcms_del_err', 'code' => 'false', 'key' => $ktid);
return $return_array;
}
}
}