Notice (8): Undefined variable: establishment [APP/Controller/SearchController.php, line 957]
Code Context

            // Quitamos los serficios que no tienen profesionales asignados
            if ($establishment[$key]['Service']) {
$page = (int) 1
$date_slot = ''
$conditions = array(
	'Establishment.population_id' => '4984'
)
$query_establishments = array(
	'Establishment.population_id' => '4984'
)
$key = (int) 0
$value = '4984'
$conditions_price = ''
$day = false
$datetotime = false
$hour = false
$index_dates = false
$fields = '*, IF (Establishment.id in (	select s.establishment_id from
                (select * from services where price > 0) s
                inner join timetables t on t.object='Service' and t.object_id = s.id
                inner join establishments e on s.establishment_id = e.id and plan_id > 0
                inner join timetables te on te.object='Establishment' and te.object_id = e.id
                inner join services_staffs st on st.service_id = s.id
                  inner join staffs on staffs.id = st.staff_id
                  inner join services_staffs stst on stst.staff_id = st.staff_id
                  inner join timetables s_t on s_t.object='Staff' and s_t.object_id = staffs.id
                ),1,0) as have_date '
$field = 'page'
$order = array(
	'have_date' => 'desc',
	'plan_id' => 'desc'
)
$establishments = array(
	(int) 0 => array(
		'Establishment' => array(
			'id' => '1968',
			'name' => 'FISIOTERAPIAS, SCP',
			'category_id' => '1',
			'establishment_type' => '1',
			'image' => null,
			'image_dir' => null,
			'web' => null,
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => '',
			'address1' => 'Carrer Esteve Barange, 18',
			'address2' => '',
			'email' => null,
			'fax' => null,
			'mobile' => '',
			'mobile2' => null,
			'phone' => '938713748',
			'phone2' => null,
			'zipcode' => '08440',
			'town' => 'Cardedeu',
			'state' => 'Barcelona',
			'country' => 'España',
			'latitude' => '41.638924',
			'longitude' => '2.360464',
			'slug' => 'fisioterapias-scp-carrer-esteve-barange',
			'canonical' => 'fisioterapia/cardedeu/fisioterapias-scp',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => '0d5bb5358202b889c58eb5b7ac767239',
			'hash_old' => null,
			'deleted' => false,
			'deleterequest' => null,
			'user_id' => null,
			'plan_id' => '1',
			'next_plan_id' => null,
			'video' => null,
			'pinterest' => null,
			'googleplus' => null,
			'youtube' => null,
			'linkedin' => null,
			'facebook' => null,
			'twitter' => null,
			'status' => '1',
			'subscription_status' => '0',
			'subscription_id' => '0',
			'population_id' => '4984',
			'bank' => null,
			'bank_cert' => null,
			'bank_cert_dir' => null,
			'bank_cert_status' => null,
			'file_dni' => null,
			'file_dni_dir' => null,
			'writers' => null,
			'writers_dir' => null,
			'split_id' => null,
			'created' => '2016-07-07 13:12:19',
			'modified' => '2018-07-10 19:41:49',
			'sms' => null,
			'fulladdress' => 'Carrer Esteve Barange, 18, Cardedeu ( 08440 ) , Barcelona',
			'link' => 'https://www.fisiosite.com/fisioterapia/cardedeu/fisioterapias-scp',
			'path_cert' => '/var/www/fisiosite.com/webroot//files/establishment/bank_cert//',
			'path_dni' => '/var/www/fisiosite.com/webroot//files/establishment/file_dni//',
			'path_writers' => '/var/www/fisiosite.com/webroot//files/establishment/writers//',
			'rating' => false,
			'is_open' => false
		),
		'Category' => array(
			'id' => '1',
			'name' => 'FISIOTERAPIA',
			'slug' => 'fisioterapia',
			'description' => '',
			'parent_id' => '31',
			'created' => '2016-06-13 12:15:16',
			'modified' => '2016-06-13 12:15:16',
			'lft' => '2',
			'rght' => '3'
		),
		'EstablishmentsCategory' => array(
			'id' => null,
			'establishment_id' => null,
			'category_id' => null,
			'created' => null,
			'modified' => null
		),
		'Service' => array(),
		'Slide' => array(
			'id' => null,
			'model' => null,
			'foreign_key' => null,
			'name' => null,
			'attachment' => null,
			'dir' => null,
			'type' => null,
			'size' => null,
			'active' => null
		),
		(int) 0 => array(
			'have_date' => '0'
		),
		'Comment' => array(),
		'Staff' => array(),
		'Slots' => array()
	),
	(int) 1 => array(
		'Establishment' => array(
			'id' => '12555',
			'name' => 'lea',
			'category_id' => '1',
			'establishment_type' => '3',
			'image' => null,
			'image_dir' => null,
			'web' => '',
			'short_description' => null,
			'description' => 'Tractaments de pluripatologies.',
			'fiscalnumber' => '43432994r',
			'address1' => 'calle st josep oriol',
			'address2' => '',
			'email' => 'leabcn@yahoo.es',
			'fax' => null,
			'mobile' => '',
			'mobile2' => null,
			'phone' => '',
			'phone2' => '619565893',
			'zipcode' => '08440',
			'town' => 'Cardedeu',
			'state' => 'Barcelona',
			'country' => '',
			'latitude' => null,
			'longitude' => null,
			'slug' => null,
			'canonical' => 'fisioterapia/cardedeu/lea',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => '8ed820be12be334e66d731218a3ad0fc',
			'hash_old' => null,
			'deleted' => false,
			'deleterequest' => null,
			'user_id' => '5f7ce9fa-5d5c-4e8f-be6e-694e335b89d7',
			'plan_id' => '1',
			'next_plan_id' => null,
			'video' => null,
			'pinterest' => null,
			'googleplus' => null,
			'youtube' => null,
			'linkedin' => null,
			'facebook' => null,
			'twitter' => null,
			'status' => '1',
			'subscription_status' => null,
			'subscription_id' => null,
			'population_id' => '4984',
			'bank' => '',
			'bank_cert' => null,
			'bank_cert_dir' => null,
			'bank_cert_status' => null,
			'file_dni' => null,
			'file_dni_dir' => null,
			'writers' => null,
			'writers_dir' => null,
			'split_id' => null,
			'created' => '2020-10-07 00:12:45',
			'modified' => '2020-10-07 09:59:50',
			'sms' => null,
			'fulladdress' => 'calle st josep oriol, Cardedeu ( 08440 ) , Barcelona',
			'link' => 'https://www.fisiosite.com/fisioterapia/cardedeu/lea',
			'path_cert' => '/var/www/fisiosite.com/webroot//files/establishment/bank_cert//',
			'path_dni' => '/var/www/fisiosite.com/webroot//files/establishment/file_dni//',
			'path_writers' => '/var/www/fisiosite.com/webroot//files/establishment/writers//'
		),
		'Category' => array(
			'id' => '1',
			'name' => 'FISIOTERAPIA',
			'slug' => 'fisioterapia',
			'description' => '',
			'parent_id' => '31',
			'created' => '2016-06-13 12:15:16',
			'modified' => '2016-06-13 12:15:16',
			'lft' => '2',
			'rght' => '3'
		),
		'EstablishmentsCategory' => array(
			'id' => null,
			'establishment_id' => null,
			'category_id' => null,
			'created' => null,
			'modified' => null
		),
		'Service' => array(
			'id' => null,
			'name' => null,
			'description' => null,
			'duration_reserved' => null,
			'duration' => null,
			'price' => null,
			'slots' => null,
			'pay_online' => null,
			'establishment_id' => null,
			'created_status' => null,
			'tag' => null,
			'created' => null,
			'modified' => null
		),
		'Slide' => array(
			'id' => null,
			'model' => null,
			'foreign_key' => null,
			'name' => null,
			'attachment' => null,
			'dir' => null,
			'type' => null,
			'size' => null,
			'active' => null
		),
		(int) 0 => array(
			'have_date' => '0'
		),
		'Comment' => array(),
		'Staff' => array()
	),
	(int) 2 => array(
		'Establishment' => array(
			'id' => '10393',
			'name' => 'Fisioterapias P',
			'category_id' => '1',
			'establishment_type' => '1',
			'image' => null,
			'image_dir' => null,
			'web' => '',
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => null,
			'address1' => 'Carrer Barangé, 18',
			'address2' => '',
			'email' => '',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '938 71 37 48',
			'phone2' => '',
			'zipcode' => '08440',
			'town' => 'Cardedeu',
			'state' => 'Barcelona',
			'country' => 'España',
			'latitude' => '41.638866',
			'longitude' => '2.360579',
			'slug' => null,
			'canonical' => 'fisioterapia/cardedeu/fisioterapias-p',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => 'b6be25713db847e99bdc9b22cb578a10',
			'hash_old' => null,
			'deleted' => false,
			'deleterequest' => null,
			'user_id' => null,
			'plan_id' => null,
			'next_plan_id' => null,
			'video' => null,
			'pinterest' => null,
			'googleplus' => null,
			'youtube' => null,
			'linkedin' => null,
			'facebook' => null,
			'twitter' => null,
			'status' => '1',
			'subscription_status' => '0',
			'subscription_id' => '0',
			'population_id' => '4984',
			'bank' => null,
			'bank_cert' => null,
			'bank_cert_dir' => null,
			'bank_cert_status' => null,
			'file_dni' => null,
			'file_dni_dir' => null,
			'writers' => null,
			'writers_dir' => null,
			'split_id' => null,
			'created' => '2017-10-02 10:04:01',
			'modified' => '2018-07-10 20:03:31',
			'sms' => null,
			'fulladdress' => 'Carrer Barangé, 18, Cardedeu ( 08440 ) , Barcelona',
			'link' => 'https://www.fisiosite.com/fisioterapia/cardedeu/fisioterapias-p',
			'path_cert' => '/var/www/fisiosite.com/webroot//files/establishment/bank_cert//',
			'path_dni' => '/var/www/fisiosite.com/webroot//files/establishment/file_dni//',
			'path_writers' => '/var/www/fisiosite.com/webroot//files/establishment/writers//'
		),
		'Category' => array(
			'id' => '1',
			'name' => 'FISIOTERAPIA',
			'slug' => 'fisioterapia',
			'description' => '',
			'parent_id' => '31',
			'created' => '2016-06-13 12:15:16',
			'modified' => '2016-06-13 12:15:16',
			'lft' => '2',
			'rght' => '3'
		),
		'EstablishmentsCategory' => array(
			'id' => null,
			'establishment_id' => null,
			'category_id' => null,
			'created' => null,
			'modified' => null
		),
		'Service' => array(
			'id' => null,
			'name' => null,
			'description' => null,
			'duration_reserved' => null,
			'duration' => null,
			'price' => null,
			'slots' => null,
			'pay_online' => null,
			'establishment_id' => null,
			'created_status' => null,
			'tag' => null,
			'created' => null,
			'modified' => null
		),
		'Slide' => array(
			'id' => null,
			'model' => null,
			'foreign_key' => null,
			'name' => null,
			'attachment' => null,
			'dir' => null,
			'type' => null,
			'size' => null,
			'active' => null
		),
		(int) 0 => array(
			'have_date' => '0'
		),
		'Comment' => array(),
		'Staff' => array()
	),
	(int) 3 => array(
		'Establishment' => array(
			'id' => '10394',
			'name' => 'Carles Sunyer Oller',
			'category_id' => '1',
			'establishment_type' => '1',
			'image' => null,
			'image_dir' => null,
			'web' => '',
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => null,
			'address1' => 'Carrer Llinars, 68',
			'address2' => '',
			'email' => '',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '938 44 46 67',
			'phone2' => '',
			'zipcode' => '08440',
			'town' => 'Cardedeu',
			'state' => 'Barcelona',
			'country' => 'España',
			'latitude' => '41.637371',
			'longitude' => '2.362430',
			'slug' => null,
			'canonical' => 'fisioterapia/cardedeu/carles-sunyer-oller',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => 'af7d084353ad76401075c68c027f56ee',
			'hash_old' => null,
			'deleted' => false,
			'deleterequest' => null,
			'user_id' => null,
			'plan_id' => null,
			'next_plan_id' => null,
			'video' => null,
			'pinterest' => null,
			'googleplus' => null,
			'youtube' => null,
			'linkedin' => null,
			'facebook' => null,
			'twitter' => null,
			'status' => '1',
			'subscription_status' => '0',
			'subscription_id' => '0',
			'population_id' => '4984',
			'bank' => null,
			'bank_cert' => null,
			'bank_cert_dir' => null,
			'bank_cert_status' => null,
			'file_dni' => null,
			'file_dni_dir' => null,
			'writers' => null,
			'writers_dir' => null,
			'split_id' => null,
			'created' => '2017-10-02 10:04:06',
			'modified' => '2018-07-10 20:03:31',
			'sms' => null,
			'fulladdress' => 'Carrer Llinars, 68, Cardedeu ( 08440 ) , Barcelona',
			'link' => 'https://www.fisiosite.com/fisioterapia/cardedeu/carles-sunyer-oller',
			'path_cert' => '/var/www/fisiosite.com/webroot//files/establishment/bank_cert//',
			'path_dni' => '/var/www/fisiosite.com/webroot//files/establishment/file_dni//',
			'path_writers' => '/var/www/fisiosite.com/webroot//files/establishment/writers//'
		),
		'Category' => array(
			'id' => '1',
			'name' => 'FISIOTERAPIA',
			'slug' => 'fisioterapia',
			'description' => '',
			'parent_id' => '31',
			'created' => '2016-06-13 12:15:16',
			'modified' => '2016-06-13 12:15:16',
			'lft' => '2',
			'rght' => '3'
		),
		'EstablishmentsCategory' => array(
			'id' => null,
			'establishment_id' => null,
			'category_id' => null,
			'created' => null,
			'modified' => null
		),
		'Service' => array(
			'id' => null,
			'name' => null,
			'description' => null,
			'duration_reserved' => null,
			'duration' => null,
			'price' => null,
			'slots' => null,
			'pay_online' => null,
			'establishment_id' => null,
			'created_status' => null,
			'tag' => null,
			'created' => null,
			'modified' => null
		),
		'Slide' => array(
			'id' => null,
			'model' => null,
			'foreign_key' => null,
			'name' => null,
			'attachment' => null,
			'dir' => null,
			'type' => null,
			'size' => null,
			'active' => null
		),
		(int) 0 => array(
			'have_date' => '0'
		),
		'Comment' => array(),
		'Staff' => array()
	),
	(int) 4 => array(
		'Establishment' => array(
			'id' => '10395',
			'name' => 'Homefisio Cardedeu',
			'category_id' => '1',
			'establishment_type' => '1',
			'image' => null,
			'image_dir' => null,
			'web' => 'http://homeofisiocardedeu.blogspot.com.es',
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => null,
			'address1' => 'C/Cervantes, 17',
			'address2' => '',
			'email' => '',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '627 909 953',
			'phone2' => '610 607 185',
			'zipcode' => '08440',
			'town' => 'Cardedeu',
			'state' => 'Barcelona',
			'country' => 'España',
			'latitude' => '41.640320',
			'longitude' => '2.356590',
			'slug' => null,
			'canonical' => 'fisioterapia/cardedeu/homefisio-cardedeu',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => '744778f8fc1c9f1398d5190f0fc97b93',
			'hash_old' => null,
			'deleted' => false,
			'deleterequest' => null,
			'user_id' => null,
			'plan_id' => null,
			'next_plan_id' => null,
			'video' => null,
			'pinterest' => null,
			'googleplus' => null,
			'youtube' => null,
			'linkedin' => null,
			'facebook' => null,
			'twitter' => null,
			'status' => '1',
			'subscription_status' => '0',
			'subscription_id' => '0',
			'population_id' => '4984',
			'bank' => null,
			'bank_cert' => null,
			'bank_cert_dir' => null,
			'bank_cert_status' => null,
			'file_dni' => null,
			'file_dni_dir' => null,
			'writers' => null,
			'writers_dir' => null,
			'split_id' => null,
			'created' => '2017-10-02 10:04:09',
			'modified' => '2018-07-10 20:03:31',
			'sms' => null,
			'fulladdress' => 'C/Cervantes, 17, Cardedeu ( 08440 ) , Barcelona',
			'link' => 'https://www.fisiosite.com/fisioterapia/cardedeu/homefisio-cardedeu',
			'path_cert' => '/var/www/fisiosite.com/webroot//files/establishment/bank_cert//',
			'path_dni' => '/var/www/fisiosite.com/webroot//files/establishment/file_dni//',
			'path_writers' => '/var/www/fisiosite.com/webroot//files/establishment/writers//'
		),
		'Category' => array(
			'id' => '1',
			'name' => 'FISIOTERAPIA',
			'slug' => 'fisioterapia',
			'description' => '',
			'parent_id' => '31',
			'created' => '2016-06-13 12:15:16',
			'modified' => '2016-06-13 12:15:16',
			'lft' => '2',
			'rght' => '3'
		),
		'EstablishmentsCategory' => array(
			'id' => null,
			'establishment_id' => null,
			'category_id' => null,
			'created' => null,
			'modified' => null
		),
		'Service' => array(
			'id' => null,
			'name' => null,
			'description' => null,
			'duration_reserved' => null,
			'duration' => null,
			'price' => null,
			'slots' => null,
			'pay_online' => null,
			'establishment_id' => null,
			'created_status' => null,
			'tag' => null,
			'created' => null,
			'modified' => null
		),
		'Slide' => array(
			'id' => null,
			'model' => null,
			'foreign_key' => null,
			'name' => null,
			'attachment' => null,
			'dir' => null,
			'type' => null,
			'size' => null,
			'active' => null
		),
		(int) 0 => array(
			'have_date' => '0'
		),
		'Comment' => array(),
		'Staff' => array()
	),
	(int) 5 => array(
		'Establishment' => array(
			'id' => '10396',
			'name' => 'Onco Cardedeu-Baix Montseny',
			'category_id' => '30',
			'establishment_type' => '1',
			'image' => null,
			'image_dir' => null,
			'web' => 'http://www.oncocardedeu.cat/',
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => null,
			'address1' => 'Àngel Guimera 144',
			'address2' => '',
			'email' => 'oncocardedeu@gmail.com',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '660 45 48 54',
			'phone2' => '',
			'zipcode' => '08440',
			'town' => 'Cardedeu',
			'state' => 'Barcelona',
			'country' => 'España',
			'latitude' => '41.640781',
			'longitude' => '2.359496',
			'slug' => null,
			'canonical' => 'fisioterapia-oncologica/cardedeu/onco-cardedeu-baix-montseny',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => '8ac8b548d4762d75da965be01850bc40',
			'hash_old' => null,
			'deleted' => false,
			'deleterequest' => null,
			'user_id' => null,
			'plan_id' => null,
			'next_plan_id' => null,
			'video' => null,
			'pinterest' => null,
			'googleplus' => null,
			'youtube' => null,
			'linkedin' => null,
			'facebook' => null,
			'twitter' => null,
			'status' => '1',
			'subscription_status' => '0',
			'subscription_id' => '0',
			'population_id' => '4984',
			'bank' => null,
			'bank_cert' => null,
			'bank_cert_dir' => null,
			'bank_cert_status' => null,
			'file_dni' => null,
			'file_dni_dir' => null,
			'writers' => null,
			'writers_dir' => null,
			'split_id' => null,
			'created' => '2017-10-02 10:04:13',
			'modified' => '2018-07-10 20:03:31',
			'sms' => null,
			'fulladdress' => 'Àngel Guimera 144, Cardedeu ( 08440 ) , Barcelona',
			'link' => 'https://www.fisiosite.com/fisioterapia-oncologica/cardedeu/onco-cardedeu-baix-montseny',
			'path_cert' => '/var/www/fisiosite.com/webroot//files/establishment/bank_cert//',
			'path_dni' => '/var/www/fisiosite.com/webroot//files/establishment/file_dni//',
			'path_writers' => '/var/www/fisiosite.com/webroot//files/establishment/writers//'
		),
		'Category' => array(
			'id' => '30',
			'name' => 'FISIOTERAPIA ONCOLOGICA',
			'slug' => 'fisioterapia-oncologica',
			'description' => '',
			'parent_id' => '1',
			'created' => '2016-06-13 12:15:17',
			'modified' => '2016-06-13 12:15:17',
			'lft' => '58',
			'rght' => '59'
		),
		'EstablishmentsCategory' => array(
			'id' => null,
			'establishment_id' => null,
			'category_id' => null,
			'created' => null,
			'modified' => null
		),
		'Service' => array(
			'id' => null,
			'name' => null,
			'description' => null,
			'duration_reserved' => null,
			'duration' => null,
			'price' => null,
			'slots' => null,
			'pay_online' => null,
			'establishment_id' => null,
			'created_status' => null,
			'tag' => null,
			'created' => null,
			'modified' => null
		),
		'Slide' => array(
			'id' => null,
			'model' => null,
			'foreign_key' => null,
			'name' => null,
			'attachment' => null,
			'dir' => null,
			'type' => null,
			'size' => null,
			'active' => null
		),
		(int) 0 => array(
			'have_date' => '0'
		),
		'Comment' => array(),
		'Staff' => array()
	),
	(int) 6 => array(
		'Establishment' => array(
			'id' => '10397',
			'name' => 'Núria López.',
			'category_id' => '1',
			'establishment_type' => '1',
			'image' => null,
			'image_dir' => null,
			'web' => '',
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => null,
			'address1' => 'Àngel Guimerà, 21',
			'address2' => '2n 1a',
			'email' => '',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '647 24 53 83',
			'phone2' => '',
			'zipcode' => '08440',
			'town' => 'Cardedeu',
			'state' => 'Barcelona',
			'country' => 'España',
			'latitude' => '41.637615',
			'longitude' => '2.359355',
			'slug' => null,
			'canonical' => 'fisioterapia/cardedeu/nuria-lopez',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => '7a7e0eecf51ea82b78030008aab2eaa8',
			'hash_old' => null,
			'deleted' => false,
			'deleterequest' => null,
			'user_id' => null,
			'plan_id' => null,
			'next_plan_id' => null,
			'video' => null,
			'pinterest' => null,
			'googleplus' => null,
			'youtube' => null,
			'linkedin' => null,
			'facebook' => null,
			'twitter' => null,
			'status' => '1',
			'subscription_status' => '0',
			'subscription_id' => '0',
			'population_id' => '4984',
			'bank' => null,
			'bank_cert' => null,
			'bank_cert_dir' => null,
			'bank_cert_status' => null,
			'file_dni' => null,
			'file_dni_dir' => null,
			'writers' => null,
			'writers_dir' => null,
			'split_id' => null,
			'created' => '2017-10-02 10:04:15',
			'modified' => '2018-07-10 20:03:32',
			'sms' => null,
			'fulladdress' => 'Àngel Guimerà, 21, Cardedeu ( 08440 ) , Barcelona',
			'link' => 'https://www.fisiosite.com/fisioterapia/cardedeu/nuria-lopez',
			'path_cert' => '/var/www/fisiosite.com/webroot//files/establishment/bank_cert//',
			'path_dni' => '/var/www/fisiosite.com/webroot//files/establishment/file_dni//',
			'path_writers' => '/var/www/fisiosite.com/webroot//files/establishment/writers//'
		),
		'Category' => array(
			'id' => '1',
			'name' => 'FISIOTERAPIA',
			'slug' => 'fisioterapia',
			'description' => '',
			'parent_id' => '31',
			'created' => '2016-06-13 12:15:16',
			'modified' => '2016-06-13 12:15:16',
			'lft' => '2',
			'rght' => '3'
		),
		'EstablishmentsCategory' => array(
			'id' => null,
			'establishment_id' => null,
			'category_id' => null,
			'created' => null,
			'modified' => null
		),
		'Service' => array(
			'id' => null,
			'name' => null,
			'description' => null,
			'duration_reserved' => null,
			'duration' => null,
			'price' => null,
			'slots' => null,
			'pay_online' => null,
			'establishment_id' => null,
			'created_status' => null,
			'tag' => null,
			'created' => null,
			'modified' => null
		),
		'Slide' => array(
			'id' => null,
			'model' => null,
			'foreign_key' => null,
			'name' => null,
			'attachment' => null,
			'dir' => null,
			'type' => null,
			'size' => null,
			'active' => null
		),
		(int) 0 => array(
			'have_date' => '0'
		),
		'Comment' => array(),
		'Staff' => array()
	),
	(int) 7 => array(
		'Establishment' => array(
			'id' => '10398',
			'name' => 'Eloi Anson Nebot',
			'category_id' => '14',
			'establishment_type' => '1',
			'image' => null,
			'image_dir' => null,
			'web' => '',
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => null,
			'address1' => 'Josep Vilaseca, 18',
			'address2' => 'Y 20',
			'email' => '',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '938477485',
			'phone2' => '',
			'zipcode' => '08440',
			'town' => 'Cardedeu',
			'state' => 'Barcelona',
			'country' => 'España',
			'latitude' => '41.638237',
			'longitude' => '2.354416',
			'slug' => null,
			'canonical' => 'osteopatia/cardedeu/eloi-anson-nebot',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => '7f10e9fdb02cc235b4f1214e4bb4a238',
			'hash_old' => null,
			'deleted' => false,
			'deleterequest' => null,
			'user_id' => null,
			'plan_id' => null,
			'next_plan_id' => null,
			'video' => null,
			'pinterest' => null,
			'googleplus' => null,
			'youtube' => null,
			'linkedin' => null,
			'facebook' => null,
			'twitter' => null,
			'status' => '1',
			'subscription_status' => '0',
			'subscription_id' => '0',
			'population_id' => '4984',
			'bank' => null,
			'bank_cert' => null,
			'bank_cert_dir' => null,
			'bank_cert_status' => null,
			'file_dni' => null,
			'file_dni_dir' => null,
			'writers' => null,
			'writers_dir' => null,
			'split_id' => null,
			'created' => '2017-10-02 10:04:17',
			'modified' => '2018-07-10 20:03:32',
			'sms' => null,
			'fulladdress' => 'Josep Vilaseca, 18, Cardedeu ( 08440 ) , Barcelona',
			'link' => 'https://www.fisiosite.com/osteopatia/cardedeu/eloi-anson-nebot',
			'path_cert' => '/var/www/fisiosite.com/webroot//files/establishment/bank_cert//',
			'path_dni' => '/var/www/fisiosite.com/webroot//files/establishment/file_dni//',
			'path_writers' => '/var/www/fisiosite.com/webroot//files/establishment/writers//'
		),
		'Category' => array(
			'id' => '14',
			'name' => 'OSTEOPATIA',
			'slug' => 'osteopatia',
			'description' => '',
			'parent_id' => '1',
			'created' => '2016-06-13 12:15:16',
			'modified' => '2016-06-13 12:15:16',
			'lft' => '26',
			'rght' => '27'
		),
		'EstablishmentsCategory' => array(
			'id' => null,
			'establishment_id' => null,
			'category_id' => null,
			'created' => null,
			'modified' => null
		),
		'Service' => array(
			'id' => null,
			'name' => null,
			'description' => null,
			'duration_reserved' => null,
			'duration' => null,
			'price' => null,
			'slots' => null,
			'pay_online' => null,
			'establishment_id' => null,
			'created_status' => null,
			'tag' => null,
			'created' => null,
			'modified' => null
		),
		'Slide' => array(
			'id' => null,
			'model' => null,
			'foreign_key' => null,
			'name' => null,
			'attachment' => null,
			'dir' => null,
			'type' => null,
			'size' => null,
			'active' => null
		),
		(int) 0 => array(
			'have_date' => '0'
		),
		'Comment' => array(),
		'Staff' => array()
	)
)
$n_establishments = (int) 8
$e = array(
	'Establishment' => array(
		'id' => '1968',
		'name' => 'FISIOTERAPIAS, SCP',
		'category_id' => '1',
		'establishment_type' => '1',
		'image' => null,
		'image_dir' => null,
		'web' => null,
		'short_description' => null,
		'description' => null,
		'fiscalnumber' => '',
		'address1' => 'Carrer Esteve Barange, 18',
		'address2' => '',
		'email' => null,
		'fax' => null,
		'mobile' => '',
		'mobile2' => null,
		'phone' => '938713748',
		'phone2' => null,
		'zipcode' => '08440',
		'town' => 'Cardedeu',
		'state' => 'Barcelona',
		'country' => 'España',
		'latitude' => '41.638924',
		'longitude' => '2.360464',
		'slug' => 'fisioterapias-scp-carrer-esteve-barange',
		'canonical' => 'fisioterapia/cardedeu/fisioterapias-scp',
		'canonical_old' => null,
		'timetable' => null,
		'hash' => '0d5bb5358202b889c58eb5b7ac767239',
		'hash_old' => null,
		'deleted' => false,
		'deleterequest' => null,
		'user_id' => null,
		'plan_id' => '1',
		'next_plan_id' => null,
		'video' => null,
		'pinterest' => null,
		'googleplus' => null,
		'youtube' => null,
		'linkedin' => null,
		'facebook' => null,
		'twitter' => null,
		'status' => '1',
		'subscription_status' => '0',
		'subscription_id' => '0',
		'population_id' => '4984',
		'bank' => null,
		'bank_cert' => null,
		'bank_cert_dir' => null,
		'bank_cert_status' => null,
		'file_dni' => null,
		'file_dni_dir' => null,
		'writers' => null,
		'writers_dir' => null,
		'split_id' => null,
		'created' => '2016-07-07 13:12:19',
		'modified' => '2018-07-10 19:41:49',
		'sms' => null,
		'fulladdress' => 'Carrer Esteve Barange, 18, Cardedeu ( 08440 ) , Barcelona',
		'link' => 'https://www.fisiosite.com/fisioterapia/cardedeu/fisioterapias-scp',
		'path_cert' => '/var/www/fisiosite.com/webroot//files/establishment/bank_cert//',
		'path_dni' => '/var/www/fisiosite.com/webroot//files/establishment/file_dni//',
		'path_writers' => '/var/www/fisiosite.com/webroot//files/establishment/writers//'
	),
	'Category' => array(
		'id' => '1',
		'name' => 'FISIOTERAPIA',
		'slug' => 'fisioterapia',
		'description' => '',
		'parent_id' => '31',
		'created' => '2016-06-13 12:15:16',
		'modified' => '2016-06-13 12:15:16',
		'lft' => '2',
		'rght' => '3'
	),
	'EstablishmentsCategory' => array(
		'id' => null,
		'establishment_id' => null,
		'category_id' => null,
		'created' => null,
		'modified' => null
	),
	'Service' => array(
		'id' => null,
		'name' => null,
		'description' => null,
		'duration_reserved' => null,
		'duration' => null,
		'price' => null,
		'slots' => null,
		'pay_online' => null,
		'establishment_id' => null,
		'created_status' => null,
		'tag' => null,
		'created' => null,
		'modified' => null
	),
	'Slide' => array(
		'id' => null,
		'model' => null,
		'foreign_key' => null,
		'name' => null,
		'attachment' => null,
		'dir' => null,
		'type' => null,
		'size' => null,
		'active' => null
	),
	(int) 0 => array(
		'have_date' => '0'
	),
	'Comment' => array(),
	'Staff' => array()
)
$comments = array()
SearchController::search_establishments() - APP/Controller/SearchController.php, line 957
SearchController::query() - APP/Controller/SearchController.php, line 1041
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - APP/Vendor/cakephp/cakephp/lib/Cake/Controller/Controller.php, line 490
Dispatcher::_invoke() - APP/Vendor/cakephp/cakephp/lib/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - APP/Vendor/cakephp/cakephp/lib/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 133

