| /plugin/struct/meta/ |
| H A D | Search.php | 104 * @param string $colname may contain an alias
106 public function addColumn($colname) argument
108 if ($this->processWildcard($colname)) return; // wildcard?
109 if ($colname[0] == '-') { // remove column from previous wildcard lookup
110 $colname = substr($colname, 1);
112 if ($col->getLabel() === $colname) unset($this->columns[$key]);
117 $col = $this->findColumn($colname);
128 * @param string $colname may contain an alias
132 public function addSort($colname, $asc = true, $nc = true) argument
134 $col = $this->findColumn($colname);
[all …]
|
| H A D | AccessTable.php | 210 foreach ($data as $colname => $value) {
211 if (!isset($colrefs[$colname])) {
212 throw new StructException("Unknown column %s in schema.", hsc($colname));
215 $this->singleCols[] = 'col' . $colrefs[$colname];
218 $this->multiValues[] = [$colrefs[$colname], $index + 1, $multivalue];
224 $this->handleEmptyMulti($this->pid, $this->rid, $colrefs[$colname]);
509 $colname = 'col' . $colref;
524 $col->getType()->select($QB, 'DATA', $colname, $outname);
|
| H A D | SearchCloud.php | 66 $colname = $MN . '.value';
69 $colname = $datatable . '.' . $col->getColName();
71 $QB->addSelectStatement("COUNT($colname)", 'count');
|
| H A D | SearchConfigParameters.php | 42 [$colname, $sort] = $confHlp->parseSort($INPUT->str(self::$PARAM_SORT));
43 $this->setSort($colname, $sort);
48 [$colname, $comp, $value, ] = $confHlp->parseFilterLine('AND', $colcomp . $filter);
49 $this->addFilter($colname, $comp, $value);
|
| H A D | SearchSQLBuilder.php | 170 $colname = $col->getColName(false);
171 if ($nc) $colname .= ' COLLATE NOCASE';
172 … $col->getType()->sort($this->qb, 'data_' . $col->getTable(), $colname, $asc ? 'ASC' : 'DESC');
|
| /plugin/struct/types/ |
| H A D | Page.php | 121 * @param string $colname
124 public function select(QueryBuilder $QB, $tablealias, $colname, $alias) argument
127 parent::select($QB, $tablealias, $colname, $alias);
131 … $QB->addLeftJoin($tablealias, 'titles', $rightalias, "$tablealias.$colname = $rightalias.pid");
132 $QB->addSelectStatement("STRUCT_JSON($tablealias.$colname, $rightalias.title)", $alias);
140 * @param string $colname
143 public function sort(QueryBuilder $QB, $tablealias, $colname, $order) argument
146 parent::sort($QB, $tablealias, $colname, $order);
151 … $QB->addLeftJoin($tablealias, 'titles', $rightalias, "$tablealias.$colname = $rightalias.pid");
153 $QB->addOrderBy("$tablealias.$colname $order");
[all …]
|
| H A D | AutoSummary.php | 16 * @param string $colname
19 public function select(QueryBuilder $QB, $tablealias, $colname, $alias) argument
31 * @param string $colname
34 public function sort(QueryBuilder $QB, $tablealias, $colname, $order) argument
46 * @param string $colname
51 public function filter(QueryBuilderWhere $add, $tablealias, $colname, $comp, $value, $op) argument
|
| H A D | Lookup.php | 234 * @param string $colname
237 public function select(QueryBuilder $QB, $tablealias, $colname, $alias) argument
242 parent::select($QB, $tablealias, $colname, $alias);
252 "STRUCT_LOOKUP($tablealias.$colname, 0) = $rightalias.pid " .
253 "AND STRUCT_LOOKUP($tablealias.$colname, 1) = $rightalias.rid " .
258 $QB->addSelectStatement("STRUCT_JSON($tablealias.$colname, $sql)", $alias);
266 * @param string $colname
271 public function filter(QueryBuilderWhere $add, $tablealias, $colname, $comp, $value, $op) argument
276 parent::filter($add, $tablealias, $colname, $comp, $value, $op);
288 … "$tablealias.$colname = STRUCT_JSON($rightalias.pid, CAST($rightalias.rid AS DECIMAL)) AND " .
[all …]
|
| H A D | DateTime.php | 102 * @param string $colname
105 public function select(QueryBuilder $QB, $tablealias, $colname, $alias) argument
107 $col = "$tablealias.$colname";
122 * @param string $colname
127 public function filter(QueryBuilderWhere $add, $tablealias, $colname, $comp, $value, $op) argument
129 $col = "$tablealias.$colname";
155 * @param string $colname
158 public function sort(QueryBuilder $QB, $tablealias, $colname, $order) argument
160 $col = "$tablealias.$colname";
|
| H A D | User.php | 120 * @param string $colname
123 public function select(QueryBuilder $QB, $tablealias, $colname, $alias) argument
132 parent::select($QB, $tablealias, $colname, $alias);
140 * @param string $colname
143 public function sort(QueryBuilder $QB, $tablealias, $colname, $order) argument
152 $QB->addOrderBy("$tablealias.$colname $order");
160 * @param string $colname
165 public function filter(QueryBuilderWhere $add, $tablealias, $colname, $comp, $value, $op) argument
179 parent::filter($add, $tablealias, $colname, $comp, $value, $op);
|
| H A D | Decimal.php | 147 * @param string $colname
150 public function sort(QueryBuilder $QB, $tablealias, $colname, $order) argument
152 $QB->addOrderBy("CAST($tablealias.$colname AS DECIMAL) $order");
160 * @param string $colname
165 public function filter(QueryBuilderWhere $add, $tablealias, $colname, $comp, $value, $op) argument
168 $add->where('AND', "$tablealias.$colname != ''");
180 $add->where($op, "CAST($tablealias.$colname AS DECIMAL) $comp CAST($pl AS DECIMAL)");
|
| H A D | AbstractBaseType.php | 375 * @param string $colname The column name on above table to use in the SQL
380 public function filter(QueryBuilderWhere $add, $tablealias, $colname, $comp, $value, $op) argument
389 $add->where($op, "$tablealias.$colname $comp $pl");
410 * @param string $colname The column name on above table
413 public function select(QueryBuilder $QB, $tablealias, $colname, $alias) argument
415 $QB->addSelectColumn($tablealias, $colname, $alias);
426 * @param string $colname The column name on above table (always single column!)
432 public function sort(QueryBuilder $QB, $tablealias, $colname, $order) argument
434 $QB->addOrderBy("$tablealias.$colname COLLATE NOCASE $order");
|
| H A D | TraitFilterPrefix.php | 22 * @param string $colname
27 public function filter(QueryBuilderWhere $add, $tablealias, $colname, $comp, $value, $op) argument
36 $column = "$tablealias.$colname";
|
| H A D | Tag.php | 122 * @param string $colname
127 public function filter(QueryBuilderWhere $add, $tablealias, $colname, $comp, $value, $op) argument
136 …$add->where($op, "LOWER(REPLACE($tablealias.$colname, ' ', '')) $comp LOWER(REPLACE($pl, ' ', ''))…
|
| /plugin/structnumber/types/ |
| D | Number.php | 94 * @param string $colname
97 public function sort(QueryBuilder $QB, $tablealias, $colname, $order) argument
99 $QB->addOrderBy("CAST($tablealias.$colname AS DECIMAL) $order");
107 * @param string $colname
112 public function filter(QueryBuilderWhere $add, $tablealias, $colname, $comp, $value, $op) argument
115 $add->where('AND', "$tablealias.$colname != ''"); // make sure the field isn't empty
126 $add->where($op, "CAST($tablealias.$colname AS DECIMAL) $comp CAST($pl AS DECIMAL)");
|
| /plugin/structjoin/types/ |
| D | Join.php | 90 * @param string $colname
94 public function select(QueryBuilder $QB, $tablealias, $colname, $alias) { argument
97 AbstractBaseType::select($QB, $tablealias, $colname, $alias);
146 * @param string $colname
151 public function filter(QueryBuilderWhere $add, $tablealias, $colname, $comp, $value, $op) { argument
155 AbstractBaseType::filter($add, $tablealias, $colname, $comp, $value, $op);
174 * @param string $colname
178 public function sort(QueryBuilder $QB, $tablealias, $colname, $order) { argument
182 AbstractBaseType::sort($QB, $tablealias, $colname, $order);
|
| /plugin/structstatus/ |
| D | Status.php | 101 * @param string $colname
104 public function select(QueryBuilder $QB, $tablealias, $colname, $alias) { argument
112 AbstractBaseType::select($QB, $tablealias, $colname, $alias);
136 …"$tablealias.$colname = STRUCT_JSON($rightalias.pid, CAST($rightalias.rid AS DECIMAL)) AND $righta…
140 …$QB->addSelectStatement("STRUCT_JSON($tablealias.$colname, $field_status, $field_color, $field_ico…
152 $colname = $col->getLabel();
156 $search->addColumn($colname);
159 $search->addSort($colname);
|
| /plugin/structprogress/types/ |
| D | Progress.php | 127 * @param string $colname
130 public function sort(QueryBuilder $QB, $tablealias, $colname, $order) argument
132 $QB->addOrderBy("CAST($tablealias.$colname AS DECIMAL) $order");
140 * @param string $colname
145 public function filter(QueryBuilderWhere $add, $tablealias, $colname, $comp, $value, $op) argument
148 $add->where('AND', "$tablealias.$colname != ''"); // make sure the field isn't empty
159 $add->where($op, "CAST($tablealias.$colname AS DECIMAL) $comp CAST($pl AS DECIMAL)");
|
| /plugin/struct/helper/ |
| H A D | field.php | 202 $colname = $field->getColumn()->getFullQualifiedLabel();
209 $html .= "<label class=\"$lclass\" data-column=\"$colname\" for=\"$id\">";
221 * @param string $colname
225 protected function findColumn($colname) argument
227 [$table, $label] = explode('.', $colname, 2);
229 throw new StructException('Field \'%s\' not given in schema.field form', $colname);
|
| /plugin/struct/action/ |
| H A D | ajax.php | 69 [$schema, $colname] = explode('.', $col, 2);
70 if (blank($schema) || blank($colname)) throw new StructException('Column format is wrong');
75 $column = $schema->findColumn($colname);
|
| H A D | migration.php | 160 $colname = "col$colno";
167 $s = sprintf($f, $name, $colname, $colname, $colname, $colname, $colname);
|
| H A D | edit.php | 164 $colname = $field->getColumn()->getFullQualifiedLabel();
177 $html .= "<label $hide data-column=\"$colname\" for=\"$id\">";
|
| /plugin/structat/meta/ |
| D | SearchConfigAt.php | 172 $colname = $col->getColName(false);
173 if($nc) $colname .= ' COLLATE NOCASE';
174 $col->getType()->sort($QB, 'data_' . $col->getTable(), $colname, $asc ? 'ASC' : 'DESC');
|
| /plugin/data/ |
| D | helper.php | 405 'colname' => $col,
526 'colname' => $column['colname'],
|
| /plugin/data-au/ |
| D | helper.php | 375 'colname' => $col,
495 'colname' => $column['colname'],
|