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; }