Javascript Generator Script in PHP Linked to 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) 5. We need basic text displayed when the PHP is run, to show success or failure to build organisational tree webpage 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: 1-2Wks Duration Helpful Resources: [login to view URL] [login to view URL] [login to view URL]