📄 report.php

📁 极限网络智能办公系统 - Office Automation 2.8 100％源码
💻 PHP
字号:
<?php

include_once( "inc/auth.php" );
include_once( "inc/utility_all.php" );
$query = "SELECT * from SAL_FLOW where FLOW_ID={$FLOW_ID}";
$cursor = exequery( $connection, $query );
$FLOW_COUNT = 0;
if ( $ROW = mysql_fetch_array( $cursor ) )
{
	$CONTENT = $ROW['CONTENT'];
	$STYLE = $ROW['STYLE'];
}
if ( $STYLE == "" )
{
	$query = "SELECT max( `FLOW_ID` ) as FLOW_ID,isnull(max( `FLOW_ID` )) AS flag FROM `SAL_FLOW` WHERE FLOW_ID < '{$FLOW_ID}' AND `STYLE` IS NOT NULL  AND `STYLE` !=''";
	$cursor = exequery( $connection, $query );
	if ( $ROW = mysql_fetch_array( $cursor ) )
	{
		$FLOWID = $ROW['FLOW_ID'];
		$flag = $ROW['flag'];
	}
	if ( $flag == "0" )
	{
		$query = "SELECT * from SAL_FLOW where FLOW_ID={$FLOWID}";
		$cursor = exequery( $connection, $query );
		if ( $ROW = mysql_fetch_array( $cursor ) )
		{
			$STYLE = $ROW['STYLE'];
		}
	}
	else
	{
		$query = "SELECT * from SAL_ITEM ORDER BY `ITEM_ID`";
		$cursor = exequery( $connection, $query );
		while ( $ROW = mysql_fetch_array( $cursor ) )
		{
			$ITEM_ID = $ROW['ITEM_ID'];
			$STYLE .= $ITEM_ID.",";
		}
	}
}
echo "\r\n<html>\r\n<head>\r\n<title>工资报表 - ";
echo $CONTENT;
echo "</title>\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\">\r\n";
echo "<s";
echo "tyle type=\"text/css\">\r\n.small {  font-size: 9pt;}\r\n</style>\r\n</head>\r\n\r\n<body>\r\n\r\n";
$query = "SELECT count(*) from SAL_ITEM";
$ITEM_COUNT = 0;
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
	$ITEM_COUNT = $ROW[0];
}
if ( $ITEM_COUNT == 0 )
{
	message( "提示", "尚未定义工资项目" );
	button_back( );
	exit( );
}
echo "\r\n<table border=\"1\" bordercolor=\"#000000\" cellspacing=\"0\" class=\"small\" cellpadding=\"3\" align=\"center\">\r\n\r\n    <tr bgcolor=\"#D3E5FA\">\r\n      <td nowrap align=\"center\"><b>部门</b></td>\r\n      <td nowrap align=\"center\"><b>姓名</b></td>\r\n      <td nowrap align=\"center\"><b>职务</b></td>\r\n";
$STYLE_ARRAY = explode( ",", $STYLE );
$ARRAY_COUNT = sizeof( $STYLE_ARRAY );
$COUNT = 0;
if ( $STYLE_ARRAY[$ARRAY_COUNT - 1] == "" )
{
	--$ARRAY_COUNT;
}
$I = 0;
for ( ;	$I < $ARRAY_COUNT;	++$I	)
{
	$query1 = "select ITEM_ID,ITEM_NAME from SAL_ITEM where ITEM_ID='{$STYLE_ARRAY[$I]}'";
	$cursor1 = exequery( $connection, $query1 );
	if ( $ROW = mysql_fetch_array( $cursor1 ) )
	{
		$ITEM_NAME = $ROW['ITEM_NAME'];
		$ITEM_ID[$COUNT] = $ROW['ITEM_ID'];
	}
	++$COUNT;
	echo "      <td nowrap align=\"center\"><b>";
	echo $ITEM_NAME;
	echo "</b></td>\r\n";
}
echo "    </tr>\r\n\r\n";
if ( $DEPT_FLAG != 1 )
{
	$query = "SELECT * from USER,USER_PRIV,DEPARTMENT where DEPARTMENT.DEPT_ID=USER.DEPT_ID and USER.USER_PRIV=USER_PRIV.USER_PRIV order by DEPT_NO,PRIV_NO,USER_NAME";
}
else
{
	$query = "SELECT * from USER,USER_PRIV where USER.USER_PRIV=USER_PRIV.USER_PRIV and DEPT_ID=0";
}
$cursor = exequery( $connection, $query );
$USER_COUNT = 0;
while ( $ROW = mysql_fetch_array( $cursor ) )
{
	++$USER_COUNT;
	$USER_ID = $ROW['USER_ID'];
	$USER_NAME = $ROW['USER_NAME'];
	$DEPT_ID = $ROW['DEPT_ID'];
	$USER_PRIV = $ROW['USER_PRIV'];
	if ( $DEPT_ID == 0 )
	{
		$DEPT_NAME = "离职人员/外部人员";
	}
	else
	{
		$query1 = "select * from DEPARTMENT where DEPT_ID={$DEPT_ID}";
		$cursor1 = exequery( $connection, $query1 );
		if ( $ROW = mysql_fetch_array( $cursor1 ) )
		{
			$DEPT_NAME = $ROW['DEPT_NAME'];
		}
	}
	$query1 = "SELECT * from USER_PRIV where USER_PRIV='{$USER_PRIV}'";
	$cursor1 = exequery( $connection, $query1 );
	if ( $ROW = mysql_fetch_array( $cursor1 ) )
	{
		$USER_PRIV = $ROW['PRIV_NAME'];
	}
	echo "    <tr>\r\n      <td nowrap align=\"center\">";
	echo $DEPT_NAME;
	echo "</td>\r\n      <td nowrap align=\"center\">";
	echo $USER_NAME;
	echo "</td>\r\n      <td nowrap align=\"center\">";
	echo $USER_PRIV;
	echo "</td>\r\n";
	$query1 = "select * from SAL_DATA where FLOW_ID={$FLOW_ID} and USER_ID='{$USER_ID}'";
	$cursor1 = exequery( $connection, $query1 );
	if ( $ROW = mysql_fetch_array( $cursor1 ) )
	{
		$I = 0;
		for ( ;	$I < $COUNT;	++$I	)
		{
			$STR = "S".$ITEM_ID[$I];
			$$STR = format_money( $ROW["{$STR}"] );
		}
	}
	else
	{
		$I = 0;
		for ( ;	$I < $COUNT;	++$I	)
		{
			$STR = "S".$ITEM_ID[$I];
			$$STR = "";
		}
	}
	$I = 0;
	for ( ;	$I < $COUNT;	++$I	)
	{
		$STR = "S".$ITEM_ID[$I];
		$STR_COUNT = $STR."_COUNT";
		$$STR_COUNT += $$STR;
		if ( $$STR == "" )
		{
			$$STR = "&nbsp;";
		}
		echo "      <td nowrap align=\"right\">";
		echo $$STR;
		echo "</td>\r\n";
	}
	echo "    </tr>\r\n";
}
if ( $USER_COUNT == 0 )
{
	echo "  <div align=\"center\"><b>尚未定义用户</b></div><br>\r\n";
}
else
{
	echo "  <tr bgcolor=\"#EEEEEE\">\r\n   <td nowrap align=\"center\" colspan=\"3\"><b>合计</b></td>\r\n";
	$I = 0;
	for ( ;	$I < $COUNT;	++$I	)
	{
		$STR = "S".$ITEM_ID[$I];
		$STR_COUNT = $STR."_COUNT";
		$DATA = format_money( $$STR_COUNT );
		if ( $DATA == "" )
		{
			$DATA = "&nbsp;";
		}
		echo "   <td nowrap align=\"right\"><b>";
		echo $DATA;
		echo "</b></td>\r\n";
	}
	echo "  </tr>\r\n";
}
echo "</table>\r\n</div>\r\n\r\n</body>\r\n</html>";
?>
⌨️ 快捷键说明

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