⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 listdolog.php

📁 一、超强系统模型扩展功能 EmpireCMS卓越之处在于：不仅提供了网站管理功能
💻 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");

//删除日志
function DelDoLog($logid,$userid,$username){
	global $empire,$dbtbpre;
	//验证权限
	CheckLevel($userid,$username,$classid,"log");
	$logid=(int)$logid;
	if(!$logid)
	{printerror("NotDelLogid","history.go(-1)");}
	$sql=$empire->query("delete from {$dbtbpre}enewsdolog where logid='$logid'");
	if($sql)
	{
		//操作日志
		insert_dolog("logid=".$logid);
		printerror("DelLogSuccess","ListDolog.php");
	}
	else
	{
		printerror("DbError","history.go(-1)");
	}
}

//批量删除日志
function DelDoLog_all($logid,$userid,$username){
	global $empire,$dbtbpre;
	//验证权限
	CheckLevel($userid,$username,$classid,"log");
	$count=count($logid);
	if(!$count)
	{printerror("NotDelLogid","history.go(-1)");}
	for($i=0;$i<$count;$i++)
	{
		$add.=" logid='$logid[$i]' or";
	}
	$add=substr($add,0,strlen($add)-3);
	$sql=$empire->query("delete from {$dbtbpre}enewsdolog where".$add);
	if($sql)
	{
		//操作日志
		insert_dolog("");
		printerror("DelLogSuccess","ListDolog.php");
	}
	else
	{
		printerror("DbError","history.go(-1)");
	}
}

//日期删除日志
function DelDoLog_date($start_y,$start_m,$start_d,$end_y,$end_m,$end_d,$uname,$userid,$username){
	global $empire,$dbtbpre;
	//验证权限
	CheckLevel($userid,$username,$classid,"log");
	$start=RepPostVar($start_y.$start_m.$start_d);
	$end=RepPostVar($end_y.$end_m.$end_d);
	$add="";
	if($uname)
	{
		$add.=" and username='$uname'";
    }
	$sql=$empire->query("delete from {$dbtbpre}enewsdolog where logtime<'$end' and logtime>'$start'".$add);
	if($sql)
	{
		//操作日志
		insert_dolog("username=$uname&time=".$start."-".$end);
		printerror("DelLogSuccess","ListDolog.php");
	}
	else
	{
		printerror("DbError","history.go(-1)");
	}
}

$enews=$_POST['enews'];
if(empty($enews))
{$enews=$_GET['enews'];}
//删除日志
if($enews=="DelDoLog")
{
	$logid=$_GET['logid'];
	DelDoLog($logid,$logininid,$loginin);
}
//批量删除日志
elseif($enews=="DelDoLog_all")
{
	$logid=$_POST['logid'];
	DelDoLog_all($logid,$logininid,$loginin);
}

$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=RepPostVar($start_y.$start_m.$start_d);
	$end=RepPostVar($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++)
{
	$selected='';
	if($i==$thisyear)
	{
		$selected=' selected';
	}
	$yearoption.="<option value='".$i."'".$selected.">".$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="100%" border="0" align="center" cellpadding="3" cellspacing="1">
  <tr> 
    <td width="50%">位置：日志管理 &gt; <a href="ListDolog.php">管理操作日志</a></td>
    <td><div align="right">
        <input type="button" name="Submit5" value="管理登陆日志" onclick="self.location.href='ListLog.php';">
      </div></td>
  </tr>
</table>
  
<br>
<table width="100%" 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="ListDolog.php" onsubmit="return confirm('确认要删除?');">
  <table width="100%" 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=ListDolog.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?>&nbsp;&nbsp;
        <input type="submit" name="Submit" value="批量删除"> <input name="enews" type="hidden" id="phome" value="DelDoLog_all">&nbsp;
        <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 + -