/Quản lý website trường trung học phổ thông PHP/lc1/admin/modules/siteinfo/logs.php

<?php

/**
 * @Project NUKEVIET 3.0
 * @Author VINADES.,JSC (contact@vinades.vn)
 * @Copyright (C) 2010 VINADES.,JSC. All rights reserved
 * @Createdate 11-10-2010 14:43
 */
 
if ( ! defined( 'NV_IS_FILE_SITEINFO' ) ) die( 'Stop!!!' );

/* 
 * Eg: $id = nv_insert_logs('lang','module name','name key','note',1, 'link acess');
 */

$page_title = $lang_module['logs_title'];

$page = $nv_Request->get_int( 'page', 'get', 0 );
$per_page = 30;
$data = array();
$array_userid = array();
$disabled = " disabled=\"disabled\"";

$sql = "SELECT SQL_CALC_FOUND_ROWS * FROM `" . $db_config['prefix'] . "_logs` WHERE `id`!=0";
$base_url = NV_BASE_ADMINURL . "index.php?" . NV_NAME_VARIABLE . "=" . $module_name . "&" . NV_OP_VARIABLE . "=" . $op;

// Search data
$data_search = array(
	"q" => $lang_module['filter_enterkey'], //
	"from" => "", //
	"to" => "", //
	"lang" => "", //
	"module" => "", //
	"user" => "" //
);

if ( $nv_Request->isset_request( 'filter', 'get' ) and $nv_Request->isset_request( 'checksess', 'get' ) )
{
	$checksess = filter_text_input( 'checksess', 'get', '', 1 );
	if ( $checksess != md5 ( "siteinfo_" . session_id() . "_" . $admin_info['userid'] ) )
	{
		nv_insert_logs( NV_LANG_DATA, $module_name, sprintf ( $lang_module['filter_check_log'], $op ), $admin_info['username'] . " - " . $admin_info['userid'], 0 );
		Header( "Location: " . NV_BASE_ADMINURL . "index.php?" . NV_NAME_VARIABLE . "=" . $module_name . "&" . NV_OP_VARIABLE . "=" . $op );
		exit();
	}
	
	$data_search = array(
		"q" => filter_text_input( 'q', 'get', '' ), //
		"from" => filter_text_input( 'from', 'get', '' ), //
		"to" => filter_text_input( 'to', 'get', '' ), //
		"lang" => filter_text_input( 'lang', 'get', '' ), //
		"module" => filter_text_input( 'module', 'get', '' ), //
		"user" => filter_text_input( 'user', 'get', '' ) //
	);
	
	$base_url .= "&amp;filter=1&amp;checksess=" . $checksess;
	$disabled = "";
	
	if ( ! empty ( $data_search['q'] ) and $data_search['q'] != $lang_module['filter_enterkey'] )
	{
		$base_url .= "&amp;q=" . $data_search['q'];
		$sql .= " AND ( `name_key` LIKE '%" . $db->dblikeescape( $data_search['q'] ) . "%' OR `note_action` LIKE '%" . $db->dblikeescape( $data_search['q'] ) . "%' )";
	}
	
	if ( ! empty ( $data_search['from'] ) )
	{
		unset( $match );
		if ( preg_match( "/^([0-9]{1,2})\.([0-9]{1,2})\.([0-9]{4})$/", $data_search['from'], $match ) )
		{
			$from = mktime( 0, 0, 0, $match[2], $match[1], $match[3] );
			$sql .= " AND `log_time` >= " . $from;
			$base_url .= "&amp;from=" . $data_search['from'];
		}
	}
	
	if ( ! empty ( $data_search['to'] ) )
	{
		unset( $match );
		if ( preg_match( "/^([0-9]{1,2})\.([0-9]{1,2})\.([0-9]{4})$/", $data_search['to'], $match ) )
		{
			$to = mktime( 0, 0, 0, $match[2], $match[1], $match[3] );
			$sql .= " AND `log_time` <= " . $to;
			$base_url .= "&amp;to=" . $data_search['to'];
		}
	}
	
	if ( ! empty ( $data_search['lang'] ) )
	{
		if ( in_array( $data_search['lang'], array_keys ( $language_array ) ) )
		{
			$sql .= " AND `lang`=" . $db->dbescape( $data_search['lang'] );
			$base_url .= "&amp;lang=" . $data_search['lang'];
		}
	}
	
	if ( ! empty ( $data_search['module'] ) )
	{
		$sql .= " AND `module_name`=" . $db->dbescape( $data_search['module'] );
		$base_url .= "&amp;module=" . $data_search['module'];
	}
	
	if ( ! empty ( $data_search['user'] ) )
	{
		$user_tmp = ( $data_search['user'] == "system" ) ? 0 : (int)$data_search['user'];
		
		$sql .= " AND `userid`=" . $user_tmp;
		$base_url .= "&amp;user=" . $data_search['user'];
	}
}

