- <!DOCTYPE html>
- <html>
- <head>
- <link rel='stylesheet' href='css/amsbarang/default.css'>
- <link rel='stylesheet' href='css/amsbarang/tabel_customer.css'>
- <link rel='stylesheet' href='css/new_design.css'>
- <link href="css/style.css" rel="stylesheet" type="text/css" media="screen"/>
- <!-- Bootstrap core CSS -->
- <link href="css/bootstrap.css" rel="stylesheet">
- <link rel="stylesheet" href="dist/css/bootstrapValidator.css" />
- <?php
- /*History :
- 11/9/2018 : Implementasi Alasan Pada Saat Transaksi Tambah Asset
- */
- // Untuk mengakses halaman ini, harus login
- if(!$user_sedang_login) {
- echo "Belum Login.";
- exit;
- }
- // Atur hak akses user, untuk halaman ini.
- // Halaman ini bisa diakses oleh semua user sbb :
- if($hak_akses >= 2) {
- // Lanjut
- } else {
- echo "Tidak ada hak akses.";
- exit;
- }
- ?>
- <h3>Pengeluaran Barang</h3>
- <meta http-equiv="content-type" content="text/html; charset=iso-8859-1" />
- <link rel="Shortcut Icon" href="region/favicon.ico" />
- <?php
- $id_user = $datauserlogin[2]['username'];
- $login_region = $datauserlogin[2]['id_region'];
- $login_area = $datauserlogin[2]['id_area'];
- $nama_user = $datauserlogin[2]['nama'];
- //echo $nama_user;
- //jika tombol submit ditekan maka :
- if(isset($_POST["tambah"]))
- {
- $qty_in=$_POST['qty_out'];
- //echo $qty_in;
- //stop();
- $qty_in2=floatval($qty_in);
- $qty_in_int = (int)$qty_in;
- $temp=$_POST['temp'];
- $temp2=floatval($temp);
- $sisa_stok=$_POST['sisa_stok'];
- $sisa_stok2=floatval($sisa_stok);
- $stok_keluar=$temp+$qty_in;
- $stok_akhir=$sisa_stok2-$temp-$qty_in;
- $keterangan_pengeluaran="pengeluaran_prwh";
- //echo '|';
- //echo $stok_akhir;
- //exit();
- if($stok_akhir < 0) {
- print '<script type="text/javascript">
- window.onload = function () { alert("Kode Error : ED001 - Jumlah Pengeluaran Melebihi Stok yang Ada. Stok :'.$sisa_stok2.' Pengeluaran :'.$stok_keluar.' "); }
- </script>';
- } else {
- include 'include/b_pengeluaran_temp_part.php';
- }
- }
- //jika tombol submit ditekan maka :
- if(isset($_POST["proses"]))
- {
- //stop();
- //include 'function/function_nomor_dokumen.php';
- $jtransaksi=$_POST['jtransaksi'];
- $area_lama=$_POST['area_lama'];
- include 'function/function_nomor_dokumen_out.php';
- //echo $nomorbaru;
- //stop();
- echo "Transaksi Pengeluarannya :".$jtransaksi."";
- //stop();
- //mengambil idtransaksi untuk tambah barang
- include 'function/function_transaksi_barang.php';
- //$trx_out=trx_pengeluaran_barang();
- //$trx_in=trx_penerimaan_barang();
- $trx_out=trx_pengeluaran_qty();
- //$trx_in=trx_penerimaan_qty();
- /*
- echo "Trx Out :".$trx_out." <br>";
- echo "Trx In :".$trx_in." <br>";
- stop();
- */
- //mengambil jumlah data yang ada di table temporary
- $jumlah_count=$_POST['jumlah'];
- $jumlah_count2=floatval($jumlah_count);
- $no_dokumen=$_POST['no_dokumen'];
- $tanggal_dokumen=$_POST['tanggal_dokumen']; $tanggal_dokumen2 = date("Y-m-d", strtotime($tanggal_dokumen));
- $region_baru=$_POST['region_baru'];
- /*
- echo "region baru";
- echo $region_baru;
- echo "br";
- */
- $area_baru=$_POST['area_baru'];
- $lokasi_baru=$_POST['lokasi_baru'];
- $region_lama=$_POST['region_lama'];
- $area_lama=$_POST['area_lama'];
- //$lokasi_lama=$_POST['lokasi_lama'];
- $keterangan=strtoupper($_POST['keterangan']);
- $id_user=$_POST['id_user'];
- $nama_pengirim=strtoupper($_POST['nama_user']);
- $nama_penerima=strtoupper($_POST['nama_penerima']);
- $jenis_pengadaan=$_POST['jenis_pengadaan'];
- $id_jpengiriman=strtoupper($_POST['jpengiriman']);
- $id_itemmaty=$_POST['id_itemmat'.$i];
- $id_kategori_asety=$_POST['id_kategori_aset'.$i];
- $id_jenisy=$_POST['id_jenis'];
- $qty_in='0';
- $no_party=$_POST['no_part'.$i];
- $id_merky=$_POST['id_merk'.$i];
- $id_uomy=$_POST['id_uom'.$i];
- $qty_outy=$_POST['qty_out'.$i];
- $part_descy=$_POST['part_desc'.$i];
- $lokasi_lamay=$_POST['lokasi_lama'.$i];
- $status_party=$_POST['status_part'.$i];
- if($jtransaksi=='PRWH')
- {
- include 'include/b_pengeluaran_prwh_part.php';
- } else {
- include 'include/b_pengeluaran_non_prwh_part.php';
- }
- }
- ?>
- <?php
- ?>
- <!--<form action="index.php?p=tambah_stok_proses" method="post">-->
- <form method="post" id='customers'>
- <table id='customers' width='100%'>
- <tr>
- <th>No Part</th>
- <th>Lokasi Gudang</th>
- <th>Status Part</th>
- <th>Sisa Stock</th>
- <th>Temp Keluar</th>
- <th>Jumlah Keluar</th>
- <th>Action</th>
- </tr>
- <?php
- include "config/koneksi_dashboard.php";
- ?>
- <td>
- <select name='no_part' id='propinsi2' required>
- <option value="">Pilih Part</option>
- <?php
- //mengambil nama-nama propinsi yang ada di database
- $propinsi_x="SELECT DISTINCT
- mb.no_part AS no_part,
- mb.part_description AS part_description,
- a_merk.`n_merk` AS merk,
- a_uom.`nama_uom` AS uom,
- a_uom.id_uom AS id_uom,
- a_merk.id_merk AS id_merk
- FROM master_barang mb
- LEFT JOIN a_merk a_merk ON a_merk.`id_merk`=mb.`id_merk`
- LEFT JOIN a_uom a_uom ON a_uom.`id_uom`=mb.`id_uom`
- LEFT JOIN qty_master_stock ms ON mb.`no_part`=ms.`no_part`
- WHERE ms.id_area='".$login_area."' and ms.qty_ss > '0' order by mb.part_description ASC";
- /*
- ,
- ms.`qty_ss` AS stock,
- ms.id_lokasi as id_lokasi
- */
- $propinsi2= mysql_query($propinsi_x);
- while($p2=mysql_fetch_array($propinsi2)){
- echo "<option value=\"$p2[no_part]\">$p2[part_description] - $p2[no_part]</option>\n";
- }
- ?>
- </select>
- </td>
- <td><select name="lokasi_lama" id="kota2" required>
- </select></td>
- <td><select name="status_part" id="statuspart" required>
- </select></td>
- <input type='hidden' name='part_description' id="part_description" placeholder='Part Desc' readonly >
- <input type='hidden' name='merk' id="merk" placeholder='Merk' readonly>
- <input type='hidden' name='satuan' id="uom" placeholder='Satuan' readonly>
- <td><input type="text" size='2' name="sisa_stok" id='stock' style="text-transform:uppercase" placeholder='Sisa Stok' readonly></td>
- <td><input type="text" size='2' name="temp" id='temp' style="text-transform:uppercase" placeholder='Stok Keluar' readonly></td>
- <td><input type="number" name="qty_out" style="text-transform:uppercase" min="0" placeholder='Jumlah Keluar' required></td>
- <td><input type="submit" name="tambah" value="Tambah"></td>
- </tr>
- </table>
- <input type='hidden' name="id_user" value='<?php echo $id_user;?>'>
- <input type='hidden' name="region_lama" value='<?php echo $login_region;?>'>
- <input type='hidden' name="area_lama" value='<?php echo $login_area;?>'>
- <input type='hidden' name='id_uom' id="id_uom" placeholder='ID Satuan' readonly>
- <input type='hidden' name='login_area' id="login_area" value='<?php echo $login_area;?>'>
- <input type='hidden' name='id_merk' id="id_merk" placeholder='ID Merk' readonly>
- <input type='hidden' name='id_itemmat' id="id_itemmat" placeholder='id_itemmat' readonly>
- <input type='hidden' name='id_kategori_aset' id="id_kategori_aset" placeholder='id_kategori_aset' readonly>
- <input type='hidden' name='id_jenis' id="id_jenis" placeholder='id_jenis' readonly>
- </form>
- <br>
- <link rel='stylesheet' href='css/new_design.css'>
- <link href="css/style.css" rel="stylesheet" type="text/css" media="screen"/>
- <table id="customers">
- <tr bgcolor="#CCCCCC">
- <th>No</th>
- <th>Lokasi</th>
- <th>No Part</th>
- <th>Part Desc</th>
- <th>Merk</th>
- <th>Jumlah</th>
- <th>Uom</th>
- <th>Status</th>
- <th>Serial</th>
- <th>Action</th>
- </tr>
- <?php
- $keterangan_pengeluaran="pengeluaran_prwh";
- //menampilkan data yang berada di tabel temporary
- $tampil="SELECT
- temp.no_part as no_part,
- temp.part_description as part_description,
- temp.qty as qty,
- temp.username as user,
- uom.nama_uom as satuan,
- a_merk.`n_merk` as merk,
- sts.n_status_part as status_temp,
- t_lokasi.nama_lokasi as nama_lokasi,
- t_lokasi.id_lokasi as nama_lokasi_id,
- temp.id_status_part as status_temp_id,
- mb.id_jenis as id_jenis
- from qty_transaksi_tambah_stock_temp temp
- LEFT JOIN a_uom uom on temp.`id_uom`=uom.`id_uom`
- LEFT JOIN t_lokasi t_lokasi on t_lokasi.id_lokasi=temp.id_lokasi
- LEFT JOIN qty_a_status_part sts on sts.id_status_part=temp.id_status_part
- LEFT JOIN a_merk a_merk on temp.`id_merk`=a_merk.`id_merk`
- LEFT JOIN master_barang mb on mb.no_part=temp.no_part
- where temp.username='".$id_user."' AND temp.trx='".$keterangan_pengeluaran."'";
- //echo $tampil;
- $result_tampil=mysql_query($tampil);
- //menghitung jumlah item yang dikeluarkan
- $jumlah_item="SELECT count(no_part) as jumlah_item from qty_transaksi_tambah_stock_temp where username='".$id_user."' and trx='pengeluaran'";
- $rjumlah_item=mysql_query($jumlah_item);
- while ($item=mysql_fetch_assoc($rjumlah_item))
- {
- $jumlah_item=$item['jumlah_item'];
- };
- //mengakumulasi total part yang dikeluarkan
- $total_item="SELECT sum(qty) as total_item from qty_transaksi_tambah_stock_temp where username='".$id_user."' and trx='pengeluaran'";
- $rtotal_item=mysql_query($total_item);
- while ($t_item=mysql_fetch_assoc($rtotal_item))
- {
- $jtotal_item=$t_item['total_item'];
- };
- $no='1';
- while ($data_tampil=mysql_fetch_array($result_tampil)) {
- $no_part=$data_tampil['no_part'];
- $part_description=$data_tampil['part_description'];
- $qty_out=$data_tampil['qty'];
- $user=$data_tampil['user'];
- $satuan=$data_tampil['satuan'];
- $merk=$data_tampil['merk'];
- $nama_lokasi=$data_tampil['nama_lokasi'];
- $nama_lokasi_id=$data_tampil['nama_lokasi_id'];
- $status_part=$data_tampil['status_temp'];
- $status_part_id=$data_tampil['status_temp_id'];
- $temp_jenis=$data_tampil['id_jenis'];
- echo "<tr>
- <td>".$no."</td>
- <td>".$nama_lokasi."</td>
- <td>".$no_part."</td>
- <td>".$part_description."</td>
- <td>".$merk."</td>
- <td>".number_format($qty_out,0)."</td>
- <td>".$satuan."</td>
- <td>".$status_part."</td>
- ";?>
- <td>
- <button type="button" name="add" id="add<?php echo $no;?>" data-toggle="modal" data-target="#add_data_Modal" data-backdrop="static" class="btn btn-success">Tambah Data</button>
- </div><br>
- <div id="tabel_siswa">
- <div class="table-responsive">
- </div>
- </div>
- </div>
- <!-- Modal Popup untuk Input-->
- <!-- Modal Popup untuk Input-->
- <div id="add_data_Modal" class="modal fade">
- <div class="modal-dialog modal-lg">
- <div class="modal-content">
- <div class="modal-header">
- <button type="button" class="close" data-dismiss="modal">×</button>
- <h4 class="modal-title">Input Serial Number </h4>
- </div>
- <div class="modal-body">
- <form id="defaultForm" method="post" class="form-horizontal" enctype="multipart/form-data">
- <div class="form-group">
- <label class="col-lg-3 control-label">Region</label>
- <div class="col-lg-5">
- <input type="text" class="form-control" name="region" id="region" placeholder="Region" maxlength="30" value="<?php echo $login_region;?>" autocomplete="off" readonly />
- </div>
- </div>
- <div class="form-group">
- <label class="col-lg-3 control-label">Area</label>
- <div class="col-lg-5">
- <input type="text" class="form-control" name="area" id="area" placeholder="Area" maxlength="30" value="<?php echo $login_area;?>" autocomplete="off" readonly />
- </div>
- </div>
- <div class="form-group">
- <label class="col-lg-3 control-label">Lokasi</label>
- <div class="col-lg-5">
- <input type="text" class="form-control" name="lokasi" id="lokasi" placeholder="Lokasi" maxlength="30" value="<?php echo $nama_lokasi_id;?>" autocomplete="off" readonly />
- </div>
- </div>
- <div class="form-group">
- <label class="col-lg-3 control-label">No Part <?php echo $no;?></label>
- <div class="col-lg-5">
- <input type="text" class="form-control" name="no_part" id="no_part" placeholder="part" maxlength="30" value="<?php echo $data_tampil['no_part'];?>" autocomplete="off" readonly />
- </div>
- </div>
- <div class="form-group">
- <label class="col-lg-3 control-label">Part Description</label>
- <div class="col-lg-5">
- <input type="text" class="form-control" name="part_desc" id="part_desc" placeholder="Area" maxlength="30" value="<?php echo $part_description;?>" autocomplete="off" readonly />
- </div>
- </div>
- <div class="form-group">
- <label class="col-lg-3 control-label">Status Fisik</label>
- <div class="col-lg-5">
- <input type="text" class="form-control" name="status_part" id="status_part" placeholder="Area" maxlength="30" value="<?php echo $status_part_id;?>" autocomplete="off" readonly />
- </div>
- </div>
- <div class="form-group">
- <label class="col-lg-3 control-label">Qty</label>
- <div class="col-lg-5">
- <input type="text" class="form-control" name="qty_out" id="qty_out" placeholder="Area" maxlength="30" value="<?php echo $qty_out;?>" autocomplete="off" readonly />
- </div>
- </div>
- <div class="form-group">
- <label class="col-lg-3 control-label">Upload Serial Number</label>
- <div class="col-lg-5">
- <input type="file" class="form-control" name="fileexcel" id="fileexcel" accept=".xls" />
- </div>
- </div>
- <div class="form-group">
- <div class="col-lg-9 col-lg-offset-3">
- <input type="submit" name="submit" class="btn btn-primary" id="insert" value="Simpan">
- </div>
- </div>
- <div class="form-group">
- <input type="hidden" class="form-control" name="id_user" id="id_user" placeholder="Area" maxlength="30" value="<?php echo $id_user;?>" autocomplete="off" readonly />
- </div>
- </form>
- </div>
- <div class="modal-footer">
- <button type="button" class="btn btn-default" data-dismiss="modal">Close</button>
- </div>
- </div>
- </div>
- </div>
- </td>
- <td><a class="hapus" href="index.php?p=b_pengeluaran_stok_delete&no_part=<?php echo $no_part; ?>&username=<?php echo $id_user; ?>&status_part=<?php echo $status_part_id; ?>">Hapus</a></td>
- <?php
- echo "</tr>";
- $no++;
- }
- echo "<tr>
- <td colspan='2'><b>Jumlah Item</b></td>
- <td><b>".$jumlah_item."</b></td>
- <td colspan='1'><b>Total Item</b></td>
- <td></td>
- <td><b>".number_format($jtotal_item,0)."</b></td>
- <td></td>
- <td></td>
- <td></td>
- <td></td>
- </tr>";
- echo "</table>";
- echo "<br>";
- echo "<b>Catatan :</b> <br>Pastikan Pada saat Transaksi Pengeluaran / Penerimaan, List Diatas Kosong, jika masih tersisa, silahkan di hapus terlebih dahulu untuk membersihkan cache</br>
- ";
- echo "<br>";
- //bataas
- ?>
- <br>
- <?php
- $jumlah_data="SELECT no_part from qty_transaksi_tambah_stock_temp where username='$id_user'";
- $jresult=mysql_query($jumlah_data);
- $rjumlah_data=mysql_num_rows($jresult);
- //echo "Jumlah Part Yang di Transaksikan : ";
- //echo $rjumlah_data;
- ?>
- <form method="post">
- <table id="customer" cellpadding="3" cellspacing="0" border='0'>
- </tr>
- <tr>
- <td>Jenis Transaksi</td>
- <td>:</td>
- <td><select name="jtransaksi" required>
- <!--<option value=""></option>-->
- <?php
- include "koneksi_dashboard.php";
- //mysql_connect("localhost", "root", "");
- //mysql_select_db("noncpeall");
- //$sql = mysql_query("SELECT id_jtransaksi,n_jtransaksi FROM b_jenis_transaksi where id_jtransaksi='PNR' order by n_jtransaksi ASC");
- $sql = mysql_query("SELECT id_jtransaksi,n_jtransaksi FROM qty_a_jtransaksi where kategori='OUT' and id_jtransaksi='PRWH' order by n_jtransaksi ASC");
- if(mysql_num_rows($sql) != 0){
- while($data = mysql_fetch_assoc($sql)){
- echo '<option value="'.$data['id_jtransaksi'].'">'.$data['id_jtransaksi'].' - '.$data['n_jtransaksi'].'</option>';
- }
- }
- ?>
- </select></td>
- <?php
- include "config/koneksi_dashboard.php";
- ?>
- </tr>
- <tr>
- <td>No. Dokumen</td>
- <td>:</td>
- <td><input type="hidden" name="no_dokumen" required>
- Auto Generate By System</td>
- </tr>
- <tr>
- <td>Tanggal Dok</td >
- <td>:</td>
- <td><input type="text" name="tanggal_dokumen" id="tanggal" required></td>
- <tr>
- <td>Region Tujuan</td><td>:</td><td><select name="region_baru" id="propinsi" required>
- <option value=""></option>
- <?php
- //mengambil nama-nama propinsi yang ada di database
- $propinsi = mysql_query("SELECT * FROM t_region ORDER BY nama_region");
- while($p=mysql_fetch_array($propinsi)){
- //echo "<option value=\"$p[id_prov]\">$p[nama_prov]</option>\n";
- //echo "<option value=\"$p[nama_prov]\">$p[nama_prov]</option>\n";
- echo "<option value=\"$p[id_region]\">$p[nama_region]</option>\n";
- }
- ?>
- </select>
- </td>
- </tr>
- <tr>
- <td>Area Tujuan</td><td>:</td><td><select name="area_baru" id="kota" required>
- <option value=""></option>
- <?php
- //mengambil nama-nama propinsi yang ada di database
- $kota = mysql_query("SELECT * FROM t_area ORDER BY id_area");
- while($p=mysql_fetch_array($propinsi)){
- //echo "<option value=\"$p[id_kabkot]\">$p[nama_kabkot]</option>\n";
- echo "<option value=\"$p[id_area]\">$p[nama_area]</option>\n";
- }
- ?>
- </select></td>
- </tr>
- <tr>
- <td>Lokasi Tujuan</td>
- <td>:</td>
- <td><select name="lokasi_baru" id="kec" required>
- <option value=""></option>
- </select></td>
- </tr>
- <tr>
- <td>Jenis Pengiriman</td >
- <td>:</td>
- <td><select name="jpengiriman" required>
- <option value="">PILIH PENGIRIMAN</option>
- <?php
- include "config/koneksi_dashboard.php";
- //mysql_connect("localhost", "root", "");
- //mysql_select_db("noncpeall");
- $sql = mysql_query("SELECT id_jpengiriman,UPPER(n_jpengiriman) as n_jpengiriman FROM b_jenis_pengiriman");
- if(mysql_num_rows($sql) != 0){
- while($l = mysql_fetch_assoc($sql)){
- echo '<option value="'.$l['id_jpengiriman'].'">'.$l['id_jpengiriman'].' - '.$l['n_jpengiriman'].'</option>';
- }
- }
- ?>
- </tr>
- <tr><td>Nama Penerima</td><td>:</td><td><input type='text' name='nama_penerima' style="text-transform:uppercase" placeholder='Isi Nama Penerimanya yaa' required >
- </tr>
- <tr>
- <td>Keterangan</td>
- <td>:</td>
- <td><textarea name="keterangan" style="text-transform:uppercase" required></textarea></td>
- </tr>
- <tr>
- <td></td>
- <td></td>
- <td><input type="submit" name="proses" value="Proses"></td>
- </tr>
- <tr>
- <td></td>
- </tr>
- <input type="hidden" name="nama_pengirim" value="<?php echo $id_user;?>">
- <input type="hidden" name="jumlah" value="<?php echo $rjumlah_data;?>" >
- <input type="hidden" name="region_lama" value="<?php echo $login_region;?>" >
- <input type="hidden" name="area_lama" value="<?php echo $login_area;?>" >
- <input type='hidden' name="id_user" value='<?php echo $id_user;?>'>
- <input type='hidden' name="nama_user" value='<?php echo $nama_user;?>'>
- </table>
- <?php
- $tambah_temp="select
- no_part as no_part,
- part_description,
- qty,
- username,
- id_merk,
- id_uom,
- id_lokasi,
- id_status_part,
- id_itemmat,
- id_kategori_aset,
- id_jenis
- from qty_transaksi_tambah_stock_temp
- where username='".$id_user."'";
- //echo $tambah_temp;
- //echo "<br>";
- $r_tambah_temp=mysql_query($tambah_temp);
- for($i=0; $i < $jumlah_count2; $i++)
- //$MultiDimArray = array();
- $no_part = array();
- while($cek = mysql_fetch_array($r_tambah_temp)){
- $no_partx=$cek['no_part'];
- $id_merk=$cek['id_merk'];
- $id_uom=$cek['id_uom'];
- $qty_out=$cek['qty'];
- $part_desc=$cek['part_description'];
- $lokasi_lama=$cek['id_lokasi'];
- $status_part=$cek['id_status_part'];
- $id_itemmat=$cek['id_itemmat'];
- $id_kategori_aset=$cek['id_kategori_aset'];
- $id_jenis=$cek['id_jenis'];
- //echo $no_partx;
- //echo $id_merk;
- //echo $id_uom;
- ?>
- <input type='hidden' name="no_part[]" value='<?php echo $no_partx;?>'>
- <input type='hidden' name="id_merk[]" value='<?php echo $id_merk;?>'>
- <input type='hidden' name="id_uom[]" value='<?php echo $id_uom;?>'>
- <input type='hidden' name="qty_out[]" value='<?php echo $qty_out;?>'>
- <input type='hidden' name="part_desc[]" value='<?php echo $part_desc;?>'>
- <input type='hidden' name="lokasi_lama[]" value='<?php echo $lokasi_lama;?>'>
- <input type='hidden' name="status_part[]" value='<?php echo $status_part;?>'>
- <input type='hidden' name="id_itemmat[]" value='<?php echo $id_itemmat;?>'>
- <input type='hidden' name="id_kategori_aset[]" value='<?php echo $id_kategori_aset;?>'>
- <input type='hidden' name="id_jenis[]" value='<?php echo $id_jenis;?>'>
- <?php
- };
- ?>
- <br>
- <br>
- </form>
- <?php
- /*
- $exe="delete from qty_transaksi_tambah_stock_temp where username='$id_user' or username=''";
- //echo $exe;
- $r_exe=mysql_query($exe);
- echo $exe;
- */
- ?>
- <script type="text/javascript" src="areatransvision/jquery.js"></script>
- <script type="text/javascript">
- var htmlobjek;
- $(document).ready(function(){
- //apabila terjadi event onchange terhadap object <select id=propinsi>
- $("#jtransaksi").change(function(){
- var jtransaksi = $("#jtransaksi").val();
- $.ajax({
- url: "areatransvision/ambilpropinsi.php",
- data: "jtransaksi="+jtransaksi,
- cache: false,
- success: function(msg){
- //jika data sukses diambil dari server kita tampilkan
- //di <select id=kota>
- $("#propinsi").html(msg);
- }
- });
- });
- $("#propinsi").change(function(){
- var propinsi = $("#propinsi").val();
- $.ajax({
- url: "areatransvision/ambilkota.php",
- data: "propinsi="+propinsi,
- cache: false,
- success: function(msg){
- //jika data sukses diambil dari server kita tampilkan
- //di <select id=kota>
- $("#kota").html(msg);
- }
- });
- });
- $("#kota").change(function(){
- var kota = $("#kota").val();
- $.ajax({
- url: "areatransvision/ambilkecamatan.php",
- data: "kota="+kota,
- cache: false,
- success: function(msg){
- $("#kec").html(msg);
- }
- });
- });
- });
- </script>
- <!--<script src="lib/jquery.min.js"></script>-->
- <script src="lib/jquery.min.js"></script>
- <script type="text/javascript">
- var htmlobjek;
- $(document).ready(function(){
- //apabila terjadi event onchange terhadap object <select id=propinsi>
- $("#propinsi2").change(function(){
- var propinsi2 = $("#propinsi2").val();
- var login_area = $("#login_area").val();
- $.ajax({
- url: "areatransvision/cek_lokasi.php",
- data: "propinsi2="+propinsi2+"&login_area="+login_area,
- cache: false,
- success: function(msg){
- //jika data sukses diambil dari server kita tampilkan
- //di <select id=kota>
- $("#kota2").html(msg);
- }
- });
- });
- $("#kota2").change(function(){
- var propinsi2 = $("#propinsi2").val();
- var login_area = $("#login_area").val();
- var kota2 = $("#kota2").val();
- $.ajax({
- url: "areatransvision/cek_status_part.php",
- data: "no_part="+propinsi2+"&id_area="+login_area+"&kota2="+kota2,
- cache: false,
- success: function(msg){
- //jika data sukses diambil dari server kita tampilkan
- //di <select id=kota>
- $("#statuspart").html(msg);
- }
- });
- });
- $("#statuspart").change(function(){
- var propinsi2 = $("#propinsi2").val();
- var login_area = $("#login_area").val();
- var id_lokasi = $("#kota2").val();
- var statuspart = $("#statuspart").val();
- $.ajax({
- url: 'include/ajax_master_barang.php',
- data:"propinsi2="+propinsi2+"&login_area="+login_area+"&kota2="+id_lokasi+"&statuspart="+statuspart,
- //+"&id_lokasi="+id_lokasi
- }).success(function (data_part) {
- var json = data_part,
- obj = JSON.parse(json);
- $('#part_description').val(obj.part_description);
- $('#merk').val(obj.merk);
- $('#uom').val(obj.uom);
- $('#stock').val(obj.stock);
- $('#id_merk').val(obj.id_merk);
- $('#id_uom').val(obj.id_uom);
- $('#id_lokasi').val(obj.id_lokasi);
- $('#temp').val(obj.temp);
- $('#statuspart').val(obj.statuspart);
- $('#id_itemmat').val(obj.id_itemmat);
- $('#id_kategori_aset').val(obj.id_kategori_aset);
- $('#id_jenis').val(obj.id_jenis);
- });
- })
- })
- </script>
- <!-- Note Dewa : Javascript untuk meload otomatis kategori pada saat pemilihan item material, perubahan tgl 9 juni 2017 -->
- <script src="js/jquery.min.js"></script>
- <script type="text/javascript">
- function isi_otomatis_kategori(){
- var item_material= $("#item_material").val();
- //$("#n_kategori_aset").val('xx');
- $.ajax({
- url: 'function/function_kategori.php',
- data:"item_material="+item_material ,
- }).success(function (data) {
- //console.log(data);
- var json = data,
- obj = JSON.parse(json);
- $('#id_kategori_aset').val(obj.id_kategori_aset);
- $('#n_kategori_aset').val(obj.n_kategori_aset);
- $('#id_itemmat').val(obj.id_itemmat);
- });
- }
- </script>
- <!-- Note Dewa : JawaScript untuk menampilkan tanggal secara dinamis -->
- <script src="tanggal/jquery-ui-1.11.4/external/jquery/jquery.js"></script>
- <script src="tanggal/jquery-ui-1.11.4/jquery-ui.js"></script>
- <script src="tanggal/jquery-ui-1.11.4/jquery-ui.min.js"></script>
- <link rel="stylesheet" href="tanggal/jquery-ui-1.11.4/jquery-ui.theme.css">
- <script>
- var $jnoc=jQuery.noConflict();
- $jnoc(document).ready(function(){
- $jnoc("#tanggal").datepicker({
- })
- })
- </script>
- <!-- Note Dewa : JawaScript untuk menampilkan tanggal secara dinamis -->
- <script src="tanggal/jquery-ui-1.11.4/external/jquery/jquery.js"></script>
- <script src="tanggal/jquery-ui-1.11.4/jquery-ui.js"></script>
- <script src="tanggal/jquery-ui-1.11.4/jquery-ui.min.js"></script>
- <link rel="stylesheet" href="tanggal/jquery-ui-1.11.4/jquery-ui.theme.css">
- <script>
- var $jnoc=jQuery.noConflict();
- $jnoc(document).ready(function(){
- $jnoc("#tanggal_pengadaan").datepicker({
- })
- })
- </script>
- <!-- batas -->
- <script src="lib/jquery.min.js"></script>
- <script type="text/javascript">
- function cek_database(){
- var no_part = $("#no_part").val();
- var login_area = $("#login_area").val();
- //var id_lokasi = $("#id_lokasi").val();
- $.ajax({
- url: 'include/ajax_master_barang.php',
- data:"no_part="+no_part+"&login_area="+login_area,
- //+"&id_lokasi="+id_lokasi
- }).success(function (data) {
- var json = data,
- obj = JSON.parse(json);
- $('#part_description').val(obj.part_description);
- $('#merk').val(obj.merk);
- $('#materialgroup').val(obj.materialgroup);
- $('#uom').val(obj.uom);
- $('#stock').val(obj.stock);
- $('#id_merk').val(obj.id_merk);
- $('#id_uom').val(obj.id_uom);
- $('#temp').val(obj.temp);
- $('#id_lokasi').val(obj.id_lokasi);
- /*
- var $jenis_kelamin = $('input:radio[name=jenis_kelamin]');
- if(obj.jenis_kelamin == 'laki-laki'){
- $jenis_kelamin.filter('[value=laki-laki]').prop('checked', true);
- }else{
- $jenis_kelamin.filter('[value=perempuan]').prop('checked', true);
- }
- */
- });
- }
- </script>
- <!-- Bootstrap core JavaScript-->
- <script src="lib/jquery.min.js"></script>
- <script src="dist/js/bootstrap.js"></script>
- <!-- validator -->
- <script type="text/javascript" src="dist/js/bootstrapValidator.js"></script>
- <script>
- /*insert form*/
- $(document).ready(function () {
- $('#defaultForm')
- .bootstrapValidator({
- fields: {
- foto: {
- validators: {
- notEmpty: {
- message: 'Gambar Tidak Boleh Kosong !'
- },
- file: {
- extension: 'png,jpg,jpeg',
- type: 'image/png,image/jpg,image/jpeg',
- maxSize: 2 * 1024 * 1024,
- message: 'Ekstensi yang diperbolehkan hanya .jpg,.png dan Maksimal 2MB'
- }
- }
- },
- nama: {
- validators: {
- notEmpty: {
- message: 'Nama Tidak Boleh Kosong !'
- },
- }
- },
- nisn: {
- validators: {
- notEmpty: {
- message: 'NISN Tidak Boleh Kosong !'
- },
- digits: {
- message: 'Gunakan Angka !'
- }
- }
- },
- jk: {
- validators: {
- notEmpty: {
- message: 'Pilih Gender !'
- },
- }
- },
- }
- })
- .on('success.form.bv', function (e) {
- // Prevent form submission
- e.preventDefault();
- $.ajax({
- url: "include/b_insert_serial.php",
- method: "POST",
- data: new FormData(this),
- contentType: false,
- cache: false,
- processData: false,
- beforeSend: function () {
- $('#insert').val("sedang menyimpan...");
- },
- success: function (data) {
- $('#defaultForm')[0].reset();
- $('#defaultForm').bootstrapValidator('resetForm', true);
- $('#add_data_Modal').modal('hide');
- $('#tabel_siswa').html(data);
- $('#insert').val("Simpan Data");
- setTimeout(function () {
- $('#success_message').fadeOut("Slow");
- }, 2000);
- }
- });
- });
- });
- /*edit data*/
- $(document).ready(function () {
- $(document).on('click', '.edit_data', function () {
- var id = $(this).prop("id");
- $.ajax({
- url: "fetch.php",
- method: "POST",
- data: { id: id },
- dataType: "json",
- success: function (data) {
- $('#namas').val(data.nama_siswa);
- $('#id').val(data.id_siswa);
- $('#nisns').val(data.nisn);
- $('#lama').val(data.foto_siswa);
- if (data.gender_siswa == 'L') {
- $('input:radio[name=jks][value="L"]').prop('checked', true)
- } else {
- $('input:radio[name=jks][value="P"]').prop('checked', true)
- }
- $('#update').val("Simpan Perubahan");
- $('#edit_data_Modal').modal('show');
- }
- });
- });
- });
- /*edit form*/
- $(document).ready(function () {
- $('#editForm')
- .bootstrapValidator({
- fields: {
- foto: {
- validators: {
- file: {
- extension: 'png,jpg,jpeg',
- type: 'image/png,image/jpg,image/jpeg',
- maxSize: 2 * 1024 * 1024,
- message: 'Ekstensi yang diperbolehkan hanya .jpg dan .png, dan Maksimal 2MB'
- }
- }
- },
- namas: {
- validators: {
- notEmpty: {
- message: 'Nama Tidak Boleh Kosong !'
- },
- }
- },
- nisns: {
- validators: {
- notEmpty: {
- message: 'NISN Tidak Boleh Kosong !'
- },
- digits: {
- message: 'Gunakan Angka !'
- }
- }
- },
- jks: {
- validators: {
- notEmpty: {
- message: 'Pilih Gender !'
- },
- }
- },
- }
- })
- .on('success.form.bv', function (e) {
- // Prevent form submission
- e.preventDefault();
- $.ajax({
- url: "update.php",
- method: "POST",
- data: new FormData(this),
- contentType: false,
- cache: false,
- processData: false,
- beforeSend: function () {
- $('#update').val("sedang mengupdate...");
- },
- success: function (data) {
- $('#editForm')[0].reset();
- $('#editForm').bootstrapValidator('resetForm', true);
- $('#edit_data_Modal').modal('hide');
- $('#tabel_siswa').html(data);
- $('#update').val("Simpan Perubahan");
- setTimeout(function () {
- $('#success_message').fadeOut("Slow");
- }, 2000);
- }
- });
- });
- });
- </script>