📄 showdetail.php

📁 极限网络智能办公系统 Office Automation V3.0官方100％源代码.
💻 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>
<?
 $count=0;

 $connection=OpenConnection();
 $query = "select count(*) from FIELDSETTING where TABLENAME='PROVIDER'";
 $cursor=exequery($connection,$query);
 if($ROW=mysql_fetch_array($cursor))
{
   $count=$ROW[0];
}
 if($count>0)
 {
?>
   <tr>
    <td nowrap  class="TableHeader" colspan="8" align="left">
     用户自定义信息：
    </td>
   </tr>
<?
  $query = "select * from FIELDSETTING where TABLENAME='PROVIDER' 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";
?>
 <tr>
    <td nowrap class="TableData"><?=$FIELDNAME?>：</td>
    <td nowrap class="TableData" colspan="7">
<?
    if($STYPE=="T")
    {
?>
    <?=$$FIELDNO1?>
<?
    }
    if($STYPE=="MT")
    {
?>
    <?=$$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])
       	 {
?>
         <?=$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--;
       for($I=0;$I<$TYPENAME_COUNT;$I++)
       {
         $flag=0;
         for($T=0;$T< $temp_ARRAY_count;$T++)
         {
         	  if($temp_ARRAY[$T]==$TYPEVALUE_ARRAY[$I])
         	  {

?>
        <?=$TYPENAME_ARRAY[$I]?>,
<?
            }
        }
      }

     }
     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])
       	 {
?>
        <?=$TYPENAME_ARRAY[$I]?>
<?
        }
       }
    }
?>

    </td>
 </tr>
<?
  }

 }
?>
 <tr>
    <td nowrap  class="TableControl" colspan="8" align="center">
    		&nbsp;&nbsp;<input type="button" value="联系人信息" class="SmallButton" onclick="showlist('linkmanlist.php','<?=$PROVIDER_ID?>')">
    	  &nbsp;<input type="button" value="相关产品" class="SmallButton" onclick="showlist('prodictlist.php','<?=$PROVIDER_ID?>')">
       &nbsp;<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;
  }

}
?>
💿 文件大小 24085 K
👤 上传用户 happy_christina
📂 所属分类 OA系统
🏷️ 相关标签

#Automation #Office #3.0 #100
⌨️ 快捷键说明

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