@extends('layouts/contentLayoutMaster')

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

@section('vendor-style')
    {{-- vendor css files --}}
    <link rel="stylesheet" href="{{ asset('vendors/css/forms/select/select2.min.css') }}">
    <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 class="card-datatable table-responsive">
                            <table class="table" id="general_expense_table">
                                <thead>
                                    <tr>
                                        <td colspan="3">
                                            <input type="search" class="form-control" placeholder="Search"
                                                id="search">
                                        </td>
                                        <td colspan="3">
                                            <select class="select2 search-input" id="type">
                                                <option value="">Type</option>
                                                <option value="mmt_dispatch_plant">MMT Purchase</option>
                                                <option value="ao_dispatch_plant">Area Office </option>
                                            </select>
                                        </td>
                                        <td colspan="2">
                                            <input type="text" class="form-control" placeholder="Serial Number"
                                                id="serial_number">
                                        </td>
                                        <td colspan="3">
                                            <select class="select2 search-input" id="area_office">
                                                <option value="">Area Office</option>
                                                
                                            </select>
                                        </td>
                                    </tr>
                                    <tr>
                                        <th>No.</th>
                                        <th>Type</th>
                                        <th>Bank Acc.</th>
                                        <th>Petty Cash Wallet</th>
                                        <th>Expense Category</th>
                                        <th>Exp. Date</th>
                                        <th>Level Of Expense</th>
                                        <th>Area Office</th>
                                        <th>Collection Point</th>
                                        <th>Amount</th>
                                        <th>Image</th>
                                        <th>Remarks</th>
                                    </tr>
                                </thead>
                            </table>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </section>
    <!--/ Column Search -->
@endsection


@section('vendor-script')
    {{-- vendor files table data --}}
    <script src="{{ asset('vendors/js/forms/select/select2.full.min.js') }}"></script>
    <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>

        $('#general_expense_table').DataTable({
            processing: true,
            serverSide: true,
            ajax: "{{ route('general-expense.index') }}",
            columns: [{
                    data: 'DT_RowIndex',
                    name: 'DT_RowIndex'
                },
                {
                    data: 'type',
                    name: 'type',
                    render: function(data, type, row) {
                        // Check if type is 'bank', and display 'Bank'
                        if (data === 'bank') {
                            return 'Bank';
                        }
                        // Check if type is 'petty_cash', and display 'Petty Cash'
                        else if (data === 'petty_cash') {
                            return 'Petty Cash';
                        }
                        // Return the original data or handle other cases
                        else {
                            return data;
                        }
                    }
                },
                {
                    data: 'bank_account_title',
                    name: 'bank_account_title',
                },
                {
                    data: 'petty_cash_wallet_title',
                    name: 'petty_cash_wallet_title',
                },
                {
                    data: 'expense_category',
                    name: 'expense_category'
                },
                {
                    data: 'exp_date',
                    name: 'exp_date'
                },
                {
                    data: 'level_of_expense',
                    name: 'level_of_expense',
                    render: function(data, type, row) {
                        if (data === 'mcc') {
                            return 'MCC';
                        } else {
                            return 'Area Office'; // Return the actual value for other cases
                        }
                    }
                },
                {
                    data: 'area_office',
                    name: 'area_office'
                },
                {
                    data: 'collection_point',
                    name: 'collection_point'
                },
                {
                    data: 'amount',
                    name: 'amount'
                },
                {
                    data: 'remarks',
                    name: 'remarks'
                }
            ],
            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 align-items-center justify-content-lg-end justify-content-center flex-md-nowrap flex-wrap"<"me-1"f>>>' +
                '><"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>' +
                '>',
            language: {
                paginate: {
                    // remove previous & next text from pagination
                    previous: '&nbsp;',
                    next: '&nbsp;'
                }
            }
        });
    </script> --}}

    <script>
    
    var table;
    $(document).ready(function() {
        $(".select2").select2({});
        table = $('#general_expense_table').DataTable({
            processing: true,
            serverSide: true,
            searching: false,
            paging: true,
            // ajax: "{{ route('general-expense.index') }}",
            ajax: {
                headers: {
                    'X-CSRF-TOKEN': $('meta[name="csrf-token"]').attr('content') // CSRF token for security
                },
                url: "{{ route('general-expense.index') }}", // Your custom route
                data: function(d) {
                    // Customize data sent to the server
                    d.page = (d.start / d.length) + 1; // Calculate the current page number based on DataTables' start value
                    d.length = d.length; // Number of rows per page
                    d.search = $('#search').val();
                }
            },
            columns: [{
                    data: 'DT_RowIndex',
                    name: 'DT_RowIndex'
                },
                {
                    data: 'type',
                    name: 'type',
                    render: function(data, type, row) {
                        // Check if type is 'bank', and display 'Bank'
                        if (data === 'bank') {
                            return 'Bank';
                        }
                        // Check if type is 'petty_cash', and display 'Petty Cash'
                        else if (data === 'petty_cash') {
                            return 'Petty Cash';
                        }
                        // Return the original data or handle other cases
                        else {
                            return data;
                        }
                    }
                },
                {
                    data: 'bank_account_title',
                    name: 'bank_account_title',
                },
                {
                    data: 'petty_cash_wallet_title',
                    name: 'petty_cash_wallet_title',
                },
                {
                    data: 'expense_category',
                    name: 'expense_category'
                },
                {
                    data: 'exp_date',
                    name: 'exp_date'
                },
                {
                    data: 'level_of_expense',
                    name: 'level_of_expense',
                    render: function(data, type, row) {
                        if (data === 'mcc') {
                            return 'MCC';
                        } else {
                            return 'Area Office'; // Return the actual value for other cases
                        }
                    }
                },
                {
                    data: 'area_office',
                    name: 'area_office'
                },
                {
                    data: 'collection_point',
                    name: 'collection_point'
                },
                {
                    data: 'amount',
                    name: 'amount'
                },
                {
                    data: 'image_url',
                    name: 'image_url',
                    render: function(data, type, full, meta) {
                        console.log(data)
                        if (data) {
                            return '<a href="' + data + '" target="_blank">' +
                                '<img src="' + data + '" style="max-width: 50px; height: auto;" /></a>';
                        } else {
                            return 'N/A';
                        }
                    }
                },
                {
                    data: 'remarks',
                    name: 'remarks'
                }
            ],
            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 align-items-center justify-content-lg-end justify-content-center flex-md-nowrap flex-wrap"<"me-1"f>>>' +
                '><"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>' +
                '>',
            language: {
                paginate: {
                    // remove previous & next text from pagination
                    previous: '&nbsp;',
                    next: '&nbsp;'
                }
            }
        });
        
        $('#search').on('input', function() {
            table.ajax.reload();
        });
    });
    </script>
    
@endsection