📄 delete.php
字号:
<?php
include_once( "inc/auth.php" );
include_once( "inc/utility_all.php" );
echo "\r\n<html>\r\n<head>\r\n<title></title>\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\">\r\n</head>\r\n\r\n<body class=\"bodycolor\" topmargin=\"5\">\r\n";
$CUR_DATE = date( "Y-m-d", time( ) );
$TRANS_FLAG = trim( $TRANS_FLAG );
if ( $TRANSID == "" )
{
if ( $TRANS_FLAG != -1 && $TRANS_FLAG != "" )
{
if ( $WHERE_STR == "" )
{
$WHERE_STR .= " where a.TRANS_FLAG='".$TRANS_FLAG."'";
}
else
{
$WHERE_STR .= " and a.TRANS_FLAG='".$TRANS_FLAG."'";
}
}
if ( $PRO_ID != " " && $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 != " " && $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 != " " && $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 != " " && $TO_DATE != "" )
{
if ( $WHERE_STR == "" )
{
$WHERE_STR .= " where a.TRANS_DATE<='".$TO_DATE."'";
}
else
{
$WHERE_STR .= " and a.TRANS_DATE<='".$TO_DATE."'";
}
}
if ( $BORROWER != " " && $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 );
if ( $U_DELETE != "1" )
{
header( "location:index.php" );
}
else
{
header( "location:query.php" );
}
}
else
{
$query = "delete from OFFICE_TRANSHISTORY where TRANS_ID='".$TRANSID."'";
exequery( $connection, $query );
if ( $U_DELETE != "1" )
{
header( "location:detail.php?TRUN=1&ISDELETE=1&TRANS_FLAG=".$TRANS_FLAG."&PRO_ID={$PRO_ID}&PRO_NAME={$PRO_NAME}&FROM_DATE={$FROM_DATE}&TO_DATE={$TO_DATE}&BORROWER={$BORROWER}" );
}
else
{
header( "location:user_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>\r\n</html>\r\n";
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -