DELIMITER $$
USE `humanresources`$$
CREATE DEFINER=`` PROCEDURE `GetEntranceExitListRoutine`(
in employeeId char(5),
in startDate date,
in endDate date
)
BEGIN
select r.id as rfid_id,e.id as employee_id,e.name,e.surname,a.when_accepted_date, a.when_accepted_time, p.when_exit_time
from employees e
join rfids r
on e.id = r.employees_id
join accepted_entrances a
on r.id = a.rfids_id
LEFT JOIN personel_exits p ON a.when_accepted_date = p.when_exit_date
AND a.rfids_id = p.rfids_id
where e.id = employeeId
and a.when_accepted_date
between startDate and endDate;

END$$

DELIMITER ;