2016-02 08 16:44:36 Nuevo(58,1) Caso :34 2016-02 08 16:44:36 cargar datos del sujeto(,,s,34,34) select s.*, m.nombre as nom_muni, c.nom_cat,fec_caso from wf_caso_34 w inner join core_sujetoverificacion s on w.id=34 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 08 16:44:36 tabla dat adic select tabla from core_sujetoverificaciontipo where id=1 2016-02 08 16:44:36 tabla :persona SELECT * FROM persona where id=58 CasoSeguimiento :95 EjecutarTarea_36() Formulario de registro id_comp1170 28 ValidarUsuario(36):1 EjecutarPaso_46: form:5 , caso=34 id_comp 1170 Mostrar form fin 2016-02-08 16:44:36 /******************************************************************************************************/ 2016-02-08 16:44:36TraerCaso(34,34,) CargarCaso :34 2016-02 08 16:44:36 CargarDatos: Caso :34 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_34_seguimiento_id,wf_paso_id from wf_caso_34_pasos a1 group by wf_caso_34_seguimiento_id,wf_paso_id order by id )a inner join wf_caso_34_pasos p using(id,wf_caso_34_seguimiento_id) inner join ( select max(id) as wf_caso_34_seguimiento_id,wf_caso_34_id,wf_tarea_id from wf_caso_34_seguimiento where wf_caso_34_id =? group by wf_caso_34_id,wf_tarea_id order by wf_caso_34_id,wf_caso_34_seguimiento_id ) b using(wf_caso_34_seguimiento_id) left join usuarios u using(core_usuario_id) Error : 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_34_seguimiento a inner join ( select max(b0.id) as id,b0.wf_caso_34_id,b0.wf_tarea_id from wf_caso_34_seguimiento b0 where b0.wf_caso_34_id =? group by b0.wf_caso_34_id,b0.wf_tarea_id order by wf_caso_34_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":"95","id":"95","1":"34","wf_caso_34_id":"34","2":"36","wf_tarea_id":"36","3":null,"core_usuario_id":null,"4":"2016-02-08 16:44:36","fec_asig":"2016-02-08 16:44:36","5":null,"core_usuario_id_resol":null,"6":null,"fec_resol":null,"7":"36","wf_tarea_id_sig":"36","8":null,"usr_asig":null,"9":null,"usr_resol":null} 2016-02 08 16:44:36 cargar datos del sujeto(,,s,34,34) select s.*, m.nombre as nom_muni, c.nom_cat,fec_caso from wf_caso_34 w inner join core_sujetoverificacion s on w.id=34 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 08 16:44:36 tabla dat adic select tabla from core_sujetoverificaciontipo where id=1 2016-02 08 16:44:36 tabla :persona SELECT * FROM persona where id=58 fin 2016-02-08 16:44:36 /******************************************************************************************************/ 2016-02-08 16:45:50TraerCaso(34,34,) CargarCaso :34 2016-02 08 16:45:50 CargarDatos: Caso :34 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_34_seguimiento_id,wf_paso_id from wf_caso_34_pasos a1 group by wf_caso_34_seguimiento_id,wf_paso_id order by id )a inner join wf_caso_34_pasos p using(id,wf_caso_34_seguimiento_id) inner join ( select max(id) as wf_caso_34_seguimiento_id,wf_caso_34_id,wf_tarea_id from wf_caso_34_seguimiento where wf_caso_34_id =? group by wf_caso_34_id,wf_tarea_id order by wf_caso_34_id,wf_caso_34_seguimiento_id ) b using(wf_caso_34_seguimiento_id) left join usuarios u using(core_usuario_id) Error : 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_34_seguimiento a inner join ( select max(b0.id) as id,b0.wf_caso_34_id,b0.wf_tarea_id from wf_caso_34_seguimiento b0 where b0.wf_caso_34_id =? group by b0.wf_caso_34_id,b0.wf_tarea_id order by wf_caso_34_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":"95","id":"95","1":"34","wf_caso_34_id":"34","2":"36","wf_tarea_id":"36","3":null,"core_usuario_id":null,"4":"2016-02-08 16:44:36","fec_asig":"2016-02-08 16:44:36","5":null,"core_usuario_id_resol":null,"6":null,"fec_resol":null,"7":"36","wf_tarea_id_sig":"36","8":null,"usr_asig":null,"9":null,"usr_resol":null} 2016-02 08 16:45:50 cargar datos del sujeto(,,s,34,34) select s.*, m.nombre as nom_muni, c.nom_cat,fec_caso from wf_caso_34 w inner join core_sujetoverificacion s on w.id=34 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 08 16:45:50 tabla dat adic select tabla from core_sujetoverificaciontipo where id=1 2016-02 08 16:45:50 tabla :persona SELECT * FROM persona where id=58 2016-02 08 16:45:50 Continuar(s,36,46,) EjecutarTarea_36() Formulario de registro id_comp1170 28 ValidarUsuario(36):1 EjecutarPaso_46: form:5 , caso=34 id_comp 1170 Paso::Guardar(Caso:34) Datos a guardar: Array ( [wf_proceso_id] => 34 [wf_paso_id] => 46 [wf_tarea_id] => 36 [wf_caso_id] => 34 [id] => 1170 [accion] => nextPaso [reg] => s [rta] => n [cod_formulario2] => 5 [id_periodo] => 2016 [obs_ingreso] => [cod_bloque] => 6 [oid] => [oid_maestro] => [222] => 2016-02-08 [226] => kkk [227] => 301 ) OID: 27 rta: 1 dato:27 tabla:sce.t5 CasoPaso:156 CargarDatos_46(27) se carga 34_36_46_5_6_302 se carga 34_36_46_5_6_228 se carga 34_36_46_5_6_227301 se carga 34_36_46_5_6_226kkk se carga 34_36_46_5_6_225 se carga 34_36_46_5_6_2222016-02-08 SiguientePasoDe46: Funcion para ejecutar el siguiente paso EjecutarPaso_47: ladj:62 , caso=34 id_comp 1170 Mostrar ladj Retorno : Array ( [ret] => inicioComponente_WF_ladj({"tarea_id":36,"paso_id":47,"id":"1170","proceso_id":34,"caso_id":"34","sujeto_id":"58","ladj":62}); [suc] => 1 ) fin 2016-02-08 16:45:50 /******************************************************************************************************/ 2016-02-08 16:48:13TraerCaso(34,34,) CargarCaso :34 2016-02 08 16:48:13 CargarDatos: Caso :34 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_34_seguimiento_id,wf_paso_id from wf_caso_34_pasos a1 group by wf_caso_34_seguimiento_id,wf_paso_id order by id )a inner join wf_caso_34_pasos p using(id,wf_caso_34_seguimiento_id) inner join ( select max(id) as wf_caso_34_seguimiento_id,wf_caso_34_id,wf_tarea_id from wf_caso_34_seguimiento where wf_caso_34_id =? group by wf_caso_34_id,wf_tarea_id order by wf_caso_34_id,wf_caso_34_seguimiento_id ) b using(wf_caso_34_seguimiento_id) left join usuarios u using(core_usuario_id) {"0":"156","id":"156","1":"46","wf_paso_id":"46","2":"95","wf_caso_34_seguimiento_id":"95","3":"28","core_usuario_id":"28","4":"2016-02-08 16:45:50","fecha_ejec":"2016-02-08 16:45:50","5":"27","dato":"27","6":"sce.t5","tabla":"sce.t5","7":"36","tarea_id":"36","8":"fddf trfd: ciudadano","usr_ejec":"fddf trfd: ciudadano"} CargarDatos_46(27) se carga 34_36_46_5_6_302 se carga 34_36_46_5_6_228 se carga 34_36_46_5_6_227301 se carga 34_36_46_5_6_226kkk se carga 34_36_46_5_6_225 se carga 34_36_46_5_6_2222016-02-08 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_34_seguimiento a inner join ( select max(b0.id) as id,b0.wf_caso_34_id,b0.wf_tarea_id from wf_caso_34_seguimiento b0 where b0.wf_caso_34_id =? group by b0.wf_caso_34_id,b0.wf_tarea_id order by wf_caso_34_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":"95","id":"95","1":"34","wf_caso_34_id":"34","2":"36","wf_tarea_id":"36","3":null,"core_usuario_id":null,"4":"2016-02-08 16:44:36","fec_asig":"2016-02-08 16:44:36","5":null,"core_usuario_id_resol":null,"6":null,"fec_resol":null,"7":"36","wf_tarea_id_sig":"36","8":null,"usr_asig":null,"9":null,"usr_resol":null} 2016-02 08 16:48:13 cargar datos del sujeto(,,s,34,34) select s.*, m.nombre as nom_muni, c.nom_cat,fec_caso from wf_caso_34 w inner join core_sujetoverificacion s on w.id=34 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 08 16:48:13 tabla dat adic select tabla from core_sujetoverificaciontipo where id=1 2016-02 08 16:48:13 tabla :persona SELECT * FROM persona where id=58 2016-02 08 16:48:13 Continuar(s,36,47,) EjecutarTarea_36() Formulario de registro id_comp1170 28 ValidarUsuario(36):1 EjecutarPaso_47: ladj:62 , caso=34 id_comp 1170 Paso::Guardar(Caso:34) rta: 1 dato:6848 tabla:wf_documentoentradaadj_caso CasoPaso:157 CargarDatos_47(6848) SiguientePasoDe47: Funcion para ejecutar el siguiente paso EjecutarPaso_118: corr:40 , caso=34 id_comp 1170 Mostrar corr ob_start(); $ciud = mb_strtoupper( "{ WFSV_2 } { WFSV_3 }",'utf-8'); ?>

Apreciado(a)

El presente mensaje es una notificación para el caso No

inicioComponente_WF_Correo({"id":"1170","caso_id":"34","proceso_id":34,"tit":"Formulario de registro","tarea_id":36,"paso_id":118,"desc":"

\nApreciado(a)
\nTRFD FDDF<\/strong>\n

\n

El presente mensaje es una notificación para el caso No 34<\/strong> <\/p>\nSu solicitud de concepto de norma urban\u00edstica ha sido registrada exitosamente  y ya se encuentra en tr\u00e1mite.<\/strong> ","url":"De clic aquí para volver a enviar el correo<\/a><\/div>"}); [suc] => 1 ) fin 2016-02-08 16:48:13 /******************************************************************************************************/ 2016-02-08 16:48:15TraerCaso(34,34,) CargarCaso :34 2016-02 08 16:48:15 CargarDatos: Caso :34 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_34_seguimiento_id,wf_paso_id from wf_caso_34_pasos a1 group by wf_caso_34_seguimiento_id,wf_paso_id order by id )a inner join wf_caso_34_pasos p using(id,wf_caso_34_seguimiento_id) inner join ( select max(id) as wf_caso_34_seguimiento_id,wf_caso_34_id,wf_tarea_id from wf_caso_34_seguimiento where wf_caso_34_id =? group by wf_caso_34_id,wf_tarea_id order by wf_caso_34_id,wf_caso_34_seguimiento_id ) b using(wf_caso_34_seguimiento_id) left join usuarios u using(core_usuario_id) {"0":"156","id":"156","1":"46","wf_paso_id":"46","2":"95","wf_caso_34_seguimiento_id":"95","3":"28","core_usuario_id":"28","4":"2016-02-08 16:45:50","fecha_ejec":"2016-02-08 16:45:50","5":"27","dato":"27","6":"sce.t5","tabla":"sce.t5","7":"36","tarea_id":"36","8":"fddf trfd: ciudadano","usr_ejec":"fddf trfd: ciudadano"} CargarDatos_46(27) se carga 34_36_46_5_6_302 se carga 34_36_46_5_6_228 se carga 34_36_46_5_6_227301 se carga 34_36_46_5_6_226kkk se carga 34_36_46_5_6_225 se carga 34_36_46_5_6_2222016-02-08 {"0":"157","id":"157","1":"47","wf_paso_id":"47","2":"95","wf_caso_34_seguimiento_id":"95","3":"28","core_usuario_id":"28","4":"2016-02-08 16:48:13","fecha_ejec":"2016-02-08 16:48:13","5":"6848","dato":"6848","6":"wf_documentoentradaadj_caso","tabla":"wf_documentoentradaadj_caso","7":"36","tarea_id":"36","8":"fddf trfd: ciudadano","usr_ejec":"fddf trfd: ciudadano"} CargarDatos_47(6848) 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_34_seguimiento a inner join ( select max(b0.id) as id,b0.wf_caso_34_id,b0.wf_tarea_id from wf_caso_34_seguimiento b0 where b0.wf_caso_34_id =? group by b0.wf_caso_34_id,b0.wf_tarea_id order by wf_caso_34_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":"95","id":"95","1":"34","wf_caso_34_id":"34","2":"36","wf_tarea_id":"36","3":null,"core_usuario_id":null,"4":"2016-02-08 16:44:36","fec_asig":"2016-02-08 16:44:36","5":null,"core_usuario_id_resol":null,"6":null,"fec_resol":null,"7":"36","wf_tarea_id_sig":"36","8":null,"usr_asig":null,"9":null,"usr_resol":null} 2016-02 08 16:48:15 cargar datos del sujeto(,,s,34,34) select s.*, m.nombre as nom_muni, c.nom_cat,fec_caso from wf_caso_34 w inner join core_sujetoverificacion s on w.id=34 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 08 16:48:15 tabla dat adic select tabla from core_sujetoverificaciontipo where id=1 2016-02 08 16:48:15 tabla :persona SELECT * FROM persona where id=58 2016-02 08 16:48:15 Continuar(s,36,118,) EjecutarTarea_36() Formulario de registro id_comp1170 28 ValidarUsuario(36):1 EjecutarPaso_118: corr:40 , caso=34 id_comp 1170 Paso::Guardar(Caso:34) rta: 1 dato: tabla: CasoPaso:158 CargarDatos_118() SiguientePasoDe118: Funcion para ejecutar el siguiente paso Condicion Tarea : true TerminarTarea(36,72) Ultimo seg :95 Ultimo seg :96 EjecutarTarea_72() Verificación id_comp1170 28 ValidarUsuario(72): Retorno : Array ( [htm] => [suc] => 1 [ret] => crearMsg('Usted no puede ejecutar la tarea actual del proceso, Debe esperar a que un usuario con los privilegios adecuados la ejecute.','Información');Ext.getCmp('comp_1170').funcionInicial('n'); ) fin 2016-02-08 16:48:15 /******************************************************************************************************/ 2016-02-08 16:51:04TraerCaso(34,34,) CargarCaso :34 2016-02 08 16:51:04 CargarDatos: Caso :34 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_34_seguimiento_id,wf_paso_id from wf_caso_34_pasos a1 group by wf_caso_34_seguimiento_id,wf_paso_id order by id )a inner join wf_caso_34_pasos p using(id,wf_caso_34_seguimiento_id) inner join ( select max(id) as wf_caso_34_seguimiento_id,wf_caso_34_id,wf_tarea_id from wf_caso_34_seguimiento where wf_caso_34_id =? group by wf_caso_34_id,wf_tarea_id order by wf_caso_34_id,wf_caso_34_seguimiento_id ) b using(wf_caso_34_seguimiento_id) left join usuarios u using(core_usuario_id) {"0":"156","id":"156","1":"46","wf_paso_id":"46","2":"95","wf_caso_34_seguimiento_id":"95","3":"28","core_usuario_id":"28","4":"2016-02-08 16:45:50","fecha_ejec":"2016-02-08 16:45:50","5":"27","dato":"27","6":"sce.t5","tabla":"sce.t5","7":"36","tarea_id":"36","8":"fddf trfd: ciudadano","usr_ejec":"fddf trfd: ciudadano"} CargarDatos_46(27) se carga 34_36_46_5_6_302 se carga 34_36_46_5_6_228 se carga 34_36_46_5_6_227301 se carga 34_36_46_5_6_226kkk se carga 34_36_46_5_6_225 se carga 34_36_46_5_6_2222016-02-08 {"0":"157","id":"157","1":"47","wf_paso_id":"47","2":"95","wf_caso_34_seguimiento_id":"95","3":"28","core_usuario_id":"28","4":"2016-02-08 16:48:13","fecha_ejec":"2016-02-08 16:48:13","5":"6848","dato":"6848","6":"wf_documentoentradaadj_caso","tabla":"wf_documentoentradaadj_caso","7":"36","tarea_id":"36","8":"fddf trfd: ciudadano","usr_ejec":"fddf trfd: ciudadano"} CargarDatos_47(6848) {"0":"158","id":"158","1":"118","wf_paso_id":"118","2":"95","wf_caso_34_seguimiento_id":"95","3":"28","core_usuario_id":"28","4":"2016-02-08 16:48:15","fecha_ejec":"2016-02-08 16:48:15","5":null,"dato":null,"6":null,"tabla":null,"7":"36","tarea_id":"36","8":"fddf trfd: ciudadano","usr_ejec":"fddf trfd: ciudadano"} CargarDatos_118() 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_34_seguimiento a inner join ( select max(b0.id) as id,b0.wf_caso_34_id,b0.wf_tarea_id from wf_caso_34_seguimiento b0 where b0.wf_caso_34_id =? group by b0.wf_caso_34_id,b0.wf_tarea_id order by wf_caso_34_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":"95","id":"95","1":"34","wf_caso_34_id":"34","2":"36","wf_tarea_id":"36","3":null,"core_usuario_id":null,"4":"2016-02-08 16:44:36","fec_asig":"2016-02-08 16:44:36","5":"28","core_usuario_id_resol":"28","6":"2016-02-08 16:48:15","fec_resol":"2016-02-08 16:48:15","7":"36","wf_tarea_id_sig":"36","8":null,"usr_asig":null,"9":"fddf trfd: ciudadano","usr_resol":"fddf trfd: ciudadano"} {"0":"96","id":"96","1":"34","wf_caso_34_id":"34","2":"72","wf_tarea_id":"72","3":null,"core_usuario_id":null,"4":"2016-02-08 16:48:15","fec_asig":"2016-02-08 16:48:15","5":null,"core_usuario_id_resol":null,"6":null,"fec_resol":null,"7":"72","wf_tarea_id_sig":"72","8":null,"usr_asig":null,"9":null,"usr_resol":null} 2016-02 08 16:51:04 cargar datos del sujeto(,,s,34,34) select s.*, m.nombre as nom_muni, c.nom_cat,fec_caso from wf_caso_34 w inner join core_sujetoverificacion s on w.id=34 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 08 16:51:04 tabla dat adic select tabla from core_sujetoverificaciontipo where id=1 2016-02 08 16:51:04 tabla :persona SELECT * FROM persona where id=58 2016-02 08 16:51:04 Continuar(,72,,s) EjecutarTarea_72() Verificación id_comp1173 65 ValidarUsuario(72):1 EjecutarPaso_161: vadj:62 , caso=34 id_comp 1173 Mostrar vadj Retorno : Array ( [ret] => inicioComponente_WF_vadj({"tarea_id":72,"paso_id":161,"id":"1173","proceso_id":34,"caso_id":"34","sujeto_id":"58","vadj":62}); [suc] => 1 ) fin 2016-02-08 16:51:04 /******************************************************************************************************/ 2016-02-08 16:51:34TraerCaso(34,34,) CargarCaso :34 2016-02 08 16:51:34 CargarDatos: Caso :34 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_34_seguimiento_id,wf_paso_id from wf_caso_34_pasos a1 group by wf_caso_34_seguimiento_id,wf_paso_id order by id )a inner join wf_caso_34_pasos p using(id,wf_caso_34_seguimiento_id) inner join ( select max(id) as wf_caso_34_seguimiento_id,wf_caso_34_id,wf_tarea_id from wf_caso_34_seguimiento where wf_caso_34_id =? group by wf_caso_34_id,wf_tarea_id order by wf_caso_34_id,wf_caso_34_seguimiento_id ) b using(wf_caso_34_seguimiento_id) left join usuarios u using(core_usuario_id) {"0":"156","id":"156","1":"46","wf_paso_id":"46","2":"95","wf_caso_34_seguimiento_id":"95","3":"28","core_usuario_id":"28","4":"2016-02-08 16:45:50","fecha_ejec":"2016-02-08 16:45:50","5":"27","dato":"27","6":"sce.t5","tabla":"sce.t5","7":"36","tarea_id":"36","8":"fddf trfd: ciudadano","usr_ejec":"fddf trfd: ciudadano"} CargarDatos_46(27) se carga 34_36_46_5_6_302 se carga 34_36_46_5_6_228 se carga 34_36_46_5_6_227301 se carga 34_36_46_5_6_226kkk se carga 34_36_46_5_6_225 se carga 34_36_46_5_6_2222016-02-08 {"0":"157","id":"157","1":"47","wf_paso_id":"47","2":"95","wf_caso_34_seguimiento_id":"95","3":"28","core_usuario_id":"28","4":"2016-02-08 16:48:13","fecha_ejec":"2016-02-08 16:48:13","5":"6848","dato":"6848","6":"wf_documentoentradaadj_caso","tabla":"wf_documentoentradaadj_caso","7":"36","tarea_id":"36","8":"fddf trfd: ciudadano","usr_ejec":"fddf trfd: ciudadano"} CargarDatos_47(6848) {"0":"158","id":"158","1":"118","wf_paso_id":"118","2":"95","wf_caso_34_seguimiento_id":"95","3":"28","core_usuario_id":"28","4":"2016-02-08 16:48:15","fecha_ejec":"2016-02-08 16:48:15","5":null,"dato":null,"6":null,"tabla":null,"7":"36","tarea_id":"36","8":"fddf trfd: ciudadano","usr_ejec":"fddf trfd: ciudadano"} CargarDatos_118() 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_34_seguimiento a inner join ( select max(b0.id) as id,b0.wf_caso_34_id,b0.wf_tarea_id from wf_caso_34_seguimiento b0 where b0.wf_caso_34_id =? group by b0.wf_caso_34_id,b0.wf_tarea_id order by wf_caso_34_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":"95","id":"95","1":"34","wf_caso_34_id":"34","2":"36","wf_tarea_id":"36","3":null,"core_usuario_id":null,"4":"2016-02-08 16:44:36","fec_asig":"2016-02-08 16:44:36","5":"28","core_usuario_id_resol":"28","6":"2016-02-08 16:48:15","fec_resol":"2016-02-08 16:48:15","7":"36","wf_tarea_id_sig":"36","8":null,"usr_asig":null,"9":"fddf trfd: ciudadano","usr_resol":"fddf trfd: ciudadano"} {"0":"96","id":"96","1":"34","wf_caso_34_id":"34","2":"72","wf_tarea_id":"72","3":null,"core_usuario_id":null,"4":"2016-02-08 16:48:15","fec_asig":"2016-02-08 16:48:15","5":null,"core_usuario_id_resol":null,"6":null,"fec_resol":null,"7":"72","wf_tarea_id_sig":"72","8":null,"usr_asig":null,"9":null,"usr_resol":null} 2016-02 08 16:51:34 cargar datos del sujeto(,,s,34,34) select s.*, m.nombre as nom_muni, c.nom_cat,fec_caso from wf_caso_34 w inner join core_sujetoverificacion s on w.id=34 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 08 16:51:34 tabla dat adic select tabla from core_sujetoverificaciontipo where id=1 2016-02 08 16:51:34 tabla :persona SELECT * FROM persona where id=58 2016-02 08 16:51:34 Continuar(s,72,161,) EjecutarTarea_72() Verificación id_comp1173 65 ValidarUsuario(72):1 EjecutarPaso_161: vadj:62 , caso=34 id_comp 1173 Paso::Guardar(Caso:34) rta: 1 dato:2715 tabla:wf_documentoentradaadj_caso CasoPaso:159 CargarDatos_161(2715) SiguientePasoDe161: Funcion para ejecutar el siguiente paso Condicion Tarea : Si =="Si" TerminarTarea(72,37) Ultimo seg :96 Ultimo seg :97 EjecutarTarea_37() Radicación id_comp1173 65 65 ValidarUsuario(37):1 EjecutarPaso_50: form:6 , caso=34 id_comp 1173 Mostrar form Retorno : Array ( [ret] => Ext.getCmp('comp_1173').removeAll();Ext.getCmp('comp_1173').add(new Ext.form.FormPanel({ title: 'Urbanística' ,padding: 10,id:'frm_formulario_34_34',autoScroll:true ,labelAlign:'top',defaults: { anchor: '97%'} ,items: [new Ext.form.Hidden({name:'cod_formulario2',value:'6'}) ,new Ext.form.Hidden({name :'id_periodo',value:'2016'}) ,new Ext.form.Hidden({name :'obs_ingreso',value:''}) ,new Ext.form.Hidden({name:'cod_bloque',value:'7'}) ,new Ext.form.Hidden({name :'oid',value:''}) ,new Ext.form.Hidden({name :'oid_maestro',value:''}) ,{value:'',xtype:'textfield' , maxLength:30,autoCreate:{ tag:'input',maxlength:'30'} ,allowBlank:false,id:'301',fieldLabel:'* No. Predial' },{value:'',xtype:'textfield' , maxLength:30,autoCreate:{ tag:'input',maxlength:'30'} ,allowBlank:false,id:'303',fieldLabel:'* No. Radicación' },new Ext.form.DateField({fieldLabel:'* Fecha de la visita',name:'231',allowBlank:false,maskRe:/^[-_0-9]$/,format:FormatoFecha,renderer:Ext.util.Format.dateRenderer(FormatoFecha) }), new Ext.form.TimeField({ hiddenName:'232',id:'h_232' ,allowBlank:false,fieldLabel:'* Hora'}),{value:'',xtype:'textfield' , maxLength:60,autoCreate:{ tag:'input',maxlength:'60'} ,allowBlank:false,id:'233',fieldLabel:'* Clase de Predio' },{value:'',xtype:'textfield' , maxLength:60,autoCreate:{ tag:'input',maxlength:'60'} ,allowBlank:false,id:'234',fieldLabel:'* Dirección' },new Ext.form.ComboBox({fieldLabel:'*Comuna',anchor:'100%',allowBlank:false,forceSelection:true,emptyText:'Seleccione una opción',editable:true,displayField:'valor',valueField:'id',triggerAction:'all',minChars:3,store:new Ext.data.Store({autoDestroy:true,url:$view_js+"carga_comboQueryTabla.php",autoSave:false,baseParams:{'dqsl':'6', 'pro':'34', 'cas':'34'},autoLoad:false,reader:new Ext.data.JsonReader({totalProperty:'total',successProperty:'success',idProperty:'id',root:'data',messageProperty:'message'},[{name:'id'},{name:'valor'}])}),mode:'remote',queryParam:'nombre',pageSize:20,hiddenName:235,id:'inp_235',loadValor:function(val,data){this.getStore().loadData(data);this.setValue(val);}}),{value:'',xtype:'textfield' , maxLength:60,autoCreate:{ tag:'input',maxlength:'60'} ,allowBlank:false,id:'236',fieldLabel:'* Sector' },{value:'',xtype:'textfield' , maxLength:60,autoCreate:{ tag:'input',maxlength:'60'} ,allowBlank:false,id:'237',fieldLabel:'* Sección' },{value:'',xtype:'textfield' , maxLength:30,autoCreate:{ tag:'input',maxlength:'30'} ,allowBlank:false,id:'238',fieldLabel:'* Manzana' },{ xtype:'hidden',id:'hds239',disabled:true},new Ext.form.ComboBox({typeAhead:true,listeners:{ select:function(){xajax_comprobar_campoOcultoSelect(this.getValue(),239);},afterrender:function(){ xajax_comprobar_campoOcultoSelect(this.getValue(),239); }},/*fin introducir listener para campos ocultos*/triggerAction:'all',mode:'local',editable:false,emptyText:'Seleccione una opción',store:new Ext.data.ArrayStore({fields:['id', 'value'],data:[[1,'1'],[2,'2'],[3,'3'],[4,'4'],[5,'5'],[6,'6'],[7,'7'],[8,'8'],[9,'9'],[10,'10'] ]}),valueField:'id',displayField:'value',id:'inp_select_7_239',allowBlank:false,fieldLabel:'* Estrato',hiddenName:'239'}),{value:'',xtype:'textfield' , maxLength:60,autoCreate:{ tag:'input',maxlength:'60'} ,allowBlank:false,id:'240',fieldLabel:'* Suelo' },{value:'',xtype:'textfield' , maxLength:30,autoCreate:{ tag:'input',maxlength:'30'} ,allowBlank:false,id:'241',fieldLabel:'* AMH' },{value:'',xtype:'textfield' , maxLength:30,autoCreate:{ tag:'input',maxlength:'30'} ,allowBlank:false,id:'242',fieldLabel:'* Tratamiento' }, new Ext.form.TextArea({id:'304',allowBlank:false, fieldLabel:'* Observaciones',name:'304'}),new Ext.form.RadioGroup({columns:2,items:[ new Ext.form.Radio({name:'313',id:'313_1',inputValue:1,boxLabel:'Si'}), new Ext.form.Radio({name:'313',id:'313_2',inputValue:2,boxLabel:'No'}) ],columns:2,allowBlank:false,fieldLabel:'* Carta catastral',id:'313',listeners:{change:function(){var rad=Ext.getCmp('313_2').getValue();if(rad){Ext.getCmp('314').setDisabled(true);Ext.getCmp('314').setValue('');}else{Ext.getCmp('314').setDisabled(false);}}}}), new Ext.form.TextArea({id:'314',allowBlank:false, fieldLabel:'* Nombre',name:'314',disabled:true}) ] ,prepararGrids:function(){/*buscar editorgrid - grilla id compuesto, id real, mas id formulario esclavo, separado _*/var grillasF=this.findByType('editorgrid');if(grillasF && grillasF!=''){for (i=0; i < grillasF.length; i++){var xstore=grillasF[i].getStore();if(xstore.getCount()>0){var data=new Array();var xxid=grillasF[i].getId().split('_');for (j=0; j < xstore.getCount(); j++){var xreco = xstore.getAt(j); var cont_dat_vac=0,cont_tot_vac=0; for(var elem in xreco.data){cont_tot_vac++;if( xreco.data[elem] ==null || xreco.data[elem]=='' ){cont_dat_vac++;}} if(cont_dat_vac < cont_tot_vac){data[data.length]=xreco.data;data[data.length-1]['form_master_escribir_xxx']=xxid[1];}}var xfinalfin=Ext.encode(data);Ext.getCmp(xxid[0]).setValue(xfinalfin);}}}/*grabar stores en hiddens*/},tbar:[{text:'Guardar',iconCls: 'icon-disk',handler: function(){ var form = Ext.getCmp('frm_formulario_34_34'); var f=form.getForm();if(f.isValid()){var band_f=true;try{band_f =form.Validar();}catch(e){}if(band_f){form.prepararGrids();f.submit({url:'http://192.168.10.116/sisad/build/view/'+'workflow/casos/casos_l.php',params:{wf_proceso_id:'34',wf_paso_id:'50',wf_tarea_id:'37',wf_caso_id:'34',id:'1173',accion:'nextPaso',reg:'s',rta:'n'},success:function(form, action){if(action.result.message) crearMsg(action.result.message,'Informacion');else if(action.result.execute){/*try{*/eval(action.result.execute);/*}catch(e){alert(e+'Se presentó un error , por favor cierre la pestaña del caso y continue el proceso desde la pestaña de resumen' );}*/}},failure: function(form, action) {switch (action.failureType) {case Ext.form.Action.CONNECT_FAILURE:Ext.Msg.alert('Error', 'En este momento no hay comunicación con el servidor intente más tarde');break;case Ext.form.Action.SERVER_INVALID: Ext.Msg.alert('Error', action.result.message); break; }}});}}else{Ext.MessageBox.alert('Advertencia',getErrorFields(f));}} } ] ,listeners:{ afterrender:function(){ try{ Ext.getCmp('frm_formulario_34_34').getForm().loadRecord(new Ext.data.Record({"cod_formulario":6,"oid_maestro":null,"cod_bloque":7,"301":null,"303":null,"233":null,"234":null,"236":null,"237":null,"238":null,"240":null,"241":null,"242":null})); llamadaAJAX({url:'http://192.168.10.116/sisad/build/view/workflow/casos/casos_datosForm.php',mostrarMsg:false,params:{accion:'verifica',wf_paso_id:'50',cod_formulario:'6',cod_bloque:'7',wf_caso_id:'{"pro":"34","cas":"34"}'}}); }catch(e){alert(e);} } } }) );Ext.getCmp('comp_1173').doLayout(); [suc] => 1 ) fin 2016-02-08 16:51:35 /******************************************************************************************************/ 2016-02-08 16:51:35TraerCaso(34,34,) CargarCaso :34 2016-02 08 16:51:35 CargarDatos: Caso :34 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_34_seguimiento_id,wf_paso_id from wf_caso_34_pasos a1 group by wf_caso_34_seguimiento_id,wf_paso_id order by id )a inner join wf_caso_34_pasos p using(id,wf_caso_34_seguimiento_id) inner join ( select max(id) as wf_caso_34_seguimiento_id,wf_caso_34_id,wf_tarea_id from wf_caso_34_seguimiento where wf_caso_34_id =? group by wf_caso_34_id,wf_tarea_id order by wf_caso_34_id,wf_caso_34_seguimiento_id ) b using(wf_caso_34_seguimiento_id) left join usuarios u using(core_usuario_id) {"0":"156","id":"156","1":"46","wf_paso_id":"46","2":"95","wf_caso_34_seguimiento_id":"95","3":"28","core_usuario_id":"28","4":"2016-02-08 16:45:50","fecha_ejec":"2016-02-08 16:45:50","5":"27","dato":"27","6":"sce.t5","tabla":"sce.t5","7":"36","tarea_id":"36","8":"fddf trfd: ciudadano","usr_ejec":"fddf trfd: ciudadano"} CargarDatos_46(27) se carga 34_36_46_5_6_302 se carga 34_36_46_5_6_228 se carga 34_36_46_5_6_227301 se carga 34_36_46_5_6_226kkk se carga 34_36_46_5_6_225 se carga 34_36_46_5_6_2222016-02-08 {"0":"157","id":"157","1":"47","wf_paso_id":"47","2":"95","wf_caso_34_seguimiento_id":"95","3":"28","core_usuario_id":"28","4":"2016-02-08 16:48:13","fecha_ejec":"2016-02-08 16:48:13","5":"6848","dato":"6848","6":"wf_documentoentradaadj_caso","tabla":"wf_documentoentradaadj_caso","7":"36","tarea_id":"36","8":"fddf trfd: ciudadano","usr_ejec":"fddf trfd: ciudadano"} CargarDatos_47(6848) {"0":"158","id":"158","1":"118","wf_paso_id":"118","2":"95","wf_caso_34_seguimiento_id":"95","3":"28","core_usuario_id":"28","4":"2016-02-08 16:48:15","fecha_ejec":"2016-02-08 16:48:15","5":null,"dato":null,"6":null,"tabla":null,"7":"36","tarea_id":"36","8":"fddf trfd: ciudadano","usr_ejec":"fddf trfd: ciudadano"} CargarDatos_118() {"0":"159","id":"159","1":"161","wf_paso_id":"161","2":"96","wf_caso_34_seguimiento_id":"96","3":"65","core_usuario_id":"65","4":"2016-02-08 16:51:34","fecha_ejec":"2016-02-08 16:51:34","5":"2715","dato":"2715","6":"wf_documentoentradaadj_caso","tabla":"wf_documentoentradaadj_caso","7":"72","tarea_id":"72","8":"funcionario planeaci\u00f3n: gerente","usr_ejec":"funcionario planeaci\u00f3n: gerente"} CargarDatos_161(2715) 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_34_seguimiento a inner join ( select max(b0.id) as id,b0.wf_caso_34_id,b0.wf_tarea_id from wf_caso_34_seguimiento b0 where b0.wf_caso_34_id =? group by b0.wf_caso_34_id,b0.wf_tarea_id order by wf_caso_34_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":"95","id":"95","1":"34","wf_caso_34_id":"34","2":"36","wf_tarea_id":"36","3":null,"core_usuario_id":null,"4":"2016-02-08 16:44:36","fec_asig":"2016-02-08 16:44:36","5":"28","core_usuario_id_resol":"28","6":"2016-02-08 16:48:15","fec_resol":"2016-02-08 16:48:15","7":"36","wf_tarea_id_sig":"36","8":null,"usr_asig":null,"9":"fddf trfd: ciudadano","usr_resol":"fddf trfd: ciudadano"} {"0":"96","id":"96","1":"34","wf_caso_34_id":"34","2":"72","wf_tarea_id":"72","3":null,"core_usuario_id":null,"4":"2016-02-08 16:48:15","fec_asig":"2016-02-08 16:48:15","5":"65","core_usuario_id_resol":"65","6":"2016-02-08 16:51:34","fec_resol":"2016-02-08 16:51:34","7":"72","wf_tarea_id_sig":"72","8":null,"usr_asig":null,"9":"funcionario planeaci\u00f3n: gerente","usr_resol":"funcionario planeaci\u00f3n: gerente"} {"0":"97","id":"97","1":"34","wf_caso_34_id":"34","2":"37","wf_tarea_id":"37","3":"65","core_usuario_id":"65","4":"2016-02-08 16:51:35","fec_asig":"2016-02-08 16:51:35","5":null,"core_usuario_id_resol":null,"6":null,"fec_resol":null,"7":"37","wf_tarea_id_sig":"37","8":"funcionario planeaci\u00f3n: gerente","usr_asig":"funcionario planeaci\u00f3n: gerente","9":null,"usr_resol":null} 2016-02 08 16:51:35 cargar datos del sujeto(,,s,34,34) select s.*, m.nombre as nom_muni, c.nom_cat,fec_caso from wf_caso_34 w inner join core_sujetoverificacion s on w.id=34 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 08 16:51:35 tabla dat adic select tabla from core_sujetoverificaciontipo where id=1 2016-02 08 16:51:35 tabla :persona SELECT * FROM persona where id=58 fin 2016-02-08 16:51:35 /******************************************************************************************************/ 2016-02-08 16:54:20TraerCaso(34,34,) CargarCaso :34 2016-02 08 16:54:20 CargarDatos: Caso :34 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_34_seguimiento_id,wf_paso_id from wf_caso_34_pasos a1 group by wf_caso_34_seguimiento_id,wf_paso_id order by id )a inner join wf_caso_34_pasos p using(id,wf_caso_34_seguimiento_id) inner join ( select max(id) as wf_caso_34_seguimiento_id,wf_caso_34_id,wf_tarea_id from wf_caso_34_seguimiento where wf_caso_34_id =? group by wf_caso_34_id,wf_tarea_id order by wf_caso_34_id,wf_caso_34_seguimiento_id ) b using(wf_caso_34_seguimiento_id) left join usuarios u using(core_usuario_id) {"0":"156","id":"156","1":"46","wf_paso_id":"46","2":"95","wf_caso_34_seguimiento_id":"95","3":"28","core_usuario_id":"28","4":"2016-02-08 16:45:50","fecha_ejec":"2016-02-08 16:45:50","5":"27","dato":"27","6":"sce.t5","tabla":"sce.t5","7":"36","tarea_id":"36","8":"fddf trfd: ciudadano","usr_ejec":"fddf trfd: ciudadano"} CargarDatos_46(27) se carga 34_36_46_5_6_302 se carga 34_36_46_5_6_228 se carga 34_36_46_5_6_227301 se carga 34_36_46_5_6_226kkk se carga 34_36_46_5_6_225 se carga 34_36_46_5_6_2222016-02-08 {"0":"157","id":"157","1":"47","wf_paso_id":"47","2":"95","wf_caso_34_seguimiento_id":"95","3":"28","core_usuario_id":"28","4":"2016-02-08 16:48:13","fecha_ejec":"2016-02-08 16:48:13","5":"6848","dato":"6848","6":"wf_documentoentradaadj_caso","tabla":"wf_documentoentradaadj_caso","7":"36","tarea_id":"36","8":"fddf trfd: ciudadano","usr_ejec":"fddf trfd: ciudadano"} CargarDatos_47(6848) {"0":"158","id":"158","1":"118","wf_paso_id":"118","2":"95","wf_caso_34_seguimiento_id":"95","3":"28","core_usuario_id":"28","4":"2016-02-08 16:48:15","fecha_ejec":"2016-02-08 16:48:15","5":null,"dato":null,"6":null,"tabla":null,"7":"36","tarea_id":"36","8":"fddf trfd: ciudadano","usr_ejec":"fddf trfd: ciudadano"} CargarDatos_118() {"0":"159","id":"159","1":"161","wf_paso_id":"161","2":"96","wf_caso_34_seguimiento_id":"96","3":"65","core_usuario_id":"65","4":"2016-02-08 16:51:34","fecha_ejec":"2016-02-08 16:51:34","5":"2715","dato":"2715","6":"wf_documentoentradaadj_caso","tabla":"wf_documentoentradaadj_caso","7":"72","tarea_id":"72","8":"funcionario planeaci\u00f3n: gerente","usr_ejec":"funcionario planeaci\u00f3n: gerente"} CargarDatos_161(2715) 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_34_seguimiento a inner join ( select max(b0.id) as id,b0.wf_caso_34_id,b0.wf_tarea_id from wf_caso_34_seguimiento b0 where b0.wf_caso_34_id =? group by b0.wf_caso_34_id,b0.wf_tarea_id order by wf_caso_34_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":"95","id":"95","1":"34","wf_caso_34_id":"34","2":"36","wf_tarea_id":"36","3":null,"core_usuario_id":null,"4":"2016-02-08 16:44:36","fec_asig":"2016-02-08 16:44:36","5":"28","core_usuario_id_resol":"28","6":"2016-02-08 16:48:15","fec_resol":"2016-02-08 16:48:15","7":"36","wf_tarea_id_sig":"36","8":null,"usr_asig":null,"9":"fddf trfd: ciudadano","usr_resol":"fddf trfd: ciudadano"} {"0":"96","id":"96","1":"34","wf_caso_34_id":"34","2":"72","wf_tarea_id":"72","3":null,"core_usuario_id":null,"4":"2016-02-08 16:48:15","fec_asig":"2016-02-08 16:48:15","5":"65","core_usuario_id_resol":"65","6":"2016-02-08 16:51:34","fec_resol":"2016-02-08 16:51:34","7":"72","wf_tarea_id_sig":"72","8":null,"usr_asig":null,"9":"funcionario planeaci\u00f3n: gerente","usr_resol":"funcionario planeaci\u00f3n: gerente"} {"0":"97","id":"97","1":"34","wf_caso_34_id":"34","2":"37","wf_tarea_id":"37","3":"65","core_usuario_id":"65","4":"2016-02-08 16:51:35","fec_asig":"2016-02-08 16:51:35","5":null,"core_usuario_id_resol":null,"6":null,"fec_resol":null,"7":"37","wf_tarea_id_sig":"37","8":"funcionario planeaci\u00f3n: gerente","usr_asig":"funcionario planeaci\u00f3n: gerente","9":null,"usr_resol":null} 2016-02 08 16:54:20 cargar datos del sujeto(,,s,34,34) select s.*, m.nombre as nom_muni, c.nom_cat,fec_caso from wf_caso_34 w inner join core_sujetoverificacion s on w.id=34 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 08 16:54:20 tabla dat adic select tabla from core_sujetoverificaciontipo where id=1 2016-02 08 16:54:20 tabla :persona SELECT * FROM persona where id=58 2016-02 08 16:54:20 Continuar(,37,,s) EjecutarTarea_37() Radicación id_comp1173 65 65 ValidarUsuario(37):1 EjecutarPaso_50: form:6 , caso=34 id_comp 1173 Mostrar form Retorno : Array ( [ret] => Ext.getCmp('comp_1173').removeAll();Ext.getCmp('comp_1173').add(new Ext.form.FormPanel({ title: 'Urbanística' ,padding: 10,id:'frm_formulario_34_34',autoScroll:true ,labelAlign:'top',defaults: { anchor: '97%'} ,items: [new Ext.form.Hidden({name:'cod_formulario2',value:'6'}) ,new Ext.form.Hidden({name :'id_periodo',value:'2016'}) ,new Ext.form.Hidden({name :'obs_ingreso',value:''}) ,new Ext.form.Hidden({name:'cod_bloque',value:'7'}) ,new Ext.form.Hidden({name :'oid',value:''}) ,new Ext.form.Hidden({name :'oid_maestro',value:''}) ,{value:'',xtype:'textfield' , maxLength:30,autoCreate:{ tag:'input',maxlength:'30'} ,allowBlank:false,id:'301',fieldLabel:'* No. Predial' },{value:'',xtype:'textfield' , maxLength:30,autoCreate:{ tag:'input',maxlength:'30'} ,allowBlank:false,id:'303',fieldLabel:'* No. Radicación' },/*new Ext.form.DateField({fieldLabel:'* Fecha de la visita',name:'231',allowBlank:false,maskRe:/^[-_0-9]$/,format:FormatoFecha,renderer:Ext.util.Format.dateRenderer(FormatoFecha) }), new Ext.form.TimeField({ hiddenName:'232',id:'h_232' ,allowBlank:false,fieldLabel:'* Hora'}),*/{value:'',xtype:'textfield' , maxLength:60,autoCreate:{ tag:'input',maxlength:'60'} ,allowBlank:false,id:'233',fieldLabel:'* Clase de Predio' },{value:'',xtype:'textfield' , maxLength:60,autoCreate:{ tag:'input',maxlength:'60'} ,allowBlank:false,id:'234',fieldLabel:'* Dirección' },new Ext.form.ComboBox({fieldLabel:'*Comuna',anchor:'100%',allowBlank:false,forceSelection:true,emptyText:'Seleccione una opción',editable:true,displayField:'valor',valueField:'id',triggerAction:'all',minChars:3,store:new Ext.data.Store({autoDestroy:true,url:$view_js+"carga_comboQueryTabla.php",autoSave:false,baseParams:{'dqsl':'6', 'pro':'34', 'cas':'34'},autoLoad:false,reader:new Ext.data.JsonReader({totalProperty:'total',successProperty:'success',idProperty:'id',root:'data',messageProperty:'message'},[{name:'id'},{name:'valor'}])}),mode:'remote',queryParam:'nombre',pageSize:20,hiddenName:235,id:'inp_235',loadValor:function(val,data){this.getStore().loadData(data);this.setValue(val);}}),{value:'',xtype:'textfield' , maxLength:60,autoCreate:{ tag:'input',maxlength:'60'} ,allowBlank:false,id:'236',fieldLabel:'* Sector' },{value:'',xtype:'textfield' , maxLength:60,autoCreate:{ tag:'input',maxlength:'60'} ,allowBlank:false,id:'237',fieldLabel:'* Sección' },{value:'',xtype:'textfield' , maxLength:30,autoCreate:{ tag:'input',maxlength:'30'} ,allowBlank:false,id:'238',fieldLabel:'* Manzana' },{ xtype:'hidden',id:'hds239',disabled:true},new Ext.form.ComboBox({typeAhead:true,listeners:{ select:function(){xajax_comprobar_campoOcultoSelect(this.getValue(),239);},afterrender:function(){ xajax_comprobar_campoOcultoSelect(this.getValue(),239); }},/*fin introducir listener para campos ocultos*/triggerAction:'all',mode:'local',editable:false,emptyText:'Seleccione una opción',store:new Ext.data.ArrayStore({fields:['id', 'value'],data:[[1,'1'],[2,'2'],[3,'3'],[4,'4'],[5,'5'],[6,'6'],[7,'7'],[8,'8'],[9,'9'],[10,'10'] ]}),valueField:'id',displayField:'value',id:'inp_select_7_239',allowBlank:false,fieldLabel:'* Estrato',hiddenName:'239'}),{value:'',xtype:'textfield' , maxLength:60,autoCreate:{ tag:'input',maxlength:'60'} ,allowBlank:false,id:'240',fieldLabel:'* Suelo' },{value:'',xtype:'textfield' , maxLength:30,autoCreate:{ tag:'input',maxlength:'30'} ,allowBlank:false,id:'241',fieldLabel:'* AMH' },{value:'',xtype:'textfield' , maxLength:30,autoCreate:{ tag:'input',maxlength:'30'} ,allowBlank:false,id:'242',fieldLabel:'* Tratamiento' }, new Ext.form.TextArea({id:'304',allowBlank:false, fieldLabel:'* Observaciones',name:'304'}),new Ext.form.RadioGroup({columns:2,items:[ new Ext.form.Radio({name:'313',id:'313_1',inputValue:1,boxLabel:'Si'}), new Ext.form.Radio({name:'313',id:'313_2',inputValue:2,boxLabel:'No'}) ],columns:2,allowBlank:false,fieldLabel:'* Carta catastral',id:'313',listeners:{change:function(){var rad=Ext.getCmp('313_2').getValue();if(rad){Ext.getCmp('314').setDisabled(true);Ext.getCmp('314').setValue('');}else{Ext.getCmp('314').setDisabled(false);}}}}), new Ext.form.TextArea({id:'314',allowBlank:false, fieldLabel:'* Nombre',name:'314',disabled:true}) ] ,prepararGrids:function(){/*buscar editorgrid - grilla id compuesto, id real, mas id formulario esclavo, separado _*/var grillasF=this.findByType('editorgrid');if(grillasF && grillasF!=''){for (i=0; i < grillasF.length; i++){var xstore=grillasF[i].getStore();if(xstore.getCount()>0){var data=new Array();var xxid=grillasF[i].getId().split('_');for (j=0; j < xstore.getCount(); j++){var xreco = xstore.getAt(j); var cont_dat_vac=0,cont_tot_vac=0; for(var elem in xreco.data){cont_tot_vac++;if( xreco.data[elem] ==null || xreco.data[elem]=='' ){cont_dat_vac++;}} if(cont_dat_vac < cont_tot_vac){data[data.length]=xreco.data;data[data.length-1]['form_master_escribir_xxx']=xxid[1];}}var xfinalfin=Ext.encode(data);Ext.getCmp(xxid[0]).setValue(xfinalfin);}}}/*grabar stores en hiddens*/},tbar:[{text:'Guardar',iconCls: 'icon-disk',handler: function(){ var form = Ext.getCmp('frm_formulario_34_34'); var f=form.getForm();if(f.isValid()){var band_f=true;try{band_f =form.Validar();}catch(e){}if(band_f){form.prepararGrids();f.submit({url:'http://192.168.10.116/sisad/build/view/'+'workflow/casos/casos_l.php',params:{wf_proceso_id:'34',wf_paso_id:'50',wf_tarea_id:'37',wf_caso_id:'34',id:'1173',accion:'nextPaso',reg:'s',rta:'n'},success:function(form, action){if(action.result.message) crearMsg(action.result.message,'Informacion');else if(action.result.execute){/*try{*/eval(action.result.execute);/*}catch(e){alert(e+'Se presentó un error , por favor cierre la pestaña del caso y continue el proceso desde la pestaña de resumen' );}*/}},failure: function(form, action) {switch (action.failureType) {case Ext.form.Action.CONNECT_FAILURE:Ext.Msg.alert('Error', 'En este momento no hay comunicación con el servidor intente más tarde');break;case Ext.form.Action.SERVER_INVALID: Ext.Msg.alert('Error', action.result.message); break; }}});}}else{Ext.MessageBox.alert('Advertencia',getErrorFields(f));}} } ] ,listeners:{ afterrender:function(){ try{ Ext.getCmp('frm_formulario_34_34').getForm().loadRecord(new Ext.data.Record({"cod_formulario":6,"oid_maestro":null,"cod_bloque":7,"301":null,"303":null,"233":null,"234":null,"236":null,"237":null,"238":null,"240":null,"241":null,"242":null})); llamadaAJAX({url:'http://192.168.10.116/sisad/build/view/workflow/casos/casos_datosForm.php',mostrarMsg:false,params:{accion:'verifica',wf_paso_id:'50',cod_formulario:'6',cod_bloque:'7',wf_caso_id:'{"pro":"34","cas":"34"}'}}); }catch(e){alert(e);} } } }) );Ext.getCmp('comp_1173').doLayout(); [suc] => 1 ) fin 2016-02-08 16:54:20 /******************************************************************************************************/ 2016-02-08 16:54:21TraerCaso(34,34,) CargarCaso :34 2016-02 08 16:54:21 CargarDatos: Caso :34 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_34_seguimiento_id,wf_paso_id from wf_caso_34_pasos a1 group by wf_caso_34_seguimiento_id,wf_paso_id order by id )a inner join wf_caso_34_pasos p using(id,wf_caso_34_seguimiento_id) inner join ( select max(id) as wf_caso_34_seguimiento_id,wf_caso_34_id,wf_tarea_id from wf_caso_34_seguimiento where wf_caso_34_id =? group by wf_caso_34_id,wf_tarea_id order by wf_caso_34_id,wf_caso_34_seguimiento_id ) b using(wf_caso_34_seguimiento_id) left join usuarios u using(core_usuario_id) {"0":"156","id":"156","1":"46","wf_paso_id":"46","2":"95","wf_caso_34_seguimiento_id":"95","3":"28","core_usuario_id":"28","4":"2016-02-08 16:45:50","fecha_ejec":"2016-02-08 16:45:50","5":"27","dato":"27","6":"sce.t5","tabla":"sce.t5","7":"36","tarea_id":"36","8":"fddf trfd: ciudadano","usr_ejec":"fddf trfd: ciudadano"} CargarDatos_46(27) se carga 34_36_46_5_6_302 se carga 34_36_46_5_6_228 se carga 34_36_46_5_6_227301 se carga 34_36_46_5_6_226kkk se carga 34_36_46_5_6_225 se carga 34_36_46_5_6_2222016-02-08 {"0":"157","id":"157","1":"47","wf_paso_id":"47","2":"95","wf_caso_34_seguimiento_id":"95","3":"28","core_usuario_id":"28","4":"2016-02-08 16:48:13","fecha_ejec":"2016-02-08 16:48:13","5":"6848","dato":"6848","6":"wf_documentoentradaadj_caso","tabla":"wf_documentoentradaadj_caso","7":"36","tarea_id":"36","8":"fddf trfd: ciudadano","usr_ejec":"fddf trfd: ciudadano"} CargarDatos_47(6848) {"0":"158","id":"158","1":"118","wf_paso_id":"118","2":"95","wf_caso_34_seguimiento_id":"95","3":"28","core_usuario_id":"28","4":"2016-02-08 16:48:15","fecha_ejec":"2016-02-08 16:48:15","5":null,"dato":null,"6":null,"tabla":null,"7":"36","tarea_id":"36","8":"fddf trfd: ciudadano","usr_ejec":"fddf trfd: ciudadano"} CargarDatos_118() {"0":"159","id":"159","1":"161","wf_paso_id":"161","2":"96","wf_caso_34_seguimiento_id":"96","3":"65","core_usuario_id":"65","4":"2016-02-08 16:51:34","fecha_ejec":"2016-02-08 16:51:34","5":"2715","dato":"2715","6":"wf_documentoentradaadj_caso","tabla":"wf_documentoentradaadj_caso","7":"72","tarea_id":"72","8":"funcionario planeaci\u00f3n: gerente","usr_ejec":"funcionario planeaci\u00f3n: gerente"} CargarDatos_161(2715) 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_34_seguimiento a inner join ( select max(b0.id) as id,b0.wf_caso_34_id,b0.wf_tarea_id from wf_caso_34_seguimiento b0 where b0.wf_caso_34_id =? group by b0.wf_caso_34_id,b0.wf_tarea_id order by wf_caso_34_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":"95","id":"95","1":"34","wf_caso_34_id":"34","2":"36","wf_tarea_id":"36","3":null,"core_usuario_id":null,"4":"2016-02-08 16:44:36","fec_asig":"2016-02-08 16:44:36","5":"28","core_usuario_id_resol":"28","6":"2016-02-08 16:48:15","fec_resol":"2016-02-08 16:48:15","7":"36","wf_tarea_id_sig":"36","8":null,"usr_asig":null,"9":"fddf trfd: ciudadano","usr_resol":"fddf trfd: ciudadano"} {"0":"96","id":"96","1":"34","wf_caso_34_id":"34","2":"72","wf_tarea_id":"72","3":null,"core_usuario_id":null,"4":"2016-02-08 16:48:15","fec_asig":"2016-02-08 16:48:15","5":"65","core_usuario_id_resol":"65","6":"2016-02-08 16:51:34","fec_resol":"2016-02-08 16:51:34","7":"72","wf_tarea_id_sig":"72","8":null,"usr_asig":null,"9":"funcionario planeaci\u00f3n: gerente","usr_resol":"funcionario planeaci\u00f3n: gerente"} {"0":"97","id":"97","1":"34","wf_caso_34_id":"34","2":"37","wf_tarea_id":"37","3":"65","core_usuario_id":"65","4":"2016-02-08 16:51:35","fec_asig":"2016-02-08 16:51:35","5":null,"core_usuario_id_resol":null,"6":null,"fec_resol":null,"7":"37","wf_tarea_id_sig":"37","8":"funcionario planeaci\u00f3n: gerente","usr_asig":"funcionario planeaci\u00f3n: gerente","9":null,"usr_resol":null} 2016-02 08 16:54:21 cargar datos del sujeto(,,s,34,34) select s.*, m.nombre as nom_muni, c.nom_cat,fec_caso from wf_caso_34 w inner join core_sujetoverificacion s on w.id=34 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 08 16:54:21 tabla dat adic select tabla from core_sujetoverificaciontipo where id=1 2016-02 08 16:54:21 tabla :persona SELECT * FROM persona where id=58 fin 2016-02-08 16:54:21 /******************************************************************************************************/ 2016-02-08 16:56:02TraerCaso(34,34,) CargarCaso :34 2016-02 08 16:56:02 CargarDatos: Caso :34 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_34_seguimiento_id,wf_paso_id from wf_caso_34_pasos a1 group by wf_caso_34_seguimiento_id,wf_paso_id order by id )a inner join wf_caso_34_pasos p using(id,wf_caso_34_seguimiento_id) inner join ( select max(id) as wf_caso_34_seguimiento_id,wf_caso_34_id,wf_tarea_id from wf_caso_34_seguimiento where wf_caso_34_id =? group by wf_caso_34_id,wf_tarea_id order by wf_caso_34_id,wf_caso_34_seguimiento_id ) b using(wf_caso_34_seguimiento_id) left join usuarios u using(core_usuario_id) {"0":"156","id":"156","1":"46","wf_paso_id":"46","2":"95","wf_caso_34_seguimiento_id":"95","3":"28","core_usuario_id":"28","4":"2016-02-08 16:45:50","fecha_ejec":"2016-02-08 16:45:50","5":"27","dato":"27","6":"sce.t5","tabla":"sce.t5","7":"36","tarea_id":"36","8":"fddf trfd: ciudadano","usr_ejec":"fddf trfd: ciudadano"} CargarDatos_46(27) se carga 34_36_46_5_6_302 se carga 34_36_46_5_6_228 se carga 34_36_46_5_6_227301 se carga 34_36_46_5_6_226kkk se carga 34_36_46_5_6_225 se carga 34_36_46_5_6_2222016-02-08 {"0":"157","id":"157","1":"47","wf_paso_id":"47","2":"95","wf_caso_34_seguimiento_id":"95","3":"28","core_usuario_id":"28","4":"2016-02-08 16:48:13","fecha_ejec":"2016-02-08 16:48:13","5":"6848","dato":"6848","6":"wf_documentoentradaadj_caso","tabla":"wf_documentoentradaadj_caso","7":"36","tarea_id":"36","8":"fddf trfd: ciudadano","usr_ejec":"fddf trfd: ciudadano"} CargarDatos_47(6848) {"0":"158","id":"158","1":"118","wf_paso_id":"118","2":"95","wf_caso_34_seguimiento_id":"95","3":"28","core_usuario_id":"28","4":"2016-02-08 16:48:15","fecha_ejec":"2016-02-08 16:48:15","5":null,"dato":null,"6":null,"tabla":null,"7":"36","tarea_id":"36","8":"fddf trfd: ciudadano","usr_ejec":"fddf trfd: ciudadano"} CargarDatos_118() {"0":"159","id":"159","1":"161","wf_paso_id":"161","2":"96","wf_caso_34_seguimiento_id":"96","3":"65","core_usuario_id":"65","4":"2016-02-08 16:51:34","fecha_ejec":"2016-02-08 16:51:34","5":"2715","dato":"2715","6":"wf_documentoentradaadj_caso","tabla":"wf_documentoentradaadj_caso","7":"72","tarea_id":"72","8":"funcionario planeaci\u00f3n: gerente","usr_ejec":"funcionario planeaci\u00f3n: gerente"} CargarDatos_161(2715) 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_34_seguimiento a inner join ( select max(b0.id) as id,b0.wf_caso_34_id,b0.wf_tarea_id from wf_caso_34_seguimiento b0 where b0.wf_caso_34_id =? group by b0.wf_caso_34_id,b0.wf_tarea_id order by wf_caso_34_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":"95","id":"95","1":"34","wf_caso_34_id":"34","2":"36","wf_tarea_id":"36","3":null,"core_usuario_id":null,"4":"2016-02-08 16:44:36","fec_asig":"2016-02-08 16:44:36","5":"28","core_usuario_id_resol":"28","6":"2016-02-08 16:48:15","fec_resol":"2016-02-08 16:48:15","7":"36","wf_tarea_id_sig":"36","8":null,"usr_asig":null,"9":"fddf trfd: ciudadano","usr_resol":"fddf trfd: ciudadano"} {"0":"96","id":"96","1":"34","wf_caso_34_id":"34","2":"72","wf_tarea_id":"72","3":null,"core_usuario_id":null,"4":"2016-02-08 16:48:15","fec_asig":"2016-02-08 16:48:15","5":"65","core_usuario_id_resol":"65","6":"2016-02-08 16:51:34","fec_resol":"2016-02-08 16:51:34","7":"72","wf_tarea_id_sig":"72","8":null,"usr_asig":null,"9":"funcionario planeaci\u00f3n: gerente","usr_resol":"funcionario planeaci\u00f3n: gerente"} {"0":"97","id":"97","1":"34","wf_caso_34_id":"34","2":"37","wf_tarea_id":"37","3":"65","core_usuario_id":"65","4":"2016-02-08 16:51:35","fec_asig":"2016-02-08 16:51:35","5":null,"core_usuario_id_resol":null,"6":null,"fec_resol":null,"7":"37","wf_tarea_id_sig":"37","8":"funcionario planeaci\u00f3n: gerente","usr_asig":"funcionario planeaci\u00f3n: gerente","9":null,"usr_resol":null} 2016-02 08 16:56:02 cargar datos del sujeto(,,s,34,34) select s.*, m.nombre as nom_muni, c.nom_cat,fec_caso from wf_caso_34 w inner join core_sujetoverificacion s on w.id=34 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 08 16:56:02 tabla dat adic select tabla from core_sujetoverificaciontipo where id=1 2016-02 08 16:56:02 tabla :persona SELECT * FROM persona where id=58 2016-02 08 16:56:02 Continuar(s,37,50,) EjecutarTarea_37() Radicación id_comp1173 65 65 ValidarUsuario(37):1 EjecutarPaso_50: form:6 , caso=34 id_comp 1173 Paso::Guardar(Caso:34) Datos a guardar: Array ( [wf_proceso_id] => 34 [wf_paso_id] => 50 [wf_tarea_id] => 37 [wf_caso_id] => 34 [id] => 1173 [accion] => nextPaso [reg] => s [rta] => n [cod_formulario2] => 6 [id_periodo] => 2016 [obs_ingreso] => [cod_bloque] => 7 [oid] => [oid_maestro] => [301] => 5958 [303] => 44 [233] => kk [234] => cc [235] => 5 [236] => jjjq [237] => jj [238] => 8 [239] => 2 [240] => fertil [241] => dd [242] => ss [304] => sddfada [313] => 1 [314] => fsdadada ) OID: 16 rta: 1 dato:16 tabla:sce.t6 CasoPaso:160 CargarDatos_50(16) se carga 34_37_50_6_7_314fsdadada se carga 34_37_50_6_7_3131 se carga 34_37_50_6_7_304sddfada se carga 34_37_50_6_7_30344 se carga 34_37_50_6_7_3015958 se carga 34_37_50_6_7_242ss se carga 34_37_50_6_7_241dd se carga 34_37_50_6_7_240fertil se carga 34_37_50_6_7_2392 se carga 34_37_50_6_7_2388 se carga 34_37_50_6_7_237jj se carga 34_37_50_6_7_236jjjq se carga 34_37_50_6_7_2355 se carga 34_37_50_6_7_234cc se carga 34_37_50_6_7_233kk se carga 34_37_50_6_7_232 se carga 34_37_50_6_7_231 SiguientePasoDe50: Funcion para ejecutar el siguiente paso EjecutarPaso_120: corr:41 , caso=34 id_comp 1173 Mostrar corr ob_start(); $ciud = mb_strtoupper( "{ WFSV_2 } { WFSV_3 }",'utf-8'); ?>

