📄 showdetail.php

📁 通达网络办公 - Office Anywhere 2008 增强版100％源码(3.4.081216) 内含通达OA2008增強版接近完美破解补丁20081216集及最新通达OA2008ADV(
💻 PHP
字号:
<?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;
		}
	}
}

include_once( "inc/auth.php" );
include_once( "inc/utility_file.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\r\n<script src=\"/inc/js/attach.js\"></script>\r\n<script Language=\"JavaScript\">\r\nfunction Load_Do()\r\n{\r\n  EDIT_HTML.SetHtml(document.form1.CONTRACT_CONTENT.value);\r\n}\r\n</script>\r\n</head>\r\n";
$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 "\r\n<body class=\"bodycolor\" topmargin=\"5\" onload=\"Load_Do();\">\r\n\r\n<table border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"3\" class=\"small\">\r\n  <tr>\r\n    <td class=\"Big\"><img src=\"/images/customerdetail.gif\" align=\"absmiddle\"><span class=\"big3\"> &nbsp;合同详细信息</span>\r\n    </td>\r\n  </tr>\r\n</table>\r\n<br>\r\n\r\n<table border=\"0\" cellspacing=\"1\" width=\"90%\"  class=\"small\"  bgcolor=\"#000000\" cellpadding=\"3\" align=\"center\" >\r\n  <form action=\"add.php\" enctype=\"multipart/form-data\"  method=\"post\" name=\"form1\" onsubmit=\"return CheckForm();\">\r\n   <tr>\r\n    <td nowrap  class=\"TableHeader\" colspan=\"4\" align=\"left\">\r\n    合同基本信息：\r\n    </td>\r\n   </tr>\r\n   <tr>\r\n   \t<td nowrap class=\"TableData\" width=\"5%\">客户名称： </td>\r\n    <td class=\"TableData\">\r\n      ";
echo $CUSTOMER_NAME1;
echo "      </td>\r\n    <td nowrap class=\"TableData\" width=\"5%\">合同编号： </td>\r\n    <td nowrap class=\"TableData\">\r\n       ";
echo $CONTRACT_NO1;
echo "    </td>\r\n   </tr>\r\n\r\n   <tr>\r\n   <td nowrap class=\"TableData\">合同类型： </td>\r\n    <td nowrap class=\"TableData\">\r\n      \r\n";
getalldate( "CONTRACT_TYPE", $CONTRACT_TYPE1 );
echo "   </td>\r\n    <td nowrap class=\"TableData\">合同打印样式： </td>\r\n    <td nowrap class=\"TableData\">\r\n      产品销售合同\r\n    </td>\r\n   </tr>\r\n\r\n\r\n    <tr>\r\n    <td nowrap class=\"TableData\">合同名称： </td>\r\n    <td nowrap class=\"TableData\" colspan=\"3\">\r\n     ";
echo $CONTRACT_NAME1;
echo "    </td>\r\n   </tr>\r\n\r\n    <tr>\r\n    <td nowrap class=\"TableData\">合同描述： </td>\r\n    <td  class=\"TableData\" colspan=\"3\">\r\n    \t ";
echo $CONTRACT_MEMO;
echo "    </td>\r\n   </tr>\r\n    <tr>\r\n    <td nowrap class=\"TableData\">合同条款： </td>\r\n    <td  class=\"TableData\" colspan=\"3\">\r\n    \t";
echo $CONTRACT_ARTICLE;
echo "    </td>\r\n   </tr>\r\n   <tr>\r\n    <td nowrap class=\"TableData\">合同内容： </td>\r\n    <td class=\"TableData\" colspan=\"3\">\r\n    \t ";
echo $CONTRACT_CONTENT;
echo "    </td>\r\n   </tr>\r\n  <tr>\r\n    <td nowrap class=\"TableData\">生效日期： </td>\r\n    <td nowrap class=\"TableData\">\r\n        ";
echo $BEGIN_DATE;
echo "    </td>\r\n    <td nowrap class=\"TableData\">终止日期： </td>\r\n    <td nowrap class=\"TableData\">\r\n        ";
echo $END_DATE;
echo "    </td>\r\n  </tr>\r\n  <tr>\r\n    <td nowrap class=\"TableData\">签约人（买方）： </td>\r\n    <td nowrap class=\"TableData\">\r\n        ";
echo $CONTRACT_LINKMAN11;
echo "    </td>\r\n     <td nowrap class=\"TableData\">签约人（卖方）： </td>\r\n    <td nowrap class=\"TableData\">\r\n       \r\n";
$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>\r\n   </tr>\r\n  <tr>\r\n    <td nowrap class=\"TableData\">创建日期： </td>\r\n    <td nowrap class=\"TableData\">\r\n     ";
echo $CREATE_DATE;
echo "    </td>\r\n     <td nowrap class=\"TableData\">创建人： </td>\r\n    <td nowrap class=\"TableData\">\r\n    \r\n";
$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>\r\n   </tr>\r\n    <tr>\r\n    <td nowrap class=\"TableData\">合同附件： </td>\r\n    <td nowrap class=\"TableData\" colspan=\"3\">\r\n";
echo attach_link( $ATTACHMENT_ID, $ATTACHMENT_NAME, 1, 1, 0, 0, 0, 1, 0, 0 );
echo "    </td>\r\n   </tr>\r\n<tr>\r\n <td nowrap  class=\"TableHeader\" colspan=\"4\" align=\"left\">\r\n  备注：\r\n </td>\r\n</tr>\r\n<tr>\r\n <td nowrap class=\"TableData\">备注1： </td>\r\n    <td nowrap class=\"TableData\" colspan=\"3\">\r\n       ";
echo $MEMO;
echo "    </td>\r\n</tr>\r\n\r\n<tr>\r\n <td nowrap class=\"TableData\">备注2： </td>\r\n    <td nowrap class=\"TableData\" colspan=\"3\">\r\n        ";
echo $MEMO1;
echo "    </td>\r\n</tr>\r\n";
$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>\r\n    <td nowrap  class=\"TableHeader\" colspan=\"4\" align=\"left\">\r\n      用户自定义字段：\r\n\r\n    </td>\r\n   </tr>\r\n";
	$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>\r\n    <td nowrap class=\"TableData\">";
		echo $FIELDNAME;
		echo "：</td>\r\n    <td nowrap class=\"TableData\" colspan=\"3\">\r\n";
		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;
			}
			$I = 0;
			for ( ;	$I < $TYPENAME_COUNT;	++$I	)
			{
				if ( $$FIELDNO1 == $TYPEVALUE_ARRAY[$I] )
				{
					echo "         ";
					echo $TYPENAME_ARRAY[$I];
				}
			}
		}
		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;
			}
			$I = 0;
			for ( ;	$I < $TYPENAME_COUNT;	++$I	)
			{
				$flag = 0;
				$T = 0;
				for ( ;	$T < $temp_ARRAY_count;	++$T	)
				{
					if ( $temp_ARRAY[$T] == $TYPEVALUE_ARRAY[$I] )
					{
						echo "        ";
						echo $TYPENAME_ARRAY[$I];
						echo ",\r\n";
					}
				}
			}
		}
		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;
			}
			$I = 0;
			for ( ;	$I < $TYPENAME_COUNT;	++$I	)
			{
				if ( $$FIELDNO1 == $TYPEVALUE_ARRAY[$I] )
				{
					echo "        ";
					echo $TYPENAME_ARRAY[$I];
				}
			}
		}
		echo "    </td>\r\n </tr>\r\n";
	}
}
echo " <tr>\r\n    <td nowrap  class=\"TableControl\" colspan=\"4\" align=\"center\">\r\n        <input type=\"button\" value=\"关闭\"  onclick=\"window.close()\" class=\"BigButton\"  name=\"button\">&nbsp;\r\n    </td>\r\n   </tr>\r\n  </form>\r\n</table>\r\n\r\n</body>\r\n</html>\r\n";
?>
💿 文件大小 17584 K
👤 上传用户 Rosa_
📂 所属分类 OA系统
🏷️ 相关标签

#2008 #Anywhere #20081216 #Office
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -