@extends('layouts.view')
@section('title','Users Management')
@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 {{ $data['savedreports']->name }} Query</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
                            <input type="hidden" id="querytext" name="querytext" value="{{ $data['savedreports']->query_text }}">
                        <label style="margin-right:30px;"> <span>Rig Name   : </span> <input class="form-control" type="text" id="reg_name" name="reg_name" value="{{ $data['savedreports']->reg_names }}" />
                        <span><code>For Multi Rigs Please Put Comma(,) between names.Example:Rig 1,Rig 2</code></span>
                        </label>
 
                        <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 >
                            <button style="margin-top:-60px" type="button" id="submit" class="btn btn-gradient-primary waves-effect waves-light" >Execute Query</button>
                            
                        </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>
 <div id="loader" style='text-align:center;display:none;'> <img src="{{ asset('assets/images/unnamed-2.gif') }}"></div>
                                        </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('querytext').value;
           

var obj = jQuery.parseJSON(arraydata);
$.each(obj, function(key,value) {
  //alert(value);
  var Columns = value.split('.');
                   NameWithUppercaseFirstLetter =  Columns[1].charAt(0).toUpperCase() + Columns[1].slice(1);
                   
   $('#datatable-buttons-ahmed thead tr').append(
       '<th>' + NameWithUppercaseFirstLetter + '</th>' 
    );
}); 
$('#datatablebb tbody').on('click', '.addrig', function () {
      
            if($(this).prop("checked") == true) {
             var newrig=$(this).data('rigname');
            // alert(newrig);
             regsname.push(newrig);
             $('#reg_name').val(regsname);
            }else{
                
            }
		
        });
 $("#loader").hide();

            $('#submit').click(function () {
                $.ajax({
                    url:"{{route('run_query')}}",
                    type:'POST',
                    data:{
                        'columns':arraydata,
                        'date_from':$('#date_from').val(),
                        'date_to':$('#date_to').val(),
                        'reg_name':$('#reg_name').val(),
                        "_token": "{{ csrf_token() }}",
                    },
                    beforeSend: function(){
                      $("#loader").show();
                 }
                }).done( function(data) {
                    $("#loader").hide();
                    var table =   $('#datatable-buttons-ahmed').DataTable( {
                        lengthChange: false,
                        buttons: ['copy', 'excel', 'pdf', 'colvis'],
                        aaData: data.data,
                        columns: data.columns,

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