📄 index.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.form1.PLAN_NO.value=="")
{ alert("生产计划的编号不能为空！");
return (false);
}
document.form1.submit();
}
function clear_dept()
{
document.form1.TO_NAME.value="";
document.form1.TO_ID.value="";
}
function LoadWindow()
{
URL="/module/dept_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:1;status:0;help:0;resizable:1;dialogWidth:400px;dialogHeight:330px;dialogTop:"+loc_y+"px;dialogLeft:"+loc_x+"px");
}
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");
}
</script>
</head>
<body class="bodycolor" topmargin="5" onload="javascript:form1.PLAN_NO.focus();">
<?
if($TASK_ID!="")
{
$query = "SELECT * from MANU_TASK where TASK_ID=$TASK_ID";
$cursor= exequery($connection,$query);
if($ROW=mysql_fetch_array($cursor))
{
$TASK_NO=$ROW["TASK_NO"];
$TASK_DATE=$ROW["TASK_DATE"];
$TASK_DEPT=$ROW["TASK_DEPT"];
$TASK_DESC=$ROW["TASK_DESC"];
$TASK_TYPE=$ROW["TASK_TYPE"];
if($TASK_DATE=="0000-00-00")
$TASK_DATE="";
}
}
?>
<table border="0" width="90%" cellspacing="0" cellpadding="3" class="small">
<tr>
<td class="Big"><img src="/images/notify_new.gif" align="absmiddle"><span class="big3"> 生成生产计划</span>
</td>
</tr>
</table>
<table border="0" width="70%" cellpadding="2" cellspacing="1" align="center" bgcolor="#000000" class="small">
<tr class="TableHeader">
<td colspan="2">基本信息</td>
</tr>
<form enctype="multipart/form-data" action="add.php" method="post" name="form1">
<tr>
<td nowrap class="TableData"> 计划单编号：</td>
<td class="TableData">
<input type="text" name="PLAN_NO" size="20" maxlength="20" class="BigInput" value="<?=$PLAN_NO?>">
</td>
</tr>
<tr>
<td nowrap class="TableData">计划类型：</td>
<td class="TableData">
<select name="PLAN_TYPE" class="BigSelect">
<option value=""></option>
<?=code_list("MANU_PLAN_TYPE",$PLAN_TYPE)?>
</select>
</td>
</tr>
<tr>
<td nowrap class="TableData">计划日期：</td>
<td class="TableData">
<input type="text" name="PLAN_DATE" size="10" maxlength="10" class="BigInput" value="<?=$PLAN_DATE?>">
<img src="/images/menu/calendar.gif" border="0" style="cursor:hand" onclick="td_calendar('form1.PLAN_DATE');">
</td>
</tr>
<tr>
<td nowrap class="TableData">生产部门：</td>
<td class="TableData">
<select name="PLAN_DEPT" class="BigSelect">
<?
echo my_dept_tree(0,$PLAN_DEPT,0);
?>
</select>
</td>
</tr>
<tr>
<td nowrap class="TableData">备注：</td>
<td class="TableData">
<textarea name="PLAN_DESC" class="BigInput" cols="50" rows="3"><?=$PLAN_DESC?></textarea>
</td>
</tr>
<tr class="TableHeader">
<td colspan="2">生产计划明细</td>
</tr>
<tr>
<td nowrap class="TableData" colspan="2">
<?
//============================显示合同明细=======================================
$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.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
,PRODUCT b
where a.PRODUCT_ID = b.PRODUCT_ID AND a.TYPE='PRO' and 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 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"><?=$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">
<input type="text" name="PLAN_COUNT[]" size="10" maxlength="20" class="BigInput" value=""><input type="hidden" name="PRODUCT_ID[]" value="<?=$PRODUCT_ID?>"> </td>
</tr>
<?
}
if($VOTE_COUNT>0)
{
?>
<tr align="center" class="TableControl">
<td colspan="2" 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>
<?
}
?>
</td>
</tr>
<tr align="center" class="TableControl">
<td colspan="2" nowrap>
<input type="button" value="保存" class="BigButton" onclick="CheckForm();">
<input type="reset" value="重填" class="BigButton">
<input type="button" value="返回" class="BigButton" onclick="location='../'">
</td>
</tr>
</table>
</form>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -