function block_queries_display_view($USER,$instructorlogin,$registrarlogin,$studentlogin){ global $CFG, $USER, $PAGE, $DB; $blockqueries_returncontent = array(); $sql ="SELECT * FROM {block_queries} WHERE userid = $USER->id"; if(is_siteadmin($USER->id)){ $sql .=" AND userrole = 'admin' ORDER BY id DESC LIMIT 3"; $blockqueries_returncontent[]=blockqueries_tablecontent($sql); $blockqueries_returncontent = implode('',$blockqueries_returncontent); } elseif(!empty($instructorlogin) ){ $sql .=" AND userrole = 'instructor' ORDER BY id DESC LIMIT 3"; $blockqueries_returncontent[]=blockqueries_tablecontent($sql); $blockqueries_returncontent = implode('',$blockqueries_returncontent); } elseif(!empty($registrarlogin)){ $sql .=" AND userrole = 'registrar' ORDER BY id DESC LIMIT 3"; $blockqueries_returncontent[]=blockqueries_tablecontent($sql); $blockqueries_returncontent = implode('',$blockqueries_returncontent); } elseif(!empty($studentlogin)){ $formdata = new stdClass(); $actionpage = $CFG->wwwroot.'/blocks/queries/sendingemail.php'; $mform= new block_queries_form($actionpage); $blockqueries_returncontent[] = $mform->render(); //to display form in block $blockqueries_returncontent = implode('',$blockqueries_returncontent); } else { $blockqueries_returncontent[] = html_writer:: tag('p',get_string('noprevioussubjects','block_queries'),array()); } return $blockqueries_returncontent; } // end of function
public function get_content() { global $DB; if ($this->content !== null) { return $this->content; } global $CFG, $USER; $this->content = new stdClass(); require_once $CFG->dirroot . '/blocks/queries/queries_form.php'; $courses = enrol_get_users_courses($USER->id); //print_object($courses); $instructorlogin = array(); foreach ($courses as $course) { $sql = "SELECT u.id, u.email, u.firstname, u.lastname\n FROM {context} AS cxt\n JOIN {role_assignments} AS ra\n ON cxt.id = ra.contextid \n JOIN {user} AS u\n ON ra.userid = u.id\n WHERE cxt.instanceid = {$course->id} AND ra.roleid = 10 AND cxt.contextlevel = 50 AND u.id = {$USER->id}"; $instructor = $DB->get_record_sql($sql); if ($instructor) { $instructorlogin[] = $instructor->id; } } $registrarlogin = array(); foreach ($courses as $course) { $sql = "SELECT u.id, u.email, u.firstname, u.lastname\n FROM {context} AS cxt\n JOIN {role_assignments} AS ra\n ON cxt.id = ra.contextid \n JOIN {user} AS u\n ON ra.userid = u.id\n WHERE cxt.instanceid = {$course->id} AND ra.roleid = 9 AND cxt.contextlevel = 50 AND u.id = {$USER->id}"; $registrarrecord = $DB->get_record_sql($sql); if ($registrarrecord) { $registrarlogin[] = $registrarrecord->id; } } $studentlogin = array(); foreach ($courses as $course) { $sql = "SELECT u.id, u.email, u.firstname, u.lastname\n FROM {context} AS cxt\n JOIN {role_assignments} AS ra\n ON cxt.id = ra.contextid \n JOIN {user} AS u\n ON ra.userid = u.id\n WHERE cxt.instanceid = {$course->id} AND ra.roleid = 5 AND cxt.contextlevel = 50 AND u.id = {$USER->id}"; $studentrecord = $DB->get_record_sql($sql); if ($studentrecord) { $studentlogin[] = $studentrecord->id; } } if (is_siteadmin($USER->id)) { $adminqueries = $DB->get_records_sql("SELECT * FROM {queries} WHERE userid = 2 AND userrole = 'admin' ORDER BY 'timecreated' DESC LIMIT 5"); //print_object($adminqueries); if ($adminqueries) { $data = array(); foreach ($adminqueries as $adminquery) { //print_object(date('d/m/Y h:m a',$adminquery->timecreated)); //print_object($adminquery->timecreated); $row = array(); $adm_decription = html_writer::tag('span', $adminquery->description, array()); $row[] = html_writer::tag('p', $adminquery->subject . $adm_decription, array('class' => 'tooltip1')); //$row[] = "<input type= 'submit' name='submit' value='submit'>"; $row[] = html_writer::empty_tag('img', array('src' => $CFG->wwwroot . '/pix/i/feedback_add.gif')); $description = html_writer::tag('span', $adminquery->description, array()); $data[] = $row; } } $table = new html_table(); $table->head = array('Subject', ''); $table->width = '100%'; $table->size = array('90%', '10%'); $table->data = $data; $this->content->text[] = html_writer::table($table); $this->content->text[] = html_writer::tag('a', get_string('mypreviewqueries', 'block_queries'), array('href' => $CFG->wwwroot . '/blocks/queries/display_queries.php')); $this->content->text = implode('', $this->content->text); } elseif (!empty($instructorlogin)) { $instructorqueries = $DB->get_records_sql("SELECT * FROM {queries} WHERE userid = {$USER->id} AND userrole = 'instructor' ORDER BY 'timecreated' DESC LIMIT 5"); if ($instructorqueries) { $data = array(); foreach ($instructorqueries as $instructorquery) { $row = array(); $ins_decription = html_writer::tag('span', $instructorquery->description, array()); $row[] = html_writer::tag('p', $instructorquery->subject . $ins_decription, array('class' => 'tooltip1')); $row[] = html_writer::empty_tag('img', array('src' => $CFG->wwwroot . '/pix/i/feedback_add.gif')); $data[] = $row; } //print_object($data);exit; } $table = new html_table(); $table->head = array('Subject', 'comment'); $table->width = '100%'; $table->data = $data; $this->content->text[] = html_writer::table($table); $this->content->text[] = html_writer::tag('a', get_string('mypreviewqueries', 'block_queries'), array('href' => $CFG->wwwroot . '/blocks/queries/display_queries.php')); $this->content->text = implode('', $this->content->text); } elseif (!empty($registrarlogin)) { $registrarqueries = $DB->get_records_sql("SELECT * FROM {queries} WHERE userid = {$USER->id} AND userrole = 'registrar' ORDER BY 'timecreated' DESC LIMIT 5"); //print_object($instructorqueries); if ($registrarqueries) { $data = array(); foreach ($registrarqueries as $registrarquery) { $row = array(); $reg_decription = html_writer::tag('span', $registrarquery->description, array()); $row[] = html_writer::tag('p', $registrarquery->subject . $reg_decription, array('class' => 'tooltip1')); $row[] = html_writer::empty_tag('img', array('src' => $CFG->wwwroot . '/pix/i/feedback_add.gif')); $registrardecription = $registrarquery->description; $data[] = $row; } } $table = new html_table(); $table->head = array('Subject', ''); $table->width = '100%'; $table->size = array('90%', '10%'); $table->data = $data; $this->content->text[] = html_writer::table($table); $this->content->text[] = html_writer::tag('a', get_string('mypreviewqueries', 'block_queries'), array('href' => $CFG->wwwroot . '/blocks/queries/display_queries.php')); $this->content->text = implode('', $this->content->text); } elseif (!empty($studentlogin)) { $formdata = new stdClass(); $actionpage = $CFG->wwwroot . '/blocks/queries/sendingemail.php'; $mform = new block_queries_form($actionpage); $this->content->text = $mform->render(); //to display form in block //$this->content->text = $mform->display(); //to display form in block //$toinsertrecord = new stdclass(); //if($formdata = $mform->get_data()) { // $toinsertrecord->usertype = $formdata->usertype; // if(($formdata->usertype === 'instructor') && ($formdata->instrs > 0)){ // $toinsertrecord->userid = $formdata->instrs; // } // elseif(($formdata->usertype === 'registrar') && $formdata->registrs > 0){ // $toinsertrecord->userid = $formdata->registrs; // } // elseif(($formdata->usertype === 'admin') && $formdata->siteadmin > 0){ // $toinsertrecord->userid = $formdata->siteadmin; // } // $toinsertrecord->subject = $formdata->subject; // $toinsertrecord->description = $formdata->description['text']; // $toinsertrecord->description_format = $formdata->description['format']; // $toinsertrecord->postedby = $USER->id; // $toinsertrecord->status = 0; // $toinsertrecord->timecreated = time(); // // $DB->insert_record('queries',$toinsertrecord ); //} } //// Return the content object return $this->content; }