📄 contractlist.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 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"];
?>

<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"><span class="big3"> &nbsp;合同详细信息</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">
    合同基本信息：
    </td>
   </tr>
   <tr>
   	<td nowrap class="TableData" width="5%">客户名称： </td>
    <td class="TableData">
      <?=$CUSTOMER_NAME1?>
      </td>
    <td nowrap class="TableData" width="5%">合同编号： </td>
    <td nowrap class="TableData">
       <?=$CONTRACT_NO1?>
    </td>
   </tr>

   <tr>
   <td nowrap class="TableData">合同类型： </td>
    <td nowrap class="TableData">
      
<?
        GETALLDATE("CONTRACT_TYPE",$CONTRACT_TYPE1);
?>
   </td>
    <td nowrap class="TableData">合同打印样式： </td>
    <td nowrap class="TableData">
      产品销售合同
    </td>
   </tr>


    <tr>
    <td nowrap class="TableData">合同名称： </td>
    <td nowrap class="TableData" colspan="3">
     <?=$CONTRACT_NAME1?>
    </td>
   </tr>

    <tr>
    <td nowrap class="TableData">合同描述： </td>
    <td  class="TableData" colspan="3">
    	 <?=$CONTRACT_MEMO?>
    </td>
   </tr>
    <tr>
    <td nowrap class="TableData">合同条款： </td>
    <td  class="TableData" colspan="3">
    	<?=$CONTRACT_ARTICLE?>
    </td>
   </tr>
   <tr>
    <td nowrap class="TableData">合同内容： </td>
    <td class="TableData" colspan="3">
    	 <?=$CONTRACT_CONTENT?>
    </td>
   </tr>
  <tr>
    <td nowrap class="TableData">生效日期： </td>
    <td nowrap class="TableData">
        <?=$BEGIN_DATE?>
    </td>
    <td nowrap class="TableData">终止日期： </td>
    <td nowrap class="TableData">
        <?=$END_DATE?>
    </td>
  </tr>
  <tr>
    <td nowrap class="TableData">签约人（买方）： </td>
    <td nowrap class="TableData">
        <?=$CONTRACT_LINKMAN11?>
    </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"];
?>
       <?=$LINKMAN2_NAME?>
    </td>
   </tr>
  <tr>
    <td nowrap class="TableData">创建日期： </td>
    <td nowrap class="TableData">
     <?=$CREATE_DATE?>
    </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"];
?>
       <?=$SELLER1_NAME?>
    </td>
   </tr>
    <tr>
    <td nowrap class="TableData">合同附件： </td>
    <td nowrap class="TableData" colspan="3">
    	 <?
      if($ATTACHMENT_NAME=="")
         echo "无";
      else
      {
         $ATTACHMENT_ID_ARRAY=explode(",",$ATTACHMENT_ID);
         $ATTACHMENT_NAME_ARRAY=explode("*",$ATTACHMENT_NAME);

         $ARRAY_COUNT=sizeof($ATTACHMENT_ID_ARRAY);
         for($I=0;$I<$ARRAY_COUNT;$I++)
         {
            if($ATTACHMENT_ID_ARRAY[$I]=="")
               break;
           $ATTACH_SIZE=attach_size($ATTACHMENT_ID_ARRAY[$I],$ATTACHMENT_NAME_ARRAY[$I]);
           $ATTACH_SIZE=number_format($ATTACH_SIZE,0, ".",",");
?>
       <img src="/images/email_atta.gif" align="absmiddle"><a href="/inc/attach.php?ATTACHMENT_ID=<?=$ATTACHMENT_ID_ARRAY[$I]*3+2?>&ATTACHMENT_NAME=<?=urlencode($ATTACHMENT_NAME_ARRAY[$I])?>" target="_blank"><?=$ATTACHMENT_NAME_ARRAY[$I]?></a>
<?
           if(stristr($ATTACHMENT_NAME_ARRAY[$I],".doc")||stristr($ATTACHMENT_NAME_ARRAY[$I],".ppt")||stristr($ATTACHMENT_NAME_ARRAY[$I],".xls"))
           {
?>
	     <input type="button" value="阅读" class="SmallButton" onClick="window.open('/module/OC?ATTACHMENT_ID=<?=$ATTACHMENT_ID_ARRAY[$I]*3+2?>&ATTACHMENT_NAME=<?=urlencode($ATTACHMENT_NAME_ARRAY[$I])?>&OP=5','<?=$ATTACHMENT_ID_ARRAY[$I]?>','menubar=0,toolbar=0,status=1,scrollbars=1,resizable=1');">&nbsp;
	   
<?
           }
           else if(is_media($ATTACHMENT_NAME_ARRAY[$I]))
           {
?>
	       <input type="button" value="播放" class="SmallButton" onClick="window.open('/module/mediaplayer/index.php?MEDIA_NAME=<?=urlencode($ATTACHMENT_NAME_ARRAY[$I])?>&MEDIA_URL=<?=urlencode("/inc/attach.php?ATTACHMENT_ID=".($ATTACHMENT_ID_ARRAY[$I]*3+2)."&ATTACHMENT_NAME=".urlencode($ATTACHMENT_NAME_ARRAY[$I]))?>','media<?=$ATTACHMENT_ID_ARRAY[$I]?>','menubar=0,toolbar=0,status=1,scrollbars=1,resizable=1');">&nbsp;
<?
           }
?>
       (<?=$ATTACH_SIZE?>字节)<br>
<?
        }
      }
?>
    </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">
       <?=$MEMO?>
    </td>
</tr>

<tr>
 <td nowrap class="TableData">备注2： </td>
    <td nowrap class="TableData" colspan="3">
        <?=$MEMO1?>
    </td>
</tr>
<?
 $count=0;
 $connection=OpenConnection();
 $query = "select count(*) from FIELDSETTING where TABLENAME='CONTRACT'";
 $cursor=exequery($connection,$query);
 if($ROW=mysql_fetch_array($cursor))
{
   $count=$ROW[0];
}
 if($count>0)
 {

?>
   <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";
?>
 <tr>
    <td nowrap class="TableData"><?=$FIELDNAME?>：</td>
    <td nowrap class="TableData" colspan="3">
<?
    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="4" align="center">
        <input type="button" value="关闭"  onclick="window.close()" class="BigButton"  name="button">&nbsp;
    </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 + -