@extends('admin.partials.layout')
@section('css')

<link rel="stylesheet" type="text/css"
href="{{asset('admin/assets/node_modules/datatables.net-bs4/css/dataTables.bootstrap4.css')}}">
<link rel="stylesheet" type="text/css"
href="{{asset('admin/assets/node_modules/datatables.net-bs4/css/responsive.dataTables.min.css')}}">


<style>
    
    table td{
        /* border: 1px solid lightgray; */
    }

    table th{
        /* border: 1px solid lightgray; */
    }

    @media (max-width: 767px){
        .container-fluid, .container-sm, .container-md, .container-lg, .container-xl, .container-xxl {
           
            overflow: scroll!important;
        }
    }

    .dataTables_info {
     float: right;
    }


</style>
@endsection

@section('content')
    <div class="row page-titles">
        <div class="col-md-5 align-self-center">
            <h4 class="text-themecolor">Job Expense List 
            </h4>
        </div>
        <div class="col-md-7 align-self-center text-end">
            <div class="d-flex justify-content-end align-items-center">
                <ol class="breadcrumb justify-content-end">
                    <li class="breadcrumb-item"><a href="javascript:void(0)">Home</a></li>
                    <li class="breadcrumb-item active">Job Expense</li>
                </ol>
            </div>
        </div>
    </div>

 <div class="row">
    <div class="col-sm-12">
        <section class="card">
            <header class="card-header bg-info">
                <h4 class="mb-0 text-white">Search</h4>
            </header>
            <div class="card-body">
                <div class="row">
                    <!-- Job Number Selector -->
                    <div class="col-md-4">
                        <div class="form-group">
                            <label>Job Number</label>
                            <select class="form-control jobnumbernew" name="job_number">
                               
                            </select>
                        </div>
                    </div>
                    
                    <!-- Bank Selector -->
                    <div class="col-md-4">
                        <div class="form-group">
                            <label>Bank</label>
                            <select class="form-control account" name="bank">
                           
                           
                            </select>
                        </div>
                    </div>


                    <!-- Category -->
                    <div class="col-md-4">
                        <div class="form-group">
                            <label>Category</label>
                            <select class="form-control category" name="category">
                                
                            </select>
                        </div>
                    </div>

                    <!-- Start Date -->
                    <div class="col-md-4">
                        <div class="form-group">
                            <label>Start Date</label>
                            <input type="date" class="form-control" name="start_date" />
                        </div>
                    </div>

                    <!-- End Date -->
                    <div class="col-md-4">
                        <div class="form-group">
                            <label>End Date</label>
                            <input type="date" class="form-control" name="end_date" />
                        </div>
                    </div>
                    <div class="col-md-4">
                        <div class="form-group">
                            <label>Search</label>
                            <input type="text" class="form-control" name="search" />
                        </div>
                    </div>

                    <!-- Search Button -->
                    <div class="col-md-12 text-center mt-3">
                        <button type="button" class="search_btn btn btn-primary">Search</button>
                    </div>
                </div>
            </div>
        </section>
    </div>
</div>



    <!-- page start-->
                <div class="row">
                    <div class="col-sm-12">
                        <section class="card">
                            <header class="card-header bg-info">
                                <div class="row">
                                    <div class="col-md-6 align-self-center">
                                        <h4 class="mb-0 text-white" >All Job Expense List</h4>
                                    </div>
                                    <div class="col-md-6 text-end">
                                        @if(Auth::user()->permission('account.create'))
                                        <a class="btn btn-primary" href="{{URL::to('admin/jobexpense/create')}}">Create New </a>
                                        @endif
                                    </div>
                                </div>
                            </header>
                        <div class="card-body">    
                        <!--    <table id="example23" class="mydatatable display nowrap table table-hover table-striped border" cellspacing="0" width="100%">-->
                        <!--            <thead>-->
                        <!--                <tr class="" >-->
                        <!--                    <th>#</th>-->
                        <!--                    <th>Category</th>-->
                        <!--                    <th>Job Number</th>-->
                        <!--                    <th>BL Number</th>-->
                        <!--                    <th>Bill Number</th>-->
                        <!--                    <th>Check Number</th>-->
                        <!--                    <th>Amount</th>-->
                        <!--                    <th>Bank</th>-->
                        <!--                    <th>Date</th>-->
                                       
                        <!--                    <th class="hidden-phone" >Action</th>-->
                        <!--                </tr>-->
                        <!--             </thead>-->
                        <!--            <tbody>-->
                        <!--     </tbody>-->
                        <!--</table>-->
                        
                        
                        <table id="example23" class="mydatatable display nowrap table table-hover table-striped border" cellspacing="0" width="100%">
    <thead>
        <tr>
            <th>#</th>
            <th>Category</th>
            <th>Job Number</th>
            <th>BL Number</th>
            <th>Bill Number</th>
            <th>Check Number</th>
            <th>Amount</th>
            <th>Bank</th>
            <th>Date</th>
            <th class="hidden-phone">Action</th>
        </tr>
    </thead>
    <tbody>
        <!-- Dummy data will be inserted here dynamically -->
    </tbody>
