📄 delete.php

📁 极限网络智能办公系统 - Office Automation 2.8 100％源码

💻 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\r\n";
$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 != " " && $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}'";
	}
}
$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" );
echo "\r\n</body>\r\n</html>\r\n";
?>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -