How can I call a dynamic variable in a subquery? I have some relations and call them like: $locations = Location::query() ->with('brands', function ($query) { $query->with('employees')->where('location_id', {dynamic ID of brand location}); }) ->get(); The relation in the Location.php Class: public…
I'm working on a Laravel project and I have two models: "Post" and "Comment". Each post can have multiple comments. I'm trying to use the "withCount" method in Laravel to get the number of comments for each post. Here's what…
My Product Model is public function IncomeRepo(){ return $this->hasMany(Income::class,'Product'); } My Income Report Model Is public function ProductData(){ return $this->belongsTo(Product::class,'Product','id'); } My Query is public function SearchIncomeData(Request $request){ $GetFromDate = $request->FromDate; $GetToDate = $request->ToDate; $ProductData = Product::with('IncomeRepo')->whereBetween('created_at', [$GetFromDate, $GetToDate])->get(); return…
I have two tables in my Laravel project: teacher_subject and subject. The teacher_subject table has three columns: id, teacher_token and subject_token. And the subject table has three columns: id, subject_token and subject_name. teacher_subject table's subject_token referencing the subject table's subject_token.…
I have a categories table. every category has some posts. I want to get categories with their last 10 posts. So I tried this: Category::query()->with(['posts' => function($q) { $q->take(10); }])->get(); The problem is instead of putting 10 posts in each…
I am missing a laravel relation or I just don't get it... it is not hasOneThrough or belongsToThrough The relation is as in the topic: an Invoice (fkey customer_id) belongsTo Customer that Customer hasOne BankData (fkey customer_id) Am I missing…
Suppose I want to keep who follows who in a simple table that has two fields ; UserId and FollowedId and I have a simple data set like ; UserId FollowedId 1 100 2 100 3 100 4 100 5…
I have a relation in a database as follows: constituents Symbol [{"weight":0.5, "ticker":"WPM"},{"weight":0.5, "ticker":"AEM"}] GLD [{"weight":0.5, "ticker":"XYZ"},{"weight":0.5, "ticker":"ABC"}] KLE [{"weight":1.0, "ticker":"TSLA"}] TSLA [{"weight":1.0, "ticker":"MSFT"}] MSFT [{"weight":0.4, "ticker":"XYZ"},{"weight":0.6, "ticker":"ABC"}] KLE [{"weight":0.3, "ticker":"BBBY"},{"weight":0.7, "ticker":"GME"}] MEME I want to get the distinct symbols…
What is the correct way of defining 1:n relations in Laravel using MongoDB between two models Author and Book where one author can have several books while one book has exactly one authors? Author.php class Author extends Model { public…
I have a symfony app with a Comment entity, and I would like to link it, with a relation property, to many entities. But by many entities, I don't mean many objects, but many classes. A comment can be about…