File manager - Edit - /home/autoph/public_html/connect/api/prf/prf_countForApproval.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['apiKey']; // Expect LoginName, LoginPassword //========================================================= if($ApiKey == 453454353454534523413432){//FOR APPROVAL REST API FUNCTION $userID = $_REQUEST['empID']; // Expect LoginName, LoginPassword* $prfDeptApproval = mysql_result(mysql_query("SELECT COUNT(1) FROM `prf_request_hdr` WHERE `deleted`=0 AND `dept_head_id`='$userID' AND `dept_approval_date`='' AND `current_status` < 90 AND `current_status`!=0"),0); $prfGMCount = mysql_result(mysql_query("SELECT COUNT(1) FROM `prf_request_hdr` WHERE `deleted`=0 AND `approving_GM_id`='$userID' AND `gm_approval_date`='' AND `dept_approval_date`!='' AND `current_status`=2 AND `request_by`!=0"),0); $prfPOApprocalCount=mysql_result(mysql_query("SELECT COUNT(1) FROM `prf_purchase_order` WHERE `po_status`=2 AND `date_approved`=''"),0); $prfDeptAssetValidation = mysql_result(mysql_query("SELECT COUNT(1) FROM `prf_request_hdr` WHERE `deleted`=0 AND `approving_admin_id`='$userID' AND `admin_approval_date`='' AND `gm_approval_date`!='' AND `dept_approval_date`!='' AND `current_status` <90"),0); //check if user id exist in prf_poapprover table. if not zero out the PO validation and PO Approver $chkPOCheck = mysql_result(mysql_query("SELECT COUNT(1) FROM prf_poapprover WHERE po_officer_id=$userID AND trans_type ='Checker' || po_officer_id=$userID AND trans_type ='Approver'"),0); if($chkPOCheck > 0){ $prfPOApprocalCountValidated = $prfPOApprocalCount; }else{ $prfPOApprocalCountValidated = 0; } $json = json_encode(["deptHeadCount" => $prfDeptApproval,"validatorCount" => $prfDeptAssetValidation,"gmCount" => $prfGMCount,"prfPOApprocalCount" => $prfPOApprocalCountValidated]); } echo $json; ?>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings