import_shoppers.php 3.4 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119
  1. <?php
  2. require "../initialise.php";
  3. $file = "tasks/Shoppers.csv";
  4. $handle = fopen($file, "r");
  5. date_default_timezone_set("UTC");
  6. for($i = 0; $line = fgetcsv($handle); $i++) {
  7. if($i == 0) continue;
  8. $line = array_map("trim", $line);
  9. list($old_id, $display_name, $title, $first_name, $initials, $last_name, $date_created, $date_started, $date_deactivated, $date_of_birth,
  10. $proof_1_index, $proof_2_index, $mobile_number, $other_number, $email, $timestamp, $age, $password, $reference, $proof_path_1, $proof_path_2,
  11. $range_miles,
  12. $residence_address_1, $residence_address_2, $residence_town, $residence_city, $residence_county, $residence_postcode,
  13. $home_address_1, $home_address_2, $home_town, $home_city, $home_county, $home_postcode,
  14. $gender,
  15. $is_verified, $verified_by, $verified_reason, $verified_check, $date_verified,
  16. $has_own_transport, $can_work_after_6, $national_insurance_number, $preferred_payment_method, $marketing,
  17. $residence_lng, $residence_lat,
  18. $home_lng, $home_lat,
  19. $age, $day_rate, $evening_rate) = $line;
  20. if(empty($email)) {
  21. echo "Skipping $old_id (no email)\n";
  22. continue;
  23. }
  24. $email = strtolower($email);
  25. $unix_registered = strtotime($date_created);
  26. $unix_dob = strtotime($date_of_birth);
  27. $is_deactivated = !empty($date_deactivated);
  28. $gender = strtoupper(substr($gender, 0, 1));
  29. if(!$gender) $gender = "U";
  30. if(!in_array($gender, ["M", "F"])) $gender = "U";
  31. $user = User::queryOne(["old_id" => $old_id]);
  32. $email_check = User::queryOne(["email" => $email]);
  33. if($email_check) {
  34. echo "Skipping $old_id (email already exists)\n";
  35. continue;
  36. }
  37. if(!$user) {
  38. $user = new User;
  39. $user->old_id = $old_id;
  40. }
  41. else {
  42. echo "Skipping $old_id (already exists)\n";
  43. continue;
  44. }
  45. $user->email = $email;
  46. $user->level = User::LEVEL_TESTER;
  47. if($is_deactivated) $user->level = User::LEVEL_DEACTIVATED;
  48. if(in_array($title, User::TITLES)) $user->title = $title;
  49. $user->first_name = $first_name;
  50. $user->last_name = $last_name;
  51. $user->gender = $gender;
  52. if($date_of_birth) $user->date_of_birth = date("Y-m-d", $unix_dob);
  53. $user->phone = $mobile_number;
  54. $user->dts_registered = date("Y-m-d", $unix_registered);
  55. $success = $user->commit();
  56. if(!$success) throw new Exception("Commit failed.");
  57. if($residence_lat) {
  58. $address = new UserAddress;
  59. $address->user_id = $user->id;
  60. $address->name = "Current Residence";
  61. $address->address_1 = $residence_address_1;
  62. $address->address_2 = $residence_address_2;
  63. if($residence_town) $address->city = $residence_town;
  64. if($residence_city) $address->city = $residence_city;
  65. $address->county = $residence_county;
  66. $address->postal_code = $residence_postcode;
  67. $address->latitude = $residence_lat;
  68. $address->longitude = $residence_lng;
  69. if($range_miles) $address->max_radius_miles = $range_miles;
  70. $success = $address->commit();
  71. if(!$success) throw new Exception("Commit failed.");
  72. }
  73. if($home_lat) {
  74. $address = new UserAddress;
  75. $address->user_id = $user->id;
  76. $address->name = "Home";
  77. $address->address_1 = $home_address_1;
  78. $address->address_2 = $home_address_2;
  79. if($home_town) $address->city = $home_town;
  80. if($home_city) $address->city = $home_city;
  81. $address->county = $home_county;
  82. $address->postal_code = $home_postcode;
  83. $address->latitude = $home_lat;
  84. $address->longitude = $home_lng;
  85. if($range_miles) $address->max_radius_miles = $range_miles;
  86. $success = $address->commit();
  87. if(!$success) throw new Exception("Commit failed.");
  88. }
  89. }
  90. ?>