www.gusucode.com > ecShop PHP网上商城系统 粉丝修复版 v2.7.3源码程序 > ecshop_xf_v2.7.3/admin/search_log.php
<?php /** * ECSHOP 程序说明 * =========================================================== * * 版权所有 2005-2012 上海商派网络科技有限公司,并保留所有权利。 * 网站地址: http://www.ecshop.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; } ?>