通达OA流程触发器使用

按网上流传的方法新建好的触发器，添加自定义的PHP代码，可以用于判断数据正确性

用于流程结束后对上海百胜软件的ERP2自动新增对应的单据

<script>      jQuery.ajaxSetup({          type:"POST",          dataType:"json",          async:false,          cache:false      });             function chkSubIsOver_before_callBack_<?php echo $PRCS_KEY_ID;?>(){          var run_id=jQuery("input[name='run_id']:eq(0)").val();      //获取流水号          var flow_id=jQuery("input[name='flow_id']:eq(0)").val();    //获取流程ID号          //获取表单内控件值  如果需要对表单某个数据做较验，可以使用以下部份              //  var myform=jQuery(window.frames["work_form_data"].document).find("form[name='form1'");         // var val=myform.find(":input[name='DATA_2']").val();  /*        //检查子件是否结束          var chckflag=true;          jQuery.ajax({              url:"/userext/index.php?c=workflow&m=chkSubisOver",              data:{flow_id:flow_id,run_id:run_id},              success:function(res){                  if (!res){                       alert("获取子件数据失败");                      chckflag=false;                  }                  if (!res.rescode){                      alert("该母件的子件还未结束\r子件流水号:\r"+res.resmsg);                      chckflag=false;                  }              }          });          if (!chckflag){             return false;          }  */    }  </script> <?php$serverName = "192.168.1.xxx";    $connectionInfo = array( "Database"=>"y", "UID"=>"", "PWD"=>"");    $conn = sqlsrv_connect( $serverName, $connectionInfo );//$run_id=jQuery(window.frames["work_form_data"].document).find("form[name='form1'");include_once ("inc/auth.inc.php");  ob_end_clean();  include_once ("../plugin.inc.php"); $RUN_DATA = getRunData($RUN_ID);  //var_dump($RUN_DATA);$hostname = gethostbyaddr("127.0.0.1"); $spdm=$RUN_DATA['报损明细']['1']['0'];     //商品条码$sddm=$RUN_DATA['申请人ID'];//商店代码$data=$RUN_DATA['申请时间'];//申请日期 $zsl="-".$RUN_DATA['总件数'];   //报损数量$id=$RUN_ID;//流程ID//var_dump($RUN_DATA['报损明细']);//echo count($RUN_DATA['报损明细']);$sql_djh="select djh from DJBHWH WHERE DJMC='CKTZD' AND BMFS='0' AND DM='0'";    //查询调整单单号$stmt = sqlsrv_query( $conn, $sql_djh );$row_djh = sqlsrv_fetch_array( $stmt, SQLSRV_FETCH_ASSOC);$sql_mxbh="select max(mibh)+1 as  编号 from cktzdmx";    //查询调整单单号$stmt = sqlsrv_query( $conn, $sql_mxbh );$row_mxbh = sqlsrv_fetch_array( $stmt, SQLSRV_FETCH_ASSOC);$today = date("Y-m-d");//echo $row_djh['djh'];echo "<br>";//echo $row_mxbh['编号'];echo "<br>";$djh=$row_djh['djh']+1;switch(strlen($row_djh['djh'])){case 4:$djbh="KA500".$row_djh['djh'];break;case 5:$djbh="KA50".$row_djh['djh'];break;case 6:$djbh="KA5".$row_djh['djh'];break;}//echo $id;   //流水号//插入调整单代码$sql_pdd="insert into cktzd(djbh,rq,djxz,dm1,dm2,dm2_1,qddm,ygdm,sl,je,tj,xc,ys,jz,js,sh,shrq,zdr,shr,llr,rq_4,bz,byzd1,byzd2,byzd5,byzd6,byzd12,zs)values ('".$djbh."','".$today."',0,100,'".$sddm."','000','000','000','".$zsl."','-239',0,0,1,0,0,1,'".$today."','".$_SESSION["LOGIN_USER_NAME"]."','".$_SESSION["LOGIN_USER_NAME"]."',0,'".$today."','OA:".$id."','3',0,'".$_SESSION["LOGIN_USER_NAME"]."','".$hostname."',1,0)";$stmt = sqlsrv_query( $conn, $sql_pdd );if (!$stmt){echo "插入单据号失败，请检查！";}else{//$row_pdd = sqlsrv_fetch_array( $stmt, SQLSRV_FETCH_ASSOC);//echo $sql_pdd;//djh+1更新写入djbhwh$sql_djh1="update DJBHWH set djh='".$djh."'  WHERE DJMC='CKTZD' AND BMFS='0' AND DM='0'";$stmt = sqlsrv_query( $conn, $sql_djh1 );$mibh=0;for($x=1;$x<count($RUN_DATA['报损明细']);$x++){$baosunKeys = array_values( $RUN_DATA['报损明细'][$x] );$tm=substr((array_values($baosunKeys)[0]),0,10);//$tm='2150509018';$ys=substr((array_values($baosunKeys)[0]),-3,2);$cm=substr((array_values($baosunKeys)[0]),-1,1);$sl="-".(array_values($baosunKeys)[2]);$mibh=$mibh+1;//插入明细数据$sql_mx="insert into CKTZDmx (djbh,mibh,spdm,gg1dm,gg2dm,sl,byzd1)values('$djbh','$mibh','$tm','$ys','$cm','$sl',1)";$stmt = sqlsrv_query( $conn, $sql_mx );if(!$stmt){//echo "插入明细数据失败！请检查";echo "<script language=\"JavaScript\">alert(\"插入单据号失败，请检查！\");</script>";echo "<br>";echo $tm."<br>";echo $ys."<br>";echo $cm."<br>";$sql_del="delete from cktzd where djbh='".$djbh."'";   //插入明细数据失败，则删除对应的调整单echo $sql_del;$stmt = sqlsrv_query( $conn, $sql_del );}else{//$row_mx = sqlsrv_fetch_array( $stmt, SQLSRV_FETCH_ASSOC);//刷新价格$sql1 = "update CKTZDmx set ckj=(select bzsj from shangpin where shangpin.spdm=CKTZDmx.spdm) where DJBH='".$djbh."';";$sql2 = "update CKTZDmx set zk='1.0' where DJBH='".$djbh."';";$sql3 = "update CKTZDmx set dj=ckj,dj_1=ckj where DJBH='".$djbh."';";$sql4 = "update CKTZDmx set je=sl*(select bzsj from shangpin where shangpin.spdm=CKTZDmx.spdm) where DJBH='".$djbh."';";$sql5 = "update CKTZDmx set bzje=sl*(select bzsj from shangpin where shangpin.spdm=CKTZDmx.spdm) where DJBH='".$djbh."';";$sql6 = "update CKTZD set je=(select sum(je) from CKTZDmx where djbh='".$djbh."')  where djbh='".$djbh."';"; $sql7 = "update CKTZD set bzje=(select sum(bzje) from CKTZDmx where djbh='".$djbh."')  where djbh='".$djbh."';";$stmt = sqlsrv_query( $conn, $sql1 );$stmt = sqlsrv_query( $conn, $sql2 );$stmt = sqlsrv_query( $conn, $sql3 );$stmt = sqlsrv_query( $conn, $sql4 );$stmt = sqlsrv_query( $conn, $sql5 );$stmt = sqlsrv_query( $conn, $sql6 );$stmt = sqlsrv_query( $conn, $sql7 );echo $djbh."单据添加成功!";$sql_rz = "INSERT INTO XTRZB(GUID,IP,JQ,DT,CZDX,DJMC,DJBH,YDJH,CZ,ZYMC,MODULE,EXECMODULE) VALUES('','','".$hostname. "',getdate(),'1','cktzd','".$djbh."','','INSERT','".$_SESSION["LOGIN_USER_NAME"]."',0,'分销')";$stmt = sqlsrv_query( $conn, $sql_rz );}}}?>