@extends('layout.admin')

@section('content')
    <div class="row bg-title" style="background-color: white;">
        <!-- .page title -->
        <div class="col-lg-3 col-md-4 col-sm-4 col-xs-12">
            <h4 class="page-title">Tutup Tahun</h4> 
        </div>
        <!-- /.page title -->

        <!-- .breadcrumb -->
        <div class="col-lg-9 col-sm-8 col-md-8 col-xs-12">
            <ol class="breadcrumb">
                <li><a href="javascript:void(0)">Akuntansi</a></li>
                <li class="active">Tutup Tahun</li>
            </ol>
        </div>
        <!-- /.breadcrumb -->
    </div>

    <!-- .row -->
    <div class="row">
        <div class="col-lg-12 col-sm-12 col-xs-12">
            <div class="white-box">
                <!-- Tab panes -->
                <div class="tab-content">
                    <div class="tab-pane active">
                        <!-- .row -->
                        <div class="row">
                            <div class="col-sm-12">
                                
                                <div class="panel-group wiz-aco" id="accordion" role="tablist" aria-multiselectable="true">
                                    <div class="panel panel-default">
                                        <div class="panel-heading" role="tab" id="headingOne">
                                            <h4 class="panel-title">
                                                <a data-toggle="collapse" data-parent="#accordion" href="#collapseOne" aria-expanded="true" aria-controls="collapseOne">
                                                    <b>Proses Tutup Tahun Periode {{ $listData['tahun_fiskal'] }}</b>
                                                </a>
                                            </h4> 
                                        </div>
                                        <div id="collapseOne" class="panel-collapse collapse in" role="tabpanel" aria-labelledby="headingOne">
                                            <div class="panel-body"> 
                                                1. Proses ini harus dilakukan pada akhir tahun. </br>
                                                2. Pastikan pengaturan alokasi dana SHU sudah dilakukan dengan benar. </br>
                                                3. Proses ini berfungsi untuk menghitung SHU dan memindahkan saldo akun ke tahun periode berikutnya. </br>
                                                4. Setelah melakukan proses tutup tahun, anda tidak dapat melakukan semua transaksi tahun sekarang. </br>
                                                5. Sebelum melakukan proses, anda harus melakukan backup data terlebih dahulu. </br>
                                                6. Pastikan tidak ada user lain yang sedang melakukan transaksi. </br>
                                            </div>
                                        </div>
                                    </div>
                                    <div class="panel panel-default">
                                        <div class="panel-heading" role="tab" id="headingTwo">
                                            <h4 class="panel-title">
                                                <a class="collapsed" data-toggle="collapse" data-parent="#accordion" href="#collapseTwo" aria-expanded="false" aria-controls="collapseTwo">
                                                    <b>Detail Neraca</b>
                                                </a>
                                            </h4> 
                                        </div>
                                        <div id="collapseTwo" class="panel-collapse collapse" role="tabpanel" aria-labelledby="headingTwo">
                                            <div class="panel-body">
                                                <div class="table-responsive">
                                                    <table class="table color-table inverse-table table-hover table-condensed">
                                                        <thead>
                                                            <tr>
                                                                <th style="text-align: center;" colspan="2"><b>Daftar Akun</b></th>
                                                                <th style="text-align: center;" colspan="2"><b>Neraca Saldo</b></th>
                                                                <th style="text-align: center;" colspan="3"><b>SHU</b></th>
                                                                <th style="text-align: center;" colspan="2"><b>Neraca</b></th>
                                                            </tr>
                                                            <tr>
                                                                <th style="text-align: center;"><b>Kode</b></th>
                                                                <th style="text-align: center;"><b>Nama Akun</b></th>
                                                                <th style="text-align: center;"><b>Debet</b></th>
                                                                <th style="text-align: center;"><b>Kredit</b></th>
                                                                <th style="text-align: center;"><b>% SHU</b></th>
                                                                <th style="text-align: center;"><b>Debet</b></th>
                                                                <th style="text-align: center;"><b>Kredit</b></th>
                                                                <th style="text-align: center;"><b>Debet</b></th>
                                                                <th style="text-align: center;"><b>Kredit</b></th>
                                                            </tr>
                                                        </thead>
                                                        <tbody>
                                                            @php
                                                                $neracaSaldoDebet = 0;
                                                                $neracaSaldoKredit = 0;
                                                                $persenShu = 0;
                                                                $neracaDebet = 0;
                                                                $neracaKredit = 0;

                                                                $jumNeracaSaldoDebet = 0;
                                                                $jumNeracaSaldoKredit = 0;
                                                                $jumPersenShu = 0;
                                                                $jumShuDebet = 0;
                                                                $jumShuKredit = 0;
                                                                $jumNeracaDebet = 0;
                                                                $jumNeracaKredit = 0;

                                                                $jumNeracaSaldoLabaRugiDebet = 0;
                                                                $jumNeracaSaldoLabaRugiKredit = App\Models\AkunPerkiraan\TipeAkunDetail::labaRugiShuByNeracaTutupTahun($listData['tahun_fiskal']);
                                                                $jumShuPersenLabaRugi = 0;
                                                                $jumShuLabaRugiDebet = $jumNeracaSaldoLabaRugiKredit;
                                                                $jumShuLabaRugiKredit = 0;
                                                                $jumNeracaLabaRugiDebet = 0;
                                                                $jumNeracaLabaRugiKredit = 0;
                                                            @endphp

                                                            @foreach($listAkun as $item)  
                                                            @php
                                                                if (in_array($item->kode[0],[1,2,3])) {
                                                                    $neracaSaldoDebet = $item->neracaSaldo($listData['tahun_fiskal'], 'debet');
                                                                    $neracaSaldoKredit = $item->neracaSaldo($listData['tahun_fiskal'], 'kredit');
                                                                } else {
                                                                    $neracaSaldoDebet = 0;
                                                                    $neracaSaldoKredit = 0;
                                                                }

                                                                $persenShu = $item->persenShu();
                                                                
                                                                $shuDebet = 0;
                                                                $shuKredit = $persenShu/100 * $jumNeracaSaldoLabaRugiKredit;

                                                                $neracaDebet = $neracaSaldoDebet + $shuDebet;
                                                                $neracaKredit = $neracaSaldoKredit + $shuKredit;


                                                                $jumNeracaSaldoDebet += $neracaSaldoDebet;
                                                                $jumNeracaSaldoKredit += $neracaSaldoKredit;
                                                                $jumPersenShu += $persenShu;
                                                                $jumShuDebet += $shuDebet;
                                                                $jumShuKredit+= $shuKredit;
                                                                $jumNeracaDebet += $neracaDebet;
                                                                $jumNeracaKredit += $neracaKredit;
                                                           
                                                            @endphp
                                                            <tr>
                                                                <td>{{ $item['kode'] }}</td>
                                                                <td>{{ $item['nama'] }}</td>
                                                                <td style="text-align: right;">{{ mataUang($neracaSaldoDebet) }}</td>
                                                                <td style="text-align: right;">{{ mataUang($neracaSaldoKredit) }}</td>
                                                                <td style="text-align: right;">{{ mataUang($persenShu) }} %</td>
                                                                <td style="text-align: right;">{{ mataUang($shuDebet) }}</td>
                                                                <td style="text-align: right;">{{ mataUang($shuKredit) }}</td>
                                                                <td style="text-align: right;">{{ mataUang($neracaDebet) }}</td>
                                                                <td style="text-align: right;">{{ mataUang($neracaKredit) }}</td>
                                                            </tr>
                                                            @endforeach
                                                            <tr>
                                                                <td>&nbsp;</td>
                                                                <td><b>TOTAL</b></td>
                                                                <td style="text-align: right;">{{ mataUang($jumNeracaSaldoDebet) }}</td>
                                                                <td style="text-align: right;">{{ mataUang($jumNeracaSaldoKredit) }}</td>
                                                                <td style="text-align: right;">{{ mataUang($jumPersenShu) }} %</td>
                                                                <td style="text-align: right;">{{ mataUang($jumShuDebet) }}</td>
                                                                <td style="text-align: right;">{{ mataUang($jumShuKredit) }}</td>
                                                                <td style="text-align: right;">{{ mataUang($jumNeracaDebet) }}</td>
                                                                <td style="text-align: right;">{{ mataUang($jumNeracaKredit) }}</td>
                                                            </tr>
                                                            <tr>
                                                                <td>320-20</td>
                                                                <td><b>{{ $listData['akun_laba_rugi'] }}</b></td>
                                                                <td style="text-align: right;">{{ mataUang($jumNeracaSaldoLabaRugiDebet) }}</td>
                                                                <td style="text-align: right;">{{ mataUang($jumNeracaSaldoLabaRugiKredit) }}</td>
                                                                <td style="text-align: right;">{{ mataUang($jumShuPersenLabaRugi) }} %</td>
                                                                <td style="text-align: right;">{{ mataUang($jumShuLabaRugiDebet) }}</td>
                                                                <td style="text-align: right;">{{ mataUang($jumShuLabaRugiKredit) }}</td>
                                                                <td style="text-align: right;">{{ mataUang($jumNeracaLabaRugiDebet) }}</td>
                                                                <td style="text-align: right;">{{ mataUang($jumNeracaLabaRugiKredit) }}</td>
                                                            </tr>
                                                            @php
                                                                $totalNeracaSaldoDebet = $jumNeracaSaldoDebet + $jumNeracaSaldoLabaRugiDebet;
                                                                $totalNeracaSaldoKredit = $jumNeracaSaldoKredit + $jumNeracaSaldoLabaRugiKredit;
                                                                
                                                                $totalShuPersen = $jumPersenShu;
                                                                $totalShuDebet = $jumShuLabaRugiDebet + $jumShuDebet;
                                                                $totalShuKredit = $jumShuLabaRugiKredit + $jumShuKredit;

                                                                $totalNeracaDebet = $jumNeracaDebet + $jumNeracaLabaRugiDebet;
                                                                $totalNeracaKredit = $jumNeracaKredit + $jumNeracaLabaRugiKredit;
                                                            @endphp
                                                            <tr>
                                                                <td>&nbsp;</td>
                                                                <td><b>TOTAL</b></td>
                                                                <td style="text-align: right;">{{ mataUang($totalNeracaSaldoDebet) }}</td>
                                                                <td style="text-align: right;">{{ mataUang($totalNeracaSaldoKredit) }}</td>
                                                                <td style="text-align: right;">{{ mataUang($totalShuPersen) }} %</td>
                                                                <td style="text-align: right;">{{ mataUang($totalShuDebet) }}</td>
                                                                <td style="text-align: right;">{{ mataUang($totalShuKredit) }}</td>
                                                                <td style="text-align: right;">{{ mataUang($totalNeracaDebet) }}</td>
                                                                <td style="text-align: right;">{{ mataUang($totalNeracaKredit) }}</td>
                                                            </tr>
                                                            <tr>
                                                                <td>&nbsp;</td>
                                                                <td><b>TOTAL SETELAH SHU</b></td>
                                                                <td style="text-align: right;">&nbsp;</td>
                                                                <td style="text-align: right;">&nbsp;</td>
                                                                <td style="text-align: right;">&nbsp;</td>
                                                                <td style="text-align: right;">&nbsp;</td>
                                                                <td style="text-align: right;">&nbsp;</td>
                                                                <td style="text-align: right;">{{ mataUang($totalNeracaDebet) }}</td>
                                                                <td style="text-align: right;">{{ mataUang($totalNeracaKredit) }}</td>
                                                            </tr>
                                                        </tbody>
                                                    </table>
                                                </div>
                                                
                                                @php
                                                    $totalShuFinal = $jumNeracaSaldoLabaRugiKredit;
                                                    $totalBalanceFinal = $totalNeracaDebet - $totalNeracaKredit;
                                                @endphp
                                                <div class="row">
                                                    <div class="col-md-4">
                                                        <div class="form-group">
                                                            {!! Form::label('total_shu', 'Total SHU', ['class' => 'col-lg-4 col-sm-4 control-label']) !!}
                                                            <div class="col-lg-8">
                                                                {!! Form::text('total_shu',  mataUang($totalShuFinal), ['class'=>'form-control', 'readonly'=>true]) !!}
                                                            </div>
                                                        </div>
                                                    </div>
                                                    <div class="col-md-4">
                                                        <div class="form-group">
                                                            {!! Form::label('total_debet', 'Total Debet Dipindahkan', ['class' => 'col-lg-4 col-sm-4 control-label']) !!}
                                                            <div class="col-lg-8">
                                                                {!! Form::text('total_debet', mataUang($totalNeracaDebet), ['class'=>'form-control', 'readonly'=>true]) !!}
                                                            </div>
                                                        </div>
                                                    </div>
                                                    <div class="col-md-4">
                                                        <div class="form-group">
                                                            {!! Form::label('total_kredit', 'Total Kredit Dipindahkan', ['class' => 'col-lg-4 col-sm-4 control-label']) !!}
                                                            <div class="col-lg-8">
                                                                {!! Form::text('total_kredit', mataUang($totalNeracaKredit), ['class'=>'form-control', 'readonly'=>true]) !!}
                                                            </div>
                                                        </div>
                                                    </div>
                                                    <div class="col-md-12 mt-5"></div>
                                                    <div class="col-md-6"></div>
                                                    <div class="col-md-6">
                                                        <div class="form-group">
                                                            {!! Form::label('cek_balance', 'Cek Balance', ['class' => 'col-lg-4 col-sm-4 control-label']) !!}
                                                            <div class="col-lg-8">
                                                                {!! Form::text('cek_balance',  mataUang($totalBalanceFinal), ['class'=>'form-control', 'readonly'=>true]) !!}
                                                            </div>
                                                        </div>
                                                    </div>
                                                </div>
                                            </div>
                                        </div>
                                    </div>
                                    <div class="panel panel-default">
                                        <div class="panel-heading" role="tab" id="headingThree">
                                            <h4 class="panel-title">
                                                <a class="collapsed" data-toggle="collapse" data-parent="#accordion" href="#collapseThree" aria-expanded="false" aria-controls="collapseThree">
                                                    <b>Detail SHU</b>
                                                </a>
                                            </h4> 
                                        </div>
                                        <div id="collapseThree" class="panel-collapse collapse" role="tabpanel" aria-labelledby="headingThree">
                                            <div class="panel-body">
                                                 <div class="table-responsive">
                                                    <table class="table color-table inverse-table table-hover table-condensed">
                                                        <thead>
                                                            <th style="text-align: center;"><b>Nama Alokasi</b></th>
                                                            <th style="text-align: center;"><b>Kode Akun</b></th>
                                                            <th style="text-align: center;"><b>Nama Akun</b></th>
                                                            <th style="text-align: center;"><b>Persen</b></th>
                                                            <th style="text-align: center;"><b>Jumlah (Rp)</b></th>
                                                        </thead>
                                                        <tbody>
                                                            @php
                                                                $jumlahAlokasiShu = 0;

                                                                $totalPresentaseShu = 0;
                                                                $totalRupiahShu = 0;
                                                            @endphp
                                                            @foreach($alokasiShu as $itemAlokasi)
                                                                @php
                                                                    $jumlahAlokasiShu = $totalShuFinal * (hilangTiTik($itemAlokasi->presentase)/100);

                                                                    $totalPresentaseShu += hilangTiTik($itemAlokasi->presentase);
                                                                    $totalRupiahShu += $jumlahAlokasiShu;
                                                                @endphp
                                                                <tr>
                                                                    <td>{{ $itemAlokasi->nama }}</td>
                                                                    <td>{{ $itemAlokasi->tipeAkunDetail->kode }}</td>
                                                                    <td>{{ $itemAlokasi->tipeAkunDetail->nama }}</td>
                                                                    <td style="text-align: right;">{{ $itemAlokasi->presentase }} %</td>
                                                                    <td style="text-align: right;">{{ mataUang($jumlahAlokasiShu) }}</td>
                                                                </tr>
                                                            @endforeach
                                                        </tbody>
                                                    </table>
                                                </div>
                                                

                                                @php
                                                    $alokasiShuAnggota = $totalShuFinal * (hilangTiTik(@$smkShu->btAlokasiShu->presentase)/100);
                                                    $jumlahShuPenyimpan = $alokasiShuAnggota * (hilangTiTik(@$smkShu->presentase_dari_simpanan)/100);
                                                    $jumlahShuPeminjam = $alokasiShuAnggota * (hilangTiTik(@$smkShu->presentase_dari_pinjaman)/100);
                                                    $totalShuAnggota = $jumlahShuPenyimpan + $jumlahShuPeminjam;
                                                @endphp
                                                <div class="row">
                                                     <div class="col-md-6">
                                                         <div class="row">
                                                            <div class="col-md-12">
                                                                <div class="form-group">
                                                                    {!! Form::label('alokasi_shu_anggota', 'Alokasi SHU Anggota', ['class' => 'col-lg-4 col-sm-4 control-label']) !!}
                                                                    <div class="col-lg-8">
                                                                        {!! Form::text('alokasi_shu_anggota',  @$smkShu->btAlokasiShu->nama, ['class'=>'form-control', 'readonly'=>true]) !!}
                                                                    </div>
                                                                </div>
                                                            </div>
                                                            <div class="col-md-12 mt-5">
                                                                <div class="form-group">
                                                                    {!! Form::label('shu_penyimpan', 'SHU Penyimpanan', ['class' => 'col-lg-4 col-sm-4 control-label']) !!}
                                                                    <div class="col-lg-4">
                                                                        {!! Form::text('shu_penyimpan',  @$smkShu->presentase_dari_simpanan.' %', ['class'=>'form-control', 'readonly'=>true]) !!}
                                                                    </div>
                                                                    <div class="col-lg-4">
                                                                        {!! Form::text('shu_penyimpan_2',  mataUang($jumlahShuPenyimpan), ['class'=>'form-control', 'readonly'=>true]) !!}
                                                                    </div>
                                                                </div>
                                                            </div>
                                                            <div class="col-md-12 mt-5">
                                                                <div class="form-group">
                                                                    {!! Form::label('shu_peminjam', 'SHU Peminjam', ['class' => 'col-lg-4 col-sm-4 control-label']) !!}
                                                                    <div class="col-lg-4">
                                                                        {!! Form::text('shu_peminjam',  @$smkShu->presentase_dari_pinjaman.' %', ['class'=>'form-control', 'readonly'=>true]) !!}
                                                                    </div>
                                                                    <div class="col-lg-4">
                                                                        {!! Form::text('shu_peminjam_2',  mataUang($jumlahShuPeminjam), ['class'=>'form-control', 'readonly'=>true]) !!}
                                                                    </div>
                                                                </div>
                                                            </div>
                                                             <div class="col-md-12 mt-5">
                                                                <div class="form-group">
                                                                    {!! Form::label('total_shu_anggota', 'Total SHU Anggota', ['class' => 'col-lg-4 col-sm-4 control-label']) !!}
                                                                    <div class="col-lg-8">
                                                                        {!! Form::text('total_shu_anggota',  mataUang($totalShuAnggota), ['class'=>'form-control', 'readonly'=>true]) !!}
                                                                    </div>
                                                                </div>
                                                            </div>
                                                         </div>
                                                     </div>
                                                     <div class="col-md-1"></div>
                                                     <div class="col-md-5">
                                                        <div class="row">
                                                            <div class="col-md-12">
                                                                <div class="form-group">
                                                                    {!! Form::label('total_presentase', 'Total Presentase', ['class' => 'col-lg-4 col-sm-4 control-label']) !!}
                                                                    <div class="col-lg-8">
                                                                        {!! Form::text('total_presentase',  mataUang($totalPresentaseShu).' %', ['class'=>'form-control', 'readonly'=>true]) !!}
                                                                    </div>
                                                                </div>
                                                            </div>
                                                             <div class="col-md-12 mt-5">
                                                                <div class="form-group">
                                                                    {!! Form::label('total_shu', 'Total SHU', ['class' => 'col-lg-4 col-sm-4 control-label']) !!}
                                                                    <div class="col-lg-8">
                                                                        {!! Form::text('total_shu',  mataUang($totalRupiahShu), ['class'=>'form-control', 'readonly'=>true]) !!}
                                                                    </div>
                                                                </div>
                                                            </div>
                                                        </div>
                                                     </div>
                                                </div>
                                            </div>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                        <!-- /.row -->
                        <div class="clearfix"></div>
                    </div>
                </div>
            </div>
        </div>
    </div>
    <!-- .row -->
@endsection

@section('javascript')
    {{-- <script type="text/javascript">
        $(document).ready(function() {  
            $("#form-ganti-password").validate({
                rules: {
                    password: "required",
                    password2: {
                        required: true,
                        equalTo: password
                    }
                },
                messages: {
                    password: "Kolom password harus diisi",
                    password2: {
                        required: "Kolom Konfirmasi password harus diisi",
                        equalTo: "Konfirmasi password harus sama dengan password baru"
                    }
                }
            });
        });
          
    </script> --}}
@endsection