通达OA触发器--压缩保存工作流中的表单文件和所有附件到服务器的指定目录（2013adv,2015,2016）

<?
//qq:1027167227
include_once("inc/auth.inc.php");
include_once("inc/utility_file.php");
include_once("../../list/export_flow.php");
include_once("inc/header.inc.php");
include_once("inc/workflow/inc/common.inc.php");
include_once("inc/workflow/inc/workflow.inc.php");
include_once("inc/workflow/tform/twork_export.class.php");
$RUN_ID_STR="7857";
//echo $RUN_ID_STR."<br>";
//workflow/query/explot_zip.php
if($archive_data){
	$archive_time="_".$archive_data;	
	$use_databases = "td_oa_archive.";
}else{
	$archive_time =="";
	$use_databases = "";
}

$zip_name = sprintf(_($RUN_ID_STR."OA工作(%s).zip"), date("Y-m-d",time()));
$zip_file = get_tmp_filename("workflow", $zip_name);

$zip = new ZipArchive;
$res = $zip->open($zip_file, ZipArchive::CREATE|ZIPARCHIVE::OVERWRITE);
if($res !== TRUE)
{
   Message(_("提示"),_("创建文件错误，代码：").$res);
   exit;
}

if($RUN_ID_STR=="")
   $RUN_ID_STR=0;
elseif(substr($RUN_ID_STR,-1,1)==",")
   $RUN_ID_STR=substr($RUN_ID_STR,0,-1);

