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

Method getThresholdsByReport

lib/Db/ThresholdMapper.php:67–87  ·  view source on GitHub ↗

* @throws Exception */

($reportId)

Source from the content-addressed store, hash-verified

65 * @throws Exception
66 */
67 public function getThresholdsByReport($reportId)
68 {
69 $sql = $this->db->getQueryBuilder();
70 $sql->from(self::TABLE_NAME)
71 ->select('id')
72 ->addSelect('dimension')
73 ->addSelect('source_column_ref')
74 ->addSelect('coloring')
75 ->selectAlias('target', 'value')
76 ->addSelect('option')
77 ->addSelect('severity')
78 ->addSelect('user_id')
79 ->addSelect('sequence')
80 ->where($sql->expr()->eq('report', $sql->createNamedParameter($reportId)))
81 ->andWhere($sql->expr()->eq('user_id', $sql->createNamedParameter($this->userId)))
82 ->orderBy('sequence', 'ASC');
83 $statement = $sql->executeQuery();
84 $result = $statement->fetchAll();
85 $statement->closeCursor();
86 return $result;
87 }
88
89 public function getReportByThreshold($id)
90 {

Callers 4

readMethod · 0.80
readRawMethod · 0.80
createCopyMethod · 0.80
exportMethod · 0.80

Calls 1

eqMethod · 0.80

Tested by

no test coverage detected