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") {
$final_date_array[] = $final_date;
{
global $con;
$comp_sdate = mysqli_query($con, "SELECT * from USER_RIGHTS_CONFIGURATION WHERE URC_ID=11");
while ($row = mysqli_fetch_array($comp_sdate)) {
$comp_startdate = $row["URC_DATA"];
}
$comp_startdate = date('d-m-Y', strtotime($comp_startdate));
return $comp_startdate;
}
if ($_REQUEST["option"] == "admin_report_entry") {
$get_permission_array = get_permission();
$ure_uld_id = get_uldid();
$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);
