@@ -20,67 +20,67 @@ |
||
20 | 20 | */ |
21 | 21 | class GeoAnalysisResultItem |
22 | 22 | { |
23 | - private GeoAnalysisPlace $place; |
|
24 | - private int $count; |
|
23 | + private GeoAnalysisPlace $place; |
|
24 | + private int $count; |
|
25 | 25 | |
26 | - /** |
|
27 | - * Constructor for GeoAnalysisResultItem |
|
28 | - * |
|
29 | - * @param GeoAnalysisPlace $place |
|
30 | - * @param int $count |
|
31 | - */ |
|
32 | - public function __construct(GeoAnalysisPlace $place, int $count = 0) |
|
33 | - { |
|
34 | - $this->place = $place; |
|
35 | - $this->count = $count; |
|
36 | - } |
|
26 | + /** |
|
27 | + * Constructor for GeoAnalysisResultItem |
|
28 | + * |
|
29 | + * @param GeoAnalysisPlace $place |
|
30 | + * @param int $count |
|
31 | + */ |
|
32 | + public function __construct(GeoAnalysisPlace $place, int $count = 0) |
|
33 | + { |
|
34 | + $this->place = $place; |
|
35 | + $this->count = $count; |
|
36 | + } |
|
37 | 37 | |
38 | - /** |
|
39 | - * Get the item key. |
|
40 | - * |
|
41 | - * @return string |
|
42 | - */ |
|
43 | - public function key(): string |
|
44 | - { |
|
45 | - return $this->place->key(); |
|
46 | - } |
|
38 | + /** |
|
39 | + * Get the item key. |
|
40 | + * |
|
41 | + * @return string |
|
42 | + */ |
|
43 | + public function key(): string |
|
44 | + { |
|
45 | + return $this->place->key(); |
|
46 | + } |
|
47 | 47 | |
48 | - /** |
|
49 | - * Get the referenced GeoAnalysis Place |
|
50 | - * |
|
51 | - * @return GeoAnalysisPlace |
|
52 | - */ |
|
53 | - public function place(): GeoAnalysisPlace |
|
54 | - { |
|
55 | - return $this->place; |
|
56 | - } |
|
48 | + /** |
|
49 | + * Get the referenced GeoAnalysis Place |
|
50 | + * |
|
51 | + * @return GeoAnalysisPlace |
|
52 | + */ |
|
53 | + public function place(): GeoAnalysisPlace |
|
54 | + { |
|
55 | + return $this->place; |
|
56 | + } |
|
57 | 57 | |
58 | - /** |
|
59 | - * Get the count of occurrences of the GeoAnalysis Place in the analysis |
|
60 | - * |
|
61 | - * @return int |
|
62 | - */ |
|
63 | - public function count(): int |
|
64 | - { |
|
65 | - return $this->count; |
|
66 | - } |
|
58 | + /** |
|
59 | + * Get the count of occurrences of the GeoAnalysis Place in the analysis |
|
60 | + * |
|
61 | + * @return int |
|
62 | + */ |
|
63 | + public function count(): int |
|
64 | + { |
|
65 | + return $this->count; |
|
66 | + } |
|
67 | 67 | |
68 | - /** |
|
69 | - * Increment the count of occurrences of the GeoAnalysis Place in the analysis |
|
70 | - * |
|
71 | - * @return $this |
|
72 | - */ |
|
73 | - public function increment(): self |
|
74 | - { |
|
75 | - $this->count++; |
|
76 | - return $this; |
|
77 | - } |
|
68 | + /** |
|
69 | + * Increment the count of occurrences of the GeoAnalysis Place in the analysis |
|
70 | + * |
|
71 | + * @return $this |
|
72 | + */ |
|
73 | + public function increment(): self |
|
74 | + { |
|
75 | + $this->count++; |
|
76 | + return $this; |
|
77 | + } |
|
78 | 78 | |
79 | - /** |
|
80 | - * Clone the item object |
|
81 | - */ |
|
82 | - public function __clone() |
|
83 | - { |
|
84 | - $this->place = clone $this->place; |
|
85 | - } |
|
79 | + /** |
|
80 | + * Clone the item object |
|
81 | + */ |
|
82 | + public function __clone() |
|
83 | + { |
|
84 | + $this->place = clone $this->place; |
|
85 | + } |
|
86 | 86 | } |
@@ -31,40 +31,40 @@ |
||
31 | 31 | */ |
32 | 32 | class AuthTreePreference implements MiddlewareInterface |
33 | 33 | { |
34 | - /** |
|
35 | - * {@inheritDoc} |
|
36 | - * @see \Psr\Http\Server\MiddlewareInterface::process() |
|
37 | - */ |
|
38 | - public function process(ServerRequestInterface $request, RequestHandlerInterface $handler): ResponseInterface |
|
39 | - { |
|
40 | - $tree = Validator::attributes($request)->tree(); |
|
41 | - $route = Validator::attributes($request)->route(); |
|
42 | - $user = Validator::attributes($request)->user(); |
|
34 | + /** |
|
35 | + * {@inheritDoc} |
|
36 | + * @see \Psr\Http\Server\MiddlewareInterface::process() |
|
37 | + */ |
|
38 | + public function process(ServerRequestInterface $request, RequestHandlerInterface $handler): ResponseInterface |
|
39 | + { |
|
40 | + $tree = Validator::attributes($request)->tree(); |
|
41 | + $route = Validator::attributes($request)->route(); |
|
42 | + $user = Validator::attributes($request)->user(); |
|
43 | 43 | |
44 | - $permission_preference = $route->extras['permission_preference'] ?? ''; |
|
45 | - $permission_level = $permission_preference === '' ? '' : $tree->getPreference($permission_preference); |
|
44 | + $permission_preference = $route->extras['permission_preference'] ?? ''; |
|
45 | + $permission_level = $permission_preference === '' ? '' : $tree->getPreference($permission_preference); |
|
46 | 46 | |
47 | - // Permissions are configured |
|
48 | - if (is_numeric($permission_level)) { |
|
49 | - // Logged in with the correct role? |
|
50 | - if (Auth::accessLevel($tree, $user) <= (int) $permission_level) { |
|
51 | - return $handler->handle($request); |
|
52 | - } |
|
47 | + // Permissions are configured |
|
48 | + if (is_numeric($permission_level)) { |
|
49 | + // Logged in with the correct role? |
|
50 | + if (Auth::accessLevel($tree, $user) <= (int) $permission_level) { |
|
51 | + return $handler->handle($request); |
|
52 | + } |
|
53 | 53 | |
54 | - // Logged in, but without the correct role? |
|
55 | - if ($user instanceof User) { |
|
56 | - throw new HttpAccessDeniedException(); |
|
57 | - } |
|
58 | - } |
|
54 | + // Logged in, but without the correct role? |
|
55 | + if ($user instanceof User) { |
|
56 | + throw new HttpAccessDeniedException(); |
|
57 | + } |
|
58 | + } |
|
59 | 59 | |
60 | - // Permissions no configured, or not logged in |
|
61 | - if ($request->getMethod() === RequestMethodInterface::METHOD_POST) { |
|
62 | - throw new HttpAccessDeniedException(); |
|
63 | - } |
|
60 | + // Permissions no configured, or not logged in |
|
61 | + if ($request->getMethod() === RequestMethodInterface::METHOD_POST) { |
|
62 | + throw new HttpAccessDeniedException(); |
|
63 | + } |
|
64 | 64 | |
65 | - return Registry::responseFactory()->redirect( |
|
66 | - LoginPage::class, |
|
67 | - ['tree' => $tree->name(), 'url' => (string) $request->getUri()] |
|
68 | - ); |
|
69 | - } |
|
65 | + return Registry::responseFactory()->redirect( |
|
66 | + LoginPage::class, |
|
67 | + ['tree' => $tree->name(), 'url' => (string) $request->getUri()] |
|
68 | + ); |
|
69 | + } |
|
70 | 70 | } |
@@ -23,252 +23,252 @@ |
||
23 | 23 | */ |
24 | 24 | class TaskSchedule |
25 | 25 | { |
26 | - private int $id; |
|
27 | - private bool $enabled; |
|
28 | - private string $task_id; |
|
29 | - private CarbonInterface $last_run; |
|
30 | - private bool $last_result; |
|
31 | - private int $frequency; |
|
32 | - private int $nb_occurrences; |
|
33 | - private bool $is_running; |
|
26 | + private int $id; |
|
27 | + private bool $enabled; |
|
28 | + private string $task_id; |
|
29 | + private CarbonInterface $last_run; |
|
30 | + private bool $last_result; |
|
31 | + private int $frequency; |
|
32 | + private int $nb_occurrences; |
|
33 | + private bool $is_running; |
|
34 | 34 | |
35 | - /** |
|
36 | - * Constructor for TaskSchedule |
|
37 | - * |
|
38 | - * @param int $id Schedule ID |
|
39 | - * @param string $task_id Task ID |
|
40 | - * @param bool $enabled Is the schedule enabled |
|
41 | - * @param CarbonInterface $last_run Last successful run date/time |
|
42 | - * @param bool $last_result Result of the last run |
|
43 | - * @param int $frequency Schedule frequency in minutes |
|
44 | - * @param int $nb_occurrences Number of remaining occurrences to be run |
|
45 | - * @param bool $is_running Is the task currently running |
|
46 | - */ |
|
47 | - public function __construct( |
|
48 | - int $id, |
|
49 | - string $task_id, |
|
50 | - bool $enabled, |
|
51 | - CarbonInterface $last_run, |
|
52 | - bool $last_result, |
|
53 | - int $frequency, |
|
54 | - int $nb_occurrences, |
|
55 | - bool $is_running |
|
56 | - ) { |
|
57 | - $this->id = $id; |
|
58 | - $this->task_id = $task_id; |
|
59 | - $this->enabled = $enabled; |
|
60 | - $this->last_run = $last_run; |
|
61 | - $this->last_result = $last_result; |
|
62 | - $this->frequency = $frequency; |
|
63 | - $this->nb_occurrences = $nb_occurrences; |
|
64 | - $this->is_running = $is_running; |
|
65 | - } |
|
35 | + /** |
|
36 | + * Constructor for TaskSchedule |
|
37 | + * |
|
38 | + * @param int $id Schedule ID |
|
39 | + * @param string $task_id Task ID |
|
40 | + * @param bool $enabled Is the schedule enabled |
|
41 | + * @param CarbonInterface $last_run Last successful run date/time |
|
42 | + * @param bool $last_result Result of the last run |
|
43 | + * @param int $frequency Schedule frequency in minutes |
|
44 | + * @param int $nb_occurrences Number of remaining occurrences to be run |
|
45 | + * @param bool $is_running Is the task currently running |
|
46 | + */ |
|
47 | + public function __construct( |
|
48 | + int $id, |
|
49 | + string $task_id, |
|
50 | + bool $enabled, |
|
51 | + CarbonInterface $last_run, |
|
52 | + bool $last_result, |
|
53 | + int $frequency, |
|
54 | + int $nb_occurrences, |
|
55 | + bool $is_running |
|
56 | + ) { |
|
57 | + $this->id = $id; |
|
58 | + $this->task_id = $task_id; |
|
59 | + $this->enabled = $enabled; |
|
60 | + $this->last_run = $last_run; |
|
61 | + $this->last_result = $last_result; |
|
62 | + $this->frequency = $frequency; |
|
63 | + $this->nb_occurrences = $nb_occurrences; |
|
64 | + $this->is_running = $is_running; |
|
65 | + } |
|
66 | 66 | |
67 | - /** |
|
68 | - * Get the schedule ID. |
|
69 | - * |
|
70 | - * @return int |
|
71 | - */ |
|
72 | - public function id(): int |
|
73 | - { |
|
74 | - return $this->id; |
|
75 | - } |
|
67 | + /** |
|
68 | + * Get the schedule ID. |
|
69 | + * |
|
70 | + * @return int |
|
71 | + */ |
|
72 | + public function id(): int |
|
73 | + { |
|
74 | + return $this->id; |
|
75 | + } |
|
76 | 76 | |
77 | - /** |
|
78 | - * Get the task ID. |
|
79 | - * |
|
80 | - * @return string |
|
81 | - */ |
|
82 | - public function taskId(): string |
|
83 | - { |
|
84 | - return $this->task_id; |
|
85 | - } |
|
77 | + /** |
|
78 | + * Get the task ID. |
|
79 | + * |
|
80 | + * @return string |
|
81 | + */ |
|
82 | + public function taskId(): string |
|
83 | + { |
|
84 | + return $this->task_id; |
|
85 | + } |
|
86 | 86 | |
87 | - /** |
|
88 | - * Returns whether the schedule is enabled |
|
89 | - * |
|
90 | - * @return bool |
|
91 | - */ |
|
92 | - public function isEnabled(): bool |
|
93 | - { |
|
94 | - return $this->enabled; |
|
95 | - } |
|
87 | + /** |
|
88 | + * Returns whether the schedule is enabled |
|
89 | + * |
|
90 | + * @return bool |
|
91 | + */ |
|
92 | + public function isEnabled(): bool |
|
93 | + { |
|
94 | + return $this->enabled; |
|
95 | + } |
|
96 | 96 | |
97 | - /** |
|
98 | - * Enable the schedule |
|
99 | - * |
|
100 | - * @return $this |
|
101 | - */ |
|
102 | - public function enable(): self |
|
103 | - { |
|
104 | - $this->enabled = true; |
|
105 | - return $this; |
|
106 | - } |
|
97 | + /** |
|
98 | + * Enable the schedule |
|
99 | + * |
|
100 | + * @return $this |
|
101 | + */ |
|
102 | + public function enable(): self |
|
103 | + { |
|
104 | + $this->enabled = true; |
|
105 | + return $this; |
|
106 | + } |
|
107 | 107 | |
108 | - /** |
|
109 | - * Disable the schedule |
|
110 | - * |
|
111 | - * @return $this |
|
112 | - */ |
|
113 | - public function disable(): self |
|
114 | - { |
|
115 | - $this->enabled = false; |
|
116 | - return $this; |
|
117 | - } |
|
108 | + /** |
|
109 | + * Disable the schedule |
|
110 | + * |
|
111 | + * @return $this |
|
112 | + */ |
|
113 | + public function disable(): self |
|
114 | + { |
|
115 | + $this->enabled = false; |
|
116 | + return $this; |
|
117 | + } |
|
118 | 118 | |
119 | - /** |
|
120 | - * Get the frequency of the schedule |
|
121 | - * |
|
122 | - * @return int |
|
123 | - */ |
|
124 | - public function frequency(): int |
|
125 | - { |
|
126 | - return $this->frequency; |
|
127 | - } |
|
119 | + /** |
|
120 | + * Get the frequency of the schedule |
|
121 | + * |
|
122 | + * @return int |
|
123 | + */ |
|
124 | + public function frequency(): int |
|
125 | + { |
|
126 | + return $this->frequency; |
|
127 | + } |
|
128 | 128 | |
129 | - /** |
|
130 | - * Set the frequency of the schedule |
|
131 | - * |
|
132 | - * @param int $frequency |
|
133 | - * @return $this |
|
134 | - */ |
|
135 | - public function setFrequency(int $frequency): self |
|
136 | - { |
|
137 | - $this->frequency = $frequency; |
|
138 | - return $this; |
|
139 | - } |
|
129 | + /** |
|
130 | + * Set the frequency of the schedule |
|
131 | + * |
|
132 | + * @param int $frequency |
|
133 | + * @return $this |
|
134 | + */ |
|
135 | + public function setFrequency(int $frequency): self |
|
136 | + { |
|
137 | + $this->frequency = $frequency; |
|
138 | + return $this; |
|
139 | + } |
|
140 | 140 | |
141 | - /** |
|
142 | - * Get the date/time of the last successful run. |
|
143 | - * |
|
144 | - * @return CarbonInterface |
|
145 | - */ |
|
146 | - public function lastRunTime(): CarbonInterface |
|
147 | - { |
|
148 | - return $this->last_run; |
|
149 | - } |
|
141 | + /** |
|
142 | + * Get the date/time of the last successful run. |
|
143 | + * |
|
144 | + * @return CarbonInterface |
|
145 | + */ |
|
146 | + public function lastRunTime(): CarbonInterface |
|
147 | + { |
|
148 | + return $this->last_run; |
|
149 | + } |
|
150 | 150 | |
151 | - /** |
|
152 | - * Set the last successful run date/time |
|
153 | - * |
|
154 | - * @param CarbonInterface $last_run |
|
155 | - * @return $this |
|
156 | - */ |
|
157 | - public function setLastRunTime(CarbonInterface $last_run): self |
|
158 | - { |
|
159 | - $this->last_run = $last_run; |
|
160 | - return $this; |
|
161 | - } |
|
151 | + /** |
|
152 | + * Set the last successful run date/time |
|
153 | + * |
|
154 | + * @param CarbonInterface $last_run |
|
155 | + * @return $this |
|
156 | + */ |
|
157 | + public function setLastRunTime(CarbonInterface $last_run): self |
|
158 | + { |
|
159 | + $this->last_run = $last_run; |
|
160 | + return $this; |
|
161 | + } |
|
162 | 162 | |
163 | - /** |
|
164 | - * Returns whether the last run was successful |
|
165 | - * |
|
166 | - * @return bool |
|
167 | - */ |
|
168 | - public function wasLastRunSuccess(): bool |
|
169 | - { |
|
170 | - return $this->last_result; |
|
171 | - } |
|
163 | + /** |
|
164 | + * Returns whether the last run was successful |
|
165 | + * |
|
166 | + * @return bool |
|
167 | + */ |
|
168 | + public function wasLastRunSuccess(): bool |
|
169 | + { |
|
170 | + return $this->last_result; |
|
171 | + } |
|
172 | 172 | |
173 | - /** |
|
174 | - * Set the last run result |
|
175 | - * |
|
176 | - * @param bool $last_result |
|
177 | - * @return $this |
|
178 | - */ |
|
179 | - public function setLastResult(bool $last_result): self |
|
180 | - { |
|
181 | - $this->last_result = $last_result; |
|
182 | - return $this; |
|
183 | - } |
|
173 | + /** |
|
174 | + * Set the last run result |
|
175 | + * |
|
176 | + * @param bool $last_result |
|
177 | + * @return $this |
|
178 | + */ |
|
179 | + public function setLastResult(bool $last_result): self |
|
180 | + { |
|
181 | + $this->last_result = $last_result; |
|
182 | + return $this; |
|
183 | + } |
|
184 | 184 | |
185 | - /** |
|
186 | - * Get the number of remaining of occurrences of task runs. |
|
187 | - * Returns 0 if the tasks must be run indefinitely. |
|
188 | - * |
|
189 | - * @return int |
|
190 | - */ |
|
191 | - public function remainingOccurrences(): int |
|
192 | - { |
|
193 | - return $this->nb_occurrences; |
|
194 | - } |
|
185 | + /** |
|
186 | + * Get the number of remaining of occurrences of task runs. |
|
187 | + * Returns 0 if the tasks must be run indefinitely. |
|
188 | + * |
|
189 | + * @return int |
|
190 | + */ |
|
191 | + public function remainingOccurrences(): int |
|
192 | + { |
|
193 | + return $this->nb_occurrences; |
|
194 | + } |
|
195 | 195 | |
196 | - /** |
|
197 | - * Decrements the number of remaining occurrences by 1. |
|
198 | - * The task will be disabled when the number reaches 0. |
|
199 | - * |
|
200 | - * @return $this |
|
201 | - */ |
|
202 | - public function decrementRemainingOccurrences(): self |
|
203 | - { |
|
204 | - if ($this->nb_occurrences > 0) { |
|
205 | - $this->nb_occurrences--; |
|
206 | - if ($this->nb_occurrences === 0) { |
|
207 | - $this->disable(); |
|
208 | - } |
|
209 | - } |
|
210 | - return $this; |
|
211 | - } |
|
196 | + /** |
|
197 | + * Decrements the number of remaining occurrences by 1. |
|
198 | + * The task will be disabled when the number reaches 0. |
|
199 | + * |
|
200 | + * @return $this |
|
201 | + */ |
|
202 | + public function decrementRemainingOccurrences(): self |
|
203 | + { |
|
204 | + if ($this->nb_occurrences > 0) { |
|
205 | + $this->nb_occurrences--; |
|
206 | + if ($this->nb_occurrences === 0) { |
|
207 | + $this->disable(); |
|
208 | + } |
|
209 | + } |
|
210 | + return $this; |
|
211 | + } |
|
212 | 212 | |
213 | - /** |
|
214 | - * Set the number of remaining occurrences of task runs. |
|
215 | - * |
|
216 | - * @param int $nb_occurrences |
|
217 | - * @return $this |
|
218 | - */ |
|
219 | - public function setRemainingOccurrences(int $nb_occurrences): self |
|
220 | - { |
|
221 | - $this->nb_occurrences = $nb_occurrences; |
|
222 | - return $this; |
|
223 | - } |
|
213 | + /** |
|
214 | + * Set the number of remaining occurrences of task runs. |
|
215 | + * |
|
216 | + * @param int $nb_occurrences |
|
217 | + * @return $this |
|
218 | + */ |
|
219 | + public function setRemainingOccurrences(int $nb_occurrences): self |
|
220 | + { |
|
221 | + $this->nb_occurrences = $nb_occurrences; |
|
222 | + return $this; |
|
223 | + } |
|
224 | 224 | |
225 | - /** |
|
226 | - * Returns whether the task is running |
|
227 | - * @return bool |
|
228 | - */ |
|
229 | - public function isRunning(): bool |
|
230 | - { |
|
231 | - return $this->is_running; |
|
232 | - } |
|
225 | + /** |
|
226 | + * Returns whether the task is running |
|
227 | + * @return bool |
|
228 | + */ |
|
229 | + public function isRunning(): bool |
|
230 | + { |
|
231 | + return $this->is_running; |
|
232 | + } |
|
233 | 233 | |
234 | - /** |
|
235 | - * Informs the schedule that the task is going to run |
|
236 | - * |
|
237 | - * @return $this |
|
238 | - */ |
|
239 | - public function startRunning(): self |
|
240 | - { |
|
241 | - $this->is_running = true; |
|
242 | - return $this; |
|
243 | - } |
|
234 | + /** |
|
235 | + * Informs the schedule that the task is going to run |
|
236 | + * |
|
237 | + * @return $this |
|
238 | + */ |
|
239 | + public function startRunning(): self |
|
240 | + { |
|
241 | + $this->is_running = true; |
|
242 | + return $this; |
|
243 | + } |
|
244 | 244 | |
245 | - /** |
|
246 | - * Informs the schedule that the task has stopped running. |
|
247 | - * @return $this |
|
248 | - */ |
|
249 | - public function stopRunning(): self |
|
250 | - { |
|
251 | - $this->is_running = false; |
|
252 | - return $this; |
|
253 | - } |
|
245 | + /** |
|
246 | + * Informs the schedule that the task has stopped running. |
|
247 | + * @return $this |
|
248 | + */ |
|
249 | + public function stopRunning(): self |
|
250 | + { |
|
251 | + $this->is_running = false; |
|
252 | + return $this; |
|
253 | + } |
|
254 | 254 | |
255 | - /** |
|
256 | - * Returns the schedule details as an associate array |
|
257 | - * |
|
258 | - * @phpcs:ignore Generic.Files.LineLength.TooLong |
|
259 | - * @return array{id: int, task_id: string, enabled: bool, last_run: CarbonInterface, last_result: bool, frequency: int, nb_occurrences: int, is_running: bool} |
|
260 | - */ |
|
261 | - public function toArray(): array |
|
262 | - { |
|
263 | - return [ |
|
264 | - 'id' => $this->id, |
|
265 | - 'task_id' => $this->task_id, |
|
266 | - 'enabled' => $this->enabled, |
|
267 | - 'last_run' => $this->last_run, |
|
268 | - 'last_result' => $this->last_result, |
|
269 | - 'frequency' => $this->frequency, |
|
270 | - 'nb_occurrences' => $this->nb_occurrences, |
|
271 | - 'is_running' => $this->is_running |
|
272 | - ]; |
|
273 | - } |
|
255 | + /** |
|
256 | + * Returns the schedule details as an associate array |
|
257 | + * |
|
258 | + * @phpcs:ignore Generic.Files.LineLength.TooLong |
|
259 | + * @return array{id: int, task_id: string, enabled: bool, last_run: CarbonInterface, last_result: bool, frequency: int, nb_occurrences: int, is_running: bool} |
|
260 | + */ |
|
261 | + public function toArray(): array |
|
262 | + { |
|
263 | + return [ |
|
264 | + 'id' => $this->id, |
|
265 | + 'task_id' => $this->task_id, |
|
266 | + 'enabled' => $this->enabled, |
|
267 | + 'last_run' => $this->last_run, |
|
268 | + 'last_result' => $this->last_result, |
|
269 | + 'frequency' => $this->frequency, |
|
270 | + 'nb_occurrences' => $this->nb_occurrences, |
|
271 | + 'is_running' => $this->is_running |
|
272 | + ]; |
|
273 | + } |
|
274 | 274 | } |
@@ -28,39 +28,39 @@ |
||
28 | 28 | */ |
29 | 29 | class SosaComputeModal implements RequestHandlerInterface |
30 | 30 | { |
31 | - /** |
|
32 | - * @var SosaModule|null $module |
|
33 | - */ |
|
34 | - private $module; |
|
31 | + /** |
|
32 | + * @var SosaModule|null $module |
|
33 | + */ |
|
34 | + private $module; |
|
35 | 35 | |
36 | - /** |
|
37 | - * Constructor for SosaComputeModal Request Handler |
|
38 | - * |
|
39 | - * @param ModuleService $module_service |
|
40 | - */ |
|
41 | - public function __construct(ModuleService $module_service) |
|
42 | - { |
|
43 | - $this->module = $module_service->findByInterface(SosaModule::class)->first(); |
|
44 | - } |
|
36 | + /** |
|
37 | + * Constructor for SosaComputeModal Request Handler |
|
38 | + * |
|
39 | + * @param ModuleService $module_service |
|
40 | + */ |
|
41 | + public function __construct(ModuleService $module_service) |
|
42 | + { |
|
43 | + $this->module = $module_service->findByInterface(SosaModule::class)->first(); |
|
44 | + } |
|
45 | 45 | |
46 | - /** |
|
47 | - * {@inheritDoc} |
|
48 | - * @see \Psr\Http\Server\RequestHandlerInterface::handle() |
|
49 | - */ |
|
50 | - public function handle(ServerRequestInterface $request): ResponseInterface |
|
51 | - { |
|
52 | - if ($this->module === null) { |
|
53 | - return Registry::responseFactory()->response(view('modals/error', [ |
|
54 | - 'title' => I18N::translate('Error'), |
|
55 | - 'error' => I18N::translate('The attached module could not be found.') |
|
56 | - ])); |
|
57 | - } |
|
46 | + /** |
|
47 | + * {@inheritDoc} |
|
48 | + * @see \Psr\Http\Server\RequestHandlerInterface::handle() |
|
49 | + */ |
|
50 | + public function handle(ServerRequestInterface $request): ResponseInterface |
|
51 | + { |
|
52 | + if ($this->module === null) { |
|
53 | + return Registry::responseFactory()->response(view('modals/error', [ |
|
54 | + 'title' => I18N::translate('Error'), |
|
55 | + 'error' => I18N::translate('The attached module could not be found.') |
|
56 | + ])); |
|
57 | + } |
|
58 | 58 | |
59 | - $tree = Validator::attributes($request)->tree(); |
|
59 | + $tree = Validator::attributes($request)->tree(); |
|
60 | 60 | |
61 | - return Registry::responseFactory()->response(view($this->module->name() . '::modals/sosa-compute', [ |
|
62 | - 'tree' => $tree, |
|
63 | - 'xref' => Validator::attributes($request)->isXref()->string('xref', '') |
|
64 | - ])); |
|
65 | - } |
|
61 | + return Registry::responseFactory()->response(view($this->module->name() . '::modals/sosa-compute', [ |
|
62 | + 'tree' => $tree, |
|
63 | + 'xref' => Validator::attributes($request)->isXref()->string('xref', '') |
|
64 | + ])); |
|
65 | + } |
|
66 | 66 | } |
@@ -35,79 +35,79 @@ |
||
35 | 35 | */ |
36 | 36 | class AncestorsListIndividual implements RequestHandlerInterface |
37 | 37 | { |
38 | - use ViewResponseTrait; |
|
39 | - |
|
40 | - /** |
|
41 | - * @var SosaModule|null $module |
|
42 | - */ |
|
43 | - private $module; |
|
44 | - |
|
45 | - /** |
|
46 | - * @var SosaRecordsService $sosa_record_service |
|
47 | - */ |
|
48 | - private $sosa_record_service; |
|
49 | - |
|
50 | - /** |
|
51 | - * Constructor for AncestorsListIndividual Request Handler |
|
52 | - * |
|
53 | - * @param ModuleService $module_service |
|
54 | - * @param SosaRecordsService $sosa_record_service |
|
55 | - */ |
|
56 | - public function __construct( |
|
57 | - ModuleService $module_service, |
|
58 | - SosaRecordsService $sosa_record_service |
|
59 | - ) { |
|
60 | - $this->module = $module_service->findByInterface(SosaModule::class)->first(); |
|
61 | - $this->sosa_record_service = $sosa_record_service; |
|
62 | - } |
|
63 | - |
|
64 | - /** |
|
65 | - * {@inheritDoc} |
|
66 | - * @see \Psr\Http\Server\RequestHandlerInterface::handle() |
|
67 | - */ |
|
68 | - public function handle(ServerRequestInterface $request): ResponseInterface |
|
69 | - { |
|
70 | - $this->layout = 'layouts/ajax'; |
|
71 | - |
|
72 | - if ($this->module === null) { |
|
73 | - throw new HttpNotFoundException(I18N::translate('The attached module could not be found.')); |
|
74 | - } |
|
75 | - |
|
76 | - $tree = Validator::attributes($request)->tree(); |
|
77 | - $user = Auth::check() ? Validator::attributes($request)->user() : new DefaultUser(); |
|
78 | - $current_gen = Validator::attributes($request)->integer('gen', 0); |
|
79 | - |
|
80 | - if ($current_gen <= 0) { |
|
81 | - return Registry::responseFactory()->response( |
|
82 | - 'Invalid generation', |
|
83 | - StatusCodeInterface::STATUS_UNPROCESSABLE_ENTITY |
|
84 | - ); |
|
85 | - } |
|
86 | - |
|
87 | - $list_ancestors = $this->sosa_record_service->listAncestorsAtGeneration($tree, $user, $current_gen); |
|
88 | - $nb_ancestors_all = $list_ancestors->count(); |
|
89 | - |
|
90 | - /** @var \Illuminate\Support\Collection<int, \Fisharebest\Webtrees\Individual> $list_ancestors */ |
|
91 | - $list_ancestors = $list_ancestors |
|
92 | - ->filter(function (stdClass $value) use ($tree): bool { |
|
93 | - $indi = Registry::individualFactory()->make($value->majs_i_id, $tree); |
|
94 | - return $indi !== null && $indi->canShowName(); |
|
95 | - }) |
|
96 | - ->mapWithKeys(function (stdClass $value) use ($tree): array { |
|
97 | - $indi = Registry::individualFactory()->make($value->majs_i_id, $tree); |
|
98 | - return [(int) $value->majs_sosa => $indi]; |
|
99 | - }); |
|
100 | - |
|
101 | - $nb_ancestors_shown = $list_ancestors->count(); |
|
102 | - |
|
103 | - return $this->viewResponse($this->module->name() . '::list-ancestors-indi-tab', [ |
|
104 | - 'module_name' => $this->module->name(), |
|
105 | - 'title' => I18N::translate('Sosa Ancestors'), |
|
106 | - 'tree' => $tree, |
|
107 | - 'list_ancestors' => $list_ancestors, |
|
108 | - 'nb_ancestors_all' => $nb_ancestors_all, |
|
109 | - 'nb_ancestors_theor' => pow(2, $current_gen - 1), |
|
110 | - 'nb_ancestors_shown' => $nb_ancestors_shown |
|
111 | - ]); |
|
112 | - } |
|
38 | + use ViewResponseTrait; |
|
39 | + |
|
40 | + /** |
|
41 | + * @var SosaModule|null $module |
|
42 | + */ |
|
43 | + private $module; |
|
44 | + |
|
45 | + /** |
|
46 | + * @var SosaRecordsService $sosa_record_service |
|
47 | + */ |
|
48 | + private $sosa_record_service; |
|
49 | + |
|
50 | + /** |
|
51 | + * Constructor for AncestorsListIndividual Request Handler |
|
52 | + * |
|
53 | + * @param ModuleService $module_service |
|
54 | + * @param SosaRecordsService $sosa_record_service |
|
55 | + */ |
|
56 | + public function __construct( |
|
57 | + ModuleService $module_service, |
|
58 | + SosaRecordsService $sosa_record_service |
|
59 | + ) { |
|
60 | + $this->module = $module_service->findByInterface(SosaModule::class)->first(); |
|
61 | + $this->sosa_record_service = $sosa_record_service; |
|
62 | + } |
|
63 | + |
|
64 | + /** |
|
65 | + * {@inheritDoc} |
|
66 | + * @see \Psr\Http\Server\RequestHandlerInterface::handle() |
|
67 | + */ |
|
68 | + public function handle(ServerRequestInterface $request): ResponseInterface |
|
69 | + { |
|
70 | + $this->layout = 'layouts/ajax'; |
|
71 | + |
|
72 | + if ($this->module === null) { |
|
73 | + throw new HttpNotFoundException(I18N::translate('The attached module could not be found.')); |
|
74 | + } |
|
75 | + |
|
76 | + $tree = Validator::attributes($request)->tree(); |
|
77 | + $user = Auth::check() ? Validator::attributes($request)->user() : new DefaultUser(); |
|
78 | + $current_gen = Validator::attributes($request)->integer('gen', 0); |
|
79 | + |
|
80 | + if ($current_gen <= 0) { |
|
81 | + return Registry::responseFactory()->response( |
|
82 | + 'Invalid generation', |
|
83 | + StatusCodeInterface::STATUS_UNPROCESSABLE_ENTITY |
|
84 | + ); |
|
85 | + } |
|
86 | + |
|
87 | + $list_ancestors = $this->sosa_record_service->listAncestorsAtGeneration($tree, $user, $current_gen); |
|
88 | + $nb_ancestors_all = $list_ancestors->count(); |
|
89 | + |
|
90 | + /** @var \Illuminate\Support\Collection<int, \Fisharebest\Webtrees\Individual> $list_ancestors */ |
|
91 | + $list_ancestors = $list_ancestors |
|
92 | + ->filter(function (stdClass $value) use ($tree): bool { |
|
93 | + $indi = Registry::individualFactory()->make($value->majs_i_id, $tree); |
|
94 | + return $indi !== null && $indi->canShowName(); |
|
95 | + }) |
|
96 | + ->mapWithKeys(function (stdClass $value) use ($tree): array { |
|
97 | + $indi = Registry::individualFactory()->make($value->majs_i_id, $tree); |
|
98 | + return [(int) $value->majs_sosa => $indi]; |
|
99 | + }); |
|
100 | + |
|
101 | + $nb_ancestors_shown = $list_ancestors->count(); |
|
102 | + |
|
103 | + return $this->viewResponse($this->module->name() . '::list-ancestors-indi-tab', [ |
|
104 | + 'module_name' => $this->module->name(), |
|
105 | + 'title' => I18N::translate('Sosa Ancestors'), |
|
106 | + 'tree' => $tree, |
|
107 | + 'list_ancestors' => $list_ancestors, |
|
108 | + 'nb_ancestors_all' => $nb_ancestors_all, |
|
109 | + 'nb_ancestors_theor' => pow(2, $current_gen - 1), |
|
110 | + 'nb_ancestors_shown' => $nb_ancestors_shown |
|
111 | + ]); |
|
112 | + } |
|
113 | 113 | } |
@@ -35,78 +35,78 @@ |
||
35 | 35 | */ |
36 | 36 | class AncestorsListFamily implements RequestHandlerInterface |
37 | 37 | { |
38 | - use ViewResponseTrait; |
|
39 | - |
|
40 | - /** |
|
41 | - * @var SosaModule|null $module |
|
42 | - */ |
|
43 | - private $module; |
|
44 | - |
|
45 | - /** |
|
46 | - * @var SosaRecordsService $sosa_record_service |
|
47 | - */ |
|
48 | - private $sosa_record_service; |
|
49 | - |
|
50 | - /** |
|
51 | - * Constructor for AncestorsListFamily Request Handler |
|
52 | - * |
|
53 | - * @param ModuleService $module_service |
|
54 | - * @param SosaRecordsService $sosa_record_service |
|
55 | - */ |
|
56 | - public function __construct( |
|
57 | - ModuleService $module_service, |
|
58 | - SosaRecordsService $sosa_record_service |
|
59 | - ) { |
|
60 | - $this->module = $module_service->findByInterface(SosaModule::class)->first(); |
|
61 | - $this->sosa_record_service = $sosa_record_service; |
|
62 | - } |
|
63 | - |
|
64 | - /** |
|
65 | - * {@inheritDoc} |
|
66 | - * @see \Psr\Http\Server\RequestHandlerInterface::handle() |
|
67 | - */ |
|
68 | - public function handle(ServerRequestInterface $request): ResponseInterface |
|
69 | - { |
|
70 | - $this->layout = 'layouts/ajax'; |
|
71 | - |
|
72 | - if ($this->module === null) { |
|
73 | - throw new HttpNotFoundException(I18N::translate('The attached module could not be found.')); |
|
74 | - } |
|
75 | - |
|
76 | - $tree = Validator::attributes($request)->tree(); |
|
77 | - $user = Auth::check() ? Validator::attributes($request)->user() : new DefaultUser(); |
|
78 | - $current_gen = Validator::attributes($request)->integer('gen', 0); |
|
79 | - |
|
80 | - if ($current_gen <= 0) { |
|
81 | - return Registry::responseFactory()->response( |
|
82 | - 'Invalid generation', |
|
83 | - StatusCodeInterface::STATUS_UNPROCESSABLE_ENTITY |
|
84 | - ); |
|
85 | - } |
|
86 | - |
|
87 | - $list_families = $this->sosa_record_service->listAncestorFamiliesAtGeneration($tree, $user, $current_gen); |
|
88 | - $nb_families_all = $list_families->count(); |
|
89 | - |
|
90 | - /** @var \Illuminate\Support\Collection<int, \Fisharebest\Webtrees\Family> $list_families */ |
|
91 | - $list_families = $list_families |
|
92 | - ->filter(function (stdClass $value) use ($tree): bool { |
|
93 | - $fam = Registry::familyFactory()->make($value->f_id, $tree); |
|
94 | - return $fam !== null && $fam->canShow(); |
|
95 | - }) |
|
96 | - ->mapWithKeys(function (stdClass $value) use ($tree): array { |
|
97 | - $fam = Registry::familyFactory()->make($value->f_id, $tree); |
|
98 | - return [(int) $value->majs_sosa => $fam]; |
|
99 | - }); |
|
100 | - |
|
101 | - $nb_families_shown = $list_families->count(); |
|
102 | - |
|
103 | - return $this->viewResponse($this->module->name() . '::list-ancestors-fam-tab', [ |
|
104 | - 'module_name' => $this->module->name(), |
|
105 | - 'title' => I18N::translate('Sosa Ancestors'), |
|
106 | - 'tree' => $tree, |
|
107 | - 'list_families' => $list_families, |
|
108 | - 'nb_families_all' => $nb_families_all, |
|
109 | - 'nb_families_shown' => $nb_families_shown |
|
110 | - ]); |
|
111 | - } |
|
38 | + use ViewResponseTrait; |
|
39 | + |
|
40 | + /** |
|
41 | + * @var SosaModule|null $module |
|
42 | + */ |
|
43 | + private $module; |
|
44 | + |
|
45 | + /** |
|
46 | + * @var SosaRecordsService $sosa_record_service |
|
47 | + */ |
|
48 | + private $sosa_record_service; |
|
49 | + |
|
50 | + /** |
|
51 | + * Constructor for AncestorsListFamily Request Handler |
|
52 | + * |
|
53 | + * @param ModuleService $module_service |
|
54 | + * @param SosaRecordsService $sosa_record_service |
|
55 | + */ |
|
56 | + public function __construct( |
|
57 | + ModuleService $module_service, |
|
58 | + SosaRecordsService $sosa_record_service |
|
59 | + ) { |
|
60 | + $this->module = $module_service->findByInterface(SosaModule::class)->first(); |
|
61 | + $this->sosa_record_service = $sosa_record_service; |
|
62 | + } |
|
63 | + |
|
64 | + /** |
|
65 | + * {@inheritDoc} |
|
66 | + * @see \Psr\Http\Server\RequestHandlerInterface::handle() |
|
67 | + */ |
|
68 | + public function handle(ServerRequestInterface $request): ResponseInterface |
|
69 | + { |
|
70 | + $this->layout = 'layouts/ajax'; |
|
71 | + |
|
72 | + if ($this->module === null) { |
|
73 | + throw new HttpNotFoundException(I18N::translate('The attached module could not be found.')); |
|
74 | + } |
|
75 | + |
|
76 | + $tree = Validator::attributes($request)->tree(); |
|
77 | + $user = Auth::check() ? Validator::attributes($request)->user() : new DefaultUser(); |
|
78 | + $current_gen = Validator::attributes($request)->integer('gen', 0); |
|
79 | + |
|
80 | + if ($current_gen <= 0) { |
|
81 | + return Registry::responseFactory()->response( |
|
82 | + 'Invalid generation', |
|
83 | + StatusCodeInterface::STATUS_UNPROCESSABLE_ENTITY |
|
84 | + ); |
|
85 | + } |
|
86 | + |
|
87 | + $list_families = $this->sosa_record_service->listAncestorFamiliesAtGeneration($tree, $user, $current_gen); |
|
88 | + $nb_families_all = $list_families->count(); |
|
89 | + |
|
90 | + /** @var \Illuminate\Support\Collection<int, \Fisharebest\Webtrees\Family> $list_families */ |
|
91 | + $list_families = $list_families |
|
92 | + ->filter(function (stdClass $value) use ($tree): bool { |
|
93 | + $fam = Registry::familyFactory()->make($value->f_id, $tree); |
|
94 | + return $fam !== null && $fam->canShow(); |
|
95 | + }) |
|
96 | + ->mapWithKeys(function (stdClass $value) use ($tree): array { |
|
97 | + $fam = Registry::familyFactory()->make($value->f_id, $tree); |
|
98 | + return [(int) $value->majs_sosa => $fam]; |
|
99 | + }); |
|
100 | + |
|
101 | + $nb_families_shown = $list_families->count(); |
|
102 | + |
|
103 | + return $this->viewResponse($this->module->name() . '::list-ancestors-fam-tab', [ |
|
104 | + 'module_name' => $this->module->name(), |
|
105 | + 'title' => I18N::translate('Sosa Ancestors'), |
|
106 | + 'tree' => $tree, |
|
107 | + 'list_families' => $list_families, |
|
108 | + 'nb_families_all' => $nb_families_all, |
|
109 | + 'nb_families_shown' => $nb_families_shown |
|
110 | + ]); |
|
111 | + } |
|
112 | 112 | } |
@@ -33,49 +33,49 @@ |
||
33 | 33 | */ |
34 | 34 | class PedigreeCollapseData implements RequestHandlerInterface |
35 | 35 | { |
36 | - /** |
|
37 | - * @var SosaModule|null $module |
|
38 | - */ |
|
39 | - private $module; |
|
36 | + /** |
|
37 | + * @var SosaModule|null $module |
|
38 | + */ |
|
39 | + private $module; |
|
40 | 40 | |
41 | - /** |
|
42 | - * Constructor for PedigreeCollapseData Request Handler |
|
43 | - * |
|
44 | - * @param ModuleService $module_service |
|
45 | - */ |
|
46 | - public function __construct(ModuleService $module_service) |
|
47 | - { |
|
48 | - $this->module = $module_service->findByInterface(SosaModule::class)->first(); |
|
49 | - } |
|
41 | + /** |
|
42 | + * Constructor for PedigreeCollapseData Request Handler |
|
43 | + * |
|
44 | + * @param ModuleService $module_service |
|
45 | + */ |
|
46 | + public function __construct(ModuleService $module_service) |
|
47 | + { |
|
48 | + $this->module = $module_service->findByInterface(SosaModule::class)->first(); |
|
49 | + } |
|
50 | 50 | |
51 | - /** |
|
52 | - * {@inheritDoc} |
|
53 | - * @see \Psr\Http\Server\RequestHandlerInterface::handle() |
|
54 | - */ |
|
55 | - public function handle(ServerRequestInterface $request): ResponseInterface |
|
56 | - { |
|
57 | - if ($this->module === null) { |
|
58 | - throw new HttpNotFoundException(I18N::translate('The attached module could not be found.')); |
|
59 | - } |
|
51 | + /** |
|
52 | + * {@inheritDoc} |
|
53 | + * @see \Psr\Http\Server\RequestHandlerInterface::handle() |
|
54 | + */ |
|
55 | + public function handle(ServerRequestInterface $request): ResponseInterface |
|
56 | + { |
|
57 | + if ($this->module === null) { |
|
58 | + throw new HttpNotFoundException(I18N::translate('The attached module could not be found.')); |
|
59 | + } |
|
60 | 60 | |
61 | - $tree = Validator::attributes($request)->tree(); |
|
62 | - $user = Auth::check() ? Validator::attributes($request)->user() : new DefaultUser(); |
|
61 | + $tree = Validator::attributes($request)->tree(); |
|
62 | + $user = Auth::check() ? Validator::attributes($request)->user() : new DefaultUser(); |
|
63 | 63 | |
64 | - /** @var SosaStatisticsService $sosa_stats_service */ |
|
65 | - $sosa_stats_service = app()->makeWith(SosaStatisticsService::class, ['tree' => $tree, 'user' => $user]); |
|
66 | - $pedi_collapse_data = $sosa_stats_service->pedigreeCollapseByGenerationData(); |
|
64 | + /** @var SosaStatisticsService $sosa_stats_service */ |
|
65 | + $sosa_stats_service = app()->makeWith(SosaStatisticsService::class, ['tree' => $tree, 'user' => $user]); |
|
66 | + $pedi_collapse_data = $sosa_stats_service->pedigreeCollapseByGenerationData(); |
|
67 | 67 | |
68 | - $response = [ 'cells' => [] ]; |
|
69 | - $last_pedi_collapse = 0; |
|
70 | - foreach ($pedi_collapse_data as $gen => $rec) { |
|
71 | - $response['cells'][$gen] = view($this->module->name() . '::components/pedigree-collapse-cell', [ |
|
72 | - 'pedi_collapse_roots' => $rec['pedi_collapse_roots'], |
|
73 | - 'pedi_collapse_xgen' => $rec['pedi_collapse_xgen'] |
|
74 | - ]); |
|
75 | - $last_pedi_collapse = $rec['pedi_collapse_roots']; |
|
76 | - } |
|
77 | - $response['pedi_collapse'] = I18N::percentage($last_pedi_collapse, 2); |
|
68 | + $response = [ 'cells' => [] ]; |
|
69 | + $last_pedi_collapse = 0; |
|
70 | + foreach ($pedi_collapse_data as $gen => $rec) { |
|
71 | + $response['cells'][$gen] = view($this->module->name() . '::components/pedigree-collapse-cell', [ |
|
72 | + 'pedi_collapse_roots' => $rec['pedi_collapse_roots'], |
|
73 | + 'pedi_collapse_xgen' => $rec['pedi_collapse_xgen'] |
|
74 | + ]); |
|
75 | + $last_pedi_collapse = $rec['pedi_collapse_roots']; |
|
76 | + } |
|
77 | + $response['pedi_collapse'] = I18N::percentage($last_pedi_collapse, 2); |
|
78 | 78 | |
79 | - return Registry::responseFactory()->response($response); |
|
80 | - } |
|
79 | + return Registry::responseFactory()->response($response); |
|
80 | + } |
|
81 | 81 | } |
@@ -32,101 +32,101 @@ |
||
32 | 32 | */ |
33 | 33 | class SosaByGenerationGeoAnalysis implements GeoAnalysisInterface |
34 | 34 | { |
35 | - private SosaRecordsService $records_service; |
|
36 | - |
|
37 | - /** |
|
38 | - * Constructor for SosaByGenerationGeoAnalysis |
|
39 | - * |
|
40 | - * @param SosaRecordsService $records_service |
|
41 | - */ |
|
42 | - public function __construct(SosaRecordsService $records_service) |
|
43 | - { |
|
44 | - $this->records_service = $records_service; |
|
45 | - } |
|
46 | - |
|
47 | - /** |
|
48 | - * {@inheritDoc} |
|
49 | - * @see \MyArtJaub\Webtrees\Contracts\GeoDispersion\GeoAnalysisInterface::title() |
|
50 | - */ |
|
51 | - public function title(): string |
|
52 | - { |
|
53 | - return I18N::translate('Sosa ancestors places by generation'); |
|
54 | - } |
|
55 | - |
|
56 | - /** |
|
57 | - * {@inheritDoc} |
|
58 | - * @see \MyArtJaub\Webtrees\Contracts\GeoDispersion\GeoAnalysisInterface::itemsDescription() |
|
59 | - */ |
|
60 | - public function itemsDescription(): callable |
|
61 | - { |
|
62 | - return fn(int $count): string => I18N::plural('ancestor', 'ancestors', $count); |
|
63 | - } |
|
64 | - |
|
65 | - /** |
|
66 | - * {@inheritDoc} |
|
67 | - * @see \MyArtJaub\Webtrees\Contracts\GeoDispersion\GeoAnalysisInterface::results() |
|
68 | - */ |
|
69 | - public function results(Tree $tree, int $depth): GeoAnalysisResults |
|
70 | - { |
|
71 | - $results = new GeoAnalysisResults(); |
|
72 | - |
|
73 | - $unique_ancestors = $this->records_service |
|
74 | - ->listAncestors($tree, Auth::check() ? Auth::user() : new DefaultUser()) |
|
75 | - ->uniqueStrict(fn(stdClass $item): string => $item->majs_i_id); |
|
76 | - |
|
77 | - foreach ($unique_ancestors as $item) { |
|
78 | - $ancestor = Registry::individualFactory()->make($item->majs_i_id, $tree); |
|
79 | - if ($ancestor === null || !$ancestor->canShow()) { |
|
80 | - continue; |
|
81 | - } |
|
82 | - $generation = $this->records_service->generation((int) $item->majs_sosa); |
|
83 | - $significantplace = new GeoAnalysisPlace($tree, null, $depth); |
|
84 | - foreach ($this->significantPlaces($ancestor) as $place) { |
|
85 | - $significantplace = new GeoAnalysisPlace($tree, $place, $depth, true); |
|
86 | - if ($significantplace->isKnown()) { |
|
87 | - break; |
|
88 | - } |
|
89 | - } |
|
90 | - $results->addPlace($significantplace); |
|
91 | - $results->addPlaceInCategory( |
|
92 | - I18N::translate('Generation %s', I18N::number($generation)), |
|
93 | - $generation, |
|
94 | - $significantplace |
|
95 | - ); |
|
96 | - } |
|
97 | - |
|
98 | - return $results; |
|
99 | - } |
|
100 | - |
|
101 | - /** |
|
102 | - * Returns significant places in order of priority for an individual |
|
103 | - * |
|
104 | - * @param Individual $individual |
|
105 | - * @return Generator<\Fisharebest\Webtrees\Place> |
|
106 | - */ |
|
107 | - protected function significantPlaces(Individual $individual): Generator |
|
108 | - { |
|
109 | - yield $individual->getBirthPlace(); |
|
110 | - |
|
111 | - /** @var \Fisharebest\Webtrees\Fact $fact */ |
|
112 | - foreach ($individual->facts(['RESI']) as $fact) { |
|
113 | - yield $fact->place(); |
|
114 | - } |
|
115 | - |
|
116 | - yield $individual->getDeathPlace(); |
|
117 | - |
|
118 | - /** @var \Fisharebest\Webtrees\Family $family */ |
|
119 | - foreach ($individual->childFamilies() as $family) { |
|
120 | - foreach ($family->facts(['RESI']) as $fact) { |
|
121 | - yield $fact->place(); |
|
122 | - } |
|
123 | - } |
|
124 | - |
|
125 | - /** @var \Fisharebest\Webtrees\Family $family */ |
|
126 | - foreach ($individual->spouseFamilies() as $family) { |
|
127 | - foreach ($family->facts(['RESI']) as $fact) { |
|
128 | - yield $fact->place(); |
|
129 | - } |
|
130 | - } |
|
131 | - } |
|
35 | + private SosaRecordsService $records_service; |
|
36 | + |
|
37 | + /** |
|
38 | + * Constructor for SosaByGenerationGeoAnalysis |
|
39 | + * |
|
40 | + * @param SosaRecordsService $records_service |
|
41 | + */ |
|
42 | + public function __construct(SosaRecordsService $records_service) |
|
43 | + { |
|
44 | + $this->records_service = $records_service; |
|
45 | + } |
|
46 | + |
|
47 | + /** |
|
48 | + * {@inheritDoc} |
|
49 | + * @see \MyArtJaub\Webtrees\Contracts\GeoDispersion\GeoAnalysisInterface::title() |
|
50 | + */ |
|
51 | + public function title(): string |
|
52 | + { |
|
53 | + return I18N::translate('Sosa ancestors places by generation'); |
|
54 | + } |
|
55 | + |
|
56 | + /** |
|
57 | + * {@inheritDoc} |
|
58 | + * @see \MyArtJaub\Webtrees\Contracts\GeoDispersion\GeoAnalysisInterface::itemsDescription() |
|
59 | + */ |
|
60 | + public function itemsDescription(): callable |
|
61 | + { |
|
62 | + return fn(int $count): string => I18N::plural('ancestor', 'ancestors', $count); |
|
63 | + } |
|
64 | + |
|
65 | + /** |
|
66 | + * {@inheritDoc} |
|
67 | + * @see \MyArtJaub\Webtrees\Contracts\GeoDispersion\GeoAnalysisInterface::results() |
|
68 | + */ |
|
69 | + public function results(Tree $tree, int $depth): GeoAnalysisResults |
|
70 | + { |
|
71 | + $results = new GeoAnalysisResults(); |
|
72 | + |
|
73 | + $unique_ancestors = $this->records_service |
|
74 | + ->listAncestors($tree, Auth::check() ? Auth::user() : new DefaultUser()) |
|
75 | + ->uniqueStrict(fn(stdClass $item): string => $item->majs_i_id); |
|
76 | + |
|
77 | + foreach ($unique_ancestors as $item) { |
|
78 | + $ancestor = Registry::individualFactory()->make($item->majs_i_id, $tree); |
|
79 | + if ($ancestor === null || !$ancestor->canShow()) { |
|
80 | + continue; |
|
81 | + } |
|
82 | + $generation = $this->records_service->generation((int) $item->majs_sosa); |
|
83 | + $significantplace = new GeoAnalysisPlace($tree, null, $depth); |
|
84 | + foreach ($this->significantPlaces($ancestor) as $place) { |
|
85 | + $significantplace = new GeoAnalysisPlace($tree, $place, $depth, true); |
|
86 | + if ($significantplace->isKnown()) { |
|
87 | + break; |
|
88 | + } |
|
89 | + } |
|
90 | + $results->addPlace($significantplace); |
|
91 | + $results->addPlaceInCategory( |
|
92 | + I18N::translate('Generation %s', I18N::number($generation)), |
|
93 | + $generation, |
|
94 | + $significantplace |
|
95 | + ); |
|
96 | + } |
|
97 | + |
|
98 | + return $results; |
|
99 | + } |
|
100 | + |
|
101 | + /** |
|
102 | + * Returns significant places in order of priority for an individual |
|
103 | + * |
|
104 | + * @param Individual $individual |
|
105 | + * @return Generator<\Fisharebest\Webtrees\Place> |
|
106 | + */ |
|
107 | + protected function significantPlaces(Individual $individual): Generator |
|
108 | + { |
|
109 | + yield $individual->getBirthPlace(); |
|
110 | + |
|
111 | + /** @var \Fisharebest\Webtrees\Fact $fact */ |
|
112 | + foreach ($individual->facts(['RESI']) as $fact) { |
|
113 | + yield $fact->place(); |
|
114 | + } |
|
115 | + |
|
116 | + yield $individual->getDeathPlace(); |
|
117 | + |
|
118 | + /** @var \Fisharebest\Webtrees\Family $family */ |
|
119 | + foreach ($individual->childFamilies() as $family) { |
|
120 | + foreach ($family->facts(['RESI']) as $fact) { |
|
121 | + yield $fact->place(); |
|
122 | + } |
|
123 | + } |
|
124 | + |
|
125 | + /** @var \Fisharebest\Webtrees\Family $family */ |
|
126 | + foreach ($individual->spouseFamilies() as $family) { |
|
127 | + foreach ($family->facts(['RESI']) as $fact) { |
|
128 | + yield $fact->place(); |
|
129 | + } |
|
130 | + } |
|
131 | + } |
|
132 | 132 | } |
@@ -30,291 +30,291 @@ |
||
30 | 30 | */ |
31 | 31 | class SosaRecordsService |
32 | 32 | { |
33 | - private ?int $max_system_generations = null; |
|
33 | + private ?int $max_system_generations = null; |
|
34 | 34 | |
35 | - /** |
|
36 | - * Maximum number of generation the system is able to hold. |
|
37 | - * This is based on the size of the bigint SQL type (2^63) and the maximum PHP integer type |
|
38 | - * |
|
39 | - * @return int |
|
40 | - */ |
|
41 | - public function maxSystemGenerations(): int |
|
42 | - { |
|
43 | - if ($this->max_system_generations === null) { |
|
44 | - $this->max_system_generations = min(63, $this->generation(PHP_INT_MAX)); |
|
45 | - } |
|
46 | - return $this->max_system_generations; |
|
47 | - } |
|
35 | + /** |
|
36 | + * Maximum number of generation the system is able to hold. |
|
37 | + * This is based on the size of the bigint SQL type (2^63) and the maximum PHP integer type |
|
38 | + * |
|
39 | + * @return int |
|
40 | + */ |
|
41 | + public function maxSystemGenerations(): int |
|
42 | + { |
|
43 | + if ($this->max_system_generations === null) { |
|
44 | + $this->max_system_generations = min(63, $this->generation(PHP_INT_MAX)); |
|
45 | + } |
|
46 | + return $this->max_system_generations; |
|
47 | + } |
|
48 | 48 | |
49 | - /** |
|
50 | - * Calculate the generation of a sosa |
|
51 | - * Sosa 1 is of generation 1. |
|
52 | - * |
|
53 | - * @param int $sosa |
|
54 | - * @return int |
|
55 | - */ |
|
56 | - public function generation(int $sosa): int |
|
57 | - { |
|
58 | - return BigInteger::of($sosa)->getBitLength(); |
|
59 | - } |
|
49 | + /** |
|
50 | + * Calculate the generation of a sosa |
|
51 | + * Sosa 1 is of generation 1. |
|
52 | + * |
|
53 | + * @param int $sosa |
|
54 | + * @return int |
|
55 | + */ |
|
56 | + public function generation(int $sosa): int |
|
57 | + { |
|
58 | + return BigInteger::of($sosa)->getBitLength(); |
|
59 | + } |
|
60 | 60 | |
61 | - /** |
|
62 | - * Calculate the descendant sosa of the given sosa, at the given generation. |
|
63 | - * For instance, the descendant of the Sosa 14 at generation 2 is Sosa 3 (mother). |
|
64 | - * |
|
65 | - * @param int $sosa |
|
66 | - * @param int $gen |
|
67 | - * @return int |
|
68 | - */ |
|
69 | - public function sosaDescendantOf(int $sosa, int $gen): int |
|
70 | - { |
|
71 | - $gen_sosa = $this->generation($sosa); |
|
72 | - return $gen_sosa <= $gen ? $sosa : BigInteger::of($sosa) |
|
73 | - ->dividedBy(BigInteger::of(2)->power($this->generation($sosa) - $gen), RoundingMode::DOWN) |
|
74 | - ->toInt(); |
|
75 | - } |
|
61 | + /** |
|
62 | + * Calculate the descendant sosa of the given sosa, at the given generation. |
|
63 | + * For instance, the descendant of the Sosa 14 at generation 2 is Sosa 3 (mother). |
|
64 | + * |
|
65 | + * @param int $sosa |
|
66 | + * @param int $gen |
|
67 | + * @return int |
|
68 | + */ |
|
69 | + public function sosaDescendantOf(int $sosa, int $gen): int |
|
70 | + { |
|
71 | + $gen_sosa = $this->generation($sosa); |
|
72 | + return $gen_sosa <= $gen ? $sosa : BigInteger::of($sosa) |
|
73 | + ->dividedBy(BigInteger::of(2)->power($this->generation($sosa) - $gen), RoundingMode::DOWN) |
|
74 | + ->toInt(); |
|
75 | + } |
|
76 | 76 | |
77 | - /** |
|
78 | - * Check whether an individual is a Sosa ancestor. |
|
79 | - * |
|
80 | - * @param Tree $tree |
|
81 | - * @param UserInterface $user |
|
82 | - * @param Individual $indi |
|
83 | - * @return bool |
|
84 | - */ |
|
85 | - public function isSosa(Tree $tree, UserInterface $user, Individual $indi): bool |
|
86 | - { |
|
87 | - return $this->sosaNumbers($tree, $user, $indi)->count() > 0; |
|
88 | - } |
|
77 | + /** |
|
78 | + * Check whether an individual is a Sosa ancestor. |
|
79 | + * |
|
80 | + * @param Tree $tree |
|
81 | + * @param UserInterface $user |
|
82 | + * @param Individual $indi |
|
83 | + * @return bool |
|
84 | + */ |
|
85 | + public function isSosa(Tree $tree, UserInterface $user, Individual $indi): bool |
|
86 | + { |
|
87 | + return $this->sosaNumbers($tree, $user, $indi)->count() > 0; |
|
88 | + } |
|
89 | 89 | |
90 | - /** |
|
91 | - * Returns all Sosa numbers associated to an Individual |
|
92 | - * |
|
93 | - * @param Tree $tree |
|
94 | - * @param UserInterface $user |
|
95 | - * @param Individual $indi |
|
96 | - * @return Collection<int, int> |
|
97 | - */ |
|
98 | - public function sosaNumbers(Tree $tree, UserInterface $user, Individual $indi): Collection |
|
99 | - { |
|
100 | - return Registry::cache()->array()->remember( |
|
101 | - 'sosanumbers-' . $indi->xref() . '@' . $tree->id() . '-' . $user->id(), |
|
102 | - function () use ($tree, $user, $indi): Collection { |
|
103 | - return DB::table('maj_sosa') |
|
104 | - ->select(['majs_sosa', 'majs_gen']) |
|
105 | - ->where('majs_gedcom_id', '=', $tree->id()) |
|
106 | - ->where('majs_user_id', '=', $user->id()) |
|
107 | - ->where('majs_i_id', '=', $indi->xref()) |
|
108 | - ->orderBy('majs_sosa') |
|
109 | - ->get()->pluck('majs_gen', 'majs_sosa'); |
|
110 | - } |
|
111 | - ); |
|
112 | - } |
|
90 | + /** |
|
91 | + * Returns all Sosa numbers associated to an Individual |
|
92 | + * |
|
93 | + * @param Tree $tree |
|
94 | + * @param UserInterface $user |
|
95 | + * @param Individual $indi |
|
96 | + * @return Collection<int, int> |
|
97 | + */ |
|
98 | + public function sosaNumbers(Tree $tree, UserInterface $user, Individual $indi): Collection |
|
99 | + { |
|
100 | + return Registry::cache()->array()->remember( |
|
101 | + 'sosanumbers-' . $indi->xref() . '@' . $tree->id() . '-' . $user->id(), |
|
102 | + function () use ($tree, $user, $indi): Collection { |
|
103 | + return DB::table('maj_sosa') |
|
104 | + ->select(['majs_sosa', 'majs_gen']) |
|
105 | + ->where('majs_gedcom_id', '=', $tree->id()) |
|
106 | + ->where('majs_user_id', '=', $user->id()) |
|
107 | + ->where('majs_i_id', '=', $indi->xref()) |
|
108 | + ->orderBy('majs_sosa') |
|
109 | + ->get()->pluck('majs_gen', 'majs_sosa'); |
|
110 | + } |
|
111 | + ); |
|
112 | + } |
|
113 | 113 | |
114 | - /** |
|
115 | - * Return a list of the Sosa ancestors across all generation |
|
116 | - * |
|
117 | - * @param Tree $tree |
|
118 | - * @param UserInterface $user |
|
119 | - * @return Collection<\stdClass> |
|
120 | - */ |
|
121 | - public function listAncestors(Tree $tree, UserInterface $user): Collection |
|
122 | - { |
|
123 | - return DB::table('maj_sosa') |
|
124 | - ->select(['majs_sosa', 'majs_i_id']) |
|
125 | - ->where('majs_gedcom_id', '=', $tree->id()) |
|
126 | - ->where('majs_user_id', '=', $user->id()) |
|
127 | - ->orderBy('majs_sosa') |
|
128 | - ->get(); |
|
129 | - } |
|
114 | + /** |
|
115 | + * Return a list of the Sosa ancestors across all generation |
|
116 | + * |
|
117 | + * @param Tree $tree |
|
118 | + * @param UserInterface $user |
|
119 | + * @return Collection<\stdClass> |
|
120 | + */ |
|
121 | + public function listAncestors(Tree $tree, UserInterface $user): Collection |
|
122 | + { |
|
123 | + return DB::table('maj_sosa') |
|
124 | + ->select(['majs_sosa', 'majs_i_id']) |
|
125 | + ->where('majs_gedcom_id', '=', $tree->id()) |
|
126 | + ->where('majs_user_id', '=', $user->id()) |
|
127 | + ->orderBy('majs_sosa') |
|
128 | + ->get(); |
|
129 | + } |
|
130 | 130 | |
131 | - /** |
|
132 | - * Return a list of the Sosa ancestors at a given generation |
|
133 | - * |
|
134 | - * @param Tree $tree |
|
135 | - * @param UserInterface $user |
|
136 | - * @param int $gen |
|
137 | - * @return Collection<\stdClass> |
|
138 | - */ |
|
139 | - public function listAncestorsAtGeneration(Tree $tree, UserInterface $user, int $gen): Collection |
|
140 | - { |
|
141 | - return DB::table('maj_sosa') |
|
142 | - ->select(['majs_sosa', 'majs_i_id']) |
|
143 | - ->where('majs_gedcom_id', '=', $tree->id()) |
|
144 | - ->where('majs_user_id', '=', $user->id()) |
|
145 | - ->where('majs_gen', '=', $gen) |
|
146 | - ->orderBy('majs_sosa') |
|
147 | - ->get(); |
|
148 | - } |
|
131 | + /** |
|
132 | + * Return a list of the Sosa ancestors at a given generation |
|
133 | + * |
|
134 | + * @param Tree $tree |
|
135 | + * @param UserInterface $user |
|
136 | + * @param int $gen |
|
137 | + * @return Collection<\stdClass> |
|
138 | + */ |
|
139 | + public function listAncestorsAtGeneration(Tree $tree, UserInterface $user, int $gen): Collection |
|
140 | + { |
|
141 | + return DB::table('maj_sosa') |
|
142 | + ->select(['majs_sosa', 'majs_i_id']) |
|
143 | + ->where('majs_gedcom_id', '=', $tree->id()) |
|
144 | + ->where('majs_user_id', '=', $user->id()) |
|
145 | + ->where('majs_gen', '=', $gen) |
|
146 | + ->orderBy('majs_sosa') |
|
147 | + ->get(); |
|
148 | + } |
|
149 | 149 | |
150 | - /** |
|
151 | - * Return a list of the Sosa families at a given generation |
|
152 | - * |
|
153 | - * @param Tree $tree |
|
154 | - * @param UserInterface $user |
|
155 | - * @param int $gen |
|
156 | - * @return Collection<\stdClass> |
|
157 | - */ |
|
158 | - public function listAncestorFamiliesAtGeneration(Tree $tree, UserInterface $user, int $gen): Collection |
|
159 | - { |
|
160 | - $table_prefix = DB::connection()->getTablePrefix(); |
|
161 | - return DB::table('families') |
|
162 | - ->join('maj_sosa AS sosa_husb', function (JoinClause $join) use ($tree, $user): void { |
|
163 | - // Link to family husband |
|
164 | - $join->on('families.f_file', '=', 'sosa_husb.majs_gedcom_id') |
|
165 | - ->on('families.f_husb', '=', 'sosa_husb.majs_i_id') |
|
166 | - ->where('sosa_husb.majs_gedcom_id', '=', $tree->id()) |
|
167 | - ->where('sosa_husb.majs_user_id', '=', $user->id()); |
|
168 | - }) |
|
169 | - ->join('maj_sosa AS sosa_wife', function (JoinClause $join) use ($tree, $user): void { |
|
170 | - // Link to family husband |
|
171 | - $join->on('families.f_file', '=', 'sosa_wife.majs_gedcom_id') |
|
172 | - ->on('families.f_wife', '=', 'sosa_wife.majs_i_id') |
|
173 | - ->where('sosa_wife.majs_gedcom_id', '=', $tree->id()) |
|
174 | - ->where('sosa_wife.majs_user_id', '=', $user->id()); |
|
175 | - }) |
|
176 | - ->select(['sosa_husb.majs_sosa', 'families.f_id']) |
|
177 | - ->where('sosa_husb.majs_gen', '=', $gen) |
|
178 | - ->whereRaw($table_prefix . 'sosa_husb.majs_sosa + 1 = ' . $table_prefix . 'sosa_wife.majs_sosa') |
|
179 | - ->orderBy('sosa_husb.majs_sosa') |
|
180 | - ->get(); |
|
181 | - } |
|
150 | + /** |
|
151 | + * Return a list of the Sosa families at a given generation |
|
152 | + * |
|
153 | + * @param Tree $tree |
|
154 | + * @param UserInterface $user |
|
155 | + * @param int $gen |
|
156 | + * @return Collection<\stdClass> |
|
157 | + */ |
|
158 | + public function listAncestorFamiliesAtGeneration(Tree $tree, UserInterface $user, int $gen): Collection |
|
159 | + { |
|
160 | + $table_prefix = DB::connection()->getTablePrefix(); |
|
161 | + return DB::table('families') |
|
162 | + ->join('maj_sosa AS sosa_husb', function (JoinClause $join) use ($tree, $user): void { |
|
163 | + // Link to family husband |
|
164 | + $join->on('families.f_file', '=', 'sosa_husb.majs_gedcom_id') |
|
165 | + ->on('families.f_husb', '=', 'sosa_husb.majs_i_id') |
|
166 | + ->where('sosa_husb.majs_gedcom_id', '=', $tree->id()) |
|
167 | + ->where('sosa_husb.majs_user_id', '=', $user->id()); |
|
168 | + }) |
|
169 | + ->join('maj_sosa AS sosa_wife', function (JoinClause $join) use ($tree, $user): void { |
|
170 | + // Link to family husband |
|
171 | + $join->on('families.f_file', '=', 'sosa_wife.majs_gedcom_id') |
|
172 | + ->on('families.f_wife', '=', 'sosa_wife.majs_i_id') |
|
173 | + ->where('sosa_wife.majs_gedcom_id', '=', $tree->id()) |
|
174 | + ->where('sosa_wife.majs_user_id', '=', $user->id()); |
|
175 | + }) |
|
176 | + ->select(['sosa_husb.majs_sosa', 'families.f_id']) |
|
177 | + ->where('sosa_husb.majs_gen', '=', $gen) |
|
178 | + ->whereRaw($table_prefix . 'sosa_husb.majs_sosa + 1 = ' . $table_prefix . 'sosa_wife.majs_sosa') |
|
179 | + ->orderBy('sosa_husb.majs_sosa') |
|
180 | + ->get(); |
|
181 | + } |
|
182 | 182 | |
183 | - /** |
|
184 | - * Return a list of Sosa ancestors missing at a given generation. |
|
185 | - * It includes the reference of either parent if it is known. |
|
186 | - * |
|
187 | - * @param Tree $tree |
|
188 | - * @param UserInterface $user |
|
189 | - * @param int $gen |
|
190 | - * @return Collection<\stdClass> |
|
191 | - */ |
|
192 | - public function listMissingAncestorsAtGeneration(Tree $tree, UserInterface $user, int $gen): Collection |
|
193 | - { |
|
194 | - if ($gen === 1) { |
|
195 | - return collect(); |
|
196 | - } |
|
183 | + /** |
|
184 | + * Return a list of Sosa ancestors missing at a given generation. |
|
185 | + * It includes the reference of either parent if it is known. |
|
186 | + * |
|
187 | + * @param Tree $tree |
|
188 | + * @param UserInterface $user |
|
189 | + * @param int $gen |
|
190 | + * @return Collection<\stdClass> |
|
191 | + */ |
|
192 | + public function listMissingAncestorsAtGeneration(Tree $tree, UserInterface $user, int $gen): Collection |
|
193 | + { |
|
194 | + if ($gen === 1) { |
|
195 | + return collect(); |
|
196 | + } |
|
197 | 197 | |
198 | - $table_prefix = DB::connection()->getTablePrefix(); |
|
199 | - return DB::table('maj_sosa AS sosa') |
|
200 | - ->select(['sosa.majs_i_id', 'sosa_fat.majs_i_id AS majs_fat_id', 'sosa_mot.majs_i_id AS majs_mot_id']) |
|
201 | - ->selectRaw('MIN(' . $table_prefix . 'sosa.majs_sosa) AS majs_sosa') |
|
202 | - ->leftJoin('maj_sosa AS sosa_fat', function (JoinClause $join) use ($tree, $user, $table_prefix): void { |
|
203 | - // Link to sosa's father |
|
204 | - $join->whereRaw($table_prefix . 'sosa_fat.majs_sosa = 2 * ' . $table_prefix . 'sosa.majs_sosa') |
|
205 | - ->where('sosa_fat.majs_gedcom_id', '=', $tree->id()) |
|
206 | - ->where('sosa_fat.majs_user_id', '=', $user->id()); |
|
207 | - }) |
|
208 | - ->leftJoin('maj_sosa AS sosa_mot', function (JoinClause $join) use ($tree, $user, $table_prefix): void { |
|
209 | - // Link to sosa's mother |
|
210 | - $join->whereRaw($table_prefix . 'sosa_mot.majs_sosa = 2 * ' . $table_prefix . 'sosa.majs_sosa + 1') |
|
211 | - ->where('sosa_mot.majs_gedcom_id', '=', $tree->id()) |
|
212 | - ->where('sosa_mot.majs_user_id', '=', $user->id()); |
|
213 | - }) |
|
214 | - ->where('sosa.majs_gedcom_id', '=', $tree->id()) |
|
215 | - ->where('sosa.majs_user_id', '=', $user->id()) |
|
216 | - ->where('sosa.majs_gen', '=', $gen - 1) |
|
217 | - ->where(function (Builder $query): void { |
|
218 | - $query->whereNull('sosa_fat.majs_i_id') |
|
219 | - ->orWhereNull('sosa_mot.majs_i_id'); |
|
220 | - }) |
|
221 | - ->groupBy('sosa.majs_i_id', 'sosa_fat.majs_i_id', 'sosa_mot.majs_i_id') |
|
222 | - ->orderByRaw('MIN(' . $table_prefix . 'sosa.majs_sosa)') |
|
223 | - ->get(); |
|
224 | - } |
|
198 | + $table_prefix = DB::connection()->getTablePrefix(); |
|
199 | + return DB::table('maj_sosa AS sosa') |
|
200 | + ->select(['sosa.majs_i_id', 'sosa_fat.majs_i_id AS majs_fat_id', 'sosa_mot.majs_i_id AS majs_mot_id']) |
|
201 | + ->selectRaw('MIN(' . $table_prefix . 'sosa.majs_sosa) AS majs_sosa') |
|
202 | + ->leftJoin('maj_sosa AS sosa_fat', function (JoinClause $join) use ($tree, $user, $table_prefix): void { |
|
203 | + // Link to sosa's father |
|
204 | + $join->whereRaw($table_prefix . 'sosa_fat.majs_sosa = 2 * ' . $table_prefix . 'sosa.majs_sosa') |
|
205 | + ->where('sosa_fat.majs_gedcom_id', '=', $tree->id()) |
|
206 | + ->where('sosa_fat.majs_user_id', '=', $user->id()); |
|
207 | + }) |
|
208 | + ->leftJoin('maj_sosa AS sosa_mot', function (JoinClause $join) use ($tree, $user, $table_prefix): void { |
|
209 | + // Link to sosa's mother |
|
210 | + $join->whereRaw($table_prefix . 'sosa_mot.majs_sosa = 2 * ' . $table_prefix . 'sosa.majs_sosa + 1') |
|
211 | + ->where('sosa_mot.majs_gedcom_id', '=', $tree->id()) |
|
212 | + ->where('sosa_mot.majs_user_id', '=', $user->id()); |
|
213 | + }) |
|
214 | + ->where('sosa.majs_gedcom_id', '=', $tree->id()) |
|
215 | + ->where('sosa.majs_user_id', '=', $user->id()) |
|
216 | + ->where('sosa.majs_gen', '=', $gen - 1) |
|
217 | + ->where(function (Builder $query): void { |
|
218 | + $query->whereNull('sosa_fat.majs_i_id') |
|
219 | + ->orWhereNull('sosa_mot.majs_i_id'); |
|
220 | + }) |
|
221 | + ->groupBy('sosa.majs_i_id', 'sosa_fat.majs_i_id', 'sosa_mot.majs_i_id') |
|
222 | + ->orderByRaw('MIN(' . $table_prefix . 'sosa.majs_sosa)') |
|
223 | + ->get(); |
|
224 | + } |
|
225 | 225 | |
226 | - /** |
|
227 | - * Remove all Sosa entries related to the gedcom file and user |
|
228 | - * |
|
229 | - * @param Tree $tree |
|
230 | - * @param UserInterface $user |
|
231 | - */ |
|
232 | - public function deleteAll(Tree $tree, UserInterface $user): void |
|
233 | - { |
|
234 | - DB::table('maj_sosa') |
|
235 | - ->where('majs_gedcom_id', '=', $tree->id()) |
|
236 | - ->where('majs_user_id', '=', $user->id()) |
|
237 | - ->delete(); |
|
238 | - } |
|
226 | + /** |
|
227 | + * Remove all Sosa entries related to the gedcom file and user |
|
228 | + * |
|
229 | + * @param Tree $tree |
|
230 | + * @param UserInterface $user |
|
231 | + */ |
|
232 | + public function deleteAll(Tree $tree, UserInterface $user): void |
|
233 | + { |
|
234 | + DB::table('maj_sosa') |
|
235 | + ->where('majs_gedcom_id', '=', $tree->id()) |
|
236 | + ->where('majs_user_id', '=', $user->id()) |
|
237 | + ->delete(); |
|
238 | + } |
|
239 | 239 | |
240 | - /** |
|
241 | - * |
|
242 | - * @param Tree $tree |
|
243 | - * @param UserInterface $user |
|
244 | - * @param int $sosa |
|
245 | - */ |
|
246 | - public function deleteAncestorsFrom(Tree $tree, UserInterface $user, int $sosa): void |
|
247 | - { |
|
248 | - DB::table('maj_sosa') |
|
249 | - ->where('majs_gedcom_id', '=', $tree->id()) |
|
250 | - ->where('majs_user_id', '=', $user->id()) |
|
251 | - ->where('majs_sosa', '>=', $sosa) |
|
252 | - ->whereRaw( |
|
253 | - 'FLOOR(majs_sosa / (POW(2, (majs_gen - ?)))) = ?', |
|
254 | - [$this->generation($sosa), $sosa] |
|
255 | - ) |
|
256 | - ->delete(); |
|
257 | - } |
|
240 | + /** |
|
241 | + * |
|
242 | + * @param Tree $tree |
|
243 | + * @param UserInterface $user |
|
244 | + * @param int $sosa |
|
245 | + */ |
|
246 | + public function deleteAncestorsFrom(Tree $tree, UserInterface $user, int $sosa): void |
|
247 | + { |
|
248 | + DB::table('maj_sosa') |
|
249 | + ->where('majs_gedcom_id', '=', $tree->id()) |
|
250 | + ->where('majs_user_id', '=', $user->id()) |
|
251 | + ->where('majs_sosa', '>=', $sosa) |
|
252 | + ->whereRaw( |
|
253 | + 'FLOOR(majs_sosa / (POW(2, (majs_gen - ?)))) = ?', |
|
254 | + [$this->generation($sosa), $sosa] |
|
255 | + ) |
|
256 | + ->delete(); |
|
257 | + } |
|
258 | 258 | |
259 | - /** |
|
260 | - * Insert (or update if already existing) a list of Sosa individuals |
|
261 | - * |
|
262 | - * @param Tree $tree |
|
263 | - * @param UserInterface $user |
|
264 | - * @param array<array<string,mixed>> $sosa_records |
|
265 | - */ |
|
266 | - public function insertOrUpdate(Tree $tree, UserInterface $user, array $sosa_records): void |
|
267 | - { |
|
268 | - $mass_update = DB::connection()->getDriverName() === 'mysql'; |
|
259 | + /** |
|
260 | + * Insert (or update if already existing) a list of Sosa individuals |
|
261 | + * |
|
262 | + * @param Tree $tree |
|
263 | + * @param UserInterface $user |
|
264 | + * @param array<array<string,mixed>> $sosa_records |
|
265 | + */ |
|
266 | + public function insertOrUpdate(Tree $tree, UserInterface $user, array $sosa_records): void |
|
267 | + { |
|
268 | + $mass_update = DB::connection()->getDriverName() === 'mysql'; |
|
269 | 269 | |
270 | - $bindings_placeholders = $bindings_values = []; |
|
271 | - $has_records = false; |
|
272 | - foreach ($sosa_records as $i => $row) { |
|
273 | - $gen = $this->generation($row['sosa']); |
|
274 | - if ($gen <= $this->maxSystemGenerations()) { |
|
275 | - $has_records = true; |
|
276 | - if ($mass_update) { |
|
277 | - $bindings_placeholders[] = '(:tree_id' . $i . ', :user_id' . $i . ', :sosa' . $i . ',' . |
|
278 | - ' :indi_id' . $i . ', :gen' . $i . ',' . |
|
279 | - ' :byear' . $i . ', :byearest' . $i . ', :dyear' . $i . ', :dyearest' . $i . ')'; |
|
280 | - $bindings_values += [ |
|
281 | - 'tree_id' . $i => $tree->id(), |
|
282 | - 'user_id' . $i => $user->id(), |
|
283 | - 'sosa' . $i => $row['sosa'], |
|
284 | - 'indi_id' . $i => $row['indi'], |
|
285 | - 'gen' . $i => $gen, |
|
286 | - 'byear' . $i => $row['birth_year'], |
|
287 | - 'byearest' . $i => $row['birth_year_est'], |
|
288 | - 'dyear' . $i => $row['death_year'], |
|
289 | - 'dyearest' . $i => $row['death_year_est'] |
|
290 | - ]; |
|
291 | - } else { |
|
292 | - DB::table('maj_sosa')->updateOrInsert( |
|
293 | - [ 'majs_gedcom_id' => $tree->id(), 'majs_user_id' => $user->id(), 'majs_sosa' => $row['sosa']], |
|
294 | - [ |
|
295 | - 'majs_i_id' => $row['indi'], |
|
296 | - 'majs_gen' => $gen, |
|
297 | - 'majs_birth_year' => $row['birth_year'], |
|
298 | - 'majs_birth_year_est' => $row['birth_year_est'], |
|
299 | - 'majs_death_year' => $row['death_year'], |
|
300 | - 'majs_death_year_est' => $row['death_year_est'] |
|
301 | - ] |
|
302 | - ); |
|
303 | - } |
|
304 | - } |
|
305 | - } |
|
270 | + $bindings_placeholders = $bindings_values = []; |
|
271 | + $has_records = false; |
|
272 | + foreach ($sosa_records as $i => $row) { |
|
273 | + $gen = $this->generation($row['sosa']); |
|
274 | + if ($gen <= $this->maxSystemGenerations()) { |
|
275 | + $has_records = true; |
|
276 | + if ($mass_update) { |
|
277 | + $bindings_placeholders[] = '(:tree_id' . $i . ', :user_id' . $i . ', :sosa' . $i . ',' . |
|
278 | + ' :indi_id' . $i . ', :gen' . $i . ',' . |
|
279 | + ' :byear' . $i . ', :byearest' . $i . ', :dyear' . $i . ', :dyearest' . $i . ')'; |
|
280 | + $bindings_values += [ |
|
281 | + 'tree_id' . $i => $tree->id(), |
|
282 | + 'user_id' . $i => $user->id(), |
|
283 | + 'sosa' . $i => $row['sosa'], |
|
284 | + 'indi_id' . $i => $row['indi'], |
|
285 | + 'gen' . $i => $gen, |
|
286 | + 'byear' . $i => $row['birth_year'], |
|
287 | + 'byearest' . $i => $row['birth_year_est'], |
|
288 | + 'dyear' . $i => $row['death_year'], |
|
289 | + 'dyearest' . $i => $row['death_year_est'] |
|
290 | + ]; |
|
291 | + } else { |
|
292 | + DB::table('maj_sosa')->updateOrInsert( |
|
293 | + [ 'majs_gedcom_id' => $tree->id(), 'majs_user_id' => $user->id(), 'majs_sosa' => $row['sosa']], |
|
294 | + [ |
|
295 | + 'majs_i_id' => $row['indi'], |
|
296 | + 'majs_gen' => $gen, |
|
297 | + 'majs_birth_year' => $row['birth_year'], |
|
298 | + 'majs_birth_year_est' => $row['birth_year_est'], |
|
299 | + 'majs_death_year' => $row['death_year'], |
|
300 | + 'majs_death_year_est' => $row['death_year_est'] |
|
301 | + ] |
|
302 | + ); |
|
303 | + } |
|
304 | + } |
|
305 | + } |
|
306 | 306 | |
307 | - if ($has_records && $mass_update) { |
|
308 | - DB::connection()->statement( |
|
309 | - 'INSERT INTO `' . DB::connection()->getTablePrefix() . 'maj_sosa`' . |
|
310 | - ' (majs_gedcom_id, majs_user_id, majs_sosa,' . |
|
311 | - ' majs_i_id, majs_gen, majs_birth_year, majs_birth_year_est, majs_death_year, majs_death_year_est)' . |
|
312 | - ' VALUES ' . implode(',', $bindings_placeholders) . |
|
313 | - ' ON DUPLICATE KEY UPDATE majs_i_id = VALUES(majs_i_id), majs_gen = VALUES(majs_gen),' . |
|
314 | - ' majs_birth_year = VALUES(majs_birth_year), majs_birth_year_est = VALUES(majs_birth_year_est),' . |
|
315 | - ' majs_death_year = VALUES(majs_death_year), majs_death_year_est = VALUES(majs_death_year_est)', |
|
316 | - $bindings_values |
|
317 | - ); |
|
318 | - } |
|
319 | - } |
|
307 | + if ($has_records && $mass_update) { |
|
308 | + DB::connection()->statement( |
|
309 | + 'INSERT INTO `' . DB::connection()->getTablePrefix() . 'maj_sosa`' . |
|
310 | + ' (majs_gedcom_id, majs_user_id, majs_sosa,' . |
|
311 | + ' majs_i_id, majs_gen, majs_birth_year, majs_birth_year_est, majs_death_year, majs_death_year_est)' . |
|
312 | + ' VALUES ' . implode(',', $bindings_placeholders) . |
|
313 | + ' ON DUPLICATE KEY UPDATE majs_i_id = VALUES(majs_i_id), majs_gen = VALUES(majs_gen),' . |
|
314 | + ' majs_birth_year = VALUES(majs_birth_year), majs_birth_year_est = VALUES(majs_birth_year_est),' . |
|
315 | + ' majs_death_year = VALUES(majs_death_year), majs_death_year_est = VALUES(majs_death_year_est)', |
|
316 | + $bindings_values |
|
317 | + ); |
|
318 | + } |
|
319 | + } |
|
320 | 320 | } |