Lines Matching refs:QB

119      * @param QueryBuilder $QB
124     public function select(QueryBuilder $QB, $tablealias, $colname, $alias)
127             parent::select($QB, $tablealias, $colname, $alias);
130         $rightalias = $QB->generateTableAlias();
131         $QB->addLeftJoin($tablealias, 'titles', $rightalias, "$tablealias.$colname = $rightalias.pid");
132         $QB->addSelectStatement("STRUCT_JSON($tablealias.$colname, $rightalias.title)", $alias);
138      * @param QueryBuilder $QB
143     public function sort(QueryBuilder $QB, $tablealias, $colname, $order)
146             parent::sort($QB, $tablealias, $colname, $order);
150         $rightalias = $QB->generateTableAlias();
151         $QB->addLeftJoin($tablealias, 'titles', $rightalias, "$tablealias.$colname = $rightalias.pid");
152         $QB->addOrderBy("$rightalias.title COLLATE NOCASE $order");
153         $QB->addOrderBy("$tablealias.$colname $order");
204         $QB = $add->getQB();
205         $rightalias = $QB->generateTableAlias();
206         $QB->addLeftJoin($tablealias, 'titles', $rightalias, "$tablealias.$colname = $rightalias.pid");
210         $pl = $QB->addValue($value);
212         $pl = $QB->addValue($value);