Code Context
if($_GET['sent'] == 1)
{
$viewFile = '/web/htdocs/www.immobiliare55.com/home/src/Template/Element/front_footer.ctp'
$dataForView = [
'page' => 'home',
'subpage' => null,
'RealHl' => object(Cake\ORM\Query) {
'(help)' => 'This is a Query object, to get the results execute or iterate it.',
'sql' => 'SELECT Realestate.title AS `Realestate__title`, Realestate.id AS `Realestate__id`, Realestate.category AS `Realestate__category`, Realestate.mq AS `Realestate__mq`, Realestate.washroom AS `Realestate__washroom`, Realestate.rooms AS `Realestate__rooms`, Realestate.price AS `Realestate__price`, images.path AS `images__path` FROM realestate Realestate INNER JOIN images ON images.refer = Realestate.id AND images.path LIKE "0%" WHERE highlight = 1',
'params' => [[maximum depth reached]],
'defaultTypes' => [
[maximum depth reached]
],
'decorators' => (int) 0,
'executed' => false,
'hydrate' => true,
'buffered' => true,
'formatters' => (int) 0,
'mapReducers' => (int) 0,
'contain' => [[maximum depth reached]],
'matching' => [[maximum depth reached]],
'extraOptions' => [[maximum depth reached]],
'repository' => object(Cake\ORM\Table) {}
},
'locationsReal' => object(Cake\ORM\Query) {
'(help)' => 'This is a Query object, to get the results execute or iterate it.',
'sql' => 'SELECT DISTINCT Locations.id AS `Locations__id`, Locations.name AS `Locations__name` FROM locations Locations INNER JOIN realestate ON realestate.location = Locations.id AND realestate.public = 1 AND Locations.id != 1 ',
'params' => [[maximum depth reached]],
'defaultTypes' => [
[maximum depth reached]
],
'decorators' => (int) 0,
'executed' => true,
'hydrate' => true,
'buffered' => true,
'formatters' => (int) 0,
'mapReducers' => (int) 0,
'contain' => [[maximum depth reached]],
'matching' => [[maximum depth reached]],
'extraOptions' => [[maximum depth reached]],
'repository' => object(Cake\ORM\Table) {}
},
'RealRecenti' => object(Cake\ORM\Query) {
'(help)' => 'This is a Query object, to get the results execute or iterate it.',
'sql' => 'SELECT Realestate.title AS `Realestate__title`, Realestate.id AS `Realestate__id`, Realestate.washroom AS `Realestate__washroom`, Realestate.rooms AS `Realestate__rooms`, Realestate.mq AS `Realestate__mq`, category.name AS `category__name`, Realestate.price AS `Realestate__price`, locations.name AS `locations__name`, Realestate.insertionDate AS `Realestate__insertionDate`, images.path AS `images__path`, Realestate.public AS `Realestate__public` FROM realestate Realestate INNER JOIN category ON Realestate.category = category.id INNER JOIN locations ON Realestate.location = locations.id INNER JOIN images ON Realestate.id = images.refer AND images.first = 1 WHERE public = 1 ORDER BY insertionDate DESC LIMIT 5',
'params' => [[maximum depth reached]],
'defaultTypes' => [
[maximum depth reached]
],
'decorators' => (int) 0,
'executed' => true,
'hydrate' => true,
'buffered' => true,
'formatters' => (int) 0,
'mapReducers' => (int) 0,
'contain' => [[maximum depth reached]],
'matching' => [[maximum depth reached]],
'extraOptions' => [[maximum depth reached]],
'repository' => object(Cake\ORM\Table) {}
},
'CountReal' => (int) 71,
'CountImages' => (int) 625,
'CountLocations' => (int) 13,
'cover' => object(Cake\ORM\Query) {
'(help)' => 'This is a Query object, to get the results execute or iterate it.',
'sql' => 'SELECT Background.path AS `Background__path`, Background.id AS `Background__id` FROM background Background WHERE public = 1',
'params' => [[maximum depth reached]],
'defaultTypes' => [
[maximum depth reached]
],
'decorators' => (int) 0,
'executed' => true,
'hydrate' => true,
'buffered' => true,
'formatters' => (int) 0,
'mapReducers' => (int) 0,
'contain' => [[maximum depth reached]],
'matching' => [[maximum depth reached]],
'extraOptions' => [[maximum depth reached]],
'repository' => object(Cake\ORM\Table) {}
},
'categoryReal' => object(Cake\ORM\Query) {
'(help)' => 'This is a Query object, to get the results execute or iterate it.',
'sql' => 'SELECT DISTINCT Category.id AS `Category__id`, Category.name AS `Category__name` FROM category Category INNER JOIN realestate ON realestate.category = Category.id AND Category.name != "-"',
'params' => [[maximum depth reached]],
'defaultTypes' => [
[maximum depth reached]
],
'decorators' => (int) 0,
'executed' => true,
'hydrate' => true,
'buffered' => true,
'formatters' => (int) 0,
'mapReducers' => (int) 0,
'contain' => [[maximum depth reached]],
'matching' => [[maximum depth reached]],
'extraOptions' => [[maximum depth reached]],
'repository' => object(Cake\ORM\Table) {}
},
'categories' => object(Cake\ORM\Query) {
'(help)' => 'This is a Query object, to get the results execute or iterate it.',
'sql' => 'SELECT DISTINCT Category.id AS `Category__id`, Category.name AS `Category__name` FROM category Category',
'params' => [[maximum depth reached]],
'defaultTypes' => [
[maximum depth reached]
],
'decorators' => (int) 0,
'executed' => false,
'hydrate' => true,
'buffered' => true,
'formatters' => (int) 0,
'mapReducers' => (int) 0,
'contain' => [[maximum depth reached]],
'matching' => [[maximum depth reached]],
'extraOptions' => [[maximum depth reached]],
'repository' => object(Cake\ORM\Table) {}
}
]
$page = 'home'
$subpage = null
$RealHl = object(Cake\ORM\Query) {
'(help)' => 'This is a Query object, to get the results execute or iterate it.',
'sql' => 'SELECT Realestate.title AS `Realestate__title`, Realestate.id AS `Realestate__id`, Realestate.category AS `Realestate__category`, Realestate.mq AS `Realestate__mq`, Realestate.washroom AS `Realestate__washroom`, Realestate.rooms AS `Realestate__rooms`, Realestate.price AS `Realestate__price`, images.path AS `images__path` FROM realestate Realestate INNER JOIN images ON images.refer = Realestate.id AND images.path LIKE "0%" WHERE highlight = 1',
'params' => [],
'defaultTypes' => [
'Realestate__id' => 'integer',
'Realestate.id' => 'integer',
'id' => 'integer',
'Realestate__title' => 'string',
'Realestate.title' => 'string',
'title' => 'string',
'Realestate__category' => 'integer',
'Realestate.category' => 'integer',
'category' => 'integer',
'Realestate__insertionDate' => 'date',
'Realestate.insertionDate' => 'date',
'insertionDate' => 'date',
'Realestate__mq' => 'string',
'Realestate.mq' => 'string',
'mq' => 'string',
'Realestate__washroom' => 'string',
'Realestate.washroom' => 'string',
'washroom' => 'string',
'Realestate__rooms' => 'string',
'Realestate.rooms' => 'string',
'rooms' => 'string',
'Realestate__garage' => 'string',
'Realestate.garage' => 'string',
'garage' => 'string',
'Realestate__garden' => 'string',
'Realestate.garden' => 'string',
'garden' => 'string',
'Realestate__kitchen' => 'string',
'Realestate.kitchen' => 'string',
'kitchen' => 'string',
'Realestate__location' => 'integer',
'Realestate.location' => 'integer',
'location' => 'integer',
'Realestate__madeYear' => 'string',
'Realestate.madeYear' => 'string',
'madeYear' => 'string',
'Realestate__workYear' => 'string',
'Realestate.workYear' => 'string',
'workYear' => 'string',
'Realestate__balcony' => 'string',
'Realestate.balcony' => 'string',
'balcony' => 'string',
'Realestate__terrace' => 'string',
'Realestate.terrace' => 'string',
'terrace' => 'string',
'Realestate__winery' => 'string',
'Realestate.winery' => 'string',
'winery' => 'string',
'Realestate__cooling' => 'string',
'Realestate.cooling' => 'string',
'cooling' => 'string',
'Realestate__floor' => 'string',
'Realestate.floor' => 'string',
'floor' => 'string',
'Realestate__elevator' => 'string',
'Realestate.elevator' => 'string',
'elevator' => 'string',
'Realestate__rentFee' => 'string',
'Realestate.rentFee' => 'string',
'rentFee' => 'string',
'Realestate__decor' => 'string',
'Realestate.decor' => 'string',
'decor' => 'string',
'Realestate__tavern' => 'string',
'Realestate.tavern' => 'string',
'tavern' => 'string',
'Realestate__mansard' => 'string',
'Realestate.mansard' => 'string',
'mansard' => 'string',
'Realestate__heating' => 'string',
'Realestate.heating' => 'string',
'heating' => 'string',
'Realestate__heatingType' => 'string',
'Realestate.heatingType' => 'string',
'heatingType' => 'string',
'Realestate__alarm' => 'string',
'Realestate.alarm' => 'string',
'alarm' => 'string',
'Realestate__armoredDoor' => 'string',
'Realestate.armoredDoor' => 'string',
'armoredDoor' => 'string',
'Realestate__fireplace' => 'string',
'Realestate.fireplace' => 'string',
'fireplace' => 'string',
'Realestate__solar' => 'string',
'Realestate.solar' => 'string',
'solar' => 'string',
'Realestate__aircentral' => 'string',
'Realestate.aircentral' => 'string',
'aircentral' => 'string',
'Realestate__solarpanel' => 'string',
'Realestate.solarpanel' => 'string',
'solarpanel' => 'string',
'Realestate__videophone' => 'string',
'Realestate.videophone' => 'string',
'videophone' => 'string',
'Realestate__price' => 'string',
'Realestate.price' => 'string',
'price' => 'string',
'Realestate__ape' => 'string',
'Realestate.ape' => 'string',
'ape' => 'string',
'Realestate__rent' => 'boolean',
'Realestate.rent' => 'boolean',
'rent' => 'boolean',
'Realestate__descr' => 'text',
'Realestate.descr' => 'text',
'descr' => 'text',
'Realestate__public' => 'boolean',
'Realestate.public' => 'boolean',
'public' => 'boolean'
],
'decorators' => (int) 0,
'executed' => false,
'hydrate' => true,
'buffered' => true,
'formatters' => (int) 0,
'mapReducers' => (int) 0,
'contain' => [],
'matching' => [],
'extraOptions' => [],
'repository' => object(Cake\ORM\Table) {}
}
$locationsReal = object(Cake\ORM\Query) {
'(help)' => 'This is a Query object, to get the results execute or iterate it.',
'sql' => 'SELECT DISTINCT Locations.id AS `Locations__id`, Locations.name AS `Locations__name` FROM locations Locations INNER JOIN realestate ON realestate.location = Locations.id AND realestate.public = 1 AND Locations.id != 1 ',
'params' => [],
'defaultTypes' => [
'Locations__id' => 'integer',
'Locations.id' => 'integer',
'id' => 'integer',
'Locations__name' => 'string',
'Locations.name' => 'string',
'name' => 'string'
],
'decorators' => (int) 0,
'executed' => true,
'hydrate' => true,
'buffered' => true,
'formatters' => (int) 0,
'mapReducers' => (int) 0,
'contain' => [],
'matching' => [],
'extraOptions' => [],
'repository' => object(Cake\ORM\Table) {}
}
$RealRecenti = object(Cake\ORM\Query) {
'(help)' => 'This is a Query object, to get the results execute or iterate it.',
'sql' => 'SELECT Realestate.title AS `Realestate__title`, Realestate.id AS `Realestate__id`, Realestate.washroom AS `Realestate__washroom`, Realestate.rooms AS `Realestate__rooms`, Realestate.mq AS `Realestate__mq`, category.name AS `category__name`, Realestate.price AS `Realestate__price`, locations.name AS `locations__name`, Realestate.insertionDate AS `Realestate__insertionDate`, images.path AS `images__path`, Realestate.public AS `Realestate__public` FROM realestate Realestate INNER JOIN category ON Realestate.category = category.id INNER JOIN locations ON Realestate.location = locations.id INNER JOIN images ON Realestate.id = images.refer AND images.first = 1 WHERE public = 1 ORDER BY insertionDate DESC LIMIT 5',
'params' => [],
'defaultTypes' => [
'Realestate__id' => 'integer',
'Realestate.id' => 'integer',
'id' => 'integer',
'Realestate__title' => 'string',
'Realestate.title' => 'string',
'title' => 'string',
'Realestate__category' => 'integer',
'Realestate.category' => 'integer',
'category' => 'integer',
'Realestate__insertionDate' => 'date',
'Realestate.insertionDate' => 'date',
'insertionDate' => 'date',
'Realestate__mq' => 'string',
'Realestate.mq' => 'string',
'mq' => 'string',
'Realestate__washroom' => 'string',
'Realestate.washroom' => 'string',
'washroom' => 'string',
'Realestate__rooms' => 'string',
'Realestate.rooms' => 'string',
'rooms' => 'string',
'Realestate__garage' => 'string',
'Realestate.garage' => 'string',
'garage' => 'string',
'Realestate__garden' => 'string',
'Realestate.garden' => 'string',
'garden' => 'string',
'Realestate__kitchen' => 'string',
'Realestate.kitchen' => 'string',
'kitchen' => 'string',
'Realestate__location' => 'integer',
'Realestate.location' => 'integer',
'location' => 'integer',
'Realestate__madeYear' => 'string',
'Realestate.madeYear' => 'string',
'madeYear' => 'string',
'Realestate__workYear' => 'string',
'Realestate.workYear' => 'string',
'workYear' => 'string',
'Realestate__balcony' => 'string',
'Realestate.balcony' => 'string',
'balcony' => 'string',
'Realestate__terrace' => 'string',
'Realestate.terrace' => 'string',
'terrace' => 'string',
'Realestate__winery' => 'string',
'Realestate.winery' => 'string',
'winery' => 'string',
'Realestate__cooling' => 'string',
'Realestate.cooling' => 'string',
'cooling' => 'string',
'Realestate__floor' => 'string',
'Realestate.floor' => 'string',
'floor' => 'string',
'Realestate__elevator' => 'string',
'Realestate.elevator' => 'string',
'elevator' => 'string',
'Realestate__rentFee' => 'string',
'Realestate.rentFee' => 'string',
'rentFee' => 'string',
'Realestate__decor' => 'string',
'Realestate.decor' => 'string',
'decor' => 'string',
'Realestate__tavern' => 'string',
'Realestate.tavern' => 'string',
'tavern' => 'string',
'Realestate__mansard' => 'string',
'Realestate.mansard' => 'string',
'mansard' => 'string',
'Realestate__heating' => 'string',
'Realestate.heating' => 'string',
'heating' => 'string',
'Realestate__heatingType' => 'string',
'Realestate.heatingType' => 'string',
'heatingType' => 'string',
'Realestate__alarm' => 'string',
'Realestate.alarm' => 'string',
'alarm' => 'string',
'Realestate__armoredDoor' => 'string',
'Realestate.armoredDoor' => 'string',
'armoredDoor' => 'string',
'Realestate__fireplace' => 'string',
'Realestate.fireplace' => 'string',
'fireplace' => 'string',
'Realestate__solar' => 'string',
'Realestate.solar' => 'string',
'solar' => 'string',
'Realestate__aircentral' => 'string',
'Realestate.aircentral' => 'string',
'aircentral' => 'string',
'Realestate__solarpanel' => 'string',
'Realestate.solarpanel' => 'string',
'solarpanel' => 'string',
'Realestate__videophone' => 'string',
'Realestate.videophone' => 'string',
'videophone' => 'string',
'Realestate__price' => 'string',
'Realestate.price' => 'string',
'price' => 'string',
'Realestate__ape' => 'string',
'Realestate.ape' => 'string',
'ape' => 'string',
'Realestate__rent' => 'boolean',
'Realestate.rent' => 'boolean',
'rent' => 'boolean',
'Realestate__descr' => 'text',
'Realestate.descr' => 'text',
'descr' => 'text',
'Realestate__public' => 'boolean',
'Realestate.public' => 'boolean',
'public' => 'boolean'
],
'decorators' => (int) 0,
'executed' => true,
'hydrate' => true,
'buffered' => true,
'formatters' => (int) 0,
'mapReducers' => (int) 0,
'contain' => [],
'matching' => [],
'extraOptions' => [],
'repository' => object(Cake\ORM\Table) {}
}
$CountReal = (int) 71
$CountImages = (int) 625
$CountLocations = (int) 13
$cover = object(Cake\ORM\Query) {
'(help)' => 'This is a Query object, to get the results execute or iterate it.',
'sql' => 'SELECT Background.path AS `Background__path`, Background.id AS `Background__id` FROM background Background WHERE public = 1',
'params' => [],
'defaultTypes' => [
'Background__id' => 'integer',
'Background.id' => 'integer',
'id' => 'integer',
'Background__path' => 'string',
'Background.path' => 'string',
'path' => 'string',
'Background__public' => 'boolean',
'Background.public' => 'boolean',
'public' => 'boolean'
],
'decorators' => (int) 0,
'executed' => true,
'hydrate' => true,
'buffered' => true,
'formatters' => (int) 0,
'mapReducers' => (int) 0,
'contain' => [],
'matching' => [],
'extraOptions' => [],
'repository' => object(Cake\ORM\Table) {}
}
$categoryReal = object(Cake\ORM\Query) {
'(help)' => 'This is a Query object, to get the results execute or iterate it.',
'sql' => 'SELECT DISTINCT Category.id AS `Category__id`, Category.name AS `Category__name` FROM category Category INNER JOIN realestate ON realestate.category = Category.id AND Category.name != "-"',
'params' => [],
'defaultTypes' => [
'Category__id' => 'integer',
'Category.id' => 'integer',
'id' => 'integer',
'Category__name' => 'string',
'Category.name' => 'string',
'name' => 'string'
],
'decorators' => (int) 0,
'executed' => true,
'hydrate' => true,
'buffered' => true,
'formatters' => (int) 0,
'mapReducers' => (int) 0,
'contain' => [],
'matching' => [],
'extraOptions' => [],
'repository' => object(Cake\ORM\Table) {}
}
$categories = object(Cake\ORM\Query) {
'(help)' => 'This is a Query object, to get the results execute or iterate it.',
'sql' => 'SELECT DISTINCT Category.id AS `Category__id`, Category.name AS `Category__name` FROM category Category',
'params' => [],
'defaultTypes' => [
'Category__id' => 'integer',
'Category.id' => 'integer',
'id' => 'integer',
'Category__name' => 'string',
'Category.name' => 'string',
'name' => 'string'
],
'decorators' => (int) 0,
'executed' => false,
'hydrate' => true,
'buffered' => true,
'formatters' => (int) 0,
'mapReducers' => (int) 0,
'contain' => [],
'matching' => [],
'extraOptions' => [],
'repository' => object(Cake\ORM\Table) {}
}include - APP/Template/Element/front_footer.ctp, line 79
Cake\View\View::_evaluate() - CORE/src/View/View.php, line 1413
Cake\View\View::_render() - CORE/src/View/View.php, line 1374
Cake\View\View::_renderElement() - CORE/src/View/View.php, line 1838
Cake\View\View::element() - CORE/src/View/View.php, line 783
include - APP/Template/Pages/home.ctp, line 149
Cake\View\View::_evaluate() - CORE/src/View/View.php, line 1413
Cake\View\View::_render() - CORE/src/View/View.php, line 1374
Cake\View\View::render() - CORE/src/View/View.php, line 880
Cake\Controller\Controller::render() - CORE/src/Controller/Controller.php, line 791
App\Controller\PagesController::display() - APP/Controller/PagesController.php, line 63
Cake\Controller\Controller::invokeAction() - CORE/src/Controller/Controller.php, line 610
Cake\Http\ActionDispatcher::_invoke() - CORE/src/Http/ActionDispatcher.php, line 120
Cake\Http\ActionDispatcher::dispatch() - CORE/src/Http/ActionDispatcher.php, line 94
Cake\Http\BaseApplication::__invoke() - CORE/src/Http/BaseApplication.php, line 235
Cake\Http\Runner::__invoke() - CORE/src/Http/Runner.php, line 65
Cake\Http\Runner::__invoke() - CORE/src/Http/Runner.php, line 65
