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

     <div class="right_col" role="main">
            <div class="row  class="right_col"">
              <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>
                    @if (Session::get('role_id')==1 || Session::get('role_id')==3)  <b style="font-size: 20px"> <a href="#" id="cd_balance1">CD Balance</a>   ||</b> @endif 
                    <b style="font-size: 20px"><a href="#" id="History_id1">History</a> ||</b>

               
                    @if (Session::get('role_id')==1 || Session::get('role_id')==3)
                      <b style="font-size: 20px"><a href="#" id="History_id1">Bulk Ecard Upload</a>  </b>
                    @endif 



                    <br><hr>
 
                      
      <label id="lblError3" style="color:green;"></label>
   <input type="hidden" id="cm_id" name="cm_id" value="{{$cd_balance->comp_id}}">

    @if (Session::get('role_id')==1 || Session::get('role_id')==3)
    <div id="cd_balance">    
      <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">Current Balance:</label>
                        <div class="col-sm-4">

                         
                          <input type="hidden" id="com_get_id" name="comp_id" class="form-control" value="{{$cd_balance->comp_id}},{{$cd_balance->cd_balance}}"   placeholder="Company ID"  required>

                          <input type="text"   class="form-control" value="{{$cd_balance->cd_balance}}"  disabled=""     >
                            
                         <label id="lblError0" style="color: red;"></label>
                        </div>
                      </div>
                  </div>


              <div class="col-md-12">
                   <div class="form-group row">
 
                        <label for="empcode" class="col-sm-4 col-form-label">Current Date:</label>
                        <div class="col-sm-4">
                               <input type="text"   id="txtDate" name="txtDate"  placeholder="Date "  class="form-control "         >
                         
                        </div>
                      </div>
               </div>



                  <div class="col-md-12">
                   <div class="form-group row">
 
                        <label for="empcode" class="col-sm-4 col-form-label">Choose operation type:</label>
                        <div class="col-sm-4">
                          <select class="form-control"   name="operation_id" id="operation_id"  required>
                            <option value="0">Select One</option>
                             <option value="1"> Monthly changes</option>
                             <option value="2"> Add new balance</option>
                             <option value="3"> Special case changes</option>
                            
                          </select>
                         <label id="lblError0" style="color: red;"></label>
                        </div>
                      </div>
                  </div>

          

               <div style="display: none" id="operation1">
                  <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_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">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>


             
            
               <div class="col-md-12"  style="display: none" id="operation3">
                   <div class="form-group row">
                        <label for="empcode" class="col-sm-4 col-form-label">Choose operation type:</label>
                        <div class="col-sm-4">
                          <select class="form-control"   name="Chooseoperation_id"  id="Chooseoperation_id" required>
                            <option value="0">Select One</option>
                             <option value="3"> Add</option>
                             <option value="4"  > Delete</option>
                              
                          </select>
                         <label id="lblError0" style="color: red;"></label>
                        </div>
                      </div>
                  </div>



            <div style="display: none" id="operation2">
             <div class="col-md-12">
                   <div class="form-group row">
                        <label for="empname" class="col-sm-4 col-form-label">Balance amount</label>
                        <div class="col-sm-4">
                          <input type="text" class="form-control" id="balance_amount" name="balance_amount" placeholder="Balance amount"  required >
                          <label id="lblError1" style="color: red;"></label>
                        </div>
                      </div>
             </div>
           </div>



           <div class="col-md-12">
             <div class="form-group row">
                  <label for="empname" class="col-sm-4 col-form-label">Remarks</label>
                  <div class="col-sm-4">
                    <input type="text" class="form-control" id="remark" name="remark" placeholder="Remarks"  required >
                    <label id="lblError1" style="color: red;"></label>
                  </div>
                </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>

    @endif 

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

 

<div id="History_id" style="display: none"> 
<!-- <table id="tblItems" class="table table-bordered table-striped">
    <thead>
        <tr>
            <th> Transcation ID</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>


<table id="tblItems2" class="table table-bordered table-striped">
    <thead>
        <tr>
            <th> Transcation ID</th>
            <th>Company ID</th>
            <th>cd balance </th>
            <th>New Balance </th>
            <th>remark </th>
            <th>operation Type</th>
            <th>Created Date</th>
             
             
           
        </tr>
    </thead>
</table>
 -->

