In my Setting model. I have a local scope that accepts $data array argument. The $data contains two keys group and property and any of them can be null as you can see in my query. public function scopeSettingFilters($query, array…
i try make code for search and this is my code: $services = Service::query()->with('plans')->latest(); if ($request->service_name) { $services = $services->whereRaw("CONVERT(JSON_EXTRACT(name, '$.ar') using 'utf8') LIKE '%$request->service_name%' ") ->orWhereRaw("CONVERT(JSON_EXTRACT(name, '$.en') using 'utf8') LIKE '%$request->service_name%' ") ->orWhereRaw("CONVERT(JSON_EXTRACT(name, '$.he') using 'utf8') LIKE '%$request->service_name%' ");…
In Message.php model: public function getAudioUrlAttribute() { return Storage::disk('public')->url('audio/' . $this->audio); } in MessageController.php $messages = Message::select('id', 'role', 'content', 'audio')->get(); $messages = $messages->map(function($message) { return $message->only('id', 'role', 'content', 'audio_url'); }); return ['messages' => $messages]; how to add audio_url to the…
I have three models: EmailTemplate EmailSend Attendee An EmailSend references both an Attendee and an EmailTemplate: class EmailSend extends MyBaseModel { ... public function attendee() { return $this->belongsTo(AppModalsAttendee::class); } public function template() { return $this->belongsTo(AppModalsEmailTemplate::class); } ... } and associated…
I'm trying to write a query scope in Laravel Eloquent to get records only where the sum of a records relationship values is more than a value stored in a parent column. So for example I have: Table A id…
I am writing a Trait for Laravel eloquent models that enables "promotion" of input elements during create and update. The base trait looks like this: <?php namespace AppTraits; use IlluminateDatabaseEloquentBuilder; trait PromotesInputsDuringCreation { public static function doPromotion($attrs) { if (isset(static::$promotions)…
hello i want to upload image via laravel. but i got this Error message: Call to a member function getClientOriginalExtension() on string i put my code below and will appreciate you for solve this problem. i searched the problem and…
Im learning the MVC pattern using Laravel and the eloquent model is kinda overwhelming to me. The eloquent model returns a collection of collumns of a table, but i want to a collection of another table to be the attributes…
I have the following data in my table: Name | Age | Shirt Size | User Id ------------------------------------------------------------- Jon Doe | 12 | L | 3 ------------------------------------------------------------- Jonathan Doe | 13 | XL | 3 ------------------------------------------------------------- John Doe | 14…
I keep encountering this error on Laravel 8 with PHP 8. Im grabbing the id from the view like so: <li><a href="category/{{$catego->id}}">{{$catego->categories}}</a></li> This then goes to web.php like so: Route::get('category/{id}', [UserController::class, 'categories']); It then goes to the categories function like…