Answer to Question #287516 in Excel for jhay

Question

PROBLEM 101

PHP, JS, MySQL, CSS, HTML

INPUT:
Using the following databases
1. u_dtrs.sql
	tbl_employee = employee basic info
	tbl_employee_status = employee status/schedule
	tbl_schedule = preset schedules
2. u_attn.sql
	07-2020 = employee attendance for 07-2020 period (1 - 22 only)

OUTPUT:
Generate attendance (DTR) for each employees. See "Result.png" for the example/expected output.

NOTE:
- using structured programming/OOP is much BETTER
- no login required
- implement proper data validation/security

Answer 1

Dear jhay, your question requires a lot of work, which neither of our experts is ready to perform for free. We advise you to convert it to a fully qualified order and we will try to help you. Please click the link below to proceed: Submit order