📄 index.php
字号:
<select name="ORDER_TYPE" class="BigSelect">
<?
GETALLDATE("ORDER_TYPE",$ORDER_TYPE1);
?>
</select>
<a href="javascript:LoadWindow1('ORDER_TYPE','ORDER_TYPE');"><img src="/images/edit1.gif" align="absmiddle" border=0 title="订单类型定义"></a>
</td>
</tr>
<tr>
<td nowrap class="TableData">订单名称： </td>
<td nowrap class="TableData" colspan="3">
<input type="text" name="ORDER_NAME" class="BigInput" size="51" maxlength="100" value="<?=$ORDER_NAME1?>">
</td>
</tr>
<tr>
<td nowrap class="TableData">订单描述： </td>
<td nowrap class="TableData" colspan="3">
<textarea cols=57 rows=3 name="ORDER_MEMO" class="BigInput" wrap="yes"><?=$ORDER_MEMO1?></textarea>
</td>
</tr>
<tr>
<td nowrap class="TableData">创建日期：</td>
<td nowrap class="TableData">
<input type="text" name="CREATE_DATE" size="15" maxlength="10" class="BigStatic" readonly value="<? if($ORDER_ID!=""){echo $CREATE_DATE1;}else{echo $CREATE_DATE=date("Y-m-d",time());}?>">
<img src="/images/menu/calendar.gif" border="0" style="cursor:hand" onclick="td_calendar('form1.CREATE_DATE');">
</td>
<td nowrap class="TableData">来货日期： </td>
<td nowrap class="TableData">
<input type="text" name="BEGIN_DATE" size="15" maxlength="10" class="BigStatic" readonly value="<?=$BEGIN_DATE1?>">
<img src="/images/menu/calendar.gif" border="0" style="cursor:hand" onclick="td_calendar('form1.BEGIN_DATE');">
</td>
</tr>
<tr>
<td nowrap class="TableData">创建人： </td>
<td nowrap class="TableData">
<input type="hidden" name="CREATOR" value="<?=$LOGIN_USER_ID?>" >
<?
$query2="select USER_NAME from USER where USER_ID='$LOGIN_USER_ID'";
$cursor2 = exequery($connection, $query2);
if($ROW=mysql_fetch_array($cursor2))
$SELLER1_NAME=$ROW["USER_NAME"];
?>
<input type="text" name="CREATOR_NAME" class="BigStatic" readonly size="15" maxlength="100" value="<?=$SELLER1_NAME?>">
</td>
<td nowrap class="TableData">负责人： </td>
<td nowrap class="TableData">
<input type="hidden" name="TO_ID" value="<?=$RECIVER1?>">
<input type="text" name="TO_NAME" class="BigStatic" readonly size="15" maxlength="100" value="<?=$RECIVER_NAME1?>">
<input type="button" value="选择" class="SmallButton" onClick="LoadWindow()" title="指定负责人" name="button">
</td>
</tr>
<tr>
<td nowrap class="TableData">备注： </td>
<td nowrap class="TableData" colspan="3">
<textarea cols=57 rows=3 name="REMARK" class="BigInput" wrap="yes"><?=$REMARK1?></textarea>
</td>
</tr>
<tr>
<td class="TableData" colspan="4">
<?=get_field_table(get_field_html("SUPPLY_ORDER", $ORDER_ID))?>
</td>
</tr>
<tr>
<td nowrap class="TableHeader" colspan="4" align="left">
订单明细：
</td>
</tr>
<tr>
<td nowrap class="TableData">产品： </td>
<td class="TableData" colspan="3">
<input type="hidden" name="PRO_ID" value="">
<input type="hidden" name="PRICE" value="">
<input type="text" name="PRO_NAME" size="20" class="BigStatic" maxlength="20" value="" readonly>
<input type="button" value="选 择" class="SmallButton" onClick="LoadWindow3()" title="选择产品" name="button">
<input type="button" value="添加" class="SmallButton" title="添加" name="button" onclick="add_detail();">
</td>
</tr>
<tr>
<td nowrap class="TableData" colspan="4">
<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>
<?
$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,
b.PRODUCT_TYPE as PRODUCT_TYPE,a.TRANS_PRICE*a.TRANS_QTY as TOTALPRICE
from ORDER_LINE a
LEFT OUTER JOIN PRODUCT b ON a.PRODUCT_ID = b.PRODUCT_ID
where a.ORDER_ID='$ORDER_ID' order by a.LINE_ID desc ";
$cursor= exequery($connection,$query);
$VOTE_COUNT=0;
$SUM_TRANS_QTY=0;
$SUM_TOTAL_PRICE=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_TYPE=$ROW["PRODUCT_TYPE"];
$TOTAL_PRICE=$ROW["TOTALPRICE"];
$SUM_TRANS_QTY=$SUM_TRANS_QTY+$TRANS_QTY;
$SUM_TOTAL_PRICE=$SUM_TOTAL_PRICE+$TOTAL_PRICE;
if($VOTE_COUNT%2==1)
$TableLine="TableLine1";
else
$TableLine="TableLine2";
?>
<tr class="<?=$TableLine?>">
<td nowrap align="center"><?=$PRODUCT_NAME?></td>
<td align="center"><?=$PRODUCT_TYPE?></td>
<td align="center"><input type="text" value="<?=$TRANS_PRICE?>" name="<?=$LINE_ID?>PRICE"></td>
<td nowrap align="center"><input type="text" value="<?=$TRANS_QTY?>" name="<?=$LINE_ID?>TRANS_QTY"></td>
<td nowrap align="center"><?=$TOTAL_PRICE?></td>
<td nowrap align="center"><input type="text" value="<?=$MEMO?>" name="<?=$LINE_ID?>MEMO"></td>
<td nowrap align="center">
<?
if($querstr!="")
{
$urlstr1=str_replace("%","&",$querstr);
?>
<a href="javascript:edit_line('<?=$LINE_ID?>');">保存</a>
<a href="javascript:delete_line('<?=$LINE_ID?>');">删除</a>
<?
}
else
{
?>
<a href="javascript:edit_line('<?=$LINE_ID?>');">保存</a>
<a href="javascript:delete_line('<?=$LINE_ID?>');">删除</a>
<?
}
?>
</td>
<?
}
?>
</table>
</td>
</tr>
<tr>
<td nowrap class="TableControl" colspan="4" align="center">
<?
if($querstr!="")
{
$urlstr1=str_replace("%","&",$querstr);
?>
<input type="hidden" name="OP">
<input type="hidden" name="LINE_ID">
<input type="hidden" value="<?=$ORDER_ID?>" name="ORDER_ID">
<input type="hidden" name="querstr" value="<?=$querstr?>">
<input type="hidden" value="<?=$querstr?>&ORDERFIELD=<?=$ORDERFIELD?>&ORDERTYPE=<?=$ORDERTYPE?>&CUR_PAGE=<?=$CUR_PAGE?>" name="QUERY_LIST">
<input type="hidden" value="ad_query" name="FLAGSOURCE">
<input type="submit" value="确定" class="BigButton" name="button">
<input type="button" value="转至订单管理页面" class="BigButton" onclick="location='../manage/ad_query/list.php?<?=$urlstr1?>&ORDERFIELD=<?=$ORDERFIELD?>&ORDERTYPE=<?=$ORDERTYPE?>&CUR_PAGE=<?=$CUR_PAGE?>'">
<?
}
else
{
?>
<input type="hidden" name="OP">
<input type="hidden" name="LINE_ID">
<input type="hidden" value="<?=$ORDER_ID?>" name="ORDER_ID">
<input type="hidden" value="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="submit" value="确定" class="BigButton" title="新建" name="button">
<input type="button" value="转至订单管理页面" class="BigButton" onclick="location='../manage?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>
</form>
</table>
</body>
</html>
<?
function GETALLDATE($CODE,$GETVALUE)
{
global $connection;
$query = "SELECT * from SYS_CODE where PARENT_NO='$CODE'";
$connection=OpenConnection();
$cursor= exequery($connection,$query);
while($ROW=mysql_fetch_array($cursor))
{
$CODE_NO=$ROW["CODE_NO"];
$CODE_NAME=$ROW["CODE_NAME"];
if ($CODE_NO==$GETVALUE)
{echo "<option value=".$CODE_NO." selected>".$CODE_NAME."</option>";}
else
{echo "<option value=".$CODE_NO." >".$CODE_NAME."</option>";}
}
}
?>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -