@@ -745,7 +745,7 @@ discard block |
||
745 | 745 | * @return Response |
746 | 746 | */ |
747 | 747 | public function changesLogData(Request $request): Response { |
748 | - list($select, , $where, $args1) = $this->changesQuery($request); |
|
748 | + list($select,, $where, $args1) = $this->changesQuery($request); |
|
749 | 749 | list($order_by, $limit, $args2) = $this->dataTablesPagination($request); |
750 | 750 | |
751 | 751 | $rows = Database::prepare( |
@@ -819,7 +819,7 @@ discard block |
||
819 | 819 | * @return Response |
820 | 820 | */ |
821 | 821 | public function changesLogDownload(Request $request): Response { |
822 | - list($select, , $where, $args) = $this->changesQuery($request); |
|
822 | + list($select,, $where, $args) = $this->changesQuery($request); |
|
823 | 823 | |
824 | 824 | $rows = Database::prepare($select . $where)->execute($args)->fetchAll(); |
825 | 825 | |
@@ -970,7 +970,7 @@ discard block |
||
970 | 970 | $args = []; |
971 | 971 | |
972 | 972 | if ($search !== '') { |
973 | - $where .= " AND (multimedia_file_refn LIKE CONCAT('%', :search1, '%') OR multimedia_file_refn LIKE CONCAT('%', :search2, '%'))"; |
|
973 | + $where .= " AND (multimedia_file_refn LIKE CONCAT('%', :search1, '%') OR multimedia_file_refn LIKE CONCAT('%', :search2, '%'))"; |
|
974 | 974 | $args['search1'] = $search; |
975 | 975 | $args['search2'] = $search; |
976 | 976 | } |
@@ -1151,7 +1151,7 @@ discard block |
||
1151 | 1151 | $data = array_map(function (string $thumbnail) { |
1152 | 1152 | $original = $this->findOriginalFileFromThumbnail($thumbnail); |
1153 | 1153 | |
1154 | - $original_url = route('unused-media-thumbnail', [ |
|
1154 | + $original_url = route('unused-media-thumbnail', [ |
|
1155 | 1155 | 'folder' => dirname($original), |
1156 | 1156 | 'file' => basename($original), |
1157 | 1157 | 'w' => 100, |
@@ -1691,36 +1691,36 @@ discard block |
||
1691 | 1691 | $where = ' WHERE 1'; |
1692 | 1692 | $args = []; |
1693 | 1693 | if ($search !== '') { |
1694 | - $where .= " AND (old_gedcom LIKE CONCAT('%', :search_1, '%') OR new_gedcom LIKE CONCAT('%', :search_2, '%'))"; |
|
1694 | + $where .= " AND (old_gedcom LIKE CONCAT('%', :search_1, '%') OR new_gedcom LIKE CONCAT('%', :search_2, '%'))"; |
|
1695 | 1695 | $args['search_1'] = $search; |
1696 | 1696 | $args['search_2'] = $search; |
1697 | 1697 | } |
1698 | 1698 | if ($from !== '') { |
1699 | - $where .= " AND change_time >= :from"; |
|
1699 | + $where .= " AND change_time >= :from"; |
|
1700 | 1700 | $args['from'] = $from; |
1701 | 1701 | } |
1702 | 1702 | if ($to !== '') { |
1703 | - $where .= ' AND change_time < TIMESTAMPADD(DAY, 1 , :to)'; // before end of the day |
|
1703 | + $where .= ' AND change_time < TIMESTAMPADD(DAY, 1 , :to)'; // before end of the day |
|
1704 | 1704 | $args['to'] = $to; |
1705 | 1705 | } |
1706 | 1706 | if ($type !== '') { |
1707 | - $where .= ' AND status = :status'; |
|
1707 | + $where .= ' AND status = :status'; |
|
1708 | 1708 | $args['status'] = $type; |
1709 | 1709 | } |
1710 | 1710 | if ($oldged !== '') { |
1711 | - $where .= " AND old_gedcom LIKE CONCAT('%', :old_ged, '%')"; |
|
1711 | + $where .= " AND old_gedcom LIKE CONCAT('%', :old_ged, '%')"; |
|
1712 | 1712 | $args['old_ged'] = $oldged; |
1713 | 1713 | } |
1714 | 1714 | if ($newged !== '') { |
1715 | - $where .= " AND new_gedcom LIKE CONCAT('%', :new_ged, '%')"; |
|
1715 | + $where .= " AND new_gedcom LIKE CONCAT('%', :new_ged, '%')"; |
|
1716 | 1716 | $args['new_ged'] = $newged; |
1717 | 1717 | } |
1718 | 1718 | if ($xref !== '') { |
1719 | - $where .= " AND xref = :xref"; |
|
1719 | + $where .= " AND xref = :xref"; |
|
1720 | 1720 | $args['xref'] = $xref; |
1721 | 1721 | } |
1722 | 1722 | if ($username !== '') { |
1723 | - $where .= " AND user_name LIKE CONCAT('%', :user, '%')"; |
|
1723 | + $where .= " AND user_name LIKE CONCAT('%', :user, '%')"; |
|
1724 | 1724 | $args['user'] = $username; |
1725 | 1725 | } |
1726 | 1726 | if ($ged !== '') { |
@@ -68,7 +68,7 @@ |
||
68 | 68 | if ($individual !== null) { |
69 | 69 | $xrefs[] = $addxref; |
70 | 70 | if ($addfam) { |
71 | - $xrefs = array_merge($xrefs, $this->closeFamily($individual)); |
|
71 | + $xrefs = array_merge($xrefs, $this->closeFamily($individual)); |
|
72 | 72 | } |
73 | 73 | } |
74 | 74 |
@@ -366,7 +366,7 @@ discard block |
||
366 | 366 | $html = sprintf('<div id="childarrow"><a href="#" class="menuselect %s"></a><div id="childbox-pedigree">', $this->arrows->menu); |
367 | 367 | |
368 | 368 | foreach ($families as $family) { |
369 | - $html .= '<span class="name1">' . I18N::translate('Family') . '</span>'; |
|
369 | + $html .= '<span class="name1">' . I18N::translate('Family') . '</span>'; |
|
370 | 370 | $spouse = $family->getSpouse($this->root); |
371 | 371 | if ($spouse) { |
372 | 372 | $html .= '<a class="name1" href="' . e(route('pedigree', [ |
@@ -426,7 +426,7 @@ discard block |
||
426 | 426 | $html = ''; |
427 | 427 | if ($this->chartHasAncestors) { |
428 | 428 | if ($this->nodes[$index]['indi'] && $this->nodes[$index]['indi']->getChildFamilies()) { |
429 | - $html .= '<div class="ancestorarrow">'; |
|
429 | + $html .= '<div class="ancestorarrow">'; |
|
430 | 430 | $rootParentId = 1; |
431 | 431 | if ($index > (int) ($this->treesize / 2) + (int) ($this->treesize / 4)) { |
432 | 432 | $rootParentId++; |
@@ -130,7 +130,7 @@ |
||
130 | 130 | ->setPreference('TIMEZONE', $time_zone) |
131 | 131 | ->setPreference('visibleonline', $visible_online); |
132 | 132 | |
133 | - $tree->setUserPreference($user,'rootid', $rootid); |
|
133 | + $tree->setUserPreference($user, 'rootid', $rootid); |
|
134 | 134 | |
135 | 135 | // Switch to the new theme now |
136 | 136 | Session::put('theme_id', $theme); |
@@ -58,7 +58,7 @@ discard block |
||
58 | 58 | $maximum_generations = (int) $tree->getPreference('MAX_DESCENDANCY_GENERATIONS', self::DEFAULT_MAXIMUM_GENERATIONS); |
59 | 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); |
@@ -220,7 +220,7 @@ discard block |
||
220 | 220 | echo '<table cellspacing="0" cellpadding="0" border="0" style="position: relative; top: auto; float: ' . $tablealign . ';">'; |
221 | 221 | for ($i = 0; $i < $ct; $i++) { |
222 | 222 | $individual2 = $children[$i]; |
223 | - $chil = $individual2->getXref(); |
|
223 | + $chil = $individual2->getXref(); |
|
224 | 224 | echo '<tr>'; |
225 | 225 | echo '<td id="td_', e($chil), '" class="', I18N::direction(), '" style="text-align:', $otablealign, '">'; |
226 | 226 | $this->printDescendency($individual2, $generation + 1, $generations, $show_spouse, false); |
@@ -116,18 +116,18 @@ |
||
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 | /** |
@@ -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 |
@@ -105,7 +105,7 @@ discard block |
||
105 | 105 | $recursion = (int) $request->get('recursion', '0'); |
106 | 106 | $ancestors = (bool) $request->get('ancestors', '0'); |
107 | 107 | |
108 | - $max_recursion = (int) $tree->getPreference('RELATIONSHIP_RECURSION', RelationshipsChartModule::DEFAULT_RECURSION); |
|
108 | + $max_recursion = (int) $tree->getPreference('RELATIONSHIP_RECURSION', RelationshipsChartModule::DEFAULT_RECURSION); |
|
109 | 109 | |
110 | 110 | $recursion = min($recursion, $max_recursion); |
111 | 111 | |
@@ -153,14 +153,14 @@ discard block |
||
153 | 153 | case 'sis': |
154 | 154 | case 'sib': |
155 | 155 | $table[$x + 1][$y] = '<div style="background:url(' . Theme::theme()->parameter('image-hline') . ') repeat-x center; width: 94px; text-align: center"><div class="hline-text" style="height: 32px;">' . Functions::getRelationshipNameFromPath($relationships[$n], Individual::getInstance($path[$n - 1], $tree), Individual::getInstance($path[$n + 1], $tree)) . '</div><div style="height: 32px;">' . FontAwesome::decorativeIcon('arrow-end') . '</div></div>'; |
156 | - $x += 2; |
|
156 | + $x += 2; |
|
157 | 157 | break; |
158 | 158 | case 'son': |
159 | 159 | case 'dau': |
160 | 160 | case 'chi': |
161 | 161 | if ($n > 2 && preg_match('/fat|mot|par/', $relationships[$n - 2])) { |
162 | 162 | $table[$x + 1][$y - 1] = '<div style="background:url(' . $diagonal2 . '); width: 64px; height: 64px; text-align: center;"><div style="height: 32px; text-align: end;">' . Functions::getRelationshipNameFromPath($relationships[$n], Individual::getInstance($path[$n - 1], $tree), Individual::getInstance($path[$n + 1], $tree)) . '</div><div style="height: 32px; text-align: start;">' . FontAwesome::decorativeIcon('arrow-down') . '</div></div>'; |
163 | - $x += 2; |
|
163 | + $x += 2; |
|
164 | 164 | } else { |
165 | 165 | $table[$x][$y - 1] = '<div style="background:url(' . Theme::theme() |
166 | 166 | ->parameter('image-vline') . ') repeat-y center; height: 64px; text-align: center;"><div class="vline-text" style="display: inline-block; width:50%; line-height: 64px;">' . Functions::getRelationshipNameFromPath($relationships[$n], Individual::getInstance($path[$n - 1], $tree), Individual::getInstance($path[$n + 1], $tree)) . '</div><div style="display: inline-block; width:50%; line-height: 64px;">' . FontAwesome::decorativeIcon('arrow-down') . '</div></div>'; |
@@ -172,7 +172,7 @@ discard block |
||
172 | 172 | case 'par': |
173 | 173 | if ($n > 2 && preg_match('/son|dau|chi/', $relationships[$n - 2])) { |
174 | 174 | $table[$x + 1][$y + 1] = '<div style="background:url(' . $diagonal1 . '); background-position: top right; width: 64px; height: 64px; text-align: center;"><div style="height: 32px; text-align: start;">' . Functions::getRelationshipNameFromPath($relationships[$n], Individual::getInstance($path[$n - 1], $tree), Individual::getInstance($path[$n + 1], $tree)) . '</div><div style="height: 32px; text-align: end;">' . FontAwesome::decorativeIcon('arrow-down') . '</div></div>'; |
175 | - $x += 2; |
|
175 | + $x += 2; |
|
176 | 176 | } else { |
177 | 177 | $table[$x][$y + 1] = '<div style="background:url(' . Theme::theme() |
178 | 178 | ->parameter('image-vline') . ') repeat-y center; height: 64px; text-align:center; "><div class="vline-text" style="display: inline-block; width: 50%; line-height: 32px;">' . Functions::getRelationshipNameFromPath($relationships[$n], Individual::getInstance($path[$n - 1], $tree), Individual::getInstance($path[$n + 1], $tree)) . '</div><div style="display: inline-block; width: 50%; line-height: 32px">' . FontAwesome::decorativeIcon('arrow-up') . '</div></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; |
19 | 19 |