1. <?php
  3. /**
  4. * Cleans data in collections for dry-run scenarios with error logging.
  5. *
  6. * @param array $collections An array of collections to clean.
  7. * @return array An array of cleaned collections.
  8. */
  9. function cleanCollections(array $collections): array
  10. {
  11. $cleanedCollections = [];
  12. $errors = [];
  14. foreach ($collections as $collection) {
  15. try {
  16. // Validate if the collection is an array
  17. if (!is_array($collection)) {
  18. $errors[] = "Invalid collection: Expected an array, got " . gettype($collection);
  19. continue; // Skip to the next collection
  20. }
  22. // Remove null/empty values
  23. $cleanedCollection = array_filter($collection, function ($value) {
  24. return $value !== null && $value !== '';
  25. });
  27. // Remove whitespace from strings
  28. $cleanedCollection = array_map(function ($value) {
  29. if (is_string($value)) {
  30. return trim($value);
  31. }
  32. return $value;
  33. }, $cleanedCollection);
  35. // Remove duplicates - using array_values to reindex
  36. $cleanedCollection = array_values(array_unique($cleanedCollection));
  38. $cleanedCollections[] = $cleanedCollection;
  40. } catch (Exception $e) {
  41. $errors[] = "Error cleaning collection: " . $e->getMessage() . ". Collection data: " . print_r($collection, true);
  42. }
  43. }
  45. // Log errors
  46. if (!empty($errors)) {
  47. error_log("Data Cleaning Errors:\n" . implode("\n", $errors));
  48. }
  50. return $cleanedCollections;
  51. }
  53. // Example Usage (for testing)
  54. /*
  55. $collections = [
  56. ['name' => ' John Doe ', 'age' => 30, 'city' => 'New York', 'email' => null, 'phone' => ''],
  57. ['product' => 'Widget', 'price' => 19.99, 'category' => '', 'quantity' => 10],
  58. ['item' => 'Book', 'title' => 'The Lord of the Rings', 'author' => 'J.R.R. Tolkien', 'isbn' => '978-0618260264'],
  59. 'invalid_collection',
  60. ];
  62. $cleaned = cleanCollections($collections);
  64. print_r($cleaned);
  65. */
  66. ?>

Add your comment