File manager

File manager - Edit - /home/autoph/public_html/connect/api/prf/prf_POApprovalList.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']; $poNumber = $_REQUEST['poNumber']; $return_tag = Array(); //$sql = "SELECT * FROM `prf_purchase_order` WHERE `po_status`= 2 ORDER BY `id` DESC"; if($poNumber!=''){ $sql = "SELECT prf_purchase_order.`id`, prf_purchase_order.`po_number`, prf_purchase_order.`po_status`, prf_purchase_order.`comp_id`, prf_purchase_order.`dealer_id`, prf_purchase_order.`canvass_id`, prf_purchase_order.`vendor_id`, prf_purchase_order.`date_posted`, prf_purchase_order.`checked_by`, prf_purchase_order.`date_checked`, prf_purchase_order.`delivered_date`, prf_purchase_order.`terms`, prf_purchase_order.`remarks`, prf_purchase_order.`delivery_date`, prf_suppliers.`id`, prf_suppliers.`sup_name`, prf_suppliers.`terms`, vts_users.`u_id`, vts_users.`u_fname`, vts_users.`u_lname`,vts_dealerships.`deal_name`,vts_dealerships.`deal_code`, vts_company.`comp_id`,vts_company.`comp_name`,prf_request_detl.`header_ref_code`,FORMAT(SUM(prf_request_detl.`approved_amount`), 2) as poAmount FROM prf_purchase_order JOIN prf_suppliers ON prf_suppliers.id = prf_purchase_order.vendor_id JOIN vts_users ON vts_users.u_id = prf_purchase_order.checked_by JOIN vts_company ON vts_company.comp_id = prf_purchase_order.`comp_id` JOIN vts_dealerships ON vts_dealerships.deal_id = prf_purchase_order.`dealer_id` JOIN prf_request_detl ON prf_request_detl.po_code = prf_purchase_order.`po_number` WHERE prf_purchase_order.po_status = 2 AND prf_purchase_order.`po_number` = prf_request_detl.`po_code` AND prf_purchase_order.`po_number`='$poNumber' GROUP BY prf_request_detl.`po_code` ORDER BY prf_purchase_order.id ASC "; }else{ $sql = "SELECT prf_purchase_order.`id`, prf_purchase_order.`po_number`, prf_purchase_order.`po_status`, prf_purchase_order.`comp_id`, prf_purchase_order.`dealer_id`, prf_purchase_order.`canvass_id`, prf_purchase_order.`vendor_id`, prf_purchase_order.`date_posted`, prf_purchase_order.`checked_by`, prf_purchase_order.`date_checked`, prf_purchase_order.`delivered_date`, prf_purchase_order.`terms`, prf_purchase_order.`remarks`, prf_purchase_order.`delivery_date`, prf_suppliers.`id`, prf_suppliers.`sup_name`, prf_suppliers.`terms`, vts_users.`u_id`, vts_users.`u_fname`, vts_users.`u_lname`,vts_dealerships.`deal_name`,vts_dealerships.`deal_code`, vts_company.`comp_id`,vts_company.`comp_name`,prf_request_detl.`header_ref_code`,FORMAT(SUM(prf_request_detl.`approved_amount`), 2) as poAmount FROM prf_purchase_order JOIN prf_suppliers ON prf_suppliers.id = prf_purchase_order.vendor_id JOIN vts_users ON vts_users.u_id = prf_purchase_order.checked_by JOIN vts_company ON vts_company.comp_id = prf_purchase_order.`comp_id` JOIN vts_dealerships ON vts_dealerships.deal_id = prf_purchase_order.`dealer_id` JOIN prf_request_detl ON prf_request_detl.po_code = prf_purchase_order.`po_number` WHERE prf_purchase_order.po_status = 2 AND prf_purchase_order.`po_number` = prf_request_detl.`po_code` GROUP BY prf_request_detl.`po_code` ORDER BY prf_purchase_order.id ASC "; } $chkIfApprover = mysql_result(mysql_query("SELECT COUNT(1) FROM `prf_poapprover` WHERE `po_officer_id`=$userID"),0); if($chkIfApprover > 0){ $sqlTable = mysql_query($sql, $conn); while($sqlRecord = mysql_fetch_assoc($sqlTable)) { $count = $count + 1; $return_tag[]= $sqlRecord; } if($count > 0){ $visible="false"; if($count > 1){ $foundRecord ='There are (' . $count.') records found.'; }else{ $foundRecord ='Only (' . $count.') record found.'; } }else{ $visible="true"; $visible="false"; if($count > 1){ $foundRecord ='There are (' . $count.') records found.'; }else{ $foundRecord ='Only (' . $count.') record found.'; } } $json = json_encode([$return_tag,"Visible" => "$visible","Authority" => "$foundRecord"]); }else{ $json = json_encode(["Visible" => "$visible","Authority" => "$foundRecord"]); } } if($did_something === 0) { $msg = did_nothing_message; $json = json_encode(["status" => "$MyCustomerID", "statusCode" => "$customerType"]); } echo $json; ?>

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