How do I generate pagination links? My code looks like this: // In Model public function comments() { return $this->hasMany(Comment::class); } // In Controller public function show(User $user) { $user = User::query() ->with(['comments' => fn ($query) => $query->paginate(20)->withQueryString()]) ->find($user->id); return…
I want to use a record fields in laravel eloquent subquery I tried this $clients = Client::with(['records' => function (Builder $query) { // how can i take a record fields there? $record = $query->first(); $query->where('time', Carbon::now()->subMinutes(10 + $record->duration); }])->where('profile_id', $profile->id)->get();…
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…