@extends('layouts.master')

@section('page_title', 'Expense Details')
@section('title', 'Expense Details')
@section('main_item', 'Expense')
@section('sub_item', 'Expense Details')

@section('content')

    <div class="col-12">
        <div class="card">
            <div id="accordion">

                <div class="border-bottom card-header" style="background-color: white; cursor: pointer;" data-toggle="collapse"
                    data-target="#collapseOne" aria-expanded="true" aria-controls="collapseOne">
                    <h4 class="mb-0 header-title">
                        Filter
                    </h4>
                </div>


                <div id="collapseOne" class="collapse show mt-3" aria-labelledby="headingOne" data-parent="#accordion">
                    <div class="card-body">
                        <form method="GET" action="{{ route('expenses.index') }}">
                        <div class="row">
                            <div class="col-md-3">
                                <div class="form-group">
                                    <label class="required" style="font-weight: bold" for="location_id">Business Location</label>
                                        <select class="form-control select2" id="location_id" name="location_id">
                                            <option value="">All</option>
                                            @foreach ($users_access_location as $business_location)
                                                @if ($business_location->is_active == '1')
                                                    <option value="{{ $business_location->id }}" {{ request('location_id') == $business_location->id ? 'selected' : '' }}>
                                                        {{ $business_location->name }}
                                                    </option>
                                                @endif
                                            @endforeach
                                        </select>
                                    </div>
                                </div>

                            <div class="col-md-3">
                                <div class="form-group">
                                    <label style="font-weight: bold" for="branch_id">Branch</label>
                                    <select class="form-control select2" id="branch_id" name="branch_id">
                                        <option value="">All</option>
                                        @foreach ($branches as $branch)
                                            <option value="{{ $branch->id }}" {{ request('branch_id') == $branch->id ? 'selected' : '' }}>
                                                {{ $branch->branch_name }}
                                            </option>
                                        @endforeach
                                    </select>
                                </div>
                            </div>
                                
                            <div class="col-md-3">
                                <div class="form-group">
                                    <label style="font-weight: bold" for="account_id">Account</label>
                                    <select class="form-control select2" id="account_id" name="account_id">
                                        <option value="">All</option>
                                        @foreach ($accounts as $account)
                                            <option value="{{ $account->id }}" {{ request('account_id') == $account->id ? 'selected' : '' }}>
                                                {{ $account->account_name }}
                                            </option>
                                        @endforeach
                                    </select>
                                </div>
                            </div>

                            <div class="col-md-3">
                                <div class="form-group">
                                    <label style="font-weight: bold" for="reportrange">Date</label>
                                    <input type="text" class="form-control" name="range" id="reportrange" value="{{ request('range') }}" readonly>
                                </div>
                            </div>

                            <div class="col-md-12 text-right">
                                <button type="submit" class="btn btn-primary mt-3" style="width: 140px;">Filter</button>
                            </div>
                                
                            </div>
                        </form>
                    </div>
                </div>
            </div>
        </div>
    </div>

    <div class="col-12">
        <div class="card">
            <div class="card-body">
                @can('expense_create')
                    <a href="{{ route('expenses.create') }}">
                        <button class="btn btn-primary px-4 float-right mt-0 mb-3"><i
                                class="mdi mdi-plus-circle-outline mr-2"></i>Add Expense</button>
                    </a>
                @endcan
                <h4 class="header-title mt-0">Expenses Details</h4>
                <div class="table-responsive dash-social">
                    <table id="laravel_datatable" class="table table-hover">
                        <thead class="thead-dark">
                            <tr>
                                <th>Action</th>
                                <th>Date</th>
                                <th>Business Location</th>
                                <th>Payment Status</th>
                                <th>Ref No</th>
                                <th>Expense Category</th>
                                <th>Total Amount</th>
                                <th>Payment Due</th>
                                <th>Added By</th>
                            </tr>
                        </thead>
                        <tbody>
                            @foreach ($expenses as $expense)
                        <tr>
                            <td>{!! $expense->action_buttons !!}</td> <!-- Render action buttons -->
                            <td>{{ \Carbon\Carbon::parse($expense->date)->format('Y-m-d') }}</td> <!-- Display only the date -->
                            <td>{{ $expense->business_location_name }}</td>
                            <td>
                                @if ($expense->status == 'due')
                                    <span class="badge badge-warning">Due</span>
                                @elseif ($expense->status == 'partial')
                                    <span class="badge badge-success">Partial</span>
                                @elseif ($expense->status == 'paid')
                                    <span class="badge badge-secondary">Paid</span>
                                @else
                                    <span class="badge badge-info">Not Available</span>
                                @endif
                            </td>
                            <td>{{ $expense->ref_no }}</td>
                            <td>{{ $expense->expenses_category->name ?? 'N/A' }}</td>
                            <td>{{ number_format($expense->amount, 2) }}</td>
                            <td>{{ number_format($expense->due_amount, 2) }}</td>
                            <td>{{ $expense->user->username ?? 'N/A' }}</td>
                        </tr>
                    @endforeach

                        </tbody>
                        
                        <tfoot>
                            <tr>
                                <th colspan="5" style="text-align: center"></th>
                                <th style="font-weight: bold">Total</th>
                                <th></th>
                                <th colspan="2"></th>
                            </tr>
                        </tfoot>
                    </table>
                </div>
            </div>
        </div>
    </div>

    <div id="add-payment" class="modal fade">
    </div>
@endsection

