@php
    $expenses = [
        'All' => 'All',
        'Employee Expense' => 'Employee Expense',
        'Travel Expense' => 'Travel Expense',
        'Office Expense' => 'Office Expense',
        'License Expense' => 'License Expense',
        'Legal Expense' => 'Legal Expense',
        'Salary Expense' => 'Salary Expense',
        'Conveyance Expense' => 'Conveyance Expense',
        'F&F Expense' => 'F&F Expense'
    ];

    $billTotal = 0;
@endphp
@extends('admin.layouts.layouts')

@section('title', 'Expense Report')

@section('content')
    <div class="page-header">
        <h3 class="page-title">
            Expense Report
        </h3>
        <nav aria-label="breadcrumb">
            <ol class="breadcrumb">
                <li class="breadcrumb-item"><a href="{{ route('admin.dashboard') }}">Dashboard</a></li>
                <li class="breadcrumb-item" aria-current="page">Reports</li>
                <li class="breadcrumb-item active" aria-current="page">Expense Report</li>
            </ol>
        </nav>
    </div>
    <div class="card">
        <div class="card-header">
            <form action="{{ route('expense-report.index') }}" method="get" id="searchForm" autocomplete="off">
                <div class="row">
                    <div class="col-md-2">
                        <div class="form-group">
                            {!! Form::label('search_location', '<strong>Location</strong>', [], false) !!}
                            {!! Form::select('search_location', $locations, request('search_location'), [
                                'class' => 'form-control select2',
                                'placeholder' => 'Select Location',
                            ]) !!}
                        </div>
                    </div>
                    <div class="col-md-2">
                        <div class="form-group">
                            {!! Form::label('search_expense', '<strong>Expense</strong>', [], false) !!}
                            {!! Form::select('search_expense', $expenses, request('search_expense'), [
                                'class' => 'form-control select2',
                                'multiple' => false,
                                'id' => 'search_expense',
                                'placeholder' => 'Select Expense',
                            ]) !!}
                        </div>
                    </div>
                    <div class="col-md-2">
                        <div class="form-group">
                            {!! Form::label('search_employee', '<strong>Employee</strong>', [], false) !!}
                            {!! Form::select('search_employee', array_combine($employees, $employees), request('search_employee'), [
                                'class' => 'form-control select2',
                                'multiple' => false,
                                'id' => 'search_employee',
                                'placeholder' => 'Select Employee',
                            ]) !!}
                        </div>
                    </div>
                    <div class="col-sm-2">
                        <div class="form-group">
                            {!! Form::label('search_from', '<strong>From</strong>', [], false) !!}
                            {!! Form::text('search_from', request('search_from'), [
                                'class' => 'form-control datepicker',
                                'id' => 'start_date',
                                'placeholder' => 'Select From Date',
                                'style' => 'height: 43px;'
                            ]) !!}
                        </div>
                    </div>
                    <div class="col-sm-2">
                        <div class="form-group">
                            {!! Form::label('search_to', '<strong>To</strong>', [], false) !!}
                            {!! Form::text('search_to', request('search_to'), [
                                'class' => 'form-control datepicker',
                                'id' => 'end_date',
                                'placeholder' => 'Select To Date',
                                'style' => 'height: 43px;'
                            ]) !!}
                        </div>
                    </div>
                    <div class="col-md-2 mt-4">
                        <div class="form-group mt-1">
                            <button type="submit" class="btn btn-sm btn-success" title="Search"><i class="fas fa-search"></i></button>
                            <a href="{{ route('expense-report.index') }}" class="btn btn-sm btn-light" title="Reset"><i class="fa fa-refresh" aria-hidden="true"></i></a>
                            @if (!empty(request('search_location')) || !empty(request('search_expense')) || !empty(request('search_from')) || !empty(request('search_to')))
                                <a class="btn btn-sm btn-primary"
                                    href="{{ route('expense-report-print') }}?search_from={{ request('search_from') }}&search_to={{ request('search_to') }}&search_location={{ request('search_location') }}&search_expense={{ request('search_expense') }}&search_employee={{ request('search_employee') }}&print=1"
                                    target="_blank" title="Print"><i class="fa-solid fa-print"></i></a>
                            @endif
                        </div>
                    </div>
                </div>
            </form>
        </div>
        <div class="card-body">
            <div class="row">
                <div class="col-12">
                    <div class="">
                        <table class="table table-bordered">
                            <thead>
                                <tr>
                                    <th>Date</th>
                                    <th>Expense Type</th>
                                    <th>Expense Sub Type</th>
                                    <th>Created By</th>
                                    <th>Employee Name</th>
                                    <th>Bank Name</th>
                                    <th style="width: 20px;">Payment Mode</th>
                                    <th>Amount (<i class="fa fa-indian-rupee-sign ml-0" style="font-size: 12px;"></i>)</th>
                                    {{-- <th style="width: 330px;">Remark</th> --}}
                                </tr>
                            </thead>
                            <tbody>
                                @forelse($reportData as $data)
                                    @php
                                        $billTotal += $data->paid_amount;
                                    @endphp
                                    <tr>
                                        <td>{{ $data->expense_date ? date('d-m-Y', strtotime($data->expense_date)) : '-' }}</td>
                                        <td>{{ $data->expense_type }}</td>
                                        <td>{{ $data->expense_sub_type_name ?? '-' }}</td>
                                        <td>{{ $data->created_by ?? '-' }}</td>
                                        <td>{{ $data->employee_name ?? '-' }}</td>
                                        <td>{{ $bankNames[$data->bank_id] ?? 'N/A' }}</td>
                                        <td>{{ ucfirst($data->payment_mode) ?? '-' }}</td>
                                        <td>{{ number_format($data->paid_amount, 2) }}</td>
                                        {{-- <td>{{ $data->remark ?? '-' }}</td> --}}
                                    </tr>
                                @empty
                                    <tr>
                                        <td colspan="7" style="text-align: center;">No records found</td>
                                    </tr>
                                @endforelse
                                <tr>
                                    <th colspan="7" class="text-right">Total</th>
                                    <th>{{ number_format($billTotal, 2) }}</th>
                                </tr>
                            </tbody>
                        </table>
                    </div>
                </div>
            </div>
        </div>
    </div>
@endsection

@section('page-js')
    <script type="text/javascript">
        $(document).ready(function() {
            $('.select2').select2();
            $('.datepicker').datepicker({
                dateFormat: "dd-mm-yy",
                autoclose: true,
                changeMonth: true,
                changeYear: true,
            });
        });
    </script>
@endsection