Notice (8): Undefined variable: establishment [APP/Controller/SearchController.php, line 957]
Code Context

            // Quitamos los serficios que no tienen profesionales asignados
            if ($establishment[$key]['Service']) {
$page = (int) 1
$date_slot = ''
$conditions = array(
	'Establishment.population_id' => '4984'
)
$query_establishments = array(
	'Establishment.population_id' => '4984'
)
$key = (int) 1
$value = '4984'
$conditions_price = ''
$day = false
$datetotime = false
$hour = false
$index_dates = false
$fields = '*, IF (Establishment.id in (	select s.establishment_id from
                (select * from services where price > 0) s
                inner join timetables t on t.object='Service' and t.object_id = s.id
                inner join establishments e on s.establishment_id = e.id and plan_id > 0
                inner join timetables te on te.object='Establishment' and te.object_id = e.id
                inner join services_staffs st on st.service_id = s.id
                  inner join staffs on staffs.id = st.staff_id
                  inner join services_staffs stst on stst.staff_id = st.staff_id
                  inner join timetables s_t on s_t.object='Staff' and s_t.object_id = staffs.id
                ),1,0) as have_date '
$field = 'page'
$order = array(
	'have_date' => 'desc',
	'plan_id' => 'desc'
)
$establishments = array(
	(int) 0 => array(
		'Establishment' => array(
			'id' => '1968',
			'name' => 'FISIOTERAPIAS, SCP',
			'category_id' => '1',
			'establishment_type' => '1',
			'image' => null,
			'image_dir' => null,
			'web' => null,
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => '',
			'address1' => 'Carrer Esteve Barange, 18',
			'address2' => '',
			'email' => null,
			'fax' => null,
			'mobile' => '',
			'mobile2' => null,
			'phone' => '938713748',
			'phone2' => null,
			'zipcode' => '08440',
			'town' => 'Cardedeu',
			'state' => 'Barcelona',
			'country' => 'España',
			'latitude' => '41.638924',
			'longitude' => '2.360464',
			'slug' => 'fisioterapias-scp-carrer-esteve-barange',
			'canonical' => 'fisioterapia/cardedeu/fisioterapias-scp',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => '0d5bb5358202b889c58eb5b7ac767239',
			'hash_old' => null,
			'deleted' => false,
			'deleterequest' => null,
			'user_id' => null,
			'plan_id' => '1',
			'next_plan_id' => null,
			'video' => null,
			'pinterest' => null,
			'googleplus' => null,
			'youtube' => null,
			'linkedin' => null,
			'facebook' => null,
			'twitter' => null,
			'status' => '1',
			'subscription_status' => '0',
			'subscription_id' => '0',
			'population_id' => '4984',
			'bank' => null,
			'bank_cert' => null,
			'bank_cert_dir' => null,
			'bank_cert_status' => null,
			'file_dni' => null,
			'file_dni_dir' => null,
			'writers' => null,
			'writers_dir' => null,
			'split_id' => null,
			'created' => '2016-07-07 13:12:19',
			'modified' => '2018-07-10 19:41:49',
			'sms' => null,
			'fulladdress' => 'Carrer Esteve Barange, 18, Cardedeu ( 08440 ) , Barcelona',
			'link' => 'https://www.fisiosite.com/fisioterapia/cardedeu/fisioterapias-scp',
			'path_cert' => '/var/www/fisiosite.com/webroot//files/establishment/bank_cert//',
			'path_dni' => '/var/www/fisiosite.com/webroot//files/establishment/file_dni//',
			'path_writers' => '/var/www/fisiosite.com/webroot//files/establishment/writers//',
			'rating' => false,
			'is_open' => false
		),
		'Category' => array(
			'id' => '1',
			'name' => 'FISIOTERAPIA',
			'slug' => 'fisioterapia',
			'description' => '',
			'parent_id' => '31',
			'created' => '2016-06-13 12:15:16',
			'modified' => '2016-06-13 12:15:16',
			'lft' => '2',
			'rght' => '3'
		),
		'EstablishmentsCategory' => array(
			'id' => null,
			'establishment_id' => null,
			'category_id' => null,
			'created' => null,
			'modified' => null
		),
		'Service' => array(),
		'Slide' => array(
			'id' => null,
			'model' => null,
			'foreign_key' => null,
			'name' => null,
			'attachment' => null,
			'dir' => null,
			'type' => null,
			'size' => null,
			'active' => null
		),
		(int) 0 => array(
			'have_date' => '0'
		),
		'Comment' => array(),
		'Staff' => array(),
		'Slots' => array()
	),
	(int) 1 => array(
		'Establishment' => array(
			'id' => '12555',
			'name' => 'lea',
			'category_id' => '1',
			'establishment_type' => '3',
			'image' => null,
			'image_dir' => null,
			'web' => '',
			'short_description' => null,
			'description' => 'Tractaments de pluripatologies.',
			'fiscalnumber' => '43432994r',
			'address1' => 'calle st josep oriol',
			'address2' => '',
			'email' => 'leabcn@yahoo.es',
			'fax' => null,
			'mobile' => '',
			'mobile2' => null,
			'phone' => '',
			'phone2' => '619565893',
			'zipcode' => '08440',
			'town' => 'Cardedeu',
			'state' => 'Barcelona',
			'country' => '',
			'latitude' => null,
			'longitude' => null,
			'slug' => null,
			'canonical' => 'fisioterapia/cardedeu/lea',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => '8ed820be12be334e66d731218a3ad0fc',
			'hash_old' => null,
			'deleted' => false,
			'deleterequest' => null,
			'user_id' => '5f7ce9fa-5d5c-4e8f-be6e-694e335b89d7',
			'plan_id' => '1',
			'next_plan_id' => null,
			'video' => null,
			'pinterest' => null,
			'googleplus' => null,
			'youtube' => null,
			'linkedin' => null,
			'facebook' => null,
			'twitter' => null,
			'status' => '1',
			'subscription_status' => null,
			'subscription_id' => null,
			'population_id' => '4984',
			'bank' => '',
			'bank_cert' => null,
			'bank_cert_dir' => null,
			'bank_cert_status' => null,
			'file_dni' => null,
			'file_dni_dir' => null,
			'writers' => null,
			'writers_dir' => null,
			'split_id' => null,
			'created' => '2020-10-07 00:12:45',
			'modified' => '2020-10-07 09:59:50',
			'sms' => null,
			'fulladdress' => 'calle st josep oriol, Cardedeu ( 08440 ) , Barcelona',
			'link' => 'https://www.fisiosite.com/fisioterapia/cardedeu/lea',
			'path_cert' => '/var/www/fisiosite.com/webroot//files/establishment/bank_cert//',
			'path_dni' => '/var/www/fisiosite.com/webroot//files/establishment/file_dni//',
			'path_writers' => '/var/www/fisiosite.com/webroot//files/establishment/writers//',
			'rating' => false,
			'is_open' => false
		),
		'Category' => array(
			'id' => '1',
			'name' => 'FISIOTERAPIA',
			'slug' => 'fisioterapia',
			'description' => '',
			'parent_id' => '31',
			'created' => '2016-06-13 12:15:16',
			'modified' => '2016-06-13 12:15:16',
			'lft' => '2',
			'rght' => '3'
		),
		'EstablishmentsCategory' => array(
			'id' => null,
			'establishment_id' => null,
			'category_id' => null,
			'created' => null,
			'modified' => null
		),
		'Service' => array(),
		'Slide' => array(
			'id' => null,
			'model' => null,
			'foreign_key' => null,
			'name' => null,
			'attachment' => null,
			'dir' => null,
			'type' => null,
			'size' => null,
			'active' => null
		),
		(int) 0 => array(
			'have_date' => '0'
		),
		'Comment' => array(),
		'Staff' => array(),
		'Slots' => array()
	),
	(int) 2 => array(
		'Establishment' => array(
			'id' => '10393',
			'name' => 'Fisioterapias P',
			'category_id' => '1',
			'establishment_type' => '1',
			'image' => null,
			'image_dir' => null,
			'web' => '',
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => null,
			'address1' => 'Carrer Barangé, 18',
			'address2' => '',
			'email' => '',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '938 71 37 48',
			'phone2' => '',
			'zipcode' => '08440',
			'town' => 'Cardedeu',
			'state' => 'Barcelona',
			'country' => 'España',
			'latitude' => '41.638866',
			'longitude' => '2.360579',
			'slug' => null,
			'canonical' => 'fisioterapia/cardedeu/fisioterapias-p',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => 'b6be25713db847e99bdc9b22cb578a10',
			'hash_old' => null,
			'deleted' => false,
			'deleterequest' => null,
			'user_id' => null,
			'plan_id' => null,
			'next_plan_id' => null,
			'video' => null,
			'pinterest' => null,
			'googleplus' => null,
			'youtube' => null,
			'linkedin' => null,
			'facebook' => null,
			'twitter' => null,
			'status' => '1',
			'subscription_status' => '0',
			'subscription_id' => '0',
			'population_id' => '4984',
			'bank' => null,
			'bank_cert' => null,
			'bank_cert_dir' => null,
			'bank_cert_status' => null,
			'file_dni' => null,
			'file_dni_dir' => null,
			'writers' => null,
			'writers_dir' => null,
			'split_id' => null,
			'created' => '2017-10-02 10:04:01',
			'modified' => '2018-07-10 20:03:31',
			'sms' => null,
			'fulladdress' => 'Carrer Barangé, 18, Cardedeu ( 08440 ) , Barcelona',
			'link' => 'https://www.fisiosite.com/fisioterapia/cardedeu/fisioterapias-p',
			'path_cert' => '/var/www/fisiosite.com/webroot//files/establishment/bank_cert//',
			'path_dni' => '/var/www/fisiosite.com/webroot//files/establishment/file_dni//',
			'path_writers' => '/var/www/fisiosite.com/webroot//files/establishment/writers//'
		),
		'Category' => array(
			'id' => '1',
			'name' => 'FISIOTERAPIA',
			'slug' => 'fisioterapia',
			'description' => '',
			'parent_id' => '31',
			'created' => '2016-06-13 12:15:16',
			'modified' => '2016-06-13 12:15:16',
			'lft' => '2',
			'rght' => '3'
		),
		'EstablishmentsCategory' => array(
			'id' => null,
			'establishment_id' => null,
			'category_id' => null,
			'created' => null,
			'modified' => null
		),
		'Service' => array(
			'id' => null,
			'name' => null,
			'description' => null,
			'duration_reserved' => null,
			'duration' => null,
			'price' => null,
			'slots' => null,
			'pay_online' => null,
			'establishment_id' => null,
			'created_status' => null,
			'tag' => null,
			'created' => null,
			'modified' => null
		),
		'Slide' => array(
			'id' => null,
			'model' => null,
			'foreign_key' => null,
			'name' => null,
			'attachment' => null,
			'dir' => null,
			'type' => null,
			'size' => null,
			'active' => null
		),
		(int) 0 => array(
			'have_date' => '0'
		),
		'Comment' => array(),
		'Staff' => array()
	),
	(int) 3 => array(
		'Establishment' => array(
			'id' => '10394',
			'name' => 'Carles Sunyer Oller',
			'category_id' => '1',
			'establishment_type' => '1',
			'image' => null,
			'image_dir' => null,
			'web' => '',
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => null,
			'address1' => 'Carrer Llinars, 68',
			'address2' => '',
			'email' => '',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '938 44 46 67',
			'phone2' => '',
			'zipcode' => '08440',
			'town' => 'Cardedeu',
			'state' => 'Barcelona',
			'country' => 'España',
			'latitude' => '41.637371',
			'longitude' => '2.362430',
			'slug' => null,
			'canonical' => 'fisioterapia/cardedeu/carles-sunyer-oller',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => 'af7d084353ad76401075c68c027f56ee',
			'hash_old' => null,
			'deleted' => false,
			'deleterequest' => null,
			'user_id' => null,
			'plan_id' => null,
			'next_plan_id' => null,
			'video' => null,
			'pinterest' => null,
			'googleplus' => null,
			'youtube' => null,
			'linkedin' => null,
			'facebook' => null,
			'twitter' => null,
			'status' => '1',
			'subscription_status' => '0',
			'subscription_id' => '0',
			'population_id' => '4984',
			'bank' => null,
			'bank_cert' => null,
			'bank_cert_dir' => null,
			'bank_cert_status' => null,
			'file_dni' => null,
			'file_dni_dir' => null,
			'writers' => null,
			'writers_dir' => null,
			'split_id' => null,
			'created' => '2017-10-02 10:04:06',
			'modified' => '2018-07-10 20:03:31',
			'sms' => null,
			'fulladdress' => 'Carrer Llinars, 68, Cardedeu ( 08440 ) , Barcelona',
			'link' => 'https://www.fisiosite.com/fisioterapia/cardedeu/carles-sunyer-oller',
			'path_cert' => '/var/www/fisiosite.com/webroot//files/establishment/bank_cert//',
			'path_dni' => '/var/www/fisiosite.com/webroot//files/establishment/file_dni//',
			'path_writers' => '/var/www/fisiosite.com/webroot//files/establishment/writers//'
		),
		'Category' => array(
			'id' => '1',
			'name' => 'FISIOTERAPIA',
			'slug' => 'fisioterapia',
			'description' => '',
			'parent_id' => '31',
			'created' => '2016-06-13 12:15:16',
			'modified' => '2016-06-13 12:15:16',
			'lft' => '2',
			'rght' => '3'
		),
		'EstablishmentsCategory' => array(
			'id' => null,
			'establishment_id' => null,
			'category_id' => null,
			'created' => null,
			'modified' => null
		),
		'Service' => array(
			'id' => null,
			'name' => null,
			'description' => null,
			'duration_reserved' => null,
			'duration' => null,
			'price' => null,
			'slots' => null,
			'pay_online' => null,
			'establishment_id' => null,
			'created_status' => null,
			'tag' => null,
			'created' => null,
			'modified' => null
		),
		'Slide' => array(
			'id' => null,
			'model' => null,
			'foreign_key' => null,
			'name' => null,
			'attachment' => null,
			'dir' => null,
			'type' => null,
			'size' => null,
			'active' => null
		),
		(int) 0 => array(
			'have_date' => '0'
		),
		'Comment' => array(),
		'Staff' => array()
	),
	(int) 4 => array(
		'Establishment' => array(
			'id' => '10395',
			'name' => 'Homefisio Cardedeu',
			'category_id' => '1',
			'establishment_type' => '1',
			'image' => null,
			'image_dir' => null,
			'web' => 'http://homeofisiocardedeu.blogspot.com.es',
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => null,
			'address1' => 'C/Cervantes, 17',
			'address2' => '',
			'email' => '',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '627 909 953',
			'phone2' => '610 607 185',
			'zipcode' => '08440',
			'town' => 'Cardedeu',
			'state' => 'Barcelona',
			'country' => 'España',
			'latitude' => '41.640320',
			'longitude' => '2.356590',
			'slug' => null,
			'canonical' => 'fisioterapia/cardedeu/homefisio-cardedeu',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => '744778f8fc1c9f1398d5190f0fc97b93',
			'hash_old' => null,
			'deleted' => false,
			'deleterequest' => null,
			'user_id' => null,
			'plan_id' => null,
			'next_plan_id' => null,
			'video' => null,
			'pinterest' => null,
			'googleplus' => null,
			'youtube' => null,
			'linkedin' => null,
			'facebook' => null,
			'twitter' => null,
			'status' => '1',
			'subscription_status' => '0',
			'subscription_id' => '0',
			'population_id' => '4984',
			'bank' => null,
			'bank_cert' => null,
			'bank_cert_dir' => null,
			'bank_cert_status' => null,
			'file_dni' => null,
			'file_dni_dir' => null,
			'writers' => null,
			'writers_dir' => null,
			'split_id' => null,
			'created' => '2017-10-02 10:04:09',
			'modified' => '2018-07-10 20:03:31',
			'sms' => null,
			'fulladdress' => 'C/Cervantes, 17, Cardedeu ( 08440 ) , Barcelona',
			'link' => 'https://www.fisiosite.com/fisioterapia/cardedeu/homefisio-cardedeu',
			'path_cert' => '/var/www/fisiosite.com/webroot//files/establishment/bank_cert//',
			'path_dni' => '/var/www/fisiosite.com/webroot//files/establishment/file_dni//',
			'path_writers' => '/var/www/fisiosite.com/webroot//files/establishment/writers//'
		),
		'Category' => array(
			'id' => '1',
			'name' => 'FISIOTERAPIA',
			'slug' => 'fisioterapia',
			'description' => '',
			'parent_id' => '31',
			'created' => '2016-06-13 12:15:16',
			'modified' => '2016-06-13 12:15:16',
			'lft' => '2',
			'rght' => '3'
		),
		'EstablishmentsCategory' => array(
			'id' => null,
			'establishment_id' => null,
			'category_id' => null,
			'created' => null,
			'modified' => null
		),
		'Service' => array(
			'id' => null,
			'name' => null,
			'description' => null,
			'duration_reserved' => null,
			'duration' => null,
			'price' => null,
			'slots' => null,
			'pay_online' => null,
			'establishment_id' => null,
			'created_status' => null,
			'tag' => null,
			'created' => null,
			'modified' => null
		),
		'Slide' => array(
			'id' => null,
			'model' => null,
			'foreign_key' => null,
			'name' => null,
			'attachment' => null,
			'dir' => null,
			'type' => null,
			'size' => null,
			'active' => null
		),
		(int) 0 => array(
			'have_date' => '0'
		),
		'Comment' => array(),
		'Staff' => array()
	),
	(int) 5 => array(
		'Establishment' => array(
			'id' => '10396',
			'name' => 'Onco Cardedeu-Baix Montseny',
			'category_id' => '30',
			'establishment_type' => '1',
			'image' => null,
			'image_dir' => null,
			'web' => 'http://www.oncocardedeu.cat/',
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => null,
			'address1' => 'Àngel Guimera 144',
			'address2' => '',
			'email' => 'oncocardedeu@gmail.com',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '660 45 48 54',
			'phone2' => '',
			'zipcode' => '08440',
			'town' => 'Cardedeu',
			'state' => 'Barcelona',
			'country' => 'España',
			'latitude' => '41.640781',
			'longitude' => '2.359496',
			'slug' => null,
			'canonical' => 'fisioterapia-oncologica/cardedeu/onco-cardedeu-baix-montseny',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => '8ac8b548d4762d75da965be01850bc40',
			'hash_old' => null,
			'deleted' => false,
			'deleterequest' => null,
			'user_id' => null,
			'plan_id' => null,
			'next_plan_id' => null,
			'video' => null,
			'pinterest' => null,
			'googleplus' => null,
			'youtube' => null,
			'linkedin' => null,
			'facebook' => null,
			'twitter' => null,
			'status' => '1',
			'subscription_status' => '0',
			'subscription_id' => '0',
			'population_id' => '4984',
			'bank' => null,
			'bank_cert' => null,
			'bank_cert_dir' => null,
			'bank_cert_status' => null,
			'file_dni' => null,
			'file_dni_dir' => null,
			'writers' => null,
			'writers_dir' => null,
			'split_id' => null,
			'created' => '2017-10-02 10:04:13',
			'modified' => '2018-07-10 20:03:31',
			'sms' => null,
			'fulladdress' => 'Àngel Guimera 144, Cardedeu ( 08440 ) , Barcelona',
			'link' => 'https://www.fisiosite.com/fisioterapia-oncologica/cardedeu/onco-cardedeu-baix-montseny',
			'path_cert' => '/var/www/fisiosite.com/webroot//files/establishment/bank_cert//',
			'path_dni' => '/var/www/fisiosite.com/webroot//files/establishment/file_dni//',
			'path_writers' => '/var/www/fisiosite.com/webroot//files/establishment/writers//'
		),
		'Category' => array(
			'id' => '30',
			'name' => 'FISIOTERAPIA ONCOLOGICA',
			'slug' => 'fisioterapia-oncologica',
			'description' => '',
			'parent_id' => '1',
			'created' => '2016-06-13 12:15:17',
			'modified' => '2016-06-13 12:15:17',
			'lft' => '58',
			'rght' => '59'
		),
		'EstablishmentsCategory' => array(
			'id' => null,
			'establishment_id' => null,
			'category_id' => null,
			'created' => null,
			'modified' => null
		),
		'Service' => array(
			'id' => null,
			'name' => null,
			'description' => null,
			'duration_reserved' => null,
			'duration' => null,
			'price' => null,
			'slots' => null,
			'pay_online' => null,
			'establishment_id' => null,
			'created_status' => null,
			'tag' => null,
			'created' => null,
			'modified' => null
		),
		'Slide' => array(
			'id' => null,
			'model' => null,
			'foreign_key' => null,
			'name' => null,
			'attachment' => null,
			'dir' => null,
			'type' => null,
			'size' => null,
			'active' => null
		),
		(int) 0 => array(
			'have_date' => '0'
		),
		'Comment' => array(),
		'Staff' => array()
	),
	(int) 6 => array(
		'Establishment' => array(
			'id' => '10397',
			'name' => 'Núria López.',
			'category_id' => '1',
			'establishment_type' => '1',
			'image' => null,
			'image_dir' => null,
			'web' => '',
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => null,
			'address1' => 'Àngel Guimerà, 21',
			'address2' => '2n 1a',
			'email' => '',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '647 24 53 83',
			'phone2' => '',
			'zipcode' => '08440',
			'town' => 'Cardedeu',
			'state' => 'Barcelona',
			'country' => 'España',
			'latitude' => '41.637615',
			'longitude' => '2.359355',
			'slug' => null,
			'canonical' => 'fisioterapia/cardedeu/nuria-lopez',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => '7a7e0eecf51ea82b78030008aab2eaa8',
			'hash_old' => null,
			'deleted' => false,
			'deleterequest' => null,
			'user_id' => null,
			'plan_id' => null,
			'next_plan_id' => null,
			'video' => null,
			'pinterest' => null,
			'googleplus' => null,
			'youtube' => null,
			'linkedin' => null,
			'facebook' => null,
			'twitter' => null,
			'status' => '1',
			'subscription_status' => '0',
			'subscription_id' => '0',
			'population_id' => '4984',
			'bank' => null,
			'bank_cert' => null,
			'bank_cert_dir' => null,
			'bank_cert_status' => null,
			'file_dni' => null,
			'file_dni_dir' => null,
			'writers' => null,
			'writers_dir' => null,
			'split_id' => null,
			'created' => '2017-10-02 10:04:15',
			'modified' => '2018-07-10 20:03:32',
			'sms' => null,
			'fulladdress' => 'Àngel Guimerà, 21, Cardedeu ( 08440 ) , Barcelona',
			'link' => 'https://www.fisiosite.com/fisioterapia/cardedeu/nuria-lopez',
			'path_cert' => '/var/www/fisiosite.com/webroot//files/establishment/bank_cert//',
			'path_dni' => '/var/www/fisiosite.com/webroot//files/establishment/file_dni//',
			'path_writers' => '/var/www/fisiosite.com/webroot//files/establishment/writers//'
		),
		'Category' => array(
			'id' => '1',
			'name' => 'FISIOTERAPIA',
			'slug' => 'fisioterapia',
			'description' => '',
			'parent_id' => '31',
			'created' => '2016-06-13 12:15:16',
			'modified' => '2016-06-13 12:15:16',
			'lft' => '2',
			'rght' => '3'
		),
		'EstablishmentsCategory' => array(
			'id' => null,
			'establishment_id' => null,
			'category_id' => null,
			'created' => null,
			'modified' => null
		),
		'Service' => array(
			'id' => null,
			'name' => null,
			'description' => null,
			'duration_reserved' => null,
			'duration' => null,
			'price' => null,
			'slots' => null,
			'pay_online' => null,
			'establishment_id' => null,
			'created_status' => null,
			'tag' => null,
			'created' => null,
			'modified' => null
		),
		'Slide' => array(
			'id' => null,
			'model' => null,
			'foreign_key' => null,
			'name' => null,
			'attachment' => null,
			'dir' => null,
			'type' => null,
			'size' => null,
			'active' => null
		),
		(int) 0 => array(
			'have_date' => '0'
		),
		'Comment' => array(),
		'Staff' => array()
	),
	(int) 7 => array(
		'Establishment' => array(
			'id' => '10398',
			'name' => 'Eloi Anson Nebot',
			'category_id' => '14',
			'establishment_type' => '1',
			'image' => null,
			'image_dir' => null,
			'web' => '',
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => null,
			'address1' => 'Josep Vilaseca, 18',
			'address2' => 'Y 20',
			'email' => '',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '938477485',
			'phone2' => '',
			'zipcode' => '08440',
			'town' => 'Cardedeu',
			'state' => 'Barcelona',
			'country' => 'España',
			'latitude' => '41.638237',
			'longitude' => '2.354416',
			'slug' => null,
			'canonical' => 'osteopatia/cardedeu/eloi-anson-nebot',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => '7f10e9fdb02cc235b4f1214e4bb4a238',
			'hash_old' => null,
			'deleted' => false,
			'deleterequest' => null,
			'user_id' => null,
			'plan_id' => null,
			'next_plan_id' => null,
			'video' => null,
			'pinterest' => null,
			'googleplus' => null,
			'youtube' => null,
			'linkedin' => null,
			'facebook' => null,
			'twitter' => null,
			'status' => '1',
			'subscription_status' => '0',
			'subscription_id' => '0',
			'population_id' => '4984',
			'bank' => null,
			'bank_cert' => null,
			'bank_cert_dir' => null,
			'bank_cert_status' => null,
			'file_dni' => null,
			'file_dni_dir' => null,
			'writers' => null,
			'writers_dir' => null,
			'split_id' => null,
			'created' => '2017-10-02 10:04:17',
			'modified' => '2018-07-10 20:03:32',
			'sms' => null,
			'fulladdress' => 'Josep Vilaseca, 18, Cardedeu ( 08440 ) , Barcelona',
			'link' => 'https://www.fisiosite.com/osteopatia/cardedeu/eloi-anson-nebot',
			'path_cert' => '/var/www/fisiosite.com/webroot//files/establishment/bank_cert//',
			'path_dni' => '/var/www/fisiosite.com/webroot//files/establishment/file_dni//',
			'path_writers' => '/var/www/fisiosite.com/webroot//files/establishment/writers//'
		),
		'Category' => array(
			'id' => '14',
			'name' => 'OSTEOPATIA',
			'slug' => 'osteopatia',
			'description' => '',
			'parent_id' => '1',
			'created' => '2016-06-13 12:15:16',
			'modified' => '2016-06-13 12:15:16',
			'lft' => '26',
			'rght' => '27'
		),
		'EstablishmentsCategory' => array(
			'id' => null,
			'establishment_id' => null,
			'category_id' => null,
			'created' => null,
			'modified' => null
		),
		'Service' => array(
			'id' => null,
			'name' => null,
			'description' => null,
			'duration_reserved' => null,
			'duration' => null,
			'price' => null,
			'slots' => null,
			'pay_online' => null,
			'establishment_id' => null,
			'created_status' => null,
			'tag' => null,
			'created' => null,
			'modified' => null
		),
		'Slide' => array(
			'id' => null,
			'model' => null,
			'foreign_key' => null,
			'name' => null,
			'attachment' => null,
			'dir' => null,
			'type' => null,
			'size' => null,
			'active' => null
		),
		(int) 0 => array(
			'have_date' => '0'
		),
		'Comment' => array(),
		'Staff' => array()
	)
)
$n_establishments = (int) 8
$e = array(
	'Establishment' => array(
		'id' => '12555',
		'name' => 'lea',
		'category_id' => '1',
		'establishment_type' => '3',
		'image' => null,
		'image_dir' => null,
		'web' => '',
		'short_description' => null,
		'description' => 'Tractaments de pluripatologies.',
		'fiscalnumber' => '43432994r',
		'address1' => 'calle st josep oriol',
		'address2' => '',
		'email' => 'leabcn@yahoo.es',
		'fax' => null,
		'mobile' => '',
		'mobile2' => null,
		'phone' => '',
		'phone2' => '619565893',
		'zipcode' => '08440',
		'town' => 'Cardedeu',
		'state' => 'Barcelona',
		'country' => '',
		'latitude' => null,
		'longitude' => null,
		'slug' => null,
		'canonical' => 'fisioterapia/cardedeu/lea',
		'canonical_old' => null,
		'timetable' => null,
		'hash' => '8ed820be12be334e66d731218a3ad0fc',
		'hash_old' => null,
		'deleted' => false,
		'deleterequest' => null,
		'user_id' => '5f7ce9fa-5d5c-4e8f-be6e-694e335b89d7',
		'plan_id' => '1',
		'next_plan_id' => null,
		'video' => null,
		'pinterest' => null,
		'googleplus' => null,
		'youtube' => null,
		'linkedin' => null,
		'facebook' => null,
		'twitter' => null,
		'status' => '1',
		'subscription_status' => null,
		'subscription_id' => null,
		'population_id' => '4984',
		'bank' => '',
		'bank_cert' => null,
		'bank_cert_dir' => null,
		'bank_cert_status' => null,
		'file_dni' => null,
		'file_dni_dir' => null,
		'writers' => null,
		'writers_dir' => null,
		'split_id' => null,
		'created' => '2020-10-07 00:12:45',
		'modified' => '2020-10-07 09:59:50',
		'sms' => null,
		'fulladdress' => 'calle st josep oriol, Cardedeu ( 08440 ) , Barcelona',
		'link' => 'https://www.fisiosite.com/fisioterapia/cardedeu/lea',
		'path_cert' => '/var/www/fisiosite.com/webroot//files/establishment/bank_cert//',
		'path_dni' => '/var/www/fisiosite.com/webroot//files/establishment/file_dni//',
		'path_writers' => '/var/www/fisiosite.com/webroot//files/establishment/writers//'
	),
	'Category' => array(
		'id' => '1',
		'name' => 'FISIOTERAPIA',
		'slug' => 'fisioterapia',
		'description' => '',
		'parent_id' => '31',
		'created' => '2016-06-13 12:15:16',
		'modified' => '2016-06-13 12:15:16',
		'lft' => '2',
		'rght' => '3'
	),
	'EstablishmentsCategory' => array(
		'id' => null,
		'establishment_id' => null,
		'category_id' => null,
		'created' => null,
		'modified' => null
	),
	'Service' => array(
		'id' => null,
		'name' => null,
		'description' => null,
		'duration_reserved' => null,
		'duration' => null,
		'price' => null,
		'slots' => null,
		'pay_online' => null,
		'establishment_id' => null,
		'created_status' => null,
		'tag' => null,
		'created' => null,
		'modified' => null
	),
	'Slide' => array(
		'id' => null,
		'model' => null,
		'foreign_key' => null,
		'name' => null,
		'attachment' => null,
		'dir' => null,
		'type' => null,
		'size' => null,
		'active' => null
	),
	(int) 0 => array(
		'have_date' => '0'
	),
	'Comment' => array(),
	'Staff' => array()
)
$comments = array()
SearchController::search_establishments() - APP/Controller/SearchController.php, line 957
SearchController::query() - APP/Controller/SearchController.php, line 1041
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - APP/Vendor/cakephp/cakephp/lib/Cake/Controller/Controller.php, line 490
Dispatcher::_invoke() - APP/Vendor/cakephp/cakephp/lib/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - APP/Vendor/cakephp/cakephp/lib/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 133

