📄 delete_all.php

📁 通达OA官方提供的30源代码,感觉很实在

💻 PHP

字号:

<?
include_once("inc/auth.php");
include_once("inc/utility_file.php");
?>

<html>
<head>
<title></title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>

<body class="bodycolor" topmargin="5">
<?
if($LOGIN_USER_PRIV!="1")
   $query="select * from WORK_PLAN where CREATOR='$LOGIN_USER_ID'";
else
   $query = "select * from WORK_PLAN";   
$cursor=exequery($connection,$query);
while($ROW=mysql_fetch_array($cursor))
{
	 $PLAN_ID.=$ROW["PLAN_ID"].",";
   $ATTACHMENT_ID=$ROW["ATTACHMENT_ID"];
   $ATTACHMENT_NAME=$ROW["ATTACHMENT_NAME"];
   if($ATTACHMENT_NAME!=""&&$ATTACHMENT_ID!="")
      delete_attach($ATTACHMENT_ID,$ATTACHMENT_NAME);
}

if($LOGIN_USER_PRIV!="1")
   $query="delete from WORK_PLAN where CREATOR='$LOGIN_USER_ID'";
else
   $query = "delete from WORK_PLAN";      
exequery($connection,$query);

//删除计划的进度日志和批注
$PLAN_ARRAY=explode(",",$PLAN_ID);
$PLAN_ARRAY_NUM=sizeof($PLAN_ARRAY);
for($I=0;$I<$PLAN_ARRAY_NUM;$I++)
{
   $query="delete from WORK_DETAIL where PLAN_ID='$PLAN_ARRAY[$I]'";
   exequery($connection,$query);
}

header("location: index1.php");
?>

</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -