Webpage/Jscript Generator in PHP using Joomla 2.5 Contacts

Project: Webpage(Javascript) generator for “Organisation Chart menu” Joomla 2.5 Extension Overall goal: To provide an automated way of building an organisation chart hierarchy from the Joomla contacts list, without separate admin needed. Related Tools: Joomla 2.5 & Organisational Chart Menu Joomla Extension Interface/Audience: There will be no user interaction with this page Validation/Debug Level: Standard, as this is not a critical runtime application Plan: 1. To create separate PHP webpage that we can call via a Cron job or a Button within Joomla (We will handle the call method) 2. To then lookup the Joomla core contacts list (not login list) and obtain (preferably through a Joomla library JDatabase method rather than direct to MySQL to avoid issue after Joomla updates) a. To pickup an agreed field with Joomla contacts that will hold a CODE (to be agreed) that will say what the “parent node id” of this contact is. b. If there is no code, then this contact can be skipped and ignored c. You will need to populate the JavaScript with: id, parented, title, description and a link for the profile image within Joomla (see reference below) 3. To demonstrate the code works manually 4. To provide assistance to implement and test, and remedy accordingly (we will have our development team installing it, so this should be minimal and IT specific) Skills: PHP/Joomla 2.5 (& JDatabase)/JavaScript/MySQL? Process Discussion: 1. We think it might be sensible to create the Javascript required as a separate file and then use a permanent “src” link from the main webpage (is this feasible/sensible?) 2. You may think it better to replace the Hierarchy script page to a PHP page that’s generates the script on-the-fly at runtime, please provide your recommendation? Timescales: We are quoting the client at present, however should they green light it, then we would like a 1-2week turnaround (1wk preferred). Helpful Resources: [login to view URL] [login to view URL] [login to view URL]