$location, "latestTest" => null, "testerId" => null, "testCount" => 0 ]; }; // Input $customer_id = http::value("customer_id", "int"); $min_date = http::value("min_date"); $max_date = http::value("max_date"); // Get customer $customer = Customer::get($customer_id); if(!$customer) throw new RuntimeException("Customer not found."); // Get locations $locations = $customer->getLocations(["archived" => 0]); foreach($locations as $location) { $results[$location->id] = $init_result($location); } // Get tests $nvp = [ "status" => Constraint::notEquals(Test::STATUS_CANCELLED), "location_id" => array_column($locations, "id") ]; if($min_date && $max_date) { if(preg_match($date_format, $min_date) && preg_match($date_format, $max_date)) { $min_dts = $min_date; $max_dts = $max_date; $nvp["dts_start"] = Constraint::between($min_dts, $max_dts); } else { throw new RuntimeException("Invalid dates submitted."); } } else { [$min_dts, $max_dts] = $customer->getYearCycleDates(); $nvp["dts_start"] = Constraint::between($min_dts, $max_dts); } $tests = Test::query($nvp); foreach($tests as $test) { $result = $results[$test->location_id]; $result->testCount++; $assign_test = false; if($result->latestTest === null) { $assign_test = true; } else { /** @var Test $existing */ $existing = $result->latestTest; $unix_start_existing = ($existing->dts_start === null) ? 0 : strtotime($existing->dts_start . " UTC"); $unix_start_current = ($test->dts_start === null) ? 0 : strtotime($test->dts_start . " UTC"); if($unix_start_current > $unix_start_existing) { $assign_test = true; } } if($assign_test) { $result->latestTest = $test; $result->testerId = $test->tester_id; } } $tester_ids = array_column($results, "testerId"); User::load($tester_ids); $output = []; foreach($results as $result) { /** @var Location $location */ $location = $result->location; /** @var Test $test */ $test = $result->latestTest; $customer_slug = Util::slug($customer->name, "_"); /** @var User $tester */ $tester = null; $formatted_start_dts = null; $formatted_due_dts = null; $icon = null; $icon_file = "{$customer_slug}_none.png"; $past_due = false; if($test) { $tester = $test->getTester(); if($test->dts_start !== null) { $unix_start = strtotime($test->dts_start); $formatted_start_dts = date("d/m/Y H:i", $unix_start); } if($test->isPending()) { $icon_file = "{$customer_slug}_pending.png"; $unix_due = null; if($test->dts_due !== null) { $unix_due = strtotime($test->dts_due); $formatted_due_dts = date("d/m/Y H:i", $unix_due); } if($tester && $unix_due && time() > $unix_due) { $icon_file = "{$customer_slug}_past_due.png"; $past_due = true; } } else if($test->pass) { $icon_file = "{$customer_slug}_pass.png"; } else { $icon_file = "{$customer_slug}_fail.png"; } } if($location->do_not_test) { $icon_file = "do_not_test.png"; } if($location->closed) { $icon_file = "closed.png"; } if(file_exists("public/img/markers/$icon_file")) { $icon = $icon_file; } $data = [ "id" => (int) $location->id, "internalId" => $location->internal_id, "name" => $location->name, "latitude" => (float) $location->latitude, "longitude" => (float) $location->longitude, "icon" => $icon, "test" => null, "doNotTest" => (bool) $location->do_not_test, "closed" => (bool) $location->closed, "archived" => $location->isArchived(), "testCount" => $result->testCount ]; if($test) { $data["test"] = [ "id" => $test->id, "formattedStartDts" => $formatted_start_dts, "formattedDueDts" => $formatted_due_dts, "tester" => null, "pastDue" => $past_due, ]; if($tester) { $data["test"]["tester"] = [ "id" => $tester->id, "name" => $tester->getDisplayName(), ]; } } $output[] = $data; } JSON::success([ "locations" => $output, "testPeriod" => sprintf("%s to %s", $min_dts, $max_dts) ]); break; } // Gets all locations for a project case "get-project-locations": { $project_id = http::value("project_id", "int"); $project = Project::get($project_id); if(!$project) throw new RuntimeException("Project not found."); $customer = $project->getCustomer(); $tests = $project->getTests(); $locations = Location::load(array_column($tests, "location_id")); $location_tests = []; foreach($tests as $test) { if($test->isCancelled()) continue; $location_tests[$test->location_id] = $test; } $output = []; foreach($locations as $location) { $test = $location_tests[$location->id] ?? false; $test_id = null; $status = 0; $status_text = ""; $pass = 0; $pass_class = ""; $pass_text = ""; $pass_icon = ""; $class = "secondary"; if($test) { $test_id = $test->id; $class = $test->getStatusClass(); $status = $test->status; $status_text = $test->getStatusText(); $pass = $test->pass; $pass_class = $test->getPassClass(); $pass_text = $test->getPassText(); $pass_icon = $test->getPassIcon(); } $filename = Util::slug($customer->name, "_"); $icon = null; if(file_exists("public/img/markers/$filename.png")) { $icon = "$filename.png"; } $output[] = (object) [ "id" => (int) $location->id, "internalId" => $location->internal_id, "testId" => (int) $test_id, "name" => $location->name, "address" => $location->getDisplayAddress(["address_1", "address_2", "city", "postal_code"]), "address1" => $location->address_1, "status" => $status, "statusText" => $status_text, "pass" => (int) $pass, "passClass" => $pass_class, "passText" => $pass_text, "passIcon" => $pass_icon, "class" => $class, "latitude" => (float) $location->latitude, "longitude" => (float) $location->longitude, "icon" => $icon ]; } usort($output, static function(object $a, object $b): int { return $a->status <=> $b->status; }); JSON::success([ "locations" => $output ]); break; } default: throw new RuntimeException("Invalid request."); } } catch(Exception $e) { JSON::fail($e->getMessage()); } } JSON::fail("Invalid request.");