Re: db design and WOIFrame or AJaxUpdateCOntainer
Re: db design and WOIFrame or AJaxUpdateCOntainer
- Subject: Re: db design and WOIFrame or AJaxUpdateCOntainer
- From: WebObjects <email@hidden>
- Date: Fri, 3 Oct 2008 19:48:47 -0500
LOL... aguardiente would be fine. or maybe Cerveza??? :/
ok so after the relax I took.
id endDateTime idealEmployees maxEmployees minEmployees
startDateTime
1 12::00 6 8 4 09:00
2 15:00 6 8 4 12:00
3 18:00 7 8 6 15:00
4 21:00 6 7 5 18:00
5 13:00 8 9 6 10:00
6 16:00 7 10 6 13:00
7 19:00 7 10 6 16:00
8 13:00 5 6 4 10:00
9 16:00 4 5 3 13:00
this table its fixed... so far... if in six months the admin wats to
change the turn he can do it, via de properties file, or something
like that... hadn;t think about that yet. am I right.?
It will grow as the Admin sets up each week worth of WorkDays and
what Turns they have.
Hold it on the grid! I thought that the WorkDay table which its
related with Turn, will have the Turn and the day for which that Turn
apply to.
I have to questions here, one of them might be my confusion of all.
What I had in mind, or thought, is that each time an Employee takes a
turn for a particular day (mon-sun) , this WorkDay will be filled,
ie. if I, as employee select the monday from the calendar, then select
the turn 1, .. then what..... I create an instance of WorkDay, then an
Instance of EmpleadoTurno then.. I set the relationship.. and then I
save the changes.
so I will have on my tables the follwing.
WorkDay:
id dayOfWeek idTurn startingDateTime
1 Monday 1 09:00
and the EmployeeTurno
id idEmployee idTurn creationTimeStamp
1 1 1 "whatever"
and if I the next week I wanna take the same turn for the same day...
then what.. can I do that? my mind its cloudily thinking that at the
end I will try to insert on EmployeeTurn the same data that I did
already... or this is handled by EOF
2. how is possible that each week the admin should set up the turns.
Im assuming that the turns "may" change in the time, but will not
occur so often, but eventually they will change as you mentioned.
in the WorkDay the startingDateTime, is necessary? , i mean if I have
the id o f th eurn, I have already the startintg time no?
if one day you come to colombia I invite you a beer, or aguardiente if
you like more.
Gus
This WeekDay its confusing me, in sort a way.
On Oct 3, 2008, at 3:47 PM, David Avendasora wrote:
On Oct 3, 2008, at 4:09 PM, WebObjects wrote:
AHA!.. so ... Im starting to understand something... The WorkDay
you suggest to add, will keep track of each single day, so that
table will grow up each day an employee register for a turn.
It will grow as the Admin sets up each week worth of WorkDays and
what Turns they have.
lets suppose the admin, based on a properties file, generate the
turns, from mon-fri on a 3hrs/turn for 12hrs /day, that give us a
4 turns per day. Sat from 10 till 7 and sun from 10 - 4. So on
the Turn will go:
ie.
id endDateTime idealEmployees maxEmployees minEmployees
startDateTime
1 12::00 6 8 4 09:00
2 15:00 6 8 4 12:00
3 18:00 7 8 6 15:00
4 21:00 6 7 5 18:00
5 13:00 8 9 6 10:00
6 16:00 7 10 6 13:00
7 19:00 7 10 6 16:00
8 13:00 5 6 4 10:00
9 16:00 4 5 3 13:00
Yes.
and on WorkDay will go.
id dayOfWeek idTurn startingDateTime
1 Monday 1 09:00
2 Monday 2 12:00
and so on...
isn't it?
Exactly.
then when a employee register for a turn he will select a day,
lets say Tuesday, based on a calendar, then I will fetch all the
turns for tuesday and display them on the "tabl, form" im not
worrying about how to displaying now, (Im following your advice
David, :P),
and he will select the turn 3 lets say. so that;s it from
15:00 to 18:00, (im not considering validating that it has the
required employees now and other stuff, lets asume he can select
that one).. so when he will click on the submit button... what I
will have to do is.
I have the employee now, (he logged in already) I have the Date
and turn he wants to work at
And which Turn he wants.
, so I will have to add to EmplyeeTurn .............................
Exactly. You now have all the pieces you need to create the
EmployeeTurn object that will tie everything together.
im gonna take a break.....
¿Cervesa o Aguardiente?
I hate db!.
thanks
Gus
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden