Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- session_start();
- include '../../function/function.php';
- include '../../config/koneksi.php';
- if(!isset($_SESSION['awal']) && !isset($_SESSION['akhir'])){
- echo "<script>alert('Silahkan tentukan periode laporan keuangan yang ingin ditampilkan...');history.back(self);</script>";
- }
- $tanggalakhir=ubahTanggal($_SESSION['akhir']);
- $timestamp=strtotime($tanggalakhir);
- $setTanggal=date('Y-m-d',strtotime('+1 day',$timestamp));
- ?>
- <html>
- <head>
- <title>Neraca Awal 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">Neraca Awal <br>Periode <?php echo tanggalIndo($setTanggal);?><br> 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">
- <?php
- $query="select*from akun where indeks='1' and noakun between '1100' and '1350' order by indeks,noakun";
- $statement=$dbh->prepare($query);
- $statement->execute();
- $result=$statement->fetchAll();
- ?>
- <div class="form-group">
- <table class="table table-bordered table-striped">
- <tr>
- <td align="center" width="15%">No. Akun</td>
- <td align="center" width="50%">Nama Akun</td>
- <td align="center" width="35%">Saldo</td>
- </tr>
- <?php
- foreach($result as $row){
- ?>
- <tr>
- <td>
- <select name="idakun[]" id="idakun[]">
- <option value="<?php echo $row['idakun'];?>"><?php echo $row['indeks'].' - '. $row['noakun'];?></option>
- </select>
- </td>
- <td><input type="text" name="noakun[]" id="noakun[]" value="<?php echo $row['namaakun'];?>" readonly class="form-control input-sm"></td>
- <td><input type="text" name="saldo[]" id="saldo[]" autocomplete="off" value="0" class="form-control input-sm"></td>
- </tr>
- <?php } ?>
- <?php
- $query2="select*from akun where indeks='1' and noakun between '2100' and '2510' order by indeks,noakun";
- $statement2=$dbh->prepare($query2);
- $statement2->execute();
- $result2=$statement2->fetchAll();
- ?>
- <?php
- foreach($result2 as $row2){
- ?>
- <tr>
- <td>
- <select name="idakun[]" id="idakun[]">
- <option value="<?php echo $row2['idakun'];?>"><?php echo $row2['indeks'].' - '. $row2['noakun'];?></option>
- </select>
- </td>
- <td><input type="text" name="noakun[]" id="noakun[]" value="<?php echo $row2['namaakun'];?>" readonly class="form-control input-sm"></td>
- <td><input type="text" name="saldo[]" id="saldo[]" autocomplete="off" value="0" class="form-control input-sm"></td>
- </tr>
- <?php } ?>
- <?php
- $query3="select*from akun where indeks='2' and noakun between '1100' and '1300' order by indeks,noakun";
- $statement3=$dbh->prepare($query3);
- $statement3->execute();
- $result3=$statement3->fetchAll();
- ?>
- <?php
- foreach($result3 as $row3){
- ?>
- <tr>
- <td>
- <select name="idakun[]" id="idakun[]">
- <option value="<?php echo $row3['idakun'];?>"><?php echo $row3['indeks'].' - '. $row3['noakun'];?></option>
- </select>
- </td>
- <td><input type="text" name="noakun[]" id="noakun[]" value="<?php echo $row3['namaakun'];?>" readonly class="form-control input-sm"></td>
- <td><input type="text" name="saldo[]" id="saldo[]" autocomplete="off" value="0" class="form-control input-sm"></td>
- </tr>
- <?php } ?>
- <?php
- $query4="select*from akun where indeks='2' and noakun='2100' order by indeks,noakun";
- $statement4=$dbh->prepare($query4);
- $statement4->execute();
- $result4=$statement4->fetchAll();
- ?>
- <?php
- foreach($result4 as $row4){
- ?>
- <tr>
- <td>
- <select name="idakun[]" id="idakun[]">
- <option value="<?php echo $row4['idakun'];?>"><?php echo $row4['indeks'].' - '. $row4['noakun'];?></option>
- </select>
- </td>
- <td><input type="text" name="noakun[]" id="noakun[]" value="<?php echo $row4['namaakun'];?>" readonly class="form-control input-sm"></td>
- <td><input type="text" name="saldo[]" id="saldo[]" autocomplete="off" value="0" class="form-control input-sm"></td>
- </tr>
- <?php } ?>
- <?php
- $query5="select*from akun where indeks='3' and noakun='1100' order by indeks,noakun";
- $statement5=$dbh->prepare($query5);
- $statement5->execute();
- $result5=$statement5->fetchAll();
- ?>
- <?php
- foreach($result5 as $row5){
- ?>
- <tr>
- <td>
- <select name="idakun[]" id="idakun[]">
- <option value="<?php echo $row5['idakun'];?>"><?php echo $row5['indeks'].' - '. $row5['noakun'];?></option>
- </select>
- </td>
- <td><input type="text" name="noakun[]" id="noakun[]" value="<?php echo $row5['namaakun'];?>" readonly class="form-control input-sm"></td>
- <td><input type="text" name="saldo[]" id="saldo[]" autocomplete="off" value="0" class="form-control input-sm"></td>
- </tr>
- <?php } ?>
- </table>
- </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({});
- var rupiah = document.getElementById('saldo[]');
- rupiah.addEventListener('keyup', function(e){
- rupiah.value=formatRupiah(this.value, 'Rp. ');
- });
- function formatRupiah(angka,prefix){
- var number_string=angka.replace(/[^,\d]/g, '').toString(),
- split=number_string.split(','),
- sisa=split[0].length % 3,
- rupiah=split[0].substr(0, sisa),
- ribuan=split[0].substr(sisa).match(/\d{3}/gi);
- if(ribuan){
- separator=sisa ? '.' : '';
- rupiah+=separator+ribuan.join('.');
- }
- rupiah=split[1] != undefined ? rupiah + ',' + split[1]:rupiah;
- return prefix == undefined ? rupiah : (rupiah ? 'Rp. ' + rupiah : '');
- }
- load_data();
- function load_data(){
- $.ajax({
- url:"fetch.php",
- method:"POST",
- success:function(data){
- $('#user_data').html(data);
- }
- });
- }
- $('#user_dialog').dialog({
- autoOpen:false,
- width:850
- });
- $('#addRow').click(function(){
- var i = $('input').size()+1, element='<tr>';
- element+='<td width="10px"><select name="idakun[]" id="idakun-'+i+' " >';
- element+='<option value="">- Pilih Akun -</option>';
- element+='<?php foreach($result as $row){ ?>';
- element+='<?php $idakun=$row["idakun"];$indeks=$row["indeks"];$noakun=$row["noakun"];$namaakun=$row["namaakun"];?>';
- element+='<option value="<?php echo $idakun;?>"><?php echo $indeks;?> - <?php echo $noakun;?> - <?php echo $namaakun; ?></option>';
- element+='<?php } ?>'
- element+='</select></td>';
- element+='<td><input type="text" name="debit[]" id="debit-'+i+' " size="10px" value="0"></td>';
- element+='<td><input type="text" name="kredit[]" id="kredit-'+i+' " size="10px" value="0"></td>';
- element+='<td> </td>';
- element+='</tr>';
- $('#rowTable').append(element);
- 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