📄 delete_hrms.php

📁 通达OA官方提供的30源代码,感觉很实在
💻 PHP
字号:
<?
include_once("inc/auth.php");
include_once("inc/utility_file.php");
include_once("inc/utility_field.php");
ob_start();
?>
<html>
<head>
<title></title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body class="bodycolor" topmargin="5">
<?
if ($USER_ID=="")  //删除部门的所有用户档案
{
	$query="select HRMS.USER_ID from HRMS,USER where HRMS.USER_ID=USER.USER_ID and  USER.DEPT_ID='$DEPT_ID'";
	$cursor= exequery($connection,$query);
 
    while($ROW=mysql_fetch_array($cursor))
    {
        $USER_ID=$ROW["USER_ID"];
		
		$query1="select PHOTO,ATTACHMENT_ID,ATTACHMENT_NAME from HRMS where USER_ID='$USER_ID'";
   	    $cursor1=exequery($connection,$query1);
        if($ROW1=mysql_fetch_array($cursor1))
        {
        	$ATTACHMENT_ID=$ROW1["ATTACHMENT_ID"];
        	$ATTACHMENT_NAME=$ROW1["ATTACHMENT_NAME"];
        	$PHOTO=$ROW1["PHOTO"];
        }
        if($ATTACHMENT_NAME!="")
        { 
            delete_attach($ATTACHMENT_ID,$ATTACHMENT_NAME);
        }
        if($PHOTO!="")
        {
	        $FILENAME=$ATTACH_PATH."hrms_pic/$PHOTO";
	        if(file_exists($FILENAME))
            {
                unlink($FILENAME);
            }
         }
        $query2="delete from HRMS where USER_ID='$USER_ID'";
        exequery($connection,$query2);
        del_field_data("HRMS",$USER_ID);
   	}
}
else  //删除指定用户档案
{
    $query="select PHOTO,ATTACHMENT_ID,ATTACHMENT_NAME from HRMS where USER_ID='$USER_ID'";
    $cursor=exequery($connection,$query);
    if($ROW=mysql_fetch_array($cursor))
    {
        $ATTACHMENT_ID=$ROW["ATTACHMENT_ID"];
        $ATTACHMENT_NAME=$ROW["ATTACHMENT_NAME"];
        $PHOTO=$ROW["PHOTO"];
    }
    if($ATTACHMENT_NAME!="")
    {
        delete_attach($ATTACHMENT_ID,$ATTACHMENT_NAME);
    }
    if($PHOTO!="")
    {
	    $FILENAME=$ATTACH_PATH."hrms_pic/$PHOTO";
	    if(file_exists($FILENAME))
        {
            unlink($FILENAME);
        }
     }
    $query="delete from HRMS where USER_ID='$USER_ID'";
    exequery($connection,$query);
    del_field_data("HRMS",$USER_ID);
}
if($DEPT_ID!="")  //删除全部们的用户档案时
{
?>
<script>
location="user_new.php?DEPT_ID=<?=$DEPT_ID?>";
</script>
<?
}
else  //删除指定用户档案时
{
?>
<script>
location="hrms.php?USER_ID=<?=$USER_ID?>";
</script>
<?
}
?>
</body>
</html>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -