<?php error_reporting(0); include "CONNECTION.php"; include "GET_USERSTAMP.php"; include "COMMON.php"; $USERSTAMP=$UserStamp; global $con; if($_REQUEST['option']=="active_emp") { $TH_active_emp=get_active_emp_id(); $TH_active_empname=array(); $TH_query=mysqli_query($con,"SELECT EMPLOYEE_NAME FROM VW_TS_ALL_EMPLOYEE_DETAILS ORDER BY EMPLOYEE_NAME ASC"); while($row=mysqli_fetch_array($TH_query)){ $TH_active_empname[]=$row["EMPLOYEE_NAME"]; } $errormessage=array(); $errormsg=mysqli_query($con,"SELECT DISTINCT EMC_DATA FROM ERROR_MESSAGE_CONFIGURATION WHERE EMC_ID IN (73,74,75)"); while($row=mysqli_fetch_array($errormsg)){ $errormessage[]=$row["EMC_DATA"]; } $TH_array_values=array($TH_active_empname,$errormessage); echo JSON_ENCODE($TH_array_values); } if($_REQUEST['option']=="search") { $loginid=$_REQUEST['empid']; $uld_id=mysqli_query($con,"select ULD_ID from VW_TS_ALL_EMPLOYEE_DETAILS where EMPLOYEE_NAME='$loginid'"); while($row=mysqli_fetch_array($uld_id)){ $TH_uld_id=$row["ULD_ID"]; } $result = $con->query("CALL SP_TS_USER_ADMIN_REPORT_DETAILS_TICKLER_DATA('$TH_uld_id','$USERSTAMP',@TEMP_UARD_TICKLER_HISTORY)");
//VER 0.02-SD:09/01/2015 ED:10/01/2015,TRACKER NO:74,Updated Sorting function //VER 0.01-INITIAL VERSION, SD:03/01/2015 ED:05/01/2015,TRACKER NO:74 //*********************************************************************************************************// 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}'");
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_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)) {
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 $CLK_errmsg = get_error_msg("15,18,83,100,101"); // REPORT CONFIGURATION LIST $CLK_report_config = mysqli_query($con, "SELECT * FROM REPORT_CONFIGURATION WHERE CGN_ID=19"); $CLK_rprtconfiglist = array(); while ($row = mysqli_fetch_array($CLK_report_config)) { $CLK_rprtconfiglist[] = array($row["RC_DATA"], $row["RC_ID"]); } // ACTIVE EMPLOYEE LIST $CLK_active_emp = get_active_emp_id(); // NONACTIVE EMPLOYEE LIST $CLK_active_nonemp = get_nonactive_emp_id(); $CLK_final_values = array($CLK_rprtconfiglist, $CLK_active_emp, $CLK_active_nonemp, $CLK_errmsg); echo JSON_ENCODE($CLK_final_values); } //SETTING MIN ND MAX DATE FOR DATE PICKER WITH LOGIN ID OPTION if ($_REQUEST["option"] == "minmax_dtewth_loginid") { $login_id = $_REQUEST['CLK_loginid']; $admin_searchmin_date = mysqli_query($con, "SELECT MIN(ECIOD_DATE) as ECIOD_DATE FROM EMPLOYEE_CHECK_IN_OUT_DETAILS where ULD_ID='{$login_id}' "); while ($row = mysqli_fetch_array($admin_searchmin_date)) { $admin_searchmin_date_value = $row["ECIOD_DATE"]; $admin_min_date = $admin_searchmin_date_value; } $admin_searchmax_date = mysqli_query($con, "SELECT MAX(ECIOD_DATE) as ECIOD_DATE FROM EMPLOYEE_CHECK_IN_OUT_DETAILS where ULD_ID='{$login_id}' "); while ($row = mysqli_fetch_array($admin_searchmax_date)) {
<?php include "../../TSLIB/TSLIB_CONNECTION.php"; include "../../TSLIB/TSLIB_GET_USERSTAMP.php"; include "../../TSLIB/TSLIB_COMMON.php"; if ($_REQUEST["option"] == "search_option") { $loginid = get_active_emp_id(); $err_msg = get_error_msg('18,103,104,105,83'); $select_query = "SELECT * FROM REPORT_CONFIGURATION WHERE RC_ID IN (1,2,6) ORDER BY RC_DATA"; $result = mysqli_query($con, $select_query); $get_report_array = array(); while ($row = mysqli_fetch_array($result)) { $get_report_array[] = array($row["RC_DATA"], $row["RC_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 = $admin_searchmin_date_value; //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 = $admin_searchmax_date_value; //date('d-m-Y',strtotime($admin_searchmax_date_value)); } $final_array = array($loginid, $err_msg, $get_report_array, $min_date, $max_date); echo JSON_ENCODE($final_array); } if ($_REQUEST["option"] == "login_id") { $login_id = $_REQUEST['login_id'];
//VER 0.01-INITIAL VERSION, SD:03/11/2014 ED:04/11/2014,TRACKER NO:97 //************************************************************************************************************// require_once 'google/appengine/api/mail/Message.php'; use google\appengine\api\mail\Message; 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 ERROR MESSAGE FROM SQL TABLE if ($_REQUEST['option'] == "INITIAL_DATAS") { // GET ERR MSG $CPVD_errmsg = get_error_msg('3,7,15,83'); $CPVD_act_employee = get_active_emp_id(); $final_array = array($CPVD_errmsg, $CPVD_act_employee); echo JSON_ENCODE($final_array); } //FETCHING COMPANY PROPERTIES DETAILS if ($_REQUEST['option'] == "COMPANY_PROPERTY") { $CPVD_loginid = $_REQUEST['CPVD_lb_loginid']; $CPVD_cmpny_prop = mysqli_query($con, "SELECT CP.CP_LAPTOP_NUMBER,CP.CP_CHARGER_NUMBER FROM COMPANY_PROPERTIES CP,COMPANY_PROPERTIES_DETAILS CPD,EMPLOYEE_DETAILS EMP WHERE CP.CP_ID=CPD.CP_ID AND EMP.EMP_ID=CPD.EMP_ID AND EMP.ULD_ID='{$CPVD_loginid}'"); while ($row = mysqli_fetch_array($CPVD_cmpny_prop)) { $CPVD_lap_no = $row["CP_LAPTOP_NUMBER"]; $CPVD_charger_no = $row["CP_CHARGER_NUMBER"]; } $CPVD_cmpny_values = array('CPVD_lap_no' => $CPVD_lap_no, 'CPVD_charger_no' => $CPVD_charger_no); $values_array[] = $CPVD_cmpny_values; echo JSON_ENCODE($values_array); }
} // PROJECT NAME LIST $project_result = mysqli_query($con, "SELECT DISTINCT PD.PD_PROJECT_NAME FROM PROJECT_DETAILS PD JOIN PROJECT_STATUS PS WHERE PD.PD_ID=PS.PD_ID ORDER BY PD_PROJECT_NAME ASC "); $REV_project_array = array(); while ($row = mysqli_fetch_array($project_result)) { $REV_project_array[] = $row["PD_PROJECT_NAME"]; } // PROJECT NAME REV VERSION LIST $REV_recversion = $_REQUEST['REV_lb_recver']; $project_result = mysqli_query($con, "SELECT PS.PS_REC_VER FROM PROJECT_DETAILS PD JOIN PROJECT_STATUS PS WHERE PD.PD_ID=PS.PD_ID and PD.PD_PROJECT_NAME='{$REV_recversion}'"); $REV_project_recver = array(); while ($row = mysqli_fetch_array($project_result)) { $REV_project_recver[] = $row["PS_REC_VER"]; } // ACTIVE EMPLOYEE LIST $REV_active_emp = get_active_emp_id(); // NON ACTIVE EMPLOYEE LIST $REV_active_nonemp = get_nonactive_emp_id(); $final_values = array($REV_projectlist, $REV_project_array, $REV_active_emp, $REV_active_nonemp, $REV_errmsg, $REV_project_recver); echo JSON_ENCODE($final_values); } //SPECICIFIED PROJECT NAM EFOR ACTINE ND NONACTIVE EMP if ($_REQUEST['option'] == "SPECICIFIED_PROJECT_NAME") { $REV_loginid = $_REQUEST['login_id']; $REV_prjct_name = get_project($REV_loginid); $final_values = array($REV_prjct_name); echo JSON_ENCODE($final_values); } //SETTING MIN ND MAX DATE FUNCTION FOR NON ACTIVE EMPLOYEE BY DATE RANGE if ($_REQUEST['option'] == "login_id") { $recver_id = $_REQUEST['project_recverss'];
$CPD_laptopno = $row['CP_LAPTOP_NUMBER']; $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'];