2016-02-09 08:24:20TraerCaso(108,81,)
 CargarCaso :108
2016-02 09 08:24:20  
CargarDatos: Caso :108
	cargar datos de ejecucion de los ultimos pasos 
		select p.*,b.wf_tarea_id as tarea_id,
				u.apellido||' '||u.nombre|| ': '||u.cargo as usr_ejec
				from
				(select max(id) as id, wf_caso_81_seguimiento_id,wf_paso_id from wf_caso_81_pasos a1  group by wf_caso_81_seguimiento_id,wf_paso_id order by id
				)a
				inner join wf_caso_81_pasos p using(id,wf_caso_81_seguimiento_id)
				inner join ( select max(id) as wf_caso_81_seguimiento_id,wf_caso_81_id,wf_tarea_id from wf_caso_81_seguimiento where wf_caso_81_id =? group by wf_caso_81_id,wf_tarea_id order by wf_caso_81_id,wf_caso_81_seguimiento_id  ) b using(wf_caso_81_seguimiento_id)
				left join  usuarios  u using(core_usuario_id) 
			{"0":"688","id":"688","1":"173","wf_paso_id":"173","2":"360","wf_caso_81_seguimiento_id":"360","3":"32","core_usuario_id":"32","4":"2015-04-16 09:54:07","fecha_ejec":"2015-04-16 09:54:07","5":"103","dato":"103","6":"sce.t22","tabla":"sce.t22","7":"78","tarea_id":"78","8":"Martinez Jose: ciudadano","usr_ejec":"Martinez Jose: ciudadano"}
				CargarDatos_173(103)
							se carga 81_78_173_22_23_3302
			{"0":"689","id":"689","1":"175","wf_paso_id":"175","2":"361","wf_caso_81_seguimiento_id":"361","3":"32","core_usuario_id":"32","4":"2015-04-16 09:54:53","fecha_ejec":"2015-04-16 09:54:53","5":"23","dato":"23","6":"sce.t25","tabla":"sce.t25","7":"80","tarea_id":"80","8":"Martinez Jose: ciudadano","usr_ejec":"Martinez Jose: ciudadano"}
				CargarDatos_175(23)
							se carga 81_80_175_25_26_407
							se carga 81_80_175_25_26_397dfsdfsfdsfdds
							se carga 81_80_175_25_26_3962015-04-25
							se carga 81_80_175_25_26_3952015-04-16
							se carga 81_80_175_25_26_394
							se carga 81_80_175_25_26_3931
							se carga 81_80_175_25_26_3924
							se carga 81_80_175_25_26_3914
							se carga 81_80_175_25_26_3901
							se carga 81_80_175_25_26_389
							se carga 81_80_175_25_26_388
							se carga 81_80_175_25_26_387cvxvcxvcx
							se carga 81_80_175_25_26_3861
							se carga 81_80_175_25_26_3852
							se carga 81_80_175_25_26_3841
							se carga 81_80_175_25_26_383
							se carga 81_80_175_25_26_382xcvxc
							se carga 81_80_175_25_26_381
							se carga 81_80_175_25_26_380asdfs@sda.com
							se carga 81_80_175_25_26_379342
							se carga 81_80_175_25_26_378342
							se carga 81_80_175_25_26_3771
							se carga 81_80_175_25_26_376cxv
							se carga 81_80_175_25_26_375cvxxcv
							se carga 81_80_175_25_26_374xcvcx
							se carga 81_80_175_25_26_373
							se carga 81_80_175_25_26_372xcvv
							se carga 81_80_175_25_26_371
							se carga 81_80_175_25_26_370asdfs@sda.com
							se carga 81_80_175_25_26_3694324
							se carga 81_80_175_25_26_36823432
							se carga 81_80_175_25_26_3671
							se carga 81_80_175_25_26_366czxz
							se carga 81_80_175_25_26_365zcxzcxzcx
							se carga 81_80_175_25_26_364cxzzxczcx
							se carga 81_80_175_25_26_363
							se carga 81_80_175_25_26_362zxccxz
							se carga 81_80_175_25_26_361
							se carga 81_80_175_25_26_360asdfs@sda.com
							se carga 81_80_175_25_26_359432
							se carga 81_80_175_25_26_358324243
							se carga 81_80_175_25_26_3571
							se carga 81_80_175_25_26_3561
							se carga 81_80_175_25_26_355
							se carga 81_80_175_25_26_354sdafsadfsad
							se carga 81_80_175_25_26_353sfdasf
							se carga 81_80_175_25_26_352
							se carga 81_80_175_25_26_3512015-04-16
			{"0":"690","id":"690","1":"239","wf_paso_id":"239","2":"361","wf_caso_81_seguimiento_id":"361","3":"32","core_usuario_id":"32","4":"2015-04-16 09:55:09","fecha_ejec":"2015-04-16 09:55:09","5":"5060","dato":"5060","6":"wf_documentoentradaadj_caso","tabla":"wf_documentoentradaadj_caso","7":"80","tarea_id":"80","8":"Martinez Jose: ciudadano","usr_ejec":"Martinez Jose: ciudadano"}
				CargarDatos_239(5060)
			{"0":"691","id":"691","1":"245","wf_paso_id":"245","2":"361","wf_caso_81_seguimiento_id":"361","3":"32","core_usuario_id":"32","4":"2015-04-16 09:55:10","fecha_ejec":"2015-04-16 09:55:10","5":null,"dato":null,"6":null,"tabla":null,"7":"80","tarea_id":"80","8":"Martinez Jose: ciudadano","usr_ejec":"Martinez Jose: ciudadano"}
				CargarDatos_245()
			{"0":"692","id":"692","1":"242","wf_paso_id":"242","2":"362","wf_caso_81_seguimiento_id":"362","3":"27","core_usuario_id":"27","4":"2015-04-16 09:55:23","fecha_ejec":"2015-04-16 09:55:23","5":"2162","dato":"2162","6":"wf_documentoentradaadj_caso","tabla":"wf_documentoentradaadj_caso","7":"134","tarea_id":"134","8":"ORTIZ JOHN: gerente, ciudadano","usr_ejec":"ORTIZ JOHN: gerente, ciudadano"}
				CargarDatos_242(2162)
			{"0":"698","id":"698","1":"256","wf_paso_id":"256","2":"363","wf_caso_81_seguimiento_id":"363","3":"27","core_usuario_id":"27","4":"2015-04-16 09:55:40","fecha_ejec":"2015-04-16 09:55:40","5":null,"dato":null,"6":null,"tabla":null,"7":"138","tarea_id":"138","8":"ORTIZ JOHN: gerente, ciudadano","usr_ejec":"ORTIZ JOHN: gerente, ciudadano"}
				CargarDatos_256()
	cargar datos de ejecucion de las tareas (las ultimas si el proceso tiene ciclos) 
		select a.*, u.apellido||' '||u.nombre|| ': '||u.cargo as usr_asig  , ur.apellido||' '||ur.nombre|| ': '||ur.cargo as usr_resol from
				wf_caso_81_seguimiento a
				inner join (
				select max(b0.id) as id,b0.wf_caso_81_id,b0.wf_tarea_id from wf_caso_81_seguimiento b0  where b0.wf_caso_81_id =? group by b0.wf_caso_81_id,b0.wf_tarea_id order by wf_caso_81_id,id
				) b using(id)
				left join  usuarios  u using(core_usuario_id)
				left join  usuarios  ur on ur.core_usuario_id=core_usuario_id_resol
			{"0":"360","id":"360","1":"108","wf_caso_81_id":"108","2":"78","wf_tarea_id":"78","3":null,"core_usuario_id":null,"4":"2015-04-16 09:54:05","fec_asig":"2015-04-16 09:54:05","5":"32","core_usuario_id_resol":"32","6":"2015-04-16 09:54:07","fec_resol":"2015-04-16 09:54:07","7":"78","wf_tarea_id_sig":"78","8":null,"usr_asig":null,"9":"Martinez Jose: ciudadano","usr_resol":"Martinez Jose: ciudadano"}
			{"0":"361","id":"361","1":"108","wf_caso_81_id":"108","2":"80","wf_tarea_id":"80","3":"32","core_usuario_id":"32","4":"2015-04-16 09:54:07","fec_asig":"2015-04-16 09:54:07","5":"32","core_usuario_id_resol":"32","6":"2015-04-16 09:55:10","fec_resol":"2015-04-16 09:55:10","7":"80","wf_tarea_id_sig":"80","8":"Martinez Jose: ciudadano","usr_asig":"Martinez Jose: ciudadano","9":"Martinez Jose: ciudadano","usr_resol":"Martinez Jose: ciudadano"}
			{"0":"362","id":"362","1":"108","wf_caso_81_id":"108","2":"134","wf_tarea_id":"134","3":null,"core_usuario_id":null,"4":"2015-04-16 09:55:10","fec_asig":"2015-04-16 09:55:10","5":"27","core_usuario_id_resol":"27","6":"2015-04-16 09:55:23","fec_resol":"2015-04-16 09:55:23","7":"134","wf_tarea_id_sig":"134","8":null,"usr_asig":null,"9":"ORTIZ JOHN: gerente, ciudadano","usr_resol":"ORTIZ JOHN: gerente, ciudadano"}
			{"0":"363","id":"363","1":"108","wf_caso_81_id":"108","2":"138","wf_tarea_id":"138","3":"27","core_usuario_id":"27","4":"2015-04-16 09:55:23","fec_asig":"2015-04-16 09:55:23","5":null,"core_usuario_id_resol":null,"6":null,"fec_resol":null,"7":"138","wf_tarea_id_sig":"138","8":"ORTIZ JOHN: gerente, ciudadano","usr_asig":"ORTIZ JOHN: gerente, ciudadano","9":null,"usr_resol":null}
