通达OA工作流附件自动转存到文件柜的触发器

<?php

include_once("inc/auth.inc.php");
//include_once("inc/conn.php");
include_once("inc/utility_all.php");
include_once("inc/utility_org.php");
include_once("inc/utility_file.php" );

//$filename = "a.test.txt";
//$houzhui = substr(strrchr($filename, '.'), 1);
//$result = basename($filename,".".$houzhui);
//echo $result;
#$RUN_ID=470;
#$FLOW_ID=132;
#$PRCS_ID=1;
$run_id=$RUN_ID;//流水号
$flow_id=$FLOW_ID;//流程号
$prcs_id=$PRCS_ID;//实际步骤
$user_id=$_SESSION["LOGIN_USER_ID"];
$SORT_ID=0;
#echo $RUN_ID;
if($RUN_ID && $FLOW_ID){
	//查询工作流表单数据
	$sql="select * from flow_data_".$FLOW_ID." where run_id=".$RUN_ID." limit 1";
	#echo $sql;
	$cursor = exequery(TD::conn(),$sql);
  	while($ROW=mysql_fetch_array($cursor)){
	$run_name=$ROW["run_name"];
	$begin_user=$ROW["begin_user"];
	}
	$query3="select * from flow_run_attach where run_id='$RUN_ID'";
	$cursor3=exequery(TD::conn(),$query3);
	$num3=mysql_num_rows($cursor3);
	if($num3!=0){
		//创建子目录
		$query6="select *from file_sort where SORT_NAME='$run_name' AND USER_ID='$user_id' LIMIT 1";
		$cursor6=exequery(TD::conn(),$query6);
		$num6=mysql_num_rows($cursor6);
		if($num6==0){
		$query5="INSERT INTO `TD_OA`.`file_sort` ( `SORT_PARENT`, `SORT_NO`, `SORT_NAME`, `SORT_TYPE`, `USER_ID`) VALUES ( '0', '1', '$run_name', '4', '$user_id')";
		exequery(TD::conn(),$query5);//创建子目录
		$SORT_ID=mysql_insert_id();
		} else {
			$row6=mysql_fetch_array($cursor6);
			$SORT_ID=$row6["SORT_ID"];
			}
		while($row3=mysql_fetch_array($cursor3)){
			$ATTACHMENT_ID=$row3["ATTACHMENT_ID"];
			$ATTACHMENT_NAME=$row3["ATTACHMENT_NAME"];
			#echo $ATTACHMENT_ID."---".$ATTACHMENT_NAME."<BR>";

			$houzhui = substr(strrchr($ATTACHMENT_NAME, '.'), 1);
			$SUBHECT = basename($ATTACHMENT_NAME,".".$houzhui);
			
			$query4="INSERT INTO `TD_OA`.`file_content` (`SORT_ID`, `SUBJECT`, `CONTENT`, `SEND_TIME`, `ATTACHMENT_ID`, `ATTACHMENT_NAME`, `ATTACHMENT_DESC`, `USER_ID`, `CONTENT_NO`, `NEW_PERSON`, `READERS`, `CREATER`, `LOGS`, `KEYWORD`) VALUES ('$SORT_ID', '$SUBHECT', '', '".date("Y-m-d H:i:s")."', '".$ATTACHMENT_ID.",', '".$ATTACHMENT_NAME."*', '', '$user_id', '0', '', '', '$user_id', '', '')";
			exequery(TD::conn(),$query4);

			}
		}

}//if

?>