@extends('layouts.layout')

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

@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">
                        <div class="row">
                            <div class="col-xs-6 col-sm-6 col-md-6">
                                <h2 class="title-dashboard text-left">
                                    <h3>Month Report</h3>
                                </h2>
                            </div>
                            <div class="clearfix"></div>
                        </div>
                    </div>
                </div>
                <style>
                    .bottom-align {
                        vertical-align: bottom;
                    }
                </style>

                <div class="row">
                    <div class="col-xs-12 col-sm-12">

                        <div class="x_title">
                            Filter
                            <div class="x_panel">
                                <div class="x_content">
                                    <form>
                                        <div class="row">
                                            <div class="col-md-2">
                                                <label for="periode">Periode :</label>
                                                <select name="periode" id="periode" class="form-control">
                                                    <option value="">-- Pilih Periode --</option>
                                                    @foreach (range(date('Y'), date('Y')) as $year)
                                                        @foreach (range(1, 12) as $m)
                                                            @php
                                                                $formattedMonth = str_pad($m, 2, '0', STR_PAD_LEFT);
                                                                $period = $year . '-' . $formattedMonth;
                                                            @endphp
                                                            <option value="{{ $period }}"
                                                                {{ request('periode') == $period ? 'selected' : '' }}>
                                                                {{ date('F', mktime(0, 0, 0, $m, 1)) }} {{ $year }}
                                                            </option>
                                                        @endforeach
                                                    @endforeach
                                                </select>
                                            </div>
                                            <div class="col-md-1">
                                                <label>&nbsp;</label>
                                                <button type="submit" class="btn btn-primary btn-block">Filter</button>
                                            </div>
                                        </div>
                                    </form>
                                </div>
                            </div>
                        </div>
                    </div>
                    <div class="col-xs-12">
                        <div class="x_panel">
                            <div class="form-group">
                                <p>
                                    <a class="btn btn-success" data-toggle="collapse" href="#collapseExample" role="button"
                                        aria-expanded="false" aria-controls="collapseExample">
                                        Log Download
                                    </a>
                                </p>
                                <div class="collapse" id="collapseExample">
                                    <div class="card card-body">
                                        <table id="myTable" class="table table-bordered table-striped"
                                            style="zoom: 0.75;">
                                            <thead>
                                                <tr>
                                                    <th class="text-center">Periode</th>
                                                    <th class="text-center">Type Dokumen</th>
                                                    <th class="text-center">File Name</th>
                                                    <th class="text-center">Action</th>
                                                </tr>
                                            </thead>
                                            <tbody id="load_summary_customer">
                                                @foreach ($download_file as $data)
                                                    <tr>
                                                        <td class="text-left">{{ $data->created_at }}</td>
                                                        <td class="text-left">
                                                            @if (\Illuminate\Support\Str::contains($data->file_name, 'summary_stock_detail'))
                                                                Detail
                                                            @else
                                                                Summary
                                                            @endif
                                                        </td>
                                                        <td class="text-left">{{ $data->file_name }}</td>
                                                        <td class="text-center">
                                                            <a href="{{ env('ALIYUN_OSS_IMAGE_URL') . '/download_file/' . $data->file_name }}" 
                                                                class="btn btn-success" 
                                                                target="_blank">
                                                                Download
                                                             </a>
                                                        </td>
                                                </tr>
                                                @endforeach
                                            </tbody>
                                        </table>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>

                    <div class="row">
                        <div class="col-xs-12 col-sm-12">
                            <div class="x_panel">
                                <div class="x_content">
                                    <table id="table" class="table table-bordered table-striped">
                                        <thead>
                                            <tr>
                                                <th class="text-left">No</th>
                                                <th class="text-left">Tahun</th>
                                                <th class="text-left">Bulan</th>
                                                <th class="text-center">Lokasi</th>
                                                <th class="text-center">Brand</th>
                                                <th class="text-center">Pecahan</th>
                                                <th class="text-center">Qty</th>
                                                <th class="text-center">Total</th>
                                            </tr>
                                        </thead>
                                        <tbody>
                                            @php
                                                $sumQty = 0;
                                                $sumTotal = 0;
                                                $no = 1;
                                            @endphp

                                            @foreach ($summary_history as $data)
                                                @php
                                                    $sumQty += $data->total;
                                                    $sumTotal += $data->pecahan * $data->total;
                                                @endphp
                                                <tr>
                                                    <td class="text-center">{{ $no++ }}</td>
                                                    <td class="text-left">{{ date('Y', strtotime($data->periode . '-01')) }}</td>
                                                    <td class="text-left">
                                                        {{ date('F', strtotime($data->periode . '-01')) }}</td>
                                                    <td class="text-center">{{ $data->group_lokasi }}</td>
                                                    <td class="text-center">{{ $data->brand_emas }}</td>
                                                    <td class="text-center">{{ $data->pecahan }}</td>
                                                    <td class="text-center">{{ $data->total }}</td>
                                                    <td class="text-center">{{ $data->pecahan * $data->total }}</td>
                                                </tr>
                                            @endforeach

                                            <tr>
                                                <td colspan="5" class="text-center"><strong>Total</strong></td>
                                                <td class="text-center"><strong>{{ number_format($sumQty) }}</strong></td>
                                                <td class="text-center">
                                                    <strong>{{ number_format($sumTotal, 2, ',', '.') }}</strong></td>
                                            </tr>
                                        </tbody>
                                    </table>

                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
@endsection

@section('scripts')
    <script>
        $(document).ready(function() {
            $('#myTable').DataTable({
                searching: false,
                lengthChange: false,
                pageLength: 5,
                order: [
                    [0, 'desc']
                ]
            });
        });
        $(document).ready(function() {

            $('#brand').on('change', function() {
                updateItemDropdown($(this).val());
            });

            updateItemDropdown($('#brand').val());

            $('#actual_groups').on('change', function() {
                updateTokoDropdown($(this).val());
            });

            updateTokoDropdown($('#actual_groups').val());
        });

        function updateItemDropdown(brandId) {
            $.ajax({
                url: '/summary_stock/' + brandId,
                type: "GET",
                data: {
                    "_token": "{{ csrf_token() }}"
                },
                dataType: "json",
                success: function(data) {
                    if (data) {
                        $('#item').empty();
                        $('#item').append('<option value="">-- Pilih Item --</option>');
                        $.each(data, function(key, emas) {
                            $('select[name="item"]').append('<option value="' +
                                emas.id + '">' + emas.pecahan + " Gram " +
                                '</option>');
                        });
                    } else {
                        $('#item').empty();
                    }
                }
            });
        }

        function updateTokoDropdown(actualGroups) {
            $.ajax({
                url: '/summary_stock_location/' + actualGroups,
                type: "GET",
                data: {
                    "_token": "{{ csrf_token() }}"
                },
                dataType: "json",
                success: function(data) {
                    if (data) {
                        $('#toko').empty();
                        $('#toko').append('<option value="">-- Pilih toko --</option>');
                        $.each(data, function(key, toko) {
                            $('select[id="toko"]').append('<option value="' +
                                toko.code + '">' + toko.name +
                                '</option>');
                        });
                    } else {
                        $('#toko').empty();
                    }
                }
            });
        }
    </script>
@endsection