Method getData

lib/Controller/OutputController.php:250–302

* Get the data from backend; * pre-evaluation of valid datasetId within read & readPublic is trusted here * also used in Pagecontroller-indexPublicMin ToDo: make this private * * @param $reportMetadata * @return array * @throws Exception */

($reportMetadata)

	 * @throws Exception
	 */
	#[NoAdminRequired]
	public function getData($reportMetadata) {
		$datasource = (int)$reportMetadata['type'];
		$datasetId = (int)$reportMetadata['dataset'];

		$filterOptions = $reportMetadata['filteroptions']; // need to remember the filter with original text variables
		$reportMetadata = $this->VariableService->replaceFilterVariables($reportMetadata); // replace %xx% dynamic variables

		if ($datasource === DatasourceController::DATASET_TYPE_INTERNAL_DB) {
			// Internal data
			if ($datasetId !== 0) {
				$result = $this->StorageService->read($datasetId, $reportMetadata);
			} else {
				$result['error'] = 'inconsistent report';
			}
		} else {
			// Realtime data
			$result = $this->DatasourceController->read($datasource, $reportMetadata);
			$result = DatasourceResultSanitizer::sanitize($result);
			if (isset($result['filteroptions']) && is_string($result['filteroptions'])) {
				$reportMetadata['filteroptions'] = $result['filteroptions'];
				$filterOptions = $result['filteroptions'];
				unset($result['filteroptions']);
			}

			// datasource confirmed a stable cache key and no change
			if (isset($result['cache']['notModified']) && $result['cache']['notModified'] === true) {
				return $result;
			}
		}

		// sort the data by a given column
		if ($filterOptions && isset($result['data'])) {
			$result['data'] = $this->sortByColumn($result['data'], $filterOptions);
		}

		unset($reportMetadata['parent'], $reportMetadata['user_id'], $reportMetadata['link'], $reportMetadata['dimension1'], $reportMetadata['dimension2'], $reportMetadata['dimension3'], $reportMetadata['value'], $reportMetadata['password'], $reportMetadata['dataset'], $reportMetadata['cacheKey']);

		$result['filterApplied'] = $reportMetadata['filteroptions'];
		$reportMetadata['filteroptions'] = $filterOptions; // keep the original filters

		// there can be different values for no options. null during creation; empty after removal; => harmonize them
		if (array_key_exists('chartoptions', $reportMetadata)) {
			$reportMetadata['chartoptions'] = ($reportMetadata['chartoptions'] === '' || $reportMetadata['chartoptions'] === 'null') ? null : $reportMetadata['chartoptions'];
		}

		if (array_key_exists('dataoptions', $reportMetadata)) {
			$reportMetadata['dataoptions'] = ($reportMetadata['dataoptions'] === '' || $reportMetadata['dataoptions'] === 'null') ? null : $reportMetadata['dataoptions'];
		}
		$result['options'] = $reportMetadata;
		$result['thresholds'] = $this->ThresholdService->read($reportMetadata['id']);
		return $result;
	}

	/**
	 * get the data when requested from public page