@extends('layouts.layout')
@section('body_class', 'nav-md')
@section('css')
    <style>
        ul {
            margin: 0;
        }

        .custom-box {
            border: 1px solid black;
            margin-top: 75px;
            padding: 20px;
            border-radius: 10px;
        }
    </style>
@endsection
@section('body_content')

    <div class="container body">
        <div class="main_container">
            @include('includes.sidebar')
            <div class="right_col" role="main">
                <div class="container" style="">
                    <div class="col-xs-12">
                        <div class="x_panel">
                            <div class="page-title">
                                <div class="title_left">
                                    <h3>Report</h3>
                                </div>
                                <div class="clearfix"></div>
                            </div>

                            <div class="row" style="margin-top:10px;">
                                <div class="col-xs-6">
                                    <form id="form" class="form-horizontal">

                                        <div class="form-group">
                                            <label class="col-xs-12 col-sm-3 control-label" style="text-align: left;">Date
                                                Start :</label>

                                            <div class="col-xs-12 col-sm-8">
                                                <input id="date_start" name="date_start" value="{{ $request['date_start'] }}"
                                                    type="date" class="form-control" placeholder="Date Start">
                                            </div>
                                        </div>

                                        <div class="form-group">
                                            <label class="col-xs-12 col-sm-3 control-label" style="text-align: left;">Date
                                                End :</label>
                                            <div class="col-xs-12 col-sm-8">
                                                <input id="date_end"  value="{{ $request['date_end'] }}" name="date_end"
                                                    type="date" class="form-control" placeholder="Date End">
                                            </div>
                                        </div>

                                        {{-- <div class="form-group">
                                            <label class="col-xs-12 col-sm-3 control-label" style="text-align: left;">Date
                                                Start :</label>

                                            <div class="col-xs-12 col-sm-9">
                                                <input id="date_start" name="date_start" value="{{ $request['start'] }}"
                                                    type="date" class="form-control" placeholder="Date Start">
                                            </div>
                                        </div>

                                        <div class="form-group">
                                            <label class="col-xs-12 col-sm-3 control-label" style="text-align: left;">Date
                                                End :</label>
                                            <div class="col-xs-12 col-sm-9">
                                                <input id="date_end" value="{{ now()->format('Y-m-d') }}" name="date_end"
                                                    type="date" class="form-control" placeholder="Date End">
                                            </div>
                                        </div> --}}

                                        {{-- <div class="form-group">
                                            <label class="col-xs-12 col-sm-3 control-label"
                                                style="text-align: left;">Customer :</label>
                                            <div class="col-xs-12 col-sm-9">
                                                <input type="text" name="search_" class="form-control"
                                                    placeholder="Customer">
                                            </div>
                                        </div>

                                        <div class="form-group">
                                            <label class="col-xs-12 col-sm-3 control-label" style="text-align: left;">Filter
                                                :</label>
                                            <div class="col-xs-12 col-sm-3">
                                                <select class="form-control" value="{{$request['brand']}}" name="brand" id="brand">
                                                    <option value="">Brand</option>
                                                    @foreach ($brands as $brand)
                                                        <option value="{{ $brand->brand }}"
                                                            @if ($brand->brand == $request['brands']) selected @endif>
                                                            {{ $brand->brand }}</option>
                                                    @endforeach
                                                </select>
                                            </div>
                                            <div class="col-xs-12 col-sm-3">
                                                <select class="form-control" name="store" id="store">
                                                    <option value="">Store</option>
                                                </select>
                                            </div>
                                            <div class="col-xs-12 col-sm-3">
                                                <select class="form-control" name="jr" id="jr">
                                                    <option value="">JR</option>
                                                </select>
                                            </div>
                                        </div> --}}

                                        <div class="form-group">
                                            <div class="col-xs-12 col-sm-offset-2 col-sm-10">
                                                <div class="alert_placeholder"></div>
                                            </div>
                                        </div>

                                        <div class="form-group row">
                                            <label for="buy_price" class="col-sm-3 col-form-label text-right"></label>
                                            <div class="col-sm-6">
                                                <button type="submit" class="btn btn-primary">
                                                    <span><i class="fa fa fa-spinner fa-spin loading hidden"
                                                            aria-hidden="true"></i></span>
                                                    <span class="submit">Search</span>
                                                </button>
                                            </div>
                                        </div>
                                    </form>
                                </div>
                            </div>
                            <div class="x_title">
                                <h2>CMK X LEI</h2>

                                {{-- <button class="btn btn-success" id="detail">
                                        <span style="color: aliceblue">Show Detail</span>
                                    </button> --}}

                                <div class="clearfix"></div>
                            </div>
                            <div class="x_content" style="zoom: 0.9;">
                                <table class="table table-bordered table-striped text-center">
                                    <thead>
                                        <tr>
                                            <td class="text-center bold" rowspan="2">Keterangan</td>
                                            <th colspan="3" class="text-center">Digital Gold</th>
                                            <th colspan="3" class="text-center">Gold Priority</th>
                                            <th colspan="3" class="text-center">Resell</th>
                                            <th colspan="3" class="text-center">Voucher LEI</th>
                                        </tr>
                                        <tr>
                                            <td>Customer</td>
                                            <td>Weight</td>
                                            <td>Value</td>
                                            <td>Customer</td>
                                            <td>Weight</td>
                                            <td>Value</td>
                                            <td>Customer</td>
                                            <td>Weight</td>
                                            <td>Value</td>
                                            <td>Customer</td>
                                            <td>Weight</td>
                                            <td>Value</td>
                                        </tr>
                                    </thead>
                                    <tbody>
                                        <tr>
                                            <td class="text-center">
                                                {{-- <a id="detail" href="/report_cmk_lei/frank-&-co" style="cursor: pointer;">
                                                    Frank & Co
                                                </a> --}}
                                                <a id="detail" href="{{ route('report_cmk_lei.detail', ['brand' => 'FRANK & CO']) }}" style="cursor: pointer;">
                                                    Frank & Co
                                                </a>
                                            </td>
                                            <td>{{ number_format($data['frank_cust']->get()->count()) }}</td>
                                            {{-- <td>{{ number_format($data['frank']->count('transaksi.id')) }}</td> --}}
                                            <td>{{bcadd(0,$data['weight_fc']->sum('tabungan_transaksi.credit'),4) }}
                                            </td>
                                            <td>{{ number_format($data['value_fc']->sum('tabungan_transaksi.total_dana_setor')) }}
                                            </td>
                                            <td>{{ number_format($data['cust_gold_fc']) }}</td>
                                            <td>{{ number_format($data['weight_gold_fc']) }}</td>
                                            <td>{{ number_format($data['value_gold_m']) }}</td>
                                            <td>{{ number_format($data['cust_ressel_fc']->count('lakuemas_butik_2.store_resell_invoice.customer_id')) }}
                                            </td>
                                            <td>{{ number_format((float)$data['weight_ressel_fc']->sum('store_resell_invoice_detail.weight'),4) }}
                                            </td>
                                            <td>{{ number_format($data['value_ressel_fc']->sum('lakuemas_butik_2.store_resell_invoice_detail.price')) }}
                                            </td>
                                            <td>{{ $data['cust_voucher_fc'] }}</td>
                                            <td>{{ $data['weight_voucher_fc'] }}</td>
                                            <td>{{ $data['value_voucher_fc'] }}</td>
                                        </tr>

                                        <tr>

                                            <td class="text-center">
                                                {{-- <a id="detail_tp" href="report_cmk_lei/mondial" style="cursor: pointer;">
                                                    Mondial
                                                </a> --}}
                                                <a id="detail" href="{{ route('report_cmk_lei.detail', ['brand' => 'mondial']) }}" style="cursor: pointer;">
                                                    Mondial
                                                </a>
                                            </td>
                                            <td>{{ number_format($data['cust_mo']->get()->count()) }}</td>
                                            <td>{{ bcadd(0,$data['weight_mo']->sum('tabungan_transaksi.credit'),4) }}
                                            </td>
                                            <td>{{ number_format($data['value_mo']->sum('tabungan_transaksi.total_dana_setor')) }}
                                            </td>
                                            <td>{{ number_format($data['cust_gold_m']) }}</td>
                                            <td>{{ number_format($data['weight_gold_m']) }}</td>
                                            <td>{{ number_format($data['value_gold_m']) }}</td>
                                            <td>{{ number_format($data['cust_ressel_m']->count('lakuemas_butik_2.store_resell_invoice.customer_id')) }}
                                            </td>
                                            <td>{{ number_format($data['weight_ressel_m']->sum('store_resell_invoice_detail.weight_total')) }}
                                            </td>
                                            <td>{{ number_format($data['value_ressel_m']->sum('lakuemas_butik_2.store_resell_invoice_detail.price')) }}
                                            </td>
                                            <td>{{ $data['cust_voucher_m'] }}</td>
                                            <td>{{ $data['weight_voucher_m'] }}</td>
                                            <td>{{ $data['value_voucher_m'] }}</td>
                                        </tr>
                                        <tr>
                                            <td class="text-center">
                                                {{-- <a id="detail_tp" href="/report_cmk_lei/the-palace" style="cursor: pointer;">The
                                                    Palaces</a> --}}
                                                    <a id="detail" href="{{ route('report_cmk_lei.detail', ['brand' => 'The Palace']) }}" style="cursor: pointer;">
                                                        The Palace
                                                    </a>
                                                </td>
                                            <td>{{ number_format($data['cust_tp']->get()->count()) }}</td>
                                            {{-- <td>{{ number_format($data['frank_cust']->count('transaksi.id')) }}</td> --}}
                                            <td>{{ bcadd(0,$data['weight_tp']->sum('tabungan_transaksi.credit'),4) }}
                                            </td>
                                            <td>{{ number_format($data['value_tp']->sum('tabungan_transaksi.total_dana_setor')) }}
                                            </td>
                                            <td>{{ number_format($data['cust_gold_tp']) }}</td>
                                            <td>{{ number_format($data['weight_gold_tp']) }}</td>
                                            <td>{{ number_format($data['value_gold_tp']) }}</td>
                                            <td>{{ number_format($data['cust_ressel_tp']->count('lakuemas_butik_2.store_resell_invoice.customer_id')) }}
                                            </td>
                                            <td>{{ number_format($data['weight_ressel_tp']->sum('store_resell_invoice_detail.weight_total')) }}
                                            </td>
                                            <td>{{ number_format($data['value_ressel_tp']->sum('lakuemas_butik_2.store_resell_invoice_detail.price')) }}
                                            </td>
                                            <td>{{ $data['cust_voucher_m'] }}</td>
                                            <td>{{ $data['weight_voucher_m'] }}</td>
                                            <td>{{ $data['value_voucher_m'] }}</td>
                                        </tr>
                                        <tr>
                                            {{-- DIGITAL GOLD --}}
                                            <th class="text-center">Total</th>
                                            <th class="text-center">{{ number_format($data['total_c']) }}</th>
                                            <th class="text-center">{{ number_format($data['total_w']) }}</th>
                                            <th class="text-center">{{ number_format($data['total_v']) }}</th>

                                            {{-- GOLD PRIORITY --}}
                                            <th class="text-center">{{ number_format($data['total_gold_c']) }}</th>
                                            <th class="text-center">{{ number_format($data['total_gold_w']) }}</th>
                                            <th class="text-center">{{ number_format($data['total_gold_v']) }}</th>

                                            {{-- RESELL --}}
                                            <th class="text-center">{{ number_format($data['total_ressel_c']) }}</th>
                                            <th class="text-center">{{ number_format((float)$data['total_ressel_w'],4) }}</th>
                                            <th class="text-center">{{ number_format($data['total_ressel_v']) }}</th>

                                            {{-- VOUCHER LEI --}}
                                            <th class="text-center">{{ number_format($data['total_voucher_c']) }}</th>
                                            <th class="text-center">{{ number_format($data['total_voucher_w']) }}</th>
                                            <th class="text-center">{{ number_format($data['total_voucher_v']) }}</th>
                                        </tr>
                                    </tbody>
                                </table>
                            </div>
                            

                            </div>
                        </div>
                        @include('includes.footer')
                    </div>
                </div>
                <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js"></script>
                {{-- <script type="text/javascript">
                    $("#detail").click(
                        function() {
                            $("#appear").show();
                        }
                    );
                    $("#detail_m").click(
                        function() {
                            $("#appear_m").show();
                        }
                    );
                    $("#detail_tp").click(
                        function() {
                            $("#appear_tp").show();
                        }
                    );
                    $("#hide").click(
                        function() {
                            $("#appear").hide();
                        }
                    );
                    $("#hide_m").click(
                        function() {
                            $("#appear_m").hide();
                        }
                    );
                    $("#hide_tp").click(
                        function() {
                            $("#appear_tp").hide();
                        }
                    );
                </script> --}}
                <script>
                    $(document).ready(function() {
                        $('#store').on('change', function() {
                            var store = $(this).val();
                            if (store) {
                                $.ajax({
                                    url: '/getSales/' + store,
                                    type: "GET",
                                    data: {
                                        code: store,
                                        "_token": "{{ csrf_token() }}"
                                    },
                                    dataType: "json",
                                    success: function(data) {
                                        if (data) {
                                            $('#jr').empty();
                                            $('#jr').append('<option hidden>JR</option>');
                                            $.each(data, function(key, jr) {
                                                $('select[name="jr"]').append('<option value="' +
                                                    key.code + '">' + jr.nik + " - " + jr.nama +
                                                    // key.code + '">' + jr.nama +
                                                    '</option>');
                                            });
                                        } else {
                                            $('#jr').empty();
                                        }
                                    }
                                });
                            }
                        });
                    });
                    $(document).ready(function() {
                        $('#brand').on('change', function() {
                            var brand = $(this).val();
                            if (brand) {
                                $.ajax({
                                    url: '/getBrand/' + brand,
                                    type: "GET",
                                    data: {
                                        "_token": "{{ csrf_token() }}"
                                    },
                                    dataType: "json",
                                    success: function(data) {
                                        if (data) {
                                            $('#store').empty();
                                            $('#store').append('<option hidden>Store</option>');
                                            $.each(data, function(key, store) {
                                                $('select[name="store"]').append('<option value="' +
                                                    // store.code + '">' +
                                                    // store.m_nama + '</option>');
                                                    store.code + '">' + store.code + " - " +
                                                    store.m_nama + '</option>');
                                            });
                                        } else {
                                            $('#store').empty();
                                        }
                                    }
                                });
                            }
                        });
                    });
                </script>
            @endsection