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();