$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; }