$spladminname = strtoupper($spladminname); if ($Current_day != 'Sunday') { if ($check_ph == 0 && $check_onduty == 0) { $final_array = array_diff($get_active_user, $get_login_id); $final_array = array_values($final_array); $array_length = count($final_array); $final_user_array = array(); for ($i = 0; $i < $array_length; $i++) { $names = $final_array[$i]; $select_empname = "SELECT EMPLOYEE_NAME from VW_TS_ALL_ACTIVE_EMPLOYEE_DETAILS where ULD_LOGINID='{$names}' "; $select_emp_name = mysqli_query($con, $select_empname); if ($row = mysqli_fetch_array($select_emp_name)) { $empname = $row["EMPLOYEE_NAME"]; } $sub = str_replace("[SADMIN]", "{$spladminname}", $body); $get_uldid = get_uldid($names); $get_joindate = get_joindate($get_uldid); $message = '<body>' . '<br>' . '<h> ' . $sub . '</h>' . '<br>' . '<br>' . '<table border=1 width=490 ><thead bgcolor=#6495ed style=color:white><tr align=center height=3px ><td>EMPLOYEE NAME</td><td >REPORT DATE</td></tr></thead>'; $select_last_report = "SELECT UARD_DATE FROM USER_ADMIN_REPORT_DETAILS UARD,USER_LOGIN_DETAILS ULD WHERE UARD.ULD_ID=(SELECT ULD_ID from USER_LOGIN_DETAILS where ULD_LOGINID='{$names}') ORDER by UARD.UARD_DATE desc LIMIT 1"; $select_last_report_rs = mysqli_query($con, $select_last_report); while ($row = mysqli_fetch_array($select_last_report_rs)) { $last_date = $row["UARD_DATE"]; } $final_date_array = array(); if ($last_date != $currentdate) { for ($j = 1; $j <= 30; $j++) { $final_date = date('Y-m-d', strtotime($last_date . +$j . ' days')); if ($final_date <= $currentdate) { if ($final_date >= $get_joindate) { $day = date('l', strtotime($final_date)); if ($day != "Sunday") {
$get_project_array = get_projectentry($ure_uld_id); $error = '3,4,5,6,7,8,16,17,18,67,115,120,142'; $error_array = get_error_msg($error); $min_date = get_joindate($ure_uld_id); $login_array = get_active_emp_id(); // $select_wfh=mysqli_query($con,"select WFHA_FLAG from WORK_FROM_HOME_ACCESS where ULD_ID=$ure_uld_id"); // while($row=mysqli_fetch_array($select_wfh)) // { // $wfh_flag=$row['WFHA_FLAG']; // } $values_array = array($get_permission_array, $get_project_array, $min_date, $error_array, $login_array, $wfh_flag); echo JSON_ENCODE($values_array); } if ($_REQUEST["option"] == "admin_search_update") { $get_permission_array = get_permission(); $ure_uld_id = get_uldid(); // $get_project_array=get_project(); $error = '3,4,5,6,7,8,16,17,18,67,83,98,109,110'; $error_array = get_error_msg($error); // $min_date=get_joindate($ure_uld_id); $admin_searchmin_date = mysqli_query($con, "SELECT MIN(UARD_DATE) as UARD_DATE FROM USER_ADMIN_REPORT_DETAILS "); while ($row = mysqli_fetch_array($admin_searchmin_date)) { $admin_searchmin_date_value = $row["UARD_DATE"]; $min_date = date('d-m-Y', strtotime($admin_searchmin_date_value)); } $admin_searchmax_date = mysqli_query($con, "SELECT MAX(UARD_DATE) as UARD_DATE FROM USER_ADMIN_REPORT_DETAILS "); while ($row = mysqli_fetch_array($admin_searchmax_date)) { $admin_searchmax_date_value = $row["UARD_DATE"]; $max_date = date('d-m-Y', strtotime($admin_searchmax_date_value)); } $login_array = get_active_emp_id();