We require a very smart looking display of items in either a MySQL database OR in a path/subfolder.
The display will comprise a timeline scaled to suit the lowest and highest date/time in the database/path.
The display will show on that timeline the days as separate colours depending on the number of items in the database for that day, for example green = lowactivity, red = high activity. The software will have to automatically scale the activity depending on the overall number of items/day.
clicking on the day will change the display to show hours, however, at this stage the display needs to change to a series of graduated colours showing activity, however, a separate thin line for each type of file - for example JPG, MPEG, MPG.
So, for example, we should have a very pretty graphical display showing each type of recording in the database with the cluster of recording as a hot spot colour, ideally graduated going through the green/orange/red/purple/red/orange/green sequence. With purple being the highest level.
Ask away.... as I am sure there will be many questions.