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