Laravel Report: 2-Level GroupBy with Dynamic Columns

preview_player
Показать описание
Today I'm answering a question from an email, trying to group the data with two conditions.

- - - - -
Support the channel by checking out my products:

- - - - -
Other places to follow:
  1. Laravel Daily
Рекомендации по теме
Laravel Report: 2-Level 0:05:30

Laravel Report: 2-Level GroupBy with Dynamic Columns

Laravel Eloquent Report: 0:02:29

Laravel Eloquent Report: Group By Year with Raw Queries

Laravel Report: Group 0:03:05

Laravel Report: Group By Day with CarbonPeriod and Collections

Laravel GroupBy: 3 0:05:46

Laravel GroupBy: 3 Practical Examples

Eloquent Practice: Group 0:08:59

Eloquent Practice: Group By Month and Company

Eloquent Practice: Group 0:05:49

Eloquent Practice: Group By Raw and HasMany

Laravel Group Data: 0:05:23

Laravel Group Data: in Collections or in Eloquent Query?

Why & How 0:10:11

Why & How To Used groupBy() Method In Laravel

Laravel 10 Fundamental 0:06:28

Laravel 10 Fundamental [Part 88] - Query Builder - Group By with Count

Advanced Aggregate Functions 0:06:00

Advanced Aggregate Functions in SQL (GROUP BY, HAVING vs. WHERE)

How to use 0:11:14

How to use Group Concat in laravel Joining | Laravel Group By | Laravel 8 | Learning Points

How to fix 0:02:09

How to fix Group by not working - Laravel

laravel Dynamic module 0:00:59

laravel Dynamic module Report no video

NEW in Filament 0:03:26

NEW in Filament 3: Table Builder Summaries with Grouping

Best Programming Languages 0:00:16

Best Programming Languages #programming #coding #javascript

How to Get 0:00:36

How to Get single column's value from the first result in Laravel #shorts #laravel #php

How to Order 0:03:55

How to Order by Relationship in Eloquent | Laravel | Tutorial | Quick Win Wednesday #QWW

Eloquent Example: Group 0:05:12

Eloquent Example: Group Data with Multiple Calculations

Kafka in 100 0:02:35

Kafka in 100 Seconds

Laravel Eloquent tips 0:05:55

Laravel Eloquent tips and tricks | master querying dates ...

Demo | Dynamic 0:02:47

Demo | Dynamic Graphical Reporting Dashboard in Laravel, MySQL , #Highcharts , #Amcharts

laravel consent module 0:00:28

laravel consent module Report no video

Laravel Collection Filtering: 0:00:46

Laravel Collection Filtering: Tips and Tricks #shorts #laravel #php

Secret To Optimizing 0:05:57

Secret To Optimizing SQL Queries - Understand The SQL Execution Order

Комментарии
Автор

Level two ‘group’ and ‘where’ are seems like untouched from my end. Thank you for sharing new content 🎉

SuvroImran
Автор

I've not known the 2-level two ‘group’ and ‘where’ until I saw this video. Thanks for your gem.

freeidol
Автор

Thank you for another class, Povilas! Appreciate it!

rubensgarrison
Автор

You deserve a million subscriber in quick. So much good content and understanding.

khapp
Автор

Thank you for another class. I would like to suggest that you discuss inheritance in Laravel, as it is a topic that isn't commonly talked about. Specifically, I'm interested in knowing the best approach between single table inheritance and multi table inheritance.

One common scenario where this arises is when you need to separate two records that have almost all the fields in common, but with a few differences. For example, let's consider a table for Animals, with specific records for Cats and Dogs. These two entities share most of the fields, but have a few distinct ones. In such cases, would it be better to split them into different tables and utilize scopes using the foreign key for animal, or keep them in one large table and use a column type?

pauloteodoro
Автор

Hello Povilas, hope you are doing well.
My question is not related to this tutorial but payment.
So, is it secure to create a payments table and store the chargeID, status, amount currency and of course userID in this table during the payment process (for a single charge) in order to retrieve chargeID to refund?

neonneon