function definition() { global $USER, $CFG, $DB, $PAGE; $mform = $this->_form; $mform->addElement('header', 'settingsheader', get_string('system_settings', 'local_cobaltsettings')); $hier1 = new hierarchy(); $schoolids = $hier1->get_assignedschools(); if (!empty($schoolids)) { $count = sizeof($schoolids); if ($count > 1) { $parents = $hier1->get_school_parent($schoolids, '', true); $attributes1 = 'style="height:25px; width:29%; "'; $mform->addElement('select', 'schoolid', get_string('schoolid', 'local_collegestructure'), $parents, $attributes1); $mform->addRule('schoolid', get_string('missingschool', 'local_collegestructure'), 'required', null, 'client'); } else { $schoolname = $DB->get_record('local_school', array('id' => $schoolids[0]->id)); $mform->addElement('static', 'sid', get_string('select', 'local_collegestructure'), $schoolname->fullname); $mform->addElement('hidden', 'schoolid', $schoolids[0]->id); } } $mform->addElement('advcheckbox', 'batch', null, 'Batch', array('group' => 1), array(0, 1)); $mform->addElement('html', '<div style=" margin-left:265px;" class="form-description"><p>' . get_string('enable_batch', 'local_cobaltsettings') . ' </p></div>'); $mform->addElement('advcheckbox', 'prefix_suffix', null, 'Prefix-Suffix', array('group' => 1), array(0, 1)); $mform->addElement('html', '<div style=" margin-left:265px;" class="form-description"><p>' . get_string('create_batch', 'local_cobaltsettings') . ' </p></div>'); $mform->addElement('advcheckbox', 'online_app', null, 'Online Applications', array('group' => 1), array(0, 1)); $mform->addElement('html', '<div style=" margin-left:265px; color:light-grey" class="form-description"><p>' . get_string('enable_online', 'local_cobaltsettings') . ' </p></div>'); $mform->addElement('advcheckbox', 'certificate', null, 'Issue certificates', array('group' => 1), array(0, 1)); /* start of vijaya jan-29 */ $mform->addElement('advcheckbox', 'onlinepayment', null, 'Online Payment', array('group' => 1), array(0, 1)); /* end of vijaya jan-29 */ $this->add_action_buttons(true, 'Submit'); }
function user_download_xls($fields) { global $CFG, $DB; require_once("$CFG->libdir/excellib.class.php"); $filename = clean_filename(get_string('course', 'local_cobaltcourses') . '.xls'); $workbook = new MoodleExcelWorkbook('-'); $workbook->send($filename); $worksheet = array(); $worksheet[0] = $workbook->add_worksheet(''); $col = 0; foreach ($fields as $fieldname) { $worksheet[0]->write(0, $col, $fieldname); $col++; } $hierarchy = new hierarchy(); $schoollist = $hierarchy->get_assignedschools(); if (is_siteadmin()) { $schoollist = $hierarchy->get_school_items(); } $sheetrow = 1; foreach ($schoollist as $school) { $courses = $DB->get_records('local_cobaltcourses', array('schoolid' => $school->id)); foreach ($courses as $course) { $post = new stdclass(); $post->fullname = $course->fullname; $post->shortname = $course->shortname; $departmentname = $DB->get_field('local_department', 'fullname', array('id' => $course->departmentid)); $post->courselibraryname = $departmentname; $schoolname = $DB->get_field('local_school', 'fullname', array('id' => $course->schoolid)); $post->organizationname = $schoolname; $post->summary = $course->summary; $post->coursetype = ($course->coursetype == 0) ? 'General' : 'Elective'; $post->credithours = $course->credithours; $post->coursecost = $course->coursecost; $col = 0; foreach ($fields as $fieldname) { $worksheet[0]->write($sheetrow, $col, $post->$fieldname); $col++; } $sheetrow++; } } $workbook->close(); die; }
public function definition() { global $CFG, $DB; $mform = & $this->_form; $hierarchy = new hierarchy(); if (is_siteadmin()) { $scho = $hierarchy->get_school_items(); } else { $scho = $hierarchy->get_assignedschools(); } $count = count($scho); if ($count > 1) { $school = $hierarchy->get_school_parent($scho); $mform->addElement('select', 'schoolid', get_string('schoolid', 'local_collegestructure'), $school); $mform->addRule('schoolid', get_string('required'), 'required', null, 'client'); } else { $school = $DB->get_record('local_school', array('visible' => 1)); $mform->addElement('static', 'school', get_string('schoolid', 'local_collegestructure'), $school->fullname); $mform->setType('school', PARAM_RAW); $mform->addElement('hidden', 'schoolid', $school->id); $mform->setType('schoolidid', PARAM_INT); } for ($i = 0; $i <= 23; $i++) { $hours[$i] = sprintf("%02d", $i); } for ($i = 0; $i < 60; $i+=5) { $minutes[$i] = sprintf("%02d", $i); } $durtime = array(); $durtime[] = & $mform->createElement('select', 'starthours', get_string('hour', 'form'), $hours, false, true); $durtime[] = & $mform->createElement('select', 'startminutes', get_string('minute', 'form'), $minutes, false, true); $mform->addGroup($durtime, 'starttime', get_string('starttime', 'local_attendance'), array(' '), true); $durtimes = array(); $durtimes[] = & $mform->createElement('select', 'endhours', get_string('hour', 'form'), $hours, false, true); $durtimes[] = & $mform->createElement('select', 'endminutes', get_string('minute', 'form'), $minutes, false, true); $mform->addGroup($durtimes, 'endtime', get_string('orgendtime', 'local_attendance'), array(' '), true); $mform->addElement('hidden', 'id'); $mform->setType('id', PARAM_INT); $submit = ($this->_customdata['id'] > 0) ? 'Update' : 'Create'; $this->add_action_buttons('false', $submit); }
function user_download_xls($fields) { global $CFG, $DB; require_once("$CFG->libdir/excellib.class.php"); $filename = clean_filename(get_string('department', 'local_departments') . '.xls'); $workbook = new MoodleExcelWorkbook('-'); $workbook->send($filename); $worksheet = array(); $worksheet[0] = $workbook->add_worksheet(''); $col = 0; foreach ($fields as $fieldname) { $worksheet[0]->write(0, $col, $fieldname); $col++; } $hierarchy = new hierarchy(); /* Bug report #260 * Edited by hemalatha c arun <*****@*****.**> * resolved- If loggedin user is admin, downloading all the department */ if (is_siteadmin()) { $sql = "SELECT distinct(s.id),s.* FROM {local_school} s ORDER BY s.sortorder"; $schoollist = $DB->get_records_sql($sql); } else $schoollist = $hierarchy->get_assignedschools(); $sheetrow = 1; foreach ($schoollist as $school) { $departments = $DB->get_records('local_department', array('schoolid' => $school->id)); foreach ($departments as $department) { $post = new stdclass(); $post->shortname = $department->shortname; $post->fullname = $department->fullname; $schoolname = $DB->get_field('local_school', 'fullname', array('id' => $department->schoolid)); $post->schoolname = $schoolname; $post->summary = $department->description; $col = 0; foreach ($fields as $fieldname) { $worksheet[0]->write($sheetrow, $col, $post->$fieldname); $col++; } $sheetrow++; } } $workbook->close(); die; }
function user_download_xls($fields) { $hier = new hierarchy(); $schools = $hier->get_assignedschools(); global $CFG, $DB; require_once("$CFG->libdir/excellib.class.php"); $filename = clean_filename('Users.xls'); $workbook = new MoodleExcelWorkbook('-'); $workbook->send($filename); $worksheet = array(); $worksheet[0] = $workbook->add_worksheet(''); $col = 0; foreach ($fields as $fieldname) { $worksheet[0]->write(0, $col, $fieldname); $col++; } $sheetrow = 1; $myuser = users::getInstance(); $users = $DB->get_records_sql("SELECT u.id, u.username, u.email, u.firstname, u.lastname, u.city, u.country, u.lastaccess, u.confirmed, u.mnethostid, u.suspended FROM {user} u, {local_users} lu WHERE lu.userid = u.id "); foreach ($users as $user) { $rid = $myuser->get_rolename($user->id); $post = new stdclass(); $post->firstname = $user->firstname; $post->lastname = $user->lastname; $post->email = $user->email; $post->schoolname = $myuser->get_schoolnames($user); $post->roleid = $myuser->get_rolename($user->id); $col = 0; foreach ($fields as $fieldname) { $worksheet[0]->write($sheetrow, $col, $post->$fieldname); $col++; } $sheetrow++; } $workbook->close(); die; }
function definition() { global $USER, $CFG, $DB, $PAGE; $mform = $this->_form; $mform->addElement('header', 'settingsheader', get_string('addeditgradeletter', 'local_gradesubmission')); $PAGE->requires->yui_module('moodle-local_gradesubmission-heirarchyselector', 'M.local_gradesubmission.init_heirarchyselector', array(array('formid' => $mform->getAttribute('id')))); $id = $this->_customdata['id']; $disable = ($id > 0) ? 'disabled="disabled"' : ''; $hierarchy = new hierarchy(); $schools = $hierarchy->get_assignedschools(); $count = count($schools); if ($count > 1) { $parents = $hierarchy->get_school_parent($schools); $mform->addElement('select', 'schoolid', get_string('schoolid', 'local_collegestructure'), $parents, $disable); if ($id < 0) { $mform->addRule('schoolid', get_string('missingschool', 'local_collegestructure'), 'required', null, 'client'); } $mform->setType('schoolid', PARAM_INT); } else { $school_name = $DB->get_record('local_school', array('id' => $schools[0]->id)); $mform->addElement('static', 'schid', get_string('schoolid', 'local_collegestructure'), $school_name->fullname); $mform->addElement('hidden', 'schoolid', $schools[0]->id); $mform->setType('schoolid', PARAM_INT); } $mform->registerNoSubmitButton('updatecourseformat'); $mform->addElement('submit', 'updatecourseformat', get_string('courseformatudpate')); $mform->addElement('hidden', 'addprogramslisthere'); $mform->setType('addprogramslisthere', PARAM_INT); $mform->addElement('hidden', 'addsemesterslisthere'); $mform->setType('addsemesterslisthere', PARAM_INT); $mform->addElement('hidden', 'addclclasseslisthere'); $mform->setType('addclclasseslisthere', PARAM_INT); $mform->addElement('hidden', 'id'); $mform->setType('id', PARAM_INT); $this->add_action_buttons(); }
function user_download_xls($fields) { global $CFG, $DB; require_once("$CFG->libdir/excellib.class.php"); $filename = clean_filename(get_string('program', 'local_programs') . '.xls'); $workbook = new MoodleExcelWorkbook('-'); $workbook->send($filename); $worksheet = array(); $worksheet[0] = $workbook->add_worksheet(''); $col = 0; foreach ($fields as $fieldname) { $worksheet[0]->write(0, $col, $fieldname); $col++; } $hierarchy = new hierarchy(); $schoollist = $hierarchy->get_assignedschools(); $sheetrow = 1; foreach ($schoollist as $school) { $programs = $DB->get_records('local_program', array('schoolid' => $school->id)); foreach ($programs as $program) { $post = new stdclass(); $post->shortname = $program->shortname; $post->fullname = $program->fullname; $departmentname = $DB->get_field('local_department', 'fullname', array('id' => $program->departmentid)); $post->departmentname = $departmentname; $schoolname = $DB->get_field('local_school', 'fullname', array('id' => $program->schoolid)); $post->schoolname = $schoolname; $post->summary = $program->description; $post->type = ($program->type == 0) ? 'UnderGraduate' : 'PostGraduate'; $post->duration = $program->duration; $col = 0; foreach ($fields as $fieldname) { $worksheet[0]->write($sheetrow, $col, $post->$fieldname); $col++; } $sheetrow++; } } $workbook->close(); die; }
$d_event['description'] = $data->description; $d_event['userid'] = $USER->id; $d_event['eventtype'] = $data->activityname; $d_event['timestart'] = $data->startdate; $d_event['timemodified'] = $today; $d_event['visible'] = $data->publish; $data->visble = $data->publish; $data->userid = $USER->id; $data->timecreated = time(); $data->timemodified = time(); if (isset($data->eventlevel) && $data->eventlevel == 1 && $data->eventtypeid == 1) { if (is_siteadmin($USER)) { $faculties = $DB->get_records('local_school', array('visible' => 1)); } else { $faculties = $hierarchy->get_assignedschools(); } foreach ($faculties as $faculty) { $programlist = $DB->get_records('local_program', array('schoolid' => $faculty->id, 'visible' => 1)); foreach ($programlist as $program) { $data->schoolid = $program->schoolid; $data->programid = $program->id; $eventid = $acalendar->event_add_instance($data); $d_event['uuid'] = $eventid; $acalendar->devent_add($d_event); } } $options = array('style' => 'notifysuccess'); $hierarchy->set_confirmation(get_string('eventsuccess', 'local_academiccalendar'), $returnurl, $options);
public function definition() { global $CFG, $DB, $PAGE; $mform = & $this->_form; $schoolid = $this->_customdata['sid']; $PAGE->requires->yui_module('moodle-local_classroomresources-building', 'M.local_classroomresources.init_building', array(array('formid' => $mform->getAttribute('id')))); $PAGE->requires->yui_module('moodle-local_classroomresources-floor', 'M.local_classroomresources.init_floor', array(array('formid' => $mform->getAttribute('id')))); $PAGE->requires->yui_module('moodle-local_classroomresources-classroom', 'M.local_classroomresources.init_classroom', array(array('formid' => $mform->getAttribute('id')))); $c = 'class="one";style="border:none";readonly="readonly";'; $hierarchy = new hierarchy(); if (is_siteadmin()) { $scho = $hierarchy->get_school_items(); } else { $scho = $hierarchy->get_assignedschools(); } $count = count($scho); $school = $hierarchy->get_school_parent($scho); $this->_customdata['id']; if ($this->_customdata['id'] > 0) { $mform->addElement('static', 'schoolid', get_string('schoolname', 'local_collegestructure')); $mform->setType('schoolid', PARAM_RAW); $mform->addElement('text', 'buildingid', get_string('buildingname', 'local_classroomresources'), $c); $mform->setType('buildingid', PARAM_RAW); $mform->addElement('text', 'floorid', get_string('floorname', 'local_classroomresources'), $c); $mform->setType('floorid', PARAM_RAW); $mform->addElement('text', 'classroomid', get_string('classroomid', 'local_classroomresources'), $c); $mform->setType('classroomid', PARAM_RAW); $resource = cobalt_resources::get_instance(); $resourcelist = $hierarchy->get_records_cobaltselect_menu('local_resource', "schoolid=$schoolid AND visible=1", null, '', 'id,fullname', get_string('select', 'local_classroomresources')); $select = $mform->addElement('select', 'resourceid', get_string('resourceid', 'local_classroomresources'), $resourcelist); $select->setMultiple(true); } else { $mform->addElement('select', 'schoolid', get_string('schoolid', 'local_collegestructure'), $school); $mform->addRule('schoolid', get_string('required'), 'required', null, 'client'); $mform->addElement('hidden', 'beforefloor'); $mform->setType('beforefloor', PARAM_RAW); $mform->addElement('hidden', 'beforeclass'); $mform->setType('beforeclass', PARAM_RAW); $mform->addElement('hidden', 'beforeresource'); $mform->setType('beforeresource', PARAM_RAW); $mform->addElement('hidden', 'beforer'); $mform->setType('beforer', PARAM_RAW); $mform->registerNoSubmitButton('updatecourseformat'); $mform->addElement('submit', 'updatecourseformat', get_string('courseformatudpate')); } $mform->addElement('hidden', 'id'); $mform->setType('id', PARAM_INT); $submit = ($this->_customdata['id'] > 0) ? 'Update' : 'Assign Resources'; $this->add_action_buttons('false', $submit); }
$PAGE->navbar->add(get_string('listdepts', 'local_departments')); //-------------manage_dept heading------------------------ echo $OUTPUT->heading(get_string('dept_heading', 'local_departments')); echo $OUTPUT->header(); try { $dept = $DB->get_record('local_department', array('id' => $id)); $PAGE->set_title(get_string('department', 'local_departments') . ': ' . $dept->fullname); //Heading of the page echo $OUTPUT->heading($dept->fullname); //Semester Name //------------if registrar not assigned to any school it throws exception $hier1 = new hierarchy(); $schoolid = $hier1->get_assignedschools(); if (empty($schoolid)) { $e = get_string('rnot_assigned', 'local_departments'); throw new Exception($e); } $data[] = array('<b>' . get_string('deptid', 'local_departments') . '</b>', $dept->shortname); $schoolname = $DB->get_record('local_school', array('id' => $dept->schoolid)); $data[] = array('<b>' . get_string('belongs', 'local_departments') . '</b>', $schoolname->fullname . 'school'); // list of assigned school for the perticular department $school_list = $DB->get_records('local_assignedschool_dept', array('deptid' => $dept->id)); if (!empty($school_list)) { $school_name = ''; foreach ($school_list as $sl) { $sn = $DB->get_record('local_school', array('id' => $sl->assigned_schoolid));
function definition() { global $USER, $CFG, $DB, $PAGE; $mform = $this->_form; //------used for editing purpose(used to put static schoolname and shortname) $eid = $this->_customdata['temp']; //-------used for adding department from college structure plugin or other plugin $schoolid_collegestruct = $this->_customdata['scid']; /* Bug-id #262 * @author hemalatha c arun <*****@*****.**> * resolved -string issue */ if ($eid->id > 0) { $mform->addElement('header', 'editheader', get_string('edit_department', 'local_departments')); $mform->addHelpButton('editheader', 'deptnote', 'local_departments'); } else { // get_string('create_note','local_departments'); $mform->addElement('header', 'createheader', get_string('create_department', 'local_departments')); $mform->addHelpButton('createheader', 'deptnote', 'local_departments'); } $attributes = 'style="height:30px; "'; //------used for editing purpose(used to put static schoolname ) if ($eid->id > 0) { $school = $DB->get_record('local_school', array('id' => $eid->schoolid)); $mform->addElement('static', 'esid', get_string('schoolid', 'local_collegestructure'), $school->fullname); } else { $hier = new hierarchy(); if (is_siteadmin($USER->id)) { $schoolids = $DB->get_records('local_school', array('visible' => 1)); } else $schoolids = $hier->get_assignedschools(); $count = sizeof($schoolids); if ($count > 1) { // $items = $hier->get_school_items(); $parents = $hier->get_school_parent($schoolids, '', true); //$attributes1='style="height:30px; width:29%; "'; $mform->addElement('select', 'schoolid', get_string('schoolid', 'local_collegestructure'), $parents); $mform->addRule('schoolid', get_string('missingschool', 'local_collegestructure'), 'required', null, 'client'); if ($schoolid_collegestruct > 0) $mform->setDefault('schoolid', $schoolid_collegestruct); } else { foreach($schoolids as $sid){ $schoolid=$sid->id; $schoolname=$sid->fullname; } $mform->addElement('static', 'sid', get_string('schoolid', 'local_collegestructure'), $schoolname); $mform->addElement('hidden', 'schoolid', $schoolid); } } $mform->setType('schoolid', PARAM_INT); $mform->addElement('text', 'fullname', get_string('deptfullname', 'local_departments'), $attributes); $mform->addRule('fullname', get_string('missing_deptfullname', 'local_departments'), 'required', null, 'client'); $mform->setType('fullname', PARAM_RAW); $mform->addHelpButton('fullname', 'fullname_note', 'local_departments'); //-----used to put static shortname while editing--------- if ($eid->id > 0) { $mform->addElement('static', 'eshortname', get_string('deptid', 'local_departments'), $eid->shortname); } else { $mform->addElement('text', 'shortname', get_string('deptid', 'local_departments'), $attributes); $mform->addRule('shortname', get_string('missing_deptid', 'local_departments'), 'required', null, 'client'); $mform->setType('shortname', PARAM_TEXT); $mform->addHelpButton('shortname', 'shortname_note', 'local_departments'); } //$mform->addElement('textarea', 'description', get_string("description", "local_departments"), 'wrap="virtual" rows="6" cols="150"',$attributes); //$mform->setType('description', PARAM_TEXT); $mform->addElement('editor', 'description', get_string("description", "local_departments")); $mform->setType('description', PARAM_RAW); $mform->addElement('hidden', 'id'); $mform->setType('id', PARAM_INT); $submitbuttonname = ($eid->id > 0) ? 'update_department' : 'create_department'; $this->add_action_buttons(true, get_string($submitbuttonname, 'local_departments')); }
$context =context_user::instance($USER->id); if (has_capability('local/clclasses:enrollclass', $context) && !is_siteadmin()) { echo $OUTPUT->heading(get_string('myacademics', 'local_courseregistration')); } else { echo $OUTPUT->heading(get_string('pluginname', 'local_academiccalendar')); } if (is_siteadmin($USER)) { $admin_school = $DB->get_records('local_school'); if (empty($admin_school)) throw new schoolnotfound_exception(); } if (!is_siteadmin($USER)) { if (has_capability('local/collegestructure:manage', $systemcontext)) { $assigned_schools = $hierarchy->get_assignedschools(); foreach ($assigned_schools as $assigned_school) { if ($assigned_school->id != null) { $aschools[] = $assigned_school->id; } } $schoollist = implode(',', $aschools); empty($schoollist) ? $schoollist = 0 : $schoollist; empty($sql) ? $sql .=' ((eventlevel=1) OR (schoolid in (' . $schoollist . ')))' : $sql .=' AND ((eventlevel=1) OR (schoolid in (' . $schoollist . ')))'; } elseif (has_capability('local/clclasses:enrollclass', $usercontext)) { $userdetails = $DB->get_records('local_userdata', array('userid' => $USER->id)); $usersems = $DB->get_records('local_user_semester', array('userid' => $USER->id));
public function definition() { global $CFG, $DB, $PAGE, $USER; $mform = & $this->_form; $hierarchy = new hierarchy(); $id = $this->_customdata['id']; $deptid = $this->_customdata['deptid']; $schoid = $this->_customdata['schoid']; $semid = $this->_customdata['semid']; $courseid = $this->_customdata['courseid']; $classid = $this->_customdata['classid']; $classtype = $this->_customdata['classtype']; // remove empty value in classtype if ($classtype) { foreach ($classtype as $key => $value) { if ($value == 0) unset($classtype[$key]); } } if (isset($classid)) $classinfo = $DB->get_record('local_clclasses', array('id' => $classid, 'visible' => 1)); $deptid = (isset($classinfo->departmentid) ? $classinfo->departmentid : 0); $schoolid = (isset($classinfo->schoolid) ? $classinfo->schoolid : 0); $semid = (isset($classinfo->semesterid) ? $classinfo->semesterid : 0); $id = $this->_customdata['id']; //$PAGE->requires->yui_module('moodle-local_clclasses-chooser', 'M.local_clclasses.init_chooser', array(array('formid' => $mform->getAttribute('id')))); $PAGE->requires->yui_module('moodle-local_timetable-timetable', 'M.local_timetable.init_timetable', array(array('formid' => $mform->getAttribute('id')))); $PAGE->requires->js('/local/timetable/unassign_type.js'); $hierarchy = new hierarchy(); if (is_siteadmin()) { $scho = $hierarchy->get_school_items(); } else { $scho = $hierarchy->get_assignedschools(); } $count = count($scho); $school = $hierarchy->get_school_parent($scho); $mform->addElement('select', 'schoolid', get_string('schoolid', 'local_collegestructure'), $school); $mform->addRule('schoolid', get_string('missingschool', 'local_collegestructure'), 'required', null, 'client'); $mform->setType('schoolid', PARAM_RAW); $mform->setDefault('schoolid', $classinfo->schoolid); $mform->registerNoSubmitButton('updatecourseformat'); $mform->addElement('submit', 'updatecourseformat', get_string('courseformatudpate')); $mform->addElement('hidden', 'addsemesterlisthere'); $mform->setType('addsemesterlisthere', PARAM_RAW); $mform->addElement('hidden', 'addclasslisthere'); $mform->setType('addclasslisthere', PARAM_RAW); // adding classtype $mform->addElement('header', 'settingsheader', get_string('classtype', 'local_timetable')); $classtypes = $DB->get_records_menu('local_class_scheduletype', array('schoolid' => $schoolid,'visible'=>1), '', 'id, classtype'); if(sizeof($classtypes) > 0 ){ $string_cltype = array('Select classtype', '-1' => 'All'); $final_classtype = $string_cltype + $classtypes; } else { $string_cltype = array('Select classtype'); $final_classtype=$string_cltype + $classtypes; } if ($classid) { $select = $mform->addElement('select', 'classtype', get_string('classtype', 'local_timetable'), $final_classtype); $select->setMultiple(true); $mform->setType('classtype', PARAM_INT); $mform->addRule('classtype', get_string('required'), 'required', null, 'client'); } $mform->addElement('html', '<a id="newclasstype" style="float:right;margin-right: 240px;cursor:pointer;" onclick="newclasstype(' . $schoolid . ')">' . get_string('classtype', 'local_timetable') . '</a>'); $mform->addElement('html', '<div id="createclasstype"></div>'); $mform->addElement('html', '<div id="myratings1"></div>'); $mform->registerNoSubmitButton('scheduleclasstype'); $mform->addElement('submit', 'scheduleclasstype', get_string('scheduleclasstype', 'local_timetable')); $scheduleclass = cobalt_scheduleclass::get_instance(); $hour = $scheduleclass->hour(); $min = $scheduleclass->min(); $starttime = array(); $endtime = array(); /* Start of scheduleclass startdate */ //providing semester startdate and enddate helpful to select date if ($semid) { $seminfo = $DB->get_record('local_semester', array('id' => $semid)); $seminfo->startdate = date('d M Y', $seminfo->startdate); $seminfo->enddate = date('d M Y', $seminfo->enddate); $mform->addElement('static', 'datedescription', '', get_string('classschedule_datedescription', 'local_clclasses', $seminfo)); } if ($classtype && $classinfo) $this->reapeat_schedulecontent_basedon_type($classtype, $classinfo); /* Bug Report #276 * @author hemalatha c arun<*****@*****.**> * Resolved- if classrom created under the online course, no need to display classroom dropdown box */ // if ($DB->record_exists('local_clclasses', array('id' => $classid, 'online' => 1))) { // // } else { // $classroom = $hierarchy->get_records_cobaltselect_menu('local_classroom', "schoolid=$schoid AND visible=1", null, '', 'id,fullname', '--Select--'); // //$classroom=1; // $mform->addElement('select', 'classroomid', get_string('classroomids', 'local_classroomresources'), $classroom); // if (count($classroom) <= 1) { // $navigationlink = $CFG->wwwroot . '/local/classroomresources/classroom.php?linkschool=' . $schoid . ''; // $navigationmsg = get_string('navigation_info', 'local_collegestructure'); // $linkname = get_string('createclassroom', 'local_classroomresources'); // $mform->addElement('static', 'classroomids_empty', '', $hierarchy->cobalt_navigation_msg($navigationmsg, $linkname, $navigationlink, 'margin-bottom: -15px; //line-height: 0px;')); // } // $mform->addRule('classroomid', get_string('required'), 'required', null, 'client'); // } /* Start of hidden fields */ $time = time(); $user = $USER->id; $mform->addElement('hidden', 'timecreated', $time); $mform->setType('timecreated', PARAM_INT); $mform->addElement('hidden', 'timemodified', $time); $mform->setType('timemodified', PARAM_INT); $mform->addElement('hidden', 'usermodified', $user); $mform->setType('usermodified', PARAM_INT); $mform->addElement('hidden', 'departmentid', $deptid); $mform->setType('departmentid', PARAM_INT); // $mform->addElement('hidden', 'schoid', $schoid); $mform->setType('schoid', PARAM_INT); $mform->addElement('hidden', 'deptid', $deptid); $mform->setType('deptid', PARAM_INT); // // $mform->addElement('hidden', 'schoolid', $schoid); // $mform->setType('schoolid', PARAM_INT); // $mform->addElement('hidden', 'semesterid', $semid); // $mform->setType('semesterid', PARAM_INT); //$mform->addElement('hidden', 'semid', $semid); //$mform->setType('semid', PARAM_INT); $mform->addElement('hidden', 'courseid', $courseid); $mform->setType('courseid', PARAM_INT); //$mform->addElement('hidden', 'classid', $classid); //$mform->setType('classid', PARAM_INT); /* Start of hidden id field */ $mform->addElement('hidden', 'id'); $mform->setType('id', PARAM_INT); /* Start of action buttons */ $actionbutton = ($id > 0) ? get_string('scheduleclassroom', 'local_clclasses') : get_string('scheduleclassroom', 'local_clclasses'); $this->add_action_buttons($cancel = true, $actionbutton); }
/** * @method check_loginuser_registrar_admin * @todo to display school list based logged in user (registrar, admin) * * @param boolean $schoolids_in_formofstring (used to get schoolids in the form of string) * @return based on condition it returns array of objects or string type of data */ public function check_loginuser_registrar_admin($schoolids_in_formofstring = false) { global $DB, $USER, $CFG; $hier1 = new hierarchy(); // checking of login user is admin.. if (is_siteadmin($USER->id)) { $schoolid = $DB->get_records('local_school', array('visible' => 1)); } else { //------------if registrar not assigned to any school it throws exception $users = $hier1->get_manager(); $schoolid = $hier1->get_assignedschools(); } // end of else if (empty($schoolid)) { throw new schoolnotfound_exception(); } if ($schoolids_in_formofstring) { foreach ($schoolid as $sid) { $temp[] = $sid->id; } $school_id = implode(',', $temp); return $school_id; } else return $schoolid; }
/** * @method get_users_listing * @todo to get user list of school based on condition * @param string $sort fieldname * @param string $dir specify the order to sort * @param int $page page number * @param int $recordsperpage records perpage * @param string $extraselect extra condition to select user * @param array $extraparams * @return array of objects , list of users */ function get_users_listing($sort = 'lastaccess', $dir = 'ASC', $page = 0, $recordsperpage = 0, $extraselect = '', array $extraparams = null, $extracontext = null) { global $DB, $CFG; $extraselect; $select = "deleted <> 1 AND id <> :guestid"; //$select = "deleted=0"; $params = array('guestid' => $CFG->siteguest); if ($extraselect) { $select .= " AND $extraselect"; $params = $params + (array) $extraparams; } // If a context is specified, get extra user fields that the current user // is supposed to see. $extrafields = ''; if ($extracontext) { $extrafields = get_extra_user_fields_sql($extracontext, '', '', array('id', 'username', 'email', 'firstname', 'lastname', 'city', 'country', 'lastaccess', 'confirmed', 'mnethostid')); } /* * ###Bugreport#183-Filters * @author Naveen Kumar<*****@*****.**> * (Resolved) Added $select parameters for conditions */ // warning: will return UNCONFIRMED USERS // print_object($params); $users = $DB->get_records_sql("SELECT * FROM {user} WHERE $select", $params); $hierarchy = new hierarchy(); $schoollist = $hierarchy->get_assignedschools(); $schoollist = $hierarchy->get_school_parent($schoollist, $selected = array(), $inctop = false, $all = false); if (is_siteadmin()) { $schoollist = $hierarchy->get_school_items(); } $schoolidin = implode(',', array_keys($schoollist)); if ($users && $schoollist) { $useridin = implode(',', array_keys($users)); return $DB->get_records_sql("select user.* from (SELECT u.id, u.username, u.email, u.firstname, u.lastname, u.city, u.country, u.lastaccess, u.confirmed, u.mnethostid, u.suspended FROM {user} u JOIN {local_users} lu ON lu.userid = u.id JOIN {local_school_permissions} sp ON sp.userid = u.id WHERE u.id in ($useridin) AND sp.schoolid IN ($schoolidin) UNION SELECT u.id, u.username, u.email, u.firstname, u.lastname, u.city, u.country, u.lastaccess, u.confirmed, u.mnethostid, u.suspended FROM {user} u JOIN {local_users} lu ON lu.userid = u.id JOIN {local_userdata} ud ON ud.userid = u.id WHERE u.id in ($useridin) AND ud.schoolid IN ($schoolidin)) user GROUP BY user.id ORDER BY user.$sort $dir LIMIT $page, $recordsperpage "); } }
$semester = student_semesters($USER->id, 'courseregistration'); // print_object($semester); foreach ($semester as $key => $value) { $current_semid = $key; } if (empty($current_semid)) print_error(get_string('noactivesem', 'local_timetable')); $sessionsinfo = $DB->get_records_sql("select sd.* FROM {local_user_clclasses} as cl JOIN {local_scheduleclass} as sd ON sd.classid= cl.classid and sd.visible=1 WHERE cl.semesterid=$current_semid and cl.userid=$USER->id and from_unixtime('%Y',sd.startdate) > 2014 and sd.visible=1 "); } // only for registrar else if (has_capability('local/collegestructure:manage', $systemcontext) && !is_siteadmin()) { $hier = new hierarchy(); $schoolist = $hier->get_assignedschools(); if ($schoolist) { $result = ''; foreach ($schoolist as $school) $result[] = $school->id; $result = implode(',', $result); $sessionsinfo = $DB->get_records_sql("select * from {local_scheduleclass} where schoolid IN ($result) and from_unixtime('%Y',startdate) > 2014 and visible=1"); } } // only for instructor else if (has_capability('local/clclasses:submitgrades', $systemcontext) && !is_siteadmin()) { $sessionsinfo = $DB->get_records_sql(" select sh.* from mdl_local_clclasses as cl JOIN mdl_local_scheduleclass as sh ON sh.classid=cl.id where sh.instructorid=$USER->id and from_unixtime('%Y',sh.startdate) > 2013 and sh.visible=1"); } else {
function definition() { global $USER, $CFG, $DB, $PAGE; $mform = $this->_form; $id = $this->_customdata['id']; $mform->addElement('header', 'settingsheader', get_string('addeditgradeletter', 'local_gradeletter')); $hierarchy = new hierarchy(); if (is_siteadmin($USER->id)) { $schools = $DB->get_records('local_school', array('visible' => 1)); } else { $schools = $hierarchy->get_assignedschools(); } $noofschools = count($schools); if ($noofschools > 1) { $parents = $hierarchy->get_school_parent($schools); $mform->addElement('select', 'schoolid', get_string('select', 'local_collegestructure'), $parents); $mform->addRule('schoolid', get_string('missingschool', 'local_collegestructure'), 'required', null, 'client'); $mform->setType('schoolid', PARAM_INT); } else { foreach($schools as $sl){ $schoolid = $sl->id; $schoolname= $sl->fullname; } $mform->addElement('static', 'schid', get_string('select', 'local_collegestructure'), $schoolname); $mform->addElement('hidden', 'schoolid', $schoolid); $mform->setType('schoolid', PARAM_INT); } $mform->addElement('text', 'letter', get_string('lettergrades', 'local_gradeletter')); $mform->addRule('letter', get_string('letterreq', 'local_gradeletter'), 'required', null, 'client'); $mform->addRule('letter', get_string('lettersonly', 'local_gradeletter'), 'lettersonly', null, 'client'); $mform->setType('letter', PARAM_TEXT); $mform->addElement('text', 'markfrom', get_string('markfrom', 'local_gradeletter')); $mform->addRule('markfrom', get_string('marksfromreq', 'local_gradeletter'), 'required', null, 'client'); $mform->addRule('markfrom', null, 'numeric', null, 'client'); // $mform->addRule('markfrom', get_string('markslengthmin','local_gradeletter'), 'minlength',2, 'client'); $mform->setType('markfrom', PARAM_INT); $mform->addElement('text', 'markto', get_string('markto', 'local_gradeletter')); $mform->addRule('markto', get_string('reqmarktoval', 'local_gradeletter'), 'required', null, 'client'); $mform->addRule('markto', null, 'numeric', null, 'client'); $mform->addRule('markto', get_string('markslengthmin', 'local_gradeletter'), 'minlength', 2, 'client'); $mform->setType('markto', PARAM_INT); $mform->addRule(array('markfrom', 'markto'), '"Mark from" value should be lesser than "Mark to" value.', 'compare', '<'); $mform->addElement('text', 'gradepoint', get_string('gradepoint', 'local_gradeletter')); $mform->addRule('gradepoint', get_string('gradepointreq', 'local_gradeletter'), 'required', null, 'client'); $mform->addRule('gradepoint', null, 'numeric', null, 'client'); $mform->setType('gradepoint', PARAM_TEXT); $mform->addElement('hidden', 'id'); $mform->setType('id', PARAM_INT); $submitlable = ($id > 0) ? get_string('updategradeletter', 'local_gradeletter') : get_string('creategradeletter', 'local_gradeletter'); $this->add_action_buttons($cancel = true, $submitlable); }
/** * process the mass enrolment * @param csv_import_reader $cir an import reader created by caller * @param Object $course a course record from table mdl_course * @param Object $context course context instance * @param Object $data data from a moodleform * @return string log of operations */ function bulk_batch_enroll_newstudents($cir, $data) { global $CFG,$DB,$USER; $optype=''; $returnurl = new moodle_url('/local/batches/bulk_enroll.php'); //$STD_FIELDS = array('firstname', 'middlename', 'lastname', 'gender', 'dob', 'birthcountry', 'birthplace', 'fathername', 'pob', 'region', 'town', 'current_home_no', 'current_country', 'phone', 'email', 'howlong', 'same', 'permenant_country', 'permenant_home_no', 'state', 'city', 'pincode', 'contactname', 'primary_school', 'primary_year', 'primary_score', 'primary_place', 'undergraduate_in', 'ugname', 'ug_year', 'ug_score', 'ug_place', 'graduate_in', 'graduate_name', 'graduate_year', 'graduate_score', 'graduate_place', 'examname', 'hallticketno', 'score', 'no_of_months', 'reason', 'description','typeofstudent', 'typeofapplication', 'previousstudent', 'serviceid', 'typeofprogram'); $STD_FIELDS = array('firstname', 'middlename', 'lastname', 'fathername','mothername','gender', 'dob','caste','category', 'current_country', 'phone', 'email', 'otherphone','city', 'pincode', 'typeofapplication', 'serviceid', 'fatheremail','address'); $PRF_FIELDS = array(); $result = ''; //$roleid = $data->roleassign; //$useridfield = $data->firstcolumn; $enrollablecount = 0; $skipped=0; $createdgroupscount = 0; $createdgroupingscount = 0; $createdgroups = ''; $createdgroupings = ''; $filecolumns = uu_validate_admission_upload_columns($cir, $STD_FIELDS, $PRF_FIELDS, $returnurl); $upt = new uu_progress_tracker(); $plugin = enrol_get_plugin('manual'); // init csv import helper $cir->init(); $linenum = 1; loop: while ($line = $cir->next()) { $result=''; $existsmail=0; $upt->flush(); $linenum++; $admission = new stdClass(); // add fields to admission object foreach ($line as $keynum => $value) { if (!isset($filecolumns[$keynum])) { // this should not happen continue; } $key = $filecolumns[$keynum]; $admission->$key = $value; } $admission->linenum = $linenum; // // ---------- getting curriculumid-------------------- // $curriculum = trim($admission->curriculumname); // $curriculumid = $DB->get_field('local_curriculum', 'id', array('fullname' => $curriculum)); // // // ---------- getting batchid--------------- // $batchname = trim($admission->batchname); // // $batchid = $DB->get_field('cohort', 'id', array('name' => $batchname)); if(empty($data->batchid)){ $result .= '<div class="alert alert-error">'.get_string('emptybatch','local_batches').'</div>'; goto loop; } $batchid =$data->batchid; $batchmapinfo=$DB->get_record('local_batch_map',array('batchid'=>$batchid)); // if (!empty($admission->previousstudent) && !empty($admission->serviceid) && $admission->previousstudent == 2) { // // // schools validation // // $scname = trim($admission->schoolname); // $schoollist = $DB->get_record('local_school', array('fullname' => $data->schoolid)); // if (empty($schoollist)) { // $result .= '<div class="alert alert-error">'.get_string('invalidschool_ub', 'local_batches', $admission). '</div>'; // goto loop; // } // $scid = $schoollist->id; // // check schoolname // $hier = new hierarchy(); // $schools = $hier->get_assignedschools(); // if (is_siteadmin()) { // $schools = $hier->get_school_items(); // } // $c = 0; // foreach ($schools as $scl) { // if ($scid == $scl->id) { // ++$c; // break; // } // } // if ($c == 0) { // $result .= '<div class="alert alert-error">'.get_string('invalidschoolpermission_ub', 'local_batches', $admission). '</div>'; // goto loop; // } // // if (empty($admission->typeofprogram)) { // $result .= '<div class="alert alert-error">'.get_string('emptytypeofprogram_ub', 'local_batches', $admission). '</div>'; // // goto loop; // } // // type of program validation // if ($admission->typeofprogram > 2 || $admission->typeofprogram < 1) { // $result .= '<div class="alert alert-error">'.get_string('invalidtypeofprogram_ub', 'local_batches', $admission). '</div>'; // // goto loop; // } // if (empty($admission->typeofapplication)) { // $result .= '<div class="alert alert-error">'.get_string('emptytypeofapplication_ub', 'local_batches', $admission). '</div>'; // // goto loop; // } // if ($admission->typeofapplication > 2 || $admission->typeofapplication < 1) { // $result .= '<div class="alert alert-error">'.get_string('invalidtypeofapplication_ub', 'local_batches', $admission). '</div>'; // // goto loop; // } // // // program validation //// $prg = trim($admission->programname); //// $programlist = $DB->get_record('local_program', array('fullname' => $prg)); //// if (empty($programlist)) { //// $result .= '<div class="alert alert-error">'.get_string('invalidprogramname_ub', 'local_batches', $admission). '</div>'; //// //// goto loop; //// } //// $prgid = $programlist->id; //// //// $programs = $DB->get_records('local_program', array('id' => $prgid, 'schoolid' => $scid, 'programlevel' => $admission->typeofprogram)); //// if (empty($programs)) { //// $result .= '<div class="alert alert-error">'.get_string('invalidmapprogramname_ub', 'local_batches', $admission). '</div>'; //// // echo '<h3 style="color:red;">Program "' . $admission->programname . '" is not under given School "' . $admission->schoolname . '" or not under given typeofprogram "' . $admission->typeofprogram . '" at line no. "' . $linenum . '" of excelsheet.</h3>'; //// goto loop; //// } // // // $scid= $data->schoolid; // $prgid=$data->program; // $time = date('m/d/Y'); // $time = strtotime($time); // $openadms = $DB->get_record_sql('select * from {local_event_activities} where schoolid = ' . $scid . ' and programid = ' . $prgid . ' and publish = 1 and ((' . $time . ' BETWEEN startdate and enddate) or (' . $time . ' >= startdate and enddate = 0)) and eventtypeid = 1'); // $serviceid = trim($admission->serviceid); // if (empty($openadms)) { // $result .='<h3 style="color:red;">Admissions are not opened for the applied program entered at line no. "' . $linenum . '" of uploaded excelsheet.</h3>'; // goto loop; // } // $applcntid = $DB->get_field('local_userdata', 'applicantid', array('serviceid' => $serviceid, 'schoolid' => $scid)); // if (empty($applcntid)) { // $result .= '<h3 style="color:red;">You have entered invalid serviceid "' . $admission->serviceid . '" at line no. "' . $linenum . '" of uploaded excelsheet.'; // goto loop; // } // $result = $DB->get_record('local_admission', array('id' => $applcntid)); // $previous = $result; // $previous->dateofapplication = time(); // $previous->typeofprogram = $admission->typeofprogram; // $previous->typeofapplication = $admission->typeofapplication; // $previous->program = $prgid; // $previous->status = 0; // $DB->insert_record('local_admission', $previous); // $admissionsnew++; // // print_object($previous); // } else { // ----------to checking unique email id--------------- if($admission->email){ if($existsuser=$DB->get_record('user',array('email'=>$admission->email))){ $existsmail= 1; // if( $DB->record_exists('cohort_members',array('userid'=>$existsuser->id,'cohortid'=>$batchid))) $result .= '<div class="alert alert-error">'.get_string('useremailidexists_ub', 'local_batches', $admission). '</div>'; goto loop; } } // ----------to checking unique service id (Rollid)--------------- if($admission->serviceid){ if($existsuser=$DB->get_record('local_userdata',array('serviceid'=>$admission->serviceid))){ $result .= '<div class="alert alert-error">'.get_string('existsserviceid', 'local_batches', $admission). '</div>'; goto loop; } } //if ($admission->previousstudent != 1) { // $result .= '<h3 style="color:red;">You have entered invalid previousstudent "' . $admission->previousstudent . '" at line no. "' . $linenum . '" of uploaded excelsheet.'; // goto loop; //} if (!isset($admission->email)) { // prevent warnings below $admission->email = ''; } // make sure we really have admissionname if (empty($admission->email)) { $admissionserrors++; continue; } $admission->email = trim($admission->email); $existingadmission = $DB->get_record_sql("select * from {local_admission} where email = '$admission->email' and (status=0 or status=1)"); // add default values for remaining fields $formdefaults = array(); foreach ($STD_FIELDS as $field) { if (isset($admission->$field)) { continue; } // all validation moved to form2 if (isset($formdata->$field)) { // process templates $formdefaults[$field] = true; } } foreach ($PRF_FIELDS as $field) { if (isset($admission->$field)) { continue; } if (isset($formdata->$field)) { $formdefaults[$field] = true; } } // can we process with update or insert? $skip = false; if ($optype == 'UU_ADMISSION_ADDNEW') { if ($existingadmission) { $admissionsskipped++; $skip = true; } } if ($skip) { continue; } // save the new admission to the database // schools validation //$scname = trim($admission->schoolname); //$schoollist = $DB->get_record('local_school', array('fullname' => $scname)); //if (empty($schoollist)) { // $result .= '<h3 style="color:red;">Invalid school "' . $admission->schoolname . '" entered at line no. "' . $linenum . '" of excelsheet.</h3>'; // goto loop; //} // $scid = $schoollist->id; // check schoolname $hier = new hierarchy(); $schools = $hier->get_assignedschools(); if (is_siteadmin()) { $schools = $hier->get_school_items(); } $c = 0; foreach ($schools as $scl) { if ($scid == $scl->id) { ++$c; break; } } //if ($c == 0) { // $result .='<h3 style="color:red;">Sorry you are not assigned to this school "' . $admission->schoolname . '" entered at line no. "' . $linenum . '" of uploaded excelsheet.</h3>'; // goto loop; //} //if (empty($admission->typeofprogram)) { // $result .= '<h3 style="color:red;">Please enter value for "typeofprogram" field in line no. "' . $linenum . '" of uploaded excelsheet.</h3>'; // goto loop; //} if (empty($admission->typeofapplication)) { $result .= '<div class="alert alert-error">Please enter value for "typeofapplication" field in line no. "' . $linenum . '" of uploaded excelsheet.</div>'; goto loop; } if ($admission->typeofapplication > 2 || $admission->typeofapplication < 1) { $result .= '<div class="alert alert-error">You have entered invalid typeofapplication "' . $admission->typeofapplication . '" at line no. "' . $linenum . '" of uploaded excelsheet.</div>'; goto loop; } // type of program validation //if ($admission->typeofprogram > 2 || $admission->typeofprogram < 1) { // $result .= '<h3 style="color:red;">You have entered invalid typeofprogram "' . $admission->typeofprogram . '" at line no. "' . $linenum . '" of uploaded excelsheet.'; // goto loop; //} // program validation //$prg = trim($admission->programname); //$programlist = $DB->get_record('local_program', array('fullname' => $prg)); //if (empty($programlist)) { // $result .='<div class="alert alert-error">Invalid program name "' . $admission->programname . '" entered at line no. "' . $linenum . '" of excelsheet.</div>'; // goto loop; //} //$prgid = $programlist->id; if($batchmapinfo->programid>0) $prgid=$batchmapinfo->programid; else $prgid= $data->program; if($batchmapinfo->schoolid>0) $scid=$batchmapinfo->schoolid; else $scid =$data->schoolid; if($batchmapinfo->curriculumid>0) $curriculumid=$batchmapinfo->curriculumid; else $curriculumid =$data->curriculumid; //$programs = $DB->get_records('local_program', array('id' => $prgid, 'schoolid' => $scid, 'programlevel' => $admission->typeofprogram)); //if (empty($programs)) { // $result .='<div class="alert alert-error">Program "' . $admission->programname . '" is not under given School "' . $admission->schoolname . '" or not under given typeofprogram "' . $admission->typeofprogram . '" at line no. "' . $linenum . '" of excelsheet.</div>'; // goto loop; //} //$time = date('m/d/Y'); //$time = strtotime($time); //$openadms = $DB->get_record_sql('select * from {local_event_activities} where schoolid = ' . $scid . ' and programid = ' . $prgid . ' and publish = 1 and ((' . $time . ' BETWEEN startdate and enddate) or (' . $time . ' >= startdate and enddate = 0)) and eventtypeid = 1'); //if (empty($openadms)) { // $result .= '<div class="alert alert-error">Admissions are not opened for the applied program entered at line no. "' . $linenum . '" of uploaded excelsheet.</div>'; // goto loop; //} // type of student validation //if ($admission->typeofstudent > 3 || $admission->typeofstudent < 1) { // $result .='<div class="alert alert-error">You have entered invalid typeofstudent "' . $admission->typeofstudent . '" at line no. "' . $linenum . '" of uploaded excelsheet.</div>'; // goto loop; //} $year = time(); $year_in_number = date('Y'); if (empty($admission->dob)) { $result .= '<div class="alert alert-error">Please enter dob in line no. "' . $linenum . '" of uploaded excelsheet.</div>'; goto loop; } $ex = explode('/', $admission->dob); if((sizeof($ex))<2){ $ex = explode('-', $admission->dob); } if((sizeof($ex))<2){ $ex = explode('.', $admission->dob); } $howlong = $year_in_number - $ex[2]; $dob = strtotime($ex[0].'/'.$ex[1].'/'.$ex[2]); $true = checkdate($ex[0],$ex[1],$ex[2]); if ($true == false) { $result .= '<div class="alert alert-error">Invalid dob "' . $admission->dob . '" format entered at line no. "' . $linenum . '" of uploaded excelsheet. </div>'; goto loop; } if(empty($dob)){ $result .= '<div class="alert alert-error">check dob date format "' . $admission->dob . '" format entered at line no. "' . $linenum . '" of uploaded excelsheet. </div>'; } // check dob if ($dob > $year) { $result .='<div class="alert alert-error">dob "' . $admission->dob . '" should be less than present date at line no. "' . $linenum . '" of uploaded excelsheet.</div>'; goto loop; } // check howlong //if ($howlong < $admission->howlong) { // $result .= '<div class="alert alert-error"> howlong ' . $admission->howlong . ' should not be greater than your age at line no. "' . $linenum . '" of uploaded excelsheet.</div>'; // goto loop; //} //// check primary year //if ($admission->primary_year > $year_in_number) { // $result .= '<div class="alert alert-error">primary_year "' . $admission->primary_year . '" should not br greater than present date at line no. "' . $linenum . '".</div>'; // goto loop; //} //if ($admission->primary_year < $ex[2]) { // $result .= '<div class="alert alert-error">primary_year "' . $admission->primary_year . '" should not be less than dob at line no. "' . $linenum . '".</div>'; // goto loop; //} //if ($admission->typeofprogram == 2) { // if ($admission->ug_year > $year_in_number) { // $result .= '<div class="alert alert-error">ug_year "' . $admission->ug_year . '" should not be greater than present date at line no. "' . $linenum . '" of uploaded excelsheet.</div>'; // goto loop; // } // if ($admission->ug_year < $admission->primary_year) { // $result .= '<div class="alert alert-error">ug_year "' . $admission->ug_year . '" should not be less than primary year at line no. "' . $linenum . '" of uploaded excelsheet.</div>'; // goto loop; // } // if ($admission->ug_year < $ex[2]) { // $result .= '<div class="alert alert-error">ug_year "' . $admission->ug_year . '" should not be less than dob at line no. "' . $linenum . '" of uploaded excelsheet.</div>'; // goto loop; // } // if ($admission->ug_year == $admission->primary_year) { // $result .= '<div class="alert alert-error">ug_year "' . $admission->ug_year . '" should not be less than primary year at line no. "' . $linenum . '" of uploaded excelsheet.</div>'; // goto loop; // } //} //if ($admission->same > 2 || $admission->same < 1) { // $result .='<div class="alert alert-error">Number entered for field same "' . $admission->same . '" is invalid at line no. "' . $linenum . '" of uploaded excelsheet.</div>'; // goto loop; //} //$value1 = numeric_validation($admission->pob); //if ($value1 == 0) { // $result .= '<div class="alert alert-error">Enter valid value for field pob in line no. "' . $linenum . '" of uploaded excelsheet.</div>'; // goto loop; //} // check phone number $phone_length = strlen($admission->phone); //if ($phone_length > 15 || $phone_length < 10) { // echo '<div class="alert alert-error">Enter valid phone number in line no. "' . $linenum . '" of uploaded excelsheet.</div>'; // goto loop; //} //if (empty($admission->current_home_no)) { // echo '<div class="alert alert-error">Please enter current_home_no in line no. "' . $linenum . '" of uploaded excelsheet.</div>'; // goto loop; //} if (empty($admission->current_country)) { echo '<div class="alert alert-error">Please enter current_country in line no. "' . $linenum . '" of uploaded excelsheet.</div>'; goto loop; } if(empty($admission->address)){ echo '<div class="alert alert-error">Please enter address in line no. "' . $linenum . '" of uploaded excelsheet.</div>'; goto loop; } //if (empty($admission->fathername)) { // echo '<div class="alert alert-error">Please enter fathername in line no. "' . $linenum . '" of uploaded excelsheet.</div>'; // goto loop; //} //if (empty($admission->pob)) { // echo '<div class="alert alert-error">Please enter pob in line no. "' . $linenum . '" of uploaded excelsheet.</div>'; // goto loop; //} //if (!trim($admission->region)) { // echo '<div class="alert alert-error">Please enter region in line no. "' . $linenum . '" of uploaded excelsheet.</div>'; // goto loop; //} //if (empty($admission->town)) { // echo '<div class="alert alert-error">Please enter town in line no. "' . $linenum . '" of uploaded excelsheet.</div>'; // goto loop; //} //if (empty($admission->birthcountry)) { // echo '<div class="alert alert-error">Please enter birthcountry in line no. "' . $linenum . '" of uploaded excelsheet.</div>'; // goto loop; //} $check_mail = filter_var($admission->email, FILTER_VALIDATE_EMAIL); if ($check_mail == false) { echo '<div class="alert alert-error">Please enter valid email in line no. "' . $linenum . '" of uploaded excelsheet.</div>'; goto loop; } $country = get_string_manager()->get_list_of_countries(); //if (!empty($admission->birthcountry)) { // if (!array_key_exists($admission->birthcountry, $country)) { // echo '<div class="alert alert-error">Please enter valid code for birthcountry in line no. "' . $linenum . '" of uploaded excelsheet.</div>'; // goto loop; // } //} if (!empty($admission->current_country)) { if (!array_key_exists($admission->current_country, $country)) { echo '<div class="alert alert-error">Please enter valid code for current_country in line no. "' . $linenum . '" of uploaded excelsheet.</div>'; goto loop; } } //if (empty($admission->same)) { // echo '<div class="alert alert-error">Please enter value for "same" field in line no. "' . $linenum . '" of uploaded excelsheet.</div>'; // goto loop; //} if (empty($admission->firstname)) { echo '<div class="alert alert-error">Please enter firstname in line no. "' . $linenum . '" of uploaded excelsheet.</div>'; goto loop; } if (empty($admission->lastname)) { echo '<div class="alert alert-error">Please enter lastname in line no. "' . $linenum . '" of uploaded excelsheet.</div>'; goto loop; } if (empty($admission->gender)) { echo '<div class="alert alert-error">Please enter gender in line no. "' . $linenum . '" of uploaded excelsheet.</div>'; goto loop; } //if (empty($admission->birthplace)) { // echo '<div class="alert alert-error">Please enter birthplace in line no. "' . $linenum . '" of uploaded excelsheet.</div>'; // goto loop; //} //if (empty($admission->primary_school)) { // echo '<div class="alert alert-error">Please enter primary_school in line no. "' . $linenum . '" of uploaded excelsheet.</div>'; // goto loop; //} //if (empty($admission->primary_year)) { // echo '<div class="alert alert-error">Please enter primary_year in line no. "' . $linenum . '" of uploaded excelsheet.</div>'; // goto loop; //} //if (empty($admission->primary_score)) { // echo '<div class="alert alert-error">Please enter primary_score in line no. "' . $linenum . '" of uploaded excelsheet.</div>'; // goto loop; //} //if (empty($admission->primary_place)) { // echo '<div class="alert alert-error">Please enter primary_place in line no. "' . $linenum . '" of uploaded excelsheet.</div>'; // goto loop; //} //if (empty($admission->typeofstudent)) { // echo '<div class="alert alert-error">Please enter typeofstudent in line no. "' . $linenum . '" of uploaded excelsheet.</div>'; // goto loop; //} //if ($admission->typeofstudent == 2) { // if (empty($admission->examname)) { // echo '<div class="alert alert-error">Please enter examname in line no. "' . $linenum . '" of uploaded excelsheet.</div>'; // goto loop; // } // if (empty($admission->hallticketno)) { // echo '<div class="alert alert-error">Please enter hallticketno in line no. "' . $linenum . '" of uploaded excelsheet.</div>'; // goto loop; // } // if (empty($admission->score)) { // echo '<div class="alert alert-error">Please enter score in line no. "' . $linenum . '" of uploaded excelsheet.</div>'; // goto loop; // } //} //if ($admission->typeofstudent == 3) { // if (empty($admission->no_of_months)) { // echo '<div class="alert alert-error">Please enter no_of_months in line no. "' . $linenum . '" of uploaded excelsheet.</div>'; // goto loop; // } // if (empty($admission->reason)) { // echo '<div class="alert alert-error">Please enter reason in line no. "' . $linenum . '" of uploaded excelsheet.</div>'; // goto loop; // } // if (empty($admission->description)) { // echo '<div class="alert alert-error">Please enter description in line no. "' . $linenum . '" of uploaded excelsheet.</div>'; // goto loop; // } //} //if ($admission->typeofprogram == 2) { // if (empty($admission->undergraduate_in)) { // echo '<div class="alert alert-error">Please enter undergraduate_in in line no. "' . $linenum . '" of uploaded excelsheet.</div>'; // goto loop; // } // if (empty($admission->ugname)) { // echo '<div class="alert alert-error">Please enter ugname in line no. "' . $linenum . '" of uploaded excelsheet.</div>'; // goto loop; // } // if (empty($admission->ug_year)) { // echo '<div class="alert alert-error">Please enter ug_year in line no. "' . $linenum . '" of uploaded excelsheet.</div>'; // goto loop; // } // if (empty($admission->ug_score)) { // echo '<div class="alert alert-error">Please enter ug_score in line no. "' . $linenum . '" of uploaded excelsheet.</div>'; // goto loop; // } // if (empty($admission->ug_place)) { // echo '<div class="alert alert-error">Please enter ug_place in line no. "' . $linenum . '" of uploaded excelsheet.</div>'; // goto loop; // } //} // if ($admission->same == 2) { //if (empty($admission->permenant_country)) { // echo '<div class="alert alert-error">Please enter permenant_country in line no. "' . $linenum . '" of uploaded excelsheet.</div>'; // goto loop; //} //if (!empty($admission->permenant_country)) { // if (!array_key_exists($admission->permenant_country, $country)) { // echo '<div class="alert alert-error">Please enter valid code for permenant_country in line no. "' . $linenum . '" of uploaded excelsheet.</div>'; // goto loop; // } //} if (empty($admission->city)) { echo '<div class="alert alert-error">Please enter city in line no. "' . $linenum . '" of uploaded excelsheet.</div>'; goto loop; } //if (empty($admission->permenant_home_no)) { // echo '<div class="alert alert-error">Please enter permenant_home_no in line no. "' . $linenum . '" of uploaded excelsheet.</div>'; // goto loop; //} //if (empty($admission->state)) { // echo '<div class="alert alert-error">Please enter state in line no. "' . $linenum . '" of uploaded excelsheet.</div>'; // goto loop; //} //if (empty($admission->pincode)) { // echo '<div class="alert alert-error">Please enter pincode in line no. "' . $linenum . '" of uploaded excelsheet.</div>'; // goto loop; //} //$value2 = numeric_validation($admission->pincode); //if ($value2 == 0) { // echo '<div class="alert alert-error">Enter valid value for field pincode in line no. "' . $linenum . '" of uploaded excelsheet.</div>'; // goto loop; //} //if (empty($admission->contactname)) { // echo '<div class="alert alert-error">Please enter contactname in line no. "' . $linenum . '" of uploaded excelsheet.</div>'; // goto loop; //} $data->firstname = $admission->firstname; $data->middlename = $admission->middlename; $data->lastname = $admission->lastname; $data->gender = $admission->gender; $data->dob = $dob; //$data->birthcountry = $admission->birthcountry; //$data->birthplace = $admission->birthplace; $data->fathername = $admission->fathername; //$data->pob = $admission->pob; $data->caste = $admission->caste; $data->category = $admission->category; $data->otherphone = $admission->otherphone; $data->fatheremail = $admission->fatheremail; //$data->town = $admission->town; //$data->howlong = $admission->howlong; //$data->currenthno = $admission->current_home_no; $data->currentcountry = $admission->current_country; $data->phone = $admission->phone; $data->email = $admission->email; $data->mothername = $admission->mothername; // $data->same = $admission->same; // permanent address same as temporary address or current address //if ($data->same == 1) { // $data->pcountry = $admission->current_country; // $data->permenanthno = $admission->current_home_no; // $data->state = $admission->region; // $data->city = $admission->town; // $data->pincode = $admission->pob; // $data->contactname = $admission->fathername; //} //if ($data->same == 2) { // $data->pcountry = $admission->permenant_country; // $data->permanenthno = $admission->permenant_home_no; // $data->state = $admission->state; $data->city = $admission->city; $data->pincode = $admission->pincode; // $data->contactname = $admission->contactname; // } //$data->primaryschoolname = $admission->primary_school; //$data->primaryyear = $admission->primary_year; //$data->primaryscore = $admission->primary_score; //$data->primaryplace = $admission->primary_place; //$data->typeofstudent = $admission->typeofstudent; //international student //if ($data->typeofstudent == 2) { // $data->examname = $admission->examname; // $data->hallticketno = $admission->hallticketno; // $data->score = $admission->score; //} elseif ($data->typeofstudent == 3) { //mature student // $data->noofmonths = $admission->no_of_months; // $data->reason = $admission->reason; // $data->description = $admission->description; //} $data->programid = $prgid; $data->typeofapplication = 1; $data->status = 0; // $data->typeofprogram = $admission->typeofprogram; //if ($data->typeofprogram == 2) { // graduate // $data->ugin = $admission->undergraduate_in; // $data->ugname = $admission->ugname; // $data->ugyear = $admission->ug_year; // $data->ugscore = $admission->ug_score; // $data->ugplace = $admission->ug_place; //} $data->previousstudent = 1; $data->dateofapplication = time(); $data->uploadfile=0; $data->address= $admission->address; $data->id = $DB->insert_record('local_admission', $data); $applicantid = $data->id; $program = $DB->get_field('local_program', 'shortname', array('id' => $prgid)); $random = random_string(5); $update = new Stdclass(); $update->id = $data->id; $update->applicationid = substr($program,0,8).$data->id.$random; $applicationid = $DB->update_record('local_admission', $update); $data->id ++; $admissionsnew++; $admission->batchid= $batchid; $csvfields= $admission; if(isset($data->id)){ // $result =$data->id; $response = local_batches_enroll_batches($applicantid,$curriculumid,$batchid, $csvfields ); } if($response){ $enrollablecount++; } else $skipped++; } // end of while $result .= get_string('numberofenrolled', 'local_batches', $enrollablecount) . ""; $result .= '<div class="alert alert-error">'.get_string('numberofskippedusers','local_batches', $skipped).'</div>'; return $result; }// end of function
function definition() { global $USER, $CFG, $DB, $PAGE, $hierarchy; $mform = $this->_form; $PAGE->requires->yui_module('moodle-local_scheduleexam-scheduleexamchooser', 'M.local_scheduleexam.init_scheduleexamchooser', array(array('formid' => $mform->getAttribute('id')))); $id = $this->_customdata['id']; $disable = ($id > 0) ? 'disabled="disabled"' : ''; $hierarchy = new hierarchy(); if (is_siteadmin($USER->id)) { $schools = $DB->get_records('local_school', array('visible' => 1)); } else { $schools = $hierarchy->get_assignedschools(); } if ($id > 0) { $mform->addElement('header', 'editexamheader', get_string('editexamheader', 'local_scheduleexam')); $mform->addHelpButton('editexamheader', 'editexamheader', 'local_scheduleexam'); } else { $mform->addElement('header', 'createexamheader', get_string('createexamheader', 'local_scheduleexam')); $mform->addHelpButton('createexamheader', 'createexamheader', 'local_scheduleexam'); } $parents = $hierarchy->get_school_parent($schools); $mform->addElement('select', 'schoolid', get_string('schoolid', 'local_collegestructure'), $parents, $disable); if ($id < 0) { $mform->addRule('schoolid', get_string('missingschool', 'local_collegestructure'), 'required', null, 'client'); } $mform->setType('schoolid', PARAM_INT); $mform->registerNoSubmitButton('updatecourseformat'); $mform->addElement('submit', 'updatecourseformat', get_string('courseformatudpate')); $mform->addElement('hidden', 'addsemesterslisthere'); $mform->setType('addsemesterslisthere', PARAM_INT); $mform->addElement('hidden', 'addclclasseslisthere'); $mform->setType('addclclasseslisthere', PARAM_INT); $mform->addElement('hidden', 'addcobaltcourseehere'); $mform->setType('addcobaltcourseehere', PARAM_INT); $mform->addElement('hidden', 'addexamtypehere'); $mform->setType('addexamtypehere', PARAM_INT); $mform->addElement('hidden', 'addexamtypeempty_msg'); $mform->setType('addexamtypeempty_msg', PARAM_RAW); $mform->addElement('hidden', 'addlecturetypehere'); $mform->setType('addlecturetypehere', PARAM_INT); $mform->addElement('hidden', 'addlecturetypeempty_msg'); $mform->setType('addlecturetypeempty_msg', PARAM_RAW); $mform->addElement('date_selector', 'opendate', get_string('opendate', 'local_scheduleexam')); $mform->addRule('opendate', get_string('opendatereq', 'local_scheduleexam'), 'required', null, 'client'); //************************************************************************************************************* $shour['null'] = 'Hour'; for ($sthour = 0; $sthour <= 23; $sthour++) { if ($sthour < 10) $shour['0' . $sthour] = '0' . $sthour; else $shour[$sthour] = $sthour; } $smin['null'] = 'Mins'; for ($stmin = 0; $stmin <= 59; $stmin++) { if ($stmin < 10) $smin['0' . $stmin] = '0' . $stmin; else $smin[$stmin] = $stmin; } $starttime = array(); $starttime[] = & $mform->createElement('select', 'starttimehour', '', $shour); $starttime[] = & $mform->createElement('select', 'starttimemin', '', $smin); $mform->addGroup($starttime, 'starttimearr', get_string('starttimehour', 'local_scheduleexam'), array(' '), false); $mform->addRule('starttimearr', get_string('missingstarttimehour', 'local_scheduleexam'), 'required', null, 'client'); $endtime = array(); $endtime[] = & $mform->createElement('select', 'endtimehour', '', $shour); $endtime[] = & $mform->createElement('select', 'endtimemin', '', $smin); $mform->addGroup($endtime, 'endtimearr', get_string('endtimehour', 'local_scheduleexam'), array(' '), false); $mform->addRule('endtimearr', get_string('missingendtimehour', 'local_scheduleexam'), 'required', null, 'client'); $mform->addElement('text', 'grademin', get_string('grademin', 'local_scheduleexam'), $disable); $mform->setType('grademin', PARAM_INT); if ($id < 0) { $mform->addRule('grademin', get_string('grademinreq', 'local_scheduleexam'), 'required', null, 'client'); $mform->addRule('grademin', get_string('grademinnum', 'local_scheduleexam'), 'numeric', null, 'client'); } $mform->addElement('text', 'grademax', get_string('grademax', 'local_scheduleexam'), $disable); $mform->setType('grademax', PARAM_INT); if ($id < 0) { $mform->addRule('grademax', get_string('grademaxreq', 'local_scheduleexam'), 'required', null, 'client'); $mform->addRule('grademax', get_string('grademaxnum', 'local_scheduleexam'), 'numeric', null, 'client'); } // $mform->addElement('text', 'examweightage', get_string('examweightage', 'local_scheduleexam'), $disable); // $mform->setType('examweightage', PARAM_INT); // if($id < 0){ // $mform->addRule('examweightage', get_string('examweightagereq', 'local_scheduleexam'), 'required', null, 'client'); // $mform->addRule('examweightage', get_string('examweightagenum', 'local_scheduleexam'), 'numeric', null, 'client'); // } //***************************************************************************************** $mform->addElement('hidden', 'id'); $mform->setType('id', PARAM_INT); if ($id < 0) { $this->add_action_buttons('false', 'Schedule Assessment'); } else { $this->add_action_buttons('false', 'Update Assessment'); } }
print_error('You dont have permissions'); } $PAGE->set_url('/local/modules/index.php'); $string = get_string('pluginname', 'local_modules') . ':' . get_string('viewmodules', 'local_modules'); $PAGE->set_title($string); //Header and the navigation bar $PAGE->set_heading($SITE->fullname); $PAGE->navbar->add(get_string('managemodule', 'local_modules')); $PAGE->navbar->add(get_string('viewmodules', 'local_modules')); $instance = new cobalt_modules(); //echo $OUTPUT->header(); echo $OUTPUT->header(); //Heading of the page echo $OUTPUT->heading(get_string('managemodule', 'local_modules')); $hier = new hierarchy(); $schools = $hier->get_assignedschools(); $currenttab = "lists"; $instance->print_tabs($currenttab, -1); // // Moodle 2.2 and onwards if (isset($CFG->allowframembedding) and ! $CFG->allowframembedding) { echo $OUTPUT->box(get_string('allowframembedding', 'local_modules')); } $schools = $hier->get_school_parent($schools, $selected = array(), $inctop = false, $all = false); if (is_siteadmin()) { $schools = $hier->get_school_items(); } $schoollist_string = implode(',', array_keys($schools));
function definition() { global $USER, $CFG, $DB, $PAGE; $mform = $this->_form; //------used for editing purpose(used to put static schoolname and shortname) $eid = $this->_customdata['temp']; $hierarchy= new hierarchy(); $PAGE->requires->yui_module('moodle-local_prefix-hideshow', 'M.local_prefix.init_hideshow', array(array('formid' => $mform->getAttribute('id')))); if ($eid->id > 0) $mform->addElement('header', 'settingsheader', get_string('editprefix_settings', 'local_prefix')); else $mform->addElement('header', 'settingsheader', get_string('prefixs', 'local_prefix')); $prefix = prefix_suffix::getInstance(); $entitylist = $hierarchy->get_records_cobaltselect_menu('local_create_entity', '', null, '', 'id,entity_name', '--Select--'); $mform->addElement('select', 'entityid', get_string('entityid', 'local_prefix'), $entitylist); $mform->addRule('entityid', get_string('entityid', 'local_prefix'), 'required', null, 'client'); //------used for editing purpose(used to put static schoolname ) if ($eid->id > 0) { $school = $DB->get_record('local_school', array('id' => $eid->schoolid)); $mform->addElement('static', 'esid', get_string('select', 'local_collegestructure'), $school->fullname); $program = $DB->get_record('local_program', array('id' => $eid->programid)); $mform->addElement('static', 'epid', get_string('selectprogram', 'local_programs'), $program->fullname); } else { $hier = new hierarchy(); if (is_siteadmin($USER->id)) { $schoolids = $DB->get_records('local_school', array('visible' => 1)); } else { $schoolids = $hier->get_assignedschools(); } $count = sizeof($schoolids); if ($count > 1) { $items = $hier->get_school_items(); $parents = $hier->get_school_parent($schoolids, '', true); $mform->addElement('select', 'schoolid', get_string('select', 'local_collegestructure'), $parents); $mform->addRule('schoolid', get_string('select', 'local_collegestructure'), 'required', null, 'client'); $mform->registerNoSubmitButton('updatecourseformat'); $mform->addElement('submit', 'updatecourseformat', get_string('courseformatudpate')); } else { foreach($schoolids as $sid){ $schoolid=$sid->id; $schoolname=$sid->fullname; } $mform->addElement('static', 'sid', get_string('schoolid', 'local_collegestructure'), $schoolname); $mform->addElement('hidden', 'schoolid', $schoolid); } } $mform->setType('schoolid', PARAM_INT); $mform->addElement('hidden', 'addprogramlisthere'); $mform->setType('addprogramlisthere', PARAM_INT); $mform->addElement('text', 'sequence_no', get_string('sequence', 'local_prefix')); $mform->addRule('sequence_no', get_string('spaces', 'local_prefix'), 'regex', '/[^ ]+/', 'client'); $mform->addRule('sequence_no', get_string('num', 'local_prefix'), 'numeric', null, 'client'); $mform->addRule('sequence_no', get_string('seq1', 'local_prefix'), 'required', null, 'client'); $mform->setType('sequence_no', PARAM_RAW); $mform->addElement('text', 'prefix', get_string('prefix', 'local_prefix')); $mform->addRule('prefix', get_string('spaces', 'local_prefix'), 'regex', '/[^ ]+/', 'client'); $mform->addRule('prefix', get_string('pre1', 'local_prefix'), 'required', null, 'client'); $mform->setType('prefix', PARAM_RAW); $mform->addElement('text', 'suffix', get_string('suffix', 'local_prefix')); $mform->addRule('suffix', get_string('spaces', 'local_prefix'), 'regex', '/[^ ]+/', 'client'); $mform->addRule('suffix', get_string('suf1', 'local_prefix'), 'required', null, 'client'); $mform->setType('suffix', PARAM_RAW); $mform->addElement('hidden', 'id'); $mform->setType('id', PARAM_INT); $mform->addElement('hidden', 'page'); $mform->setType('page', PARAM_INT); $i = get_string('submit', 'local_prefix'); $this->add_action_buttons(true, 'Submit'); }
public function definition() { global $CFG, $DB, $PAGE, $USER; $mform = & $this->_form; /* Bug report #304 -Edit Class>Short Name- Error * @author hemalatha c arun <*****@*****.**> * Resolved- added valid condition avoiding duplication of shortname and also updated strings */ $id = $this->_customdata['id']; $PAGE->requires->yui_module('moodle-local_clclasses-chooser', 'M.local_clclasses.init_chooser', array(array('formid' => $mform->getAttribute('id')))); $hierarchy = new hierarchy(); if (is_siteadmin()) { $scho = $hierarchy->get_school_items(); } else { $scho = $hierarchy->get_assignedschools(); } $count = count($scho); $school = $hierarchy->get_school_parent($scho); $mform->addElement('select', 'schoolid', get_string('schoolid', 'local_collegestructure'), $school); $mform->addRule('schoolid', get_string('missingschool', 'local_collegestructure'), 'required', null, 'client'); $mform->setType('schoolid', PARAM_RAW); $mform->registerNoSubmitButton('updatecourseformat'); $mform->addElement('submit', 'updatecourseformat', get_string('courseformatudpate')); $mform->addElement('hidden', 'addsemesterlisthere'); $mform->setType('addsemesterlisthere', PARAM_RAW); $mform->addElement('hidden', 'adddepartmentlisthere'); $mform->setType('adddepartmentlisthere', PARAM_RAW); $style = "style='height:25px !important;'"; $mform->addElement('hidden', 'adddepartmentemptymsg'); $mform->setType('adddepartmentemptymsg', PARAM_RAW); $mform->addElement('hidden', 'addcobaltcoursehere'); $mform->setType('addcobaltcoursehere', PARAM_RAW); $mform->addElement('text', 'fullname', get_string('classesname', 'local_clclasses'), $style); $mform->addHelpButton('fullname', 'classesname', 'local_clclasses'); $mform->addRule('fullname', get_string('missingclassesname', 'local_clclasses'), 'required', null, 'client'); $mform->setType('fullname', PARAM_RAW); $mform->addElement('text', 'shortname', get_string('classesshortname', 'local_clclasses'), $style); $mform->addHelpButton('shortname', 'classesshortname', 'local_clclasses'); $mform->addRule('shortname', get_string('missingclassesshort', 'local_clclasses'), 'required', null, 'client'); $mform->setType('shortname', PARAM_RAW); $mform->addElement('text', 'classlimit', get_string('classlimit', 'local_clclasses'), $style); $mform->addHelpButton('classlimit', 'classlimit', 'local_clclasses'); $mform->addRule('classlimit', get_string('missinglimit', 'local_clclasses'), 'required', null, 'client'); $mform->addRule('classlimit', get_string('numeric', 'local_admission'), 'numeric', null, 'client'); $mform->setType('classlimit', PARAM_RAW); $selecttype = array(); $selecttype['1'] = get_string('clsmode_1', 'local_clclasses'); $selecttype['2'] = get_string('clsmode_2', 'local_clclasses'); $mform->addElement('select', 'type', get_string('classmode', 'local_clclasses'), $selecttype); $mform->addHelpButton('type', 'classmode', 'local_clclasses'); $mform->addRule('type', get_string('missingtype', 'local_clclasses'), 'required', null, 'client'); $mform->setType('type', PARAM_INT); $mform->addElement('hidden', 'addonlinelisthere'); $mform->setType('addonlinelisthere', PARAM_RAW); $mform->addElement('hidden', 'addonlinecoursehere'); $mform->setType('addonlinecoursehere', PARAM_RAW); $mform->addElement('hidden', 'addinstructorhere'); $mform->setType('addinstructorhere', PARAM_RAW); $mform->addElement('editor', 'description', get_string('description', 'local_clclasses'), null); $mform->setType('description', PARAM_RAW); /* $style="style='height:25px !important;'"; $mform->addElement('text', 'fullname', get_string('classesname', 'local_clclasses'),$style); $mform->addHelpButton('fullname', 'classesname', 'local_clclasses'); $mform->addRule('fullname', get_string('missingclassesname','local_clclasses'), 'required', null, 'client'); $mform->setType('fullname', PARAM_RAW); $mform->addElement('text', 'shortname', get_string('classesshortname', 'local_clclasses'),$style); $mform->addHelpButton('shortname', 'classesshortname', 'local_clclasses'); $mform->addRule('shortname', get_string('missingclassesshort','local_clclasses'), 'required', null, 'client'); $mform->setType('shortname', PARAM_RAW); $mform->addElement('editor', 'description', get_string('description', 'local_clclasses'), null, $editoroptions); $mform->setType('description', PARAM_RAW); $mform->addElement('text', 'classlimit',get_string('classlimit','local_clclasses'),$style); $mform->addHelpButton('classlimit', 'classlimit', 'local_clclasses'); $mform->addRule('classlimit', get_string('missinglimit','local_clclasses'), 'required', null, 'client'); $mform->addRule('classlimit', get_string('numeric','local_admission'), 'numeric', null,'client'); $mform->setType('classlimit', PARAM_RAW); $selecttype=array(); $selecttype['1']=get_string('clsmode_1','local_clclasses'); $selecttype['2']=get_string('clsmode_2','local_clclasses'); $mform->addElement('select', 'type',get_string('classmode','local_clclasses'),$selecttype); $mform->addHelpButton('type', 'classmode', 'local_clclasses'); $mform->addRule('type', get_string('missingtype','local_clclasses'), 'required', null, 'client'); $mform->setType('type', PARAM_INT); */ $mform->addElement('html', '<div id="myratings1"></div>'); $mform->addElement('html', '<div id="myratings2"></div>'); $submit = get_string('createclasses', 'local_clclasses'); $time = time(); $userid = $USER->id; $mform->addElement('hidden', 'timecreated', $time); $mform->setType('timecreated', PARAM_INT); $mform->addElement('hidden', 'timemodified', $time); $mform->setType('timemodified', PARAM_INT); $mform->addElement('hidden', 'usermodified', $userid); $mform->setType('usermodified', PARAM_INT); $mform->addElement('hidden', 'id'); $mform->setType('id', PARAM_INT); $actionbutton = ($id > 0) ? get_string('updateclass', 'local_clclasses') : get_string('createclasses', 'local_clclasses'); $this->add_action_buttons($cancel = true, $actionbutton); }
/** * @method school_formelement_condition * @todo to display school field form element based on condition (if multiple school providing drop down box else static field) * @param object $mform * @return array of objects(form elements) */ public function school_formelement_condition($mform) { global $DB, $CFG, $USER; $hier = new hierarchy(); if (is_siteadmin($USER->id)) { $schoolids = $DB->get_records('local_school', array('visible' => 1)); } else $schoolids = $hier->get_assignedschools(); if (!empty($schoolids)) { $count = sizeof($schoolids); if ($count > 1) { $parents = $hier->get_school_parent($schoolids, '', true); $mform->addElement('select', 'schoolid', get_string('select', 'local_collegestructure'), $parents); $mform->addRule('schoolid', get_string('missingschool', 'local_collegestructure'), 'required', null, 'client'); } else { $schoolname = $DB->get_record('local_school', array('id' => $schoolids[0]->id)); $mform->addElement('static', 'sid', get_string('schoolid', 'local_collegestructure'), $schoolname->fullname); $mform->addElement('hidden', 'schoolid', $schoolids[0]->id); } $mform->setType('schoolid', PARAM_INT); } }
/** * @method settingelements * @todo to set form elements * @param object $mform object * @param string $place1 * @param string $place2 * @return array of objects ($mfrom objects) * */ public function settingelements($mform, $place1, $place2) { global $hierarchy; $hierarchy = new hierarchy(); $faculties = $hierarchy->get_assignedschools(); $school = $hierarchy->get_school_parent($faculties); $newel = $mform->createElement('select', 'schoolid', get_string('schoolid', 'local_collegestructure'), $school); $mform->insertElementBefore($newel, $place1); $mform->addRule('schoolid', get_string('missingschool', 'local_collegestructure'), 'required', null, 'client'); $school_value = $mform->getElementValue('schoolid'); //Creating program element after getting the school value if (isset($school_value) && !empty($school_value)) { $school_id = $school_value[0]; $programs = $hierarchy->get_records_cobaltselect_menu('local_program', "schoolid=$school_id AND visible=1", null, '', 'id,fullname', '--Select--'); $newel2 = $mform->createElement('select', 'programid', get_string('selectprogram', 'local_programs'), $programs); $mform->insertElementBefore($newel2, $place2); $mform->addRule('programid', get_string('missingfullname', 'local_programs'), 'required', null, 'client'); $program_value = $mform->getElementValue('programid'); return $program_value; } }
function get_events() { global $DB, $CFG, $USER; $systemcontext = get_context_instance(CONTEXT_SYSTEM); ?> <?php if (is_siteadmin()) { $time = time(); $sql = 'select * from {local_event_activities} where FROM_UNIXTIME("%d-%m-%y",startdate) >= FROM_UNIXTIME("%d-%m-%y",'.$time.') OR FROM_UNIXTIME("%d-%m-%y",'.$time.') <= FROM_UNIXTIME("%d-%m-%y",enddate) LIMIT 0,3'; $eactivities = $DB->get_records_sql($sql); if (!empty($eactivities)) { $data = array(); $i = 1; foreach ($eactivities as $eactivity) { if($i > 3){ break; } $line = array(); $eactivity->startdate = date('d-m-Y', $eactivity->startdate); $startdate = $eactivity->startdate; $eactivity->enddate > 0 ? $eactivity->enddate = date('d-m-Y', $eactivity->enddate) : $eactivity->enddate = ''; $enddate = $eactivity->enddate; $view = new moodle_url('' . $CFG->wwwroot . '/local/academiccalendar/viewevent.php', array('id' => $eactivity->id)); $line[] = html_writer::link($view, $eactivity->eventtitle); if ($enddate) { $line[] = $startdate . ' - ' . $enddate; } else { $line[] = $startdate; } $i++; $data[] = $line; } $table = new html_table(); $table->head = array( get_string('eventtitle', 'local_academiccalendar'), 'Date' ); $table->width = '100%'; $table->align = array('left','left'); $table->size = array('50%','50%'); $table->data = $data; $string = html_writer::table($table); if(sizeof($data) > 3) $string.='<a href="../local/academiccalendar/index.php">View more...</a>'; return $string; } else { $string = '<p>No events created till now.</p>'; return $string; } } elseif (has_capability('local/collegestructure:manage', $systemcontext) && !is_siteadmin()) { $hier = new hierarchy(); $time = time(); $schoolslist = $hier->get_assignedschools(); $array = array(); $schools = $hier->get_school_parent($schoolslist, $array, false, false); foreach ($schools as $key => $value) { if($key!=null) { $schoollist[] = $key; } } $schoollist_string = implode(',', $schoollist); $sql = "select * from {local_event_activities} where eventlevel=2 and schoolid in ( $schoollist_string ) and (FROM_UNIXTIME('%d-%m-%y',startdate) >= FROM_UNIXTIME('%d-%m-%y',$time) OR FROM_UNIXTIME('%d-%m-%y',$time) <= FROM_UNIXTIME('%d-%m-%y',enddate)) LIMIT 0,3"; $eactivities = $DB->get_records_sql($sql); if (!empty($eactivities)) { $data = array(); foreach ($eactivities as $eactivity) { $line = array(); $eactivity->startdate = date('d-m-Y', $eactivity->startdate); $startdate = $eactivity->startdate; $eactivity->enddate > 0 ? $eactivity->enddate = date('d M Y', $eactivity->enddate) : $eactivity->enddate = ''; $enddate = $eactivity->enddate; $view = new moodle_url('' . $CFG->wwwroot . '/local/academiccalendar/viewevent.php', array('id' => $eactivity->id)); $line[] = html_writer::link($view, $eactivity->eventtitle); if ($enddate) { $line[] = $startdate . ' - ' . $enddate; } else { $line[] = $startdate; } $data[] = $line; } $table = new html_table(); $table->head = array( get_string('eventtitle', 'local_academiccalendar'), 'Date' ); $table->width = '100%'; $table->align = array('left', 'left'); $table->size = array('50%', '50%'); $table->data = $data; $string = html_writer::table($table); return $string; } else { $string = '<p>No events created till now.</p>'; return $string; } } else { $time = time(); $userdetails = $DB->get_records('local_userdata', array('userid' => $USER->id)); if ($userdetails) { foreach ($userdetails as $userdetail) { $schoollist[] = $userdetail->schoolid; $programlist[] = $userdetail->programid; } $schoollist_string = implode(',', $schoollist); $programlist_string = implode(',', $programlist); // $string = '<div id="event_tabs"> // <ul> // <li><a href="#fragment-3"><span>Academic Events</span></a></li> // <li><a href="#fragment-2"><span>Global Events</span></a></li> // </ul>'; // // $string.='<div id="fragment-3">'; // $sql = 'select * from {local_event_activities} where (FROM_UNIXTIME("%d-%m-%y",startdate) >= FROM_UNIXTIME("%d-%m-%y",'.$time.') OR // FROM_UNIXTIME("%d-%m-%y",'.$time.') <= FROM_UNIXTIME("%d-%m-%y",enddate)) and // (eventlevel=2 and schoolid in (' . $schoollist_string . ')) OR // ( // eventlevel=3 and schoolid in (' . $schoollist_string . ') AND // programid in (' . $programlist_string . ') // ) LIMIT 0,3'; // // $eactivities1 = $DB->get_records_sql($sql); // // $data = array(); // foreach ($eactivities1 as $eactivity) { // $line = array(); // $eactivity->startdate = strtoupper(date('d-M-Y', $eactivity->startdate)); // $startdate = $eactivity->startdate; // $eactivity->enddate > 0 ? $eactivity->enddate = strtoupper(date('d-M-Y', $eactivity->enddate)) : $eactivity->enddate = ''; // $enddate = $eactivity->enddate; // $view = new moodle_url('' . $CFG->wwwroot . '/local/academiccalendar/viewevent.php', array('id' => $eactivity->id)); // $line[] = html_writer::link($view, $eactivity->eventtitle); // if ($enddate) { // $line[] = $startdate . ' - ' . $enddate; // } else { // $line[] = $startdate; // } // $data[] = $line; // } // $table = new html_table(); // $table->head = array( // get_string('eventtitle', 'local_academiccalendar'), // get_string('date', 'block_classrooms') //// get_string('enddate','local_academiccalendar') // ); // $table->width = '100%'; // $table->align = array('left', 'center'); // $table->size = array('50%', '50%'); // $table->data = $data; // $string.= html_writer::table($table); // if($data) // $string .= '<a href="' . $CFG->wwwroot . '/local/academiccalendar/index.php" > View All </a> '; // else // $string .= '<p>No events created.</p>'; // $string.='</div>'; // // $string.='<div id="fragment-2">'; $sql = 'select * from {local_event_activities} where eventlevel=1 and (FROM_UNIXTIME("%d-%m-%y",startdate) >= FROM_UNIXTIME("%d-%m-%y",'.$time.') OR FROM_UNIXTIME("%d-%m-%y",'.$time.') <= FROM_UNIXTIME("%d-%m-%y",enddate)) LIMIT 0,3'; $eactivities = $DB->get_records_sql($sql); $data1 = array(); foreach ($eactivities as $eactivity) { $line1 = array(); $eactivity->startdate = strtoupper(date('d-M-Y', $eactivity->startdate)); $startdate = $eactivity->startdate; $eactivity->enddate > 0 ? $eactivity->enddate = strtoupper(date('d-M-Y', $eactivity->enddate)) : $eactivity->enddate = ''; $enddate = $eactivity->enddate; $view = new moodle_url('' . $CFG->wwwroot . '/local/academiccalendar/viewevent.php', array('id' => $eactivity->id)); $line1[] = html_writer::link($view, $eactivity->eventtitle); if ($enddate) { $line1[] = $startdate . ' - ' . $enddate; } else { $line1[] = $startdate; } // $line1[] = $enddate; $data1[] = $line1; } $table1 = new html_table(); $table1->head = array( get_string('eventtitle', 'local_academiccalendar'), 'Date' // get_string('enddate','local_academiccalendar') ); $table1->width = '100%'; $table1->align = array('left', 'center'); $table1->size = array('50%', '50%'); $table1->data = $data1; $string.= html_writer::table($table1); if($data1) $string .= '<a href="' . $CFG->wwwroot . '/local/academiccalendar/index.php" > View All </a> '; else $string .= '<p>No events created.</p>'; //$string.='</div>'; //$string .= '</div>'; return $string; } else $string = '<p>You are not registered to any type of courses.</p>'; return $string; } ?> <?php } ?>
function get_usercount($extraselect = '', array $extraparams = null) { global $DB, $CFG, $SESSION; $select = " u.id <> :guestid AND u.deleted = 0"; $params = array('guestid' => $CFG->siteguest); if ($extraselect) { $select .= " AND {$extraselect}"; $params = $params + (array) $extraparams; } if (isset($SESSION->user_filtering['courseid'])) { $sql = "SELECT u.* FROM {user_enrolments} ue\n\t\t\t\t\t\t\t\t\t\tJOIN {enrol} e ON e.id = ue.enrolid\n\t\t\t\t\t\t\t\t\t\tJOIN {user} u ON u.id = ue.userid\n\t\t\t\t\t\t\t\t\t\tJOIN {course} c ON c.id = e.courseid\n\t\t\t\t\t\t\t\t\t\tWHERE c.visible = 1 AND ue.status = 0 AND {$select}"; $users = $DB->get_records_sql($sql, $params); } else { $users = $DB->get_records_sql("SELECT u.*, lu.rosterid\n\t\t\t\t\t\t\t FROM {user} u\n\t\t\t\t\t\t\t JOIN {local_users} lu ON lu.userid = u.id\n\t\t\t\t\t\t\t WHERE {$select}", $params); } $records = array(); if (!empty($users)) { $useridin = implode(',', array_keys($users)); $hierarchy = new hierarchy(); $schoollist = $hierarchy->get_assignedschools(); $schoollist = $hierarchy->get_school_parent($schoollist, $selected = array(), $inctop = false, $all = false); if (is_siteadmin()) { $schoollist = $hierarchy->get_school_items(); } if (!empty($schoollist)) { $schoolidin = implode(',', array_keys($schoollist)); $records = $DB->get_records_sql("(SELECT u.* FROM {user} u\n JOIN {local_users} lu ON lu.userid = u.id\n JOIN {local_school_permissions} sp ON sp.userid = u.id\n\n WHERE u.id in ({$useridin}) AND sp.schoolid IN ({$schoolidin}))\n UNION\n (SELECT u.* FROM {user} u\n JOIN {local_users} lu ON lu.userid = u.id\n JOIN {local_userdata} ud ON ud.userid = u.id\n WHERE u.id in ({$useridin}) AND ud.schoolid IN ({$schoolidin}))"); } } return sizeof($records); }
function definition() { global $USER, $CFG, $DB, $PAGE; $hierarchy = new hierarchy(); $mform = $this->_form; $id = $this->_customdata['id']; $mform->addElement('header', 'settingsheader', get_string('accountingperiod', 'local_onlinepayment')); $schoollist = $hierarchy->get_assignedschools(); if (is_siteadmin()) { $schoollist = $hierarchy->get_school_items(); } $schoollist = $hierarchy->get_school_parent($schoollist, $selected = array(), $inctop = true, $all = false); if ($id < 0) { $mform->addElement('select', 'schoolid', get_string('select', 'local_collegestructure'), $schoollist); $mform->setType('schoolid', PARAM_INT); $mform->addRule('schoolid', get_string('missingschool', 'local_collegestructure'), 'required', null, 'client'); } else { $mform->addElement('static', 'school_name', get_string('schoolname', 'local_collegestructure')); $mform->addElement('hidden', 'schoolid'); $mform->setType('schoolid', PARAM_INT); } $mform->addElement('date_selector', 'datefrom', get_string('startdate', 'local_academiccalendar'), array('optional' => true)); $mform->addElement('date_selector', 'dateto', get_string('enddate', 'local_academiccalendar'), array('optional' => true)); $mform->addRule('datefrom', get_string('missingstartdate', 'local_academiccalendar'), 'required', null, 'client'); $mform->addRule('dateto', get_string('missingenddate', 'local_academiccalendar'), 'required', null, 'client'); $mform->addElement('hidden', 'id'); $mform->setType('id', PARAM_INT); $buttonarray = array(); $buttonarray[] = &$mform->createElement('submit', 'submitbutton', get_string('submit')); $buttonarray[] = &$mform->createElement('cancel'); $mform->addGroup($buttonarray, 'buttonar', '', array(' '), false); }
$yesurl = new moodle_url('/local/curriculum/assigncourses.php', array('id' => $id, 'mode' => $mode, 'cid' => $cid, 'unassign' => 1, 'courseid' => $courseid, 'confirm' => 1, 'sesskey' => sesskey())); $message = get_string('confirmunassign', 'local_curriculum'); echo $OUTPUT->confirm($message, $yesurl, $returnurl); echo $OUTPUT->footer(); die; } //page breadcrumb and header $PAGE->navbar->add(get_string('managecurriculum', 'local_curriculum'), new moodle_url('/local/curriculum/index.php', array('id' => $cid))); if ($id) $PAGE->navbar->add(get_string('manageplan', 'local_curriculum'), new moodle_url('/local/curriculum/viewcurriculum.php', array('id' => $cid, 'assign' => 1))); $PAGE->navbar->add(get_string('assigncourses', 'local_curriculum')); echo $OUTPUT->header(); echo $OUTPUT->heading(get_string('managecurriculum', 'local_curriculum')); //try{ $schoollist = $hierarchy->get_assignedschools(); if (is_siteadmin()) { $schoollist = $hierarchy->get_school_items(); } $count = count($schoollist); //Count of schools to which registrar is assigned if ($count < 1) { throw new Exception(get_string('notassignedschool', 'local_collegestructure')); } //Tab view $curriculum = new curricula(); $curriculum->print_curriculumtabs($mode); if ($id) $plan = $DB->get_record('local_curriculum_plan', array('id' => $id)); $cur = $DB->get_record('local_curriculum', array('id' => $cid)); if ($id)
/** * @method ac_hierarchyelements * @todo creates hierarchy elements in form (school,program and semester) * @param1 object $mform (form object) * @param2 string $place1 (element1 position) * @param3 string $place2 (element2 position) * @param4 int $eventlevel (event level ID) * @param5 int $eventtypeid (event type ID) * @return form elments add to form */ public function ac_hierarchyelements($mform, $place1, $place2, $eventlevel, $eventtype) { global $USER, $DB; $hierarchy = new hierarchy(); if ($eventlevel != 1) { $isadmin = is_siteadmin($USER); if ($isadmin) { $school = $hierarchy->get_records_cobaltselect_menu('local_school', 'visible=1', null, '', 'id,fullname', '--Select--'); } else { $faculties = $hierarchy->get_assignedschools(); $school = $hierarchy->get_school_parent($faculties, null, true, false); } $newel = $mform->createElement('select', 'schoolid', get_string('schoolid', 'local_collegestructure'), $school); $mform->insertElementBefore($newel, $place1); $mform->addRule('schoolid', get_string('missingschool', 'local_collegestructure'), 'required', null, 'client'); $school_value = $mform->getElementValue('schoolid'); } /* ---Creating program element after getting the school value--- */ if (isset($school_value) && !empty($school_value) && $school_value[0] > 0 && $eventlevel == 3) { $school_id = $school_value[0]; $programs = $hierarchy->get_records_cobaltselect_menu('local_program', "schoolid=$school_value[0] AND visible=1", null, '', 'id,fullname', '--Select--'); $newel2 = $mform->createElement('select', 'programid', get_string('program', 'local_programs'), $programs); $mform->insertElementBefore($newel2, $place2); $mform->addRule('programid', get_string('missingfullname', 'local_programs'), 'required', null, 'client'); $program_value = $mform->getElementValue('programid'); return $program_value; } if (isset($school_value) && !empty($school_value) && $school_value[0] > 0 && $eventlevel == 4) { $school_id = $school_value[0]; //if ($eventtype == 2) // $semesters = $hierarchy->get_upcoming_school_semesters($school_id); //else $semesters = $hierarchy->get_school_semesters($school_id); $newel2 = $mform->createElement('select', 'semesterid', get_string('semester', 'local_semesters'), $semesters); $mform->insertElementBefore($newel2, $place2); $mform->addRule('semesterid', get_string('semester_help', 'local_semesters'), 'required', null, 'client'); $sem_value = $mform->getElementValue('semesterid'); if($sem_value[0]){ $this->static_description_dateselection($mform, $sem_value[0],$eventtype,$school_id,1); } return $sem_value; } }