API tools faq
paste
Advertisement
cdsatrian

tambah permintaan barang

cdsatrian
Jan 9th, 2013
127
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 4.54 KB | None | 0 0
raw download clone embed print report
  1. <?php
  2.   session_save_path("klien/login/sess");
  3.   @session_start();
  4.   include("connect/connect.php");
  5.   $kd="PR".date("y").date("m").date("d")."01";
  6.   $sql="SELECT no_per FROM tpermintaan;";
  7.   $result = mysql_query($sql);
  8.   if($result)
  9.   {
  10.     while($row = mysql_fetch_array($result))
  11.     {
  12.       $kode=$row['no_per'];
  13.     }
  14.     if(substr($kode,2,-2)==date("ymd"))
  15.     {
  16.       $kode=substr($kode,-2);
  17.       $kd="PR".date("y").date("m").date("d").str_pad(++$kode,2,"0",STR_PAD_LEFT);
  18.     }
  19.   }
  20.   $sql = "SELECT * FROM  tstok";
  21.   $result = mysql_query($sql);
  22.   $option_barang='';
  23.   if ($result){
  24.     while ($data = mysql_fetch_array($result)) {
  25.       $option_barang.="<option value=\"".$data['KD_BRG']."\">".$data['NAMA']."</option>\n";
  26.     }
  27.   }
  28. ?>
  29. <!DOCTYPE html>
  30. <html>
  31. <head>
  32.   <title>Permintaan</title>
  33.   <style type="text/css">
  34.     .add:hover {cursor:pointer;}
  35.   </style>
  36. </head>
  37. <body>
  38. <fieldset>
  39.   <legend>
  40.     <h3>Buat Permintaan</h3>
  41.   </legend>
  42.   <form method="post" id="myfrm" action="?menu=simpan_permintaan">
  43.     <table>
  44.       <tr>
  45.         <td>No Permintaan</option></td>
  46.         <td>:</td>
  47.         <td> <?php echo $kd;  ?><input type='hidden' name='no_per' value="<?php echo $kd; ?>" /></td>
  48.       </tr>
  49.       <!--<tr>
  50.         <td>Tanggal Permintaan</td>
  51.         <td>:</td>
  52.         <td><input type='text' name='tanggal' value="<?php echo $_POST['tanggal']; ?>" /></td>
  53.       </tr>-->
  54.       <tr>
  55.         <td>Nama</td>
  56.         <td>:</td>
  57.         <td><?php echo $_SESSION['username'];?> <input type="hidden" name="nama" value="<?php echo $_SESSION['username'];?>"/></td>
  58.       </tr>
  59.       <tr>
  60.         <td>Nama Barang</td>
  61.         <td>:</td>
  62.         <td>
  63.           <select size="1" id="kd_brg">
  64.             <?php echo $option_barang;?>
  65.           </select>
  66.           <input type="hidden" name="stok" id="stok" value="0"/>
  67.         </td>
  68.       </tr>
  69.       <tr>
  70.         <td>Jumlah</td>
  71.         <td>:</td>
  72.         <td>
  73.           <input type="text" id="jumlah" size="3" maxlength="2" />
  74.           <img src="images/add.gif" id="add" class="add" />
  75.         </td>
  76.       </tr>
  77.       <tr>
  78.         <td>Kode Barang</td>
  79.         <td width="312">Nama Barang</td>
  80.         <td width="119">Jumlah</td>
  81.       </tr>
  82.       <tr>
  83.          <td>
  84.             <input type="button" name="simpan" id="simpan" value="Simpan" />
  85.             <input type="button" name="cancel" id="cancel" value="Cancel" />
  86.          </td>
  87.       </tr>
  88.     </table>
  89.   </form>
  90. </fieldset>
  91. <script type="text/javascript" src="js/jquery.min.js"></script>
  92. <script type="text/javascript">
  93. $(document).ready(function() {
  94.     $('#add').click(function() {
  95.       if(validation() != ''){
  96.         alert(validation());
  97.       } else
  98.         $("#data").children('tbody').append(newRow());
  99.     });
  100.     $('#kd_brg').change(function(){
  101.       $.ajax(
  102.         {
  103.           type: "POST",
  104.           url: "get_stok.php",
  105.           data: "kd="+ this.value,
  106.           dataType: "json",
  107.           success: function(data)
  108.           {
  109.             if(data.result<=0){
  110.               alert('no available stock');
  111.             }
  112.             $('#stok').val(data.result);
  113.           },
  114.           error: function(data){
  115.             alert('Ajax error');
  116.           }
  117.         }      
  118.       )
  119.     });
  120.     $('#simpan').click(function(){
  121.     $("#myfrm").submit();
  122.     });
  123. });
  124.  
  125. function validation(){
  126.    var msg='';
  127.    if($('#jumlah').value > $('#stok').value){
  128.       msg='jumlah yang dimasukkan lebih dari stok yang tersedia';
  129.    }
  130.    return msg;
  131. }
  132.  
  133. function newRow() {
  134.     var kode = $("select#kd_brg").val();
  135.     var jumlah = $("#jumlah").val();
  136.     var nama = $("#kd_brg option:selected").text();
  137.     if(jumlah == '' || jumlah == 0) {
  138.         alert('jumlah kosong');
  139.         return false;
  140.     }
  141.     if($("#" + kode).length > 0) {
  142.         alert('data sudah ada');
  143.         return false;
  144.     }
  145.     var text = "<tr>" +
  146.         "<td><input value='" + kode + "' name='kode[]' id = '" + kode + "' readonly /></td>" +
  147.         "<td><input value='" + nama + "' name='nbarang[]' size=50 readonly /></td>" +
  148.         "<td><input value='" + jumlah + "' name='jml[]' readonly /></td>" +
  149.         "</tr>";
  150.     return text;
  151. };
  152. </script>
  153. </body>
  154. </html>
  155.  
  156. /////////-- file : get_stok.php ---//////////
  157.  
  158. <?php
  159.   //filename: get_stok.php
  160.  
  161.   $kd=isset($_POST['kd'])?$_POST['kd']:'';
  162.   $sql = "SELECT stok FROM  tstok WHERE kd_brg='".$kd."'";
  163.   if($result = mysql_query($sql)){
  164.     $row=mysql_fetch_row($result);
  165.     $data['result']=$row['stok'];
  166.   }
  167.   return json_encode($data);
  168. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!