return $active_nonemp; } function get_company_start_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();
include "../TSLIB/TSLIB_GET_USERSTAMP.php"; include "../TSLIB/TSLIB_COMMON.php"; date_default_timezone_set('Asia/Kolkata'); $USERSTAMP = $UserStamp; if ($_REQUEST["option"] == "login_id") { $ADM_uld_id = $_REQUEST['login_id']; $min_date = mysqli_query($con, "SELECT UA_JOIN_DATE FROM USER_ACCESS where ULD_ID='{$ADM_uld_id}' AND UA_TERMINATE IS NULL"); while ($row = mysqli_fetch_array($min_date)) { $mindate_array = $row["UA_JOIN_DATE"]; $min_date = date('d-m-Y', strtotime($mindate_array)); } $select_wfh = mysqli_query($con, "select WFHA_FLAG from WORK_FROM_HOME_ACCESS where ULD_ID={$ADM_uld_id}"); while ($row = mysqli_fetch_array($select_wfh)) { $wfh_flag = $row['WFHA_FLAG']; } $get_project_array = get_projectentry($ADM_uld_id); $finalvalue = array($min_date, $get_project_array, $wfh_flag); echo JSON_ENCODE($finalvalue); } if ($_REQUEST["option"] == "LOGINID") { $ADM_uld_id = $_REQUEST['login_id']; $min_date = mysqli_query($con, "SELECT UA_JOIN_DATE FROM USER_ACCESS where ULD_ID='{$ADM_uld_id}' AND UA_TERMINATE IS NULL"); while ($row = mysqli_fetch_array($min_date)) { $mindate_array = $row["UA_JOIN_DATE"]; $min_date = date('d-m-Y', strtotime($mindate_array)); } echo $min_date; } if ($_REQUEST["option"] == "DATE") { $date = $_REQUEST['date_change']; $ADM_uld_id = $_REQUEST['login_id'];
} function get_company_start_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(); $error='3,4,5,6,7,8,16,17,18,67,115,132,133'; $error_array=get_error_msg($error); $min_date=get_joindate($ure_uld_id); $login_array=get_active_emp_id(); $values_array=array($get_permission_array,$get_project_array,$min_date,$error_array,$login_array); 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,132,133'; $error_array=get_error_msg($error);
} echo json_encode($ure_date_array); } if($_REQUEST['option']=='PRESENT') { $row=get_projectentry(); if(count($row)!=0) { $flag=1; } else { $flag=0; } echo $flag; } if($_REQUEST['option']=='HALFDAYABSENT') { $row=get_projectentry(); if(count($row)!=0) { $flag=1; } else { $flag=0; } echo $flag; } ?>