Home
last modified time | relevance | path

Searched refs:colname (Results 1 – 25 of 28) sorted by relevance

12

/plugin/struct/meta/
H A DSearch.php104 * @param string $colname may contain an alias
106 public function addColumn($colname)
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,
107 addColumn($colname) global() argument
133 addSort($colname, $asc = true, $nc = true) global() argument
159 addFilter($colname, $value, $comp, $op = 'OR') global() argument
598 processWildcard($colname) global() argument
623 resolveColumn($colname) global() argument
648 findColumn($colname, $strict = false) global() argument
[all...]
H A DAccessTable.php210 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 DSearchConfigParameters.php42 [$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 DSearchCloud.php74 $colname = $MN . '.value';
77 $colname = $datatable . '.' . $col->getColName();
79 $QB->addSelectStatement("COUNT($colname)", 'count');
/plugin/struct/types/
H A DPage.php121 * @param string $colname
124 public function select(QueryBuilder $QB, $tablealias, $colname, $alias)
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)
146 parent::sort($QB, $tablealias, $colname, $order);
151 $QB->addLeftJoin($tablealias, 'titles', $rightalias, "$tablealias.$colname = $rightalias.pid");
153 $QB->addOrderBy("$tablealias.$colname
136 select(QueryBuilder $QB, $tablealias, $colname, $alias) global() argument
155 sort(QueryBuilder $QB, $tablealias, $colname, $order) global() argument
209 filter(QueryBuilderWhere $add, $tablealias, $colname, $comp, $value, $op) global() argument
[all...]
H A DAutoSummary.php16 * @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 DUser.php120 * @param string $colname
123 public function select(QueryBuilder $QB, $tablealias, $colname, $alias)
132 parent::select($QB, $tablealias, $colname, $alias);
140 * @param string $colname
143 public function sort(QueryBuilder $QB, $tablealias, $colname, $order)
152 $QB->addOrderBy("$tablealias.$colname $order");
160 * @param string $colname
165 public function filter(QueryBuilderWhere $add, $tablealias, $colname, $comp, $value, $op)
179 parent::filter($add, $tablealias, $colname, $comp, $value, $op);
108 select(QueryBuilder $QB, $tablealias, $colname, $alias) global() argument
128 sort(QueryBuilder $QB, $tablealias, $colname, $order) global() argument
150 filter(QueryBuilderWhere $add, $tablealias, $colname, $comp, $value, $op) global() argument
H A DDateTime.php102 * @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 DLookup.php230 * @param string $colname
233 public function select(QueryBuilder $QB, $tablealias, $colname, $alias)
238 parent::select($QB, $tablealias, $colname, $alias);
248 "STRUCT_LOOKUP($tablealias.$colname, 0) = $rightalias.pid " .
249 "AND STRUCT_LOOKUP($tablealias.$colname, 1) = $rightalias.rid " .
254 $QB->addSelectStatement("STRUCT_JSON($tablealias.$colname, $sql)", $alias);
262 * @param string $colname
267 public function filter(QueryBuilderWhere $add, $tablealias, $colname, $comp, $value, $op)
272 parent::filter($add, $tablealias, $colname, $comp, $value, $op);
284 "$tablealias.$colname
236 select(QueryBuilder $QB, $tablealias, $colname, $alias) global() argument
269 filter(QueryBuilderWhere $add, $tablealias, $colname, $comp, $value, $op) global() argument
300 sort(QueryBuilder $QB, $tablealias, $colname, $order) global() argument
[all...]
H A DDecimal.php147 * @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 DTraitFilterPrefix.php22 * @param string $colname
27 public function filter(QueryBuilderWhere $add, $tablealias, $colname, $comp, $value, $op) argument
36 $column = "$tablealias.$colname";
H A DAbstractBaseType.php375 * @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)
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)
415 $QB->addSelectColumn($tablealias, $colname, $alias);
426 * @param string $colname The column name on above table (always single column!) argument
432 public function sort(QueryBuilder $QB, $tablealias, $colname, $order)
434 $QB->addOrderBy("$tablealias.$colname COLLATE NOCASE $order");
374 filter(QueryBuilderWhere $add, $tablealias, $colname, $comp, $value, $op) global() argument
407 select(QueryBuilder $QB, $tablealias, $colname, $alias) global() argument
H A DTag.php120 * @param string $colname
125 public function filter(QueryBuilderWhere $add, $tablealias, $colname, $comp, $value, $op) argument
134 $add->where($op, "LOWER(REPLACE($tablealias.$colname, ' ', '')) $comp LOWER(REPLACE($pl, ' ', ''))");
/plugin/structjoin/types/
H A DJoin.php90 * @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/
H A DStatus.php101 * @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/
H A DProgress.php127 * @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 Dfield.php202 $colname = $field->getColumn()->getFullQualifiedLabel();
209 $html .= "<label class=\"$lclass\" data-column=\"$colname\" for=\"$id\">";
221 * @param string $colname
225 protected function findColumn($colname)
227 [$table, $label] = explode('.', $colname, 2);
229 throw new StructException('Field \'%s\' not given in schema.field form', $colname);
219 findColumn($colname) global() argument
/plugin/struct/action/
H A Dajax.php69 [$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 Dmigration.php160 $colname = "col$colno";
167 $s = sprintf($f, $name, $colname, $colname, $colname, $colname, $colname);
H A Dedit.php164 $colname = $field->getColumn()->getFullQualifiedLabel();
177 $html .= "<label $hide data-column=\"$colname\" for=\"$id\">";
/plugin/structat/meta/
H A DSearchConfigAt.php172 $colname = $col->getColName(false);
173 if($nc) $colname .= ' COLLATE NOCASE';
174 $col->getType()->sort($QB, 'data_' . $col->getTable(), $colname, $asc ? 'ASC' : 'DESC');
/plugin/data-au/
H A Dhelper.php375 'colname' => $col,
495 'colname' => $column['colname'],
/plugin/data/
H A Dhelper.php191 * @param string $colname
194 public function resolveData($value, $colname)
197 $column = $this->column($colname);
405 'colname' => $col,
526 'colname' => $column['colname'],
182 _resolveData($value, $colname) global() argument
/plugin/structodt/
H A Dhelper.php234 $colname = $filter[0];
238 $search->addFilter($colname, $value, $comp, $op);
/plugin/data-au/_test/
H A Dhelper.test.php277 protected function createFilterArray($key, $value, $compare, $colname, $type) { argument
282 'colname' => $colname,

12