@extends('layouts.layout')

@section('body_class', 'nav-md')

@section('css')
    <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/bootstrap-datepicker/1.7.1/css/bootstrap-datepicker.min.css" />
    <style type="text/css">

        table, th { 
          text-align: center !important;
        }

        tfoot tr th {
            text-align: right !important;
        }
    </style>

    <style>
        table, td, th {  
          border: 1px solid #ddd;
          text-align: left;
        }

        table {
          border-collapse: collapse;
          width: 100%;
        }

        th, td {
          padding: 15px;
        }
    </style>
@endsection

@section('body_content')
<div class="container body">
    <div class="main_container">
        @include('includes.sidebar')
        <div class="right_col" role="main">
            <div class="page-title">
                <div class="title_left">
                    <h3>Laporan Semua Transaksi</h3>
                </div>
                <div class="clearfix"></div>
            </div>

            <div class="row">
                <div class="col-xs-12">
                    <ol class="breadcrumb">
                        <li><a href="{{ url('/dashboard') }}">Home</a></li>
                        <li><a href="{{ url('/reporting/generate') }}">Reporting</a></li>
                        <li class="active">Laporan Semua Transaksi</li>
                    </ol>
                </div>

                <div class="col-xs-12">
                    <div class="x_panel">
                        <div class="x_title">
                            <h2>Filter</h2>
                            <ul class="nav navbar-right panel_toolbox">
                                <li><a class="collapse-link"><i class="fa fa-chevron-up"></i></a></li>
                            </ul>
                            <div class="clearfix"></div>
                        </div>
                        <div class="x_content">
                            <form id="form_filter" class="form-horizontal">
                                <div class="form-group">
                                    <label class="col-sm-2 control-label">Mulai</label>
                                    <div class="col-sm-10">
                                        <select name="bulan_mulai" id="bulan_mulai" class="form-control" onchange="bulanMulai()" style="width: 120px; float:left; margin-right:3px;">
                                            <option value="01" selected>Januari</option>
                                            <option value="02">Februari</option>
                                            <option value="03">Maret</option>
                                            <option value="04">April</option>
                                            <option value="05">Mei</option>
                                            <option value="06">Juni</option>
                                            <option value="07">Juli</option>
                                            <option value="08">Agustus</option>
                                            <option value="09">September</option>
                                            <option value="10">Oktober</option>
                                            <option value="11">November</option>
                                            <option value="12">Desember</option>
                                        </select>
                                        <input name="tahun_mulai" id="tahun_mulai" type="number" class="form-control" placeholder="Tahun" value="{{ date('Y') }}" required value="{{ $request['tahun_mulai'] }}" style="width:100px;" onkeyup="tahunMulai()">
                                    </div>
                                </div>

                                <div class="form-group">
                                    <label class="col-sm-2 control-label">Sampai</label>
                                    <div class="col-sm-10">
                                        <input type="text" id="bulan_sampai_desc" class="form-control" style="width: 120px; float:left; margin-right:3px;" value="Maret" readonly>
                                        <input type="hidden" name="bulan_sampai" id="bulan_sampai" value="03">
                                        <input name="tahun_sampai" id="tahun_sampai" type="number" class="form-control" placeholder="Tahun" value="{{ date('Y') }}" required value="{{ $request['tahun_mulai'] }}" style="width:100px;" readonly>
                                    </div>
                                </div>

                                <div class="form-group">
                                    <div class="col-sm-offset-2 col-sm-10">
                                        <button type="submit" class="btn btn-default"><i class="fa fa-search"></i> Cari</button>
                                    </div>
                                </div>
                            </form>
                        </div>
                    </div>
                </div>

                <div class="col-xs-12">
                    <div class="x_panel">
                        <div class="x_title">
                            <h2>Data</h2>
                            <div class="clearfix"></div>
                        </div>
                        <div class="x_content" style="overflow: auto;">
                            <table id="table_artikel" class="table table-condensed">
                                <thead>
                                    <tr>
                                        <th rowspan="2">No</th>
                                        <th rowspan="2">Bulan</th>
                                        <th colspan="2" align="center">Transaksi Beli</th>
                                        <th colspan="2" align="center">Transaksi Redeem</th>
                                        <th colspan="2" align="center">Transaksi Jual Emas</th>
                                        <th colspan="2" align="center">Transaksi Tukar Gramasi</th>
                                        <th colspan="4">Customer</th>
                                    </tr>
                                    <tr>
                                        <th>Unique</th>
                                        <th>Not Unique</th>
                                        <th>Unique</th>
                                        <th>Not Unique</th>
                                        <th>Unique</th>
                                        <th>Not Unique</th>
                                        <th>Unique</th>
                                        <th>Not Unique</th>
                                        <th>Penambahan</th>
                                        <th>Akumulasi</th>
                                        <th>Customer Aktif Akumulatif</th>
                                        <th>Customer aktif perbulan</th>
                                    </tr>
                                </thead>
                                <tbody>
                                    @php
                                        $beli_unique = 0;
                                        $beli_unique_not = 0;
                                        $beli_unique_not_gram = 0;
                                        $redeem_unique = 0;
                                        $redeem_unique_not = 0;
                                        $redeem_unique_not_gram = 0;
                                        $jual_unique = 0;
                                        $jual_unique_not = 0;
                                        $jual_unique_not_gram = 0;
                                        $tukar_unique = 0;
                                        $tukar_unique_not = 0;
                                        $tukar_unique_not_gram = 0;
                                        $register_add = 0;
                                        $register_total = 0;
                                        $register_customer_aktif_akumulatif = 0;
                                        $register_customer_aktif_perbulan = 0;
                                    @endphp
                                    @foreach($result as $key => $list)
                                        <tr>
                                            <td>{{ $key + 1 }}</td>
                                            <td style="text-align: left;">
                                                {{ date("F Y", strtotime($list['month'] . '-01')) }}
                                                {{-- <div style="width: 120px; border: 0px solid #f00; margin: 0 -10px;"></div> --}}
                                            </td>
                                            <td style="text-align: right;">{{ $list['transaksi']['beli']['unique'] }}</td>
                                            <td style="text-align: right;">{{ $list['transaksi']['beli']['not_unique'] }} ({{ $list['transaksi']['beli']['not_unique_gram'] ? : 0}} Gram)</td>
                                            <td style="text-align: right;">{{ $list['transaksi']['redeem']['unique'] }}</td>
                                            <td style="text-align: right;">{{ $list['transaksi']['redeem']['not_unique'] }} ({{ $list['transaksi']['redeem']['not_unique_gram'] ? : 0}} Gram)</td>
                                            <td style="text-align: right;">{{ $list['transaksi']['jual']['unique'] }}</td>
                                            <td style="text-align: right;">{{ $list['transaksi']['jual']['not_unique'] }} ({{ $list['transaksi']['jual']['not_unique_gram'] ? : 0}} Gram)</td>
                                            <td style="text-align: right;">{{ $list['transaksi']['tukar']['unique'] }}</td>
                                            <td style="text-align: right;">{{ $list['transaksi']['tukar']['not_unique'] }} ({{ $list['transaksi']['tukar']['not_unique_gram'] ? : 0}} Gram)</td>
                                            <td style="text-align: right;">{{ $list['customer_register']['penambahan'] }}</td>
                                            <td style="text-align: right;">{{ $list['customer_register']['total'] }}</td>
                                            <td style="text-align: right;">{{ $list['customer_register']['customer_aktif_akumulatif'] }}</td>
                                            <td style="text-align: right;">{{ $list['customer_register']['customer_aktif_perbulan'] }}</td>
                                        </tr>
                                        @php
                                            $beli_unique += $list['transaksi']['beli']['unique'];
                                            $beli_unique_not += $list['transaksi']['beli']['not_unique'];
                                            $beli_unique_not_gram += $list['transaksi']['beli']['not_unique_gram'] ? : 0;
                                            $redeem_unique += $list['transaksi']['redeem']['unique'];
                                            $redeem_unique_not += $list['transaksi']['redeem']['not_unique'];
                                            $redeem_unique_not_gram += $list['transaksi']['redeem']['not_unique_gram'] ? : 0;
                                            $jual_unique += $list['transaksi']['jual']['unique'];
                                            $jual_unique_not += $list['transaksi']['jual']['not_unique'];
                                            $jual_unique_not_gram += $list['transaksi']['jual']['not_unique_gram'] ? : 0;
                                            $tukar_unique += $list['transaksi']['tukar']['unique'];
                                            $tukar_unique_not += $list['transaksi']['tukar']['not_unique'];
                                            $tukar_unique_not_gram += $list['transaksi']['tukar']['not_unique_gram'] ? : 0;
                                            $register_add += $list['customer_register']['penambahan'];
                                            $register_total = $list['customer_register']['total'];
                                            $register_customer_aktif_akumulatif = $list['customer_register']['customer_aktif_akumulatif'];
                                            $register_customer_aktif_perbulan = $list['customer_register']['customer_aktif_perbulan'];
                                        @endphp
                                    @endforeach
                                    @if(count($result) === 0)
                                        <tr>
                                            <td colspan="13" align="middle">Tidak ditemukan data</td>
                                        </tr>
                                    @endif
                                </tbody>
                                @if(count($result) > 0)
                                <tfoot>
                                    <tr>
                                        <th colspan="2">TOTAL</th>
                                        <th>{{ $beli_unique }}</th>
                                        <th>{{ $beli_unique_not }} ({{ $beli_unique_not_gram }} Gram)</th>
                                        <th>{{ $redeem_unique }}</th>
                                        <th>{{ $redeem_unique_not }} ({{ $redeem_unique_not_gram }} Gram)</th>
                                        <th>{{ $jual_unique }}</th>
                                        <th>{{ $jual_unique_not }} ({{ $jual_unique_not_gram }} Gram)</th>
                                        <th>{{ $tukar_unique }}</th>
                                        <th>{{ $tukar_unique_not }} ({{ $tukar_unique_not_gram }} Gram)</th>
                                        <th>{{ $register_add }}</th>
                                        <th>{{ $register_total }}</th>
                                        <th>{{ $register_customer_aktif_akumulatif }}</th>
                                        <th>{{ $register_customer_aktif_perbulan }}</th>
                                    </tr>
                                </tfoot>
                                @endif
                            </table>
                        </div>
                    </div>
                </div>
            </div>
        </div>
        @include('includes.footer')
    </div>
