File manager

File manager - Edit - /home/autoph/public_html/tasks/CL_Clearance_ForApproval.php.tar

Back
home/autoph/public_html/connect/CL_Clearance_ForApproval.php��0000644��00000010167�15025026015�0020207 0��ustar�00��<?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 == 20101088991122){//FOR APPROVAL REST API FUNCTION $userID= $_REQUEST['empID']; // Expect LoginName, LoginPassword* $return_tag = Array(); $sql = "SELECT vts_users.u_fname,vts_users.u_lname,vts_users.u_lname, cl_clearance_header.cl_h_emp_id,cl_clearance_header.cl_h_reason, cl_clearance_header.cl_h_date_created, cl_clearance_header.h_id FROM cl_clearance_header join vts_users ON cl_clearance_header.cl_h_emp_id = vts_users.u_id WHERE cl_clearance_header.cl_approver_id = '$userID' AND cl_clearance_header.cl_approver_id_timestamp = '' AND cl_clearance_header.cl_recommender_a_timestamp != '' AND cl_clearance_header.cl_recommender_b_timestamp != '' AND cl_clearance_header.cl_h_hr_approval='FINAL APPROVAL' \|\| cl_clearance_header.cl_approver_id_b = '$userID' AND cl_clearance_header.cl_approver_id_b_timestamp = '' AND cl_clearance_header.cl_recommender_a_timestamp != '' AND cl_clearance_header.cl_recommender_b_timestamp != '' AND cl_clearance_header.cl_h_hr_approval='FINAL APPROVAL' "; $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"]); //$jsonA = json_encode(["Visible" => "$visible"]); } if($ApiKey == 30101088991133){ //FOR ENDORSEMENT REST API $userID= $_REQUEST['empID']; // Expect LoginName, LoginPassword* $return_tag = Array(); $sqlA = "SELECT vts_users.u_fname,vts_users.u_lname,vts_users.u_lname, cl_clearance_header.cl_h_emp_id,cl_clearance_header.cl_h_reason, cl_clearance_header.cl_h_date_created, cl_clearance_header.h_id FROM cl_clearance_header join vts_users ON cl_clearance_header.cl_h_emp_id = vts_users.u_id WHERE cl_clearance_header.cl_recommender_a_id = '$userID' AND cl_clearance_header.cl_recommender_a_timestamp = '' AND cl_clearance_header.cl_h_hr_approval = 'FOR ENDORSEMENT' \|\| cl_clearance_header.cl_recommender_b_id = '$userID' AND cl_clearance_header.cl_recommender_b_timestamp = '' AND cl_clearance_header.cl_h_hr_approval = 'FOR ENDORSEMENT'"; $sqlTable = mysql_query($sqlA, $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"]); //$jsonA = json_encode(["Visible" => "$visible"]); } if($ApiKey == 40101088991144){ //FOR HR AUTHORIZATION $userID = $_REQUEST['empID']; // Expect LoginName, LoginPassword* $compID = $_REQUEST['compID']; // Expect LoginName, LoginPassword* $return_tag = Array(); $sqlA = "SELECT vts_users.u_fname,vts_users.u_lname,vts_users.u_lname, cl_clearance_header.cl_h_emp_id,cl_clearance_header.cl_h_reason, cl_clearance_header.cl_h_date_created, cl_clearance_header.h_id FROM cl_clearance_header join vts_users ON cl_clearance_header.cl_h_emp_id = vts_users.u_id WHERE cl_clearance_header.cl_hr_approval_id = '$userID' AND cl_clearance_header.cl_h_comp_id = '$compID' AND cl_clearance_header.hdr_status = 0 AND `delete_date_time`=''"; $sqlTable = mysql_query($sqlA, $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"]); //$jsonA = json_encode(["Visible" => "$visible"]); } echo $json; ?> ��

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