personal_sign.php
来自「极限网络智能办公系统 - Office Automation 2008 官方10」· PHP 代码 · 共 99 行
PHP
99 行
<?php
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 "\r\n<html>\r\n<head>\r\n<title>会签意见</title>\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\">\r\n\r\n<body class=\"bodycolor\" topmargin=\"1\" leftmargin=\"0\">\r\n";
}
$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\">\r\n <tr class=\"TableHeader\">\r\n <td>会签意见</td>\r\n </tr>\r\n";
}
$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( "\n", "<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\">\r\n <td>\r\n <b>\r\n";
if ( $PRCS_ID1 != 0 )
{
echo " \t第";
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>\r\n <br>\r\n ";
echo $CONTENT;
echo " <i>";
echo $EDIT_TIME;
echo "</i>\r\n <br>\r\n\r\n";
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>\r\n </tr>\r\n";
}
if ( 0 < $FEEDBACK_COUNT )
{
echo "</table>";
}
?>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?