通达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);
}
}
?>