Notice (8): Undefined variable: establishment [APP/Controller/SearchController.php, line 957]
Code Context

            // Quitamos los serficios que no tienen profesionales asignados
            if ($establishment[$key]['Service']) {
$page = (int) 1
$date_slot = ''
$conditions = array(
	'Establishment.population_id' => '4984'
)
$query_establishments = array(
	'Establishment.population_id' => '4984'
)
$key = (int) 2
$value = '4984'
$conditions_price = ''
$day = false
$datetotime = false
$hour = false
$index_dates = false
$fields = '*, IF (Establishment.id in (	select s.establishment_id from
                (select * from services where price > 0) s
                inner join timetables t on t.object='Service' and t.object_id = s.id
                inner join establishments e on s.establishment_id = e.id and plan_id > 0
                inner join timetables te on te.object='Establishment' and te.object_id = e.id
                inner join services_staffs st on st.service_id = s.id
                  inner join staffs on staffs.id = st.staff_id
                  inner join services_staffs stst on stst.staff_id = st.staff_id
                  inner join timetables s_t on s_t.object='Staff' and s_t.object_id = staffs.id
                ),1,0) as have_date '
$field = 'page'
$order = array(
	'have_date' => 'desc',
	'plan_id' => 'desc'
)
$establishments = array(
	(int) 0 => array(
		'Establishment' => array(
			'id' => '1968',
			'name' => 'FISIOTERAPIAS, SCP',
			'category_id' => '1',
			'establishment_type' => '1',
			'image' => null,
			'image_dir' => null,
			'web' => null,
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => '',
			'address1' => 'Carrer Esteve Barange, 18',
			'address2' => '',
			'email' => null,
			'fax' => null,
			'mobile' => '',
			'mobile2' => null,
			'phone' => '938713748',
			'phone2' => null,
			'zipcode' => '08440',
			'town' => 'Cardedeu',
			'state' => 'Barcelona',
			'country' => 'España',
			'latitude' => '41.638924',
			'longitude' => '2.360464',
			'slug' => 'fisioterapias-scp-carrer-esteve-barange',
			'canonical' => 'fisioterapia/cardedeu/fisioterapias-scp',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => '0d5bb5358202b889c58eb5b7ac767239',
			'hash_old' => null,
			'deleted' => false,
			'deleterequest' => null,
			'user_id' => null,
			'plan_id' => '1',
			'next_plan_id' => null,
			'video' => null,
			'pinterest' => null,
			'googleplus' => null,
			'youtube' => null,
			'linkedin' => null,
			'facebook' => null,
			'twitter' => null,
			'status' => '1',
			'subscription_status' => '0',
			'subscription_id' => '0',
			'population_id' => '4984',
			'bank' => null,
			'bank_cert' => null,
			'bank_cert_dir' => null,
			'bank_cert_status' => null,
			'file_dni' => null,
			'file_dni_dir' => null,
			'writers' => null,
			'writers_dir' => null,
			'split_id' => null,
			'created' => '2016-07-07 13:12:19',
			'modified' => '2018-07-10 19:41:49',
			'sms' => null,
			'fulladdress' => 'Carrer Esteve Barange, 18, Cardedeu ( 08440 ) , Barcelona',
			'link' => 'https://www.fisiosite.com/fisioterapia/cardedeu/fisioterapias-scp',
			'path_cert' => '/var/www/fisiosite.com/webroot//files/establishment/bank_cert//',
			'path_dni' => '/var/www/fisiosite.com/webroot//files/establishment/file_dni//',
			'path_writers' => '/var/www/fisiosite.com/webroot//files/establishment/writers//',
			'rating' => false,
			'is_open' => false
		),
		'Category' => array(
			'id' => '1',
			'name' => 'FISIOTERAPIA',
			'slug' => 'fisioterapia',
			'description' => '',
			'parent_id' => '31',
			'created' => '2016-06-13 12:15:16',
			'modified' => '2016-06-13 12:15:16',
			'lft' => '2',
			'rght' => '3'
		),
		'EstablishmentsCategory' => array(
			'id' => null,
			'establishment_id' => null,
			'category_id' => null,
			'created' => null,
			'modified' => null
		),
		'Service' => array(),
		'Slide' => array(
			'id' => null,
			'model' => null,
			'foreign_key' => null,
			'name' => null,
			'attachment' => null,
			'dir' => null,
			'type' => null,
			'size' => null,
			'active' => null
		),
		(int) 0 => array(
			'have_date' => '0'
		),
		'Comment' => array(),
		'Staff' => array(),
		'Slots' => array()
	),
	(int) 1 => array(
		'Establishment' => array(
			'id' => '12555',
			'name' => 'lea',
			'category_id' => '1',
			'establishment_type' => '3',
			'image' => null,
			'image_dir' => null,
			'web' => '',
			'short_description' => null,
			'description' => 'Tractaments de pluripatologies.',
			'fiscalnumber' => '43432994r',
			'address1' => 'calle st josep oriol',
			'address2' => '',
			'email' => 'leabcn@yahoo.es',
			'fax' => null,
			'mobile' => '',
			'mobile2' => null,
			'phone' => '',
			'phone2' => '619565893',
			'zipcode' => '08440',
			'town' => 'Cardedeu',
			'state' => 'Barcelona',
			'country' => '',
			'latitude' => null,
			'longitude' => null,
			'slug' => null,
			'canonical' => 'fisioterapia/cardedeu/lea',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => '8ed820be12be334e66d731218a3ad0fc',
			'hash_old' => null,
			'deleted' => false,
			'deleterequest' => null,
			'user_id' => '5f7ce9fa-5d5c-4e8f-be6e-694e335b89d7',
			'plan_id' => '1',
			'next_plan_id' => null,
			'video' => null,
			'pinterest' => null,
			'googleplus' => null,
			'youtube' => null,
			'linkedin' => null,
			'facebook' => null,
			'twitter' => null,
			'status' => '1',
			'subscription_status' => null,
			'subscription_id' => null,
			'population_id' => '4984',
			'bank' => '',
			'bank_cert' => null,
			'bank_cert_dir' => null,
			'bank_cert_status' => null,
			'file_dni' => null,
			'file_dni_dir' => null,
			'writers' => null,
			'writers_dir' => null,
			'split_id' => null,
			'created' => '2020-10-07 00:12:45',
			'modified' => '2020-10-07 09:59:50',
			'sms' => null,
			'fulladdress' => 'calle st josep oriol, Cardedeu ( 08440 ) , Barcelona',
			'link' => 'https://www.fisiosite.com/fisioterapia/cardedeu/lea',
			'path_cert' => '/var/www/fisiosite.com/webroot//files/establishment/bank_cert//',
			'path_dni' => '/var/www/fisiosite.com/webroot//files/establishment/file_dni//',
			'path_writers' => '/var/www/fisiosite.com/webroot//files/establishment/writers//',
			'rating' => false,
			'is_open' => false
		),
		'Category' => array(
			'id' => '1',
			'name' => 'FISIOTERAPIA',
			'slug' => 'fisioterapia',
			'description' => '',
			'parent_id' => '31',
			'created' => '2016-06-13 12:15:16',
			'modified' => '2016-06-13 12:15:16',
			'lft' => '2',
			'rght' => '3'
		),
		'EstablishmentsCategory' => array(
			'id' => null,
			'establishment_id' => null,
			'category_id' => null,
			'created' => null,
			'modified' => null
		),
		'Service' => array(),
		'Slide' => array(
			'id' => null,
			'model' => null,
			'foreign_key' => null,
			'name' => null,
			'attachment' => null,
			'dir' => null,
			'type' => null,
			'size' => null,
			'active' => null
		),
		(int) 0 => array(
			'have_date' => '0'
		),
		'Comment' => array(),
		'Staff' => array(),
		'Slots' => array()
	),
	(int) 2 => array(
		'Establishment' => array(
			'id' => '10393',
			'name' => 'Fisioterapias P',
			'category_id' => '1',
			'establishment_type' => '1',
			'image' => null,
			'image_dir' => null,
			'web' => '',
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => null,
			'address1' => 'Carrer Barangé, 18',
			'address2' => '',
			'email' => '',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '938 71 37 48',
			'phone2' => '',
			'zipcode' => '08440',
			'town' => 'Cardedeu',
			'state' => 'Barcelona',
			'country' => 'España',
			'latitude' => '41.638866',
			'longitude' => '2.360579',
			'slug' => null,
			'canonical' => 'fisioterapia/cardedeu/fisioterapias-p',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => 'b6be25713db847e99bdc9b22cb578a10',
			'hash_old' => null,
			'deleted' => false,
			'deleterequest' => null,
			'user_id' => null,
			'plan_id' => null,
			'next_plan_id' => null,
			'video' => null,
			'pinterest' => null,
			'googleplus' => null,
			'youtube' => null,
			'linkedin' => null,
			'facebook' => null,
			'twitter' => null,
			'status' => '1',
			'subscription_status' => '0',
			'subscription_id' => '0',
			'population_id' => '4984',
			'bank' => null,
			'bank_cert' => null,
			'bank_cert_dir' => null,
			'bank_cert_status' => null,
			'file_dni' => null,
			'file_dni_dir' => null,
			'writers' => null,
			'writers_dir' => null,
			'split_id' => null,
			'created' => '2017-10-02 10:04:01',
			'modified' => '2018-07-10 20:03:31',
			'sms' => null,
			'fulladdress' => 'Carrer Barangé, 18, Cardedeu ( 08440 ) , Barcelona',
			'link' => 'https://www.fisiosite.com/fisioterapia/cardedeu/fisioterapias-p',
			'path_cert' => '/var/www/fisiosite.com/webroot//files/establishment/bank_cert//',
			'path_dni' => '/var/www/fisiosite.com/webroot//files/establishment/file_dni//',
			'path_writers' => '/var/www/fisiosite.com/webroot//files/establishment/writers//',
			'rating' => false,
			'is_open' => false
		),
		'Category' => array(
			'id' => '1',
			'name' => 'FISIOTERAPIA',
			'slug' => 'fisioterapia',
			'description' => '',
			'parent_id' => '31',
			'created' => '2016-06-13 12:15:16',
			'modified' => '2016-06-13 12:15:16',
			'lft' => '2',
			'rght' => '3'
		),
		'EstablishmentsCategory' => array(
			'id' => null,
			'establishment_id' => null,
			'category_id' => null,
			'created' => null,
			'modified' => null
		),
		'Service' => array(),
		'Slide' => array(
			'id' => null,
			'model' => null,
			'foreign_key' => null,
			'name' => null,
			'attachment' => null,
			'dir' => null,
			'type' => null,
			'size' => null,
			'active' => null
		),
		(int) 0 => array(
			'have_date' => '0'
		),
		'Comment' => array(),
		'Staff' => array(),
		'Slots' => array()
	),
	(int) 3 => array(
		'Establishment' => array(
			'id' => '10394',
			'name' => 'Carles Sunyer Oller',
			'category_id' => '1',
			'establishment_type' => '1',
			'image' => null,
			'image_dir' => null,
			'web' => '',
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => null,
			'address1' => 'Carrer Llinars, 68',
			'address2' => '',
			'email' => '',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '938 44 46 67',
			'phone2' => '',
			'zipcode' => '08440',
			'town' => 'Cardedeu',
			'state' => 'Barcelona',
			'country' => 'España',
			'latitude' => '41.637371',
			'longitude' => '2.362430',
			'slug' => null,
			'canonical' => 'fisioterapia/cardedeu/carles-sunyer-oller',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => 'af7d084353ad76401075c68c027f56ee',
			'hash_old' => null,
			'deleted' => false,
			'deleterequest' => null,
			'user_id' => null,
			'plan_id' => null,
			'next_plan_id' => null,
			'video' => null,
			'pinterest' => null,
			'googleplus' => null,
			'youtube' => null,
			'linkedin' => null,
			'facebook' => null,
			'twitter' => null,
			'status' => '1',
			'subscription_status' => '0',
			'subscription_id' => '0',
			'population_id' => '4984',
			'bank' => null,
			'bank_cert' => null,
			'bank_cert_dir' => null,
			'bank_cert_status' => null,
			'file_dni' => null,
			'file_dni_dir' => null,
			'writers' => null,
			'writers_dir' => null,
			'split_id' => null,
			'created' => '2017-10-02 10:04:06',
			'modified' => '2018-07-10 20:03:31',
			'sms' => null,
			'fulladdress' => 'Carrer Llinars, 68, Cardedeu ( 08440 ) , Barcelona',
			'link' => 'https://www.fisiosite.com/fisioterapia/cardedeu/carles-sunyer-oller',
			'path_cert' => '/var/www/fisiosite.com/webroot//files/establishment/bank_cert//',
			'path_dni' => '/var/www/fisiosite.com/webroot//files/establishment/file_dni//',
			'path_writers' => '/var/www/fisiosite.com/webroot//files/establishment/writers//'
		),
		'Category' => array(
			'id' => '1',
			'name' => 'FISIOTERAPIA',
			'slug' => 'fisioterapia',
			'description' => '',
			'parent_id' => '31',
			'created' => '2016-06-13 12:15:16',
			'modified' => '2016-06-13 12:15:16',
			'lft' => '2',
			'rght' => '3'
		),
		'EstablishmentsCategory' => array(
			'id' => null,
			'establishment_id' => null,
			'category_id' => null,
			'created' => null,
			'modified' => null
		),
		'Service' => array(
			'id' => null,
			'name' => null,
			'description' => null,
			'duration_reserved' => null,
			'duration' => null,
			'price' => null,
			'slots' => null,
			'pay_online' => null,
			'establishment_id' => null,
			'created_status' => null,
			'tag' => null,
			'created' => null,
			'modified' => null
		),
		'Slide' => array(
			'id' => null,
			'model' => null,
			'foreign_key' => null,
			'name' => null,
			'attachment' => null,
			'dir' => null,
			'type' => null,
			'size' => null,
			'active' => null
		),
		(int) 0 => array(
			'have_date' => '0'
		),
		'Comment' => array(),
		'Staff' => array()
	),
	(int) 4 => array(
		'Establishment' => array(
			'id' => '10395',
			'name' => 'Homefisio Cardedeu',
			'category_id' => '1',
			'establishment_type' => '1',
			'image' => null,
			'image_dir' => null,
			'web' => 'http://homeofisiocardedeu.blogspot.com.es',
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => null,
			'address1' => 'C/Cervantes, 17',
			'address2' => '',
			'email' => '',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '627 909 953',
			'phone2' => '610 607 185',
			'zipcode' => '08440',
			'town' => 'Cardedeu',
			'state' => 'Barcelona',
			'country' => 'España',
			'latitude' => '41.640320',
			'longitude' => '2.356590',
			'slug' => null,
			'canonical' => 'fisioterapia/cardedeu/homefisio-cardedeu',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => '744778f8fc1c9f1398d5190f0fc97b93',
			'hash_old' => null,
			'deleted' => false,
			'deleterequest' => null,
			'user_id' => null,
			'plan_id' => null,
			'next_plan_id' => null,
			'video' => null,
			'pinterest' => null,
			'googleplus' => null,
			'youtube' => null,
			'linkedin' => null,
			'facebook' => null,
			'twitter' => null,
			'status' => '1',
			'subscription_status' => '0',
			'subscription_id' => '0',
			'population_id' => '4984',
			'bank' => null,
			'bank_cert' => null,
			'bank_cert_dir' => null,
			'bank_cert_status' => null,
			'file_dni' => null,
			'file_dni_dir' => null,
			'writers' => null,
			'writers_dir' => null,
			'split_id' => null,
			'created' => '2017-10-02 10:04:09',
			'modified' => '2018-07-10 20:03:31',
			'sms' => null,
			'fulladdress' => 'C/Cervantes, 17, Cardedeu ( 08440 ) , Barcelona',
			'link' => 'https://www.fisiosite.com/fisioterapia/cardedeu/homefisio-cardedeu',
			'path_cert' => '/var/www/fisiosite.com/webroot//files/establishment/bank_cert//',
			'path_dni' => '/var/www/fisiosite.com/webroot//files/establishment/file_dni//',
			'path_writers' => '/var/www/fisiosite.com/webroot//files/establishment/writers//'
		),
		'Category' => array(
			'id' => '1',
			'name' => 'FISIOTERAPIA',
			'slug' => 'fisioterapia',
			'description' => '',
			'parent_id' => '31',
			'created' => '2016-06-13 12:15:16',
			'modified' => '2016-06-13 12:15:16',
			'lft' => '2',
			'rght' => '3'
		),
		'EstablishmentsCategory' => array(
			'id' => null,
			'establishment_id' => null,
			'category_id' => null,
			'created' => null,
			'modified' => null
		),
		'Service' => array(
			'id' => null,
			'name' => null,
			'description' => null,
			'duration_reserved' => null,
			'duration' => null,
			'price' => null,
			'slots' => null,
			'pay_online' => null,
			'establishment_id' => null,
			'created_status' => null,
			'tag' => null,
			'created' => null,
			'modified' => null
		),
		'Slide' => array(
			'id' => null,
			'model' => null,
			'foreign_key' => null,
			'name' => null,
			'attachment' => null,
			'dir' => null,
			'type' => null,
			'size' => null,
			'active' => null
		),
		(int) 0 => array(
			'have_date' => '0'
		),
		'Comment' => array(),
		'Staff' => array()
	),
	(int) 5 => array(
		'Establishment' => array(
			'id' => '10396',
			'name' => 'Onco Cardedeu-Baix Montseny',
			'category_id' => '30',
			'establishment_type' => '1',
			'image' => null,
			'image_dir' => null,
			'web' => 'http://www.oncocardedeu.cat/',
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => null,
			'address1' => 'Àngel Guimera 144',
			'address2' => '',
			'email' => 'oncocardedeu@gmail.com',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '660 45 48 54',
			'phone2' => '',
			'zipcode' => '08440',
			'town' => 'Cardedeu',
			'state' => 'Barcelona',
			'country' => 'España',
			'latitude' => '41.640781',
			'longitude' => '2.359496',
			'slug' => null,
			'canonical' => 'fisioterapia-oncologica/cardedeu/onco-cardedeu-baix-montseny',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => '8ac8b548d4762d75da965be01850bc40',
			'hash_old' => null,
			'deleted' => false,
			'deleterequest' => null,
			'user_id' => null,
			'plan_id' => null,
			'next_plan_id' => null,
			'video' => null,
			'pinterest' => null,
			'googleplus' => null,
			'youtube' => null,
			'linkedin' => null,
			'facebook' => null,
			'twitter' => null,
			'status' => '1',
			'subscription_status' => '0',
			'subscription_id' => '0',
			'population_id' => '4984',
			'bank' => null,
			'bank_cert' => null,
			'bank_cert_dir' => null,
			'bank_cert_status' => null,
			'file_dni' => null,
			'file_dni_dir' => null,
			'writers' => null,
			'writers_dir' => null,
			'split_id' => null,
			'created' => '2017-10-02 10:04:13',
			'modified' => '2018-07-10 20:03:31',
			'sms' => null,
			'fulladdress' => 'Àngel Guimera 144, Cardedeu ( 08440 ) , Barcelona',
			'link' => 'https://www.fisiosite.com/fisioterapia-oncologica/cardedeu/onco-cardedeu-baix-montseny',
			'path_cert' => '/var/www/fisiosite.com/webroot//files/establishment/bank_cert//',
			'path_dni' => '/var/www/fisiosite.com/webroot//files/establishment/file_dni//',
			'path_writers' => '/var/www/fisiosite.com/webroot//files/establishment/writers//'
		),
		'Category' => array(
			'id' => '30',
			'name' => 'FISIOTERAPIA ONCOLOGICA',
			'slug' => 'fisioterapia-oncologica',
			'description' => '',
			'parent_id' => '1',
			'created' => '2016-06-13 12:15:17',
			'modified' => '2016-06-13 12:15:17',
			'lft' => '58',
			'rght' => '59'
		),
		'EstablishmentsCategory' => array(
			'id' => null,
			'establishment_id' => null,
			'category_id' => null,
			'created' => null,
			'modified' => null
		),
		'Service' => array(
			'id' => null,
			'name' => null,
			'description' => null,
			'duration_reserved' => null,
			'duration' => null,
			'price' => null,
			'slots' => null,
			'pay_online' => null,
			'establishment_id' => null,
			'created_status' => null,
			'tag' => null,
			'created' => null,
			'modified' => null
		),
		'Slide' => array(
			'id' => null,
			'model' => null,
			'foreign_key' => null,
			'name' => null,
			'attachment' => null,
			'dir' => null,
			'type' => null,
			'size' => null,
			'active' => null
		),
		(int) 0 => array(
			'have_date' => '0'
		),
		'Comment' => array(),
		'Staff' => array()
	),
	(int) 6 => array(
		'Establishment' => array(
			'id' => '10397',
			'name' => 'Núria López.',
			'category_id' => '1',
			'establishment_type' => '1',
			'image' => null,
			'image_dir' => null,
			'web' => '',
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => null,
			'address1' => 'Àngel Guimerà, 21',
			'address2' => '2n 1a',
			'email' => '',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '647 24 53 83',
			'phone2' => '',
			'zipcode' => '08440',
			'town' => 'Cardedeu',
			'state' => 'Barcelona',
			'country' => 'España',
			'latitude' => '41.637615',
			'longitude' => '2.359355',
			'slug' => null,
			'canonical' => 'fisioterapia/cardedeu/nuria-lopez',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => '7a7e0eecf51ea82b78030008aab2eaa8',
			'hash_old' => null,
			'deleted' => false,
			'deleterequest' => null,
			'user_id' => null,
			'plan_id' => null,
			'next_plan_id' => null,
			'video' => null,
			'pinterest' => null,
			'googleplus' => null,
			'youtube' => null,
			'linkedin' => null,
			'facebook' => null,
			'twitter' => null,
			'status' => '1',
			'subscription_status' => '0',
			'subscription_id' => '0',
			'population_id' => '4984',
			'bank' => null,
			'bank_cert' => null,
			'bank_cert_dir' => null,
			'bank_cert_status' => null,
			'file_dni' => null,
			'file_dni_dir' => null,
			'writers' => null,
			'writers_dir' => null,
			'split_id' => null,
			'created' => '2017-10-02 10:04:15',
			'modified' => '2018-07-10 20:03:32',
			'sms' => null,
			'fulladdress' => 'Àngel Guimerà, 21, Cardedeu ( 08440 ) , Barcelona',
			'link' => 'https://www.fisiosite.com/fisioterapia/cardedeu/nuria-lopez',
			'path_cert' => '/var/www/fisiosite.com/webroot//files/establishment/bank_cert//',
			'path_dni' => '/var/www/fisiosite.com/webroot//files/establishment/file_dni//',
			'path_writers' => '/var/www/fisiosite.com/webroot//files/establishment/writers//'
		),
		'Category' => array(
			'id' => '1',
			'name' => 'FISIOTERAPIA',
			'slug' => 'fisioterapia',
			'description' => '',
			'parent_id' => '31',
			'created' => '2016-06-13 12:15:16',
			'modified' => '2016-06-13 12:15:16',
			'lft' => '2',
			'rght' => '3'
		),
		'EstablishmentsCategory' => array(
			'id' => null,
			'establishment_id' => null,
			'category_id' => null,
			'created' => null,
			'modified' => null
		),
		'Service' => array(
			'id' => null,
			'name' => null,
			'description' => null,
			'duration_reserved' => null,
			'duration' => null,
			'price' => null,
			'slots' => null,
			'pay_online' => null,
			'establishment_id' => null,
			'created_status' => null,
			'tag' => null,
			'created' => null,
			'modified' => null
		),
		'Slide' => array(
			'id' => null,
			'model' => null,
			'foreign_key' => null,
			'name' => null,
			'attachment' => null,
			'dir' => null,
			'type' => null,
			'size' => null,
			'active' => null
		),
		(int) 0 => array(
			'have_date' => '0'
		),
		'Comment' => array(),
		'Staff' => array()
	),
	(int) 7 => array(
		'Establishment' => array(
			'id' => '10398',
			'name' => 'Eloi Anson Nebot',
			'category_id' => '14',
			'establishment_type' => '1',
			'image' => null,
			'image_dir' => null,
			'web' => '',
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => null,
			'address1' => 'Josep Vilaseca, 18',
			'address2' => 'Y 20',
			'email' => '',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '938477485',
			'phone2' => '',
			'zipcode' => '08440',
			'town' => 'Cardedeu',
			'state' => 'Barcelona',
			'country' => 'España',
			'latitude' => '41.638237',
			'longitude' => '2.354416',
			'slug' => null,
			'canonical' => 'osteopatia/cardedeu/eloi-anson-nebot',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => '7f10e9fdb02cc235b4f1214e4bb4a238',
			'hash_old' => null,
			'deleted' => false,
			'deleterequest' => null,
			'user_id' => null,
			'plan_id' => null,
			'next_plan_id' => null,
			'video' => null,
			'pinterest' => null,
			'googleplus' => null,
			'youtube' => null,
			'linkedin' => null,
			'facebook' => null,
			'twitter' => null,
			'status' => '1',
			'subscription_status' => '0',
			'subscription_id' => '0',
			'population_id' => '4984',
			'bank' => null,
			'bank_cert' => null,
			'bank_cert_dir' => null,
			'bank_cert_status' => null,
			'file_dni' => null,
			'file_dni_dir' => null,
			'writers' => null,
			'writers_dir' => null,
			'split_id' => null,
			'created' => '2017-10-02 10:04:17',
			'modified' => '2018-07-10 20:03:32',
			'sms' => null,
			'fulladdress' => 'Josep Vilaseca, 18, Cardedeu ( 08440 ) , Barcelona',
			'link' => 'https://www.fisiosite.com/osteopatia/cardedeu/eloi-anson-nebot',
			'path_cert' => '/var/www/fisiosite.com/webroot//files/establishment/bank_cert//',
			'path_dni' => '/var/www/fisiosite.com/webroot//files/establishment/file_dni//',
			'path_writers' => '/var/www/fisiosite.com/webroot//files/establishment/writers//'
		),
		'Category' => array(
			'id' => '14',
			'name' => 'OSTEOPATIA',
			'slug' => 'osteopatia',
			'description' => '',
			'parent_id' => '1',
			'created' => '2016-06-13 12:15:16',
			'modified' => '2016-06-13 12:15:16',
			'lft' => '26',
			'rght' => '27'
		),
		'EstablishmentsCategory' => array(
			'id' => null,
			'establishment_id' => null,
			'category_id' => null,
			'created' => null,
			'modified' => null
		),
		'Service' => array(
			'id' => null,
			'name' => null,
			'description' => null,
			'duration_reserved' => null,
			'duration' => null,
			'price' => null,
			'slots' => null,
			'pay_online' => null,
			'establishment_id' => null,
			'created_status' => null,
			'tag' => null,
			'created' => null,
			'modified' => null
		),
		'Slide' => array(
			'id' => null,
			'model' => null,
			'foreign_key' => null,
			'name' => null,
			'attachment' => null,
			'dir' => null,
			'type' => null,
			'size' => null,
			'active' => null
		),
		(int) 0 => array(
			'have_date' => '0'
		),
		'Comment' => array(),
		'Staff' => array()
	)
)
$n_establishments = (int) 8
$e = array(
	'Establishment' => array(
		'id' => '10393',
		'name' => 'Fisioterapias P',
		'category_id' => '1',
		'establishment_type' => '1',
		'image' => null,
		'image_dir' => null,
		'web' => '',
		'short_description' => null,
		'description' => null,
		'fiscalnumber' => null,
		'address1' => 'Carrer Barangé, 18',
		'address2' => '',
		'email' => '',
		'fax' => null,
		'mobile' => '',
		'mobile2' => '',
		'phone' => '938 71 37 48',
		'phone2' => '',
		'zipcode' => '08440',
		'town' => 'Cardedeu',
		'state' => 'Barcelona',
		'country' => 'España',
		'latitude' => '41.638866',
		'longitude' => '2.360579',
		'slug' => null,
		'canonical' => 'fisioterapia/cardedeu/fisioterapias-p',
		'canonical_old' => null,
		'timetable' => null,
		'hash' => 'b6be25713db847e99bdc9b22cb578a10',
		'hash_old' => null,
		'deleted' => false,
		'deleterequest' => null,
		'user_id' => null,
		'plan_id' => null,
		'next_plan_id' => null,
		'video' => null,
		'pinterest' => null,
		'googleplus' => null,
		'youtube' => null,
		'linkedin' => null,
		'facebook' => null,
		'twitter' => null,
		'status' => '1',
		'subscription_status' => '0',
		'subscription_id' => '0',
		'population_id' => '4984',
		'bank' => null,
		'bank_cert' => null,
		'bank_cert_dir' => null,
		'bank_cert_status' => null,
		'file_dni' => null,
		'file_dni_dir' => null,
		'writers' => null,
		'writers_dir' => null,
		'split_id' => null,
		'created' => '2017-10-02 10:04:01',
		'modified' => '2018-07-10 20:03:31',
		'sms' => null,
		'fulladdress' => 'Carrer Barangé, 18, Cardedeu ( 08440 ) , Barcelona',
		'link' => 'https://www.fisiosite.com/fisioterapia/cardedeu/fisioterapias-p',
		'path_cert' => '/var/www/fisiosite.com/webroot//files/establishment/bank_cert//',
		'path_dni' => '/var/www/fisiosite.com/webroot//files/establishment/file_dni//',
		'path_writers' => '/var/www/fisiosite.com/webroot//files/establishment/writers//'
	),
	'Category' => array(
		'id' => '1',
		'name' => 'FISIOTERAPIA',
		'slug' => 'fisioterapia',
		'description' => '',
		'parent_id' => '31',
		'created' => '2016-06-13 12:15:16',
		'modified' => '2016-06-13 12:15:16',
		'lft' => '2',
		'rght' => '3'
	),
	'EstablishmentsCategory' => array(
		'id' => null,
		'establishment_id' => null,
		'category_id' => null,
		'created' => null,
		'modified' => null
	),
	'Service' => array(
		'id' => null,
		'name' => null,
		'description' => null,
		'duration_reserved' => null,
		'duration' => null,
		'price' => null,
		'slots' => null,
		'pay_online' => null,
		'establishment_id' => null,
		'created_status' => null,
		'tag' => null,
		'created' => null,
		'modified' => null
	),
	'Slide' => array(
		'id' => null,
		'model' => null,
		'foreign_key' => null,
		'name' => null,
		'attachment' => null,
		'dir' => null,
		'type' => null,
		'size' => null,
		'active' => null
	),
	(int) 0 => array(
		'have_date' => '0'
	),
	'Comment' => array(),
	'Staff' => array()
)
$comments = array()
SearchController::search_establishments() - APP/Controller/SearchController.php, line 957
SearchController::query() - APP/Controller/SearchController.php, line 1041
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - APP/Vendor/cakephp/cakephp/lib/Cake/Controller/Controller.php, line 490
Dispatcher::_invoke() - APP/Vendor/cakephp/cakephp/lib/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - APP/Vendor/cakephp/cakephp/lib/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 133

