feedback.php

泛微协同办公系统标准版E-office V5.5的源代码内含泛微办公系统V5.5自动注册文件。

<?php

include_once( "inc/auth_nohtml.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'];
}
$FLOW_PRCS_RUN = $FLOW_PRCS;
echo "<table border=\"0\" cellspacing=\"1\" width=\"100%\" cellpadding=\"5\">\r\n<tr class=\"Tableline1\">\r\n\t<td>\r\n\t\t<IFRAME id=\"iframesign\"  height=\"120\" width=\"100%\" FRAMEBORDER=0 SCROLLING=no SRC=\"/general/workflow/input_form/input_area/personal_sign_ajax.php?RUN_ID=";
echo $RUN_ID;
echo "&FLOW_ID=";
echo $FLOW_ID;
echo "&PRCS_ID=";
echo $PRCS_ID;
echo "&FLOW_PRCS=";
echo $FLOW_PRCS_RUN;
echo "\">\r\n\t\t</IFRAME>\r\n\t</td> \r\n</tr>\r\n<tr>\r\n\t<td>\r\n\r\n";
$query = "SELECT * from FLOW_RUN_FEEDBACK where RUN_ID={$RUN_ID} order by EDIT_TIME desc";
$cursor = exequery( $connection, $query );
$FEEDBACK_COUNT = 0;
$FLOW_PRCS_TMP = 0;
$i = 0;
$j = 0;
while ( $ROW = mysql_fetch_array( $cursor ) )
{
	++$FEEDBACK_COUNT;
	$USER_ID = $ROW['USER_ID'];
	$CONTENT = $ROW['CONTENT'];
	$ATTACHMENT_ID = $ROW['ATTACHMENT_ID'];
	$ATTACHMENT_NAME = $ROW['ATTACHMENT_NAME'];
	$EDIT_TIME = $ROW['EDIT_TIME'];
	$SEQ_ID = $ROW['SEQ_ID'];
	$FLOW_PRCS = $ROW['FLOW_PRCS'];
	$CONTENT = str_replace( "<", "&lt", $CONTENT );
	$CONTENT = str_replace( ">", "&gt", $CONTENT );
	$CONTENT = stripslashes( $CONTENT );
	$query1 = "SELECT * 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 );
	}
	$sql = "SELECT PRCS_NAME FROM FLOW_PROCESS WHERE FLOW_ID=".$FLOW_ID." AND PRCS_ID=".$FLOW_PRCS;
	$rs = exequery( $connection, $sql );
	$row = mysql_fetch_array( $rs );
	$PRCS_NAME = $row['PRCS_NAME'];
	if ( $FEEDBACK_COUNT % 2 == 0 )
	{
		$tableline = "TableLine2";
	}
	else
	{
		$tableline = "TableLine1";
	}
	if ( $FLOW_PRCS_TMP != $FLOW_PRCS && $FLOW_PRCS_TMP != 0 )
	{
		++$i;
		$j = 0;
	}
	$arrayData[$i]['DATA'][$j]['SEQ_ID'] = $SEQ_ID;
	$arrayData[$i]['FLOW']['FLOW_PRCS'] = $FLOW_PRCS;
	$arrayData[$i]['DATA'][$j]['USER_ID'] = $USER_ID;
	$arrayData[$i]['DATA'][$j]['CONTENT'] = $CONTENT;
	$arrayData[$i]['DATA'][$j]['ATTACHMENT_ID'] = $ATTACHMENT_ID;
	$arrayData[$i]['DATA'][$j]['ATTACHMENT_NAME'] = $ATTACHMENT_NAME;
	$arrayData[$i]['DATA'][$j]['EDIT_TIME'] = $EDIT_TIME;
	$arrayData[$i]['DATA'][$j]['USER_NAME'] = $USER_NAME;
	$arrayData[$i]['DATA'][$j]['DEPT_ID'] = $DEPT_ID;
	$arrayData[$i]['DATA'][$j]['DEPT_NAME'] = $DEPT_NAME;
	$arrayData[$i]['FLOW']['PRCS_NAME'] = $PRCS_NAME;
	++$j;
	$FLOW_PRCS_TMP = $FLOW_PRCS;
}
$m = 0;
for ( ;	$m < count( $arrayData );	++$m	)
{
	$PRCS_NAME = $arrayData[$m]['FLOW']['PRCS_NAME'];
	echo "<table border=\"0\" cellspacing=\"1\" width=\"100%\" cellpadding=\"2\">\r\n\t <tr>\r\n\t\t<td class=\"tablehead2\" width=\"10%\" align=\"center\" valign=\"middle\"><br>";
	echo "<s";
	echo "pan style=\"color:#333333\">";
	echo $PRCS_NAME;
	echo "</span>\r\n\t\t</td>\r\n\t\t<td>\r\n\t\t\t<table border=\"0\" cellspacing=\"1\" width=\"100%\" cellpadding=\"5\">\r\n\r\n";
	$n = 0;
	for ( ;	$n < count( $arrayData[$m]['DATA'] );	++$n	)
	{
		$SEQ_ID = $arrayData[$m]['DATA'][$n]['SEQ_ID'];
		$USER_ID = $arrayData[$m]['DATA'][$n]['USER_ID'];
		$CONTENT = $arrayData[$m]['DATA'][$n]['CONTENT'];
		$ATTACHMENT_ID = $arrayData[$m]['DATA'][$n]['ATTACHMENT_ID'];
		$ATTACHMENT_NAME = $arrayData[$m]['DATA'][$n]['ATTACHMENT_NAME'];
		$EDIT_TIME = $arrayData[$m]['DATA'][$n]['EDIT_TIME'];
		$USER_NAME = $arrayData[$m]['DATA'][$n]['USER_NAME'];
		$DEPT_ID = $arrayData[$m]['DATA'][$n]['DEPT_ID'];
		$DEPT_NAME = $arrayData[$m]['DATA'][$n]['DEPT_NAME'];
		echo "\r\n\t<tr>\r\n      <td class=\"TableLine2\">\r\n\t\t";
		echo "<s";
		echo "pan style=\"color:#003366\" title=\"部门：";
		echo $DEPT_NAME;
		echo "\" >";
		echo $USER_NAME;
		echo "</span> ";
		echo "<s";
		echo "pan style=\"font-size:9px;color:#333333\">";
		echo $EDIT_TIME;
		echo "</span> \r\n\t  </td>\r\n    </tr>\r\n\t<tr>\r\n\t\t<td>\r\n\t  ";
		echo $CONTENT;
		echo "<br>\r\n\r\n";
		if ( $ATTACHMENT_ID != "" )
		{
			$ATTACHMENT_ID_ARRAY = explode( ",", $ATTACHMENT_ID );
			$ATTACHMENT_NAME_ARRAY = explode( "*", $ATTACHMENT_NAME );
			$ARRAY_COUNT = sizeof( $ATTACHMENT_ID_ARRAY );
			$I = 0;
			for ( ;	$I < $ARRAY_COUNT;	++$I	)
			{
				if ( $ATTACHMENT_ID_ARRAY[$I] == "" )
				{
				}
				else
				{
					$ATTACH_IMAGE = getfilesuffixicon( $ATTACHMENT_NAME_ARRAY[$I] );
					echo "         <img src=\"";
					echo $ATTACH_IMAGE;
					echo "\" align=\"absmiddle\">\r\n\r\n               ";
					echo $ATTACHMENT_NAME_ARRAY[$I];
					echo " <a class=\"dbbutton\" onClick=\"window.location='/inc/attach.php?ATTACHMENT_ID=";
					echo $ATTACHMENT_ID_ARRAY[$I] * 3 + 2;
					echo "&ATTACHMENT_NAME=";
					echo urlencode( $ATTACHMENT_NAME_ARRAY[$I] );
					echo "'\">下载</a>&nbsp;\r\n\r\n\r\n\r\n";
					if ( isofficeoffile( $ATTACHMENT_NAME_ARRAY[$I] ) )
					{
						echo "                 <a class=\"dbbutton\"  onclick=\"window.open('/iWebOffice/DocumentEdit.php?RecordID=";
						echo $EMAIL_ID;
						echo "&EditType=0&UserName=";
						echo $_SESSION['LOGIN_USER_ID'];
						echo ";&ATTACHMENT_ID=";
						echo $ATTACHMENT_ID_ARRAY[$I] * 3 + 2;
						echo "&ATTACHMENT_NAME=";
						echo urlencode( $ATTACHMENT_NAME_ARRAY[$I] );
						echo "',null,'menubar=0,toolbar=0,status=1,scrollbars=1,resizable=1');\">阅读</a>&nbsp;\r\n\r\n";
						if ( $USER_ID == $LOGIN_USER_ID )
						{
							echo "              \r\n\t     <a class=\"dbbutton\" onClick=\"window.open('/iWebOffice/DocumentEdit.php?RecordID=";
							echo $EMAIL_ID;
							echo "&EditType=3&UserName=";
							echo $_SESSION['LOGIN_USER_ID'];
							echo ";&ATTACHMENT_ID=";
							echo $ATTACHMENT_ID_ARRAY[$I] * 3 + 2;
							echo "&ATTACHMENT_NAME=";
							echo urlencode( $ATTACHMENT_NAME_ARRAY[$I] );
							echo "',null,'menubar=0,toolbar=0,status=1,scrollbars=1,resizable=1');\">编辑</a>&nbsp;\r\n\r\n";
						}
					}
					if ( $USER_ID == $LOGIN_USER_ID )
					{
						echo "\r\n\t         <a class=\"dbbutton\" onClick=\"deleteAttach('divattach','/general/workflow/input_form/input_area/delete_personal_attach_ajax.php','ATTACHMENT_ID=";
						echo $ATTACHMENT_ID_ARRAY[$I];
						echo "&ATTACHMENT_NAME=";
						echo $ATTACHMENT_NAME_ARRAY[$I];
						echo "&RUN_ID=";
						echo $RUN_ID;
						echo "&FLOW_ID=";
						echo $FLOW_ID;
						echo "&PRCS_ID=";
						echo $PRCS_ID;
						echo "&FLOW_PRCS=";
						echo $FLOW_PRCS;
						echo "&SEQ_ID=";
						echo $SEQ_ID;
						echo "','divfeedback','/general/workflow/input_form/input_area/feedback.php','FLOW_ID=";
						echo $FLOW_ID;
						echo "&RUN_ID=";
						echo $RUN_ID;
						echo "&FLOW_PRCS=";
						echo $FLOW_PRCS_RUN;
						echo "')\">删除</a>\r\n";
					}
					echo "<br>";
				}
			}
		}
		echo "       \r\n\t   </td>\r\n     </tr>\r\n\r\n\r\n";
	}
	echo "\t\t\t</table>\r\n\t\t</td>\r\n\t </tr>\r\n</table>\r\n\r\n";
}
echo "\t</td>\r\n</tr>\r\n</table>";
?>