@SuppressWarnings("unchecked")
    public List<Object[]> getListLokasiAbsensiOnline(String karyawanId, Date tanggalJamUserAbsen) {
        StringBuilder sb = new StringBuilder();

        sb.append("SELECT       a.hm_mem006_workplace_id as lokasiAbsen, \n");
        sb.append("             b.longitude, b.latitude, b.max_radius_in_meters, b.hm_msd031_timezone_id \n");
        sb.append("FROM         hm_oem008 a \n");
        sb.append("INNER JOIN   hm_mes016 b on a.hm_mem006_workplace_id = b.hm_mem006_workplace_id \n");
        sb.append("WHERE        a.hm_oem001_employee_id = :karyawanId \n");
        sb.append("             and a.begin_date <= :tanggalJamUserAbsen and :tanggalJamUserAbsen <= a.end_date \n");
        sb.append("UNION        \n");
        sb.append("SELECT       id as lokasiAbsen, \n");
        sb.append("             longitude, latitude, max_radius_in_meters, hm_msd031_timezone_id \n");
        sb.append("FROM         hm_mes017 \n");
        sb.append("WHERE        hm_oem001_karyawan_id = :karyawanId \n");
        sb.append("             and flag_aktif = true \n");

        Query query = em.createNativeQuery(sb.toString());
        query.setParameter("karyawanId", karyawanId);
        query.setParameter("tanggalJamUserAbsen", tanggalJamUserAbsen);

        return (List<Object[]>) query.getResultList();
    }