2016-02 09 08:24:20  
cargar datos del sujeto(,,s,81,108)
	
				select  s.*, m.nombre as nom_muni, c.nom_cat,fec_caso
				from  wf_caso_81 w
				inner join core_sujetoverificacion  s on w.id=108 AND s.id =w.core_sujetoverificacion_id
				inner join plan_municipio m on s.plan_municipio_id=m.id
				inner join core_sujetocategoria c on s.core_sujetocategoria_id=c.id
				
2016-02 09 08:24:20  
tabla dat adic
	select tabla from core_sujetoverificaciontipo where id=1
2016-02 09 08:24:20  
tabla :persona
	SELECT * FROM persona where id=62
					ob_start();
					$ciud =  mb_strtoupper( "{ WFSV_2 } { WFSV_3 }",'utf-8');
					?>
					<p>
					Apreciado(a)<br>
					<strong><?php echo htmlentities($ciud) ?></strong>
					<p>
					<p>El presente mensaje es una notificaci&oacute;n para el caso No  <strong><?php echo 108; ?></strong> </p>
					<?php  $html=ob_get_clean();  
					TWFSV_3:Martinez
					TWFSV_2:Jose
					Su solicitud de<b>&nbsp;Permiso para publicidad exterior visual </b>&nbsp;para vallas o murales artísticos fue revisada y radicada con éxito.
					{ WFSV_1 } 
					TWFSV_1:jlmd0222@hotmail.com
					revisión-radicación vallas-murallas
 fin 2016-02-09  08:24:20
/******************************************************************************************************/

