Method readOwn

lib/Db/ReportMapper.php:141–162

* get single report for user * @param int $id * @return array * @throws Exception */

(int $id)

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

        if ($result !== false) {
            $result['dataset'] = (int) $result['dataset'];
            $result['type'] = (int) $result['type'];
            $result['parent'] = (int) $result['parent'];
            $result['refresh'] = (int) $result['refresh'];
        }

        return $result;
    }

    /**
     * get single report