EVOLUTION-NINJA

Edit File: edit_salary.php

<?php $this->load->view('includes/header.php')?>

<div class="content-wrapper">
    
    <div class="content-header">
      <div class="container-fluid">
      <div class="row mb-2">
        <div class="col-sm-6">
        </div>
        <div class="col-sm-6">
        <ol class="breadcrumb float-sm-right">
          <li class="breadcrumb-item"><a href="#">HR</a></li>
          <li class="breadcrumb-item"> Update Employee Salary </li>
        </ol>
        </div> 
      </div> 
      </div>
    </div>

<form id="edit_salary" class="form_submit">
				<div class="col-xs-12">
					
					<div class="row" style="background-color:#f8f8f8;padding-top: 10px;padding-bottom: 10px;">
						<div class="col-sm-12 col-md-6">
							<span style="font-size:25px;">Update Employee Salary</span>
						</div>
						<div class="col-sm-6"></div>	
					</div>
					
					<input type="hidden" class="form-control salary_id" value="<?php echo $sal->salary_id; ?>" name="salary_id" required="required">

<div class="row">
						<div class="col-sm-12 col-xs-12 col-md-3">
							<label class="col-sm-12 ">Employee</label>
							<div class="col-sm-12 yes_form">
								<select name="emp_id" class="form-control employee_id" >
									<?php foreach($employee as $key => $value) { ?>				
									<option value="<?php echo $value->emp_id; ?>" <?php if($sal->emp_id==$value->emp_id){ echo 'selected'; }else{ echo 'disabled';} ?>><?php echo $value->first_name.' '.$value->last_name; ?></option>
									<?php } ?>
								</select>
							</div>
						</div>
						<div class="col-sm-12 col-xs-12 col-md-3">
							<label class="col-sm-12">Gross Earnings</label>
							<div class="col-sm-12 yes_form"><input type="text" class="form-control g_earnings" id="g_earnings" name="gross_earning" required="required">
							</div>
						</div>

<div class="col-sm-12 col-xs-12 col-md-3">
							<label class="col-sm-12">PF</label>
							<div class="col-sm-12 yes_form">
								<input type="text" class="form-control pf" id="pf" name="pf">
							</div>
						</div>
						<div class="col-sm-12 col-xs-12 col-md-3">
							<label class="col-sm-12">Basic & DA</label>
							<div class="col-sm-12 yes_form">
								<input type="text" class="form-control basic" id="basic" name="basic" required="required">
							</div>
						</div>	
					</div> 
					
					<div class="row">
						<div class="col-sm-12 col-xs-12 col-md-3">
							<label class="col-sm-12">ESI</label>
							<div class="col-sm-12 yes_form">
								<input type="text" class="form-control esi" id="esi" name="esi" required="required">
							</div>
						</div>
						<div class="col-sm-12 col-xs-12 col-md-3">
							<label class="col-sm-12">HRA @20%</label>
							<div class="col-sm-12 yes_form">
								<input type="text" class="form-control hra" id="hra" name="hra">	
							</div>
						</div>
						<div class="col-sm-12 col-xs-12 col-md-3">
							<label class="col-sm-12">Professional Tax</label>
							<div class="col-sm-12 yes_form">
								<input type="text" class="form-control p_tax" id="p_tax" name="prof_tax">	
							</div>
						</div>
						<div class="col-sm-12 col-xs-12 col-md-3">
							<label class="col-sm-12">Travel & Other Allowance @20%</label>
							<div class="col-sm-12 yes_form">
								<input type="text" class="form-control sp_allowance" id="sp_allowance" name="special_allowance">
							</div>
						</div>	
					</div>

<div class="row">							
						<div class="col-sm-12 col-xs-12 col-md-3">
							<label class="col-sm-12">Gross Deduction</label>
							<div class="col-sm-12 yes_form">
								<input type="text" class="form-control g_deduction" id="g_deduction" name="gross_deduction" required="required">
							</div>
						</div>
						<div class="col-sm-12 col-xs-12 col-md-3">
							<label class="col-sm-12">Net Pay</label>
							<div class="col-sm-12 yes_form">
								<input type="text" class="form-control net_pay" id="net_pay" name="net_pay">
							</div>
						</div>	
					</div>

<div class="row" style="background-color:#f8f8f8;padding-top: 10px;padding-bottom: 10px;">
						<div class="col-sm-12 col-md-2">
							
						</div>
						<div class="col-sm-7"></div>
						<div class="col-sm-3">
							<button type="submit" class="btn btn-primary">Update</button>
							<button type="reset" class="btn btn-secondary">Cancel</button>
						</div>
					</div>
				</div>
			</form>

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

</div>