2016-02-09 08:24:21TraerCaso(108,81,)
 CargarCaso :108
2016-02 09 08:24:21  
CargarDatos: Caso :108
	cargar datos de ejecucion de los ultimos pasos 
		select p.*,b.wf_tarea_id as tarea_id,
				u.apellido||' '||u.nombre|| ': '||u.cargo as usr_ejec
				from
				(select max(id) as id, wf_caso_81_seguimiento_id,wf_paso_id from wf_caso_81_pasos a1  group by wf_caso_81_seguimiento_id,wf_paso_id order by id
				)a
				inner join wf_caso_81_pasos p using(id,wf_caso_81_seguimiento_id)
				inner join ( select max(id) as wf_caso_81_seguimiento_id,wf_caso_81_id,wf_tarea_id from wf_caso_81_seguimiento where wf_caso_81_id =? group by wf_caso_81_id,wf_tarea_id order by wf_caso_81_id,wf_caso_81_seguimiento_id  ) b using(wf_caso_81_seguimiento_id)
				left join  usuarios  u using(core_usuario_id) 
			{"0":"688","id":"688","1":"173","wf_paso_id":"173","2":"360","wf_caso_81_seguimiento_id":"360","3":"32","core_usuario_id":"32","4":"2015-04-16 09:54:07","fecha_ejec":"2015-04-16 09:54:07","5":"103","dato":"103","6":"sce.t22","tabla":"sce.t22","7":"78","tarea_id":"78","8":"Martinez Jose: ciudadano","usr_ejec":"Martinez Jose: ciudadano"}
				CargarDatos_173(103)
							se carga 81_78_173_22_23_3302
			{"0":"689","id":"689","1":"175","wf_paso_id":"175","2":"361","wf_caso_81_seguimiento_id":"361","3":"32","core_usuario_id":"32","4":"2015-04-16 09:54:53","fecha_ejec":"2015-04-16 09:54:53","5":"23","dato":"23","6":"sce.t25","tabla":"sce.t25","7":"80","tarea_id":"80","8":"Martinez Jose: ciudadano","usr_ejec":"Martinez Jose: ciudadano"}
				CargarDatos_175(23)
							se carga 81_80_175_25_26_407
							se carga 81_80_175_25_26_397dfsdfsfdsfdds
							se carga 81_80_175_25_26_3962015-04-25
							se carga 81_80_175_25_26_3952015-04-16
							se carga 81_80_175_25_26_394
							se carga 81_80_175_25_26_3931
							se carga 81_80_175_25_26_3924
							se carga 81_80_175_25_26_3914
							se carga 81_80_175_25_26_3901
							se carga 81_80_175_25_26_389
							se carga 81_80_175_25_26_388
							se carga 81_80_175_25_26_387cvxvcxvcx
							se carga 81_80_175_25_26_3861
							se carga 81_80_175_25_26_3852
							se carga 81_80_175_25_26_3841
							se carga 81_80_175_25_26_383
							se carga 81_80_175_25_26_382xcvxc
							se carga 81_80_175_25_26_381
							se carga 81_80_175_25_26_380asdfs@sda.com
							se carga 81_80_175_25_26_379342
							se carga 81_80_175_25_26_378342
							se carga 81_80_175_25_26_3771
							se carga 81_80_175_25_26_376cxv
							se carga 81_80_175_25_26_375cvxxcv
							se carga 81_80_175_25_26_374xcvcx
							se carga 81_80_175_25_26_373
							se carga 81_80_175_25_26_372xcvv
							se carga 81_80_175_25_26_371
							se carga 81_80_175_25_26_370asdfs@sda.com
							se carga 81_80_175_25_26_3694324
							se carga 81_80_175_25_26_36823432
							se carga 81_80_175_25_26_3671
							se carga 81_80_175_25_26_366czxz
							se carga 81_80_175_25_26_365zcxzcxzcx
							se carga 81_80_175_25_26_364cxzzxczcx
							se carga 81_80_175_25_26_363
							se carga 81_80_175_25_26_362zxccxz
							se carga 81_80_175_25_26_361
							se carga 81_80_175_25_26_360asdfs@sda.com
							se carga 81_80_175_25_26_359432
							se carga 81_80_175_25_26_358324243
							se carga 81_80_175_25_26_3571
							se carga 81_80_175_25_26_3561
							se carga 81_80_175_25_26_355
							se carga 81_80_175_25_26_354sdafsadfsad
							se carga 81_80_175_25_26_353sfdasf
							se carga 81_80_175_25_26_352
							se carga 81_80_175_25_26_3512015-04-16
			{"0":"690","id":"690","1":"239","wf_paso_id":"239","2":"361","wf_caso_81_seguimiento_id":"361","3":"32","core_usuario_id":"32","4":"2015-04-16 09:55:09","fecha_ejec":"2015-04-16 09:55:09","5":"5060","dato":"5060","6":"wf_documentoentradaadj_caso","tabla":"wf_documentoentradaadj_caso","7":"80","tarea_id":"80","8":"Martinez Jose: ciudadano","usr_ejec":"Martinez Jose: ciudadano"}
				CargarDatos_239(5060)
			{"0":"691","id":"691","1":"245","wf_paso_id":"245","2":"361","wf_caso_81_seguimiento_id":"361","3":"32","core_usuario_id":"32","4":"2015-04-16 09:55:10","fecha_ejec":"2015-04-16 09:55:10","5":null,"dato":null,"6":null,"tabla":null,"7":"80","tarea_id":"80","8":"Martinez Jose: ciudadano","usr_ejec":"Martinez Jose: ciudadano"}
				CargarDatos_245()
			{"0":"692","id":"692","1":"242","wf_paso_id":"242","2":"362","wf_caso_81_seguimiento_id":"362","3":"27","core_usuario_id":"27","4":"2015-04-16 09:55:23","fecha_ejec":"2015-04-16 09:55:23","5":"2162","dato":"2162","6":"wf_documentoentradaadj_caso","tabla":"wf_documentoentradaadj_caso","7":"134","tarea_id":"134","8":"ORTIZ JOHN: gerente, ciudadano","usr_ejec":"ORTIZ JOHN: gerente, ciudadano"}
				CargarDatos_242(2162)
			{"0":"698","id":"698","1":"256","wf_paso_id":"256","2":"363","wf_caso_81_seguimiento_id":"363","3":"27","core_usuario_id":"27","4":"2015-04-16 09:55:40","fecha_ejec":"2015-04-16 09:55:40","5":null,"dato":null,"6":null,"tabla":null,"7":"138","tarea_id":"138","8":"ORTIZ JOHN: gerente, ciudadano","usr_ejec":"ORTIZ JOHN: gerente, ciudadano"}
				CargarDatos_256()
	cargar datos de ejecucion de las tareas (las ultimas si el proceso tiene ciclos) 
		select a.*, u.apellido||' '||u.nombre|| ': '||u.cargo as usr_asig  , ur.apellido||' '||ur.nombre|| ': '||ur.cargo as usr_resol from
				wf_caso_81_seguimiento a
				inner join (
				select max(b0.id) as id,b0.wf_caso_81_id,b0.wf_tarea_id from wf_caso_81_seguimiento b0  where b0.wf_caso_81_id =? group by b0.wf_caso_81_id,b0.wf_tarea_id order by wf_caso_81_id,id
				) b using(id)
				left join  usuarios  u using(core_usuario_id)
				left join  usuarios  ur on ur.core_usuario_id=core_usuario_id_resol
			{"0":"360","id":"360","1":"108","wf_caso_81_id":"108","2":"78","wf_tarea_id":"78","3":null,"core_usuario_id":null,"4":"2015-04-16 09:54:05","fec_asig":"2015-04-16 09:54:05","5":"32","core_usuario_id_resol":"32","6":"2015-04-16 09:54:07","fec_resol":"2015-04-16 09:54:07","7":"78","wf_tarea_id_sig":"78","8":null,"usr_asig":null,"9":"Martinez Jose: ciudadano","usr_resol":"Martinez Jose: ciudadano"}
			{"0":"361","id":"361","1":"108","wf_caso_81_id":"108","2":"80","wf_tarea_id":"80","3":"32","core_usuario_id":"32","4":"2015-04-16 09:54:07","fec_asig":"2015-04-16 09:54:07","5":"32","core_usuario_id_resol":"32","6":"2015-04-16 09:55:10","fec_resol":"2015-04-16 09:55:10","7":"80","wf_tarea_id_sig":"80","8":"Martinez Jose: ciudadano","usr_asig":"Martinez Jose: ciudadano","9":"Martinez Jose: ciudadano","usr_resol":"Martinez Jose: ciudadano"}
			{"0":"362","id":"362","1":"108","wf_caso_81_id":"108","2":"134","wf_tarea_id":"134","3":null,"core_usuario_id":null,"4":"2015-04-16 09:55:10","fec_asig":"2015-04-16 09:55:10","5":"27","core_usuario_id_resol":"27","6":"2015-04-16 09:55:23","fec_resol":"2015-04-16 09:55:23","7":"134","wf_tarea_id_sig":"134","8":null,"usr_asig":null,"9":"ORTIZ JOHN: gerente, ciudadano","usr_resol":"ORTIZ JOHN: gerente, ciudadano"}
			{"0":"363","id":"363","1":"108","wf_caso_81_id":"108","2":"138","wf_tarea_id":"138","3":"27","core_usuario_id":"27","4":"2015-04-16 09:55:23","fec_asig":"2015-04-16 09:55:23","5":null,"core_usuario_id_resol":null,"6":null,"fec_resol":null,"7":"138","wf_tarea_id_sig":"138","8":"ORTIZ JOHN: gerente, ciudadano","usr_asig":"ORTIZ JOHN: gerente, ciudadano","9":null,"usr_resol":null}
