1. <?php
  3. /**
  4. * Mirrors data of entries with basic sanity checks for manual execution.
  5. *
  6. * @param array $sourceData Array of source data entries.
  7. * @param array $destinationData Array of destination data entries.
  8. * @param array $checkFields Array of fields to perform sanity checks on.
  9. * @return array Array of updated destination data entries.
  10. */
  11. function mirrorData(array $sourceData, array $destinationData, array $checkFields): array
  12. {
  13. $updatedData = [];
  15. foreach ($sourceData as $sourceEntry) {
  16. $matchingEntry = null;
  17. foreach ($destinationData as $destEntry) {
  18. // Match based on a common identifier (e.g., ID)
  19. if (isset($sourceEntry['id']) && isset($destEntry['id']) && $sourceEntry['id'] == $destEntry['id']) {
  20. $matchingEntry = $destEntry;
  21. break;
  22. }
  23. }
  25. if ($matchingEntry !== null) {
  26. // Mirror the data, performing sanity checks
  27. $updatedEntry = $matchingEntry;
  28. foreach ($checkFields as $field) {
  29. if (isset($sourceEntry[$field]) && isset($matchingEntry[$field]) && $sourceEntry[$field] !== $matchingEntry[$field]) {
  30. // Sanity check: Data mismatch
  31. error_log("Sanity check failed for field: " . $field . " - Source: " . $sourceEntry[$field] . ", Destination: " . $matchingEntry[$field]);
  32. // Optionally, handle the mismatch (e.g., log, skip, alert)
  33. // For now, we'll just leave the data as is.
  34. }
  35. }
  36. $updatedData[] = $updatedEntry;
  37. } else {
  38. // No matching entry found in destination data
  39. error_log("No matching entry found in destination data for ID: " . (isset($sourceEntry['id']) ? $sourceEntry['id'] : 'N/A'));
  40. $updatedData[] = $sourceEntry; // Keep the source entry
  41. }
  42. }
  44. return $updatedData;
  45. }
  47. // Example Usage (for manual execution)
  48. /*
  49. $sourceData = [
  50. ['id' => 1, 'name' => 'Alice', 'email' => 'alice@example.com', 'age' => 30],
  51. ['id' => 2, 'name' => 'Bob', 'email' => 'bob@example.com', 'age' => 25],
  52. ['id' => 3, 'name' => 'Charlie', 'email' => 'charlie@example.com', 'age' => 40],
  53. ];
  55. $destinationData = [
  56. ['id' => 1, 'name' => 'Alice', 'email' => 'alice@example.com', 'age' => 30],
  57. ['id' => 2, 'name' => 'Robert', 'email' => 'robert@example.com', 'age' => 26], // Different name and age
  58. ];
  60. $checkFields = ['name', 'email', 'age'];
  62. $updatedData = mirrorData($sourceData, $destinationData, $checkFields);
  64. // Output the updated data (for manual inspection)
  65. print_r($updatedData);
  66. */
  69. ?>

Add your comment