File manager

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

Back
home/autoph/public_html/connect/CL_LoadEmployeeInfo.php��0000644��00000017031�15025031216�0017206 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 == 10101088991100){//FOR APPROVAL REST API FUNCTION $hrdDataID = $_REQUEST['clearanceDataID']; //ClearanceDataID $getKeyCode = mysql_result(mysql_query("SELECT `key_code` FROM `cl_clearance_data` WHERE `cl_id`='$hrdDataID'"),0); $getEmpID = mysql_result(mysql_query("SELECT `cl_h_emp_id` FROM `cl_clearance_header` WHERE `key_code`='$getKeyCode'"),0); $getReason = mysql_result(mysql_query("SELECT `cl_h_reason` FROM `cl_clearance_header` WHERE `key_code`='$getKeyCode'"),0); $getDateResigned = mysql_result(mysql_query("SELECT `DateResigned` FROM `cl_clearance_header` WHERE `key_code`='$getKeyCode'"),0); $getEffectivity = mysql_result(mysql_query("SELECT `cl_effectivity_date` FROM `cl_clearance_header` WHERE `key_code`='$getKeyCode'"),0); $getCompanyID = mysql_result(mysql_query("SELECT `cl_h_comp_id` FROM `cl_clearance_header` WHERE `key_code`='$getKeyCode'"),0); $getCompanyName = mysql_result(mysql_query("SELECT `comp_name` FROM `vts_company` WHERE `comp_id`='$getCompanyID'"),0); //$getSLAStartDate = mysql_result(mysql_query("SELECT `cl_h_date_created` FROM `cl_clearance_header` WHERE `key_code`='$getKeyCode'"),0); //025748906-1 $getSLAStartDate = mysql_result(mysql_query("SELECT `cl_sla_start` FROM `cl_clearance_data` WHERE `cl_id`='$hrdDataID'"),0); $getPositionID = mysql_result(mysql_query("SELECT `cl_h_emp_id` FROM `cl_clearance_header` WHERE `key_code`='$getKeyCode'"),0); $getPosition = mysql_result(mysql_query("SELECT `u_position` FROM `vts_users` WHERE `u_id`='$getPositionID'"),0); $getDepartment = mysql_result(mysql_query("SELECT `cl_unit_assignment` FROM `cl_clearance_header` WHERE `key_code`='$getKeyCode'"),0); $empFName = mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id`='$getEmpID'"),0); $empLName = mysql_result(mysql_query("SELECT `u_lname` FROM `vts_users` WHERE `u_id`='$getEmpID'"),0); $myPicture = mysql_result(mysql_query("SELECT `photo` FROM `vts_users` WHERE `u_id`='$getEmpID'"),0); $empMobile = mysql_result(mysql_query("SELECT `usr_mobile` FROM `vts_users` WHERE `u_id`='$getEmpID'"),0); $empEmail = mysql_result(mysql_query("SELECT `email` FROM `vts_users` WHERE `u_id`='$getEmpID'"),0); $empDealer = mysql_result(mysql_query("SELECT `dealer` FROM `vts_users` WHERE `u_id`='$getEmpID'"),0); $dealerName = mysql_result(mysql_query("SELECT `deal_name` FROM `vts_dealerships` WHERE `deal_id`='$empDealer'"),0); $myFullName = strtoupper($empFName ." ". $empLName); $actual = mysql_result(mysql_query("SELECT COUNT(cl_id) FROM `cl_clearance_data` WHERE `key_code`='$getKeyCode' AND `cl_approver_id_a` != 0 AND `cl_approved_by_id` !=0 \|\| `key_code`='$getKeyCode' AND `cl_approver_id_b` != 0 AND `cl_approved_by_id` !=0"),0); //3818206-40 $max = mysql_result(mysql_query("SELECT COUNT(cl_id) FROM `cl_clearance_data` WHERE key_code='$getKeyCode' AND `cl_approver_id_a` != 0 \|\| key_code='$getKeyCode' AND `cl_approver_id_b` != 0"),0);//3818206-40 $Rate = ($actual / $max) * 100; $cRate = number_format($Rate,0,'.','')."%"; $json = json_encode(["cRate"=>"$cRate","FName" => "$empFName","LName" => "$empLName","Position" => "$getPosition","Email" => "$empEmail","Mobile" => "$empMobile","Department" => "$getDepartment","Reason" => "$getReason","Company" => "$getCompanyName","Dealer" => "$dealerName","Effectivity" => "$getEffectivity","DateResigned" => "$getDateResigned","DateReceived" => "$getSLAStartDate","FullName" => "$myFullName","Photo" => "$myPicture"]); } if($ApiKey == 30101088991133 \|\| $ApiKey == 40101088991144 \|\| $ApiKey == 20101088991122){//FOR APPROVAL REST API FUNCTION $clearanceDataID = $_REQUEST['clearanceDataID']; //ClearanceDataID $getKeyCode = mysql_result(mysql_query("SELECT `key_code` FROM `cl_clearance_header` WHERE `h_id`='$clearanceDataID' "),0); $getEmpID = mysql_result(mysql_query("SELECT `cl_h_emp_id` FROM `cl_clearance_header` WHERE `key_code`='$getKeyCode'"),0); $getReason = mysql_result(mysql_query("SELECT `cl_h_reason` FROM `cl_clearance_header` WHERE `key_code`='$getKeyCode'"),0); $getDateResigned = mysql_result(mysql_query("SELECT `DateResigned` FROM `cl_clearance_header` WHERE `key_code`='$getKeyCode'"),0); $getEffectivity = mysql_result(mysql_query("SELECT `cl_effectivity_date` FROM `cl_clearance_header` WHERE `key_code`='$getKeyCode'"),0); $getCompanyID = mysql_result(mysql_query("SELECT `cl_h_comp_id` FROM `cl_clearance_header` WHERE `key_code`='$getKeyCode'"),0); $getCompanyName = mysql_result(mysql_query("SELECT `comp_name` FROM `vts_company` WHERE `comp_id`='$getCompanyID'"),0); $getSLAStartDate = mysql_result(mysql_query("SELECT `cl_sla_start` FROM `cl_clearance_header` WHERE `key_code`='$getKeyCode'"),0); $getPosition = mysql_result(mysql_query("SELECT `cl_emp_designated` FROM `cl_clearance_header` WHERE `key_code`='$getKeyCode'"),0); $getDepartment = mysql_result(mysql_query("SELECT `cl_unit_assignment` FROM `cl_clearance_header` WHERE `key_code`='$getKeyCode'"),0); $empFName = mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id`='$getEmpID'"),0); $empLName = mysql_result(mysql_query("SELECT `u_lname` FROM `vts_users` WHERE `u_id`='$getEmpID'"),0); $myPicture = mysql_result(mysql_query("SELECT `photo` FROM `vts_users` WHERE `u_id`='$getEmpID'"),0); $empMobile = mysql_result(mysql_query("SELECT `usr_mobile` FROM `vts_users` WHERE `u_id`='$getEmpID'"),0); $empEmail = mysql_result(mysql_query("SELECT `email` FROM `vts_users` WHERE `u_id`='$getEmpID'"),0); $empDealer = mysql_result(mysql_query("SELECT `dealer` FROM `vts_users` WHERE `u_id`='$getEmpID'"),0); $dealerName = mysql_result(mysql_query("SELECT `deal_name` FROM `vts_dealerships` WHERE `deal_id`='$empDealer'"),0); $myFullName = strtoupper($empFName ." ". $empLName); $actual = mysql_result(mysql_query("SELECT COUNT(cl_id) FROM `cl_clearance_data` WHERE `key_code`='$getKeyCode' AND `cl_approver_id_a` != 0 AND `cl_approved_by_id` !=0 \|\| `key_code`='$getKeyCode' AND `cl_approver_id_b` != 0 AND `cl_approved_by_id` !=0"),0); //3818206-40 $max = mysql_result(mysql_query("SELECT COUNT(cl_id) FROM `cl_clearance_data` WHERE key_code='$getKeyCode' AND `cl_approver_id_a` != 0 \|\| key_code='$getKeyCode' AND `cl_approver_id_b` != 0"),0);//3818206-40 $Rate = ($actual / $max) * 100; $cRate = number_format($Rate,0,'.','')."%"; $json = json_encode(["cRate"=>"$cRate","FName" => "$empFName","LName" => "$empLName","Position" => "$getPosition","Email" => "$empEmail","Mobile" => "$empMobile","Department" => "$getDepartment","Reason" => "$getReason","Company" => "$getCompanyName","Dealer" => "$dealerName","Effectivity" => "$getEffectivity","DateResigned" => "$getDateResigned","DateReceived" => "$getSLAStartDate","FullName" => "$myFullName","Photo" => "$myPicture"]); } echo $json; //echo $jsonA; ?> ��

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