@extends('layouts/contentLayoutMaster')

@section('title', 'General Expense List')

@section('vendor-style')
    {{-- vendor css files --}}
    <link rel="stylesheet" href="{{ asset('vendors/css/tables/datatable/dataTables.bootstrap5.min.css') }}">
    <link rel="stylesheet" href="{{ asset('vendors/css/tables/datatable/buttons.bootstrap5.min.css') }}">
    <link rel="stylesheet" href="{{ asset('vendors/css/extensions/sweetalert2.min.css') }}">
    <link rel="stylesheet" href="{{ asset('/css/custom.css') }}">
@endsection
<style>
    .row {
        margin-right: calc(-1.4 * var(--bs-gutter-x)) !important;
        margin-left: calc(-1.4 * var(--bs-gutter-x)) !important;
    }

    html .content .content-wrapper .content-header-title {
        margin-left: 28px !important;
    }
</style>
@section('content')
    <!-- Column Search -->
    <section id="column-search-datatable">
        <div class="row">
            <div class="col-12">
                <div class="card">
                    <div class="card-header border-bottom">
                        <h4 class="card-title">General Expense List</h4>
                        {{-- @can('Create Department') --}}
                            <a class="add-new-btn btn btn-primary mt-2 mr_30px" href="{{ route('general-expense.create') }}">Add New</a>
                        {{-- @endcan --}}
                    </div>
                    @if ($message = Session::get('success'))
                        <div class="demo-spacing-0 m-2">
                            <div class="alert alert-success alert-dismissible fade show" role="alert">
                                <div class="alert-body">{{ $message }}</div>
                                <button type="button" class="btn-close" data-bs-dismiss="alert"
                                    aria-label="Close"></button>
                            </div>
                        </div>
                    @endif
                    <div class="card-body">
                        <div class="tabs">
                            @include('content._partials._sections.general_expense_tabs')
                        </div>
                    </div>
                    <div class="card-datatable table-responsive">
                        <table class="table" id="general_expense_table">
                            <thead>
                                <div class="row ms-1 me-1">
                                    <div class="col-md-12 m-0 p-0 d-flex justify-content-between">
                                        <div class="pe-1 w-25">
                                            <label for="name" class=""><small>Area Office</small></label>
                                            <select class="form-control" id="areaOffice">
                                                <option value="">Area Office</option>
                                                @foreach ($areaOffices as $areaOffice)
                                                    <option value="{{ $areaOffice->id }}">{{ $areaOffice->name }}</option>
                                                @endforeach
                                            </select>
                                        </div>
                                        <div class="pe-1 w-25">
                                            <label for="name" class=""><small>Expense Category</small></label>
                                            <input type="text" class="form-control" placeholder="Expense Category"
                                            id="expenseCategory">
                                        </div>
                                        <div class=" pe-1 w-25">
                                            <label for="from" class=""><small>From Date</small></label>
                                            <input type="date" class="form-control" placeholder="From Date"
                                                id="from">
                                        </div>
                                        <div class="pe-1 w-25">
                                            <label for="to" class=""><small>To Date</small></label>
                                            <input type="date" class="form-control" placeholder="To Date"
                                                id="to">
                                        </div>
                                        <div class="" style="margin-top: 18.5px">
                                            <button class="btn btn-md btn-primary" id="resetBtn">
                                                Reset
                                            </button>
                                        </div>
                                    </div>
                                </div>
                                <tr>
                                    <th>No.</th>
                                    <th>Code</th>
                                    <th>Type</th>
                                    <th>Bank Acc.</th>
                                    <th>Cash Acc.</th>
                                    <th>Expense Category</th>
                                    <th>Category GL Code</th>
                                    <th>Expense Date</th>
                                    <th>Level Of Expense</th>
                                    <th>Area Office</th>
                                    <th>Collection Point</th>
                                    <th>Amount</th>
                                    <th>File</th>
                                    <th>Created By</th>
                                    <th>Created At</th>
                                    <th>Remarks</th>
                                    {{-- <th>Action</th> --}}
                                </tr>
                            </thead>
                        </table>
                    </div>
                </div>
            </div>
        </div>
    </section>
    <!--/ Column Search -->
@endsection


@section('vendor-script')
    {{-- vendor files table data --}}
    <script src="{{ asset('vendors/js/tables/datatable/jquery.dataTables.min.js') }}"></script>
    <script src="{{ asset('vendors/js/tables/datatable/dataTables.bootstrap5.min.js') }}"></script>
    <script src="{{ asset('vendors/js/tables/datatable/datatables.buttons.min.js') }}"></script>
    <script src="{{ asset('vendors/js/tables/datatable/buttons.bootstrap5.min.js') }}"></script>
    <script src="{{ asset('vendors/js/extensions/sweetalert2.all.min.js') }}"></script>
@endsection

