I have a table journals having columns transaction_id, type(receipt or payment), debit and credit columns for amount, account_id relation with accounts table the records can be multiple receipt or payment entries, and an opposite entry to record sum of these…
this code is not working: $removedEmployees = $mergedEmployees->diff($uniqueEmployees); here is my code. $employees1 = Employee::where('employment_status', '<>', 'SEPARATED') ->where('client_code_1', $client->client_code) ->where('position', $grouping->position) ->where('billable_rate', $grouping->billable_rate) ->get(); $employees2 = Employee::where('employment_status', '<>', 'SEPARATED') ->where('client_code_2', $client->client_code) ->where('position', $grouping->position) ->where('billable_rate', $grouping->billable_rate) ->get(); $mergedEmployees = $employees1->merge($employees2); $uniqueEmployees…
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…