$before_date = getLeavestatusBydate($row['id'], $date_before);
$i_before++;
} while ($before_date == 'Cl');
}
$weekday_after = date("l", mktime(0, 0, 0, $mm, $dd + 1, $yy));
if ($before_date == 'P' or $before_date == 'OD' or $after_date == 'P' or $after_date == 'OD') {
$h++;
$leave_status = 'H';
$Total++;
} else if (getweeklyoffDetail('off_day', $row['id'], $date_before) == $weekday_before) {
if (validate_weekoff_before($row['id'], $mm, $dd - 1, $yy)) {
$h++;
$leave_status = 'H';
$Total++;
}
} else if (getweeklyoffDetail('off_day', $row['id'], $date_after) == $weekday_after) {
if (validate_weekoff_after($row['id'], $mm, $dd + 1, $yy)) {
$h++;
$leave_status = 'H';
$Total++;
}
} else {
$leave_status = getLeavestatusBydate($row['id'], $date1);
if ($leave_status == "") {
$leave_status = 'A';
$absent++;
$Total++;
} else if ($leave_status == "Pl") {
$Pl++;
$Total++;
} else if ($leave_status == "Cl") {
</table>
<?
} else {
if ($holiday != "") {
?>
<table align="center" width="100%" border="0" class="border">
<tr class="blackHead" >
<td align="center">
Holiday OFF:<?= $holiday ?>
</td>
</tr>
</table>
<?
} else if ($weekly_day == getweeklyoffDetail('off_day', $id, $date)) {
?>
<table align="center" width="100%" border="0" class="border">
<tr class="blackHead" >
<td align="center">
Weekly OFF:<?= $weekly_day ?>
</td>
</tr>
</table>
<?
} else {
$query_count = "select count(*) as count from " . $mysql_adm_table_prefix . "document_master where DocumentFor = '$id'";
$result_doc = mysql_query($sql) or die("Error in : " . $sql . "<br>" . mysql_errno() . " : " . mysql_error());
//Calculates Days Old
$i = 0;
while ($i <= $daysago + 1) {
if ($i != 0) {
$date = $date + 86400;
} else {
$date = $date - 86400;
}
$today = date('Y-m-d', $date);
//echo "$today ";
$yy = date('Y', $date);
$mm = date('m', $date);
$dd = date('d', $date);
$date1 = $yy . "-" . $mm . "-" . $dd;
$weekday = date("l", mktime(0, 0, 0, $mm, $dd, $yy));
if (getweeklyoffDetail('off_day', $row['id'], $date1) == $weekday and $row['employee_typ'] != 'daily_wages') {
$date_before = date('Y-m-d', mktime(0, 0, 0, $mm, $dd - 1, $yy));
$date_after = date('Y-m-d', mktime(0, 0, 0, $mm, $dd + 1, $yy));
$before_date = getLeavestatusBydate($row['id'], $date_before);
$after_date = getLeavestatusBydate($row['id'], $date_after);
if ($before_date == 'P' or $before_date == 'OD' or $after_date == 'P' or $after_date == 'OD') {
if ($row['employee_typ'] != 'daily_wages') {
$Total++;
$flag = 1;
}
} else {
if (getHoliday('rec_id', $date_before) != "") {
if (validate_weekoff_before($row['id'], $mm, $dd - 1, $yy)) {
$Total++;
$flag = 1;
}
$i = 0;
while ($i <= $daysago) {
if ($i != 0) { $date = $date + 86400; }
$today = date('Y-m-d',$date);
//echo "$today ";
$yy = date('Y',$date);
$mm = date('m',$date);
$dd = date('d',$date);
$date1=$yy."-".$mm."-".$dd;
$weekday = date("l", mktime(0,0,0,$mm,$dd,$yy));
if(getweeklyoffDetail('off_day',$emp_id,$date1)==$weekday and $row_dept['employee_typ']!='daily_wages')
{
$date_before=date('Y-m-d',mktime(0,0,0,$mm,$dd-1,$yy));
$date_after=date('Y-m-d',mktime(0,0,0,$mm,$dd+1,$yy));
$before_date=getLeavestatusBydate($emp_id,$date_before);
$after_date=getLeavestatusBydate($emp_id,$date_after);
if($before_date=='P' or $before_date=='OD' or $after_date=='P' or $after_date=='OD')
{
if($employee_typ!='daily_wages')
{
$Total++;
$flag=1;
}
}
else if(getHoliday('rec_id',$date_before)!="")
{
}
?>
</table>
</td>
</tr>
</table>
</td>
<td style="padding:10px; background-image:url(images/background-gradient.jpg); background-position:center; background-repeat:repeat-y; width:1px;">
</td>
<td>
<?php
if (isset($emp_check[$z + 1])) {
$emp_id = $emp_check[$z + 1];
$off_day = getweeklyoffDetail('off_day', $emp_id, $date_month);
$sql_prj = "select * from mpc_employee_master where rec_id='{$emp_id}'";
$result_prj = mysql_query($sql_prj) or die("Error in Query :" . $sql_prj . "<br>" . mysql_error() . ":" . mysql_errno());
$row = mysql_fetch_array($result_prj);
?>
<table align="center" cellpadding="0" cellspacing="0" class="border" border="0" width="<?php
echo $width;
?>
" height="<?php
echo $height;
?>
">
<tr>
<td>
<table cellpadding="0" cellspacing="0" border="0" width="100%" style="font-size:12px">
<tr>
