Grouping No More Than

Edducation

New member
Hello All,

I am after some assistance/guidance on a new project I am working on.

I run an immersive event that I can only have 10 people per group in each time.

I would like to build a system that a member of staff can input the customers booking id and amount of people in their group, when the customers arrive on site.

Once this data is inputed by the staff member, the system should see if the amount of people in the customers group will fit into an existing group of customers or would a new group need to be created.

e.g.
An existing group (group A) has 3 customers that have checked in waiting to go into the experience. The new customer has 4 people in their booking so they would be able to go in group A as this is less than 10 People.
If the new customer had 10 people in their booking and not 4 people, this would not fit into Group A, and Group B should be created...

This should continue to loop through groups C, D, E, F, G etc....

I have all the submission stuff working to mysql however I have hit a brick wall on the grouping system.

Any help/advice welcome.

Edd
 
Back
Top