search.php
来自「通达OA2007SE源代码 非常好的」· PHP 代码 · 共 307 行
PHP
307 行
<?
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 check_all()
{
if(!document.all("email_select"))
return;
for (i=0;i<document.all("email_select").length;i++)
{
if(document.all("allbox").checked)
document.all("email_select").item(i).checked=true;
else
document.all("email_select").item(i).checked=false;
}
if(i==0)
{
if(document.all("allbox").checked)
document.all("email_select").c';
echo 'hecked=true;
else
document.all("email_select").checked=false;
}
}
function check_one(el)
{
if(!el.checked)
document.all("allbox").checked=false;
}
function delete_mail()
{
delete_str="";
for(i=0;i<document.all("email_select").length;i++)
{
el=document.all("email_select").item(i);
if(el.checked)
{ val=el.value;
delete_str+=va';
echo 'l + ",";
}
}
if(i==0)
{
el=document.all("email_select");
if(el.checked)
{ val=el.value;
delete_str+=val + ",";
}
}
if(delete_str=="")
{
alert("要删除日志，请至少选择其中一条。");
return;
}
msg=\'确认要删除所选日志么？\';
if(window.confirm(msg))
{
url="delete.php?DELETE_STR="+ delete_str +"&PAGE_START=';
echo $PAGE_START;
echo '&BOX_ID=';
echo $BOX_ID;
echo '";
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;
loc_y=document.body.scrollTop+event.clientY-event.offsetY+170;
window.open(URL,null,"height=180,width=400,status=1,toolbar=no,menubar=no,locatio';
echo 'n=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 ();
}
}
$query1 = 'SELECT * from SYS_PARA where PARA_NAME=\'LOCK_TIME\'';
$cursor1 = exequery ($connection, $query1);
if ($ROW1 = mysql_fetch_array ($cursor1))
{
$PARA_VALUE = $ROW1['PARA_VALUE'];
$PARA_VALUE = explode (',', $PARA_VALUE);
$W_START = $PARA_VALUE[0];
$W_END = $PARA_VALUE[1];
$DAYS = intval ($PARA_VALUE[2]);
}
echo '
<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>
';
$CUR_DATE = date ('Y-m-d', time ());
($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=\'').$LOGIN_USER_ID).'\'');
if (($DIA_TYPE != '0'))
{
($query .= (((''.' and DIA_TYPE=\'').$DIA_TYPE).'\''));
}
if (($SUBJECT != ''))
{
($query .= (((''.' and SUBJECT like \'%').$SUBJECT).'%\''));
}
if (($ATTACHMENT_NAME != ''))
{
($query .= (((''.' and ATTACHMENT_NAME like \'%').$ATTACHMENT_NAME).'%\''));
}
($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, ' ');
$DIA_TYPE = $ROW['DIA_TYPE'];
$SUBJECT = $ROW['SUBJECT'];
$CONTENT = $ROW['CONTENT'];
$ATTACHMENT_ID = $ROW['ATTACHMENT_ID'];
$ATTACHMENT_NAME = $ROW['ATTACHMENT_NAME'];
if (($SUBJECT == ''))
{
$SUBJECT = (csubstr (strip_tags ($CONTENT), 0, 50).((50 < strlen ($CONTENT)) ? '...' : ''));
}
$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
{
++$DIA_COUNT;
$DIA_TYPE_DESC = get_code_name ($DIA_TYPE, 'DIARY_TYPE');
$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))
{
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">
';
if (((($DAYS == 0) OR (date ('Y-m-d', time ()) < date ('Y-m-d', strtotime ((('+'.$DAYS).'day'), strtotime ($DIA_DATE))))) AND ((((($W_START == '') AND ($W_END == '')) OR ((($W_START == '') AND ($W_END != '')) AND (compare_date ($DIA_DATE, $W_END) == 1))) OR ((($W_START != '') AND ($W_END == '')) AND (compare_date ($W_START, $DIA_DATE) == 1))) OR ((($W_START != '') AND ($W_END != '')) AND ((compare_date ($DIA_DATE, $W_END) == 1) OR (compare_date ($W_START, $DIA_DATE) == 1))))))
{
echo ' <input type="checkbox" name="email_select" value="';
echo $DIA_ID;
echo '" onClick="check_one(self);">
';
}
echo ' </td>
<td nowrap align="center">';
echo $DIA_DATE;
echo '</td>
<td nowrap align="center">';
echo $DIA_TYPE_DESC;
echo '</td>
<td><a href="read.php?DIA_ID=';
echo $DIA_ID;
echo '">';
echo $SUBJECT;
echo '</a></td>
<td>';
echo attach_link ($ATTACHMENT_ID, $ATTACHMENT_NAME, 0, 1, 1);
echo '<td nowrap align="center">
';
if ((0 < $COMMENT_COUNT))
{
echo ' <a href="read.php?DIA_ID=';
echo $DIA_ID;
echo '">查看</a>
';
}
echo ' </td>
<td nowrap align="center">
';
if (((($DAYS == 0) OR (date ('Y-m-d', time ()) < date ('Y-m-d', strtotime ((('+'.$DAYS).'day'), strtotime ($DIA_DATE))))) AND ((((($W_START == '') AND ($W_END == '')) OR ((($W_START == '') AND ($W_END != '')) AND (compare_date ($DIA_DATE, $W_END) == 1))) OR ((($W_START != '') AND ($W_END == '')) AND (compare_date ($W_START, $DIA_DATE) == 1))) OR ((($W_START != '') AND ($W_END != '')) AND ((compare_date ($DIA_DATE, $W_END) == 1) OR (compare_date ($W_START, $DIA_DATE) == 1))))))
{
echo ' <a href="edit.php?DIA_ID=';
echo $DIA_ID;
echo '">编辑</a>
';
}
echo ' </td>
</tr>
';
continue;
}
}
if (($DIA_COUNT == 0))
{
message ('', '无符合条件的日志记录');
}
else
{
echo ' <thead class="TableHeader">
<td nowrap align="center" width="40">选择</td>
<td nowrap align="center" width="80">日期 <img border=0 src="/images/arrow_down.gif" width="11" height="10"></td>
<td nowrap align="center" width="100">日志类型</td>
<td nowrap align="center">日志标题</td>
<td nowrap align="center">附件</td>
<td nowrap align="center" width="40">点评</td>
<td no';
echo 'wrap align="center" width="40">操作</td>
</thead>
<tr class="TableControl">
<td colspan="7">
<input type="checkbox" name="allbox" id="allbox_for" onClick="check_all();">
<label for="allbox_for">全选</label>
<input type="button" value="删除" class="SmallButton" onClick="delete_mail();" title="删除所选日志">
</td>
</tr>
</table>
';
}
session_start ();
$QUERY_DIARY = $query;
if (!session_is_registered ('QUERY_DIARY'))
{
session_register ('QUERY_DIARY');
}
if ((0 < $DIA_COUNT))
{
message ('', (('共 '.$DIA_COUNT).' 篇日志'));
}
echo '
<div align="center">
';
if ((0 < $DIA_COUNT))
{
echo '<input type="button" value="导出" class="BigButton" onClick="window.open(\'export.php?KEY1=';
echo $KEY1;
echo '&KEY2=';
echo $KEY2;
echo '&KEY3=';
echo $KEY3;
echo '\');" title="导出word文件">
';
}
echo ' <input type="button" value="返回" class="BigButton" onClick="location=\'index.php\';">
</div>
</body>
</html>
';
?>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?