type_origine = $type_orig;
switch ($quoifaire) {
case 'ajout_origine':
$sug_ori->save();
break;
case 'suppr_origine':
$sug_ori->delete($sug_ori->num_suggestion,$sug_ori->origine,$sug_ori->type_origine);
break;
}
}
$list_user = "";
$req_select = suggestions_origine::listOccurences($id_sugg);
$res = mysql_query($req_select,$dbh);
$nb_user = 0;
while(($user = mysql_fetch_object($res))){
switch($user->type_origine){
default:
case '0' :
$requete_user = "SELECT userid, nom, prenom FROM users where userid = '".$user->origine."'";
$res_user = mysql_query($requete_user, $dbh);
$row_user=mysql_fetch_row($res_user);
$lib_orig = $row_user[1];
if ($row_user[2]) $lib_orig.= ", ".$row_user[2];
$suppr_click = "onClick=\"if(confirm('".$msg['confirm_suppr_origine']."')){ ajax_suppr_origine('".$user->origine."','".$user->type_origine."');}\"";
if(empty($premier_user) || !isset($premier_user)) $premier_user = $lib_orig;
else $list_user .= $lib_orig."
";
break;
case '1' :
$requete_empr = "SELECT id_empr, empr_nom, empr_prenom FROM empr where id_empr = '".$user->origine."'";
$res_empr = mysql_query($requete_empr, $dbh);
$row_empr=mysql_fetch_row($res_empr);
$lib_orig = $row_empr[1];
if ($row_empr[2]) $lib_orig.= ", ".$row_empr[2];
$suppr_click = "onClick=\"if(confirm('".$msg['confirm_suppr_origine']."')){ ajax_suppr_origine('".$user->origine."','".$user->type_origine."');}\"";
if(empty($premier_user) || !isset($premier_user)) $premier_user = $lib_orig;
else $list_user .= $lib_orig."
";
break;
case '2' :
if($user->origine) $lib_orig = $user->origine;
else $lib_orig = $msg['suggest_anonyme'];
$suppr_click = "onClick=\"if(confirm('".$msg['confirm_suppr_origine']."')){ ajax_suppr_origine('".$user->origine."','".$user->type_origine."');}\"";
if(empty($premier_user) || !isset($premier_user)) $premier_user = $lib_orig;
else $list_user .= $lib_orig."
";
break;
}
$nb_user++;
}
$ajout_create = "
";
$list_user .= $ajout_create;
if(mysql_num_rows($res) > 1){
$result = gen_plus('ori_ajax',$msg['suggest_creator']. " (".($nb_user-1).")",$list_user,0);
} else if(mysql_num_rows($res) == 1){
$result = $list_user;
}
ajax_http_send_response($result);
}
?>