📄 delete.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" topmargin="5">
<?
//-----------合成SQL语句-----------
$CUR_DATE=date("Y-m-d",time());
$TRANS_FLAG=TRIM($TRANS_FLAG);
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");
?>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -