@@ -13,7 +13,7 @@ discard block |
||
13 | 13 | * You should have received a copy of the GNU General Public License |
14 | 14 | * along with this program. If not, see <http://www.gnu.org/licenses/>. |
15 | 15 | */ |
16 | -declare(strict_types=1); |
|
16 | +declare(strict_types = 1); |
|
17 | 17 | |
18 | 18 | namespace Fisharebest\Webtrees\Http\Controllers; |
19 | 19 | |
@@ -287,7 +287,7 @@ discard block |
||
287 | 287 | } |
288 | 288 | // Don't sublists short lists. |
289 | 289 | if ($count < $tree->getPreference('SUBLIST_TRIGGER_I')) { |
290 | - $falpha = ''; |
|
290 | + $falpha = ''; |
|
291 | 291 | } else { |
292 | 292 | $givn_initials = $this->givenAlpha($surname, $alpha, $show_marnm === 'yes', $families); |
293 | 293 | // Break long lists by initial letter of given name |
@@ -508,7 +508,7 @@ discard block |
||
508 | 508 | */ |
509 | 509 | private function allMedia(Tree $tree, string $folder, string $subfolders, string $sort, string $filter, string $form_type): array { |
510 | 510 | // All files in the folder, plus external files |
511 | - $sql = |
|
511 | + $sql = |
|
512 | 512 | "SELECT m_id AS xref, m_gedcom AS gedcom" . |
513 | 513 | " FROM `##media`" . |
514 | 514 | " JOIN `##media_file` USING (m_id, m_file)" . |
@@ -527,11 +527,11 @@ discard block |
||
527 | 527 | // Include / exclude subfolders (but always include external) |
528 | 528 | switch ($subfolders) { |
529 | 529 | case 'include': |
530 | - $sql .= " AND (multimedia_file_refn LIKE CONCAT(?, '%') $sql_external)"; |
|
530 | + $sql .= " AND (multimedia_file_refn LIKE CONCAT(?, '%') $sql_external)"; |
|
531 | 531 | $args[] = Database::escapeLike($folder); |
532 | 532 | break; |
533 | 533 | case 'exclude': |
534 | - $sql .= " AND (multimedia_file_refn LIKE CONCAT(?, '%') AND multimedia_file_refn NOT LIKE CONCAT(?, '%/%') $sql_external)"; |
|
534 | + $sql .= " AND (multimedia_file_refn LIKE CONCAT(?, '%') AND multimedia_file_refn NOT LIKE CONCAT(?, '%/%') $sql_external)"; |
|
535 | 535 | $args[] = Database::escapeLike($folder); |
536 | 536 | $args[] = Database::escapeLike($folder); |
537 | 537 | break; |
@@ -539,13 +539,13 @@ discard block |
||
539 | 539 | |
540 | 540 | // Apply search terms |
541 | 541 | if ($filter) { |
542 | - $sql .= " AND (SUBSTRING_INDEX(multimedia_file_refn, '/', -1) LIKE CONCAT('%', ?, '%') OR descriptive_title LIKE CONCAT('%', ?, '%'))"; |
|
542 | + $sql .= " AND (SUBSTRING_INDEX(multimedia_file_refn, '/', -1) LIKE CONCAT('%', ?, '%') OR descriptive_title LIKE CONCAT('%', ?, '%'))"; |
|
543 | 543 | $args[] = Database::escapeLike($filter); |
544 | 544 | $args[] = Database::escapeLike($filter); |
545 | 545 | } |
546 | 546 | |
547 | 547 | if ($form_type) { |
548 | - $sql .= " AND source_media_type = ?"; |
|
548 | + $sql .= " AND source_media_type = ?"; |
|
549 | 549 | $args[] = $form_type; |
550 | 550 | } |
551 | 551 | |
@@ -1457,7 +1457,7 @@ discard block |
||
1457 | 1457 | ]; |
1458 | 1458 | |
1459 | 1459 | foreach ($this->getAlphabetForLocale(WT_LOCALE) as $n => $letter) { |
1460 | - $sql .= " AND n_surn COLLATE :collate_" . $n . " NOT LIKE :letter_" . $n; |
|
1460 | + $sql .= " AND n_surn COLLATE :collate_" . $n . " NOT LIKE :letter_" . $n; |
|
1461 | 1461 | $args['collate_' . $n] = I18N::collation(); |
1462 | 1462 | $args['letter_' . $n] = $letter . '%'; |
1463 | 1463 | } |
@@ -1542,7 +1542,7 @@ discard block |
||
1542 | 1542 | ]; |
1543 | 1543 | |
1544 | 1544 | if ($surn) { |
1545 | - $sql .= " AND n_surn COLLATE :collate_1 = :surn"; |
|
1545 | + $sql .= " AND n_surn COLLATE :collate_1 = :surn"; |
|
1546 | 1546 | $args['collate_1'] = I18N::collation(); |
1547 | 1547 | $args['surn'] = $surn; |
1548 | 1548 | } elseif ($salpha === ',') { |
@@ -1593,7 +1593,7 @@ discard block |
||
1593 | 1593 | ]; |
1594 | 1594 | |
1595 | 1595 | if ($surn) { |
1596 | - $sql .= " AND n_surn COLLATE :collate_1 = :surn"; |
|
1596 | + $sql .= " AND n_surn COLLATE :collate_1 = :surn"; |
|
1597 | 1597 | $args['collate_1'] = I18N::collation(); |
1598 | 1598 | $args['surn'] = $surn; |
1599 | 1599 | } elseif ($salpha === ',') { |
@@ -1606,7 +1606,7 @@ discard block |
||
1606 | 1606 | // All surnames |
1607 | 1607 | $sql .= " AND n_surn NOT IN ('', '@N.N.')"; |
1608 | 1608 | } |
1609 | - $sql .= " GROUP BY n_surn COLLATE :collate_2, n_file) AS n2 ON (n1.n_surn = n2.n_surn COLLATE :collate_3 AND n1.n_file = n2.n_file)"; |
|
1609 | + $sql .= " GROUP BY n_surn COLLATE :collate_2, n_file) AS n2 ON (n1.n_surn = n2.n_surn COLLATE :collate_3 AND n1.n_file = n2.n_file)"; |
|
1610 | 1610 | $args['collate_2'] = I18N::collation(); |
1611 | 1611 | $args['collate_3'] = I18N::collation(); |
1612 | 1612 | |
@@ -1646,7 +1646,7 @@ discard block |
||
1646 | 1646 | ]; |
1647 | 1647 | |
1648 | 1648 | if ($surn) { |
1649 | - $sql .= " AND n_surn COLLATE :collate_1 = :surn"; |
|
1649 | + $sql .= " AND n_surn COLLATE :collate_1 = :surn"; |
|
1650 | 1650 | $args['collate_1'] = I18N::collation(); |
1651 | 1651 | $args['surn'] = $surn; |
1652 | 1652 | } elseif ($salpha === ',') { |
@@ -1663,7 +1663,7 @@ discard block |
||
1663 | 1663 | $sql .= " AND " . $this->getInitialSql('n_givn', $galpha); |
1664 | 1664 | } |
1665 | 1665 | |
1666 | - $sql .= " ORDER BY CASE n_surn WHEN '@N.N.' THEN 1 ELSE 0 END, n_surn COLLATE :collate_2, CASE n_givn WHEN '@P.N.' THEN 1 ELSE 0 END, n_givn COLLATE :collate_3"; |
|
1666 | + $sql .= " ORDER BY CASE n_surn WHEN '@N.N.' THEN 1 ELSE 0 END, n_surn COLLATE :collate_2, CASE n_givn WHEN '@P.N.' THEN 1 ELSE 0 END, n_givn COLLATE :collate_3"; |
|
1667 | 1667 | $args['collate_2'] = I18N::collation(); |
1668 | 1668 | $args['collate_3'] = I18N::collation(); |
1669 | 1669 |
@@ -13,7 +13,7 @@ discard block |
||
13 | 13 | * You should have received a copy of the GNU General Public License |
14 | 14 | * along with this program. If not, see <http://www.gnu.org/licenses/>. |
15 | 15 | */ |
16 | - declare(strict_types=1); |
|
16 | + declare(strict_types = 1); |
|
17 | 17 | |
18 | 18 | namespace Fisharebest\Webtrees\Http\Controllers; |
19 | 19 | |
@@ -116,18 +116,18 @@ discard block |
||
116 | 116 | ]; |
117 | 117 | |
118 | 118 | const DMY_SHORTCUTS = [ |
119 | - '11 DEC 1913' => ['11/12/1913', '11-12-1913', '11.12.1913',], |
|
120 | - '01 FEB 2003' => ['01/02/03', '01-02-03', '01.02.03',], |
|
119 | + '11 DEC 1913' => ['11/12/1913', '11-12-1913', '11.12.1913', ], |
|
120 | + '01 FEB 2003' => ['01/02/03', '01-02-03', '01.02.03', ], |
|
121 | 121 | ]; |
122 | 122 | |
123 | 123 | const MDY_SHORTCUTS = [ |
124 | - '11 DEC 1913' => ['12/11/1913', '12-11-1913', '12.11.1913',], |
|
125 | - '01 FEB 2003' => ['02/01/03', '02-01-03', '02.01.03',], |
|
124 | + '11 DEC 1913' => ['12/11/1913', '12-11-1913', '12.11.1913', ], |
|
125 | + '01 FEB 2003' => ['02/01/03', '02-01-03', '02.01.03', ], |
|
126 | 126 | ]; |
127 | 127 | |
128 | 128 | const YMD_SHORTCUTS = [ |
129 | - '11 DEC 1913' => ['11/12/1913', '11-12-1913', '11.12.1913',], |
|
130 | - '01 FEB 2003' => ['03/02/01', '03-02-01', '03.02.01',], |
|
129 | + '11 DEC 1913' => ['11/12/1913', '11-12-1913', '11.12.1913', ], |
|
130 | + '01 FEB 2003' => ['03/02/01', '03-02-01', '03.02.01', ], |
|
131 | 131 | ]; |
132 | 132 | |
133 | 133 | /** |
@@ -13,7 +13,7 @@ |
||
13 | 13 | * You should have received a copy of the GNU General Public License |
14 | 14 | * along with this program. If not, see <http://www.gnu.org/licenses/>. |
15 | 15 | */ |
16 | - declare(strict_types=1); |
|
16 | + declare(strict_types = 1); |
|
17 | 17 | |
18 | 18 | namespace Fisharebest\Webtrees\Http\Controllers; |
19 | 19 |
@@ -13,7 +13,7 @@ |
||
13 | 13 | * You should have received a copy of the GNU General Public License |
14 | 14 | * along with this program. If not, see <http://www.gnu.org/licenses/>. |
15 | 15 | */ |
16 | -declare(strict_types=1); |
|
16 | +declare(strict_types = 1); |
|
17 | 17 | |
18 | 18 | namespace Fisharebest\Webtrees\Http\Controllers; |
19 | 19 |
@@ -74,7 +74,7 @@ |
||
74 | 74 | <?php endforeach ?> |
75 | 75 | </td> |
76 | 76 | <td> |
77 | - <a href="<?= e(Html::url('message.php', ['to' => $record_change->user_name, 'subject' => I18N::translate('Pending changes') . ' - ' . strip_tags($record_change->record->getFullName()), 'body' => WT_BASE_URL . $record_change->record->url(), 'ged' => $record_change->gedcom_name,])) ?>" title="<?= I18N::translate('Send a message') ?>"> |
|
77 | + <a href="<?= e(Html::url('message.php', ['to' => $record_change->user_name, 'subject' => I18N::translate('Pending changes') . ' - ' . strip_tags($record_change->record->getFullName()), 'body' => WT_BASE_URL . $record_change->record->url(), 'ged' => $record_change->gedcom_name, ])) ?>" title="<?= I18N::translate('Send a message') ?>"> |
|
78 | 78 | <?= e($record_change->real_name) ?> - <?= e($record_change->user_name) ?> |
79 | 79 | </a> |
80 | 80 | </td> |
@@ -185,4 +185,4 @@ |
||
185 | 185 | </form> |
186 | 186 | |
187 | 187 | |
188 | -<div class="wt-ajax-load wt-page-content" data-ajax-url="<?= e(route('calendar-events', ['ged' => $tree->getName(), 'cal' => $cal, 'day' => $day, 'month' => $month, 'year' => $year, 'view' => $view, 'filterev' => $filterev, 'filterof' => $filterof, 'filtersx' => $filtersx,])) ?>"></div> |
|
188 | +<div class="wt-ajax-load wt-page-content" data-ajax-url="<?= e(route('calendar-events', ['ged' => $tree->getName(), 'cal' => $cal, 'day' => $day, 'month' => $month, 'year' => $year, 'view' => $view, 'filterev' => $filterev, 'filterof' => $filterof, 'filtersx' => $filtersx, ])) ?>"></div> |
@@ -13,7 +13,7 @@ |
||
13 | 13 | * You should have received a copy of the GNU General Public License |
14 | 14 | * along with this program. If not, see <http://www.gnu.org/licenses/>. |
15 | 15 | */ |
16 | -declare(strict_types=1); |
|
16 | +declare(strict_types = 1); |
|
17 | 17 | |
18 | 18 | namespace Fisharebest\Webtrees\Http\Controllers; |
19 | 19 |