public function get_content() { global $DB; if ($this->content !== null) { return $this->content; } global $CFG, $USER, $PAGE; $this->content = new stdClass(); require_once($CFG->dirroot.'/blocks/queries/lib.php'); require_once($CFG->dirroot.'/blocks/queries/commentform.php'); require_once($CFG->dirroot.'/blocks/queries/queries_form.php'); //query to enrol users courses particulars $courses = enrol_get_users_courses($USER->id); //calling function for if login user instructor or not $instructorlogin = block_queries_getrole_user($courses,'instructor'); //calling function for if login user registrar or not $registrarlogin = block_queries_getrole_user($courses,'registrar'); //calling function for if login user student or not $studentlogin = block_queries_getrole_user($courses,'student'); /************calling function for getting data to the logged in user*************/ $this->content->text = block_queries_display_view($USER,$instructorlogin,$registrarlogin,$studentlogin); $this->content->footer = ''; $this->page->requires->js('/blocks/queries/js/commentform_popup.js'); // Return the content object return $this->content; }
else{ $test .= html_writer:: tag('p',get_string('nocomments','block_queries')); } /*********end of code for display comments in toggle-starts here************/ $test.='</span></div></div>'; $test.= $popup; $row[]=$test; $data[]=$row; } } } //for login user is a registrar $courses = enrol_get_users_courses($USER->id); $registrarlogin = block_queries_getrole_user($courses,'registrar'); if(!empty($registrarlogin)){ $registrarresponses = $DB->get_records_sql("SELECT * FROM {block_queries} WHERE userid = $USER->id AND userrole = 'registrar' ORDER BY id DESC"); $data = array(); foreach($registrarresponses as $registrarresponse){ $row = array(); $reg_id = $registrarresponse->id; $postedby = $registrarresponse->postedby; $posteduser = $DB->get_record_sql("SELECT * FROM {user} WHERE id=$postedby"); $studentname = fullname($posteduser); $date_registrar = date("d/m/y h:i a",$registrarresponse->timecreated); if($registrarresponse->status == 0){ $ifelse_registrar = get_string('notresponded','block_queries'); }else { $ifelse_registrar = get_string('responded','block_queries');