In my controller :
function view($id = null) {
if (!$id) {
$this->Session->setFlash('Salle non valide.');
$this->redirect(array('action'=>'index'), null, true);
}
$this->RessourceSalle->recursive = 2 ;
$this->set('ressourceSalle',$this->RessourceSalle->read(null,
$id));
}
pr($ressourceSalle) returns :
Array
(
[RessourceSalle] => Array
(
[id] => 5
[code] => SRDCG
[libelle] => Salle du rez de chaussée à gauche
[capacite] => 10
[description] => Adaptée pour la bureautique.
[created] => 2007-11-15 11:39:54
[modified] => 2007-11-20 10:05:28
)
[Indispo] => Array
(
[0] => Array
(
[id] => 1
[salle_id] => 5
[code] => INNODB
[date] => 2007-11-15
[ampm] => PM
[amdebut] => 15:21:00
[amfin] => 12:46:00
[pmdebut] => 15:21:00
[pmfin] => 18:21:00
[observations] => Quelqu'un a mal fermé le
robinet,
la salle est innondée !
[bloquant] => 1
[created] => 2007-11-15 15:22:40
[modified] => 2007-11-20 10:06:09
[Salle] => Array
(
[id] => 5
[code] => SRDCG
[libelle] => Salle du rez de chaussée à
gauche
[capacite] => 10
[description] => Adaptée pour la
bureautique.
[created] => 2007-11-15 11:39:54
[modified] => 2007-11-20 10:05:28
)
)
[1] => Array
(
[id] => 3
[salle_id] => 5
[code] => AM
[date] => 2007-11-15
[ampm] => AM
[amdebut] => 16:58:00
[amfin] => 16:58:00
[pmdebut] => 16:58:00
[pmfin] => 16:58:00
[observations] => Nous avons perdu les clefs de la
salle, le serrurier doit passer demain.
[bloquant] => 1
[created] => 2007-11-15 16:59:12
[modified] => 2007-11-15 17:12:45
[Salle] => Array
(
[id] => 5
[code] => SRDCG
[libelle] => Salle du rez de chaussée à
gauche
[capacite] => 10
[description] => Adaptée pour la
bureautique.
[created] => 2007-11-15 11:39:54
[modified] => 2007-11-20 10:05:28
)
)
)
[Stage] => Array
(
[0] => Array
(
[id] => 1
[formation_id] => 1
[formateur_id] => 2
[salle_id] => 5
[min] => 5
[max] => 10
[nbinscrit] => 0
[statut] =>
[observations] =>
[created] => 2007-11-27 09:39:29
[modified] => 2007-11-28 12:19:53
[Formateur] => Array
(
[id] => 2
[code] => A
[qualite] => Mlle
[nom] => ?
[prenom] => Audrey
[adresse] => Quelque part
mais ou
dis donc !
[code_postal] => 507317
[ville] => Massy Palaiseau
[telephone] => 789789789
[fax] => 789789789
[email] => [EMAIL PROTECTED]
[vacataire] => 0
[num_secu] => 456897987
[tarif_jour] => 1000
[observations] =>
[created] => 2007-11-15 12:17:54
[modified] => 2007-11-15 13:22:38
)
[Salle] => Array
(
[id] => 5
[code] => SRDCG
[libelle] => Salle du rez de chaussée à
gauche
[capacite] => 10
[description] => Adaptée pour la
bureautique.
[created] => 2007-11-15 11:39:54
[modified] => 2007-11-20 10:05:28
)
[Formation] => Array
(
[id] => 1
[code] => PHPDEB
[libelle] => PHP Débutant
[domaine_id] => 1
[categorie_id] => 1
[formateur_id] => 3
[nb_jours] => 5
[nb_heures] => 30
[minimum] => 5
[maximum] => 10
[debut_am] => 14:30:00
[fin_am] => 14:30:00
[debut_pm] => 14:30:00
[fin_pm] => 14:30:00
[observations] => Formation de base php
[created] => 2007-11-16 14:30:45
[modified] => 2007-11-16 14:30:45
)
[Stagiaire] => Array
(
)
)
[1] => Array
(
[id] => 3
[formation_id] => 2
[formateur_id] => 5
[salle_id] => 5
[min] => 0
[max] => 0
[nbinscrit] => 0
[statut] =>
[observations] =>
[created] => 2007-11-28 15:33:14
[modified] => 2007-11-28 15:34:37
[Formateur] => Array
(
[id] => 5
[code] => STE
[qualite] => M
[nom] => Monsieur
[prenom] => Stephane
[adresse] => Au fond a droite
puis a gauche
et enfin a droite
[code_postal] => 75009
[ville] => Paris
[telephone] => 0142998675
[fax] => 4564654644
[email] => [EMAIL PROTECTED]
[vacataire] => 0
[num_secu] =>
[tarif_jour] => 0
[observations] =>
[created] => 2007-11-15 12:40:39
[modified] => 2007-11-15 12:52:53
)
[Salle] => Array
(
[id] => 5
[code] => SRDCG
[libelle] => Salle du rez de chaussée à
gauche
[capacite] => 10
[description] => Adaptée pour la
bureautique.
[created] => 2007-11-15 11:39:54
[modified] => 2007-11-20 10:05:28
)
[Formation] => Array
(
[id] => 2
[code] => CYBER
[libelle] => Communication et Cybernétique
[domaine_id] => 3
[categorie_id] => 2
[formateur_id] => 5
[nb_jours] => 4
[nb_heures] => 25
[minimum] => 2
[maximum] => 10
[debut_am] => 10:02:00
[fin_am] => 00:02:00
[debut_pm] => 01:02:00
[fin_pm] => 04:02:00
[observations] =>
[created] => 2007-11-19 10:03:29
[modified] => 2007-11-19 10:03:29
)
[Stagiaire] => Array
(
)
)
)
)
And the sql is :
1 DESCRIBE `ressource_salles`
2 DESCRIBE `ressource_salles_indispos`
3 DESCRIBE `stage_stages`
4 DESCRIBE `ressource_formateurs`
5 DESCRIBE `ressource_formateurs_competences`
6 DESCRIBE `catalogue_formations`
7 DESCRIBE `catalogue_domaines`
8 DESCRIBE `catalogue_axes`
9 DESCRIBE `catalogue_categories`
10 DESCRIBE `catalogue_documents`
11 DESCRIBE `stage_dates`
12 DESCRIBE `stage_documents`
13 DESCRIBE `client_stagiaires`
14 DESCRIBE `client_societes`
15 DESCRIBE `client_contacts`
16 DESCRIBE `stage_stages_stage_stagiaires`
17 SELECT `RessourceSalle`.`id`, `RessourceSalle`.`code`,
`RessourceSalle`.`libelle`, `RessourceSalle`.`capacite`,
`RessourceSalle`.`description`, `RessourceSalle`.`created`,
`RessourceSalle`.`modified` FROM `ressource_salles` AS
`RessourceSalle` WHERE `RessourceSalle`.`id` = 5 LIMIT 1
18 SELECT `Indispo`.`id`, `Indispo`.`salle_id`, `Indispo`.`code`,
`Indispo`.`date`, `Indispo`.`ampm`, `Indispo`.`amdebut`,
`Indispo`.`amfin`, `Indispo`.`pmdebut`, `Indispo`.`pmfin`,
`Indispo`.`observations`, `Indispo`.`bloquant`, `Indispo`.`created`,
`Indispo`.`modified` FROM `ressource_salles_indispos` AS `Indispo`
WHERE `Indispo`.`salle_id` IN (5)
19 SELECT `Salle`.`id`, `Salle`.`code`, `Salle`.`libelle`,
`Salle`.`capacite`, `Salle`.`description`, `Salle`.`created`,
`Salle`.`modified` FROM `ressource_salles` AS `Salle` WHERE
`Salle`.`id` = 5
20 SELECT `Salle`.`id`, `Salle`.`code`, `Salle`.`libelle`,
`Salle`.`capacite`, `Salle`.`description`, `Salle`.`created`,
`Salle`.`modified` FROM `ressource_salles` AS `Salle` WHERE
`Salle`.`id` = 5
21 SELECT `Stage`.`id`, `Stage`.`formation_id`,
`Stage`.`formateur_id`, `Stage`.`salle_id`, `Stage`.`min`,
`Stage`.`max`, `Stage`.`nbinscrit`, `Stage`.`statut`,
`Stage`.`observations`, `Stage`.`created`, `Stage`.`modified` FROM
`stage_stages` AS `Stage` WHERE `Stage`.`salle_id` IN (5)
22 SELECT `Formateur`.`id`, `Formateur`.`code`, `Formateur`.`qualite`,
`Formateur`.`nom`, `Formateur`.`prenom`, `Formateur`.`adresse`,
`Formateur`.`code_postal`, `Formateur`.`ville`,
`Formateur`.`telephone`, `Formateur`.`fax`, `Formateur`.`email`,
`Formateur`.`vacataire`, `Formateur`.`num_secu`,
`Formateur`.`tarif_jour`, `Formateur`.`observations`,
`Formateur`.`created`, `Formateur`.`modified` FROM
`ressource_formateurs` AS `Formateur` WHERE `Formateur`.`id` = 2
23 SELECT `Formateur`.`id`, `Formateur`.`code`, `Formateur`.`qualite`,
`Formateur`.`nom`, `Formateur`.`prenom`, `Formateur`.`adresse`,
`Formateur`.`code_postal`, `Formateur`.`ville`,
`Formateur`.`telephone`, `Formateur`.`fax`, `Formateur`.`email`,
`Formateur`.`vacataire`, `Formateur`.`num_secu`,
`Formateur`.`tarif_jour`, `Formateur`.`observations`,
`Formateur`.`created`, `Formateur`.`modified` FROM
`ressource_formateurs` AS `Formateur` WHERE `Formateur`.`id` = 5
24 SELECT `Salle`.`id`, `Salle`.`code`, `Salle`.`libelle`,
`Salle`.`capacite`, `Salle`.`description`, `Salle`.`created`,
`Salle`.`modified` FROM `ressource_salles` AS `Salle` WHERE
`Salle`.`id` = 5
25 SELECT `Salle`.`id`, `Salle`.`code`, `Salle`.`libelle`,
`Salle`.`capacite`, `Salle`.`description`, `Salle`.`created`,
`Salle`.`modified` FROM `ressource_salles` AS `Salle` WHERE
`Salle`.`id` = 5
26 SELECT `Formation`.`id`, `Formation`.`code`, `Formation`.`libelle`,
`Formation`.`domaine_id`, `Formation`.`categorie_id`,
`Formation`.`formateur_id`, `Formation`.`nb_jours`,
`Formation`.`nb_heures`, `Formation`.`minimum`, `Formation`.`maximum`,
`Formation`.`debut_am`, `Formation`.`fin_am`, `Formation`.`debut_pm`,
`Formation`.`fin_pm`, `Formation`.`observations`,
`Formation`.`created`, `Formation`.`modified` FROM
`catalogue_formations` AS `Formation` WHERE `Formation`.`id` = 1
27 SELECT `Formation`.`id`, `Formation`.`code`, `Formation`.`libelle`,
`Formation`.`domaine_id`, `Formation`.`categorie_id`,
`Formation`.`formateur_id`, `Formation`.`nb_jours`,
`Formation`.`nb_heures`, `Formation`.`minimum`, `Formation`.`maximum`,
`Formation`.`debut_am`, `Formation`.`fin_am`, `Formation`.`debut_pm`,
`Formation`.`fin_pm`, `Formation`.`observations`,
`Formation`.`created`, `Formation`.`modified` FROM
`catalogue_formations` AS `Formation` WHERE `Formation`.`id` = 2
28 SELECT `Date`.`id`, `Date`.`stage_id`, `Date`.`date`,
`Date`.`ampm`, `Date`.`debutam`, `Date`.`finam`, `Date`.`debutpm`,
`Date`.`finpm`, `Date`.`observations`, `Date`.`created`,
`Date`.`modified` FROM `stage_dates` AS `Date` WHERE `Date`.`stage_id`
IN (1, 3)
29 SELECT `Document`.`id`, `Document`.`stage_id`,
`Document`.`descriptif`, `Document`.`fichier`, `Document`.`dir`,
`Document`.`mimetype`, `Document`.`filesize`, `Document`.`created`,
`Document`.`modified` FROM `stage_documents` AS `Document` WHERE
`Document`.`stage_id` IN (1, 3)
30 SELECT `Stagiaire`.`id`, `Stagiaire`.`societe_id`,
`Stagiaire`.`qualite`, `Stagiaire`.`nom`, `Stagiaire`.`prenom`,
`Stagiaire`.`adresse`, `Stagiaire`.`code_postal`, `Stagiaire`.`ville`,
`Stagiaire`.`tel`, `Stagiaire`.`fax`, `Stagiaire`.`email`,
`Stagiaire`.`type`, `Stagiaire`.`observations`, `Stagiaire`.`created`,
`Stagiaire`.`modified`, `StageStagesStageStagiaire`.`stage_id`,
`StageStagesStageStagiaire`.`stagiaire_id` FROM `client_stagiaires` AS
`Stagiaire` JOIN `stage_stages_stage_stagiaires` AS
`StageStagesStageStagiaire` ON (`StageStagesStageStagiaire`.`stage_id`
IN (1, 3) AND `StageStagesStageStagiaire`.`stagiaire_id` =
`Stagiaire`.`id`)
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Cake
PHP" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---
