$Total++;
} else if ($leave_status == "Pl") {
$Pl++;
$Total++;
} else if ($leave_status == "Cl") {
$Cl++;
$Total++;
} else if ($leave_status == "HCL") {
$Cl = $Cl + 0.5;
$present = $present + 0.5;
$Total = $Total + 0.5;
} else if ($leave_status == "HD") {
$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 ($after_date == 'A' || $before_date == "A") {
$leave_status = 'A';
}
$absent = $absent + 1;
$Total = $Total + 1;
} else if ($leave_status == "" and $today_date >= $date1) {
$leave_status = 'A';
$absent++;
$Total++;
} else if ($leave_status == "C/OFF" or $leave_status == "OD") {
$Total++;
} else if ($leave_status == "w") {
$leave_status;
$wo++;
$Total++;
//Calcuates Difference
$daysago = floor($difference / 60 / 60 / 24);
//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);
$yy = date('Y', $date);
$mm = date('m', $date);
$dd = date('d', $date);
$date1 = $yy . "-" . $mm . "-" . $dd;
if (getLeavestatusBydate($emp_id, $date1) == 'P') {
$total_salary_basic = $total_salary_basic + getSalaryDetail("basic", $emp_id, $date1) / $day2;
}
$i++;
}
$bonus = $total_salary_basic * 8.33 / 100;
?>
<tr>
<td colspan="3">
</td>
<td>
<?php
echo $month_year;
?>
</td>
<td>
}
}
else if($after_date=='W')
{
$after_date2=date('Y-m-d',mktime(0,0,0,$mm,$dd-2,$yy));
$after_date2=getLeavestatusBydate($emp_id,$after_date2);
if($after_date2=='P' or $after_date2=='OD')
{
$Total++;
$flag=1;
}
}
}
else
{
$leave_status = getLeavestatusBydate($emp_id,$date1);
if($leave_status=="P" or $leave_status=="CO/COF" or $leave_status=="OD" or $leave_status=="Cl" or $leave_status=="Pl")
{
$Total++;
$flag=1;
}
else if($leave_status=="HD")
{
$Total=$Total+.5;
$flag=2;
}
}
if($flag==1)
{
if($employee_typ=='daily_wages')
{
function validate_weekoff_after($emp_id, $mm, $dd, $yy)
{
$date_after = date('Y-m-d', mktime(0, 0, 0, $mm, $dd + 1, $yy));
$status = getHoliday($emp_id, $date_after);
if ($status == "H") {
validate_weekoff_after($emp_id, ${$mm}, $dd, $yy);
} else {
if (getLeavestatusBydate($emp_id, $date_after) == "P" or getLeavestatusBydate($emp_id, $date_after) == "OD") {
return true;
} else {
return false;
}
}
}
$result_sub = mysql_query($sql_sub) or die("Error in Query :" . $sql_sub . "<br>" . mysql_error() . ":" . mysql_errno());
if (mysql_num_rows($result_sub) > 0) {
while ($row_sub = mysql_fetch_array($result_sub)) {
$present = 0;
$absent = 0;
$l = 0;
$on_roll = 0;
$present_per = 0;
$absent_per = 0;
$l_per = 0;
$sql = "SELECT * FROM mpc_department_employee where to_date='0000-00-00' and dept_id='" . $row_sub['rec_id'] . "'";
$result = mysql_query($sql) or die("Error in sql : " . $sql . " : " . mysql_errno() . " : " . mysql_error());
if (mysql_num_rows($result) > 0) {
while ($row_dept = mysql_fetch_array($result)) {
$today_date = date('Y-m-d');
$leave_status = getLeavestatusBydate($row_dept['emp_id'], $txt_date);
if ($leave_status == "P") {
$present++;
} else {
if ($leave_status == "A") {
$absent++;
} else {
if ($leave_status == "Pl") {
$l++;
} else {
if ($leave_status == "Cl") {
$l++;
} else {
if ($leave_status == "" and $today_date >= $txt_date) {
$leave_status = 'A';
$absent++;
$Total++;
$flag = 1;
}
} else {
if ($after_date == 'W') {
$after_date2 = date('Y-m-d', mktime(0, 0, 0, $mm, $dd - 2, $yy));
$after_date2 = getLeavestatusBydate($row['id'], $after_date2);
if ($after_date2 == 'P' or $after_date2 == 'OD') {
$Total++;
$flag = 1;
}
}
}
}
} else {
$leave_status = getLeavestatusBydate($row['id'], $date1);
if ($leave_status == "P" or $leave_status == "CO/COF" or $leave_status == "OD" or $leave_status == "Cl" or $leave_status == "Pl") {
$Total++;
$flag = 1;
} else {
if ($leave_status == "HD") {
$Total = $Total + 0.5;
$flag = 2;
}
}
}
}
if ($flag == 1) {
if ($row['employee_typ'] == 'daily_wages') {
$total_salary_basic = $total_salary_basic + getSalaryDetail("basic", $emp_id, $date1);
$total_lta = $total_lta + getSalaryDetail("leave_travel_allow", $emp_id, $date1);
function getDeptAttendancestatus($dept_id,$att_status,$date)
{
$getDeptAttendancestatus = 0;
$sql = "SELECT emp_id FROM mpc_department_employee where dept_id = '$dept_id'";
//echo $sql;
$result = mysql_query ($sql) or die ("Error in : ".$sql."<br>".mysql_errno()." : ".mysql_error());
if(mysql_num_rows($result)>0)
{
while($row = mysql_fetch_array($result))
{
$status=getLeavestatusBydate($row['emp_id'],$date);
if($status==$att_status)
{
$getDeptAttendancestatus++;
}
}
}
return $getDeptAttendancestatus;
}