2016-02 09 08:24:21  
cargar datos del sujeto(,,s,81,108)
	
				select  s.*, m.nombre as nom_muni, c.nom_cat,fec_caso
				from  wf_caso_81 w
				inner join core_sujetoverificacion  s on w.id=108 AND s.id =w.core_sujetoverificacion_id
				inner join plan_municipio m on s.plan_municipio_id=m.id
				inner join core_sujetocategoria c on s.core_sujetocategoria_id=c.id
				
2016-02 09 08:24:21  
tabla dat adic
	select tabla from core_sujetoverificaciontipo where id=1
2016-02 09 08:24:21  
tabla :persona
	SELECT * FROM persona where id=62
					ob_start();
					$ciud =  mb_strtoupper( "{ WFSV_2 } { WFSV_3 }",'utf-8');
					?>
					<p>
					Apreciado(a)<br>
					<strong><?php echo htmlentities($ciud) ?></strong>
					<p>
					<p>El presente mensaje es una notificaci&oacute;n para el caso No  <strong><?php echo 108; ?></strong> </p>
					<?php  $html=ob_get_clean();  
					TWFSV_3:Martinez
					TWFSV_2:Jose
					Su solicitud de<b>&nbsp;Permiso para publicidad exterior visual </b>&nbsp;para vallas o murales artísticos fue revisada y radicada con éxito.
					{ WFSV_1 } 
					TWFSV_1:jlmd0222@hotmail.com
					revisión-radicación vallas-murallas
 fin 2016-02-09  08:24:21
/******************************************************************************************************/

