Home
last modified time | relevance | path

Searched refs:tablealias (Results 1 – 12 of 12) sorted by relevance

/plugin/struct/types/
H A DAutoSummary.php15 * @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 DPage.php129 * @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 DUser.php103 * @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 DDateTime.php101 * @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 DLookup.php232 * @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 DDecimal.php115 * @param string $tablealias
119 public function sort(QueryBuilder $QB, $tablealias, $colname, $order) argument
121 $QB->addOrderBy("CAST($tablealias.$colname AS DECIMAL) $order");
128 * @param string $tablealias
134 public function filter(QueryBuilderWhere $add, $tablealias, $colname, $comp, $value, $op) argument
137 $add->where('AND', "$tablealias.$colname != ''"); // make sure the field isn't empty
148 $add->where($op, "CAST($tablealias.$colname AS DECIMAL) $comp CAST($pl AS DECIMAL)");
H A DAbstractBaseType.php368 * @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 DTraitFilterPrefix.php21 * @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 DTag.php120 * @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 DJoin.php89 * @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 DQueryBuilder.php39 * @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/structstatus/
H A DStatus.php100 * @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…