BOOTSTRAP (OSCOMMERCE) ADMIN USER LOGIN RESTRICTION -- 2
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
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