Notice (8): Undefined variable: establishment [APP/Controller/SearchController.php, line 957]
Code Context

            // Quitamos los serficios que no tienen profesionales asignados
            if ($establishment[$key]['Service']) {
$page = (int) 1
$date_slot = ''
$conditions = array(
	'Establishment.population_id' => '4984'
)
$query_establishments = array(
	'Establishment.population_id' => '4984'
)
$key = (int) 3
$value = '4984'
$conditions_price = ''
$day = false
$datetotime = false
$hour = false
$index_dates = false
$fields = '*, IF (Establishment.id in (	select s.establishment_id from
                (select * from services where price > 0) s
                inner join timetables t on t.object='Service' and t.object_id = s.id
                inner join establishments e on s.establishment_id = e.id and plan_id > 0
                inner join timetables te on te.object='Establishment' and te.object_id = e.id
                inner join services_staffs st on st.service_id = s.id
                  inner join staffs on staffs.id = st.staff_id
                  inner join services_staffs stst on stst.staff_id = st.staff_id
                  inner join timetables s_t on s_t.object='Staff' and s_t.object_id = staffs.id
                ),1,0) as have_date '
$field = 'page'
$order = array(
	'have_date' => 'desc',
	'plan_id' => 'desc'
)
$establishments = array(
	(int) 0 => array(
		'Establishment' => array(
			'id' => '1968',
			'name' => 'FISIOTERAPIAS, SCP',
			'category_id' => '1',
			'establishment_type' => '1',
			'image' => null,
			'image_dir' => null,
			'web' => null,
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => '',
			'address1' => 'Carrer Esteve Barange, 18',
			'address2' => '',
			'email' => null,
			'fax' => null,
			'mobile' => '',
			'mobile2' => null,
			'phone' => '938713748',
			'phone2' => null,
			'zipcode' => '08440',
			'town' => 'Cardedeu',
			'state' => 'Barcelona',
			'country' => 'España',
			'latitude' => '41.638924',
			'longitude' => '2.360464',
			'slug' => 'fisioterapias-scp-carrer-esteve-barange',
			'canonical' => 'fisioterapia/cardedeu/fisioterapias-scp',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => '0d5bb5358202b889c58eb5b7ac767239',
			'hash_old' => null,
			'deleted' => false,
			'deleterequest' => null,
			'user_id' => null,
			'plan_id' => '1',
			'next_plan_id' => null,
			'video' => null,
			'pinterest' => null,
			'googleplus' => null,
			'youtube' => null,
			'linkedin' => null,
			'facebook' => null,
			'twitter' => null,
			'status' => '1',
			'subscription_status' => '0',
			'subscription_id' => '0',
			'population_id' => '4984',
			'bank' => null,
			'bank_cert' => null,
			'bank_cert_dir' => null,
			'bank_cert_status' => null,
			'file_dni' => null,
			'file_dni_dir' => null,
			'writers' => null,
			'writers_dir' => null,
			'split_id' => null,
			'created' => '2016-07-07 13:12:19',
			'modified' => '2018-07-10 19:41:49',
			'sms' => null,
			'fulladdress' => 'Carrer Esteve Barange, 18, Cardedeu ( 08440 ) , Barcelona',
			'link' => 'https://www.fisiosite.com/fisioterapia/cardedeu/fisioterapias-scp',
			'path_cert' => '/var/www/fisiosite.com/webroot//files/establishment/bank_cert//',
			'path_dni' => '/var/www/fisiosite.com/webroot//files/establishment/file_dni//',
			'path_writers' => '/var/www/fisiosite.com/webroot//files/establishment/writers//',
			'rating' => false,
			'is_open' => false
		),
		'Category' => array(
			'id' => '1',
			'name' => 'FISIOTERAPIA',
			'slug' => 'fisioterapia',
			'description' => '',
			'parent_id' => '31',
			'created' => '2016-06-13 12:15:16',
			'modified' => '2016-06-13 12:15:16',
			'lft' => '2',
			'rght' => '3'
		),
		'EstablishmentsCategory' => array(
			'id' => null,
			'establishment_id' => null,
			'category_id' => null,
			'created' => null,
			'modified' => null
		),
		'Service' => array(),
		'Slide' => array(
			'id' => null,
			'model' => null,
			'foreign_key' => null,
			'name' => null,
			'attachment' => null,
			'dir' => null,
			'type' => null,
			'size' => null,
			'active' => null
		),
		(int) 0 => array(
			'have_date' => '0'
		),
		'Comment' => array(),
		'Staff' => array(),
		'Slots' => array()
	),
	(int) 1 => array(
		'Establishment' => array(
			'id' => '12555',
			'name' => 'lea',
			'category_id' => '1',
			'establishment_type' => '3',
			'image' => null,
			'image_dir' => null,
			'web' => '',
			'short_description' => null,
			'description' => 'Tractaments de pluripatologies.',
			'fiscalnumber' => '43432994r',
			'address1' => 'calle st josep oriol',
			'address2' => '',
			'email' => 'leabcn@yahoo.es',
			'fax' => null,
			'mobile' => '',
			'mobile2' => null,
			'phone' => '',
			'phone2' => '619565893',
			'zipcode' => '08440',
			'town' => 'Cardedeu',
			'state' => 'Barcelona',
			'country' => '',
			'latitude' => null,
			'longitude' => null,
			'slug' => null,
			'canonical' => 'fisioterapia/cardedeu/lea',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => '8ed820be12be334e66d731218a3ad0fc',
			'hash_old' => null,
			'deleted' => false,
			'deleterequest' => null,
			'user_id' => '5f7ce9fa-5d5c-4e8f-be6e-694e335b89d7',
			'plan_id' => '1',
			'next_plan_id' => null,
			'video' => null,
			'pinterest' => null,
			'googleplus' => null,
			'youtube' => null,
			'linkedin' => null,
			'facebook' => null,
			'twitter' => null,
			'status' => '1',
			'subscription_status' => null,
			'subscription_id' => null,
			'population_id' => '4984',
			'bank' => '',
			'bank_cert' => null,
			'bank_cert_dir' => null,
			'bank_cert_status' => null,
			'file_dni' => null,
			'file_dni_dir' => null,
			'writers' => null,
			'writers_dir' => null,
			'split_id' => null,
			'created' => '2020-10-07 00:12:45',
			'modified' => '2020-10-07 09:59:50',
			'sms' => null,
			'fulladdress' => 'calle st josep oriol, Cardedeu ( 08440 ) , Barcelona',
			'link' => 'https://www.fisiosite.com/fisioterapia/cardedeu/lea',
			'path_cert' => '/var/www/fisiosite.com/webroot//files/establishment/bank_cert//',
			'path_dni' => '/var/www/fisiosite.com/webroot//files/establishment/file_dni//',
			'path_writers' => '/var/www/fisiosite.com/webroot//files/establishment/writers//',
			'rating' => false,
			'is_open' => false
		),
		'Category' => array(
			'id' => '1',
			'name' => 'FISIOTERAPIA',
			'slug' => 'fisioterapia',
			'description' => '',
			'parent_id' => '31',
			'created' => '2016-06-13 12:15:16',
			'modified' => '2016-06-13 12:15:16',
			'lft' => '2',
			'rght' => '3'
		),
		'EstablishmentsCategory' => array(
			'id' => null,
			'establishment_id' => null,
			'category_id' => null,
			'created' => null,
			'modified' => null
		),
		'Service' => array(),
		'Slide' => array(
			'id' => null,
			'model' => null,
			'foreign_key' => null,
			'name' => null,
			'attachment' => null,
			'dir' => null,
			'type' => null,
			'size' => null,
			'active' => null
		),
		(int) 0 => array(
			'have_date' => '0'
		),
		'Comment' => array(),
		'Staff' => array(),
		'Slots' => array()
	),
	(int) 2 => array(
		'Establishment' => array(
			'id' => '10393',
			'name' => 'Fisioterapias P',
			'category_id' => '1',
			'establishment_type' => '1',
			'image' => null,
			'image_dir' => null,
			'web' => '',
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => null,
			'address1' => 'Carrer Barangé, 18',
			'address2' => '',
			'email' => '',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '938 71 37 48',
			'phone2' => '',
			'zipcode' => '08440',
			'town' => 'Cardedeu',
			'state' => 'Barcelona',
			'country' => 'España',
			'latitude' => '41.638866',
			'longitude' => '2.360579',
			'slug' => null,
			'canonical' => 'fisioterapia/cardedeu/fisioterapias-p',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => 'b6be25713db847e99bdc9b22cb578a10',
			'hash_old' => null,
			'deleted' => false,
			'deleterequest' => null,
			'user_id' => null,
			'plan_id' => null,
			'next_plan_id' => null,
			'video' => null,
			'pinterest' => null,
			'googleplus' => null,
			'youtube' => null,
			'linkedin' => null,
			'facebook' => null,
			'twitter' => null,
			'status' => '1',
			'subscription_status' => '0',
			'subscription_id' => '0',
			'population_id' => '4984',
			'bank' => null,
			'bank_cert' => null,
			'bank_cert_dir' => null,
			'bank_cert_status' => null,
			'file_dni' => null,
			'file_dni_dir' => null,
			'writers' => null,
			'writers_dir' => null,
			'split_id' => null,
			'created' => '2017-10-02 10:04:01',
			'modified' => '2018-07-10 20:03:31',
			'sms' => null,
			'fulladdress' => 'Carrer Barangé, 18, Cardedeu ( 08440 ) , Barcelona',
			'link' => 'https://www.fisiosite.com/fisioterapia/cardedeu/fisioterapias-p',
			'path_cert' => '/var/www/fisiosite.com/webroot//files/establishment/bank_cert//',
			'path_dni' => '/var/www/fisiosite.com/webroot//files/establishment/file_dni//',
			'path_writers' => '/var/www/fisiosite.com/webroot//files/establishment/writers//',
			'rating' => false,
			'is_open' => false
		),
		'Category' => array(
			'id' => '1',
			'name' => 'FISIOTERAPIA',
			'slug' => 'fisioterapia',
			'description' => '',
			'parent_id' => '31',
			'created' => '2016-06-13 12:15:16',
			'modified' => '2016-06-13 12:15:16',
			'lft' => '2',
			'rght' => '3'
		),
		'EstablishmentsCategory' => array(
			'id' => null,
			'establishment_id' => null,
			'category_id' => null,
			'created' => null,
			'modified' => null
		),
		'Service' => array(),
		'Slide' => array(
			'id' => null,
			'model' => null,
			'foreign_key' => null,
			'name' => null,
			'attachment' => null,
			'dir' => null,
			'type' => null,
			'size' => null,
			'active' => null
		),
		(int) 0 => array(
			'have_date' => '0'
		),
		'Comment' => array(),
		'Staff' => array(),
		'Slots' => array()
	),
	(int) 3 => array(
		'Establishment' => array(
			'id' => '10394',
			'name' => 'Carles Sunyer Oller',
			'category_id' => '1',
			'establishment_type' => '1',
			'image' => null,
			'image_dir' => null,
			'web' => '',
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => null,
			'address1' => 'Carrer Llinars, 68',
			'address2' => '',
			'email' => '',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '938 44 46 67',
			'phone2' => '',
			'zipcode' => '08440',
			'town' => 'Cardedeu',
			'state' => 'Barcelona',
			'country' => 'España',
			'latitude' => '41.637371',
			'longitude' => '2.362430',
			'slug' => null,
			'canonical' => 'fisioterapia/cardedeu/carles-sunyer-oller',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => 'af7d084353ad76401075c68c027f56ee',
			'hash_old' => null,
			'deleted' => false,
			'deleterequest' => null,
			'user_id' => null,
			'plan_id' => null,
			'next_plan_id' => null,
			'video' => null,
			'pinterest' => null,
			'googleplus' => null,
			'youtube' => null,
			'linkedin' => null,
			'facebook' => null,
			'twitter' => null,
			'status' => '1',
			'subscription_status' => '0',
			'subscription_id' => '0',
			'population_id' => '4984',
			'bank' => null,
			'bank_cert' => null,
			'bank_cert_dir' => null,
			'bank_cert_status' => null,
			'file_dni' => null,
			'file_dni_dir' => null,
			'writers' => null,
			'writers_dir' => null,
			'split_id' => null,
			'created' => '2017-10-02 10:04:06',
			'modified' => '2018-07-10 20:03:31',
			'sms' => null,
			'fulladdress' => 'Carrer Llinars, 68, Cardedeu ( 08440 ) , Barcelona',
			'link' => 'https://www.fisiosite.com/fisioterapia/cardedeu/carles-sunyer-oller',
			'path_cert' => '/var/www/fisiosite.com/webroot//files/establishment/bank_cert//',
			'path_dni' => '/var/www/fisiosite.com/webroot//files/establishment/file_dni//',
			'path_writers' => '/var/www/fisiosite.com/webroot//files/establishment/writers//',
			'rating' => false,
			'is_open' => false
		),
		'Category' => array(
			'id' => '1',
			'name' => 'FISIOTERAPIA',
			'slug' => 'fisioterapia',
			'description' => '',
			'parent_id' => '31',
			'created' => '2016-06-13 12:15:16',
			'modified' => '2016-06-13 12:15:16',
			'lft' => '2',
			'rght' => '3'
		),
		'EstablishmentsCategory' => array(
			'id' => null,
			'establishment_id' => null,
			'category_id' => null,
			'created' => null,
			'modified' => null
		),
		'Service' => array(),
		'Slide' => array(
			'id' => null,
			'model' => null,
			'foreign_key' => null,
			'name' => null,
			'attachment' => null,
			'dir' => null,
			'type' => null,
			'size' => null,
			'active' => null
		),
		(int) 0 => array(
			'have_date' => '0'
		),
		'Comment' => array(),
		'Staff' => array(),
		'Slots' => array()
	),
	(int) 4 => array(
		'Establishment' => array(
			'id' => '10395',
			'name' => 'Homefisio Cardedeu',
			'category_id' => '1',
			'establishment_type' => '1',
			'image' => null,
			'image_dir' => null,
			'web' => 'http://homeofisiocardedeu.blogspot.com.es',
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => null,
			'address1' => 'C/Cervantes, 17',
			'address2' => '',
			'email' => '',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '627 909 953',
			'phone2' => '610 607 185',
			'zipcode' => '08440',
			'town' => 'Cardedeu',
			'state' => 'Barcelona',
			'country' => 'España',
			'latitude' => '41.640320',
			'longitude' => '2.356590',
			'slug' => null,
			'canonical' => 'fisioterapia/cardedeu/homefisio-cardedeu',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => '744778f8fc1c9f1398d5190f0fc97b93',
			'hash_old' => null,
			'deleted' => false,
			'deleterequest' => null,
			'user_id' => null,
			'plan_id' => null,
			'next_plan_id' => null,
			'video' => null,
			'pinterest' => null,
			'googleplus' => null,
			'youtube' => null,
			'linkedin' => null,
			'facebook' => null,
			'twitter' => null,
			'status' => '1',
			'subscription_status' => '0',
			'subscription_id' => '0',
			'population_id' => '4984',
			'bank' => null,
			'bank_cert' => null,
			'bank_cert_dir' => null,
			'bank_cert_status' => null,
			'file_dni' => null,
			'file_dni_dir' => null,
			'writers' => null,
			'writers_dir' => null,
			'split_id' => null,
			'created' => '2017-10-02 10:04:09',
			'modified' => '2018-07-10 20:03:31',
			'sms' => null,
			'fulladdress' => 'C/Cervantes, 17, Cardedeu ( 08440 ) , Barcelona',
			'link' => 'https://www.fisiosite.com/fisioterapia/cardedeu/homefisio-cardedeu',
			'path_cert' => '/var/www/fisiosite.com/webroot//files/establishment/bank_cert//',
			'path_dni' => '/var/www/fisiosite.com/webroot//files/establishment/file_dni//',
			'path_writers' => '/var/www/fisiosite.com/webroot//files/establishment/writers//'
		),
		'Category' => array(
			'id' => '1',
			'name' => 'FISIOTERAPIA',
			'slug' => 'fisioterapia',
			'description' => '',
			'parent_id' => '31',
			'created' => '2016-06-13 12:15:16',
			'modified' => '2016-06-13 12:15:16',
			'lft' => '2',
			'rght' => '3'
		),
		'EstablishmentsCategory' => array(
			'id' => null,
			'establishment_id' => null,
			'category_id' => null,
			'created' => null,
			'modified' => null
		),
		'Service' => array(
			'id' => null,
			'name' => null,
			'description' => null,
			'duration_reserved' => null,
			'duration' => null,
			'price' => null,
			'slots' => null,
			'pay_online' => null,
			'establishment_id' => null,
			'created_status' => null,
			'tag' => null,
			'created' => null,
			'modified' => null
		),
		'Slide' => array(
			'id' => null,
			'model' => null,
			'foreign_key' => null,
			'name' => null,
			'attachment' => null,
			'dir' => null,
			'type' => null,
			'size' => null,
			'active' => null
		),
		(int) 0 => array(
			'have_date' => '0'
		),
		'Comment' => array(),
		'Staff' => array()
	),
	(int) 5 => array(
		'Establishment' => array(
			'id' => '10396',
			'name' => 'Onco Cardedeu-Baix Montseny',
			'category_id' => '30',
			'establishment_type' => '1',
			'image' => null,
			'image_dir' => null,
			'web' => 'http://www.oncocardedeu.cat/',
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => null,
			'address1' => 'Àngel Guimera 144',
			'address2' => '',
			'email' => 'oncocardedeu@gmail.com',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '660 45 48 54',
			'phone2' => '',
			'zipcode' => '08440',
			'town' => 'Cardedeu',
			'state' => 'Barcelona',
			'country' => 'España',
			'latitude' => '41.640781',
			'longitude' => '2.359496',
			'slug' => null,
			'canonical' => 'fisioterapia-oncologica/cardedeu/onco-cardedeu-baix-montseny',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => '8ac8b548d4762d75da965be01850bc40',
			'hash_old' => null,
			'deleted' => false,
			'deleterequest' => null,
			'user_id' => null,
			'plan_id' => null,
			'next_plan_id' => null,
			'video' => null,
			'pinterest' => null,
			'googleplus' => null,
			'youtube' => null,
			'linkedin' => null,
			'facebook' => null,
			'twitter' => null,
			'status' => '1',
			'subscription_status' => '0',
			'subscription_id' => '0',
			'population_id' => '4984',
			'bank' => null,
			'bank_cert' => null,
			'bank_cert_dir' => null,
			'bank_cert_status' => null,
			'file_dni' => null,
			'file_dni_dir' => null,
			'writers' => null,
			'writers_dir' => null,
			'split_id' => null,
			'created' => '2017-10-02 10:04:13',
			'modified' => '2018-07-10 20:03:31',
			'sms' => null,
			'fulladdress' => 'Àngel Guimera 144, Cardedeu ( 08440 ) , Barcelona',
			'link' => 'https://www.fisiosite.com/fisioterapia-oncologica/cardedeu/onco-cardedeu-baix-montseny',
			'path_cert' => '/var/www/fisiosite.com/webroot//files/establishment/bank_cert//',
			'path_dni' => '/var/www/fisiosite.com/webroot//files/establishment/file_dni//',
			'path_writers' => '/var/www/fisiosite.com/webroot//files/establishment/writers//'
		),
		'Category' => array(
			'id' => '30',
			'name' => 'FISIOTERAPIA ONCOLOGICA',
			'slug' => 'fisioterapia-oncologica',
			'description' => '',
			'parent_id' => '1',
			'created' => '2016-06-13 12:15:17',
			'modified' => '2016-06-13 12:15:17',
			'lft' => '58',
			'rght' => '59'
		),
		'EstablishmentsCategory' => array(
			'id' => null,
			'establishment_id' => null,
			'category_id' => null,
			'created' => null,
			'modified' => null
		),
		'Service' => array(
			'id' => null,
			'name' => null,
			'description' => null,
			'duration_reserved' => null,
			'duration' => null,
			'price' => null,
			'slots' => null,
			'pay_online' => null,
			'establishment_id' => null,
			'created_status' => null,
			'tag' => null,
			'created' => null,
			'modified' => null
		),
		'Slide' => array(
			'id' => null,
			'model' => null,
			'foreign_key' => null,
			'name' => null,
			'attachment' => null,
			'dir' => null,
			'type' => null,
			'size' => null,
			'active' => null
		),
		(int) 0 => array(
			'have_date' => '0'
		),
		'Comment' => array(),
		'Staff' => array()
	),
	(int) 6 => array(
		'Establishment' => array(
			'id' => '10397',
			'name' => 'Núria López.',
			'category_id' => '1',
			'establishment_type' => '1',
			'image' => null,
			'image_dir' => null,
			'web' => '',
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => null,
			'address1' => 'Àngel Guimerà, 21',
			'address2' => '2n 1a',
			'email' => '',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '647 24 53 83',
			'phone2' => '',
			'zipcode' => '08440',
			'town' => 'Cardedeu',
			'state' => 'Barcelona',
			'country' => 'España',
			'latitude' => '41.637615',
			'longitude' => '2.359355',
			'slug' => null,
			'canonical' => 'fisioterapia/cardedeu/nuria-lopez',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => '7a7e0eecf51ea82b78030008aab2eaa8',
			'hash_old' => null,
			'deleted' => false,
			'deleterequest' => null,
			'user_id' => null,
			'plan_id' => null,
			'next_plan_id' => null,
			'video' => null,
			'pinterest' => null,
			'googleplus' => null,
			'youtube' => null,
			'linkedin' => null,
			'facebook' => null,
			'twitter' => null,
			'status' => '1',
			'subscription_status' => '0',
			'subscription_id' => '0',
			'population_id' => '4984',
			'bank' => null,
			'bank_cert' => null,
			'bank_cert_dir' => null,
			'bank_cert_status' => null,
			'file_dni' => null,
			'file_dni_dir' => null,
			'writers' => null,
			'writers_dir' => null,
			'split_id' => null,
			'created' => '2017-10-02 10:04:15',
			'modified' => '2018-07-10 20:03:32',
			'sms' => null,
			'fulladdress' => 'Àngel Guimerà, 21, Cardedeu ( 08440 ) , Barcelona',
			'link' => 'https://www.fisiosite.com/fisioterapia/cardedeu/nuria-lopez',
			'path_cert' => '/var/www/fisiosite.com/webroot//files/establishment/bank_cert//',
			'path_dni' => '/var/www/fisiosite.com/webroot//files/establishment/file_dni//',
			'path_writers' => '/var/www/fisiosite.com/webroot//files/establishment/writers//'
		),
		'Category' => array(
			'id' => '1',
			'name' => 'FISIOTERAPIA',
			'slug' => 'fisioterapia',
			'description' => '',
			'parent_id' => '31',
			'created' => '2016-06-13 12:15:16',
			'modified' => '2016-06-13 12:15:16',
			'lft' => '2',
			'rght' => '3'
		),
		'EstablishmentsCategory' => array(
			'id' => null,
			'establishment_id' => null,
			'category_id' => null,
			'created' => null,
			'modified' => null
		),
		'Service' => array(
			'id' => null,
			'name' => null,
			'description' => null,
			'duration_reserved' => null,
			'duration' => null,
			'price' => null,
			'slots' => null,
			'pay_online' => null,
			'establishment_id' => null,
			'created_status' => null,
			'tag' => null,
			'created' => null,
			'modified' => null
		),
		'Slide' => array(
			'id' => null,
			'model' => null,
			'foreign_key' => null,
			'name' => null,
			'attachment' => null,
			'dir' => null,
			'type' => null,
			'size' => null,
			'active' => null
		),
		(int) 0 => array(
			'have_date' => '0'
		),
		'Comment' => array(),
		'Staff' => array()
	),
	(int) 7 => array(
		'Establishment' => array(
			'id' => '10398',
			'name' => 'Eloi Anson Nebot',
			'category_id' => '14',
			'establishment_type' => '1',
			'image' => null,
			'image_dir' => null,
			'web' => '',
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => null,
			'address1' => 'Josep Vilaseca, 18',
			'address2' => 'Y 20',
			'email' => '',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '938477485',
			'phone2' => '',
			'zipcode' => '08440',
			'town' => 'Cardedeu',
			'state' => 'Barcelona',
			'country' => 'España',
			'latitude' => '41.638237',
			'longitude' => '2.354416',
			'slug' => null,
			'canonical' => 'osteopatia/cardedeu/eloi-anson-nebot',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => '7f10e9fdb02cc235b4f1214e4bb4a238',
			'hash_old' => null,
			'deleted' => false,
			'deleterequest' => null,
			'user_id' => null,
			'plan_id' => null,
			'next_plan_id' => null,
			'video' => null,
			'pinterest' => null,
			'googleplus' => null,
			'youtube' => null,
			'linkedin' => null,
			'facebook' => null,
			'twitter' => null,
			'status' => '1',
			'subscription_status' => '0',
			'subscription_id' => '0',
			'population_id' => '4984',
			'bank' => null,
			'bank_cert' => null,
			'bank_cert_dir' => null,
			'bank_cert_status' => null,
			'file_dni' => null,
			'file_dni_dir' => null,
			'writers' => null,
			'writers_dir' => null,
			'split_id' => null,
			'created' => '2017-10-02 10:04:17',
			'modified' => '2018-07-10 20:03:32',
			'sms' => null,
			'fulladdress' => 'Josep Vilaseca, 18, Cardedeu ( 08440 ) , Barcelona',
			'link' => 'https://www.fisiosite.com/osteopatia/cardedeu/eloi-anson-nebot',
			'path_cert' => '/var/www/fisiosite.com/webroot//files/establishment/bank_cert//',
			'path_dni' => '/var/www/fisiosite.com/webroot//files/establishment/file_dni//',
			'path_writers' => '/var/www/fisiosite.com/webroot//files/establishment/writers//'
		),
		'Category' => array(
			'id' => '14',
			'name' => 'OSTEOPATIA',
			'slug' => 'osteopatia',
			'description' => '',
			'parent_id' => '1',
			'created' => '2016-06-13 12:15:16',
			'modified' => '2016-06-13 12:15:16',
			'lft' => '26',
			'rght' => '27'
		),
		'EstablishmentsCategory' => array(
			'id' => null,
			'establishment_id' => null,
			'category_id' => null,
			'created' => null,
			'modified' => null
		),
		'Service' => array(
			'id' => null,
			'name' => null,
			'description' => null,
			'duration_reserved' => null,
			'duration' => null,
			'price' => null,
			'slots' => null,
			'pay_online' => null,
			'establishment_id' => null,
			'created_status' => null,
			'tag' => null,
			'created' => null,
			'modified' => null
		),
		'Slide' => array(
			'id' => null,
			'model' => null,
			'foreign_key' => null,
			'name' => null,
			'attachment' => null,
			'dir' => null,
			'type' => null,
			'size' => null,
			'active' => null
		),
		(int) 0 => array(
			'have_date' => '0'
		),
		'Comment' => array(),
		'Staff' => array()
	)
)
$n_establishments = (int) 8
$e = array(
	'Establishment' => array(
		'id' => '10394',
		'name' => 'Carles Sunyer Oller',
		'category_id' => '1',
		'establishment_type' => '1',
		'image' => null,
		'image_dir' => null,
		'web' => '',
		'short_description' => null,
		'description' => null,
		'fiscalnumber' => null,
		'address1' => 'Carrer Llinars, 68',
		'address2' => '',
		'email' => '',
		'fax' => null,
		'mobile' => '',
		'mobile2' => '',
		'phone' => '938 44 46 67',
		'phone2' => '',
		'zipcode' => '08440',
		'town' => 'Cardedeu',
		'state' => 'Barcelona',
		'country' => 'España',
		'latitude' => '41.637371',
		'longitude' => '2.362430',
		'slug' => null,
		'canonical' => 'fisioterapia/cardedeu/carles-sunyer-oller',
		'canonical_old' => null,
		'timetable' => null,
		'hash' => 'af7d084353ad76401075c68c027f56ee',
		'hash_old' => null,
		'deleted' => false,
		'deleterequest' => null,
		'user_id' => null,
		'plan_id' => null,
		'next_plan_id' => null,
		'video' => null,
		'pinterest' => null,
		'googleplus' => null,
		'youtube' => null,
		'linkedin' => null,
		'facebook' => null,
		'twitter' => null,
		'status' => '1',
		'subscription_status' => '0',
		'subscription_id' => '0',
		'population_id' => '4984',
		'bank' => null,
		'bank_cert' => null,
		'bank_cert_dir' => null,
		'bank_cert_status' => null,
		'file_dni' => null,
		'file_dni_dir' => null,
		'writers' => null,
		'writers_dir' => null,
		'split_id' => null,
		'created' => '2017-10-02 10:04:06',
		'modified' => '2018-07-10 20:03:31',
		'sms' => null,
		'fulladdress' => 'Carrer Llinars, 68, Cardedeu ( 08440 ) , Barcelona',
		'link' => 'https://www.fisiosite.com/fisioterapia/cardedeu/carles-sunyer-oller',
		'path_cert' => '/var/www/fisiosite.com/webroot//files/establishment/bank_cert//',
		'path_dni' => '/var/www/fisiosite.com/webroot//files/establishment/file_dni//',
		'path_writers' => '/var/www/fisiosite.com/webroot//files/establishment/writers//'
	),
	'Category' => array(
		'id' => '1',
		'name' => 'FISIOTERAPIA',
		'slug' => 'fisioterapia',
		'description' => '',
		'parent_id' => '31',
		'created' => '2016-06-13 12:15:16',
		'modified' => '2016-06-13 12:15:16',
		'lft' => '2',
		'rght' => '3'
	),
	'EstablishmentsCategory' => array(
		'id' => null,
		'establishment_id' => null,
		'category_id' => null,
		'created' => null,
		'modified' => null
	),
	'Service' => array(
		'id' => null,
		'name' => null,
		'description' => null,
		'duration_reserved' => null,
		'duration' => null,
		'price' => null,
		'slots' => null,
		'pay_online' => null,
		'establishment_id' => null,
		'created_status' => null,
		'tag' => null,
		'created' => null,
		'modified' => null
	),
	'Slide' => array(
		'id' => null,
		'model' => null,
		'foreign_key' => null,
		'name' => null,
		'attachment' => null,
		'dir' => null,
		'type' => null,
		'size' => null,
		'active' => null
	),
	(int) 0 => array(
		'have_date' => '0'
	),
	'Comment' => array(),
	'Staff' => array()
)
$comments = array()
SearchController::search_establishments() - APP/Controller/SearchController.php, line 957
SearchController::query() - APP/Controller/SearchController.php, line 1041
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - APP/Vendor/cakephp/cakephp/lib/Cake/Controller/Controller.php, line 490
Dispatcher::_invoke() - APP/Vendor/cakephp/cakephp/lib/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - APP/Vendor/cakephp/cakephp/lib/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 133

Notice (8): Undefined variable: establishment [APP/Controller/SearchController.php, line 957]
Code Context

            // Quitamos los serficios que no tienen profesionales asignados
            if ($establishment[$key]['Service']) {
$page = (int) 1
$date_slot = ''
$conditions = array(
	'Establishment.population_id' => '4984'
)
$query_establishments = array(
	'Establishment.population_id' => '4984'
)
$key = (int) 4
$value = '4984'
$conditions_price = ''
$day = false
$datetotime = false
$hour = false
$index_dates = false
$fields = '*, IF (Establishment.id in (	select s.establishment_id from
                (select * from services where price > 0) s
                inner join timetables t on t.object='Service' and t.object_id = s.id
                inner join establishments e on s.establishment_id = e.id and plan_id > 0
                inner join timetables te on te.object='Establishment' and te.object_id = e.id
                inner join services_staffs st on st.service_id = s.id
                  inner join staffs on staffs.id = st.staff_id
                  inner join services_staffs stst on stst.staff_id = st.staff_id
                  inner join timetables s_t on s_t.object='Staff' and s_t.object_id = staffs.id
                ),1,0) as have_date '
