Bug again

A colleague from Guangzhou subsidiary asked me for help that there is negative compensatory leave time in an employee's account in their OA system. In our context of OA system, if an employee works overtime, he can ask for the same compensatory leave time in the future. In the case of Guangzhou, this means that the employee had applied for leave time more than his overtime. In general, this won’t happen, so I thought it must be a bug in the OA system.

I had dealt with such cases before, because they had changed the working hours in one day for this employee, and the employee applied overtime by day, it would result in the wrong compensatory leave time.

So I converted the overtime days to hours and minutes by a line of SQL, problem solved. But the bug still exists in the OA system. It was no a big deal, I had more important work to do.