Laravel orderBy备份字段incase primary是重复的

Question

Working on a queuing system that allows users to book appointments.

There is a slight issue at the moment where two appointments can get the same value for a field of 'estimated_booking_time'. This time is used to show when they are coming up.

The problem is that when fetching all appointments the ones with a duplicate estimated_booking_time are then ordered by their ID which (depending on when the appointment was booked) can sometimes be in a reverse order.

Im using carbon to create a diffInMinutes return on another field but the where the ID is the backup order my results are not always correct.

Is there a way to tell Laravel instead to use another field as the backup orderby field when there are duplicate values?

Answer 1

You can invoke orderBy multiple times.

Booking::orderBy('estimated_booking_time', 'ASC')->orderBy('created_at', 'ASC')->get();