BOOTSTRAP (OSCOMMERCE) ADMIN USER LOGIN RESTRICTION -- 2

Job ID: 37794991

Budget: $30 – $250 USD

i need to LINK the ADMINISTRATORS table to the STORES_CONFIG to restrict what certain users see when logged in.
Example suppose we have 3 administrators or users then we might have a setup as:-

1. MASTER ADMIN (ME) - linked to "configuration" > SEES TOTAL SALES FOR ALL STORES
2. STORE 1 ADMIN - linked to config_store1 > SEES TOTAL SALES FOR STORE ID = 1 only
3. STORE 2 ADMIN - linked to config_store1 > SEES TOTAL SALES FOR STORE ID = 2 only

this means we need a column in the ADMINISTRATORS table called "STORES_CONFIG_TABLE"
then each user will be connected to a stores_config table.
Note: we can even make a new table called STORE_MANAGERS if thats easier and ill provide a different url path for access.
In case of the MASTER ADMIN they will have access to ALL STORES stores config table is set as configuration for this.

note: it is technically possible to have more than 1 store connected to 1 user login the user may manage 2 stores, so we will just add 2 store config_tables in that case and will load the first by default then if they want to load the second they will get a list at the top of the dashboard.

I will also restrict what store managers can see on their dashboards
dont worry a lot about all of the technicalities just now
to start lets get the user login restrictions in place
this will involve STORES_ID join

each config table has a STORES_ID and that is recorded in the stores table also
we have stores_config_table stores_id

e.g

store config name stores ID

config_tomsdiner 1
config_pizzashop 2

then any data which is CALLED using MYSQL queries we need to add some sort of JOIN or WHERE CLAUSE or AND condition
e.g QUERY....................... bla bla WHERE stores_id = 2


etc
NO TIME WASTERS
NEED THIS DONE FAST
Related categories: PHP Website Design OSCommerce MySQL Bootstrap