Breaking News: Grepper is joining You.com. Read the official announcement!

Advanced query example - Laravel

Rasetz answered on May 25, 2023 Popularity 6/10 Helpfulness 3/10

answer Advanced query example - Laravel

Advanced query example - Laravel

Comment

$map = RegionData::join('regions', 'region_data.region_id', '=', 'regions.id')
             ->select('region_data.date', 'region_data.max', 'region_data.min', 'region_data.avg', 'region_data.opa', 'regions.name', 'regions.description')
             ->where(function ($query) {
                 $query->where('region_data.date', date('Y-m-d'))
                       ->orWhere(function ($query) {
                           $query->where('region_data.date', function ($query) {
                               $query->selectRaw('MAX(date)')
                                     ->from('region_data')
                                     ->where('date', '<', date('Y-m-d'));
                           })
                           ->whereNotIn('region_data.region_id', function ($query) {
                               $query->select('region_id')
                                     ->from('region_data')
                                     ->where('date', '>', date('Y-m-d'))
                                     ->groupBy('region_id');
                           });
                       });
             })
             ->get();

Popularity 6/10 Helpfulness 3/10 Language php

Source: Grepper

Tags: laravel php

Link to this answer
Share Copy Link

Contributed on May 25 2023

Rasetz

0 Answers Avg Quality 2/10

Advanced query example - Laravel

Contents

More Related Answers

Advanced query example - Laravel

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.