error_reporting(0);
include "../LMC_LIB/CONNECTION.php";
include "../LMC_LIB/GET_USERSTAMP.php";
include "../LMC_LIB/COMMON.php";
$dir = dirname(dirname(__FILE__)) . DIRECTORY_SEPARATOR;
date_default_timezone_set('Asia/Singapore');
$parentdocfolder = get_reportdocfolder_id();
if ($_REQUEST['option'] == 'COMMON_DATA') {
// category
$categories = mysqli_query($con, "SELECT RDC_ID,RDC_CATEGORY FROM LMC_REPORT_DOCUMENT_CATEGORY ORDER BY RDC_CATEGORY ASC");
while ($row = mysqli_fetch_array($categories)) {
$category[] = $row["RDC_CATEGORY"];
}
//ERRPOR MESSAGE
$errormsg = get_error_msg('133,141,142,146');
$values = array($category, $errormsg);
echo JSON_encode($values);
} elseif ($_REQUEST['option'] == 'tempfilname') {
$uploadcount = $_REQUEST['ENT_upload_count'];
$date = $_REQUEST['doc_date'];
$category = $_REQUEST['doc_lb_category'];
$uploaddate = date('Y-m-d', strtotime($date));
$repdate = str_replace('-', '', $date);
$upload_file_array = array();
$uploadpath = $dir . $parentdocfolder . DIRECTORY_SEPARATOR;
// echo $uploadpath;exit;
for ($x = 1; $x <= $uploadcount; $x++) {
if ($_FILES['ENT_upload_filename' . $x]['name'] != '') {
$attach_file_name = $repdate . '_' . date('His') . '_' . $_FILES['ENT_upload_filename' . $x]['name'];
if (move_uploaded_file($_FILES['ENT_upload_filename' . $x]['tmp_name'], $uploadpath . $attach_file_name)) {
$status = mysqli_query($con, "SELECT PC_DATA from PROJECT_CONFIGURATION WHERE CGN_ID=7 ");
$pro_status = array();
while ($row = mysqli_fetch_array($status)) {
$pro_status[] = $row["PC_DATA"];
}
echo json_encode($pro_status);
} else {
if ($_REQUEST['option'] == 'AUTO') {
global $con;
$create_view = mysqli_query($con, "CREATE OR REPLACE VIEW VW_PROJECT AS SELECT PD_ID,MAX(PS_REC_VER)AS RECVER FROM PROJECT_STATUS GROUP BY PD_ID");
$auto = mysqli_query($con, " SELECT P.PD_PROJECT_NAME FROM PROJECT_DETAILS P,PROJECT_STATUS PS,VW_PROJECT V WHERE P.PD_ID=PS.PD_ID AND V.PD_ID=PS.PD_ID AND V.RECVER=PS.PS_REC_VER AND PS.PC_ID=3");
$pro_auto = array();
while ($row = mysqli_fetch_array($auto)) {
$pro_auto[] = $row["PD_PROJECT_NAME"];
}
$erro_msg = get_error_msg('62,63,79,80,81,83,99');
$project_result = mysqli_query($con, "select PC_ID,PC_DATA from PROJECT_CONFIGURATION");
$get_project_status_array = array();
while ($row = mysqli_fetch_array($project_result)) {
$get_project_status_array[] = array($row["PC_ID"], $row["PC_DATA"]);
}
$comp_startdate = get_company_start_date();
$values = array($pro_auto, $erro_msg, $comp_startdate, $get_project_status_array);
$drop_view = mysqli_query($con, 'drop view if exists VW_PROJECT');
echo json_encode($values);
}
}
}
}
}
if (isset($_REQUEST['option']) && $_REQUEST['option'] != '') {
if($_REQUEST['option']=="CONFIG_SRCH_UPD_load_mod")
{
// GET ERR MSG
$CONFIG_SRCH_UPD_errmsg=get_error_msg('17,60,113,125,126,127,128,129,131,132');
echo JSON_ENCODE($CONFIG_SRCH_UPD_errmsg);
}
if($_REQUEST['option']=="CONFIG_SRCH_UPD_load_type")
{
$CONFIG_SRCH_UPD_mod=$_REQUEST['module'];
//CONFIG TYPE LIST
$CONFIG_SRCH_UPD_type = mysqli_query($con,"SELECT * FROM LMC_CONFIGURATION WHERE CGN_ID IN (9,10,11,12,13,14,16,17,18,19,20) ORDER BY CGN_TYPE ASC");
$CONFIG_SRCH_UPD_arr_type=array();
while($row=mysqli_fetch_array($CONFIG_SRCH_UPD_type)){
$CONFIG_SRCH_UPD_arr_type[]=array($row[0],$row[2]);
}
$CONFIG_SRCH_UPD_errmsg=get_error_msg('17,60,113,125,126,127,128,129,131,132');
$values=array($CONFIG_SRCH_UPD_arr_type,$CONFIG_SRCH_UPD_errmsg);
echo JSON_ENCODE($values);
}
//LOAD DATA FOR FLEX TABLE
if($_REQUEST['option']=="CONFIG_SRCH_UPD_load_data")
{
$CONFIG_SRCH_UPD_type=$_REQUEST['CONFIG_SRCH_UPD_lb_type'];
if($CONFIG_SRCH_UPD_type==13)
{
$CONFIG_SRCH_UPD_sql_data = mysqli_query($con,"SELECT LTC.TC_ID,LTC.TEAM_NAME,ULD.ULD_USERNAME,DATE_FORMAT((LTC.TC_TIMESTAMP),'%d-%m-%Y %T') AS TC_TIMESTAMP FROM LMC_TEAM_CREATION LTC ,LMC_USER_LOGIN_DETAILS ULD WHERE LTC.ULD_ID=ULD.ULD_ID ORDER BY LTC.TEAM_NAME");
}
else if($CONFIG_SRCH_UPD_type==14)
{
$CONFIG_SRCH_UPD_sql_data = mysqli_query($con,"SELECT LMT.MT_ID,LMT.MT_TOPIC,ULD.ULD_USERNAME,DATE_FORMAT((LMT.MT_TIMESTAMP),'%d-%m-%Y %T') AS MT_TIMESTAMP FROM LMC_MEETING_TOPIC LMT,LMC_USER_LOGIN_DETAILS ULD WHERE LMT.ULD_ID=ULD.ULD_ID ORDER BY LMT.MT_TOPIC");
}
//VER 0.03-SD:03/01/2015 ED:06/01/2015, TRACKER NO:74,DESC: SETTING PRELOADER POSITON AND MSGBOX POSITION
//DONE BY:LALITHA
//VER 0.02-SD:14/11/2014 ED:14/11/2014,TRACKER NO:74,Fixed width
//VER 0.01-INITIAL VERSION, SD:27/10/2014 ED:28/10/2014,TRACKER NO:99
//*********************************************************************************************************//
error_reporting(0);
if(isset($_REQUEST)){
include "CONNECTION.php";
include "COMMON.php";
include "GET_USERSTAMP.php";
$USERSTAMP=$UserStamp;
global $con;
//FUNCTION TO FETCHING EMAIL TEMPLATE SCRIPT NAME,ERROR MESSAGE FROM SQL TABLE
if($_REQUEST['option']=="INITIAL_DATAS"){
// GET ERR MSG
$ET_SRC_UPD_DEL_errmsg=get_error_msg('56,87,88,89');
$ET_SRC_UPD_DEL_emltemp = mysqli_query($con,"SELECT ET_ID,ET_EMAIL_SCRIPT FROM EMAIL_TEMPLATE ORDER BY ET_EMAIL_SCRIPT");
$ET_SRC_UPD_DEL_script_object=array();
while($row=mysqli_fetch_array($ET_SRC_UPD_DEL_emltemp)){
$ET_SRC_UPD_DEL_script_object[]=array($row["ET_EMAIL_SCRIPT"],$row["ET_ID"]);
}
$ET_SRC_UPD_DEL_final_values=array($ET_SRC_UPD_DEL_script_object,$ET_SRC_UPD_DEL_errmsg);
echo JSON_ENCODE($ET_SRC_UPD_DEL_final_values);
}
//FUNCTION FOR SHOW THE DATA IN TABLE
if($_REQUEST['option']=="EMAIL_TEMPLATE_DETAILS"){
$ET_SRC_UPD_DEL_scriptname=$_POST['ET_SRC_UPD_DEL_lb_scriptname'];
$ET_SRC_UPD_DEL_flextbl= mysqli_query($con,"SELECT DATE_FORMAT(CONVERT_TZ(ETD.ETD_TIMESTAMP,'+00:00','+08:00'),'%d-%m-%Y %T') AS TIMESTAMP,ETD.ETD_EMAIL_SUBJECT,ETD.ETD_EMAIL_BODY,ULD.ULD_LOGINID,ETD.ETD_ID FROM EMAIL_TEMPLATE_DETAILS ETD,USER_LOGIN_DETAILS ULD WHERE ETD.ULD_ID=ULD.ULD_ID AND ETD.ET_ID='$ET_SRC_UPD_DEL_scriptname'");
$ET_SRC_UPD_DEL_values=array();
while($row=mysqli_fetch_array($ET_SRC_UPD_DEL_flextbl)){
$ET_SRC_UPD_DEL_subject=$row["ETD_EMAIL_SUBJECT"];
// while($row=mysqli_fetch_array($CONFIG_ENTRY_mod)){
// $CONFIG_ENTRY_arr_mod[]=array($row[0],$row[1]);
// }
// $CONFIG_ENTRY_errmsg_modlist=array($CONFIG_ENTRY_errmsg,$CONFIG_ENTRY_arr_mod);
echo JSON_ENCODE($CONFIG_ENTRY_errmsg);
}
if($_REQUEST['option']=="CONFIG_ENTRY_load_type")
{
// $CONFIG_ENTRY_mod=$_REQUEST['module'];
//CONFIG TYPE LIST
$CONFIG_ENTRY_type = mysqli_query($con,"SELECT * FROM LMC_CONFIGURATION WHERE CNP_ID='2' AND (CGN_NON_IP_FLAG is null) ORDER BY CGN_TYPE ASC");
$CONFIG_ENTRY_arr_type=array();
while($row=mysqli_fetch_array($CONFIG_ENTRY_type)){
$CONFIG_ENTRY_arr_type[]=array($row[0],$row[2]);
}
$CONFIG_ENTRY_errmsg=get_error_msg('71,127,130,131');
$values=array($CONFIG_ENTRY_arr_type,$CONFIG_ENTRY_errmsg);
echo JSON_ENCODE($values);
}
//SAVE CODING
if($_REQUEST['option']=="CONFIG_ENTRY_save")
{
$flag=$_REQUEST['CONFIG_ENTRY_lb_module'];
$CONFIG_ENTRY_data=$_REQUEST['CONFIG_ENTRY_tb_data'];
$CONFIG_ENTRY_data=$con->real_escape_string($CONFIG_ENTRY_data);
$CONFIG_ENTRY_type=$_REQUEST['CONFIG_ENTRY_lb_type'];
$CONFIG_ENTRY_arr_config=array(3=>array("LMC_USER_RIGHTS_CONFIGURATION","URC_DATA"));
$sql1= "SELECT ".$CONFIG_ENTRY_arr_config[$flag][1]." FROM ".$CONFIG_ENTRY_arr_config[$flag][0]." CCN WHERE CCN.CGN_ID=(SELECT C.CGN_ID FROM LMC_CONFIGURATION C WHERE C.CGN_ID='$CONFIG_ENTRY_type') AND ".$CONFIG_ENTRY_arr_config[$flag][1]."='$CONFIG_ENTRY_data'";
$CONFIG_ENTRY_type1 = mysqli_query($con,$sql1);
$CONFIG_ENTRY_save=0;
if($row=mysqli_fetch_array($CONFIG_ENTRY_type1)){
if(isset($_REQUEST)){
include "CONNECTION.php";
include "COMMON.php";
include "GET_USERSTAMP.php";
$USERSTAMP=$UserStamp;
global $con;
//FETCHING DATAS LOADED FRM DB FOR LOGIN ID ND ERR MSGS
if($_REQUEST['option']=="common")
{
$active_login_id=mysqli_query($con,"SELECT ULD_LOGINID from VW_ACCESS_RIGHTS_TERMINATE_LOGINID where URC_DATA!='SUPER ADMIN' AND ULD_LOGINID IN (SELECT ULD_LOGINID FROM USER_LOGIN_DETAILS WHERE ULD_ID NOT IN (SELECT ULD_ID FROM EMPLOYEE_PROJECT_DETAILS)) ORDER BY ULD_LOGINID");
$REV_active_emp=array();
while($row=mysqli_fetch_array($active_login_id)){
$REV_active_emp[]=$row["ULD_LOGINID"];
}
$get_project_array=get_emp_projectentry();
$EMP_ENTRY_errmsg=get_error_msg('71,83,117');
$final_values=array($REV_active_emp,$get_project_array,$EMP_ENTRY_errmsg);
echo JSON_ENCODE($final_values);
}
//FUNCTION FOR TO SAVE THE EMPLOYEE PROJECT DETAILS
if($_REQUEST['option']=="PROJECT_PROPETIES_SAVE"){
$EMP_ENTRY_loginid=$_POST['EMP_ENTRY_lb_loginid'];
$uld_id=mysqli_query($con,"select ULD_ID from USER_LOGIN_DETAILS where ULD_LOGINID='$EMP_ENTRY_loginid'");
while($row=mysqli_fetch_array($uld_id)){
$EMP_ENTRY_uld_id=$row["ULD_ID"];
}
$project=$_POST['checkbox'];
$length=count($project);
$projectid;
for($i=0;$i<$length;$i++){
if($i==0){
<?php
error_reporting(0);
include "../LMC_LIB/CONNECTION.php";
include "../LMC_LIB/GET_USERSTAMP.php";
include "../LMC_LIB/COMMON.php";
if($_REQUEST['option']=='Get_initialdata'){
// ERRPOR MESSAGE
$errormsg[]=get_error_msg('83,167,168');
echo json_encode($errormsg);
}
else if($_REQUEST['option']=='Chart_input'){
$fromdate=$_REQUEST['fromdate'];
$todate=$_REQUEST['todate'];
$flag=$_REQUEST['flag'];
$chart_twodimens_arr=[];
$contract_dtl=array();
if($flag=='chart_flag_month'){
$sqlquery="CALL SP_LMC_CONTRACT_CHART(1,'$fromdate',NULL,'$UserStamp',@TEMP_TABLE)";
}
else if($flag=='chart_flag_range'){
$sqlquery="CALL SP_LMC_CONTRACT_CHART(2,'$fromdate','$todate','$UserStamp',@TEMP_TABLE)";
}
$result = $con->query($sqlquery);
if (!$result) {
$flag = 0;
die("CALL failed: (" . $con->errno . ") " . $con->error);
}
$selecttable = $con->query('SELECT @TEMP_TABLE');
$resulttable = $selecttable->fetch_assoc();
$tablename = $resulttable['@TEMP_TABLE'];
if($tablename!='') {
//VER 0.03-SD:29/10/2014 ED:31/10/2014,TRACKER NO:97,Fixed the column nd div width,Changed the data table header is meaningful nd put space also,Updated Sorting fr dte,Hide the section id nd old dt datas while listbx changing fn,Added Preloader in list bx fn ,Column values alignd in centre
//VER 0.02-SD:14/10/2014 ED:21/10/2014,TRACKER NO:97,Did others two parts of projects,Changed data tble for prjct rvn by actv nonactv emp option,Removed hard code of list bx option(tkn data nd id also frm db),Updated data tble,validation,Loaded all err msg frm db,hiding err msg,lbls nd others fields in unwanted places,Changed queries,update dte frmt,Update comments,Set min nd max dte
//DONE BY:SASIKALA
//VER 0.01-INITIAL VERSION, SD:08/10/2014 ED:15/10/2014,TRACKER NO:97
//*********************************************************************************************************//
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 LISTBX
if ($_REQUEST['option'] == "common") {
// GET ERR MSG
$REV_errmsg = get_error_msg('15,16,75,82,83,106,107,108,111,112');
// REPORT CONFIGURATION LIST
$REV_project_list = mysqli_query($con, "SELECT * FROM REPORT_CONFIGURATION WHERE CGN_ID=2");
$REV_projectlist = array();
while ($row = mysqli_fetch_array($REV_project_list)) {
$REV_projectlist[] = array($row["RC_DATA"], $row["RC_ID"]);
}
// 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}'");
//*******************************************FILE DESCRIPTION*********************************************//
//*******************************************PUBLIC HOLIDAY SEARCH/UPDATE*********************************************//
//DONE BY:LALITHA
//VER 0.01-INITIAL VERSION, SD:17/12/2014 ED:17/12/2014,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 LISTBX
if ($_REQUEST['option'] == "common") {
// GET ERR MSG
$PH_SRC_UPD_nodate = get_error_msg('4,18,56,83,89');
// YEAR FOR PUBLIC HOLIDAY
$PH_SRC_UPD_yr_list = mysqli_query($con, "SELECT DISTINCT DATE_FORMAT(PH_DATE, '%Y')AS YEAR FROM PUBLIC_HOLIDAY;");
$PH_SRC_UPD_yrlist = array();
while ($row = mysqli_fetch_array($PH_SRC_UPD_yr_list)) {
$PH_SRC_UPD_yrlist[] = array($row["YEAR"]);
}
$final_values = array($PH_SRC_UPD_yrlist, $PH_SRC_UPD_nodate);
echo JSON_ENCODE($final_values);
}
if ($_REQUEST['option'] == "PUBLIC_HOLIDAY_DETAILS") {
//FETCHING USER LOGIN DETAILS RECORDS
$PH_SRC_UPD_year = $_REQUEST["PH_SRC_UPD_lb_yr"];
$date = mysqli_query($con, "SELECT PH.PH_ID,DATE_FORMAT(PH.PH_DATE,'%d-%m-%Y') AS PH_DATE,PH.PH_DESCRIPTION,ULD.ULD_LOGINID,DATE_FORMAT(CONVERT_TZ(PH.PH_TIMESTAMP,'+00:00','+05:30'), '%d-%m-%Y %T') AS PH_TIMESTAMP FROM PUBLIC_HOLIDAY PH ,USER_LOGIN_DETAILS ULD WHERE PH.ULD_ID=ULD.ULD_ID AND YEAR(PH.PH_DATE)='{$PH_SRC_UPD_year}'");
$ure_values = array();
while ($row = mysqli_fetch_array($date)) {
$uldid=$row["ULD_ID"];
}
if($_REQUEST['option']=='INITIAL_DATA')
{
// POSITION
$position=mysqli_query($con,"SELECT WD_ID,WD_DESIGNATION FROM LMC_WORKER_DESIGNATION ORDER BY WD_DESIGNATION ASC");
while($row=mysqli_fetch_array($position)){
$employeepostion[]=array($row['WD_DESIGNATION'],$row['WD_ID']);
}
//TEAM NAME
$teamname=mysqli_query($con,"SELECT TC_ID,TEAM_NAME FROM LMC_TEAM_CREATION ORDER BY TEAM_NAME ASC");
while($row=mysqli_fetch_array($teamname)){
$empteamname[]=array($row['TEAM_NAME'],$row['TC_ID']);
}
//ERROR MESSAGE
$errormsg=get_error_msg('149,150,153,154,155');
//NOT ASSIGN
$empnotassign=mysqli_query($con,"SELECT DISTINCT ULD_ID,ULD_WORKER_NAME FROM LMC_USER_LOGIN_DETAILS WHERE ULD_ID NOT IN (SELECT ULD_ID FROM LMC_EMPLOYEE_TEAM_DETAILS ) ORDER BY ULD_WORKER_NAME");
$numrow=mysqli_num_rows($empnotassign);
if($numrow>0)
{
while($row=mysqli_fetch_array($empnotassign)){
$data[]=array($row['ULD_ID'],$row['ULD_WORKER_NAME']);
}
$values=array($data,$empteamname,$employeepostion,$errormsg);
}
else
{
$values=array($numrow,$empteamname,$employeepostion,$errormsg);
}
echo json_encode($values);
$sql = "SELECT PC_BALANCE FROM PETTY_CASH WHERE PC_ID=(SELECT MAX(PC_ID) FROM PETTY_CASH)";
$result = mysqli_query($con, $sql);
while ($row = mysqli_fetch_array($result)) {
$opt = $row["PC_BALANCE"];
}
if ($opt == null) {
$opt = 0;
}
$error = '1,2,3,4,17,7';
$error_array = get_error_msg($error);
$finalarr = array($opt, $error_array);
echo json_encode($finalarr);
}
if ($_REQUEST["option"] == "petty_cash_form") {
$error = '1,2,3,7';
$error_array[] = get_error_msg($error);
}
//FUNCTION FOR INSERT
if ($_POST['Option'] == 'Insert') {
$Date = date("Y-m-d", strtotime($_POST['PC_tb_DATE']));
$amount = $_POST['PC_tb_atm'];
$inviceitem = $_POST['PC_tb_INVOICE_ITEMS'];
$Report = $_POST['PC_tb_COMMENTS'];
$cash = $_POST['PC_cash_radio'];
if ($_POST['PC_cash_radio'] == "PC_CASH_IN") {
$cashout = 'null';
$QUERY = "CALL SP_PETTY_CASH_INSERT('{$Date}','{$amount}',{$cashout},'{$inviceitem}','{$Report}','{$USERSTAMP}',@flag)";
$result = $con->query($QUERY);
if (!$result) {
die("CALL failed: (" . $con->errno . ") " . $con->error);
}
echo JSON_ENCODE($URSRC_role_array);
}
$project_result = mysqli_query($con, "SELECT AC_ID,AC_DATA FROM ATTENDANCE_CONFIGURATION WHERE AC_ID=15");
$get_project_array = array();
while ($row = mysqli_fetch_array($project_result)) {
$get_project_array[] = array($row["AC_DATA"], $row["AC_ID"]);
}
// }
//FETCHING DATAS LOADED FRM DB FOR LOGIN ID ND ERR MSGS
if ($_REQUEST['option'] == "common") {
$REV_active_empname = mysqli_query($con, "SELECT * FROM VW_TS_ALL_ACTIVE_EMPLOYEE_DETAILS WHERE URC_DATA!='SUPER ADMIN' ORDER BY EMPLOYEE_NAME");
$REV_active_emp = array();
while ($row = mysqli_fetch_array($REV_active_empname)) {
$REV_active_emp[] = array($row["EMPLOYEE_NAME"], $row["ULD_ID"]);
}
$EMP_ENTRY_errmsg = get_error_msg('71,83,139,140');
$final_values = array($REV_active_emp, $get_project_array, $EMP_ENTRY_errmsg);
echo json_encode($final_values);
}
//FETCHING SELECT DATA VALUE
if ($_REQUEST['option'] == "check_flag") {
$loginid = $_REQUEST['loginid'];
$check_flag = mysqli_query($con, "SELECT WFHA_FLAG FROM WORK_FROM_HOME_ACCESS WHERE WFHA_FLAG='X' AND ULD_ID={$loginid}");
$flag = '';
while ($row = mysqli_fetch_array($check_flag)) {
$flag = $row['WFHA_FLAG'];
}
echo json_encode($flag);
}
//FUNCTION TO SAVE AND UPDATE THE EMPLOYEE PROJECT DETAILS
$EMP_ENTRY_uld_id = $_POST['EMP_ENTRY_lb_loginid'];
<?php
//error_reporting(0);
include "TSLIB/TSLIB_GET_USERSTAMP.php";
include "TSLIB/TSLIB_CONNECTION.php";
include "TSLIB/TSLIB_COMMON.php";
$USERSTAMP = $UserStamp;
if ($_REQUEST['option'] == "MENU") {
mysqli_report(MYSQLI_REPORT_STRICT);
$user_ipaddress = $ip = getenv('HTTP_CLIENT_IP') ?: ($user_ipaddress = getenv('HTTP_X_FORWARDED_FOR') ?: ($user_ipaddress = getenv('HTTP_X_FORWARDED') ?: ($user_ipaddress = getenv('HTTP_FORWARDED_FOR') ?: ($user_ipaddress = getenv('HTTP_FORWARDED') ?: ($user_ipaddress = getenv('REMOTE_ADDR'))))));
$ip_check_flag = 0;
$flag_wfh = null;
try {
$err_msg = get_error_msg('61,119,124');
$select_loginid_role = mysqli_query($con, "SELECT URC_DATA from VW_ACCESS_RIGHTS_TERMINATE_LOGINID where ULD_LOGINID='{$USERSTAMP}' ");
$login_id_role;
while ($row = mysqli_fetch_array($select_loginid_role)) {
$login_id_role = $row["URC_DATA"];
}
$userstamp_id = mysqli_query($con, "select ULD_ID from USER_LOGIN_DETAILS where ULD_LOGINID='{$USERSTAMP}'");
while ($row = mysqli_fetch_array($userstamp_id)) {
$ADM_userstamp_id = $row["ULD_ID"];
}
$wfh_flag = mysqli_query($con, "select WFHA_FLAG from WORK_FROM_HOME_ACCESS where ULD_ID={$ADM_userstamp_id}");
$wfh_row = mysqli_num_rows($wfh_flag);
if ($wfh_row > 0) {
if ($row = mysqli_fetch_array($wfh_flag)) {
$flag_wfh = $row['WFHA_FLAG'];
}
if ($flag_wfh == 'X') {
$ip_check_flag = 1;
include "../LMC_LIB/GET_USERSTAMP.php";
include "../LMC_LIB/COMMON.php";
function inital_data()
{
global $con;
$itemno = array();
$itemdtl = mysqli_query($con, "SELECT LID_ID,LID_ITEM_NO,LID_DESCRIPTION FROM LMC_INVENTORY_ITEM_DETAILS ORDER BY LID_ITEM_NO");
while ($row = mysqli_fetch_array($itemdtl)) {
$itemno[] = array('id' => $row["LID_ID"], 'no' => $row["LID_ITEM_NO"], 'name' => $row["LID_DESCRIPTION"]);
}
return $itemno;
}
if ($_REQUEST['option'] == 'get_item_no') {
$itemdetail = inital_data();
// ERRPOR MESSAGE
$errormsg = get_error_msg('3,7,83');
$values = array($itemdetail, $errormsg);
echo json_encode($values);
} elseif ($_REQUEST['option'] == 'get_item_name') {
$itemnoid = $_REQUEST['item_no'];
$itemname = array();
$itemdtl = mysqli_query($con, "SELECT LID_DESCRIPTION FROM LMC_INVENTORY_ITEM_DETAILS WHERE LID_ID='{$itemnoid}'");
if ($row = mysqli_fetch_array($itemdtl)) {
$itemname = $row["LID_DESCRIPTION"];
}
echo $itemname;
} elseif ($_REQUEST['option'] == 'get_sitestock') {
$fromdate = $_REQUEST['ISS_db_datesrchfrom'];
$todate = $_REQUEST['ISS_db_datesrchto'];
$itemno = $_REQUEST['ISS_lb_itemnosrch'];
$itemname = $_REQUEST['ISS_lb_itemnamesrch'];
$userstamp_id = mysqli_query($con, "SELECT ULD_ID FROM LMC_USER_LOGIN_DETAILS WHERE ULD_USERNAME='******'");
if ($row = mysqli_fetch_array($userstamp_id)) {
$uldid = $row["ULD_ID"];
}
if ($_REQUEST['option'] == 'INITIAL_DATA') {
//TEAM NAME
$teamname = mysqli_query($con, "SELECT TC_ID,TEAM_NAME FROM LMC_TEAM_CREATION ORDER BY TEAM_NAME ASC");
while ($row = mysqli_fetch_array($teamname)) {
$empteamname[] = array($row['TEAM_NAME'], $row['TC_ID']);
}
//STATUS
$status = mysqli_query($con, "SELECT LCS_ID,LCS_STATUS FROM LMC_CONTRACT_STATUS ORDER BY LCS_STATUS ASC");
while ($row = mysqli_fetch_array($status)) {
$jobstatus[] = array($row['LCS_STATUS'], $row['LCS_ID']);
}
$errormsg = get_error_msg('3,4,7,17');
$values = array($empteamname, $jobstatus, $errormsg);
echo json_encode($values);
} elseif ($_REQUEST['option'] == 'contractsaveupdate') {
$CC_contractno = $_REQUEST['CC_contractid'];
$CC_customername = $_REQUEST['CC_customername'];
$CC_contactperson = $_REQUEST['CC_contactperson'];
$CC_location = $_REQUEST['CC_location'];
$CC_address = $_REQUEST['CC_address'];
$CC_address = $con->real_escape_string($CC_address);
$CC_paymentterm = $_REQUEST['CC_paymentterm'];
$CC_nextnumber = $_REQUEST['CC_nextnumber'];
$CC_type = $_REQUEST['CC_type'];
if ($CC_type == 'SELECT') {
$CC_type = '';
}
//VER 0.02 SD:06/12/2014 ED:08/12/2014,TRACKER NO:74,Updated preloader position nd message box position,Changed loginid to emp name
//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);
//*******************************************CLOCK IN/OUT DETAILS*********************************************//
//DONE BY:LALITHA
//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") {
while ($row = mysqli_fetch_array($URSRC_select_basicrole_result)) {
$URSRC_basicrole = $row["URC_DATA"];
}
$URSRC_basicroleid_array_result = mysqli_query($con, "select * from LMC_USER_RIGHTS_CONFIGURATION URC,LMC_BASIC_ROLE_PROFILE BRP where URC.URC_DATA='" . $URSRC_basicrole . "' and URC.URC_ID=BRP.URC_ID");
$URSRC_basicroleid_array = array();
while ($row = mysqli_fetch_array($URSRC_basicroleid_array_result)) {
$URSRC_basicroleid_array[] = $row["BRP_BR_ID"];
}
$get_URSRC_basicrole_profile_array = array();
for ($i = 0; $i < count($URSRC_basicroleid_array); $i++) {
$URSRC_basicrole_profile_array_result = mysqli_query($con, "select * from LMC_USER_RIGHTS_CONFIGURATION URC,LMC_BASIC_ROLE_PROFILE BRP where BRP.BRP_BR_ID=URC.URC_ID and BRP.BRP_BR_ID='" . $URSRC_basicroleid_array[$i] . "' order by URC_DATA asc ");
while ($row = mysqli_fetch_array($URSRC_basicrole_profile_array_result)) {
$get_URSRC_basicrole_profile_array[] = $row["URC_DATA"];
}
}
$get_URSRC_basicrole_profile_array = array_values(array_unique($get_URSRC_basicrole_profile_array));
$comp_startdate = get_company_start_date();
$value_array = array($get_rolecreation_array, $get_project_array, $get_menuname_array, $get_URSRC_basicrole_profile_array, $URSRC_errmsg, $get_emptype_array, $comp_startdate, $get_team_array);
echo JSON_ENCODE($value_array);
}
if ($_REQUEST["option"] == "EMAIL_TEMPLATE_ENTRY") {
$error = '71,85,86';
$error_array = get_error_msg($error);
$values_array = array($error_array);
echo JSON_ENCODE($values_array);
}
if ($_REQUEST["option"] == "RESET_FORM") {
$str = '20,138,139';
$URSRC_errmsg = get_error_msg($str);
echo JSON_ENCODE($URSRC_errmsg);
}
}
$select = $con->query('SELECT @SUCCESS_FLAG');
$result = $select->fetch_assoc();
$flag = $result['@SUCCESS_FLAG'];
echo json_encode($flag);
}
//FUNTION FOR INITIAL LOAD
if ($_REQUEST['Option'] == "initial_data") {
$TH_active_emp = get_active_emp_id();
$TH_active_empname = array();
$TH_query = mysqli_query($con, "SELECT * from VW_TS_PAYSLIP_ALL_ACTIVE_EMPLOYEE_DETAILS where URC_DATA!='SUPER ADMIN' ORDER BY EMPLOYEE_NAME");
while ($row = mysqli_fetch_array($TH_query)) {
$TH_active_empname[] = $row["EMPLOYEE_NAME"];
}
$error = '1,2,3,4,17,7';
$error_array = get_error_msg($error);
$paymentmode = array();
$TH_query = mysqli_query($con, "SELECT EPM_PAYMENT_MODE FROM EMPLOYEE_PAYMENT_MODE");
while ($row = mysqli_fetch_array($TH_query)) {
$paymentmode[] = $row["EPM_PAYMENT_MODE"];
}
$Earning_labels = array();
$TH_query = mysqli_query($con, "SELECT EEL_EARNING_LABELS FROM EMPLOYEE_PAYMENT_EARNING_LABELS ORDER BY EEL_EARNING_LABELS ASC");
while ($row = mysqli_fetch_array($TH_query)) {
$Earning_labels[] = $row["EEL_EARNING_LABELS"];
}
$Dedution = array();
$TH_query = mysqli_query($con, "SELECT EPDL_DEDUCTION_LABELS FROM EMPLOYEE_PAYMENT_DEDUCTION_LABELS");
while ($row = mysqli_fetch_array($TH_query)) {
$Dedution[] = $row["EPDL_DEDUCTION_LABELS"];
}
if($_REQUEST['option']=='COMMON_DATA')
{
//FILE NAME
$filename=mysqli_query($con,"SELECT ULD_DOC_FILE_NAME FROM LMC_USER_LOGIN_DETAILS ORDER BY ULD_DOC_FILE_NAME ASC");
$attachedfilename=array();
$final_filearry=array();
while($row=mysqli_fetch_array($filename)){
$attachedfilename=array();
$attachedfilename=explode('/',$row["ULD_DOC_FILE_NAME"]);
for($i=0;$i<count($attachedfilename);$i++){
$final_filearry[]=$attachedfilename[$i];
}
$attachedfileid=$row['ULD_ID'];
}
$errormsg=get_error_msg('37,40,41,42,46,48,56,83,133,139,141,142,146');
$select_role=mysqli_query($con,"select URC_DATA from VW_TS_ALL_ACTIVE_EMPLOYEE_DETAILS where ULD_USERNAME='******'");
if($row=mysqli_fetch_array($select_role)){
$rolename=$row["URC_DATA"];
}
$select_name=mysqli_query($con,"SELECT ULD_ID,ULD_WORKER_NAME FROM LMC_USER_LOGIN_DETAILS ORDER BY ULD_WORKER_NAME ASC");
while($row=mysqli_fetch_array($select_name)){
$empname[]=array($row["ULD_ID"],$row["ULD_WORKER_NAME"]);
}
$rcname_result=mysqli_query($con,"SELECT * FROM LMC_ROLE_CREATION ORDER BY RC_NAME");
while($row=mysqli_fetch_array($rcname_result)){
$rcname_array[]=array($row["RC_NAME"],$row["RC_ID"]);
}
$final_values=array($final_filearry,$errormsg,$rolename,$empname,$rcname_array);
echo json_encode($final_values);
$attachedfilename = array();
$attachedfilename = explode('/', $row["RAD_DOC_FILE_NAME"]);
for ($i = 0; $i < count($attachedfilename); $i++) {
$final_filearry[] = $attachedfilename[$i];
}
}
//CATEGORY
$category = mysqli_query($con, "select RDC_ID,RDC_CATEGORY from LMC_REPORT_DOCUMENT_CATEGORY ORDER BY RDC_CATEGORY ASC");
while ($row = mysqli_fetch_array($category)) {
$attachcategory[] = array($row["RDC_CATEGORY"], $row['RDC_ID']);
}
$select_role = mysqli_query($con, "select URC_DATA from VW_TS_ALL_ACTIVE_EMPLOYEE_DETAILS where ULD_USERNAME='******'");
if ($row = mysqli_fetch_array($select_role)) {
$rolename = $row["URC_DATA"];
}
$erromsg = get_error_msg('83,133,141,142,146');
$values = array($final_filearry, $attachcategory, $erromsg, $rolename);
echo json_encode($values);
} elseif ($_REQUEST['option'] == 'search_data') {
$filename = $_REQUEST['filename'];
$startdate = $_REQUEST['startdate'];
$enddate = $_REQUEST['enddate'];
$category = $_REQUEST['category'];
if ($startdate != '') {
$sdate = date('Y-m-d', strtotime($startdate));
} else {
$sdate = '';
}
if ($enddate != '') {
$edate = date('Y-m-d', strtotime($enddate));
} else {
$address = $_POST['CC_tb_address'];
$projectname = $_POST['CC_tb_pname'];
$time = $_POST['CC_tb_ctime'];
$comments = $_POST['CC_tb_cname'];
$checked = $_POST['EMP_ID'];
$query = "select ULD_ID FROM USER_LOGIN_DETAILS WHERE ULD_LOGINID ='{$USERSTAMP}'";
$result = mysqli_query($con, $query);
while ($row = mysqli_fetch_array($result)) {
$rep_getuld_id = $row["ULD_ID"];
}
$query = "SELECT EMP_ID FROM EMPLOYEE_DETAILS WHERE ULD_ID=(SELECT ULD_ID FROM USER_LOGIN_DETAILS WHERE ULD_LOGINID='{$USERSTAMP}')";
$result = mysqli_query($con, $query);
while ($row = mysqli_fetch_array($result)) {
$rep_getuld_id = $row["EMP_ID"];
}
// echo("CALL SP_CLIENT_CONTACT_DETAILS_INSERT('1',NULL,'$date','$clientname','$mailid','$contactno','$address','$projectname','$time','$comments','$checked','$USERSTAMP',@FLAG)");exit;
$result = $con->query("CALL SP_CLIENT_CONTACT_DETAILS_INSERT('1',NULL,'{$date}','{$clientname}','{$mailid}','{$contactno}','{$address}','{$projectname}','{$time}','{$comments}','{$checked}','{$USERSTAMP}',@FLAG)");
if (!$result) {
die("CALL failed: (" . $con->errno . ") " . $con->error);
}
$select = $con->query('SELECT @flag');
$result = $select->fetch_assoc();
$flag = $result['@flag'];
echo $flag;
}
if ($_REQUEST['option'] == 'error') {
$CC_error = get_error_msg('3', '7');
$final_array = array($CC_error);
echo json_encode($final_array);
}
}
<?php
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_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)) {
error_reporting(0);
include "../LMC_LIB/CONNECTION.php";
include "../LMC_LIB/GET_USERSTAMP.php";
include "../LMC_LIB/COMMON.php";
require_once '../mpdf571/mpdf571/mpdf.php';
require_once "../PHPMailer/class.phpmailer.php";
require_once "../PHPMailer/class.smtp.php";
date_default_timezone_set('Asia/Singapore');
if ($_REQUEST['option'] == 'COMMON_DATA') {
//EMPLOYEE NAME
$empname = mysqli_query($con, "SELECT ARD_ID,ARD_NAME FROM LMC_ACCIDENT_REPORT_DETAILS ORDER BY ARD_NAME ASC ");
while ($row = mysqli_fetch_array($empname)) {
$employeename[] = array($row["ARD_NAME"], $row['ARD_ID']);
}
//ERRPOR MESSAGE
$errormsg = get_error_msg('4,6,16,17,143');
$values = array($employeename, $errormsg);
echo JSON_encode($values);
} elseif ($_REQUEST['option'] == 'FETCH_DATA') {
$emp = $_REQUEST['emp'];
$fromdate = date('Y-m-d', strtotime($_REQUEST['fromdate']));
$todate = date('Y-m-d', strtotime($_REQUEST['todate']));
//EMPLOYEE DETAILS
$empdetails = mysqli_query($con, "SELECT ARD.ARD_ID,ARD.ARD_TIME,ARD.ARD_NAME,DATE_FORMAT(ARD.ARD_DATE,'%d-%m-%Y') AS ARD_DATE,ARD.ARD_PLACE,ARD.ARD_TYPE_OF_INJURY,ARD.ARD_NATURE_OF_INJURY,ARD.ARD_LOCATION,ARD.ARD_DESCRIPTION,ULD.ULD_USERNAME,DATE_FORMAT(CONVERT_TZ(ARD.ARD_TIMESTAMP,'+00:00','+08:00'),'%d-%m-%Y %T') AS ARD_TIMESTAMP,ARD.ARD_INJURED_PART,ARD.ARD_MACHINERY_TYPE,ARD.ARD_LM_NO,ARD.ARD_OPERATOR_NAME,ARD.ARD_DESCRIPTION,ARD.ARD_AGE,ARD.ARD_ADDRESS,ARD.ARD_NRIC_NO,ARD.ARD_FIN_NO,ARD.ARD_WORK_PERMIT_NO,ARD.ARD_PASSPORT_NO,ARD.ARD_NATIONALITY,ARD.ARD_SEX,DATE_FORMAT(ARD.ARD_DOB,'%d-%m-%Y') AS ARD_DOB,ARD.ARD_MARTIAL_STATUS,ARD.ARD_DESIGNATION,ARD.ARD_LENGTH_OF_SERVICE,ARD.ARD_WORK_COMMENCEMENT FROM LMC_ACCIDENT_REPORT_DETAILS ARD,LMC_USER_LOGIN_DETAILS ULD WHERE ARD.ULD_ID=ULD.ULD_ID AND ARD.ARD_DATE BETWEEN '{$fromdate}' AND '{$todate}' ORDER BY ARD_DATE");
while ($row = mysqli_fetch_array($empdetails)) {
$employeedetails[] = array($row['ARD_NAME'], $row["ARD_DATE"], $row['ARD_PLACE'], $row['ARD_TYPE_OF_INJURY'], $row['ARD_NATURE_OF_INJURY'], $row['ARD_LOCATION'], $row['ARD_DESCRIPTION'], $row['ULD_USERNAME'], $row['ARD_TIMESTAMP'], $row['ARD_ID'], $row['ARD_INJURED_PART'], $row['ARD_TIME'], $row['ARD_MACHINERY_TYPE'], $row['ARD_LM_NO'], $row['ARD_OPERATOR_NAME'], $row['ARD_DESCRIPTION'], $row['ARD_AGE'], $row['ARD_ADDRESS'], $row['ARD_NRIC_NO'], $row['ARD_FIN_NO'], $row['ARD_WORK_PERMIT_NO'], $row['ARD_PASSPORT_NO'], $row['ARD_NATIONALITY'], $row['ARD_SEX'], $row['ARD_DOB'], $row['ARD_MARTIAL_STATUS'], $row['ARD_DESIGNATION'], $row['ARD_LENGTH_OF_SERVICE'], $row['ARD_WORK_COMMENCEMENT']);
}
$values = array($employeedetails);
echo JSON_encode($values);
} elseif ($_REQUEST['option'] == 'UPDATE_SEARCH') {
$trdid = $_REQUEST['trdid'];
protected function respons($code, $data = "")
{
$msg = get_error_msg($code);
$this->responFunc(array("status" => $code, "msg" => $msg, "data" => $data));
}
<?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'];
include "CONNECTION.php";
include "COMMON.php";
date_default_timezone_set('Asia/Singapore');
$dir=dirname(__FILE__).DIRECTORY_SEPARATOR;
$activeempname=mysqli_query($con,"SELECT ULD_ID FROM LMC_USER_LOGIN_DETAILS WHERE ULD_USERNAME='******'");
if($row=mysqli_fetch_array($activeempname))
{
$activeemp=$row["ULD_ID"];
}
if($_REQUEST['option']=='COMMON_DATA')
{
$rcname_result=mysqli_query($con,"SELECT * FROM LMC_ROLE_CREATION WHERE RC_NAME!='SUPER ADMIN' ORDER BY RC_NAME");
while($row=mysqli_fetch_array($rcname_result)){
$rcname_array[]=array($row["RC_NAME"],$row["RC_ID"]);
}
$errormsg=get_error_msg('37,40,42,45,48,95,133,139,141,142,146');
$values=array($rcname_array,$errormsg);
echo json_encode($values);
}
if($_REQUEST['option']=='logincheck'){
$loginid=$_REQUEST['loginname'];
$existquery=mysqli_query($con,"SELECT * FROM LMC_USER_LOGIN_DETAILS WHERE ULD_USERNAME='******'");
$row=mysqli_num_rows($existquery);
echo $row;
}
if($_REQUEST['option']=='emailcheck'){
$emilid=$_REQUEST['emailid'];
$existmailquery=mysqli_query($con,"SELECT * FROM LMC_USER_LOGIN_DETAILS WHERE ULD_EMAIL_ID='$emilid'");
$row=mysqli_num_rows($existmailquery);
echo $row;
}
<?php
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
$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)) {
}
if($_REQUEST['option']=='EP_SRC_UPD_DEL_searchoption')
{
$EP_SRC_UPD_DEL_emaillistprofile="SELECT EP.EP_ID,EP.EP_EMAIL_DOMAIN,EL.EL_ID,EP.EP_NON_IP_FLAG FROM LMC_EMAIL_PROFILE EP,LMC_EMAIL_LIST EL WHERE EL.EP_ID=EP.EP_ID ORDER BY EP_EMAIL_DOMAIN ASC";
$EP_SRC_UPD_DEL_emailresult=mysqli_query($con,$EP_SRC_UPD_DEL_emaillistprofile);
while($row=mysqli_fetch_array($EP_SRC_UPD_DEL_emailresult))
{
$EP_SRC_UPD_DEL_profilename_id=$row['EP_ID'];
$EP_SRC_UPD_DEL_profilename_data=$row['EP_EMAIL_DOMAIN'];
$EP_SRC_UPD_DEL_listname_id=$row['EL_ID'];
$EP_SRC_UPD_DEL_profilename_flag=$row['EP_NON_IP_FLAG'];
$EP_SRC_UPD_DEL_nameid_object=array("EP_SRC_UPD_DEL_profilenames_id"=>$EP_SRC_UPD_DEL_profilename_id,"EP_SRC_UPD_DEL_profilenames_data"=>$EP_SRC_UPD_DEL_profilename_data,"EP_SRC_UPD_DEL_listnames_id"=>$EP_SRC_UPD_DEL_listname_id,"EP_SRC_UPD_DEL_profilenames_flag"=>$EP_SRC_UPD_DEL_profilename_flag);
$EP_SRC_UPD_DEL_email_array[]=$EP_SRC_UPD_DEL_nameid_object;
}
$EP_SRC_UPD_DEL_errorMsg_array=[];
$EP_SRC_UPD_DEL_errorMsg_array=get_error_msg('8,17,40,159,160,161,162,163,164,165');
$EP_SRC_UPD_DEL_email_arrayresult=array("EP_SRC_UPD_DEL_profilelistdataid"=>$EP_SRC_UPD_DEL_email_array,"EP_SRC_UPD_DEL_errormsg"=>$EP_SRC_UPD_DEL_errorMsg_array);
echo json_encode($EP_SRC_UPD_DEL_email_arrayresult);
}
if($_REQUEST['option']=='EP_SRC_UPD_DEL_srch')
{
$EP_SRC_UPD_DEL_email_list=[];
$EP_SRC_UPD_DEL_emailstmt_array=[];
$EP_SRC_UPD_DEL_email_list=[];
$EP_SRC_UPD_DEL_id=$_REQUEST['EP_SRC_UPD_DEL_id'];
$EP_SRC_UPD_DEL_query="SELECT DATE_FORMAT(EL_TIMESTAMP,'%d-%m-%Y %T') AS TIMESTAMP,EL_ID,EL_EMAIL_ID,ULD.ULD_USERNAME,EP_NON_IP_FLAG FROM LMC_EMAIL_LIST EL,LMC_EMAIL_PROFILE EP ,LMC_USER_LOGIN_DETAILS ULD WHERE EL.EP_ID='$EP_SRC_UPD_DEL_id' AND EL.EP_ID=EP.EP_ID AND EL.ULD_ID=ULD.ULD_ID ORDER BY EL.EL_EMAIL_ID";
$EP_SRC_UPD_DEL_rs=mysqli_query($con,$EP_SRC_UPD_DEL_query);
while($row=mysqli_fetch_array($EP_SRC_UPD_DEL_rs))
{
$EP_SRC_UPD_DEL_emailid=$row["EL_EMAIL_ID"];
$EP_SRC_UPD_DEL_userstamp=$row["ULD_USERNAME"];
}
$cp = CusProduct::find($cp_id);
if ($_SERVER["REQUEST_METHOD"] == "GET") {
$_POST["attr"]["quantity"] = $cp->get_quantity();
foreach ($cp->get_custom() as $type => $value) {
$_POST["attr"][$type] = $value;
}
}
if ($_SERVER["REQUEST_METHOD"] == "POST") {
$_POST["attr"]["image"] = intval($_POST["attr"]["image"]);
//handle add product request
if ($_POST["attr"]["image"] <= 0) {
$_POST["attr"]["image"] = Image::process_image($_FILES['upload'], $user);
}
if ($_POST["attr"]["image"] <= 0) {
set_msg("Image Error: " . get_error_msg($_POST["attr"]["image"]));
} else {
$result = modify_product($user, $cp, $_POST["attr"]);
if ($result) {
header("Location: cart.php");
exit;
}
}
}
$cusproduct = $cp;
include 'header.php';
include 'menu.php';
?>
<div id="content">
<h3>Customize the <?php
echo $cusproduct->get_name();
