2025-03-05 11:08:29 - Received Data: {"empId":"62","eid":"arch-emp62","visitdate":"2024-03-01"}
2025-03-05 11:09:12 - Received Data: {"empId":"62","eid":"arch-emp62","visitdate":"2024-03-26"}
2025-04-09 19:55:13 - Received Data: {"empId":"3","eid":"frts-emp3","visitdate":"2025-04-08"}
2025-04-09 19:55:13 - SQL Executed: SELECT 
    tbl_agencyvisit.empId AS employee_id, 
    tbl_agencyvisit.visitId AS visit_id, 
    tbl_agencyvisit.visitDate, 
    tbl_agencyvisit.punch_in, 
    tbl_agencyvisit.punch_out, 
    tbl_agencyvisit.totalTimeSpent, 
    tbl_agency.agencyId, 
    tbl_agency.agencyName
FROM tbl_agencyvisit
INNER JOIN tbl_employee ON tbl_employee.id = tbl_agencyvisit.empId
INNER JOIN tbl_agency ON tbl_agency.agencyId = tbl_agencyvisit.agencyId
WHERE tbl_agencyvisit.visitDate = ?
AND tbl_agencyvisit.empId = ? | Rows Found: 0
2025-04-10 00:12:29 - Received Data: {"empId":"3","eid":"frts-emp3","visitdate":"2025-04-09"}
2025-04-10 00:12:29 - SQL Executed: SELECT 
    tbl_agencyvisit.empId AS employee_id, 
    tbl_agencyvisit.visitId AS visit_id, 
    tbl_agencyvisit.visitDate, 
    tbl_agencyvisit.punch_in, 
    tbl_agencyvisit.punch_out, 
    tbl_agencyvisit.totalTimeSpent, 
    tbl_agency.agencyId, 
    tbl_agency.agencyName
FROM tbl_agencyvisit
INNER JOIN tbl_employee ON tbl_employee.id = tbl_agencyvisit.empId
INNER JOIN tbl_agency ON tbl_agency.agencyId = tbl_agencyvisit.agencyId
WHERE tbl_agencyvisit.visitDate = ?
AND tbl_agencyvisit.empId = ? | Rows Found: 2
