Improvement still required:

• not allow employee to checkin more than once in a day. - not implemented
• create an admin login screen. implemented local admin login without database. - not implemented
• improve admin login with md5 and database saved password.
• add ability for admin to update login password.
• provide admin related functionality only to admin user (edit/delete user, print (copy, pdf, csv, xlsx, hard print). - implemented
• ability to select 'from' and 'to' date for the admin backend instead of showing only daily check in on the front end - implemented
• added ability to print with Brother QL-700 usb printer (requires Python 3 and project installed) - implemented
• added two seperate check in buttons, one for employee and one for visitor - implemented
• added automatic print of badge for visitor with qrcode summarising check in details. - implemented

Building a CRUD (Create Read Update Delete) application with PHP/MySQL/Bootstrap4/datatable for employee checkin/checkout purpose.

User Front End

Admin Login

(username: admin, password:123456)

Admin Backend

MySQL commands needed

INSERT (CREATE)

INSERT INTO table ( col1, col2 ) VALUES ('val1', 'val2' )

SELECT (READ)

SELECT * FROM table WHERE col1 = 'val1' AND col2 = 'val2'

UPDATE

UPDATE table set col1 = 'val1', col2 = 'val2' WHERE col3 = 'val3

DELETE

DELETE FROM table WHERE col1 = 'val1'

Database structure