Lines Matching defs:data
15 * will hold the data helper plugin
25 $this->dthlp = plugin_load('helper', 'data');
27 msg('Loading the data helper failed. Make sure the data plugin is installed.', -1);
70 * Builds the SQL query from the given data
72 * @param array &$data instruction by handler
75 public function buildSQL(&$data)
77 $ckey = array_keys($data['cols']);
90 if (is_array($data['filter']) && count($data['filter'])) {
93 foreach ($data['filter'] as $filter) {
101 $pagesjoin = ' LEFT JOIN pages ON pages.pid = data.pid';
106 $from .= ' LEFT JOIN data AS ' . $tables[$col] . ' ON ' . $tables[$col] . '.pid = data.pid';
117 $sql = "SELECT data.value AS value, COUNT(data.pid) AS cnt
118 FROM data $from $pagesjoin
119 WHERE data.key = " . $sqlite->getPdo()->quote($ckey) . "
121 GROUP BY data.value";
122 if (isset($data['min'])) {
123 $sql .= ' HAVING cnt >= ' . $data['min'];
126 if ($data['limit']) {
127 $sql .= ' LIMIT ' . $data['limit'];
139 * Create output or save the data
143 * @param $data
146 public function render($format, Doku_Renderer $renderer, $data)
151 if (is_null($data)) return false;
158 $ckey = array_keys($data['cols']);
161 if (!isset($data['page'])) {
162 $data['page'] = $ID;
165 $this->dthlp->replacePlaceholdersInSQL($data);
167 // build cloud data
168 $rows = $sqlite->queryAll($data['sql']);
183 $renderer->doc .= sprintf($this->before_item, hsc($data['classes']));
186 if ($data['summarize'] == 1) {
192 wl($data['page'], $this->dthlp->getTagUrlparam($data['cols'][$ckey], $tag['value'])) .