示例#1
0
 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;
 }