Requirement: A PHP / MySQL powered script which looks up a contract number input by a user against a database and retrieves a displays a page which pulls back information from a table row about the department which services those contracts. A range of contract numbers will be serviced by any given department but their format varies. For example, one may be 6 digits long with two letters then 4 numbers but another could be 10 digits long due to a history of acquiring other companies. An admin panel behind login is required to allow non developers to updated the content of the database. There are several caller types which will also need to be taken into account when pulling back the department. For example, the phone number may vary based on the type of caller. I'm happy for the admin user to specific a alphanumeric range and a contract number length in the MySQL for the call handler's input to be validated against. Each department may have multiple email addresses or phone numbers for a specific caller type. Basically, the purpose of this system is to empower a call handler to redirect misdirected calls to the correct department.
What's not required: We'll handle the user interface design, please provide an unstyled raw valid XHTML output for each screen.