| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119 |
- <?php
- require "../initialise.php";
- $file = "tasks/Shoppers.csv";
- $handle = fopen($file, "r");
- date_default_timezone_set("UTC");
- for($i = 0; $line = fgetcsv($handle); $i++) {
- if($i == 0) continue;
- $line = array_map("trim", $line);
- list($old_id, $display_name, $title, $first_name, $initials, $last_name, $date_created, $date_started, $date_deactivated, $date_of_birth,
- $proof_1_index, $proof_2_index, $mobile_number, $other_number, $email, $timestamp, $age, $password, $reference, $proof_path_1, $proof_path_2,
- $range_miles,
- $residence_address_1, $residence_address_2, $residence_town, $residence_city, $residence_county, $residence_postcode,
- $home_address_1, $home_address_2, $home_town, $home_city, $home_county, $home_postcode,
- $gender,
- $is_verified, $verified_by, $verified_reason, $verified_check, $date_verified,
- $has_own_transport, $can_work_after_6, $national_insurance_number, $preferred_payment_method, $marketing,
- $residence_lng, $residence_lat,
- $home_lng, $home_lat,
- $age, $day_rate, $evening_rate) = $line;
- if(empty($email)) {
- echo "Skipping $old_id (no email)\n";
- continue;
- }
- $email = strtolower($email);
- $unix_registered = strtotime($date_created);
- $unix_dob = strtotime($date_of_birth);
- $is_deactivated = !empty($date_deactivated);
- $gender = strtoupper(substr($gender, 0, 1));
- if(!$gender) $gender = "U";
- if(!in_array($gender, ["M", "F"])) $gender = "U";
- $user = User::queryOne(["old_id" => $old_id]);
- $email_check = User::queryOne(["email" => $email]);
- if($email_check) {
- echo "Skipping $old_id (email already exists)\n";
- continue;
- }
- if(!$user) {
- $user = new User;
- $user->old_id = $old_id;
- }
- else {
- echo "Skipping $old_id (already exists)\n";
- continue;
- }
- $user->email = $email;
- $user->level = User::LEVEL_TESTER;
- if($is_deactivated) $user->level = User::LEVEL_DEACTIVATED;
- if(in_array($title, User::TITLES)) $user->title = $title;
- $user->first_name = $first_name;
- $user->last_name = $last_name;
- $user->gender = $gender;
- if($date_of_birth) $user->date_of_birth = date("Y-m-d", $unix_dob);
- $user->phone = $mobile_number;
- $user->dts_registered = date("Y-m-d", $unix_registered);
- $success = $user->commit();
- if(!$success) throw new Exception("Commit failed.");
- if($residence_lat) {
- $address = new UserAddress;
- $address->user_id = $user->id;
- $address->name = "Current Residence";
- $address->address_1 = $residence_address_1;
- $address->address_2 = $residence_address_2;
- if($residence_town) $address->city = $residence_town;
- if($residence_city) $address->city = $residence_city;
- $address->county = $residence_county;
- $address->postal_code = $residence_postcode;
- $address->latitude = $residence_lat;
- $address->longitude = $residence_lng;
- if($range_miles) $address->max_radius_miles = $range_miles;
- $success = $address->commit();
- if(!$success) throw new Exception("Commit failed.");
- }
- if($home_lat) {
- $address = new UserAddress;
- $address->user_id = $user->id;
- $address->name = "Home";
- $address->address_1 = $home_address_1;
- $address->address_2 = $home_address_2;
- if($home_town) $address->city = $home_town;
- if($home_city) $address->city = $home_city;
- $address->county = $home_county;
- $address->postal_code = $home_postcode;
- $address->latitude = $home_lat;
- $address->longitude = $home_lng;
- if($range_miles) $address->max_radius_miles = $range_miles;
- $success = $address->commit();
- if(!$success) throw new Exception("Commit failed.");
- }
- }
- ?>
|