Commit Graph

8 Commits

Author SHA1 Message Date
kougyokugentou 34019b1743 Mock Data. 2021-02-10 14:41:41 -08:00
kougyokugentou 1554dd4abc Add some more code, thinking to do along the lines of "for each day, pull the students first and last in/out record and display it. Forget about if the student checks in or out multiple times, that's too hard.
TODO: for each day, make a new class to display the records in the dgvReport with child displayname, in+in_time, guardian_in, out+out_time, guardian_out, duration.
2021-02-04 22:16:12 -08:00
kougyokugentou 4e1c10d297 This fuckign query took 2 hours to write/debug/think about, so commit it. 2021-02-04 22:11:26 -08:00
kougyokugentou 2cce2560a6 Add trigger to update CURRENT_TIMESTAMP to local time upon insert to Attendance table 2021-02-04 22:11:03 -08:00
kougyokugentou 16940a0ba0 remove timestamp from dob field in mockdata, we don't need that. 2021-02-02 21:11:08 -08:00
kougyokugentou b26114a5f4 Fix mockdata, it was bothering me. 2021-01-30 12:52:24 -08:00
kougyokugentou 6aee50df6d Add more mock data 2021-01-21 22:55:52 -08:00
kougyokugentou c037591451 add documentation 2021-01-18 20:21:36 -08:00