📄 index.php

📁 极限网络智能办公系统 - Office Automation 2008 官方100％源码
💻 PHP
字号:
<?
include_once("inc/auth.php");
include_once("inc/utility_all.php");
?>

<html>
<head>
<title>产品BOM修改</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">

<script Language="JavaScript">
function LoadWindow1()
{
  URL="product_select/?PRODUCT_PARENT=<?=$PRODUCT_PARENT?>";
  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 LoadWindow2()
{
  URL="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()
{

    	if(document.form1.PRO_NAME.value=="")
      { alert("产品名称不能为空！");
        return (false);
      }
      if(document.form1.PRO_ID.value=="")
      { alert("产品名称不能为空！");
        return (false);
      }
       if(document.form1.AMT.value=="")
      { alert("数量不能为空！");
        return (false);
      }
  document.form1.submit();
}


function delete_vote(PRODUCT_PARENT,BOM_ID)
{
 msg='确认删除产品BOM修改吗？';
 if(window.confirm(msg))
 {
  URL="delete.php?PRODUCT_PARENT="+PRODUCT_PARENT+"&BOM_ID="+BOM_ID+"&PRODUCT_NAME=<?=$PRODUCT_NAME?>&PRODUCT_TYPE=<?=$PRODUCT_TYPE?>&PRODUCT_DESC=<?=$PRODUCT_DESC?>&PRODUCT_MODE=<?=$PRODUCT_MODE?>&PROVIDER_NAME=<?=$PROVIDER_NAME?>&CUR_PAGE=<?=$CUR_PAGE?>&ORDERFIELD=<?=$ORDERFIELD?>&ORDERTYPE=<?=$ORDERTYPE?>";
  window.location=URL;
 }
}
</script>
</head>

<body class="bodycolor" topmargin="5">
<?
if($BOM_ID!="")
{
 $query = "SELECT BOM_ID,PRODUCT_BOM.*,PRODUCT_NAME,AMT FROM PRODUCT_BOM,PRODUCT WHERE PRODUCT.PRODUCT_ID=PRODUCT_BOM.PRODUCT_ID AND BOM_ID=$BOM_ID";
 $cursor= exequery($connection,$query);
 if($ROW=mysql_fetch_array($cursor))
 {
    $BOM_ID1=$ROW["BOM_ID"];
    $PRODUCT_ID1=$ROW["PRODUCT_ID"];
    $PRODUCT_NAME1=$ROW["PRODUCT_NAME"];
    $AMT1=$ROW["AMT"];
  }
 }
?>
<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 nowrap  class="TableData">产品：</td>
      <td class="TableData">
        <input type="hidden" name="PRO_ID" value="<?=$PRODUCT_ID1?>">
        <input type="hidden" name="PRICE" value="">
        <input type="text" name="PRO_NAME" size="20" class="BigStatic" maxlength="20"  value="<?=$PRODUCT_NAME1?>" 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>
      <td nowrap class="TableData">数量：</td>
      <td class="TableData">
        <input type="text" name="AMT" size="20" maxlength="20" class="BigInput" value="<?=$AMT1?>">
      </td>
   </tr>
    <tr align="center" class="TableControl">
  <td colspan="2" nowrap>
        <input type="hidden" name="BOM_ID" value="<?=$BOM_ID1?>">
        <input type="hidden" name="PRODUCT_PARENT" value="<?=$PRODUCT_PARENT?>">
        <input type="hidden" value="PRODUCT_NAME=<?=$PRODUCT_NAME?>&PRODUCT_TYPE=<?=$PRODUCT_TYPE?>&PRODUCT_DESC=<?=$PRODUCT_DESC?>&PRODUCT_MODE=<?=$PRODUCT_MODE?>&PROVIDER_NAME=<?=$PROVIDER_NAME?>&CUR_PAGE=<?=$CUR_PAGE?>&ORDERFIELD=<?=$ORDERFIELD?>&ORDERTYPE=<?=$ORDERTYPE?>" name="QUERY_LIST">
        <input type="button" value="确认" class="BigButton" onclick="CheckForm();">&nbsp;&nbsp;
<?
    if($BOM_ID!="")
    {
?>
        <input type="button" value="取消" class="BigButton" onclick="location='index.php?BOM_ID=<?=$BOM_ID?>&PRODUCT_NAME=<?=$PRODUCT_NAME?>&PRODUCT_TYPE=<?=$PRODUCT_TYPE?>&PRODUCT_DESC=<?=$PRODUCT_DESC?>&PRODUCT_MODE=<?=$PRODUCT_MODE?>&PROVIDER_NAME=<?=$PROVIDER_NAME?>&CUR_PAGE=<?=$CUR_PAGE?>&ORDERFIELD=<?=$ORDERFIELD?>&ORDERTYPE=<?=$ORDERTYPE?>'">
<?
      }

?>
      &nbsp;&nbsp;<input type="button" value="返回" class="BigButton" onclick="location='../index1.php?PRODUCT_NAME=<?=$PRODUCT_NAME?>&PRODUCT_TYPE=<?=$PRODUCT_TYPE?>&PRODUCT_DESC=<?=$PRODUCT_DESC?>&PRODUCT_MODE=<?=$PRODUCT_MODE?>&PROVIDER_NAME=<?=$PROVIDER_NAME?>&CUR_PAGE=<?=$CUR_PAGE?>&ORDERFIELD=<?=$ORDERFIELD?>&ORDERTYPE=<?=$ORDERTYPE?>'">
      </td>

   </tr>
  </table>
</form>
<?
 //============================显示产品BOM修改=======================================
 $query = "SELECT BOM_ID,PRODUCT_BOM.PRODUCT_ID,PRODUCT_NAME,AMT FROM PRODUCT,PRODUCT_BOM where PRODUCT_BOM.PRODUCT_ID=PRODUCT.PRODUCT_ID AND PRODUCT_PARENT='$PRODUCT_PARENT' ";
 $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++;
    $BOM_ID1=$ROW["BOM_ID"];
    $PRODUCT_ID1=$ROW["PRODUCT_ID"];
    $PRODUCT_NAME1=$ROW["PRODUCT_NAME"];
    $AMT1=$ROW["AMT"];
    $SUM_AMT=$SUM_AMT+$AMT1;
    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;产品BOM修改</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>
    </tr>

<?
    }

    if($VOTE_COUNT%2==1)
       $TableLine="TableLine1";
    else
       $TableLine="TableLine2";
?>
    <tr class="<?=$TableLine?>">
      <td nowrap align="center"><?=$PRODUCT_NAME1?></td>
      <td nowrap align="center"><?=$AMT1?></td>
      <td nowrap align="center">&nbsp;
    <a href="index.php?PRODUCT_PARENT=<?=$PRODUCT_PARENT?>&BOM_ID=<?=$BOM_ID1?>&PRODUCT_NAME=<?=$PRODUCT_NAME?>&PRODUCT_TYPE=<?=$PRODUCT_TYPE?>&PRODUCT_DESC=<?=$PRODUCT_DESC?>&PRODUCT_MODE=<?=$PRODUCT_MODE?>&PROVIDER_NAME=<?=$PROVIDER_NAME?>&CUR_PAGE=<?=$CUR_PAGE?>&ORDERFIELD=<?=$ORDERFIELD?>&ORDERTYPE=<?=$ORDERTYPE?>">修改</a>
      &nbsp;
    <a href="javascript:delete_vote('<?=$PRODUCT_PARENT?>','<?=$BOM_ID1?>');">删除</a>
      </td>
    </tr>
<?
 }

 if($VOTE_COUNT>0)
 {
?>
 <tr align="center" class="TableControl">
  <td  nowrap>合计：</td>
  <td nowrap align="center"><?=$SUM_AMT?></td>
  <td nowrap align="center"></td>
 </tr>
</table>
<?
 }
?>

</body>
</html>
⌨️ 快捷键说明

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