I want to filter records with relation which has another relation with conditions and with count > 0 Code: $classClass = ClassClass::query() ->with('parent') ->with('children', function (BelongsTo $query) { $query ->withCount(['serialNumbers' => function($query) { $query ->whereNull('serial_number_parent_id') ->whereNull('inherit_class_for_serial_number_id'); }]); }) ->where('parent_class_id','=', $class->id)…
Laravel group by if column value exits then group by perform other wise as it is return records in single laravel query i have tried this $sql = $this->expense->builder()->where('session_year_id',1)->whereNull('staff_id')->orWhereNotNull(function($q){ $q->groupBy('month'); })->get();
I have a need to create a migration that changes an existing 'unsignedMediumInteger' column to nullable(). I have the following in my migration: <?php use IlluminateDatabaseMigrationsMigration; use IlluminateDatabaseSchemaBlueprint; use IlluminateSupportFacadesSchema; use AppNewModelsSubscriptionType; return new class extends Migration { public function…
I am unsure if I should use the Carbon date object directly in the where() function. Or should I use the timestamp of the Carbon (date) object? $todayMarketCloseTime = Carbon::now('Asia/Karachi')->hour(15)->minute(10)->second(00); // Should I get the timestamp on the Carbon date…
I am trying to write an Eloquent query for a BelongsToMany relationship and where the results return only one distinct result based on the pivot table. See below for example. Installer: Id Name 1 Installer 1 2 Installer 2 State:…
How can I retrieve data from my respondent table when it has a one-to-one relationship with the ages table, sexes table, diseases table, and vaccines table? I want to display within my table.blade.php file the contents in my respondent table,…
enter image description here How can I fetch those latest records withRaw Sql syntax I know how to get it through eloquent with hasOne relationship but i need to do it from joins `post id; integer('no'); string('division'); histories id; foreignId('post_id');…
I have a model Product which contains a list of Specification how can I easily update all the specifications in one-to-many relationship in Laravel 10? class Product extends Model { //... public function specifications() { return $this->hasMany(Specification:class); } } class…
Why do some of my voucher relations return null? even though there is a voucher with that ID And some relationships run well as in the picture below This is code for dumping the results dump(AppModelsAffiliatorVoucher::find('27a4093d-2370-4c55-bc44-1f8ef8144067')->toArray()); dd(AppModelsAffiliatorVoucherMember::with('voucher')->find(172)->toArray()); AppModelsAffiliatorVoucher class AffiliatorVoucher…
I'm trying to fetch all records from a database table using Post::all() . Strangely, it's giving me a 500 error. if I use a where clause like Post::where('id', 1)->get(), it works just fine. I checked the error log, but there's…