⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 index.php

📁 极限网络智能办公系统 Office Automation V3.0官方100％源代码.
💻 PHP
📖 第 1 页 / 共 2 页
字号:
🔍
12 
        &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";} ?>>

      <td nowrap class="TableData">单价：</td>
      <td class="TableData">
<?
      	if ($TRANS_PRICE=="")
      	{
?>
      	<input type="text" name="PRICE" size="20" maxlength="20" class="BigInput" value="0.0">
<?
        }
       else
       {

?>
        <input type="text" name="PRICE" size="20" maxlength="20" class="BigInput" value="<?=$TRANS_PRICE?>">

<?
      }
?>
      </td>
   </tr>
   <tr id="QTY" style=<? if($LINE_ID==""){ echo "";}
     	                     else{ if($TYPE=="PRO") echo ""; else echo "display:none";} ?>>
      <td nowrap class="TableData">数量：</td>
      <td class="TableData">
        <input type="text" name="TRANS_QTY" size="20" maxlength="20" class="BigInput" value="<?=$TRANS_QTY?>">
      </td>
   </tr>
   <tr id="TOTALPRICE" style=<? if($LINE_ID==""){ echo "display:none";}
     	                     else{ if($TYPE=="SER") echo ""; else echo "display:none";} ?>>
      <td nowrap class="TableData">总价：</td>
      <td class="TableData">
        <input type="text" name="TOTAL_PRICE" size="20" maxlength="20" class="BigInput" value="<?=$TOTAL_PRICE?>">
      </td>
    </tr>

   <tr>
      <td nowrap class="TableData">备注：</td>
      <td class="TableData">
        <textarea name="MEMO" cols="45" rows="5" class="BigInput"><?=$MEMO?></textarea>
      </td>
  </tr>
    <tr align="center" class="TableControl">
<?
 if($querstr!="")
  {
  	    $urlstr1=str_replace("%","&",$querstr);
?>
      <td colspan="2" nowrap>
        <input type="hidden" name="CONTRACT_ID" value="<?=$CONTRACT_ID?>">
        <input type="hidden" name="LINE_ID" value="<?=$LINE_ID?>">
        <input type="hidden" name="TYPE" value="<?=$TYPE?>">
        <input type="hidden" name="querstr" value="<?=$querstr?>">
        <input type="hidden" value="ORDERFIELD=<?=$ORDERFIELD?>&ORDERTYPE=<?=$ORDERTYPE?>&CUR_PAGE=<?=$CUR_PAGE?>" name="QUERY_LIST">
        <input type="hidden" value="ad_query" name="FLAGSOURCE">
        <input type="button" value="确认" class="BigButton" onclick="CheckForm();">&nbsp;&nbsp;
<?
    if($LINE_ID!="")
      {
?>
        <input type="button" value="取消" class="BigButton" onclick="location='index.php?CONTRACT_ID=<?=$CONTRACT_ID?>&querstr=<?=$querstr?>&CUR_PAGE=<?=$CUR_PAGE?>&ORDERFIELD=<?=$ORDERFIELD?>&ORDERTYPE=<?=$ORDERTYPE?>'">
<?
      }

?>
      &nbsp;&nbsp;<input type="button" value="返回" class="BigButton" onclick="location='../ad_query/list.php?<?=$urlstr1?>&ORDERFIELD=<?=$ORDERFIELD?>&ORDERTYPE=<?=$ORDERTYPE?>&CUR_PAGE=<?=$CUR_PAGE?>'">
      </td>
<?
  }
  else
 {
?>
  <td colspan="2" nowrap>
        <input type="hidden" name="CONTRACT_ID" value="<?=$CONTRACT_ID?>">
        <input type="hidden" name="LINE_ID" value="<?=$LINE_ID?>">
        <input type="hidden" name="TYPE" value="<?=$TYPE?>">
        <input type="hidden" value="CUSTOMER_NAME=<?=$CUSTOMER_NAME?>&KIND=<?=$KIND?>&SELLMODE=<?=$SELLMODE?>&CONTRACT_TYPE=<?=$CONTRACT_TYPE?>&CONTRACT_NO=<?=$CONTRACT_NO?>&CONTRACT_NAME=<?=$CONTRACT_NAME?>&DATE_TYPE=<?=$DATE_TYPE?>&CONTRACT_LINKMAN1=<?=$CONTRACT_LINKMAN1?>&DATE1=<?=$DATE1?>&DATE2=<?=$DATE2?>&CONTRACT_LINKMAN2=<?=$CONTRACT_LINKMAN2?>&SIGN=<?=$SIGN?>&CUR_PAGE=<?=$CUR_PAGE?>&ORDERFIELD=<?=$ORDERFIELD?>&ORDERTYPE=<?=$ORDERTYPE?>" name="QUERY_LIST">
        <input type="button" value="确认" class="BigButton" onclick="CheckForm();">&nbsp;&nbsp;
<?
    if($LINE_ID!="")
    {
?>
        <input type="button" value="取消" class="BigButton" onclick="location='index.php?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?>&SIGN=<?=$SIGN?>&CONTRACT_LINKMAN2=<?=$CONTRACT_LINKMAN2?>&DATE1=<?=$DATE1?>&DATE2=<?=$DATE2?>&CUR_PAGE=<?=$CUR_PAGE?>&ORDERFIELD=<?=$ORDERFIELD?>&ORDERTYPE=<?=$ORDERTYPE?>'">
<?
      }

?>
      &nbsp;&nbsp;<input type="button" value="返回" class="BigButton" onclick="location='../?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?>'">
      </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)
    {
?>
      <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>
      <td nowrap align="center">操作</td>
    </tr>

<?
    }

    if($VOTE_COUNT%2==1)
       $TableLine="TableLine1";
    else
       $TableLine="TableLine2";
