📄 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';
echo '
<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 .= ',');
continue;
}
}
($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 .= ',');
continue;
}
}
($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>
</html>
';
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -