@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">Customer Statement</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">Customer</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>Job Number</label>
                    <select class="form-control jobnumber" name="job_number"></select>
                </div>
            </div>
            <div class="col-md-4">
                <div class="form-group">
                    <label>Customer</label>
                    @if(Auth::user()->role_id == 3)
                        <select class="form-control" name="customer">
                            <option value="{{ Auth::user()->customer->id }}">
                                {{ Auth::user()->customer->customer_name }}
                            </option>
                        </select>
                    @else
                        <select class="form-control customer" name="customer"></select>
                    @endif
                </div>
            </div>
            <div class="col-md-4">
                <div class="form-group">
                    <label>Lc / Bt / TT No</label>
                    <select class="form-control lc" name="lc"></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">Customer Statement</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>Action</th>-->
                            <th>#</th>
                            <th class="text-center">Job</th>
                            <th>Po Number</th>
                            <th>BL Number</th>
                            <th class="text-center" >LC/BT/TT Number</th>
                            <th>Item Name</th>
                            <th>Quantity </th>
                            <th>Value</th>
                            <th>Arrival Date</th>
                            <th>Arrived Date</th>
                            <th>Remaining Document</th>
                            <th>Remarks</th>
                        </tr>
                        </thead>
                         <tbody>

                         </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]],
            ajax: {
                url: "{{URL::to('admin/customerstatement')}}",
                type: "GET",
                data: function ( d ) {  
 
                    d.job_number = $('select[name=job_number]').val();
                    d.customer = $('select[name=customer]').val();
                    d.lc = $('select[name=lc]').val();
                    d.sdate = $('input[name=sdate]').val();
                    d.edate = $('input[name=edate]').val();
                    d.search = $('input[name=search]').val();

                 }

            },
            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');
            });

        });
    });
    
$(document).ready(function () {
    $("#download_pdf").click(function () {
        $.ajax({
            url: "{{ route('statment.download.pdf') }}", // Laravel route
            type: "POST",
            data: {
                _token: "{{ csrf_token() }}", // CSRF token for security
                job_number: $("select[name='job_number']").val(),
                customer: $("select[name='customer']").val(),
                lc: $("select[name='lc']").val(),
                sdate: $("input[name='sdate']").val(),
                edate: $("input[name='edate']").val(),
                search: $("input[name='search']").val()
            },
            xhrFields: {
                responseType: 'blob' // Important for downloading files
            },
            beforeSend: function () {
                $("#download_pdf").text("Generating...").prop("disabled", true);
            },
            success: function (response, status, xhr) {
                var filename = xhr.getResponseHeader('Content-Disposition').split('filename=')[1].replace(/"/g, '');
                var blob = new Blob([response], { type: "application/pdf" });
                var link = document.createElement("a");
                link.href = window.URL.createObjectURL(blob);
                link.download = filename; // Dynamically set filename
                document.body.appendChild(link);
                link.click();
                document.body.removeChild(link);
            },
            complete: function () {
                $("#download_pdf").text("Download PDF").prop("disabled", false);
            },
            error: function (xhr, status, error) {
                alert("Error generating PDF. Please try again.");
            }
        });
    });
});


    </script>
@endsection