function do_sugg_form($id_suggestion)
{
global $dbh, $charset;
global $recept_deliv_form_sugg, $deflt3receptsugstat;
$sug = new suggestions($id_suggestion);
$tab_orig = $sug->getOrigines();
$form = '';
//Récupération des noms des créateurs des suggestions
$list_orig = '';
if (count($tab_orig)) {
$form = $recept_deliv_form_sugg;
foreach ($tab_orig as $orig) {
switch ($orig['type_origine']) {
default:
case '0':
$q_user = "******" . $orig['origine'] . "'";
$r_user = mysql_query($q_user, $dbh);
$row_user = mysql_fetch_row($r_user);
$list_orig = htmlentities($row_user[1], ENT_QUOTES, $charset);
if ($row_user[2]) {
$list_orig .= ", " . htmlentities($row_user[2], ENT_QUOTES, $charset);
}
$list_orig .= "<br />";
break;
case '1':
$q_empr = "SELECT id_empr, empr_nom, empr_prenom FROM empr where id_empr = '" . $orig['origine'] . "'";
$r_empr = mysql_query($q_empr, $dbh);
$row_empr = mysql_fetch_row($r_empr);
$list_orig .= htmlentities($row_empr[1], ENT_QUOTES, $charset);
if ($row_empr[2]) {
$list_orig .= ", " . htmlentities($row_empr[2], ENT_QUOTES, $charset);
}
$list_orig .= "<br />";
break;
case '2':
break;
}
}
$form = str_replace('<!-- origines -->', $list_orig, $form);
$form = str_replace('!!id_sug!!', $id_suggestion, $form);
$sug_map = new suggestions_map();
if ($sug->statut == $sug_map->getState_ID('ORDERED')) {
$sel_sugstat = $sug_map->getHtmlStateSelect('ORDERED', array(0 => $sug_map->getStateNameFromId($deflt3receptsugstat)), TRUE, array('name' => 'sel_sugstat'));
} else {
$sel_sugstat = $sug_map->getHtmlStateSelect('ORDERED', array(0 => $sug_map->getStateNameFromId($sug->statut)), TRUE, array('name' => 'sel_sugstat'));
}
$form = str_replace('<!-- sel_sugstat -->', $sel_sugstat, $form);
}
return $form;
}
