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

📄 index.php

📁 极限网络智能办公系统 - Office Automation 2008 官方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 CheckForm()
{
	 if(document.all("LINE_ID").value=="" )
    {
    	  alert("请选择订单明细！！");
        return (false);
    }
    if(document.all("TRANS_QTY").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,TRANS_PRICE,PROVIDER_ID)
{

    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("PROVIDER_ID").value=PROVIDER_ID;
    document.all("OP").value="ADD";
}

function select_value1(LINE_ID,PRODUCT_ID,PRODUCT_NAME,TRANS_PRICE,TRANS_QTY,HISTORY_ID)
{
      document.all("HISTORY_ID").value=HISTORY_ID;
      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";
}

function delete_vote(HISTORY_ID,ORDER_ID)
{
 msg='确认删除该接货记录吗？';
 if(window.confirm(msg))
 {
  URL="delete.php?HISTORY_ID="+HISTORY_ID+"&ORDER_ID="+ORDER_ID+"&PROVIDER_NAME=<?=$PROVIDER_NAME?>&PROVIDER_CODE=<?=$PROVIDER_CODE?>&PROVIDER_SHORT=<?=$PROVIDER_SHORT?>&PROVIDER_AREA=<?=$PROVIDER_AREA?>&ORDER_TYPE=<?=$ORDER_TYPE?>&ORDER_NO=<?=$ORDER_NO?>&ORDER_NAME=<?=$ORDER_NAME?>&RECIVER=<?=$RECIVER?>&DATE1=<?=$DATE1?>&DATE2=<?=$DATE2?>&CREATOR=<?=$CREATOR?>&DATE_TYPE=<?=$DATE_TYPE?>&CUR_PAGE=<?=$CUR_PAGE?>&ORDERFIELD=<?=$ORDERFIELD?>&ORDERTYPE=<?=$ORDERTYPE?>";
  window.location=URL;
 }
}
function delete_vote1(HISTORY_ID,ORDER_ID)
{
 msg='确认删除该接货记录吗？';
 if(window.confirm(msg))
 {
  URL="delete.php?HISTORY_ID="+HISTORY_ID+"&ORDER_ID="+ORDER_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,
                   a.TRANS_PRICE as TRANS_PRICE,
                   a.TRANS_QTY as TRANS_QTY,a.PAYMENT as PAYMENT,a.MEMO as MEMO,c.PROVIDER_ID as PROVIDER_ID,
                   b.PRODUCT_CODE as PRODUCT_CODE,a.TRANS_PRICE*a.TRANS_QTY as TOTALPRICE,b.PRODUCT_TYPE as PRODUCT_TYPE
                   from ORDER_LINE a
                   LEFT OUTER JOIN PRODUCT b ON a.PRODUCT_ID = b.PRODUCT_ID
                   LEFT OUTER JOIN SUPPLY_ORDER c ON a.ORDER_ID = c.ORDER_ID
                   where a.ORDER_ID='$ORDER_ID' ";
 $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"];
    $TRANS_PRICE=$ROW["TRANS_PRICE"];
    $TRANS_QTY=$ROW["TRANS_QTY"];
    $PAYMENT=$ROW["PAYMENT"];
    $MEMO=$ROW["MEMO"];
    $PRODUCT_CODE=$ROW["PRODUCT_CODE"];
    $PRODUCT_TYPE=$ROW["PRODUCT_TYPE"];
    $PROVIDER_ID=$ROW["PROVIDER_ID"];
    $TOTAL_PRICE=$ROW["TOTALPRICE"];
    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>
    </tr>

<?
    }

    if($VOTE_COUNT%2==1)
       $TableLine="TableLine1";
    else
       $TableLine="TableLine2";
?>
    <tr class="<?=$TableLine?>">
       <td nowrap align="center"><?=$PRODUCT_NAME?></td>
        <td align="center"><?=$PRODUCT_CODE?></td>
       <td align="center"><?=$PRODUCT_TYPE?></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">&nbsp;
       <a href="javascript:select_value('<?=$LINE_ID?>','<?=$PRODUCT_ID?>','<?=$PRODUCT_NAME?>','<?=$TRANS_PRICE?>','<?=$PROVIDER_ID?>');"> 选择</a>
      </td>
    </tr>
<?
 }
?>
</table>
<br>
<table border="0" width="50%" cellpadding="2" cellspacing="1" align="center" bgcolor="#000000" class="small">
  <form enctype="multipart/form-data" action="add.php"  method="post" name="form1">
    <tr>
      <td nowrap  class="TableData">产品名称：</td>
      <td class="TableData">
        <input type="hidden" name="PRO_ID">
        <input type="text" name="PRO_NAME" size="20" class="BigStatic" maxlength="20" readonly>
      </td>
    </tr>
   <tr>
      <td nowrap class="TableData">单价：</td>
      <td class="TableData">
      	<input type="text" name="PRICE" size="20" maxlength="20" class="BigStatic" class="BigInput" readonly>
      </td>
   </tr>
   <tr>
      <td nowrap class="TableData">本次交付数量：</td>
      <td class="TableData">
        <input type="text" name="TRANS_QTY" size="20" maxlength="20" class="BigInput">
      </td>
   </tr>
    <tr align="center" class="TableControl">
      <td colspan="2" nowrap>
<?
  if($querstr!="")
   {
  	 $urlstr1=str_replace("%","&",$querstr);
?>
        <input type="hidden" name="ORDER_ID" value="<?=$ORDER_ID?>">
        <input type="hidden" name="LINE_ID">
        <input type="hidden" name="PROVIDER_ID" value="<?=$PROVIDER_ID?>">
        <input type="hidden" name="OP">
        <input type="hidden" name="HISTORY_ID">
        <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?ORDER_ID=<?=$ORDER_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?>'">
<?
  }
  else
 {
?>
        <input type="hidden" name="ORDER_ID" value="<?=$ORDER_ID?>">
        <input type="hidden" name="LINE_ID">
        <input type="hidden" name="PROVIDER_ID" value="<?=$PROVIDER_ID?>">
        <input type="hidden" name="OP">
        <input type="hidden" name="HISTORY_ID">
        <input type="hidden" value="ORDER_ID=<?=$ORDER_ID?>&PROVIDER_NAME=<?=$PROVIDER_NAME?>&PROVIDER_CODE=<?=$PROVIDER_CODE?>&PROVIDER_SHORT=<?=$PROVIDER_SHORT?>&PROVIDER_AREA=<?=$PROVIDER_AREA?>&ORDER_TYPE=<?=$ORDER_TYPE?>&ORDER_NO=<?=$ORDER_NO?>&ORDER_NAME=<?=$ORDER_NAME?>&RECIVER=<?=$RECIVER?>&DATE1=<?=$DATE1?>&DATE2=<?=$DATE2?>&CREATOR=<?=$CREATOR?>&DATE_TYPE=<?=$DATE_TYPE?>&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?ORDER_ID=<?=$ORDER_ID?>&PROVIDER_NAME=<?=$PROVIDER_NAME?>&PROVIDER_CODE=<?=$PROVIDER_CODE?>&PROVIDER_SHORT=<?=$PROVIDER_SHORT?>&PROVIDER_AREA=<?=$PROVIDER_AREA?>&ORDER_TYPE=<?=$ORDER_TYPE?>&ORDER_NO=<?=$ORDER_NO?>&ORDER_NAME=<?=$ORDER_NAME?>&RECIVER=<?=$RECIVER?>&DATE1=<?=$DATE1?>&DATE2=<?=$DATE2?>&CREATOR=<?=$CREATOR?>&DATE_TYPE=<?=$DATE_TYPE?>&CUR_PAGE=<?=$CUR_PAGE?>&ORDERFIELD=<?=$ORDERFIELD?>&ORDERTYPE=<?=$ORDERTYPE?>'">
<?
    }

?>
      &nbsp;&nbsp;<input type="button" value="返回" class="BigButton" onclick="location='../?PROVIDER_NAME=<?=$PROVIDER_NAME?>&PROVIDER_CODE=<?=$PROVIDER_CODE?>&PROVIDER_SHORT=<?=$PROVIDER_SHORT?>&PROVIDER_AREA=<?=$PROVIDER_AREA?>&ORDER_TYPE=<?=$ORDER_TYPE?>&ORDER_NO=<?=$ORDER_NO?>&ORDER_NAME=<?=$ORDER_NAME?>&RECIVER=<?=$RECIVER?>&DATE1=<?=$DATE1?>&DATE2=<?=$DATE2?>&CREATOR=<?=$CREATOR?>&DATE_TYPE=<?=$DATE_TYPE?>&CUR_PAGE=<?=$CUR_PAGE?>&ORDERFIELD=<?=$ORDERFIELD?>&ORDERTYPE=<?=$ORDERTYPE?>'">
<?
  }
