$data = array();
foreach($adminqueries as $adminquery){
$row = array();
$adminqueryid = $adminquery->id;
$postedby = $adminquery->postedby;
$posteduser = $DB->get_record_sql("SELECT * FROM {user} WHERE id=$postedby");
$studentname = html_writer:: tag('a',$posteduser->firstname,array('href'=>$CFG->wwwroot.'/user/profile.php?id='.$posteduser->id));
$date_admin = date("d/m/y h:i a",$adminquery->timecreated);
if($adminquery->status == 0){
$ifelse_admin = get_string('notresponded','block_queries');
} else {
$ifelse_admin = get_string('responded','block_queries');
}
$click_admin = html_writer:: empty_tag('img',array('src'=>$CFG->wwwroot.'/pix/t/message.svg',"id"=>"showDialog$adminqueryid","class"=>"commenticonpostion","onclick"=>"mycommentpopupform($adminqueryid)"));
$popup_admin = commenthtmlform($adminqueryid);
//here we are calling js fuction to get the toggle
$comment='<a href="javascript:void(0)" onclick="view('.$adminquery->id.')">View comments</a>';
//here we are showing the table content in a list-----------------
$profilepicture = $OUTPUT->user_picture($posteduser,array('size'=>35));
$test ='<div><div>
<div class="profilepicture">'.$profilepicture.'</div>
<p class="subjectclass"><b>'.$adminquery->subject.'</b><br>'.get_string("by","block_queries").' '.$studentname.' - '.$date_admin.'</p>
<hr class="horizontalline">
<p class="comment_summary">'.$adminquery->description.'</p>
<div class="informationdiv"><b>'.get_string('status','block_queries').': </b>'.$ifelse_admin.'<b> | '.get_string('comment','block_queries').': </b>'.$click_admin.' | '.$comment.'</div>
</div>
<div class="toggle_style"><span style="display:none;" class="toggle'.$adminquery->id.'">';
/********* code for display comments in toggle-started here************/
function blockqueries_tablecontent($sql){
global $CFG, $USER, $PAGE, $DB;
$blockqueries_displaycontent = array();
$querieslists=$DB->get_records_sql($sql);
$data = array();
foreach($querieslists as $querieslist){
$row = array();
$adminqueryid = $querieslist->id;
$row[] = html_writer:: tag('p',$querieslist->subject,array());
$comment_image = html_writer:: empty_tag('img',array('src'=>$CFG->wwwroot.'/pix/t/message.svg',"id"=>"showDialog$adminqueryid",'title'=>get_string('addacomment','block_queries'),'onclick'=>"mycommentpopupform($adminqueryid)",'class'=>'queries_iconclass'));
$comment_popup = commenthtmlform($adminqueryid);
$row[] = $comment_image.$comment_popup;
$data[] = $row;
}
$table = new html_table();
$table->head = array(get_string('subjectt','block_queries'),get_string('comment','block_queries'));
$table->width = '100%';
$table->size = array('95%','5%');
$table->align = array('left','center');
$table->data = $data;
$blockqueries_displaycontent[] = html_writer::table($table);
$blockqueries_displaycontent[] = html_writer:: tag('a',get_string('mypreviewqueries','block_queries'),array('href'=>$CFG->wwwroot.'/blocks/queries/display_queries.php'));
$blockqueries_displaycontent = implode('',$blockqueries_displaycontent);
return $blockqueries_displaycontent;
}
