* read report options * @param $id * @return array * @throws Exception */
($id)
| 317 | * @throws Exception |
| 318 | */ |
| 319 | public function readOptions($id) |
| 320 | { |
| 321 | $sql = $this->db->getQueryBuilder(); |
| 322 | $sql->from(self::TABLE_NAME) |
| 323 | ->select('name') |
| 324 | ->addSelect('visualization') |
| 325 | ->addSelect('chart') |
| 326 | ->addSelect('user_id') |
| 327 | ->where($sql->expr()->eq('id', $sql->createNamedParameter($id))); |
| 328 | $statement = $sql->executeQuery(); |
| 329 | $result = $statement->fetch(); |
| 330 | $statement->closeCursor(); |
| 331 | return $result; |
| 332 | } |
| 333 | |
| 334 | /** |
| 335 | * delete report |