📄 log_mag.php
字号:
<?
require "inc/func.php";
//require "connect.inc";
require "inc/error.php";
//check_login();
?>
<html>
<head>
<title>“天勤”网站后台管理系统</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<STYLE type=text/css>BODY {
FONT-FAMILY: "宋体"; FONT-SIZE: 12px; scrollbar-face-color: ffffff; scrollbar-shadow-color: C1C1BB; scrollbar-highlight-color: C1C1BB; scrollbar-3dlight-color: EBEBE4; scrollbar-darkshadow-color: EBEBE4; scrollbar-track-color: F4F4F0; scrollbar-arrow-color: CACAB7
}
P {
FONT-FAMILY: "宋体"; FONT-SIZE: 12px
}
INPUT {
FONT-FAMILY: "宋体"; FONT-SIZE: 12px
}
FONT {
FONT-FAMILY: "宋体"; FONT-SIZE: 12px
}
SELECT {
FONT-FAMILY: "宋体"; FONT-SIZE: 12px
}
OPTION {
FONT-FAMILY: "宋体"; FONT-SIZE: 12px
}
TEXTAREA {
FONT-FAMILY: "宋体"; FONT-SIZE: 12px
}
FORM {
FONT-FAMILY: "宋体"; FONT-SIZE: 12px
}
TD {
FONT-FAMILY: "宋体"; FONT-SIZE: 12px; TABLE-LAYOUT: fixed; WORD-BREAK: break-all
}
A:link {
TEXT-DECORATION: none
}
A:visited {
TEXT-DECORATION: none
}
A:hover {
TEXT-DECORATION: underline
}
A:active {
FONT-SIZE: 12px; TEXT-DECORATION: none
}
.border {
BACKGROUND-COLOR: #efefef; BORDER-BOTTOM: 1px dotted; BORDER-COLLAPSE: collapse; BORDER-LEFT: 1px dotted; BORDER-RIGHT: 1px dotted; BORDER-TOP: 1px dotted; COLOR: #000000
}
.shadow1 {
COLOR: #ffffff; FILTER: dropshadow(color=#000000,offx=1,offy=1); FONT-SIZE: 12px
}
.shadow2 {
COLOR: #000000; FILTER: dropshadow(color=#d5d5d5,offx=1,offy=1); FONT-SIZE: 12px
}
.p1 {
COLOR: #ffffff; FONT-SIZE: 12px; TEXT-DECORATION: none
}
.p2 {
COLOR: #000000; FONT-SIZE: 12px; TEXT-DECORATION: none
}
.p3 {
COLOR: #004080; FONT-SIZE: 14px; TEXT-DECORATION: none
}
</STYLE>
</head>
<body>
<script language="JavaScript">
<!--
function MM_reloadPage(init) { //reloads the window if Nav4 resized
if (init==true) with (navigator) {if ((appName=="Netscape")&&(parseInt(appVersion)==4)) {
document.MM_pgW=innerWidth; document.MM_pgH=innerHeight; onresize=MM_reloadPage; }}
else if (innerWidth!=document.MM_pgW || innerHeight!=document.MM_pgH) location.reload();
}
MM_reloadPage(true);
// -->
</script>
<!-- search code begin -->
<SCRIPT LANGUAGE="JavaScript">
function checksubmit(cform){
i = cform.obj.options[cform.obj.selectedIndex].value;
cform.action=url_arr[i][1];
for(j=2;j<url_arr[i].length;j+=2){
obj=eval("document.search_form."+url_arr[i][j]);
if(obj)obj.value=url_arr[i][j+1];
}
}
function chg_manu(ser_type){
var subobj=document.form2.ser_type;
alert(subobj.value);
if(""==subobj.value){
if(-1!=(subobj.options[subobj.selectedIndex].text.indexOf("所有"))) return;
subobj.options[subobj.selectedIndex+1].selected=true;
chg_manu(subobj.options[subobj.selectedIndex].value);
return;
}
document.list_manu.location="list_manu.php?ser_type="+ser_type;
}
</SCRIPT>
<center>
<p> </p>
<div align="center">
<table width="100%" border="0" height="95">
<tr>
<td width="75%" height="68" rowspan="5">
<p align="center"><font size="5">日志管理</font></p>
<form name="form2" method="post" action="">
<table width="100%" border="0" height="109">
<tr>
<td width="11%" height="60"> </td>
<td width="78%" height="60" valign="bottom">
<table width="754" border="1" cellpadding="3" cellspacing="0" align="center" bordercolor="#111111" class=border>
<tr >
<td width="138" height="20">
<div align="center"><font color="#000000">查询内容</font></div>
</td>
<td width="82" height="20">
<div align="center"><font color="#000000">操作符</font></div>
</td>
<td width="165" height="20">
<div align="center"><font color="#000000">条件值</font></div>
</td>
<td width="259" height="20">
<div align="center"><font color="#000000">时间限制（yyyy-mm-dd）</font></div>
</td>
</tr>
<tr bgcolor="#f7f7f7">
<td width="138" >
<div align="center">
<select name="ser_type" >
<option value="anyway"></option>
<option value="group_name">组名</option>
<option value="user_name">用户名</option>
<option value="act_type">操作类型</option>
</select>
</div>
</td>
<td width="82">
<div align="center">包含</div>
</td>
<td width="165">
<div align="center"><? //<iframe name=list_manu src="about:<body topmargin=0 leftmargin=0><select><option>↓ 选择所有品牌 ↓</select>" frameborder=0 marginwidth=0 marginheight=0 vspace=0 hspace=0 height=16 width=128 scrolling=no>
//</iframe>?>
<input type="text" name="txtvalue" size="10">
</div>
</td>
<td width="259">从
<input type="text" name="ser_t1" size="10">
到
<input type="text" name="ser_t2" size="10">
</td>
</tr>
</table>
<div align="right"></div>
</td>
<td width="11%" valign="bottom" height="60"><font color="#000000">搜索帮助</font></td>
</tr>
<tr>
<td width="11%"> </td>
<td width="78%">
<br>
<div align="right">
<input type="submit" name="cmdsearc" value="开始查询" >
<input type="reset" name="cmdreset" value="重置本页">
</div>
</td>
<td width="11%"> </td>
</tr>
</table>
</form>
</td>
</tr>
<tr> </tr>
<tr> </tr>
<tr> </tr>
<tr> </tr>
<tr>
<td width="75%" height="70" valign="top">
<div align="right">
<table width="78%" border="0" align="center">
<tr>
<td colspan="3">
<div align="right"> </div>
<?
if(($cmdsearc=="开始查询") or ($temp==1)or($killbtn=="批量删除")or ($action=="del")){
if( (($ser_t1<>"" and $ser_t2<>"")and !(eregi("([0-9]{4})-([0-9]{2})-([0-9]{2})",$ser_t1) and eregi("([0-9]{4})-([0-9]{2})-([0-9]{2})",$ser_t2)))and(($ser_t1<>"" and $ser_t2<>"")and !(eregi("([0-9]{4})/([0-9]{2})/([0-9]{2})",$ser_t1) and eregi("([0-9]{4})/([0-9]{2})/([0-9]{2})",$ser_t2))) and (($ser_t1<>"" and $ser_t2<>"")and !(eregi("([0-9]{4})([0-9]{2})([0-9]{2})",$ser_t1) and eregi("([0-9]{4})([0-9]{2})([0-9]{2})",$ser_t2))) ){
show_msg("输入的日期不合法！<br>正确格式如：2002-6-30或2002/6/30");exit;
}
$ser_t1=str_replace("/","",$ser_t1);
$ser_t2=str_replace("/","",$ser_t2);
$ser_t1=str_replace("-","",$ser_t1);
$ser_t2=str_replace("-","",$ser_t2);
$sqldo_c="select count(*) from operatelog ";
$sqldo="select log_id,user_name,group_name,news_id,news_title,act_type,act_time from operatelog ";
if($ser_type<>"anyway"){ //如果有条件（即不是任意条件）
$sqldo.="where (instr($ser_type,'$txtvalue')>0)" ;
$sqldo_c.="where (instr($ser_type,'$txtvalue')>0)";
if((trim($ser_t1)<>"") and(trim($ser_t2)<>"")){
$ser_t1.="000000";
$ser_t2.="246060";
$sqldo.="and (act_time > '$ser_t1') and (act_time<'$ser_t2') ";
$sqldo_c.="and (act_time > '$ser_t1') and (act_time<'$ser_t2') ";
}
}
else{ //如果是任意条件
if((trim($ser_t1)) and(trim($ser_t2))){
$ser_t1.="000000";
$ser_t2.="246060";
$sqldo.="where (act_time > '$ser_t1') and (act_time<'$ser_t2') " ;
$sqldo_c.="where (act_time > '$ser_t1') and (act_time<'$ser_t2') " ;
}
}
$sqldo.=" order by log_id desc ";
$k=0;
}
?>
<?
if($killbtn=="批量删除"){ //如果是批量删除
$res_array=$cla->db_query($sqldo);
$i=0;
while($res_array[$i][0]){
if(${chk.$res_array[$i][0]}==$res_array[$i][0]){
$lid=$res_array[$i][0];
$sqldodel="delete from operatelog where log_id='$lid'";
//echo "del:".$sqldodel;
$cla->db_delete($sqldodel);
$cla->db_commit();
}
$i++;
}
}
?>
<?
if($action=="del"){ //如果是删除一个日志记录
$sqldodel2="delete from operatelog where log_id='$lid'";
if($cla->db_delete($sqldodel2)){
//echo $sqldodel2;
}
$cla->db_commit();
//echo "shanchu:".$sqldo;
}
?>
<?php //搜索数据库
// echo $sqldo."\n";
/*
if(!$temp){
$sqldo= "select log_id,user_name,group_name,news_id,news_title,act_type,act_time from operatelog where (act_time > '20000909000000') and (act_time<'20090909246060') order by log_id desc ";
$sqldo_c="select count(*) from operatelog where (act_time > '20000909000000') and (act_time<'20090909246060') order by log_id desc ";
}
*/
if($temp==1){
$sqldo=stripslashes($sqldo);
$sqldo_c=stripslashes($sqldo_c);
}
//echo "sqldo：".$sqldo;
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -