Home
last modified time | relevance | path

Searched refs:Expression (Results 1 – 25 of 47) sorted by relevance

12

/webtrees/app/Http/RequestHandlers/
H A DRenumberTreeAction.php36 use Illuminate\Database\Query\Expression; alias
83 … 'i_gedcom' => new Expression("REPLACE(i_gedcom, '0 @$old_xref@ INDI', '0 @$new_xref@ INDI')"),
91 … 'f_gedcom' => new Expression("REPLACE(f_gedcom, ' HUSB @$old_xref@', ' HUSB @$new_xref@')"),
99 … 'f_gedcom' => new Expression("REPLACE(f_gedcom, ' WIFE @$old_xref@', ' WIFE @$new_xref@')"),
114 … 'f_gedcom' => new Expression("REPLACE(f_gedcom, ' $tag @$old_xref@', ' $tag @$new_xref@')"),
130 … 'i_gedcom' => new Expression("REPLACE(i_gedcom, ' $tag @$old_xref@', ' $tag @$new_xref@')"),
163 … 'f_gedcom' => new Expression("REPLACE(f_gedcom, '0 @$old_xref@ FAM', '0 @$new_xref@ FAM')"),
178 … 'i_gedcom' => new Expression("REPLACE(i_gedcom, ' $tag @$old_xref@', ' $tag @$new_xref@')"),
203 … 's_gedcom' => new Expression("REPLACE(s_gedcom, '0 @$old_xref@ SOUR', '0 @$new_xref@ SOUR')"),
216 … 'i_gedcom' => new Expression("REPLACE(i_gedcom, ' SOUR @$old_xref@', ' SOUR @$new_xref@')"),
[all …]
H A DMergeTreesAction.php31 use Illuminate\Database\Query\Expression; alias
80 new Expression($tree2->id()),
98 new Expression($tree2->id()),
115 new Expression($tree2->id()),
129 new Expression($tree2->id()),
145 new Expression($tree2->id()),
162 new Expression($tree2->id()),
187 new Expression($tree2->id()),
217 new Expression($tree2->id()),
238 new Expression($tree2->id()),
H A DControlPanel.php64 use Illuminate\Database\Query\Expression; alias
235 ->pluck(new Expression('COUNT(change_id) AS aggregate'), 'gedcom.gedcom_id')
250 ->pluck(new Expression('COUNT(i_id) AS aggregate'), 'gedcom_id')
264 ->pluck(new Expression('COUNT(f_id) AS aggregate'), 'gedcom_id')
278 ->pluck(new Expression('COUNT(s_id) AS aggregate'), 'gedcom_id')
292 ->pluck(new Expression('COUNT(m_id) AS aggregate'), 'gedcom_id')
310 ->pluck(new Expression('COUNT(o_id) AS aggregate'), 'gedcom_id')
328 ->pluck(new Expression('COUNT(o_id) AS aggregate'), 'gedcom_id')
346 ->pluck(new Expression('COUNT(o_id) AS aggregate'), 'gedcom_id')
H A DManageMediaData.php34 use Illuminate\Database\Query\Expression; alias
109 2 => new Expression('descriptive_title || multimedia_file_refn'),
178 new Expression("COALESCE(setting_value, 'media/') AS media_folder"),
181 …$query->where(new Expression('setting_value || multimedia_file_refn'), 'LIKE', $media_folder . '%'…
184 …$query->where(new Expression('setting_value || multimedia_file_refn'), 'NOT LIKE', $media_folder .…
205 new Expression("'' AS media_folder"),
H A DCheckTree.php56 use Illuminate\Database\Query\Expression; alias
110 ->select(['i_id AS xref', 'i_gedcom AS gedcom', new Expression("'INDI' AS type")]);
113 ->select(['f_id AS xref', 'f_gedcom AS gedcom', new Expression("'FAM' AS type")]);
116 ->select(['m_id AS xref', 'm_gedcom AS gedcom', new Expression("'OBJE' AS type")]);
119 ->select(['s_id AS xref', 's_gedcom AS gedcom', new Expression("'SOUR' AS type")]);
127 ->select(['xref', 'new_gedcom AS gedcom', new Expression("'' AS type")]);
/webtrees/app/Services/
H A DAdminService.php34 use Illuminate\Database\Query\Expression; alias
102 return DB::table(new Expression('(' . $subquery1->toSql() . ') AS sub1'))
122 ->having(new Expression('COUNT(s_id)'), '>', '1')
123 ->select([new Expression(DB::groupConcat('s_id') . ' AS xrefs')])
146 ->having(new Expression('COUNT(DISTINCT d_gid)'), '>', '1')
147 ->select([new Expression(DB::groupConcat('d_gid') . ' AS xrefs')])
157 ->groupBy([new Expression('LEAST(f_husb, f_wife)')])
158 ->groupBy([new Expression('GREATEST(f_husb, f_wife)')])
159 ->having(new Expression('COUNT(f_id)'), '>', '1')
160 ->select([new Expression(DB::groupConcat('f_id') . ' AS xrefs')])
[all …]
H A DMediaFileService.php29 use Illuminate\Database\Query\Expression; alias
314 … ->where(new Expression('setting_value || multimedia_file_refn'), 'LIKE', $media_folder . '%');
317 …$query->where(new Expression('setting_value || multimedia_file_refn'), 'NOT LIKE', $media_folder .…
321 ->orderBy(new Expression('setting_value || multimedia_file_refn'))
322 ->pluck(new Expression('setting_value || multimedia_file_refn AS path'));
363 … ->pluck(new Expression("COALESCE(setting_value, 'media/') || multimedia_file_refn AS path"))
373 ->pluck(new Expression("COALESCE(setting_value, 'media/') AS path"))
H A DGedcomExportService.php37 use Illuminate\Database\Query\Expression; alias
368 ->orderBy(new Expression('LENGTH(f_id)'))
383 ->orderBy(new Expression('LENGTH(i_id)'))
398 ->orderBy(new Expression('LENGTH(s_id)'))
413 ->orderBy(new Expression('LENGTH(m_id)'))
430 ->orderBy(new Expression('LENGTH(o_id)'))
H A DSiteLogsService.php31 use Illuminate\Database\Query\Expression; alias
61 …->select(['log.*', new Expression("COALESCE(user_name, '<none>') AS user_name"), new Expression("C…
H A DDatatablesService.php25 use Illuminate\Database\Query\Expression; alias
156 … $sort_column = $sort_columns[$value['column']] ?? new Expression(1 + $value['column']);
161 $query->orderBy(new Expression(1));
H A DMapDataService.php27 use Illuminate\Database\Query\Expression; alias
253 new Expression('COUNT(' . $prefix . 'p1.id) AS child_count'),
254 new Expression('SUM(' . $expression . ') AS no_coord'),
/webtrees/app/Schema/
H A DMigration44.php23 use Illuminate\Database\Query\Expression; alias
110 'pl_place' => new Expression('SUBSTRING(pl_place, 1, 120)'),
118 new Expression('MIN(pl_id) AS min'),
119 new Expression('MAX(pl_id) AS max'),
122 ->having(new Expression('COUNT(*)'), '>', '1')
148 new Expression('CASE pl_parent_id WHEN 0 THEN NULL ELSE pl_parent_id END'),
150 … new Expression("CAST(REPLACE(REPLACE(pl_lati, 'S', '-'), 'N', '') AS FLOAT)"),
151 … new Expression("CAST(REPLACE(REPLACE(pl_long, 'W', '-'), 'E', '') AS FLOAT)"),
162 new Expression('CASE pl_parent_id WHEN 0 THEN NULL ELSE pl_parent_id END'),
164 new Expression("REPLACE(REPLACE(pl_lati, 'S', '-'), 'N', '')"),
[all …]
H A DMigration37.php24 use Illuminate\Database\Query\Expression; alias
74 new Expression($substring_function . '(m_filename, 1, 248)'),
75 new Expression($substring_function . '(m_ext, 1, 4)'),
76 new Expression($substring_function . '(m_type, 1, 15)'),
77 new Expression($substring_function . '(m_titl, 1, 248)'),
/webtrees/app/Statistics/Google/
H A DChartMarriageAge.php26 use Illuminate\Database\Query\Expression; alias
61 …new Expression('AVG(' . DB::prefix('married.d_julianday2') . ' - ' . DB::prefix('birth.d_julianday…
62 … new Expression('ROUND((' . DB::prefix('married.d_year') . ' + 49) / 100, 0) AS century'),
63 new Expression("'M' as sex")
76 ->where('married.d_julianday1', '>', new Expression(DB::prefix('birth.d_julianday1')))
84 …new Expression('ROUND(AVG(' . DB::prefix('married.d_julianday2') . ' - ' . DB::prefix('birth.d_jul…
85 … new Expression('ROUND((' . DB::prefix('married.d_year') . ' + 49) / 100, 0) AS century'),
86 new Expression("'F' as sex")
99 ->where('married.d_julianday1', '>', new Expression(DB::prefix('birth.d_julianday1')))
H A DChartAge.php26 use Illuminate\Database\Query\Expression; alias
61 …new Expression('AVG(' . DB::prefix('death.d_julianday2') . ' - ' . DB::prefix('birth.d_julianday1'…
62 … new Expression('ROUND((' . DB::prefix('death.d_year') . ' + 49) / 100, 0) AS century'),
/webtrees/app/Statistics/Repository/
H A DFamilyRepository.php39 use Illuminate\Database\Query\Expression; alias
169 ->orderBy(new Expression('COUNT(*)'), 'DESC')
330 …link1.l_from AS family', 'link1.l_to AS ch1', 'link2.l_to AS ch2', new Expression(DB::prefix('chil…
562 ->select(['f_numchil', new Expression('COUNT(*) AS total')]);
711 ->select(['l_from AS family_id', new Expression('MIN(d_julianday1) AS min_birth_jd')])
727 ->select(['d_month', new Expression('COUNT(*) AS total')])
753 ->select(['d_month', 'i_sex', new Expression('COUNT(*) AS total')])
833 … ->where('childbirth.d_julianday2', '>', new Expression(DB::prefix('birth.d_julianday1')))
834 …->select(['parentfamily.l_to AS id', new Expression(DB::prefix('childbirth.d_julianday2') . ' - ' …
1031 …->select(['f_id AS family', new Expression('MIN(' . DB::prefix('husbdeath.d_julianday2') . ' - ' .…
[all …]
H A DIndividualRepository.php47 use Illuminate\Database\Query\Expression; alias
109 ->where(new Expression('LENGTH(n_givn)'), '>', 1);
126 ->pluck(new Expression('COUNT(distinct n_id) AS count'), 'n_givn');
512 ->orderBy(new Expression('COUNT(n_surn)'), 'DESC')
513 ->having(new Expression('COUNT(n_surn)'), '>=', $threshold)
526 ->select(['n_surn', new Expression('COUNT(n_surn) AS count')])
685 ->select(['d_month', new Expression('COUNT(*) AS total')])
709 ->select(['d_month', 'i_sex', new Expression('COUNT(*) AS total')])
743 ->select(['d_month', new Expression('COUNT(*) AS total')])
767 ->select(['d_month', 'i_sex', new Expression('COUNT(*) AS total')])
[all …]
H A DPlaceRepository.php30 use Illuminate\Database\Query\Expression; alias
203 ->orderByDesc(new Expression('COUNT(*)'))
205 ->pluck(new Expression('COUNT(*) AS total'), 'p_place')
/webtrees/app/Module/
H A DSiteMapModule.php41 use Illuminate\Database\Query\Expression; alias
203 ->pluck(new Expression('COUNT(*) AS total'), 'gedcom_name');
209 ->pluck(new Expression('COUNT(*) AS total'), 'gedcom_name');
215 ->pluck(new Expression('COUNT(*) AS total'), 'gedcom_name');
222 ->pluck(new Expression('COUNT(*) AS total'), 'gedcom_name');
229 ->pluck(new Expression('COUNT(*) AS total'), 'gedcom_name');
235 ->pluck(new Expression('COUNT(*) AS total'), 'gedcom_name');
242 ->pluck(new Expression('COUNT(*) AS total'), 'gedcom_name');
/webtrees/resources/views/lists/
H A Dnotes-table.phtml9 use Illuminate\Database\Query\Expression; alias
32 ->pluck(new Expression('COUNT(*) AS total'), 'l_to')
44 ->pluck(new Expression('COUNT(*) AS total'), 'l_to')
56 ->pluck(new Expression('COUNT(*) AS total'), 'l_to')
68 ->pluck(new Expression('COUNT(*) AS total'), 'l_to')
H A Dsources-table.phtml10 use Illuminate\Database\Query\Expression; alias
33 ->pluck(new Expression('COUNT(*) AS total'), 'l_to')
45 ->pluck(new Expression('COUNT(*) AS total'), 'l_to')
57 ->pluck(new Expression('COUNT(*) AS total'), 'l_to')
70 ->pluck(new Expression('COUNT(*) AS total'), 'l_to')
H A Dmedia-table.phtml9 use Illuminate\Database\Query\Expression; alias
32 ->pluck(new Expression('COUNT(*) AS total'), 'l_to')
44 ->pluck(new Expression('COUNT(*) AS total'), 'l_to')
56 ->pluck(new Expression('COUNT(*) AS total'), 'l_to')
H A Dlocations-table.phtml9 use Illuminate\Database\Query\Expression; alias
32 ->pluck(new Expression('COUNT(*) AS total'), 'l_to')
44 ->pluck(new Expression('COUNT(*) AS total'), 'l_to')
H A Dsubmitters-table.phtml9 use Illuminate\Database\Query\Expression; alias
35 ->pluck(new Expression('COUNT(*) AS total'), 'l_to')
47 ->pluck(new Expression('COUNT(*) AS total'), 'l_to')
/webtrees/app/
H A DDB.php24 use Illuminate\Database\Query\Expression; alias
208 public static function binaryColumn(string $column, string|null $alias = null): Expression
220 return new Expression($sql);

12