Let's say I have a model called Research. Each research belongsToMany Location models. And each Location model BelongsToMany Contact models. BUT, each Contact is also related to Research. class Research extends Model { protected $table = 'researches'; public function locations()…
I loop trough an eloquent Collection and I want to add the data to another Collection called "$tagCollection". If an entry with the same tag_id already exists I only want to increase the rating-column for the existing entry. At the…
I get a Laravel collection from a Eloquent query and I converted into an array using toArray() method. The sample output is mentioned below. Array ( [0] => Array ( [id] => 1 [details] => routes [level] => beginner [created_at]…
I'm doing a dental function, I'm looking to sync data in a many-to-many relationship. I have the following: tooth - id - name cost - id - name cost_tooth - id - tooth_id - cost_id - row_number This is the…
I'm truing to get the employees that have birthday within next 3 days. I tried to do that by using the following query. public function upcomingBirthdays() { $from = now()->format('m-d'); $to = now()->addDays(3)->format('m-d'); $employees = Employees::whereRaw("DATE_FORMAT(dob, '%m-%d') BETWEEN '{$from}' AND…
Is it possible to combine multiple orWhere() inside one where()? E.g. The following: $query->where(function($query){ $query->where('text1', '=', $_GET['lorem']) ->orWhere('text2', '=', $_GET['lorem']) ->orWhere('text3', '=', $_GET['lorem']) ->orWhere('text4', '=', $_GET['lorem']); }); Would look something like this: $query->where(function($query){ $query->where(['text1' || 'text2' || 'text3' || 'text4'],…
I've got 3 models: Order, OrderItem and Product (for simplicity just showing the relationships): class Order extends BaseModel { use Uuid; protected $casts = [ 'status' => OrderStatuses::class, ]; /** * An Order has multiple OrderItems associated to it. *…
I could not find this in the laravel docs on aggregate relationships I was able to do something like this private function refreshUsers() { $this->users = User::withSum(['taskTimeSessions'=> function ($query) { $query->whereMonth('created_at',$this->month) ->where('is_reconciled',1); }],'session_duration_in_seconds') ->get(); } But now I am trying…
I am new to Laravel and looked already for a similiar thread but I didnt find something. I want to use Eloquent and I got 3 Models and Tables: Testseries, Devices and Users. The Users has a many to many…
Route: Route::get('/posts/{post}', [PostController::class, 'show']); Controller: public function show(Post $post){ $postData = $post->load(['author' => function($query){ $query->select('post_id', 'name'); }]) ->get(['title', 'desc', 'created_date']) ->toArray(); } This returns all the posts in the database, While I only want to get the selected post passed…