* Joomla website - minor changes required *

A small Australian transport, grain storage and grain marketing company requires some small updates to a website it recently had created in Joomla.

The current site at [url removed, login to view]

The following changes are required:

Requirement #1:

To insert a new, reliable weather feed module onto the front page under the 'weather' tab. The previous module that used the google weather API has been broken. The weather for three locations is to be displayed, as per the headings currently in the table (Nhill, Horsham and Melbourne - all located in Victoria, Australia). A radar map showing cloud cover for the Nhill location is also to be displayed.

Requirement #2:

To simplify the process of updating grain prices. We also have a requirement to display grain prices in a separate tab only when they have been updated, and only for the day that they have been updated. This is currently working (I can demonstrate it to the successful bidder), however it is not user friendly and involves a difficult process of logging in to the joomla admin site and making HTML changes in a couple of places. Not very nice for non technical users. Please see APPENDIX A in the attached PDF file for the details on the current update process.

What we require is:

a) a separate, authenticated section of the site for updating grain prices. Authentication should use Joomla user credentials.

b) the update process should be a simple form with a submit button. The number of prices does not need to change in future. Please allow the name of the three grain types to be changed. The page should remember the last grain types and prices entered.

c) this should be accessible via an private URL (not published to search engines, not linked to on the site) ie. [url removed, login to view]

d) this should be functional and easy to use from any mobile device, especially iOS based

e) with my limited knowledge, a suggested approach (open to your recommendations):

- create a new table in the database called 'GrainPrices'. The table would have the fields 'GrainType', 'GrainCode', 'GrainPrice' and 'Enable'.

- create a new table in the database called 'GrainPriceUpdate'. The table would have a single field 'UpdateDate'.

- create a database trigger that whenever an update is performed or new row added to the 'GrainPrices' table, the current date is written to the 'GrainPriceUpdate' table in the 'UpdateDate' field.

- similarly to what is currently being done, have the grain prices tab only display when the 'UpdateDate' field is equal to todays date (according to the server). I've set this to todays date (06/08/2012) to demonstrate what it currently looks like.

- when the grain prices tab is displayed, dynamically generate the table using PHP based on the data in the 'GrainPrices' database for each grain type.

- create a small page with user authentication where the user can easily update the prices in the table and change the grain type names where required. The number of prices does not need to change if this complicates the approach.

Milestone Payments and Communication:

Payment to the successful bidder will be made in two milestones - each half of the total project cost - the first milestone being paid when requirement #1 is complete and the second when requirement #2 is complete.

The successful bidder must be able to be contacted via Skype to go over the requirement and confirm the approach.

Please let me know if you have any queries or require further information.

CSS HTML Joomla MySQL PHP

Project ID: #2463367

About the project