<?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'];
