easychart-8.x-3.5/src/EasychartUpdate.php

<?php

namespace Drupal\easychart;

use Drupal\Component\Utility\Unicode;

/**
 * Update helper class.
 */
class EasychartUpdate {

  /**
   * Update the csv data from the url stored in the database.
   */
  public static function updateCsvFromUrl() {
    $field_storages = \Drupal::entityTypeManager()
      ->getStorage('field_storage_config')
      ->loadByProperties(['type' => 'easychart']);

    /** @var \Drupal\field\FieldStorageConfigInterface $field_storage */
    foreach ($field_storages as $field_storage) {
      $field_name = $field_storage->getName();
      $entity_type = $field_storage->getTargetEntityTypeId();
      $ids = \Drupal::entityQuery($entity_type)
        ->condition($field_name . '.csv_url', "", "!=")
        ->accessCheck(TRUE)
        ->execute();

      if (!empty($ids)) {
        $entities = \Drupal::entityTypeManager()
          ->getStorage($entity_type)
          ->loadMultiple($ids);

        foreach ($entities as $entity) {
          $url = $entity->{$field_name}->csv_url;
          $csv_data = file_get_contents($url);
          if (!empty($csv_data)) {
            $delimiter = self::findCsvDelimiter($csv_data);
            $csv = json_encode(self::parseCsv($csv_data, $delimiter));
            $entity->{$field_name}->csv = $csv;
            $entity->save();
          }
        }
      }
    }
  }

  /**
   * Helper function to parse the csv data into an array.
   *
   * @param string $csv_string
   *   The CSV.
   * @param string $delimiter
   *   The delimiter.
   * @param bool $skip_empty_lines
   *   Whether to skip empty lines or not.
   * @param bool $trim_fields
   *   Whether to trim fields or not.
   *
   * @return array
   *   Parsed data.
   */
  private static function parseCsv(string $csv_string, string $delimiter = ",", $skip_empty_lines = TRUE, $trim_fields = TRUE) {
    $enc = preg_replace('/(?<!")""/', '!!Q!!', $csv_string);
    $enc = preg_replace_callback(
      '/"(.*?)"/s',
      function ($field) {
        return urlencode(Unicode::convertToUtf8($field[1], 'ISO-8859-1'));
      },
      $enc
    );
    $lines = preg_split($skip_empty_lines ? ($trim_fields ? '/( *\R)+/s' : '/\R+/s') : '/\R/s', $enc);
    return array_map(
      function ($line) use ($delimiter, $trim_fields) {
        $fields = $trim_fields ? array_map('trim', explode($delimiter, $line)) : explode($delimiter, $line);
        return array_map(
          function ($field) {
            return str_replace('!!Q!!', '"', iconv('UTF-8', 'ISO-8859-1', urldecode($field)));
          },
          $fields
        );
      },
      $lines
    );
  }

  /**
   * Helper function to find the delimiter in a csv file.
   *
   * @param string $data
   *   A collection of data.
   *
   * @return string
   *   The delimiter.
   */
  private static function findCsvDelimiter($data): string {
    // Possible delimiters.
    $delimiters = [
      'tab'       => "\t",
      'comma'     => ",",
      'semicolon' => ";",
    ];

    // Count how much a possible delimiter appears.
    $delimiters_found = [];
    foreach ($delimiters as $key => $value) {
      $delimiters_found[$key] = count(explode($value, $data)) - 1;
    }

    // Get the highest appearance score.
    arsort($delimiters_found);
    reset($delimiters_found);
    $delimiter = key($delimiters_found);

    return $delimiters[$delimiter];
  }

}