@extends('layouts.view')
@section('title','Static Report')
@section('content')


    <div class="container-fluid">
        <div class="row">
            <div class="col-sm-12">
                <div class="page-title-box">
                    <div class="float-right">

                    </div>
                    <h4 class="page-title">Run Static Report</h4>
                </div><!--end page-title-box-->
            </div><!--end col-->
        </div><!--end row-->
        <div class="row">
            <div class="col-lg-12">
                <div class="card" >
                    <h5 class="card-header bg-primary text-white mt-0"> Conditions</h5>
                    <div class="card-body">
                        <form class="form-horizontal row-fluid"  method="post" enctype="multipart/form-data">
                            {{csrf_field()}}
                          
                         <input type="hidden" id="columns" name="columns" value="{{$columns}}">

                        <label style="margin-right:30px;"> <span> Date From : </span> <input class="form-control" type="date" id="date_from"  name="date_from" value="2026-03-17" /> <span><code>&nbsp;&nbsp;</code></span></label>
                        <label style="margin-right:30px;"> <span>Date To   : </span> <input class="form-control" type="date" id="date_to" name="date_to" value="2026-03-17" />
                        <span><code>&nbsp;&nbsp;</code></span>
                        </label style="margin-bottom:-20px">
                            <button type="button" id="submit" class="btn btn-gradient-primary waves-effect waves-light" >Execute Report</button>
                             <span><code>&nbsp;&nbsp;</code></span>
                        </form>

                    </div></div>

            </div> </div>
        <div class="row">
        <div class="col-12">
            <div class="card">
                <h5 class="card-header bg-primary text-white mt-0"> Report</h5>
                <div class="card-body">

                    <!-- end col -->

                                    <div id="viewtable">
                                        <h4 class="mt-0 header-title">Query Table </h4>
                                        <p>

                                        </p>

                                        <table id="datatable-buttons-ahmed" class="table table-striped table-bordered dt-responsive nowrap" style="border-collapse: collapse; border-spacing: 0; width: 100%;">
                                            <thead>
                                            <tr>
                                            </tr>
                                            </thead>


                                            <tbody>


                                            </tbody>
                                        </table>
                                    </div>
                                    <!-- end col -->

                    





                                </div></div>

        </div> </div></div>




    <script src="{{ asset('plugins/datatables/jquery.dataTables.min.js') }}"></script>
    <script src="{{ asset('plugins/datatables/dataTables.bootstrap4.min.js') }}"></script>
    <!-- Buttons examples -->
    <script src="{{ asset('plugins/datatables/dataTables.buttons.min.js') }}"></script>
    <script src="{{ asset('plugins/datatables/buttons.bootstrap4.min.js') }}"></script>
    <script src="{{ asset('plugins/datatables/jszip.min.js') }}"></script>
    <script src="{{ asset('plugins/datatables/pdfmake.min.js') }}"></script>
    <script src="{{ asset('plugins/datatables/vfs_fonts.js') }}"></script>
    <script src="{{ asset('plugins/datatables/buttons.html5.min.js') }}"></script>
    <script src="{{ asset('plugins/datatables/buttons.print.min.js') }}"></script>
    <script src="{{ asset('plugins/datatables/buttons.colVis.min.js') }}"></script>
    <script src="{{ asset('plugins/datatables/dataTables.responsive.min.js') }}"></script>
    <script src="{{ asset('plugins/datatables/responsive.bootstrap4.min.js') }}"></script>
    <script src="{{ asset('assets/pages/jquery.datatable.init.js') }}"></script>
    <script>
        $(document).ready(function(){
         var arraydata=document.getElementById('columns').value;
            

var obj = jQuery.parseJSON(arraydata);
$.each(obj, function(key,value) {
  //alert(value);
  var Column= value;
   $('#datatable-buttons-ahmed thead tr').append(
       '<th>' + Column + '</th>' 
    );
}); 


            $('#submit').click(function () {
                $.ajax({
                    type:'POST',
                    url:"/api/first_static_report",
                    //dataType: "json",
                    data:{
                        'date_from':$('#date_from').val(),
                        'date_to':$('#date_to').val(),
                        '_token': $('meta[name="csrf-token"]').attr('content')
                    },
//   'contentType': 'application/json'
                }).done( function(data) {
                    var table =   $('#datatable-buttons-ahmed').DataTable( {
                        lengthChange: false,
                        buttons: ['copy', 'excel', 'pdf', 'colvis'],
                        aaData: data.data,
                      //  columns: data.columns,
                        //lengthChange: false,
                       

                    });
                    table.buttons().container()
                        .appendTo('#datatable-buttons-ahmed_wrapper .col-md-6:eq(0)');

                    $('#row_callback').DataTable( {
                        "createdRow": function ( row, data, index ) {
                            if ( data[5].replace(/[\$,]/g, '') * 1 > 150000 ) {
                                $('td', row).eq(5).addClass('highlight');
                            }
                        }
                    } );





                })

   


            });

        });
    </script>
@endsection