public static function FORMAT($S, $R, $P) { $I = array(); if ($P === false) { $I[] = STR_REPLACE("/", "-", $R) . " 00:00:00"; $I[] = STR_REPLACE("/", "-", $R) . " 24:59:59"; $SET = 'HOUR'; } else { $R = explode(" - ", $R); $I[] = STR_REPLACE("/", "-", $R[0]); $I[] = STR_REPLACE("/", "-", $R[1]); $SET = 'DAY'; } $I[] = $S['s_id']; $Q = "SELECT MIN(t_checkout_created) AS `time`, AVG(t_checkout_price) AS `cost` FROM core_tickets_processed WHERE t_checkout_created >= ? AND t_checkout_created <= ? AND t_store = ? GROUP BY"; $CA = MYSQL::QUERY($Q . " {$SET}(t_checkout_created) ORDER BY t_checkout_created ASC", $I); $CO = MYSQL::QUERY($Q . " t_checkout_created ORDER BY t_checkout_created ASC", $I); $STRING = array(); $STRING[] = array('name' => 'Average Charge', 'data' => ''); $STRING[] = array('name' => 'Checkout Charges', 'data' => ''); foreach ($CA as $C) { $T = Date_UTC($C['time']); $STRING[0]['data'][] .= $T[0] . "," . $T[1] . "," . $T[2] . "," . $T[3] . "," . $C['cost']; } foreach ($CO as $C) { $T = Date_UTC($C['time']); $STRING[1]['data'][] .= $T[0] . "," . $T[1] . "," . $T[2] . "," . $T[3] . "," . $T[4] . "," . $C['cost']; } echo JSON_ENCODE($STRING); }
function showData($data, $con) { $date = $con->real_escape_string($data['startdate']); $startdate = $_REQUEST['startdate']; $startdate = date("Y-m-d", strtotime($startdate)); $enddate = $_REQUEST['enddate']; // $date = $con->real_escape_string($data['enddate']); $enddate = date("Y-m-d", strtotime($enddate)); $AWSU_values = array(); $sql = "SELECT AW.AWRD_ID,AW.AWRD_REPORT,AW.AWRD_DATE,DATE_FORMAT(CONVERT_TZ(AW.AWRD_TIMESTAMP,'+00:00','+05:30'), '%d-%m-%Y %T') AS AWRD_TIMESTAMP,ULD.ULD_LOGINID as ULD_USERSTAMP FROM ADMIN_WEEKLY_REPORT_DETAILS AW JOIN USER_LOGIN_DETAILS ULD on AW.ULD_ID=ULD.ULD_ID where AW.AWRD_DATE BETWEEN '{$startdate}' AND '{$enddate}' ORDER BY AWRD_DATE DESC"; $projectfetch = mysqli_query($con, $sql); $AWSU_values = false; while ($row = mysqli_fetch_array($projectfetch)) { $awsu_report = $row['AWRD_REPORT']; if ($awsu_report != null) { $awsu_rprt = ''; $body_msg = explode("\n", $awsu_report); $length = count($body_msg); for ($i = 0; $i < $length; $i++) { $awsu_rprt .= $body_msg[$i] . '<br>'; } } else { $awsu_rprt = null; } $awsu_id = $row['AWRD_ID']; $awsu_date = $row['AWRD_DATE']; $awsu_userstamp = $row["ULD_USERSTAMP"]; $awsu_timestamp = $row["AWRD_TIMESTAMP"]; $AWSU_report_values = array('report' => $awsu_rprt, 'report1' => $awsu_report, 'id' => $awsu_id, 'date' => $awsu_date, 'userstamp' => $awsu_userstamp, 'timestamp' => $awsu_timestamp); $AWSU_values[] = $AWSU_report_values; } echo JSON_ENCODE($AWSU_values); }
public static function FORMAT($S, $R, $P) { $I = array($S['s_id']); if ($P === false) { $TI = "AND d_date = ? LIMIT 1"; $I[] = str_replace("/", "-", $R); } else { $R = explode(" - ", $R); $TI = "AND d_date >= ? AND d_date <= ? ORDER BY d_date ASC"; $I[] = str_replace("/", "-", $R[0]); $I[] = str_replace("/", "-", $R[1]); } $CT = MYSQL::QUERY("SELECT * FROM core_stores_daily_checkouts WHERE s_id = ? {$TI}", $I); $STRING = array(array('name' => 'Sales', 'data' => '')); if (!$P === false) { foreach ($CT as $CL) { $T = Date_UTC($CL['d_date']); $Total = $CL['d_gross_nontaxable'] + $CL['d_gross_taxable']; $STRING[0]['data'][] .= $T[0] . "," . $T[1] . "," . $T[2] . "," . $Total; } } else { $T = Date_UTC($CT['d_date']); $Total = $CT['d_gross_nontaxable'] + $CT['d_gross_taxable']; $STRING[0]['data'][] .= $T[0] . "," . $T[1] . "," . $T[2] . "," . $Total; } if ($P === false) { $STRING[0]['type'] = 'column'; } echo JSON_ENCODE($STRING); }
function productsUpdateAction(Request $request, Application $app) { $em = $app['orm.em']; $categoryRepository = $em->getRepository('Category'); $categories = $categoryRepository->findAll(); $categoriesPresentation = array(); foreach ($categories as $category) { $keys = $category->getItems()->getKeys(); array_push($categoriesPresentation, array('id' => $category->getId(), 'title' => $category->getTitle(), 'summary' => $category->getSummary(), 'photo' => $category->getItems()->get(array_rand($keys))->getPhoto())); } return JSON_ENCODE($categoriesPresentation); }
public static function FORMAT($S, $R, $P) { $I = array($S['s_id']); if ($P === false) { $TI = "AND d_date = ? LIMIT 1"; $I[] = str_replace("/", "-", $R); } else { $R = explode(" - ", $R); $TI = "AND d_date >= ? AND d_date <= ? ORDER BY d_date ASC"; $I[] = str_replace("/", "-", $R[0]); $I[] = str_replace("/", "-", $R[1]); } $CT = MYSQL::QUERY("SELECT * FROM core_stores_daily_checkouts WHERE s_id = ? {$TI}", $I); $STRING = array(array('name' => 'Cash', 'data' => ''), array('name' => 'Check', 'data' => ''), array('name' => 'American Express', 'data' => ''), array('name' => 'Discover', 'data' => ''), array('name' => 'Master Card', 'data' => ''), array('name' => 'Visa', 'data' => ''), array('name' => 'Debit', 'data' => '')); if (!$P === false) { foreach ($CT as $CL) { $T = Date_UTC($CL['d_date']); $STRING[0]['data'][] .= $T[0] . "," . $T[1] . "," . $T[2] . "," . $CL['d_cash']; $STRING[1]['data'][] .= $T[0] . "," . $T[1] . "," . $T[2] . "," . $CL['d_check']; $STRING[2]['data'][] .= $T[0] . "," . $T[1] . "," . $T[2] . "," . $CL['d_amex']; $STRING[3]['data'][] .= $T[0] . "," . $T[1] . "," . $T[2] . "," . $CL['d_discover']; $STRING[4]['data'][] .= $T[0] . "," . $T[1] . "," . $T[2] . "," . $CL['d_master']; $STRING[5]['data'][] .= $T[0] . "," . $T[1] . "," . $T[2] . "," . $CL['d_visa']; $STRING[6]['data'][] .= $T[0] . "," . $T[1] . "," . $T[2] . "," . $CL['d_debit']; } } else { $T = Date_UTC($CT['d_date']); $STRING[0]['data'][] .= $T[0] . "," . $T[1] . "," . $T[2] . "," . $CT['d_cash']; $STRING[1]['data'][] .= $T[0] . "," . $T[1] . "," . $T[2] . "," . $CT['d_check']; $STRING[2]['data'][] .= $T[0] . "," . $T[1] . "," . $T[2] . "," . $CT['d_amex']; $STRING[3]['data'][] .= $T[0] . "," . $T[1] . "," . $T[2] . "," . $CT['d_discover']; $STRING[4]['data'][] .= $T[0] . "," . $T[1] . "," . $T[2] . "," . $CT['d_master']; $STRING[5]['data'][] .= $T[0] . "," . $T[1] . "," . $T[2] . "," . $CT['d_visa']; $STRING[6]['data'][] .= $T[0] . "," . $T[1] . "," . $T[2] . "," . $CT['d_debit']; } if ($P === false) { $STRING[0]['type'] = 'column'; $STRING[1]['type'] = 'column'; $STRING[2]['type'] = 'column'; $STRING[3]['type'] = 'column'; $STRING[4]['type'] = 'column'; $STRING[5]['type'] = 'column'; $STRING[6]['type'] = 'column'; } echo JSON_ENCODE($STRING); }
$menunameradiovalues = $_GET['radio_value']; $URSRC_basic_roleval=str_replace("_"," ",$menunameradiovalues); $URSRC_getmenu_folder_values=URSRC_getmenu_folder($URSRC_basic_roleval); echo JSON_ENCODE($URSRC_getmenu_folder_values); } //FUNCTION to get basic menus if($_REQUEST['option']=="URSRC_tree_view_basic"){ $menunameradiovalues = $_GET['radio_value']; $URSRC_basic_roleval=str_replace("_"," ",$menunameradiovalues); $URSRC_getmenu_folder_values=URSRC_getmenubasic_folder1(); echo JSON_ENCODE($URSRC_getmenu_folder_values); } //FUNCTION TO LOAD INITIAL VALUES ROLE LST bX if($_REQUEST['option']=="ACCESS_RIGHTS_SEARCH_UPDATE_BASICROLE"){ $URSRC_role_array=get_roles(); echo JSON_ENCODE($URSRC_role_array); } } // ////function URSRC_unshare_document($loggin,$fileId){ //// //// global $con,$ClientId,$ClientSecret,$RedirectUri,$DriveScopes,$CalenderScopes,$Refresh_Token; //// $drive = new Google_Client(); //// $drive->setClientId($ClientId); //// $drive->setClientSecret($ClientSecret); //// $drive->setRedirectUri($RedirectUri); //// $drive->setScopes(array($DriveScopes,$CalenderScopes)); //// $drive->setAccessType('online'); //// $authUrl = $drive->createAuthUrl(); //// $refresh_token= $Refresh_Token; //// $drive->refreshToken($refresh_token);
$admin_searchmin_date_value = $row["AWRD_DATE"]; // $min_date = date('d-m-Y',strtotime($admin_searchmin_date_value)); $min_date = date('Y-m-d', strtotime($admin_searchmin_date_value)); } $admin_weekly_maxdate = mysqli_query($con, "SELECT MAX(AWRD_DATE) as AWRD_DATE FROM ADMIN_WEEKLY_REPORT_DETAILS"); while ($row = mysqli_fetch_array($admin_weekly_maxdate)) { $admin_searchmin_date_value = $row["AWRD_DATE"]; // $max_date = date('d-m-Y',strtotime($admin_searchmin_date_value)); $max_date = date('Y-m-d', strtotime($admin_searchmin_date_value)); date_default_timezone_set('Asia/Kolkata'); $a_date = $admin_searchmin_date_value; $date = new DateTime($a_date); $date->modify('last day of this month'); $date = $date->format('d'); } $value_array = array($errormsg_array, $min_date, $max_date, $date); echo JSON_ENCODE($value_array); } if ($_REQUEST['option'] == "ADMIN WEEKLY REPORT ENTRY") { $str = '3,7,84'; $errormsg_array = get_error_msg($str); $comp_startdate = get_company_start_date(); $value_array = array($errormsg_array, $comp_startdate); echo JSON_ENCODE($value_array); } if ($_REQUEST["option"] == "PUBLIC_HOLIDAY") { $error = '71,93,94,96'; $error_array = get_error_msg($error); $values_array = array($error_array); echo JSON_ENCODE($values_array); }
public static function FORMAT($S, $R, $P) { $I = array($S['s_id']); if ($P === false) { $TI = "AND d_date = ? LIMIT 1"; $I[] = str_replace("/", "-", $R); } else { $R = explode(" - ", $R); $TI = "AND d_date >= ? AND d_date <= ? ORDER BY d_date ASC"; $I[] = str_replace("/", "-", $R[0]); $I[] = str_replace("/", "-", $R[1]); } $CT = MYSQL::QUERY("SELECT * FROM core_stores_daily_tickets WHERE s_id = ? {$TI}", $I); $AE = MYSQL::QUERY("SELECT * FROM core_stores_daily_accepts WHERE s_id = ? {$TI}", $I); $WT = MYSQL::QUERY("SELECT * FROM core_stores_daily_walkouts WHERE s_id = ? {$TI}", $I); $CD = MYSQL::QUERY("SELECT * FROM core_stores_daily_checkouts WHERE s_id = ? {$TI}", $I); $RD = MYSQL::QUERY("SELECT * FROM core_stores_daily_repairs WHERE s_id = ? {$TI}", $I); $CC = MYSQL::QUERY("SELECT * FROM core_stores_daily_customers WHERE s_id = ? {$TI}", $I); $STRING = array(array('name' => 'Created Tickets', 'data' => ''), array('name' => 'Accepted Estimates', 'data' => ''), array('name' => 'Walked Out Tickets', 'data' => ''), array('name' => 'Checked Out Tickets', 'data' => ''), array('name' => 'Repaired Devices', 'data' => ''), array('name' => 'Customer Accounts Created', 'data' => '')); if (!$P === false) { foreach ($CT as $CL) { $T = Date_UTC($CL['d_date']); $STRING[0]['data'][] .= $T[0] . "," . $T[1] . "," . $T[2] . "," . $CL['d_key']; } foreach ($AE as $A) { $T = Date_UTC($A['d_date']); $STRING[1]['data'][] .= $T[0] . "," . $T[1] . "," . $T[2] . "," . $A['d_key']; } foreach ($WT as $W) { $T = Date_UTC($W['d_date']); $STRING[2]['data'][] .= $T[0] . "," . $T[1] . "," . $T[2] . "," . $W['d_key']; } foreach ($CD as $C) { $T = Date_UTC($C['d_date']); $STRING[3]['data'][] .= $T[0] . "," . $T[1] . "," . $T[2] . "," . $C['d_key']; } foreach ($RD as $R) { $T = Date_UTC($R['d_date']); $STRING[4]['data'][] .= $T[0] . "," . $T[1] . "," . $T[2] . "," . $R['d_key']; } foreach ($CC as $C) { $T = Date_UTC($C['d_date']); $STRING[5]['data'][] .= $T[0] . "," . $T[1] . "," . $T[2] . "," . $C['d_key']; } } else { $T = Date_UTC($CT['d_date']); $STRING[0]['data'][] .= $T[0] . "," . $T[1] . "," . $T[2] . "," . $CT['d_key']; $STRING[1]['data'][] .= $T[0] . "," . $T[1] . "," . $T[2] . "," . $AE['d_key']; $STRING[2]['data'][] .= $T[0] . "," . $T[1] . "," . $T[2] . "," . $WT['d_key']; $STRING[3]['data'][] .= $T[0] . "," . $T[1] . "," . $T[2] . "," . $CD['d_key']; $STRING[4]['data'][] .= $T[0] . "," . $T[1] . "," . $T[2] . "," . $RD['d_key']; $STRING[5]['data'][] .= $T[0] . "," . $T[1] . "," . $T[2] . "," . $CC['d_key']; } if ($P === false) { $STRING[0]['type'] = 'column'; $STRING[1]['type'] = 'column'; $STRING[2]['type'] = 'column'; $STRING[3]['type'] = 'column'; $STRING[4]['type'] = 'column'; $STRING[5]['type'] = 'column'; } echo JSON_ENCODE($STRING); }
function getImages() { if (isset($_POST["ObjectId"])) { $images = Resources::getImage($_POST["ObjectId"]); for ($i = 0; $i < count($images); $i++) { $images[$i]["ImageBlob"] = base64_encode($images[$i]["ImageBlob"]); } $object = new stdClass(); $object->Images = $images; echo JSON_ENCODE($this->utf8ize($object)); } }
protected function actionList() { if (count($this->routes) > 0) { $id = array_shift($this->routes); $file = $this->dir . $id . self::jsonExtension; if (is_file($file)) { return file_get_contents($file); } return notFound(); } $page = (int) $this->get(self::getPage, 1); if ($page == 0) { $page = 1; } $start = ($page - 1) * self::pageSize; $end = $start + self::pageSize; $items = []; $c = 0; $this->readDirectory(function ($file) use(&$c, &$items, $start, $end) { if ($c >= $start && $c < $end) { $items[] = json_decode(file_get_contents($this->dir . $file), true); } $c++; }); header('Content-type: text/json'); return JSON_ENCODE(['items' => $items, '_meta' => ['page' => $page, 'total' => $c, 'pages' => ceil($c / self::pageSize)]]); }
} } else { $checkintime = null; } $checkouttime = mysqli_query($con, "select ECIOD_CHECK_OUT_TIME from EMPLOYEE_CHECK_IN_OUT_DETAILS where ECIOD_DATE='{$date}' and ULD_ID='{$ADM_userstamp_id}'"); $checkoutrow = mysqli_num_rows($checkouttime); if ($checkoutrow > 0) { if ($checkoutrow = mysqli_fetch_array($checkouttime)) { $check_out_time = $checkoutrow["ECIOD_CHECK_OUT_TIME"]; } } else { $check_out_time = null; } $allvalues = array($final_values, $checkintime, $err_msg, $date, $check_out_time, $login_id_role, $ip_check_flag); // mysqli_close($con); echo JSON_ENCODE($allvalues); } catch (mysqli_sql_exception $e) { echo $e->getMessage(); } } else { if ($_REQUEST['option'] == 'CLOCK') { global $con; $check_in_out_location = $_REQUEST['location']; $btn_value = $_REQUEST['btn_value']; $date = date('Y-m-d'); $checkintime = date("G:i:s", time()); $checkouttime = date("G:i:s", time()); $uld_id = mysqli_query($con, "select ULD_ID from USER_LOGIN_DETAILS where ULD_LOGINID='{$USERSTAMP}'"); while ($row = mysqli_fetch_array($uld_id)) { $ure_uld_id = $row["ULD_ID"]; }
} 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)"); if(!$result) die("CALL failed: (" . $con->errno . ") " . $con->error); $select = $con->query('SELECT @TEMP_UARD_TICKLER_HISTORY'); $result = $select->fetch_assoc(); $temp_tickler_history= $result['@TEMP_UARD_TICKLER_HISTORY']; $TH_values=array(); $sqlquery=mysqli_query($con,"SELECT EVENT_TYPE,TABLE_NAME,TH_OLD_VALUE,TH_NEW_VALUE,TH_USERSTAMP,DATE_FORMAT(CONVERT_TZ(TH_TIMESTAMP,'+00:00','+08:00'),'%d-%m-%Y %T') AS T_TIMESTAMP FROM $temp_tickler_history ORDER BY TH_TIMESTAMP DESC "); while($row=mysqli_fetch_array($sqlquery)){ $TH_eventtype=$row["EVENT_TYPE"]; $TH_tblename=$row["TABLE_NAME"]; $TH_oldvalue=$row['TH_OLD_VALUE']; $TH_oldvalue=htmlspecialchars($TH_oldvalue); $TH_newvalue=$row['TH_NEW_VALUE']; $TH_newvalue=htmlspecialchars($TH_newvalue); $TH_userstamp=$row['TH_USERSTAMP']; $TH_timestamp=$row['T_TIMESTAMP']; $TH_values[]=(object)['tptype'=>$TH_eventtype,'ttipdata'=>$TH_tblename,'oldvalue'=>$TH_oldvalue,'newvalue'=>$TH_newvalue,'userstamp'=>$TH_userstamp,'timestamp'=>$TH_timestamp]; } $drop_query="DROP TABLE $temp_tickler_history "; mysqli_query($con,$drop_query); echo JSON_ENCODE($TH_values); } ?>
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); }
if($_REQUEST['option']=="CLK_loginid_searchoption") { // $CLK_loginid=$_REQUEST['CLK_loginid']; $CLK_mnthyrval=$_REQUEST['CLK_monthyear']; // echo $CLK_mnthyrval; // $CLK_start_value = date('Y-m-d',strtotime($CLK_mnthyrval)); $final_start=date('Y-m-01', strtotime($CLK_mnthyrval)); // echo $final_start; $final_end=date('Y-m-t', strtotime($CLK_mnthyrval)); // echo $final_end; // echo "SELECT COUNT(*) AS CLOCK_OUTMISSED FROM EMPLOYEE_CHECK_IN_OUT_DETAILS WHERE ECIOD_DATE BETWEEN '$final_start' AND '$final_end' AND ECIOD_CHECK_OUT_LOCATION IS NULL AND ULD_ID='$CLK_loginid'"; $CLK_flextbl= mysqli_query($con,"SELECT DATE_FORMAT(ECIOD_DATE,'%d-%m-%Y') AS ECIOD_DATE FROM EMPLOYEE_CHECK_IN_OUT_DETAILS WHERE ECIOD_DATE BETWEEN '$final_start' AND '$final_end' AND ECIOD_FLAG='X' AND ULD_ID='$uld_id'"); $CLK_COUNT= mysqli_query($con,"SELECT COUNT(*) AS CLOCK_OUTMISSED FROM EMPLOYEE_CHECK_IN_OUT_DETAILS WHERE ECIOD_DATE BETWEEN '$final_start' AND '$final_end' AND ECIOD_FLAG='X' AND ULD_ID='$uld_id'"); $CLK_values=array(); $ET_count_values=array(); while($row=mysqli_fetch_array($CLK_flextbl)){ $CLK_count=$row["ECIOD_DATE"]; $final_values=(object) ['date'=>$CLK_count]; $CLK_values[]=$final_values; } while($row=mysqli_fetch_array($CLK_COUNT)){ $CLK_missedcount=$row["CLOCK_OUTMISSED"]; $final_values_count=(object) ['count'=>$CLK_missedcount]; $ET_count_values[]=$final_values_count; } $variable=array($CLK_values,$ET_count_values); echo JSON_ENCODE($variable); } }
// } $fromdate = date('Y-m-d', strtotime($fdate)); $todate = date('Y-m-d', strtotime($tdate)); $ure_date_array = array(); if ($ADM_uld_id != 'SELECT') { $sql = mysqli_query($con, "SELECT DISTINCT DATE_FORMAT(UARD_DATE,'%d-%m-%Y') AS UARD_DATE FROM USER_ADMIN_REPORT_DETAILS WHERE UARD_DATE BETWEEN '{$fromdate}' AND '{$todate}' AND ULD_ID={$ADM_uld_id} ORDER BY UARD_DATE"); while ($row = mysqli_fetch_array($sql)) { $ure_date_array[] = $row["UARD_DATE"]; } } else { $sql = mysqli_query($con, "SELECT DISTINCT DATE_FORMAT(UARD_DATE,'%d-%m-%Y') AS UARD_DATE FROM USER_ADMIN_REPORT_DETAILS WHERE UARD_DATE BETWEEN '{$fromdate}' AND '{$todate}' ORDER BY UARD_DATE"); while ($row = mysqli_fetch_array($sql)) { $ure_date_array[] = $row["UARD_DATE"]; } } echo JSON_ENCODE($ure_date_array); } if ($_REQUEST['option'] == 'ALLEMPDATE') { $mindate = mysqli_query($con, "SELECT MIN(UARD_DATE) as UARD_DATE FROM USER_ADMIN_REPORT_DETAILS ORDER BY UARD_DATE"); while ($row = mysqli_fetch_array($mindate)) { $allmindate = $row["UARD_DATE"]; } $allmindate = date('d-m-Y', strtotime($allmindate)); echo $allmindate; } if ($_REQUEST['option'] == 'PRESENT') { $emptyflag = 0; $rprtdate = $_REQUEST['reportdate']; $ure_uld_id = $_REQUEST['loginid']; $rprtdate = date('Y-m-d', strtotime($rprtdate)); $uld_id = mysqli_query($con, "select ULD_LOGINID from USER_LOGIN_DETAILS where ULD_ID='{$ure_uld_id}'");
*/ if ($_GET['mode'] == 'load') { //Load a file $send_data = array(); $j = 0; for ($i = 0; $i < count($formats); $i++) { if ($formats[$i] != 'deleted') { if ($formats[$i]['owner'] == unserialize($_COOKIE['MALSIG_LOGIN'])['username']) { $send_data[$j] = $formats[$i]; $send_data[$j]['id'] = $i; $j++; } } } //$data = file_GET_contents('../raw/files/' . $_POST['id'] . '.' . $formats[$_POST['id']]['format']); //Grab the file contents echo JSON_ENCODE($send_data); //Feed them back to the other file } else { if ($_GET['mode'] == 'new') { //Save a new image $number = count($formats); //New id if (isset($_FILES["file"])) { //Filter the file types , if you want. if ($_FILES["file"]["error"] > 0) { die("Error: " . $_FILES["file"]["error"]); } else { move_uploaded_file($_FILES["file"]["tmp_name"], $output_dir . $number . '.' . array_pop(explode('.', $_FILES["file"]["name"]))); //echo "Uploaded File :".$_FILES["file"]["name"]; $formats[$number] = array('title' => $_FILES["file"]["name"], 'owner' => unserialize($_COOKIE['MALSIG_LOGIN'])['username']); $serializeFormats = base64_encode(serialize($formats));
<br> <?php $cor = array('Amarelo', 'Azul', 'Verde'); foreach ($cor as $valor) { echo $valor . '<br>'; } foreach ($cor as $chave => $valor) { echo $chave . ' - ' . $valor . '<br>'; } ?> Uso de JSON <br> <?php $aAlunos = array(array('nome' => 'Marcos', 'notas' => array(8, 9, 7)), array('nome' => 'Maria', 'notas' => array(8, 10, 7))); $sJSON = JSON_ENCODE($aAlunos); echo $sJSON; echo "<pre>" . print_r($sJSON, true) . "</pre>"; //[{"nome":"Marcos","notas":[8,9,7]},{"nome":"Maria","notas":[8,10,7]}] ?> Decodificando o JSON <br> <?php $sJSON = '[{"nome":"Marcos","notas":[8,9,7]},{"nome":"Maria","notas":[8,10,7]}] '; //Usa o DECODE $aAlunos = JSON_DECODE($sJSON, true); foreach ($aAlunos as $valor) { echo $valor['nome'] . ':'; echo implode($valor['notas'], ',') . '<br>'; } ?>
$REP_values = array(); while ($row = mysqli_fetch_array($REP_flextbl)) { $check_in_time = $row["ECIOD_CHECK_IN_TIME"]; $check_in_location = $row["ECIOD_CHECK_IN_LOCATION"]; $check_out_time = $row["ECIOD_CHECK_OUT_TIME"]; $check_out_location = $row["ECIOD_CHECK_OUT_LOCATION"]; $check_in_date = $row["E_ECIOD_DATE"]; $final_values = array('check_in_date' => $check_in_date, 'check_in_time' => $check_in_time, 'check_in_location' => $check_in_location, 'check_out_time' => $check_out_time, 'check_out_location' => $check_out_location); $REP_values[] = $final_values; } echo JSON_ENCODE($REP_values); } //SET MIN ND MAX DATE FUNCTION FOR PROJECT NAME BY DATE RANGE if ($_REQUEST['option'] == "set_datemin_max") { $REP_loginid = $_REQUEST['REP_chk_loginid']; //SET MIN DATE $min_date = mysqli_query($con, "select MIN(ECIOD_DATE) AS ECIOD_DATE from EMPLOYEE_CHECK_IN_OUT_DETAILS WHERE ULD_ID='{$REP_loginid}'"); while ($row = mysqli_fetch_array($min_date)) { $mindate_array = $row["ECIOD_DATE"]; $min_date = $mindate_array; } //SET MAX DATE $REV_searchmax_date = mysqli_query($con, "select MAX(ECIOD_DATE) AS ECIOD_DATE from EMPLOYEE_CHECK_IN_OUT_DETAILS WHERE ULD_ID='{$REP_loginid}'"); while ($row = mysqli_fetch_array($REV_searchmax_date)) { $REV_searchmax_date_value = $row["ECIOD_DATE"]; $max_date = $REV_searchmax_date_value; } $minmax_date_values = array($min_date, $max_date); echo JSON_ENCODE($minmax_date_values); } }
require "../../../frame/engine.php"; ENGINE::START(); $USER = USER::VERIFY(0, TRUE); if (empty($_GET['sSearch'])) { $S = $_GET['string']; } else { $S = $_GET['sSearch']; } $iDS = $_GET['iDisplayStart']; $iDL = $_GET['iDisplayLength']; $iSC = $_GET['iSortCol_0']; $iSD = $_GET['sSortDir_0']; switch ($iSC) { case 0: $SS = 'ORDER BY c_name ' . $iSD; break; case 1: $SS = 'ORDER BY c_phone ' . $iSD; break; case 2: $SS = ''; break; } $iTotal = MYSQL::QUERY('SELECT COUNT(c_id) AS `COUNT` FROM core_customers WHERE c_name LIKE ? OR c_phone LIKE ?', array('%' . $S . '%', '%' . $S . '%')); $iQuery = MYSQL::QUERY("SELECT * FROM core_customers WHERE c_name LIKE ? OR c_phone LIKE ? {$SS} LIMIT {$iDS},{$iDL}", array('%' . $S . '%', '%' . $S . '%'), FALSE, TRUE); $OUTPUT = array('sEcho' => $_GET['sEcho'], 'iTotalRecords' => $iTotal[0]['COUNT'], 'iTotalDisplayRecords' => $iTotal[0]['COUNT'], 'aaData'); foreach ($iQuery as $C) { $OUTPUT['aaData'][] = array($C['c_name'], FORMAT::PHONE($C['c_phone']), '<button onClick="LoadCustomer(' . "'" . $C['c_id'] . "'" . ')">LOAD</button>'); } echo JSON_ENCODE($OUTPUT);
} //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"]; $ET_SRC_UPD_DEL_body=$row["ETD_EMAIL_BODY"]; $ET_SRC_UPD_DEL_userstamp=$row["ULD_LOGINID"]; $ET_SRC_UPD_DEL_timestamp=$row["TIMESTAMP"]; $ET_SRC_UPD_DEL_el_id=$row['ETD_ID']; $final_values=(object) ['id'=>$ET_SRC_UPD_DEL_el_id,'ET_SRC_UPD_DEL_subject' =>$ET_SRC_UPD_DEL_subject,'ET_SRC_UPD_DEL_body' =>$ET_SRC_UPD_DEL_body,'ET_SRC_UPD_DEL_userstamp'=>$ET_SRC_UPD_DEL_userstamp,'ET_SRC_UPD_DEL_timestamp'=>$ET_SRC_UPD_DEL_timestamp]; $ET_SRC_UPD_DEL_values[]=$final_values; } echo JSON_ENCODE($ET_SRC_UPD_DEL_values); } //UPDATE DATA FOR EMAIL TEMPLATE TABLE if($_REQUEST['option']=="EMAIL_TEMPLATE_UPDATE"){ $ET_SRC_UPD_DEL_el_id=$_POST['ET_SRC_UPD_DEL_rd_flxtbl']; $ET_SRC_UPD_DEL_subject=$_POST['ET_SRC_UPD_DEL_ta_updsubject']; $ET_SRC_UPD_DEL_subject= $con->real_escape_string($ET_SRC_UPD_DEL_subject); $ET_SRC_UPD_DEL_body=$_POST['ET_SRC_UPD_DEL_ta_updbody']; $ET_SRC_UPD_DEL_body= $con->real_escape_string($ET_SRC_UPD_DEL_body); $sql="UPDATE EMAIL_TEMPLATE_DETAILS SET ETD_EMAIL_SUBJECT='$ET_SRC_UPD_DEL_subject',ETD_EMAIL_BODY='$ET_SRC_UPD_DEL_body',ULD_ID=(SELECT ULD_ID FROM USER_LOGIN_DETAILS WHERE ULD_LOGINID='$USERSTAMP') WHERE ETD_ID='$ET_SRC_UPD_DEL_el_id' "; if (!mysqli_query($con,$sql)) { die('Error: ' . mysqli_error($con)); $flag=0; } else{ $flag=1;
<?php require "../../../frame/engine.php"; ENGINE::START(); $user = USER::VERIFY(1); $SYS_LEDGER = MYSQL::QUERY('SELECT * FROM core_stores_daily_checkouts WHERE s_id=? AND d_date=? LIMIT 1', array($user['store'], $_POST['date'])); $RESULTS = array('KEY' => $_POST['rec'] - $SYS_LEDGER['d_key'], 'CASH' => $_POST['cas'] - $SYS_LEDGER['d_cash'], 'CHECK' => $_POST['che'] - $SYS_LEDGER['d_check'], 'AMEX' => $_POST['ame'] - $SYS_LEDGER['d_amex'], 'DISCOVER' => $_POST['dis'] - $SYS_LEDGER['d_discover'], 'MASTER' => $_POST['mas'] - $SYS_LEDGER['d_master'], 'VISA' => $_POST['vis'] - $SYS_LEDGER['d_visa'], 'DEBIT' => $_POST['deb'] - $SYS_LEDGER['d_debit'], 'TICKETS' => ''); $CHECK = 0; foreach ($RESULTS as $KEY => $VALUE) { if ($VALUE != 0 && $CHECK == 0) { $RESULTS['TICKETS'] = array('TICKETS' => MYSQL::QUERY("SELECT qb_id,items,pm_1,pm_1_cost,pm_2,pm_2_cost FROM core_checkout_sessions WHERE s_id=? AND d_date>=? AND d_date<=?", array($user['store'], $_POST['date'] . ' 00:00:00', $_POST['date'] . ' 24:59:59'))); $CHECK = 1; } } echo JSON_ENCODE($RESULTS);
// } // $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)){ $CONFIG_ENTRY_save= 2; }
function getpaymenttypedetail($paymenttypeid) { $this->db->where('id', $paymenttypeid); $query = $this->db->get('paymenttypedetail')->row(); if ($query) { echo JSON_ENCODE($query); } else { echo 0; } }
$CONFIG_SRCH_UPD_sql_data = mysqli_query($con, "SELECT URC_ID,URC_DATA,URC_USERSTAMP,URC_TIMESTAMP FROM LMC_USER_RIGHTS_CONFIGURATION WHERE CGN_ID='$CONFIG_SRCH_UPD_type'"); } $appendTable="<br><div id='CONFIG_SRCH_UPD_div_errmsg'></div><br><table id='CONFIG_SRCH_UPD_tble_config' border=1 cellspacing='0' class='srcresult'><thead bgcolor='#6495ed' style='color:white'><tr class='head'><th style='text-align:center;' width=350>DATA</th><th style='text-align:center;' width=150>USERSTAMP</th><th style='text-align:center;' width=130>TIMESTAMP</th></tr></thead><tbody>"; while($row=mysqli_fetch_array($CONFIG_SRCH_UPD_sql_data)){ $appendTable .='<tr id='.$row[0].'><td id='.'CONFIG_'.$row[0].' class="data">'.$row[1].'</td>'; for($x = 2; $x < 4; $x++) { if($x == 3){ $appendTable .="<td style='text-align:center;'>".$row[$x]."</td>"; } else{ $appendTable .="<td>".$row[$x]."</td>"; } } } $appendTable .='</tbody></table>'; echo JSON_ENCODE($appendTable); } //UPDATE CODING if($_REQUEST['option']=="CONFIG_SRCH_UPD_save") { $ff=1; $flag=$_REQUEST['CONFIG_SRCH_UPD_lb_module']; $CONFIG_SRCH_UPD_data=$_REQUEST['CONFIG_SRCH_UPD_tb_data']; $CONFIG_SRCH_UPD_type=$_REQUEST['CONFIG_SRCH_UPD_lb_type']; $CONFIG_SRCH_UPD_id=$_REQUEST['CONFIG_SRCH_UPD_id']; $CONFIG_SRCH_UPD_arr_config=array(4=>array("attendance_configuration","AC_ID","AC_DATA","ULD_ID","(SELECT ULD_ID FROM USER_LOGIN_DETAILS WHERE ULD_LOGINID='$USERSTAMP')"),5=>array("PROJECT_CONFIGURATION","PC_ID","PC_DATA","ULD_ID","(SELECT ULD_ID FROM USER_LOGIN_DETAILS WHERE ULD_LOGINID='$USERSTAMP')"),2=>array("REPORT_CONFIGURATION","RC_ID","RC_DATA","ULD_ID","(SELECT ULD_ID FROM USER_LOGIN_DETAILS WHERE ULD_LOGINID='$USERSTAMP')"),3=>array("LMC_USER_RIGHTS_CONFIGURATION","URC_ID","URC_DATA","URC_USERSTAMP","(SELECT ULD_ID FROM LMC_USER_LOGIN_DETAILS WHERE ULD_USERNAME='******')")); $sql1= "SELECT ".$CONFIG_SRCH_UPD_arr_config[$flag][1]." FROM ".$CONFIG_SRCH_UPD_arr_config[$flag][0]." CCN WHERE CCN.CGN_ID=(SELECT C.CGN_ID FROM CONFIGURATION C WHERE C.CGN_ID='$CONFIG_SRCH_UPD_type') AND ".$CONFIG_SRCH_UPD_arr_config[$flag][1]."='$CONFIG_SRCH_UPD_data'"; $CONFIG_SRCH_UPD_type1 = mysqli_query($con,$sql1); $CONFIG_SRCH_UPD_save=0;
} if($ure_reason_txt!=null){ $ure_reason=''; $URE_reason_msg =explode("\n", $ure_reason_txt); $length=count($URE_reason_msg); for($i=0;$i<=$length;$i++){ $ure_reason.=$URE_reason_msg[$i].'<br>'; } } else{ $ure_reason=null; } $final_values=(object) ['id'=>$ure_id,'date' => $ure_date,'report' =>$ure_report,'report1' =>$ure_reprt,'userstamp'=> $ure_userstamp,'timestamp'=>$ure_timestamp,'reason'=>$ure_reason,'reason1'=>$ure_reason_txt,'permission'=>$ure_permission,'attendance'=>$ure_attendance,'pdid'=>$ure_pdid,'morningsession'=>$ure_morningsession,'afternoonsession'=>$ure_afternoonsession,'user_stamp'=>$userstamp,'flag'=>$ure_flag,'imageurl'=>$base64]; $ure_values[]=$final_values; } echo JSON_ENCODE($ure_values); } if($_REQUEST['option']=='ALLDATE') { $alldate = $_REQUEST['alldate']; $empdate = date('Y-m-d',strtotime($alldate)); $sql=mysqli_query($con,"SELECT DISTINCT AED.EMPLOYEE_NAME,A.UARD_REPORT,A.UARD_REASON,AC.AC_DATA as PERMISSION,AT.AC_DATA,G.AC_DATA AS UARD_AM_SESSION,H.AC_DATA AS UARD_PM_SESSION,C.ULD_LOGINID as USERSTAMP,DATE_FORMAT(CONVERT_TZ(A.UARD_TIMESTAMP,'+00:00','+08:00'), '%d-%m-%Y %T') as UARD_TIMESTAMP FROM USER_ADMIN_REPORT_DETAILS A INNER JOIN USER_LOGIN_DETAILS B on A.ULD_ID=B.ULD_ID INNER JOIN USER_LOGIN_DETAILS C on A.UARD_USERSTAMP_ID=C.ULD_ID INNER JOIN VW_TS_ALL_EMPLOYEE_DETAILS AED ON A.ULD_ID=AED.ULD_ID INNER JOIN USER_ACCESS D LEFT JOIN ATTENDANCE_CONFIGURATION G ON G.AC_ID=A.UARD_AM_SESSION LEFT JOIN ATTENDANCE_CONFIGURATION H ON H.AC_ID=A.UARD_PM_SESSION LEFT join ATTENDANCE_CONFIGURATION AC ON A.UARD_PERMISSION=AC.AC_ID left JOIN ATTENDANCE_CONFIGURATION AT on AT.AC_ID=A.UARD_ATTENDANCE INNER JOIN EMPLOYEE_DETAILS ED ON A.ULD_ID=ED.ULD_ID where A.UARD_DATE='$empdate' and D.UA_TERMINATE IS null order by EMPLOYEE_NAME"); while($row=mysqli_fetch_array($sql)){ $adm_reprt=$row["UARD_REPORT"]; $adm_userstamp=$row["USERSTAMP"]; $adm_timestamp=$row["UARD_TIMESTAMP"]; $adm_loginid=$row["EMPLOYEE_NAME"]; $adm_reason_txt=$row["UARD_REASON"]; $ure_morningsession=$row["UARD_AM_SESSION"]; $ure_afternoonsession=$row["UARD_PM_SESSION"];
$USERSTAMP = $UserStamp; global $con; //FUNCTION TO FETCHING EMAIL TEMPLATE SCRIPT NAME,ERROR MESSAGE FROM SQL TABLE if ($_REQUEST['option'] == "EP_ENTRY_getdomain_err") { $EP_ENTRY_profile_array=[]; $select_data=mysqli_query($con,"SELECT EP_ID,EP_EMAIL_DOMAIN FROM LMC_EMAIL_PROFILE WHERE EP_NON_IP_FLAG is null ORDER BY EP_EMAIL_DOMAIN ASC"); while($row=mysqli_fetch_array($select_data)){ $ep_id=$row['EP_ID']; $ep_profilename=$row['EP_EMAIL_DOMAIN']; $EP_ENTRY_script_object=array('EP_ENTRY_profile_names_id'=>$ep_id,'EP_ENTRY_profile_names' =>$ep_profilename); $EP_ENTRY_profile_array[]=$EP_ENTRY_script_object; } // GET ERR MSG $EP_SRC_UPD_DEL_errmsg = get_error_msg('7,40,158,159'); $finalvalues=array("EP_ENTRY_profilenamedataid"=>$EP_ENTRY_profile_array,"EP_ENTRY_errormsg"=>$EP_SRC_UPD_DEL_errmsg); echo JSON_ENCODE($finalvalues); } if($_REQUEST['option']=="EP_ENTRY_already") { $profilename=$_REQUEST['EP_ENTRY_listboxname']; $EP_ENTRY_email=$_REQUEST['EP_ENTRY_email']; $EP_ENTRY_alreadyemailid=mysqli_query($con,"SELECT * FROM LMC_EMAIL_LIST WHERE EL_EMAIL_ID='$EP_ENTRY_email' AND EP_ID=(SELECT EP_ID FROM LMC_EMAIL_PROFILE WHERE EP_EMAIL_DOMAIN='$profilename')"); $row=mysqli_num_rows($EP_ENTRY_alreadyemailid); if($row>0) { $EP_ENTRY_chkmail_flag=1; } else{ $EP_ENTRY_chkmail_flag=0; } echo $EP_ENTRY_chkmail_flag;
$USERSTAMP = $UserStamp; if ($_REQUEST['option'] == 'SUBMIT') { $rep_entryreport = $_REQUEST['AWRE_SRC_ta_enterreport']; $date = $_REQUEST['AWRE_SRC_tb_date']; $rep_entrydate = date("Y-m-d", strtotime($date)); $rep_entryreport = $con->real_escape_string($rep_entryreport); $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"]; } $sql = "INSERT INTO ADMIN_WEEKLY_REPORT_DETAILS (AWRD_REPORT,AWRD_DATE,ULD_ID)VALUES('{$rep_entryreport}','{$rep_entrydate}','{$rep_getuld_id}')"; if (!mysqli_query($con, $sql)) { die('Error: ' . mysqli_error($con)); $flag = 0; } else { $flag = 1; } echo $flag; } else { if ($_REQUEST['option'] == 'CHECK') { $date_array = array(); $sql = "SELECT * FROM ADMIN_WEEKLY_REPORT_DETAILS "; $sql_result = mysqli_query($con, $sql); while ($row = mysqli_fetch_array($sql_result)) { $date_array[] = $row["AWRD_DATE"]; } echo JSON_ENCODE($date_array); } } }