$field = 'page'
$order = array(
	'have_date' => 'desc',
	'plan_id' => 'desc'
)
$establishments = array(
	(int) 0 => array(
		'Establishment' => array(
			'id' => '1968',
			'name' => 'FISIOTERAPIAS, SCP',
			'category_id' => '1',
			'establishment_type' => '1',
			'image' => null,
			'image_dir' => null,
			'web' => null,
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => '',
			'address1' => 'Carrer Esteve Barange, 18',
			'address2' => '',
			'email' => null,
			'fax' => null,
			'mobile' => '',
			'mobile2' => null,
			'phone' => '938713748',
			'phone2' => null,
			'zipcode' => '08440',
			'town' => 'Cardedeu',
			'state' => 'Barcelona',
			'country' => 'España',
			'latitude' => '41.638924',
			'longitude' => '2.360464',
			'slug' => 'fisioterapias-scp-carrer-esteve-barange',
			'canonical' => 'fisioterapia/cardedeu/fisioterapias-scp',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => '0d5bb5358202b889c58eb5b7ac767239',
			'hash_old' => null,
			'deleted' => false,
			'deleterequest' => null,
			'user_id' => null,
			'plan_id' => '1',
			'next_plan_id' => null,
			'video' => null,
			'pinterest' => null,
			'googleplus' => null,
			'youtube' => null,
			'linkedin' => null,
			'facebook' => null,
			'twitter' => null,
			'status' => '1',
			'subscription_status' => '0',
			'subscription_id' => '0',
			'population_id' => '4984',
			'bank' => null,
			'bank_cert' => null,
			'bank_cert_dir' => null,
			'bank_cert_status' => null,
			'file_dni' => null,
			'file_dni_dir' => null,
			'writers' => null,
			'writers_dir' => null,
			'split_id' => null,
			'created' => '2016-07-07 13:12:19',
			'modified' => '2018-07-10 19:41:49',
			'sms' => null,
			'fulladdress' => 'Carrer Esteve Barange, 18, Cardedeu ( 08440 ) , Barcelona',
			'link' => 'https://www.fisiosite.com/fisioterapia/cardedeu/fisioterapias-scp',
			'path_cert' => '/var/www/fisiosite.com/webroot//files/establishment/bank_cert//',
			'path_dni' => '/var/www/fisiosite.com/webroot//files/establishment/file_dni//',
			'path_writers' => '/var/www/fisiosite.com/webroot//files/establishment/writers//',
			'rating' => false,
			'is_open' => false
		),
		'Category' => array(
			'id' => '1',
			'name' => 'FISIOTERAPIA',
			'slug' => 'fisioterapia',
			'description' => '',
			'parent_id' => '31',
			'created' => '2016-06-13 12:15:16',
			'modified' => '2016-06-13 12:15:16',
			'lft' => '2',
			'rght' => '3'
		),
		'EstablishmentsCategory' => array(
			'id' => null,
			'establishment_id' => null,
			'category_id' => null,
			'created' => null,
			'modified' => null
		),
		'Service' => array(),
		'Slide' => array(
			'id' => null,
			'model' => null,
			'foreign_key' => null,
			'name' => null,
			'attachment' => null,
			'dir' => null,
			'type' => null,
			'size' => null,
			'active' => null
		),
		(int) 0 => array(
			'have_date' => '0'
		),
		'Comment' => array(),
		'Staff' => array(),
		'Slots' => array()
	),
	(int) 1 => array(
		'Establishment' => array(
			'id' => '12555',
			'name' => 'lea',
			'category_id' => '1',
			'establishment_type' => '3',
			'image' => null,
			'image_dir' => null,
			'web' => '',
			'short_description' => null,
			'description' => 'Tractaments de pluripatologies.',
			'fiscalnumber' => '43432994r',
			'address1' => 'calle st josep oriol',
			'address2' => '',
			'email' => 'leabcn@yahoo.es',
			'fax' => null,
			'mobile' => '',
			'mobile2' => null,
			'phone' => '',
			'phone2' => '619565893',
			'zipcode' => '08440',
			'town' => 'Cardedeu',
			'state' => 'Barcelona',
			'country' => '',
			'latitude' => null,
			'longitude' => null,
			'slug' => null,
			'canonical' => 'fisioterapia/cardedeu/lea',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => '8ed820be12be334e66d731218a3ad0fc',
			'hash_old' => null,
			'deleted' => false,
			'deleterequest' => null,
			'user_id' => '5f7ce9fa-5d5c-4e8f-be6e-694e335b89d7',
			'plan_id' => '1',
			'next_plan_id' => null,
			'video' => null,
			'pinterest' => null,
			'googleplus' => null,
			'youtube' => null,
			'linkedin' => null,
			'facebook' => null,
			'twitter' => null,
			'status' => '1',
			'subscription_status' => null,
			'subscription_id' => null,
			'population_id' => '4984',
			'bank' => '',
			'bank_cert' => null,
			'bank_cert_dir' => null,
			'bank_cert_status' => null,
			'file_dni' => null,
			'file_dni_dir' => null,
			'writers' => null,
			'writers_dir' => null,
			'split_id' => null,
			'created' => '2020-10-07 00:12:45',
			'modified' => '2020-10-07 09:59:50',
			'sms' => null,
			'fulladdress' => 'calle st josep oriol, Cardedeu ( 08440 ) , Barcelona',
			'link' => 'https://www.fisiosite.com/fisioterapia/cardedeu/lea',
			'path_cert' => '/var/www/fisiosite.com/webroot//files/establishment/bank_cert//',
			'path_dni' => '/var/www/fisiosite.com/webroot//files/establishment/file_dni//',
			'path_writers' => '/var/www/fisiosite.com/webroot//files/establishment/writers//',
			'rating' => false,
			'is_open' => false
		),
		'Category' => array(
			'id' => '1',
			'name' => 'FISIOTERAPIA',
			'slug' => 'fisioterapia',
			'description' => '',
			'parent_id' => '31',
			'created' => '2016-06-13 12:15:16',
			'modified' => '2016-06-13 12:15:16',
			'lft' => '2',
			'rght' => '3'
		),
		'EstablishmentsCategory' => array(
			'id' => null,
			'establishment_id' => null,
			'category_id' => null,
			'created' => null,
			'modified' => null
		),
		'Service' => array(),
		'Slide' => array(
			'id' => null,
			'model' => null,
			'foreign_key' => null,
			'name' => null,
			'attachment' => null,
			'dir' => null,
			'type' => null,
			'size' => null,
			'active' => null
		),
		(int) 0 => array(
			'have_date' => '0'
		),
		'Comment' => array(),
		'Staff' => array(),
		'Slots' => array()
	),
	(int) 2 => array(
		'Establishment' => array(
			'id' => '10393',
			'name' => 'Fisioterapias P',
			'category_id' => '1',
			'establishment_type' => '1',
			'image' => null,
			'image_dir' => null,
			'web' => '',
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => null,
			'address1' => 'Carrer Barangé, 18',
			'address2' => '',
			'email' => '',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '938 71 37 48',
			'phone2' => '',
			'zipcode' => '08440',
			'town' => 'Cardedeu',
			'state' => 'Barcelona',
			'country' => 'España',
			'latitude' => '41.638866',
			'longitude' => '2.360579',
			'slug' => null,
			'canonical' => 'fisioterapia/cardedeu/fisioterapias-p',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => 'b6be25713db847e99bdc9b22cb578a10',
			'hash_old' => null,
			'deleted' => false,
			'deleterequest' => null,
			'user_id' => null,
			'plan_id' => null,
			'next_plan_id' => null,
			'video' => null,
			'pinterest' => null,
			'googleplus' => null,
			'youtube' => null,
			'linkedin' => null,
			'facebook' => null,
			'twitter' => null,
			'status' => '1',
			'subscription_status' => '0',
			'subscription_id' => '0',
			'population_id' => '4984',
			'bank' => null,
			'bank_cert' => null,
			'bank_cert_dir' => null,
			'bank_cert_status' => null,
			'file_dni' => null,
			'file_dni_dir' => null,
			'writers' => null,
			'writers_dir' => null,
			'split_id' => null,
			'created' => '2017-10-02 10:04:01',
			'modified' => '2018-07-10 20:03:31',
			'sms' => null,
			'fulladdress' => 'Carrer Barangé, 18, Cardedeu ( 08440 ) , Barcelona',
			'link' => 'https://www.fisiosite.com/fisioterapia/cardedeu/fisioterapias-p',
			'path_cert' => '/var/www/fisiosite.com/webroot//files/establishment/bank_cert//',
			'path_dni' => '/var/www/fisiosite.com/webroot//files/establishment/file_dni//',
			'path_writers' => '/var/www/fisiosite.com/webroot//files/establishment/writers//',
			'rating' => false,
			'is_open' => false
		),
		'Category' => array(
			'id' => '1',
			'name' => 'FISIOTERAPIA',
			'slug' => 'fisioterapia',
			'description' => '',
			'parent_id' => '31',
			'created' => '2016-06-13 12:15:16',
			'modified' => '2016-06-13 12:15:16',
			'lft' => '2',
			'rght' => '3'
		),
		'EstablishmentsCategory' => array(
			'id' => null,
			'establishment_id' => null,
			'category_id' => null,
			'created' => null,
			'modified' => null
		),
		'Service' => array(),
		'Slide' => array(
			'id' => null,
			'model' => null,
			'foreign_key' => null,
			'name' => null,
			'attachment' => null,
			'dir' => null,
			'type' => null,
			'size' => null,
			'active' => null
		),
		(int) 0 => array(
			'have_date' => '0'
		),
		'Comment' => array(),
		'Staff' => array(),
		'Slots' => array()
	),
	(int) 3 => array(
		'Establishment' => array(
			'id' => '10394',
			'name' => 'Carles Sunyer Oller',
			'category_id' => '1',
			'establishment_type' => '1',
			'image' => null,
			'image_dir' => null,
			'web' => '',
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => null,
			'address1' => 'Carrer Llinars, 68',
			'address2' => '',
			'email' => '',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '938 44 46 67',
			'phone2' => '',
			'zipcode' => '08440',
			'town' => 'Cardedeu',
			'state' => 'Barcelona',
			'country' => 'España',
			'latitude' => '41.637371',
			'longitude' => '2.362430',
			'slug' => null,
			'canonical' => 'fisioterapia/cardedeu/carles-sunyer-oller',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => 'af7d084353ad76401075c68c027f56ee',
			'hash_old' => null,
			'deleted' => false,
			'deleterequest' => null,
			'user_id' => null,
			'plan_id' => null,
			'next_plan_id' => null,
			'video' => null,
			'pinterest' => null,
			'googleplus' => null,
			'youtube' => null,
			'linkedin' => null,
			'facebook' => null,
			'twitter' => null,
			'status' => '1',
			'subscription_status' => '0',
			'subscription_id' => '0',
			'population_id' => '4984',
			'bank' => null,
			'bank_cert' => null,
			'bank_cert_dir' => null,
			'bank_cert_status' => null,
			'file_dni' => null,
			'file_dni_dir' => null,
			'writers' => null,
			'writers_dir' => null,
			'split_id' => null,
			'created' => '2017-10-02 10:04:06',
			'modified' => '2018-07-10 20:03:31',
			'sms' => null,
			'fulladdress' => 'Carrer Llinars, 68, Cardedeu ( 08440 ) , Barcelona',
			'link' => 'https://www.fisiosite.com/fisioterapia/cardedeu/carles-sunyer-oller',
			'path_cert' => '/var/www/fisiosite.com/webroot//files/establishment/bank_cert//',
			'path_dni' => '/var/www/fisiosite.com/webroot//files/establishment/file_dni//',
			'path_writers' => '/var/www/fisiosite.com/webroot//files/establishment/writers//',
			'rating' => false,
			'is_open' => false
		),
		'Category' => array(
			'id' => '1',
			'name' => 'FISIOTERAPIA',
			'slug' => 'fisioterapia',
			'description' => '',
			'parent_id' => '31',
			'created' => '2016-06-13 12:15:16',
			'modified' => '2016-06-13 12:15:16',
			'lft' => '2',
			'rght' => '3'
		),
		'EstablishmentsCategory' => array(
			'id' => null,
			'establishment_id' => null,
			'category_id' => null,
			'created' => null,
			'modified' => null
		),
		'Service' => array(),
		'Slide' => array(
			'id' => null,
			'model' => null,
			'foreign_key' => null,
			'name' => null,
			'attachment' => null,
			'dir' => null,
			'type' => null,
			'size' => null,
			'active' => null
		),
		(int) 0 => array(
			'have_date' => '0'
		),
		'Comment' => array(),
		'Staff' => array(),
		'Slots' => array()
	),
	(int) 4 => array(
		'Establishment' => array(
			'id' => '10395',
			'name' => 'Homefisio Cardedeu',
			'category_id' => '1',
			'establishment_type' => '1',
			'image' => null,
			'image_dir' => null,
			'web' => 'http://homeofisiocardedeu.blogspot.com.es',
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => null,
			'address1' => 'C/Cervantes, 17',
			'address2' => '',
			'email' => '',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '627 909 953',
			'phone2' => '610 607 185',
			'zipcode' => '08440',
			'town' => 'Cardedeu',
			'state' => 'Barcelona',
			'country' => 'España',
			'latitude' => '41.640320',
			'longitude' => '2.356590',
			'slug' => null,
			'canonical' => 'fisioterapia/cardedeu/homefisio-cardedeu',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => '744778f8fc1c9f1398d5190f0fc97b93',
			'hash_old' => null,
			'deleted' => false,
			'deleterequest' => null,
			'user_id' => null,
			'plan_id' => null,
			'next_plan_id' => null,
			'video' => null,
			'pinterest' => null,
			'googleplus' => null,
			'youtube' => null,
			'linkedin' => null,
			'facebook' => null,
			'twitter' => null,
			'status' => '1',
			'subscription_status' => '0',
			'subscription_id' => '0',
			'population_id' => '4984',
			'bank' => null,
			'bank_cert' => null,
			'bank_cert_dir' => null,
			'bank_cert_status' => null,
			'file_dni' => null,
			'file_dni_dir' => null,
			'writers' => null,
			'writers_dir' => null,
			'split_id' => null,
			'created' => '2017-10-02 10:04:09',
			'modified' => '2018-07-10 20:03:31',
			'sms' => null,
			'fulladdress' => 'C/Cervantes, 17, Cardedeu ( 08440 ) , Barcelona',
			'link' => 'https://www.fisiosite.com/fisioterapia/cardedeu/homefisio-cardedeu',
			'path_cert' => '/var/www/fisiosite.com/webroot//files/establishment/bank_cert//',
			'path_dni' => '/var/www/fisiosite.com/webroot//files/establishment/file_dni//',
			'path_writers' => '/var/www/fisiosite.com/webroot//files/establishment/writers//',
			'rating' => false,
			'is_open' => false
		),
		'Category' => array(
			'id' => '1',
			'name' => 'FISIOTERAPIA',
			'slug' => 'fisioterapia',
			'description' => '',
			'parent_id' => '31',
			'created' => '2016-06-13 12:15:16',
			'modified' => '2016-06-13 12:15:16',
			'lft' => '2',
			'rght' => '3'
		),
		'EstablishmentsCategory' => array(
			'id' => null,
			'establishment_id' => null,
			'category_id' => null,
			'created' => null,
			'modified' => null
		),
		'Service' => array(),
		'Slide' => array(
			'id' => null,
			'model' => null,
			'foreign_key' => null,
			'name' => null,
			'attachment' => null,
			'dir' => null,
			'type' => null,
			'size' => null,
			'active' => null
		),
		(int) 0 => array(
			'have_date' => '0'
		),
		'Comment' => array(),
		'Staff' => array(),
		'Slots' => array()
	),
	(int) 5 => array(
		'Establishment' => array(
			'id' => '10396',
			'name' => 'Onco Cardedeu-Baix Montseny',
			'category_id' => '30',
			'establishment_type' => '1',
			'image' => null,
			'image_dir' => null,
			'web' => 'http://www.oncocardedeu.cat/',
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => null,
			'address1' => 'Àngel Guimera 144',
			'address2' => '',
			'email' => 'oncocardedeu@gmail.com',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '660 45 48 54',
			'phone2' => '',
			'zipcode' => '08440',
			'town' => 'Cardedeu',
			'state' => 'Barcelona',
			'country' => 'España',
			'latitude' => '41.640781',
			'longitude' => '2.359496',
			'slug' => null,
			'canonical' => 'fisioterapia-oncologica/cardedeu/onco-cardedeu-baix-montseny',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => '8ac8b548d4762d75da965be01850bc40',
			'hash_old' => null,
			'deleted' => false,
			'deleterequest' => null,
			'user_id' => null,
			'plan_id' => null,
			'next_plan_id' => null,
			'video' => null,
			'pinterest' => null,
			'googleplus' => null,
			'youtube' => null,
			'linkedin' => null,
			'facebook' => null,
			'twitter' => null,
			'status' => '1',
			'subscription_status' => '0',
			'subscription_id' => '0',
			'population_id' => '4984',
			'bank' => null,
			'bank_cert' => null,
			'bank_cert_dir' => null,
			'bank_cert_status' => null,
			'file_dni' => null,
			'file_dni_dir' => null,
			'writers' => null,
			'writers_dir' => null,
			'split_id' => null,
			'created' => '2017-10-02 10:04:13',
			'modified' => '2018-07-10 20:03:31',
			'sms' => null,
			'fulladdress' => 'Àngel Guimera 144, Cardedeu ( 08440 ) , Barcelona',
			'link' => 'https://www.fisiosite.com/fisioterapia-oncologica/cardedeu/onco-cardedeu-baix-montseny',
			'path_cert' => '/var/www/fisiosite.com/webroot//files/establishment/bank_cert//',
			'path_dni' => '/var/www/fisiosite.com/webroot//files/establishment/file_dni//',
			'path_writers' => '/var/www/fisiosite.com/webroot//files/establishment/writers//'
		),
		'Category' => array(
			'id' => '30',
			'name' => 'FISIOTERAPIA ONCOLOGICA',
			'slug' => 'fisioterapia-oncologica',
			'description' => '',
			'parent_id' => '1',
			'created' => '2016-06-13 12:15:17',
			'modified' => '2016-06-13 12:15:17',
			'lft' => '58',
			'rght' => '59'
		),
		'EstablishmentsCategory' => array(
			'id' => null,
			'establishment_id' => null,
			'category_id' => null,
			'created' => null,
			'modified' => null
		),
		'Service' => array(
			'id' => null,
			'name' => null,
			'description' => null,
			'duration_reserved' => null,
			'duration' => null,
			'price' => null,
			'slots' => null,
			'pay_online' => null,
			'establishment_id' => null,
			'created_status' => null,
			'tag' => null,
			'created' => null,
			'modified' => null
		),
		'Slide' => array(
			'id' => null,
			'model' => null,
			'foreign_key' => null,
			'name' => null,
			'attachment' => null,
			'dir' => null,
			'type' => null,
			'size' => null,
			'active' => null
		),
		(int) 0 => array(
			'have_date' => '0'
		),
		'Comment' => array(),
		'Staff' => array()
	),
	(int) 6 => array(
		'Establishment' => array(
			'id' => '10397',
			'name' => 'Núria López.',
			'category_id' => '1',
			'establishment_type' => '1',
			'image' => null,
			'image_dir' => null,
			'web' => '',
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => null,
			'address1' => 'Àngel Guimerà, 21',
			'address2' => '2n 1a',
			'email' => '',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '647 24 53 83',
			'phone2' => '',
			'zipcode' => '08440',
			'town' => 'Cardedeu',
			'state' => 'Barcelona',
			'country' => 'España',
			'latitude' => '41.637615',
			'longitude' => '2.359355',
			'slug' => null,
			'canonical' => 'fisioterapia/cardedeu/nuria-lopez',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => '7a7e0eecf51ea82b78030008aab2eaa8',
			'hash_old' => null,
			'deleted' => false,
			'deleterequest' => null,
			'user_id' => null,
			'plan_id' => null,
			'next_plan_id' => null,
			'video' => null,
			'pinterest' => null,
			'googleplus' => null,
			'youtube' => null,
			'linkedin' => null,
			'facebook' => null,
			'twitter' => null,
			'status' => '1',
			'subscription_status' => '0',
			'subscription_id' => '0',
			'population_id' => '4984',
			'bank' => null,
			'bank_cert' => null,
			'bank_cert_dir' => null,
			'bank_cert_status' => null,
			'file_dni' => null,
			'file_dni_dir' => null,
			'writers' => null,
			'writers_dir' => null,
			'split_id' => null,
			'created' => '2017-10-02 10:04:15',
			'modified' => '2018-07-10 20:03:32',
			'sms' => null,
			'fulladdress' => 'Àngel Guimerà, 21, Cardedeu ( 08440 ) , Barcelona',
			'link' => 'https://www.fisiosite.com/fisioterapia/cardedeu/nuria-lopez',
			'path_cert' => '/var/www/fisiosite.com/webroot//files/establishment/bank_cert//',
			'path_dni' => '/var/www/fisiosite.com/webroot//files/establishment/file_dni//',
			'path_writers' => '/var/www/fisiosite.com/webroot//files/establishment/writers//'
		),
		'Category' => array(
			'id' => '1',
			'name' => 'FISIOTERAPIA',
			'slug' => 'fisioterapia',
			'description' => '',
			'parent_id' => '31',
			'created' => '2016-06-13 12:15:16',
			'modified' => '2016-06-13 12:15:16',
			'lft' => '2',
			'rght' => '3'
		),
		'EstablishmentsCategory' => array(
			'id' => null,
			'establishment_id' => null,
			'category_id' => null,
			'created' => null,
			'modified' => null
		),
		'Service' => array(
			'id' => null,
			'name' => null,
			'description' => null,
			'duration_reserved' => null,
			'duration' => null,
			'price' => null,
			'slots' => null,
			'pay_online' => null,
			'establishment_id' => null,
			'created_status' => null,
			'tag' => null,
			'created' => null,
			'modified' => null
		),
		'Slide' => array(
			'id' => null,
			'model' => null,
			'foreign_key' => null,
			'name' => null,
			'attachment' => null,
			'dir' => null,
			'type' => null,
			'size' => null,
			'active' => null
		),
		(int) 0 => array(
			'have_date' => '0'
		),
		'Comment' => array(),
		'Staff' => array()
	),
	(int) 7 => array(
		'Establishment' => array(
			'id' => '10398',
			'name' => 'Eloi Anson Nebot',
			'category_id' => '14',
			'establishment_type' => '1',
			'image' => null,
			'image_dir' => null,
			'web' => '',
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => null,
			'address1' => 'Josep Vilaseca, 18',
			'address2' => 'Y 20',
			'email' => '',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '938477485',
			'phone2' => '',
			'zipcode' => '08440',
			'town' => 'Cardedeu',
			'state' => 'Barcelona',
			'country' => 'España',
			'latitude' => '41.638237',
			'longitude' => '2.354416',
			'slug' => null,
			'canonical' => 'osteopatia/cardedeu/eloi-anson-nebot',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => '7f10e9fdb02cc235b4f1214e4bb4a238',
			'hash_old' => null,
			'deleted' => false,
			'deleterequest' => null,
			'user_id' => null,
			'plan_id' => null,
			'next_plan_id' => null,
			'video' => null,
			'pinterest' => null,
			'googleplus' => null,
			'youtube' => null,
			'linkedin' => null,
			'facebook' => null,
			'twitter' => null,
			'status' => '1',
			'subscription_status' => '0',
			'subscription_id' => '0',
			'population_id' => '4984',
			'bank' => null,
			'bank_cert' => null,
			'bank_cert_dir' => null,
			'bank_cert_status' => null,
			'file_dni' => null,
			'file_dni_dir' => null,
			'writers' => null,
			'writers_dir' => null,
			'split_id' => null,
			'created' => '2017-10-02 10:04:17',
			'modified' => '2018-07-10 20:03:32',
			'sms' => null,
			'fulladdress' => 'Josep Vilaseca, 18, Cardedeu ( 08440 ) , Barcelona',
			'link' => 'https://www.fisiosite.com/osteopatia/cardedeu/eloi-anson-nebot',
			'path_cert' => '/var/www/fisiosite.com/webroot//files/establishment/bank_cert//',
			'path_dni' => '/var/www/fisiosite.com/webroot//files/establishment/file_dni//',
			'path_writers' => '/var/www/fisiosite.com/webroot//files/establishment/writers//'
		),
		'Category' => array(
			'id' => '14',
			'name' => 'OSTEOPATIA',
			'slug' => 'osteopatia',
			'description' => '',
			'parent_id' => '1',
			'created' => '2016-06-13 12:15:16',
			'modified' => '2016-06-13 12:15:16',
			'lft' => '26',
			'rght' => '27'
		),
		'EstablishmentsCategory' => array(
			'id' => null,
			'establishment_id' => null,
			'category_id' => null,
			'created' => null,
			'modified' => null
		),
		'Service' => array(
			'id' => null,
			'name' => null,
			'description' => null,
			'duration_reserved' => null,
			'duration' => null,
			'price' => null,
			'slots' => null,
			'pay_online' => null,
			'establishment_id' => null,
			'created_status' => null,
			'tag' => null,
			'created' => null,
			'modified' => null
		),
		'Slide' => array(
			'id' => null,
			'model' => null,
			'foreign_key' => null,
			'name' => null,
			'attachment' => null,
			'dir' => null,
			'type' => null,
			'size' => null,
			'active' => null
		),
		(int) 0 => array(
			'have_date' => '0'
		),
		'Comment' => array(),
		'Staff' => array()
	)
)
$n_establishments = (int) 8
$e = array(
	'Establishment' => array(
		'id' => '10395',
		'name' => 'Homefisio Cardedeu',
		'category_id' => '1',
		'establishment_type' => '1',
		'image' => null,
		'image_dir' => null,
		'web' => 'http://homeofisiocardedeu.blogspot.com.es',
		'short_description' => null,
		'description' => null,
		'fiscalnumber' => null,
		'address1' => 'C/Cervantes, 17',
		'address2' => '',
		'email' => '',
		'fax' => null,
		'mobile' => '',
		'mobile2' => '',
		'phone' => '627 909 953',
		'phone2' => '610 607 185',
		'zipcode' => '08440',
		'town' => 'Cardedeu',
		'state' => 'Barcelona',
		'country' => 'España',
		'latitude' => '41.640320',
		'longitude' => '2.356590',
		'slug' => null,
		'canonical' => 'fisioterapia/cardedeu/homefisio-cardedeu',
		'canonical_old' => null,
		'timetable' => null,
		'hash' => '744778f8fc1c9f1398d5190f0fc97b93',
		'hash_old' => null,
		'deleted' => false,
		'deleterequest' => null,
		'user_id' => null,
		'plan_id' => null,
		'next_plan_id' => null,
		'video' => null,
		'pinterest' => null,
		'googleplus' => null,
		'youtube' => null,
		'linkedin' => null,
		'facebook' => null,
		'twitter' => null,
		'status' => '1',
		'subscription_status' => '0',
		'subscription_id' => '0',
		'population_id' => '4984',
		'bank' => null,
		'bank_cert' => null,
		'bank_cert_dir' => null,
		'bank_cert_status' => null,
		'file_dni' => null,
		'file_dni_dir' => null,
		'writers' => null,
		'writers_dir' => null,
		'split_id' => null,
		'created' => '2017-10-02 10:04:09',
		'modified' => '2018-07-10 20:03:31',
		'sms' => null,
		'fulladdress' => 'C/Cervantes, 17, Cardedeu ( 08440 ) , Barcelona',
		'link' => 'https://www.fisiosite.com/fisioterapia/cardedeu/homefisio-cardedeu',
		'path_cert' => '/var/www/fisiosite.com/webroot//files/establishment/bank_cert//',
		'path_dni' => '/var/www/fisiosite.com/webroot//files/establishment/file_dni//',
		'path_writers' => '/var/www/fisiosite.com/webroot//files/establishment/writers//'
	),
	'Category' => array(
		'id' => '1',
		'name' => 'FISIOTERAPIA',
		'slug' => 'fisioterapia',
		'description' => '',
		'parent_id' => '31',
		'created' => '2016-06-13 12:15:16',
		'modified' => '2016-06-13 12:15:16',
		'lft' => '2',
		'rght' => '3'
	),
	'EstablishmentsCategory' => array(
		'id' => null,
		'establishment_id' => null,
		'category_id' => null,
		'created' => null,
		'modified' => null
	),
	'Service' => array(
		'id' => null,
		'name' => null,
		'description' => null,
		'duration_reserved' => null,
		'duration' => null,
		'price' => null,
		'slots' => null,
		'pay_online' => null,
		'establishment_id' => null,
		'created_status' => null,
		'tag' => null,
		'created' => null,
		'modified' => null
	),
	'Slide' => array(
		'id' => null,
		'model' => null,
		'foreign_key' => null,
		'name' => null,
		'attachment' => null,
		'dir' => null,
		'type' => null,
		'size' => null,
		'active' => null
	),
	(int) 0 => array(
		'have_date' => '0'
	),
	'Comment' => array(),
	'Staff' => array()
)
$comments = array()
SearchController::search_establishments() - APP/Controller/SearchController.php, line 957
SearchController::query() - APP/Controller/SearchController.php, line 1041
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - APP/Vendor/cakephp/cakephp/lib/Cake/Controller/Controller.php, line 490
Dispatcher::_invoke() - APP/Vendor/cakephp/cakephp/lib/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - APP/Vendor/cakephp/cakephp/lib/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 133

Notice (8): Undefined variable: establishment [APP/Controller/SearchController.php, line 957]
Code Context

            // Quitamos los serficios que no tienen profesionales asignados
            if ($establishment[$key]['Service']) {
$page = (int) 1
$date_slot = ''
$conditions = array(
	'Establishment.population_id' => '4984'
)
$query_establishments = array(
	'Establishment.population_id' => '4984'
)
$key = (int) 5
$value = '4984'
$conditions_price = ''
$day = false
$datetotime = false
$hour = false
$index_dates = false
$fields = '*, IF (Establishment.id in (	select s.establishment_id from
                (select * from services where price > 0) s
                inner join timetables t on t.object='Service' and t.object_id = s.id
                inner join establishments e on s.establishment_id = e.id and plan_id > 0
                inner join timetables te on te.object='Establishment' and te.object_id = e.id
                inner join services_staffs st on st.service_id = s.id
                  inner join staffs on staffs.id = st.staff_id
                  inner join services_staffs stst on stst.staff_id = st.staff_id
                  inner join timetables s_t on s_t.object='Staff' and s_t.object_id = staffs.id
                ),1,0) as have_date '
