case "editPage": include "inc/admin/editPage.php"; break; case "batchLicence": include "inc/user/batchLicence.php"; break; case 'mesInterets': $i = new archiInterest(); echo $i->displayMyInterest(); break; case 'saveInterest': $i = new archiInterest(); echo $i->saveInterest(); break; case 'deleteInterest': $i = new archiInterest(); echo $i->deleteInterest(); break; case 'lienOpendata': $s = new archiAccueil(); echo $s->afficherOpendata(); break; case 'profil': $u = new archiUtilisateur(); echo $u->displayProfile($_GET['idUtilisateur']); break; case 'profilPublique': $u = new archiUtilisateur(); $u->getPublicProfil($_GET['idUtilisateur']); break; case 'profilPrive':
public function getLatestModification($nbElts) { $interest = new archiInterest(); $auth = new ArchiAuthentification(); $whereSimple = "WHERE ae.idAdresse IS NOT NULL "; $whereSimpleArray = array(); if ($auth->estConnecte()) { $arrayInterest = $interest->getFavorisByCategories(); if (!empty($arrayInterest)) { if (isset($arrayInterest['rue'])) { $fieldRue = implode(',', $arrayInterest['rue']); $subClause[] = "ha.idRue in ({$fieldRue})"; foreach ($arrayInterest['rue'] as $idRue) { $whereSimpleArray[] = "ha.idRue = " . $idRue . " "; } } if (isset($arrayInterest['sousQuartier'])) { $fieldSousQuartier = implode(',', $arrayInterest['sousQuartier']); $subClause[] = "ha.idSousQuartier in ({$fieldSousQuartier})"; foreach ($arrayInterest['sousQuartier'] as $idSousQuartier) { $whereSimpleArray[] = " ha.idSousQuartier = " . $idSousQuartier . " "; } } if (isset($arrayInterest['quartier'])) { $fieldQuartier = implode(',', $arrayInterest['quartier']); $subClause[] = "ha.idQuartier in ({$fieldQuartier})"; foreach ($arrayInterest['quartier'] as $idQuartier) { $whereSimpleArray[] = " ha.idQuartier = " . $idQuartier . " "; } } if (isset($arrayInterest['ville'])) { $fieldVille = implode(',', $arrayInterest['ville']); $subClause[] = "ha.idVille in ({$fieldVille})"; foreach ($arrayInterest['ville'] as $idVille) { $whereSimpleArray[] = " ha.idVille = " . $idVille . " "; } } if (isset($arrayInterest['pays'])) { $fieldPays = implode(',', $arrayInterest['pays']); $subClause[] = "ha.idPays in ({$fieldPays})"; foreach ($arrayInterest['pays'] as $idPays) { $whereSimpleArray[] = " ha.idPays = " . $idPays . " "; } } if (!empty($subClause)) { $whereClause .= " AND (" . implode(' OR ', $subClause) . ")"; } if (!empty($whereSimpleArray)) { $whereSimple .= " AND (" . implode(' OR ', $whereSimpleArray) . ")"; } $leftjoinCondition = "AND " . implode(' AND ', $whereSimpleArray); } } $requeteElements = "select * from (\n \t\t\t\t\t SELECT\n\t\t\t\t\t ee.idEvenement as idEvenementGroupeAdresse,\n\t\t\t\t\tevt.idEvenement AS idEvenement,\n\t\t\t\t\tae.idAdresse,\n\t\t\t\t\tnull as idPersonne,\n\t\t\t\t\tevt.idEvenementRecuperationTitre ,\n\t\t\t\t\tevt.idImagePrincipale AS idHistoriqueImage,\n\t\t\t\t\tte.nom as typeEvenement,\n\t\t\t\t\tdate_format(evt.dateCreationEvenement," . _('"%e/%m/%Y"') . ") as dateCreationEvenement,\n\t\t\t\t\tDATE_FORMAT(evt.dateCreationEvenement, '%Y%m%d%H%i%s') as DateTri,\n\t\t\t\t\tevt.description,\n\t\t\t\t\t'adresse' as type\n\t\t\n\t\t\t\t\tFROM evenements evt\n\t\t\t\t\tLEFT JOIN _evenementEvenement ee on ee.idEvenementAssocie = evt.idEvenement\n\t\t\t\t\tLEFT JOIN _adresseEvenement ae ON ae.idEvenement = ee.idEvenement\n\t\t\t\t\tLEFT JOIN historiqueAdresse ha on ha.idAdresse = ae.idAdresse\n\t\t\t\t\tLEFT JOIN typeEvenement te ON te.idTypeEvenement = evt.idTypeEvenement\n\t\t\n\t\t\t\t\tWHERE ae.idAdresse IS NOT NULL\n\t\t \t\t\t" . $whereClause . "\n\t\t\n\t\t\t\t UNION\n\t\t\t\t SELECT\n\t\t\t\t ee.idEvenement as idEvenementGroupeAdresse,\n\t\t\t\t evt.idEvenement AS idEvenement,\n\t\t\t\t\tNULL as idAdresse,\n\t\t\t\t\tp.idPersonne,\n\t\t\t\t evt.idEvenementRecuperationTitre ,\n\t\t\t\t evt.idImagePrincipale AS idHistoriqueImage,\n\t\t\t\t 'Personne' as typeEvenement,\n\t\t\t\t\tdate_format(evt.dateCreationEvenement," . _('"%e/%m/%Y"') . ") as dateCreationEvenement,\n\t\t\t\t\tDATE_FORMAT(evt.dateCreationEvenement, '%Y%m%d%H%i%s') as DateTri,\n\t\t\t\t evt.description,\n\t\t\t\t 'personne' as type\n\t\t\n\t\t\t\t FROM evenements evt\n\t\t\t\t LEFT JOIN _evenementEvenement ee on ee.idEvenementAssocie = evt.idEvenement\n\t\t\t\t LEFT JOIN _personneEvenement pe ON pe.idEvenement = ee.idEvenement\n\t\t\t\t LEFT JOIN personne p on p.idPersonne = pe.idPersonne\n\t\t\t\t\tLEFT JOIN _evenementPersonne ep on ep.idPersonne = p.idPersonne\n\t\t\t\t\tLEFT JOIN _evenementEvenement ee2 on ee2.idEvenementAssocie = ep.idEvenement\n\t\t\t\t\tLEFT JOIN _adresseEvenement ae on ae.idEvenement = ee2.idEvenement\n\t\t\t\t\tLEFT JOIN historiqueAdresse ha on ha.idAdresse = ae.idAdresse\n\t\t\n\t\t\t\t WHERE p.idPersonne IS NOT NULL\n\t\t\t\t\t" . $whereClause . "\n\t\t\t\t\t\t\t\n\t\t\t\t\t\n\t\t\n\t\t\t\t) as tmp\n\t\t\n\t\t\t\tWHERE tmp.DateTri = (\n\t\t\t\t SELECT max(DATE_FORMAT(evt2.dateCreationEvenement, '%Y%m%d%H%i%s'))\n\t\t\t\t FROM evenements evt2\n\t\t\t\t LEFT JOIN _evenementEvenement ee2 on ee2.idEvenementAssocie = evt2.idEvenement\n\t\t\t\t WHERE ee2.idEvenement = tmp.idEvenementGroupeAdresse\n\t\t\t\t)\n\t\t\t\tGROUP BY tmp.idEvenement\n\t\t\t\tORDER BY tmp.DateTri DESC\n\t\t\t\tLIMIT 8\n\t\t\n\t\t\t\t"; $resultIdAdresse = $this->connexionBdd->requete($requeteElements); $arrayIdEvenement = array(); $arrayEvenement = array(); while ($lastModif = mysql_fetch_assoc($resultIdAdresse)) { $tmp = $lastModif; if ($lastModif['type'] == 'adresse') { $requeteTitre = "SELECT e1.titre , e2.idImagePrincipale\n\t\t\t\t\t\tFROM evenements e1,evenements e2\n\t\t\t\t\t\tWHERE e2.idEvenement = " . $lastModif['idEvenementGroupeAdresse'] . "\n\t\t\t\t\t\tAND e1.idEvenement = e2.idEvenementRecuperationTitre\n\t\t\t\t\t\t\t\t"; $restitre = $this->connexionBdd->requete($requeteTitre); $titreArray = mysql_fetch_assoc($restitre); $evenement = new archiEvenement(); $idTitre = $evenement->getIdEvenementTitre($lastModif); $requeteTitreLegacy = "SELECT titre from evenements where idEvenement = {$idTitre}"; $resTitreLegacy = $this->connexionBdd->requete($requeteTitreLegacy); $titreArray = mysql_fetch_assoc($resTitreLegacy); $tmp['titre'] = $titreArray['titre']; $idImagePrincipale = $titreArray['idImagePrincipale']; if (isset($idImagePrincipale) && !empty($idImagePrincipale)) { $requeteIdHistoImage = "\n\t\t\t\t\t\t\tSELECT idHistoriqueImage\n\t\t\t\t\t\t\tFROM historiqueImage hi \n\t\t\t\t\t\t\tWHERE idImage = {$idImagePrincipale}\n\t\t\t\t\t\t\tORDER BY idHistoriqueImage DESC\n\t\t\t\t\t\t\tLIMIT 1\n\t\t\t\t\t\t\t"; $resIdImg = $this->connexionBdd->requete($requeteIdHistoImage); $arrayIdHistoImg = mysql_fetch_assoc($resIdImg); $tmp['idHistoriqueImage'] = $arrayIdHistoImg['idHistoriqueImage']; } } else { $p = new ArchiPersonne($tmp['idPersonne']); $tmp['titre'] = $p->getPersonneLibelle($tmp['idPersonne']); } $arrayLastModif[] = $tmp; } return $arrayLastModif; }