File manager - Edit - /home/autoph/public_html/tasks/CLR_ListForFinalApproval.php.tar
Back
home/autoph/public_html/connect/CLR_ListForFinalApproval.php 0000644 00000003665 15025025345 0020214 0 ustar 00 <?php include '../../cfg/asaconn.php'; $mykey = $_GET['ApiKey']; //========================================================= if($mykey == 10101080000000000028991100){ $userID= $_REQUEST['empID']; // Expect LoginName, LoginPassword* $count =0; $rows = Array(); $sql = "SELECT vts_users.u_fname, vts_users.u_lname, vts_users.u_lname, vts_users.u_position, vts_company.comp_code, cl_clearance_header.cl_h_emp_id, cl_clearance_header.cl_recommender_a_id, cl_clearance_header.cl_recommender_b_id, cl_clearance_header.cl_recommender_a_timestamp, cl_clearance_header.cl_recommender_b_timestamp, cl_clearance_header.h_id, cl_clearance_header.cl_effectivity_date, cl_clearance_header.cl_h_reason, cl_clearance_header.cl_h_date_created, cl_clearance_header.key_code, cl_clearance_header.cl_h_hr_approval FROM cl_clearance_header join vts_users ON cl_clearance_header.cl_h_emp_id = vts_users.u_id join vts_company ON cl_clearance_header.cl_h_comp_id = vts_company.comp_id WHERE cl_clearance_header.cl_approver_id=$userID AND cl_clearance_header.cl_h_hr_approval ='FINAL APPROVAL' || cl_clearance_header.cl_approver_id_b=$userID AND cl_clearance_header.cl_h_hr_approval ='FINAL APPROVAL' ORDER BY cl_clearance_header.h_id ASC"; $resultA = $conn->query($sql); if ($resultA->num_rows > 0) { while($row = $resultA->fetch_assoc()){ $count = $count + 1; $date1 = new DateTime($row['cl_effectivity_date']); $date2 = new DateTime($curDate); $interval = $date1->diff($date2); if($interval->days > 1){ $withS = 's'; }else{ $withS = ''; } $intervalDates = $interval->days; $rows[] = [$row,"days"=>"$intervalDates", "Count" =>"$count"]; } } $json = json_encode($rows); } echo $json; ?>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings