📄 showdetail.php
字号:
<?php
function GETALLDATE( $CODE, $GETVALUE )
{
global $connection;
$query = "SELECT * from SYS_CODE where PARENT_NO='".$CODE."'";
$connection = openconnection( );
$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;
}
else
{
echo $CODE_NAME;
}
}
}
include_once( "inc/auth.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\" topmargin=\"5\">\r\n";
$query = "SELECT * from COMPLAINT where COMPLAINT_ID=".$COMPLAINT_ID;
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$COMPLAINT_TYPE1 = $ROW['COMPLAINT_TYPE'];
$CUSTOMER_ID1 = $ROW['CUSTOMER_ID'];
$COMPLAINT_CONTENT1 = $ROW['COMPLAINT_CONTENT'];
$TEL_NO1 = $ROW['TEL_NO'];
$ADDRESS1 = $ROW['ADDRESS'];
$COMPLAINT_DATE1 = $ROW['COMPLAINT_DATE'];
$LINKMAN_ID1 = $ROW['LINKMAN_ID'];
$MEMO11 = $ROW['MEMO'];
$MEMO12 = $ROW['MEMO1'];
$COMPLAINT_REQUEST1 = $ROW['COMPLAINT_REQUEST'];
$CONTACT_TIME1 = $ROW['CONTACT_TIME'];
$USERDEF11 = $ROW['USERDEF1'];
$USERDEF21 = $ROW['USERDEF2'];
$USERDEF31 = $ROW['USERDEF3'];
$USERDEF41 = $ROW['USERDEF4'];
$USERDEF51 = $ROW['USERDEF5'];
}
$query = "SELECT CUSTOMER_NAME from CUSTOMER where CUSTOMER_ID='".$CUSTOMER_ID1."'";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$CUSTOMER_NAME1 = $ROW['CUSTOMER_NAME'];
}
$query = "SELECT LINKMAN_NAME from LINKMAN where LINKMAN_ID='".$LINKMAN_ID1."'";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$LINKMAN_NAME1 = $ROW['LINKMAN_NAME'];
}
echo "<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\">客户投诉信息查看</span>\r\n </td>\r\n </tr>\r\n</table>\r\n<br>\r\n<table border=\"0\" cellspacing=\"1\" width=\"450\" class=\"small\" bgcolor=\"#000000\" cellpadding=\"3\" align=\"center\" >\r\n <form method=\"post\" name=\"form1\">\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\">投诉类型： </td>\r\n <td class=\"TableData\">\r\n";
getalldate( "COMPLAINT_TYPE", $COMPLAINT_TYPE1 );
echo " </td>\r\n <td nowrap class=\"TableData\">投诉日期： </td>\r\n <td nowrap class=\"TableData\">";
echo $COMPLAINT_DATE1;
echo "</td>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableData\">客户名称： </td>\r\n <td class=\"TableData\">";
echo $CUSTOMER_NAME1;
echo "</td>\r\n <td nowrap class=\"TableData\">联系人： </td>\r\n <td nowrap class=\"TableData\">";
echo $LINKMAN_NAME1;
echo "</td>\r\n </tr>\r\n\r\n <tr>\r\n <td nowrap class=\"TableData\">联系电话： </td>\r\n <td class=\"TableData\">";
echo $TEL_NO1;
echo "</td>\r\n <td nowrap class=\"TableData\">联系地址： </td>\r\n <td nowrap class=\"TableData\">";
echo $ADDRESS1;
echo "</td>\r\n </tr>\r\n\r\n <tr>\r\n <td nowrap class=\"TableData\">方便联系时间：</td>\r\n <td nowrap class=\"TableData\" colspan=\"3\">";
echo $CONTACT_TIME1;
echo "</td>\r\n </tr>\r\n\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\">投诉内容： </td>\r\n <td nowrap class=\"TableData\" colspan=\"3\">";
echo $COMPLAINT_CONTENT1;
echo "</td>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableData\">处理要求： </td>\r\n <td nowrap class=\"TableData\" colspan=\"3\">";
echo $COMPLAINT_REQUEST1;
echo "</td>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableData\">备注1： </td>\r\n <td nowrap class=\"TableData\" colspan=\"3\">";
echo $MEMO11;
echo "</td></tr>\r\n <tr>\r\n <td nowrap class=\"TableData\">备注2： </td>\r\n <td nowrap class=\"TableData\" colspan=\"3\">";
echo $MEMO12;
echo "</td>\r\n </tr>\r\n";
$count = 0;
$connection = openconnection( );
$query = "select count(*) from FIELDSETTING where TABLENAME='COMPLAINT'";
$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=\"8\" align=\"left\">\r\n 用户自定义信息：\r\n </td>\r\n </tr>\r\n";
$query = "select * from FIELDSETTING where TABLENAME='COMPLAINT' 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=\"7\">\r\n";
if ( $STYPE == "T" )
{
echo " ";
echo $$FIELDNO1;
}
if ( $STYPE == "MT" )
{
echo " ";
echo $$FIELDNO1;
echo "\r\n";
}
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 "\r\n </td>\r\n </tr>\r\n";
}
}
echo " <tr>\r\n <td nowrap class=\"TableControl\" colspan=\"4\" align=\"center\">\r\n <input type=\"button\" value=\"关闭\" class=\"SmallButton\" onclick=\"window.close()\">\r\n </td>\r\n </tr>\r\n</form>\r\n</table>\r\n</body>\r\n</html>\r\n";
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -