Lines Matching refs:data
4 * List related pages based on similar data in the given column(s)
32 * @param array $data data created by handler()
35 public function render($format, Doku_Renderer $renderer, $data)
38 if (is_null($data)) return false;
44 if (!$data['sql']) return true; // sql build
45 $this->dthlp->replacePlaceholdersInSQL($data);
47 $rows = $sqlite->queryAll($data['sql']);
50 $renderer->doc .= '<dl class="' . $data['classes'] . '">';
51 $renderer->doc .= '<dt>' . htmlspecialchars($data['title']) . '</dt>';
67 * Builds the SQL query from the given data
69 public function buildSQL(&$data, $id = null)
85 foreach (array_keys($data['cols']) as $col) {
88 FROM data A, pages B
107 if ($data['sort'][0]) {
108 $col = $data['sort'][0];
111 $order = ', pages.page ' . $data['sort'][1];
113 $order = ', pages.title ' . $data['sort'][1];
118 $from .= ' LEFT JOIN data AS ' . $tables[$col] . ' ON ' . $tables[$col] . '.pid = pages.pid';
122 $order = ', ' . $tables[$col] . '.value ' . $data['sort'][1];
129 if (is_array($data['filter']) && count($data['filter'])) {
132 foreach ($data['filter'] as $filter) {
150 $from .= ' LEFT JOIN data AS ' . $tables[$col] . ' ON ' . $tables[$col] . '.pid = pages.pid';
164 FROM pages, data as T1 $from
172 if ($data['limit']) {
173 $sql .= ' LIMIT ' . ($data['limit']);