EVOLUTION-NINJA
Edit File: add_salary.php
<?php $this->load->view('includes/header.php')?> <link rel="stylesheet" href="<?php echo base_url('assets/css/jquery-ui.css');?>" /> <script src="<?php echo base_url('assets/js/jquery-ui.js');?>"></script> <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"> Add Employee Salary </li> </ol> </div> </div> </div> </div> <div class="row"> <div class="col-md-12 grid-margin stretch-card"> <div class="card"> <div class="card-body"> <form id="emp_submit"> <div class="col-xs-12"> <!-- PAGE CONTENT BEGINS --> <div class="row" style="background-color:#f8f8f8;padding-top: 10px;padding-bottom: 10px;"> <div class="col-sm-6"> <span style="font-size:25px;">Add Employee Salary</span> </div> <div class="col-sm-6"> <a href="<?php echo site_url('employee-list');?>"><button type="reset" class="btn btn-primary pull-right">Back</button></a> </div> </div> <div class="row"> <div class="col-sm-12 col-xs-12 col-md-3"> <label class="col-sm-12">Employee<span style="color:red" ></span></label> <div class="col-sm-12 yes_form"> <select name="emp_id" class="form-control emp_id" required> <option value="">Select</option> <?php foreach($employee as $key => $value) { ?> <option value="<?php echo $value->emp_id; ?>"><?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" placeholder="Enter gross Earnings" name="gross_earning" 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" value="0" name="pf" readonly> </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-8 yes_form"> <input type="text" class="form-control basic" value="0" name="basic" required="required" readonly> </div> </div> </div> <!--row--> <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" value="0" name="esi" required="required" readonly> </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" value="0" name="hra" readonly> </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" value="0" name="prof_tax" readonly> </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" value="0" name="special_allowance" readonly> </div> </div> </div><!--row--> <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" value="0" name="gross_deduction" required="required" readonly> </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" value="0" name="net_pay" readonly> </div> </div> </div> <br> <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">Save</button> <button type="reset" class="btn btn-secondary cancel">Cancel</button> </div> </div> </div> </form> </div> </div> </div> </div> </div> <style type="text/css"> .content-wrapper { max-width: 1460px !important; } .row-form { width:100%; } #emp_submit label{ padding-top: 20px; } </style> <script type="text/javascript"> $('.cancel').click(function(){ window.location = '<?php echo site_url("Salary-List")?>'; }); $('#emp_submit').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('Add-Employee-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 = $('.emp_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); 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 load_back() { window.location.href = '<?php echo site_url('dashboard');?>'; } </script> <?php $this->load->view('includes/footer.php')?>