Imagine we have a Facture and Item model in a one-to-many relationship. I'm using $facture->items() or $facture->load('items') and it works perfectly. However, when I need to use a condition on items like where('items.price', 30), I have no idea how to…
I'm not sure how I should have titled this question. I have a table called products. A simplified schema is: +--------+-----------+----------+ | id | name | priority | +--------+-----------+----------+ | 1 | Product 1 | null | | 2 |…
My question is quite similar to this unanswered question. I'm making a 2v2 ladder system in Laravel 11. I have 2 models: Users Games There's a pivot table between them with an added team_user column, defining which team the user…
Background In my Laravel application, I have models Organization, Region, and Location, which all have a polymorphic relationship to the User model via an Assignment model. (An Assignment is a three-way relationship between User, Role, and one of the other…
$dbConnection = DB::connection('test_connection'); $dbConnection->beginTransaction(); try{ $dbConnection->getSchemaBuilder()->create('Alpha_1', function ($table) use ($validatedData) { $table->string('name')->nullable(); }); $dbConnection->commit(); } catch (Exception $e) { // Rollback the transaction in case of error $dbConnection->rollBack(); // Get the exact database error $errorMessage = $e->getMessage(); dd($errorMessage); } I…
I am using the Cknow/Money package to handle money values in models. I have this model event that validates a value before saving to prevent wrong data from being entered due to a common scenario: I have this laravel 10…
I am trying to fetch the closest record of if date not matched in database. But somehow it is not working or you can say giving me the wrong information. Below is my code that you can check and help…
Want to logout the specific user, when admin inactive this specific user with Laravel public function userInactive1($id) { $selectedUser = User::find($id); if ($selectedUser) { // Update user status to inactive // $selectedUser->status = 0; $selectedUser->save(); } return redirect()->back(); }
I have Model called Post. In my DB I have fields like "views" and "likes". I need to add custom field to my SELECT request like "reactions" that do "views + likes". Using Attributes is bad idea because I need…
I have a 'projects' table in my Laravel project. The migration looks something like this: Schema::create('projects', function (Blueprint $table) { $table->id(); $table->string('title'); $table->string('key')->nullable(); $table->integer('bpm')->nullable(); $table->boolean('is_collaborative')->default(false); $table->foreignId('owner_id')->constrained('users')->cascadeOnDelete(); $table->timestamps(); }); I want the owner_id field to reference a user's id in order…