@bennouna The scope of this app is in house developed for in house use. The aim of this is to get rid of paper time sheet, better staff time management, connect everything from quote->job/task->invoice, reduce the work load of manager in term of technician work time approval, check out cheat technicians, and follow up with serious issue.
This app does have hardware allocated to task, how many technician working on task and total working time for each technician on any single task. This app, according to the boss, is 80% of what he wanted.
@Da:Sourcerer I am the only coder, do everything from scratch, and I work on this app according to what the boss want me to do, plus first time with MVC framwork and Yii

. I admit that I do have some text fields on boolean values, probably copy and paste or change database design, I have to go back and check them all, with proper default value. Thanks for pointing that out.
I don't make use of Yii's validation system. I have problems with it since I start and don't use it at all (or I was very inexperience with Yii a year ago

). Probably I need to go back and review about it.