2016-02-09 08:24:21TraerCaso(108,81,)
 CargarCaso :108
2016-02 09 08:24:21  
CargarDatos: Caso :108
	cargar datos de ejecucion de los ultimos pasos 
		select p.*,b.wf_tarea_id as tarea_id,
				u.apellido||' '||u.nombre|| ': '||u.cargo as usr_ejec
				from
				(select max(id) as id, wf_caso_81_seguimiento_id,wf_paso_id from wf_caso_81_pasos a1  group by wf_caso_81_seguimiento_id,wf_paso_id order by id
				)a
				inner join wf_caso_81_pasos p using(id,wf_caso_81_seguimiento_id)
				inner join ( select max(id) as wf_caso_81_seguimiento_id,wf_caso_81_id,wf_tarea_id from wf_caso_81_seguimiento where wf_caso_81_id =? group by wf_caso_81_id,wf_tarea_id order by wf_caso_81_id,wf_caso_81_seguimiento_id  ) b using(wf_caso_81_seguimiento_id)
				left join  usuarios  u using(core_usuario_id) 
			{"0":"688","id":"688","1":"173","wf_paso_id":"173","2":"360","wf_caso_81_seguimiento_id":"360","3":"32","core_usuario_id":"32","4":"2015-04-16 09:54:07","fecha_ejec":"2015-04-16 09:54:07","5":"103","dato":"103","6":"sce.t22","tabla":"sce.t22","7":"78","tarea_id":"78","8":"Martinez Jose: ciudadano","usr_ejec":"Martinez Jose: ciudadano"}
				CargarDatos_173(103)
							se carga 81_78_173_22_23_3302
			{"0":"689","id":"689","1":"175","wf_paso_id":"175","2":"361","wf_caso_81_seguimiento_id":"361","3":"32","core_usuario_id":"32","4":"2015-04-16 09:54:53","fecha_ejec":"2015-04-16 09:54:53","5":"23","dato":"23","6":"sce.t25","tabla":"sce.t25","7":"80","tarea_id":"80","8":"Martinez Jose: ciudadano","usr_ejec":"Martinez Jose: ciudadano"}
				CargarDatos_175(23)
							se carga 81_80_175_25_26_407
							se carga 81_80_175_25_26_397dfsdfsfdsfdds
							se carga 81_80_175_25_26_3962015-04-25
							se carga 81_80_175_25_26_3952015-04-16
							se carga 81_80_175_25_26_394
							se carga 81_80_175_25_26_3931
							se carga 81_80_175_25_26_3924
							se carga 81_80_175_25_26_3914
							se carga 81_80_175_25_26_3901
							se carga 81_80_175_25_26_389
							se carga 81_80_175_25_26_388
							se carga 81_80_175_25_26_387cvxvcxvcx
							se carga 81_80_175_25_26_3861
							se carga 81_80_175_25_26_3852
							se carga 81_80_175_25_26_3841
							se carga 81_80_175_25_26_383
							se carga 81_80_175_25_26_382xcvxc
							se carga 81_80_175_25_26_381
							se carga 81_80_175_25_26_380asdfs@sda.com
							se carga 81_80_175_25_26_379342
							se carga 81_80_175_25_26_378342
							se carga 81_80_175_25_26_3771
							se carga 81_80_175_25_26_376cxv
							se carga 81_80_175_25_26_375cvxxcv
							se carga 81_80_175_25_26_374xcvcx
							se carga 81_80_175_25_26_373
							se carga 81_80_175_25_26_372xcvv
							se carga 81_80_175_25_26_371
							se carga 81_80_175_25_26_370asdfs@sda.com
							se carga 81_80_175_25_26_3694324
							se carga 81_80_175_25_26_36823432
							se carga 81_80_175_25_26_3671
							se carga 81_80_175_25_26_366czxz
							se carga 81_80_175_25_26_365zcxzcxzcx
							se carga 81_80_175_25_26_364cxzzxczcx
							se carga 81_80_175_25_26_363
							se carga 81_80_175_25_26_362zxccxz
							se carga 81_80_175_25_26_361
							se carga 81_80_175_25_26_360asdfs@sda.com
							se carga 81_80_175_25_26_359432
							se carga 81_80_175_25_26_358324243
							se carga 81_80_175_25_26_3571
							se carga 81_80_175_25_26_3561
							se carga 81_80_175_25_26_355
							se carga 81_80_175_25_26_354sdafsadfsad
							se carga 81_80_175_25_26_353sfdasf
							se carga 81_80_175_25_26_352
							se carga 81_80_175_25_26_3512015-04-16
			{"0":"690","id":"690","1":"239","wf_paso_id":"239","2":"361","wf_caso_81_seguimiento_id":"361","3":"32","core_usuario_id":"32","4":"2015-04-16 09:55:09","fecha_ejec":"2015-04-16 09:55:09","5":"5060","dato":"5060","6":"wf_documentoentradaadj_caso","tabla":"wf_documentoentradaadj_caso","7":"80","tarea_id":"80","8":"Martinez Jose: ciudadano","usr_ejec":"Martinez Jose: ciudadano"}
				CargarDatos_239(5060)
			{"0":"691","id":"691","1":"245","wf_paso_id":"245","2":"361","wf_caso_81_seguimiento_id":"361","3":"32","core_usuario_id":"32","4":"2015-04-16 09:55:10","fecha_ejec":"2015-04-16 09:55:10","5":null,"dato":null,"6":null,"tabla":null,"7":"80","tarea_id":"80","8":"Martinez Jose: ciudadano","usr_ejec":"Martinez Jose: ciudadano"}
				CargarDatos_245()
			{"0":"692","id":"692","1":"242","wf_paso_id":"242","2":"362","wf_caso_81_seguimiento_id":"362","3":"27","core_usuario_id":"27","4":"2015-04-16 09:55:23","fecha_ejec":"2015-04-16 09:55:23","5":"2162","dato":"2162","6":"wf_documentoentradaadj_caso","tabla":"wf_documentoentradaadj_caso","7":"134","tarea_id":"134","8":"ORTIZ JOHN: gerente, ciudadano","usr_ejec":"ORTIZ JOHN: gerente, ciudadano"}
				CargarDatos_242(2162)
			{"0":"698","id":"698","1":"256","wf_paso_id":"256","2":"363","wf_caso_81_seguimiento_id":"363","3":"27","core_usuario_id":"27","4":"2015-04-16 09:55:40","fecha_ejec":"2015-04-16 09:55:40","5":null,"dato":null,"6":null,"tabla":null,"7":"138","tarea_id":"138","8":"ORTIZ JOHN: gerente, ciudadano","usr_ejec":"ORTIZ JOHN: gerente, ciudadano"}
				CargarDatos_256()
	cargar datos de ejecucion de las tareas (las ultimas si el proceso tiene ciclos) 
		select a.*, u.apellido||' '||u.nombre|| ': '||u.cargo as usr_asig  , ur.apellido||' '||ur.nombre|| ': '||ur.cargo as usr_resol from
				wf_caso_81_seguimiento a
				inner join (
				select max(b0.id) as id,b0.wf_caso_81_id,b0.wf_tarea_id from wf_caso_81_seguimiento b0  where b0.wf_caso_81_id =? group by b0.wf_caso_81_id,b0.wf_tarea_id order by wf_caso_81_id,id
				) b using(id)
				left join  usuarios  u using(core_usuario_id)
				left join  usuarios  ur on ur.core_usuario_id=core_usuario_id_resol
			{"0":"360","id":"360","1":"108","wf_caso_81_id":"108","2":"78","wf_tarea_id":"78","3":null,"core_usuario_id":null,"4":"2015-04-16 09:54:05","fec_asig":"2015-04-16 09:54:05","5":"32","core_usuario_id_resol":"32","6":"2015-04-16 09:54:07","fec_resol":"2015-04-16 09:54:07","7":"78","wf_tarea_id_sig":"78","8":null,"usr_asig":null,"9":"Martinez Jose: ciudadano","usr_resol":"Martinez Jose: ciudadano"}
			{"0":"361","id":"361","1":"108","wf_caso_81_id":"108","2":"80","wf_tarea_id":"80","3":"32","core_usuario_id":"32","4":"2015-04-16 09:54:07","fec_asig":"2015-04-16 09:54:07","5":"32","core_usuario_id_resol":"32","6":"2015-04-16 09:55:10","fec_resol":"2015-04-16 09:55:10","7":"80","wf_tarea_id_sig":"80","8":"Martinez Jose: ciudadano","usr_asig":"Martinez Jose: ciudadano","9":"Martinez Jose: ciudadano","usr_resol":"Martinez Jose: ciudadano"}
			{"0":"362","id":"362","1":"108","wf_caso_81_id":"108","2":"134","wf_tarea_id":"134","3":null,"core_usuario_id":null,"4":"2015-04-16 09:55:10","fec_asig":"2015-04-16 09:55:10","5":"27","core_usuario_id_resol":"27","6":"2015-04-16 09:55:23","fec_resol":"2015-04-16 09:55:23","7":"134","wf_tarea_id_sig":"134","8":null,"usr_asig":null,"9":"ORTIZ JOHN: gerente, ciudadano","usr_resol":"ORTIZ JOHN: gerente, ciudadano"}
			{"0":"363","id":"363","1":"108","wf_caso_81_id":"108","2":"138","wf_tarea_id":"138","3":"27","core_usuario_id":"27","4":"2015-04-16 09:55:23","fec_asig":"2015-04-16 09:55:23","5":null,"core_usuario_id_resol":null,"6":null,"fec_resol":null,"7":"138","wf_tarea_id_sig":"138","8":"ORTIZ JOHN: gerente, ciudadano","usr_asig":"ORTIZ JOHN: gerente, ciudadano","9":null,"usr_resol":null}
