File manager - Edit - /home/autoph/public_html/connect/Clearance_Count.php
Back
<?php date_default_timezone_set('Asia/Manila'); header('Content-Type: application/json'); error_reporting(0); $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 == 10241977091101){ $userID= $_REQUEST['user_id']; $compID= $_REQUEST['comp_id']; $clearanceForOfficerApproval = mysql_result(mysql_query("SELECT COUNT(key_code) FROM `cl_clearance_data` WHERE `cl_approver_id_a`='$userID' AND `cl_approved_by_id` = 0 AND `hdr_status` = '1' AND `deleted`='No' || `cl_approver_id_b`='$userID' AND `cl_approved_by_id` = 0 AND `hdr_status` = '1' AND `deleted`='No'"),0); $myEndorsement = mysql_result(mysql_query("SELECT COUNT(h_id) FROM `cl_clearance_header` WHERE `cl_recommender_a_id` ='$userID' AND `cl_recommender_a_timestamp`='' AND `cl_h_hr_approval` = 'FOR ENDORSEMENT' || `cl_recommender_b_id` ='$userID' AND `cl_recommender_b_timestamp`='' AND `cl_h_hr_approval` = 'FOR ENDORSEMENT'"),0); $forAuthorization = mysql_result(mysql_query("SELECT COUNT(h_id) FROM `cl_clearance_header` WHERE `cl_h_comp_id`='$compID' AND `cl_hr_approval_id` ='$userID' AND `cl_hr_approval_timestamp`='' AND `hdr_status` = 0"),0); $myForMyFinalApproval = mysql_result(mysql_query("SELECT COUNT(h_id) FROM `cl_clearance_header` WHERE `cl_approver_id` ='$userID' AND `cl_approver_id_timestamp`='' AND `cl_recommender_b_timestamp`!='' AND `cl_recommender_a_timestamp`!='' AND `cl_h_hr_approval`='FINAL APPROVAL' || `cl_approver_id_b` ='$userID' AND `cl_approver_id_b_timestamp`='' AND `cl_recommender_b_timestamp`!='' AND `cl_recommender_a_timestamp`!='' AND `cl_h_hr_approval`='FINAL APPROVAL'"),0); $myForApproval = $clearanceForOfficerApproval + $forAuthorization + $myEndorsement + $myForMyFinalApproval; $json = json_encode(["ROUTE" => "$forAuthorization","ENDORSE" => "$myEndorsement","APPROVE" => "$myForMyFinalApproval","CLEAR" => "$clearanceForOfficerApproval","TOTAL" => "$myForApproval"]); } 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