How to make a redirect after login to the requested page?

Question

MySQL

Good afternoon! Please tell me how to implement. Now, if a user tries to open a page that requires authorization, he is redirected to the main page and a login modal appears. How to make it return to the requested page before login after login? There is an option to return the requested page in the parameter and redirect using JS after login, but can it be done using Lara's tools?

Answer 1

SELECT ...
  FROM (
    SELECT 0 AS `order`, ...
      FROM `sc_order` 
      WHERE `StatusId` = 5
    UNION SELECT 1 AS `order`, ...
      FROM `codes` 
      WHERE ...
  ) AS `t`
  ORDER BY `order`
  LIMIT 20