I'm looking for a PHP/MySQL ticket/helpdesk solution that combines project management, bug reporting, and general it ticket management into a single streamlined system.

Open source and a clean look is vital.

We have 1 IT guy and 2 web guys and we'd like for our non-it manager to be able to review the projects in the works and keep track of what's going on.