📄 showdetail.php
字号:
<?
function getalldate ($CODE, $GETVALUE)
{
global $connection;
$query = (((''.'SELECT * from SYS_CODE where PARENT_NO=\'').$CODE).'\'');
$cursor = exequery ($connection, $query);
while ($ROW = mysql_fetch_array ($cursor))
{
$CODE_NO = $ROW['CODE_NO'];
$CODE_NAME = $ROW['CODE_NAME'];
if (($CODE_NO == $GETVALUE))
{
echo $CODE_NAME;
continue;
}
}
}
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">
';
echo '<s';
echo 'cript Language="JavaScript">
function Load_Do()
{
EDIT_HTML.SetHtml(document.form1.CONTRACT_CONTENT.value);
}
</script>
</head>
';
$CREATE_DATE = date ('Y-m-d', time ());
if (($CONTRACT_ID != ''))
{
$query = (((''.'select * from CONTRACT where CONTRACT_ID=\'').$CONTRACT_ID).'\'');
$cursor = exequery ($connection, $query);
if ($ROW = mysql_fetch_array ($cursor))
{
$CONTRACT_ID = $ROW['CONTRACT_ID'];
$CONTRACT_NO1 = $ROW['CONTRACT_NO'];
$CONTRACT_NAME1 = $ROW['CONTRACT_NAME'];
$CONTRACT_TYPE1 = $ROW['CONTRACT_TYPE'];
$CONTRACT_ARTICLE = $ROW['CONTRACT_ARTICLE'];
$CONTRACT_CONTENT = $ROW['CONTRACT_CONTENT'];
$ATTACHMENT_ID = $ROW['ATTACHMENT_ID'];
$ATTACHMENT_NAME = $ROW['ATTACHMENT_NAME'];
$CONTRACT_PRINT = $ROW['CONTRACT_PRINT'];
$CONTRACT_MEMO = $ROW['CONTRACT_MEMO'];
$CUSTOMER_ID = $ROW['CUSTOMER_ID'];
$CONTRACT_LINKMAN11 = $ROW['CONTRACT_LINKMAN1'];
$CONTRACT_LINKMAN21 = $ROW['CONTRACT_LINKMAN2'];
$SELLER1 = $ROW['SELLER'];
$CREATE_DATE = $ROW['CREATE_DATE'];
$BEGIN_DATE = $ROW['BEGIN_DATE'];
$END_DATE = $ROW['END_DATE'];
if (($END_DATE == '0000-00-00'))
{
$END_DATE = '';
}
if (($BEGIN_DATE == '0000-00-00'))
{
$BEGIN_DATE = '';
}
if (($CREATE_DATE == '0000-00-00'))
{
$CREATE_DATE = '';
}
$MEMO = $ROW['MEMO'];
$MEMO1 = $ROW['MEMO1'];
$USERDEF11 = $ROW['USERDEF1'];
$USERDEF21 = $ROW['USERDEF2'];
$USERDEF31 = $ROW['USERDEF3'];
$USERDEF41 = $ROW['USERDEF4'];
$USERDEF51 = $ROW['USERDEF5'];
}
}
$query2 = (((''.'select CUSTOMER_NAME from CUSTOMER where CUSTOMER_ID=\'').$CUSTOMER_ID).'\'');
$cursor2 = exequery ($connection, $query2);
if ($ROW = mysql_fetch_array ($cursor2))
{
$CUSTOMER_NAME1 = $ROW['CUSTOMER_NAME'];
}
echo '
<body class="bodycolor" topmargin="5" onload="Load_Do();">
<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
<tr>
<td class="Big"><img src="/images/customerdetail.gif" align="absmiddle">';
echo '<s';
echo 'pan class="big3"> 合同详细信息</span>
</td>
</tr>
</table>
<br>
<table border="0" cellspacing="1" width="90%" class="small" bgcolor="#000000" cellpadding="3" align="center" >
<form action="add.php" enctype="multipart/form-data" method="post" name="form1" onsubmit="return CheckForm();">
<tr>
<td nowrap class="TableHeader" colspan="4" align="left">
合同基本信息：
';
echo '</td>
</tr>
<tr>
<td nowrap class="TableData" width="5%">客户名称： </td>
<td class="TableData">
';
echo $CUSTOMER_NAME1;
echo ' </td>
<td nowrap class="TableData" width="5%">合同编号： </td>
<td nowrap class="TableData">
';
echo $CONTRACT_NO1;
echo ' </td>
</tr>
<tr>
<td nowrap class="TableData">合同类型： </td>
<td nowrap class="TableData">
';
getalldate ('CONTRACT_TYPE', $CONTRACT_TYPE1);
echo ' </td>
<td nowrap class="TableData">合同打印样式： </td>
<td nowrap class="TableData">
产品销售合同
</td>
</tr>
<tr>
<td nowrap class="TableData">合同名称： </td>
<td nowrap class="TableData" colspan="3">
';
echo $CONTRACT_NAME1;
echo ' </td>
</tr>
<tr>
<td nowrap class="TableData">合同描述： </td>
<td class="TableData" colspan="3">
';
echo $CONTRACT_MEMO;
echo ' </td>
</tr>
<tr>
<td nowrap class="TableData">合同条款： </td>
<td class="TableData" colspan="3">
';
echo $CONTRACT_ARTICLE;
echo ' </td>
</tr>
<tr>
<td nowrap class="TableData">合同内容： </td>
<td class="TableData" colspan="3">
';
echo $CONTRACT_CONTENT;
echo ' </td>
</tr>
<tr>
<td nowrap class="TableData">生效日期： </td>
<td nowrap class="TableData">
';
echo $BEGIN_DATE;
echo ' </td>
<td nowrap class="TableData">终止日期： </td>
<td nowrap class="TableData">
';
echo $END_DATE;
echo ' </td>
</tr>
<tr>
<td nowrap class="TableData">签约人（买方）： </td>
<td nowrap class="TableData">
';
echo $CONTRACT_LINKMAN11;
echo ' </td>
<td nowrap class="TableData">签约人（卖方）： </td>
<td nowrap class="TableData">
';
$query2 = (((''.'select USER_NAME from USER where USER_ID=\'').$CONTRACT_LINKMAN21).'\'');
$cursor2 = exequery ($connection, $query2);
if ($ROW = mysql_fetch_array ($cursor2))
{
$LINKMAN2_NAME = $ROW['USER_NAME'];
}
echo ' ';
echo $LINKMAN2_NAME;
echo ' </td>
</tr>
<tr>
<td nowrap class="TableData">创建日期： </td>
<td nowrap class="TableData">
';
echo $CREATE_DATE;
echo ' </td>
<td nowrap class="TableData">创建人： </td>
<td nowrap class="TableData">
';
$query2 = (((''.'select USER_NAME from USER where USER_ID=\'').$SELLER1).'\'');
$cursor2 = exequery ($connection, $query2);
if ($ROW = mysql_fetch_array ($cursor2))
{
$SELLER1_NAME = $ROW['USER_NAME'];
}
echo ' ';
echo $SELLER1_NAME;
echo ' </td>
</tr>
<tr>
<td nowrap class="TableData">合同附件： </td>
<td nowrap class="TableData" colspan="3">
';
echo attach_link ($ATTACHMENT_ID, $ATTACHMENT_NAME, 1, 1, 0, 0, 0, 1, 0, 0);
echo ' </td>
</tr>
<tr>
<td nowrap class="TableHeader" colspan="4" align="left">
备注：
</td>
</tr>
<tr>
<td nowrap class="TableData">备注1： </td>
<td nowrap class="TableData" colspan="3">
';
echo $MEMO;
echo ' </td>
</tr>
<tr>
<td nowrap class="TableData">备注2： </td>
<td nowrap class="TableData" colspan="3">
';
echo $MEMO1;
echo ' </td>
</tr>
';
$count = 0;
$query = 'select count(*) from FIELDSETTING where TABLENAME=\'CONTRACT\'';
$cursor = exequery ($connection, $query);
if ($ROW = mysql_fetch_array ($cursor))
{
$count = $ROW[0];
}
if ((0 < $count))
{
echo ' <tr>
<td nowrap class="TableHeader" colspan="4" align="left">
用户自定义字段：
</td>
</tr>
';
$query = 'select * from FIELDSETTING where TABLENAME=\'CONTRACT\' ORDER BY ORDERNO ASC ';
$cursor = exequery ($connection, $query);
while ($ROW = mysql_fetch_array ($cursor))
{
$FIELDNAME = $ROW['FIELDNAME'];
$ORDERNO = $ROW['ORDERNO'];
$STYPE = $ROW['STYPE'];
$TYPENAME = $ROW['TYPENAME'];
$TYPEVALUE = $ROW['TYPEVALUE'];
$TYPECODE = $ROW['TYPECODE'];
$ISQUERY = $ROW['ISQUERY'];
$ISGROUY = $ROW['ISGROUY'];
$FIELDNAME = $ROW['FIELDNAME'];
$FIELDNO = $ROW['FIELDNO'];
$FIELDNO1 = ($FIELDNO.'1');
echo ' <tr>
<td nowrap class="TableData">';
echo $FIELDNAME;
echo '：</td>
<td nowrap class="TableData" colspan="3">
';
if (($STYPE == 'T'))
{
echo ' ';
echo $$FIELDNO1;
}
if (($STYPE == 'MT'))
{
echo ' ';
echo $$FIELDNO1;
}
if (($STYPE == 'D'))
{
$TYPEVALUE = str_replace ('，', ',', $TYPEVALUE);
$TYPEVALUE_ARRAY = explode (',', $TYPEVALUE);
$TYPENAME = str_replace ('，', ',', $TYPENAME);
$TYPENAME_ARRAY = explode (',', $TYPENAME);
$TYPENAME_COUNT = sizeof ($TYPENAME_ARRAY);
if (($TYPENAME_ARRAY[($TYPENAME_COUNT - 1)] == ''))
{
--$TYPENAME_COUNT;
}
for ($I = 0; ($I < $TYPENAME_COUNT); ++$I)
{
if (($$FIELDNO1 == $TYPEVALUE_ARRAY[$I]))
{
echo ' ';
echo $TYPENAME_ARRAY[$I];
continue;
}
}
}
if (($STYPE == 'C'))
{
$temp = str_replace ('，', ',', $$FIELDNO1);
$temp_ARRAY = explode (',', $temp);
$temp_ARRAY_count = sizeof ($temp_ARRAY);
$TYPEVALUE = str_replace ('，', ',', $TYPEVALUE);
$TYPEVALUE_ARRAY = explode (',', $TYPEVALUE);
$TYPENAME = str_replace ('，', ',', $TYPENAME);
$TYPENAME_ARRAY = explode (',', $TYPENAME);
$TYPENAME_COUNT = sizeof ($TYPENAME_ARRAY);
if (($TYPENAME_ARRAY[($TYPENAME_COUNT - 1)] == ''))
{
--$TYPENAME_COUNT;
}
for ($I = 0; ($I < $TYPENAME_COUNT); ++$I)
{
$flag = 0;
for ($T = 0; ($T < $temp_ARRAY_count); ++$T)
{
if (($temp_ARRAY[$T] == $TYPEVALUE_ARRAY[$I]))
{
echo ' ';
echo $TYPENAME_ARRAY[$I];
echo ',
';
continue;
}
}
}
}
if (($STYPE == 'R'))
{
$TYPEVALUE = str_replace ('，', ',', $TYPEVALUE);
$TYPEVALUE_ARRAY = explode (',', $TYPEVALUE);
$TYPENAME = str_replace ('，', ',', $TYPENAME);
$TYPENAME_ARRAY = explode (',', $TYPENAME);
$TYPENAME_COUNT = sizeof ($TYPENAME_ARRAY);
if (($TYPENAME_ARRAY[($TYPENAME_COUNT - 1)] == ''))
{
--$TYPENAME_COUNT;
}
for ($I = 0; ($I < $TYPENAME_COUNT); ++$I)
{
if (($$FIELDNO1 == $TYPEVALUE_ARRAY[$I]))
{
echo ' ';
echo $TYPENAME_ARRAY[$I];
continue;
}
}
}
echo ' </td>
</tr>
';
}
}
echo ' <tr>
<td nowrap class="TableControl" colspan="4" align="center">
<input type="button" value="关闭" onclick="window.close()" class="BigButton" name="button">
</td>
</tr>
</form>
</table>
</body>
</html>
';
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -