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 + -
显示快捷键?