| Server IP : 108.163.255.210 / Your IP : 18.226.186.153 Web Server : Apache System : Linux blossom.urlnameserver.com 3.10.0-1160.80.1.el7.x86_64 #1 SMP Tue Nov 8 15:48:59 UTC 2022 x86_64 User : ( 1172) PHP Version : 7.2.34 Disable Function : eval,escapeshellarg,proc_close,proc_get_status,proc_nice,proc_open,symlink,system,pcntl_exec,getrusage,chown,chgp,closelog,openlog,syslog,define_syslog_variables,php_ini_loaded_file,getservbyname,getservbyport,posix_getgid,posix_getgrgid,proc_terminate,pfsockopen,apache_child_terminate,posix_mkfifo,posix_setpgid,posix_setuid,hypot,pg_host,pos,posix_access,posix_getcwd,posix_getservbyname,myshellexec,getpid,posix_getsid,posix_isatty,posix_kill,posix_mknod,posix_setgid,posix_setsid,posix_setuid,posix_times,posix_uname,ps_fill,posix_getpwuid,global,ini_restore,zip_open,zip_read,rar_open,bzopen,bzread,bzwrite,apache_get_modules,apache_get_version,phpversionphpinfo,php_ini_scanned_files,get_current_user,disk_total_space,diskfreespace,leak,imap_list,hypo,filedump,safe_mode,getmygid,apache_getenv,apache_setenv,bzread,bzwrite,bzopen,phpini,higlight_file,dos_conv,get_cwd,er_log,cmd,e_name,vdir,get_dir,only_read,ftok,ftpexec,posix_getpwnam,mysql_list_dbs,disk_free_space,session_save_path,confirm_phpdoc_compiled,zip_entry_rea,php_u,psockopen,crack_opendict,crack_getlastmessage,crack_closedict,crack_check,fpassthru,posix_get_last_error,posix_getlogin,posix_getgroups,posix_strerror,posix_getrlimit,posix_getpgrp,posix_getgrnam,pos,dl MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /home/unilinki/www/payroll/admin/ |
Upload File : |
<?php
session_start();
//check if user is login or not. If the user is not login redirect it to login.php
if(!isset($_SESSION["adminuser"]) || $_SESSION["adminuser"]=="")
{
header("Location:login.php");
exit;
}
if ($_SESSION['role_id']=="5"){
echo "<script>window.location='../index.php' </script>";
exit();
}
//require database connection file and it's supporting file.
require_once("../include/db.php");
$obj=new query_execution();
$uid=md5(uniqid(rand()));
$sysdate=date("d/m/Y");
if(isset($_POST['submitsal'])){
$empid=$_POST['empid'];
foreach ($empid as $i=>$meet_details) {
$cc="select * from `attendance` where `id`='".$_POST['empid'][$i]."' && `company`='".$_POST['co'][$i]."' && `date1`='".$da."'";
$check=mysql_query($cc);
$check1=mysql_num_rows($check);
if($check1>0)
{
$s="UPDATE `attendance` SET
`wd`='".$_POST['wd'][$i]."',`wo`='".$_POST['wo'][$i]."',`wp`='".$_POST['wp'][$i]."',`pd`='".$_POST['pd'][$i]."',`ot`='".$_POST['ot'][$i]."',
`gbpay`='".$_POST['gbpay'][$i]."',`hra`='".$_POST['hra'][$i]."',`da`='".$_POST['daa'][$i]."',`conv`='".$_POST['conv'][$i]."',`splallow`='".$_POST['splallow'][$i]."',
`washallow`='".$_POST['washallow'][$i]."',`total`='".$_POST['total'][$i]."',`gbpay1`='".$_POST['gbpay1'][$i]."',`hra1`='".$_POST['hra1'][$i]."',
`da1`='".$_POST['daa1'][$i]."',
`conv1`='".$_POST['conv1'][$i]."',`splallow1`='".$_POST['splallow1'][$i]."',`washallow1`='".$_POST['washallow1'][$i]."',
`overtime`='".$_POST['overtime'][$i]."',`total1`='".$_POST['total1'][$i]."',`gbpay2`='".$_POST['gbpay2'][$i]."',`hra2`='".$_POST['hra2'][$i]."',
`da2`='".$_POST['daa2'][$i]."',
`conv2`='".$_POST['conv2'][$i]."',`total2`='".$_POST['total2'][$i]."',`epf`='".$_POST['epf'][$i]."',`esi`='".$_POST['esi'][$i]."',
`lwf`='".$_POST['lwf'][$i]."',`canteen`='".$_POST['canteen'][$i]."',`total3`='".$_POST['total3'][$i]."',`net`='".$_POST['net'][$i]."',
`employer_pf`='".$_POST['employer_pf'][$i]."',`employer_esi`='".$_POST['employer_esi'][$i]."',`ctc`='".$_POST['ctc1'][$i]."'
WHERE id='".$_POST['empid'][$i]."' && company='".$_POST['co'][$i]."' && date1='".$da."'";
$sql=mysql_query($s);
//cl pl and adjestment insert
if(isset($_POST['clcheck'][$i])){
$insertcl="insert into leave_management (`uid`,`type`,`number`,`month`)
values('".$_POST['empid'][$i]."','cl','".$_POST['clnet'][$i]."','".$da."')";
$ic=mysql_query($insertcl);
}else{
$insertcl="insert into leave_management (`uid`,`type`,`number`,`month`) values('".$_POST['empid'][$i]."','cl','0','".$da."')";
$ic=mysql_query($insertcl);
}
if(isset($_POST['plcheck'][$i])){
$insertpl="insert into leave_management (`uid`,`type`,`number`,`month`)
values('".$_POST['empid'][$i]."','pl','".$_POST['plnet'][$i]."','".$da."')";
$ip=mysql_query($insertpl);
}else{
$insertpl="insert into leave_management (`uid`,`type`,`number`,`month`) values('".$_POST['empid'][$i]."','pl','0','".$da."')";
$ip=mysql_query($insertpl);
}
if(isset($_POST['adcheck'][$i])){
$insertad="insert into leave_management (`uid`,`type`,`number`,`month`)
values('".$_POST['empid'][$i]."','ad','".$_POST['adnet'][$i]."','".$da."')";
$iad=mysql_query($insertad);
}else{
$insertad="insert into leave_management (`uid`,`type`,`number`,`month`) values('".$_POST['empid'][$i]."','ad','0','".$da."')";
$iad=mysql_query($insertad);
}
//cl pl and adjestment insert
}else{
if($_POST['overtime'][$i]=='0'){
$sysdate1='';
}else{
$sysdate1=date("d/m/Y");
}
$s="INSERT INTO `attendance`
(`id`,`company`,`date1`,`date2`,`wd`,`wo`,`wp`,`pd`,`ot`,`gbpay`,`hra`,`da`,`conv`,`splallow`,`washallow`,`gbpay1`,`hra1`,`da1`,`conv1`,`splallow1`,
`washallow1`,`total`,`overtime`,`overtime_date`, `total1`, `gbpay2`, `hra2`,`da2`, `conv2`, `total2`, `epf`, `esi`, `lwf`, `canteen`, `total3`, `net`,
`employer_pf`,`employer_esi`,`ctc`)
VALUES
( '".$_POST['empid'][$i]."','".$_POST['co'][$i]."','".$da."','".$sysdate."','".$_POST['wd'][$i]."','".$_POST['wo'][$i]."','".$_POST['wp'][$i]."',
'".$_POST['pd'][$i]."','".$_POST['ot'][$i]."','".$_POST['gbpay'][$i]."','".$_POST['hra'][$i]."','".$_POST['daa'][$i]."','".$_POST['conv'][$i]."',
'".$_POST['splallow'][$i]."','".$_POST['washallow'][$i]."','".$_POST['gbpay1'][$i]."','".$_POST['hra1'][$i]."','".$_POST['daa1'][$i]."',
'".$_POST['conv1'][$i]."','".$_POST['splallow1'][$i]."','".$_POST['washallow1'][$i]."','".$_POST['total'][$i]."',
'".$_POST['overtime'][$i]."','".$sysdate1."','".$_POST['total1'][$i]."','".$_POST['gbpay2'][$i]."','".$_POST['hra2'][$i]."', '".$_POST['daa2'][$i]."',
'".$_POST['conv2'][$i]."','".$_POST['total2'][$i]."','".$_POST['epf'][$i]."','".$_POST['esi'][$i]."','".$_POST['lwf'][$i]."',
'".$_POST['canteen'][$i]."','".$_POST['total3'][$i]."','".$_POST['net'][$i]."','".$_POST['employer_pf'][$i]."',
'".$_POST['employer_esi'][$i]."','".$_POST['ctc1'][$i]."')";
$sql=mysql_query($s) or die(mysql_error());
//cl pl and adjestment insert
if(isset($_POST['clcheck'][$i]) ){
$insertcl="insert into leave_management (`uid`,`type`,`number`,`month`)
values('".$_POST['empid'][$i]."','cl','".$_POST['clnet'][$i]."','".$da."')";
$ic=mysql_query($insertcl);
}
/*else{
$insertcl="insert into leave_management (`uid`,`type`,`number`,`month`) values('".$_POST['empid'][$i]."','cl','0','".$da."')";
$ic=mysql_query($insertcl);
}*/
if(isset($_POST['plcheck'][$i]) ){
$insertpl="insert into leave_management (`uid`,`type`,`number`,`month`)
values('".$_POST['empid'][$i]."','pl','".$_POST['plnet'][$i]."','".$da."')";
$ip=mysql_query($insertpl);
}
/*else{
$insertpl="insert into leave_management (`uid`,`type`,`number`,`month`) values('".$_POST['empid'][$i]."','pl','0','".$da."')";
$ip=mysql_query($insertpl);
}*/
if(isset($_POST['adcheck'][$i]) ){
$insertad="insert into leave_management (`uid`,`type`,`number`,`month`)
values('".$_POST['empid'][$i]."','ad','".$_POST['adnet'][$i]."','".$da."')";
$iad=mysql_query($insertad);
}
/*else{
$insertad="insert into leave_management (`uid`,`type`,`number`,`month`) values('".$_POST['empid'][$i]."','ad','0','".$da."')";
$iad=mysql_query($insertad);
}*/
//cl pl and adjestment insert
}
}
}
$var=$_GET['var'];
if($var==NULL){
$option="<option value='' disabled selected>Select Branch</option>";
}else{
$option="<option value='$var' selected>$var</option>";
}
require_once("header.php");
?>
<link rel="stylesheet" href="//code.jquery.com/ui/1.11.4/themes/smoothness/jquery-ui.css">
<script src="//code.jquery.com/jquery-1.10.2.js"></script>
<script src="//code.jquery.com/ui/1.11.4/jquery-ui.js"></script>
<link rel="stylesheet" href="/resources/demos/style.css">
<script language="javascript" type="text/javascript">
function getval(sel){
var url = sel.value;
var url1="generate_salery.php?var=";
// get selected value
if (url) { // require a URL
window.location =url1+ url; // redirect
}
return false;
}
function x(){ }
function round(x, digits){
return parseFloat(x.toFixed(digits))
}
</script>
<script type="text/javascript" language="javascript">
// When the document is ready
$(document).ready(function (){
$('#startDate').datepicker({
format: "mm/yyyy",
viewMode: "months",
minViewMode: "months"
});
});
</script>
<style>
.modal-body .row .col-md-4 {
margin-bottom: 10px;
text-align: center;
}
</style>
<!----header ends-->
<!-- Left side column. contains the logo and sidebar -->
<?php require_once("left.php"); ?>
<!-- Content Wrapper. Contains page content -->
<div class="content-wrapper">
<!-- Content Header (Page header) -->
<section class="content-header">
<h1>Generate salary</h1>
<ol class="breadcrumb">
<li><a href="dashboard.php"><i class="fa fa-dashboard"></i> Home</a></li>
<li class="active">Generate salary</li>
</ol>
</section>
<?PHP $count1=$_GET['count1']; $count2=$_GET['count2']; ?>
<!-- Main content -->
<section class="content">
<div class="row">
<div class="col-xs-12">
<div class="box">
<div class="box-header">
<h3 class="box-title">Generate Salary </h3>
</div><!-- /.box-header -->
<div class="box-body">
<form name="" action="generate_salery.php?count1=<?php echo $count1; ?>&count2=<?php echo $count2; ?>" method="post">
<table class="table table-bordered table-hover">
<tr>
<td>
<?php if($_SESSION['branch']!=""){?>
<input type="hidden" name="company1" value="<?php echo $_SESSION['branch'] ?>" >
<?php } else {?>
<select name="company1" required class="form-control">
<?php echo $option ;
$sql=mysql_query("select * from companies");
while($f=mysql_fetch_array($sql)){
$compname=$f['name'];
?>
<option value="<?php echo $compname ?>" <?php if($compname==$_REQUEST['company1']){?> selected <?php } ?>><?php echo $compname ?></option>
<?php } ?>
</select>
<?php } ?>
</td>
<td>
<select name="arrear" required class="form-control">
<option value="1">Normal</option>
<option value="2">Arrears wise</option>
</select>
</td>
<td>
<input type="text" class="form-control" name="search_name" placeholder="Filter By Name">
</td>
<td><input type="text" name="datee" required id="startDate" placeholder="Select Month" class="form-control" value="<?php echo $_REQUEST['datee'] ?>" /></td>
<td><input type="submit" name="submit" value="Check Details" class="btn btn-info pull-left" /></td>
</tr>
</table>
</form>
<?php
if(isset($_POST['submit'])){?>
<form name="frm_del" action="generate_salery.php?count1=<?php echo $count1; ?>&count2=<?php echo $count2+$count1; ?>" method="post" >
<?php
$da=$_POST['datee'];
$da1=explode("/",$_POST['datee']);
$cret_dt=$da1[1]."-".$da1[0]."-01";
$cret_dt1="01/".$da;
$com=$_POST['company1'];
if($_POST['search_name']!="")
{
$search_query="&& name='".$_POST['search_name']."'";
}
?>
<input type="hidden" name="datee" value="<?php echo $da; ?>" >
<input type="hidden" name="company1" value="<?php echo $com; ?>" >
<input type="hidden" name="search_name" value="<?php echo $_POST['search_name']; ?>" >
<input type="hidden" name="arrear" value="<?php echo $_POST['arrear']; ?>" >
<input type ="hidden" name="submit" value="submit">
<?php
$fetch=mysql_query("select * from employee where company='$com' $search_query && status='yes' limit $count1 offset $count2");
$num_fetch1=mysql_num_rows($fetch);
if($num_fetch1==0)
{
echo "<script>window.location='generate_salery.php?count1=5&count2=0'</script>";
}
while($fe=mysql_fetch_array($fetch)){
$sno=$fe['sno'];
$name=$fe['name'];
$id=$fe['id'];
$fname=$fe['fname'];
$pf=$fe['pf'];
$esi=$fe['esi'];
$pca=$fe['pca'];
$doj=$fe['d_o_J'];
$emp_code=$fe['emp_id'];
$area=$fe['area'];
$daa=$fe['da'];
//calculating difference of months
//echo "select * from `cl-pl_data` where `pf`='".$id."'";
$myselect=mysql_query("select * from `cl-pl_data` where `pf`='".$id."'");
$ms=mysql_fetch_array($myselect);
$cl_pl_data_aug1="06/2017";
$cl_pl_data_aug="2017-06-01";
/*echo $ts1 = strtotime($cl_pl_data_aug);
echo $ts2 = strtotime($da);
$year1 = date('Y', $ts1);
$year2 = date('Y', $ts2);
if($year2==$year1){
$cl_month=date('m', $ts1);
}else{
$cl_month=0;
}
$month1 = date('m', $ts1);
$month2 = date('m', $ts2);
$diff_month_cl = ($month2 - $cl_month);
$diff_month = (($year2 - $year1) * 12) + ($month2 - $month1);*/
$date_var="01/".$da;
$date_new = str_replace('/', '-', $date_var);
$con_date=strtotime($date_new);
$startTimeStamp = strtotime($cl_pl_data_aug);
$endTimeStamp = $con_date;
$timeDiff = abs($endTimeStamp - $startTimeStamp);
$numberDays = $timeDiff/86400; // 86400 seconds in one day
// and you might want to convert to integer
$numberDays = intval($numberDays);
$tot_cl_days =round($numberDays/30);
$tot_pf_days =round($numberDays/24);
$check_taken_cl=mysql_query("select * from leave_management where uid='$id' && type='cl' && month between '$cl_pl_data_aug1' and '$da'");
while($cl_num1=mysql_fetch_array($check_taken_cl)){
$cl_num=$cl_num1['number']+$cl_num;
}
// echo $cl_num;
$check_taken_pl=mysql_query("select * from leave_management where uid='$id' && type='pl' && month between '$cl_pl_data_aug1' and '$da'");
while($pl_num1=mysql_fetch_array($check_taken_pl)){
$pl_num=$pl_num1['number']+$pl_num;
}
//calculating difference of months
$coo=$fe['company'];
$b_salary=$fe['b_salary'];
$ne="select * from `attendance` where id='$id' && company='$com' && date1='$da'";
$next=mysql_query($ne);
$totrecord=mysql_num_rows($next);
$num_of_days=cal_days_in_month($cret_dt1,$month2,$year2);
if($totrecord==0){
$wd5=$num_of_days;
$wo5=0;
$wp5=0;
$pd5=0;
$ot5=0;
$gbpay5=0;
$hra5=0;
$conv5=0;
$splallow5=0;
$washallow5=0;
$total5=0;
$gbpay15=0;
$hra15=0;
$conv15=0;
$splallow15=0;
$washallow15=0;
$overtime5=0;
$total15=0;
$gbpay25=0;
$hra25=0;
$conv25=0;
$total25=0;
$epf5=0;
$esi5=0;
$lwf5=0;
$canteen5=0;
$total35=0;
$net5=0;
$pd5=0;
$employer_pf=0;
$employer_esi=0;
$ctc=0;
$daa15=0;
}else{
$n=mysql_fetch_array($next);
$id5=$n['id'];
$date5=$n['date1'];
$wd5=$n['wd'];
$wo5=$n['wo'];
$wp5=$n['wp'];
$pd5=$n['pd'];
$ot5=$n['ot'];
$gbpay5=$n['gbpay'];
$hra5=$n['hra'];
$conv5=$n['conv'];
$splallow5=$n['splallow'];
$washallow5=$n['washallow'];
$total5=$n['total'];
$gbpay15=$n['gbpay1'];
$hra15=$n['hra1'];
$conv15=$n['conv1'];
$splallow15=$n['splallow1'];
$washallow15=$n['washallow1'];
$overtime5=$n['overtime'];
$total15=$n['total1'];
$gbpay25=$n['gbpay2'];
$hra25=$n['hra2'];
$conv25=$n['conv2'];
$total25=$n['total2'];
$epf5=$n['epf'];
$esi5=$n['esi'];
$lwf5=$n['lwf'];
$canteen5=$n['canteen'];
$total35=$n['total3'];
$net5=$n['net'];
$pd5=$n['pd'];
$employer_pf=$n['employer_pf'];
$employer_esi=$n['employer_esi'];
$ctc=$n['ctc'];
$daa15=$n['da'];
}
$past=mysql_query("select * from companies where name='$com'");
$p=mysql_fetch_array($past);
$over=$p['over_time'];
$checking_adjst=mysql_query("select * from leave_management where uid='$id5' && month='$da'");
$ca=mysql_fetch_array($checking_adjst);
$tca=$ca['number']+$tca;
if($tca>0){
$class="block";
}else{
$class="none";
}
/*$tcl=mysql_query("select * from leave_management where uid='$id5' && month='$da' && type='cl'");
while($tcl1=mysql_fetch_array($tcl)) { $tcl2=$tcl1['number']+$tcl2;}
$tpl=mysql_query("select * from leave_management where uid='$id5' && month='$da' && type='pl'");
while($tpl1=mysql_fetch_array($tpl)) { $tpl2=$tpl1['number']+$tpl2;}
$tad=mysql_query("select * from leave_management where uid='$id5' && month='$da' && type='ad'");
while($tad1=mysql_fetch_array($tad)) { $tad2=$tcl1['number']+$tad2;}*/
?>
<table id="example1" class="table table-bordered table-hover">
<thead>
<tr>
<th>Employee Particulars </th>
<th colspan="2"><--Days--></th>
<th>Earnings</th>
<th>Rate of Wages</th>
<th>Amount Payable</th>
<?php if($_POST['arrear']=="2"){?> <th >Arrears</th> <?php } ?>
<th>Deductions</th>
<th>Amount</th>
<th>Net Pay</th>
</tr>
</thead>
<tbody>
<tr>
<td>
<label>Sno : <?php echo $sno ?></label>
<label>Emp.Cd. : <?php echo $emp_code; ?></label><br/>
<label>Name : <?php echo $name ?></label><br/>
<label>F/H : <?php echo $fname ?></label><br/>
<label>Pf No. : <?php echo $pf ?></label><br/>
<label>Esi : <?php echo $esi ?></label><br/>
<label>Area : <?php echo $area; ?></label><br/>
<label>DOJ : <?php echo $doj ?></label><br/>
<label style="background-color:green;color:white; text-align:center;display:<?php echo $class ?>;" id="label<?php echo $sno; ?>">
Adjestment Applied: CL(<span id="cl1<?php echo $sno ?>"><?php echo $tcl2 ?></span>),PL(<span id="pl1<?php echo $sno ?>">
<?php echo $tpl2?></span>),AD(<span id="ad1<?php echo $sno ?>"><?php echo $tad2?></span>)</label><br/>
</td>
<td>
<label class="col-sm-2 control-label labelht">WD</label><br/>
<label class="col-sm-2 control-label labelht">WO</label><br/><br><br><br>
<label class="col-sm-2 control-label labelht">PD</label><br/>
<label class="col-sm-2 control-label labelht">WP</label><br/>
<label class="col-sm-2 control-label labelht" style='display:none;'>OT</label><br/>
</td>
<td>
<input type="hidden" name="empid[]" value="<?php echo $id ?>" />
<input type="hidden" name="co[]" value="<?php echo $com ?>" />
<input type="hidden" name="da" value="<?php echo $da ?>" />
<label><input type="text" name="wd[]" id="wd<?php echo $sno ?>" value="<? $date_val=(explode("/",$_REQUEST['datee'])) ;echo date("t",mktime(0,0,0,$date_val[0],1,$date_val[1]));?>" class="form-control" /></label><br/>
<label><input type="text" name="wo[]" id="wof<?php echo $sno ?>" value="<?php echo $wo5 ?>" class="form-control" onkeyup="checkval<?php echo $sno ?>();document.getElementById('wp<?php echo $sno ?>').value=document.getElementById('wd<?php echo $sno ?>').value-document.getElementById('wof<?php echo $sno ?>').value;pdays<?php echo $sno ?>();grsal<?php echo $sno ?>();grhra<?php echo $sno ?>();totalbasic<?php echo $sno ?>();checkleave<?php echo $sno ?>();total_salary<?php echo $sno ?>();epf_emppf<?php echo $sno ?>();esi_empesi<?php echo $sno ?>();total_deduction<?php echo $sno ?>();total_netsal<?php echo $sno ?>(); " />
<!---popup for leave adjustment ----->
<?php if($tca==0){?>
<a data-toggle="modal" data-target="#myModal<?php echo $sno ?>" style="cursor:pointer;">Adjust Leave</a><?php } ?>
<!-- Modal -->
<div class="modal fade" id="myModal<?php echo $sno ?>" tabindex="-1" role="dialog" aria-labelledby="myModalLabel">
<div class="modal-dialog" role="document">
<div class="modal-content">
<div class="modal-header">
<h4 class="modal-title" id="myModalLabel">Leave Adjustment for <?php echo $name ?></h4>
</div>
<div class="modal-body">
<div class="row">
<div class="col-md-4">
<label for="exampleInputName2">Total CL (<?php echo (($tot_cl_days+$ms['cl'])-$cl_num); ?>)</label>
</div>
<div class="col-md-4">
<input type="text" class="form-control" name="clnet[]" value="0" disabled id="myText<?php echo $sno ?>">
</div>
<div class="col-md-4">
<input type="checkbox" name="clcheck[]" onchange="valueChanged<?php echo $sno ?>()" id="clcheck<?php echo $sno ?>" value="option1" >
</div>
</div>
<div class="row">
<div class="col-md-4">
<label for="exampleInputName2">Total PL (<?php echo ($tot_pf_days-$pl_num+$ms['pl']); ?>)</label>
</div>
<div class="col-md-4">
<input type="text" name="plnet[]" class="form-control" value="0" disabled id="myText12<?php echo $sno ?>">
</div>
<div class="col-md-4">
<input type="checkbox" name="plcheck[]" onchange="valueChanged<?php echo $sno ?>()" id="plcheck<?php echo $sno ?>" value="option1">
</div>
</div>
<div class="row">
<div class="col-md-4">
<label for="exampleInputName2">ADJUST</label>
</div>
<div class="col-md-4">
<input type="text" name="adnet[]" class="form-control" value="0" disabled id="myText23<?php echo $sno ?>">
</div>
<div class="col-md-4">
<input type="checkbox" name="adcheck[]" onchange="valueChanged<?php echo $sno ?>()" id="adcheck<?php echo $sno ?>" value="option1" >
</div>
</div>
</div>
<div class="modal-footer">
<button type="button" id="skip<?php echo $sno ?>" class="btn btn-primary" data-dismiss="modal" aria-label="Skip" onclick="remove_leave<?php echo $sno ?>();">Skip</button>
<button type="button" id="button<?php echo $sno ?>" onclick="paid_days<?php echo $sno ?>();grs<?php echo $sno ?>();total_salary<?php echo $sno ?>();epf_emppf<?php echo $sno ?>();esi_empesi<?php echo $sno ?>();total_deduction<?php echo $sno ?>();total_netsal<?php echo $sno ?>();myFunction<?php echo $sno ?>(); " class="btn btn-primary" data-dismiss="modal" style="display:none;">Apply</button>
</div>
</div>
</div>
</div>
<script language="javascript" >
function myFunction<?php echo $sno ?>() {
if(($('#clcheck<?php echo $sno ?>').is(":checked")) && ($('#plcheck<?php echo $sno ?>').is(":checked")) && ($('#adcheck<?php echo $sno ?>').is(":checked"))) {
document.getElementById("cl1<?php echo $sno ?>").innerHTML=document.getElementById("myText<?php echo $sno ?>").value;
document.getElementById("pl1<?php echo $sno ?>").innerHTML=document.getElementById("myText12<?php echo $sno ?>").value;
document.getElementById("ad1<?php echo $sno ?>").innerHTML=document.getElementById("myText23<?php echo $sno ?>").value;
}else if(($('#clcheck<?php echo $sno ?>').is(":checked")) && ($('#plcheck<?php echo $sno ?>').is(":checked")) ) {
document.getElementById("cl1<?php echo $sno ?>").innerHTML=document.getElementById("myText<?php echo $sno ?>").value;
document.getElementById("pl1<?php echo $sno ?>").innerHTML=document.getElementById("myText12<?php echo $sno ?>").value;
document.getElementById("ad1<?php echo $sno ?>").innerHTML=0;
}else if(($('#clcheck<?php echo $sno ?>').is(":checked")) && ($('#adcheck<?php echo $sno ?>').is(":checked"))) {
document.getElementById("cl1<?php echo $sno ?>").innerHTML=document.getElementById("myText<?php echo $sno ?>").value;
document.getElementById("pl1<?php echo $sno ?>").innerHTML=0;
document.getElementById("ad1<?php echo $sno ?>").innerHTML=document.getElementById("myText23<?php echo $sno ?>").value;
}else if(($('#clcheck<?php echo $sno ?>').is(":checked"))) {
document.getElementById("cl1<?php echo $sno ?>").innerHTML=document.getElementById("myText<?php echo $sno ?>").value;
document.getElementById("pl1<?php echo $sno ?>").innerHTML=0;
document.getElementById("ad1<?php echo $sno ?>").innerHTML=0;
}else if(($('#plcheck<?php echo $sno ?>').is(":checked")) && ($('#adcheck<?php echo $sno ?>').is(":checked"))) {
document.getElementById("cl1<?php echo $sno ?>").innerHTML=0;
document.getElementById("pl1<?php echo $sno ?>").innerHTML=document.getElementById("myText12<?php echo $sno ?>").value;
document.getElementById("ad1<?php echo $sno ?>").innerHTML=document.getElementById("myText23<?php echo $sno ?>").value;
}else if(($('#plcheck<?php echo $sno ?>').is(":checked")) ) {
document.getElementById("cl1<?php echo $sno ?>").innerHTML=0;
document.getElementById("pl1<?php echo $sno ?>").innerHTML=document.getElementById("myText12<?php echo $sno ?>").value;
document.getElementById("ad1<?php echo $sno ?>").innerHTML=0;
}else if(($('#adcheck<?php echo $sno ?>').is(":checked"))) {
document.getElementById("cl1<?php echo $sno ?>").innerHTML=0;
document.getElementById("pl1<?php echo $sno ?>").innerHTML=0;
document.getElementById("ad1<?php echo $sno ?>").innerHTML=document.getElementById("myText23<?php echo $sno ?>").value;
}
document.getElementById("label<?php echo $sno ?>").style.display = "block";
}
function checkleave<?php echo $sno ?>(){
var lv=document.getElementById("wof<?php echo $sno ?>").value;
if(lv!='' & lv!='0')
{
var cl_total=<?php echo ($diff_month_cl-$cl_num) ?>;
var cl= Math.abs(cl_total-lv);
var pl_total=<?php echo ($diff_month-$pl_num) ?>;
var ad= Math.abs(pl_total-cl);
if(lv<=cl_total){
var cl_net=lv;
var cl=0;
var ad=0;
var pl=0;
}else if(lv>cl_total){
var cl_net=cl_total;
varpl_cal=(lv-cl_total);
if(varpl_cal>pl_total){
var cl=pl_total;
var ad_cal=(varpl_cal-pl_total);
var ad=ad_cal;
}else{
var ad=0;
var cl=varpl_cal;
}
}
else if(pl_total<= cl)
{
var cl_net=cl_total;
var cl=pl_total;
var ad=ad;
}
else{
var cl_net=0;
var cl=0;
var ad=0;
}
document.getElementById("myText<?php echo $sno ?>").value=cl_net;
document.getElementById("myText12<?php echo $sno ?>").value=cl;
document.getElementById("myText23<?php echo $sno ?>").value=ad;
}
}
function remove_leave<?php echo $sno ?>()
{
document.getElementById("label<?php echo $sno ?>").style.display = "none";
}
function valueChanged<?php echo $sno?>()
{
if($('#clcheck<?php echo $sno ?>').is(":checked")){
$("#button<?php echo $sno ?>").show();
document.getElementById("myText<?php echo $sno ?>").disabled=false;
}else{
document.getElementById("myText<?php echo $sno ?>").disabled=true;
}
if ($('#plcheck<?php echo $sno ?>').is(":checked")) {
$("#button<?php echo $sno ?>").show();
document.getElementById("myText12<?php echo $sno ?>").disabled=false;
}else{
document.getElementById("myText12<?php echo $sno ?>").disabled=true;
}
if ($('#adcheck<?php echo $sno ?>').is(":checked")){
$("#button<?php echo $sno ?>").show();
document.getElementById("myText23<?php echo $sno ?>").disabled=false;
}else{
document.getElementById("myText23<?php echo $sno ?>").disabled=true;
}
}
</script>
<!---popup for leave adjustment ----->
</label><br/>
<label><input type="text" name="pd[]" readonly id="pd<?php echo $sno ?>" value="<?php echo $pd5 ?>" class="form-control"/></label><br/>
<label><input type="text" name="wp[]" readonly id="wp<?php echo $sno ?>" value="<?php echo $wp5 ?>" class="form-control"/></label><br/>
<label style="display:none;"><input type="text" name="ot[]" id="ot<?php echo $sno ?>" value="<?php echo $ot5; ?>" class="form-control" onkeyup="b<?php echo $sno ?>(); total_salary<?php echo $sno ?>();esi_empesi<?php echo $sno ?>();total_deduction<?php echo $sno ?>();total_netsal<?php echo $sno ?>();" /></label><br/>
</td>
<td>
<label class="labelht">Basic Pay</label><br/>
<label class="labelht">HRA</label><br/>
<label class="labelht">Conveyance</label><br/>
<label class="labelht">Spl Allow</label><br/>
<label class="labelht">Wash Allow</label><br/>
<label class="labelht">DA</label><br/>
<label class="labelht" style="display:none;">Over Time</label><br/>
</td>
<td align="center" valign="middle">
<label><input type="text" name="gbpay[]" readonly id="gbpay<?php echo $sno ?>" value="<?php echo $b_salary ?>" class="form-control" /></label><br/>
<label><input type="text" name="hra[]" id="hra<?php echo $sno ?>" value="<?php echo $fe['hra']; ?>" class="form-control" readonly onkeyup="document.getElementById('hra1<?php echo $sno ?>').value=this.value;totalbasic<?php echo $sno ?>();total_salary<?php echo $sno ?>();esi_empesi<?php echo $sno ?>();total_deduction<?php echo $sno ?>();total_netsal<?php echo $sno ?>();ctc<?php echo $sno ?>();"/></label><br/>
<label><input type="text" name="conv[]" id="conv<?php echo $sno ?>" value="<?php echo $fe['conv']; ?>" class="form-control" readonly onkeyup="document.getElementById('conv1<?php echo $sno ?>').value=this.value;totalbasic<?php echo $sno ?>();total_salary<?php echo $sno ?>();esi_empesi<?php echo $sno ?>();total_deduction<?php echo $sno ?>();total_netsal<?php echo $sno ?>();ctc<?php echo $sno ?>();"/></label><br/>
<label><input type="text" name="splallow[]" id="splallow<?php echo $sno ?>" value="<?php echo $fe['sallow'] ; ?>" readonly class="form-control" onkeyup="document.getElementById('splallow1<?php echo $sno ?>').value=this.value;totalbasic<?php echo $sno ?>();total_salary<?php echo $sno ?>();esi_empesi<?php echo $sno ?>();total_deduction<?php echo $sno ?>();total_netsal<?php echo $sno ?>();ctc<?php echo $sno ?>();" /></label><br/>
<label><input type="text" name="washallow[]" id="washallow<?php echo $sno ?>" value="<?php echo $fe['wash']; ?>" readonly class="form-control" onkeyup="document.getElementById('washallow1<?php echo $sno ?>').value=this.value;totalbasic<?php echo $sno ?>();total_salary<?php echo $sno ?>();esi_empesi<?php echo $sno ?>();total_deduction<?php echo $sno ?>();total_netsal<?php echo $sno ?>();ctc<?php echo $sno ?>();" /></label><br/>
<label><input type="text" name="daa[]" id="daa<?php echo $sno ?>" value="<?php echo $daa; ?>" readonly class="form-control" onkeyup="document.getElementById('daa1<?php echo $sno ?>').value=this.value;totalbasic<?php echo $sno ?>();total_salary<?php echo $sno ?>();esi_empesi<?php echo $sno ?>();total_deduction<?php echo $sno ?>();total_netsal<?php echo $sno ?>();ctc<?php echo $sno ?>();" /></label><br/>
<label>Reimbursement</label>
</td>
<td>
<label><input type="text" name="gbpay1[]" readonly id="gbpay1<?php echo $sno ?>" value="<?php echo $gbpay15 ?>" class="form-control" /></label><br/>
<label><input type="text" name="hra1[]" readonly id="hra1<?php echo $sno ?>" value="<?php echo $hra15 ?>" class="form-control" /></label><br/>
<label><input type="text" name="conv1[]" readonly id="conv1<?php echo $sno ?>" value="<?php echo $conv15?>" class="form-control" /></label><br/>
<label><input type="text" name="splallow1[]" readonly id="splallow1<?php echo $sno ?>" value="<?php echo $splallow15 ?>" class="form-control" /></label><br/>
<label><input type="text" name="washallow1[]" readonly id="washallow1<?php echo $sno ?>" value="<?php echo $washallow15 ?>" class="form-control" /></label><br/>
<label><input type="text" name="daa1[]" readonly id="daa1<?php echo $sno ?>" value="<?php echo $daa15 ?>" class="form-control" /></label><br/>
<label><input type="text" name="overtime[]" id="overtime<?php echo $sno ?>" value="<?php echo $overtime5; ?>" class="form-control" onkeyup="total_salary<?php echo $sno ?>();total_netsal<?php echo $sno ?>()" /></label><br/>
<script language="javascript" type="text/javascript">
/*function b<?php echo $sno ?>()
{
var ot1=document.getElementById('ot<?php echo $sno ?>').value;
var x=<?php echo $over ?>;
var overtime1=parseFloat(ot1)*parseFloat(x);
document.getElementById('overtime<?php echo $sno ?>').value=parseFloat(overtime1);
}*/
function grsal<?php echo $sno ?>(){
var gr1=document.getElementById('gbpay<?php echo $sno ?>').value;
var da1=document.getElementById('daa<?php echo $sno ?>').value;
var wp1=document.getElementById('wp<?php echo $sno ?>').value;
var wd1=document.getElementById('wd<?php echo $sno ?>').value;
var grbasicsalary=((parseFloat(gr1)/parseFloat(wd1))*(parseFloat(wp1)));
document.getElementById('gbpay1<?php echo $sno ?>').value=round(grbasicsalary);
var totda=((parseFloat(da1)/parseFloat(wd1))*(parseFloat(wp1)));
var pfvalue=grbasicsalary+totda;
<?php if($_POST['arrear']=="2"){ ?>
var gbpay_arr2=document.getElementById("gbpay2<?php echo $sno ?>").value;
var daa_arr2=document.getElementById("daa2<?php echo $sno ?>").value;
if((gbpay_arr2==0) || (daa_arr2==0)){
gbpay_arr2=0;
daa_arr2=0;
}else{
gbpay_arr2=gbpay_arr2;
daa_arr2=daa_arr2;
}
<?php }else{ ?>
var gbpay_arr2=0;
var daa_arr2=0;
<?php }?>
//var gbpay3=parseFloat(document.getElementById("gbpay1<?php echo $sno ?>").value);
// alert(totda);
if(pfvalue>25000){
var pf=0;
}else{
var totalsal=(parseFloat(grbasicsalary)+parseFloat(totda)+parseFloat(gbpay_arr2)+parseFloat(daa_arr2));
var pf=parseFloat((12*(totalsal))/100);}
document.getElementById('epf<?php echo $sno ?>').value=Math.round(pf);
//alert(document.getElementById('epf<?php echo $sno ?>').value);
//var employer_pf=parseFloat((13.61*grbasicsalary)/100);
//document.getElementById('employer_pf<?php echo $sno ?>').value=employer_pf;
}
function grhra<?php echo $sno ?>(){
var wp1=document.getElementById('wp<?php echo $sno ?>').value;
var wd1=document.getElementById('wd<?php echo $sno ?>').value;
var hr1=document.getElementById('hra<?php echo $sno ?>').value;
var con1=document.getElementById('conv<?php echo $sno ?>').value;
var spl1=document.getElementById('splallow<?php echo $sno ?>').value;
var wshal1=document.getElementById('washallow<?php echo $sno ?>').value;
var daa1=document.getElementById('daa<?php echo $sno ?>').value;
var grosshra=((parseFloat(hr1)/parseFloat(wd1))*(parseFloat(wp1)));
document.getElementById('hra1<?php echo $sno ?>').value=round(grosshra);
var grossConv=((parseFloat(con1)/parseFloat(wd1))*(parseFloat(wp1)));
document.getElementById('conv1<?php echo $sno ?>').value=round(grossConv);
var grosssplallow=((parseFloat(spl1)/parseFloat(wd1))*(parseFloat(wp1)));
document.getElementById('splallow1<?php echo $sno ?>').value=round(grosssplallow);
var grosswashallow=((parseFloat(wshal1)/parseFloat(wd1))*(parseFloat(wp1)));
document.getElementById('washallow1<?php echo $sno ?>').value=round(grosswashallow);
var grossda=((parseFloat(daa1)/parseFloat(wd1))*(parseFloat(wp1)));
document.getElementById('daa1<?php echo $sno ?>').value=round(grossda);
}
function grs<?php echo $sno ?>(){
if($('#clcheck<?php echo $sno ?>').is(":checked"))
var g=document.getElementById("myText<?php echo $sno ?>").value;
else var g=0;
if ($('#plcheck<?php echo $sno ?>').is(":checked"))
var u=document.getElementById("myText12<?php echo $sno ?>").value;
else var u=0;
if ($('#adcheck<?php echo $sno ?>').is(":checked"))
var n=document.getElementById("myText23<?php echo $sno ?>").value;
else var n=0;
var gunj=parseFloat(g)+parseFloat(u)+parseFloat(n);
var gr1=document.getElementById('gbpay<?php echo $sno ?>').value;
var daa1=document.getElementById('daa<?php echo $sno ?>').value;
var wp1=document.getElementById('wp<?php echo $sno ?>').value;
var wd1=document.getElementById('wd<?php echo $sno ?>').value;
var hr1=document.getElementById('hra<?php echo $sno ?>').value;
var con1=document.getElementById('conv<?php echo $sno ?>').value;
var spl1=document.getElementById('splallow<?php echo $sno ?>').value;
var wshal1=document.getElementById('washallow<?php echo $sno ?>').value;
var grbasicsalary=((parseFloat(gr1)/parseFloat(wd1))*(parseFloat(wp1)+(parseFloat(gunj))));
document.getElementById('gbpay1<?php echo $sno ?>').value=round(grbasicsalary);
var grosshra=((parseFloat(hr1)/parseFloat(wd1))*(parseFloat(wp1)+(parseFloat(gunj))));
document.getElementById('hra1<?php echo $sno ?>').value=round(grosshra);
var grossConv=((parseFloat(con1)/parseFloat(wd1))*(parseFloat(wp1)+(parseFloat(gunj))));
document.getElementById('conv1<?php echo $sno ?>').value=round(grossConv);
var grosssplallow=((parseFloat(spl1)/parseFloat(wd1))*(parseFloat(wp1)+(parseFloat(gunj))));
document.getElementById('splallow1<?php echo $sno ?>').value=round(grosssplallow);
var grosswashallow=((parseFloat(wshal1)/parseFloat(wd1))*(parseFloat(wp1)+(parseFloat(gunj))));
document.getElementById('washallow1<?php echo $sno ?>').value=round(grosswashallow);
var grossda=((parseFloat(daa1)/parseFloat(wd1))*(parseFloat(wp1)+(parseFloat(gunj))));
document.getElementById('daa1<?php echo $sno ?>').value=round(grossda);
var pfvalue=grbasicsalary+grossda;
<?php if($_POST['arrear']=="2"){ ?>
var gbpay_arr2=document.getElementById("gbpay2<?php echo $sno ?>").value;
var daa_arr2=document.getElementById("daa2<?php echo $sno ?>").value;
if((gbpay_arr2==0) || (daa_arr2==0)){
gbpay_arr2=0;
daa_arr2=0;
}else{
gbpay_arr2=gbpay_arr2;
daa_arr2=daa_arr2;
}
<?php }else{ ?>
var gbpay_arr2=0;
var daa_arr2=0;
<?php }?>
//var gbpay3=parseFloat(document.getElementById("gbpay1<?php echo $sno ?>").value);
// alert(totda);
if(pfvalue>25000){
var pf=0;
}else{
var totalsal=(parseFloat(grbasicsalary)+parseFloat(grossda)+parseFloat(gbpay_arr2)+parseFloat(daa_arr2));
var pf=parseFloat((12*(totalsal))/100);}
document.getElementById('epf<?php echo $sno ?>').value=Math.round(pf);
}
function checkval<?php echo $sno ?>(){
var workday1=parseFloat(document.getElementById('wd<?php echo $sno ?>').value);
var workoff1=parseFloat(document.getElementById('wof<?php echo $sno ?>').value);
if(workoff1<0 ) {
alert('working off Should not be negative.');
document.getElementById('wof<?php echo $sno ?>').value='0';
document.getElementById('wof<?php echo $sno ?>').focus();
document.getElementById('pd<?php echo $sno ?>').value='0';
document.getElementById('wp<?php echo $sno ?>').value='0';
document.getElementById('gbpay1<?php echo $sno ?>').value='0';
document.getElementById('hra1<?php echo $sno ?>').value='0';
document.getElementById('conv1<?php echo $sno ?>').value='0';
document.getElementById('splallow1<?php echo $sno ?>').value='0';
document.getElementById('washallow1<?php echo $sno ?>').value='0';
document.getElementById('epf<?php echo $sno ?>').value='0';
document.getElementById('esi<?php echo $sno ?>').value='0';
document.getElementById('total<?php echo $sno ?>').value='0';
document.getElementById('total1<?php echo $sno ?>').value='0';
document.getElementById('total3<?php echo $sno ?>').value='0';
document.getElementById('net<?php echo $sno ?>').value='0';
document.getElementById('da<?php echo $sno ?>').value='0';
return false;
}else if(workoff1>workday1){
alert('working off is greater then working days');
document.getElementById('wof<?php echo $sno ?>').value='0';
document.getElementById('wof<?php echo $sno ?>').focus();
document.getElementById('pd<?php echo $sno ?>').value='0';
document.getElementById('wp<?php echo $sno ?>').value='0';
document.getElementById('gbpay1<?php echo $sno ?>').value='0';
document.getElementById('hra1<?php echo $sno ?>').value='0';
document.getElementById('conv1<?php echo $sno ?>').value='0';
document.getElementById('splallow1<?php echo $sno ?>').value='0';
document.getElementById('washallow1<?php echo $sno ?>').value='0';
document.getElementById('epf<?php echo $sno ?>').value='0';
document.getElementById('esi<?php echo $sno ?>').value='0';
document.getElementById('total<?php echo $sno ?>').value='0';
document.getElementById('total1<?php echo $sno ?>').value='0';
document.getElementById('total3<?php echo $sno ?>').value='0';
document.getElementById('net<?php echo $sno ?>').value='0';
document.getElementById('da<?php echo $sno ?>').value='0';
return false;
}
}
</script>
</td>
<?php if($_POST['arrear']=="2"){?><td valign="top">
<label><input type="text" name="gbpay2[]" id="gbpay2<?php echo $sno ?>" value="0" class="form-control" onkeyup="d<?php echo $sno ?>();epf_emppf_arr<?php echo $sno ?>();esi_empesi_arr<?php echo $sno ?>();total_deduction<?php echo $sno ?>();total_netsal<?php echo $sno ?>();"/></label><br/>
<label><input type="text" name="hra2[]" id="hra2<?php echo $sno ?>" value="0" class="form-control" onkeyup="d<?php echo $sno ?>();esi_empesi_arr<?php echo $sno ?>();total_deduction<?php echo $sno ?>();total_netsal<?php echo $sno ?>();"/></label><br/>
<label><input type="text" name="conv2[]" id="conv2<?php echo $sno ?>" value="0" class="form-control" onkeyup="d<?php echo $sno ?>();esi_empesi_arr<?php echo $sno ?>();total_deduction<?php echo $sno ?>();total_netsal<?php echo $sno ?>();"/></label><br/>
<label><input type="text" name="splallow2[]" id="splallow2<?php echo $sno ?>" value="0" class="form-control" onkeyup="d<?php echo $sno ?>();esi_empesi_arr<?php echo $sno ?>();total_deduction<?php echo $sno ?>();total_netsal<?php echo $sno ?>();"/></label><br/>
<label><input type="text" name="washallow2[]" id="washallow2<?php echo $sno ?>" value="0" class="form-control" onkeyup="d<?php echo $sno ?>();total_deduction<?php echo $sno ?>();total_netsal<?php echo $sno ?>();"/></label><br/>
<label><input type="text" name="daa2[]" id="daa2<?php echo $sno ?>" value="0" class="form-control" onkeyup="d<?php echo $sno ?>();epf_emppf_arr<?php echo $sno ?>();esi_empesi_arr<?php echo $sno ?>();total_deduction<?php echo $sno ?>();total_netsal<?php echo $sno ?>();"/></label><br/>
</td> <?php } ?>
<td>
<label class="labelht">EPF@12.00%</label><br/>
<label class="labelht">ESI @ 1.75%</label><br/>
<label class="labelht" style="display:none;">LWF</label><br/>
<label class="labelht">Other</label><br/>
<label class="labelht" style="display:none;">Employer PF</label><br/>
<label class="labelht" style="display:none;">Employer ESI</label><br/>
<label class="labelht" style="display:none;">CTC</label><br/>
</td>
<td>
<label><input type="text" name="epf[]" id="epf<?php echo $sno ?>" value="<?php echo $epf5 ?>" class="form-control" /></label><br/>
<label><input type="text" name="esi[]" id="esi<?php echo $sno ?>" value="<?php echo $esi5 ?>" class="form-control" /></label><br/>
<label><input type="text" name="lwf[]" id="lwf<?php echo $sno ?>" value="0" class="form-control" style="display:none;" /></label><br/>
<label><input type="text" name="canteen[]" id="canteen<?php echo $sno ?>" value="<?php echo $canteen5 ?>" class="form-control" onkeyup="total_deduction<?php echo $sno ?>();total_netsal<?php echo $sno ?>()" /></label><br/>
<label style="display:none;"><input type="text" name="employer_pf[]" id="employer_pf<?php echo $sno ?>" value="<?php echo $employer_pf ?>" class="form-control" readonly /></label><br/>
<label style="display:none;"><input type="text" name="employer_esi[]" id="employer_esi<?php echo $sno ?>" value="<?php echo $employer_esi ?>" class="form-control" readonly /></label><br/>
<label style="display:none;"><input type="text" name="ctc1[]" id="ctc1<?php echo $sno ?>" value="<?php echo $ctc ?>" class="form-control" readonly /></label><br/>
</td>
<td valign="top"> </td>
</tr>
<script type="text/javascript" language="javascript">
function totalbasic<?php echo $sno ?>()
{
var gbpay=parseFloat(document.getElementById("gbpay<?php echo $sno ?>").value);
var conv=parseFloat(document.getElementById("conv<?php echo $sno ?>").value);
var hra=parseFloat(document.getElementById("hra<?php echo $sno ?>").value);
var splallow=parseFloat(document.getElementById("splallow<?php echo $sno ?>").value);
var washallow=parseFloat(document.getElementById("washallow<?php echo $sno ?>").value);
var daa=parseFloat(document.getElementById("daa<?php echo $sno ?>").value);
var total= hra+conv+gbpay+splallow+washallow+daa;
document.getElementById("total<?php echo $sno ?>").value=Math.round(total);
}
function total_salary<?php echo $sno ?>()
{
var gbpay1=parseFloat(document.getElementById('gbpay1<?php echo $sno ?>').value);
var conv1=parseFloat(document.getElementById('conv1<?php echo $sno ?>').value);
var hra1=parseFloat(document.getElementById('hra1<?php echo $sno ?>').value);
var splallow1=parseFloat(document.getElementById('splallow1<?php echo $sno ?>').value);
var washallow1=parseFloat(document.getElementById('washallow1<?php echo $sno ?>').value);
var daa1=parseFloat(document.getElementById('daa1<?php echo $sno ?>').value);
var overtime=parseFloat(document.getElementById('overtime<?php echo $sno ?>').value);
var total1= round(hra1+conv1+gbpay1+splallow1+washallow1+daa1+overtime,2);
//alert(conv1);
document.getElementById('total1<?php echo $sno ?>').value=Math.round(total1);
}
function d<?php echo $sno ?>()
{
var gbpay2=parseFloat(document.getElementById("gbpay2<?php echo $sno ?>").value);
var conv2=parseFloat(document.getElementById("conv2<?php echo $sno ?>").value);
var hra2=parseFloat(document.getElementById("hra2<?php echo $sno ?>").value);
var splallow2=parseFloat(document.getElementById("splallow2<?php echo $sno ?>").value);
var washallow2=parseFloat(document.getElementById("washallow2<?php echo $sno ?>").value);
var daa2=parseFloat(document.getElementById("daa2<?php echo $sno ?>").value);
var total2= round((hra2+conv2+gbpay2+splallow2+washallow2+daa2),2);
document.getElementById("total2<?php echo $sno ?>").value=Math.round(total2);
}
function epf_emppf<?php echo $sno ?>()
{
var gbpayy=parseFloat(document.getElementById("gbpay1<?php echo $sno ?>").value);
var da11=parseFloat(document.getElementById('daa1<?php echo $sno ?>').value);
var totemplpff=round(gbpayy+da11,2);
var pff=Math.ceil(parseFloat((12*gbpayy)/100));
//document.getElementById('epf<?php echo $sno ?>').value=pff;
var employer_pf1=13.61*totemplpff;
var employer_pf=Math.ceil(parseFloat((employer_pf1 )/100));
//alert(employer_pf);
document.getElementById('employer_pf<?php echo $sno ?>').value=Math.round(employer_pf);
}
function esi_empesi<?php echo $sno ?>()
{
var me1=parseFloat(document.getElementById("gbpay1<?php echo $sno ?>").value);
var me2=parseFloat(document.getElementById("hra1<?php echo $sno ?>").value);
var me3=parseFloat(document.getElementById("splallow1<?php echo $sno ?>").value);
var me4=parseFloat(document.getElementById("conv1<?php echo $sno ?>").value);
var me5=parseFloat(document.getElementById("daa1<?php echo $sno ?>").value);
<?php
if($_POST['arrear']=="2"){?>
var me6=parseFloat(document.getElementById("gbpay2<?php echo $sno ?>").value);
var me7=parseFloat(document.getElementById("conv2<?php echo $sno ?>").value);
var me8=parseFloat(document.getElementById("hra2<?php echo $sno ?>").value);
var me9=parseFloat(document.getElementById("splallow2<?php echo $sno ?>").value);
var me10=parseFloat(document.getElementById("daa2<?php echo $sno ?>").value);
<?php }else{ ?>
var me6=0;
var me7=0;
var me8=0;
var me9=0;
var me10=0;
<?php }?>
var me_total=round((me1+me2+me3+me4+me5+me6+me7+me8+me9+me10),2);
var pftot=me1+me5;
if(me1>25000)
{
var total11=0;
}else{
var total11= round(((me_total)*1.75)/100,2);
}
var employer_total11= round(((me_total)*4.75)/100,2);
document.getElementById("esi<?php echo $sno ?>").value=Math.round(total11);
document.getElementById("employer_esi<?php echo $sno ?>").value=Math.round(employer_total11);
}
function epf_emppf_arr<?php echo $sno ?>(){
var gr2_basic=document.getElementById('gbpay<?php echo $sno ?>').value;
var gr1_basic=document.getElementById('gbpay1<?php echo $sno ?>').value;
var da1_basic=document.getElementById('daa1<?php echo $sno ?>').value;
//alert(da1_basic);
var gr1_arr=document.getElementById('gbpay2<?php echo $sno ?>').value;
var da1_arr=document.getElementById('daa2<?php echo $sno ?>').value;
var wp1_arr=document.getElementById('wp<?php echo $sno ?>').value;
var wd1_arr=document.getElementById('wd<?php echo $sno ?>').value;
//alert(gr1_arr);
var grbasicsalary_arr=((parseFloat(gr1_arr)/parseFloat(wd1_arr))*(parseFloat(wp1_arr)));
//alert(grbasicsalary_arr);
var totda_arr=((parseFloat(da1_arr)/parseFloat(wd1_arr))*(parseFloat(wp1_arr)));
if((gr1_arr==0) && (da1_arr==0)){
gbpay_arr2=0;
daa_arr2=0;
}else{
gbpay_arr2=gr1_arr;
daa_arr2=da1_arr;
}
if(gr2_basic>25000){
var pf_arr=0;
}else{
var totalsal_arr=(parseFloat(grbasicsalary_arr)+parseFloat(totda_arr)+parseFloat(gr1_basic)+parseFloat(da1_basic));
//alert(totalsal_arr);
var pf_arr=parseFloat((12*(totalsal_arr))/100);}
document.getElementById('epf<?php echo $sno ?>').value=Math.round(pf_arr);
}
function esi_empesi_arr<?php echo $sno ?>()
{
var me11=parseFloat(document.getElementById("gbpay1<?php echo $sno ?>").value);
var me21=parseFloat(document.getElementById("hra1<?php echo $sno ?>").value);
var me31=parseFloat(document.getElementById("splallow1<?php echo $sno ?>").value);
var me41=parseFloat(document.getElementById("conv1<?php echo $sno ?>").value);
var me51=parseFloat(document.getElementById("daa1<?php echo $sno ?>").value);
var me61=parseFloat(document.getElementById("gbpay2<?php echo $sno ?>").value);
var me71=parseFloat(document.getElementById("conv2<?php echo $sno ?>").value);
var me81=parseFloat(document.getElementById("hra2<?php echo $sno ?>").value);
var me91=parseFloat(document.getElementById("splallow2<?php echo $sno ?>").value);
var me101=parseFloat(document.getElementById("daa2<?php echo $sno ?>").value);
var me_total1=round((me11+me21+me31+me41+me51+me61+me71+me81+me91+me101),2);
//alert(me_total1);
if(me11>25000)
{
var total111=0;
}else{
var total111= round(((me_total1)*1.75)/100,2);
}
var employer_total111= round(((me_total1)*4.75)/100,2);
document.getElementById("esi<?php echo $sno ?>").value=Math.round(total111);
document.getElementById("employer_esi<?php echo $sno ?>").value=Math.round(employer_total111);
}
function total_deduction<?php echo $sno ?>()
{
var epff=parseFloat(document.getElementById("epf<?php echo $sno ?>").value);
var esii=parseFloat(document.getElementById("esi<?php echo $sno ?>").value);
var lwff=parseFloat(document.getElementById("lwf<?php echo $sno ?>").value);
var canteenn=parseFloat(document.getElementById("canteen<?php echo $sno ?>").value);
var total15= round((epff+esii+lwff+canteenn),2);
document.getElementById("total3<?php echo $sno ?>").value=Math.round(total15);
}
function total_netsal<?php echo $sno ?>()
{
var t1=t2=t3=t4=0;
var t1=document.getElementById("total<?php echo $sno ?>").value;
var t2=document.getElementById("total1<?php echo $sno ?>").value;
var t3=document.getElementById("total2<?php echo $sno ?>").value;
var t4=document.getElementById("total3<?php echo $sno ?>").value;
var t5=(parseFloat(t2)+parseFloat(t3));
var tt=((parseFloat(t2)+parseFloat(t3))-parseFloat(t4));
var ttt= parseFloat(tt,2);
document.getElementById("net<?php echo $sno ?>").value=Math.round(ttt);
}
function paid_days<?php echo $sno ?>(){
var wp=document.getElementById("wp<?php echo $sno ?>").value;
if($('#clcheck<?php echo $sno ?>').is(":checked"))
var mt1=document.getElementById("myText<?php echo $sno ?>").value;
else var mt1=0;
if ($('#plcheck<?php echo $sno ?>').is(":checked"))
var mt2=document.getElementById("myText12<?php echo $sno ?>").value;
else var mt2=0;
if ($('#adcheck<?php echo $sno ?>').is(":checked"))
var mt3=document.getElementById("myText23<?php echo $sno ?>").value;
else var mt3=0;
var pd1=parseFloat(mt1)+parseFloat(mt2)+parseFloat(mt3);
var pd2=parseFloat(pd1)+parseFloat(wp)
document.getElementById("pd<?php echo $sno ?>").value=pd2;
}
function pdays<?php echo $sno ?>(){
document.getElementById("pd<?php echo $sno ?>").value=document.getElementById("wp<?php echo $sno ?>").value;
}
function ctc<?php echo $sno ?>()
{
var ctc1=parseFloat(document.getElementById("total<?php echo $sno ?>").value);
var ctc2=parseFloat(document.getElementById("employer_pf<?php echo $sno ?>").value);
var ctc3=parseFloat(document.getElementById("employer_esi<?php echo $sno ?>").value);
var ctc=round(ctc1+ctc2+ctc3);
document.getElementById("ctc1<?php echo $sno ?>").value=Math.round(ctc);
}
$('document').on('click', function() {
$('#gbpay1<?php echo $sno ?>').val('hi') // get the current value of the input field.
});
</script>
<tr >
<th style="border-bottom:2px solid #333; border-top:dotted;"> </th>
<th colspan="2" style="border-bottom:2px solid #333; border-top:dotted;"> </th>
<th style="border-bottom:2px solid #333; border-top:dotted;">Total</th>
<th style="border-bottom:2px solid #333; border-top:dotted;"><input type="text" name="total[]" readonly onclick="totalbasic<?php echo $sno ?>()" value="<?php echo $total5 ?>" id="total<?php echo $sno ?>" class="form-control" /></th>
<th style="border-bottom:2px solid #333; border-top:dotted;"><input type="text" name="total1[]" id="total1<?php echo $sno ?>" onkeyup="esi_empesi<?php echo $sno ?>();" value="<?php echo $total15 ?>" class="form-control" readonly /></th>
<?php if($_POST['arrear']=="2"){ ?><th style="border-bottom:2px solid #333; border-top:dotted; " ><input type="text" name="total2[]" id="total2<?php echo $sno ?>" value="0" class="form-control" readonly /></th> <?php }else{ ?> <input type="hidden" name="total2[]" id="total2<?php echo $sno ?>" value="0" class="form-control" readonly /><?php }?>
<th style="border-bottom:2px solid #333; border-top:dotted;">Total</th>
<th style="border-bottom:2px solid #333; border-top:dotted;"><input type="text" name="total3[]" id="total3<?php echo $sno ?>" onclick="total_deduction<?php echo $sno ?>()" value="<?php echo $total35?>" class="form-control" readonly /></th>
<th style="border-bottom:2px solid #333; border-top:dotted;"><input type="text" name="net[]" id="net<?php echo $sno ?>" onkeyup="total_netsal<?php echo $sno ?>()" value="<?php echo $net5 ?>" class="form-control" readonly /></th>
</tr>
</tbody>
</tfoot>
</table>
<?php $tca=0;} ?>
<input type="submit" name="submitsal" value="Submit Salary" class="btn btn-info " >
</form>
<?php } ?>
</div><!-- /.box-body -->
</div><!-- /.box -->
</div><!-- /.col -->
</div><!-- /.row -->
</section><!-- /.content -->
</div><!-- /.content-wrapper -->
<?php
require_once("footer.php");
?>