Project Detail

Description

We seek an experienced php programmer to modify the code of an open source project to our needs.

This should be a small and quick project, but if you deliver these modifications successfully we could retain you for this project as well as other ongoing projects in our pipeline.

This program utilizes some complex php code and mySQL queries therefore please make sure you are comfortable with advanced level php/mySQL.

If you are just starting out writing/understanding php, please do not bid as we are only interested in experienced programmers. That saves us both time.

Qualified candidate should be comfortable with mySQL joins as well as writing optimized/efficient queries in mySQL and php code.

We will provide you ftp as well as cPanel access to our server. You will be able to use ftp to do modifications and work directly on our server. Through cPanel login you will be able to take first hand look at mysql table structures (using phpMyAdmin).

This is a long term project and if initial modifications go well, there's a good chance we may retain your services for further modifications to this project as well as development work our other projects.

IMPORTANT: You have to be prepared to communicate with us via phone or at least via instant messaging. If you do not speak english or are not comfortable speaking to us directly or communicating via IM, then please do not bid.


To get an idea of what you will be working on, please visit:

http://phon-exus.com (please remove the hyphen - )
username for admin interface = admin
password for admin interface = demo

If you wish to take a look at the code, please email us and we will provide that to you.


What we need.

1- In the main page where all helpdesk tickets are displayed, we need an extra column titled 'Conversation' where for each and every ticket all messages sent by the customer and the responses given by the agent are displayed. We want to be able to show the latest 250 characters of the conversation and the entire conversation visible by pointing the mouse over the conversation field (possibly ajax).

The code for the entire conversation is already available in the viewtickets.php page where the whole conversation is shown, however we need help in utilizing that code on the main admin page (where all tickets are displayed).



2- Create a form at the bottom of the page (one text box for subject, and one text area for message) which we can use to send email to individual customers by checking the checkbox next to their ticket ID. Its essentially a group email message that we have to be able to send only to customers whos tickets have a checkmark next to them.

Basically that would include converting the individual checkboxes to an array and using mail function to process mail that way.

Please note, if you find the current code complex to modify and instead are interested in writing your own php code to access the database and display the results, we are open to that as long as functionality is not compromised.

Payment in full upon completion of the project and its demonstration to our satisfaction. Good luck


Additional information submitted:

10/12/2008 at 12:51 EDT:
The link to the admin interface is:

http://phonexus.com/admin.php