Completed
Pull Request — master (#1904)
by Rico
09:54
created
app/Http/Controllers/HourglassChartController.php 1 patch
Spacing   +18 added lines, -18 removed lines patch added patch discarded remove patch
@@ -55,15 +55,15 @@  discard block
 block discarded – undo
55 55
 
56 56
         $this->checkIndividualAccess($individual);
57 57
 
58
-        $maximum_generations = (int)$tree->getPreference('MAX_DESCENDANCY_GENERATIONS', self::DEFAULT_MAXIMUM_GENERATIONS);
59
-        $default_generations = (int)$tree->getPreference('DEFAULT_PEDIGREE_GENERATIONS', self::DEFAULT_GENERATIONS);
58
+        $maximum_generations = (int) $tree->getPreference('MAX_DESCENDANCY_GENERATIONS', self::DEFAULT_MAXIMUM_GENERATIONS);
59
+        $default_generations = (int) $tree->getPreference('DEFAULT_PEDIGREE_GENERATIONS', self::DEFAULT_GENERATIONS);
60 60
 
61
-        $generations = (int)$request->get('generations', $default_generations);
61
+        $generations = (int) $request->get('generations', $default_generations);
62 62
 
63 63
         $generations = min($generations, $maximum_generations);
64 64
         $generations = max($generations, self::MINIMUM_GENERATIONS);
65 65
 
66
-        $show_spouse = (bool)$request->get('show_spouse');
66
+        $show_spouse = (bool) $request->get('show_spouse');
67 67
 
68 68
         /* I18N: %s is an individual’s name */
69 69
         $title = I18N::translate('Hourglass chart of %s', $individual->getFullName());
@@ -95,14 +95,14 @@  discard block
 block discarded – undo
95 95
 
96 96
         $this->checkIndividualAccess($individual);
97 97
 
98
-        $maximum_generations = (int)$tree->getPreference('MAX_DESCENDANCY_GENERATIONS', self::DEFAULT_MAXIMUM_GENERATIONS);
99
-        $default_generations = (int)$tree->getPreference('DEFAULT_PEDIGREE_GENERATIONS', self::DEFAULT_GENERATIONS);
98
+        $maximum_generations = (int) $tree->getPreference('MAX_DESCENDANCY_GENERATIONS', self::DEFAULT_MAXIMUM_GENERATIONS);
99
+        $default_generations = (int) $tree->getPreference('DEFAULT_PEDIGREE_GENERATIONS', self::DEFAULT_GENERATIONS);
100 100
 
101
-        $generations = (int)$request->get('generations', $default_generations);
101
+        $generations = (int) $request->get('generations', $default_generations);
102 102
         $generations = min($generations, $maximum_generations);
103 103
         $generations = max($generations, self::MINIMUM_GENERATIONS);
104 104
 
105
-        $show_spouse = (bool)$request->get('show_spouse');
105
+        $show_spouse = (bool) $request->get('show_spouse');
106 106
 
107 107
         ob_start();
108 108
         $this->printDescendency($individual, 1, $generations, $show_spouse, true);
@@ -115,7 +115,7 @@  discard block
 block discarded – undo
115 115
         return new Response(view('hourglass-chart', [
116 116
             'descendants' => $descendants,
117 117
             'ancestors'   => $ancestors,
118
-            'bhalfheight' => (int)(Theme::theme()->parameter('chart-box-y') / 2),
118
+            'bhalfheight' => (int) (Theme::theme()->parameter('chart-box-y') / 2),
119 119
         ]));
120 120
     }
121 121
 
@@ -134,7 +134,7 @@  discard block
 block discarded – undo
134 134
 
135 135
         $this->checkIndividualAccess($individual);
136 136
 
137
-        $show_spouse = (bool)$request->get('show_spouse');
137
+        $show_spouse = (bool) $request->get('show_spouse');
138 138
 
139 139
         ob_start();
140 140
         $this->printPersonPedigree($individual, 0, 1, $show_spouse);
@@ -156,7 +156,7 @@  discard block
 block discarded – undo
156 156
         $xref       = $request->get('xref');
157 157
         $individual = Individual::getInstance($xref, $tree);
158 158
 
159
-        $show_spouse = (bool)$request->get('show_spouse');
159
+        $show_spouse = (bool) $request->get('show_spouse');
160 160
 
161 161
         ob_start();
162 162
         $this->printDescendency($individual, 1, 2, $show_spouse, false);
@@ -309,7 +309,7 @@  discard block
 block discarded – undo
309 309
                     echo '<a href="' . e(route('hourglass', [
310 310
                             'xref'        => $spouse->getXref(),
311 311
                             'generations' => $generations,
312
-                            'show_spouse' => (int)$show_spouse,
312
+                            'show_spouse' => (int) $show_spouse,
313 313
                             'ged'         => $spouse->getTree()->getName(),
314 314
                         ])) . '" class="name1">' . $spouse->getFullName() . '</a>';
315 315
                 }
@@ -317,7 +317,7 @@  discard block
 block discarded – undo
317 317
                     echo '<a href="' . e(route('hourglass', [
318 318
                             'xref'        => $child->getXref(),
319 319
                             'generations' => $generations,
320
-                            'show_spouse' => (int)$show_spouse,
320
+                            'show_spouse' => (int) $show_spouse,
321 321
                             'ged'         => $child->getTree()->getName(),
322 322
                         ])) . '" class="name1">' . $child->getFullName() . '</a>';
323 323
                 }
@@ -332,7 +332,7 @@  discard block
 block discarded – undo
332 332
                         echo '<a href="' . e(route('hourglass', [
333 333
                                 'xref'        => $husb->getXref(),
334 334
                                 'generations' => $generations,
335
-                                'show_spouse' => (int)$show_spouse,
335
+                                'show_spouse' => (int) $show_spouse,
336 336
                                 'ged'         => $husb->getTree()->getName(),
337 337
                             ])) . '" class="name1">' . $husb->getFullName() . '</a>';
338 338
                     }
@@ -341,7 +341,7 @@  discard block
 block discarded – undo
341 341
                         echo '<a href="' . e(route('hourglass', [
342 342
                                 'xref'        => $wife->getXref(),
343 343
                                 'generations' => $generations,
344
-                                'show_spouse' => (int)$show_spouse,
344
+                                'show_spouse' => (int) $show_spouse,
345 345
                                 'ged'         => $wife->getTree()->getName(),
346 346
                             ])) . '" class="name1">' . $wife->getFullName() . '</a>';
347 347
                     }
@@ -360,7 +360,7 @@  discard block
 block discarded – undo
360 360
                         echo '<a href="' . e(route('hourglass', [
361 361
                                 'xref'        => $child->getXref(),
362 362
                                 'generations' => $generations,
363
-                                'show_spouse' => (int)$show_spouse,
363
+                                'show_spouse' => (int) $show_spouse,
364 364
                                 'ged'         => $child->getTree()->getName(),
365 365
                             ])) . '" class="name1">' . $child->getFullName() . '</a>';
366 366
                     }
@@ -423,7 +423,7 @@  discard block
 block discarded – undo
423 423
                         'href'         => '#',
424 424
                         'data-route'   => 'hourglass-add-asc',
425 425
                         'data-xref'    => $ARID,
426
-                        'data-spouses' => (int)$show_spouse,
426
+                        'data-spouses' => (int) $show_spouse,
427 427
                         'data-tree'    => $family->getHusband()->getTree()->getName(),
428 428
                     ]);
429 429
                 }
@@ -460,7 +460,7 @@  discard block
 block discarded – undo
460 460
                         'href'         => '#',
461 461
                         'data-route'   => 'hourglass-add-asc',
462 462
                         'data-xref'    => $ARID,
463
-                        'data-spouses' => (int)$show_spouse,
463
+                        'data-spouses' => (int) $show_spouse,
464 464
                         'data-tree'    => $family->getWife()->getTree()->getName(),
