1.8
* @date 02/12/2007
*
* Prints list of user's stored queries
*/
if (!defined('MOODLE_INTERNAL')) {
die('Direct access to this script is forbidden.'); /// It must be included from view.php in mod/tracker
}
$queries = $DB->get_records_select('tracker_query', "userid = {$USER->id} AND trackerid = {$tracker->id} ");
echo $OUTPUT->heading(get_string('myqueries', 'tracker'));
echo $OUTPUT->box_start('center', '80%', '', '', 'generalbox', 'tracker-queries');
echo '
';
if (!empty($queries)){
$searchstr = get_string('query', 'tracker');
$namestr = get_string('name');
$descriptionstr = get_string('description');
$actionstr = get_string('action', 'tracker');
$table->head = array("$searchstr", "$namestr", "$descriptionstr", "$actionstr");
$table->size = array(50, 100, 500, 100);
$table->align = array('center', 'left', 'center', 'center');
foreach ($queries as $query){
$fields = tracker_extractsearchparametersfromdb($query->id);
$query->description = tracker_printsearchfields($fields);
$searchlink = "id}&view=view&screen=browse&what=usequery&queryid={$query->id}\" title=\"".get_string('searchwiththat', 'tracker')."\">
pix_url('search','mod_tracker')."\" border=\"0\" />";
$action = "id}&what=editquery&queryid={$query->id}\" title=\"".get_string('update')."\" >
pix_url('t/edit','core')."\" />";
$action .= " id}&what=deletequery&queryid={$query->id}\" title=\"".get_string('delete')."\" >
pix_url('t/delete','core')."\" />";
$table->data[] = array($searchlink, " {$query->name}", format_string($query->description), $action);
}
echo html_writer::table($table);
} else {
print_string('noqueryssaved', 'tracker');
}
echo '';
echo $OUTPUT->box_end();