| /plugin/struct/types/ |
| 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, $colname, $comp, $value, $op) argument
55 $QB->addLeftJoin($tablealias, 'titles', $rightalias, "$tablealias.pid = $rightalias.pid");
|
| H A D | Page.php | 129 * @param string $tablealias
136 parent::select($QB, $tablealias, $colname, $alias);
140 … $QB->addLeftJoin($tablealias, 'titles', $rightalias, "$tablealias.$colname = $rightalias.pid");
148 * @param string $tablealias
152 public function sort(QueryBuilder $QB, $tablealias, $colname, $order) argument
155 parent::sort($QB, $tablealias, $colname, $order);
160 … $QB->addLeftJoin($tablealias, 'titles', $rightalias, "$tablealias.$colname = $rightalias.pid");
162 $QB->addOrderBy("$tablealias.$colname $order");
200 * @param string $tablealias
215 … $QB->addLeftJoin($tablealias, 'titles', $rightalias, "$tablealias.$colname = $rightalias.pid");
[all …]
|
| H A D | User.php | 103 * @param string $tablealias
107 public function select(QueryBuilder $QB, $tablealias, $colname, $alias) argument
111 … $QB->addLeftJoin($tablealias, 'titles', $rightalias, "$tablealias.pid = $rightalias.pid");
116 parent::select($QB, $tablealias, $colname, $alias);
123 * @param string $tablealias
127 public function sort(QueryBuilder $QB, $tablealias, $colname, $order) argument
131 … $QB->addLeftJoin($tablealias, 'titles', $rightalias, "$tablealias.pid = $rightalias.pid");
136 $QB->addOrderBy("$tablealias.$colname $order");
143 * @param string $tablealias
154 … $QB->addLeftJoin($tablealias, 'titles', $rightalias, "$tablealias.pid = $rightalias.pid");
[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
129 $col = "$tablealias.$colname";
136 … $QB->addLeftJoin($tablealias, 'titles', $rightalias, "$tablealias.pid = $rightalias.pid");
154 * @param string $tablealias
158 public function sort(QueryBuilder $QB, $tablealias, $colname, $order) argument
160 $col = "$tablealias.$colname";
[all …]
|
| H A D | Lookup.php | 232 * @param string $tablealias
236 public function select(QueryBuilder $QB, $tablealias, $colname, $alias) argument
241 parent::select($QB, $tablealias, $colname, $alias);
248 $tablealias,
263 * @param string $tablealias
274 parent::filter($add, $tablealias, $colname, $comp, $value, $op);
283 $tablealias,
296 * @param string $tablealias
300 public function sort(QueryBuilder $QB, $tablealias, $colname, $order) argument
305 parent::sort($QB, $tablealias, $colname, $order);
[all …]
|
| H A D | Decimal.php | 142 * @param string $tablealias
146 public function sort(QueryBuilder $QB, $tablealias, $colname, $order) argument
148 $QB->addOrderBy("CAST($tablealias.$colname AS DECIMAL) $order");
155 * @param string $tablealias
161 public function filter(QueryBuilderWhere $add, $tablealias, $colname, $comp, $value, $op) argument
164 $add->where('AND', "$tablealias.$colname != ''"); // make sure the field isn't empty
175 $add->where($op, "CAST($tablealias.$colname AS DECIMAL) $comp CAST($pl AS DECIMAL)");
|
| H A D | TraitFilterPrefix.php | 21 * @param string $tablealias
27 public function filter(QueryBuilderWhere $add, $tablealias, $colname, $comp, $value, $op) argument
30 $add->where('AND', "$tablealias.$colname != ''"); // make sure the field isn't empty
40 $column = "$tablealias.$colname";
|
| H A D | AbstractBaseType.php | 368 * @param string $tablealias The table the currently saved value(s) are stored in
374 public function filter(QueryBuilderWhere $add, $tablealias, $colname, $comp, $value, $op) argument
383 $add->where($op, "$tablealias.$colname $comp $pl");
403 * @param string $tablealias The table the currently saved value(s) are stored in
407 public function select(QueryBuilder $QB, $tablealias, $colname, $alias) argument
409 $QB->addSelectColumn($tablealias, $colname, $alias);
419 * @param string $tablealias The table the currently saved value is stored in
426 public function sort(QueryBuilder $QB, $tablealias, $colname, $order) argument
428 $QB->addOrderBy("$tablealias.$colname $order");
|
| H A D | Tag.php | 120 * @param string $tablealias
126 public function filter(QueryBuilderWhere $add, $tablealias, $colname, $comp, $value, $op) argument
135 …$add->where($op, "LOWER(REPLACE($tablealias.$colname, ' ', '')) $comp LOWER(REPLACE($pl, ' ', ''))…
|
| /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/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/structprogress/types/ |
| H A D | Progress.php | 120 * @param string $tablealias
124 public function sort(QueryBuilder $QB, $tablealias, $colname, $order) argument
126 $QB->addOrderBy("CAST($tablealias.$colname AS DECIMAL) $order");
133 * @param string $tablealias
139 public function filter(QueryBuilderWhere $add, $tablealias, $colname, $comp, $value, $op) argument
142 $add->where('AND', "$tablealias.$colname != ''"); // make sure the field isn't empty
153 $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…
|