De clic aqui para descargar el archivo<\/a><\/div>"});
[suc] => 1
)
fin 2015-07-29 17:01:27
/******************************************************************************************************/
2015-07-29 17:01:29TraerCaso(269,79,)
CargarCaso :269
2015-07 29 17:01:29
CargarDatos: Caso :269
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_79_seguimiento_id,wf_paso_id from wf_caso_79_pasos a1 group by wf_caso_79_seguimiento_id,wf_paso_id order by id
)a
inner join wf_caso_79_pasos p using(id,wf_caso_79_seguimiento_id)
inner join ( select max(id) as wf_caso_79_seguimiento_id,wf_caso_79_id,wf_tarea_id from wf_caso_79_seguimiento where wf_caso_79_id =? group by wf_caso_79_id,wf_tarea_id order by wf_caso_79_id,wf_caso_79_seguimiento_id ) b using(wf_caso_79_seguimiento_id)
left join usuarios u using(core_usuario_id) where tabla not in ('sce.t53')
{"0":"642","id":"642","1":"288","wf_paso_id":"288","2":"546","wf_caso_79_seguimiento_id":"546","3":"133","core_usuario_id":"133","4":"2015-07-29 14:19:04","fecha_ejec":"2015-07-29 14:19:04","5":"196","dato":"196","6":"sce.t93","tabla":"sce.t93","7":"158","tarea_id":"158","8":"anonimo anonimo: ciudadano","usr_ejec":"anonimo anonimo: ciudadano"}
CargarDatos_288(196)
se carga 79_158_288_93_110_870960
se carga 79_158_288_93_110_7401
se carga 79_158_288_93_110_7311
se carga 79_158_288_93_110_730embigado
{"0":"644","id":"644","1":"402","wf_paso_id":"402","2":"547","wf_caso_79_seguimiento_id":"547","3":"133","core_usuario_id":"133","4":"2015-07-29 14:19:18","fecha_ejec":"2015-07-29 14:19:18","5":"12065","dato":"12065","6":"core_upload","tabla":"core_upload","7":"243","tarea_id":"243","8":"anonimo anonimo: ciudadano","usr_ejec":"anonimo anonimo: ciudadano"}
CargarDatos_402(12065)
{"0":"645","id":"645","1":"290","wf_paso_id":"290","2":"548","wf_caso_79_seguimiento_id":"548","3":"140","core_usuario_id":"140","4":"2015-07-29 17:01:27","fecha_ejec":"2015-07-29 17:01:27","5":"106","dato":"106","6":"sce.t94","tabla":"sce.t94","7":"159","tarea_id":"159","8":"796 Paola: Gerente","usr_ejec":"796 Paola: Gerente"}
CargarDatos_290(106)
se carga 79_159_290_94_111_87644
se carga 79_159_290_94_111_87531
se carga 79_159_290_94_111_8742015-07-26
se carga 79_159_290_94_111_873111
se carga 79_159_290_94_111_8722015-07-17
se carga 79_159_290_94_111_871123
se carga 79_159_290_94_111_7411
se carga 79_159_290_94_111_7391
se carga 79_159_290_94_111_7331
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_79_seguimiento a
inner join (
select max(b0.id) as id,b0.wf_caso_79_id,b0.wf_tarea_id from wf_caso_79_seguimiento b0 where b0.wf_caso_79_id =? group by b0.wf_caso_79_id,b0.wf_tarea_id order by wf_caso_79_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":"546","id":"546","1":"269","wf_caso_79_id":"269","2":"158","wf_tarea_id":"158","3":null,"core_usuario_id":null,"4":"2015-07-29 14:18:41","fec_asig":"2015-07-29 14:18:41","5":"133","core_usuario_id_resol":"133","6":"2015-07-29 14:19:12","fec_resol":"2015-07-29 14:19:12","7":"158","wf_tarea_id_sig":"158","8":null,"usr_asig":null,"9":"anonimo anonimo: ciudadano","usr_resol":"anonimo anonimo: ciudadano"}
{"0":"547","id":"547","1":"269","wf_caso_79_id":"269","2":"243","wf_tarea_id":"243","3":"133","core_usuario_id":"133","4":"2015-07-29 14:19:12","fec_asig":"2015-07-29 14:19:12","5":"133","core_usuario_id_resol":"133","6":"2015-07-29 14:19:18","fec_resol":"2015-07-29 14:19:18","7":"243","wf_tarea_id_sig":"243","8":"anonimo anonimo: ciudadano","usr_asig":"anonimo anonimo: ciudadano","9":"anonimo anonimo: ciudadano","usr_resol":"anonimo anonimo: ciudadano"}
{"0":"548","id":"548","1":"269","wf_caso_79_id":"269","2":"159","wf_tarea_id":"159","3":null,"core_usuario_id":null,"4":"2015-07-29 14:19:18","fec_asig":"2015-07-29 14:19:18","5":"140","core_usuario_id_resol":"140","6":"2015-07-29 17:01:27","fec_resol":"2015-07-29 17:01:27","7":"159","wf_tarea_id_sig":"159","8":null,"usr_asig":null,"9":"796 Paola: Gerente","usr_resol":"796 Paola: Gerente"}
{"0":"549","id":"549","1":"269","wf_caso_79_id":"269","2":"161","wf_tarea_id":"161","3":"140","core_usuario_id":"140","4":"2015-07-29 17:01:27","fec_asig":"2015-07-29 17:01:27","5":null,"core_usuario_id_resol":null,"6":null,"fec_resol":null,"7":"161","wf_tarea_id_sig":"161","8":"796 Paola: Gerente","usr_asig":"796 Paola: Gerente","9":null,"usr_resol":null}
2015-07 29 17:01:29
cargar datos del sujeto(,,s,79,269)
select s.*, m.nombre as nom_muni, c.nom_cat,fec_caso
from wf_caso_79 w
inner join core_sujetoverificacion s on w.id=269 AND s.id =w.core_sujetoverificacion_id
inner join plan_municipio m on s.plan_municipio_id=m.id
inner join core_sujetocategoria c on s.core_sujetocategoria_id=c.id
2015-07 29 17:01:29
tabla dat adic
select tabla from core_sujetoverificaciontipo where id=1
2015-07 29 17:01:29
tabla :persona
SELECT * FROM persona where id=20490
2015-07 29 17:01:29
Continuar(s,161,361,)
EjecutarTarea_161() Certificado exitoso id_comp1124
140 140
ValidarUsuario(161):1
EjecutarPaso_361: docs:61 , caso=269 id_comp 1124
Paso::Guardar(Caso:269)
rta: 1 dato:12068 tabla:core_upload
CasoPaso:646
CargarDatos_361(12068)
SiguientePasoDe361: Funcion para ejecutar el siguiente paso
EjecutarPaso_364: ladj:28 , caso=269 id_comp 1124
Mostrar ladj
Retorno :
Array
(
[ret] => inicioComponente_WF_ladj({"tarea_id":161,"paso_id":364,"id":"1124","proceso_id":79,"caso_id":"269","sujeto_id":"20490","ladj":28});
[suc] => 1
)
fin 2015-07-29 17:01:29
/******************************************************************************************************/
2015-07-29 17:01:43TraerCaso(269,79,)
CargarCaso :269
2015-07 29 17:01:43
CargarDatos: Caso :269
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_79_seguimiento_id,wf_paso_id from wf_caso_79_pasos a1 group by wf_caso_79_seguimiento_id,wf_paso_id order by id
)a
inner join wf_caso_79_pasos p using(id,wf_caso_79_seguimiento_id)
inner join ( select max(id) as wf_caso_79_seguimiento_id,wf_caso_79_id,wf_tarea_id from wf_caso_79_seguimiento where wf_caso_79_id =? group by wf_caso_79_id,wf_tarea_id order by wf_caso_79_id,wf_caso_79_seguimiento_id ) b using(wf_caso_79_seguimiento_id)
left join usuarios u using(core_usuario_id) where tabla not in ('sce.t53')
{"0":"642","id":"642","1":"288","wf_paso_id":"288","2":"546","wf_caso_79_seguimiento_id":"546","3":"133","core_usuario_id":"133","4":"2015-07-29 14:19:04","fecha_ejec":"2015-07-29 14:19:04","5":"196","dato":"196","6":"sce.t93","tabla":"sce.t93","7":"158","tarea_id":"158","8":"anonimo anonimo: ciudadano","usr_ejec":"anonimo anonimo: ciudadano"}
CargarDatos_288(196)
se carga 79_158_288_93_110_870960
se carga 79_158_288_93_110_7401
se carga 79_158_288_93_110_7311
se carga 79_158_288_93_110_730embigado
{"0":"644","id":"644","1":"402","wf_paso_id":"402","2":"547","wf_caso_79_seguimiento_id":"547","3":"133","core_usuario_id":"133","4":"2015-07-29 14:19:18","fecha_ejec":"2015-07-29 14:19:18","5":"12065","dato":"12065","6":"core_upload","tabla":"core_upload","7":"243","tarea_id":"243","8":"anonimo anonimo: ciudadano","usr_ejec":"anonimo anonimo: ciudadano"}
CargarDatos_402(12065)
{"0":"645","id":"645","1":"290","wf_paso_id":"290","2":"548","wf_caso_79_seguimiento_id":"548","3":"140","core_usuario_id":"140","4":"2015-07-29 17:01:27","fecha_ejec":"2015-07-29 17:01:27","5":"106","dato":"106","6":"sce.t94","tabla":"sce.t94","7":"159","tarea_id":"159","8":"796 Paola: Gerente","usr_ejec":"796 Paola: Gerente"}
CargarDatos_290(106)
se carga 79_159_290_94_111_87644
se carga 79_159_290_94_111_87531
se carga 79_159_290_94_111_8742015-07-26
se carga 79_159_290_94_111_873111
se carga 79_159_290_94_111_8722015-07-17
se carga 79_159_290_94_111_871123
se carga 79_159_290_94_111_7411
se carga 79_159_290_94_111_7391
se carga 79_159_290_94_111_7331
{"0":"646","id":"646","1":"361","wf_paso_id":"361","2":"549","wf_caso_79_seguimiento_id":"549","3":"140","core_usuario_id":"140","4":"2015-07-29 17:01:29","fecha_ejec":"2015-07-29 17:01:29","5":"12068","dato":"12068","6":"core_upload","tabla":"core_upload","7":"161","tarea_id":"161","8":"796 Paola: Gerente","usr_ejec":"796 Paola: Gerente"}
CargarDatos_361(12068)
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_79_seguimiento a
inner join (
select max(b0.id) as id,b0.wf_caso_79_id,b0.wf_tarea_id from wf_caso_79_seguimiento b0 where b0.wf_caso_79_id =? group by b0.wf_caso_79_id,b0.wf_tarea_id order by wf_caso_79_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":"546","id":"546","1":"269","wf_caso_79_id":"269","2":"158","wf_tarea_id":"158","3":null,"core_usuario_id":null,"4":"2015-07-29 14:18:41","fec_asig":"2015-07-29 14:18:41","5":"133","core_usuario_id_resol":"133","6":"2015-07-29 14:19:12","fec_resol":"2015-07-29 14:19:12","7":"158","wf_tarea_id_sig":"158","8":null,"usr_asig":null,"9":"anonimo anonimo: ciudadano","usr_resol":"anonimo anonimo: ciudadano"}
{"0":"547","id":"547","1":"269","wf_caso_79_id":"269","2":"243","wf_tarea_id":"243","3":"133","core_usuario_id":"133","4":"2015-07-29 14:19:12","fec_asig":"2015-07-29 14:19:12","5":"133","core_usuario_id_resol":"133","6":"2015-07-29 14:19:18","fec_resol":"2015-07-29 14:19:18","7":"243","wf_tarea_id_sig":"243","8":"anonimo anonimo: ciudadano","usr_asig":"anonimo anonimo: ciudadano","9":"anonimo anonimo: ciudadano","usr_resol":"anonimo anonimo: ciudadano"}
{"0":"548","id":"548","1":"269","wf_caso_79_id":"269","2":"159","wf_tarea_id":"159","3":null,"core_usuario_id":null,"4":"2015-07-29 14:19:18","fec_asig":"2015-07-29 14:19:18","5":"140","core_usuario_id_resol":"140","6":"2015-07-29 17:01:27","fec_resol":"2015-07-29 17:01:27","7":"159","wf_tarea_id_sig":"159","8":null,"usr_asig":null,"9":"796 Paola: Gerente","usr_resol":"796 Paola: Gerente"}
{"0":"549","id":"549","1":"269","wf_caso_79_id":"269","2":"161","wf_tarea_id":"161","3":"140","core_usuario_id":"140","4":"2015-07-29 17:01:27","fec_asig":"2015-07-29 17:01:27","5":null,"core_usuario_id_resol":null,"6":null,"fec_resol":null,"7":"161","wf_tarea_id_sig":"161","8":"796 Paola: Gerente","usr_asig":"796 Paola: Gerente","9":null,"usr_resol":null}
2015-07 29 17:01:43
cargar datos del sujeto(,,s,79,269)
select s.*, m.nombre as nom_muni, c.nom_cat,fec_caso
from wf_caso_79 w
inner join core_sujetoverificacion s on w.id=269 AND s.id =w.core_sujetoverificacion_id
inner join plan_municipio m on s.plan_municipio_id=m.id
inner join core_sujetocategoria c on s.core_sujetocategoria_id=c.id
2015-07 29 17:01:43
tabla dat adic
select tabla from core_sujetoverificaciontipo where id=1
2015-07 29 17:01:43
tabla :persona
SELECT * FROM persona where id=20490
2015-07 29 17:01:43
Continuar(s,161,364,)
EjecutarTarea_161() Certificado exitoso id_comp1124
140 140
ValidarUsuario(161):1
EjecutarPaso_364: ladj:28 , caso=269 id_comp 1124
Paso::Guardar(Caso:269)
rta: 1 dato:2501 tabla:wf_documentoentradaadj_caso
CasoPaso:647
CargarDatos_364(2501)
SiguientePasoDe364: Funcion para ejecutar el siguiente paso
EjecutarPaso_293: corr:38 , caso=269 id_comp 1124
Mostrar corr
ob_start();
$ciud = mb_strtoupper( "{ WFSV_79 } { WFSV_80 }",'utf-8');
?>
Apreciado(a)
El presente mensaje es una notificación para el caso No
{ WFSV_76 }
TWFSV_76:myriabe123@gmail.com
Certificado satisfactorio
Retorno :
Array
(
[ret] => inicioComponente_WF_Correo({"id":"1124","caso_id":"269","proceso_id":79,"tit":"Certificado exitoso","tarea_id":161,"paso_id":293,"desc":"\r\nApreciado(a)
\r\nMAYRA BURBANO<\/strong>\r\n\r\n
El presente mensaje es una notificación para el caso No 79269<\/strong> <\/p>\r\nSu solicitud de certificado fue exitoso. Ac\u00e9rquese a la ventanilla correspondiente para retirar su certificado
<\/strong> ","url":"De click aqui para volver a enviar el correo<\/a><\/div>"});
[suc] => 1
)
fin 2015-07-29 17:01:43
/******************************************************************************************************/
2015-07-29 17:01:50TraerCaso(269,79,)
CargarCaso :269
2015-07 29 17:01:50
CargarDatos: Caso :269
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_79_seguimiento_id,wf_paso_id from wf_caso_79_pasos a1 group by wf_caso_79_seguimiento_id,wf_paso_id order by id
)a
inner join wf_caso_79_pasos p using(id,wf_caso_79_seguimiento_id)
inner join ( select max(id) as wf_caso_79_seguimiento_id,wf_caso_79_id,wf_tarea_id from wf_caso_79_seguimiento where wf_caso_79_id =? group by wf_caso_79_id,wf_tarea_id order by wf_caso_79_id,wf_caso_79_seguimiento_id ) b using(wf_caso_79_seguimiento_id)
left join usuarios u using(core_usuario_id) where tabla not in ('sce.t53')
{"0":"642","id":"642","1":"288","wf_paso_id":"288","2":"546","wf_caso_79_seguimiento_id":"546","3":"133","core_usuario_id":"133","4":"2015-07-29 14:19:04","fecha_ejec":"2015-07-29 14:19:04","5":"196","dato":"196","6":"sce.t93","tabla":"sce.t93","7":"158","tarea_id":"158","8":"anonimo anonimo: ciudadano","usr_ejec":"anonimo anonimo: ciudadano"}
CargarDatos_288(196)
se carga 79_158_288_93_110_870960
se carga 79_158_288_93_110_7401
se carga 79_158_288_93_110_7311
se carga 79_158_288_93_110_730embigado
{"0":"644","id":"644","1":"402","wf_paso_id":"402","2":"547","wf_caso_79_seguimiento_id":"547","3":"133","core_usuario_id":"133","4":"2015-07-29 14:19:18","fecha_ejec":"2015-07-29 14:19:18","5":"12065","dato":"12065","6":"core_upload","tabla":"core_upload","7":"243","tarea_id":"243","8":"anonimo anonimo: ciudadano","usr_ejec":"anonimo anonimo: ciudadano"}
CargarDatos_402(12065)
{"0":"645","id":"645","1":"290","wf_paso_id":"290","2":"548","wf_caso_79_seguimiento_id":"548","3":"140","core_usuario_id":"140","4":"2015-07-29 17:01:27","fecha_ejec":"2015-07-29 17:01:27","5":"106","dato":"106","6":"sce.t94","tabla":"sce.t94","7":"159","tarea_id":"159","8":"796 Paola: Gerente","usr_ejec":"796 Paola: Gerente"}
CargarDatos_290(106)
se carga 79_159_290_94_111_87644
se carga 79_159_290_94_111_87531
se carga 79_159_290_94_111_8742015-07-26
se carga 79_159_290_94_111_873111
se carga 79_159_290_94_111_8722015-07-17
se carga 79_159_290_94_111_871123
se carga 79_159_290_94_111_7411
se carga 79_159_290_94_111_7391
se carga 79_159_290_94_111_7331
{"0":"646","id":"646","1":"361","wf_paso_id":"361","2":"549","wf_caso_79_seguimiento_id":"549","3":"140","core_usuario_id":"140","4":"2015-07-29 17:01:29","fecha_ejec":"2015-07-29 17:01:29","5":"12068","dato":"12068","6":"core_upload","tabla":"core_upload","7":"161","tarea_id":"161","8":"796 Paola: Gerente","usr_ejec":"796 Paola: Gerente"}
CargarDatos_361(12068)
{"0":"647","id":"647","1":"364","wf_paso_id":"364","2":"549","wf_caso_79_seguimiento_id":"549","3":"140","core_usuario_id":"140","4":"2015-07-29 17:01:43","fecha_ejec":"2015-07-29 17:01:43","5":"2501","dato":"2501","6":"wf_documentoentradaadj_caso","tabla":"wf_documentoentradaadj_caso","7":"161","tarea_id":"161","8":"796 Paola: Gerente","usr_ejec":"796 Paola: Gerente"}
CargarDatos_364(2501)
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_79_seguimiento a
inner join (
select max(b0.id) as id,b0.wf_caso_79_id,b0.wf_tarea_id from wf_caso_79_seguimiento b0 where b0.wf_caso_79_id =? group by b0.wf_caso_79_id,b0.wf_tarea_id order by wf_caso_79_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":"546","id":"546","1":"269","wf_caso_79_id":"269","2":"158","wf_tarea_id":"158","3":null,"core_usuario_id":null,"4":"2015-07-29 14:18:41","fec_asig":"2015-07-29 14:18:41","5":"133","core_usuario_id_resol":"133","6":"2015-07-29 14:19:12","fec_resol":"2015-07-29 14:19:12","7":"158","wf_tarea_id_sig":"158","8":null,"usr_asig":null,"9":"anonimo anonimo: ciudadano","usr_resol":"anonimo anonimo: ciudadano"}
{"0":"547","id":"547","1":"269","wf_caso_79_id":"269","2":"243","wf_tarea_id":"243","3":"133","core_usuario_id":"133","4":"2015-07-29 14:19:12","fec_asig":"2015-07-29 14:19:12","5":"133","core_usuario_id_resol":"133","6":"2015-07-29 14:19:18","fec_resol":"2015-07-29 14:19:18","7":"243","wf_tarea_id_sig":"243","8":"anonimo anonimo: ciudadano","usr_asig":"anonimo anonimo: ciudadano","9":"anonimo anonimo: ciudadano","usr_resol":"anonimo anonimo: ciudadano"}
{"0":"548","id":"548","1":"269","wf_caso_79_id":"269","2":"159","wf_tarea_id":"159","3":null,"core_usuario_id":null,"4":"2015-07-29 14:19:18","fec_asig":"2015-07-29 14:19:18","5":"140","core_usuario_id_resol":"140","6":"2015-07-29 17:01:27","fec_resol":"2015-07-29 17:01:27","7":"159","wf_tarea_id_sig":"159","8":null,"usr_asig":null,"9":"796 Paola: Gerente","usr_resol":"796 Paola: Gerente"}
{"0":"549","id":"549","1":"269","wf_caso_79_id":"269","2":"161","wf_tarea_id":"161","3":"140","core_usuario_id":"140","4":"2015-07-29 17:01:27","fec_asig":"2015-07-29 17:01:27","5":null,"core_usuario_id_resol":null,"6":null,"fec_resol":null,"7":"161","wf_tarea_id_sig":"161","8":"796 Paola: Gerente","usr_asig":"796 Paola: Gerente","9":null,"usr_resol":null}
2015-07 29 17:01:50
cargar datos del sujeto(,,s,79,269)
select s.*, m.nombre as nom_muni, c.nom_cat,fec_caso
from wf_caso_79 w
inner join core_sujetoverificacion s on w.id=269 AND s.id =w.core_sujetoverificacion_id
inner join plan_municipio m on s.plan_municipio_id=m.id
inner join core_sujetocategoria c on s.core_sujetocategoria_id=c.id
2015-07 29 17:01:50
tabla dat adic
select tabla from core_sujetoverificaciontipo where id=1
2015-07 29 17:01:50
tabla :persona
SELECT * FROM persona where id=20490
2015-07 29 17:01:50
Continuar(s,161,293,)
EjecutarTarea_161() Certificado exitoso id_comp1124
140 140
ValidarUsuario(161):1
EjecutarPaso_293: corr:38 , caso=269 id_comp 1124
Paso::Guardar(Caso:269)
rta: 1 dato: tabla:
CasoPaso:648
CargarDatos_293()
SiguientePasoDe293: Funcion para ejecutar el siguiente paso
TerminarTarea(161,)
Retorno :
Array
(
[htm] =>
[suc] => 1
[ret] => crearMsg('El proceso ha terminado exitosamente, si considera que no debe ser asà comuniquese con el administrador del sistema','Información');Ext.getCmp('comp_1124').funcionInicial('n');
)
fin 2015-07-29 17:01:50
/******************************************************************************************************/
2015-07-29 17:03:04TraerCaso(269,79,)
CargarCaso :269
2015-07 29 17:03:04
CargarDatos: Caso :269
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_79_seguimiento_id,wf_paso_id from wf_caso_79_pasos a1 group by wf_caso_79_seguimiento_id,wf_paso_id order by id
)a
inner join wf_caso_79_pasos p using(id,wf_caso_79_seguimiento_id)
inner join ( select max(id) as wf_caso_79_seguimiento_id,wf_caso_79_id,wf_tarea_id from wf_caso_79_seguimiento where wf_caso_79_id =? group by wf_caso_79_id,wf_tarea_id order by wf_caso_79_id,wf_caso_79_seguimiento_id ) b using(wf_caso_79_seguimiento_id)
left join usuarios u using(core_usuario_id) where tabla not in ('sce.t53')
{"0":"642","id":"642","1":"288","wf_paso_id":"288","2":"546","wf_caso_79_seguimiento_id":"546","3":"133","core_usuario_id":"133","4":"2015-07-29 14:19:04","fecha_ejec":"2015-07-29 14:19:04","5":"196","dato":"196","6":"sce.t93","tabla":"sce.t93","7":"158","tarea_id":"158","8":"anonimo anonimo: ciudadano","usr_ejec":"anonimo anonimo: ciudadano"}
CargarDatos_288(196)
se carga 79_158_288_93_110_870960
se carga 79_158_288_93_110_7401
se carga 79_158_288_93_110_7311
se carga 79_158_288_93_110_730embigado
{"0":"644","id":"644","1":"402","wf_paso_id":"402","2":"547","wf_caso_79_seguimiento_id":"547","3":"133","core_usuario_id":"133","4":"2015-07-29 14:19:18","fecha_ejec":"2015-07-29 14:19:18","5":"12065","dato":"12065","6":"core_upload","tabla":"core_upload","7":"243","tarea_id":"243","8":"anonimo anonimo: ciudadano","usr_ejec":"anonimo anonimo: ciudadano"}
CargarDatos_402(12065)
{"0":"645","id":"645","1":"290","wf_paso_id":"290","2":"548","wf_caso_79_seguimiento_id":"548","3":"140","core_usuario_id":"140","4":"2015-07-29 17:01:27","fecha_ejec":"2015-07-29 17:01:27","5":"106","dato":"106","6":"sce.t94","tabla":"sce.t94","7":"159","tarea_id":"159","8":"796 Paola: Gerente","usr_ejec":"796 Paola: Gerente"}
CargarDatos_290(106)
se carga 79_159_290_94_111_87644
se carga 79_159_290_94_111_87531
se carga 79_159_290_94_111_8742015-07-26
se carga 79_159_290_94_111_873111
se carga 79_159_290_94_111_8722015-07-17
se carga 79_159_290_94_111_871123
se carga 79_159_290_94_111_7411
se carga 79_159_290_94_111_7391
se carga 79_159_290_94_111_7331
{"0":"646","id":"646","1":"361","wf_paso_id":"361","2":"549","wf_caso_79_seguimiento_id":"549","3":"140","core_usuario_id":"140","4":"2015-07-29 17:01:29","fecha_ejec":"2015-07-29 17:01:29","5":"12068","dato":"12068","6":"core_upload","tabla":"core_upload","7":"161","tarea_id":"161","8":"796 Paola: Gerente","usr_ejec":"796 Paola: Gerente"}
CargarDatos_361(12068)
{"0":"647","id":"647","1":"364","wf_paso_id":"364","2":"549","wf_caso_79_seguimiento_id":"549","3":"140","core_usuario_id":"140","4":"2015-07-29 17:01:43","fecha_ejec":"2015-07-29 17:01:43","5":"2501","dato":"2501","6":"wf_documentoentradaadj_caso","tabla":"wf_documentoentradaadj_caso","7":"161","tarea_id":"161","8":"796 Paola: Gerente","usr_ejec":"796 Paola: Gerente"}
CargarDatos_364(2501)
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_79_seguimiento a
inner join (
select max(b0.id) as id,b0.wf_caso_79_id,b0.wf_tarea_id from wf_caso_79_seguimiento b0 where b0.wf_caso_79_id =? group by b0.wf_caso_79_id,b0.wf_tarea_id order by wf_caso_79_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":"546","id":"546","1":"269","wf_caso_79_id":"269","2":"158","wf_tarea_id":"158","3":null,"core_usuario_id":null,"4":"2015-07-29 14:18:41","fec_asig":"2015-07-29 14:18:41","5":"133","core_usuario_id_resol":"133","6":"2015-07-29 14:19:12","fec_resol":"2015-07-29 14:19:12","7":"158","wf_tarea_id_sig":"158","8":null,"usr_asig":null,"9":"anonimo anonimo: ciudadano","usr_resol":"anonimo anonimo: ciudadano"}
{"0":"547","id":"547","1":"269","wf_caso_79_id":"269","2":"243","wf_tarea_id":"243","3":"133","core_usuario_id":"133","4":"2015-07-29 14:19:12","fec_asig":"2015-07-29 14:19:12","5":"133","core_usuario_id_resol":"133","6":"2015-07-29 14:19:18","fec_resol":"2015-07-29 14:19:18","7":"243","wf_tarea_id_sig":"243","8":"anonimo anonimo: ciudadano","usr_asig":"anonimo anonimo: ciudadano","9":"anonimo anonimo: ciudadano","usr_resol":"anonimo anonimo: ciudadano"}
{"0":"548","id":"548","1":"269","wf_caso_79_id":"269","2":"159","wf_tarea_id":"159","3":null,"core_usuario_id":null,"4":"2015-07-29 14:19:18","fec_asig":"2015-07-29 14:19:18","5":"140","core_usuario_id_resol":"140","6":"2015-07-29 17:01:27","fec_resol":"2015-07-29 17:01:27","7":"159","wf_tarea_id_sig":"159","8":null,"usr_asig":null,"9":"796 Paola: Gerente","usr_resol":"796 Paola: Gerente"}
{"0":"549","id":"549","1":"269","wf_caso_79_id":"269","2":"161","wf_tarea_id":"161","3":"140","core_usuario_id":"140","4":"2015-07-29 17:01:27","fec_asig":"2015-07-29 17:01:27","5":"140","core_usuario_id_resol":"140","6":"2015-07-29 17:01:50","fec_resol":"2015-07-29 17:01:50","7":"161","wf_tarea_id_sig":"161","8":"796 Paola: Gerente","usr_asig":"796 Paola: Gerente","9":"796 Paola: Gerente","usr_resol":"796 Paola: Gerente"}
2015-07 29 17:03:04
cargar datos del sujeto(,,s,79,269)
select s.*, m.nombre as nom_muni, c.nom_cat,fec_caso
from wf_caso_79 w
inner join core_sujetoverificacion s on w.id=269 AND s.id =w.core_sujetoverificacion_id
inner join plan_municipio m on s.plan_municipio_id=m.id
inner join core_sujetocategoria c on s.core_sujetocategoria_id=c.id
2015-07 29 17:03:04
tabla dat adic
select tabla from core_sujetoverificaciontipo where id=1
2015-07 29 17:03:04
tabla :persona
SELECT * FROM persona where id=20490
ob_start();
$ciud = mb_strtoupper( "{ WFSV_79 } { WFSV_80 }",'utf-8');
?>
Apreciado(a)
El presente mensaje es una notificación para el caso No
{ WFSV_76 }
TWFSV_76:myriabe123@gmail.com
Certificado satisfactorio
fin 2015-07-29 17:03:04
/******************************************************************************************************/
2015-07-29 17:03:21TraerCaso(269,79,)
CargarCaso :269
2015-07 29 17:03:21
CargarDatos: Caso :269
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_79_seguimiento_id,wf_paso_id from wf_caso_79_pasos a1 group by wf_caso_79_seguimiento_id,wf_paso_id order by id
)a
inner join wf_caso_79_pasos p using(id,wf_caso_79_seguimiento_id)
inner join ( select max(id) as wf_caso_79_seguimiento_id,wf_caso_79_id,wf_tarea_id from wf_caso_79_seguimiento where wf_caso_79_id =? group by wf_caso_79_id,wf_tarea_id order by wf_caso_79_id,wf_caso_79_seguimiento_id ) b using(wf_caso_79_seguimiento_id)
left join usuarios u using(core_usuario_id) where tabla not in ('sce.t53')
{"0":"642","id":"642","1":"288","wf_paso_id":"288","2":"546","wf_caso_79_seguimiento_id":"546","3":"133","core_usuario_id":"133","4":"2015-07-29 14:19:04","fecha_ejec":"2015-07-29 14:19:04","5":"196","dato":"196","6":"sce.t93","tabla":"sce.t93","7":"158","tarea_id":"158","8":"anonimo anonimo: ciudadano","usr_ejec":"anonimo anonimo: ciudadano"}
CargarDatos_288(196)
se carga 79_158_288_93_110_870960
se carga 79_158_288_93_110_7401
se carga 79_158_288_93_110_7311
se carga 79_158_288_93_110_730embigado
{"0":"644","id":"644","1":"402","wf_paso_id":"402","2":"547","wf_caso_79_seguimiento_id":"547","3":"133","core_usuario_id":"133","4":"2015-07-29 14:19:18","fecha_ejec":"2015-07-29 14:19:18","5":"12065","dato":"12065","6":"core_upload","tabla":"core_upload","7":"243","tarea_id":"243","8":"anonimo anonimo: ciudadano","usr_ejec":"anonimo anonimo: ciudadano"}
CargarDatos_402(12065)
{"0":"645","id":"645","1":"290","wf_paso_id":"290","2":"548","wf_caso_79_seguimiento_id":"548","3":"140","core_usuario_id":"140","4":"2015-07-29 17:01:27","fecha_ejec":"2015-07-29 17:01:27","5":"106","dato":"106","6":"sce.t94","tabla":"sce.t94","7":"159","tarea_id":"159","8":"796 Paola: Gerente","usr_ejec":"796 Paola: Gerente"}
CargarDatos_290(106)
se carga 79_159_290_94_111_87644
se carga 79_159_290_94_111_87531
se carga 79_159_290_94_111_8742015-07-26
se carga 79_159_290_94_111_873111
se carga 79_159_290_94_111_8722015-07-17
se carga 79_159_290_94_111_871123
se carga 79_159_290_94_111_7411
se carga 79_159_290_94_111_7391
se carga 79_159_290_94_111_7331
{"0":"646","id":"646","1":"361","wf_paso_id":"361","2":"549","wf_caso_79_seguimiento_id":"549","3":"140","core_usuario_id":"140","4":"2015-07-29 17:01:29","fecha_ejec":"2015-07-29 17:01:29","5":"12068","dato":"12068","6":"core_upload","tabla":"core_upload","7":"161","tarea_id":"161","8":"796 Paola: Gerente","usr_ejec":"796 Paola: Gerente"}
CargarDatos_361(12068)
{"0":"647","id":"647","1":"364","wf_paso_id":"364","2":"549","wf_caso_79_seguimiento_id":"549","3":"140","core_usuario_id":"140","4":"2015-07-29 17:01:43","fecha_ejec":"2015-07-29 17:01:43","5":"2501","dato":"2501","6":"wf_documentoentradaadj_caso","tabla":"wf_documentoentradaadj_caso","7":"161","tarea_id":"161","8":"796 Paola: Gerente","usr_ejec":"796 Paola: Gerente"}
CargarDatos_364(2501)
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_79_seguimiento a
inner join (
select max(b0.id) as id,b0.wf_caso_79_id,b0.wf_tarea_id from wf_caso_79_seguimiento b0 where b0.wf_caso_79_id =? group by b0.wf_caso_79_id,b0.wf_tarea_id order by wf_caso_79_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":"546","id":"546","1":"269","wf_caso_79_id":"269","2":"158","wf_tarea_id":"158","3":null,"core_usuario_id":null,"4":"2015-07-29 14:18:41","fec_asig":"2015-07-29 14:18:41","5":"133","core_usuario_id_resol":"133","6":"2015-07-29 14:19:12","fec_resol":"2015-07-29 14:19:12","7":"158","wf_tarea_id_sig":"158","8":null,"usr_asig":null,"9":"anonimo anonimo: ciudadano","usr_resol":"anonimo anonimo: ciudadano"}
{"0":"547","id":"547","1":"269","wf_caso_79_id":"269","2":"243","wf_tarea_id":"243","3":"133","core_usuario_id":"133","4":"2015-07-29 14:19:12","fec_asig":"2015-07-29 14:19:12","5":"133","core_usuario_id_resol":"133","6":"2015-07-29 14:19:18","fec_resol":"2015-07-29 14:19:18","7":"243","wf_tarea_id_sig":"243","8":"anonimo anonimo: ciudadano","usr_asig":"anonimo anonimo: ciudadano","9":"anonimo anonimo: ciudadano","usr_resol":"anonimo anonimo: ciudadano"}
{"0":"548","id":"548","1":"269","wf_caso_79_id":"269","2":"159","wf_tarea_id":"159","3":null,"core_usuario_id":null,"4":"2015-07-29 14:19:18","fec_asig":"2015-07-29 14:19:18","5":"140","core_usuario_id_resol":"140","6":"2015-07-29 17:01:27","fec_resol":"2015-07-29 17:01:27","7":"159","wf_tarea_id_sig":"159","8":null,"usr_asig":null,"9":"796 Paola: Gerente","usr_resol":"796 Paola: Gerente"}
{"0":"549","id":"549","1":"269","wf_caso_79_id":"269","2":"161","wf_tarea_id":"161","3":"140","core_usuario_id":"140","4":"2015-07-29 17:01:27","fec_asig":"2015-07-29 17:01:27","5":"140","core_usuario_id_resol":"140","6":"2015-07-29 17:01:50","fec_resol":"2015-07-29 17:01:50","7":"161","wf_tarea_id_sig":"161","8":"796 Paola: Gerente","usr_asig":"796 Paola: Gerente","9":"796 Paola: Gerente","usr_resol":"796 Paola: Gerente"}
2015-07 29 17:03:21
cargar datos del sujeto(,,s,79,269)
select s.*, m.nombre as nom_muni, c.nom_cat,fec_caso
from wf_caso_79 w
inner join core_sujetoverificacion s on w.id=269 AND s.id =w.core_sujetoverificacion_id
inner join plan_municipio m on s.plan_municipio_id=m.id
inner join core_sujetocategoria c on s.core_sujetocategoria_id=c.id
2015-07 29 17:03:21
tabla dat adic
select tabla from core_sujetoverificaciontipo where id=1
2015-07 29 17:03:21
tabla :persona
SELECT * FROM persona where id=20490
ob_start();
$ciud = mb_strtoupper( "{ WFSV_79 } { WFSV_80 }",'utf-8');
?>
Apreciado(a)
El presente mensaje es una notificación para el caso No
{ WFSV_76 }
TWFSV_76:myriabe123@gmail.com
Certificado satisfactorio
fin 2015-07-29 17:03:21
/******************************************************************************************************/