delete.php
来自「通达OA2007SE源代码 非常好的」· PHP 代码 · 共 94 行
PHP
94 行
<?
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">
';
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);
for ($I = 0; ($I < $ARRAY_COUNT); ++$I)
{
if (($ATTACHMENT_ID_ARRAY[$I] != ''))
{
delete_attach ($ATTACHMENT_ID_ARRAY[$I], $ATTACHMENT_NAME_ARRAY[$I]);
continue;
}
}
}
}
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 != ''))
{
$ATTACHMENT_ID_ARRAY = explode (',', $ATTACHMENT_ID);
$ATTACHMENT_NAME_ARRAY = explode ('*', $ATTACHMENT_NAME);
$ARRAY_COUNT = sizeof ($ATTACHMENT_ID_ARRAY);
for ($I = 0; ($I < $ARRAY_COUNT); ++$I)
{
if (($ATTACHMENT_ID_ARRAY[$I] != ''))
{
delete_attach ($ATTACHMENT_ID_ARRAY[$I], $ATTACHMENT_NAME_ARRAY[$I]);
continue;
}
}
continue;
}
}
}
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>
</html>
';
?>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?