465 465
                     ]);
466 466
                 }
Please login to merge, or discard this patch.
app/Http/Controllers/LifespansChartController.php 1 patch
Spacing   +8 added lines, -8 removed lines patch added patch discarded remove patch
@@ -52,9 +52,9 @@  discard block
 block discarded – undo
52 52
     {
53 53
         $this->checkModuleIsActive($tree, 'lifespans_chart');
54 54
 
55
-        $xrefs     = (array)$request->get('xrefs', []);
55
+        $xrefs     = (array) $request->get('xrefs', []);
56 56
         $addxref   = $request->get('addxref', '');
57
-        $addfam    = (bool)$request->get('addfam', false);
57
+        $addfam    = (bool) $request->get('addfam', false);
58 58
         $placename = $request->get('placename', '');
59 59
         $start     = $request->get('start', '');
60 60
         $end       = $request->get('end', '');
@@ -111,7 +111,7 @@  discard block
 block discarded – undo
111 111
     {
112 112
         $this->checkModuleIsActive($tree, 'lifespans_chart');
113 113
 
114
-        $xrefs = (array)$request->get('xrefs', []);
114
+        $xrefs = (array) $request->get('xrefs', []);
115 115
         $xrefs = array_unique($xrefs);
116 116
 
117 117
         /** @var Individual[] $individuals */
@@ -131,8 +131,8 @@  discard block
 block discarded – undo
131 131
         $subtitle = $request->get('subtitle');
132 132
 
133 133
         // Round to whole decades
134
-        $start_year = (int)floor($this->minYear($individuals) / 10) * 10;
135
-        $end_year   = (int)ceil($this->maxYear($individuals) / 10) * 10;
134
+        $start_year = (int) floor($this->minYear($individuals) / 10) * 10;
135
+        $end_year   = (int) ceil($this->maxYear($individuals) / 10) * 10;
136 136
 
137 137
         $lifespans = $this->layoutIndividuals($individuals);
138 138
 
@@ -167,7 +167,7 @@  discard block
 block discarded – undo
167 167
             'U' => new ColorGenerator(120, self::SATURATION, self::LIGHTNESS, self::ALPHA, self::RANGE),
168 168
         ];
169 169
 
170
-        $current_year = (int)date('Y');
170
+        $current_year = (int) date('Y');
171 171
 
172 172
         // Latest year used in each row
173 173
         $rows = [];
@@ -196,7 +196,7 @@  discard block
 block discarded – undo
196 196
             // Fill the row up to the year (leaving a small gap)
197 197
             $rows[$next_row] = $death_year;
198 198
 
199
-            $lifespans[] = (object)[
199
+            $lifespans[] = (object) [
200 200
                 'background' => $colors[$individual->getSex()]->getNextColor(),
201 201
                 'birth_year' => $birth_year,
202 202
                 'death_year' => $death_year,
@@ -225,7 +225,7 @@  discard block
 block discarded – undo
225 225
         $year = $this->jdToYear($jd);
226 226
 
227 227
         // Don't show future dates
228
-        return min($year, (int)date('Y'));
228
+        return min($year, (int) date('Y'));
229 229
     }
230 230
 
231 231
     /**
Please login to merge, or discard this patch.
app/Http/Controllers/Auth/RegisterController.php 1 patch
Spacing   +2 added lines, -2 removed lines patch added patch discarded remove patch
@@ -118,7 +118,7 @@  discard block
 block discarded – undo
118 118
             ->setPreference('sessiontime', '0');
119 119
 
120 120
         // Create a dummy user, so we can send messages from the tree.
121
-        $sender = new User((object)[
121
+        $sender = new User((object) [
122 122
             'user_id'   => null,
123 123
             'user_name' => '',
124 124
             'real_name' => $tree->getTitle(),
@@ -137,7 +137,7 @@  discard block
 block discarded – undo
137 137
         );
138 138
 
139 139
         // Tell the genealogy contact about the registration.
140
-        $webmaster = User::find((int)$tree->getPreference('WEBMASTER_USER_ID'));
140
+        $webmaster = User::find((int) $tree->getPreference('WEBMASTER_USER_ID'));
141 141
 
142 142
         if ($webmaster !== null) {
143 143
             I18N::init($webmaster->getPreference('language'));
Please login to merge, or discard this patch.
app/Http/Controllers/FanChartController.php 1 patch
Spacing   +17 added lines, -17 removed lines patch added patch discarded remove patch
@@ -62,9 +62,9 @@  discard block
 block discarded – undo
62 62
 
63 63
         $this->checkIndividualAccess($individual);
64 64
 
65
-        $chart_style = (int)$request->get('chart_style', self::DEFAULT_STYLE);
66
-        $fan_width   = (int)$request->get('fan_width', self::DEFAULT_WIDTH);
67
-        $generations = (int)$request->get('generations', self::DEFAULT_GENERATIONS);
65
+        $chart_style = (int) $request->get('chart_style', self::DEFAULT_STYLE);
66
+        $fan_width   = (int) $request->get('fan_width', self::DEFAULT_WIDTH);
67
+        $generations = (int) $request->get('generations', self::DEFAULT_GENERATIONS);
68 68
 
69 69
         $fan_width = min($fan_width, self::MAXIMUM_WIDTH);
70 70
         $fan_width = max($fan_width, self::MINIMUM_WIDTH);
@@ -106,9 +106,9 @@  discard block
 block discarded – undo
106 106
 
107 107
         $this->checkIndividualAccess($individual);
108 108
 
109
-        $chart_style = (int)$request->get('chart_style', self::DEFAULT_STYLE);
110
-        $fan_width   = (int)$request->get('fan_width', self::DEFAULT_WIDTH);
111
-        $generations = (int)$request->get('generations', self::DEFAULT_GENERATIONS);
109
+        $chart_style = (int) $request->get('chart_style', self::DEFAULT_STYLE);
110
+        $fan_width   = (int) $request->get('fan_width', self::DEFAULT_WIDTH);
111
+        $generations = (int) $request->get('generations', self::DEFAULT_GENERATIONS);
112 112
 
113 113
         $fan_width = min($fan_width, self::MAXIMUM_WIDTH);
114 114
         $fan_width = max($fan_width, self::MINIMUM_WIDTH);
@@ -137,7 +137,7 @@  discard block
 block discarded – undo
137 137
         $scale = $fanw / 640;
138 138
 
139 139
         // Create the image
140
-        $image = imagecreate((int)$fanw, (int)$fanh);
140
+        $image = imagecreate((int) $fanw, (int) $fanh);
141 141
 
142 142
         // Create colors
143 143
         $transparent = imagecolorallocate($image, 0, 0, 0);
@@ -154,7 +154,7 @@  discard block
 block discarded – undo
154 154
         ];
155 155
 
156 156
 
157
-        imagefilledrectangle($image, 0, 0, (int)$fanw, (int)$fanh, $transparent);
157
+        imagefilledrectangle($image, 0, 0, (int) $fanw, (int) $fanh, $transparent);
158 158
 
159 159
         $fandeg = 90 * $chart_style;
160 160
 
@@ -169,7 +169,7 @@  discard block
 block discarded – undo
169 169
             // clean current generation area
170 170
             $deg2 = 360 + ($fandeg - 180) / 2;
171 171
             $deg1 = $deg2 - $fandeg;
172
-            imagefilledarc($image, (int)$cx, (int)$cy, (int)$rx, (int)$rx, (int)$deg1, (int)$deg2, $backgrounds['U'], IMG_ARC_PIE);
172
+            imagefilledarc($image, (int) $cx, (int) $cy, (int) $rx, (int) $rx, (int) $deg1, (int) $deg2, $backgrounds['U'], IMG_ARC_PIE);
173 173
             $rx -= 3;
174 174
 
175 175
             // calculate new angle
@@ -199,15 +199,15 @@  discard block
 block discarded – undo
199 199
 
200 200
                     $background = $backgrounds[$person->getSex()];
201 201
 
202
-                    imagefilledarc($image, (int)$cx, (int)$cy, (int)$rx, (int)$rx, (int)$deg1, (int)$deg2, $background, IMG_ARC_PIE);
202
+                    imagefilledarc($image, (int) $cx, (int) $cy, (int) $rx, (int) $rx, (int) $deg1, (int) $deg2, $background, IMG_ARC_PIE);
203 203
 
204 204
                     // split and center text by lines
205
-                    $wmax = (int)($angle * 7 / 7 * $scale);
205
+                    $wmax = (int) ($angle * 7 / 7 * $scale);
206 206
                     $wmax = min($wmax, 35 * $scale);
207 207
                     if ($gen == 0) {
208 208
                         $wmax = min($wmax, 17 * $scale);
209 209
                     }
210
-                    $text = $this->splitAlignText($text, (int)$wmax);
210
+                    $text = $this->splitAlignText($text, (int) $wmax);
211 211
 
212 212
                     // text angle
213 213
                     $tangle = 270 - ($deg1 + $angle / 2);
@@ -376,7 +376,7 @@  discard block
 block discarded – undo
376 376
                     }
377 377
                     $line .= "$word";
378 378
                 } else {
379
-                    $p = max(0, (int)(($maxlen - $len) / 2));
379
+                    $p = max(0, (int) (($maxlen - $len) / 2));
380 380
                     if (!empty($line)) {
381 381
                         $line = str_repeat(' ', $p) . $line; // center alignment using spaces
382 382
                         $text .= $line . "\n";
@@ -391,7 +391,7 @@  discard block
 block discarded – undo
391 391
             if (in_array(ord($line{0}), $RTLOrd)) {
392 392
                 $len /= 2;
393 393
             }
394
-            $p    = max(0, (int)(($maxlen - $len) / 2));
394
+            $p    = max(0, (int) (($maxlen - $len) / 2));
395 395
             $line = str_repeat(' ', $p) . $line; // center alignment using spaces
396 396
             $text .= $line;
397 397
         }
@@ -411,9 +411,9 @@  discard block
 block discarded – undo
411 411
     {
412 412
         return imagecolorallocate(
413 413
             $image,
414
-            (int)hexdec(substr($css_color, 0, 2)),
415
-            (int)hexdec(substr($css_color, 2, 2)),
416
-            (int)hexdec(substr($css_color, 4, 2))
414
+            (int) hexdec(substr($css_color, 0, 2)),
415
+            (int) hexdec(substr($css_color, 2, 2)),
416
+            (int) hexdec(substr($css_color, 4, 2))
417 417
         );
418 418
     }
419 419
 
Please login to merge, or discard this patch.
app/Http/Controllers/StatisticsChartController.php 1 patch
Spacing   +3 added lines, -3 removed lines patch added patch discarded remove patch
@@ -576,7 +576,7 @@  discard block
 block discarded – undo
576 576
                         $z_axis = $this->axisAll();
577 577
                         // The stats query doesn't have an "all" function, so query M/F/U separately
578 578
                         foreach (['M', 'F', 'U'] as $sex) {
579
-                            $rows  = $stats->statsMarrAgeQuery(false, $sex);
579
+                            $rows = $stats->statsMarrAgeQuery(false, $sex);
580 580
                             $indi = [];
581 581
                             foreach ($rows as $row) {
582 582
                                 if (!in_array($row->d_gid, $indi)) {
@@ -589,7 +589,7 @@  discard block
 block discarded – undo
589 589
                     case self::Z_AXIS_SEX:
590 590
                         $z_axis = $this->axisSexes();
591 591
                         foreach (array_keys($z_axis) as $sex) {
592
-                            $rows  = $stats->statsMarrAgeQuery(false, $sex);
592
+                            $rows = $stats->statsMarrAgeQuery(false, $sex);
593 593
                             $indi = [];
594 594
                             foreach ($rows as $row) {
595 595
                                 if (!in_array($row->d_gid, $indi)) {
@@ -605,7 +605,7 @@  discard block
 block discarded – undo
605 605
                         // The stats query doesn't have an "all" function, so query M/F/U separately
606 606
                         foreach (['M', 'F', 'U'] as $sex) {
607 607
                             $prev_boundary = 0;
608
-                            $indi   = [];
608
+                            $indi = [];
609 609
                             foreach (array_keys($z_axis) as $boundary) {
610 610
                                 $rows = $stats->statsMarrAgeQuery(false, $sex, $prev_boundary, $boundary);
611 611
                                 foreach ($rows as $row) {
Please login to merge, or discard this patch.
app/Http/Controllers/AdminController.php 1 patch
Spacing   +38 added lines, -38 removed lines patch added patch discarded remove patch
@@ -165,7 +165,7 @@  discard block
 block discarded – undo
165 165
             $user_list[$tmp_user->getUserName()] = $tmp_user->getUserName();
166 166
         }
167 167
 
168
-        $action   = $request->get('action');
168
+        $action = $request->get('action');
169 169
 
170 170
         // @TODO This ought to be a POST action
171 171
         if ($action === 'delete') {
@@ -231,7 +231,7 @@  discard block
 block discarded – undo
231 231
      */
232 232
     public function changesLogData(Request $request): Response
233 233
     {
234
-        list($select, , $where, $args1) = $this->changesQuery($request);
234
+        list($select,, $where, $args1) = $this->changesQuery($request);
235 235
         list($order_by, $limit, $args2) = $this->dataTablesPagination($request);
236 236
 
237 237
         $rows = Database::prepare(
@@ -239,8 +239,8 @@  discard block
 block discarded – undo
239 239
         )->execute(array_merge($args1, $args2))->fetchAll();
240 240
 
241 241
         // Total filtered/unfiltered rows
242
-        $recordsFiltered = (int)Database::prepare("SELECT FOUND_ROWS()")->fetchOne();
243
-        $recordsTotal    = (int)Database::prepare("SELECT COUNT(*) FROM `##change`")->fetchOne();
242
+        $recordsFiltered = (int) Database::prepare("SELECT FOUND_ROWS()")->fetchOne();
243
+        $recordsTotal    = (int) Database::prepare("SELECT COUNT(*) FROM `##change`")->fetchOne();
244 244
 
245 245
         $data      = [];
246 246
         $algorithm = new MyersDiff();
@@ -291,7 +291,7 @@  discard block
 block discarded – undo
291 291
 
292 292
         // See http://www.datatables.net/usage/server-side
293 293
         return new JsonResponse([
294
-            'draw'            => (int)$request->get('draw'),
294
+            'draw'            => (int) $request->get('draw'),
295 295
             'recordsTotal'    => $recordsTotal,
296 296
             'recordsFiltered' => $recordsFiltered,
297 297
             'data'            => $data,
@@ -307,7 +307,7 @@  discard block
 block discarded – undo
307 307
      */
308 308
     public function changesLogDownload(Request $request): Response
309 309
     {
310
-        list($select, , $where, $args) = $this->changesQuery($request);
310
+        list($select,, $where, $args) = $this->changesQuery($request);
311 311
 
312 312
         $rows = Database::prepare($select . $where)->execute($args)->fetchAll();
313 313
 
@@ -449,8 +449,8 @@  discard block
 block discarded – undo
449 449
             'RESN',
450 450
         ];
451 451
 
452
-        $start  = (int)$request->get('start', 0);
453
-        $length = (int)$request->get('length', 20);
452
+        $start  = (int) $request->get('start', 0);
453
+        $length = (int) $request->get('length', 20);
454 454
         $search = $request->get('search', []);
455 455
         $search = $search['value'] ?? '';
456 456
 
@@ -470,7 +470,7 @@  discard block
 block discarded – undo
470 470
         $args  = [];
471 471
 
472 472
         if ($search !== '') {
473
-            $where           .= " AND (multimedia_file_refn LIKE CONCAT('%', :search1, '%') OR multimedia_file_refn LIKE CONCAT('%', :search2, '%'))";
473
+            $where .= " AND (multimedia_file_refn LIKE CONCAT('%', :search1, '%') OR multimedia_file_refn LIKE CONCAT('%', :search2, '%'))";
474 474
             $args['search1'] = $search;
475 475
             $args['search2'] = $search;
476 476
         }
@@ -489,8 +489,8 @@  discard block
 block discarded – undo
489 489
         )->fetchAll();
490 490
 
491 491
         // Total filtered/unfiltered rows
492
-        $recordsFiltered = (int)Database::prepare("SELECT FOUND_ROWS()")->fetchOne();
493
-        $recordsTotal    = (int)Database::prepare($select2)->fetchOne();
492
+        $recordsFiltered = (int) Database::prepare("SELECT FOUND_ROWS()")->fetchOne();
493
+        $recordsTotal    = (int) Database::prepare($select2)->fetchOne();
494 494
 
495 495
         // Turn each row from the query into a row for the table
496 496
         $data = array_map(function (stdClass $datum) use ($ignore_facts) {
@@ -532,7 +532,7 @@  discard block
 block discarded – undo
532 532
         }, $data);
533 533
 
534 534
         return new JsonResponse([
535
-            'draw'            => (int)$request->get('draw'),
535
+            'draw'            => (int) $request->get('draw'),
536 536
             'recordsTotal'    => $recordsTotal,
537 537
             'recordsFiltered' => $recordsFiltered,
538 538
             'data'            => $data,
@@ -621,8 +621,8 @@  discard block
 block discarded – undo
621 621
      */
622 622
     public function webtrees1ThumbnailsData(Request $request): JsonResponse
623 623
     {
624
-        $start  = (int)$request->get('start', 0);
625
-        $length = (int)$request->get('length', 20);
624
+        $start  = (int) $request->get('start', 0);
625
+        $length = (int) $request->get('length', 20);
626 626
         $search = $request->get('search', []);
627 627
         $search = $search['value'] ?? '';
628 628
 
@@ -653,7 +653,7 @@  discard block
 block discarded – undo
653 653
         $data = array_map(function (string $thumbnail) {
654 654
             $original = $this->findOriginalFileFromThumbnail($thumbnail);
655 655
 
656
-            $original_url  = route('unused-media-thumbnail', [
656
+            $original_url = route('unused-media-thumbnail', [
657 657
                 'folder' => dirname($original),
658 658
                 'file'   => basename($original),
659 659
                 'w'      => 100,
@@ -695,7 +695,7 @@  discard block
 block discarded – undo
695 695
         }, $thumbnails);
696 696
 
697 697
         return new JsonResponse([
698
-            'draw'            => (int)$request->get('draw'),
698
+            'draw'            => (int) $request->get('draw'),
699 699
             'recordsTotal'    => $recordsTotal,
700 700
             'recordsFiltered' => $recordsFiltered,
701 701
             'data'            => $data,
@@ -1021,7 +1021,7 @@  discard block
 block discarded – undo
1021 1021
      */
1022 1022
     public function treePrivacyUpdate(Request $request, Tree $tree): RedirectResponse
1023 1023
     {
1024
-        foreach ((array)$request->get('delete') as $default_resn_id) {
1024
+        foreach ((array) $request->get('delete') as $default_resn_id) {
1025 1025
             Database::prepare(
1026 1026
                 "DELETE FROM `##default_resn` WHERE default_resn_id = :default_resn_id"
1027 1027
             )->execute([
@@ -1029,13 +1029,13 @@  discard block
 block discarded – undo
1029 1029
             ]);
1030 1030
         }
1031 1031
 
1032
-        $xrefs     = (array)$request->get('xref');
1033
-        $tag_types = (array)$request->get('tag_type');
1034
-        $resns     = (array)$request->get('resn');
1032
+        $xrefs     = (array) $request->get('xref');
1033
+        $tag_types = (array) $request->get('tag_type');
1034
+        $resns     = (array) $request->get('resn');
1035 1035
 
1036 1036
         foreach ($xrefs as $n => $xref) {
1037
-            $tag_type = (string)$tag_types[$n];
1038
-            $resn     = (string)$resns[$n];
1037
+            $tag_type = (string) $tag_types[$n];
1038
+            $resn     = (string) $resns[$n];
1039 1039
 
1040 1040
             if ($tag_type !== '' || $xref !== '') {
1041 1041
                 // Delete any existing data
@@ -1081,10 +1081,10 @@  discard block
 block discarded – undo
1081 1081
         FlashMessages::addMessage(I18N::translate('The preferences for the family tree “%s” have been updated.', e($tree->getTitle()), 'success'));
1082 1082
 
1083 1083
         // Coming soon...
1084
-        if ((bool)$request->get('all_trees')) {
1084
+        if ((bool) $request->get('all_trees')) {
1085 1085
             FlashMessages::addMessage(I18N::translate('The preferences for all family trees have been updated.', e($tree->getTitle())), 'success');
1086 1086
         }
1087
-        if ((bool)$request->get('new_trees')) {
1087
+        if ((bool) $request->get('new_trees')) {
1088 1088
             FlashMessages::addMessage(I18N::translate('The preferences for new family trees have been updated.', e($tree->getTitle())), 'success');
1089 1089
         }
1090 1090
 
@@ -1107,7 +1107,7 @@  discard block
 block discarded – undo
1107 1107
         foreach ($modules as $module) {
1108 1108
             foreach (Tree::getAll() as $tree) {
1109 1109
                 $key          = 'access-' . $module->getName() . '-' . $tree->getTreeId();
1110
-                $access_level = (int)$request->get($key, $module->defaultAccessLevel());
1110
+                $access_level = (int) $request->get($key, $module->defaultAccessLevel());
1111 1111
 
1112 1112
                 Database::prepare("REPLACE INTO `##module_privacy` (module_name, gedcom_id, component, access_level) VALUES (:module_name, :tree_id, :component, :access_level)")->execute([
1113 1113
                     'module_name'  => $module->getName(),
@@ -1134,7 +1134,7 @@  discard block
 block discarded – undo
1134 1134
         $module_status = Database::prepare("SELECT module_name, status FROM `##module`")->fetchAssoc();
1135 1135
 
1136 1136
         foreach ($modules as $module) {
1137
-            $new_status = (bool)$request->get('status-' . $module->getName()) ? 'enabled' : 'disabled';
1137
+            $new_status = (bool) $request->get('status-' . $module->getName()) ? 'enabled' : 'disabled';
1138 1138
             $old_status = $module_status[$module->getName()];
1139 1139
 
1140 1140
             if ($new_status !== $old_status) {
@@ -1197,36 +1197,36 @@  discard block
 block discarded – undo
1197 1197
         $where = ' WHERE 1';
1198 1198
         $args  = [];
1199 1199
         if ($search !== '') {
1200
-            $where            .= " AND (old_gedcom LIKE CONCAT('%', :search_1, '%') OR new_gedcom LIKE CONCAT('%', :search_2, '%'))";
1200
+            $where .= " AND (old_gedcom LIKE CONCAT('%', :search_1, '%') OR new_gedcom LIKE CONCAT('%', :search_2, '%'))";
1201 1201
             $args['search_1'] = $search;
1202 1202
             $args['search_2'] = $search;
1203 1203
         }
1204 1204
         if ($from !== '') {
1205
-            $where        .= " AND change_time >= :from";
1205
+            $where .= " AND change_time >= :from";
1206 1206
             $args['from'] = $from;
1207 1207
         }
1208 1208
         if ($to !== '') {
1209
-            $where      .= ' AND change_time < TIMESTAMPADD(DAY, 1 , :to)'; // before end of the day
1209
+            $where .= ' AND change_time < TIMESTAMPADD(DAY, 1 , :to)'; // before end of the day
1210 1210
             $args['to'] = $to;
1211 1211
         }
1212 1212
         if ($type !== '') {
1213
-            $where          .= ' AND status = :status';
1213
+            $where .= ' AND status = :status';
1214 1214
             $args['status'] = $type;
1215 1215
         }
1216 1216
         if ($oldged !== '') {
1217
-            $where           .= " AND old_gedcom LIKE CONCAT('%', :old_ged, '%')";
1217
+            $where .= " AND old_gedcom LIKE CONCAT('%', :old_ged, '%')";
1218 1218
             $args['old_ged'] = $oldged;
1219 1219
         }
1220 1220
         if ($newged !== '') {
1221
-            $where           .= " AND new_gedcom LIKE CONCAT('%', :new_ged, '%')";
1221
+            $where .= " AND new_gedcom LIKE CONCAT('%', :new_ged, '%')";
1222 1222
             $args['new_ged'] = $newged;
1223 1223
         }
1224 1224
         if ($xref !== '') {
1225
-            $where        .= " AND xref = :xref";
1225
+            $where .= " AND xref = :xref";
1226 1226
             $args['xref'] = $xref;
1227 1227
         }
1228 1228
         if ($username !== '') {
1229
-            $where        .= " AND user_name LIKE CONCAT('%', :user, '%')";
1229
+            $where .= " AND user_name LIKE CONCAT('%', :user, '%')";
1230 1230
             $args['user'] = $username;
1231 1231
         }
1232 1232
         if ($ged !== '') {
@@ -1277,8 +1277,8 @@  discard block
 block discarded – undo
1277 1277
      */
1278 1278
     private function dataTablesPagination(Request $request): array
1279 1279
     {
1280
-        $start  = (int)$request->get('start', '0');
1281
-        $length = (int)$request->get('length', '0');
1280
+        $start  = (int) $request->get('start', '0');
1281
+        $length = (int) $request->get('length', '0');
1282 1282
         $order  = $request->get('order', []);
1283 1283
         $args   = [];
1284 1284
 
@@ -1429,7 +1429,7 @@  discard block
 block discarded – undo
1429 1429
         }
1430 1430
 
1431 1431
         // The maximum difference is 255 (black versus white).
1432
-        return 100 - (int)($max_difference * 100 / 255);
1432
+        return 100 - (int) ($max_difference * 100 / 255);
1433 1433
     }
1434 1434
 
1435 1435
     /**
@@ -1460,7 +1460,7 @@  discard block
 block discarded – undo
1460 1460
             $pixels[$x] = [];
1461 1461
             for ($y = 0; $y < $size; ++$y) {
1462 1462
                 $pixel          = $image->pickColor($x, $y);
1463
-                $pixels[$x][$y] = (int)(($pixel[0] + $pixel[1] + $pixel[2]) / 3);
1463
+                $pixels[$x][$y] = (int) (($pixel[0] + $pixel[1] + $pixel[2]) / 3);
1464 1464
             }
1465 1465
         }
1466 1466
 
Please login to merge, or discard this patch.
app/Module/PedigreeMapModule.php 1 patch
Spacing   +10 added lines, -10 removed lines patch added patch discarded remove patch
@@ -35,7 +35,7 @@  discard block
 block discarded – undo
35 35
  */
36 36
 class PedigreeMapModule extends AbstractModule implements ModuleChartInterface
37 37
 {
38
-    const LINE_COLORS  = [
38
+    const LINE_COLORS = [
39 39
         '#FF0000',
40 40
         // Red
41 41
         '#00FF00',
@@ -140,7 +140,7 @@  discard block
 block discarded – undo
140 140
                     $color            = self::LINE_COLORS[log($id, 2) % $color_count];
141 141
                     $icon['color']    = $color; //make icon color the same as the line
142 142
                     $sosa_points[$id] = $event->getLatLonJSArray();
143
-                    $sosa_parent      = (int)floor($id / 2);
143
+                    $sosa_parent      = (int) floor($id / 2);
144 144
                     if (array_key_exists($sosa_parent, $sosa_points)) {
145 145
                         // Would like to use a GeometryCollection to hold LineStrings
146 146
                         // rather than generate polylines but the MarkerCluster library
@@ -168,7 +168,7 @@  discard block
 block discarded – undo
168 168
                             'icon'     => $icon,
169 169
                             'tooltip'  => $event->toolTip(),
170 170
                             'summary'  => view('modules/pedigree-map/event-sidebar', $event->shortSummary('pedigree', $id)),
171
-                            'zoom'     => (int)$event->getZoom(),
171
+                            'zoom'     => (int) $event->getZoom(),
172 172
                         ],
173 173
                     ];
174 174
                 }
@@ -188,7 +188,7 @@  discard block
 block discarded – undo
188 188
     {
189 189
         $xref        = $request->get('reference');
190 190
         $individual  = Individual::getInstance($xref, $tree);
191
-        $generations = (int)$request->get(
191
+        $generations = (int) $request->get(
192 192
             'generations',
193 193
             $tree->getPreference('DEFAULT_PEDIGREE_GENERATIONS')
194 194
         );
@@ -241,14 +241,14 @@  discard block
 block discarded – undo
241 241
                         function ($item) {
242 242
                             return preg_replace('/[^a-z\d]/i', '', strtolower($item));
243 243
                         },
244
-                        (array)$provider->styles
244
+                        (array) $provider->styles
245 245
                     );
246 246
 
247
-                    $key = preg_replace('/[^a-z\d]/i', '', strtolower((string)$provider->name));
247
+                    $key = preg_replace('/[^a-z\d]/i', '', strtolower((string) $provider->name));
248 248
 
249 249
                     self::$map_providers[$key] = [
250
-                        'name'   => (string)$provider->name,
251
-                        'styles' => array_combine($style_keys, (array)$provider->styles),
250
+                        'name'   => (string) $provider->name,
251
+                        'styles' => array_combine($style_keys, (array) $provider->styles),
252 252
                     ];
253 253
                 }
254 254
             } catch (Exception $ex) {
@@ -257,7 +257,7 @@  discard block
 block discarded – undo
257 257
                     'provider' => 'openstreetmap',
258 258
                     'style'    => 'mapnik',
259 259
                 ];
260
-                self::$map_providers  = [
260
+                self::$map_providers = [
261 261
                     'openstreetmap' => [
262 262
                         'name'   => 'OpenStreetMap',
263 263
                         'styles' => ['mapnik' => 'Mapnik'],
@@ -318,7 +318,7 @@  discard block
 block discarded – undo
318 318
             throw new IndividualAccessDeniedException();
319 319
         }
320 320
         
321
-        return (object)[
321
+        return (object) [
322 322
             'name' => 'modules/pedigree-map/pedigree-map-page',
323 323
             'data' => [
324 324
                 'module'         => $this->getName(),
Please login to merge, or discard this patch.
app/Http/Controllers/SearchController.php 1 patch
Spacing   +46 added lines, -46 removed lines patch added patch discarded remove patch
@@ -163,11 +163,11 @@  discard block
 block discarded – undo
163 163
         $query = $request->get('query', '');
164 164
 
165 165
         // What type of records to search?
166
-        $search_individuals  = (bool)$request->get('search_individuals');
167
-        $search_families     = (bool)$request->get('search_families');
168
-        $search_repositories = (bool)$request->get('search_repositories');
169
-        $search_sources      = (bool)$request->get('search_sources');
170
-        $search_notes        = (bool)$request->get('search_notes');
166
+        $search_individuals  = (bool) $request->get('search_individuals');
167
+        $search_families     = (bool) $request->get('search_families');
168
+        $search_repositories = (bool) $request->get('search_repositories');
169
+        $search_sources      = (bool) $request->get('search_sources');
170
+        $search_notes        = (bool) $request->get('search_notes');
171 171
 
172 172
         // Default to individuals only
173 173
         if (!$search_individuals && !$search_families && !$search_repositories && !$search_sources && !$search_notes) {
@@ -184,7 +184,7 @@  discard block
 block discarded – undo
184 184
             $all_trees = [$tree];
185 185
         }
186 186
 
187
-        $search_tree_names = (array)$request->get('search_trees', []);
187
+        $search_tree_names = (array) $request->get('search_trees', []);
188 188
 
189 189
         $search_trees = array_filter($all_trees, function (Tree $tree) use ($search_tree_names): bool {
190 190
             return in_array($tree->getName(), $search_tree_names);
@@ -290,7 +290,7 @@  discard block
 block discarded – undo
290 290
             $all_trees = [$tree];
291 291
         }
292 292
 
293
-        $search_tree_names = (array)$request->get('search_trees', []);
293
+        $search_tree_names = (array) $request->get('search_trees', []);
294 294
 
295 295
         $search_trees = array_filter($all_trees, function (Tree $tree) use ($search_tree_names): bool {
296 296
             return in_array($tree->getName(), $search_tree_names);
@@ -640,7 +640,7 @@  discard block
 block discarded – undo
640 640
 
641 641
         foreach ($search_terms as $n => $q) {
642 642
             $queryregex[]          = preg_quote(I18N::strtoupper($q), '/');
643
-            $sql                   .= " AND f_gedcom COLLATE :collate_" . $n . " LIKE CONCAT('%', :query_" . $n . ", '%')";
643
+            $sql .= " AND f_gedcom COLLATE :collate_" . $n . " LIKE CONCAT('%', :query_" . $n . ", '%')";
644 644
             $args['collate_' . $n] = I18N::collation();
645 645
             $args['query_' . $n]   = Database::escapeLike($q);
646 646
         }
@@ -688,7 +688,7 @@  discard block
 block discarded – undo
688 688
      */
689 689
     private function searchFamilyNames(array $search_terms, array $search_trees): array
690 690
     {
691
-        $sql  =
691
+        $sql =
692 692
             "SELECT DISTINCT f_id AS xref, f_file AS gedcom_id, f_gedcom AS gedcom" .
693 693
             " FROM `##families`" .
694 694
             " LEFT JOIN `##name` husb ON f_husb = husb.n_id AND f_file = husb.n_file" .
@@ -697,7 +697,7 @@  discard block
 block discarded – undo
697 697
         $args = [];
698 698
 
699 699
         foreach ($search_terms as $n => $q) {
700
-            $sql                        .= " AND (husb.n_full COLLATE :husb_collate_" . $n . " LIKE CONCAT('%', :husb_query_" . $n . ", '%') OR wife.n_full COLLATE :wife_collate_" . $n . " LIKE CONCAT('%', :wife_query_" . $n . ", '%'))";
700
+            $sql .= " AND (husb.n_full COLLATE :husb_collate_" . $n . " LIKE CONCAT('%', :husb_query_" . $n . ", '%') OR wife.n_full COLLATE :wife_collate_" . $n . " LIKE CONCAT('%', :wife_query_" . $n . ", '%'))";
701 701
             $args['husb_collate_' . $n] = I18N::collation();
702 702
             $args['husb_query_' . $n]   = Database::escapeLike($q);
703 703
             $args['wife_collate_' . $n] = I18N::collation();
@@ -749,7 +749,7 @@  discard block
 block discarded – undo
749 749
 
750 750
         foreach ($search_terms as $n => $q) {
751 751
             $queryregex[]          = preg_quote(I18N::strtoupper($q), '/');
752
-            $sql                   .= " AND i_gedcom COLLATE :collate_" . $n . " LIKE CONCAT('%', :query_" . $n . ", '%')";
752
+            $sql .= " AND i_gedcom COLLATE :collate_" . $n . " LIKE CONCAT('%', :query_" . $n . ", '%')";
753 753
             $args['collate_' . $n] = I18N::collation();
754 754
             $args['query_' . $n]   = Database::escapeLike($q);
755 755
         }
@@ -896,7 +896,7 @@  discard block
 block discarded – undo
896 896
         }
897 897
 
898 898
         // Add the where clause
899
-        $sql    .= " WHERE ind.i_file=?";
899
+        $sql .= " WHERE ind.i_file=?";
900 900
         $bind[] = $tree->getTreeId();
901 901
 
902 902
         foreach ($fields as $field_name => $field_value) {
@@ -907,15 +907,15 @@  discard block
 block discarded – undo
907 907
                     case 'GIVN':
908 908
                         switch ($modifiers[$field_name]) {
909 909
                             case 'EXACT':
910
-                                $sql    .= " AND i_n.n_givn=?";
910
+                                $sql .= " AND i_n.n_givn=?";
911 911
                                 $bind[] = $field_value;
912 912
                                 break;
913 913
                             case 'BEGINS':
914
-                                $sql    .= " AND i_n.n_givn LIKE CONCAT(?, '%')";
914
+                                $sql .= " AND i_n.n_givn LIKE CONCAT(?, '%')";
915 915
                                 $bind[] = $field_value;
916 916
                                 break;
917 917
                             case 'CONTAINS':
918
-                                $sql    .= " AND i_n.n_givn LIKE CONCAT('%', ?, '%')";
918
+                                $sql .= " AND i_n.n_givn LIKE CONCAT('%', ?, '%')";
919 919
                                 $bind[] = $field_value;
920 920
                                 break;
921 921
                             case 'SDX_STD':
@@ -929,7 +929,7 @@  discard block
 block discarded – undo
929 929
                                     $sql .= ' AND (' . implode(' OR ', $sdx) . ')';
930 930
                                 } else {
931 931
                                     // No phonetic content? Use a substring match
932
-                                    $sql    .= " AND i_n.n_givn LIKE CONCAT('%', ?, '%')";
932
+                                    $sql .= " AND i_n.n_givn LIKE CONCAT('%', ?, '%')";
933 933
                                     $bind[] = $field_value;
934 934
                                 }
935 935
                                 break;
@@ -945,7 +945,7 @@  discard block
 block discarded – undo
945 945
                                     $sql .= ' AND (' . implode(' OR ', $sdx) . ')';
946 946
                                 } else {
947 947
                                     // No phonetic content? Use a substring match
948
-                                    $sql    .= " AND i_n.n_givn LIKE CONCAT('%', ?, '%')";
948
+                                    $sql .= " AND i_n.n_givn LIKE CONCAT('%', ?, '%')";
949 949
                                     $bind[] = $field_value;
950 950
                                 }
951 951
                                 break;
@@ -954,15 +954,15 @@  discard block
 block discarded – undo
954 954
                     case 'SURN':
955 955
                         switch ($modifiers[$field_name]) {
956 956
                             case 'EXACT':
957
-                                $sql    .= " AND i_n.n_surname=?";
957
+                                $sql .= " AND i_n.n_surname=?";
958 958
                                 $bind[] = $field_value;
959 959
                                 break;
960 960
                             case 'BEGINS':
961
-                                $sql    .= " AND i_n.n_surname LIKE CONCAT(?, '%')";
961
+                                $sql .= " AND i_n.n_surname LIKE CONCAT(?, '%')";
962 962
                                 $bind[] = $field_value;
963 963
                                 break;
964 964
                             case 'CONTAINS':
965
-                                $sql    .= " AND i_n.n_surname LIKE CONCAT('%', ?, '%')";
965
+                                $sql .= " AND i_n.n_surname LIKE CONCAT('%', ?, '%')";
966 966
                                 $bind[] = $field_value;
967 967
                                 break;
968 968
                             case 'SDX_STD':
@@ -976,7 +976,7 @@  discard block
 block discarded – undo
976 976
                                     $sql .= " AND (" . implode(' OR ', $sdx) . ")";
977 977
                                 } else {
978 978
                                     // No phonetic content? Use a substring match
979
-                                    $sql    .= " AND i_n.n_surn LIKE CONCAT('%', ?, '%')";
979
+                                    $sql .= " AND i_n.n_surn LIKE CONCAT('%', ?, '%')";
980 980
                                     $bind[] = $field_value;
981 981
                                 }
982 982
                                 break;
@@ -993,7 +993,7 @@  discard block
 block discarded – undo
993 993
                                     break;
994 994
                                 } else {
995 995
                                     // No phonetic content? Use a substring match
996
-                                    $sql    .= " AND i_n.n_surn LIKE CONCAT('%', ?, '%')";
996
+                                    $sql .= " AND i_n.n_surn LIKE CONCAT('%', ?, '%')";
997 997
                                     $bind[] = $field_value;
998 998
                                 }
999 999
                         }
@@ -1002,7 +1002,7 @@  discard block
 block discarded – undo
1002 1002
                     case '_MARNM':
1003 1003
                     case '_HEB':
1004 1004
                     case '_AKA':
1005
-                        $sql    .= " AND i_n.n_type=? AND i_n.n_full LIKE CONCAT('%', ?, '%')";
1005
+                        $sql .= " AND i_n.n_type=? AND i_n.n_full LIKE CONCAT('%', ?, '%')";
1006 1006
                         $bind[] = $parts[1];
1007 1007
                         $bind[] = $field_value;
1008 1008
                         break;
@@ -1012,7 +1012,7 @@  discard block
 block discarded – undo
1012 1012
                 $date = new Date($field_value);
1013 1013
                 if ($date->isOK()) {
1014 1014
                     $delta  = 365 * ($modifiers[$field_name] ?? 0);
1015
-                    $sql    .= " AND i_d.d_fact=? AND i_d.d_julianday1>=? AND i_d.d_julianday2<=?";
1015
+                    $sql .= " AND i_d.d_fact=? AND i_d.d_julianday1>=? AND i_d.d_julianday2<=?";
1016 1016
                     $bind[] = $parts[0];
1017 1017
                     $bind[] = $date->minimumJulianDay() - $delta;
1018 1018
                     $bind[] = $date->maximumJulianDay() + $delta;
@@ -1022,7 +1022,7 @@  discard block
 block discarded – undo
1022 1022
                 $date = new Date($field_value);
1023 1023
                 if ($date->isOK()) {
1024 1024
                     $delta  = 365 * $modifiers[$field_name];
1025
-                    $sql    .= " AND f_d.d_fact=? AND f_d.d_julianday1>=? AND f_d.d_julianday2<=?";
1025
+                    $sql .= " AND f_d.d_fact=? AND f_d.d_julianday1>=? AND f_d.d_julianday2<=?";
1026 1026
                     $bind[] = $parts[1];
1027 1027
                     $bind[] = $date->minimumJulianDay() - $delta;
1028 1028
                     $bind[] = $date->maximumJulianDay() + $delta;
@@ -1030,12 +1030,12 @@  discard block
 block discarded – undo
1030 1030
             } elseif ($parts[1] === 'PLAC') {
1031 1031
                 // *:PLAC
1032 1032
                 // SQL can only link a place to a person/family, not to an event.
1033
-                $sql    .= " AND i_p.place LIKE CONCAT('%', ?, '%')";
1033
+                $sql .= " AND i_p.place LIKE CONCAT('%', ?, '%')";
1034 1034
                 $bind[] = $field_value;
1035 1035
             } elseif ($parts[0] === 'FAMS' && $parts[2] === 'PLAC') {
1036 1036
                 // FAMS:*:PLAC
1037 1037
                 // SQL can only link a place to a person/family, not to an event.
1038
-                $sql    .= " AND f_p.place LIKE CONCAT('%', ?, '%')";
1038
+                $sql .= " AND f_p.place LIKE CONCAT('%', ?, '%')";
1039 1039
                 $bind[] = $field_value;
1040 1040
             } elseif ($parts[0] === 'FAMC' && $parts[2] === 'NAME') {
1041 1041
                 $table = $parts[1] === 'HUSB' ? 'f_n' : 'm_n';
@@ -1044,15 +1044,15 @@  discard block
 block discarded – undo
1044 1044
                     case 'GIVN':
1045 1045
                         switch ($modifiers[$field_name]) {
1046 1046
                             case 'EXACT':
1047
-                                $sql    .= " AND {$table}.n_givn=?";
1047
+                                $sql .= " AND {$table}.n_givn=?";
1048 1048
                                 $bind[] = $field_value;
1049 1049
                                 break;
1050 1050
                             case 'BEGINS':
1051
-                                $sql    .= " AND {$table}.n_givn LIKE CONCAT(?, '%')";
1051
+                                $sql .= " AND {$table}.n_givn LIKE CONCAT(?, '%')";
1052 1052
                                 $bind[] = $field_value;
1053 1053
                                 break;
1054 1054
                             case 'CONTAINS':
1055
-                                $sql    .= " AND {$table}.n_givn LIKE CONCAT('%', ?, '%')";
1055
+                                $sql .= " AND {$table}.n_givn LIKE CONCAT('%', ?, '%')";
1056 1056
                                 $bind[] = $field_value;
1057 1057
                                 break;
1058 1058
                             case 'SDX_STD':
@@ -1066,7 +1066,7 @@  discard block
 block discarded – undo
1066 1066
                                     $sql .= ' AND (' . implode(' OR ', $sdx) . ')';
1067 1067
                                 } else {
1068 1068
                                     // No phonetic content? Use a substring match
1069
-                                    $sql    .= " AND {$table}.n_givn LIKE CONCAT('%', ?, '%')";
1069
+                                    $sql .= " AND {$table}.n_givn LIKE CONCAT('%', ?, '%')";
1070 1070
                                     $bind[] = $field_value;
1071 1071
                                 }
1072 1072
                                 break;
@@ -1083,7 +1083,7 @@  discard block
 block discarded – undo
1083 1083
                                     break;
1084 1084
                                 } else {
1085 1085
                                     // No phonetic content? Use a substring match
1086
-                                    $sql    .= " AND {$table}.n_givn LIKE CONCAT('%', ?, '%')";
1086
+                                    $sql .= " AND {$table}.n_givn LIKE CONCAT('%', ?, '%')";
1087 1087
                                     $bind[] = $field_value;
1088 1088
                                 }
1089 1089
                         }
@@ -1091,15 +1091,15 @@  discard block
 block discarded – undo
1091 1091
                     case 'SURN':
1092 1092
                         switch ($modifiers[$field_name]) {
1093 1093
                             case 'EXACT':
1094
-                                $sql    .= " AND {$table}.n_surname=?";
1094
+                                $sql .= " AND {$table}.n_surname=?";
1095 1095
                                 $bind[] = $field_value;
1096 1096
                                 break;
1097 1097
                             case 'BEGINS':
1098
-                                $sql    .= " AND {$table}.n_surname LIKE CONCAT(?, '%')";
1098
+                                $sql .= " AND {$table}.n_surname LIKE CONCAT(?, '%')";
1099 1099
                                 $bind[] = $field_value;
1100 1100
                                 break;
1101 1101
                             case 'CONTAINS':
1102
-                                $sql    .= " AND {$table}.n_surname LIKE CONCAT('%', ?, '%')";
1102
+                                $sql .= " AND {$table}.n_surname LIKE CONCAT('%', ?, '%')";
1103 1103
                                 $bind[] = $field_value;
1104 1104
                                 break;
1105 1105
                             case 'SDX_STD':
@@ -1113,7 +1113,7 @@  discard block
 block discarded – undo
1113 1113
                                     $sql .= ' AND (' . implode(' OR ', $sdx) . ')';
1114 1114
                                 } else {
1115 1115
                                     // No phonetic content? Use a substring match
1116
-                                    $sql    .= " AND {$table}.n_surn LIKE CONCAT('%', ?, '%')";
1116
+                                    $sql .= " AND {$table}.n_surn LIKE CONCAT('%', ?, '%')";
1117 1117
                                     $bind[] = $field_value;
1118 1118
                                 }
1119 1119
                                 break;
@@ -1129,7 +1129,7 @@  discard block
 block discarded – undo
1129 1129
                                     $sql .= ' AND (' . implode(' OR ', $sdx) . ')';
1130 1130
                                 } else {
1131 1131
                                     // No phonetic content? Use a substring match
1132
-                                    $sql    .= " AND {$table}.n_surn LIKE CONCAT('%', ?, '%')";
1132
+                                    $sql .= " AND {$table}.n_surn LIKE CONCAT('%', ?, '%')";
1133 1133
                                     $bind[] = $field_value;
1134 1134
                                 }
1135 1135
                                 break;
@@ -1138,17 +1138,17 @@  discard block
 block discarded – undo
1138 1138
                 }
1139 1139
             } elseif ($parts[0] === 'FAMS') {
1140 1140
                 // e.g. searches for occupation, religion, note, etc.
1141
-                $sql    .= " AND fam.f_gedcom REGEXP CONCAT('\n[0-9] ', ?, '(.*\n[0-9] CONT)* [^\n]*', ?)";
1141
+                $sql .= " AND fam.f_gedcom REGEXP CONCAT('\n[0-9] ', ?, '(.*\n[0-9] CONT)* [^\n]*', ?)";
1142 1142
                 $bind[] = $parts[1];
1143 1143
                 $bind[] = $field_value;
1144 1144
             } elseif ($parts[1] === 'TYPE') {
1145 1145
                 // e.g. FACT:TYPE or EVEN:TYPE
1146
-                $sql    .= " AND ind.i_gedcom REGEXP CONCAT('\n1 ', ?, '.*(\n[2-9] .*)*\n2 TYPE .*', ?)";
1146
+                $sql .= " AND ind.i_gedcom REGEXP CONCAT('\n1 ', ?, '.*(\n[2-9] .*)*\n2 TYPE .*', ?)";
1147 1147
                 $bind[] = $parts[0];
1148 1148
                 $bind[] = $field_value;
1149 1149
             } else {
1150 1150
                 // e.g. searches for occupation, religion, note, etc.
1151
-                $sql    .= " AND ind.i_gedcom REGEXP CONCAT('\n[0-9] ', ?, '(.*\n[0-9] CONT)* [^\n]*', ?)";
1151
+                $sql .= " AND ind.i_gedcom REGEXP CONCAT('\n[0-9] ', ?, '(.*\n[0-9] CONT)* [^\n]*', ?)";
1152 1152
                 $bind[] = $parts[0];
1153 1153
                 $bind[] = $field_value;
1154 1154
             }
@@ -1227,7 +1227,7 @@  discard block
 block discarded – undo
1227 1227
         $sql .= ")";
1228 1228
 
1229 1229
         if ($givn_sdx !== '') {
1230
-            $sql      .= " AND (";
1230
+            $sql .= " AND (";
1231 1231
             $givn_sdx = explode(':', $givn_sdx);
1232 1232
             foreach ($givn_sdx as $n => $sdx) {
1233 1233
                 $sql .= $n > 0 ? " OR " : "";
@@ -1245,7 +1245,7 @@  discard block
 block discarded – undo
1245 1245
         }
1246 1246
 
1247 1247
         if ($surn_sdx !== '') {
1248
-            $sql      .= " AND (";
1248
+            $sql .= " AND (";
1249 1249
             $surn_sdx = explode(':', $surn_sdx);
1250 1250
             foreach ($surn_sdx as $n => $sdx) {
1251 1251
                 $sql .= $n ? " OR " : "";
@@ -1263,7 +1263,7 @@  discard block
 block discarded – undo
1263 1263
         }
1264 1264
 
1265 1265
         if ($plac_sdx !== '') {
1266
-            $sql      .= " AND (";
1266
+            $sql .= " AND (";
1267 1267
             $plac_sdx = explode(':', $plac_sdx);
1268 1268
             foreach ($plac_sdx as $n => $sdx) {
1269 1269
                 $sql .= $n ? " OR " : "";
@@ -1310,7 +1310,7 @@  discard block
 block discarded – undo
1310 1310
 
1311 1311
         foreach ($search_terms as $n => $q) {
1312 1312
             $queryregex[]          = preg_quote(I18N::strtoupper($q), '/');
1313
-            $sql                   .= " AND o_gedcom COLLATE :collate_" . $n . " LIKE CONCAT('%', :query_" . $n . ", '%')";
1313
+            $sql .= " AND o_gedcom COLLATE :collate_" . $n . " LIKE CONCAT('%', :query_" . $n . ", '%')";
1314 1314
             $args['collate_' . $n] = I18N::collation();
1315 1315
             $args['query_' . $n]   = Database::escapeLike($q);
1316 1316
         }
@@ -1366,7 +1366,7 @@  discard block
 block discarded – undo
1366 1366
 
1367 1367
         foreach ($search_terms as $n => $q) {
1368 1368
             $queryregex[]          = preg_quote(I18N::strtoupper($q), '/');
1369
-            $sql                   .= " AND o_gedcom COLLATE :collate_" . $n . " LIKE CONCAT('%', :query_" . $n . ", '%')";
1369
+            $sql .= " AND o_gedcom COLLATE :collate_" . $n . " LIKE CONCAT('%', :query_" . $n . ", '%')";
1370 1370
             $args['collate_' . $n] = I18N::collation();
1371 1371
             $args['query_' . $n]   = Database::escapeLike($q);
1372 1372
         }
@@ -1422,7 +1422,7 @@  discard block
 block discarded – undo
1422 1422
 
1423 1423
         foreach ($search_terms as $n => $q) {
1424 1424
             $queryregex[]          = preg_quote(I18N::strtoupper($q), '/');
1425
-            $sql                   .= " AND s_gedcom COLLATE :collate_" . $n . " LIKE CONCAT('%', :query_" . $n . ", '%')";
1425
+            $sql .= " AND s_gedcom COLLATE :collate_" . $n . " LIKE CONCAT('%', :query_" . $n . ", '%')";
1426 1426
             $args['collate_' . $n] = I18N::collation();
1427 1427
             $args['query_' . $n]   = Database::escapeLike($q);
1428 1428
         }
Please login to merge, or discard this patch.
app/Http/Controllers/ReportEngineController.php 1 patch
Spacing   +4 added lines, -4 removed lines patch added patch discarded remove patch
@@ -115,7 +115,7 @@  discard block
 block discarded – undo
115 115
                     $input['control'] = FunctionsEdit::formControlSource($tree, $source, $attributes + ['required' => 'true']);
116 116
                     break;
117 117
                 case 'DATE':
118
-                    $attributes       += [
118
+                    $attributes += [
119 119
                         'type'  => 'text',
120 120
                         'value' => $input['default'],
121 121
                     ];
@@ -129,16 +129,16 @@  discard block
 block discarded – undo
129 129
                 default:
130 130
                     switch ($input['type']) {
131 131
                         case 'text':
132
-                            $attributes       += [
132
+                            $attributes += [
133 133
                                 'type'  => 'text',
134 134
                                 'value' => $input['default'],
135 135
                             ];
136 136
                             $input['control'] = '<input ' . Html::attributes($attributes) . '>';
137 137
                             break;
138 138
                         case 'checkbox':
139
-                            $attributes       += [
139
+                            $attributes += [
140 140
                                 'type'    => 'checkbox',
141
-                                'checked' => (bool)$input['default'],
141
+                                'checked' => (bool) $input['default'],
142 142
                             ];
143 143
                             $input['control'] = '<input ' . Html::attributes($attributes) . '>';
144 144
                             break;
Please login to merge, or discard this patch.