@extends('layout.admin')

@section('head')
    @extends('layout.header')
    @section('header_title', 'Expenses')
@endsection

@section('content')
    <!-- Content Wrapper. Contains page content -->
    <div class="content-wrapper">
        <!-- Content Header (Page header) -->
        <div class="content-header">
            <div class="container-fluid">
                <div class="row mb-2">
                    <div class="col-sm-6">
                        <h1 class="m-0">Expenses</h1>
                    </div><!-- /.col -->
                    <div class="col-sm-6">
                        <ol class="breadcrumb float-sm-right">
                            <li class="breadcrumb-item"><a href="#">Home</a></li>
                            <li class="breadcrumb-item active">Expenses</li>
                        </ol>
                    </div><!-- /.col -->
                </div><!-- /.row -->
            </div><!-- /.container-fluid -->
        </div>

        <section class="content">
            <div class="container-fluid">
                <div class="row">
                    <div class="col-md-12">
                        <div class="card">
                            <div class="card-body">
                                <div class="row">
                                    <div class="col-md-3">
                                        <div class="form-group">
                                            <label for="date">Date</label>
                                            <input style="width: 90%" type="date" name="date" class="form-control"
                                                id="date">
                                        </div>
                                    </div>
                                    <div class="col-md-3">
                                        <div class="form-group">
                                            <label for="date">Category</label>
                                            <select style="width: 90%" name="category" id="category" class="form-control">
                                                <option value="Daily Expenses">Daily Expenses</option>
                                                <option value="Purchase">Purchase</option>
                                                <option value="Bill payment">Bill payment</option>
                                            </select>
                                        </div>
                                    </div>
                                    <div class="col-md-3">
                                        <div class="form-group">
                                            <label for="date">Type</label>
                                            <select style="width: 90%" name="type" id="type" class="form-control">
                                                <option value="Cash">Cash</option>
                                                <option value="Cheque">Cheque</option>
                                            </select>
                                        </div>
                                    </div>
                                    <div class="col-md-3">
                                        <div class="form-group">
                                            <label for="date">Amount</label>
                                            <input style="width: 90%" type="number" name="date" class="form-control"
                                                   id="amount">
                                        </div>
                                    </div>
                                    <div class="col-md-9">
                                        <div class="form-group">
                                            <label for="date">Reason</label>
                                            <div style="display: flex; gap: 30px">
                                                <input style="width: 70%" type="text" name="date" class="form-control"
                                                    id="reason" placeholder="Reason...">
                                                <button class="btn btn-primary" onclick="submitData()">Save
                                                    Expense</button>
                                            </div>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </section>

        <section class="content">
            <div class="container-fluid">
                <div class="row">
                    <div class="col-12">
                        <div class="card">
                            <div class="card-header">
                                <h3 class="card-title">Expenses</h3>
                            </div>
                            <!-- /.card-header -->
                            <div class="card-body">
                                <div class="card-body table-responsive p-0">
                                    <table class="table table-head-fixed text-nowrap" id="expenses_table">
                                        <thead>
                                            <tr>
                                                <th>Date</th>
                                                <th>Category</th>
                                                <th>Type</th>
                                                <th>Amount</th>
                                                <th>Reason</th>
                                                <th>Action</th>
                                            </tr>
                                        </thead>
                                        <tbody>
                                            @foreach ($expenses as $index => $expense)
                                                <tr>
                                                    <td>{{ $expense->Date }}</td>
                                                    <td>{{ $expense->Type }}</td>
                                                    <td>{{ $expense->Category }}</td>
                                                    <td>{{ number_format($expense->Amount, 2) }}</td>
                                                    <td>{{ $expense->Reason }}</td>
                                                    @if($expense->Category=="OutStock")
                                                        <td><button class="btn btn-danger" disabled>Delete</button></td>
                                                    @else
                                                        <td><button onclick="deleteData('{{ $expense->idExpenses }}')"
                                                                    class="btn btn-danger">Delete</button></td>
                                                    @endif

                                                </tr>
                                            @endforeach
                                        </tbody>
                                    </table>
                                </div>
                            </div>
                            <!-- /.card-body -->
                        </div>
                    </div>
                </div>
            </div>
        </section>
        <!-- /.content -->
    </div>
    <!-- /.content-wrapper -->
@endsection

