📄 table_submit.php
字号:
<?
include_once("inc/auth.php");
include_once("inc/check_type.php");
include_once("inc/utility_all.php");
include_once("fun_compute.php");
?>
<html>
<head>
<title>工资数据提交</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body class="bodycolor">
<?
$query = "SELECT USER_ID from USER where DEPT_ID='$DEPT_ID'";
$cursor= exequery($connection,$query);
$USER_COUNT=0;
while($ROW=mysql_fetch_array($cursor))
{
$USER_ID=$ROW["USER_ID"];
$OPERATION_ID=$USER_ID."_OPERATION";
if($$OPERATION_ID==1)
{
$query1="insert into SAL_DATA(FLOW_ID,USER_ID";
$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.=",S".$STYLE_ARRAY[$I];
$query1.=") values ($FLOW_ID,'$USER_ID',";
for($I=0;$I<$ARRAY_COUNT;$I++)
{
$STR=$USER_ID."_".$STYLE_ARRAY[$I];
if($$STR=="")
$$STR="0";
$query1.=$$STR;
if($I!=$ARRAY_COUNT-1)
$query1.=",";
}
$query1.=")";
}
else
{
$query1="update SAL_DATA set ";
$STYLE_ARRAY=explode(",",$STYLE);
$ARRAY_COUNT=sizeof($STYLE_ARRAY);
if($STYLE_ARRAY[$ARRAY_COUNT-1]=="")$ARRAY_COUNT--;
for($I=0;$I<$ARRAY_COUNT;$I++)
{
$STR="S".$STYLE_ARRAY[$I];
$STR_VALUE=$USER_ID."_".$STYLE_ARRAY[$I];
if($$STR_VALUE=="")
$$STR_VALUE="0";
$query1.=$STR."=".$$STR_VALUE;
if($I!=$ARRAY_COUNT-1)
$query1.=",";
}
$query1.=" where FLOW_ID=$FLOW_ID and USER_ID='$USER_ID'";
}
exequery($connection,$query1);
comput_allitem($FLOW_ID,$USER_ID);
}
header("location:table.php?FLOW_ID=$FLOW_ID&DEPT_ID=$DEPT_ID");
?>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -