通达OA2017按部门创建公共文件柜

通达OA2017按部门创建公共文件柜，把所有代码另存为file_folder.php,存放到webroot目录下，访问http://localhost/file_folder.php，

会自动创建所有的部门的公共文件柜。并同时设置好每个文件柜的所属权限为本部门。

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

$HTML_PAGE_TITLE = _("按部门创建文件柜");
include_once("inc/header.inc.php");


$query="select * from department order by dept_no asc";
$cursor=exequery(TD::conn(),$query);
while($row=mysql_fetch_array($cursor)){
	$dept_id=$row["DEPT_ID"];
	$dept_no=$row["DEPT_NO"];
	$dept_name=$row["DEPT_NAME"];
	$quanxian=$dept_id.",||admin,";
	
	
	$query2="select * from file_sort where SORT_NAME='$dept_name' limit 1";
	$cursor2=exequery(TD::conn(),$query2);
	$num=mysql_num_rows($cursor2);
	if($num==0){
	
	$query1="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 ( '0', '$dept_id', '$dept_name', '5', '$quanxian', '$quanxian', '$quanxian', '$quanxian', '$quanxian', '', '$quanxian', '$quanxian', '$quanxian', '')";
echo $query1."<br>";
exequery(TD::conn(),$query1);
	}
}

?>