I'm trying to use a HasMany relation in a HasOne. I have following Models: class Auction extends Model { //... public function bids(): HasMany { return $this->hasMany(Bid::class, 'auction_id'); } public function approvedBids(): HasMany { return $this->bids()->approved(); } public function topBids():…
I have a table with 3 columns: firstname lastname fullname in migration: Schema::create('owners', function (Blueprint $table) { $table->id(); $table->string('firstname',20); $table->string('lastname', 20); $table->string('fullname')->storedAs('CONCAT(firstname,lastname)'); $table->timestamps(); }); the problem is that i want to change the concatenation order in the controller i tried…
If I use models this is easily resolved, but if I don't have the availability of using models, would it be possible to get the result equivalent to ->with() with DB::table?
I have a table and there are two columns. user_id to_user_id 101 102 102 101 101 105 In the above table, 1 and 2 rows of users are like each other I want to remove 2 rows. Here is my…
I've been using latestOfmany() for my hasMany() relation to define them as hasOne() for quite a while now. Lately I've been in need of the similar application but for belongsToMany() relationships. Laravel doesn't have this feature unfortunately. My codebase as…
I have these: posts table public function up() { Schema::create('posts', function (Blueprint $table) { $table->id(); $table->string('title', 64); $table->string('teaser', 128)->nullable(); $table->text('content', 50000); $table->timestamps(); }); } posts model use HasFactory; protected $fillable = ['title', 'teaser', 'content']; public function tags() { return $this->belongsToMany(Tag::class,…
In my Laravel app there are 3 Models: Movie, User, Review Review: <?php namespace AppModels; use IlluminateDatabaseEloquentFactoriesHasFactory; use IlluminateDatabaseEloquentModel; class Review extends Model { use HasFactory; protected $hidden = ['user_id','movie_id','created_at','updated_at']; public function movie(){ return $this->belongsTo(Movie::class); } public function user(){ return…
I am trying to store a simple form into my database. My model is that I have jobs which where each job can contain several task. Therefore my Models look like this: User public function jobs() { return $this->hasMany(Job::class); }…
The below function allows me to retrieve related entries of a given model type that have, for instance, overlapping tags associated with them. <?php public function getRelated($entity, $fields = [], $relations = []) { $related = new EloquentCollection(); // get…
I fill a SQL Table from a Request with Laravel Excel. After this I do an Eloquent Statement to fill the values markt and period manually. public function importall(Request $request) { $periode = $request->periode; $markt = $request->markt; Excel::import(new periodenImport(), $request->file);…