Code Context //récupération de l'id de la réalisation coté comWeb pour la création du lien
$realisationsTable = TableRegistry::get('BaseSite.Realisations');
foreach ($avisClients['avisByMembre']['avis'] as $key => $avisClient) {
$page = [
'etablissement' => object(Cake\ORM\Entity) {
'id' => (int) 215,
'nom' => 'Energie Facile Aquitaine',
'description' => 'Energie Facile Aquitaine – Artigues près Bordeaux. Expert RGE en chauffage et énergie solaire. Installation, entretien et aides financières à votre service dans la région Aquitaine.',
'adresse' => '37 Avenue de L'Ile de France',
'adresse2' => null,
'adresse3' => null,
'cp' => '33370',
'cp2' => null,
'cp3' => null,
'ville' => 'Artigues près Bordeaux',
'ville2' => null,
'ville3' => null,
'tel' => '05 56 67 28 62',
'tel2' => null,
'tel3' => null,
'fax' => '',
'mobile' => '',
'mobile2' => null,
'mail' => 'j.deamorin@energiefacileaquitaine.fr',
'logo' => 'website_logo_1314.png',
'lat' => (float) 44.84498,
'lat2' => null,
'lat3' => null,
'lng' => (float) -0.496218,
'lng2' => null,
'lng3' => null,
'siret' => '49901877800047',
'capital_social' => '10000',
'tva' => '',
'tarifs' => null,
'cgv' => null,
'formulaire_retractation' => null,
'mediateur_nom' => 'MEDIMMOCONSO',
'mediateur_url' => 'https://medimmoconso.fr/',
'mediateur_adresse' => null,
'mediateur_mail' => null,
'facebook' => 'https://fr-fr.facebook.com/pages/category/Home-Improvement/Energie-Facile-Aquitaine-1762236754089157/',
'twitter' => '',
'youtube' => 'https://www.youtube.com/@energiefacileaquitaine-vid4114',
'instagram' => '',
'linkedin' => null,
'membre_id' => (int) 217,
'membre' => object(Cake\ORM\Entity) {},
'dpt' => 'Gironde (33)',
'dptUrl' => 'gironde-33',
'[new]' => false,
'[accessible]' => [
[maximum depth reached]
],
'[dirty]' => [
[maximum depth reached]
],
'[original]' => [[maximum depth reached]],
'[virtual]' => [[maximum depth reached]],
'[errors]' => [[maximum depth reached]],
'[invalid]' => [[maximum depth reached]],
'[repository]' => 'BaseSite.Etablissements'
},
'metiers' => [
(int) 156 => object(Cake\ORM\Entity) {},
(int) 158 => object(Cake\ORM\Entity) {},
(int) 16 => object(Cake\ORM\Entity) {},
(int) 145 => object(Cake\ORM\Entity) {},
(int) 97 => object(Cake\ORM\Entity) {},
(int) 15 => object(Cake\ORM\Entity) {},
(int) 163 => object(Cake\ORM\Entity) {},
(int) 99 => object(Cake\ORM\Entity) {},
(int) 189 => object(Cake\ORM\Entity) {},
(int) 217 => object(Cake\ORM\Entity) {},
(int) 150 => object(Cake\ORM\Entity) {},
(int) 175 => object(Cake\ORM\Entity) {},
(int) 192 => object(Cake\ORM\Entity) {},
(int) 176 => object(Cake\ORM\Entity) {},
(int) 88 => object(Cake\ORM\Entity) {},
(int) 204 => object(Cake\ORM\Entity) {},
(int) 85 => object(Cake\ORM\Entity) {},
(int) 199 => object(Cake\ORM\Entity) {},
(int) 87 => object(Cake\ORM\Entity) {},
(int) 277 => object(Cake\ORM\Entity) {},
(int) 203 => object(Cake\ORM\Entity) {},
(int) 202 => object(Cake\ORM\Entity) {},
(int) 210 => object(Cake\ORM\Entity) {},
(int) 211 => object(Cake\ORM\Entity) {},
(int) 67 => object(Cake\ORM\Entity) {},
(int) 206 => object(Cake\ORM\Entity) {}
],
'partenaires' => [
(int) 0 => object(Cake\ORM\Entity) {},
(int) 1 => object(Cake\ORM\Entity) {},
(int) 2 => object(Cake\ORM\Entity) {},
(int) 3 => object(Cake\ORM\Entity) {},
(int) 4 => object(Cake\ORM\Entity) {},
(int) 5 => object(Cake\ORM\Entity) {},
(int) 6 => object(Cake\ORM\Entity) {},
(int) 7 => object(Cake\ORM\Entity) {},
(int) 8 => object(Cake\ORM\Entity) {},
(int) 9 => object(Cake\ORM\Entity) {}
],
'avis_etablissement' => [
'avis' => [
'avis' => (int) 13,
'moy_note_avis' => (int) 5
]
],
'meta' => [
'title' => '',
'description' => '',
'postTitle' => 'Energie Facile Aquitaine',
'postDescription' => 'Situés à Artigues près Bordeaux (33370), nous intervenons dans les domaines suivants : Installation d'un poêle à granulés ou d'un poêle à bois (bûches), Installation de cheminée, Installation chaudière à granulés et bois, Installation d'une cuisinière & poêle à bois hydro bouilleur, Installation d'un chauffage solaire (SSC), Production d'eau chaude sanitaire, Installation d'un chauffe eau solaire (CESI), Circuit de chauffage central, Pose de radiateurs, Pose de robinets de radiateurs, Régulation de chauffage, Tubage de conduit de cheminée, de poêle ou de chaudière, Désembouage du circuit de chauffage central, Ramonage de conduit de cheminée, de poêle ou de chaudière, Entretien de poêle à granulés et de poêle à bois (bûches), Entretien de cheminée (insert ou foyer ouvert), Entretien chaudière à granulés et bois, Entretien d'un chauffage solaire (SSC), Entretien d'un chauffe eau solaire (CESI), Panne chauffage, Dépannage de poêle à granulés et de poêle à bois (bûches), Dépannage chaudière à granulés et bois, Dépannage d'un chauffage solaire (SSC), Dépannage d'un chauffe eau solaire (CESI), Dépannage de radiateurs, Entretien cuisinière à bois hydro bouilleur.',
'others' => null
],
'slider' => object(Cake\ORM\Entity) {
'id' => (int) 311,
'page_id' => (int) 421,
'images' => [
[maximum depth reached]
],
'[new]' => false,
'[accessible]' => [
[maximum depth reached]
],
'[dirty]' => [[maximum depth reached]],
'[original]' => [[maximum depth reached]],
'[virtual]' => [[maximum depth reached]],
'[errors]' => [[maximum depth reached]],
'[invalid]' => [[maximum depth reached]],
'[repository]' => 'BaseSite.Sliders'
},
'intro' => object(Cake\ORM\Entity) {
'id' => (int) 420,
'titre' => 'Energie Facile Aquitaine à Artigues près Bordeaux, expert en chauffage durable',
'content_old' => null,
'content' => '<p>Nous installons et entretenons poêles à bois ou granulés, chaudières, cheminées, chauffages et chauffe-eau solaires dans les départements 33, 24, 47, 40 et 17. Certifiés RGE QualiBois et QualiSol, nous vous aidons à obtenir MaPrimeRénov’ et CEE, pour un projet économique et écologique. Optez pour le confort, les économies et un suivi garanti. Demandez votre audit énergie sur mesure.</p>',
'page_id' => (int) 421,
'[new]' => false,
'[accessible]' => [
[maximum depth reached]
],
'[dirty]' => [[maximum depth reached]],
'[original]' => [[maximum depth reached]],
'[virtual]' => [[maximum depth reached]],
'[errors]' => [[maximum depth reached]],
'[invalid]' => [[maximum depth reached]],
'[repository]' => 'BaseSite.Paragraphes'
},
'selection' => [
(int) 0 => object(Cake\ORM\Entity) {},
(int) 1 => object(Cake\ORM\Entity) {},
(int) 2 => object(Cake\ORM\Entity) {},
(int) 3 => object(Cake\ORM\Entity) {},
(int) 4 => object(Cake\ORM\Entity) {},
(int) 5 => object(Cake\ORM\Entity) {},
(int) 6 => object(Cake\ORM\Entity) {},
(int) 7 => object(Cake\ORM\Entity) {}
],
'certifications' => [
(int) 0 => object(Cake\ORM\Entity) {},
(int) 1 => object(Cake\ORM\Entity) {},
(int) 2 => object(Cake\ORM\Entity) {},
(int) 3 => object(Cake\ORM\Entity) {},
(int) 4 => object(Cake\ORM\Entity) {},
(int) 5 => object(Cake\ORM\Entity) {}
]
]
$slidersTable = object(BaseSite\Model\Table\SlidersTable) {
'registryAlias' => 'BaseSite.Sliders',
'table' => 'sliders',
'alias' => 'Sliders',
'entityClass' => '\Cake\ORM\Entity',
'associations' => [
(int) 0 => 'images',
(int) 1 => 'pages'
],
'behaviors' => [
(int) 0 => 'Webpage'
],
'defaultConnection' => 'default',
'connectionName' => 'default'
}
$paragraphesTable = object(BaseSite\Model\Table\ParagraphesTable) {
'registryAlias' => 'BaseSite.Paragraphes',
'table' => 'paragraphes',
'alias' => 'Paragraphes',
'entityClass' => '\Cake\ORM\Entity',
'associations' => [
(int) 0 => 'pages'
],
'behaviors' => [
(int) 0 => 'Webpage'
],
'defaultConnection' => 'default',
'connectionName' => 'default'
}
$realisationSelectionsTable = object(BaseSite\Model\Table\RealisationSelectionsTable) {
'registryAlias' => 'BaseSite.RealisationSelections',
'table' => 'realisation_selections',
'alias' => 'RealisationSelections',
'entityClass' => '\Cake\ORM\Entity',
'associations' => [
(int) 0 => 'pages',
(int) 1 => 'realisations'
],
'behaviors' => [
(int) 0 => 'Webpage'
],
'defaultConnection' => 'default',
'connectionName' => 'default'
}
$certificationsTable = object(BaseSite\Model\Table\CertificationsTable) {
'registryAlias' => 'BaseSite.Certifications',
'table' => 'certifications',
'alias' => 'Certifications',
'entityClass' => '\Cake\ORM\Entity',
'associations' => [
(int) 0 => 'etablissements',
(int) 1 => 'certificationsetablissements'
],
'behaviors' => [],
'defaultConnection' => 'default',
'connectionName' => 'default'
}
$membreId = (int) 1314
$cacheKey = 'last_avis_clients_1314'
$avisClients = null
$realisationsTable = object(BaseSite\Model\Table\RealisationsTable) {
'registryAlias' => 'BaseSite.Realisations',
'table' => 'realisations',
'alias' => 'Realisations',
'entityClass' => '\Cake\ORM\Entity',
'associations' => [
(int) 0 => 'membres',
(int) 1 => 'realisationselections',
(int) 2 => 'realisationphotos',
(int) 3 => 'metiers'
],
'behaviors' => [
(int) 0 => 'Webpage'
],
'defaultConnection' => 'default',
'connectionName' => 'default'
}Gb5V1\Controller\WebPagesController::home() - /home/resoproeco/www/core/plugins/Gb5V1/src/Controller/WebPagesController.php, line 75
App\Controller\PagesController::home() - APP/Controller/PagesController.php, line 32
Cake\Controller\Controller::invokeAction() - CORE/src/Controller/Controller.php, line 429
Cake\Routing\Dispatcher::_invoke() - CORE/src/Routing/Dispatcher.php, line 114
Cake\Routing\Dispatcher::dispatch() - CORE/src/Routing/Dispatcher.php, line 87
[main] - ROOT/webroot/index.php, line 36
