Completed
Push — master ( f93e28...a26fec )
by Jonathan
07:20 queued 04:02
created
src/Webtrees/Module/Sosa/Model/SosaProvider.php 1 patch
Indentation   +561 added lines, -561 removed lines patch added patch discarded remove patch
@@ -22,390 +22,390 @@  discard block
 block discarded – undo
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
-     * @param int $ged_id ID of the gedcom file
262
-     * @return array Associative array of Sosa ancestors, with their generation, comma separated
263
-     */
264
-    public function getAllSosaWithGenerations(){
265
-        if(!$this->is_setup) return array();
266
-        return Database::prepare(
267
-            'SELECT majs_i_id AS indi,' .
268
-            ' GROUP_CONCAT(DISTINCT majs_gen ORDER BY majs_gen ASC SEPARATOR ",") AS generations' .
269
-            ' FROM `##maj_sosa`' .
270
-            ' WHERE majs_gedcom_id=:tree_id AND majs_user_id=:user_id' .
271
-            ' GROUP BY majs_i_id'
272
-        )->execute(array(
273
-            'tree_id' => $this->tree->getTreeId(),
274
-            'user_id' => $this->user->getUserId()
275
-        ))->fetchAssoc();
276
-    }
277
-    
278
-    /**
279
-     * Get an associative array of Sosa individuals in generation G. Keys are Sosa numbers, values individuals.
280
-     *
281
-     * @param number $gen Generation
282
-     * @return array Array of Sosa individuals
283
-     */
284
-    public function getSosaListAtGeneration($gen){
285
-        if(!$this->is_setup) return array();
286
-        if(!$this->sosa_list_by_gen)
287
-            $this->sosa_list_by_gen = array();
258
+	/**
259
+	 * Return the list of all sosas, with the generations it belongs to
260
+	 *
261
+	 * @param int $ged_id ID of the gedcom file
262
+	 * @return array Associative array of Sosa ancestors, with their generation, comma separated
263
+	 */
264
+	public function getAllSosaWithGenerations(){
265
+		if(!$this->is_setup) return array();
266
+		return Database::prepare(
267
+			'SELECT majs_i_id AS indi,' .
268
+			' GROUP_CONCAT(DISTINCT majs_gen ORDER BY majs_gen ASC SEPARATOR ",") AS generations' .
269
+			' FROM `##maj_sosa`' .
270
+			' WHERE majs_gedcom_id=:tree_id AND majs_user_id=:user_id' .
271
+			' GROUP BY majs_i_id'
272
+		)->execute(array(
273
+			'tree_id' => $this->tree->getTreeId(),
274
+			'user_id' => $this->user->getUserId()
275
+		))->fetchAssoc();
276
+	}
277
+    
278
+	/**
279
+	 * Get an associative array of Sosa individuals in generation G. Keys are Sosa numbers, values individuals.
280
+	 *
281
+	 * @param number $gen Generation
282
+	 * @return array Array of Sosa individuals
283
+	 */
284
+	public function getSosaListAtGeneration($gen){
285
+		if(!$this->is_setup) return array();
286
+		if(!$this->sosa_list_by_gen)
287
+			$this->sosa_list_by_gen = array();
288 288
         
289
-        if($gen){
290
-            if(!isset($this->sosa_list_by_gen[$gen])){
291
-                $this->sosa_list_by_gen[$gen] = Database::prepare(
292
-                    'SELECT majs_sosa AS sosa, majs_i_id AS indi'.
293
-                    ' FROM `##maj_sosa`'.
294
-                    ' WHERE majs_gedcom_id=:tree_id AND majs_user_id=:user_id'.
295
-                    ' AND majs_gen = :gen'.
296
-                    ' ORDER BY majs_sosa ASC')
297
-                ->execute(array(
298
-                    'tree_id' => $this->tree->getTreeId(),
299
-                    'user_id' => $this->user->getUserId(),
300
-                    'gen' => $gen
301
-                ))
302
-                ->fetchAssoc();
303
-            }
304
-            return $this->sosa_list_by_gen[$gen];
305
-        }
306
-        return array();
307
-    }
308
-    
309
-    /**
310
-     * Get an associative array of Sosa families in generation G. Keys are Sosa numbers for the husband, values families.
311
-     *
312
-     * @param number $gen Generation
313
-     * @return array Array of Sosa families
314
-     */
315
-    public function getFamilySosaListAtGeneration($gen){
316
-        if(!$this->is_setup) return array();
317
-        if(!$this->sosa_fam_list_by_gen)
318
-            $this->sosa_fam_list_by_gen = array();
289
+		if($gen){
290
+			if(!isset($this->sosa_list_by_gen[$gen])){
291
+				$this->sosa_list_by_gen[$gen] = Database::prepare(
292
+					'SELECT majs_sosa AS sosa, majs_i_id AS indi'.
293
+					' FROM `##maj_sosa`'.
294
+					' WHERE majs_gedcom_id=:tree_id AND majs_user_id=:user_id'.
295
+					' AND majs_gen = :gen'.
296
+					' ORDER BY majs_sosa ASC')
297
+				->execute(array(
298
+					'tree_id' => $this->tree->getTreeId(),
299
+					'user_id' => $this->user->getUserId(),
300
+					'gen' => $gen
301
+				))
302
+				->fetchAssoc();
303
+			}
304
+			return $this->sosa_list_by_gen[$gen];
305
+		}
306
+		return array();
307
+	}
308
+    
309
+	/**
310
+	 * Get an associative array of Sosa families in generation G. Keys are Sosa numbers for the husband, values families.
311
+	 *
312
+	 * @param number $gen Generation
313
+	 * @return array Array of Sosa families
314
+	 */
315
+	public function getFamilySosaListAtGeneration($gen){
316
+		if(!$this->is_setup) return array();
317
+		if(!$this->sosa_fam_list_by_gen)
318
+			$this->sosa_fam_list_by_gen = array();
319 319
         
320
-        if($gen){
321
-            if(!isset($this->sosa_fam_list_by_gen[$gen])){
322
-                $this->sosa_fam_list_by_gen[$gen] = Database::prepare(
323
-                    'SELECT s1.majs_sosa AS sosa, f_id AS fam'.
324
-                    ' FROM `##families`'.
325
-                    ' INNER JOIN `##maj_sosa` AS s1 ON (`##families`.f_husb = s1.majs_i_id AND `##families`.f_file = s1.majs_gedcom_id)'.
326
-                    ' INNER JOIN `##maj_sosa` AS s2 ON (`##families`.f_wife = s2.majs_i_id AND `##families`.f_file = s2.majs_gedcom_id)'.
327
-                    ' WHERE s1.majs_sosa + 1 = s2.majs_sosa'.
328
-                    ' AND s1.majs_gedcom_id= :tree_id AND s1.majs_user_id=:user_id'.
329
-                    ' AND s2.majs_gedcom_id= :tree_id AND s2.majs_user_id=:user_id'.
330
-                    ' AND s1.majs_gen = :gen'.
331
-                    ' ORDER BY s1.majs_sosa ASC'
332
-                    )
333
-                    ->execute(array(
334
-                        'tree_id' => $this->tree->getTreeId(),
335
-                        'user_id' => $this->user->getUserId(),
336
-                        'gen' => $gen
337
-                    ))
338
-                    ->fetchAssoc();
339
-            }
340
-            return $this->sosa_fam_list_by_gen[$gen];
341
-        }
342
-        return array();
343
-    }
344
-    
345
-    /**
346
-     * Get an associative array of Sosa individuals in generation G who are missing parents. Keys are Sosa numbers, values individuals.
347
-     *
348
-     * @param number $gen Generation
349
-     * @return array Array of Sosa individuals
350
-     */
351
-    public function getMissingSosaListAtGeneration($gen){
352
-        if(!$this->is_setup) return array();    
353
-        if($gen){
354
-            return $this->sosa_list_by_gen[$gen] = Database::prepare(
355
-                'SELECT schild.majs_sosa sosa, schild.majs_i_id indi, sfat.majs_sosa IS NOT NULL has_father, smot.majs_sosa IS NOT NULL has_mother'.
356
-                ' FROM `##maj_sosa` schild'.
357
-                ' 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)'.
358
-                ' 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)'.
359
-                ' WHERE schild.majs_gedcom_id = :tree_id AND schild.majs_user_id = :user_id'.
360
-                ' AND schild.majs_gen = :gen'.
361
-                ' AND (sfat.majs_sosa IS NULL OR smot.majs_sosa IS NULL)'.
362
-                ' ORDER BY schild.majs_sosa ASC')
363
-                ->execute(array(
364
-                    'tree_id' => $this->tree->getTreeId(),
365
-                    'user_id' => $this->user->getUserId(),
366
-                    'gen' => $gen - 1
367
-                ))->fetchAll(\PDO::FETCH_ASSOC);
368
-        }
369
-        return array();
370
-    }
371
-    
372
-    
373
-    
374
-    /*************
320
+		if($gen){
321
+			if(!isset($this->sosa_fam_list_by_gen[$gen])){
322
+				$this->sosa_fam_list_by_gen[$gen] = Database::prepare(
323
+					'SELECT s1.majs_sosa AS sosa, f_id AS fam'.
324
+					' FROM `##families`'.
325
+					' INNER JOIN `##maj_sosa` AS s1 ON (`##families`.f_husb = s1.majs_i_id AND `##families`.f_file = s1.majs_gedcom_id)'.
326
+					' INNER JOIN `##maj_sosa` AS s2 ON (`##families`.f_wife = s2.majs_i_id AND `##families`.f_file = s2.majs_gedcom_id)'.
327
+					' WHERE s1.majs_sosa + 1 = s2.majs_sosa'.
328
+					' AND s1.majs_gedcom_id= :tree_id AND s1.majs_user_id=:user_id'.
329
+					' AND s2.majs_gedcom_id= :tree_id AND s2.majs_user_id=:user_id'.
330
+					' AND s1.majs_gen = :gen'.
331
+					' ORDER BY s1.majs_sosa ASC'
332
+					)
333
+					->execute(array(
334
+						'tree_id' => $this->tree->getTreeId(),
335
+						'user_id' => $this->user->getUserId(),
336
+						'gen' => $gen
337
+					))
338
+					->fetchAssoc();
339
+			}
340
+			return $this->sosa_fam_list_by_gen[$gen];
341
+		}
342
+		return array();
343
+	}
344
+    
345
+	/**
346
+	 * Get an associative array of Sosa individuals in generation G who are missing parents. Keys are Sosa numbers, values individuals.
347
+	 *
348
+	 * @param number $gen Generation
349
+	 * @return array Array of Sosa individuals
350
+	 */
351
+	public function getMissingSosaListAtGeneration($gen){
352
+		if(!$this->is_setup) return array();    
353
+		if($gen){
354
+			return $this->sosa_list_by_gen[$gen] = Database::prepare(
355
+				'SELECT schild.majs_sosa sosa, schild.majs_i_id indi, sfat.majs_sosa IS NOT NULL has_father, smot.majs_sosa IS NOT NULL has_mother'.
356
+				' FROM `##maj_sosa` schild'.
357
+				' 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)'.
358
+				' 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)'.
359
+				' WHERE schild.majs_gedcom_id = :tree_id AND schild.majs_user_id = :user_id'.
360
+				' AND schild.majs_gen = :gen'.
361
+				' AND (sfat.majs_sosa IS NULL OR smot.majs_sosa IS NULL)'.
362
+				' ORDER BY schild.majs_sosa ASC')
363
+				->execute(array(
364
+					'tree_id' => $this->tree->getTreeId(),
365
+					'user_id' => $this->user->getUserId(),
366
+					'gen' => $gen - 1
367
+				))->fetchAll(\PDO::FETCH_ASSOC);
368
+		}
369
+		return array();
370
+	}
371
+    
372
+    
373
+    
374
+	/*************
375 375
      * STATISTICS
376 376
      *************/
377
-    /**
378
-     * Get the statistic array detailed by generation.
379
-     * Statistics for each generation are:
380
-     * 	- The number of Sosa in generation
381
-     * 	- The number of Sosa up to generation
382
-     *  - The number of distinct Sosa up to generation
383
-     *  - The year of the first birth in generation
384
-     *  - The year of the last birth in generation
385
-     *  - The average year of birth in generation
386
-     *
387
-     * @return array Statistics array
388
-     */
389
-    public function getStatisticsByGeneration() {
390
-        if(!$this->is_setup) return array();
391
-        if(!$this->statistics_tab) {
392
-            $this->statistics_tab = array();
393
-            if($maxGeneration = $this->getLastGeneration()) {
394
-                for ($gen = 1; $gen <= $maxGeneration; $gen++) {
395
-                    $birthStats = $this->getStatsBirthYearInGeneration($gen);
396
-                    $this->statistics_tab[$gen] = array(
397
-                        'sosaCount'				=>	$this->getSosaCountAtGeneration($gen),
398
-                        'sosaTotalCount'		=>	$this->getSosaCountUpToGeneration($gen),
399
-                        'diffSosaTotalCount'	=>	$this->getDifferentSosaCountUpToGeneration($gen),
400
-                        'firstBirth'			=>	$birthStats['first'],
401
-                        'lastBirth'				=>	$birthStats['last'],
402
-                        'avgBirth'				=>	$birthStats['avg']
403
-                    );
404
-                }
405
-            }
406
-        }
407
-        return $this->statistics_tab;        
408
-    }
377
+	/**
378
+	 * Get the statistic array detailed by generation.
379
+	 * Statistics for each generation are:
380
+	 * 	- The number of Sosa in generation
381
+	 * 	- The number of Sosa up to generation
382
+	 *  - The number of distinct Sosa up to generation
383
+	 *  - The year of the first birth in generation
384
+	 *  - The year of the last birth in generation
385
+	 *  - The average year of birth in generation
386
+	 *
387
+	 * @return array Statistics array
388
+	 */
389
+	public function getStatisticsByGeneration() {
390
+		if(!$this->is_setup) return array();
391
+		if(!$this->statistics_tab) {
392
+			$this->statistics_tab = array();
393
+			if($maxGeneration = $this->getLastGeneration()) {
394
+				for ($gen = 1; $gen <= $maxGeneration; $gen++) {
395
+					$birthStats = $this->getStatsBirthYearInGeneration($gen);
396
+					$this->statistics_tab[$gen] = array(
397
+						'sosaCount'				=>	$this->getSosaCountAtGeneration($gen),
398
+						'sosaTotalCount'		=>	$this->getSosaCountUpToGeneration($gen),
399
+						'diffSosaTotalCount'	=>	$this->getDifferentSosaCountUpToGeneration($gen),
400
+						'firstBirth'			=>	$birthStats['first'],
401
+						'lastBirth'				=>	$birthStats['last'],
402
+						'avgBirth'				=>	$birthStats['avg']
403
+					);
404
+				}
405
+			}
406
+		}
407
+		return $this->statistics_tab;        
408
+	}
409 409
     
410 410
 	/**
411 411
 	 * How many individuals exist in the tree.
@@ -413,205 +413,205 @@  discard block
 block discarded – undo
413 413
 	 * @return int
414 414
 	 */
415 415
 	public function getTotalIndividuals() {
416
-	    if(!$this->is_setup) return 0;
417
-	    return Database::prepare(
418
-	        'SELECT SQL_CACHE COUNT(*) FROM `##individuals`' .
419
-	        ' WHERE i_file = :tree_id')
420
-	        ->execute(array('tree_id' => $this->tree->getTreeId()))
421
-	        ->fetchOne() ?: 0;
416
+		if(!$this->is_setup) return 0;
417
+		return Database::prepare(
418
+			'SELECT SQL_CACHE COUNT(*) FROM `##individuals`' .
419
+			' WHERE i_file = :tree_id')
420
+			->execute(array('tree_id' => $this->tree->getTreeId()))
421
+			->fetchOne() ?: 0;
422 422
 	}
423 423
     
424
-    /**
425
-     * Get the total Sosa count for all generations
426
-     *
427
-     * @return number Number of Sosas
428
-     */
429
-    public function getSosaCount(){
430
-        if(!$this->is_setup) return 0;
431
-        return Database::prepare(
432
-            'SELECT SQL_CACHE COUNT(majs_sosa) FROM `##maj_sosa`' .
433
-            ' WHERE majs_gedcom_id=:tree_id AND majs_user_id=:user_id')
434
-            ->execute(array(
435
-                'tree_id' => $this->tree->getTreeId(), 
436
-                'user_id' => $this->user->getUserId() 
437
-            ))->fetchOne() ?: 0;
438
-    }
439
-    
440
-    /**
441
-     * Get the number of Sosa in a specific generation.
442
-     *
443
-     * @param number $gen Generation
444
-     * @return number Number of Sosas in generation
445
-     */
446
-    public function getSosaCountAtGeneration($gen){
447
-        if(!$this->is_setup) return 0;
448
-        return Database::prepare(
449
-            'SELECT SQL_CACHE COUNT(majs_sosa) FROM `##maj_sosa`' .
450
-            ' WHERE majs_gedcom_id=:tree_id AND majs_user_id=:user_id'.
451
-            ' AND majs_gen= :gen')
452
-        ->execute(array(
453
-                'tree_id' => $this->tree->getTreeId(), 
454
-                'user_id' => $this->user->getUserId(),
455
-                'gen' => $gen            
456
-        ))->fetchOne() ?: 0;
457
-    }
458
-    
459
-    /**
460
-     * Get the total number of Sosa up to a specific generation.
461
-     *
462
-     * @param number $gen Generation
463
-     * @return number Total number of Sosas up to generation
464
-     */
465
-    public function getSosaCountUpToGeneration($gen){
466
-        if(!$this->is_setup) return 0;
467
-        return Database::prepare(
468
-            'SELECT SQL_CACHE COUNT(majs_sosa) FROM `##maj_sosa`' .
469
-            ' WHERE majs_gedcom_id=:tree_id AND majs_user_id=:user_id'.
470
-            ' AND majs_gen <= :gen')
471
-        ->execute(array(
472
-                'tree_id' => $this->tree->getTreeId(), 
473
-                'user_id' => $this->user->getUserId(),
474
-                'gen' => $gen 
475
-        ))->fetchOne() ?: 0;
476
-    }
477
-    
478
-    /**
479
-     * Get the total number of distinct Sosa individual for all generations.
480
-     *
481
-     * @return number Total number of distinct individual
482
-     */
483
-    public function getDifferentSosaCount(){
484
-        if(!$this->is_setup) return 0;
485
-        return Database::prepare(
486
-            'SELECT SQL_CACHE COUNT(DISTINCT majs_i_id) FROM `##maj_sosa`' .
487
-            ' WHERE majs_gedcom_id=:tree_id AND majs_user_id=:user_id')
488
-        ->execute(array(
489
-                'tree_id' => $this->tree->getTreeId(), 
490
-                'user_id' => $this->user->getUserId()
491
-        ))->fetchOne() ?: 0;
492
-    }
493
-    
494
-    /**
495
-     * Get the number of distinct Sosa individual up to a specific generation.
496
-     *
497
-     * @param number $gen Generation
498
-     * @return number Number of distinct Sosa individuals up to generation
499
-     */
500
-    public function getDifferentSosaCountUpToGeneration($gen){
501
-        if(!$this->is_setup) return 0;
502
-        return Database::prepare(
503
-            'SELECT SQL_CACHE COUNT(DISTINCT majs_i_id) FROM `##maj_sosa`' .
504
-            ' WHERE majs_gedcom_id=:tree_id AND majs_user_id=:user_id'.
505
-            ' AND majs_gen <= :gen')
506
-        ->execute(array(
507
-                'tree_id' => $this->tree->getTreeId(), 
508
-                'user_id' => $this->user->getUserId(),
509
-                'gen' => $gen 
510
-        ))->fetchOne() ?: 0;
511
-    }
512
-    
513
-    /**
514
-     * Get an array of birth statistics for a specific generation
515
-     * Statistics are :
516
-     * 	- first : First birth year in generation
517
-     *  - last : Last birth year in generation
518
-     *  - avg : Average birth year
519
-     *
520
-     * @param number $gen Generation
521
-     * @return array Birth statistics array
522
-     */
523
-    public function getStatsBirthYearInGeneration($gen){
524
-        if(!$this->is_setup) return array('first' => 0, 'avg' => 0, 'last' => 0);
525
-        return Database::prepare(
526
-            'SELECT MIN(majs_birth_year) AS first, AVG(majs_birth_year) AS avg, MAX(majs_birth_year) AS last'.
527
-            ' FROM `##maj_sosa`' .
528
-            ' WHERE majs_gedcom_id=:tree_id AND majs_user_id=:user_id'.
529
-            ' AND majs_gen=:gen AND NOT majs_birth_year = :birth_year')
530
-            ->execute(array(
531
-                'tree_id' => $this->tree->getTreeId(), 
532
-                'user_id' => $this->user->getUserId(),
533
-                'gen' => $gen,
534
-                'birth_year' => 0))
535
-            ->fetchOneRow(\PDO::FETCH_ASSOC) ?: array('first' => 0, 'avg' => 0, 'last' => 0);
536
-    }
537
-    
538
-    /**
539
-     * Get the mean generation time, based on a linear regression of birth years and generations
540
-     *
541
-     * @return number|NULL Mean generation time
542
-     */
543
-    public function getMeanGenerationTime(){
544
-        if(!$this->is_setup) return;
545
-        if(!$this->statistics_tab){
546
-            $this->getStatisticsByGeneration();
547
-        }
548
-        //Linear regression on x=generation and y=birthdate
549
-        $sum_xy = 0;
550
-        $sum_x=0;
551
-        $sum_y=0;
552
-        $sum_x2=0;
553
-        $n=count($this->statistics_tab);
554
-        foreach($this->statistics_tab as $gen=>$stats){
555
-            $sum_xy+=$gen*$stats['avgBirth'];
556
-            $sum_x+=$gen;
557
-            $sum_y+=$stats['avgBirth'];
558
-            $sum_x2+=$gen*$gen;
559
-        }
560
-        $denom=($n*$sum_x2)-($sum_x*$sum_x);
561
-        if($denom!=0){
562
-            return -(($n*$sum_xy)-($sum_x*$sum_y))/($denom);
563
-        }
564
-        return null;
565
-    }
566
-    
567
-    /**
568
-     * Return a computed array of statistics about the dispersion of ancestors across the ancestors
569
-     * at a specified generation.
570
-     * This statistics cannot be used for generations above 11, as it would cause a out of range in MySQL
571
-     * 
572
-     * Format: 
573
-     *  - key : a base-2 representation of the ancestor at generation G for which exclusive ancestors have been found,
574
-     *          -1 is used for shared ancestors
575
-     *          For instance base2(0100) = base10(4) represent the maternal grand father
576
-     *  - values: number of ancestors exclusively in the ancestors of the ancestor in key
577
-     *  
578
-     *  For instance a result at generation 3 could be :
579
-     *      array (   -1        =>  12      -> 12 ancestors are shared by the grand-parents
580
-     *                base10(1) =>  32      -> 32 ancestors are exclusive to the paternal grand-father
581
-     *                base10(2) =>  25      -> 25 ancestors are exclusive to the paternal grand-mother
582
-     *                base10(4) =>  12      -> 12 ancestors are exclusive to the maternal grand-father
583
-     *                base10(8) =>  30      -> 30 ancestors are exclusive to the maternal grand-mother
584
-     *            )
585
-     *  
586
-     * @param int $gen Reference generation
587
-     * @return array
588
-     */
589
-    public function getAncestorDispersionForGen($gen) {
590
-        if(!$this->is_setup || $gen > 11) return array();  // Going further than 11 gen will be out of range in the query
591
-        return Database::prepare(
592
-            'SELECT branches, count(i_id)'.
593
-            ' FROM ('.
594
-            '   SELECT i_id,'.
595
-            '       CASE'.
596
-            '           WHEN CEIL(LOG2(SUM(branch))) = LOG2(SUM(branch)) THEN SUM(branch)'.
597
-            '           ELSE -1'.   // We put all ancestors shared between some branches in the same bucket
598
-            '       END branches'.
599
-            '   FROM ('.
600
-            '       SELECT DISTINCT majs_i_id i_id,'.
601
-            '           POW(2, FLOOR(majs_sosa / POW(2, (majs_gen - :gen))) - POW(2, :gen -1)) branch'.
602
-            '       FROM `##maj_sosa`'.
603
-            '       WHERE majs_gedcom_id = :tree_id AND majs_user_id = :user_id'.
604
-            '           AND majs_gen >= :gen'.
605
-            '   ) indistat'.
606
-            '   GROUP BY i_id'.
607
-            ') grouped'.
608
-            ' GROUP BY branches')
609
-            ->execute(array(
610
-                'tree_id' => $this->tree->getTreeId(), 
611
-                'user_id' => $this->user->getUserId(),
612
-                'gen' => $gen
613
-            ))->fetchAssoc() ?: array();
614
-    }
424
+	/**
425
+	 * Get the total Sosa count for all generations
426
+	 *
427
+	 * @return number Number of Sosas
428
+	 */
429
+	public function getSosaCount(){
430
+		if(!$this->is_setup) return 0;
431
+		return Database::prepare(
432
+			'SELECT SQL_CACHE COUNT(majs_sosa) FROM `##maj_sosa`' .
433
+			' WHERE majs_gedcom_id=:tree_id AND majs_user_id=:user_id')
434
+			->execute(array(
435
+				'tree_id' => $this->tree->getTreeId(), 
436
+				'user_id' => $this->user->getUserId() 
437
+			))->fetchOne() ?: 0;
438
+	}
439
+    
440
+	/**
441
+	 * Get the number of Sosa in a specific generation.
442
+	 *
443
+	 * @param number $gen Generation
444
+	 * @return number Number of Sosas in generation
445
+	 */
446
+	public function getSosaCountAtGeneration($gen){
447
+		if(!$this->is_setup) return 0;
448
+		return Database::prepare(
449
+			'SELECT SQL_CACHE COUNT(majs_sosa) FROM `##maj_sosa`' .
450
+			' WHERE majs_gedcom_id=:tree_id AND majs_user_id=:user_id'.
451
+			' AND majs_gen= :gen')
452
+		->execute(array(
453
+				'tree_id' => $this->tree->getTreeId(), 
454
+				'user_id' => $this->user->getUserId(),
455
+				'gen' => $gen            
456
+		))->fetchOne() ?: 0;
457
+	}
458
+    
459
+	/**
460
+	 * Get the total number of Sosa up to a specific generation.
461
+	 *
462
+	 * @param number $gen Generation
463
+	 * @return number Total number of Sosas up to generation
464
+	 */
465
+	public function getSosaCountUpToGeneration($gen){
466
+		if(!$this->is_setup) return 0;
467
+		return Database::prepare(
468
+			'SELECT SQL_CACHE COUNT(majs_sosa) FROM `##maj_sosa`' .
469
+			' WHERE majs_gedcom_id=:tree_id AND majs_user_id=:user_id'.
470
+			' AND majs_gen <= :gen')
471
+		->execute(array(
472
+				'tree_id' => $this->tree->getTreeId(), 
473
+				'user_id' => $this->user->getUserId(),
474
+				'gen' => $gen 
475
+		))->fetchOne() ?: 0;
476
+	}
477
+    
478
+	/**
479
+	 * Get the total number of distinct Sosa individual for all generations.
480
+	 *
481
+	 * @return number Total number of distinct individual
482
+	 */
483
+	public function getDifferentSosaCount(){
484
+		if(!$this->is_setup) return 0;
485
+		return Database::prepare(
486
+			'SELECT SQL_CACHE COUNT(DISTINCT majs_i_id) FROM `##maj_sosa`' .
487
+			' WHERE majs_gedcom_id=:tree_id AND majs_user_id=:user_id')
488
+		->execute(array(
489
+				'tree_id' => $this->tree->getTreeId(), 
490
+				'user_id' => $this->user->getUserId()
491
+		))->fetchOne() ?: 0;
492
+	}
493
+    
494
+	/**
495
+	 * Get the number of distinct Sosa individual up to a specific generation.
496
+	 *
497
+	 * @param number $gen Generation
498
+	 * @return number Number of distinct Sosa individuals up to generation
499
+	 */
500
+	public function getDifferentSosaCountUpToGeneration($gen){
501
+		if(!$this->is_setup) return 0;
502
+		return Database::prepare(
503
+			'SELECT SQL_CACHE COUNT(DISTINCT majs_i_id) FROM `##maj_sosa`' .
504
+			' WHERE majs_gedcom_id=:tree_id AND majs_user_id=:user_id'.
505
+			' AND majs_gen <= :gen')
506
+		->execute(array(
507
+				'tree_id' => $this->tree->getTreeId(), 
508
+				'user_id' => $this->user->getUserId(),
509
+				'gen' => $gen 
510
+		))->fetchOne() ?: 0;
511
+	}
512
+    
513
+	/**
514
+	 * Get an array of birth statistics for a specific generation
515
+	 * Statistics are :
516
+	 * 	- first : First birth year in generation
517
+	 *  - last : Last birth year in generation
518
+	 *  - avg : Average birth year
519
+	 *
520
+	 * @param number $gen Generation
521
+	 * @return array Birth statistics array
522
+	 */
523
+	public function getStatsBirthYearInGeneration($gen){
524
+		if(!$this->is_setup) return array('first' => 0, 'avg' => 0, 'last' => 0);
525
+		return Database::prepare(
526
+			'SELECT MIN(majs_birth_year) AS first, AVG(majs_birth_year) AS avg, MAX(majs_birth_year) AS last'.
527
+			' FROM `##maj_sosa`' .
528
+			' WHERE majs_gedcom_id=:tree_id AND majs_user_id=:user_id'.
529
+			' AND majs_gen=:gen AND NOT majs_birth_year = :birth_year')
530
+			->execute(array(
531
+				'tree_id' => $this->tree->getTreeId(), 
532
+				'user_id' => $this->user->getUserId(),
533
+				'gen' => $gen,
534
+				'birth_year' => 0))
535
+			->fetchOneRow(\PDO::FETCH_ASSOC) ?: array('first' => 0, 'avg' => 0, 'last' => 0);
536
+	}
537
+    
538
+	/**
539
+	 * Get the mean generation time, based on a linear regression of birth years and generations
540
+	 *
541
+	 * @return number|NULL Mean generation time
542
+	 */
543
+	public function getMeanGenerationTime(){
544
+		if(!$this->is_setup) return;
545
+		if(!$this->statistics_tab){
546
+			$this->getStatisticsByGeneration();
547
+		}
548
+		//Linear regression on x=generation and y=birthdate
549
+		$sum_xy = 0;
550
+		$sum_x=0;
551
+		$sum_y=0;
552
+		$sum_x2=0;
553
+		$n=count($this->statistics_tab);
554
+		foreach($this->statistics_tab as $gen=>$stats){
555
+			$sum_xy+=$gen*$stats['avgBirth'];
556
+			$sum_x+=$gen;
557
+			$sum_y+=$stats['avgBirth'];
558
+			$sum_x2+=$gen*$gen;
559
+		}
560
+		$denom=($n*$sum_x2)-($sum_x*$sum_x);
561
+		if($denom!=0){
562
+			return -(($n*$sum_xy)-($sum_x*$sum_y))/($denom);
563
+		}
564
+		return null;
565
+	}
566
+    
567
+	/**
568
+	 * Return a computed array of statistics about the dispersion of ancestors across the ancestors
569
+	 * at a specified generation.
570
+	 * This statistics cannot be used for generations above 11, as it would cause a out of range in MySQL
571
+	 * 
572
+	 * Format: 
573
+	 *  - key : a base-2 representation of the ancestor at generation G for which exclusive ancestors have been found,
574
+	 *          -1 is used for shared ancestors
575
+	 *          For instance base2(0100) = base10(4) represent the maternal grand father
576
+	 *  - values: number of ancestors exclusively in the ancestors of the ancestor in key
577
+	 *  
578
+	 *  For instance a result at generation 3 could be :
579
+	 *      array (   -1        =>  12      -> 12 ancestors are shared by the grand-parents
580
+	 *                base10(1) =>  32      -> 32 ancestors are exclusive to the paternal grand-father
581
+	 *                base10(2) =>  25      -> 25 ancestors are exclusive to the paternal grand-mother
582
+	 *                base10(4) =>  12      -> 12 ancestors are exclusive to the maternal grand-father
583
+	 *                base10(8) =>  30      -> 30 ancestors are exclusive to the maternal grand-mother
584
+	 *            )
585
+	 *  
586
+	 * @param int $gen Reference generation
587
+	 * @return array
588
+	 */
589
+	public function getAncestorDispersionForGen($gen) {
590
+		if(!$this->is_setup || $gen > 11) return array();  // Going further than 11 gen will be out of range in the query
591
+		return Database::prepare(
592
+			'SELECT branches, count(i_id)'.
593
+			' FROM ('.
594
+			'   SELECT i_id,'.
595
+			'       CASE'.
596
+			'           WHEN CEIL(LOG2(SUM(branch))) = LOG2(SUM(branch)) THEN SUM(branch)'.
597
+			'           ELSE -1'.   // We put all ancestors shared between some branches in the same bucket
598
+			'       END branches'.
599
+			'   FROM ('.
600
+			'       SELECT DISTINCT majs_i_id i_id,'.
601
+			'           POW(2, FLOOR(majs_sosa / POW(2, (majs_gen - :gen))) - POW(2, :gen -1)) branch'.
602
+			'       FROM `##maj_sosa`'.
603
+			'       WHERE majs_gedcom_id = :tree_id AND majs_user_id = :user_id'.
604
+			'           AND majs_gen >= :gen'.
605
+			'   ) indistat'.
606
+			'   GROUP BY i_id'.
607
+			') grouped'.
608
+			' GROUP BY branches')
609
+			->execute(array(
610
+				'tree_id' => $this->tree->getTreeId(), 
611
+				'user_id' => $this->user->getUserId(),
612
+				'gen' => $gen
613
+			))->fetchAssoc() ?: array();
614
+	}
615 615
     
616 616
                
617 617
 }