@section('script')
    <script src="../plugins/jquery/jquery.min.js"></script>
    <script src="http://cdnjs.cloudflare.com/ajax/libs/bootstrap-datepicker/1.3.0/js/bootstrap-datepicker.js"></script>


    <script src="../plugins/datatables/jquery.dataTables.min.js"></script>
    <script src="../plugins/datatables-bs4/js/dataTables.bootstrap4.min.js"></script>
    <script src="../plugins/datatables-responsive/js/dataTables.responsive.min.js"></script>
    <script src="../plugins/datatables-responsive/js/responsive.bootstrap4.min.js"></script>
    <script src="../plugins/datatables-buttons/js/dataTables.buttons.min.js"></script>
    <script src="../plugins/datatables-buttons/js/buttons.bootstrap4.min.js"></script>
    <script src="../plugins/jszip/jszip.min.js"></script>
    <script src="../plugins/pdfmake/pdfmake.min.js"></script>
    <script src="../plugins/pdfmake/vfs_fonts.js"></script>
    <script src="../plugins/datatables-buttons/js/buttons.html5.min.js"></script>
    <script src="../plugins/datatables-buttons/js/buttons.print.min.js"></script>
    <script src="../plugins/datatables-buttons/js/buttons.colVis.min.js"></script>
    <!-- Bootstrap 4 -->
    <script src="../plugins/bootstrap/js/bootstrap.bundle.min.js"></script>
    <script src="../plugins/select2/js/select2.full.min.js"></script>
    <!-- jquery-validation -->
    <script src="../plugins/jquery-validation/jquery.validate.min.js"></script>
    <script src="../plugins/jquery-validation/additional-methods.min.js"></script>
    <!-- AdminLTE App -->
    <script src="../dist/js/adminlte.min.js"></script>

    <!-- AdminLTE for demo purposes -->
    <script src="../dist/js/demo.js"></script>
    <script src="../JS/validate.js"></script>
    <script src="https://cdn.jsdelivr.net/npm/sweetalert2@11"></script>
    <script>
        $(function() {


            $('#expenses_table').DataTable({
                "paging": true,
                "lengthChange": false,
                "searching": true,
                "ordering": true,
                "order": [[0, "desc"]], // Order by the first column (Date) in descending order
                "info": true,
                "autoWidth": false,
                "responsive": true,
                "buttons": [
                    {
                        extend: 'copy',
                        exportOptions: {
                            columns: ':not(:last-child)' // Exclude last column from copy
                        }
                    },
                    {
                        extend: 'csv',
                        exportOptions: {
                            columns: ':not(:last-child)' // Exclude last column from CSV
                        }
                    },
                    {
                        extend: 'excel',
                        exportOptions: {
                            columns: ':not(:last-child)' // Exclude last column from Excel
                        }
                    },
                    {
                        extend: 'pdf',
                        exportOptions: {
                            columns: ':not(:last-child)' // Exclude last column from PDF
                        }
                    },
                    {
                        extend: 'print',
                        exportOptions: {
                            columns: ':not(:last-child)' // Exclude last column from PDF
                        }
                    }
                ]
            }).buttons().container().appendTo('#expenses_table_wrapper .col-md-6:eq(0)');






            let today = new Date().toISOString().split('T')[0];

            $("#date").val(today);
        })

        const submitData = () => {
            const date = $('#date').val();
            const amount = $('#amount').val();
            const reason = $('#reason').val();
            const category = $('#category').val();
            const type = $('#type').val();

            if (date === '') {
                Swal.fire(
                    'Error!',
                    'Please select a date !',
                    'error'
                );
            } else if (amount === '') {
                Swal.fire(
                    'Error!',
                    'Please enter amount !',
                    'error'
                );
            } else if (reason === '') {
                Swal.fire(
                    'Error!',
                    'Please enter reason !',
                    'error'
                );
            } else {
                Swal.fire({
                    title: 'Are you sure?',
                    text: "Do you want to save ?",
                    icon: 'warning',
                    showCancelButton: true,
                    confirmButtonColor: '#3085d6',
                    cancelButtonColor: '#d33',
                    confirmButtonText: 'Yes, Save it!'
                }).then((result) => {
                    if (result.isConfirmed) {
                        $.ajax({
                            type: "POST",
                            url: '/expenses',
                            headers: {
                                'X-CSRF-TOKEN': $('meta[name="csrf-token"]').attr('content')
                            },
                            data: {
                                date: date,
                                amount: amount,
                                reason: reason,
                                category: category,
                                type: type,
                            },
                            success: function(data) {
                                // Check if the response contains the 'message' key
                                if (data && data.message && data.message === '1') {
                                    Swal.fire({
                                        position: 'center',
                                        icon: 'success',
                                        title: 'Successfully saved !',
                                    }).then(function() {
                                        window.location.reload();
                                    });
                                } else {
                                    Swal.fire({
                                        position: 'center',
                                        icon: 'error',
                                        title: 'Failed to save data!',
                                    });
                                }
                            },
                            error: function(xhr, status, error) {
                                // Handle AJAX errors
                                Swal.fire({
                                    position: 'center',
                                    icon: 'error',
                                    title: 'An error occurred while processing your request!',
                                });
                            }
                        });
                    }
                });
            }
        }

        const deleteData = (id) => {
            Swal.fire({
                title: 'Are you sure?',
                text: "Do you want to delete ?",
                icon: 'warning',
                showCancelButton: true,
                confirmButtonColor: '#3085d6',
                cancelButtonColor: '#d33',
                confirmButtonText: 'Yes, Delete it!'
            }).then((result) => {
                if (result.isConfirmed) {
                    $.ajax({
                        type: "GET",
                        url: '/expenses/' + id,
                        headers: {
                            'X-CSRF-TOKEN': $('meta[name="csrf-token"]').attr('content')
                        },
                        success: function(data) {
                            Swal.fire({
                                position: 'center',
                                icon: 'success',
                                title: 'Successfully deleted !',
                            }).then(function() {
                                window.location.reload();
                            });
                        }
                    });
                }
            });
        }
    </script>
@endsection