📄 batch_submit.php

📁 通达OA官方提供的30源代码,感觉很实在
💻 PHP
字号:
<?
include_once("inc/auth.php");
include_once("inc/check_type.php");
include_once("inc/utility_all.php");
include_once("inc/utility_sms1.php");
?>
<html>
<head>
<title></title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body class="bodycolor" topmargin="5">
<?

$USER_ID=strtok($TO_ID,",");
while($USER_ID!="")
{
   if($USER_ID=="")
   {
   	  $USER_ID=strtok(",");
   	  continue;
    }
	
	//未建档的不修改
   $query="select count(*) from HRMS,USER where HRMS.USER_ID=USER.USER_ID and HRMS.USER_ID='$USER_ID'";
   $cursor= exequery($connection,$query);
   $ROW=mysql_fetch_array($cursor);
   $COUNT=$ROW[0];
   if ($COUNT=="1")
   {
		if($LEAVE_TYPE!="")
		{
		  $query1="update HRMS set LEAVE_TYPE=$LEAVE_TYPE where USER_ID='$USER_ID'";
		  //echo $query1;
		  exequery($connection,$query1);
		}	    
    	if(($SELECTITEM!="-1")&&($TContext!=""))  //其他   like '%".$NO."%'";
   		{
      		if($MODE=="overwrite")
				$query1="update HRMS set $SELECTITEM='$TContext' where USER_ID='$USER_ID'";
			else //MODE=append
			    $query1="update HRMS set $SELECTITEM=CONCAT($SELECTITEM,'\n$TContext') where USER_ID='$USER_ID'";        	
	  		exequery($connection,$query1);  //执行常规修改
   		}
    
   		//--------------------批量修改自定义字段------------------------
   		//save_field_data("HRMS",$USER_ID,$_POST);
   		$USERDEF_FIELD=array();
   		//处理非复选框
   		while (list($key, $value) = each($_POST))
   		{
      		if(substr($key, 0, 7)!="USERDEF" || strstr(substr($key, 7),"_"))
         	continue;

      		$USERDEF_FIELD[$key]=$value;
   		}

   		//处理复选框，把相同复选框的值串起来并保存在数组CHECKBOX_FIELD里
   		reset($_POST);
   		while (list($key, $value) = each($_POST))
   		{
      		if(substr($key, 0, 7)!="USERDEF" || !strstr(substr($key, 7),"_"))
         	continue;

      		$ARRAY=explode("_",substr($key,7));
      		$USERDEF_FIELD["USERDEF".$ARRAY[0]].=$ARRAY[1].",";
   		}
  
   		reset($_POST);
   		while (list($key, $value) = each($USERDEF_FIELD))
   		{
	  		$query2 = "select * from FIELD_DATE where TABLENAME='HRMS' and FIELDNO='$key' and IDENTY_ID='$USER_ID';";
      		$cursor2=exequery($connection,$query2);
	  		if ($value!='')
	  		{
         		if(mysql_num_rows($cursor2)>0)
				{
            		$query2 = "update FIELD_DATE set ITEM_DATE='$value' where TABLENAME='HRMS' and FIELDNO='$key' and IDENTY_ID='$USER_ID';";
				}
         		else
            		$query2 = "insert into FIELD_DATE (TABLENAME,FIELDNO,IDENTY_ID,ITEM_DATE) values ('HRMS','$key','$USER_ID','$value');";
		  		exequery($connection,$query2);	 
	  		 }
	 		 //echo $query2;
	  	//break;
   		}
   		//-------------------k---------------------------------------------
   }
   $USER_ID=strtok(",");
}//while
   Message("提示","批量更新成功！");
?>
<div align="center">
	<input type="button" value="返回" class="BigButton" onClick="location='batch_update.php'">
</div>
</body>
</html>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -