@extends('layouts/app')
@section('css')
    <style type="text/css" nonce="{{ csp_nonce() }}">
      .amount {
        text-align: right;
      }
    </style>
@stop
@section('content')
    <div class="content-header">
        <div class="container-fluid">
            <div class="row mb-2">
                <div class="col-sm-4">
                    <!-- <h1 class="m-0">Starter Page</h1> -->
                </div>
                <div class="col-sm-8">
                    <ol class="breadcrumb float-sm-right">
                        <li class="breadcrumb-item">Reports</li>
                        <li class="breadcrumb-item"><a href="{{ route('reports.operatingHourSale') }}">Operating Hours Sales by Branch</a></li>
                    </ol>
                </div>
            </div>
        </div>
    </div>
    <div class="content">
        <div class="container-fluid">
            <div class="row">
                <div class="col-12">
                    <div class="card">
                        <div class="container mt-3">
                            <form action="{{ route('reports.operatingHourSale') }}" method="post">
                                @csrf
                                <div class="row">
                                    <div class="col-sm">
                                        <div class="form-group">
                                            <label class="control-label">Region</label>
                                            <div class='input-group'>
                                                @php 
                                                    $region = Config('config.region.value'); 
                                                @endphp
                                                @if (Auth::user()->userIsHQBranchs())
                                                    <select class="form-control" id="region" name="region">
                                                        <option value="" selected>--All--</option>
                                                        @foreach ($region as $key => $rg)
                                                        <option value="{{ $key }}" {{ $key == ($_POST['region'] ?? '') ? 'selected' : '' }}>{{ $rg['name'] }}</option>
                                                        @endforeach
                                                    </select>
                                                @else
                                                    <select class="form-control" name="region">
                                                        @foreach ($branch_region as $key)
                                                        <option value="{{ $key }}" {{ $key == ($_POST['region'] ?? '') ? 'selected' : '' }}>{{ $region[$key]['name'] }}</option>
                                                        @endforeach
                                                    </select>
                                                @endif
                                            </div>
                                        </div>
                                    </div>
                                    <div class="col-sm">
                                        <div class="form-group">
                                            <label class="control-label">Branch</label>
                                            <div class='input-group'>
                                                @if (Auth::user()->userIsHQBranchs())
                                                    <select class="form-control" name="branch_id">
                                                        @if (!empty($branches))
                                                            <option value="" selected>--All--</option>
                                                            @foreach ($branches as $branch)
                                                                <option value="{{ $branch->id }}"
                                                                    {{ $branch->id == ($_POST['branch_id'] ?? '') ? 'selected' : '' }}>
                                                                    {{ $branch->code }}</option>
                                                            @endforeach
                                                        @endif
                                                    </select>
                                                @else
                                                    <select class="form-control" name="branch_id">
                                                        <option value="{{ Session::get('branch')->id }}">
                                                            {{ Session::get('branch')->code }}
                                                        </option>
                                                    </select>
                                                @endif
                                            </div>
                                        </div>
                                    </div>
                                    <div class="col-sm">
                                        <div class="form-group">
                                            <label class="control-label">From Date</label>
                                            <div class="input-group date datetimepicker" id="datetimepicker1">
                                                <input type='date' value="{{ $_POST['from_date'] ?? date('Y-m-d', strtotime('-1 month')) }}"
                                                    class="form-control" name="from_date" id="from_date" max="{{date('Y-m-d')}}"/>
                                                <span class="input-group-addon">
                                                    <span class="glyphicon glyphicon-calendar"></span>
                                                </span>
                                            </div>
                                        </div>
                                    </div>
                                    <div class="col-sm">
                                        <div class="form-group">
                                            <label class="control-label">End Date</label>
                                            <div class="input-group date datetimepicker" id="datetimepicker2">
                                                <input type='date' value="{{ $_POST['end_date'] ?? date('Y-m-d') }}"
                                                    class="form-control" id="end_date" name="end_date" max="{{date('Y-m-d')}}"/>
                                                <span class="input-group-addon">
                                                    <span class="glyphicon glyphicon-calendar"></span>
                                                </span>
                                            </div>
                                        </div>
                                    </div>
                                    <div class="col-sm">
                                        <div class="form-group">
                                            <label class="control-label"><span class="right badge badge-light"><a
                                                        href="{{ route('reports.operatingHourSale') }}">clear <i
                                                            class="fa-solid fa-rotate-right"></i></a></span></label>
                                            <div class='input-group'>
                                            <button type="submit" class="btn btn-success">Show report</button>
                                            </div>
                                        </div>
                                    </div>
                                    <div class="col-sm">
                                        <div class="form-group">
                                            <div class='input-group mb-1'>
                                                <a href="{{ route('reports.downloadOperatingHourSale', [
                                                    'from_date' => $_POST['from_date'] ?? '',
                                                    'end_date' => $_POST['end_date'] ?? '',
                                                    'branch_id' => $_POST['branch_id'] ?? '',
                                                    'region' => $_POST['region'] ?? '',
                                                ]) }}"
                                                    class="btn btn-outline-success"><strong><i class="fa fa-file-excel-o"
                                                    aria-hidden="true"></i></strong>
                                                    Export</a>
                                            </div>
                                            <div class='input-group'>
                                                <a href="{{ route('reports.downloadOperatingHourSalePDF', [
                                                    'from_date' => $_POST['from_date'] ?? '',
                                                    'end_date' => $_POST['end_date'] ?? '',
                                                    'branch_id' => $_POST['branch_id'] ?? '',
                                                    'region' => $_POST['region'] ?? '',
                                                ]) }}"
                                                    class="btn btn-outline-success"><strong><i class="fa fa-file-excel-o"
                                                    aria-hidden="true"></i></strong>
                                                    Export PDF</a>
                                            </div>
                                        </div>
                                    </div>
                                </div>
                            </form>
                        </div>
                        @if (Session::has('error'))
                            <div class="alert alert-warning alert-dismissible">
                                <button type="button" class="close" data-dismiss="alert" aria-hidden="true">×</button>
                                <h5><i class="icon fas fa-check"></i> Note:</h5>
                                @foreach(Session::get('error') as $err)
                                    {{ $err }}<br>
                                @endforeach
                                @php
                                    Session::forget('error');
                                @endphp
                            </div>
                        @endif

                        <div class="card-body table-responsive p-0">
                            @if (!empty($reports))
                                <table class="table table-hover text-nowrap">
                                    <tbody>
                                        @foreach ($reports as $key => $report)
                                        <tr>
                                            <td colspan="5" class="font-weight-bold">{{ $key }}</td>
                                        </tr>
                                        <tr>
                                            <td>Terminal ID</td>
                                            <td>Date</td>
                                            <td>Day</td>
                                            <td>Sign on</td>
                                            <td>Sign off</td>
                                            <td>Sales</td>
                                        </tr>
                                        @foreach ($report as $rep)
                                        @php
                                            $day = \Carbon\Carbon::parse($rep['date'])->format('l');
                                        @endphp
                                        <tr>
                                            <td>{{ $rep['terminal'] }}</td>
                                            <td>{{ $rep['date'] }}</td>
                                            <td>{{ $day }}</td>
                                            <td><span class="text-danger">{{ ($rep['is_late_signon'] && $day != 'Thursday') ? '*' : '' }}</span> {{ $rep['signon'] ? $rep['signon'] : '*---:---'}}</td>
                                            <td><span class="text-danger">{{ ($rep['is_early_signoff'] && $day != 'Thursday') ? '#' :'' }}</span> {{ $rep['signoff'] ? $rep['signoff'] : '#---:---' }}</td>
                                            <td class="amount">{{ number_format($rep['amount'],2,'.',',') }}</td>
                                        </tr>
                                        @endforeach
                                        @endforeach
                                    </tbody>
                                </table>
                            @else
                                <p class="text-center">No data found</p>
                            @endif
                            <div class="card-body table-responsive p-4">
                            <table>
                                <tr>
                                    <td colspan="5">Note:<br>
                                        [ * ] = SSK late Sign On [ # ] = SSK early Sign off<br>
                                        [ --:-- ] = SSK not Sign On / Sign Off
                                    </td>
                                </tr>
                                <tr>
                                    <td colspan="5"><br>Please refer to Agency Operating Hours as follow:<br>
                                        <table class="table-sm table-bordered">
                                            <tr>
                                                <th>Day</th>
                                                <th>Operating hours</th>
                                                <th>Things to note</th>
                                            </tr>
                                            <tr>
                                                <td>Monday</td>
                                                <td>9am - 2pm</td>
                                                <td>-</td>
                                            </tr>
                                            <tr>
                                                <td>Tuesday</td>
                                                <td>9am - 5pm</td>
                                                <td>8am - 7pm if it's a Special Draw Day</td>
                                            </tr>
                                            <tr>
                                                <td>Wednesday</td>
                                                <td>8am - 7pm</td>
                                                <td>Draw day</td>
                                            </tr>
                                            <tr>
                                                <td>Thursday</td>
                                                <td>Official rest day</td>
                                                <td>Some outlets may choose to operate, usually from 9am - 2pm</td>
                                            </tr>
                                            <tr>
                                                <td>Friday</td>
                                                <td>9am - 5pm</td>
                                                <td>-</td>
                                            </tr>
                                            <tr>
                                                <td>Saturday</td>
                                                <td>8am - 7pm</td>
                                                <td>Draw day</td>
                                            </tr>
                                            <tr>
                                                <td>Sunday</td>
                                                <td>8am - 7pm</td>
                                                <td>Draw Day</td>
                                            </tr>
                                        </table>
                                    </td>
                                </tr>
                            </table>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
@endsection
@section('js')
<script nonce="{{ csp_nonce() }}">

    // $('input[name="from_date"]').on('change', function() {
    //     var value =  $(this).val();

    //     var today = new Date();
    //     var tyear = today.getFullYear();
    //     var tmonth = (today.getMonth() + 1).toString().padStart(2, '0');
    //     var tday = today.getDate().toString().padStart(2, '0');

    //     var newDate = new Date(value);
    //     newDate.setMonth(newDate.getMonth() + 1);
    //     var year = newDate.getFullYear();
    //     var month = (newDate.getMonth() + 1).toString().padStart(2, '0');
    //     var day = newDate.getDate().toString().padStart(2, '0');

    //     var formattedDate = year + '-' + month + '-' + day;
    //     var tformattedDate = tyear + '-' + tmonth + '-' + tday;

    //     fdate = $('#from_date').val();
    //     edate = $('#end_date').val();

    //     if(new Date(formattedDate) > new Date(tformattedDate)) {
    //         $('#end_date').val(tformattedDate);
    //     }
    //     else if((new Date(edate) > new Date(formattedDate)) || (new Date(edate) < new Date(fdate))) {
    //         $('#end_date').val(formattedDate);
    //     }

    //     // $('#end_date').attr("min", value);
    //     $('#end_date').attr("max", tformattedDate);
    // });

    // $('input[name="end_date"]').on('change', function() {
    //     var value =  $(this).val();

    //     var newDate = new Date(value);
    //     newDate.setMonth(newDate.getMonth() - 1);
    //     var year = newDate.getFullYear();
    //     var month = (newDate.getMonth() + 1).toString().padStart(2, '0');
    //     var day = newDate.getDate().toString().padStart(2, '0');

    //     var formattedDate = year + '-' + month + '-' + day;

    //     fdate = $('#from_date').val();
    //     edate = $('#end_date').val();
        
    //     if((new Date(fdate) < new Date(formattedDate)) || (new Date(edate) < new Date(fdate))) {
    //         $('#from_date').val(formattedDate);
    //     }
    // });

    $('select[name="region"]').on('change', function() {
        var region =  $(this).val();
        $.ajax({
            type: 'get',
            url: '{{ route('reports.getBranchForRegion') }}',
            data: { 'region': region },
            dataType: 'json',
            success: function(data) {
                $('select[name="branch_id"]').empty();
                $('select[name="branch_id"]').html('<option value="">--All--</option>');
                $.each(data, function(key, value) {
                    $('select[name="branch_id"]').append('<option value="'+ value.id +'" {{ '+ value.id +' == ($_POST["branch_id"] ?? '') ? "selected" : "" }}>'+ value.code +'</option>');
                });
            }
        });
    });
</script>
@stop