@section('page-script')
    {{-- Page js files --}}
    <script src="{{ asset('/js/custom.js') }}"></script>
    <script>

        $('#resetBtn').on('click', function() {
            // Reset the input field with id="plant"
            $('#to, #from, #areaOffice, #expenseCategory').val('');  // For text-based inputs (e.g., text, email, etc.
            table.ajax.reload();
        });

        var table;
        $(document).ready(function() {
            table = $('#general_expense_table').DataTable({
                processing: true,
                serverSide: true,
                paging: true,
                    ajax: {
                        url: "{{ route('general-expense.index') }}",
                        data: function(d) {
                            // '_token': '{{ csrf_token() }}',
                            d.page = (d.start / d.length) + 1; // DataTables calculates the page number based on start
                            d.length = d.length; // Page length (number of rows per page)
                            d.from = $('#from').val();
                            d.to = $('#to').val();
                            d.areaOffice = $('#areaOffice').val();
                            d.expenseCategory = $('#expenseCategory').val(); 
                        }
                    },
                columns: [{
                        data: 'DT_RowIndex',
                        name: 'DT_RowIndex',
                        className: 'text-center'
                    },
                    {
                        data: 'code',
                        name: 'code',
                        className: 'text-center'
                    },
                    {
                        data: 'type',
                        name: 'type',
                        className: 'text-left'
                    },
                    {
                        data: 'bank_account',
                        name: 'bank_account',
                        className: 'text-left'
                    },
                    {
                        data: 'petty_cash_wallet',
                        name: 'petty_cash_wallet',
                        className: 'text-left'
                    },
                    {
                        data: 'expense_category',
                        name: 'expense_category',
                        className: 'text-left'
                    },
                    {
                        data: 'category_gl_code',
                        name: 'category_gl_code',
                        className: 'text-center'
                    },
                    {
                        data: 'exp_date',
                        name: 'exp_date',
                        className: 'text-center'
                    },
                    {
                        data: 'level_of_expense',
                        name: 'level_of_expense',
                        className: 'text-left'
                    },
                    {
                        data: 'area_office',
                        name: 'area_office',
                        className: 'text-left'
                    },
                    {
                        data: 'collection_point',
                        name: 'collection_point',
                        className: 'text-left'
                    },
                    {
                        data: 'amount',
                        name: 'amount',
                        className: 'text-end'
                    },
                    {
                        data: 'file_url',
                        name: 'file_url',
                        render: function(data, type, full, meta) {
                            if (data) {
                                const fileExtension = data.split('.').pop().toLowerCase();
                                
                                if (['jpeg', 'jpg', 'png'].includes(fileExtension)) {
                                    // If it's an image, display the image
                                    return '<a href="' + data + '" target="_blank">' +
                                        '<img src="' + data + '" style="max-width: 50px; height: auto;" /></a>';
                                } else if (fileExtension === 'pdf') {
                                    // If it's a PDF, display a link to the PDF
                                    return '<a href="' + data + '" target="_blank">View PDF</a>';
                                } else {
                                    // If it's another file type, return a generic link
                                    return '<a href="' + data + '" target="_blank">View File</a>';
                                }
                            } else {
                                return 'N/A';
                            }
                        }
                    },
                    {
                        data: 'user_name',
                        name: 'user_name',
                        className: 'text-left'
                    },
                    {
                        data: 'created_at',
                        name: 'created_at',
                        className: 'text-center'
                    },
                    {
                        data: 'remarks',
                        name: 'remarks',
                        className: 'text-left'
                    }
                ],
                order: [
                    [1, 'asc']
                ],
                dom: '<"d-flex justify-content-between align-items-center header-actions text-nowrap mx-1 row mt-75"' +
                        '<"col-sm-12 col-lg-4 d-flex justify-content-center justify-content-lg-start" l>' +
                        '<"col-sm-12 col-lg-8 dt-action-buttons d-flex flex-column align-items-end justify-content-end"' +
                            '<" me-1"B>' + // Buttons on top
                            '<"me-1"f>' + // Search bar below
                        '>' +
                    '>' +
                    '<"text-nowrap" t>' +
                    '<"d-flex justify-content-between mx-2 row mb-1"' +
                        '<"col-sm-12 col-md-6"i>' +
                        '<"col-sm-12 col-md-6"p>' +
                    '>',
                    buttons: [
                        {
                            extend: 'excelHtml5',
                            text: '<i class="fas fa-file-excel excel-file"></i> Excel Export',
                            className: 'custom-excel-btn',
                            exportOptions: {
                                columns: [0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 13, 14, 15] // Exclude the 'action' column,
                            }
                        }
                    ],
                language: {
                    paginate: {
                        // remove previous & next text from pagination
                        previous: '&nbsp;',
                        next: '&nbsp;'
                    }
                }
            });

            $('#to,#from,#areaOffice').on('change input', function() {
                table.ajax.reload();
            });
            $('#expenseCategory').on('input', function() {
                table.ajax.reload();
            });
        });
    </script>
    
@endsection