WTA Sales Recording System (MSSQL Database)

We are looking for a web developer to create a database driven application. This is on our own MSSQL Server which has a Wordpresss intranet website and PHP on the server.

The initial part of the project will involve linking with our Active Directory users list so only those with assigned permissions will have access to certain menu links. Those who are not assigned permissions will not have the menu link displayed on their intranet page.

Administrators will have access to the HQ link where we will set up our OUTLETS and store this information into the MSSQL database. Once created we can then create some POS TERMINALS belonging to each outlet. Each outlet will have a sales grid on the WTA (see attached image and the information below)

The main part of the project ("WTA") will allow authorised users to access a weekly grid for recording sales and pay out information for trading in a business.

The grid will be a 7 day view (showing Monday to Sunday like the attached image) and the default view is the current week. A date picker will be required to allow users the ability to navigate backwards to a previous 7 day view (Monday to Sunday) to view historical entries.

Where no entries exist in the database for sales information this will display as per the attached image. As sales information becomes available, a user should have the ability to click on the blank '£ - 'and the area clicked becomes a text box to enter or edit a value. This will either INSERT or UPDATE into the database for the relevant date and POS Terminal.

Where we have multiple POS TERMINALS in an OUTLET, a tab will be required to allow a user to navigate between the sales grid for each terminal.

Happy to discuss the project in further detail as offers are submitted. Looking to start on this ASAP.

Remote access can be provided to our web server on Splashtop.

I am based in the UK so ideally someone on a similar time zone.