table.php
来自「通达OA2007SE源代码 非常好的」· PHP 代码 · 共 161 行
PHP
161 行
<?
include_once 'inc/auth.php';
include_once 'inc/utility_all.php';
$query = 'SELECT ITEM_ID from SAL_ITEM where ISREPORT=\'1\'';
$cursor = exequery ($connection, $query);
$FLOW_COUNT = 0;
while ($ROW = mysql_fetch_array ($cursor))
{
$STYLE = (($STYLE.$ROW['ITEM_ID']).',');
}
echo '
<html>
<head>
<title>人员工资录入</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body class="bodycolor" topmargin="5" leftmargin="0">
<form action="table_submit.php" method="post" name="form1">
<table bordercolor="#000000" style=\'border-collapse:collapse\' border=1 cellspacing=0 cellpadding=2 bordercolor=\'#000000\' class="small" align="center">
<tr class=';
echo '"TableHeader" align="center">
<td nowrap width="15%"><b>姓名</b></td>
';
$STYLE_ARRAY = explode (',', $STYLE);
$ARRAY_COUNT = sizeof ($STYLE_ARRAY);
$COUNT = 0;
if (($STYLE_ARRAY[($ARRAY_COUNT - 1)] == ''))
{
--$ARRAY_COUNT;
}
for ($I = 0; ($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" onclick="clickTitle(\'';
echo $ITEM_ID[($COUNT - 1)];
echo '\')" style="cursor:hand"><b>';
echo $ITEM_NAME;
echo '</b></td>
';
}
echo ' </tr>
';
$query = (((''.'SELECT * from USER,USER_PRIV where DEPT_ID=').$DEPT_ID).' and USER.USER_PRIV=USER_PRIV.USER_PRIV order by PRIV_NO,USER_NO,USER_NAME');
$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'];
$STYLE_USER = (($STYLE_USER.$USER_ID).',');
if ((($USER_COUNT % 2) == 1))
{
$TableLine = 'TableLine1';
}
else
{
$TableLine = 'TableContent';
}
echo ' <tr class="TableLine1" align="center">
<td nowrap>';
echo $USER_NAME;
echo '</td>
';
$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))
{
for ($I = 1; ($I <= 50); ++$I)
{
$STR = ('S'.$I);
$$STR = format_money ($ROW[(''.$STR)]);
}
$OPERATION = 2;
}
else
{
$OPERATION = 1;
}
$STYLE_ARRAY = explode (',', $STYLE);
$ARRAY_COUNT = sizeof ($STYLE_ARRAY);
$COUNT = 0;
if (($STYLE_ARRAY[($ARRAY_COUNT - 1)] == ''))
{
--$ARRAY_COUNT;
}
for ($I = 0; ($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'];
$S_ID = ('S'.$ITEM_ID[$COUNT]);
}
++$COUNT;
echo ' <td nowrap align="center"><input type="text" name="';
echo $USER_ID;
echo '_';
echo $ITEM_ID[($COUNT - 1)];
echo '" class="SmallInput" value="';
echo $$S_ID;
echo '" size="10" ></td>
';
}
echo ' <input type="hidden" name="';
echo $USER_ID;
echo '_OPERATION" class="SmallInput" value="';
echo $OPERATION;
echo '" size="10" >
';
}
if (($USER_COUNT == 0))
{
--$DEPT_COUNT;
}
echo '</table>
<br>
<div align="center">
<input type="hidden" value="';
echo $STYLE;
echo '" name="STYLE">
<input type="hidden" value="';
echo $FLOW_ID;
echo '" name="FLOW_ID">
<input type="hidden" value="';
echo $DEPT_ID;
echo '" name="DEPT_ID">
<input type="hidden" value="';
echo $STYLE_USER;
echo '" name="STYLE_USER">
<input type="submit" value="确定" class="BigButton" title="确定" name="button">
</div>
</form>
</body>
</html>
';
echo '<s';
echo 'cript language="JavaScript">
function clickTitle(ID)
{
var str1=document.all("STYLE_USER").value;
var id_value_array=str1.split(",");
var temp=id_value_array.length-2;
for(i=0;i<=temp;i++){
control=id_value_array[i]+"_"+ID;
if(i==0)setvalue=document.all(control).value;
document.all(control).value=setvalue;
}
}
</script>';
?>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?