Home
last modified time | relevance | path

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

/plugin/structat/meta/
H A DSearchConfigAt.php57 $QB = new QueryBuilder();
68 $QB->addTable($datatable);
71 $subAnd = $QB->filters()->whereSubAnd();
79 $QB->addLeftJoin(
117 $QB->addLeftJoin(
127 $sel = $QB->getSelectStatement($CN);
131 $QB->addGroupByStatement($CN);
137 $userWHERE = $QB->filters()->where('AND');
148 $MN = $QB->generateTableAlias('MN');
150 $QB->addLeftJoin(
[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
[all...]
H A DPage.php119 * @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
136 select(QueryBuilder $QB, $tablealias, $colname, $alias) global() argument
155 sort(QueryBuilder $QB, $tablealias, $colname, $order) global() argument
[all...]
H A DUser.php118 * @param QueryBuilder $QB
123 public function select(QueryBuilder $QB, $tablealias, $colname, $alias)
126 $rightalias = $QB->generateTableAlias();
127 $QB->addLeftJoin($tablealias, 'titles', $rightalias, "$tablealias.pid = $rightalias.pid");
128 $QB->addSelectStatement("$rightalias.lasteditor", $alias); argument
132 parent::select($QB, $tablealias, $colname, $alias);
138 * @param QueryBuilder $QB
143 public function sort(QueryBuilder $QB, $tablealias, $colname, $order)
146 $rightalias = $QB->generateTableAlias();
147 $QB
108 select(QueryBuilder $QB, $tablealias, $colname, $alias) global() argument
[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
158 sort(QueryBuilder $QB, $tablealias, $colname, $order) global() argument
[all...]
H A DLookup.php228 * @param QueryBuilder $QB
233 public function select(QueryBuilder $QB, $tablealias, $colname, $alias)
238 parent::select($QB, $tablealias, $colname, $alias);
243 $rightalias = $QB->generateTableAlias();
244 $QB->addLeftJoin(
252 $column->getType()->select($QB, $rightalias, $field, $alias);
253 $sql = $QB->getSelectStatement($alias);
254 $QB->addSelectStatement("STRUCT_JSON($tablealias.$colname, $sql)", $alias);
278 $QB = $add->getQB();
279 $rightalias = $QB
236 select(QueryBuilder $QB, $tablealias, $colname, $alias) global() argument
300 sort(QueryBuilder $QB, $tablealias, $colname, $order) global() argument
[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)
415 $QB->addSelectColumn($tablealias, $colname, $alias);
424 * Generally if you implemented @param QueryBuilder $QB
432 public function sort(QueryBuilder $QB, $tablealias, $colname, $order)
434 $QB->addOrderBy("$tablealias.$colname COLLATE NOCASE $order");
407 select(QueryBuilder $QB, $tablealias, $colname, $alias) global() argument
426 sort(QueryBuilder $QB, $tablealias, $colname, $order) global() argument
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.php118 * @param QueryBuilder $QB
/plugin/struct/meta/
H A DSearchCloud.php25 $QB = new QueryBuilder();
30 $QB->addTable($datatable);
33 $subAnd = $QB->filters()->whereSubAnd();
46 $QB->addLeftJoin(
55 $QB->filters()->whereAnd("$datatable.latest = 1");
56 $QB->filters()->where('AND', 'tag IS NOT \'\'');
61 $MN = $QB->generateTableAlias('M');
63 $QB->addLeftJoin(
73 $col->getType()->select($QB, $MN, 'value', 'tag');
76 $col->getType()->select($QB,
[all...]
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 DSearch.php
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
[all...]
/plugin/structjoin/types/
H A DJoin.php88 * @param QueryBuilder $QB
101 $rightalias = $this->findRightAlias($QB);
111 * @param QueryBuilder $QB
115 protected function findRightAlias(QueryBuilder $QB) { argument
116 $from = $this->getProtectedPropertyFromQB($QB, 'from');
128 * @param QueryBuilder $QB
138 return $reflectionProperty->getValue($QB);
161 $QB = $add->getQB();
162 $rightalias = $this->findRightAlias($QB);
172 * @param QueryBuilder $QB
[all …]
/plugin/structstatus/
H A 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/structprogress/types/
H A 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/
H A Dtactics.pgn4328 [FEN "2r1r2k/1q3ppp/p2Rp3/2p1P3/6QB/p3P3/bP3PPP/3R2K1 w - - 0 1"]
/plugin/mermaid/
H A Dmermaid.min.js1323 `);const m=Oe().securityLevel;let b;m==="sandbox"&&(b=Mr("#i"+a));const E=Mr(m==="sandbox"?b.nodes()[0].contentDocument.body:"body");nv.init();const C=E.select("#"+a);RP.initGraphi global() class in AnonymousFunction3478d9c75cb00.AnonymousFunction3478d9c75dd00
[all...]