table.php
来自「通达OA官方提供的30源代码,感觉很实在」· PHP 代码 · 共 129 行
PHP
129 行
<?
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"].",";
}
?>
<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 class="TableBlock" align="center">
<tr class="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++;
?>
<td nowrap align="center" onClick="clickTitle('<?=$ITEM_ID[$COUNT-1]?>')" style="cursor:hand"><b><?=$ITEM_NAME?></b></td>
<?
}
?>
</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";
?>
<tr class="TableLine1" align="center">
<td nowrap><?=$USER_NAME?></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++;
?>
<td nowrap align="center"><input type="text" name="<?=$USER_ID?>_<?=$ITEM_ID[$COUNT-1]?>" class="SmallInput" value="<?=$$S_ID?>" size="10" ></td>
<?
}
?>
<input type="hidden" name="<?=$USER_ID?>_OPERATION" class="SmallInput" value="<?=$OPERATION?>" size="10" >
<?
}
if($USER_COUNT==0)
$DEPT_COUNT--;
?>
</table>
<br>
<div align="center">
<input type="hidden" value="<?=$STYLE?>" name="STYLE">
<input type="hidden" value="<?=$FLOW_ID?>" name="FLOW_ID">
<input type="hidden" value="<?=$DEPT_ID?>" name="DEPT_ID">
<input type="hidden" value="<?=$STYLE_USER?>" name="STYLE_USER">
<input type="submit" value="确定" class="BigButton" title="确定" name="button">
</div>
</form>
</body>
</html>
<script 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 + -
显示快捷键?