i have one problem , i try to fetch data from database to show it on view page .. when this data not ready in database , i dont want to show attempt to read property on null or 404…
I have a staff controller and transactions model. In the staff controller, I am fetching staff transactions with other data as below StaffController.php $transactions = Transaction::thisMerchant() ->earnedByStaff($staff) ->where(function ($q) use ($staffID) { $q->where('staff_id', $staffID) ->orWhere(function ($qq) use ($staffID) { $qq…
I want to add a field to an Eloquent model instance. This field data comes from a query, not a constant or a value. Yes, it could be done adding a field to $appends and adding an Attribute, but the…
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…