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
{"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
{"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
{"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
{"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
{"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
{"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
{"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
{"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
{"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
{"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
{"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
{"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
{"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
{"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
{"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
{"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
/******************************************************************************************************/