@section('scripts')

    <script>
        $(document).ready(function() {
            $("#branch_id").select2();
            $("#location_id").select2();
            $("#account_id").select2();

            @if(request('range'))
                var range = '{{ request('range') }}';
                $('#reportrange').val(range);
            @endif

            $('#mdate').val(moment(new Date()).format("YYYY-MM-DD"));


            $('#laravel_datatable').DataTable({
                paging: true,
                searching: true,
                ordering: true,
                info: true,
                lengthMenu: [
                    [25, 50, 100, -1],
                    ['25 ', '50 ', '100', 'All']
                ],
                dom: 'Blfrtip',
                buttons: [

                    {
                        extend: 'copy',
                        exportOptions: {
                            columns: [1, 2, 3, 4, 5, 6, 7, 8]
                        }
                    },

                    {
                        extend: 'excel',
                        exportOptions: {
                            columns: [1, 2, 3, 4, 5, 6, 7, 8]
                        }
                    },
                    {
                        extend: 'pdf',
                        exportOptions: {
                            columns: [1, 2, 3, 4, 5, 6, 7, 8]
                        }
                    },
                    {
                        extend: 'print',
                        exportOptions: {
                            columns: [1, 2, 3, 4, 5, 6, 7, 8]
                        }
                    },
                ],
                "footerCallback": function(row, data, start, end, display) {
                    var api = this.api(),
                        data;
                    // converting to interger to find total
                    var intVal = function(i) {
                        return typeof i === 'string' ?
                            i.replace(/[\$,]/g, '') * 1 :
                            typeof i === 'number' ?
                            i : 0;
                    };
                    // get basic salary

                    // total allowance
                    let grand_total = api.column(6).data().reduce(function(a, b) {
                        return intVal(a) + intVal(b);
                    }, 0);

                    $(api.column(6).footer()).html(formatNumber(grand_total) + '.00');

                    let due = api.column(7).data().reduce(function(a, b) {
                        return intVal(a) + intVal(b);
                    }, 0);


                    $(api.column(7).footer()).html(formatNumber(due) + '.00');

                },
                columns: [{
                        data: 'action',
                        name: 'action'
                    },
                    {
                        data: 'date',
                        name: 'date'
                    },
                    {
                        data: 'location_id',
                        name: 'location_id'
                    },
                    {
                        data: 'status',
                        name: 'status'
                    },
                    {
                        data: 'ref_no',
                        name: 'ref_no'
                    },
                    {
                        data: 'expense_category',
                        name: 'expense_category'
                    },

                    {
                        data: 'amount',
                        name: 'amount'
                    },

                    {
                        data: 'due_amount',
                        name: 'due_amount'
                    },
                    {
                        data: 'created_by',
                        name: 'created_by'
                    },
                ]
            });

            //toast
            $('[data-toggle="tooltip"]').tooltip()
            
            $(document).on('click', '#add_payment', function() {
                var today = new Date().toLocaleDateString();
                $('#add-payment').load($(this).data('href'), function() {
                    $('#mdate').bootstrapMaterialDatePicker({
                        weekStart: 0,
                        time: false
                    });
                    $('#mdate').val(moment(new Date()).format("YYYY-MM-DD"));
                    // $('#mdate').val(today);
                    $('#add-payment').modal('show');
                })
            });
            $(document).on('click', '#update_payment', function() {
                let amount = $('#amount').val();
                let payment_ref_no = $('#payment_ref_no').val();
                let date = $('#mdate').val();
                let due_amount = $('#due_amount').val();
                let account_id = $('#accounts').val();
                let id = $('#id').val();
                let description = $('#description').val();
                let payment_method = $('#payment_method').val();
                let url = "{{ route('expense.update-payment') }}";
                $.ajax({
                    method: 'POST',
                    url: url,
                    data: {
                        "_token": "{{ csrf_token() }}",
                        'amount': amount,
                        'payment_ref_no': payment_ref_no,
                        'account_id': account_id,
                        'due_amount': due_amount,
                        'id': id,
                        'description': description,
                        'payment_method': payment_method,
                        'date': date,
                    },
                    success: function(response) {
                        if (response == 'ok') {
                            $('#add-payment').modal('hide');
                            location.reload();
                        }
                    }
                });
            });

            $(document).on('click', '.delete-contact', function(e) {
                e.preventDefault();
                var url = $(this).attr('href');
                Swal.fire({
                    title: 'Are you sure?',
                    text: "You won't be able to revert this!",
                    icon: 'warning',
                    showCancelButton: true,
                    confirmButtonColor: '#3085d6',
                    cancelButtonColor: '#d33',
                    confirmButtonText: 'Yes, delete it!'
                }).then((result) => {
                    if (result.value) {

                        $.ajax({
                            type: "GET",
                            url: url,
                            success: function(response) {
                                if (response.success == 1) {
                                    $.toast({
                                        heading: 'Success',
                                        text: response.msg,
                                        position: 'top-right',
                                        bgColor: '#1ecab8',
                                        icon: 'success',
                                        showHideTransition: 'fade',
                                        loaderBg: '#ecf0f1'
                                    })

                                } else {
                                    $.toast({
                                        heading: 'Error',
                                        text: response.msg,
                                        position: 'top-right',
                                        bgColor: '#f1646c',
                                        icon: 'error',
                                        showHideTransition: 'fade',
                                        loaderBg: '#ecf0f1'
                                    })
                                }
                                window.location.reload();
                            }
                        });
                    }
                })
            });
        });
        $(function() {
            $('[data-toggle="tooltip"]').tooltip()
        })
    </script>

@endsection