MCPcopy Create free account
hub / github.com/Rello/analytics / create

Method create

lib/Db/ThresholdMapper.php:36–62  ·  view source on GitHub ↗

* @throws Exception */

($reportId, $dimension, $value, $option, $severity, $coloring, ?string $sourceColumnRef = null)

Source from the content-addressed store, hash-verified

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

Callers

nothing calls this directly

Calls 1

eqMethod · 0.80

Tested by

no test coverage detected