📄 report.php
字号:
<?php
include_once( "inc/auth.php" );
include_once( "inc/utility_all.php" );
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";
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";
$connection = openconnection( );
$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 "<table width=\"100%\" border=\"0\" cellspacing=\"1\" cellpadding=\"5\">\r\n <tr>\r\n <td class=\"tablehead1\"><a href='create_excel.php?FLOW_ID=";
echo $_REQUEST['FLOW_ID'];
echo "'><img src=\"/images/button/button_out_excel.gif\" border=\"0\"></a> </td>\r\n </tr>\r\n</table>\r\n<table border=\"0\" cellspacing=\"1\" cellpadding=\"5\" align=\"center\" width=\"100%\">\r\n\r\n <tr class=\"TableHeader\">\r\n <td nowrap align=\"center\"><b>部门</b></td>\r\n <td align=\"center\" nowrap><b>姓名</b></td>\r\n <td align=\"center\" nowrap><b>职务</b></td>\r\n";
$query = "SELECT * from SAL_ITEM";
$cursor = exequery( $connection, $query );
while ( $ROW = mysql_fetch_array( $cursor ) )
{
$ITEM_NAME = $ROW['ITEM_NAME'];
echo " <td align=\"center\" nowrap><b>";
echo $ITEM_NAME;
echo "</b></td>\r\n";
}
echo " <td align=\"center\" nowrap><b>合计</b></td>\r\n </tr>\r\n\r\n";
$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";
$cursor = exequery( $connection, $query );
$USER_COUNT = 0;
$LINE_COUNT = 0;
$TOTAL_U_STR = "";
while ( $ROW = mysql_fetch_array( $cursor ) )
{
++$USER_COUNT;
++$LINE_COUNT;
$USER_ID = $ROW['USER_ID'];
$USER_NAME = $ROW['USER_NAME'];
$DEPT_ID = $ROW['DEPT_ID'];
$USER_PRIV = $ROW['USER_PRIV'];
$query1 = "select * from DEPARTMENT where DEPT_ID={$DEPT_ID}";
$cursor1 = exequery( $connection, $query1 );
if ( $ROW = mysql_fetch_array( $cursor1 ) )
{
$DEPT_NAME = $ROW['DEPT_NAME'];
}
if ( $DEPT_ID == 0 )
{
$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 "\r\n";
if ( $LINE_COUNT % 2 == 1 )
{
$TableLine = "TableLine1";
}
else
{
$TableLine = "TableLine2";
}
echo "\r\n <tr class=\"";
echo $TableLine;
echo "\">\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 );
$totalPnStr = "";
if ( $ROW = mysql_fetch_array( $cursor1 ) )
{
$I = 1;
for ( ; $I <= $ITEM_COUNT; ++$I )
{
$STR = "S".$I;
$$STR = format_money( $ROW["{$STR}"] );
$totalPnStr += $$STR;
}
$totalPnStr = format_money( $totalPnStr );
}
else
{
$I = 1;
for ( ; $I <= $ITEM_COUNT; ++$I )
{
$STR = "S".$I;
$$STR = "";
}
}
$TOTAL_U_STR += $totalPnStr;
$I = 1;
for ( ; $I <= $ITEM_COUNT; ++$I )
{
$STR = "S".$I;
$STR_COUNT = $STR."_COUNT";
$$STR_COUNT += $$STR;
if ( $$STR == "" )
{
$$STR = " ";
}
echo " <td nowrap align=\"right\">";
echo $$STR;
echo "</td>\r\n";
}
echo "<td nowrap align=\"right\"><b>";
echo $totalPnStr;
echo "</b></td>\r\n </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";
$TOTAL_U_STR = format_money( $TOTAL_U_STR );
$I = 1;
for ( ; $I <= $ITEM_COUNT; ++$I )
{
$STR = "S".$I;
$STR_COUNT = $STR."_COUNT";
$DATA = format_money( $$STR_COUNT );
if ( $DATA == "" )
{
$DATA = " ";
}
echo " \r\n <td nowrap align=\"right\"><b>";
echo $DATA;
echo "</b></td>\r\n";
}
echo " <td nowrap align=\"right\">";
echo "<s";
echo "pan style=\"color:red\"><b>";
echo $TOTAL_U_STR;
echo "</b></span></td>\r\n </tr>\r\n";
}
echo "</table>\r\n</body>\r\n</html>";
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -