@extends('admin.layouts.masterlayout')
@section('styles')

<link href="{{asset('new_theme/assets/plugins/datatable/css/dataTables.bootstrap5.min.css')}}" rel="stylesheet" />
@endsection
@section('content')
<div class="main-content">
    
    <div class="row">
        <div class="col-12">
            <div class="card" data-aos="fade-up">
                <div class="card-header">
                        <h4>Invested Report</h4>
                    </div>
                <div class="col-md-12 p-3">
                    <div class="row g-3">
                            {{ Form::open(['role' => 'form','id'=>'Downlode_INVESTEDForm','route'=>['TransactionManager.investedamount'],'files' => true,'method' => 'post']) }}
                            {{csrf_field()}}
                            @php
                            $matchkey="";$start_date="";$end_date="";
                            if(isset($_GET['start_date'])){
                                $start_date = $_GET['start_date'];
                            }
                            if(isset($_GET['end_date'])){
                                $end_date = $_GET['end_date'];
                            }
                            @endphp
                            <div class="row g-3">
                                <div class="form-group col-md-3 mb-0">
                                    <label>Start Date</label>
                                    <div class="form-group col-md-6">
                                    <input type="text" required="" name="start_date" id="start_date" class="pull-left form-control datetimepickerget w-95" value="{{isset($start_date) && !empty($start_date) ? $start_date:date('Y-m-01  h:i:s')}}" autocomplete="off">
                                    </div>
                                </div>
                                <div class="form-group col-md-3 mb-0">
                                    <label>End Date</label>
                                    <div class="form-group col-md-6">
                                    <input type="text" required="" name="end_date" id="end_date" class="pull-left form-control datetimepickerget w-95" value="{{isset($end_date) && !empty($end_date) ? $end_date:date('Y-m-d h:i:s')}}" autocomplete="off">
                                    </div>
                                </div>
                                <div class="form-group col-md-3 mb-0">
                                    <label>Search Data</label>
                                    <div class="form-group col-md-12">
                                        <button class="btn btn-primary" id="usersWalletData" type="button">Search Data</button>
                                    </div>
                                </div>

                                <div class="form-group col-md-3 mb-0">
                                    <label>Download Data</label>

                                    <div class="form-group col-md-12">
                                        <input type="hidden" name="download" value="1">
                                        <button class="btn btn-primary" type="submit">Download Invested Report</button>

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

                            {{ Form::close() }}


                    </div>
                </div>

                <div class="card-body">
                    <div class="table-responsive">
                        <table id="dataList" class="table table-striped table-bordered"  style="width:100%">
                            {{-- SrNo
                            Sports
                            Series Name
                            Match Name
                            Match ID

                            Match Final Status
                            Invested Total Amount --}}
                            <thead>
                                <tr>
                                <th>S No.</th>
                                <th>Sports</th>
                                <th>Series Name</th>
                                <th>Match Name</th>
                                <th>Match Id</th>
                                <th>Start Date</th>
                                <th>Match Final Status</th>
                                <th>Invested Total Amount</th>

                            </tr>
                            </thead>

                        </table>
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>
@endsection
@section('scripts')
<script src="{{asset('new_theme/assets/plugins/datatable/js/jquery.dataTables.min.js')}}"></script>
<script src="{{asset('new_theme/assets/plugins/datatable/js/dataTables.bootstrap5.min.js')}}"></script>
<script type="text/javascript">
      var fieldname = '';
      var filtercolums = {

      }

      function cancelEvent(){
        event.stopPropagation();
      }

      var input_filter_teamname = '';


      function updateURL(event , fieldname){
        var value = event.target.value;

        if(fieldname == 'filter_teamname'){
          input_filter_teamname = value;
        }


        var url = window.location.href.split('?')[0];
        history.pushState('', '', url+"?filter=1&filter_teamname="+input_filter_teamname);

      }

      function filterData(event , fieldname){

        var value = event.target.value;
         updateURL(event,fieldname);

        if(fieldname == 'filter_teamname'){
          filtercolums['filter_teamname'] = value;
        }
        //URL UPDATE

        $('#dataList').DataTable().clear().destroy(); //clear table data Table

        $('#dataList').DataTable({
             order: [0, 'desc'],
            "processing": true,
            "serverSide": true,
            "ajax":{
              url:"{{route($modelName.'.investedamount')}}",
              type: "POST",
              data : {"_token": "{{ csrf_token() }}" , "filter_columns":filtercolums}
            },

            "columns": [
              {data: 'DT_RowIndex', name: 'DT_RowIndex'},
              {data: 'sports', name: 'sports'},
              {data: 'series_name', name: 'series_name'},
              {data: 'match_name', name: 'match_name'},
              {data: 'matchkey', name: 'matchkey'},
              {data: 'start_date', name: 'start_date'},
              {data: 'final_status', name: 'final_status'},
              {data: 'investedamount', name: 'investedamount'}
            ]
        });

        document.getElementById(fieldname).focus();
      }

</script>

<script type="text/javascript">
$(document).ready(function() {

    usersWalletData();

    $(document).on('click','#usersWalletData', function(){
        $('#dataList').DataTable().clear().destroy();
        usersWalletData();
    });

    function usersWalletData(){
      let filter_teamname = '';
      let filter_email = '';
      let filter_mobile = '';
      let filter_start_date = $('#start_date').val();
      let filter_end_date = $('#end_date').val();

      var filtercolums = {

      }
      // FOR SELECT Filtering
      if(filter_teamname !==''){
        filtercolums['filter_teamname'] = filter_teamname;
      }
      if(filter_email !==''){
        filtercolums['filter_email'] = filter_email;
      }
      if(filter_mobile !==''){
        filtercolums['filter_mobile'] = filter_mobile;
      }

      if(filter_start_date !==''){
        filtercolums['filter_start_date'] = filter_start_date;
      }


      if(filter_end_date !==''){
        filtercolums['filter_end_date'] = filter_end_date;
      }
      $('#dataList').DataTable().clear().destroy();

        $('#dataList').DataTable({
            "processing": true,
            "serverSide": true,
            "ajax":{
              url:"{{route($modelName.'.investedamount')}}",
              type: "POST",
                  data : {"_token": "{{ csrf_token() }}" , "filter_columns":filtercolums }
            },
            "columns": [
              {data: 'DT_RowIndex', name: 'DT_RowIndex'},
              {data: 'sports', name: 'sports'},
              {data: 'series_name', name: 'series_name'},
              {data: 'match_name', name: 'match_name'},
              {data: 'matchkey', name: 'matchkey'},
              {data: 'start_date', name: 'start_date'},
              {data: 'final_status', name: 'final_status'},
              {data: 'investedamount', name: 'investedamount'}
            ]
        });

        return true;
    }


});
</script>
@endsection