* @throws Exception */
($reportId, $dimension, $value, $option, $severity, $coloring, ?string $sourceColumnRef = null)
| 34 | * @throws Exception |
| 35 | */ |
| 36 | public function create($reportId, $dimension, $value, $option, $severity, $coloring, ?string $sourceColumnRef = null) |
| 37 | { |
| 38 | $get = $this->db->getQueryBuilder(); |
| 39 | $get->select('sequence') |
| 40 | ->from(self::TABLE_NAME) |
| 41 | ->where($get->expr()->eq('report', $get->createNamedParameter($reportId))) |
| 42 | ->orderBy('sequence', 'DESC') |
| 43 | ->setMaxResults(1); |
| 44 | $max = $get->executeQuery()->fetchOne(); |
| 45 | $sequence = ($max === null) ? 1 : ((int)$max + 1); |
| 46 | |
| 47 | $sql = $this->db->getQueryBuilder(); |
| 48 | $sql->insert(self::TABLE_NAME) |
| 49 | ->values([ |
| 50 | 'user_id' => $sql->createNamedParameter($this->userId), |
| 51 | 'report' => $sql->createNamedParameter($reportId), |
| 52 | 'dimension' => $sql->createNamedParameter($dimension), |
| 53 | 'source_column_ref' => $sql->createNamedParameter($sourceColumnRef), |
| 54 | 'target' => $sql->createNamedParameter($value), |
| 55 | 'option' => $sql->createNamedParameter($option), |
| 56 | 'severity' => $sql->createNamedParameter($severity), |
| 57 | 'coloring' => $sql->createNamedParameter($coloring), |
| 58 | 'sequence' => $sql->createNamedParameter($sequence), |
| 59 | ]); |
| 60 | $sql->executeStatement(); |
| 61 | return (int)$sql->getLastInsertId(); |
| 62 | } |
| 63 | |
| 64 | /** |
| 65 | * @throws Exception |