20141021 orders_detail_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.做新增動作 次訂單
*/
$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"];
// 新增至次訂單 orders01
$varp_cnts = ""; if (isset($_POST["p_cnts"]) ){ $varp_cnts =$_POST["p_cnts"];}
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 customers01 set ";
$upd.=" c_num = ".$varc_num.", ";
//$upd.=" c_name = '".$varc_name."', ";
$upd.=" c_addr = '".$varc_addr."', ";
$upd.=" c_phone = '".$varc_phone."', ";
$upd.=" c_fax = '".$varc_fax."', ";
$upd = substr($upd, 0 , strlen($upd) -2);
$upd.=" where 1=1 ";
$upd.=" and c_id= ".$varc_id." ";
//echo " upd = ".$upd."<br>";
//exit();
$Recordset1 = mysql_query($upd, $allianz) or die(mysql_error()); // 執行查詢語法
//exit();
header(sprintf("Location: %s", "orders_qry.php" ));
}
$o_id = $row_Recordset1["o_id"];
$c_num = "";
$c_name = "";
$c_addr = "";
$c_phone = "";
$c_fax = "";
if( strlen($varc_id) >0){
mysql_select_db($database_allianz, $allianz); // 連線資料庫
$sql = " select * from customers01 where 1=1 "; // 準備要查詢的SQL指令
$sql.= " and c_id = " .$varc_id ." ";
$Recordset1 = mysql_query($sql, $allianz) or die(mysql_error()); // 執行查詢語法
$row_Recordset1 = mysql_fetch_assoc($Recordset1); // 把查詢的結果帶到$row_Recordset1[]陣列中
$totalRow_Recordset1 = mysql_num_rows($Recordset1); // 把查詢後表格總共有幾列(幾筆資料)放到 $totalRows_Recordset1
$c_num = $row_Recordset1["c_num"];
//echo " c_num = " . $c_num . "<br>";
$c_name = $row_Recordset1["c_name"];
//echo " c_name = " . $c_name . "<br>";
$c_addr = $row_Recordset1["c_addr"];
//echo " c_addr =" . $c_addr . "<br>";
$c_phone = $row_Recordset1["c_phone"];
//echo " c_phone = " . $c_phone . "<br>";
$c_fax = $row_Recordset1["c_fax"];
//echo " c_fax = " . $c_fax . "<br>";
}
$p_name = "";
$p_spec = "";
$p_prices = "";
if( strlen($varp_id) >0){
mysql_select_db($database_allianz, $allianz); // 連線資料庫
$sql2 = " select * from products01 where 1=1 "; // 準備要查詢的SQL指令
$sql2.= " and p_id = " .$varp_id ." ";
$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
$p_name = $row_Recordset2["p_name"];
$p_spec = $row_Recordset2["p_spec"];
$p_prices = $row_Recordset2["p_prices"];
}
echo " varc_id = " . $varc_id . "<br>";
echo " varc_name = " . $varc_name . "<br>";
?>
<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>
<!--
-->
</script>
</head>
<body>
<div id="dialog" title="基本訊息"></div>
<form method="post" name="form1" id="form1" action="" enctype="multipart/form-data">
<table border="1">
<tr>
<td colspan="11">修改表</td>
</tr>
<tr>
<tr>
<td>客戶名稱</td>
<td>
<select id="c_id" name="c_id" onchange="idkey()">
<option value="">請選擇</option>
<?php do{ ?>
<option value="<?php echo $row_Recordset1["c_id"];?>" <?php if ($varc_id==$row_Recordset1["c_id"]){echo "selected";} ?>><?php echo $row_Recordset1["c_name"];?></option>
<?php }while( $row_Recordset1 = mysql_fetch_assoc($Recordset1) ); ?>
</select>
</td>
<td>統一編號</td>
<td><input type="text" name="c_num" value="<?php echo $row_Recordset1["c_num"];?>"></td>
<td>住址</td>
<td><input type="text" name="c_addr" value="<?php echo $row_Recordset1["c_addr"];?>"></td><?php // $row_Recordset1["c_addr"];?>
<td>手機</td>
<td><input type="text" name="c_phone" value="<?php echo $row_Recordset1["c_phone"];?>"></td>
<td>傳真</td>
<td><input type="text" name="c_fax" value="<?php echo $row_Recordset1["c_fax"];?>"></td>
<td><input type="submit" value="修改"></td>
</tr>
<tr>
<td>產品名稱</td>
<td>
<select id="p_id" name="p_id" onchange="idkey();">
<option value="">請選擇</option>
<?php do{ ?>
<option value="<?php echo $row_Recordset2["p_id"];?>" <?php if ($varp_id==$row_Recordset2["p_id"]){echo "selected";} ?>><?php echo $row_Recordset2["p_name"];?></option>
<?php }while( $row_Recordset2 = mysql_fetch_assoc($Recordset2) ); ?>
</select>
</td>
<td>產品編號</td>
<td>
<input type="text" name="p_id" id="p_id" value="<?php echo $row_Recordset2["p_id"];?>" class="inputbox_size">
</td>
<td>規格</td>
<td>
<input type="text" name="p_spec" id="p_spec" value="<?php echo $row_Recordset2["p_spec"];?>" class="inputbox_size">
</td>
<td>單價</td>
<td>
<input type="text" name="p_prices" id="p_prices" value="<?php echo $row_Recordset2["p_prices"];?>" class="inputbox_size">
</td>
<td colspan="2"> </td>
<td><input type="submit" value="修改"></td>
</tr>
</table>
<input type="hidden" name="mm_form" value="form1">
</form>
</body>
</html>
留言列表
