Mon Jul 01, 2013 11:08 pm
<?php
include "function.php";
if(isset($_POST['add_serial'])){
$date = date("Y-m-d H:i:s");
$data = "'".$_POST['out_location']."','".$date."','".$_POST['out_qty']."','".$_POST['out_wo']."','";
$data .= $_POST['reciever']."','".$_POST['Ship_to']."','";
$data .= $_POST['out_serial']."','0'";
$column = "(`out_location`, `out_qty`, `out_wo`, `out_serial`, `Receiver`, `ship_to`, `remark`, `tmp`)";
$sql = "INSERT INTO kwip ".$column." VALUES(".$data.")";
insert_data_sql($sql);
exit;
}
if(isset($_POST['change_status'])){
$sql = "UPDATE kwip SET tmp='1' WHERE Serial='".$_POST['serial_no']."'";
insert_data_sql($sql);
exit;
function add_serial(){
var serial = $('#serial_array').val();
var serial_array = serial.split(',');
for (var i=0;i<serial_array.length;i++)
{
$.post("checkout.php", { serial_no: serial_array, change_status: "change" } );
}
location.reload();
}
function add_serial_tmp() {
var out_location= $('#out_location').val();
var out_qty= $('#out_qty').val();
var out_wo= $('#out_wo').val();
var out_serial= $('#out_serial').val();
var reciever= $('#Reciever').val();
var ship_to= $('#ship_to').val();
var remark= $('#remark').val();
$.post("checkout.php", {
out_location: out_location,
out_qty: out_qty,
out_wo: out_wo,
out_serial: out_serial,
reciever: reciever,
ship_to: ship_to,
remark: remark,
add_serial: "add"
})
.done(function (data) {
if (data = '0') {
$('#serial_holder tr:last').after('<tr id="so-' + so + '"><td>' + so + '</td><td><button onclick="delete_serial(\'$this\')">Delete</button></td></tr>');
var serial_array = $('#serial_array').val();
if(serial_array == '0'){
$('#serial_array').val(so);
}else{
$('#serial_array').val($('#serial_array').val()+','+so);
}
} else {
alert('error');
}
});
}
$(function () {
});
</script>
</head>
<body>
<p align="center" class="style1"><img src="../bannerLogo.png" width="1006" height="87" /><span class="style3"><a href="mainpage.css">Menu</a> <a href="report"></a></span> </p>
<p align="center" class="style1">Board Check-Out Information </p>
<table width="1000" border="0" align="center" bordercolor="#666666" background="../grey.jpg" bgcolor="#FFFFCC">
<tr>
<td bgcolor="#666666"> </td>
<td nowrap bgcolor="#666666"> </td>
</tr>
<tr>
<td width="414">
<strong>Out_Location</strong>
<label for="select"></label>
<label for="select"></label>
<select name="out_location" id="out_location">
<option value="SELECT">SELECT</option>
<option value="FG">FG</option>
<option value="Intel">Intel</option>
<option value="Production">Production</option>
</select>
</td>
<td width="570" nowrap><strong>Out_Qty</strong>
<label for="textfield"></label>
<input type="text" name="invoice" id="out_qty" />
</td>
</tr>
<tr>
<td> </td>
<td nowrap> </td>
</tr>
<tr>
<td><strong>Out_Serial</strong>
<label for="label"></label>
<label for="Submit"></label>
<label for="label"></label>
<input type="text" id="out_serial" />
<input onclick="add_serial_tmp();" id="add_in" type="button" id="add_in" value="add" />
</td>
<td> </td>
</tr>
<tr>
<td nowrap bgcolor="#666666"> </td>
<td nowrap bgcolor="#666666"> </td>
</tr>
<tr>
<td> </td>
<td nowrap> </td>
</tr>
<tr>
<td>
<td nowrap><strong>Reciever </strong>
<label for="textfield"></label>
<input name="reciever" type="text" id="reciever" value="" />
</td>
</tr>
<tr>
<td> </td>
<td nowrap> </td>
</tr>
<tr>
<td height="30"><strong>Ship_To</strong>
<label for="textfield"></label>
<input type="text" name="ship_to" id="ship_to" />
</td>
<td nowrap><strong>Remark</strong>
<label for="textfield"></label>
<input type="text" name="remark" id="remark" />
</td>
</tr>
<tr>
<td bgcolor="#666666"> </td>
<td nowrap bgcolor="#666666"> </td>
</tr>
<tr>
<td> </td>
<td nowrap> </td>
</tr>
<tr>
<td><label for="Submit"></label>
<input onclick="add_serial();" name="Submit2" type="submit" id="Submit2" value="Board Check Out!" />
</td>
<td nowrap> </td>
</tr>
<tr>
<td> </td>
<td nowrap> </td>
</tr>
<tr>
<td bgcolor="#666666"> </td>
<td nowrap bgcolor="#666666"> </td>
</tr>
</table>
<input type="hidden" id="serial_array" value="0">
<table id="serial_holder" width="500">
<th colspan="2" bgcolor="grey" align="left">Serial</th>
<tr>
<td></td>
<td></td>
</tr>
</table>
</body>
</html>
this is what i did..any comment?