$tmp_file_array = array();
$tmp_file_array[] = $zip_file;
$query = "SELECT * from FLOW_RUN where RUN_ID IN ($RUN_ID_STR)";
//echo $query."<br>";
$cursor= exequery(TD::conn(),$query);
while($ROW=mysql_fetch_array($cursor))
{
    $zipfiles="";
    $role_str = "";
    $RUN_ID = $run_id     = $ROW["RUN_ID"];
    $flow_id    = $ROW["FLOW_ID"];
    $run_name   = trim($ROW["RUN_NAME"]);
    
    //判断查看权限
    $role_str = run_role($run_id, 0, $archive_time);
    
    //判断保密字段规则 0 - 无保密字段 1 - 根据步骤号获得保密字段 2 - 对所有步骤的保密字段都设定为保密字段
    $flag_hidden_type = 1;
    $table_flow_run_prcs = $use_databases."flow_run_prcs".$archive_time;
    
    if(find_id($role_str, 1) || find_id($role_str, 3) || find_id($role_str, 5) || find_id($role_str, 9) || find_id($role_str, 10) || find_id($role_str, 11))
    {
        //系统管理员、查询、管理、监控、点评、编辑权限人可以看所有字段
        $PRCS_ID = 0;
        $flag_hidden_type = 0;
    }
    else if(find_id($role_str, 2) || find_id($role_str, 4) || find_id($role_str, 6))
    {
        //主办、经办、原始委托人可以查看其办理的最后一步流程步骤的所有字段
        $query2 = "select prcs_id from ".$table_flow_run_prcs."
                  where ID = (
                  select MAX(ID) from ".$table_flow_run_prcs." where RUN_ID = '".$run_id."'
                  AND (USER_ID = '".$_SESSION["LOGIN_USER_ID"]."'
                  or FIND_IN_SET('".$_SESSION["LOGIN_USER_ID"]."',OTHER_USER))) ";
        $cursor2 = exequery(TD::conn(), $query2);
        if($row2 = mysql_fetch_array($cursor2))
        {
            $PRCS_ID = $row2['prcs_id'];
        }
        $flag_hidden_type = 1;
    }
    else if(find_id($role_str, 8) || find_id($role_str, 7))
    {
        //传阅人或者父、子流程权限所有人，所有步骤的保密字段
        $PRCS_ID = 0;
        $flag_hidden_type = 2;
    }
    
    //获取保密字段
    if($flag_hidden_type == 0)
    {
        $secret_fields = "";
    }
    else if($flag_hidden_type == 1)
    {
        //获得设计步骤号
        $query3 = "select FLOW_PRCS from ".$table_flow_run_prcs." where RUN_ID = '".$run_id."' and PRCS_ID = '".$PRCS_ID."' limit 1";
        $cursor3 = exequery(TD::conn(),$query3);
        if($row3 = mysql_fetch_array($cursor3))
        {
            $FLOW_PRCS = $row3['FLOW_PRCS'];
        }
        
        //获得步骤保密字段
        $table_flow_prcocess = $use_databases."flow_process".$archive_time;
        $secret_fields = "";
        $query3 = "select HIDDEN_ITEM from ".$table_flow_prcocess." where FLOW_ID = '".$flow_id."' and PRCS_ID = '".$FLOW_PRCS."' ";
        $cursor3 = exequery(TD::conn(),$query3);
        if($row3 = mysql_fetch_array($cursor3))
        {
            $secret_fields = $row3['HIDDEN_ITEM'];
        }
    }
    else if($flag_hidden_type == 2)
    {
        //获得流程所有步骤的保密字段
        $table_flow_prcocess = $use_databases."flow_process".$archive_time;
        $secret_fields = "";
        $query3 = "select HIDDEN_ITEM from ".$table_flow_prcocess." where FLOW_ID = '".$flow_id."' ";
        $cursor3 = exequery(TD::conn(),$query3);
        while($row3 = mysql_fetch_array($cursor3))
        {
            $secret_fields .= $row3['HIDDEN_ITEM'].",";
        }
        
        //去掉重复的
        $secret_fields = td_trim($secret_fields);
        $secret_fields = str_remove_dup($secret_fields);
    }
    
    $config = Array(
        'FLOW_VIEW' => '12345',
        'db' => $use_databases,
        'archive_time' => $archive_time,
        'secret_fields' => $secret_fields
    );

    $obj_export_zip = new TWorkExport($flow_id, $run_id, 0,0,0, $config);
    $a_export = $obj_export_zip->export_all_run();
	//print_r($a_export);
    $s_attachment_id = $a_export['attachment_id'];
    $s_attachment_name = $a_export['attachment_name'];
    $content_html = $a_export['content_html'];
	
	$query4="select data_2,data_2_key from flow_data_161 where run_id='$RUN_ID' limit 1";
	$cursor4=exequery(TD::conn(),$query4);
	while($row4=mysql_fetch_array($cursor4)){
		$data_2=str_replace("*",",",$row4["data_2"]);
		$data_2_key=$row4["data_2_key"];
		}
	 $s_attachment_id.=$data_2_key; 	
	 $s_attachment_name.=$data_2;
	// echo $s_attachment_id."<br>";
	//echo $s_attachment_name."<br>";
	
    //处理文件名称 /\*:?"<>|
    $j = 0;
    $char="/,\\,*,:,?,\",<,>,|";
    while($j < strlen($run_name))
    {
        $str = substr($run_name, $j, 1);
        if(find_id($char, $str))
        {
            $run_name = str_replace($str,"",$run_name);
        }
        $j++;
    }
    
    if(!$zip->addEmptyDir($run_name))
    {
        continue;
    }
    
    $zip->addFromString($run_name."/".$run_name.".html", $content_html);
   // echo $s_attachment_id."<br>";
    $a_attachment_id = explode(",",$s_attachment_id);
    $a_attachment_name = explode(",",$s_attachment_name);
    
    $feedbck_count_id = sizeof($a_attachment_id);
    for($k=0; $k < $feedbck_count_id; $k++)
    {
        if($a_attachment_id[$k] == '')
        {
            continue;
        }
        
        $filename = attach_real_path($a_attachment_id[$k],$a_attachment_name[$k]);
       
        if(!$filename)
        {
            continue;
        }
        
        $tmp_filename = get_tmp_filename("workflow_attach", basename($filename));
        
        if(decrypt_attach($filename, $tmp_filename))
        {
            $filename = $tmp_filename;
            $tmp_file_array[] = $tmp_filename;
        }
        
        $zip->addFile($filename, $run_name."/".$a_attachment_name[$k]);
    }
}//while

$zip->close();

ob_end_clean();
/*
Header("Cache-control: private");
Header("Content-type: application/x-zip");
header("Accept-Ranges: bytes");
header("Accept-Length: ".sprintf("%u", filesize($zip_file)));
header("Content-Disposition: attachment; ".get_attachment_filename($zip_name));
*/
//readfile($zip_file);
echo $zip_file."<br>";
$PATH="E:/MYOA/attach/".$zip_name;  
echo @copy($zip_file,$PATH)?'成功':'失败';
//echo @rename($file1,$PATH)?'成功':'失败';//2677@1505_1668115426

foreach ($tmp_file_array as $tmp_file)
{
    @unlink($tmp_file);
}
?>