Notice (8): Undefined variable: proyFin [APP/Controller/ObrasController.php, line 100]



         $this->set('proyFin', $proyFin);

$year = '2014'
$obras = array(
	(int) 0 => array(
		'Obra' => array(
			'id' => '6',
			'title' => 'Cambio de ubicación de dos farolas en la calle Valle de Oza',
			'subtitle' => 'Valle de Oza',
			'distrito' => 'arrabal',
			'cliente' => 'Cerma & Arriaxa',
			'body' => '<p>Las obras empezas faj &ntilde;&acute;lkjfaskdlfj as&ntilde;dklj&ntilde;lkj</p>
',
			'body_data' => '<p>Las obras empezas faj &ntilde;&acute;lkjfaskdlfj as&ntilde;dklj&ntilde;lkj</p>
',
			'body_html_clean' => '<p>Las obras empezas faj &ntilde;&acute;lkjfaskdlfj as&ntilde;dklj&ntilde;lkj</p>
',
			'user_id' => '1',
			'url_slug' => 'cambio-de-ubicacion-de-dos-farolas-en-la-calle-valle-de-oza',
			'afecciones' => '',
			'motivo_obra' => '',
			'activo' => true,
			'fecha' => '2014-12-22 00:00:00',
			'fecha_fin' => '2014-12-23 00:00:00',
			'estado_obra' => '0',
			'latitud' => '41.643671',
			'longitud' => '-0.886034',
			'localizacion_obra' => 'paseo sagasta, zaragoza',
			'tags' => '',
			'created' => '2017-06-12 19:52:03',
			'modified' => '2017-08-03 09:23:12'
		)
	)
)
$TotalCuantos = (int) 0
$current_year = '2025'
$i = (int) 2025
$cuantos = (int) 0

ObrasController::index() - APP/Controller/ObrasController.php, line 100
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 490
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 185
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 160
[main] - APP/webroot/index.php, line 98

Obras realizadas durante el año 2014

Proyectos ejecutados recientemente

Diciembre de 2014
Cambio de ubicación de dos farolas en la calle Valle de Oza

Ver ficha

Obras finalizadas

Histórico de nuestro trabajo

