Add the analytics part to a ready made application Wifi Access Point solution

This is short version as a space limitation had occurred. Anyway the full version is availiable in the PDF attached. So see the mockup provided in the attachment area. For a multi-location Wifi solution we provided we are using FreeRADIUS as the authentication backend. We are storing all information in central database (MySQL) The installation has minor adoptions in the datatable structures. For the propose of analytics we are creating a reporting / charting solution which shall seemless integrate in the existing backend. Enduser can use free Wifi by entering the system and confirm their credentials by a text-message (SMS) send to their phone. Basically the authentication system will associate a MAC adress with a credential. The FreeRadius DB will collect and store all registration requests, login and logoff. So we can use the information here to create a usage profile and also and create some analytics reports. Besides a HTTP sniffer is collecting (non-secure) url targets. This data is stored in text-files at is loaded on a daily basis from all locations to the central data storage. We would prefer to load these data first to a database where map-reduce could be used, e.g. mongoDB, couchDB, etc. In case I would prefer to transfer the data first into a "data warehouse"; so combining the SQL data and the textual data into a single data storage. The system finally should show various metrics and should allow admin users should be able to select and aggregate the data. The system should be integrate into the frontend javascript library QooxDoo and use a javascript charting lib e.g. [login to view URL] and/or [login to view URL] For the frontend UI will be fully javascript based loading the data via "Ajax". The backend here must be implemented in PHP and must create PHP arrays. The response wrapping to JSON and the request processing is done by a ready made PHP setup (QooxDoo RPC backend). We can provide sample code here but also help with integration strategy. What is absolutely essential is the setup of the selected Chart Libraries into QooxDoo contribution modules. We are expecting 3 different stages of deliveries. Please specify these stages within your milestone planning. First I like to see a rough plan of how data is stored and aggregated. And also which Javascript charting lib is fitting. Also we would need a set of API methods signatures that we would need here. Maybe we might be fine which a single call here ? Also a prototype of the UI (in QooxDoo) should be shown here; so to demo that you are able to work with the framework. Second I like to see the data gathering actions. So loading all the data into the data warehouse. Connecting and combining the URLs-files in. A contrib for the selected charting lib should be done already. Maybe a single aggregation is already done. Third step should be the final delivery. We will test and approve the system and integrate it into our existing setup. And finally please confirm that you had read till the end and please do a little math and start your proposal with "the answer is 38+4" :)