2015-07-02 09:44:09TraerCaso(11595,59,)
 CargarCaso :11595
2015-07 02 09:44:09  
CargarDatos: Caso :11595
	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_59_seguimiento_id,wf_paso_id from wf_caso_59_pasos a1  group by wf_caso_59_seguimiento_id,wf_paso_id order by id
				)a
				inner join wf_caso_59_pasos p using(id,wf_caso_59_seguimiento_id)
				inner join ( select max(id) as wf_caso_59_seguimiento_id,wf_caso_59_id,wf_tarea_id from wf_caso_59_seguimiento where wf_caso_59_id =? group by wf_caso_59_id,wf_tarea_id order by wf_caso_59_id,wf_caso_59_seguimiento_id  ) b using(wf_caso_59_seguimiento_id)
				left join  usuarios  u using(core_usuario_id)
			{"0":"115213","id":"115213","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"172","wf_paso_id":"172","4":"109243","wf_caso_59_seguimiento_id":"109243","5":"2014-09-09 14:15:10","fecha_ejec":"2014-09-09 14:15:10","6":"1550","dato":"1550","7":"sce.t2","tabla":"sce.t2","8":"1","core_usuario_id":"1","9":"105","tarea_id":"105","10":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_ejec":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
				CargarDatos_172(1550)
							se carga 59_105_172_2_2_81
							se carga 59_105_172_2_2_10sin observaciones<br>
			{"0":"115214","id":"115214","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"174","wf_paso_id":"174","4":"109245","wf_caso_59_seguimiento_id":"109245","5":"2014-09-09 14:16:46","fecha_ejec":"2014-09-09 14:16:46","6":"104658","dato":"104658","7":"wf_documentoentradadatos","tabla":"wf_documentoentradadatos","8":"1","core_usuario_id":"1","9":"107","tarea_id":"107","10":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_ejec":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
				CargarDatos_174(104658)
					Documento 104658 
					Documento 104658 
			{"0":"115215","id":"115215","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"176","wf_paso_id":"176","4":"109245","wf_caso_59_seguimiento_id":"109245","5":"2014-09-09 14:18:23","fecha_ejec":"2014-09-09 14:18:23","6":"104659","dato":"104659","7":"wf_documentoentradadatos","tabla":"wf_documentoentradadatos","8":"1","core_usuario_id":"1","9":"107","tarea_id":"107","10":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_ejec":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
				CargarDatos_176(104659)
					Documento 104659 
					Documento 104659 
			{"0":"115216","id":"115216","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"175","wf_paso_id":"175","4":"109245","wf_caso_59_seguimiento_id":"109245","5":"2014-09-09 14:18:51","fecha_ejec":"2014-09-09 14:18:51","6":"104660","dato":"104660","7":"wf_documentoentradadatos","tabla":"wf_documentoentradadatos","8":"1","core_usuario_id":"1","9":"107","tarea_id":"107","10":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_ejec":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
				CargarDatos_175(104660)
					Documento 104660 
					Documento 104660 
			{"0":"115217","id":"115217","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"177","wf_paso_id":"177","4":"109246","wf_caso_59_seguimiento_id":"109246","5":"2014-09-09 14:34:19","fecha_ejec":"2014-09-09 14:34:19","6":"1526","dato":"1526","7":"sce.t4","tabla":"sce.t4","8":"1","core_usuario_id":"1","9":"109","tarea_id":"109","10":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_ejec":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
				CargarDatos_177(1526)
							se carga 59_109_177_4_5_752014-09-10
							se carga 59_109_177_4_5_69sin descripcion de mercancias prueba
							se carga 59_109_177_4_5_6880
							se carga 59_109_177_4_5_6480423667,9,PAULO CESAR ORTIZ
							se carga 59_109_177_4_5_412014-09-09
							se carga 59_109_177_4_5_408
							se carga 59_109_177_4_5_398
							se carga 59_109_177_4_5_241
							se carga 59_109_177_4_5_22800
							se carga 59_109_177_4_5_2180
			{"0":"115218","id":"115218","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"182","wf_paso_id":"182","4":"109247","wf_caso_59_seguimiento_id":"109247","5":"2014-09-09 14:35:53","fecha_ejec":"2014-09-09 14:35:53","6":"1525","dato":"1525","7":"sce.t6","tabla":"sce.t6","8":"1","core_usuario_id":"1","9":"115","tarea_id":"115","10":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_ejec":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
				CargarDatos_182(1525)
							se carga 59_115_182_6_7_381
							se carga 59_115_182_6_7_377
							se carga 59_115_182_6_7_32sin observaciones de descargue<br>
			{"0":"115219","id":"115219","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"192","wf_paso_id":"192","4":"109247","wf_caso_59_seguimiento_id":"109247","5":"2014-09-09 14:36:36","fecha_ejec":"2014-09-09 14:36:36","6":"11365","dato":"11365","7":"core_upload","tabla":"core_upload","8":"1","core_usuario_id":"1","9":"115","tarea_id":"115","10":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_ejec":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
				CargarDatos_192(11365)
			{"0":"115220","id":"115220","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"184","wf_paso_id":"184","4":"109248","wf_caso_59_seguimiento_id":"109248","5":"2014-09-09 14:37:23","fecha_ejec":"2014-09-09 14:37:23","6":"1534","dato":"1534","7":"sce.t8","tabla":"sce.t8","8":"1","core_usuario_id":"1","9":"116","tarea_id":"116","10":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_ejec":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
				CargarDatos_184(1534)
							se carga 59_116_184_8_9_46observaciones informacion repeso
							se carga 59_116_184_8_9_45800
							se carga 59_116_184_8_9_448
							se carga 59_116_184_8_9_4380
			{"0":"115221","id":"115221","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"194","wf_paso_id":"194","4":"109248","wf_caso_59_seguimiento_id":"109248","5":"2014-09-09 14:37:52","fecha_ejec":"2014-09-09 14:37:52","6":"11366","dato":"11366","7":"core_upload","tabla":"core_upload","8":"1","core_usuario_id":"1","9":"116","tarea_id":"116","10":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_ejec":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
				CargarDatos_194(11366)
			{"0":"115222","id":"115222","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"193","wf_paso_id":"193","4":"109249","wf_caso_59_seguimiento_id":"109249","5":"2014-09-09 14:43:56","fecha_ejec":"2014-09-09 14:43:56","6":null,"dato":null,"7":null,"tabla":null,"8":"1","core_usuario_id":"1","9":"122","tarea_id":"122","10":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_ejec":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
				CargarDatos_193()
	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_59_seguimiento a
				inner join (
				select max(b0.id) as id,b0.wf_caso_59_id,b0.wf_tarea_id from wf_caso_59_seguimiento b0  where b0.wf_caso_59_id =? group by b0.wf_caso_59_id,b0.wf_tarea_id order by wf_caso_59_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":"109243","id":"109243","1":"11595","wf_caso_59_id":"11595","2":"105","wf_tarea_id":"105","3":null,"core_usuario_id":null,"4":"2014-09-08 08:48:13","fec_asig":"2014-09-08 08:48:13","5":"2014-09-09 14:15:10","fec_resol":"2014-09-09 14:15:10","6":"105","wf_tarea_id_sig":"105","7":"1","core_usuario_id_resol":"1","8":null,"usr_asig":null,"9":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_resol":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
			{"0":"109245","id":"109245","1":"11595","wf_caso_59_id":"11595","2":"107","wf_tarea_id":"107","3":"1","core_usuario_id":"1","4":"2014-09-09 14:15:10","fec_asig":"2014-09-09 14:15:10","5":"2014-09-09 14:18:51","fec_resol":"2014-09-09 14:18:51","6":"107","wf_tarea_id_sig":"107","7":"1","core_usuario_id_resol":"1","8":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_asig":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","9":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_resol":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
			{"0":"109246","id":"109246","1":"11595","wf_caso_59_id":"11595","2":"109","wf_tarea_id":"109","3":"1","core_usuario_id":"1","4":"2014-09-09 14:18:51","fec_asig":"2014-09-09 14:18:51","5":"2014-09-09 14:34:20","fec_resol":"2014-09-09 14:34:20","6":"109","wf_tarea_id_sig":"109","7":"1","core_usuario_id_resol":"1","8":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_asig":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","9":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_resol":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
			{"0":"109247","id":"109247","1":"11595","wf_caso_59_id":"11595","2":"115","wf_tarea_id":"115","3":"1","core_usuario_id":"1","4":"2014-09-09 14:34:20","fec_asig":"2014-09-09 14:34:20","5":"2014-09-09 14:36:36","fec_resol":"2014-09-09 14:36:36","6":"115","wf_tarea_id_sig":"115","7":"1","core_usuario_id_resol":"1","8":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_asig":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","9":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_resol":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
			{"0":"109248","id":"109248","1":"11595","wf_caso_59_id":"11595","2":"116","wf_tarea_id":"116","3":"1","core_usuario_id":"1","4":"2014-09-09 14:36:36","fec_asig":"2014-09-09 14:36:36","5":"2014-09-09 14:37:52","fec_resol":"2014-09-09 14:37:52","6":"116","wf_tarea_id_sig":"116","7":"1","core_usuario_id_resol":"1","8":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_asig":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","9":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_resol":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
			{"0":"109249","id":"109249","1":"11595","wf_caso_59_id":"11595","2":"122","wf_tarea_id":"122","3":"1","core_usuario_id":"1","4":"2014-09-09 14:37:52","fec_asig":"2014-09-09 14:37:52","5":"2014-09-09 14:43:56","fec_resol":"2014-09-09 14:43:56","6":"122","wf_tarea_id_sig":"122","7":"1","core_usuario_id_resol":"1","8":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_asig":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","9":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_resol":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
2015-07 02 09:44:09  
cargar datos del sujeto(,,s,59,11595)
	
				select  s.*, m.nombre as nom_muni, c.nom_cat,fec_caso
				from  wf_caso_59 w
				inner join core_sujetoverificacion  s on w.id=11595 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
				
2015-07 02 09:44:09  
tabla dat adic
	select tabla from core_sujetoverificaciontipo where id=1
2015-07 02 09:44:09  
tabla :core_sujetoverificacionstickerentrada
	SELECT * FROM core_sujetoverificacionstickerentrada where id=11586
 fin 2015-07-02  09:44:09
/******************************************************************************************************/

2015-07-02 09:44:09TraerCaso(11595,59,)
 CargarCaso :11595
2015-07 02 09:44:09  
CargarDatos: Caso :11595
	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_59_seguimiento_id,wf_paso_id from wf_caso_59_pasos a1  group by wf_caso_59_seguimiento_id,wf_paso_id order by id
				)a
				inner join wf_caso_59_pasos p using(id,wf_caso_59_seguimiento_id)
				inner join ( select max(id) as wf_caso_59_seguimiento_id,wf_caso_59_id,wf_tarea_id from wf_caso_59_seguimiento where wf_caso_59_id =? group by wf_caso_59_id,wf_tarea_id order by wf_caso_59_id,wf_caso_59_seguimiento_id  ) b using(wf_caso_59_seguimiento_id)
				left join  usuarios  u using(core_usuario_id)
			{"0":"115213","id":"115213","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"172","wf_paso_id":"172","4":"109243","wf_caso_59_seguimiento_id":"109243","5":"2014-09-09 14:15:10","fecha_ejec":"2014-09-09 14:15:10","6":"1550","dato":"1550","7":"sce.t2","tabla":"sce.t2","8":"1","core_usuario_id":"1","9":"105","tarea_id":"105","10":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_ejec":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
				CargarDatos_172(1550)
							se carga 59_105_172_2_2_81
							se carga 59_105_172_2_2_10sin observaciones<br>
			{"0":"115214","id":"115214","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"174","wf_paso_id":"174","4":"109245","wf_caso_59_seguimiento_id":"109245","5":"2014-09-09 14:16:46","fecha_ejec":"2014-09-09 14:16:46","6":"104658","dato":"104658","7":"wf_documentoentradadatos","tabla":"wf_documentoentradadatos","8":"1","core_usuario_id":"1","9":"107","tarea_id":"107","10":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_ejec":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
				CargarDatos_174(104658)
					Documento 104658 
					Documento 104658 
			{"0":"115215","id":"115215","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"176","wf_paso_id":"176","4":"109245","wf_caso_59_seguimiento_id":"109245","5":"2014-09-09 14:18:23","fecha_ejec":"2014-09-09 14:18:23","6":"104659","dato":"104659","7":"wf_documentoentradadatos","tabla":"wf_documentoentradadatos","8":"1","core_usuario_id":"1","9":"107","tarea_id":"107","10":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_ejec":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
				CargarDatos_176(104659)
					Documento 104659 
					Documento 104659 
			{"0":"115216","id":"115216","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"175","wf_paso_id":"175","4":"109245","wf_caso_59_seguimiento_id":"109245","5":"2014-09-09 14:18:51","fecha_ejec":"2014-09-09 14:18:51","6":"104660","dato":"104660","7":"wf_documentoentradadatos","tabla":"wf_documentoentradadatos","8":"1","core_usuario_id":"1","9":"107","tarea_id":"107","10":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_ejec":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
				CargarDatos_175(104660)
					Documento 104660 
					Documento 104660 
			{"0":"115217","id":"115217","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"177","wf_paso_id":"177","4":"109246","wf_caso_59_seguimiento_id":"109246","5":"2014-09-09 14:34:19","fecha_ejec":"2014-09-09 14:34:19","6":"1526","dato":"1526","7":"sce.t4","tabla":"sce.t4","8":"1","core_usuario_id":"1","9":"109","tarea_id":"109","10":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_ejec":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
				CargarDatos_177(1526)
							se carga 59_109_177_4_5_752014-09-10
							se carga 59_109_177_4_5_69sin descripcion de mercancias prueba
							se carga 59_109_177_4_5_6880
							se carga 59_109_177_4_5_6480423667,9,PAULO CESAR ORTIZ
							se carga 59_109_177_4_5_412014-09-09
							se carga 59_109_177_4_5_408
							se carga 59_109_177_4_5_398
							se carga 59_109_177_4_5_241
							se carga 59_109_177_4_5_22800
							se carga 59_109_177_4_5_2180
			{"0":"115218","id":"115218","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"182","wf_paso_id":"182","4":"109247","wf_caso_59_seguimiento_id":"109247","5":"2014-09-09 14:35:53","fecha_ejec":"2014-09-09 14:35:53","6":"1525","dato":"1525","7":"sce.t6","tabla":"sce.t6","8":"1","core_usuario_id":"1","9":"115","tarea_id":"115","10":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_ejec":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
				CargarDatos_182(1525)
							se carga 59_115_182_6_7_381
							se carga 59_115_182_6_7_377
							se carga 59_115_182_6_7_32sin observaciones de descargue<br>
			{"0":"115219","id":"115219","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"192","wf_paso_id":"192","4":"109247","wf_caso_59_seguimiento_id":"109247","5":"2014-09-09 14:36:36","fecha_ejec":"2014-09-09 14:36:36","6":"11365","dato":"11365","7":"core_upload","tabla":"core_upload","8":"1","core_usuario_id":"1","9":"115","tarea_id":"115","10":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_ejec":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
				CargarDatos_192(11365)
			{"0":"115220","id":"115220","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"184","wf_paso_id":"184","4":"109248","wf_caso_59_seguimiento_id":"109248","5":"2014-09-09 14:37:23","fecha_ejec":"2014-09-09 14:37:23","6":"1534","dato":"1534","7":"sce.t8","tabla":"sce.t8","8":"1","core_usuario_id":"1","9":"116","tarea_id":"116","10":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_ejec":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
				CargarDatos_184(1534)
							se carga 59_116_184_8_9_46observaciones informacion repeso
							se carga 59_116_184_8_9_45800
							se carga 59_116_184_8_9_448
							se carga 59_116_184_8_9_4380
			{"0":"115221","id":"115221","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"194","wf_paso_id":"194","4":"109248","wf_caso_59_seguimiento_id":"109248","5":"2014-09-09 14:37:52","fecha_ejec":"2014-09-09 14:37:52","6":"11366","dato":"11366","7":"core_upload","tabla":"core_upload","8":"1","core_usuario_id":"1","9":"116","tarea_id":"116","10":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_ejec":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
				CargarDatos_194(11366)
			{"0":"115222","id":"115222","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"193","wf_paso_id":"193","4":"109249","wf_caso_59_seguimiento_id":"109249","5":"2014-09-09 14:43:56","fecha_ejec":"2014-09-09 14:43:56","6":null,"dato":null,"7":null,"tabla":null,"8":"1","core_usuario_id":"1","9":"122","tarea_id":"122","10":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_ejec":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
				CargarDatos_193()
	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_59_seguimiento a
				inner join (
				select max(b0.id) as id,b0.wf_caso_59_id,b0.wf_tarea_id from wf_caso_59_seguimiento b0  where b0.wf_caso_59_id =? group by b0.wf_caso_59_id,b0.wf_tarea_id order by wf_caso_59_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":"109243","id":"109243","1":"11595","wf_caso_59_id":"11595","2":"105","wf_tarea_id":"105","3":null,"core_usuario_id":null,"4":"2014-09-08 08:48:13","fec_asig":"2014-09-08 08:48:13","5":"2014-09-09 14:15:10","fec_resol":"2014-09-09 14:15:10","6":"105","wf_tarea_id_sig":"105","7":"1","core_usuario_id_resol":"1","8":null,"usr_asig":null,"9":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_resol":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
			{"0":"109245","id":"109245","1":"11595","wf_caso_59_id":"11595","2":"107","wf_tarea_id":"107","3":"1","core_usuario_id":"1","4":"2014-09-09 14:15:10","fec_asig":"2014-09-09 14:15:10","5":"2014-09-09 14:18:51","fec_resol":"2014-09-09 14:18:51","6":"107","wf_tarea_id_sig":"107","7":"1","core_usuario_id_resol":"1","8":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_asig":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","9":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_resol":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
			{"0":"109246","id":"109246","1":"11595","wf_caso_59_id":"11595","2":"109","wf_tarea_id":"109","3":"1","core_usuario_id":"1","4":"2014-09-09 14:18:51","fec_asig":"2014-09-09 14:18:51","5":"2014-09-09 14:34:20","fec_resol":"2014-09-09 14:34:20","6":"109","wf_tarea_id_sig":"109","7":"1","core_usuario_id_resol":"1","8":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_asig":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","9":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_resol":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
			{"0":"109247","id":"109247","1":"11595","wf_caso_59_id":"11595","2":"115","wf_tarea_id":"115","3":"1","core_usuario_id":"1","4":"2014-09-09 14:34:20","fec_asig":"2014-09-09 14:34:20","5":"2014-09-09 14:36:36","fec_resol":"2014-09-09 14:36:36","6":"115","wf_tarea_id_sig":"115","7":"1","core_usuario_id_resol":"1","8":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_asig":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","9":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_resol":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
			{"0":"109248","id":"109248","1":"11595","wf_caso_59_id":"11595","2":"116","wf_tarea_id":"116","3":"1","core_usuario_id":"1","4":"2014-09-09 14:36:36","fec_asig":"2014-09-09 14:36:36","5":"2014-09-09 14:37:52","fec_resol":"2014-09-09 14:37:52","6":"116","wf_tarea_id_sig":"116","7":"1","core_usuario_id_resol":"1","8":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_asig":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","9":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_resol":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
			{"0":"109249","id":"109249","1":"11595","wf_caso_59_id":"11595","2":"122","wf_tarea_id":"122","3":"1","core_usuario_id":"1","4":"2014-09-09 14:37:52","fec_asig":"2014-09-09 14:37:52","5":"2014-09-09 14:43:56","fec_resol":"2014-09-09 14:43:56","6":"122","wf_tarea_id_sig":"122","7":"1","core_usuario_id_resol":"1","8":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_asig":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","9":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_resol":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
2015-07 02 09:44:10  
cargar datos del sujeto(,,s,59,11595)
	
				select  s.*, m.nombre as nom_muni, c.nom_cat,fec_caso
				from  wf_caso_59 w
				inner join core_sujetoverificacion  s on w.id=11595 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
				
2015-07 02 09:44:10  
tabla dat adic
	select tabla from core_sujetoverificaciontipo where id=1
2015-07 02 09:44:10  
tabla :core_sujetoverificacionstickerentrada
	SELECT * FROM core_sujetoverificacionstickerentrada where id=11586
 fin 2015-07-02  09:44:10
/******************************************************************************************************/

2015-07-02 09:44:10TraerCaso(11595,59,)
 CargarCaso :11595
2015-07 02 09:44:10  
CargarDatos: Caso :11595
	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_59_seguimiento_id,wf_paso_id from wf_caso_59_pasos a1  group by wf_caso_59_seguimiento_id,wf_paso_id order by id
				)a
				inner join wf_caso_59_pasos p using(id,wf_caso_59_seguimiento_id)
				inner join ( select max(id) as wf_caso_59_seguimiento_id,wf_caso_59_id,wf_tarea_id from wf_caso_59_seguimiento where wf_caso_59_id =? group by wf_caso_59_id,wf_tarea_id order by wf_caso_59_id,wf_caso_59_seguimiento_id  ) b using(wf_caso_59_seguimiento_id)
				left join  usuarios  u using(core_usuario_id)
			{"0":"115213","id":"115213","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"172","wf_paso_id":"172","4":"109243","wf_caso_59_seguimiento_id":"109243","5":"2014-09-09 14:15:10","fecha_ejec":"2014-09-09 14:15:10","6":"1550","dato":"1550","7":"sce.t2","tabla":"sce.t2","8":"1","core_usuario_id":"1","9":"105","tarea_id":"105","10":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_ejec":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
				CargarDatos_172(1550)
							se carga 59_105_172_2_2_81
							se carga 59_105_172_2_2_10sin observaciones<br>
			{"0":"115214","id":"115214","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"174","wf_paso_id":"174","4":"109245","wf_caso_59_seguimiento_id":"109245","5":"2014-09-09 14:16:46","fecha_ejec":"2014-09-09 14:16:46","6":"104658","dato":"104658","7":"wf_documentoentradadatos","tabla":"wf_documentoentradadatos","8":"1","core_usuario_id":"1","9":"107","tarea_id":"107","10":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_ejec":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
				CargarDatos_174(104658)
					Documento 104658 
					Documento 104658 
			{"0":"115215","id":"115215","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"176","wf_paso_id":"176","4":"109245","wf_caso_59_seguimiento_id":"109245","5":"2014-09-09 14:18:23","fecha_ejec":"2014-09-09 14:18:23","6":"104659","dato":"104659","7":"wf_documentoentradadatos","tabla":"wf_documentoentradadatos","8":"1","core_usuario_id":"1","9":"107","tarea_id":"107","10":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_ejec":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
				CargarDatos_176(104659)
					Documento 104659 
					Documento 104659 
			{"0":"115216","id":"115216","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"175","wf_paso_id":"175","4":"109245","wf_caso_59_seguimiento_id":"109245","5":"2014-09-09 14:18:51","fecha_ejec":"2014-09-09 14:18:51","6":"104660","dato":"104660","7":"wf_documentoentradadatos","tabla":"wf_documentoentradadatos","8":"1","core_usuario_id":"1","9":"107","tarea_id":"107","10":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_ejec":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
				CargarDatos_175(104660)
					Documento 104660 
					Documento 104660 
			{"0":"115217","id":"115217","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"177","wf_paso_id":"177","4":"109246","wf_caso_59_seguimiento_id":"109246","5":"2014-09-09 14:34:19","fecha_ejec":"2014-09-09 14:34:19","6":"1526","dato":"1526","7":"sce.t4","tabla":"sce.t4","8":"1","core_usuario_id":"1","9":"109","tarea_id":"109","10":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_ejec":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
				CargarDatos_177(1526)
							se carga 59_109_177_4_5_752014-09-10
							se carga 59_109_177_4_5_69sin descripcion de mercancias prueba
							se carga 59_109_177_4_5_6880
							se carga 59_109_177_4_5_6480423667,9,PAULO CESAR ORTIZ
							se carga 59_109_177_4_5_412014-09-09
							se carga 59_109_177_4_5_408
							se carga 59_109_177_4_5_398
							se carga 59_109_177_4_5_241
							se carga 59_109_177_4_5_22800
							se carga 59_109_177_4_5_2180
			{"0":"115218","id":"115218","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"182","wf_paso_id":"182","4":"109247","wf_caso_59_seguimiento_id":"109247","5":"2014-09-09 14:35:53","fecha_ejec":"2014-09-09 14:35:53","6":"1525","dato":"1525","7":"sce.t6","tabla":"sce.t6","8":"1","core_usuario_id":"1","9":"115","tarea_id":"115","10":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_ejec":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
				CargarDatos_182(1525)
							se carga 59_115_182_6_7_381
							se carga 59_115_182_6_7_377
							se carga 59_115_182_6_7_32sin observaciones de descargue<br>
			{"0":"115219","id":"115219","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"192","wf_paso_id":"192","4":"109247","wf_caso_59_seguimiento_id":"109247","5":"2014-09-09 14:36:36","fecha_ejec":"2014-09-09 14:36:36","6":"11365","dato":"11365","7":"core_upload","tabla":"core_upload","8":"1","core_usuario_id":"1","9":"115","tarea_id":"115","10":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_ejec":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
				CargarDatos_192(11365)
			{"0":"115220","id":"115220","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"184","wf_paso_id":"184","4":"109248","wf_caso_59_seguimiento_id":"109248","5":"2014-09-09 14:37:23","fecha_ejec":"2014-09-09 14:37:23","6":"1534","dato":"1534","7":"sce.t8","tabla":"sce.t8","8":"1","core_usuario_id":"1","9":"116","tarea_id":"116","10":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_ejec":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
				CargarDatos_184(1534)
							se carga 59_116_184_8_9_46observaciones informacion repeso
							se carga 59_116_184_8_9_45800
							se carga 59_116_184_8_9_448
							se carga 59_116_184_8_9_4380
			{"0":"115221","id":"115221","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"194","wf_paso_id":"194","4":"109248","wf_caso_59_seguimiento_id":"109248","5":"2014-09-09 14:37:52","fecha_ejec":"2014-09-09 14:37:52","6":"11366","dato":"11366","7":"core_upload","tabla":"core_upload","8":"1","core_usuario_id":"1","9":"116","tarea_id":"116","10":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_ejec":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
				CargarDatos_194(11366)
			{"0":"115222","id":"115222","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"193","wf_paso_id":"193","4":"109249","wf_caso_59_seguimiento_id":"109249","5":"2014-09-09 14:43:56","fecha_ejec":"2014-09-09 14:43:56","6":null,"dato":null,"7":null,"tabla":null,"8":"1","core_usuario_id":"1","9":"122","tarea_id":"122","10":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_ejec":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
				CargarDatos_193()
	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_59_seguimiento a
				inner join (
				select max(b0.id) as id,b0.wf_caso_59_id,b0.wf_tarea_id from wf_caso_59_seguimiento b0  where b0.wf_caso_59_id =? group by b0.wf_caso_59_id,b0.wf_tarea_id order by wf_caso_59_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":"109243","id":"109243","1":"11595","wf_caso_59_id":"11595","2":"105","wf_tarea_id":"105","3":null,"core_usuario_id":null,"4":"2014-09-08 08:48:13","fec_asig":"2014-09-08 08:48:13","5":"2014-09-09 14:15:10","fec_resol":"2014-09-09 14:15:10","6":"105","wf_tarea_id_sig":"105","7":"1","core_usuario_id_resol":"1","8":null,"usr_asig":null,"9":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_resol":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
			{"0":"109245","id":"109245","1":"11595","wf_caso_59_id":"11595","2":"107","wf_tarea_id":"107","3":"1","core_usuario_id":"1","4":"2014-09-09 14:15:10","fec_asig":"2014-09-09 14:15:10","5":"2014-09-09 14:18:51","fec_resol":"2014-09-09 14:18:51","6":"107","wf_tarea_id_sig":"107","7":"1","core_usuario_id_resol":"1","8":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_asig":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","9":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_resol":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
			{"0":"109246","id":"109246","1":"11595","wf_caso_59_id":"11595","2":"109","wf_tarea_id":"109","3":"1","core_usuario_id":"1","4":"2014-09-09 14:18:51","fec_asig":"2014-09-09 14:18:51","5":"2014-09-09 14:34:20","fec_resol":"2014-09-09 14:34:20","6":"109","wf_tarea_id_sig":"109","7":"1","core_usuario_id_resol":"1","8":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_asig":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","9":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_resol":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
			{"0":"109247","id":"109247","1":"11595","wf_caso_59_id":"11595","2":"115","wf_tarea_id":"115","3":"1","core_usuario_id":"1","4":"2014-09-09 14:34:20","fec_asig":"2014-09-09 14:34:20","5":"2014-09-09 14:36:36","fec_resol":"2014-09-09 14:36:36","6":"115","wf_tarea_id_sig":"115","7":"1","core_usuario_id_resol":"1","8":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_asig":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","9":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_resol":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
			{"0":"109248","id":"109248","1":"11595","wf_caso_59_id":"11595","2":"116","wf_tarea_id":"116","3":"1","core_usuario_id":"1","4":"2014-09-09 14:36:36","fec_asig":"2014-09-09 14:36:36","5":"2014-09-09 14:37:52","fec_resol":"2014-09-09 14:37:52","6":"116","wf_tarea_id_sig":"116","7":"1","core_usuario_id_resol":"1","8":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_asig":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","9":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_resol":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
			{"0":"109249","id":"109249","1":"11595","wf_caso_59_id":"11595","2":"122","wf_tarea_id":"122","3":"1","core_usuario_id":"1","4":"2014-09-09 14:37:52","fec_asig":"2014-09-09 14:37:52","5":"2014-09-09 14:43:56","fec_resol":"2014-09-09 14:43:56","6":"122","wf_tarea_id_sig":"122","7":"1","core_usuario_id_resol":"1","8":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_asig":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","9":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_resol":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
2015-07 02 09:44:10  
cargar datos del sujeto(,,s,59,11595)
	
				select  s.*, m.nombre as nom_muni, c.nom_cat,fec_caso
				from  wf_caso_59 w
				inner join core_sujetoverificacion  s on w.id=11595 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
				
2015-07 02 09:44:10  
tabla dat adic
	select tabla from core_sujetoverificaciontipo where id=1
2015-07 02 09:44:10  
tabla :core_sujetoverificacionstickerentrada
	SELECT * FROM core_sujetoverificacionstickerentrada where id=11586
 fin 2015-07-02  09:44:10
/******************************************************************************************************/

2015-07-02 09:44:10TraerCaso(11595,59,)
 CargarCaso :11595
2015-07 02 09:44:10  
CargarDatos: Caso :11595
	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_59_seguimiento_id,wf_paso_id from wf_caso_59_pasos a1  group by wf_caso_59_seguimiento_id,wf_paso_id order by id
				)a
				inner join wf_caso_59_pasos p using(id,wf_caso_59_seguimiento_id)
				inner join ( select max(id) as wf_caso_59_seguimiento_id,wf_caso_59_id,wf_tarea_id from wf_caso_59_seguimiento where wf_caso_59_id =? group by wf_caso_59_id,wf_tarea_id order by wf_caso_59_id,wf_caso_59_seguimiento_id  ) b using(wf_caso_59_seguimiento_id)
				left join  usuarios  u using(core_usuario_id)
			{"0":"115213","id":"115213","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"172","wf_paso_id":"172","4":"109243","wf_caso_59_seguimiento_id":"109243","5":"2014-09-09 14:15:10","fecha_ejec":"2014-09-09 14:15:10","6":"1550","dato":"1550","7":"sce.t2","tabla":"sce.t2","8":"1","core_usuario_id":"1","9":"105","tarea_id":"105","10":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_ejec":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
				CargarDatos_172(1550)
							se carga 59_105_172_2_2_81
							se carga 59_105_172_2_2_10sin observaciones<br>
			{"0":"115214","id":"115214","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"174","wf_paso_id":"174","4":"109245","wf_caso_59_seguimiento_id":"109245","5":"2014-09-09 14:16:46","fecha_ejec":"2014-09-09 14:16:46","6":"104658","dato":"104658","7":"wf_documentoentradadatos","tabla":"wf_documentoentradadatos","8":"1","core_usuario_id":"1","9":"107","tarea_id":"107","10":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_ejec":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
				CargarDatos_174(104658)
					Documento 104658 
					Documento 104658 
			{"0":"115215","id":"115215","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"176","wf_paso_id":"176","4":"109245","wf_caso_59_seguimiento_id":"109245","5":"2014-09-09 14:18:23","fecha_ejec":"2014-09-09 14:18:23","6":"104659","dato":"104659","7":"wf_documentoentradadatos","tabla":"wf_documentoentradadatos","8":"1","core_usuario_id":"1","9":"107","tarea_id":"107","10":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_ejec":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
				CargarDatos_176(104659)
					Documento 104659 
					Documento 104659 
			{"0":"115216","id":"115216","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"175","wf_paso_id":"175","4":"109245","wf_caso_59_seguimiento_id":"109245","5":"2014-09-09 14:18:51","fecha_ejec":"2014-09-09 14:18:51","6":"104660","dato":"104660","7":"wf_documentoentradadatos","tabla":"wf_documentoentradadatos","8":"1","core_usuario_id":"1","9":"107","tarea_id":"107","10":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_ejec":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
				CargarDatos_175(104660)
					Documento 104660 
					Documento 104660 
			{"0":"115217","id":"115217","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"177","wf_paso_id":"177","4":"109246","wf_caso_59_seguimiento_id":"109246","5":"2014-09-09 14:34:19","fecha_ejec":"2014-09-09 14:34:19","6":"1526","dato":"1526","7":"sce.t4","tabla":"sce.t4","8":"1","core_usuario_id":"1","9":"109","tarea_id":"109","10":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_ejec":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
				CargarDatos_177(1526)
							se carga 59_109_177_4_5_752014-09-10
							se carga 59_109_177_4_5_69sin descripcion de mercancias prueba
							se carga 59_109_177_4_5_6880
							se carga 59_109_177_4_5_6480423667,9,PAULO CESAR ORTIZ
							se carga 59_109_177_4_5_412014-09-09
							se carga 59_109_177_4_5_408
							se carga 59_109_177_4_5_398
							se carga 59_109_177_4_5_241
							se carga 59_109_177_4_5_22800
							se carga 59_109_177_4_5_2180
			{"0":"115218","id":"115218","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"182","wf_paso_id":"182","4":"109247","wf_caso_59_seguimiento_id":"109247","5":"2014-09-09 14:35:53","fecha_ejec":"2014-09-09 14:35:53","6":"1525","dato":"1525","7":"sce.t6","tabla":"sce.t6","8":"1","core_usuario_id":"1","9":"115","tarea_id":"115","10":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_ejec":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
				CargarDatos_182(1525)
							se carga 59_115_182_6_7_381
							se carga 59_115_182_6_7_377
							se carga 59_115_182_6_7_32sin observaciones de descargue<br>
			{"0":"115219","id":"115219","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"192","wf_paso_id":"192","4":"109247","wf_caso_59_seguimiento_id":"109247","5":"2014-09-09 14:36:36","fecha_ejec":"2014-09-09 14:36:36","6":"11365","dato":"11365","7":"core_upload","tabla":"core_upload","8":"1","core_usuario_id":"1","9":"115","tarea_id":"115","10":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_ejec":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
				CargarDatos_192(11365)
			{"0":"115220","id":"115220","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"184","wf_paso_id":"184","4":"109248","wf_caso_59_seguimiento_id":"109248","5":"2014-09-09 14:37:23","fecha_ejec":"2014-09-09 14:37:23","6":"1534","dato":"1534","7":"sce.t8","tabla":"sce.t8","8":"1","core_usuario_id":"1","9":"116","tarea_id":"116","10":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_ejec":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
				CargarDatos_184(1534)
							se carga 59_116_184_8_9_46observaciones informacion repeso
							se carga 59_116_184_8_9_45800
							se carga 59_116_184_8_9_448
							se carga 59_116_184_8_9_4380
			{"0":"115221","id":"115221","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"194","wf_paso_id":"194","4":"109248","wf_caso_59_seguimiento_id":"109248","5":"2014-09-09 14:37:52","fecha_ejec":"2014-09-09 14:37:52","6":"11366","dato":"11366","7":"core_upload","tabla":"core_upload","8":"1","core_usuario_id":"1","9":"116","tarea_id":"116","10":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_ejec":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
				CargarDatos_194(11366)
			{"0":"115222","id":"115222","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"193","wf_paso_id":"193","4":"109249","wf_caso_59_seguimiento_id":"109249","5":"2014-09-09 14:43:56","fecha_ejec":"2014-09-09 14:43:56","6":null,"dato":null,"7":null,"tabla":null,"8":"1","core_usuario_id":"1","9":"122","tarea_id":"122","10":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_ejec":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
				CargarDatos_193()
	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_59_seguimiento a
				inner join (
				select max(b0.id) as id,b0.wf_caso_59_id,b0.wf_tarea_id from wf_caso_59_seguimiento b0  where b0.wf_caso_59_id =? group by b0.wf_caso_59_id,b0.wf_tarea_id order by wf_caso_59_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":"109243","id":"109243","1":"11595","wf_caso_59_id":"11595","2":"105","wf_tarea_id":"105","3":null,"core_usuario_id":null,"4":"2014-09-08 08:48:13","fec_asig":"2014-09-08 08:48:13","5":"2014-09-09 14:15:10","fec_resol":"2014-09-09 14:15:10","6":"105","wf_tarea_id_sig":"105","7":"1","core_usuario_id_resol":"1","8":null,"usr_asig":null,"9":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_resol":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
			{"0":"109245","id":"109245","1":"11595","wf_caso_59_id":"11595","2":"107","wf_tarea_id":"107","3":"1","core_usuario_id":"1","4":"2014-09-09 14:15:10","fec_asig":"2014-09-09 14:15:10","5":"2014-09-09 14:18:51","fec_resol":"2014-09-09 14:18:51","6":"107","wf_tarea_id_sig":"107","7":"1","core_usuario_id_resol":"1","8":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_asig":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","9":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_resol":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
			{"0":"109246","id":"109246","1":"11595","wf_caso_59_id":"11595","2":"109","wf_tarea_id":"109","3":"1","core_usuario_id":"1","4":"2014-09-09 14:18:51","fec_asig":"2014-09-09 14:18:51","5":"2014-09-09 14:34:20","fec_resol":"2014-09-09 14:34:20","6":"109","wf_tarea_id_sig":"109","7":"1","core_usuario_id_resol":"1","8":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_asig":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","9":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_resol":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
			{"0":"109247","id":"109247","1":"11595","wf_caso_59_id":"11595","2":"115","wf_tarea_id":"115","3":"1","core_usuario_id":"1","4":"2014-09-09 14:34:20","fec_asig":"2014-09-09 14:34:20","5":"2014-09-09 14:36:36","fec_resol":"2014-09-09 14:36:36","6":"115","wf_tarea_id_sig":"115","7":"1","core_usuario_id_resol":"1","8":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_asig":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","9":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_resol":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
			{"0":"109248","id":"109248","1":"11595","wf_caso_59_id":"11595","2":"116","wf_tarea_id":"116","3":"1","core_usuario_id":"1","4":"2014-09-09 14:36:36","fec_asig":"2014-09-09 14:36:36","5":"2014-09-09 14:37:52","fec_resol":"2014-09-09 14:37:52","6":"116","wf_tarea_id_sig":"116","7":"1","core_usuario_id_resol":"1","8":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_asig":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","9":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_resol":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
			{"0":"109249","id":"109249","1":"11595","wf_caso_59_id":"11595","2":"122","wf_tarea_id":"122","3":"1","core_usuario_id":"1","4":"2014-09-09 14:37:52","fec_asig":"2014-09-09 14:37:52","5":"2014-09-09 14:43:56","fec_resol":"2014-09-09 14:43:56","6":"122","wf_tarea_id_sig":"122","7":"1","core_usuario_id_resol":"1","8":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_asig":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","9":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_resol":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
2015-07 02 09:44:10  
cargar datos del sujeto(,,s,59,11595)
	
				select  s.*, m.nombre as nom_muni, c.nom_cat,fec_caso
				from  wf_caso_59 w
				inner join core_sujetoverificacion  s on w.id=11595 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
				
2015-07 02 09:44:10  
tabla dat adic
	select tabla from core_sujetoverificaciontipo where id=1
2015-07 02 09:44:10  
tabla :core_sujetoverificacionstickerentrada
	SELECT * FROM core_sujetoverificacionstickerentrada where id=11586
 fin 2015-07-02  09:44:10
/******************************************************************************************************/

2015-07-02 09:44:10TraerCaso(11595,59,)
 CargarCaso :11595
2015-07 02 09:44:10  
CargarDatos: Caso :11595
	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_59_seguimiento_id,wf_paso_id from wf_caso_59_pasos a1  group by wf_caso_59_seguimiento_id,wf_paso_id order by id
				)a
				inner join wf_caso_59_pasos p using(id,wf_caso_59_seguimiento_id)
				inner join ( select max(id) as wf_caso_59_seguimiento_id,wf_caso_59_id,wf_tarea_id from wf_caso_59_seguimiento where wf_caso_59_id =? group by wf_caso_59_id,wf_tarea_id order by wf_caso_59_id,wf_caso_59_seguimiento_id  ) b using(wf_caso_59_seguimiento_id)
				left join  usuarios  u using(core_usuario_id)
			{"0":"115213","id":"115213","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"172","wf_paso_id":"172","4":"109243","wf_caso_59_seguimiento_id":"109243","5":"2014-09-09 14:15:10","fecha_ejec":"2014-09-09 14:15:10","6":"1550","dato":"1550","7":"sce.t2","tabla":"sce.t2","8":"1","core_usuario_id":"1","9":"105","tarea_id":"105","10":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_ejec":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
				CargarDatos_172(1550)
							se carga 59_105_172_2_2_81
							se carga 59_105_172_2_2_10sin observaciones<br>
			{"0":"115214","id":"115214","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"174","wf_paso_id":"174","4":"109245","wf_caso_59_seguimiento_id":"109245","5":"2014-09-09 14:16:46","fecha_ejec":"2014-09-09 14:16:46","6":"104658","dato":"104658","7":"wf_documentoentradadatos","tabla":"wf_documentoentradadatos","8":"1","core_usuario_id":"1","9":"107","tarea_id":"107","10":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_ejec":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
				CargarDatos_174(104658)
					Documento 104658 
					Documento 104658 
			{"0":"115215","id":"115215","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"176","wf_paso_id":"176","4":"109245","wf_caso_59_seguimiento_id":"109245","5":"2014-09-09 14:18:23","fecha_ejec":"2014-09-09 14:18:23","6":"104659","dato":"104659","7":"wf_documentoentradadatos","tabla":"wf_documentoentradadatos","8":"1","core_usuario_id":"1","9":"107","tarea_id":"107","10":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_ejec":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
				CargarDatos_176(104659)
					Documento 104659 
					Documento 104659 
			{"0":"115216","id":"115216","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"175","wf_paso_id":"175","4":"109245","wf_caso_59_seguimiento_id":"109245","5":"2014-09-09 14:18:51","fecha_ejec":"2014-09-09 14:18:51","6":"104660","dato":"104660","7":"wf_documentoentradadatos","tabla":"wf_documentoentradadatos","8":"1","core_usuario_id":"1","9":"107","tarea_id":"107","10":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_ejec":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
				CargarDatos_175(104660)
					Documento 104660 
					Documento 104660 
			{"0":"115217","id":"115217","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"177","wf_paso_id":"177","4":"109246","wf_caso_59_seguimiento_id":"109246","5":"2014-09-09 14:34:19","fecha_ejec":"2014-09-09 14:34:19","6":"1526","dato":"1526","7":"sce.t4","tabla":"sce.t4","8":"1","core_usuario_id":"1","9":"109","tarea_id":"109","10":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_ejec":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
				CargarDatos_177(1526)
							se carga 59_109_177_4_5_752014-09-10
							se carga 59_109_177_4_5_69sin descripcion de mercancias prueba
							se carga 59_109_177_4_5_6880
							se carga 59_109_177_4_5_6480423667,9,PAULO CESAR ORTIZ
							se carga 59_109_177_4_5_412014-09-09
							se carga 59_109_177_4_5_408
							se carga 59_109_177_4_5_398
							se carga 59_109_177_4_5_241
							se carga 59_109_177_4_5_22800
							se carga 59_109_177_4_5_2180
			{"0":"115218","id":"115218","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"182","wf_paso_id":"182","4":"109247","wf_caso_59_seguimiento_id":"109247","5":"2014-09-09 14:35:53","fecha_ejec":"2014-09-09 14:35:53","6":"1525","dato":"1525","7":"sce.t6","tabla":"sce.t6","8":"1","core_usuario_id":"1","9":"115","tarea_id":"115","10":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_ejec":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
				CargarDatos_182(1525)
							se carga 59_115_182_6_7_381
							se carga 59_115_182_6_7_377
							se carga 59_115_182_6_7_32sin observaciones de descargue<br>
			{"0":"115219","id":"115219","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"192","wf_paso_id":"192","4":"109247","wf_caso_59_seguimiento_id":"109247","5":"2014-09-09 14:36:36","fecha_ejec":"2014-09-09 14:36:36","6":"11365","dato":"11365","7":"core_upload","tabla":"core_upload","8":"1","core_usuario_id":"1","9":"115","tarea_id":"115","10":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_ejec":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
				CargarDatos_192(11365)
			{"0":"115220","id":"115220","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"184","wf_paso_id":"184","4":"109248","wf_caso_59_seguimiento_id":"109248","5":"2014-09-09 14:37:23","fecha_ejec":"2014-09-09 14:37:23","6":"1534","dato":"1534","7":"sce.t8","tabla":"sce.t8","8":"1","core_usuario_id":"1","9":"116","tarea_id":"116","10":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_ejec":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
				CargarDatos_184(1534)
							se carga 59_116_184_8_9_46observaciones informacion repeso
							se carga 59_116_184_8_9_45800
							se carga 59_116_184_8_9_448
							se carga 59_116_184_8_9_4380
			{"0":"115221","id":"115221","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"194","wf_paso_id":"194","4":"109248","wf_caso_59_seguimiento_id":"109248","5":"2014-09-09 14:37:52","fecha_ejec":"2014-09-09 14:37:52","6":"11366","dato":"11366","7":"core_upload","tabla":"core_upload","8":"1","core_usuario_id":"1","9":"116","tarea_id":"116","10":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_ejec":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
				CargarDatos_194(11366)
			{"0":"115222","id":"115222","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"193","wf_paso_id":"193","4":"109249","wf_caso_59_seguimiento_id":"109249","5":"2014-09-09 14:43:56","fecha_ejec":"2014-09-09 14:43:56","6":null,"dato":null,"7":null,"tabla":null,"8":"1","core_usuario_id":"1","9":"122","tarea_id":"122","10":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_ejec":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
				CargarDatos_193()
	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_59_seguimiento a
				inner join (
				select max(b0.id) as id,b0.wf_caso_59_id,b0.wf_tarea_id from wf_caso_59_seguimiento b0  where b0.wf_caso_59_id =? group by b0.wf_caso_59_id,b0.wf_tarea_id order by wf_caso_59_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":"109243","id":"109243","1":"11595","wf_caso_59_id":"11595","2":"105","wf_tarea_id":"105","3":null,"core_usuario_id":null,"4":"2014-09-08 08:48:13","fec_asig":"2014-09-08 08:48:13","5":"2014-09-09 14:15:10","fec_resol":"2014-09-09 14:15:10","6":"105","wf_tarea_id_sig":"105","7":"1","core_usuario_id_resol":"1","8":null,"usr_asig":null,"9":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_resol":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
			{"0":"109245","id":"109245","1":"11595","wf_caso_59_id":"11595","2":"107","wf_tarea_id":"107","3":"1","core_usuario_id":"1","4":"2014-09-09 14:15:10","fec_asig":"2014-09-09 14:15:10","5":"2014-09-09 14:18:51","fec_resol":"2014-09-09 14:18:51","6":"107","wf_tarea_id_sig":"107","7":"1","core_usuario_id_resol":"1","8":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_asig":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","9":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_resol":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
			{"0":"109246","id":"109246","1":"11595","wf_caso_59_id":"11595","2":"109","wf_tarea_id":"109","3":"1","core_usuario_id":"1","4":"2014-09-09 14:18:51","fec_asig":"2014-09-09 14:18:51","5":"2014-09-09 14:34:20","fec_resol":"2014-09-09 14:34:20","6":"109","wf_tarea_id_sig":"109","7":"1","core_usuario_id_resol":"1","8":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_asig":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","9":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_resol":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
			{"0":"109247","id":"109247","1":"11595","wf_caso_59_id":"11595","2":"115","wf_tarea_id":"115","3":"1","core_usuario_id":"1","4":"2014-09-09 14:34:20","fec_asig":"2014-09-09 14:34:20","5":"2014-09-09 14:36:36","fec_resol":"2014-09-09 14:36:36","6":"115","wf_tarea_id_sig":"115","7":"1","core_usuario_id_resol":"1","8":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_asig":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","9":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_resol":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
			{"0":"109248","id":"109248","1":"11595","wf_caso_59_id":"11595","2":"116","wf_tarea_id":"116","3":"1","core_usuario_id":"1","4":"2014-09-09 14:36:36","fec_asig":"2014-09-09 14:36:36","5":"2014-09-09 14:37:52","fec_resol":"2014-09-09 14:37:52","6":"116","wf_tarea_id_sig":"116","7":"1","core_usuario_id_resol":"1","8":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_asig":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","9":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_resol":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
			{"0":"109249","id":"109249","1":"11595","wf_caso_59_id":"11595","2":"122","wf_tarea_id":"122","3":"1","core_usuario_id":"1","4":"2014-09-09 14:37:52","fec_asig":"2014-09-09 14:37:52","5":"2014-09-09 14:43:56","fec_resol":"2014-09-09 14:43:56","6":"122","wf_tarea_id_sig":"122","7":"1","core_usuario_id_resol":"1","8":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_asig":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","9":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_resol":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
2015-07 02 09:44:10  
cargar datos del sujeto(,,s,59,11595)
	
				select  s.*, m.nombre as nom_muni, c.nom_cat,fec_caso
				from  wf_caso_59 w
				inner join core_sujetoverificacion  s on w.id=11595 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
				
2015-07 02 09:44:10  
tabla dat adic
	select tabla from core_sujetoverificaciontipo where id=1
2015-07 02 09:44:10  
tabla :core_sujetoverificacionstickerentrada
	SELECT * FROM core_sujetoverificacionstickerentrada where id=11586
 fin 2015-07-02  09:44:10
/******************************************************************************************************/

2015-07-02 09:44:10TraerCaso(11595,59,)
 CargarCaso :11595
2015-07 02 09:44:10  
CargarDatos: Caso :11595
	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_59_seguimiento_id,wf_paso_id from wf_caso_59_pasos a1  group by wf_caso_59_seguimiento_id,wf_paso_id order by id
				)a
				inner join wf_caso_59_pasos p using(id,wf_caso_59_seguimiento_id)
				inner join ( select max(id) as wf_caso_59_seguimiento_id,wf_caso_59_id,wf_tarea_id from wf_caso_59_seguimiento where wf_caso_59_id =? group by wf_caso_59_id,wf_tarea_id order by wf_caso_59_id,wf_caso_59_seguimiento_id  ) b using(wf_caso_59_seguimiento_id)
				left join  usuarios  u using(core_usuario_id)
			{"0":"115213","id":"115213","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"172","wf_paso_id":"172","4":"109243","wf_caso_59_seguimiento_id":"109243","5":"2014-09-09 14:15:10","fecha_ejec":"2014-09-09 14:15:10","6":"1550","dato":"1550","7":"sce.t2","tabla":"sce.t2","8":"1","core_usuario_id":"1","9":"105","tarea_id":"105","10":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_ejec":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
				CargarDatos_172(1550)
							se carga 59_105_172_2_2_81
							se carga 59_105_172_2_2_10sin observaciones<br>
			{"0":"115214","id":"115214","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"174","wf_paso_id":"174","4":"109245","wf_caso_59_seguimiento_id":"109245","5":"2014-09-09 14:16:46","fecha_ejec":"2014-09-09 14:16:46","6":"104658","dato":"104658","7":"wf_documentoentradadatos","tabla":"wf_documentoentradadatos","8":"1","core_usuario_id":"1","9":"107","tarea_id":"107","10":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_ejec":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
				CargarDatos_174(104658)
					Documento 104658 
					Documento 104658 
			{"0":"115215","id":"115215","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"176","wf_paso_id":"176","4":"109245","wf_caso_59_seguimiento_id":"109245","5":"2014-09-09 14:18:23","fecha_ejec":"2014-09-09 14:18:23","6":"104659","dato":"104659","7":"wf_documentoentradadatos","tabla":"wf_documentoentradadatos","8":"1","core_usuario_id":"1","9":"107","tarea_id":"107","10":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_ejec":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
				CargarDatos_176(104659)
					Documento 104659 
					Documento 104659 
			{"0":"115216","id":"115216","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"175","wf_paso_id":"175","4":"109245","wf_caso_59_seguimiento_id":"109245","5":"2014-09-09 14:18:51","fecha_ejec":"2014-09-09 14:18:51","6":"104660","dato":"104660","7":"wf_documentoentradadatos","tabla":"wf_documentoentradadatos","8":"1","core_usuario_id":"1","9":"107","tarea_id":"107","10":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_ejec":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
				CargarDatos_175(104660)
					Documento 104660 
					Documento 104660 
			{"0":"115217","id":"115217","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"177","wf_paso_id":"177","4":"109246","wf_caso_59_seguimiento_id":"109246","5":"2014-09-09 14:34:19","fecha_ejec":"2014-09-09 14:34:19","6":"1526","dato":"1526","7":"sce.t4","tabla":"sce.t4","8":"1","core_usuario_id":"1","9":"109","tarea_id":"109","10":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_ejec":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
				CargarDatos_177(1526)
							se carga 59_109_177_4_5_752014-09-10
							se carga 59_109_177_4_5_69sin descripcion de mercancias prueba
							se carga 59_109_177_4_5_6880
							se carga 59_109_177_4_5_6480423667,9,PAULO CESAR ORTIZ
							se carga 59_109_177_4_5_412014-09-09
							se carga 59_109_177_4_5_408
							se carga 59_109_177_4_5_398
							se carga 59_109_177_4_5_241
							se carga 59_109_177_4_5_22800
							se carga 59_109_177_4_5_2180
			{"0":"115218","id":"115218","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"182","wf_paso_id":"182","4":"109247","wf_caso_59_seguimiento_id":"109247","5":"2014-09-09 14:35:53","fecha_ejec":"2014-09-09 14:35:53","6":"1525","dato":"1525","7":"sce.t6","tabla":"sce.t6","8":"1","core_usuario_id":"1","9":"115","tarea_id":"115","10":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_ejec":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
				CargarDatos_182(1525)
							se carga 59_115_182_6_7_381
							se carga 59_115_182_6_7_377
							se carga 59_115_182_6_7_32sin observaciones de descargue<br>
			{"0":"115219","id":"115219","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"192","wf_paso_id":"192","4":"109247","wf_caso_59_seguimiento_id":"109247","5":"2014-09-09 14:36:36","fecha_ejec":"2014-09-09 14:36:36","6":"11365","dato":"11365","7":"core_upload","tabla":"core_upload","8":"1","core_usuario_id":"1","9":"115","tarea_id":"115","10":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_ejec":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
				CargarDatos_192(11365)
			{"0":"115220","id":"115220","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"184","wf_paso_id":"184","4":"109248","wf_caso_59_seguimiento_id":"109248","5":"2014-09-09 14:37:23","fecha_ejec":"2014-09-09 14:37:23","6":"1534","dato":"1534","7":"sce.t8","tabla":"sce.t8","8":"1","core_usuario_id":"1","9":"116","tarea_id":"116","10":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_ejec":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
				CargarDatos_184(1534)
							se carga 59_116_184_8_9_46observaciones informacion repeso
							se carga 59_116_184_8_9_45800
							se carga 59_116_184_8_9_448
							se carga 59_116_184_8_9_4380
			{"0":"115221","id":"115221","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"194","wf_paso_id":"194","4":"109248","wf_caso_59_seguimiento_id":"109248","5":"2014-09-09 14:37:52","fecha_ejec":"2014-09-09 14:37:52","6":"11366","dato":"11366","7":"core_upload","tabla":"core_upload","8":"1","core_usuario_id":"1","9":"116","tarea_id":"116","10":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_ejec":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
				CargarDatos_194(11366)
			{"0":"115222","id":"115222","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"193","wf_paso_id":"193","4":"109249","wf_caso_59_seguimiento_id":"109249","5":"2014-09-09 14:43:56","fecha_ejec":"2014-09-09 14:43:56","6":null,"dato":null,"7":null,"tabla":null,"8":"1","core_usuario_id":"1","9":"122","tarea_id":"122","10":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_ejec":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
				CargarDatos_193()
	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_59_seguimiento a
				inner join (
				select max(b0.id) as id,b0.wf_caso_59_id,b0.wf_tarea_id from wf_caso_59_seguimiento b0  where b0.wf_caso_59_id =? group by b0.wf_caso_59_id,b0.wf_tarea_id order by wf_caso_59_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":"109243","id":"109243","1":"11595","wf_caso_59_id":"11595","2":"105","wf_tarea_id":"105","3":null,"core_usuario_id":null,"4":"2014-09-08 08:48:13","fec_asig":"2014-09-08 08:48:13","5":"2014-09-09 14:15:10","fec_resol":"2014-09-09 14:15:10","6":"105","wf_tarea_id_sig":"105","7":"1","core_usuario_id_resol":"1","8":null,"usr_asig":null,"9":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_resol":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
			{"0":"109245","id":"109245","1":"11595","wf_caso_59_id":"11595","2":"107","wf_tarea_id":"107","3":"1","core_usuario_id":"1","4":"2014-09-09 14:15:10","fec_asig":"2014-09-09 14:15:10","5":"2014-09-09 14:18:51","fec_resol":"2014-09-09 14:18:51","6":"107","wf_tarea_id_sig":"107","7":"1","core_usuario_id_resol":"1","8":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_asig":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","9":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_resol":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
			{"0":"109246","id":"109246","1":"11595","wf_caso_59_id":"11595","2":"109","wf_tarea_id":"109","3":"1","core_usuario_id":"1","4":"2014-09-09 14:18:51","fec_asig":"2014-09-09 14:18:51","5":"2014-09-09 14:34:20","fec_resol":"2014-09-09 14:34:20","6":"109","wf_tarea_id_sig":"109","7":"1","core_usuario_id_resol":"1","8":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_asig":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","9":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_resol":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
			{"0":"109247","id":"109247","1":"11595","wf_caso_59_id":"11595","2":"115","wf_tarea_id":"115","3":"1","core_usuario_id":"1","4":"2014-09-09 14:34:20","fec_asig":"2014-09-09 14:34:20","5":"2014-09-09 14:36:36","fec_resol":"2014-09-09 14:36:36","6":"115","wf_tarea_id_sig":"115","7":"1","core_usuario_id_resol":"1","8":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_asig":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","9":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_resol":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
			{"0":"109248","id":"109248","1":"11595","wf_caso_59_id":"11595","2":"116","wf_tarea_id":"116","3":"1","core_usuario_id":"1","4":"2014-09-09 14:36:36","fec_asig":"2014-09-09 14:36:36","5":"2014-09-09 14:37:52","fec_resol":"2014-09-09 14:37:52","6":"116","wf_tarea_id_sig":"116","7":"1","core_usuario_id_resol":"1","8":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_asig":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","9":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_resol":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
			{"0":"109249","id":"109249","1":"11595","wf_caso_59_id":"11595","2":"122","wf_tarea_id":"122","3":"1","core_usuario_id":"1","4":"2014-09-09 14:37:52","fec_asig":"2014-09-09 14:37:52","5":"2014-09-09 14:43:56","fec_resol":"2014-09-09 14:43:56","6":"122","wf_tarea_id_sig":"122","7":"1","core_usuario_id_resol":"1","8":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_asig":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","9":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_resol":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
2015-07 02 09:44:10  
cargar datos del sujeto(,,s,59,11595)
	
				select  s.*, m.nombre as nom_muni, c.nom_cat,fec_caso
				from  wf_caso_59 w
				inner join core_sujetoverificacion  s on w.id=11595 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
				
2015-07 02 09:44:10  
tabla dat adic
	select tabla from core_sujetoverificaciontipo where id=1
2015-07 02 09:44:10  
tabla :core_sujetoverificacionstickerentrada
	SELECT * FROM core_sujetoverificacionstickerentrada where id=11586
 fin 2015-07-02  09:44:10
/******************************************************************************************************/

2015-07-02 09:44:10TraerCaso(11595,59,)
 CargarCaso :11595
2015-07 02 09:44:10  
CargarDatos: Caso :11595
	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_59_seguimiento_id,wf_paso_id from wf_caso_59_pasos a1  group by wf_caso_59_seguimiento_id,wf_paso_id order by id
				)a
				inner join wf_caso_59_pasos p using(id,wf_caso_59_seguimiento_id)
				inner join ( select max(id) as wf_caso_59_seguimiento_id,wf_caso_59_id,wf_tarea_id from wf_caso_59_seguimiento where wf_caso_59_id =? group by wf_caso_59_id,wf_tarea_id order by wf_caso_59_id,wf_caso_59_seguimiento_id  ) b using(wf_caso_59_seguimiento_id)
				left join  usuarios  u using(core_usuario_id)
			{"0":"115213","id":"115213","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"172","wf_paso_id":"172","4":"109243","wf_caso_59_seguimiento_id":"109243","5":"2014-09-09 14:15:10","fecha_ejec":"2014-09-09 14:15:10","6":"1550","dato":"1550","7":"sce.t2","tabla":"sce.t2","8":"1","core_usuario_id":"1","9":"105","tarea_id":"105","10":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_ejec":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
				CargarDatos_172(1550)
							se carga 59_105_172_2_2_81
							se carga 59_105_172_2_2_10sin observaciones<br>
			{"0":"115214","id":"115214","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"174","wf_paso_id":"174","4":"109245","wf_caso_59_seguimiento_id":"109245","5":"2014-09-09 14:16:46","fecha_ejec":"2014-09-09 14:16:46","6":"104658","dato":"104658","7":"wf_documentoentradadatos","tabla":"wf_documentoentradadatos","8":"1","core_usuario_id":"1","9":"107","tarea_id":"107","10":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_ejec":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
				CargarDatos_174(104658)
					Documento 104658 
					Documento 104658 
			{"0":"115215","id":"115215","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"176","wf_paso_id":"176","4":"109245","wf_caso_59_seguimiento_id":"109245","5":"2014-09-09 14:18:23","fecha_ejec":"2014-09-09 14:18:23","6":"104659","dato":"104659","7":"wf_documentoentradadatos","tabla":"wf_documentoentradadatos","8":"1","core_usuario_id":"1","9":"107","tarea_id":"107","10":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_ejec":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
				CargarDatos_176(104659)
					Documento 104659 
					Documento 104659 
			{"0":"115216","id":"115216","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"175","wf_paso_id":"175","4":"109245","wf_caso_59_seguimiento_id":"109245","5":"2014-09-09 14:18:51","fecha_ejec":"2014-09-09 14:18:51","6":"104660","dato":"104660","7":"wf_documentoentradadatos","tabla":"wf_documentoentradadatos","8":"1","core_usuario_id":"1","9":"107","tarea_id":"107","10":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_ejec":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
				CargarDatos_175(104660)
					Documento 104660 
					Documento 104660 
			{"0":"115217","id":"115217","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"177","wf_paso_id":"177","4":"109246","wf_caso_59_seguimiento_id":"109246","5":"2014-09-09 14:34:19","fecha_ejec":"2014-09-09 14:34:19","6":"1526","dato":"1526","7":"sce.t4","tabla":"sce.t4","8":"1","core_usuario_id":"1","9":"109","tarea_id":"109","10":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_ejec":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
				CargarDatos_177(1526)
							se carga 59_109_177_4_5_752014-09-10
							se carga 59_109_177_4_5_69sin descripcion de mercancias prueba
							se carga 59_109_177_4_5_6880
							se carga 59_109_177_4_5_6480423667,9,PAULO CESAR ORTIZ
							se carga 59_109_177_4_5_412014-09-09
							se carga 59_109_177_4_5_408
							se carga 59_109_177_4_5_398
							se carga 59_109_177_4_5_241
							se carga 59_109_177_4_5_22800
							se carga 59_109_177_4_5_2180
			{"0":"115218","id":"115218","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"182","wf_paso_id":"182","4":"109247","wf_caso_59_seguimiento_id":"109247","5":"2014-09-09 14:35:53","fecha_ejec":"2014-09-09 14:35:53","6":"1525","dato":"1525","7":"sce.t6","tabla":"sce.t6","8":"1","core_usuario_id":"1","9":"115","tarea_id":"115","10":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_ejec":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
				CargarDatos_182(1525)
							se carga 59_115_182_6_7_381
							se carga 59_115_182_6_7_377
							se carga 59_115_182_6_7_32sin observaciones de descargue<br>
			{"0":"115219","id":"115219","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"192","wf_paso_id":"192","4":"109247","wf_caso_59_seguimiento_id":"109247","5":"2014-09-09 14:36:36","fecha_ejec":"2014-09-09 14:36:36","6":"11365","dato":"11365","7":"core_upload","tabla":"core_upload","8":"1","core_usuario_id":"1","9":"115","tarea_id":"115","10":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_ejec":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
				CargarDatos_192(11365)
			{"0":"115220","id":"115220","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"184","wf_paso_id":"184","4":"109248","wf_caso_59_seguimiento_id":"109248","5":"2014-09-09 14:37:23","fecha_ejec":"2014-09-09 14:37:23","6":"1534","dato":"1534","7":"sce.t8","tabla":"sce.t8","8":"1","core_usuario_id":"1","9":"116","tarea_id":"116","10":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_ejec":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
				CargarDatos_184(1534)
							se carga 59_116_184_8_9_46observaciones informacion repeso
							se carga 59_116_184_8_9_45800
							se carga 59_116_184_8_9_448
							se carga 59_116_184_8_9_4380
			{"0":"115221","id":"115221","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"194","wf_paso_id":"194","4":"109248","wf_caso_59_seguimiento_id":"109248","5":"2014-09-09 14:37:52","fecha_ejec":"2014-09-09 14:37:52","6":"11366","dato":"11366","7":"core_upload","tabla":"core_upload","8":"1","core_usuario_id":"1","9":"116","tarea_id":"116","10":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_ejec":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
				CargarDatos_194(11366)
			{"0":"115222","id":"115222","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"193","wf_paso_id":"193","4":"109249","wf_caso_59_seguimiento_id":"109249","5":"2014-09-09 14:43:56","fecha_ejec":"2014-09-09 14:43:56","6":null,"dato":null,"7":null,"tabla":null,"8":"1","core_usuario_id":"1","9":"122","tarea_id":"122","10":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_ejec":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
				CargarDatos_193()
	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_59_seguimiento a
				inner join (
				select max(b0.id) as id,b0.wf_caso_59_id,b0.wf_tarea_id from wf_caso_59_seguimiento b0  where b0.wf_caso_59_id =? group by b0.wf_caso_59_id,b0.wf_tarea_id order by wf_caso_59_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":"109243","id":"109243","1":"11595","wf_caso_59_id":"11595","2":"105","wf_tarea_id":"105","3":null,"core_usuario_id":null,"4":"2014-09-08 08:48:13","fec_asig":"2014-09-08 08:48:13","5":"2014-09-09 14:15:10","fec_resol":"2014-09-09 14:15:10","6":"105","wf_tarea_id_sig":"105","7":"1","core_usuario_id_resol":"1","8":null,"usr_asig":null,"9":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_resol":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
			{"0":"109245","id":"109245","1":"11595","wf_caso_59_id":"11595","2":"107","wf_tarea_id":"107","3":"1","core_usuario_id":"1","4":"2014-09-09 14:15:10","fec_asig":"2014-09-09 14:15:10","5":"2014-09-09 14:18:51","fec_resol":"2014-09-09 14:18:51","6":"107","wf_tarea_id_sig":"107","7":"1","core_usuario_id_resol":"1","8":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_asig":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","9":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_resol":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
			{"0":"109246","id":"109246","1":"11595","wf_caso_59_id":"11595","2":"109","wf_tarea_id":"109","3":"1","core_usuario_id":"1","4":"2014-09-09 14:18:51","fec_asig":"2014-09-09 14:18:51","5":"2014-09-09 14:34:20","fec_resol":"2014-09-09 14:34:20","6":"109","wf_tarea_id_sig":"109","7":"1","core_usuario_id_resol":"1","8":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_asig":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","9":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_resol":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
			{"0":"109247","id":"109247","1":"11595","wf_caso_59_id":"11595","2":"115","wf_tarea_id":"115","3":"1","core_usuario_id":"1","4":"2014-09-09 14:34:20","fec_asig":"2014-09-09 14:34:20","5":"2014-09-09 14:36:36","fec_resol":"2014-09-09 14:36:36","6":"115","wf_tarea_id_sig":"115","7":"1","core_usuario_id_resol":"1","8":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_asig":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","9":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_resol":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
			{"0":"109248","id":"109248","1":"11595","wf_caso_59_id":"11595","2":"116","wf_tarea_id":"116","3":"1","core_usuario_id":"1","4":"2014-09-09 14:36:36","fec_asig":"2014-09-09 14:36:36","5":"2014-09-09 14:37:52","fec_resol":"2014-09-09 14:37:52","6":"116","wf_tarea_id_sig":"116","7":"1","core_usuario_id_resol":"1","8":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_asig":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","9":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_resol":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
			{"0":"109249","id":"109249","1":"11595","wf_caso_59_id":"11595","2":"122","wf_tarea_id":"122","3":"1","core_usuario_id":"1","4":"2014-09-09 14:37:52","fec_asig":"2014-09-09 14:37:52","5":"2014-09-09 14:43:56","fec_resol":"2014-09-09 14:43:56","6":"122","wf_tarea_id_sig":"122","7":"1","core_usuario_id_resol":"1","8":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_asig":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","9":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_resol":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
2015-07 02 09:44:10  
cargar datos del sujeto(,,s,59,11595)
	
				select  s.*, m.nombre as nom_muni, c.nom_cat,fec_caso
				from  wf_caso_59 w
				inner join core_sujetoverificacion  s on w.id=11595 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
				
2015-07 02 09:44:10  
tabla dat adic
	select tabla from core_sujetoverificaciontipo where id=1
2015-07 02 09:44:10  
tabla :core_sujetoverificacionstickerentrada
	SELECT * FROM core_sujetoverificacionstickerentrada where id=11586
 fin 2015-07-02  09:44:10
/******************************************************************************************************/

2015-07-02 09:44:10TraerCaso(11595,59,)
 CargarCaso :11595
2015-07 02 09:44:10  
CargarDatos: Caso :11595
	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_59_seguimiento_id,wf_paso_id from wf_caso_59_pasos a1  group by wf_caso_59_seguimiento_id,wf_paso_id order by id
				)a
				inner join wf_caso_59_pasos p using(id,wf_caso_59_seguimiento_id)
				inner join ( select max(id) as wf_caso_59_seguimiento_id,wf_caso_59_id,wf_tarea_id from wf_caso_59_seguimiento where wf_caso_59_id =? group by wf_caso_59_id,wf_tarea_id order by wf_caso_59_id,wf_caso_59_seguimiento_id  ) b using(wf_caso_59_seguimiento_id)
				left join  usuarios  u using(core_usuario_id)
			{"0":"115213","id":"115213","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"172","wf_paso_id":"172","4":"109243","wf_caso_59_seguimiento_id":"109243","5":"2014-09-09 14:15:10","fecha_ejec":"2014-09-09 14:15:10","6":"1550","dato":"1550","7":"sce.t2","tabla":"sce.t2","8":"1","core_usuario_id":"1","9":"105","tarea_id":"105","10":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_ejec":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
				CargarDatos_172(1550)
							se carga 59_105_172_2_2_81
							se carga 59_105_172_2_2_10sin observaciones<br>
			{"0":"115214","id":"115214","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"174","wf_paso_id":"174","4":"109245","wf_caso_59_seguimiento_id":"109245","5":"2014-09-09 14:16:46","fecha_ejec":"2014-09-09 14:16:46","6":"104658","dato":"104658","7":"wf_documentoentradadatos","tabla":"wf_documentoentradadatos","8":"1","core_usuario_id":"1","9":"107","tarea_id":"107","10":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_ejec":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
				CargarDatos_174(104658)
					Documento 104658 
					Documento 104658 
			{"0":"115215","id":"115215","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"176","wf_paso_id":"176","4":"109245","wf_caso_59_seguimiento_id":"109245","5":"2014-09-09 14:18:23","fecha_ejec":"2014-09-09 14:18:23","6":"104659","dato":"104659","7":"wf_documentoentradadatos","tabla":"wf_documentoentradadatos","8":"1","core_usuario_id":"1","9":"107","tarea_id":"107","10":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_ejec":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
				CargarDatos_176(104659)
					Documento 104659 
					Documento 104659 
			{"0":"115216","id":"115216","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"175","wf_paso_id":"175","4":"109245","wf_caso_59_seguimiento_id":"109245","5":"2014-09-09 14:18:51","fecha_ejec":"2014-09-09 14:18:51","6":"104660","dato":"104660","7":"wf_documentoentradadatos","tabla":"wf_documentoentradadatos","8":"1","core_usuario_id":"1","9":"107","tarea_id":"107","10":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_ejec":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
				CargarDatos_175(104660)
					Documento 104660 
					Documento 104660 
			{"0":"115217","id":"115217","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"177","wf_paso_id":"177","4":"109246","wf_caso_59_seguimiento_id":"109246","5":"2014-09-09 14:34:19","fecha_ejec":"2014-09-09 14:34:19","6":"1526","dato":"1526","7":"sce.t4","tabla":"sce.t4","8":"1","core_usuario_id":"1","9":"109","tarea_id":"109","10":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_ejec":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
				CargarDatos_177(1526)
							se carga 59_109_177_4_5_752014-09-10
							se carga 59_109_177_4_5_69sin descripcion de mercancias prueba
							se carga 59_109_177_4_5_6880
							se carga 59_109_177_4_5_6480423667,9,PAULO CESAR ORTIZ
							se carga 59_109_177_4_5_412014-09-09
							se carga 59_109_177_4_5_408
							se carga 59_109_177_4_5_398
							se carga 59_109_177_4_5_241
							se carga 59_109_177_4_5_22800
							se carga 59_109_177_4_5_2180
			{"0":"115218","id":"115218","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"182","wf_paso_id":"182","4":"109247","wf_caso_59_seguimiento_id":"109247","5":"2014-09-09 14:35:53","fecha_ejec":"2014-09-09 14:35:53","6":"1525","dato":"1525","7":"sce.t6","tabla":"sce.t6","8":"1","core_usuario_id":"1","9":"115","tarea_id":"115","10":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_ejec":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
				CargarDatos_182(1525)
							se carga 59_115_182_6_7_381
							se carga 59_115_182_6_7_377
							se carga 59_115_182_6_7_32sin observaciones de descargue<br>
			{"0":"115219","id":"115219","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"192","wf_paso_id":"192","4":"109247","wf_caso_59_seguimiento_id":"109247","5":"2014-09-09 14:36:36","fecha_ejec":"2014-09-09 14:36:36","6":"11365","dato":"11365","7":"core_upload","tabla":"core_upload","8":"1","core_usuario_id":"1","9":"115","tarea_id":"115","10":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_ejec":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
				CargarDatos_192(11365)
			{"0":"115220","id":"115220","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"184","wf_paso_id":"184","4":"109248","wf_caso_59_seguimiento_id":"109248","5":"2014-09-09 14:37:23","fecha_ejec":"2014-09-09 14:37:23","6":"1534","dato":"1534","7":"sce.t8","tabla":"sce.t8","8":"1","core_usuario_id":"1","9":"116","tarea_id":"116","10":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_ejec":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
				CargarDatos_184(1534)
							se carga 59_116_184_8_9_46observaciones informacion repeso
							se carga 59_116_184_8_9_45800
							se carga 59_116_184_8_9_448
							se carga 59_116_184_8_9_4380
			{"0":"115221","id":"115221","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"194","wf_paso_id":"194","4":"109248","wf_caso_59_seguimiento_id":"109248","5":"2014-09-09 14:37:52","fecha_ejec":"2014-09-09 14:37:52","6":"11366","dato":"11366","7":"core_upload","tabla":"core_upload","8":"1","core_usuario_id":"1","9":"116","tarea_id":"116","10":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_ejec":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
				CargarDatos_194(11366)
			{"0":"115222","id":"115222","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"193","wf_paso_id":"193","4":"109249","wf_caso_59_seguimiento_id":"109249","5":"2014-09-09 14:43:56","fecha_ejec":"2014-09-09 14:43:56","6":null,"dato":null,"7":null,"tabla":null,"8":"1","core_usuario_id":"1","9":"122","tarea_id":"122","10":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_ejec":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
				CargarDatos_193()
	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_59_seguimiento a
				inner join (
				select max(b0.id) as id,b0.wf_caso_59_id,b0.wf_tarea_id from wf_caso_59_seguimiento b0  where b0.wf_caso_59_id =? group by b0.wf_caso_59_id,b0.wf_tarea_id order by wf_caso_59_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":"109243","id":"109243","1":"11595","wf_caso_59_id":"11595","2":"105","wf_tarea_id":"105","3":null,"core_usuario_id":null,"4":"2014-09-08 08:48:13","fec_asig":"2014-09-08 08:48:13","5":"2014-09-09 14:15:10","fec_resol":"2014-09-09 14:15:10","6":"105","wf_tarea_id_sig":"105","7":"1","core_usuario_id_resol":"1","8":null,"usr_asig":null,"9":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_resol":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
			{"0":"109245","id":"109245","1":"11595","wf_caso_59_id":"11595","2":"107","wf_tarea_id":"107","3":"1","core_usuario_id":"1","4":"2014-09-09 14:15:10","fec_asig":"2014-09-09 14:15:10","5":"2014-09-09 14:18:51","fec_resol":"2014-09-09 14:18:51","6":"107","wf_tarea_id_sig":"107","7":"1","core_usuario_id_resol":"1","8":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_asig":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","9":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_resol":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
			{"0":"109246","id":"109246","1":"11595","wf_caso_59_id":"11595","2":"109","wf_tarea_id":"109","3":"1","core_usuario_id":"1","4":"2014-09-09 14:18:51","fec_asig":"2014-09-09 14:18:51","5":"2014-09-09 14:34:20","fec_resol":"2014-09-09 14:34:20","6":"109","wf_tarea_id_sig":"109","7":"1","core_usuario_id_resol":"1","8":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_asig":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","9":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_resol":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
			{"0":"109247","id":"109247","1":"11595","wf_caso_59_id":"11595","2":"115","wf_tarea_id":"115","3":"1","core_usuario_id":"1","4":"2014-09-09 14:34:20","fec_asig":"2014-09-09 14:34:20","5":"2014-09-09 14:36:36","fec_resol":"2014-09-09 14:36:36","6":"115","wf_tarea_id_sig":"115","7":"1","core_usuario_id_resol":"1","8":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_asig":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","9":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_resol":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
			{"0":"109248","id":"109248","1":"11595","wf_caso_59_id":"11595","2":"116","wf_tarea_id":"116","3":"1","core_usuario_id":"1","4":"2014-09-09 14:36:36","fec_asig":"2014-09-09 14:36:36","5":"2014-09-09 14:37:52","fec_resol":"2014-09-09 14:37:52","6":"116","wf_tarea_id_sig":"116","7":"1","core_usuario_id_resol":"1","8":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_asig":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","9":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_resol":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
			{"0":"109249","id":"109249","1":"11595","wf_caso_59_id":"11595","2":"122","wf_tarea_id":"122","3":"1","core_usuario_id":"1","4":"2014-09-09 14:37:52","fec_asig":"2014-09-09 14:37:52","5":"2014-09-09 14:43:56","fec_resol":"2014-09-09 14:43:56","6":"122","wf_tarea_id_sig":"122","7":"1","core_usuario_id_resol":"1","8":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_asig":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","9":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_resol":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
2015-07 02 09:44:10  
cargar datos del sujeto(,,s,59,11595)
	
				select  s.*, m.nombre as nom_muni, c.nom_cat,fec_caso
				from  wf_caso_59 w
				inner join core_sujetoverificacion  s on w.id=11595 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
				
2015-07 02 09:44:10  
tabla dat adic
	select tabla from core_sujetoverificaciontipo where id=1
2015-07 02 09:44:10  
tabla :core_sujetoverificacionstickerentrada
	SELECT * FROM core_sujetoverificacionstickerentrada where id=11586
 fin 2015-07-02  09:44:10
/******************************************************************************************************/