index.php

来自「通达OA2007SE源代码 非常好的」· PHP 代码 · 共 521 行

PHP
521 行
字号 
<?
  include_once 'inc/auth.php';
  include_once 'inc/utility_all.php';
  echo '
<html>
<head>
<title>合同明细</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
';
  echo '<s';
  echo 'cript Language="JavaScript">
function LoadWindow1()
{
   URL="/module/crm/product_select";
  loc_x=document.body.scrollLeft+event.clientX-event.offsetX-100;
  loc_y=document.body.scrollTop+event.clientY-event.offsetY+170;
  window.showModalDialog(URL,self,"edge:raised;scroll:0;status:0;help:0;resizable:1;dialogWidth:320px;dialogHeight:245px;dialogTop:"+loc_y+"px;dialogLeft:"+loc_x+"px");
}
';
  echo '
function LoadWindow2()
{
  URL="/module/crm/service_select";
  loc_x=document.body.scrollLeft+event.clientX-event.offsetX-100;
  loc_y=document.body.scrollTop+event.clientY-event.offsetY+170;
  window.showModalDialog(URL,self,"edge:raised;scroll:0;status:0;help:0;resizable:1;dialogWidth:320px;dialogHeight:245px;dialogTop:"+loc_y+"px;dialogLeft:"+loc_x+"px");
}
function CheckForm()
{
';
  echo '   if (document.all("TYPE").value=="PRO")
    {
    	if(document.form1.PRO_NAME.value=="")
      { alert("产品名称不能为空！");
        return (false);
      }
      if(document.form1.PRO_ID.value=="")
      { alert("产品名称不能为空！");
        return (false);
      }
      if(document.form1.PRICE.value=="")
      { alert("单价不能为空！");
        return (false);
      }
       if';
  echo '(document.form1.TRANS_QTY.value=="")
      { alert("数量不能为空！");
        return (false);
      }
    }
     if (document.all("TYPE").value=="SER")
    {
    	if(document.form1.SER_NAME.value=="")
      { alert("服务名称不能为空！");
        return (false);
      }
      if(document.form1.SER_ID.value=="")
      { alert("服务名称不能为空！");
        return (false);
      }
';
  echo '      if(document.form1.TOTAL_PRICE.value=="")
      { alert("总价不能为空！");
        return (false);
      }
    }
  document.form1.submit();
}
function clear_dept1()
{
  document.form1.PRO_ID.value="";
	document.form1.PRO_NAME.value="";
	document.form1.PRICE.value="";
}
function clear_dept2()
{
  document.form1.SER_ID.value="";
	document.form1.SER_NAME.value="";
}
';
  echo '
