For over a year I have worked at Luma Pictures reworking their project and resource management software. BigBrother is the all in one solution for just about everything.
BB includes staff management tools: payroll, timesheets, task time tracking, vacation calendar, sick day tracking, and staff details. It's produciton related tools include barcode scaning for IO, task management, drag and drop delivery management, a shot breakdown by element, artist, and changes. It also includes over 40 differnt reporting tools for comparing shots, elements, disk space, and time spent on a shot.
When I arrived at Luma BB was a collection of hundreds of php scripts modified over the years. It is now a 160k line MVC Caffeine PHP application using Mootools and Mocha UI.