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

Method importReports

lib/UserMigration/AnalyticsMigrator.php:219–267  ·  view source on GitHub ↗

* @param list > $rows * @param array $datasetMap * @return array * @throws Exception */

(string $uid, array $rows, array $datasetMap, array $columnMaps = [])

Source from the content-addressed store, hash-verified

217 * @throws Exception
218 */
219 private function importReports(string $uid, array $rows, array $datasetMap, array $columnMaps = []): array {
220 $idMap = [];
221
222 foreach ($rows as $row) {
223 if (!isset($row['id'])) {
224 continue;
225 }
226
227 $oldId = (int)$row['id'];
228 $oldDataset = isset($row['dataset']) ? (int)$row['dataset'] : 0;
229 $newDataset = $oldDataset === 0 ? 0 : ($datasetMap[$oldDataset] ?? 0);
230 $columnMap = $columnMaps[$oldDataset] ?? [];
231
232 $newId = $this->insertAndReturnId('analytics_report', [
233 'user_id' => $uid,
234 'dataset' => $newDataset,
235 'name' => $row['name'] ?? '',
236 'subheader' => $row['subheader'] ?? null,
237 'link' => $row['link'] ?? '',
238 'type' => isset($row['type']) ? (int)$row['type'] : 0,
239 'parent' => 0,
240 'dimension1' => $this->remapReferenceValue($row['dimension1'] ?? '', $columnMap),
241 'dimension2' => $this->remapReferenceValue($row['dimension2'] ?? '', $columnMap),
242 'value' => $this->remapReferenceValue($row['value'] ?? '', $columnMap),
243 'chart' => $row['chart'] ?? 'line',
244 'visualization' => $row['visualization'] ?? 'table',
245 'chartoptions' => $this->remapReferenceJson($row['chartoptions'] ?? null, $columnMap),
246 'dataoptions' => $this->remapReferenceJson($row['dataoptions'] ?? null, $columnMap),
247 'filteroptions' => $this->remapReferenceJson($row['filteroptions'] ?? null, $columnMap),
248 'tableoptions' => $this->remapReferenceJson($row['tableoptions'] ?? null, $columnMap),
249 'refresh' => isset($row['refresh']) ? (int)$row['refresh'] : 0,
250 'version' => isset($row['version']) ? (int)$row['version'] : 0,
251 ]);
252 $idMap[$oldId] = $newId;
253 }
254
255 foreach ($rows as $row) {
256 if (!isset($row['id']) || !isset($idMap[(int)$row['id']])) {
257 continue;
258 }
259
260 $newId = $idMap[(int)$row['id']];
261 $oldParent = isset($row['parent']) ? (int)$row['parent'] : 0;
262 $newParent = $oldParent === 0 ? 0 : ($idMap[$oldParent] ?? 0);
263 $this->updateById('analytics_report', $newId, ['parent' => $newParent]);
264 }
265
266 return $idMap;
267 }
268
269 /**
270 * @param list<array<string,mixed>> $rows

Callers 1

importMethod · 0.95

Calls 4

insertAndReturnIdMethod · 0.95
remapReferenceValueMethod · 0.95
remapReferenceJsonMethod · 0.95
updateByIdMethod · 0.95

Tested by

no test coverage detected