public function __construct($record)
 {
     global $DB;
     parent::__construct($record);
     $this->course = $DB->get_record_sql('SELECT c.id, c.enablecompletion, c.cacherev, c.startdate
                     FROM {badge} b INNER JOIN {course} c ON b.courseid = c.id
                     WHERE b.id = :badgeid ', array('badgeid' => $this->badgeid), MUST_EXIST);
     $this->courseid = $this->course->id;
 }
 public function __construct($record)
 {
     global $DB;
     parent::__construct($record);
     $course = $DB->get_record_sql('SELECT b.courseid, c.startdate
                     FROM {badge} b INNER JOIN {course} c ON b.courseid = c.id
                     WHERE b.id = :badgeid ', array('badgeid' => $this->badgeid));
     $this->courseid = $course->courseid;
     $this->coursestartdate = $course->startdate;
 }
 public function __construct($record)
 {
     parent::__construct($record);
     $this->courseid = self::get_course();
 }