Avertissement : Trying to access array offset on false ligne 47 (/home/chdznra/www/site/fiche.php)
Avertissement : Trying to access array offset on false ligne 52 (/home/chdznra/www/site/fiche.php)
Avertissement : Trying to access array offset on false ligne 52 (/home/chdznra/www/site/fiche.php)
Avertissement : Trying to access array offset on false ligne 52 (/home/chdznra/www/site/fiche.php)
Avertissement : Trying to access array offset on false ligne 55 (/home/chdznra/www/site/fiche.php)
Avertissement : Trying to access array offset on false ligne 26 (/home/chdznra/www/site/inc/lignedevie.inc.php)
Avertissement : Trying to access array offset on false ligne 27 (/home/chdznra/www/site/inc/lignedevie.inc.php)
Avertissement : Undefined array key "" ligne 27 (/home/chdznra/www/site/inc/lignedevie.inc.php)
Avertissement : Trying to access array offset on false ligne 27 (/home/chdznra/www/site/inc/lignedevie.inc.php)
Avertissement : Undefined array key "" ligne 27 (/home/chdznra/www/site/inc/lignedevie.inc.php)
Avertissement : Trying to access array offset on false ligne 32 (/home/chdznra/www/site/inc/lignedevie.inc.php)
Avertissement : Trying to access array offset on false ligne 45 (/home/chdznra/www/site/inc/lignedevie.inc.php)
Avertissement : Trying to access array offset on false ligne 60 (/home/chdznra/www/site/inc/lignedevie.inc.php)
Avertissement : Trying to access array offset on false ligne 60 (/home/chdznra/www/site/inc/lignedevie.inc.php)
Erreur fatale : SQLSTATE[HY000]: General error: 1 near "=": syntax error ligne 33 (/home/chdznra/www/site/app/connexion.php)
select
E.DateGed,
E.TriTypeUCD as Evenement,
E.Titre as TitreEvenement,
"individu" as Relation,
I.Prenoms as Prenoms,
NS.Nom as Nom,
I.Sexe as Sexe,
L.Ville,
E.XrefLieu,
SB.Titre as Subdivision,
L.Departement,
L.Pays,
case
when (E.NombreSources > 0) Then E.CodeID
end Source,
case
when (E.NombreSources > 1) Then E.NombreSources
end nbSources,
case
when (E.XrefNote is not Null) Then E.XrefNote
end Note,
Null as NoteUnion,
Null as OrdreUnion,
E.RechercheActe,
E.Cause,
E.XrefIndividuProprio as CodeID,
E.EventType,
case
when (E.EventType = 8 or E.EventType = 6) then (E.DateTri+0.1)
else E.DateTri
end DateTri
from Evenements E
left join Lieux L on L.CodeID = E.XrefLieu
left join Subdivisions SB on E.XrefSubdivision = SB.CodeID
left join Individus I on I.CodeID = E.XrefIndividuProprio
left join Noms NS on I.XrefNom = NS.CodeID
where E.XrefIndividuProprio = 257161
and E.EventType <> 7 union
select
E.DateGed,
E.TriTypeUCD as Evenement,
E.Titre as TitreEvenement,
"individu" as Relation,
I.Prenoms as Prenoms,
NS.Nom as Nom,
I.Sexe as Sexe,
L.Ville,
E.XrefLieu,
SB.Titre as Subdivision,
L.Departement,
L.Pays,
case
when (E.NombreSources > 0) Then E.CodeID
end Source,
case
when (E.NombreSources > 1) Then E.NombreSources
end nbSources,
case
when (E.XrefNote is not Null) Then E.XrefNote
end Note,
U.XrefNote as NoteUnion,
case
when (OU.Ordre is not Null) Then OU.Ordre
end OrdreUnion,
E.RechercheActe,
E.Cause,
I.CodeID as CodeID,
E.EventType,
E.DateTri as DateTri
from Evenements E
left join Unions U on E.XrefUnionProprio = U.CodeID
left join OrdreUnions OU on U.CodeID = OU.XrefUnion
left join Lieux L on L.CodeID = E.XrefLieu
left join Subdivisions SB on E.XrefSubdivision = SB.CodeID left join Individus I on I.CodeID = U.
left join Noms NS on I.XrefNom = NS.CodeID
where U. = 257161
and I.Confidentiel < 1 union
select
E.DateGed,
E.TriTypeUCD as Evenement,
E.Titre as TitreEvenement,
"individu" as Relation,
I.Prenoms as Prenoms,
Ns.Nom as Nom,
I.Sexe as Sexe,
L.Ville,
E.XrefLieu,
SB.Titre as Subdivision,
L.Departement,
L.Pays,
case
when (E.NombreSources > 0) Then E.CodeID
end Source,
case
when (E.NombreSources > 1) Then E.NombreSources
end nbSources,
case
when (E.XrefNote is not Null) Then E.XrefNote
end Note,
NULL as NoteUnion,
NULL as OrdreUnion,
E.RechercheActe,
E.Cause,
LIE.XrefIndividuOrig as CodeID,
E.EventType,
E.DateTri as DateTri
from LienIndividuEvenement LIE
left join Evenements E on E.CodeID = LIE.XrefEvenement
left join Lieux L on L.CodeID = E.XrefLieu
left join Subdivisions SB on E.XrefSubdivision = SB.CodeID
left join Individus I on I.CodeID = LIE.XrefIndividuOrig
left join Noms NS on I.XrefNom = NS.CodeID
where LIE.XrefIndividuOrig = 257161 order by DateTri, E.EventType