2015-07-02 09:44:12TraerCaso(11623,59,) CargarCaso :11623 2015-07 02 09:44:12 CargarDatos: Caso :11623 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":"115285","id":"115285","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"172","wf_paso_id":"172","4":"109308","wf_caso_59_seguimiento_id":"109308","5":"2014-09-13 11:11:31","fecha_ejec":"2014-09-13 11:11:31","6":"1579","dato":"1579","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(1579) se carga 59_105_172_2_2_81 se carga 59_105_172_2_2_10bvbvbbvbv {"0":"115286","id":"115286","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"174","wf_paso_id":"174","4":"109309","wf_caso_59_seguimiento_id":"109309","5":"2014-09-13 11:11:42","fecha_ejec":"2014-09-13 11:11:42","6":"104676","dato":"104676","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(104676) Documento 104676 Documento 104676 {"0":"115287","id":"115287","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"176","wf_paso_id":"176","4":"109309","wf_caso_59_seguimiento_id":"109309","5":"2014-09-13 11:11:48","fecha_ejec":"2014-09-13 11:11:48","6":"104677","dato":"104677","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(104677) Documento 104677 Documento 104677 {"0":"115288","id":"115288","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"175","wf_paso_id":"175","4":"109309","wf_caso_59_seguimiento_id":"109309","5":"2014-09-13 11:11:55","fecha_ejec":"2014-09-13 11:11:55","6":"104678","dato":"104678","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(104678) Documento 104678 Documento 104678 {"0":"115289","id":"115289","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"177","wf_paso_id":"177","4":"109310","wf_caso_59_seguimiento_id":"109310","5":"2014-09-13 11:13:05","fecha_ejec":"2014-09-13 11:13:05","6":"1528","dato":"1528","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(1528) se carga 59_109_177_4_5_752014-09-16 se carga 59_109_177_4_5_69azucar se carga 59_109_177_4_5_68tanques se carga 59_109_177_4_5_64110,0,TRANSEUR LTDA. se carga 59_109_177_4_5_412014-09-15 se carga 59_109_177_4_5_405556 se carga 59_109_177_4_5_395555 se carga 59_109_177_4_5_241 se carga 59_109_177_4_5_225000 se carga 59_109_177_4_5_2150 {"0":"115290","id":"115290","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"182","wf_paso_id":"182","4":"109311","wf_caso_59_seguimiento_id":"109311","5":"2014-09-13 11:13:18","fecha_ejec":"2014-09-13 11:13:18","6":"1530","dato":"1530","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(1530) se carga 59_115_182_6_7_381 se carga 59_115_182_6_7_371 se carga 59_115_182_6_7_32bnbnbn {"0":"115291","id":"115291","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"192","wf_paso_id":"192","4":"109311","wf_caso_59_seguimiento_id":"109311","5":"2014-09-13 11:13:31","fecha_ejec":"2014-09-13 11:13:31","6":"11397","dato":"11397","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(11397) {"0":"115292","id":"115292","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"184","wf_paso_id":"184","4":"109312","wf_caso_59_seguimiento_id":"109312","5":"2014-09-13 11:13:55","fecha_ejec":"2014-09-13 11:13:55","6":"1539","dato":"1539","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(1539) se carga 59_116_184_8_9_46nbnbnbn se carga 59_116_184_8_9_455000 se carga 59_116_184_8_9_445 se carga 59_116_184_8_9_435000 {"0":"115293","id":"115293","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"194","wf_paso_id":"194","4":"109312","wf_caso_59_seguimiento_id":"109312","5":"2014-09-13 11:14:06","fecha_ejec":"2014-09-13 11:14:06","6":"11398","dato":"11398","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(11398) 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":"109308","id":"109308","1":"11623","wf_caso_59_id":"11623","2":"105","wf_tarea_id":"105","3":null,"core_usuario_id":null,"4":"2014-09-13 11:11:24","fec_asig":"2014-09-13 11:11:24","5":"2014-09-13 11:11:31","fec_resol":"2014-09-13 11:11:31","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":"109309","id":"109309","1":"11623","wf_caso_59_id":"11623","2":"107","wf_tarea_id":"107","3":"1","core_usuario_id":"1","4":"2014-09-13 11:11:31","fec_asig":"2014-09-13 11:11:31","5":"2014-09-13 11:11:55","fec_resol":"2014-09-13 11:11:55","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":"109310","id":"109310","1":"11623","wf_caso_59_id":"11623","2":"109","wf_tarea_id":"109","3":"1","core_usuario_id":"1","4":"2014-09-13 11:11:55","fec_asig":"2014-09-13 11:11:55","5":"2014-09-13 11:13:05","fec_resol":"2014-09-13 11:13:05","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":"109311","id":"109311","1":"11623","wf_caso_59_id":"11623","2":"115","wf_tarea_id":"115","3":"1","core_usuario_id":"1","4":"2014-09-13 11:13:05","fec_asig":"2014-09-13 11:13:05","5":"2014-09-13 11:13:31","fec_resol":"2014-09-13 11:13:31","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":"109312","id":"109312","1":"11623","wf_caso_59_id":"11623","2":"116","wf_tarea_id":"116","3":"1","core_usuario_id":"1","4":"2014-09-13 11:13:31","fec_asig":"2014-09-13 11:13:31","5":"2014-09-13 11:14:06","fec_resol":"2014-09-13 11:14:06","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":"109313","id":"109313","1":"11623","wf_caso_59_id":"11623","2":"122","wf_tarea_id":"122","3":"1","core_usuario_id":"1","4":"2014-09-13 11:14:06","fec_asig":"2014-09-13 11:14:06","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:12 cargar datos del sujeto(,,s,59,11623) 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=11623 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:12 tabla dat adic select tabla from core_sujetoverificaciontipo where id=1 2015-07 02 09:44:12 tabla :core_sujetoverificacionstickerentrada SELECT * FROM core_sujetoverificacionstickerentrada where id=11549 fin 2015-07-02 09:44:12 /******************************************************************************************************/ 2015-07-02 09:44:12TraerCaso(11623,59,) CargarCaso :11623 2015-07 02 09:44:12 CargarDatos: Caso :11623 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":"115285","id":"115285","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"172","wf_paso_id":"172","4":"109308","wf_caso_59_seguimiento_id":"109308","5":"2014-09-13 11:11:31","fecha_ejec":"2014-09-13 11:11:31","6":"1579","dato":"1579","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(1579) se carga 59_105_172_2_2_81 se carga 59_105_172_2_2_10bvbvbbvbv {"0":"115286","id":"115286","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"174","wf_paso_id":"174","4":"109309","wf_caso_59_seguimiento_id":"109309","5":"2014-09-13 11:11:42","fecha_ejec":"2014-09-13 11:11:42","6":"104676","dato":"104676","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(104676) Documento 104676 Documento 104676 {"0":"115287","id":"115287","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"176","wf_paso_id":"176","4":"109309","wf_caso_59_seguimiento_id":"109309","5":"2014-09-13 11:11:48","fecha_ejec":"2014-09-13 11:11:48","6":"104677","dato":"104677","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(104677) Documento 104677 Documento 104677 {"0":"115288","id":"115288","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"175","wf_paso_id":"175","4":"109309","wf_caso_59_seguimiento_id":"109309","5":"2014-09-13 11:11:55","fecha_ejec":"2014-09-13 11:11:55","6":"104678","dato":"104678","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(104678) Documento 104678 Documento 104678 {"0":"115289","id":"115289","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"177","wf_paso_id":"177","4":"109310","wf_caso_59_seguimiento_id":"109310","5":"2014-09-13 11:13:05","fecha_ejec":"2014-09-13 11:13:05","6":"1528","dato":"1528","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(1528) se carga 59_109_177_4_5_752014-09-16 se carga 59_109_177_4_5_69azucar se carga 59_109_177_4_5_68tanques se carga 59_109_177_4_5_64110,0,TRANSEUR LTDA. se carga 59_109_177_4_5_412014-09-15 se carga 59_109_177_4_5_405556 se carga 59_109_177_4_5_395555 se carga 59_109_177_4_5_241 se carga 59_109_177_4_5_225000 se carga 59_109_177_4_5_2150 {"0":"115290","id":"115290","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"182","wf_paso_id":"182","4":"109311","wf_caso_59_seguimiento_id":"109311","5":"2014-09-13 11:13:18","fecha_ejec":"2014-09-13 11:13:18","6":"1530","dato":"1530","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(1530) se carga 59_115_182_6_7_381 se carga 59_115_182_6_7_371 se carga 59_115_182_6_7_32bnbnbn {"0":"115291","id":"115291","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"192","wf_paso_id":"192","4":"109311","wf_caso_59_seguimiento_id":"109311","5":"2014-09-13 11:13:31","fecha_ejec":"2014-09-13 11:13:31","6":"11397","dato":"11397","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(11397) {"0":"115292","id":"115292","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"184","wf_paso_id":"184","4":"109312","wf_caso_59_seguimiento_id":"109312","5":"2014-09-13 11:13:55","fecha_ejec":"2014-09-13 11:13:55","6":"1539","dato":"1539","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(1539) se carga 59_116_184_8_9_46nbnbnbn se carga 59_116_184_8_9_455000 se carga 59_116_184_8_9_445 se carga 59_116_184_8_9_435000 {"0":"115293","id":"115293","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"194","wf_paso_id":"194","4":"109312","wf_caso_59_seguimiento_id":"109312","5":"2014-09-13 11:14:06","fecha_ejec":"2014-09-13 11:14:06","6":"11398","dato":"11398","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(11398) 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":"109308","id":"109308","1":"11623","wf_caso_59_id":"11623","2":"105","wf_tarea_id":"105","3":null,"core_usuario_id":null,"4":"2014-09-13 11:11:24","fec_asig":"2014-09-13 11:11:24","5":"2014-09-13 11:11:31","fec_resol":"2014-09-13 11:11:31","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":"109309","id":"109309","1":"11623","wf_caso_59_id":"11623","2":"107","wf_tarea_id":"107","3":"1","core_usuario_id":"1","4":"2014-09-13 11:11:31","fec_asig":"2014-09-13 11:11:31","5":"2014-09-13 11:11:55","fec_resol":"2014-09-13 11:11:55","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":"109310","id":"109310","1":"11623","wf_caso_59_id":"11623","2":"109","wf_tarea_id":"109","3":"1","core_usuario_id":"1","4":"2014-09-13 11:11:55","fec_asig":"2014-09-13 11:11:55","5":"2014-09-13 11:13:05","fec_resol":"2014-09-13 11:13:05","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":"109311","id":"109311","1":"11623","wf_caso_59_id":"11623","2":"115","wf_tarea_id":"115","3":"1","core_usuario_id":"1","4":"2014-09-13 11:13:05","fec_asig":"2014-09-13 11:13:05","5":"2014-09-13 11:13:31","fec_resol":"2014-09-13 11:13:31","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":"109312","id":"109312","1":"11623","wf_caso_59_id":"11623","2":"116","wf_tarea_id":"116","3":"1","core_usuario_id":"1","4":"2014-09-13 11:13:31","fec_asig":"2014-09-13 11:13:31","5":"2014-09-13 11:14:06","fec_resol":"2014-09-13 11:14:06","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":"109313","id":"109313","1":"11623","wf_caso_59_id":"11623","2":"122","wf_tarea_id":"122","3":"1","core_usuario_id":"1","4":"2014-09-13 11:14:06","fec_asig":"2014-09-13 11:14:06","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:12 cargar datos del sujeto(,,s,59,11623) 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=11623 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:12 tabla dat adic select tabla from core_sujetoverificaciontipo where id=1 2015-07 02 09:44:12 tabla :core_sujetoverificacionstickerentrada SELECT * FROM core_sujetoverificacionstickerentrada where id=11549 fin 2015-07-02 09:44:12 /******************************************************************************************************/ 2015-07-02 09:44:12TraerCaso(11623,59,) CargarCaso :11623 2015-07 02 09:44:12 CargarDatos: Caso :11623 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":"115285","id":"115285","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"172","wf_paso_id":"172","4":"109308","wf_caso_59_seguimiento_id":"109308","5":"2014-09-13 11:11:31","fecha_ejec":"2014-09-13 11:11:31","6":"1579","dato":"1579","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(1579) se carga 59_105_172_2_2_81 se carga 59_105_172_2_2_10bvbvbbvbv {"0":"115286","id":"115286","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"174","wf_paso_id":"174","4":"109309","wf_caso_59_seguimiento_id":"109309","5":"2014-09-13 11:11:42","fecha_ejec":"2014-09-13 11:11:42","6":"104676","dato":"104676","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(104676) Documento 104676 Documento 104676 {"0":"115287","id":"115287","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"176","wf_paso_id":"176","4":"109309","wf_caso_59_seguimiento_id":"109309","5":"2014-09-13 11:11:48","fecha_ejec":"2014-09-13 11:11:48","6":"104677","dato":"104677","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(104677) Documento 104677 Documento 104677 {"0":"115288","id":"115288","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"175","wf_paso_id":"175","4":"109309","wf_caso_59_seguimiento_id":"109309","5":"2014-09-13 11:11:55","fecha_ejec":"2014-09-13 11:11:55","6":"104678","dato":"104678","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(104678) Documento 104678 Documento 104678 {"0":"115289","id":"115289","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"177","wf_paso_id":"177","4":"109310","wf_caso_59_seguimiento_id":"109310","5":"2014-09-13 11:13:05","fecha_ejec":"2014-09-13 11:13:05","6":"1528","dato":"1528","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(1528) se carga 59_109_177_4_5_752014-09-16 se carga 59_109_177_4_5_69azucar se carga 59_109_177_4_5_68tanques se carga 59_109_177_4_5_64110,0,TRANSEUR LTDA. se carga 59_109_177_4_5_412014-09-15 se carga 59_109_177_4_5_405556 se carga 59_109_177_4_5_395555 se carga 59_109_177_4_5_241 se carga 59_109_177_4_5_225000 se carga 59_109_177_4_5_2150 {"0":"115290","id":"115290","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"182","wf_paso_id":"182","4":"109311","wf_caso_59_seguimiento_id":"109311","5":"2014-09-13 11:13:18","fecha_ejec":"2014-09-13 11:13:18","6":"1530","dato":"1530","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(1530) se carga 59_115_182_6_7_381 se carga 59_115_182_6_7_371 se carga 59_115_182_6_7_32bnbnbn {"0":"115291","id":"115291","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"192","wf_paso_id":"192","4":"109311","wf_caso_59_seguimiento_id":"109311","5":"2014-09-13 11:13:31","fecha_ejec":"2014-09-13 11:13:31","6":"11397","dato":"11397","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(11397) {"0":"115292","id":"115292","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"184","wf_paso_id":"184","4":"109312","wf_caso_59_seguimiento_id":"109312","5":"2014-09-13 11:13:55","fecha_ejec":"2014-09-13 11:13:55","6":"1539","dato":"1539","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(1539) se carga 59_116_184_8_9_46nbnbnbn se carga 59_116_184_8_9_455000 se carga 59_116_184_8_9_445 se carga 59_116_184_8_9_435000 {"0":"115293","id":"115293","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"194","wf_paso_id":"194","4":"109312","wf_caso_59_seguimiento_id":"109312","5":"2014-09-13 11:14:06","fecha_ejec":"2014-09-13 11:14:06","6":"11398","dato":"11398","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(11398) 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":"109308","id":"109308","1":"11623","wf_caso_59_id":"11623","2":"105","wf_tarea_id":"105","3":null,"core_usuario_id":null,"4":"2014-09-13 11:11:24","fec_asig":"2014-09-13 11:11:24","5":"2014-09-13 11:11:31","fec_resol":"2014-09-13 11:11:31","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":"109309","id":"109309","1":"11623","wf_caso_59_id":"11623","2":"107","wf_tarea_id":"107","3":"1","core_usuario_id":"1","4":"2014-09-13 11:11:31","fec_asig":"2014-09-13 11:11:31","5":"2014-09-13 11:11:55","fec_resol":"2014-09-13 11:11:55","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":"109310","id":"109310","1":"11623","wf_caso_59_id":"11623","2":"109","wf_tarea_id":"109","3":"1","core_usuario_id":"1","4":"2014-09-13 11:11:55","fec_asig":"2014-09-13 11:11:55","5":"2014-09-13 11:13:05","fec_resol":"2014-09-13 11:13:05","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":"109311","id":"109311","1":"11623","wf_caso_59_id":"11623","2":"115","wf_tarea_id":"115","3":"1","core_usuario_id":"1","4":"2014-09-13 11:13:05","fec_asig":"2014-09-13 11:13:05","5":"2014-09-13 11:13:31","fec_resol":"2014-09-13 11:13:31","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":"109312","id":"109312","1":"11623","wf_caso_59_id":"11623","2":"116","wf_tarea_id":"116","3":"1","core_usuario_id":"1","4":"2014-09-13 11:13:31","fec_asig":"2014-09-13 11:13:31","5":"2014-09-13 11:14:06","fec_resol":"2014-09-13 11:14:06","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":"109313","id":"109313","1":"11623","wf_caso_59_id":"11623","2":"122","wf_tarea_id":"122","3":"1","core_usuario_id":"1","4":"2014-09-13 11:14:06","fec_asig":"2014-09-13 11:14:06","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:12 cargar datos del sujeto(,,s,59,11623) 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=11623 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:12 tabla dat adic select tabla from core_sujetoverificaciontipo where id=1 2015-07 02 09:44:12 tabla :core_sujetoverificacionstickerentrada SELECT * FROM core_sujetoverificacionstickerentrada where id=11549 fin 2015-07-02 09:44:12 /******************************************************************************************************/ 2015-07-02 09:44:12TraerCaso(11623,59,) CargarCaso :11623 2015-07 02 09:44:12 CargarDatos: Caso :11623 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":"115285","id":"115285","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"172","wf_paso_id":"172","4":"109308","wf_caso_59_seguimiento_id":"109308","5":"2014-09-13 11:11:31","fecha_ejec":"2014-09-13 11:11:31","6":"1579","dato":"1579","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(1579) se carga 59_105_172_2_2_81 se carga 59_105_172_2_2_10bvbvbbvbv {"0":"115286","id":"115286","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"174","wf_paso_id":"174","4":"109309","wf_caso_59_seguimiento_id":"109309","5":"2014-09-13 11:11:42","fecha_ejec":"2014-09-13 11:11:42","6":"104676","dato":"104676","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(104676) Documento 104676 Documento 104676 {"0":"115287","id":"115287","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"176","wf_paso_id":"176","4":"109309","wf_caso_59_seguimiento_id":"109309","5":"2014-09-13 11:11:48","fecha_ejec":"2014-09-13 11:11:48","6":"104677","dato":"104677","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(104677) Documento 104677 Documento 104677 {"0":"115288","id":"115288","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"175","wf_paso_id":"175","4":"109309","wf_caso_59_seguimiento_id":"109309","5":"2014-09-13 11:11:55","fecha_ejec":"2014-09-13 11:11:55","6":"104678","dato":"104678","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(104678) Documento 104678 Documento 104678 {"0":"115289","id":"115289","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"177","wf_paso_id":"177","4":"109310","wf_caso_59_seguimiento_id":"109310","5":"2014-09-13 11:13:05","fecha_ejec":"2014-09-13 11:13:05","6":"1528","dato":"1528","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(1528) se carga 59_109_177_4_5_752014-09-16 se carga 59_109_177_4_5_69azucar se carga 59_109_177_4_5_68tanques se carga 59_109_177_4_5_64110,0,TRANSEUR LTDA. se carga 59_109_177_4_5_412014-09-15 se carga 59_109_177_4_5_405556 se carga 59_109_177_4_5_395555 se carga 59_109_177_4_5_241 se carga 59_109_177_4_5_225000 se carga 59_109_177_4_5_2150 {"0":"115290","id":"115290","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"182","wf_paso_id":"182","4":"109311","wf_caso_59_seguimiento_id":"109311","5":"2014-09-13 11:13:18","fecha_ejec":"2014-09-13 11:13:18","6":"1530","dato":"1530","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(1530) se carga 59_115_182_6_7_381 se carga 59_115_182_6_7_371 se carga 59_115_182_6_7_32bnbnbn {"0":"115291","id":"115291","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"192","wf_paso_id":"192","4":"109311","wf_caso_59_seguimiento_id":"109311","5":"2014-09-13 11:13:31","fecha_ejec":"2014-09-13 11:13:31","6":"11397","dato":"11397","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(11397) {"0":"115292","id":"115292","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"184","wf_paso_id":"184","4":"109312","wf_caso_59_seguimiento_id":"109312","5":"2014-09-13 11:13:55","fecha_ejec":"2014-09-13 11:13:55","6":"1539","dato":"1539","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(1539) se carga 59_116_184_8_9_46nbnbnbn se carga 59_116_184_8_9_455000 se carga 59_116_184_8_9_445 se carga 59_116_184_8_9_435000 {"0":"115293","id":"115293","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"194","wf_paso_id":"194","4":"109312","wf_caso_59_seguimiento_id":"109312","5":"2014-09-13 11:14:06","fecha_ejec":"2014-09-13 11:14:06","6":"11398","dato":"11398","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(11398) 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":"109308","id":"109308","1":"11623","wf_caso_59_id":"11623","2":"105","wf_tarea_id":"105","3":null,"core_usuario_id":null,"4":"2014-09-13 11:11:24","fec_asig":"2014-09-13 11:11:24","5":"2014-09-13 11:11:31","fec_resol":"2014-09-13 11:11:31","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":"109309","id":"109309","1":"11623","wf_caso_59_id":"11623","2":"107","wf_tarea_id":"107","3":"1","core_usuario_id":"1","4":"2014-09-13 11:11:31","fec_asig":"2014-09-13 11:11:31","5":"2014-09-13 11:11:55","fec_resol":"2014-09-13 11:11:55","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":"109310","id":"109310","1":"11623","wf_caso_59_id":"11623","2":"109","wf_tarea_id":"109","3":"1","core_usuario_id":"1","4":"2014-09-13 11:11:55","fec_asig":"2014-09-13 11:11:55","5":"2014-09-13 11:13:05","fec_resol":"2014-09-13 11:13:05","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":"109311","id":"109311","1":"11623","wf_caso_59_id":"11623","2":"115","wf_tarea_id":"115","3":"1","core_usuario_id":"1","4":"2014-09-13 11:13:05","fec_asig":"2014-09-13 11:13:05","5":"2014-09-13 11:13:31","fec_resol":"2014-09-13 11:13:31","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":"109312","id":"109312","1":"11623","wf_caso_59_id":"11623","2":"116","wf_tarea_id":"116","3":"1","core_usuario_id":"1","4":"2014-09-13 11:13:31","fec_asig":"2014-09-13 11:13:31","5":"2014-09-13 11:14:06","fec_resol":"2014-09-13 11:14:06","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":"109313","id":"109313","1":"11623","wf_caso_59_id":"11623","2":"122","wf_tarea_id":"122","3":"1","core_usuario_id":"1","4":"2014-09-13 11:14:06","fec_asig":"2014-09-13 11:14:06","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:12 cargar datos del sujeto(,,s,59,11623) 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=11623 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:12 tabla dat adic select tabla from core_sujetoverificaciontipo where id=1 2015-07 02 09:44:12 tabla :core_sujetoverificacionstickerentrada SELECT * FROM core_sujetoverificacionstickerentrada where id=11549 fin 2015-07-02 09:44:12 /******************************************************************************************************/ 2015-07-02 09:44:12TraerCaso(11623,59,) CargarCaso :11623 2015-07 02 09:44:12 CargarDatos: Caso :11623 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":"115285","id":"115285","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"172","wf_paso_id":"172","4":"109308","wf_caso_59_seguimiento_id":"109308","5":"2014-09-13 11:11:31","fecha_ejec":"2014-09-13 11:11:31","6":"1579","dato":"1579","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(1579) se carga 59_105_172_2_2_81 se carga 59_105_172_2_2_10bvbvbbvbv {"0":"115286","id":"115286","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"174","wf_paso_id":"174","4":"109309","wf_caso_59_seguimiento_id":"109309","5":"2014-09-13 11:11:42","fecha_ejec":"2014-09-13 11:11:42","6":"104676","dato":"104676","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(104676) Documento 104676 Documento 104676 {"0":"115287","id":"115287","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"176","wf_paso_id":"176","4":"109309","wf_caso_59_seguimiento_id":"109309","5":"2014-09-13 11:11:48","fecha_ejec":"2014-09-13 11:11:48","6":"104677","dato":"104677","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(104677) Documento 104677 Documento 104677 {"0":"115288","id":"115288","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"175","wf_paso_id":"175","4":"109309","wf_caso_59_seguimiento_id":"109309","5":"2014-09-13 11:11:55","fecha_ejec":"2014-09-13 11:11:55","6":"104678","dato":"104678","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(104678) Documento 104678 Documento 104678 {"0":"115289","id":"115289","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"177","wf_paso_id":"177","4":"109310","wf_caso_59_seguimiento_id":"109310","5":"2014-09-13 11:13:05","fecha_ejec":"2014-09-13 11:13:05","6":"1528","dato":"1528","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(1528) se carga 59_109_177_4_5_752014-09-16 se carga 59_109_177_4_5_69azucar se carga 59_109_177_4_5_68tanques se carga 59_109_177_4_5_64110,0,TRANSEUR LTDA. se carga 59_109_177_4_5_412014-09-15 se carga 59_109_177_4_5_405556 se carga 59_109_177_4_5_395555 se carga 59_109_177_4_5_241 se carga 59_109_177_4_5_225000 se carga 59_109_177_4_5_2150 {"0":"115290","id":"115290","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"182","wf_paso_id":"182","4":"109311","wf_caso_59_seguimiento_id":"109311","5":"2014-09-13 11:13:18","fecha_ejec":"2014-09-13 11:13:18","6":"1530","dato":"1530","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(1530) se carga 59_115_182_6_7_381 se carga 59_115_182_6_7_371 se carga 59_115_182_6_7_32bnbnbn {"0":"115291","id":"115291","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"192","wf_paso_id":"192","4":"109311","wf_caso_59_seguimiento_id":"109311","5":"2014-09-13 11:13:31","fecha_ejec":"2014-09-13 11:13:31","6":"11397","dato":"11397","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(11397) {"0":"115292","id":"115292","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"184","wf_paso_id":"184","4":"109312","wf_caso_59_seguimiento_id":"109312","5":"2014-09-13 11:13:55","fecha_ejec":"2014-09-13 11:13:55","6":"1539","dato":"1539","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(1539) se carga 59_116_184_8_9_46nbnbnbn se carga 59_116_184_8_9_455000 se carga 59_116_184_8_9_445 se carga 59_116_184_8_9_435000 {"0":"115293","id":"115293","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"194","wf_paso_id":"194","4":"109312","wf_caso_59_seguimiento_id":"109312","5":"2014-09-13 11:14:06","fecha_ejec":"2014-09-13 11:14:06","6":"11398","dato":"11398","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(11398) 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":"109308","id":"109308","1":"11623","wf_caso_59_id":"11623","2":"105","wf_tarea_id":"105","3":null,"core_usuario_id":null,"4":"2014-09-13 11:11:24","fec_asig":"2014-09-13 11:11:24","5":"2014-09-13 11:11:31","fec_resol":"2014-09-13 11:11:31","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":"109309","id":"109309","1":"11623","wf_caso_59_id":"11623","2":"107","wf_tarea_id":"107","3":"1","core_usuario_id":"1","4":"2014-09-13 11:11:31","fec_asig":"2014-09-13 11:11:31","5":"2014-09-13 11:11:55","fec_resol":"2014-09-13 11:11:55","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":"109310","id":"109310","1":"11623","wf_caso_59_id":"11623","2":"109","wf_tarea_id":"109","3":"1","core_usuario_id":"1","4":"2014-09-13 11:11:55","fec_asig":"2014-09-13 11:11:55","5":"2014-09-13 11:13:05","fec_resol":"2014-09-13 11:13:05","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":"109311","id":"109311","1":"11623","wf_caso_59_id":"11623","2":"115","wf_tarea_id":"115","3":"1","core_usuario_id":"1","4":"2014-09-13 11:13:05","fec_asig":"2014-09-13 11:13:05","5":"2014-09-13 11:13:31","fec_resol":"2014-09-13 11:13:31","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":"109312","id":"109312","1":"11623","wf_caso_59_id":"11623","2":"116","wf_tarea_id":"116","3":"1","core_usuario_id":"1","4":"2014-09-13 11:13:31","fec_asig":"2014-09-13 11:13:31","5":"2014-09-13 11:14:06","fec_resol":"2014-09-13 11:14:06","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":"109313","id":"109313","1":"11623","wf_caso_59_id":"11623","2":"122","wf_tarea_id":"122","3":"1","core_usuario_id":"1","4":"2014-09-13 11:14:06","fec_asig":"2014-09-13 11:14:06","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:12 cargar datos del sujeto(,,s,59,11623) 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=11623 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:12 tabla dat adic select tabla from core_sujetoverificaciontipo where id=1 2015-07 02 09:44:12 tabla :core_sujetoverificacionstickerentrada SELECT * FROM core_sujetoverificacionstickerentrada where id=11549 fin 2015-07-02 09:44:12 /******************************************************************************************************/ 2015-07-02 09:44:12TraerCaso(11623,59,) CargarCaso :11623 2015-07 02 09:44:12 CargarDatos: Caso :11623 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":"115285","id":"115285","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"172","wf_paso_id":"172","4":"109308","wf_caso_59_seguimiento_id":"109308","5":"2014-09-13 11:11:31","fecha_ejec":"2014-09-13 11:11:31","6":"1579","dato":"1579","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(1579) se carga 59_105_172_2_2_81 se carga 59_105_172_2_2_10bvbvbbvbv {"0":"115286","id":"115286","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"174","wf_paso_id":"174","4":"109309","wf_caso_59_seguimiento_id":"109309","5":"2014-09-13 11:11:42","fecha_ejec":"2014-09-13 11:11:42","6":"104676","dato":"104676","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(104676) Documento 104676 Documento 104676 {"0":"115287","id":"115287","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"176","wf_paso_id":"176","4":"109309","wf_caso_59_seguimiento_id":"109309","5":"2014-09-13 11:11:48","fecha_ejec":"2014-09-13 11:11:48","6":"104677","dato":"104677","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(104677) Documento 104677 Documento 104677 {"0":"115288","id":"115288","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"175","wf_paso_id":"175","4":"109309","wf_caso_59_seguimiento_id":"109309","5":"2014-09-13 11:11:55","fecha_ejec":"2014-09-13 11:11:55","6":"104678","dato":"104678","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(104678) Documento 104678 Documento 104678 {"0":"115289","id":"115289","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"177","wf_paso_id":"177","4":"109310","wf_caso_59_seguimiento_id":"109310","5":"2014-09-13 11:13:05","fecha_ejec":"2014-09-13 11:13:05","6":"1528","dato":"1528","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(1528) se carga 59_109_177_4_5_752014-09-16 se carga 59_109_177_4_5_69azucar se carga 59_109_177_4_5_68tanques se carga 59_109_177_4_5_64110,0,TRANSEUR LTDA. se carga 59_109_177_4_5_412014-09-15 se carga 59_109_177_4_5_405556 se carga 59_109_177_4_5_395555 se carga 59_109_177_4_5_241 se carga 59_109_177_4_5_225000 se carga 59_109_177_4_5_2150 {"0":"115290","id":"115290","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"182","wf_paso_id":"182","4":"109311","wf_caso_59_seguimiento_id":"109311","5":"2014-09-13 11:13:18","fecha_ejec":"2014-09-13 11:13:18","6":"1530","dato":"1530","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(1530) se carga 59_115_182_6_7_381 se carga 59_115_182_6_7_371 se carga 59_115_182_6_7_32bnbnbn {"0":"115291","id":"115291","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"192","wf_paso_id":"192","4":"109311","wf_caso_59_seguimiento_id":"109311","5":"2014-09-13 11:13:31","fecha_ejec":"2014-09-13 11:13:31","6":"11397","dato":"11397","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(11397) {"0":"115292","id":"115292","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"184","wf_paso_id":"184","4":"109312","wf_caso_59_seguimiento_id":"109312","5":"2014-09-13 11:13:55","fecha_ejec":"2014-09-13 11:13:55","6":"1539","dato":"1539","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(1539) se carga 59_116_184_8_9_46nbnbnbn se carga 59_116_184_8_9_455000 se carga 59_116_184_8_9_445 se carga 59_116_184_8_9_435000 {"0":"115293","id":"115293","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"194","wf_paso_id":"194","4":"109312","wf_caso_59_seguimiento_id":"109312","5":"2014-09-13 11:14:06","fecha_ejec":"2014-09-13 11:14:06","6":"11398","dato":"11398","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(11398) 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":"109308","id":"109308","1":"11623","wf_caso_59_id":"11623","2":"105","wf_tarea_id":"105","3":null,"core_usuario_id":null,"4":"2014-09-13 11:11:24","fec_asig":"2014-09-13 11:11:24","5":"2014-09-13 11:11:31","fec_resol":"2014-09-13 11:11:31","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":"109309","id":"109309","1":"11623","wf_caso_59_id":"11623","2":"107","wf_tarea_id":"107","3":"1","core_usuario_id":"1","4":"2014-09-13 11:11:31","fec_asig":"2014-09-13 11:11:31","5":"2014-09-13 11:11:55","fec_resol":"2014-09-13 11:11:55","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":"109310","id":"109310","1":"11623","wf_caso_59_id":"11623","2":"109","wf_tarea_id":"109","3":"1","core_usuario_id":"1","4":"2014-09-13 11:11:55","fec_asig":"2014-09-13 11:11:55","5":"2014-09-13 11:13:05","fec_resol":"2014-09-13 11:13:05","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":"109311","id":"109311","1":"11623","wf_caso_59_id":"11623","2":"115","wf_tarea_id":"115","3":"1","core_usuario_id":"1","4":"2014-09-13 11:13:05","fec_asig":"2014-09-13 11:13:05","5":"2014-09-13 11:13:31","fec_resol":"2014-09-13 11:13:31","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":"109312","id":"109312","1":"11623","wf_caso_59_id":"11623","2":"116","wf_tarea_id":"116","3":"1","core_usuario_id":"1","4":"2014-09-13 11:13:31","fec_asig":"2014-09-13 11:13:31","5":"2014-09-13 11:14:06","fec_resol":"2014-09-13 11:14:06","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":"109313","id":"109313","1":"11623","wf_caso_59_id":"11623","2":"122","wf_tarea_id":"122","3":"1","core_usuario_id":"1","4":"2014-09-13 11:14:06","fec_asig":"2014-09-13 11:14:06","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:12 cargar datos del sujeto(,,s,59,11623) 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=11623 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:12 tabla dat adic select tabla from core_sujetoverificaciontipo where id=1 2015-07 02 09:44:12 tabla :core_sujetoverificacionstickerentrada SELECT * FROM core_sujetoverificacionstickerentrada where id=11549 fin 2015-07-02 09:44:12 /******************************************************************************************************/ 2015-07-02 09:44:12TraerCaso(11623,59,) CargarCaso :11623 2015-07 02 09:44:12 CargarDatos: Caso :11623 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":"115285","id":"115285","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"172","wf_paso_id":"172","4":"109308","wf_caso_59_seguimiento_id":"109308","5":"2014-09-13 11:11:31","fecha_ejec":"2014-09-13 11:11:31","6":"1579","dato":"1579","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(1579) se carga 59_105_172_2_2_81 se carga 59_105_172_2_2_10bvbvbbvbv {"0":"115286","id":"115286","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"174","wf_paso_id":"174","4":"109309","wf_caso_59_seguimiento_id":"109309","5":"2014-09-13 11:11:42","fecha_ejec":"2014-09-13 11:11:42","6":"104676","dato":"104676","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(104676) Documento 104676 Documento 104676 {"0":"115287","id":"115287","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"176","wf_paso_id":"176","4":"109309","wf_caso_59_seguimiento_id":"109309","5":"2014-09-13 11:11:48","fecha_ejec":"2014-09-13 11:11:48","6":"104677","dato":"104677","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(104677) Documento 104677 Documento 104677 {"0":"115288","id":"115288","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"175","wf_paso_id":"175","4":"109309","wf_caso_59_seguimiento_id":"109309","5":"2014-09-13 11:11:55","fecha_ejec":"2014-09-13 11:11:55","6":"104678","dato":"104678","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(104678) Documento 104678 Documento 104678 {"0":"115289","id":"115289","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"177","wf_paso_id":"177","4":"109310","wf_caso_59_seguimiento_id":"109310","5":"2014-09-13 11:13:05","fecha_ejec":"2014-09-13 11:13:05","6":"1528","dato":"1528","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(1528) se carga 59_109_177_4_5_752014-09-16 se carga 59_109_177_4_5_69azucar se carga 59_109_177_4_5_68tanques se carga 59_109_177_4_5_64110,0,TRANSEUR LTDA. se carga 59_109_177_4_5_412014-09-15 se carga 59_109_177_4_5_405556 se carga 59_109_177_4_5_395555 se carga 59_109_177_4_5_241 se carga 59_109_177_4_5_225000 se carga 59_109_177_4_5_2150 {"0":"115290","id":"115290","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"182","wf_paso_id":"182","4":"109311","wf_caso_59_seguimiento_id":"109311","5":"2014-09-13 11:13:18","fecha_ejec":"2014-09-13 11:13:18","6":"1530","dato":"1530","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(1530) se carga 59_115_182_6_7_381 se carga 59_115_182_6_7_371 se carga 59_115_182_6_7_32bnbnbn {"0":"115291","id":"115291","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"192","wf_paso_id":"192","4":"109311","wf_caso_59_seguimiento_id":"109311","5":"2014-09-13 11:13:31","fecha_ejec":"2014-09-13 11:13:31","6":"11397","dato":"11397","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(11397) {"0":"115292","id":"115292","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"184","wf_paso_id":"184","4":"109312","wf_caso_59_seguimiento_id":"109312","5":"2014-09-13 11:13:55","fecha_ejec":"2014-09-13 11:13:55","6":"1539","dato":"1539","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(1539) se carga 59_116_184_8_9_46nbnbnbn se carga 59_116_184_8_9_455000 se carga 59_116_184_8_9_445 se carga 59_116_184_8_9_435000 {"0":"115293","id":"115293","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"194","wf_paso_id":"194","4":"109312","wf_caso_59_seguimiento_id":"109312","5":"2014-09-13 11:14:06","fecha_ejec":"2014-09-13 11:14:06","6":"11398","dato":"11398","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(11398) 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":"109308","id":"109308","1":"11623","wf_caso_59_id":"11623","2":"105","wf_tarea_id":"105","3":null,"core_usuario_id":null,"4":"2014-09-13 11:11:24","fec_asig":"2014-09-13 11:11:24","5":"2014-09-13 11:11:31","fec_resol":"2014-09-13 11:11:31","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":"109309","id":"109309","1":"11623","wf_caso_59_id":"11623","2":"107","wf_tarea_id":"107","3":"1","core_usuario_id":"1","4":"2014-09-13 11:11:31","fec_asig":"2014-09-13 11:11:31","5":"2014-09-13 11:11:55","fec_resol":"2014-09-13 11:11:55","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":"109310","id":"109310","1":"11623","wf_caso_59_id":"11623","2":"109","wf_tarea_id":"109","3":"1","core_usuario_id":"1","4":"2014-09-13 11:11:55","fec_asig":"2014-09-13 11:11:55","5":"2014-09-13 11:13:05","fec_resol":"2014-09-13 11:13:05","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":"109311","id":"109311","1":"11623","wf_caso_59_id":"11623","2":"115","wf_tarea_id":"115","3":"1","core_usuario_id":"1","4":"2014-09-13 11:13:05","fec_asig":"2014-09-13 11:13:05","5":"2014-09-13 11:13:31","fec_resol":"2014-09-13 11:13:31","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":"109312","id":"109312","1":"11623","wf_caso_59_id":"11623","2":"116","wf_tarea_id":"116","3":"1","core_usuario_id":"1","4":"2014-09-13 11:13:31","fec_asig":"2014-09-13 11:13:31","5":"2014-09-13 11:14:06","fec_resol":"2014-09-13 11:14:06","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":"109313","id":"109313","1":"11623","wf_caso_59_id":"11623","2":"122","wf_tarea_id":"122","3":"1","core_usuario_id":"1","4":"2014-09-13 11:14:06","fec_asig":"2014-09-13 11:14:06","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:12 cargar datos del sujeto(,,s,59,11623) 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=11623 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:12 tabla dat adic select tabla from core_sujetoverificaciontipo where id=1 2015-07 02 09:44:12 tabla :core_sujetoverificacionstickerentrada SELECT * FROM core_sujetoverificacionstickerentrada where id=11549 fin 2015-07-02 09:44:12 /******************************************************************************************************/ 2015-07-02 09:44:12TraerCaso(11623,59,) CargarCaso :11623 2015-07 02 09:44:12 CargarDatos: Caso :11623 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":"115285","id":"115285","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"172","wf_paso_id":"172","4":"109308","wf_caso_59_seguimiento_id":"109308","5":"2014-09-13 11:11:31","fecha_ejec":"2014-09-13 11:11:31","6":"1579","dato":"1579","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(1579) se carga 59_105_172_2_2_81 se carga 59_105_172_2_2_10bvbvbbvbv {"0":"115286","id":"115286","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"174","wf_paso_id":"174","4":"109309","wf_caso_59_seguimiento_id":"109309","5":"2014-09-13 11:11:42","fecha_ejec":"2014-09-13 11:11:42","6":"104676","dato":"104676","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(104676) Documento 104676 Documento 104676 {"0":"115287","id":"115287","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"176","wf_paso_id":"176","4":"109309","wf_caso_59_seguimiento_id":"109309","5":"2014-09-13 11:11:48","fecha_ejec":"2014-09-13 11:11:48","6":"104677","dato":"104677","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(104677) Documento 104677 Documento 104677 {"0":"115288","id":"115288","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"175","wf_paso_id":"175","4":"109309","wf_caso_59_seguimiento_id":"109309","5":"2014-09-13 11:11:55","fecha_ejec":"2014-09-13 11:11:55","6":"104678","dato":"104678","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(104678) Documento 104678 Documento 104678 {"0":"115289","id":"115289","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"177","wf_paso_id":"177","4":"109310","wf_caso_59_seguimiento_id":"109310","5":"2014-09-13 11:13:05","fecha_ejec":"2014-09-13 11:13:05","6":"1528","dato":"1528","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(1528) se carga 59_109_177_4_5_752014-09-16 se carga 59_109_177_4_5_69azucar se carga 59_109_177_4_5_68tanques se carga 59_109_177_4_5_64110,0,TRANSEUR LTDA. se carga 59_109_177_4_5_412014-09-15 se carga 59_109_177_4_5_405556 se carga 59_109_177_4_5_395555 se carga 59_109_177_4_5_241 se carga 59_109_177_4_5_225000 se carga 59_109_177_4_5_2150 {"0":"115290","id":"115290","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"182","wf_paso_id":"182","4":"109311","wf_caso_59_seguimiento_id":"109311","5":"2014-09-13 11:13:18","fecha_ejec":"2014-09-13 11:13:18","6":"1530","dato":"1530","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(1530) se carga 59_115_182_6_7_381 se carga 59_115_182_6_7_371 se carga 59_115_182_6_7_32bnbnbn {"0":"115291","id":"115291","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"192","wf_paso_id":"192","4":"109311","wf_caso_59_seguimiento_id":"109311","5":"2014-09-13 11:13:31","fecha_ejec":"2014-09-13 11:13:31","6":"11397","dato":"11397","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(11397) {"0":"115292","id":"115292","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"184","wf_paso_id":"184","4":"109312","wf_caso_59_seguimiento_id":"109312","5":"2014-09-13 11:13:55","fecha_ejec":"2014-09-13 11:13:55","6":"1539","dato":"1539","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(1539) se carga 59_116_184_8_9_46nbnbnbn se carga 59_116_184_8_9_455000 se carga 59_116_184_8_9_445 se carga 59_116_184_8_9_435000 {"0":"115293","id":"115293","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"194","wf_paso_id":"194","4":"109312","wf_caso_59_seguimiento_id":"109312","5":"2014-09-13 11:14:06","fecha_ejec":"2014-09-13 11:14:06","6":"11398","dato":"11398","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(11398) 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":"109308","id":"109308","1":"11623","wf_caso_59_id":"11623","2":"105","wf_tarea_id":"105","3":null,"core_usuario_id":null,"4":"2014-09-13 11:11:24","fec_asig":"2014-09-13 11:11:24","5":"2014-09-13 11:11:31","fec_resol":"2014-09-13 11:11:31","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":"109309","id":"109309","1":"11623","wf_caso_59_id":"11623","2":"107","wf_tarea_id":"107","3":"1","core_usuario_id":"1","4":"2014-09-13 11:11:31","fec_asig":"2014-09-13 11:11:31","5":"2014-09-13 11:11:55","fec_resol":"2014-09-13 11:11:55","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":"109310","id":"109310","1":"11623","wf_caso_59_id":"11623","2":"109","wf_tarea_id":"109","3":"1","core_usuario_id":"1","4":"2014-09-13 11:11:55","fec_asig":"2014-09-13 11:11:55","5":"2014-09-13 11:13:05","fec_resol":"2014-09-13 11:13:05","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":"109311","id":"109311","1":"11623","wf_caso_59_id":"11623","2":"115","wf_tarea_id":"115","3":"1","core_usuario_id":"1","4":"2014-09-13 11:13:05","fec_asig":"2014-09-13 11:13:05","5":"2014-09-13 11:13:31","fec_resol":"2014-09-13 11:13:31","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":"109312","id":"109312","1":"11623","wf_caso_59_id":"11623","2":"116","wf_tarea_id":"116","3":"1","core_usuario_id":"1","4":"2014-09-13 11:13:31","fec_asig":"2014-09-13 11:13:31","5":"2014-09-13 11:14:06","fec_resol":"2014-09-13 11:14:06","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":"109313","id":"109313","1":"11623","wf_caso_59_id":"11623","2":"122","wf_tarea_id":"122","3":"1","core_usuario_id":"1","4":"2014-09-13 11:14:06","fec_asig":"2014-09-13 11:14:06","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:12 cargar datos del sujeto(,,s,59,11623) 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=11623 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:12 tabla dat adic select tabla from core_sujetoverificaciontipo where id=1 2015-07 02 09:44:12 tabla :core_sujetoverificacionstickerentrada SELECT * FROM core_sujetoverificacionstickerentrada where id=11549 fin 2015-07-02 09:44:12 /******************************************************************************************************/