// Order data
$order = array();
$check_order = array( "ASC", "DESC", "NO" );
$opposite_order = array(
	"NO" => "ASC",  //
	"DESC" => "ASC",  //
	"ASC" => "DESC"  //
);
$lang_order_1 = array(
	"NO" => $lang_module['filter_lang_asc'],  //
	"DESC" => $lang_module['filter_lang_asc'],  //
	"ASC" => $lang_module['filter_lang_desc']  //
);
$lang_order_2 = array(
	"lang" => strtolower ( $lang_module['log_lang'] ),  //
	"module" => strtolower ( $lang_module['moduleName'] ),  //
	"time" => strtolower ( $lang_module['log_time'] )  //
);

$order['lang']['order'] = filter_text_input( 'order_lang', 'get', 'NO' );
$order['module']['order'] = filter_text_input( 'order_module', 'get', 'NO' );
$order['time']['order'] = filter_text_input( 'order_time', 'get', 'NO' );

foreach ( $order as $key => $check )
{
	if ( ! in_array ( $check['order'], $check_order ) )
	{
		$order[$key]['order'] = "NO";
	}
	
	$order[$key]['data'] = array(
		"class" => "order" . strtolower ( $order[$key]['order'] ),  //
		"url" => $base_url . "&amp;order_" . $key . "=" . $opposite_order[$order[$key]['order']],  //
		"title" => sprintf ( $lang_module['filter_order_by'], $lang_order_2[$key] ) . " " . $lang_order_1[$order[$key]['order']]  //
	); 
}

if ( $order['lang']['order'] != "NO" )
{
	$sql .= " ORDER BY `lang` " . $order['lang']['order'];
}
elseif  ( $order['module']['order'] != "NO" )
{
	$sql .= " ORDER BY `module_name` " . $order['module']['order'];
}
elseif  ( $order['time']['order'] != "NO" )
{
	$sql .= " ORDER BY `log_time` " . $order['time']['order'];
}
else
{
	$sql .= " ORDER BY `id` DESC";
}

$sql .= " LIMIT " . $page . "," . $per_page;

//
$result_query = $db->sql_query( $sql );
$result = $db->sql_query( "SELECT FOUND_ROWS()" );

list( $all_page ) = $db->sql_fetchrow( $result );
while ( $data_i = $db->sql_fetchrow( $result_query ) )
{
    if ( $data_i['userid'] != 0 )
    {
        if ( ! in_array( $data_i['userid'], $array_userid ) )
        {
            $array_userid[] = $data_i['userid'];
        }
    }
    $data_i['time'] = nv_date( "d-m-Y h:i:s A", $data_i['log_time'] );
    $data[] = $data_i;
    unset( $data_i );
}

$data_users = array();
$data_users[0] = "system";
if ( ! empty( $array_userid ) )
{
    $array_userid = implode( ",", $array_userid );
	$sql = "SELECT userid, username FROM `" . $db_config['prefix'] . "_users` WHERE userid IN (" . $array_userid . ")";

	$result_users = $db->sql_query( $sql );
	while ( $data_i = $db->sql_fetchrow( $result_users ) )
	{
		$data_users[$data_i['userid']] = $data_i['username'];
	}
	unset( $data_i, $result_users );
}

//
$list_lang = nv_siteinfo_getlang ();
$array_lang = array();
$array_lang[] = array(
	"key" => "",  //
	"title" => $lang_module['filter_lang'],  //
	"selected" => ( $data_search['lang'] == "" ) ? " selected=\"selected\"" : ""  //
);

foreach ( $list_lang as $lang )
{
	$array_lang[] = array(
		"key" => $lang,  //
		"title" => $language_array[$lang]['name'],  //
		"selected" => ( $data_search['lang'] == $lang ) ? " selected=\"selected\"" : ""  //
	);
}

//
$list_module = nv_siteinfo_getmodules ();
$array_module = array();
$array_module[] = array(
	"key" => "",  //
	"title" => $lang_module['filter_module'],  //
	"selected" => ( $data_search['module'] == "" ) ? " selected=\"selected\"" : ""  //
);

foreach ( $list_module as $module )
{
	$array_module[] = array(
		"key" => $module,  //
		"title" => $module,  //
		"selected" => ( $data_search['module'] == $module ) ? " selected=\"selected\"" : ""  //
	);
}

