Method index

lib/Db/ReportMapper.php:45–72

* get reports * @return array * @throws Exception */

()

     * @throws Exception
     */
    public function index()
    {
        $sql = $this->db->getQueryBuilder();
        $sql->from(self::TABLE_NAME)
            ->select('id')
            ->addSelect('name')
            ->addSelect('type')
            ->addSelect('parent')
            ->addSelect('dataset')
			->addSelect('version')
            ->where($sql->expr()->eq('user_id', $sql->createNamedParameter($this->userId)))
            ->orderBy('parent', 'ASC')
            ->addOrderBy('name', 'ASC');
        $statement = $sql->executeQuery();
        $result = $statement->fetchAll();
        $statement->closeCursor();

        if ($result !== false && is_array($result)) {
            foreach ($result as &$row) {
                $row['dataset'] = (int) $row['dataset'];
                $row['type'] = (int) $row['type'];
                $row['parent'] = (int) $row['parent'];
            }
            unset($row); // Unset reference
        }

        return $result;
    }

    /**
     * get reports for user