@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;
        }

        .number {
            text-align: right !important;
        }

        .block-tr-type {
            padding: 5px; 
            border-radius: 5px !important; 
            border: 1px solid #ccc;
        }

        .title-type {
            text-align: center; 
            font-weight: bold; 
            font-size: 20px;
        }

        .content-type {
            text-align: center; 
            font-size: 14px;
        }

        .bg-color-type-1 {
            background: #ffcdd2 !important;
        }

        .bg-color-type-22 {
            background: #b3e5fc !important;
        }

        .bg-color-type-29 {
            background: #ffecb3 !important;
        }
    </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 Data Penjualan</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 Data Penjualan</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">Tanggal Mulai</label>
                                    <div class="col-sm-10">
                                        <input id="start" name="date_start" type="text" class="form-control bs-input-datepicker" placeholder="Date Start" required value="{{ $request['start_date'] }}">
                                    </div>
                                </div>

                                <div class="form-group">
                                    <label class="col-sm-2 control-label">Tanggal Selesai</label>
                                    <div class="col-sm-10">
                                        <input id="end" name="date_end" type="text" class="form-control bs-input-datepicker" placeholder="Date End" required value="{{ $request['end_date'] }}">
                                    </div>
                                </div>

                                <div class="form-group">
                                    <label class="col-sm-2 control-label">Tipe Transaksi</label>
                                    <div class="col-sm-10">
                                        <select id="tipe_transaksi" name="tipe_transaksi" class="form-control">
                                            <option value="0" selected>All</option>tipe_transaksi
                                            <option value="1">LE Beli</option>
                                            <option value="22">LE Palace Beli</option>
                                            <option value="29">LE Merchant Beli</option>
                                        </select>
                                    </div>
                                </div>

                                <div class="form-group">
                                    <div class="col-sm-offset-2 col-sm-10">
                                        <button type="submit" id="cari" class="btn btn-default btn-sm"><i class="fa fa-search" aria-hidden="true"></i> Cari</button>
                                        @if(!empty($_GET['date_start']) && !empty($_GET['date_end']))
                                        <a id="download" href="#" class="btn btn-primary btn-sm"><i class="fa fa-download" aria-hidden="true"></i> Unduh Laporan</a>
                                        @endif
                                    </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>
                        @if($sum)
                            <div class="row">
                                <div class="col-md-12">
                                    <div style="margin-left:5px;">
                                        <h5>Total Jumlah Dana : <b>Rp. {{ number_format($sum->total_jumlah_dana) }}</b></h5>
                                        <h5>Total Jumlah Credit : <b>{{ number_format($sum->total_gram, 4) }} Gram</b></h5>
                                    </div>
                                </div>
                            </div>
                            <div class="row" style="margin: 10px;">
                                <div class="col-md-4">
                                    <div class="block-tr-type bg-color-type-1">
                                        <div class="title-type">LE BELI</div>
                                        <div class="content-type">
                                            Total Jumlah Dana : <b>Rp. {{ number_format($sum->total_jumlah_dana_type_1) }}</b><br>
                                            Total Jumlah Credit : <b>{{ number_format($sum->total_gram_type_1, 4) }} Gram</b>
                                        </div>
                                    </div>
                                </div>
                                <div class="col-md-4">
                                    <div class="block-tr-type bg-color-type-22">
                                        <div class="title-type">LE Palace Beli</div>
                                        <div class="content-type">
                                            Total Jumlah Dana : <b>Rp. {{ number_format($sum->total_jumlah_dana_type_22) }}</b><br>
                                            Total Jumlah Credit : <b>{{ number_format($sum->total_gram_type_22, 4) }} Gram</b>
                                        </div>
                                    </div>
                                </div>
                                <div class="col-md-4">
                                    <div class="block-tr-type bg-color-type-29">
                                        <div class="title-type">LE Merchant Beli</div>
                                        <div class="content-type">
                                            Total Jumlah Dana : <b>Rp. {{ number_format($sum->total_jumlah_dana_type_29) }}</b><br>
                                            Total Jumlah Credit : <b>{{ number_format($sum->total_gram_type_29, 4) }} Gram</b>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        @endif
                        <div class="x_content" style="overflow: auto;">
                            <table id="table_artikel" class="table table-condensed table-hover">
                                <thead>
                                    <tr>
                                        <th rowspan="2">No</th>
                                        <th rowspan="2">Code</th>
                                        <th rowspan="2">Tipe Transaksi</th>
                                        <th rowspan="2">Date Approve</th>
                                        <th colspan="2">Customer</th>
                                        <th rowspan="2">Credit</th>
                                        <th rowspan="2">Jumlah Dana</th>
                                        <th colspan="2">Tax</th>
                                        <th colspan="2">Voucher</th>
                                        <th rowspan="2">Total Dana Setor</th>
                                    </tr>
                                    <tr>
                                        <th>Name</th>
                                        <th>Email</th>
                                        <th>%</th>
                                        <th>Nominal</th>
                                        <th>Code</th>
                                        <th>Nominal</th>
                                    </tr>
                                </thead>
                                <tbody>
                                    @if(count($transactions) === 0)
                                    <tr>
                                        <th colspan="13">Tidak ada data</th>
                                    </tr>
                                    @else
                                        @foreach($transactions as $key => $transaction)
                                            @php
                                                $tabungan_transaksi = $transaction->tabungan_transaksi;
                                                $credit = 0;
                                                $jml_dana = 0;
                                                $tax_percent = 0;
                                                $tax_nominal = 0;
                                                $voucher_code = 0;
                                                $voucher_nominal = 0;
                                                $total_dana_setor = 0;
                                                if(count($tabungan_transaksi) > 0) {
                                                    $credit = $tabungan_transaksi[0]->credit;
                                                    $jml_dana = $tabungan_transaksi[0]->jumlah_dana;
                                                    $tax_percent = $tabungan_transaksi[0]->pajak_terhitung;
                                                    $tax_nominal = $tabungan_transaksi[0]->pajak_asli;
                                                    $voucher = $tabungan_transaksi[0]->transaksi_voucher_lakuemasbeli;
                                                    if($voucher) {
                                                        $voucher_code = $voucher->voucher_code;
                                                        $voucher_nominal = $voucher->voucher_nominal;
                                                    }
                                                    $total_dana_setor = $tabungan_transaksi[0]->total_dana_setor;
                                                }

                                                $bg = '';
                                                if($transaction->type === 1) {
                                                    $bg = 'bg-color-type-1';
                                                }
                                                elseif($transaction->type === 22) {
                                                    $bg = 'bg-color-type-22';
                                                }
                                                elseif($transaction->type === 29) {
                                                    $bg = 'bg-color-type-29';
                                                }
                                            @endphp
                                            <tr>
                                                <th>{{ $key + $transactions->firstItem() }}</th>
                                                <td>{{ $transaction->code }}</td>
                                                <td class="{{ $bg }}">{{ $transaction->transaksi_type->type }}</td>
                                                <td>{{ date('d M Y', strtotime($transaction->date_approved)) }}</td>
                                                <td>{{ $transaction->customer ? $transaction->customer->name : '-' }}</td>
                                                <td>{{ $transaction->customer ? $transaction->customer->email : '-' }}</td>
                                                <td class="number">{{ number_format($credit, 4) }}</td>
                                                <td class="number">{{ number_format($jml_dana) }}</td>
                                                <td class="number">{{ $tax_percent }}</td>
                                                <td class="number">{{ number_format($tax_nominal) }}</td>
                                                <td class="number">{{ $voucher_code }}</td>
                                                <td class="number">{{ number_format($voucher_nominal) }}</td>
                                                <td class="number">{{ number_format($total_dana_setor) }}</td>
                                            </tr>
                                        @endforeach
                                    @endif
                                </tbody>
                            </table>

                            <div class="col-md-12">
                                <div style="border: 0px solid #f00; width: 300px; text-align: center; margin: 40px auto 0px !important;">   
                                        @if(count($transactions) > 0)
                                            {{ $transactions->appends(request()->query())->links() }}
                                        @endif
                                </div>
                            </div>
                        </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>
    function do_click() {
        var url = '{{ route("download_laporan_data_penjualan", ["start"=> ":start", "end"=>":end", "tipe_transaksi"=>":tipe_transaksi"]) }}';
        url = url.replace(':start', $("#start").val());
        url = url.replace(':end', $("#end").val());
        url = url.replace(':tipe_transaksi', $("#tipe_transaksi").val());
        $('#download').attr('href', url)
    }

    $(document).ready(function() {
        $('#download').on('click', do_click);

        @if($request['tipe_transaksi'])
            $('#tipe_transaksi').val('{{ $request["tipe_transaksi"] }}');
        @endif
    });
</script>
@endsection