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

Method validateRanges

lib/Datasource/LocalSpreadsheet.php:199–234  ·  view source on GitHub ↗
(string $rangeList)

Source from the content-addressed store, hash-verified

197 }
198
199 private function validateRanges(string $rangeList): ?string {
200 $ranges = str_getcsv($rangeList);
201 $totalCells = 0;
202 foreach ($ranges as $range) {
203 $range = strtoupper(trim($range));
204 if ($range === '') {
205 return $this->l10n->t('Invalid spreadsheet range');
206 }
207
208 if (preg_match('/^(?<startColumn>[A-Z]{1,3})(?<startRow>[1-9][0-9]*)(?::(?<endColumn>[A-Z]{1,3})(?<endRow>[1-9][0-9]*))?$/', $range, $matches) !== 1) {
209 return $this->l10n->t('Invalid spreadsheet range');
210 }
211
212 $endColumn = ($matches['endColumn'] ?? '') !== '' ? $matches['endColumn'] : $matches['startColumn'];
213 $endRow = ($matches['endRow'] ?? '') !== '' ? $matches['endRow'] : $matches['startRow'];
214 $rows = abs((int)$endRow - (int)$matches['startRow']) + 1;
215 if ($rows > self::MAX_RANGE_ROWS) {
216 return $this->l10n->t('Spreadsheet range is too large');
217 }
218
219 try {
220 [$startColumn] = Coordinate::coordinateFromString($matches['startColumn'] . $matches['startRow']);
221 [$validatedEndColumn] = Coordinate::coordinateFromString($endColumn . $endRow);
222 $columns = abs(Coordinate::columnIndexFromString($validatedEndColumn) - Coordinate::columnIndexFromString($startColumn)) + 1;
223 } catch (\PhpOffice\PhpSpreadsheet\Exception $e) {
224 return $this->l10n->t('Invalid spreadsheet range');
225 }
226 $totalCells += $columns * $rows;
227
228 if ($totalCells > self::MAX_RANGE_CELLS) {
229 return $this->l10n->t('Spreadsheet range is too large');
230 }
231 }
232
233 return null;
234 }
235
236 private function removeNullColumns(array $data): array {
237 // Transpose the data to work with columns as rows

Callers 1

readDataMethod · 0.95

Calls 1

tMethod · 0.45

Tested by

no test coverage detected