@extends('includes.master')
  @section('content')    

  <div class="right_col" role="main">
    <div class="row  class="right_col"">
	<div class="col-md-12 float-none"><div style="font-size: 22px;font-size: 25px; padding: 5px 10px;background: #fff;font-weight: normal; display: block; margin-bottom: 10px;">Premium Calculator 
</div></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">Premium Calculator</b>
            <br><hr> -->
            
            
            <label id="lblError3" style="color:green;"></label>
            <form class="form-horizontal" method="post" id="calc_premium_form" enctype="multipart/form-data"  >
              {{csrf_field()}}
              
              <div class="col-md-12">
               <div class="form-group row">
                 
                <label for="empcode" class="col-sm-4 col-form-label">Select&nbsp;Company:</label>
                <div class="col-sm-4">
                  <select class="form-control" id="comp_id" name="comp_id" placeholder="Company Code"  required>
                    <option value="0">Select One</option>
                    @foreach($comp as $val)
                    <option value="{{$val->comp_id}},{{$val->cd_balance}}">{{$val->comp_name}}</option>
                    @endforeach
                  </select>
                  <label id="lblError0" style="color: red;"></label>
                </div>
                
                <div id="cd_balance_ap"></div>

              </div>
            </div>



            
            <div class="col-md-12">
             <div class="form-group row">
              <label for="empname" class="col-sm-4 col-form-label">Add employee file (xls):</label>
              <div class="col-sm-4">
                <input type="file" class="form-control" id="excel_xls_add" name="excel_xls_add" placeholder="File"  required >
                <label id="lblError1" style="color: red;"></label>

              </div>
              <a  href="{{URL::to('uploads/employee_details_format.xls')}}" class="btn btn-primary">Download Sample</a>
            </div>
          </div>



          <div class="col-md-12">
           <div class="form-group row">
            <label for="empname" class="col-sm-4 col-form-label">Delete Employee file (xls):</label>
            <div class="col-sm-4">
              <input type="file" class="form-control" id="excel_xls_delete" name="excel_xls_delete" placeholder="File"  required >
              <label id="lblError1" style="color: red;"></label>
            </div>
            <a  href="{{URL::to('uploads/employee_delete.xls')}}" class="btn btn-primary">Download Sample</a>
          </div>
        </div>




        <div class="col-md-12">
         <div class="form-group row">
          <label for="empname" class="col-sm-4 col-form-label">Correction file (xls):</label>
          <div class="col-sm-4">
            <input type="file" class="form-control" id="correction_file" name="correction_file" placeholder="File"  required >
            <label id="lblError1" style="color: red;"></label>
          </div>
          <a  href="{{URL::to('uploads/employee_details_format.xls')}}" class="btn btn-primary">Download Sample</a>
        </div>
      </div>




      <div class="col-md-12 success_class" style="font-size: 20px;" id="success_response">
      </div>



      <center><div class="col-sm-9">
        <input type="Submit" name="Submit" class="btn btn-primary" id="calc_premium" value="Submit">
        
      </div>
    </center>
  </form> 


  <div id="seccess_add" ></div>
  <div id="seccess_del" ></div>



  
  

  <table id="tblItems" class="table table-bordered table-striped">
    <thead>
      <tr>
        <th>Transcation ID</th>
        <th>User Name  </th>
        <th>Company ID</th>
        <th>Company name</th>
        <th>Employee Add</th>
        <th>Employee Delete</th>
        <th>Correction File</th>
        <th>Created Date</th>
        <th>Premium Details</th>
        
        
      </tr>
    </thead>
  </table>

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




<div class="modal" tabindex="-1" role="dialog" id="cl_premium">
  <div class="modal-dialog" role="document">
    <div class="modal-content">
      <div class="modal-header">
        <h5 class="modal-title">Premium </h5>
        <button type="button" class="close" data-dismiss="modal" aria-label="Close">
          <span aria-hidden="true">&times;</span>
        </button>
      </div>
      <div class="modal-body">
        <p id="addmembers"></p>
        <p id="deletemembers"></p>
        <p id="final_premium"></p>
        <p id="cdbalance"></p>
      </div>
      <div class="modal-footer">
       <button type="button" class="btn btn-secondary" data-dismiss="modal">Close</button>
       
     </div>
   </div>
 </div>
</div>






