course_format_iena_attendance.php 1.65 KB
Newer Older
Thomas Fradet's avatar
folder  
Thomas Fradet committed
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66
<?php

// This file is part of Moodle - http://moodle.org/
//
// Moodle is free software: you can redistribute it and/or modify
// it under the terms of the GNU General Public License as published by
// the Free Software Foundation, either version 3 of the License, or
// (at your option) any later version.
//
// Moodle is distributed in the hope that it will be useful,
// but WITHOUT ANY WARRANTY; without even the implied warranty of
// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
// GNU General Public License for more details.
//
// You should have received a copy of the GNU General Public License
// along with Moodle.  If not, see <http://www.gnu.org/licenses/>.

/**
 *
 * course_format_iena_sections
 *
 * @package    format_iena
 * @category   format
 * @copyright  2018 Softia/Université lorraine
 * @author     Thomas Fradet
 * @license    http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later
 */
class course_format_iena_attendance
{

	/**
	 * @param $id_course
	 * @return array
	 * @throws dml_exception
	 */
	public function get_attendance_sessions($course_id) {


		global $DB;
			// -- FROM {attendance_sessions} 
		// $DB->set_debug(true);
		$res = $DB->get_records_sql('SELECT sessdate, att_sess.id, duration, groupid 
			FROM {attendance_sessions} as att_sess
			INNER JOIN {attendance} as att on att_sess.attendanceid = att.id
			WHERE att.course = ?'
			, array($course_id));

		return $res;
		// $groups = array();
		// $i = 0;
		// foreach ($requete as $value) {
		// 	$group = new course_format_iena_groups();
		// 	$group->get_group_by_id_group($value->id);
		// 	$groups[$i] = $group;
		// 	$i++;
		// }

		// return $groups;


	}




}