Sampel View vabsensi

CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER  VIEW `vabsensi` AS SELECT
absensi.idabsen,
absensi.uid,
karyawan.nama,
absensi.tgl,
absensi.masuk,
absensi.pulang,
case when absensi.tidakmasuk='Sakit' then 1 else 0 end as sakit,
case when absensi.tidakmasuk='Ijin' then 1 else 0 end as ijin,
case when absensi.tidakmasuk='Alfa' then 1 else 0 end as alfa,
case when cast(absensi.masuk as time)>cast('08:15:00' as time) then 1 else 0 end as terlambat,
case when cast(absensi.pulang as time)<cast((case when (WEEKDAY(absensi.tgl)+1)='6' then '13:00:00' else '16:00:00' end) as time) then 1 else 0 end as setengah_hari,
case when absensi.masuk='' AND absensi.pulang='' then 1 else 0 end as tidak_masuk,
case when (time_to_sec('08:00')-time_to_sec(absensi.masuk))>=time_to_sec('00:30') then sec_to_time(time_to_sec('08:00')-time_to_sec(absensi.masuk)) else '00:00:00' end as lembur_masuk,
case when   (cast(absensi.pulang as time)-cast((case when (WEEKDAY(absensi.tgl)+1)='6' then '13:00:00' else '16:00:00' end) as time))>=time_to_sec('00:30') then    time(cast(absensi.pulang as time)-cast((case when (WEEKDAY(absensi.tgl)+1)='6' then '13:00:00' else '16:00:00' end) as time)) else '00:00:00' end as lembur_pulang

FROM
absensi inner join karyawan on absensi.uid=karyawan.uid ;