$field = 'page'
$order = array(
	'have_date' => 'desc',
	'plan_id' => 'desc'
)
$establishments = array(
	(int) 0 => array(
		'Establishment' => array(
			'id' => '1968',
			'name' => 'FISIOTERAPIAS, SCP',
			'category_id' => '1',
			'establishment_type' => '1',
			'image' => null,
			'image_dir' => null,
			'web' => null,
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => '',
			'address1' => 'Carrer Esteve Barange, 18',
			'address2' => '',
			'email' => null,
			'fax' => null,
			'mobile' => '',
			'mobile2' => null,
			'phone' => '938713748',
			'phone2' => null,
			'zipcode' => '08440',
			'town' => 'Cardedeu',
			'state' => 'Barcelona',
			'country' => 'España',
			'latitude' => '41.638924',
			'longitude' => '2.360464',
			'slug' => 'fisioterapias-scp-carrer-esteve-barange',
			'canonical' => 'fisioterapia/cardedeu/fisioterapias-scp',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => '0d5bb5358202b889c58eb5b7ac767239',
			'hash_old' => null,
			'deleted' => false,
			'deleterequest' => null,
			'user_id' => null,
			'plan_id' => '1',
			'next_plan_id' => null,
			'video' => null,
			'pinterest' => null,
			'googleplus' => null,
			'youtube' => null,
			'linkedin' => null,
			'facebook' => null,
			'twitter' => null,
			'status' => '1',
			'subscription_status' => '0',
			'subscription_id' => '0',
			'population_id' => '4984',
			'bank' => null,
			'bank_cert' => null,
			'bank_cert_dir' => null,
			'bank_cert_status' => null,
			'file_dni' => null,
			'file_dni_dir' => null,
			'writers' => null,
			'writers_dir' => null,
			'split_id' => null,
			'created' => '2016-07-07 13:12:19',
			'modified' => '2018-07-10 19:41:49',
			'sms' => null,
			'fulladdress' => 'Carrer Esteve Barange, 18, Cardedeu ( 08440 ) , Barcelona',
			'link' => 'https://www.fisiosite.com/fisioterapia/cardedeu/fisioterapias-scp',
			'path_cert' => '/var/www/fisiosite.com/webroot//files/establishment/bank_cert//',
			'path_dni' => '/var/www/fisiosite.com/webroot//files/establishment/file_dni//',
			'path_writers' => '/var/www/fisiosite.com/webroot//files/establishment/writers//',
			'rating' => false,
			'is_open' => false
		),
		'Category' => array(
			'id' => '1',
			'name' => 'FISIOTERAPIA',
			'slug' => 'fisioterapia',
			'description' => '',
			'parent_id' => '31',
			'created' => '2016-06-13 12:15:16',
			'modified' => '2016-06-13 12:15:16',
			'lft' => '2',
			'rght' => '3'
		),
		'EstablishmentsCategory' => array(
			'id' => null,
			'establishment_id' => null,
			'category_id' => null,
			'created' => null,
			'modified' => null
		),
		'Service' => array(),
		'Slide' => array(
			'id' => null,
			'model' => null,
			'foreign_key' => null,
			'name' => null,
			'attachment' => null,
			'dir' => null,
			'type' => null,
			'size' => null,
			'active' => null
		),
		(int) 0 => array(
			'have_date' => '0'
		),
		'Comment' => array(),
		'Staff' => array(),
		'Slots' => array()
	),
	(int) 1 => array(
		'Establishment' => array(
			'id' => '12555',
			'name' => 'lea',
			'category_id' => '1',
			'establishment_type' => '3',
			'image' => null,
			'image_dir' => null,
			'web' => '',
			'short_description' => null,
			'description' => 'Tractaments de pluripatologies.',
			'fiscalnumber' => '43432994r',
			'address1' => 'calle st josep oriol',
			'address2' => '',
			'email' => 'leabcn@yahoo.es',
			'fax' => null,
			'mobile' => '',
			'mobile2' => null,
			'phone' => '',
			'phone2' => '619565893',
			'zipcode' => '08440',
			'town' => 'Cardedeu',
			'state' => 'Barcelona',
			'country' => '',
			'latitude' => null,
			'longitude' => null,
			'slug' => null,
			'canonical' => 'fisioterapia/cardedeu/lea',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => '8ed820be12be334e66d731218a3ad0fc',
			'hash_old' => null,
			'deleted' => false,
			'deleterequest' => null,
			'user_id' => '5f7ce9fa-5d5c-4e8f-be6e-694e335b89d7',
			'plan_id' => '1',
			'next_plan_id' => null,
			'video' => null,
			'pinterest' => null,
			'googleplus' => null,
			'youtube' => null,
			'linkedin' => null,
			'facebook' => null,
			'twitter' => null,
			'status' => '1',
			'subscription_status' => null,
			'subscription_id' => null,
			'population_id' => '4984',
			'bank' => '',
			'bank_cert' => null,
			'bank_cert_dir' => null,
			'bank_cert_status' => null,
			'file_dni' => null,
			'file_dni_dir' => null,
			'writers' => null,
			'writers_dir' => null,
			'split_id' => null,
			'created' => '2020-10-07 00:12:45',
			'modified' => '2020-10-07 09:59:50',
			'sms' => null,
			'fulladdress' => 'calle st josep oriol, Cardedeu ( 08440 ) , Barcelona',
			'link' => 'https://www.fisiosite.com/fisioterapia/cardedeu/lea',
			'path_cert' => '/var/www/fisiosite.com/webroot//files/establishment/bank_cert//',
			'path_dni' => '/var/www/fisiosite.com/webroot//files/establishment/file_dni//',
			'path_writers' => '/var/www/fisiosite.com/webroot//files/establishment/writers//',
			'rating' => false,
			'is_open' => false
		),
		'Category' => array(
			'id' => '1',
			'name' => 'FISIOTERAPIA',
			'slug' => 'fisioterapia',
			'description' => '',
			'parent_id' => '31',
			'created' => '2016-06-13 12:15:16',
			'modified' => '2016-06-13 12:15:16',
			'lft' => '2',
			'rght' => '3'
		),
		'EstablishmentsCategory' => array(
			'id' => null,
			'establishment_id' => null,
			'category_id' => null,
			'created' => null,
			'modified' => null
		),
		'Service' => array(),
		'Slide' => array(
			'id' => null,
			'model' => null,
			'foreign_key' => null,
			'name' => null,
			'attachment' => null,
			'dir' => null,
			'type' => null,
			'size' => null,
			'active' => null
		),
		(int) 0 => array(
			'have_date' => '0'
		),
		'Comment' => array(),
		'Staff' => array(),
		'Slots' => array()
	),
	(int) 2 => array(
		'Establishment' => array(
			'id' => '10393',
			'name' => 'Fisioterapias P',
			'category_id' => '1',
			'establishment_type' => '1',
			'image' => null,
			'image_dir' => null,
			'web' => '',
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => null,
			'address1' => 'Carrer Barangé, 18',
			'address2' => '',
			'email' => '',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '938 71 37 48',
			'phone2' => '',
			'zipcode' => '08440',
			'town' => 'Cardedeu',
			'state' => 'Barcelona',
			'country' => 'España',
			'latitude' => '41.638866',
			'longitude' => '2.360579',
			'slug' => null,
			'canonical' => 'fisioterapia/cardedeu/fisioterapias-p',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => 'b6be25713db847e99bdc9b22cb578a10',
			'hash_old' => null,
			'deleted' => false,
			'deleterequest' => null,
			'user_id' => null,
			'plan_id' => null,
			'next_plan_id' => null,
			'video' => null,
			'pinterest' => null,
			'googleplus' => null,
			'youtube' => null,
			'linkedin' => null,
			'facebook' => null,
			'twitter' => null,
			'status' => '1',
			'subscription_status' => '0',
			'subscription_id' => '0',
			'population_id' => '4984',
			'bank' => null,
			'bank_cert' => null,
			'bank_cert_dir' => null,
			'bank_cert_status' => null,
			'file_dni' => null,
			'file_dni_dir' => null,
			'writers' => null,
			'writers_dir' => null,
			'split_id' => null,
			'created' => '2017-10-02 10:04:01',
			'modified' => '2018-07-10 20:03:31',
			'sms' => null,
			'fulladdress' => 'Carrer Barangé, 18, Cardedeu ( 08440 ) , Barcelona',
			'link' => 'https://www.fisiosite.com/fisioterapia/cardedeu/fisioterapias-p',
			'path_cert' => '/var/www/fisiosite.com/webroot//files/establishment/bank_cert//',
			'path_dni' => '/var/www/fisiosite.com/webroot//files/establishment/file_dni//',
			'path_writers' => '/var/www/fisiosite.com/webroot//files/establishment/writers//',
			'rating' => false,
			'is_open' => false
		),
		'Category' => array(
			'id' => '1',
			'name' => 'FISIOTERAPIA',
			'slug' => 'fisioterapia',
			'description' => '',
			'parent_id' => '31',
			'created' => '2016-06-13 12:15:16',
			'modified' => '2016-06-13 12:15:16',
			'lft' => '2',
			'rght' => '3'
		),
		'EstablishmentsCategory' => array(
			'id' => null,
			'establishment_id' => null,
			'category_id' => null,
			'created' => null,
			'modified' => null
		),
		'Service' => array(),
		'Slide' => array(
			'id' => null,
			'model' => null,
			'foreign_key' => null,
			'name' => null,
			'attachment' => null,
			'dir' => null,
			'type' => null,
			'size' => null,
			'active' => null
		),
		(int) 0 => array(
			'have_date' => '0'
		),
		'Comment' => array(),
		'Staff' => array(),
		'Slots' => array()
	),
	(int) 3 => array(
		'Establishment' => array(
			'id' => '10394',
			'name' => 'Carles Sunyer Oller',
			'category_id' => '1',
			'establishment_type' => '1',
			'image' => null,
			'image_dir' => null,
			'web' => '',
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => null,
			'address1' => 'Carrer Llinars, 68',
			'address2' => '',
			'email' => '',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '938 44 46 67',
			'phone2' => '',
			'zipcode' => '08440',
			'town' => 'Cardedeu',
			'state' => 'Barcelona',
			'country' => 'España',
			'latitude' => '41.637371',
			'longitude' => '2.362430',
			'slug' => null,
			'canonical' => 'fisioterapia/cardedeu/carles-sunyer-oller',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => 'af7d084353ad76401075c68c027f56ee',
			'hash_old' => null,
			'deleted' => false,
			'deleterequest' => null,
			'user_id' => null,
			'plan_id' => null,
			'next_plan_id' => null,
			'video' => null,
			'pinterest' => null,
			'googleplus' => null,
			'youtube' => null,
			'linkedin' => null,
			'facebook' => null,
			'twitter' => null,
			'status' => '1',
			'subscription_status' => '0',
			'subscription_id' => '0',
			'population_id' => '4984',
			'bank' => null,
			'bank_cert' => null,
			'bank_cert_dir' => null,
			'bank_cert_status' => null,
			'file_dni' => null,
			'file_dni_dir' => null,
			'writers' => null,
			'writers_dir' => null,
			'split_id' => null,
			'created' => '2017-10-02 10:04:06',
			'modified' => '2018-07-10 20:03:31',
			'sms' => null,
			'fulladdress' => 'Carrer Llinars, 68, Cardedeu ( 08440 ) , Barcelona',
			'link' => 'https://www.fisiosite.com/fisioterapia/cardedeu/carles-sunyer-oller',
			'path_cert' => '/var/www/fisiosite.com/webroot//files/establishment/bank_cert//',
			'path_dni' => '/var/www/fisiosite.com/webroot//files/establishment/file_dni//',
			'path_writers' => '/var/www/fisiosite.com/webroot//files/establishment/writers//',
			'rating' => false,
			'is_open' => false
		),
		'Category' => array(
			'id' => '1',
			'name' => 'FISIOTERAPIA',
			'slug' => 'fisioterapia',
			'description' => '',
			'parent_id' => '31',
			'created' => '2016-06-13 12:15:16',
			'modified' => '2016-06-13 12:15:16',
			'lft' => '2',
			'rght' => '3'
		),
		'EstablishmentsCategory' => array(
			'id' => null,
			'establishment_id' => null,
			'category_id' => null,
			'created' => null,
			'modified' => null
		),
		'Service' => array(),
		'Slide' => array(
			'id' => null,
			'model' => null,
			'foreign_key' => null,
			'name' => null,
			'attachment' => null,
			'dir' => null,
			'type' => null,
			'size' => null,
			'active' => null
		),
		(int) 0 => array(
			'have_date' => '0'
		),
		'Comment' => array(),
		'Staff' => array(),
		'Slots' => array()
	),
	(int) 4 => array(
		'Establishment' => array(
			'id' => '10395',
			'name' => 'Homefisio Cardedeu',
			'category_id' => '1',
			'establishment_type' => '1',
			'image' => null,
			'image_dir' => null,
			'web' => 'http://homeofisiocardedeu.blogspot.com.es',
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => null,
			'address1' => 'C/Cervantes, 17',
			'address2' => '',
			'email' => '',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '627 909 953',
			'phone2' => '610 607 185',
			'zipcode' => '08440',
			'town' => 'Cardedeu',
			'state' => 'Barcelona',
			'country' => 'España',
			'latitude' => '41.640320',
			'longitude' => '2.356590',
			'slug' => null,
			'canonical' => 'fisioterapia/cardedeu/homefisio-cardedeu',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => '744778f8fc1c9f1398d5190f0fc97b93',
			'hash_old' => null,
			'deleted' => false,
			'deleterequest' => null,
			'user_id' => null,
			'plan_id' => null,
			'next_plan_id' => null,
			'video' => null,
			'pinterest' => null,
			'googleplus' => null,
			'youtube' => null,
			'linkedin' => null,
			'facebook' => null,
			'twitter' => null,
			'status' => '1',
			'subscription_status' => '0',
			'subscription_id' => '0',
			'population_id' => '4984',
			'bank' => null,
			'bank_cert' => null,
			'bank_cert_dir' => null,
			'bank_cert_status' => null,
			'file_dni' => null,
			'file_dni_dir' => null,
			'writers' => null,
			'writers_dir' => null,
			'split_id' => null,
			'created' => '2017-10-02 10:04:09',
			'modified' => '2018-07-10 20:03:31',
			'sms' => null,
			'fulladdress' => 'C/Cervantes, 17, Cardedeu ( 08440 ) , Barcelona',
			'link' => 'https://www.fisiosite.com/fisioterapia/cardedeu/homefisio-cardedeu',
			'path_cert' => '/var/www/fisiosite.com/webroot//files/establishment/bank_cert//',
			'path_dni' => '/var/www/fisiosite.com/webroot//files/establishment/file_dni//',
			'path_writers' => '/var/www/fisiosite.com/webroot//files/establishment/writers//',
			'rating' => false,
			'is_open' => false
		),
		'Category' => array(
			'id' => '1',
			'name' => 'FISIOTERAPIA',
			'slug' => 'fisioterapia',
			'description' => '',
			'parent_id' => '31',
			'created' => '2016-06-13 12:15:16',
			'modified' => '2016-06-13 12:15:16',
			'lft' => '2',
			'rght' => '3'
		),
		'EstablishmentsCategory' => array(
			'id' => null,
			'establishment_id' => null,
			'category_id' => null,
			'created' => null,
			'modified' => null
		),
		'Service' => array(),
		'Slide' => array(
			'id' => null,
			'model' => null,
			'foreign_key' => null,
			'name' => null,
			'attachment' => null,
			'dir' => null,
			'type' => null,
			'size' => null,
			'active' => null
		),
		(int) 0 => array(
			'have_date' => '0'
		),
		'Comment' => array(),
		'Staff' => array(),
		'Slots' => array()
	),
	(int) 5 => array(
		'Establishment' => array(
			'id' => '10396',
			'name' => 'Onco Cardedeu-Baix Montseny',
			'category_id' => '30',
			'establishment_type' => '1',
			'image' => null,
			'image_dir' => null,
			'web' => 'http://www.oncocardedeu.cat/',
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => null,
			'address1' => 'Àngel Guimera 144',
			'address2' => '',
			'email' => 'oncocardedeu@gmail.com',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '660 45 48 54',
			'phone2' => '',
			'zipcode' => '08440',
			'town' => 'Cardedeu',
			'state' => 'Barcelona',
			'country' => 'España',
			'latitude' => '41.640781',
			'longitude' => '2.359496',
			'slug' => null,
			'canonical' => 'fisioterapia-oncologica/cardedeu/onco-cardedeu-baix-montseny',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => '8ac8b548d4762d75da965be01850bc40',
			'hash_old' => null,
			'deleted' => false,
			'deleterequest' => null,
			'user_id' => null,
			'plan_id' => null,
			'next_plan_id' => null,
			'video' => null,
			'pinterest' => null,
			'googleplus' => null,
			'youtube' => null,
			'linkedin' => null,
			'facebook' => null,
			'twitter' => null,
			'status' => '1',
			'subscription_status' => '0',
			'subscription_id' => '0',
			'population_id' => '4984',
			'bank' => null,
			'bank_cert' => null,
			'bank_cert_dir' => null,
			'bank_cert_status' => null,
			'file_dni' => null,
			'file_dni_dir' => null,
			'writers' => null,
			'writers_dir' => null,
			'split_id' => null,
			'created' => '2017-10-02 10:04:13',
			'modified' => '2018-07-10 20:03:31',
			'sms' => null,
			'fulladdress' => 'Àngel Guimera 144, Cardedeu ( 08440 ) , Barcelona',
			'link' => 'https://www.fisiosite.com/fisioterapia-oncologica/cardedeu/onco-cardedeu-baix-montseny',
			'path_cert' => '/var/www/fisiosite.com/webroot//files/establishment/bank_cert//',
			'path_dni' => '/var/www/fisiosite.com/webroot//files/establishment/file_dni//',
			'path_writers' => '/var/www/fisiosite.com/webroot//files/establishment/writers//',
			'rating' => false,
			'is_open' => false
		),
		'Category' => array(
			'id' => '30',
			'name' => 'FISIOTERAPIA ONCOLOGICA',
			'slug' => 'fisioterapia-oncologica',
			'description' => '',
			'parent_id' => '1',
			'created' => '2016-06-13 12:15:17',
			'modified' => '2016-06-13 12:15:17',
			'lft' => '58',
			'rght' => '59'
		),
		'EstablishmentsCategory' => array(
			'id' => null,
			'establishment_id' => null,
			'category_id' => null,
			'created' => null,
			'modified' => null
		),
		'Service' => array(),
		'Slide' => array(
			'id' => null,
			'model' => null,
			'foreign_key' => null,
			'name' => null,
			'attachment' => null,
			'dir' => null,
			'type' => null,
			'size' => null,
			'active' => null
		),
		(int) 0 => array(
			'have_date' => '0'
		),
		'Comment' => array(),
		'Staff' => array(),
		'Slots' => array()
	),
	(int) 6 => array(
		'Establishment' => array(
			'id' => '10397',
			'name' => 'Núria López.',
			'category_id' => '1',
			'establishment_type' => '1',
			'image' => null,
			'image_dir' => null,
			'web' => '',
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => null,
			'address1' => 'Àngel Guimerà, 21',
			'address2' => '2n 1a',
			'email' => '',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '647 24 53 83',
			'phone2' => '',
			'zipcode' => '08440',
			'town' => 'Cardedeu',
			'state' => 'Barcelona',
			'country' => 'España',
			'latitude' => '41.637615',
			'longitude' => '2.359355',
			'slug' => null,
			'canonical' => 'fisioterapia/cardedeu/nuria-lopez',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => '7a7e0eecf51ea82b78030008aab2eaa8',
			'hash_old' => null,
			'deleted' => false,
			'deleterequest' => null,
			'user_id' => null,
			'plan_id' => null,
			'next_plan_id' => null,
			'video' => null,
			'pinterest' => null,
			'googleplus' => null,
			'youtube' => null,
			'linkedin' => null,
			'facebook' => null,
			'twitter' => null,
			'status' => '1',
			'subscription_status' => '0',
			'subscription_id' => '0',
			'population_id' => '4984',
			'bank' => null,
			'bank_cert' => null,
			'bank_cert_dir' => null,
			'bank_cert_status' => null,
			'file_dni' => null,
			'file_dni_dir' => null,
			'writers' => null,
			'writers_dir' => null,
			'split_id' => null,
			'created' => '2017-10-02 10:04:15',
			'modified' => '2018-07-10 20:03:32',
			'sms' => null,
			'fulladdress' => 'Àngel Guimerà, 21, Cardedeu ( 08440 ) , Barcelona',
			'link' => 'https://www.fisiosite.com/fisioterapia/cardedeu/nuria-lopez',
			'path_cert' => '/var/www/fisiosite.com/webroot//files/establishment/bank_cert//',
			'path_dni' => '/var/www/fisiosite.com/webroot//files/establishment/file_dni//',
			'path_writers' => '/var/www/fisiosite.com/webroot//files/establishment/writers//'
		),
		'Category' => array(
			'id' => '1',
			'name' => 'FISIOTERAPIA',
			'slug' => 'fisioterapia',
			'description' => '',
			'parent_id' => '31',
			'created' => '2016-06-13 12:15:16',
			'modified' => '2016-06-13 12:15:16',
			'lft' => '2',
			'rght' => '3'
		),
		'EstablishmentsCategory' => array(
			'id' => null,
			'establishment_id' => null,
			'category_id' => null,
			'created' => null,
			'modified' => null
		),
		'Service' => array(
			'id' => null,
			'name' => null,
			'description' => null,
			'duration_reserved' => null,
			'duration' => null,
			'price' => null,
			'slots' => null,
			'pay_online' => null,
			'establishment_id' => null,
			'created_status' => null,
			'tag' => null,
			'created' => null,
			'modified' => null
		),
		'Slide' => array(
			'id' => null,
			'model' => null,
			'foreign_key' => null,
			'name' => null,
			'attachment' => null,
			'dir' => null,
			'type' => null,
			'size' => null,
			'active' => null
		),
		(int) 0 => array(
			'have_date' => '0'
		),
		'Comment' => array(),
		'Staff' => array()
	),
	(int) 7 => array(
		'Establishment' => array(
			'id' => '10398',
			'name' => 'Eloi Anson Nebot',
			'category_id' => '14',
			'establishment_type' => '1',
			'image' => null,
			'image_dir' => null,
			'web' => '',
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => null,
			'address1' => 'Josep Vilaseca, 18',
			'address2' => 'Y 20',
			'email' => '',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '938477485',
			'phone2' => '',
			'zipcode' => '08440',
			'town' => 'Cardedeu',
			'state' => 'Barcelona',
			'country' => 'España',
			'latitude' => '41.638237',
			'longitude' => '2.354416',
			'slug' => null,
			'canonical' => 'osteopatia/cardedeu/eloi-anson-nebot',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => '7f10e9fdb02cc235b4f1214e4bb4a238',
			'hash_old' => null,
			'deleted' => false,
			'deleterequest' => null,
			'user_id' => null,
			'plan_id' => null,
			'next_plan_id' => null,
			'video' => null,
			'pinterest' => null,
			'googleplus' => null,
			'youtube' => null,
			'linkedin' => null,
			'facebook' => null,
			'twitter' => null,
			'status' => '1',
			'subscription_status' => '0',
			'subscription_id' => '0',
			'population_id' => '4984',
			'bank' => null,
			'bank_cert' => null,
			'bank_cert_dir' => null,
			'bank_cert_status' => null,
			'file_dni' => null,
			'file_dni_dir' => null,
			'writers' => null,
			'writers_dir' => null,
			'split_id' => null,
			'created' => '2017-10-02 10:04:17',
			'modified' => '2018-07-10 20:03:32',
			'sms' => null,
			'fulladdress' => 'Josep Vilaseca, 18, Cardedeu ( 08440 ) , Barcelona',
			'link' => 'https://www.fisiosite.com/osteopatia/cardedeu/eloi-anson-nebot',
			'path_cert' => '/var/www/fisiosite.com/webroot//files/establishment/bank_cert//',
			'path_dni' => '/var/www/fisiosite.com/webroot//files/establishment/file_dni//',
			'path_writers' => '/var/www/fisiosite.com/webroot//files/establishment/writers//'
		),
		'Category' => array(
			'id' => '14',
			'name' => 'OSTEOPATIA',
			'slug' => 'osteopatia',
			'description' => '',
			'parent_id' => '1',
			'created' => '2016-06-13 12:15:16',
			'modified' => '2016-06-13 12:15:16',
			'lft' => '26',
			'rght' => '27'
		),
		'EstablishmentsCategory' => array(
			'id' => null,
			'establishment_id' => null,
			'category_id' => null,
			'created' => null,
			'modified' => null
		),
		'Service' => array(
			'id' => null,
			'name' => null,
			'description' => null,
			'duration_reserved' => null,
			'duration' => null,
			'price' => null,
			'slots' => null,
			'pay_online' => null,
			'establishment_id' => null,
			'created_status' => null,
			'tag' => null,
			'created' => null,
			'modified' => null
		),
		'Slide' => array(
			'id' => null,
			'model' => null,
			'foreign_key' => null,
			'name' => null,
			'attachment' => null,
			'dir' => null,
			'type' => null,
			'size' => null,
			'active' => null
		),
		(int) 0 => array(
			'have_date' => '0'
		),
		'Comment' => array(),
		'Staff' => array()
	)
)
$n_establishments = (int) 8
$e = array(
	'Establishment' => array(
		'id' => '10396',
		'name' => 'Onco Cardedeu-Baix Montseny',
		'category_id' => '30',
		'establishment_type' => '1',
		'image' => null,
		'image_dir' => null,
		'web' => 'http://www.oncocardedeu.cat/',
		'short_description' => null,
		'description' => null,
		'fiscalnumber' => null,
		'address1' => 'Àngel Guimera 144',
		'address2' => '',
		'email' => 'oncocardedeu@gmail.com',
		'fax' => null,
		'mobile' => '',
		'mobile2' => '',
		'phone' => '660 45 48 54',
		'phone2' => '',
		'zipcode' => '08440',
		'town' => 'Cardedeu',
		'state' => 'Barcelona',
		'country' => 'España',
		'latitude' => '41.640781',
		'longitude' => '2.359496',
		'slug' => null,
		'canonical' => 'fisioterapia-oncologica/cardedeu/onco-cardedeu-baix-montseny',
		'canonical_old' => null,
		'timetable' => null,
		'hash' => '8ac8b548d4762d75da965be01850bc40',
		'hash_old' => null,
		'deleted' => false,
		'deleterequest' => null,
		'user_id' => null,
		'plan_id' => null,
		'next_plan_id' => null,
		'video' => null,
		'pinterest' => null,
		'googleplus' => null,
		'youtube' => null,
		'linkedin' => null,
		'facebook' => null,
		'twitter' => null,
		'status' => '1',
		'subscription_status' => '0',
		'subscription_id' => '0',
		'population_id' => '4984',
		'bank' => null,
		'bank_cert' => null,
		'bank_cert_dir' => null,
		'bank_cert_status' => null,
		'file_dni' => null,
		'file_dni_dir' => null,
		'writers' => null,
		'writers_dir' => null,
		'split_id' => null,
		'created' => '2017-10-02 10:04:13',
		'modified' => '2018-07-10 20:03:31',
		'sms' => null,
		'fulladdress' => 'Àngel Guimera 144, Cardedeu ( 08440 ) , Barcelona',
		'link' => 'https://www.fisiosite.com/fisioterapia-oncologica/cardedeu/onco-cardedeu-baix-montseny',
		'path_cert' => '/var/www/fisiosite.com/webroot//files/establishment/bank_cert//',
		'path_dni' => '/var/www/fisiosite.com/webroot//files/establishment/file_dni//',
		'path_writers' => '/var/www/fisiosite.com/webroot//files/establishment/writers//'
	),
	'Category' => array(
		'id' => '30',
		'name' => 'FISIOTERAPIA ONCOLOGICA',
		'slug' => 'fisioterapia-oncologica',
		'description' => '',
		'parent_id' => '1',
		'created' => '2016-06-13 12:15:17',
		'modified' => '2016-06-13 12:15:17',
		'lft' => '58',
		'rght' => '59'
	),
	'EstablishmentsCategory' => array(
		'id' => null,
		'establishment_id' => null,
		'category_id' => null,
		'created' => null,
		'modified' => null
	),
	'Service' => array(
		'id' => null,
		'name' => null,
		'description' => null,
		'duration_reserved' => null,
		'duration' => null,
		'price' => null,
		'slots' => null,
		'pay_online' => null,
		'establishment_id' => null,
		'created_status' => null,
		'tag' => null,
		'created' => null,
		'modified' => null
	),
	'Slide' => array(
		'id' => null,
		'model' => null,
		'foreign_key' => null,
		'name' => null,
		'attachment' => null,
		'dir' => null,
		'type' => null,
		'size' => null,
		'active' => null
	),
	(int) 0 => array(
		'have_date' => '0'
	),
	'Comment' => array(),
	'Staff' => array()
)
$comments = array()
SearchController::search_establishments() - APP/Controller/SearchController.php, line 957
SearchController::query() - APP/Controller/SearchController.php, line 1041
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - APP/Vendor/cakephp/cakephp/lib/Cake/Controller/Controller.php, line 490
Dispatcher::_invoke() - APP/Vendor/cakephp/cakephp/lib/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - APP/Vendor/cakephp/cakephp/lib/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 133

Notice (8): Undefined variable: establishment [APP/Controller/SearchController.php, line 957]
Code Context

            // Quitamos los serficios que no tienen profesionales asignados
            if ($establishment[$key]['Service']) {
$page = (int) 1
$date_slot = ''
$conditions = array(
	'Establishment.population_id' => '4984'
)
$query_establishments = array(
	'Establishment.population_id' => '4984'
)
$key = (int) 6
$value = '4984'
$conditions_price = ''
$day = false
$datetotime = false
$hour = false
$index_dates = false
$fields = '*, IF (Establishment.id in (	select s.establishment_id from
                (select * from services where price > 0) s
                inner join timetables t on t.object='Service' and t.object_id = s.id
                inner join establishments e on s.establishment_id = e.id and plan_id > 0
                inner join timetables te on te.object='Establishment' and te.object_id = e.id
                inner join services_staffs st on st.service_id = s.id
                  inner join staffs on staffs.id = st.staff_id
                  inner join services_staffs stst on stst.staff_id = st.staff_id
                  inner join timetables s_t on s_t.object='Staff' and s_t.object_id = staffs.id
                ),1,0) as have_date '
