Notice (8): unserialize(): Error at offset 24561 of 24565 bytes [CORE/Cake/Cache/Engine/FileEngine.php, line 194]Code Context$data = str_replace('\\\\\\\\', '\\', $data);}$data = unserialize((string)$data);$key = 'myapp_cake_core_method_cache' $time = (int) 1762302998 $cachetime = (int) 1762303007 $data = 'a:3:{i:0;b:0;s:4:"name";a:301:{s:32:"c90ae449a68f32be8118d349874ba385";s:14:"`lepetitbz331`";s:32:"6ffdd24df8128bd2dee144f2bc4c26ba";s:18:"`Departement`.`id`";s:32:"92b4c6c2973b147cd7bcaa9c8a75f316";s:18:"`Departement__lib`";s:32:"7ec0ac3433bbef218f0ee2815213e9e3";s:4:"" ("";s:32:"a0361a9cbe98c2ea2ccd8b7ee8842382";s:3:"")"";s:32:"bced73ca92db4ae12dc958018ccb4c26";s:14:"`departements`";s:32:"c184ef7a5ca82d94a917d9a5c4ba23ed";s:13:"`Departement`";s:32:"29126a3a52be88127591ae5c23ca88cf";s:6:"`code`";s:32:"a3bda72c8358843bdc43fbcd52c8f5b5";s:24:"`Ville`.`departement_id`";s:32:"11d2680b8852e8a1913406ed1a52ac08";s:8:"`villes`";s:32:"abfe790023ff0d1611edcb6dfce6802d";s:14:"`Moyennevente`";s:32:"c1955c45da499f15d5021c8c72d79c2f";s:26:"`Moyennevente`.`codeinsee`";s:32:"63a2ac815a36fbcbf376027705467c8a";s:22:"`Ville`.`code_commune`";s:32:"3c8d21fc2164772cb7201fe48deb9396";s:15:"`moyenneventes`";s:32:"4074550b4bbee6a4267a989b94eb3c28";s:9:"`Service`";s:32:"2820d7e3c0cdadb2d655400d922db24a";s:18:"`Service`.`CODGEO`";s:32:"c359b7626061b1039ae6a3000e4cfe3c";s:10:"`services`";s:32:"b2c7c45f9ab47735e87c3b000b4368af";s:14:"`Ville`.`slug`";s:32:"7067d7040923af6cd41822817d0bf4ab";s:15:""rochefoucauld"";s:32:"155d4ed88991347fe7ea82b4e0b41352";s:7:"`Ville`";s:32:"f6f73245755f80817e02585396487347";s:12:"`Ville`.`id`";s:32:"b3a132b3002f0a095c207367d2386438";s:13:"`Ville`.`dep`";s:32:"c5697e1e5c979d7ac16a2058fe255e21";s:13:"`Ville`.`nom`";s:32:"f340c52a13f3cf8684f61cdbc6725f3f";s:13:"`Ville`.`lat`";s:32:"b4707c5ae31d038ddd76310d59aceb1c";s:13:"`Ville`.`lng`";s:32:"8af9a7412209202b2e0e984c3f255d07";s:10:"`distance`";s:32:"c1f9b57df40a583acfdf261e4793fe99";s:20:"`Ville`.`population`";s:32:"f721416f99749f3df35aa11d34cb1cf3";s:12:"`population`";s:32:"3857f2e1b78a705845c11758b879ec11";s:11:"`Epublic`.*";s:32:"6504b0970e350614eba7cc0cf66aae51";s:10:"`epublics`";s:32:"311ac503c2c83d277449d5c03a0ee2e8";s:23:"`Epublic`.`identifiant`";s:32:"95ccb19139b56742a7732f163bad069e";s:10:""%mairie%"";s:32:"47b08794347dfb2384d73f46d8cdcb32";s:21:"`Epublic`.`codeinsee`";s:32:"07e806f43f3d5fdd36c5874b29c971f5";s:7:""16281"";s:32:"8c0b662da940de7037c2bab929dcef1d";s:9:"`Epublic`";s:32:"9a3600fb95e8205f33e11d93f770cfb9";s:16:"`etablissements`";s:32:"1be622d935eb0dd0c7e58a62e227a657";s:20:"`Etablissement`.`id`";s:32:"f3d82e8ee5e91d5866793a4ca4ed0c93";s:23:"`Etablissement`.`siren`";s:32:"0efb4e97ead0410107e96ae6cb489c14";s:20:"`Etablissement`.`rs`";s:32:"8bcebc6efad54c5593f8cc8592d732c7";s:22:"`Etablissement`.`slug`";s:32:"2838dc68d05ac3364132f45f55975893";s:21:"`Etablissement`.`img`";s:32:"d61d90b9849537e0cf77726d4d1bed4c";s:21:"`Etablissement`.`pdf`";s:32:"75c6571d87fb87d853fdf142c6f4ee34";s:21:"`Etablissement`.`lng`";s:32:"b0a9c0163be136679cb7aaaf68eb67fa";s:21:"`Etablissement`.`lat`";s:32:"8b905edc230cf3ba9566668da045397d";s:22:"`Etablissement`.`desc`";s:32:"17ce0a1b745586b5481bd2659670ce01";s:28:"`Etablissement`.`historique`";s:32:"190556c243fea80e29a79f8d71231cc8";s:26:"`Etablissement`.`chambres`";s:32:"266364fcf4472684468e83b306fd4686";s:30:"`Etablissement`.`restauration`";s:32:"8be5e44c45f7287eb279be0f26743cdb";s:27:"`Etablissement`.`situation`";s:32:"e96a683a32c44452e7a0e3821f19e6d5";s:25:"`Etablissement`.`parking`";s:32:"ef4980c19106906ba4e419b623dbcc5d";s:30:"`Etablissement`.`animauxadmis`";s:32:"05c511133282e79f3cb2aada631c4bb1";s:29:"`Etablissement`.`equipements`";s:32:"1e1f64fe2b6c940a130904c95995b7da";s:25:"`Etablissement`.`langues`";s:32:"14162a432865948bdf4a852e0faeb95f";s:24:"`Etablissement`.`tarifs`";s:32:"88508b25214c29f69cc3b07a1f9fe894";s:28:"`Etablissement`.`supplement`";s:32:"06242cdb74ecd096ab7c648ed232b419";s:26:"`Etablissement`.`capacite`";s:32:"9a47b0361d47e3f745fafced9219786f";s:26:"`Etablissement`.`categ_id`";s:32:"a10db395b9efb7ad27b39a3859a5c1ec";s:24:"`Etablissement`.`adress`";s:32:"4eef95bfa78d9bd42003f1b7709f21f1";s:25:"`Etablissement`.`adress2`";s:32:"8e8f9fbf2febbf9da306a06db31eaf5c";s:26:"`Etablissement`.`cp_ville`";s:32:"7c21cde53b6fbdec5f13e813f2420207";s:20:"`Etablissement`.`cp`";s:32:"5dca682eb27a5c39e2c4bb44c376205c";s:26:"`Etablissement`.`ville_id`";s:32:"84794120bcf00d57d5c95509c6dd6ba9";s:21:"`Etablissement`.`tel`";s:32:"40fa51bb8cb7c4a9c2b097c28ac7dc80";s:27:"`Etablissement`.`telecopie`";s:32:"a308ab77d34b589977fbb1facf28056c";s:23:"`Etablissement`.`email`";s:32:"0d21b27b030a717527b9174797aa4235";s:26:"`Etablissement`.`site_web`";s:32:"5357163bc68467b6ae009dac63462c2b";s:25:"`Etablissement`.`partner`";s:32:"5a971db96511a81c17f5ea0171270e5c";s:27:"`Etablissement`.`full_desc`";s:32:"65ee872b9d308ffcde62806477c81284";s:21:"`Etablissement`.`fin`";s:32:"302e47de74b9bb812f1f70870dab0ddc";s:22:"`Etablissement`.`view`";s:32:"52249bd313f1f7619ae93de0d5d72bee";s:32:"`Etablissement`.`departement_id`";s:32:"1ab99d655aaa071ba2feb461a67aa186";s:28:"`Etablissement`.`agregat_id`";s:32:"d412679177dd4e90e8985bf3c84dee16";s:22:"`Etablissement`.`pets`";s:32:"e05f5b4413dedb2732599617f807556c";s:26:"`Etablissement`.`horaires`";s:32:"8d4ea0d8b5d80a07d6122537a36be68c";s:27:"`Etablissement`.`date_call`";s:32:"51e93a971b8f4be41e95691839c4837d";s:32:"`Etablissement`.`recall_creneau`";s:32:"bc4f8d27d98c9ea99bf6ae1fb62d791c";s:28:"`Etablissement`.`convention`";s:32:"f48c736cd00796c91312e38ca69aa43b";s:33:"`Etablissement`.`convention_text`";s:32:"4a3f0be93fdcc639ed15c3d03151d791";s:33:"`Etablissement`.`convention_date`";s:32:"b28f65eaedd4583e7422316d630fb0b9";s:29:"`Etablissement`.`financement`";s:32:"986ca076e9ffa66abb309a36ca4c14f6";s:34:"`Etablissement`.`financement_text`";s:32:"dd6b8fdd4906dc87d48ff763bcbdbe41";s:34:"`Etablissement`.`financement_date`";s:32:"4f8b1c8519d2fe54dce650d814e94efb";s:27:"`Etablissement`.`direction`";s:32:"85ca6a6983e5f098380837e26f828b01";s:32:"`Etablissement`.`direction_name`";s:32:"977c186d9000ab3cdf33f96f0ccb58e6";s:33:"`Etablissement`.`direction_email`";s:32:"e42057de332eb8fe8e943fa011e138e6";s:32:"`Etablissement`.`direction_move`";s:32:"6b77f9d061073c49dc210d6295535089";s:32:"`Etablissement`.`direction_text`";s:32:"c3327fd912d046d8a589fe7e9dea4756";s:32:"`Etablissement`.`direction_date`";s:32:"77aefda4d62a6524b40989b2d8d15612";s:32:"`Etablissement`.`recall_travaux`";s:32:"24413814ddfd478c355947b937143676";s:32:"`Etablissement`.`recall_maladie`";s:32:"971288ff498287b31eda6792a8e4dd29";s:30:"`Etablissement`.`recall_autre`";s:32:"23c62e5f800aafcedf58fffe048dd68d";s:29:"`Etablissement`.`recall_date`";s:32:"348cae104a01acaf1c087f05c56a58fc";s:29:"`Etablissement`.`observation`";s:32:"7de0eb817f98e54fb4e1545b78d80fe1";s:25:"`Etablissement`.`user_id`";s:32:"808ffbab4bd715dce1b305cf62835111";s:26:"`Etablissement`.`modified`";s:32:"291996f689feffd916e98d0b476e3a52";s:25:"`Etablissement`.`created`";s:32:"c28944d2d6eb600005c2af84c65564ab";s:12:"`Ville`.`cp`";s:32:"dae70075c678611634e66603f2507e87";s:17:"`Ville`.`commune`";s:32:"57bf3bd16d22d1b823018a6025079b24";s:24:"`Ville`.`arrondissement`";s:32:"b052d37be080aa8824cc9854ed3cf459";s:16:"`Ville`.`canton`";s:32:"7f00fac894bcaa6f6957e1656c394953";s:14:"`Ville`.`amdi`";s:32:"43701643bdb6302c47823411692303ff";s:17:"`Ville`.`surface`";s:32:"d566309c0012ca98a5e57a7bedb032f9";s:13:"`Ville`.`ski`";s:32:"55be94b87f050cb7030cf3de79cb27a6";s:17:"`Ville`.`created`";s:32:"e782832d7a2689f8cdf15060a110a972";s:20:"`Ville`.`descriptif`";s:32:"691e753cebf5a915d0de75218e3ea067";s:13:"`Ville`.`img`";s:32:"a6382f688c824218203f0808712ffca6";s:14:"`Agregat`.`id`";s:32:"e478222606bf391f2d59503a883e870f";s:10:"`agregats`";s:32:"5014af7f66e2b32efa7aa3a47124f74b";s:15:"`Agregat`.`lib`";s:32:"6f50392488f24686919a1b4910dc7689";s:16:"`Agregat`.`lib2`";s:32:"ffb7b854b5ab9be92d699d39783561d3";s:19:"`Agregat`.`libRech`";s:32:"0f5491fbe3c71a8d5c826cdb6cf884ec";s:15:"`Agregat`.`img`";s:32:"286f28574d7bea14d39d2894e34cb51a";s:18:"`Agregat`.`imgCat`";s:32:"43a3e95b8a02906d1ec54cfdf661c369";s:23:"`Agregat`.`code_finess`";s:32:"3b461942687bd09977212f947e998a70";s:19:"`Agregat`.`nb_view`";s:32:"ff25dfd114b40931caf9a50acfbc857f";s:16:"`Agregat`.`slug`";s:32:"225eb7b2f28fe983777b8178353a316c";s:16:"`Agregat`.`desc`";s:32:"39bbb01a6b52f4aa883c7280d7fdd615";s:24:"`Agregat`.`ensavoirplus`";s:32:"738ba2bd6d4be2d93d680ba6bbaa48e3";s:19:"`Agregat`.`imglist`";s:32:"56172bdc6f68aa3180cb6797b14ad59d";s:19:"`Agregat`.`created`";s:32:"700b564bc6ce9eca080f8dd142ba3e8f";s:17:"`Agregat`.`class`";s:32:"4526819598ac2d82a6502a37524ffe7c";s:9:"`Agregat`";s:32:"a27ec4135f193498d357b9b4deb6a063";s:15:"`Etablissement`";s:32:"a45f8d4730b0ab680de961f7a9b5ffd8";s:8:""roisel"";s:32:"089d7f47d81be409e8299b5502fc6e7b";s:7:""80677"";s:32:"4980ed713520c53a5ef7bfe59bfe3568";s:14:"`Mur`.`pseudo`";s:32:"5df22fc0ee63f77314a59940fedac466";s:15:"`Mur`.`contenu`";s:32:"78f75bec59f89c734ad73833bc56b727";s:14:"`Mur`.`posted`";s:32:"f0a34e9f16b52b8585fb8852c455febf";s:6:"`murs`";s:32:"025bf5e280fa1a5abe6649e1e4de4e90";s:16:"`Mur`.`ville_id`";s:32:"aeb9c0f91b83d19a86e2de9383c8aea7";s:16:"`Mur`.`validate`";s:32:"9d1b58c9bf83bd6b146c7059e2971034";s:5:"`Mur`";s:32:"d2c23d1b4feeec456d72cdc94cc44595";s:4:"`id`";s:32:"359ac070c703c6225869362821552643";s:11:"`Annonce`.*";s:32:"40afeb1c40614860e01d0748c5f553df";s:10:"`annonces`";s:32:"8027d37245b611a3fbdf14a1e89d8f29";s:20:"`Annonce`.`ville_id`";s:32:"404f56ef6af3757e2e643f86960284d3";s:18:"`Annonce`.`statut`";s:32:"f95ddc2be023960209cb5ce5f087ddbd";s:9:"`Annonce`";s:32:"f88e9b15e207fb3bb2e40b5a9f453aea";s:11:""illartein"";s:32:"25260e8a7750dbf8f8d7a717a0c89887";s:7:""09141"";s:32:"8448d64402d7336bbbca3409861563d5";s:22:""aboncourt-gesincourt"";s:32:"38c1762cb3b9bf273a5b66ccc4f8ca2a";s:7:""70002"";s:32:"3c174c46f9ab1ce16b2dc5e6e0780786";s:27:""maizieres-grande-paroisse"";s:32:"451aac1517187e1ae6c58ef849f91545";s:7:""10220"";s:32:"0a0b9f7a7a0babce70c51db89124f349";s:20:""nanteuil-sur-marne"";s:32:"d0b478d967301c6551076163d3dafd0a";s:7:""77331"";s:32:"167c7843203b1b0c631db30277a71932";s:13:""montagne-33"";s:32:"d10200fcae568d6344dec4ad35fb1532";s:7:""33290"";s:32:"9e6c95695da823f36acf24b866a462ef";s:27:""st-affrique-les-montagnes"";s:32:"20f787f0766feebbce21664bed81ab9f";s:7:""81235"";s:32:"b64902b7c12e990378b4fceec7646049";s:11:""monastere"";s:32:"ffea09636b9269f06e98c570546b71af";s:7:""12146"";s:32:"c4552ee9a01d805791a441b7764f7908";s:21:""velizy-villacoublay"";s:32:"625835575fd00514b00cafe894b0a129";s:7:""78640"";s:32:"5676c5d3790405cac03e743f6432a309";s:16:""marchais-beton"";s:32:"e56396c393c77377ad52938db423e57e";s:7:""89243"";s:32:"34edccced3fabb96b8cb6ad4a03c53eb";s:11:""meurcourt"";s:32:"bd8b3d72ee9ccd0843ad884499eeb7a4";s:7:""70344"";s:32:"073b96c8630bf4c6ed2dca04372f9714";s:25:""gonneville-sur-honfleur"";s:32:"1ea53b58d031375f7aedd0eaa097e093";s:7:""14304"";s:32:"ba8b3dcdf607cc578fb8bffc4d465b79";s:11:""chirac-16"";s:32:"5ede86c8535a61c02375c2229ee50fc8";s:7:""16100"";s:32:"253c3e5ec7787f31b15279029c17e47a";s:17:""saacy-sur-marne"";s:32:"95d84c3e1a9496d3486081ad6a416954";s:7:""77397"";s:32:"caceca3ad2e19fd73a998110c3d60a26";s:15:""saane-st-just"";s:32:"c0ced8e9b7b7fef52aacda2a4d3b9f50";s:7:""76549"";s:32:"ce13e6f8bc0dc967f973d1590dcb3f5a";s:9:""brie-16"";s:32:"6602a4a00f35bbe80b643ae5ede4a552";s:7:""16061"";s:32:"175c542a3674c7fa52531398e6af8e4f";s:11:""servignat"";s:32:"b49d8f2fb35349c922225b63f166f944";s:7:""01406"";s:32:"5e7a0713b56fe82a0f87b401e2e3801f";s:12:""boisset-43"";s:32:"e679494e2b5bee1bd5ecd89aea151d47";s:7:""43034"";s:32:"902265b6b47b623fd7e1740cc2c2fb31";s:20:""huisseau-en-beauce"";s:32:"d4cff4072da2a9f9a85e65ec9dc4babd";s:7:""41103"";s:32:"1ef448e51da2d0cf0b8f5c2187e053c7";s:17:""esplas-de-serou"";s:32:"b7c5d67b2cc68afb85e714c0ac0395d6";s:7:""09118"";s:32:"b3b6c405e1991f371e9b192bf9b47798";s:12:""bollezeele"";s:32:"80be4076cb5078073fd06de506cbacdc";s:8:"`Info`.*";s:32:"65c814b1b540f6da677533b16200a366";s:9:"`Sujet`.*";s:32:"6e09c806ee1568f15d870232c9ad7192";s:7:"`Sujet`";s:32:"9cc9932f961dd20be2485b6e784c67c9";s:9:"`Ville`.*";s:32:"0d0d440f3c7e653c8e2c7441c2a0d952";s:7:"`infos`";s:32:"3173fb2701c28779fb55d9fccb0214d0";s:17:"`Info`.`ville_id`";s:32:"3f291f5951c2401d928d43a105167167";s:17:"`Sujet`.`info_id`";s:32:"47595faa5061b239a137aa95ab2d051e";s:11:"`Info`.`id`";s:32:"b790d6f73c2cec29a0d7d28fa5e12bce";s:8:"`sujets`";s:32:"e8e3ca76fb86257b3cc96203366fa277";s:6:"`Info`";s:32:"09dd8fecc401560e8d221105a5a4dca7";s:12:"`Sujet`.`id`";s:32:"37facbb8c0a0941bf11d357172a0d410";s:12:""st-gourson"";s:32:"99763f32172b28f0dd8353587d8c5061";s:7:""16325"";s:32:"ce76b6bcf10f64689c1e6017a17ccfd9";s:11:""saussenac"";s:32:"d58a14eb6d93103f1674d8cff0c5ae33";s:7:""81277"";s:32:"c65d381171c22bedf85312068cf29618";s:21:""ville-sous-la-ferte"";s:32:"2bc10d6ea86657adee5fea766012c191";s:7:""10426"";s:32:"ae9092a4213249cbcb4f19c2926f6c80";s:14:""ferrieres-65"";s:32:"457c87b8c576413655b0cba4838529a8";s:7:""65176"";s:32:"392eb3418c467b254493c8a6185e15e7";s:9:""assions"";s:32:"6f47958d9f8e79043a2f51f4b7280068";s:7:""07017"";s:32:"3cbca6cac4e2c316d0c70c535b1d3eba";s:12:""chelles-60"";s:32:"298adde4a5816d31e1c8428d8ac9277d";s:7:""60145"";s:32:"0ad7d6baea7dcc535cb779f904b9fdbf";s:7:""bouex"";s:32:"f191cd8f60e09198183e352d8f63c45e";s:7:""16055"";s:32:"83f32337c3de8b3e7d82dbb7b0ef1ed8";s:21:""mallefougasse-auges"";s:32:"dcd112d06b8fb9dc8a0cad41daa4c137";s:7:""04109"";s:32:"2a2cada2c21cd537581924398ed32b14";s:11:""vienville"";s:32:"8b6a05ec49fa93b08a069fd8d21a2003";s:7:""88505"";s:32:"781a5841a48b3e2d7419970f1d24e312";s:14:""montdurausse"";s:32:"1c4630e4ff522f1ea8b516f75812c04d";s:7:""81175"";s:32:"939ce7c286639440568f446d69d2147e";s:13:""eymouthiers"";s:32:"a6bf0408ff374a8379013b1cbcb69a19";s:7:""16135"";s:32:"2aae6268de84dacc4a33ec7d994bae23";s:16:""mery-sur-marne"";s:32:"05cae87200a8fe184593e0c2d510e6df";s:7:""77290"";s:32:"e756f87b95b32a3542afb9f9857add70";s:19:""souance-au-perche"";s:32:"59d16d4eefc2ad8e4241996953940d4e";s:7:""28378"";s:32:"1d97a9fd1d9a2bc62b2872eb1250fe79";s:23:""maisoncelles-du-maine"";s:32:"209fd0aa319032ae13a04b97c618c286";s:7:""53143"";s:32:"a2f503c8f9bde775e4b1bbf22e7478e2";s:12:""blanzac-43"";s:32:"5327c17c0c2b7edb652117109f598d66";s:7:""43030"";s:32:"602233585362e5e23b07e1405cc297c2";s:11:""darbonnay"";s:32:"0dac5fa3061c8a6b03794b8b7f59702d";s:7:""39191"";s:32:"ca22e5ee70aade95087a94a5ca38b580";s:7:""burey"";s:32:"62ac74ec5e6c879d64139991ecd08784";s:7:""27120"";s:32:"955bab67853cb130bdef674e27365600";s:13:""sancheville"";s:32:"4e5e271df5cba15e036a22acd7c2cd63";s:7:""28364"";s:32:"663ac784a62afcb2eb7c61051a9973a3";s:22:""st-eustache-la-foret"";s:32:"5da5c0d5256bfc23dae96c4f7fd8bbee";s:13:""cellefrouin"";s:32:"a4a8257bffec9c1ffae09b181d6bd6fe";s:7:""16068"";s:32:"fe738fad9787c43801b5c968c6eab2b3";s:14:""equemauville"";s:32:"cc433c888b22695e4a4c11167dd41166";s:7:""14243"";s:32:"a78c87f491b60a123965c88088fb62ab";s:9:""haulies"";s:32:"27292b32db7361a232c11774a443079b";s:7:""32153"";s:32:"c486393d4dc8dda68069e7f929002296";s:9:""betbeze"";s:32:"56e64a7bfddf69ef83dde3d2a2ef82c4";s:7:""65088"";s:32:"4dbd37279dd8c5eba6c2a99be3afe4d0";s:8:""rauzan"";s:32:"fb02cb8f188a711f30726530478c95e2";s:15:""st-perdoux-24"";s:32:"89dd153ad31c4ad78d940fdd8ce9497e";s:7:""24483"";s:32:"9f311ca927870d50d03847e338288597";s:10:""nolleval"";s:32:"0e3a42ac35c9763e7c19e3da94d78fa5";s:7:""76469"";s:32:"6e806e6cbac9830c0adba33d2bf737ce";s:17:""st-martin-petit"";s:32:"eb6a4cdb1c8d0279b68e88d2fe83e5cd";s:7:""47257"";s:32:"45462020fd66124eca6f877dc8685aef";s:10:""langouet"";s:32:"fb19b4bdac7e542b3bce92e048117cc0";s:7:""35146"";s:32:"8fc083c6077f90370f41d04781b99d5c";s:12:""mareuil-16"";s:32:"611f1a63434646b5f87272b19963a203";s:7:""16208"";s:32:"548aba37b1605ba4b3af034a8345d2b1";s:13:""morangis-51"";s:32:"13919b05c5ce80616ef6234e8248324d";s:7:""51384"";s:32:"ace73ec7e9f47adeb6568a751b72d493";s:17:""ceaux-d-allegre"";s:32:"23e74d2b8984def1f46df8488e264d3f";s:7:""43043"";s:32:"0ea420ae59dc6eef5e81697140bf96b2";s:7:""soual"";s:32:"f71ff09a2350442a0072aa1c0eaa7d99";s:7:""81289"";s:32:"9778610779ca9178879e844ddc37cc89";s:9:""serenac"";s:32:"21a721b4117ee772fdaf528e1af51bda";s:7:""81285"";s:32:"4bcce41cf80c6559dbefbcfc7b514af4";s:10:""ambernac"";s:32:"900e09c1f44ce329c3597b67b3faca44";s:7:""16009"";s:32:"56c6c9c16afac1af523e19f5e1b9349b";s:17:""lamotte-beuvron"";s:32:"af6d18a646e75c3430f4e2c8dc5c45cd";s:7:""41106"";s:32:"0b9250e8fe54ba2b1a847b21fca8bee1";s:7:""nevez"";s:32:"bbb5fab14b9260f3d685d494d51241a2";s:7:""29153"";s:32:"a7dd239474077786087b83ff3b777c42";s:24:""st-georges-le-flechard"";s:32:"07f54623dc45dde33fae5887f14f60fa";s:21:""st-martin-de-sallen"";s:32:"005d6c4f8492f536741813cf4e1e2fe0";s:7:""14628"";s:32:"c85f7e285c8c7a3500417b1d1279738f";s:17:""lesignac-durand"";s:32:"23d4298eab6641222c1fb9786b314a04";s:7:""16183"";s:32:"6853e10d3b317a32475b2a0de14237ff";s:15:""st-clement-15"";s:32:"25c537697ce83bf09bb325c9a517c722";s:7:""15180"";s:32:"154be582a928b21c919b760c49840f1e";s:19:""chatillon-coligny"";s:32:"5145bc97efe3b2a8561098f6a84ed933";s:7:""45085"";s:32:"a3dd1456af74a55ef94d23f10ca90e61";s:22:""planches-pres-arbois"";s:32:"2e739d53e97f9b2056c4062866cf13d0";s:7:""39425"";s:32:"399b96325d4bdf89ed72d3a146cb7375";s:8:""recurt"";s:32:"1f850a4be7058d366b9ba1dd0c8c3949";s:7:""65376"";s:32:"c0a1f3e891e4c4710fe8a29987215029";s:22:""st-jean-pierre-fixte"";s:32:"524499fdc33818f5ea05ae3e0fa78369";s:7:""28342"";s:32:"8918114176b71925a73e73c8c2c2e0b8";s:8:""pouzin"";s:32:"1cd00f5d512ac737a022df7589dfadab";s:7:""07181"";s:32:"ab631a12c4969f2ecf46f1716be57489";s:19:""chaumont-en-vexin"";s:32:"025c649753346642d66bb9348af46981";s:7:""60143"";s:32:"27e0df56cc53a0b7e63d312d2154c0c6";s:23:""hardivillers-en-vexin"";s:32:"502542f5ef86aa7e7b7aedd6b956ea42";s:7:""60300"";s:32:"733280f4eee1e5f44823f3efbb675664";s:21:""chapelle-st-sulpice"";s:32:"0ba3efd99fbe6b942765e3f008cc159b";s:7:""77090"";s:32:"71129227e4817e638ec9fb7db1d25f18";s:10:""clefmont"";s:32:"f4cc5132e9faafe6c78e1d1923742d9d";s:7:""52132"";s:32:"e257836cadf60d3a654cb6a8f13dead6";s:10:""peumerit"";s:32:"138d9e6586422f74b60f7deb596171bc";s:7:""29159"";s:32:"397bd819d5e381278c082322daded8d1";s:18:""st-michel-de-vax"";s:32:"e3720b3bd929a198cc993330c76d260f";s:7:""81265"";s:32:"b5a8cfd0d22bdfc5c732d0cd1ef04c30";s:7:""mancy"";s:32:"9c00b95690bc2ad5e8322ebe11df9314";s:7:""51342"";s:32:"0eb7cefa76730b66ce19df7056492b7c";s:22:""st-laurent-du-verdon"";s:32:"d88abbfb4952a3ca3528ff02fc54f9e9";s:7:""04186"";s:32:"773ffdbfd108fa62e4c3fe02ccaa813b";s:9:""gouezec"";s:32:"098eb25377ce003a9de7922f1ab9b4f3";s:7:""29062"";s:32:"6e9fdd76acaccaf5df0121bc4c58d9d8";s:10:""fosse-41"";s:32:"894c5d6ca1aa425b49f986099d2220cc";s:7:""41091"";s:32:"8e131fa69719980646b682655a38b4cc";s:9:""vantoux"";s:32:"8907cf5465f7a3bfcfff9c0861dbc34c";s:7:""57693"";s:32:"23ffdcee966874eebf54fea762236249";s:20:""labecede-lauragais"";s:32:"79befbd73a494642d329f20287651a96";s:7:""11181"";s:32:"8308436a3fbe5f55ee4942e185342938";s:13:""torchefelon"";s:32:"c04157699d232cdf246b3a1d7fd2989f";s:7:""38508"";}s:6:"fields";a:92:{s:32:"0776bc5a07b6293ad7a608503c8f0fbb";a:2:{i:0;s:18:"`Departement`.`id`";i:1;s:52:"(CONCAT(nom, " (", code,")")) AS `Departement__lib`";}s:32:"6ebd007b29cf065d538dcc3a7c4187b9";a:2:{i:0;s:18:"`Departement`.`id`";i:1;s:37:"(CONCAT(code)) AS `Departement__lib`";}s:32:"d56346cbc1a9c1c07ecb6f77d7298a85";a:2:{i:0;s:87:"Ville.*, Departement.nom, Departement.slug, Departement.code, Service.*, Moyennevente.*";i:1;s:18:"`Departement`.`id`";}s:32:"578f66db51cbbf83b7b592e62ad85cbb";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:200:"(((acos(sin((45.7333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.7333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.383333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"4b250b3dde838d4b4d7c519fcfd8ecb7";a:1:{i:0;s:11:"`Epublic`.*";}s:32:"8ee4e381878886a74715e50c607da897";a:60:{i:0;s:20:"`Etablissement`.`id`";i:1;s:23:"`Etablissement`.`siren`";i:2;s:20:"`Etablissement`.`rs`";i:3;s:22:"`Etablissement`.`slug`";i:4;s:21:"`Etablissement`.`img`";i:5;s:21:"`Etablissement`.`pdf`";i:6;s:21:"`Etablissement`.`lng`";i:7;s:21:"`Etablissement`.`lat`";i:8;s:22:"`Etablissement`.`desc`";i:9;s:28:"`Etablissement`.`historique`";i:10;s:26:"`Etablissement`.`chambres`";i:11;s:30:"`Etablissement`.`restauration`";i:12;s:27:"`Etablissement`.`situation`";i:13;s:25:"`Etablissement`.`parking`";i:14;s:30:"`Etablissement`.`animauxadmis`";i:15;s:29:"`Etablissement`.`equipements`";i:16;s:25:"`Etablissement`.`langues`";i:17;s:24:"`Etablissement`.`tarifs`";i:18;s:28:"`Etablissement`.`supplement`";i:19;s:26:"`Etablissement`.`capacite`";i:20;s:26:"`Etablissement`.`categ_id`";i:21;s:24:"`Etablissement`.`adress`";i:22;s:25:"`Etablissement`.`adress2`";i:23;s:26:"`Etablissement`.`cp_ville`";i:24;s:20:"`Etablissement`.`cp`";i:25;s:26:"`Etablissement`.`ville_id`";i:26;s:21:"`Etablissement`.`tel`";i:27;s:27:"`Etablissement`.`telecopie`";i:28;s:23:"`Etablissement`.`email`";i:29;s:26:"`Etablissement`.`site_web`";i:30;s:25:"`Etablissement`.`partner`";i:31;s:27:"`Etablissement`.`full_desc`";i:32;s:21:"`Etablissement`.`fin`";i:33;s:22:"`Etablissement`.`view`";i:34;s:32:"`Etablissement`.`departement_id`";i:35;s:28:"`Etablissement`.`agregat_id`";i:36;s:22:"`Etablissement`.`pets`";i:37;s:26:"`Etablissement`.`horaires`";i:38;s:27:"`Etablissement`.`date_call`";i:39;s:32:"`Etablissement`.`recall_creneau`";i:40;s:28:"`Etablissement`.`convention`";i:41;s:33:"`Etablissement`.`convention_text`";i:42;s:33:"`Etablissement`.`convention_date`";i:43;s:29:"`Etablissement`.`financement`";i:44;s:34:"`Etablissement`.`financement_text`";i:45;s:34:"`Etablissement`.`financement_date`";i:46;s:27:"`Etablissement`.`direction`";i:47;s:32:"`Etablissement`.`direction_name`";i:48;s:33:"`Etablissement`.`direction_email`";i:49;s:32:"`Etablissement`.`direction_move`";i:50;s:32:"`Etablissement`.`direction_text`";i:51;s:32:"`Etablissement`.`direction_date`";i:52;s:32:"`Etablissement`.`recall_travaux`";i:53;s:32:"`Etablissement`.`recall_maladie`";i:54;s:30:"`Etablissement`.`recall_autre`";i:55;s:29:"`Etablissement`.`recall_date`";i:56;s:29:"`Etablissement`.`observation`";i:57;s:25:"`Etablissement`.`user_id`";i:58;s:26:"`Etablissement`.`modified`";i:59;s:25:"`Etablissement`.`created`";}s:32:"f20b828ab391eb16a16d5e5df54bfec5";a:19:{i:0;s:12:"`Ville`.`id`";i:1;s:13:"`Ville`.`dep`";i:2;s:14:"`Ville`.`slug`";i:3;s:13:"`Ville`.`nom`";i:4;s:12:"`Ville`.`cp`";i:5;s:17:"`Ville`.`commune`";i:6;s:22:"`Ville`.`code_commune`";i:7;s:24:"`Ville`.`arrondissement`";i:8;s:16:"`Ville`.`canton`";i:9;s:14:"`Ville`.`amdi`";i:10;s:20:"`Ville`.`population`";i:11;s:17:"`Ville`.`surface`";i:12;s:13:"`Ville`.`ski`";i:13;s:13:"`Ville`.`lng`";i:14;s:13:"`Ville`.`lat`";i:15;s:24:"`Ville`.`departement_id`";i:16;s:17:"`Ville`.`created`";i:17;s:20:"`Ville`.`descriptif`";i:18;s:13:"`Ville`.`img`";}s:32:"5ef5376c23915b319c95a55e27b463e2";a:14:{i:0;s:14:"`Agregat`.`id`";i:1;s:15:"`Agregat`.`lib`";i:2;s:16:"`Agregat`.`lib2`";i:3;s:19:"`Agregat`.`libRech`";i:4;s:15:"`Agregat`.`img`";i:5;s:18:"`Agregat`.`imgCat`";i:6;s:23:"`Agregat`.`code_finess`";i:7;s:19:"`Agregat`.`nb_view`";i:8;s:16:"`Agregat`.`slug`";i:9;s:16:"`Agregat`.`desc`";i:10;s:24:"`Agregat`.`ensavoirplus`";i:11;s:19:"`Agregat`.`imglist`";i:12;s:19:"`Agregat`.`created`";i:13;s:17:"`Agregat`.`class`";}s:32:"bc013b7883512024414e377d97f654f5";a:14:{i:0;s:14:"`Agregat`.`id`";i:1;s:15:"`Agregat`.`lib`";i:2;s:16:"`Agregat`.`lib2`";i:3;s:19:"`Agregat`.`libRech`";i:4;s:15:"`Agregat`.`img`";i:5;s:18:"`Agregat`.`imgCat`";i:6;s:23:"`Agregat`.`code_finess`";i:7;s:19:"`Agregat`.`nb_view`";i:8;s:16:"`Agregat`.`slug`";i:9;s:16:"`Agregat`.`desc`";i:10;s:24:"`Agregat`.`ensavoirplus`";i:11;s:19:"`Agregat`.`imglist`";i:12;s:19:"`Agregat`.`created`";i:13;s:17:"`Agregat`.`class`";}s:32:"624bffe106297b88c87a00f09ab9b5f0";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:191:"(((acos(sin((49.95*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.95*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.1- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"1ac2a7de1032f79c4b8218c21288e0c1";a:3:{i:0;s:54:"Etablissement.id, Etablissement.rs, Etablissement.slug";i:1;s:12:"`Ville`.`id`";i:2;s:14:"`Agregat`.`id`";}s:32:"c4fd98c43562097d790d7e33c74a05f1";a:3:{i:0;s:14:"`Mur`.`pseudo`";i:1;s:15:"`Mur`.`contenu`";i:2;s:14:"`Mur`.`posted`";}s:32:"227110cb1331a56c3995a31fd8c4db7c";a:1:{i:0;s:11:"`Annonce`.*";}s:32:"9709a3f7131d4a0fde726bf6a3112064";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"'unserialize - [internal], line ?? FileEngine::read() - CORE/Cake/Cache/Engine/FileEngine.php, line 194 Cache::read() - CORE/Cake/Cache/Cache.php, line 363 DboSource::cacheMethod() - CORE/Cake/Model/Datasource/DboSource.php, line 828 DboSource::fields() - CORE/Cake/Model/Datasource/DboSource.php, line 2658 DboSource::read() - CORE/Cake/Model/Datasource/DboSource.php, line 1171 Model::_readDataSource() - CORE/Cake/Model/Model.php, line 3053 Model::find() - CORE/Cake/Model/Model.php, line 3025 EtablissementsController::index() - APP/Controller/EtablissementsController.php, line 171 ReflectionMethod::invokeArgs() - [internal], line ?? Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 499 Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193 Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167 [main] - APP/webroot/index.php, line 111
Warning (2): Cannot modify header information - headers already sent by (output started at /home/lepetitbz/dansmaprovince/lib/Cake/Utility/Debugger.php:797) [CORE/Cake/Network/CakeResponse.php, line 458]Code Contextsetcookie($name, $c['value'], $c['expire'], $c['path'],$c['domain'], $c['secure'], $c['httpOnly']$c = array( 'name' => 'CakeCookie[autologin]', 'value' => '', 'expire' => (int) 1762260998, 'path' => '/', 'domain' => '', 'secure' => false, 'httpOnly' => false ) $name = 'CakeCookie[autologin]'setcookie - [internal], line ?? CakeResponse::_setCookies() - CORE/Cake/Network/CakeResponse.php, line 458 CakeResponse::send() - CORE/Cake/Network/CakeResponse.php, line 429 ExceptionRenderer::_outputMessage() - CORE/Cake/Error/ExceptionRenderer.php, line 294 ExceptionRenderer::pdoError() - CORE/Cake/Error/ExceptionRenderer.php, line 281 ExceptionRenderer::render() - CORE/Cake/Error/ExceptionRenderer.php, line 190 ErrorHandler::handleException() - CORE/Cake/Error/ErrorHandler.php, line 127 [main] - [internal], line ??
Error: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'Etablissement.codeinsee' in 'where clause'
SQL Query: SELECT `Etablissement`.*, `Agregat`.*, `Ville`.`nom` FROM `lepetitbz331`.`etablissements` AS `Etablissement` LEFT JOIN `lepetitbz331`.`villes` AS `Ville` ON (`Etablissement`.`codeinsee` = `Ville`.`code_commune`) LEFT JOIN `lepetitbz331`.`categories` AS `Categorie` ON (`Categorie`.`siret` = `Etablissement`.`siret`) LEFT JOIN `lepetitbz331`.`agregats` AS `Agregat` ON (`Agregat`.`id` = `Categorie`.`categorie`) WHERE `Etablissement`.`codeinsee` = "47159"
Notice: If you want to customize this error message, create app/View/Errors/pdo_error.ctp
try {$query = $this->_connection->prepare($sql, $prepareOptions);$query->setFetchMode(PDO::FETCH_LAZY);if (!$query->execute($params)) {$this->_result = $query;
array()
$options += array('log' => $this->fullDebug);$t = microtime(true);$this->_result = $this->_execute($sql, $params);
'SELECT `Etablissement`.*, `Agregat`.*, `Ville`.`nom` FROM `lepetitbz331`.`etablissements` AS `Etablissement` LEFT JOIN `lepetitbz331`.`villes` AS `Ville` ON (`Etablissement`.`codeinsee` = `Ville`.`code_commune`) LEFT JOIN `lepetitbz331`.`categories` AS `Categorie` ON (`Categorie`.`siret` = `Etablissement`.`siret`) LEFT JOIN `lepetitbz331`.`agregats` AS `Agregat` ON (`Agregat`.`id` = `Categorie`.`categorie`) WHERE `Etablissement`.`codeinsee` = "47159"' array()
if ($cache && ($cached = $this->getQueryCache($sql, $params)) !== false) {return $cached;}$result = $this->execute($sql, array(), $params);if ($result) {
'SELECT `Etablissement`.*, `Agregat`.*, `Ville`.`nom` FROM `lepetitbz331`.`etablissements` AS `Etablissement` LEFT JOIN `lepetitbz331`.`villes` AS `Ville` ON (`Etablissement`.`codeinsee` = `Ville`.`code_commune`) LEFT JOIN `lepetitbz331`.`categories` AS `Categorie` ON (`Categorie`.`siret` = `Etablissement`.`siret`) LEFT JOIN `lepetitbz331`.`agregats` AS `Agregat` ON (`Agregat`.`id` = `Categorie`.`categorie`) WHERE `Etablissement`.`codeinsee` = "47159"' array( 'log' => true ) array()
// Build SQL statement with the primary model, plus hasOne and belongsTo associations$query = $this->buildAssociationQuery($Model, $queryData);$resultSet = $this->fetchAll($query, $Model->cacheQueries);unset($query);
'SELECT `Etablissement`.*, `Agregat`.*, `Ville`.`nom` FROM `lepetitbz331`.`etablissements` AS `Etablissement` LEFT JOIN `lepetitbz331`.`villes` AS `Ville` ON (`Etablissement`.`codeinsee` = `Ville`.`code_commune`) LEFT JOIN `lepetitbz331`.`categories` AS `Categorie` ON (`Categorie`.`siret` = `Etablissement`.`siret`) LEFT JOIN `lepetitbz331`.`agregats` AS `Agregat` ON (`Agregat`.`id` = `Categorie`.`categorie`) WHERE `Etablissement`.`codeinsee` = "47159"' array()
* @return array*/protected function _readDataSource($type, $query) {$results = $this->getDataSource()->read($this, $query);$this->resetAssociations();
object(Etablissement) {
actsAs => array(
(int) 0 => 'Containable'
)
belongsTo => array(
'Etablissement' => array(
'className' => 'Etablissement',
'foreignKey' => 'etablissement_id',
'conditions' => '',
'fields' => '',
'order' => '',
'counterCache' => ''
),
'Ville' => array(
'className' => 'Ville',
'foreignKey' => 'ville_id',
'conditions' => '',
'fields' => '',
'order' => '',
'counterCache' => ''
),
'Agregat' => array(
'className' => 'Agregat',
'foreignKey' => 'agregat_id',
'conditions' => '',
'fields' => '',
'order' => '',
'counterCache' => ''
),
'Plaquette' => array(
'className' => 'Plaquette',
'foreignKey' => 'plaquette_id',
'conditions' => '',
'fields' => '',
'order' => '',
'counterCache' => ''
)
)
hasMany => array(
'EtablissementKeyword' => array(
'className' => 'EtablissementKeyword',
'foreignKey' => 'etablissement_id',
'conditions' => '',
'fields' => '',
'order' => '',
'limit' => '',
'offset' => '',
'dependent' => '',
'exclusive' => '',
'finderQuery' => '',
'counterQuery' => ''
),
'Comment' => array(
'className' => 'Comment',
'foreignKey' => 'etablissement_id',
'conditions' => '',
'fields' => '',
'order' => '',
'limit' => '',
'offset' => '',
'dependent' => '',
'exclusive' => '',
'finderQuery' => '',
'counterQuery' => ''
)
)
recursive => (int) -1
useDbConfig => 'default'
useTable => 'etablissements'
id => false
data => array()
schemaName => 'lepetitbz331'
table => 'etablissements'
primaryKey => 'id'
validate => array()
validationErrors => array()
validationDomain => null
tablePrefix => ''
plugin => null
name => 'Etablissement'
alias => 'Etablissement'
tableToModel => array(
'etablissements' => 'Etablissement'
)
cacheQueries => false
hasOne => array()
hasAndBelongsToMany => array()
Behaviors => object(BehaviorCollection) {
modelName => 'Etablissement'
defaultPriority => (int) 10
[protected] _methods => array(
[maximum depth reached]
)
[protected] _mappedMethods => array([maximum depth reached])
[protected] _enabled => array(
[maximum depth reached]
)
[protected] _loaded => array(
[maximum depth reached]
)
}
whitelist => array()
cacheSources => true
findQueryType => 'all'
order => null
virtualFields => array()
__backAssociation => array()
__backInnerAssociation => array()
__backOriginalAssociation => array()
__backContainableAssociation => array()
__safeUpdateMode => false
useConsistentAfterFind => true
findMethods => array(
'all' => true,
'first' => true,
'count' => true,
'neighbors' => true,
'list' => true,
'threaded' => true
)
[protected] _schema => null
[protected] _associationKeys => array(
'belongsTo' => array(
(int) 0 => 'className',
(int) 1 => 'foreignKey',
(int) 2 => 'conditions',
(int) 3 => 'fields',
(int) 4 => 'order',
(int) 5 => 'counterCache'
),
'hasOne' => array(
(int) 0 => 'className',
(int) 1 => 'foreignKey',
(int) 2 => 'conditions',
(int) 3 => 'fields',
(int) 4 => 'order',
(int) 5 => 'dependent'
),
'hasMany' => array(
(int) 0 => 'className',
(int) 1 => 'foreignKey',
(int) 2 => 'conditions',
(int) 3 => 'fields',
(int) 4 => 'order',
(int) 5 => 'limit',
(int) 6 => 'offset',
(int) 7 => 'dependent',
(int) 8 => 'exclusive',
(int) 9 => 'finderQuery',
(int) 10 => 'counterQuery'
),
'hasAndBelongsToMany' => array(
(int) 0 => 'className',
(int) 1 => 'joinTable',
(int) 2 => 'with',
(int) 3 => 'foreignKey',
(int) 4 => 'associationForeignKey',
(int) 5 => 'conditions',
(int) 6 => 'fields',
(int) 7 => 'order',
(int) 8 => 'limit',
(int) 9 => 'offset',
(int) 10 => 'unique',
(int) 11 => 'finderQuery'
)
)
[protected] _associations => array(
(int) 0 => 'belongsTo',
(int) 1 => 'hasOne',
(int) 2 => 'hasMany',
(int) 3 => 'hasAndBelongsToMany'
)
[protected] _insertID => null
[protected] _sourceConfigured => true
[protected] _eventManager => object(CakeEventManager) {
[protected] _generalManager => object(CakeEventManager) {}
[protected] _listeners => array(
[maximum depth reached]
)
[protected] _isGlobal => false
}
[protected] _validator => null
}
array(
'conditions' => ' Etablissement.codeinsee = "47159"',
'fields' => array(
(int) 0 => '`Etablissement`.*',
(int) 1 => '`Agregat`.*',
(int) 2 => '`Ville`.`nom`'
),
'joins' => array(
(int) 0 => array(
'table' => 'villes',
'alias' => 'Ville',
'type' => 'LEFT',
'conditions' => array(
(int) 0 => 'Etablissement.codeinsee = Ville.code_commune'
)
),
(int) 1 => array(
'table' => 'categories',
'alias' => 'Categorie',
'type' => 'LEFT',
'conditions' => array(
(int) 0 => 'Categorie.siret = Etablissement.siret'
)
),
(int) 2 => array(
'table' => 'agregats',
'alias' => 'Agregat',
'type' => 'LEFT',
'conditions' => array(
(int) 0 => 'Agregat.id = Categorie.categorie'
)
)
),
'limit' => null,
'offset' => null,
'order' => array(),
'page' => (int) 1,
'group' => null,
'callbacks' => true,
'having' => null,
'lock' => null
)return null;}return $this->_readDataSource($type, $query);}
'all' array( 'conditions' => ' Etablissement.codeinsee = "47159"', 'fields' => 'Etablissement.*, Agregat.*, Ville.nom', 'joins' => array( (int) 0 => array( 'table' => 'villes', 'alias' => 'Ville', 'type' => 'LEFT', 'conditions' => array( (int) 0 => 'Etablissement.codeinsee = Ville.code_commune' ) ), (int) 1 => array( 'table' => 'categories', 'alias' => 'Categorie', 'type' => 'LEFT', 'conditions' => array( (int) 0 => 'Categorie.siret = Etablissement.siret' ) ), (int) 2 => array( 'table' => 'agregats', 'alias' => 'Agregat', 'type' => 'LEFT', 'conditions' => array( (int) 0 => 'Agregat.id = Categorie.categorie' ) ) ), 'limit' => null, 'offset' => null, 'order' => array(), 'page' => (int) 1, 'group' => null, 'callbacks' => true )
$d['artisans'] = $this->Etablissement->find('all', array('fields' => 'Etablissement.*, Agregat.*, Ville.nom','joins' => $joins2,'conditions'=>' Etablissement.codeinsee = "'.$d['data']['Ville']['code_commune'].'"'));
'all' array( 'conditions' => ' Etablissement.codeinsee = "47159"', 'fields' => 'Etablissement.*, Agregat.*, Ville.nom', 'joins' => array( (int) 0 => array( 'table' => 'villes', 'alias' => 'Ville', 'type' => 'LEFT', 'conditions' => array( (int) 0 => 'Etablissement.codeinsee = Ville.code_commune' ) ), (int) 1 => array( 'table' => 'categories', 'alias' => 'Categorie', 'type' => 'LEFT', 'conditions' => array( (int) 0 => 'Categorie.siret = Etablissement.siret' ) ), (int) 2 => array( 'table' => 'agregats', 'alias' => 'Agregat', 'type' => 'LEFT', 'conditions' => array( (int) 0 => 'Agregat.id = Categorie.categorie' ) ) ), 'limit' => null, 'offset' => null, 'order' => array(), 'page' => (int) 1, 'group' => null, 'callbacks' => true )
'mas-d-agenais'
'action' => $request->params['action']));}return $method->invokeArgs($this, $request->params['pass']);
object(EtablissementsController) {
helpers => array(
(int) 0 => 'Text',
(int) 1 => 'Js',
'Form' => array(
'className' => 'FormExt'
),
(int) 2 => 'Html',
(int) 3 => 'Date',
(int) 4 => 'Session'
)
components => array(
(int) 0 => 'AutoLogin',
'Auth' => array(
'loginAction' => array(
[maximum depth reached]
),
'loginRedirect' => array(
[maximum depth reached]
),
'logoutRedirect' => array(
[maximum depth reached]
),
'authorize' => array(
[maximum depth reached]
),
'authError' => 'You are not authorized to view this page.'
),
(int) 1 => 'RequestHandler',
(int) 2 => 'Session',
(int) 3 => 'Img',
(int) 4 => 'Paginator'
)
name => 'Etablissements'
uses => array(
(int) 0 => 'Etablissement',
(int) 1 => 'Departement',
(int) 2 => 'Ville',
(int) 3 => 'Epublic'
)
request => object(CakeRequest) {
params => array(
[maximum depth reached]
)
data => array([maximum depth reached])
query => array([maximum depth reached])
url => 'pros/mas-d-agenais'
base => ''
webroot => '/'
here => '/pros/mas-d-agenais'
[protected] _detectors => array(
[maximum depth reached]
)
[protected] _input => ''
}
response => object(CakeResponse) {
[protected] _statusCodes => array(
[maximum depth reached]
)
[protected] _mimeTypes => array(
[maximum depth reached]
)
[protected] _protocol => 'HTTP/1.1'
[protected] _status => (int) 200
[protected] _contentType => 'text/html'
[protected] _headers => array([maximum depth reached])
[protected] _body => null
[protected] _file => null
[protected] _fileRange => null
[protected] _charset => 'UTF-8'
[protected] _cacheDirectives => array([maximum depth reached])
[protected] _cookies => array(
[maximum depth reached]
)
}
viewPath => 'Etablissements'
layoutPath => null
viewVars => array(
'username' => null
)
view => 'index'
layout => 'default'
autoRender => true
autoLayout => true
Components => object(ComponentCollection) {
defaultPriority => (int) 10
[protected] _Controller => object(EtablissementsController) {}
[protected] _enabled => array(
[maximum depth reached]
)
[protected] _loaded => array(
[maximum depth reached]
)
}
viewClass => 'View'
View => null
ext => '.ctp'
plugin => null
cacheAction => false
passedArgs => array(
(int) 0 => 'mas-d-agenais'
)
scaffold => false
methods => array(
(int) 0 => 'admin_MAJRGE',
(int) 1 => 'admin_addRGE',
(int) 2 => 'index',
(int) 3 => 'departements',
(int) 4 => 'annuaire',
(int) 5 => 'demande',
(int) 6 => 'view',
(int) 7 => 'partners',
(int) 8 => 'admin_index',
(int) 9 => 'admin_add',
(int) 10 => 'admin_add2',
(int) 11 => 'admin_delete',
(int) 12 => 'admin_plupload',
(int) 13 => 'plupload',
(int) 14 => 'admin_up_catalogue',
(int) 15 => 'admin_demandes',
(int) 16 => 'admin_demande',
(int) 17 => 'admin_del_dmd',
(int) 18 => 'admin_catalogue',
(int) 19 => 'admin_del_catalogue',
(int) 20 => 'admin_export',
(int) 21 => 'admin_set_cat_export',
(int) 22 => 'admin_export_imp',
(int) 23 => 'search',
(int) 24 => 'admin_desc',
(int) 25 => 'admin_update_finess',
(int) 26 => 'admin_finess',
(int) 27 => 'admin_finess_add',
(int) 28 => 'prono',
(int) 29 => 'admin_tpvoie',
(int) 30 => 'admin_fslug',
(int) 31 => 'admin_villeid',
(int) 32 => '_usersUsername',
(int) 34 => 'isAuthorized'
)
modelClass => 'Etablissement'
modelKey => 'etablissement'
validationErrors => null
AutoLogin => object(AutoLoginComponent) {
components => array(
[maximum depth reached]
)
model => 'User'
username => 'username'
password => 'password'
plugin => ''
controller => 'users'
loginAction => 'login'
logoutAction => 'logout'
cookieName => 'autologin'
expires => '+2 weeks'
cookieLocalDomain => false
redirect => true
requirePrompt => true
active => true
settings => array([maximum depth reached])
Cookie => object(CookieComponent) {}
Auth => object(AuthComponent) {}
[protected] _debug => false
[protected] _Collection => object(ComponentCollection) {}
[protected] _componentMap => array(
[maximum depth reached]
)
}
Auth => object(AuthComponent) {
components => array(
[maximum depth reached]
)
authenticate => array(
[maximum depth reached]
)
authorize => array(
[maximum depth reached]
)
ajaxLogin => null
flash => array(
[maximum depth reached]
)
loginAction => array(
[maximum depth reached]
)
loginRedirect => array(
[maximum depth reached]
)
logoutRedirect => array(
[maximum depth reached]
)
authError => 'You are not authorized to view this page.'
unauthorizedRedirect => true
allowedActions => array(
[maximum depth reached]
)
request => object(CakeRequest) {}
response => object(CakeResponse) {}
settings => array(
[maximum depth reached]
)
[protected] _authenticateObjects => array(
[maximum depth reached]
)
[protected] _authorizeObjects => array([maximum depth reached])
[protected] _user => array([maximum depth reached])
[protected] _methods => array(
[maximum depth reached]
)
[protected] _Collection => object(ComponentCollection) {}
[protected] _componentMap => array(
[maximum depth reached]
)
}
RequestHandler => object(RequestHandlerComponent) {
ajaxLayout => 'ajax'
enabled => true
request => object(CakeRequest) {}
response => object(CakeResponse) {}
ext => null
params => array(
[maximum depth reached]
)
settings => array(
[maximum depth reached]
)
components => array([maximum depth reached])
[protected] _renderType => null
[protected] _inputTypeMap => array(
[maximum depth reached]
)
[protected] _viewClassMap => array(
[maximum depth reached]
)
[protected] _Collection => object(ComponentCollection) {}
[protected] _componentMap => array([maximum depth reached])
}
Session => object(SessionComponent) {
settings => array([maximum depth reached])
components => array([maximum depth reached])
[protected] _Collection => object(ComponentCollection) {}
[protected] _componentMap => array([maximum depth reached])
}
Img => object(ImgComponent) {
settings => array([maximum depth reached])
components => array([maximum depth reached])
[protected] _Collection => object(ComponentCollection) {}
[protected] _componentMap => array([maximum depth reached])
}
Paginator => object(PaginatorComponent) {
settings => array(
[maximum depth reached]
)
whitelist => array(
[maximum depth reached]
)
components => array([maximum depth reached])
Controller => object(EtablissementsController) {}
[protected] _Collection => object(ComponentCollection) {}
[protected] _componentMap => array([maximum depth reached])
}
Departement => object(Departement) {
belongTo => array(
[maximum depth reached]
)
hasMany => array(
[maximum depth reached]
)
recursive => (int) -1
actsAs => array(
[maximum depth reached]
)
useDbConfig => 'default'
useTable => 'departements'
id => false
data => array([maximum depth reached])
schemaName => 'lepetitbz331'
table => 'departements'
primaryKey => 'id'
validate => array([maximum depth reached])
validationErrors => array([maximum depth reached])
validationDomain => null
tablePrefix => ''
plugin => null
name => 'Departement'
alias => 'Departement'
tableToModel => array(
[maximum depth reached]
)
cacheQueries => false
belongsTo => array([maximum depth reached])
hasOne => array([maximum depth reached])
hasAndBelongsToMany => array([maximum depth reached])
Behaviors => object(BehaviorCollection) {}
whitelist => array([maximum depth reached])
cacheSources => true
findQueryType => null
order => null
virtualFields => array(
[maximum depth reached]
)
__backAssociation => array([maximum depth reached])
__backInnerAssociation => array([maximum depth reached])
__backOriginalAssociation => array([maximum depth reached])
__backContainableAssociation => array([maximum depth reached])
__safeUpdateMode => false
useConsistentAfterFind => true
findMethods => array(
[maximum depth reached]
)
[protected] _schema => null
[protected] _associationKeys => array(
[maximum depth reached]
)
[protected] _associations => array(
[maximum depth reached]
)
[protected] _insertID => null
[protected] _sourceConfigured => true
[protected] _eventManager => object(CakeEventManager) {}
[protected] _validator => null
}
Ville => object(Ville) {
belongsTo => array(
[maximum depth reached]
)
hasMany => array(
[maximum depth reached]
)
recursive => (int) -1
actsAs => array(
[maximum depth reached]
)
useDbConfig => 'default'
useTable => 'villes'
id => false
data => array([maximum depth reached])
schemaName => 'lepetitbz331'
table => 'villes'
primaryKey => 'id'
validate => array([maximum depth reached])
validationErrors => array([maximum depth reached])
validationDomain => null
tablePrefix => ''
plugin => null
name => 'Ville'
alias => 'Ville'
tableToModel => array(
[maximum depth reached]
)
cacheQueries => false
hasOne => array([maximum depth reached])
hasAndBelongsToMany => array([maximum depth reached])
Behaviors => object(BehaviorCollection) {}
whitelist => array([maximum depth reached])
cacheSources => true
findQueryType => null
order => null
virtualFields => array([maximum depth reached])
__backAssociation => array([maximum depth reached])
__backInnerAssociation => array([maximum depth reached])
__backOriginalAssociation => array([maximum depth reached])
__backContainableAssociation => array([maximum depth reached])
__safeUpdateMode => false
useConsistentAfterFind => true
findMethods => array(
[maximum depth reached]
)
Departement => object(Departement) {}
[protected] _schema => null
[protected] _associationKeys => array(
[maximum depth reached]
)
[protected] _associations => array(
[maximum depth reached]
)
[protected] _insertID => null
[protected] _sourceConfigured => true
[protected] _eventManager => object(CakeEventManager) {}
[protected] _validator => null
}
Epublic => object(Epublic) {
name => 'Epublic'
belongsTo => array(
[maximum depth reached]
)
validate => array(
[maximum depth reached]
)
recursive => (int) -1
actsAs => array(
[maximum depth reached]
)
useDbConfig => 'default'
useTable => 'epublics'
id => false
data => array([maximum depth reached])
schemaName => 'lepetitbz331'
table => 'epublics'
primaryKey => 'id'
validationErrors => array([maximum depth reached])
validationDomain => null
tablePrefix => ''
plugin => null
alias => 'Epublic'
tableToModel => array(
[maximum depth reached]
)
cacheQueries => false
hasOne => array([maximum depth reached])
hasMany => array([maximum depth reached])
hasAndBelongsToMany => array([maximum depth reached])
Behaviors => object(BehaviorCollection) {}
whitelist => array([maximum depth reached])
cacheSources => true
findQueryType => null
order => null
virtualFields => array([maximum depth reached])
__backAssociation => array([maximum depth reached])
__backInnerAssociation => array([maximum depth reached])
__backOriginalAssociation => array([maximum depth reached])
__backContainableAssociation => array([maximum depth reached])
__safeUpdateMode => false
useConsistentAfterFind => true
findMethods => array(
[maximum depth reached]
)
[protected] _schema => null
[protected] _associationKeys => array(
[maximum depth reached]
)
[protected] _associations => array(
[maximum depth reached]
)
[protected] _insertID => null
[protected] _sourceConfigured => true
[protected] _eventManager => object(CakeEventManager) {}
[protected] _validator => null
}
Etablissement => object(Etablissement) {
actsAs => array(
[maximum depth reached]
)
belongsTo => array(
[maximum depth reached]
)
hasMany => array(
[maximum depth reached]
)
recursive => (int) -1
useDbConfig => 'default'
useTable => 'etablissements'
id => false
data => array([maximum depth reached])
schemaName => 'lepetitbz331'
table => 'etablissements'
primaryKey => 'id'
validate => array([maximum depth reached])
validationErrors => array([maximum depth reached])
validationDomain => null
tablePrefix => ''
plugin => null
name => 'Etablissement'
alias => 'Etablissement'
tableToModel => array(
[maximum depth reached]
)
cacheQueries => false
hasOne => array([maximum depth reached])
hasAndBelongsToMany => array([maximum depth reached])
Behaviors => object(BehaviorCollection) {}
whitelist => array([maximum depth reached])
cacheSources => true
findQueryType => 'all'
order => null
virtualFields => array([maximum depth reached])
__backAssociation => array([maximum depth reached])
__backInnerAssociation => array([maximum depth reached])
__backOriginalAssociation => array([maximum depth reached])
__backContainableAssociation => array([maximum depth reached])
__safeUpdateMode => false
useConsistentAfterFind => true
findMethods => array(
[maximum depth reached]
)
[protected] _schema => null
[protected] _associationKeys => array(
[maximum depth reached]
)
[protected] _associations => array(
[maximum depth reached]
)
[protected] _insertID => null
[protected] _sourceConfigured => true
[protected] _eventManager => object(CakeEventManager) {}
[protected] _validator => null
}
[protected] _responseClass => 'CakeResponse'
[protected] _mergeParent => 'AppController'
[protected] _eventManager => object(CakeEventManager) {
[protected] _generalManager => object(CakeEventManager) {}
[protected] _listeners => array(
[maximum depth reached]
)
[protected] _isGlobal => false
}
}
array(
(int) 0 => 'mas-d-agenais'
)$response = $controller->response;$render = true;$result = $controller->invokeAction($request);if ($result instanceof CakeResponse) {
object(CakeRequest) {
params => array(
'plugin' => null,
'controller' => 'etablissements',
'action' => 'index',
'named' => array(),
'pass' => array(
(int) 0 => 'mas-d-agenais'
),
'ville' => 'mas-d-agenais',
'isAjax' => false,
'models' => array(
'Departement' => array(
[maximum depth reached]
),
'Ville' => array(
[maximum depth reached]
),
'Epublic' => array(
[maximum depth reached]
),
'Etablissement' => array(
[maximum depth reached]
)
)
)
data => array()
query => array()
url => 'pros/mas-d-agenais'
base => ''
webroot => '/'
here => '/pros/mas-d-agenais'
[protected] _detectors => array(
'get' => array(
'env' => 'REQUEST_METHOD',
'value' => 'GET'
),
'patch' => array(
'env' => 'REQUEST_METHOD',
'value' => 'PATCH'
),
'post' => array(
'env' => 'REQUEST_METHOD',
'value' => 'POST'
),
'put' => array(
'env' => 'REQUEST_METHOD',
'value' => 'PUT'
),
'delete' => array(
'env' => 'REQUEST_METHOD',
'value' => 'DELETE'
),
'head' => array(
'env' => 'REQUEST_METHOD',
'value' => 'HEAD'
),
'options' => array(
'env' => 'REQUEST_METHOD',
'value' => 'OPTIONS'
),
'ssl' => array(
'env' => 'HTTPS',
'value' => (int) 1
),
'ajax' => array(
'env' => 'HTTP_X_REQUESTED_WITH',
'value' => 'XMLHttpRequest'
),
'flash' => array(
'env' => 'HTTP_USER_AGENT',
'pattern' => '/^(Shockwave|Adobe) Flash/'
),
'mobile' => array(
'env' => 'HTTP_USER_AGENT',
'options' => array(
[maximum depth reached]
)
),
'requested' => array(
'param' => 'requested',
'value' => (int) 1
),
'json' => array(
'accept' => array(
[maximum depth reached]
),
'param' => 'ext',
'value' => 'json'
),
'xml' => array(
'accept' => array(
[maximum depth reached]
),
'param' => 'ext',
'value' => 'xml'
)
)
[protected] _input => ''
}));}$response = $this->_invoke($controller, $request);if (isset($request->params['return'])) {
object(EtablissementsController) {
helpers => array(
(int) 0 => 'Text',
(int) 1 => 'Js',
'Form' => array(
'className' => 'FormExt'
),
(int) 2 => 'Html',
(int) 3 => 'Date',
(int) 4 => 'Session'
)
components => array(
(int) 0 => 'AutoLogin',
'Auth' => array(
'loginAction' => array(
[maximum depth reached]
),
'loginRedirect' => array(
[maximum depth reached]
),
'logoutRedirect' => array(
[maximum depth reached]
),
'authorize' => array(
[maximum depth reached]
),
'authError' => 'You are not authorized to view this page.'
),
(int) 1 => 'RequestHandler',
(int) 2 => 'Session',
(int) 3 => 'Img',
(int) 4 => 'Paginator'
)
name => 'Etablissements'
uses => array(
(int) 0 => 'Etablissement',
(int) 1 => 'Departement',
(int) 2 => 'Ville',
(int) 3 => 'Epublic'
)
request => object(CakeRequest) {
params => array(
[maximum depth reached]
)
data => array([maximum depth reached])
query => array([maximum depth reached])
url => 'pros/mas-d-agenais'
base => ''
webroot => '/'
here => '/pros/mas-d-agenais'
[protected] _detectors => array(
[maximum depth reached]
)
[protected] _input => ''
}
response => object(CakeResponse) {
[protected] _statusCodes => array(
[maximum depth reached]
)
[protected] _mimeTypes => array(
[maximum depth reached]
)
[protected] _protocol => 'HTTP/1.1'
[protected] _status => (int) 200
[protected] _contentType => 'text/html'
[protected] _headers => array([maximum depth reached])
[protected] _body => null
[protected] _file => null
[protected] _fileRange => null
[protected] _charset => 'UTF-8'
[protected] _cacheDirectives => array([maximum depth reached])
[protected] _cookies => array(
[maximum depth reached]
)
}
viewPath => 'Etablissements'
layoutPath => null
viewVars => array(
'username' => null
)
view => 'index'
layout => 'default'
autoRender => true
autoLayout => true
Components => object(ComponentCollection) {
defaultPriority => (int) 10
[protected] _Controller => object(EtablissementsController) {}
[protected] _enabled => array(
[maximum depth reached]
)
[protected] _loaded => array(
[maximum depth reached]
)
}
viewClass => 'View'
View => null
ext => '.ctp'
plugin => null
cacheAction => false
passedArgs => array(
(int) 0 => 'mas-d-agenais'
)
scaffold => false
methods => array(
(int) 0 => 'admin_MAJRGE',
(int) 1 => 'admin_addRGE',
(int) 2 => 'index',
(int) 3 => 'departements',
(int) 4 => 'annuaire',
(int) 5 => 'demande',
(int) 6 => 'view',
(int) 7 => 'partners',
(int) 8 => 'admin_index',
(int) 9 => 'admin_add',
(int) 10 => 'admin_add2',
(int) 11 => 'admin_delete',
(int) 12 => 'admin_plupload',
(int) 13 => 'plupload',
(int) 14 => 'admin_up_catalogue',
(int) 15 => 'admin_demandes',
(int) 16 => 'admin_demande',
(int) 17 => 'admin_del_dmd',
(int) 18 => 'admin_catalogue',
(int) 19 => 'admin_del_catalogue',
(int) 20 => 'admin_export',
(int) 21 => 'admin_set_cat_export',
(int) 22 => 'admin_export_imp',
(int) 23 => 'search',
(int) 24 => 'admin_desc',
(int) 25 => 'admin_update_finess',
(int) 26 => 'admin_finess',
(int) 27 => 'admin_finess_add',
(int) 28 => 'prono',
(int) 29 => 'admin_tpvoie',
(int) 30 => 'admin_fslug',
(int) 31 => 'admin_villeid',
(int) 32 => '_usersUsername',
(int) 34 => 'isAuthorized'
)
modelClass => 'Etablissement'
modelKey => 'etablissement'
validationErrors => null
AutoLogin => object(AutoLoginComponent) {
components => array(
[maximum depth reached]
)
model => 'User'
username => 'username'
password => 'password'
plugin => ''
controller => 'users'
loginAction => 'login'
logoutAction => 'logout'
cookieName => 'autologin'
expires => '+2 weeks'
cookieLocalDomain => false
redirect => true
requirePrompt => true
active => true
settings => array([maximum depth reached])
Cookie => object(CookieComponent) {}
Auth => object(AuthComponent) {}
[protected] _debug => false
[protected] _Collection => object(ComponentCollection) {}
[protected] _componentMap => array(
[maximum depth reached]
)
}
Auth => object(AuthComponent) {
components => array(
[maximum depth reached]
)
authenticate => array(
[maximum depth reached]
)
authorize => array(
[maximum depth reached]
)
ajaxLogin => null
flash => array(
[maximum depth reached]
)
loginAction => array(
[maximum depth reached]
)
loginRedirect => array(
[maximum depth reached]
)
logoutRedirect => array(
[maximum depth reached]
)
authError => 'You are not authorized to view this page.'
unauthorizedRedirect => true
allowedActions => array(
[maximum depth reached]
)
request => object(CakeRequest) {}
response => object(CakeResponse) {}
settings => array(
[maximum depth reached]
)
[protected] _authenticateObjects => array(
[maximum depth reached]
)
[protected] _authorizeObjects => array([maximum depth reached])
[protected] _user => array([maximum depth reached])
[protected] _methods => array(
[maximum depth reached]
)
[protected] _Collection => object(ComponentCollection) {}
[protected] _componentMap => array(
[maximum depth reached]
)
}
RequestHandler => object(RequestHandlerComponent) {
ajaxLayout => 'ajax'
enabled => true
request => object(CakeRequest) {}
response => object(CakeResponse) {}
ext => null
params => array(
[maximum depth reached]
)
settings => array(
[maximum depth reached]
)
components => array([maximum depth reached])
[protected] _renderType => null
[protected] _inputTypeMap => array(
[maximum depth reached]
)
[protected] _viewClassMap => array(
[maximum depth reached]
)
[protected] _Collection => object(ComponentCollection) {}
[protected] _componentMap => array([maximum depth reached])
}
Session => object(SessionComponent) {
settings => array([maximum depth reached])
components => array([maximum depth reached])
[protected] _Collection => object(ComponentCollection) {}
[protected] _componentMap => array([maximum depth reached])
}
Img => object(ImgComponent) {
settings => array([maximum depth reached])
components => array([maximum depth reached])
[protected] _Collection => object(ComponentCollection) {}
[protected] _componentMap => array([maximum depth reached])
}
Paginator => object(PaginatorComponent) {
settings => array(
[maximum depth reached]
)
whitelist => array(
[maximum depth reached]
)
components => array([maximum depth reached])
Controller => object(EtablissementsController) {}
[protected] _Collection => object(ComponentCollection) {}
[protected] _componentMap => array([maximum depth reached])
}
Departement => object(Departement) {
belongTo => array(
[maximum depth reached]
)
hasMany => array(
[maximum depth reached]
)
recursive => (int) -1
actsAs => array(
[maximum depth reached]
)
useDbConfig => 'default'
useTable => 'departements'
id => false
data => array([maximum depth reached])
schemaName => 'lepetitbz331'
table => 'departements'
primaryKey => 'id'
validate => array([maximum depth reached])
validationErrors => array([maximum depth reached])
validationDomain => null
tablePrefix => ''
plugin => null
name => 'Departement'
alias => 'Departement'
tableToModel => array(
[maximum depth reached]
)
cacheQueries => false
belongsTo => array([maximum depth reached])
hasOne => array([maximum depth reached])
hasAndBelongsToMany => array([maximum depth reached])
Behaviors => object(BehaviorCollection) {}
whitelist => array([maximum depth reached])
cacheSources => true
findQueryType => null
order => null
virtualFields => array(
[maximum depth reached]
)
__backAssociation => array([maximum depth reached])
__backInnerAssociation => array([maximum depth reached])
__backOriginalAssociation => array([maximum depth reached])
__backContainableAssociation => array([maximum depth reached])
__safeUpdateMode => false
useConsistentAfterFind => true
findMethods => array(
[maximum depth reached]
)
[protected] _schema => null
[protected] _associationKeys => array(
[maximum depth reached]
)
[protected] _associations => array(
[maximum depth reached]
)
[protected] _insertID => null
[protected] _sourceConfigured => true
[protected] _eventManager => object(CakeEventManager) {}
[protected] _validator => null
}
Ville => object(Ville) {
belongsTo => array(
[maximum depth reached]
)
hasMany => array(
[maximum depth reached]
)
recursive => (int) -1
actsAs => array(
[maximum depth reached]
)
useDbConfig => 'default'
useTable => 'villes'
id => false
data => array([maximum depth reached])
schemaName => 'lepetitbz331'
table => 'villes'
primaryKey => 'id'
validate => array([maximum depth reached])
validationErrors => array([maximum depth reached])
validationDomain => null
tablePrefix => ''
plugin => null
name => 'Ville'
alias => 'Ville'
tableToModel => array(
[maximum depth reached]
)
cacheQueries => false
hasOne => array([maximum depth reached])
hasAndBelongsToMany => array([maximum depth reached])
Behaviors => object(BehaviorCollection) {}
whitelist => array([maximum depth reached])
cacheSources => true
findQueryType => null
order => null
virtualFields => array([maximum depth reached])
__backAssociation => array([maximum depth reached])
__backInnerAssociation => array([maximum depth reached])
__backOriginalAssociation => array([maximum depth reached])
__backContainableAssociation => array([maximum depth reached])
__safeUpdateMode => false
useConsistentAfterFind => true
findMethods => array(
[maximum depth reached]
)
Departement => object(Departement) {}
[protected] _schema => null
[protected] _associationKeys => array(
[maximum depth reached]
)
[protected] _associations => array(
[maximum depth reached]
)
[protected] _insertID => null
[protected] _sourceConfigured => true
[protected] _eventManager => object(CakeEventManager) {}
[protected] _validator => null
}
Epublic => object(Epublic) {
name => 'Epublic'
belongsTo => array(
[maximum depth reached]
)
validate => array(
[maximum depth reached]
)
recursive => (int) -1
actsAs => array(
[maximum depth reached]
)
useDbConfig => 'default'
useTable => 'epublics'
id => false
data => array([maximum depth reached])
schemaName => 'lepetitbz331'
table => 'epublics'
primaryKey => 'id'
validationErrors => array([maximum depth reached])
validationDomain => null
tablePrefix => ''
plugin => null
alias => 'Epublic'
tableToModel => array(
[maximum depth reached]
)
cacheQueries => false
hasOne => array([maximum depth reached])
hasMany => array([maximum depth reached])
hasAndBelongsToMany => array([maximum depth reached])
Behaviors => object(BehaviorCollection) {}
whitelist => array([maximum depth reached])
cacheSources => true
findQueryType => null
order => null
virtualFields => array([maximum depth reached])
__backAssociation => array([maximum depth reached])
__backInnerAssociation => array([maximum depth reached])
__backOriginalAssociation => array([maximum depth reached])
__backContainableAssociation => array([maximum depth reached])
__safeUpdateMode => false
useConsistentAfterFind => true
findMethods => array(
[maximum depth reached]
)
[protected] _schema => null
[protected] _associationKeys => array(
[maximum depth reached]
)
[protected] _associations => array(
[maximum depth reached]
)
[protected] _insertID => null
[protected] _sourceConfigured => true
[protected] _eventManager => object(CakeEventManager) {}
[protected] _validator => null
}
Etablissement => object(Etablissement) {
actsAs => array(
[maximum depth reached]
)
belongsTo => array(
[maximum depth reached]
)
hasMany => array(
[maximum depth reached]
)
recursive => (int) -1
useDbConfig => 'default'
useTable => 'etablissements'
id => false
data => array([maximum depth reached])
schemaName => 'lepetitbz331'
table => 'etablissements'
primaryKey => 'id'
validate => array([maximum depth reached])
validationErrors => array([maximum depth reached])
validationDomain => null
tablePrefix => ''
plugin => null
name => 'Etablissement'
alias => 'Etablissement'
tableToModel => array(
[maximum depth reached]
)
cacheQueries => false
hasOne => array([maximum depth reached])
hasAndBelongsToMany => array([maximum depth reached])
Behaviors => object(BehaviorCollection) {}
whitelist => array([maximum depth reached])
cacheSources => true
findQueryType => 'all'
order => null
virtualFields => array([maximum depth reached])
__backAssociation => array([maximum depth reached])
__backInnerAssociation => array([maximum depth reached])
__backOriginalAssociation => array([maximum depth reached])
__backContainableAssociation => array([maximum depth reached])
__safeUpdateMode => false
useConsistentAfterFind => true
findMethods => array(
[maximum depth reached]
)
[protected] _schema => null
[protected] _associationKeys => array(
[maximum depth reached]
)
[protected] _associations => array(
[maximum depth reached]
)
[protected] _insertID => null
[protected] _sourceConfigured => true
[protected] _eventManager => object(CakeEventManager) {}
[protected] _validator => null
}
[protected] _responseClass => 'CakeResponse'
[protected] _mergeParent => 'AppController'
[protected] _eventManager => object(CakeEventManager) {
[protected] _generalManager => object(CakeEventManager) {}
[protected] _listeners => array(
[maximum depth reached]
)
[protected] _isGlobal => false
}
}
object(CakeRequest) {
params => array(
'plugin' => null,
'controller' => 'etablissements',
'action' => 'index',
'named' => array(),
'pass' => array(
(int) 0 => 'mas-d-agenais'
),
'ville' => 'mas-d-agenais',
'isAjax' => false,
'models' => array(
'Departement' => array(
[maximum depth reached]
),
'Ville' => array(
[maximum depth reached]
),
'Epublic' => array(
[maximum depth reached]
),
'Etablissement' => array(
[maximum depth reached]
)
)
)
data => array()
query => array()
url => 'pros/mas-d-agenais'
base => ''
webroot => '/'
here => '/pros/mas-d-agenais'
[protected] _detectors => array(
'get' => array(
'env' => 'REQUEST_METHOD',
'value' => 'GET'
),
'patch' => array(
'env' => 'REQUEST_METHOD',
'value' => 'PATCH'
),
'post' => array(
'env' => 'REQUEST_METHOD',
'value' => 'POST'
),
'put' => array(
'env' => 'REQUEST_METHOD',
'value' => 'PUT'
),
'delete' => array(
'env' => 'REQUEST_METHOD',
'value' => 'DELETE'
),
'head' => array(
'env' => 'REQUEST_METHOD',
'value' => 'HEAD'
),
'options' => array(
'env' => 'REQUEST_METHOD',
'value' => 'OPTIONS'
),
'ssl' => array(
'env' => 'HTTPS',
'value' => (int) 1
),
'ajax' => array(
'env' => 'HTTP_X_REQUESTED_WITH',
'value' => 'XMLHttpRequest'
),
'flash' => array(
'env' => 'HTTP_USER_AGENT',
'pattern' => '/^(Shockwave|Adobe) Flash/'
),
'mobile' => array(
'env' => 'HTTP_USER_AGENT',
'options' => array(
[maximum depth reached]
)
),
'requested' => array(
'param' => 'requested',
'value' => (int) 1
),
'json' => array(
'accept' => array(
[maximum depth reached]
),
'param' => 'ext',
'value' => 'json'
),
'xml' => array(
'accept' => array(
[maximum depth reached]
),
'param' => 'ext',
'value' => 'xml'
)
)
[protected] _input => ''
}$Dispatcher = new Dispatcher();$Dispatcher->dispatch(new CakeRequest(),new CakeResponse());
object(CakeRequest) {
params => array(
'plugin' => null,
'controller' => 'etablissements',
'action' => 'index',
'named' => array(),
'pass' => array(
(int) 0 => 'mas-d-agenais'
),
'ville' => 'mas-d-agenais',
'isAjax' => false,
'models' => array(
'Departement' => array(
[maximum depth reached]
),
'Ville' => array(
[maximum depth reached]
),
'Epublic' => array(
[maximum depth reached]
),
'Etablissement' => array(
[maximum depth reached]
)
)
)
data => array()
query => array()
url => 'pros/mas-d-agenais'
base => ''
webroot => '/'
here => '/pros/mas-d-agenais'
[protected] _detectors => array(
'get' => array(
'env' => 'REQUEST_METHOD',
'value' => 'GET'
),
'patch' => array(
'env' => 'REQUEST_METHOD',
'value' => 'PATCH'
),
'post' => array(
'env' => 'REQUEST_METHOD',
'value' => 'POST'
),
'put' => array(
'env' => 'REQUEST_METHOD',
'value' => 'PUT'
),
'delete' => array(
'env' => 'REQUEST_METHOD',
'value' => 'DELETE'
),
'head' => array(
'env' => 'REQUEST_METHOD',
'value' => 'HEAD'
),
'options' => array(
'env' => 'REQUEST_METHOD',
'value' => 'OPTIONS'
),
'ssl' => array(
'env' => 'HTTPS',
'value' => (int) 1
),
'ajax' => array(
'env' => 'HTTP_X_REQUESTED_WITH',
'value' => 'XMLHttpRequest'
),
'flash' => array(
'env' => 'HTTP_USER_AGENT',
'pattern' => '/^(Shockwave|Adobe) Flash/'
),
'mobile' => array(
'env' => 'HTTP_USER_AGENT',
'options' => array(
[maximum depth reached]
)
),
'requested' => array(
'param' => 'requested',
'value' => (int) 1
),
'json' => array(
'accept' => array(
[maximum depth reached]
),
'param' => 'ext',
'value' => 'json'
),
'xml' => array(
'accept' => array(
[maximum depth reached]
),
'param' => 'ext',
'value' => 'xml'
)
)
[protected] _input => ''
}
object(CakeResponse) {
[protected] _statusCodes => array(
(int) 100 => 'Continue',
(int) 101 => 'Switching Protocols',
(int) 200 => 'OK',
(int) 201 => 'Created',
(int) 202 => 'Accepted',
(int) 203 => 'Non-Authoritative Information',
(int) 204 => 'No Content',
(int) 205 => 'Reset Content',
(int) 206 => 'Partial Content',
(int) 300 => 'Multiple Choices',
(int) 301 => 'Moved Permanently',
(int) 302 => 'Found',
(int) 303 => 'See Other',
(int) 304 => 'Not Modified',
(int) 305 => 'Use Proxy',
(int) 307 => 'Temporary Redirect',
(int) 400 => 'Bad Request',
(int) 401 => 'Unauthorized',
(int) 402 => 'Payment Required',
(int) 403 => 'Forbidden',
(int) 404 => 'Not Found',
(int) 405 => 'Method Not Allowed',
(int) 406 => 'Not Acceptable',
(int) 407 => 'Proxy Authentication Required',
(int) 408 => 'Request Time-out',
(int) 409 => 'Conflict',
(int) 410 => 'Gone',
(int) 411 => 'Length Required',
(int) 412 => 'Precondition Failed',
(int) 413 => 'Request Entity Too Large',
(int) 414 => 'Request-URI Too Large',
(int) 415 => 'Unsupported Media Type',
(int) 416 => 'Requested range not satisfiable',
(int) 417 => 'Expectation Failed',
(int) 429 => 'Too Many Requests',
(int) 500 => 'Internal Server Error',
(int) 501 => 'Not Implemented',
(int) 502 => 'Bad Gateway',
(int) 503 => 'Service Unavailable',
(int) 504 => 'Gateway Time-out',
(int) 505 => 'Unsupported Version'
)
[protected] _mimeTypes => array(
'html' => array(
(int) 0 => 'text/html',
(int) 1 => '*/*'
),
'json' => 'application/json',
'xml' => array(
(int) 0 => 'application/xml',
(int) 1 => 'text/xml'
),
'rss' => 'application/rss+xml',
'ai' => 'application/postscript',
'bcpio' => 'application/x-bcpio',
'bin' => 'application/octet-stream',
'ccad' => 'application/clariscad',
'cdf' => 'application/x-netcdf',
'class' => 'application/octet-stream',
'cpio' => 'application/x-cpio',
'cpt' => 'application/mac-compactpro',
'csh' => 'application/x-csh',
'csv' => array(
(int) 0 => 'text/csv',
(int) 1 => 'application/vnd.ms-excel'
),
'dcr' => 'application/x-director',
'dir' => 'application/x-director',
'dms' => 'application/octet-stream',
'doc' => 'application/msword',
'docx' => 'application/vnd.openxmlformats-officedocument.wordprocessingml.document',
'drw' => 'application/drafting',
'dvi' => 'application/x-dvi',
'dwg' => 'application/acad',
'dxf' => 'application/dxf',
'dxr' => 'application/x-director',
'eot' => 'application/vnd.ms-fontobject',
'eps' => 'application/postscript',
'exe' => 'application/octet-stream',
'ez' => 'application/andrew-inset',
'flv' => 'video/x-flv',
'gtar' => 'application/x-gtar',
'gz' => 'application/x-gzip',
'bz2' => 'application/x-bzip',
'7z' => 'application/x-7z-compressed',
'hdf' => 'application/x-hdf',
'hqx' => 'application/mac-binhex40',
'ico' => 'image/x-icon',
'ips' => 'application/x-ipscript',
'ipx' => 'application/x-ipix',
'js' => 'application/javascript',
'jsonapi' => 'application/vnd.api+json',
'latex' => 'application/x-latex',
'lha' => 'application/octet-stream',
'lsp' => 'application/x-lisp',
'lzh' => 'application/octet-stream',
'man' => 'application/x-troff-man',
'me' => 'application/x-troff-me',
'mif' => 'application/vnd.mif',
'ms' => 'application/x-troff-ms',
'nc' => 'application/x-netcdf',
'oda' => 'application/oda',
'otf' => 'font/otf',
'pdf' => 'application/pdf',
'pgn' => 'application/x-chess-pgn',
'pot' => 'application/vnd.ms-powerpoint',
'pps' => 'application/vnd.ms-powerpoint',
'ppt' => 'application/vnd.ms-powerpoint',
'pptx' => 'application/vnd.openxmlformats-officedocument.presentationml.presentation',
'ppz' => 'application/vnd.ms-powerpoint',
'pre' => 'application/x-freelance',
'prt' => 'application/pro_eng',
'ps' => 'application/postscript',
'roff' => 'application/x-troff',
'scm' => 'application/x-lotusscreencam',
'set' => 'application/set',
'sh' => 'application/x-sh',
'shar' => 'application/x-shar',
'sit' => 'application/x-stuffit',
'skd' => 'application/x-koan',
'skm' => 'application/x-koan',
'skp' => 'application/x-koan',
'skt' => 'application/x-koan',
'smi' => 'application/smil',
'smil' => 'application/smil',
'sol' => 'application/solids',
'spl' => 'application/x-futuresplash',
'src' => 'application/x-wais-source',
'step' => 'application/STEP',
'stl' => 'application/SLA',
'stp' => 'application/STEP',
'sv4cpio' => 'application/x-sv4cpio',
'sv4crc' => 'application/x-sv4crc',
'svg' => 'image/svg+xml',
'svgz' => 'image/svg+xml',
'swf' => 'application/x-shockwave-flash',
't' => 'application/x-troff',
'tar' => 'application/x-tar',
'tcl' => 'application/x-tcl',
'tex' => 'application/x-tex',
'texi' => 'application/x-texinfo',
'texinfo' => 'application/x-texinfo',
'tr' => 'application/x-troff',
'tsp' => 'application/dsptype',
'ttc' => 'font/ttf',
'ttf' => 'font/ttf',
'unv' => 'application/i-deas',
'ustar' => 'application/x-ustar',
'vcd' => 'application/x-cdlink',
'vda' => 'application/vda',
'xlc' => 'application/vnd.ms-excel',
'xll' => 'application/vnd.ms-excel',
'xlm' => 'application/vnd.ms-excel',
'xls' => 'application/vnd.ms-excel',
'xlsx' => 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet',
'xlw' => 'application/vnd.ms-excel',
'zip' => 'application/zip',
'aif' => 'audio/x-aiff',
'aifc' => 'audio/x-aiff',
'aiff' => 'audio/x-aiff',
'au' => 'audio/basic',
'kar' => 'audio/midi',
'mid' => 'audio/midi',
'midi' => 'audio/midi',
'mp2' => 'audio/mpeg',
'mp3' => 'audio/mpeg',
'mpga' => 'audio/mpeg',
'ogg' => 'audio/ogg',
'oga' => 'audio/ogg',
'spx' => 'audio/ogg',
'ra' => 'audio/x-realaudio',
'ram' => 'audio/x-pn-realaudio',
'rm' => 'audio/x-pn-realaudio',
'rpm' => 'audio/x-pn-realaudio-plugin',
'snd' => 'audio/basic',
'tsi' => 'audio/TSP-audio',
'wav' => 'audio/x-wav',
'aac' => 'audio/aac',
'asc' => 'text/plain',
'c' => 'text/plain',
'cc' => 'text/plain',
'css' => 'text/css',
'etx' => 'text/x-setext',
'f' => 'text/plain',
'f90' => 'text/plain',
'h' => 'text/plain',
'hh' => 'text/plain',
'htm' => array(
(int) 0 => 'text/html',
(int) 1 => '*/*'
),
'ics' => 'text/calendar',
'm' => 'text/plain',
'rtf' => 'text/rtf',
'rtx' => 'text/richtext',
'sgm' => 'text/sgml',
'sgml' => 'text/sgml',
'tsv' => 'text/tab-separated-values',
'tpl' => 'text/template',
'txt' => 'text/plain',
'text' => 'text/plain',
'avi' => 'video/x-msvideo',
'fli' => 'video/x-fli',
'mov' => 'video/quicktime',
'movie' => 'video/x-sgi-movie',
'mpe' => 'video/mpeg',
'mpeg' => 'video/mpeg',
'mpg' => 'video/mpeg',
'qt' => 'video/quicktime',
'viv' => 'video/vnd.vivo',
'vivo' => 'video/vnd.vivo',
'ogv' => 'video/ogg',
'webm' => 'video/webm',
'mp4' => 'video/mp4',
'm4v' => 'video/mp4',
'f4v' => 'video/mp4',
'f4p' => 'video/mp4',
'm4a' => 'audio/mp4',
'f4a' => 'audio/mp4',
'f4b' => 'audio/mp4',
'gif' => 'image/gif',
'ief' => 'image/ief',
'jpg' => 'image/jpeg',
'jpeg' => 'image/jpeg',
'jpe' => 'image/jpeg',
'pbm' => 'image/x-portable-bitmap',
'pgm' => 'image/x-portable-graymap',
'png' => 'image/png',
'pnm' => 'image/x-portable-anymap',
'ppm' => 'image/x-portable-pixmap',
'ras' => 'image/cmu-raster',
'rgb' => 'image/x-rgb',
'tif' => 'image/tiff',
'tiff' => 'image/tiff',
'xbm' => 'image/x-xbitmap',
'xpm' => 'image/x-xpixmap',
'xwd' => 'image/x-xwindowdump',
'psd' => array(
(int) 0 => 'application/photoshop',
(int) 1 => 'application/psd',
(int) 2 => 'image/psd',
(int) 3 => 'image/x-photoshop',
(int) 4 => 'image/photoshop',
(int) 5 => 'zz-application/zz-winassoc-psd'
),
'ice' => 'x-conference/x-cooltalk',
'iges' => 'model/iges',
'igs' => 'model/iges',
'mesh' => 'model/mesh',
'msh' => 'model/mesh',
'silo' => 'model/mesh',
'vrml' => 'model/vrml',
'wrl' => 'model/vrml',
'mime' => 'www/mime',
'pdb' => 'chemical/x-pdb',
'xyz' => 'chemical/x-pdb',
'javascript' => 'application/javascript',
'form' => 'application/x-www-form-urlencoded',
'file' => 'multipart/form-data',
'xhtml' => array(
(int) 0 => 'application/xhtml+xml',
(int) 1 => 'application/xhtml',
(int) 2 => 'text/xhtml'
),
'xhtml-mobile' => 'application/vnd.wap.xhtml+xml',
'atom' => 'application/atom+xml',
'amf' => 'application/x-amf',
'wap' => array(
(int) 0 => 'text/vnd.wap.wml',
(int) 1 => 'text/vnd.wap.wmlscript',
(int) 2 => 'image/vnd.wap.wbmp'
),
'wml' => 'text/vnd.wap.wml',
'wmlscript' => 'text/vnd.wap.wmlscript',
'wbmp' => 'image/vnd.wap.wbmp',
'woff' => 'application/x-font-woff',
'webp' => 'image/webp',
'appcache' => 'text/cache-manifest',
'manifest' => 'text/cache-manifest',
'htc' => 'text/x-component',
'rdf' => 'application/xml',
'crx' => 'application/x-chrome-extension',
'oex' => 'application/x-opera-extension',
'xpi' => 'application/x-xpinstall',
'safariextz' => 'application/octet-stream',
'webapp' => 'application/x-web-app-manifest+json',
'vcf' => 'text/x-vcard',
'vtt' => 'text/vtt',
'mkv' => 'video/x-matroska',
'pkpass' => 'application/vnd.apple.pkpass',
'ajax' => 'text/html'
)
[protected] _protocol => 'HTTP/1.1'
[protected] _status => (int) 200
[protected] _contentType => 'text/html'
[protected] _headers => array()
[protected] _body => null
[protected] _file => null
[protected] _fileRange => null
[protected] _charset => 'UTF-8'
[protected] _cacheDirectives => array()
[protected] _cookies => array(
'CakeCookie[autologin]' => array(
'name' => 'CakeCookie[autologin]',
'value' => '',
'expire' => (int) 1762260998,
'path' => '/',
'domain' => '',
'secure' => false,
'httpOnly' => false
)
)
}