I want to sort/order a query in laravel. For example I have a model where 'id' ranges from 1 to 100. And I have an array of ids of selected model elements eg. [1,3,12,32,...]. I want to sort my model…
I have a mysql table which has two columns id and attendancetime, I want to select count(id) hourly. id attendancetime 1 1725256398 2 1725258398 3 1725264581 4 1725277777 5 1725277777 6 1725277777 7 1725298931 8 1725299156 9 1725299156 My expected…
I have a User and Lesson models. these models are not related to each other. users table: id, username, password, is_active lessons table: id, title User class User extends Modle { // code } Lesson class Lessosn extends Modle {…
I want to hash password and fill it in my request validator to be able to save a new employee registration. Can you help how to hash password in request validator? Here details of my project: Model: <?php namespace AppModels;…
I'm working on a Laravel project where I need to calculate an estimated_value for each record in my SalesLead model by multiplying the probability and value columns. I want to filter records based on this computed column. I used a…
I have a filament resource with a table. I want to change the table query based on the condition i.e. if there is a filter ->modifyQueryUsing(function (Builder $query){ if (tableFilter) { return $query->with('studentAcademics'); } else { return $query->whereNull('id'); } })…
In laravel 11 app User model have defined relation : namespace AppModels; use IlluminateFoundationAuthUser as Authenticatable; ... class User extends Authenticatable { public function uncompletedTasks(): belongsToMany { return $this->belongsToMany(Task::class) ->using(TaskUser::class) ->withPivot('supervisor_id') // Reference to "task_user" table ->where('completed', false) ->orderBy('priority', 'desc')…
I'm working on a filtering system for products using laravel Laravel Framework 11.20.0 & PHP 8.3.10, and wanted to get your thoughts on the best approach. Here's the scope query I've added to the Product model public function applyFilters($query, Request…
I am unable to get autocompletions for the methods for Eloquent models in Visual Studio Code. Using DB instead of the model does show the methods. I have the Post model imported, and I tried installing the IDE helper from…
have a "courses" collection that contains two taxonomies: "courses_levels" and "courses_categories". Currently, I use the following loop to iterate over all courses by level. However, I would now like to apply a filter based on the second taxonomy "courses_categories". {{…