<td width="5%" align="center"><?php
echo $row['ticket_no'];
?>
</td>
<td width="5%" align="center">
<?php
echo ucfirst($row['first_name']);
?>
<?php
echo ucfirst($row['last_name']);
?>
<br/>
</td>
<td width="15%" align="center">
<?php
echo ucfirst(getfamilyDetail('father_name', $emp_id));
?>
</td>
<td align="center"><?php
echo $pre;
?>
</td>
<td align="center"><?php
echo round($total_salary_basic);
?>
</td>
<td align="center"><?php
echo round($total_hra);
?>
</td>
<td align="center"><?php
</tr>
<?
while ($row = mysql_fetch_array($result_prj)) {
$present = 0;
$absent = 0;
$h = 0;
$wo = 0;
$Pl = 0;
$Cl = 0;
$HalfCl = 0;
$Total = 0;
?>
<tr <? if ($sno % 2 == 1) { ?> bgcolor="#F8F8F8" <? } ?> class="tableTxt">
<td align="center"><?= $sno ?><br/><?= $off_day = getweeklyoffDetail('off_day', $row['id'], $start_date) ?></td>
<td align="center"><?= $row['ticket_no'] ?></td>
<td align="left" ><?= $row['first_name'] ?> <?= getfamilyDetail('father_name', $row['id']) ?><br/><?= getDatetime(getofficeDetail('date_joining', $row['id'])) ?>/<?= getdesignationMaster('designation_name', 'rec_id', getdesignationDetail('designation_id', $row['id'], $start_date)); ?></td>
<?
$start_date = "01";
$day1 = $start_date;
$month1 = $month;
$year1 = $year;
$day1 = $day1 + 1;
$end_date = date("t", strtotime($year . "-" . $month . "-01"));
$day2 = $end_date;
$month2 = $month;
$year2 = $year;
}
$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;
?>
<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">
<?=$row['first_name']?> <?=$row['last_name']?><br/>
</td>
<td width="15%" align="center"><?=getfamilyDetail('father_name',$emp_id)?><br/><?=getdesignationMaster('designation_name','rec_id',getdesignationDetail('designation_id',$emp_id,$date_month));?></td>
<td align="center">
<?=$basic_rate?>
<br/>
<?=$row_salary_deduction['salary_house_rent']?>
</td>
<td align="center"><?=$Total?><br/> <?=$total_advance?> <br/> <?=$row_salary_deduction['salary_fine']?></td>
<td align="center">
<?=round($total_salary_basic,2)?>
<br/>
<?=round($total_loan,2)?>
<br/> <?=$row_salary_deduction['salary_damage']?>
</td>
<td align="center">
<?=round($total_lta,2)?>
<br/>
</td>
<td width="5%" align="center"><?php
echo $row['ticket_no'];
?>
</td>
<td width="5%" align="center">
<?php
echo $row['first_name'];
?>
<?php
echo $row['last_name'];
?>
<br/>
</td>
<td width="15%" align="center"><?php
echo getfamilyDetail('father_name', $emp_id);
?>
<br/><?php
echo getdesignationMaster('designation_name', 'rec_id', getdesignationDetail('designation_id', $emp_id, $date_month));
?>
</td>
<td align="center">
<?php
echo $basic_rate;
?>
<br/>
<?php
echo $row_salary_deduction['salary_house_rent'];
?>
</td>
<td align="center"><?php
echo $sno;
?>
<br/>
<?php
echo $off_day = getweeklyoffDetail('off_day', $row['id'], $start_date);
?>
</td>
<td width="5%" align="center"><?php
echo $row['ticket_no'];
?>
</td>
<td width="15%" align="left"><?php
echo $row['first_name'];
?>
<?php
echo getfamilyDetail('father_name', $row['id']);
?>
<br/>
<?php
echo getDatetime(getofficeDetail('date_joining', $row['id']));
?>
/
<?php
echo getdesignationMaster('designation_name', 'rec_id', getdesignationDetail('designation_id', $row['id'], $start_date));
?>
</td>
<?php
$start_date = "01";
$day1 = $start_date;
$month1 = $month;
$year1 = $year;
