Home
last modified time | relevance | path

Searched refs:rightalias (Results 1 – 8 of 8) sorted by relevance

/plugin/struct/types/
H A DAutoSummary.php21 $rightalias = $QB->generateTableAlias();
22 $QB->addLeftJoin($tablealias, 'titles', $rightalias, "$tablealias.pid = $rightalias.pid");
23 $QB->addSelectStatement("$rightalias.lastsummary", $alias);
36 $rightalias = $QB->generateTableAlias();
37 $QB->addLeftJoin($tablealias, 'titles', $rightalias, "$tablealias.pid = $rightalias.pid");
38 $QB->addOrderBy("$rightalias.lastsummary $order");
54 $rightalias = $QB->generateTableAlias();
55 $QB->addLeftJoin($tablealias, 'titles', $rightalias, "$tablealias.pid = $rightalias.pid");
60 $sub->whereOr("$rightalias.lastsummary $comp $pl");
H A DDateTime.php111 $rightalias = $QB->generateTableAlias();
112 … $QB->addLeftJoin($tablealias, 'titles', $rightalias, "$tablealias.pid = $rightalias.pid");
113 $col = "DATETIME($rightalias.lastrev, 'unixepoch', 'localtime')";
134 $rightalias = $QB->generateTableAlias();
135 $col = "DATETIME($rightalias.lastrev, 'unixepoch', 'localtime')";
136 … $QB->addLeftJoin($tablealias, 'titles', $rightalias, "$tablealias.pid = $rightalias.pid");
163 $rightalias = $QB->generateTableAlias();
164 … $QB->addLeftJoin($tablealias, 'titles', $rightalias, "$tablealias.pid = $rightalias.pid");
165 $col = "$rightalias.lastrev";
H A DUser.php126 $rightalias = $QB->generateTableAlias();
127 … $QB->addLeftJoin($tablealias, 'titles', $rightalias, "$tablealias.pid = $rightalias.pid");
128 $QB->addSelectStatement("$rightalias.lasteditor", $alias);
146 $rightalias = $QB->generateTableAlias();
147 … $QB->addLeftJoin($tablealias, 'titles', $rightalias, "$tablealias.pid = $rightalias.pid");
148 $QB->addOrderBy("$rightalias.lasteditor $order");
169 $rightalias = $QB->generateTableAlias();
170 … $QB->addLeftJoin($tablealias, 'titles', $rightalias, "$tablealias.pid = $rightalias.pid");
175 $sub->whereOr("$rightalias.lasteditor $comp $pl");
H A DLookup.php247 $rightalias = $QB->generateTableAlias();
251 $rightalias,
252 "STRUCT_LOOKUP($tablealias.$colname, 0) = $rightalias.pid " .
253 "AND STRUCT_LOOKUP($tablealias.$colname, 1) = $rightalias.rid " .
254 "AND $rightalias.latest = 1"
256 $column->getType()->select($QB, $rightalias, $field, $alias);
283 $rightalias = $QB->generateTableAlias();
287 $rightalias,
288 … "$tablealias.$colname = STRUCT_JSON($rightalias.pid, CAST($rightalias.rid AS DECIMAL)) AND " .
289 "$rightalias.latest = 1"
[all …]
H A DPage.php130 $rightalias = $QB->generateTableAlias();
131 … $QB->addLeftJoin($tablealias, 'titles', $rightalias, "$tablealias.$colname = $rightalias.pid");
132 $QB->addSelectStatement("STRUCT_JSON($tablealias.$colname, $rightalias.title)", $alias);
150 $rightalias = $QB->generateTableAlias();
151 … $QB->addLeftJoin($tablealias, 'titles', $rightalias, "$tablealias.$colname = $rightalias.pid");
152 $QB->addOrderBy("$rightalias.title COLLATE NOCASE $order");
205 $rightalias = $QB->generateTableAlias();
206 … $QB->addLeftJoin($tablealias, 'titles', $rightalias, "$tablealias.$colname = $rightalias.pid");
213 $sub->whereOr("$rightalias.title $comp $pl");
/plugin/structjoin/types/
DJoin.php101 $rightalias = $this->findRightAlias($QB);
102 if (!$rightalias) {
107 $column->getType()->select($QB, $rightalias, $field, $alias);
162 $rightalias = $this->findRightAlias($QB);
163 if (!$rightalias) {
166 $column->getType()->filter($add, $rightalias, $field, $comp, $value, $op);
187 $rightalias = $this->findRightAlias($QB);
188 if (!$rightalias) {
191 $column->getType()->sort($QB, $rightalias, $field, $order);
/plugin/struct/meta/
H A DQueryBuilder.php106 * @param string $rightalias an alias for the right table, blank for table name
109 public function addLeftJoin($leftalias, $righttable, $rightalias, $onclause) argument
111 if ($rightalias === '') $rightalias = $righttable;
115 if (isset($this->from[$rightalias])) {
120 $statement = "LEFT OUTER JOIN $righttable AS $rightalias ON $onclause";
121 $this->from = $this->arrayInsert($this->from, [$rightalias => $statement], $pos + 1);
122 $this->type[$rightalias] = 'join';
/plugin/structstatus/
DStatus.php107 $rightalias = $QB->generateTableAlias();
115 $field_status = $rightalias . '.' . $col_status->getColName();
122 $field_color = $rightalias . '.' . $col_color->getColName(true);
130 $field_icon = $rightalias . '.' . $col_icon->getColName(true);
135 $tablealias, $schema, $rightalias,
136 …"$tablealias.$colname = STRUCT_JSON($rightalias.pid, CAST($rightalias.rid AS DECIMAL)) AND $righta…