@@ -145,7 +145,7 @@ discard block |
||
145 | 145 | 'ged' => $tree->name(), |
146 | 146 | 'show_all' => 'yes', |
147 | 147 | ]; |
148 | - $show = $request->get('show', 'surn'); |
|
148 | + $show = $request->get('show', 'surn'); |
|
149 | 149 | } |
150 | 150 | } elseif ($surname) { |
151 | 151 | $alpha = $this->localization_service->initialLetter($surname); // so we can highlight the initial letter |
@@ -520,7 +520,7 @@ discard block |
||
520 | 520 | private function allMedia(Tree $tree, string $folder, string $subfolders, string $sort, string $filter, string $form_type): array |
521 | 521 | { |
522 | 522 | // All files in the folder, plus external files |
523 | - $sql = |
|
523 | + $sql = |
|
524 | 524 | "SELECT m_id AS xref, m_gedcom AS gedcom" . |
525 | 525 | " FROM `##media`" . |
526 | 526 | " JOIN `##media_file` USING (m_id, m_file)" . |
@@ -539,11 +539,11 @@ discard block |
||
539 | 539 | // Include / exclude subfolders (but always include external) |
540 | 540 | switch ($subfolders) { |
541 | 541 | case 'include': |
542 | - $sql .= " AND (multimedia_file_refn LIKE CONCAT(?, '%') $sql_external)"; |
|
542 | + $sql .= " AND (multimedia_file_refn LIKE CONCAT(?, '%') $sql_external)"; |
|
543 | 543 | $args[] = Database::escapeLike($folder); |
544 | 544 | break; |
545 | 545 | case 'exclude': |
546 | - $sql .= " AND (multimedia_file_refn LIKE CONCAT(?, '%') AND multimedia_file_refn NOT LIKE CONCAT(?, '%/%') $sql_external)"; |
|
546 | + $sql .= " AND (multimedia_file_refn LIKE CONCAT(?, '%') AND multimedia_file_refn NOT LIKE CONCAT(?, '%/%') $sql_external)"; |
|
547 | 547 | $args[] = Database::escapeLike($folder); |
548 | 548 | $args[] = Database::escapeLike($folder); |
549 | 549 | break; |
@@ -551,13 +551,13 @@ discard block |
||
551 | 551 | |
552 | 552 | // Apply search terms |
553 | 553 | if ($filter) { |
554 | - $sql .= " AND (SUBSTRING_INDEX(multimedia_file_refn, '/', -1) LIKE CONCAT('%', ?, '%') OR descriptive_title LIKE CONCAT('%', ?, '%'))"; |
|
554 | + $sql .= " AND (SUBSTRING_INDEX(multimedia_file_refn, '/', -1) LIKE CONCAT('%', ?, '%') OR descriptive_title LIKE CONCAT('%', ?, '%'))"; |
|
555 | 555 | $args[] = Database::escapeLike($filter); |
556 | 556 | $args[] = Database::escapeLike($filter); |
557 | 557 | } |
558 | 558 | |
559 | 559 | if ($form_type) { |
560 | - $sql .= " AND source_media_type = ?"; |
|
560 | + $sql .= " AND source_media_type = ?"; |
|
561 | 561 | $args[] = $form_type; |
562 | 562 | } |
563 | 563 |
@@ -219,7 +219,8 @@ discard block |
||
219 | 219 | <li class="wt-initials-list-item d-flex"> |
220 | 220 | <?php if ($count > 0) : ?> |
221 | 221 | <a href="<?= e(route($route, ['alpha' => $letter, 'ged' => $tree->name()])) ?>" class="wt-initial<?= $letter === $alpha ? ' active' : '' ?> '" title="<?= I18N::number($count) ?>"><?= $this->surnameInitial((string) $letter) ?></a> |
222 | - <?php else : ?> |
|
222 | + <?php else { |
|
223 | + : ?> |
|
223 | 224 | <span class="wt-initial text-muted"><?= $this->surnameInitial((string) $letter) ?></span> |
224 | 225 | |
225 | 226 | <?php endif ?> |
@@ -273,6 +274,7 @@ discard block |
||
273 | 274 | |
274 | 275 | if ($show === 'indi' || $show === 'surn') { |
275 | 276 | $surns = $this->individual_list_service->surnames($surname, $alpha, $show_marnm === 'yes', $families, WT_LOCALE, I18N::collation()); |
277 | +} |
|
276 | 278 | if ($show === 'surn') { |
277 | 279 | // Show the surname list |
278 | 280 | switch ($tree->getPreference('SURNAME_LIST_STYLE')) { |
@@ -70,7 +70,7 @@ |
||
70 | 70 | |
71 | 71 | $top10 = DB::table('hit_counter') |
72 | 72 | ->where('gedcom_id', '=', $tree->id()) |
73 | - ->whereIn('page_name', ['individual.php','family.php','source.php','repo.php','note.php','mediaviewer.php']) |
|
73 | + ->whereIn('page_name', ['individual.php', 'family.php', 'source.php', 'repo.php', 'note.php', 'mediaviewer.php']) |
|
74 | 74 | ->orderByDesc('page_count') |
75 | 75 | ->limit((int) $num) |
76 | 76 | ->pluck('page_count', 'page_parameter'); |
@@ -103,7 +103,7 @@ |
||
103 | 103 | $pages = []; |
104 | 104 | |
105 | 105 | // Escape the query for MySQL and PHP, converting spaces to wildcards. |
106 | - $like_query = strtr($query, [ |
|
106 | + $like_query = strtr($query, [ |
|
107 | 107 | '_' => '\\_', |
108 | 108 | '%' => '\\%', |
109 | 109 | ' ' => '%', |
@@ -185,15 +185,15 @@ |
||
185 | 185 | } |
186 | 186 | |
187 | 187 | /** |
188 | - * Search for sources by name. |
|
189 | - * |
|
190 | - * @param Tree $tree |
|
191 | - * @param string $search |
|
192 | - * @param int $offset |
|
193 | - * @param int $limit |
|
194 | - * |
|
195 | - * @return Collection|Source[] |
|
196 | - */ |
|
188 | + * Search for sources by name. |
|
189 | + * |
|
190 | + * @param Tree $tree |
|
191 | + * @param string $search |
|
192 | + * @param int $offset |
|
193 | + * @param int $limit |
|
194 | + * |
|
195 | + * @return Collection|Source[] |
|
196 | + */ |
|
197 | 197 | public function searchSourcesByName(Tree $tree, string $search, int $offset = 0, int $limit = PHP_INT_MAX): Collection |
198 | 198 | { |
199 | 199 | $query = DB::table('sources') |