Remarque : Trying to access array offset on value of type bool ligne 47 (/home/chdznra/www/site/fiche.php)
Remarque : Trying to access array offset on value of type bool ligne 52 (/home/chdznra/www/site/fiche.php)
Remarque : Trying to access array offset on value of type bool ligne 52 (/home/chdznra/www/site/fiche.php)
Remarque : Trying to access array offset on value of type bool ligne 52 (/home/chdznra/www/site/fiche.php)
Remarque : Trying to access array offset on value of type bool ligne 55 (/home/chdznra/www/site/fiche.php)
Remarque : Trying to access array offset on value of type bool ligne 26 (/home/chdznra/www/site/inc/lignedevie.inc.php)
Remarque : Undefined index: ligne 26 (/home/chdznra/www/site/inc/lignedevie.inc.php)
Remarque : Trying to access array offset on value of type bool ligne 26 (/home/chdznra/www/site/inc/lignedevie.inc.php)
Remarque : Undefined index: ligne 26 (/home/chdznra/www/site/inc/lignedevie.inc.php)
Remarque : Trying to access array offset on value of type bool ligne 30 (/home/chdznra/www/site/inc/lignedevie.inc.php)
Remarque : Trying to access array offset on value of type bool ligne 43 (/home/chdznra/www/site/inc/lignedevie.inc.php)
Remarque : Trying to access array offset on value of type bool ligne 58 (/home/chdznra/www/site/inc/lignedevie.inc.php)
Remarque : Trying to access array offset on value of type bool ligne 58 (/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,
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 = 3594
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,
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 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. = 3594
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,
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 = 3594 order by DateTri, E.EventType