📄 delete.php

📁 极限网络智能办公系统 - Office Automation 2008 官方100％源码
💻 PHP
字号:
<?
include_once("inc/auth.php");
include_once("inc/utility_all.php");
?>
<html>
<head>
<title>删除合同</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body class="bodycolor">
<?
if($CONTRACT_ID!="")
{
  $query="select ATTACHMENT_ID,ATTACHMENT_NAME from CONTRACT where CONTRACT_ID=$CONTRACT_ID";
  $cursor= exequery($connection,$query);
  if($ROW=mysql_fetch_array($cursor))
  {
    $ATTACHMENT_ID=$ROW["ATTACHMENT_ID"];
    $ATTACHMENT_NAME=$ROW["ATTACHMENT_NAME"];
  }
  if($ATTACHMENT_NAME!="")
  {
     $ATTACHMENT_ID_ARRAY=explode(",",$ATTACHMENT_ID);
     $ATTACHMENT_NAME_ARRAY=explode("*",$ATTACHMENT_NAME);

     $ARRAY_COUNT=sizeof($ATTACHMENT_ID_ARRAY);
     for($I=0;$I<$ARRAY_COUNT;$I++)
     {
        if($ATTACHMENT_ID_ARRAY[$I]!="")
           delete_attach($ATTACHMENT_ID_ARRAY[$I],$ATTACHMENT_NAME_ARRAY[$I]);
     }
   }
}
else
{
	$delete_str="'".str_replace(",","','",substr($delete_str,0,-1))."'";
  $query="select ATTACHMENT_ID,ATTACHMENT_NAME from CONTRACT where CONTRACT_ID in ($delete_str)";
  $cursor= exequery($connection,$query);
  while($ROW=mysql_fetch_array($cursor))
  {
    $ATTACHMENT_ID=$ROW["ATTACHMENT_ID"];
    $ATTACHMENT_NAME=$ROW["ATTACHMENT_NAME"];
    if($ATTACHMENT_NAME!="")
   {
     $ATTACHMENT_ID_ARRAY=explode(",",$ATTACHMENT_ID);
     $ATTACHMENT_NAME_ARRAY=explode("*",$ATTACHMENT_NAME);

     $ARRAY_COUNT=sizeof($ATTACHMENT_ID_ARRAY);
     for($I=0;$I<$ARRAY_COUNT;$I++)
     {
        if($ATTACHMENT_ID_ARRAY[$I]!="")
           delete_attach($ATTACHMENT_ID_ARRAY[$I],$ATTACHMENT_NAME_ARRAY[$I]);
      }
    }

   }
}
if($CONTRACT_ID!="")
{
 $query="delete from SALE_HISTORY where CONTRACT_ID='$CONTRACT_ID'";      
 exequery($connection,$query);
 $query="delete from CONTRACT_LINE where CONTRACT_ID='$CONTRACT_ID'";      
 exequery($connection,$query);
 $query="delete from CONTRACT where CONTRACT_ID='$CONTRACT_ID'";      
 exequery($connection,$query);  
 del_field_data("CONTRACT",$CONTRACT_ID);
}
else
{
 $query="delete from SALE_HISTORY where CONTRACT_ID in ($delete_str)";      
 exequery($connection,$query);
 $query="delete from CONTRACT_LINE where CONTRACT_ID in ($delete_str)";     
 exequery($connection,$query);
 $query="delete from CONTRACT where CONTRACT_ID in ($delete_str)";      
 exequery($connection,$query); 
 del_field_datastr("CONTRACT",$delete_str);      
}
if($querstr!="")
{
  $urlstr1=str_replace("%","&",$querstr);
	header("location: ad_query/list.php?".$urlstr1."&CUR_PAGE=$CUR_PAGE&ORDERFIELD=$ORDERFIELD&ORDERTYPE=$ORDERTYPE");
}
else
{
header("location: index.php?CUSTOMER_NAME=$CUSTOMER_NAME&KIND=$KIND&SELLMODE=$SELLMODE&CONTRACT_TYPE=$CONTRACT_TYPE&DATE_TYPE=$DATE_TYPE&CONTRACT_NO=$CONTRACT_NO&CONTRACT_NAME=$CONTRACT_NAME&CONTRACT_LINKMAN1=$CONTRACT_LINKMAN1&CONTRACT_LINKMAN2=$CONTRACT_LINKMAN2&DATE1=$DATE1&DATE2=$DATE2&SIGN=$SIGN&CUR_PAGE=$CUR_PAGE&ORDERFIELD=$ORDERFIELD&ORDERTYPE=$ORDERTYPE");
}
?>
</body>
</html>
⌨️ 快捷键说明

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