File manager - Edit - /home/autoph/public_html/api/aha/asa_myMeetings.php
Back
<?php include '../../../cfg/connhr.php'; $mykey = $_GET['keyID']; if($mykey =="6e59e008b5348b452b615a3033729daae383HRIS"){ $userID = $_GET['userID']; $startDate = $_GET['startDate']; $endDate = $_GET['endDate']; $CstartDate = date('Y-m-d'); //$dateTime = DateTime::createFromFormat('h:i A', $timeSlot); //$dateTimeX = DateTime::createFromFormat('H:i:s', $row['time_slot']); //$amTimepm = $dateTimeX->format('h:i A'); // SQL query $sql = "SELECT t1.*, t2.employee_id, t2.asa_user_id,t2.firstname,t2.lastname,t2.email,t2.mobile, t3.employee_id AS attendeesID,t3.meeting_id,t3.asa_user_id FROM asa_meetings t1 LEFT JOIN employees AS t2 ON t2.asa_user_id = t1.asa_user_id LEFT JOIN asa_meeting_attendees AS t3 on t1.id = t3.id WHERE t1.asa_user_id= '$userID' AND t3.asa_user_id ='$userID' AND t1.enabled = 1 ORDER BY t1.start_datetime ASC"; $result = $connhr->query($sql); if ($result->num_rows > 0) { // Array to hold the results $rows = array(); $count=0; $cssBG == "cssWhite"; while($row = $result->fetch_assoc()) { $count=$count + 1; if($cssBG == "cssWhite"){ $cssBG ="cssBlue"; }else{ $cssBG ="cssWhite"; } $timestamp = strtotime($row['start_datetime']); $sDate = date('Y-m-d', $timestamp); $sTime = date('h:i A', $timestamp); $endDatetime = strtotime($row['end_datetime']); $eDate = date('Y-m-d', $endDatetime); $eTime = date('h:i A', $endDatetime); //$rows[] = $row; $selectedFields = [ 'id' => $row['id'], 'employee_id' => $row['employee_id'], 'asa_userID' => $row['asa_user_id'], 'start_date' => $sDate, 'start_time' => $sTime, 'end_date' => $eDate, 'end_time' => $eTime, 'meeting_title' => $row['meeting_title'], 'created_by' => $row['created_by'], 'date_created' => $row['date_created'], 'update_at' => $row['update_at'], 'enabled' => $row['enabled'], 'confirmed' => $row['confirmed'], 'declined' => $row['declined'], 'notes' => $row['notes'], 'firstname' => $row['firstname'], 'lastname' => $row['lastname'], 'mobile' => $row['mobile'], 'email' => $row['email'], 'bgCSS' =>$cssBG // Add more fields as needed ]; $rows[] = $selectedFields; } } header('Content-Type: application/json'); echo json_encode([$rows,"count"=>"$count"]); } $connhr->close(); ?>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings