user_search.php
来自「通达OA官方提供的30源代码,感觉很实在」· PHP 代码 · 共 168 行
PHP
168 行
<?
include_once("inc/auth.php");
include_once("inc/check_type.php");
include_once("inc/utility_all.php");
include_once("inc/utility_file.php");
include_once("inc/utility_org.php");
$PRIV_NO_FLAG=2;
$MODULE_ID="4";
include_once("inc/my_priv.php");
?>
<html>
<head>
<title>工作日志查询</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<script src="/inc/js/attach.js"></script>
</head>
<body class="bodycolor" topmargin="5">
<?
//----------- 合法性校验 ---------
if($BEGIN_DATE!="")
{
$TIME_OK=is_date($BEGIN_DATE);
if(!$TIME_OK)
{ Message("错误","起始日期格式不对，应形如 1999-1-2");
Button_Back();
exit;
}
}
if($END_DATE!="")
{
$TIME_OK=is_date($END_DATE);
if(!$TIME_OK)
{ Message("错误","截止日期格式不对，应形如 1999-1-2");
Button_Back();
exit;
}
}
?>
<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
<tr>
<td class="Big"><img src="/images/menu/diary.gif" WIDTH="18" HEIGHT="18" align="absmiddle"><span class="big3"> 查询结果</span>
</td>
</tr>
</table>
<?
$WHERE_STR="";
if($BEGIN_DATE!="")
{
$URL_BEGIN_DATE = $BEGIN_DATE;
$BEGIN_DATE.=" 00:00:00";
$WHERE_STR = " and DIA_DATE >= '$BEGIN_DATE'";
}
if($END_DATE!="")
{
$URL_END_DATE = $END_DATE;
$END_DATE.=" 23:59:59";
$WHERE_STR .= " and DIA_DATE <= '$END_DATE'";
}
if($SUBJECT!="")
{
$URL_SUBJECT = $SUBJECT;
$WHERE_STR .= " and SUBJECT like '%$SUBJECT%'";
}
if($TO_ID!="")
{
$WHERE_STR .= " and find_in_set(USER_ID,'$TO_ID')";
}
//============================ 显示日志 =======================================
$query = "SELECT DIA_ID,DIA_DATE,DIA_TYPE,SUBJECT,CONTENT,ATTACHMENT_ID,ATTACHMENT_NAME,LAST_COMMENT_TIME,USER_ID from DIARY where DIA_TYPE='1' ".$WHERE_STR;
$query .= " order by DIA_DATE desc,DIA_ID desc";
$cursor= exequery($connection,$query);
$DIA_COUNT=0;
while($ROW=mysql_fetch_array($cursor))
{
$DIA_ID=$ROW["DIA_ID"];
$DIA_DATE=$ROW["DIA_DATE"];
$DIA_DATE=strtok($DIA_DATE," ");
$DIA_TYPE=$ROW["DIA_TYPE"];
$SUBJECT=$ROW["SUBJECT"];
$CONTENT=$ROW["CONTENT"];
$USER_ID=$ROW["USER_ID"];
if(!is_user_priv($USER_ID, $MY_PRIV))
continue;
$DIA_COUNT++;
$query1 = "SELECT USER_NAME from USER where USER_ID='$USER_ID'";
$cursor1= exequery($connection,$query1);
if($ROW1=mysql_fetch_array($cursor1))
$USER_NAME=$ROW1["USER_NAME"];
$ATTACHMENT_ID=$ROW["ATTACHMENT_ID"];
$ATTACHMENT_NAME=$ROW["ATTACHMENT_NAME"];
if($SUBJECT=="")
$SUBJECT=csubstr(strip_tags($CONTENT),0,30).(strlen($CONTENT)>30?"...":"");
$query1 = "SELECT count(*) from DIARY_COMMENT where DIA_ID='$DIA_ID'";
$cursor1= exequery($connection,$query1);
if($ROW1=mysql_fetch_array($cursor1))
$COMMENT_COUNT=$ROW1[0];
if($DIA_COUNT==1)
{
?>
<table class="TableList" width="95%" align="center">
<?
}
if($DIA_COUNT%2==1)
$TableLine="TableLine1";
else
$TableLine="TableLine2";
?>
<tr class="<?=$TableLine?>">
<td nowrap align="center"><?=$DIA_DATE?></td>
<td nowrap align="center" width="60"><?=$USER_NAME?></td>
<td><a href="read.php?DIA_ID=<?=$DIA_ID?>&FROM=1&USER_NAME=<?=urlencode($USER_NAME)?>&BEGIN_DATE=<?=$URL_BEGIN_DATE?>&END_DATE=<?=$URL_END_DATE?>&SUBJECT=<?=urlencode($URL_SUBJECT)?>"><?=$SUBJECT?></a></td>
<td><?=attach_link($ATTACHMENT_ID,$ATTACHMENT_NAME,0,1,1)?></td>
<td width="30"><a href="comment.php?DIA_ID=<?=$DIA_ID?>&USER_ID=<?=$USER_ID?>&FROM=1&USER_NAME=<?=urlencode($USER_NAME)?>&BEGIN_DATE=<?=$URL_BEGIN_DATE?>&END_DATE=<?=$URL_END_DATE?>&SUBJECT=<?=urlencode($URL_SUBJECT)?>">点评</a></td>
</tr>
<?
}//while
if($DIA_COUNT==0)
{
Message("","无符合条件的日志记录");
}
else
{
?>
<thead class="TableHeader">
<td nowrap align="center" width="80">日期 <img border=0 src="/images/arrow_down.gif" width="11" height="10"></td>
<td nowrap align="center" width="50">作者</td>
<td nowrap align="center">日志标题</td>
<td nowrap align="center">附件</td>
<td nowrap align="center" width="30">操作</td>
</thead>
</table>
<?
}
if($DIA_COUNT > 0)
{
Message("","共 ".$DIA_COUNT." 篇日志");
}
?>
<div align="center">
<input type="button" value="返回" class="BigButton" onClick="location='user_query.php';">
</div>
</body>
</html>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?