personal_sign.php
来自「通达OA2007SE源代码 非常好的」· PHP 代码 · 共 117 行
PHP
117 行
<?
include_once 'inc/auth.php';
include_once 'inc/utility_all.php';
include_once '../prcs_role.php';
if (!run_role ($RUN_ID, 0))
{
exit ();
}
$query = ((''.'SELECT * from FLOW_TYPE WHERE FLOW_ID=').$FLOW_ID);
$cursor1 = exequery ($connection, $query);
if ($ROW = mysql_fetch_array ($cursor1))
{
$FLOW_NAME = $ROW['FLOW_NAME'];
$FORM_ID = $ROW['FORM_ID'];
$FLOW_TYPE = $ROW['FLOW_TYPE'];
$FLOW_DOC = $ROW['FLOW_DOC'];
}
if (($PRINT_FLAG != 1))
{
echo '
<html>
<head>
<title>会签意见</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<body class="bodycolor" topmargin="1" leftmargin="0">
';
}
$query = ((''.'SELECT PRCS_ID,FLOW_PRCS from FLOW_RUN_PRCS WHERE RUN_ID=').$RUN_ID);
$cursor = exequery ($connection, $query);
while ($ROW = mysql_fetch_array ($cursor))
{
$PRCS_ID1 = $ROW['PRCS_ID'];
$FLOW_PRCS1 = $ROW['FLOW_PRCS'];
$query = ((((''.'SELECT PRCS_NAME from FLOW_PROCESS WHERE FLOW_ID=').$FLOW_ID).' AND PRCS_ID=').$FLOW_PRCS1);
$cursor1 = exequery ($connection, $query);
if ($ROW = mysql_fetch_array ($cursor1))
{
$PRCS_NAME = $ROW['PRCS_NAME'];
}
$PRCS_ID_ARRAY[$PRCS_ID1] = $PRCS_NAME;
}
$query = (((''.'SELECT * from FLOW_RUN_FEEDBACK where RUN_ID=').$RUN_ID).' order by PRCS_ID,EDIT_TIME');
$cursor = exequery ($connection, $query);
$FEEDBACK_COUNT = 0;
while ($ROW = mysql_fetch_array ($cursor))
{
++$FEEDBACK_COUNT;
if (($FEEDBACK_COUNT == 1))
{
echo ' <table style=\'border-collapse:collapse\' border=1 cellspacing=0 cellpadding=3 bordercolor=\'#000000\' width="100%" class="small">
<tr class="TableHeader">
<td>会签意见</td>
</tr>
';
}
$USER_ID = $ROW['USER_ID'];
$PRCS_ID1 = $ROW['PRCS_ID'];
$CONTENT = $ROW['CONTENT'];
$ATTACHMENT_ID = $ROW['ATTACHMENT_ID'];
$ATTACHMENT_NAME = $ROW['ATTACHMENT_NAME'];
$EDIT_TIME = $ROW['EDIT_TIME'];
$CONTENT = str_replace ('<', '<', $CONTENT);
$CONTENT = str_replace ('>', '>', $CONTENT);
$CONTENT = stripslashes ($CONTENT);
$CONTENT = str_replace ('
', '<br>', $CONTENT);
$query1 = (((''.'SELECT USER_NAME,DEPT_ID from USER where USER_ID=\'').$USER_ID).'\'');
$cursor1 = exequery ($connection, $query1);
if ($ROW = mysql_fetch_array ($cursor1))
{
$USER_NAME = $ROW['USER_NAME'];
$DEPT_ID = $ROW['DEPT_ID'];
$DEPT_NAME = dept_long_name ($DEPT_ID);
}
echo ' <tr class="TableData">
<td>
<b>
';
if (($PRCS_ID1 != 0))
{
echo ' 第';
echo $PRCS_ID1;
echo '步 ';
echo $PRCS_ID_ARRAY[$PRCS_ID1];
}
echo ' <u title="部门:';
echo $DEPT_NAME;
echo '" style="cursor:hand">';
echo $USER_NAME;
echo '</u>:</b>
<br>
';
echo $CONTENT;
echo ' <i>';
echo $EDIT_TIME;
echo '</i>
<br>
';
if (($ATTACHMENT_ID != ''))
{
$TMP = attach_link ($ATTACHMENT_ID, $ATTACHMENT_NAME, 0, 1, 1, 0, 0, 1, 1, 0, '');
if ($WORD)
{
$TMP = str_replace ('<img ', '<span ', $TMP);
}
echo $TMP;
}
echo ' </td>
</tr>
';
}
if ((0 < $FEEDBACK_COUNT))
{
echo '</table>';
}
?>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?