📄 table_submit.php
字号:
<?php
include_once( "inc/auth.php" );
include_once( "inc/check_type.php" );
include_once( "inc/utility_all.php" );
include_once( "fun_compute.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</head>\r\n\r\n<body class=\"bodycolor\">\r\n\r\n";
$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;
}
$I = 0;
for ( ; $I < $ARRAY_COUNT; ++$I )
{
$query1 .= ",S".$STYLE_ARRAY[$I];
}
$query1 .= ") values (".$FLOW_ID.",'{$USER_ID}',";
$I = 0;
for ( ; $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;
}
$I = 0;
for ( ; $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}" );
echo "</body>\r\n</html>\r\n";
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -