I have a model, Project, that I am eager loading relations in the Http/Controller. The problem is that the withDefault closure on the belongsTo Relation in the model always fires, regardless of if there is an actual relation to eager…
I am creating an API using laravel 10 and eloquent and I want to copy values from an object read from the http request to anoter object that is a laravel entity, I have an object with a lot of…
To simplify I have two models, Product and ProductStatus. To record the history of the product status, they are tied with one-to-many relationship with Product being the parent. Now the question is: How do I query the Product model based…
I am creating a small news system and these are the tables I have available: News Table id title text 1 News 1 - 2 News 2 - 3 News 3 - 4 News 4 - 5 News 5 -…
I have two models, User and Community. A user can belong to many communities while a community can have many users. I have implemented many-to-many relationship for this in both models and then created a pivot table communities_users. In Community…
I have the following code where I fire an event comparing two versions of the same model. I worked around it by manually setting a "dirty" attribute. However, is there a way to fetch the whole original model on updated…
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 am using Laravel 10. This is crm_details table: I need to count each status,. Also I need to consider parent_token with the same value as a single row. That means 2 rows have same `parent_token' then It will consider…
I have create a laravel object as per the documentation. Though when i am trying to get the value from it, it is throwing the error. Here is a sample code $user = USER::findOrFail(2990); print_r($user); This is throwing error. Please…
I have tried everything to get the data total of Jumlah Hadir, Jumlah Sakit, and Jumlah Izin there for every user. as a beginner I am very confused. For a clear view I want, you can see the image below:…