Request Settings
Home
Request Settings
Request Settings
Level 1 Approver
return_result("SELECT `employee_id`, (SELECT concat(employee_id, ' - ',first_name,' ',middle_name,' ',last_name) as name FROM `employee` WHERE id=ra.`employee_id`) as name FROM `sms_service_approver` ra WHERE `request_type_id` = '1' "); foreach($level_1 as $data){ echo "
".$data['name']."
"; } ?>
Level 2 Approver
return_result("SELECT `employee_id`, (SELECT concat(employee_id, ' - ',first_name,' ',middle_name,' ',last_name) as name FROM `employee` WHERE id=ra.`employee_id`) as name FROM `sms_service_approver` ra WHERE `request_type_id` = '2' "); foreach($level_2 as $data){ echo "
".$data['name']."
"; } ?>