I need help with my laravel 11 project. I have a table which acts as a morph table which would work with morphedByMany. But for this particular model I only need to retrieve one entry. My tables are: Site, Domain…
I'm encountering an issue with whereFullText in Laravel. Here's my code: $search_key = $args['q'] ?? $args['search_key'] ?? NULL; $builder->when($search_key, function (Builder $builder, $search_key) { $builder->whereFullText(self::fullTextColumns(), $search_key . self::WILDCARD, [ 'mode' => 'boolean', // [ natural, natural language, query expansion, boolean…
I'm currently building an API assigned for an ecommerce project using Laravel framework. While getting help to build data migrations and Models, I got confused on how the product_categories, the intermediate table, can link a product and category as in…
I'm encountering an issue with Laravel Eloquent while trying to order query results by a column from a related table. Specifically, I have a recipes table and a related nutrients table, and I want to order recipes by the kcal…
I have ProductCollection Model and AttributeValue Model which have a common table product_collection_attributes that has 2 columns: product_collection_id and attribute_value_id that are a foreign key to their respective tables and are both a primary key. In ProductCollection Model relation is:…
To show application_status in result, I'm using DB::raw statement in my query. DB::raw(' CASE WHEN status = 0 THEN "Pending" WHEN status = 1 THEN "Approved" WHEN status = 2 THEN "Declined" END AS application_status' ) How can I convert…
I am having an issue filtering a Mariadb query through HAVING on a computed column based on a Mariadb variable. I am having an issue in Laravel Elquent where a query I am running is producing no results. I have…
I'm using laravel 10. I have following structure in DB forum_categories id forum_threads id forum_category_id forum_posts id forum_thread_id My goal is, using the eloquent get all categories with latest ForumPost model. In model ForumCategory i have following method: public function…
I'm using Laravel 10 (planning to switch to 11 soon) to expose an API. Below is a simplified version of the issue that I'm having. I have a table with users and a table with groups, and I have a…
when i run the laravel schedule comman, "php artisan schedule:work "i get this error. am running; laravel 11 php 8.3 ArgumentCountError Too few arguments to function AppJobsOrangeJob::__construct(), 0 passed in D:projectspulseroutesconsole.php on line 8 and exactly 1 expected at appJobsOrangeJob.php:20…