2015-07-02 09:44:10TraerCaso(11596,59,) CargarCaso :11596 2015-07 02 09:44:10 CargarDatos: Caso :11596 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":"115224","id":"115224","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"172","wf_paso_id":"172","4":"109250","wf_caso_59_seguimiento_id":"109250","5":"2014-09-11 10:57:19","fecha_ejec":"2014-09-11 10:57:19","6":"1552","dato":"1552","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(1552) se carga 59_105_172_2_2_81 se carga 59_105_172_2_2_10n {"0":"115225","id":"115225","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"174","wf_paso_id":"174","4":"109251","wf_caso_59_seguimiento_id":"109251","5":"2014-09-11 11:04:31","fecha_ejec":"2014-09-11 11:04:31","6":"104663","dato":"104663","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(104663) Documento 104663 Documento 104663 {"0":"115226","id":"115226","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"176","wf_paso_id":"176","4":"109251","wf_caso_59_seguimiento_id":"109251","5":"2014-09-11 11:04:38","fecha_ejec":"2014-09-11 11:04:38","6":"104664","dato":"104664","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(104664) Documento 104664 Documento 104664 {"0":"115227","id":"115227","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"175","wf_paso_id":"175","4":"109251","wf_caso_59_seguimiento_id":"109251","5":"2014-09-11 11:04:44","fecha_ejec":"2014-09-11 11:04:44","6":"104665","dato":"104665","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(104665) Documento 104665 Documento 104665 {"0":"115228","id":"115228","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"177","wf_paso_id":"177","4":"109252","wf_caso_59_seguimiento_id":"109252","5":"2014-09-11 11:08:30","fecha_ejec":"2014-09-11 11:08:30","6":"1527","dato":"1527","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(1527) se carga 59_109_177_4_5_752014-09-10 se carga 59_109_177_4_5_69cafe se carga 59_109_177_4_5_68sacos se carga 59_109_177_4_5_6463350616,7,MARTHA CECILIA VELEZ GIRALDO se carga 59_109_177_4_5_412014-09-11 se carga 59_109_177_4_5_4078789879 se carga 59_109_177_4_5_39897879879879 se carga 59_109_177_4_5_241 se carga 59_109_177_4_5_2250000 se carga 59_109_177_4_5_211000 {"0":"115229","id":"115229","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"182","wf_paso_id":"182","4":"109253","wf_caso_59_seguimiento_id":"109253","5":"2014-09-11 11:09:32","fecha_ejec":"2014-09-11 11:09:32","6":"1526","dato":"1526","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(1526) se carga 59_115_182_6_7_381 se carga 59_115_182_6_7_371 se carga 59_115_182_6_7_32n {"0":"115230","id":"115230","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"192","wf_paso_id":"192","4":"109253","wf_caso_59_seguimiento_id":"109253","5":"2014-09-11 11:10:56","fecha_ejec":"2014-09-11 11:10:56","6":"11383","dato":"11383","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(11383) {"0":"115231","id":"115231","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"184","wf_paso_id":"184","4":"109254","wf_caso_59_seguimiento_id":"109254","5":"2014-09-11 11:14:43","fecha_ejec":"2014-09-11 11:14:43","6":"1535","dato":"1535","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(1535) se carga 59_116_184_8_9_46se encontraron sacos rotos se carga 59_116_184_8_9_4549500 se carga 59_116_184_8_9_443000 se carga 59_116_184_8_9_4352500 {"0":"115232","id":"115232","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"194","wf_paso_id":"194","4":"109254","wf_caso_59_seguimiento_id":"109254","5":"2014-09-11 11:16:02","fecha_ejec":"2014-09-11 11:16:02","6":"11384","dato":"11384","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(11384) 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":"109250","id":"109250","1":"11596","wf_caso_59_id":"11596","2":"105","wf_tarea_id":"105","3":null,"core_usuario_id":null,"4":"2014-09-11 10:56:53","fec_asig":"2014-09-11 10:56:53","5":"2014-09-11 10:57:19","fec_resol":"2014-09-11 10:57:19","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":"109251","id":"109251","1":"11596","wf_caso_59_id":"11596","2":"107","wf_tarea_id":"107","3":"1","core_usuario_id":"1","4":"2014-09-11 10:57:19","fec_asig":"2014-09-11 10:57:19","5":"2014-09-11 11:04:44","fec_resol":"2014-09-11 11:04:44","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":"109252","id":"109252","1":"11596","wf_caso_59_id":"11596","2":"109","wf_tarea_id":"109","3":"1","core_usuario_id":"1","4":"2014-09-11 11:04:44","fec_asig":"2014-09-11 11:04:44","5":"2014-09-11 11:08:30","fec_resol":"2014-09-11 11:08:30","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":"109253","id":"109253","1":"11596","wf_caso_59_id":"11596","2":"115","wf_tarea_id":"115","3":"1","core_usuario_id":"1","4":"2014-09-11 11:08:30","fec_asig":"2014-09-11 11:08:30","5":"2014-09-11 11:10:56","fec_resol":"2014-09-11 11:10:56","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":"109254","id":"109254","1":"11596","wf_caso_59_id":"11596","2":"116","wf_tarea_id":"116","3":"1","core_usuario_id":"1","4":"2014-09-11 11:10:56","fec_asig":"2014-09-11 11:10:56","5":"2014-09-11 11:16:02","fec_resol":"2014-09-11 11:16:02","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":"109255","id":"109255","1":"11596","wf_caso_59_id":"11596","2":"122","wf_tarea_id":"122","3":"1","core_usuario_id":"1","4":"2014-09-11 11:16:02","fec_asig":"2014-09-11 11:16:02","5":null,"fec_resol":null,"6":"122","wf_tarea_id_sig":"122","7":null,"core_usuario_id_resol":null,"8":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_asig":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","9":null,"usr_resol":null} 2015-07 02 09:44:10 cargar datos del sujeto(,,s,59,11596) 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=11596 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(11596,59,) CargarCaso :11596 2015-07 02 09:44:10 CargarDatos: Caso :11596 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":"115224","id":"115224","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"172","wf_paso_id":"172","4":"109250","wf_caso_59_seguimiento_id":"109250","5":"2014-09-11 10:57:19","fecha_ejec":"2014-09-11 10:57:19","6":"1552","dato":"1552","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(1552) se carga 59_105_172_2_2_81 se carga 59_105_172_2_2_10n {"0":"115225","id":"115225","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"174","wf_paso_id":"174","4":"109251","wf_caso_59_seguimiento_id":"109251","5":"2014-09-11 11:04:31","fecha_ejec":"2014-09-11 11:04:31","6":"104663","dato":"104663","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(104663) Documento 104663 Documento 104663 {"0":"115226","id":"115226","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"176","wf_paso_id":"176","4":"109251","wf_caso_59_seguimiento_id":"109251","5":"2014-09-11 11:04:38","fecha_ejec":"2014-09-11 11:04:38","6":"104664","dato":"104664","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(104664) Documento 104664 Documento 104664 {"0":"115227","id":"115227","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"175","wf_paso_id":"175","4":"109251","wf_caso_59_seguimiento_id":"109251","5":"2014-09-11 11:04:44","fecha_ejec":"2014-09-11 11:04:44","6":"104665","dato":"104665","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(104665) Documento 104665 Documento 104665 {"0":"115228","id":"115228","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"177","wf_paso_id":"177","4":"109252","wf_caso_59_seguimiento_id":"109252","5":"2014-09-11 11:08:30","fecha_ejec":"2014-09-11 11:08:30","6":"1527","dato":"1527","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(1527) se carga 59_109_177_4_5_752014-09-10 se carga 59_109_177_4_5_69cafe se carga 59_109_177_4_5_68sacos se carga 59_109_177_4_5_6463350616,7,MARTHA CECILIA VELEZ GIRALDO se carga 59_109_177_4_5_412014-09-11 se carga 59_109_177_4_5_4078789879 se carga 59_109_177_4_5_39897879879879 se carga 59_109_177_4_5_241 se carga 59_109_177_4_5_2250000 se carga 59_109_177_4_5_211000 {"0":"115229","id":"115229","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"182","wf_paso_id":"182","4":"109253","wf_caso_59_seguimiento_id":"109253","5":"2014-09-11 11:09:32","fecha_ejec":"2014-09-11 11:09:32","6":"1526","dato":"1526","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(1526) se carga 59_115_182_6_7_381 se carga 59_115_182_6_7_371 se carga 59_115_182_6_7_32n {"0":"115230","id":"115230","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"192","wf_paso_id":"192","4":"109253","wf_caso_59_seguimiento_id":"109253","5":"2014-09-11 11:10:56","fecha_ejec":"2014-09-11 11:10:56","6":"11383","dato":"11383","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(11383) {"0":"115231","id":"115231","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"184","wf_paso_id":"184","4":"109254","wf_caso_59_seguimiento_id":"109254","5":"2014-09-11 11:14:43","fecha_ejec":"2014-09-11 11:14:43","6":"1535","dato":"1535","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(1535) se carga 59_116_184_8_9_46se encontraron sacos rotos se carga 59_116_184_8_9_4549500 se carga 59_116_184_8_9_443000 se carga 59_116_184_8_9_4352500 {"0":"115232","id":"115232","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"194","wf_paso_id":"194","4":"109254","wf_caso_59_seguimiento_id":"109254","5":"2014-09-11 11:16:02","fecha_ejec":"2014-09-11 11:16:02","6":"11384","dato":"11384","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(11384) 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":"109250","id":"109250","1":"11596","wf_caso_59_id":"11596","2":"105","wf_tarea_id":"105","3":null,"core_usuario_id":null,"4":"2014-09-11 10:56:53","fec_asig":"2014-09-11 10:56:53","5":"2014-09-11 10:57:19","fec_resol":"2014-09-11 10:57:19","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":"109251","id":"109251","1":"11596","wf_caso_59_id":"11596","2":"107","wf_tarea_id":"107","3":"1","core_usuario_id":"1","4":"2014-09-11 10:57:19","fec_asig":"2014-09-11 10:57:19","5":"2014-09-11 11:04:44","fec_resol":"2014-09-11 11:04:44","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":"109252","id":"109252","1":"11596","wf_caso_59_id":"11596","2":"109","wf_tarea_id":"109","3":"1","core_usuario_id":"1","4":"2014-09-11 11:04:44","fec_asig":"2014-09-11 11:04:44","5":"2014-09-11 11:08:30","fec_resol":"2014-09-11 11:08:30","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":"109253","id":"109253","1":"11596","wf_caso_59_id":"11596","2":"115","wf_tarea_id":"115","3":"1","core_usuario_id":"1","4":"2014-09-11 11:08:30","fec_asig":"2014-09-11 11:08:30","5":"2014-09-11 11:10:56","fec_resol":"2014-09-11 11:10:56","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":"109254","id":"109254","1":"11596","wf_caso_59_id":"11596","2":"116","wf_tarea_id":"116","3":"1","core_usuario_id":"1","4":"2014-09-11 11:10:56","fec_asig":"2014-09-11 11:10:56","5":"2014-09-11 11:16:02","fec_resol":"2014-09-11 11:16:02","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":"109255","id":"109255","1":"11596","wf_caso_59_id":"11596","2":"122","wf_tarea_id":"122","3":"1","core_usuario_id":"1","4":"2014-09-11 11:16:02","fec_asig":"2014-09-11 11:16:02","5":null,"fec_resol":null,"6":"122","wf_tarea_id_sig":"122","7":null,"core_usuario_id_resol":null,"8":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_asig":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","9":null,"usr_resol":null} 2015-07 02 09:44:10 cargar datos del sujeto(,,s,59,11596) 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=11596 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(11596,59,) CargarCaso :11596 2015-07 02 09:44:11 CargarDatos: Caso :11596 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":"115224","id":"115224","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"172","wf_paso_id":"172","4":"109250","wf_caso_59_seguimiento_id":"109250","5":"2014-09-11 10:57:19","fecha_ejec":"2014-09-11 10:57:19","6":"1552","dato":"1552","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(1552) se carga 59_105_172_2_2_81 se carga 59_105_172_2_2_10n {"0":"115225","id":"115225","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"174","wf_paso_id":"174","4":"109251","wf_caso_59_seguimiento_id":"109251","5":"2014-09-11 11:04:31","fecha_ejec":"2014-09-11 11:04:31","6":"104663","dato":"104663","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(104663) Documento 104663 Documento 104663 {"0":"115226","id":"115226","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"176","wf_paso_id":"176","4":"109251","wf_caso_59_seguimiento_id":"109251","5":"2014-09-11 11:04:38","fecha_ejec":"2014-09-11 11:04:38","6":"104664","dato":"104664","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(104664) Documento 104664 Documento 104664 {"0":"115227","id":"115227","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"175","wf_paso_id":"175","4":"109251","wf_caso_59_seguimiento_id":"109251","5":"2014-09-11 11:04:44","fecha_ejec":"2014-09-11 11:04:44","6":"104665","dato":"104665","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(104665) Documento 104665 Documento 104665 {"0":"115228","id":"115228","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"177","wf_paso_id":"177","4":"109252","wf_caso_59_seguimiento_id":"109252","5":"2014-09-11 11:08:30","fecha_ejec":"2014-09-11 11:08:30","6":"1527","dato":"1527","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(1527) se carga 59_109_177_4_5_752014-09-10 se carga 59_109_177_4_5_69cafe se carga 59_109_177_4_5_68sacos se carga 59_109_177_4_5_6463350616,7,MARTHA CECILIA VELEZ GIRALDO se carga 59_109_177_4_5_412014-09-11 se carga 59_109_177_4_5_4078789879 se carga 59_109_177_4_5_39897879879879 se carga 59_109_177_4_5_241 se carga 59_109_177_4_5_2250000 se carga 59_109_177_4_5_211000 {"0":"115229","id":"115229","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"182","wf_paso_id":"182","4":"109253","wf_caso_59_seguimiento_id":"109253","5":"2014-09-11 11:09:32","fecha_ejec":"2014-09-11 11:09:32","6":"1526","dato":"1526","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(1526) se carga 59_115_182_6_7_381 se carga 59_115_182_6_7_371 se carga 59_115_182_6_7_32n {"0":"115230","id":"115230","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"192","wf_paso_id":"192","4":"109253","wf_caso_59_seguimiento_id":"109253","5":"2014-09-11 11:10:56","fecha_ejec":"2014-09-11 11:10:56","6":"11383","dato":"11383","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(11383) {"0":"115231","id":"115231","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"184","wf_paso_id":"184","4":"109254","wf_caso_59_seguimiento_id":"109254","5":"2014-09-11 11:14:43","fecha_ejec":"2014-09-11 11:14:43","6":"1535","dato":"1535","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(1535) se carga 59_116_184_8_9_46se encontraron sacos rotos se carga 59_116_184_8_9_4549500 se carga 59_116_184_8_9_443000 se carga 59_116_184_8_9_4352500 {"0":"115232","id":"115232","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"194","wf_paso_id":"194","4":"109254","wf_caso_59_seguimiento_id":"109254","5":"2014-09-11 11:16:02","fecha_ejec":"2014-09-11 11:16:02","6":"11384","dato":"11384","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(11384) 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":"109250","id":"109250","1":"11596","wf_caso_59_id":"11596","2":"105","wf_tarea_id":"105","3":null,"core_usuario_id":null,"4":"2014-09-11 10:56:53","fec_asig":"2014-09-11 10:56:53","5":"2014-09-11 10:57:19","fec_resol":"2014-09-11 10:57:19","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":"109251","id":"109251","1":"11596","wf_caso_59_id":"11596","2":"107","wf_tarea_id":"107","3":"1","core_usuario_id":"1","4":"2014-09-11 10:57:19","fec_asig":"2014-09-11 10:57:19","5":"2014-09-11 11:04:44","fec_resol":"2014-09-11 11:04:44","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":"109252","id":"109252","1":"11596","wf_caso_59_id":"11596","2":"109","wf_tarea_id":"109","3":"1","core_usuario_id":"1","4":"2014-09-11 11:04:44","fec_asig":"2014-09-11 11:04:44","5":"2014-09-11 11:08:30","fec_resol":"2014-09-11 11:08:30","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":"109253","id":"109253","1":"11596","wf_caso_59_id":"11596","2":"115","wf_tarea_id":"115","3":"1","core_usuario_id":"1","4":"2014-09-11 11:08:30","fec_asig":"2014-09-11 11:08:30","5":"2014-09-11 11:10:56","fec_resol":"2014-09-11 11:10:56","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":"109254","id":"109254","1":"11596","wf_caso_59_id":"11596","2":"116","wf_tarea_id":"116","3":"1","core_usuario_id":"1","4":"2014-09-11 11:10:56","fec_asig":"2014-09-11 11:10:56","5":"2014-09-11 11:16:02","fec_resol":"2014-09-11 11:16:02","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":"109255","id":"109255","1":"11596","wf_caso_59_id":"11596","2":"122","wf_tarea_id":"122","3":"1","core_usuario_id":"1","4":"2014-09-11 11:16:02","fec_asig":"2014-09-11 11:16:02","5":null,"fec_resol":null,"6":"122","wf_tarea_id_sig":"122","7":null,"core_usuario_id_resol":null,"8":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_asig":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","9":null,"usr_resol":null} 2015-07 02 09:44:11 cargar datos del sujeto(,,s,59,11596) 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=11596 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:11 tabla dat adic select tabla from core_sujetoverificaciontipo where id=1 2015-07 02 09:44:11 tabla :core_sujetoverificacionstickerentrada SELECT * FROM core_sujetoverificacionstickerentrada where id=11586 fin 2015-07-02 09:44:11 /******************************************************************************************************/ 2015-07-02 09:44:11TraerCaso(11596,59,) CargarCaso :11596 2015-07 02 09:44:11 CargarDatos: Caso :11596 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":"115224","id":"115224","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"172","wf_paso_id":"172","4":"109250","wf_caso_59_seguimiento_id":"109250","5":"2014-09-11 10:57:19","fecha_ejec":"2014-09-11 10:57:19","6":"1552","dato":"1552","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(1552) se carga 59_105_172_2_2_81 se carga 59_105_172_2_2_10n {"0":"115225","id":"115225","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"174","wf_paso_id":"174","4":"109251","wf_caso_59_seguimiento_id":"109251","5":"2014-09-11 11:04:31","fecha_ejec":"2014-09-11 11:04:31","6":"104663","dato":"104663","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(104663) Documento 104663 Documento 104663 {"0":"115226","id":"115226","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"176","wf_paso_id":"176","4":"109251","wf_caso_59_seguimiento_id":"109251","5":"2014-09-11 11:04:38","fecha_ejec":"2014-09-11 11:04:38","6":"104664","dato":"104664","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(104664) Documento 104664 Documento 104664 {"0":"115227","id":"115227","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"175","wf_paso_id":"175","4":"109251","wf_caso_59_seguimiento_id":"109251","5":"2014-09-11 11:04:44","fecha_ejec":"2014-09-11 11:04:44","6":"104665","dato":"104665","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(104665) Documento 104665 Documento 104665 {"0":"115228","id":"115228","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"177","wf_paso_id":"177","4":"109252","wf_caso_59_seguimiento_id":"109252","5":"2014-09-11 11:08:30","fecha_ejec":"2014-09-11 11:08:30","6":"1527","dato":"1527","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(1527) se carga 59_109_177_4_5_752014-09-10 se carga 59_109_177_4_5_69cafe se carga 59_109_177_4_5_68sacos se carga 59_109_177_4_5_6463350616,7,MARTHA CECILIA VELEZ GIRALDO se carga 59_109_177_4_5_412014-09-11 se carga 59_109_177_4_5_4078789879 se carga 59_109_177_4_5_39897879879879 se carga 59_109_177_4_5_241 se carga 59_109_177_4_5_2250000 se carga 59_109_177_4_5_211000 {"0":"115229","id":"115229","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"182","wf_paso_id":"182","4":"109253","wf_caso_59_seguimiento_id":"109253","5":"2014-09-11 11:09:32","fecha_ejec":"2014-09-11 11:09:32","6":"1526","dato":"1526","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(1526) se carga 59_115_182_6_7_381 se carga 59_115_182_6_7_371 se carga 59_115_182_6_7_32n {"0":"115230","id":"115230","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"192","wf_paso_id":"192","4":"109253","wf_caso_59_seguimiento_id":"109253","5":"2014-09-11 11:10:56","fecha_ejec":"2014-09-11 11:10:56","6":"11383","dato":"11383","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(11383) {"0":"115231","id":"115231","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"184","wf_paso_id":"184","4":"109254","wf_caso_59_seguimiento_id":"109254","5":"2014-09-11 11:14:43","fecha_ejec":"2014-09-11 11:14:43","6":"1535","dato":"1535","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(1535) se carga 59_116_184_8_9_46se encontraron sacos rotos se carga 59_116_184_8_9_4549500 se carga 59_116_184_8_9_443000 se carga 59_116_184_8_9_4352500 {"0":"115232","id":"115232","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"194","wf_paso_id":"194","4":"109254","wf_caso_59_seguimiento_id":"109254","5":"2014-09-11 11:16:02","fecha_ejec":"2014-09-11 11:16:02","6":"11384","dato":"11384","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(11384) 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":"109250","id":"109250","1":"11596","wf_caso_59_id":"11596","2":"105","wf_tarea_id":"105","3":null,"core_usuario_id":null,"4":"2014-09-11 10:56:53","fec_asig":"2014-09-11 10:56:53","5":"2014-09-11 10:57:19","fec_resol":"2014-09-11 10:57:19","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":"109251","id":"109251","1":"11596","wf_caso_59_id":"11596","2":"107","wf_tarea_id":"107","3":"1","core_usuario_id":"1","4":"2014-09-11 10:57:19","fec_asig":"2014-09-11 10:57:19","5":"2014-09-11 11:04:44","fec_resol":"2014-09-11 11:04:44","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":"109252","id":"109252","1":"11596","wf_caso_59_id":"11596","2":"109","wf_tarea_id":"109","3":"1","core_usuario_id":"1","4":"2014-09-11 11:04:44","fec_asig":"2014-09-11 11:04:44","5":"2014-09-11 11:08:30","fec_resol":"2014-09-11 11:08:30","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":"109253","id":"109253","1":"11596","wf_caso_59_id":"11596","2":"115","wf_tarea_id":"115","3":"1","core_usuario_id":"1","4":"2014-09-11 11:08:30","fec_asig":"2014-09-11 11:08:30","5":"2014-09-11 11:10:56","fec_resol":"2014-09-11 11:10:56","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":"109254","id":"109254","1":"11596","wf_caso_59_id":"11596","2":"116","wf_tarea_id":"116","3":"1","core_usuario_id":"1","4":"2014-09-11 11:10:56","fec_asig":"2014-09-11 11:10:56","5":"2014-09-11 11:16:02","fec_resol":"2014-09-11 11:16:02","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":"109255","id":"109255","1":"11596","wf_caso_59_id":"11596","2":"122","wf_tarea_id":"122","3":"1","core_usuario_id":"1","4":"2014-09-11 11:16:02","fec_asig":"2014-09-11 11:16:02","5":null,"fec_resol":null,"6":"122","wf_tarea_id_sig":"122","7":null,"core_usuario_id_resol":null,"8":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_asig":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","9":null,"usr_resol":null} 2015-07 02 09:44:11 cargar datos del sujeto(,,s,59,11596) 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=11596 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:11 tabla dat adic select tabla from core_sujetoverificaciontipo where id=1 2015-07 02 09:44:11 tabla :core_sujetoverificacionstickerentrada SELECT * FROM core_sujetoverificacionstickerentrada where id=11586 fin 2015-07-02 09:44:11 /******************************************************************************************************/ 2015-07-02 09:44:11TraerCaso(11596,59,) CargarCaso :11596 2015-07 02 09:44:11 CargarDatos: Caso :11596 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":"115224","id":"115224","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"172","wf_paso_id":"172","4":"109250","wf_caso_59_seguimiento_id":"109250","5":"2014-09-11 10:57:19","fecha_ejec":"2014-09-11 10:57:19","6":"1552","dato":"1552","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(1552) se carga 59_105_172_2_2_81 se carga 59_105_172_2_2_10n {"0":"115225","id":"115225","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"174","wf_paso_id":"174","4":"109251","wf_caso_59_seguimiento_id":"109251","5":"2014-09-11 11:04:31","fecha_ejec":"2014-09-11 11:04:31","6":"104663","dato":"104663","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(104663) Documento 104663 Documento 104663 {"0":"115226","id":"115226","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"176","wf_paso_id":"176","4":"109251","wf_caso_59_seguimiento_id":"109251","5":"2014-09-11 11:04:38","fecha_ejec":"2014-09-11 11:04:38","6":"104664","dato":"104664","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(104664) Documento 104664 Documento 104664 {"0":"115227","id":"115227","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"175","wf_paso_id":"175","4":"109251","wf_caso_59_seguimiento_id":"109251","5":"2014-09-11 11:04:44","fecha_ejec":"2014-09-11 11:04:44","6":"104665","dato":"104665","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(104665) Documento 104665 Documento 104665 {"0":"115228","id":"115228","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"177","wf_paso_id":"177","4":"109252","wf_caso_59_seguimiento_id":"109252","5":"2014-09-11 11:08:30","fecha_ejec":"2014-09-11 11:08:30","6":"1527","dato":"1527","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(1527) se carga 59_109_177_4_5_752014-09-10 se carga 59_109_177_4_5_69cafe se carga 59_109_177_4_5_68sacos se carga 59_109_177_4_5_6463350616,7,MARTHA CECILIA VELEZ GIRALDO se carga 59_109_177_4_5_412014-09-11 se carga 59_109_177_4_5_4078789879 se carga 59_109_177_4_5_39897879879879 se carga 59_109_177_4_5_241 se carga 59_109_177_4_5_2250000 se carga 59_109_177_4_5_211000 {"0":"115229","id":"115229","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"182","wf_paso_id":"182","4":"109253","wf_caso_59_seguimiento_id":"109253","5":"2014-09-11 11:09:32","fecha_ejec":"2014-09-11 11:09:32","6":"1526","dato":"1526","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(1526) se carga 59_115_182_6_7_381 se carga 59_115_182_6_7_371 se carga 59_115_182_6_7_32n {"0":"115230","id":"115230","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"192","wf_paso_id":"192","4":"109253","wf_caso_59_seguimiento_id":"109253","5":"2014-09-11 11:10:56","fecha_ejec":"2014-09-11 11:10:56","6":"11383","dato":"11383","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(11383) {"0":"115231","id":"115231","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"184","wf_paso_id":"184","4":"109254","wf_caso_59_seguimiento_id":"109254","5":"2014-09-11 11:14:43","fecha_ejec":"2014-09-11 11:14:43","6":"1535","dato":"1535","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(1535) se carga 59_116_184_8_9_46se encontraron sacos rotos se carga 59_116_184_8_9_4549500 se carga 59_116_184_8_9_443000 se carga 59_116_184_8_9_4352500 {"0":"115232","id":"115232","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"194","wf_paso_id":"194","4":"109254","wf_caso_59_seguimiento_id":"109254","5":"2014-09-11 11:16:02","fecha_ejec":"2014-09-11 11:16:02","6":"11384","dato":"11384","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(11384) 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":"109250","id":"109250","1":"11596","wf_caso_59_id":"11596","2":"105","wf_tarea_id":"105","3":null,"core_usuario_id":null,"4":"2014-09-11 10:56:53","fec_asig":"2014-09-11 10:56:53","5":"2014-09-11 10:57:19","fec_resol":"2014-09-11 10:57:19","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":"109251","id":"109251","1":"11596","wf_caso_59_id":"11596","2":"107","wf_tarea_id":"107","3":"1","core_usuario_id":"1","4":"2014-09-11 10:57:19","fec_asig":"2014-09-11 10:57:19","5":"2014-09-11 11:04:44","fec_resol":"2014-09-11 11:04:44","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":"109252","id":"109252","1":"11596","wf_caso_59_id":"11596","2":"109","wf_tarea_id":"109","3":"1","core_usuario_id":"1","4":"2014-09-11 11:04:44","fec_asig":"2014-09-11 11:04:44","5":"2014-09-11 11:08:30","fec_resol":"2014-09-11 11:08:30","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":"109253","id":"109253","1":"11596","wf_caso_59_id":"11596","2":"115","wf_tarea_id":"115","3":"1","core_usuario_id":"1","4":"2014-09-11 11:08:30","fec_asig":"2014-09-11 11:08:30","5":"2014-09-11 11:10:56","fec_resol":"2014-09-11 11:10:56","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":"109254","id":"109254","1":"11596","wf_caso_59_id":"11596","2":"116","wf_tarea_id":"116","3":"1","core_usuario_id":"1","4":"2014-09-11 11:10:56","fec_asig":"2014-09-11 11:10:56","5":"2014-09-11 11:16:02","fec_resol":"2014-09-11 11:16:02","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":"109255","id":"109255","1":"11596","wf_caso_59_id":"11596","2":"122","wf_tarea_id":"122","3":"1","core_usuario_id":"1","4":"2014-09-11 11:16:02","fec_asig":"2014-09-11 11:16:02","5":null,"fec_resol":null,"6":"122","wf_tarea_id_sig":"122","7":null,"core_usuario_id_resol":null,"8":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_asig":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","9":null,"usr_resol":null} 2015-07 02 09:44:11 cargar datos del sujeto(,,s,59,11596) 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=11596 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:11 tabla dat adic select tabla from core_sujetoverificaciontipo where id=1 2015-07 02 09:44:11 tabla :core_sujetoverificacionstickerentrada SELECT * FROM core_sujetoverificacionstickerentrada where id=11586 fin 2015-07-02 09:44:11 /******************************************************************************************************/ 2015-07-02 09:44:11TraerCaso(11596,59,) CargarCaso :11596 2015-07 02 09:44:11 CargarDatos: Caso :11596 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":"115224","id":"115224","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"172","wf_paso_id":"172","4":"109250","wf_caso_59_seguimiento_id":"109250","5":"2014-09-11 10:57:19","fecha_ejec":"2014-09-11 10:57:19","6":"1552","dato":"1552","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(1552) se carga 59_105_172_2_2_81 se carga 59_105_172_2_2_10n {"0":"115225","id":"115225","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"174","wf_paso_id":"174","4":"109251","wf_caso_59_seguimiento_id":"109251","5":"2014-09-11 11:04:31","fecha_ejec":"2014-09-11 11:04:31","6":"104663","dato":"104663","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(104663) Documento 104663 Documento 104663 {"0":"115226","id":"115226","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"176","wf_paso_id":"176","4":"109251","wf_caso_59_seguimiento_id":"109251","5":"2014-09-11 11:04:38","fecha_ejec":"2014-09-11 11:04:38","6":"104664","dato":"104664","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(104664) Documento 104664 Documento 104664 {"0":"115227","id":"115227","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"175","wf_paso_id":"175","4":"109251","wf_caso_59_seguimiento_id":"109251","5":"2014-09-11 11:04:44","fecha_ejec":"2014-09-11 11:04:44","6":"104665","dato":"104665","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(104665) Documento 104665 Documento 104665 {"0":"115228","id":"115228","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"177","wf_paso_id":"177","4":"109252","wf_caso_59_seguimiento_id":"109252","5":"2014-09-11 11:08:30","fecha_ejec":"2014-09-11 11:08:30","6":"1527","dato":"1527","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(1527) se carga 59_109_177_4_5_752014-09-10 se carga 59_109_177_4_5_69cafe se carga 59_109_177_4_5_68sacos se carga 59_109_177_4_5_6463350616,7,MARTHA CECILIA VELEZ GIRALDO se carga 59_109_177_4_5_412014-09-11 se carga 59_109_177_4_5_4078789879 se carga 59_109_177_4_5_39897879879879 se carga 59_109_177_4_5_241 se carga 59_109_177_4_5_2250000 se carga 59_109_177_4_5_211000 {"0":"115229","id":"115229","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"182","wf_paso_id":"182","4":"109253","wf_caso_59_seguimiento_id":"109253","5":"2014-09-11 11:09:32","fecha_ejec":"2014-09-11 11:09:32","6":"1526","dato":"1526","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(1526) se carga 59_115_182_6_7_381 se carga 59_115_182_6_7_371 se carga 59_115_182_6_7_32n {"0":"115230","id":"115230","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"192","wf_paso_id":"192","4":"109253","wf_caso_59_seguimiento_id":"109253","5":"2014-09-11 11:10:56","fecha_ejec":"2014-09-11 11:10:56","6":"11383","dato":"11383","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(11383) {"0":"115231","id":"115231","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"184","wf_paso_id":"184","4":"109254","wf_caso_59_seguimiento_id":"109254","5":"2014-09-11 11:14:43","fecha_ejec":"2014-09-11 11:14:43","6":"1535","dato":"1535","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(1535) se carga 59_116_184_8_9_46se encontraron sacos rotos se carga 59_116_184_8_9_4549500 se carga 59_116_184_8_9_443000 se carga 59_116_184_8_9_4352500 {"0":"115232","id":"115232","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"194","wf_paso_id":"194","4":"109254","wf_caso_59_seguimiento_id":"109254","5":"2014-09-11 11:16:02","fecha_ejec":"2014-09-11 11:16:02","6":"11384","dato":"11384","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(11384) 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":"109250","id":"109250","1":"11596","wf_caso_59_id":"11596","2":"105","wf_tarea_id":"105","3":null,"core_usuario_id":null,"4":"2014-09-11 10:56:53","fec_asig":"2014-09-11 10:56:53","5":"2014-09-11 10:57:19","fec_resol":"2014-09-11 10:57:19","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":"109251","id":"109251","1":"11596","wf_caso_59_id":"11596","2":"107","wf_tarea_id":"107","3":"1","core_usuario_id":"1","4":"2014-09-11 10:57:19","fec_asig":"2014-09-11 10:57:19","5":"2014-09-11 11:04:44","fec_resol":"2014-09-11 11:04:44","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":"109252","id":"109252","1":"11596","wf_caso_59_id":"11596","2":"109","wf_tarea_id":"109","3":"1","core_usuario_id":"1","4":"2014-09-11 11:04:44","fec_asig":"2014-09-11 11:04:44","5":"2014-09-11 11:08:30","fec_resol":"2014-09-11 11:08:30","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":"109253","id":"109253","1":"11596","wf_caso_59_id":"11596","2":"115","wf_tarea_id":"115","3":"1","core_usuario_id":"1","4":"2014-09-11 11:08:30","fec_asig":"2014-09-11 11:08:30","5":"2014-09-11 11:10:56","fec_resol":"2014-09-11 11:10:56","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":"109254","id":"109254","1":"11596","wf_caso_59_id":"11596","2":"116","wf_tarea_id":"116","3":"1","core_usuario_id":"1","4":"2014-09-11 11:10:56","fec_asig":"2014-09-11 11:10:56","5":"2014-09-11 11:16:02","fec_resol":"2014-09-11 11:16:02","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":"109255","id":"109255","1":"11596","wf_caso_59_id":"11596","2":"122","wf_tarea_id":"122","3":"1","core_usuario_id":"1","4":"2014-09-11 11:16:02","fec_asig":"2014-09-11 11:16:02","5":null,"fec_resol":null,"6":"122","wf_tarea_id_sig":"122","7":null,"core_usuario_id_resol":null,"8":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_asig":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","9":null,"usr_resol":null} 2015-07 02 09:44:11 cargar datos del sujeto(,,s,59,11596) 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=11596 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:11 tabla dat adic select tabla from core_sujetoverificaciontipo where id=1 2015-07 02 09:44:11 tabla :core_sujetoverificacionstickerentrada SELECT * FROM core_sujetoverificacionstickerentrada where id=11586 fin 2015-07-02 09:44:11 /******************************************************************************************************/ 2015-07-02 09:44:11TraerCaso(11596,59,) CargarCaso :11596 2015-07 02 09:44:11 CargarDatos: Caso :11596 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":"115224","id":"115224","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"172","wf_paso_id":"172","4":"109250","wf_caso_59_seguimiento_id":"109250","5":"2014-09-11 10:57:19","fecha_ejec":"2014-09-11 10:57:19","6":"1552","dato":"1552","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(1552) se carga 59_105_172_2_2_81 se carga 59_105_172_2_2_10n {"0":"115225","id":"115225","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"174","wf_paso_id":"174","4":"109251","wf_caso_59_seguimiento_id":"109251","5":"2014-09-11 11:04:31","fecha_ejec":"2014-09-11 11:04:31","6":"104663","dato":"104663","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(104663) Documento 104663 Documento 104663 {"0":"115226","id":"115226","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"176","wf_paso_id":"176","4":"109251","wf_caso_59_seguimiento_id":"109251","5":"2014-09-11 11:04:38","fecha_ejec":"2014-09-11 11:04:38","6":"104664","dato":"104664","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(104664) Documento 104664 Documento 104664 {"0":"115227","id":"115227","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"175","wf_paso_id":"175","4":"109251","wf_caso_59_seguimiento_id":"109251","5":"2014-09-11 11:04:44","fecha_ejec":"2014-09-11 11:04:44","6":"104665","dato":"104665","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(104665) Documento 104665 Documento 104665 {"0":"115228","id":"115228","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"177","wf_paso_id":"177","4":"109252","wf_caso_59_seguimiento_id":"109252","5":"2014-09-11 11:08:30","fecha_ejec":"2014-09-11 11:08:30","6":"1527","dato":"1527","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(1527) se carga 59_109_177_4_5_752014-09-10 se carga 59_109_177_4_5_69cafe se carga 59_109_177_4_5_68sacos se carga 59_109_177_4_5_6463350616,7,MARTHA CECILIA VELEZ GIRALDO se carga 59_109_177_4_5_412014-09-11 se carga 59_109_177_4_5_4078789879 se carga 59_109_177_4_5_39897879879879 se carga 59_109_177_4_5_241 se carga 59_109_177_4_5_2250000 se carga 59_109_177_4_5_211000 {"0":"115229","id":"115229","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"182","wf_paso_id":"182","4":"109253","wf_caso_59_seguimiento_id":"109253","5":"2014-09-11 11:09:32","fecha_ejec":"2014-09-11 11:09:32","6":"1526","dato":"1526","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(1526) se carga 59_115_182_6_7_381 se carga 59_115_182_6_7_371 se carga 59_115_182_6_7_32n {"0":"115230","id":"115230","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"192","wf_paso_id":"192","4":"109253","wf_caso_59_seguimiento_id":"109253","5":"2014-09-11 11:10:56","fecha_ejec":"2014-09-11 11:10:56","6":"11383","dato":"11383","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(11383) {"0":"115231","id":"115231","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"184","wf_paso_id":"184","4":"109254","wf_caso_59_seguimiento_id":"109254","5":"2014-09-11 11:14:43","fecha_ejec":"2014-09-11 11:14:43","6":"1535","dato":"1535","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(1535) se carga 59_116_184_8_9_46se encontraron sacos rotos se carga 59_116_184_8_9_4549500 se carga 59_116_184_8_9_443000 se carga 59_116_184_8_9_4352500 {"0":"115232","id":"115232","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"194","wf_paso_id":"194","4":"109254","wf_caso_59_seguimiento_id":"109254","5":"2014-09-11 11:16:02","fecha_ejec":"2014-09-11 11:16:02","6":"11384","dato":"11384","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(11384) 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":"109250","id":"109250","1":"11596","wf_caso_59_id":"11596","2":"105","wf_tarea_id":"105","3":null,"core_usuario_id":null,"4":"2014-09-11 10:56:53","fec_asig":"2014-09-11 10:56:53","5":"2014-09-11 10:57:19","fec_resol":"2014-09-11 10:57:19","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":"109251","id":"109251","1":"11596","wf_caso_59_id":"11596","2":"107","wf_tarea_id":"107","3":"1","core_usuario_id":"1","4":"2014-09-11 10:57:19","fec_asig":"2014-09-11 10:57:19","5":"2014-09-11 11:04:44","fec_resol":"2014-09-11 11:04:44","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":"109252","id":"109252","1":"11596","wf_caso_59_id":"11596","2":"109","wf_tarea_id":"109","3":"1","core_usuario_id":"1","4":"2014-09-11 11:04:44","fec_asig":"2014-09-11 11:04:44","5":"2014-09-11 11:08:30","fec_resol":"2014-09-11 11:08:30","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":"109253","id":"109253","1":"11596","wf_caso_59_id":"11596","2":"115","wf_tarea_id":"115","3":"1","core_usuario_id":"1","4":"2014-09-11 11:08:30","fec_asig":"2014-09-11 11:08:30","5":"2014-09-11 11:10:56","fec_resol":"2014-09-11 11:10:56","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":"109254","id":"109254","1":"11596","wf_caso_59_id":"11596","2":"116","wf_tarea_id":"116","3":"1","core_usuario_id":"1","4":"2014-09-11 11:10:56","fec_asig":"2014-09-11 11:10:56","5":"2014-09-11 11:16:02","fec_resol":"2014-09-11 11:16:02","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":"109255","id":"109255","1":"11596","wf_caso_59_id":"11596","2":"122","wf_tarea_id":"122","3":"1","core_usuario_id":"1","4":"2014-09-11 11:16:02","fec_asig":"2014-09-11 11:16:02","5":null,"fec_resol":null,"6":"122","wf_tarea_id_sig":"122","7":null,"core_usuario_id_resol":null,"8":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_asig":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","9":null,"usr_resol":null} 2015-07 02 09:44:11 cargar datos del sujeto(,,s,59,11596) 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=11596 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:11 tabla dat adic select tabla from core_sujetoverificaciontipo where id=1 2015-07 02 09:44:11 tabla :core_sujetoverificacionstickerentrada SELECT * FROM core_sujetoverificacionstickerentrada where id=11586 fin 2015-07-02 09:44:11 /******************************************************************************************************/ 2015-07-02 09:44:11TraerCaso(11596,59,) CargarCaso :11596 2015-07 02 09:44:11 CargarDatos: Caso :11596 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":"115224","id":"115224","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"172","wf_paso_id":"172","4":"109250","wf_caso_59_seguimiento_id":"109250","5":"2014-09-11 10:57:19","fecha_ejec":"2014-09-11 10:57:19","6":"1552","dato":"1552","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(1552) se carga 59_105_172_2_2_81 se carga 59_105_172_2_2_10n {"0":"115225","id":"115225","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"174","wf_paso_id":"174","4":"109251","wf_caso_59_seguimiento_id":"109251","5":"2014-09-11 11:04:31","fecha_ejec":"2014-09-11 11:04:31","6":"104663","dato":"104663","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(104663) Documento 104663 Documento 104663 {"0":"115226","id":"115226","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"176","wf_paso_id":"176","4":"109251","wf_caso_59_seguimiento_id":"109251","5":"2014-09-11 11:04:38","fecha_ejec":"2014-09-11 11:04:38","6":"104664","dato":"104664","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(104664) Documento 104664 Documento 104664 {"0":"115227","id":"115227","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"175","wf_paso_id":"175","4":"109251","wf_caso_59_seguimiento_id":"109251","5":"2014-09-11 11:04:44","fecha_ejec":"2014-09-11 11:04:44","6":"104665","dato":"104665","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(104665) Documento 104665 Documento 104665 {"0":"115228","id":"115228","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"177","wf_paso_id":"177","4":"109252","wf_caso_59_seguimiento_id":"109252","5":"2014-09-11 11:08:30","fecha_ejec":"2014-09-11 11:08:30","6":"1527","dato":"1527","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(1527) se carga 59_109_177_4_5_752014-09-10 se carga 59_109_177_4_5_69cafe se carga 59_109_177_4_5_68sacos se carga 59_109_177_4_5_6463350616,7,MARTHA CECILIA VELEZ GIRALDO se carga 59_109_177_4_5_412014-09-11 se carga 59_109_177_4_5_4078789879 se carga 59_109_177_4_5_39897879879879 se carga 59_109_177_4_5_241 se carga 59_109_177_4_5_2250000 se carga 59_109_177_4_5_211000 {"0":"115229","id":"115229","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"182","wf_paso_id":"182","4":"109253","wf_caso_59_seguimiento_id":"109253","5":"2014-09-11 11:09:32","fecha_ejec":"2014-09-11 11:09:32","6":"1526","dato":"1526","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(1526) se carga 59_115_182_6_7_381 se carga 59_115_182_6_7_371 se carga 59_115_182_6_7_32n {"0":"115230","id":"115230","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"192","wf_paso_id":"192","4":"109253","wf_caso_59_seguimiento_id":"109253","5":"2014-09-11 11:10:56","fecha_ejec":"2014-09-11 11:10:56","6":"11383","dato":"11383","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(11383) {"0":"115231","id":"115231","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"184","wf_paso_id":"184","4":"109254","wf_caso_59_seguimiento_id":"109254","5":"2014-09-11 11:14:43","fecha_ejec":"2014-09-11 11:14:43","6":"1535","dato":"1535","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(1535) se carga 59_116_184_8_9_46se encontraron sacos rotos se carga 59_116_184_8_9_4549500 se carga 59_116_184_8_9_443000 se carga 59_116_184_8_9_4352500 {"0":"115232","id":"115232","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"194","wf_paso_id":"194","4":"109254","wf_caso_59_seguimiento_id":"109254","5":"2014-09-11 11:16:02","fecha_ejec":"2014-09-11 11:16:02","6":"11384","dato":"11384","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(11384) 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":"109250","id":"109250","1":"11596","wf_caso_59_id":"11596","2":"105","wf_tarea_id":"105","3":null,"core_usuario_id":null,"4":"2014-09-11 10:56:53","fec_asig":"2014-09-11 10:56:53","5":"2014-09-11 10:57:19","fec_resol":"2014-09-11 10:57:19","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":"109251","id":"109251","1":"11596","wf_caso_59_id":"11596","2":"107","wf_tarea_id":"107","3":"1","core_usuario_id":"1","4":"2014-09-11 10:57:19","fec_asig":"2014-09-11 10:57:19","5":"2014-09-11 11:04:44","fec_resol":"2014-09-11 11:04:44","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":"109252","id":"109252","1":"11596","wf_caso_59_id":"11596","2":"109","wf_tarea_id":"109","3":"1","core_usuario_id":"1","4":"2014-09-11 11:04:44","fec_asig":"2014-09-11 11:04:44","5":"2014-09-11 11:08:30","fec_resol":"2014-09-11 11:08:30","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":"109253","id":"109253","1":"11596","wf_caso_59_id":"11596","2":"115","wf_tarea_id":"115","3":"1","core_usuario_id":"1","4":"2014-09-11 11:08:30","fec_asig":"2014-09-11 11:08:30","5":"2014-09-11 11:10:56","fec_resol":"2014-09-11 11:10:56","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":"109254","id":"109254","1":"11596","wf_caso_59_id":"11596","2":"116","wf_tarea_id":"116","3":"1","core_usuario_id":"1","4":"2014-09-11 11:10:56","fec_asig":"2014-09-11 11:10:56","5":"2014-09-11 11:16:02","fec_resol":"2014-09-11 11:16:02","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":"109255","id":"109255","1":"11596","wf_caso_59_id":"11596","2":"122","wf_tarea_id":"122","3":"1","core_usuario_id":"1","4":"2014-09-11 11:16:02","fec_asig":"2014-09-11 11:16:02","5":null,"fec_resol":null,"6":"122","wf_tarea_id_sig":"122","7":null,"core_usuario_id_resol":null,"8":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_asig":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","9":null,"usr_resol":null} 2015-07 02 09:44:11 cargar datos del sujeto(,,s,59,11596) 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=11596 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:11 tabla dat adic select tabla from core_sujetoverificaciontipo where id=1 2015-07 02 09:44:11 tabla :core_sujetoverificacionstickerentrada SELECT * FROM core_sujetoverificacionstickerentrada where id=11586 fin 2015-07-02 09:44:11 /******************************************************************************************************/