File manager - Edit - /home/autoph/public_html/data03252025consolidation/app/employee/employee_information.php
Back
<?php include_once("../../cfg/db.php"); $employee_id = $db -> escape(trim($_POST['employee_id'])); $query_all_info = "SELECT e.id, e.`employee_id`, e.`first_name`, e.`middle_name`, e.`last_name`, ext.id as suffix_id ,e.`date_of_birth`, ag.id as gender_id, e.`photo`, DATE_FORMAT(e.date_registered, '%M %d, %Y - %h:%i:%s %p') as date_registered, ea.username,ea.employee_role_id ,ec.email_address,ec.email_address_2,ec.contact_number,ec.contact_number_2,ec.fax,ec.business,ec.residential,ec.landline,ec.address,st.provCode,ac.id as city_id ,ec.postal,ed.id as department_id , ep.id as position_id, sc.id as company_id,sd.id as dealer_id FROM `employee` e INNER JOIN employee_account ea ON e.employee_id = ea.employee_id INNER JOIN employee_contact ec ON e.employee_id = ec.employee_id INNER JOIN all_suffix ext ON e.suffix_id = ext.id INNER JOIN all_gender ag ON e.gender_id = ag.id INNER JOIN source_company_dealer cdi ON e.company_dealer_id = cdi.id INNER JOIN source_company sc ON cdi.company_id = sc.id INNER JOIN source_dealer sd ON cdi.dealer_id = sd.id INNER JOIN employee_department ed ON e.department_id = ed.id INNER JOIN employee_position ep ON e.position_id = ep.id LEFT OUTER JOIN all_state st on ec.provCode = st.provCode LEFT OUTER JOIN all_city ac ON ec.city_id=ac.id where e.id = '$employee_id'"; // echo $query_all_info; return; $employee_info = $db -> return_result($query_all_info); foreach($employee_info as $data){ $data = array_map("replaceNull", $data); $return_arr['id'] = $data['id']; $return_arr['employee_id'] = $data['employee_id']; $return_arr['first_name'] = $data['first_name']; $return_arr['middle_name'] = $data['middle_name']; $return_arr['last_name'] = $data['last_name']; $return_arr['suffix_name'] = $data['suffix_id']; $return_arr['date_of_birth'] = $data['date_of_birth']; $return_arr['gender_name'] = $data['gender_id']; $return_arr['photo'] = $data['photo']; $return_arr['date_registered'] = $data['date_registered']; $return_arr['username'] = $data['username']; $return_arr['employee_role_id'] = $data['employee_role_id']; $return_arr['email_address'] = $data['email_address']; $return_arr['email_address_2'] = $data['email_address_2']; $return_arr['contact_number'] = $data['contact_number']; $return_arr['contact_number_2'] = $data['contact_number_2']; $return_arr['fax'] = $data['fax']; $return_arr['business'] = $data['business']; $return_arr['residential'] = $data['residential']; $return_arr['landline'] = $data['landline']; $return_arr['address'] = $data['address']; $return_arr['state'] = $data['provCode']; $return_arr['city'] = $data['city_id']; $return_arr['postal'] = $data['postal']; $return_arr['department_name'] = $data['department_id']; $return_arr['position_name'] = $data['position_id']; $return_arr['company_name'] = $data['company_id']; $return_arr['dealer_name'] = $data['dealer_id']; } echo json_encode($return_arr); function replaceNull($s){ return ($s <> null ) ? $s : '' ; } ?>
| ver. 1.4 |
.
| PHP 8.1.32 | Generation time: 0 |
proxy
|
phpinfo
|
Settings