(default) 13 queries took 11 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	SELECT `Obra`.`id`, `Obra`.`title`, `Obra`.`subtitle`, `Obra`.`distrito`, `Obra`.`cliente`, `Obra`.`body`, `Obra`.`body_data`, `Obra`.`body_html_clean`, `Obra`.`user_id`, `Obra`.`url_slug`, `Obra`.`afecciones`, `Obra`.`motivo_obra`, `Obra`.`activo`, `Obra`.`fecha`, `Obra`.`fecha_fin`, `Obra`.`estado_obra`, `Obra`.`latitud`, `Obra`.`longitud`, `Obra`.`localizacion_obra`, `Obra`.`tags`, `Obra`.`created`, `Obra`.`modified` FROM `inviasa_inv`.`obras` AS `Obra` WHERE `Obra`.`activo` = '1' AND ((`Obra`.`estado_obra` = '0') OR (`Obra`.`estado_obra` = '2') OR (`Obra`.`estado_obra` = '1') OR (`Obra`.`estado_obra` = '3')) AND `Obra`.`fecha_fin` >= '2014-01-01 00:00:00' AND `Obra`.`fecha_fin` <= '2014-12-31 00:00:00' ORDER BY `Obra`.`fecha_fin` DESC LIMIT 100	1	1	3
2	SELECT COUNT(*) AS `count` FROM `inviasa_inv`.`obras` AS `Obra` WHERE `Obra`.`activo` = '1' AND ((`Obra`.`estado_obra` = '0') OR (`Obra`.`estado_obra` = '2') OR (`Obra`.`estado_obra` = '1') OR (`Obra`.`estado_obra` = '3')) AND `Obra`.`fecha_fin` >= '2014-01-01 00:00:00' AND `Obra`.`fecha_fin` <= '2014-12-31 00:00:00'	1	1	2
3	SELECT COUNT(*) AS `count` FROM `inviasa_inv`.`obras` AS `Obra` LEFT JOIN `inviasa_inv`.`users` AS `User` ON (`Obra`.`user_id` = `User`.`id`) WHERE `estado_obra` = '0' AND `fecha_fin` >= '2018-01-01 00:00:00' AND `fecha_fin` <= '2018-12-31 00:00:00'	1	1	1
4	SELECT COUNT(*) AS `count` FROM `inviasa_inv`.`obras` AS `Obra` LEFT JOIN `inviasa_inv`.`users` AS `User` ON (`Obra`.`user_id` = `User`.`id`) WHERE `estado_obra` = '0' AND `fecha_fin` >= '2019-01-01 00:00:00' AND `fecha_fin` <= '2019-12-31 00:00:00'	1	1	1
5	SELECT COUNT(*) AS `count` FROM `inviasa_inv`.`obras` AS `Obra` LEFT JOIN `inviasa_inv`.`users` AS `User` ON (`Obra`.`user_id` = `User`.`id`) WHERE `estado_obra` = '0' AND `fecha_fin` >= '2020-01-01 00:00:00' AND `fecha_fin` <= '2020-12-31 00:00:00'	1	1	0
6	SELECT COUNT(*) AS `count` FROM `inviasa_inv`.`obras` AS `Obra` LEFT JOIN `inviasa_inv`.`users` AS `User` ON (`Obra`.`user_id` = `User`.`id`) WHERE `estado_obra` = '0' AND `fecha_fin` >= '2021-01-01 00:00:00' AND `fecha_fin` <= '2021-12-31 00:00:00'	1	1	1
7	SELECT COUNT(*) AS `count` FROM `inviasa_inv`.`obras` AS `Obra` LEFT JOIN `inviasa_inv`.`users` AS `User` ON (`Obra`.`user_id` = `User`.`id`) WHERE `estado_obra` = '0' AND `fecha_fin` >= '2022-01-01 00:00:00' AND `fecha_fin` <= '2022-12-31 00:00:00'	1	1	1
8	SELECT COUNT(*) AS `count` FROM `inviasa_inv`.`obras` AS `Obra` LEFT JOIN `inviasa_inv`.`users` AS `User` ON (`Obra`.`user_id` = `User`.`id`) WHERE `estado_obra` = '0' AND `fecha_fin` >= '2023-01-01 00:00:00' AND `fecha_fin` <= '2023-12-31 00:00:00'	1	1	1
9	SELECT COUNT(*) AS `count` FROM `inviasa_inv`.`obras` AS `Obra` LEFT JOIN `inviasa_inv`.`users` AS `User` ON (`Obra`.`user_id` = `User`.`id`) WHERE `estado_obra` = '0' AND `fecha_fin` >= '2024-01-01 00:00:00' AND `fecha_fin` <= '2024-12-31 00:00:00'	1	1	1
10	SELECT `SeoTitle`.`title`, `SeoUri`.`uri`, `SeoUri`.`id` FROM `inviasa_inv`.`seo_titles` AS `SeoTitle` LEFT JOIN `inviasa_inv`.`seo_uris` AS `SeoUri` ON (`SeoTitle`.`seo_uri_id` = `SeoUri`.`id`) WHERE `SeoUri`.`uri` = '/obras-finalizadas/2014' AND `SeoUri`.`is_approved` = '1' LIMIT 1	0	0	0
11	SELECT `SeoMetaTag`.`id`, `SeoMetaTag`.`seo_uri_id`, `SeoMetaTag`.`name`, `SeoMetaTag`.`content`, `SeoMetaTag`.`is_http_equiv`, `SeoMetaTag`.`created`, `SeoMetaTag`.`modified`, `SeoUri`.`uri` FROM `inviasa_inv`.`seo_meta_tags` AS `SeoMetaTag` LEFT JOIN `inviasa_inv`.`seo_uris` AS `SeoUri` ON (`SeoMetaTag`.`seo_uri_id` = `SeoUri`.`id`) WHERE `SeoUri`.`uri` = '/obras-finalizadas/2014' AND `SeoUri`.`is_approved` = '1'	0	0	0
12	SELECT `SeoUri`.`id`, `SeoUri`.`uri` FROM `inviasa_inv`.`seo_uris` AS `SeoUri` WHERE ((`SeoUri`.`uri` LIKE '#%') OR (`SeoUri`.`uri` LIKE '%*')) AND `SeoUri`.`is_approved` = '1'	0	0	0
13	SELECT `SeoCanonical`.`canonical` FROM `inviasa_inv`.`seo_canonicals` AS `SeoCanonical` LEFT JOIN `inviasa_inv`.`seo_uris` AS `SeoUri` ON (`SeoCanonical`.`seo_uri_id` = `SeoUri`.`id`) WHERE `SeoUri`.`uri` = '/obras-finalizadas/2014' AND `SeoUri`.`is_approved` = '1' AND `SeoCanonical`.`is_active` = '1' LIMIT 1	0	0	0

(default) 13 queries took 11 ms

Query

Error

Affected

Num. rows

Took (ms)

SELECT `Obra`.`id`, `Obra`.`title`, `Obra`.`subtitle`, `Obra`.`distrito`, `Obra`.`cliente`, `Obra`.`body`, `Obra`.`body_data`, `Obra`.`body_html_clean`, `Obra`.`user_id`, `Obra`.`url_slug`, `Obra`.`afecciones`, `Obra`.`motivo_obra`, `Obra`.`activo`, `Obra`.`fecha`, `Obra`.`fecha_fin`, `Obra`.`estado_obra`, `Obra`.`latitud`, `Obra`.`longitud`, `Obra`.`localizacion_obra`, `Obra`.`tags`, `Obra`.`created`, `Obra`.`modified` FROM `inviasa_inv`.`obras` AS `Obra` WHERE `Obra`.`activo` = '1' AND ((`Obra`.`estado_obra` = '0') OR (`Obra`.`estado_obra` = '2') OR (`Obra`.`estado_obra` = '1') OR (`Obra`.`estado_obra` = '3')) AND `Obra`.`fecha_fin` >= '2014-01-01 00:00:00' AND `Obra`.`fecha_fin` <= '2014-12-31 00:00:00' ORDER BY `Obra`.`fecha_fin` DESC LIMIT 100

SELECT COUNT(*) AS `count` FROM `inviasa_inv`.`obras` AS `Obra` WHERE `Obra`.`activo` = '1' AND ((`Obra`.`estado_obra` = '0') OR (`Obra`.`estado_obra` = '2') OR (`Obra`.`estado_obra` = '1') OR (`Obra`.`estado_obra` = '3')) AND `Obra`.`fecha_fin` >= '2014-01-01 00:00:00' AND `Obra`.`fecha_fin` <= '2014-12-31 00:00:00'

SELECT COUNT(*) AS `count` FROM `inviasa_inv`.`obras` AS `Obra` LEFT JOIN `inviasa_inv`.`users` AS `User` ON (`Obra`.`user_id` = `User`.`id`) WHERE `estado_obra` = '0' AND `fecha_fin` >= '2018-01-01 00:00:00' AND `fecha_fin` <= '2018-12-31 00:00:00'

SELECT COUNT(*) AS `count` FROM `inviasa_inv`.`obras` AS `Obra` LEFT JOIN `inviasa_inv`.`users` AS `User` ON (`Obra`.`user_id` = `User`.`id`) WHERE `estado_obra` = '0' AND `fecha_fin` >= '2019-01-01 00:00:00' AND `fecha_fin` <= '2019-12-31 00:00:00'

SELECT COUNT(*) AS `count` FROM `inviasa_inv`.`obras` AS `Obra` LEFT JOIN `inviasa_inv`.`users` AS `User` ON (`Obra`.`user_id` = `User`.`id`) WHERE `estado_obra` = '0' AND `fecha_fin` >= '2020-01-01 00:00:00' AND `fecha_fin` <= '2020-12-31 00:00:00'

SELECT COUNT(*) AS `count` FROM `inviasa_inv`.`obras` AS `Obra` LEFT JOIN `inviasa_inv`.`users` AS `User` ON (`Obra`.`user_id` = `User`.`id`) WHERE `estado_obra` = '0' AND `fecha_fin` >= '2021-01-01 00:00:00' AND `fecha_fin` <= '2021-12-31 00:00:00'

SELECT COUNT(*) AS `count` FROM `inviasa_inv`.`obras` AS `Obra` LEFT JOIN `inviasa_inv`.`users` AS `User` ON (`Obra`.`user_id` = `User`.`id`) WHERE `estado_obra` = '0' AND `fecha_fin` >= '2022-01-01 00:00:00' AND `fecha_fin` <= '2022-12-31 00:00:00'

SELECT COUNT(*) AS `count` FROM `inviasa_inv`.`obras` AS `Obra` LEFT JOIN `inviasa_inv`.`users` AS `User` ON (`Obra`.`user_id` = `User`.`id`) WHERE `estado_obra` = '0' AND `fecha_fin` >= '2023-01-01 00:00:00' AND `fecha_fin` <= '2023-12-31 00:00:00'

SELECT COUNT(*) AS `count` FROM `inviasa_inv`.`obras` AS `Obra` LEFT JOIN `inviasa_inv`.`users` AS `User` ON (`Obra`.`user_id` = `User`.`id`) WHERE `estado_obra` = '0' AND `fecha_fin` >= '2024-01-01 00:00:00' AND `fecha_fin` <= '2024-12-31 00:00:00'

SELECT `SeoTitle`.`title`, `SeoUri`.`uri`, `SeoUri`.`id` FROM `inviasa_inv`.`seo_titles` AS `SeoTitle` LEFT JOIN `inviasa_inv`.`seo_uris` AS `SeoUri` ON (`SeoTitle`.`seo_uri_id` = `SeoUri`.`id`) WHERE `SeoUri`.`uri` = '/obras-finalizadas/2014' AND `SeoUri`.`is_approved` = '1' LIMIT 1

SELECT `SeoMetaTag`.`id`, `SeoMetaTag`.`seo_uri_id`, `SeoMetaTag`.`name`, `SeoMetaTag`.`content`, `SeoMetaTag`.`is_http_equiv`, `SeoMetaTag`.`created`, `SeoMetaTag`.`modified`, `SeoUri`.`uri` FROM `inviasa_inv`.`seo_meta_tags` AS `SeoMetaTag` LEFT JOIN `inviasa_inv`.`seo_uris` AS `SeoUri` ON (`SeoMetaTag`.`seo_uri_id` = `SeoUri`.`id`) WHERE `SeoUri`.`uri` = '/obras-finalizadas/2014' AND `SeoUri`.`is_approved` = '1'

SELECT `SeoUri`.`id`, `SeoUri`.`uri` FROM `inviasa_inv`.`seo_uris` AS `SeoUri` WHERE ((`SeoUri`.`uri` LIKE '#%') OR (`SeoUri`.`uri` LIKE '%*')) AND `SeoUri`.`is_approved` = '1'

SELECT `SeoCanonical`.`canonical` FROM `inviasa_inv`.`seo_canonicals` AS `SeoCanonical` LEFT JOIN `inviasa_inv`.`seo_uris` AS `SeoUri` ON (`SeoCanonical`.`seo_uri_id` = `SeoUri`.`id`) WHERE `SeoUri`.`uri` = '/obras-finalizadas/2014' AND `SeoUri`.`is_approved` = '1' AND `SeoCanonical`.`is_active` = '1' LIMIT 1