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…
I'm building a diet plan with Laravel 8. Database looks like this: Recipes Category Calories Apple pie snacks 289 Banana pie snacks 386 Tomato Pasta lunch 712 Chicken Salad lunch 756 Vegetables soup dinner 410 Fish with potatoes dinner 652…
I am using Laravel 11 and the following structure: users - id artworks - id collections - id collection_user - id - collection_id - user_id artwork_collection - id - artwork_id - collection_id So a User can have multiple Collections, a…
I am currently using Laravel Scout to search through my models with the database driver My search controller looks like this Post::search($request->filter)->get(); Lets say I have a posts with a Text that say "Hello this is a Post" When I…
I have three models: Group, Activity, User. With the following relationships in the models. Activities belongTo a Group (with the group_id being a field in the activity) Users belongTo a Group (with the group_id being a field in the user)…
I have a table transaction_details cta scta sscta charge 102 1 1 80.00 102 1 1 5.00 102 1 2 20.00 102 1 2 2.00 105 1 0 30.00 105 2 0 50.00 107 1 0 45.00 107 1 0…