* create report * @param $name * @param $subheader * @param $parent * @param $type * @param $dataset * @param $link * @param $visualization * @param $chart * @param $dimension1 * @param $dimension2 * @param $value * @return int * @throws Exception */
($name, $subheader, $parent, $type, $dataset, $link, $visualization, $chart, $dimension1, $dimension2, $value)
| 106 | * @throws Exception |
| 107 | */ |
| 108 | public function create($name, $subheader, $parent, $type, $dataset, $link, $visualization, $chart, $dimension1, $dimension2, $value) |
| 109 | { |
| 110 | $sql = $this->db->getQueryBuilder(); |
| 111 | $sql->insert(self::TABLE_NAME) |
| 112 | ->values([ |
| 113 | 'user_id' => $sql->createNamedParameter($this->userId), |
| 114 | 'dataset' => $sql->createNamedParameter($dataset), |
| 115 | 'name' => $sql->createNamedParameter($name), |
| 116 | 'subheader' => $sql->createNamedParameter($subheader), |
| 117 | 'link' => $sql->createNamedParameter($link), |
| 118 | 'type' => $sql->createNamedParameter($type), |
| 119 | 'parent' => $sql->createNamedParameter($parent), |
| 120 | 'dimension1' => $sql->createNamedParameter($dimension1), |
| 121 | 'dimension2' => $sql->createNamedParameter($dimension2), |
| 122 | //'dimension3' => $sql->createNamedParameter($this->l10n->t('Value')), |
| 123 | //'dimension4' => $sql->createNamedParameter($this->l10n->t('Value')), |
| 124 | //'timestamp' => $sql->createNamedParameter($this->l10n->t('Date')), |
| 125 | //'unit' => $sql->createNamedParameter($this->l10n->t('Value')), |
| 126 | 'value' => $sql->createNamedParameter($value), |
| 127 | 'chart' => $sql->createNamedParameter($chart), |
| 128 | 'visualization' => $sql->createNamedParameter($visualization), |
| 129 | 'version' => $sql->createNamedParameter(random_int(self::INITIAL_VERSION_MIN, self::INITIAL_VERSION_MAX)), |
| 130 | ]); |
| 131 | $sql->executeStatement(); |
| 132 | return (int)$sql->getLastInsertId(); |
| 133 | } |
| 134 | |
| 135 | /** |
| 136 | * get single report for user |
no outgoing calls