php/mysql

We need an email and database client with the following functionalities: An outlook-like web mail client and a database interface that allows users to search a mysql database and fetch matching email messages from an email server. The database is populated by us by preprocessing mailboxes. Programmers need to establish its link with the email server for fetching messages based on database queries. The web mail client may be based on zimbra or other acceptable open source software. It must have full email functionality (attachments, cc, bcc, addressbook etc) and database query capability. Details: We pre-process email messages that are received by a user and write certain characteristics of messages into the database. The email that was processed is put in the user's mailbox. The user logs on to our system to read emails and do some advance searches in his inbox using the database. This is similar to IMAP search, but more advanced. The search function will be basically some numeric and string comparisons against the database. The database need to contain links to email messages in the user's mailbox, which will be used to access email bodies when the user wants to open a message that is fetched after a search. If the user does not do a search, he will reach his inbox, and will be able to read his email and perform other email functions as with an ordinary email client. ## Deliverables [login to view URL] requirements notice: As originally posted, this bid request does not have complete details. Should a dispute arise and this project go into arbitration "as is", the contract's vagueness might cause it to be interpreted against you, even though you were acting in good-faith. So for your protection, if you are interested in this project, please work-out and document the requirements onsite.