I have a database with structure like
users:
usr_id
usr_fname
usr_lname
usr_uname
usr_pass
organizarion:
org_id
org_name
org_address
org_tel
org_web
org_email
org_cat
org_desc
departments:
dpt_id
dpt_name
dpt_desc
sections:
sec_id
sec_dpt_id
sec_name
sec_desc
designations:
dsg_id
dsg_sec_id
dsg_name
dsg_desc
employee:
emp_id
emp_fname
emp_lname
emp_phone
emp_email
emp_addr
emp_join_dt
emp_salary
emp_card_no
emp_dsg_id
emp_sft_id
shifts:
sft_id
sft_name
sft_from
sft_to
sft_desc
leaves:
lev_id
lev_emp_id
lev_frm
lev_to
lev_desc
holidays:
hld_id
thl_tp_id
hld_st_dt
hld_end_dt
hld_cmnt
holiday_types:
hld_tp_id
hld_tp_name
hld_tp_desc
attendance:
att_id
att_emp_id
att_time
att_date
att_dir
Can anyone help me querying to produce employee wise monthly attendance report where in time and out time for each date and "absent" would be written for absent days will be available?
My report will be like this:
Date Attendance Shift In time Out time
1 Present A 12:40 PM 06:40 PM
2 Absent A N/A N/A
3
.
.
.
31 Present B 07:00 PM 11:00 PM
Total