訂單(修改)+訂單明細
orders_upd.php
<?php require_once('../../Connections/allianz.php'); ?>
<?php
/*
1.查詢下拉選單表 客戶表
2.選擇下拉選單 帶KEY值
key 帶出客戶表的全部欄位
3.KEY值用 javascript 抓網址列
4.做新增動作 主訂單
5.查詢下拉選單表 產品 表
6.選擇下拉選單 帶KEY值
key 帶出產品 表的全部欄位
7.KEY值用 javascript 抓網址列
8.做新增動作 次訂單
*/
$varo_id = ""; if (isset($_REQUEST["o_id"]) ){ $varo_id =$_REQUEST["o_id"];}
//echo " o_id = " . $varo_id . "<br>";
$varc_id = ""; if (isset($_REQUEST["c_id"]) ){ $varc_id =$_REQUEST["c_id"];}
//echo " c_id = " . $varc_id . "<br>";
$varp_id = ""; if (isset($_REQUEST["p_id"]) ){ $varp_id =$_REQUEST["p_id"];}
//echo " p_id = " . $varp_id . "<br>";
$varp_cnts = ""; if (isset($_REQUEST["p_cnts"]) ){ $varp_cnts =$_REQUEST["p_cnts"];}
//echo " p_cnts = " . $varp_cnts . "<br>";
$varMM_form = ""; if (isset($_POST["mm_form"]) ){ $varMM_form =$_POST["mm_form"];}
//echo "mm_form=" .$varMM_form ."<br>";
// 查到o_id
mysql_select_db($database_allianz, $allianz); // 連線資料庫
$sql3 = " select max(o_id) o_id from orders01 where 1=1 "; // 準備要查詢的SQL指令
$Recordset3 = mysql_query($sql3, $allianz) or die(mysql_error()); // 執行查詢語法
$row_Recordset3 = mysql_fetch_assoc($Recordset3); // 把查詢的結果帶到$row_Recordset1[]陣列中
$totalRow_Recordset3 = mysql_num_rows($Recordset3); // 把查詢後表格總共有幾列(幾筆資料)放到 $totalRows_Recordset1
$o_id = $row_Recordset3["o_id"];
$varp_cnts = ""; if (isset($_POST["p_cnts"]) ){ $varp_cnts =$_POST["p_cnts"];}
// 新增至次訂單 orders01
if( $varMM_form == "form1"){
$varc_num = ""; if (isset($_POST["c_num"]) ){ $varc_num =$_POST["c_num"];}
$varc_name = ""; if (isset($_POST["c_name"]) ){ $varc_name =$_POST["c_name"];}
$varc_addr = ""; if (isset($_POST["c_addr"]) ){ $varc_addr =$_POST["c_addr"];}
$varc_phone = ""; if (isset($_POST["c_phone"]) ){ $varc_phone =$_POST["c_phone"];}
$varc_fax = ""; if (isset($_POST["c_fax"]) ){ $varc_fax =$_POST["c_fax"];}
mysql_select_db($database_allianz, $allianz); // 連線資料庫
$upd=" update orders01 set ";
$upd.=" c_id = ".$varc_id.", ";
$upd.=" c_addr = '".$varc_addr."', ";
$upd = substr($upd, 0 , strlen($upd) -2);
$upd.=" where 1=1 ";
$upd.=" and o_id= ".$varo_id." ";
//echo " upd = ".$upd."<br>";
//exit();
$Recordset1 = mysql_query($upd, $allianz) or die(mysql_error()); // 執行查詢語法
//exit();
header(sprintf("Location: %s", "orders_qry.php" ));
}
?>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<script src="http://code.jquery.com/jquery-1.10.2.js"></script>
<script src="../js/jquery-ui-1.11.1.custom/jquery-ui.js"></script>
<link rel="stylesheet" href="../js/jquery-ui-1.11.1.custom/jquery-ui.structure.css">
<link rel="stylesheet" href="../js/jquery-ui-1.11.1.custom/jquery-ui.theme.css">
<style>
.inputbox_size{
width:100%;
}
</style>
<script>
<!--
function idkey(){
var sUrl = "orders_upd.php?";
sUrl += "&c_id=" + $("#c_id").val();
sUrl += "&o_id=" + $("#o_id").val();
alert( sUrl );
location.href = sUrl;
}
-->
</script>
</head>
<body>
<div id="dialog" title="基本訊息"></div>
<form method="post" name="form1" id="form1" action="">
<table border="1">
<tr>
<td colspan="11">修改表</td>
</tr>
<tr>
<td>客戶名稱</td>
<td>
<?php
mysql_select_db($database_allianz, $allianz); // 連線資料庫
$sql2 = " select * from customers01 where 1=1 "; // 準備要查詢的SQL指令
//echo "sql2 = " .$sql2 . "<br>";
$Recordset2 = mysql_query($sql2, $allianz) or die(mysql_error()); // 執行查詢語法
$row_Recordset2 = mysql_fetch_assoc($Recordset2); // 把查詢的結果帶到$row_Recordset1[]陣列中
$totalRow_Recordset2 = mysql_num_rows($Recordset2); // 把查詢後表格總共有幾列(幾筆資料)放到 $totalRows_Recordset1
?>
<select id="c_id" name="c_id" onchange="idkey()">
<option value="">請選擇</option>
<?php do{ ?>
<option value="<?php echo $row_Recordset2["c_id"];?>" <?php if ($varc_id==$row_Recordset2["c_id"]){echo "selected";} ?>><?php echo $row_Recordset2["c_name"];?></option>
<?php }while( $row_Recordset2 = mysql_fetch_assoc($Recordset2) ); ?>
</select>
</td>
</tr>
<?php
if( strlen($varc_id)){
mysql_select_db($database_allianz, $allianz); // 連線資料庫
$sql3 = " select * from customers01 where 1=1 "; // 準備要查詢的SQL指令
//echo "sql3 = " .$sql3 . "<br>";
$Recordset3 = mysql_query($sql3, $allianz) or die(mysql_error()); // 執行查詢語法
$row_Recordset3 = mysql_fetch_assoc($Recordset3); // 把查詢的結果帶到$row_Recordset1[]陣列中
$totalRow_Recordset3 = mysql_num_rows($Recordset3); // 把查詢後表格總共有幾列(幾筆資料)放到 $totalRows_Recordset1
?>
<tr>
<td>外送住址</td>
<td>
<input type="text" name="c_addr" value="<?php echo $row_Recordset3["c_addr"];?>">
</td>
</tr>
<tr>
<td>統一編號</td>
<td><?php echo $row_Recordset3["c_num"];?></td>
</tr>
<tr>
<td>客戶住址</td>
<td><?php echo $row_Recordset3["c_addr"];?></td>
</tr>
<tr>
<td>手機</td>
<td><?php echo $row_Recordset3["c_phone"];?></td>
</tr>
<tr>
<td>傳真</td>
<td><?php echo $row_Recordset3["c_fax"];?></td>
</tr>
<?php } ?>
</table>
<input type="hidden" name="o_id" id="o_id" value="<?php echo $_REQUEST["o_id"];?>">
<input type="submit" value="修改">
<input type="hidden" name="mm_form" value="form1">
</form>
</body>
</html>
留言列表
