public function getClassroomForDropdown() { $res = array(); $res[0] = $this->lang->def('_NOT_ASSIGNED'); $query = "SELECT idClassroom, location, name" . " FROM %lms_class_location as loc JOIN " . $this->classroom_table . " AS cl " . " ON (loc.location_id = cl.location_id) "; if (Docebo::user()->getUserLevelId() !== ADMIN_GROUP_GODADMIN) { require_once _base_ . '/lib/lib.preference.php'; $adminManager = new AdminPreference(); $arr_locations = $adminManager->getAdminClasslocation(Docebo::user()->getIdst()); if (!empty($arr_locations)) { $query .= " WHERE loc.location_id IN (" . implode(",", $arr_locations) . ") "; } else { return $res; } } $query .= " ORDER BY location, name"; $result = sql_query($query); while (list($id_classroom, $location, $name) = sql_fetch_row($result)) { $res[$id_classroom] = '<b>' . $location . '</b> - ' . $name; } return $res; }