芝麻web文件管理V1.00
编辑当前文件:/home2/sdektunc/www/cepali/filter/data/filter.php
. /** * This filter provides automatic linking to database activity entries * when found inside every Moodle text. * * @package filter * @subpackage data * @copyright 2006 Vy-Shane Sin Fat * @license http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later */ defined('MOODLE_INTERNAL') || die(); /** * Database activity filtering */ class filter_data extends moodle_text_filter { public function filter($text, array $options = array()) { global $CFG, $DB, $USER; // Trivial-cache - keyed on $cachedcourseid + $cacheduserid. static $cachedcourseid = null; static $cacheduserid = null; static $coursecontentlist = array(); static $sitecontentlist = array(); static $nothingtodo; // Try to get current course. $coursectx = $this->context->get_course_context(false); if (!$coursectx) { // We could be in a course category so no entries for courseid == 0 will be found. $courseid = 0; } else { $courseid = $coursectx->instanceid; } if ($cacheduserid !== $USER->id) { // Invalidate all caches if the user changed. $coursecontentlist = array(); $sitecontentlist = array(); $cacheduserid = $USER->id; $cachedcourseid = $courseid; $nothingtodo = false; } else if ($courseid != get_site()->id && $courseid != 0 && $cachedcourseid != $courseid) { // Invalidate course-level caches if the course id changed. $coursecontentlist = array(); $cachedcourseid = $courseid; $nothingtodo = false; } if ($nothingtodo === true) { return $text; } // If courseid == 0 only site entries will be returned. if ($courseid == get_site()->id || $courseid == 0) { $contentlist = & $sitecontentlist; } else { $contentlist = & $coursecontentlist; } // Create a list of all the resources to search for. It may be cached already. if (empty($contentlist)) { $coursestosearch = $courseid ? array($courseid) : array(); // Add courseid if found if (get_site()->id != $courseid) { // Add siteid if was not courseid $coursestosearch[] = get_site()->id; } // We look for text field contents only if have autolink enabled (param1) list ($coursesql, $params) = $DB->get_in_or_equal($coursestosearch); $sql = 'SELECT dc.id AS contentid, dr.id AS recordid, dc.content AS content, d.id AS dataid FROM {data} d JOIN {data_fields} df ON df.dataid = d.id JOIN {data_records} dr ON dr.dataid = d.id JOIN {data_content} dc ON dc.fieldid = df.id AND dc.recordid = dr.id WHERE d.course ' . $coursesql . ' AND df.type = \'text\' AND ' . $DB->sql_compare_text('df.param1', 1) . " = '1'"; if (!$contents = $DB->get_records_sql($sql, $params)) { $nothingtodo = true; return $text; } foreach ($contents as $key => $content) { // Trim empty or unlinkable concepts $currentcontent = trim(strip_tags($content->content)); if (empty($currentcontent)) { unset($contents[$key]); continue; } else { $contents[$key]->content = $currentcontent; } // Rule out any small integers. See bug 1446 $currentint = intval($currentcontent); if ($currentint && (strval($currentint) == $currentcontent) && $currentint < 1000) { unset($contents[$key]); } } if (empty($contents)) { $nothingtodo = true; return $text; } usort($contents, 'filter_data::sort_entries_by_length'); foreach ($contents as $content) { $href_tag_begin = '
wwwroot.'/mod/data/view.php?d='.$content->dataid. '&rid='.$content->recordid.'">'; $contentlist[] = new filterobject($content->content, $href_tag_begin, '
', false, true); } $contentlist = filter_remove_duplicates($contentlist); // Clean dupes } return filter_phrases($text, $contentlist); // Look for all these links in the text } private static function sort_entries_by_length($content0, $content1) { $len0 = strlen($content0->content); $len1 = strlen($content1->content); if ($len0 < $len1) { return 1; } else if ($len0 > $len1) { return -1; } else { return 0; } } }