(int $id)
| 94 | } |
| 95 | |
| 96 | public function getOwnReportByThreshold(int $id): int { |
| 97 | $sql = $this->db->getQueryBuilder(); |
| 98 | $sql->from(self::TABLE_NAME) |
| 99 | ->select('report') |
| 100 | ->where($sql->expr()->eq('id', $sql->createNamedParameter($id))) |
| 101 | ->andWhere($sql->expr()->eq('user_id', $sql->createNamedParameter($this->userId))); |
| 102 | return (int)$sql->executeQuery()->fetchOne(); |
| 103 | } |
| 104 | |
| 105 | /** |
| 106 | * @throws Exception |