I'm trying to delete data in my Laravel project, but when I click on the Delete menu, it just shows the confirmation alert. After I click OK, it only refreshes the /barang page, which shows the records list in the…
I have two tables bets and users. bets columns tickets (json) draw_date user_id I would like to get all tickets from users of a specific draw_date. Example result: [ 1 => [283983, 389239, 484843], 2 => [122343, 332344] ] 1,…
I would create a virtual model modelC (with no real table on the DB) as join between model modelA and model modelB. My need is to access to model modelC like a standard model and access to his attributes (modelA…
I have two tables in my db. Table Permit ID Permit_type Max_allowed 1 Full 24 2 Half 12 3 Quarter 6 Table Entry ID User_ID User_Name Permit_type Duration Status Date 1 1 John Smith Full 6 Approved 2023-12-08 2 2…
When Laravel Eloquent calls a relation property that indicates the original model of the relation destination from a certain model, it issues a re-query and returns the original model. Is there a way to return the original model without issuing…
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…