?>
    <tr class="<?=$TableLine?>">
      <td nowrap align="center"><?=$PRODUCT_NAME?></td>
      <td align="center"><?=$SERVICE_NAME?></td>
      <td align="center"><?=$TRANS_PRICE?></td>
      <td nowrap align="center"><?=$TRANS_QTY?></td>
      <td nowrap align="center"><?=$TOTAL_PRICE?></td>
      <td nowrap align="center"><?=$PAYMENT?></td>
      <td nowrap align="center"><?=$QIANKUAN?></td>
      <td nowrap align="center">&nbsp;
<?
 if($querstr!="")
  {
  	    $urlstr1=str_replace("%","&",$querstr);
?>
      <a href="index.php?LINE_ID=<?=$LINE_ID?>&CONTRACT_ID=<?=$CONTRACT_ID?>&querstr=<?=$querstr?>&CUR_PAGE=<?=$CUR_PAGE?>&ORDERFIELD=<?=$ORDERFIELD?>&ORDERTYPE=<?=$ORDERTYPE?>">修改</a>
      &nbsp;
      <a href="javascript:delete_vote1('<?=$LINE_ID?>','<?=$CONTRACT_ID?>');">删除</a>
<?
  }
  else
 {
?>
    <a href="index.php?LINE_ID=<?=$LINE_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?>&SIGN=<?=$SIGN?>&CONTRACT_LINKMAN2=<?=$CONTRACT_LINKMAN2?>&DATE1=<?=$DATE1?>&DATE2=<?=$DATE2?>&CUR_PAGE=<?=$CUR_PAGE?>&ORDERFIELD=<?=$ORDERFIELD?>&ORDERTYPE=<?=$ORDERTYPE?>">修改</a>
      &nbsp;
    <a href="javascript:delete_vote('<?=$LINE_ID?>','<?=$CONTRACT_ID?>');">删除</a>
<?
  }
?>

      </td>
    </tr>
<?
 }

 if($VOTE_COUNT>0)
 {
?>
 <tr align="center" class="TableControl">
  <td colspan="3" nowrap>合计：</td>
  <td nowrap align="center"><?=$SUM_TRANS_QTY?></td>
  <td nowrap align="center"><?=$SUM_TOTAL_PRICE?></td>
  <td nowrap align="center"><?=$SUM_PAYMENT?></td>
  <td nowrap align="center"><?=$SUM_QIANKUAN?></td>
  <td nowrap align="center"></td>
 </tr>
</table>
<?
 }
?>

</body>
</html>
12

⌨️ 快捷键说明

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