| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221 |
- <?php
- namespace Helpers;
- use Constraint;
- use Exception;
- use Location;
- use RuntimeException;
- use Test;
- use User;
- use Util;
- class LocationHelper {
- public const DATE_FORMAT = "/^2\d{3}-[01]\d-[0-3]\d$/";
- /**
- * @param Location[] $locations
- * @param string|null $min_date
- * @param string|null $max_date
- * @return array
- * @throws Exception
- */
- public static function getMarkerDataForLocations(array $locations, ?string $min_date, ?string $max_date, array $options = []): array {
- if(empty($locations)) {
- return [];
- }
- $failed_only = $options["failed_only"] ?? false;
- $untested_only = $options["untested_only"] ?? false;
- $user = $options["user"] ?? null;
- $location = reset($locations);
- $customer = $location->getCustomer();
- $init_result = static function(Location $location): object {
- return (object) [
- "location" => $location,
- "latestTest" => null,
- "testerId" => null,
- "testCount" => 0
- ];
- };
- $results = [];
- 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($user && $user->level <= User::LEVEL_CUSTOMER) {
- $nvp["status"] = Test::STATUS_COMPLETED;
- }
- if($min_date && $max_date) {
- if(preg_match(self::DATE_FORMAT, $min_date) && preg_match(self::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}.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,
- "passed" => $test->isPass(),
- "resultText" => $test->getPassText(),
- ];
- if($tester) {
- $data["test"]["tester"] = [
- "id" => $tester->id,
- "name" => $tester->getDisplayName(),
- ];
- }
- }
- $output[] = $data;
- }
- if($failed_only) {
- $output = array_values(array_filter($output, static fn($test) => isset($test["test"]) && !$test["test"]["passed"]));
- }
- if($untested_only) {
- $output = array_values(array_filter($output, static fn($test) => $test["test"] === null));
- }
- return $output;
- }
- }
|