I have a Laravel model Product and Vouchers defined as follows: class Product extends Model { public function vouchers(): HasMany { return $this->hasMany(Voucher::class); } } and class Voucher extends Model { public function product(): BelongsTo { return $this->belongsTo(Product::class); } }…
I have two models: User and Tier. In my management rules, A user is associated with one or more Third Parties, and a Tier is associated with a single User. Here is what I wrote in my template: User Model…
I have a problem in retrieving datas and using it to check checkboxes in Laravel. I want that when the edit pages are opened, the checkboxes will be checked based on the records on the database. Edit view page: @php…
I have a laravel project and in this project there is a table like this: I need to run a query and return a result where the $circulation variable is in range of the column range_from and range_to. So I…
I'm a newbie to Laravel so I'm probably making some sort of noob error. That said, here's my problem. I'm trying to access a related table from within my blade,. Here are relevant portions of my models: class _MeetingUser extends…
Using Laravel 10 and trying to get a belongsTo relationship to work and it's not working. Basically a Fragment has one FragmentGroup while a FragmentGroup has many Fragments. I'm using it this way and it's giving me null: $fragment =…
I have a simple json table containing an array of values: [1,2,3,4,5,6,7,8,9] I'm trying to query this table by multiple conditions: Must contain the value 2 Must contain atleast 3 of the other values, it does not matter which ones…
I have an array which I use to filter out the results of a certain query. There is a known issue where the query returns null, when the passed array in whereNotIn() or whereIn() exceeds a certain amount (I think…
I'm working on a project using Laravel 10. My goal is to show all customers data and added with a field containing the date of the last penawaran data made by that customer. Each Customer can create multiple Penawaran, but…
I use Laravel 10. I try to fetch some data from my mariaDB with the following condition. $contentList = $this->get(); foreach($contentList as $content){ $this->product()->where('id', '=', $content->content_product_id)->ddRawSql(); } But the query I get is: select * from `radio_content_products` where `radio_content_products`.`id` is…