@@ -93,8 +93,12 @@ discard block |
||
| 93 | 93 | foreach($stats_gen as $gen => $tab){ |
| 94 | 94 | $genY1= I18N::translate('-'); |
| 95 | 95 | $genY2= I18N::translate('-'); |
| 96 | - if($tab['firstBirth']>0) $genY1=$tab['firstEstimatedBirth']; |
|
| 97 | - if($tab['lastBirth']>0) $genY2=$tab['lastEstimatedBirth']; |
|
| 96 | + if($tab['firstBirth']>0) { |
|
| 97 | + $genY1=$tab['firstEstimatedBirth']; |
|
| 98 | + } |
|
| 99 | + if($tab['lastBirth']>0) { |
|
| 100 | + $genY2=$tab['lastEstimatedBirth']; |
|
| 101 | + } |
|
| 98 | 102 | $total_theoretical += $gen_theoretical; |
| 99 | 103 | $perc_sosa_count_theor = Functions::safeDivision($tab['sosaCount'], $gen_theoretical); |
| 100 | 104 | $gen_equiv += $perc_sosa_count_theor; |
@@ -154,7 +158,9 @@ discard block |
||
| 154 | 158 | private function htmlAncestorDispersionG2() |
| 155 | 159 | { |
| 156 | 160 | $ancestorsDispGen2 = $this->sosa_provider->getAncestorDispersionForGen(2); |
| 157 | - if(count($ancestorsDispGen2) == 0) return; |
|
| 161 | + if(count($ancestorsDispGen2) == 0) { |
|
| 162 | + return; |
|
| 163 | + } |
|
| 158 | 164 | |
| 159 | 165 | $size = '600x300'; |
| 160 | 166 | |
@@ -84,21 +84,25 @@ 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) |
|
| 88 | - self::$default_user = User::find(-1); |
|
| 87 | + if(self::$default_user === null) { |
|
| 88 | + self::$default_user = User::find(-1); |
|
| 89 | + } |
|
| 89 | 90 | |
| 90 | 91 | $this->tree = $tree; |
| 91 | 92 | $this->user = $user; |
| 92 | 93 | $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; |
|
| 94 | + if($this->user === null) { |
|
| 95 | + $this->user = Auth::user(); |
|
| 96 | + } |
|
| 97 | + if(strlen($this->user->getUserId()) == 0) { |
|
| 98 | + $this->user = self::$default_user; |
|
| 99 | + } |
|
| 95 | 100 | |
| 96 | 101 | // Check if the user, or the default user, has a root already setup; |
| 97 | 102 | if(empty($this->getRootIndiId())) { |
| 98 | 103 | if($this->user == self::$default_user) { // If the default user is not setup |
| 99 | 104 | $this->is_setup = false; |
| 100 | - } |
|
| 101 | - else { |
|
| 105 | + } else { |
|
| 102 | 106 | $this->user = self::$default_user; |
| 103 | 107 | $this->is_setup = $this->getRootIndiId() === null; |
| 104 | 108 | } |
@@ -141,7 +145,9 @@ discard block |
||
| 141 | 145 | * Remove all Sosa entries related to the gedcom file and user |
| 142 | 146 | */ |
| 143 | 147 | public function deleteAll() { |
| 144 | - if(!$this->is_setup) return; |
|
| 148 | + if(!$this->is_setup) { |
|
| 149 | + return; |
|
| 150 | + } |
|
| 145 | 151 | Database::prepare( |
| 146 | 152 | 'DELETE FROM `##maj_sosa`'. |
| 147 | 153 | ' WHERE majs_gedcom_id= :tree_id and majs_user_id = :user_id ') |
@@ -157,7 +163,9 @@ discard block |
||
| 157 | 163 | * @param int $sosa |
| 158 | 164 | */ |
| 159 | 165 | public function deleteAncestors($sosa) { |
| 160 | - if(!$this->is_setup) return; |
|
| 166 | + if(!$this->is_setup) { |
|
| 167 | + return; |
|
| 168 | + } |
|
| 161 | 169 | $gen = Functions::getGeneration($sosa); |
| 162 | 170 | Database::prepare( |
| 163 | 171 | 'DELETE FROM `##maj_sosa`'. |
@@ -177,7 +185,9 @@ discard block |
||
| 177 | 185 | * @param array $sosa_records |
| 178 | 186 | */ |
| 179 | 187 | public function insertOrUpdate($sosa_records) { |
| 180 | - if(!$this->is_setup) return; |
|
| 188 | + if(!$this->is_setup) { |
|
| 189 | + return; |
|
| 190 | + } |
|
| 181 | 191 | |
| 182 | 192 | $treeid = $this->tree->getTreeId(); |
| 183 | 193 | $userid = $this->user->getUserId(); |
@@ -226,7 +236,9 @@ discard block |
||
| 226 | 236 | * @return array Array of sosa numbers |
| 227 | 237 | */ |
| 228 | 238 | public function getSosaNumbers(Individual $indi) { |
| 229 | - if(!$this->is_setup) return array(); |
|
| 239 | + if(!$this->is_setup) { |
|
| 240 | + return array(); |
|
| 241 | + } |
|
| 230 | 242 | return Database::prepare( |
| 231 | 243 | 'SELECT majs_sosa, majs_gen FROM `##maj_sosa`'. |
| 232 | 244 | ' WHERE majs_i_id=:indi_id AND majs_gedcom_id=:tree_id AND majs_user_id=:user_id' |
@@ -243,7 +255,9 @@ discard block |
||
| 243 | 255 | * @return number Last generation if found, 1 otherwise |
| 244 | 256 | */ |
| 245 | 257 | public function getLastGeneration() { |
| 246 | - if(!$this->is_setup) return; |
|
| 258 | + if(!$this->is_setup) { |
|
| 259 | + return; |
|
| 260 | + } |
|
| 247 | 261 | return Database::prepare( |
| 248 | 262 | 'SELECT MAX(majs_gen) FROM `##maj_sosa`'. |
| 249 | 263 | ' WHERE majs_gedcom_id=:tree_id AND majs_user_id=:user_id' |
@@ -263,7 +277,9 @@ discard block |
||
| 263 | 277 | * @return array Associative array of Sosa ancestors, with their generation, comma separated |
| 264 | 278 | */ |
| 265 | 279 | public function getAllSosaWithGenerations(){ |
| 266 | - if(!$this->is_setup) return array(); |
|
| 280 | + if(!$this->is_setup) { |
|
| 281 | + return array(); |
|
| 282 | + } |
|
| 267 | 283 | return Database::prepare( |
| 268 | 284 | 'SELECT majs_i_id AS indi,' . |
| 269 | 285 | ' GROUP_CONCAT(DISTINCT majs_gen ORDER BY majs_gen ASC SEPARATOR ",") AS generations' . |
@@ -283,9 +299,12 @@ discard block |
||
| 283 | 299 | * @return array Array of Sosa individuals |
| 284 | 300 | */ |
| 285 | 301 | public function getSosaListAtGeneration($gen){ |
| 286 | - if(!$this->is_setup) return array(); |
|
| 287 | - if(!$this->sosa_list_by_gen) |
|
| 288 | - $this->sosa_list_by_gen = array(); |
|
| 302 | + if(!$this->is_setup) { |
|
| 303 | + return array(); |
|
| 304 | + } |
|
| 305 | + if(!$this->sosa_list_by_gen) { |
|
| 306 | + $this->sosa_list_by_gen = array(); |
|
| 307 | + } |
|
| 289 | 308 | |
| 290 | 309 | if($gen){ |
| 291 | 310 | if(!isset($this->sosa_list_by_gen[$gen])){ |
@@ -314,9 +333,12 @@ discard block |
||
| 314 | 333 | * @return array Array of Sosa families |
| 315 | 334 | */ |
| 316 | 335 | public function getFamilySosaListAtGeneration($gen){ |
| 317 | - if(!$this->is_setup) return array(); |
|
| 318 | - if(!$this->sosa_fam_list_by_gen) |
|
| 319 | - $this->sosa_fam_list_by_gen = array(); |
|
| 336 | + if(!$this->is_setup) { |
|
| 337 | + return array(); |
|
| 338 | + } |
|
| 339 | + if(!$this->sosa_fam_list_by_gen) { |
|
| 340 | + $this->sosa_fam_list_by_gen = array(); |
|
| 341 | + } |
|
| 320 | 342 | |
| 321 | 343 | if($gen){ |
| 322 | 344 | if(!isset($this->sosa_fam_list_by_gen[$gen])){ |
@@ -350,7 +372,9 @@ discard block |
||
| 350 | 372 | * @return array Array of Sosa individuals |
| 351 | 373 | */ |
| 352 | 374 | public function getMissingSosaListAtGeneration($gen){ |
| 353 | - if(!$this->is_setup) return array(); |
|
| 375 | + if(!$this->is_setup) { |
|
| 376 | + return array(); |
|
| 377 | + } |
|
| 354 | 378 | if($gen){ |
| 355 | 379 | return $this->sosa_list_by_gen[$gen] = Database::prepare( |
| 356 | 380 | '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'. |
@@ -390,7 +414,9 @@ discard block |
||
| 390 | 414 | * @return array Statistics array |
| 391 | 415 | */ |
| 392 | 416 | public function getStatisticsByGeneration() { |
| 393 | - if(!$this->is_setup) return array(); |
|
| 417 | + if(!$this->is_setup) { |
|
| 418 | + return array(); |
|
| 419 | + } |
|
| 394 | 420 | if(!$this->statistics_tab) { |
| 395 | 421 | $this->statistics_tab = array(); |
| 396 | 422 | if($maxGeneration = $this->getLastGeneration()) { |
@@ -418,7 +444,9 @@ discard block |
||
| 418 | 444 | * @return int |
| 419 | 445 | */ |
| 420 | 446 | public function getTotalIndividuals() { |
| 421 | - if(!$this->is_setup) return 0; |
|
| 447 | + if(!$this->is_setup) { |
|
| 448 | + return 0; |
|
| 449 | + } |
|
| 422 | 450 | return Database::prepare( |
| 423 | 451 | 'SELECT COUNT(*) FROM `##individuals`' . |
| 424 | 452 | ' WHERE i_file = :tree_id') |
@@ -432,7 +460,9 @@ discard block |
||
| 432 | 460 | * @return number Number of Sosas |
| 433 | 461 | */ |
| 434 | 462 | public function getSosaCount(){ |
| 435 | - if(!$this->is_setup) return 0; |
|
| 463 | + if(!$this->is_setup) { |
|
| 464 | + return 0; |
|
| 465 | + } |
|
| 436 | 466 | return Database::prepare( |
| 437 | 467 | 'SELECT COUNT(majs_sosa) FROM `##maj_sosa`' . |
| 438 | 468 | ' WHERE majs_gedcom_id=:tree_id AND majs_user_id=:user_id') |
@@ -449,7 +479,9 @@ discard block |
||
| 449 | 479 | * @return number Number of Sosas in generation |
| 450 | 480 | */ |
| 451 | 481 | public function getSosaCountAtGeneration($gen){ |
| 452 | - if(!$this->is_setup) return 0; |
|
| 482 | + if(!$this->is_setup) { |
|
| 483 | + return 0; |
|
| 484 | + } |
|
| 453 | 485 | return Database::prepare( |
| 454 | 486 | 'SELECT COUNT(majs_sosa) FROM `##maj_sosa`' . |
| 455 | 487 | ' WHERE majs_gedcom_id=:tree_id AND majs_user_id=:user_id'. |
@@ -468,7 +500,9 @@ discard block |
||
| 468 | 500 | * @return number Total number of Sosas up to generation |
| 469 | 501 | */ |
| 470 | 502 | public function getSosaCountUpToGeneration($gen){ |
| 471 | - if(!$this->is_setup) return 0; |
|
| 503 | + if(!$this->is_setup) { |
|
| 504 | + return 0; |
|
| 505 | + } |
|
| 472 | 506 | return Database::prepare( |
| 473 | 507 | 'SELECT COUNT(majs_sosa) FROM `##maj_sosa`' . |
| 474 | 508 | ' WHERE majs_gedcom_id=:tree_id AND majs_user_id=:user_id'. |
@@ -486,7 +520,9 @@ discard block |
||
| 486 | 520 | * @return number Total number of distinct individual |
| 487 | 521 | */ |
| 488 | 522 | public function getDifferentSosaCount(){ |
| 489 | - if(!$this->is_setup) return 0; |
|
| 523 | + if(!$this->is_setup) { |
|
| 524 | + return 0; |
|
| 525 | + } |
|
| 490 | 526 | return Database::prepare( |
| 491 | 527 | 'SELECT COUNT(DISTINCT majs_i_id) FROM `##maj_sosa`' . |
| 492 | 528 | ' WHERE majs_gedcom_id=:tree_id AND majs_user_id=:user_id') |
@@ -503,7 +539,9 @@ discard block |
||
| 503 | 539 | * @return number Number of distinct Sosa individuals up to generation |
| 504 | 540 | */ |
| 505 | 541 | public function getDifferentSosaCountUpToGeneration($gen){ |
| 506 | - if(!$this->is_setup) return 0; |
|
| 542 | + if(!$this->is_setup) { |
|
| 543 | + return 0; |
|
| 544 | + } |
|
| 507 | 545 | return Database::prepare( |
| 508 | 546 | 'SELECT COUNT(DISTINCT majs_i_id) FROM `##maj_sosa`' . |
| 509 | 547 | ' WHERE majs_gedcom_id=:tree_id AND majs_user_id=:user_id'. |
@@ -528,7 +566,9 @@ discard block |
||
| 528 | 566 | * @return array Birth statistics array |
| 529 | 567 | */ |
| 530 | 568 | public function getStatsBirthYearInGeneration($gen){ |
| 531 | - if(!$this->is_setup) return array('first' => 0, 'first_est' => 0, 'avg' => 0, 'last' => 0, 'last_est' => 0); |
|
| 569 | + if(!$this->is_setup) { |
|
| 570 | + return array('first' => 0, 'first_est' => 0, 'avg' => 0, 'last' => 0, 'last_est' => 0); |
|
| 571 | + } |
|
| 532 | 572 | return Database::prepare( |
| 533 | 573 | 'SELECT'. |
| 534 | 574 | ' MIN(majs_birth_year) AS first, MIN(majs_birth_year_est) AS first_est,'. |
@@ -550,7 +590,9 @@ discard block |
||
| 550 | 590 | * @return number|NULL Mean generation time |
| 551 | 591 | */ |
| 552 | 592 | public function getMeanGenerationTime(){ |
| 553 | - if(!$this->is_setup) return; |
|
| 593 | + if(!$this->is_setup) { |
|
| 594 | + return; |
|
| 595 | + } |
|
| 554 | 596 | if(!$this->statistics_tab){ |
| 555 | 597 | $this->getStatisticsByGeneration(); |
| 556 | 598 | } |
@@ -596,7 +638,10 @@ discard block |
||
| 596 | 638 | * @return array |
| 597 | 639 | */ |
| 598 | 640 | public function getAncestorDispersionForGen($gen) { |
| 599 | - if(!$this->is_setup || $gen > 11) return array(); // Going further than 11 gen will be out of range in the query |
|
| 641 | + if(!$this->is_setup || $gen > 11) { |
|
| 642 | + return array(); |
|
| 643 | + } |
|
| 644 | + // Going further than 11 gen will be out of range in the query |
|
| 600 | 645 | return Database::prepare( |
| 601 | 646 | 'SELECT branches, count(i_id)'. |
| 602 | 647 | ' FROM ('. |
@@ -636,7 +681,9 @@ discard block |
||
| 636 | 681 | * @return array |
| 637 | 682 | */ |
| 638 | 683 | public function getTopMultiSosaAncestorsNoTies($limit) { |
| 639 | - if(!$this->is_setup) return array(); |
|
| 684 | + if(!$this->is_setup) { |
|
| 685 | + return array(); |
|
| 686 | + } |
|
| 640 | 687 | return Database::prepare( |
| 641 | 688 | 'SELECT sosa_i_id, sosa_count FROM ('. |
| 642 | 689 | ' SELECT'. |