📄 listdolog.php
字号:
<?php
require("../../class/connect.php");
include("../../class/db_sql.php");
include("../../class/config.php");
include("../../class/functions.php");
include("../../class/class.php");
include "../".LoadLang("pub/enews.php");
include "../".LoadLang("pub/fun.php");
$link=db_connect();
$empire=new mysqlquery();
$logininid=getcvar('loginuserid');
$loginin=getcvar('loginusername');
$loginrnd=getcvar('loginrnd');
$loginlevel=getcvar('loginlevel');
$editor=1;
is_login($logininid,$loginin,$loginrnd);
//验证权限
CheckLevel($logininid,$loginin,$classid,"log");
$line=20;//每页显示条数
$page_line=18;//每页显示链接数
$page=(int)$_GET['page'];
$start=(int)$_GET['start'];
$offset=$start+$page*$line;//总偏移量
$query="select * from {$dbtbpre}enewsdolog";
$totalquery="select count(*) as total from {$dbtbpre}enewsdolog";
$username=$_GET['username'];
if(empty($username))
{
$username=$_POST['username'];
}
$username=RepPostVar($username);
//搜索
$doing=$_GET['doing'];
if(empty($doing))
{$doing=$_POST['doing'];}
if($doing=="del")
{
$start_y=$_POST['start_y'];
$start_m=$_POST['start_m'];
$start_d=$_POST['start_d'];
$end_y=$_POST['end_y'];
$end_m=$_POST['end_m'];
$end_d=$_POST['end_d'];
DelDoLog_date($start_y,$start_m,$start_d,$end_y,$end_m,$end_d,$username,$logininid,$loginin);}
elseif($doing=="search")
{
$start_y=$_POST['start_y'];
$start_m=$_POST['start_m'];
$start_d=$_POST['start_d'];
$end_y=$_POST['end_y'];
$end_m=$_POST['end_m'];
$end_d=$_POST['end_d'];
if(empty($start_y))
{
$start_y=$_GET['start_y'];
$start_m=$_GET['start_m'];
$start_d=$_GET['start_d'];
$end_y=$_GET['end_y'];
$end_m=$_GET['end_m'];
$end_d=$_GET['end_d'];
}
$start1=$start_y.$start_m.$start_d;
$end=$end_y.$end_m.$end_d;
$a="";
if($username)
{
$a=" and username='$username'";
}
$where=" where logtime<'$end' and logtime>'$start1'".$a;
$query.=$where;
$totalquery.=$where;
$search="&doing=search&username=$username&start_y=$start_y&start_m=$start_m&start_d=$start_d&end_y=$end_y&end_m=$end_m&end_d=$end_d";
//$query.=" where username like '%$keyboard%'";
//$search="&sear=1&keyboard=".$keyboard;
}
else
{}
$num=$empire->gettotal($totalquery);//取得总条数
$query=$query." order by logid desc limit $offset,$line";
$sql=$empire->query($query);
$returnpage=page1($num,$line,$page_line,$start,$page,$search);
//返回年
$thisyear=date("Y");
for($i=2003;$i<=$thisyear+1;$i++)
{
$yearoption.="<option value='".$i."'>".$i."</option>";
}
//用户
$usql=$empire->query("select username from {$dbtbpre}enewsuser order by userid");
while($ur=$empire->fetch($usql))
{
$select="";
if($ur['username']==$username)
{
$select=" selected";
}
$user.="<option value='".$ur[username]."'".$select.">".$ur[username]."</option>";
}
//风格
$loginadminstyleid=(int)getcvar('loginadminstyleid');
?>
<link href="../adminstyle/<?=$loginadminstyleid?>/adminstyle.css" rel="stylesheet" type="text/css">
<script>
function CheckAll(form)
{
for (var i=0;i<form.elements.length;i++)
{
var e = form.elements[i];
if (e.name != 'chkall')
e.checked = form.chkall.checked;
}
}
</script>
<table width="98%" border="0" align="center" cellpadding="3" cellspacing="1">
<tr>
<td>位置:日志管理 -> <a href="ListDolog.php">管理操作日志</a> (<a href=ListLog.php>管理登陆日志</a>)</td>
</tr>
</table>
<br>
<table width="98%" align=center cellpadding=0 cellspacing=0>
<form name=form1 method=post action='ListDolog.php' onsubmit="return confirm('确认要执行此操作?');">
<input type=hidden name=phome value=DelDoLog_date>
<tr>
<td height="25"> <div align="center"><font color=#333333>操作:
<select name=start_y size=1>
<?=$yearoption?>
</select>
年
<select name=start_m size=1>
<option value=01>1</option>
<option value=02>2</option>
<option value=03>3</option>
<option value=04>4</option>
<option value=05>5</option>
<option value=06>6</option>
<option value=07>7</option>
<option value=08>8</option>
<option value=09>9</option>
<option value=10>10</option>
<option value=11>11</option>
<option value=12>12</option>
</select>
月
<select name=start_d size=1>
<option value=01>1</option>
<option value=02>2</option>
<option value=03>3</option>
<option value=0>4</option>
<option value=05>5</option>
<option value=06>6</option>
<option value=07>7</option>
<option value=08>8</option>
<option value=09>9</option>
<option value=10>10</option>
<option value=11>11</option>
<option value=12>12</option>
<option value=13>13</option>
<option value=14>14</option>
<option value=15>15</option>
<option value=16>16</option>
<option value=17>17</option>
<option value=18>18</option>
<option value=19>19</option>
<option value=20>20</option>
<option value=21>21</option>
<option value=22>22</option>
<option value=23>23</option>
<option value=24>24</option>
<option value=25>25</option>
<option value=26>26</option>
<option value=27>27</option>
<option value=28>28</option>
<option value=29>29</option>
<option value=30>30</option>
<option value=31>31</option>
</select>
日---到---
<select name=end_y size=1>
<?=$yearoption?>
</select>
年
<select name=end_m size=1>
<option value=01>1</option>
<option value=02>2</option>
<option value=03>3</option>
<option value=04>4</option>
<option value=05>5</option>
<option value=06>6</option>
<option value=07>7</option>
<option value=08>8</option>
<option value=09>9</option>
<option value=10>10</option>
<option value=11>11</option>
<option value=12>12</option>
</select>
月
<select name=end_d size=1>
<option value=01>1</option>
<option value=02>2</option>
<option value=03>3</option>
<option value=04>4</option>
<option value=05>5</option>
<option value=06>6</option>
<option value=07>7</option>
<option value=08>8</option>
<option value=09>9</option>
<option value=10>10</option>
<option value=11>11</option>
<option value=12>12</option>
<option value=13>13</option>
<option value=14>14</option>
<option value=15>15</option>
<option value=16>16</option>
<option value=17>17</option>
<option value=18>18</option>
<option value=19>19</option>
<option value=20>20</option>
<option value=21>21</option>
<option value=22>22</option>
<option value=23>23</option>
<option value=24>24</option>
<option value=25>25</option>
<option value=26>26</option>
<option value=27>27</option>
<option value=28>28</option>
<option value=29>29</option>
<option value=30>30</option>
<option value=31>31</option>
</select>
日的日志</font></div></td>
</tr>
<tr>
<td height="25"><div align="center">用户:
<select name="username">
<option value="">所有用户</option>
<?=$user?>
</select>
</div></td>
</tr>
<tr>
<td height="25"> <div align=center>
<input name="doing" type="radio" value="search" checked>
查询日志
<input type="radio" name="doing" value="del">
删除日志
<input name=do type=submit id="do" value=执行操作>
</div></td>
</tr>
</form>
</table>
<form name="form2" method="post" action="../enews.php" onsubmit="return confirm('确认要删除?');">
<table width="98%" border="0" align="center" cellpadding="0" cellspacing="1">
<tr class="header">
<td width="8%">
<div align="center">ID</div></td>
<td width="24%" height="25">
<div align="center">操作者</div></td>
<td width="23%" height="25">
<div align="center">IP</div></td>
<td width="27%">
<div align="center">操作时间</div></td>
<td width="18%" height="25">
<div align="center">删除</div></td>
</tr>
<?
while($r=$empire->fetch($sql))
{
?>
<tr bgcolor="#DBEAF5" id=log<?=$r[logid]?>>
<td>
<div align="center"><?=$r[logid]?></div></td>
<td height="25">
<div align="center">
<?=$r[username]?>
</div></td>
<td height="25">
<div align="center">
<?=$r[logip]?>
</div></td>
<td>
<div align="center">
<?=$r[logtime]?>
</div></td>
<td height="25">
<div align="center">[<a href=../enews.php?enews=DelDoLog&logid=<?=$r[logid]?> onclick="return confirm('确认要删除此日志?');">删除</a>
<input name="logid[]" type="checkbox" id="logid[]" value="<?=$r[logid]?>" onclick="if(this.checked){log<?=$r[logid]?>.style.backgroundColor='#cccccc';}else{log<?=$r[logid]?>.style.backgroundColor='#DBEAF5';}">
]</div></td>
</tr>
<tr bgcolor="#FFFFFF">
<td height="25" colspan="5"><table width="100%" border="0" cellspacing="1" cellpadding="3">
<tr>
<td width="9%">动作:</td>
<td width="25%"><?=$enews_r[$r[enews]]?></td>
<td width="10%">操作对像:</td>
<td width="56%"><?=$r[doing]?></td>
</tr>
</table></td>
</tr>
<?
}
?>
<tr bgcolor="#FFFFFF">
<td height="25" colspan="5">
<?=$returnpage?>
<input type="submit" name="Submit" value="批量删除"> <input name="enews" type="hidden" id="phome" value="DelDoLog_all">
<input type=checkbox name=chkall value=on onClick=CheckAll(this.form)>
选中全部 </td>
</tr>
</table>
</form>
<?
db_close();
$empire=null;
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -