Query Building

gistfile1.php

<?php

class MyQuery {
    protected function buildCollectionQuery($is_count_query = false) {
        $qs = $is_count_query ? $this->baseCountQS : $this->baseCollectionQS;
        $qsParams = [''];

        if ($this->showInactive === false) {
            $qs .= " && u.userStatus = 'active'";
        }

        if ($this->nameFilter !== null) {
            $qs .= " && a.companyName LIKE ?";
            $qsParams[] = '%'.$this->nameFilter.'%';
        }

        if (!$this->user->isAdmin()) {
            $qs .= " && u.userManager = ?";
            $qsParams[] = $this->user->getId();
        }

        if (count($this->sorts)) {
            $qs .= ' ORDER BY ' . implode(', ', $this->sorts);
        }

        if (!$is_count_query) {
            $qs .= ' LIMIT ' . $this->pageSize . ' OFFSET ' . $this->pageSize * ($this->page - 1);
        }

        return ['query' => $qs, 'params' => $qsParams];
    }
}