📄 showdetail.php
字号:
<?
include_once("inc/auth.php");
include_once("inc/utility_all.php");
?>
<html>
<head>
<title>供应商详细信息</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<script Language="JavaScript">
function showlist(srcstr,PROVIDER_ID)
{
document.all.EDIT_HTML.height="200%";
document.all.EDIT_HTML.src=srcstr+"?"+"PROVIDER_ID="+PROVIDER_ID;
document.all.list.style.display="";
}
</script>
</head>
<body class="bodycolor" topmargin="5" >
<?
$query = "SELECT * from PROVIDER where PROVIDER_ID=$PROVIDER_ID";
$cursor= exequery($connection,$query);
if($ROW=mysql_fetch_array($cursor))
{
$PROVIDER_NAME1=$ROW["PROVIDER_NAME"];
$PROVIDER_SHORT1=$ROW["PROVIDER_SHORT"];
$PROVIDER_CODE1=$ROW["PROVIDER_CODE"];
$PROVIDER_AREA1=$ROW["PROVIDER_AREA"];
$PROVIDER_RECORDER1=$ROW["PROVIDER_RECORDER"];
$TEL_NO1=$ROW["TEL_NO"];
$FAX_NO1=$ROW["FAX_NO"];
$PROVIDER_WWW1=$ROW["PROVIDER_WWW"];
$EMAIL1=$ROW["EMAIL"];
$PROVIDER_ADD1=$ROW["PROVIDER_ADD"];
$POSTALCODE1=$ROW["POSTALCODE"];
$BANK1=$ROW["BANK"];
$ACCOUNT1=$ROW["ACCOUNT"];
$MEMO11=$ROW["MEMO"];
$USERDEF11=$ROW["USERDEF1"];
$USERDEF21=$ROW["USERDEF2"];
$USERDEF31=$ROW["USERDEF3"];
$USERDEF41=$ROW["USERDEF4"];
$USERDEF51=$ROW["USERDEF5"];
$PROVIDER_DETAILNAME="";
$TOK=strtok($PROVIDER_DETAIL1,",");
while($TOK!="")
{
$query1="select PRODUCT_NAME from PRODUCT where PRODUCT_ID='$TOK'";
$cursor1= exequery($connection,$query1);
if($ROW=mysql_fetch_array($cursor1))
$PROVIDER_DETAILNAME.=$ROW["PRODUCT_NAME"].",";
$TOK=strtok(",");
}
}
?>
<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
<tr>
<td class="Big"><img src="/images/customerdetail.gif" align="absmiddle"><span class="big3"> 供应商详细信息</span>
</td>
</tr>
</table>
<br>
<table border="0" cellspacing="1" width="650" class="small" bgcolor="#000000" cellpadding="3" align="center" >
<form action="update.php" method="post" name="form1" >
<tr>
<td nowrap class="TableHeader" colspan="4" align="left">
基本信息：
</td>
<tr>
<td nowrap class="TableData">供应商名称： </td>
<td nowrap class="TableData" colspan="3">
<?=$PROVIDER_NAME1?>
</td>
</tr>
<tr>
<td nowrap class="TableData">供应商编码： </td>
<td nowrap class="TableData">
<?=$PROVIDER_CODE1?>
</td>
<td nowrap class="TableData">供应商简称： </td>
<td nowrap class="TableData">
<?=$PROVIDER_SHORT1?>
</td>
</tr>
<tr>
<td nowrap class="TableData">电话： </td>
<td nowrap class="TableData">
<?=$TEL_NO1?>
</td>
<td nowrap class="TableData">传真： </td>
<td nowrap class="TableData">
<?=$FAX_NO1?>
</td>
</tr>
<tr>
<td nowrap class="TableData">网址： </td>
<td nowrap class="TableData">
<?=$PROVIDER_WWW1?>
</td>
<td nowrap class="TableData">电子邮件： </td>
<td nowrap class="TableData">
<?=$EMAIL1?>
</td>
</tr>
<tr>
<td nowrap class="TableData">地区： </td>
<td nowrap class="TableData">
<?
GETALLDATE("AREA",$PROVIDER_AREA1);
?>
</td>
<td nowrap class="TableData">邮政编码： </td>
<td nowrap class="TableData">
<?=$POSTALCODE1?>
</td>
</tr>
<tr>
<td nowrap class="TableData">详细地址： </td>
<td nowrap class="TableData" colspan="3">
<?=$PROVIDER_ADD1?>
</td>
</tr>
<tr>
<td nowrap class="TableData">备注： </td>
<td nowrap class="TableData" colspan="3">
<?=$MEMO11?>
</td>
</tr>
<tr>
<td nowrap class="TableHeader" colspan="4" align="left">
财务信息：
</td>
</tr>
<tr>
<td nowrap class="TableData">开户行： </td>
<td nowrap class="TableData" colspan="3">
<?=$BANK1?>
</td>
</tr>
<tr>
<td nowrap class="TableData">帐号： </td>
<td nowrap class="TableData" colspan="3">
<?=$ACCOUNT1?>
</td>
</tr>
<tr>
<td class="TableData" colspan="8">
<?=get_field_table(get_field_text("PROVIDER", $PROVIDER_ID))?>
</td>
</tr>
<tr>
<td nowrap class="TableControl" colspan="8" align="center">
<input type="button" value="联系人信息" class="SmallButton" onclick="showlist('linkmanlist.php','<?=$PROVIDER_ID?>')">
<input type="button" value="相关产品" class="SmallButton" onclick="showlist('prodictlist.php','<?=$PROVIDER_ID?>')">
<input type="button" value="相关报价" class="SmallButton" onclick="showlist('pricelist.php','<?=$PROVIDER_ID?>')">
<input type="button" value="相关证件" class="SmallButton" onclick="showlist('certificatelist.php','<?=$PROVIDER_ID?>')">
<input type="button" value="关闭" class="SmallButton" onclick="window.close()">
</td>
</tr>
<tr id="list" style="display:none">
<td nowrap class="TableData" colspan="8" align="center" height="300%">
<table border="0" width="100%" align="center">
<tr>
<td >
<iframe id="EDIT_HTML" width="100%" frameborder=0 type="text/x-scriptlet" VIEWASTEXT></iframe>
</td>
</tr>
</table>
</td>
</tr>
</form>
</table>
</body>
</html>
<?
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;
}
}
?>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -