| /plugin/struct/meta/ |
| H A D | QueryBuilder.php | 39 * @param string $tablealias The table to select from
43 public function addSelectColumn($tablealias, $column, $alias = '') argument
46 if (!isset($this->from[$tablealias])) {
49 $this->select[$alias] = "$tablealias.$column";
148 * @param string $tablealias
151 public function addGroupByColumn($tablealias, $column) argument
153 if (!isset($this->from[$tablealias])) {
156 $this->groupby[] = "$tablealias.$column";
|
| /plugin/struct/types/ |
| H A D | AbstractBaseType.php | 374 * @param string $tablealias The table the currently saved value(s) are stored in argument
380 public function filter(QueryBuilderWhere $add, $tablealias, $colname, $comp, $value, $op)
389 $add->where($op, "$tablealias.$colname $comp $pl");
401 * The passed $tablealias.$columnname might be a data_* table (referencing a single
409 * @param string $tablealias The table the currently saved value(s) are stored in
413 public function select(QueryBuilder $QB, $tablealias, $colname, $alias)
415 $QB->addSelectColumn($tablealias, $colname, $alias);
425 * @param string $tablealias The table the currently saved value is stored in
432 public function sort(QueryBuilder $QB, $tablealias, $colname, $order)
434 $QB->addOrderBy("$tablealias
407 select(QueryBuilder $QB, $tablealias, $colname, $alias) global() argument
426 sort(QueryBuilder $QB, $tablealias, $colname, $order) global() argument
[all...] |
| H A D | AutoSummary.php | 15 * @param string $tablealias
19 public function select(QueryBuilder $QB, $tablealias, $colname, $alias) argument
22 $QB->addLeftJoin($tablealias, 'titles', $rightalias, "$tablealias.pid = $rightalias.pid");
30 * @param string $tablealias
34 public function sort(QueryBuilder $QB, $tablealias, $colname, $order) argument
37 $QB->addLeftJoin($tablealias, 'titles', $rightalias, "$tablealias.pid = $rightalias.pid");
45 * @param string $tablealias
51 public function filter(QueryBuilderWhere $add, $tablealias, argument
[all...] |
| H A D | DateTime.php | 101 * @param string $tablealias
105 public function select(QueryBuilder $QB, $tablealias, $colname, $alias) argument
107 $col = "$tablealias.$colname";
112 $QB->addLeftJoin($tablealias, 'titles', $rightalias, "$tablealias.pid = $rightalias.pid");
121 * @param string $tablealias
127 public function filter(QueryBuilderWhere $add, $tablealias, $colname, $comp, $value, $op) argument
129 $col = "$tablealias.$colname";
136 $QB->addLeftJoin($tablealias, 'titles', $rightalias, "$tablealias
158 sort(QueryBuilder $QB, $tablealias, $colname, $order) global() argument
[all...] |
| H A D | Decimal.php | 146 * @param string $tablealias
150 public function sort(QueryBuilder $QB, $tablealias, $colname, $order) argument
152 $QB->addOrderBy("CAST($tablealias.$colname AS DECIMAL) $order");
159 * @param string $tablealias
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 | Lookup.php | 229 * @param string $tablealias
233 public function select(QueryBuilder $QB, $tablealias, $colname, $alias)
238 parent::select($QB, $tablealias, $colname, $alias);
245 $tablealias,
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);
261 * @param string $tablealias
267 public function filter(QueryBuilderWhere $add, $tablealias, $colname, $comp, $value, $op)
272 parent::filter($add, $tablealias,
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 D | Page.php | 120 * @param string $tablealias
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);
139 * @param string $tablealias
143 public function sort(QueryBuilder $QB, $tablealias, $colname, $order)
146 parent::sort($QB, $tablealias, $colname, $order);
151 $QB->addLeftJoin($tablealias, 'title
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 D | Tag.php | 119 * @param string $tablealias
125 public function filter(QueryBuilderWhere $add, $tablealias, $colname, $comp, $value, $op) argument
134 $add->where($op, "LOWER(REPLACE($tablealias.$colname, ' ', '')) $comp LOWER(REPLACE($pl, ' ', ''))");
|
| H A D | TraitFilterPrefix.php | 21 * @param string $tablealias
27 public function filter(QueryBuilderWhere $add, $tablealias, $colname, $comp, $value, $op) argument
36 $column = "$tablealias.$colname";
|
| H A D | User.php | 119 * @param string $tablealias
123 public function select(QueryBuilder $QB, $tablealias, $colname, $alias)
127 $QB->addLeftJoin($tablealias, 'titles', $rightalias, "$tablealias.pid = $rightalias.pid");
132 parent::select($QB, $tablealias, $colname, $alias);
139 * @param string $tablealias
143 public function sort(QueryBuilder $QB, $tablealias, $colname, $order)
147 $QB->addLeftJoin($tablealias, 'titles', $rightalias, "$tablealias.pid = $rightalias.pid");
152 $QB->addOrderBy("$tablealias
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
[all...] |
| /plugin/structjoin/types/ |
| H A D | Join.php | 89 * @param string $tablealias
94 public function select(QueryBuilder $QB, $tablealias, $colname, $alias) { argument
97 AbstractBaseType::select($QB, $tablealias, $colname, $alias);
145 * @param string $tablealias
151 public function filter(QueryBuilderWhere $add, $tablealias, $colname, $comp, $value, $op) { argument
155 AbstractBaseType::filter($add, $tablealias, $colname, $comp, $value, $op);
173 * @param string $tablealias
178 public function sort(QueryBuilder $QB, $tablealias, $colname, $order) { argument
182 AbstractBaseType::sort($QB, $tablealias, $colname, $order);
|
| /plugin/structprogress/types/ |
| H A D | Progress.php | 126 * @param string $tablealias
130 public function sort(QueryBuilder $QB, $tablealias, $colname, $order) argument
132 $QB->addOrderBy("CAST($tablealias.$colname AS DECIMAL) $order");
139 * @param string $tablealias
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/structstatus/ |
| H A D | Status.php | 100 * @param string $tablealias
104 public function select(QueryBuilder $QB, $tablealias, $colname, $alias) { argument
112 AbstractBaseType::select($QB, $tablealias, $colname, $alias);
135 $tablealias, $schema, $rightalias,
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…
|