@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;">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="{{ 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>{{ 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>{{ bcadd(0,$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  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((float)$data['weight_ressel_m']->sum('store_resell_invoice_detail.weight'),4) }}
                                            </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="{{ route('report_cmk_lei.detail', ['brand' => 'The Palace']) }}" style="cursor: pointer;">
                                                    The Palaces
                                                </a>
                                            </td>
                                            <td>{{ number_format($data['cust_tp']->get()->count()) }}</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>{{ bcadd(0,$data['weight_ressel_tp']->sum('store_resell_invoice_detail.weight'),4) }}
                                            </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">{{ bcadd(0,$data['total_w'],4) }}</th>
                                            <th class="text-center">{{ number_format($data['total_v'],2) }}</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">{{ bcadd(0,$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 class="x_title">
                                <h2>DETAIL CMK X LEI</h2>
                                <div div class="clearfix"></div>
                            </div>
                            <div class="col-xs-6">
                                <form id="forms" class="form-horizontal">
                                    
                                    <div class="form-group" style="display: none">
                                        <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" value="{{ $request['search'] }}" class="form-control"
                                                placeholder="Customer">
                                        </div>
                                    </div>

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

                                        <div class="col-xs-12 col-sm-4">
                                            <select class="form-control" value="{{ $request['store'] }}" name="store" id="store">
                                                <option value="">Store</option>
                                            </select>
                                        </div>

                                        {{-- <div class="col-xs-12 col-sm-3">
                                            <select class="form-control" value="{{ $request['jr'] }}" name="jr" id="jr">
                                                <option value="">JR</option>
                                            </select>
                                        </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-3">
                                            <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>

                            {{-- <button class="btn btn-success" id="hide">
                                    <p style="display: inline">Hide Detail</p>
                                </button> --}}
                            <div class="x_content" style="zoom: 0.9;">
                                <table class="table table-bordered table-striped text-center">
                                    <thead>
                                        <tr>
                                            <td 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>
                                        {{-- @if (is_array($data['cust']) || is_object($data['cust'])) --}}
                                        @php
                                            $sum_hitung        = 0;
                                            $sum_berat         = 0;
                                            $sum_harga         = 0;
                                            $sum_resell_cust   = 0;
                                            $sum_resell_berat  = 0;
                                            $sum_resell_rupiah = 0;
                                        @endphp
                                        @foreach ($final_rows as $row)
                                        @php
                                            $sum_hitung += $row['dg_customer'];
                                            $sum_berat += $row['dg_weight'];
                                            $sum_harga += $row['dg_value'];
                                            $sum_resell_cust += $row['rs_customer'];
                                            $sum_resell_berat += $row['rs_weight'];
                                            $sum_resell_rupiah += $row['rs_value'];

                                        @endphp
                                            <tr>
                                                <td class="text-left">
                                                    {{-- <a href="{{ route('report_cmk_lei.jr', ['jr' => $row['code'] ]) }}"> --}}
                                                        {{ $row['code'] }} -  {{ $row['m_nama'] }} 
                                                    {{-- </a> --}}
                                                </td>
                                                <td>
                                                    {{ $row['dg_customer'] }}
                                                </td>
                                                <td>{{ bcadd(0,$row['dg_weight'],4) }} </td>
                                                <td>{{ number_format($row['dg_value']) }} </td>
                                                <td>0</td>
                                                <td>0</td>
                                                <td>0</td>
                                                <td>{{ number_format($row['rs_customer']) }} </td>
                                                <td>{{ bcadd(0,$row['rs_weight'],4) }} </td>
                                                <td>{{ number_format($row['rs_value']) }} </td>
                                                <td>0</td>
                                                <td>0</td>
                                                <td>0</td>
                                            </tr>
                                            @endforeach
                                            <tfoot>
                                                <tr>
                                                    <th class="text-right">TOTAL JUMLAH :</th>
                                                    <th class="text-center">{{ number_format($sum_hitung) }}</th>
                                                    <th class="text-center">{{ number_format((float)$sum_berat,4) }}</th>
                                                    <th class="text-center">{{ number_format($sum_harga) }}</th>
                                                    <th class="text-center">0</th>
                                                    <th class="text-center">0</th>
                                                    <th class="text-center">0</th>
                                                    <th class="text-center">{{ number_format($sum_resell_cust) }}</th>
                                                    <th class="text-center">{{ number_format((float)$sum_resell_berat,4) }}</th>
                                                    <th class="text-center">{{ number_format($sum_resell_rupiah) }}</th>
                                                    <th class="text-center">0</th>
                                                    <th class="text-center">0</th>
                                                    <th class="text-center">0</th>
                                                </tr>
                                            </tfoot>
                                    </tbody>
                                </table>
                            </div>
                        </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>
            $(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