diff options
| author | Greg Roach <greg@subaqua.co.uk> | 2020-04-26 14:53:23 +0100 |
|---|---|---|
| committer | Greg Roach <greg@subaqua.co.uk> | 2020-04-26 14:53:23 +0100 |
| commit | eb8ab1e151ed2e0c52b600a232d6ad9dbab554b5 (patch) | |
| tree | 618c59bb68e2cdfb98626bac84f41062284154e5 /app/Http/RequestHandlers/ControlPanel.php | |
| parent | e380f8990cb1cd8831d92d4267bce2ed573b9856 (diff) | |
| download | webtrees-eb8ab1e151ed2e0c52b600a232d6ad9dbab554b5.tar.gz webtrees-eb8ab1e151ed2e0c52b600a232d6ad9dbab554b5.tar.bz2 webtrees-eb8ab1e151ed2e0c52b600a232d6ad9dbab554b5.zip | |
Postgres compatibility
Diffstat (limited to 'app/Http/RequestHandlers/ControlPanel.php')
| -rw-r--r-- | app/Http/RequestHandlers/ControlPanel.php | 16 |
1 files changed, 8 insertions, 8 deletions
diff --git a/app/Http/RequestHandlers/ControlPanel.php b/app/Http/RequestHandlers/ControlPanel.php index 1bfecdacc8..66c437d519 100644 --- a/app/Http/RequestHandlers/ControlPanel.php +++ b/app/Http/RequestHandlers/ControlPanel.php @@ -207,7 +207,7 @@ class ControlPanel implements RequestHandlerInterface ->where('change.status', '=', 'pending'); }) ->groupBy(['gedcom.gedcom_id']) - ->pluck(new Expression('COUNT(change_id)'), 'gedcom.gedcom_id') + ->pluck(new Expression('COUNT(change_id) AS aggregate'), 'gedcom.gedcom_id') ->all(); } @@ -221,7 +221,7 @@ class ControlPanel implements RequestHandlerInterface return DB::table('gedcom') ->leftJoin('individuals', 'i_file', '=', 'gedcom_id') ->groupBy(['gedcom_id']) - ->pluck(new Expression('COUNT(i_id)'), 'gedcom_id') + ->pluck(new Expression('COUNT(i_id) AS aggregate'), 'gedcom_id') ->map(static function (string $count) { return (int) $count; }); @@ -237,7 +237,7 @@ class ControlPanel implements RequestHandlerInterface return DB::table('gedcom') ->leftJoin('families', 'f_file', '=', 'gedcom_id') ->groupBy(['gedcom_id']) - ->pluck(new Expression('COUNT(f_id)'), 'gedcom_id') + ->pluck(new Expression('COUNT(f_id) AS aggregate'), 'gedcom_id') ->map(static function (string $count) { return (int) $count; }); @@ -253,7 +253,7 @@ class ControlPanel implements RequestHandlerInterface return DB::table('gedcom') ->leftJoin('sources', 's_file', '=', 'gedcom_id') ->groupBy(['gedcom_id']) - ->pluck(new Expression('COUNT(s_id)'), 'gedcom_id') + ->pluck(new Expression('COUNT(s_id) AS aggregate'), 'gedcom_id') ->map(static function (string $count) { return (int) $count; }); @@ -269,7 +269,7 @@ class ControlPanel implements RequestHandlerInterface return DB::table('gedcom') ->leftJoin('media', 'm_file', '=', 'gedcom_id') ->groupBy(['gedcom_id']) - ->pluck(new Expression('COUNT(m_id)'), 'gedcom_id') + ->pluck(new Expression('COUNT(m_id) AS aggregate'), 'gedcom_id') ->map(static function (string $count) { return (int) $count; }); @@ -289,7 +289,7 @@ class ControlPanel implements RequestHandlerInterface ->where('o_type', '=', Repository::RECORD_TYPE); }) ->groupBy(['gedcom_id']) - ->pluck(new Expression('COUNT(o_id)'), 'gedcom_id') + ->pluck(new Expression('COUNT(o_id) AS aggregate'), 'gedcom_id') ->map(static function (string $count) { return (int) $count; }); @@ -309,7 +309,7 @@ class ControlPanel implements RequestHandlerInterface ->where('o_type', '=', Note::RECORD_TYPE); }) ->groupBy(['gedcom_id']) - ->pluck(new Expression('COUNT(o_id)'), 'gedcom_id') + ->pluck(new Expression('COUNT(o_id) AS aggregate'), 'gedcom_id') ->map(static function (string $count) { return (int) $count; }); @@ -329,7 +329,7 @@ class ControlPanel implements RequestHandlerInterface ->where('o_type', '=', Submitter::RECORD_TYPE); }) ->groupBy(['gedcom_id']) - ->pluck(new Expression('COUNT(o_id)'), 'gedcom_id') + ->pluck(new Expression('COUNT(o_id) AS aggregate'), 'gedcom_id') ->map(static function (string $count) { return (int) $count; }); |