Searched refs:rightalias (Results 1 – 8 of 8) sorted by path
/plugin/struct/meta/ |
H A D | QueryBuilder.php | 106 * @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/struct/types/ |
H A D | AutoSummary.php | 21 $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, " [all...] |
H A D | DateTime.php | 111 $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, " [all...] |
H A D | Lookup.php | 243 $rightalias = $QB->generateTableAlias(); 247 $rightalias, 248 "STRUCT_LOOKUP($tablealias.$colname, 0) = $rightalias.pid " . 249 "AND STRUCT_LOOKUP($tablealias.$colname, 1) = $rightalias.rid " . 250 "AND $rightalias.latest = 1" 252 $column->getType()->select($QB, $rightalias, $field, $alias); 279 $rightalias = $QB->generateTableAlias(); 283 $rightalias, 284 "$tablealias.$colname = STRUCT_JSON($rightalias.pid, CAST($rightalias [all...] |
H A D | Page.php | 130 $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, " [all...] |
H A D | User.php | 126 $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, " [all...] |
/plugin/structjoin/types/ |
H A D | Join.php | 101 $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/structstatus/ |
H A D | Status.php | 107 $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…
|