You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
85 lines
3.5 KiB
85 lines
3.5 KiB
<?php
|
|
|
|
/**
|
|
* ECSHOP 程序说明
|
|
* ===========================================================
|
|
* * 版权所有 2005-2016 上海商创网络科技有限公司，并保留所有权利。
|
|
* 网站地址: http://www.ecmoban.com；
|
|
* ----------------------------------------------------------
|
|
* 这不是一个自由软件！您只能在不用于商业目的的前提下对程序代码进行修改和
|
|
* 使用；不允许对程序代码以任何形式任何目的的再发布。
|
|
* ==========================================================
|
|
* $Author: liubo $
|
|
* $Id: search_log.php 17217 2011-01-19 06:29:08Z liubo $
|
|
*/
|
|
|
|
define('IN_ECS', true);
|
|
|
|
require(dirname(__FILE__) . '/includes/init.php');
|
|
$_REQUEST['act'] = trim($_REQUEST['act']);
|
|
|
|
admin_priv('search_log');
|
|
if ($_REQUEST['act'] == 'list')
|
|
{
|
|
$logdb = get_search_log();
|
|
$smarty->assign('ur_here', $_LANG['search_log']);
|
|
$smarty->assign('full_page', 1);
|
|
$smarty->assign('logdb', $logdb['logdb']);
|
|
$smarty->assign('filter', $logdb['filter']);
|
|
$smarty->assign('record_count', $logdb['record_count']);
|
|
$smarty->assign('page_count', $logdb['page_count']);
|
|
$smarty->assign('start_date', local_date('Y-m-d'));
|
|
$smarty->assign('end_date', local_date('Y-m-d'));
|
|
assign_query_info();
|
|
$smarty->display('search_log_list.htm');
|
|
}
|
|
elseif ($_REQUEST['act'] == 'query')
|
|
{
|
|
|
|
$logdb = get_search_log();
|
|
$smarty->assign('full_page', 0);
|
|
$smarty->assign('logdb', $logdb['logdb']);
|
|
$smarty->assign('filter', $logdb['filter']);
|
|
$smarty->assign('record_count', $logdb['record_count']);
|
|
$smarty->assign('page_count', $logdb['page_count']);
|
|
$smarty->assign('start_date', local_date('Y-m-d'));
|
|
$smarty->assign('end_date', local_date('Y-m-d'));
|
|
make_json_result($smarty->fetch('search_log_list.htm'), '',
|
|
array('filter' => $logdb['filter'], 'page_count' => $logdb['page_count']));
|
|
}
|
|
function get_search_log()
|
|
{
|
|
$where = '';
|
|
if (isset($_REQUEST['start_dateYear']) && isset($_REQUEST['end_dateYear']))
|
|
{
|
|
$start_date = $_POST['start_dateYear']. '-' .$_POST['start_dateMonth']. '-' .$_POST['start_dateDay'];
|
|
$end_date = $_POST['end_dateYear']. '-' .$_POST['end_dateMonth']. '-' .$_POST['end_dateDay'];
|
|
$where .= " AND date <= '$end_date' AND date >= '$start_date'";
|
|
$filter['start_dateYear'] = $_REQUEST['start_dateYear'];
|
|
$filter['start_dateMonth'] = $_REQUEST['start_dateMonth'];
|
|
$filter['start_dateDay'] = $_REQUEST['start_dateDay'];
|
|
|
|
$filter['end_dateYear'] = $_REQUEST['end_dateYear'];
|
|
$filter['end_dateMonth'] = $_REQUEST['end_dateMonth'];
|
|
$filter['end_dateDay'] = $_REQUEST['end_dateDay'];
|
|
}
|
|
|
|
$sql = "SELECT COUNT(*) FROM " . $GLOBALS['ecs']->table('keywords') . " WHERE searchengine='ecshop' $where";
|
|
$filter['record_count'] = $GLOBALS['db']->getOne($sql);
|
|
$logdb = array();
|
|
$filter = page_and_size($filter);
|
|
$sql = "SELECT * FROM " . $GLOBALS['ecs']->table('keywords') .
|
|
" WHERE searchengine='ecshop' $where" .
|
|
" ORDER BY date DESC, count DESC" .
|
|
" LIMIT $filter[start],$filter[page_size]";
|
|
$query = $GLOBALS['db']->query($sql);
|
|
|
|
while ($rt = $GLOBALS['db']->fetch_array($query))
|
|
{
|
|
$logdb[] = $rt;
|
|
}
|
|
$arr = array('logdb' => $logdb, 'filter' => $filter, 'page_count' => $filter['page_count'], 'record_count' => $filter['record_count']);
|
|
|
|
return $arr;
|
|
}
|
|
?>
|