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;
}
