First of all, this is my first project with codeigniter and grocerycrud, feel free to send me links to tutorials if I ask obvious thnigs I should read. I'm reading since 2 days, and I start now coding as I decided to try codeigniter/grocerycrud on a real project.
My project is the following :
Basically the master object is a room with 14 places or with 5 places and the related tables are people (students) and coaches (teachers) and other extra person (assistant, photograph, ... different type of service) that need to participate. I have to book people in the room, eventually as a group and with coaches and extra persons, and I have to be carefull that the room is not full ;-)
ROOM
room_id
name
max_places
ROOMPEOPLE
room_id
people_id
PEOPLE
people_id
name
group_id
coach_needed (true|false)
extra_needed (true|false)
COACH
coach_id
name
is_available (true|false)
ROOMCOACH
room_id
coach_id
EXTRA
extra_id
name
type
is_available (true|false)
ROOMEXTRA
room_id
extra_id
GROUP
group_id
name
1) I need to be able to add only max_places people in the room.
2) I need to add all people of a same group
3) If a coach is needed, I need to add an available coach too in the room (and if extra are needed, i need to add an available extra too)
4) I need a simple way to define a group (may be checkboxes in the list mode on people, and a "create group" button somewhere that create the group for selected checkboxes
This is the draft concept. I guess many things can be done with grocerycrud, but any help would be appreciated if some of you have already done such a complex CRUD with multiple tables and constraints.