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 DUser.php110 $rightalias = $QB->generateTableAlias();
111 … $QB->addLeftJoin($tablealias, 'titles', $rightalias, "$tablealias.pid = $rightalias.pid");
112 $QB->addSelectStatement("$rightalias.lasteditor", $alias);
130 $rightalias = $QB->generateTableAlias();
131 … $QB->addLeftJoin($tablealias, 'titles', $rightalias, "$tablealias.pid = $rightalias.pid");
132 $QB->addOrderBy("$rightalias.lasteditor $order");
153 $rightalias = $QB->generateTableAlias();
154 … $QB->addLeftJoin($tablealias, 'titles', $rightalias, "$tablealias.pid = $rightalias.pid");
159 $sub->whereOr("$rightalias.lasteditor $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 DLookup.php246 $rightalias = $QB->generateTableAlias();
250 $rightalias,
251 … "$tablealias.$colname = STRUCT_JSON($rightalias.pid, CAST($rightalias.rid AS DECIMAL)) " .
252 "AND $rightalias.latest = 1"
281 $rightalias = $QB->generateTableAlias();
285 $rightalias,
286 … "$tablealias.$colname = STRUCT_JSON($rightalias.pid, CAST($rightalias.rid AS DECIMAL)) AND " .
287 "$rightalias.latest = 1"
314 $rightalias,
315 … "$tablealias.$colname = STRUCT_JSON($rightalias.pid, CAST($rightalias.rid AS DECIMAL)) AND " .
[all …]
H A DPage.php139 $rightalias = $QB->generateTableAlias();
140 … $QB->addLeftJoin($tablealias, 'titles', $rightalias, "$tablealias.$colname = $rightalias.pid");
141 $QB->addSelectStatement("STRUCT_JSON($tablealias.$colname, $rightalias.title)", $alias);
159 $rightalias = $QB->generateTableAlias();
160 … $QB->addLeftJoin($tablealias, 'titles', $rightalias, "$tablealias.$colname = $rightalias.pid");
161 $QB->addOrderBy("$rightalias.title $order");
214 $rightalias = $QB->generateTableAlias();
215 … $QB->addLeftJoin($tablealias, 'titles', $rightalias, "$tablealias.$colname = $rightalias.pid");
222 $sub->whereOr("$rightalias.title $comp $pl");
/plugin/structjoin/types/
H A 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, array($rightalias => $statement), $pos + 1);
122 $this->type[$rightalias] = 'join';
/plugin/structstatus/
H A 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…