</div>
@endsection

@section('scripts')
<script src="https://cdnjs.cloudflare.com/ajax/libs/bootstrap-datepicker/1.7.1/js/bootstrap-datepicker.min.js"></script>
<script src="{{ url('js/reporting/laporan_pembukaan_rekening.min.js') }}"></script>
<script>

    let bulan = {
        '01':'Januari',
        '02':'Februari',
        '03':'Maret',
        '04':'April',
        '05':'Mei',
        '06':'Juni',
        '07':'Juli',
        '08':'Agustus',
        '09':'September',
        '10':'Oktober',
        '11':'November',
        '12':'Desember'
    };
    $(document).ready(function() {
        @if(isset($_GET['bulan_mulai']) && 
            isset($_GET['tahun_mulai']) && 
            isset($_GET['bulan_sampai']) && 
            isset($_GET['tahun_sampai']))
        $('#bulan_mulai').val('{{ $_GET['bulan_mulai'] }}');
        $('#tahun_mulai').val('{{ $_GET['tahun_mulai'] }}');
        $('#bulan_sampai').val('{{ $_GET['bulan_sampai'] }}');
        $('#tahun_sampai').val('{{ $_GET['tahun_sampai'] }}');
        @endif
    });



    function bulanMulai() {
        let bulan_mulai = $('#bulan_mulai').val();
        let bulan_sampai = parseInt(bulan_mulai) + 2;
        let tahun_mulai = $('#tahun_mulai').val();
        let tahun_sampai = tahun_mulai;
        if(bulan_sampai > 12) {
            bulan_sampai = bulan_sampai - 12;
            $('#bulan_sampai_desc').val(bulan['0' + bulan_sampai]);
            $('#bulan_sampai').val('0' + bulan_sampai);
            $('#tahun_sampai').val(parseInt(tahun_sampai) + 1);
        }
        else {
            if(parseInt(bulan_sampai) >= 10) {
                $('#bulan_sampai_desc').val(bulan[bulan_sampai]);
                $('#bulan_sampai').val(bulan_sampai);
            }
            else {
                $('#bulan_sampai_desc').val(bulan['0' + bulan_sampai]);                
                $('#bulan_sampai').val('0' + bulan_sampai);                
            }
            $('#tahun_sampai').val(tahun_sampai);
        }
    }

    function tahunMulai() {
        let tahun_mulai = $('#tahun_mulai').val();
        $('#tahun_sampai').val(tahun_mulai);
        $('#bulan_sampai_desc').val(bulan[$('#bulan_mulai').val()]);
    }
</script>
@endsection