$field = 'page'
$order = array(
	'have_date' => 'desc',
	'plan_id' => 'desc'
)
$establishments = array(
	(int) 0 => array(
		'Establishment' => array(
			'id' => '1968',
			'name' => 'FISIOTERAPIAS, SCP',
			'category_id' => '1',
			'establishment_type' => '1',
			'image' => null,
			'image_dir' => null,
			'web' => null,
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => '',
			'address1' => 'Carrer Esteve Barange, 18',
			'address2' => '',
			'email' => null,
			'fax' => null,
			'mobile' => '',
			'mobile2' => null,
			'phone' => '938713748',
			'phone2' => null,
			'zipcode' => '08440',
			'town' => 'Cardedeu',
			'state' => 'Barcelona',
			'country' => 'España',
			'latitude' => '41.638924',
			'longitude' => '2.360464',
			'slug' => 'fisioterapias-scp-carrer-esteve-barange',
			'canonical' => 'fisioterapia/cardedeu/fisioterapias-scp',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => '0d5bb5358202b889c58eb5b7ac767239',
			'hash_old' => null,
			'deleted' => false,
			'deleterequest' => null,
			'user_id' => null,
			'plan_id' => '1',
			'next_plan_id' => null,
			'video' => null,
			'pinterest' => null,
			'googleplus' => null,
			'youtube' => null,
			'linkedin' => null,
			'facebook' => null,
			'twitter' => null,
			'status' => '1',
			'subscription_status' => '0',
			'subscription_id' => '0',
			'population_id' => '4984',
			'bank' => null,
			'bank_cert' => null,
			'bank_cert_dir' => null,
			'bank_cert_status' => null,
			'file_dni' => null,
			'file_dni_dir' => null,
			'writers' => null,
			'writers_dir' => null,
			'split_id' => null,
			'created' => '2016-07-07 13:12:19',
			'modified' => '2018-07-10 19:41:49',
			'sms' => null,
			'fulladdress' => 'Carrer Esteve Barange, 18, Cardedeu ( 08440 ) , Barcelona',
			'link' => 'https://www.fisiosite.com/fisioterapia/cardedeu/fisioterapias-scp',
			'path_cert' => '/var/www/fisiosite.com/webroot//files/establishment/bank_cert//',
			'path_dni' => '/var/www/fisiosite.com/webroot//files/establishment/file_dni//',
			'path_writers' => '/var/www/fisiosite.com/webroot//files/establishment/writers//',
			'rating' => false,
			'is_open' => false
		),
		'Category' => array(
			'id' => '1',
			'name' => 'FISIOTERAPIA',
			'slug' => 'fisioterapia',
			'description' => '',
			'parent_id' => '31',
			'created' => '2016-06-13 12:15:16',
			'modified' => '2016-06-13 12:15:16',
			'lft' => '2',
			'rght' => '3'
		),
		'EstablishmentsCategory' => array(
			'id' => null,
			'establishment_id' => null,
			'category_id' => null,
			'created' => null,
			'modified' => null
		),
		'Service' => array(),
		'Slide' => array(
			'id' => null,
			'model' => null,
			'foreign_key' => null,
			'name' => null,
			'attachment' => null,
			'dir' => null,
			'type' => null,
			'size' => null,
			'active' => null
		),
		(int) 0 => array(
			'have_date' => '0'
		),
		'Comment' => array(),
		'Staff' => array(),
		'Slots' => array()
	),
	(int) 1 => array(
		'Establishment' => array(
			'id' => '12555',
			'name' => 'lea',
			'category_id' => '1',
			'establishment_type' => '3',
			'image' => null,
			'image_dir' => null,
			'web' => '',
			'short_description' => null,
			'description' => 'Tractaments de pluripatologies.',
			'fiscalnumber' => '43432994r',
			'address1' => 'calle st josep oriol',
			'address2' => '',
			'email' => 'leabcn@yahoo.es',
			'fax' => null,
			'mobile' => '',
			'mobile2' => null,
			'phone' => '',
			'phone2' => '619565893',
			'zipcode' => '08440',
			'town' => 'Cardedeu',
			'state' => 'Barcelona',
			'country' => '',
			'latitude' => null,
			'longitude' => null,
			'slug' => null,
			'canonical' => 'fisioterapia/cardedeu/lea',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => '8ed820be12be334e66d731218a3ad0fc',
			'hash_old' => null,
			'deleted' => false,
			'deleterequest' => null,
			'user_id' => '5f7ce9fa-5d5c-4e8f-be6e-694e335b89d7',
			'plan_id' => '1',
			'next_plan_id' => null,
			'video' => null,
			'pinterest' => null,
			'googleplus' => null,
			'youtube' => null,
			'linkedin' => null,
			'facebook' => null,
			'twitter' => null,
			'status' => '1',
			'subscription_status' => null,
			'subscription_id' => null,
			'population_id' => '4984',
			'bank' => '',
			'bank_cert' => null,
			'bank_cert_dir' => null,
			'bank_cert_status' => null,
			'file_dni' => null,
			'file_dni_dir' => null,
			'writers' => null,
			'writers_dir' => null,
			'split_id' => null,
			'created' => '2020-10-07 00:12:45',
			'modified' => '2020-10-07 09:59:50',
			'sms' => null,
			'fulladdress' => 'calle st josep oriol, Cardedeu ( 08440 ) , Barcelona',
			'link' => 'https://www.fisiosite.com/fisioterapia/cardedeu/lea',
			'path_cert' => '/var/www/fisiosite.com/webroot//files/establishment/bank_cert//',
			'path_dni' => '/var/www/fisiosite.com/webroot//files/establishment/file_dni//',
			'path_writers' => '/var/www/fisiosite.com/webroot//files/establishment/writers//',
			'rating' => false,
			'is_open' => false
		),
		'Category' => array(
			'id' => '1',
			'name' => 'FISIOTERAPIA',
			'slug' => 'fisioterapia',
			'description' => '',
			'parent_id' => '31',
			'created' => '2016-06-13 12:15:16',
			'modified' => '2016-06-13 12:15:16',
			'lft' => '2',
			'rght' => '3'
		),
		'EstablishmentsCategory' => array(
			'id' => null,
			'establishment_id' => null,
			'category_id' => null,
			'created' => null,
			'modified' => null
		),
		'Service' => array(),
		'Slide' => array(
			'id' => null,
			'model' => null,
			'foreign_key' => null,
			'name' => null,
			'attachment' => null,
			'dir' => null,
			'type' => null,
			'size' => null,
			'active' => null
		),
		(int) 0 => array(
			'have_date' => '0'
		),
		'Comment' => array(),
		'Staff' => array(),
		'Slots' => array()
	),
	(int) 2 => array(
		'Establishment' => array(
			'id' => '10393',
			'name' => 'Fisioterapias P',
			'category_id' => '1',
			'establishment_type' => '1',
			'image' => null,
			'image_dir' => null,
			'web' => '',
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => null,
			'address1' => 'Carrer Barangé, 18',
			'address2' => '',
			'email' => '',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '938 71 37 48',
			'phone2' => '',
			'zipcode' => '08440',
			'town' => 'Cardedeu',
			'state' => 'Barcelona',
			'country' => 'España',
			'latitude' => '41.638866',
			'longitude' => '2.360579',
			'slug' => null,
			'canonical' => 'fisioterapia/cardedeu/fisioterapias-p',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => 'b6be25713db847e99bdc9b22cb578a10',
			'hash_old' => null,
			'deleted' => false,
			'deleterequest' => null,
			'user_id' => null,
			'plan_id' => null,
			'next_plan_id' => null,
			'video' => null,
			'pinterest' => null,
			'googleplus' => null,
			'youtube' => null,
			'linkedin' => null,
			'facebook' => null,
			'twitter' => null,
			'status' => '1',
			'subscription_status' => '0',
			'subscription_id' => '0',
			'population_id' => '4984',
			'bank' => null,
			'bank_cert' => null,
			'bank_cert_dir' => null,
			'bank_cert_status' => null,
			'file_dni' => null,
			'file_dni_dir' => null,
			'writers' => null,
			'writers_dir' => null,
			'split_id' => null,
			'created' => '2017-10-02 10:04:01',
			'modified' => '2018-07-10 20:03:31',
			'sms' => null,
			'fulladdress' => 'Carrer Barangé, 18, Cardedeu ( 08440 ) , Barcelona',
			'link' => 'https://www.fisiosite.com/fisioterapia/cardedeu/fisioterapias-p',
			'path_cert' => '/var/www/fisiosite.com/webroot//files/establishment/bank_cert//',
			'path_dni' => '/var/www/fisiosite.com/webroot//files/establishment/file_dni//',
			'path_writers' => '/var/www/fisiosite.com/webroot//files/establishment/writers//',
			'rating' => false,
			'is_open' => false
		),
		'Category' => array(
			'id' => '1',
			'name' => 'FISIOTERAPIA',
			'slug' => 'fisioterapia',
			'description' => '',
			'parent_id' => '31',
			'created' => '2016-06-13 12:15:16',
			'modified' => '2016-06-13 12:15:16',
			'lft' => '2',
			'rght' => '3'
		),
		'EstablishmentsCategory' => array(
			'id' => null,
			'establishment_id' => null,
			'category_id' => null,
			'created' => null,
			'modified' => null
		),
		'Service' => array(),
		'Slide' => array(
			'id' => null,
			'model' => null,
			'foreign_key' => null,
			'name' => null,
			'attachment' => null,
			'dir' => null,
			'type' => null,
			'size' => null,
			'active' => null
		),
		(int) 0 => array(
			'have_date' => '0'
		),
		'Comment' => array(),
		'Staff' => array(),
		'Slots' => array()
	),
	(int) 3 => array(
		'Establishment' => array(
			'id' => '10394',
			'name' => 'Carles Sunyer Oller',
			'category_id' => '1',
			'establishment_type' => '1',
			'image' => null,
			'image_dir' => null,
			'web' => '',
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => null,
			'address1' => 'Carrer Llinars, 68',
			'address2' => '',
			'email' => '',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '938 44 46 67',
			'phone2' => '',
			'zipcode' => '08440',
			'town' => 'Cardedeu',
			'state' => 'Barcelona',
			'country' => 'España',
			'latitude' => '41.637371',
			'longitude' => '2.362430',
			'slug' => null,
			'canonical' => 'fisioterapia/cardedeu/carles-sunyer-oller',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => 'af7d084353ad76401075c68c027f56ee',
			'hash_old' => null,
			'deleted' => false,
			'deleterequest' => null,
			'user_id' => null,
			'plan_id' => null,
			'next_plan_id' => null,
			'video' => null,
			'pinterest' => null,
			'googleplus' => null,
			'youtube' => null,
			'linkedin' => null,
			'facebook' => null,
			'twitter' => null,
			'status' => '1',
			'subscription_status' => '0',
			'subscription_id' => '0',
			'population_id' => '4984',
			'bank' => null,
			'bank_cert' => null,
			'bank_cert_dir' => null,
			'bank_cert_status' => null,
			'file_dni' => null,
			'file_dni_dir' => null,
			'writers' => null,
			'writers_dir' => null,
			'split_id' => null,
			'created' => '2017-10-02 10:04:06',
			'modified' => '2018-07-10 20:03:31',
			'sms' => null,
			'fulladdress' => 'Carrer Llinars, 68, Cardedeu ( 08440 ) , Barcelona',
			'link' => 'https://www.fisiosite.com/fisioterapia/cardedeu/carles-sunyer-oller',
			'path_cert' => '/var/www/fisiosite.com/webroot//files/establishment/bank_cert//',
			'path_dni' => '/var/www/fisiosite.com/webroot//files/establishment/file_dni//',
			'path_writers' => '/var/www/fisiosite.com/webroot//files/establishment/writers//',
			'rating' => false,
			'is_open' => false
		),
		'Category' => array(
			'id' => '1',
			'name' => 'FISIOTERAPIA',
			'slug' => 'fisioterapia',
			'description' => '',
			'parent_id' => '31',
			'created' => '2016-06-13 12:15:16',
			'modified' => '2016-06-13 12:15:16',
			'lft' => '2',
			'rght' => '3'
		),
		'EstablishmentsCategory' => array(
			'id' => null,
			'establishment_id' => null,
			'category_id' => null,
			'created' => null,
			'modified' => null
		),
		'Service' => array(),
		'Slide' => array(
			'id' => null,
			'model' => null,
			'foreign_key' => null,
			'name' => null,
			'attachment' => null,
			'dir' => null,
			'type' => null,
			'size' => null,
			'active' => null
		),
		(int) 0 => array(
			'have_date' => '0'
		),
		'Comment' => array(),
		'Staff' => array(),
		'Slots' => array()
	),
	(int) 4 => array(
		'Establishment' => array(
			'id' => '10395',
			'name' => 'Homefisio Cardedeu',
			'category_id' => '1',
			'establishment_type' => '1',
			'image' => null,
			'image_dir' => null,
			'web' => 'http://homeofisiocardedeu.blogspot.com.es',
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => null,
			'address1' => 'C/Cervantes, 17',
			'address2' => '',
			'email' => '',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '627 909 953',
			'phone2' => '610 607 185',
			'zipcode' => '08440',
			'town' => 'Cardedeu',
			'state' => 'Barcelona',
			'country' => 'España',
			'latitude' => '41.640320',
			'longitude' => '2.356590',
			'slug' => null,
			'canonical' => 'fisioterapia/cardedeu/homefisio-cardedeu',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => '744778f8fc1c9f1398d5190f0fc97b93',
			'hash_old' => null,
			'deleted' => false,
			'deleterequest' => null,
			'user_id' => null,
			'plan_id' => null,
			'next_plan_id' => null,
			'video' => null,
			'pinterest' => null,
			'googleplus' => null,
			'youtube' => null,
			'linkedin' => null,
			'facebook' => null,
			'twitter' => null,
			'status' => '1',
			'subscription_status' => '0',
			'subscription_id' => '0',
			'population_id' => '4984',
			'bank' => null,
			'bank_cert' => null,
			'bank_cert_dir' => null,
			'bank_cert_status' => null,
			'file_dni' => null,
			'file_dni_dir' => null,
			'writers' => null,
			'writers_dir' => null,
			'split_id' => null,
			'created' => '2017-10-02 10:04:09',
			'modified' => '2018-07-10 20:03:31',
			'sms' => null,
			'fulladdress' => 'C/Cervantes, 17, Cardedeu ( 08440 ) , Barcelona',
			'link' => 'https://www.fisiosite.com/fisioterapia/cardedeu/homefisio-cardedeu',
			'path_cert' => '/var/www/fisiosite.com/webroot//files/establishment/bank_cert//',
			'path_dni' => '/var/www/fisiosite.com/webroot//files/establishment/file_dni//',
			'path_writers' => '/var/www/fisiosite.com/webroot//files/establishment/writers//',
			'rating' => false,
			'is_open' => false
		),
		'Category' => array(
			'id' => '1',
			'name' => 'FISIOTERAPIA',
			'slug' => 'fisioterapia',
			'description' => '',
			'parent_id' => '31',
			'created' => '2016-06-13 12:15:16',
			'modified' => '2016-06-13 12:15:16',
			'lft' => '2',
			'rght' => '3'
		),
		'EstablishmentsCategory' => array(
			'id' => null,
			'establishment_id' => null,
			'category_id' => null,
			'created' => null,
			'modified' => null
		),
		'Service' => array(),
		'Slide' => array(
			'id' => null,
			'model' => null,
			'foreign_key' => null,
			'name' => null,
			'attachment' => null,
			'dir' => null,
			'type' => null,
			'size' => null,
			'active' => null
		),
		(int) 0 => array(
			'have_date' => '0'
		),
		'Comment' => array(),
		'Staff' => array(),
		'Slots' => array()
	),
	(int) 5 => array(
		'Establishment' => array(
			'id' => '10396',
			'name' => 'Onco Cardedeu-Baix Montseny',
			'category_id' => '30',
			'establishment_type' => '1',
			'image' => null,
			'image_dir' => null,
			'web' => 'http://www.oncocardedeu.cat/',
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => null,
			'address1' => 'Àngel Guimera 144',
			'address2' => '',
			'email' => 'oncocardedeu@gmail.com',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '660 45 48 54',
			'phone2' => '',
			'zipcode' => '08440',
			'town' => 'Cardedeu',
			'state' => 'Barcelona',
			'country' => 'España',
			'latitude' => '41.640781',
			'longitude' => '2.359496',
			'slug' => null,
			'canonical' => 'fisioterapia-oncologica/cardedeu/onco-cardedeu-baix-montseny',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => '8ac8b548d4762d75da965be01850bc40',
			'hash_old' => null,
			'deleted' => false,
			'deleterequest' => null,
			'user_id' => null,
			'plan_id' => null,
			'next_plan_id' => null,
			'video' => null,
			'pinterest' => null,
			'googleplus' => null,
			'youtube' => null,
			'linkedin' => null,
			'facebook' => null,
			'twitter' => null,
			'status' => '1',
			'subscription_status' => '0',
			'subscription_id' => '0',
			'population_id' => '4984',
			'bank' => null,
			'bank_cert' => null,
			'bank_cert_dir' => null,
			'bank_cert_status' => null,
			'file_dni' => null,
			'file_dni_dir' => null,
			'writers' => null,
			'writers_dir' => null,
			'split_id' => null,
			'created' => '2017-10-02 10:04:13',
			'modified' => '2018-07-10 20:03:31',
			'sms' => null,
			'fulladdress' => 'Àngel Guimera 144, Cardedeu ( 08440 ) , Barcelona',
			'link' => 'https://www.fisiosite.com/fisioterapia-oncologica/cardedeu/onco-cardedeu-baix-montseny',
			'path_cert' => '/var/www/fisiosite.com/webroot//files/establishment/bank_cert//',
			'path_dni' => '/var/www/fisiosite.com/webroot//files/establishment/file_dni//',
			'path_writers' => '/var/www/fisiosite.com/webroot//files/establishment/writers//',
			'rating' => false,
			'is_open' => false
		),
		'Category' => array(
			'id' => '30',
			'name' => 'FISIOTERAPIA ONCOLOGICA',
			'slug' => 'fisioterapia-oncologica',
			'description' => '',
			'parent_id' => '1',
			'created' => '2016-06-13 12:15:17',
			'modified' => '2016-06-13 12:15:17',
			'lft' => '58',
			'rght' => '59'
		),
		'EstablishmentsCategory' => array(
			'id' => null,
			'establishment_id' => null,
			'category_id' => null,
			'created' => null,
			'modified' => null
		),
		'Service' => array(),
		'Slide' => array(
			'id' => null,
			'model' => null,
			'foreign_key' => null,
			'name' => null,
			'attachment' => null,
			'dir' => null,
			'type' => null,
			'size' => null,
			'active' => null
		),
		(int) 0 => array(
			'have_date' => '0'
		),
		'Comment' => array(),
		'Staff' => array(),
		'Slots' => array()
	),
	(int) 6 => array(
		'Establishment' => array(
			'id' => '10397',
			'name' => 'Núria López.',
			'category_id' => '1',
			'establishment_type' => '1',
			'image' => null,
			'image_dir' => null,
			'web' => '',
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => null,
			'address1' => 'Àngel Guimerà, 21',
			'address2' => '2n 1a',
			'email' => '',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '647 24 53 83',
			'phone2' => '',
			'zipcode' => '08440',
			'town' => 'Cardedeu',
			'state' => 'Barcelona',
			'country' => 'España',
			'latitude' => '41.637615',
			'longitude' => '2.359355',
			'slug' => null,
			'canonical' => 'fisioterapia/cardedeu/nuria-lopez',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => '7a7e0eecf51ea82b78030008aab2eaa8',
			'hash_old' => null,
			'deleted' => false,
			'deleterequest' => null,
			'user_id' => null,
			'plan_id' => null,
			'next_plan_id' => null,
			'video' => null,
			'pinterest' => null,
			'googleplus' => null,
			'youtube' => null,
			'linkedin' => null,
			'facebook' => null,
			'twitter' => null,
			'status' => '1',
			'subscription_status' => '0',
			'subscription_id' => '0',
			'population_id' => '4984',
			'bank' => null,
			'bank_cert' => null,
			'bank_cert_dir' => null,
			'bank_cert_status' => null,
			'file_dni' => null,
			'file_dni_dir' => null,
			'writers' => null,
			'writers_dir' => null,
			'split_id' => null,
			'created' => '2017-10-02 10:04:15',
			'modified' => '2018-07-10 20:03:32',
			'sms' => null,
			'fulladdress' => 'Àngel Guimerà, 21, Cardedeu ( 08440 ) , Barcelona',
			'link' => 'https://www.fisiosite.com/fisioterapia/cardedeu/nuria-lopez',
			'path_cert' => '/var/www/fisiosite.com/webroot//files/establishment/bank_cert//',
			'path_dni' => '/var/www/fisiosite.com/webroot//files/establishment/file_dni//',
			'path_writers' => '/var/www/fisiosite.com/webroot//files/establishment/writers//',
			'rating' => false,
			'is_open' => false
		),
		'Category' => array(
			'id' => '1',
			'name' => 'FISIOTERAPIA',
			'slug' => 'fisioterapia',
			'description' => '',
			'parent_id' => '31',
			'created' => '2016-06-13 12:15:16',
			'modified' => '2016-06-13 12:15:16',
			'lft' => '2',
			'rght' => '3'
		),
		'EstablishmentsCategory' => array(
			'id' => null,
			'establishment_id' => null,
			'category_id' => null,
			'created' => null,
			'modified' => null
		),
		'Service' => array(),
		'Slide' => array(
			'id' => null,
			'model' => null,
			'foreign_key' => null,
			'name' => null,
			'attachment' => null,
			'dir' => null,
			'type' => null,
			'size' => null,
			'active' => null
		),
		(int) 0 => array(
			'have_date' => '0'
		),
		'Comment' => array(),
		'Staff' => array(),
		'Slots' => array()
	),
	(int) 7 => array(
		'Establishment' => array(
			'id' => '10398',
			'name' => 'Eloi Anson Nebot',
			'category_id' => '14',
			'establishment_type' => '1',
			'image' => null,
			'image_dir' => null,
			'web' => '',
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => null,
			'address1' => 'Josep Vilaseca, 18',
			'address2' => 'Y 20',
			'email' => '',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '938477485',
			'phone2' => '',
			'zipcode' => '08440',
			'town' => 'Cardedeu',
			'state' => 'Barcelona',
			'country' => 'España',
			'latitude' => '41.638237',
			'longitude' => '2.354416',
			'slug' => null,
			'canonical' => 'osteopatia/cardedeu/eloi-anson-nebot',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => '7f10e9fdb02cc235b4f1214e4bb4a238',
			'hash_old' => null,
			'deleted' => false,
			'deleterequest' => null,
			'user_id' => null,
			'plan_id' => null,
			'next_plan_id' => null,
			'video' => null,
			'pinterest' => null,
			'googleplus' => null,
			'youtube' => null,
			'linkedin' => null,
			'facebook' => null,
			'twitter' => null,
			'status' => '1',
			'subscription_status' => '0',
			'subscription_id' => '0',
			'population_id' => '4984',
			'bank' => null,
			'bank_cert' => null,
			'bank_cert_dir' => null,
			'bank_cert_status' => null,
			'file_dni' => null,
			'file_dni_dir' => null,
			'writers' => null,
			'writers_dir' => null,
			'split_id' => null,
			'created' => '2017-10-02 10:04:17',
			'modified' => '2018-07-10 20:03:32',
			'sms' => null,
			'fulladdress' => 'Josep Vilaseca, 18, Cardedeu ( 08440 ) , Barcelona',
			'link' => 'https://www.fisiosite.com/osteopatia/cardedeu/eloi-anson-nebot',
			'path_cert' => '/var/www/fisiosite.com/webroot//files/establishment/bank_cert//',
			'path_dni' => '/var/www/fisiosite.com/webroot//files/establishment/file_dni//',
			'path_writers' => '/var/www/fisiosite.com/webroot//files/establishment/writers//'
		),
		'Category' => array(
			'id' => '14',
			'name' => 'OSTEOPATIA',
			'slug' => 'osteopatia',
			'description' => '',
			'parent_id' => '1',
			'created' => '2016-06-13 12:15:16',
			'modified' => '2016-06-13 12:15:16',
			'lft' => '26',
			'rght' => '27'
		),
		'EstablishmentsCategory' => array(
			'id' => null,
			'establishment_id' => null,
			'category_id' => null,
			'created' => null,
			'modified' => null
		),
		'Service' => array(
			'id' => null,
			'name' => null,
			'description' => null,
			'duration_reserved' => null,
			'duration' => null,
			'price' => null,
			'slots' => null,
			'pay_online' => null,
			'establishment_id' => null,
			'created_status' => null,
			'tag' => null,
			'created' => null,
			'modified' => null
		),
		'Slide' => array(
			'id' => null,
			'model' => null,
			'foreign_key' => null,
			'name' => null,
			'attachment' => null,
			'dir' => null,
			'type' => null,
			'size' => null,
			'active' => null
		),
		(int) 0 => array(
			'have_date' => '0'
		),
		'Comment' => array(),
		'Staff' => array()
	)
)
$n_establishments = (int) 8
$e = array(
	'Establishment' => array(
		'id' => '10397',
		'name' => 'Núria López.',
		'category_id' => '1',
		'establishment_type' => '1',
		'image' => null,
		'image_dir' => null,
		'web' => '',
		'short_description' => null,
		'description' => null,
		'fiscalnumber' => null,
		'address1' => 'Àngel Guimerà, 21',
		'address2' => '2n 1a',
		'email' => '',
		'fax' => null,
		'mobile' => '',
		'mobile2' => '',
		'phone' => '647 24 53 83',
		'phone2' => '',
		'zipcode' => '08440',
		'town' => 'Cardedeu',
		'state' => 'Barcelona',
		'country' => 'España',
		'latitude' => '41.637615',
		'longitude' => '2.359355',
		'slug' => null,
		'canonical' => 'fisioterapia/cardedeu/nuria-lopez',
		'canonical_old' => null,
		'timetable' => null,
		'hash' => '7a7e0eecf51ea82b78030008aab2eaa8',
		'hash_old' => null,
		'deleted' => false,
		'deleterequest' => null,
		'user_id' => null,
		'plan_id' => null,
		'next_plan_id' => null,
		'video' => null,
		'pinterest' => null,
		'googleplus' => null,
		'youtube' => null,
		'linkedin' => null,
		'facebook' => null,
		'twitter' => null,
		'status' => '1',
		'subscription_status' => '0',
		'subscription_id' => '0',
		'population_id' => '4984',
		'bank' => null,
		'bank_cert' => null,
		'bank_cert_dir' => null,
		'bank_cert_status' => null,
		'file_dni' => null,
		'file_dni_dir' => null,
		'writers' => null,
		'writers_dir' => null,
		'split_id' => null,
		'created' => '2017-10-02 10:04:15',
		'modified' => '2018-07-10 20:03:32',
		'sms' => null,
		'fulladdress' => 'Àngel Guimerà, 21, Cardedeu ( 08440 ) , Barcelona',
		'link' => 'https://www.fisiosite.com/fisioterapia/cardedeu/nuria-lopez',
		'path_cert' => '/var/www/fisiosite.com/webroot//files/establishment/bank_cert//',
		'path_dni' => '/var/www/fisiosite.com/webroot//files/establishment/file_dni//',
		'path_writers' => '/var/www/fisiosite.com/webroot//files/establishment/writers//'
	),
	'Category' => array(
		'id' => '1',
		'name' => 'FISIOTERAPIA',
		'slug' => 'fisioterapia',
		'description' => '',
		'parent_id' => '31',
		'created' => '2016-06-13 12:15:16',
		'modified' => '2016-06-13 12:15:16',
		'lft' => '2',
		'rght' => '3'
	),
	'EstablishmentsCategory' => array(
		'id' => null,
		'establishment_id' => null,
		'category_id' => null,
		'created' => null,
		'modified' => null
	),
	'Service' => array(
		'id' => null,
		'name' => null,
		'description' => null,
		'duration_reserved' => null,
		'duration' => null,
		'price' => null,
		'slots' => null,
		'pay_online' => null,
		'establishment_id' => null,
		'created_status' => null,
		'tag' => null,
		'created' => null,
		'modified' => null
	),
	'Slide' => array(
		'id' => null,
		'model' => null,
		'foreign_key' => null,
		'name' => null,
		'attachment' => null,
		'dir' => null,
		'type' => null,
		'size' => null,
		'active' => null
	),
	(int) 0 => array(
		'have_date' => '0'
	),
	'Comment' => array(),
	'Staff' => array()
)
$comments = array()
SearchController::search_establishments() - APP/Controller/SearchController.php, line 957
SearchController::query() - APP/Controller/SearchController.php, line 1041
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - APP/Vendor/cakephp/cakephp/lib/Cake/Controller/Controller.php, line 490
Dispatcher::_invoke() - APP/Vendor/cakephp/cakephp/lib/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - APP/Vendor/cakephp/cakephp/lib/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 133

Notice (8): Undefined variable: establishment [APP/Controller/SearchController.php, line 957]
Code Context

            // Quitamos los serficios que no tienen profesionales asignados
            if ($establishment[$key]['Service']) {
$page = (int) 1
$date_slot = ''
$conditions = array(
	'Establishment.population_id' => '4984'
)
$query_establishments = array(
	'Establishment.population_id' => '4984'
)
$key = (int) 7
$value = '4984'
$conditions_price = ''
$day = false
$datetotime = false
$hour = false
$index_dates = false
$fields = '*, IF (Establishment.id in (	select s.establishment_id from
                (select * from services where price > 0) s
                inner join timetables t on t.object='Service' and t.object_id = s.id
                inner join establishments e on s.establishment_id = e.id and plan_id > 0
                inner join timetables te on te.object='Establishment' and te.object_id = e.id
                inner join services_staffs st on st.service_id = s.id
                  inner join staffs on staffs.id = st.staff_id
                  inner join services_staffs stst on stst.staff_id = st.staff_id
                  inner join timetables s_t on s_t.object='Staff' and s_t.object_id = staffs.id
                ),1,0) as have_date '
