table_submit.php

来自「通达OA官方提供的30源代码,感觉很实在」· PHP 代码 · 共 72 行

PHP
72
字号
<?
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 + =
减小字号Ctrl + -
显示快捷键?