DROP FUNCTION IF EXISTS personne_cherche(prm_token integer, prm_nom character varying, prm_prenom character varying);
DROP FUNCTION IF EXISTS personne_cherche(prm_token integer, prm_nom character varying, prm_prenom character varying, prm_type character varying);
DROP FUNCTION IF EXISTS personne_cherche(prm_token integer, prm_nom character varying, prm_prenom character varying, prm_type character varying, prm_grp_id integer);
+DROP FUNCTION IF EXISTS personne_cherche(prm_token integer, prm_nom character varying, prm_prenom character varying, prm_type character varying, prm_grp_id integer, prm_sta_id integer);
DROP FUNCTION IF EXISTS personne_cherche2(prm_token integer, prm_nom character varying, prm_prenom character varying, prm_type character varying, prm_secteur character varying);
DROP FUNCTION IF EXISTS personne_cherche_avec_lien(prm_token integer, prm_nom character varying, prm_prenom character varying, prm_type character varying, prm_grp_id integer, prm_per_id integer);
DROP FUNCTION IF EXISTS personne_cherche2_avec_lien(prm_token integer, prm_nom character varying, prm_prenom character varying, prm_type character varying, prm_secteur character varying, prm_per_id integer);
END;
$$;
-CREATE OR REPLACE FUNCTION personne_cherche(prm_token integer, prm_nom character varying, prm_prenom character varying, prm_type character varying, prm_grp_id integer) RETURNS SETOF personne_cherche
+CREATE OR REPLACE FUNCTION personne_cherche(prm_token integer, prm_nom character varying, prm_prenom character varying, prm_type character varying, prm_grp_id integer, prm_sta_id integer) RETURNS SETOF personne_cherche
LANGUAGE plpgsql
AS $$
DECLARE
AND (prm_prenom ISNULL OR personne_info_varchar_get(prm_token, per_id, 'prenom') ilike prm_prenom || '%')
AND ent_code = prm_type
AND (prm_grp_id ISNULL OR (personne_groupe.grp_id = prm_grp_id AND CURRENT_TIMESTAMP BETWEEN COALESCE(personne_groupe.peg_debut, '-Infinity'::timestamp) AND COALESCE (personne_groupe.peg_fin, 'Infinity'::timestamp)))
+ AND (prm_sta_id ISNULL OR (prm_sta_id = personne_info_integer_get(prm_token, per_id, 'statut_usager')))
ORDER BY COALESCE (personne_info_varchar_get(prm_token, per_id, 'nom') || ' ', '') || COALESCE (personne_info_varchar_get(prm_token, per_id, 'prenom'), '') ||
(CASE WHEN prm_type = 'usager' THEN ''
WHEN prm_type = 'famille' THEN ''