<table id="tblItems3" class="table table-bordered table-striped">
</table>
 



 





</div>







 

 



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



<div class="modal" tabindex="-1" role="dialog" id="Premium_Calculation">
  <div class="modal-dialog" role="document">
    <div class="modal-content">
      <div class="modal-header">
        <h5 class="modal-title">Premium Calculation</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="CurrentBalance"></p>
        <p id="Newbalance"></p>
        <p id="final"></p>
         
          <!-- <div class="modal-body">
                <center><div class="col-sm-9 cdbalance_update"  >           
                        </div>
               </center>
          </div> -->


  <strong id="errors_mg"> </strong> 



      </div>
      <div class="modal-footer">
        <div class="col-sm-9 cdbalance_update"  > </div>
       <button type="button" class="btn btn-secondary" data-dismiss="modal">Close</button>
         
      </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">Modal title</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-body">
                <center><div class="col-sm-9 cdbalance_update"  > </div>
               </center>
          </div> -->

       <div class="modal-footer">
       <div class="col-sm-9 cdbalance_update"  > </div>

       <button type="button" class="btn btn-secondary" data-dismiss="modal">Close</button>
         
      </div>
    </div>
  </div>
</div>





      <link rel="stylesheet" type="text/css" href="http://cdnjs.cloudflare.com/ajax/libs/bootstrap-datepicker/1.3.0/css/datepicker.min.css">
      <script type="text/javascript" src="//netdna.bootstrapcdn.com/bootstrap/3.1.1/js/bootstrap.min.js"></script>
      <script type="text/javascript" src="http://cdnjs.cloudflare.com/ajax/libs/bootstrap-datepicker/1.3.0/js/bootstrap-datepicker.js"></script>

<script type="text/javascript">
  
var date=new Date();
var year=date.getFullYear();
var month=date.getMonth();

$('#txtDate').datepicker
({
    format: "mm/yyyy",
    minViewMode: -1,
    autoclose: true,
    startDate: new Date(year, month-1, '01'),
    endDate: new Date(year+1, month, '31')
}); 
</script>

<style type="text/css">
  .datepicker-switch
{
    pointer-events: none;
}
</style>





<script type="text/javascript">

var month_name = function(dt){
mlist = [ "January", "February", "March", "April", "May", "June", "July", "August", "September", "October", "November", "December" ];
  return mlist[dt.getMonth()];
};



$('#cd_balance1').click(function(){
$('#cd_balance').show();
$('#History_id').hide();
});

$('#History_id1').click(function(){  
cm_id=$('#cm_id').val();


$('#cd_balance').hide();
$('#History_id').show();

 
 var trt=Array();
 var tr1=Array();
      $.ajax({
           type:"GET",
           url:"{{URL::to('cd-balance-details')}}",
           data:{cm_id:cm_id},
           success:function(msg){
        $.each( msg.messages, function( key, val ) {  
           var var_name='';
           if(key=='monthName'){
              var_name='Transaction Type || Month Name';
           }else if(key=='openigballance'){
                 var_name='Opening Balance';
           }else if(key=='add_premium'){
                 var_name='Add New CD Balance';
           }else if(key=='addition_month'){
                 var_name='Add New Member Premium Amount';
           }else if(key=='deletion_month'){
                 var_name=' Delete Member Premium Amount';
           }else if(key=='spec_case_add_premium'){
                 var_name=' Add New Balance (Special Cases)';
           }else if(key=='spec_case_del_premium'){
                 var_name='Delete New Balance (Special Cases)';
           }else if(key=='cd_balance'){
                 var_name=' Final Balance';
           }
          
           trt.push(' <tr><td>'+var_name+'</td> ');
          $.each(val, function( key1, val1 ) {  
               trt.push('<th>'+val1+'</th>');

          });

           trt.push('</tr>');

           

       });

 

 
        $('#tblItems3').html('<thead>'+trt+'</thead>');


// var mytable2 = $('#tblItems2').DataTable({destroy: true,});
// $.each( msg.get_pr, function( key, val ) {   

// operation=0;
//  if(val.operation_id==1){
//   operation="Monthly changes";
//  }else if(val.operation_id==2){
//     operation=" Add new balance";
//  }else if(val.operation_id==3){
//   operation="Add";
//  }else if(val.operation_id==4){
//   operation="Delete";
//  }

 


// mytable2.row.add([val.id,val.com_id,val.cd_balance,val.cd_update,val.remark,operation,val.created_at]);

// });


//  $('#tblItems2').DataTable({destroy: true,
//             columns: [
//             {data:"id"},
//             { data: "com_id" },
//             { data: "cd_balance"},
//             { data: "cd_update"},
//             { data: "remark"},
//             { data: "operation_id"},
//             { data: "created_at",
//             render: function ( data, type, row ) { 
             

//               // return row.created_at.toLocaleString(locale, { month: "short" });
            
//                return month_name(new Date(row.created_at))+':=>'+row.created_at;
                   
//                 }



//           },
//            ],

// });   mytable2.draw();









//           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.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: "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();



      }


  });


// $.ajax({

//      type:"GET",
//      url:"{{URL::to('cd-balance-details')}}",
//      data:{cm_id:cm_id},
//      success:function(msg){
//              console.log(msg);
//      }

// });
 



$('#cd_balance').hide();
$('#History_id').show();
});