</table>
                  </div>
               </div>
             </section>
         </div>

@endsection

 @section('js')

       <!-- This is data table -->
       <script src="{{asset('admin/assets/node_modules/datatables.net/js/jquery.dataTables.min.js')}}"></script>
       <script src="{{asset('admin/assets/node_modules/datatables.net-bs4/js/dataTables.responsive.min.js')}}"></script>
       <script src="https://www.fatwaqa.com/admin/assets/node_modules/switchery/dist/switchery.min.js"></script>

       <script>
       
  $(function () {
//     var application_table = $('.mydatatable').DataTable({
//         processing: true,
//         "searching": true,
//         ordering: false,
//         fixedColumns: false,
//         fixedHeader: false,
//         scrollCollapse: false,
//         scrollX: true,
//         autoWidth: false,
//         dom: 'lirtp',
//         serverSide: true,
//         lengthMenu: [[10,25, 50, 100,500],[10,25, 50, 100,500]],
//         ajax: {
//             url: "{{ URL::to('admin/expense/index') }}",
//             type: "GET",
//             data: function (d) {
//                 d.search = $('input[name=search]').val();
//                 d.job_number = $('select[name=job_number]').val();
//                 d.bank = $('select[name=bank]').val();
//                 d.category = $('select[name=category]').val();
//                 d.start_date = $('input[name=start_date]').val();
//                 d.end_date = $('input[name=end_date]').val();
//             }
//         },
//         columnDefs: [
//             { 
//                 targets: -1,
//                 className: "text-center"
//             }
//         ]
//     });

//     // Filter ke button pe AJAX chalayega
//     $(".search_btn").click(function () {
//         application_table.draw();
//     });


// });


    </script>
    
    
    
    
    <script>
    // Dummy data
    const dummyData = [
        {
            id: 1,
            category: "Category 1",
            jobNumber: "JOB001",
            blNumber: "BL001",
            billNumber: "BILL001",
            checkNumber: "CHK001",
            amount: "$1000",
            bank: "Bank A",
            date: "2023-10-01"
        },
        {
            id: 2,
            category: "Category 2",
            jobNumber: "JOB002",
            blNumber: "BL002",
            billNumber: "BILL002",
            checkNumber: "CHK002",
            amount: "$2000",
            bank: "Bank B",
            date: "2023-10-02"
        },
        {
            id: 3,
            category: "Category 3",
            jobNumber: "JOB003",
            blNumber: "BL003",
            billNumber: "BILL003",
            checkNumber: "CHK003",
            amount: "$3000",
            bank: "Bank C",
            date: "2023-10-03"
        }
    ];

    // Function to populate the table with dummy data
    function populateTable() {
        const tbody = document.querySelector("#example23 tbody");

        dummyData.forEach((item) => {
            const row = document.createElement("tr");

            // Add data to each cell
            row.innerHTML = `
                <td>${item.id}</td>
                <td>${item.category}</td>
                <td>${item.jobNumber}</td>
                <td>${item.blNumber}</td>
                <td>${item.billNumber}</td>
                <td>${item.checkNumber}</td>
                <td>${item.amount}</td>
                <td>${item.bank}</td>
                <td>${item.date}</td>
                <td>
                    <a class="btn btn-primary btn-sm" href="{{route('jobeditexp')}}">Edit</a>
                </td>
            `;

            tbody.appendChild(row);
        });
    }

    // Function to handle edit button click
    function editItem(id) {
        alert(`Edit item with ID: ${id}`);
        // You can add your edit logic here, such as opening a modal or redirecting to an edit page
    }

    // Populate the table when the page loads
    document.addEventListener("DOMContentLoaded", populateTable);
</script>
@endsection