通达OA2017版工作流触发器应用实例

<?php
//qq  874689017  承接OA实施  流程定制  包月技术支持  软件开发
include_once("inc/auth.inc.php");
//include_once("inc/conn.php");
include_once("inc/utility_all.php");
include_once("inc/td_config.php");
include_once 'inc/utility_org.php'; 
include_once("inc/utility_file.php" );


include_once("inc/check_type.php");
include_once("inc/utility_sms1.php");  
include_once("inc/utility_sms2.php");  
 
include_once("inc/utility_flow.php");  
include_once("inc/workflow/inc/workflow.inc.php");  


$run_id=$RUN_ID;//流水号
$flow_id=$FLOW_ID;//流程号
$prcs_id=$PRCS_ID;//实际步骤

//$run_id=3294;
//$flow_id=159;

	
	$query1="select * from  flow_data_".$flow_id."  where run_id='$run_id'";
	$cursor1=exequery(TD::conn(),$query1);
	while($row1=mysql_fetch_array($cursor1)){
		$begin_user=$row1["begin_user"];//
		$begin_time=$row1["begin_time"];//
		$liushuihao=$row1["data_45"];//流水号
		$dianpu=$row1["data_4"];//店铺
		$zhandian=$row1["data_10"];//站点
		$fahuoriqi=$row1["data_6"];//发货日期
		$jihuamingcheng=$row1["data_5"];//计划名称
		$fahuoqudao=$row1["data_11"];//发货渠道
		$daohuoriqi=$row1["data_7"];//到货日期
		$danhao=$row1["data_49"];//单号
		$shuliang=$row1["data_50"];//数量
		
		$query2="select * from flow_data_151 as a ,flow_run as b where a.run_id=b.run_id  and a.data_49='$run_id' and b.del_flag=0 limit 1";
		$cursor2=exequery(TD::conn(),$query2);
		$num2=mysql_num_rows($cursor2);
		if($num2==0){
			 $START_TIME = date("Y-m-d H:i:s");  
  			$user=$_SESSION["LOGIN_USER_ID"];
    $run_id1= new_flow(151,$user,$user,0,0,0,1,$START_TIME);//1  是事务提醒  相同是主办人  不相同是经办人   
	$query3="UPDATE `TD_OA`.`flow_data_151` SET `data_6`='$fahuoriqi',  `data_10`='$zhandian', `data_11`='$fahuoqudao', `data_45`='$run_id1', `data_4`='$dianpu', `data_5`='$jihuamingcheng', `data_7`='$shuliang',`data_49`='$run_id' WHERE (`run_id`='$run_id1')";
	exequery(TD::conn(),$query3);
	$query4="update flow_data_150 set data_49='$run_id1'";
		exequery(TD::conn(),$query4);
			}
		
	
		
	}
		

?>