📄 sal_data.php
字号:
<?
include_once 'inc/auth.php';
include_once 'inc/utility_all.php';
echo '
<html>
<head>
<title>工资数据查阅</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body class="bodycolor" topmargin="5">
';
$query = (((''.'SELECT * from USER where USER_ID=\'').$USER_ID).'\'');
$cursor = exequery ($connection, $query);
if ($ROW = mysql_fetch_array ($cursor))
{
$USER_NAME = $ROW['USER_NAME'];
}
echo '<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
<tr>
<td class="Big"><img src="/images/menu/salary.gif" WIDTH="22" HEIGHT="20" align="absmiddle">';
echo '<s';
echo 'pan class="big3"> 工资数据查阅（';
echo $USER_NAME;
echo '）</span>
</td>
</tr>
</table>
<div align="center">
';
if (($RECALL == ''))
{
$query = (((((''.'select * from SAL_DATA where FLOW_ID=').$FLOW_ID).' and USER_ID=\'').$USER_ID).'\'');
$cursor = exequery ($connection, $query);
if ($ROW = mysql_fetch_array ($cursor))
{
for ($I = 1; ($I <= 50); ++$I)
{
$STR = ('S'.$I);
$$STR = format_money ($ROW[(''.$STR)]);
}
$OPERATION = 2;
}
else
{
$OPERATION = 1;
}
}
$query = 'select * from SAL_ITEM';
$cursor = exequery ($connection, $query);
$ITEM_COUNT = 0;
while ($ROW = mysql_fetch_array ($cursor))
{
++$ITEM_COUNT;
$ITEM_ID = $ROW['ITEM_ID'];
$ITEM_NAME = $ROW['ITEM_NAME'];
$S_ID = ('S'.$ITEM_ID);
$S_NAME = ($S_ID.'_NAME');
if (($ITEM_COUNT == 1))
{
echo '
<table border="0" cellspacing="1" width="450" class="small" bgcolor="#000000" cellpadding="3">
';
}
echo ' <tr class="TableData">
<td nowrap align="center" width="110">';
echo $ITEM_NAME;
echo '</td>
<td nowrap align="center">';
echo $$S_ID;
echo ' </td>
</tr>
';
}
if ((0 < $ITEM_COUNT))
{
echo ' <thead class="TableHeader">
<td nowrap align="center">工资项目</td>
<td nowrap align="center">金额</td>
</thead>
</table>
';
}
else
{
message ('', '尚未定义工资项目，请与财务主管联系！');
}
echo '
</div>
</body>
</html>';
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -