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' => '763'
)
$query_establishments = array(
	'Establishment.population_id' => '763'
)
$key = (int) 0
$value = '763'
$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' => '6294',
			'name' => 'Francisco Miguel Cocera Morata - Clínica de Fisioterapia Cocera',
			'category_id' => '14',
			'establishment_type' => '1',
			'image' => null,
			'image_dir' => null,
			'web' => null,
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => '',
			'address1' => 'c/ María Alba, 8',
			'address2' => '',
			'email' => 'clinicacocera@hotmail.com',
			'fax' => null,
			'mobile' => '',
			'mobile2' => null,
			'phone' => '955862399',
			'phone2' => null,
			'zipcode' => '41710',
			'town' => 'Utrera',
			'state' => 'Sevilla',
			'country' => 'España',
			'latitude' => '37.185684',
			'longitude' => '-5.779523',
			'slug' => 'francisco-miguel-cocera-morata-clinica-de-fisioterapia-cocera-c-maria-alba',
			'canonical' => 'osteopatia/utrera/francisco-miguel-cocera-morata-clinica-de-fisioterapia-cocera',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => 'ac6a1bf8e6f67d19096ef487ca5dd5da',
			'hash_old' => null,
			'deleted' => false,
			'deleterequest' => null,
			'user_id' => null,
			'plan_id' => '1',
			'next_plan_id' => null,
			'video' => null,
			'pinterest' => null,
			'googleplus' => null,
			'youtube' => null,
			'linkedin' => null,
			'facebook' => null,
			'twitter' => null,
			'status' => '1',
			'subscription_status' => '0',
			'subscription_id' => '0',
			'population_id' => '763',
			'bank' => null,
			'bank_cert' => null,
			'bank_cert_dir' => null,
			'bank_cert_status' => null,
			'file_dni' => null,
			'file_dni_dir' => null,
			'writers' => null,
			'writers_dir' => null,
			'split_id' => null,
			'created' => '2016-09-21 17:19:42',
			'modified' => '2018-07-10 19:47:29',
			'sms' => null,
			'fulladdress' => 'c/ María Alba, 8, Utrera ( 41710 ) , Sevilla',
			'link' => 'https://www.fisiosite.com/osteopatia/utrera/francisco-miguel-cocera-morata-clinica-de-fisioterapia-cocera',
			'path_cert' => '/var/www/fisiosite.com/webroot//files/establishment/bank_cert//',
			'path_dni' => '/var/www/fisiosite.com/webroot//files/establishment/file_dni//',
			'path_writers' => '/var/www/fisiosite.com/webroot//files/establishment/writers//',
			'rating' => false,
			'is_open' => false
		),
		'Category' => array(
			'id' => '14',
			'name' => 'OSTEOPATIA',
			'slug' => 'osteopatia',
			'description' => '',
			'parent_id' => '1',
			'created' => '2016-06-13 12:15:16',
			'modified' => '2016-06-13 12:15:16',
			'lft' => '26',
			'rght' => '27'
		),
		'EstablishmentsCategory' => array(
			'id' => null,
			'establishment_id' => null,
			'category_id' => null,
			'created' => null,
			'modified' => null
		),
		'Service' => array(),
		'Slide' => array(
			'id' => null,
			'model' => null,
			'foreign_key' => null,
			'name' => null,
			'attachment' => null,
			'dir' => null,
			'type' => null,
			'size' => null,
			'active' => null
		),
		(int) 0 => array(
			'have_date' => '0'
		),
		'Comment' => array(),
		'Staff' => array(),
		'Slots' => array()
	),
	(int) 1 => array(
		'Establishment' => array(
			'id' => '11271',
			'name' => 'Centro Profesional de Recuperacion Funcional SLP ',
			'category_id' => '1',
			'establishment_type' => null,
			'image' => null,
			'image_dir' => null,
			'web' => 'http://www.cprf.es',
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => null,
			'address1' => 'Calle Sevilla',
			'address2' => '56',
			'email' => 'info@cpr.es',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '955 86 26 00',
			'phone2' => '',
			'zipcode' => '41710',
			'town' => 'Utrera',
			'state' => 'Sevilla',
			'country' => 'España',
			'latitude' => '37.183491',
			'longitude' => '-5.783145',
			'slug' => null,
			'canonical' => 'fisioterapia/utrera/centro-profesional-de-recuperacion-funcional-slp',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => '58c80399509b487b6724f414e9a51ce9',
			'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' => '763',
			'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-11-30 12:28:22',
			'modified' => '2018-07-10 20:07:26',
			'sms' => null,
			'fulladdress' => 'Calle Sevilla, Utrera ( 41710 ) , Sevilla',
			'link' => 'https://www.fisiosite.com/fisioterapia/utrera/centro-profesional-de-recuperacion-funcional-slp',
			'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' => '11272',
			'name' => 'FisioPie',
			'category_id' => '1',
			'establishment_type' => null,
			'image' => null,
			'image_dir' => null,
			'web' => 'http://www.fisiopieutrera.com',
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => null,
			'address1' => 'Calle Rubén Darío',
			'address2' => '24',
			'email' => 'info@fisiopieutrera.com',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '955 86 31 70',
			'phone2' => '',
			'zipcode' => '41710',
			'town' => 'Utrera',
			'state' => 'Sevilla',
			'country' => 'España',
			'latitude' => '37.188004',
			'longitude' => '-5.786162',
			'slug' => null,
			'canonical' => 'fisioterapia/utrera/fisiopie',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => 'bcdfeb01f924e68c32bab078d919d64d',
			'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' => '763',
			'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-11-30 12:28:26',
			'modified' => '2018-07-10 20:07:26',
			'sms' => null,
			'fulladdress' => 'Calle Rubén Darío, Utrera ( 41710 ) , Sevilla',
			'link' => 'https://www.fisiosite.com/fisioterapia/utrera/fisiopie',
			'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' => '11373',
			'name' => 'Clínica De Fisioterapia Cocera ',
			'category_id' => '1',
			'establishment_type' => null,
			'image' => null,
			'image_dir' => null,
			'web' => 'http://clinicacocera.blogspot.com.es',
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => null,
			'address1' => 'C/María Alba',
			'address2' => '8',
			'email' => 'clinicacocera@gmail.com',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '955 86 23 99',
			'phone2' => '677493398',
			'zipcode' => '41710',
			'town' => 'Utrera',
			'state' => 'Sevilla',
			'country' => 'España',
			'latitude' => '37.186058',
			'longitude' => '-5.778937',
			'slug' => null,
			'canonical' => 'fisioterapia/utrera/clinica-de-fisioterapia-cocera',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => '22aeff7f9c728017e77778dd9c95b0d8',
			'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' => '763',
			'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-11-30 13:03:06',
			'modified' => '2018-07-10 20:07:53',
			'sms' => null,
			'fulladdress' => 'C/María Alba, Utrera ( 41710 ) , Sevilla',
			'link' => 'https://www.fisiosite.com/fisioterapia/utrera/clinica-de-fisioterapia-cocera',
			'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' => '11374',
			'name' => 'Asd Club Gimnasio Millán ',
			'category_id' => '17',
			'establishment_type' => null,
			'image' => null,
			'image_dir' => null,
			'web' => '',
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => null,
			'address1' => ' Calle Calderón de la Barca',
			'address2' => '9',
			'email' => '',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '954 86 19 37',
			'phone2' => '',
			'zipcode' => '41710',
			'town' => 'Utrera',
			'state' => 'Sevilla',
			'country' => 'España',
			'latitude' => '37.192009',
			'longitude' => '-5.782663',
			'slug' => null,
			'canonical' => 'pilates/utrera/asd-club-gimnasio-millan',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => '37b8a7e7a1f2fdebcd5fb5115cb475d5',
			'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' => '763',
			'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-11-30 13:03:10',
			'modified' => '2018-07-10 20:07:53',
			'sms' => null,
			'fulladdress' => ' Calle Calderón de la Barca, Utrera ( 41710 ) , Sevilla',
			'link' => 'https://www.fisiosite.com/pilates/utrera/asd-club-gimnasio-millan',
			'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' => '17',
			'name' => 'PILATES',
			'slug' => 'pilates',
			'description' => '',
			'parent_id' => '1',
			'created' => '2016-06-13 12:15:16',
			'modified' => '2016-06-13 12:15:16',
			'lft' => '32',
			'rght' => '33'
		),
		'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' => '12589',
			'name' => 'TECUM CENTER',
			'category_id' => '1',
			'establishment_type' => '2',
			'image' => null,
			'image_dir' => null,
			'web' => 'https://fisioterapiaymovimientoalvarogonzalezfajardo.negocio.site/?m=true',
			'short_description' => null,
			'description' => 'Clínica de fisioterapia avanzada en Utrera. Fisioterapeuta profesional, en constante actualización y formación.
Nos basamos en un tratamiento integral del paciente mediante valoración completa inicial, terapia manual, ejercicio y educación para la salud.
Técnicas que ofrecemos: movilizaciones, masaje terapéutico, terapia manual instrumental, electroterapia, inducción miofascial, movimiento funcional, pilates terapéutico, punción seca, vibroterapia, diatermia recuperadora, presoterapia.
Fisioterapia global e integrativa de nuestro sistema neuro-músculo-fascia-esquelético.
Tratamientos de lesiones deportivas, traumatológicas, recuperación en personas mayores, neurológicos, post-ictus, post-cirugía o intervención quirúrgica, rehabilitación.',
			'fiscalnumber' => '47393257D',
			'address1' => 'Avenida María Auxiliadora 94',
			'address2' => 'TECUM CENTER',
			'email' => 'alvarogfisio@gmail.com',
			'fax' => null,
			'mobile' => null,
			'mobile2' => null,
			'phone' => '634598702',
			'phone2' => '634598702',
			'zipcode' => '41710',
			'town' => 'Utrera',
			'state' => 'Sevilla',
			'country' => null,
			'latitude' => null,
			'longitude' => null,
			'slug' => null,
			'canonical' => 'fisioterapia/utrera/tecum-center',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => '904a964f9cbdb61b9105e4f1b9e9790c',
			'hash_old' => null,
			'deleted' => false,
			'deleterequest' => null,
			'user_id' => '60a4cb23-13e4-43fd-8c46-73fc335b89d7',
			'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' => null,
			'subscription_id' => null,
			'population_id' => '763',
			'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' => '2021-05-19 10:30:48',
			'modified' => '2021-05-20 00:42:56',
			'sms' => null,
			'fulladdress' => 'Avenida María Auxiliadora 94, Utrera ( 41710 ) , Sevilla',
			'link' => 'https://www.fisiosite.com/fisioterapia/utrera/tecum-center',
			'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) 6
$e = array(
	'Establishment' => array(
		'id' => '6294',
		'name' => 'Francisco Miguel Cocera Morata - Clínica de Fisioterapia Cocera',
		'category_id' => '14',
		'establishment_type' => '1',
		'image' => null,
		'image_dir' => null,
		'web' => null,
		'short_description' => null,
		'description' => null,
		'fiscalnumber' => '',
		'address1' => 'c/ María Alba, 8',
		'address2' => '',
		'email' => 'clinicacocera@hotmail.com',
		'fax' => null,
		'mobile' => '',
		'mobile2' => null,
		'phone' => '955862399',
		'phone2' => null,
		'zipcode' => '41710',
		'town' => 'Utrera',
		'state' => 'Sevilla',
		'country' => 'España',
		'latitude' => '37.185684',
		'longitude' => '-5.779523',
		'slug' => 'francisco-miguel-cocera-morata-clinica-de-fisioterapia-cocera-c-maria-alba',
		'canonical' => 'osteopatia/utrera/francisco-miguel-cocera-morata-clinica-de-fisioterapia-cocera',
		'canonical_old' => null,
		'timetable' => null,
		'hash' => 'ac6a1bf8e6f67d19096ef487ca5dd5da',
		'hash_old' => null,
		'deleted' => false,
		'deleterequest' => null,
		'user_id' => null,
		'plan_id' => '1',
		'next_plan_id' => null,
		'video' => null,
		'pinterest' => null,
		'googleplus' => null,
		'youtube' => null,
		'linkedin' => null,
		'facebook' => null,
		'twitter' => null,
		'status' => '1',
		'subscription_status' => '0',
		'subscription_id' => '0',
		'population_id' => '763',
		'bank' => null,
		'bank_cert' => null,
		'bank_cert_dir' => null,
		'bank_cert_status' => null,
		'file_dni' => null,
		'file_dni_dir' => null,
		'writers' => null,
		'writers_dir' => null,
		'split_id' => null,
		'created' => '2016-09-21 17:19:42',
		'modified' => '2018-07-10 19:47:29',
		'sms' => null,
		'fulladdress' => 'c/ María Alba, 8, Utrera ( 41710 ) , Sevilla',
		'link' => 'https://www.fisiosite.com/osteopatia/utrera/francisco-miguel-cocera-morata-clinica-de-fisioterapia-cocera',
		'path_cert' => '/var/www/fisiosite.com/webroot//files/establishment/bank_cert//',
		'path_dni' => '/var/www/fisiosite.com/webroot//files/establishment/file_dni//',
		'path_writers' => '/var/www/fisiosite.com/webroot//files/establishment/writers//'
	),
	'Category' => array(
		'id' => '14',
		'name' => 'OSTEOPATIA',
		'slug' => 'osteopatia',
		'description' => '',
		'parent_id' => '1',
		'created' => '2016-06-13 12:15:16',
		'modified' => '2016-06-13 12:15:16',
		'lft' => '26',
		'rght' => '27'
	),
	'EstablishmentsCategory' => array(
		'id' => null,
		'establishment_id' => null,
		'category_id' => null,
		'created' => null,
		'modified' => null
	),
	'Service' => array(
		'id' => null,
		'name' => null,
		'description' => null,
		'duration_reserved' => null,
		'duration' => null,
		'price' => null,
		'slots' => null,
		'pay_online' => null,
		'establishment_id' => null,
		'created_status' => null,
		'tag' => null,
		'created' => null,
		'modified' => null
	),
	'Slide' => array(
		'id' => null,
		'model' => null,
		'foreign_key' => null,
		'name' => null,
		'attachment' => null,
		'dir' => null,
		'type' => null,
		'size' => null,
		'active' => null
	),
	(int) 0 => array(
		'have_date' => '0'
	),
	'Comment' => array(),
	'Staff' => array()
)
$comments = array()
SearchController::search_establishments() - APP/Controller/SearchController.php, line 957
SearchController::query() - APP/Controller/SearchController.php, line 1041
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - APP/Vendor/cakephp/cakephp/lib/Cake/Controller/Controller.php, line 490
Dispatcher::_invoke() - APP/Vendor/cakephp/cakephp/lib/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - APP/Vendor/cakephp/cakephp/lib/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 133

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' => '763'
)
$query_establishments = array(
	'Establishment.population_id' => '763'
)
$key = (int) 1
$value = '763'
$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' => '6294',
			'name' => 'Francisco Miguel Cocera Morata - Clínica de Fisioterapia Cocera',
			'category_id' => '14',
			'establishment_type' => '1',
			'image' => null,
			'image_dir' => null,
			'web' => null,
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => '',
			'address1' => 'c/ María Alba, 8',
			'address2' => '',
			'email' => 'clinicacocera@hotmail.com',
			'fax' => null,
			'mobile' => '',
			'mobile2' => null,
			'phone' => '955862399',
			'phone2' => null,
			'zipcode' => '41710',
			'town' => 'Utrera',
			'state' => 'Sevilla',
			'country' => 'España',
			'latitude' => '37.185684',
			'longitude' => '-5.779523',
			'slug' => 'francisco-miguel-cocera-morata-clinica-de-fisioterapia-cocera-c-maria-alba',
			'canonical' => 'osteopatia/utrera/francisco-miguel-cocera-morata-clinica-de-fisioterapia-cocera',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => 'ac6a1bf8e6f67d19096ef487ca5dd5da',
			'hash_old' => null,
			'deleted' => false,
			'deleterequest' => null,
			'user_id' => null,
			'plan_id' => '1',
			'next_plan_id' => null,
			'video' => null,
			'pinterest' => null,
			'googleplus' => null,
			'youtube' => null,
			'linkedin' => null,
			'facebook' => null,
			'twitter' => null,
			'status' => '1',
			'subscription_status' => '0',
			'subscription_id' => '0',
			'population_id' => '763',
			'bank' => null,
			'bank_cert' => null,
			'bank_cert_dir' => null,
			'bank_cert_status' => null,
			'file_dni' => null,
			'file_dni_dir' => null,
			'writers' => null,
			'writers_dir' => null,
			'split_id' => null,
			'created' => '2016-09-21 17:19:42',
			'modified' => '2018-07-10 19:47:29',
			'sms' => null,
			'fulladdress' => 'c/ María Alba, 8, Utrera ( 41710 ) , Sevilla',
			'link' => 'https://www.fisiosite.com/osteopatia/utrera/francisco-miguel-cocera-morata-clinica-de-fisioterapia-cocera',
			'path_cert' => '/var/www/fisiosite.com/webroot//files/establishment/bank_cert//',
			'path_dni' => '/var/www/fisiosite.com/webroot//files/establishment/file_dni//',
			'path_writers' => '/var/www/fisiosite.com/webroot//files/establishment/writers//',
			'rating' => false,
			'is_open' => false
		),
		'Category' => array(
			'id' => '14',
			'name' => 'OSTEOPATIA',
			'slug' => 'osteopatia',
			'description' => '',
			'parent_id' => '1',
			'created' => '2016-06-13 12:15:16',
			'modified' => '2016-06-13 12:15:16',
			'lft' => '26',
			'rght' => '27'
		),
		'EstablishmentsCategory' => array(
			'id' => null,
			'establishment_id' => null,
			'category_id' => null,
			'created' => null,
			'modified' => null
		),
		'Service' => array(),
		'Slide' => array(
			'id' => null,
			'model' => null,
			'foreign_key' => null,
			'name' => null,
			'attachment' => null,
			'dir' => null,
			'type' => null,
			'size' => null,
			'active' => null
		),
		(int) 0 => array(
			'have_date' => '0'
		),
		'Comment' => array(),
		'Staff' => array(),
		'Slots' => array()
	),
	(int) 1 => array(
		'Establishment' => array(
			'id' => '11271',
			'name' => 'Centro Profesional de Recuperacion Funcional SLP ',
			'category_id' => '1',
			'establishment_type' => null,
			'image' => null,
			'image_dir' => null,
			'web' => 'http://www.cprf.es',
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => null,
			'address1' => 'Calle Sevilla',
			'address2' => '56',
			'email' => 'info@cpr.es',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '955 86 26 00',
			'phone2' => '',
			'zipcode' => '41710',
			'town' => 'Utrera',
			'state' => 'Sevilla',
			'country' => 'España',
			'latitude' => '37.183491',
			'longitude' => '-5.783145',
			'slug' => null,
			'canonical' => 'fisioterapia/utrera/centro-profesional-de-recuperacion-funcional-slp',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => '58c80399509b487b6724f414e9a51ce9',
			'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' => '763',
			'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-11-30 12:28:22',
			'modified' => '2018-07-10 20:07:26',
			'sms' => null,
			'fulladdress' => 'Calle Sevilla, Utrera ( 41710 ) , Sevilla',
			'link' => 'https://www.fisiosite.com/fisioterapia/utrera/centro-profesional-de-recuperacion-funcional-slp',
			'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' => '11272',
			'name' => 'FisioPie',
			'category_id' => '1',
			'establishment_type' => null,
			'image' => null,
			'image_dir' => null,
			'web' => 'http://www.fisiopieutrera.com',
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => null,
			'address1' => 'Calle Rubén Darío',
			'address2' => '24',
			'email' => 'info@fisiopieutrera.com',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '955 86 31 70',
			'phone2' => '',
			'zipcode' => '41710',
			'town' => 'Utrera',
			'state' => 'Sevilla',
			'country' => 'España',
			'latitude' => '37.188004',
			'longitude' => '-5.786162',
			'slug' => null,
			'canonical' => 'fisioterapia/utrera/fisiopie',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => 'bcdfeb01f924e68c32bab078d919d64d',
			'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' => '763',
			'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-11-30 12:28:26',
			'modified' => '2018-07-10 20:07:26',
			'sms' => null,
			'fulladdress' => 'Calle Rubén Darío, Utrera ( 41710 ) , Sevilla',
			'link' => 'https://www.fisiosite.com/fisioterapia/utrera/fisiopie',
			'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' => '11373',
			'name' => 'Clínica De Fisioterapia Cocera ',
			'category_id' => '1',
			'establishment_type' => null,
			'image' => null,
			'image_dir' => null,
			'web' => 'http://clinicacocera.blogspot.com.es',
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => null,
			'address1' => 'C/María Alba',
			'address2' => '8',
			'email' => 'clinicacocera@gmail.com',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '955 86 23 99',
			'phone2' => '677493398',
			'zipcode' => '41710',
			'town' => 'Utrera',
			'state' => 'Sevilla',
			'country' => 'España',
			'latitude' => '37.186058',
			'longitude' => '-5.778937',
			'slug' => null,
			'canonical' => 'fisioterapia/utrera/clinica-de-fisioterapia-cocera',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => '22aeff7f9c728017e77778dd9c95b0d8',
			'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' => '763',
			'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-11-30 13:03:06',
			'modified' => '2018-07-10 20:07:53',
			'sms' => null,
			'fulladdress' => 'C/María Alba, Utrera ( 41710 ) , Sevilla',
			'link' => 'https://www.fisiosite.com/fisioterapia/utrera/clinica-de-fisioterapia-cocera',
			'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' => '11374',
			'name' => 'Asd Club Gimnasio Millán ',
			'category_id' => '17',
			'establishment_type' => null,
			'image' => null,
			'image_dir' => null,
			'web' => '',
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => null,
			'address1' => ' Calle Calderón de la Barca',
			'address2' => '9',
			'email' => '',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '954 86 19 37',
			'phone2' => '',
			'zipcode' => '41710',
			'town' => 'Utrera',
			'state' => 'Sevilla',
			'country' => 'España',
			'latitude' => '37.192009',
			'longitude' => '-5.782663',
			'slug' => null,
			'canonical' => 'pilates/utrera/asd-club-gimnasio-millan',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => '37b8a7e7a1f2fdebcd5fb5115cb475d5',
			'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' => '763',
			'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-11-30 13:03:10',
			'modified' => '2018-07-10 20:07:53',
			'sms' => null,
			'fulladdress' => ' Calle Calderón de la Barca, Utrera ( 41710 ) , Sevilla',
			'link' => 'https://www.fisiosite.com/pilates/utrera/asd-club-gimnasio-millan',
			'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' => '17',
			'name' => 'PILATES',
			'slug' => 'pilates',
			'description' => '',
			'parent_id' => '1',
			'created' => '2016-06-13 12:15:16',
			'modified' => '2016-06-13 12:15:16',
			'lft' => '32',
			'rght' => '33'
		),
		'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' => '12589',
			'name' => 'TECUM CENTER',
			'category_id' => '1',
			'establishment_type' => '2',
			'image' => null,
			'image_dir' => null,
			'web' => 'https://fisioterapiaymovimientoalvarogonzalezfajardo.negocio.site/?m=true',
			'short_description' => null,
			'description' => 'Clínica de fisioterapia avanzada en Utrera. Fisioterapeuta profesional, en constante actualización y formación.
Nos basamos en un tratamiento integral del paciente mediante valoración completa inicial, terapia manual, ejercicio y educación para la salud.
Técnicas que ofrecemos: movilizaciones, masaje terapéutico, terapia manual instrumental, electroterapia, inducción miofascial, movimiento funcional, pilates terapéutico, punción seca, vibroterapia, diatermia recuperadora, presoterapia.
Fisioterapia global e integrativa de nuestro sistema neuro-músculo-fascia-esquelético.
Tratamientos de lesiones deportivas, traumatológicas, recuperación en personas mayores, neurológicos, post-ictus, post-cirugía o intervención quirúrgica, rehabilitación.',
			'fiscalnumber' => '47393257D',
			'address1' => 'Avenida María Auxiliadora 94',
			'address2' => 'TECUM CENTER',
			'email' => 'alvarogfisio@gmail.com',
			'fax' => null,
			'mobile' => null,
			'mobile2' => null,
			'phone' => '634598702',
			'phone2' => '634598702',
			'zipcode' => '41710',
			'town' => 'Utrera',
			'state' => 'Sevilla',
			'country' => null,
			'latitude' => null,
			'longitude' => null,
			'slug' => null,
			'canonical' => 'fisioterapia/utrera/tecum-center',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => '904a964f9cbdb61b9105e4f1b9e9790c',
			'hash_old' => null,
			'deleted' => false,
			'deleterequest' => null,
			'user_id' => '60a4cb23-13e4-43fd-8c46-73fc335b89d7',
			'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' => null,
			'subscription_id' => null,
			'population_id' => '763',
			'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' => '2021-05-19 10:30:48',
			'modified' => '2021-05-20 00:42:56',
			'sms' => null,
			'fulladdress' => 'Avenida María Auxiliadora 94, Utrera ( 41710 ) , Sevilla',
			'link' => 'https://www.fisiosite.com/fisioterapia/utrera/tecum-center',
			'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) 6
$e = array(
	'Establishment' => array(
		'id' => '11271',
		'name' => 'Centro Profesional de Recuperacion Funcional SLP ',
		'category_id' => '1',
		'establishment_type' => null,
		'image' => null,
		'image_dir' => null,
		'web' => 'http://www.cprf.es',
		'short_description' => null,
		'description' => null,
		'fiscalnumber' => null,
		'address1' => 'Calle Sevilla',
		'address2' => '56',
		'email' => 'info@cpr.es',
		'fax' => null,
		'mobile' => '',
		'mobile2' => '',
		'phone' => '955 86 26 00',
		'phone2' => '',
		'zipcode' => '41710',
		'town' => 'Utrera',
		'state' => 'Sevilla',
		'country' => 'España',
		'latitude' => '37.183491',
		'longitude' => '-5.783145',
		'slug' => null,
		'canonical' => 'fisioterapia/utrera/centro-profesional-de-recuperacion-funcional-slp',
		'canonical_old' => null,
		'timetable' => null,
		'hash' => '58c80399509b487b6724f414e9a51ce9',
		'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' => '763',
		'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-11-30 12:28:22',
		'modified' => '2018-07-10 20:07:26',
		'sms' => null,
		'fulladdress' => 'Calle Sevilla, Utrera ( 41710 ) , Sevilla',
		'link' => 'https://www.fisiosite.com/fisioterapia/utrera/centro-profesional-de-recuperacion-funcional-slp',
		'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' => '763'
)
$query_establishments = array(
	'Establishment.population_id' => '763'
)
$key = (int) 2
$value = '763'
$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' => '6294',
			'name' => 'Francisco Miguel Cocera Morata - Clínica de Fisioterapia Cocera',
			'category_id' => '14',
			'establishment_type' => '1',
			'image' => null,
			'image_dir' => null,
			'web' => null,
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => '',
			'address1' => 'c/ María Alba, 8',
			'address2' => '',
			'email' => 'clinicacocera@hotmail.com',
			'fax' => null,
			'mobile' => '',
			'mobile2' => null,
			'phone' => '955862399',
			'phone2' => null,
			'zipcode' => '41710',
			'town' => 'Utrera',
			'state' => 'Sevilla',
			'country' => 'España',
			'latitude' => '37.185684',
			'longitude' => '-5.779523',
			'slug' => 'francisco-miguel-cocera-morata-clinica-de-fisioterapia-cocera-c-maria-alba',
			'canonical' => 'osteopatia/utrera/francisco-miguel-cocera-morata-clinica-de-fisioterapia-cocera',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => 'ac6a1bf8e6f67d19096ef487ca5dd5da',
			'hash_old' => null,
			'deleted' => false,
			'deleterequest' => null,
			'user_id' => null,
			'plan_id' => '1',
			'next_plan_id' => null,
			'video' => null,
			'pinterest' => null,
			'googleplus' => null,
			'youtube' => null,
			'linkedin' => null,
			'facebook' => null,
			'twitter' => null,
			'status' => '1',
			'subscription_status' => '0',
			'subscription_id' => '0',
			'population_id' => '763',
			'bank' => null,
			'bank_cert' => null,
			'bank_cert_dir' => null,
			'bank_cert_status' => null,
			'file_dni' => null,
			'file_dni_dir' => null,
			'writers' => null,
			'writers_dir' => null,
			'split_id' => null,
			'created' => '2016-09-21 17:19:42',
			'modified' => '2018-07-10 19:47:29',
			'sms' => null,
			'fulladdress' => 'c/ María Alba, 8, Utrera ( 41710 ) , Sevilla',
			'link' => 'https://www.fisiosite.com/osteopatia/utrera/francisco-miguel-cocera-morata-clinica-de-fisioterapia-cocera',
			'path_cert' => '/var/www/fisiosite.com/webroot//files/establishment/bank_cert//',
			'path_dni' => '/var/www/fisiosite.com/webroot//files/establishment/file_dni//',
			'path_writers' => '/var/www/fisiosite.com/webroot//files/establishment/writers//',
			'rating' => false,
			'is_open' => false
		),
		'Category' => array(
			'id' => '14',
			'name' => 'OSTEOPATIA',
			'slug' => 'osteopatia',
			'description' => '',
			'parent_id' => '1',
			'created' => '2016-06-13 12:15:16',
			'modified' => '2016-06-13 12:15:16',
			'lft' => '26',
			'rght' => '27'
		),
		'EstablishmentsCategory' => array(
			'id' => null,
			'establishment_id' => null,
			'category_id' => null,
			'created' => null,
			'modified' => null
		),
		'Service' => array(),
		'Slide' => array(
			'id' => null,
			'model' => null,
			'foreign_key' => null,
			'name' => null,
			'attachment' => null,
			'dir' => null,
			'type' => null,
			'size' => null,
			'active' => null
		),
		(int) 0 => array(
			'have_date' => '0'
		),
		'Comment' => array(),
		'Staff' => array(),
		'Slots' => array()
	),
	(int) 1 => array(
		'Establishment' => array(
			'id' => '11271',
			'name' => 'Centro Profesional de Recuperacion Funcional SLP ',
			'category_id' => '1',
			'establishment_type' => null,
			'image' => null,
			'image_dir' => null,
			'web' => 'http://www.cprf.es',
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => null,
			'address1' => 'Calle Sevilla',
			'address2' => '56',
			'email' => 'info@cpr.es',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '955 86 26 00',
			'phone2' => '',
			'zipcode' => '41710',
			'town' => 'Utrera',
			'state' => 'Sevilla',
			'country' => 'España',
			'latitude' => '37.183491',
			'longitude' => '-5.783145',
			'slug' => null,
			'canonical' => 'fisioterapia/utrera/centro-profesional-de-recuperacion-funcional-slp',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => '58c80399509b487b6724f414e9a51ce9',
			'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' => '763',
			'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-11-30 12:28:22',
			'modified' => '2018-07-10 20:07:26',
			'sms' => null,
			'fulladdress' => 'Calle Sevilla, Utrera ( 41710 ) , Sevilla',
			'link' => 'https://www.fisiosite.com/fisioterapia/utrera/centro-profesional-de-recuperacion-funcional-slp',
			'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' => '11272',
			'name' => 'FisioPie',
			'category_id' => '1',
			'establishment_type' => null,
			'image' => null,
			'image_dir' => null,
			'web' => 'http://www.fisiopieutrera.com',
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => null,
			'address1' => 'Calle Rubén Darío',
			'address2' => '24',
			'email' => 'info@fisiopieutrera.com',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '955 86 31 70',
			'phone2' => '',
			'zipcode' => '41710',
			'town' => 'Utrera',
			'state' => 'Sevilla',
			'country' => 'España',
			'latitude' => '37.188004',
			'longitude' => '-5.786162',
			'slug' => null,
			'canonical' => 'fisioterapia/utrera/fisiopie',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => 'bcdfeb01f924e68c32bab078d919d64d',
			'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' => '763',
			'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-11-30 12:28:26',
			'modified' => '2018-07-10 20:07:26',
			'sms' => null,
			'fulladdress' => 'Calle Rubén Darío, Utrera ( 41710 ) , Sevilla',
			'link' => 'https://www.fisiosite.com/fisioterapia/utrera/fisiopie',
			'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' => '11373',
			'name' => 'Clínica De Fisioterapia Cocera ',
			'category_id' => '1',
			'establishment_type' => null,
			'image' => null,
			'image_dir' => null,
			'web' => 'http://clinicacocera.blogspot.com.es',
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => null,
			'address1' => 'C/María Alba',
			'address2' => '8',
			'email' => 'clinicacocera@gmail.com',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '955 86 23 99',
			'phone2' => '677493398',
			'zipcode' => '41710',
			'town' => 'Utrera',
			'state' => 'Sevilla',
			'country' => 'España',
			'latitude' => '37.186058',
			'longitude' => '-5.778937',
			'slug' => null,
			'canonical' => 'fisioterapia/utrera/clinica-de-fisioterapia-cocera',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => '22aeff7f9c728017e77778dd9c95b0d8',
			'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' => '763',
			'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-11-30 13:03:06',
			'modified' => '2018-07-10 20:07:53',
			'sms' => null,
			'fulladdress' => 'C/María Alba, Utrera ( 41710 ) , Sevilla',
			'link' => 'https://www.fisiosite.com/fisioterapia/utrera/clinica-de-fisioterapia-cocera',
			'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' => '11374',
			'name' => 'Asd Club Gimnasio Millán ',
			'category_id' => '17',
			'establishment_type' => null,
			'image' => null,
			'image_dir' => null,
			'web' => '',
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => null,
			'address1' => ' Calle Calderón de la Barca',
			'address2' => '9',
			'email' => '',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '954 86 19 37',
			'phone2' => '',
			'zipcode' => '41710',
			'town' => 'Utrera',
			'state' => 'Sevilla',
			'country' => 'España',
			'latitude' => '37.192009',
			'longitude' => '-5.782663',
			'slug' => null,
			'canonical' => 'pilates/utrera/asd-club-gimnasio-millan',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => '37b8a7e7a1f2fdebcd5fb5115cb475d5',
			'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' => '763',
			'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-11-30 13:03:10',
			'modified' => '2018-07-10 20:07:53',
			'sms' => null,
			'fulladdress' => ' Calle Calderón de la Barca, Utrera ( 41710 ) , Sevilla',
			'link' => 'https://www.fisiosite.com/pilates/utrera/asd-club-gimnasio-millan',
			'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' => '17',
			'name' => 'PILATES',
			'slug' => 'pilates',
			'description' => '',
			'parent_id' => '1',
			'created' => '2016-06-13 12:15:16',
			'modified' => '2016-06-13 12:15:16',
			'lft' => '32',
			'rght' => '33'
		),
		'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' => '12589',
			'name' => 'TECUM CENTER',
			'category_id' => '1',
			'establishment_type' => '2',
			'image' => null,
			'image_dir' => null,
			'web' => 'https://fisioterapiaymovimientoalvarogonzalezfajardo.negocio.site/?m=true',
			'short_description' => null,
			'description' => 'Clínica de fisioterapia avanzada en Utrera. Fisioterapeuta profesional, en constante actualización y formación.
Nos basamos en un tratamiento integral del paciente mediante valoración completa inicial, terapia manual, ejercicio y educación para la salud.
Técnicas que ofrecemos: movilizaciones, masaje terapéutico, terapia manual instrumental, electroterapia, inducción miofascial, movimiento funcional, pilates terapéutico, punción seca, vibroterapia, diatermia recuperadora, presoterapia.
Fisioterapia global e integrativa de nuestro sistema neuro-músculo-fascia-esquelético.
Tratamientos de lesiones deportivas, traumatológicas, recuperación en personas mayores, neurológicos, post-ictus, post-cirugía o intervención quirúrgica, rehabilitación.',
			'fiscalnumber' => '47393257D',
			'address1' => 'Avenida María Auxiliadora 94',
			'address2' => 'TECUM CENTER',
			'email' => 'alvarogfisio@gmail.com',
			'fax' => null,
			'mobile' => null,
			'mobile2' => null,
			'phone' => '634598702',
			'phone2' => '634598702',
			'zipcode' => '41710',
			'town' => 'Utrera',
			'state' => 'Sevilla',
			'country' => null,
			'latitude' => null,
			'longitude' => null,
			'slug' => null,
			'canonical' => 'fisioterapia/utrera/tecum-center',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => '904a964f9cbdb61b9105e4f1b9e9790c',
			'hash_old' => null,
			'deleted' => false,
			'deleterequest' => null,
			'user_id' => '60a4cb23-13e4-43fd-8c46-73fc335b89d7',
			'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' => null,
			'subscription_id' => null,
			'population_id' => '763',
			'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' => '2021-05-19 10:30:48',
			'modified' => '2021-05-20 00:42:56',
			'sms' => null,
			'fulladdress' => 'Avenida María Auxiliadora 94, Utrera ( 41710 ) , Sevilla',
			'link' => 'https://www.fisiosite.com/fisioterapia/utrera/tecum-center',
			'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) 6
$e = array(
	'Establishment' => array(
		'id' => '11272',
		'name' => 'FisioPie',
		'category_id' => '1',
		'establishment_type' => null,
		'image' => null,
		'image_dir' => null,
		'web' => 'http://www.fisiopieutrera.com',
		'short_description' => null,
		'description' => null,
		'fiscalnumber' => null,
		'address1' => 'Calle Rubén Darío',
		'address2' => '24',
		'email' => 'info@fisiopieutrera.com',
		'fax' => null,
		'mobile' => '',
		'mobile2' => '',
		'phone' => '955 86 31 70',
		'phone2' => '',
		'zipcode' => '41710',
		'town' => 'Utrera',
		'state' => 'Sevilla',
		'country' => 'España',
		'latitude' => '37.188004',
		'longitude' => '-5.786162',
		'slug' => null,
		'canonical' => 'fisioterapia/utrera/fisiopie',
		'canonical_old' => null,
		'timetable' => null,
		'hash' => 'bcdfeb01f924e68c32bab078d919d64d',
		'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' => '763',
		'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-11-30 12:28:26',
		'modified' => '2018-07-10 20:07:26',
		'sms' => null,
		'fulladdress' => 'Calle Rubén Darío, Utrera ( 41710 ) , Sevilla',
		'link' => 'https://www.fisiosite.com/fisioterapia/utrera/fisiopie',
		'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' => '763'
)
$query_establishments = array(
	'Establishment.population_id' => '763'
)
$key = (int) 3
$value = '763'
$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' => '6294',
			'name' => 'Francisco Miguel Cocera Morata - Clínica de Fisioterapia Cocera',
			'category_id' => '14',
			'establishment_type' => '1',
			'image' => null,
			'image_dir' => null,
			'web' => null,
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => '',
			'address1' => 'c/ María Alba, 8',
			'address2' => '',
			'email' => 'clinicacocera@hotmail.com',
			'fax' => null,
			'mobile' => '',
			'mobile2' => null,
			'phone' => '955862399',
			'phone2' => null,
			'zipcode' => '41710',
			'town' => 'Utrera',
			'state' => 'Sevilla',
			'country' => 'España',
			'latitude' => '37.185684',
			'longitude' => '-5.779523',
			'slug' => 'francisco-miguel-cocera-morata-clinica-de-fisioterapia-cocera-c-maria-alba',
			'canonical' => 'osteopatia/utrera/francisco-miguel-cocera-morata-clinica-de-fisioterapia-cocera',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => 'ac6a1bf8e6f67d19096ef487ca5dd5da',
			'hash_old' => null,
			'deleted' => false,
			'deleterequest' => null,
			'user_id' => null,
			'plan_id' => '1',
			'next_plan_id' => null,
			'video' => null,
			'pinterest' => null,
			'googleplus' => null,
			'youtube' => null,
			'linkedin' => null,
			'facebook' => null,
			'twitter' => null,
			'status' => '1',
			'subscription_status' => '0',
			'subscription_id' => '0',
			'population_id' => '763',
			'bank' => null,
			'bank_cert' => null,
			'bank_cert_dir' => null,
			'bank_cert_status' => null,
			'file_dni' => null,
			'file_dni_dir' => null,
			'writers' => null,
			'writers_dir' => null,
			'split_id' => null,
			'created' => '2016-09-21 17:19:42',
			'modified' => '2018-07-10 19:47:29',
			'sms' => null,
			'fulladdress' => 'c/ María Alba, 8, Utrera ( 41710 ) , Sevilla',
			'link' => 'https://www.fisiosite.com/osteopatia/utrera/francisco-miguel-cocera-morata-clinica-de-fisioterapia-cocera',
			'path_cert' => '/var/www/fisiosite.com/webroot//files/establishment/bank_cert//',
			'path_dni' => '/var/www/fisiosite.com/webroot//files/establishment/file_dni//',
			'path_writers' => '/var/www/fisiosite.com/webroot//files/establishment/writers//',
			'rating' => false,
			'is_open' => false
		),
		'Category' => array(
			'id' => '14',
			'name' => 'OSTEOPATIA',
			'slug' => 'osteopatia',
			'description' => '',
			'parent_id' => '1',
			'created' => '2016-06-13 12:15:16',
			'modified' => '2016-06-13 12:15:16',
			'lft' => '26',
			'rght' => '27'
		),
		'EstablishmentsCategory' => array(
			'id' => null,
			'establishment_id' => null,
			'category_id' => null,
			'created' => null,
			'modified' => null
		),
		'Service' => array(),
		'Slide' => array(
			'id' => null,
			'model' => null,
			'foreign_key' => null,
			'name' => null,
			'attachment' => null,
			'dir' => null,
			'type' => null,
			'size' => null,
			'active' => null
		),
		(int) 0 => array(
			'have_date' => '0'
		),
		'Comment' => array(),
		'Staff' => array(),
		'Slots' => array()
	),
	(int) 1 => array(
		'Establishment' => array(
			'id' => '11271',
			'name' => 'Centro Profesional de Recuperacion Funcional SLP ',
			'category_id' => '1',
			'establishment_type' => null,
			'image' => null,
			'image_dir' => null,
			'web' => 'http://www.cprf.es',
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => null,
			'address1' => 'Calle Sevilla',
			'address2' => '56',
			'email' => 'info@cpr.es',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '955 86 26 00',
			'phone2' => '',
			'zipcode' => '41710',
			'town' => 'Utrera',
			'state' => 'Sevilla',
			'country' => 'España',
			'latitude' => '37.183491',
			'longitude' => '-5.783145',
			'slug' => null,
			'canonical' => 'fisioterapia/utrera/centro-profesional-de-recuperacion-funcional-slp',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => '58c80399509b487b6724f414e9a51ce9',
			'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' => '763',
			'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-11-30 12:28:22',
			'modified' => '2018-07-10 20:07:26',
			'sms' => null,
			'fulladdress' => 'Calle Sevilla, Utrera ( 41710 ) , Sevilla',
			'link' => 'https://www.fisiosite.com/fisioterapia/utrera/centro-profesional-de-recuperacion-funcional-slp',
			'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' => '11272',
			'name' => 'FisioPie',
			'category_id' => '1',
			'establishment_type' => null,
			'image' => null,
			'image_dir' => null,
			'web' => 'http://www.fisiopieutrera.com',
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => null,
			'address1' => 'Calle Rubén Darío',
			'address2' => '24',
			'email' => 'info@fisiopieutrera.com',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '955 86 31 70',
			'phone2' => '',
			'zipcode' => '41710',
			'town' => 'Utrera',
			'state' => 'Sevilla',
			'country' => 'España',
			'latitude' => '37.188004',
			'longitude' => '-5.786162',
			'slug' => null,
			'canonical' => 'fisioterapia/utrera/fisiopie',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => 'bcdfeb01f924e68c32bab078d919d64d',
			'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' => '763',
			'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-11-30 12:28:26',
			'modified' => '2018-07-10 20:07:26',
			'sms' => null,
			'fulladdress' => 'Calle Rubén Darío, Utrera ( 41710 ) , Sevilla',
			'link' => 'https://www.fisiosite.com/fisioterapia/utrera/fisiopie',
			'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' => '11373',
			'name' => 'Clínica De Fisioterapia Cocera ',
			'category_id' => '1',
			'establishment_type' => null,
			'image' => null,
			'image_dir' => null,
			'web' => 'http://clinicacocera.blogspot.com.es',
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => null,
			'address1' => 'C/María Alba',
			'address2' => '8',
			'email' => 'clinicacocera@gmail.com',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '955 86 23 99',
			'phone2' => '677493398',
			'zipcode' => '41710',
			'town' => 'Utrera',
			'state' => 'Sevilla',
			'country' => 'España',
			'latitude' => '37.186058',
			'longitude' => '-5.778937',
			'slug' => null,
			'canonical' => 'fisioterapia/utrera/clinica-de-fisioterapia-cocera',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => '22aeff7f9c728017e77778dd9c95b0d8',
			'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' => '763',
			'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-11-30 13:03:06',
			'modified' => '2018-07-10 20:07:53',
			'sms' => null,
			'fulladdress' => 'C/María Alba, Utrera ( 41710 ) , Sevilla',
			'link' => 'https://www.fisiosite.com/fisioterapia/utrera/clinica-de-fisioterapia-cocera',
			'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' => '11374',
			'name' => 'Asd Club Gimnasio Millán ',
			'category_id' => '17',
			'establishment_type' => null,
			'image' => null,
			'image_dir' => null,
			'web' => '',
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => null,
			'address1' => ' Calle Calderón de la Barca',
			'address2' => '9',
			'email' => '',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '954 86 19 37',
			'phone2' => '',
			'zipcode' => '41710',
			'town' => 'Utrera',
			'state' => 'Sevilla',
			'country' => 'España',
			'latitude' => '37.192009',
			'longitude' => '-5.782663',
			'slug' => null,
			'canonical' => 'pilates/utrera/asd-club-gimnasio-millan',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => '37b8a7e7a1f2fdebcd5fb5115cb475d5',
			'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' => '763',
			'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-11-30 13:03:10',
			'modified' => '2018-07-10 20:07:53',
			'sms' => null,
			'fulladdress' => ' Calle Calderón de la Barca, Utrera ( 41710 ) , Sevilla',
			'link' => 'https://www.fisiosite.com/pilates/utrera/asd-club-gimnasio-millan',
			'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' => '17',
			'name' => 'PILATES',
			'slug' => 'pilates',
			'description' => '',
			'parent_id' => '1',
			'created' => '2016-06-13 12:15:16',
			'modified' => '2016-06-13 12:15:16',
			'lft' => '32',
			'rght' => '33'
		),
		'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' => '12589',
			'name' => 'TECUM CENTER',
			'category_id' => '1',
			'establishment_type' => '2',
			'image' => null,
			'image_dir' => null,
			'web' => 'https://fisioterapiaymovimientoalvarogonzalezfajardo.negocio.site/?m=true',
			'short_description' => null,
			'description' => 'Clínica de fisioterapia avanzada en Utrera. Fisioterapeuta profesional, en constante actualización y formación.
Nos basamos en un tratamiento integral del paciente mediante valoración completa inicial, terapia manual, ejercicio y educación para la salud.
Técnicas que ofrecemos: movilizaciones, masaje terapéutico, terapia manual instrumental, electroterapia, inducción miofascial, movimiento funcional, pilates terapéutico, punción seca, vibroterapia, diatermia recuperadora, presoterapia.
Fisioterapia global e integrativa de nuestro sistema neuro-músculo-fascia-esquelético.
Tratamientos de lesiones deportivas, traumatológicas, recuperación en personas mayores, neurológicos, post-ictus, post-cirugía o intervención quirúrgica, rehabilitación.',
			'fiscalnumber' => '47393257D',
			'address1' => 'Avenida María Auxiliadora 94',
			'address2' => 'TECUM CENTER',
			'email' => 'alvarogfisio@gmail.com',
			'fax' => null,
			'mobile' => null,
			'mobile2' => null,
			'phone' => '634598702',
			'phone2' => '634598702',
			'zipcode' => '41710',
			'town' => 'Utrera',
			'state' => 'Sevilla',
			'country' => null,
			'latitude' => null,
			'longitude' => null,
			'slug' => null,
			'canonical' => 'fisioterapia/utrera/tecum-center',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => '904a964f9cbdb61b9105e4f1b9e9790c',
			'hash_old' => null,
			'deleted' => false,
			'deleterequest' => null,
			'user_id' => '60a4cb23-13e4-43fd-8c46-73fc335b89d7',
			'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' => null,
			'subscription_id' => null,
			'population_id' => '763',
			'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' => '2021-05-19 10:30:48',
			'modified' => '2021-05-20 00:42:56',
			'sms' => null,
			'fulladdress' => 'Avenida María Auxiliadora 94, Utrera ( 41710 ) , Sevilla',
			'link' => 'https://www.fisiosite.com/fisioterapia/utrera/tecum-center',
			'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) 6
$e = array(
	'Establishment' => array(
		'id' => '11373',
		'name' => 'Clínica De Fisioterapia Cocera ',
		'category_id' => '1',
		'establishment_type' => null,
		'image' => null,
		'image_dir' => null,
		'web' => 'http://clinicacocera.blogspot.com.es',
		'short_description' => null,
		'description' => null,
		'fiscalnumber' => null,
		'address1' => 'C/María Alba',
		'address2' => '8',
		'email' => 'clinicacocera@gmail.com',
		'fax' => null,
		'mobile' => '',
		'mobile2' => '',
		'phone' => '955 86 23 99',
		'phone2' => '677493398',
		'zipcode' => '41710',
		'town' => 'Utrera',
		'state' => 'Sevilla',
		'country' => 'España',
		'latitude' => '37.186058',
		'longitude' => '-5.778937',
		'slug' => null,
		'canonical' => 'fisioterapia/utrera/clinica-de-fisioterapia-cocera',
		'canonical_old' => null,
		'timetable' => null,
		'hash' => '22aeff7f9c728017e77778dd9c95b0d8',
		'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' => '763',
		'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-11-30 13:03:06',
		'modified' => '2018-07-10 20:07:53',
		'sms' => null,
		'fulladdress' => 'C/María Alba, Utrera ( 41710 ) , Sevilla',
		'link' => 'https://www.fisiosite.com/fisioterapia/utrera/clinica-de-fisioterapia-cocera',
		'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' => '763'
)
$query_establishments = array(
	'Establishment.population_id' => '763'
)
$key = (int) 4
$value = '763'
$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' => '6294',
			'name' => 'Francisco Miguel Cocera Morata - Clínica de Fisioterapia Cocera',
			'category_id' => '14',
			'establishment_type' => '1',
			'image' => null,
			'image_dir' => null,
			'web' => null,
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => '',
			'address1' => 'c/ María Alba, 8',
			'address2' => '',
			'email' => 'clinicacocera@hotmail.com',
			'fax' => null,
			'mobile' => '',
			'mobile2' => null,
			'phone' => '955862399',
			'phone2' => null,
			'zipcode' => '41710',
			'town' => 'Utrera',
			'state' => 'Sevilla',
			'country' => 'España',
			'latitude' => '37.185684',
			'longitude' => '-5.779523',
			'slug' => 'francisco-miguel-cocera-morata-clinica-de-fisioterapia-cocera-c-maria-alba',
			'canonical' => 'osteopatia/utrera/francisco-miguel-cocera-morata-clinica-de-fisioterapia-cocera',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => 'ac6a1bf8e6f67d19096ef487ca5dd5da',
			'hash_old' => null,
			'deleted' => false,
			'deleterequest' => null,
			'user_id' => null,
			'plan_id' => '1',
			'next_plan_id' => null,
			'video' => null,
			'pinterest' => null,
			'googleplus' => null,
			'youtube' => null,
			'linkedin' => null,
			'facebook' => null,
			'twitter' => null,
			'status' => '1',
			'subscription_status' => '0',
			'subscription_id' => '0',
			'population_id' => '763',
			'bank' => null,
			'bank_cert' => null,
			'bank_cert_dir' => null,
			'bank_cert_status' => null,
			'file_dni' => null,
			'file_dni_dir' => null,
			'writers' => null,
			'writers_dir' => null,
			'split_id' => null,
			'created' => '2016-09-21 17:19:42',
			'modified' => '2018-07-10 19:47:29',
			'sms' => null,
			'fulladdress' => 'c/ María Alba, 8, Utrera ( 41710 ) , Sevilla',
			'link' => 'https://www.fisiosite.com/osteopatia/utrera/francisco-miguel-cocera-morata-clinica-de-fisioterapia-cocera',
			'path_cert' => '/var/www/fisiosite.com/webroot//files/establishment/bank_cert//',
			'path_dni' => '/var/www/fisiosite.com/webroot//files/establishment/file_dni//',
			'path_writers' => '/var/www/fisiosite.com/webroot//files/establishment/writers//',
			'rating' => false,
			'is_open' => false
		),
		'Category' => array(
			'id' => '14',
			'name' => 'OSTEOPATIA',
			'slug' => 'osteopatia',
			'description' => '',
			'parent_id' => '1',
			'created' => '2016-06-13 12:15:16',
			'modified' => '2016-06-13 12:15:16',
			'lft' => '26',
			'rght' => '27'
		),
		'EstablishmentsCategory' => array(
			'id' => null,
			'establishment_id' => null,
			'category_id' => null,
			'created' => null,
			'modified' => null
		),
		'Service' => array(),
		'Slide' => array(
			'id' => null,
			'model' => null,
			'foreign_key' => null,
			'name' => null,
			'attachment' => null,
			'dir' => null,
			'type' => null,
			'size' => null,
			'active' => null
		),
		(int) 0 => array(
			'have_date' => '0'
		),
		'Comment' => array(),
		'Staff' => array(),
		'Slots' => array()
	),
	(int) 1 => array(
		'Establishment' => array(
			'id' => '11271',
			'name' => 'Centro Profesional de Recuperacion Funcional SLP ',
			'category_id' => '1',
			'establishment_type' => null,
			'image' => null,
			'image_dir' => null,
			'web' => 'http://www.cprf.es',
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => null,
			'address1' => 'Calle Sevilla',
			'address2' => '56',
			'email' => 'info@cpr.es',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '955 86 26 00',
			'phone2' => '',
			'zipcode' => '41710',
			'town' => 'Utrera',
			'state' => 'Sevilla',
			'country' => 'España',
			'latitude' => '37.183491',
			'longitude' => '-5.783145',
			'slug' => null,
			'canonical' => 'fisioterapia/utrera/centro-profesional-de-recuperacion-funcional-slp',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => '58c80399509b487b6724f414e9a51ce9',
			'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' => '763',
			'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-11-30 12:28:22',
			'modified' => '2018-07-10 20:07:26',
			'sms' => null,
			'fulladdress' => 'Calle Sevilla, Utrera ( 41710 ) , Sevilla',
			'link' => 'https://www.fisiosite.com/fisioterapia/utrera/centro-profesional-de-recuperacion-funcional-slp',
			'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' => '11272',
			'name' => 'FisioPie',
			'category_id' => '1',
			'establishment_type' => null,
			'image' => null,
			'image_dir' => null,
			'web' => 'http://www.fisiopieutrera.com',
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => null,
			'address1' => 'Calle Rubén Darío',
			'address2' => '24',
			'email' => 'info@fisiopieutrera.com',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '955 86 31 70',
			'phone2' => '',
			'zipcode' => '41710',
			'town' => 'Utrera',
			'state' => 'Sevilla',
			'country' => 'España',
			'latitude' => '37.188004',
			'longitude' => '-5.786162',
			'slug' => null,
			'canonical' => 'fisioterapia/utrera/fisiopie',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => 'bcdfeb01f924e68c32bab078d919d64d',
			'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' => '763',
			'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-11-30 12:28:26',
			'modified' => '2018-07-10 20:07:26',
			'sms' => null,
			'fulladdress' => 'Calle Rubén Darío, Utrera ( 41710 ) , Sevilla',
			'link' => 'https://www.fisiosite.com/fisioterapia/utrera/fisiopie',
			'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' => '11373',
			'name' => 'Clínica De Fisioterapia Cocera ',
			'category_id' => '1',
			'establishment_type' => null,
			'image' => null,
			'image_dir' => null,
			'web' => 'http://clinicacocera.blogspot.com.es',
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => null,
			'address1' => 'C/María Alba',
			'address2' => '8',
			'email' => 'clinicacocera@gmail.com',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '955 86 23 99',
			'phone2' => '677493398',
			'zipcode' => '41710',
			'town' => 'Utrera',
			'state' => 'Sevilla',
			'country' => 'España',
			'latitude' => '37.186058',
			'longitude' => '-5.778937',
			'slug' => null,
			'canonical' => 'fisioterapia/utrera/clinica-de-fisioterapia-cocera',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => '22aeff7f9c728017e77778dd9c95b0d8',
			'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' => '763',
			'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-11-30 13:03:06',
			'modified' => '2018-07-10 20:07:53',
			'sms' => null,
			'fulladdress' => 'C/María Alba, Utrera ( 41710 ) , Sevilla',
			'link' => 'https://www.fisiosite.com/fisioterapia/utrera/clinica-de-fisioterapia-cocera',
			'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' => '11374',
			'name' => 'Asd Club Gimnasio Millán ',
			'category_id' => '17',
			'establishment_type' => null,
			'image' => null,
			'image_dir' => null,
			'web' => '',
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => null,
			'address1' => ' Calle Calderón de la Barca',
			'address2' => '9',
			'email' => '',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '954 86 19 37',
			'phone2' => '',
			'zipcode' => '41710',
			'town' => 'Utrera',
			'state' => 'Sevilla',
			'country' => 'España',
			'latitude' => '37.192009',
			'longitude' => '-5.782663',
			'slug' => null,
			'canonical' => 'pilates/utrera/asd-club-gimnasio-millan',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => '37b8a7e7a1f2fdebcd5fb5115cb475d5',
			'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' => '763',
			'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-11-30 13:03:10',
			'modified' => '2018-07-10 20:07:53',
			'sms' => null,
			'fulladdress' => ' Calle Calderón de la Barca, Utrera ( 41710 ) , Sevilla',
			'link' => 'https://www.fisiosite.com/pilates/utrera/asd-club-gimnasio-millan',
			'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' => '17',
			'name' => 'PILATES',
			'slug' => 'pilates',
			'description' => '',
			'parent_id' => '1',
			'created' => '2016-06-13 12:15:16',
			'modified' => '2016-06-13 12:15:16',
			'lft' => '32',
			'rght' => '33'
		),
		'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' => '12589',
			'name' => 'TECUM CENTER',
			'category_id' => '1',
			'establishment_type' => '2',
			'image' => null,
			'image_dir' => null,
			'web' => 'https://fisioterapiaymovimientoalvarogonzalezfajardo.negocio.site/?m=true',
			'short_description' => null,
			'description' => 'Clínica de fisioterapia avanzada en Utrera. Fisioterapeuta profesional, en constante actualización y formación.
Nos basamos en un tratamiento integral del paciente mediante valoración completa inicial, terapia manual, ejercicio y educación para la salud.
Técnicas que ofrecemos: movilizaciones, masaje terapéutico, terapia manual instrumental, electroterapia, inducción miofascial, movimiento funcional, pilates terapéutico, punción seca, vibroterapia, diatermia recuperadora, presoterapia.
Fisioterapia global e integrativa de nuestro sistema neuro-músculo-fascia-esquelético.
Tratamientos de lesiones deportivas, traumatológicas, recuperación en personas mayores, neurológicos, post-ictus, post-cirugía o intervención quirúrgica, rehabilitación.',
			'fiscalnumber' => '47393257D',
			'address1' => 'Avenida María Auxiliadora 94',
			'address2' => 'TECUM CENTER',
			'email' => 'alvarogfisio@gmail.com',
			'fax' => null,
			'mobile' => null,
			'mobile2' => null,
			'phone' => '634598702',
			'phone2' => '634598702',
			'zipcode' => '41710',
			'town' => 'Utrera',
			'state' => 'Sevilla',
			'country' => null,
			'latitude' => null,
			'longitude' => null,
			'slug' => null,
			'canonical' => 'fisioterapia/utrera/tecum-center',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => '904a964f9cbdb61b9105e4f1b9e9790c',
			'hash_old' => null,
			'deleted' => false,
			'deleterequest' => null,
			'user_id' => '60a4cb23-13e4-43fd-8c46-73fc335b89d7',
			'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' => null,
			'subscription_id' => null,
			'population_id' => '763',
			'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' => '2021-05-19 10:30:48',
			'modified' => '2021-05-20 00:42:56',
			'sms' => null,
			'fulladdress' => 'Avenida María Auxiliadora 94, Utrera ( 41710 ) , Sevilla',
			'link' => 'https://www.fisiosite.com/fisioterapia/utrera/tecum-center',
			'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) 6
$e = array(
	'Establishment' => array(
		'id' => '11374',
		'name' => 'Asd Club Gimnasio Millán ',
		'category_id' => '17',
		'establishment_type' => null,
		'image' => null,
		'image_dir' => null,
		'web' => '',
		'short_description' => null,
		'description' => null,
		'fiscalnumber' => null,
		'address1' => ' Calle Calderón de la Barca',
		'address2' => '9',
		'email' => '',
		'fax' => null,
		'mobile' => '',
		'mobile2' => '',
		'phone' => '954 86 19 37',
		'phone2' => '',
		'zipcode' => '41710',
		'town' => 'Utrera',
		'state' => 'Sevilla',
		'country' => 'España',
		'latitude' => '37.192009',
		'longitude' => '-5.782663',
		'slug' => null,
		'canonical' => 'pilates/utrera/asd-club-gimnasio-millan',
		'canonical_old' => null,
		'timetable' => null,
		'hash' => '37b8a7e7a1f2fdebcd5fb5115cb475d5',
		'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' => '763',
		'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-11-30 13:03:10',
		'modified' => '2018-07-10 20:07:53',
		'sms' => null,
		'fulladdress' => ' Calle Calderón de la Barca, Utrera ( 41710 ) , Sevilla',
		'link' => 'https://www.fisiosite.com/pilates/utrera/asd-club-gimnasio-millan',
		'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' => '17',
		'name' => 'PILATES',
		'slug' => 'pilates',
		'description' => '',
		'parent_id' => '1',
		'created' => '2016-06-13 12:15:16',
		'modified' => '2016-06-13 12:15:16',
		'lft' => '32',
		'rght' => '33'
	),
	'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' => '763'
)
$query_establishments = array(
	'Establishment.population_id' => '763'
)
$key = (int) 5
$value = '763'
$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' => '6294',
			'name' => 'Francisco Miguel Cocera Morata - Clínica de Fisioterapia Cocera',
			'category_id' => '14',
			'establishment_type' => '1',
			'image' => null,
			'image_dir' => null,
			'web' => null,
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => '',
			'address1' => 'c/ María Alba, 8',
			'address2' => '',
			'email' => 'clinicacocera@hotmail.com',
			'fax' => null,
			'mobile' => '',
			'mobile2' => null,
			'phone' => '955862399',
			'phone2' => null,
			'zipcode' => '41710',
			'town' => 'Utrera',
			'state' => 'Sevilla',
			'country' => 'España',
			'latitude' => '37.185684',
			'longitude' => '-5.779523',
			'slug' => 'francisco-miguel-cocera-morata-clinica-de-fisioterapia-cocera-c-maria-alba',
			'canonical' => 'osteopatia/utrera/francisco-miguel-cocera-morata-clinica-de-fisioterapia-cocera',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => 'ac6a1bf8e6f67d19096ef487ca5dd5da',
			'hash_old' => null,
			'deleted' => false,
			'deleterequest' => null,
			'user_id' => null,
			'plan_id' => '1',
			'next_plan_id' => null,
			'video' => null,
			'pinterest' => null,
			'googleplus' => null,
			'youtube' => null,
			'linkedin' => null,
			'facebook' => null,
			'twitter' => null,
			'status' => '1',
			'subscription_status' => '0',
			'subscription_id' => '0',
			'population_id' => '763',
			'bank' => null,
			'bank_cert' => null,
			'bank_cert_dir' => null,
			'bank_cert_status' => null,
			'file_dni' => null,
			'file_dni_dir' => null,
			'writers' => null,
			'writers_dir' => null,
			'split_id' => null,
			'created' => '2016-09-21 17:19:42',
			'modified' => '2018-07-10 19:47:29',
			'sms' => null,
			'fulladdress' => 'c/ María Alba, 8, Utrera ( 41710 ) , Sevilla',
			'link' => 'https://www.fisiosite.com/osteopatia/utrera/francisco-miguel-cocera-morata-clinica-de-fisioterapia-cocera',
			'path_cert' => '/var/www/fisiosite.com/webroot//files/establishment/bank_cert//',
			'path_dni' => '/var/www/fisiosite.com/webroot//files/establishment/file_dni//',
			'path_writers' => '/var/www/fisiosite.com/webroot//files/establishment/writers//',
			'rating' => false,
			'is_open' => false
		),
		'Category' => array(
			'id' => '14',
			'name' => 'OSTEOPATIA',
			'slug' => 'osteopatia',
			'description' => '',
			'parent_id' => '1',
			'created' => '2016-06-13 12:15:16',
			'modified' => '2016-06-13 12:15:16',
			'lft' => '26',
			'rght' => '27'
		),
		'EstablishmentsCategory' => array(
			'id' => null,
			'establishment_id' => null,
			'category_id' => null,
			'created' => null,
			'modified' => null
		),
		'Service' => array(),
		'Slide' => array(
			'id' => null,
			'model' => null,
			'foreign_key' => null,
			'name' => null,
			'attachment' => null,
			'dir' => null,
			'type' => null,
			'size' => null,
			'active' => null
		),
		(int) 0 => array(
			'have_date' => '0'
		),
		'Comment' => array(),
		'Staff' => array(),
		'Slots' => array()
	),
	(int) 1 => array(
		'Establishment' => array(
			'id' => '11271',
			'name' => 'Centro Profesional de Recuperacion Funcional SLP ',
			'category_id' => '1',
			'establishment_type' => null,
			'image' => null,
			'image_dir' => null,
			'web' => 'http://www.cprf.es',
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => null,
			'address1' => 'Calle Sevilla',
			'address2' => '56',
			'email' => 'info@cpr.es',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '955 86 26 00',
			'phone2' => '',
			'zipcode' => '41710',
			'town' => 'Utrera',
			'state' => 'Sevilla',
			'country' => 'España',
			'latitude' => '37.183491',
			'longitude' => '-5.783145',
			'slug' => null,
			'canonical' => 'fisioterapia/utrera/centro-profesional-de-recuperacion-funcional-slp',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => '58c80399509b487b6724f414e9a51ce9',
			'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' => '763',
			'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-11-30 12:28:22',
			'modified' => '2018-07-10 20:07:26',
			'sms' => null,
			'fulladdress' => 'Calle Sevilla, Utrera ( 41710 ) , Sevilla',
			'link' => 'https://www.fisiosite.com/fisioterapia/utrera/centro-profesional-de-recuperacion-funcional-slp',
			'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' => '11272',
			'name' => 'FisioPie',
			'category_id' => '1',
			'establishment_type' => null,
			'image' => null,
			'image_dir' => null,
			'web' => 'http://www.fisiopieutrera.com',
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => null,
			'address1' => 'Calle Rubén Darío',
			'address2' => '24',
			'email' => 'info@fisiopieutrera.com',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '955 86 31 70',
			'phone2' => '',
			'zipcode' => '41710',
			'town' => 'Utrera',
			'state' => 'Sevilla',
			'country' => 'España',
			'latitude' => '37.188004',
			'longitude' => '-5.786162',
			'slug' => null,
			'canonical' => 'fisioterapia/utrera/fisiopie',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => 'bcdfeb01f924e68c32bab078d919d64d',
			'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' => '763',
			'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-11-30 12:28:26',
			'modified' => '2018-07-10 20:07:26',
			'sms' => null,
			'fulladdress' => 'Calle Rubén Darío, Utrera ( 41710 ) , Sevilla',
			'link' => 'https://www.fisiosite.com/fisioterapia/utrera/fisiopie',
			'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' => '11373',
			'name' => 'Clínica De Fisioterapia Cocera ',
			'category_id' => '1',
			'establishment_type' => null,
			'image' => null,
			'image_dir' => null,
			'web' => 'http://clinicacocera.blogspot.com.es',
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => null,
			'address1' => 'C/María Alba',
			'address2' => '8',
			'email' => 'clinicacocera@gmail.com',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '955 86 23 99',
			'phone2' => '677493398',
			'zipcode' => '41710',
			'town' => 'Utrera',
			'state' => 'Sevilla',
			'country' => 'España',
			'latitude' => '37.186058',
			'longitude' => '-5.778937',
			'slug' => null,
			'canonical' => 'fisioterapia/utrera/clinica-de-fisioterapia-cocera',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => '22aeff7f9c728017e77778dd9c95b0d8',
			'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' => '763',
			'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-11-30 13:03:06',
			'modified' => '2018-07-10 20:07:53',
			'sms' => null,
			'fulladdress' => 'C/María Alba, Utrera ( 41710 ) , Sevilla',
			'link' => 'https://www.fisiosite.com/fisioterapia/utrera/clinica-de-fisioterapia-cocera',
			'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' => '11374',
			'name' => 'Asd Club Gimnasio Millán ',
			'category_id' => '17',
			'establishment_type' => null,
			'image' => null,
			'image_dir' => null,
			'web' => '',
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => null,
			'address1' => ' Calle Calderón de la Barca',
			'address2' => '9',
			'email' => '',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '954 86 19 37',
			'phone2' => '',
			'zipcode' => '41710',
			'town' => 'Utrera',
			'state' => 'Sevilla',
			'country' => 'España',
			'latitude' => '37.192009',
			'longitude' => '-5.782663',
			'slug' => null,
			'canonical' => 'pilates/utrera/asd-club-gimnasio-millan',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => '37b8a7e7a1f2fdebcd5fb5115cb475d5',
			'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' => '763',
			'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-11-30 13:03:10',
			'modified' => '2018-07-10 20:07:53',
			'sms' => null,
			'fulladdress' => ' Calle Calderón de la Barca, Utrera ( 41710 ) , Sevilla',
			'link' => 'https://www.fisiosite.com/pilates/utrera/asd-club-gimnasio-millan',
			'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' => '17',
			'name' => 'PILATES',
			'slug' => 'pilates',
			'description' => '',
			'parent_id' => '1',
			'created' => '2016-06-13 12:15:16',
			'modified' => '2016-06-13 12:15:16',
			'lft' => '32',
			'rght' => '33'
		),
		'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' => '12589',
			'name' => 'TECUM CENTER',
			'category_id' => '1',
			'establishment_type' => '2',
			'image' => null,
			'image_dir' => null,
			'web' => 'https://fisioterapiaymovimientoalvarogonzalezfajardo.negocio.site/?m=true',
			'short_description' => null,
			'description' => 'Clínica de fisioterapia avanzada en Utrera. Fisioterapeuta profesional, en constante actualización y formación.
Nos basamos en un tratamiento integral del paciente mediante valoración completa inicial, terapia manual, ejercicio y educación para la salud.
Técnicas que ofrecemos: movilizaciones, masaje terapéutico, terapia manual instrumental, electroterapia, inducción miofascial, movimiento funcional, pilates terapéutico, punción seca, vibroterapia, diatermia recuperadora, presoterapia.
Fisioterapia global e integrativa de nuestro sistema neuro-músculo-fascia-esquelético.
Tratamientos de lesiones deportivas, traumatológicas, recuperación en personas mayores, neurológicos, post-ictus, post-cirugía o intervención quirúrgica, rehabilitación.',
			'fiscalnumber' => '47393257D',
			'address1' => 'Avenida María Auxiliadora 94',
			'address2' => 'TECUM CENTER',
			'email' => 'alvarogfisio@gmail.com',
			'fax' => null,
			'mobile' => null,
			'mobile2' => null,
			'phone' => '634598702',
			'phone2' => '634598702',
			'zipcode' => '41710',
			'town' => 'Utrera',
			'state' => 'Sevilla',
			'country' => null,
			'latitude' => null,
			'longitude' => null,
			'slug' => null,
			'canonical' => 'fisioterapia/utrera/tecum-center',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => '904a964f9cbdb61b9105e4f1b9e9790c',
			'hash_old' => null,
			'deleted' => false,
			'deleterequest' => null,
			'user_id' => '60a4cb23-13e4-43fd-8c46-73fc335b89d7',
			'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' => null,
			'subscription_id' => null,
			'population_id' => '763',
			'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' => '2021-05-19 10:30:48',
			'modified' => '2021-05-20 00:42:56',
			'sms' => null,
			'fulladdress' => 'Avenida María Auxiliadora 94, Utrera ( 41710 ) , Sevilla',
			'link' => 'https://www.fisiosite.com/fisioterapia/utrera/tecum-center',
			'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) 6
$e = array(
	'Establishment' => array(
		'id' => '12589',
		'name' => 'TECUM CENTER',
		'category_id' => '1',
		'establishment_type' => '2',
		'image' => null,
		'image_dir' => null,
		'web' => 'https://fisioterapiaymovimientoalvarogonzalezfajardo.negocio.site/?m=true',
		'short_description' => null,
		'description' => 'Clínica de fisioterapia avanzada en Utrera. Fisioterapeuta profesional, en constante actualización y formación.
Nos basamos en un tratamiento integral del paciente mediante valoración completa inicial, terapia manual, ejercicio y educación para la salud.
Técnicas que ofrecemos: movilizaciones, masaje terapéutico, terapia manual instrumental, electroterapia, inducción miofascial, movimiento funcional, pilates terapéutico, punción seca, vibroterapia, diatermia recuperadora, presoterapia.
Fisioterapia global e integrativa de nuestro sistema neuro-músculo-fascia-esquelético.
Tratamientos de lesiones deportivas, traumatológicas, recuperación en personas mayores, neurológicos, post-ictus, post-cirugía o intervención quirúrgica, rehabilitación.',
		'fiscalnumber' => '47393257D',
		'address1' => 'Avenida María Auxiliadora 94',
		'address2' => 'TECUM CENTER',
		'email' => 'alvarogfisio@gmail.com',
		'fax' => null,
		'mobile' => null,
		'mobile2' => null,
		'phone' => '634598702',
		'phone2' => '634598702',
		'zipcode' => '41710',
		'town' => 'Utrera',
		'state' => 'Sevilla',
		'country' => null,
		'latitude' => null,
		'longitude' => null,
		'slug' => null,
		'canonical' => 'fisioterapia/utrera/tecum-center',
		'canonical_old' => null,
		'timetable' => null,
		'hash' => '904a964f9cbdb61b9105e4f1b9e9790c',
		'hash_old' => null,
		'deleted' => false,
		'deleterequest' => null,
		'user_id' => '60a4cb23-13e4-43fd-8c46-73fc335b89d7',
		'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' => null,
		'subscription_id' => null,
		'population_id' => '763',
		'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' => '2021-05-19 10:30:48',
		'modified' => '2021-05-20 00:42:56',
		'sms' => null,
		'fulladdress' => 'Avenida María Auxiliadora 94, Utrera ( 41710 ) , Sevilla',
		'link' => 'https://www.fisiosite.com/fisioterapia/utrera/tecum-center',
		'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' => '1625423331',
	'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) 1623653331,
	'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 Utrera

Aquí te mostramos las 6 clínicas encontradas de fisioterapia en Utrera

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

Francisco miguel cocera morata - clínica de fisioterapia cocera c/ María Alba, 8, Utrera ( 41710 ) , Sevilla
Osteopatia

Sin valoraciones
(0) Comentarios

2

Centro profesional de recuperacion funcional slp  Calle Sevilla, Utrera ( 41710 ) , Sevilla
Fisioterapia

Sin valoraciones
(0) Comentarios

3

Fisiopie Calle Rubén Darío, Utrera ( 41710 ) , Sevilla
Fisioterapia

Sin valoraciones
(0) Comentarios

4

Clínica de fisioterapia cocera  C/María Alba, Utrera ( 41710 ) , Sevilla
Fisioterapia

Sin valoraciones
(0) Comentarios

5

Asd club gimnasio millán   Calle Calderón de la Barca, Utrera ( 41710 ) , Sevilla
Pilates

Sin valoraciones
(0) Comentarios

6

Tecum center Avenida María Auxiliadora 94, Utrera ( 41710 ) , Sevilla
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