⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 flow_report.php

📁 通达网络办公 - Office Anywhere 2008 增强版100％源码(3.4.081216) 内含 通达OA2008增強版接近完美破解补丁20081216集 及 最新通达OA2008ADV(
💻 PHP
📖 第 1 页 / 共 2 页
字号:
🔍
12 
						$cursor_auto = exequery( $connection, $query_auto );
						if ( !( $ROW = mysql_fetch_array( $cursor_auto ) ) )
						{
							break;
						}
						$ITEM_VALUE = $ROW['DEPT_NAME'];
						break;
					case "SYS_LIST_PRIV" :
						$query_auto = "SELECT PRIV_NAME from USER_PRIV where USER_PRIV=".$ITEM_VALUE;
						$cursor_auto = exequery( $connection, $query_auto );
						if ( !( $ROW = mysql_fetch_array( $cursor_auto ) ) )
						{
							break;
						}
						$ITEM_VALUE = $ROW['PRIV_NAME'];
						break;
					case "SYS_LIST_USER" :
					case "SYS_LIST_PRCSUSER1" :
					case "SYS_LIST_PRCSUSER2" :
						$query_auto = "SELECT USER_NAME from USER where USER_ID='".$ITEM_VALUE."'";
						$cursor_auto = exequery( $connection, $query_auto );
						if ( !( $ROW = mysql_fetch_array( $cursor_auto ) ) )
						{
							break;
						}
						$ITEM_VALUE = $ROW['USER_NAME'];
						break;
					case "SYS_LIST_SQL" :
					}
					else
					{
						if ( $ECLASS == "LIST_VIEW" )
						{
							if ( !( $ITEM_VALUE != "" ) )
							{
								break;
							}
							$LV_TITLE = get_attr( $ELEMENT, "LV_TITLE" );
							$LV_SIZE = get_attr( $ELEMENT, "LV_SIZE" );
							$MY_ARRAY_SIZE = explode( "`", $LV_SIZE );
							$LV_VALUE = $ITEM_VALUE;
							$ITEM_VALUE = "<TABLE class='small' style='border-collapse:collapse' border=1 cellspacing=0 cellpadding=2 bordercolor='#000000'><TR class=TableHeader>\n";
							$MY_ARRAY = explode( "`", $LV_TITLE );
							$ARRAY_COUNT_TITLE = sizeof( $MY_ARRAY );
							if ( $MY_ARRAY[$ARRAY_COUNT_TITLE - 1] == "" )
							{
								--$ARRAY_COUNT_TITLE;
							}
							$K = 0;
							for ( ;	$K < $ARRAY_COUNT_TITLE;	++$K	)
							{
								$ITEM_VALUE .= "<TD nowrap>".$MY_ARRAY[$K]."</TD>\n";
							}
							$ITEM_VALUE .= "</TR>\n";
							$MY_ARRAY = explode( "\r\n", $LV_VALUE );
							$ARRAY_COUNT = sizeof( $MY_ARRAY );
							if ( $MY_ARRAY[$ARRAY_COUNT - 1] == "" )
							{
								--$ARRAY_COUNT;
							}
							$K = 0;
							for ( ;	$K < $ARRAY_COUNT;	++$K	)
							{
								$ITEM_VALUE .= "<tr>\n";
								$TR_DATA = $MY_ARRAY[$K];
								$MY_ARRAY1 = explode( "`", $TR_DATA );
								$L = 0;
								for ( ;	$L < $ARRAY_COUNT_TITLE;	++$L	)
								{
									$TD_DATA = $MY_ARRAY1[$L];
									if ( $TD_DATA == "" )
									{
										$TD_DATA = "&nbsp;";
									}
									$ITEM_VALUE .= ( "<td width=".$MY_ARRAY_SIZE[$L] * 9 ).">".$TD_DATA."</td>\n";
								}
								$ITEM_VALUE .= "</tr>\n";
							}
							$ITEM_VALUE .= "</TABLE>\n";
						}
						else
						{
							if ( $ECLASS == "AUTO" && $ITEM_VALUE == "{宏控件}" )
							{
								$ITEM_VALUE = "";
							}
							$ITEM_VALUE = str_replace( "<", "&lt", $ITEM_VALUE );
							$ITEM_VALUE = str_replace( ">", "&gt", $ITEM_VALUE );
							$ITEM_VALUE = stripslashes( $ITEM_VALUE );
							$ITEM_VALUE = str_replace( chr( 10 ), "<br>", $ITEM_VALUE );
							if ( !( $ENAME == "INPUT" ) && !strstr( $ELEMENT, "type=checkbox" ) )
							{
								break;
							}
							if ( $ITEM_VALUE == "on" )
							{
								$ITEM_VALUE = "是";
							}
							else
							{
								$ITEM_VALUE = "否";
							}
						}
					}
				}
				$DATA_ARRAY[$RUN_COUNT][$ITEM_ID + 4] = $ITEM_VALUE;
			}
		}
		++$RUN_COUNT;
	}
}
if ( $RUN_COUNT == 0 )
{
	message( "提示", "无符合条件的记录" );
	exit( );
}
$ROW_COUNT = $RUN_COUNT;
$COL_COUNT = $ITEM_ID + 5;
$TITLE_ARRAY[0] = "流水号";
$TITLE_ARRAY[1] = "名称/文号";
$TITLE_ARRAY[2] = "流程状态";
$TITLE_ARRAY[3] = "流程开始日期";
$TITLE_ARRAY[4] = "流程开始时间";
$J = 0;
$TEMP_ID = 0;
$I = 0;
for ( ;	$I < $ITEM_ID_MAX;	++$I	)
{
	$ELEMENT = $ELEMENT_ARRAY[$I];
	$ETITLE = get_attr( $ELEMENT, "TITLE" );
	$ECLASS = get_attr( $ELEMENT, "CLASS" );
	if ( !( $ECLASS == "DATE" ) )
	{
		if ( $ECLASS == "USER" )
		{
			break;
		}
	}
	else
	{
		continue;
	}
	++$TEMP_ID;
	if ( $ECLASS == "SIGN" )
	{
		$TITLE_ARRAY[$J + 5] = "";
		++$J;
	}
	else if ( !find_id( $DISP_FLD, $TEMP_ID + 4 ) )
	{
	}
	else
	{
		$ETITLE = str_replace( "<", "&lt", $ETITLE );
		$ETITLE = str_replace( ">", "&gt", $ETITLE );
		$ETITLE = stripslashes( $ETITLE );
		$TITLE_ARRAY[$J + 5] = $ETITLE;
		++$J;
	}
}
echo "\r\n<table cellspacing=\"0\" width=\"100%\" style=\"border-collapse:collapse\" border=1 cellspacing=0 cellpadding=3 bordercolor='#000000' class=\"small\">\r\n";
if ( $OP == 1 )
{
	echo "   <tr class=\"TableContent\">\r\n";
}
else
{
	echo "   <tr style=\"BACKGROUND: #D3E5FA; color: #000000; font-weight: bold;\">\r\n";
}
echo "   <td class=\"TableControl\" align=\"center\" nowrap><b>分组：";
echo $TITLE_ARRAY[$GROUP_FLD];
echo "&nbsp;</b></td>\r\n";
$ARRAY_COUNT = sizeof( $TITLE_ARRAY );
$I = 0;
for ( ;	$I < $ARRAY_COUNT;	++$I	)
{
	if ( !( $I == $GROUP_FLD ) )
	{
		if ( $TITLE_ARRAY[$I] == "" )
		{
			break;
		}
	}
	else
	{
		continue;
	}
	echo "   <td  nowrap align=\"center\"><b>";
	echo $TITLE_ARRAY[$I];
	echo "&nbsp;</b></td>\r\n";
}
echo "   </tr>\r\n";
$I = 0;
for ( ;	$I < $ROW_COUNT;	++$I	)
{
	$DATA_INDEX_ARRAY[0][$I] = $DATA_ARRAY[$I][$GROUP_FLD];
	$DATA_INDEX_ARRAY[1][$I] = $I;
}
if ( $GROUP_FLD == 0 )
{
	$SORT_TYPE = 1;
}
else
{
	$SORT_TYPE = 2;
}
$SORT_DESC = 3;
$SORT_ASC = 4;
$SORT_STRING = 1;
if ( $GROUP_SORT == "ASC" )
{
	array_multisort( &$DATA_INDEX_ARRAY[0], &$SORT_TYPE, &$SORT_ASC, &$DATA_INDEX_ARRAY[1], &$SORT_STRING, &$SORT_ASC );
}
else
{
	array_multisort( &$DATA_INDEX_ARRAY[0], &$SORT_TYPE, &$SORT_DESC, &$DATA_INDEX_ARRAY[1], &$SORT_STRING, &$SORT_ASC );
}
$CUR_VALUE_PREV = "OA_NULL_VALUE";
$GROUP_COUNT = -1;
$I = 0;
for ( ;	$I < $ROW_COUNT;	++$I	)
{
	if ( $DATA_INDEX_ARRAY[0][$I] != $CUR_VALUE_PREV )
	{
		++$GROUP_COUNT;
	}
	$DATA_GROUP_ARRAY[$GROUP_COUNT][0] = $DATA_INDEX_ARRAY[0][$I];
	$DATA_GROUP_ARRAY[$GROUP_COUNT][1] .= $DATA_INDEX_ARRAY[1][$I].",";
	$CUR_VALUE_PREV = $DATA_INDEX_ARRAY[0][$I];
}
$I = 0;
for ( ;	$I <= $GROUP_COUNT;	++$I	)
{
	unset( $SUM_DATA_ARRAY );
	$ROW_ARRAY = explode( ",", $DATA_GROUP_ARRAY[$I][1] );
	$ARRAY_COUNT = sizeof( $ROW_ARRAY ) - 1;
	$ROWSPAN = $ARRAY_COUNT;
	if ( $SUM_FLD1 != "" )
	{
		++$ROWSPAN;
	}
	$J = 0;
	for ( ;	$J < $ARRAY_COUNT;	++$J	)
	{
		echo "   <tr class=\"TableData\">\r\n";
		if ( $J == 0 )
		{
			echo "     <td rowspan=\"";
			echo $ROWSPAN;
			echo "\" class=\"TableContent\">\r\n     ";
			echo $DATA_GROUP_ARRAY[$I][0];
			if ( $GROUP_FLD != "0" )
			{
				echo "     <br><b>(共";
				echo $ARRAY_COUNT;
				echo "项)</b>\r\n";
			}
			echo "     \t</td>\r\n";
		}
		$K = 0;
		for ( ;	$K < $COL_COUNT;	++$K	)
		{
			if ( !( $K == $GROUP_FLD ) )
			{
				if ( $TITLE_ARRAY[$K] == "" )
				{
					break;
				}
			}
			else
			{
				continue;
			}
			if ( find_id( $SUM_FLD1, $K ) )
			{
				$SUM_DATA_ARRAY[$K] += $DATA_ARRAY[$ROW_ARRAY[$J]][$K];
				$SUM_TOTAL_DATA_ARRAY[$K] += $DATA_ARRAY[$ROW_ARRAY[$J]][$K];
			}
			echo "     <td ";
			if ( find_id( $SUM_FLD1, $K ) )
			{
				echo "align=right";
			}
			echo ">";
			echo $DATA_ARRAY[$ROW_ARRAY[$J]][$K];
			echo "</td>\r\n";
		}
		echo "   </tr>\r\n";
	}
	if ( $SUM_FLD1 != "" )
	{
		echo "      <tr class=\"TableData\">\r\n";
		$flag = 0;
		$K = 0;
		for ( ;	$K < $COL_COUNT;	++$K	)
		{
			if ( !( $K == $GROUP_FLD ) )
			{
				if ( $flag == 0 )
				{
					$flag = 1;
					echo "      \t    <td class=\"TableControl\" align=right><b>小计</b></td>\r\n";
				}
				else
				{
					echo "   <td class=\"TableControl\" align=right>";
					echo $SUM_DATA_ARRAY[$K];
					echo "&nbsp;</td>\r\n";
				}
			}
		}
		echo "</tr>";
	}
}
if ( $SUM_FLD1 != "" )
{
	echo "  <tr class=\"TableControl\">\r\n   <td align=\"center\"><b>合计</b></td>\r\n";
	$K = 0;
	for ( ;	$K < $COL_COUNT;	++$K	)
	{
		if ( !( $K == $GROUP_FLD ) )
		{
			echo " <td align=\"right\">";
			echo $SUM_TOTAL_DATA_ARRAY[$K];
			echo "&nbsp;</td>\r\n ";
		}
	}
	echo "</tr>";
}
echo "</table>\r\n\r\n</body>\r\n</html>";
?>
12

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -