454 |
// du dossier d'instruction en cours |
// du dossier d'instruction en cours |
455 |
$sql = "SELECT |
$sql = "SELECT |
456 |
evenement.evenement, |
evenement.evenement, |
457 |
CONCAT(evenement.libelle, ' ['||evenement.action||']') as lib |
evenement.libelle as lib |
458 |
FROM ".DB_PREFIXE."dossier |
FROM ".DB_PREFIXE."dossier |
459 |
INNER JOIN ".DB_PREFIXE."lien_dossier_instruction_type_evenement |
INNER JOIN ".DB_PREFIXE."lien_dossier_instruction_type_evenement |
460 |
ON dossier.dossier_instruction_type=lien_dossier_instruction_type_evenement.dossier_instruction_type |
ON dossier.dossier_instruction_type=lien_dossier_instruction_type_evenement.dossier_instruction_type |
482 |
$form->setSelect("evenement", $contenu); |
$form->setSelect("evenement", $contenu); |
483 |
} else { |
} else { |
484 |
$sql = "SELECT |
$sql = "SELECT |
485 |
CONCAT(evenement.libelle, ' ['||evenement.action||']') as lib |
evenement.libelle as lib |
486 |
FROM ".DB_PREFIXE."evenement |
FROM ".DB_PREFIXE."evenement |
487 |
WHERE evenement.evenement=".$this->getVal("evenement").""; |
WHERE evenement.evenement=".$this->getVal("evenement").""; |
488 |
$res = $db->getone($sql); |
$res = $db->getone($sql); |