</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_convence=0;
$total_medical=0;
$total_hra=0;
$other_deductions=0;
$side_allowance=0;
$prof_tax=0;
$tds=0;
$start_date="01";
$Total=0;
$flag=0;
$grand_days=0;
$emp_id=$row_dept['emp_id'];
$employee_typ=getofficeDetail('employee_typ',$emp_id);
$start_date =getdbDateSepretoe($_POST['txt_date_from']);
$end_date = getdbDateSepretoe($_POST['txt_date_to']);
$day1 = substr($_POST['txt_date_from'],0,2);
$month1 = substr($_POST['txt_date_from'],3,2);
$year1 = substr($_POST['txt_date_from'],6,4);
$day2 = substr($_POST['txt_date_to'],0,2);
$month2 = substr($_POST['txt_date_to'],3,2);
$year2 = substr($_POST['txt_date_to'],6,4);
//$day1 = $day1 + 1;
<td><?php
echo $month_days = date("t", strtotime($year . "-" . $i . "-01"));
?>
</td>
<td><?php
echo $no_present = getleavecountMonthly($emp_id, "P", $i, $year);
?>
</td>
<td><?php
if ($i <= date('m')) {
$total_month = 0;
for ($j = 1; $j <= $month_days; $j++) {
$date = mktime(0, 0, 0, $i, $j, $year);
$dd = date('d', $date);
$salary_ann = getSalaryDetail("basic", $emp_id, $year . '-' . $i . '-' . $dd);
if (getofficeDetail('employee_typ', $emp_id) == 'daily_wages') {
$per_day = $salary_ann / $month_days;
} else {
$per_day = $salary_ann / $month_days;
}
$total_month = $total_month + $per_day;
}
$total_month = round($total_month, 2);
echo round($no_present * $total_month / $month_days);
}
?>
</td>
<!--<td> </td>
<td> </td>-->
<td colspan="2"><?php
if ($i <= date('m')) {
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;
$day1 = $day1 + 1;
$end_date = date("t", strtotime($year . "-" . $month . "-01"));
$day2 = $end_date;
$month2 = $month;
<td>
:<?php
echo getemployeeDetail('first_name', $emp_id);
?>
<?php
echo getemployeeDetail('last_name', $emp_id);
?>
</td>
</tr>
<tr>
<td>
DATE OF JOINING
</td>
<td>
:<?php
echo getDatetime(getofficeDetail('date_joining', $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:<?php
echo getdeptDetail('department_name', 'rec_id', getdepartmentDetail('dept_id', $emp_id, $date_month));
?>
</td>
