**Project description**:
Within a Joomla 1.7 article, only available for registered users, I want to have a RSFormPro form which will be used to update / change mySQL database content.
On top of the page, information is displayed from the mySQL Joomla database. (20 rows visible, scroll down window, sorted on date)
Information should be filtered based on the area_code and skill_code of the registered user and with the status_code OPEN.
So: area_code_user = area_code_request
skill_code_user =service_type_request
status_code_request = OPEN
The database table holds records filled with requests for services.
Customer name, address, city, area_code, telnr.,email, service_type, service_date, status_code (default = OPEN), id_nr, name_provider (default empty), jobinfo (default empty)
Data about registered service providers are also stored in the database.
Provider name, address, city, area_code, telnr, email, skill_type, password, id_nr.
Below the displayed service requests a small form must be displayed where the registered user (service provider) can add data to a selected record.
Data to be filled in:
request_id_nr
jobinfo
By submitting this form a confirmation page must be shown, where all the new record data is displayed, including the new data, the name of the provider and the status_code of this job should be changed to HANDLED.
User will have to confirm or return to form.
After confirmation an e-mail message should be send to the customer and provider to confirm job handling.