2016-02 09 08:24:21  
cargar datos del sujeto(,,s,81,108)
	
				select  s.*, m.nombre as nom_muni, c.nom_cat,fec_caso
				from  wf_caso_81 w
				inner join core_sujetoverificacion  s on w.id=108 AND s.id =w.core_sujetoverificacion_id
				inner join plan_municipio m on s.plan_municipio_id=m.id
				inner join core_sujetocategoria c on s.core_sujetocategoria_id=c.id
				
2016-02 09 08:24:21  
tabla dat adic
	select tabla from core_sujetoverificaciontipo where id=1
2016-02 09 08:24:21  
tabla :persona
	SELECT * FROM persona where id=62
					ob_start();
					$ciud =  mb_strtoupper( "{ WFSV_2 } { WFSV_3 }",'utf-8');
					?>
					<p>
					Apreciado(a)<br>
					<strong><?php echo htmlentities($ciud) ?></strong>
					<p>
					<p>El presente mensaje es una notificaci&oacute;n para el caso No  <strong><?php echo 108; ?></strong> </p>
					<?php  $html=ob_get_clean();  
					TWFSV_3:Martinez
					TWFSV_2:Jose
					Su solicitud de<b>&nbsp;Permiso para publicidad exterior visual </b>&nbsp;para vallas o murales artísticos fue revisada y radicada con éxito.
					{ WFSV_1 } 
					TWFSV_1:jlmd0222@hotmail.com
					revisión-radicación vallas-murallas
 fin 2016-02-09  08:24:21
/******************************************************************************************************/

