@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">
                        <h3>Transaksi E-Commerce</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/transaksi_lakuemas/ecommerce_transaksi') }}">Reporting</a></li>
                            <li class="active">Transaksi Lakuemas</li>
                        </ol>
                    </div>
                </div>

                <div class="row">
                    <div class="col-xs-12 col-sm-4">
                        <div class="x_panel">
                            <div class="x_title">Filter</div>
                            <div class="x_content">
                                <form id="form-search" class="form-horizontal">
                                    <div class="form-group">
                                        <label class="col-xs-12 col-sm-4 control-label">Tanggal Mulai :</label>
                                        <div class="col-xs-6 col-sm-8">
                                            <input id="date_start" name="date_start" type="date" class="form-control" value="{{ $request['date_start'] }}" placeholder="Date Start">
                                        </div>
                                    </div>
                                    <div class="form-group">
                                        <label class="col-xs-12 col-sm-4 control-label">Tanggal Selesai :</label>
                                        <div class="col-xs-6 col-sm-8">
                                            <input id="date_end" name="date_end" type="date" class="form-control" value="{{ $request['date_end'] ? $request['date_end'] : now()->toDateString() }}" placeholder="Date End">
                                        </div>
                                    </div>
                                    <div class="form-group">
                                        <label class="col-xs-12 col-sm-4 control-label">E-Commerce :</label>
                                        <div class="col-xs-6 col-sm-8">
                                            <select name="merchant" id="merchant" class="form-control">
                                                <option value="">All</option>
                                                @foreach ($request['merchant_list'] as $data)
                                                    <option value="{{ $data->name }}" @if (request()->merchant == $data->name) selected @endif>
                                                        {{ $data->name }}
                                                    </option>
                                                @endforeach
                                            </select>
                                        </div>
                                    </div>
                                    <div class="form-group">
                                        <label class="col-xs-12 col-sm-4 control-label">Search :</label>
                                        <div class="col-xs-6 col-sm-8">
                                            <input name="search" class="form-control" value="{{ request('search') }}">
                                        </div>
                                    </div>
                                    <div class="form-group" style="margin-top:20px">
                                        <div class="col-xs-12 col-sm-8 col-sm-offset-4">
                                            <button type="submit" name="btn_search" class="btn btn-primary btn-search">
                                                <i class="fa fa-search"></i> Search
                                            </button>
                                        </div>
                                    </div>
                               {{-- </form> --}} 
                            </div>
                        </div>
                    </div>
                    <div class="col-xs-12 col-sm-8">
                        {{-- </form> --}}
                            <div class="x_panel" style="overflow-x: auto; width: 100%;">
                                <div style="font-size: 12px; padding-top: 2px;">
                                    <div class="form-group">
                                        <label>Tahun :</label>
                                        <select name="year">
                                            @foreach ($year_dynamic as $yr)
                                                <option value="{{ $yr }}" {{ $yr == $request['year'] ? 'selected' : '' }}>{{ $yr }}</option>
                                            @endforeach
                                        </select>
                                        {{--<button type="submit" name="btn_search" value="search_1" class="btn btn-primary btn-search">
                                            <i class="fa fa-search"></i> Search
                                        </button>--}}
                                    </div>
                                    <table class="table table-bordered table-striped">
                                        <thead>
                                            <tr>
                                                <th class="text-center">E-Commerce</th>
                                                @foreach (["Januari", "Februari", "Maret", "April", "Mei", "Juni", "Juli", "Agustus", "September", "Oktober", "November", "Desember"] as $month)
                                                    <th class="text-center">{{ $month }}</th>
                                                @endforeach
                                                <th class="text-center">Total</th>
                                            </tr>
                                        </thead>
                                        <tbody>
                                        @php
                                            $months = ["January", "February", "March", "April", "May", "June", "July", "August", "September", "October", "November", "December"];
                                            $total = array_fill_keys($months, 0);
                                        @endphp

                                        @foreach($sales_order_header as $row)
                                            @php
                                                $total_ecommerce = 0;
                                            @endphp
                                            <tr>
                                                <td class="text-center">{{ $row->{"E-commerce"} }}</td>
                                                @foreach ($months as $month)
                                                    <td class="text-right">{{ number_format($row->$month, 0) }}</td>
                                                    @php
                                                        $total[$month] += $row->$month;
                                                        $total_ecommerce += $row->$month;
                                                    @endphp
                                                @endforeach
                                                <td class="text-right" style="font-weight: bold; background:#6ef081;">
                                                    {{ number_format($total_ecommerce, 0) }}
                                                </td>
                                            </tr>
                                        @endforeach
                                        <tr style="font-weight:bold; background:#dfefff;">
                                            <td class="text-center">TOTAL</td>
                                            @foreach ($months as $month)
                                                <td class="text-right">{{ number_format($total[$month], 0) }}</td>
                                            @endforeach
                                            <td class="text-right">
                                                {{ number_format(array_sum($total), 0) }}
                                            </td>
                                        </tr>
                                    </tbody>
                                    </table>
                                </div>
                            </div>
                        </form>
                    </div>
                </div>
                <div class="x_content" style="zoom: 0.9; overflow: auto;">
                    <table class="table table-bordered table-striped">
                        <thead>
                            <tr>
                                <th class="text-center">No</th>
                                <th class="text-center">Tanggal Transaksi</th>
                                <th class="text-center">Name E-Commerce</th>
                                <th class="text-center">Nomor Invoice</th>
                                <th class="text-center">Total Penjualan</th>
                                <th class="text-center">Qty Item</th>
                            </tr>
                        </thead>
                        <tbody>
                            @if(request()->query()) 
                                @if ($sales_order_summarys->isNotEmpty())
                                    @php $number = $sales_order_summarys->firstItem(); @endphp
                                    @foreach ($sales_order_summarys as $data)
                                        <tr>
                                            <td class="text-center">{{ $number++ }}</td>
                                            <td class="text-center">{{ $data->order_datetime }}</td>
                                            <td class="text-center">{{ $data->name }}</td>
                                            <td class="text-center">{{ $data->order_number }}</td>
                                            <td class="text-right">Rp {{ number_format($data->total_rupiah, 0, ',', '.') }}</td>
                                            <td class="text-right">{{ $data->total_qty }}</td>
                                        </tr>
                                    @endforeach
                                @else
                                    <tr>
                                        <td colspan="6" class="text-center">Data tidak ditemukan</td>
                                    </tr>
                                @endif
                            @else
                                <tr>
                                    <td colspan="6" class="text-center">Data belum dipilih</td>
                                </tr>
                            @endif
                        </tbody>
                    </table>
                    @if(request()->query() && $sales_order_summarys->isNotEmpty())
                        <div class="d-flex justify-content-center">
                            {{ $sales_order_summarys->appends(request()->query())->links() }}
                        </div>
                    @endif
                </div>
            </div>
        </div>
    </div>
@endsection