File manager

File manager - Edit - /home/autoph/public_html/connect/CL_LOAD_action_SLIP.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 == 881010108899110088){//FOR CLEARING OFFICER RECORD REST API $userID= $_REQUEST['cl_data_id']; // Expect LoginName, LoginPassword //$clKeyCode= '012814704-91';// $recordID= $_REQUEST['cl_data_record_id']; // Expect LoginName, LoginPassword $clKeyCode = mysql_result(mysql_query("SELECT `key_code` FROM `cl_clearance_data` WHERE cl_id='$recordID'"),0); //$clKeyCode = mysql_result(mysql_query("SELECT `key_code` FROM `cl_clearance_header` WHERE h_id='$recordID'"),0); $getAction = "SELECT cl_action_slip_data.id, cl_action_slip_data.cl_key_code,cl_action_slip_data.amount, cl_action_slip_data.cl_emp_id, cl_action_slip_data.cl_slip_info, cl_action_slip_data.cl_slip_date, cl_action_slip_data.cl_slip_time, cl_action_slip_data.cl_hdr_id, vts_users.u_fname, vts_users.u_lname, vts_users.u_id, vts_users.u_position FROM cl_action_slip_data INNER JOIN vts_users ON cl_action_slip_data.cl_request_by_id = vts_users.u_id WHERE cl_action_slip_data.`cl_key_code`='$clKeyCode' AND cl_action_slip_data.`cl_key_code`!='' ORDER BY id DESC"; $sqlTable = mysql_query($getAction, $conn); while($sqlData = mysql_fetch_assoc($sqlTable)){ $return_tag[]=$sqlData; } if($visible > 0 ){ $visible='true'; }else{ $visible='false'; } $json = json_encode([$return_tag, "Visible" => "$visible"]); } //========================================================= if($ApiKey == 881010108899110099){//FOR APPROVING OFFICERS RECORD REST API $userID= $_REQUEST['cl_data_id']; // Expect LoginName, LoginPassword $recordID= $_REQUEST['cl_data_record_id']; //$clKeyCode = mysql_result(mysql_query("SELECT `key_code` FROM `cl_clearance_data` WHERE cl_id='$recordID'"),0); $clKeyCode = mysql_result(mysql_query("SELECT `key_code` FROM `cl_clearance_header` WHERE h_id='$recordID'"),0); $getAction = "SELECT cl_action_slip_data.id, cl_action_slip_data.cl_key_code,cl_action_slip_data.amount, cl_action_slip_data.cl_emp_id, cl_action_slip_data.cl_slip_info, cl_action_slip_data.cl_slip_date, cl_action_slip_data.cl_slip_time, cl_action_slip_data.cl_hdr_id, vts_users.u_fname, vts_users.u_lname, vts_users.u_id, vts_users.u_position FROM cl_action_slip_data INNER JOIN vts_users ON cl_action_slip_data.cl_request_by_id = vts_users.u_id WHERE cl_action_slip_data.`cl_key_code`='$clKeyCode' AND cl_action_slip_data.`cl_key_code`!='' ORDER BY id DESC"; $sqlTable = mysql_query($getAction, $conn); while($sqlData = mysql_fetch_assoc($sqlTable)){ $return_tag[]=$sqlData; } if($visible > 0 ){ $visible='true'; }else{ $visible='false'; } $json = json_encode([$return_tag, "Visible" => "$visible"]); } //========================================================= if($ApiKey == 8810241977091101072120010622201588){//FOR APPROVAL REST API $userID= $_REQUEST['userID']; // Expect LoginName, LoginPassword //$clKeyCode= '012814704-91';// $clKeyCode= $_REQUEST['clKeyCode']; // Expect LoginName, LoginPassword $getAction = "SELECT cl_action_slip_data.id, cl_action_slip_data.cl_key_code, cl_action_slip_data.cl_emp_id, cl_action_slip_data.cl_slip_info, cl_action_slip_data.cl_slip_date, cl_action_slip_data.cl_slip_time, cl_action_slip_data.cl_hdr_id, vts_users.u_fname, vts_users.u_lname, vts_users.u_id, vts_users.u_position FROM cl_action_slip_data INNER JOIN vts_users ON cl_action_slip_data.cl_request_by_id = vts_users.u_id WHERE cl_action_slip_data.`cl_key_code`='$clKeyCode' AND cl_action_slip_data.`cl_key_code`!='' ORDER BY id DESC"; $sqlTable = mysql_query($getAction, $conn); while($sqlData = mysql_fetch_assoc($sqlTable)){ $return_tag[]=$sqlData; } if($visible > 0 ){ $visible='true'; }else{ $visible='false'; } $json = json_encode([$return_tag, "Visible" => "$visible"]); } echo $json; //echo $jsonA; ?>

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