Server : Apache/2.4.18 (Ubuntu) System : Linux canvaswebdesign 3.13.0-71-generic #114-Ubuntu SMP Tue Dec 1 02:34:22 UTC 2015 x86_64 User : oppastar ( 1041) PHP Version : 7.0.33-0ubuntu0.16.04.15 Disable Function : pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority, Directory : /var/www/rabbithabit.com/public_html/application/views/admin/pembelian_faktur/ |
Upload File : |
<div class="row"> <div class="col-sm-12"> <p> <a href="<?= base_url('admin/pembelian/faktur'); ?>"> <i class="fa fa-arrow-left" aria-hidden="true"></i> Kembali ke daftar Faktur </a> </p><br> <h2> No. Faktur : <?php if(isset($current_faktur)): ?> <?= $transaction_faktur->no_faktur; ?> <?php endif; ?> </h2> <?= $this->session->flashdata('success'); //to display success message ?> <?= $this->session->flashdata('result'); //to display result message ?> </div><!-- end class="col-sm-12" --> </div> <!-- end row --> <?= form_open_multipart(); ?> <div class="row"> <div class="col-sm-12" style="text-align: center;"> <p style="border: 1px solid;padding: 5px;">Supplier</p> </div> <div class="col-sm-4"> <p><b>No.TTB</b></p> <?php if(isset($current_faktur)): ?> <input class="form-control" type="email" value="<?= $transaction_receiving->no_ttb; ?>" style="padding: 5px;width: 100%;" disabled> <?php else: ?> <select class="form-control select_transaction_receiving" name="id_transaction_receiving" required> <option value selected disabled readonly>Pilih No.TTB ... </option> <?php foreach ($no_ttb as $item_no_ttb):?> <!-- cek faktur paid and unpaid--> <?php $cek_unpaid = $this->db->select('id')->from('transaction_faktur')->where('status_faktur','12')->where('transaction_receiving_id',$item_no_ttb->id)->get()->row(); if($cek_unpaid == null): ?> <?php $cek_paid = $this->db->select('id')->from('transaction_faktur')->where('status_faktur','13')->where('transaction_receiving_id',$item_no_ttb->id)->get()->row(); if($cek_paid == null): ?> <option value="<?= $item_no_ttb->id; ?>"><?= $item_no_ttb->no_ttb; ?></option> <?php endif; ?> <?php endif; ?> <!-- cek faktur paid and unpaid--> <?php endforeach; ?> </select> <?= form_error('id_transaction_receiving'); ?> <?php endif; ?> <br> <p><b>No. Pemesanan</b></p> <?php if(isset($current_faktur)): ?> <input class="form-control" type="email" value="<?= $transaction->no_transaksi; ?>" style="padding: 5px;width: 100%;" disabled> <?php else: ?> <input class="form-control" type="text" id="no_po" disabled> <?php endif; ?> <br> <p><b>Nama Supplier</b></p> <?php if(isset($current_faktur)): ?> <input class="form-control" type="email" value="<?= $supplier->supplier_name; ?>" style="padding: 5px;width: 100%;" disabled> <?php else: ?> <input class="form-control" type="text" id="nama_supplier" disabled> <?php endif; ?> <br> <p><b>Alamat</b></p> <div style="border: 1px solid black;padding: 20px 10px;"> <?php if(isset($current_faktur)): ?> <p style="margin-bottom: 0px;"><?= $supplier->supplier_address; ?></p> <?php else: ?> <p id="supplier_address" style="margin-bottom: 0px;"></p> <?php endif; ?> </div> </div> <div class="col-sm-4"> <p><b>E-mail</b></p> <?php if(isset($current_faktur)): ?> <input class="form-control" type="email" value="<?= $supplier->supplier_email; ?>" style="padding: 5px;width: 100%;" disabled> <?php else: ?> <input class="form-control" type="email" id="supplier_email" style="padding: 5px;width: 100%;" disabled> <?php endif; ?> <br> <p><b>Tgl. Request</b></p> <?php if(isset($current_faktur)): ?> <input class="form-control" type="text" value="<?= $transaction->tgl_transaksi; ?>" style="padding: 5px;width: 100%;" disabled> <?php else: ?> <input class="form-control" type="text" id="tgl_transaksi" disabled style="padding: 5px;width: 100%;"> <?php endif; ?> <br> <p><b>Tgl. Faktur</b></p> <?php if(isset($current_faktur)): ?> <input class="form-control" type="text" value="<?= $transaction_faktur->tgl_faktur; ?>" style="padding: 5px;width: 100%;" disabled> <?php else: ?> <input class="form-control" type="text" disabled style="padding: 5px;width: 100%;"> <?php endif; ?> <div style="padding-top: 20px;display: none;"> <p><b>No. Referensi Supplier</b></p> <?php if(isset($current_transaction_receiving)): ?> <input class="form-control" type="text" value="<?= $transaction->no_referensi; ?>" disabled style="padding: 5px;"> <?php else: ?> <input class="form-control" type="text" id="no_referensi" disabled style="padding: 5px;"> <?php endif; ?> </div> </div> <div class="col-sm-4"> <p><b>Syarat Pembayaran</b></p> <?php if(isset($current_faktur)): ?> <input class="form-control" type="text" value="<?= $syarat_pembayaran_name; ?>" style="padding: 5px;width: 100%;" disabled> <?php else: ?> <input class="form-control" type="text" id="syarat_pembayaran" disabled style="padding: 5px;"> <?php endif; ?> <br> <p><b>Tgl. Jatuh Tempo</b></p> <?php if(isset($current_faktur)): ?> <input class="form-control" type="text" value="<?= $transaction->tgl_jth_tempo; ?>" style="padding: 5px;width: 100%;" disabled> <?php else: ?> <input class="form-control" type="text" id="tgl_jth_tempo" placeholder="yyyy-mm-dd" disabled style="padding: 5px;"> <?php endif; ?> <br> <p><b>Gudang</b></p> <?php if(isset($current_faktur)): ?> <input class="form-control" type="text" value="<?= $warehouse; ?>" style="padding: 5px;width: 100%;" disabled> <?php else: ?> <input class="form-control" type="text" id="warehouse" disabled style="padding: 5px;"> <?php endif; ?> </div> </div> <div class="row" > <div class="col-sm-12"> <div class="table-responsive"> <table class="table table-striped" style="margin-bottom: 0px;"> <thead> <tr> <th>Produk</th> <th>SatuanBeli to SatuanJual</th> <th>QuantitasBeli</th> <th>QuantitasJual</th> <th>Harga Satuan</th> <th>Harga Beli Akhir</th> <th>Diskon</th> <th>PPN</th> <th>Jumlah</th> <th>Last90D</th> <th>Stok Skrg</th> </tr> </thead> <tbody id="transaction_detail"> <?php if(isset($current_faktur)): ?> <?php $a=0;foreach ($transaction_detail as $item_transaction_detail):?> <tr> <!-- Produk --> <td> <?php $product_name = $this->db->select('title')->from('products')->where('id_products',$item_transaction_detail->id_product)->get()->row()->title; echo ucfirst($product_name); ?> </td> <!-- SatuanBeli to SatuanJual --> <td> <select class="form-control" disabled> <option readonly selected>Pilih Conversi</option> <?php $konversi=$this->db->query("select id_product,satuan_beli_id,satuan_jual_id from `transaction_detail` where id_transaction=".$transaction->id_transaction." and id_product=".$item_transaction_detail->id_product." union select product_id,satuan_beli_id,satuan_jual_id from unit_convertion where product_id=".$item_transaction_detail->id_product)->result(); foreach ($konversi as $item): $satuan_beli = $this->db->select("*")->from("conversion")->where("id_conversion",$item->satuan_beli_id)->get()->row()->conversion; $satuan_jual = $this->db->select("*")->from("conversion")->where("id_conversion",$item->satuan_jual_id)->get()->row()->conversion; ?><?php if(($item->satuan_beli_id == $item_transaction_detail->satuan_beli_id) && ($item->satuan_jual_id == $item_transaction_detail->satuan_jual_id)) : ?> <option value="<?= ($item->satuan_beli_id).'-'.($item->satuan_jual_id)?>" selected><?= ucfirst($satuan_beli).' -to- '.ucfirst($satuan_jual); ?></option> <?php else: ?> <option value="<?= ($item->satuan_beli_id).'-'.($item->satuan_jual_id)?>"><?= ucfirst($satuan_beli).' -to- '.ucfirst($satuan_jual); ?></option> <?php endif; ?> <?php endforeach; ?> </select> </td> <!-- QuantitasBeli --> <td> <input type="text" class="form-control" value="<?= $transaction_receiving_detail[$a]->qty_receiving; ?>" required readonly style="width: 90px;text-align: center;padding: 5px;"> </td> <!-- QuantitasJual --> <td> <?php $konversi =$item_transaction_detail->konversi; $convertion_value = $konversi * $transaction_receiving_detail[$a]->qty_receiving; ?> <input class="form-control" type="number" readonly value="<?= $convertion_value; ?>" style="width: 90px;text-align: center;padding: 5px;"> </td> <!-- Harga Satuan --> <td> <div class="input-group"> <div class="input-group-addon"> <span class="input-group-text">Rp.</span> </div> <input type="text" class="form-control" required readonly value="<?= number_format($item_transaction_detail->harga_satuan,2,',','.'); ?>" style="width: 95px;text-align: center;padding: 5px;"> </div> </td> <!-- Harga Beli Akhir --> <td> <div class="input-group"> <div class="input-group-addon"> <span class="input-group-text">Rp.</span> </div> <input class="form-control" type="text" value="0,00" readonly style="width: 110px;padding: 5px;"> </div> </td> <!-- Diskon --> <td> <div class="input-group"> <input class="form-control" type="number" readonly required value="<?= $item_transaction_detail->diskon_satuan; ?>" style="width: 50px;text-align: center;padding: 5px;"> <div class="input-group-addon"> <span class="input-group-text">%</span> </div> </div> </td> <!-- PPN --> <td> <?php if($item_transaction_detail->ppn_satuan == 0):?> <input type="hidden" value="0"> <?php elseif($item_transaction_detail->ppn_satuan == 10): ?> <input type="hidden" value="10"> <?php endif; ?> <select class="form-control" disabled style="width: 70px;display: inline;"> <?php if($item_transaction_detail->ppn_satuan == 0):?> <option value="0" selected>No</option> <?php elseif($item_transaction_detail->ppn_satuan == 10): ?> <option value="10" selected>Yes</option> <?php endif; ?> </select> </td> <!-- Jumlah --> <td> <?php $faktur_hs = ($item_transaction_detail->harga_satuan * $transaction_receiving_detail[$a]->qty_receiving); ?> <div class="input-group"> <div class="input-group-addon"> <span class="input-group-text">Rp.</span> </div> <input type="text" class="form-control" readonly value="<?= number_format($faktur_hs,2,',','.'); ?>" style="width:84px;padding: 5px;display: inline;"> </div> </td> <!-- Last90D --> <td> <input type="text" class="form-control" value="0" readonly style="width:50px;text-align: center;padding: 5px;"> </td> <!-- StockSkrg --> <td> <?php error_reporting(0); $product_stock = 0; $warehouse_stock = $this->db->select('stock')->from('stock')->where('id_product',$item_transaction_detail->id_product)->where('warehouse_id',$transaction->warehouse_id)->get()->row()->stock; if($warehouse_stock != null){ $product_stock = $warehouse_stock; } else{ $product_stock = $product_stock; } ?> <input type="text" class="form-control" value="<?= $product_stock; ?>" readonly style="width:50px;text-align: center;padding: 5px;"> </td> </tr> <?php $a++;endforeach; ?> <?php else: ?> <tr> <td colspan="11" style="text-align: center;"> Pilih No. TTB Terlebih Dahulu </td> </tr> <?php endif; ?> </tbody> </table> </div><!-- end class responsive--> </div><!-- end class="col-sm-12" --> </div> <!-- end row --> <div class="row"> <div class="col-sm-4"> <p style="font-size: 20px;"><b>Catatan :</b></p> <div style="border: 1px solid black;padding: 20px 10px;"> <?php if(isset($current_faktur)): ?> <p style="margin-bottom: 0px;" ><?= $transaction->transaction_message; ?></p> <?php else: ?> <p style="margin-bottom: 0px;" id="transaction_message"></p> <?php endif; ?> </div> </div> <div class="col-sm-4"> <p style="font-size: 20px;"><b>Lampiran :</b></p> <?php if(isset($current_faktur)): ?> <div class="form-group" id="transaction_file"> <a href="<?= base_url('uploads/lampiran/').$transaction->transaction_file;?>" target="_blank"><?= $transaction->transaction_file;?></a> </div> <?php else: ?> <div class="form-group" id="transaction_file"></div> <?php endif; ?> </div> <div class="col-sm-4"> <div class="row"> <div class="col-sm-6"> SubTotal </div> <div class="col-sm-6"> Rp. <?php if(isset($current_faktur)): ?> <input type="text" class="form-control" disabled value="<?= number_format($transaction_faktur->sub_total,2,',','.'); ?>" style="width: 139px;display: inline;"> <?php else: ?> <input type="text" class="form-control" id="sub_total" name="sub_total" readonly style="width: 139px;display: inline;"> <?php endif; ?> </div> </div> <div class="row"> <div class="col-sm-6"> Diskon Per Baris </div> <div class="col-sm-6"> Rp. <?php if(isset($current_faktur)): ?> <input type="text" class="form-control" disabled value="<?= number_format($transaction_faktur->diskon_per_baris,2,',','.'); ?>" style="width: 139px;display: inline;"> <?php else: ?> <input type="text" class="form-control" id="diskon_per_baris" name="diskon_per_baris" readonly style="width: 139px;display: inline;"> <?php endif; ?> </div> </div> <div class="row"> <div class="col-sm-6"> PPN </div> <div class="col-sm-6"> Rp. <?php if(isset($current_faktur)): ?> <input type="text" class="form-control" disabled value="<?= number_format($transaction_faktur->ppn_result,2,',','.'); ?>" style="width: 139px;display: inline;"> <?php else: ?> <input class="form-control" id="ppn_value" type="text" name="ppn_value" required readonly style="width: 139px;display: inline;"> <?php endif; ?> </div> </div> <div class="row"> <div class="col-sm-6"> Total </div> <div class="col-sm-6"> Rp. <?php if(isset($current_faktur)): ?> <input type="text" class="form-control" disabled value="<?= number_format($transaction_faktur->total,2,',','.'); ?>" style="width: 139px;display: inline;"> <?php else: ?> <input class="form-control" id="total_akhir" name="total" type="text" required readonly style="width: 139px;display: inline;"> <?php endif; ?> </div> </div> <div class="row"> <div class="col-sm-6"> Ongkos Kirim </div> <div class="col-sm-6"> Rp. <?php if(isset($current_faktur)): ?> <input type="text" class="form-control uang" disabled value="<?= number_format($transaction_faktur->ongkos_kirim,2,',','.'); ?>" style="width: 139px;display: inline;"> <?php else: ?> <input class="form-control uang" id="ongkos_kirim" name="ongkos_kirim" type="text" required onblur="hitung_ongkos_kirim()" style="width: 139px;display: inline;"> <?php endif; ?> </div> </div> <div class="row"> <div class="col-sm-6"> Sisa Tagihan </div> <div class="col-sm-6"> Rp. <?php if(isset($current_faktur)): ?> <input type="text" class="form-control" disabled value="<?= number_format($transaction_faktur->sisa_tagihan,2,',','.'); ?>" style="width: 139px;display: inline;"> <?php else: ?> <input class="form-control" id="sisa_tagihan" name="sisa_tagihan" type="text" required readonly style="width: 139px;display: inline;"> <?php endif; ?> </div> </div> </div> </div> <div class="row"> <div class="col-sm-12" style="text-align: center;"> <a href="<?= base_url('admin/pembelian/faktur'); ?>" type="submit" class="btn btn-info">Kembali ke daftar Faktur</a> <?php if(isset($current_faktur)): ?> <?php if($transaction_faktur->status_faktur == 12): ?> <a href="<?= base_url('admin/pembelian/faktur_paid/'.$transaction_faktur->id)?>" type="submit" class="btn btn-primary"> <i class="fa fa-save"></i> Sinkronisasi ke Jurnal </a> <?php endif; ?> <?php else: ?> <button class="btn btn-success" type="submit" name="submit" value="create_faktur"> <i class="fa fa-save"></i> Buat Faktur & Sinkronisasi </button> <?php endif; ?> </div> </div> <?= form_close(); ?> <script> $(document).ready(function(){ $('.select_transaction_receiving').change(function(){ var id_ttb = $(this).val(); ajax_faktur_get_transaction(id_ttb); ajax_faktur_get_transaction_detail(id_ttb); }); $('.uang').maskMoney({thousands:'.', decimal:','}); }); function ajax_faktur_get_transaction(id_ttb) { $.ajax({ 'url' : '<?php echo base_url(); ?>' + 'admin/pembelian' + '/ajax_faktur_get_transaction', 'type' : 'POST', 'data' : { 'id_ttb' : id_ttb, '<?= $this->security->get_csrf_token_name(); ?>' : '<?= $this->security->get_csrf_hash(); ?>' }, 'success' : function(data) { if (data) { var hasil = JSON.parse(data); /*intro*/ document.getElementById('no_po').value = hasil.transaction['no_transaksi']; document.getElementById('nama_supplier').value = hasil.supplier['supplier_name']; $('#supplier_address').html(hasil.supplier['supplier_address']); document.getElementById('supplier_email').value = hasil.supplier['supplier_email']; document.getElementById('tgl_transaksi').value = hasil.transaction['tgl_transaksi']; document.getElementById('no_referensi').value = hasil.transaction['no_referensi']; document.getElementById('syarat_pembayaran').value = hasil.syarat_pembayaran; document.getElementById('tgl_jth_tempo').value = hasil.transaction['tgl_jth_tempo']; // document.getElementById('ongkos_kirim').value = number_format(hasil.transaction_receiving['ongkos_pengiriman'],2,',','.'); document.getElementById('warehouse').value = hasil.warehouse; /*intro*/ /*footer*/ $('#transaction_message').html(hasil.transaction['transaction_message']); document.getElementById("transaction_file").innerHTML = '<a href="<?= base_url('uploads/lampiran/');?>'+hasil.transaction['transaction_file']+'" target="_blank">'+hasil.transaction['transaction_file']+'</a>'; var a; var sub_total = 0; var diskon_per_baris = 0; var ppn_perbaris = 0; var total = 0; var sisa_tagihan = 0; var count = hasil.count_transaction; var ongkos_kirim = hasil.transaction_receiving['ongkos_pengiriman']; for (a = 0; a < count; a++) { var coming_qty = hasil.transaction_receiving_detail[a]['qty_receiving']; var harga_satuan = hasil.transaction_detail[a]['harga_satuan']; var diskon_satuan = hasil.transaction_detail[a]['diskon_satuan']; var ppn_satuan = hasil.transaction_detail[a]['ppn_satuan']; var total_jml_satuan = coming_qty * harga_satuan; var total_diskon_satuan = (total_jml_satuan * diskon_satuan)/100; var total_ppn_satuan = ((total_jml_satuan - total_diskon_satuan)*ppn_satuan)/100; sub_total = sub_total + total_jml_satuan; diskon_per_baris = diskon_per_baris + total_diskon_satuan; ppn_perbaris = ppn_perbaris + total_ppn_satuan; } total = (sub_total - diskon_per_baris) + ppn_perbaris; sisa_tagihan = total + parseFloat(ongkos_kirim); document.getElementById('sub_total').value = number_format(sub_total.toFixed(2),2,',','.'); document.getElementById('diskon_per_baris').value = number_format(diskon_per_baris.toFixed(2),2,',','.'); document.getElementById('ppn_value').value = number_format(ppn_perbaris.toFixed(2),2,',','.'); document.getElementById('total_akhir').value = number_format(total.toFixed(2),2,',','.'); document.getElementById('ongkos_kirim').value = number_format(ongkos_kirim,2,',','.'); document.getElementById('sisa_tagihan').value = number_format(sisa_tagihan.toFixed(2),2,',','.'); /*footer*/ }; } }); } function ajax_faktur_get_transaction_detail(id_ttb) { $.ajax({ 'url' : '<?php echo base_url(); ?>' + 'admin/pembelian' + '/ajax_faktur_get_transaction_detail', 'type' : 'POST', 'data' : { 'id_ttb' : id_ttb, '<?= $this->security->get_csrf_token_name(); ?>' : '<?= $this->security->get_csrf_hash(); ?>' }, 'success' : function(data) { if (data) { $('#transaction_detail').html(data); }; } }); } function hitung_ongkos_kirim() { var ongkir = document.getElementById('ongkos_kirim').value.split('.').join("").replace(',','.'); var total = document.getElementById('total_akhir').value.split('.').join("").replace(',','.'); var sisa_tagihan = 0; sisa_tagihan = parseFloat(total) + parseFloat(ongkir); document.getElementById('sisa_tagihan').value = number_format(sisa_tagihan.toFixed(2),2,',','.'); } </script>