report.php
unknown
php_laravel_blade
2 years ago
40 kB
5
Indexable
@extends('templates.admin_main') @section('top-header') <header class="top-nav w3-container w3-xlarge header-customize px-4 mt-3"> <p class="w3-left">Laporan Saldo Vihara Dhamma Jaya</p> <p class="w3-right">Role <span>: {{ Auth::guard('admin')->user()->role }} </span> </p> <style> .tab { display: inline-block; margin-left: 17%; } .plus { color: green; } .minus { color: red; } .border-top { border-top: 1pt solid black; } </style> </header> @endsection @section('css') <!-- Datepicker asset --> <link rel="stylesheet" href="//code.jquery.com/ui/1.13.2/themes/base/jquery-ui.css"> <link rel="stylesheet" href="/resources/demos/style.css"> <!-- Add-on Font Awesome --> <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/5.15.2/css/all.min.css"> <!-- Select2 Plugin for search in select --> <link href="https://cdn.jsdelivr.net/npm/select2@4.1.0-rc.0/dist/css/select2.min.css" rel="stylesheet" /> <script src="https://cdn.jsdelivr.net/npm/select2@4.1.0-rc.0/dist/js/select2.min.js"></script> @endsection @section('content') <div class="w3-main container-main" style="margin-left:250px;padding-top: 0;"> <!-- isi halaman --> <div class="content-wrapper" id="content-web-page"> <div class="container-fluid"> <div class="row"> {{-- ============================ BATAS ====================================== --}} <div class="col-md-14"> <div class="card card-noborder b-radius"> <div class="card-header"> <div class="row"> <div class="col-md-8"> <h4 id="periode"></h4> </div> <div class="col-md-4 mt-3"> <div class="row"> <div class="col"> <input type="month" name="date" id="tahun_bulan" class="form-control form-control-md" required> </div> <div class="col-sm"> <button type="submit" class="btn btn-primary btn-md" id="filter_btn">Filter</button> <button class="btn btn-danger btn-md" id="exportpdf" type="submit"> <i class="mdi mdi-file-pdf"></i> PDF </button> </div> </div> </div> <div class="col-md-4 mt-1"> <div class="row"> {{-- <div class="col-md-2"> <button class="btn btn-danger btn-sm" id="exportpdf" type="submit"> <i class="mdi mdi-file-pdf"></i> PDF </button> </div> --}} {{-- <div class="col-md-4"> <button class="btn btn-success btn-sm" id="exportexcel" type="submit"> <i class="mdi mdi-file-excel"></i> Excel </button> </div> --}} </div> </div> </div> </div> <div class="card-body"> <div class="table-responsive"> <table class="table table-bordered"> <thead> </thead> <tbody> <tr> <th colspan="6" style="font-size:26px; color:red;">Pendapatan</th> </tr> {{-- ---------- Transaksi Dana ----------- --}} <tr> <td style="width:20%"> <h6><b>Transaksi Dana</b></h6> </td> <td style="width:15%"></td> <td style="width:15%"></td> <td style="width:15%"></td> <td style="width:15%"></td> <td style="width:20%"></td> </tr> <tr> <td></td> <td> <b> Tunai </b></td> <td> <b> Transfer </b></td> <td> <b> QRIS </b></td> <td> <b> Debit </b> </td> <td><b>Total Transaksi Dana</b></td> </tr> <tr> <td></td> <td id="transaksi_dana_tunai" style="text-align: right; border-top: 1px solid black;"></td> <td id="transaksi_dana_transfer" style="text-align: right; border-top: 1px solid black;"></td> <td id="transaksi_dana_QRIS" style="text-align: right; border-top: 1px solid black;"></td> <td id="transaksi_dana_debit" style="text-align: right; border-top: 1px solid black;"></td> <td id="total_transaksi_dana" style="text-align: right; border-top: 1px solid black;"></td> </tr> <tr> <td style="height:40px"></td> <td></td> <td></td> <td></td> <td></td> <td></td> </tr> {{-- ---------- Transaksi Paket ----------- --}} <tr> <td style="width:20%"> <h6><b>Transaksi Paket</b></h6> </td> <td style="width:15%"></td> <td style="width:15%"></td> <td style="width:15%"></td> <td style="width:15%"></td> <td style="width:20%"></td> </tr> <tr> <td></td> <td> <b> Tunai </b></td> <td> <b> Transfer </b></td> <td> <b> QRIS </b></td> <td> <b> Debit </b> </td> <td><b>Total Transaksi Paket</b></td> </tr> <tr> <td></td> <td id="transaksi_paket_tunai" style="text-align: right; border-top: 1px solid black;"></td> <td id="transaksi_paket_transfer" style="text-align: right; border-top: 1px solid black;"></td> <td id="transaksi_paket_QRIS" style="text-align: right; border-top: 1px solid black;"></td> <td id="transaksi_paket_debit" style="text-align: right; border-top: 1px solid black;"></td> <td id="total_transaksi_paket" style="text-align: right; border-top: 1px solid black;"> </th> </td> <tr> <td style="height:40px"></td> <td></td> <td></td> <td></td> <td></td> <td></td> </tr> <tr> <td style="width:20%"> <h6><b>Transaksi Samanagara</b></h6> </td> <td style="width:15%"></td> <td style="width:15%"></td> <td style="width:15%"></td> <td style="width:15%"></td> <td style="width:20%"></td> </tr> <tr> <td></td> <td> <b> Tunai </b></td> <td> <b> Transfer </b></td> <td> <b> QRIS </b></td> <td> <b> Debit </b> </td> <td><b>Total Transaksi Samanagara</b></td> </tr> <tr> <td>Umat yang Terdaftar</td> <td id="transaksi-foto-tunai" style="text-align: right; border-top: 1px solid black;"></td> <td id="transaksi-foto-transfer" style="text-align: right; border-top: 1px solid black;"></td> <td id="transaksi-foto-QRIS" style="text-align: right; border-top: 1px solid black;"></td> <td id="transaksi-foto-debit" style="text-align: right; border-top: 1px solid black;"></td> <td id="total-transaksi-foto" style="text-align: right; border-top: 1px solid black;"></td> </tr> <tr> <td>Umat yang tidak Terdaftar</td> <td id="transaksi-foto-unreg-tunai" style="text-align: right;"></td> <td id="transaksi-foto-unreg-transfer" style="text-align: right;"></td> <td id="transaksi-foto-unreg-QRIS" style="text-align: right;"></td> <td id="transaksi-foto-unreg-debit" style="text-align: right;"></td> <td id="total-transaksi-foto-unreg" style="text-align: right;"></td> </tr> <tr> <td style="height:40px"></td> <td></td> <td></td> <td></td> <td></td> <td></td> </tr> <tr> <td style="width:20%"> <h6><b>Kas Masuk</b> </h6> </td> <td></td> <td></td> <td></td> <td></td> <td></td> </tr> <tr> <td></td> <td> <b> Tunai </b> </td> <td></td> <td></td> <td></td> {{-- <td> <b> Transfer </b></td> <td> <b> QRIS </b></td> <td> <b> Debit </b> </td> --}} <td><b>Total Kas Masuk</b></td> </tr> <tr> <td>Dana dari Yayasan</td> <td id="km_1" style="text-align: right; border-top: 1px solid black;"></td> <td> </td> <td></td> <td></td> <td id="total_km_1" style="text-align: right; border-top: 1px solid black;"></td> </tr> <tr> <td>Dana Paramita Umum</td> <td id="km_2" style="text-align: right;"></td> <td style="text-align: right;"></td> <td style="text-align: right;"></td> <td style="text-align: right;"></td> <td id="total_km_2" style="text-align: right;"></td> </tr> <tr> <td>Dana Paramita Anak-Anak</td> <td id="km_3" style="text-align: right;"></td> <td style="text-align: right;"></td> <td style="text-align: right;"></td> <td style="text-align: right;"></td> <td id="total_km_3" style="text-align: right;"></td> </tr> <tr> <td>Dana Paramita Remaja</td> <td id="km_4" style="text-align: right;"></td> <td style="text-align: right;"></td> <td style="text-align: right;"></td> <td style="text-align: right;"></td> <td id="total_km_4" style="text-align: right;"></td> </tr> <tr> <td>Dana Muda Mudi</td> <td id="km_5" style="text-align: right;"></td> <td style="text-align: right;"></td> <td style="text-align: right;"></td> <td style="text-align: right;"></td> <td id="total_km_5" style="text-align: right;"></td> </tr> <tr> <td style="height:40px"></td> <td></td> <td></td> <td></td> <td></td> <td></td> </tr> <tr> <td> <h6><b> Total Pendapatan</b></h6> </td> <th id="total-pendapatan-kas" style=" text-align: right;"> </th> <td></td> <td></td> <td></td> <th id="total-pendapatan" style="color:green; text-align: right;"> </th> </tr> <tr> <th colspan="6" style="font-size:26px; color:red;">Pengeluaran</th> </tr> <tr> <td> <h6><b> Kas Keluar </b></h6> </td> </tr> <tr> <td></td> <td><b> Tunai </b></td> <td><b> Transfer </b></td> <td></td> <td></td> <td><b>Total Transaksi Kas Keluar</b></td> </tr> <tr> <td></td> <td style="text-align: right;border-top: 1px solid black;" id="kas-keluar"></td> <td style="text-align: right;border-top: 1px solid black;" id="kas-keluar-tf"></td> <td></td> <td></td> <td id="total-kas-keluar" style="text-align: right;border-top: 1px solid black;"></td> </tr> <tr> <td style="height:40px"></td> <td></td> <td></td> <td></td> <td></td> <td></td> </tr> {{-- <tr> <td> <h6><b> Total Pendapatan</b></h6> </td> <td></td> <td></td> <td></td> <td></td> <th id="total-pendapatan" style="color:green; text-align: right;"> </th> </tr> --}} <tr> <td> <h6><b>Total Pengeluaran</b></h6> </td> <td></td> <td></td> <td></td> <td></td> <th id="total-pengeluaran" style="color:red; text-align: right;"> </th> </tr> {{-- <tr> <th colspan="4">Laba</th> </tr> --}} <tr> <td> <h6><b>Saldo Kas Tunai</b></h6> </td> <td></td> <td></td> <td></td> <td></td> <th id="laba-bersih" style="text-align: right;"></th> </tr> </tbody> </table> </div> </div> </div> </div> {{-- ============================ BATAS ====================================== --}} </div> </div> </div> </div> @endsection @section('script') <script> $(document).ready(function() { var tahun_bulan = document.getElementById('tahun_bulan').value; console.log(tahun_bulan); if (tahun_bulan == null) { tahun_bulan = 0; } if ($('#tahun_bulan').is(':empty')) { tahun_bulan = 0; } $.ajax({ url: "{{ url('/laporan-keuangan/data-transaksi') }}/" + tahun_bulan, method: "GET", success: function(response) { // Pemasukan var transaksi = response.total_transaksi; var total_pendapatan = response.total_pendapatan; var total_pendapatan_kas = response.total_pendapatan_kas; var date = response.date; // Kas Masuk var kasMasuk = response.total_kas_masuk; var km_1 = response.km_1; var km_2 = response.km_2; var km_3 = response.km_3; var km_4 = response.km_4; var km_5 = response.km_5; var total_km_1 = km_1; var total_km_2 = km_2; var total_km_3 = km_3; var total_km_4 = km_4; var total_km_5 = km_5; // ===== Transaksi Dana ===== // var transaksi_dana_tunai = response.transaksi_dana_tunai; var transaksi_dana_transfer = response.transaksi_dana_transfer; var transaksi_dana_QRIS = response.transaksi_dana_QRIS; var transaksi_dana_debit = response.transaksi_dana_debit; var total_transaksi_dana = response.total_transaksi_dana; // ===== Transaksi Paket ===== // var transaksi_paket_tunai = response.transaksi_paket_tunai; var transaksi_paket_transfer = response.transaksi_paket_transfer; var transaksi_paket_QRIS = response.transaksi_paket_QRIS; var transaksi_paket_debit = response.transaksi_paket_debit; var total_transaksi_paket = response.total_transaksi_paket; // ===== Transaksi Foto ===== // var transaksi_foto_tunai = response.transaksi_foto_tunai; var transaksi_foto_transfer = response.transaksi_foto_transfer; var transaksi_foto_QRIS = response.transaksi_foto_QRIS; var transaksi_foto_debit = response.transaksi_foto_debit; var total_transaksi_foto = response.total_transaksi_foto; // ===== Transaksi Foto Unreg ===== // var transaksi_foto_unreg_tunai = response.transaksi_foto_unreg_tunai; var transaksi_foto_unreg_transfer = response.transaksi_foto_unreg_transfer; var transaksi_foto_unreg_QRIS = response.transaksi_foto_unreg_QRIS; var transaksi_foto_unreg_debit = response.transaksi_foto_unreg_debit; var total_transaksi_foto_unreg = response.total_transaksi_foto_unreg; // Pengeluaran var total_pengeluaran = response.total_pengeluaran; var total_pengeluaranTu = response.total_pengeluaran_tu; var total_pengeluaranTf = response.total_pengeluaran_tf; // Laba var laba_bersih = response.laba_bersih; $('#periode').html("Periode : Bulan " + date); // Kas Masuk $('#km_1').html(km_1); $('#km_2').html(km_2); $('#km_3').html(km_3); $('#km_4').html(km_4); $('#km_5').html(km_5); $('#total_km_1').html(total_km_1); $('#total_km_2').html(total_km_2); $('#total_km_3').html(total_km_3); $('#total_km_4').html(total_km_4); $('#total_km_5').html(total_km_5); $('#kas_masuk').html(kasMasuk); $('#total_kas_masuk').html(kasMasuk); // ===== Transaksi Dana ===== // $('#transaksi_dana_tunai').html(transaksi_dana_tunai) $('#transaksi_dana_transfer').html(transaksi_dana_transfer) $('#transaksi_dana_QRIS').html(transaksi_dana_QRIS) $('#transaksi_dana_debit').html(transaksi_dana_debit) $('#total_transaksi_dana').html(total_transaksi_dana) // ===== Transaksi Paket ===== // $('#transaksi_paket_tunai').html(transaksi_paket_tunai) $('#transaksi_paket_transfer').html(transaksi_paket_transfer) $('#transaksi_paket_QRIS').html(transaksi_paket_QRIS) $('#transaksi_paket_debit').html(transaksi_paket_debit) $('#total_transaksi_paket').html(total_transaksi_paket) // Foto $('#transaksi-foto-tunai').html(transaksi_foto_tunai); $('#transaksi-foto-transfer').html(transaksi_foto_transfer); $('#transaksi-foto-QRIS').html(transaksi_foto_QRIS); $('#transaksi-foto-debit').html(transaksi_foto_debit); $('#total-transaksi-foto').html(total_transaksi_foto); // Foto Unreg $('#transaksi-foto-unreg-tunai').html(transaksi_foto_unreg_tunai); $('#transaksi-foto-unreg-transfer').html(transaksi_foto_unreg_transfer); $('#transaksi-foto-unreg-QRIS').html(transaksi_foto_unreg_QRIS); $('#transaksi-foto-unreg-debit').html(transaksi_foto_unreg_debit); $('#total-transaksi-foto-unreg').html(total_transaksi_foto_unreg); $('#total-pendapatan').html("<h6><b> Rp. " + total_pendapatan_kas + "</b></h6>"); $('#total-pendapatan-kas').html("<h6><b> Rp. " + total_pendapatan + "</b></h6>"); $('#kas-keluar').html(total_pengeluaranTu); $('#kas-keluar-tf').html(total_pengeluaranTf); $('#total-kas-keluar').html(total_pengeluaran); $('#total-pengeluaran').html("<h6><b> Rp. " + total_pengeluaran + "</b></h6>"); $('#laba-bersih').html("<h6><b> Rp. " + laba_bersih + "</b></h6>"); $('#laba-bersih').addClass(response.laba_class); } }); }); $(document).on('click', '#filter_btn', function(e) { e.preventDefault(); var tahun_bulan = document.getElementById('tahun_bulan').value; console.log(tahun_bulan); $.ajax({ url: "{{ url('/laporan-keuangan/data-transaksi') }}/" + tahun_bulan, method: "GET", success: function(response) { // Pemasukan var transaksi = response.total_transaksi; var total_pendapatan = response.total_pendapatan; var total_pendapatan_kas = response.total_pendapatan_kas; var date = response.date; // Kas Masuk var kasMasuk = response.total_kas_masuk; var km_1 = response.km_1; var km_2 = response.km_2; var km_3 = response.km_3; var km_4 = response.km_4; var km_5 = response.km_5; var total_km_1 = km_1; var total_km_2 = km_2; var total_km_3 = km_3; var total_km_4 = km_4; var total_km_5 = km_5; // ===== Transaksi Dana ===== // var transaksi_dana_tunai = response.transaksi_dana_tunai; var transaksi_dana_transfer = response.transaksi_dana_transfer; var transaksi_dana_QRIS = response.transaksi_dana_QRIS; var transaksi_dana_debit = response.transaksi_dana_debit; var total_transaksi_dana = response.total_transaksi_dana; // ===== Transaksi Paket ===== // var transaksi_paket_tunai = response.transaksi_paket_tunai; var transaksi_paket_transfer = response.transaksi_paket_transfer; var transaksi_paket_QRIS = response.transaksi_paket_QRIS; var transaksi_paket_debit = response.transaksi_paket_debit; var total_transaksi_paket = response.total_transaksi_paket; // ===== Transaksi Foto ===== // var transaksi_foto_tunai = response.transaksi_foto_tunai; var transaksi_foto_transfer = response.transaksi_foto_transfer; var transaksi_foto_QRIS = response.transaksi_foto_QRIS; var transaksi_foto_debit = response.transaksi_foto_debit; var total_transaksi_foto = response.total_transaksi_foto; // ===== Transaksi Foto Unreg ===== // var transaksi_foto_unreg_tunai = response.transaksi_foto_unreg_tunai; var transaksi_foto_unreg_transfer = response.transaksi_foto_unreg_transfer; var transaksi_foto_unreg_QRIS = response.transaksi_foto_unreg_QRIS; var transaksi_foto_unreg_debit = response.transaksi_foto_unreg_debit; var total_transaksi_foto_unreg = response.total_transaksi_foto_unreg; // Pengeluaran var total_pengeluaran = response.total_pengeluaran; var total_pengeluaranTu = response.total_pengeluaran_tu; var total_pengeluaranTf = response.total_pengeluaran_tf; // Laba var laba_bersih = response.laba_bersih; $('#periode').html("Periode : Bulan " + date); // Kas Masuk $('#km_1').html(km_1); $('#km_2').html(km_2); $('#km_3').html(km_3); $('#km_4').html(km_4); $('#km_5').html(km_5); $('#total_km_1').html(total_km_1); $('#total_km_2').html(total_km_2); $('#total_km_3').html(total_km_3); $('#total_km_4').html(total_km_4); $('#total_km_5').html(total_km_5); $('#kas_masuk').html(kasMasuk); $('#total_kas_masuk').html(kasMasuk); // ===== Transaksi Dana ===== // $('#transaksi_dana_tunai').html(transaksi_dana_tunai) $('#transaksi_dana_transfer').html(transaksi_dana_transfer) $('#transaksi_dana_QRIS').html(transaksi_dana_QRIS) $('#transaksi_dana_debit').html(transaksi_dana_debit) $('#total_transaksi_dana').html(total_transaksi_dana) // ===== Transaksi Paket ===== // $('#transaksi_paket_tunai').html(transaksi_paket_tunai) $('#transaksi_paket_transfer').html(transaksi_paket_transfer) $('#transaksi_paket_QRIS').html(transaksi_paket_QRIS) $('#transaksi_paket_debit').html(transaksi_paket_debit) $('#total_transaksi_paket').html(total_transaksi_paket) // Foto $('#transaksi-foto-tunai').html(transaksi_foto_tunai); $('#transaksi-foto-transfer').html(transaksi_foto_transfer); $('#transaksi-foto-QRIS').html(transaksi_foto_QRIS); $('#transaksi-foto-debit').html(transaksi_foto_debit); $('#total-transaksi-foto').html(total_transaksi_foto); // Foto Unreg $('#transaksi-foto-unreg-tunai').html(transaksi_foto_unreg_tunai); $('#transaksi-foto-unreg-transfer').html(transaksi_foto_unreg_transfer); $('#transaksi-foto-unreg-QRIS').html(transaksi_foto_unreg_QRIS); $('#transaksi-foto-unreg-debit').html(transaksi_foto_unreg_debit); $('#total-transaksi-foto-unreg').html(total_transaksi_foto_unreg); $('#total-pendapatan-kas').html("<h6><b> Rp. " + total_pendapatan_kas + "</b></h6>"); $('#total-pendapatan').html("<h6><b> Rp. " + total_pendapatan + "</b></h6>"); $('#kas-keluar').html(total_pengeluaranTu); $('#kas-keluar-tf').html(total_pengeluaranTf); $('#total-kas-keluar').html(total_pengeluaran); $('#total-pengeluaran').html("<h6><b> Rp. " + total_pengeluaran + "</b></h6>"); $('#laba-bersih').html("<h6><b> Rp. " + laba_bersih + "</b></h6>"); $('#laba-bersih').addClass(response.laba_class); } }); }); $(document).on('click', '#exportpdf', function(e) { var tahun_bulan = document.getElementById('tahun_bulan').value; console.log(tahun_bulan); if (tahun_bulan == null) { tahun_bulan = 0; } // if ($('#tahun_bulan').is(':empty')) { // tahun_bulan = 0; // } console.log(tahun_bulan); window.open("{{ url('/laporan-keuangan/exportpdf') }}/" + tahun_bulan); }); $(document).on('click', '#exportexcel', function(e) { var tahun_bulan = document.getElementById('tahun_bulan').value; console.log(tahun_bulan); if (tahun_bulan == null) { tahun_bulan = 0; } // if ($('#tahun_bulan').is(':empty')) { // tahun_bulan = 0; // } console.log(tahun_bulan); window.open("{{ url('/laporan-keuangan/exportexcel') }}/" + tahun_bulan); }); $("tr.item").each(function() { var tmp = $(this).find("td.test").val(); if (tmp = '0.00') $(this).hide; }); </script> @endsection
Editor is loading...