$field = 'page'
$order = array(
	'have_date' => 'desc',
	'plan_id' => 'desc'
)
$establishments = array(
	(int) 0 => array(
		'Establishment' => array(
			'id' => '1968',
			'name' => 'FISIOTERAPIAS, SCP',
			'category_id' => '1',
			'establishment_type' => '1',
			'image' => null,
			'image_dir' => null,
			'web' => null,
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => '',
			'address1' => 'Carrer Esteve Barange, 18',
			'address2' => '',
			'email' => null,
			'fax' => null,
			'mobile' => '',
			'mobile2' => null,
			'phone' => '938713748',
			'phone2' => null,
			'zipcode' => '08440',
			'town' => 'Cardedeu',
			'state' => 'Barcelona',
			'country' => 'España',
			'latitude' => '41.638924',
			'longitude' => '2.360464',
			'slug' => 'fisioterapias-scp-carrer-esteve-barange',
			'canonical' => 'fisioterapia/cardedeu/fisioterapias-scp',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => '0d5bb5358202b889c58eb5b7ac767239',
			'hash_old' => null,
			'deleted' => false,
			'deleterequest' => null,
			'user_id' => null,
			'plan_id' => '1',
			'next_plan_id' => null,
			'video' => null,
			'pinterest' => null,
			'googleplus' => null,
			'youtube' => null,
			'linkedin' => null,
			'facebook' => null,
			'twitter' => null,
			'status' => '1',
			'subscription_status' => '0',
			'subscription_id' => '0',
			'population_id' => '4984',
			'bank' => null,
			'bank_cert' => null,
			'bank_cert_dir' => null,
			'bank_cert_status' => null,
			'file_dni' => null,
			'file_dni_dir' => null,
			'writers' => null,
			'writers_dir' => null,
			'split_id' => null,
			'created' => '2016-07-07 13:12:19',
			'modified' => '2018-07-10 19:41:49',
			'sms' => null,
			'fulladdress' => 'Carrer Esteve Barange, 18, Cardedeu ( 08440 ) , Barcelona',
			'link' => 'https://www.fisiosite.com/fisioterapia/cardedeu/fisioterapias-scp',
			'path_cert' => '/var/www/fisiosite.com/webroot//files/establishment/bank_cert//',
			'path_dni' => '/var/www/fisiosite.com/webroot//files/establishment/file_dni//',
			'path_writers' => '/var/www/fisiosite.com/webroot//files/establishment/writers//',
			'rating' => false,
			'is_open' => false
		),
		'Category' => array(
			'id' => '1',
			'name' => 'FISIOTERAPIA',
			'slug' => 'fisioterapia',
			'description' => '',
			'parent_id' => '31',
			'created' => '2016-06-13 12:15:16',
			'modified' => '2016-06-13 12:15:16',
			'lft' => '2',
			'rght' => '3'
		),
		'EstablishmentsCategory' => array(
			'id' => null,
			'establishment_id' => null,
			'category_id' => null,
			'created' => null,
			'modified' => null
		),
		'Service' => array(),
		'Slide' => array(
			'id' => null,
			'model' => null,
			'foreign_key' => null,
			'name' => null,
			'attachment' => null,
			'dir' => null,
			'type' => null,
			'size' => null,
			'active' => null
		),
		(int) 0 => array(
			'have_date' => '0'
		),
		'Comment' => array(),
		'Staff' => array(),
		'Slots' => array()
	),
	(int) 1 => array(
		'Establishment' => array(
			'id' => '12555',
			'name' => 'lea',
			'category_id' => '1',
			'establishment_type' => '3',
			'image' => null,
			'image_dir' => null,
			'web' => '',
			'short_description' => null,
			'description' => 'Tractaments de pluripatologies.',
			'fiscalnumber' => '43432994r',
			'address1' => 'calle st josep oriol',
			'address2' => '',
			'email' => 'leabcn@yahoo.es',
			'fax' => null,
			'mobile' => '',
			'mobile2' => null,
			'phone' => '',
			'phone2' => '619565893',
			'zipcode' => '08440',
			'town' => 'Cardedeu',
			'state' => 'Barcelona',
			'country' => '',
			'latitude' => null,
			'longitude' => null,
			'slug' => null,
			'canonical' => 'fisioterapia/cardedeu/lea',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => '8ed820be12be334e66d731218a3ad0fc',
			'hash_old' => null,
			'deleted' => false,
			'deleterequest' => null,
			'user_id' => '5f7ce9fa-5d5c-4e8f-be6e-694e335b89d7',
			'plan_id' => '1',
			'next_plan_id' => null,
			'video' => null,
			'pinterest' => null,
			'googleplus' => null,
			'youtube' => null,
			'linkedin' => null,
			'facebook' => null,
			'twitter' => null,
			'status' => '1',
			'subscription_status' => null,
			'subscription_id' => null,
			'population_id' => '4984',
			'bank' => '',
			'bank_cert' => null,
			'bank_cert_dir' => null,
			'bank_cert_status' => null,
			'file_dni' => null,
			'file_dni_dir' => null,
			'writers' => null,
			'writers_dir' => null,
			'split_id' => null,
			'created' => '2020-10-07 00:12:45',
			'modified' => '2020-10-07 09:59:50',
			'sms' => null,
			'fulladdress' => 'calle st josep oriol, Cardedeu ( 08440 ) , Barcelona',
			'link' => 'https://www.fisiosite.com/fisioterapia/cardedeu/lea',
			'path_cert' => '/var/www/fisiosite.com/webroot//files/establishment/bank_cert//',
			'path_dni' => '/var/www/fisiosite.com/webroot//files/establishment/file_dni//',
			'path_writers' => '/var/www/fisiosite.com/webroot//files/establishment/writers//',
			'rating' => false,
			'is_open' => false
		),
		'Category' => array(
			'id' => '1',
			'name' => 'FISIOTERAPIA',
			'slug' => 'fisioterapia',
			'description' => '',
			'parent_id' => '31',
			'created' => '2016-06-13 12:15:16',
			'modified' => '2016-06-13 12:15:16',
			'lft' => '2',
			'rght' => '3'
		),
		'EstablishmentsCategory' => array(
			'id' => null,
			'establishment_id' => null,
			'category_id' => null,
			'created' => null,
			'modified' => null
		),
		'Service' => array(),
		'Slide' => array(
			'id' => null,
			'model' => null,
			'foreign_key' => null,
			'name' => null,
			'attachment' => null,
			'dir' => null,
			'type' => null,
			'size' => null,
			'active' => null
		),
		(int) 0 => array(
			'have_date' => '0'
		),
		'Comment' => array(),
		'Staff' => array(),
		'Slots' => array()
	),
	(int) 2 => array(
		'Establishment' => array(
			'id' => '10393',
			'name' => 'Fisioterapias P',
			'category_id' => '1',
			'establishment_type' => '1',
			'image' => null,
			'image_dir' => null,
			'web' => '',
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => null,
			'address1' => 'Carrer Barangé, 18',
			'address2' => '',
			'email' => '',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '938 71 37 48',
			'phone2' => '',
			'zipcode' => '08440',
			'town' => 'Cardedeu',
			'state' => 'Barcelona',
			'country' => 'España',
			'latitude' => '41.638866',
			'longitude' => '2.360579',
			'slug' => null,
			'canonical' => 'fisioterapia/cardedeu/fisioterapias-p',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => 'b6be25713db847e99bdc9b22cb578a10',
			'hash_old' => null,
			'deleted' => false,
			'deleterequest' => null,
			'user_id' => null,
			'plan_id' => null,
			'next_plan_id' => null,
			'video' => null,
			'pinterest' => null,
			'googleplus' => null,
			'youtube' => null,
			'linkedin' => null,
			'facebook' => null,
			'twitter' => null,
			'status' => '1',
			'subscription_status' => '0',
			'subscription_id' => '0',
			'population_id' => '4984',
			'bank' => null,
			'bank_cert' => null,
			'bank_cert_dir' => null,
			'bank_cert_status' => null,
			'file_dni' => null,
			'file_dni_dir' => null,
			'writers' => null,
			'writers_dir' => null,
			'split_id' => null,
			'created' => '2017-10-02 10:04:01',
			'modified' => '2018-07-10 20:03:31',
			'sms' => null,
			'fulladdress' => 'Carrer Barangé, 18, Cardedeu ( 08440 ) , Barcelona',
			'link' => 'https://www.fisiosite.com/fisioterapia/cardedeu/fisioterapias-p',
			'path_cert' => '/var/www/fisiosite.com/webroot//files/establishment/bank_cert//',
			'path_dni' => '/var/www/fisiosite.com/webroot//files/establishment/file_dni//',
			'path_writers' => '/var/www/fisiosite.com/webroot//files/establishment/writers//',
			'rating' => false,
			'is_open' => false
		),
		'Category' => array(
			'id' => '1',
			'name' => 'FISIOTERAPIA',
			'slug' => 'fisioterapia',
			'description' => '',
			'parent_id' => '31',
			'created' => '2016-06-13 12:15:16',
			'modified' => '2016-06-13 12:15:16',
			'lft' => '2',
			'rght' => '3'
		),
		'EstablishmentsCategory' => array(
			'id' => null,
			'establishment_id' => null,
			'category_id' => null,
			'created' => null,
			'modified' => null
		),
		'Service' => array(),
		'Slide' => array(
			'id' => null,
			'model' => null,
			'foreign_key' => null,
			'name' => null,
			'attachment' => null,
			'dir' => null,
			'type' => null,
			'size' => null,
			'active' => null
		),
		(int) 0 => array(
			'have_date' => '0'
		),
		'Comment' => array(),
		'Staff' => array(),
		'Slots' => array()
	),
	(int) 3 => array(
		'Establishment' => array(
			'id' => '10394',
			'name' => 'Carles Sunyer Oller',
			'category_id' => '1',
			'establishment_type' => '1',
			'image' => null,
			'image_dir' => null,
			'web' => '',
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => null,
			'address1' => 'Carrer Llinars, 68',
			'address2' => '',
			'email' => '',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '938 44 46 67',
			'phone2' => '',
			'zipcode' => '08440',
			'town' => 'Cardedeu',
			'state' => 'Barcelona',
			'country' => 'España',
			'latitude' => '41.637371',
			'longitude' => '2.362430',
			'slug' => null,
			'canonical' => 'fisioterapia/cardedeu/carles-sunyer-oller',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => 'af7d084353ad76401075c68c027f56ee',
			'hash_old' => null,
			'deleted' => false,
			'deleterequest' => null,
			'user_id' => null,
			'plan_id' => null,
			'next_plan_id' => null,
			'video' => null,
			'pinterest' => null,
			'googleplus' => null,
			'youtube' => null,
			'linkedin' => null,
			'facebook' => null,
			'twitter' => null,
			'status' => '1',
			'subscription_status' => '0',
			'subscription_id' => '0',
			'population_id' => '4984',
			'bank' => null,
			'bank_cert' => null,
			'bank_cert_dir' => null,
			'bank_cert_status' => null,
			'file_dni' => null,
			'file_dni_dir' => null,
			'writers' => null,
			'writers_dir' => null,
			'split_id' => null,
			'created' => '2017-10-02 10:04:06',
			'modified' => '2018-07-10 20:03:31',
			'sms' => null,
			'fulladdress' => 'Carrer Llinars, 68, Cardedeu ( 08440 ) , Barcelona',
			'link' => 'https://www.fisiosite.com/fisioterapia/cardedeu/carles-sunyer-oller',
			'path_cert' => '/var/www/fisiosite.com/webroot//files/establishment/bank_cert//',
			'path_dni' => '/var/www/fisiosite.com/webroot//files/establishment/file_dni//',
			'path_writers' => '/var/www/fisiosite.com/webroot//files/establishment/writers//',
			'rating' => false,
			'is_open' => false
		),
		'Category' => array(
			'id' => '1',
			'name' => 'FISIOTERAPIA',
			'slug' => 'fisioterapia',
			'description' => '',
			'parent_id' => '31',
			'created' => '2016-06-13 12:15:16',
			'modified' => '2016-06-13 12:15:16',
			'lft' => '2',
			'rght' => '3'
		),
		'EstablishmentsCategory' => array(
			'id' => null,
			'establishment_id' => null,
			'category_id' => null,
			'created' => null,
			'modified' => null
		),
		'Service' => array(),
		'Slide' => array(
			'id' => null,
			'model' => null,
			'foreign_key' => null,
			'name' => null,
			'attachment' => null,
			'dir' => null,
			'type' => null,
			'size' => null,
			'active' => null
		),
		(int) 0 => array(
			'have_date' => '0'
		),
		'Comment' => array(),
		'Staff' => array(),
		'Slots' => array()
	),
	(int) 4 => array(
		'Establishment' => array(
			'id' => '10395',
			'name' => 'Homefisio Cardedeu',
			'category_id' => '1',
			'establishment_type' => '1',
			'image' => null,
			'image_dir' => null,
			'web' => 'http://homeofisiocardedeu.blogspot.com.es',
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => null,
			'address1' => 'C/Cervantes, 17',
			'address2' => '',
			'email' => '',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '627 909 953',
			'phone2' => '610 607 185',
			'zipcode' => '08440',
			'town' => 'Cardedeu',
			'state' => 'Barcelona',
			'country' => 'España',
			'latitude' => '41.640320',
			'longitude' => '2.356590',
			'slug' => null,
			'canonical' => 'fisioterapia/cardedeu/homefisio-cardedeu',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => '744778f8fc1c9f1398d5190f0fc97b93',
			'hash_old' => null,
			'deleted' => false,
			'deleterequest' => null,
			'user_id' => null,
			'plan_id' => null,
			'next_plan_id' => null,
			'video' => null,
			'pinterest' => null,
			'googleplus' => null,
			'youtube' => null,
			'linkedin' => null,
			'facebook' => null,
			'twitter' => null,
			'status' => '1',
			'subscription_status' => '0',
			'subscription_id' => '0',
			'population_id' => '4984',
			'bank' => null,
			'bank_cert' => null,
			'bank_cert_dir' => null,
			'bank_cert_status' => null,
			'file_dni' => null,
			'file_dni_dir' => null,
			'writers' => null,
			'writers_dir' => null,
			'split_id' => null,
			'created' => '2017-10-02 10:04:09',
			'modified' => '2018-07-10 20:03:31',
			'sms' => null,
			'fulladdress' => 'C/Cervantes, 17, Cardedeu ( 08440 ) , Barcelona',
			'link' => 'https://www.fisiosite.com/fisioterapia/cardedeu/homefisio-cardedeu',
			'path_cert' => '/var/www/fisiosite.com/webroot//files/establishment/bank_cert//',
			'path_dni' => '/var/www/fisiosite.com/webroot//files/establishment/file_dni//',
			'path_writers' => '/var/www/fisiosite.com/webroot//files/establishment/writers//',
			'rating' => false,
			'is_open' => false
		),
		'Category' => array(
			'id' => '1',
			'name' => 'FISIOTERAPIA',
			'slug' => 'fisioterapia',
			'description' => '',
			'parent_id' => '31',
			'created' => '2016-06-13 12:15:16',
			'modified' => '2016-06-13 12:15:16',
			'lft' => '2',
			'rght' => '3'
		),
		'EstablishmentsCategory' => array(
			'id' => null,
			'establishment_id' => null,
			'category_id' => null,
			'created' => null,
			'modified' => null
		),
		'Service' => array(),
		'Slide' => array(
			'id' => null,
			'model' => null,
			'foreign_key' => null,
			'name' => null,
			'attachment' => null,
			'dir' => null,
			'type' => null,
			'size' => null,
			'active' => null
		),
		(int) 0 => array(
			'have_date' => '0'
		),
		'Comment' => array(),
		'Staff' => array(),
		'Slots' => array()
	),
	(int) 5 => array(
		'Establishment' => array(
			'id' => '10396',
			'name' => 'Onco Cardedeu-Baix Montseny',
			'category_id' => '30',
			'establishment_type' => '1',
			'image' => null,
			'image_dir' => null,
			'web' => 'http://www.oncocardedeu.cat/',
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => null,
			'address1' => 'Àngel Guimera 144',
			'address2' => '',
			'email' => 'oncocardedeu@gmail.com',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '660 45 48 54',
			'phone2' => '',
			'zipcode' => '08440',
			'town' => 'Cardedeu',
			'state' => 'Barcelona',
			'country' => 'España',
			'latitude' => '41.640781',
			'longitude' => '2.359496',
			'slug' => null,
			'canonical' => 'fisioterapia-oncologica/cardedeu/onco-cardedeu-baix-montseny',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => '8ac8b548d4762d75da965be01850bc40',
			'hash_old' => null,
			'deleted' => false,
			'deleterequest' => null,
			'user_id' => null,
			'plan_id' => null,
			'next_plan_id' => null,
			'video' => null,
			'pinterest' => null,
			'googleplus' => null,
			'youtube' => null,
			'linkedin' => null,
			'facebook' => null,
			'twitter' => null,
			'status' => '1',
			'subscription_status' => '0',
			'subscription_id' => '0',
			'population_id' => '4984',
			'bank' => null,
			'bank_cert' => null,
			'bank_cert_dir' => null,
			'bank_cert_status' => null,
			'file_dni' => null,
			'file_dni_dir' => null,
			'writers' => null,
			'writers_dir' => null,
			'split_id' => null,
			'created' => '2017-10-02 10:04:13',
			'modified' => '2018-07-10 20:03:31',
			'sms' => null,
			'fulladdress' => 'Àngel Guimera 144, Cardedeu ( 08440 ) , Barcelona',
			'link' => 'https://www.fisiosite.com/fisioterapia-oncologica/cardedeu/onco-cardedeu-baix-montseny',
			'path_cert' => '/var/www/fisiosite.com/webroot//files/establishment/bank_cert//',
			'path_dni' => '/var/www/fisiosite.com/webroot//files/establishment/file_dni//',
			'path_writers' => '/var/www/fisiosite.com/webroot//files/establishment/writers//',
			'rating' => false,
			'is_open' => false
		),
		'Category' => array(
			'id' => '30',
			'name' => 'FISIOTERAPIA ONCOLOGICA',
			'slug' => 'fisioterapia-oncologica',
			'description' => '',
			'parent_id' => '1',
			'created' => '2016-06-13 12:15:17',
			'modified' => '2016-06-13 12:15:17',
			'lft' => '58',
			'rght' => '59'
		),
		'EstablishmentsCategory' => array(
			'id' => null,
			'establishment_id' => null,
			'category_id' => null,
			'created' => null,
			'modified' => null
		),
		'Service' => array(),
		'Slide' => array(
			'id' => null,
			'model' => null,
			'foreign_key' => null,
			'name' => null,
			'attachment' => null,
			'dir' => null,
			'type' => null,
			'size' => null,
			'active' => null
		),
		(int) 0 => array(
			'have_date' => '0'
		),
		'Comment' => array(),
		'Staff' => array(),
		'Slots' => array()
	),
	(int) 6 => array(
		'Establishment' => array(
			'id' => '10397',
			'name' => 'Núria López.',
			'category_id' => '1',
			'establishment_type' => '1',
			'image' => null,
			'image_dir' => null,
			'web' => '',
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => null,
			'address1' => 'Àngel Guimerà, 21',
			'address2' => '2n 1a',
			'email' => '',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '647 24 53 83',
			'phone2' => '',
			'zipcode' => '08440',
			'town' => 'Cardedeu',
			'state' => 'Barcelona',
			'country' => 'España',
			'latitude' => '41.637615',
			'longitude' => '2.359355',
			'slug' => null,
			'canonical' => 'fisioterapia/cardedeu/nuria-lopez',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => '7a7e0eecf51ea82b78030008aab2eaa8',
			'hash_old' => null,
			'deleted' => false,
			'deleterequest' => null,
			'user_id' => null,
			'plan_id' => null,
			'next_plan_id' => null,
			'video' => null,
			'pinterest' => null,
			'googleplus' => null,
			'youtube' => null,
			'linkedin' => null,
			'facebook' => null,
			'twitter' => null,
			'status' => '1',
			'subscription_status' => '0',
			'subscription_id' => '0',
			'population_id' => '4984',
			'bank' => null,
			'bank_cert' => null,
			'bank_cert_dir' => null,
			'bank_cert_status' => null,
			'file_dni' => null,
			'file_dni_dir' => null,
			'writers' => null,
			'writers_dir' => null,
			'split_id' => null,
			'created' => '2017-10-02 10:04:15',
			'modified' => '2018-07-10 20:03:32',
			'sms' => null,
			'fulladdress' => 'Àngel Guimerà, 21, Cardedeu ( 08440 ) , Barcelona',
			'link' => 'https://www.fisiosite.com/fisioterapia/cardedeu/nuria-lopez',
			'path_cert' => '/var/www/fisiosite.com/webroot//files/establishment/bank_cert//',
			'path_dni' => '/var/www/fisiosite.com/webroot//files/establishment/file_dni//',
			'path_writers' => '/var/www/fisiosite.com/webroot//files/establishment/writers//',
			'rating' => false,
			'is_open' => false
		),
		'Category' => array(
			'id' => '1',
			'name' => 'FISIOTERAPIA',
			'slug' => 'fisioterapia',
			'description' => '',
			'parent_id' => '31',
			'created' => '2016-06-13 12:15:16',
			'modified' => '2016-06-13 12:15:16',
			'lft' => '2',
			'rght' => '3'
		),
		'EstablishmentsCategory' => array(
			'id' => null,
			'establishment_id' => null,
			'category_id' => null,
			'created' => null,
			'modified' => null
		),
		'Service' => array(),
		'Slide' => array(
			'id' => null,
			'model' => null,
			'foreign_key' => null,
			'name' => null,
			'attachment' => null,
			'dir' => null,
			'type' => null,
			'size' => null,
			'active' => null
		),
		(int) 0 => array(
			'have_date' => '0'
		),
		'Comment' => array(),
		'Staff' => array(),
		'Slots' => array()
	),
	(int) 7 => array(
		'Establishment' => array(
			'id' => '10398',
			'name' => 'Eloi Anson Nebot',
			'category_id' => '14',
			'establishment_type' => '1',
			'image' => null,
			'image_dir' => null,
			'web' => '',
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => null,
			'address1' => 'Josep Vilaseca, 18',
			'address2' => 'Y 20',
			'email' => '',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '938477485',
			'phone2' => '',
			'zipcode' => '08440',
			'town' => 'Cardedeu',
			'state' => 'Barcelona',
			'country' => 'España',
			'latitude' => '41.638237',
			'longitude' => '2.354416',
			'slug' => null,
			'canonical' => 'osteopatia/cardedeu/eloi-anson-nebot',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => '7f10e9fdb02cc235b4f1214e4bb4a238',
			'hash_old' => null,
			'deleted' => false,
			'deleterequest' => null,
			'user_id' => null,
			'plan_id' => null,
			'next_plan_id' => null,
			'video' => null,
			'pinterest' => null,
			'googleplus' => null,
			'youtube' => null,
			'linkedin' => null,
			'facebook' => null,
			'twitter' => null,
			'status' => '1',
			'subscription_status' => '0',
			'subscription_id' => '0',
			'population_id' => '4984',
			'bank' => null,
			'bank_cert' => null,
			'bank_cert_dir' => null,
			'bank_cert_status' => null,
			'file_dni' => null,
			'file_dni_dir' => null,
			'writers' => null,
			'writers_dir' => null,
			'split_id' => null,
			'created' => '2017-10-02 10:04:17',
			'modified' => '2018-07-10 20:03:32',
			'sms' => null,
			'fulladdress' => 'Josep Vilaseca, 18, Cardedeu ( 08440 ) , Barcelona',
			'link' => 'https://www.fisiosite.com/osteopatia/cardedeu/eloi-anson-nebot',
			'path_cert' => '/var/www/fisiosite.com/webroot//files/establishment/bank_cert//',
			'path_dni' => '/var/www/fisiosite.com/webroot//files/establishment/file_dni//',
			'path_writers' => '/var/www/fisiosite.com/webroot//files/establishment/writers//',
			'rating' => false,
			'is_open' => false
		),
		'Category' => array(
			'id' => '14',
			'name' => 'OSTEOPATIA',
			'slug' => 'osteopatia',
			'description' => '',
			'parent_id' => '1',
			'created' => '2016-06-13 12:15:16',
			'modified' => '2016-06-13 12:15:16',
			'lft' => '26',
			'rght' => '27'
		),
		'EstablishmentsCategory' => array(
			'id' => null,
			'establishment_id' => null,
			'category_id' => null,
			'created' => null,
			'modified' => null
		),
		'Service' => array(),
		'Slide' => array(
			'id' => null,
			'model' => null,
			'foreign_key' => null,
			'name' => null,
			'attachment' => null,
			'dir' => null,
			'type' => null,
			'size' => null,
			'active' => null
		),
		(int) 0 => array(
			'have_date' => '0'
		),
		'Comment' => array(),
		'Staff' => array(),
		'Slots' => array()
	)
)
$n_establishments = (int) 8
$e = array(
	'Establishment' => array(
		'id' => '10398',
		'name' => 'Eloi Anson Nebot',
		'category_id' => '14',
		'establishment_type' => '1',
		'image' => null,
		'image_dir' => null,
		'web' => '',
		'short_description' => null,
		'description' => null,
		'fiscalnumber' => null,
		'address1' => 'Josep Vilaseca, 18',
		'address2' => 'Y 20',
		'email' => '',
		'fax' => null,
		'mobile' => '',
		'mobile2' => '',
		'phone' => '938477485',
		'phone2' => '',
		'zipcode' => '08440',
		'town' => 'Cardedeu',
		'state' => 'Barcelona',
		'country' => 'España',
		'latitude' => '41.638237',
		'longitude' => '2.354416',
		'slug' => null,
		'canonical' => 'osteopatia/cardedeu/eloi-anson-nebot',
		'canonical_old' => null,
		'timetable' => null,
		'hash' => '7f10e9fdb02cc235b4f1214e4bb4a238',
		'hash_old' => null,
		'deleted' => false,
		'deleterequest' => null,
		'user_id' => null,
		'plan_id' => null,
		'next_plan_id' => null,
		'video' => null,
		'pinterest' => null,
		'googleplus' => null,
		'youtube' => null,
		'linkedin' => null,
		'facebook' => null,
		'twitter' => null,
		'status' => '1',
		'subscription_status' => '0',
		'subscription_id' => '0',
		'population_id' => '4984',
		'bank' => null,
		'bank_cert' => null,
		'bank_cert_dir' => null,
		'bank_cert_status' => null,
		'file_dni' => null,
		'file_dni_dir' => null,
		'writers' => null,
		'writers_dir' => null,
		'split_id' => null,
		'created' => '2017-10-02 10:04:17',
		'modified' => '2018-07-10 20:03:32',
		'sms' => null,
		'fulladdress' => 'Josep Vilaseca, 18, Cardedeu ( 08440 ) , Barcelona',
		'link' => 'https://www.fisiosite.com/osteopatia/cardedeu/eloi-anson-nebot',
		'path_cert' => '/var/www/fisiosite.com/webroot//files/establishment/bank_cert//',
		'path_dni' => '/var/www/fisiosite.com/webroot//files/establishment/file_dni//',
		'path_writers' => '/var/www/fisiosite.com/webroot//files/establishment/writers//'
	),
	'Category' => array(
		'id' => '14',
		'name' => 'OSTEOPATIA',
		'slug' => 'osteopatia',
		'description' => '',
		'parent_id' => '1',
		'created' => '2016-06-13 12:15:16',
		'modified' => '2016-06-13 12:15:16',
		'lft' => '26',
		'rght' => '27'
	),
	'EstablishmentsCategory' => array(
		'id' => null,
		'establishment_id' => null,
		'category_id' => null,
		'created' => null,
		'modified' => null
	),
	'Service' => array(
		'id' => null,
		'name' => null,
		'description' => null,
		'duration_reserved' => null,
		'duration' => null,
		'price' => null,
		'slots' => null,
		'pay_online' => null,
		'establishment_id' => null,
		'created_status' => null,
		'tag' => null,
		'created' => null,
		'modified' => null
	),
	'Slide' => array(
		'id' => null,
		'model' => null,
		'foreign_key' => null,
		'name' => null,
		'attachment' => null,
		'dir' => null,
		'type' => null,
		'size' => null,
		'active' => null
	),
	(int) 0 => array(
		'have_date' => '0'
	),
	'Comment' => array(),
	'Staff' => array()
)
$comments = array()
SearchController::search_establishments() - APP/Controller/SearchController.php, line 957
SearchController::query() - APP/Controller/SearchController.php, line 1041
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - APP/Vendor/cakephp/cakephp/lib/Cake/Controller/Controller.php, line 490
Dispatcher::_invoke() - APP/Vendor/cakephp/cakephp/lib/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - APP/Vendor/cakephp/cakephp/lib/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 133

Warning (2): Cannot modify header information - headers already sent by (output started at /var/www/fisiosite.com/Vendor/cakephp/cakephp/lib/Cake/Utility/Debugger.php:800) [APP/Vendor/cakephp/cakephp/lib/Cake/Network/CakeResponse.php, line 449]
Code Context
                $name, $c['value'], $c['expire'], $c['path'],
                $c['domain'], $c['secure'], $c['httpOnly']
            );
$name = 'User[lang]'
$c = array(
	'name' => 'User[lang]',
	'value' => 'es_ES',
	'expire' => '1628941842',
	'path' => '/',
	'domain' => '',
	'secure' => false,
	'httpOnly' => false
)
setcookie - [internal], line ??
CakeResponse::_setCookies() - APP/Vendor/cakephp/cakephp/lib/Cake/Network/CakeResponse.php, line 449
CakeResponse::send() - APP/Vendor/cakephp/cakephp/lib/Cake/Network/CakeResponse.php, line 419
Dispatcher::dispatch() - APP/Vendor/cakephp/cakephp/lib/Cake/Routing/Dispatcher.php, line 174
[main] - APP/webroot/index.php, line 133

Warning (2): Cannot modify header information - headers already sent by (output started at /var/www/fisiosite.com/Vendor/cakephp/cakephp/lib/Cake/Utility/Debugger.php:800) [APP/Vendor/cakephp/cakephp/lib/Cake/Network/CakeResponse.php, line 449]
Code Context
                $name, $c['value'], $c['expire'], $c['path'],
                $c['domain'], $c['secure'], $c['httpOnly']
            );
$name = 'User[is_login]'
$c = array(
	'name' => 'User[is_login]',
	'value' => '',
	'expire' => (int) 1627171842,
	'path' => '/',
	'domain' => '',
	'secure' => false,
	'httpOnly' => false
)
setcookie - [internal], line ??
CakeResponse::_setCookies() - APP/Vendor/cakephp/cakephp/lib/Cake/Network/CakeResponse.php, line 449
CakeResponse::send() - APP/Vendor/cakephp/cakephp/lib/Cake/Network/CakeResponse.php, line 419
Dispatcher::dispatch() - APP/Vendor/cakephp/cakephp/lib/Cake/Routing/Dispatcher.php, line 174
[main] - APP/webroot/index.php, line 133

fisiosite

Clínicas de fisioterapia en Cardedeu

Aquí te mostramos las 8 clínicas encontradas de fisioterapia en Cardedeu

Ver filtros Ver mapa

AMPLIAR MAPA

Filtra tu búsqueda Elige municipio

¿Dónde quieres tu cita?

• En clínica
• A domicilio
• Todos

¿Tipo de especialidad?

• Todas
• Fisioterapia
• Fisioterapia En La Actividad Fisica Y Deporte
• Fisioterapia Veterinaria
• Fisioterapia Respiratoria
• Fisioterapia Geriátrica
• Fisioterapia Neurológica
• Osteopatia
• Fisioterapia Pediátrica
• Pilates
• Fisioterapia Uroginecológica
• Fisioterapia Traumatologica
• Fisioterapeuta-osteópata
• Fisioterapia Oncologica

Por precio

• Cualquiera
• Menos de 30€
• De 30€ a 40€
• De 40€ a 50€
• Más de 50€

1

Fisioterapias, scp Carrer Esteve Barange, 18, Cardedeu ( 08440 ) , Barcelona
Fisioterapia

Sin valoraciones
(0) Comentarios

2

Lea calle st josep oriol, Cardedeu ( 08440 ) , Barcelona
Fisioterapia

Sin valoraciones
(0) Comentarios

3

Fisioterapias p Carrer Barangé, 18, Cardedeu ( 08440 ) , Barcelona
Fisioterapia

Sin valoraciones
(0) Comentarios

4

Carles sunyer oller Carrer Llinars, 68, Cardedeu ( 08440 ) , Barcelona
Fisioterapia

Sin valoraciones
(0) Comentarios

5

Homefisio cardedeu C/Cervantes, 17, Cardedeu ( 08440 ) , Barcelona
Fisioterapia

Sin valoraciones
(0) Comentarios

6

Onco cardedeu-baix montseny Àngel Guimera 144, Cardedeu ( 08440 ) , Barcelona
Fisioterapia oncologica

Sin valoraciones
(0) Comentarios

7

Núria lópez. Àngel Guimerà, 21, Cardedeu ( 08440 ) , Barcelona
Fisioterapia

Sin valoraciones
(0) Comentarios

8

Eloi anson nebot Josep Vilaseca, 18, Cardedeu ( 08440 ) , Barcelona
Osteopatia

Sin valoraciones
(0) Comentarios

¿Eres fisioterapeuta? Únete a Fisiosite
Mejora tu presencia en Internet
y accede a más pacientes

Quiero unirme

Nuestros Partners

Condiciones de uso - Política de privacidad