Apreciado(a)

El presente mensaje es una notificación para el caso No

inicioComponente_WF_Correo({"id":"1173","caso_id":"34","proceso_id":34,"tit":"Radicación","tarea_id":37,"paso_id":120,"desc":"

\nApreciado(a)
\nTRFD FDDF<\/strong>\n

\n

El presente mensaje es una notificación para el caso No 34<\/strong> <\/p>\nSu solicitud de concepto de norma urban\u00edstica se encuentra Radicada.<\/strong> ","url":"De clic aquí para volver a enviar el correo<\/a><\/div>"}); [suc] => 1 ) fin 2016-02-08 16:56:03 /******************************************************************************************************/ 2016-02-08 16:56:11TraerCaso(34,34,) CargarCaso :34 2016-02 08 16:56:11 CargarDatos: Caso :34 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_34_seguimiento_id,wf_paso_id from wf_caso_34_pasos a1 group by wf_caso_34_seguimiento_id,wf_paso_id order by id )a inner join wf_caso_34_pasos p using(id,wf_caso_34_seguimiento_id) inner join ( select max(id) as wf_caso_34_seguimiento_id,wf_caso_34_id,wf_tarea_id from wf_caso_34_seguimiento where wf_caso_34_id =? group by wf_caso_34_id,wf_tarea_id order by wf_caso_34_id,wf_caso_34_seguimiento_id ) b using(wf_caso_34_seguimiento_id) left join usuarios u using(core_usuario_id) {"0":"156","id":"156","1":"46","wf_paso_id":"46","2":"95","wf_caso_34_seguimiento_id":"95","3":"28","core_usuario_id":"28","4":"2016-02-08 16:45:50","fecha_ejec":"2016-02-08 16:45:50","5":"27","dato":"27","6":"sce.t5","tabla":"sce.t5","7":"36","tarea_id":"36","8":"fddf trfd: ciudadano","usr_ejec":"fddf trfd: ciudadano"} CargarDatos_46(27) se carga 34_36_46_5_6_302 se carga 34_36_46_5_6_228 se carga 34_36_46_5_6_227301 se carga 34_36_46_5_6_226kkk se carga 34_36_46_5_6_225 se carga 34_36_46_5_6_2222016-02-08 {"0":"157","id":"157","1":"47","wf_paso_id":"47","2":"95","wf_caso_34_seguimiento_id":"95","3":"28","core_usuario_id":"28","4":"2016-02-08 16:48:13","fecha_ejec":"2016-02-08 16:48:13","5":"6848","dato":"6848","6":"wf_documentoentradaadj_caso","tabla":"wf_documentoentradaadj_caso","7":"36","tarea_id":"36","8":"fddf trfd: ciudadano","usr_ejec":"fddf trfd: ciudadano"} CargarDatos_47(6848) {"0":"158","id":"158","1":"118","wf_paso_id":"118","2":"95","wf_caso_34_seguimiento_id":"95","3":"28","core_usuario_id":"28","4":"2016-02-08 16:48:15","fecha_ejec":"2016-02-08 16:48:15","5":null,"dato":null,"6":null,"tabla":null,"7":"36","tarea_id":"36","8":"fddf trfd: ciudadano","usr_ejec":"fddf trfd: ciudadano"} CargarDatos_118() {"0":"159","id":"159","1":"161","wf_paso_id":"161","2":"96","wf_caso_34_seguimiento_id":"96","3":"65","core_usuario_id":"65","4":"2016-02-08 16:51:34","fecha_ejec":"2016-02-08 16:51:34","5":"2715","dato":"2715","6":"wf_documentoentradaadj_caso","tabla":"wf_documentoentradaadj_caso","7":"72","tarea_id":"72","8":"funcionario planeaci\u00f3n: gerente","usr_ejec":"funcionario planeaci\u00f3n: gerente"} CargarDatos_161(2715) {"0":"160","id":"160","1":"50","wf_paso_id":"50","2":"97","wf_caso_34_seguimiento_id":"97","3":"65","core_usuario_id":"65","4":"2016-02-08 16:56:03","fecha_ejec":"2016-02-08 16:56:03","5":"16","dato":"16","6":"sce.t6","tabla":"sce.t6","7":"37","tarea_id":"37","8":"funcionario planeaci\u00f3n: gerente","usr_ejec":"funcionario planeaci\u00f3n: gerente"} CargarDatos_50(16) se carga 34_37_50_6_7_314 se carga 34_37_50_6_7_313 se carga 34_37_50_6_7_304 se carga 34_37_50_6_7_303 se carga 34_37_50_6_7_301 se carga 34_37_50_6_7_242 se carga 34_37_50_6_7_241 se carga 34_37_50_6_7_240 se carga 34_37_50_6_7_239 se carga 34_37_50_6_7_238 se carga 34_37_50_6_7_237 se carga 34_37_50_6_7_236 se carga 34_37_50_6_7_235 se carga 34_37_50_6_7_234 se carga 34_37_50_6_7_233 se carga 34_37_50_6_7_232 se carga 34_37_50_6_7_231 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_34_seguimiento a inner join ( select max(b0.id) as id,b0.wf_caso_34_id,b0.wf_tarea_id from wf_caso_34_seguimiento b0 where b0.wf_caso_34_id =? group by b0.wf_caso_34_id,b0.wf_tarea_id order by wf_caso_34_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":"95","id":"95","1":"34","wf_caso_34_id":"34","2":"36","wf_tarea_id":"36","3":null,"core_usuario_id":null,"4":"2016-02-08 16:44:36","fec_asig":"2016-02-08 16:44:36","5":"28","core_usuario_id_resol":"28","6":"2016-02-08 16:48:15","fec_resol":"2016-02-08 16:48:15","7":"36","wf_tarea_id_sig":"36","8":null,"usr_asig":null,"9":"fddf trfd: ciudadano","usr_resol":"fddf trfd: ciudadano"} {"0":"96","id":"96","1":"34","wf_caso_34_id":"34","2":"72","wf_tarea_id":"72","3":null,"core_usuario_id":null,"4":"2016-02-08 16:48:15","fec_asig":"2016-02-08 16:48:15","5":"65","core_usuario_id_resol":"65","6":"2016-02-08 16:51:34","fec_resol":"2016-02-08 16:51:34","7":"72","wf_tarea_id_sig":"72","8":null,"usr_asig":null,"9":"funcionario planeaci\u00f3n: gerente","usr_resol":"funcionario planeaci\u00f3n: gerente"} {"0":"97","id":"97","1":"34","wf_caso_34_id":"34","2":"37","wf_tarea_id":"37","3":"65","core_usuario_id":"65","4":"2016-02-08 16:51:35","fec_asig":"2016-02-08 16:51:35","5":null,"core_usuario_id_resol":null,"6":null,"fec_resol":null,"7":"37","wf_tarea_id_sig":"37","8":"funcionario planeaci\u00f3n: gerente","usr_asig":"funcionario planeaci\u00f3n: gerente","9":null,"usr_resol":null} 2016-02 08 16:56:11 cargar datos del sujeto(,,s,34,34) select s.*, m.nombre as nom_muni, c.nom_cat,fec_caso from wf_caso_34 w inner join core_sujetoverificacion s on w.id=34 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 08 16:56:11 tabla dat adic select tabla from core_sujetoverificaciontipo where id=1 2016-02 08 16:56:11 tabla :persona SELECT * FROM persona where id=58 2016-02 08 16:56:11 Continuar(s,37,120,) EjecutarTarea_37() Radicación id_comp1173 65 65 ValidarUsuario(37):1 EjecutarPaso_120: corr:41 , caso=34 id_comp 1173 Paso::Guardar(Caso:34) rta: 1 dato: tabla: CasoPaso:161 CargarDatos_120() SiguientePasoDe120: Funcion para ejecutar el siguiente paso Condicion Tarea : true TerminarTarea(37,38) Ultimo seg :97 Ultimo seg :98 EjecutarTarea_38() Documento de entrada id_comp1173 65 65 ValidarUsuario(38):1 EjecutarPaso_48: ladj:69 , caso=34 id_comp 1173 Mostrar ladj Retorno : Array ( [ret] => inicioComponente_WF_ladj({"tarea_id":38,"paso_id":48,"id":"1173","proceso_id":34,"caso_id":"34","sujeto_id":"58","ladj":69}); [suc] => 1 ) fin 2016-02-08 16:56:11 /******************************************************************************************************/ 2016-02-08 16:56:25TraerCaso(34,34,) CargarCaso :34 2016-02 08 16:56:25 CargarDatos: Caso :34 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_34_seguimiento_id,wf_paso_id from wf_caso_34_pasos a1 group by wf_caso_34_seguimiento_id,wf_paso_id order by id )a inner join wf_caso_34_pasos p using(id,wf_caso_34_seguimiento_id) inner join ( select max(id) as wf_caso_34_seguimiento_id,wf_caso_34_id,wf_tarea_id from wf_caso_34_seguimiento where wf_caso_34_id =? group by wf_caso_34_id,wf_tarea_id order by wf_caso_34_id,wf_caso_34_seguimiento_id ) b using(wf_caso_34_seguimiento_id) left join usuarios u using(core_usuario_id) {"0":"156","id":"156","1":"46","wf_paso_id":"46","2":"95","wf_caso_34_seguimiento_id":"95","3":"28","core_usuario_id":"28","4":"2016-02-08 16:45:50","fecha_ejec":"2016-02-08 16:45:50","5":"27","dato":"27","6":"sce.t5","tabla":"sce.t5","7":"36","tarea_id":"36","8":"fddf trfd: ciudadano","usr_ejec":"fddf trfd: ciudadano"} CargarDatos_46(27) se carga 34_36_46_5_6_302 se carga 34_36_46_5_6_228 se carga 34_36_46_5_6_227301 se carga 34_36_46_5_6_226kkk se carga 34_36_46_5_6_225 se carga 34_36_46_5_6_2222016-02-08 {"0":"157","id":"157","1":"47","wf_paso_id":"47","2":"95","wf_caso_34_seguimiento_id":"95","3":"28","core_usuario_id":"28","4":"2016-02-08 16:48:13","fecha_ejec":"2016-02-08 16:48:13","5":"6848","dato":"6848","6":"wf_documentoentradaadj_caso","tabla":"wf_documentoentradaadj_caso","7":"36","tarea_id":"36","8":"fddf trfd: ciudadano","usr_ejec":"fddf trfd: ciudadano"} CargarDatos_47(6848) {"0":"158","id":"158","1":"118","wf_paso_id":"118","2":"95","wf_caso_34_seguimiento_id":"95","3":"28","core_usuario_id":"28","4":"2016-02-08 16:48:15","fecha_ejec":"2016-02-08 16:48:15","5":null,"dato":null,"6":null,"tabla":null,"7":"36","tarea_id":"36","8":"fddf trfd: ciudadano","usr_ejec":"fddf trfd: ciudadano"} CargarDatos_118() {"0":"159","id":"159","1":"161","wf_paso_id":"161","2":"96","wf_caso_34_seguimiento_id":"96","3":"65","core_usuario_id":"65","4":"2016-02-08 16:51:34","fecha_ejec":"2016-02-08 16:51:34","5":"2715","dato":"2715","6":"wf_documentoentradaadj_caso","tabla":"wf_documentoentradaadj_caso","7":"72","tarea_id":"72","8":"funcionario planeaci\u00f3n: gerente","usr_ejec":"funcionario planeaci\u00f3n: gerente"} CargarDatos_161(2715) {"0":"160","id":"160","1":"50","wf_paso_id":"50","2":"97","wf_caso_34_seguimiento_id":"97","3":"65","core_usuario_id":"65","4":"2016-02-08 16:56:03","fecha_ejec":"2016-02-08 16:56:03","5":"16","dato":"16","6":"sce.t6","tabla":"sce.t6","7":"37","tarea_id":"37","8":"funcionario planeaci\u00f3n: gerente","usr_ejec":"funcionario planeaci\u00f3n: gerente"} CargarDatos_50(16) se carga 34_37_50_6_7_314 se carga 34_37_50_6_7_313 se carga 34_37_50_6_7_304 se carga 34_37_50_6_7_303 se carga 34_37_50_6_7_301 se carga 34_37_50_6_7_242 se carga 34_37_50_6_7_241 se carga 34_37_50_6_7_240 se carga 34_37_50_6_7_239 se carga 34_37_50_6_7_238 se carga 34_37_50_6_7_237 se carga 34_37_50_6_7_236 se carga 34_37_50_6_7_235 se carga 34_37_50_6_7_234 se carga 34_37_50_6_7_233 se carga 34_37_50_6_7_232 se carga 34_37_50_6_7_231 {"0":"161","id":"161","1":"120","wf_paso_id":"120","2":"97","wf_caso_34_seguimiento_id":"97","3":"65","core_usuario_id":"65","4":"2016-02-08 16:56:11","fecha_ejec":"2016-02-08 16:56:11","5":null,"dato":null,"6":null,"tabla":null,"7":"37","tarea_id":"37","8":"funcionario planeaci\u00f3n: gerente","usr_ejec":"funcionario planeaci\u00f3n: gerente"} CargarDatos_120() 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_34_seguimiento a inner join ( select max(b0.id) as id,b0.wf_caso_34_id,b0.wf_tarea_id from wf_caso_34_seguimiento b0 where b0.wf_caso_34_id =? group by b0.wf_caso_34_id,b0.wf_tarea_id order by wf_caso_34_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":"95","id":"95","1":"34","wf_caso_34_id":"34","2":"36","wf_tarea_id":"36","3":null,"core_usuario_id":null,"4":"2016-02-08 16:44:36","fec_asig":"2016-02-08 16:44:36","5":"28","core_usuario_id_resol":"28","6":"2016-02-08 16:48:15","fec_resol":"2016-02-08 16:48:15","7":"36","wf_tarea_id_sig":"36","8":null,"usr_asig":null,"9":"fddf trfd: ciudadano","usr_resol":"fddf trfd: ciudadano"} {"0":"96","id":"96","1":"34","wf_caso_34_id":"34","2":"72","wf_tarea_id":"72","3":null,"core_usuario_id":null,"4":"2016-02-08 16:48:15","fec_asig":"2016-02-08 16:48:15","5":"65","core_usuario_id_resol":"65","6":"2016-02-08 16:51:34","fec_resol":"2016-02-08 16:51:34","7":"72","wf_tarea_id_sig":"72","8":null,"usr_asig":null,"9":"funcionario planeaci\u00f3n: gerente","usr_resol":"funcionario planeaci\u00f3n: gerente"} {"0":"97","id":"97","1":"34","wf_caso_34_id":"34","2":"37","wf_tarea_id":"37","3":"65","core_usuario_id":"65","4":"2016-02-08 16:51:35","fec_asig":"2016-02-08 16:51:35","5":"65","core_usuario_id_resol":"65","6":"2016-02-08 16:56:11","fec_resol":"2016-02-08 16:56:11","7":"37","wf_tarea_id_sig":"37","8":"funcionario planeaci\u00f3n: gerente","usr_asig":"funcionario planeaci\u00f3n: gerente","9":"funcionario planeaci\u00f3n: gerente","usr_resol":"funcionario planeaci\u00f3n: gerente"} {"0":"98","id":"98","1":"34","wf_caso_34_id":"34","2":"38","wf_tarea_id":"38","3":"65","core_usuario_id":"65","4":"2016-02-08 16:56:11","fec_asig":"2016-02-08 16:56:11","5":null,"core_usuario_id_resol":null,"6":null,"fec_resol":null,"7":"38","wf_tarea_id_sig":"38","8":"funcionario planeaci\u00f3n: gerente","usr_asig":"funcionario planeaci\u00f3n: gerente","9":null,"usr_resol":null} 2016-02 08 16:56:25 cargar datos del sujeto(,,s,34,34) select s.*, m.nombre as nom_muni, c.nom_cat,fec_caso from wf_caso_34 w inner join core_sujetoverificacion s on w.id=34 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 08 16:56:25 tabla dat adic select tabla from core_sujetoverificaciontipo where id=1 2016-02 08 16:56:25 tabla :persona SELECT * FROM persona where id=58 2016-02 08 16:56:25 Continuar(s,38,48,) EjecutarTarea_38() Documento de entrada id_comp1173 65 65 ValidarUsuario(38):1 EjecutarPaso_48: ladj:69 , caso=34 id_comp 1173 Paso::Guardar(Caso:34) rta: 1 dato:6854 tabla:wf_documentoentradaadj_caso CasoPaso:162 CargarDatos_48(6854) SiguientePasoDe48: Funcion para ejecutar el siguiente paso Condicion Tarea : true TerminarTarea(38,39) Ultimo seg :98 Ultimo seg :99 EjecutarTarea_39() Notificación id_comp1173 65 65 ValidarUsuario(39):1 EjecutarPaso_49: eval:0 , caso=34 id_comp 1173 Mostrar eval Retorno : Array ( [ret] => inicioComponente_WF_Evaluar({"tarea_id":39,"paso_id":49,"id":"1173","proceso_id":34,"caso_id":"34","sujeto_id":"58"}); [suc] => 1 ) fin 2016-02-08 16:56:25 /******************************************************************************************************/ 2016-02-08 16:56:25TraerCaso(34,34,) CargarCaso :34 2016-02 08 16:56:25 CargarDatos: Caso :34 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_34_seguimiento_id,wf_paso_id from wf_caso_34_pasos a1 group by wf_caso_34_seguimiento_id,wf_paso_id order by id )a inner join wf_caso_34_pasos p using(id,wf_caso_34_seguimiento_id) inner join ( select max(id) as wf_caso_34_seguimiento_id,wf_caso_34_id,wf_tarea_id from wf_caso_34_seguimiento where wf_caso_34_id =? group by wf_caso_34_id,wf_tarea_id order by wf_caso_34_id,wf_caso_34_seguimiento_id ) b using(wf_caso_34_seguimiento_id) left join usuarios u using(core_usuario_id) {"0":"156","id":"156","1":"46","wf_paso_id":"46","2":"95","wf_caso_34_seguimiento_id":"95","3":"28","core_usuario_id":"28","4":"2016-02-08 16:45:50","fecha_ejec":"2016-02-08 16:45:50","5":"27","dato":"27","6":"sce.t5","tabla":"sce.t5","7":"36","tarea_id":"36","8":"fddf trfd: ciudadano","usr_ejec":"fddf trfd: ciudadano"} CargarDatos_46(27) se carga 34_36_46_5_6_302 se carga 34_36_46_5_6_228 se carga 34_36_46_5_6_227301 se carga 34_36_46_5_6_226kkk se carga 34_36_46_5_6_225 se carga 34_36_46_5_6_2222016-02-08 {"0":"157","id":"157","1":"47","wf_paso_id":"47","2":"95","wf_caso_34_seguimiento_id":"95","3":"28","core_usuario_id":"28","4":"2016-02-08 16:48:13","fecha_ejec":"2016-02-08 16:48:13","5":"6848","dato":"6848","6":"wf_documentoentradaadj_caso","tabla":"wf_documentoentradaadj_caso","7":"36","tarea_id":"36","8":"fddf trfd: ciudadano","usr_ejec":"fddf trfd: ciudadano"} CargarDatos_47(6848) {"0":"158","id":"158","1":"118","wf_paso_id":"118","2":"95","wf_caso_34_seguimiento_id":"95","3":"28","core_usuario_id":"28","4":"2016-02-08 16:48:15","fecha_ejec":"2016-02-08 16:48:15","5":null,"dato":null,"6":null,"tabla":null,"7":"36","tarea_id":"36","8":"fddf trfd: ciudadano","usr_ejec":"fddf trfd: ciudadano"} CargarDatos_118() {"0":"159","id":"159","1":"161","wf_paso_id":"161","2":"96","wf_caso_34_seguimiento_id":"96","3":"65","core_usuario_id":"65","4":"2016-02-08 16:51:34","fecha_ejec":"2016-02-08 16:51:34","5":"2715","dato":"2715","6":"wf_documentoentradaadj_caso","tabla":"wf_documentoentradaadj_caso","7":"72","tarea_id":"72","8":"funcionario planeaci\u00f3n: gerente","usr_ejec":"funcionario planeaci\u00f3n: gerente"} CargarDatos_161(2715) {"0":"160","id":"160","1":"50","wf_paso_id":"50","2":"97","wf_caso_34_seguimiento_id":"97","3":"65","core_usuario_id":"65","4":"2016-02-08 16:56:03","fecha_ejec":"2016-02-08 16:56:03","5":"16","dato":"16","6":"sce.t6","tabla":"sce.t6","7":"37","tarea_id":"37","8":"funcionario planeaci\u00f3n: gerente","usr_ejec":"funcionario planeaci\u00f3n: gerente"} CargarDatos_50(16) se carga 34_37_50_6_7_314 se carga 34_37_50_6_7_313 se carga 34_37_50_6_7_304 se carga 34_37_50_6_7_303 se carga 34_37_50_6_7_301 se carga 34_37_50_6_7_242 se carga 34_37_50_6_7_241 se carga 34_37_50_6_7_240 se carga 34_37_50_6_7_239 se carga 34_37_50_6_7_238 se carga 34_37_50_6_7_237 se carga 34_37_50_6_7_236 se carga 34_37_50_6_7_235 se carga 34_37_50_6_7_234 se carga 34_37_50_6_7_233 se carga 34_37_50_6_7_232 se carga 34_37_50_6_7_231 {"0":"161","id":"161","1":"120","wf_paso_id":"120","2":"97","wf_caso_34_seguimiento_id":"97","3":"65","core_usuario_id":"65","4":"2016-02-08 16:56:11","fecha_ejec":"2016-02-08 16:56:11","5":null,"dato":null,"6":null,"tabla":null,"7":"37","tarea_id":"37","8":"funcionario planeaci\u00f3n: gerente","usr_ejec":"funcionario planeaci\u00f3n: gerente"} CargarDatos_120() {"0":"162","id":"162","1":"48","wf_paso_id":"48","2":"98","wf_caso_34_seguimiento_id":"98","3":"65","core_usuario_id":"65","4":"2016-02-08 16:56:25","fecha_ejec":"2016-02-08 16:56:25","5":"6854","dato":"6854","6":"wf_documentoentradaadj_caso","tabla":"wf_documentoentradaadj_caso","7":"38","tarea_id":"38","8":"funcionario planeaci\u00f3n: gerente","usr_ejec":"funcionario planeaci\u00f3n: gerente"} CargarDatos_48(6854) 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_34_seguimiento a inner join ( select max(b0.id) as id,b0.wf_caso_34_id,b0.wf_tarea_id from wf_caso_34_seguimiento b0 where b0.wf_caso_34_id =? group by b0.wf_caso_34_id,b0.wf_tarea_id order by wf_caso_34_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":"95","id":"95","1":"34","wf_caso_34_id":"34","2":"36","wf_tarea_id":"36","3":null,"core_usuario_id":null,"4":"2016-02-08 16:44:36","fec_asig":"2016-02-08 16:44:36","5":"28","core_usuario_id_resol":"28","6":"2016-02-08 16:48:15","fec_resol":"2016-02-08 16:48:15","7":"36","wf_tarea_id_sig":"36","8":null,"usr_asig":null,"9":"fddf trfd: ciudadano","usr_resol":"fddf trfd: ciudadano"} {"0":"96","id":"96","1":"34","wf_caso_34_id":"34","2":"72","wf_tarea_id":"72","3":null,"core_usuario_id":null,"4":"2016-02-08 16:48:15","fec_asig":"2016-02-08 16:48:15","5":"65","core_usuario_id_resol":"65","6":"2016-02-08 16:51:34","fec_resol":"2016-02-08 16:51:34","7":"72","wf_tarea_id_sig":"72","8":null,"usr_asig":null,"9":"funcionario planeaci\u00f3n: gerente","usr_resol":"funcionario planeaci\u00f3n: gerente"} {"0":"97","id":"97","1":"34","wf_caso_34_id":"34","2":"37","wf_tarea_id":"37","3":"65","core_usuario_id":"65","4":"2016-02-08 16:51:35","fec_asig":"2016-02-08 16:51:35","5":"65","core_usuario_id_resol":"65","6":"2016-02-08 16:56:11","fec_resol":"2016-02-08 16:56:11","7":"37","wf_tarea_id_sig":"37","8":"funcionario planeaci\u00f3n: gerente","usr_asig":"funcionario planeaci\u00f3n: gerente","9":"funcionario planeaci\u00f3n: gerente","usr_resol":"funcionario planeaci\u00f3n: gerente"} {"0":"98","id":"98","1":"34","wf_caso_34_id":"34","2":"38","wf_tarea_id":"38","3":"65","core_usuario_id":"65","4":"2016-02-08 16:56:11","fec_asig":"2016-02-08 16:56:11","5":"65","core_usuario_id_resol":"65","6":"2016-02-08 16:56:25","fec_resol":"2016-02-08 16:56:25","7":"38","wf_tarea_id_sig":"38","8":"funcionario planeaci\u00f3n: gerente","usr_asig":"funcionario planeaci\u00f3n: gerente","9":"funcionario planeaci\u00f3n: gerente","usr_resol":"funcionario planeaci\u00f3n: gerente"} {"0":"99","id":"99","1":"34","wf_caso_34_id":"34","2":"39","wf_tarea_id":"39","3":"65","core_usuario_id":"65","4":"2016-02-08 16:56:25","fec_asig":"2016-02-08 16:56:25","5":null,"core_usuario_id_resol":null,"6":null,"fec_resol":null,"7":"39","wf_tarea_id_sig":"39","8":"funcionario planeaci\u00f3n: gerente","usr_asig":"funcionario planeaci\u00f3n: gerente","9":null,"usr_resol":null} 2016-02 08 16:56:25 cargar datos del sujeto(,,s,34,34) select s.*, m.nombre as nom_muni, c.nom_cat,fec_caso from wf_caso_34 w inner join core_sujetoverificacion s on w.id=34 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 08 16:56:25 tabla dat adic select tabla from core_sujetoverificaciontipo where id=1 2016-02 08 16:56:25 tabla :persona SELECT * FROM persona where id=58 2016-02 08 16:56:25 Continuar(s,39,49,) EjecutarTarea_39() Notificación id_comp1173 65 65 ValidarUsuario(39):1 EjecutarPaso_49: eval:0 , caso=34 id_comp 1173 Paso::Guardar(Caso:34) rta: 1 dato: tabla: CasoPaso:163 CargarDatos_49() SiguientePasoDe49: Funcion para ejecutar el siguiente paso EjecutarPaso_119: corr:42 , caso=34 id_comp 1173 Mostrar corr ob_start(); $ciud = mb_strtoupper( "{ WFSV_2 } { WFSV_3 }",'utf-8'); ?>

