throw new RuntimeException('Unable to locate an object compatible with paginate.'); |
|
} |
|
$settings += $this->paginate; |
|
|
|
return $this->Paginator->paginate($table, $settings); |
|
} |
|
|
|
/** |
|
* Method to check that an action is accessible from a URL. |
object(Cake\ORM\Query) { '(help)' => 'This is a Query object, to get the results execute or iterate it.', 'sql' => 'SELECT Listes.id AS `Listes__id`, Listes.ets AS `Listes__ets`, Listes.presentation AS `Listes__presentation`, Listes.certifications_id AS `Listes__certifications_id`, Listes.mobile AS `Listes__mobile`, Listes.tel AS `Listes__tel`, Listes.site AS `Listes__site`, Listes.membre_partenaire AS `Listes__membre_partenaire`, Listes.created AS `Listes__created`, Dirigeant.id AS `Dirigeant__id`, Dirigeant.nom AS `Dirigeant__nom`, Dirigeant.prenom AS `Dirigeant__prenom`, Dirigeant.photo AS `Dirigeant__photo`, Activites.id AS `Activites__id`, Activites.membre_id AS `Activites__membre_id`, Activites.realisations AS `Activites__realisations`, Activites.avis AS `Activites__avis`, Activites.moy_note_avis AS `Activites__moy_note_avis`, Parrains.id AS `Parrains__id`, Parrains.ets AS `Parrains__ets`, CountReferences2.id_installateur AS `CountReferences2__id_installateur`, CountReferences2.photo AS `photoReferences2`, CountReferences2.titre AS `titreReferences2`, (COUNT(CountReferences2.id)) AS `totalReferences2` FROM liste Listes LEFT JOIN users Dirigeant ON (Dirigeant.type = :c0 AND Listes.id = (Dirigeant.liste_id)) LEFT JOIN activites Activites ON Listes.id = (Activites.membre_id) LEFT JOIN liste Parrains ON Parrains.id = (Listes.parrain_id) LEFT JOIN references2 CountReferences2 ON (CountReferences2.sous_categories like :c1 AND CountReferences2.statut = :c2 AND CountReferences2.valid = :c3 AND Listes.id = (CountReferences2.id_installateur)) WHERE (Listes.id not in (:c4,:c5) AND Listes.actif = :c6 AND Listes.membre_partenaire = :c7 AND Listes.metiers_id like :c8) GROUP BY Listes.id ORDER BY Listes.membre_partenaire asc, totalReferences2 desc LIMIT 16 OFFSET 32', 'params' => [ ':c0' => [ 'value' => 'dirigeant', 'type' => 'string', 'placeholder' => 'c0' ], ':c1' => [ 'value' => '%,781,%', 'type' => 'string', 'placeholder' => 'c1' ], ':c2' => [ 'value' => (int) 1, 'type' => 'boolean', 'placeholder' => 'c2' ], ':c3' => [ 'value' => (int) 1, 'type' => 'boolean', 'placeholder' => 'c3' ], ':c4' => [ 'value' => (int) 957, 'type' => 'smallinteger', 'placeholder' => 'c4' ], ':c5' => [ 'value' => (int) 1239, 'type' => 'smallinteger', 'placeholder' => 'c5' ], ':c6' => [ 'value' => (int) 1, 'type' => 'tinyinteger', 'placeholder' => 'c6' ], ':c7' => [ 'value' => (int) 0, 'type' => 'boolean', 'placeholder' => 'c7' ], ':c8' => [ 'value' => '%,258,%', 'type' => 'string', 'placeholder' => 'c8' ] ], 'defaultTypes' => [ 'Listes__id' => 'smallinteger', 'Listes.id' => 'smallinteger', 'id' => 'smallinteger', 'Listes__region_id' => 'integer', 'Listes.region_id' => 'integer', 'region_id' => 'integer', 'Listes__commission_id' => 'integer', 'Listes.commission_id' => 'integer', 'commission_id' => 'integer', 'Listes__association' => 'string', 'Listes.association' => 'string', 'association' => 'string', 'Listes__domaine' => 'string', 'Listes.domaine' => 'string', 'domaine' => 'string', 'Listes__dept' => 'string', 'Listes.dept' => 'string', 'dept' => 'string', 'Listes__metiers_id' => 'string', 'Listes.metiers_id' => 'string', 'metiers_id' => 'string', 'Listes__certifications_id' => 'string', 'Listes.certifications_id' => 'string', 'certifications_id' => 'string', 'Listes__x' => 'smallinteger', 'Listes.x' => 'smallinteger', 'x' => 'smallinteger', 'Listes__x2' => 'smallinteger', 'Listes.x2' => 'smallinteger', 'x2' => 'smallinteger', 'Listes__y' => 'smallinteger', 'Listes.y' => 'smallinteger', 'y' => 'smallinteger', 'Listes__y2' => 'string', 'Listes.y2' => 'string', 'y2' => 'string', 'Listes__Lat' => 'decimal', 'Listes.Lat' => 'decimal', 'Lat' => 'decimal', 'Listes__Lat2' => 'string', 'Listes.Lat2' => 'string', 'Lat2' => 'string', 'Listes__Lng' => 'decimal', 'Listes.Lng' => 'decimal', 'Lng' => 'decimal', 'Listes__Lng2' => 'string', 'Listes.Lng2' => 'string', 'Lng2' => 'string', 'Listes__ets' => 'string', 'Listes.ets' => 'string', 'ets' => 'string', 'Listes__tva' => 'string', 'Listes.tva' => 'string', 'tva' => 'string', 'Listes__capital_social' => 'string', 'Listes.capital_social' => 'string', 'capital_social' => 'string', 'Listes__tarifs' => 'string', 'Listes.tarifs' => 'string', 'tarifs' => 'string', 'Listes__cgv' => 'string', 'Listes.cgv' => 'string', 'cgv' => 'string', 'Listes__formulaire_retractation' => 'string', 'Listes.formulaire_retractation' => 'string', 'formulaire_retractation' => 'string', 'Listes__mediateur_nom' => 'string', 'Listes.mediateur_nom' => 'string', 'mediateur_nom' => 'string', 'Listes__mediateur_url' => 'string', 'Listes.mediateur_url' => 'string', 'mediateur_url' => 'string', 'Listes__mediateur_adresse' => 'string', 'Listes.mediateur_adresse' => 'string', 'mediateur_adresse' => 'string', 'Listes__mediateur_mail' => 'string', 'Listes.mediateur_mail' => 'string', 'mediateur_mail' => 'string', 'Listes__siret' => 'string', 'Listes.siret' => 'string', 'siret' => 'string', 'Listes__bureau_etudes' => 'tinyinteger', 'Listes.bureau_etudes' => 'tinyinteger', 'bureau_etudes' => 'tinyinteger', 'Listes__situation' => 'string', 'Listes.situation' => 'string', 'situation' => 'string', 'Listes__nom' => 'string', 'Listes.nom' => 'string', 'nom' => 'string', 'Listes__prenom' => 'string', 'Listes.prenom' => 'string', 'prenom' => 'string', 'Listes__adresse' => 'string', 'Listes.adresse' => 'string', 'adresse' => 'string', 'Listes__adresse2' => 'string', 'Listes.adresse2' => 'string', 'adresse2' => 'string', 'Listes__cp' => 'integer', 'Listes.cp' => 'integer', 'cp' => 'integer', 'Listes__cp2' => 'integer', 'Listes.cp2' => 'integer', 'cp2' => 'integer', 'Listes__ville' => 'string', 'Listes.ville' => 'string', 'ville' => 'string', 'Listes__ville2' => 'string', 'Listes.ville2' => 'string', 'ville2' => 'string', 'Listes__tel' => 'string', 'Listes.tel' => 'string', 'tel' => 'string', 'Listes__tel2' => 'string', 'Listes.tel2' => 'string', 'tel2' => 'string', 'Listes__mobile' => 'string', 'Listes.mobile' => 'string', 'mobile' => 'string', 'Listes__fax' => 'string', 'Listes.fax' => 'string', 'fax' => 'string', 'Listes__texte' => 'text', 'Listes.texte' => 'text', 'texte' => 'text', 'Listes__site' => 'string', 'Listes.site' => 'string', 'site' => 'string', 'Listes__mail' => 'string', 'Listes.mail' => 'string', 'mail' => 'string', 'Listes__redirection_mail' => 'string', 'Listes.redirection_mail' => 'string', 'redirection_mail' => 'string', 'Listes__logo' => 'string', 'Listes.logo' => 'string', 'logo' => 'string', 'Listes__photo0' => 'string', 'Listes.photo0' => 'string', 'photo0' => 'string', 'Listes__photo1' => 'string', 'Listes.photo1' => 'string', 'photo1' => 'string', 'Listes__photo2' => 'string', 'Listes.photo2' => 'string', 'photo2' => 'string', 'Listes__photo3' => 'string', 'Listes.photo3' => 'string', 'photo3' => 'string', 'Listes__slider0' => 'string', 'Listes.slider0' => 'string', 'slider0' => 'string', 'Listes__slider1' => 'string', 'Listes.slider1' => 'string', 'slider1' => 'string', 'Listes__slider2' => 'string', 'Listes.slider2' => 'string', 'slider2' => 'string', 'Listes__presentation' => 'text', 'Listes.presentation' => 'text', 'presentation' => 'text', 'Listes__reso_social_type' => 'string', 'Listes.reso_social_type' => 'string', 'reso_social_type' => 'string', 'Listes__facebook' => 'string', 'Listes.facebook' => 'string', 'facebook' => 'string', 'Listes__twitter' => 'string', 'Listes.twitter' => 'string', 'twitter' => 'string', 'Listes__youtube' => 'string', 'Listes.youtube' => 'string', 'youtube' => 'string', 'Listes__instagram' => 'string', 'Listes.instagram' => 'string', 'instagram' => 'string', 'Listes__linkedin' => 'string', 'Listes.linkedin' => 'string', 'linkedin' => 'string', 'Listes__login' => 'string', 'Listes.login' => 'string', 'login' => 'string', 'Listes__mdp' => 'string', 'Listes.mdp' => 'string', 'mdp' => 'string', 'Listes__cotisation' => 'date', 'Listes.cotisation' => 'date', 'cotisation' => 'date', 'Listes__cotisation_website' => 'date', 'Listes.cotisation_website' => 'date', 'cotisation_website' => 'date', 'Listes__gabarit_selection' => 'date', 'Listes.gabarit_selection' => 'date', 'gabarit_selection' => 'date', 'Listes__service_web_key' => 'integer', 'Listes.service_web_key' => 'integer', 'service_web_key' => 'integer', 'Listes__cotisation_service_web' => 'date', 'Listes.cotisation_service_web' => 'date', 'cotisation_service_web' => 'date', 'Listes__website' => 'boolean', 'Listes.website' => 'boolean', 'website' => 'boolean', 'Listes__membre_partenaire' => 'boolean', 'Listes.membre_partenaire' => 'boolean', 'membre_partenaire' => 'boolean', 'Listes__parrain_id' => 'integer', 'Listes.parrain_id' => 'integer', 'parrain_id' => 'integer', 'Listes__website_online' => 'boolean', 'Listes.website_online' => 'boolean', 'website_online' => 'boolean', 'Listes__rib' => 'string', 'Listes.rib' => 'string', 'rib' => 'string', 'Listes__autorisation' => 'boolean', 'Listes.autorisation' => 'boolean', 'autorisation' => 'boolean', 'Listes__created' => 'date', 'Listes.created' => 'date', 'created' => 'date', 'Listes__actif' => 'tinyinteger', 'Listes.actif' => 'tinyinteger', 'actif' => 'tinyinteger', 'Listes__viessmann_client_id' => 'string', 'Listes.viessmann_client_id' => 'string', 'viessmann_client_id' => 'string', 'Listes__derniere_co' => 'datetime', 'Listes.derniere_co' => 'datetime', 'derniere_co' => 'datetime', 'Adresses__id' => 'integer', 'Adresses.id' => 'integer', 'Adresses__adresse' => 'string', 'Adresses.adresse' => 'string', 'Adresses__cp' => 'string', 'Adresses.cp' => 'string', 'Adresses__ville' => 'string', 'Adresses.ville' => 'string', 'Adresses__x' => 'smallinteger', 'Adresses.x' => 'smallinteger', 'Adresses__y' => 'smallinteger', 'Adresses.y' => 'smallinteger', 'Adresses__lat' => 'decimal', 'Adresses.lat' => 'decimal', 'lat' => 'decimal', 'Adresses__lng' => 'decimal', 'Adresses.lng' => 'decimal', 'lng' => 'decimal', 'Adresses__tel' => 'string', 'Adresses.tel' => 'string', 'Adresses__mobile' => 'string', 'Adresses.mobile' => 'string', 'Dirigeant__id' => 'integer', 'Dirigeant.id' => 'integer', 'Dirigeant__type' => 'string', 'Dirigeant.type' => 'string', 'type' => 'string', 'Dirigeant__fonction' => 'string', 'Dirigeant.fonction' => 'string', 'fonction' => 'string', 'Dirigeant__nom' => 'string', 'Dirigeant.nom' => 'string', 'Dirigeant__prenom' => 'string', 'Dirigeant.prenom' => 'string', 'Dirigeant__login' => 'string', 'Dirigeant.login' => 'string', 'Dirigeant__password' => 'string', 'Dirigeant.password' => 'string', 'password' => 'string', 'Dirigeant__mail' => 'string', 'Dirigeant.mail' => 'string', 'Dirigeant__tel' => 'string', 'Dirigeant.tel' => 'string', 'Dirigeant__photo' => 'string', 'Dirigeant.photo' => 'string', 'photo' => 'string', 'Dirigeant__liste_id' => 'integer', 'Dirigeant.liste_id' => 'integer', 'liste_id' => 'integer', 'Dirigeant__fabricant_id' => 'integer', 'Dirigeant.fabricant_id' => 'integer', 'fabricant_id' => 'integer', 'Dirigeant__droit' => 'string', 'Dirigeant.droit' => 'string', 'droit' => 'string', 'Dirigeant__all_mails' => 'boolean', 'Dirigeant.all_mails' => 'boolean', 'all_mails' => 'boolean', 'Dirigeant__actif' => 'tinyinteger', 'Dirigeant.actif' => 'tinyinteger', 'Activites__id' => 'integer', 'Activites.id' => 'integer', 'Activites__membre_id' => 'integer', 'Activites.membre_id' => 'integer', 'membre_id' => 'integer', 'Activites__realisations' => 'integer', 'Activites.realisations' => 'integer', 'realisations' => 'integer', 'Activites__avis' => 'integer', 'Activites.avis' => 'integer', 'avis' => 'integer', 'Activites__moy_note_avis' => 'float', 'Activites.moy_note_avis' => 'float', 'moy_note_avis' => 'float', 'Parrains__id' => 'smallinteger', 'Parrains.id' => 'smallinteger', 'Parrains__region_id' => 'integer', 'Parrains.region_id' => 'integer', 'Parrains__commission_id' => 'integer', 'Parrains.commission_id' => 'integer', 'Parrains__association' => 'string', 'Parrains.association' => 'string', 'Parrains__domaine' => 'string', 'Parrains.domaine' => 'string', 'Parrains__dept' => 'string', 'Parrains.dept' => 'string', 'Parrains__metiers_id' => 'string', 'Parrains.metiers_id' => 'string', 'Parrains__certifications_id' => 'string', 'Parrains.certifications_id' => 'string', 'Parrains__x' => 'smallinteger', 'Parrains.x' => 'smallinteger', 'Parrains__x2' => 'smallinteger', 'Parrains.x2' => 'smallinteger', 'Parrains__y' => 'smallinteger', 'Parrains.y' => 'smallinteger', 'Parrains__y2' => 'string', 'Parrains.y2' => 'string', 'Parrains__Lat' => 'decimal', 'Parrains.Lat' => 'decimal', 'Parrains__Lat2' => 'string', 'Parrains.Lat2' => 'string', 'Parrains__Lng' => 'decimal', 'Parrains.Lng' => 'decimal', 'Parrains__Lng2' => 'string', 'Parrains.Lng2' => 'string', 'Parrains__ets' => 'string', 'Parrains.ets' => 'string', 'Parrains__tva' => 'string', 'Parrains.tva' => 'string', 'Parrains__capital_social' => 'string', 'Parrains.capital_social' => 'string', 'Parrains__tarifs' => 'string', 'Parrains.tarifs' => 'string', 'Parrains__cgv' => 'string', 'Parrains.cgv' => 'string', 'Parrains__formulaire_retractation' => 'string', 'Parrains.formulaire_retractation' => 'string', 'Parrains__mediateur_nom' => 'string', 'Parrains.mediateur_nom' => 'string', 'Parrains__mediateur_url' => 'string', 'Parrains.mediateur_url' => 'string', 'Parrains__mediateur_adresse' => 'string', 'Parrains.mediateur_adresse' => 'string', 'Parrains__mediateur_mail' => 'string', 'Parrains.mediateur_mail' => 'string', 'Parrains__siret' => 'string', 'Parrains.siret' => 'string', 'Parrains__bureau_etudes' => 'tinyinteger', 'Parrains.bureau_etudes' => 'tinyinteger', 'Parrains__situation' => 'string', 'Parrains.situation' => 'string', 'Parrains__nom' => 'string', 'Parrains.nom' => 'string', 'Parrains__prenom' => 'string', 'Parrains.prenom' => 'string', 'Parrains__adresse' => 'string', 'Parrains.adresse' => 'string', 'Parrains__adresse2' => 'string', 'Parrains.adresse2' => 'string', 'Parrains__cp' => 'integer', 'Parrains.cp' => 'integer', 'Parrains__cp2' => 'integer', 'Parrains.cp2' => 'integer', 'Parrains__ville' => 'string', 'Parrains.ville' => 'string', 'Parrains__ville2' => 'string', 'Parrains.ville2' => 'string', 'Parrains__tel' => 'string', 'Parrains.tel' => 'string', 'Parrains__tel2' => 'string', 'Parrains.tel2' => 'string', 'Parrains__mobile' => 'string', 'Parrains.mobile' => 'string', 'Parrains__fax' => 'string', 'Parrains.fax' => 'string', 'Parrains__texte' => 'text', 'Parrains.texte' => 'text', 'Parrains__site' => 'string', 'Parrains.site' => 'string', 'Parrains__mail' => 'string', 'Parrains.mail' => 'string', 'Parrains__redirection_mail' => 'string', 'Parrains.redirection_mail' => 'string', 'Parrains__logo' => 'string', 'Parrains.logo' => 'string', 'Parrains__photo0' => 'string', 'Parrains.photo0' => 'string', 'Parrains__photo1' => 'string', 'Parrains.photo1' => 'string', 'Parrains__photo2' => 'string', 'Parrains.photo2' => 'string', 'Parrains__photo3' => 'string', 'Parrains.photo3' => 'string', 'Parrains__slider0' => 'string', 'Parrains.slider0' => 'string', 'Parrains__slider1' => 'string', 'Parrains.slider1' => 'string', 'Parrains__slider2' => 'string', 'Parrains.slider2' => 'string', 'Parrains__presentation' => 'text', 'Parrains.presentation' => 'text', 'Parrains__reso_social_type' => 'string', 'Parrains.reso_social_type' => 'string', 'Parrains__facebook' => 'string', 'Parrains.facebook' => 'string', 'Parrains__twitter' => 'string', 'Parrains.twitter' => 'string', 'Parrains__youtube' => 'string', 'Parrains.youtube' => 'string', 'Parrains__instagram' => 'string', 'Parrains.instagram' => 'string', 'Parrains__linkedin' => 'string', 'Parrains.linkedin' => 'string', 'Parrains__login' => 'string', 'Parrains.login' => 'string', 'Parrains__mdp' => 'string', 'Parrains.mdp' => 'string', 'Parrains__cotisation' => 'date', 'Parrains.cotisation' => 'date', 'Parrains__cotisation_website' => 'date', 'Parrains.cotisation_website' => 'date', 'Parrains__gabarit_selection' => 'date', 'Parrains.gabarit_selection' => 'date', 'Parrains__service_web_key' => 'integer', 'Parrains.service_web_key' => 'integer', 'Parrains__cotisation_service_web' => 'date', 'Parrains.cotisation_service_web' => 'date', 'Parrains__website' => 'boolean', 'Parrains.website' => 'boolean', 'Parrains__membre_partenaire' => 'boolean', 'Parrains.membre_partenaire' => 'boolean', 'Parrains__parrain_id' => 'integer', 'Parrains.parrain_id' => 'integer', 'Parrains__website_online' => 'boolean', 'Parrains.website_online' => 'boolean', 'Parrains__rib' => 'string', 'Parrains.rib' => 'string', 'Parrains__autorisation' => 'boolean', 'Parrains.autorisation' => 'boolean', 'Parrains__created' => 'date', 'Parrains.created' => 'date', 'Parrains__actif' => 'tinyinteger', 'Parrains.actif' => 'tinyinteger', 'Parrains__viessmann_client_id' => 'string', 'Parrains.viessmann_client_id' => 'string', 'Parrains__derniere_co' => 'datetime', 'Parrains.derniere_co' => 'datetime', 'CountReferences2__id' => 'integer', 'CountReferences2.id' => 'integer', 'CountReferences2__id_installateur' => 'integer', 'CountReferences2.id_installateur' => 'integer', 'id_installateur' => 'integer', 'CountReferences2__id_client' => 'integer', 'CountReferences2.id_client' => 'integer', 'id_client' => 'integer', 'CountReferences2__client_mail_send' => 'tinyinteger', 'CountReferences2.client_mail_send' => 'tinyinteger', 'client_mail_send' => 'tinyinteger', 'CountReferences2__categorie' => 'integer', 'CountReferences2.categorie' => 'integer', 'categorie' => 'integer', 'CountReferences2__sous_categories' => 'string', 'CountReferences2.sous_categories' => 'string', 'sous_categories' => 'string', 'CountReferences2__Lat' => 'decimal', 'CountReferences2.Lat' => 'decimal', 'CountReferences2__Lng' => 'decimal', 'CountReferences2.Lng' => 'decimal', 'CountReferences2__titre' => 'string', 'CountReferences2.titre' => 'string', 'titre' => 'string', 'CountReferences2__annee' => 'string', 'CountReferences2.annee' => 'string', 'annee' => 'string', 'CountReferences2__caracteristiques' => 'text', 'CountReferences2.caracteristiques' => 'text', 'caracteristiques' => 'text', 'CountReferences2__client_nom' => 'string', 'CountReferences2.client_nom' => 'string', 'client_nom' => 'string', 'CountReferences2__client_adresse' => 'text', 'CountReferences2.client_adresse' => 'text', 'client_adresse' => 'text', 'CountReferences2__client_cp' => 'string', 'CountReferences2.client_cp' => 'string', 'client_cp' => 'string', 'CountReferences2__client_ville' => 'string', 'CountReferences2.client_ville' => 'string', 'client_ville' => 'string', 'CountReferences2__client_mail' => 'string', 'CountReferences2.client_mail' => 'string', 'client_mail' => 'string', 'CountReferences2__client_tel' => 'string', 'CountReferences2.client_tel' => 'string', 'client_tel' => 'string', 'CountReferences2__client_autorisation' => 'boolean', 'CountReferences2.client_autorisation' => 'boolean', 'client_autorisation' => 'boolean', 'CountReferences2__fabricant' => 'string', 'CountReferences2.fabricant' => 'string', 'fabricant' => 'string', 'CountReferences2__photo' => 'string', 'CountReferences2.photo' => 'string', 'CountReferences2__photo_01' => 'string', 'CountReferences2.photo_01' => 'string', 'photo_01' => 'string', 'CountReferences2__photo_02' => 'string', 'CountReferences2.photo_02' => 'string', 'photo_02' => 'string', 'CountReferences2__photo_03' => 'string', 'CountReferences2.photo_03' => 'string', 'photo_03' => 'string', 'CountReferences2__photo_04' => 'string', 'CountReferences2.photo_04' => 'string', 'photo_04' => 'string', 'CountReferences2__photo_05' => 'string', 'CountReferences2.photo_05' => 'string', 'photo_05' => 'string', 'CountReferences2__dossier_technique' => 'string', 'CountReferences2.dossier_technique' => 'string', 'dossier_technique' => 'string', 'CountReferences2__video' => 'string', 'CountReferences2.video' => 'string', 'video' => 'string', 'CountReferences2__departements' => 'string', 'CountReferences2.departements' => 'string', 'departements' => 'string', 'CountReferences2__statut' => 'boolean', 'CountReferences2.statut' => 'boolean', 'statut' => 'boolean', 'CountReferences2__valid' => 'boolean', 'CountReferences2.valid' => 'boolean', 'valid' => 'boolean', 'CountReferences2__affichage_carte' => 'boolean', 'CountReferences2.affichage_carte' => 'boolean', 'affichage_carte' => 'boolean', 'CountReferences2__created' => 'datetime', 'CountReferences2.created' => 'datetime', 'CountReferences2__brouillon' => 'tinyinteger', 'CountReferences2.brouillon' => 'tinyinteger', 'brouillon' => 'tinyinteger', 'CountReferences2__admin_commentaire' => 'text', 'CountReferences2.admin_commentaire' => 'text', 'admin_commentaire' => 'text', 'LastPhotoReferences2__id' => 'integer', 'LastPhotoReferences2.id' => 'integer', 'LastPhotoReferences2__id_installateur' => 'integer', 'LastPhotoReferences2.id_installateur' => 'integer', 'LastPhotoReferences2__id_client' => 'integer', 'LastPhotoReferences2.id_client' => 'integer', 'LastPhotoReferences2__client_mail_send' => 'tinyinteger', 'LastPhotoReferences2.client_mail_send' => 'tinyinteger', 'LastPhotoReferences2__categorie' => 'integer', 'LastPhotoReferences2.categorie' => 'integer', 'LastPhotoReferences2__sous_categories' => 'string', 'LastPhotoReferences2.sous_categories' => 'string', 'LastPhotoReferences2__Lat' => 'decimal', 'LastPhotoReferences2.Lat' => 'decimal', 'LastPhotoReferences2__Lng' => 'decimal', 'LastPhotoReferences2.Lng' => 'decimal', 'LastPhotoReferences2__titre' => 'string', 'LastPhotoReferences2.titre' => 'string', 'LastPhotoReferences2__annee' => 'string', 'LastPhotoReferences2.annee' => 'string', 'LastPhotoReferences2__caracteristiques' => 'text', 'LastPhotoReferences2.caracteristiques' => 'text', 'LastPhotoReferences2__client_nom' => 'string', 'LastPhotoReferences2.client_nom' => 'string', 'LastPhotoReferences2__client_adresse' => 'text', 'LastPhotoReferences2.client_adresse' => 'text', 'LastPhotoReferences2__client_cp' => 'string', 'LastPhotoReferences2.client_cp' => 'string', 'LastPhotoReferences2__client_ville' => 'string', 'LastPhotoReferences2.client_ville' => 'string', 'LastPhotoReferences2__client_mail' => 'string', 'LastPhotoReferences2.client_mail' => 'string', 'LastPhotoReferences2__client_tel' => 'string', 'LastPhotoReferences2.client_tel' => 'string', 'LastPhotoReferences2__client_autorisation' => 'boolean', 'LastPhotoReferences2.client_autorisation' => 'boolean', 'LastPhotoReferences2__fabricant' => 'string', 'LastPhotoReferences2.fabricant' => 'string', 'LastPhotoReferences2__photo' => 'string', 'LastPhotoReferences2.photo' => 'string', 'LastPhotoReferences2__photo_01' => 'string', 'LastPhotoReferences2.photo_01' => 'string', 'LastPhotoReferences2__photo_02' => 'string', 'LastPhotoReferences2.photo_02' => 'string', 'LastPhotoReferences2__photo_03' => 'string', 'LastPhotoReferences2.photo_03' => 'string', 'LastPhotoReferences2__photo_04' => 'string', 'LastPhotoReferences2.photo_04' => 'string', 'LastPhotoReferences2__photo_05' => 'string', 'LastPhotoReferences2.photo_05' => 'string', 'LastPhotoReferences2__dossier_technique' => 'string', 'LastPhotoReferences2.dossier_technique' => 'string', 'LastPhotoReferences2__video' => 'string', 'LastPhotoReferences2.video' => 'string', 'LastPhotoReferences2__departements' => 'string', 'LastPhotoReferences2.departements' => 'string', 'LastPhotoReferences2__statut' => 'boolean', 'LastPhotoReferences2.statut' => 'boolean', 'LastPhotoReferences2__valid' => 'boolean', 'LastPhotoReferences2.valid' => 'boolean', 'LastPhotoReferences2__affichage_carte' => 'boolean', 'LastPhotoReferences2.affichage_carte' => 'boolean', 'LastPhotoReferences2__created' => 'datetime', 'LastPhotoReferences2.created' => 'datetime', 'LastPhotoReferences2__brouillon' => 'tinyinteger', 'LastPhotoReferences2.brouillon' => 'tinyinteger', 'LastPhotoReferences2__admin_commentaire' => 'text', 'LastPhotoReferences2.admin_commentaire' => 'text' ], 'decorators' => (int) 1, 'executed' => true, 'hydrate' => true, 'buffered' => true, 'formatters' => (int) 0, 'mapReducers' => (int) 0, 'contain' => [ 'Adresses' => [], 'Dirigeant' => [ 'queryBuilder' => object(Closure) {} ], 'Activites' => [ 'queryBuilder' => object(Closure) {} ], 'Parrains' => [ 'queryBuilder' => object(Closure) {} ], 'CountReferences2' => [ 'queryBuilder' => object(Closure) {} ], 'LastPhotoReferences2' => [ 'queryBuilder' => object(Closure) {} ] ], 'matching' => [], 'extraOptions' => [ 'scope' => null, 'sort' => 'totalReferences2', 'sortWhitelist' => [ (int) 0 => 'totalReferences2', (int) 1 => 'Activites.avis', (int) 2 => 'Listes.membre_partenaire' ], 'whitelist' => [ (int) 0 => 'limit', (int) 1 => 'sort', (int) 2 => 'page', (int) 3 => 'direction' ] ], 'repository' => object(App\Model\Table\ListesTable) { 'registryAlias' => 'Listes', 'table' => 'liste', 'alias' => 'Listes', 'entityClass' => 'App\Model\Entity\Liste', 'associations' => [ [maximum depth reached] ], 'behaviors' => [[maximum depth reached]], 'defaultConnection' => 'default', 'connectionName' => 'default' } } [ 'limit' => (int) 16, 'order' => [ 'totalReferences2' => 'desc' ], 'sortWhitelist' => [ (int) 0 => 'totalReferences2', (int) 1 => 'Activites.avis', (int) 2 => 'Listes.membre_partenaire' ], 'page' => (int) 3 ]
'order' => ['totalReferences2' => 'desc'], |
|
'sortWhitelist' => ['totalReferences2', 'Activites.avis', 'Listes.membre_partenaire'] |
|
]; |
|
$this->paginate['page'] = (isset($this->request->params['page'])) ? $this->request->params['page'] * 1 : 1; |
|
$membres = $this->paginate($query); |
|
// debug($membres); |
|
// exit; |
|
//récupération note moyenne du métier |
|
$avisTable = TableRegistry::get('AvisRealisations'); |
object(Cake\ORM\Query) { '(help)' => 'This is a Query object, to get the results execute or iterate it.', 'sql' => 'SELECT Listes.id AS `Listes__id`, Listes.ets AS `Listes__ets`, Listes.presentation AS `Listes__presentation`, Listes.certifications_id AS `Listes__certifications_id`, Listes.mobile AS `Listes__mobile`, Listes.tel AS `Listes__tel`, Listes.site AS `Listes__site`, Listes.membre_partenaire AS `Listes__membre_partenaire`, Listes.created AS `Listes__created`, Dirigeant.id AS `Dirigeant__id`, Dirigeant.nom AS `Dirigeant__nom`, Dirigeant.prenom AS `Dirigeant__prenom`, Dirigeant.photo AS `Dirigeant__photo`, Activites.id AS `Activites__id`, Activites.membre_id AS `Activites__membre_id`, Activites.realisations AS `Activites__realisations`, Activites.avis AS `Activites__avis`, Activites.moy_note_avis AS `Activites__moy_note_avis`, Parrains.id AS `Parrains__id`, Parrains.ets AS `Parrains__ets`, CountReferences2.id_installateur AS `CountReferences2__id_installateur`, CountReferences2.photo AS `photoReferences2`, CountReferences2.titre AS `titreReferences2`, (COUNT(CountReferences2.id)) AS `totalReferences2` FROM liste Listes LEFT JOIN users Dirigeant ON (Dirigeant.type = :c0 AND Listes.id = (Dirigeant.liste_id)) LEFT JOIN activites Activites ON Listes.id = (Activites.membre_id) LEFT JOIN liste Parrains ON Parrains.id = (Listes.parrain_id) LEFT JOIN references2 CountReferences2 ON (CountReferences2.sous_categories like :c1 AND CountReferences2.statut = :c2 AND CountReferences2.valid = :c3 AND Listes.id = (CountReferences2.id_installateur)) WHERE (Listes.id not in (:c4,:c5) AND Listes.actif = :c6 AND Listes.membre_partenaire = :c7 AND Listes.metiers_id like :c8) GROUP BY Listes.id ORDER BY Listes.membre_partenaire asc, totalReferences2 desc LIMIT 16 OFFSET 32', 'params' => [ ':c0' => [ 'value' => 'dirigeant', 'type' => 'string', 'placeholder' => 'c0' ], ':c1' => [ 'value' => '%,781,%', 'type' => 'string', 'placeholder' => 'c1' ], ':c2' => [ 'value' => (int) 1, 'type' => 'boolean', 'placeholder' => 'c2' ], ':c3' => [ 'value' => (int) 1, 'type' => 'boolean', 'placeholder' => 'c3' ], ':c4' => [ 'value' => (int) 957, 'type' => 'smallinteger', 'placeholder' => 'c4' ], ':c5' => [ 'value' => (int) 1239, 'type' => 'smallinteger', 'placeholder' => 'c5' ], ':c6' => [ 'value' => (int) 1, 'type' => 'tinyinteger', 'placeholder' => 'c6' ], ':c7' => [ 'value' => (int) 0, 'type' => 'boolean', 'placeholder' => 'c7' ], ':c8' => [ 'value' => '%,258,%', 'type' => 'string', 'placeholder' => 'c8' ] ], 'defaultTypes' => [ 'Listes__id' => 'smallinteger', 'Listes.id' => 'smallinteger', 'id' => 'smallinteger', 'Listes__region_id' => 'integer', 'Listes.region_id' => 'integer', 'region_id' => 'integer', 'Listes__commission_id' => 'integer', 'Listes.commission_id' => 'integer', 'commission_id' => 'integer', 'Listes__association' => 'string', 'Listes.association' => 'string', 'association' => 'string', 'Listes__domaine' => 'string', 'Listes.domaine' => 'string', 'domaine' => 'string', 'Listes__dept' => 'string', 'Listes.dept' => 'string', 'dept' => 'string', 'Listes__metiers_id' => 'string', 'Listes.metiers_id' => 'string', 'metiers_id' => 'string', 'Listes__certifications_id' => 'string', 'Listes.certifications_id' => 'string', 'certifications_id' => 'string', 'Listes__x' => 'smallinteger', 'Listes.x' => 'smallinteger', 'x' => 'smallinteger', 'Listes__x2' => 'smallinteger', 'Listes.x2' => 'smallinteger', 'x2' => 'smallinteger', 'Listes__y' => 'smallinteger', 'Listes.y' => 'smallinteger', 'y' => 'smallinteger', 'Listes__y2' => 'string', 'Listes.y2' => 'string', 'y2' => 'string', 'Listes__Lat' => 'decimal', 'Listes.Lat' => 'decimal', 'Lat' => 'decimal', 'Listes__Lat2' => 'string', 'Listes.Lat2' => 'string', 'Lat2' => 'string', 'Listes__Lng' => 'decimal', 'Listes.Lng' => 'decimal', 'Lng' => 'decimal', 'Listes__Lng2' => 'string', 'Listes.Lng2' => 'string', 'Lng2' => 'string', 'Listes__ets' => 'string', 'Listes.ets' => 'string', 'ets' => 'string', 'Listes__tva' => 'string', 'Listes.tva' => 'string', 'tva' => 'string', 'Listes__capital_social' => 'string', 'Listes.capital_social' => 'string', 'capital_social' => 'string', 'Listes__tarifs' => 'string', 'Listes.tarifs' => 'string', 'tarifs' => 'string', 'Listes__cgv' => 'string', 'Listes.cgv' => 'string', 'cgv' => 'string', 'Listes__formulaire_retractation' => 'string', 'Listes.formulaire_retractation' => 'string', 'formulaire_retractation' => 'string', 'Listes__mediateur_nom' => 'string', 'Listes.mediateur_nom' => 'string', 'mediateur_nom' => 'string', 'Listes__mediateur_url' => 'string', 'Listes.mediateur_url' => 'string', 'mediateur_url' => 'string', 'Listes__mediateur_adresse' => 'string', 'Listes.mediateur_adresse' => 'string', 'mediateur_adresse' => 'string', 'Listes__mediateur_mail' => 'string', 'Listes.mediateur_mail' => 'string', 'mediateur_mail' => 'string', 'Listes__siret' => 'string', 'Listes.siret' => 'string', 'siret' => 'string', 'Listes__bureau_etudes' => 'tinyinteger', 'Listes.bureau_etudes' => 'tinyinteger', 'bureau_etudes' => 'tinyinteger', 'Listes__situation' => 'string', 'Listes.situation' => 'string', 'situation' => 'string', 'Listes__nom' => 'string', 'Listes.nom' => 'string', 'nom' => 'string', 'Listes__prenom' => 'string', 'Listes.prenom' => 'string', 'prenom' => 'string', 'Listes__adresse' => 'string', 'Listes.adresse' => 'string', 'adresse' => 'string', 'Listes__adresse2' => 'string', 'Listes.adresse2' => 'string', 'adresse2' => 'string', 'Listes__cp' => 'integer', 'Listes.cp' => 'integer', 'cp' => 'integer', 'Listes__cp2' => 'integer', 'Listes.cp2' => 'integer', 'cp2' => 'integer', 'Listes__ville' => 'string', 'Listes.ville' => 'string', 'ville' => 'string', 'Listes__ville2' => 'string', 'Listes.ville2' => 'string', 'ville2' => 'string', 'Listes__tel' => 'string', 'Listes.tel' => 'string', 'tel' => 'string', 'Listes__tel2' => 'string', 'Listes.tel2' => 'string', 'tel2' => 'string', 'Listes__mobile' => 'string', 'Listes.mobile' => 'string', 'mobile' => 'string', 'Listes__fax' => 'string', 'Listes.fax' => 'string', 'fax' => 'string', 'Listes__texte' => 'text', 'Listes.texte' => 'text', 'texte' => 'text', 'Listes__site' => 'string', 'Listes.site' => 'string', 'site' => 'string', 'Listes__mail' => 'string', 'Listes.mail' => 'string', 'mail' => 'string', 'Listes__redirection_mail' => 'string', 'Listes.redirection_mail' => 'string', 'redirection_mail' => 'string', 'Listes__logo' => 'string', 'Listes.logo' => 'string', 'logo' => 'string', 'Listes__photo0' => 'string', 'Listes.photo0' => 'string', 'photo0' => 'string', 'Listes__photo1' => 'string', 'Listes.photo1' => 'string', 'photo1' => 'string', 'Listes__photo2' => 'string', 'Listes.photo2' => 'string', 'photo2' => 'string', 'Listes__photo3' => 'string', 'Listes.photo3' => 'string', 'photo3' => 'string', 'Listes__slider0' => 'string', 'Listes.slider0' => 'string', 'slider0' => 'string', 'Listes__slider1' => 'string', 'Listes.slider1' => 'string', 'slider1' => 'string', 'Listes__slider2' => 'string', 'Listes.slider2' => 'string', 'slider2' => 'string', 'Listes__presentation' => 'text', 'Listes.presentation' => 'text', 'presentation' => 'text', 'Listes__reso_social_type' => 'string', 'Listes.reso_social_type' => 'string', 'reso_social_type' => 'string', 'Listes__facebook' => 'string', 'Listes.facebook' => 'string', 'facebook' => 'string', 'Listes__twitter' => 'string', 'Listes.twitter' => 'string', 'twitter' => 'string', 'Listes__youtube' => 'string', 'Listes.youtube' => 'string', 'youtube' => 'string', 'Listes__instagram' => 'string', 'Listes.instagram' => 'string', 'instagram' => 'string', 'Listes__linkedin' => 'string', 'Listes.linkedin' => 'string', 'linkedin' => 'string', 'Listes__login' => 'string', 'Listes.login' => 'string', 'login' => 'string', 'Listes__mdp' => 'string', 'Listes.mdp' => 'string', 'mdp' => 'string', 'Listes__cotisation' => 'date', 'Listes.cotisation' => 'date', 'cotisation' => 'date', 'Listes__cotisation_website' => 'date', 'Listes.cotisation_website' => 'date', 'cotisation_website' => 'date', 'Listes__gabarit_selection' => 'date', 'Listes.gabarit_selection' => 'date', 'gabarit_selection' => 'date', 'Listes__service_web_key' => 'integer', 'Listes.service_web_key' => 'integer', 'service_web_key' => 'integer', 'Listes__cotisation_service_web' => 'date', 'Listes.cotisation_service_web' => 'date', 'cotisation_service_web' => 'date', 'Listes__website' => 'boolean', 'Listes.website' => 'boolean', 'website' => 'boolean', 'Listes__membre_partenaire' => 'boolean', 'Listes.membre_partenaire' => 'boolean', 'membre_partenaire' => 'boolean', 'Listes__parrain_id' => 'integer', 'Listes.parrain_id' => 'integer', 'parrain_id' => 'integer', 'Listes__website_online' => 'boolean', 'Listes.website_online' => 'boolean', 'website_online' => 'boolean', 'Listes__rib' => 'string', 'Listes.rib' => 'string', 'rib' => 'string', 'Listes__autorisation' => 'boolean', 'Listes.autorisation' => 'boolean', 'autorisation' => 'boolean', 'Listes__created' => 'date', 'Listes.created' => 'date', 'created' => 'date', 'Listes__actif' => 'tinyinteger', 'Listes.actif' => 'tinyinteger', 'actif' => 'tinyinteger', 'Listes__viessmann_client_id' => 'string', 'Listes.viessmann_client_id' => 'string', 'viessmann_client_id' => 'string', 'Listes__derniere_co' => 'datetime', 'Listes.derniere_co' => 'datetime', 'derniere_co' => 'datetime', 'Adresses__id' => 'integer', 'Adresses.id' => 'integer', 'Adresses__adresse' => 'string', 'Adresses.adresse' => 'string', 'Adresses__cp' => 'string', 'Adresses.cp' => 'string', 'Adresses__ville' => 'string', 'Adresses.ville' => 'string', 'Adresses__x' => 'smallinteger', 'Adresses.x' => 'smallinteger', 'Adresses__y' => 'smallinteger', 'Adresses.y' => 'smallinteger', 'Adresses__lat' => 'decimal', 'Adresses.lat' => 'decimal', 'lat' => 'decimal', 'Adresses__lng' => 'decimal', 'Adresses.lng' => 'decimal', 'lng' => 'decimal', 'Adresses__tel' => 'string', 'Adresses.tel' => 'string', 'Adresses__mobile' => 'string', 'Adresses.mobile' => 'string', 'Dirigeant__id' => 'integer', 'Dirigeant.id' => 'integer', 'Dirigeant__type' => 'string', 'Dirigeant.type' => 'string', 'type' => 'string', 'Dirigeant__fonction' => 'string', 'Dirigeant.fonction' => 'string', 'fonction' => 'string', 'Dirigeant__nom' => 'string', 'Dirigeant.nom' => 'string', 'Dirigeant__prenom' => 'string', 'Dirigeant.prenom' => 'string', 'Dirigeant__login' => 'string', 'Dirigeant.login' => 'string', 'Dirigeant__password' => 'string', 'Dirigeant.password' => 'string', 'password' => 'string', 'Dirigeant__mail' => 'string', 'Dirigeant.mail' => 'string', 'Dirigeant__tel' => 'string', 'Dirigeant.tel' => 'string', 'Dirigeant__photo' => 'string', 'Dirigeant.photo' => 'string', 'photo' => 'string', 'Dirigeant__liste_id' => 'integer', 'Dirigeant.liste_id' => 'integer', 'liste_id' => 'integer', 'Dirigeant__fabricant_id' => 'integer', 'Dirigeant.fabricant_id' => 'integer', 'fabricant_id' => 'integer', 'Dirigeant__droit' => 'string', 'Dirigeant.droit' => 'string', 'droit' => 'string', 'Dirigeant__all_mails' => 'boolean', 'Dirigeant.all_mails' => 'boolean', 'all_mails' => 'boolean', 'Dirigeant__actif' => 'tinyinteger', 'Dirigeant.actif' => 'tinyinteger', 'Activites__id' => 'integer', 'Activites.id' => 'integer', 'Activites__membre_id' => 'integer', 'Activites.membre_id' => 'integer', 'membre_id' => 'integer', 'Activites__realisations' => 'integer', 'Activites.realisations' => 'integer', 'realisations' => 'integer', 'Activites__avis' => 'integer', 'Activites.avis' => 'integer', 'avis' => 'integer', 'Activites__moy_note_avis' => 'float', 'Activites.moy_note_avis' => 'float', 'moy_note_avis' => 'float', 'Parrains__id' => 'smallinteger', 'Parrains.id' => 'smallinteger', 'Parrains__region_id' => 'integer', 'Parrains.region_id' => 'integer', 'Parrains__commission_id' => 'integer', 'Parrains.commission_id' => 'integer', 'Parrains__association' => 'string', 'Parrains.association' => 'string', 'Parrains__domaine' => 'string', 'Parrains.domaine' => 'string', 'Parrains__dept' => 'string', 'Parrains.dept' => 'string', 'Parrains__metiers_id' => 'string', 'Parrains.metiers_id' => 'string', 'Parrains__certifications_id' => 'string', 'Parrains.certifications_id' => 'string', 'Parrains__x' => 'smallinteger', 'Parrains.x' => 'smallinteger', 'Parrains__x2' => 'smallinteger', 'Parrains.x2' => 'smallinteger', 'Parrains__y' => 'smallinteger', 'Parrains.y' => 'smallinteger', 'Parrains__y2' => 'string', 'Parrains.y2' => 'string', 'Parrains__Lat' => 'decimal', 'Parrains.Lat' => 'decimal', 'Parrains__Lat2' => 'string', 'Parrains.Lat2' => 'string', 'Parrains__Lng' => 'decimal', 'Parrains.Lng' => 'decimal', 'Parrains__Lng2' => 'string', 'Parrains.Lng2' => 'string', 'Parrains__ets' => 'string', 'Parrains.ets' => 'string', 'Parrains__tva' => 'string', 'Parrains.tva' => 'string', 'Parrains__capital_social' => 'string', 'Parrains.capital_social' => 'string', 'Parrains__tarifs' => 'string', 'Parrains.tarifs' => 'string', 'Parrains__cgv' => 'string', 'Parrains.cgv' => 'string', 'Parrains__formulaire_retractation' => 'string', 'Parrains.formulaire_retractation' => 'string', 'Parrains__mediateur_nom' => 'string', 'Parrains.mediateur_nom' => 'string', 'Parrains__mediateur_url' => 'string', 'Parrains.mediateur_url' => 'string', 'Parrains__mediateur_adresse' => 'string', 'Parrains.mediateur_adresse' => 'string', 'Parrains__mediateur_mail' => 'string', 'Parrains.mediateur_mail' => 'string', 'Parrains__siret' => 'string', 'Parrains.siret' => 'string', 'Parrains__bureau_etudes' => 'tinyinteger', 'Parrains.bureau_etudes' => 'tinyinteger', 'Parrains__situation' => 'string', 'Parrains.situation' => 'string', 'Parrains__nom' => 'string', 'Parrains.nom' => 'string', 'Parrains__prenom' => 'string', 'Parrains.prenom' => 'string', 'Parrains__adresse' => 'string', 'Parrains.adresse' => 'string', 'Parrains__adresse2' => 'string', 'Parrains.adresse2' => 'string', 'Parrains__cp' => 'integer', 'Parrains.cp' => 'integer', 'Parrains__cp2' => 'integer', 'Parrains.cp2' => 'integer', 'Parrains__ville' => 'string', 'Parrains.ville' => 'string', 'Parrains__ville2' => 'string', 'Parrains.ville2' => 'string', 'Parrains__tel' => 'string', 'Parrains.tel' => 'string', 'Parrains__tel2' => 'string', 'Parrains.tel2' => 'string', 'Parrains__mobile' => 'string', 'Parrains.mobile' => 'string', 'Parrains__fax' => 'string', 'Parrains.fax' => 'string', 'Parrains__texte' => 'text', 'Parrains.texte' => 'text', 'Parrains__site' => 'string', 'Parrains.site' => 'string', 'Parrains__mail' => 'string', 'Parrains.mail' => 'string', 'Parrains__redirection_mail' => 'string', 'Parrains.redirection_mail' => 'string', 'Parrains__logo' => 'string', 'Parrains.logo' => 'string', 'Parrains__photo0' => 'string', 'Parrains.photo0' => 'string', 'Parrains__photo1' => 'string', 'Parrains.photo1' => 'string', 'Parrains__photo2' => 'string', 'Parrains.photo2' => 'string', 'Parrains__photo3' => 'string', 'Parrains.photo3' => 'string', 'Parrains__slider0' => 'string', 'Parrains.slider0' => 'string', 'Parrains__slider1' => 'string', 'Parrains.slider1' => 'string', 'Parrains__slider2' => 'string', 'Parrains.slider2' => 'string', 'Parrains__presentation' => 'text', 'Parrains.presentation' => 'text', 'Parrains__reso_social_type' => 'string', 'Parrains.reso_social_type' => 'string', 'Parrains__facebook' => 'string', 'Parrains.facebook' => 'string', 'Parrains__twitter' => 'string', 'Parrains.twitter' => 'string', 'Parrains__youtube' => 'string', 'Parrains.youtube' => 'string', 'Parrains__instagram' => 'string', 'Parrains.instagram' => 'string', 'Parrains__linkedin' => 'string', 'Parrains.linkedin' => 'string', 'Parrains__login' => 'string', 'Parrains.login' => 'string', 'Parrains__mdp' => 'string', 'Parrains.mdp' => 'string', 'Parrains__cotisation' => 'date', 'Parrains.cotisation' => 'date', 'Parrains__cotisation_website' => 'date', 'Parrains.cotisation_website' => 'date', 'Parrains__gabarit_selection' => 'date', 'Parrains.gabarit_selection' => 'date', 'Parrains__service_web_key' => 'integer', 'Parrains.service_web_key' => 'integer', 'Parrains__cotisation_service_web' => 'date', 'Parrains.cotisation_service_web' => 'date', 'Parrains__website' => 'boolean', 'Parrains.website' => 'boolean', 'Parrains__membre_partenaire' => 'boolean', 'Parrains.membre_partenaire' => 'boolean', 'Parrains__parrain_id' => 'integer', 'Parrains.parrain_id' => 'integer', 'Parrains__website_online' => 'boolean', 'Parrains.website_online' => 'boolean', 'Parrains__rib' => 'string', 'Parrains.rib' => 'string', 'Parrains__autorisation' => 'boolean', 'Parrains.autorisation' => 'boolean', 'Parrains__created' => 'date', 'Parrains.created' => 'date', 'Parrains__actif' => 'tinyinteger', 'Parrains.actif' => 'tinyinteger', 'Parrains__viessmann_client_id' => 'string', 'Parrains.viessmann_client_id' => 'string', 'Parrains__derniere_co' => 'datetime', 'Parrains.derniere_co' => 'datetime', 'CountReferences2__id' => 'integer', 'CountReferences2.id' => 'integer', 'CountReferences2__id_installateur' => 'integer', 'CountReferences2.id_installateur' => 'integer', 'id_installateur' => 'integer', 'CountReferences2__id_client' => 'integer', 'CountReferences2.id_client' => 'integer', 'id_client' => 'integer', 'CountReferences2__client_mail_send' => 'tinyinteger', 'CountReferences2.client_mail_send' => 'tinyinteger', 'client_mail_send' => 'tinyinteger', 'CountReferences2__categorie' => 'integer', 'CountReferences2.categorie' => 'integer', 'categorie' => 'integer', 'CountReferences2__sous_categories' => 'string', 'CountReferences2.sous_categories' => 'string', 'sous_categories' => 'string', 'CountReferences2__Lat' => 'decimal', 'CountReferences2.Lat' => 'decimal', 'CountReferences2__Lng' => 'decimal', 'CountReferences2.Lng' => 'decimal', 'CountReferences2__titre' => 'string', 'CountReferences2.titre' => 'string', 'titre' => 'string', 'CountReferences2__annee' => 'string', 'CountReferences2.annee' => 'string', 'annee' => 'string', 'CountReferences2__caracteristiques' => 'text', 'CountReferences2.caracteristiques' => 'text', 'caracteristiques' => 'text', 'CountReferences2__client_nom' => 'string', 'CountReferences2.client_nom' => 'string', 'client_nom' => 'string', 'CountReferences2__client_adresse' => 'text', 'CountReferences2.client_adresse' => 'text', 'client_adresse' => 'text', 'CountReferences2__client_cp' => 'string', 'CountReferences2.client_cp' => 'string', 'client_cp' => 'string', 'CountReferences2__client_ville' => 'string', 'CountReferences2.client_ville' => 'string', 'client_ville' => 'string', 'CountReferences2__client_mail' => 'string', 'CountReferences2.client_mail' => 'string', 'client_mail' => 'string', 'CountReferences2__client_tel' => 'string', 'CountReferences2.client_tel' => 'string', 'client_tel' => 'string', 'CountReferences2__client_autorisation' => 'boolean', 'CountReferences2.client_autorisation' => 'boolean', 'client_autorisation' => 'boolean', 'CountReferences2__fabricant' => 'string', 'CountReferences2.fabricant' => 'string', 'fabricant' => 'string', 'CountReferences2__photo' => 'string', 'CountReferences2.photo' => 'string', 'CountReferences2__photo_01' => 'string', 'CountReferences2.photo_01' => 'string', 'photo_01' => 'string', 'CountReferences2__photo_02' => 'string', 'CountReferences2.photo_02' => 'string', 'photo_02' => 'string', 'CountReferences2__photo_03' => 'string', 'CountReferences2.photo_03' => 'string', 'photo_03' => 'string', 'CountReferences2__photo_04' => 'string', 'CountReferences2.photo_04' => 'string', 'photo_04' => 'string', 'CountReferences2__photo_05' => 'string', 'CountReferences2.photo_05' => 'string', 'photo_05' => 'string', 'CountReferences2__dossier_technique' => 'string', 'CountReferences2.dossier_technique' => 'string', 'dossier_technique' => 'string', 'CountReferences2__video' => 'string', 'CountReferences2.video' => 'string', 'video' => 'string', 'CountReferences2__departements' => 'string', 'CountReferences2.departements' => 'string', 'departements' => 'string', 'CountReferences2__statut' => 'boolean', 'CountReferences2.statut' => 'boolean', 'statut' => 'boolean', 'CountReferences2__valid' => 'boolean', 'CountReferences2.valid' => 'boolean', 'valid' => 'boolean', 'CountReferences2__affichage_carte' => 'boolean', 'CountReferences2.affichage_carte' => 'boolean', 'affichage_carte' => 'boolean', 'CountReferences2__created' => 'datetime', 'CountReferences2.created' => 'datetime', 'CountReferences2__brouillon' => 'tinyinteger', 'CountReferences2.brouillon' => 'tinyinteger', 'brouillon' => 'tinyinteger', 'CountReferences2__admin_commentaire' => 'text', 'CountReferences2.admin_commentaire' => 'text', 'admin_commentaire' => 'text', 'LastPhotoReferences2__id' => 'integer', 'LastPhotoReferences2.id' => 'integer', 'LastPhotoReferences2__id_installateur' => 'integer', 'LastPhotoReferences2.id_installateur' => 'integer', 'LastPhotoReferences2__id_client' => 'integer', 'LastPhotoReferences2.id_client' => 'integer', 'LastPhotoReferences2__client_mail_send' => 'tinyinteger', 'LastPhotoReferences2.client_mail_send' => 'tinyinteger', 'LastPhotoReferences2__categorie' => 'integer', 'LastPhotoReferences2.categorie' => 'integer', 'LastPhotoReferences2__sous_categories' => 'string', 'LastPhotoReferences2.sous_categories' => 'string', 'LastPhotoReferences2__Lat' => 'decimal', 'LastPhotoReferences2.Lat' => 'decimal', 'LastPhotoReferences2__Lng' => 'decimal', 'LastPhotoReferences2.Lng' => 'decimal', 'LastPhotoReferences2__titre' => 'string', 'LastPhotoReferences2.titre' => 'string', 'LastPhotoReferences2__annee' => 'string', 'LastPhotoReferences2.annee' => 'string', 'LastPhotoReferences2__caracteristiques' => 'text', 'LastPhotoReferences2.caracteristiques' => 'text', 'LastPhotoReferences2__client_nom' => 'string', 'LastPhotoReferences2.client_nom' => 'string', 'LastPhotoReferences2__client_adresse' => 'text', 'LastPhotoReferences2.client_adresse' => 'text', 'LastPhotoReferences2__client_cp' => 'string', 'LastPhotoReferences2.client_cp' => 'string', 'LastPhotoReferences2__client_ville' => 'string', 'LastPhotoReferences2.client_ville' => 'string', 'LastPhotoReferences2__client_mail' => 'string', 'LastPhotoReferences2.client_mail' => 'string', 'LastPhotoReferences2__client_tel' => 'string', 'LastPhotoReferences2.client_tel' => 'string', 'LastPhotoReferences2__client_autorisation' => 'boolean', 'LastPhotoReferences2.client_autorisation' => 'boolean', 'LastPhotoReferences2__fabricant' => 'string', 'LastPhotoReferences2.fabricant' => 'string', 'LastPhotoReferences2__photo' => 'string', 'LastPhotoReferences2.photo' => 'string', 'LastPhotoReferences2__photo_01' => 'string', 'LastPhotoReferences2.photo_01' => 'string', 'LastPhotoReferences2__photo_02' => 'string', 'LastPhotoReferences2.photo_02' => 'string', 'LastPhotoReferences2__photo_03' => 'string', 'LastPhotoReferences2.photo_03' => 'string', 'LastPhotoReferences2__photo_04' => 'string', 'LastPhotoReferences2.photo_04' => 'string', 'LastPhotoReferences2__photo_05' => 'string', 'LastPhotoReferences2.photo_05' => 'string', 'LastPhotoReferences2__dossier_technique' => 'string', 'LastPhotoReferences2.dossier_technique' => 'string', 'LastPhotoReferences2__video' => 'string', 'LastPhotoReferences2.video' => 'string', 'LastPhotoReferences2__departements' => 'string', 'LastPhotoReferences2.departements' => 'string', 'LastPhotoReferences2__statut' => 'boolean', 'LastPhotoReferences2.statut' => 'boolean', 'LastPhotoReferences2__valid' => 'boolean', 'LastPhotoReferences2.valid' => 'boolean', 'LastPhotoReferences2__affichage_carte' => 'boolean', 'LastPhotoReferences2.affichage_carte' => 'boolean', 'LastPhotoReferences2__created' => 'datetime', 'LastPhotoReferences2.created' => 'datetime', 'LastPhotoReferences2__brouillon' => 'tinyinteger', 'LastPhotoReferences2.brouillon' => 'tinyinteger', 'LastPhotoReferences2__admin_commentaire' => 'text', 'LastPhotoReferences2.admin_commentaire' => 'text' ], 'decorators' => (int) 1, 'executed' => true, 'hydrate' => true, 'buffered' => true, 'formatters' => (int) 0, 'mapReducers' => (int) 0, 'contain' => [ 'Adresses' => [], 'Dirigeant' => [ 'queryBuilder' => object(Closure) {} ], 'Activites' => [ 'queryBuilder' => object(Closure) {} ], 'Parrains' => [ 'queryBuilder' => object(Closure) {} ], 'CountReferences2' => [ 'queryBuilder' => object(Closure) {} ], 'LastPhotoReferences2' => [ 'queryBuilder' => object(Closure) {} ] ], 'matching' => [], 'extraOptions' => [ 'scope' => null, 'sort' => 'totalReferences2', 'sortWhitelist' => [ (int) 0 => 'totalReferences2', (int) 1 => 'Activites.avis', (int) 2 => 'Listes.membre_partenaire' ], 'whitelist' => [ (int) 0 => 'limit', (int) 1 => 'sort', (int) 2 => 'page', (int) 3 => 'direction' ] ], 'repository' => object(App\Model\Table\ListesTable) { 'registryAlias' => 'Listes', 'table' => 'liste', 'alias' => 'Listes', 'entityClass' => 'App\Model\Entity\Liste', 'associations' => [ [maximum depth reached] ], 'behaviors' => [[maximum depth reached]], 'defaultConnection' => 'default', 'connectionName' => 'default' } }
} |
|
/* @var callable $callable */ |
|
$callable = [$this, $request->getParam('action')]; |
|
|
|
return $callable(...array_values($request->getParam('pass'))); |
|
} |
|
|
|
/** |
|
* Merge components, helpers vars from |
'51'
if ($result instanceof Response) { |
|
return $result; |
|
} |
|
|
|
$response = $controller->invokeAction(); |
|
if ($response !== null && !($response instanceof Response)) { |
|
throw new LogicException('Controller actions can only return Cake\Http\Response or null.'); |
|
} |
|
|
No arguments
} else { |
|
$controller = $this->factory->create($request, $response); |
|
} |
|
|
|
$response = $this->_invoke($controller); |
|
if (isset($request->params['return'])) { |
|
return $response; |
|
} |
|
|
object(App\Controller\ProfessionsController) { _jsVars => [] name => 'Professions' helpers => [] request => object(Cake\Http\ServerRequest) { params => [ [maximum depth reached] ] data => [[maximum depth reached]] query => [[maximum depth reached]] cookies => [[maximum depth reached]] url => 'professions/chauffagiste-cogeneration-pile-a-combustible-51/p/3' base => '' webroot => '/' here => '/professions/chauffagiste-cogeneration-pile-a-combustible-51/p/3' trustProxy => false [protected] _environment => [ [maximum depth reached] ] [protected] _input => null [protected] _detectors => [ [maximum depth reached] ] [protected] _detectorCache => [ [maximum depth reached] ] [protected] stream => object(Zend\Diactoros\PhpInputStream) {} [protected] uri => object(Zend\Diactoros\Uri) {} [protected] session => object(Cake\Network\Session) {} [protected] attributes => [[maximum depth reached]] [protected] emulatedAttributes => [ [maximum depth reached] ] [protected] uploadedFiles => [[maximum depth reached]] [protected] protocol => null [protected] requestTarget => null } response => object(Cake\Http\Response) { 'status' => (int) 200, 'contentType' => 'text/html', 'headers' => [ [maximum depth reached] ], 'file' => null, 'fileRange' => [[maximum depth reached]], 'cookies' => object(Cake\Http\Cookie\CookieCollection) {}, 'cacheDirectives' => [[maximum depth reached]], 'body' => '' } paginate => [ 'limit' => (int) 16, 'order' => [ 'totalReferences2' => 'desc' ], 'sortWhitelist' => [ (int) 0 => 'totalReferences2', (int) 1 => 'Activites.avis', (int) 2 => 'Listes.membre_partenaire' ], 'page' => (int) 3 ] autoRender => true components => [] View => null plugin => null passedArgs => [ (int) 0 => '51' ] modelClass => 'Professions' viewClass => null viewVars => [] RequestHandler => object(Cake\Controller\Component\RequestHandlerComponent) { 'components' => [[maximum depth reached]], 'implementedEvents' => [ [maximum depth reached] ], '_config' => [ [maximum depth reached] ] } Flash => object(Cake\Controller\Component\FlashComponent) { 'components' => [[maximum depth reached]], 'implementedEvents' => [[maximum depth reached]], '_config' => [ [maximum depth reached] ] } Auth => object(Cake\Controller\Component\AuthComponent) { 'components' => [ [maximum depth reached] ], 'implementedEvents' => [ [maximum depth reached] ], '_config' => [ [maximum depth reached] ] } Professions => object(App\Model\Table\ProfessionsTable) { 'registryAlias' => 'Professions', 'table' => 'professions', 'alias' => 'Professions', 'entityClass' => '\Cake\ORM\Entity', 'associations' => [ [maximum depth reached] ], 'behaviors' => [[maximum depth reached]], 'defaultConnection' => 'default', 'connectionName' => 'default' } Paginator => object(Cake\Controller\Component\PaginatorComponent) { 'components' => [[maximum depth reached]], 'implementedEvents' => [[maximum depth reached]], '_config' => [ [maximum depth reached] ] } [protected] _responseClass => 'Cake\Http\Response' [protected] _components => object(Cake\Controller\ComponentRegistry) { '_Controller' => object(App\Controller\ProfessionsController) {}, '_loaded' => [ [maximum depth reached] ], '_eventManager' => object(Cake\Event\EventManager) {}, '_eventClass' => 'Cake\Event\Event' } [protected] _validViewOptions => [ (int) 0 => 'passedArgs' ] [protected] _eventManager => object(Cake\Event\EventManager) { '_listeners' => [ [maximum depth reached] ], '_isGlobal' => false, '_trackEvents' => false, '_generalManager' => '(object) EventManager', '_dispatchedEvents' => null } [protected] _eventClass => 'Cake\Event\Event' [protected] _tableLocator => object(Cake\ORM\Locator\TableLocator) { [protected] _config => [[maximum depth reached]] [protected] _instances => [ [maximum depth reached] ] [protected] _fallbacked => [ [maximum depth reached] ] [protected] _options => [ [maximum depth reached] ] } [protected] _modelFactories => [ 'Table' => [ (int) 0 => object(Cake\ORM\Locator\TableLocator) {}, (int) 1 => 'get' ] ] [protected] _modelType => 'Table' [protected] _viewBuilder => null }
* @return \Psr\Http\Message\ResponseInterface |
|
*/ |
|
public function __invoke(ServerRequestInterface $request, ResponseInterface $response, $next) |
|
{ |
|
return $this->getDispatcher()->dispatch($request, $response); |
|
} |
|
|
|
/** |
|
* Get the ActionDispatcher. |
object(Cake\Http\ServerRequest) { params => [ 'slug' => 'chauffagiste-cogeneration-pile-a-combustible', 'id' => '51', 'page' => '3', 'pass' => [ (int) 0 => '51' ], 'controller' => 'Professions', 'action' => 'show', 'plugin' => null, '_matchedRoute' => '/professions/:slug-:id/p/:page', '_ext' => null, 'isAjax' => false, 'paging' => [ 'Listes' => [ [maximum depth reached] ] ] ] data => [] query => [] cookies => [] url => 'professions/chauffagiste-cogeneration-pile-a-combustible-51/p/3' base => '' webroot => '/' here => '/professions/chauffagiste-cogeneration-pile-a-combustible-51/p/3' trustProxy => false [protected] _environment => [ 'USER' => 'reseauec', 'HOME' => '/home/reseauec', 'SCRIPT_NAME' => '/webroot/index.php', 'REQUEST_URI' => '/professions/chauffagiste-cogeneration-pile-a-combustible-51/p/3', 'QUERY_STRING' => '', 'REQUEST_METHOD' => 'GET', 'SERVER_PROTOCOL' => 'HTTP/2.0', 'GATEWAY_INTERFACE' => 'CGI/1.1', 'REDIRECT_URL' => '/webroot/professions/chauffagiste-cogeneration-pile-a-combustible-51/p/3', 'REMOTE_PORT' => '57738', 'SCRIPT_FILENAME' => '/home/reseauec/www/webroot/index.php', 'SERVER_ADMIN' => '[no address given]', 'CONTEXT_DOCUMENT_ROOT' => '/home/reseauec/www', 'CONTEXT_PREFIX' => '', 'REQUEST_SCHEME' => 'https', 'DOCUMENT_ROOT' => '/home/reseauec/www', 'REMOTE_ADDR' => '100.26.140.179', 'SERVER_PORT' => '443', 'SERVER_ADDR' => '54.36.38.55', 'SERVER_NAME' => 'reseau-proeco-energies.fr', 'SERVER_SOFTWARE' => 'Apache', 'SERVER_SIGNATURE' => '<address>Apache Server at reseau-proeco-energies.fr Port 443</address> ', 'PATH' => '/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin', 'HTTP_HOST' => 'reseau-proeco-energies.fr', 'HTTP_USER_AGENT' => 'claudebot', 'HTTP_ACCEPT' => '*/*', 'proxy-nokeepalive' => '1', 'SSL_TLS_SNI' => 'reseau-proeco-energies.fr', 'HTTPS' => 'on', 'H2_STREAM_TAG' => '7878-3787-3', 'H2_STREAM_ID' => '3', 'H2_PUSHED_ON' => '', 'H2_PUSHED' => '', 'H2_PUSH' => 'off', 'H2PUSH' => 'off', 'HTTP2' => 'on', 'REDIRECT_STATUS' => '200', 'REDIRECT_SSL_TLS_SNI' => 'reseau-proeco-energies.fr', 'REDIRECT_HTTPS' => 'on', 'REDIRECT_H2_STREAM_TAG' => '7878-3787-3', 'REDIRECT_H2_STREAM_ID' => '3', 'REDIRECT_H2_PUSHED_ON' => '', 'REDIRECT_H2_PUSHED' => '', 'REDIRECT_H2_PUSH' => 'off', 'REDIRECT_H2PUSH' => 'off', 'REDIRECT_HTTP2' => 'on', 'REDIRECT_REDIRECT_STATUS' => '200', 'REDIRECT_REDIRECT_SSL_TLS_SNI' => 'reseau-proeco-energies.fr', 'REDIRECT_REDIRECT_HTTPS' => 'on', 'REDIRECT_REDIRECT_H2_STREAM_TAG' => '7878-3787-3', 'REDIRECT_REDIRECT_H2_STREAM_ID' => '3', 'REDIRECT_REDIRECT_H2_PUSHED_ON' => '', 'REDIRECT_REDIRECT_H2_PUSHED' => '', 'REDIRECT_REDIRECT_H2_PUSH' => 'off', 'REDIRECT_REDIRECT_H2PUSH' => 'off', 'REDIRECT_REDIRECT_HTTP2' => 'on', 'FCGI_ROLE' => 'RESPONDER', 'PHP_SELF' => '/webroot/index.php', 'REQUEST_TIME_FLOAT' => (float) 1711631837.7648, 'REQUEST_TIME' => (int) 1711631837, 'ORIGINAL_REQUEST_METHOD' => 'GET', 'HTTP_X_REQUESTED_WITH' => null, 'HTTP_IF_NONE_MATCH' => null, 'HTTP_IF_MODIFIED_SINCE' => null ] [protected] _input => null [protected] _detectors => [ 'get' => [ 'env' => 'REQUEST_METHOD', 'value' => 'GET' ], 'post' => [ 'env' => 'REQUEST_METHOD', 'value' => 'POST' ], 'put' => [ 'env' => 'REQUEST_METHOD', 'value' => 'PUT' ], 'patch' => [ 'env' => 'REQUEST_METHOD', 'value' => 'PATCH' ], 'delete' => [ 'env' => 'REQUEST_METHOD', 'value' => 'DELETE' ], 'head' => [ 'env' => 'REQUEST_METHOD', 'value' => 'HEAD' ], 'options' => [ 'env' => 'REQUEST_METHOD', 'value' => 'OPTIONS' ], 'ssl' => [ 'env' => 'HTTPS', 'options' => [ [maximum depth reached] ] ], 'ajax' => [ 'env' => 'HTTP_X_REQUESTED_WITH', 'value' => 'XMLHttpRequest' ], 'flash' => [ 'env' => 'HTTP_USER_AGENT', 'pattern' => '/^(Shockwave|Adobe) Flash/' ], 'requested' => [ 'param' => 'requested', 'value' => (int) 1 ], 'json' => [ 'accept' => [ [maximum depth reached] ], 'param' => '_ext', 'value' => 'json' ], 'xml' => [ 'accept' => [ [maximum depth reached] ], 'param' => '_ext', 'value' => 'xml' ], 'mobile' => object(Closure) {}, 'tablet' => object(Closure) {} ] [protected] _detectorCache => [ 'ajax' => false, 'get' => true, 'head' => false, 'options' => false, 'post' => false ] [protected] stream => object(Zend\Diactoros\PhpInputStream) { [protected] resource => resource [protected] stream => 'php://input' [private] cache => '' [private] reachedEof => false } [protected] uri => object(Zend\Diactoros\Uri) { base => '' webroot => '/' [protected] allowedSchemes => [ [maximum depth reached] ] [private] scheme => 'https' [private] userInfo => '' [private] host => 'reseau-proeco-energies.fr' [private] port => null [private] path => '/professions/chauffagiste-cogeneration-pile-a-combustible-51/p/3' [private] query => '' [private] fragment => '' [private] uriString => null } [protected] session => object(Cake\Network\Session) { [protected] _engine => null [protected] _started => false [protected] _lifetime => '7200' [protected] _isCLI => false } [protected] attributes => [] [protected] emulatedAttributes => [ (int) 0 => 'session', (int) 1 => 'webroot', (int) 2 => 'base', (int) 3 => 'params' ] [protected] uploadedFiles => [] [protected] protocol => null [protected] requestTarget => null } object(Cake\Http\Response) { 'status' => (int) 200, 'contentType' => 'text/html', 'headers' => [ 'Content-Type' => [ (int) 0 => 'text/html; charset=UTF-8' ] ], 'file' => null, 'fileRange' => [], 'cookies' => object(Cake\Http\Cookie\CookieCollection) { [protected] cookies => [[maximum depth reached]] }, 'cacheDirectives' => [], 'body' => '' }
$next = $this->middleware->get($this->index); |
|
if ($next) { |
|
$this->index++; |
|
|
|
return $next($request, $response, $this); |
|
} |
|
|
|
// End of the queue |
|
return $response; |
object(Cake\Http\ServerRequest) { params => [ 'slug' => 'chauffagiste-cogeneration-pile-a-combustible', 'id' => '51', 'page' => '3', 'pass' => [ (int) 0 => '51' ], 'controller' => 'Professions', 'action' => 'show', 'plugin' => null, '_matchedRoute' => '/professions/:slug-:id/p/:page', '_ext' => null, 'isAjax' => false, 'paging' => [ 'Listes' => [ [maximum depth reached] ] ] ] data => [] query => [] cookies => [] url => 'professions/chauffagiste-cogeneration-pile-a-combustible-51/p/3' base => '' webroot => '/' here => '/professions/chauffagiste-cogeneration-pile-a-combustible-51/p/3' trustProxy => false [protected] _environment => [ 'USER' => 'reseauec', 'HOME' => '/home/reseauec', 'SCRIPT_NAME' => '/webroot/index.php', 'REQUEST_URI' => '/professions/chauffagiste-cogeneration-pile-a-combustible-51/p/3', 'QUERY_STRING' => '', 'REQUEST_METHOD' => 'GET', 'SERVER_PROTOCOL' => 'HTTP/2.0', 'GATEWAY_INTERFACE' => 'CGI/1.1', 'REDIRECT_URL' => '/webroot/professions/chauffagiste-cogeneration-pile-a-combustible-51/p/3', 'REMOTE_PORT' => '57738', 'SCRIPT_FILENAME' => '/home/reseauec/www/webroot/index.php', 'SERVER_ADMIN' => '[no address given]', 'CONTEXT_DOCUMENT_ROOT' => '/home/reseauec/www', 'CONTEXT_PREFIX' => '', 'REQUEST_SCHEME' => 'https', 'DOCUMENT_ROOT' => '/home/reseauec/www', 'REMOTE_ADDR' => '100.26.140.179', 'SERVER_PORT' => '443', 'SERVER_ADDR' => '54.36.38.55', 'SERVER_NAME' => 'reseau-proeco-energies.fr', 'SERVER_SOFTWARE' => 'Apache', 'SERVER_SIGNATURE' => '<address>Apache Server at reseau-proeco-energies.fr Port 443</address> ', 'PATH' => '/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin', 'HTTP_HOST' => 'reseau-proeco-energies.fr', 'HTTP_USER_AGENT' => 'claudebot', 'HTTP_ACCEPT' => '*/*', 'proxy-nokeepalive' => '1', 'SSL_TLS_SNI' => 'reseau-proeco-energies.fr', 'HTTPS' => 'on', 'H2_STREAM_TAG' => '7878-3787-3', 'H2_STREAM_ID' => '3', 'H2_PUSHED_ON' => '', 'H2_PUSHED' => '', 'H2_PUSH' => 'off', 'H2PUSH' => 'off', 'HTTP2' => 'on', 'REDIRECT_STATUS' => '200', 'REDIRECT_SSL_TLS_SNI' => 'reseau-proeco-energies.fr', 'REDIRECT_HTTPS' => 'on', 'REDIRECT_H2_STREAM_TAG' => '7878-3787-3', 'REDIRECT_H2_STREAM_ID' => '3', 'REDIRECT_H2_PUSHED_ON' => '', 'REDIRECT_H2_PUSHED' => '', 'REDIRECT_H2_PUSH' => 'off', 'REDIRECT_H2PUSH' => 'off', 'REDIRECT_HTTP2' => 'on', 'REDIRECT_REDIRECT_STATUS' => '200', 'REDIRECT_REDIRECT_SSL_TLS_SNI' => 'reseau-proeco-energies.fr', 'REDIRECT_REDIRECT_HTTPS' => 'on', 'REDIRECT_REDIRECT_H2_STREAM_TAG' => '7878-3787-3', 'REDIRECT_REDIRECT_H2_STREAM_ID' => '3', 'REDIRECT_REDIRECT_H2_PUSHED_ON' => '', 'REDIRECT_REDIRECT_H2_PUSHED' => '', 'REDIRECT_REDIRECT_H2_PUSH' => 'off', 'REDIRECT_REDIRECT_H2PUSH' => 'off', 'REDIRECT_REDIRECT_HTTP2' => 'on', 'FCGI_ROLE' => 'RESPONDER', 'PHP_SELF' => '/webroot/index.php', 'REQUEST_TIME_FLOAT' => (float) 1711631837.7648, 'REQUEST_TIME' => (int) 1711631837, 'ORIGINAL_REQUEST_METHOD' => 'GET', 'HTTP_X_REQUESTED_WITH' => null, 'HTTP_IF_NONE_MATCH' => null, 'HTTP_IF_MODIFIED_SINCE' => null ] [protected] _input => null [protected] _detectors => [ 'get' => [ 'env' => 'REQUEST_METHOD', 'value' => 'GET' ], 'post' => [ 'env' => 'REQUEST_METHOD', 'value' => 'POST' ], 'put' => [ 'env' => 'REQUEST_METHOD', 'value' => 'PUT' ], 'patch' => [ 'env' => 'REQUEST_METHOD', 'value' => 'PATCH' ], 'delete' => [ 'env' => 'REQUEST_METHOD', 'value' => 'DELETE' ], 'head' => [ 'env' => 'REQUEST_METHOD', 'value' => 'HEAD' ], 'options' => [ 'env' => 'REQUEST_METHOD', 'value' => 'OPTIONS' ], 'ssl' => [ 'env' => 'HTTPS', 'options' => [ [maximum depth reached] ] ], 'ajax' => [ 'env' => 'HTTP_X_REQUESTED_WITH', 'value' => 'XMLHttpRequest' ], 'flash' => [ 'env' => 'HTTP_USER_AGENT', 'pattern' => '/^(Shockwave|Adobe) Flash/' ], 'requested' => [ 'param' => 'requested', 'value' => (int) 1 ], 'json' => [ 'accept' => [ [maximum depth reached] ], 'param' => '_ext', 'value' => 'json' ], 'xml' => [ 'accept' => [ [maximum depth reached] ], 'param' => '_ext', 'value' => 'xml' ], 'mobile' => object(Closure) {}, 'tablet' => object(Closure) {} ] [protected] _detectorCache => [ 'ajax' => false, 'get' => true, 'head' => false, 'options' => false, 'post' => false ] [protected] stream => object(Zend\Diactoros\PhpInputStream) { [protected] resource => resource [protected] stream => 'php://input' [private] cache => '' [private] reachedEof => false } [protected] uri => object(Zend\Diactoros\Uri) { base => '' webroot => '/' [protected] allowedSchemes => [ [maximum depth reached] ] [private] scheme => 'https' [private] userInfo => '' [private] host => 'reseau-proeco-energies.fr' [private] port => null [private] path => '/professions/chauffagiste-cogeneration-pile-a-combustible-51/p/3' [private] query => '' [private] fragment => '' [private] uriString => null } [protected] session => object(Cake\Network\Session) { [protected] _engine => null [protected] _started => false [protected] _lifetime => '7200' [protected] _isCLI => false } [protected] attributes => [] [protected] emulatedAttributes => [ (int) 0 => 'session', (int) 1 => 'webroot', (int) 2 => 'base', (int) 3 => 'params' ] [protected] uploadedFiles => [] [protected] protocol => null [protected] requestTarget => null } object(Cake\Http\Response) { 'status' => (int) 200, 'contentType' => 'text/html', 'headers' => [ 'Content-Type' => [ (int) 0 => 'text/html; charset=UTF-8' ] ], 'file' => null, 'fileRange' => [], 'cookies' => object(Cake\Http\Cookie\CookieCollection) { [protected] cookies => [[maximum depth reached]] }, 'cacheDirectives' => [], 'body' => '' } object(Cake\Http\Runner) { [protected] index => (int) 4 [protected] middleware => object(Cake\Http\MiddlewareQueue) { [protected] queue => [ [maximum depth reached] ] [protected] callables => [ [maximum depth reached] ] } }
); |
|
} |
|
$matching = Router::getRouteCollection()->getMiddleware($middleware); |
|
if (!$matching) { |
|
return $next($request, $response); |
|
} |
|
$matching[] = $next; |
|
$middleware = new MiddlewareQueue($matching); |
|
$runner = new Runner(); |
object(Cake\Http\ServerRequest) { params => [ 'slug' => 'chauffagiste-cogeneration-pile-a-combustible', 'id' => '51', 'page' => '3', 'pass' => [ (int) 0 => '51' ], 'controller' => 'Professions', 'action' => 'show', 'plugin' => null, '_matchedRoute' => '/professions/:slug-:id/p/:page', '_ext' => null, 'isAjax' => false, 'paging' => [ 'Listes' => [ [maximum depth reached] ] ] ] data => [] query => [] cookies => [] url => 'professions/chauffagiste-cogeneration-pile-a-combustible-51/p/3' base => '' webroot => '/' here => '/professions/chauffagiste-cogeneration-pile-a-combustible-51/p/3' trustProxy => false [protected] _environment => [ 'USER' => 'reseauec', 'HOME' => '/home/reseauec', 'SCRIPT_NAME' => '/webroot/index.php', 'REQUEST_URI' => '/professions/chauffagiste-cogeneration-pile-a-combustible-51/p/3', 'QUERY_STRING' => '', 'REQUEST_METHOD' => 'GET', 'SERVER_PROTOCOL' => 'HTTP/2.0', 'GATEWAY_INTERFACE' => 'CGI/1.1', 'REDIRECT_URL' => '/webroot/professions/chauffagiste-cogeneration-pile-a-combustible-51/p/3', 'REMOTE_PORT' => '57738', 'SCRIPT_FILENAME' => '/home/reseauec/www/webroot/index.php', 'SERVER_ADMIN' => '[no address given]', 'CONTEXT_DOCUMENT_ROOT' => '/home/reseauec/www', 'CONTEXT_PREFIX' => '', 'REQUEST_SCHEME' => 'https', 'DOCUMENT_ROOT' => '/home/reseauec/www', 'REMOTE_ADDR' => '100.26.140.179', 'SERVER_PORT' => '443', 'SERVER_ADDR' => '54.36.38.55', 'SERVER_NAME' => 'reseau-proeco-energies.fr', 'SERVER_SOFTWARE' => 'Apache', 'SERVER_SIGNATURE' => '<address>Apache Server at reseau-proeco-energies.fr Port 443</address> ', 'PATH' => '/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin', 'HTTP_HOST' => 'reseau-proeco-energies.fr', 'HTTP_USER_AGENT' => 'claudebot', 'HTTP_ACCEPT' => '*/*', 'proxy-nokeepalive' => '1', 'SSL_TLS_SNI' => 'reseau-proeco-energies.fr', 'HTTPS' => 'on', 'H2_STREAM_TAG' => '7878-3787-3', 'H2_STREAM_ID' => '3', 'H2_PUSHED_ON' => '', 'H2_PUSHED' => '', 'H2_PUSH' => 'off', 'H2PUSH' => 'off', 'HTTP2' => 'on', 'REDIRECT_STATUS' => '200', 'REDIRECT_SSL_TLS_SNI' => 'reseau-proeco-energies.fr', 'REDIRECT_HTTPS' => 'on', 'REDIRECT_H2_STREAM_TAG' => '7878-3787-3', 'REDIRECT_H2_STREAM_ID' => '3', 'REDIRECT_H2_PUSHED_ON' => '', 'REDIRECT_H2_PUSHED' => '', 'REDIRECT_H2_PUSH' => 'off', 'REDIRECT_H2PUSH' => 'off', 'REDIRECT_HTTP2' => 'on', 'REDIRECT_REDIRECT_STATUS' => '200', 'REDIRECT_REDIRECT_SSL_TLS_SNI' => 'reseau-proeco-energies.fr', 'REDIRECT_REDIRECT_HTTPS' => 'on', 'REDIRECT_REDIRECT_H2_STREAM_TAG' => '7878-3787-3', 'REDIRECT_REDIRECT_H2_STREAM_ID' => '3', 'REDIRECT_REDIRECT_H2_PUSHED_ON' => '', 'REDIRECT_REDIRECT_H2_PUSHED' => '', 'REDIRECT_REDIRECT_H2_PUSH' => 'off', 'REDIRECT_REDIRECT_H2PUSH' => 'off', 'REDIRECT_REDIRECT_HTTP2' => 'on', 'FCGI_ROLE' => 'RESPONDER', 'PHP_SELF' => '/webroot/index.php', 'REQUEST_TIME_FLOAT' => (float) 1711631837.7648, 'REQUEST_TIME' => (int) 1711631837, 'ORIGINAL_REQUEST_METHOD' => 'GET', 'HTTP_X_REQUESTED_WITH' => null, 'HTTP_IF_NONE_MATCH' => null, 'HTTP_IF_MODIFIED_SINCE' => null ] [protected] _input => null [protected] _detectors => [ 'get' => [ 'env' => 'REQUEST_METHOD', 'value' => 'GET' ], 'post' => [ 'env' => 'REQUEST_METHOD', 'value' => 'POST' ], 'put' => [ 'env' => 'REQUEST_METHOD', 'value' => 'PUT' ], 'patch' => [ 'env' => 'REQUEST_METHOD', 'value' => 'PATCH' ], 'delete' => [ 'env' => 'REQUEST_METHOD', 'value' => 'DELETE' ], 'head' => [ 'env' => 'REQUEST_METHOD', 'value' => 'HEAD' ], 'options' => [ 'env' => 'REQUEST_METHOD', 'value' => 'OPTIONS' ], 'ssl' => [ 'env' => 'HTTPS', 'options' => [ [maximum depth reached] ] ], 'ajax' => [ 'env' => 'HTTP_X_REQUESTED_WITH', 'value' => 'XMLHttpRequest' ], 'flash' => [ 'env' => 'HTTP_USER_AGENT', 'pattern' => '/^(Shockwave|Adobe) Flash/' ], 'requested' => [ 'param' => 'requested', 'value' => (int) 1 ], 'json' => [ 'accept' => [ [maximum depth reached] ], 'param' => '_ext', 'value' => 'json' ], 'xml' => [ 'accept' => [ [maximum depth reached] ], 'param' => '_ext', 'value' => 'xml' ], 'mobile' => object(Closure) {}, 'tablet' => object(Closure) {} ] [protected] _detectorCache => [ 'ajax' => false, 'get' => true, 'head' => false, 'options' => false, 'post' => false ] [protected] stream => object(Zend\Diactoros\PhpInputStream) { [protected] resource => resource [protected] stream => 'php://input' [private] cache => '' [private] reachedEof => false } [protected] uri => object(Zend\Diactoros\Uri) { base => '' webroot => '/' [protected] allowedSchemes => [ [maximum depth reached] ] [private] scheme => 'https' [private] userInfo => '' [private] host => 'reseau-proeco-energies.fr' [private] port => null [private] path => '/professions/chauffagiste-cogeneration-pile-a-combustible-51/p/3' [private] query => '' [private] fragment => '' [private] uriString => null } [protected] session => object(Cake\Network\Session) { [protected] _engine => null [protected] _started => false [protected] _lifetime => '7200' [protected] _isCLI => false } [protected] attributes => [] [protected] emulatedAttributes => [ (int) 0 => 'session', (int) 1 => 'webroot', (int) 2 => 'base', (int) 3 => 'params' ] [protected] uploadedFiles => [] [protected] protocol => null [protected] requestTarget => null } object(Cake\Http\Response) { 'status' => (int) 200, 'contentType' => 'text/html', 'headers' => [ 'Content-Type' => [ (int) 0 => 'text/html; charset=UTF-8' ] ], 'file' => null, 'fileRange' => [], 'cookies' => object(Cake\Http\Cookie\CookieCollection) { [protected] cookies => [[maximum depth reached]] }, 'cacheDirectives' => [], 'body' => '' }
$next = $this->middleware->get($this->index); |
|
if ($next) { |
|
$this->index++; |
|
|
|
return $next($request, $response, $this); |
|
} |
|
|
|
// End of the queue |
|
return $response; |
object(Cake\Http\ServerRequest) { params => [ 'slug' => 'chauffagiste-cogeneration-pile-a-combustible', 'id' => '51', 'page' => '3', 'pass' => [ (int) 0 => '51' ], 'controller' => 'Professions', 'action' => 'show', 'plugin' => null, '_matchedRoute' => '/professions/:slug-:id/p/:page', '_ext' => null, 'isAjax' => false, 'paging' => [ 'Listes' => [ [maximum depth reached] ] ] ] data => [] query => [] cookies => [] url => 'professions/chauffagiste-cogeneration-pile-a-combustible-51/p/3' base => '' webroot => '/' here => '/professions/chauffagiste-cogeneration-pile-a-combustible-51/p/3' trustProxy => false [protected] _environment => [ 'USER' => 'reseauec', 'HOME' => '/home/reseauec', 'SCRIPT_NAME' => '/webroot/index.php', 'REQUEST_URI' => '/professions/chauffagiste-cogeneration-pile-a-combustible-51/p/3', 'QUERY_STRING' => '', 'REQUEST_METHOD' => 'GET', 'SERVER_PROTOCOL' => 'HTTP/2.0', 'GATEWAY_INTERFACE' => 'CGI/1.1', 'REDIRECT_URL' => '/webroot/professions/chauffagiste-cogeneration-pile-a-combustible-51/p/3', 'REMOTE_PORT' => '57738', 'SCRIPT_FILENAME' => '/home/reseauec/www/webroot/index.php', 'SERVER_ADMIN' => '[no address given]', 'CONTEXT_DOCUMENT_ROOT' => '/home/reseauec/www', 'CONTEXT_PREFIX' => '', 'REQUEST_SCHEME' => 'https', 'DOCUMENT_ROOT' => '/home/reseauec/www', 'REMOTE_ADDR' => '100.26.140.179', 'SERVER_PORT' => '443', 'SERVER_ADDR' => '54.36.38.55', 'SERVER_NAME' => 'reseau-proeco-energies.fr', 'SERVER_SOFTWARE' => 'Apache', 'SERVER_SIGNATURE' => '<address>Apache Server at reseau-proeco-energies.fr Port 443</address> ', 'PATH' => '/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin', 'HTTP_HOST' => 'reseau-proeco-energies.fr', 'HTTP_USER_AGENT' => 'claudebot', 'HTTP_ACCEPT' => '*/*', 'proxy-nokeepalive' => '1', 'SSL_TLS_SNI' => 'reseau-proeco-energies.fr', 'HTTPS' => 'on', 'H2_STREAM_TAG' => '7878-3787-3', 'H2_STREAM_ID' => '3', 'H2_PUSHED_ON' => '', 'H2_PUSHED' => '', 'H2_PUSH' => 'off', 'H2PUSH' => 'off', 'HTTP2' => 'on', 'REDIRECT_STATUS' => '200', 'REDIRECT_SSL_TLS_SNI' => 'reseau-proeco-energies.fr', 'REDIRECT_HTTPS' => 'on', 'REDIRECT_H2_STREAM_TAG' => '7878-3787-3', 'REDIRECT_H2_STREAM_ID' => '3', 'REDIRECT_H2_PUSHED_ON' => '', 'REDIRECT_H2_PUSHED' => '', 'REDIRECT_H2_PUSH' => 'off', 'REDIRECT_H2PUSH' => 'off', 'REDIRECT_HTTP2' => 'on', 'REDIRECT_REDIRECT_STATUS' => '200', 'REDIRECT_REDIRECT_SSL_TLS_SNI' => 'reseau-proeco-energies.fr', 'REDIRECT_REDIRECT_HTTPS' => 'on', 'REDIRECT_REDIRECT_H2_STREAM_TAG' => '7878-3787-3', 'REDIRECT_REDIRECT_H2_STREAM_ID' => '3', 'REDIRECT_REDIRECT_H2_PUSHED_ON' => '', 'REDIRECT_REDIRECT_H2_PUSHED' => '', 'REDIRECT_REDIRECT_H2_PUSH' => 'off', 'REDIRECT_REDIRECT_H2PUSH' => 'off', 'REDIRECT_REDIRECT_HTTP2' => 'on', 'FCGI_ROLE' => 'RESPONDER', 'PHP_SELF' => '/webroot/index.php', 'REQUEST_TIME_FLOAT' => (float) 1711631837.7648, 'REQUEST_TIME' => (int) 1711631837, 'ORIGINAL_REQUEST_METHOD' => 'GET', 'HTTP_X_REQUESTED_WITH' => null, 'HTTP_IF_NONE_MATCH' => null, 'HTTP_IF_MODIFIED_SINCE' => null ] [protected] _input => null [protected] _detectors => [ 'get' => [ 'env' => 'REQUEST_METHOD', 'value' => 'GET' ], 'post' => [ 'env' => 'REQUEST_METHOD', 'value' => 'POST' ], 'put' => [ 'env' => 'REQUEST_METHOD', 'value' => 'PUT' ], 'patch' => [ 'env' => 'REQUEST_METHOD', 'value' => 'PATCH' ], 'delete' => [ 'env' => 'REQUEST_METHOD', 'value' => 'DELETE' ], 'head' => [ 'env' => 'REQUEST_METHOD', 'value' => 'HEAD' ], 'options' => [ 'env' => 'REQUEST_METHOD', 'value' => 'OPTIONS' ], 'ssl' => [ 'env' => 'HTTPS', 'options' => [ [maximum depth reached] ] ], 'ajax' => [ 'env' => 'HTTP_X_REQUESTED_WITH', 'value' => 'XMLHttpRequest' ], 'flash' => [ 'env' => 'HTTP_USER_AGENT', 'pattern' => '/^(Shockwave|Adobe) Flash/' ], 'requested' => [ 'param' => 'requested', 'value' => (int) 1 ], 'json' => [ 'accept' => [ [maximum depth reached] ], 'param' => '_ext', 'value' => 'json' ], 'xml' => [ 'accept' => [ [maximum depth reached] ], 'param' => '_ext', 'value' => 'xml' ], 'mobile' => object(Closure) {}, 'tablet' => object(Closure) {} ] [protected] _detectorCache => [ 'ajax' => false, 'get' => true, 'head' => false, 'options' => false, 'post' => false ] [protected] stream => object(Zend\Diactoros\PhpInputStream) { [protected] resource => resource [protected] stream => 'php://input' [private] cache => '' [private] reachedEof => false } [protected] uri => object(Zend\Diactoros\Uri) { base => '' webroot => '/' [protected] allowedSchemes => [ [maximum depth reached] ] [private] scheme => 'https' [private] userInfo => '' [private] host => 'reseau-proeco-energies.fr' [private] port => null [private] path => '/professions/chauffagiste-cogeneration-pile-a-combustible-51/p/3' [private] query => '' [private] fragment => '' [private] uriString => null } [protected] session => object(Cake\Network\Session) { [protected] _engine => null [protected] _started => false [protected] _lifetime => '7200' [protected] _isCLI => false } [protected] attributes => [] [protected] emulatedAttributes => [ (int) 0 => 'session', (int) 1 => 'webroot', (int) 2 => 'base', (int) 3 => 'params' ] [protected] uploadedFiles => [] [protected] protocol => null [protected] requestTarget => null } object(Cake\Http\Response) { 'status' => (int) 200, 'contentType' => 'text/html', 'headers' => [ 'Content-Type' => [ (int) 0 => 'text/html; charset=UTF-8' ] ], 'file' => null, 'fileRange' => [], 'cookies' => object(Cake\Http\Cookie\CookieCollection) { [protected] cookies => [[maximum depth reached]] }, 'cacheDirectives' => [], 'body' => '' } object(Cake\Http\Runner) { [protected] index => (int) 4 [protected] middleware => object(Cake\Http\MiddlewareQueue) { [protected] queue => [ [maximum depth reached] ] [protected] callables => [ [maximum depth reached] ] } }
public function __invoke($request, $response, $next) |
|
{ |
|
$url = $request->getUri()->getPath(); |
|
if (strpos($url, '..') !== false || strpos($url, '.') === false) { |
|
return $next($request, $response); |
|
} |
|
|
|
if (strpos($url, '/.') !== false) { |
|
return $next($request, $response); |
object(Cake\Http\ServerRequest) { params => [ 'plugin' => null, 'controller' => null, 'action' => null, '_ext' => null, 'pass' => [] ] data => [] query => [] cookies => [] url => 'professions/chauffagiste-cogeneration-pile-a-combustible-51/p/3' base => '' webroot => '/' here => '/professions/chauffagiste-cogeneration-pile-a-combustible-51/p/3' trustProxy => false [protected] _environment => [ 'USER' => 'reseauec', 'HOME' => '/home/reseauec', 'SCRIPT_NAME' => '/webroot/index.php', 'REQUEST_URI' => '/professions/chauffagiste-cogeneration-pile-a-combustible-51/p/3', 'QUERY_STRING' => '', 'REQUEST_METHOD' => 'GET', 'SERVER_PROTOCOL' => 'HTTP/2.0', 'GATEWAY_INTERFACE' => 'CGI/1.1', 'REDIRECT_URL' => '/webroot/professions/chauffagiste-cogeneration-pile-a-combustible-51/p/3', 'REMOTE_PORT' => '57738', 'SCRIPT_FILENAME' => '/home/reseauec/www/webroot/index.php', 'SERVER_ADMIN' => '[no address given]', 'CONTEXT_DOCUMENT_ROOT' => '/home/reseauec/www', 'CONTEXT_PREFIX' => '', 'REQUEST_SCHEME' => 'https', 'DOCUMENT_ROOT' => '/home/reseauec/www', 'REMOTE_ADDR' => '100.26.140.179', 'SERVER_PORT' => '443', 'SERVER_ADDR' => '54.36.38.55', 'SERVER_NAME' => 'reseau-proeco-energies.fr', 'SERVER_SOFTWARE' => 'Apache', 'SERVER_SIGNATURE' => '<address>Apache Server at reseau-proeco-energies.fr Port 443</address> ', 'PATH' => '/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin', 'HTTP_HOST' => 'reseau-proeco-energies.fr', 'HTTP_USER_AGENT' => 'claudebot', 'HTTP_ACCEPT' => '*/*', 'proxy-nokeepalive' => '1', 'SSL_TLS_SNI' => 'reseau-proeco-energies.fr', 'HTTPS' => 'on', 'H2_STREAM_TAG' => '7878-3787-3', 'H2_STREAM_ID' => '3', 'H2_PUSHED_ON' => '', 'H2_PUSHED' => '', 'H2_PUSH' => 'off', 'H2PUSH' => 'off', 'HTTP2' => 'on', 'REDIRECT_STATUS' => '200', 'REDIRECT_SSL_TLS_SNI' => 'reseau-proeco-energies.fr', 'REDIRECT_HTTPS' => 'on', 'REDIRECT_H2_STREAM_TAG' => '7878-3787-3', 'REDIRECT_H2_STREAM_ID' => '3', 'REDIRECT_H2_PUSHED_ON' => '', 'REDIRECT_H2_PUSHED' => '', 'REDIRECT_H2_PUSH' => 'off', 'REDIRECT_H2PUSH' => 'off', 'REDIRECT_HTTP2' => 'on', 'REDIRECT_REDIRECT_STATUS' => '200', 'REDIRECT_REDIRECT_SSL_TLS_SNI' => 'reseau-proeco-energies.fr', 'REDIRECT_REDIRECT_HTTPS' => 'on', 'REDIRECT_REDIRECT_H2_STREAM_TAG' => '7878-3787-3', 'REDIRECT_REDIRECT_H2_STREAM_ID' => '3', 'REDIRECT_REDIRECT_H2_PUSHED_ON' => '', 'REDIRECT_REDIRECT_H2_PUSHED' => '', 'REDIRECT_REDIRECT_H2_PUSH' => 'off', 'REDIRECT_REDIRECT_H2PUSH' => 'off', 'REDIRECT_REDIRECT_HTTP2' => 'on', 'FCGI_ROLE' => 'RESPONDER', 'PHP_SELF' => '/webroot/index.php', 'REQUEST_TIME_FLOAT' => (float) 1711631837.7648, 'REQUEST_TIME' => (int) 1711631837, 'ORIGINAL_REQUEST_METHOD' => 'GET' ] [protected] _input => null [protected] _detectors => [ 'get' => [ 'env' => 'REQUEST_METHOD', 'value' => 'GET' ], 'post' => [ 'env' => 'REQUEST_METHOD', 'value' => 'POST' ], 'put' => [ 'env' => 'REQUEST_METHOD', 'value' => 'PUT' ], 'patch' => [ 'env' => 'REQUEST_METHOD', 'value' => 'PATCH' ], 'delete' => [ 'env' => 'REQUEST_METHOD', 'value' => 'DELETE' ], 'head' => [ 'env' => 'REQUEST_METHOD', 'value' => 'HEAD' ], 'options' => [ 'env' => 'REQUEST_METHOD', 'value' => 'OPTIONS' ], 'ssl' => [ 'env' => 'HTTPS', 'options' => [ [maximum depth reached] ] ], 'ajax' => [ 'env' => 'HTTP_X_REQUESTED_WITH', 'value' => 'XMLHttpRequest' ], 'flash' => [ 'env' => 'HTTP_USER_AGENT', 'pattern' => '/^(Shockwave|Adobe) Flash/' ], 'requested' => [ 'param' => 'requested', 'value' => (int) 1 ], 'json' => [ 'accept' => [ [maximum depth reached] ], 'param' => '_ext', 'value' => 'json' ], 'xml' => [ 'accept' => [ [maximum depth reached] ], 'param' => '_ext', 'value' => 'xml' ], 'mobile' => object(Closure) {}, 'tablet' => object(Closure) {} ] [protected] _detectorCache => [] [protected] stream => object(Zend\Diactoros\PhpInputStream) { [protected] resource => resource [protected] stream => 'php://input' [private] cache => '' [private] reachedEof => false } [protected] uri => object(Zend\Diactoros\Uri) { base => '' webroot => '/' [protected] allowedSchemes => [ [maximum depth reached] ] [private] scheme => 'https' [private] userInfo => '' [private] host => 'reseau-proeco-energies.fr' [private] port => null [private] path => '/professions/chauffagiste-cogeneration-pile-a-combustible-51/p/3' [private] query => '' [private] fragment => '' [private] uriString => null } [protected] session => object(Cake\Network\Session) { [protected] _engine => null [protected] _started => false [protected] _lifetime => '7200' [protected] _isCLI => false } [protected] attributes => [] [protected] emulatedAttributes => [ (int) 0 => 'session', (int) 1 => 'webroot', (int) 2 => 'base', (int) 3 => 'params' ] [protected] uploadedFiles => [] [protected] protocol => null [protected] requestTarget => null } object(Cake\Http\Response) { 'status' => (int) 200, 'contentType' => 'text/html', 'headers' => [ 'Content-Type' => [ (int) 0 => 'text/html; charset=UTF-8' ] ], 'file' => null, 'fileRange' => [], 'cookies' => object(Cake\Http\Cookie\CookieCollection) { [protected] cookies => [[maximum depth reached]] }, 'cacheDirectives' => [], 'body' => '' }
$next = $this->middleware->get($this->index); |
|
if ($next) { |
|
$this->index++; |
|
|
|
return $next($request, $response, $this); |
|
} |
|
|
|
// End of the queue |
|
return $response; |
object(Cake\Http\ServerRequest) { params => [ 'plugin' => null, 'controller' => null, 'action' => null, '_ext' => null, 'pass' => [] ] data => [] query => [] cookies => [] url => 'professions/chauffagiste-cogeneration-pile-a-combustible-51/p/3' base => '' webroot => '/' here => '/professions/chauffagiste-cogeneration-pile-a-combustible-51/p/3' trustProxy => false [protected] _environment => [ 'USER' => 'reseauec', 'HOME' => '/home/reseauec', 'SCRIPT_NAME' => '/webroot/index.php', 'REQUEST_URI' => '/professions/chauffagiste-cogeneration-pile-a-combustible-51/p/3', 'QUERY_STRING' => '', 'REQUEST_METHOD' => 'GET', 'SERVER_PROTOCOL' => 'HTTP/2.0', 'GATEWAY_INTERFACE' => 'CGI/1.1', 'REDIRECT_URL' => '/webroot/professions/chauffagiste-cogeneration-pile-a-combustible-51/p/3', 'REMOTE_PORT' => '57738', 'SCRIPT_FILENAME' => '/home/reseauec/www/webroot/index.php', 'SERVER_ADMIN' => '[no address given]', 'CONTEXT_DOCUMENT_ROOT' => '/home/reseauec/www', 'CONTEXT_PREFIX' => '', 'REQUEST_SCHEME' => 'https', 'DOCUMENT_ROOT' => '/home/reseauec/www', 'REMOTE_ADDR' => '100.26.140.179', 'SERVER_PORT' => '443', 'SERVER_ADDR' => '54.36.38.55', 'SERVER_NAME' => 'reseau-proeco-energies.fr', 'SERVER_SOFTWARE' => 'Apache', 'SERVER_SIGNATURE' => '<address>Apache Server at reseau-proeco-energies.fr Port 443</address> ', 'PATH' => '/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin', 'HTTP_HOST' => 'reseau-proeco-energies.fr', 'HTTP_USER_AGENT' => 'claudebot', 'HTTP_ACCEPT' => '*/*', 'proxy-nokeepalive' => '1', 'SSL_TLS_SNI' => 'reseau-proeco-energies.fr', 'HTTPS' => 'on', 'H2_STREAM_TAG' => '7878-3787-3', 'H2_STREAM_ID' => '3', 'H2_PUSHED_ON' => '', 'H2_PUSHED' => '', 'H2_PUSH' => 'off', 'H2PUSH' => 'off', 'HTTP2' => 'on', 'REDIRECT_STATUS' => '200', 'REDIRECT_SSL_TLS_SNI' => 'reseau-proeco-energies.fr', 'REDIRECT_HTTPS' => 'on', 'REDIRECT_H2_STREAM_TAG' => '7878-3787-3', 'REDIRECT_H2_STREAM_ID' => '3', 'REDIRECT_H2_PUSHED_ON' => '', 'REDIRECT_H2_PUSHED' => '', 'REDIRECT_H2_PUSH' => 'off', 'REDIRECT_H2PUSH' => 'off', 'REDIRECT_HTTP2' => 'on', 'REDIRECT_REDIRECT_STATUS' => '200', 'REDIRECT_REDIRECT_SSL_TLS_SNI' => 'reseau-proeco-energies.fr', 'REDIRECT_REDIRECT_HTTPS' => 'on', 'REDIRECT_REDIRECT_H2_STREAM_TAG' => '7878-3787-3', 'REDIRECT_REDIRECT_H2_STREAM_ID' => '3', 'REDIRECT_REDIRECT_H2_PUSHED_ON' => '', 'REDIRECT_REDIRECT_H2_PUSHED' => '', 'REDIRECT_REDIRECT_H2_PUSH' => 'off', 'REDIRECT_REDIRECT_H2PUSH' => 'off', 'REDIRECT_REDIRECT_HTTP2' => 'on', 'FCGI_ROLE' => 'RESPONDER', 'PHP_SELF' => '/webroot/index.php', 'REQUEST_TIME_FLOAT' => (float) 1711631837.7648, 'REQUEST_TIME' => (int) 1711631837, 'ORIGINAL_REQUEST_METHOD' => 'GET' ] [protected] _input => null [protected] _detectors => [ 'get' => [ 'env' => 'REQUEST_METHOD', 'value' => 'GET' ], 'post' => [ 'env' => 'REQUEST_METHOD', 'value' => 'POST' ], 'put' => [ 'env' => 'REQUEST_METHOD', 'value' => 'PUT' ], 'patch' => [ 'env' => 'REQUEST_METHOD', 'value' => 'PATCH' ], 'delete' => [ 'env' => 'REQUEST_METHOD', 'value' => 'DELETE' ], 'head' => [ 'env' => 'REQUEST_METHOD', 'value' => 'HEAD' ], 'options' => [ 'env' => 'REQUEST_METHOD', 'value' => 'OPTIONS' ], 'ssl' => [ 'env' => 'HTTPS', 'options' => [ [maximum depth reached] ] ], 'ajax' => [ 'env' => 'HTTP_X_REQUESTED_WITH', 'value' => 'XMLHttpRequest' ], 'flash' => [ 'env' => 'HTTP_USER_AGENT', 'pattern' => '/^(Shockwave|Adobe) Flash/' ], 'requested' => [ 'param' => 'requested', 'value' => (int) 1 ], 'json' => [ 'accept' => [ [maximum depth reached] ], 'param' => '_ext', 'value' => 'json' ], 'xml' => [ 'accept' => [ [maximum depth reached] ], 'param' => '_ext', 'value' => 'xml' ], 'mobile' => object(Closure) {}, 'tablet' => object(Closure) {} ] [protected] _detectorCache => [] [protected] stream => object(Zend\Diactoros\PhpInputStream) { [protected] resource => resource [protected] stream => 'php://input' [private] cache => '' [private] reachedEof => false } [protected] uri => object(Zend\Diactoros\Uri) { base => '' webroot => '/' [protected] allowedSchemes => [ [maximum depth reached] ] [private] scheme => 'https' [private] userInfo => '' [private] host => 'reseau-proeco-energies.fr' [private] port => null [private] path => '/professions/chauffagiste-cogeneration-pile-a-combustible-51/p/3' [private] query => '' [private] fragment => '' [private] uriString => null } [protected] session => object(Cake\Network\Session) { [protected] _engine => null [protected] _started => false [protected] _lifetime => '7200' [protected] _isCLI => false } [protected] attributes => [] [protected] emulatedAttributes => [ (int) 0 => 'session', (int) 1 => 'webroot', (int) 2 => 'base', (int) 3 => 'params' ] [protected] uploadedFiles => [] [protected] protocol => null [protected] requestTarget => null } object(Cake\Http\Response) { 'status' => (int) 200, 'contentType' => 'text/html', 'headers' => [ 'Content-Type' => [ (int) 0 => 'text/html; charset=UTF-8' ] ], 'file' => null, 'fileRange' => [], 'cookies' => object(Cake\Http\Cookie\CookieCollection) { [protected] cookies => [[maximum depth reached]] }, 'cacheDirectives' => [], 'body' => '' } object(Cake\Http\Runner) { [protected] index => (int) 4 [protected] middleware => object(Cake\Http\MiddlewareQueue) { [protected] queue => [ [maximum depth reached] ] [protected] callables => [ [maximum depth reached] ] } }
*/ |
|
public function __invoke($request, $response, $next) |
|
{ |
|
try { |
|
return $next($request, $response); |
|
} catch (Throwable $exception) { |
|
return $this->handleException($exception, $request, $response); |
|
} catch (Exception $exception) { |
|
return $this->handleException($exception, $request, $response); |
object(Cake\Http\ServerRequest) { params => [ 'plugin' => null, 'controller' => null, 'action' => null, '_ext' => null, 'pass' => [] ] data => [] query => [] cookies => [] url => 'professions/chauffagiste-cogeneration-pile-a-combustible-51/p/3' base => '' webroot => '/' here => '/professions/chauffagiste-cogeneration-pile-a-combustible-51/p/3' trustProxy => false [protected] _environment => [ 'USER' => 'reseauec', 'HOME' => '/home/reseauec', 'SCRIPT_NAME' => '/webroot/index.php', 'REQUEST_URI' => '/professions/chauffagiste-cogeneration-pile-a-combustible-51/p/3', 'QUERY_STRING' => '', 'REQUEST_METHOD' => 'GET', 'SERVER_PROTOCOL' => 'HTTP/2.0', 'GATEWAY_INTERFACE' => 'CGI/1.1', 'REDIRECT_URL' => '/webroot/professions/chauffagiste-cogeneration-pile-a-combustible-51/p/3', 'REMOTE_PORT' => '57738', 'SCRIPT_FILENAME' => '/home/reseauec/www/webroot/index.php', 'SERVER_ADMIN' => '[no address given]', 'CONTEXT_DOCUMENT_ROOT' => '/home/reseauec/www', 'CONTEXT_PREFIX' => '', 'REQUEST_SCHEME' => 'https', 'DOCUMENT_ROOT' => '/home/reseauec/www', 'REMOTE_ADDR' => '100.26.140.179', 'SERVER_PORT' => '443', 'SERVER_ADDR' => '54.36.38.55', 'SERVER_NAME' => 'reseau-proeco-energies.fr', 'SERVER_SOFTWARE' => 'Apache', 'SERVER_SIGNATURE' => '<address>Apache Server at reseau-proeco-energies.fr Port 443</address> ', 'PATH' => '/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin', 'HTTP_HOST' => 'reseau-proeco-energies.fr', 'HTTP_USER_AGENT' => 'claudebot', 'HTTP_ACCEPT' => '*/*', 'proxy-nokeepalive' => '1', 'SSL_TLS_SNI' => 'reseau-proeco-energies.fr', 'HTTPS' => 'on', 'H2_STREAM_TAG' => '7878-3787-3', 'H2_STREAM_ID' => '3', 'H2_PUSHED_ON' => '', 'H2_PUSHED' => '', 'H2_PUSH' => 'off', 'H2PUSH' => 'off', 'HTTP2' => 'on', 'REDIRECT_STATUS' => '200', 'REDIRECT_SSL_TLS_SNI' => 'reseau-proeco-energies.fr', 'REDIRECT_HTTPS' => 'on', 'REDIRECT_H2_STREAM_TAG' => '7878-3787-3', 'REDIRECT_H2_STREAM_ID' => '3', 'REDIRECT_H2_PUSHED_ON' => '', 'REDIRECT_H2_PUSHED' => '', 'REDIRECT_H2_PUSH' => 'off', 'REDIRECT_H2PUSH' => 'off', 'REDIRECT_HTTP2' => 'on', 'REDIRECT_REDIRECT_STATUS' => '200', 'REDIRECT_REDIRECT_SSL_TLS_SNI' => 'reseau-proeco-energies.fr', 'REDIRECT_REDIRECT_HTTPS' => 'on', 'REDIRECT_REDIRECT_H2_STREAM_TAG' => '7878-3787-3', 'REDIRECT_REDIRECT_H2_STREAM_ID' => '3', 'REDIRECT_REDIRECT_H2_PUSHED_ON' => '', 'REDIRECT_REDIRECT_H2_PUSHED' => '', 'REDIRECT_REDIRECT_H2_PUSH' => 'off', 'REDIRECT_REDIRECT_H2PUSH' => 'off', 'REDIRECT_REDIRECT_HTTP2' => 'on', 'FCGI_ROLE' => 'RESPONDER', 'PHP_SELF' => '/webroot/index.php', 'REQUEST_TIME_FLOAT' => (float) 1711631837.7648, 'REQUEST_TIME' => (int) 1711631837, 'ORIGINAL_REQUEST_METHOD' => 'GET' ] [protected] _input => null [protected] _detectors => [ 'get' => [ 'env' => 'REQUEST_METHOD', 'value' => 'GET' ], 'post' => [ 'env' => 'REQUEST_METHOD', 'value' => 'POST' ], 'put' => [ 'env' => 'REQUEST_METHOD', 'value' => 'PUT' ], 'patch' => [ 'env' => 'REQUEST_METHOD', 'value' => 'PATCH' ], 'delete' => [ 'env' => 'REQUEST_METHOD', 'value' => 'DELETE' ], 'head' => [ 'env' => 'REQUEST_METHOD', 'value' => 'HEAD' ], 'options' => [ 'env' => 'REQUEST_METHOD', 'value' => 'OPTIONS' ], 'ssl' => [ 'env' => 'HTTPS', 'options' => [ [maximum depth reached] ] ], 'ajax' => [ 'env' => 'HTTP_X_REQUESTED_WITH', 'value' => 'XMLHttpRequest' ], 'flash' => [ 'env' => 'HTTP_USER_AGENT', 'pattern' => '/^(Shockwave|Adobe) Flash/' ], 'requested' => [ 'param' => 'requested', 'value' => (int) 1 ], 'json' => [ 'accept' => [ [maximum depth reached] ], 'param' => '_ext', 'value' => 'json' ], 'xml' => [ 'accept' => [ [maximum depth reached] ], 'param' => '_ext', 'value' => 'xml' ], 'mobile' => object(Closure) {}, 'tablet' => object(Closure) {} ] [protected] _detectorCache => [] [protected] stream => object(Zend\Diactoros\PhpInputStream) { [protected] resource => resource [protected] stream => 'php://input' [private] cache => '' [private] reachedEof => false } [protected] uri => object(Zend\Diactoros\Uri) { base => '' webroot => '/' [protected] allowedSchemes => [ [maximum depth reached] ] [private] scheme => 'https' [private] userInfo => '' [private] host => 'reseau-proeco-energies.fr' [private] port => null [private] path => '/professions/chauffagiste-cogeneration-pile-a-combustible-51/p/3' [private] query => '' [private] fragment => '' [private] uriString => null } [protected] session => object(Cake\Network\Session) { [protected] _engine => null [protected] _started => false [protected] _lifetime => '7200' [protected] _isCLI => false } [protected] attributes => [] [protected] emulatedAttributes => [ (int) 0 => 'session', (int) 1 => 'webroot', (int) 2 => 'base', (int) 3 => 'params' ] [protected] uploadedFiles => [] [protected] protocol => null [protected] requestTarget => null } object(Cake\Http\Response) { 'status' => (int) 200, 'contentType' => 'text/html', 'headers' => [ 'Content-Type' => [ (int) 0 => 'text/html; charset=UTF-8' ] ], 'file' => null, 'fileRange' => [], 'cookies' => object(Cake\Http\Cookie\CookieCollection) { [protected] cookies => [[maximum depth reached]] }, 'cacheDirectives' => [], 'body' => '' }
$next = $this->middleware->get($this->index); |
|
if ($next) { |
|
$this->index++; |
|
|
|
return $next($request, $response, $this); |
|
} |
|
|
|
// End of the queue |
|
return $response; |
object(Cake\Http\ServerRequest) { params => [ 'plugin' => null, 'controller' => null, 'action' => null, '_ext' => null, 'pass' => [] ] data => [] query => [] cookies => [] url => 'professions/chauffagiste-cogeneration-pile-a-combustible-51/p/3' base => '' webroot => '/' here => '/professions/chauffagiste-cogeneration-pile-a-combustible-51/p/3' trustProxy => false [protected] _environment => [ 'USER' => 'reseauec', 'HOME' => '/home/reseauec', 'SCRIPT_NAME' => '/webroot/index.php', 'REQUEST_URI' => '/professions/chauffagiste-cogeneration-pile-a-combustible-51/p/3', 'QUERY_STRING' => '', 'REQUEST_METHOD' => 'GET', 'SERVER_PROTOCOL' => 'HTTP/2.0', 'GATEWAY_INTERFACE' => 'CGI/1.1', 'REDIRECT_URL' => '/webroot/professions/chauffagiste-cogeneration-pile-a-combustible-51/p/3', 'REMOTE_PORT' => '57738', 'SCRIPT_FILENAME' => '/home/reseauec/www/webroot/index.php', 'SERVER_ADMIN' => '[no address given]', 'CONTEXT_DOCUMENT_ROOT' => '/home/reseauec/www', 'CONTEXT_PREFIX' => '', 'REQUEST_SCHEME' => 'https', 'DOCUMENT_ROOT' => '/home/reseauec/www', 'REMOTE_ADDR' => '100.26.140.179', 'SERVER_PORT' => '443', 'SERVER_ADDR' => '54.36.38.55', 'SERVER_NAME' => 'reseau-proeco-energies.fr', 'SERVER_SOFTWARE' => 'Apache', 'SERVER_SIGNATURE' => '<address>Apache Server at reseau-proeco-energies.fr Port 443</address> ', 'PATH' => '/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin', 'HTTP_HOST' => 'reseau-proeco-energies.fr', 'HTTP_USER_AGENT' => 'claudebot', 'HTTP_ACCEPT' => '*/*', 'proxy-nokeepalive' => '1', 'SSL_TLS_SNI' => 'reseau-proeco-energies.fr', 'HTTPS' => 'on', 'H2_STREAM_TAG' => '7878-3787-3', 'H2_STREAM_ID' => '3', 'H2_PUSHED_ON' => '', 'H2_PUSHED' => '', 'H2_PUSH' => 'off', 'H2PUSH' => 'off', 'HTTP2' => 'on', 'REDIRECT_STATUS' => '200', 'REDIRECT_SSL_TLS_SNI' => 'reseau-proeco-energies.fr', 'REDIRECT_HTTPS' => 'on', 'REDIRECT_H2_STREAM_TAG' => '7878-3787-3', 'REDIRECT_H2_STREAM_ID' => '3', 'REDIRECT_H2_PUSHED_ON' => '', 'REDIRECT_H2_PUSHED' => '', 'REDIRECT_H2_PUSH' => 'off', 'REDIRECT_H2PUSH' => 'off', 'REDIRECT_HTTP2' => 'on', 'REDIRECT_REDIRECT_STATUS' => '200', 'REDIRECT_REDIRECT_SSL_TLS_SNI' => 'reseau-proeco-energies.fr', 'REDIRECT_REDIRECT_HTTPS' => 'on', 'REDIRECT_REDIRECT_H2_STREAM_TAG' => '7878-3787-3', 'REDIRECT_REDIRECT_H2_STREAM_ID' => '3', 'REDIRECT_REDIRECT_H2_PUSHED_ON' => '', 'REDIRECT_REDIRECT_H2_PUSHED' => '', 'REDIRECT_REDIRECT_H2_PUSH' => 'off', 'REDIRECT_REDIRECT_H2PUSH' => 'off', 'REDIRECT_REDIRECT_HTTP2' => 'on', 'FCGI_ROLE' => 'RESPONDER', 'PHP_SELF' => '/webroot/index.php', 'REQUEST_TIME_FLOAT' => (float) 1711631837.7648, 'REQUEST_TIME' => (int) 1711631837, 'ORIGINAL_REQUEST_METHOD' => 'GET' ] [protected] _input => null [protected] _detectors => [ 'get' => [ 'env' => 'REQUEST_METHOD', 'value' => 'GET' ], 'post' => [ 'env' => 'REQUEST_METHOD', 'value' => 'POST' ], 'put' => [ 'env' => 'REQUEST_METHOD', 'value' => 'PUT' ], 'patch' => [ 'env' => 'REQUEST_METHOD', 'value' => 'PATCH' ], 'delete' => [ 'env' => 'REQUEST_METHOD', 'value' => 'DELETE' ], 'head' => [ 'env' => 'REQUEST_METHOD', 'value' => 'HEAD' ], 'options' => [ 'env' => 'REQUEST_METHOD', 'value' => 'OPTIONS' ], 'ssl' => [ 'env' => 'HTTPS', 'options' => [ [maximum depth reached] ] ], 'ajax' => [ 'env' => 'HTTP_X_REQUESTED_WITH', 'value' => 'XMLHttpRequest' ], 'flash' => [ 'env' => 'HTTP_USER_AGENT', 'pattern' => '/^(Shockwave|Adobe) Flash/' ], 'requested' => [ 'param' => 'requested', 'value' => (int) 1 ], 'json' => [ 'accept' => [ [maximum depth reached] ], 'param' => '_ext', 'value' => 'json' ], 'xml' => [ 'accept' => [ [maximum depth reached] ], 'param' => '_ext', 'value' => 'xml' ], 'mobile' => object(Closure) {}, 'tablet' => object(Closure) {} ] [protected] _detectorCache => [] [protected] stream => object(Zend\Diactoros\PhpInputStream) { [protected] resource => resource [protected] stream => 'php://input' [private] cache => '' [private] reachedEof => false } [protected] uri => object(Zend\Diactoros\Uri) { base => '' webroot => '/' [protected] allowedSchemes => [ [maximum depth reached] ] [private] scheme => 'https' [private] userInfo => '' [private] host => 'reseau-proeco-energies.fr' [private] port => null [private] path => '/professions/chauffagiste-cogeneration-pile-a-combustible-51/p/3' [private] query => '' [private] fragment => '' [private] uriString => null } [protected] session => object(Cake\Network\Session) { [protected] _engine => null [protected] _started => false [protected] _lifetime => '7200' [protected] _isCLI => false } [protected] attributes => [] [protected] emulatedAttributes => [ (int) 0 => 'session', (int) 1 => 'webroot', (int) 2 => 'base', (int) 3 => 'params' ] [protected] uploadedFiles => [] [protected] protocol => null [protected] requestTarget => null } object(Cake\Http\Response) { 'status' => (int) 200, 'contentType' => 'text/html', 'headers' => [ 'Content-Type' => [ (int) 0 => 'text/html; charset=UTF-8' ] ], 'file' => null, 'fileRange' => [], 'cookies' => object(Cake\Http\Cookie\CookieCollection) { [protected] cookies => [[maximum depth reached]] }, 'cacheDirectives' => [], 'body' => '' } object(Cake\Http\Runner) { [protected] index => (int) 4 [protected] middleware => object(Cake\Http\MiddlewareQueue) { [protected] queue => [ [maximum depth reached] ] [protected] callables => [ [maximum depth reached] ] } }
{ |
|
$this->middleware = $middleware; |
|
$this->index = 0; |
|
|
|
return $this->__invoke($request, $response); |
|
} |
|
|
|
/** |
|
* @param \Psr\Http\Message\ServerRequestInterface $request The server request |
object(Cake\Http\ServerRequest) { params => [ 'plugin' => null, 'controller' => null, 'action' => null, '_ext' => null, 'pass' => [] ] data => [] query => [] cookies => [] url => 'professions/chauffagiste-cogeneration-pile-a-combustible-51/p/3' base => '' webroot => '/' here => '/professions/chauffagiste-cogeneration-pile-a-combustible-51/p/3' trustProxy => false [protected] _environment => [ 'USER' => 'reseauec', 'HOME' => '/home/reseauec', 'SCRIPT_NAME' => '/webroot/index.php', 'REQUEST_URI' => '/professions/chauffagiste-cogeneration-pile-a-combustible-51/p/3', 'QUERY_STRING' => '', 'REQUEST_METHOD' => 'GET', 'SERVER_PROTOCOL' => 'HTTP/2.0', 'GATEWAY_INTERFACE' => 'CGI/1.1', 'REDIRECT_URL' => '/webroot/professions/chauffagiste-cogeneration-pile-a-combustible-51/p/3', 'REMOTE_PORT' => '57738', 'SCRIPT_FILENAME' => '/home/reseauec/www/webroot/index.php', 'SERVER_ADMIN' => '[no address given]', 'CONTEXT_DOCUMENT_ROOT' => '/home/reseauec/www', 'CONTEXT_PREFIX' => '', 'REQUEST_SCHEME' => 'https', 'DOCUMENT_ROOT' => '/home/reseauec/www', 'REMOTE_ADDR' => '100.26.140.179', 'SERVER_PORT' => '443', 'SERVER_ADDR' => '54.36.38.55', 'SERVER_NAME' => 'reseau-proeco-energies.fr', 'SERVER_SOFTWARE' => 'Apache', 'SERVER_SIGNATURE' => '<address>Apache Server at reseau-proeco-energies.fr Port 443</address> ', 'PATH' => '/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin', 'HTTP_HOST' => 'reseau-proeco-energies.fr', 'HTTP_USER_AGENT' => 'claudebot', 'HTTP_ACCEPT' => '*/*', 'proxy-nokeepalive' => '1', 'SSL_TLS_SNI' => 'reseau-proeco-energies.fr', 'HTTPS' => 'on', 'H2_STREAM_TAG' => '7878-3787-3', 'H2_STREAM_ID' => '3', 'H2_PUSHED_ON' => '', 'H2_PUSHED' => '', 'H2_PUSH' => 'off', 'H2PUSH' => 'off', 'HTTP2' => 'on', 'REDIRECT_STATUS' => '200', 'REDIRECT_SSL_TLS_SNI' => 'reseau-proeco-energies.fr', 'REDIRECT_HTTPS' => 'on', 'REDIRECT_H2_STREAM_TAG' => '7878-3787-3', 'REDIRECT_H2_STREAM_ID' => '3', 'REDIRECT_H2_PUSHED_ON' => '', 'REDIRECT_H2_PUSHED' => '', 'REDIRECT_H2_PUSH' => 'off', 'REDIRECT_H2PUSH' => 'off', 'REDIRECT_HTTP2' => 'on', 'REDIRECT_REDIRECT_STATUS' => '200', 'REDIRECT_REDIRECT_SSL_TLS_SNI' => 'reseau-proeco-energies.fr', 'REDIRECT_REDIRECT_HTTPS' => 'on', 'REDIRECT_REDIRECT_H2_STREAM_TAG' => '7878-3787-3', 'REDIRECT_REDIRECT_H2_STREAM_ID' => '3', 'REDIRECT_REDIRECT_H2_PUSHED_ON' => '', 'REDIRECT_REDIRECT_H2_PUSHED' => '', 'REDIRECT_REDIRECT_H2_PUSH' => 'off', 'REDIRECT_REDIRECT_H2PUSH' => 'off', 'REDIRECT_REDIRECT_HTTP2' => 'on', 'FCGI_ROLE' => 'RESPONDER', 'PHP_SELF' => '/webroot/index.php', 'REQUEST_TIME_FLOAT' => (float) 1711631837.7648, 'REQUEST_TIME' => (int) 1711631837, 'ORIGINAL_REQUEST_METHOD' => 'GET' ] [protected] _input => null [protected] _detectors => [ 'get' => [ 'env' => 'REQUEST_METHOD', 'value' => 'GET' ], 'post' => [ 'env' => 'REQUEST_METHOD', 'value' => 'POST' ], 'put' => [ 'env' => 'REQUEST_METHOD', 'value' => 'PUT' ], 'patch' => [ 'env' => 'REQUEST_METHOD', 'value' => 'PATCH' ], 'delete' => [ 'env' => 'REQUEST_METHOD', 'value' => 'DELETE' ], 'head' => [ 'env' => 'REQUEST_METHOD', 'value' => 'HEAD' ], 'options' => [ 'env' => 'REQUEST_METHOD', 'value' => 'OPTIONS' ], 'ssl' => [ 'env' => 'HTTPS', 'options' => [ [maximum depth reached] ] ], 'ajax' => [ 'env' => 'HTTP_X_REQUESTED_WITH', 'value' => 'XMLHttpRequest' ], 'flash' => [ 'env' => 'HTTP_USER_AGENT', 'pattern' => '/^(Shockwave|Adobe) Flash/' ], 'requested' => [ 'param' => 'requested', 'value' => (int) 1 ], 'json' => [ 'accept' => [ [maximum depth reached] ], 'param' => '_ext', 'value' => 'json' ], 'xml' => [ 'accept' => [ [maximum depth reached] ], 'param' => '_ext', 'value' => 'xml' ], 'mobile' => object(Closure) {}, 'tablet' => object(Closure) {} ] [protected] _detectorCache => [] [protected] stream => object(Zend\Diactoros\PhpInputStream) { [protected] resource => resource [protected] stream => 'php://input' [private] cache => '' [private] reachedEof => false } [protected] uri => object(Zend\Diactoros\Uri) { base => '' webroot => '/' [protected] allowedSchemes => [ [maximum depth reached] ] [private] scheme => 'https' [private] userInfo => '' [private] host => 'reseau-proeco-energies.fr' [private] port => null [private] path => '/professions/chauffagiste-cogeneration-pile-a-combustible-51/p/3' [private] query => '' [private] fragment => '' [private] uriString => null } [protected] session => object(Cake\Network\Session) { [protected] _engine => null [protected] _started => false [protected] _lifetime => '7200' [protected] _isCLI => false } [protected] attributes => [] [protected] emulatedAttributes => [ (int) 0 => 'session', (int) 1 => 'webroot', (int) 2 => 'base', (int) 3 => 'params' ] [protected] uploadedFiles => [] [protected] protocol => null [protected] requestTarget => null } object(Cake\Http\Response) { 'status' => (int) 200, 'contentType' => 'text/html', 'headers' => [ 'Content-Type' => [ (int) 0 => 'text/html; charset=UTF-8' ] ], 'file' => null, 'fileRange' => [], 'cookies' => object(Cake\Http\Cookie\CookieCollection) { [protected] cookies => [[maximum depth reached]] }, 'cacheDirectives' => [], 'body' => '' }
throw new RuntimeException('The application `middleware` method did not return a middleware queue.'); |
|
} |
|
$this->dispatchEvent('Server.buildMiddleware', ['middleware' => $middleware]); |
|
$middleware->add($this->app); |
|
$response = $this->runner->run($middleware, $request, $response); |
|
|
|
if (!($response instanceof ResponseInterface)) { |
|
throw new RuntimeException(sprintf( |
|
'Application did not create a response. Got "%s" instead.', |
object(Cake\Http\MiddlewareQueue) { [protected] queue => [ (int) 0 => object(Cake\Error\Middleware\ErrorHandlerMiddleware) {}, (int) 1 => object(Cake\Routing\Middleware\AssetMiddleware) {}, (int) 2 => object(Cake\Routing\Middleware\RoutingMiddleware) {}, (int) 3 => object(App\Application) {} ] [protected] callables => [ (int) 0 => object(Cake\Error\Middleware\ErrorHandlerMiddleware) {}, (int) 1 => object(Cake\Routing\Middleware\AssetMiddleware) {}, (int) 2 => object(Cake\Routing\Middleware\RoutingMiddleware) {}, (int) 3 => object(App\Application) {} ] } object(Cake\Http\ServerRequest) { params => [ 'plugin' => null, 'controller' => null, 'action' => null, '_ext' => null, 'pass' => [] ] data => [] query => [] cookies => [] url => 'professions/chauffagiste-cogeneration-pile-a-combustible-51/p/3' base => '' webroot => '/' here => '/professions/chauffagiste-cogeneration-pile-a-combustible-51/p/3' trustProxy => false [protected] _environment => [ 'USER' => 'reseauec', 'HOME' => '/home/reseauec', 'SCRIPT_NAME' => '/webroot/index.php', 'REQUEST_URI' => '/professions/chauffagiste-cogeneration-pile-a-combustible-51/p/3', 'QUERY_STRING' => '', 'REQUEST_METHOD' => 'GET', 'SERVER_PROTOCOL' => 'HTTP/2.0', 'GATEWAY_INTERFACE' => 'CGI/1.1', 'REDIRECT_URL' => '/webroot/professions/chauffagiste-cogeneration-pile-a-combustible-51/p/3', 'REMOTE_PORT' => '57738', 'SCRIPT_FILENAME' => '/home/reseauec/www/webroot/index.php', 'SERVER_ADMIN' => '[no address given]', 'CONTEXT_DOCUMENT_ROOT' => '/home/reseauec/www', 'CONTEXT_PREFIX' => '', 'REQUEST_SCHEME' => 'https', 'DOCUMENT_ROOT' => '/home/reseauec/www', 'REMOTE_ADDR' => '100.26.140.179', 'SERVER_PORT' => '443', 'SERVER_ADDR' => '54.36.38.55', 'SERVER_NAME' => 'reseau-proeco-energies.fr', 'SERVER_SOFTWARE' => 'Apache', 'SERVER_SIGNATURE' => '<address>Apache Server at reseau-proeco-energies.fr Port 443</address> ', 'PATH' => '/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin', 'HTTP_HOST' => 'reseau-proeco-energies.fr', 'HTTP_USER_AGENT' => 'claudebot', 'HTTP_ACCEPT' => '*/*', 'proxy-nokeepalive' => '1', 'SSL_TLS_SNI' => 'reseau-proeco-energies.fr', 'HTTPS' => 'on', 'H2_STREAM_TAG' => '7878-3787-3', 'H2_STREAM_ID' => '3', 'H2_PUSHED_ON' => '', 'H2_PUSHED' => '', 'H2_PUSH' => 'off', 'H2PUSH' => 'off', 'HTTP2' => 'on', 'REDIRECT_STATUS' => '200', 'REDIRECT_SSL_TLS_SNI' => 'reseau-proeco-energies.fr', 'REDIRECT_HTTPS' => 'on', 'REDIRECT_H2_STREAM_TAG' => '7878-3787-3', 'REDIRECT_H2_STREAM_ID' => '3', 'REDIRECT_H2_PUSHED_ON' => '', 'REDIRECT_H2_PUSHED' => '', 'REDIRECT_H2_PUSH' => 'off', 'REDIRECT_H2PUSH' => 'off', 'REDIRECT_HTTP2' => 'on', 'REDIRECT_REDIRECT_STATUS' => '200', 'REDIRECT_REDIRECT_SSL_TLS_SNI' => 'reseau-proeco-energies.fr', 'REDIRECT_REDIRECT_HTTPS' => 'on', 'REDIRECT_REDIRECT_H2_STREAM_TAG' => '7878-3787-3', 'REDIRECT_REDIRECT_H2_STREAM_ID' => '3', 'REDIRECT_REDIRECT_H2_PUSHED_ON' => '', 'REDIRECT_REDIRECT_H2_PUSHED' => '', 'REDIRECT_REDIRECT_H2_PUSH' => 'off', 'REDIRECT_REDIRECT_H2PUSH' => 'off', 'REDIRECT_REDIRECT_HTTP2' => 'on', 'FCGI_ROLE' => 'RESPONDER', 'PHP_SELF' => '/webroot/index.php', 'REQUEST_TIME_FLOAT' => (float) 1711631837.7648, 'REQUEST_TIME' => (int) 1711631837, 'ORIGINAL_REQUEST_METHOD' => 'GET' ] [protected] _input => null [protected] _detectors => [ 'get' => [ 'env' => 'REQUEST_METHOD', 'value' => 'GET' ], 'post' => [ 'env' => 'REQUEST_METHOD', 'value' => 'POST' ], 'put' => [ 'env' => 'REQUEST_METHOD', 'value' => 'PUT' ], 'patch' => [ 'env' => 'REQUEST_METHOD', 'value' => 'PATCH' ], 'delete' => [ 'env' => 'REQUEST_METHOD', 'value' => 'DELETE' ], 'head' => [ 'env' => 'REQUEST_METHOD', 'value' => 'HEAD' ], 'options' => [ 'env' => 'REQUEST_METHOD', 'value' => 'OPTIONS' ], 'ssl' => [ 'env' => 'HTTPS', 'options' => [ [maximum depth reached] ] ], 'ajax' => [ 'env' => 'HTTP_X_REQUESTED_WITH', 'value' => 'XMLHttpRequest' ], 'flash' => [ 'env' => 'HTTP_USER_AGENT', 'pattern' => '/^(Shockwave|Adobe) Flash/' ], 'requested' => [ 'param' => 'requested', 'value' => (int) 1 ], 'json' => [ 'accept' => [ [maximum depth reached] ], 'param' => '_ext', 'value' => 'json' ], 'xml' => [ 'accept' => [ [maximum depth reached] ], 'param' => '_ext', 'value' => 'xml' ], 'mobile' => object(Closure) {}, 'tablet' => object(Closure) {} ] [protected] _detectorCache => [] [protected] stream => object(Zend\Diactoros\PhpInputStream) { [protected] resource => resource [protected] stream => 'php://input' [private] cache => '' [private] reachedEof => false } [protected] uri => object(Zend\Diactoros\Uri) { base => '' webroot => '/' [protected] allowedSchemes => [ [maximum depth reached] ] [private] scheme => 'https' [private] userInfo => '' [private] host => 'reseau-proeco-energies.fr' [private] port => null [private] path => '/professions/chauffagiste-cogeneration-pile-a-combustible-51/p/3' [private] query => '' [private] fragment => '' [private] uriString => null } [protected] session => object(Cake\Network\Session) { [protected] _engine => null [protected] _started => false [protected] _lifetime => '7200' [protected] _isCLI => false } [protected] attributes => [] [protected] emulatedAttributes => [ (int) 0 => 'session', (int) 1 => 'webroot', (int) 2 => 'base', (int) 3 => 'params' ] [protected] uploadedFiles => [] [protected] protocol => null [protected] requestTarget => null } object(Cake\Http\Response) { 'status' => (int) 200, 'contentType' => 'text/html', 'headers' => [ 'Content-Type' => [ (int) 0 => 'text/html; charset=UTF-8' ] ], 'file' => null, 'fileRange' => [], 'cookies' => object(Cake\Http\Cookie\CookieCollection) { [protected] cookies => [[maximum depth reached]] }, 'cacheDirectives' => [], 'body' => '' }
$server = new Server(new Application(dirname(__DIR__) . '/config')); |
|
|
|
// Run the request/response through the application |
|
// and emit the response. |
|
$server->emit($server->run()); |
|
|
No arguments
Some of the Table objects in your application were created by instantiating "Cake\ORM\Table" instead of any other specific subclass.
This could be the cause for this exception. Auto-Tables are created for you under the following circumstances:
Please try correcting the issue for the following table aliases:
If you want to customize this error message, create src/Template/Error/error400.ctp