@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>
            <b style="font-size: 20px"><a href="#" id="ecard_employee"> Bulk E card Upload </a>  || </b>
              @endif 
              <b style="font-size: 20px"><a href="#" id="History_id1">History</a></b>


              <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" value="01/2026"   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_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>




      <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 id="seccess_add" ></div>
<div id="seccess_del" ></div>
</div>





<div id="ecard_employee1" style="display: none"> <!-- Ecard Upload -->
  <div class="x_content">
    <p class="text-muted font-13 m-b-30">
      <b style="font-size: 30px">Bulk E-card Upload</b> </p> <br><hr>

      <form method="post"    enctype="multipart/form-data"  id="btn_submit_ecard_from"  >{{ 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-6">



              <input type="hidden" class="form-control" id="comp_id" name="comp_id" value="{{$cd_balance->comp_id}}">


              <label id="err_comp_id" class="error_class"></label>
            </div>
          </div>
        </div>


        <div class="col-md-12">
          <div class="form-group row">
            <label for="empcode" class="col-sm-4 col-form-label">Upload&nbsp;Pdf:</label>
            <div class="col-sm-6">
             <input name="upload[]" type="file" multiple="multiple"  class="form-control"    required>


             <label id="err_comp_id" class="error_class"></label>
           </div>
         </div>
       </div>

       <center>
         <a    id="btn_submit_ecard" class="btn btn-primary">Submit1</a>  
       </center>
     </form>   

     <div id="error" class="bg-danger"> </div>
     <div id="arr_id" class="bg-danger"> </div>

   </div>
 </div>



 <div id="History_id" style="display: none"> 
 <table id="tblItems3" class="table table-bordered table-striped"></table>

<br><br><br><br>

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

 </div>








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


@endif 



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


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








<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();
    $('#ecard_employee1').hide();
  });


  $('#ecard_employee').click(function(){
    $('#ecard_employee1').show();

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

  });







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

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


    var trt=Array();
    var tr1=Array();

    var tmrt=Array();
 
    $.ajax({
     type:"GET",
     url:"{{URL::to('cd-balance-details')}}",
     data:{cm_id:cm_id},
     success:function(msg){   $('.iframeloading').hide(); $('#tblItems3').html();$('#total_member').html();
     $.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>');


 $.each( msg.total_active_m, function( key, val ) {  
    tmrt.push(' <tr><td>'+key+'</td> ');
     $.each(val, function( key1, val1 ) {  
       tmrt.push('<th>'+val1+'</th>');
     });
     tmrt.push('</tr>');
}); $('#total_member').html('<thead>'+tmrt+'</thead>');

}


 });







    $('#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]);
       $(".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 : 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){  $(".iframeloading").hide();
       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();   
    $(".iframeloading").show();
    $.ajax({
     type:"post",
     url:"{{URL::to('cd-balance-update')}}",
     data:$("#CD_balance__update_form").serialize(),

     success:function(msg){ $(".iframeloading").hide();
     if(msg.errors==0){
      alert("success fully updated..");
      location.reload();

    }

  }


});
   // }


 });



</script>



<script type="text/javascript">

  var date=new Date();
  var year=date.getFullYear();
  var month=date.getMonth();


  $(document).ready(function() {

   $('#txtDate1').datepicker( {
    changeMonth: false,
    changeYear: false,
    stepMonths: false,
    dateFormat: 'mm/yy'
  });
 });

</script>

<script type="text/javascript">


  $('#btn_submit_ecard').click(function(evt){ evt.preventDefault();   
   var formdata = new FormData($("#btn_submit_ecard_from")[0]);
   $(".iframeloading").show();
   $.ajax({  
     type: "POST",  
     url: "{{URL::to('pdf-upload-save')}}",
     data : formdata,
     processData: false,
     contentType : false,
     success: function(msg){  $(".iframeloading").hide();
     arr=Array(); $('#arr_id').empty();
     $('#error').empty();
     if(msg.status==1){
      $.each(msg.Validator,function(index,val){
       console.log(val);
       arr.push('<li>'+val+'</li>');

     });
    }else{
      if(msg.data.length>0){
       $.each(msg.data,function(index,val){
        arr.push('<li>'+val+'</li>');
      });
       $('#error').append('Not update pdf..');
     }else{
       $('#error').append('success ');
     }  
   }
   $('#arr_id').append('<ul>'+arr+'</ul>');

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