| Server IP : 61.19.30.66 / Your IP : 216.73.216.15 Web Server : Apache/2.2.22 (Ubuntu) System : Linux klw 3.11.0-15-generic #25~precise1-Ubuntu SMP Thu Jan 30 17:39:31 UTC 2014 x86_64 User : www-data ( 33) PHP Version : 5.3.10-1ubuntu3.48 Disable Function : pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority, MySQL : ON | cURL : OFF | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : OFF Directory : /var/www/cooperative/sell/ |
Upload File : |
<?
ob_start();
session_start();
if($_SESSION["adminlogin"]=="")
{
header('location:index.php');
exit();
}
//============ Start Session และทำการเรียก Function ติดต่อฐานข้อมูล
require_once('../connect/connect.php');
require_once('../connect/function.php');
//=========== กรณีมีการแก้ไขรายการสินค้า
if($_GET["Action"]=="Save")
{
//=========== บันทึกข้อมูลสินค้า
$sql_up = "update order_stock set Quantity='$_POST[txtQuantity]',Price='".str_replace(",","",$_POST[txtPrice])."',StockID='$_POST[ddlStockID]' where OrderStockID='$_GET[OrderStockID]'";
$dbquery_up = mysql_query($sql_up);
$value = $_POST["txtQuantity"] - $_POST["hidQuantity"];
$sql_up = "update stock set Stock=Stock + ($value) where StockID='$_POST[ddlStockID]'";
$dbquery_up = mysql_query($sql_up);
echo"<script language='JavaScript'>";
echo"alert('แก้ไขข้อมูลเรียบร้อยแล้ว');";
echo"window.location='edit_order_stock.php?OrderStockID=$_GET[OrderStockID]';";
echo"</script>";
}
?>
<html>
<title>..:: ระบบจัดการฐานข้อมูล ::</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<link rel="stylesheet" href="../css/styles.css" type="text/css">
<script language="JavaScript" src="editor.js"></script>
<div align="center"><br>
<?
//=========== อ่านว่าคือสินค้าชนิดใด
$resultHeader=select("order_stock","where 1=1 and OrderStockID='".$_GET["OrderStockID"]."'");
if(!$resultHeader)
{
header("location:order_stock.php");
}
?>
<table cellspacing=1 cellpadding=4 width="68%" bgcolor=#CCCCCC border=0 align="center" height="10">
<tbody>
<tr bgcolor=#e5e5e5>
<td width="100%" bgcolor="#FFFFFF"> <div align="center"></div>
<table cellspacing=1 cellpadding=4 width="100%" border=0 align="center" height="10">
<tbody>
<tr bgcolor=#e5e5e5>
<td width="35%" bgcolor="#FFFFFF"> <div align="left"><b><img src="../image/allrowto.gif" width="11" height="11" align="absbottom">
แก้ไขรายการสั่งซื้อวัตถุดิบ </b></div></td>
<td width="22%" align=middle bgcolor="#FFFFFF"> <div align="left">
</div></td>
<td width="43%" bgcolor="#FFFFFF"> <div align="right"><a href="order_stock.php">กลับไป</a></div></td>
</tr>
</tbody>
</table></td>
</tr>
</tbody>
</table>
</div>
<form name="frm<?=$i;?>" method="post" action="<?=$_SERVER['PHP_SELF'];?>?OrderStockID=<?=$_GET["OrderStockID"];?>&Action=Save" enctype="multipart/form-data" onSubmit="return checkvalue()">
<table cellspacing=1 cellpadding=3 width="56%" bgcolor=#CCCCCC border=0 align="center" height="10">
<tbody>
<tr bgcolor=#e5e5e5>
<td bgcolor="#FFFFFF"> <script language="Javascript1.2"><!-- // load htmlarea
_editor_url = ""; // URL to htmlarea files
var win_ie_ver = parseFloat(navigator.appVersion.split("MSIE")[1]);
if (navigator.userAgent.indexOf('Mac') >= 0) { win_ie_ver = 0; }
if (navigator.userAgent.indexOf('Windows CE') >= 0) { win_ie_ver = 0; }
if (navigator.userAgent.indexOf('Opera') >= 0) { win_ie_ver = 0; }
if (win_ie_ver >= 5.5) {
document.write('<scr' + 'ipt src="' +_editor_url+ 'editor.js"');
document.write(' language="Javascript1.2"></scr' + 'ipt>');
} else { document.write('<scr'+'ipt>function editor_generate() { return false; }</scr'+'ipt>'); }
// --></script>
<script language="JavaScript">
function checkvalue()
{
if(document.all.ddlStockID.value =="")
{
alert('กรุณาเลือกวัตถุดิบ');
document.all.ddlStockID.focus();
return false;
}
if(document.all.txtQuantity.value =="")
{
alert('กรุณากรอกจำนวนที่ซื้อ');
document.all.txtQuantity.focus();
return false;
}
if(document.all.txtPrice.value =="")
{
alert('กรุณากรอกราคารวม');
document.all.txtPrice.focus();
return false;
}
}
</script>
<table width="100%" border="0" cellspacing="2" cellpadding="2">
<tr>
<td width="34%"> </td>
<td width="66%"> </td>
</tr>
<tr>
<td valign="top">วันที่</td>
<td>
<?=$resultHeader["Date"];?>
</td>
</tr>
<tr>
<td valign="top">รหัสวัตถุดิบ <font color="#FF0000">** </font></td>
<td><select name="tmpddlStockID" id="tmpddlStockID" disabled>
<option value="">-- เลือกรายการวัตถุดิบสินค้า --</option>
<?
$i=0;
//=========== ทำการ query เพื่อเลือกรายการสินค้า
$sql_stock = "select * from stock where 1 $condition order by StockID asc";
$dbquery_stock = mysql_query($sql_stock);
$num_rows_stock = mysql_num_rows($dbquery_stock);
while ($result= mysql_fetch_array($dbquery_stock))
{
if($result["StockID"] == $resultHeader["StockID"])
{
$sel = "selected";
}
else
{
$sel = "";
}
$i++;
?>
<option value="<?=$result["StockID"];?>" <?=$sel;?>>
<?=$result["StockCode"];?>
[
<?=$result["StockName"];?>
เบอร์ :
<?=$result["Number"];?>
สี :
<?=$result["Color"];?>
]</option>
<?
}
?>
</select>
<input name="ddlStockID" type="hidden" id="ddlStockID" value="<?=$resultHeader["StockID"];?>"> </td>
</tr>
<tr>
<td valign="top">จำนวนที่ซื้อ <font color="#FF0000">** </font></td>
<td><input name="txtQuantity" type="text" class="txtbox" id="txtQuantity" value="<?=$resultHeader["Quantity"];?>" size="10" maxlength="10">
<input name="hidQuantity" type="hidden" class="txtbox" id="hidQuantity" value="<?=$resultHeader["Quantity"];?>" size="10" maxlength="10"></td>
</tr>
<tr>
<td>ราคารวม <font color="#FF0000">** </font></td>
<td><input name="txtPrice" type="text" class="txtbox" id="txtPrice" value="<?=$resultHeader["Price"];?>" size="10" maxlength="10"></td>
</tr>
<tr>
<td> </td>
<td><input name="Submit" type="submit" class="button" value="บันทึก">
<input name="Cancel" type="button" class="button" id="Cancel" value="ยกเลิก" onClick="window.location='order_stock.php';"></td>
</tr>
<tr>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
</tr>
</table></td>
</tr>
</tbody>
</table>
</form>