I have a circumstance that calculates the user working time, every user has to login and logout per day. Of course when day logout, I will store the time in my table, let call it "tbl_Checkin".
So, I have 2 problems:
When the user did not logout of the system, that means I cannot keep track the logout time of them -> Can not calculate the total time that the user worked
When the user work as OT, so they have to be alert and make a confirm their working extra times, so the system won’t logout the user.
In the first situation, I want to set up a time limit for the user, if after 17:30 they still stay in the system, I could ask or auto logout and save the time
But how can I create a trigger time in Yii?
Any suggestion to solve my problems?