$('#operation_id').change(function(){ $("#Chooseoperation_id").children('option:gt(0)').show();
    if(this.value==1){  
      $('#operation1').show();
      $('#operation2').hide();
       $('#operation3').hide();
    }else if(this.value==2){

    //  document.getElementById("Chooseoperation_id").options[2].disabled = false; alert("Fdf")
$("#Chooseoperation_id").children('option:gt(1)').hide();

      $('#operation2').show();
      $('#operation1').hide();
      $('#operation3').show();
    }else if(this.value==3){
      $('#operation3').show();
      $('#operation1').hide();
      $('#operation2').show();
    }else{
       $('#operation3').show();
     $('#operation1').hide();
     $('#operation2').hide();



    }


});

 

$('#calc_premium').click(function(evt){ evt.preventDefault(); 

if($('#operation_id').val()==1){
    file1=document.getElementById("excel_xls_add").files.length;
    file2=document.getElementById("excel_xls_delete").files.length;
    file3=document.getElementById("correction_file").files.length;


 if(file1!=0  && file2!=0 && file3!=0 ){  
   var formdata = new FormData($("#calc_premium_form")[0]);
   $(".loader").show();
   $.ajax({  
     type: "POST",  
     url: "{{URL::to('calc-file')}}",
     data : formdata,
     processData: false,
     contentType : false,
     success: function(msg){  $(".loader").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 : Count ('+msg.total_countadd+') :   Premium : &nbsp; &nbsp;'+msg.premium_add+'</h4>');
            $("#deletemembers").html('<h4> Delete member : Count ('+msg.total_countdelt+') :  Premium : &nbsp;&nbsp;'+msg.premium_delete+'</h4>');
            $("#final_premium").html('<h4>Final premium after addition and deletion :  '+msg.Final_premium+'</h4>');
            $("#cdbalance").html('<h4 '+set_color+'>CD balance after changes :'+msg.CD_balance+'</h4>');
            
 

           // $("#cdbalance_update").html('<a  href="'+msg.CD_balance+'" id="CD_balance__update" class="btn btn-primary">You want to update cd balance in database</a>');
            $('#cl_premium').modal('show'); 
            premium_excel_id=msg.get_ID;
            cd_balance=com_get_id=$('#com_get_id').val();
            new_balance=$('#balance_amount').val();
            cd_update=msg.CD_balance;
            remark=$('#remark').val();
            operation_id=1;
            datepicker_id_=$('#txtDate').val();
              update_fn(premium_excel_id,cd_balance,new_balance,cd_update,remark,operation_id,datepicker_id_);

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

}


 
if($('#operation_id').val()==2  || $('#operation_id').val()==3){
if( ($('#operation_id').val()==2  || $('#operation_id').val()==3)  &&  $('#Chooseoperation_id').val()!=0 && $('#balance_amount').val()!='' && $('#remark').val()!='' && $('#txtDate').val()!=''){
 var operation_id=0;
   
  if($('#operation_id').val()==2){
            operation_id=2;
  }
   if($('#operation_id').val()==3){
            operation_id=$('#Chooseoperation_id').val();
  }

 


 var balance_amount=$('#balance_amount').val();
 var remark=$('#remark').val();
 var com_get_id=$('#com_get_id').val();

$('#errors_mg').html('');
 
    if(balance_amount!=null && remark!=null && $('#txtDate').val()!=null){  

      $.ajax({
         type:"post",
         url:"{{URL::to('cd-balance')}}",
         data:{operation_id:operation_id,balance_amount:balance_amount,remark:remark,com_get_id:com_get_id,"_token": "{{ csrf_token() }}"},
         success:function(msg){ 
            if(msg.errors==0){
            $("#CurrentBalance").html('<h4> Current Balance :'+msg.CurrentBalance+'</h4>');
            $("#Newbalance").html('<h4> New balance :'+msg.Newbalance+'</h4>');
            $("#final").html('<h4>Final Balance after transaction:  '+msg.final+'</h4>');

            premium_excel_id=0;
            cd_balance=com_get_id=$('#com_get_id').val();
            new_balance=msg.Newbalance;
            cd_update=msg.final;
            datepicker_id_=$('#txtDate').val();

   
 
             update_fn(premium_excel_id,cd_balance,new_balance,cd_update,remark,operation_id,datepicker_id_);


          }else{
            $('#errors_mg').html('<h4> errors  => Current Balance :'+msg.status+'</h4>');
          }
          $('#Premium_Calculation').modal('show');

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

         }


      });
    }

}else{

 

  alert("Please Fill From Carefully");
}

}

});



 
 
 
  




 
 


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



function update_fn(premium_excel_id,cd_balance,new_balance,cd_update,remark,operation_id,datepicker_id_){
  $('.cdbalance_update').html('<form  name="CD_balance__update_form" id="CD_balance__update_form"> <input type="hidden" id="premium_excel_id" name="premium_excel_id" value="'+premium_excel_id+'"><input type="hidden" id="cd_balance" name="cd_balance" value="'+cd_balance+'"><input type="hidden" id="new_balance" name="new_balance" value="'+new_balance+'" ><input type="hidden" id="cd_update" name="cd_update" value="'+cd_update+'" ><input type="hidden"   name="remark" value="'+remark+'" ><input type="hidden" id="operation_id" name="operation_id" value="'+operation_id+'" > <a href="#"   class="btn btn-primary" id="CD_balance__update" > You want to update cd balance in database <a><input type="hidden" name="_token" value="{{ csrf_token() }}" > <input type="hidden" name="datepicker_id_" value="'+datepicker_id_+'" > </form>');
            
}


$(document).on('click','#CD_balance__update',function(evt){ evt.preventDefault();   
 // var balance_amount = $(this).attr('href');
      //comp_id=$('#cm_id').val();
 //var formdata = new FormData($("#calc_premium_form")[0]);
    // formdata.append('balance_amount', balance_amount);

  //if(balance_amount!=null && comp_id!=null){  

  

      $.ajax({
         type:"post",
         url:"{{URL::to('cd-balance-update')}}",
        // data:{balance_amount:balance_amount,comp_id:comp_id,"_token": "{{ csrf_token() }}"},
          data:$("#CD_balance__update_form").serialize(),
      
         success:function(msg){
                     
                 if(msg.errors==0){
                    alert("success fully updated..");
                    //$('#cl_premium').modal('hide');
                   // $('#CD_balance__update_form')[0].reset();

                     location.reload();
                    
                 }

         }


      });
   // }


});



</script>


<!-- <script type="text/javascript">
$(document).ready(function() {
   $('#txtDate').datepicker({
     changeMonth: true,
     changeYear: true,
     dateFormat: "mm/yy",
       
     onClose: function() {
        var iMonth = $("#ui-datepicker-div .ui-datepicker-month :selected").val();
        var iYear = $("#ui-datepicker-div .ui-datepicker-year :selected").val();
        $(this).datepicker('setDate', new Date(iYear, iMonth, 1));
     },
       
     beforeShow: function() {
       if ((selDate = $(this).val()).length > 0) 
       {
          iYear = selDate.substring(selDate.length - 4, selDate.length);
          iMonth = jQuery.inArray(selDate.substring(0, selDate.length - 5), $(this).datepicker('option', 'monthNames'));
          $(this).datepicker('option', 'defaultDate', new Date(iYear, iMonth, 1));
           $(this).datepicker('setDate', new Date(iYear, iMonth, 1));
       }
    }


  });
});
</script> -->




@endsection

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

  .ui-datepicker-calendar {
    display: none;
}
</style>
</style>