📄 delete.php
字号:
<?php
include_once( "inc/auth.php" );
include_once( "inc/utility_file.php" );
include_once( "inc/utility_field.php" );
echo "<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<body class=\"bodycolor\">\r\n";
if ( $CONTRACT_ID != "" )
{
$query = "select ATTACHMENT_ID,ATTACHMENT_NAME from CONTRACT where CONTRACT_ID=".$CONTRACT_ID;
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$ATTACHMENT_ID = $ROW['ATTACHMENT_ID'];
$ATTACHMENT_NAME = $ROW['ATTACHMENT_NAME'];
}
if ( $ATTACHMENT_NAME != "" )
{
$ATTACHMENT_ID_ARRAY = explode( ",", $ATTACHMENT_ID );
$ATTACHMENT_NAME_ARRAY = explode( "*", $ATTACHMENT_NAME );
$ARRAY_COUNT = sizeof( $ATTACHMENT_ID_ARRAY );
$I = 0;
for ( ; do
{
$I < $ARRAY_COUNT; ++$I )
{
if ( $ATTACHMENT_ID_ARRAY[$I] != "" )
{
delete_attach( $ATTACHMENT_ID_ARRAY[$I], $ATTACHMENT_NAME_ARRAY[$I] );
}
break;
}
} while ( 1 );
}
}
else
{
$delete_str = "'".str_replace( ",", "','", substr( $delete_str, 0, -1 ) )."'";
$query = "select ATTACHMENT_ID,ATTACHMENT_NAME from CONTRACT where CONTRACT_ID in (".$delete_str.")";
$cursor = exequery( $connection, $query );
while ( $ROW = mysql_fetch_array( $cursor ) )
{
$ATTACHMENT_ID = $ROW['ATTACHMENT_ID'];
$ATTACHMENT_NAME = $ROW['ATTACHMENT_NAME'];
if ( !( $ATTACHMENT_NAME != "" ) )
{
continue;
}
$ATTACHMENT_ID_ARRAY = explode( ",", $ATTACHMENT_ID );
$ATTACHMENT_NAME_ARRAY = explode( "*", $ATTACHMENT_NAME );
$ARRAY_COUNT = sizeof( $ATTACHMENT_ID_ARRAY );
$I = 0;
for ( ; $I < $ARRAY_COUNT; ++$I )
{
if ( $ATTACHMENT_ID_ARRAY[$I] != "" )
{
delete_attach( $ATTACHMENT_ID_ARRAY[$I], $ATTACHMENT_NAME_ARRAY[$I] );
}
}
}
}
if ( $CONTRACT_ID != "" )
{
$query = "delete from SALE_HISTORY where CONTRACT_ID='".$CONTRACT_ID."'";
exequery( $connection, $query );
$query = "delete from CONTRACT_LINE where CONTRACT_ID='".$CONTRACT_ID."'";
exequery( $connection, $query );
$query = "delete from CONTRACT where CONTRACT_ID='".$CONTRACT_ID."'";
exequery( $connection, $query );
del_field_data( "CONTRACT", $CONTRACT_ID );
}
else
{
$query = "delete from SALE_HISTORY where CONTRACT_ID in (".$delete_str.")";
exequery( $connection, $query );
$query = "delete from CONTRACT_LINE where CONTRACT_ID in (".$delete_str.")";
exequery( $connection, $query );
$query = "delete from CONTRACT where CONTRACT_ID in (".$delete_str.")";
exequery( $connection, $query );
del_field_datastr( "CONTRACT", $delete_str );
}
if ( $querstr != "" )
{
$urlstr1 = str_replace( "%", "&", $querstr );
header( "location: ad_query/list.php?".$urlstr1.( "&CUR_PAGE=".$CUR_PAGE."&ORDERFIELD={$ORDERFIELD}&ORDERTYPE={$ORDERTYPE}" ) );
}
else
{
header( "location: index.php?CUSTOMER_NAME=".$CUSTOMER_NAME."&KIND={$KIND}&SELLMODE={$SELLMODE}&CONTRACT_TYPE={$CONTRACT_TYPE}&DATE_TYPE={$DATE_TYPE}&CONTRACT_NO={$CONTRACT_NO}&CONTRACT_NAME={$CONTRACT_NAME}&CONTRACT_LINKMAN1={$CONTRACT_LINKMAN1}&CONTRACT_LINKMAN2={$CONTRACT_LINKMAN2}&DATE1={$DATE1}&DATE2={$DATE2}&SIGN={$SIGN}&CUR_PAGE={$CUR_PAGE}&ORDERFIELD={$ORDERFIELD}&ORDERTYPE={$ORDERTYPE}" );
}
echo "</body>\r\n</html>\r\n";
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -