getAddresses(); $output = []; foreach($addresses as $address) { $output[] = [ "name" => $address->name, "latitude" => (float) $address->latitude, "longitude" => (float) $address->longitude ]; } JSON::success([ "addresses" => $output ]); break; case "get-locations": $output = []; $address_id = http::value("address_id", "int"); $max_distance = http::value("max_distance", "int"); if($max_distance <= 0) $max_distance = 50; $date_start = http::value("date_start", "db"); $date_end = http::value("date_end", "db"); $pending_tests = http::value("pending_tests", "int"); $address = UserAddress::queryOne([ "id" => $address_id, "user_id" => $id, ]); if(!$address) throw new Exception("Cannot find address."); // Get locations according to bounds $bounds = Geolocation::getBounds($address->getGeolocation(), $max_distance); list($min_lat, $min_lng) = $bounds->southWest; list($max_lat, $max_lng) = $bounds->northEast; $locations = Location::query([ "latitude" => (new Constraint("BETWEEN"))->setValues($min_lat, $max_lat), "longitude" => (new Constraint("BETWEEN"))->setValues($min_lng, $max_lng), "archived" => 0, "closed" => 0 ]); // Get customers $customers = Customer::load(array_column($locations, "customer_id")); // Sort locations by distance usort($locations, function($a, $b) use ($address) { /** * @var Location $a * @var Location $b */ return Geolocation::getDistance($address->getGeolocation(), $a->getGeolocation()) <=> Geolocation::getDistance($address->getGeolocation(), $b->getGeolocation()); }); // Get tests $test_nvp = [ "status" => (new Constraint("NOT_EQUALS"))->setValues(Test::STATUS_CANCELLED), "location_id" => array_column($locations, "id") ]; if($pending_tests) { $test_nvp["status"] = [Test::STATUS_UNASSIGNED, Test::STATUS_ASSIGNED]; } else { $test_nvp["dts_start"] = (new Constraint("BETWEEN"))->setValues($date_start, $date_end); } $tests = Test::query($test_nvp); // Get projects $projects = Project::load(array_column($tests, "project_id")); $location_test_array = []; foreach($tests as $test) { $exists = isset($location_test_array[$test->location_id]); if(!$exists) { $location_test_array[$test->location_id] = $test; } else { $existing = $location_test_array[$test->location_id]; $unix_start_existing = is_null($existing->dts_start) ? 0 : strtotime($existing->dts_start . " UTC"); $unix_start_current = is_null($test->dts_start) ? 0 : strtotime($test->dts_start . " UTC"); if($unix_start_current > $unix_start_existing) { $location_test_array[$test->location_id] = $test; } } } // Start output foreach($locations as $location) { // Filter by distance $distance = Geolocation::getDistance($address->getGeolocation(), $location->getGeolocation()); if($distance > $max_distance) continue; /** @var Test $test */ $test = $location_test_array[$location->id] ?? null; if($pending_tests) { if(!$test) continue; if($test->dts_start) continue; } // Get customer $customer = $location->getCustomer(); $customer_slug = Util::slug($customer->name, "_"); // Test /** @var User $tester */ $tester = null; $formatted_start_dts = null; $formatted_due_dts = null; $past_due = false; // Icon $icon = null; $icon_file = "{$customer_slug}_none.png"; // Process test if($test) { $tester = $test->getTester(); $project = $test->getProject(); if(!is_null($test->dts_start)) { $unix_start = strtotime($test->dts_start); $formatted_start_dts = date("d/m/Y H:i", $unix_start); } if(is_null($test->pass)) { $icon_file = "{$customer_slug}_pending.png"; // Has due date if(!is_null($test->dts_due)) { $unix_due = strtotime($test->dts_due); $formatted_due_dts = date("d/m/Y H:i", $unix_due); if($tester && time() > $unix_due) { $icon_file = "{$customer_slug}_past_due.png"; $past_due = true; } } } else if($test->pass) { $icon_file = "{$customer_slug}_pass.png"; } else if(!$test->pass) { $icon_file = "{$customer_slug}_fail.png"; } } if($icon_file && file_exists("public/img/markers/$icon_file")) { $icon = $icon_file; } $data = [ "id" => (int) $location->id, "internalId" => (int) $location->internal_id, "name" => $location->name, "address" => $location->getDisplayAddress(), "distance" => $distance, "latitude" => (double) $location->latitude, "longitude" => (double) $location->longitude, "icon" => $icon, "customer" => [ "id" => $customer->id, "name" => $customer->name, ], "test" => null, ]; if($test) { $pass = is_null($test->pass) ? null : intval($test->pass); $data["test"] = [ "id" => (int) $test->id, "pass" => $pass, "formattedStartDts" => $formatted_start_dts, "formattedDueDts" => $formatted_due_dts, "tester" => null, "pastDue" => $past_due, ]; if($project) { $data["test"]["project"] = [ "id" => (int) $project->id, "name" => $project->name, ]; } if($tester) { $data["test"]["tester"] = [ "id" => (int) $tester->id, "name" => $tester->getDisplayName(), ]; } } $output[] = $data; } JSON::success([ "name" => $address->name, "latitude" => (double) $address->latitude, "longitude" => (double) $address->longitude, "locations" => $output ]); break; }