.content-wrapper {
    max-width: 1260px !important;
}
.row-form {
	width:100%;
}
.form_submit label{
  padding-top: 20px;
}
.form-control{
    height: 2.5rem !important;
}
#edit_salary label{
	font-size: 14px;
}
</style>

$('#edit_salary').submit(function(e){
      e.preventDefault();
      formdata = new FormData($(this)[0]);
      swal({

title: "Are you sure?",
        text: "You want to Save this?",
        type: "warning",   showCancelButton: true,
        confirmButtonColor: "#DD6B55",
        confirmButtonText: "Yes!",
        cancelButtonText: "No, cancel plz!",
        closeOnConfirm: false,
        closeOnCancel: false 
        },
      function(isConfirm){

if (isConfirm) {

$(".sweet-alert").hide();
        $(".sweet-overlay").hide();
      
            $.ajax({
                type : 'post',
                url  : "<?php echo site_url('update-salary');?>",
                data : formdata,
                contentType: false,
                processData: false,
                success:function(response) {
                  response=jQuery.parseJSON(response);
                  //console.log(response);
                  if(response.result==1)
                  {
                    toastr["success"](response.message);
                    setTimeout(function wait(){
                     window.location = '<?php echo site_url("Salary-List")?>';
                      }, 1000);
                  } 
                  else
                  {
                    toastr["error"](response.message);
                  }

}
            });
        } 
        else 
        {
          $(".sweet-alert").hide();
          $(".sweet-overlay").hide();
        }
      });

});

$('.g_earnings').focusout(function(e){
      e.preventDefault();

var emp_id = $('.employee_id option:selected').val();

$.ajax({
            type : 'post',
            url  : "<?php echo site_url('latest-payment-details');?>",
            data : {'emp_id':emp_id},
            
            success:function(response) {

response=jQuery.parseJSON(response);
              console.log(response);
              //alert(response.result);
              if(response.result==1)
              {

var pf;
                var esi;
                var prof_tax;
                var hra;
                var allowance;

var g_earn   = $(".g_earnings").val();
          var res_earn = g_earn.replace(/[_\W]+/g, "");
          g_earn = parseFloat(res_earn);

var hra_percent = response.message.hra;
                hra = parseFloat(g_earn*hra_percent/100);

deduct_hra = parseFloat(g_earn-hra);

if(deduct_hra >= 15000)
                {
                var pf_percent = response.message.pf;
                pf = parseFloat(15000*pf_percent/100);
              }
                else
                {
                  var pf_percent = response.message.pf;
                  pf = parseFloat(deduct_hra*pf_percent/100);
                }
                
                if(g_earn > response.message.esi_above)
                {
                  esi = 0;
                  esi = parseFloat(esi);
                }
                else
                {
                  var esi_percent = response.message.esi;
                  esi = parseFloat(g_earn*esi_percent/100);
                }

if(g_earn >= response.message.prof_tax_above)
                {
                  prof_tax = response.message.prof_tax;
                  prof_tax = parseFloat(prof_tax);
                }
                else
                {
                  prof_tax = 0;
                  prof_tax = parseFloat(prof_tax);
                }

var basic = parseFloat(g_earn*60/100);

allowance = parseFloat(g_earn-basic-hra);
                
          var g_deduct = parseFloat(pf+esi+prof_tax);

var net_pay = parseFloat(g_earn-g_deduct);

$('.basic').val(basic);
          $('.hra').val(hra);
          $('.sp_allowance').val(allowance);

$('.pf').val(pf);
          $('.esi').val(esi);
          $('.p_tax').val(prof_tax);

$('.g_deduction').val(g_deduct);
          $('.net_pay').val(net_pay);

} 
            else
            {
              //toastr["error"](response.message);
            }

}
      });
      
  });