<script type="text/javascript">
 

  $('#calc_premium').click(function(evt){ evt.preventDefault();  
    file1=document.getElementById("excel_xls_add").files.length;
    file2=document.getElementById("excel_xls_delete").files.length;
    file3=document.getElementById("correction_file").files.length;

    
    if($('#comp_id').val()!=0  && file1!=0  && file2!=0 && file3!=0 ){  
     var formdata = new FormData($("#calc_premium_form")[0]);
     $(".iframeloading").show();
     $.ajax({  
       type: "POST",  
       url: "{{URL::to('calc-file')}}",
       data : formdata,
       processData: false,
       contentType : false,
       success: function(msg){   $(".iframeloading").hide();

       var set_color='';

       var add=Array();
       var delet=Array();
       $('#seccess_add').empty();
       $('#seccess_del').empty();



       if(msg.errors==0){
        if(msg.CD_balance<0){set_color='style="color: red;"';}


        $("#addmembers").html('<h4 > Add members :&nbsp; Count ('+msg.total_countadd+')  : &nbsp;  Premium   :&nbsp;&nbsp; '+msg.premium_add.toFixed(3)+'</h4>');
        $("#deletemembers").html('<h4> Delete member : &nbsp; Count ('+msg.total_countdelt+') : &nbsp;  Premium  : &nbsp;&nbsp;'+msg.premium_delete.toFixed(3)+'</h4>');
        $("#final_premium").html('<h4>Final premium after addition and deletion : &nbsp;&nbsp; '+msg.Final_premium.toFixed(3)+'</h4>');
        $("#cdbalance").html('<h4 '+set_color+' >CD balance after changes : &nbsp;&nbsp; '+msg.CD_balance.toFixed(3)+'</h4>');
        $('#cl_premium').modal('show');
        $('#calc_premium_form')[0].reset();
      }else if(msg.errors==2){  
       
        
       if(msg.statusadd!=0){  
        $.each( msg.statusadd, function( key, value ) { 
         $.each( value, function( d, d ) { 

          add.push('<li class="list-group-item list-group-item-warning" > '+d +'</li>');
        });

         


         
       });  $('#seccess_add').append(add); }
        
        if(msg.statusde!=0){

         
         $.each( msg.statusde, function( key, value ) { 

           

          delet.push('<li class="list-group-item list-group-item-warning" > '+value.employee_id+'</li>');
        });$('#seccess_del').append(delet);}

         
         $('#Premium_Calculation').hide('show');
         
         
         



            //$('#calc_premium_form')[0].reset();
          }else{

            alert(msg.status);
          }    
        }
      }); 

   }else{

    alert(" Please Fill From Carefully");

  }

});

  
  
  $(document).ready(function() {


    var full_url=document.URL;  
    var url_array = full_url.split('/')   ;

    if(url_array[3].split('?')[1]){

      let cm_id_ = url_array[3].split('?')[1];
      

      
      if(cm_id_.split('=')[0]=="notification"){ let cm_id = url_array[3].split('=')[1];
      show_premium_details(cm_id);
    }
  }


  var my_columns = [];
  $("#comp_id").change(function () { 
    var end = this.value;
    if(end==0){return false;}
    var myarr = end.split(",");
    $('#cd_balance_ap').html('<h4> CD Balance :   '+myarr[1]+'</h4>');
    show_premium_details(myarr[0]);
    
  });
});






  function show_premium_details(com_id){  
    $(".iframeloading").show();
    
    $.ajax({
     type:"GET",
     url:"{{URL::to('calc-get-premium')}}",
     data:{com_id:com_id},
     success:function(msg){ $(".iframeloading").hide();

     
     
     var mytable = $('#tblItems').DataTable({destroy: true,});
     mytable.rows().remove();
     $.each( msg.messages, function( key, value ) {  
      string1=value.count_add+","+value.count_delete+","+value.total_premium+","+value.total_premium_delete+","+value.Final_premium+","+value.cd_balance;
      mytable.row.add([value.id,value.user_name,value.com_id,value.comp_name,value.folder_url_add,value.folder_url_delete,value.correction_file,value.create_date,string1]);
    });  


     var full_url="{{URL::to('/')}}";
     $('#tblItems').DataTable({destroy: true,
      
      columns: [
      {data:"id"},
      { data: "com_id" },
      { data: "user_name" },
      { data: "comp_name",

      render: function ( data, type, row ) { 
       

        return '<a href="#" >'+row.comp_name+'</a>';
        
      },

    },
    {
      data:   "folder_url_add",
      render: function ( data, type, row ) {

       return '<a href="'+full_url+row.folder_url_add+'">Download  </a>';
       
     },
     
   },
   { data: "folder_url_delete" ,
   render: function ( data, type, row ) {
    return '<a href="'+full_url+row.folder_url_delete+'">Download  </a>';
  },

},
{ data: "correction_file" ,
render: function ( data, type, row ) {
  return '<a href="'+full_url+row.correction_file+'">Download  </a>';
},

},
{ data: "create_date" },
{ data: "string1",

render: function ( data, type, row ) {  
  return "<a href='#'' onclick='get_premium_deteils("+row.string1+");'>Show Premium</a>";
},


},



],

});  

     mytable.draw();


   }
 });
  }



  function get_premium_deteils(count_add,count_delete,total_premium,total_premium_delete,Final_premium,cd_balance){
    $("#addmembers").html('<h4> Add members :  &nbsp; Count ('+count_add+') :  &nbsp;  Premium   &nbsp; : &nbsp;'+total_premium+'</h4>');
    $("#deletemembers").html('<h4> Delete member :  &nbsp;  Count ('+count_delete+') :   &nbsp; &nbsp; Premium : &nbsp;'+total_premium_delete+'</h4>');
    $("#final_premium").html('<h4>Final premium after addition and deletion :  &nbsp; &nbsp;    &nbsp; '+Final_premium+'</h4>');
    $("#cdbalance").html('<h4>CD balance after changes :  &nbsp; &nbsp; '+cd_balance+'</h4>');
    $('#cl_premium').modal('show');
  }

</script>





<style type="text/css">
  
  <style type="text/css">
    .loader{
      position: fixed;
      left: 0px;
      top: 0px;
      width: 100%;
      height: 100%;
      z-index: 9999;
      background: url('images/pageLoader.gif') 50% 50% no-repeat rgb(249,249,249);
      opacity: .8;
    }
  </style>

  @endsection