The website is to report upon and allow export of data (various formats) from SQL database.
If the site can be built upon Joomla that would be ideal.
Links are required to a number of websites through SOAP api.
The main function of the website is to report upon data in one table of a SQL database.
Users to be able to add categories, and change the allocation of a line in that table. Users only able to see lines allocated to their business
eg mark a line as viewed
mark a line as not viewed
mark a line as type A or type B
mark a line as category A, or B or C or D etc
Allow users to set up new categories
Users to have flexibility on how to view the data
eg by date range and type and category
Export information from the database in various formats
If this can all be built as a component for Joomla that would be very good,
as we can use the inbuilt user management and other components, and the design.
Links to other websites are required using SOAP api. In this proposal 2 other websites, with more to be added later.