| /plugin/struct/types/ |
| 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");
|
| D | Page.php | 120 * @param string $tablealias
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);
139 * @param string $tablealias
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 …]
|
| 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.pid = $rightalias.pid");
154 * @param string $tablealias
158 public function sort(QueryBuilder $QB, $tablealias, $colname, $order) argument
[all …]
|
| D | User.php | 119 * @param string $tablealias
123 public function select(QueryBuilder $QB, $tablealias, $colname, $alias) argument
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) argument
147 … $QB->addLeftJoin($tablealias, 'titles', $rightalias, "$tablealias.pid = $rightalias.pid");
152 $QB->addOrderBy("$tablealias.$colname $order");
159 * @param string $tablealias
165 public function filter(QueryBuilderWhere $add, $tablealias, $colname, $comp, $value, $op) argument
[all …]
|
| D | Lookup.php | 233 * @param string $tablealias
237 public function select(QueryBuilder $QB, $tablealias, $colname, $alias) argument
242 parent::select($QB, $tablealias, $colname, $alias);
249 $tablealias,
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);
265 * @param string $tablealias
271 public function filter(QueryBuilderWhere $add, $tablealias, $colname, $comp, $value, $op) argument
276 parent::filter($add, $tablealias, $colname, $comp, $value, $op);
[all …]
|
| 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)");
|
| D | AbstractBaseType.php | 374 * @param string $tablealias The table the currently saved value(s) are stored in
380 public function filter(QueryBuilderWhere $add, $tablealias, $colname, $comp, $value, $op) argument
389 $add->where($op, "$tablealias.$colname $comp $pl");
409 * @param string $tablealias The table the currently saved value(s) are stored in
413 public function select(QueryBuilder $QB, $tablealias, $colname, $alias) argument
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) argument
434 $QB->addOrderBy("$tablealias.$colname COLLATE NOCASE $order");
|
| D | TraitFilterPrefix.php | 21 * @param string $tablealias
27 public function filter(QueryBuilderWhere $add, $tablealias, $colname, $comp, $value, $op) argument
36 $column = "$tablealias.$colname";
|
| D | Tag.php | 121 * @param string $tablealias
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 | 93 * @param string $tablealias
97 public function sort(QueryBuilder $QB, $tablealias, $colname, $order) argument
99 $QB->addOrderBy("CAST($tablealias.$colname AS DECIMAL) $order");
106 * @param string $tablealias
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 | 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/ |
| 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/ |
| 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/ |
| 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…
|