File manager

File manager - Edit - /home/autoph/public_html/connect/api/prf/assetValidation_list.php

Back
<?php date_default_timezone_set('Asia/Manila'); header('Content-Type: application/json'); $sqlUser = 'autoph_arnel'; $sqlDatabase = 'autoph_connect'; $sqlPass = 'Hke@2001'; $toDate = date_create() ->format("Y/m/d"); $conn = mysql_connect($sqlHost, $sqlUser, $sqlPass) or die ("Couldn't connct to MySQL server on $sqlHost: ". mysql_error(). '.'); $db = mysql_select_db($sqlDatabase, $conn) or die ("Couldn't select database $sqlDatabase: ". mysql_error(). '.'); $ApiKey= $_REQUEST['keyID']; // Expect LoginName, LoginPassword //========================================================= if($ApiKey == 'AAA1024197710262009EEE'){ $userID = $_REQUEST['userID']; // Expect LoginName, LoginPassword* $return_tag = Array(); $sqlXXX = "SELECT prf_request_hdr.reference_code, prf_request_hdr.request_by, prf_request_hdr.dept_head_id, prf_request_hdr.date_needed, prf_request_hdr.`purpose_of_request`, prf_request_hdr.date_needed,prf_validate_links.completed, prf_validate_links.link,prf_validate_links.sms_link, prf_validate_links.uid, prf_validate_links.item_id, prf_validate_links.po_code, vts_users.u_fname, vts_users.u_lname, vts_users.u_id,vts_users.employee_id FROM prf_validate_links JOIN prf_request_hdr ON prf_request_hdr.reference_code = prf_validate_links.po_code JOIN vts_users ON vts_users.u_id = prf_validate_links.uid WHERE prf_request_hdr.reference_code = prf_validate_links.po_code AND prf_validate_links.completed=0 AND link LIKE '%validate%' AND vts_users.u_id=$userID AND prf_request_hdr.`dept_approval_date`!='' AND prf_request_hdr.`gm_approval_date`!='' AND prf_request_hdr.`admin_approval_date`=''"; $sql = "SELECT prf_request_hdr.id, prf_request_hdr.reference_code, prf_request_hdr.request_by, prf_request_hdr.dept_head_id, prf_request_hdr.date_created, prf_request_hdr.deleted, prf_request_hdr.`purpose_of_request`, prf_request_hdr.posted_date, prf_request_hdr.purpose_of_request, prf_request_hdr.reference_code, prf_request_hdr.date_needed, vts_users.u_fname, vts_users.u_lname, vts_users.u_id, vts_users.employee_id FROM vts_users JOIN prf_request_hdr ON vts_users.u_id = prf_request_hdr.`request_by` WHERE prf_request_hdr.deleted = 0 AND prf_request_hdr.approving_admin_id=$userID AND prf_request_hdr.admin_approval_date='' AND prf_request_hdr.gm_approval_date!=''"; $sqlX = "SELECT * FROM `prf_request_hdr` WHERE `approving_admin_id`='$userID' AND deleted=0"; $sqlTable = mysql_query($sql, $conn); while($sqlRecord = mysql_fetch_assoc($sqlTable)) { $count = $count + 1; $return_tag[]= $sqlRecord; } if($count > 0){ $visible="false"; }else{ $visible="true"; } $json = json_encode([$return_tag,"Visible" => "$visible"]); } echo $json; ?>

| ver. 1.4 | . | PHP 7.3.33 | Generation time: 0.08 | proxy | phpinfo | Settings