public function getAll(QueryBuilder $qb, array $params = [], array $pageOpts = [], $inDeleted = false)
    {
        if ($this->softDelete && !$inDeleted) {
            $qb->andWhere('t.'.$this->softDeleteName.' IS NULL');
        }

        if (!empty($pageOpts)) {
            $rs = $this->paginate($qb, $pageOpts, $params);
        } else {
            $rs = $this->db->fetchAll($qb->getSQL(), $params);
        }

        return $rs;
    }