Apreciado(a)

El presente mensaje es una notificación para el caso No

{ WFSV_1 } TWFSV_1:moniknatyk@gmail.com Notificación concepto de norma urbanística Retorno : Array ( [ret] => inicioComponente_WF_Correo({"id":"1173","caso_id":"34","proceso_id":34,"tit":"Notificación","tarea_id":39,"paso_id":119,"desc":"

\nApreciado(a)
\nTRFD FDDF<\/strong>\n

\n

El presente mensaje es una notificación para el caso No 34<\/strong> <\/p>\nSu certificado de concepto de norma urban\u00edstica se encuentra disponible. Puede acercarse a ventanilla para solicitarlo.
<\/strong> ","url":"
De clic aquí para volver a enviar el correo<\/a><\/div>"}); [suc] => 1 ) fin 2016-02-08 16:56:25 /******************************************************************************************************/ 2016-02-08 16:56:36TraerCaso(34,34,) CargarCaso :34 2016-02 08 16:56:36 CargarDatos: Caso :34 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_34_seguimiento_id,wf_paso_id from wf_caso_34_pasos a1 group by wf_caso_34_seguimiento_id,wf_paso_id order by id )a inner join wf_caso_34_pasos p using(id,wf_caso_34_seguimiento_id) inner join ( select max(id) as wf_caso_34_seguimiento_id,wf_caso_34_id,wf_tarea_id from wf_caso_34_seguimiento where wf_caso_34_id =? group by wf_caso_34_id,wf_tarea_id order by wf_caso_34_id,wf_caso_34_seguimiento_id ) b using(wf_caso_34_seguimiento_id) left join usuarios u using(core_usuario_id) {"0":"156","id":"156","1":"46","wf_paso_id":"46","2":"95","wf_caso_34_seguimiento_id":"95","3":"28","core_usuario_id":"28","4":"2016-02-08 16:45:50","fecha_ejec":"2016-02-08 16:45:50","5":"27","dato":"27","6":"sce.t5","tabla":"sce.t5","7":"36","tarea_id":"36","8":"fddf trfd: ciudadano","usr_ejec":"fddf trfd: ciudadano"} CargarDatos_46(27) se carga 34_36_46_5_6_302 se carga 34_36_46_5_6_228 se carga 34_36_46_5_6_227301 se carga 34_36_46_5_6_226kkk se carga 34_36_46_5_6_225 se carga 34_36_46_5_6_2222016-02-08 {"0":"157","id":"157","1":"47","wf_paso_id":"47","2":"95","wf_caso_34_seguimiento_id":"95","3":"28","core_usuario_id":"28","4":"2016-02-08 16:48:13","fecha_ejec":"2016-02-08 16:48:13","5":"6848","dato":"6848","6":"wf_documentoentradaadj_caso","tabla":"wf_documentoentradaadj_caso","7":"36","tarea_id":"36","8":"fddf trfd: ciudadano","usr_ejec":"fddf trfd: ciudadano"} CargarDatos_47(6848) {"0":"158","id":"158","1":"118","wf_paso_id":"118","2":"95","wf_caso_34_seguimiento_id":"95","3":"28","core_usuario_id":"28","4":"2016-02-08 16:48:15","fecha_ejec":"2016-02-08 16:48:15","5":null,"dato":null,"6":null,"tabla":null,"7":"36","tarea_id":"36","8":"fddf trfd: ciudadano","usr_ejec":"fddf trfd: ciudadano"} CargarDatos_118() {"0":"159","id":"159","1":"161","wf_paso_id":"161","2":"96","wf_caso_34_seguimiento_id":"96","3":"65","core_usuario_id":"65","4":"2016-02-08 16:51:34","fecha_ejec":"2016-02-08 16:51:34","5":"2715","dato":"2715","6":"wf_documentoentradaadj_caso","tabla":"wf_documentoentradaadj_caso","7":"72","tarea_id":"72","8":"funcionario planeaci\u00f3n: gerente","usr_ejec":"funcionario planeaci\u00f3n: gerente"} CargarDatos_161(2715) {"0":"160","id":"160","1":"50","wf_paso_id":"50","2":"97","wf_caso_34_seguimiento_id":"97","3":"65","core_usuario_id":"65","4":"2016-02-08 16:56:03","fecha_ejec":"2016-02-08 16:56:03","5":"16","dato":"16","6":"sce.t6","tabla":"sce.t6","7":"37","tarea_id":"37","8":"funcionario planeaci\u00f3n: gerente","usr_ejec":"funcionario planeaci\u00f3n: gerente"} CargarDatos_50(16) se carga 34_37_50_6_7_314 se carga 34_37_50_6_7_313 se carga 34_37_50_6_7_304 se carga 34_37_50_6_7_303 se carga 34_37_50_6_7_301 se carga 34_37_50_6_7_242 se carga 34_37_50_6_7_241 se carga 34_37_50_6_7_240 se carga 34_37_50_6_7_239 se carga 34_37_50_6_7_238 se carga 34_37_50_6_7_237 se carga 34_37_50_6_7_236 se carga 34_37_50_6_7_235 se carga 34_37_50_6_7_234 se carga 34_37_50_6_7_233 se carga 34_37_50_6_7_232 se carga 34_37_50_6_7_231 {"0":"161","id":"161","1":"120","wf_paso_id":"120","2":"97","wf_caso_34_seguimiento_id":"97","3":"65","core_usuario_id":"65","4":"2016-02-08 16:56:11","fecha_ejec":"2016-02-08 16:56:11","5":null,"dato":null,"6":null,"tabla":null,"7":"37","tarea_id":"37","8":"funcionario planeaci\u00f3n: gerente","usr_ejec":"funcionario planeaci\u00f3n: gerente"} CargarDatos_120() {"0":"162","id":"162","1":"48","wf_paso_id":"48","2":"98","wf_caso_34_seguimiento_id":"98","3":"65","core_usuario_id":"65","4":"2016-02-08 16:56:25","fecha_ejec":"2016-02-08 16:56:25","5":"6854","dato":"6854","6":"wf_documentoentradaadj_caso","tabla":"wf_documentoentradaadj_caso","7":"38","tarea_id":"38","8":"funcionario planeaci\u00f3n: gerente","usr_ejec":"funcionario planeaci\u00f3n: gerente"} CargarDatos_48(6854) {"0":"163","id":"163","1":"49","wf_paso_id":"49","2":"99","wf_caso_34_seguimiento_id":"99","3":"65","core_usuario_id":"65","4":"2016-02-08 16:56:25","fecha_ejec":"2016-02-08 16:56:25","5":null,"dato":null,"6":null,"tabla":null,"7":"39","tarea_id":"39","8":"funcionario planeaci\u00f3n: gerente","usr_ejec":"funcionario planeaci\u00f3n: gerente"} CargarDatos_49() 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_34_seguimiento a inner join ( select max(b0.id) as id,b0.wf_caso_34_id,b0.wf_tarea_id from wf_caso_34_seguimiento b0 where b0.wf_caso_34_id =? group by b0.wf_caso_34_id,b0.wf_tarea_id order by wf_caso_34_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":"95","id":"95","1":"34","wf_caso_34_id":"34","2":"36","wf_tarea_id":"36","3":null,"core_usuario_id":null,"4":"2016-02-08 16:44:36","fec_asig":"2016-02-08 16:44:36","5":"28","core_usuario_id_resol":"28","6":"2016-02-08 16:48:15","fec_resol":"2016-02-08 16:48:15","7":"36","wf_tarea_id_sig":"36","8":null,"usr_asig":null,"9":"fddf trfd: ciudadano","usr_resol":"fddf trfd: ciudadano"} {"0":"96","id":"96","1":"34","wf_caso_34_id":"34","2":"72","wf_tarea_id":"72","3":null,"core_usuario_id":null,"4":"2016-02-08 16:48:15","fec_asig":"2016-02-08 16:48:15","5":"65","core_usuario_id_resol":"65","6":"2016-02-08 16:51:34","fec_resol":"2016-02-08 16:51:34","7":"72","wf_tarea_id_sig":"72","8":null,"usr_asig":null,"9":"funcionario planeaci\u00f3n: gerente","usr_resol":"funcionario planeaci\u00f3n: gerente"} {"0":"97","id":"97","1":"34","wf_caso_34_id":"34","2":"37","wf_tarea_id":"37","3":"65","core_usuario_id":"65","4":"2016-02-08 16:51:35","fec_asig":"2016-02-08 16:51:35","5":"65","core_usuario_id_resol":"65","6":"2016-02-08 16:56:11","fec_resol":"2016-02-08 16:56:11","7":"37","wf_tarea_id_sig":"37","8":"funcionario planeaci\u00f3n: gerente","usr_asig":"funcionario planeaci\u00f3n: gerente","9":"funcionario planeaci\u00f3n: gerente","usr_resol":"funcionario planeaci\u00f3n: gerente"} {"0":"98","id":"98","1":"34","wf_caso_34_id":"34","2":"38","wf_tarea_id":"38","3":"65","core_usuario_id":"65","4":"2016-02-08 16:56:11","fec_asig":"2016-02-08 16:56:11","5":"65","core_usuario_id_resol":"65","6":"2016-02-08 16:56:25","fec_resol":"2016-02-08 16:56:25","7":"38","wf_tarea_id_sig":"38","8":"funcionario planeaci\u00f3n: gerente","usr_asig":"funcionario planeaci\u00f3n: gerente","9":"funcionario planeaci\u00f3n: gerente","usr_resol":"funcionario planeaci\u00f3n: gerente"} {"0":"99","id":"99","1":"34","wf_caso_34_id":"34","2":"39","wf_tarea_id":"39","3":"65","core_usuario_id":"65","4":"2016-02-08 16:56:25","fec_asig":"2016-02-08 16:56:25","5":null,"core_usuario_id_resol":null,"6":null,"fec_resol":null,"7":"39","wf_tarea_id_sig":"39","8":"funcionario planeaci\u00f3n: gerente","usr_asig":"funcionario planeaci\u00f3n: gerente","9":null,"usr_resol":null} 2016-02 08 16:56:36 cargar datos del sujeto(,,s,34,34) select s.*, m.nombre as nom_muni, c.nom_cat,fec_caso from wf_caso_34 w inner join core_sujetoverificacion s on w.id=34 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 08 16:56:36 tabla dat adic select tabla from core_sujetoverificaciontipo where id=1 2016-02 08 16:56:36 tabla :persona SELECT * FROM persona where id=58 2016-02 08 16:56:36 Continuar(s,39,119,) EjecutarTarea_39() Notificación id_comp1173 65 65 ValidarUsuario(39):1 EjecutarPaso_119: corr:42 , caso=34 id_comp 1173 Paso::Guardar(Caso:34) rta: 1 dato: tabla: CasoPaso:164 CargarDatos_119() SiguientePasoDe119: Funcion para ejecutar el siguiente paso TerminarTarea(39,) Retorno : Array ( [htm] => [suc] => 1 [ret] => crearMsg('El proceso ha terminado exitosamente, si considera que no debe ser asi comuniquese con el administrador del sistema','Información');Ext.getCmp('comp_1173').funcionInicial('n'); ) fin 2016-02-08 16:56:36 /******************************************************************************************************/