📄 search.php
字号:
<?
include_once 'inc/auth.php';
include_once 'inc/check_type.php';
include_once 'inc/utility_all.php';
echo '
<html>
<head>
<title>工作日志查询</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
';
echo '<s';
echo 'cript>
function delete_diary(DIA_ID)
{
msg=\'确认要删除该日的工作日志么？\';
if(window.confirm(msg))
{
URL="delete.php?DIA_ID=" + DIA_ID;
window.location=URL;
}
}
function SaveFile(ATTACHMENT_ID,ATTACHMENT_NAME)
{
URL="/module/save_file?ATTACHMENT_ID="+ATTACHMENT_ID+"&ATTACHMENT_NAME="+ATTACHMENT_NAME+"&A=1";
loc_x=document.body.scrollLeft+event.clientX-event.offsetX-100;
';
echo ' loc_y=document.body.scrollTop+event.clientY-event.offsetY+170;
window.open(URL,null,"height=180,width=400,status=1,toolbar=no,menubar=no,location=no,scrollbars=yes,top="+loc_y+",left="+loc_x+",resizable=yes");
}
</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 ();
}
}
echo '
<div align="center" class="Big1">
<b>[';
echo $USER_NAME;
echo ' - 工作日志查询]</b>
</div>
<br>
<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">';
echo '<s';
echo 'pan class="big3"> 查询结果</span>
</td>
</tr>
</table>
';
($BEGIN_DATE .= '00:00:00');
($END_DATE .= '23:59:59');
$query = (((((((''.'SELECT * from DIARY where DIA_DATE>=\'').$BEGIN_DATE).'\' and DIA_DATE<=\'').$END_DATE).'\' and USER_ID=\'').$USER_ID).'\' and DIA_TYPE!=\'2\'');
if (($SUBJECT != '0'))
{
($query .= (((''.' and SUBJECT like \'%').$SUBJECT).'%\''));
}
($query .= ' order by DIA_DATE 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, ' ');
$SUBJECT = $ROW['SUBJECT'];
$CONTENT = $ROW['CONTENT'];
$ATTACHMENT_ID = $ROW['ATTACHMENT_ID'];
$ATTACHMENT_NAME = $ROW['ATTACHMENT_NAME'];
$FLAG = 0;
if ((($KEY1 != '') AND stristr (strip_tags ($CONTENT), $KEY1)))
{
++$FLAG;
}
if ((($KEY2 != '') AND stristr (strip_tags ($CONTENT), $KEY2)))
{
++$FLAG;
}
if ((($KEY3 != '') AND stristr (strip_tags ($CONTENT), $KEY3)))
{
++$FLAG;
}
if ((($FLAG == 0) AND ((($KEY1 != '') OR ($KEY2 != '')) OR ($KEY3 != ''))))
{
continue;
}
else
{
if (($SUBJECT == ''))
{
$SUBJECT = (csubstr (strip_tags ($CONTENT), 0, 50).((50 < strlen ($CONTENT)) ? '...' : ''));
}
++$DIA_COUNT;
if (($DIA_COUNT == 1))
{
echo '
<table border="0" cellspacing="1" width="95%" class="small" bgcolor="#000000" cellpadding="3">
';
}
if ((($DIA_COUNT % 2) == 1))
{
$TableLine = 'TableLine1';
}
else
{
$TableLine = 'TableLine2';
}
echo ' <tr class="';
echo $TableLine;
echo '">
<td nowrap align="center" width="100">';
echo $DIA_DATE;
echo '</td>
<td><a href="read.php?DIA_ID=';
echo $DIA_ID;
echo '&USER_NAME=';
echo $USER_NAME;
echo '">';
echo $SUBJECT;
echo '</a></td>
<td>
';
if (($ATTACHMENT_NAME != ''))
{
$ATTACHMENT_ID_ARRAY = explode (',', $ATTACHMENT_ID);
$ATTACHMENT_NAME_ARRAY = explode ('*', $ATTACHMENT_NAME);
$ARRAY_COUNT = sizeof ($ATTACHMENT_ID_ARRAY);
for ($I = 0; ($I < ($ARRAY_COUNT - 1)); ++$I)
{
$ATTACH_SIZE = attach_size ($ATTACHMENT_ID_ARRAY[$I], $ATTACHMENT_NAME_ARRAY[$I]);
$ATTACH_SIZE = number_format ($ATTACH_SIZE, 0, '.', ',');
echo ' <img src="/images/email_atta.gif" align="absmiddle"><a href="/inc/attach.php?ATTACHMENT_ID=';
echo (($ATTACHMENT_ID_ARRAY[$I] * 3) + 2);
echo '&ATTACHMENT_NAME=';
echo urlencode ($ATTACHMENT_NAME_ARRAY[$I]);
echo '">';
echo $ATTACHMENT_NAME_ARRAY[$I];
echo '</a>
(';
echo $ATTACH_SIZE;
echo '字节)
<input type="button" value="转存" class="SmallButton" onClick="SaveFile(\'';
echo (($ATTACHMENT_ID_ARRAY[$I] * 3) + 2);
echo '\',\'';
echo urlencode ($ATTACHMENT_NAME_ARRAY[$I]);
echo '\');">
';
if (((stristr ($ATTACHMENT_NAME_ARRAY[$I], '.doc') OR stristr ($ATTACHMENT_NAME_ARRAY[$I], '.ppt')) OR stristr ($ATTACHMENT_NAME_ARRAY[$I], '.xls')))
{
echo ' <input type="button" value="阅读" class="SmallButton" onClick="window.open(\'/module/OC?ATTACHMENT_ID=';
echo (($ATTACHMENT_ID_ARRAY[$I] * 3) + 2);
echo '&ATTACHMENT_NAME=';
echo urlencode ($ATTACHMENT_NAME_ARRAY[$I]);
echo '&OP=5&PRINT=1\',\'';
echo $ATTACHMENT_ID_ARRAY[$I];
echo '\',\'menubar=0,toolbar=0,status=1,scrollbars=1,resizable=1\');">
';
}
else
{
if (is_media ($ATTACHMENT_NAME_ARRAY[$I]))
{
echo ' <input type="button" value="播放" class="SmallButton" onClick="window.open(\'/module/mediaplayer/index.php?MEDIA_NAME=';
echo urlencode ($ATTACHMENT_NAME_ARRAY[$I]);
echo '&MEDIA_URL=';
echo urlencode (((('/inc/attach.php?ATTACHMENT_ID='.(($ATTACHMENT_ID_ARRAY[$I] * 3) + 2)).'&ATTACHMENT_NAME=').urlencode ($ATTACHMENT_NAME_ARRAY[$I])));
echo '\',\'media';
echo $ATTACHMENT_ID_ARRAY[$I];
echo '\',\'menubar=0,toolbar=0,status=1,scrollbars=1,resizable=1\');">
';
}
}
echo '<br>';
}
}
echo ' </td>
<td nowrap align="center" width="60"><a href="comment.php?DIA_ID=';
echo $DIA_ID;
echo '&USER_ID=';
echo $USER_ID;
echo '">点评</a></td>
</tr>
';
continue;
}
}
if (($DIA_COUNT == 0))
{
message ('', '无符合条件的日志记录');
}
else
{
echo ' <thead class="TableHeader">
<td nowrap align="center">日期 <img border=0 src="/images/arrow_down.gif" width="11" height="10"></td>
<td nowrap align="center">日志标题</td>
<td nowrap align="center">附件</td>
<td nowrap align="center">操作</td>
</thead>
</table>
';
}
echo '
<br>
';
if ((0 < $DIA_COUNT))
{
message ('', (('共 '.$DIA_COUNT).' 篇日志'));
}
echo '<div align="center">
<input type="button" value="返回" class="BigButton" onClick="location=\'user_diary.php?USER_ID=';
echo $USER_ID;
echo '&USER_NAME=';
echo $USER_NAME;
echo '\';">
</div>
</body>
</html>
';
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -