2015-06-03 08:26:16TraerCaso(127,80,)
CargarCaso :127
2015-06 03 08:26:16
CargarDatos: Caso :127
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_80_seguimiento_id,wf_paso_id from wf_caso_80_pasos a1 group by wf_caso_80_seguimiento_id,wf_paso_id order by id
)a
inner join wf_caso_80_pasos p using(id,wf_caso_80_seguimiento_id)
inner join ( select max(id) as wf_caso_80_seguimiento_id,wf_caso_80_id,wf_tarea_id from wf_caso_80_seguimiento where wf_caso_80_id =? group by wf_caso_80_id,wf_tarea_id order by wf_caso_80_id,wf_caso_80_seguimiento_id ) b using(wf_caso_80_seguimiento_id)
left join usuarios u using(core_usuario_id)
{"0":"397","id":"397","1":"318","wf_paso_id":"318","2":"497","wf_caso_80_seguimiento_id":"497","3":"133","core_usuario_id":"133","4":"2015-05-14 08:30:57","fecha_ejec":"2015-05-14 08:30:57","5":"104","dato":"104","6":"sce.t100","tabla":"sce.t100","7":"172","tarea_id":"172","8":"Pinchao German: ciudadano","usr_ejec":"Pinchao German: ciudadano"}
CargarDatos_318(104)
se carga 80_172_318_100_118_7532
{"0":"398","id":"398","1":"319","wf_paso_id":"319","2":"498","wf_caso_80_seguimiento_id":"498","3":"133","core_usuario_id":"133","4":"2015-05-14 08:31:32","fecha_ejec":"2015-05-14 08:31:32","5":"82","dato":"82","6":"sce.t101","tabla":"sce.t101","7":"173","tarea_id":"173","8":"Pinchao German: ciudadano","usr_ejec":"Pinchao German: ciudadano"}
CargarDatos_319(82)
se carga 80_173_319_101_119_7541
{"0":"399","id":"399","1":"320","wf_paso_id":"320","2":"499","wf_caso_80_seguimiento_id":"499","3":"133","core_usuario_id":"133","4":"2015-05-14 08:31:35","fecha_ejec":"2015-05-14 08:31:35","5":"47","dato":"47","6":"sce.t102","tabla":"sce.t102","7":"174","tarea_id":"174","8":"Pinchao German: ciudadano","usr_ejec":"Pinchao German: ciudadano"}
CargarDatos_320(47)
se carga 80_174_320_102_120_7551
{"0":"400","id":"400","1":"324","wf_paso_id":"324","2":"500","wf_caso_80_seguimiento_id":"500","3":"133","core_usuario_id":"133","4":"2015-05-14 08:31:43","fecha_ejec":"2015-05-14 08:31:43","5":"27","dato":"27","6":"sce.t103","tabla":"sce.t103","7":"178","tarea_id":"178","8":"Pinchao German: ciudadano","usr_ejec":"Pinchao German: ciudadano"}
CargarDatos_324(27)
se carga 80_178_324_103_121_7561
{"0":"401","id":"401","1":"328","wf_paso_id":"328","2":"501","wf_caso_80_seguimiento_id":"501","3":"133","core_usuario_id":"133","4":"2015-05-14 08:32:20","fecha_ejec":"2015-05-14 08:32:20","5":"784","dato":"784","6":"wf_documentoentradaadj_caso","tabla":"wf_documentoentradaadj_caso","7":"182","tarea_id":"182","8":"Pinchao German: ciudadano","usr_ejec":"Pinchao German: ciudadano"}
CargarDatos_328(784)
{"0":"402","id":"402","1":"346","wf_paso_id":"346","2":"502","wf_caso_80_seguimiento_id":"502","3":"133","core_usuario_id":"133","4":"2015-05-14 08:32:28","fecha_ejec":"2015-05-14 08:32:28","5":null,"dato":null,"6":null,"tabla":null,"7":"196","tarea_id":"196","8":"Pinchao German: ciudadano","usr_ejec":"Pinchao German: ciudadano"}
CargarDatos_346()
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_80_seguimiento a
inner join (
select max(b0.id) as id,b0.wf_caso_80_id,b0.wf_tarea_id from wf_caso_80_seguimiento b0 where b0.wf_caso_80_id =? group by b0.wf_caso_80_id,b0.wf_tarea_id order by wf_caso_80_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":"497","id":"497","1":"127","wf_caso_80_id":"127","2":"172","wf_tarea_id":"172","3":null,"core_usuario_id":null,"4":"2015-05-14 08:30:54","fec_asig":"2015-05-14 08:30:54","5":"133","core_usuario_id_resol":"133","6":"2015-05-14 08:30:57","fec_resol":"2015-05-14 08:30:57","7":"172","wf_tarea_id_sig":"172","8":null,"usr_asig":null,"9":"Pinchao German: ciudadano","usr_resol":"Pinchao German: ciudadano"}
{"0":"498","id":"498","1":"127","wf_caso_80_id":"127","2":"173","wf_tarea_id":"173","3":"133","core_usuario_id":"133","4":"2015-05-14 08:30:57","fec_asig":"2015-05-14 08:30:57","5":"133","core_usuario_id_resol":"133","6":"2015-05-14 08:31:32","fec_resol":"2015-05-14 08:31:32","7":"173","wf_tarea_id_sig":"173","8":"Pinchao German: ciudadano","usr_asig":"Pinchao German: ciudadano","9":"Pinchao German: ciudadano","usr_resol":"Pinchao German: ciudadano"}
{"0":"500","id":"500","1":"127","wf_caso_80_id":"127","2":"178","wf_tarea_id":"178","3":"133","core_usuario_id":"133","4":"2015-05-14 08:31:35","fec_asig":"2015-05-14 08:31:35","5":"133","core_usuario_id_resol":"133","6":"2015-05-14 08:31:43","fec_resol":"2015-05-14 08:31:43","7":"178","wf_tarea_id_sig":"178","8":"Pinchao German: ciudadano","usr_asig":"Pinchao German: ciudadano","9":"Pinchao German: ciudadano","usr_resol":"Pinchao German: ciudadano"}
{"0":"502","id":"502","1":"127","wf_caso_80_id":"127","2":"196","wf_tarea_id":"196","3":"133","core_usuario_id":"133","4":"2015-05-14 08:32:20","fec_asig":"2015-05-14 08:32:20","5":"133","core_usuario_id_resol":"133","6":"2015-05-14 08:32:28","fec_resol":"2015-05-14 08:32:28","7":"196","wf_tarea_id_sig":"196","8":"Pinchao German: ciudadano","usr_asig":"Pinchao German: ciudadano","9":"Pinchao German: ciudadano","usr_resol":"Pinchao German: ciudadano"}
{"0":"499","id":"499","1":"127","wf_caso_80_id":"127","2":"174","wf_tarea_id":"174","3":"133","core_usuario_id":"133","4":"2015-05-14 08:31:32","fec_asig":"2015-05-14 08:31:32","5":"133","core_usuario_id_resol":"133","6":"2015-05-14 08:31:35","fec_resol":"2015-05-14 08:31:35","7":"174","wf_tarea_id_sig":"174","8":"Pinchao German: ciudadano","usr_asig":"Pinchao German: ciudadano","9":"Pinchao German: ciudadano","usr_resol":"Pinchao German: ciudadano"}
{"0":"501","id":"501","1":"127","wf_caso_80_id":"127","2":"182","wf_tarea_id":"182","3":"133","core_usuario_id":"133","4":"2015-05-14 08:31:43","fec_asig":"2015-05-14 08:31:43","5":"133","core_usuario_id_resol":"133","6":"2015-05-14 08:32:20","fec_resol":"2015-05-14 08:32:20","7":"182","wf_tarea_id_sig":"182","8":"Pinchao German: ciudadano","usr_asig":"Pinchao German: ciudadano","9":"Pinchao German: ciudadano","usr_resol":"Pinchao German: ciudadano"}
{"0":"503","id":"503","1":"127","wf_caso_80_id":"127","2":"203","wf_tarea_id":"203","3":null,"core_usuario_id":null,"4":"2015-05-14 08:32:28","fec_asig":"2015-05-14 08:32:28","5":null,"core_usuario_id_resol":null,"6":null,"fec_resol":null,"7":"203","wf_tarea_id_sig":"203","8":null,"usr_asig":null,"9":null,"usr_resol":null}
2015-06 03 08:26:17
cargar datos del sujeto(,,s,80,127)
select s.*, m.nombre as nom_muni, c.nom_cat,fec_caso
from wf_caso_80 w
inner join core_sujetoverificacion s on w.id=127 AND s.id =w.core_sujetoverificacion_id
inner join plan_municipio m on s.plan_municipio_id=m.id
inner join core_sujetocategoria c on s.core_sujetocategoria_id=c.id
2015-06 03 08:26:17
tabla dat adic
select tabla from core_sujetoverificaciontipo where id=1
2015-06 03 08:26:17
tabla :persona
SELECT * FROM persona where id=20348
2015-06 03 08:26:17
Continuar(,203,,s)
EjecutarTarea_203() verificacion_adj_ins_prof id_comp1133
140
ValidarUsuario(203):1
EjecutarPaso_365: vadj:17 , caso=127 id_comp 1133
Mostrar vadj
Retorno :
Array
(
[ret] => inicioComponente_WF_vadj({"tarea_id":203,"paso_id":365,"id":"1133","proceso_id":80,"caso_id":"127","sujeto_id":"20348","vadj":17});
[suc] => 1
)
fin 2015-06-03 08:26:17
/******************************************************************************************************/
2015-06-03 08:26:29TraerCaso(127,80,)
CargarCaso :127
2015-06 03 08:26:29
CargarDatos: Caso :127
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_80_seguimiento_id,wf_paso_id from wf_caso_80_pasos a1 group by wf_caso_80_seguimiento_id,wf_paso_id order by id
)a
inner join wf_caso_80_pasos p using(id,wf_caso_80_seguimiento_id)
inner join ( select max(id) as wf_caso_80_seguimiento_id,wf_caso_80_id,wf_tarea_id from wf_caso_80_seguimiento where wf_caso_80_id =? group by wf_caso_80_id,wf_tarea_id order by wf_caso_80_id,wf_caso_80_seguimiento_id ) b using(wf_caso_80_seguimiento_id)
left join usuarios u using(core_usuario_id)
{"0":"397","id":"397","1":"318","wf_paso_id":"318","2":"497","wf_caso_80_seguimiento_id":"497","3":"133","core_usuario_id":"133","4":"2015-05-14 08:30:57","fecha_ejec":"2015-05-14 08:30:57","5":"104","dato":"104","6":"sce.t100","tabla":"sce.t100","7":"172","tarea_id":"172","8":"Pinchao German: ciudadano","usr_ejec":"Pinchao German: ciudadano"}
CargarDatos_318(104)
se carga 80_172_318_100_118_7532
{"0":"398","id":"398","1":"319","wf_paso_id":"319","2":"498","wf_caso_80_seguimiento_id":"498","3":"133","core_usuario_id":"133","4":"2015-05-14 08:31:32","fecha_ejec":"2015-05-14 08:31:32","5":"82","dato":"82","6":"sce.t101","tabla":"sce.t101","7":"173","tarea_id":"173","8":"Pinchao German: ciudadano","usr_ejec":"Pinchao German: ciudadano"}
CargarDatos_319(82)
se carga 80_173_319_101_119_7541
{"0":"399","id":"399","1":"320","wf_paso_id":"320","2":"499","wf_caso_80_seguimiento_id":"499","3":"133","core_usuario_id":"133","4":"2015-05-14 08:31:35","fecha_ejec":"2015-05-14 08:31:35","5":"47","dato":"47","6":"sce.t102","tabla":"sce.t102","7":"174","tarea_id":"174","8":"Pinchao German: ciudadano","usr_ejec":"Pinchao German: ciudadano"}
CargarDatos_320(47)
se carga 80_174_320_102_120_7551
{"0":"400","id":"400","1":"324","wf_paso_id":"324","2":"500","wf_caso_80_seguimiento_id":"500","3":"133","core_usuario_id":"133","4":"2015-05-14 08:31:43","fecha_ejec":"2015-05-14 08:31:43","5":"27","dato":"27","6":"sce.t103","tabla":"sce.t103","7":"178","tarea_id":"178","8":"Pinchao German: ciudadano","usr_ejec":"Pinchao German: ciudadano"}
CargarDatos_324(27)
se carga 80_178_324_103_121_7561
{"0":"401","id":"401","1":"328","wf_paso_id":"328","2":"501","wf_caso_80_seguimiento_id":"501","3":"133","core_usuario_id":"133","4":"2015-05-14 08:32:20","fecha_ejec":"2015-05-14 08:32:20","5":"784","dato":"784","6":"wf_documentoentradaadj_caso","tabla":"wf_documentoentradaadj_caso","7":"182","tarea_id":"182","8":"Pinchao German: ciudadano","usr_ejec":"Pinchao German: ciudadano"}
CargarDatos_328(784)
{"0":"402","id":"402","1":"346","wf_paso_id":"346","2":"502","wf_caso_80_seguimiento_id":"502","3":"133","core_usuario_id":"133","4":"2015-05-14 08:32:28","fecha_ejec":"2015-05-14 08:32:28","5":null,"dato":null,"6":null,"tabla":null,"7":"196","tarea_id":"196","8":"Pinchao German: ciudadano","usr_ejec":"Pinchao German: ciudadano"}
CargarDatos_346()
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_80_seguimiento a
inner join (
select max(b0.id) as id,b0.wf_caso_80_id,b0.wf_tarea_id from wf_caso_80_seguimiento b0 where b0.wf_caso_80_id =? group by b0.wf_caso_80_id,b0.wf_tarea_id order by wf_caso_80_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":"497","id":"497","1":"127","wf_caso_80_id":"127","2":"172","wf_tarea_id":"172","3":null,"core_usuario_id":null,"4":"2015-05-14 08:30:54","fec_asig":"2015-05-14 08:30:54","5":"133","core_usuario_id_resol":"133","6":"2015-05-14 08:30:57","fec_resol":"2015-05-14 08:30:57","7":"172","wf_tarea_id_sig":"172","8":null,"usr_asig":null,"9":"Pinchao German: ciudadano","usr_resol":"Pinchao German: ciudadano"}
{"0":"498","id":"498","1":"127","wf_caso_80_id":"127","2":"173","wf_tarea_id":"173","3":"133","core_usuario_id":"133","4":"2015-05-14 08:30:57","fec_asig":"2015-05-14 08:30:57","5":"133","core_usuario_id_resol":"133","6":"2015-05-14 08:31:32","fec_resol":"2015-05-14 08:31:32","7":"173","wf_tarea_id_sig":"173","8":"Pinchao German: ciudadano","usr_asig":"Pinchao German: ciudadano","9":"Pinchao German: ciudadano","usr_resol":"Pinchao German: ciudadano"}
{"0":"500","id":"500","1":"127","wf_caso_80_id":"127","2":"178","wf_tarea_id":"178","3":"133","core_usuario_id":"133","4":"2015-05-14 08:31:35","fec_asig":"2015-05-14 08:31:35","5":"133","core_usuario_id_resol":"133","6":"2015-05-14 08:31:43","fec_resol":"2015-05-14 08:31:43","7":"178","wf_tarea_id_sig":"178","8":"Pinchao German: ciudadano","usr_asig":"Pinchao German: ciudadano","9":"Pinchao German: ciudadano","usr_resol":"Pinchao German: ciudadano"}
{"0":"502","id":"502","1":"127","wf_caso_80_id":"127","2":"196","wf_tarea_id":"196","3":"133","core_usuario_id":"133","4":"2015-05-14 08:32:20","fec_asig":"2015-05-14 08:32:20","5":"133","core_usuario_id_resol":"133","6":"2015-05-14 08:32:28","fec_resol":"2015-05-14 08:32:28","7":"196","wf_tarea_id_sig":"196","8":"Pinchao German: ciudadano","usr_asig":"Pinchao German: ciudadano","9":"Pinchao German: ciudadano","usr_resol":"Pinchao German: ciudadano"}
{"0":"499","id":"499","1":"127","wf_caso_80_id":"127","2":"174","wf_tarea_id":"174","3":"133","core_usuario_id":"133","4":"2015-05-14 08:31:32","fec_asig":"2015-05-14 08:31:32","5":"133","core_usuario_id_resol":"133","6":"2015-05-14 08:31:35","fec_resol":"2015-05-14 08:31:35","7":"174","wf_tarea_id_sig":"174","8":"Pinchao German: ciudadano","usr_asig":"Pinchao German: ciudadano","9":"Pinchao German: ciudadano","usr_resol":"Pinchao German: ciudadano"}
{"0":"501","id":"501","1":"127","wf_caso_80_id":"127","2":"182","wf_tarea_id":"182","3":"133","core_usuario_id":"133","4":"2015-05-14 08:31:43","fec_asig":"2015-05-14 08:31:43","5":"133","core_usuario_id_resol":"133","6":"2015-05-14 08:32:20","fec_resol":"2015-05-14 08:32:20","7":"182","wf_tarea_id_sig":"182","8":"Pinchao German: ciudadano","usr_asig":"Pinchao German: ciudadano","9":"Pinchao German: ciudadano","usr_resol":"Pinchao German: ciudadano"}
{"0":"503","id":"503","1":"127","wf_caso_80_id":"127","2":"203","wf_tarea_id":"203","3":null,"core_usuario_id":null,"4":"2015-05-14 08:32:28","fec_asig":"2015-05-14 08:32:28","5":null,"core_usuario_id_resol":null,"6":null,"fec_resol":null,"7":"203","wf_tarea_id_sig":"203","8":null,"usr_asig":null,"9":null,"usr_resol":null}
2015-06 03 08:26:29
cargar datos del sujeto(,,s,80,127)
select s.*, m.nombre as nom_muni, c.nom_cat,fec_caso
from wf_caso_80 w
inner join core_sujetoverificacion s on w.id=127 AND s.id =w.core_sujetoverificacion_id
inner join plan_municipio m on s.plan_municipio_id=m.id
inner join core_sujetocategoria c on s.core_sujetocategoria_id=c.id
2015-06 03 08:26:29
tabla dat adic
select tabla from core_sujetoverificaciontipo where id=1
2015-06 03 08:26:29
tabla :persona
SELECT * FROM persona where id=20348
2015-06 03 08:26:29
Continuar(,203,,s)
EjecutarTarea_203() verificacion_adj_ins_prof id_comp1133
140
ValidarUsuario(203):1
EjecutarPaso_365: vadj:17 , caso=127 id_comp 1133
Mostrar vadj
Retorno :
Array
(
[ret] => inicioComponente_WF_vadj({"tarea_id":203,"paso_id":365,"id":"1133","proceso_id":80,"caso_id":"127","sujeto_id":"20348","vadj":17});
[suc] => 1
)
fin 2015-06-03 08:26:29
/******************************************************************************************************/
2015-06-03 08:28:13TraerCaso(127,80,)
CargarCaso :127
2015-06 03 08:28:13
CargarDatos: Caso :127
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_80_seguimiento_id,wf_paso_id from wf_caso_80_pasos a1 group by wf_caso_80_seguimiento_id,wf_paso_id order by id
)a
inner join wf_caso_80_pasos p using(id,wf_caso_80_seguimiento_id)
inner join ( select max(id) as wf_caso_80_seguimiento_id,wf_caso_80_id,wf_tarea_id from wf_caso_80_seguimiento where wf_caso_80_id =? group by wf_caso_80_id,wf_tarea_id order by wf_caso_80_id,wf_caso_80_seguimiento_id ) b using(wf_caso_80_seguimiento_id)
left join usuarios u using(core_usuario_id)
{"0":"397","id":"397","1":"318","wf_paso_id":"318","2":"497","wf_caso_80_seguimiento_id":"497","3":"133","core_usuario_id":"133","4":"2015-05-14 08:30:57","fecha_ejec":"2015-05-14 08:30:57","5":"104","dato":"104","6":"sce.t100","tabla":"sce.t100","7":"172","tarea_id":"172","8":"Pinchao German: ciudadano","usr_ejec":"Pinchao German: ciudadano"}
CargarDatos_318(104)
se carga 80_172_318_100_118_7532
{"0":"398","id":"398","1":"319","wf_paso_id":"319","2":"498","wf_caso_80_seguimiento_id":"498","3":"133","core_usuario_id":"133","4":"2015-05-14 08:31:32","fecha_ejec":"2015-05-14 08:31:32","5":"82","dato":"82","6":"sce.t101","tabla":"sce.t101","7":"173","tarea_id":"173","8":"Pinchao German: ciudadano","usr_ejec":"Pinchao German: ciudadano"}
CargarDatos_319(82)
se carga 80_173_319_101_119_7541
{"0":"399","id":"399","1":"320","wf_paso_id":"320","2":"499","wf_caso_80_seguimiento_id":"499","3":"133","core_usuario_id":"133","4":"2015-05-14 08:31:35","fecha_ejec":"2015-05-14 08:31:35","5":"47","dato":"47","6":"sce.t102","tabla":"sce.t102","7":"174","tarea_id":"174","8":"Pinchao German: ciudadano","usr_ejec":"Pinchao German: ciudadano"}
CargarDatos_320(47)
se carga 80_174_320_102_120_7551
{"0":"400","id":"400","1":"324","wf_paso_id":"324","2":"500","wf_caso_80_seguimiento_id":"500","3":"133","core_usuario_id":"133","4":"2015-05-14 08:31:43","fecha_ejec":"2015-05-14 08:31:43","5":"27","dato":"27","6":"sce.t103","tabla":"sce.t103","7":"178","tarea_id":"178","8":"Pinchao German: ciudadano","usr_ejec":"Pinchao German: ciudadano"}
CargarDatos_324(27)
se carga 80_178_324_103_121_7561
{"0":"401","id":"401","1":"328","wf_paso_id":"328","2":"501","wf_caso_80_seguimiento_id":"501","3":"133","core_usuario_id":"133","4":"2015-05-14 08:32:20","fecha_ejec":"2015-05-14 08:32:20","5":"784","dato":"784","6":"wf_documentoentradaadj_caso","tabla":"wf_documentoentradaadj_caso","7":"182","tarea_id":"182","8":"Pinchao German: ciudadano","usr_ejec":"Pinchao German: ciudadano"}
CargarDatos_328(784)
{"0":"402","id":"402","1":"346","wf_paso_id":"346","2":"502","wf_caso_80_seguimiento_id":"502","3":"133","core_usuario_id":"133","4":"2015-05-14 08:32:28","fecha_ejec":"2015-05-14 08:32:28","5":null,"dato":null,"6":null,"tabla":null,"7":"196","tarea_id":"196","8":"Pinchao German: ciudadano","usr_ejec":"Pinchao German: ciudadano"}
CargarDatos_346()
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_80_seguimiento a
inner join (
select max(b0.id) as id,b0.wf_caso_80_id,b0.wf_tarea_id from wf_caso_80_seguimiento b0 where b0.wf_caso_80_id =? group by b0.wf_caso_80_id,b0.wf_tarea_id order by wf_caso_80_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":"497","id":"497","1":"127","wf_caso_80_id":"127","2":"172","wf_tarea_id":"172","3":null,"core_usuario_id":null,"4":"2015-05-14 08:30:54","fec_asig":"2015-05-14 08:30:54","5":"133","core_usuario_id_resol":"133","6":"2015-05-14 08:30:57","fec_resol":"2015-05-14 08:30:57","7":"172","wf_tarea_id_sig":"172","8":null,"usr_asig":null,"9":"Pinchao German: ciudadano","usr_resol":"Pinchao German: ciudadano"}
{"0":"498","id":"498","1":"127","wf_caso_80_id":"127","2":"173","wf_tarea_id":"173","3":"133","core_usuario_id":"133","4":"2015-05-14 08:30:57","fec_asig":"2015-05-14 08:30:57","5":"133","core_usuario_id_resol":"133","6":"2015-05-14 08:31:32","fec_resol":"2015-05-14 08:31:32","7":"173","wf_tarea_id_sig":"173","8":"Pinchao German: ciudadano","usr_asig":"Pinchao German: ciudadano","9":"Pinchao German: ciudadano","usr_resol":"Pinchao German: ciudadano"}
{"0":"500","id":"500","1":"127","wf_caso_80_id":"127","2":"178","wf_tarea_id":"178","3":"133","core_usuario_id":"133","4":"2015-05-14 08:31:35","fec_asig":"2015-05-14 08:31:35","5":"133","core_usuario_id_resol":"133","6":"2015-05-14 08:31:43","fec_resol":"2015-05-14 08:31:43","7":"178","wf_tarea_id_sig":"178","8":"Pinchao German: ciudadano","usr_asig":"Pinchao German: ciudadano","9":"Pinchao German: ciudadano","usr_resol":"Pinchao German: ciudadano"}
{"0":"502","id":"502","1":"127","wf_caso_80_id":"127","2":"196","wf_tarea_id":"196","3":"133","core_usuario_id":"133","4":"2015-05-14 08:32:20","fec_asig":"2015-05-14 08:32:20","5":"133","core_usuario_id_resol":"133","6":"2015-05-14 08:32:28","fec_resol":"2015-05-14 08:32:28","7":"196","wf_tarea_id_sig":"196","8":"Pinchao German: ciudadano","usr_asig":"Pinchao German: ciudadano","9":"Pinchao German: ciudadano","usr_resol":"Pinchao German: ciudadano"}
{"0":"499","id":"499","1":"127","wf_caso_80_id":"127","2":"174","wf_tarea_id":"174","3":"133","core_usuario_id":"133","4":"2015-05-14 08:31:32","fec_asig":"2015-05-14 08:31:32","5":"133","core_usuario_id_resol":"133","6":"2015-05-14 08:31:35","fec_resol":"2015-05-14 08:31:35","7":"174","wf_tarea_id_sig":"174","8":"Pinchao German: ciudadano","usr_asig":"Pinchao German: ciudadano","9":"Pinchao German: ciudadano","usr_resol":"Pinchao German: ciudadano"}
{"0":"501","id":"501","1":"127","wf_caso_80_id":"127","2":"182","wf_tarea_id":"182","3":"133","core_usuario_id":"133","4":"2015-05-14 08:31:43","fec_asig":"2015-05-14 08:31:43","5":"133","core_usuario_id_resol":"133","6":"2015-05-14 08:32:20","fec_resol":"2015-05-14 08:32:20","7":"182","wf_tarea_id_sig":"182","8":"Pinchao German: ciudadano","usr_asig":"Pinchao German: ciudadano","9":"Pinchao German: ciudadano","usr_resol":"Pinchao German: ciudadano"}
{"0":"503","id":"503","1":"127","wf_caso_80_id":"127","2":"203","wf_tarea_id":"203","3":null,"core_usuario_id":null,"4":"2015-05-14 08:32:28","fec_asig":"2015-05-14 08:32:28","5":null,"core_usuario_id_resol":null,"6":null,"fec_resol":null,"7":"203","wf_tarea_id_sig":"203","8":null,"usr_asig":null,"9":null,"usr_resol":null}
2015-06 03 08:28:13
cargar datos del sujeto(,,s,80,127)
select s.*, m.nombre as nom_muni, c.nom_cat,fec_caso
from wf_caso_80 w
inner join core_sujetoverificacion s on w.id=127 AND s.id =w.core_sujetoverificacion_id
inner join plan_municipio m on s.plan_municipio_id=m.id
inner join core_sujetocategoria c on s.core_sujetocategoria_id=c.id
2015-06 03 08:28:13
tabla dat adic
select tabla from core_sujetoverificaciontipo where id=1
2015-06 03 08:28:13
tabla :persona
SELECT * FROM persona where id=20348
2015-06 03 08:28:13
Continuar(,203,,s)
EjecutarTarea_203() verificacion_adj_ins_prof id_comp1133
140
ValidarUsuario(203):1
EjecutarPaso_365: vadj:17 , caso=127 id_comp 1133
Mostrar vadj
Retorno :
Array
(
[ret] => inicioComponente_WF_vadj({"tarea_id":203,"paso_id":365,"id":"1133","proceso_id":80,"caso_id":"127","sujeto_id":"20348","vadj":17});
[suc] => 1
)
fin 2015-06-03 08:28:13
/******************************************************************************************************/