For the store
I need a simple application / web page (password protected) which will present me sales of a given item in a given period of time. By default, it would display for example the last 30 days, but I would like to be able to change the scale for example
last 7 days
last 30 days
last 12 months
and some arbitrary dates to choose from.
By default, all items on the page are displayed (such a big table)
In each row:
Photo thumbnail | Name| Catalog number| Quantity| Number sold | etc.
Additionally, the filters would allow to choose category/manufacturer/quantity just like in the store.
The table should be able to be sorted by any column.
The script is to be extended with profitability calculations and other stuff, but I care most about the table with the information about the number of sold items.
I don't have any requirements as to how it should be written - it should work on my server with WEB access.
Apart from the price offer, I would also like to see some examples of your work.
All the data is in mySQL but I need to extract it nicely :) and present it properly.