I have a SQL query like this: SELECT year FROM ( SELECT my_custom_function_for_get_year(week_start::date) AS year FROM ( SELECT date_trunc('week', week_start) AS week_start FROM generate_series('2023-01-01'::date, '2023-12-31'::date, interval '1 week') gs(week_start) ) as select1, (SELECT id FROM mytable) as select2 ) as…
I have one to many relations In my User Model public function user_balances(){ return $this->hasMany(UserBalances::class); } In my User Balances Model public function user(){ return $this->belongsTo(UserBalances::class); } So every time I want to retrieve the last record of user balance,…
Imagine I had 4 models as follows: Year Position PositionAllowance : This is a pivot table of Position and Year, with the addition of "allowance" i.e. it defines the amount of allowance for each position in a specified year. Employee…
I have some code and tried it in two ways. It's not working as expected and is not rolling back data Error produce example is in git : https://github.com/Namvarii/laravel-db-transaction-error DB::beginTransaction(); try { $order = Order::create([ // data ]); $order->notes()->create([ //…
I have this code here simplified. Post::whereDoesntHave('tags', function($query){ $query->whereIn(tags.id, $tagIds); }) Lets say that tagIds = [1,2,3] My goal is to retrieve only Posts that do not contain all of those tags. ex. if post has tags 1,2,3 , then…
So far the only thing I've seen devs putting in model policies is simple statements like this: public function update(User $user, Post $post): bool { return $user->id === $post->user_id; } In my app I have an admin user that should…
I'm trying to build a request that returns all users that are a subset of a specific user ID (via connected_id), who are also between one or many age ranges (eg "20-30", "50-60"). The list of ages ranges are presented…
I have a query to return: All schedules that doesn't have program or all schedules that have at least a program but the program is yet to end. The issue is that, the query returns all schedules that doesn't have…
I am creating a virtual shop website and I'm trying to do a Product register page. Some of the fields from the product form are not required, so I need a way to make my Controller only add the columns…
I want to join two tables with laravel relationship, but I've gotten stuck. I have 2 MySSL tables table strans + id + trans_code + trans_description table step + step_id + step_trans_code + step_proc_sequence My models look like this: class…