//
$list_user = nv_siteinfo_getuser ();
$array_user = array();
$array_user[] = array(
	"key" => "",  //
	"title" => $lang_module['filter_user'],  //
	"selected" => ( $data_search['user'] == "" ) ? " selected=\"selected\"" : ""  //
);
$array_user[] = array(
	"key" => "system",  //
	"title" => $lang_module['filter_system'],  //
	"selected" => ( $data_search['user'] == "system" ) ? " selected=\"selected\"" : ""  //
);

foreach ( $list_user as $user )
{
	$array_user[] = array(
		"key" => $user['userid'],  //
		"title" => $user['username'],  //
		"selected" => ( (int)$data_search['user'] == $user['userid'] ) ? " selected=\"selected\"" : ""  //
	);
}

// Call popcalendar
$my_head = "<script type=\"text/javascript\" src=\"" . NV_BASE_SITEURL . "js/popcalendar/popcalendar.js\"></script>\n";
$my_head .= "<script type=\"text/javascript\" src=\"" . NV_BASE_SITEURL . "js/shadowbox/shadowbox.js\"></script>\n";
$my_head .= "<link rel=\"stylesheet\" type=\"text/css\" href=\"" . NV_BASE_SITEURL . "js/shadowbox/shadowbox.css\" />\n";
$my_head .= "<script type=\"text/javascript\">\n";
$my_head .= "Shadowbox.init({\n";
$my_head .= "});\n";
$my_head .= "</script>\n";

$xtpl = new XTemplate( "logs.tpl", NV_ROOTDIR . "/themes/" . $global_config['module_theme'] . "/modules/" . $module_file );
$xtpl->assign( 'LANG', $lang_module );
$xtpl->assign( 'GLANG', $lang_global );
$xtpl->assign( 'NV_BASE_ADMINURL', NV_BASE_ADMINURL );
$xtpl->assign( 'NV_NAME_VARIABLE', NV_NAME_VARIABLE );
$xtpl->assign( 'MODULE_NAME', $module_name );
$xtpl->assign( 'NV_OP_VARIABLE', NV_OP_VARIABLE );
$xtpl->assign( 'OP', $op );
$xtpl->assign( 'checksess', md5 ( "siteinfo_" . session_id() . "_" . $admin_info['userid'] ) );
$xtpl->assign( 'URL_DEL', $base_url . "&" . NV_OP_VARIABLE . "=logs_del" );
$xtpl->assign( 'URL_CANCEL', NV_BASE_ADMINURL . "index.php?" . NV_NAME_VARIABLE . "=" . $module_name . "&" . NV_OP_VARIABLE . "=" . $op );
$xtpl->assign( 'DISABLE', $disabled );
$xtpl->assign( 'DATA_SEARCH', $data_search );
$xtpl->assign( 'DATA_ORDER', $order );

foreach ( $array_lang as $lang )
{
	$xtpl->assign( 'lang', $lang );
	$xtpl->parse( 'main.lang' );
}

foreach ( $array_module as $module )
{
	$xtpl->assign( 'module', $module );
	$xtpl->parse( 'main.module' );
}

foreach ( $array_user as $user )
{
	$xtpl->assign( 'user', $user );
	$xtpl->parse( 'main.user' );
}

$a = 0;
foreach ( $data as $data_i )
{
    if ( ! empty( $data_users[$data_i['userid']] ) )
    {
        $data_i['username'] = $data_users[$data_i['userid']];
    }
    else
    {
        $data_i['username'] = "unknown";
    }
	
    $xtpl->assign( 'DATA', $data_i );
    $xtpl->assign( 'CLASS', $a % 2 == 1 ? " class=\"second\"" : "" );
    $xtpl->assign( 'DEL_URL', NV_BASE_ADMINURL . "index.php?" . NV_NAME_VARIABLE . "=" . $module_name . "&amp;" . NV_OP_VARIABLE . "=log&amp;" . NV_OP_VARIABLE . "=logs_del&amp;id=" . $data_i['id'] );
    $xtpl->assign( 'BACK_URL', $base_url );
    $xtpl->parse( 'main.row' );
    $a ++;
}

$generate_page = nv_generate_page( $base_url, $all_page, $per_page, $page );
if ( ! empty( $generate_page ) )
{
    $xtpl->assign( 'GENERATE_PAGE', $generate_page );
    $xtpl->parse( 'main.generate_page' );
}

$xtpl->parse( 'main' );
$contents = $xtpl->text( 'main' );

include ( NV_ROOTDIR . "/includes/header.php" );
echo nv_admin_theme( $contents );
include ( NV_ROOTDIR . "/includes/footer.php" );

?>