<?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();
$sql = "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,vusers.u_fname,vusers.u_lname,vts_users.u_id,vts_users.employee_id, prf_request_detl.header_ref_code,prf_request_detl.item_description 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 
JOIN prf_request_detl ON prf_request_detl.id = prf_validate_links.item_id
JOIN vts_users as vusers ON vusers.u_id = prf_request_hdr.request_by 
WHERE prf_validate_links.completed = 0 AND link LIKE '%exapr%' AND prf_request_detl.id = prf_validate_links.item_id AND prf_validate_links.uid=$userID";
	
	$sqlTable = mysql_query($sql, $conn);
		while($sqlRecord = mysql_fetch_assoc($sqlTable))
	{ 
        $count = $count + 1;
        $return_tag[]= $sqlRecord;
       
	}
	if($count > 0){
	    $visible="false";
	    $itemDescVisible="true";
	}else{
	    $visible="true";
	    $itemDescVisible="false";
	}
    $json = json_encode([$return_tag,"Visible" => "$visible","itemDesVisible" => "$itemDescVisible"]);
    
}
 

echo $json;
 
 
?>