Avertissement : Trying to access array offset on false ligne 51 (/home/chdznra/www/site/fiche.php)
Avertissement : Trying to access array offset on false ligne 29 (/home/chdznra/www/site/inc/lignedevie.inc.php)
Avertissement : Trying to access array offset on false ligne 30 (/home/chdznra/www/site/inc/lignedevie.inc.php)
Avertissement : Undefined array key "" ligne 30 (/home/chdznra/www/site/inc/lignedevie.inc.php)
Avertissement : Trying to access array offset on false ligne 30 (/home/chdznra/www/site/inc/lignedevie.inc.php)
Avertissement : Undefined array key "" ligne 30 (/home/chdznra/www/site/inc/lignedevie.inc.php)
Avertissement : Trying to access array offset on false ligne 35 (/home/chdznra/www/site/inc/lignedevie.inc.php)
Avertissement : Trying to access array offset on false ligne 48 (/home/chdznra/www/site/inc/lignedevie.inc.php)
Avertissement : Trying to access array offset on false ligne 63 (/home/chdznra/www/site/inc/lignedevie.inc.php)
Avertissement : Trying to access array offset on false ligne 63 (/home/chdznra/www/site/inc/lignedevie.inc.php)
Erreur fatale : SQLSTATE[HY000]: General error: 1 near "=": syntax error ligne 30 (/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.Shared == 0 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