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". {{…
I have Users. Some users (admins) manage accounts, defined via a account_user pivot table (account_id | admin_id). Some of these admins manage other "sub-users", defined via a user_management pivot table (account_admin_id | end_user_id). #1) I need to create an Eloquent…
I need a screen to be accessed both by those who have logged in and by visitors, however I wanted to use auth()->user() on this page to access the data, however if I use the auth middleware it does not…
I have a model with a connection parameter to a different database. class User extends Model { protected $connection = 'main_database'; } When I save the model the connection is returning to default application connection which is named "mysql". It…
I found a weird situation when nesting in a query a where with a orWhereNull. The result is returning rows with values that are neither null nor correct This is the code: $query = Document::where("active", true)->where("type_id", $document_type->id); if($selected) { $query->where(function($q)…
I want to create a nested JSON object, something like this: [ { "age": 8, "countAll": 3, "gender": [ { "genderName": "male", "countGender": 2 }, { "genderName": "female", "countGender": 1 }, ] }, { "age": 10, "countAll": 1, "gender": […
I'd like to insert the user-id of the current user into a table in column "user_id". The field is a relation to the user table. Migration / database schema Schema::create('pdlocations', function (Blueprint $table) { $table->id(); $table->timestamps(); $table->decimal('lon', 10, 7); $table->decimal('lat',…
I have a model Product, and the same product can be sold by multiple supermarkets and outlets, so I define two BelongsToMany relationships for them: class Product extends Model { public function supermarkets(): BelongsToMany { return $this->belongsToMany( Supermarket::class, 'product_supermarket', 'product_id',…
I wanted to convert my Cakephp to Laravel 10. Here in Cakephp 2.x $sql = [ 'fields' => [ 'Student.name', 'Room.id' ], 'joins' => [ 'use index(course)', [ 'table' => 'rooms', 'alias' => 'Room use index(weekday, semester, year)', 'type' =>…