?>

      </td>
    </tr>
  </table>
</form>
<?
 //============================显示接货记录=======================================
 $query = "SELECT  a.LINE_ID as LINE_ID,a.PRODUCT_ID as PRODUCT_ID,b.PRODUCT_NAME as PRODUCT_NAME,
                   a.PRICE as TRANS_PRICE, b.PRODUCT_CODE as PRODUCT_CODE,
                   a.AMT as TRANS_QTY, (a.PRICE*a.AMT) as TOTAL_PRICE,a.DATE as TRANS_DATE,f.USER_NAME as SELLER,g.PROVIDER_NAME as PROVIDER_NAME,a.HISTORY_ID as HISTORY_ID,b.PRODUCT_TYPE as PRODUCT_TYPE
                   from SUPPLY_HISTORY  a
                   LEFT OUTER JOIN PRODUCT b ON a.PRODUCT_ID = b.PRODUCT_ID
                   LEFT OUTER JOIN ORDER_LINE d ON a.LINE_ID = d.LINE_ID
                   LEFT OUTER JOIN SUPPLY_ORDER e ON d.ORDER_ID = e.ORDER_ID
                   LEFT OUTER JOIN USER f ON a.SALESMAN=f.USER_ID
                   LEFT OUTER JOIN PROVIDER g ON a.PROVIDER_ID=g.PROVIDER_ID
                   where a.ORDER_ID='$ORDER_ID' order by HISTORY_ID 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"];
    $TRANS_PRICE=$ROW["TRANS_PRICE"];
    $TRANS_QTY=$ROW["TRANS_QTY"];
    $TOTAL_PRICE =$ROW["TOTAL_PRICE"];
    $TRANS_DATE =$ROW["TRANS_DATE"];
    $PRODUCT_TYPE=$ROW["PRODUCT_TYPE"];
     $PRODUCT_CODE=$ROW["PRODUCT_CODE"];
    $SELLER =$ROW["SELLER"];
    $PROVIDER_NAME =$ROW["PROVIDER_NAME"];
    $MEMO=$ROW["MEMO"];
    $HISTORY_ID=$ROW["HISTORY_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>
      <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"><?=$PRODUCT_CODE?></td>
       <td align="center"><?=$PRODUCT_TYPE?></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"><?=$TRANS_DATE?></td>
       <td nowrap align="center"><?=$PROVIDER_NAME?></td>
       <td nowrap align="center"><?=$SELLER?></td>
      <td nowrap align="center">&nbsp;
<?
 if($querstr!="")
  {
  	    $urlstr1=str_replace("%","&",$querstr);
?>
        <a href="javascript:select_value1('<?=$LINE_ID?>','<?=$PRODUCT_ID?>','<?=$PRODUCT_NAME?>','<?=$TRANS_PRICE?>','<?=$TRANS_QTY?>','<?=$HISTORY_ID?>');">修改</a>
         &nbsp;
        <a href="javascript:delete_vote1('<?=$HISTORY_ID?>','<?=$ORDER_ID?>');">删除</a>
<?
  }
  else
 {
?>
        <a href="javascript:select_value1('<?=$LINE_ID?>','<?=$PRODUCT_ID?>','<?=$PRODUCT_NAME?>','<?=$TRANS_PRICE?>','<?=$TRANS_QTY?>','<?=$HISTORY_ID?>');">修改</a>
         &nbsp;
        <a href="javascript:delete_vote('<?=$HISTORY_ID?>','<?=$ORDER_ID?>');">删除</a>
<?
  }
?>

      </td>
    </tr>
<?
 }

 if($VOTE_COUNT>0)
 {
?>
</table>
<?
 }
?>

</body>
</html>

⌨️ 快捷键说明

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