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( "<", "&lt", $CONTENT );
	$CONTENT = str_replace( ">", "&gt", $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 + -
显示快捷键?