Menu
Community /Pin to ProfileBookmark
@NogDogAug 04.2011 — #If this is database-driven (which it sounds like it [i]should[/i] be), then it should be fairly simple to control via the DB design and the SQL. For instance, the user table might be something like:
SQL to get $number users for a given site that are available:
The same structure could then be used to update the table to change their availability. (You would probably want to use table locking so that both queries could be executed in sequence without worrying about anyone else changing that available status of any users in between the two.)
Building a PC User allocation system
Hi all.
I’m looking to build a website in PHP for the training team in my work place. They have an allocation of PC Users to use whilst in the training environment.
For arguments sake lets say:
Site1Usr1 to Site1Usr80
Site2Usr1 to Site2Usr80
Site3Usr1 to Site3Usr80
A list of trainers will have access to the site. Trainer A will log on and say I need 24 users, at site 1. The website will allocate the first 24 available users on site 1.
The site will remember that Trainer 1 has these 24 users. If the trainer has any difficult in using any of the PC Users, they can mark the PC user as faulty. The site will pull the PC user from this Trainer, find the next available free PC User and add this to the users assigned to them.
The bit I can see being the biggest challenge is – A Trainer needs 30 users. Users 1 to 40 are free, but user 22, 26 and 28 are out of use because we’re waiting for IT to fix these accounts. How would I build it to allocate user 1-21,23 – 25,27, 29-33?
Or am I trying to build something here that’s already out there as a polished and working product?
Your advice, guidance and knowledge is welcomed.
Sign in
to post a comment2 Comments(s) ↴
0
@NogDogAug 04.2011 — #If this is database-driven (which it sounds like it [i]should[/i] be), then it should be fairly simple to control via the DB design and the SQL. For instance, the user table might be something like:<i>
</i>id (int, auto-increment, primary key)
user_name (varchar)
site_id (int, foreign key to site table)
in_use (tinyint [0 = in use, 1 = available])
(You'd probably have a unique index on the combined user_name/site_id fields.)
SQL to get $number users for a given site that are available:
[code=php]
$siteID = 1;
$numberNeeded = 20;
$sql = "
SELECT * FROM user
WHERE site_id = $sitedID AND available = 1
ORDER BY user_name LIMIT $numberNeeded
";
[/code]The same structure could then be used to update the table to change their availability. (You would probably want to use table locking so that both queries could be executed in sequence without worrying about anyone else changing that available status of any users in between the two.)
[code=php]
$sql = "
UPDATE user SET available = 0
WHERE site_id = $sitedID AND available = 1
ORDER BY user_name LIMIT $numberNeeded
";
[/code]