@@ -219,7 +219,7 @@ |
||
| 219 | 219 | |
| 220 | 220 | /** |
| 221 | 221 | * Convert an array to Google Chart encoding |
| 222 | - * @param arrat $a Array to encode |
|
| 222 | + * @param integer[] $a Array to encode |
|
| 223 | 223 | * @return string |
| 224 | 224 | */ |
| 225 | 225 | private function arrayToExtendedEncoding($a) { |
@@ -25,218 +25,218 @@ |
||
| 25 | 25 | */ |
| 26 | 26 | class SosaStatsController extends MvcController |
| 27 | 27 | { |
| 28 | - /** |
|
| 29 | - * Sosa Provider for the controller |
|
| 30 | - * @var SosaProvider $sosa_provider |
|
| 31 | - */ |
|
| 32 | - protected $sosa_provider; |
|
| 28 | + /** |
|
| 29 | + * Sosa Provider for the controller |
|
| 30 | + * @var SosaProvider $sosa_provider |
|
| 31 | + */ |
|
| 32 | + protected $sosa_provider; |
|
| 33 | 33 | |
| 34 | - /** |
|
| 35 | - * Constructor for SosaStatsController |
|
| 36 | - * @param AbstractModule $module |
|
| 37 | - */ |
|
| 38 | - public function __construct(AbstractModule $module) { |
|
| 39 | - global $WT_TREE; |
|
| 34 | + /** |
|
| 35 | + * Constructor for SosaStatsController |
|
| 36 | + * @param AbstractModule $module |
|
| 37 | + */ |
|
| 38 | + public function __construct(AbstractModule $module) { |
|
| 39 | + global $WT_TREE; |
|
| 40 | 40 | |
| 41 | - parent::__construct($module); |
|
| 41 | + parent::__construct($module); |
|
| 42 | 42 | |
| 43 | - $this->sosa_provider = new SosaProvider($WT_TREE, Auth::user()); |
|
| 44 | - } |
|
| 43 | + $this->sosa_provider = new SosaProvider($WT_TREE, Auth::user()); |
|
| 44 | + } |
|
| 45 | 45 | |
| 46 | - /** |
|
| 47 | - * Pages |
|
| 48 | - */ |
|
| 46 | + /** |
|
| 47 | + * Pages |
|
| 48 | + */ |
|
| 49 | 49 | |
| 50 | - /** |
|
| 51 | - * SosaStats@index |
|
| 52 | - */ |
|
| 53 | - public function index() { |
|
| 54 | - global $WT_TREE; |
|
| 50 | + /** |
|
| 51 | + * SosaStats@index |
|
| 52 | + */ |
|
| 53 | + public function index() { |
|
| 54 | + global $WT_TREE; |
|
| 55 | 55 | |
| 56 | - $controller = new PageController(); |
|
| 57 | - $controller |
|
| 58 | - ->setPageTitle(I18N::translate('Sosa Statistics')) |
|
| 59 | - ->addInlineJavascript('$(".help_tooltip").tooltip();') |
|
| 60 | - ; |
|
| 56 | + $controller = new PageController(); |
|
| 57 | + $controller |
|
| 58 | + ->setPageTitle(I18N::translate('Sosa Statistics')) |
|
| 59 | + ->addInlineJavascript('$(".help_tooltip").tooltip();') |
|
| 60 | + ; |
|
| 61 | 61 | |
| 62 | - $view_bag = new ViewBag(); |
|
| 63 | - $view_bag->set('title', $controller->getPageTitle()); |
|
| 64 | - $view_bag->set('is_setup', false); |
|
| 62 | + $view_bag = new ViewBag(); |
|
| 63 | + $view_bag->set('title', $controller->getPageTitle()); |
|
| 64 | + $view_bag->set('is_setup', false); |
|
| 65 | 65 | |
| 66 | - if($this->sosa_provider->isSetup()) { |
|
| 67 | - $view_bag->set('is_setup', true); |
|
| 66 | + if($this->sosa_provider->isSetup()) { |
|
| 67 | + $view_bag->set('is_setup', true); |
|
| 68 | 68 | |
| 69 | - $view_bag->set('root_indi', $this->sosa_provider->getRootIndi()); |
|
| 69 | + $view_bag->set('root_indi', $this->sosa_provider->getRootIndi()); |
|
| 70 | 70 | |
| 71 | - $sosaCount = $this->sosa_provider->getSosaCount(); |
|
| 72 | - $diffSosaCount = $this->sosa_provider->getDifferentSosaCount(); |
|
| 71 | + $sosaCount = $this->sosa_provider->getSosaCount(); |
|
| 72 | + $diffSosaCount = $this->sosa_provider->getDifferentSosaCount(); |
|
| 73 | 73 | |
| 74 | - $general_stats = array( |
|
| 75 | - 'sosa_count' => $sosaCount, |
|
| 76 | - 'distinct_count' => $diffSosaCount, |
|
| 77 | - 'sosa_rate' => Functions::safeDivision($diffSosaCount, $this->sosa_provider->getTotalIndividuals()), |
|
| 78 | - 'pedi_collapse' => 1 - Functions::safeDivision($diffSosaCount, $sosaCount), |
|
| 79 | - 'mean_gen_time' => $this->sosa_provider->getMeanGenerationTime() |
|
| 80 | - ); |
|
| 81 | - $view_bag->set('general_stats', $general_stats); |
|
| 74 | + $general_stats = array( |
|
| 75 | + 'sosa_count' => $sosaCount, |
|
| 76 | + 'distinct_count' => $diffSosaCount, |
|
| 77 | + 'sosa_rate' => Functions::safeDivision($diffSosaCount, $this->sosa_provider->getTotalIndividuals()), |
|
| 78 | + 'pedi_collapse' => 1 - Functions::safeDivision($diffSosaCount, $sosaCount), |
|
| 79 | + 'mean_gen_time' => $this->sosa_provider->getMeanGenerationTime() |
|
| 80 | + ); |
|
| 81 | + $view_bag->set('general_stats', $general_stats); |
|
| 82 | 82 | |
| 83 | - $stats_gen = $this->sosa_provider->getStatisticsByGeneration(); |
|
| 84 | - $view_bag->set('missinganc_url', 'module.php?mod='.$this->module->getName().'&mod_action=SosaList@missing&ged='.$WT_TREE->getNameUrl().'&gen='); |
|
| 85 | - $view_bag->set('sosaanc_url', 'module.php?mod='.$this->module->getName().'&mod_action=SosaList&ged='.$WT_TREE->getNameUrl().'&gen='); |
|
| 83 | + $stats_gen = $this->sosa_provider->getStatisticsByGeneration(); |
|
| 84 | + $view_bag->set('missinganc_url', 'module.php?mod='.$this->module->getName().'&mod_action=SosaList@missing&ged='.$WT_TREE->getNameUrl().'&gen='); |
|
| 85 | + $view_bag->set('sosaanc_url', 'module.php?mod='.$this->module->getName().'&mod_action=SosaList&ged='.$WT_TREE->getNameUrl().'&gen='); |
|
| 86 | 86 | |
| 87 | - $gen_theoretical=1; |
|
| 88 | - $total_theoretical=0; |
|
| 89 | - $prev_diff=0; |
|
| 90 | - $prev_known=0.5; |
|
| 91 | - $gen_equiv=0; |
|
| 92 | - $generation_stats = array(); |
|
| 87 | + $gen_theoretical=1; |
|
| 88 | + $total_theoretical=0; |
|
| 89 | + $prev_diff=0; |
|
| 90 | + $prev_known=0.5; |
|
| 91 | + $gen_equiv=0; |
|
| 92 | + $generation_stats = array(); |
|
| 93 | 93 | |
| 94 | - foreach($stats_gen as $gen => $tab){ |
|
| 95 | - $genY1= I18N::translate('-'); |
|
| 96 | - $genY2= I18N::translate('-'); |
|
| 97 | - if($tab['firstBirth']>0) $genY1=$tab['firstBirth']; |
|
| 98 | - if($tab['lastBirth']>0) $genY2=$tab['lastBirth']; |
|
| 99 | - $total_theoretical += $gen_theoretical; |
|
| 100 | - $perc_sosa_count_theor = Functions::safeDivision($tab['sosaCount'], $gen_theoretical); |
|
| 101 | - $gen_equiv += $perc_sosa_count_theor; |
|
| 102 | - $missing=2*$prev_known - $tab['sosaCount']; |
|
| 103 | - $gen_diff=$tab['diffSosaTotalCount']-$prev_diff; |
|
| 94 | + foreach($stats_gen as $gen => $tab){ |
|
| 95 | + $genY1= I18N::translate('-'); |
|
| 96 | + $genY2= I18N::translate('-'); |
|
| 97 | + if($tab['firstBirth']>0) $genY1=$tab['firstBirth']; |
|
| 98 | + if($tab['lastBirth']>0) $genY2=$tab['lastBirth']; |
|
| 99 | + $total_theoretical += $gen_theoretical; |
|
| 100 | + $perc_sosa_count_theor = Functions::safeDivision($tab['sosaCount'], $gen_theoretical); |
|
| 101 | + $gen_equiv += $perc_sosa_count_theor; |
|
| 102 | + $missing=2*$prev_known - $tab['sosaCount']; |
|
| 103 | + $gen_diff=$tab['diffSosaTotalCount']-$prev_diff; |
|
| 104 | 104 | |
| 105 | - $generation_stats[$gen] = array( |
|
| 106 | - 'gen_min_birth' => $genY1, |
|
| 107 | - 'gen_max_birth' => $genY2, |
|
| 108 | - 'theoretical' => $gen_theoretical, |
|
| 109 | - 'known' => $tab['sosaCount'], |
|
| 110 | - 'perc_known' => $perc_sosa_count_theor, |
|
| 111 | - 'missing' => $missing, |
|
| 112 | - 'perc_missing' => 1-Functions::safeDivision($tab['sosaCount'], 2*$prev_known), |
|
| 113 | - 'total_known' => $tab['sosaTotalCount'], |
|
| 114 | - 'perc_total_known' => Functions::safeDivision($tab['sosaTotalCount'], $total_theoretical), |
|
| 115 | - 'different' => $gen_diff, |
|
| 116 | - 'perc_different' => Functions::safeDivision($gen_diff, $tab['sosaCount']), |
|
| 117 | - 'total_different' => $tab['diffSosaTotalCount'], |
|
| 118 | - 'pedi_collapse' => 1 - Functions::safeDivision($tab['diffSosaTotalCount'], $tab['sosaTotalCount']) |
|
| 119 | - ); |
|
| 105 | + $generation_stats[$gen] = array( |
|
| 106 | + 'gen_min_birth' => $genY1, |
|
| 107 | + 'gen_max_birth' => $genY2, |
|
| 108 | + 'theoretical' => $gen_theoretical, |
|
| 109 | + 'known' => $tab['sosaCount'], |
|
| 110 | + 'perc_known' => $perc_sosa_count_theor, |
|
| 111 | + 'missing' => $missing, |
|
| 112 | + 'perc_missing' => 1-Functions::safeDivision($tab['sosaCount'], 2*$prev_known), |
|
| 113 | + 'total_known' => $tab['sosaTotalCount'], |
|
| 114 | + 'perc_total_known' => Functions::safeDivision($tab['sosaTotalCount'], $total_theoretical), |
|
| 115 | + 'different' => $gen_diff, |
|
| 116 | + 'perc_different' => Functions::safeDivision($gen_diff, $tab['sosaCount']), |
|
| 117 | + 'total_different' => $tab['diffSosaTotalCount'], |
|
| 118 | + 'pedi_collapse' => 1 - Functions::safeDivision($tab['diffSosaTotalCount'], $tab['sosaTotalCount']) |
|
| 119 | + ); |
|
| 120 | 120 | |
| 121 | - $gen_theoretical = $gen_theoretical * 2; |
|
| 122 | - $prev_known=$tab['sosaCount']; |
|
| 123 | - $prev_diff=$tab['diffSosaTotalCount']; |
|
| 124 | - } |
|
| 121 | + $gen_theoretical = $gen_theoretical * 2; |
|
| 122 | + $prev_known=$tab['sosaCount']; |
|
| 123 | + $prev_diff=$tab['diffSosaTotalCount']; |
|
| 124 | + } |
|
| 125 | 125 | |
| 126 | - $view_bag->set('generation_stats', $generation_stats); |
|
| 127 | - $view_bag->set('equivalent_gen', $gen_equiv); |
|
| 126 | + $view_bag->set('generation_stats', $generation_stats); |
|
| 127 | + $view_bag->set('equivalent_gen', $gen_equiv); |
|
| 128 | 128 | |
| 129 | - $view_bag->set('chart_img_g2', $this->htmlAncestorDispersionG2()); |
|
| 130 | - $view_bag->set('chart_img_g3', $this->htmlAncestorDispersionG3()); |
|
| 129 | + $view_bag->set('chart_img_g2', $this->htmlAncestorDispersionG2()); |
|
| 130 | + $view_bag->set('chart_img_g3', $this->htmlAncestorDispersionG3()); |
|
| 131 | 131 | |
| 132 | - } |
|
| 132 | + } |
|
| 133 | 133 | |
| 134 | - ViewFactory::make('SosaStats', $this, $controller, $view_bag)->render(); |
|
| 135 | - } |
|
| 134 | + ViewFactory::make('SosaStats', $this, $controller, $view_bag)->render(); |
|
| 135 | + } |
|
| 136 | 136 | |
| 137 | - /** |
|
| 138 | - * Returns HTML code for a graph showing the dispersion of ancestors across father & mother |
|
| 139 | - * @return string HTML code |
|
| 140 | - */ |
|
| 141 | - private function htmlAncestorDispersionG2() |
|
| 142 | - { |
|
| 143 | - $ancestorsDispGen2 = $this->sosa_provider->getAncestorDispersionForGen(2); |
|
| 144 | - if(count($ancestorsDispGen2) == 0) return; |
|
| 137 | + /** |
|
| 138 | + * Returns HTML code for a graph showing the dispersion of ancestors across father & mother |
|
| 139 | + * @return string HTML code |
|
| 140 | + */ |
|
| 141 | + private function htmlAncestorDispersionG2() |
|
| 142 | + { |
|
| 143 | + $ancestorsDispGen2 = $this->sosa_provider->getAncestorDispersionForGen(2); |
|
| 144 | + if(count($ancestorsDispGen2) == 0) return; |
|
| 145 | 145 | |
| 146 | - $size = '600x300'; |
|
| 146 | + $size = '600x300'; |
|
| 147 | 147 | |
| 148 | - $total = array_sum($ancestorsDispGen2); |
|
| 149 | - $father_count = array_key_exists(1, $ancestorsDispGen2) ? $ancestorsDispGen2[1] : 0; |
|
| 150 | - $father = array ( |
|
| 151 | - 'color' => '84beff', |
|
| 152 | - 'count' => $father_count, |
|
| 153 | - 'perc' => Functions::safeDivision($father_count, $total), |
|
| 154 | - 'name' => \Fisharebest\Webtrees\Functions\Functions::getRelationshipNameFromPath('fat') |
|
| 155 | - ); |
|
| 156 | - $mother_count = array_key_exists(2, $ancestorsDispGen2) ? $ancestorsDispGen2[2] : 0; |
|
| 157 | - $mother = array ( |
|
| 158 | - 'color' => 'ffd1dc', |
|
| 159 | - 'count' => $mother_count, |
|
| 160 | - 'perc' => Functions::safeDivision($mother_count, $total), |
|
| 161 | - 'name' => \Fisharebest\Webtrees\Functions\Functions::getRelationshipNameFromPath('mot') |
|
| 162 | - ); |
|
| 163 | - $shared_count = array_key_exists(-1, $ancestorsDispGen2) ? $ancestorsDispGen2[-1] : 0; |
|
| 164 | - $shared = array ( |
|
| 165 | - 'color' => '777777', |
|
| 166 | - 'count' => $shared_count, |
|
| 167 | - 'perc' => Functions::safeDivision($shared_count, $total), |
|
| 168 | - 'name' => I18N::translate('Shared') |
|
| 169 | - ); |
|
| 148 | + $total = array_sum($ancestorsDispGen2); |
|
| 149 | + $father_count = array_key_exists(1, $ancestorsDispGen2) ? $ancestorsDispGen2[1] : 0; |
|
| 150 | + $father = array ( |
|
| 151 | + 'color' => '84beff', |
|
| 152 | + 'count' => $father_count, |
|
| 153 | + 'perc' => Functions::safeDivision($father_count, $total), |
|
| 154 | + 'name' => \Fisharebest\Webtrees\Functions\Functions::getRelationshipNameFromPath('fat') |
|
| 155 | + ); |
|
| 156 | + $mother_count = array_key_exists(2, $ancestorsDispGen2) ? $ancestorsDispGen2[2] : 0; |
|
| 157 | + $mother = array ( |
|
| 158 | + 'color' => 'ffd1dc', |
|
| 159 | + 'count' => $mother_count, |
|
| 160 | + 'perc' => Functions::safeDivision($mother_count, $total), |
|
| 161 | + 'name' => \Fisharebest\Webtrees\Functions\Functions::getRelationshipNameFromPath('mot') |
|
| 162 | + ); |
|
| 163 | + $shared_count = array_key_exists(-1, $ancestorsDispGen2) ? $ancestorsDispGen2[-1] : 0; |
|
| 164 | + $shared = array ( |
|
| 165 | + 'color' => '777777', |
|
| 166 | + 'count' => $shared_count, |
|
| 167 | + 'perc' => Functions::safeDivision($shared_count, $total), |
|
| 168 | + 'name' => I18N::translate('Shared') |
|
| 169 | + ); |
|
| 170 | 170 | |
| 171 | - $chd = $this->arrayToExtendedEncoding(array(4095 * $father['perc'], 4095 * $shared['perc'], 4095 * $mother['perc'])); |
|
| 172 | - $chart_title = I18N::translate('Known Sosa ancestors\' dispersion'); |
|
| 173 | - $chl = |
|
| 174 | - $father['name'] . ' - ' . I18N::percentage($father['perc'], 1) . '|' . |
|
| 175 | - $shared['name'] . ' - ' . I18N::percentage($shared['perc'], 1) . '|' . |
|
| 176 | - $mother['name'] . ' - ' . I18N::percentage($mother['perc'], 1); |
|
| 177 | - return "<img src=\"https://chart.googleapis.com/chart?cht=p&chp=1.5708&chd=e:{$chd}&chs={$size}&chco={$father['color']},{$shared['color']},{$mother['color']}&chf=bg,s,ffffff00&chl={$chl}\" alt=\"" . $chart_title . "\" title=\"" . $chart_title . "\" />"; |
|
| 178 | - } |
|
| 171 | + $chd = $this->arrayToExtendedEncoding(array(4095 * $father['perc'], 4095 * $shared['perc'], 4095 * $mother['perc'])); |
|
| 172 | + $chart_title = I18N::translate('Known Sosa ancestors\' dispersion'); |
|
| 173 | + $chl = |
|
| 174 | + $father['name'] . ' - ' . I18N::percentage($father['perc'], 1) . '|' . |
|
| 175 | + $shared['name'] . ' - ' . I18N::percentage($shared['perc'], 1) . '|' . |
|
| 176 | + $mother['name'] . ' - ' . I18N::percentage($mother['perc'], 1); |
|
| 177 | + return "<img src=\"https://chart.googleapis.com/chart?cht=p&chp=1.5708&chd=e:{$chd}&chs={$size}&chco={$father['color']},{$shared['color']},{$mother['color']}&chf=bg,s,ffffff00&chl={$chl}\" alt=\"" . $chart_title . "\" title=\"" . $chart_title . "\" />"; |
|
| 178 | + } |
|
| 179 | 179 | |
| 180 | - /** |
|
| 181 | - * Returns HTML code for a graph showing the dispersion of ancestors across grand-parents |
|
| 182 | - * @return string HTML code |
|
| 183 | - */ |
|
| 184 | - private function htmlAncestorDispersionG3() |
|
| 185 | - { |
|
| 186 | - $ancestorsDispGen2 = $this->sosa_provider->getAncestorDispersionForGen(3); |
|
| 180 | + /** |
|
| 181 | + * Returns HTML code for a graph showing the dispersion of ancestors across grand-parents |
|
| 182 | + * @return string HTML code |
|
| 183 | + */ |
|
| 184 | + private function htmlAncestorDispersionG3() |
|
| 185 | + { |
|
| 186 | + $ancestorsDispGen2 = $this->sosa_provider->getAncestorDispersionForGen(3); |
|
| 187 | 187 | |
| 188 | - $size = '700x300'; |
|
| 188 | + $size = '700x300'; |
|
| 189 | 189 | |
| 190 | - $color_motmot = 'ffd1dc'; |
|
| 191 | - $color_motfat = 'b998a0'; |
|
| 192 | - $color_fatfat = '577292'; |
|
| 193 | - $color_fatmot = '84beff'; |
|
| 194 | - $color_shared = '777777'; |
|
| 190 | + $color_motmot = 'ffd1dc'; |
|
| 191 | + $color_motfat = 'b998a0'; |
|
| 192 | + $color_fatfat = '577292'; |
|
| 193 | + $color_fatmot = '84beff'; |
|
| 194 | + $color_shared = '777777'; |
|
| 195 | 195 | |
| 196 | - $total_fatfat = array_key_exists(1, $ancestorsDispGen2) ? $ancestorsDispGen2[1] : 0; |
|
| 197 | - $total_fatmot = array_key_exists(2, $ancestorsDispGen2) ? $ancestorsDispGen2[2] : 0; |
|
| 198 | - $total_motfat = array_key_exists(4, $ancestorsDispGen2) ? $ancestorsDispGen2[4] : 0; |
|
| 199 | - $total_motmot = array_key_exists(8, $ancestorsDispGen2) ? $ancestorsDispGen2[8] : 0; |
|
| 200 | - $total_sha = array_key_exists(-1, $ancestorsDispGen2) ? $ancestorsDispGen2[-1] : 0; |
|
| 201 | - $total = $total_fatfat + $total_fatmot + $total_motfat+ $total_motmot + $total_sha; |
|
| 196 | + $total_fatfat = array_key_exists(1, $ancestorsDispGen2) ? $ancestorsDispGen2[1] : 0; |
|
| 197 | + $total_fatmot = array_key_exists(2, $ancestorsDispGen2) ? $ancestorsDispGen2[2] : 0; |
|
| 198 | + $total_motfat = array_key_exists(4, $ancestorsDispGen2) ? $ancestorsDispGen2[4] : 0; |
|
| 199 | + $total_motmot = array_key_exists(8, $ancestorsDispGen2) ? $ancestorsDispGen2[8] : 0; |
|
| 200 | + $total_sha = array_key_exists(-1, $ancestorsDispGen2) ? $ancestorsDispGen2[-1] : 0; |
|
| 201 | + $total = $total_fatfat + $total_fatmot + $total_motfat+ $total_motmot + $total_sha; |
|
| 202 | 202 | |
| 203 | - $chd = $this->arrayToExtendedEncoding(array( |
|
| 204 | - 4095 * Functions::safeDivision($total_fatfat, $total), |
|
| 205 | - 4095 * Functions::safeDivision($total_fatmot, $total), |
|
| 206 | - 4095 * Functions::safeDivision($total_sha, $total), |
|
| 207 | - 4095 * Functions::safeDivision($total_motfat, $total), |
|
| 208 | - 4095 * Functions::safeDivision($total_motmot, $total) |
|
| 209 | - )); |
|
| 210 | - $chart_title = I18N::translate('Known Sosa ancestors\' dispersion - G3'); |
|
| 211 | - $chl = |
|
| 212 | - \Fisharebest\Webtrees\Functions\Functions::getRelationshipNameFromPath('fatfat') . ' - ' . I18N::percentage(Functions::safeDivision($total_fatfat, $total), 1) . '|' . |
|
| 213 | - \Fisharebest\Webtrees\Functions\Functions::getRelationshipNameFromPath('fatmot') . ' - ' . I18N::percentage(Functions::safeDivision($total_fatmot, $total), 1) . '|' . |
|
| 214 | - I18N::translate('Shared') . ' - ' . I18N::percentage(Functions::safeDivision($total_sha, $total), 1) . '|' . |
|
| 215 | - \Fisharebest\Webtrees\Functions\Functions::getRelationshipNameFromPath('motfat') . ' - ' . I18N::percentage(Functions::safeDivision($total_motfat, $total), 1) . '|' . |
|
| 216 | - \Fisharebest\Webtrees\Functions\Functions::getRelationshipNameFromPath('motmot') . ' - ' . I18N::percentage(Functions::safeDivision($total_motmot, $total), 1); |
|
| 217 | - return "<img src=\"https://chart.googleapis.com/chart?cht=p&chp=1.5708&chd=e:{$chd}&chs={$size}&chco={$color_fatfat},{$color_fatmot},{$color_shared},{$color_motfat},{$color_motmot}&chf=bg,s,ffffff00&chl={$chl}\" alt=\"" . $chart_title . "\" title=\"" . $chart_title . "\" />"; |
|
| 218 | - } |
|
| 203 | + $chd = $this->arrayToExtendedEncoding(array( |
|
| 204 | + 4095 * Functions::safeDivision($total_fatfat, $total), |
|
| 205 | + 4095 * Functions::safeDivision($total_fatmot, $total), |
|
| 206 | + 4095 * Functions::safeDivision($total_sha, $total), |
|
| 207 | + 4095 * Functions::safeDivision($total_motfat, $total), |
|
| 208 | + 4095 * Functions::safeDivision($total_motmot, $total) |
|
| 209 | + )); |
|
| 210 | + $chart_title = I18N::translate('Known Sosa ancestors\' dispersion - G3'); |
|
| 211 | + $chl = |
|
| 212 | + \Fisharebest\Webtrees\Functions\Functions::getRelationshipNameFromPath('fatfat') . ' - ' . I18N::percentage(Functions::safeDivision($total_fatfat, $total), 1) . '|' . |
|
| 213 | + \Fisharebest\Webtrees\Functions\Functions::getRelationshipNameFromPath('fatmot') . ' - ' . I18N::percentage(Functions::safeDivision($total_fatmot, $total), 1) . '|' . |
|
| 214 | + I18N::translate('Shared') . ' - ' . I18N::percentage(Functions::safeDivision($total_sha, $total), 1) . '|' . |
|
| 215 | + \Fisharebest\Webtrees\Functions\Functions::getRelationshipNameFromPath('motfat') . ' - ' . I18N::percentage(Functions::safeDivision($total_motfat, $total), 1) . '|' . |
|
| 216 | + \Fisharebest\Webtrees\Functions\Functions::getRelationshipNameFromPath('motmot') . ' - ' . I18N::percentage(Functions::safeDivision($total_motmot, $total), 1); |
|
| 217 | + return "<img src=\"https://chart.googleapis.com/chart?cht=p&chp=1.5708&chd=e:{$chd}&chs={$size}&chco={$color_fatfat},{$color_fatmot},{$color_shared},{$color_motfat},{$color_motmot}&chf=bg,s,ffffff00&chl={$chl}\" alt=\"" . $chart_title . "\" title=\"" . $chart_title . "\" />"; |
|
| 218 | + } |
|
| 219 | 219 | |
| 220 | - /** |
|
| 221 | - * Convert an array to Google Chart encoding |
|
| 222 | - * @param arrat $a Array to encode |
|
| 223 | - * @return string |
|
| 224 | - */ |
|
| 225 | - private function arrayToExtendedEncoding($a) { |
|
| 226 | - $xencoding = WT_GOOGLE_CHART_ENCODING; |
|
| 220 | + /** |
|
| 221 | + * Convert an array to Google Chart encoding |
|
| 222 | + * @param arrat $a Array to encode |
|
| 223 | + * @return string |
|
| 224 | + */ |
|
| 225 | + private function arrayToExtendedEncoding($a) { |
|
| 226 | + $xencoding = WT_GOOGLE_CHART_ENCODING; |
|
| 227 | 227 | |
| 228 | - $encoding = ''; |
|
| 229 | - foreach ($a as $value) { |
|
| 230 | - if ($value < 0) { |
|
| 231 | - $value = 0; |
|
| 232 | - } |
|
| 233 | - $first = (int) ($value / 64); |
|
| 234 | - $second = $value % 64; |
|
| 235 | - $encoding .= $xencoding[(int) $first] . $xencoding[(int) $second]; |
|
| 236 | - } |
|
| 228 | + $encoding = ''; |
|
| 229 | + foreach ($a as $value) { |
|
| 230 | + if ($value < 0) { |
|
| 231 | + $value = 0; |
|
| 232 | + } |
|
| 233 | + $first = (int) ($value / 64); |
|
| 234 | + $second = $value % 64; |
|
| 235 | + $encoding .= $xencoding[(int) $first] . $xencoding[(int) $second]; |
|
| 236 | + } |
|
| 237 | 237 | |
| 238 | - return $encoding; |
|
| 239 | - } |
|
| 238 | + return $encoding; |
|
| 239 | + } |
|
| 240 | 240 | |
| 241 | 241 | |
| 242 | 242 | } |
| 243 | 243 | \ No newline at end of file |
@@ -63,7 +63,7 @@ discard block |
||
| 63 | 63 | $view_bag->set('title', $controller->getPageTitle()); |
| 64 | 64 | $view_bag->set('is_setup', false); |
| 65 | 65 | |
| 66 | - if($this->sosa_provider->isSetup()) { |
|
| 66 | + if ($this->sosa_provider->isSetup()) { |
|
| 67 | 67 | $view_bag->set('is_setup', true); |
| 68 | 68 | |
| 69 | 69 | $view_bag->set('root_indi', $this->sosa_provider->getRootIndi()); |
@@ -84,23 +84,23 @@ discard block |
||
| 84 | 84 | $view_bag->set('missinganc_url', 'module.php?mod='.$this->module->getName().'&mod_action=SosaList@missing&ged='.$WT_TREE->getNameUrl().'&gen='); |
| 85 | 85 | $view_bag->set('sosaanc_url', 'module.php?mod='.$this->module->getName().'&mod_action=SosaList&ged='.$WT_TREE->getNameUrl().'&gen='); |
| 86 | 86 | |
| 87 | - $gen_theoretical=1; |
|
| 88 | - $total_theoretical=0; |
|
| 89 | - $prev_diff=0; |
|
| 90 | - $prev_known=0.5; |
|
| 91 | - $gen_equiv=0; |
|
| 87 | + $gen_theoretical = 1; |
|
| 88 | + $total_theoretical = 0; |
|
| 89 | + $prev_diff = 0; |
|
| 90 | + $prev_known = 0.5; |
|
| 91 | + $gen_equiv = 0; |
|
| 92 | 92 | $generation_stats = array(); |
| 93 | 93 | |
| 94 | - foreach($stats_gen as $gen => $tab){ |
|
| 95 | - $genY1= I18N::translate('-'); |
|
| 96 | - $genY2= I18N::translate('-'); |
|
| 97 | - if($tab['firstBirth']>0) $genY1=$tab['firstBirth']; |
|
| 98 | - if($tab['lastBirth']>0) $genY2=$tab['lastBirth']; |
|
| 94 | + foreach ($stats_gen as $gen => $tab) { |
|
| 95 | + $genY1 = I18N::translate('-'); |
|
| 96 | + $genY2 = I18N::translate('-'); |
|
| 97 | + if ($tab['firstBirth'] > 0) $genY1 = $tab['firstBirth']; |
|
| 98 | + if ($tab['lastBirth'] > 0) $genY2 = $tab['lastBirth']; |
|
| 99 | 99 | $total_theoretical += $gen_theoretical; |
| 100 | 100 | $perc_sosa_count_theor = Functions::safeDivision($tab['sosaCount'], $gen_theoretical); |
| 101 | 101 | $gen_equiv += $perc_sosa_count_theor; |
| 102 | - $missing=2*$prev_known - $tab['sosaCount']; |
|
| 103 | - $gen_diff=$tab['diffSosaTotalCount']-$prev_diff; |
|
| 102 | + $missing = 2 * $prev_known - $tab['sosaCount']; |
|
| 103 | + $gen_diff = $tab['diffSosaTotalCount'] - $prev_diff; |
|
| 104 | 104 | |
| 105 | 105 | $generation_stats[$gen] = array( |
| 106 | 106 | 'gen_min_birth' => $genY1, |
@@ -109,7 +109,7 @@ discard block |
||
| 109 | 109 | 'known' => $tab['sosaCount'], |
| 110 | 110 | 'perc_known' => $perc_sosa_count_theor, |
| 111 | 111 | 'missing' => $missing, |
| 112 | - 'perc_missing' => 1-Functions::safeDivision($tab['sosaCount'], 2*$prev_known), |
|
| 112 | + 'perc_missing' => 1 - Functions::safeDivision($tab['sosaCount'], 2 * $prev_known), |
|
| 113 | 113 | 'total_known' => $tab['sosaTotalCount'], |
| 114 | 114 | 'perc_total_known' => Functions::safeDivision($tab['sosaTotalCount'], $total_theoretical), |
| 115 | 115 | 'different' => $gen_diff, |
@@ -119,8 +119,8 @@ discard block |
||
| 119 | 119 | ); |
| 120 | 120 | |
| 121 | 121 | $gen_theoretical = $gen_theoretical * 2; |
| 122 | - $prev_known=$tab['sosaCount']; |
|
| 123 | - $prev_diff=$tab['diffSosaTotalCount']; |
|
| 122 | + $prev_known = $tab['sosaCount']; |
|
| 123 | + $prev_diff = $tab['diffSosaTotalCount']; |
|
| 124 | 124 | } |
| 125 | 125 | |
| 126 | 126 | $view_bag->set('generation_stats', $generation_stats); |
@@ -141,27 +141,27 @@ discard block |
||
| 141 | 141 | private function htmlAncestorDispersionG2() |
| 142 | 142 | { |
| 143 | 143 | $ancestorsDispGen2 = $this->sosa_provider->getAncestorDispersionForGen(2); |
| 144 | - if(count($ancestorsDispGen2) == 0) return; |
|
| 144 | + if (count($ancestorsDispGen2) == 0) return; |
|
| 145 | 145 | |
| 146 | 146 | $size = '600x300'; |
| 147 | 147 | |
| 148 | 148 | $total = array_sum($ancestorsDispGen2); |
| 149 | 149 | $father_count = array_key_exists(1, $ancestorsDispGen2) ? $ancestorsDispGen2[1] : 0; |
| 150 | - $father = array ( |
|
| 150 | + $father = array( |
|
| 151 | 151 | 'color' => '84beff', |
| 152 | 152 | 'count' => $father_count, |
| 153 | 153 | 'perc' => Functions::safeDivision($father_count, $total), |
| 154 | 154 | 'name' => \Fisharebest\Webtrees\Functions\Functions::getRelationshipNameFromPath('fat') |
| 155 | 155 | ); |
| 156 | 156 | $mother_count = array_key_exists(2, $ancestorsDispGen2) ? $ancestorsDispGen2[2] : 0; |
| 157 | - $mother = array ( |
|
| 157 | + $mother = array( |
|
| 158 | 158 | 'color' => 'ffd1dc', |
| 159 | 159 | 'count' => $mother_count, |
| 160 | 160 | 'perc' => Functions::safeDivision($mother_count, $total), |
| 161 | 161 | 'name' => \Fisharebest\Webtrees\Functions\Functions::getRelationshipNameFromPath('mot') |
| 162 | 162 | ); |
| 163 | 163 | $shared_count = array_key_exists(-1, $ancestorsDispGen2) ? $ancestorsDispGen2[-1] : 0; |
| 164 | - $shared = array ( |
|
| 164 | + $shared = array( |
|
| 165 | 165 | 'color' => '777777', |
| 166 | 166 | 'count' => $shared_count, |
| 167 | 167 | 'perc' => Functions::safeDivision($shared_count, $total), |
@@ -171,10 +171,10 @@ discard block |
||
| 171 | 171 | $chd = $this->arrayToExtendedEncoding(array(4095 * $father['perc'], 4095 * $shared['perc'], 4095 * $mother['perc'])); |
| 172 | 172 | $chart_title = I18N::translate('Known Sosa ancestors\' dispersion'); |
| 173 | 173 | $chl = |
| 174 | - $father['name'] . ' - ' . I18N::percentage($father['perc'], 1) . '|' . |
|
| 175 | - $shared['name'] . ' - ' . I18N::percentage($shared['perc'], 1) . '|' . |
|
| 176 | - $mother['name'] . ' - ' . I18N::percentage($mother['perc'], 1); |
|
| 177 | - return "<img src=\"https://chart.googleapis.com/chart?cht=p&chp=1.5708&chd=e:{$chd}&chs={$size}&chco={$father['color']},{$shared['color']},{$mother['color']}&chf=bg,s,ffffff00&chl={$chl}\" alt=\"" . $chart_title . "\" title=\"" . $chart_title . "\" />"; |
|
| 174 | + $father['name'].' - '.I18N::percentage($father['perc'], 1).'|'. |
|
| 175 | + $shared['name'].' - '.I18N::percentage($shared['perc'], 1).'|'. |
|
| 176 | + $mother['name'].' - '.I18N::percentage($mother['perc'], 1); |
|
| 177 | + return "<img src=\"https://chart.googleapis.com/chart?cht=p&chp=1.5708&chd=e:{$chd}&chs={$size}&chco={$father['color']},{$shared['color']},{$mother['color']}&chf=bg,s,ffffff00&chl={$chl}\" alt=\"".$chart_title."\" title=\"".$chart_title."\" />"; |
|
| 178 | 178 | } |
| 179 | 179 | |
| 180 | 180 | /** |
@@ -198,7 +198,7 @@ discard block |
||
| 198 | 198 | $total_motfat = array_key_exists(4, $ancestorsDispGen2) ? $ancestorsDispGen2[4] : 0; |
| 199 | 199 | $total_motmot = array_key_exists(8, $ancestorsDispGen2) ? $ancestorsDispGen2[8] : 0; |
| 200 | 200 | $total_sha = array_key_exists(-1, $ancestorsDispGen2) ? $ancestorsDispGen2[-1] : 0; |
| 201 | - $total = $total_fatfat + $total_fatmot + $total_motfat+ $total_motmot + $total_sha; |
|
| 201 | + $total = $total_fatfat + $total_fatmot + $total_motfat + $total_motmot + $total_sha; |
|
| 202 | 202 | |
| 203 | 203 | $chd = $this->arrayToExtendedEncoding(array( |
| 204 | 204 | 4095 * Functions::safeDivision($total_fatfat, $total), |
@@ -209,12 +209,12 @@ discard block |
||
| 209 | 209 | )); |
| 210 | 210 | $chart_title = I18N::translate('Known Sosa ancestors\' dispersion - G3'); |
| 211 | 211 | $chl = |
| 212 | - \Fisharebest\Webtrees\Functions\Functions::getRelationshipNameFromPath('fatfat') . ' - ' . I18N::percentage(Functions::safeDivision($total_fatfat, $total), 1) . '|' . |
|
| 213 | - \Fisharebest\Webtrees\Functions\Functions::getRelationshipNameFromPath('fatmot') . ' - ' . I18N::percentage(Functions::safeDivision($total_fatmot, $total), 1) . '|' . |
|
| 214 | - I18N::translate('Shared') . ' - ' . I18N::percentage(Functions::safeDivision($total_sha, $total), 1) . '|' . |
|
| 215 | - \Fisharebest\Webtrees\Functions\Functions::getRelationshipNameFromPath('motfat') . ' - ' . I18N::percentage(Functions::safeDivision($total_motfat, $total), 1) . '|' . |
|
| 216 | - \Fisharebest\Webtrees\Functions\Functions::getRelationshipNameFromPath('motmot') . ' - ' . I18N::percentage(Functions::safeDivision($total_motmot, $total), 1); |
|
| 217 | - return "<img src=\"https://chart.googleapis.com/chart?cht=p&chp=1.5708&chd=e:{$chd}&chs={$size}&chco={$color_fatfat},{$color_fatmot},{$color_shared},{$color_motfat},{$color_motmot}&chf=bg,s,ffffff00&chl={$chl}\" alt=\"" . $chart_title . "\" title=\"" . $chart_title . "\" />"; |
|
| 212 | + \Fisharebest\Webtrees\Functions\Functions::getRelationshipNameFromPath('fatfat').' - '.I18N::percentage(Functions::safeDivision($total_fatfat, $total), 1).'|'. |
|
| 213 | + \Fisharebest\Webtrees\Functions\Functions::getRelationshipNameFromPath('fatmot').' - '.I18N::percentage(Functions::safeDivision($total_fatmot, $total), 1).'|'. |
|
| 214 | + I18N::translate('Shared').' - '.I18N::percentage(Functions::safeDivision($total_sha, $total), 1).'|'. |
|
| 215 | + \Fisharebest\Webtrees\Functions\Functions::getRelationshipNameFromPath('motfat').' - '.I18N::percentage(Functions::safeDivision($total_motfat, $total), 1).'|'. |
|
| 216 | + \Fisharebest\Webtrees\Functions\Functions::getRelationshipNameFromPath('motmot').' - '.I18N::percentage(Functions::safeDivision($total_motmot, $total), 1); |
|
| 217 | + return "<img src=\"https://chart.googleapis.com/chart?cht=p&chp=1.5708&chd=e:{$chd}&chs={$size}&chco={$color_fatfat},{$color_fatmot},{$color_shared},{$color_motfat},{$color_motmot}&chf=bg,s,ffffff00&chl={$chl}\" alt=\"".$chart_title."\" title=\"".$chart_title."\" />"; |
|
| 218 | 218 | } |
| 219 | 219 | |
| 220 | 220 | /** |
@@ -230,9 +230,9 @@ discard block |
||
| 230 | 230 | if ($value < 0) { |
| 231 | 231 | $value = 0; |
| 232 | 232 | } |
| 233 | - $first = (int) ($value / 64); |
|
| 233 | + $first = (int)($value / 64); |
|
| 234 | 234 | $second = $value % 64; |
| 235 | - $encoding .= $xencoding[(int) $first] . $xencoding[(int) $second]; |
|
| 235 | + $encoding .= $xencoding[(int)$first].$xencoding[(int)$second]; |
|
| 236 | 236 | } |
| 237 | 237 | |
| 238 | 238 | return $encoding; |
@@ -94,8 +94,12 @@ discard block |
||
| 94 | 94 | foreach($stats_gen as $gen => $tab){ |
| 95 | 95 | $genY1= I18N::translate('-'); |
| 96 | 96 | $genY2= I18N::translate('-'); |
| 97 | - if($tab['firstBirth']>0) $genY1=$tab['firstBirth']; |
|
| 98 | - if($tab['lastBirth']>0) $genY2=$tab['lastBirth']; |
|
| 97 | + if($tab['firstBirth']>0) { |
|
| 98 | + $genY1=$tab['firstBirth']; |
|
| 99 | + } |
|
| 100 | + if($tab['lastBirth']>0) { |
|
| 101 | + $genY2=$tab['lastBirth']; |
|
| 102 | + } |
|
| 99 | 103 | $total_theoretical += $gen_theoretical; |
| 100 | 104 | $perc_sosa_count_theor = Functions::safeDivision($tab['sosaCount'], $gen_theoretical); |
| 101 | 105 | $gen_equiv += $perc_sosa_count_theor; |
@@ -141,7 +145,9 @@ discard block |
||
| 141 | 145 | private function htmlAncestorDispersionG2() |
| 142 | 146 | { |
| 143 | 147 | $ancestorsDispGen2 = $this->sosa_provider->getAncestorDispersionForGen(2); |
| 144 | - if(count($ancestorsDispGen2) == 0) return; |
|
| 148 | + if(count($ancestorsDispGen2) == 0) { |
|
| 149 | + return; |
|
| 150 | + } |
|
| 145 | 151 | |
| 146 | 152 | $size = '600x300'; |
| 147 | 153 | |
@@ -18,35 +18,35 @@ discard block |
||
| 18 | 18 | */ |
| 19 | 19 | class Dispatcher implements DispatcherInterface { |
| 20 | 20 | |
| 21 | - /** |
|
| 22 | - * @var Dispatcher $instance Singleton pattern instance |
|
| 23 | - */ |
|
| 24 | - private static $instance = null; |
|
| 21 | + /** |
|
| 22 | + * @var Dispatcher $instance Singleton pattern instance |
|
| 23 | + */ |
|
| 24 | + private static $instance = null; |
|
| 25 | 25 | |
| 26 | - /** |
|
| 27 | - * Returns the *Dispatcher* instance of this class. |
|
| 28 | - * |
|
| 29 | - * @return Dispatcher The *Singleton* instance. |
|
| 30 | - */ |
|
| 31 | - public static function getInstance() |
|
| 32 | - { |
|
| 33 | - if (null === static::$instance) { |
|
| 34 | - static::$instance = new static(); |
|
| 35 | - } |
|
| 26 | + /** |
|
| 27 | + * Returns the *Dispatcher* instance of this class. |
|
| 28 | + * |
|
| 29 | + * @return Dispatcher The *Singleton* instance. |
|
| 30 | + */ |
|
| 31 | + public static function getInstance() |
|
| 32 | + { |
|
| 33 | + if (null === static::$instance) { |
|
| 34 | + static::$instance = new static(); |
|
| 35 | + } |
|
| 36 | 36 | |
| 37 | - return static::$instance; |
|
| 38 | - } |
|
| 37 | + return static::$instance; |
|
| 38 | + } |
|
| 39 | 39 | |
| 40 | 40 | /** |
| 41 | - * Protected constructor. |
|
| 42 | - */ |
|
| 43 | - protected function __construct() {} |
|
| 41 | + * Protected constructor. |
|
| 42 | + */ |
|
| 43 | + protected function __construct() {} |
|
| 44 | 44 | |
| 45 | - /** |
|
| 46 | - * {@inheritdoc } |
|
| 47 | - * @see \MyArtJaub\Webtrees\Mvc\DispatcherInterface::handle() |
|
| 48 | - */ |
|
| 49 | - public function handle(fw\Module\AbstractModule $module, $request) { |
|
| 45 | + /** |
|
| 46 | + * {@inheritdoc } |
|
| 47 | + * @see \MyArtJaub\Webtrees\Mvc\DispatcherInterface::handle() |
|
| 48 | + */ |
|
| 49 | + public function handle(fw\Module\AbstractModule $module, $request) { |
|
| 50 | 50 | |
| 51 | 51 | $fq_modclass_name = get_class($module); |
| 52 | 52 | $ctrl_namespace = substr($fq_modclass_name, 0, - strlen('Module')) . '\\'; |
@@ -66,18 +66,18 @@ discard block |
||
| 66 | 66 | |
| 67 | 67 | $ctrl_class = $ctrl_namespace . $ctrl_name . 'Controller'; |
| 68 | 68 | if(class_exists($ctrl_class) |
| 69 | - && is_subclass_of($ctrl_class, '\\MyArtJaub\\Webtrees\\Mvc\\Controller\\MvcController') |
|
| 69 | + && is_subclass_of($ctrl_class, '\\MyArtJaub\\Webtrees\\Mvc\\Controller\\MvcController') |
|
| 70 | 70 | && $ctrl = new $ctrl_class($module) ) { |
| 71 | 71 | if(method_exists($ctrl, $method)) { |
| 72 | - try { |
|
| 73 | - call_user_func_array(array($ctrl, $method), array()); |
|
| 74 | - } |
|
| 75 | - catch (MvcException $ex) { |
|
| 76 | - if(!headers_sent()) { |
|
| 77 | - http_response_code($ex->getHttpCode()); |
|
| 78 | - } |
|
| 79 | - echo $ex->getMessage(); |
|
| 80 | - } |
|
| 72 | + try { |
|
| 73 | + call_user_func_array(array($ctrl, $method), array()); |
|
| 74 | + } |
|
| 75 | + catch (MvcException $ex) { |
|
| 76 | + if(!headers_sent()) { |
|
| 77 | + http_response_code($ex->getHttpCode()); |
|
| 78 | + } |
|
| 79 | + echo $ex->getMessage(); |
|
| 80 | + } |
|
| 81 | 81 | } |
| 82 | 82 | else { |
| 83 | 83 | throw new \Exception('The page requested does not exist'); |
@@ -86,27 +86,27 @@ discard block |
||
| 86 | 86 | else { |
| 87 | 87 | throw new \Exception('The page requested does not exist'); |
| 88 | 88 | } |
| 89 | - } |
|
| 89 | + } |
|
| 90 | 90 | |
| 91 | - /** |
|
| 92 | - * Private clone method to prevent cloning of the instance of the |
|
| 93 | - * *Dispatcher* instance. |
|
| 94 | - * |
|
| 95 | - * @return void |
|
| 96 | - */ |
|
| 97 | - private function __clone() |
|
| 98 | - { |
|
| 99 | - } |
|
| 91 | + /** |
|
| 92 | + * Private clone method to prevent cloning of the instance of the |
|
| 93 | + * *Dispatcher* instance. |
|
| 94 | + * |
|
| 95 | + * @return void |
|
| 96 | + */ |
|
| 97 | + private function __clone() |
|
| 98 | + { |
|
| 99 | + } |
|
| 100 | 100 | |
| 101 | - /** |
|
| 102 | - * Private unserialize method to prevent unserializing of the *Dispatcher* |
|
| 103 | - * instance. |
|
| 104 | - * |
|
| 105 | - * @return void |
|
| 106 | - */ |
|
| 107 | - private function __wakeup() |
|
| 108 | - { |
|
| 109 | - } |
|
| 101 | + /** |
|
| 102 | + * Private unserialize method to prevent unserializing of the *Dispatcher* |
|
| 103 | + * instance. |
|
| 104 | + * |
|
| 105 | + * @return void |
|
| 106 | + */ |
|
| 107 | + private function __wakeup() |
|
| 108 | + { |
|
| 109 | + } |
|
| 110 | 110 | |
| 111 | 111 | } |
| 112 | 112 | |
@@ -49,10 +49,10 @@ discard block |
||
| 49 | 49 | public function handle(fw\Module\AbstractModule $module, $request) { |
| 50 | 50 | |
| 51 | 51 | $fq_modclass_name = get_class($module); |
| 52 | - $ctrl_namespace = substr($fq_modclass_name, 0, - strlen('Module')) . '\\'; |
|
| 52 | + $ctrl_namespace = substr($fq_modclass_name, 0, - strlen('Module')).'\\'; |
|
| 53 | 53 | |
| 54 | - $args = explode( '@', $request, 2); |
|
| 55 | - switch(count($args)) { |
|
| 54 | + $args = explode('@', $request, 2); |
|
| 55 | + switch (count($args)) { |
|
| 56 | 56 | case 1: |
| 57 | 57 | $ctrl_name = $args[0]; |
| 58 | 58 | $method = 'index'; |
@@ -64,16 +64,16 @@ discard block |
||
| 64 | 64 | break; |
| 65 | 65 | } |
| 66 | 66 | |
| 67 | - $ctrl_class = $ctrl_namespace . $ctrl_name . 'Controller'; |
|
| 68 | - if(class_exists($ctrl_class) |
|
| 67 | + $ctrl_class = $ctrl_namespace.$ctrl_name.'Controller'; |
|
| 68 | + if (class_exists($ctrl_class) |
|
| 69 | 69 | && is_subclass_of($ctrl_class, '\\MyArtJaub\\Webtrees\\Mvc\\Controller\\MvcController') |
| 70 | - && $ctrl = new $ctrl_class($module) ) { |
|
| 71 | - if(method_exists($ctrl, $method)) { |
|
| 70 | + && $ctrl = new $ctrl_class($module)) { |
|
| 71 | + if (method_exists($ctrl, $method)) { |
|
| 72 | 72 | try { |
| 73 | 73 | call_user_func_array(array($ctrl, $method), array()); |
| 74 | 74 | } |
| 75 | 75 | catch (MvcException $ex) { |
| 76 | - if(!headers_sent()) { |
|
| 76 | + if (!headers_sent()) { |
|
| 77 | 77 | http_response_code($ex->getHttpCode()); |
| 78 | 78 | } |
| 79 | 79 | echo $ex->getMessage(); |
@@ -71,19 +71,16 @@ |
||
| 71 | 71 | if(method_exists($ctrl, $method)) { |
| 72 | 72 | try { |
| 73 | 73 | call_user_func_array(array($ctrl, $method), array()); |
| 74 | - } |
|
| 75 | - catch (MvcException $ex) { |
|
| 74 | + } catch (MvcException $ex) { |
|
| 76 | 75 | if(!headers_sent()) { |
| 77 | 76 | http_response_code($ex->getHttpCode()); |
| 78 | 77 | } |
| 79 | 78 | echo $ex->getMessage(); |
| 80 | 79 | } |
| 81 | - } |
|
| 82 | - else { |
|
| 80 | + } else { |
|
| 83 | 81 | throw new \Exception('The page requested does not exist'); |
| 84 | 82 | } |
| 85 | - } |
|
| 86 | - else { |
|
| 83 | + } else { |
|
| 87 | 84 | throw new \Exception('The page requested does not exist'); |
| 88 | 85 | } |
| 89 | 86 | } |
@@ -16,52 +16,52 @@ |
||
| 16 | 16 | */ |
| 17 | 17 | class MvcException extends \Exception { |
| 18 | 18 | |
| 19 | - /** @var int[] $VALID_HTTP List of valid HTTP codes */ |
|
| 20 | - protected static $VALID_HTTP = array( |
|
| 21 | - 100, 101, |
|
| 22 | - 200, 201, 202, 203, 204, 205, 206, |
|
| 23 | - 300, 301, 302, 303, 304, 305, 306, 307, |
|
| 24 | - 400, 401, 402, 403, 404, 405, 406, 407, 408, 409, 410, 411, 412, 413, 414, 415, 416, 417, |
|
| 25 | - 500, 501, 502, 503, 504, 505 |
|
| 26 | - ); |
|
| 19 | + /** @var int[] $VALID_HTTP List of valid HTTP codes */ |
|
| 20 | + protected static $VALID_HTTP = array( |
|
| 21 | + 100, 101, |
|
| 22 | + 200, 201, 202, 203, 204, 205, 206, |
|
| 23 | + 300, 301, 302, 303, 304, 305, 306, 307, |
|
| 24 | + 400, 401, 402, 403, 404, 405, 406, 407, 408, 409, 410, 411, 412, 413, 414, 415, 416, 417, |
|
| 25 | + 500, 501, 502, 503, 504, 505 |
|
| 26 | + ); |
|
| 27 | 27 | |
| 28 | - /** @var int $http_code */ |
|
| 29 | - protected $http_code; |
|
| 28 | + /** @var int $http_code */ |
|
| 29 | + protected $http_code; |
|
| 30 | 30 | |
| 31 | - /** |
|
| 32 | - * Constructor for MvcException |
|
| 33 | - * |
|
| 34 | - * @param int $http_code |
|
| 35 | - * @param string $message |
|
| 36 | - * @param int $code |
|
| 37 | - * @param \Throwable $previous |
|
| 38 | - */ |
|
| 39 | - public function __construct($http_code = 500, $message = "", $code = 0, \Throwable $previous = null) { |
|
| 40 | - parent::__construct($message, $code, $previous); |
|
| 31 | + /** |
|
| 32 | + * Constructor for MvcException |
|
| 33 | + * |
|
| 34 | + * @param int $http_code |
|
| 35 | + * @param string $message |
|
| 36 | + * @param int $code |
|
| 37 | + * @param \Throwable $previous |
|
| 38 | + */ |
|
| 39 | + public function __construct($http_code = 500, $message = "", $code = 0, \Throwable $previous = null) { |
|
| 40 | + parent::__construct($message, $code, $previous); |
|
| 41 | 41 | |
| 42 | - $this->http_code = in_array($http_code, self::$VALID_HTTP) ? $http_code : 500; |
|
| 43 | - } |
|
| 42 | + $this->http_code = in_array($http_code, self::$VALID_HTTP) ? $http_code : 500; |
|
| 43 | + } |
|
| 44 | 44 | |
| 45 | - /** |
|
| 46 | - * Get the HTTP code |
|
| 47 | - * |
|
| 48 | - * @return int |
|
| 49 | - */ |
|
| 50 | - public function getHttpCode() { |
|
| 51 | - return $this->http_code; |
|
| 52 | - } |
|
| 45 | + /** |
|
| 46 | + * Get the HTTP code |
|
| 47 | + * |
|
| 48 | + * @return int |
|
| 49 | + */ |
|
| 50 | + public function getHttpCode() { |
|
| 51 | + return $this->http_code; |
|
| 52 | + } |
|
| 53 | 53 | |
| 54 | - /** |
|
| 55 | - * Set the HTTP code |
|
| 56 | - * |
|
| 57 | - * @param int $http_code |
|
| 58 | - * @throws InvalidArgumentException Thrown if not valid Http code |
|
| 59 | - */ |
|
| 60 | - public function setHttpCode($http_code) { |
|
| 61 | - if(!in_array($http_code, self::$VALID_HTTP)) |
|
| 62 | - throw new \InvalidArgumentException('Invalid HTTP code'); |
|
| 63 | - $this->http_code= $http_code; |
|
| 64 | - } |
|
| 54 | + /** |
|
| 55 | + * Set the HTTP code |
|
| 56 | + * |
|
| 57 | + * @param int $http_code |
|
| 58 | + * @throws InvalidArgumentException Thrown if not valid Http code |
|
| 59 | + */ |
|
| 60 | + public function setHttpCode($http_code) { |
|
| 61 | + if(!in_array($http_code, self::$VALID_HTTP)) |
|
| 62 | + throw new \InvalidArgumentException('Invalid HTTP code'); |
|
| 63 | + $this->http_code= $http_code; |
|
| 64 | + } |
|
| 65 | 65 | |
| 66 | 66 | } |
| 67 | 67 | |
@@ -17,7 +17,7 @@ discard block |
||
| 17 | 17 | class MvcException extends \Exception { |
| 18 | 18 | |
| 19 | 19 | /** @var int[] $VALID_HTTP List of valid HTTP codes */ |
| 20 | - protected static $VALID_HTTP = array( |
|
| 20 | + protected static $VALID_HTTP = array( |
|
| 21 | 21 | 100, 101, |
| 22 | 22 | 200, 201, 202, 203, 204, 205, 206, |
| 23 | 23 | 300, 301, 302, 303, 304, 305, 306, 307, |
@@ -58,9 +58,9 @@ discard block |
||
| 58 | 58 | * @throws InvalidArgumentException Thrown if not valid Http code |
| 59 | 59 | */ |
| 60 | 60 | public function setHttpCode($http_code) { |
| 61 | - if(!in_array($http_code, self::$VALID_HTTP)) |
|
| 61 | + if (!in_array($http_code, self::$VALID_HTTP)) |
|
| 62 | 62 | throw new \InvalidArgumentException('Invalid HTTP code'); |
| 63 | - $this->http_code= $http_code; |
|
| 63 | + $this->http_code = $http_code; |
|
| 64 | 64 | } |
| 65 | 65 | |
| 66 | 66 | } |
@@ -58,8 +58,9 @@ |
||
| 58 | 58 | * @throws InvalidArgumentException Thrown if not valid Http code |
| 59 | 59 | */ |
| 60 | 60 | public function setHttpCode($http_code) { |
| 61 | - if(!in_array($http_code, self::$VALID_HTTP)) |
|
| 62 | - throw new \InvalidArgumentException('Invalid HTTP code'); |
|
| 61 | + if(!in_array($http_code, self::$VALID_HTTP)) { |
|
| 62 | + throw new \InvalidArgumentException('Invalid HTTP code'); |
|
| 63 | + } |
|
| 63 | 64 | $this->http_code= $http_code; |
| 64 | 65 | } |
| 65 | 66 | |
@@ -19,59 +19,59 @@ |
||
| 19 | 19 | * Hooks Module. |
| 20 | 20 | */ |
| 21 | 21 | class HooksModule extends AbstractModule implements ModuleConfigInterface, DependentInterface { |
| 22 | - // How to update the database schema for this module |
|
| 23 | - const SCHEMA_TARGET_VERSION = 1; |
|
| 24 | - const SCHEMA_SETTING_NAME = 'MAJ_HOOKS_SCHEMA_VERSION'; |
|
| 25 | - const SCHEMA_MIGRATION_PREFIX = '\MyArtJaub\Webtrees\Module\Hooks\Schema'; |
|
| 22 | + // How to update the database schema for this module |
|
| 23 | + const SCHEMA_TARGET_VERSION = 1; |
|
| 24 | + const SCHEMA_SETTING_NAME = 'MAJ_HOOKS_SCHEMA_VERSION'; |
|
| 25 | + const SCHEMA_MIGRATION_PREFIX = '\MyArtJaub\Webtrees\Module\Hooks\Schema'; |
|
| 26 | 26 | |
| 27 | - /** @var string For custom modules - link for support, upgrades, etc. */ |
|
| 28 | - const CUSTOM_WEBSITE = 'https://github.com/jon48/webtrees-lib'; |
|
| 27 | + /** @var string For custom modules - link for support, upgrades, etc. */ |
|
| 28 | + const CUSTOM_WEBSITE = 'https://github.com/jon48/webtrees-lib'; |
|
| 29 | 29 | |
| 30 | - /** |
|
| 31 | - * {@inhericDoc} |
|
| 32 | - */ |
|
| 33 | - public function getTitle() { |
|
| 34 | - return /* I18N: Name of the “Hooks” module */ I18N::translate('Hooks'); |
|
| 35 | - } |
|
| 30 | + /** |
|
| 31 | + * {@inhericDoc} |
|
| 32 | + */ |
|
| 33 | + public function getTitle() { |
|
| 34 | + return /* I18N: Name of the “Hooks” module */ I18N::translate('Hooks'); |
|
| 35 | + } |
|
| 36 | 36 | |
| 37 | - /** |
|
| 38 | - * {@inhericDoc} |
|
| 39 | - */ |
|
| 40 | - public function getDescription() { |
|
| 41 | - return /* I18N: Description of the “Hooks” module */ I18N::translate('Implements hooks management.'); |
|
| 42 | - } |
|
| 37 | + /** |
|
| 38 | + * {@inhericDoc} |
|
| 39 | + */ |
|
| 40 | + public function getDescription() { |
|
| 41 | + return /* I18N: Description of the “Hooks” module */ I18N::translate('Implements hooks management.'); |
|
| 42 | + } |
|
| 43 | 43 | |
| 44 | - /** |
|
| 45 | - * {@inhericDoc} |
|
| 46 | - */ |
|
| 47 | - public function modAction($mod_action) { |
|
| 48 | - Database::updateSchema(self::SCHEMA_MIGRATION_PREFIX, self::SCHEMA_SETTING_NAME, self::SCHEMA_TARGET_VERSION); |
|
| 44 | + /** |
|
| 45 | + * {@inhericDoc} |
|
| 46 | + */ |
|
| 47 | + public function modAction($mod_action) { |
|
| 48 | + Database::updateSchema(self::SCHEMA_MIGRATION_PREFIX, self::SCHEMA_SETTING_NAME, self::SCHEMA_TARGET_VERSION); |
|
| 49 | 49 | |
| 50 | - \MyArtJaub\Webtrees\Mvc\Dispatcher::getInstance()->handle($this, $mod_action); |
|
| 51 | - } |
|
| 50 | + \MyArtJaub\Webtrees\Mvc\Dispatcher::getInstance()->handle($this, $mod_action); |
|
| 51 | + } |
|
| 52 | 52 | |
| 53 | - /** |
|
| 54 | - * {@inhericDoc} |
|
| 55 | - * @see \Fisharebest\Webtrees\Module\ModuleConfigInterface::getConfigLink() |
|
| 56 | - */ |
|
| 57 | - public function getConfigLink() { |
|
| 58 | - Database::updateSchema(self::SCHEMA_MIGRATION_PREFIX, self::SCHEMA_SETTING_NAME, self::SCHEMA_TARGET_VERSION); |
|
| 53 | + /** |
|
| 54 | + * {@inhericDoc} |
|
| 55 | + * @see \Fisharebest\Webtrees\Module\ModuleConfigInterface::getConfigLink() |
|
| 56 | + */ |
|
| 57 | + public function getConfigLink() { |
|
| 58 | + Database::updateSchema(self::SCHEMA_MIGRATION_PREFIX, self::SCHEMA_SETTING_NAME, self::SCHEMA_TARGET_VERSION); |
|
| 59 | 59 | |
| 60 | - return 'module.php?mod=' . $this->getName() . '&mod_action=AdminConfig'; |
|
| 61 | - } |
|
| 60 | + return 'module.php?mod=' . $this->getName() . '&mod_action=AdminConfig'; |
|
| 61 | + } |
|
| 62 | 62 | |
| 63 | - /** |
|
| 64 | - * {@inheritDoc} |
|
| 65 | - * @see \MyArtJaub\Webtrees\Module\DependentInterface::validatePrerequisites() |
|
| 66 | - */ |
|
| 67 | - public function validatePrerequisites() { |
|
| 68 | - try { |
|
| 69 | - Database::updateSchema(self::SCHEMA_MIGRATION_PREFIX, self::SCHEMA_SETTING_NAME, self::SCHEMA_TARGET_VERSION); |
|
| 70 | - return true; |
|
| 71 | - } |
|
| 72 | - catch (\Exception $ex) { } |
|
| 73 | - return false; |
|
| 74 | - } |
|
| 63 | + /** |
|
| 64 | + * {@inheritDoc} |
|
| 65 | + * @see \MyArtJaub\Webtrees\Module\DependentInterface::validatePrerequisites() |
|
| 66 | + */ |
|
| 67 | + public function validatePrerequisites() { |
|
| 68 | + try { |
|
| 69 | + Database::updateSchema(self::SCHEMA_MIGRATION_PREFIX, self::SCHEMA_SETTING_NAME, self::SCHEMA_TARGET_VERSION); |
|
| 70 | + return true; |
|
| 71 | + } |
|
| 72 | + catch (\Exception $ex) { } |
|
| 73 | + return false; |
|
| 74 | + } |
|
| 75 | 75 | |
| 76 | 76 | |
| 77 | 77 | } |
@@ -68,8 +68,7 @@ |
||
| 68 | 68 | try { |
| 69 | 69 | Database::updateSchema(self::SCHEMA_MIGRATION_PREFIX, self::SCHEMA_SETTING_NAME, self::SCHEMA_TARGET_VERSION); |
| 70 | 70 | return true; |
| 71 | - } |
|
| 72 | - catch (\Exception $ex) { } |
|
| 71 | + } catch (\Exception $ex) { } |
|
| 73 | 72 | return false; |
| 74 | 73 | } |
| 75 | 74 | |
@@ -57,7 +57,7 @@ |
||
| 57 | 57 | public function getConfigLink() { |
| 58 | 58 | Database::updateSchema(self::SCHEMA_MIGRATION_PREFIX, self::SCHEMA_SETTING_NAME, self::SCHEMA_TARGET_VERSION); |
| 59 | 59 | |
| 60 | - return 'module.php?mod=' . $this->getName() . '&mod_action=AdminConfig'; |
|
| 60 | + return 'module.php?mod='.$this->getName().'&mod_action=AdminConfig'; |
|
| 61 | 61 | } |
| 62 | 62 | |
| 63 | 63 | /** |
@@ -277,7 +277,7 @@ discard block |
||
| 277 | 277 | /** |
| 278 | 278 | * Get an associative array of Sosa individuals in generation G. Keys are Sosa numbers, values individuals. |
| 279 | 279 | * |
| 280 | - * @param number $gen Generation |
|
| 280 | + * @param integer $gen Generation |
|
| 281 | 281 | * @return array Array of Sosa individuals |
| 282 | 282 | */ |
| 283 | 283 | public function getSosaListAtGeneration($gen){ |
@@ -308,7 +308,7 @@ discard block |
||
| 308 | 308 | /** |
| 309 | 309 | * Get an associative array of Sosa families in generation G. Keys are Sosa numbers for the husband, values families. |
| 310 | 310 | * |
| 311 | - * @param number $gen Generation |
|
| 311 | + * @param integer $gen Generation |
|
| 312 | 312 | * @return array Array of Sosa families |
| 313 | 313 | */ |
| 314 | 314 | public function getFamilySosaListAtGeneration($gen){ |
@@ -344,7 +344,7 @@ discard block |
||
| 344 | 344 | /** |
| 345 | 345 | * Get an associative array of Sosa individuals in generation G who are missing parents. Keys are Sosa numbers, values individuals. |
| 346 | 346 | * |
| 347 | - * @param number $gen Generation |
|
| 347 | + * @param integer $gen Generation |
|
| 348 | 348 | * @return array Array of Sosa individuals |
| 349 | 349 | */ |
| 350 | 350 | public function getMissingSosaListAtGeneration($gen){ |
@@ -439,8 +439,8 @@ discard block |
||
| 439 | 439 | /** |
| 440 | 440 | * Get the number of Sosa in a specific generation. |
| 441 | 441 | * |
| 442 | - * @param number $gen Generation |
|
| 443 | - * @return number Number of Sosas in generation |
|
| 442 | + * @param integer $gen Generation |
|
| 443 | + * @return integer Number of Sosas in generation |
|
| 444 | 444 | */ |
| 445 | 445 | public function getSosaCountAtGeneration($gen){ |
| 446 | 446 | if(!$this->is_setup) return 0; |
@@ -458,7 +458,7 @@ discard block |
||
| 458 | 458 | /** |
| 459 | 459 | * Get the total number of Sosa up to a specific generation. |
| 460 | 460 | * |
| 461 | - * @param number $gen Generation |
|
| 461 | + * @param integer $gen Generation |
|
| 462 | 462 | * @return number Total number of Sosas up to generation |
| 463 | 463 | */ |
| 464 | 464 | public function getSosaCountUpToGeneration($gen){ |
@@ -493,7 +493,7 @@ discard block |
||
| 493 | 493 | /** |
| 494 | 494 | * Get the number of distinct Sosa individual up to a specific generation. |
| 495 | 495 | * |
| 496 | - * @param number $gen Generation |
|
| 496 | + * @param integer $gen Generation |
|
| 497 | 497 | * @return number Number of distinct Sosa individuals up to generation |
| 498 | 498 | */ |
| 499 | 499 | public function getDifferentSosaCountUpToGeneration($gen){ |
@@ -516,7 +516,7 @@ discard block |
||
| 516 | 516 | * - last : Last birth year in generation |
| 517 | 517 | * - avg : Average birth year |
| 518 | 518 | * |
| 519 | - * @param number $gen Generation |
|
| 519 | + * @param integer $gen Generation |
|
| 520 | 520 | * @return array Birth statistics array |
| 521 | 521 | */ |
| 522 | 522 | public function getStatsBirthYearInGeneration($gen){ |
@@ -22,389 +22,389 @@ discard block |
||
| 22 | 22 | */ |
| 23 | 23 | class SosaProvider { |
| 24 | 24 | |
| 25 | - /** |
|
| 26 | - * Maximum number of generation the database is able to hold. |
|
| 27 | - * @var int MAX_DB_GENERATIONS |
|
| 28 | - */ |
|
| 29 | - const MAX_DB_GENERATIONS = 64; |
|
| 30 | - |
|
| 31 | - /** |
|
| 32 | - * System's default user (ID -1 in the database |
|
| 33 | - * @var User $default_user |
|
| 34 | - */ |
|
| 35 | - protected static $default_user; |
|
| 36 | - |
|
| 37 | - /** |
|
| 38 | - * Reference user |
|
| 39 | - * @var User $user |
|
| 40 | - */ |
|
| 41 | - protected $user; |
|
| 42 | - |
|
| 43 | - /** |
|
| 44 | - * Reference tree |
|
| 45 | - * @var Tree $tree |
|
| 46 | - */ |
|
| 47 | - protected $tree; |
|
| 48 | - |
|
| 49 | - /** |
|
| 50 | - * Cached list of Sosa Individuals by generation |
|
| 51 | - * Format: key = generation, value = array ( sosa => Individual ID) |
|
| 52 | - * @var array $sosa_list_by_gen |
|
| 53 | - */ |
|
| 54 | - protected $sosa_list_by_gen; |
|
| 55 | - |
|
| 56 | - /** |
|
| 57 | - * Cached list of Sosa Families by generation |
|
| 58 | - * Format: key = generation, value = array ( sosa => Family ID) |
|
| 59 | - * @var unknown $sosa_fam_list_by_gen |
|
| 60 | - */ |
|
| 61 | - protected $sosa_fam_list_by_gen; |
|
| 62 | - |
|
| 63 | - /** |
|
| 64 | - * Cached array of statistics by generation |
|
| 65 | - * Format: key = generation, |
|
| 66 | - * value = array( |
|
| 67 | - * sosaCount, sosaTotalCount, diffSosaTotalCount, firstBirth, lastBirth, avgBirth |
|
| 68 | - * ) |
|
| 69 | - * @var array $statistics_tab |
|
| 70 | - */ |
|
| 71 | - protected $statistics_tab; |
|
| 72 | - |
|
| 73 | - /** |
|
| 74 | - * Has the provider's initialisation completed |
|
| 75 | - * @var bool $is_setup |
|
| 76 | - */ |
|
| 77 | - protected $is_setup; |
|
| 78 | - |
|
| 79 | - /** |
|
| 80 | - * Constructor for Sosa Provider. |
|
| 81 | - * A provider is defined in relation to a specific tree and reference user. |
|
| 82 | - * |
|
| 83 | - * @param Tree $tree |
|
| 84 | - * @param User $user |
|
| 85 | - */ |
|
| 86 | - public function __construct(Tree $tree, User $user = null) { |
|
| 87 | - if(self::$default_user === null) |
|
| 88 | - self::$default_user = User::find(-1); |
|
| 25 | + /** |
|
| 26 | + * Maximum number of generation the database is able to hold. |
|
| 27 | + * @var int MAX_DB_GENERATIONS |
|
| 28 | + */ |
|
| 29 | + const MAX_DB_GENERATIONS = 64; |
|
| 30 | + |
|
| 31 | + /** |
|
| 32 | + * System's default user (ID -1 in the database |
|
| 33 | + * @var User $default_user |
|
| 34 | + */ |
|
| 35 | + protected static $default_user; |
|
| 36 | + |
|
| 37 | + /** |
|
| 38 | + * Reference user |
|
| 39 | + * @var User $user |
|
| 40 | + */ |
|
| 41 | + protected $user; |
|
| 42 | + |
|
| 43 | + /** |
|
| 44 | + * Reference tree |
|
| 45 | + * @var Tree $tree |
|
| 46 | + */ |
|
| 47 | + protected $tree; |
|
| 48 | + |
|
| 49 | + /** |
|
| 50 | + * Cached list of Sosa Individuals by generation |
|
| 51 | + * Format: key = generation, value = array ( sosa => Individual ID) |
|
| 52 | + * @var array $sosa_list_by_gen |
|
| 53 | + */ |
|
| 54 | + protected $sosa_list_by_gen; |
|
| 55 | + |
|
| 56 | + /** |
|
| 57 | + * Cached list of Sosa Families by generation |
|
| 58 | + * Format: key = generation, value = array ( sosa => Family ID) |
|
| 59 | + * @var unknown $sosa_fam_list_by_gen |
|
| 60 | + */ |
|
| 61 | + protected $sosa_fam_list_by_gen; |
|
| 62 | + |
|
| 63 | + /** |
|
| 64 | + * Cached array of statistics by generation |
|
| 65 | + * Format: key = generation, |
|
| 66 | + * value = array( |
|
| 67 | + * sosaCount, sosaTotalCount, diffSosaTotalCount, firstBirth, lastBirth, avgBirth |
|
| 68 | + * ) |
|
| 69 | + * @var array $statistics_tab |
|
| 70 | + */ |
|
| 71 | + protected $statistics_tab; |
|
| 72 | + |
|
| 73 | + /** |
|
| 74 | + * Has the provider's initialisation completed |
|
| 75 | + * @var bool $is_setup |
|
| 76 | + */ |
|
| 77 | + protected $is_setup; |
|
| 78 | + |
|
| 79 | + /** |
|
| 80 | + * Constructor for Sosa Provider. |
|
| 81 | + * A provider is defined in relation to a specific tree and reference user. |
|
| 82 | + * |
|
| 83 | + * @param Tree $tree |
|
| 84 | + * @param User $user |
|
| 85 | + */ |
|
| 86 | + public function __construct(Tree $tree, User $user = null) { |
|
| 87 | + if(self::$default_user === null) |
|
| 88 | + self::$default_user = User::find(-1); |
|
| 89 | 89 | |
| 90 | - $this->tree = $tree; |
|
| 91 | - $this->user = $user; |
|
| 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; |
|
| 90 | + $this->tree = $tree; |
|
| 91 | + $this->user = $user; |
|
| 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; |
|
| 95 | 95 | |
| 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 |
|
| 99 | - $this->is_setup = false; |
|
| 100 | - } |
|
| 101 | - else { |
|
| 102 | - $this->user = self::$default_user; |
|
| 103 | - $this->is_setup = $this->getRootIndiId() === null; |
|
| 104 | - } |
|
| 105 | - } |
|
| 106 | - } |
|
| 107 | - |
|
| 108 | - /** |
|
| 109 | - * Returns is the Provider has been successfully set up |
|
| 110 | - * @return bool |
|
| 111 | - */ |
|
| 112 | - public function isSetup() { |
|
| 113 | - return $this->is_setup; |
|
| 114 | - } |
|
| 115 | - |
|
| 116 | - /** |
|
| 117 | - * Return the root individual ID for the reference tree and user. |
|
| 118 | - * @return string Individual ID |
|
| 119 | - */ |
|
| 120 | - public function getRootIndiId() { |
|
| 121 | - return $this->tree->getUserPreference($this->user, 'MAJ_SOSA_ROOT_ID'); |
|
| 122 | - } |
|
| 123 | - |
|
| 124 | - /** |
|
| 125 | - * Return the root individual for the reference tree and user. |
|
| 126 | - * @return Individual Individual |
|
| 127 | - */ |
|
| 128 | - public function getRootIndi() { |
|
| 129 | - $root_indi_id = $this->getRootIndiId(); |
|
| 130 | - if(!empty($root_indi_id)) { |
|
| 131 | - return Individual::getInstance($root_indi_id, $this->tree); |
|
| 132 | - } |
|
| 133 | - return null; |
|
| 134 | - } |
|
| 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 |
|
| 99 | + $this->is_setup = false; |
|
| 100 | + } |
|
| 101 | + else { |
|
| 102 | + $this->user = self::$default_user; |
|
| 103 | + $this->is_setup = $this->getRootIndiId() === null; |
|
| 104 | + } |
|
| 105 | + } |
|
| 106 | + } |
|
| 107 | + |
|
| 108 | + /** |
|
| 109 | + * Returns is the Provider has been successfully set up |
|
| 110 | + * @return bool |
|
| 111 | + */ |
|
| 112 | + public function isSetup() { |
|
| 113 | + return $this->is_setup; |
|
| 114 | + } |
|
| 115 | + |
|
| 116 | + /** |
|
| 117 | + * Return the root individual ID for the reference tree and user. |
|
| 118 | + * @return string Individual ID |
|
| 119 | + */ |
|
| 120 | + public function getRootIndiId() { |
|
| 121 | + return $this->tree->getUserPreference($this->user, 'MAJ_SOSA_ROOT_ID'); |
|
| 122 | + } |
|
| 123 | + |
|
| 124 | + /** |
|
| 125 | + * Return the root individual for the reference tree and user. |
|
| 126 | + * @return Individual Individual |
|
| 127 | + */ |
|
| 128 | + public function getRootIndi() { |
|
| 129 | + $root_indi_id = $this->getRootIndiId(); |
|
| 130 | + if(!empty($root_indi_id)) { |
|
| 131 | + return Individual::getInstance($root_indi_id, $this->tree); |
|
| 132 | + } |
|
| 133 | + return null; |
|
| 134 | + } |
|
| 135 | 135 | |
| 136 | - /***************** |
|
| 136 | + /***************** |
|
| 137 | 137 | * DATA CRUD LAYER |
| 138 | 138 | *****************/ |
| 139 | 139 | |
| 140 | - /** |
|
| 141 | - * Remove all Sosa entries related to the gedcom file and user |
|
| 142 | - */ |
|
| 143 | - public function deleteAll() { |
|
| 144 | - if(!$this->is_setup) return; |
|
| 145 | - Database::prepare( |
|
| 146 | - 'DELETE FROM `##maj_sosa`'. |
|
| 147 | - ' WHERE majs_gedcom_id= :tree_id and majs_user_id = :user_id ') |
|
| 148 | - ->execute(array( |
|
| 149 | - 'tree_id' => $this->tree->getTreeId(), |
|
| 150 | - 'user_id' => $this->user->getUserId() |
|
| 151 | - )); |
|
| 152 | - } |
|
| 153 | - |
|
| 154 | - /** |
|
| 155 | - * Remove all ancestors of a sosa number |
|
| 156 | - * |
|
| 157 | - * @param int $sosa |
|
| 158 | - */ |
|
| 159 | - public function deleteAncestors($sosa) { |
|
| 160 | - if(!$this->is_setup) return; |
|
| 161 | - $gen = Functions::getGeneration($sosa); |
|
| 162 | - Database::prepare( |
|
| 163 | - 'DELETE FROM `##maj_sosa`'. |
|
| 164 | - ' WHERE majs_gedcom_id=:tree_id and majs_user_id = :user_id' . |
|
| 165 | - ' AND majs_gen >= :gen' . |
|
| 166 | - ' AND FLOOR(majs_sosa / (POW(2, (majs_gen - :gen)))) = :sosa' |
|
| 167 | - )->execute(array( |
|
| 168 | - 'tree_id' => $this->tree->getTreeId(), |
|
| 169 | - 'user_id' => $this->user->getUserId(), |
|
| 170 | - 'gen' => $gen, |
|
| 171 | - 'sosa' => $sosa |
|
| 172 | - )); |
|
| 173 | - } |
|
| 174 | - |
|
| 175 | - /** |
|
| 176 | - * Insert (or update if already existing) a list of Sosa individuals |
|
| 177 | - * @param array $sosa_records |
|
| 178 | - */ |
|
| 179 | - public function insertOrUpdate($sosa_records) { |
|
| 180 | - if(!$this->is_setup) return; |
|
| 140 | + /** |
|
| 141 | + * Remove all Sosa entries related to the gedcom file and user |
|
| 142 | + */ |
|
| 143 | + public function deleteAll() { |
|
| 144 | + if(!$this->is_setup) return; |
|
| 145 | + Database::prepare( |
|
| 146 | + 'DELETE FROM `##maj_sosa`'. |
|
| 147 | + ' WHERE majs_gedcom_id= :tree_id and majs_user_id = :user_id ') |
|
| 148 | + ->execute(array( |
|
| 149 | + 'tree_id' => $this->tree->getTreeId(), |
|
| 150 | + 'user_id' => $this->user->getUserId() |
|
| 151 | + )); |
|
| 152 | + } |
|
| 153 | + |
|
| 154 | + /** |
|
| 155 | + * Remove all ancestors of a sosa number |
|
| 156 | + * |
|
| 157 | + * @param int $sosa |
|
| 158 | + */ |
|
| 159 | + public function deleteAncestors($sosa) { |
|
| 160 | + if(!$this->is_setup) return; |
|
| 161 | + $gen = Functions::getGeneration($sosa); |
|
| 162 | + Database::prepare( |
|
| 163 | + 'DELETE FROM `##maj_sosa`'. |
|
| 164 | + ' WHERE majs_gedcom_id=:tree_id and majs_user_id = :user_id' . |
|
| 165 | + ' AND majs_gen >= :gen' . |
|
| 166 | + ' AND FLOOR(majs_sosa / (POW(2, (majs_gen - :gen)))) = :sosa' |
|
| 167 | + )->execute(array( |
|
| 168 | + 'tree_id' => $this->tree->getTreeId(), |
|
| 169 | + 'user_id' => $this->user->getUserId(), |
|
| 170 | + 'gen' => $gen, |
|
| 171 | + 'sosa' => $sosa |
|
| 172 | + )); |
|
| 173 | + } |
|
| 174 | + |
|
| 175 | + /** |
|
| 176 | + * Insert (or update if already existing) a list of Sosa individuals |
|
| 177 | + * @param array $sosa_records |
|
| 178 | + */ |
|
| 179 | + public function insertOrUpdate($sosa_records) { |
|
| 180 | + if(!$this->is_setup) return; |
|
| 181 | 181 | |
| 182 | - $treeid = $this->tree->getTreeId(); |
|
| 183 | - $userid = $this->user->getUserId(); |
|
| 184 | - $questionmarks_table = array(); |
|
| 185 | - $values_table = array(); |
|
| 182 | + $treeid = $this->tree->getTreeId(); |
|
| 183 | + $userid = $this->user->getUserId(); |
|
| 184 | + $questionmarks_table = array(); |
|
| 185 | + $values_table = array(); |
|
| 186 | 186 | |
| 187 | - $i = 0; |
|
| 188 | - foreach ($sosa_records as $row) { |
|
| 189 | - $gen = Functions::getGeneration($row['sosa']); |
|
| 190 | - if($gen <= self::MAX_DB_GENERATIONS) { |
|
| 191 | - $questionmarks_table[] = |
|
| 192 | - '(:tree_id'.$i.', :user_id'.$i.', :sosa'.$i.', :indi_id'.$i.', :gen'.$i.', :byear'.$i.', :dyear'.$i.')'; |
|
| 193 | - $values_table = array_merge( |
|
| 194 | - $values_table, |
|
| 195 | - array( |
|
| 196 | - 'tree_id'.$i => $treeid, |
|
| 197 | - 'user_id'.$i => $userid, |
|
| 198 | - 'sosa'.$i => $row['sosa'], |
|
| 199 | - 'indi_id'.$i => $row['indi'], |
|
| 200 | - 'gen'.$i => Functions::getGeneration($row['sosa']), |
|
| 201 | - 'byear'.$i => $row['birth_year'], |
|
| 202 | - 'dyear'.$i => $row['death_year'] |
|
| 203 | - ) |
|
| 204 | - ); |
|
| 205 | - } |
|
| 206 | - $i++; |
|
| 207 | - } |
|
| 187 | + $i = 0; |
|
| 188 | + foreach ($sosa_records as $row) { |
|
| 189 | + $gen = Functions::getGeneration($row['sosa']); |
|
| 190 | + if($gen <= self::MAX_DB_GENERATIONS) { |
|
| 191 | + $questionmarks_table[] = |
|
| 192 | + '(:tree_id'.$i.', :user_id'.$i.', :sosa'.$i.', :indi_id'.$i.', :gen'.$i.', :byear'.$i.', :dyear'.$i.')'; |
|
| 193 | + $values_table = array_merge( |
|
| 194 | + $values_table, |
|
| 195 | + array( |
|
| 196 | + 'tree_id'.$i => $treeid, |
|
| 197 | + 'user_id'.$i => $userid, |
|
| 198 | + 'sosa'.$i => $row['sosa'], |
|
| 199 | + 'indi_id'.$i => $row['indi'], |
|
| 200 | + 'gen'.$i => Functions::getGeneration($row['sosa']), |
|
| 201 | + 'byear'.$i => $row['birth_year'], |
|
| 202 | + 'dyear'.$i => $row['death_year'] |
|
| 203 | + ) |
|
| 204 | + ); |
|
| 205 | + } |
|
| 206 | + $i++; |
|
| 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); |
|
| 212 | - Database::prepare($sql)->execute($values_table); |
|
| 213 | - } |
|
| 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 | + Database::prepare($sql)->execute($values_table); |
|
| 213 | + } |
|
| 214 | 214 | |
| 215 | - /**************** |
|
| 215 | + /**************** |
|
| 216 | 216 | * SIMPLE QUERIES |
| 217 | 217 | ****************/ |
| 218 | 218 | |
| 219 | - /** |
|
| 220 | - * Returns the list of Sosa numbers to which an individual is related. |
|
| 221 | - * Format: key = sosa number, value = generation for the Sosa number |
|
| 222 | - * |
|
| 223 | - * @param Individual $indi |
|
| 224 | - * @return array Array of sosa numbers |
|
| 225 | - */ |
|
| 226 | - public function getSosaNumbers(Individual $indi) { |
|
| 227 | - if(!$this->is_setup) return array(); |
|
| 228 | - return Database::prepare( |
|
| 229 | - 'SELECT majs_sosa, majs_gen FROM `##maj_sosa`'. |
|
| 230 | - ' WHERE majs_i_id=:indi_id AND majs_gedcom_id=:tree_id AND majs_user_id=:user_id' |
|
| 231 | - )->execute(array( |
|
| 232 | - 'indi_id' => $indi->getXref(), |
|
| 233 | - 'tree_id' => $this->tree->getTreeId(), |
|
| 234 | - 'user_id' => $this->user->getUserId() |
|
| 235 | - ))->fetchAssoc(); |
|
| 236 | - } |
|
| 237 | - |
|
| 238 | - /** |
|
| 239 | - * Get the last generation of Sosa ancestors |
|
| 240 | - * |
|
| 241 | - * @return number Last generation if found, 1 otherwise |
|
| 242 | - */ |
|
| 243 | - public function getLastGeneration() { |
|
| 244 | - if(!$this->is_setup) return; |
|
| 245 | - return Database::prepare( |
|
| 246 | - 'SELECT MAX(majs_gen) FROM `##maj_sosa`'. |
|
| 247 | - ' WHERE majs_gedcom_id=:tree_id AND majs_user_id=:user_id' |
|
| 248 | - )->execute(array( |
|
| 249 | - 'tree_id' => $this->tree->getTreeId(), |
|
| 250 | - 'user_id' => $this->user->getUserId() |
|
| 251 | - ))->fetchOne() ?: 1; |
|
| 252 | - } |
|
| 253 | - |
|
| 254 | - /************* |
|
| 219 | + /** |
|
| 220 | + * Returns the list of Sosa numbers to which an individual is related. |
|
| 221 | + * Format: key = sosa number, value = generation for the Sosa number |
|
| 222 | + * |
|
| 223 | + * @param Individual $indi |
|
| 224 | + * @return array Array of sosa numbers |
|
| 225 | + */ |
|
| 226 | + public function getSosaNumbers(Individual $indi) { |
|
| 227 | + if(!$this->is_setup) return array(); |
|
| 228 | + return Database::prepare( |
|
| 229 | + 'SELECT majs_sosa, majs_gen FROM `##maj_sosa`'. |
|
| 230 | + ' WHERE majs_i_id=:indi_id AND majs_gedcom_id=:tree_id AND majs_user_id=:user_id' |
|
| 231 | + )->execute(array( |
|
| 232 | + 'indi_id' => $indi->getXref(), |
|
| 233 | + 'tree_id' => $this->tree->getTreeId(), |
|
| 234 | + 'user_id' => $this->user->getUserId() |
|
| 235 | + ))->fetchAssoc(); |
|
| 236 | + } |
|
| 237 | + |
|
| 238 | + /** |
|
| 239 | + * Get the last generation of Sosa ancestors |
|
| 240 | + * |
|
| 241 | + * @return number Last generation if found, 1 otherwise |
|
| 242 | + */ |
|
| 243 | + public function getLastGeneration() { |
|
| 244 | + if(!$this->is_setup) return; |
|
| 245 | + return Database::prepare( |
|
| 246 | + 'SELECT MAX(majs_gen) FROM `##maj_sosa`'. |
|
| 247 | + ' WHERE majs_gedcom_id=:tree_id AND majs_user_id=:user_id' |
|
| 248 | + )->execute(array( |
|
| 249 | + 'tree_id' => $this->tree->getTreeId(), |
|
| 250 | + 'user_id' => $this->user->getUserId() |
|
| 251 | + ))->fetchOne() ?: 1; |
|
| 252 | + } |
|
| 253 | + |
|
| 254 | + /************* |
|
| 255 | 255 | * SOSA LISTS |
| 256 | 256 | *************/ |
| 257 | 257 | |
| 258 | - /** |
|
| 259 | - * Return the list of all sosas, with the generations it belongs to |
|
| 260 | - * |
|
| 261 | - * @return array Associative array of Sosa ancestors, with their generation, comma separated |
|
| 262 | - */ |
|
| 263 | - public function getAllSosaWithGenerations(){ |
|
| 264 | - if(!$this->is_setup) return array(); |
|
| 265 | - return Database::prepare( |
|
| 266 | - 'SELECT majs_i_id AS indi,' . |
|
| 267 | - ' GROUP_CONCAT(DISTINCT majs_gen ORDER BY majs_gen ASC SEPARATOR ",") AS generations' . |
|
| 268 | - ' FROM `##maj_sosa`' . |
|
| 269 | - ' WHERE majs_gedcom_id=:tree_id AND majs_user_id=:user_id' . |
|
| 270 | - ' GROUP BY majs_i_id' |
|
| 271 | - )->execute(array( |
|
| 272 | - 'tree_id' => $this->tree->getTreeId(), |
|
| 273 | - 'user_id' => $this->user->getUserId() |
|
| 274 | - ))->fetchAssoc(); |
|
| 275 | - } |
|
| 276 | - |
|
| 277 | - /** |
|
| 278 | - * Get an associative array of Sosa individuals in generation G. Keys are Sosa numbers, values individuals. |
|
| 279 | - * |
|
| 280 | - * @param number $gen Generation |
|
| 281 | - * @return array Array of Sosa individuals |
|
| 282 | - */ |
|
| 283 | - public function getSosaListAtGeneration($gen){ |
|
| 284 | - if(!$this->is_setup) return array(); |
|
| 285 | - if(!$this->sosa_list_by_gen) |
|
| 286 | - $this->sosa_list_by_gen = array(); |
|
| 258 | + /** |
|
| 259 | + * Return the list of all sosas, with the generations it belongs to |
|
| 260 | + * |
|
| 261 | + * @return array Associative array of Sosa ancestors, with their generation, comma separated |
|
| 262 | + */ |
|
| 263 | + public function getAllSosaWithGenerations(){ |
|
| 264 | + if(!$this->is_setup) return array(); |
|
| 265 | + return Database::prepare( |
|
| 266 | + 'SELECT majs_i_id AS indi,' . |
|
| 267 | + ' GROUP_CONCAT(DISTINCT majs_gen ORDER BY majs_gen ASC SEPARATOR ",") AS generations' . |
|
| 268 | + ' FROM `##maj_sosa`' . |
|
| 269 | + ' WHERE majs_gedcom_id=:tree_id AND majs_user_id=:user_id' . |
|
| 270 | + ' GROUP BY majs_i_id' |
|
| 271 | + )->execute(array( |
|
| 272 | + 'tree_id' => $this->tree->getTreeId(), |
|
| 273 | + 'user_id' => $this->user->getUserId() |
|
| 274 | + ))->fetchAssoc(); |
|
| 275 | + } |
|
| 276 | + |
|
| 277 | + /** |
|
| 278 | + * Get an associative array of Sosa individuals in generation G. Keys are Sosa numbers, values individuals. |
|
| 279 | + * |
|
| 280 | + * @param number $gen Generation |
|
| 281 | + * @return array Array of Sosa individuals |
|
| 282 | + */ |
|
| 283 | + public function getSosaListAtGeneration($gen){ |
|
| 284 | + if(!$this->is_setup) return array(); |
|
| 285 | + if(!$this->sosa_list_by_gen) |
|
| 286 | + $this->sosa_list_by_gen = array(); |
|
| 287 | 287 | |
| 288 | - if($gen){ |
|
| 289 | - if(!isset($this->sosa_list_by_gen[$gen])){ |
|
| 290 | - $this->sosa_list_by_gen[$gen] = Database::prepare( |
|
| 291 | - 'SELECT majs_sosa AS sosa, majs_i_id AS indi'. |
|
| 292 | - ' FROM `##maj_sosa`'. |
|
| 293 | - ' WHERE majs_gedcom_id=:tree_id AND majs_user_id=:user_id'. |
|
| 294 | - ' AND majs_gen = :gen'. |
|
| 295 | - ' ORDER BY majs_sosa ASC') |
|
| 296 | - ->execute(array( |
|
| 297 | - 'tree_id' => $this->tree->getTreeId(), |
|
| 298 | - 'user_id' => $this->user->getUserId(), |
|
| 299 | - 'gen' => $gen |
|
| 300 | - )) |
|
| 301 | - ->fetchAssoc(); |
|
| 302 | - } |
|
| 303 | - return $this->sosa_list_by_gen[$gen]; |
|
| 304 | - } |
|
| 305 | - return array(); |
|
| 306 | - } |
|
| 307 | - |
|
| 308 | - /** |
|
| 309 | - * Get an associative array of Sosa families in generation G. Keys are Sosa numbers for the husband, values families. |
|
| 310 | - * |
|
| 311 | - * @param number $gen Generation |
|
| 312 | - * @return array Array of Sosa families |
|
| 313 | - */ |
|
| 314 | - public function getFamilySosaListAtGeneration($gen){ |
|
| 315 | - if(!$this->is_setup) return array(); |
|
| 316 | - if(!$this->sosa_fam_list_by_gen) |
|
| 317 | - $this->sosa_fam_list_by_gen = array(); |
|
| 288 | + if($gen){ |
|
| 289 | + if(!isset($this->sosa_list_by_gen[$gen])){ |
|
| 290 | + $this->sosa_list_by_gen[$gen] = Database::prepare( |
|
| 291 | + 'SELECT majs_sosa AS sosa, majs_i_id AS indi'. |
|
| 292 | + ' FROM `##maj_sosa`'. |
|
| 293 | + ' WHERE majs_gedcom_id=:tree_id AND majs_user_id=:user_id'. |
|
| 294 | + ' AND majs_gen = :gen'. |
|
| 295 | + ' ORDER BY majs_sosa ASC') |
|
| 296 | + ->execute(array( |
|
| 297 | + 'tree_id' => $this->tree->getTreeId(), |
|
| 298 | + 'user_id' => $this->user->getUserId(), |
|
| 299 | + 'gen' => $gen |
|
| 300 | + )) |
|
| 301 | + ->fetchAssoc(); |
|
| 302 | + } |
|
| 303 | + return $this->sosa_list_by_gen[$gen]; |
|
| 304 | + } |
|
| 305 | + return array(); |
|
| 306 | + } |
|
| 307 | + |
|
| 308 | + /** |
|
| 309 | + * Get an associative array of Sosa families in generation G. Keys are Sosa numbers for the husband, values families. |
|
| 310 | + * |
|
| 311 | + * @param number $gen Generation |
|
| 312 | + * @return array Array of Sosa families |
|
| 313 | + */ |
|
| 314 | + public function getFamilySosaListAtGeneration($gen){ |
|
| 315 | + if(!$this->is_setup) return array(); |
|
| 316 | + if(!$this->sosa_fam_list_by_gen) |
|
| 317 | + $this->sosa_fam_list_by_gen = array(); |
|
| 318 | 318 | |
| 319 | - if($gen){ |
|
| 320 | - if(!isset($this->sosa_fam_list_by_gen[$gen])){ |
|
| 321 | - $this->sosa_fam_list_by_gen[$gen] = Database::prepare( |
|
| 322 | - 'SELECT s1.majs_sosa AS sosa, f_id AS fam'. |
|
| 323 | - ' FROM `##families`'. |
|
| 324 | - ' INNER JOIN `##maj_sosa` AS s1 ON (`##families`.f_husb = s1.majs_i_id AND `##families`.f_file = s1.majs_gedcom_id)'. |
|
| 325 | - ' INNER JOIN `##maj_sosa` AS s2 ON (`##families`.f_wife = s2.majs_i_id AND `##families`.f_file = s2.majs_gedcom_id)'. |
|
| 326 | - ' WHERE s1.majs_sosa + 1 = s2.majs_sosa'. |
|
| 327 | - ' AND s1.majs_gedcom_id= :tree_id AND s1.majs_user_id=:user_id'. |
|
| 328 | - ' AND s2.majs_gedcom_id= :tree_id AND s2.majs_user_id=:user_id'. |
|
| 329 | - ' AND s1.majs_gen = :gen'. |
|
| 330 | - ' ORDER BY s1.majs_sosa ASC' |
|
| 331 | - ) |
|
| 332 | - ->execute(array( |
|
| 333 | - 'tree_id' => $this->tree->getTreeId(), |
|
| 334 | - 'user_id' => $this->user->getUserId(), |
|
| 335 | - 'gen' => $gen |
|
| 336 | - )) |
|
| 337 | - ->fetchAssoc(); |
|
| 338 | - } |
|
| 339 | - return $this->sosa_fam_list_by_gen[$gen]; |
|
| 340 | - } |
|
| 341 | - return array(); |
|
| 342 | - } |
|
| 343 | - |
|
| 344 | - /** |
|
| 345 | - * Get an associative array of Sosa individuals in generation G who are missing parents. Keys are Sosa numbers, values individuals. |
|
| 346 | - * |
|
| 347 | - * @param number $gen Generation |
|
| 348 | - * @return array Array of Sosa individuals |
|
| 349 | - */ |
|
| 350 | - public function getMissingSosaListAtGeneration($gen){ |
|
| 351 | - if(!$this->is_setup) return array(); |
|
| 352 | - if($gen){ |
|
| 353 | - return $this->sosa_list_by_gen[$gen] = Database::prepare( |
|
| 354 | - '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'. |
|
| 355 | - ' FROM `##maj_sosa` schild'. |
|
| 356 | - ' LEFT JOIN `##maj_sosa` sfat ON ((schild.majs_sosa * 2) = sfat.majs_sosa AND schild.majs_gedcom_id = sfat.majs_gedcom_id AND schild.majs_user_id = sfat.majs_user_id)'. |
|
| 357 | - ' LEFT JOIN `##maj_sosa` smot ON ((schild.majs_sosa * 2 + 1) = smot.majs_sosa AND schild.majs_gedcom_id = smot.majs_gedcom_id AND schild.majs_user_id = smot.majs_user_id)'. |
|
| 358 | - ' WHERE schild.majs_gedcom_id = :tree_id AND schild.majs_user_id = :user_id'. |
|
| 359 | - ' AND schild.majs_gen = :gen'. |
|
| 360 | - ' AND (sfat.majs_sosa IS NULL OR smot.majs_sosa IS NULL)'. |
|
| 361 | - ' ORDER BY schild.majs_sosa ASC') |
|
| 362 | - ->execute(array( |
|
| 363 | - 'tree_id' => $this->tree->getTreeId(), |
|
| 364 | - 'user_id' => $this->user->getUserId(), |
|
| 365 | - 'gen' => $gen - 1 |
|
| 366 | - ))->fetchAll(\PDO::FETCH_ASSOC); |
|
| 367 | - } |
|
| 368 | - return array(); |
|
| 369 | - } |
|
| 370 | - |
|
| 371 | - |
|
| 372 | - |
|
| 373 | - /************* |
|
| 319 | + if($gen){ |
|
| 320 | + if(!isset($this->sosa_fam_list_by_gen[$gen])){ |
|
| 321 | + $this->sosa_fam_list_by_gen[$gen] = Database::prepare( |
|
| 322 | + 'SELECT s1.majs_sosa AS sosa, f_id AS fam'. |
|
| 323 | + ' FROM `##families`'. |
|
| 324 | + ' INNER JOIN `##maj_sosa` AS s1 ON (`##families`.f_husb = s1.majs_i_id AND `##families`.f_file = s1.majs_gedcom_id)'. |
|
| 325 | + ' INNER JOIN `##maj_sosa` AS s2 ON (`##families`.f_wife = s2.majs_i_id AND `##families`.f_file = s2.majs_gedcom_id)'. |
|
| 326 | + ' WHERE s1.majs_sosa + 1 = s2.majs_sosa'. |
|
| 327 | + ' AND s1.majs_gedcom_id= :tree_id AND s1.majs_user_id=:user_id'. |
|
| 328 | + ' AND s2.majs_gedcom_id= :tree_id AND s2.majs_user_id=:user_id'. |
|
| 329 | + ' AND s1.majs_gen = :gen'. |
|
| 330 | + ' ORDER BY s1.majs_sosa ASC' |
|
| 331 | + ) |
|
| 332 | + ->execute(array( |
|
| 333 | + 'tree_id' => $this->tree->getTreeId(), |
|
| 334 | + 'user_id' => $this->user->getUserId(), |
|
| 335 | + 'gen' => $gen |
|
| 336 | + )) |
|
| 337 | + ->fetchAssoc(); |
|
| 338 | + } |
|
| 339 | + return $this->sosa_fam_list_by_gen[$gen]; |
|
| 340 | + } |
|
| 341 | + return array(); |
|
| 342 | + } |
|
| 343 | + |
|
| 344 | + /** |
|
| 345 | + * Get an associative array of Sosa individuals in generation G who are missing parents. Keys are Sosa numbers, values individuals. |
|
| 346 | + * |
|
| 347 | + * @param number $gen Generation |
|
| 348 | + * @return array Array of Sosa individuals |
|
| 349 | + */ |
|
| 350 | + public function getMissingSosaListAtGeneration($gen){ |
|
| 351 | + if(!$this->is_setup) return array(); |
|
| 352 | + if($gen){ |
|
| 353 | + return $this->sosa_list_by_gen[$gen] = Database::prepare( |
|
| 354 | + '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'. |
|
| 355 | + ' FROM `##maj_sosa` schild'. |
|
| 356 | + ' LEFT JOIN `##maj_sosa` sfat ON ((schild.majs_sosa * 2) = sfat.majs_sosa AND schild.majs_gedcom_id = sfat.majs_gedcom_id AND schild.majs_user_id = sfat.majs_user_id)'. |
|
| 357 | + ' LEFT JOIN `##maj_sosa` smot ON ((schild.majs_sosa * 2 + 1) = smot.majs_sosa AND schild.majs_gedcom_id = smot.majs_gedcom_id AND schild.majs_user_id = smot.majs_user_id)'. |
|
| 358 | + ' WHERE schild.majs_gedcom_id = :tree_id AND schild.majs_user_id = :user_id'. |
|
| 359 | + ' AND schild.majs_gen = :gen'. |
|
| 360 | + ' AND (sfat.majs_sosa IS NULL OR smot.majs_sosa IS NULL)'. |
|
| 361 | + ' ORDER BY schild.majs_sosa ASC') |
|
| 362 | + ->execute(array( |
|
| 363 | + 'tree_id' => $this->tree->getTreeId(), |
|
| 364 | + 'user_id' => $this->user->getUserId(), |
|
| 365 | + 'gen' => $gen - 1 |
|
| 366 | + ))->fetchAll(\PDO::FETCH_ASSOC); |
|
| 367 | + } |
|
| 368 | + return array(); |
|
| 369 | + } |
|
| 370 | + |
|
| 371 | + |
|
| 372 | + |
|
| 373 | + /************* |
|
| 374 | 374 | * STATISTICS |
| 375 | 375 | *************/ |
| 376 | - /** |
|
| 377 | - * Get the statistic array detailed by generation. |
|
| 378 | - * Statistics for each generation are: |
|
| 379 | - * - The number of Sosa in generation |
|
| 380 | - * - The number of Sosa up to generation |
|
| 381 | - * - The number of distinct Sosa up to generation |
|
| 382 | - * - The year of the first birth in generation |
|
| 383 | - * - The year of the last birth in generation |
|
| 384 | - * - The average year of birth in generation |
|
| 385 | - * |
|
| 386 | - * @return array Statistics array |
|
| 387 | - */ |
|
| 388 | - public function getStatisticsByGeneration() { |
|
| 389 | - if(!$this->is_setup) return array(); |
|
| 390 | - if(!$this->statistics_tab) { |
|
| 391 | - $this->statistics_tab = array(); |
|
| 392 | - if($maxGeneration = $this->getLastGeneration()) { |
|
| 393 | - for ($gen = 1; $gen <= $maxGeneration; $gen++) { |
|
| 394 | - $birthStats = $this->getStatsBirthYearInGeneration($gen); |
|
| 395 | - $this->statistics_tab[$gen] = array( |
|
| 396 | - 'sosaCount' => $this->getSosaCountAtGeneration($gen), |
|
| 397 | - 'sosaTotalCount' => $this->getSosaCountUpToGeneration($gen), |
|
| 398 | - 'diffSosaTotalCount' => $this->getDifferentSosaCountUpToGeneration($gen), |
|
| 399 | - 'firstBirth' => $birthStats['first'], |
|
| 400 | - 'lastBirth' => $birthStats['last'], |
|
| 401 | - 'avgBirth' => $birthStats['avg'] |
|
| 402 | - ); |
|
| 403 | - } |
|
| 404 | - } |
|
| 405 | - } |
|
| 406 | - return $this->statistics_tab; |
|
| 407 | - } |
|
| 376 | + /** |
|
| 377 | + * Get the statistic array detailed by generation. |
|
| 378 | + * Statistics for each generation are: |
|
| 379 | + * - The number of Sosa in generation |
|
| 380 | + * - The number of Sosa up to generation |
|
| 381 | + * - The number of distinct Sosa up to generation |
|
| 382 | + * - The year of the first birth in generation |
|
| 383 | + * - The year of the last birth in generation |
|
| 384 | + * - The average year of birth in generation |
|
| 385 | + * |
|
| 386 | + * @return array Statistics array |
|
| 387 | + */ |
|
| 388 | + public function getStatisticsByGeneration() { |
|
| 389 | + if(!$this->is_setup) return array(); |
|
| 390 | + if(!$this->statistics_tab) { |
|
| 391 | + $this->statistics_tab = array(); |
|
| 392 | + if($maxGeneration = $this->getLastGeneration()) { |
|
| 393 | + for ($gen = 1; $gen <= $maxGeneration; $gen++) { |
|
| 394 | + $birthStats = $this->getStatsBirthYearInGeneration($gen); |
|
| 395 | + $this->statistics_tab[$gen] = array( |
|
| 396 | + 'sosaCount' => $this->getSosaCountAtGeneration($gen), |
|
| 397 | + 'sosaTotalCount' => $this->getSosaCountUpToGeneration($gen), |
|
| 398 | + 'diffSosaTotalCount' => $this->getDifferentSosaCountUpToGeneration($gen), |
|
| 399 | + 'firstBirth' => $birthStats['first'], |
|
| 400 | + 'lastBirth' => $birthStats['last'], |
|
| 401 | + 'avgBirth' => $birthStats['avg'] |
|
| 402 | + ); |
|
| 403 | + } |
|
| 404 | + } |
|
| 405 | + } |
|
| 406 | + return $this->statistics_tab; |
|
| 407 | + } |
|
| 408 | 408 | |
| 409 | 409 | /** |
| 410 | 410 | * How many individuals exist in the tree. |
@@ -412,205 +412,205 @@ discard block |
||
| 412 | 412 | * @return int |
| 413 | 413 | */ |
| 414 | 414 | public function getTotalIndividuals() { |
| 415 | - if(!$this->is_setup) return 0; |
|
| 416 | - return Database::prepare( |
|
| 417 | - 'SELECT SQL_CACHE COUNT(*) FROM `##individuals`' . |
|
| 418 | - ' WHERE i_file = :tree_id') |
|
| 419 | - ->execute(array('tree_id' => $this->tree->getTreeId())) |
|
| 420 | - ->fetchOne() ?: 0; |
|
| 415 | + if(!$this->is_setup) return 0; |
|
| 416 | + return Database::prepare( |
|
| 417 | + 'SELECT SQL_CACHE COUNT(*) FROM `##individuals`' . |
|
| 418 | + ' WHERE i_file = :tree_id') |
|
| 419 | + ->execute(array('tree_id' => $this->tree->getTreeId())) |
|
| 420 | + ->fetchOne() ?: 0; |
|
| 421 | 421 | } |
| 422 | 422 | |
| 423 | - /** |
|
| 424 | - * Get the total Sosa count for all generations |
|
| 425 | - * |
|
| 426 | - * @return number Number of Sosas |
|
| 427 | - */ |
|
| 428 | - public function getSosaCount(){ |
|
| 429 | - if(!$this->is_setup) return 0; |
|
| 430 | - return Database::prepare( |
|
| 431 | - 'SELECT SQL_CACHE COUNT(majs_sosa) FROM `##maj_sosa`' . |
|
| 432 | - ' WHERE majs_gedcom_id=:tree_id AND majs_user_id=:user_id') |
|
| 433 | - ->execute(array( |
|
| 434 | - 'tree_id' => $this->tree->getTreeId(), |
|
| 435 | - 'user_id' => $this->user->getUserId() |
|
| 436 | - ))->fetchOne() ?: 0; |
|
| 437 | - } |
|
| 438 | - |
|
| 439 | - /** |
|
| 440 | - * Get the number of Sosa in a specific generation. |
|
| 441 | - * |
|
| 442 | - * @param number $gen Generation |
|
| 443 | - * @return number Number of Sosas in generation |
|
| 444 | - */ |
|
| 445 | - public function getSosaCountAtGeneration($gen){ |
|
| 446 | - if(!$this->is_setup) return 0; |
|
| 447 | - return Database::prepare( |
|
| 448 | - 'SELECT SQL_CACHE COUNT(majs_sosa) FROM `##maj_sosa`' . |
|
| 449 | - ' WHERE majs_gedcom_id=:tree_id AND majs_user_id=:user_id'. |
|
| 450 | - ' AND majs_gen= :gen') |
|
| 451 | - ->execute(array( |
|
| 452 | - 'tree_id' => $this->tree->getTreeId(), |
|
| 453 | - 'user_id' => $this->user->getUserId(), |
|
| 454 | - 'gen' => $gen |
|
| 455 | - ))->fetchOne() ?: 0; |
|
| 456 | - } |
|
| 457 | - |
|
| 458 | - /** |
|
| 459 | - * Get the total number of Sosa up to a specific generation. |
|
| 460 | - * |
|
| 461 | - * @param number $gen Generation |
|
| 462 | - * @return number Total number of Sosas up to generation |
|
| 463 | - */ |
|
| 464 | - public function getSosaCountUpToGeneration($gen){ |
|
| 465 | - if(!$this->is_setup) return 0; |
|
| 466 | - return Database::prepare( |
|
| 467 | - 'SELECT SQL_CACHE COUNT(majs_sosa) FROM `##maj_sosa`' . |
|
| 468 | - ' WHERE majs_gedcom_id=:tree_id AND majs_user_id=:user_id'. |
|
| 469 | - ' AND majs_gen <= :gen') |
|
| 470 | - ->execute(array( |
|
| 471 | - 'tree_id' => $this->tree->getTreeId(), |
|
| 472 | - 'user_id' => $this->user->getUserId(), |
|
| 473 | - 'gen' => $gen |
|
| 474 | - ))->fetchOne() ?: 0; |
|
| 475 | - } |
|
| 476 | - |
|
| 477 | - /** |
|
| 478 | - * Get the total number of distinct Sosa individual for all generations. |
|
| 479 | - * |
|
| 480 | - * @return number Total number of distinct individual |
|
| 481 | - */ |
|
| 482 | - public function getDifferentSosaCount(){ |
|
| 483 | - if(!$this->is_setup) return 0; |
|
| 484 | - return Database::prepare( |
|
| 485 | - 'SELECT SQL_CACHE COUNT(DISTINCT majs_i_id) FROM `##maj_sosa`' . |
|
| 486 | - ' WHERE majs_gedcom_id=:tree_id AND majs_user_id=:user_id') |
|
| 487 | - ->execute(array( |
|
| 488 | - 'tree_id' => $this->tree->getTreeId(), |
|
| 489 | - 'user_id' => $this->user->getUserId() |
|
| 490 | - ))->fetchOne() ?: 0; |
|
| 491 | - } |
|
| 492 | - |
|
| 493 | - /** |
|
| 494 | - * Get the number of distinct Sosa individual up to a specific generation. |
|
| 495 | - * |
|
| 496 | - * @param number $gen Generation |
|
| 497 | - * @return number Number of distinct Sosa individuals up to generation |
|
| 498 | - */ |
|
| 499 | - public function getDifferentSosaCountUpToGeneration($gen){ |
|
| 500 | - if(!$this->is_setup) return 0; |
|
| 501 | - return Database::prepare( |
|
| 502 | - 'SELECT SQL_CACHE COUNT(DISTINCT majs_i_id) FROM `##maj_sosa`' . |
|
| 503 | - ' WHERE majs_gedcom_id=:tree_id AND majs_user_id=:user_id'. |
|
| 504 | - ' AND majs_gen <= :gen') |
|
| 505 | - ->execute(array( |
|
| 506 | - 'tree_id' => $this->tree->getTreeId(), |
|
| 507 | - 'user_id' => $this->user->getUserId(), |
|
| 508 | - 'gen' => $gen |
|
| 509 | - ))->fetchOne() ?: 0; |
|
| 510 | - } |
|
| 511 | - |
|
| 512 | - /** |
|
| 513 | - * Get an array of birth statistics for a specific generation |
|
| 514 | - * Statistics are : |
|
| 515 | - * - first : First birth year in generation |
|
| 516 | - * - last : Last birth year in generation |
|
| 517 | - * - avg : Average birth year |
|
| 518 | - * |
|
| 519 | - * @param number $gen Generation |
|
| 520 | - * @return array Birth statistics array |
|
| 521 | - */ |
|
| 522 | - public function getStatsBirthYearInGeneration($gen){ |
|
| 523 | - if(!$this->is_setup) return array('first' => 0, 'avg' => 0, 'last' => 0); |
|
| 524 | - return Database::prepare( |
|
| 525 | - 'SELECT MIN(majs_birth_year) AS first, AVG(majs_birth_year) AS avg, MAX(majs_birth_year) AS last'. |
|
| 526 | - ' FROM `##maj_sosa`' . |
|
| 527 | - ' WHERE majs_gedcom_id=:tree_id AND majs_user_id=:user_id'. |
|
| 528 | - ' AND majs_gen=:gen AND NOT majs_birth_year = :birth_year') |
|
| 529 | - ->execute(array( |
|
| 530 | - 'tree_id' => $this->tree->getTreeId(), |
|
| 531 | - 'user_id' => $this->user->getUserId(), |
|
| 532 | - 'gen' => $gen, |
|
| 533 | - 'birth_year' => 0)) |
|
| 534 | - ->fetchOneRow(\PDO::FETCH_ASSOC) ?: array('first' => 0, 'avg' => 0, 'last' => 0); |
|
| 535 | - } |
|
| 536 | - |
|
| 537 | - /** |
|
| 538 | - * Get the mean generation time, based on a linear regression of birth years and generations |
|
| 539 | - * |
|
| 540 | - * @return number|NULL Mean generation time |
|
| 541 | - */ |
|
| 542 | - public function getMeanGenerationTime(){ |
|
| 543 | - if(!$this->is_setup) return; |
|
| 544 | - if(!$this->statistics_tab){ |
|
| 545 | - $this->getStatisticsByGeneration(); |
|
| 546 | - } |
|
| 547 | - //Linear regression on x=generation and y=birthdate |
|
| 548 | - $sum_xy = 0; |
|
| 549 | - $sum_x=0; |
|
| 550 | - $sum_y=0; |
|
| 551 | - $sum_x2=0; |
|
| 552 | - $n=count($this->statistics_tab); |
|
| 553 | - foreach($this->statistics_tab as $gen=>$stats){ |
|
| 554 | - $sum_xy+=$gen*$stats['avgBirth']; |
|
| 555 | - $sum_x+=$gen; |
|
| 556 | - $sum_y+=$stats['avgBirth']; |
|
| 557 | - $sum_x2+=$gen*$gen; |
|
| 558 | - } |
|
| 559 | - $denom=($n*$sum_x2)-($sum_x*$sum_x); |
|
| 560 | - if($denom!=0){ |
|
| 561 | - return -(($n*$sum_xy)-($sum_x*$sum_y))/($denom); |
|
| 562 | - } |
|
| 563 | - return null; |
|
| 564 | - } |
|
| 565 | - |
|
| 566 | - /** |
|
| 567 | - * Return a computed array of statistics about the dispersion of ancestors across the ancestors |
|
| 568 | - * at a specified generation. |
|
| 569 | - * This statistics cannot be used for generations above 11, as it would cause a out of range in MySQL |
|
| 570 | - * |
|
| 571 | - * Format: |
|
| 572 | - * - key : a base-2 representation of the ancestor at generation G for which exclusive ancestors have been found, |
|
| 573 | - * -1 is used for shared ancestors |
|
| 574 | - * For instance base2(0100) = base10(4) represent the maternal grand father |
|
| 575 | - * - values: number of ancestors exclusively in the ancestors of the ancestor in key |
|
| 576 | - * |
|
| 577 | - * For instance a result at generation 3 could be : |
|
| 578 | - * array ( -1 => 12 -> 12 ancestors are shared by the grand-parents |
|
| 579 | - * base10(1) => 32 -> 32 ancestors are exclusive to the paternal grand-father |
|
| 580 | - * base10(2) => 25 -> 25 ancestors are exclusive to the paternal grand-mother |
|
| 581 | - * base10(4) => 12 -> 12 ancestors are exclusive to the maternal grand-father |
|
| 582 | - * base10(8) => 30 -> 30 ancestors are exclusive to the maternal grand-mother |
|
| 583 | - * ) |
|
| 584 | - * |
|
| 585 | - * @param int $gen Reference generation |
|
| 586 | - * @return array |
|
| 587 | - */ |
|
| 588 | - public function getAncestorDispersionForGen($gen) { |
|
| 589 | - if(!$this->is_setup || $gen > 11) return array(); // Going further than 11 gen will be out of range in the query |
|
| 590 | - return Database::prepare( |
|
| 591 | - 'SELECT branches, count(i_id)'. |
|
| 592 | - ' FROM ('. |
|
| 593 | - ' SELECT i_id,'. |
|
| 594 | - ' CASE'. |
|
| 595 | - ' WHEN CEIL(LOG2(SUM(branch))) = LOG2(SUM(branch)) THEN SUM(branch)'. |
|
| 596 | - ' ELSE -1'. // We put all ancestors shared between some branches in the same bucket |
|
| 597 | - ' END branches'. |
|
| 598 | - ' FROM ('. |
|
| 599 | - ' SELECT DISTINCT majs_i_id i_id,'. |
|
| 600 | - ' POW(2, FLOOR(majs_sosa / POW(2, (majs_gen - :gen))) - POW(2, :gen -1)) branch'. |
|
| 601 | - ' FROM `##maj_sosa`'. |
|
| 602 | - ' WHERE majs_gedcom_id = :tree_id AND majs_user_id = :user_id'. |
|
| 603 | - ' AND majs_gen >= :gen'. |
|
| 604 | - ' ) indistat'. |
|
| 605 | - ' GROUP BY i_id'. |
|
| 606 | - ') grouped'. |
|
| 607 | - ' GROUP BY branches') |
|
| 608 | - ->execute(array( |
|
| 609 | - 'tree_id' => $this->tree->getTreeId(), |
|
| 610 | - 'user_id' => $this->user->getUserId(), |
|
| 611 | - 'gen' => $gen |
|
| 612 | - ))->fetchAssoc() ?: array(); |
|
| 613 | - } |
|
| 423 | + /** |
|
| 424 | + * Get the total Sosa count for all generations |
|
| 425 | + * |
|
| 426 | + * @return number Number of Sosas |
|
| 427 | + */ |
|
| 428 | + public function getSosaCount(){ |
|
| 429 | + if(!$this->is_setup) return 0; |
|
| 430 | + return Database::prepare( |
|
| 431 | + 'SELECT SQL_CACHE COUNT(majs_sosa) FROM `##maj_sosa`' . |
|
| 432 | + ' WHERE majs_gedcom_id=:tree_id AND majs_user_id=:user_id') |
|
| 433 | + ->execute(array( |
|
| 434 | + 'tree_id' => $this->tree->getTreeId(), |
|
| 435 | + 'user_id' => $this->user->getUserId() |
|
| 436 | + ))->fetchOne() ?: 0; |
|
| 437 | + } |
|
| 438 | + |
|
| 439 | + /** |
|
| 440 | + * Get the number of Sosa in a specific generation. |
|
| 441 | + * |
|
| 442 | + * @param number $gen Generation |
|
| 443 | + * @return number Number of Sosas in generation |
|
| 444 | + */ |
|
| 445 | + public function getSosaCountAtGeneration($gen){ |
|
| 446 | + if(!$this->is_setup) return 0; |
|
| 447 | + return Database::prepare( |
|
| 448 | + 'SELECT SQL_CACHE COUNT(majs_sosa) FROM `##maj_sosa`' . |
|
| 449 | + ' WHERE majs_gedcom_id=:tree_id AND majs_user_id=:user_id'. |
|
| 450 | + ' AND majs_gen= :gen') |
|
| 451 | + ->execute(array( |
|
| 452 | + 'tree_id' => $this->tree->getTreeId(), |
|
| 453 | + 'user_id' => $this->user->getUserId(), |
|
| 454 | + 'gen' => $gen |
|
| 455 | + ))->fetchOne() ?: 0; |
|
| 456 | + } |
|
| 457 | + |
|
| 458 | + /** |
|
| 459 | + * Get the total number of Sosa up to a specific generation. |
|
| 460 | + * |
|
| 461 | + * @param number $gen Generation |
|
| 462 | + * @return number Total number of Sosas up to generation |
|
| 463 | + */ |
|
| 464 | + public function getSosaCountUpToGeneration($gen){ |
|
| 465 | + if(!$this->is_setup) return 0; |
|
| 466 | + return Database::prepare( |
|
| 467 | + 'SELECT SQL_CACHE COUNT(majs_sosa) FROM `##maj_sosa`' . |
|
| 468 | + ' WHERE majs_gedcom_id=:tree_id AND majs_user_id=:user_id'. |
|
| 469 | + ' AND majs_gen <= :gen') |
|
| 470 | + ->execute(array( |
|
| 471 | + 'tree_id' => $this->tree->getTreeId(), |
|
| 472 | + 'user_id' => $this->user->getUserId(), |
|
| 473 | + 'gen' => $gen |
|
| 474 | + ))->fetchOne() ?: 0; |
|
| 475 | + } |
|
| 476 | + |
|
| 477 | + /** |
|
| 478 | + * Get the total number of distinct Sosa individual for all generations. |
|
| 479 | + * |
|
| 480 | + * @return number Total number of distinct individual |
|
| 481 | + */ |
|
| 482 | + public function getDifferentSosaCount(){ |
|
| 483 | + if(!$this->is_setup) return 0; |
|
| 484 | + return Database::prepare( |
|
| 485 | + 'SELECT SQL_CACHE COUNT(DISTINCT majs_i_id) FROM `##maj_sosa`' . |
|
| 486 | + ' WHERE majs_gedcom_id=:tree_id AND majs_user_id=:user_id') |
|
| 487 | + ->execute(array( |
|
| 488 | + 'tree_id' => $this->tree->getTreeId(), |
|
| 489 | + 'user_id' => $this->user->getUserId() |
|
| 490 | + ))->fetchOne() ?: 0; |
|
| 491 | + } |
|
| 492 | + |
|
| 493 | + /** |
|
| 494 | + * Get the number of distinct Sosa individual up to a specific generation. |
|
| 495 | + * |
|
| 496 | + * @param number $gen Generation |
|
| 497 | + * @return number Number of distinct Sosa individuals up to generation |
|
| 498 | + */ |
|
| 499 | + public function getDifferentSosaCountUpToGeneration($gen){ |
|
| 500 | + if(!$this->is_setup) return 0; |
|
| 501 | + return Database::prepare( |
|
| 502 | + 'SELECT SQL_CACHE COUNT(DISTINCT majs_i_id) FROM `##maj_sosa`' . |
|
| 503 | + ' WHERE majs_gedcom_id=:tree_id AND majs_user_id=:user_id'. |
|
| 504 | + ' AND majs_gen <= :gen') |
|
| 505 | + ->execute(array( |
|
| 506 | + 'tree_id' => $this->tree->getTreeId(), |
|
| 507 | + 'user_id' => $this->user->getUserId(), |
|
| 508 | + 'gen' => $gen |
|
| 509 | + ))->fetchOne() ?: 0; |
|
| 510 | + } |
|
| 511 | + |
|
| 512 | + /** |
|
| 513 | + * Get an array of birth statistics for a specific generation |
|
| 514 | + * Statistics are : |
|
| 515 | + * - first : First birth year in generation |
|
| 516 | + * - last : Last birth year in generation |
|
| 517 | + * - avg : Average birth year |
|
| 518 | + * |
|
| 519 | + * @param number $gen Generation |
|
| 520 | + * @return array Birth statistics array |
|
| 521 | + */ |
|
| 522 | + public function getStatsBirthYearInGeneration($gen){ |
|
| 523 | + if(!$this->is_setup) return array('first' => 0, 'avg' => 0, 'last' => 0); |
|
| 524 | + return Database::prepare( |
|
| 525 | + 'SELECT MIN(majs_birth_year) AS first, AVG(majs_birth_year) AS avg, MAX(majs_birth_year) AS last'. |
|
| 526 | + ' FROM `##maj_sosa`' . |
|
| 527 | + ' WHERE majs_gedcom_id=:tree_id AND majs_user_id=:user_id'. |
|
| 528 | + ' AND majs_gen=:gen AND NOT majs_birth_year = :birth_year') |
|
| 529 | + ->execute(array( |
|
| 530 | + 'tree_id' => $this->tree->getTreeId(), |
|
| 531 | + 'user_id' => $this->user->getUserId(), |
|
| 532 | + 'gen' => $gen, |
|
| 533 | + 'birth_year' => 0)) |
|
| 534 | + ->fetchOneRow(\PDO::FETCH_ASSOC) ?: array('first' => 0, 'avg' => 0, 'last' => 0); |
|
| 535 | + } |
|
| 536 | + |
|
| 537 | + /** |
|
| 538 | + * Get the mean generation time, based on a linear regression of birth years and generations |
|
| 539 | + * |
|
| 540 | + * @return number|NULL Mean generation time |
|
| 541 | + */ |
|
| 542 | + public function getMeanGenerationTime(){ |
|
| 543 | + if(!$this->is_setup) return; |
|
| 544 | + if(!$this->statistics_tab){ |
|
| 545 | + $this->getStatisticsByGeneration(); |
|
| 546 | + } |
|
| 547 | + //Linear regression on x=generation and y=birthdate |
|
| 548 | + $sum_xy = 0; |
|
| 549 | + $sum_x=0; |
|
| 550 | + $sum_y=0; |
|
| 551 | + $sum_x2=0; |
|
| 552 | + $n=count($this->statistics_tab); |
|
| 553 | + foreach($this->statistics_tab as $gen=>$stats){ |
|
| 554 | + $sum_xy+=$gen*$stats['avgBirth']; |
|
| 555 | + $sum_x+=$gen; |
|
| 556 | + $sum_y+=$stats['avgBirth']; |
|
| 557 | + $sum_x2+=$gen*$gen; |
|
| 558 | + } |
|
| 559 | + $denom=($n*$sum_x2)-($sum_x*$sum_x); |
|
| 560 | + if($denom!=0){ |
|
| 561 | + return -(($n*$sum_xy)-($sum_x*$sum_y))/($denom); |
|
| 562 | + } |
|
| 563 | + return null; |
|
| 564 | + } |
|
| 565 | + |
|
| 566 | + /** |
|
| 567 | + * Return a computed array of statistics about the dispersion of ancestors across the ancestors |
|
| 568 | + * at a specified generation. |
|
| 569 | + * This statistics cannot be used for generations above 11, as it would cause a out of range in MySQL |
|
| 570 | + * |
|
| 571 | + * Format: |
|
| 572 | + * - key : a base-2 representation of the ancestor at generation G for which exclusive ancestors have been found, |
|
| 573 | + * -1 is used for shared ancestors |
|
| 574 | + * For instance base2(0100) = base10(4) represent the maternal grand father |
|
| 575 | + * - values: number of ancestors exclusively in the ancestors of the ancestor in key |
|
| 576 | + * |
|
| 577 | + * For instance a result at generation 3 could be : |
|
| 578 | + * array ( -1 => 12 -> 12 ancestors are shared by the grand-parents |
|
| 579 | + * base10(1) => 32 -> 32 ancestors are exclusive to the paternal grand-father |
|
| 580 | + * base10(2) => 25 -> 25 ancestors are exclusive to the paternal grand-mother |
|
| 581 | + * base10(4) => 12 -> 12 ancestors are exclusive to the maternal grand-father |
|
| 582 | + * base10(8) => 30 -> 30 ancestors are exclusive to the maternal grand-mother |
|
| 583 | + * ) |
|
| 584 | + * |
|
| 585 | + * @param int $gen Reference generation |
|
| 586 | + * @return array |
|
| 587 | + */ |
|
| 588 | + public function getAncestorDispersionForGen($gen) { |
|
| 589 | + if(!$this->is_setup || $gen > 11) return array(); // Going further than 11 gen will be out of range in the query |
|
| 590 | + return Database::prepare( |
|
| 591 | + 'SELECT branches, count(i_id)'. |
|
| 592 | + ' FROM ('. |
|
| 593 | + ' SELECT i_id,'. |
|
| 594 | + ' CASE'. |
|
| 595 | + ' WHEN CEIL(LOG2(SUM(branch))) = LOG2(SUM(branch)) THEN SUM(branch)'. |
|
| 596 | + ' ELSE -1'. // We put all ancestors shared between some branches in the same bucket |
|
| 597 | + ' END branches'. |
|
| 598 | + ' FROM ('. |
|
| 599 | + ' SELECT DISTINCT majs_i_id i_id,'. |
|
| 600 | + ' POW(2, FLOOR(majs_sosa / POW(2, (majs_gen - :gen))) - POW(2, :gen -1)) branch'. |
|
| 601 | + ' FROM `##maj_sosa`'. |
|
| 602 | + ' WHERE majs_gedcom_id = :tree_id AND majs_user_id = :user_id'. |
|
| 603 | + ' AND majs_gen >= :gen'. |
|
| 604 | + ' ) indistat'. |
|
| 605 | + ' GROUP BY i_id'. |
|
| 606 | + ') grouped'. |
|
| 607 | + ' GROUP BY branches') |
|
| 608 | + ->execute(array( |
|
| 609 | + 'tree_id' => $this->tree->getTreeId(), |
|
| 610 | + 'user_id' => $this->user->getUserId(), |
|
| 611 | + 'gen' => $gen |
|
| 612 | + ))->fetchAssoc() ?: array(); |
|
| 613 | + } |
|
| 614 | 614 | |
| 615 | 615 | |
| 616 | 616 | } |
@@ -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' |
@@ -260,13 +260,13 @@ discard block |
||
| 260 | 260 | * |
| 261 | 261 | * @return array Associative array of Sosa ancestors, with their generation, comma separated |
| 262 | 262 | */ |
| 263 | - public function getAllSosaWithGenerations(){ |
|
| 264 | - if(!$this->is_setup) return array(); |
|
| 263 | + public function getAllSosaWithGenerations() { |
|
| 264 | + if (!$this->is_setup) return array(); |
|
| 265 | 265 | return Database::prepare( |
| 266 | - 'SELECT majs_i_id AS indi,' . |
|
| 267 | - ' GROUP_CONCAT(DISTINCT majs_gen ORDER BY majs_gen ASC SEPARATOR ",") AS generations' . |
|
| 268 | - ' FROM `##maj_sosa`' . |
|
| 269 | - ' WHERE majs_gedcom_id=:tree_id AND majs_user_id=:user_id' . |
|
| 266 | + 'SELECT majs_i_id AS indi,'. |
|
| 267 | + ' GROUP_CONCAT(DISTINCT majs_gen ORDER BY majs_gen ASC SEPARATOR ",") AS generations'. |
|
| 268 | + ' FROM `##maj_sosa`'. |
|
| 269 | + ' WHERE majs_gedcom_id=:tree_id AND majs_user_id=:user_id'. |
|
| 270 | 270 | ' GROUP BY majs_i_id' |
| 271 | 271 | )->execute(array( |
| 272 | 272 | 'tree_id' => $this->tree->getTreeId(), |
@@ -280,13 +280,13 @@ discard block |
||
| 280 | 280 | * @param number $gen Generation |
| 281 | 281 | * @return array Array of Sosa individuals |
| 282 | 282 | */ |
| 283 | - public function getSosaListAtGeneration($gen){ |
|
| 284 | - if(!$this->is_setup) return array(); |
|
| 285 | - if(!$this->sosa_list_by_gen) |
|
| 283 | + public function getSosaListAtGeneration($gen) { |
|
| 284 | + if (!$this->is_setup) return array(); |
|
| 285 | + if (!$this->sosa_list_by_gen) |
|
| 286 | 286 | $this->sosa_list_by_gen = array(); |
| 287 | 287 | |
| 288 | - if($gen){ |
|
| 289 | - if(!isset($this->sosa_list_by_gen[$gen])){ |
|
| 288 | + if ($gen) { |
|
| 289 | + if (!isset($this->sosa_list_by_gen[$gen])) { |
|
| 290 | 290 | $this->sosa_list_by_gen[$gen] = Database::prepare( |
| 291 | 291 | 'SELECT majs_sosa AS sosa, majs_i_id AS indi'. |
| 292 | 292 | ' FROM `##maj_sosa`'. |
@@ -311,13 +311,13 @@ discard block |
||
| 311 | 311 | * @param number $gen Generation |
| 312 | 312 | * @return array Array of Sosa families |
| 313 | 313 | */ |
| 314 | - public function getFamilySosaListAtGeneration($gen){ |
|
| 315 | - if(!$this->is_setup) return array(); |
|
| 316 | - if(!$this->sosa_fam_list_by_gen) |
|
| 314 | + public function getFamilySosaListAtGeneration($gen) { |
|
| 315 | + if (!$this->is_setup) return array(); |
|
| 316 | + if (!$this->sosa_fam_list_by_gen) |
|
| 317 | 317 | $this->sosa_fam_list_by_gen = array(); |
| 318 | 318 | |
| 319 | - if($gen){ |
|
| 320 | - if(!isset($this->sosa_fam_list_by_gen[$gen])){ |
|
| 319 | + if ($gen) { |
|
| 320 | + if (!isset($this->sosa_fam_list_by_gen[$gen])) { |
|
| 321 | 321 | $this->sosa_fam_list_by_gen[$gen] = Database::prepare( |
| 322 | 322 | 'SELECT s1.majs_sosa AS sosa, f_id AS fam'. |
| 323 | 323 | ' FROM `##families`'. |
@@ -347,9 +347,9 @@ discard block |
||
| 347 | 347 | * @param number $gen Generation |
| 348 | 348 | * @return array Array of Sosa individuals |
| 349 | 349 | */ |
| 350 | - public function getMissingSosaListAtGeneration($gen){ |
|
| 351 | - if(!$this->is_setup) return array(); |
|
| 352 | - if($gen){ |
|
| 350 | + public function getMissingSosaListAtGeneration($gen) { |
|
| 351 | + if (!$this->is_setup) return array(); |
|
| 352 | + if ($gen) { |
|
| 353 | 353 | return $this->sosa_list_by_gen[$gen] = Database::prepare( |
| 354 | 354 | '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'. |
| 355 | 355 | ' FROM `##maj_sosa` schild'. |
@@ -386,10 +386,10 @@ discard block |
||
| 386 | 386 | * @return array Statistics array |
| 387 | 387 | */ |
| 388 | 388 | public function getStatisticsByGeneration() { |
| 389 | - if(!$this->is_setup) return array(); |
|
| 390 | - if(!$this->statistics_tab) { |
|
| 389 | + if (!$this->is_setup) return array(); |
|
| 390 | + if (!$this->statistics_tab) { |
|
| 391 | 391 | $this->statistics_tab = array(); |
| 392 | - if($maxGeneration = $this->getLastGeneration()) { |
|
| 392 | + if ($maxGeneration = $this->getLastGeneration()) { |
|
| 393 | 393 | for ($gen = 1; $gen <= $maxGeneration; $gen++) { |
| 394 | 394 | $birthStats = $this->getStatsBirthYearInGeneration($gen); |
| 395 | 395 | $this->statistics_tab[$gen] = array( |
@@ -412,9 +412,9 @@ discard block |
||
| 412 | 412 | * @return int |
| 413 | 413 | */ |
| 414 | 414 | public function getTotalIndividuals() { |
| 415 | - if(!$this->is_setup) return 0; |
|
| 415 | + if (!$this->is_setup) return 0; |
|
| 416 | 416 | return Database::prepare( |
| 417 | - 'SELECT SQL_CACHE COUNT(*) FROM `##individuals`' . |
|
| 417 | + 'SELECT SQL_CACHE COUNT(*) FROM `##individuals`'. |
|
| 418 | 418 | ' WHERE i_file = :tree_id') |
| 419 | 419 | ->execute(array('tree_id' => $this->tree->getTreeId())) |
| 420 | 420 | ->fetchOne() ?: 0; |
@@ -425,10 +425,10 @@ discard block |
||
| 425 | 425 | * |
| 426 | 426 | * @return number Number of Sosas |
| 427 | 427 | */ |
| 428 | - public function getSosaCount(){ |
|
| 429 | - if(!$this->is_setup) return 0; |
|
| 428 | + public function getSosaCount() { |
|
| 429 | + if (!$this->is_setup) return 0; |
|
| 430 | 430 | return Database::prepare( |
| 431 | - 'SELECT SQL_CACHE COUNT(majs_sosa) FROM `##maj_sosa`' . |
|
| 431 | + 'SELECT SQL_CACHE COUNT(majs_sosa) FROM `##maj_sosa`'. |
|
| 432 | 432 | ' WHERE majs_gedcom_id=:tree_id AND majs_user_id=:user_id') |
| 433 | 433 | ->execute(array( |
| 434 | 434 | 'tree_id' => $this->tree->getTreeId(), |
@@ -442,10 +442,10 @@ discard block |
||
| 442 | 442 | * @param number $gen Generation |
| 443 | 443 | * @return number Number of Sosas in generation |
| 444 | 444 | */ |
| 445 | - public function getSosaCountAtGeneration($gen){ |
|
| 446 | - if(!$this->is_setup) return 0; |
|
| 445 | + public function getSosaCountAtGeneration($gen) { |
|
| 446 | + if (!$this->is_setup) return 0; |
|
| 447 | 447 | return Database::prepare( |
| 448 | - 'SELECT SQL_CACHE COUNT(majs_sosa) FROM `##maj_sosa`' . |
|
| 448 | + 'SELECT SQL_CACHE COUNT(majs_sosa) FROM `##maj_sosa`'. |
|
| 449 | 449 | ' WHERE majs_gedcom_id=:tree_id AND majs_user_id=:user_id'. |
| 450 | 450 | ' AND majs_gen= :gen') |
| 451 | 451 | ->execute(array( |
@@ -461,10 +461,10 @@ discard block |
||
| 461 | 461 | * @param number $gen Generation |
| 462 | 462 | * @return number Total number of Sosas up to generation |
| 463 | 463 | */ |
| 464 | - public function getSosaCountUpToGeneration($gen){ |
|
| 465 | - if(!$this->is_setup) return 0; |
|
| 464 | + public function getSosaCountUpToGeneration($gen) { |
|
| 465 | + if (!$this->is_setup) return 0; |
|
| 466 | 466 | return Database::prepare( |
| 467 | - 'SELECT SQL_CACHE COUNT(majs_sosa) FROM `##maj_sosa`' . |
|
| 467 | + 'SELECT SQL_CACHE COUNT(majs_sosa) FROM `##maj_sosa`'. |
|
| 468 | 468 | ' WHERE majs_gedcom_id=:tree_id AND majs_user_id=:user_id'. |
| 469 | 469 | ' AND majs_gen <= :gen') |
| 470 | 470 | ->execute(array( |
@@ -479,10 +479,10 @@ discard block |
||
| 479 | 479 | * |
| 480 | 480 | * @return number Total number of distinct individual |
| 481 | 481 | */ |
| 482 | - public function getDifferentSosaCount(){ |
|
| 483 | - if(!$this->is_setup) return 0; |
|
| 482 | + public function getDifferentSosaCount() { |
|
| 483 | + if (!$this->is_setup) return 0; |
|
| 484 | 484 | return Database::prepare( |
| 485 | - 'SELECT SQL_CACHE COUNT(DISTINCT majs_i_id) FROM `##maj_sosa`' . |
|
| 485 | + 'SELECT SQL_CACHE COUNT(DISTINCT majs_i_id) FROM `##maj_sosa`'. |
|
| 486 | 486 | ' WHERE majs_gedcom_id=:tree_id AND majs_user_id=:user_id') |
| 487 | 487 | ->execute(array( |
| 488 | 488 | 'tree_id' => $this->tree->getTreeId(), |
@@ -496,10 +496,10 @@ discard block |
||
| 496 | 496 | * @param number $gen Generation |
| 497 | 497 | * @return number Number of distinct Sosa individuals up to generation |
| 498 | 498 | */ |
| 499 | - public function getDifferentSosaCountUpToGeneration($gen){ |
|
| 500 | - if(!$this->is_setup) return 0; |
|
| 499 | + public function getDifferentSosaCountUpToGeneration($gen) { |
|
| 500 | + if (!$this->is_setup) return 0; |
|
| 501 | 501 | return Database::prepare( |
| 502 | - 'SELECT SQL_CACHE COUNT(DISTINCT majs_i_id) FROM `##maj_sosa`' . |
|
| 502 | + 'SELECT SQL_CACHE COUNT(DISTINCT majs_i_id) FROM `##maj_sosa`'. |
|
| 503 | 503 | ' WHERE majs_gedcom_id=:tree_id AND majs_user_id=:user_id'. |
| 504 | 504 | ' AND majs_gen <= :gen') |
| 505 | 505 | ->execute(array( |
@@ -519,11 +519,11 @@ discard block |
||
| 519 | 519 | * @param number $gen Generation |
| 520 | 520 | * @return array Birth statistics array |
| 521 | 521 | */ |
| 522 | - public function getStatsBirthYearInGeneration($gen){ |
|
| 523 | - if(!$this->is_setup) return array('first' => 0, 'avg' => 0, 'last' => 0); |
|
| 522 | + public function getStatsBirthYearInGeneration($gen) { |
|
| 523 | + if (!$this->is_setup) return array('first' => 0, 'avg' => 0, 'last' => 0); |
|
| 524 | 524 | return Database::prepare( |
| 525 | 525 | 'SELECT MIN(majs_birth_year) AS first, AVG(majs_birth_year) AS avg, MAX(majs_birth_year) AS last'. |
| 526 | - ' FROM `##maj_sosa`' . |
|
| 526 | + ' FROM `##maj_sosa`'. |
|
| 527 | 527 | ' WHERE majs_gedcom_id=:tree_id AND majs_user_id=:user_id'. |
| 528 | 528 | ' AND majs_gen=:gen AND NOT majs_birth_year = :birth_year') |
| 529 | 529 | ->execute(array( |
@@ -539,26 +539,26 @@ discard block |
||
| 539 | 539 | * |
| 540 | 540 | * @return number|NULL Mean generation time |
| 541 | 541 | */ |
| 542 | - public function getMeanGenerationTime(){ |
|
| 543 | - if(!$this->is_setup) return; |
|
| 544 | - if(!$this->statistics_tab){ |
|
| 542 | + public function getMeanGenerationTime() { |
|
| 543 | + if (!$this->is_setup) return; |
|
| 544 | + if (!$this->statistics_tab) { |
|
| 545 | 545 | $this->getStatisticsByGeneration(); |
| 546 | 546 | } |
| 547 | 547 | //Linear regression on x=generation and y=birthdate |
| 548 | 548 | $sum_xy = 0; |
| 549 | - $sum_x=0; |
|
| 550 | - $sum_y=0; |
|
| 551 | - $sum_x2=0; |
|
| 552 | - $n=count($this->statistics_tab); |
|
| 553 | - foreach($this->statistics_tab as $gen=>$stats){ |
|
| 554 | - $sum_xy+=$gen*$stats['avgBirth']; |
|
| 555 | - $sum_x+=$gen; |
|
| 556 | - $sum_y+=$stats['avgBirth']; |
|
| 557 | - $sum_x2+=$gen*$gen; |
|
| 549 | + $sum_x = 0; |
|
| 550 | + $sum_y = 0; |
|
| 551 | + $sum_x2 = 0; |
|
| 552 | + $n = count($this->statistics_tab); |
|
| 553 | + foreach ($this->statistics_tab as $gen=>$stats) { |
|
| 554 | + $sum_xy += $gen * $stats['avgBirth']; |
|
| 555 | + $sum_x += $gen; |
|
| 556 | + $sum_y += $stats['avgBirth']; |
|
| 557 | + $sum_x2 += $gen * $gen; |
|
| 558 | 558 | } |
| 559 | - $denom=($n*$sum_x2)-($sum_x*$sum_x); |
|
| 560 | - if($denom!=0){ |
|
| 561 | - return -(($n*$sum_xy)-($sum_x*$sum_y))/($denom); |
|
| 559 | + $denom = ($n * $sum_x2) - ($sum_x * $sum_x); |
|
| 560 | + if ($denom != 0) { |
|
| 561 | + return -(($n * $sum_xy) - ($sum_x * $sum_y)) / ($denom); |
|
| 562 | 562 | } |
| 563 | 563 | return null; |
| 564 | 564 | } |
@@ -586,14 +586,14 @@ discard block |
||
| 586 | 586 | * @return array |
| 587 | 587 | */ |
| 588 | 588 | public function getAncestorDispersionForGen($gen) { |
| 589 | - if(!$this->is_setup || $gen > 11) return array(); // Going further than 11 gen will be out of range in the query |
|
| 589 | + if (!$this->is_setup || $gen > 11) return array(); // Going further than 11 gen will be out of range in the query |
|
| 590 | 590 | return Database::prepare( |
| 591 | 591 | 'SELECT branches, count(i_id)'. |
| 592 | 592 | ' FROM ('. |
| 593 | 593 | ' SELECT i_id,'. |
| 594 | 594 | ' CASE'. |
| 595 | 595 | ' WHEN CEIL(LOG2(SUM(branch))) = LOG2(SUM(branch)) THEN SUM(branch)'. |
| 596 | - ' ELSE -1'. // We put all ancestors shared between some branches in the same bucket |
|
| 596 | + ' ELSE -1'.// We put all ancestors shared between some branches in the same bucket |
|
| 597 | 597 | ' END branches'. |
| 598 | 598 | ' FROM ('. |
| 599 | 599 | ' SELECT DISTINCT majs_i_id i_id,'. |
@@ -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(); |
@@ -224,7 +234,9 @@ discard block |
||
| 224 | 234 | * @return array Array of sosa numbers |
| 225 | 235 | */ |
| 226 | 236 | public function getSosaNumbers(Individual $indi) { |
| 227 | - if(!$this->is_setup) return array(); |
|
| 237 | + if(!$this->is_setup) { |
|
| 238 | + return array(); |
|
| 239 | + } |
|
| 228 | 240 | return Database::prepare( |
| 229 | 241 | 'SELECT majs_sosa, majs_gen FROM `##maj_sosa`'. |
| 230 | 242 | ' WHERE majs_i_id=:indi_id AND majs_gedcom_id=:tree_id AND majs_user_id=:user_id' |
@@ -241,7 +253,9 @@ discard block |
||
| 241 | 253 | * @return number Last generation if found, 1 otherwise |
| 242 | 254 | */ |
| 243 | 255 | public function getLastGeneration() { |
| 244 | - if(!$this->is_setup) return; |
|
| 256 | + if(!$this->is_setup) { |
|
| 257 | + return; |
|
| 258 | + } |
|
| 245 | 259 | return Database::prepare( |
| 246 | 260 | 'SELECT MAX(majs_gen) FROM `##maj_sosa`'. |
| 247 | 261 | ' WHERE majs_gedcom_id=:tree_id AND majs_user_id=:user_id' |
@@ -261,7 +275,9 @@ discard block |
||
| 261 | 275 | * @return array Associative array of Sosa ancestors, with their generation, comma separated |
| 262 | 276 | */ |
| 263 | 277 | public function getAllSosaWithGenerations(){ |
| 264 | - if(!$this->is_setup) return array(); |
|
| 278 | + if(!$this->is_setup) { |
|
| 279 | + return array(); |
|
| 280 | + } |
|
| 265 | 281 | return Database::prepare( |
| 266 | 282 | 'SELECT majs_i_id AS indi,' . |
| 267 | 283 | ' GROUP_CONCAT(DISTINCT majs_gen ORDER BY majs_gen ASC SEPARATOR ",") AS generations' . |
@@ -281,9 +297,12 @@ discard block |
||
| 281 | 297 | * @return array Array of Sosa individuals |
| 282 | 298 | */ |
| 283 | 299 | public function getSosaListAtGeneration($gen){ |
| 284 | - if(!$this->is_setup) return array(); |
|
| 285 | - if(!$this->sosa_list_by_gen) |
|
| 286 | - $this->sosa_list_by_gen = array(); |
|
| 300 | + if(!$this->is_setup) { |
|
| 301 | + return array(); |
|
| 302 | + } |
|
| 303 | + if(!$this->sosa_list_by_gen) { |
|
| 304 | + $this->sosa_list_by_gen = array(); |
|
| 305 | + } |
|
| 287 | 306 | |
| 288 | 307 | if($gen){ |
| 289 | 308 | if(!isset($this->sosa_list_by_gen[$gen])){ |
@@ -312,9 +331,12 @@ discard block |
||
| 312 | 331 | * @return array Array of Sosa families |
| 313 | 332 | */ |
| 314 | 333 | public function getFamilySosaListAtGeneration($gen){ |
| 315 | - if(!$this->is_setup) return array(); |
|
| 316 | - if(!$this->sosa_fam_list_by_gen) |
|
| 317 | - $this->sosa_fam_list_by_gen = array(); |
|
| 334 | + if(!$this->is_setup) { |
|
| 335 | + return array(); |
|
| 336 | + } |
|
| 337 | + if(!$this->sosa_fam_list_by_gen) { |
|
| 338 | + $this->sosa_fam_list_by_gen = array(); |
|
| 339 | + } |
|
| 318 | 340 | |
| 319 | 341 | if($gen){ |
| 320 | 342 | if(!isset($this->sosa_fam_list_by_gen[$gen])){ |
@@ -348,7 +370,9 @@ discard block |
||
| 348 | 370 | * @return array Array of Sosa individuals |
| 349 | 371 | */ |
| 350 | 372 | public function getMissingSosaListAtGeneration($gen){ |
| 351 | - if(!$this->is_setup) return array(); |
|
| 373 | + if(!$this->is_setup) { |
|
| 374 | + return array(); |
|
| 375 | + } |
|
| 352 | 376 | if($gen){ |
| 353 | 377 | return $this->sosa_list_by_gen[$gen] = Database::prepare( |
| 354 | 378 | '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'. |
@@ -386,7 +410,9 @@ discard block |
||
| 386 | 410 | * @return array Statistics array |
| 387 | 411 | */ |
| 388 | 412 | public function getStatisticsByGeneration() { |
| 389 | - if(!$this->is_setup) return array(); |
|
| 413 | + if(!$this->is_setup) { |
|
| 414 | + return array(); |
|
| 415 | + } |
|
| 390 | 416 | if(!$this->statistics_tab) { |
| 391 | 417 | $this->statistics_tab = array(); |
| 392 | 418 | if($maxGeneration = $this->getLastGeneration()) { |
@@ -412,7 +438,9 @@ discard block |
||
| 412 | 438 | * @return int |
| 413 | 439 | */ |
| 414 | 440 | public function getTotalIndividuals() { |
| 415 | - if(!$this->is_setup) return 0; |
|
| 441 | + if(!$this->is_setup) { |
|
| 442 | + return 0; |
|
| 443 | + } |
|
| 416 | 444 | return Database::prepare( |
| 417 | 445 | 'SELECT SQL_CACHE COUNT(*) FROM `##individuals`' . |
| 418 | 446 | ' WHERE i_file = :tree_id') |
@@ -426,7 +454,9 @@ discard block |
||
| 426 | 454 | * @return number Number of Sosas |
| 427 | 455 | */ |
| 428 | 456 | public function getSosaCount(){ |
| 429 | - if(!$this->is_setup) return 0; |
|
| 457 | + if(!$this->is_setup) { |
|
| 458 | + return 0; |
|
| 459 | + } |
|
| 430 | 460 | return Database::prepare( |
| 431 | 461 | 'SELECT SQL_CACHE COUNT(majs_sosa) FROM `##maj_sosa`' . |
| 432 | 462 | ' WHERE majs_gedcom_id=:tree_id AND majs_user_id=:user_id') |
@@ -443,7 +473,9 @@ discard block |
||
| 443 | 473 | * @return number Number of Sosas in generation |
| 444 | 474 | */ |
| 445 | 475 | public function getSosaCountAtGeneration($gen){ |
| 446 | - if(!$this->is_setup) return 0; |
|
| 476 | + if(!$this->is_setup) { |
|
| 477 | + return 0; |
|
| 478 | + } |
|
| 447 | 479 | return Database::prepare( |
| 448 | 480 | 'SELECT SQL_CACHE COUNT(majs_sosa) FROM `##maj_sosa`' . |
| 449 | 481 | ' WHERE majs_gedcom_id=:tree_id AND majs_user_id=:user_id'. |
@@ -462,7 +494,9 @@ discard block |
||
| 462 | 494 | * @return number Total number of Sosas up to generation |
| 463 | 495 | */ |
| 464 | 496 | public function getSosaCountUpToGeneration($gen){ |
| 465 | - if(!$this->is_setup) return 0; |
|
| 497 | + if(!$this->is_setup) { |
|
| 498 | + return 0; |
|
| 499 | + } |
|
| 466 | 500 | return Database::prepare( |
| 467 | 501 | 'SELECT SQL_CACHE COUNT(majs_sosa) FROM `##maj_sosa`' . |
| 468 | 502 | ' WHERE majs_gedcom_id=:tree_id AND majs_user_id=:user_id'. |
@@ -480,7 +514,9 @@ discard block |
||
| 480 | 514 | * @return number Total number of distinct individual |
| 481 | 515 | */ |
| 482 | 516 | public function getDifferentSosaCount(){ |
| 483 | - if(!$this->is_setup) return 0; |
|
| 517 | + if(!$this->is_setup) { |
|
| 518 | + return 0; |
|
| 519 | + } |
|
| 484 | 520 | return Database::prepare( |
| 485 | 521 | 'SELECT SQL_CACHE COUNT(DISTINCT majs_i_id) FROM `##maj_sosa`' . |
| 486 | 522 | ' WHERE majs_gedcom_id=:tree_id AND majs_user_id=:user_id') |
@@ -497,7 +533,9 @@ discard block |
||
| 497 | 533 | * @return number Number of distinct Sosa individuals up to generation |
| 498 | 534 | */ |
| 499 | 535 | public function getDifferentSosaCountUpToGeneration($gen){ |
| 500 | - if(!$this->is_setup) return 0; |
|
| 536 | + if(!$this->is_setup) { |
|
| 537 | + return 0; |
|
| 538 | + } |
|
| 501 | 539 | return Database::prepare( |
| 502 | 540 | 'SELECT SQL_CACHE COUNT(DISTINCT majs_i_id) FROM `##maj_sosa`' . |
| 503 | 541 | ' WHERE majs_gedcom_id=:tree_id AND majs_user_id=:user_id'. |
@@ -520,7 +558,9 @@ discard block |
||
| 520 | 558 | * @return array Birth statistics array |
| 521 | 559 | */ |
| 522 | 560 | public function getStatsBirthYearInGeneration($gen){ |
| 523 | - if(!$this->is_setup) return array('first' => 0, 'avg' => 0, 'last' => 0); |
|
| 561 | + if(!$this->is_setup) { |
|
| 562 | + return array('first' => 0, 'avg' => 0, 'last' => 0); |
|
| 563 | + } |
|
| 524 | 564 | return Database::prepare( |
| 525 | 565 | 'SELECT MIN(majs_birth_year) AS first, AVG(majs_birth_year) AS avg, MAX(majs_birth_year) AS last'. |
| 526 | 566 | ' FROM `##maj_sosa`' . |
@@ -540,7 +580,9 @@ discard block |
||
| 540 | 580 | * @return number|NULL Mean generation time |
| 541 | 581 | */ |
| 542 | 582 | public function getMeanGenerationTime(){ |
| 543 | - if(!$this->is_setup) return; |
|
| 583 | + if(!$this->is_setup) { |
|
| 584 | + return; |
|
| 585 | + } |
|
| 544 | 586 | if(!$this->statistics_tab){ |
| 545 | 587 | $this->getStatisticsByGeneration(); |
| 546 | 588 | } |
@@ -586,7 +628,10 @@ discard block |
||
| 586 | 628 | * @return array |
| 587 | 629 | */ |
| 588 | 630 | public function getAncestorDispersionForGen($gen) { |
| 589 | - if(!$this->is_setup || $gen > 11) return array(); // Going further than 11 gen will be out of range in the query |
|
| 631 | + if(!$this->is_setup || $gen > 11) { |
|
| 632 | + return array(); |
|
| 633 | + } |
|
| 634 | + // Going further than 11 gen will be out of range in the query |
|
| 590 | 635 | return Database::prepare( |
| 591 | 636 | 'SELECT branches, count(i_id)'. |
| 592 | 637 | ' FROM ('. |
@@ -25,14 +25,14 @@ discard block |
||
| 25 | 25 | * @see \MyArtJaub\Webtrees\Map\MapProviderInterface::getProviderPlaceId() |
| 26 | 26 | */ |
| 27 | 27 | public function getProviderPlaceId(\Fisharebest\Webtrees\Place $place) { |
| 28 | - if(!$place->isEmpty()) { |
|
| 29 | - $parent = array_reverse(explode (',', $place->getGedcomName())); |
|
| 28 | + if (!$place->isEmpty()) { |
|
| 29 | + $parent = array_reverse(explode(',', $place->getGedcomName())); |
|
| 30 | 30 | $place_id = 0; |
| 31 | 31 | $nb_levels = count($parent); |
| 32 | - for ($i=0; $i < $nb_levels; $i++) { |
|
| 32 | + for ($i = 0; $i < $nb_levels; $i++) { |
|
| 33 | 33 | $parent[$i] = trim($parent[$i]); |
| 34 | - if (empty($parent[$i])) $parent[$i]='unknown';// GoogleMap module uses "unknown" while GEDCOM uses , , |
|
| 35 | - $pl_id=Database::prepare('SELECT pl_id FROM `##placelocation` WHERE pl_level=? AND pl_parent_id=? AND pl_place LIKE ? ORDER BY pl_place') |
|
| 34 | + if (empty($parent[$i])) $parent[$i] = 'unknown'; // GoogleMap module uses "unknown" while GEDCOM uses , , |
|
| 35 | + $pl_id = Database::prepare('SELECT pl_id FROM `##placelocation` WHERE pl_level=? AND pl_parent_id=? AND pl_place LIKE ? ORDER BY pl_place') |
|
| 36 | 36 | ->execute(array($i, $place_id, $parent[$i])) |
| 37 | 37 | ->fetchOne(); |
| 38 | 38 | if (empty($pl_id)) break; |
@@ -48,12 +48,12 @@ discard block |
||
| 48 | 48 | * @see \MyArtJaub\Webtrees\Map\MapProviderInterface::getPlaceIcon() |
| 49 | 49 | */ |
| 50 | 50 | public function getPlaceIcon(\Fisharebest\Webtrees\Place $place) { |
| 51 | - if(!$place->isEmpty()){ |
|
| 51 | + if (!$place->isEmpty()) { |
|
| 52 | 52 | $place_details = |
| 53 | 53 | Database::prepare('SELECT SQL_CACHE pl_icon FROM `##placelocation` WHERE pl_id=? ORDER BY pl_place') |
| 54 | 54 | ->execute(array($this->getProviderPlaceId($place))) |
| 55 | 55 | ->fetchOneRow(); |
| 56 | - if($place_details){ |
|
| 56 | + if ($place_details) { |
|
| 57 | 57 | return WT_MODULES_DIR.'googlemap/'.$place_details->pl_icon; |
| 58 | 58 | } |
| 59 | 59 | } |
@@ -31,11 +31,16 @@ |
||
| 31 | 31 | $nb_levels = count($parent); |
| 32 | 32 | for ($i=0; $i < $nb_levels; $i++) { |
| 33 | 33 | $parent[$i] = trim($parent[$i]); |
| 34 | - if (empty($parent[$i])) $parent[$i]='unknown';// GoogleMap module uses "unknown" while GEDCOM uses , , |
|
| 34 | + if (empty($parent[$i])) { |
|
| 35 | + $parent[$i]='unknown'; |
|
| 36 | + } |
|
| 37 | + // GoogleMap module uses "unknown" while GEDCOM uses , , |
|
| 35 | 38 | $pl_id=Database::prepare('SELECT pl_id FROM `##placelocation` WHERE pl_level=? AND pl_parent_id=? AND pl_place LIKE ? ORDER BY pl_place') |
| 36 | 39 | ->execute(array($i, $place_id, $parent[$i])) |
| 37 | 40 | ->fetchOne(); |
| 38 | - if (empty($pl_id)) break; |
|
| 41 | + if (empty($pl_id)) { |
|
| 42 | + break; |
|
| 43 | + } |
|
| 39 | 44 | $place_id = $pl_id; |
| 40 | 45 | } |
| 41 | 46 | return $place_id; |
@@ -24,9 +24,9 @@ discard block |
||
| 24 | 24 | * {@inhericDoc} |
| 25 | 25 | * @see \MyArtJaub\Webtrees\Mvc\View\AbstractView::renderContent() |
| 26 | 26 | */ |
| 27 | - protected function renderContent() { |
|
| 27 | + protected function renderContent() { |
|
| 28 | 28 | |
| 29 | - ?> |
|
| 29 | + ?> |
|
| 30 | 30 | |
| 31 | 31 | <div id="maj-sosa-config-page"> |
| 32 | 32 | <h2><?php echo $this->data->get('title'); ?></h2> |
@@ -46,9 +46,9 @@ discard block |
||
| 46 | 46 | </div> |
| 47 | 47 | <div class="value"> |
| 48 | 48 | <?php |
| 49 | - $users = $this->data->get('users_settings'); |
|
| 50 | - if(count($users) == 1) { |
|
| 51 | - $root_indi = $users[0]['rootid']; ?> |
|
| 49 | + $users = $this->data->get('users_settings'); |
|
| 50 | + if(count($users) == 1) { |
|
| 51 | + $root_indi = $users[0]['rootid']; ?> |
|
| 52 | 52 | <label> |
| 53 | 53 | <input id="maj_sosa_input_userid" type="hidden" name="userid" value="<?php echo $users[0]['user']->getUserId(); ?>" /> |
| 54 | 54 | <?php echo $users[0]['user']->getRealNameHtml() ?> |
@@ -56,8 +56,8 @@ discard block |
||
| 56 | 56 | <?php } else if(count($users) > 1) { ?> |
| 57 | 57 | <select id='maj-sosa-config-select' name="userid"> |
| 58 | 58 | <?php |
| 59 | - $root_indi = $users[0]['rootid']; |
|
| 60 | - foreach ($this->data->get('users_settings') as $user) { ?> |
|
| 59 | + $root_indi = $users[0]['rootid']; |
|
| 60 | + foreach ($this->data->get('users_settings') as $user) { ?> |
|
| 61 | 61 | <option value="<?php echo $user['user']->getUserId(); ?>"><?php echo $user['user']->getRealNameHtml() ?></option> |
| 62 | 62 | <?php } ?> |
| 63 | 63 | </select> |
@@ -80,7 +80,7 @@ discard block |
||
| 80 | 80 | </form> |
| 81 | 81 | |
| 82 | 82 | <?php |
| 83 | - } |
|
| 83 | + } |
|
| 84 | 84 | |
| 85 | 85 | } |
| 86 | 86 | |
| 87 | 87 | \ No newline at end of file |
@@ -47,13 +47,13 @@ |
||
| 47 | 47 | <div class="value"> |
| 48 | 48 | <?php |
| 49 | 49 | $users = $this->data->get('users_settings'); |
| 50 | - if(count($users) == 1) { |
|
| 51 | - $root_indi = $users[0]['rootid']; ?> |
|
| 50 | + if (count($users) == 1) { |
|
| 51 | + $root_indi = $users[0]['rootid']; ?> |
|
| 52 | 52 | <label> |
| 53 | 53 | <input id="maj_sosa_input_userid" type="hidden" name="userid" value="<?php echo $users[0]['user']->getUserId(); ?>" /> |
| 54 | 54 | <?php echo $users[0]['user']->getRealNameHtml() ?> |
| 55 | 55 | </label> |
| 56 | - <?php } else if(count($users) > 1) { ?> |
|
| 56 | + <?php } else if (count($users) > 1) { ?> |
|
| 57 | 57 | <select id='maj-sosa-config-select' name="userid"> |
| 58 | 58 | <?php |
| 59 | 59 | $root_indi = $users[0]['rootid']; |
@@ -31,116 +31,116 @@ discard block |
||
| 31 | 31 | * Sosa Module. |
| 32 | 32 | */ |
| 33 | 33 | class SosaModule |
| 34 | - extends AbstractModule |
|
| 35 | - implements ModuleMenuInterface, |
|
| 36 | - ModuleConfigInterface, |
|
| 37 | - HookSubscriberInterface, |
|
| 38 | - IndividualHeaderExtenderInterface, |
|
| 39 | - RecordNameTextExtenderInterface |
|
| 34 | + extends AbstractModule |
|
| 35 | + implements ModuleMenuInterface, |
|
| 36 | + ModuleConfigInterface, |
|
| 37 | + HookSubscriberInterface, |
|
| 38 | + IndividualHeaderExtenderInterface, |
|
| 39 | + RecordNameTextExtenderInterface |
|
| 40 | 40 | { |
| 41 | - // How to update the database schema for this module |
|
| 42 | - const SCHEMA_TARGET_VERSION = 1; |
|
| 43 | - const SCHEMA_SETTING_NAME = 'MAJ_SOSA_SCHEMA_VERSION'; |
|
| 44 | - const SCHEMA_MIGRATION_PREFIX = '\MyArtJaub\Webtrees\Module\Sosa\Schema'; |
|
| 41 | + // How to update the database schema for this module |
|
| 42 | + const SCHEMA_TARGET_VERSION = 1; |
|
| 43 | + const SCHEMA_SETTING_NAME = 'MAJ_SOSA_SCHEMA_VERSION'; |
|
| 44 | + const SCHEMA_MIGRATION_PREFIX = '\MyArtJaub\Webtrees\Module\Sosa\Schema'; |
|
| 45 | 45 | |
| 46 | - /** @var string For custom modules - link for support, upgrades, etc. */ |
|
| 47 | - const CUSTOM_WEBSITE = 'https://github.com/jon48/webtrees-lib'; |
|
| 48 | - |
|
| 49 | - /** |
|
| 50 | - * {@inhericDoc} |
|
| 51 | - */ |
|
| 52 | - public function getTitle() { |
|
| 53 | - return /* I18N: Name of the “Sosa” module */ I18N::translate('Sosa'); |
|
| 54 | - } |
|
| 55 | - |
|
| 56 | - /** |
|
| 57 | - * {@inhericDoc} |
|
| 58 | - */ |
|
| 59 | - public function getDescription() { |
|
| 60 | - return /* I18N: Description of the “Sosa” module */ I18N::translate('Calculate and display Sosa ancestors of the root person.'); |
|
| 61 | - } |
|
| 62 | - |
|
| 63 | - /** |
|
| 64 | - * {@inhericDoc} |
|
| 65 | - */ |
|
| 66 | - public function modAction($mod_action) { |
|
| 67 | - Database::updateSchema(self::SCHEMA_MIGRATION_PREFIX, self::SCHEMA_SETTING_NAME, self::SCHEMA_TARGET_VERSION); |
|
| 46 | + /** @var string For custom modules - link for support, upgrades, etc. */ |
|
| 47 | + const CUSTOM_WEBSITE = 'https://github.com/jon48/webtrees-lib'; |
|
| 48 | + |
|
| 49 | + /** |
|
| 50 | + * {@inhericDoc} |
|
| 51 | + */ |
|
| 52 | + public function getTitle() { |
|
| 53 | + return /* I18N: Name of the “Sosa” module */ I18N::translate('Sosa'); |
|
| 54 | + } |
|
| 55 | + |
|
| 56 | + /** |
|
| 57 | + * {@inhericDoc} |
|
| 58 | + */ |
|
| 59 | + public function getDescription() { |
|
| 60 | + return /* I18N: Description of the “Sosa” module */ I18N::translate('Calculate and display Sosa ancestors of the root person.'); |
|
| 61 | + } |
|
| 62 | + |
|
| 63 | + /** |
|
| 64 | + * {@inhericDoc} |
|
| 65 | + */ |
|
| 66 | + public function modAction($mod_action) { |
|
| 67 | + Database::updateSchema(self::SCHEMA_MIGRATION_PREFIX, self::SCHEMA_SETTING_NAME, self::SCHEMA_TARGET_VERSION); |
|
| 68 | 68 | |
| 69 | - \MyArtJaub\Webtrees\Mvc\Dispatcher::getInstance()->handle($this, $mod_action); |
|
| 70 | - } |
|
| 69 | + \MyArtJaub\Webtrees\Mvc\Dispatcher::getInstance()->handle($this, $mod_action); |
|
| 70 | + } |
|
| 71 | 71 | |
| 72 | - /********** |
|
| 72 | + /********** |
|
| 73 | 73 | * ModuleConfigInterface |
| 74 | 74 | **********/ |
| 75 | 75 | |
| 76 | - /** |
|
| 77 | - * {@inhericDoc} |
|
| 78 | - * @see \Fisharebest\Webtrees\Module\ModuleConfigInterface::getConfigLink() |
|
| 79 | - */ |
|
| 80 | - public function getConfigLink() { |
|
| 81 | - Database::updateSchema(self::SCHEMA_MIGRATION_PREFIX, self::SCHEMA_SETTING_NAME, self::SCHEMA_TARGET_VERSION); |
|
| 76 | + /** |
|
| 77 | + * {@inhericDoc} |
|
| 78 | + * @see \Fisharebest\Webtrees\Module\ModuleConfigInterface::getConfigLink() |
|
| 79 | + */ |
|
| 80 | + public function getConfigLink() { |
|
| 81 | + Database::updateSchema(self::SCHEMA_MIGRATION_PREFIX, self::SCHEMA_SETTING_NAME, self::SCHEMA_TARGET_VERSION); |
|
| 82 | 82 | |
| 83 | - return 'module.php?mod=' . $this->getName() . '&mod_action=SosaConfig'; |
|
| 84 | - } |
|
| 83 | + return 'module.php?mod=' . $this->getName() . '&mod_action=SosaConfig'; |
|
| 84 | + } |
|
| 85 | 85 | |
| 86 | - /********** |
|
| 86 | + /********** |
|
| 87 | 87 | * ModuleMenuInterface |
| 88 | 88 | **********/ |
| 89 | 89 | |
| 90 | - /** |
|
| 91 | - * {@inhericDoc} |
|
| 92 | - * @see \Fisharebest\Webtrees\Module\ModuleMenuInterface::defaultMenuOrder() |
|
| 93 | - */ |
|
| 94 | - public function defaultMenuOrder() { |
|
| 95 | - return 5; |
|
| 96 | - } |
|
| 97 | - |
|
| 98 | - /** |
|
| 99 | - * {@inhericDoc} |
|
| 100 | - * @see \Fisharebest\Webtrees\Module\ModuleMenuInterface::getMenu() |
|
| 101 | - */ |
|
| 102 | - public function getMenu() { |
|
| 103 | - global $WT_TREE, $controller; |
|
| 90 | + /** |
|
| 91 | + * {@inhericDoc} |
|
| 92 | + * @see \Fisharebest\Webtrees\Module\ModuleMenuInterface::defaultMenuOrder() |
|
| 93 | + */ |
|
| 94 | + public function defaultMenuOrder() { |
|
| 95 | + return 5; |
|
| 96 | + } |
|
| 97 | + |
|
| 98 | + /** |
|
| 99 | + * {@inhericDoc} |
|
| 100 | + * @see \Fisharebest\Webtrees\Module\ModuleMenuInterface::getMenu() |
|
| 101 | + */ |
|
| 102 | + public function getMenu() { |
|
| 103 | + global $WT_TREE, $controller; |
|
| 104 | 104 | |
| 105 | - $menu = null; |
|
| 106 | - if(ModuleManager::getInstance()->isOperational($this->getName())) { |
|
| 105 | + $menu = null; |
|
| 106 | + if(ModuleManager::getInstance()->isOperational($this->getName())) { |
|
| 107 | 107 | |
| 108 | - $root_url = 'module.php?mod=' . $this->getName() . '&ged=' . $WT_TREE->getNameUrl() . '&'; |
|
| 109 | - $sosa_stat_menu = new Menu(I18N::translate('Sosa Statistics'), $root_url . 'mod_action=SosaStats', 'menu-maj-sosa-stats'); |
|
| 108 | + $root_url = 'module.php?mod=' . $this->getName() . '&ged=' . $WT_TREE->getNameUrl() . '&'; |
|
| 109 | + $sosa_stat_menu = new Menu(I18N::translate('Sosa Statistics'), $root_url . 'mod_action=SosaStats', 'menu-maj-sosa-stats'); |
|
| 110 | 110 | |
| 111 | - $menu = clone $sosa_stat_menu; |
|
| 112 | - $menu->setClass('menu-maj-sosa'); |
|
| 111 | + $menu = clone $sosa_stat_menu; |
|
| 112 | + $menu->setClass('menu-maj-sosa'); |
|
| 113 | 113 | |
| 114 | - $submenus = array_filter(array( |
|
| 115 | - new Menu(I18N::translate('Sosa Ancestors'), $root_url . 'mod_action=SosaList', 'menu-maj-sosa-list', array('rel' => 'nofollow')), |
|
| 116 | - new Menu(I18N::translate('Missing Ancestors'), $root_url . 'mod_action=SosaList@missing', 'menu-maj-sosa-missing', array('rel' => 'nofollow')), |
|
| 117 | - $sosa_stat_menu |
|
| 118 | - )); |
|
| 114 | + $submenus = array_filter(array( |
|
| 115 | + new Menu(I18N::translate('Sosa Ancestors'), $root_url . 'mod_action=SosaList', 'menu-maj-sosa-list', array('rel' => 'nofollow')), |
|
| 116 | + new Menu(I18N::translate('Missing Ancestors'), $root_url . 'mod_action=SosaList@missing', 'menu-maj-sosa-missing', array('rel' => 'nofollow')), |
|
| 117 | + $sosa_stat_menu |
|
| 118 | + )); |
|
| 119 | 119 | |
| 120 | 120 | |
| 121 | - if (ModuleManager::getInstance()->isOperational(Constants::MODULE_MAJ_GEODISP_NAME) |
|
| 122 | - && $ga_list = Module::getModuleByName(Constants::MODULE_MAJ_GEODISP_NAME)->getProvider()->getGeoAnalysisList() |
|
| 123 | - ) |
|
| 124 | - { |
|
| 125 | - if(count($ga_list) > 0) { |
|
| 126 | - $submenus[] = new Menu(I18N::translate('Geographical Dispersion'), 'module.php?mod=' . Constants::MODULE_MAJ_GEODISP_NAME . '&ged=' . $WT_TREE->getNameUrl() . '&mod_action=GeoAnalysis@listAll', 'menu-maj-sosa-geodispersion'); |
|
| 127 | - } |
|
| 128 | - } |
|
| 121 | + if (ModuleManager::getInstance()->isOperational(Constants::MODULE_MAJ_GEODISP_NAME) |
|
| 122 | + && $ga_list = Module::getModuleByName(Constants::MODULE_MAJ_GEODISP_NAME)->getProvider()->getGeoAnalysisList() |
|
| 123 | + ) |
|
| 124 | + { |
|
| 125 | + if(count($ga_list) > 0) { |
|
| 126 | + $submenus[] = new Menu(I18N::translate('Geographical Dispersion'), 'module.php?mod=' . Constants::MODULE_MAJ_GEODISP_NAME . '&ged=' . $WT_TREE->getNameUrl() . '&mod_action=GeoAnalysis@listAll', 'menu-maj-sosa-geodispersion'); |
|
| 127 | + } |
|
| 128 | + } |
|
| 129 | 129 | |
| 130 | - if(Auth::check()) { |
|
| 131 | - $submenus[] = new Menu( |
|
| 132 | - I18N::translate('Sosa Configuration'), |
|
| 133 | - $this->getConfigLink(), |
|
| 134 | - 'menu-maj-sosa-configuration', |
|
| 135 | - array('rel' => 'nofollow')); |
|
| 136 | - } |
|
| 130 | + if(Auth::check()) { |
|
| 131 | + $submenus[] = new Menu( |
|
| 132 | + I18N::translate('Sosa Configuration'), |
|
| 133 | + $this->getConfigLink(), |
|
| 134 | + 'menu-maj-sosa-configuration', |
|
| 135 | + array('rel' => 'nofollow')); |
|
| 136 | + } |
|
| 137 | 137 | |
| 138 | - //-- recompute Sosa submenu |
|
| 139 | - if (!empty($controller) && $controller instanceof IndividualController |
|
| 140 | - && Auth::check() && $WT_TREE->getUserPreference(Auth::user(), 'MAJ_SOSA_ROOT_ID') |
|
| 141 | - ) { |
|
| 142 | - $controller |
|
| 143 | - ->addInlineJavascript(' |
|
| 138 | + //-- recompute Sosa submenu |
|
| 139 | + if (!empty($controller) && $controller instanceof IndividualController |
|
| 140 | + && Auth::check() && $WT_TREE->getUserPreference(Auth::user(), 'MAJ_SOSA_ROOT_ID') |
|
| 141 | + ) { |
|
| 142 | + $controller |
|
| 143 | + ->addInlineJavascript(' |
|
| 144 | 144 | function majComputeSosaFromIndi(){ |
| 145 | 145 | if($("#computesosadlg").length == 0) { |
| 146 | 146 | $("body").append("<div id=\"computesosadlg\" title=\"'. I18N::translate('Sosas computation') .'\"><div id=\"sosaloadingarea\"></div></div>"); |
@@ -163,87 +163,87 @@ discard block |
||
| 163 | 163 | }); |
| 164 | 164 | }'); |
| 165 | 165 | |
| 166 | - $submenus[] = new Menu( |
|
| 167 | - I18N::translate('Complete Sosas'), |
|
| 168 | - '#', |
|
| 169 | - 'menu-maj-sosa-recompute', |
|
| 170 | - array( |
|
| 171 | - 'rel' => 'nofollow', |
|
| 172 | - 'onclick' => 'return majComputeSosaFromIndi();' |
|
| 173 | - )); |
|
| 174 | - } |
|
| 166 | + $submenus[] = new Menu( |
|
| 167 | + I18N::translate('Complete Sosas'), |
|
| 168 | + '#', |
|
| 169 | + 'menu-maj-sosa-recompute', |
|
| 170 | + array( |
|
| 171 | + 'rel' => 'nofollow', |
|
| 172 | + 'onclick' => 'return majComputeSosaFromIndi();' |
|
| 173 | + )); |
|
| 174 | + } |
|
| 175 | 175 | |
| 176 | - } |
|
| 176 | + } |
|
| 177 | 177 | |
| 178 | - $menu->setSubmenus($submenus); |
|
| 178 | + $menu->setSubmenus($submenus); |
|
| 179 | 179 | |
| 180 | - return $menu; |
|
| 180 | + return $menu; |
|
| 181 | 181 | |
| 182 | - } |
|
| 182 | + } |
|
| 183 | 183 | |
| 184 | - /********** |
|
| 184 | + /********** |
|
| 185 | 185 | * Hooks |
| 186 | 186 | **********/ |
| 187 | 187 | |
| 188 | - /** |
|
| 189 | - * {@inhericDoc} |
|
| 190 | - * @see \MyArtJaub\Webtrees\Hook\HookSubscriberInterface::getSubscribedHooks() |
|
| 191 | - */ |
|
| 192 | - public function getSubscribedHooks() { |
|
| 193 | - return array( |
|
| 194 | - 'hExtendIndiHeaderIcons' => 20, |
|
| 195 | - 'hExtendIndiHeaderRight' => 20, |
|
| 196 | - 'hRecordNameAppend' => 20 |
|
| 197 | - ); |
|
| 198 | - } |
|
| 199 | - |
|
| 200 | - /** |
|
| 201 | - * {@inhericDoc} |
|
| 202 | - * @see \MyArtJaub\Webtrees\Hook\HookInterfaces\IndividualHeaderExtenderInterface::hExtendIndiHeaderIcons() |
|
| 203 | - */ |
|
| 204 | - public function hExtendIndiHeaderIcons(IndividualController $ctrlIndi) { |
|
| 205 | - if($ctrlIndi){ |
|
| 206 | - $dindi = new Individual($ctrlIndi->getSignificantIndividual()); |
|
| 207 | - return FunctionsPrint::formatSosaNumbers($dindi->getSosaNumbers(), 1, 'large'); |
|
| 208 | - } |
|
| 209 | - return ''; |
|
| 210 | - } |
|
| 211 | - |
|
| 212 | - /** |
|
| 213 | - * {@inhericDoc} |
|
| 214 | - * @see \MyArtJaub\Webtrees\Hook\HookInterfaces\IndividualHeaderExtenderInterface::hExtendIndiHeaderLeft() |
|
| 215 | - */ |
|
| 216 | - public function hExtendIndiHeaderLeft(IndividualController $ctrlIndi) { } |
|
| 217 | - |
|
| 218 | - /** |
|
| 219 | - * {@inhericDoc} |
|
| 220 | - * @see \MyArtJaub\Webtrees\Hook\HookInterfaces\IndividualHeaderExtenderInterface::hExtendIndiHeaderRight() |
|
| 221 | - */ |
|
| 222 | - public function hExtendIndiHeaderRight(IndividualController $ctrlIndi) { |
|
| 223 | - if($ctrlIndi){ |
|
| 224 | - $dindi = new Individual($ctrlIndi->getSignificantIndividual()); |
|
| 225 | - return array('indi-header-sosa', FunctionsPrint::formatSosaNumbers($dindi->getSosaNumbers(), 2, 'normal')); |
|
| 226 | - } |
|
| 227 | - return ''; |
|
| 228 | - } |
|
| 229 | - |
|
| 230 | - /** |
|
| 231 | - * {@inhericDoc} |
|
| 232 | - * @see \MyArtJaub\Webtrees\Hook\HookInterfaces\RecordNameTextExtenderInterface::hRecordNameAppend() |
|
| 233 | - */ |
|
| 234 | - public function hRecordNameAppend(GedcomRecord $grec) { |
|
| 235 | - if($grec instanceof \Fisharebest\Webtrees\Individual){ // Only apply to individuals |
|
| 236 | - $dindi = new Individual($grec); |
|
| 237 | - return FunctionsPrint::formatSosaNumbers($dindi->getSosaNumbers(), 1, 'small'); |
|
| 238 | - } |
|
| 239 | - return ''; |
|
| 240 | - } |
|
| 241 | - |
|
| 242 | - /** |
|
| 243 | - * {@inhericDoc} |
|
| 244 | - * @see \MyArtJaub\Webtrees\Hook\HookInterfaces\RecordNameTextExtenderInterface::hRecordNamePrepend() |
|
| 245 | - */ |
|
| 246 | - public function hRecordNamePrepend(GedcomRecord $grec) {} |
|
| 188 | + /** |
|
| 189 | + * {@inhericDoc} |
|
| 190 | + * @see \MyArtJaub\Webtrees\Hook\HookSubscriberInterface::getSubscribedHooks() |
|
| 191 | + */ |
|
| 192 | + public function getSubscribedHooks() { |
|
| 193 | + return array( |
|
| 194 | + 'hExtendIndiHeaderIcons' => 20, |
|
| 195 | + 'hExtendIndiHeaderRight' => 20, |
|
| 196 | + 'hRecordNameAppend' => 20 |
|
| 197 | + ); |
|
| 198 | + } |
|
| 199 | + |
|
| 200 | + /** |
|
| 201 | + * {@inhericDoc} |
|
| 202 | + * @see \MyArtJaub\Webtrees\Hook\HookInterfaces\IndividualHeaderExtenderInterface::hExtendIndiHeaderIcons() |
|
| 203 | + */ |
|
| 204 | + public function hExtendIndiHeaderIcons(IndividualController $ctrlIndi) { |
|
| 205 | + if($ctrlIndi){ |
|
| 206 | + $dindi = new Individual($ctrlIndi->getSignificantIndividual()); |
|
| 207 | + return FunctionsPrint::formatSosaNumbers($dindi->getSosaNumbers(), 1, 'large'); |
|
| 208 | + } |
|
| 209 | + return ''; |
|
| 210 | + } |
|
| 211 | + |
|
| 212 | + /** |
|
| 213 | + * {@inhericDoc} |
|
| 214 | + * @see \MyArtJaub\Webtrees\Hook\HookInterfaces\IndividualHeaderExtenderInterface::hExtendIndiHeaderLeft() |
|
| 215 | + */ |
|
| 216 | + public function hExtendIndiHeaderLeft(IndividualController $ctrlIndi) { } |
|
| 217 | + |
|
| 218 | + /** |
|
| 219 | + * {@inhericDoc} |
|
| 220 | + * @see \MyArtJaub\Webtrees\Hook\HookInterfaces\IndividualHeaderExtenderInterface::hExtendIndiHeaderRight() |
|
| 221 | + */ |
|
| 222 | + public function hExtendIndiHeaderRight(IndividualController $ctrlIndi) { |
|
| 223 | + if($ctrlIndi){ |
|
| 224 | + $dindi = new Individual($ctrlIndi->getSignificantIndividual()); |
|
| 225 | + return array('indi-header-sosa', FunctionsPrint::formatSosaNumbers($dindi->getSosaNumbers(), 2, 'normal')); |
|
| 226 | + } |
|
| 227 | + return ''; |
|
| 228 | + } |
|
| 229 | + |
|
| 230 | + /** |
|
| 231 | + * {@inhericDoc} |
|
| 232 | + * @see \MyArtJaub\Webtrees\Hook\HookInterfaces\RecordNameTextExtenderInterface::hRecordNameAppend() |
|
| 233 | + */ |
|
| 234 | + public function hRecordNameAppend(GedcomRecord $grec) { |
|
| 235 | + if($grec instanceof \Fisharebest\Webtrees\Individual){ // Only apply to individuals |
|
| 236 | + $dindi = new Individual($grec); |
|
| 237 | + return FunctionsPrint::formatSosaNumbers($dindi->getSosaNumbers(), 1, 'small'); |
|
| 238 | + } |
|
| 239 | + return ''; |
|
| 240 | + } |
|
| 241 | + |
|
| 242 | + /** |
|
| 243 | + * {@inhericDoc} |
|
| 244 | + * @see \MyArtJaub\Webtrees\Hook\HookInterfaces\RecordNameTextExtenderInterface::hRecordNamePrepend() |
|
| 245 | + */ |
|
| 246 | + public function hRecordNamePrepend(GedcomRecord $grec) {} |
|
| 247 | 247 | |
| 248 | 248 | |
| 249 | 249 | |
@@ -80,7 +80,7 @@ discard block |
||
| 80 | 80 | public function getConfigLink() { |
| 81 | 81 | Database::updateSchema(self::SCHEMA_MIGRATION_PREFIX, self::SCHEMA_SETTING_NAME, self::SCHEMA_TARGET_VERSION); |
| 82 | 82 | |
| 83 | - return 'module.php?mod=' . $this->getName() . '&mod_action=SosaConfig'; |
|
| 83 | + return 'module.php?mod='.$this->getName().'&mod_action=SosaConfig'; |
|
| 84 | 84 | } |
| 85 | 85 | |
| 86 | 86 | /********** |
@@ -103,17 +103,17 @@ discard block |
||
| 103 | 103 | global $WT_TREE, $controller; |
| 104 | 104 | |
| 105 | 105 | $menu = null; |
| 106 | - if(ModuleManager::getInstance()->isOperational($this->getName())) { |
|
| 106 | + if (ModuleManager::getInstance()->isOperational($this->getName())) { |
|
| 107 | 107 | |
| 108 | - $root_url = 'module.php?mod=' . $this->getName() . '&ged=' . $WT_TREE->getNameUrl() . '&'; |
|
| 109 | - $sosa_stat_menu = new Menu(I18N::translate('Sosa Statistics'), $root_url . 'mod_action=SosaStats', 'menu-maj-sosa-stats'); |
|
| 108 | + $root_url = 'module.php?mod='.$this->getName().'&ged='.$WT_TREE->getNameUrl().'&'; |
|
| 109 | + $sosa_stat_menu = new Menu(I18N::translate('Sosa Statistics'), $root_url.'mod_action=SosaStats', 'menu-maj-sosa-stats'); |
|
| 110 | 110 | |
| 111 | 111 | $menu = clone $sosa_stat_menu; |
| 112 | 112 | $menu->setClass('menu-maj-sosa'); |
| 113 | 113 | |
| 114 | 114 | $submenus = array_filter(array( |
| 115 | - new Menu(I18N::translate('Sosa Ancestors'), $root_url . 'mod_action=SosaList', 'menu-maj-sosa-list', array('rel' => 'nofollow')), |
|
| 116 | - new Menu(I18N::translate('Missing Ancestors'), $root_url . 'mod_action=SosaList@missing', 'menu-maj-sosa-missing', array('rel' => 'nofollow')), |
|
| 115 | + new Menu(I18N::translate('Sosa Ancestors'), $root_url.'mod_action=SosaList', 'menu-maj-sosa-list', array('rel' => 'nofollow')), |
|
| 116 | + new Menu(I18N::translate('Missing Ancestors'), $root_url.'mod_action=SosaList@missing', 'menu-maj-sosa-missing', array('rel' => 'nofollow')), |
|
| 117 | 117 | $sosa_stat_menu |
| 118 | 118 | )); |
| 119 | 119 | |
@@ -122,12 +122,12 @@ discard block |
||
| 122 | 122 | && $ga_list = Module::getModuleByName(Constants::MODULE_MAJ_GEODISP_NAME)->getProvider()->getGeoAnalysisList() |
| 123 | 123 | ) |
| 124 | 124 | { |
| 125 | - if(count($ga_list) > 0) { |
|
| 126 | - $submenus[] = new Menu(I18N::translate('Geographical Dispersion'), 'module.php?mod=' . Constants::MODULE_MAJ_GEODISP_NAME . '&ged=' . $WT_TREE->getNameUrl() . '&mod_action=GeoAnalysis@listAll', 'menu-maj-sosa-geodispersion'); |
|
| 125 | + if (count($ga_list) > 0) { |
|
| 126 | + $submenus[] = new Menu(I18N::translate('Geographical Dispersion'), 'module.php?mod='.Constants::MODULE_MAJ_GEODISP_NAME.'&ged='.$WT_TREE->getNameUrl().'&mod_action=GeoAnalysis@listAll', 'menu-maj-sosa-geodispersion'); |
|
| 127 | 127 | } |
| 128 | 128 | } |
| 129 | 129 | |
| 130 | - if(Auth::check()) { |
|
| 130 | + if (Auth::check()) { |
|
| 131 | 131 | $submenus[] = new Menu( |
| 132 | 132 | I18N::translate('Sosa Configuration'), |
| 133 | 133 | $this->getConfigLink(), |
@@ -143,7 +143,7 @@ discard block |
||
| 143 | 143 | ->addInlineJavascript(' |
| 144 | 144 | function majComputeSosaFromIndi(){ |
| 145 | 145 | if($("#computesosadlg").length == 0) { |
| 146 | - $("body").append("<div id=\"computesosadlg\" title=\"'. I18N::translate('Sosas computation') .'\"><div id=\"sosaloadingarea\"></div></div>"); |
|
| 146 | + $("body").append("<div id=\"computesosadlg\" title=\"'. I18N::translate('Sosas computation').'\"><div id=\"sosaloadingarea\"></div></div>"); |
|
| 147 | 147 | } |
| 148 | 148 | $("#computesosadlg").dialog({ |
| 149 | 149 | modal: true, |
@@ -152,7 +152,7 @@ discard block |
||
| 152 | 152 | open: function(event, ui) { |
| 153 | 153 | $("button.ui-dialog-titlebar-close").hide(); |
| 154 | 154 | $("#sosaloadingarea").empty().html("<i class=\"icon-loading-small\"></i>"); |
| 155 | - $("#sosaloadingarea").load("module.php?mod=' . $this->getName() . '&mod_action=SosaConfig@computePartial&ged='. $WT_TREE->getNameUrl() .'&userid='.Auth::user()->getUserId().'&pid=' . $controller->getSignificantIndividual()->getXref() . '", |
|
| 155 | + $("#sosaloadingarea").load("module.php?mod=' . $this->getName().'&mod_action=SosaConfig@computePartial&ged='.$WT_TREE->getNameUrl().'&userid='.Auth::user()->getUserId().'&pid='.$controller->getSignificantIndividual()->getXref().'", |
|
| 156 | 156 | function(){ |
| 157 | 157 | $("button.ui-dialog-titlebar-close").show(); |
| 158 | 158 | setTimeout(function(){ |
@@ -202,7 +202,7 @@ discard block |
||
| 202 | 202 | * @see \MyArtJaub\Webtrees\Hook\HookInterfaces\IndividualHeaderExtenderInterface::hExtendIndiHeaderIcons() |
| 203 | 203 | */ |
| 204 | 204 | public function hExtendIndiHeaderIcons(IndividualController $ctrlIndi) { |
| 205 | - if($ctrlIndi){ |
|
| 205 | + if ($ctrlIndi) { |
|
| 206 | 206 | $dindi = new Individual($ctrlIndi->getSignificantIndividual()); |
| 207 | 207 | return FunctionsPrint::formatSosaNumbers($dindi->getSosaNumbers(), 1, 'large'); |
| 208 | 208 | } |
@@ -220,9 +220,9 @@ discard block |
||
| 220 | 220 | * @see \MyArtJaub\Webtrees\Hook\HookInterfaces\IndividualHeaderExtenderInterface::hExtendIndiHeaderRight() |
| 221 | 221 | */ |
| 222 | 222 | public function hExtendIndiHeaderRight(IndividualController $ctrlIndi) { |
| 223 | - if($ctrlIndi){ |
|
| 223 | + if ($ctrlIndi) { |
|
| 224 | 224 | $dindi = new Individual($ctrlIndi->getSignificantIndividual()); |
| 225 | - return array('indi-header-sosa', FunctionsPrint::formatSosaNumbers($dindi->getSosaNumbers(), 2, 'normal')); |
|
| 225 | + return array('indi-header-sosa', FunctionsPrint::formatSosaNumbers($dindi->getSosaNumbers(), 2, 'normal')); |
|
| 226 | 226 | } |
| 227 | 227 | return ''; |
| 228 | 228 | } |
@@ -232,7 +232,7 @@ discard block |
||
| 232 | 232 | * @see \MyArtJaub\Webtrees\Hook\HookInterfaces\RecordNameTextExtenderInterface::hRecordNameAppend() |
| 233 | 233 | */ |
| 234 | 234 | public function hRecordNameAppend(GedcomRecord $grec) { |
| 235 | - if($grec instanceof \Fisharebest\Webtrees\Individual){ // Only apply to individuals |
|
| 235 | + if ($grec instanceof \Fisharebest\Webtrees\Individual) { // Only apply to individuals |
|
| 236 | 236 | $dindi = new Individual($grec); |
| 237 | 237 | return FunctionsPrint::formatSosaNumbers($dindi->getSosaNumbers(), 1, 'small'); |
| 238 | 238 | } |
@@ -43,11 +43,11 @@ discard block |
||
| 43 | 43 | */ |
| 44 | 44 | public static function getInstance() |
| 45 | 45 | { |
| 46 | - if (null === static::$instance) { |
|
| 47 | - static::$instance = new static(); |
|
| 48 | - } |
|
| 46 | + if (null === static::$instance) { |
|
| 47 | + static::$instance = new static(); |
|
| 48 | + } |
|
| 49 | 49 | |
| 50 | - return static::$instance; |
|
| 50 | + return static::$instance; |
|
| 51 | 51 | } |
| 52 | 52 | |
| 53 | 53 | /** |
@@ -55,7 +55,7 @@ discard block |
||
| 55 | 55 | * @see \MyArtJaub\Webtrees\Hook\HookProviderInterface::get() |
| 56 | 56 | */ |
| 57 | 57 | public function get($hook_function, $hook_context = null) { |
| 58 | - return new Hook($hook_function, $hook_context); |
|
| 58 | + return new Hook($hook_function, $hook_context); |
|
| 59 | 59 | } |
| 60 | 60 | |
| 61 | 61 | /** |
@@ -73,20 +73,20 @@ discard block |
||
| 73 | 73 | public function getPossibleHooks() { |
| 74 | 74 | static $hooks=null; |
| 75 | 75 | if ($hooks === null) { |
| 76 | - $hooks = array(); |
|
| 76 | + $hooks = array(); |
|
| 77 | 77 | |
| 78 | - // Cannot use the same logic as the core Module loading, |
|
| 79 | - // as this forces a new include of the module.php file. |
|
| 80 | - // This causes issue when classes are defined in this file. |
|
| 81 | - // Cannot use Module::getActiveModules as well, as this is private. |
|
| 82 | - $module_names = Database::prepare( |
|
| 83 | - 'SELECT SQL_CACHE module_name FROM `##module`' |
|
| 84 | - )->fetchOneColumn(); |
|
| 78 | + // Cannot use the same logic as the core Module loading, |
|
| 79 | + // as this forces a new include of the module.php file. |
|
| 80 | + // This causes issue when classes are defined in this file. |
|
| 81 | + // Cannot use Module::getActiveModules as well, as this is private. |
|
| 82 | + $module_names = Database::prepare( |
|
| 83 | + 'SELECT SQL_CACHE module_name FROM `##module`' |
|
| 84 | + )->fetchOneColumn(); |
|
| 85 | 85 | |
| 86 | - foreach($module_names as $module_name) { |
|
| 87 | - $module = Module::getModuleByName($module_name); |
|
| 86 | + foreach($module_names as $module_name) { |
|
| 87 | + $module = Module::getModuleByName($module_name); |
|
| 88 | 88 | |
| 89 | - if($module instanceof HookSubscriberInterface){ |
|
| 89 | + if($module instanceof HookSubscriberInterface){ |
|
| 90 | 90 | $subscribedhooks = $module->getSubscribedHooks(); |
| 91 | 91 | if(is_array($subscribedhooks)){ |
| 92 | 92 | foreach($subscribedhooks as $key => $value){ |
@@ -111,7 +111,7 @@ discard block |
||
| 111 | 111 | } |
| 112 | 112 | } |
| 113 | 113 | } |
| 114 | - } |
|
| 114 | + } |
|
| 115 | 115 | } |
| 116 | 116 | } |
| 117 | 117 | return $hooks; |
@@ -153,33 +153,33 @@ discard block |
||
| 153 | 153 | */ |
| 154 | 154 | public function updateHooks() { |
| 155 | 155 | |
| 156 | - if(Auth::isAdmin()){ |
|
| 157 | - $ihooks = self::getInstalledHooks(); |
|
| 158 | - $phooks = self::getPossibleHooks(); |
|
| 156 | + if(Auth::isAdmin()){ |
|
| 157 | + $ihooks = self::getInstalledHooks(); |
|
| 158 | + $phooks = self::getPossibleHooks(); |
|
| 159 | 159 | |
| 160 | - // Insert hooks not existing yet in the DB |
|
| 161 | - if($phooks !== null){ |
|
| 162 | - foreach($phooks as $phook => $priority){ |
|
| 163 | - $array_hook = explode('#', $phook); |
|
| 164 | - if($ihooks === null || !array_key_exists($phook, $ihooks)){ |
|
| 165 | - $chook = new Hook($array_hook[1], $array_hook[2]); |
|
| 166 | - $chook->subscribe($array_hook[0]); |
|
| 167 | - $chook->setPriority($array_hook[0], $priority); |
|
| 168 | - } |
|
| 169 | - } |
|
| 170 | - } |
|
| 160 | + // Insert hooks not existing yet in the DB |
|
| 161 | + if($phooks !== null){ |
|
| 162 | + foreach($phooks as $phook => $priority){ |
|
| 163 | + $array_hook = explode('#', $phook); |
|
| 164 | + if($ihooks === null || !array_key_exists($phook, $ihooks)){ |
|
| 165 | + $chook = new Hook($array_hook[1], $array_hook[2]); |
|
| 166 | + $chook->subscribe($array_hook[0]); |
|
| 167 | + $chook->setPriority($array_hook[0], $priority); |
|
| 168 | + } |
|
| 169 | + } |
|
| 170 | + } |
|
| 171 | 171 | |
| 172 | - //Remove hooks not existing any more in the file system |
|
| 173 | - if($ihooks !== null){ |
|
| 174 | - foreach(array_keys($ihooks) as $ihook){ |
|
| 175 | - $array_hook = explode('#', $ihook); |
|
| 176 | - if($phooks === null || !array_key_exists($ihook, $phooks)){ |
|
| 177 | - $chook = new Hook($array_hook[1], $array_hook[2]); |
|
| 178 | - $chook->remove($array_hook[0]); |
|
| 179 | - } |
|
| 180 | - } |
|
| 181 | - } |
|
| 182 | - } |
|
| 172 | + //Remove hooks not existing any more in the file system |
|
| 173 | + if($ihooks !== null){ |
|
| 174 | + foreach(array_keys($ihooks) as $ihook){ |
|
| 175 | + $array_hook = explode('#', $ihook); |
|
| 176 | + if($phooks === null || !array_key_exists($ihook, $phooks)){ |
|
| 177 | + $chook = new Hook($array_hook[1], $array_hook[2]); |
|
| 178 | + $chook->remove($array_hook[0]); |
|
| 179 | + } |
|
| 180 | + } |
|
| 181 | + } |
|
| 182 | + } |
|
| 183 | 183 | } |
| 184 | 184 | |
| 185 | 185 | } |
| 186 | 186 | \ No newline at end of file |
@@ -71,7 +71,7 @@ discard block |
||
| 71 | 71 | * @see \MyArtJaub\Webtrees\Hook\HookProviderInterface::getPossibleHooks() |
| 72 | 72 | */ |
| 73 | 73 | public function getPossibleHooks() { |
| 74 | - static $hooks=null; |
|
| 74 | + static $hooks = null; |
|
| 75 | 75 | if ($hooks === null) { |
| 76 | 76 | $hooks = array(); |
| 77 | 77 | |
@@ -83,31 +83,31 @@ discard block |
||
| 83 | 83 | 'SELECT SQL_CACHE module_name FROM `##module`' |
| 84 | 84 | )->fetchOneColumn(); |
| 85 | 85 | |
| 86 | - foreach($module_names as $module_name) { |
|
| 86 | + foreach ($module_names as $module_name) { |
|
| 87 | 87 | $module = Module::getModuleByName($module_name); |
| 88 | 88 | |
| 89 | - if($module instanceof HookSubscriberInterface){ |
|
| 89 | + if ($module instanceof HookSubscriberInterface) { |
|
| 90 | 90 | $subscribedhooks = $module->getSubscribedHooks(); |
| 91 | - if(is_array($subscribedhooks)){ |
|
| 92 | - foreach($subscribedhooks as $key => $value){ |
|
| 93 | - if(is_int($key)) { |
|
| 91 | + if (is_array($subscribedhooks)) { |
|
| 92 | + foreach ($subscribedhooks as $key => $value) { |
|
| 93 | + if (is_int($key)) { |
|
| 94 | 94 | $hook_item = $value; |
| 95 | 95 | $priority = self::DEFAULT_PRIORITY; |
| 96 | 96 | } |
| 97 | - else{ |
|
| 97 | + else { |
|
| 98 | 98 | $hook_item = explode('#', $key, 2); |
| 99 | 99 | $priority = $value; |
| 100 | 100 | } |
| 101 | - if($hook_item && count($hook_item) == 2){ |
|
| 101 | + if ($hook_item && count($hook_item) == 2) { |
|
| 102 | 102 | $hook_func = $hook_item[0]; |
| 103 | 103 | $hook_cont = $hook_item[1]; |
| 104 | 104 | } |
| 105 | - else{ |
|
| 105 | + else { |
|
| 106 | 106 | $hook_func = $hook_item[0]; |
| 107 | 107 | $hook_cont = 'all'; |
| 108 | 108 | } |
| 109 | - if(method_exists($module, $hook_func)){ |
|
| 110 | - $hooks[$module->getName().'#'.$hook_func.'#'.$hook_cont]=$priority; |
|
| 109 | + if (method_exists($module, $hook_func)) { |
|
| 110 | + $hooks[$module->getName().'#'.$hook_func.'#'.$hook_cont] = $priority; |
|
| 111 | 111 | } |
| 112 | 112 | } |
| 113 | 113 | } |
@@ -121,8 +121,8 @@ discard block |
||
| 121 | 121 | * {@inheritDoc} |
| 122 | 122 | * @see \MyArtJaub\Webtrees\Hook\HookProviderInterface::getRawInstalledHooks() |
| 123 | 123 | */ |
| 124 | - public function getRawInstalledHooks(){ |
|
| 125 | - if(self::isModuleOperational()){ |
|
| 124 | + public function getRawInstalledHooks() { |
|
| 125 | + if (self::isModuleOperational()) { |
|
| 126 | 126 | return Database::prepare( |
| 127 | 127 | "SELECT majh_id AS id, majh_module_name AS module, majh_hook_function AS hook, majh_hook_context as context, majh_module_priority AS priority, majh_status AS status". |
| 128 | 128 | " FROM `##maj_hooks`". |
@@ -136,11 +136,11 @@ discard block |
||
| 136 | 136 | * {@inheritDoc} |
| 137 | 137 | * @see \MyArtJaub\Webtrees\Hook\HookProviderInterface::getInstalledHooks() |
| 138 | 138 | */ |
| 139 | - public function getInstalledHooks(){ |
|
| 140 | - static $installedhooks =null; |
|
| 141 | - if($installedhooks===null){ |
|
| 142 | - $dbhooks=self::getRawInstalledHooks(); |
|
| 143 | - foreach($dbhooks as $dbhook){ |
|
| 139 | + public function getInstalledHooks() { |
|
| 140 | + static $installedhooks = null; |
|
| 141 | + if ($installedhooks === null) { |
|
| 142 | + $dbhooks = self::getRawInstalledHooks(); |
|
| 143 | + foreach ($dbhooks as $dbhook) { |
|
| 144 | 144 | $installedhooks[($dbhook->module).'#'.($dbhook->hook).'#'.($dbhook->context)] = array('id' => $dbhook->id, 'status' => $dbhook->status, 'priority' => $dbhook->priority); |
| 145 | 145 | } |
| 146 | 146 | } |
@@ -153,15 +153,15 @@ discard block |
||
| 153 | 153 | */ |
| 154 | 154 | public function updateHooks() { |
| 155 | 155 | |
| 156 | - if(Auth::isAdmin()){ |
|
| 156 | + if (Auth::isAdmin()) { |
|
| 157 | 157 | $ihooks = self::getInstalledHooks(); |
| 158 | 158 | $phooks = self::getPossibleHooks(); |
| 159 | 159 | |
| 160 | 160 | // Insert hooks not existing yet in the DB |
| 161 | - if($phooks !== null){ |
|
| 162 | - foreach($phooks as $phook => $priority){ |
|
| 161 | + if ($phooks !== null) { |
|
| 162 | + foreach ($phooks as $phook => $priority) { |
|
| 163 | 163 | $array_hook = explode('#', $phook); |
| 164 | - if($ihooks === null || !array_key_exists($phook, $ihooks)){ |
|
| 164 | + if ($ihooks === null || !array_key_exists($phook, $ihooks)) { |
|
| 165 | 165 | $chook = new Hook($array_hook[1], $array_hook[2]); |
| 166 | 166 | $chook->subscribe($array_hook[0]); |
| 167 | 167 | $chook->setPriority($array_hook[0], $priority); |
@@ -170,10 +170,10 @@ discard block |
||
| 170 | 170 | } |
| 171 | 171 | |
| 172 | 172 | //Remove hooks not existing any more in the file system |
| 173 | - if($ihooks !== null){ |
|
| 174 | - foreach(array_keys($ihooks) as $ihook){ |
|
| 173 | + if ($ihooks !== null) { |
|
| 174 | + foreach (array_keys($ihooks) as $ihook) { |
|
| 175 | 175 | $array_hook = explode('#', $ihook); |
| 176 | - if($phooks === null || !array_key_exists($ihook, $phooks)){ |
|
| 176 | + if ($phooks === null || !array_key_exists($ihook, $phooks)) { |
|
| 177 | 177 | $chook = new Hook($array_hook[1], $array_hook[2]); |
| 178 | 178 | $chook->remove($array_hook[0]); |
| 179 | 179 | } |
@@ -93,16 +93,14 @@ |
||
| 93 | 93 | if(is_int($key)) { |
| 94 | 94 | $hook_item = $value; |
| 95 | 95 | $priority = self::DEFAULT_PRIORITY; |
| 96 | - } |
|
| 97 | - else{ |
|
| 96 | + } else{ |
|
| 98 | 97 | $hook_item = explode('#', $key, 2); |
| 99 | 98 | $priority = $value; |
| 100 | 99 | } |
| 101 | 100 | if($hook_item && count($hook_item) == 2){ |
| 102 | 101 | $hook_func = $hook_item[0]; |
| 103 | 102 | $hook_cont = $hook_item[1]; |
| 104 | - } |
|
| 105 | - else{ |
|
| 103 | + } else{ |
|
| 106 | 104 | $hook_func = $hook_item[0]; |
| 107 | 105 | $hook_cont = 'all'; |
| 108 | 106 | } |