2016-02-09 08:24:20TraerCaso(108,81,) CargarCaso :108 2016-02 09 08:24:20 CargarDatos: Caso :108 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_81_seguimiento_id,wf_paso_id from wf_caso_81_pasos a1 group by wf_caso_81_seguimiento_id,wf_paso_id order by id )a inner join wf_caso_81_pasos p using(id,wf_caso_81_seguimiento_id) inner join ( select max(id) as wf_caso_81_seguimiento_id,wf_caso_81_id,wf_tarea_id from wf_caso_81_seguimiento where wf_caso_81_id =? group by wf_caso_81_id,wf_tarea_id order by wf_caso_81_id,wf_caso_81_seguimiento_id ) b using(wf_caso_81_seguimiento_id) left join usuarios u using(core_usuario_id) {"0":"688","id":"688","1":"173","wf_paso_id":"173","2":"360","wf_caso_81_seguimiento_id":"360","3":"32","core_usuario_id":"32","4":"2015-04-16 09:54:07","fecha_ejec":"2015-04-16 09:54:07","5":"103","dato":"103","6":"sce.t22","tabla":"sce.t22","7":"78","tarea_id":"78","8":"Martinez Jose: ciudadano","usr_ejec":"Martinez Jose: ciudadano"} CargarDatos_173(103) se carga 81_78_173_22_23_3302 {"0":"689","id":"689","1":"175","wf_paso_id":"175","2":"361","wf_caso_81_seguimiento_id":"361","3":"32","core_usuario_id":"32","4":"2015-04-16 09:54:53","fecha_ejec":"2015-04-16 09:54:53","5":"23","dato":"23","6":"sce.t25","tabla":"sce.t25","7":"80","tarea_id":"80","8":"Martinez Jose: ciudadano","usr_ejec":"Martinez Jose: ciudadano"} CargarDatos_175(23) se carga 81_80_175_25_26_407 se carga 81_80_175_25_26_397dfsdfsfdsfdds se carga 81_80_175_25_26_3962015-04-25 se carga 81_80_175_25_26_3952015-04-16 se carga 81_80_175_25_26_394 se carga 81_80_175_25_26_3931 se carga 81_80_175_25_26_3924 se carga 81_80_175_25_26_3914 se carga 81_80_175_25_26_3901 se carga 81_80_175_25_26_389 se carga 81_80_175_25_26_388 se carga 81_80_175_25_26_387cvxvcxvcx se carga 81_80_175_25_26_3861 se carga 81_80_175_25_26_3852 se carga 81_80_175_25_26_3841 se carga 81_80_175_25_26_383 se carga 81_80_175_25_26_382xcvxc se carga 81_80_175_25_26_381 se carga 81_80_175_25_26_380asdfs@sda.com se carga 81_80_175_25_26_379342 se carga 81_80_175_25_26_378342 se carga 81_80_175_25_26_3771 se carga 81_80_175_25_26_376cxv se carga 81_80_175_25_26_375cvxxcv se carga 81_80_175_25_26_374xcvcx se carga 81_80_175_25_26_373 se carga 81_80_175_25_26_372xcvv se carga 81_80_175_25_26_371 se carga 81_80_175_25_26_370asdfs@sda.com se carga 81_80_175_25_26_3694324 se carga 81_80_175_25_26_36823432 se carga 81_80_175_25_26_3671 se carga 81_80_175_25_26_366czxz se carga 81_80_175_25_26_365zcxzcxzcx se carga 81_80_175_25_26_364cxzzxczcx se carga 81_80_175_25_26_363 se carga 81_80_175_25_26_362zxccxz se carga 81_80_175_25_26_361 se carga 81_80_175_25_26_360asdfs@sda.com se carga 81_80_175_25_26_359432 se carga 81_80_175_25_26_358324243 se carga 81_80_175_25_26_3571 se carga 81_80_175_25_26_3561 se carga 81_80_175_25_26_355 se carga 81_80_175_25_26_354sdafsadfsad se carga 81_80_175_25_26_353sfdasf se carga 81_80_175_25_26_352 se carga 81_80_175_25_26_3512015-04-16 {"0":"690","id":"690","1":"239","wf_paso_id":"239","2":"361","wf_caso_81_seguimiento_id":"361","3":"32","core_usuario_id":"32","4":"2015-04-16 09:55:09","fecha_ejec":"2015-04-16 09:55:09","5":"5060","dato":"5060","6":"wf_documentoentradaadj_caso","tabla":"wf_documentoentradaadj_caso","7":"80","tarea_id":"80","8":"Martinez Jose: ciudadano","usr_ejec":"Martinez Jose: ciudadano"} CargarDatos_239(5060) {"0":"691","id":"691","1":"245","wf_paso_id":"245","2":"361","wf_caso_81_seguimiento_id":"361","3":"32","core_usuario_id":"32","4":"2015-04-16 09:55:10","fecha_ejec":"2015-04-16 09:55:10","5":null,"dato":null,"6":null,"tabla":null,"7":"80","tarea_id":"80","8":"Martinez Jose: ciudadano","usr_ejec":"Martinez Jose: ciudadano"} CargarDatos_245() {"0":"692","id":"692","1":"242","wf_paso_id":"242","2":"362","wf_caso_81_seguimiento_id":"362","3":"27","core_usuario_id":"27","4":"2015-04-16 09:55:23","fecha_ejec":"2015-04-16 09:55:23","5":"2162","dato":"2162","6":"wf_documentoentradaadj_caso","tabla":"wf_documentoentradaadj_caso","7":"134","tarea_id":"134","8":"ORTIZ JOHN: gerente, ciudadano","usr_ejec":"ORTIZ JOHN: gerente, ciudadano"} CargarDatos_242(2162) {"0":"698","id":"698","1":"256","wf_paso_id":"256","2":"363","wf_caso_81_seguimiento_id":"363","3":"27","core_usuario_id":"27","4":"2015-04-16 09:55:40","fecha_ejec":"2015-04-16 09:55:40","5":null,"dato":null,"6":null,"tabla":null,"7":"138","tarea_id":"138","8":"ORTIZ JOHN: gerente, ciudadano","usr_ejec":"ORTIZ JOHN: gerente, ciudadano"} CargarDatos_256() 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_81_seguimiento a inner join ( select max(b0.id) as id,b0.wf_caso_81_id,b0.wf_tarea_id from wf_caso_81_seguimiento b0 where b0.wf_caso_81_id =? group by b0.wf_caso_81_id,b0.wf_tarea_id order by wf_caso_81_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":"360","id":"360","1":"108","wf_caso_81_id":"108","2":"78","wf_tarea_id":"78","3":null,"core_usuario_id":null,"4":"2015-04-16 09:54:05","fec_asig":"2015-04-16 09:54:05","5":"32","core_usuario_id_resol":"32","6":"2015-04-16 09:54:07","fec_resol":"2015-04-16 09:54:07","7":"78","wf_tarea_id_sig":"78","8":null,"usr_asig":null,"9":"Martinez Jose: ciudadano","usr_resol":"Martinez Jose: ciudadano"} {"0":"361","id":"361","1":"108","wf_caso_81_id":"108","2":"80","wf_tarea_id":"80","3":"32","core_usuario_id":"32","4":"2015-04-16 09:54:07","fec_asig":"2015-04-16 09:54:07","5":"32","core_usuario_id_resol":"32","6":"2015-04-16 09:55:10","fec_resol":"2015-04-16 09:55:10","7":"80","wf_tarea_id_sig":"80","8":"Martinez Jose: ciudadano","usr_asig":"Martinez Jose: ciudadano","9":"Martinez Jose: ciudadano","usr_resol":"Martinez Jose: ciudadano"} {"0":"362","id":"362","1":"108","wf_caso_81_id":"108","2":"134","wf_tarea_id":"134","3":null,"core_usuario_id":null,"4":"2015-04-16 09:55:10","fec_asig":"2015-04-16 09:55:10","5":"27","core_usuario_id_resol":"27","6":"2015-04-16 09:55:23","fec_resol":"2015-04-16 09:55:23","7":"134","wf_tarea_id_sig":"134","8":null,"usr_asig":null,"9":"ORTIZ JOHN: gerente, ciudadano","usr_resol":"ORTIZ JOHN: gerente, ciudadano"} {"0":"363","id":"363","1":"108","wf_caso_81_id":"108","2":"138","wf_tarea_id":"138","3":"27","core_usuario_id":"27","4":"2015-04-16 09:55:23","fec_asig":"2015-04-16 09:55:23","5":null,"core_usuario_id_resol":null,"6":null,"fec_resol":null,"7":"138","wf_tarea_id_sig":"138","8":"ORTIZ JOHN: gerente, ciudadano","usr_asig":"ORTIZ JOHN: gerente, ciudadano","9":null,"usr_resol":null} 2016-02 09 08:24:20 cargar datos del sujeto(,,s,81,108) select s.*, m.nombre as nom_muni, c.nom_cat,fec_caso from wf_caso_81 w inner join core_sujetoverificacion s on w.id=108 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 2016-02 09 08:24:20 tabla dat adic select tabla from core_sujetoverificaciontipo where id=1 2016-02 09 08:24:20 tabla :persona SELECT * FROM persona where id=62 ob_start(); $ciud = mb_strtoupper( "{ WFSV_2 } { WFSV_3 }",'utf-8'); ?>
Apreciado(a)
El presente mensaje es una notificación para el caso No
Permiso para publicidad exterior visual para vallas o murales artísticos fue revisada y radicada con éxito. { WFSV_1 } TWFSV_1:jlmd0222@hotmail.com revisión-radicación vallas-murallas fin 2016-02-09 08:24:20 /******************************************************************************************************/ 2016-02-09 08:24:21TraerCaso(108,81,) CargarCaso :108 2016-02 09 08:24:21 CargarDatos: Caso :108 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_81_seguimiento_id,wf_paso_id from wf_caso_81_pasos a1 group by wf_caso_81_seguimiento_id,wf_paso_id order by id )a inner join wf_caso_81_pasos p using(id,wf_caso_81_seguimiento_id) inner join ( select max(id) as wf_caso_81_seguimiento_id,wf_caso_81_id,wf_tarea_id from wf_caso_81_seguimiento where wf_caso_81_id =? group by wf_caso_81_id,wf_tarea_id order by wf_caso_81_id,wf_caso_81_seguimiento_id ) b using(wf_caso_81_seguimiento_id) left join usuarios u using(core_usuario_id) {"0":"688","id":"688","1":"173","wf_paso_id":"173","2":"360","wf_caso_81_seguimiento_id":"360","3":"32","core_usuario_id":"32","4":"2015-04-16 09:54:07","fecha_ejec":"2015-04-16 09:54:07","5":"103","dato":"103","6":"sce.t22","tabla":"sce.t22","7":"78","tarea_id":"78","8":"Martinez Jose: ciudadano","usr_ejec":"Martinez Jose: ciudadano"} CargarDatos_173(103) se carga 81_78_173_22_23_3302 {"0":"689","id":"689","1":"175","wf_paso_id":"175","2":"361","wf_caso_81_seguimiento_id":"361","3":"32","core_usuario_id":"32","4":"2015-04-16 09:54:53","fecha_ejec":"2015-04-16 09:54:53","5":"23","dato":"23","6":"sce.t25","tabla":"sce.t25","7":"80","tarea_id":"80","8":"Martinez Jose: ciudadano","usr_ejec":"Martinez Jose: ciudadano"} CargarDatos_175(23) se carga 81_80_175_25_26_407 se carga 81_80_175_25_26_397dfsdfsfdsfdds se carga 81_80_175_25_26_3962015-04-25 se carga 81_80_175_25_26_3952015-04-16 se carga 81_80_175_25_26_394 se carga 81_80_175_25_26_3931 se carga 81_80_175_25_26_3924 se carga 81_80_175_25_26_3914 se carga 81_80_175_25_26_3901 se carga 81_80_175_25_26_389 se carga 81_80_175_25_26_388 se carga 81_80_175_25_26_387cvxvcxvcx se carga 81_80_175_25_26_3861 se carga 81_80_175_25_26_3852 se carga 81_80_175_25_26_3841 se carga 81_80_175_25_26_383 se carga 81_80_175_25_26_382xcvxc se carga 81_80_175_25_26_381 se carga 81_80_175_25_26_380asdfs@sda.com se carga 81_80_175_25_26_379342 se carga 81_80_175_25_26_378342 se carga 81_80_175_25_26_3771 se carga 81_80_175_25_26_376cxv se carga 81_80_175_25_26_375cvxxcv se carga 81_80_175_25_26_374xcvcx se carga 81_80_175_25_26_373 se carga 81_80_175_25_26_372xcvv se carga 81_80_175_25_26_371 se carga 81_80_175_25_26_370asdfs@sda.com se carga 81_80_175_25_26_3694324 se carga 81_80_175_25_26_36823432 se carga 81_80_175_25_26_3671 se carga 81_80_175_25_26_366czxz se carga 81_80_175_25_26_365zcxzcxzcx se carga 81_80_175_25_26_364cxzzxczcx se carga 81_80_175_25_26_363 se carga 81_80_175_25_26_362zxccxz se carga 81_80_175_25_26_361 se carga 81_80_175_25_26_360asdfs@sda.com se carga 81_80_175_25_26_359432 se carga 81_80_175_25_26_358324243 se carga 81_80_175_25_26_3571 se carga 81_80_175_25_26_3561 se carga 81_80_175_25_26_355 se carga 81_80_175_25_26_354sdafsadfsad se carga 81_80_175_25_26_353sfdasf se carga 81_80_175_25_26_352 se carga 81_80_175_25_26_3512015-04-16 {"0":"690","id":"690","1":"239","wf_paso_id":"239","2":"361","wf_caso_81_seguimiento_id":"361","3":"32","core_usuario_id":"32","4":"2015-04-16 09:55:09","fecha_ejec":"2015-04-16 09:55:09","5":"5060","dato":"5060","6":"wf_documentoentradaadj_caso","tabla":"wf_documentoentradaadj_caso","7":"80","tarea_id":"80","8":"Martinez Jose: ciudadano","usr_ejec":"Martinez Jose: ciudadano"} CargarDatos_239(5060) {"0":"691","id":"691","1":"245","wf_paso_id":"245","2":"361","wf_caso_81_seguimiento_id":"361","3":"32","core_usuario_id":"32","4":"2015-04-16 09:55:10","fecha_ejec":"2015-04-16 09:55:10","5":null,"dato":null,"6":null,"tabla":null,"7":"80","tarea_id":"80","8":"Martinez Jose: ciudadano","usr_ejec":"Martinez Jose: ciudadano"} CargarDatos_245() {"0":"692","id":"692","1":"242","wf_paso_id":"242","2":"362","wf_caso_81_seguimiento_id":"362","3":"27","core_usuario_id":"27","4":"2015-04-16 09:55:23","fecha_ejec":"2015-04-16 09:55:23","5":"2162","dato":"2162","6":"wf_documentoentradaadj_caso","tabla":"wf_documentoentradaadj_caso","7":"134","tarea_id":"134","8":"ORTIZ JOHN: gerente, ciudadano","usr_ejec":"ORTIZ JOHN: gerente, ciudadano"} CargarDatos_242(2162) {"0":"698","id":"698","1":"256","wf_paso_id":"256","2":"363","wf_caso_81_seguimiento_id":"363","3":"27","core_usuario_id":"27","4":"2015-04-16 09:55:40","fecha_ejec":"2015-04-16 09:55:40","5":null,"dato":null,"6":null,"tabla":null,"7":"138","tarea_id":"138","8":"ORTIZ JOHN: gerente, ciudadano","usr_ejec":"ORTIZ JOHN: gerente, ciudadano"} CargarDatos_256() 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_81_seguimiento a inner join ( select max(b0.id) as id,b0.wf_caso_81_id,b0.wf_tarea_id from wf_caso_81_seguimiento b0 where b0.wf_caso_81_id =? group by b0.wf_caso_81_id,b0.wf_tarea_id order by wf_caso_81_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":"360","id":"360","1":"108","wf_caso_81_id":"108","2":"78","wf_tarea_id":"78","3":null,"core_usuario_id":null,"4":"2015-04-16 09:54:05","fec_asig":"2015-04-16 09:54:05","5":"32","core_usuario_id_resol":"32","6":"2015-04-16 09:54:07","fec_resol":"2015-04-16 09:54:07","7":"78","wf_tarea_id_sig":"78","8":null,"usr_asig":null,"9":"Martinez Jose: ciudadano","usr_resol":"Martinez Jose: ciudadano"} {"0":"361","id":"361","1":"108","wf_caso_81_id":"108","2":"80","wf_tarea_id":"80","3":"32","core_usuario_id":"32","4":"2015-04-16 09:54:07","fec_asig":"2015-04-16 09:54:07","5":"32","core_usuario_id_resol":"32","6":"2015-04-16 09:55:10","fec_resol":"2015-04-16 09:55:10","7":"80","wf_tarea_id_sig":"80","8":"Martinez Jose: ciudadano","usr_asig":"Martinez Jose: ciudadano","9":"Martinez Jose: ciudadano","usr_resol":"Martinez Jose: ciudadano"} {"0":"362","id":"362","1":"108","wf_caso_81_id":"108","2":"134","wf_tarea_id":"134","3":null,"core_usuario_id":null,"4":"2015-04-16 09:55:10","fec_asig":"2015-04-16 09:55:10","5":"27","core_usuario_id_resol":"27","6":"2015-04-16 09:55:23","fec_resol":"2015-04-16 09:55:23","7":"134","wf_tarea_id_sig":"134","8":null,"usr_asig":null,"9":"ORTIZ JOHN: gerente, ciudadano","usr_resol":"ORTIZ JOHN: gerente, ciudadano"} {"0":"363","id":"363","1":"108","wf_caso_81_id":"108","2":"138","wf_tarea_id":"138","3":"27","core_usuario_id":"27","4":"2015-04-16 09:55:23","fec_asig":"2015-04-16 09:55:23","5":null,"core_usuario_id_resol":null,"6":null,"fec_resol":null,"7":"138","wf_tarea_id_sig":"138","8":"ORTIZ JOHN: gerente, ciudadano","usr_asig":"ORTIZ JOHN: gerente, ciudadano","9":null,"usr_resol":null} 2016-02 09 08:24:21 cargar datos del sujeto(,,s,81,108) select s.*, m.nombre as nom_muni, c.nom_cat,fec_caso from wf_caso_81 w inner join core_sujetoverificacion s on w.id=108 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 2016-02 09 08:24:21 tabla dat adic select tabla from core_sujetoverificaciontipo where id=1 2016-02 09 08:24:21 tabla :persona SELECT * FROM persona where id=62 ob_start(); $ciud = mb_strtoupper( "{ WFSV_2 } { WFSV_3 }",'utf-8'); ?>
Apreciado(a)
El presente mensaje es una notificación para el caso No
Permiso para publicidad exterior visual para vallas o murales artísticos fue revisada y radicada con éxito. { WFSV_1 } TWFSV_1:jlmd0222@hotmail.com revisión-radicación vallas-murallas fin 2016-02-09 08:24:21 /******************************************************************************************************/ 2016-02-09 08:24:21TraerCaso(108,81,) CargarCaso :108 2016-02 09 08:24:21 CargarDatos: Caso :108 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_81_seguimiento_id,wf_paso_id from wf_caso_81_pasos a1 group by wf_caso_81_seguimiento_id,wf_paso_id order by id )a inner join wf_caso_81_pasos p using(id,wf_caso_81_seguimiento_id) inner join ( select max(id) as wf_caso_81_seguimiento_id,wf_caso_81_id,wf_tarea_id from wf_caso_81_seguimiento where wf_caso_81_id =? group by wf_caso_81_id,wf_tarea_id order by wf_caso_81_id,wf_caso_81_seguimiento_id ) b using(wf_caso_81_seguimiento_id) left join usuarios u using(core_usuario_id) {"0":"688","id":"688","1":"173","wf_paso_id":"173","2":"360","wf_caso_81_seguimiento_id":"360","3":"32","core_usuario_id":"32","4":"2015-04-16 09:54:07","fecha_ejec":"2015-04-16 09:54:07","5":"103","dato":"103","6":"sce.t22","tabla":"sce.t22","7":"78","tarea_id":"78","8":"Martinez Jose: ciudadano","usr_ejec":"Martinez Jose: ciudadano"} CargarDatos_173(103) se carga 81_78_173_22_23_3302 {"0":"689","id":"689","1":"175","wf_paso_id":"175","2":"361","wf_caso_81_seguimiento_id":"361","3":"32","core_usuario_id":"32","4":"2015-04-16 09:54:53","fecha_ejec":"2015-04-16 09:54:53","5":"23","dato":"23","6":"sce.t25","tabla":"sce.t25","7":"80","tarea_id":"80","8":"Martinez Jose: ciudadano","usr_ejec":"Martinez Jose: ciudadano"} CargarDatos_175(23) se carga 81_80_175_25_26_407 se carga 81_80_175_25_26_397dfsdfsfdsfdds se carga 81_80_175_25_26_3962015-04-25 se carga 81_80_175_25_26_3952015-04-16 se carga 81_80_175_25_26_394 se carga 81_80_175_25_26_3931 se carga 81_80_175_25_26_3924 se carga 81_80_175_25_26_3914 se carga 81_80_175_25_26_3901 se carga 81_80_175_25_26_389 se carga 81_80_175_25_26_388 se carga 81_80_175_25_26_387cvxvcxvcx se carga 81_80_175_25_26_3861 se carga 81_80_175_25_26_3852 se carga 81_80_175_25_26_3841 se carga 81_80_175_25_26_383 se carga 81_80_175_25_26_382xcvxc se carga 81_80_175_25_26_381 se carga 81_80_175_25_26_380asdfs@sda.com se carga 81_80_175_25_26_379342 se carga 81_80_175_25_26_378342 se carga 81_80_175_25_26_3771 se carga 81_80_175_25_26_376cxv se carga 81_80_175_25_26_375cvxxcv se carga 81_80_175_25_26_374xcvcx se carga 81_80_175_25_26_373 se carga 81_80_175_25_26_372xcvv se carga 81_80_175_25_26_371 se carga 81_80_175_25_26_370asdfs@sda.com se carga 81_80_175_25_26_3694324 se carga 81_80_175_25_26_36823432 se carga 81_80_175_25_26_3671 se carga 81_80_175_25_26_366czxz se carga 81_80_175_25_26_365zcxzcxzcx se carga 81_80_175_25_26_364cxzzxczcx se carga 81_80_175_25_26_363 se carga 81_80_175_25_26_362zxccxz se carga 81_80_175_25_26_361 se carga 81_80_175_25_26_360asdfs@sda.com se carga 81_80_175_25_26_359432 se carga 81_80_175_25_26_358324243 se carga 81_80_175_25_26_3571 se carga 81_80_175_25_26_3561 se carga 81_80_175_25_26_355 se carga 81_80_175_25_26_354sdafsadfsad se carga 81_80_175_25_26_353sfdasf se carga 81_80_175_25_26_352 se carga 81_80_175_25_26_3512015-04-16 {"0":"690","id":"690","1":"239","wf_paso_id":"239","2":"361","wf_caso_81_seguimiento_id":"361","3":"32","core_usuario_id":"32","4":"2015-04-16 09:55:09","fecha_ejec":"2015-04-16 09:55:09","5":"5060","dato":"5060","6":"wf_documentoentradaadj_caso","tabla":"wf_documentoentradaadj_caso","7":"80","tarea_id":"80","8":"Martinez Jose: ciudadano","usr_ejec":"Martinez Jose: ciudadano"} CargarDatos_239(5060) {"0":"691","id":"691","1":"245","wf_paso_id":"245","2":"361","wf_caso_81_seguimiento_id":"361","3":"32","core_usuario_id":"32","4":"2015-04-16 09:55:10","fecha_ejec":"2015-04-16 09:55:10","5":null,"dato":null,"6":null,"tabla":null,"7":"80","tarea_id":"80","8":"Martinez Jose: ciudadano","usr_ejec":"Martinez Jose: ciudadano"} CargarDatos_245() {"0":"692","id":"692","1":"242","wf_paso_id":"242","2":"362","wf_caso_81_seguimiento_id":"362","3":"27","core_usuario_id":"27","4":"2015-04-16 09:55:23","fecha_ejec":"2015-04-16 09:55:23","5":"2162","dato":"2162","6":"wf_documentoentradaadj_caso","tabla":"wf_documentoentradaadj_caso","7":"134","tarea_id":"134","8":"ORTIZ JOHN: gerente, ciudadano","usr_ejec":"ORTIZ JOHN: gerente, ciudadano"} CargarDatos_242(2162) {"0":"698","id":"698","1":"256","wf_paso_id":"256","2":"363","wf_caso_81_seguimiento_id":"363","3":"27","core_usuario_id":"27","4":"2015-04-16 09:55:40","fecha_ejec":"2015-04-16 09:55:40","5":null,"dato":null,"6":null,"tabla":null,"7":"138","tarea_id":"138","8":"ORTIZ JOHN: gerente, ciudadano","usr_ejec":"ORTIZ JOHN: gerente, ciudadano"} CargarDatos_256() 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_81_seguimiento a inner join ( select max(b0.id) as id,b0.wf_caso_81_id,b0.wf_tarea_id from wf_caso_81_seguimiento b0 where b0.wf_caso_81_id =? group by b0.wf_caso_81_id,b0.wf_tarea_id order by wf_caso_81_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":"360","id":"360","1":"108","wf_caso_81_id":"108","2":"78","wf_tarea_id":"78","3":null,"core_usuario_id":null,"4":"2015-04-16 09:54:05","fec_asig":"2015-04-16 09:54:05","5":"32","core_usuario_id_resol":"32","6":"2015-04-16 09:54:07","fec_resol":"2015-04-16 09:54:07","7":"78","wf_tarea_id_sig":"78","8":null,"usr_asig":null,"9":"Martinez Jose: ciudadano","usr_resol":"Martinez Jose: ciudadano"} {"0":"361","id":"361","1":"108","wf_caso_81_id":"108","2":"80","wf_tarea_id":"80","3":"32","core_usuario_id":"32","4":"2015-04-16 09:54:07","fec_asig":"2015-04-16 09:54:07","5":"32","core_usuario_id_resol":"32","6":"2015-04-16 09:55:10","fec_resol":"2015-04-16 09:55:10","7":"80","wf_tarea_id_sig":"80","8":"Martinez Jose: ciudadano","usr_asig":"Martinez Jose: ciudadano","9":"Martinez Jose: ciudadano","usr_resol":"Martinez Jose: ciudadano"} {"0":"362","id":"362","1":"108","wf_caso_81_id":"108","2":"134","wf_tarea_id":"134","3":null,"core_usuario_id":null,"4":"2015-04-16 09:55:10","fec_asig":"2015-04-16 09:55:10","5":"27","core_usuario_id_resol":"27","6":"2015-04-16 09:55:23","fec_resol":"2015-04-16 09:55:23","7":"134","wf_tarea_id_sig":"134","8":null,"usr_asig":null,"9":"ORTIZ JOHN: gerente, ciudadano","usr_resol":"ORTIZ JOHN: gerente, ciudadano"} {"0":"363","id":"363","1":"108","wf_caso_81_id":"108","2":"138","wf_tarea_id":"138","3":"27","core_usuario_id":"27","4":"2015-04-16 09:55:23","fec_asig":"2015-04-16 09:55:23","5":null,"core_usuario_id_resol":null,"6":null,"fec_resol":null,"7":"138","wf_tarea_id_sig":"138","8":"ORTIZ JOHN: gerente, ciudadano","usr_asig":"ORTIZ JOHN: gerente, ciudadano","9":null,"usr_resol":null} 2016-02 09 08:24:21 cargar datos del sujeto(,,s,81,108) select s.*, m.nombre as nom_muni, c.nom_cat,fec_caso from wf_caso_81 w inner join core_sujetoverificacion s on w.id=108 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 2016-02 09 08:24:21 tabla dat adic select tabla from core_sujetoverificaciontipo where id=1 2016-02 09 08:24:21 tabla :persona SELECT * FROM persona where id=62 ob_start(); $ciud = mb_strtoupper( "{ WFSV_2 } { WFSV_3 }",'utf-8'); ?>
Apreciado(a)
El presente mensaje es una notificación para el caso No
Permiso para publicidad exterior visual para vallas o murales artísticos fue revisada y radicada con éxito. { WFSV_1 } TWFSV_1:jlmd0222@hotmail.com revisión-radicación vallas-murallas fin 2016-02-09 08:24:21 /******************************************************************************************************/ 2016-02-09 08:24:22TraerCaso(108,81,) CargarCaso :108 2016-02 09 08:24:22 CargarDatos: Caso :108 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_81_seguimiento_id,wf_paso_id from wf_caso_81_pasos a1 group by wf_caso_81_seguimiento_id,wf_paso_id order by id )a inner join wf_caso_81_pasos p using(id,wf_caso_81_seguimiento_id) inner join ( select max(id) as wf_caso_81_seguimiento_id,wf_caso_81_id,wf_tarea_id from wf_caso_81_seguimiento where wf_caso_81_id =? group by wf_caso_81_id,wf_tarea_id order by wf_caso_81_id,wf_caso_81_seguimiento_id ) b using(wf_caso_81_seguimiento_id) left join usuarios u using(core_usuario_id) {"0":"688","id":"688","1":"173","wf_paso_id":"173","2":"360","wf_caso_81_seguimiento_id":"360","3":"32","core_usuario_id":"32","4":"2015-04-16 09:54:07","fecha_ejec":"2015-04-16 09:54:07","5":"103","dato":"103","6":"sce.t22","tabla":"sce.t22","7":"78","tarea_id":"78","8":"Martinez Jose: ciudadano","usr_ejec":"Martinez Jose: ciudadano"} CargarDatos_173(103) se carga 81_78_173_22_23_3302 {"0":"689","id":"689","1":"175","wf_paso_id":"175","2":"361","wf_caso_81_seguimiento_id":"361","3":"32","core_usuario_id":"32","4":"2015-04-16 09:54:53","fecha_ejec":"2015-04-16 09:54:53","5":"23","dato":"23","6":"sce.t25","tabla":"sce.t25","7":"80","tarea_id":"80","8":"Martinez Jose: ciudadano","usr_ejec":"Martinez Jose: ciudadano"} CargarDatos_175(23) se carga 81_80_175_25_26_407 se carga 81_80_175_25_26_397dfsdfsfdsfdds se carga 81_80_175_25_26_3962015-04-25 se carga 81_80_175_25_26_3952015-04-16 se carga 81_80_175_25_26_394 se carga 81_80_175_25_26_3931 se carga 81_80_175_25_26_3924 se carga 81_80_175_25_26_3914 se carga 81_80_175_25_26_3901 se carga 81_80_175_25_26_389 se carga 81_80_175_25_26_388 se carga 81_80_175_25_26_387cvxvcxvcx se carga 81_80_175_25_26_3861 se carga 81_80_175_25_26_3852 se carga 81_80_175_25_26_3841 se carga 81_80_175_25_26_383 se carga 81_80_175_25_26_382xcvxc se carga 81_80_175_25_26_381 se carga 81_80_175_25_26_380asdfs@sda.com se carga 81_80_175_25_26_379342 se carga 81_80_175_25_26_378342 se carga 81_80_175_25_26_3771 se carga 81_80_175_25_26_376cxv se carga 81_80_175_25_26_375cvxxcv se carga 81_80_175_25_26_374xcvcx se carga 81_80_175_25_26_373 se carga 81_80_175_25_26_372xcvv se carga 81_80_175_25_26_371 se carga 81_80_175_25_26_370asdfs@sda.com se carga 81_80_175_25_26_3694324 se carga 81_80_175_25_26_36823432 se carga 81_80_175_25_26_3671 se carga 81_80_175_25_26_366czxz se carga 81_80_175_25_26_365zcxzcxzcx se carga 81_80_175_25_26_364cxzzxczcx se carga 81_80_175_25_26_363 se carga 81_80_175_25_26_362zxccxz se carga 81_80_175_25_26_361 se carga 81_80_175_25_26_360asdfs@sda.com se carga 81_80_175_25_26_359432 se carga 81_80_175_25_26_358324243 se carga 81_80_175_25_26_3571 se carga 81_80_175_25_26_3561 se carga 81_80_175_25_26_355 se carga 81_80_175_25_26_354sdafsadfsad se carga 81_80_175_25_26_353sfdasf se carga 81_80_175_25_26_352 se carga 81_80_175_25_26_3512015-04-16 {"0":"690","id":"690","1":"239","wf_paso_id":"239","2":"361","wf_caso_81_seguimiento_id":"361","3":"32","core_usuario_id":"32","4":"2015-04-16 09:55:09","fecha_ejec":"2015-04-16 09:55:09","5":"5060","dato":"5060","6":"wf_documentoentradaadj_caso","tabla":"wf_documentoentradaadj_caso","7":"80","tarea_id":"80","8":"Martinez Jose: ciudadano","usr_ejec":"Martinez Jose: ciudadano"} CargarDatos_239(5060) {"0":"691","id":"691","1":"245","wf_paso_id":"245","2":"361","wf_caso_81_seguimiento_id":"361","3":"32","core_usuario_id":"32","4":"2015-04-16 09:55:10","fecha_ejec":"2015-04-16 09:55:10","5":null,"dato":null,"6":null,"tabla":null,"7":"80","tarea_id":"80","8":"Martinez Jose: ciudadano","usr_ejec":"Martinez Jose: ciudadano"} CargarDatos_245() {"0":"692","id":"692","1":"242","wf_paso_id":"242","2":"362","wf_caso_81_seguimiento_id":"362","3":"27","core_usuario_id":"27","4":"2015-04-16 09:55:23","fecha_ejec":"2015-04-16 09:55:23","5":"2162","dato":"2162","6":"wf_documentoentradaadj_caso","tabla":"wf_documentoentradaadj_caso","7":"134","tarea_id":"134","8":"ORTIZ JOHN: gerente, ciudadano","usr_ejec":"ORTIZ JOHN: gerente, ciudadano"} CargarDatos_242(2162) {"0":"698","id":"698","1":"256","wf_paso_id":"256","2":"363","wf_caso_81_seguimiento_id":"363","3":"27","core_usuario_id":"27","4":"2015-04-16 09:55:40","fecha_ejec":"2015-04-16 09:55:40","5":null,"dato":null,"6":null,"tabla":null,"7":"138","tarea_id":"138","8":"ORTIZ JOHN: gerente, ciudadano","usr_ejec":"ORTIZ JOHN: gerente, ciudadano"} CargarDatos_256() 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_81_seguimiento a inner join ( select max(b0.id) as id,b0.wf_caso_81_id,b0.wf_tarea_id from wf_caso_81_seguimiento b0 where b0.wf_caso_81_id =? group by b0.wf_caso_81_id,b0.wf_tarea_id order by wf_caso_81_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":"360","id":"360","1":"108","wf_caso_81_id":"108","2":"78","wf_tarea_id":"78","3":null,"core_usuario_id":null,"4":"2015-04-16 09:54:05","fec_asig":"2015-04-16 09:54:05","5":"32","core_usuario_id_resol":"32","6":"2015-04-16 09:54:07","fec_resol":"2015-04-16 09:54:07","7":"78","wf_tarea_id_sig":"78","8":null,"usr_asig":null,"9":"Martinez Jose: ciudadano","usr_resol":"Martinez Jose: ciudadano"} {"0":"361","id":"361","1":"108","wf_caso_81_id":"108","2":"80","wf_tarea_id":"80","3":"32","core_usuario_id":"32","4":"2015-04-16 09:54:07","fec_asig":"2015-04-16 09:54:07","5":"32","core_usuario_id_resol":"32","6":"2015-04-16 09:55:10","fec_resol":"2015-04-16 09:55:10","7":"80","wf_tarea_id_sig":"80","8":"Martinez Jose: ciudadano","usr_asig":"Martinez Jose: ciudadano","9":"Martinez Jose: ciudadano","usr_resol":"Martinez Jose: ciudadano"} {"0":"362","id":"362","1":"108","wf_caso_81_id":"108","2":"134","wf_tarea_id":"134","3":null,"core_usuario_id":null,"4":"2015-04-16 09:55:10","fec_asig":"2015-04-16 09:55:10","5":"27","core_usuario_id_resol":"27","6":"2015-04-16 09:55:23","fec_resol":"2015-04-16 09:55:23","7":"134","wf_tarea_id_sig":"134","8":null,"usr_asig":null,"9":"ORTIZ JOHN: gerente, ciudadano","usr_resol":"ORTIZ JOHN: gerente, ciudadano"} {"0":"363","id":"363","1":"108","wf_caso_81_id":"108","2":"138","wf_tarea_id":"138","3":"27","core_usuario_id":"27","4":"2015-04-16 09:55:23","fec_asig":"2015-04-16 09:55:23","5":null,"core_usuario_id_resol":null,"6":null,"fec_resol":null,"7":"138","wf_tarea_id_sig":"138","8":"ORTIZ JOHN: gerente, ciudadano","usr_asig":"ORTIZ JOHN: gerente, ciudadano","9":null,"usr_resol":null} 2016-02 09 08:24:22 cargar datos del sujeto(,,s,81,108) select s.*, m.nombre as nom_muni, c.nom_cat,fec_caso from wf_caso_81 w inner join core_sujetoverificacion s on w.id=108 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 2016-02 09 08:24:22 tabla dat adic select tabla from core_sujetoverificaciontipo where id=1 2016-02 09 08:24:22 tabla :persona SELECT * FROM persona where id=62 ob_start(); $ciud = mb_strtoupper( "{ WFSV_2 } { WFSV_3 }",'utf-8'); ?>
Apreciado(a)
El presente mensaje es una notificación para el caso No
Permiso para publicidad exterior visual para vallas o murales artísticos fue revisada y radicada con éxito. { WFSV_1 } TWFSV_1:jlmd0222@hotmail.com revisión-radicación vallas-murallas fin 2016-02-09 08:24:22 /******************************************************************************************************/