plan_detail.php
来自「通达OA2007SE源代码 非常好的」· PHP 代码 · 共 325 行
PHP
325 行
<?
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 Language="JavaScript">
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,location';
echo '=no,scrollbars=yes,top="+loc_y+",left="+loc_x+",resizable=yes");
}
</script>
</head>
';
$CUR_DATE = date ('Y-m-d', time ());
$query = ((''.'SELECT * from WORK_PLAN where PLAN_ID=').$PLAN_ID);
$cursor = exequery ($connection, $query);
if ($ROW = mysql_fetch_array ($cursor))
{
$PLAN_ID = $ROW['PLAN_ID'];
$NAME = $ROW['NAME'];
$CONTENT = $ROW['CONTENT'];
$BEGIN_DATE = $ROW['BEGIN_DATE'];
$END_DATE = $ROW['END_DATE'];
$TYPE = $ROW['TYPE'];
$TO_ID = $ROW['TO_ID'];
$MANAGER = $ROW['MANAGER'];
$PARTICIPATOR = $ROW['PARTICIPATOR'];
$CREATOR = $ROW['CREATOR'];
$CREATE_DATE = $ROW['CREATE_DATE'];
$ATTACHMENT_ID = $ROW['ATTACHMENT_ID'];
$ATTACHMENT_NAME = $ROW['ATTACHMENT_NAME'];
$ATTACHMENT_COMMENT = $ROW['ATTACHMENT_COMMENT'];
$REMARK = $ROW['REMARK'];
$SUSPEND_FLAG = $ROW['SUSPEND_FLAG'];
$TO_PERSON_ID = $ROW['TO_PERSON_ID'];
$CONTENT = str_replace ('
', '<br>', $CONTENT);
$query = (((''.'SELECT * from PLAN_TYPE where TYPE_ID=\'').$TYPE).'\'');
$cursor1 = exequery ($connection, $query);
if ($ROW1 = mysql_fetch_array ($cursor1))
{
$TYPE_DESC = $ROW1['TYPE_NAME'];
}
else
{
$TYPE_DESC = '';
}
if (($TO_ID == 'ALL_DEPT'))
{
$TO_NAME = '全体部门';
}
else
{
$TO_NAME = '';
$TOK = strtok ($TO_ID, ',');
while (($TOK != ''))
{
if (($TO_NAME != ''))
{
($TO_NAME .= '，');
}
$query1 = ((''.'select * from DEPARTMENT where DEPT_ID=').$TOK);
$cursor1 = exequery ($connection, $query1);
if ($ROW = mysql_fetch_array ($cursor1))
{
($TO_NAME .= $ROW['DEPT_NAME']);
}
$TOK = strtok (',');
}
}
$TO_PERSON_NAME = '';
$TOK = strtok ($TO_PERSON_ID, ',');
while (($TOK != ''))
{
if (($TO_PERSON_NAME != ''))
{
($TO_PERSON_NAME .= '，');
}
$query1 = (((''.'select * from USER where USER_ID=\'').$TOK).'\'');
$cursor1 = exequery ($connection, $query1);
if ($ROW1 = mysql_fetch_array ($cursor1))
{
$DEPT_ID = $ROW1['DEPT_ID'];
$DEPT_NAME = dept_long_name ($DEPT_ID);
($TO_PERSON_NAME .= (((('<u title="部门：'.$DEPT_NAME).'" style="cursor:hand">').$ROW1['USER_NAME']).'</u>'));
}
$TOK = strtok (',');
}
$PARTICIPATOR_NAME = '';
$TOK = strtok ($PARTICIPATOR, ',');
while (($TOK != ''))
{
if (($PARTICIPATOR_NAME != ''))
{
($PARTICIPATOR_NAME .= '，');
}
$query1 = (((''.'select * from USER where USER_ID=\'').$TOK).'\'');
$cursor1 = exequery ($connection, $query1);
if ($ROW = mysql_fetch_array ($cursor1))
{
$DEPT_ID = $ROW['DEPT_ID'];
$DEPT_NAME = dept_long_name ($DEPT_ID);
($PARTICIPATOR_NAME .= (((('<u title="部门：'.$DEPT_NAME).'" style="cursor:hand">').$ROW['USER_NAME']).'</u>'));
}
$TOK = strtok (',');
}
$PARTICIPATOR_NAME = substr ($PARTICIPATOR_NAME, 0, -1);
$MANAGE_NAME = '';
$TOK = strtok ($MANAGER, ',');
while (($TOK != ''))
{
if (($MANAGE_NAME != ''))
{
($MANAGE_NAME .= '，');
}
$query1 = (((''.'select * from USER where USER_ID=\'').$TOK).'\'');
$cursor1 = exequery ($connection, $query1);
if ($ROW = mysql_fetch_array ($cursor1))
{
$DEPT_ID = $ROW['DEPT_ID'];
$DEPT_NAME = dept_long_name ($DEPT_ID);
($MANAGE_NAME .= (((('<u title="部门：'.$DEPT_NAME).'" style="cursor:hand">').$ROW['USER_NAME']).'</u>'));
}
$TOK = strtok (',');
}
$MANAGE_NAME = substr ($MANAGE_NAME, 0, -1);
$query1 = (((''.'select * from USER where USER_ID=\'').$CREATOR).'\'');
$cursor = exequery ($connection, $query1);
if ($ROW = mysql_fetch_array ($cursor))
{
$DEPT_ID = $ROW['DEPT_ID'];
$DEPT_NAME = dept_long_name ($DEPT_ID);
$CREATOR_NAME = (((('<u title="部门：'.$DEPT_NAME).'" style="cursor:hand">').$ROW['USER_NAME']).'</u>,');
}
$CREATOR_NAME = substr ($CREATOR_NAME, 0, -1);
if (($SUSPEND_FLAG == 1))
{
if ((compare_date ($CUR_DATE, $BEGIN_DATE) < 0))
{
$STATUS_DESC = '未开始';
}
else
{
$STATUS_DESC = '<font color=\'#00AA00\'><b>进行中</b></font>';
}
if (($END_DATE != '0000-00-00'))
{
if ((0 < compare_date ($CUR_DATE, $END_DATE)))
{
$STATUS_DESC = '<font color=\'#FF0000\'><b>已结束</b></font>';
}
}
else
{
$END_DATE = '';
}
}
else
{
$STATUS_DESC = '<font color=\'#FF0000\'><b>暂停</b></font>';
}
if ((($WORK_PLAN_COUNT % 2) == 1))
{
$TableLine = 'TableLine1';
}
else
{
$TableLine = 'TableLine2';
}
echo '<body class="bodycolor" topmargin="5">
<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
<tr>
<td class="Big"><img src="/images/menu/work_plan.gif" WIDTH="22" HEIGHT="20" align="absmiddle">';
echo '<s';
echo 'pan class="big3"> 工作计划详情 - ';
echo $NAME;
echo '</span><br>
</td>
</tr>
</table>
<table border="0" cellspacing="1" width="100%" class="small" bgcolor="#000000" cellpadding="3">
<tr>
<td nowrap align="center" class="TableContent" width="80">计划名称</td>
<td align="left" class="TableData">';
echo $NAME;
echo '</td>
</tr>
<tr>
<td nowrap align="center" class="TableContent" width="80">计划内容 </td>
<td align="left" class="TableData">';
echo $CONTENT;
echo '</td>
</tr>
<tr>
<td nowrap align="center" class="TableContent" width="80">开始时间</td>
<td nowrap align="left" class="TableData">';
echo $BEGIN_DATE;
echo '</td>
</tr>
<tr>
<td nowrap align="center" class="TableContent" width="80">结束时间</td>
<td nowrap align="left" class="TableData">';
echo $END_DATE;
echo '</td>
</tr>
<tr>
<td nowrap align="center" class="TableContent" width="80">计划类别</td>
<td nowrap align="left" class="TableData">';
echo $TYPE_DESC;
echo '</td>
</tr>
<tr>
<td nowrap align="center" class="TableContent" width="80">开放部门</td>
<td align="left" class="TableData">';
echo $TO_NAME;
echo '</td>
</tr>
<tr>
<td nowrap align="center" class="TableContent" width="80">开放人员</td>
<td align="left" class="TableData">';
echo $TO_PERSON_NAME;
echo '</td>
</tr>
<tr>
<td nowrap align="center" class="TableContent" width="80">负责人</td>
<td nowrap align="left" class="TableData">';
echo $MANAGE_NAME;
echo '</td>
</tr>
<tr>
<td nowrap align="center" class="TableContent" width="80">参与人</td>
<td align="left" class="TableData">';
echo $PARTICIPATOR_NAME;
echo '</td>
</tr>
<tr>
<td nowrap align="center" class="TableContent" width="80">创建人 </td>
<td nowrap align="left" class="TableData">';
echo $CREATOR_NAME;
echo '</td>
</tr>
<tr>
<td nowrap align="center" class="TableContent" width="80">创建日期 </td>
<td nowrap align="left" class="TableData">';
echo $CREATE_DATE;
echo '</td>
</tr>
<tr>
<td nowrap align="center" class="TableContent" width="80">进度详情 </td>
<td nowrap align="left" class="TableData">
<a href="javascript:;" onClick="window.open(\'add_diary.php?PLAN_ID=';
echo $PLAN_ID;
echo '\',\'\',\'height=500,width=700,status=1,toolbar=no,menubar=no,location=no,scrollbars=yes,left=150,top=60,resizable=yes\');">查看进度日志</a>
<a href="javascript:;" onClick="window.open(\'progress_map.php?PLAN_ID=';
echo $PLAN_ID;
echo '\',\'\',\'height=500,width=700,status=1,toolbar=no,menubar=no,location=no,scrollbars=yes,left=150,top=60,resizable=yes\');">查看进度图</a>
</td>
</tr>
<tr>
<td nowrap align="center" class="TableContent" width="80">批注 </td>
<td nowrap align="left" class="TableData">
<a href="javascript:;" onClick="window.open(\'opinion_detail.php?PLAN_ID=';
echo $PLAN_ID;
echo '\',\'\',\'height=500,width=600,status=1,toolbar=no,menubar=no,location=no,scrollbars=yes,left=200,top=60,resizable=yes\');">查看领导批注</a>
</td>
</tr>
<tr>
<td nowrap align="center" class="TableContent" width="80">附件文件</td>
<td nowrap align="left" class="TableData">
';
if (($ATTACHMENT_NAME == ''))
{
echo '无';
}
else
{
echo attach_link ($ATTACHMENT_ID, $ATTACHMENT_NAME, 1, 1, 1, 0, 0, 1, 1, 0);
}
echo ' </td>
</tr>
<tr>
<td nowrap align="center" class="TableContent" width="80">附件说明</td>
<td nowrap align="left" class="TableData">';
echo $ATTACHMENT_COMMENT;
echo '</td>
</tr>
<tr>
<td nowrap align="center" class="TableContent" width="80">备注</td>
<td align="left" class="TableData">';
echo $REMARK;
echo '</td>
</tr>
<tr>
<td nowrap align="center" class="TableContent" width="80">状态</td>
<td nowrap align="left" class="TableData">';
echo $STATUS_DESC;
echo '</td>
</tr>
<tr class="TableControl">
<td colspan="9" align="center">
<input type="button" value="打印" class="BigButton" onclick="document.execCommand(\'Print\');" title="直接打印表格页面">
<input type="button" value="关闭" class="BigButton" onClick="window.close();" title="关闭窗口">
</td>
</tr>
</table>
';
}
else
{
message ('', '无未找到相应记录！');
}
echo '
</body>
</html>';
?>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?