Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php include '../../function/function.php'; ?>
- <html>
- <head>
- <title>Transaksi Pembelian CV. Anugrah</title>
- <link rel="stylesheet" href="../../bootstrap/bootstrap.min.css">
- <link rel="stylesheet" href="../../jquery/jquery-ui.css">
- <link rel="stylesheet" href="../../fontawesome/css/all.css">
- <script src="../../jquery/jquery.min.js"></script>
- <script src="../../jquery/jquery-ui.js"></script>
- </head>
- <body>
- <div class="container">
- <br>
- <h3 align="center">Data Transaksi Pembelian CV. Anugrah Jaya</h3>
- <br>
- <div align="right" style="margin-bottom:5px">
- <button type="button" name="add" id="add" class="btn btn-success btn-xs">Tambah Data</button>
- </div>
- <div class="table-responsive" id="user_data">
- </div>
- </div>
- <div id="user_dialog" title="Add Data">
- <form method="POST" id="user_form">
- <div class="form-group">
- <label>Kode Transaksi</label>
- <input type="text" name="kdtransaksi" id="kdtransaksi" class="form-control">
- <span id="error_kdtransaksi" class="text-danger"></span>
- </div>
- <div class="form-group">
- <label>Tanggal</label>
- <input type="text" name="tanggal" id="tanggal" class="form-control">
- <span id="error_tanggal" class="text-danger"></span>
- </div>
- <div class="form-group">
- <label>Nama Supplier</label>
- <select name="namasupp" id="namasupp" class="form-control">
- <option value="">- Pilih Supplier -</option>
- <?php
- include "../../config/koneksi.php";
- $query="select*from supplier";
- $statement=$dbh->prepare($query);
- $statement->execute();
- $result=$statement->fetchAll();
- foreach($result as $row){
- ?>
- <option value="<?php echo $row['idsupp'];?>"><?php echo $row['namasupp'];?></option>
- <?php } ?>
- </select>
- <span id="error_namasupp" class="text-danger"></span>
- </div>
- <div class="form-group">
- <label>Jenis Pembelian</label>
- <select name="keterangan" id="keterangan" class="form-control">
- <option value="">- Pilih Bahan -</option>
- <option value="Pembelian Bahan Baku">Bahan Baku</option>
- <option value="Pembelian Bahan Penolong">Bahan Penolong</option>
- </select>
- <span id="error_total" class="text-danger"></span>
- </div>
- <div class="form-group">
- <label>Rincian</label>
- <table class="table table-striped table-bordered" id="rowTable">
- <tr>
- <th>Kode Barang</th>
- <th>Unit</th>
- <th>Harga Satuan</th>
- <th>Total Harga</th>
- <th> </th>
- </tr>
- <tr>
- <td width="10px">
- <select name="idbarang[]" id="idbarang-0">
- <option value="">- Pilih Barang -</option>
- <?php
- $statement=$dbh->prepare("select*from barang");
- $statement->execute();
- $result=$statement->fetchAll();
- foreach($result as $row){
- $idbarang=$row['idbarang'];
- $kdbarang=$row['kdbarang'];
- $namabarang=$row['namabarang'];
- }
- ?>
- <option value="<?php echo $idbarang;?>"><?php echo $kdbarang;?> - <?php echo $namabarang;?></option>
- </select>
- </td>
- <td width="10px">
- <input type="text" name="unit[]" id="unit-0" class="hitung" size="3px">
- </td>
- <td width="10px">
- <input type="text" name="hargasatuan[]" id="hargasatuan-0" class="hitung" size="10px">
- </td>
- <td width="10px">
- <input type="text" name="totalharga[]" id="totalharga-0" class="totalharga" size="10px" readonly>
- </td>
- <td width="2px">
- <button type="button" id="addRow">+</button>
- </td>
- </tr>
- </table>
- <span id="error_total" class="text-danger"></span>
- </div>
- <div class="form-group">
- <label>Sub Total</label>
- <input type="text" name="alltotal" id="subtotal" class="form-control" class="total" readonly>
- <span id="error_subtotal" class="text-danger"></span>
- </div>
- <div class="form-group">
- <label>PPN 10%</label>
- <input type="text" name="ppn" id="ppn" class="form-control" readonly>
- <span id="error_ppn" class="text-danger"></span>
- </div>
- <div class="form-group">
- <label>Total</label>
- <input type="text" name="total" id="total" class="form-control" readonly>
- <span id="error_total" class="text-danger"></span>
- </div>
- <div class="form-group">
- <label>Bayar</label>
- <input type="text" name="bayar" id="bayar" class="form-control">
- <span id="error_bayar" class="text-danger"></span>
- </div>
- <div class="form-group">
- <input type="hidden" name="action" id="action" value="insert">
- <input type="hidden" name="hidden_id" id="hidden_id">
- <input type="submit" name="form_action" id="form_action" class="btn btn-info" value="Insert">
- </div>
- </form>
- </div>
- <div id="action_alert" title="Action">
- </div>
- <div id="delete_confirmation" title="Confirmation">
- <p>Are you sure to delete this data?</p>
- </div>
- </body>
- </html>
- <script>
- $(document).ready(function(){
- $('#tanggal').datepicker({});
- load_data();
- function load_data(){
- $.ajax({
- url:"fetch.php",
- method:"POST",
- success:function(data){
- $('#user_data').html(data);
- }
- });
- }
- $('#user_dialog').dialog({
- autoOpen:false,
- width:650
- });
- $('#addRow').click(function(){
- var i = $('input').size() + 1, element='<tr>';
- element+='<td width="10px"><select name="idbarang[]" id="idbarang-'+i+' " >';
- element+='<option value="">- Pilih Barang -</option>';
- element+='<option value="<?php echo $idbarang;?>"><?php echo $kdbarang;?> - <?php echo $namabarang;?></option>';
- element+='</select></td>';
- element+='<td><input type="text" name="unit[]" id="unit-'+i+' " class="hitung" size="3px"></td>';
- element+='<td><input type="text" name="hargasatuan[]" id="hargasatuan-'+i+' " class="hitung" size="10px"></td>';
- element+='<td><input type="text" name="totalharga[]" id="totalharga-'+i+' " class="totalharga" size="10px" readonly></td>';
- element+='<td><button type="button" id="addRow">+</button></td>';
- element+='</tr>';
- $('#rowTable').append(element);
- i++;
- return false;
- });
- /*
- $('#addRow').click(function(){
- var tableID="rowTable";
- var table=document.getElementById(tableID);
- var rowCount=table.rows.length;
- var row=table.insertRow(rowCount);
- var i=$('input').size()+1,
- element1="<tr>"+
- "<td width='10px'><select name='idbarang[]' id='idbarang-' "+i+" >"+
- "<option value=''>- Pilih Barang -</option>"+
- "<option value='<?php echo $idbarang;?>'><?php echo $kdbarang;?> - <?php echo $namabarang;?></option>"+
- "</select></td>"+
- "<td><input type='text' name='unit[]' id='unit-' "+i+" size='3px'></td>"+
- "<td><input type='text' name='hargasatuan[]' id='hargasatuan-' "+i+" size='10px'></td>"+
- "<td><input type='text' name='totalharga[]' id='totalharga-' "+i+" size='10px'></td>"+
- "<td><button type='button'id='addRow'>+</button></td>"+
- "</tr>";
- row.innerHTML=element1;
- i++;
- return false;
- });
- */
- $('.hitung').focus(function(){
- var aydi=$(this).attr('id'), berhitung=aydi.split('-');
- $(this).keydown(function(){
- setTimeout(function(){
- var unit=($('#unit-'+berhitung[1]).val()!='' ? $('#unit-'+berhitung[1]).val():0), hargasatuan=($('#hargasatuan-'+berhitung[1]).val()!='' ? $('#hargasatuan-'+berhitung[1]).val():0), subtotal=parseInt(unit)*parseInt(hargasatuan);
- if(!isNaN(subtotal)){
- $('#totalharga-'+berhitung[1]).val(subtotal);
- var alltotal=0;
- $('.totalharga').each(function(){
- alltotal += parseFloat($(this).val());
- });
- $('#subtotal').val(alltotal);
- $('#ppn').val(alltotal*0.1);
- $('#total').val(alltotal+(alltotal*0.1));
- }
- }, 50);
- });
- });
- $('#add').click(function(){
- $('#user_dialog').attr('title','Add Data');
- $('#action').val('insert');
- $('#form_action').val('Insert');
- $('#user_form')[0].reset();
- $('#form_action').attr('disabled',false);
- $('#user_dialog').dialog('open');
- });
- $('#user_form').on('submit',function(event){
- event.preventDefault();
- var error_kdtransaksi='';
- var error_tanggal='';
- var error_namasupp='';
- var error_total='';
- var error_bayar='';
- if($('#kdtransaksi').val()==''){
- error_kdtransaksi='Nomor Transaksi harap diisi...';
- $('#error_kdtransaksi').text(error_kdtransaksi);
- $('#kdtransaksi').css('border-color','#cc0000');
- }else{
- error_kdtransaksi='';
- $('#error_kdtransaksi').text(error_kdtransaksi);
- $('#kdtransaksi').css('border-color','');
- }
- if($('#tanggal').val()==''){
- error_tanggal='Tanggal harap diisi...';
- $('#error_tanggal').text(error_tanggal);
- $('#tanggal').css('border-color','#cc0000');
- }else{
- error_tanggal='';
- $('#error_tanggal').text(error_tanggal);
- $('#tanggal').css('border-color','');
- }
- if($('#namasupp').val()==''){
- error_namasupp="Supplier harap diisi...";
- $('#error_namasupp').text(error_namasupp);
- $('#namasupp').css('border-color','#cc0000');
- }else{
- error_namasupp='';
- $('#error_namasupp').text(error_namasupp);
- $('#namasupp').css('border-color','');
- }
- if($('#total').val()==''){
- error_total="Total harap diisi...";
- $('#error_total').text(error_total);
- $('#total').css('border-color','#cc0000');
- }else{
- error_total='';
- $('#error_total').text(error_total);
- $('#total').css('border-color','');
- }
- if($('#bayar').val()==''){
- error_bayar="Kolom Bayar tidak boleh kosong...";
- $('#error_bayar').text(error_bayar);
- $('#bayar').css('border-color','#cc0000');
- }else{
- error_bayar='';
- $('#error_bayar').text(error_bayar);
- $('#bayar').css('border-color','');
- }
- if(error_kdtransaksi!=''||error_tanggal!=''||error_namasupp!=''||error_total!=''||error_bayar!=''){
- return false;
- }else{
- $('#form_action').attr('disabled','disabled');
- var form_data=$(this).serialize();
- $.ajax({
- url:"action.php",
- method:"POST",
- data:form_data,
- success:function(data)
- {
- $('#user_dialog').dialog('close');
- $('#action_alert').html(data);
- $('#action_alert').dialog('open');
- load_data();
- $('#form_action').attr('disabled', false);
- }
- });
- }
- });
- $('#action_alert').dialog({
- autoOpen:false
- });
- $(document).on('click','.edit',function(){
- var id=$(this).attr('id');
- var action='fetch_single';
- $.ajax({
- url:"action.php",
- method:"POST",
- data:{id:id,action:action},
- dataType:"json",
- success:function(data){
- $('#kdtransaksi').val(data.kdtransaksi);
- $('#tanggal').val(data.tanggal);
- $('#namasupp').val(data.namasupp);
- $('#total').val(data.total);
- $('#bayar').val(data.bayar);
- $('#user_dialog').attr('title','Edit Data');
- $('#action').val('update');
- $('#hidden_id').val(id);
- $('#form_action').val('Update');
- $('#user_dialog').dialog('open');
- }
- });
- });
- $('#delete_confirmation').dialog({
- autoOpen:false,
- modal:true,
- buttons:{
- Ok : function(){
- var id = $(this).data('id');
- var action = 'delete';
- $.ajax({
- url:"action.php",
- method:"POST",
- data:{id:id, action:action},
- success:function(data)
- {
- $('#delete_confirmation').dialog('close');
- $('#action_alert').html(data);
- $('#action_alert').dialog('open');
- load_data();
- }
- });
- },
- Cancel : function(){
- $(this).dialog('close');
- }
- }
- });
- $(document).on('click','.delete',function(){
- var id=$(this).attr('id');
- $('#delete_confirmation').data('id',id).dialog('open');
- });
- });
- </script>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement