📄 item.php

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

<html>
<head>
<title>查看明细</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">

<script Language="JavaScript">
function CheckForm()
{
   if(document.form1.TO_NAME.value=="")
   { alert("销售员不能为空！");
     return (false);
   }
   if(document.form1.SALE.value=="")
   { alert("销售额不能为空！");
     return (false);
   }
   if(document.form1.ACCOUNT.value=="")
   { alert("利润不能为空！");
     return (false);
   }
}

function delete_item(ITEM_ID)
{
 msg='确认要删除该项明细么？';
 if(window.confirm(msg))
 {
  ITEM="delete.php?PLAN_ID=<?=$PLAN_ID?>&ITEM_ID=" + ITEM_ID;
  window.location=ITEM;
 }
}


function delete_all()
{
 msg='确认要删除所有明细么？';
 if(window.confirm(msg))
 {
  ITEM="delete_all.php?PLAN_ID=<?=$PLAN_ID?>";
  window.location=ITEM;
 }
}

function LoadWindow()
{
  URL="/module/user_select_single";
  loc_x=document.body.scrollLeft+event.clientX-event.offsetX-100;
  loc_y=document.body.scrollTop+event.clientY-event.offsetY+200;
  window.showModalDialog(URL,self,"edge:raised;scroll:0;status:0;help:0;resizable:1;dialogWidth:350px;dialogHeight:350px;dialogTop:"+loc_y+"px;dialogLeft:"+loc_x+"px");
}
</script>
</head>

<body class="bodycolor" topmargin="5" onload="document.form1.TO_NAME.focus();">

<table border="0" cellspacing="1" width="450" class="small" bgcolor="#000000" cellpadding="3" align="center" >

<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
  <tr>
    <td class="Big"><img src="/images/notify_open.gif" align="absmiddle"><span class="big3"> 查看明细</span>
    </td>
  </tr>
</table>

<br>
<div align="center">

<?
 $query = "SELECT SALE_PLAN_ITEM.*,USER_NAME SELLER_NAME from SALE_PLAN_ITEM left join USER on SELLER=USER_ID where PLAN_ID='$PLAN_ID' order by ITEM_ID";
 $connection=OpenConnection();
 $cursor= exequery($connection,$query);

 $ITEM_COUNT=0;
 while($ROW=mysql_fetch_array($cursor))
 {
    $ITEM_COUNT++;
    $ITEM_ID=$ROW["ITEM_ID"];
    $SELLER_NAME=$ROW["SELLER_NAME"];
    $SALE=$ROW["SALE"];
    $ACCOUNT=$ROW["ACCOUNT"];

    if($ITEM_COUNT==1)
    {
?>

    <table border="0" cellspacing="1" width="450" class="small" bgcolor="#000000" cellpadding="3">

<?
    }
?>
    <tr class="TableData">
      <td nowrap align="center"><?=$SELLER_NAME?></td>
      <td nowrap align="center"><?=$SALE?></td>
      <td nowrap align="center"><?=$ACCOUNT?></td>
    </tr>
<?
 }

 if($ITEM_COUNT>0)
 {
?>
    <thead class="TableHeader">
      <td nowrap align="center">销售员</td>
      <td nowrap align="center">销售额</td>
      <td nowrap align="center">利润</td>
    </thead>
    </table>
<?
 }
 else
    Message("","尚未添加明细");
?>

</div>
<br>
<div align=center>
       <input type="button" value="关闭" class="BigButton" onClick="javascript:window.close();">
</div>

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

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