@extends('layouts/app')
@section('css')
    <style type="text/css" nonce="{{ csp_nonce() }}">
        table {
            font-family: arial, sans-serif;
            border-collapse: collapse;
            border: 1px solid #ccc !important;
            width: 100%;
        }
        td,
        th {
            border: 1px solid #ccc !important;
            text-align: left;
            padding: 8px;
        }
        tr:nth-child(even) {
            background-color: #dddddd;
        }
        .total {
            background-color: #fff;
        }
    </style>
@stop
@section('content')
    <div class="content-header">
        <div class="container-fluid">
            <div class="row mb-2">
                <div class="col-sm-6">
                    <!-- <h1 class="m-0">Starter Page</h1> -->
                </div>
                <div class="col-sm-6">
                    <ol class="breadcrumb float-sm-right">
                        <li class="breadcrumb-item">Reports</li>
                        <li class="breadcrumb-item"><a href="{{ route('reports.dailySalesReport') }}">Daily 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.dailySalesReport') }}" 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">Select Terminal</label>
                                            <div class='input-group'>
                                                <select class="form-control" name="terminal_id">
                                                    @if (!empty($terminals))
                                                        <option value="" selected>--All--</option>
                                                        @foreach ($terminals as $terminal)
                                                            <option value="{{ $terminal }}"
                                                                {{ $terminal == ($_POST['terminal_id'] ?? '') ? 'selected' : '' }}>
                                                                {{ $terminal }}</option>
                                                        @endforeach
                                                    @endif
                                                </select>
                                            </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.dailySalesReport') }}">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">
                                            <label class="control-label text-white">---</label>
                                            <div class='input-group'>
                                                <a href="{{ route('reports.downloadDailySalesReport', [
                                                    'from_date' => $_POST['from_date'] ?? '',
                                                    'end_date' => $_POST['end_date'] ?? '',
                                                    'branch_id' => $_POST['branch_id'] ?? '',
                                                    'terminal_id' => $_POST['terminal_id'] ?? '',
                                                ]) }}"
                                                    class="btn btn-outline-success"><strong><i class="fa fa-file-excel-o"
                                                            aria-hidden="true"></i></strong>
                                                    Export </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($daily_sales))
                            <table class="table table-hover text-nowrap">
                                <thead>
                                    <tr>
                                        <th rowspan="2">Branch</th>
                                        @foreach ($date_lables as $dateLabel)
                                            <th>{{ $dateLabel['daymonth'] }}</th>
                                        @endforeach
                                        <th rowspan="2">Total</th>
                                    </tr>
                                    <tr>
                                        @foreach ($date_lables as $dateLabel)
                                            <th>{{ $dateLabel['weekly'] }}</th>
                                        @endforeach
                                    </tr>
                                </thead>
                                <tbody>
                                    <tr><th colspan="{{count($date_lables)+2}}">Number of tickets sold</th></tr>
                                    @php $trow1 = 1; $trow2 = 1; @endphp
                                    @foreach ($daily_sales as $code => $sales)
                                    @if($code!=='total_amount' && $code!=='total_number')
                                    <tr>
                                        <td>{{ $code }}</td>
                                        @foreach ($date_lables as $key => $dateLabel)
                                        @if(isset($sales[$key]) && date("Ymd", strtotime($sales[$key]['date']))==$key)
                                            <td class="font-weight-bold">{{ $sales[$key]['number'] }}</td>
                                        @else
                                            <td>{{ 0 }}</td>
                                        @endif
                                        @endforeach
                                        @if($trow1==1)
                                            <td rowspan="{{ count($daily_sales)-2 }}" class="total font-weight-bold">{{ $daily_sales['total_number'] }}</td>
                                        @endif
                                        @php $trow1++; @endphp
                                    </tr>
                                    @endif
                                    @endforeach
                                    <tr><th colspan="{{count($date_lables)+2}}">Value of tickets sold</th></tr>
                                    @foreach ($daily_sales as $code => $sales)
                                    @if($code!=='total_amount' && $code!=='total_number')
                                    <tr>
                                        <td>{{ $code }}</td>
                                        @foreach ($date_lables as $key => $dateLabel)
                                        @if(isset($sales[$key]) && date("Ymd", strtotime($sales[$key]['date']))==$key)
                                            <td class="font-weight-bold">{{ number_format($sales[$key]['amount'],2) }}</td>
                                        @else
                                            <td>{{ number_format(0,2) }}</td>
                                        @endif
                                        @endforeach
                                        @if($trow2==1)
                                            <td rowspan="{{ count($daily_sales)-2 }}" class="total font-weight-bold">{{ number_format($daily_sales['total_amount'],2) }}</td>
                                        @endif
                                        @php $trow2++; @endphp
                                    </tr>
                                    @endif
                                    @endforeach
                            </tbody>
                            </table>
                            @else
                                <p class="text-center">No data found</p>
                            @endif
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
@endsection
@section('js')
<script nonce="{{ csp_nonce() }}">
    $('select[name="branch_id"]').on('change', function() {
        var branch_id =  $(this).val();
        $.ajax({
            type: 'get',
            url: '{{ route('reports.getTerminalForBranch') }}',
            data: { 'branch_id': branch_id },
            dataType: 'json',
            success: function(data) {
                $('select[name="terminal_id"]').empty();
                $('select[name="terminal_id"]').html('<option value="">--All--</option>');
                $.each(data, function(key, value) {
                    $('select[name="terminal_id"]').append('<option value="'+ value +'" {{ '+ value +' == ($_POST["terminal_id"] ?? '') ? "selected" : "" }}>'+ value +'</option>');
                });
            }
        });
    });

    $('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