I have 3 tables - users, products and user_products. I try get user_products for user with products data. I can get user_products by $this->hasMany(ProductUser::class) but how can I get products atributes (title and other) from Product table in one query?…
So, I have a "noms" relation in provider model, i want, if role is manager, to return all models from noms. I have this: { return $this->hasMany(Nom::class); } want something like: { if($this->role === "manager"){ return Nom::all } return $this->hasMany(Nom::class);…
I'm trying to make my first Laravel app with React on the front-end using Breeze. I followed the instructions and installed PHP and Composer. Now trying to set up the Laravel app according to the instructions here and here, I…
I need help with the DB query builder. I tried to check if such a relationship already exists but got an error saying Call to undefined method IlluminateDatabaseQueryBuilder::has() $startDate = Carbon::today()->format('Y-m-dT00:00:00'); $endDate = Carbon::today()->format('Y-m-dT23:59:59'); if (request('start_date') && request('end_date')) { $startDate…
I’m facing a small issue with time zones in my Laravel application and would appreciate your help. I have a scheduled job in Laravel that updates event statuses. The job logs show the following timestamps in the laravel.log file: [2024-08-19…
I want to define middleware in my Laravel project, this is my web.php file, when I try to check the auth, I get an error Route [login] not defined. Please help me define middleware in Laravel 11 in the resource…
Laravel Framework 11.20.0 @vitejs/[email protected] vite.config.js: import { defineConfig } from 'vite'; import laravel from 'laravel-vite-plugin'; export default defineConfig({ plugins: [ laravel({ input: ['resources/js/app.js', 'resources/css/app.css'], refresh: true, }), ], }); app.js: import { createApp } from 'vue'; const app = createApp({…
In laravel referral system i want two foreign keys(userId,parentId) if user registers using referral code I defined two foreign keys (userId,parentId) in the network table when a user registers with a referral code. It's id, and its parent ID get…
Laravel sometimes error 500, SQLSTATE[HY000] [1045] I'm trying to make application settings from the database, otherwise load from .env How to make a request to the database in the service provider? Sometimes there is no error, sometimes there is error…
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…