/*$('.g_earnings').focusout(function(e){
	  	e.preventDefault();

var pf  = 1800;
	  	var esi = 0;
	  	var pt  = 200;
	  	var g_deduct = parseFloat(pf+esi+pt);

var g_earn   = $(".g_earnings").val();
	  	var res_earn = g_earn.replace(/[_\W]+/g, "");
	  	g_earn = parseFloat(res_earn);

var net_pay = parseFloat(g_earn-g_deduct);
	  	var hra = parseFloat(g_earn*20/100);
	  	var allowance = parseFloat(g_earn*20/100);
	  	var basic = parseFloat(g_earn-hra-allowance);

$('.basic').val(basic);
	  	$('.hra').val(hra);
	  	$('.sp_allowance').val(allowance);

$('.pf').val(pf);
	  	$('.esi').val(esi);
	  	$('.p_tax').val(pt);

$('.g_deduction').val(g_deduct);
	  	$('.net_pay').val(net_pay);
	  	
	});*/
	
	/*$('.net_pay').focusout(function(e){
	  	e.preventDefault();

var pf = 1800;
	  	var esi = 0;
	  	var pt = 200;
	  	var g_deduct = parseFloat(pf+esi+pt);

var net = $(".net_pay").val();
	  	var res_net = net.replace(/[_\W]+/g, "");
	  	net = parseFloat(res_net);

var g_earn = parseFloat(net+g_deduct);
	  	var hra = parseFloat(g_earn*20/100);
	  	var allowance = parseFloat(g_earn*20/100);
	  	var basic = parseFloat(g_earn-hra-allowance);

$('.basic').val(basic);
	  	$('.hra').val(hra);
	  	$('.sp_allowance').val(allowance);

$('.pf').val(pf);
	  	$('.esi').val(esi);
	  	$('.p_tax').val(pt);

$('.g_earnings').val(g_earn);
	  	$('.g_deduction').val(g_deduct);

});*/
	
	/*$('.basic').focusout(function(e){
	  	e.preventDefault();

earnings();

});

$('.hra').focusout(function(e){
	  	e.preventDefault();

earnings();
	  	
	});

$('.sp_allowance').focusout(function(e){
	  	e.preventDefault();

earnings();

});

$('.pf').focusout(function(e){
	  	e.preventDefault();

deduction();

});

$('.esi').focusout(function(e){
	  	e.preventDefault();

deduction();

});

$('.p_tax').focusout(function(e){
	  	e.preventDefault();

deduction();

});

function earnings()
	{
		var basic = $(".basic").val();
	  	var res_b = basic.replace(/[_\W]+/g, "");
	  	basic = parseFloat(res_b);
	  	
	  	var hra = $(".hra").val();
	  	var res_h = hra.replace(/[_\W]+/g, "");
	  	hra = parseFloat(res_h);
	  	
	  	var allowance = $(".sp_allowance").val();
	  	var res_a = allowance.replace(/[_\W]+/g, "");
	  	allowance = parseFloat(res_a);

var res = parseFloat(basic+hra+allowance);
	  	var earn = res.toString();
	  	var lastThree = earn.substring(earn.length-3);
	  	var otherNumbers = earn.substring(0,earn.length-3);
	  	if(otherNumbers != '')
	  		lastThree = ',' + lastThree;
	  	var g_earn = otherNumbers.replace(/\B(?=(\d{2})+(?!\d))/g, ",") + lastThree;
	  	$('.g_earnings').val(g_earn);

var earn = $(".g_earnings").val();
	  	var res_earn = earn.replace(/[_\W]+/g, "");
	  	earn = parseFloat(res_earn);

var deduct = $(".g_deduction").val();
	  	var res_deduct = deduct.replace(/[_\W]+/g, "");
	  	deduct = parseFloat(res_deduct);

var res = parseFloat(earn-deduct);
	  	var net_pay = res.toString();
	  	var lastThree = net_pay.substring(net_pay.length-3);
	  	var otherNumbers = net_pay.substring(0,net_pay.length-3);
	  	if(otherNumbers != '')
	  		lastThree = ',' + lastThree;
	  	var net = otherNumbers.replace(/\B(?=(\d{2})+(?!\d))/g, ",") + lastThree;
	  	$('.net_pay').val(net);
	}

function deduction()
	{
		var pf = $(".pf").val();
	  	var res_pf = pf.replace(/[_\W]+/g, "");
	  	pf = parseFloat(res_pf);
	  	
	  	var esi = $(".esi").val();
	  	var res_esi = esi.replace(/[_\W]+/g, "");
	  	esi = parseFloat(res_esi);
	  	
	  	var pt = $(".p_tax").val();
	  	var res_pt = pt.replace(/[_\W]+/g, "");
	  	pt = parseFloat(res_pt);
	  	
	  	var res = parseFloat(pf+esi+pt);
	  	var deduct = res.toString();
	  	var lastThree = deduct.substring(deduct.length-3);
	  	var otherNumbers = deduct.substring(0,deduct.length-3);
	  	if(otherNumbers != '')
	  		lastThree = ',' + lastThree;
	  	var g_deduct = otherNumbers.replace(/\B(?=(\d{2})+(?!\d))/g, ",") + lastThree;
	  	$('.g_deduction').val(g_deduct);

var earn = $(".g_earnings").val();
	  	var res_earn = earn.replace(/[_\W]+/g, "");
	  	earn = parseFloat(res_earn);

var deduct = $(".g_deduction").val();
	  	var res_deduct = deduct.replace(/[_\W]+/g, "");
	  	deduct = parseFloat(res_deduct);

changesalary_onload();

</script>

<?php $this->load->view('includes/footer.php')?>