Home
last modified time | relevance | path

Searched refs:QB (Results 1 – 21 of 21) sorted by relevance

/plugin/structat/meta/
DSearchConfigAt.php57 $QB = new QueryBuilder();
65 … $QB->addLeftJoin($first_table, $datatable, $datatable, "$first_table.pid = $datatable.pid");
68 $QB->addTable($datatable);
71 $subAnd = $QB->filters()->whereSubAnd();
79 $QB->addLeftJoin(
88 $QB->addSelectColumn($datatable, 'rid');
89 $QB->addSelectColumn($datatable, 'pid', 'PID');
90 $QB->addSelectColumn($datatable, 'rev');
91 $QB->addSelectColumn('schema_assignments', 'assigned', 'ASSIGNED');
92 $QB->addGroupByColumn($datatable, 'pid');
[all …]
/plugin/struct/types/
H A DAutoSummary.php14 * @param QueryBuilder $QB
19 public function select(QueryBuilder $QB, $tablealias, $colname, $alias) argument
21 $rightalias = $QB->generateTableAlias();
22 $QB->addLeftJoin($tablealias, 'titles', $rightalias, "$tablealias.pid = $rightalias.pid");
23 $QB->addSelectStatement("$rightalias.lastsummary", $alias);
29 * @param QueryBuilder $QB
34 public function sort(QueryBuilder $QB, $tablealias, $colname, $order) argument
36 $rightalias = $QB->generateTableAlias();
37 $QB->addLeftJoin($tablealias, 'titles', $rightalias, "$tablealias.pid = $rightalias.pid");
38 $QB->addOrderBy("$rightalias.lastsummary $order");
[all …]
H A DUser.php118 * @param QueryBuilder $QB
123 public function select(QueryBuilder $QB, $tablealias, $colname, $alias) argument
126 $rightalias = $QB->generateTableAlias();
127 … $QB->addLeftJoin($tablealias, 'titles', $rightalias, "$tablealias.pid = $rightalias.pid");
128 $QB->addSelectStatement("$rightalias.lasteditor", $alias);
132 parent::select($QB, $tablealias, $colname, $alias);
138 * @param QueryBuilder $QB
143 public function sort(QueryBuilder $QB, $tablealias, $colname, $order) argument
146 $rightalias = $QB->generateTableAlias();
147 … $QB->addLeftJoin($tablealias, 'titles', $rightalias, "$tablealias.pid = $rightalias.pid");
[all …]
H A DPage.php119 * @param QueryBuilder $QB
124 public function select(QueryBuilder $QB, $tablealias, $colname, $alias) argument
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) argument
146 parent::sort($QB, $tablealias, $colname, $order);
150 $rightalias = $QB->generateTableAlias();
[all …]
H A DDateTime.php100 * @param QueryBuilder $QB
105 public function select(QueryBuilder $QB, $tablealias, $colname, $alias) argument
111 $rightalias = $QB->generateTableAlias();
112 … $QB->addLeftJoin($tablealias, 'titles', $rightalias, "$tablealias.pid = $rightalias.pid");
116 $QB->addSelectStatement($col, $alias);
130 $QB = $add->getQB();
134 $rightalias = $QB->generateTableAlias();
136 … $QB->addLeftJoin($tablealias, 'titles', $rightalias, "$tablealias.pid = $rightalias.pid");
145 $pl = $QB->addValue($item);
153 * @param QueryBuilder $QB
[all …]
H A DLookup.php232 * @param QueryBuilder $QB
237 public function select(QueryBuilder $QB, $tablealias, $colname, $alias) argument
242 parent::select($QB, $tablealias, $colname, $alias);
247 $rightalias = $QB->generateTableAlias();
248 $QB->addLeftJoin(
256 $column->getType()->select($QB, $rightalias, $field, $alias);
257 $sql = $QB->getSelectStatement($alias);
258 $QB->addSelectStatement("STRUCT_JSON($tablealias.$colname, $sql)", $alias);
282 $QB = $add->getQB();
283 $rightalias = $QB->generateTableAlias();
[all …]
H A DTraitFilterPrefix.php34 $QB = $add->getQB();
39 $pl = $QB->addValue($this->config['prefix']);
43 $pl = $QB->addValue($this->config['postfix']);
47 $pl = $QB->addValue($item);
H A DAbstractBaseType.php408 * @param QueryBuilder $QB
413 public function select(QueryBuilder $QB, $tablealias, $colname, $alias) argument
415 $QB->addSelectColumn($tablealias, $colname, $alias);
424 * Generally if you implemented @param QueryBuilder $QB
432 public function sort(QueryBuilder $QB, $tablealias, $colname, $order) argument
434 $QB->addOrderBy("$tablealias.$colname COLLATE NOCASE $order");
H A DDecimal.php145 * @param QueryBuilder $QB
150 public function sort(QueryBuilder $QB, $tablealias, $colname, $order) argument
152 $QB->addOrderBy("CAST($tablealias.$colname AS DECIMAL) $order");
H A DTag.php120 * @param QueryBuilder $QB
/plugin/structjoin/types/
DJoin.php88 * @param QueryBuilder $QB
94 public function select(QueryBuilder $QB, $tablealias, $colname, $alias) { argument
97 AbstractBaseType::select($QB, $tablealias, $colname, $alias);
101 $rightalias = $this->findRightAlias($QB);
107 $column->getType()->select($QB, $rightalias, $field, $alias);
111 * @param QueryBuilder $QB
115 protected function findRightAlias(QueryBuilder $QB) { argument
116 $from = $this->getProtectedPropertyFromQB($QB, 'from');
128 * @param QueryBuilder $QB
133 protected function getProtectedPropertyFromQB(QueryBuilder $QB, $property) { argument
[all …]
/plugin/struct/meta/
H A DQueryBuilderWhere.php16 protected $QB; variable in dokuwiki\\plugin\\struct\\meta\\QueryBuilderWhere
21 * @param QueryBuilder $QB The QueryBuilder to which this where-clause belongs
25 public function __construct(QueryBuilder $QB, $type = 'AND', $statement = null) argument
27 $this->QB = $QB;
94 $where = new QueryBuilderWhere($this->QB, $op, $statement);
109 return $this->QB;
H A DSearchCloud.php46 $QB = $builder->getQueryBuilder();
53 $MN = $QB->generateTableAlias('M');
55 $QB->addLeftJoin(
65 $col->getType()->select($QB, $MN, 'value', 'tag');
68 $col->getType()->select($QB, $datatable, $col->getColName(), 'tag');
71 $QB->addSelectStatement("COUNT($colname)", 'count');
H A DAccessTable.php502 $QB = new QueryBuilder();
503 $QB->addTable($stable, 'DATA');
504 $QB->addSelectColumn('DATA', $idColumn, strtoupper($idColumn));
505 $QB->addGroupByStatement("DATA.$idColumn");
514 $QB->addLeftJoin(
520 $col->getType()->select($QB, $tn, 'value', $outname);
521 $sel = $QB->getSelectStatement($outname);
522 $QB->addSelectStatement("GROUP_CONCAT_DISTINCT($sel, '$sep')", $outname);
524 $col->getType()->select($QB, 'DATA', $colname, $outname);
525 $QB->addGroupByStatement($outname);
[all …]
/plugin/struct/_test/
H A DQueryBuilderWhereTest.php17 $QB = new QueryBuilder();
18 $where = new QueryBuilderWhere($QB);
53 $QB = new QueryBuilder();
54 $where = new QueryBuilderWhere($QB);
/plugin/structstatus/
DStatus.php99 * @param QueryBuilder $QB
104 public function select(QueryBuilder $QB, $tablealias, $colname, $alias) { argument
107 $rightalias = $QB->generateTableAlias();
112 AbstractBaseType::select($QB, $tablealias, $colname, $alias);
134 $QB->addLeftJoin(
140 …$QB->addSelectStatement("STRUCT_JSON($tablealias.$colname, $field_status, $field_color, $field_ico…
/plugin/struct/_test/types/
H A DTextTest.php139 $QB = new QueryBuilder();
142 $text->filter($QB->filters(), 'T', 'col', $comp, $val, 'AND');
144 list($sql, $opt) = $QB->getWhereSQL();
/plugin/structnumber/types/
DNumber.php92 * @param QueryBuilder $QB
97 public function sort(QueryBuilder $QB, $tablealias, $colname, $order) argument
99 $QB->addOrderBy("CAST($tablealias.$colname AS DECIMAL) $order");
/plugin/structprogress/types/
DProgress.php125 * @param QueryBuilder $QB
130 public function sort(QueryBuilder $QB, $tablealias, $colname, $order) argument
132 $QB->addOrderBy("CAST($tablealias.$colname AS DECIMAL) $order");
/plugin/pgn4web/pgn4web/
Dtactics.pgn4328 [FEN "2r1r2k/1q3ppp/p2Rp3/2p1P3/6QB/p3P3/bP3PPP/3R2K1 w - - 0 1"]
/plugin/mermaid/
H A Dmermaid.min.js1976 …QB,"defineDerivedStateFunction");uy=sC("eleTakesUpSpace",function(t){return t.pstyle("display").va… class in AnonymousClass3478d9c710e101