@@ -30,11 +30,11 @@ discard block |
||
30 | 30 | <?php |
31 | 31 | /** @var \Fisharebest\Webtrees\Individual $root_indi */ |
32 | 32 | $root_indi = $this->data->get('root_indi'); |
33 | - if($root_indi !== null && $root_indi->canShowName()) { ?> |
|
33 | + if ($root_indi !== null && $root_indi->canShowName()) { ?> |
|
34 | 34 | <h4 class="center"><?= I18N::translate('%s: %s', I18N::translate('Root individual'), $root_indi->getFullName()); ?><h4> |
35 | 35 | <?php } ?> |
36 | 36 | |
37 | - <?php if($this->data->get('is_setup')) { |
|
37 | + <?php if ($this->data->get('is_setup')) { |
|
38 | 38 | $general_stats = $this->data->get('general_stats'); ?> |
39 | 39 | <h3><?php echo I18N::translate('General statistics'); ?></h3> |
40 | 40 | <div class="maj-table"> |
@@ -56,7 +56,7 @@ discard block |
||
56 | 56 | </div> |
57 | 57 | <div class="maj-row"> |
58 | 58 | <div class="label"><?php echo I18N::translate('Mean generation time'); ?></div> |
59 | - <div class="value"><?php echo I18N::plural('%s year', '%s years', $general_stats['mean_gen_time'], I18N::number($general_stats['mean_gen_time'], 1)); ?></div> |
|
59 | + <div class="value"><?php echo I18N::plural('%s year', '%s years', $general_stats['mean_gen_time'], I18N::number($general_stats['mean_gen_time'], 1)); ?></div> |
|
60 | 60 | </div> |
61 | 61 | </div> |
62 | 62 | |
@@ -96,7 +96,7 @@ discard block |
||
96 | 96 | </tr> |
97 | 97 | </thead> |
98 | 98 | <tbody> |
99 | - <?php foreach($this->data->get('generation_stats') as $gen => $row) { ?> |
|
99 | + <?php foreach ($this->data->get('generation_stats') as $gen => $row) { ?> |
|
100 | 100 | <tr class="maj-row"> |
101 | 101 | <td class="label"><?php echo I18N::translate('<strong>G%d</strong>', $gen); ?></td> |
102 | 102 | <td class="label"><?php echo I18N::translate('%1$s <> %2$s', $row['gen_min_birth'], $row['gen_max_birth']); ?></td> |
@@ -110,7 +110,7 @@ discard block |
||
110 | 110 | <td class="value"><?php echo I18N::number($row['different']); ?></td> |
111 | 111 | <td class="value left percent_container"> |
112 | 112 | <div class="percent_frame"> |
113 | - <div class="percent_cell" style="width:<?php echo 100*$row['perc_different'] ?>%;"> |
|
113 | + <div class="percent_cell" style="width:<?php echo 100 * $row['perc_different'] ?>%;"> |
|
114 | 114 | <?php echo I18N::percentage($row['perc_different']); ?> |
115 | 115 | </div> |
116 | 116 | </div> |
@@ -123,7 +123,7 @@ discard block |
||
123 | 123 | <tfoot> |
124 | 124 | <tr class="maj-row"> |
125 | 125 | <td class="label" colspan="13"> |
126 | - <?php echo I18N::translate('Generation-equivalent: %s generations', I18N::number($this->data->get('equivalent_gen'),2)); ?> |
|
126 | + <?php echo I18N::translate('Generation-equivalent: %s generations', I18N::number($this->data->get('equivalent_gen'), 2)); ?> |
|
127 | 127 | </td> |
128 | 128 | </tr> |
129 | 129 | </tfoot> |
@@ -132,8 +132,8 @@ discard block |
||
132 | 132 | |
133 | 133 | <h3><?php echo I18N::translate('Known Sosa ancestors\' family dispersion'); ?></h3> |
134 | 134 | <div class="center"> |
135 | - <?php echo $this->data->get('chart_img_g2') ?: '' ; ?> |
|
136 | - <?php echo $this->data->get('chart_img_g3') ?: '' ; ?> |
|
135 | + <?php echo $this->data->get('chart_img_g2') ?: ''; ?> |
|
136 | + <?php echo $this->data->get('chart_img_g3') ?: ''; ?> |
|
137 | 137 | <!-- <canvas id="chart_ancestors_g2" width="300" height="300"></canvas> --> |
138 | 138 | </div> |
139 | 139 |
@@ -84,18 +84,18 @@ discard block |
||
84 | 84 | * @param User $user |
85 | 85 | */ |
86 | 86 | public function __construct(Tree $tree, User $user = null) { |
87 | - if(self::$default_user === null) |
|
87 | + if (self::$default_user === null) |
|
88 | 88 | self::$default_user = User::find(-1); |
89 | 89 | |
90 | 90 | $this->tree = $tree; |
91 | 91 | $this->user = $user; |
92 | 92 | $this->is_setup = true; |
93 | - if($this->user === null) $this->user = Auth::user(); |
|
94 | - if(strlen($this->user->getUserId()) == 0) $this->user = self::$default_user; |
|
93 | + if ($this->user === null) $this->user = Auth::user(); |
|
94 | + if (strlen($this->user->getUserId()) == 0) $this->user = self::$default_user; |
|
95 | 95 | |
96 | 96 | // Check if the user, or the default user, has a root already setup; |
97 | - if(empty($this->getRootIndiId())) { |
|
98 | - if($this->user == self::$default_user) { // If the default user is not setup |
|
97 | + if (empty($this->getRootIndiId())) { |
|
98 | + if ($this->user == self::$default_user) { // If the default user is not setup |
|
99 | 99 | $this->is_setup = false; |
100 | 100 | } |
101 | 101 | else { |
@@ -127,7 +127,7 @@ discard block |
||
127 | 127 | */ |
128 | 128 | public function getRootIndi() { |
129 | 129 | $root_indi_id = $this->getRootIndiId(); |
130 | - if(!empty($root_indi_id)) { |
|
130 | + if (!empty($root_indi_id)) { |
|
131 | 131 | return Individual::getInstance($root_indi_id, $this->tree); |
132 | 132 | } |
133 | 133 | return null; |
@@ -141,7 +141,7 @@ discard block |
||
141 | 141 | * Remove all Sosa entries related to the gedcom file and user |
142 | 142 | */ |
143 | 143 | public function deleteAll() { |
144 | - if(!$this->is_setup) return; |
|
144 | + if (!$this->is_setup) return; |
|
145 | 145 | Database::prepare( |
146 | 146 | 'DELETE FROM `##maj_sosa`'. |
147 | 147 | ' WHERE majs_gedcom_id= :tree_id and majs_user_id = :user_id ') |
@@ -157,12 +157,12 @@ discard block |
||
157 | 157 | * @param int $sosa |
158 | 158 | */ |
159 | 159 | public function deleteAncestors($sosa) { |
160 | - if(!$this->is_setup) return; |
|
160 | + if (!$this->is_setup) return; |
|
161 | 161 | $gen = Functions::getGeneration($sosa); |
162 | 162 | Database::prepare( |
163 | 163 | 'DELETE FROM `##maj_sosa`'. |
164 | - ' WHERE majs_gedcom_id=:tree_id and majs_user_id = :user_id' . |
|
165 | - ' AND majs_gen >= :gen' . |
|
164 | + ' WHERE majs_gedcom_id=:tree_id and majs_user_id = :user_id'. |
|
165 | + ' AND majs_gen >= :gen'. |
|
166 | 166 | ' AND FLOOR(majs_sosa / (POW(2, (majs_gen - :gen)))) = :sosa' |
167 | 167 | )->execute(array( |
168 | 168 | 'tree_id' => $this->tree->getTreeId(), |
@@ -177,7 +177,7 @@ discard block |
||
177 | 177 | * @param array $sosa_records |
178 | 178 | */ |
179 | 179 | public function insertOrUpdate($sosa_records) { |
180 | - if(!$this->is_setup) return; |
|
180 | + if (!$this->is_setup) return; |
|
181 | 181 | |
182 | 182 | $treeid = $this->tree->getTreeId(); |
183 | 183 | $userid = $this->user->getUserId(); |
@@ -185,9 +185,9 @@ discard block |
||
185 | 185 | $values_table = array(); |
186 | 186 | |
187 | 187 | $i = 0; |
188 | - foreach ($sosa_records as $row) { |
|
188 | + foreach ($sosa_records as $row) { |
|
189 | 189 | $gen = Functions::getGeneration($row['sosa']); |
190 | - if($gen <= self::MAX_DB_GENERATIONS) { |
|
190 | + if ($gen <= self::MAX_DB_GENERATIONS) { |
|
191 | 191 | $questionmarks_table[] = |
192 | 192 | '(:tree_id'.$i.', :user_id'.$i.', :sosa'.$i.', :indi_id'.$i.', :gen'.$i.', :byear'.$i.', :dyear'.$i.')'; |
193 | 193 | $values_table = array_merge( |
@@ -206,9 +206,9 @@ discard block |
||
206 | 206 | $i++; |
207 | 207 | } |
208 | 208 | |
209 | - $sql = 'REPLACE INTO `##maj_sosa`' . |
|
210 | - ' (majs_gedcom_id, majs_user_id, majs_sosa, majs_i_id, majs_gen, majs_birth_year, majs_death_year)' . |
|
211 | - ' VALUES '. implode(',', $questionmarks_table); |
|
209 | + $sql = 'REPLACE INTO `##maj_sosa`'. |
|
210 | + ' (majs_gedcom_id, majs_user_id, majs_sosa, majs_i_id, majs_gen, majs_birth_year, majs_death_year)'. |
|
211 | + ' VALUES '.implode(',', $questionmarks_table); |
|
212 | 212 | Database::prepare($sql)->execute($values_table); |
213 | 213 | } |
214 | 214 | |
@@ -224,7 +224,7 @@ discard block |
||
224 | 224 | * @return array Array of sosa numbers |
225 | 225 | */ |
226 | 226 | public function getSosaNumbers(Individual $indi) { |
227 | - if(!$this->is_setup) return array(); |
|
227 | + if (!$this->is_setup) return array(); |
|
228 | 228 | return Database::prepare( |
229 | 229 | 'SELECT majs_sosa, majs_gen FROM `##maj_sosa`'. |
230 | 230 | ' WHERE majs_i_id=:indi_id AND majs_gedcom_id=:tree_id AND majs_user_id=:user_id' |
@@ -241,7 +241,7 @@ discard block |
||
241 | 241 | * @return number Last generation if found, 1 otherwise |
242 | 242 | */ |
243 | 243 | public function getLastGeneration() { |
244 | - if(!$this->is_setup) return; |
|
244 | + if (!$this->is_setup) return; |
|
245 | 245 | return Database::prepare( |
246 | 246 | 'SELECT MAX(majs_gen) FROM `##maj_sosa`'. |
247 | 247 | ' WHERE majs_gedcom_id=:tree_id AND majs_user_id=:user_id' |
@@ -261,13 +261,13 @@ discard block |
||
261 | 261 | * @param int $ged_id ID of the gedcom file |
262 | 262 | * @return array Associative array of Sosa ancestors, with their generation, comma separated |
263 | 263 | */ |
264 | - public function getAllSosaWithGenerations(){ |
|
265 | - if(!$this->is_setup) return array(); |
|
264 | + public function getAllSosaWithGenerations() { |
|
265 | + if (!$this->is_setup) return array(); |
|
266 | 266 | return Database::prepare( |
267 | - 'SELECT majs_i_id AS indi,' . |
|
268 | - ' GROUP_CONCAT(DISTINCT majs_gen ORDER BY majs_gen ASC SEPARATOR ",") AS generations' . |
|
269 | - ' FROM `##maj_sosa`' . |
|
270 | - ' WHERE majs_gedcom_id=:tree_id AND majs_user_id=:user_id' . |
|
267 | + 'SELECT majs_i_id AS indi,'. |
|
268 | + ' GROUP_CONCAT(DISTINCT majs_gen ORDER BY majs_gen ASC SEPARATOR ",") AS generations'. |
|
269 | + ' FROM `##maj_sosa`'. |
|
270 | + ' WHERE majs_gedcom_id=:tree_id AND majs_user_id=:user_id'. |
|
271 | 271 | ' GROUP BY majs_i_id' |
272 | 272 | )->execute(array( |
273 | 273 | 'tree_id' => $this->tree->getTreeId(), |
@@ -281,13 +281,13 @@ discard block |
||
281 | 281 | * @param number $gen Generation |
282 | 282 | * @return array Array of Sosa individuals |
283 | 283 | */ |
284 | - public function getSosaListAtGeneration($gen){ |
|
285 | - if(!$this->is_setup) return array(); |
|
286 | - if(!$this->sosa_list_by_gen) |
|
284 | + public function getSosaListAtGeneration($gen) { |
|
285 | + if (!$this->is_setup) return array(); |
|
286 | + if (!$this->sosa_list_by_gen) |
|
287 | 287 | $this->sosa_list_by_gen = array(); |
288 | 288 | |
289 | - if($gen){ |
|
290 | - if(!isset($this->sosa_list_by_gen[$gen])){ |
|
289 | + if ($gen) { |
|
290 | + if (!isset($this->sosa_list_by_gen[$gen])) { |
|
291 | 291 | $this->sosa_list_by_gen[$gen] = Database::prepare( |
292 | 292 | 'SELECT majs_sosa AS sosa, majs_i_id AS indi'. |
293 | 293 | ' FROM `##maj_sosa`'. |
@@ -312,13 +312,13 @@ discard block |
||
312 | 312 | * @param number $gen Generation |
313 | 313 | * @return array Array of Sosa families |
314 | 314 | */ |
315 | - public function getFamilySosaListAtGeneration($gen){ |
|
316 | - if(!$this->is_setup) return array(); |
|
317 | - if(!$this->sosa_fam_list_by_gen) |
|
315 | + public function getFamilySosaListAtGeneration($gen) { |
|
316 | + if (!$this->is_setup) return array(); |
|
317 | + if (!$this->sosa_fam_list_by_gen) |
|
318 | 318 | $this->sosa_fam_list_by_gen = array(); |
319 | 319 | |
320 | - if($gen){ |
|
321 | - if(!isset($this->sosa_fam_list_by_gen[$gen])){ |
|
320 | + if ($gen) { |
|
321 | + if (!isset($this->sosa_fam_list_by_gen[$gen])) { |
|
322 | 322 | $this->sosa_fam_list_by_gen[$gen] = Database::prepare( |
323 | 323 | 'SELECT s1.majs_sosa AS sosa, f_id AS fam'. |
324 | 324 | ' FROM `##families`'. |
@@ -348,9 +348,9 @@ discard block |
||
348 | 348 | * @param number $gen Generation |
349 | 349 | * @return array Array of Sosa individuals |
350 | 350 | */ |
351 | - public function getMissingSosaListAtGeneration($gen){ |
|
352 | - if(!$this->is_setup) return array(); |
|
353 | - if($gen){ |
|
351 | + public function getMissingSosaListAtGeneration($gen) { |
|
352 | + if (!$this->is_setup) return array(); |
|
353 | + if ($gen) { |
|
354 | 354 | return $this->sosa_list_by_gen[$gen] = Database::prepare( |
355 | 355 | 'SELECT schild.majs_sosa sosa, schild.majs_i_id indi, sfat.majs_sosa IS NOT NULL has_father, smot.majs_sosa IS NOT NULL has_mother'. |
356 | 356 | ' FROM `##maj_sosa` schild'. |
@@ -387,10 +387,10 @@ discard block |
||
387 | 387 | * @return array Statistics array |
388 | 388 | */ |
389 | 389 | public function getStatisticsByGeneration() { |
390 | - if(!$this->is_setup) return array(); |
|
391 | - if(!$this->statistics_tab) { |
|
390 | + if (!$this->is_setup) return array(); |
|
391 | + if (!$this->statistics_tab) { |
|
392 | 392 | $this->statistics_tab = array(); |
393 | - if($maxGeneration = $this->getLastGeneration()) { |
|
393 | + if ($maxGeneration = $this->getLastGeneration()) { |
|
394 | 394 | for ($gen = 1; $gen <= $maxGeneration; $gen++) { |
395 | 395 | $birthStats = $this->getStatsBirthYearInGeneration($gen); |
396 | 396 | $this->statistics_tab[$gen] = array( |
@@ -413,9 +413,9 @@ discard block |
||
413 | 413 | * @return int |
414 | 414 | */ |
415 | 415 | public function getTotalIndividuals() { |
416 | - if(!$this->is_setup) return 0; |
|
416 | + if (!$this->is_setup) return 0; |
|
417 | 417 | return Database::prepare( |
418 | - 'SELECT SQL_CACHE COUNT(*) FROM `##individuals`' . |
|
418 | + 'SELECT SQL_CACHE COUNT(*) FROM `##individuals`'. |
|
419 | 419 | ' WHERE i_file = :tree_id') |
420 | 420 | ->execute(array('tree_id' => $this->tree->getTreeId())) |
421 | 421 | ->fetchOne() ?: 0; |
@@ -426,10 +426,10 @@ discard block |
||
426 | 426 | * |
427 | 427 | * @return number Number of Sosas |
428 | 428 | */ |
429 | - public function getSosaCount(){ |
|
430 | - if(!$this->is_setup) return 0; |
|
429 | + public function getSosaCount() { |
|
430 | + if (!$this->is_setup) return 0; |
|
431 | 431 | return Database::prepare( |
432 | - 'SELECT SQL_CACHE COUNT(majs_sosa) FROM `##maj_sosa`' . |
|
432 | + 'SELECT SQL_CACHE COUNT(majs_sosa) FROM `##maj_sosa`'. |
|
433 | 433 | ' WHERE majs_gedcom_id=:tree_id AND majs_user_id=:user_id') |
434 | 434 | ->execute(array( |
435 | 435 | 'tree_id' => $this->tree->getTreeId(), |
@@ -443,10 +443,10 @@ discard block |
||
443 | 443 | * @param number $gen Generation |
444 | 444 | * @return number Number of Sosas in generation |
445 | 445 | */ |
446 | - public function getSosaCountAtGeneration($gen){ |
|
447 | - if(!$this->is_setup) return 0; |
|
446 | + public function getSosaCountAtGeneration($gen) { |
|
447 | + if (!$this->is_setup) return 0; |
|
448 | 448 | return Database::prepare( |
449 | - 'SELECT SQL_CACHE COUNT(majs_sosa) FROM `##maj_sosa`' . |
|
449 | + 'SELECT SQL_CACHE COUNT(majs_sosa) FROM `##maj_sosa`'. |
|
450 | 450 | ' WHERE majs_gedcom_id=:tree_id AND majs_user_id=:user_id'. |
451 | 451 | ' AND majs_gen= :gen') |
452 | 452 | ->execute(array( |
@@ -462,10 +462,10 @@ discard block |
||
462 | 462 | * @param number $gen Generation |
463 | 463 | * @return number Total number of Sosas up to generation |
464 | 464 | */ |
465 | - public function getSosaCountUpToGeneration($gen){ |
|
466 | - if(!$this->is_setup) return 0; |
|
465 | + public function getSosaCountUpToGeneration($gen) { |
|
466 | + if (!$this->is_setup) return 0; |
|
467 | 467 | return Database::prepare( |
468 | - 'SELECT SQL_CACHE COUNT(majs_sosa) FROM `##maj_sosa`' . |
|
468 | + 'SELECT SQL_CACHE COUNT(majs_sosa) FROM `##maj_sosa`'. |
|
469 | 469 | ' WHERE majs_gedcom_id=:tree_id AND majs_user_id=:user_id'. |
470 | 470 | ' AND majs_gen <= :gen') |
471 | 471 | ->execute(array( |
@@ -480,10 +480,10 @@ discard block |
||
480 | 480 | * |
481 | 481 | * @return number Total number of distinct individual |
482 | 482 | */ |
483 | - public function getDifferentSosaCount(){ |
|
484 | - if(!$this->is_setup) return 0; |
|
483 | + public function getDifferentSosaCount() { |
|
484 | + if (!$this->is_setup) return 0; |
|
485 | 485 | return Database::prepare( |
486 | - 'SELECT SQL_CACHE COUNT(DISTINCT majs_i_id) FROM `##maj_sosa`' . |
|
486 | + 'SELECT SQL_CACHE COUNT(DISTINCT majs_i_id) FROM `##maj_sosa`'. |
|
487 | 487 | ' WHERE majs_gedcom_id=:tree_id AND majs_user_id=:user_id') |
488 | 488 | ->execute(array( |
489 | 489 | 'tree_id' => $this->tree->getTreeId(), |
@@ -497,10 +497,10 @@ discard block |
||
497 | 497 | * @param number $gen Generation |
498 | 498 | * @return number Number of distinct Sosa individuals up to generation |
499 | 499 | */ |
500 | - public function getDifferentSosaCountUpToGeneration($gen){ |
|
501 | - if(!$this->is_setup) return 0; |
|
500 | + public function getDifferentSosaCountUpToGeneration($gen) { |
|
501 | + if (!$this->is_setup) return 0; |
|
502 | 502 | return Database::prepare( |
503 | - 'SELECT SQL_CACHE COUNT(DISTINCT majs_i_id) FROM `##maj_sosa`' . |
|
503 | + 'SELECT SQL_CACHE COUNT(DISTINCT majs_i_id) FROM `##maj_sosa`'. |
|
504 | 504 | ' WHERE majs_gedcom_id=:tree_id AND majs_user_id=:user_id'. |
505 | 505 | ' AND majs_gen <= :gen') |
506 | 506 | ->execute(array( |
@@ -520,11 +520,11 @@ discard block |
||
520 | 520 | * @param number $gen Generation |
521 | 521 | * @return array Birth statistics array |
522 | 522 | */ |
523 | - public function getStatsBirthYearInGeneration($gen){ |
|
524 | - if(!$this->is_setup) return array('first' => 0, 'avg' => 0, 'last' => 0); |
|
523 | + public function getStatsBirthYearInGeneration($gen) { |
|
524 | + if (!$this->is_setup) return array('first' => 0, 'avg' => 0, 'last' => 0); |
|
525 | 525 | return Database::prepare( |
526 | 526 | 'SELECT MIN(majs_birth_year) AS first, AVG(majs_birth_year) AS avg, MAX(majs_birth_year) AS last'. |
527 | - ' FROM `##maj_sosa`' . |
|
527 | + ' FROM `##maj_sosa`'. |
|
528 | 528 | ' WHERE majs_gedcom_id=:tree_id AND majs_user_id=:user_id'. |
529 | 529 | ' AND majs_gen=:gen AND NOT majs_birth_year = :birth_year') |
530 | 530 | ->execute(array( |
@@ -540,26 +540,26 @@ discard block |
||
540 | 540 | * |
541 | 541 | * @return number|NULL Mean generation time |
542 | 542 | */ |
543 | - public function getMeanGenerationTime(){ |
|
544 | - if(!$this->is_setup) return; |
|
545 | - if(!$this->statistics_tab){ |
|
543 | + public function getMeanGenerationTime() { |
|
544 | + if (!$this->is_setup) return; |
|
545 | + if (!$this->statistics_tab) { |
|
546 | 546 | $this->getStatisticsByGeneration(); |
547 | 547 | } |
548 | 548 | //Linear regression on x=generation and y=birthdate |
549 | 549 | $sum_xy = 0; |
550 | - $sum_x=0; |
|
551 | - $sum_y=0; |
|
552 | - $sum_x2=0; |
|
553 | - $n=count($this->statistics_tab); |
|
554 | - foreach($this->statistics_tab as $gen=>$stats){ |
|
555 | - $sum_xy+=$gen*$stats['avgBirth']; |
|
556 | - $sum_x+=$gen; |
|
557 | - $sum_y+=$stats['avgBirth']; |
|
558 | - $sum_x2+=$gen*$gen; |
|
550 | + $sum_x = 0; |
|
551 | + $sum_y = 0; |
|
552 | + $sum_x2 = 0; |
|
553 | + $n = count($this->statistics_tab); |
|
554 | + foreach ($this->statistics_tab as $gen=>$stats) { |
|
555 | + $sum_xy += $gen * $stats['avgBirth']; |
|
556 | + $sum_x += $gen; |
|
557 | + $sum_y += $stats['avgBirth']; |
|
558 | + $sum_x2 += $gen * $gen; |
|
559 | 559 | } |
560 | - $denom=($n*$sum_x2)-($sum_x*$sum_x); |
|
561 | - if($denom!=0){ |
|
562 | - return -(($n*$sum_xy)-($sum_x*$sum_y))/($denom); |
|
560 | + $denom = ($n * $sum_x2) - ($sum_x * $sum_x); |
|
561 | + if ($denom != 0) { |
|
562 | + return -(($n * $sum_xy) - ($sum_x * $sum_y)) / ($denom); |
|
563 | 563 | } |
564 | 564 | return null; |
565 | 565 | } |
@@ -587,14 +587,14 @@ discard block |
||
587 | 587 | * @return array |
588 | 588 | */ |
589 | 589 | public function getAncestorDispersionForGen($gen) { |
590 | - if(!$this->is_setup || $gen > 11) return array(); // Going further than 11 gen will be out of range in the query |
|
590 | + if (!$this->is_setup || $gen > 11) return array(); // Going further than 11 gen will be out of range in the query |
|
591 | 591 | return Database::prepare( |
592 | 592 | 'SELECT branches, count(i_id)'. |
593 | 593 | ' FROM ('. |
594 | 594 | ' SELECT i_id,'. |
595 | 595 | ' CASE'. |
596 | 596 | ' WHEN CEIL(LOG2(SUM(branch))) = LOG2(SUM(branch)) THEN SUM(branch)'. |
597 | - ' ELSE -1'. // We put all ancestors shared between some branches in the same bucket |
|
597 | + ' ELSE -1'.// We put all ancestors shared between some branches in the same bucket |
|
598 | 598 | ' END branches'. |
599 | 599 | ' FROM ('. |
600 | 600 | ' SELECT DISTINCT majs_i_id i_id,'. |
@@ -38,9 +38,9 @@ discard block |
||
38 | 38 | * |
39 | 39 | * @param string $text Text to display |
40 | 40 | */ |
41 | - static public function promptAlert($text){ |
|
41 | + static public function promptAlert($text) { |
|
42 | 42 | echo '<script>'; |
43 | - echo 'alert("',fw\Filter::escapeHtml($text),'")'; |
|
43 | + echo 'alert("', fw\Filter::escapeHtml($text), '")'; |
|
44 | 44 | echo '</script>'; |
45 | 45 | } |
46 | 46 | |
@@ -53,7 +53,7 @@ discard block |
||
53 | 53 | * @return float Result of the safe division |
54 | 54 | */ |
55 | 55 | public static function safeDivision($num, $denom, $default = 0) { |
56 | - if($denom && $denom!=0){ |
|
56 | + if ($denom && $denom != 0) { |
|
57 | 57 | return $num / $denom; |
58 | 58 | } |
59 | 59 | return $default; |
@@ -67,7 +67,7 @@ discard block |
||
67 | 67 | * @param float $default Default value if denominator null or 0 |
68 | 68 | * @return float Percentage |
69 | 69 | */ |
70 | - public static function getPercentage($num, $denom, $default = 0){ |
|
70 | + public static function getPercentage($num, $denom, $default = 0) { |
|
71 | 71 | return 100 * self::safeDivision($num, $denom, $default); |
72 | 72 | } |
73 | 73 | |
@@ -78,8 +78,8 @@ discard block |
||
78 | 78 | * @param int $target The final max width/height |
79 | 79 | * @return array array of ($width, $height). One of them must be $target |
80 | 80 | */ |
81 | - static public function getResizedImageSize($file, $target=25){ |
|
82 | - list($width, $height, , ) = getimagesize($file); |
|
81 | + static public function getResizedImageSize($file, $target = 25) { |
|
82 | + list($width, $height,,) = getimagesize($file); |
|
83 | 83 | $max = max($width, $height); |
84 | 84 | $rapp = $target / $max; |
85 | 85 | $width = intval($rapp * $width); |
@@ -109,21 +109,21 @@ discard block |
||
109 | 109 | * @param int $length Length of the token, default to 32 |
110 | 110 | * @return string Random token |
111 | 111 | */ |
112 | - public static function generateRandomToken($length=32) { |
|
112 | + public static function generateRandomToken($length = 32) { |
|
113 | 113 | $chars = str_split('abcdefghijkmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789'); |
114 | 114 | $len_chars = count($chars); |
115 | 115 | $token = ''; |
116 | 116 | |
117 | 117 | for ($i = 0; $i < $length; $i++) |
118 | - $token .= $chars[ mt_rand(0, $len_chars - 1) ]; |
|
118 | + $token .= $chars[mt_rand(0, $len_chars - 1)]; |
|
119 | 119 | |
120 | 120 | # Number of 32 char chunks |
121 | - $chunks = ceil( strlen($token) / 32 ); |
|
121 | + $chunks = ceil(strlen($token) / 32); |
|
122 | 122 | $md5token = ''; |
123 | 123 | |
124 | 124 | # Run each chunk through md5 |
125 | - for ( $i=1; $i<=$chunks; $i++ ) |
|
126 | - $md5token .= md5( substr($token, $i * 32 - 32, 32) ); |
|
125 | + for ($i = 1; $i <= $chunks; $i++) |
|
126 | + $md5token .= md5(substr($token, $i * 32 - 32, 32)); |
|
127 | 127 | |
128 | 128 | # Trim the token |
129 | 129 | return substr($md5token, 0, $length); |
@@ -145,15 +145,15 @@ discard block |
||
145 | 145 | * @param string $data Text to encrypt |
146 | 146 | * @return string Encrypted and encoded text |
147 | 147 | */ |
148 | - public static function encryptToSafeBase64($data){ |
|
149 | - if(!self::isEncryptionCompatible()) |
|
148 | + public static function encryptToSafeBase64($data) { |
|
149 | + if (!self::isEncryptionCompatible()) |
|
150 | 150 | throw new \Exception('MCrypt PHP extension is required to use encryption.'); |
151 | 151 | |
152 | 152 | $key = 'STANDARDKEYIFNOSERVER'; |
153 | - if(!empty(Filter::server('SERVER_NAME')) && !empty(Filter::server('SERVER_SOFTWARE'))) |
|
153 | + if (!empty(Filter::server('SERVER_NAME')) && !empty(Filter::server('SERVER_SOFTWARE'))) |
|
154 | 154 | $key = md5(Filter::server('SERVER_NAME').Filter::server('SERVER_SOFTWARE')); |
155 | 155 | $iv = mcrypt_create_iv(self::ENCRYPTION_IV_SIZE, MCRYPT_RAND); |
156 | - $id = mcrypt_encrypt(MCRYPT_RIJNDAEL_128, $key, $data, MCRYPT_MODE_CBC,$iv); |
|
156 | + $id = mcrypt_encrypt(MCRYPT_RIJNDAEL_128, $key, $data, MCRYPT_MODE_CBC, $iv); |
|
157 | 157 | $encrypted = base64_encode($iv.$id); |
158 | 158 | // +, / and = are not URL-compatible |
159 | 159 | $encrypted = str_replace('+', '-', $encrypted); |
@@ -168,25 +168,25 @@ discard block |
||
168 | 168 | * @param string $encrypted Text to decrypt |
169 | 169 | * @return string Decrypted text |
170 | 170 | */ |
171 | - public static function decryptFromSafeBase64($encrypted){ |
|
172 | - if(!self::isEncryptionCompatible()) |
|
171 | + public static function decryptFromSafeBase64($encrypted) { |
|
172 | + if (!self::isEncryptionCompatible()) |
|
173 | 173 | throw new \Exception('MCrypt PHP extension is required to use encryption.'); |
174 | 174 | |
175 | 175 | $key = 'STANDARDKEYIFNOSERVER'; |
176 | - if(!empty(Filter::server('SERVER_NAME')) && !empty(Filter::server('SERVER_SOFTWARE'))) |
|
176 | + if (!empty(Filter::server('SERVER_NAME')) && !empty(Filter::server('SERVER_SOFTWARE'))) |
|
177 | 177 | $key = md5(Filter::server('SERVER_NAME').Filter::server('SERVER_SOFTWARE')); |
178 | 178 | $encrypted = str_replace('-', '+', $encrypted); |
179 | 179 | $encrypted = str_replace('_', '/', $encrypted); |
180 | 180 | $encrypted = str_replace('*', '=', $encrypted); |
181 | 181 | $encrypted = base64_decode($encrypted); |
182 | - if(!$encrypted) |
|
182 | + if (!$encrypted) |
|
183 | 183 | throw new \InvalidArgumentException('The encrypted value is not in correct base64 format.'); |
184 | - if(strlen($encrypted) < self::ENCRYPTION_IV_SIZE) |
|
184 | + if (strlen($encrypted) < self::ENCRYPTION_IV_SIZE) |
|
185 | 185 | throw new \InvalidArgumentException('The encrypted value does not contain enough characters for the key.'); |
186 | 186 | $iv_dec = substr($encrypted, 0, self::ENCRYPTION_IV_SIZE); |
187 | 187 | $encrypted = substr($encrypted, self::ENCRYPTION_IV_SIZE); |
188 | 188 | $decrypted = mcrypt_decrypt(MCRYPT_RIJNDAEL_128, $key, $encrypted, MCRYPT_MODE_CBC, $iv_dec); |
189 | - return preg_replace('~(?:\\000+)$~','',$decrypted); |
|
189 | + return preg_replace('~(?:\\000+)$~', '', $decrypted); |
|
190 | 190 | } |
191 | 191 | |
192 | 192 | /** |
@@ -195,9 +195,9 @@ discard block |
||
195 | 195 | * @param string $string Filesystem encoded string to encode |
196 | 196 | * @return string UTF-8 encoded string |
197 | 197 | */ |
198 | - public static function encodeFileSystemToUtf8($string){ |
|
198 | + public static function encodeFileSystemToUtf8($string) { |
|
199 | 199 | if (strtoupper(substr(php_uname('s'), 0, 7)) === 'WINDOWS') { |
200 | - return iconv('cp1252', 'utf-8//IGNORE',$string); |
|
200 | + return iconv('cp1252', 'utf-8//IGNORE', $string); |
|
201 | 201 | } |
202 | 202 | return $string; |
203 | 203 | } |
@@ -208,9 +208,9 @@ discard block |
||
208 | 208 | * @param string $string UTF-8 encoded string to encode |
209 | 209 | * @return string Filesystem encoded string |
210 | 210 | */ |
211 | - public static function encodeUtf8ToFileSystem($string){ |
|
211 | + public static function encodeUtf8ToFileSystem($string) { |
|
212 | 212 | if (preg_match('//u', $string) && strtoupper(substr(php_uname('s'), 0, 7)) === 'WINDOWS') { |
213 | - return iconv('utf-8', 'cp1252//IGNORE' , $string); |
|
213 | + return iconv('utf-8', 'cp1252//IGNORE', $string); |
|
214 | 214 | } |
215 | 215 | return $string; |
216 | 216 | } |
@@ -223,7 +223,7 @@ discard block |
||
223 | 223 | * @return boolean True if path valid |
224 | 224 | */ |
225 | 225 | public static function isValidPath($filename, $acceptfolder = FALSE) { |
226 | - if(strpbrk($filename, $acceptfolder ? '?%*:|"<>' : '\\/?%*:|"<>') === FALSE) return true; |
|
226 | + if (strpbrk($filename, $acceptfolder ? '?%*:|"<>' : '\\/?%*:|"<>') === FALSE) return true; |
|
227 | 227 | return false; |
228 | 228 | } |
229 | 229 | |
@@ -235,7 +235,7 @@ discard block |
||
235 | 235 | * @return array Array of month short names |
236 | 236 | */ |
237 | 237 | public static function getCalendarShortMonths($calendarId = 0) { |
238 | - if(!isset(self::$calendarShortMonths[$calendarId])) { |
|
238 | + if (!isset(self::$calendarShortMonths[$calendarId])) { |
|
239 | 239 | $calendar_info = cal_info($calendarId); |
240 | 240 | self::$calendarShortMonths[$calendarId] = $calendar_info['abbrevmonths']; |
241 | 241 | } |
@@ -248,8 +248,8 @@ discard block |
||
248 | 248 | * @param int $sosa Sosa number |
249 | 249 | * @return number |
250 | 250 | */ |
251 | - public static function getGeneration($sosa){ |
|
252 | - return(int)log($sosa, 2)+1; |
|
251 | + public static function getGeneration($sosa) { |
|
252 | + return(int)log($sosa, 2) + 1; |
|
253 | 253 | } |
254 | 254 | |
255 | 255 |