@extends('includes.master')
  @section('content')
<style>
.error_class{
  color:red;
}
.success_class{
  color:green;
}

</style>

          <div class="right_col" role="main">
            <div class="row  class="right_col"">
<div class="col-md-12 float-none"><b style="font-size: 25px;font-size: 22px; padding: 5px 10px;background: #fff;font-weight: normal; display: block; margin-bottom: 10px;">Monthly Final Premium Excel Report</b></div>
              <div class="col-md-12 col-sm-12 col-xs-12">
                <div class="x_panel">        

                  <div class="x_content">
                    <!-- <p class="text-muted font-13 m-b-30"></p>
                    <b style="font-size: 30px">Monthly Final Premium Excel Report</b><br><hr> -->
               <form class="form-horizontal" name="premium_report_form"  id="premium_report_form">
                    {{csrf_field()}}
          

                  <div class="col-md-12">
                      <div class="form-group row">
                        <label for="state_name" class="col-sm-2 col-form-label">Company Name:</label>
                        <div class="col-sm-6">
                          <select class="form-control" id="comp_name" name="comp_name" required>
                            <option  selected value="0">Select Company</option>
                          @if((Session::get('role_id') == 3 ) or (Session::get('role_id') == 4 ) or (Session::get('role_id') == 5 ))                          
                          @endif
                           @foreach($comp as $val)
                           <option value="{{$val->comp_id}}">{{$val->comp_name}}</option>
                           @endforeach
                          </select> 
                          <label id="err_comp_name" class="error_class"></label>                 
                        </div>
                      </div>
                  </div>
                  

                    <div class="col-md-12">
              <div class="form-group row">
                <label for="state_name" class="col-sm-2 col-form-label">Month/Year:</label>
                <div class="col-sm-6">
                  <div id="MonthYear">

                  <div class="form-control">
                   <select type="text" id="monthwise" class="form-control1"   name="monthwise" required>
                    <option value="0">Select Month</option>
                    <option value="01">January</option>
                    <option value="02">February</option>
                    <option value="03">March</option>
                    <option value="04">April</option>
                    <option value="05">May</option>
                    <option value="06">June</option>
                    <option value="07">July</option>
                    <option value="08">August</option>
                    <option value="09">September</option>
                    <option value="10">October</option>
                    <option value="11">November</option>
                    <option value="12">December</option>
                  </select>

        

                  <select type="text"  id="yearwise" name="yearwise" class="form-control1" required>
                    <option value="0">Select Year</option>
                    <option value="2019">2019</option>
                    <option value="2018">2018</option>
                    <option value="2017">2017</option>
                    <option value="2016">2016</option>
                    <option value="2015">2015</option>
                    <option value="2014">2014</option>
                    <option value="2013">2013</option>
                    <option value="2012">2012</option>
                    <option value="2011">2011</option>
                    <option value="2010">2010</option>
                    <option value="2009">2009</option>
                    <option value="2008">2008</option>
                  </select>

                </div>

                <label id="err_month_year" class="error_class"></label>

              </div>

              </div>

            </div>
          </div>

            
            



                  
                 <div class="col-md-10 col-md-offset-2">
                  <button type="button" id="btn_submit" name="btn_submit" class="btn btn-lg btn-success">Show Data</button>
                   </div>
                



               <div class="loader" id="" style= "display: none; position: absolute; top: 0px; left: 0px; width: 100%; height: 100%;">
               <img src="{{URL::to('images/processing.gif')}}" alt="Loader" title="Loader" style="top: 40%; position: relative; left: 40%; z-index: 300;"  />                  
              </div>

              

                 <div id="divhistory">
                   
                 </div>



                 </form>   



               

                  </div>


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


      
                
               


<script type="text/javascript">
  $("#btn_submit").click(function(){ 
   

    $(".error_class").empty();
    $(".success_class").empty();

    $(".loader").show();
    var formdata = new FormData($("#premium_report_form")[0]);
//if(data){
     $.ajax({
     type : 'post',
     url : "{{ URL::to('/premium-final-report-xls-download') }}",
     data : formdata,
     contentType : false,
     processData : false,
     success : function(msg){

 $(".loader").hide();
  var response = JSON.parse(msg);



                   if(response.length > 0){
                     
            {
           
                 
 

           var data = JSON.parse(msg);




         var no = 1;
         var str ="<table id='datatable' class='table table-bordered table-striped'><thead><tr><th>Sr.No</th><th>Company Name</th><th>Employee Add</th><th>Delete File</th><th>Correction File</th><th>Created Date</th></tr></thead><tbody>";
       for (var i = 0; i < data.length; i++) 
       {
         str = str + "<tr><td>"+data[i].id+"</td><td>"+data[i].comp_name+"</td><td><a href="+encodeURI(data[i].folder_url_add)+" </a>Download Excel</td><td><a href="+encodeURI(data[i].folder_url_delete)+" </a>Download Excel</td><td><a href="+encodeURI(data[i].correction_file)+" </a>Download Excel</td><td>"+data[i].create_date+"</td></tr>";
       }
         str = str + "</tbody></table>";

          $('#divhistory').html(str);
           $('#datatable').DataTable();  

          
     }


       
        }else{

              $.each(response , function(key , value){
                $("#err_" + key).text(value);
              });
            }
          
        }
        });
   //}
  }); 
</script>


@endsection