Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $material=$_GET['material'];
- mysql_select_db($database_ska, $ska);
- $query_brg = "SELECT * FROM inv WHERE material LIKE '%$material%'";
- $brg = mysql_query($query_brg, $ska) or die(mysql_error());
- $totalRows_brg = mysql_num_rows($brg);
- <form id="form1" name="form1" method="GET" action="">
- <label>Material
- <input name="material" type="text" id="material" size="10" />
- </label>
- <input type="submit" name="insert" id="insert" value="Submit" />
- </form>
- <p>PEMAKAIAN MATERIAL</p>
- <form id="form2" name="form2" method="post" action="<?php echo $editFormAction; ?>">
- <script>
- var thoudelim = ",";
- var decdelim = ".";
- var curr = "";
- var d=document;
- function haltnondigit(e) {
- var allowkey=Array(48,49,50,51,52,53,54,55,56,57,8,9,188,190,45,46,13,33,34,35,36,37,38,39,40,112,113,114,115,116,117,118,119,120,121,123);
- if(allowkey.indexOf(e.keyCode)==-1) return false;
- return true;
- }
- function format(s,r) {
- s=Math.round(s*Math.pow(10,r))/Math.pow(10,r);
- s=String(s);s=s.split(".");var l=s[0].length;var t="";var c=0;
- while(l>0){t=s[0][l-1]+(c%3==0&&c!=0?thoudelim:"")+t;l--;c++;}
- s[1]=s[1]==undefined?"0":s[1];
- for(i=s[1].length;i<r;i++) {s[1]+="0";}
- return curr+t+decdelim+s[1];
- }
- function input_focus(t) {
- t.value=t.getAttribute('ref');t.select();
- }
- function input_keydown(t,e) {
- return haltnondigit(e);t.value=t.getAttribute('ref');
- }
- function input_keyup(t,s) {
- t.setAttribute('ref',t.value);
- if(s=="qtystock") {
- var temp=parseFloat(t.parentNode.nextSibling.firstChild.getAttribute('ref'))*t.value;
- t.parentNode.nextSibling.nextSibling.firstChild.setAttribute('ref',temp);
- t.parentNode.nextSibling.nextSibling.firstChild.innerHTML=format(temp,2);
- }
- else if(s=="qtypakai") {
- var temp=parseFloat(t.parentNode.previousSibling.firstChild.getAttribute('ref'))*t.value;
- t.parentNode.nextSibling.firstChild.setAttribute('ref',temp);
- t.parentNode.nextSibling.firstChild.innerHTML=format(temp,2);
- }
- calc_total();
- }
- function input_onblur(t) {
- t.value=format(t.value,2);
- return false;
- }
- function calc_total() {
- var x=d.getElementsByTagName("div");
- var total=0;
- for(i=0;i<x.length;i++) {
- if(x[i].id=="jumlah") total+=isNaN(parseFloat(x[i].getAttribute("ref")))?0:parseFloat(x[i].getAttribute("ref"));
- }
- d.getElementById("total").value=format(total,2);
- }
- </script>
- <table width="900" border="1">
- <tr>
- <td width="420">MATERIAL</td>
- <td width="96">QTY STOCK</td>
- <td width="95">QTY PAKAI</td>
- <td width="209">QTY SISA</td>
- </tr>
- <?php
- $i=1;
- while($row_brg = mysql_fetch_assoc($brg)){
- echo "
- <tr>
- <td>".$row_brg['material']."</td>
- <td>".$row_brg['qty']."
- </td><td><input type='text' name='qtypakai".$i."' id='qtypakai' value=0,00
- rel=".$row_brg['qty']."
- ref='0'
- onfocus='input_focus(this);'
- onkeydown='return input_keydown(this,event);'
- onkeyup='input_keyup(this,\"qtypakai\");'
- onblur='return input_onblur(this);'
- >
- </td><td><div id='jumlah' ref=0,00>0,00</div>
- </td>
- </tr>";
- }
- ?>
- <tr>
- <td colspan="3">TOTAL </td>
- <td><input name="total" type="text" id="total" readonly="readonly" /></td>
- </tr>
- </table>
- <p align="center">
- <input type="submit" name="submit" id="submit" onclick="return tanya()" value="POSTING" />
- <input type="reset" name="reset" id="reset" value="RESET" />
- <input type="hidden"name="n"value= "<?php echo $jum ?>" />
- <input type="hidden" name="MM_insert" value="form2" />
- </p>
- <p> </p>
- </form>
- <script>
- calc_total();
- </script>
- <p> </p>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement