|
Server : Apache System : Linux iZ2vcgyutqttsd1p850kl8Z 3.10.0-1160.92.1.el7.x86_64 #1 SMP Tue Jun 20 11:48:01 UTC 2023 x86_64 User : www ( 1000) PHP Version : 5.6.40 Disable Function : passthru,exec,system,putenv,chroot,chgrp,chown,shell_exec,popen,proc_open,pcntl_exec,ini_alter,ini_restore,dl,openlog,syslog,readlink,symlink,popepassthru,pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,imap_open,apache_setenv Directory : /www/wwwroot/saimikebio.com/mobile/ecshopjcw/ |
<?php
/**
* ECSHOP 程序说明
* ===========================================================
* * 版权所有 2005-2012 上海商派网络科技有限公司，并保留所有权利。
* 网站地址: http://www.ecshop.com；
* ----------------------------------------------------------
* 这不是一个自由软件！您只能在不用于商业目的的前提下对程序代码进行修改和
* 使用；不允许对程序代码以任何形式任何目的的再发布。
* ==========================================================
* $Author: liubo $
* $Id: search_log.php 17217 2011-01-19 06:29:08Z liubo $
*/
define('IN_ECTOUCH', 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;
}
?>