📄 index.php

📁 极限网络智能办公系统 - Office Automation 2008 官方100％源码
💻 PHP
📖 第 1 页 / 共 2 页
字号:
12 下一页
<?
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 CheckForm()
{
	 if(document.all("HISTORY_ID").value=="" && document.all("TYPE").value=="")
    {
    	  alert("请选择合同明细！！");
        return (false);
    }
     if (document.all("TYPE").value=="PRO")
   {
    if(document.all("TRANS_QTY").value=="")
    {
    	  alert("交付数量不能空！！");
        return (false);
    }
    }

      if (document.all("TYPE").value=="SER")
   {
    if(document.all("TOTAL_PRICE").value=="")
    {
    	  alert("本次付款额不能空！！");
        return (false);
    }
    }
   document.form1.submit();
}

function checknum(p)
{
  var l = p.length;
  var count=0;
  for(var i=0; i<l; i++)
  {
  var digit = p.charAt(i);
  if(digit == "." )
  {
    ++count;
    if(count>1)
    {
     return 0;
    }
  }
  else if(digit < "0" || digit > "9")
    {
     return 0;
    }
    }
  return 1;
}
function select_value(LINE_ID,PRODUCT_ID,PRODUCT_NAME,SERVICE_ID,SERVICE_NAME,TRANS_PRICE,PTYPE)
{

     if(PTYPE=="PRO")
     {
      document.all("TYPE").value="PRO";
      document.all("LINE_ID").value=LINE_ID;
      document.all("PRO_ID").value=PRODUCT_ID;
      document.all("PRO_NAME").value=PRODUCT_NAME;
      document.all("PRICE").value=TRANS_PRICE;
       document.all("OP").value="ADD";
     	document.all("SER").style.display="none";
     	document.all("TOTALPRICE").style.display="none";
     	if(document.all("PRO").style.display=="none")
      	  document.all("PRO").style.display="";
      if(document.all("PRI").style.display=="none")
      	  document.all("PRI").style.display="";
      if(document.all("QTY").style.display=="none")
      	  document.all("QTY").style.display="";

      document.all("SER_ID").value="";
      document.all("SER_NAME").value="";
      document.all("TOTAL_PRICE").value="";
     }
    else
     {
     	document.all("TYPE").value="SER";
     	document.all("LINE_ID").value=LINE_ID;
     	document.all("SER_ID").value=SERVICE_ID;
      document.all("SER_NAME").value=SERVICE_NAME;
      document.all("TOTAL_PRICE").value="";
       document.all("OP").value="ADD";
      if(document.all("SER").style.display=="none")
         document.all("SER").style.display="";
      if(document.all("TOTALPRICE").style.display=="none")
     	   document.all("TOTALPRICE").style.display="";

      document.all("PRI").style.display="none";
      document.all("QTY").style.display="none";
      document.all("PRO").style.display="none";

       document.all("PRO_ID").value="";
      document.all("PRO_NAME").value="";
      document.all("PRICE").value="";
       document.all("TRANS_QTY").value="";

     }
}

function select_value1(LINE_ID,PRODUCT_ID,PRODUCT_NAME,SERVICE_ID,SERVICE_NAME,TRANS_PRICE,PTYPE,TRANS_QTY,TOTAL_PRICE,HISTORY_ID)
{


     document.all("HISTORY_ID").value=HISTORY_ID;
     if(PTYPE=="PRO")
     {
      document.all("TYPE").value="PRO";
      document.all("LINE_ID").value=LINE_ID;
      document.all("PRO_ID").value=PRODUCT_ID;
      document.all("PRO_NAME").value=PRODUCT_NAME;
      document.all("PRICE").value=TRANS_PRICE;
      document.all("TRANS_QTY").value=TRANS_QTY;
      document.all("OP").value="MOD";
     	document.all("SER").style.display="none";
     	document.all("TOTALPRICE").style.display="none";
     	if(document.all("PRO").style.display=="none")
      	  document.all("PRO").style.display="";
      if(document.all("PRI").style.display=="none")
      	  document.all("PRI").style.display="";
      if(document.all("QTY").style.display=="none")
      	  document.all("QTY").style.display="";

      document.all("SER_ID").value="";
      document.all("SER_NAME").value="";
      document.all("TOTAL_PRICE").value="";
     }
    else
     {
     	document.all("TYPE").value="SER";
     	document.all("LINE_ID").value=LINE_ID;
     	document.all("SER_ID").value=SERVICE_ID;
      document.all("SER_NAME").value=SERVICE_NAME;
      document.all("TOTAL_PRICE").value=TOTAL_PRICE;
       document.all("OP").value="MOD";
      if(document.all("SER").style.display=="none")
         document.all("SER").style.display="";
      if(document.all("TOTALPRICE").style.display=="none")
     	   document.all("TOTALPRICE").style.display="";

      document.all("PRI").style.display="none";
      document.all("QTY").style.display="none";
      document.all("PRO").style.display="none";

       document.all("PRO_ID").value="";
      document.all("PRO_NAME").value="";
      document.all("PRICE").value="";
       document.all("TRANS_QTY").value="";

     }
}

