2015-06 30 16:58:03
Nuevo(101,1)
Caso :29
2015-06 30 16:58:03
cargar datos del sujeto(,,s,34,29)
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=29 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 30 16:58:03
tabla dat adic
select tabla from core_sujetoverificaciontipo where id=1
2015-06 30 16:58:03
tabla :persona
SELECT * FROM persona where id=101
CasoSeguimiento :84
EjecutarTarea_36() Formulario de registro id_comp1170
51
ValidarUsuario(36):1
EjecutarPaso_46: form:5 , caso=29 id_comp 1170
Mostrar form
fin 2015-06-30 16:58:03
/******************************************************************************************************/
2015-06-30 16:58:03TraerCaso(29,34,)
CargarCaso :29
2015-06 30 16:58:03
CargarDatos: Caso :29
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":"84","id":"84","1":"29","wf_caso_34_id":"29","2":"36","wf_tarea_id":"36","3":null,"core_usuario_id":null,"4":"2015-06-30 16:58:03","fec_asig":"2015-06-30 16:58:03","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}
2015-06 30 16:58:03
cargar datos del sujeto(,,s,34,29)
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=29 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 30 16:58:03
tabla dat adic
select tabla from core_sujetoverificaciontipo where id=1
2015-06 30 16:58:03
tabla :persona
SELECT * FROM persona where id=101
fin 2015-06-30 16:58:03
/******************************************************************************************************/
2015-06-30 16:58:51TraerCaso(29,34,)
CargarCaso :29
2015-06 30 16:58:51
CargarDatos: Caso :29
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":"84","id":"84","1":"29","wf_caso_34_id":"29","2":"36","wf_tarea_id":"36","3":null,"core_usuario_id":null,"4":"2015-06-30 16:58:03","fec_asig":"2015-06-30 16:58:03","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}
2015-06 30 16:58:51
cargar datos del sujeto(,,s,34,29)
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=29 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 30 16:58:51
tabla dat adic
select tabla from core_sujetoverificaciontipo where id=1
2015-06 30 16:58:51
tabla :persona
SELECT * FROM persona where id=101
2015-06 30 16:58:51
Continuar(s,36,46,)
EjecutarTarea_36() Formulario de registro id_comp1170
51
ValidarUsuario(36):1
EjecutarPaso_46: form:5 , caso=29 id_comp 1170
Paso::Guardar(Caso:29)
Datos a guardar:
Array
(
[wf_proceso_id] => 34
[wf_paso_id] => 46
[wf_tarea_id] => 36
[wf_caso_id] => 29
[id] => 1170
[accion] => nextPaso
[reg] => s
[rta] => n
[cod_formulario2] => 5
[id_periodo] => 2015
[obs_ingreso] =>
[cod_bloque] => 6
[oid] =>
[oid_maestro] =>
[222] => 2015-06-30
[225] => 1
[226] => manzana 2
[227] => 12
[228] => Remodelación
)
OID: 25
rta: 1 dato:25 tabla:sce.t5
CasoPaso:143
CargarDatos_46(25)
se carga 34_36_46_5_6_302
se carga 34_36_46_5_6_228Remodelación
se carga 34_36_46_5_6_22712
se carga 34_36_46_5_6_226manzana 2
se carga 34_36_46_5_6_2251
se carga 34_36_46_5_6_2222015-06-30
SiguientePasoDe46: Funcion para ejecutar el siguiente paso
EjecutarPaso_47: ladj:62 , caso=29 id_comp 1170
Mostrar ladj
Retorno :
Array
(
[ret] => inicioComponente_WF_ladj({"tarea_id":36,"paso_id":47,"id":"1170","proceso_id":34,"caso_id":"29","sujeto_id":"101","ladj":62});
[suc] => 1
)
fin 2015-06-30 16:58:51
/******************************************************************************************************/
2015-06-30 16:59:52TraerCaso(29,34,)
CargarCaso :29
2015-06 30 16:59:52
CargarDatos: Caso :29
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":"143","id":"143","1":"46","wf_paso_id":"46","2":"84","wf_caso_34_seguimiento_id":"84","3":"51","core_usuario_id":"51","4":"2015-06-30 16:58:51","fecha_ejec":"2015-06-30 16:58:51","5":"25","dato":"25","6":"sce.t5","tabla":"sce.t5","7":"36","tarea_id":"36","8":"Ruano Marcela: ciudadano","usr_ejec":"Ruano Marcela: ciudadano"}
CargarDatos_46(25)
se carga 34_36_46_5_6_302
se carga 34_36_46_5_6_228Remodelación
se carga 34_36_46_5_6_22712
se carga 34_36_46_5_6_226manzana 2
se carga 34_36_46_5_6_2251
se carga 34_36_46_5_6_2222015-06-30
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":"84","id":"84","1":"29","wf_caso_34_id":"29","2":"36","wf_tarea_id":"36","3":null,"core_usuario_id":null,"4":"2015-06-30 16:58:03","fec_asig":"2015-06-30 16:58:03","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}
2015-06 30 16:59:52
cargar datos del sujeto(,,s,34,29)
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=29 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 30 16:59:52
tabla dat adic
select tabla from core_sujetoverificaciontipo where id=1
2015-06 30 16:59:52
tabla :persona
SELECT * FROM persona where id=101
2015-06 30 16:59:52
Continuar(s,36,47,)
EjecutarTarea_36() Formulario de registro id_comp1170
51
ValidarUsuario(36):1
EjecutarPaso_47: ladj:62 , caso=29 id_comp 1170
Paso::Guardar(Caso:29)
rta: 1 dato:6467 tabla:wf_documentoentradaadj_caso
CasoPaso:144
CargarDatos_47(6467)
SiguientePasoDe47: Funcion para ejecutar el siguiente paso
EjecutarPaso_118: corr:40 , caso=29 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":"29","proceso_id":34,"tit":"Formulario de registro","tarea_id":36,"paso_id":118,"desc":"\nApreciado(a)
\nMARCELA RUANO<\/strong>\n\n
El presente mensaje es una notificación para el caso No 29<\/strong> <\/p>\nSu solicitud de concepto de norma urban\u00edstica ha sido registrada exitosamente y ya se encuentra en tr\u00e1mite.<\/strong> ","url":"De click aqui para volver a enviar el correo<\/a><\/div>"});
[suc] => 1
)
fin 2015-06-30 16:59:52
/******************************************************************************************************/
2015-06-30 16:59:59TraerCaso(29,34,)
CargarCaso :29
2015-06 30 16:59:59
CargarDatos: Caso :29
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":"143","id":"143","1":"46","wf_paso_id":"46","2":"84","wf_caso_34_seguimiento_id":"84","3":"51","core_usuario_id":"51","4":"2015-06-30 16:58:51","fecha_ejec":"2015-06-30 16:58:51","5":"25","dato":"25","6":"sce.t5","tabla":"sce.t5","7":"36","tarea_id":"36","8":"Ruano Marcela: ciudadano","usr_ejec":"Ruano Marcela: ciudadano"}
CargarDatos_46(25)
se carga 34_36_46_5_6_302
se carga 34_36_46_5_6_228Remodelación
se carga 34_36_46_5_6_22712
se carga 34_36_46_5_6_226manzana 2
se carga 34_36_46_5_6_2251
se carga 34_36_46_5_6_2222015-06-30
{"0":"144","id":"144","1":"47","wf_paso_id":"47","2":"84","wf_caso_34_seguimiento_id":"84","3":"51","core_usuario_id":"51","4":"2015-06-30 16:59:52","fecha_ejec":"2015-06-30 16:59:52","5":"6467","dato":"6467","6":"wf_documentoentradaadj_caso","tabla":"wf_documentoentradaadj_caso","7":"36","tarea_id":"36","8":"Ruano Marcela: ciudadano","usr_ejec":"Ruano Marcela: ciudadano"}
CargarDatos_47(6467)
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":"84","id":"84","1":"29","wf_caso_34_id":"29","2":"36","wf_tarea_id":"36","3":null,"core_usuario_id":null,"4":"2015-06-30 16:58:03","fec_asig":"2015-06-30 16:58:03","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}
2015-06 30 16:59:59
cargar datos del sujeto(,,s,34,29)
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=29 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 30 16:59:59
tabla dat adic
select tabla from core_sujetoverificaciontipo where id=1
2015-06 30 16:59:59
tabla :persona
SELECT * FROM persona where id=101
2015-06 30 16:59:59
Continuar(s,36,118,)
EjecutarTarea_36() Formulario de registro id_comp1170
51
ValidarUsuario(36):1
EjecutarPaso_118: corr:40 , caso=29 id_comp 1170
Paso::Guardar(Caso:29)
rta: 1 dato: tabla:
CasoPaso:145
CargarDatos_118()
SiguientePasoDe118: Funcion para ejecutar el siguiente paso
Condicion Tarea : true
TerminarTarea(36,72)
Ultimo seg :84
Ultimo seg :85
EjecutarTarea_72() Verificación id_comp1170
51
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 2015-06-30 16:59:59
/******************************************************************************************************/
2015-07-10 15:39:37TraerCaso(29,34,)
CargarCaso :29
2015-07 10 15:39:37
CargarDatos: Caso :29
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":"143","id":"143","1":"46","wf_paso_id":"46","2":"84","wf_caso_34_seguimiento_id":"84","3":"51","core_usuario_id":"51","4":"2015-06-30 16:58:51","fecha_ejec":"2015-06-30 16:58:51","5":"25","dato":"25","6":"sce.t5","tabla":"sce.t5","7":"36","tarea_id":"36","8":"Ruano Marcela: ciudadano","usr_ejec":"Ruano Marcela: ciudadano"}
CargarDatos_46(25)
se carga 34_36_46_5_6_302
se carga 34_36_46_5_6_228Remodelación
se carga 34_36_46_5_6_22712
se carga 34_36_46_5_6_226manzana 2
se carga 34_36_46_5_6_2251
se carga 34_36_46_5_6_2222015-06-30
{"0":"144","id":"144","1":"47","wf_paso_id":"47","2":"84","wf_caso_34_seguimiento_id":"84","3":"51","core_usuario_id":"51","4":"2015-06-30 16:59:52","fecha_ejec":"2015-06-30 16:59:52","5":"6467","dato":"6467","6":"wf_documentoentradaadj_caso","tabla":"wf_documentoentradaadj_caso","7":"36","tarea_id":"36","8":"Ruano Marcela: ciudadano","usr_ejec":"Ruano Marcela: ciudadano"}
CargarDatos_47(6467)
{"0":"145","id":"145","1":"118","wf_paso_id":"118","2":"84","wf_caso_34_seguimiento_id":"84","3":"51","core_usuario_id":"51","4":"2015-06-30 16:59:59","fecha_ejec":"2015-06-30 16:59:59","5":null,"dato":null,"6":null,"tabla":null,"7":"36","tarea_id":"36","8":"Ruano Marcela: ciudadano","usr_ejec":"Ruano Marcela: 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":"84","id":"84","1":"29","wf_caso_34_id":"29","2":"36","wf_tarea_id":"36","3":null,"core_usuario_id":null,"4":"2015-06-30 16:58:03","fec_asig":"2015-06-30 16:58:03","5":"51","core_usuario_id_resol":"51","6":"2015-06-30 16:59:59","fec_resol":"2015-06-30 16:59:59","7":"36","wf_tarea_id_sig":"36","8":null,"usr_asig":null,"9":"Ruano Marcela: ciudadano","usr_resol":"Ruano Marcela: ciudadano"}
{"0":"85","id":"85","1":"29","wf_caso_34_id":"29","2":"72","wf_tarea_id":"72","3":null,"core_usuario_id":null,"4":"2015-06-30 16:59:59","fec_asig":"2015-06-30 16:59:59","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}
2015-07 10 15:39:37
cargar datos del sujeto(,,s,34,29)
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=29 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 10 15:39:37
tabla dat adic
select tabla from core_sujetoverificaciontipo where id=1
2015-07 10 15:39:37
tabla :persona
SELECT * FROM persona where id=101
2015-07 10 15:39:37
Continuar(,72,,s)
EjecutarTarea_72() Verificación id_comp1173
11
ValidarUsuario(72):1
EjecutarPaso_161: vadj:62 , caso=29 id_comp 1173
Mostrar vadj
Retorno :
Array
(
[ret] => inicioComponente_WF_vadj({"tarea_id":72,"paso_id":161,"id":"1173","proceso_id":34,"caso_id":"29","sujeto_id":"101","vadj":62});
[suc] => 1
)
fin 2015-07-10 15:39:37
/******************************************************************************************************/
2015-07-10 15:39:44TraerCaso(29,34,)
CargarCaso :29
2015-07 10 15:39:45
CargarDatos: Caso :29
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":"143","id":"143","1":"46","wf_paso_id":"46","2":"84","wf_caso_34_seguimiento_id":"84","3":"51","core_usuario_id":"51","4":"2015-06-30 16:58:51","fecha_ejec":"2015-06-30 16:58:51","5":"25","dato":"25","6":"sce.t5","tabla":"sce.t5","7":"36","tarea_id":"36","8":"Ruano Marcela: ciudadano","usr_ejec":"Ruano Marcela: ciudadano"}
CargarDatos_46(25)
se carga 34_36_46_5_6_302
se carga 34_36_46_5_6_228Remodelación
se carga 34_36_46_5_6_22712
se carga 34_36_46_5_6_226manzana 2
se carga 34_36_46_5_6_2251
se carga 34_36_46_5_6_2222015-06-30
{"0":"144","id":"144","1":"47","wf_paso_id":"47","2":"84","wf_caso_34_seguimiento_id":"84","3":"51","core_usuario_id":"51","4":"2015-06-30 16:59:52","fecha_ejec":"2015-06-30 16:59:52","5":"6467","dato":"6467","6":"wf_documentoentradaadj_caso","tabla":"wf_documentoentradaadj_caso","7":"36","tarea_id":"36","8":"Ruano Marcela: ciudadano","usr_ejec":"Ruano Marcela: ciudadano"}
CargarDatos_47(6467)
{"0":"145","id":"145","1":"118","wf_paso_id":"118","2":"84","wf_caso_34_seguimiento_id":"84","3":"51","core_usuario_id":"51","4":"2015-06-30 16:59:59","fecha_ejec":"2015-06-30 16:59:59","5":null,"dato":null,"6":null,"tabla":null,"7":"36","tarea_id":"36","8":"Ruano Marcela: ciudadano","usr_ejec":"Ruano Marcela: 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":"84","id":"84","1":"29","wf_caso_34_id":"29","2":"36","wf_tarea_id":"36","3":null,"core_usuario_id":null,"4":"2015-06-30 16:58:03","fec_asig":"2015-06-30 16:58:03","5":"51","core_usuario_id_resol":"51","6":"2015-06-30 16:59:59","fec_resol":"2015-06-30 16:59:59","7":"36","wf_tarea_id_sig":"36","8":null,"usr_asig":null,"9":"Ruano Marcela: ciudadano","usr_resol":"Ruano Marcela: ciudadano"}
{"0":"85","id":"85","1":"29","wf_caso_34_id":"29","2":"72","wf_tarea_id":"72","3":null,"core_usuario_id":null,"4":"2015-06-30 16:59:59","fec_asig":"2015-06-30 16:59:59","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}
2015-07 10 15:39:45
cargar datos del sujeto(,,s,34,29)
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=29 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 10 15:39:45
tabla dat adic
select tabla from core_sujetoverificaciontipo where id=1
2015-07 10 15:39:45
tabla :persona
SELECT * FROM persona where id=101
2015-07 10 15:39:45
Continuar(s,72,161,)
EjecutarTarea_72() Verificación id_comp1173
11
ValidarUsuario(72):1
EjecutarPaso_161: vadj:62 , caso=29 id_comp 1173
Paso::Guardar(Caso:29)
rta: 1 dato:2637 tabla:wf_documentoentradaadj_caso
CasoPaso:146
CargarDatos_161(2637)
SiguientePasoDe161: Funcion para ejecutar el siguiente paso
Condicion Tarea : Si =="Si"
TerminarTarea(72,37)
Ultimo seg :85
Ultimo seg :86
EjecutarTarea_37() Radicación id_comp1173
11 11
ValidarUsuario(37):1
EjecutarPaso_50: form:6 , caso=29 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_29',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:'2015'}) ,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':'29'},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_29'); 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:'29',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_29').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":"29"}'}}); }catch(e){alert(e);} } } }) );Ext.getCmp('comp_1173').doLayout();
[suc] => 1
)
fin 2015-07-10 15:39:45
/******************************************************************************************************/
2015-07-10 15:39:45TraerCaso(29,34,)
CargarCaso :29
2015-07 10 15:39:45
CargarDatos: Caso :29
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":"143","id":"143","1":"46","wf_paso_id":"46","2":"84","wf_caso_34_seguimiento_id":"84","3":"51","core_usuario_id":"51","4":"2015-06-30 16:58:51","fecha_ejec":"2015-06-30 16:58:51","5":"25","dato":"25","6":"sce.t5","tabla":"sce.t5","7":"36","tarea_id":"36","8":"Ruano Marcela: ciudadano","usr_ejec":"Ruano Marcela: ciudadano"}
CargarDatos_46(25)
se carga 34_36_46_5_6_302
se carga 34_36_46_5_6_228Remodelación
se carga 34_36_46_5_6_22712
se carga 34_36_46_5_6_226manzana 2
se carga 34_36_46_5_6_2251
se carga 34_36_46_5_6_2222015-06-30
{"0":"144","id":"144","1":"47","wf_paso_id":"47","2":"84","wf_caso_34_seguimiento_id":"84","3":"51","core_usuario_id":"51","4":"2015-06-30 16:59:52","fecha_ejec":"2015-06-30 16:59:52","5":"6467","dato":"6467","6":"wf_documentoentradaadj_caso","tabla":"wf_documentoentradaadj_caso","7":"36","tarea_id":"36","8":"Ruano Marcela: ciudadano","usr_ejec":"Ruano Marcela: ciudadano"}
CargarDatos_47(6467)
{"0":"145","id":"145","1":"118","wf_paso_id":"118","2":"84","wf_caso_34_seguimiento_id":"84","3":"51","core_usuario_id":"51","4":"2015-06-30 16:59:59","fecha_ejec":"2015-06-30 16:59:59","5":null,"dato":null,"6":null,"tabla":null,"7":"36","tarea_id":"36","8":"Ruano Marcela: ciudadano","usr_ejec":"Ruano Marcela: ciudadano"}
CargarDatos_118()
{"0":"146","id":"146","1":"161","wf_paso_id":"161","2":"85","wf_caso_34_seguimiento_id":"85","3":"11","core_usuario_id":"11","4":"2015-07-10 15:39:45","fecha_ejec":"2015-07-10 15:39:45","5":"2637","dato":"2637","6":"wf_documentoentradaadj_caso","tabla":"wf_documentoentradaadj_caso","7":"72","tarea_id":"72","8":"siti soluciones German: ciudadano, gerente","usr_ejec":"siti soluciones German: ciudadano, gerente"}
CargarDatos_161(2637)
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":"84","id":"84","1":"29","wf_caso_34_id":"29","2":"36","wf_tarea_id":"36","3":null,"core_usuario_id":null,"4":"2015-06-30 16:58:03","fec_asig":"2015-06-30 16:58:03","5":"51","core_usuario_id_resol":"51","6":"2015-06-30 16:59:59","fec_resol":"2015-06-30 16:59:59","7":"36","wf_tarea_id_sig":"36","8":null,"usr_asig":null,"9":"Ruano Marcela: ciudadano","usr_resol":"Ruano Marcela: ciudadano"}
{"0":"85","id":"85","1":"29","wf_caso_34_id":"29","2":"72","wf_tarea_id":"72","3":null,"core_usuario_id":null,"4":"2015-06-30 16:59:59","fec_asig":"2015-06-30 16:59:59","5":"11","core_usuario_id_resol":"11","6":"2015-07-10 15:39:45","fec_resol":"2015-07-10 15:39:45","7":"72","wf_tarea_id_sig":"72","8":null,"usr_asig":null,"9":"siti soluciones German: ciudadano, gerente","usr_resol":"siti soluciones German: ciudadano, gerente"}
{"0":"86","id":"86","1":"29","wf_caso_34_id":"29","2":"37","wf_tarea_id":"37","3":"11","core_usuario_id":"11","4":"2015-07-10 15:39:45","fec_asig":"2015-07-10 15:39:45","5":null,"core_usuario_id_resol":null,"6":null,"fec_resol":null,"7":"37","wf_tarea_id_sig":"37","8":"siti soluciones German: ciudadano, gerente","usr_asig":"siti soluciones German: ciudadano, gerente","9":null,"usr_resol":null}
2015-07 10 15:39:45
cargar datos del sujeto(,,s,34,29)
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=29 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 10 15:39:45
tabla dat adic
select tabla from core_sujetoverificaciontipo where id=1
2015-07 10 15:39:45
tabla :persona
SELECT * FROM persona where id=101
fin 2015-07-10 15:39:45
/******************************************************************************************************/