通达OA自动发起流程，并带有附件

最新推荐文章于 2024-05-16 13:46:02 发布

hai7425

最新推荐文章于 2024-05-16 13:46:02 发布

阅读量3.6k

点赞数 1

分类专栏：通达OA php学习研究文章标签： OA php

本文链接：https://blog.csdn.net/hai7425/article/details/53406693

版权

通达OA 同时被 2 个专栏收录

108 篇文章 15 订阅

订阅专栏

php学习研究

107 篇文章 2 订阅

订阅专栏

<?
include_once("inc/auth.inc.php");
include_once("inc/utility_sms1.php");
include_once("inc/utility_sms2.php");
include_once("inc/utility_all.php");
include_once("inc/utility_org.php");
include_once("inc/utility_file.php");
include_once("inc/utility_flow.php");
include_once("inc/workflow/inc/workflow.inc.php");


$HTML_PAGE_TITLE = _("自动触发工作流");
include_once("inc/header.inc.php");
?>


<script type="text/javascript" src="<?=MYOA_JS_SERVER?>/static/js/utility.js"></script>
<script language="javascript">

 </script>  

<body class="bodycolor" style="font-size:12px">
<?


$CUR_YEAR=date("Y");
$CUR_MONTH=date("m");
$CUR_WEEK=date("w");
$CUR_DAY=date("j");
$CUR_DATE=date("Y-m-d H:i:s");
$CUR_TIME=date("H:i:s");

    $START_TIME = date("Y-m-d H:i:s");
    $run_id= new_flow(166,"admin","admin",0,0,0,1,$START_TIME);//1  是事务提醒  相同是主办人  不相同是经办人 
    echo "流水号：".$run_id."<br>";

	 $attachemnt_id="";
	 $attachment_name="";
	 
	 if($YM=="")
    $YM=date('ym');

   $PATH="E:/MYOA/attach/workflow";
   if(!file_exists($PATH) || !is_dir($PATH))
       mkdir($PATH, 0700);
   $PATH=$PATH."/".$YM;
   if(!file_exists($PATH) || !is_dir($PATH))
       mkdir($PATH, 0700);  
	 
	$file_arr=array("测试.doc","附件2.txt","通达OA二次开发手册2015.doc","功能明细.docx");
	foreach($file_arr as $v){
		echo $v."**<br>";
	
	$ATTACH_ID=mt_rand();
	$ATTACH_NAME=$v;
	$file1="E:/MYOA/webroot/jicaifile/205/".$ATTACH_NAME;
	$PATH1=$PATH."/".$ATTACH_ID.".".$ATTACH_NAME;
	echo @copy($file1,$PATH1)?'成功':'失败';
	//echo @rename($file1,$PATH1)?'成功':'失败';//2677@1505_1668115426
	//unlink($del_name)?'成功':'失败';
	  
  
  
	
	   
	   $query="INSERT INTO `TD_OA`.`attachment` (`POSITION`, `MODULE`, `YM`, `ATTACH_ID`, `ATTACH_FILE`, `ATTACH_NAME`, `ATTACH_SIGN`, `DEL_FLAG`) VALUES ('2', '2', '$YM', '$ATTACH_ID', '$ATTACH_NAME', '$ATTACH_NAME', '0', '0')";
	   $cursor=exequery(TD::conn(),$query);
	   $AID=mysql_insert_id();
	   echo $AID."<br>";
	   $ATTACHMENT_ID=$AID."@".$YM."_".$ATTACH_ID;
	   echo $ATTACHMENT_ID."<br>";
	   
	   //插入公共附件  单个的
	   
	   $query2="INSERT INTO `TD_OA`.`flow_run_attach` ( `RUN_ID`, `ATTACHMENT_ID`, `ATTACHMENT_NAME`, `FLOW_PRCS`, `UPLOAD_USER`, `UPLOAD_TIME`) VALUES ( '$run_id', '$ATTACHMENT_ID', '$ATTACH_NAME', '1', 'admin', '$CUR_DATE')";
	   exequery(TD::conn(),$query2);
	   
	   //更新flow_run  多个附件连在一起的
	   $attachemnt_id.=$ATTACHMENT_ID.",";
	   $attachment_name.=$ATTACH_NAME."*";
	   }  //end foreach
	   
	   if($attachemnt_id!=""){
	   $query3="update flow_run set ATTACHMENT_ID='$attachemnt_id',ATTACHMENT_NAME='$attachment_name' where run_id='$run_id'";
	   exequery(TD::conn(),$query3);
	   }
?>
</body>
</html>