delete.php

来自「通达OA2007SE源代码 非常好的」· PHP 代码 · 共 96 行

PHP
96
字号
<?
  include_once 'inc/auth.php';
  include_once 'inc/utility_all.php';
  echo '
<html>
<head>
<title></title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body class="bodycolor" topmargin="5">
';
  $CUR_DATE = date ('Y-m-d', time ());
  $TRANS_FLAG = trim ($TRANS_FLAG);
  if (($TRANSID == ''))
  {
    if (($TRANS_FLAG != -1))
    {
      if (($WHERE_STR == ''))
      {
        ($WHERE_STR .= (((''.' where a.TRANS_FLAG=\'').$TRANS_FLAG).'\''));
      }
      else
      {
        ($WHERE_STR .= (((''.' and a.TRANS_FLAG=\'').$TRANS_FLAG).'\''));
      }
    }
    if ((($PRO_ID != ' ') AND ($PRO_ID != '')))
    {
      if (($WHERE_STR == ''))
      {
        ($WHERE_STR .= (((''.' where a.PRO_ID=\'').$PRO_ID).'\''));
      }
      else
      {
        ($WHERE_STR .= (((''.' and a.PRO_ID=\'').$PRO_ID).' \''));
      }
    }
    if ((($PRO_NAME != ' ') AND ($PRO_NAME != '')))
    {
      if (($WHERE_STR == ''))
      {
        ($WHERE_STR .= ((' where b.PRO_NAME like \'%'.$PRO_NAME).'%\''));
      }
      else
      {
        ($WHERE_STR .= ((' and b.PRO_NAME like \'%'.$PRO_NAME).'%\''));
      }
    }
    if ((($FROM_DATE != ' ') AND ($FROM_DATE != '')))
    {
      if (($WHERE_STR == ''))
      {
        ($WHERE_STR .= (((''.' where a.TRANS_DATE>=\'').$FROM_DATE).'\''));
      }
      else
      {
        ($WHERE_STR .= (((''.' and a.TRANS_DATE>=\'').$FROM_DATE).'\''));
      }
    }
    if ((($TO_DATE != ' ') AND ($TO_DATE != '')))
    {
      if (($WHERE_STR == ''))
      {
        ($WHERE_STR .= (((''.' where a.TRANS_DATE<=\'').$TO_DATE).'\''));
      }
      else
      {
        ($WHERE_STR .= (((''.' and a.TRANS_DATE<=\'').$TO_DATE).'\''));
      }
    }
    if ((($BORROWER != ' ') AND ($BORROWER != '')))
    {
      if (($WHERE_STR == ''))
      {
        ($WHERE_STR .= (((''.' where a.BORROWER=\'').$BORROWER).'\''));
      }
      else
      {
        ($WHERE_STR .= (((''.' and a.BORROWER=\'').$BORROWER).'\''));
      }
    }
    $query = ('delete OFFICE_TRANSHISTORY from OFFICE_TRANSHISTORY a LEFT OUTER JOIN OFFICE_PRODUCTS b ON a.PRO_ID = b.PRO_ID'.$WHERE_STR);
    exequery ($connection, $query);
    header ('location:index.php');
  }
  else
  {
    $query = (((''.'delete from OFFICE_TRANSHISTORY where TRANS_ID=\'').$TRANSID).'\'');
    exequery ($connection, $query);
    header (((((((((((((''.'location:detail.php?TRANS_FLAG=').$TRANS_FLAG).'&PRO_ID=').$PRO_ID).'&PRO_NAME=').$PRO_NAME).'&FROM_DATE=').$FROM_DATE).'&TO_DATE=').$TO_DATE).'&BORROWER=').$BORROWER));
  }
  echo '</body>
</html>
';
?>

⌨️ 快捷键说明

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