Please login to merge, or discard this patch.
src/Webtrees/Mvc/Dispatcher.php 1 patch
Indentation   +53 added lines, -53 removed lines patch added patch discarded remove patch
@@ -18,35 +18,35 @@  discard block
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 
Please login to merge, or discard this patch.
src/Webtrees/Mvc/MvcException.php 1 patch
Indentation   +41 added lines, -41 removed lines patch added patch discarded remove patch
@@ -16,52 +16,52 @@
 block discarded – undo
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
 
Please login to merge, or discard this patch.
src/Webtrees/Module/HooksModule.php 1 patch
Indentation   +45 added lines, -45 removed lines patch added patch discarded remove patch
@@ -19,59 +19,59 @@
 block discarded – undo
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() . '&amp;mod_action=AdminConfig';
61
-    }
60
+		return 'module.php?mod=' . $this->getName() . '&amp;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
 }
Please login to merge, or discard this patch.
src/Webtrees/Module/WelcomeBlock/WelcomeBlockController.php 1 patch
Indentation   +65 added lines, -65 removed lines patch added patch discarded remove patch
@@ -28,30 +28,30 @@  discard block
 block discarded – undo
28 28
 class WelcomeBlockController extends MvcController
29 29
 {   
30 30
     
31
-    /**
32
-     * Pages
33
-     */
31
+	/**
32
+	 * Pages
33
+	 */
34 34
         
35
-    /**
36
-     * WelcomeBlock@index
37
-     * 
38
-     * @param PageController $parent_controller
39
-     * @param Tree $tree
40
-     * @param string $block_id
41
-     * @param string $template
42
-     * @return $string
43
-     */
44
-    public function index(PageController $parent_controller, Tree $tree, $block_id, $template) {        
45
-        $view_bag = new ViewBag();
35
+	/**
36
+	 * WelcomeBlock@index
37
+	 * 
38
+	 * @param PageController $parent_controller
39
+	 * @param Tree $tree
40
+	 * @param string $block_id
41
+	 * @param string $template
42
+	 * @return $string
43
+	 */
44
+	public function index(PageController $parent_controller, Tree $tree, $block_id, $template) {        
45
+		$view_bag = new ViewBag();
46 46
         
47
-        if($parent_controller && $tree) {
47
+		if($parent_controller && $tree) {
48 48
         
49
-            $view_bag->set('tree', $tree);
50
-            $view_bag->set('indi', $parent_controller->getSignificantIndividual());
49
+			$view_bag->set('tree', $tree);
50
+			$view_bag->set('indi', $parent_controller->getSignificantIndividual());
51 51
         
52
-            $id = $this->module->getName().$block_id;
53
-            $class = $this->module->getName().'_block';
54
-            $parent_controller->addInlineJavascript('
52
+			$id = $this->module->getName().$block_id;
53
+			$class = $this->module->getName().'_block';
54
+			$parent_controller->addInlineJavascript('
55 55
                 jQuery("#maj-new_passwd").hide();
56 56
                 jQuery("#maj-passwd_click").click(function()
57 57
                 {
@@ -62,62 +62,62 @@  discard block
 block discarded – undo
62 62
     				  });
63 63
     			');
64 64
     
65
-            if (Auth::isAdmin()) {
66
-                $title='<a class="icon-admin" title="'.I18N::translate('Configure').'" href="block_edit.php?block_id='.$block_id.'&amp;ged=' . $tree->getNameHtml() . '&amp;ctype=gedcom"></a>';
67
-            } else {
68
-                $title='';
69
-            }
70
-            $title .='<span dir="auto">'.$tree->getTitleHtml().'</span>';
65
+			if (Auth::isAdmin()) {
66
+				$title='<a class="icon-admin" title="'.I18N::translate('Configure').'" href="block_edit.php?block_id='.$block_id.'&amp;ged=' . $tree->getNameHtml() . '&amp;ctype=gedcom"></a>';
67
+			} else {
68
+				$title='';
69
+			}
70
+			$title .='<span dir="auto">'.$tree->getTitleHtml().'</span>';
71 71
     
72
-            $piwik_enabled = $this->module->getBlockSetting($block_id, 'piwik_enabled', false);
73
-            $view_bag->set('piwik_enabled', $piwik_enabled);
74
-            if($piwik_enabled) {
75
-                $parent_controller->addInlineJavascript(
76
-                    '$("#piwik_stats")
72
+			$piwik_enabled = $this->module->getBlockSetting($block_id, 'piwik_enabled', false);
73
+			$view_bag->set('piwik_enabled', $piwik_enabled);
74
+			if($piwik_enabled) {
75
+				$parent_controller->addInlineJavascript(
76
+					'$("#piwik_stats")
77 77
                         .load("module.php?mod='.$this->module->getName().'&mod_action=Piwik&block_id='.$block_id.'");'
78
-                );
79
-            }
78
+				);
79
+			}
80 80
     
81
-            $content = ViewFactory::make('WelcomeBlock', $this,  new BaseController(), $view_bag)->getHtmlPartial();   
81
+			$content = ViewFactory::make('WelcomeBlock', $this,  new BaseController(), $view_bag)->getHtmlPartial();   
82 82
             
83
-            if ($template) {
84
-                return Theme::theme()->formatBlock($id, $title, $class, $content);
85
-            } else {
86
-                return $content;
87
-            }
88
-        }
89
-    }
83
+			if ($template) {
84
+				return Theme::theme()->formatBlock($id, $title, $class, $content);
85
+			} else {
86
+				return $content;
87
+			}
88
+		}
89
+	}
90 90
     
91 91
     
92 92
     
93
-    /**
94
-     * WelcomeBlock@config
95
-     * 
96
-     * @param string $block_id
97
-     */
98
-    public function config($block_id) {
93
+	/**
94
+	 * WelcomeBlock@config
95
+	 * 
96
+	 * @param string $block_id
97
+	 */
98
+	public function config($block_id) {
99 99
 
100
-        if (Filter::postBool('save') && Filter::checkCsrf()) {
101
-            $this->module->setBlockSetting($block_id, 'piwik_enabled', Filter::postBool('piwik_enabled'));
102
-            $this->module->setBlockSetting($block_id, 'piwik_url', trim(Filter::postUrl('piwik_url')));
103
-            $this->module->setBlockSetting($block_id, 'piwik_siteid', trim(Filter::post('piwik_siteid')));
104
-            $this->module->setBlockSetting($block_id, 'piwik_token', trim(Filter::post('piwik_token')));            
105
-            throw new MvcException(200); // Use this instead of exit
106
-        }
100
+		if (Filter::postBool('save') && Filter::checkCsrf()) {
101
+			$this->module->setBlockSetting($block_id, 'piwik_enabled', Filter::postBool('piwik_enabled'));
102
+			$this->module->setBlockSetting($block_id, 'piwik_url', trim(Filter::postUrl('piwik_url')));
103
+			$this->module->setBlockSetting($block_id, 'piwik_siteid', trim(Filter::post('piwik_siteid')));
104
+			$this->module->setBlockSetting($block_id, 'piwik_token', trim(Filter::post('piwik_token')));            
105
+			throw new MvcException(200); // Use this instead of exit
106
+		}
107 107
         
108
-        $view_bag = new ViewBag();
108
+		$view_bag = new ViewBag();
109 109
         
110
-        // Is Piwik Statistic Enabled ?
111
-        $view_bag->set('piwik_enabled', $this->module->getBlockSetting($block_id, 'piwik_enabled', '0'));
112
-        //Piwik Root Url
113
-        $view_bag->set('piwik_url', $this->module->getBlockSetting($block_id, 'piwik_url', ''));
114
-        // Piwik token
115
-        $view_bag->set('piwik_token', $this->module->getBlockSetting($block_id, 'piwik_token', ''));
116
-        // Piwik side id
117
-        $view_bag->set('piwik_siteid', $this->module->getBlockSetting($block_id, 'piwik_siteid', ''));
110
+		// Is Piwik Statistic Enabled ?
111
+		$view_bag->set('piwik_enabled', $this->module->getBlockSetting($block_id, 'piwik_enabled', '0'));
112
+		//Piwik Root Url
113
+		$view_bag->set('piwik_url', $this->module->getBlockSetting($block_id, 'piwik_url', ''));
114
+		// Piwik token
115
+		$view_bag->set('piwik_token', $this->module->getBlockSetting($block_id, 'piwik_token', ''));
116
+		// Piwik side id
117
+		$view_bag->set('piwik_siteid', $this->module->getBlockSetting($block_id, 'piwik_siteid', ''));
118 118
         
119
-        ViewFactory::make('WelcomeBlockConfig', $this, new BaseController(), $view_bag)->renderPartial();
120
-    }
119
+		ViewFactory::make('WelcomeBlockConfig', $this, new BaseController(), $view_bag)->renderPartial();
120
+	}
121 121
     
122 122
     
123 123
     
Please login to merge, or discard this patch.
src/Webtrees/Module/GeoDispersionModule.php 1 patch
Indentation   +59 added lines, -59 removed lines patch added patch discarded remove patch
@@ -24,88 +24,88 @@
 block discarded – undo
24 24
 class GeoDispersionModule extends AbstractModule implements ModuleConfigInterface, DependentInterface {
25 25
     
26 26
 	// How to update the database schema for this module
27
-    const SCHEMA_TARGET_VERSION   = 1;
28
-    const SCHEMA_SETTING_NAME     = 'MAJ_GEODISP_SCHEMA_VERSION';
29
-    const SCHEMA_MIGRATION_PREFIX = '\MyArtJaub\Webtrees\Module\GeoDispersion\Schema';
27
+	const SCHEMA_TARGET_VERSION   = 1;
28
+	const SCHEMA_SETTING_NAME     = 'MAJ_GEODISP_SCHEMA_VERSION';
29
+	const SCHEMA_MIGRATION_PREFIX = '\MyArtJaub\Webtrees\Module\GeoDispersion\Schema';
30 30
     
31
-    /** @var string For custom modules - link for support, upgrades, etc. */
32
-    const CUSTOM_WEBSITE = 'https://github.com/jon48/webtrees-lib';
31
+	/** @var string For custom modules - link for support, upgrades, etc. */
32
+	const CUSTOM_WEBSITE = 'https://github.com/jon48/webtrees-lib';
33 33
         
34
-    /**
35
-     * GeoDispersion analysis provider
36
-     * @var \MyArtJaub\Webtrees\Module\GeoDispersion\Model\GeoAnalysisProvider $provider
37
-     */
38
-    protected $provider;
34
+	/**
35
+	 * GeoDispersion analysis provider
36
+	 * @var \MyArtJaub\Webtrees\Module\GeoDispersion\Model\GeoAnalysisProvider $provider
37
+	 */
38
+	protected $provider;
39 39
     
40
-    /**
41
-     * {@inhericDoc}
42
-     */
43
-    public function getTitle() {
44
-        return /* I18N: Name of the “Hooks” module */ I18N::translate('Geographical Dispersion');
45
-    }
40
+	/**
41
+	 * {@inhericDoc}
42
+	 */
43
+	public function getTitle() {
44
+		return /* I18N: Name of the “Hooks” module */ I18N::translate('Geographical Dispersion');
45
+	}
46 46
     
47
-    /**
48
-     * {@inhericDoc}
49
-     */
50
-    public function getDescription() {
51
-        return /* I18N: Description of the “Hooks” module */ I18N::translate('Display the geographical dispersion of the root person’s Sosa ancestors.');
52
-    }
47
+	/**
48
+	 * {@inhericDoc}
49
+	 */
50
+	public function getDescription() {
51
+		return /* I18N: Description of the “Hooks” module */ I18N::translate('Display the geographical dispersion of the root person’s Sosa ancestors.');
52
+	}
53 53
     
54
-    /**
55
-     * {@inhericDoc}
56
-     */
57
-    public function modAction($mod_action) {
58
-        Database::updateSchema(self::SCHEMA_MIGRATION_PREFIX, self::SCHEMA_SETTING_NAME, self::SCHEMA_TARGET_VERSION);
54
+	/**
55
+	 * {@inhericDoc}
56
+	 */
57
+	public function modAction($mod_action) {
58
+		Database::updateSchema(self::SCHEMA_MIGRATION_PREFIX, self::SCHEMA_SETTING_NAME, self::SCHEMA_TARGET_VERSION);
59 59
         
60
-        \MyArtJaub\Webtrees\Mvc\Dispatcher::getInstance()->handle($this, $mod_action);
61
-    }
60
+		\MyArtJaub\Webtrees\Mvc\Dispatcher::getInstance()->handle($this, $mod_action);
61
+	}
62 62
     
63
-    /**
64
-     * {@inhericDoc}
65
-     * @see \Fisharebest\Webtrees\Module\ModuleConfigInterface::getConfigLink()
66
-     */
67
-    public function getConfigLink() {
68
-        Database::updateSchema(self::SCHEMA_MIGRATION_PREFIX, self::SCHEMA_SETTING_NAME, self::SCHEMA_TARGET_VERSION);
63
+	/**
64
+	 * {@inhericDoc}
65
+	 * @see \Fisharebest\Webtrees\Module\ModuleConfigInterface::getConfigLink()
66
+	 */
67
+	public function getConfigLink() {
68
+		Database::updateSchema(self::SCHEMA_MIGRATION_PREFIX, self::SCHEMA_SETTING_NAME, self::SCHEMA_TARGET_VERSION);
69 69
         
70
-        return 'module.php?mod=' . $this->getName() . '&amp;mod_action=AdminConfig';
71
-    }
70
+		return 'module.php?mod=' . $this->getName() . '&amp;mod_action=AdminConfig';
71
+	}
72 72
     
73
-    /**
74
-     * {@inhericDoc}
75
-     * @see \MyArtJaub\Webtrees\Module\DependentInterface::validatePrerequisites()
76
-     */
77
-    public function validatePrerequisites() {
78
-        try {
79
-            Database::updateSchema(self::SCHEMA_MIGRATION_PREFIX, self::SCHEMA_SETTING_NAME, self::SCHEMA_TARGET_VERSION);
73
+	/**
74
+	 * {@inhericDoc}
75
+	 * @see \MyArtJaub\Webtrees\Module\DependentInterface::validatePrerequisites()
76
+	 */
77
+	public function validatePrerequisites() {
78
+		try {
79
+			Database::updateSchema(self::SCHEMA_MIGRATION_PREFIX, self::SCHEMA_SETTING_NAME, self::SCHEMA_TARGET_VERSION);
80 80
             
81
-            return !is_null(Module::getModuleByName(Constants::MODULE_MAJ_SOSA_NAME));
82
-        }
83
-        catch (\Exception $ex) {  }
84
-        return false;
85
-    }
81
+			return !is_null(Module::getModuleByName(Constants::MODULE_MAJ_SOSA_NAME));
82
+		}
83
+		catch (\Exception $ex) {  }
84
+		return false;
85
+	}
86 86
     
87 87
 	/**
88 88
 	 * Get the GeoAnalysis Provider (initialise it if not done yet).
89 89
 	 *
90 90
 	 * @return \MyArtJaub\Webtrees\Module\GeoDispersion\Model\GeoAnalysisProvider
91 91
 	 */
92
-    public function getProvider() {
93
-        global $WT_TREE;
92
+	public function getProvider() {
93
+		global $WT_TREE;
94 94
         
95
-        if(!$this->provider) {
96
-            $this->provider = new GeoAnalysisProvider($WT_TREE);
97
-        }
98
-        return $this->provider;
99
-    }
95
+		if(!$this->provider) {
96
+			$this->provider = new GeoAnalysisProvider($WT_TREE);
97
+		}
98
+		return $this->provider;
99
+	}
100 100
 	
101 101
 	/**
102 102
 	 * Set the GeoAnalysis Provider.
103 103
 	 *
104 104
 	 * @return \MyArtJaub\Webtrees\Module\GeoDispersion\Model\GeoAnalysisProvider
105 105
 	 */
106
-    public function setProvider(GeoAnalysisProvider $provider) {
107
-        $this->provider = $provider;
108
-    }
106
+	public function setProvider(GeoAnalysisProvider $provider) {
107
+		$this->provider = $provider;
108
+	}
109 109
     
110 110
 
111 111
 }
Please login to merge, or discard this patch.
src/Webtrees/Module/Sosa/SosaStatsController.php 1 patch
Indentation   +180 added lines, -180 removed lines patch added patch discarded remove patch
@@ -25,218 +25,218 @@
 block discarded – undo
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&amp;chd=e:{$chd}&amp;chs={$size}&amp;chco={$father['color']},{$shared['color']},{$mother['color']}&amp;chf=bg,s,ffffff00&amp;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&amp;chd=e:{$chd}&amp;chs={$size}&amp;chco={$father['color']},{$shared['color']},{$mother['color']}&amp;chf=bg,s,ffffff00&amp;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&amp;chd=e:{$chd}&amp;chs={$size}&amp;chco={$color_fatfat},{$color_fatmot},{$color_shared},{$color_motfat},{$color_motmot}&amp;chf=bg,s,ffffff00&amp;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&amp;chd=e:{$chd}&amp;chs={$size}&amp;chco={$color_fatfat},{$color_fatmot},{$color_shared},{$color_motfat},{$color_motmot}&amp;chf=bg,s,ffffff00&amp;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
Please login to merge, or discard this patch.
src/Webtrees/Controller/JsonController.php 1 patch
Indentation   +32 added lines, -32 removed lines patch added patch discarded remove patch
@@ -18,40 +18,40 @@
 block discarded – undo
18 18
  */
19 19
 class JsonController extends BaseController {
20 20
     
21
-    /**
22
-     * {@inheritDoc}
23
-     * @see \Fisharebest\Webtrees\Controller\BaseController::pageHeader()
24
-     */
25
-    public function pageHeader() {        
26
-        header('Content-Type: application/json');
27
-        header('Cache-Control: no-cache, must-revalidate');
28
-        header('Expires: Mon, 26 Jul 1997 05:00:00 GMT');
29
-        // We've displayed the header - display the footer automatically
30
-        register_shutdown_function(array($this, 'pageFooter'));
21
+	/**
22
+	 * {@inheritDoc}
23
+	 * @see \Fisharebest\Webtrees\Controller\BaseController::pageHeader()
24
+	 */
25
+	public function pageHeader() {        
26
+		header('Content-Type: application/json');
27
+		header('Cache-Control: no-cache, must-revalidate');
28
+		header('Expires: Mon, 26 Jul 1997 05:00:00 GMT');
29
+		// We've displayed the header - display the footer automatically
30
+		register_shutdown_function(array($this, 'pageFooter'));
31 31
         
32
-        return $this;
33
-    }
32
+		return $this;
33
+	}
34 34
     
35
-    /**
36
-     * {@inheritDoc}
37
-     * @see \Fisharebest\Webtrees\Controller\BaseController::pageFooter()
38
-     */
39
-    public function pageFooter() {
40
-        return $this;
41
-    }
35
+	/**
36
+	 * {@inheritDoc}
37
+	 * @see \Fisharebest\Webtrees\Controller\BaseController::pageFooter()
38
+	 */
39
+	public function pageFooter() {
40
+		return $this;
41
+	}
42 42
     
43
-    /**
44
-     * Restrict access.
45
-     *
46
-     * @param bool $condition
47
-     *
48
-     * @return $this
49
-     */
50
-    public function restrictAccess($condition) {
51
-        if ($condition !== true) {
52
-            throw new MvcException(403);
53
-        }
43
+	/**
44
+	 * Restrict access.
45
+	 *
46
+	 * @param bool $condition
47
+	 *
48
+	 * @return $this
49
+	 */
50
+	public function restrictAccess($condition) {
51
+		if ($condition !== true) {
52
+			throw new MvcException(403);
53
+		}
54 54
     
55
-        return $this;
56
-    }
55
+		return $this;
56
+	}
57 57
 }
Please login to merge, or discard this patch.