php - Getting last event per day from mysql database with CodeIgniter
one text
We have a CRM application to monitor employees check ins and check outs of every location (clients).
I'm requested to get the last check out of a specific employee per day.
My database looks like this:
| employee_id | check in time | check out time |
|---|---|---|
| 90 | 1666536812 | 1666537080 |
| 90 | 1653467778 | 1653474758 |
| 90 | 1653467444 | 1653474321 |