| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167 |
- <?php
- require "../initialise.php";
- $path = readline("Type relative path to file, CWD is " . getcwd() . ": ");
- if(!file_exists($path)) die($path . " not found.");
- $customer_id = readline("Type customer ID: ");
- $customer = Customer::get($customer_id);
- if(!$customer) die("Customer not found.");
- $region = readline("Type region code: ");
- $confirm = readline($customer->name . ": Confirm Y/N: ");
- if($confirm != "Y") die("Aborted");
- $handle = fopen($path, "r");
- date_default_timezone_set("UTC");
- for($i = 0; $data = fgetcsv($handle); $i++) {
- $data = array_map("trim", $data);
- if($i == 0) {
- // Header
- foreach($data as $index => $field_name) {
- switch($field_name) {
- case "Name": $name_column = $index; break;
- case "Legal Entity Name": $legal_entity_name_column = $index; break;
- case "Address 1": $address_1_column = $index; break;
- case "Address 2": $address_2_column = $index; break;
- case "City": $city_column = $index; break;
- case "County": $county_column = $index; break;
- case "Postcode":
- case "Post Code":
- case "Postal Code": $postal_code_column = $index; break;
- case "State": $state_column = $index; break;
- case "Country": $country_column = $index; break;
- case "Email": $email_column = $index; break;
- case "Phone": $phone_column = $index; break;
- case "Opening Hours": $opening_hours_column = $index; break;
- case "Closing Hours": $closing_hours_column = $index; break;
- case "Shop Left": $shop_left_column = $index; break;
- case "Shop Right": $shop_right_column = $index; break;
- case "Brand": $brand_column = $index; break;
- case "Region": $region_column = $index; break;
- case "Region Name": $region_name_column = $index; break;
- case "Internal ID": $internal_id_column = $index; break;
- case "Area Manager": $area_manager_column = $index; break;
- case "Area Manager Name": $area_manager_name_column = $index; break;
- case "Area Manager Email": $area_manager_email_column = $index; break;
- case "Operations Manager Name": $operations_manager_name_column = $index; break;
- case "Closed": $closed_column = $index; break;
- case "Latitude": $latitude_column = $index; break;
- case "Longitude": $longitude_column = $index; break;
- case "Ignore":
- break;
- default:
- throw new Exception("Unknown field name: {$field_name}");
- }
- }
- continue;
- }
- $internal_id = isset($internal_id_column) ? $data[$internal_id_column] : null;
- $city = isset($city_column) ? $data[$city_column] : null;
- $legal_entity_name = isset($legal_entity_name_column) ? $data[$legal_entity_name_column] : null;
- $region = isset($region_column) ? $data[$region_column] : null;
- $area_manager = isset($area_manager_column) ? $data[$area_manager_column] : null;
- $opening_hours = isset($opening_hours_column) ? $data[$opening_hours_column] : null;
- $closing_hours = isset($closing_hours_column) ? $data[$closing_hours_column] : null;
- $name = isset($name_column) ? $data[$name_column] : null;
- $address_1 = isset($address_1_column) ? $data[$address_1_column] : null;
- $postal_code = isset($postal_code_column) ? $data[$postal_code_column] : null;
- $email = isset($email_column) ? $data[$email_column] : null;
- $latitude = isset($latitude_column) ? $data[$latitude_column] : null;
- $longitude = isset($longitude_column) ? $data[$longitude_column] : null;
- $address_2 = isset($address_2_column) ? $data[$address_2_column] : null;
- $county = isset($county_column) ? $data[$county_column] : null;
- $phone = isset($phone_column) ? $data[$phone_column] : null;
- $brand = isset($brand_column) ? $data[$brand_column] : null;
- $area_manager_name = isset($area_manager_name_column) ? $data[$area_manager_name_column] : null;
- $area_manager_email = isset($area_manager_email_column) ? $data[$area_manager_email_column] : null;
- $region_name = isset($region_name_column) ? $data[$region_name_column] : null;
- $operations_manager_name = isset($operations_manager_name_column) ? $data[$operations_manager_name_column] : null;
- if(empty($internal_id)) continue;
- if(empty($city)) continue;
- echo "Importing $internal_id - $city ... ";
- $location = Location::queryOne([
- "customer_id" => $customer_id,
- "internal_id" => $internal_id
- ]);
- if(!$location) {
- $location = new Location;
- $location->customer_id = $customer_id;
- $location->internal_id = $internal_id;
- }
- if(!empty($email)) $location->email = $email;
- if(!empty($latitude)) $location->latitude = $latitude;
- if(!empty($longitude)) $location->longitude = $longitude;
- if(!empty($address_2)) $location->address_2 = $address_2;
- if(!empty($county)) $location->county = $county;
- if(!empty($phone)) $location->phone = $phone;
- if(!empty($brand)) $location->brand = $brand;
- if(!empty($area_manager_name)) $location->area_manager_name = $area_manager_name;
- if(!empty($area_manager_email)) $location->area_manager_email = $area_manager_email;
- if(!empty($region_name)) $location->region_name = $region_name;
- if(!empty($operations_manager_name)) $location->operations_manager_name = $operations_manager_name;
- $location->city = $city;
- $location->legal_entity_name = $legal_entity_name;
- $location->region = $region;
- $location->area_manager = $area_manager;
- $hours_parts = [];
- if($opening_hours) $hours_parts[] = "Opening Hours: $opening_hours";
- if($closing_hours) $hours_parts[] = "Closing Hours: $closing_hours";
- $location->opening_hours = implode("\n", $hours_parts);
- $location->name = $name;
- if(stripos($name, $city) === false) {
- $location->name .= " ($city)";
- }
- $location->address_1 = str_replace(", $city", "", $address_1);
- $location->postal_code = $postal_code;
- if(!$location->latitude) {
- for($attempt = 0; $attempt < 2; $attempt++) {
- switch($attempt) {
- case 0: $query = $location->getDisplayAddress(); break;
- case 1: $query = $postal_code; break;
- }
- try {
- $results = Geolocation::geocode($query, $region);
- if($results) {
- $result = $results[0];
- $location->latitude = $result->geometry->location->lat;
- $location->longitude = $result->geometry->location->lng;
- }
- }
- catch(Exception $e) {
- echo $e->getMessage() . ": $query ... ";
- }
- }
- }
- $success = $location->commit();
- if(!$success) throw new Exception("Commit failed.");
- echo "OK\n";
- }
|