public function definition() { $err = false; global $USER, $cm, $course, $DB, $CFG; $location = praxe_get_location($this->locationid); $users = praxe_get_student_participants($cm->id); /// link back to list of locations - we will use it later $back = html_writer::link(new moodle_url(praxe_get_base_url(array('mode' => 'locations', 'schoolid' => 0))), get_string('back')); //if(praxe_get_use_status_of_location($location->id)) //var_dump(praxe_get_use_status_of_location($location->id)); //var_dump($location); if (!empty($location)) { $this->content_before_form .= html_writer::tag('p', get_string('assignstudtolocation_text', 'praxe')); $info = $location->name; if (strlen(trim($location->city))) { $info .= ", " . s($location->city); } if (strlen(trim($location->street))) { $info .= ", " . s($location->street); } $info = html_writer::tag('strong', $info); if (strlen(trim($location->subject))) { $info .= '<br>' . html_writer::tag('strong', s($location->subject)); } if (!is_null($location->teacherid)) { $info .= '<br>' . s($location->teacher_name) . ' ' . s($location->teacher_lastname); } $info .= '<br>' . praxe_get_term_text($location->term) . ' ' . $location->year; $this->content_before_form .= html_writer::tag('p', $info); // location is occupied $sql = "SELECT rec.* FROM {praxe_records} rec WHERE rec.location = ? AND rec.status != ?"; $params = array($this->locationid, PRAXE_STATUS_REFUSED); if ($ret = $DB->get_record_sql($sql, $params)) { $this->content .= html_writer::tag('div', get_string('location_is_not_available', 'praxe')); $this->content .= html_writer::tag('div', $back); /// location and users are available } else { if (is_array($users) && count($users)) { $form = '<form class="mform" action="' . praxe_get_base_url(array('locationid' => $this->locationid), 'assigntolocation') . '" method="post">'; $form .= '<input type="hidden" name="post_form" value="assigntolocation" />'; $form .= '<input type="hidden" name="sesskey" value="' . sesskey() . '" />'; $form .= '<input type="hidden" name="location" value="' . $this->locationid . '" />'; $select = '<select name="student">'; $select .= '<option value="null">' . get_string('select_student', 'praxe') . '</option>'; foreach ($users as $us) { $select .= '<option value="' . $us->id . '">' . s($us->firstname . ' ' . $us->lastname) . '</option>'; } $select .= '</select>'; $form .= html_writer::tag('div', html_writer::tag('label', get_string('student')) . html_writer::tag('div', $select), array('class' => 'frow')); /// option to send emails require_once $CFG->dirroot . "/lib/pear/HTML/QuickForm/checkbox.php"; $checks = ''; if (!is_null($location->teacherid)) { $check = new HTML_QuickForm_checkbox('sendemailtoextteacher', '', get_string('sendinfotoextteacher', 'praxe')); $checks .= html_writer::tag('div', $check->toHtml()); } $check = new HTML_QuickForm_checkbox('sendemailtostudent', '', get_string('sendinfotostudent', 'praxe'), 'checked'); $checks .= $check->toHtml(); $form .= html_writer::tag('div', html_writer::tag('label', get_string('informparticipants')) . html_writer::tag('div', $checks), array('class' => 'frow')); /// action buttons //$sub = '<div class="fitem center" style="margin: 10px 0;">' $sub = '<input type="submit" id="id_submitbutton" value="Submit" name="submitbutton" /> ' . '<input type="submit" id="id_cancel" onclick="skipClientValidation = true; return true;" value="Cancel" name="cancel" />'; //felement fsubmit $form .= html_writer::tag('div', $sub, array('class' => 'frow submit')); $form .= '</form>'; $this->content .= html_writer::tag('div', $form, array('class' => 'thin-form')); /// no students to be assigned to location } else { $table->data[] = array(get_string('nostudentsavailable', 'praxe')); $table->data[] = array($back); $table->align = array('center'); $this->content .= html_writer::table($table, true); } } } else { $this->content_before_form .= html_writer::tag('strong', get_string('notallowedaction', 'praxe')); $this->content .= $back; } }
/** * * @param string $schoolid * @param string $headmid * @param unknown $editlinkparams * @param number $bOnlyActual * @param number $year * @param array $aSort Associative array with column as key and ASC/DESC/null as value * @return Ambigous <string, lang_string>|string */ public static function show_locations($schoolid = null, $headmid = null, $editlinkparams = array(), $bOnlyActual = 0, $year = 0, $aSort = array()) { global $USER, $cm, $OUTPUT, $DB; $schoolid = $schoolid ? $schoolid : null; $sortAvailable = array('sschool' => 'name', 'sstudyfield' => 'studyfieldname', 'sisced' => 'isced', 'syear' => 'year', 'ssubject' => 'subject', 'sactive' => 'active'); $aSortcorrect = array_intersect(array_keys($sortAvailable), array_keys($aSort)); $sort = array(); foreach ($aSortcorrect as $k) { if (!is_null($aSort[$k])) { $sort[] = $sortAvailable[$k] . ' ' . $aSort[$k]; } } $locs = praxe_get_locations_by_schooldata($schoolid, $headmid, $bOnlyActual, $year, implode(', ', array_reverse($sort))); if (!$locs) { return get_string('nolocationsavailable', 'praxe'); } $defEnableAssignStudent = praxe_has_capability('assignstudenttolocation'); $table = new html_table(); $baseLink = praxe_get_base_url(array('mode' => 'locations', 'schoolid' => (int) $schoolid, 'fyearloc' => $year, 'factual' => $bOnlyActual)); $h = array(); $aHeadSorting = array('sschool' => get_string('school', 'praxe'), 'ssubject' => get_string('subject', 'praxe'), 'sactive' => get_string('active', 'praxe'), 'sstudyfield' => get_string('studyfield', 'praxe'), 'sisced' => get_string('iscedlevel', 'praxe'), 'syear' => get_string('year', 'praxe')); foreach ($aHeadSorting as $k => $text) { if (isset($aSort[$k])) { $toLink = $aSort[$k] == 'ASC' ? 'DESC' : 'ASC'; $sOut = $OUTPUT->action_link($baseLink . '&' . $k . '=' . $toLink, $text); $sOut .= $OUTPUT->pix_icon('t/sort_' . strtolower($aSort[$k]), $aSort[$k]); } else { $sOut = $OUTPUT->action_link($baseLink . '&' . $k . '=ASC', $text); } $aHeadSorting[$k] = $sOut; } $h[] = $aHeadSorting['sschool']; $h[] = $aHeadSorting['ssubject']; $h[] = get_string('extteacher', 'praxe'); $h[] = $aHeadSorting['sstudyfield']; $h[] = $aHeadSorting['sisced']; $h[] = $aHeadSorting['syear']; $h[] = get_string('term', 'praxe'); $h[] = get_string('actual_status', 'praxe'); $h[] = $aHeadSorting['sactive']; $h[] = get_string('student', 'praxe'); $table->head = $h; $table->align = array('left', 'left', 'left', 'left', 'left', 'center', 'center', 'left', 'center'); $table->data = array(); $stredit = get_string('edit'); foreach ($locs as $loc) { $editable = false; if (praxe_has_capability('manageallincourse') || praxe_has_capability('editanylocation') || praxe_has_capability('editownlocation') && ($USER->id == $loc->headmaster || $USER->id == $loc->teacherid)) { $editable = true; } $teacher = ''; if (!is_null($loc->teacherid)) { $teacher = praxe_get_user_fullname((object) array('id' => $loc->teacherid, 'firstname' => s($loc->teacher_name), 'lastname' => $loc->teacher_lastname)); } $stf = s($loc->studyfieldname) . ' (' . s($loc->shortcut) . ')'; $status = praxe_get_use_status_of_location($loc->id); $active = $loc->active == 1 ? get_string('yes') : get_string('no'); $row = array(s($loc->name), s($loc->subject), $teacher, $stf, praxe_get_isced_text($loc->isced), s($loc->year), praxe_get_term_text($loc->term), $status, $active); /// icon for assign student / student /// $sql = "SELECT p.*, s.firstname, s.lastname FROM {praxe_records} p LEFT JOIN {user} s ON (s.id = p.student)\n\t\t\t\t\tWHERE location = ?\n\t\t\t\t\tORDER BY timemodified DESC\n\t\t\t\t\tLIMIT 1"; $params = array($loc->id); if ($ret = $DB->get_record_sql($sql, $params)) { $row[] = praxe_get_user_fullname((object) array('id' => $ret->student, 'firstname' => $ret->firstname, 'lastname' => $ret->lastname)); $enableAssignStudent = $defEnableAssignStudent && $ret->status == PRAXE_STATUS_REFUSED; } else { $row[] = " "; $enableAssignStudent = $defEnableAssignStudent; } if ($editable || $enableAssignStudent) { $editRow = array(); $params = array('locationid' => $loc->id); foreach ($editlinkparams as $name => $val) { $params[s($name)] = s($val); } if ($editable) { $editRow[] = $OUTPUT->action_icon(praxe_get_base_url($params), new pix_icon('t/edit', $stredit)); } if ($enableAssignStudent) { $params['assignuser'] = 1; $editRow[] = $OUTPUT->action_icon(praxe_get_base_url($params, 'assigntolocation'), new pix_icon('i/users', get_string('assignusertolocation', 'praxe'))); } $row[] = implode(' ', $editRow); if (count($table->head) < count($row)) { $table->head[] = get_string('edit'); $table->align[] = 'center'; } } $row = new html_table_row($row); if ($loc->active != 1) { $row->attributes['class'] = 'praxe_noactive_location'; } $table->data[] = $row; } return html_writer::table($table); }
private function show_all_my_locations($bOnlyActual = 0, $year = 0) { global $USER, $CFG, $tab_modes, $DB, $OUTPUT; if (!($all = praxe_get_locations(null, null, null, $bOnlyActual, $year))) { return get_string('nolocationsavailable', 'praxe'); } $table = new html_table(); $strname = get_string('schoolname', 'praxe'); $strsubject = get_string('subject', 'praxe'); $strstudy = get_string('studyfield', 'praxe'); $strisced = get_string('iscedlevel', 'praxe'); $stryear = get_string('year', 'praxe'); $strterm = get_string('term', 'praxe'); $table->head = array($strname, $strsubject, $strisced, $strstudy, $stryear, $strterm, get_string('active', 'praxe'), get_string('edit')); $table->align = array('left', 'left', 'left', 'left', 'center', 'center', 'center'); $stredit = get_string('edit'); foreach ($all as $loc) { if ($loc->teacherid != $USER->id) { continue; } $row = array(s($loc->name), s($loc->subject), praxe_get_isced_text($loc->isced), s($loc->studyfieldname) . " (" . s($loc->shortcut) . ")"); $row[] = s($loc->year); $row[] = praxe_get_term_text($loc->term); $row[] = $loc->active == 1 ? get_string('yes') : get_string('no'); if (praxe_has_capability('editanylocation') || praxe_has_capability('editownlocation') && $USER->id == $loc->teacherid) { $row[] = $OUTPUT->action_icon(praxe_get_base_url(array("mode" => $tab_modes['extteacher'][PRAXE_TAB_EXTTEACHER_EDITLOCATION], "locationid" => $loc->id)), new pix_icon('t/edit', $stredit)); } else { $row[] = get_string('already_used', 'praxe'); } $table->data[] = $row; } if (count($table->data)) { return html_writer::table($table); } return get_string('nolocationsavailable', 'praxe'); }
$table->head = array(get_string('name'), get_string('description'), get_string('iscedlevel', 'praxe'), get_string('year', 'praxe'), get_string('term', 'praxe'), get_string('dateofpraxe', 'praxe'), get_string('numberofrecords', 'praxe'), get_string('participants') . " (" . get_string('groups') . ")"); $table->align = array('center', 'left', 'center', 'center', 'center', 'center', 'center', 'center'); foreach ($praxes as $praxe) { $records = $DB->get_records('praxe_records', array('praxe' => $praxe->id)); $numofrecords = count($records); if (!$praxe->visible) { $link = html_writer::link(new moodle_url('/mod/praxe/view.php', array('id' => $praxe->coursemodule)), format_string($praxe->name, true), array('class' => 'dimmed')); } else { $link = html_writer::link(new moodle_url('/mod/praxe/view.php', array('id' => $praxe->coursemodule)), format_string($praxe->name, true)); } $part = '0'; if (!empty($praxe->groupingid)) { $groups = $DB->get_records_sql("SELECT g.*\n \t\t\t\t\t\t\t\t\tFROM {groupings_groups} gg\n \t\t\t\t\t\t\t\t\tLEFT JOIN {groups} g on(groupid = g.id)\n \t\t\t\t\t\t\t\t\tWHERE groupingid = ?", array($praxe->groupingid)); $aPart = array(); foreach ($groups as $group) { $aPart[] = '<a href="' . $CFG->wwwroot . '/user/index.php?id=' . $course->id . '&group=' . $group->id . '">' . $group->name . '</a>'; } $part = implode(', ', $aPart); } $date = userdate($praxe->datestart, get_string('strftimedateshort')) . " - " . userdate($praxe->dateend, get_string('strftimedateshort')); $table->data[] = array($link, s($praxe->description), praxe_get_isced_text($praxe->isced), s($praxe->year), praxe_get_term_text($praxe->term), $date, $numofrecords, $part); /* if ($course->format == 'weeks' or $course->format == 'topics') { $table->data[] = array($praxe->section, $link); } else { $table->data[] = array($link); }*/ } echo $OUTPUT->heading(get_string('modulenameplural', 'praxe'), 2); echo html_writer::table($table); echo $OUTPUT->footer();