function delete_vote(HISTORY_ID,CONTRACT_ID)
{
 msg='确认删除该合同付款记录吗？';
 if(window.confirm(msg))
 {
  URL="delete.php?HISTORY_ID="+HISTORY_ID+"&CONTRACT_ID="+CONTRACT_ID+"&CUSTOMER_NAME=<?=$CUSTOMER_NAME?>&KIND=<?=$KIND?>&SELLMODE=<?=$SELLMODE?>&CONTRACT_TYPE=<?=$CONTRACT_TYPE?>&DATE_TYPE=<?=$DATE_TYPE?>&CONTRACT_NO=<?=$CONTRACT_NO?>&CONTRACT_NAME=<?=$CONTRACT_NAME?>&CONTRACT_LINKMAN1=<?=$CONTRACT_LINKMAN1?>&CONTRACT_LINKMAN2=<?=$CONTRACT_LINKMAN2?>&DATE1=<?=$DATE1?>&DATE2=<?=$DATE2?>&SIGN=<?=$SIGN?>&CUR_PAGE=<?=$CUR_PAGE?>&ORDERFIELD=<?=$ORDERFIELD?>&ORDERTYPE=<?=$ORDERTYPE?>";
  window.location=URL;
 }
}
function delete_vote1(HISTORY_ID,CONTRACT_ID)
{
 msg='确认删除该合同付款记录吗？';
 if(window.confirm(msg))
 {
  URL="delete.php?HISTORY_ID="+HISTORY_ID+"&CONTRACT_ID="+CONTRACT_ID+"&querstr="+document.all("querstr").value;;
  window.location=URL;
 }
}
</script>
</head>

<body class="bodycolor" topmargin="5">

<?
 //============================显示合同明细=======================================
 $query = "SELECT a.LINE_ID as LINE_ID,b.PRODUCT_ID as PRODUCT_ID,b.PRODUCT_NAME as PRODUCT_NAME,
                   c.SERVICE_ID as SERVICE_ID,c.SERVICE_NAME as SERVICE_NAME,a.TRANS_PRICE as TRANS_PRICE,
                   a.TRANS_QTY as TRANS_QTY,a.TOTAL_PRICE as TOTAL_PRICE,a.PAYMENT as PAYMENT,a.MEMO as MEMO,a.TYPE as TYPE,d.CUSTOMER_ID as CUSTOMER_ID,SUM(e.TOTAL_PRICE) as PAYMENT,SUM(e.AMT) as PAYMENTQTY from CONTRACT_LINE a
            LEFT OUTER JOIN PRODUCT b ON a.PRODUCT_ID = b.PRODUCT_ID AND a.TYPE='PRO'
            LEFT OUTER JOIN SERVICE c ON a.SERVICE_ID = c.SERVICE_ID AND a.TYPE='SER'
            LEFT OUTER JOIN CONTRACT d ON a.CONTRACT_ID = d.CONTRACT_ID
            LEFT OUTER JOIN SALE_HISTORY e ON a.LINE_ID=e.LINE_ID
            where a.CONTRACT_ID='$CONTRACT_ID' GROUP BY a.LINE_ID order by a.TYPE desc";
 $cursor= exequery($connection,$query);
 $VOTE_COUNT=0;
 while($ROW=mysql_fetch_array($cursor))
 {
    $VOTE_COUNT++;
    $LINE_ID=$ROW["LINE_ID"];
    $PRODUCT_ID=$ROW["PRODUCT_ID"];
    $PRODUCT_NAME=$ROW["PRODUCT_NAME"];
    $SERVICE_ID=$ROW["SERVICE_ID"];
    $SERVICE_NAME=$ROW["SERVICE_NAME"];
    $TRANS_PRICE=$ROW["TRANS_PRICE"];
    $TRANS_QTY=$ROW["TRANS_QTY"];
    $TOTAL_PRICE =$ROW["TOTAL_PRICE"];
    $PAYMENT=$ROW["PAYMENT"];
    $PAYMENTQTY=$ROW["PAYMENTQTY"];
    $MEMO=$ROW["MEMO"];
    $TYPE=$ROW["TYPE"];
    $CUSTOMER_ID=$ROW["CUSTOMER_ID"];
    if($VOTE_COUNT==1)
    {
?>
      <table width="95%" border="0" cellspacing="0" cellpadding="0" height="3">
        <tr>
         <td background="/images/dian1.gif" width="100%"></td>
        </tr>
      </table>
      <table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
        <tr>
        <td class="Big"><img src="/images/notify_open.gif" WIDTH="22" HEIGHT="22" align="absmiddle"><span class="big3">&nbsp;合同明细</span>
        </td>
       </tr>
      </table>
     <br>
     <table border="0" cellspacing="1" width="95%" class="small" bgcolor="#000000" cellpadding="3">
     <tr class="TableHeader">
  	  <td nowrap align="center">产品名称</td>
      <td nowrap align="center">服务名称</td>
      <td nowrap align="center">单价</td>
      <td nowrap align="center">计划数量</td>
      <td nowrap align="center">交付数量</td>
        <td nowrap align="center">总价</td>
      <td nowrap align="center">已付款数</td>
12 下一页
⌨️ 快捷键说明

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