Writing a WEB application that extracts the number of sold items from MySQL database at specific time intervals from an online store based on ShopGold script

Closed job
Mikrusy
Mikrusy
Employer
5 deals
Job category:
Desktop/web applications
Expected budget:

Negotiable

Published:
Valid until:

Job description

For the store

https://mikrusy.pl/

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.

Required functions:

Submitted offers 2