Lines Matching refs:datatable

37             $datatable = 'data_' . $schema->getTable();
40 … $this->qb->addLeftJoin($first_table, $datatable, $datatable, "$first_table.pid = $datatable.pid");
43                 $this->qb->addTable($datatable);
47                 $subAnd->whereAnd("$datatable.pid = ''");
49                 $subOr->whereAnd("GETACCESSLEVEL($datatable.pid) > 0");
50                 $subOr->whereAnd("PAGEEXISTS($datatable.pid) = 1");
52                 $subOr->whereAnd("($datatable.rid != 0 OR (ASSIGNED = 1 OR ASSIGNED IS NULL))");
56                     $datatable,
59                     "$datatable.pid != ''
60                     AND $datatable.pid = schema_assignments.pid
65                     $this->qb->addSelectColumn($datatable, 'rid');
66                     $this->qb->addSelectColumn($datatable, 'pid', 'PID');
67                     $this->qb->addSelectColumn($datatable, 'rev');
69                     $this->qb->addGroupByColumn($datatable, 'pid');
70                     $this->qb->addGroupByColumn($datatable, 'rid');
73                 $first_table = $datatable;
75             $this->qb->filters()->whereAnd($this->addPublishClauses($datatable));
92                 $datatable = "data_{$col->getTable()}";
97                     $datatable,
100                     "$datatable.pid = $MN.pid AND $datatable.rid = $MN.rid AND
101                      $datatable.rev = $MN.rev AND
132             $datatable = "data_{$col->getTable()}";
140                     $datatable,
143                     "$datatable.pid = $MN.pid AND $datatable.rid = $MN.rid AND
144                      $datatable.rev = $MN.rev AND
150                 $coltbl = $datatable;
177      * @param string $datatable
180     public function addPublishClauses($datatable)  argument
182         $latestClause = "IS_PUBLISHER($datatable.pid)";
184             $latestClause .= " AND $datatable.latest = 1";
186         $publishedClause = "IS_PUBLISHER($datatable.pid) !=1 AND $datatable.published = 1";