2016-02-09 08:24:22TraerCaso(108,81,)
 CargarCaso :108
2016-02 09 08:24:22  
CargarDatos: Caso :108
	cargar datos de ejecucion de los ultimos pasos 
		select p.*,b.wf_tarea_id as tarea_id,
				u.apellido||' '||u.nombre|| ': '||u.cargo as usr_ejec
				from
				(select max(id) as id, wf_caso_81_seguimiento_id,wf_paso_id from wf_caso_81_pasos a1  group by wf_caso_81_seguimiento_id,wf_paso_id order by id
				)a
				inner join wf_caso_81_pasos p using(id,wf_caso_81_seguimiento_id)
				inner join ( select max(id) as wf_caso_81_seguimiento_id,wf_caso_81_id,wf_tarea_id from wf_caso_81_seguimiento where wf_caso_81_id =? group by wf_caso_81_id,wf_tarea_id order by wf_caso_81_id,wf_caso_81_seguimiento_id  ) b using(wf_caso_81_seguimiento_id)
				left join  usuarios  u using(core_usuario_id) 
			{"0":"688","id":"688","1":"173","wf_paso_id":"173","2":"360","wf_caso_81_seguimiento_id":"360","3":"32","core_usuario_id":"32","4":"2015-04-16 09:54:07","fecha_ejec":"2015-04-16 09:54:07","5":"103","dato":"103","6":"sce.t22","tabla":"sce.t22","7":"78","tarea_id":"78","8":"Martinez Jose: ciudadano","usr_ejec":"Martinez Jose: ciudadano"}
				CargarDatos_173(103)
							se carga 81_78_173_22_23_3302
			{"0":"689","id":"689","1":"175","wf_paso_id":"175","2":"361","wf_caso_81_seguimiento_id":"361","3":"32","core_usuario_id":"32","4":"2015-04-16 09:54:53","fecha_ejec":"2015-04-16 09:54:53","5":"23","dato":"23","6":"sce.t25","tabla":"sce.t25","7":"80","tarea_id":"80","8":"Martinez Jose: ciudadano","usr_ejec":"Martinez Jose: ciudadano"}
				CargarDatos_175(23)
							se carga 81_80_175_25_26_407
							se carga 81_80_175_25_26_397dfsdfsfdsfdds
							se carga 81_80_175_25_26_3962015-04-25
							se carga 81_80_175_25_26_3952015-04-16
							se carga 81_80_175_25_26_394
							se carga 81_80_175_25_26_3931
							se carga 81_80_175_25_26_3924
							se carga 81_80_175_25_26_3914
							se carga 81_80_175_25_26_3901
							se carga 81_80_175_25_26_389
							se carga 81_80_175_25_26_388
							se carga 81_80_175_25_26_387cvxvcxvcx
							se carga 81_80_175_25_26_3861
							se carga 81_80_175_25_26_3852
							se carga 81_80_175_25_26_3841
							se carga 81_80_175_25_26_383
							se carga 81_80_175_25_26_382xcvxc
							se carga 81_80_175_25_26_381
							se carga 81_80_175_25_26_380asdfs@sda.com
							se carga 81_80_175_25_26_379342
							se carga 81_80_175_25_26_378342
							se carga 81_80_175_25_26_3771
							se carga 81_80_175_25_26_376cxv
							se carga 81_80_175_25_26_375cvxxcv
							se carga 81_80_175_25_26_374xcvcx
							se carga 81_80_175_25_26_373
							se carga 81_80_175_25_26_372xcvv
							se carga 81_80_175_25_26_371
							se carga 81_80_175_25_26_370asdfs@sda.com
							se carga 81_80_175_25_26_3694324
							se carga 81_80_175_25_26_36823432
							se carga 81_80_175_25_26_3671
							se carga 81_80_175_25_26_366czxz
							se carga 81_80_175_25_26_365zcxzcxzcx
							se carga 81_80_175_25_26_364cxzzxczcx
							se carga 81_80_175_25_26_363
							se carga 81_80_175_25_26_362zxccxz
							se carga 81_80_175_25_26_361
							se carga 81_80_175_25_26_360asdfs@sda.com
							se carga 81_80_175_25_26_359432
							se carga 81_80_175_25_26_358324243
							se carga 81_80_175_25_26_3571
							se carga 81_80_175_25_26_3561
							se carga 81_80_175_25_26_355
							se carga 81_80_175_25_26_354sdafsadfsad
							se carga 81_80_175_25_26_353sfdasf
							se carga 81_80_175_25_26_352
							se carga 81_80_175_25_26_3512015-04-16
			{"0":"690","id":"690","1":"239","wf_paso_id":"239","2":"361","wf_caso_81_seguimiento_id":"361","3":"32","core_usuario_id":"32","4":"2015-04-16 09:55:09","fecha_ejec":"2015-04-16 09:55:09","5":"5060","dato":"5060","6":"wf_documentoentradaadj_caso","tabla":"wf_documentoentradaadj_caso","7":"80","tarea_id":"80","8":"Martinez Jose: ciudadano","usr_ejec":"Martinez Jose: ciudadano"}
				CargarDatos_239(5060)
			{"0":"691","id":"691","1":"245","wf_paso_id":"245","2":"361","wf_caso_81_seguimiento_id":"361","3":"32","core_usuario_id":"32","4":"2015-04-16 09:55:10","fecha_ejec":"2015-04-16 09:55:10","5":null,"dato":null,"6":null,"tabla":null,"7":"80","tarea_id":"80","8":"Martinez Jose: ciudadano","usr_ejec":"Martinez Jose: ciudadano"}
				CargarDatos_245()
			{"0":"692","id":"692","1":"242","wf_paso_id":"242","2":"362","wf_caso_81_seguimiento_id":"362","3":"27","core_usuario_id":"27","4":"2015-04-16 09:55:23","fecha_ejec":"2015-04-16 09:55:23","5":"2162","dato":"2162","6":"wf_documentoentradaadj_caso","tabla":"wf_documentoentradaadj_caso","7":"134","tarea_id":"134","8":"ORTIZ JOHN: gerente, ciudadano","usr_ejec":"ORTIZ JOHN: gerente, ciudadano"}
				CargarDatos_242(2162)
			{"0":"698","id":"698","1":"256","wf_paso_id":"256","2":"363","wf_caso_81_seguimiento_id":"363","3":"27","core_usuario_id":"27","4":"2015-04-16 09:55:40","fecha_ejec":"2015-04-16 09:55:40","5":null,"dato":null,"6":null,"tabla":null,"7":"138","tarea_id":"138","8":"ORTIZ JOHN: gerente, ciudadano","usr_ejec":"ORTIZ JOHN: gerente, ciudadano"}
				CargarDatos_256()
	cargar datos de ejecucion de las tareas (las ultimas si el proceso tiene ciclos) 
		select a.*, u.apellido||' '||u.nombre|| ': '||u.cargo as usr_asig  , ur.apellido||' '||ur.nombre|| ': '||ur.cargo as usr_resol from
				wf_caso_81_seguimiento a
				inner join (
				select max(b0.id) as id,b0.wf_caso_81_id,b0.wf_tarea_id from wf_caso_81_seguimiento b0  where b0.wf_caso_81_id =? group by b0.wf_caso_81_id,b0.wf_tarea_id order by wf_caso_81_id,id
				) b using(id)
				left join  usuarios  u using(core_usuario_id)
				left join  usuarios  ur on ur.core_usuario_id=core_usuario_id_resol
			{"0":"360","id":"360","1":"108","wf_caso_81_id":"108","2":"78","wf_tarea_id":"78","3":null,"core_usuario_id":null,"4":"2015-04-16 09:54:05","fec_asig":"2015-04-16 09:54:05","5":"32","core_usuario_id_resol":"32","6":"2015-04-16 09:54:07","fec_resol":"2015-04-16 09:54:07","7":"78","wf_tarea_id_sig":"78","8":null,"usr_asig":null,"9":"Martinez Jose: ciudadano","usr_resol":"Martinez Jose: ciudadano"}
			{"0":"361","id":"361","1":"108","wf_caso_81_id":"108","2":"80","wf_tarea_id":"80","3":"32","core_usuario_id":"32","4":"2015-04-16 09:54:07","fec_asig":"2015-04-16 09:54:07","5":"32","core_usuario_id_resol":"32","6":"2015-04-16 09:55:10","fec_resol":"2015-04-16 09:55:10","7":"80","wf_tarea_id_sig":"80","8":"Martinez Jose: ciudadano","usr_asig":"Martinez Jose: ciudadano","9":"Martinez Jose: ciudadano","usr_resol":"Martinez Jose: ciudadano"}
			{"0":"362","id":"362","1":"108","wf_caso_81_id":"108","2":"134","wf_tarea_id":"134","3":null,"core_usuario_id":null,"4":"2015-04-16 09:55:10","fec_asig":"2015-04-16 09:55:10","5":"27","core_usuario_id_resol":"27","6":"2015-04-16 09:55:23","fec_resol":"2015-04-16 09:55:23","7":"134","wf_tarea_id_sig":"134","8":null,"usr_asig":null,"9":"ORTIZ JOHN: gerente, ciudadano","usr_resol":"ORTIZ JOHN: gerente, ciudadano"}
			{"0":"363","id":"363","1":"108","wf_caso_81_id":"108","2":"138","wf_tarea_id":"138","3":"27","core_usuario_id":"27","4":"2015-04-16 09:55:23","fec_asig":"2015-04-16 09:55:23","5":null,"core_usuario_id_resol":null,"6":null,"fec_resol":null,"7":"138","wf_tarea_id_sig":"138","8":"ORTIZ JOHN: gerente, ciudadano","usr_asig":"ORTIZ JOHN: gerente, ciudadano","9":null,"usr_resol":null}
