$USERSTAMP = $UserStamp;
global $con;
//FETCHING DATAS LOADED FRM DB FOR INITIAL LISTBX
if ($_REQUEST['option'] == "common") {
// GET ERR MSG
$REP_BND_errmsg = get_error_msg("15,18,83,100,101");
// REPORT CONFIGURATION LIST
$REP_BND_report_config = mysqli_query($con, "SELECT * FROM REPORT_CONFIGURATION WHERE CGN_ID=11");
$REP_BND_rprtconfiglist = array();
while ($row = mysqli_fetch_array($REP_BND_report_config)) {
$REP_BND_rprtconfiglist[] = array($row["RC_DATA"], $row["RC_ID"]);
}
// ACTIVE EMPLOYEE LIST
$REP_BND_active_emp = get_active_emp_id();
// NONACTIVE EMPLOYEE LIST
$REP_BND_active_nonemp = get_nonactive_emp_id();
$REP_BND_final_values = array($REP_BND_rprtconfiglist, $REP_BND_active_emp, $REP_BND_active_nonemp, $REP_BND_errmsg);
echo JSON_ENCODE($REP_BND_final_values);
}
//SETTING MIN ND MAX DATE FOR DATE PICKER WITH LOGIN ID OPTION
if ($_REQUEST["option"] == "minmax_dtewth_loginid") {
$login_id = $_REQUEST['REP_BND_loginid'];
$admin_searchmin_date = mysqli_query($con, "SELECT MIN(UARD_DATE) as UARD_DATE FROM USER_ADMIN_REPORT_DETAILS where ULD_ID='{$login_id}' ");
while ($row = mysqli_fetch_array($admin_searchmin_date)) {
$admin_searchmin_date_value = $row["UARD_DATE"];
$admin_min_date = $admin_searchmin_date_value;
}
$admin_searchmax_date = mysqli_query($con, "SELECT MAX(UARD_DATE) as UARD_DATE FROM USER_ADMIN_REPORT_DETAILS where ULD_ID='{$login_id}' ");
while ($row = mysqli_fetch_array($admin_searchmax_date)) {
$admin_searchmax_date_value = $row["UARD_DATE"];
$admin_max_date = $admin_searchmax_date_value;
$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();
$active_emp = get_active_emp_id();
$activenonemp = mysqli_query($con, "SELECT * from VW_ACCESS_RIGHTS_REJOIN_LOGINID ORDER BY ULD_LOGINID");
$active_nonemp = get_nonactive_emp_id();
$onduty_searchmin_date = mysqli_query($con, "SELECT MIN(OED_DATE) as OED_DATE FROM ONDUTY_ENTRY_DETAILS");
while ($row = mysqli_fetch_array($onduty_searchmin_date)) {
$onduty_searchmin_date_value = $row["OED_DATE"];
$od_mindate = date('d-m-Y', strtotime($onduty_searchmin_date_value));
}
$onduty_searchmax_date = mysqli_query($con, "SELECT MAX(OED_DATE) as OED_DATE FROM ONDUTY_ENTRY_DETAILS");
while ($row = mysqli_fetch_array($onduty_searchmax_date)) {
$onduty_searchmax_date_value = $row["OED_DATE"];
$od_maxdate = date('d-m-Y', strtotime($onduty_searchmax_date_value));
}
// $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'];
// }
//*********************************************************************************************************//
error_reporting(0);
if (isset($_REQUEST)) {
include "../../TSLIB/TSLIB_CONNECTION.php";
include "../../TSLIB/TSLIB_COMMON.php";
include "../../TSLIB/TSLIB_GET_USERSTAMP.php";
$USERSTAMP = $UserStamp;
global $con;
//FETCHING DATAS LOADED FRM DB FOR INITIAL LISTBX
if ($_REQUEST['option'] == "common") {
// GET ERR MSG
$REP_chk_errmsg = get_error_msg("15,16,18,83,121,122");
//GET ACTIVE LOGIN ID
$REP_chk_active_emp = get_active_emp_id();
// NONACTIVE EMPLOYEE LIST
$REP_chk_active_nonemp = get_nonactive_emp_id();
// REPORT CONFIGURATION LIST
$REP_report_config = mysqli_query($con, "SELECT * FROM REPORT_CONFIGURATION WHERE CGN_ID=16");
$REP_rprtconfiglist = array();
while ($row = mysqli_fetch_array($REP_report_config)) {
$REP_rprtconfiglist[] = array($row["RC_DATA"], $row["RC_ID"]);
}
$REP_CHK_final_values = array($REP_chk_active_emp, $REP_chk_active_nonemp, $REP_rprtconfiglist, $REP_chk_errmsg);
echo JSON_ENCODE($REP_CHK_final_values);
}
//SETTING MIN ND MAX DATE FOR DATE PICKER WITH LOGIN ID OPTION
if ($_REQUEST["option"] == "datemin_max") {
$login_id = $_REQUEST['REP_chk_loginid'];
$uld_id = mysqli_query($con, "select ULD_ID from USER_LOGIN_DETAILS where ULD_LOGINID='{$login_id}'");
while ($row = mysqli_fetch_array($uld_id)) {
$REP_uld_id = $row["ULD_ID"];
$CPD_chargerno = $row['CP_CHARGER_NUMBER'];
$CPD_battery = $row['CP_BATTERY_SERIAL_NUMBER'];
$CPD_laptopbag = $row['CP_LAPTOP_BAG_NUMBER'];
$CPD_mouse = $row['CP_MOUSE_NUMBER'];
$CPD_dooraccess = $row['CPD_DOOR_ACCESS'];
$CPD_idcard = $row['CPD_ID_CARD'];
$CPD_headset = $row['CPD_HEADSET'];
$final_values = array('empname' => $AE_empname, 'laptopno' => $CPD_laptopno, 'chargerno' => $CPD_chargerno, 'battery' => $CPD_battery, 'laptopbag' => $CPD_laptopbag, 'mouse' => $CPD_mouse, 'dooraccess' => $CPD_dooraccess, 'idcard' => $CPD_idcard, 'headset' => $CPD_headset);
$ure_values[] = $final_values;
}
$finalvalue = array($ure_values, $errormessages);
echo JSON_ENCODE($finalvalue);
}
if ($_REQUEST['option'] == "ACTIVE_EMPLOYEE") {
$empdet_active_emp = get_active_emp_id();
$empdet_active_nonemp = get_nonactive_emp_id();
$REV_errmsg = get_error_msg('148,149,150,151,152,153');
$final_values = array($empdet_active_emp, $empdet_active_nonemp, $REV_errmsg);
echo JSON_ENCODE($final_values);
}
if ($_REQUEST['option'] == "ACTIVE_EMPLOYEE_companydet") {
$EMP_loginid = $_REQUEST['login_id'];
// echo $EMP_loginid;
$date = mysqli_query($con, "SELECT CONCAT(EMP.EMP_FIRST_NAME,'',EMP.EMP_LAST_NAME) AS EMPLOYEE_NAME,CP.CP_LAPTOP_NUMBER,CP.CP_CHARGER_NUMBER,CP.CP_BATTERY_SERIAL_NUMBER,CP.CP_LAPTOP_BAG_NUMBER,CP.CP_MOUSE_NUMBER,CPD.CPD_DOOR_ACCESS,CPD.CPD_ID_CARD,CPD.CPD_HEADSET FROM COMPANY_PROPERTIES CP,EMPLOYEE_DETAILS EMP,COMPANY_PROPERTIES_DETAILS CPD,USER_ACCESS UA,USER_LOGIN_DETAILS ULD WHERE CP.CP_ID = CPD.CP_ID AND EMP.EMP_ID=CPD.EMP_ID AND UA.ULD_ID=EMP.ULD_ID AND ULD.ULD_ID=UA.ULD_ID AND ULD.ULD_ID=EMP.ULD_ID AND UA.UA_TERMINATE IS NULL AND ULD.ULD_ID={$EMP_loginid} ORDER BY EMPLOYEE_NAME ASC");
// $ure_values=array();
$final_values = array();
while ($row = mysqli_fetch_array($date)) {
$AE_empname = $row['EMPLOYEE_NAME'];
$CPD_laptopno = $row['CP_LAPTOP_NUMBER'];
$CPD_chargerno = $row['CP_CHARGER_NUMBER'];
$CPD_battery = $row['CP_BATTERY_SERIAL_NUMBER'];
