index.php
来自「通达OA2007SE源代码 非常好的」· PHP 代码 · 共 313 行
PHP
313 行
<?
include_once 'inc/auth.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 CheckForm()
{
if(document.form1.BEGIN_DATE.value=="")
{ alert("起始日期不能为空!");
return (false);
}
if(document.form1.END_DATE.value=="")
{ alert("截止日期不能为空!");
return (false);
}
return true;
}
function td_calendar(fieldname)
{
myleft=document.body.scrollLeft+event.clientX-event.offsetX-80;
mytop=document.body.scro';
echo 'llTop+event.clientY-event.offsetY+140;
window.showModalDialog("/inc/calendar.php?FIELDNAME="+fieldname,self,"edge:raised;scroll:0;status:0;help:0;resizable:1;dialogWidth:280px;dialogHeight:215px;dialogTop:"+mytop+"px;dialogLeft:"+myleft+"px");
}
function check_all()
{
if(!document.all("email_select"))
return;
for (i=0;i<document.all("email_select").length;i++)
{
if(document.a';
echo 'll("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").checked=true;
else
document.all("email_select").checked=false;
}
}
function check_one(el)
{
if(!el.checked)
document.all("allbo';
echo 'x").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+=val + ",";
}
}
if(i==0)
{
el=document.all("email_select");
if(el.checked)
{ val=el.value;
delete_str+=val +';
echo ' ",";
}
}
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">
<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><br>
</td>
</tr>
</table>
<div align="center">
<input type="button" value="新建日志" class="BigButton" onClick="location=\'new\';" title="新建工作日志">
</div>
<br>
<table width="95%" border="0" cellspacing="0" cellpadding="0" height="3">
<tr>
<td background="/images/dian1.gif" width="100%"></td>
</tr>
</table>
<table border="0" width="100%" cellspaci';
echo 'ng="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"> 最近的10篇日志</span>
</td>
</tr>
</table>
';
$BEGIN_DATE = date ('Y-m-01', time ());
$CUR_DATE = date ('Y-m-d', time ());
$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]);
}
$query = (((''.'SELECT * from DIARY where USER_ID=\'').$LOGIN_USER_ID).'\' order by DIA_DATE desc,DIA_ID desc limit 0,10');
$cursor = exequery ($connection, $query);
$DIA_COUNT = 0;
while ($ROW = mysql_fetch_array ($cursor))
{
++$DIA_COUNT;
$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)) ? '...' : ''));
}
$DIA_TYPE_DESC = get_code_name ($DIA_TYPE, 'DIARY_TYPE');
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';
}
$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];
}
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>
<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>
';
}
if (($DIA_COUNT == 0))
{
message ('', '无日志记录');
exit ();
}
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>
';
echo ' <td nowrap 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>
';
}
echo '
<br>
<table width="95%" border="0" cellspacing="0" cellpadding="0" height="3">
<tr>
<td background="/images/dian1.gif" width="100%"></td>
</tr>
</table>
<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>
<table border="0" width="400" cellpadding="2" cellspacing="1" align="center" bgcolor="#000000" class="small">
<form action="search.php" name="form1" onsubmit="return CheckForm();">
<tr>
<td nowrap class="TableData">起始日期:</td>
<td class="TableData"><input type="text" name="BEGIN_DATE" size="10" maxlength="10" class';
echo '="BigInput" value="';
echo $BEGIN_DATE;
echo '">
<img src="/images/menu/calendar.gif" border="0" style="cursor:hand" onclick="td_calendar(\'form1.BEGIN_DATE\');">
</td>
</tr>
<tr>
<td nowrap class="TableData">截止日期:</td>
<td class="TableData"><input type="text" name="END_DATE" size="10" maxlength="10" class="BigInput" value="';
echo $CUR_DATE;
echo '">
<img src="/images/menu/calendar.gif" border="0" style="cursor:hand" onclick="td_calendar(\'form1.END_DATE\');">
</td>
</tr>
<tr>
<td nowrap class="TableData">日志类型:</td>
<td class="TableData">
';
echo '<s';
echo 'elect name="DIA_TYPE" class="BigSelect">
<option value="0">所有类型</option>
';
echo code_list ('DIARY_TYPE', '');
echo ' </select>
</td>
</tr>
<tr>
<td nowrap class="TableData">标题:</td>
<td class="TableData"><input type="text" name="SUBJECT" class="BigInput" size="20"></td>
</tr>
<tr>
<td nowrap class="TableData">关键词1:</td>
<td class="TableData"><input type="text" name="KEY1" class="BigInput" size="20"></td>
</tr>
<tr>
<td nowrap class="TableData">
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?