2016-02 09 08:24:22  
cargar datos del sujeto(,,s,81,108)
	
				select  s.*, m.nombre as nom_muni, c.nom_cat,fec_caso
				from  wf_caso_81 w
				inner join core_sujetoverificacion  s on w.id=108 AND s.id =w.core_sujetoverificacion_id
				inner join plan_municipio m on s.plan_municipio_id=m.id
				inner join core_sujetocategoria c on s.core_sujetocategoria_id=c.id
				
2016-02 09 08:24:22  
tabla dat adic
	select tabla from core_sujetoverificaciontipo where id=1
2016-02 09 08:24:22  
tabla :persona
	SELECT * FROM persona where id=62
					ob_start();
					$ciud =  mb_strtoupper( "{ WFSV_2 } { WFSV_3 }",'utf-8');
					?>
					<p>
					Apreciado(a)<br>
					<strong><?php echo htmlentities($ciud) ?></strong>
					<p>
					<p>El presente mensaje es una notificaci&oacute;n para el caso No  <strong><?php echo 108; ?></strong> </p>
					<?php  $html=ob_get_clean();  
					TWFSV_3:Martinez
					TWFSV_2:Jose
					Su solicitud de<b>&nbsp;Permiso para publicidad exterior visual </b>&nbsp;para vallas o murales artísticos fue revisada y radicada con éxito.
					{ WFSV_1 } 
					TWFSV_1:jlmd0222@hotmail.com
					revisión-radicación vallas-murallas
 fin 2016-02-09  08:24:22
/******************************************************************************************************/