通达OA同步本地文件夹和文件到公共文件柜下

最新推荐文章于 2024-04-28 17:33:17 发布

hai7425

最新推荐文章于 2024-04-28 17:33:17 发布

阅读量197

点赞数

文章标签：数学建模 java python

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

版权


 
<?php
set_time_limit(0);
include_once "inc/conn.php";
include_once "inc/utility_all.php";
include_once "inc/utility_org.php";
include_once("inc/utility_cache.php");
include_once("inc/utility_file.php");  
 $SORT_ID='8596';//文件柜的ID
 $tongbuwenjian='D:/测试';//D盘跟目录的文件夹名称
 
 
 
 
function list_file($date,$SORT_ID){
	
	
		$query2="select a.SORT_ID,a.SORT_TYPE,a.USER_ID,a.NEW_USER,a.MANAGE_USER,a.DEL_USER,a.DOWN_USER,a.SHARE_USER,a.OWNER,a.SIGN_USER,a.REVIEW FROM FILE_SORT as a where a.SORT_ID='$SORT_ID' limit 1";
	$cursor2=exequery(TD::conn(),$query2);
	while($row2=mysql_fetch_array($cursor2)){
		$SORT_PARENT=$row2["SORT_ID"];//车间的id
		$SORT_TYPE=$row2["SORT_TYPE"];
		$USER_ID=$row2["USER_ID"];
		$NEW_USER=$row2["NEW_USER"];
		$MANAGE_USER=$row2["MANAGE_USER"];
		$DEL_USER=$row2["DEL_USER"];
		$DOWN_USER=$row2["DOWN_USER"];
		$SHARE_USER=$row2["SHARE_USER"];
		$OWNER=$row2["OWNER"];
		$SIGN_USER=$row2["SIGN_USER"];
		$REVIEW=$row2["REVIEW"];	
	

	}
        //1、首先先读取文件夹
        $temp=scandir($date);
        //遍历文件夹
        foreach($temp as $v){
            $a=$date.'/'.$v;
			
		 
           if(is_dir($a)){//如果是文件夹则执行
          
               if($v=='.' || $v=='..'){//判断是否为系统隐藏的文件.和..  如果是则跳过否则就继续往下走，防止无限循环再这里。
                   continue;
               }
               echo "<font color='red'>$a</font>"."<br/>"; //把文件夹红名输出
              $query32="INSERT INTO `TD_OA`.`file_sort` ( `SORT_PARENT`, `SORT_NO`, `SORT_NAME`, `SORT_TYPE`, `USER_ID`, `NEW_USER`, `MANAGE_USER`, `DEL_USER`, `DOWN_USER`, `SHARE_USER`, `OWNER`, `SIGN_USER`, `REVIEW`, `DESCRIPTION`) VALUES ( '$SORT_PARENT', '8', '$v', '5', '$USER_ID', '$NEW_USER', '$MANAGE_USER', '$DEL_USER', '$DOWN_USER', '$SHARE_USER', '$OWNER', '$SIGN_USER', '$REVIEW', '')";
		  exequery(TD::conn(),$query32);
		  $sort_id_new=mysql_insert_id();
               list_file($a,$sort_id_new);//因为是文件夹所以再次调用自己这个函数，把这个文件夹下的文件遍历出来
           }else{
            echo $a."<br/>";//全路径文件名称
			$info = pathinfo($a);
//$file_name =  basename($a,'.'.$info['extension']);
$kuozhan=$info["extension"];
$lujing=$info["dirname"];
$mingcheng=$info["filename"];
echo $mingcheng."<br>";

//$mingcheng_new=base64_decode($mingcheng);
//$new_name=$lujing."/".$mingcheng_new.".".$kuozhan;
//@rename($a,$new_name);
// var_dump($info); //echo "*****".$file_name;


/************************************/
$now=date("Y-m-d H:i:s");
		$attachemnt_id="";
	 $attachment_name="";
	 if($YM=="")  $YM=date('ym');
	 
	  $PATH="D:/MYOA/attach/file_folder";
   if(!file_exists($PATH) || !is_dir($PATH))
       mkdir($PATH, 0700);
   $PATH=$PATH."/".$YM;
   if(!file_exists($PATH) || !is_dir($PATH))
       mkdir($PATH, 0700);  
	
	

	
	$ATTACH_ID=mt_rand();
	$ATTACH_NAME=$mingcheng.".".$kuozhan;
	$file1=$a;
	$PATH1=$PATH."/".$ATTACH_ID.".".$ATTACH_NAME;
	echo @copy($file1,$PATH1)?'成功':'失败';
	echo $ATTACH_ID."&&&&".$ATTACH_NAME."<br>";
	
	if($ATTACH_NAME!=""){
	 
	   $query="INSERT INTO `TD_OA`.`attachment` (`POSITION`, `MODULE`, `YM`, `ATTACH_ID`, `ATTACH_FILE`, `ATTACH_NAME`, `ATTACH_SIGN`, `DEL_FLAG`,`MYOA_OFFICE_VER`) VALUES ('2', '3', '$YM', '$ATTACH_ID', '$ATTACH_NAME', '$ATTACH_NAME', '0', '0','2003')";
	   $cursor=exequery(TD::conn(),$query);
	   $AID=mysql_insert_id();
	  // echo $AID."<br>";
	   $ATTACHMENT_ID=$AID."@".$YM."_".$ATTACH_ID;
	 //  echo $ATTACHMENT_ID."<br>";
	   
	   $query9="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', '$mingcheng', '', '$now', '$ATTACHMENT_ID', '$ATTACH_NAME', '', '', '0', '', '', 'admin', '', '')";
	exequery(TD::conn(),$query9);
	}
/************************************/
	
				}
           }
          
        }
		
    
 
list_file($tongbuwenjian,$SORT_ID);
 
?>