}
?>
<input type="text" name="pf_value" id="pf_value" style="width:180px; height:20px;" value="<?php
echo $pf;
?>
" disabled="disabled"/></td>
</tr>
<tr>
<td class="text_1">ESI</td>
<td>
<input type="hidden" name="esi_rate" id="esi_rate" value="<?php
echo getAccountDetail('esic_rate', $id);
?>
"/>
<input type="text" name="esi_value" id="esi_value" style="width:180px; height:20px;" value="<?php
echo $esi = round(getAccountDetail('esic_rate', $id) * $total_earning / 100, 2);
?>
" disabled="disabled"/></td>
</tr>
</table>
</td>
</tr>
<tr>
<td>
<table width="100%" cellpadding="2" cellspacing="2" align="center" border="0">
<tr>
<td width="49%" class="text_1">Convence</td>
<td width="51%"><input type="text" name="convence" id="convence" style="width:180px; height:20px;" value="<?php
echo $convence;
?>
" onblur="sum_salary()"/></td>
$total_salary_basic = $total_salary_basic + getSalaryDetail("basic", $emp_id, $date1) / $day2 / 2;
$total_lta = $total_lta + getSalaryDetail("leave_travel_allow", $emp_id, $date1) / $day2 / 2;
$total_convence = $total_convence + getSalaryDetail("convence", $emp_id, $date1) / $day2 / 2;
$total_medical = $total_medical + getSalaryDetail("medical", $emp_id, $date1) / $day2 / 2;
$total_hra = $total_hra + getSalaryDetail("hra", $emp_id, $date1) / $day2 / 2;
$side_allowance = $side_allowance + getSalaryDetail("side_allowance", $emp_id, $date1) / $day2 / 2;
$other_deductions = $other_deductions + getSalaryDetail("other_deductions", $emp_id, $date1) / $day2 / 2;
}
}
$flag = 0;
$i++;
}
$basic_rate = getSalaryDetail("basic", $emp_id, $date1);
$total_earning = $total_salary_basic + $total_lta + $total_convence + total_medical + $total_hra + $side_allowance;
$total_pf = $total_salary_basic * getAccountDetail('pf_rate', $emp_id) / 100;
$total_esi = $total_earning * getAccountDetail('esic_rate', $emp_id) / 100;
$total_advance = getadvance($emp_id, $month, $year);
$total_loan = getloanDeduction($emp_id, $month, $year);
$prof_tax = getSalaryDetail("professional_tax", $emp_id, $date1);
$tds = getSalaryDetail("tds", $emp_id, $date1);
$monthDeduction = getSalaryDeduction($emp_id, $month, $year);
$sql = "SELECT sum(salary_fine) as salary_fine,sum(salary_damage) as salary_damage,sum(salary_canteen) as salary_canteen ,sum(salary_society_welfare) as salary_society_welfare, sum(salary_electrical) as salary_electrical, sum(salarly_security) as salarly_security ,sum(salary_house_rent) as salary_house_rent FROM mpc_salary_deduction where emp_id = '" . $emp_id . "' and MONTH(salary_deduction_date)='" . $month . "' and YEAR(salary_deduction_date) ='" . $year . "'";
$result = mysql_query($sql) or die("Error in : " . $sql . "<br>" . mysql_errno() . " : " . mysql_error());
if (mysql_num_rows($result) > 0) {
$row_salary_deduction = mysql_fetch_array($result);
}
$total_esi = ceil("{$total_esi}");
$total_deductions = round($total_pf) + $total_esi + $total_advance + $other_deductions + $prof_tax + $tds + $total_loan + $monthDeduction;
$net_salary = $total_earning - $total_deductions;
$grand_days = $grand_days + $Total;
if ($Total > 0) {
$pay_count = $pay_count + $Pl + $h + $wo;
$total_pre = $pre + $total_pre;
//
$total_salary_basic = round(((getSalaryDetail("basic", $emp_id, $date1)) / $day2 ) * $pay_count);
$total_lta = round(((getSalaryDetail("leave_travel_allow", $emp_id, $date1) / $day2) * $pay_count));
$total_convence = round(((getSalaryDetail("convence", $emp_id, $date1) / $day2) * $pay_count));
$total_medical = round((getSalaryDetail("medical", $emp_id, $date1) / $day2) * $pay_count);
$total_site = round((getSalaryDetail("site_allowance", $emp_id, $date1) / $day2) * $pay_count);
$total_hra = round((getSalaryDetail("hra", $emp_id, $date1) / $day2) * $pay_count);
$total_phone = round((getSalaryDetail("phone", $emp_id, $date1) / $day2) * $pay_count);
$total_other_allowance = round((getSalaryDetail("other_allowance", $emp_id, $date1) / $day2) * $pay_count);
$side_allowance = round((getSalaryDetail("side_allowance", $emp_id, $date1) / $day2) * $pay_count);
$other_deductions = round((getSalaryDetail("other_deductions", $emp_id, $date1) / $day2) * $pay_count);
$total_earning = round($total_salary_basic) + round($total_lta) + round($total_convence) + round($total_medical) + round($total_hra) + round($side_allowance);
$total_pf = round(($total_salary_basic * getAccountDetail('pf_rate', $emp_id)) / 100);
$total_esi = round(($total_earning * getAccountDetail('esic_rate', $emp_id)) / 100);
$total_advance = getadvance($emp_id, $month, $year);
$total_loan = getloanDeduction($emp_id, $month, $year);
$prof_tax = getSalaryDetail("professional_tax", $emp_id, $date1);
$tds = getSalaryDetail("tds", $emp_id, $date1);
$monthDeduction = getSalaryDeduction($emp_id, $month, $year);
$sql = "SELECT sum(salary_fine) as salary_fine,sum(salary_damage) as salary_damage,sum(salary_canteen) as salary_canteen ,sum(salary_society_welfare) as salary_society_welfare, sum(salary_electrical) as salary_electrical, sum(salarly_security) as salarly_security ,sum(salary_house_rent) as salary_house_rent FROM mpc_salary_deduction where emp_id = '" . $emp_id . "' and MONTH(salary_deduction_date)='" . $month . "' and YEAR(salary_deduction_date) ='" . $year . "'";
$result = mysql_query($sql) or die("Error in : " . $sql . "<br>" . mysql_errno() . " : " . mysql_error());
if (mysql_num_rows($result) > 0) {
$row_salary_deduction = mysql_fetch_array($result);
}
$total_esi = ceil("$total_esi");
if ($sno % 2 == 1) {
?>
bgcolor="#F8F8F8" <?php
}
?>
class="tableTxt">
<td width="5%" align="center"><?php
echo $sno;
?>
</td>
<td width="5%" align="center"><?php
echo $row['ticket_no'];
?>
</td>
<td width="5%" align="center"><?php
echo getAccountDetail('pf_number', $row['id']);
?>
</td>
<td width="5%" align="center">
<?php
echo ucfirst($row['first_name']);
?>
<?php
echo ucfirst($row['last_name']);
?>
<br/>
</td>
<td align="center"><?php
echo $pre;
?>
</td>
<td>
DATE OF JOINING
</td>
<td>
:<?php
echo getDatetime(getofficeDetail('date_joining', $emp_id));
?>
</td>
</tr>
<tr>
<td>
DATE OF DISCHARGE
</td>
<td>
:<?php
echo getDatetime(getAccountDetail('date_releaving', $emp_id));
?>
</td>
</tr>
</table>
</td>
<td>
DESIGNATION :<?php
echo getdesignationMaster('designation_name', 'rec_id', getdesignationDetail('designation_id', $emp_id, $date_month));
?>
</td>
<td>
DEPARTMENT:</td><td><?php
echo getdeptDetail('department_name', 'rec_id', getdepartmentDetail('dept_id', $emp_id, $date_month));
?>
</td>
$total_earning=$total_salary_basic+$total_lta+$total_convence+$total_medical+$total_hra+$side_allowance;
$esic_rate=getAccountDetail('esic_rate',$emp_id);
$total_esi=($total_earning*$esic_rate)/100;
$total_esi=ceil("$total_esi");
if($esic_rate>0)
{
?>
<tr <? if ($sno%2==1) { ?> bgcolor="#F8F8F8" <? } ?> class="tableTxt">
<td width="5%" align="center"><?=$sno?></td>
<td width="5%" align="center">
-
<td>
<?=getAccountDetail('esic_number',$row['id'])?>
</td>
<td width="15%" align="left"><?=$row['first_name']?> <?=$row['last_name']?><br/></td>
<td align="center">
<?=$Total?>
</td>
<td align="center">
<?=round($total_earning)?>
</td>
<td align="center">
<?=round($total_esi)?>
</td>
<td align="center">
<?
if($Total==0)
{
$pay_count = $pay_count + $Pl + $h + $wo;
$total_pre = $pre + $total_pre;
$total_salary_basic = round(((getSalaryDetail("basic", $emp_id, $date1)) / $day2 ) * $pay_count);
$pf_rate = getAccountDetail('pf_rate', $emp_id);
$total_pf = round(($total_salary_basic * getAccountDetail('pf_rate', $emp_id)) / 100);
$total_epf_employer = ($total_salary_basic * 3.67) / 100;
$total_fpf_employer = ($total_salary_basic * 8.33) / 100;
if ($pf_rate > 0) {
?>
<tr <? if ($sno % 2 == 1) { ?> bgcolor="#F8F8F8" <? } ?> class="tableTxt">
<td width="5%" align="center"><?= $sno ?></td>
<td width="5%" align="center"><?= $row['ticket_no'] ?></td>
<td width="5%" align="center"><?= getAccountDetail('pf_number', $row['id']) ?></td>
<td width="5%" align="center">
<?= ucfirst($row['first_name']) ?> <?= ucfirst($row['last_name']) ?><br/>
</td>
<td align="center"><?= $pre ?></td>
<td align="center"><?= round($total_salary_basic) ?></td>
<td align="center"><?= round($total_pf) ?></td>
<td align="center"><?= round($total_epf_employer) ?></td>
<td align="center"><?= round($total_pf - $total_epf_employer) ?></td>
</tr>
<?
$sno++;
$grand_basic_total = $basic_total + $grand_basic_total;
$grand_pf = $total_pf + $grand_pf;
}
}
</tr>
<tr>
<td>
PF NO.
</td>
<td style="border-bottom:1px solid #333333;">
<?php
echo getAccountDetail('pf_number', $emp_id);
?>
</td>
<td colspan="2">
ESI No
</td>
<td colspan="2" style="border-bottom:1px solid #333333;">
<?php
echo getAccountDetail('esic_number', $emp_id);
?>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td>
<?php
echo "<table align=\"center\" border=\"1\" cellpadding=\"1\" cellspacing=\"1\" class=\"border\" style=\"font-size:9px\" width=\"100%\">";
echo "<tr class=\"text_1\">";
$start_date = "01";
$day1 = $start_date;
$month1 = $month;
$year1 = $year;
