1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29
|
insert into creche (nom, places) values ('Weill', 10);
insert into enfant (nom, naissance, creche_id) values ('Enfant 1', DATEFROMPARTS(2014, 2, 10), 1);
insert into enfant (nom, naissance, creche_id) values ('Enfant 2', DATEFROMPARTS(2013, 1, 5), 1);
insert into enfant (nom, naissance, creche_id) values ('Enfant 3', DATEFROMPARTS(2003, 10, 17), 1);
insert into qualification (nom) values ('Auxiliaire puéricultrice');
insert into qualification (nom) values ('Auxiliaire petite enfance');
insert into employe (nom, qualification_id, creche_id, heures_hebdo) values ('Mme A', 1, 1, 35 * 2); -- on stock le temps de travail sous forme de demi-heures
insert into employe (nom, qualification_id, creche_id, heures_hebdo) values ('Mme B', 1, 1, 2.5 * 2);
insert into employe (nom, qualification_id, creche_id, heures_hebdo) values ('Mme C', 2, 1, 4 * 2);
insert into employe (nom, qualification_id, creche_id, heures_hebdo) values ('Mme D', 2, 1, 4 * 2);
declare @d1 datetime2;
declare @d2 datetime2;
set @d1 = DATETIMEFROMPARTS(2014, 9, 4, 9, 0, 0, 0);
set @d2 = DATETIMEFROMPARTS(2014, 9, 4, 18, 30, 0, 0);
exec dbo.CreerHoraireCreche 1, @d1, @d2;
set @d1 = DATETIMEFROMPARTS(2014, 9, 4, 10, 0, 0, 0);
set @d2 = DATETIMEFROMPARTS(2014, 9, 4, 15, 0, 0, 0);
exec dbo.CreerHoraireEnfant 1, @d1, @d2;
set @d1 = DATETIMEFROMPARTS(2014, 9, 4, 9, 0, 0, 0);
set @d2 = DATETIMEFROMPARTS(2014, 9, 4, 12, 00, 0, 0);
exec dbo.CreerDisponibiliteEmploye 1, @d1, @d2;
set @d2 = DATETIMEFROMPARTS(2014, 9, 4, 16, 00, 0, 0);
exec dbo.CreerDisponibiliteEmploye 2, @d1, @d2;
exec dbo.CreerDisponibiliteEmploye 3, @d1, @d2;
exec dbo.CreerDisponibiliteEmploye 4, @d1, @d2; |
Partager