function td_calendar(fieldname)
{
  myleft=document.body.scrollLeft+event.clientX-event.offsetX-80;
  mytop=document.body.scrollTop+event.clientY-event.offsetY+140;
  window.showModalDialog("/inc/calendar.php?FIELDNAME="+fieldname,self,"edge:raised;scroll:0;status:0;help:0;resizable:1;dialogWidth:280px;dialogHeight:215px;dialogTop:"+mytop+"px;dialogLeft:"+myleft+"px");
}
function sel_';
  echo 'change()
{
	  for(i=0;i<document.all("SERVICE_TYPE").length;i++)
     {
        el=document.all("SERVICE_TYPE").item(i);
        if(el.checked)
        {
        	 val=el.value;
        }
     }
     if(val=="0")
     {
      document.all("TYPE").value="PRO";
     	document.all("SER").style.display="none";
     	document.all("TOTALPRICE").style.display="none";
     	if(document.all("';
  echo '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").va';
  echo 'lue="";
     }
    else
     {
     	document.all("TYPE").value="SER";
      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";
      do';
  echo 'cument.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(LINE_ID,CONTRACT_ID)
{
 msg=\'确认删除合同明细吗？\';
 if(window.confirm(msg))
 {
  URL="delete.php?LINE_ID="+LINE_ID+"&CONTRACT_ID="+CONTRACT_ID+"&';
  echo 'CUSTOMER_ID=';
  echo $CUSTOMER_ID;
  echo '";
  window.location=URL;
 }
}
</script>
</head>
<body class="bodycolor" topmargin="5">
';
  if (($LINE_ID != ''))
  {
    $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
           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\'
           where a.LINE_ID=').$LINE_ID);
    $cursor = exequery ($connection, $query);
    if ($ROW = mysql_fetch_array ($cursor))
    {
      $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'];
      $MEMO = $ROW['MEMO'];
      $TYPE = $ROW['TYPE'];
    }
  }
  else
  {
    $TYPE = 'PRO';
  }
  echo '<br>
<table border="0" width="70%" cellpadding="2" cellspacing="1" align="center" bgcolor="#000000" class="small">
  <form enctype="multipart/form-data" action="add.php"  method="post" name="form1">
    <tr>
      <td class="TableData" colspan="2" align="left">
       &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<input type="radio" value="0" name=\'SERVICE_TYPE\' id=\'SERV';
  echo 'ICE_TYPE1\'  ';
  if (($LINE_ID == ''))
  {
    echo 'checked';
  }
  else
  {
    if (($TYPE == 'PRO'))
    {
      echo 'checked';
    }
  }
  echo '  onclick="sel_change()"><label for="SERVICE_TYPE1">产 品</label> &nbsp;
       <input type="radio" value="1" name=\'SERVICE_TYPE\' id=\'SERVICE_TYPE2\'  ';
  if ((($TYPE == 'SER') AND ($LINE_ID != '')))
  {
    echo 'checked';
  }
  echo '  onclick="sel_change()"><label for="SERVICE_TYPE2">服 务</label>
     </td>
    </tr>
    <tr id="PRO" style=';
  if (($LINE_ID == ''))
  {
    echo '';
  }
  else
  {
    if (($TYPE == 'PRO'))
    {
      echo '';
    }
    else
    {
      echo 'display:none';
    }
  }
  echo '>
      <td nowrap  class="TableData">产品：</td>
      <td class="TableData">
        <input type="hidden" name="PRO_ID" value="';
  echo $PRODUCT_ID;
  echo '">
        <input type="text" name="PRO_NAME" size="20" class="BigStatic" maxlength="20"  value="';
  echo $PRODUCT_NAME;
  echo '" readonly>
        &nbsp;<input type="button" value="选 择" class="SmallButton" onClick="LoadWindow1()" title="选择" name="button">
        &nbsp;<input type="button" value="清 空" class="SmallButton" onClick="clear_dept1()" title="清空" name="button">
      </td>
    </tr>
     <tr id="SER" style=';
  if (($LINE_ID == ''))
  {
    echo 'display:none';
  }
  else
  {
    if (($TYPE == 'SER'))
    {
      echo '';
    }
    else
    {
      echo 'display:none';
    }
  }
  echo '>
      <td nowrap  class="TableData">服务：</td>
      <td class="TableData">
        <input type="hidden" name="SER_ID" value="';
  echo $SERVICE_ID;
  echo '">
        <input type="text" name="SER_NAME" size="20" class="BigStatic" maxlength="20"  value="';
  echo $SERVICE_NAME;
  echo '" readonly>
        &nbsp;<input type="button" value="选 择" class="SmallButton" onClick="LoadWindow2()" title="选择" name="button">
        &nbsp;<input type="button" value="清 空" class="SmallButton" onClick="clear_dept2()" title="清空" name="button">
      </td>
    </tr>
   <tr id="PRI" style=';
  if (($LINE_ID == ''))
  {
    echo '';
  }
  else
  {
    if (($TYPE == 'PRO'))
    {
      echo '';
    }
    else
    {
      echo 'display:none';
    }
  }
  echo '>
      <td nowrap class="TableData">单价：</td>
      <td class="TableData">
';
  if (($TRANS_PRICE == ''))
  {
    echo '      	<input type="text" name="PRICE" size="20" maxlength="20" class="BigInput" value="0.0">
';
  }
  else
  {
    echo '        <input type="text" name="PRICE" size="20" maxlength="20" class="BigInput" value="';
    echo $TRANS_PRICE;
    echo '">
';
  }
  echo '      </td>
   </tr>
   <tr id="QTY" style=';
  if (($LINE_ID == ''))
  {
    echo '';
  }
  else
  {
    if (($TYPE == 'PRO'))
    {
      echo '';
    }
    else
    {
      echo 'display:none';
    }
  }
  echo '>
      <td nowrap class="TableData">数量：</td>
      <td class="TableData">
        <input type="text" name="TRANS_QTY" size="20" maxlength="20" class="BigInput" value="';
  echo $TRANS_QTY;
  echo '">
      </td>
   </tr>
   <tr id="TOTALPRICE" style=';
  if (($LINE_ID == ''))
  {
    echo 'display:none';
  }
  else
  {
    if (($TYPE == 'SER'))
    {
      echo '';
    }
    else
    {
      echo 'display:none';
    }
  }
  echo '>
      <td nowrap class="TableData">总价：</td>
      <td class="TableData">
        <input type="text" name="TOTAL_PRICE" size="20" maxlength="20" class="BigInput" value="';
  echo $TOTAL_PRICE;
  echo '">
      </td>
    </tr>
   <tr>
      <td nowrap class="TableData">备注：</td>
      <td class="TableData">
        <textarea name="MEMO" cols="45" rows="5" class="BigInput">';
  echo $MEMO;
  echo '</textarea>
      </td>
  </tr>
    <tr align="center" class="TableControl">
      <td colspan="2" nowrap>
        <input type="hidden" name="CONTRACT_ID" value="';
  echo $CONTRACT_ID;
  echo '">
        <input type="hidden" name="LINE_ID" value="';
  echo $LINE_ID;
  echo '">
        <input type="hidden" name="TYPE" value="';
  echo $TYPE;
  echo '">
        <input type="hidden" name="CUSTOMER_ID" value="';
  echo $CUSTOMER_ID;
  echo '">
        <input type="button" value="确认" class="BigButton" onclick="CheckForm();">&nbsp;&nbsp;
';
  if (($LINE_ID != ''))
  {
    echo '        <input type="button" value="取消" class="BigButton" onclick="location=\'index.php?CONTRACT_ID=';
    echo $CONTRACT_ID;
    echo '&CUSTOMER_ID=';
    echo $CUSTOMER_ID;
    echo '\'">
';
  }
  echo '      &nbsp;&nbsp;<input type="button" value="返回" class="BigButton" onclick="location=\'../../showdetail.php?CUSTOMER_ID=';
  echo $CUSTOMER_ID;
  echo '\'">
      </td>
    </tr>
  </table>
</form>
';
  $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,IF(a.TOTAL_PRICE-a.PAYMENT<0,0,a.TOTAL_PRICE-a.PAYMENT) as QIANKUAN,a.MEMO as MEMO,a.TYPE as TYPE 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\'
           where CONTRACT_ID=\'').$CONTRACT_ID).'\' ');
  $cursor = exequery ($connection, $query);
  $VOTE_COUNT = 0;
  $SUM_TRANS_QTY = 0;
  $SUM_TOTAL_PRICE = 0;
  $SUM_PAYMENT = 0;
  $SUM_QIANKUAN = 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'];
    $QIANKUAN = $ROW['QIANKUAN'];
    $MEMO = $ROW['MEMO'];
    $SUM_TRANS_QTY = ($SUM_TRANS_QTY + $TRANS_QTY);
    $SUM_TOTAL_PRICE = ($SUM_TOTAL_PRICE + $TOTAL_PRICE);
    $SUM_PAYMENT = ($SUM_PAYMENT + $PAYMENT);
    $SUM_QIANKUAN = ($SUM_QIANKUAN + $QIANKUAN);
    if (($VOTE_COUNT == 1))
    {
      echo '      <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">';
      echo '<s';
      echo 'pan 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>
';
      echo '        <td nowrap align="center">总价</td>
      <td nowrap align="center">已付款数</td>
       <td nowrap align="center">欠款数</td>
      <td nowrap align="center">操作</td>
    </tr>
';
    }
    if ((($VOTE_COUNT % 2) == 1))
    {
      $TableLine = 'TableLine1';
    }
    else
    {
      $TableLine = 'TableLine2';
    }
    echo '    <tr class="';
    echo $TableLine;
    echo '">
      <td nowrap align="center">';
    echo $PRODUCT_NAME;
    echo '</td>
      <td align="center">';
    echo $SERVICE_NAME;
    echo '</td>
      <td align="center">';
    echo $TRANS_PRICE;
    echo '</td>
      <td nowrap align="center">';
    echo $TRANS_QTY;
    echo '</td>
      <td nowrap align="center">';
    echo $TOTAL_PRICE;
    echo '</td>
      <td nowrap align="center">';
    echo $PAYMENT;
    echo '</td>
      <td nowrap align="center">';
    echo $QIANKUAN;
    echo '</td>
      <td nowrap align="center">&nbsp;
        <a href="index.php?LINE_ID=';
    echo $LINE_ID;
    echo '&CONTRACT_ID=';
    echo $CONTRACT_ID;
    echo '&CUSTOMER_ID=';
    echo $CUSTOMER_ID;
    echo '">修改</a>
         &nbsp;
        <a href="javascript:delete_vote(\'';
    echo $LINE_ID;
    echo '\',\'';
    echo $CONTRACT_ID;
    echo '\');">删除</a>
      </td>
    </tr>
';
  }
  if ((0 < $VOTE_COUNT))
  {
    echo ' <tr align="center" class="TableControl">
  <td colspan="3" nowrap>合计：</td>
  <td nowrap align="center">';
    echo $SUM_TRANS_QTY;
    echo '</td>
  <td nowrap align="center">';
    echo $SUM_TOTAL_PRICE;
    echo '</td>
  <td nowrap align="center">';
    echo $SUM_PAYMENT;
    echo '</td>
  <td nowrap align="center">';
    echo $SUM_QIANKUAN;
    echo '</td>
  <td nowrap align="center"></td>
 </tr>
</table>
';
  }
  echo '
</body>
</html>';
?>

index.php - 源码说明

本页面展示了「通达OA2007SE源代码 非常好的」中的 index.php 源码文件，采用 PHP 编程语言编写，共 521 行代码。您可以在线阅读完整代码内容，也可以返回资源详情页下载完整源码包进行本地学习和开发。

虫虫下载站收录了大量与2007相关的技术资源，包括源代码、技术文档、电路图等，是电子工程师和嵌入式开发者的专业学习平台。

⌨️ 快捷键说明

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