@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>    
    @media (max-width: 767px){
        .container-fluid, .container-sm, .container-md, .container-lg, .container-xl, .container-xxl {       
            overflow: scroll!important;
        }
    }

    .dataTables_info {
     float: right;
    }

    .table-hover > tbody > tr:hover {
        --bs-table-accent-bg: none;
        color: none;
    }

    .nearby {
        background: #ff00002b!important;
    }
    .nearby:hover {
        background: #ff00002b!important;
    }
</style>
@endsection

@section('content')
    <div class="row page-titles">
        <div class="col-md-5 align-self-center">
            <h4 class="text-themecolor">Office Expense</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">Reports</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">
                        <div class="col-md-4">
                            <div class="form-group">
                                <label>Category</label>
                                <select class="form-control category" name="job_number"></select>
                            </div>
                        </div>
                        <div class="col-md-4">
                            <div class="form-group">
                                <label>Bank</label>
                                <select class="form-control bank" name="bank"></select>
                            </div>
                        </div>
                        <div class="col-md-4">
                            <div class="form-group">
                                <label>User</label>
                                <select class="form-control bank" name="user"></select>
                            </div>
                        </div>
                        <div class="col-md-4">
                            <div class="form-group">
                                <label>Start Date</label>
                                <input type="date" class="form-control" name="sdate" />
                            </div>
                        </div>
                        <div class="col-md-4">
                            <div class="form-group">
                                <label>End Date</label>
                                <input type="date"  class="form-control" name="edate" />
                            </div>
                        </div>
                        <div class="col-md-4">
                            <div class="form-group">
                                <label>Search</label>
                                <input class="form-control" name="search" />
                            </div>
                        </div>
                        <div class="col-md-12 text-center">
                            <button type="button" class="search_btn btn btn-primary">Search</button>
                            <button type="button" id="download_excel" class="btn btn-success">Download Excel</button>
                            <button type="button" id="download_pdf" class="btn btn-danger">Download Pdf</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">Office Expense Report</h4>
                        </div>
                        <div class="col-md-6 text-end">
                        </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>Date</th>
                            <th>Bank</th>
                            <th>Description</th>
                            <th>Amount</th>
                            <th>User</th>
                            <th>Action</th>
                        </tr>
                        </thead>
                         <tbody>
                            <tr class="">
                                <td>#</td>
                                <td>K Electric Bill</td>
                                <td>12-5-2025</td>
                                <td>Al Falah</td>
                                <td>Description</td>
                                <td>500</th>
                                <td>Farhan Khan</td>
                                <td><button class="btn btn-success">View</button></td>
                            </tr>
                         </tbody>
                        </table>
                    </div>
                </div>
            </section>
         </div>
@endsection

@section('js')



       <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 src="https://cdnjs.cloudflare.com/ajax/libs/xlsx/0.17.0/xlsx.full.min.js"></script> --}}
       <script src="https://cdn.jsdelivr.net/npm/exceljs/dist/exceljs.min.js"></script>

       <script src="https://cdnjs.cloudflare.com/ajax/libs/FileSaver.js/2.0.5/FileSaver.min.js"></script>

       <script>
        $(function () {
          
            var application_table = $('.mydatatable').DataTable({
            processing: true,
            "searching": true,  
            fixedColumns: false,
            ordering:false,
            fixedHeader: false,
            scrollCollapse: false,
            scrollX: true,
            // scrollY: '500px',
            autoWidth: false, 
            dom: 'lirtp',
            // serverSide: true,
            lengthMenu: [[10,25, 50, 100,500],[10,25, 50, 100,500]],
            initComplete: function () {                
            },
            createdRow: function (row, data, dataIndex) {  
              if (data[12] == 'nearby') {
                $(row).addClass(data[12]);
              }
           }
        });

        application_table.on( 'draw', function () {
            
        } );

        $(".search_btn").click(e =>{ 
            application_table.draw();
        });

        $('input[name=search]').change(function (e) { 
            application_table.draw();
        });


        $(".mydatatable").delegate(".is_status", "change", function(){
            $.toast({
                heading: "Status Change Successfully",
                position: 'top-right',
                loaderBg: '#ff6849',
                icon: 'success',
                hideAfter: 3500,
                stack: 6,
            });
        });

        $("#download_excel").click(function(){

            var table = document.querySelector("#example23");
            let dataArray = [];

            dataArray.push([
                'Customer Statement '+ $('select[name=customer] option:checked').text(),
            ]);
            dataArray.push([
                'ID',
                'Job',
                'Po No',
                'BL No',
                'LC/BT/TT No',
                'Item Name',
                'Quantity',
                'Item Amount',
                'Arrival Date',
                'Arrived Date',
                'Remaining Document',
                'Remarks',  
            ]);
            $('#example23 tbody tr').each(function(){
                dataArray.push([
                    $(this).find('td:eq(0)').html(),
                    $(this).find('td:eq(1)').html(),
                    $(this).find('td:eq(2)').html(),
                    $(this).find('td:eq(3)').html(),
                    $(this).find('td:eq(4)').html(),
                    $(this).find('td:eq(5)').html(),
                    $(this).find('td:eq(6)').html(),
                    $(this).find('td:eq(7)').html(),
                    $(this).find('td:eq(8)').html(),
                    $(this).find('td:eq(9)').html(),
                    $(this).find('td:eq(10)').html(),
                    $(this).find('td:eq(11)').html(),  
                ]);
            });


            // var ws = XLSX.utils.aoa_to_sheet(dataArray);
            // ws['!merges'] = [
            //     { s: { r: 0, c: 0 }, e: { r: 0, c: 11 } }, 
            // ];
            // ws['A1'].s = { font: { bold: true }, alignment: { horizontal: "center", vertical: "center" } };
            // var wb = XLSX.utils.book_new();
            // XLSX.utils.book_append_sheet(wb, ws, "Customer Statement");
            // XLSX.writeFile(wb, 'Customer_Statement.xlsx');

            const workbook = new ExcelJS.Workbook();
            const worksheet = workbook.addWorksheet('Customer Statement');
            dataArray.forEach((row) => {
                worksheet.addRow(row);
            });
            worksheet.mergeCells('A1:L1');
            const titleCell = worksheet.getCell('A1');
            titleCell.font = { bold: true, size: 14 };
            titleCell.alignment = { horizontal: 'center', vertical: 'middle' };

            workbook.xlsx.writeBuffer().then((data) => {
                const blob = new Blob([data], { type: 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet' });
                saveAs(blob, 'Customer_Statement.xlsx');
            });

        });
    });
    </script>
@endsection