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' => '7666'
)
$query_establishments = array(
	'Establishment.population_id' => '7666'
)
$key = (int) 0
$value = '7666'
$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' => '8950',
			'name' => 'FISIONOVA',
			'category_id' => '1',
			'establishment_type' => '1',
			'image' => null,
			'image_dir' => null,
			'web' => 'http://www.fisionova.es',
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => null,
			'address1' => 'Plaza Nueva, 6',
			'address2' => '',
			'email' => '',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '639775840',
			'phone2' => '',
			'zipcode' => '03300',
			'town' => 'Orihuela',
			'state' => 'Alicante',
			'country' => 'España',
			'latitude' => '38.084587',
			'longitude' => '-0.947126',
			'slug' => null,
			'canonical' => 'fisioterapia/orihuela/fisionova',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => '5f2fe0aef24996cae4feaca99d442a45',
			'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' => '7666',
			'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-09-04 11:39:16',
			'modified' => '2018-07-10 19:57:21',
			'sms' => null,
			'fulladdress' => 'Plaza Nueva, 6, Orihuela ( 03300 ) , Alicante',
			'link' => 'https://www.fisiosite.com/fisioterapia/orihuela/fisionova',
			'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' => '8951',
			'name' => 'FISIOCEN',
			'category_id' => '1',
			'establishment_type' => '1',
			'image' => null,
			'image_dir' => null,
			'web' => 'http://www.fisiocenorihuela.com',
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => null,
			'address1' => 'Limón, 6',
			'address2' => '',
			'email' => 'info@fisiocenorihuela.com',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '966736326',
			'phone2' => '',
			'zipcode' => '03300',
			'town' => 'Orihuela',
			'state' => 'Alicante',
			'country' => 'España',
			'latitude' => '38.080601',
			'longitude' => '-0.946006',
			'slug' => null,
			'canonical' => 'fisioterapia/orihuela/fisiocen',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => '877617f40b423f002eeff91ba3e8c574',
			'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' => '7666',
			'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-09-04 11:39:20',
			'modified' => '2018-07-10 19:57:22',
			'sms' => null,
			'fulladdress' => 'Limón, 6, Orihuela ( 03300 ) , Alicante',
			'link' => 'https://www.fisiosite.com/fisioterapia/orihuela/fisiocen',
			'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' => '8952',
			'name' => 'PURI',
			'category_id' => '1',
			'establishment_type' => '1',
			'image' => null,
			'image_dir' => null,
			'web' => '',
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => null,
			'address1' => 'Jade (La Zenia II), 20',
			'address2' => '',
			'email' => '',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '966760752',
			'phone2' => '',
			'zipcode' => '03189',
			'town' => 'Orihuela',
			'state' => 'Alicante',
			'country' => 'España',
			'latitude' => '37.929626',
			'longitude' => '-0.735187',
			'slug' => null,
			'canonical' => 'fisioterapia/orihuela/puri',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => '1e2dd25a94784389f0bf825b9060634e',
			'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' => '7666',
			'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-09-04 11:39:25',
			'modified' => '2018-07-10 19:57:22',
			'sms' => null,
			'fulladdress' => 'Jade (La Zenia II), 20, Orihuela ( 03189 ) , Alicante',
			'link' => 'https://www.fisiosite.com/fisioterapia/orihuela/puri',
			'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' => '8953',
			'name' => 'FISIOTERAPIA ZAFRA',
			'category_id' => '1',
			'establishment_type' => '1',
			'image' => null,
			'image_dir' => null,
			'web' => 'http://www.fisioterapiazafra.wordpress.com',
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => null,
			'address1' => 'C/ Campoamor Nº 2',
			'address2' => '',
			'email' => '',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '674 207 150',
			'phone2' => '',
			'zipcode' => '03300',
			'town' => 'Orihuela',
			'state' => 'Alicante',
			'country' => 'España',
			'latitude' => '38.083038',
			'longitude' => '-0.944446',
			'slug' => null,
			'canonical' => 'fisioterapia/orihuela/fisioterapia-zafra',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => 'ed176cf015f9033d263d4bfd0eae898b',
			'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' => '7666',
			'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-09-04 11:39:31',
			'modified' => '2018-07-10 19:57:22',
			'sms' => null,
			'fulladdress' => 'C/ Campoamor Nº 2, Orihuela ( 03300 ) , Alicante',
			'link' => 'https://www.fisiosite.com/fisioterapia/orihuela/fisioterapia-zafra',
			'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' => '8954',
			'name' => 'CLÍNICA DE FISIOTERAPIA REYMA',
			'category_id' => '1',
			'establishment_type' => '1',
			'image' => null,
			'image_dir' => null,
			'web' => 'http://www.fisioreyma.com',
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => null,
			'address1' => 'C/ Lavatorio Nº5',
			'address2' => '',
			'email' => 'fisioreyma@hotmail.com',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '96 674 23 21',
			'phone2' => '',
			'zipcode' => '03300',
			'town' => 'Orihuela',
			'state' => 'Alicante',
			'country' => 'España',
			'latitude' => '38.081390',
			'longitude' => '-0.941793',
			'slug' => null,
			'canonical' => 'fisioterapia/orihuela/clinica-de-fisioterapia-reyma',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => '40a56d42a575776242af2393b15a789b',
			'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' => '7666',
			'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-09-04 11:39:35',
			'modified' => '2018-07-10 19:57:22',
			'sms' => null,
			'fulladdress' => 'C/ Lavatorio Nº5, Orihuela ( 03300 ) , Alicante',
			'link' => 'https://www.fisiosite.com/fisioterapia/orihuela/clinica-de-fisioterapia-reyma',
			'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' => '9330',
			'name' => 'PHYSIOTHERAPY AND OSTEOPATHY CLINIC,S. L.',
			'category_id' => '1',
			'establishment_type' => '1',
			'image' => null,
			'image_dir' => null,
			'web' => '',
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => null,
			'address1' => 'Picasso, 1',
			'address2' => '(La Zenia II)',
			'email' => 'info@physiostropath.com',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '966730153',
			'phone2' => '',
			'zipcode' => '03189',
			'town' => 'Orihuela',
			'state' => 'Alicante',
			'country' => 'España',
			'latitude' => '37.921253',
			'longitude' => '-0.732702',
			'slug' => null,
			'canonical' => 'fisioterapia/orihuela/physiotherapy-and-osteopathy-clinic-s-l',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => 'e8e1ebb7f6df881b9f18d39f12a1ab50',
			'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' => '7666',
			'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-09-04 16:23:10',
			'modified' => '2018-07-10 19:58:52',
			'sms' => null,
			'fulladdress' => 'Picasso, 1, Orihuela ( 03189 ) , Alicante',
			'link' => 'https://www.fisiosite.com/fisioterapia/orihuela/physiotherapy-and-osteopathy-clinic-s-l',
			'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) 6 => array(
		'Establishment' => array(
			'id' => '9331',
			'name' => 'PATRICIA MENÁRGUEZ FISIOTERAPIA Y OSTEOPATÍA',
			'category_id' => '1',
			'establishment_type' => '1',
			'image' => null,
			'image_dir' => null,
			'web' => 'http://www.pmfisioterapia.com',
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => null,
			'address1' => 'C/ Mancebería, 60',
			'address2' => '',
			'email' => 'info@pmfisioterapia.com',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '96 634 20 18',
			'phone2' => '',
			'zipcode' => '03300',
			'town' => 'Orihuela',
			'state' => 'Alicante',
			'country' => 'España',
			'latitude' => '38.083706',
			'longitude' => '-0.949462',
			'slug' => null,
			'canonical' => 'fisioterapia/orihuela/patricia-menarguez-fisioterapia-y-osteopatia',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => '69c1cdfe66724b75b06b34016ade17e5',
			'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' => '7666',
			'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-09-04 16:23:14',
			'modified' => '2018-07-10 19:58:53',
			'sms' => null,
			'fulladdress' => 'C/ Mancebería, 60, Orihuela ( 03300 ) , Alicante',
			'link' => 'https://www.fisiosite.com/fisioterapia/orihuela/patricia-menarguez-fisioterapia-y-osteopatia',
			'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' => '9344',
			'name' => 'CLÍNICA MARFIL',
			'category_id' => '1',
			'establishment_type' => '1',
			'image' => null,
			'image_dir' => null,
			'web' => 'http://www.clinicamarfilorihuela.es',
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => null,
			'address1' => 'C/. Avenida de España, 3',
			'address2' => 'Bajo',
			'email' => 'marfilplayasl@gmail.com',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '966936482',
			'phone2' => '',
			'zipcode' => '03300',
			'town' => 'Orihuela',
			'state' => 'Alicante',
			'country' => 'España',
			'latitude' => '38.083027',
			'longitude' => '-0.946121',
			'slug' => null,
			'canonical' => 'fisioterapia/orihuela/clinica-marfil',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => '141a51eabc000d38494ecbc84051b7b4',
			'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' => '7666',
			'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-09-04 16:37:05',
			'modified' => '2018-07-10 19:58:56',
			'sms' => null,
			'fulladdress' => 'C/. Avenida de España, 3, Orihuela ( 03300 ) , Alicante',
			'link' => 'https://www.fisiosite.com/fisioterapia/orihuela/clinica-marfil',
			'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()
	)
)
$n_establishments = (int) 8
$e = array(
	'Establishment' => array(
		'id' => '8950',
		'name' => 'FISIONOVA',
		'category_id' => '1',
		'establishment_type' => '1',
		'image' => null,
		'image_dir' => null,
		'web' => 'http://www.fisionova.es',
		'short_description' => null,
		'description' => null,
		'fiscalnumber' => null,
		'address1' => 'Plaza Nueva, 6',
		'address2' => '',
		'email' => '',
		'fax' => null,
		'mobile' => '',
		'mobile2' => '',
		'phone' => '639775840',
		'phone2' => '',
		'zipcode' => '03300',
		'town' => 'Orihuela',
		'state' => 'Alicante',
		'country' => 'España',
		'latitude' => '38.084587',
		'longitude' => '-0.947126',
		'slug' => null,
		'canonical' => 'fisioterapia/orihuela/fisionova',
		'canonical_old' => null,
		'timetable' => null,
		'hash' => '5f2fe0aef24996cae4feaca99d442a45',
		'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' => '7666',
		'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-09-04 11:39:16',
		'modified' => '2018-07-10 19:57:21',
		'sms' => null,
		'fulladdress' => 'Plaza Nueva, 6, Orihuela ( 03300 ) , Alicante',
		'link' => 'https://www.fisiosite.com/fisioterapia/orihuela/fisionova',
		'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' => '7666'
)
$query_establishments = array(
	'Establishment.population_id' => '7666'
)
$key = (int) 1
$value = '7666'
$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' => '8950',
			'name' => 'FISIONOVA',
			'category_id' => '1',
			'establishment_type' => '1',
			'image' => null,
			'image_dir' => null,
			'web' => 'http://www.fisionova.es',
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => null,
			'address1' => 'Plaza Nueva, 6',
			'address2' => '',
			'email' => '',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '639775840',
			'phone2' => '',
			'zipcode' => '03300',
			'town' => 'Orihuela',
			'state' => 'Alicante',
			'country' => 'España',
			'latitude' => '38.084587',
			'longitude' => '-0.947126',
			'slug' => null,
			'canonical' => 'fisioterapia/orihuela/fisionova',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => '5f2fe0aef24996cae4feaca99d442a45',
			'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' => '7666',
			'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-09-04 11:39:16',
			'modified' => '2018-07-10 19:57:21',
			'sms' => null,
			'fulladdress' => 'Plaza Nueva, 6, Orihuela ( 03300 ) , Alicante',
			'link' => 'https://www.fisiosite.com/fisioterapia/orihuela/fisionova',
			'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' => '8951',
			'name' => 'FISIOCEN',
			'category_id' => '1',
			'establishment_type' => '1',
			'image' => null,
			'image_dir' => null,
			'web' => 'http://www.fisiocenorihuela.com',
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => null,
			'address1' => 'Limón, 6',
			'address2' => '',
			'email' => 'info@fisiocenorihuela.com',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '966736326',
			'phone2' => '',
			'zipcode' => '03300',
			'town' => 'Orihuela',
			'state' => 'Alicante',
			'country' => 'España',
			'latitude' => '38.080601',
			'longitude' => '-0.946006',
			'slug' => null,
			'canonical' => 'fisioterapia/orihuela/fisiocen',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => '877617f40b423f002eeff91ba3e8c574',
			'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' => '7666',
			'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-09-04 11:39:20',
			'modified' => '2018-07-10 19:57:22',
			'sms' => null,
			'fulladdress' => 'Limón, 6, Orihuela ( 03300 ) , Alicante',
			'link' => 'https://www.fisiosite.com/fisioterapia/orihuela/fisiocen',
			'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' => '8952',
			'name' => 'PURI',
			'category_id' => '1',
			'establishment_type' => '1',
			'image' => null,
			'image_dir' => null,
			'web' => '',
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => null,
			'address1' => 'Jade (La Zenia II), 20',
			'address2' => '',
			'email' => '',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '966760752',
			'phone2' => '',
			'zipcode' => '03189',
			'town' => 'Orihuela',
			'state' => 'Alicante',
			'country' => 'España',
			'latitude' => '37.929626',
			'longitude' => '-0.735187',
			'slug' => null,
			'canonical' => 'fisioterapia/orihuela/puri',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => '1e2dd25a94784389f0bf825b9060634e',
			'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' => '7666',
			'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-09-04 11:39:25',
			'modified' => '2018-07-10 19:57:22',
			'sms' => null,
			'fulladdress' => 'Jade (La Zenia II), 20, Orihuela ( 03189 ) , Alicante',
			'link' => 'https://www.fisiosite.com/fisioterapia/orihuela/puri',
			'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' => '8953',
			'name' => 'FISIOTERAPIA ZAFRA',
			'category_id' => '1',
			'establishment_type' => '1',
			'image' => null,
			'image_dir' => null,
			'web' => 'http://www.fisioterapiazafra.wordpress.com',
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => null,
			'address1' => 'C/ Campoamor Nº 2',
			'address2' => '',
			'email' => '',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '674 207 150',
			'phone2' => '',
			'zipcode' => '03300',
			'town' => 'Orihuela',
			'state' => 'Alicante',
			'country' => 'España',
			'latitude' => '38.083038',
			'longitude' => '-0.944446',
			'slug' => null,
			'canonical' => 'fisioterapia/orihuela/fisioterapia-zafra',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => 'ed176cf015f9033d263d4bfd0eae898b',
			'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' => '7666',
			'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-09-04 11:39:31',
			'modified' => '2018-07-10 19:57:22',
			'sms' => null,
			'fulladdress' => 'C/ Campoamor Nº 2, Orihuela ( 03300 ) , Alicante',
			'link' => 'https://www.fisiosite.com/fisioterapia/orihuela/fisioterapia-zafra',
			'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' => '8954',
			'name' => 'CLÍNICA DE FISIOTERAPIA REYMA',
			'category_id' => '1',
			'establishment_type' => '1',
			'image' => null,
			'image_dir' => null,
			'web' => 'http://www.fisioreyma.com',
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => null,
			'address1' => 'C/ Lavatorio Nº5',
			'address2' => '',
			'email' => 'fisioreyma@hotmail.com',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '96 674 23 21',
			'phone2' => '',
			'zipcode' => '03300',
			'town' => 'Orihuela',
			'state' => 'Alicante',
			'country' => 'España',
			'latitude' => '38.081390',
			'longitude' => '-0.941793',
			'slug' => null,
			'canonical' => 'fisioterapia/orihuela/clinica-de-fisioterapia-reyma',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => '40a56d42a575776242af2393b15a789b',
			'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' => '7666',
			'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-09-04 11:39:35',
			'modified' => '2018-07-10 19:57:22',
			'sms' => null,
			'fulladdress' => 'C/ Lavatorio Nº5, Orihuela ( 03300 ) , Alicante',
			'link' => 'https://www.fisiosite.com/fisioterapia/orihuela/clinica-de-fisioterapia-reyma',
			'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' => '9330',
			'name' => 'PHYSIOTHERAPY AND OSTEOPATHY CLINIC,S. L.',
			'category_id' => '1',
			'establishment_type' => '1',
			'image' => null,
			'image_dir' => null,
			'web' => '',
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => null,
			'address1' => 'Picasso, 1',
			'address2' => '(La Zenia II)',
			'email' => 'info@physiostropath.com',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '966730153',
			'phone2' => '',
			'zipcode' => '03189',
			'town' => 'Orihuela',
			'state' => 'Alicante',
			'country' => 'España',
			'latitude' => '37.921253',
			'longitude' => '-0.732702',
			'slug' => null,
			'canonical' => 'fisioterapia/orihuela/physiotherapy-and-osteopathy-clinic-s-l',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => 'e8e1ebb7f6df881b9f18d39f12a1ab50',
			'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' => '7666',
			'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-09-04 16:23:10',
			'modified' => '2018-07-10 19:58:52',
			'sms' => null,
			'fulladdress' => 'Picasso, 1, Orihuela ( 03189 ) , Alicante',
			'link' => 'https://www.fisiosite.com/fisioterapia/orihuela/physiotherapy-and-osteopathy-clinic-s-l',
			'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) 6 => array(
		'Establishment' => array(
			'id' => '9331',
			'name' => 'PATRICIA MENÁRGUEZ FISIOTERAPIA Y OSTEOPATÍA',
			'category_id' => '1',
			'establishment_type' => '1',
			'image' => null,
			'image_dir' => null,
			'web' => 'http://www.pmfisioterapia.com',
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => null,
			'address1' => 'C/ Mancebería, 60',
			'address2' => '',
			'email' => 'info@pmfisioterapia.com',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '96 634 20 18',
			'phone2' => '',
			'zipcode' => '03300',
			'town' => 'Orihuela',
			'state' => 'Alicante',
			'country' => 'España',
			'latitude' => '38.083706',
			'longitude' => '-0.949462',
			'slug' => null,
			'canonical' => 'fisioterapia/orihuela/patricia-menarguez-fisioterapia-y-osteopatia',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => '69c1cdfe66724b75b06b34016ade17e5',
			'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' => '7666',
			'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-09-04 16:23:14',
			'modified' => '2018-07-10 19:58:53',
			'sms' => null,
			'fulladdress' => 'C/ Mancebería, 60, Orihuela ( 03300 ) , Alicante',
			'link' => 'https://www.fisiosite.com/fisioterapia/orihuela/patricia-menarguez-fisioterapia-y-osteopatia',
			'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' => '9344',
			'name' => 'CLÍNICA MARFIL',
			'category_id' => '1',
			'establishment_type' => '1',
			'image' => null,
			'image_dir' => null,
			'web' => 'http://www.clinicamarfilorihuela.es',
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => null,
			'address1' => 'C/. Avenida de España, 3',
			'address2' => 'Bajo',
			'email' => 'marfilplayasl@gmail.com',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '966936482',
			'phone2' => '',
			'zipcode' => '03300',
			'town' => 'Orihuela',
			'state' => 'Alicante',
			'country' => 'España',
			'latitude' => '38.083027',
			'longitude' => '-0.946121',
			'slug' => null,
			'canonical' => 'fisioterapia/orihuela/clinica-marfil',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => '141a51eabc000d38494ecbc84051b7b4',
			'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' => '7666',
			'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-09-04 16:37:05',
			'modified' => '2018-07-10 19:58:56',
			'sms' => null,
			'fulladdress' => 'C/. Avenida de España, 3, Orihuela ( 03300 ) , Alicante',
			'link' => 'https://www.fisiosite.com/fisioterapia/orihuela/clinica-marfil',
			'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()
	)
)
$n_establishments = (int) 8
$e = array(
	'Establishment' => array(
		'id' => '8951',
		'name' => 'FISIOCEN',
		'category_id' => '1',
		'establishment_type' => '1',
		'image' => null,
		'image_dir' => null,
		'web' => 'http://www.fisiocenorihuela.com',
		'short_description' => null,
		'description' => null,
		'fiscalnumber' => null,
		'address1' => 'Limón, 6',
		'address2' => '',
		'email' => 'info@fisiocenorihuela.com',
		'fax' => null,
		'mobile' => '',
		'mobile2' => '',
		'phone' => '966736326',
		'phone2' => '',
		'zipcode' => '03300',
		'town' => 'Orihuela',
		'state' => 'Alicante',
		'country' => 'España',
		'latitude' => '38.080601',
		'longitude' => '-0.946006',
		'slug' => null,
		'canonical' => 'fisioterapia/orihuela/fisiocen',
		'canonical_old' => null,
		'timetable' => null,
		'hash' => '877617f40b423f002eeff91ba3e8c574',
		'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' => '7666',
		'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-09-04 11:39:20',
		'modified' => '2018-07-10 19:57:22',
		'sms' => null,
		'fulladdress' => 'Limón, 6, Orihuela ( 03300 ) , Alicante',
		'link' => 'https://www.fisiosite.com/fisioterapia/orihuela/fisiocen',
		'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' => '7666'
)
$query_establishments = array(
	'Establishment.population_id' => '7666'
)
$key = (int) 2
$value = '7666'
$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' => '8950',
			'name' => 'FISIONOVA',
			'category_id' => '1',
			'establishment_type' => '1',
			'image' => null,
			'image_dir' => null,
			'web' => 'http://www.fisionova.es',
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => null,
			'address1' => 'Plaza Nueva, 6',
			'address2' => '',
			'email' => '',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '639775840',
			'phone2' => '',
			'zipcode' => '03300',
			'town' => 'Orihuela',
			'state' => 'Alicante',
			'country' => 'España',
			'latitude' => '38.084587',
			'longitude' => '-0.947126',
			'slug' => null,
			'canonical' => 'fisioterapia/orihuela/fisionova',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => '5f2fe0aef24996cae4feaca99d442a45',
			'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' => '7666',
			'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-09-04 11:39:16',
			'modified' => '2018-07-10 19:57:21',
			'sms' => null,
			'fulladdress' => 'Plaza Nueva, 6, Orihuela ( 03300 ) , Alicante',
			'link' => 'https://www.fisiosite.com/fisioterapia/orihuela/fisionova',
			'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' => '8951',
			'name' => 'FISIOCEN',
			'category_id' => '1',
			'establishment_type' => '1',
			'image' => null,
			'image_dir' => null,
			'web' => 'http://www.fisiocenorihuela.com',
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => null,
			'address1' => 'Limón, 6',
			'address2' => '',
			'email' => 'info@fisiocenorihuela.com',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '966736326',
			'phone2' => '',
			'zipcode' => '03300',
			'town' => 'Orihuela',
			'state' => 'Alicante',
			'country' => 'España',
			'latitude' => '38.080601',
			'longitude' => '-0.946006',
			'slug' => null,
			'canonical' => 'fisioterapia/orihuela/fisiocen',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => '877617f40b423f002eeff91ba3e8c574',
			'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' => '7666',
			'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-09-04 11:39:20',
			'modified' => '2018-07-10 19:57:22',
			'sms' => null,
			'fulladdress' => 'Limón, 6, Orihuela ( 03300 ) , Alicante',
			'link' => 'https://www.fisiosite.com/fisioterapia/orihuela/fisiocen',
			'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' => '8952',
			'name' => 'PURI',
			'category_id' => '1',
			'establishment_type' => '1',
			'image' => null,
			'image_dir' => null,
			'web' => '',
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => null,
			'address1' => 'Jade (La Zenia II), 20',
			'address2' => '',
			'email' => '',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '966760752',
			'phone2' => '',
			'zipcode' => '03189',
			'town' => 'Orihuela',
			'state' => 'Alicante',
			'country' => 'España',
			'latitude' => '37.929626',
			'longitude' => '-0.735187',
			'slug' => null,
			'canonical' => 'fisioterapia/orihuela/puri',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => '1e2dd25a94784389f0bf825b9060634e',
			'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' => '7666',
			'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-09-04 11:39:25',
			'modified' => '2018-07-10 19:57:22',
			'sms' => null,
			'fulladdress' => 'Jade (La Zenia II), 20, Orihuela ( 03189 ) , Alicante',
			'link' => 'https://www.fisiosite.com/fisioterapia/orihuela/puri',
			'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' => '8953',
			'name' => 'FISIOTERAPIA ZAFRA',
			'category_id' => '1',
			'establishment_type' => '1',
			'image' => null,
			'image_dir' => null,
			'web' => 'http://www.fisioterapiazafra.wordpress.com',
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => null,
			'address1' => 'C/ Campoamor Nº 2',
			'address2' => '',
			'email' => '',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '674 207 150',
			'phone2' => '',
			'zipcode' => '03300',
			'town' => 'Orihuela',
			'state' => 'Alicante',
			'country' => 'España',
			'latitude' => '38.083038',
			'longitude' => '-0.944446',
			'slug' => null,
			'canonical' => 'fisioterapia/orihuela/fisioterapia-zafra',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => 'ed176cf015f9033d263d4bfd0eae898b',
			'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' => '7666',
			'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-09-04 11:39:31',
			'modified' => '2018-07-10 19:57:22',
			'sms' => null,
			'fulladdress' => 'C/ Campoamor Nº 2, Orihuela ( 03300 ) , Alicante',
			'link' => 'https://www.fisiosite.com/fisioterapia/orihuela/fisioterapia-zafra',
			'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' => '8954',
			'name' => 'CLÍNICA DE FISIOTERAPIA REYMA',
			'category_id' => '1',
			'establishment_type' => '1',
			'image' => null,
			'image_dir' => null,
			'web' => 'http://www.fisioreyma.com',
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => null,
			'address1' => 'C/ Lavatorio Nº5',
			'address2' => '',
			'email' => 'fisioreyma@hotmail.com',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '96 674 23 21',
			'phone2' => '',
			'zipcode' => '03300',
			'town' => 'Orihuela',
			'state' => 'Alicante',
			'country' => 'España',
			'latitude' => '38.081390',
			'longitude' => '-0.941793',
			'slug' => null,
			'canonical' => 'fisioterapia/orihuela/clinica-de-fisioterapia-reyma',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => '40a56d42a575776242af2393b15a789b',
			'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' => '7666',
			'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-09-04 11:39:35',
			'modified' => '2018-07-10 19:57:22',
			'sms' => null,
			'fulladdress' => 'C/ Lavatorio Nº5, Orihuela ( 03300 ) , Alicante',
			'link' => 'https://www.fisiosite.com/fisioterapia/orihuela/clinica-de-fisioterapia-reyma',
			'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' => '9330',
			'name' => 'PHYSIOTHERAPY AND OSTEOPATHY CLINIC,S. L.',
			'category_id' => '1',
			'establishment_type' => '1',
			'image' => null,
			'image_dir' => null,
			'web' => '',
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => null,
			'address1' => 'Picasso, 1',
			'address2' => '(La Zenia II)',
			'email' => 'info@physiostropath.com',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '966730153',
			'phone2' => '',
			'zipcode' => '03189',
			'town' => 'Orihuela',
			'state' => 'Alicante',
			'country' => 'España',
			'latitude' => '37.921253',
			'longitude' => '-0.732702',
			'slug' => null,
			'canonical' => 'fisioterapia/orihuela/physiotherapy-and-osteopathy-clinic-s-l',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => 'e8e1ebb7f6df881b9f18d39f12a1ab50',
			'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' => '7666',
			'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-09-04 16:23:10',
			'modified' => '2018-07-10 19:58:52',
			'sms' => null,
			'fulladdress' => 'Picasso, 1, Orihuela ( 03189 ) , Alicante',
			'link' => 'https://www.fisiosite.com/fisioterapia/orihuela/physiotherapy-and-osteopathy-clinic-s-l',
			'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) 6 => array(
		'Establishment' => array(
			'id' => '9331',
			'name' => 'PATRICIA MENÁRGUEZ FISIOTERAPIA Y OSTEOPATÍA',
			'category_id' => '1',
			'establishment_type' => '1',
			'image' => null,
			'image_dir' => null,
			'web' => 'http://www.pmfisioterapia.com',
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => null,
			'address1' => 'C/ Mancebería, 60',
			'address2' => '',
			'email' => 'info@pmfisioterapia.com',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '96 634 20 18',
			'phone2' => '',
			'zipcode' => '03300',
			'town' => 'Orihuela',
			'state' => 'Alicante',
			'country' => 'España',
			'latitude' => '38.083706',
			'longitude' => '-0.949462',
			'slug' => null,
			'canonical' => 'fisioterapia/orihuela/patricia-menarguez-fisioterapia-y-osteopatia',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => '69c1cdfe66724b75b06b34016ade17e5',
			'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' => '7666',
			'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-09-04 16:23:14',
			'modified' => '2018-07-10 19:58:53',
			'sms' => null,
			'fulladdress' => 'C/ Mancebería, 60, Orihuela ( 03300 ) , Alicante',
			'link' => 'https://www.fisiosite.com/fisioterapia/orihuela/patricia-menarguez-fisioterapia-y-osteopatia',
			'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' => '9344',
			'name' => 'CLÍNICA MARFIL',
			'category_id' => '1',
			'establishment_type' => '1',
			'image' => null,
			'image_dir' => null,
			'web' => 'http://www.clinicamarfilorihuela.es',
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => null,
			'address1' => 'C/. Avenida de España, 3',
			'address2' => 'Bajo',
			'email' => 'marfilplayasl@gmail.com',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '966936482',
			'phone2' => '',
			'zipcode' => '03300',
			'town' => 'Orihuela',
			'state' => 'Alicante',
			'country' => 'España',
			'latitude' => '38.083027',
			'longitude' => '-0.946121',
			'slug' => null,
			'canonical' => 'fisioterapia/orihuela/clinica-marfil',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => '141a51eabc000d38494ecbc84051b7b4',
			'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' => '7666',
			'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-09-04 16:37:05',
			'modified' => '2018-07-10 19:58:56',
			'sms' => null,
			'fulladdress' => 'C/. Avenida de España, 3, Orihuela ( 03300 ) , Alicante',
			'link' => 'https://www.fisiosite.com/fisioterapia/orihuela/clinica-marfil',
			'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()
	)
)
$n_establishments = (int) 8
$e = array(
	'Establishment' => array(
		'id' => '8952',
		'name' => 'PURI',
		'category_id' => '1',
		'establishment_type' => '1',
		'image' => null,
		'image_dir' => null,
		'web' => '',
		'short_description' => null,
		'description' => null,
		'fiscalnumber' => null,
		'address1' => 'Jade (La Zenia II), 20',
		'address2' => '',
		'email' => '',
		'fax' => null,
		'mobile' => '',
		'mobile2' => '',
		'phone' => '966760752',
		'phone2' => '',
		'zipcode' => '03189',
		'town' => 'Orihuela',
		'state' => 'Alicante',
		'country' => 'España',
		'latitude' => '37.929626',
		'longitude' => '-0.735187',
		'slug' => null,
		'canonical' => 'fisioterapia/orihuela/puri',
		'canonical_old' => null,
		'timetable' => null,
		'hash' => '1e2dd25a94784389f0bf825b9060634e',
		'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' => '7666',
		'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-09-04 11:39:25',
		'modified' => '2018-07-10 19:57:22',
		'sms' => null,
		'fulladdress' => 'Jade (La Zenia II), 20, Orihuela ( 03189 ) , Alicante',
		'link' => 'https://www.fisiosite.com/fisioterapia/orihuela/puri',
		'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' => '7666'
)
$query_establishments = array(
	'Establishment.population_id' => '7666'
)
$key = (int) 3
$value = '7666'
$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' => '8950',
			'name' => 'FISIONOVA',
			'category_id' => '1',
			'establishment_type' => '1',
			'image' => null,
			'image_dir' => null,
			'web' => 'http://www.fisionova.es',
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => null,
			'address1' => 'Plaza Nueva, 6',
			'address2' => '',
			'email' => '',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '639775840',
			'phone2' => '',
			'zipcode' => '03300',
			'town' => 'Orihuela',
			'state' => 'Alicante',
			'country' => 'España',
			'latitude' => '38.084587',
			'longitude' => '-0.947126',
			'slug' => null,
			'canonical' => 'fisioterapia/orihuela/fisionova',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => '5f2fe0aef24996cae4feaca99d442a45',
			'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' => '7666',
			'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-09-04 11:39:16',
			'modified' => '2018-07-10 19:57:21',
			'sms' => null,
			'fulladdress' => 'Plaza Nueva, 6, Orihuela ( 03300 ) , Alicante',
			'link' => 'https://www.fisiosite.com/fisioterapia/orihuela/fisionova',
			'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' => '8951',
			'name' => 'FISIOCEN',
			'category_id' => '1',
			'establishment_type' => '1',
			'image' => null,
			'image_dir' => null,
			'web' => 'http://www.fisiocenorihuela.com',
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => null,
			'address1' => 'Limón, 6',
			'address2' => '',
			'email' => 'info@fisiocenorihuela.com',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '966736326',
			'phone2' => '',
			'zipcode' => '03300',
			'town' => 'Orihuela',
			'state' => 'Alicante',
			'country' => 'España',
			'latitude' => '38.080601',
			'longitude' => '-0.946006',
			'slug' => null,
			'canonical' => 'fisioterapia/orihuela/fisiocen',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => '877617f40b423f002eeff91ba3e8c574',
			'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' => '7666',
			'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-09-04 11:39:20',
			'modified' => '2018-07-10 19:57:22',
			'sms' => null,
			'fulladdress' => 'Limón, 6, Orihuela ( 03300 ) , Alicante',
			'link' => 'https://www.fisiosite.com/fisioterapia/orihuela/fisiocen',
			'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' => '8952',
			'name' => 'PURI',
			'category_id' => '1',
			'establishment_type' => '1',
			'image' => null,
			'image_dir' => null,
			'web' => '',
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => null,
			'address1' => 'Jade (La Zenia II), 20',
			'address2' => '',
			'email' => '',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '966760752',
			'phone2' => '',
			'zipcode' => '03189',
			'town' => 'Orihuela',
			'state' => 'Alicante',
			'country' => 'España',
			'latitude' => '37.929626',
			'longitude' => '-0.735187',
			'slug' => null,
			'canonical' => 'fisioterapia/orihuela/puri',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => '1e2dd25a94784389f0bf825b9060634e',
			'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' => '7666',
			'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-09-04 11:39:25',
			'modified' => '2018-07-10 19:57:22',
			'sms' => null,
			'fulladdress' => 'Jade (La Zenia II), 20, Orihuela ( 03189 ) , Alicante',
			'link' => 'https://www.fisiosite.com/fisioterapia/orihuela/puri',
			'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' => '8953',
			'name' => 'FISIOTERAPIA ZAFRA',
			'category_id' => '1',
			'establishment_type' => '1',
			'image' => null,
			'image_dir' => null,
			'web' => 'http://www.fisioterapiazafra.wordpress.com',
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => null,
			'address1' => 'C/ Campoamor Nº 2',
			'address2' => '',
			'email' => '',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '674 207 150',
			'phone2' => '',
			'zipcode' => '03300',
			'town' => 'Orihuela',
			'state' => 'Alicante',
			'country' => 'España',
			'latitude' => '38.083038',
			'longitude' => '-0.944446',
			'slug' => null,
			'canonical' => 'fisioterapia/orihuela/fisioterapia-zafra',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => 'ed176cf015f9033d263d4bfd0eae898b',
			'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' => '7666',
			'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-09-04 11:39:31',
			'modified' => '2018-07-10 19:57:22',
			'sms' => null,
			'fulladdress' => 'C/ Campoamor Nº 2, Orihuela ( 03300 ) , Alicante',
			'link' => 'https://www.fisiosite.com/fisioterapia/orihuela/fisioterapia-zafra',
			'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' => '8954',
			'name' => 'CLÍNICA DE FISIOTERAPIA REYMA',
			'category_id' => '1',
			'establishment_type' => '1',
			'image' => null,
			'image_dir' => null,
			'web' => 'http://www.fisioreyma.com',
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => null,
			'address1' => 'C/ Lavatorio Nº5',
			'address2' => '',
			'email' => 'fisioreyma@hotmail.com',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '96 674 23 21',
			'phone2' => '',
			'zipcode' => '03300',
			'town' => 'Orihuela',
			'state' => 'Alicante',
			'country' => 'España',
			'latitude' => '38.081390',
			'longitude' => '-0.941793',
			'slug' => null,
			'canonical' => 'fisioterapia/orihuela/clinica-de-fisioterapia-reyma',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => '40a56d42a575776242af2393b15a789b',
			'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' => '7666',
			'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-09-04 11:39:35',
			'modified' => '2018-07-10 19:57:22',
			'sms' => null,
			'fulladdress' => 'C/ Lavatorio Nº5, Orihuela ( 03300 ) , Alicante',
			'link' => 'https://www.fisiosite.com/fisioterapia/orihuela/clinica-de-fisioterapia-reyma',
			'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' => '9330',
			'name' => 'PHYSIOTHERAPY AND OSTEOPATHY CLINIC,S. L.',
			'category_id' => '1',
			'establishment_type' => '1',
			'image' => null,
			'image_dir' => null,
			'web' => '',
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => null,
			'address1' => 'Picasso, 1',
			'address2' => '(La Zenia II)',
			'email' => 'info@physiostropath.com',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '966730153',
			'phone2' => '',
			'zipcode' => '03189',
			'town' => 'Orihuela',
			'state' => 'Alicante',
			'country' => 'España',
			'latitude' => '37.921253',
			'longitude' => '-0.732702',
			'slug' => null,
			'canonical' => 'fisioterapia/orihuela/physiotherapy-and-osteopathy-clinic-s-l',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => 'e8e1ebb7f6df881b9f18d39f12a1ab50',
			'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' => '7666',
			'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-09-04 16:23:10',
			'modified' => '2018-07-10 19:58:52',
			'sms' => null,
			'fulladdress' => 'Picasso, 1, Orihuela ( 03189 ) , Alicante',
			'link' => 'https://www.fisiosite.com/fisioterapia/orihuela/physiotherapy-and-osteopathy-clinic-s-l',
			'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) 6 => array(
		'Establishment' => array(
			'id' => '9331',
			'name' => 'PATRICIA MENÁRGUEZ FISIOTERAPIA Y OSTEOPATÍA',
			'category_id' => '1',
			'establishment_type' => '1',
			'image' => null,
			'image_dir' => null,
			'web' => 'http://www.pmfisioterapia.com',
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => null,
			'address1' => 'C/ Mancebería, 60',
			'address2' => '',
			'email' => 'info@pmfisioterapia.com',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '96 634 20 18',
			'phone2' => '',
			'zipcode' => '03300',
			'town' => 'Orihuela',
			'state' => 'Alicante',
			'country' => 'España',
			'latitude' => '38.083706',
			'longitude' => '-0.949462',
			'slug' => null,
			'canonical' => 'fisioterapia/orihuela/patricia-menarguez-fisioterapia-y-osteopatia',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => '69c1cdfe66724b75b06b34016ade17e5',
			'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' => '7666',
			'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-09-04 16:23:14',
			'modified' => '2018-07-10 19:58:53',
			'sms' => null,
			'fulladdress' => 'C/ Mancebería, 60, Orihuela ( 03300 ) , Alicante',
			'link' => 'https://www.fisiosite.com/fisioterapia/orihuela/patricia-menarguez-fisioterapia-y-osteopatia',
			'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' => '9344',
			'name' => 'CLÍNICA MARFIL',
			'category_id' => '1',
			'establishment_type' => '1',
			'image' => null,
			'image_dir' => null,
			'web' => 'http://www.clinicamarfilorihuela.es',
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => null,
			'address1' => 'C/. Avenida de España, 3',
			'address2' => 'Bajo',
			'email' => 'marfilplayasl@gmail.com',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '966936482',
			'phone2' => '',
			'zipcode' => '03300',
			'town' => 'Orihuela',
			'state' => 'Alicante',
			'country' => 'España',
			'latitude' => '38.083027',
			'longitude' => '-0.946121',
			'slug' => null,
			'canonical' => 'fisioterapia/orihuela/clinica-marfil',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => '141a51eabc000d38494ecbc84051b7b4',
			'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' => '7666',
			'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-09-04 16:37:05',
			'modified' => '2018-07-10 19:58:56',
			'sms' => null,
			'fulladdress' => 'C/. Avenida de España, 3, Orihuela ( 03300 ) , Alicante',
			'link' => 'https://www.fisiosite.com/fisioterapia/orihuela/clinica-marfil',
			'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()
	)
)
$n_establishments = (int) 8
$e = array(
	'Establishment' => array(
		'id' => '8953',
		'name' => 'FISIOTERAPIA ZAFRA',
		'category_id' => '1',
		'establishment_type' => '1',
		'image' => null,
		'image_dir' => null,
		'web' => 'http://www.fisioterapiazafra.wordpress.com',
		'short_description' => null,
		'description' => null,
		'fiscalnumber' => null,
		'address1' => 'C/ Campoamor Nº 2',
		'address2' => '',
		'email' => '',
		'fax' => null,
		'mobile' => '',
		'mobile2' => '',
		'phone' => '674 207 150',
		'phone2' => '',
		'zipcode' => '03300',
		'town' => 'Orihuela',
		'state' => 'Alicante',
		'country' => 'España',
		'latitude' => '38.083038',
		'longitude' => '-0.944446',
		'slug' => null,
		'canonical' => 'fisioterapia/orihuela/fisioterapia-zafra',
		'canonical_old' => null,
		'timetable' => null,
		'hash' => 'ed176cf015f9033d263d4bfd0eae898b',
		'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' => '7666',
		'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-09-04 11:39:31',
		'modified' => '2018-07-10 19:57:22',
		'sms' => null,
		'fulladdress' => 'C/ Campoamor Nº 2, Orihuela ( 03300 ) , Alicante',
		'link' => 'https://www.fisiosite.com/fisioterapia/orihuela/fisioterapia-zafra',
		'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' => '7666'
)
$query_establishments = array(
	'Establishment.population_id' => '7666'
)
$key = (int) 4
$value = '7666'
$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' => '8950',
			'name' => 'FISIONOVA',
			'category_id' => '1',
			'establishment_type' => '1',
			'image' => null,
			'image_dir' => null,
			'web' => 'http://www.fisionova.es',
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => null,
			'address1' => 'Plaza Nueva, 6',
			'address2' => '',
			'email' => '',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '639775840',
			'phone2' => '',
			'zipcode' => '03300',
			'town' => 'Orihuela',
			'state' => 'Alicante',
			'country' => 'España',
			'latitude' => '38.084587',
			'longitude' => '-0.947126',
			'slug' => null,
			'canonical' => 'fisioterapia/orihuela/fisionova',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => '5f2fe0aef24996cae4feaca99d442a45',
			'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' => '7666',
			'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-09-04 11:39:16',
			'modified' => '2018-07-10 19:57:21',
			'sms' => null,
			'fulladdress' => 'Plaza Nueva, 6, Orihuela ( 03300 ) , Alicante',
			'link' => 'https://www.fisiosite.com/fisioterapia/orihuela/fisionova',
			'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' => '8951',
			'name' => 'FISIOCEN',
			'category_id' => '1',
			'establishment_type' => '1',
			'image' => null,
			'image_dir' => null,
			'web' => 'http://www.fisiocenorihuela.com',
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => null,
			'address1' => 'Limón, 6',
			'address2' => '',
			'email' => 'info@fisiocenorihuela.com',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '966736326',
			'phone2' => '',
			'zipcode' => '03300',
			'town' => 'Orihuela',
			'state' => 'Alicante',
			'country' => 'España',
			'latitude' => '38.080601',
			'longitude' => '-0.946006',
			'slug' => null,
			'canonical' => 'fisioterapia/orihuela/fisiocen',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => '877617f40b423f002eeff91ba3e8c574',
			'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' => '7666',
			'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-09-04 11:39:20',
			'modified' => '2018-07-10 19:57:22',
			'sms' => null,
			'fulladdress' => 'Limón, 6, Orihuela ( 03300 ) , Alicante',
			'link' => 'https://www.fisiosite.com/fisioterapia/orihuela/fisiocen',
			'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' => '8952',
			'name' => 'PURI',
			'category_id' => '1',
			'establishment_type' => '1',
			'image' => null,
			'image_dir' => null,
			'web' => '',
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => null,
			'address1' => 'Jade (La Zenia II), 20',
			'address2' => '',
			'email' => '',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '966760752',
			'phone2' => '',
			'zipcode' => '03189',
			'town' => 'Orihuela',
			'state' => 'Alicante',
			'country' => 'España',
			'latitude' => '37.929626',
			'longitude' => '-0.735187',
			'slug' => null,
			'canonical' => 'fisioterapia/orihuela/puri',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => '1e2dd25a94784389f0bf825b9060634e',
			'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' => '7666',
			'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-09-04 11:39:25',
			'modified' => '2018-07-10 19:57:22',
			'sms' => null,
			'fulladdress' => 'Jade (La Zenia II), 20, Orihuela ( 03189 ) , Alicante',
			'link' => 'https://www.fisiosite.com/fisioterapia/orihuela/puri',
			'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' => '8953',
			'name' => 'FISIOTERAPIA ZAFRA',
			'category_id' => '1',
			'establishment_type' => '1',
			'image' => null,
			'image_dir' => null,
			'web' => 'http://www.fisioterapiazafra.wordpress.com',
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => null,
			'address1' => 'C/ Campoamor Nº 2',
			'address2' => '',
			'email' => '',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '674 207 150',
			'phone2' => '',
			'zipcode' => '03300',
			'town' => 'Orihuela',
			'state' => 'Alicante',
			'country' => 'España',
			'latitude' => '38.083038',
			'longitude' => '-0.944446',
			'slug' => null,
			'canonical' => 'fisioterapia/orihuela/fisioterapia-zafra',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => 'ed176cf015f9033d263d4bfd0eae898b',
			'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' => '7666',
			'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-09-04 11:39:31',
			'modified' => '2018-07-10 19:57:22',
			'sms' => null,
			'fulladdress' => 'C/ Campoamor Nº 2, Orihuela ( 03300 ) , Alicante',
			'link' => 'https://www.fisiosite.com/fisioterapia/orihuela/fisioterapia-zafra',
			'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' => '8954',
			'name' => 'CLÍNICA DE FISIOTERAPIA REYMA',
			'category_id' => '1',
			'establishment_type' => '1',
			'image' => null,
			'image_dir' => null,
			'web' => 'http://www.fisioreyma.com',
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => null,
			'address1' => 'C/ Lavatorio Nº5',
			'address2' => '',
			'email' => 'fisioreyma@hotmail.com',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '96 674 23 21',
			'phone2' => '',
			'zipcode' => '03300',
			'town' => 'Orihuela',
			'state' => 'Alicante',
			'country' => 'España',
			'latitude' => '38.081390',
			'longitude' => '-0.941793',
			'slug' => null,
			'canonical' => 'fisioterapia/orihuela/clinica-de-fisioterapia-reyma',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => '40a56d42a575776242af2393b15a789b',
			'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' => '7666',
			'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-09-04 11:39:35',
			'modified' => '2018-07-10 19:57:22',
			'sms' => null,
			'fulladdress' => 'C/ Lavatorio Nº5, Orihuela ( 03300 ) , Alicante',
			'link' => 'https://www.fisiosite.com/fisioterapia/orihuela/clinica-de-fisioterapia-reyma',
			'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' => '9330',
			'name' => 'PHYSIOTHERAPY AND OSTEOPATHY CLINIC,S. L.',
			'category_id' => '1',
			'establishment_type' => '1',
			'image' => null,
			'image_dir' => null,
			'web' => '',
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => null,
			'address1' => 'Picasso, 1',
			'address2' => '(La Zenia II)',
			'email' => 'info@physiostropath.com',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '966730153',
			'phone2' => '',
			'zipcode' => '03189',
			'town' => 'Orihuela',
			'state' => 'Alicante',
			'country' => 'España',
			'latitude' => '37.921253',
			'longitude' => '-0.732702',
			'slug' => null,
			'canonical' => 'fisioterapia/orihuela/physiotherapy-and-osteopathy-clinic-s-l',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => 'e8e1ebb7f6df881b9f18d39f12a1ab50',
			'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' => '7666',
			'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-09-04 16:23:10',
			'modified' => '2018-07-10 19:58:52',
			'sms' => null,
			'fulladdress' => 'Picasso, 1, Orihuela ( 03189 ) , Alicante',
			'link' => 'https://www.fisiosite.com/fisioterapia/orihuela/physiotherapy-and-osteopathy-clinic-s-l',
			'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) 6 => array(
		'Establishment' => array(
			'id' => '9331',
			'name' => 'PATRICIA MENÁRGUEZ FISIOTERAPIA Y OSTEOPATÍA',
			'category_id' => '1',
			'establishment_type' => '1',
			'image' => null,
			'image_dir' => null,
			'web' => 'http://www.pmfisioterapia.com',
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => null,
			'address1' => 'C/ Mancebería, 60',
			'address2' => '',
			'email' => 'info@pmfisioterapia.com',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '96 634 20 18',
			'phone2' => '',
			'zipcode' => '03300',
			'town' => 'Orihuela',
			'state' => 'Alicante',
			'country' => 'España',
			'latitude' => '38.083706',
			'longitude' => '-0.949462',
			'slug' => null,
			'canonical' => 'fisioterapia/orihuela/patricia-menarguez-fisioterapia-y-osteopatia',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => '69c1cdfe66724b75b06b34016ade17e5',
			'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' => '7666',
			'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-09-04 16:23:14',
			'modified' => '2018-07-10 19:58:53',
			'sms' => null,
			'fulladdress' => 'C/ Mancebería, 60, Orihuela ( 03300 ) , Alicante',
			'link' => 'https://www.fisiosite.com/fisioterapia/orihuela/patricia-menarguez-fisioterapia-y-osteopatia',
			'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' => '9344',
			'name' => 'CLÍNICA MARFIL',
			'category_id' => '1',
			'establishment_type' => '1',
			'image' => null,
			'image_dir' => null,
			'web' => 'http://www.clinicamarfilorihuela.es',
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => null,
			'address1' => 'C/. Avenida de España, 3',
			'address2' => 'Bajo',
			'email' => 'marfilplayasl@gmail.com',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '966936482',
			'phone2' => '',
			'zipcode' => '03300',
			'town' => 'Orihuela',
			'state' => 'Alicante',
			'country' => 'España',
			'latitude' => '38.083027',
			'longitude' => '-0.946121',
			'slug' => null,
			'canonical' => 'fisioterapia/orihuela/clinica-marfil',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => '141a51eabc000d38494ecbc84051b7b4',
			'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' => '7666',
			'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-09-04 16:37:05',
			'modified' => '2018-07-10 19:58:56',
			'sms' => null,
			'fulladdress' => 'C/. Avenida de España, 3, Orihuela ( 03300 ) , Alicante',
			'link' => 'https://www.fisiosite.com/fisioterapia/orihuela/clinica-marfil',
			'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()
	)
)
$n_establishments = (int) 8
$e = array(
	'Establishment' => array(
		'id' => '8954',
		'name' => 'CLÍNICA DE FISIOTERAPIA REYMA',
		'category_id' => '1',
		'establishment_type' => '1',
		'image' => null,
		'image_dir' => null,
		'web' => 'http://www.fisioreyma.com',
		'short_description' => null,
		'description' => null,
		'fiscalnumber' => null,
		'address1' => 'C/ Lavatorio Nº5',
		'address2' => '',
		'email' => 'fisioreyma@hotmail.com',
		'fax' => null,
		'mobile' => '',
		'mobile2' => '',
		'phone' => '96 674 23 21',
		'phone2' => '',
		'zipcode' => '03300',
		'town' => 'Orihuela',
		'state' => 'Alicante',
		'country' => 'España',
		'latitude' => '38.081390',
		'longitude' => '-0.941793',
		'slug' => null,
		'canonical' => 'fisioterapia/orihuela/clinica-de-fisioterapia-reyma',
		'canonical_old' => null,
		'timetable' => null,
		'hash' => '40a56d42a575776242af2393b15a789b',
		'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' => '7666',
		'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-09-04 11:39:35',
		'modified' => '2018-07-10 19:57:22',
		'sms' => null,
		'fulladdress' => 'C/ Lavatorio Nº5, Orihuela ( 03300 ) , Alicante',
		'link' => 'https://www.fisiosite.com/fisioterapia/orihuela/clinica-de-fisioterapia-reyma',
		'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' => '7666'
)
$query_establishments = array(
	'Establishment.population_id' => '7666'
)
$key = (int) 5
$value = '7666'
$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' => '8950',
			'name' => 'FISIONOVA',
			'category_id' => '1',
			'establishment_type' => '1',
			'image' => null,
			'image_dir' => null,
			'web' => 'http://www.fisionova.es',
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => null,
			'address1' => 'Plaza Nueva, 6',
			'address2' => '',
			'email' => '',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '639775840',
			'phone2' => '',
			'zipcode' => '03300',
			'town' => 'Orihuela',
			'state' => 'Alicante',
			'country' => 'España',
			'latitude' => '38.084587',
			'longitude' => '-0.947126',
			'slug' => null,
			'canonical' => 'fisioterapia/orihuela/fisionova',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => '5f2fe0aef24996cae4feaca99d442a45',
			'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' => '7666',
			'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-09-04 11:39:16',
			'modified' => '2018-07-10 19:57:21',
			'sms' => null,
			'fulladdress' => 'Plaza Nueva, 6, Orihuela ( 03300 ) , Alicante',
			'link' => 'https://www.fisiosite.com/fisioterapia/orihuela/fisionova',
			'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' => '8951',
			'name' => 'FISIOCEN',
			'category_id' => '1',
			'establishment_type' => '1',
			'image' => null,
			'image_dir' => null,
			'web' => 'http://www.fisiocenorihuela.com',
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => null,
			'address1' => 'Limón, 6',
			'address2' => '',
			'email' => 'info@fisiocenorihuela.com',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '966736326',
			'phone2' => '',
			'zipcode' => '03300',
			'town' => 'Orihuela',
			'state' => 'Alicante',
			'country' => 'España',
			'latitude' => '38.080601',
			'longitude' => '-0.946006',
			'slug' => null,
			'canonical' => 'fisioterapia/orihuela/fisiocen',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => '877617f40b423f002eeff91ba3e8c574',
			'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' => '7666',
			'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-09-04 11:39:20',
			'modified' => '2018-07-10 19:57:22',
			'sms' => null,
			'fulladdress' => 'Limón, 6, Orihuela ( 03300 ) , Alicante',
			'link' => 'https://www.fisiosite.com/fisioterapia/orihuela/fisiocen',
			'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' => '8952',
			'name' => 'PURI',
			'category_id' => '1',
			'establishment_type' => '1',
			'image' => null,
			'image_dir' => null,
			'web' => '',
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => null,
			'address1' => 'Jade (La Zenia II), 20',
			'address2' => '',
			'email' => '',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '966760752',
			'phone2' => '',
			'zipcode' => '03189',
			'town' => 'Orihuela',
			'state' => 'Alicante',
			'country' => 'España',
			'latitude' => '37.929626',
			'longitude' => '-0.735187',
			'slug' => null,
			'canonical' => 'fisioterapia/orihuela/puri',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => '1e2dd25a94784389f0bf825b9060634e',
			'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' => '7666',
			'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-09-04 11:39:25',
			'modified' => '2018-07-10 19:57:22',
			'sms' => null,
			'fulladdress' => 'Jade (La Zenia II), 20, Orihuela ( 03189 ) , Alicante',
			'link' => 'https://www.fisiosite.com/fisioterapia/orihuela/puri',
			'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' => '8953',
			'name' => 'FISIOTERAPIA ZAFRA',
			'category_id' => '1',
			'establishment_type' => '1',
			'image' => null,
			'image_dir' => null,
			'web' => 'http://www.fisioterapiazafra.wordpress.com',
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => null,
			'address1' => 'C/ Campoamor Nº 2',
			'address2' => '',
			'email' => '',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '674 207 150',
			'phone2' => '',
			'zipcode' => '03300',
			'town' => 'Orihuela',
			'state' => 'Alicante',
			'country' => 'España',
			'latitude' => '38.083038',
			'longitude' => '-0.944446',
			'slug' => null,
			'canonical' => 'fisioterapia/orihuela/fisioterapia-zafra',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => 'ed176cf015f9033d263d4bfd0eae898b',
			'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' => '7666',
			'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-09-04 11:39:31',
			'modified' => '2018-07-10 19:57:22',
			'sms' => null,
			'fulladdress' => 'C/ Campoamor Nº 2, Orihuela ( 03300 ) , Alicante',
			'link' => 'https://www.fisiosite.com/fisioterapia/orihuela/fisioterapia-zafra',
			'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' => '8954',
			'name' => 'CLÍNICA DE FISIOTERAPIA REYMA',
			'category_id' => '1',
			'establishment_type' => '1',
			'image' => null,
			'image_dir' => null,
			'web' => 'http://www.fisioreyma.com',
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => null,
			'address1' => 'C/ Lavatorio Nº5',
			'address2' => '',
			'email' => 'fisioreyma@hotmail.com',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '96 674 23 21',
			'phone2' => '',
			'zipcode' => '03300',
			'town' => 'Orihuela',
			'state' => 'Alicante',
			'country' => 'España',
			'latitude' => '38.081390',
			'longitude' => '-0.941793',
			'slug' => null,
			'canonical' => 'fisioterapia/orihuela/clinica-de-fisioterapia-reyma',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => '40a56d42a575776242af2393b15a789b',
			'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' => '7666',
			'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-09-04 11:39:35',
			'modified' => '2018-07-10 19:57:22',
			'sms' => null,
			'fulladdress' => 'C/ Lavatorio Nº5, Orihuela ( 03300 ) , Alicante',
			'link' => 'https://www.fisiosite.com/fisioterapia/orihuela/clinica-de-fisioterapia-reyma',
			'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' => '9330',
			'name' => 'PHYSIOTHERAPY AND OSTEOPATHY CLINIC,S. L.',
			'category_id' => '1',
			'establishment_type' => '1',
			'image' => null,
			'image_dir' => null,
			'web' => '',
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => null,
			'address1' => 'Picasso, 1',
			'address2' => '(La Zenia II)',
			'email' => 'info@physiostropath.com',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '966730153',
			'phone2' => '',
			'zipcode' => '03189',
			'town' => 'Orihuela',
			'state' => 'Alicante',
			'country' => 'España',
			'latitude' => '37.921253',
			'longitude' => '-0.732702',
			'slug' => null,
			'canonical' => 'fisioterapia/orihuela/physiotherapy-and-osteopathy-clinic-s-l',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => 'e8e1ebb7f6df881b9f18d39f12a1ab50',
			'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' => '7666',
			'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-09-04 16:23:10',
			'modified' => '2018-07-10 19:58:52',
			'sms' => null,
			'fulladdress' => 'Picasso, 1, Orihuela ( 03189 ) , Alicante',
			'link' => 'https://www.fisiosite.com/fisioterapia/orihuela/physiotherapy-and-osteopathy-clinic-s-l',
			'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) 6 => array(
		'Establishment' => array(
			'id' => '9331',
			'name' => 'PATRICIA MENÁRGUEZ FISIOTERAPIA Y OSTEOPATÍA',
			'category_id' => '1',
			'establishment_type' => '1',
			'image' => null,
			'image_dir' => null,
			'web' => 'http://www.pmfisioterapia.com',
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => null,
			'address1' => 'C/ Mancebería, 60',
			'address2' => '',
			'email' => 'info@pmfisioterapia.com',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '96 634 20 18',
			'phone2' => '',
			'zipcode' => '03300',
			'town' => 'Orihuela',
			'state' => 'Alicante',
			'country' => 'España',
			'latitude' => '38.083706',
			'longitude' => '-0.949462',
			'slug' => null,
			'canonical' => 'fisioterapia/orihuela/patricia-menarguez-fisioterapia-y-osteopatia',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => '69c1cdfe66724b75b06b34016ade17e5',
			'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' => '7666',
			'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-09-04 16:23:14',
			'modified' => '2018-07-10 19:58:53',
			'sms' => null,
			'fulladdress' => 'C/ Mancebería, 60, Orihuela ( 03300 ) , Alicante',
			'link' => 'https://www.fisiosite.com/fisioterapia/orihuela/patricia-menarguez-fisioterapia-y-osteopatia',
			'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' => '9344',
			'name' => 'CLÍNICA MARFIL',
			'category_id' => '1',
			'establishment_type' => '1',
			'image' => null,
			'image_dir' => null,
			'web' => 'http://www.clinicamarfilorihuela.es',
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => null,
			'address1' => 'C/. Avenida de España, 3',
			'address2' => 'Bajo',
			'email' => 'marfilplayasl@gmail.com',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '966936482',
			'phone2' => '',
			'zipcode' => '03300',
			'town' => 'Orihuela',
			'state' => 'Alicante',
			'country' => 'España',
			'latitude' => '38.083027',
			'longitude' => '-0.946121',
			'slug' => null,
			'canonical' => 'fisioterapia/orihuela/clinica-marfil',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => '141a51eabc000d38494ecbc84051b7b4',
			'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' => '7666',
			'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-09-04 16:37:05',
			'modified' => '2018-07-10 19:58:56',
			'sms' => null,
			'fulladdress' => 'C/. Avenida de España, 3, Orihuela ( 03300 ) , Alicante',
			'link' => 'https://www.fisiosite.com/fisioterapia/orihuela/clinica-marfil',
			'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()
	)
)
$n_establishments = (int) 8
$e = array(
	'Establishment' => array(
		'id' => '9330',
		'name' => 'PHYSIOTHERAPY AND OSTEOPATHY CLINIC,S. L.',
		'category_id' => '1',
		'establishment_type' => '1',
		'image' => null,
		'image_dir' => null,
		'web' => '',
		'short_description' => null,
		'description' => null,
		'fiscalnumber' => null,
		'address1' => 'Picasso, 1',
		'address2' => '(La Zenia II)',
		'email' => 'info@physiostropath.com',
		'fax' => null,
		'mobile' => '',
		'mobile2' => '',
		'phone' => '966730153',
		'phone2' => '',
		'zipcode' => '03189',
		'town' => 'Orihuela',
		'state' => 'Alicante',
		'country' => 'España',
		'latitude' => '37.921253',
		'longitude' => '-0.732702',
		'slug' => null,
		'canonical' => 'fisioterapia/orihuela/physiotherapy-and-osteopathy-clinic-s-l',
		'canonical_old' => null,
		'timetable' => null,
		'hash' => 'e8e1ebb7f6df881b9f18d39f12a1ab50',
		'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' => '7666',
		'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-09-04 16:23:10',
		'modified' => '2018-07-10 19:58:52',
		'sms' => null,
		'fulladdress' => 'Picasso, 1, Orihuela ( 03189 ) , Alicante',
		'link' => 'https://www.fisiosite.com/fisioterapia/orihuela/physiotherapy-and-osteopathy-clinic-s-l',
		'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' => '7666'
)
$query_establishments = array(
	'Establishment.population_id' => '7666'
)
$key = (int) 6
$value = '7666'
$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' => '8950',
			'name' => 'FISIONOVA',
			'category_id' => '1',
			'establishment_type' => '1',
			'image' => null,
			'image_dir' => null,
			'web' => 'http://www.fisionova.es',
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => null,
			'address1' => 'Plaza Nueva, 6',
			'address2' => '',
			'email' => '',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '639775840',
			'phone2' => '',
			'zipcode' => '03300',
			'town' => 'Orihuela',
			'state' => 'Alicante',
			'country' => 'España',
			'latitude' => '38.084587',
			'longitude' => '-0.947126',
			'slug' => null,
			'canonical' => 'fisioterapia/orihuela/fisionova',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => '5f2fe0aef24996cae4feaca99d442a45',
			'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' => '7666',
			'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-09-04 11:39:16',
			'modified' => '2018-07-10 19:57:21',
			'sms' => null,
			'fulladdress' => 'Plaza Nueva, 6, Orihuela ( 03300 ) , Alicante',
			'link' => 'https://www.fisiosite.com/fisioterapia/orihuela/fisionova',
			'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' => '8951',
			'name' => 'FISIOCEN',
			'category_id' => '1',
			'establishment_type' => '1',
			'image' => null,
			'image_dir' => null,
			'web' => 'http://www.fisiocenorihuela.com',
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => null,
			'address1' => 'Limón, 6',
			'address2' => '',
			'email' => 'info@fisiocenorihuela.com',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '966736326',
			'phone2' => '',
			'zipcode' => '03300',
			'town' => 'Orihuela',
			'state' => 'Alicante',
			'country' => 'España',
			'latitude' => '38.080601',
			'longitude' => '-0.946006',
			'slug' => null,
			'canonical' => 'fisioterapia/orihuela/fisiocen',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => '877617f40b423f002eeff91ba3e8c574',
			'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' => '7666',
			'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-09-04 11:39:20',
			'modified' => '2018-07-10 19:57:22',
			'sms' => null,
			'fulladdress' => 'Limón, 6, Orihuela ( 03300 ) , Alicante',
			'link' => 'https://www.fisiosite.com/fisioterapia/orihuela/fisiocen',
			'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' => '8952',
			'name' => 'PURI',
			'category_id' => '1',
			'establishment_type' => '1',
			'image' => null,
			'image_dir' => null,
			'web' => '',
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => null,
			'address1' => 'Jade (La Zenia II), 20',
			'address2' => '',
			'email' => '',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '966760752',
			'phone2' => '',
			'zipcode' => '03189',
			'town' => 'Orihuela',
			'state' => 'Alicante',
			'country' => 'España',
			'latitude' => '37.929626',
			'longitude' => '-0.735187',
			'slug' => null,
			'canonical' => 'fisioterapia/orihuela/puri',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => '1e2dd25a94784389f0bf825b9060634e',
			'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' => '7666',
			'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-09-04 11:39:25',
			'modified' => '2018-07-10 19:57:22',
			'sms' => null,
			'fulladdress' => 'Jade (La Zenia II), 20, Orihuela ( 03189 ) , Alicante',
			'link' => 'https://www.fisiosite.com/fisioterapia/orihuela/puri',
			'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' => '8953',
			'name' => 'FISIOTERAPIA ZAFRA',
			'category_id' => '1',
			'establishment_type' => '1',
			'image' => null,
			'image_dir' => null,
			'web' => 'http://www.fisioterapiazafra.wordpress.com',
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => null,
			'address1' => 'C/ Campoamor Nº 2',
			'address2' => '',
			'email' => '',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '674 207 150',
			'phone2' => '',
			'zipcode' => '03300',
			'town' => 'Orihuela',
			'state' => 'Alicante',
			'country' => 'España',
			'latitude' => '38.083038',
			'longitude' => '-0.944446',
			'slug' => null,
			'canonical' => 'fisioterapia/orihuela/fisioterapia-zafra',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => 'ed176cf015f9033d263d4bfd0eae898b',
			'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' => '7666',
			'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-09-04 11:39:31',
			'modified' => '2018-07-10 19:57:22',
			'sms' => null,
			'fulladdress' => 'C/ Campoamor Nº 2, Orihuela ( 03300 ) , Alicante',
			'link' => 'https://www.fisiosite.com/fisioterapia/orihuela/fisioterapia-zafra',
			'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' => '8954',
			'name' => 'CLÍNICA DE FISIOTERAPIA REYMA',
			'category_id' => '1',
			'establishment_type' => '1',
			'image' => null,
			'image_dir' => null,
			'web' => 'http://www.fisioreyma.com',
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => null,
			'address1' => 'C/ Lavatorio Nº5',
			'address2' => '',
			'email' => 'fisioreyma@hotmail.com',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '96 674 23 21',
			'phone2' => '',
			'zipcode' => '03300',
			'town' => 'Orihuela',
			'state' => 'Alicante',
			'country' => 'España',
			'latitude' => '38.081390',
			'longitude' => '-0.941793',
			'slug' => null,
			'canonical' => 'fisioterapia/orihuela/clinica-de-fisioterapia-reyma',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => '40a56d42a575776242af2393b15a789b',
			'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' => '7666',
			'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-09-04 11:39:35',
			'modified' => '2018-07-10 19:57:22',
			'sms' => null,
			'fulladdress' => 'C/ Lavatorio Nº5, Orihuela ( 03300 ) , Alicante',
			'link' => 'https://www.fisiosite.com/fisioterapia/orihuela/clinica-de-fisioterapia-reyma',
			'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' => '9330',
			'name' => 'PHYSIOTHERAPY AND OSTEOPATHY CLINIC,S. L.',
			'category_id' => '1',
			'establishment_type' => '1',
			'image' => null,
			'image_dir' => null,
			'web' => '',
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => null,
			'address1' => 'Picasso, 1',
			'address2' => '(La Zenia II)',
			'email' => 'info@physiostropath.com',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '966730153',
			'phone2' => '',
			'zipcode' => '03189',
			'town' => 'Orihuela',
			'state' => 'Alicante',
			'country' => 'España',
			'latitude' => '37.921253',
			'longitude' => '-0.732702',
			'slug' => null,
			'canonical' => 'fisioterapia/orihuela/physiotherapy-and-osteopathy-clinic-s-l',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => 'e8e1ebb7f6df881b9f18d39f12a1ab50',
			'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' => '7666',
			'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-09-04 16:23:10',
			'modified' => '2018-07-10 19:58:52',
			'sms' => null,
			'fulladdress' => 'Picasso, 1, Orihuela ( 03189 ) , Alicante',
			'link' => 'https://www.fisiosite.com/fisioterapia/orihuela/physiotherapy-and-osteopathy-clinic-s-l',
			'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) 6 => array(
		'Establishment' => array(
			'id' => '9331',
			'name' => 'PATRICIA MENÁRGUEZ FISIOTERAPIA Y OSTEOPATÍA',
			'category_id' => '1',
			'establishment_type' => '1',
			'image' => null,
			'image_dir' => null,
			'web' => 'http://www.pmfisioterapia.com',
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => null,
			'address1' => 'C/ Mancebería, 60',
			'address2' => '',
			'email' => 'info@pmfisioterapia.com',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '96 634 20 18',
			'phone2' => '',
			'zipcode' => '03300',
			'town' => 'Orihuela',
			'state' => 'Alicante',
			'country' => 'España',
			'latitude' => '38.083706',
			'longitude' => '-0.949462',
			'slug' => null,
			'canonical' => 'fisioterapia/orihuela/patricia-menarguez-fisioterapia-y-osteopatia',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => '69c1cdfe66724b75b06b34016ade17e5',
			'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' => '7666',
			'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-09-04 16:23:14',
			'modified' => '2018-07-10 19:58:53',
			'sms' => null,
			'fulladdress' => 'C/ Mancebería, 60, Orihuela ( 03300 ) , Alicante',
			'link' => 'https://www.fisiosite.com/fisioterapia/orihuela/patricia-menarguez-fisioterapia-y-osteopatia',
			'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' => '9344',
			'name' => 'CLÍNICA MARFIL',
			'category_id' => '1',
			'establishment_type' => '1',
			'image' => null,
			'image_dir' => null,
			'web' => 'http://www.clinicamarfilorihuela.es',
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => null,
			'address1' => 'C/. Avenida de España, 3',
			'address2' => 'Bajo',
			'email' => 'marfilplayasl@gmail.com',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '966936482',
			'phone2' => '',
			'zipcode' => '03300',
			'town' => 'Orihuela',
			'state' => 'Alicante',
			'country' => 'España',
			'latitude' => '38.083027',
			'longitude' => '-0.946121',
			'slug' => null,
			'canonical' => 'fisioterapia/orihuela/clinica-marfil',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => '141a51eabc000d38494ecbc84051b7b4',
			'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' => '7666',
			'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-09-04 16:37:05',
			'modified' => '2018-07-10 19:58:56',
			'sms' => null,
			'fulladdress' => 'C/. Avenida de España, 3, Orihuela ( 03300 ) , Alicante',
			'link' => 'https://www.fisiosite.com/fisioterapia/orihuela/clinica-marfil',
			'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()
	)
)
$n_establishments = (int) 8
$e = array(
	'Establishment' => array(
		'id' => '9331',
		'name' => 'PATRICIA MENÁRGUEZ FISIOTERAPIA Y OSTEOPATÍA',
		'category_id' => '1',
		'establishment_type' => '1',
		'image' => null,
		'image_dir' => null,
		'web' => 'http://www.pmfisioterapia.com',
		'short_description' => null,
		'description' => null,
		'fiscalnumber' => null,
		'address1' => 'C/ Mancebería, 60',
		'address2' => '',
		'email' => 'info@pmfisioterapia.com',
		'fax' => null,
		'mobile' => '',
		'mobile2' => '',
		'phone' => '96 634 20 18',
		'phone2' => '',
		'zipcode' => '03300',
		'town' => 'Orihuela',
		'state' => 'Alicante',
		'country' => 'España',
		'latitude' => '38.083706',
		'longitude' => '-0.949462',
		'slug' => null,
		'canonical' => 'fisioterapia/orihuela/patricia-menarguez-fisioterapia-y-osteopatia',
		'canonical_old' => null,
		'timetable' => null,
		'hash' => '69c1cdfe66724b75b06b34016ade17e5',
		'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' => '7666',
		'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-09-04 16:23:14',
		'modified' => '2018-07-10 19:58:53',
		'sms' => null,
		'fulladdress' => 'C/ Mancebería, 60, Orihuela ( 03300 ) , Alicante',
		'link' => 'https://www.fisiosite.com/fisioterapia/orihuela/patricia-menarguez-fisioterapia-y-osteopatia',
		'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' => '7666'
)
$query_establishments = array(
	'Establishment.population_id' => '7666'
)
$key = (int) 7
$value = '7666'
$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' => '8950',
			'name' => 'FISIONOVA',
			'category_id' => '1',
			'establishment_type' => '1',
			'image' => null,
			'image_dir' => null,
			'web' => 'http://www.fisionova.es',
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => null,
			'address1' => 'Plaza Nueva, 6',
			'address2' => '',
			'email' => '',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '639775840',
			'phone2' => '',
			'zipcode' => '03300',
			'town' => 'Orihuela',
			'state' => 'Alicante',
			'country' => 'España',
			'latitude' => '38.084587',
			'longitude' => '-0.947126',
			'slug' => null,
			'canonical' => 'fisioterapia/orihuela/fisionova',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => '5f2fe0aef24996cae4feaca99d442a45',
			'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' => '7666',
			'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-09-04 11:39:16',
			'modified' => '2018-07-10 19:57:21',
			'sms' => null,
			'fulladdress' => 'Plaza Nueva, 6, Orihuela ( 03300 ) , Alicante',
			'link' => 'https://www.fisiosite.com/fisioterapia/orihuela/fisionova',
			'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' => '8951',
			'name' => 'FISIOCEN',
			'category_id' => '1',
			'establishment_type' => '1',
			'image' => null,
			'image_dir' => null,
			'web' => 'http://www.fisiocenorihuela.com',
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => null,
			'address1' => 'Limón, 6',
			'address2' => '',
			'email' => 'info@fisiocenorihuela.com',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '966736326',
			'phone2' => '',
			'zipcode' => '03300',
			'town' => 'Orihuela',
			'state' => 'Alicante',
			'country' => 'España',
			'latitude' => '38.080601',
			'longitude' => '-0.946006',
			'slug' => null,
			'canonical' => 'fisioterapia/orihuela/fisiocen',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => '877617f40b423f002eeff91ba3e8c574',
			'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' => '7666',
			'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-09-04 11:39:20',
			'modified' => '2018-07-10 19:57:22',
			'sms' => null,
			'fulladdress' => 'Limón, 6, Orihuela ( 03300 ) , Alicante',
			'link' => 'https://www.fisiosite.com/fisioterapia/orihuela/fisiocen',
			'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' => '8952',
			'name' => 'PURI',
			'category_id' => '1',
			'establishment_type' => '1',
			'image' => null,
			'image_dir' => null,
			'web' => '',
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => null,
			'address1' => 'Jade (La Zenia II), 20',
			'address2' => '',
			'email' => '',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '966760752',
			'phone2' => '',
			'zipcode' => '03189',
			'town' => 'Orihuela',
			'state' => 'Alicante',
			'country' => 'España',
			'latitude' => '37.929626',
			'longitude' => '-0.735187',
			'slug' => null,
			'canonical' => 'fisioterapia/orihuela/puri',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => '1e2dd25a94784389f0bf825b9060634e',
			'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' => '7666',
			'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-09-04 11:39:25',
			'modified' => '2018-07-10 19:57:22',
			'sms' => null,
			'fulladdress' => 'Jade (La Zenia II), 20, Orihuela ( 03189 ) , Alicante',
			'link' => 'https://www.fisiosite.com/fisioterapia/orihuela/puri',
			'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' => '8953',
			'name' => 'FISIOTERAPIA ZAFRA',
			'category_id' => '1',
			'establishment_type' => '1',
			'image' => null,
			'image_dir' => null,
			'web' => 'http://www.fisioterapiazafra.wordpress.com',
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => null,
			'address1' => 'C/ Campoamor Nº 2',
			'address2' => '',
			'email' => '',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '674 207 150',
			'phone2' => '',
			'zipcode' => '03300',
			'town' => 'Orihuela',
			'state' => 'Alicante',
			'country' => 'España',
			'latitude' => '38.083038',
			'longitude' => '-0.944446',
			'slug' => null,
			'canonical' => 'fisioterapia/orihuela/fisioterapia-zafra',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => 'ed176cf015f9033d263d4bfd0eae898b',
			'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' => '7666',
			'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-09-04 11:39:31',
			'modified' => '2018-07-10 19:57:22',
			'sms' => null,
			'fulladdress' => 'C/ Campoamor Nº 2, Orihuela ( 03300 ) , Alicante',
			'link' => 'https://www.fisiosite.com/fisioterapia/orihuela/fisioterapia-zafra',
			'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' => '8954',
			'name' => 'CLÍNICA DE FISIOTERAPIA REYMA',
			'category_id' => '1',
			'establishment_type' => '1',
			'image' => null,
			'image_dir' => null,
			'web' => 'http://www.fisioreyma.com',
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => null,
			'address1' => 'C/ Lavatorio Nº5',
			'address2' => '',
			'email' => 'fisioreyma@hotmail.com',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '96 674 23 21',
			'phone2' => '',
			'zipcode' => '03300',
			'town' => 'Orihuela',
			'state' => 'Alicante',
			'country' => 'España',
			'latitude' => '38.081390',
			'longitude' => '-0.941793',
			'slug' => null,
			'canonical' => 'fisioterapia/orihuela/clinica-de-fisioterapia-reyma',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => '40a56d42a575776242af2393b15a789b',
			'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' => '7666',
			'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-09-04 11:39:35',
			'modified' => '2018-07-10 19:57:22',
			'sms' => null,
			'fulladdress' => 'C/ Lavatorio Nº5, Orihuela ( 03300 ) , Alicante',
			'link' => 'https://www.fisiosite.com/fisioterapia/orihuela/clinica-de-fisioterapia-reyma',
			'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' => '9330',
			'name' => 'PHYSIOTHERAPY AND OSTEOPATHY CLINIC,S. L.',
			'category_id' => '1',
			'establishment_type' => '1',
			'image' => null,
			'image_dir' => null,
			'web' => '',
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => null,
			'address1' => 'Picasso, 1',
			'address2' => '(La Zenia II)',
			'email' => 'info@physiostropath.com',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '966730153',
			'phone2' => '',
			'zipcode' => '03189',
			'town' => 'Orihuela',
			'state' => 'Alicante',
			'country' => 'España',
			'latitude' => '37.921253',
			'longitude' => '-0.732702',
			'slug' => null,
			'canonical' => 'fisioterapia/orihuela/physiotherapy-and-osteopathy-clinic-s-l',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => 'e8e1ebb7f6df881b9f18d39f12a1ab50',
			'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' => '7666',
			'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-09-04 16:23:10',
			'modified' => '2018-07-10 19:58:52',
			'sms' => null,
			'fulladdress' => 'Picasso, 1, Orihuela ( 03189 ) , Alicante',
			'link' => 'https://www.fisiosite.com/fisioterapia/orihuela/physiotherapy-and-osteopathy-clinic-s-l',
			'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) 6 => array(
		'Establishment' => array(
			'id' => '9331',
			'name' => 'PATRICIA MENÁRGUEZ FISIOTERAPIA Y OSTEOPATÍA',
			'category_id' => '1',
			'establishment_type' => '1',
			'image' => null,
			'image_dir' => null,
			'web' => 'http://www.pmfisioterapia.com',
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => null,
			'address1' => 'C/ Mancebería, 60',
			'address2' => '',
			'email' => 'info@pmfisioterapia.com',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '96 634 20 18',
			'phone2' => '',
			'zipcode' => '03300',
			'town' => 'Orihuela',
			'state' => 'Alicante',
			'country' => 'España',
			'latitude' => '38.083706',
			'longitude' => '-0.949462',
			'slug' => null,
			'canonical' => 'fisioterapia/orihuela/patricia-menarguez-fisioterapia-y-osteopatia',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => '69c1cdfe66724b75b06b34016ade17e5',
			'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' => '7666',
			'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-09-04 16:23:14',
			'modified' => '2018-07-10 19:58:53',
			'sms' => null,
			'fulladdress' => 'C/ Mancebería, 60, Orihuela ( 03300 ) , Alicante',
			'link' => 'https://www.fisiosite.com/fisioterapia/orihuela/patricia-menarguez-fisioterapia-y-osteopatia',
			'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' => '9344',
			'name' => 'CLÍNICA MARFIL',
			'category_id' => '1',
			'establishment_type' => '1',
			'image' => null,
			'image_dir' => null,
			'web' => 'http://www.clinicamarfilorihuela.es',
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => null,
			'address1' => 'C/. Avenida de España, 3',
			'address2' => 'Bajo',
			'email' => 'marfilplayasl@gmail.com',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '966936482',
			'phone2' => '',
			'zipcode' => '03300',
			'town' => 'Orihuela',
			'state' => 'Alicante',
			'country' => 'España',
			'latitude' => '38.083027',
			'longitude' => '-0.946121',
			'slug' => null,
			'canonical' => 'fisioterapia/orihuela/clinica-marfil',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => '141a51eabc000d38494ecbc84051b7b4',
			'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' => '7666',
			'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-09-04 16:37:05',
			'modified' => '2018-07-10 19:58:56',
			'sms' => null,
			'fulladdress' => 'C/. Avenida de España, 3, Orihuela ( 03300 ) , Alicante',
			'link' => 'https://www.fisiosite.com/fisioterapia/orihuela/clinica-marfil',
			'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()
	)
)
$n_establishments = (int) 8
$e = array(
	'Establishment' => array(
		'id' => '9344',
		'name' => 'CLÍNICA MARFIL',
		'category_id' => '1',
		'establishment_type' => '1',
		'image' => null,
		'image_dir' => null,
		'web' => 'http://www.clinicamarfilorihuela.es',
		'short_description' => null,
		'description' => null,
		'fiscalnumber' => null,
		'address1' => 'C/. Avenida de España, 3',
		'address2' => 'Bajo',
		'email' => 'marfilplayasl@gmail.com',
		'fax' => null,
		'mobile' => '',
		'mobile2' => '',
		'phone' => '966936482',
		'phone2' => '',
		'zipcode' => '03300',
		'town' => 'Orihuela',
		'state' => 'Alicante',
		'country' => 'España',
		'latitude' => '38.083027',
		'longitude' => '-0.946121',
		'slug' => null,
		'canonical' => 'fisioterapia/orihuela/clinica-marfil',
		'canonical_old' => null,
		'timetable' => null,
		'hash' => '141a51eabc000d38494ecbc84051b7b4',
		'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' => '7666',
		'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-09-04 16:37:05',
		'modified' => '2018-07-10 19:58:56',
		'sms' => null,
		'fulladdress' => 'C/. Avenida de España, 3, Orihuela ( 03300 ) , Alicante',
		'link' => 'https://www.fisiosite.com/fisioterapia/orihuela/clinica-marfil',
		'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

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' => '1626335154',
	'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) 1624565154,
	'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 Orihuela

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

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

Fisionova Plaza Nueva, 6, Orihuela ( 03300 ) , Alicante
Fisioterapia

Sin valoraciones
(0) Comentarios

2

Fisiocen Limón, 6, Orihuela ( 03300 ) , Alicante
Fisioterapia

Sin valoraciones
(0) Comentarios

3

Puri Jade (La Zenia II), 20, Orihuela ( 03189 ) , Alicante
Fisioterapia

Sin valoraciones
(0) Comentarios

4

Fisioterapia zafra C/ Campoamor Nº 2, Orihuela ( 03300 ) , Alicante
Fisioterapia

Sin valoraciones
(0) Comentarios

5

Clínica de fisioterapia reyma C/ Lavatorio Nº5, Orihuela ( 03300 ) , Alicante
Fisioterapia

Sin valoraciones
(0) Comentarios

6

Physiotherapy and osteopathy clinic,s. l. Picasso, 1, Orihuela ( 03189 ) , Alicante
Fisioterapia

Sin valoraciones
(0) Comentarios

7

Patricia menárguez fisioterapia y osteopatía C/ Mancebería, 60, Orihuela ( 03300 ) , Alicante
Fisioterapia

Sin valoraciones
(0) Comentarios

8

Clínica marfil C/. Avenida de España, 3, Orihuela ( 03300 ) , Alicante
Fisioterapia

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