2015-07 10 15:35:48
Nuevo(3,1)
Caso :98
2015-07 10 15:35:49
cargar datos del sujeto(,,s,85,98)
select s.*, m.nombre as nom_muni, c.nom_cat,fec_caso
from wf_caso_85 w
inner join core_sujetoverificacion s on w.id=98 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:35:49
tabla dat adic
select tabla from core_sujetoverificaciontipo where id=1
2015-07 10 15:35:49
tabla :persona
SELECT * FROM persona where id=3
CasoSeguimiento :439
EjecutarTarea_89() Ingreso de datos id_comp1223
11
ValidarUsuario(89):1
EjecutarPaso_189: form:20 , caso=98 id_comp 1223
Mostrar form
fin 2015-07-10 15:35:49
/******************************************************************************************************/
2015-07-10 15:35:50TraerCaso(98,85,)
CargarCaso :98
2015-07 10 15:35:50
CargarDatos: Caso :98
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_85_seguimiento_id,wf_paso_id from wf_caso_85_pasos a1 group by wf_caso_85_seguimiento_id,wf_paso_id order by id
)a
inner join wf_caso_85_pasos p using(id,wf_caso_85_seguimiento_id)
inner join ( select max(id) as wf_caso_85_seguimiento_id,wf_caso_85_id,wf_tarea_id from wf_caso_85_seguimiento where wf_caso_85_id =? group by wf_caso_85_id,wf_tarea_id order by wf_caso_85_id,wf_caso_85_seguimiento_id ) b using(wf_caso_85_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_85_seguimiento a
inner join (
select max(b0.id) as id,b0.wf_caso_85_id,b0.wf_tarea_id from wf_caso_85_seguimiento b0 where b0.wf_caso_85_id =? group by b0.wf_caso_85_id,b0.wf_tarea_id order by wf_caso_85_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":"439","id":"439","1":"98","wf_caso_85_id":"98","2":"89","wf_tarea_id":"89","3":null,"core_usuario_id":null,"4":"2015-07-10 15:35:48","fec_asig":"2015-07-10 15:35:48","5":null,"core_usuario_id_resol":null,"6":null,"fec_resol":null,"7":"89","wf_tarea_id_sig":"89","8":null,"usr_asig":null,"9":null,"usr_resol":null}
2015-07 10 15:35:50
cargar datos del sujeto(,,s,85,98)
select s.*, m.nombre as nom_muni, c.nom_cat,fec_caso
from wf_caso_85 w
inner join core_sujetoverificacion s on w.id=98 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:35:50
tabla dat adic
select tabla from core_sujetoverificaciontipo where id=1
2015-07 10 15:35:50
tabla :persona
SELECT * FROM persona where id=3
fin 2015-07-10 15:35:50
/******************************************************************************************************/
2015-07-10 15:36:45TraerCaso(98,85,)
CargarCaso :98
2015-07 10 15:36:45
CargarDatos: Caso :98
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_85_seguimiento_id,wf_paso_id from wf_caso_85_pasos a1 group by wf_caso_85_seguimiento_id,wf_paso_id order by id
)a
inner join wf_caso_85_pasos p using(id,wf_caso_85_seguimiento_id)
inner join ( select max(id) as wf_caso_85_seguimiento_id,wf_caso_85_id,wf_tarea_id from wf_caso_85_seguimiento where wf_caso_85_id =? group by wf_caso_85_id,wf_tarea_id order by wf_caso_85_id,wf_caso_85_seguimiento_id ) b using(wf_caso_85_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_85_seguimiento a
inner join (
select max(b0.id) as id,b0.wf_caso_85_id,b0.wf_tarea_id from wf_caso_85_seguimiento b0 where b0.wf_caso_85_id =? group by b0.wf_caso_85_id,b0.wf_tarea_id order by wf_caso_85_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":"439","id":"439","1":"98","wf_caso_85_id":"98","2":"89","wf_tarea_id":"89","3":null,"core_usuario_id":null,"4":"2015-07-10 15:35:48","fec_asig":"2015-07-10 15:35:48","5":null,"core_usuario_id_resol":null,"6":null,"fec_resol":null,"7":"89","wf_tarea_id_sig":"89","8":null,"usr_asig":null,"9":null,"usr_resol":null}
2015-07 10 15:36:45
cargar datos del sujeto(,,s,85,98)
select s.*, m.nombre as nom_muni, c.nom_cat,fec_caso
from wf_caso_85 w
inner join core_sujetoverificacion s on w.id=98 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:36:45
tabla dat adic
select tabla from core_sujetoverificaciontipo where id=1
2015-07 10 15:36:45
tabla :persona
SELECT * FROM persona where id=3
2015-07 10 15:36:45
Continuar(s,89,189,)
EjecutarTarea_89() Ingreso de datos id_comp1223
11
ValidarUsuario(89):1
EjecutarPaso_189: form:20 , caso=98 id_comp 1223
Paso::Guardar(Caso:98)
Datos a guardar:
Array
(
[wf_proceso_id] => 85
[wf_paso_id] => 189
[wf_tarea_id] => 89
[wf_caso_id] => 98
[id] => 1223
[accion] => nextPaso
[reg] => s
[rta] => n
[cod_formulario2] => 20
[id_periodo] => 2015
[obs_ingreso] =>
[cod_bloque] => 21
[oid] =>
[oid_maestro] =>
[326] => 2015-07-10
[327] => 8
)
OID: 79
rta: 1 dato:79 tabla:sce.t20
CasoPaso:377
CargarDatos_189(79)
se carga 85_89_189_20_21_3278
se carga 85_89_189_20_21_3262015-07-10
SiguientePasoDe189: Funcion para ejecutar el siguiente paso
Condicion Tarea : 8 ==1
Condicion Tarea : 8 ==2
Condicion Tarea : 8 ==3
Condicion Tarea : 8 ==4
Condicion Tarea : 8 ==5
Condicion Tarea : 8 ==6
Condicion Tarea : 8 ==7
Condicion Tarea : 8 ==8
TerminarTarea(89,95)
Ultimo seg :439
Ultimo seg :440
EjecutarTarea_95() excep_impuesto_3 id_comp1223
11 11
ValidarUsuario(95):1
EjecutarPaso_209: ladj:101 , caso=98 id_comp 1223
Mostrar ladj
Retorno :
Array
(
[ret] => inicioComponente_WF_ladj({"tarea_id":95,"paso_id":209,"id":"1223","proceso_id":85,"caso_id":"98","sujeto_id":"3","ladj":101});
[suc] => 1
)
fin 2015-07-10 15:36:45
/******************************************************************************************************/
2015-07-10 15:37:03TraerCaso(98,85,)
CargarCaso :98
2015-07 10 15:37:03
CargarDatos: Caso :98
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_85_seguimiento_id,wf_paso_id from wf_caso_85_pasos a1 group by wf_caso_85_seguimiento_id,wf_paso_id order by id
)a
inner join wf_caso_85_pasos p using(id,wf_caso_85_seguimiento_id)
inner join ( select max(id) as wf_caso_85_seguimiento_id,wf_caso_85_id,wf_tarea_id from wf_caso_85_seguimiento where wf_caso_85_id =? group by wf_caso_85_id,wf_tarea_id order by wf_caso_85_id,wf_caso_85_seguimiento_id ) b using(wf_caso_85_seguimiento_id)
left join usuarios u using(core_usuario_id)
{"0":"377","id":"377","1":"189","wf_paso_id":"189","2":"439","wf_caso_85_seguimiento_id":"439","3":"11","core_usuario_id":"11","4":"2015-07-10 15:36:45","fecha_ejec":"2015-07-10 15:36:45","5":"79","dato":"79","6":"sce.t20","tabla":"sce.t20","7":"89","tarea_id":"89","8":"siti soluciones German: ciudadano, gerente","usr_ejec":"siti soluciones German: ciudadano, gerente"}
CargarDatos_189(79)
se carga 85_89_189_20_21_3278
se carga 85_89_189_20_21_3262015-07-10
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_85_seguimiento a
inner join (
select max(b0.id) as id,b0.wf_caso_85_id,b0.wf_tarea_id from wf_caso_85_seguimiento b0 where b0.wf_caso_85_id =? group by b0.wf_caso_85_id,b0.wf_tarea_id order by wf_caso_85_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":"439","id":"439","1":"98","wf_caso_85_id":"98","2":"89","wf_tarea_id":"89","3":null,"core_usuario_id":null,"4":"2015-07-10 15:35:48","fec_asig":"2015-07-10 15:35:48","5":"11","core_usuario_id_resol":"11","6":"2015-07-10 15:36:45","fec_resol":"2015-07-10 15:36:45","7":"89","wf_tarea_id_sig":"89","8":null,"usr_asig":null,"9":"siti soluciones German: ciudadano, gerente","usr_resol":"siti soluciones German: ciudadano, gerente"}
{"0":"440","id":"440","1":"98","wf_caso_85_id":"98","2":"95","wf_tarea_id":"95","3":"11","core_usuario_id":"11","4":"2015-07-10 15:36:45","fec_asig":"2015-07-10 15:36:45","5":null,"core_usuario_id_resol":null,"6":null,"fec_resol":null,"7":"95","wf_tarea_id_sig":"95","8":"siti soluciones German: ciudadano, gerente","usr_asig":"siti soluciones German: ciudadano, gerente","9":null,"usr_resol":null}
2015-07 10 15:37:03
cargar datos del sujeto(,,s,85,98)
select s.*, m.nombre as nom_muni, c.nom_cat,fec_caso
from wf_caso_85 w
inner join core_sujetoverificacion s on w.id=98 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:37:03
tabla dat adic
select tabla from core_sujetoverificaciontipo where id=1
2015-07 10 15:37:03
tabla :persona
SELECT * FROM persona where id=3
2015-07 10 15:37:03
Continuar(s,95,209,)
EjecutarTarea_95() excep_impuesto_3 id_comp1223
11 11
ValidarUsuario(95):1
EjecutarPaso_209: ladj:101 , caso=98 id_comp 1223
Paso::Guardar(Caso:98)
rta: 1 dato:6740 tabla:wf_documentoentradaadj_caso
CasoPaso:378
CargarDatos_209(6740)
SiguientePasoDe209: Funcion para ejecutar el siguiente paso
Condicion Tarea : true
TerminarTarea(95,127)
Ultimo seg :440
Ultimo seg :441
EjecutarTarea_127() Notificación registro id_comp1223
11 11
ValidarUsuario(127):1
EjecutarPaso_234: corr:64 , caso=98 id_comp 1223
Mostrar corr
ob_start();
$ciud = mb_strtoupper( "{ WFSV_2 } { WFSV_3 }",'utf-8');
?>
<p>
Apreciado(a)<br>
<strong><?php echo htmlentities($ciud) ?></strong>
<p>
<p>El presente mensaje es una notificación para el caso No <strong><?php echo $id_caso; ?></strong> </p>
<?php $html=ob_get_clean();
TWFSV_3:siti soluciones
TWFSV_2:German
Su solitud de <b>Exenciones de impuestos predial</b> ha sido registrada exitosamente y ya se encuentra en trámite.
{ WFSV_1 }
TWFSV_1:desarrollo4@siticol.com
Registro exitoso en exenciones de impuestos predial
Retorno :
Array
(
[ret] => inicioComponente_WF_Correo({"id":"1223","caso_id":"98","proceso_id":85,"tit":"Notificación registro","tarea_id":127,"paso_id":234,"desc":"<p>\nApreciado(a)<br>\n<strong>GERMAN SITI SOLUCIONES<\/strong>\n<p>\n<p>El presente mensaje es una notificación para el caso No <strong>98<\/strong> <\/p>\n<strong>Su solitud de <b>Exenciones de impuestos predial<\/b> ha sido registrada exitosamente y ya se encuentra en tr\u00e1mite. <\/strong> ","url":"<a href=\"#\" onclick=\" llamadaAJAX({\r\n\t\t\t\t\t\t\t\t\turl:'http:\/\/192.168.10.116\/sisad\/build\/view\/mail\/envio\/envio_l.php',\r\n\t\t\t\t\t\t\t\t\tmostrarMsg:true,\r\n\t\t\t\t\t\t\t\t\tparams:{accion:'envio2',destino:'desarrollo4@siticol.com',asunto:'Registro exitoso en exenciones de impuestos predial'},\r\n\t\t\t\t\t\t\t\t\tsuccess:function(result){\r\n\t\t\t\t\t\t\t\t\t\t\t\t\tif(result.success) \r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\tcrearMsg(action.result.message,'Informacion');\r\n\t\t\t\t\t\t\t\t\t\t\t\t\telse{\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\tcrearMsg(action.result.message,'Informacion');\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t}\r\n\t\t\t\t\t\t\t\t\t\t\t\t},\r\n\t\t\t\t\t\t\t\t});\" >De click aqui para volver a enviar el correo<\/a><\/div>"});
[suc] => 1
)
fin 2015-07-10 15:37:04
/******************************************************************************************************/
2015-07-10 15:37:05TraerCaso(98,85,)
CargarCaso :98
2015-07 10 15:37:05
CargarDatos: Caso :98
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_85_seguimiento_id,wf_paso_id from wf_caso_85_pasos a1 group by wf_caso_85_seguimiento_id,wf_paso_id order by id
)a
inner join wf_caso_85_pasos p using(id,wf_caso_85_seguimiento_id)
inner join ( select max(id) as wf_caso_85_seguimiento_id,wf_caso_85_id,wf_tarea_id from wf_caso_85_seguimiento where wf_caso_85_id =? group by wf_caso_85_id,wf_tarea_id order by wf_caso_85_id,wf_caso_85_seguimiento_id ) b using(wf_caso_85_seguimiento_id)
left join usuarios u using(core_usuario_id)
{"0":"377","id":"377","1":"189","wf_paso_id":"189","2":"439","wf_caso_85_seguimiento_id":"439","3":"11","core_usuario_id":"11","4":"2015-07-10 15:36:45","fecha_ejec":"2015-07-10 15:36:45","5":"79","dato":"79","6":"sce.t20","tabla":"sce.t20","7":"89","tarea_id":"89","8":"siti soluciones German: ciudadano, gerente","usr_ejec":"siti soluciones German: ciudadano, gerente"}
CargarDatos_189(79)
se carga 85_89_189_20_21_3278
se carga 85_89_189_20_21_3262015-07-10
{"0":"378","id":"378","1":"209","wf_paso_id":"209","2":"440","wf_caso_85_seguimiento_id":"440","3":"11","core_usuario_id":"11","4":"2015-07-10 15:37:04","fecha_ejec":"2015-07-10 15:37:04","5":"6740","dato":"6740","6":"wf_documentoentradaadj_caso","tabla":"wf_documentoentradaadj_caso","7":"95","tarea_id":"95","8":"siti soluciones German: ciudadano, gerente","usr_ejec":"siti soluciones German: ciudadano, gerente"}
CargarDatos_209(6740)
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_85_seguimiento a
inner join (
select max(b0.id) as id,b0.wf_caso_85_id,b0.wf_tarea_id from wf_caso_85_seguimiento b0 where b0.wf_caso_85_id =? group by b0.wf_caso_85_id,b0.wf_tarea_id order by wf_caso_85_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":"439","id":"439","1":"98","wf_caso_85_id":"98","2":"89","wf_tarea_id":"89","3":null,"core_usuario_id":null,"4":"2015-07-10 15:35:48","fec_asig":"2015-07-10 15:35:48","5":"11","core_usuario_id_resol":"11","6":"2015-07-10 15:36:45","fec_resol":"2015-07-10 15:36:45","7":"89","wf_tarea_id_sig":"89","8":null,"usr_asig":null,"9":"siti soluciones German: ciudadano, gerente","usr_resol":"siti soluciones German: ciudadano, gerente"}
{"0":"440","id":"440","1":"98","wf_caso_85_id":"98","2":"95","wf_tarea_id":"95","3":"11","core_usuario_id":"11","4":"2015-07-10 15:36:45","fec_asig":"2015-07-10 15:36:45","5":"11","core_usuario_id_resol":"11","6":"2015-07-10 15:37:04","fec_resol":"2015-07-10 15:37:04","7":"95","wf_tarea_id_sig":"95","8":"siti soluciones German: ciudadano, gerente","usr_asig":"siti soluciones German: ciudadano, gerente","9":"siti soluciones German: ciudadano, gerente","usr_resol":"siti soluciones German: ciudadano, gerente"}
{"0":"441","id":"441","1":"98","wf_caso_85_id":"98","2":"127","wf_tarea_id":"127","3":"11","core_usuario_id":"11","4":"2015-07-10 15:37:04","fec_asig":"2015-07-10 15:37:04","5":null,"core_usuario_id_resol":null,"6":null,"fec_resol":null,"7":"127","wf_tarea_id_sig":"127","8":"siti soluciones German: ciudadano, gerente","usr_asig":"siti soluciones German: ciudadano, gerente","9":null,"usr_resol":null}
2015-07 10 15:37:05
cargar datos del sujeto(,,s,85,98)
select s.*, m.nombre as nom_muni, c.nom_cat,fec_caso
from wf_caso_85 w
inner join core_sujetoverificacion s on w.id=98 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:37:05
tabla dat adic
select tabla from core_sujetoverificaciontipo where id=1
2015-07 10 15:37:05
tabla :persona
SELECT * FROM persona where id=3
2015-07 10 15:37:05
Continuar(s,127,234,)
EjecutarTarea_127() Notificación registro id_comp1223
11 11
ValidarUsuario(127):1
EjecutarPaso_234: corr:64 , caso=98 id_comp 1223
Paso::Guardar(Caso:98)
rta: 1 dato: tabla:
CasoPaso:379
CargarDatos_234()
SiguientePasoDe234: Funcion para ejecutar el siguiente paso
Condicion Tarea : 8 ==1
Condicion Tarea : 8 ==2
Condicion Tarea : 8 ==3
Condicion Tarea : 8 ==4
Condicion Tarea : 8 ==5
Condicion Tarea : 8 ==6
Condicion Tarea : 8 ==7
Condicion Tarea : 8 ==8
TerminarTarea(127,113)
Ultimo seg :441
Ultimo seg :442
EjecutarTarea_113() ver_excep_impuesto_3 id_comp1223
11 11
ValidarUsuario(113):1
EjecutarPaso_226: vadj:101 , caso=98 id_comp 1223
Mostrar vadj
Retorno :
Array
(
[ret] => inicioComponente_WF_vadj({"tarea_id":113,"paso_id":226,"id":"1223","proceso_id":85,"caso_id":"98","sujeto_id":"3","vadj":101});
[suc] => 1
)
fin 2015-07-10 15:37:05
/******************************************************************************************************/
2015-07-10 15:37:10TraerCaso(98,85,)
CargarCaso :98
2015-07 10 15:37:10
CargarDatos: Caso :98
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_85_seguimiento_id,wf_paso_id from wf_caso_85_pasos a1 group by wf_caso_85_seguimiento_id,wf_paso_id order by id
)a
inner join wf_caso_85_pasos p using(id,wf_caso_85_seguimiento_id)
inner join ( select max(id) as wf_caso_85_seguimiento_id,wf_caso_85_id,wf_tarea_id from wf_caso_85_seguimiento where wf_caso_85_id =? group by wf_caso_85_id,wf_tarea_id order by wf_caso_85_id,wf_caso_85_seguimiento_id ) b using(wf_caso_85_seguimiento_id)
left join usuarios u using(core_usuario_id)
{"0":"377","id":"377","1":"189","wf_paso_id":"189","2":"439","wf_caso_85_seguimiento_id":"439","3":"11","core_usuario_id":"11","4":"2015-07-10 15:36:45","fecha_ejec":"2015-07-10 15:36:45","5":"79","dato":"79","6":"sce.t20","tabla":"sce.t20","7":"89","tarea_id":"89","8":"siti soluciones German: ciudadano, gerente","usr_ejec":"siti soluciones German: ciudadano, gerente"}
CargarDatos_189(79)
se carga 85_89_189_20_21_3278
se carga 85_89_189_20_21_3262015-07-10
{"0":"378","id":"378","1":"209","wf_paso_id":"209","2":"440","wf_caso_85_seguimiento_id":"440","3":"11","core_usuario_id":"11","4":"2015-07-10 15:37:04","fecha_ejec":"2015-07-10 15:37:04","5":"6740","dato":"6740","6":"wf_documentoentradaadj_caso","tabla":"wf_documentoentradaadj_caso","7":"95","tarea_id":"95","8":"siti soluciones German: ciudadano, gerente","usr_ejec":"siti soluciones German: ciudadano, gerente"}
CargarDatos_209(6740)
{"0":"379","id":"379","1":"234","wf_paso_id":"234","2":"441","wf_caso_85_seguimiento_id":"441","3":"11","core_usuario_id":"11","4":"2015-07-10 15:37:05","fecha_ejec":"2015-07-10 15:37:05","5":null,"dato":null,"6":null,"tabla":null,"7":"127","tarea_id":"127","8":"siti soluciones German: ciudadano, gerente","usr_ejec":"siti soluciones German: ciudadano, gerente"}
CargarDatos_234()
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_85_seguimiento a
inner join (
select max(b0.id) as id,b0.wf_caso_85_id,b0.wf_tarea_id from wf_caso_85_seguimiento b0 where b0.wf_caso_85_id =? group by b0.wf_caso_85_id,b0.wf_tarea_id order by wf_caso_85_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":"439","id":"439","1":"98","wf_caso_85_id":"98","2":"89","wf_tarea_id":"89","3":null,"core_usuario_id":null,"4":"2015-07-10 15:35:48","fec_asig":"2015-07-10 15:35:48","5":"11","core_usuario_id_resol":"11","6":"2015-07-10 15:36:45","fec_resol":"2015-07-10 15:36:45","7":"89","wf_tarea_id_sig":"89","8":null,"usr_asig":null,"9":"siti soluciones German: ciudadano, gerente","usr_resol":"siti soluciones German: ciudadano, gerente"}
{"0":"440","id":"440","1":"98","wf_caso_85_id":"98","2":"95","wf_tarea_id":"95","3":"11","core_usuario_id":"11","4":"2015-07-10 15:36:45","fec_asig":"2015-07-10 15:36:45","5":"11","core_usuario_id_resol":"11","6":"2015-07-10 15:37:04","fec_resol":"2015-07-10 15:37:04","7":"95","wf_tarea_id_sig":"95","8":"siti soluciones German: ciudadano, gerente","usr_asig":"siti soluciones German: ciudadano, gerente","9":"siti soluciones German: ciudadano, gerente","usr_resol":"siti soluciones German: ciudadano, gerente"}
{"0":"441","id":"441","1":"98","wf_caso_85_id":"98","2":"127","wf_tarea_id":"127","3":"11","core_usuario_id":"11","4":"2015-07-10 15:37:04","fec_asig":"2015-07-10 15:37:04","5":"11","core_usuario_id_resol":"11","6":"2015-07-10 15:37:05","fec_resol":"2015-07-10 15:37:05","7":"127","wf_tarea_id_sig":"127","8":"siti soluciones German: ciudadano, gerente","usr_asig":"siti soluciones German: ciudadano, gerente","9":"siti soluciones German: ciudadano, gerente","usr_resol":"siti soluciones German: ciudadano, gerente"}
{"0":"442","id":"442","1":"98","wf_caso_85_id":"98","2":"113","wf_tarea_id":"113","3":"11","core_usuario_id":"11","4":"2015-07-10 15:37:05","fec_asig":"2015-07-10 15:37:05","5":null,"core_usuario_id_resol":null,"6":null,"fec_resol":null,"7":"113","wf_tarea_id_sig":"113","8":"siti soluciones German: ciudadano, gerente","usr_asig":"siti soluciones German: ciudadano, gerente","9":null,"usr_resol":null}
2015-07 10 15:37:10
cargar datos del sujeto(,,s,85,98)
select s.*, m.nombre as nom_muni, c.nom_cat,fec_caso
from wf_caso_85 w
inner join core_sujetoverificacion s on w.id=98 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:37:10
tabla dat adic
select tabla from core_sujetoverificaciontipo where id=1
2015-07 10 15:37:10
tabla :persona
SELECT * FROM persona where id=3
2015-07 10 15:37:10
Continuar(s,113,226,)
EjecutarTarea_113() ver_excep_impuesto_3 id_comp1223
11 11
ValidarUsuario(113):1
EjecutarPaso_226: vadj:101 , caso=98 id_comp 1223
Paso::Guardar(Caso:98)
rta: 1 dato:2633 tabla:wf_documentoentradaadj_caso
CasoPaso:380
CargarDatos_226(2633)
SiguientePasoDe226: Funcion para ejecutar el siguiente paso
Condicion Tarea : Si == "Si"
TerminarTarea(113,128)
Ultimo seg :442
Ultimo seg :443
EjecutarTarea_128() Notificación revision-radicación id_comp1223
11 11
ValidarUsuario(128):1
EjecutarPaso_235: corr:71 , caso=98 id_comp 1223
Mostrar corr
ob_start();
$ciud = mb_strtoupper( "{ WFSV_2 } { WFSV_3 }",'utf-8');
?>
<p>
Apreciado(a)<br>
<strong><?php echo htmlentities($ciud) ?></strong>
<p>
<p>El presente mensaje es una notificación para el caso No <strong><?php echo $id_caso; ?></strong> </p>
<?php $html=ob_get_clean();
TWFSV_3:siti soluciones
TWFSV_2:German
<br>Su solicitud de <b>Exenciones de impuestos predial</b> fue revisada y radicada.
{ WFSV_1 }
TWFSV_1:desarrollo4@siticol.com
Revisión y radicación en exenciones de impuestos predial
Retorno :
Array
(
[ret] => inicioComponente_WF_Correo({"id":"1223","caso_id":"98","proceso_id":85,"tit":"Notificación revision-radicación","tarea_id":128,"paso_id":235,"desc":"<p>\nApreciado(a)<br>\n<strong>GERMAN SITI SOLUCIONES<\/strong>\n<p>\n<p>El presente mensaje es una notificación para el caso No <strong>98<\/strong> <\/p>\n<strong><br>Su solicitud de <b>Exenciones de impuestos predial<\/b> fue revisada y radicada.<\/strong> ","url":"<a href=\"#\" onclick=\" llamadaAJAX({\r\n\t\t\t\t\t\t\t\t\turl:'http:\/\/192.168.10.116\/sisad\/build\/view\/mail\/envio\/envio_l.php',\r\n\t\t\t\t\t\t\t\t\tmostrarMsg:true,\r\n\t\t\t\t\t\t\t\t\tparams:{accion:'envio2',destino:'desarrollo4@siticol.com ',asunto:'Revisi\u00f3n y radicaci\u00f3n en exenciones de impuestos predial'},\r\n\t\t\t\t\t\t\t\t\tsuccess:function(result){\r\n\t\t\t\t\t\t\t\t\t\t\t\t\tif(result.success) \r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\tcrearMsg(action.result.message,'Informacion');\r\n\t\t\t\t\t\t\t\t\t\t\t\t\telse{\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\tcrearMsg(action.result.message,'Informacion');\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t}\r\n\t\t\t\t\t\t\t\t\t\t\t\t},\r\n\t\t\t\t\t\t\t\t});\" >De click aqui para volver a enviar el correo<\/a><\/div>"});
[suc] => 1
)
fin 2015-07-10 15:37:10
/******************************************************************************************************/
2015-07-10 15:37:16TraerCaso(98,85,)
CargarCaso :98
2015-07 10 15:37:16
CargarDatos: Caso :98
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_85_seguimiento_id,wf_paso_id from wf_caso_85_pasos a1 group by wf_caso_85_seguimiento_id,wf_paso_id order by id
)a
inner join wf_caso_85_pasos p using(id,wf_caso_85_seguimiento_id)
inner join ( select max(id) as wf_caso_85_seguimiento_id,wf_caso_85_id,wf_tarea_id from wf_caso_85_seguimiento where wf_caso_85_id =? group by wf_caso_85_id,wf_tarea_id order by wf_caso_85_id,wf_caso_85_seguimiento_id ) b using(wf_caso_85_seguimiento_id)
left join usuarios u using(core_usuario_id)
{"0":"377","id":"377","1":"189","wf_paso_id":"189","2":"439","wf_caso_85_seguimiento_id":"439","3":"11","core_usuario_id":"11","4":"2015-07-10 15:36:45","fecha_ejec":"2015-07-10 15:36:45","5":"79","dato":"79","6":"sce.t20","tabla":"sce.t20","7":"89","tarea_id":"89","8":"siti soluciones German: ciudadano, gerente","usr_ejec":"siti soluciones German: ciudadano, gerente"}
CargarDatos_189(79)
se carga 85_89_189_20_21_3278
se carga 85_89_189_20_21_3262015-07-10
{"0":"378","id":"378","1":"209","wf_paso_id":"209","2":"440","wf_caso_85_seguimiento_id":"440","3":"11","core_usuario_id":"11","4":"2015-07-10 15:37:04","fecha_ejec":"2015-07-10 15:37:04","5":"6740","dato":"6740","6":"wf_documentoentradaadj_caso","tabla":"wf_documentoentradaadj_caso","7":"95","tarea_id":"95","8":"siti soluciones German: ciudadano, gerente","usr_ejec":"siti soluciones German: ciudadano, gerente"}
CargarDatos_209(6740)
{"0":"379","id":"379","1":"234","wf_paso_id":"234","2":"441","wf_caso_85_seguimiento_id":"441","3":"11","core_usuario_id":"11","4":"2015-07-10 15:37:05","fecha_ejec":"2015-07-10 15:37:05","5":null,"dato":null,"6":null,"tabla":null,"7":"127","tarea_id":"127","8":"siti soluciones German: ciudadano, gerente","usr_ejec":"siti soluciones German: ciudadano, gerente"}
CargarDatos_234()
{"0":"380","id":"380","1":"226","wf_paso_id":"226","2":"442","wf_caso_85_seguimiento_id":"442","3":"11","core_usuario_id":"11","4":"2015-07-10 15:37:10","fecha_ejec":"2015-07-10 15:37:10","5":"2633","dato":"2633","6":"wf_documentoentradaadj_caso","tabla":"wf_documentoentradaadj_caso","7":"113","tarea_id":"113","8":"siti soluciones German: ciudadano, gerente","usr_ejec":"siti soluciones German: ciudadano, gerente"}
CargarDatos_226(2633)
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_85_seguimiento a
inner join (
select max(b0.id) as id,b0.wf_caso_85_id,b0.wf_tarea_id from wf_caso_85_seguimiento b0 where b0.wf_caso_85_id =? group by b0.wf_caso_85_id,b0.wf_tarea_id order by wf_caso_85_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":"439","id":"439","1":"98","wf_caso_85_id":"98","2":"89","wf_tarea_id":"89","3":null,"core_usuario_id":null,"4":"2015-07-10 15:35:48","fec_asig":"2015-07-10 15:35:48","5":"11","core_usuario_id_resol":"11","6":"2015-07-10 15:36:45","fec_resol":"2015-07-10 15:36:45","7":"89","wf_tarea_id_sig":"89","8":null,"usr_asig":null,"9":"siti soluciones German: ciudadano, gerente","usr_resol":"siti soluciones German: ciudadano, gerente"}
{"0":"440","id":"440","1":"98","wf_caso_85_id":"98","2":"95","wf_tarea_id":"95","3":"11","core_usuario_id":"11","4":"2015-07-10 15:36:45","fec_asig":"2015-07-10 15:36:45","5":"11","core_usuario_id_resol":"11","6":"2015-07-10 15:37:04","fec_resol":"2015-07-10 15:37:04","7":"95","wf_tarea_id_sig":"95","8":"siti soluciones German: ciudadano, gerente","usr_asig":"siti soluciones German: ciudadano, gerente","9":"siti soluciones German: ciudadano, gerente","usr_resol":"siti soluciones German: ciudadano, gerente"}
{"0":"441","id":"441","1":"98","wf_caso_85_id":"98","2":"127","wf_tarea_id":"127","3":"11","core_usuario_id":"11","4":"2015-07-10 15:37:04","fec_asig":"2015-07-10 15:37:04","5":"11","core_usuario_id_resol":"11","6":"2015-07-10 15:37:05","fec_resol":"2015-07-10 15:37:05","7":"127","wf_tarea_id_sig":"127","8":"siti soluciones German: ciudadano, gerente","usr_asig":"siti soluciones German: ciudadano, gerente","9":"siti soluciones German: ciudadano, gerente","usr_resol":"siti soluciones German: ciudadano, gerente"}
{"0":"442","id":"442","1":"98","wf_caso_85_id":"98","2":"113","wf_tarea_id":"113","3":"11","core_usuario_id":"11","4":"2015-07-10 15:37:05","fec_asig":"2015-07-10 15:37:05","5":"11","core_usuario_id_resol":"11","6":"2015-07-10 15:37:10","fec_resol":"2015-07-10 15:37:10","7":"113","wf_tarea_id_sig":"113","8":"siti soluciones German: ciudadano, gerente","usr_asig":"siti soluciones German: ciudadano, gerente","9":"siti soluciones German: ciudadano, gerente","usr_resol":"siti soluciones German: ciudadano, gerente"}
{"0":"443","id":"443","1":"98","wf_caso_85_id":"98","2":"128","wf_tarea_id":"128","3":"11","core_usuario_id":"11","4":"2015-07-10 15:37:10","fec_asig":"2015-07-10 15:37:10","5":null,"core_usuario_id_resol":null,"6":null,"fec_resol":null,"7":"128","wf_tarea_id_sig":"128","8":"siti soluciones German: ciudadano, gerente","usr_asig":"siti soluciones German: ciudadano, gerente","9":null,"usr_resol":null}
2015-07 10 15:37:16
cargar datos del sujeto(,,s,85,98)
select s.*, m.nombre as nom_muni, c.nom_cat,fec_caso
from wf_caso_85 w
inner join core_sujetoverificacion s on w.id=98 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:37:16
tabla dat adic
select tabla from core_sujetoverificaciontipo where id=1
2015-07 10 15:37:16
tabla :persona
SELECT * FROM persona where id=3
2015-07 10 15:37:16
Continuar(s,128,235,)
EjecutarTarea_128() Notificación revision-radicación id_comp1223
11 11
ValidarUsuario(128):1
EjecutarPaso_235: corr:71 , caso=98 id_comp 1223
Paso::Guardar(Caso:98)
rta: 1 dato: tabla:
CasoPaso:381
CargarDatos_235()
SiguientePasoDe235: Funcion para ejecutar el siguiente paso
Condicion Tarea : true
TerminarTarea(128,160)
Ultimo seg :443
Ultimo seg :444
EjecutarTarea_160() Generar acto administrativo id_comp1223
11 11
ValidarUsuario(160):1
EjecutarPaso_275: form:26 , caso=98 id_comp 1223
Mostrar form
Retorno :
Array
(
[ret] => Ext.getCmp('comp_1223').removeAll();Ext.getCmp('comp_1223').add(new Ext.form.FormPanel({ title: 'acto administrativo' ,padding: 10,id:'frm_formulario_85_98',autoScroll:true ,labelAlign:'top',defaults: { anchor: '97%'} ,items: [new Ext.form.Hidden({name:'cod_formulario2',value:'26'}) ,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:'27'}) ,new Ext.form.Hidden({name :'oid',value:''}) ,new Ext.form.Hidden({name :'oid_maestro',value:''}) ,new Ext.form.RadioGroup({columns:2,items:[ new Ext.form.Radio({name:'408',id:'408_1',inputValue:1,boxLabel:'Si'}), new Ext.form.Radio({name:'408',id:'408_2',inputValue:2,boxLabel:'No'}) ],columns:2,allowBlank:false,fieldLabel:'* Generar acto administrativo',id:'408',listeners:{change:function(){var c=Ext.getCmp('408_2').getValue();var obs=Ext.getCmp('409');if(c)obs.setDisabled(false);else obs.setDisabled(true);}}}), new Ext.form.TextArea({id:'409',allowBlank:false, fieldLabel:'* Observaciones',name:'409',disabled:true,listeners:{change:function(){if(/^\s*$/.test(this.getValue())){this.setValue('');}}}}) ] ,prepararGrids:function(){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);}}}},tbar:[{text:'Guardar',iconCls: 'icon-disk',handler: function(){ var form = Ext.getCmp('frm_formulario_85_98'); 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:'85',wf_paso_id:'275',wf_tarea_id:'160',wf_caso_id:'98',id:'1223',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_85_98').getForm().loadRecord(new Ext.data.Record({"cod_formulario":26,"oid_maestro":null,"cod_bloque":27})); llamadaAJAX({url:'http://192.168.10.116/sisad/build/view/workflow/casos/casos_datosForm.php',mostrarMsg:false,params:{accion:'verifica',wf_paso_id:'275',cod_formulario:'26',cod_bloque:'27',wf_caso_id:'{"pro":"85","cas":"98"}'}}); }catch(e){alert(e);} } } }) );Ext.getCmp('comp_1223').doLayout();
[suc] => 1
)
fin 2015-07-10 15:37:16
/******************************************************************************************************/
2015-07-10 15:37:17TraerCaso(98,85,)
CargarCaso :98
2015-07 10 15:37:17
CargarDatos: Caso :98
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_85_seguimiento_id,wf_paso_id from wf_caso_85_pasos a1 group by wf_caso_85_seguimiento_id,wf_paso_id order by id
)a
inner join wf_caso_85_pasos p using(id,wf_caso_85_seguimiento_id)
inner join ( select max(id) as wf_caso_85_seguimiento_id,wf_caso_85_id,wf_tarea_id from wf_caso_85_seguimiento where wf_caso_85_id =? group by wf_caso_85_id,wf_tarea_id order by wf_caso_85_id,wf_caso_85_seguimiento_id ) b using(wf_caso_85_seguimiento_id)
left join usuarios u using(core_usuario_id)
{"0":"377","id":"377","1":"189","wf_paso_id":"189","2":"439","wf_caso_85_seguimiento_id":"439","3":"11","core_usuario_id":"11","4":"2015-07-10 15:36:45","fecha_ejec":"2015-07-10 15:36:45","5":"79","dato":"79","6":"sce.t20","tabla":"sce.t20","7":"89","tarea_id":"89","8":"siti soluciones German: ciudadano, gerente","usr_ejec":"siti soluciones German: ciudadano, gerente"}
CargarDatos_189(79)
se carga 85_89_189_20_21_3278
se carga 85_89_189_20_21_3262015-07-10
{"0":"378","id":"378","1":"209","wf_paso_id":"209","2":"440","wf_caso_85_seguimiento_id":"440","3":"11","core_usuario_id":"11","4":"2015-07-10 15:37:04","fecha_ejec":"2015-07-10 15:37:04","5":"6740","dato":"6740","6":"wf_documentoentradaadj_caso","tabla":"wf_documentoentradaadj_caso","7":"95","tarea_id":"95","8":"siti soluciones German: ciudadano, gerente","usr_ejec":"siti soluciones German: ciudadano, gerente"}
CargarDatos_209(6740)
{"0":"379","id":"379","1":"234","wf_paso_id":"234","2":"441","wf_caso_85_seguimiento_id":"441","3":"11","core_usuario_id":"11","4":"2015-07-10 15:37:05","fecha_ejec":"2015-07-10 15:37:05","5":null,"dato":null,"6":null,"tabla":null,"7":"127","tarea_id":"127","8":"siti soluciones German: ciudadano, gerente","usr_ejec":"siti soluciones German: ciudadano, gerente"}
CargarDatos_234()
{"0":"380","id":"380","1":"226","wf_paso_id":"226","2":"442","wf_caso_85_seguimiento_id":"442","3":"11","core_usuario_id":"11","4":"2015-07-10 15:37:10","fecha_ejec":"2015-07-10 15:37:10","5":"2633","dato":"2633","6":"wf_documentoentradaadj_caso","tabla":"wf_documentoentradaadj_caso","7":"113","tarea_id":"113","8":"siti soluciones German: ciudadano, gerente","usr_ejec":"siti soluciones German: ciudadano, gerente"}
CargarDatos_226(2633)
{"0":"381","id":"381","1":"235","wf_paso_id":"235","2":"443","wf_caso_85_seguimiento_id":"443","3":"11","core_usuario_id":"11","4":"2015-07-10 15:37:16","fecha_ejec":"2015-07-10 15:37:16","5":null,"dato":null,"6":null,"tabla":null,"7":"128","tarea_id":"128","8":"siti soluciones German: ciudadano, gerente","usr_ejec":"siti soluciones German: ciudadano, gerente"}
CargarDatos_235()
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_85_seguimiento a
inner join (
select max(b0.id) as id,b0.wf_caso_85_id,b0.wf_tarea_id from wf_caso_85_seguimiento b0 where b0.wf_caso_85_id =? group by b0.wf_caso_85_id,b0.wf_tarea_id order by wf_caso_85_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":"439","id":"439","1":"98","wf_caso_85_id":"98","2":"89","wf_tarea_id":"89","3":null,"core_usuario_id":null,"4":"2015-07-10 15:35:48","fec_asig":"2015-07-10 15:35:48","5":"11","core_usuario_id_resol":"11","6":"2015-07-10 15:36:45","fec_resol":"2015-07-10 15:36:45","7":"89","wf_tarea_id_sig":"89","8":null,"usr_asig":null,"9":"siti soluciones German: ciudadano, gerente","usr_resol":"siti soluciones German: ciudadano, gerente"}
{"0":"440","id":"440","1":"98","wf_caso_85_id":"98","2":"95","wf_tarea_id":"95","3":"11","core_usuario_id":"11","4":"2015-07-10 15:36:45","fec_asig":"2015-07-10 15:36:45","5":"11","core_usuario_id_resol":"11","6":"2015-07-10 15:37:04","fec_resol":"2015-07-10 15:37:04","7":"95","wf_tarea_id_sig":"95","8":"siti soluciones German: ciudadano, gerente","usr_asig":"siti soluciones German: ciudadano, gerente","9":"siti soluciones German: ciudadano, gerente","usr_resol":"siti soluciones German: ciudadano, gerente"}
{"0":"441","id":"441","1":"98","wf_caso_85_id":"98","2":"127","wf_tarea_id":"127","3":"11","core_usuario_id":"11","4":"2015-07-10 15:37:04","fec_asig":"2015-07-10 15:37:04","5":"11","core_usuario_id_resol":"11","6":"2015-07-10 15:37:05","fec_resol":"2015-07-10 15:37:05","7":"127","wf_tarea_id_sig":"127","8":"siti soluciones German: ciudadano, gerente","usr_asig":"siti soluciones German: ciudadano, gerente","9":"siti soluciones German: ciudadano, gerente","usr_resol":"siti soluciones German: ciudadano, gerente"}
{"0":"442","id":"442","1":"98","wf_caso_85_id":"98","2":"113","wf_tarea_id":"113","3":"11","core_usuario_id":"11","4":"2015-07-10 15:37:05","fec_asig":"2015-07-10 15:37:05","5":"11","core_usuario_id_resol":"11","6":"2015-07-10 15:37:10","fec_resol":"2015-07-10 15:37:10","7":"113","wf_tarea_id_sig":"113","8":"siti soluciones German: ciudadano, gerente","usr_asig":"siti soluciones German: ciudadano, gerente","9":"siti soluciones German: ciudadano, gerente","usr_resol":"siti soluciones German: ciudadano, gerente"}
{"0":"443","id":"443","1":"98","wf_caso_85_id":"98","2":"128","wf_tarea_id":"128","3":"11","core_usuario_id":"11","4":"2015-07-10 15:37:10","fec_asig":"2015-07-10 15:37:10","5":"11","core_usuario_id_resol":"11","6":"2015-07-10 15:37:16","fec_resol":"2015-07-10 15:37:16","7":"128","wf_tarea_id_sig":"128","8":"siti soluciones German: ciudadano, gerente","usr_asig":"siti soluciones German: ciudadano, gerente","9":"siti soluciones German: ciudadano, gerente","usr_resol":"siti soluciones German: ciudadano, gerente"}
{"0":"444","id":"444","1":"98","wf_caso_85_id":"98","2":"160","wf_tarea_id":"160","3":"11","core_usuario_id":"11","4":"2015-07-10 15:37:16","fec_asig":"2015-07-10 15:37:16","5":null,"core_usuario_id_resol":null,"6":null,"fec_resol":null,"7":"160","wf_tarea_id_sig":"160","8":"siti soluciones German: ciudadano, gerente","usr_asig":"siti soluciones German: ciudadano, gerente","9":null,"usr_resol":null}
2015-07 10 15:37:17
cargar datos del sujeto(,,s,85,98)
select s.*, m.nombre as nom_muni, c.nom_cat,fec_caso
from wf_caso_85 w
inner join core_sujetoverificacion s on w.id=98 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:37:17
tabla dat adic
select tabla from core_sujetoverificaciontipo where id=1
2015-07 10 15:37:17
tabla :persona
SELECT * FROM persona where id=3
fin 2015-07-10 15:37:17
/******************************************************************************************************/
2015-07-10 15:37:18TraerCaso(98,85,)
CargarCaso :98
2015-07 10 15:37:19
CargarDatos: Caso :98
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_85_seguimiento_id,wf_paso_id from wf_caso_85_pasos a1 group by wf_caso_85_seguimiento_id,wf_paso_id order by id
)a
inner join wf_caso_85_pasos p using(id,wf_caso_85_seguimiento_id)
inner join ( select max(id) as wf_caso_85_seguimiento_id,wf_caso_85_id,wf_tarea_id from wf_caso_85_seguimiento where wf_caso_85_id =? group by wf_caso_85_id,wf_tarea_id order by wf_caso_85_id,wf_caso_85_seguimiento_id ) b using(wf_caso_85_seguimiento_id)
left join usuarios u using(core_usuario_id)
{"0":"377","id":"377","1":"189","wf_paso_id":"189","2":"439","wf_caso_85_seguimiento_id":"439","3":"11","core_usuario_id":"11","4":"2015-07-10 15:36:45","fecha_ejec":"2015-07-10 15:36:45","5":"79","dato":"79","6":"sce.t20","tabla":"sce.t20","7":"89","tarea_id":"89","8":"siti soluciones German: ciudadano, gerente","usr_ejec":"siti soluciones German: ciudadano, gerente"}
CargarDatos_189(79)
se carga 85_89_189_20_21_3278
se carga 85_89_189_20_21_3262015-07-10
{"0":"378","id":"378","1":"209","wf_paso_id":"209","2":"440","wf_caso_85_seguimiento_id":"440","3":"11","core_usuario_id":"11","4":"2015-07-10 15:37:04","fecha_ejec":"2015-07-10 15:37:04","5":"6740","dato":"6740","6":"wf_documentoentradaadj_caso","tabla":"wf_documentoentradaadj_caso","7":"95","tarea_id":"95","8":"siti soluciones German: ciudadano, gerente","usr_ejec":"siti soluciones German: ciudadano, gerente"}
CargarDatos_209(6740)
{"0":"379","id":"379","1":"234","wf_paso_id":"234","2":"441","wf_caso_85_seguimiento_id":"441","3":"11","core_usuario_id":"11","4":"2015-07-10 15:37:05","fecha_ejec":"2015-07-10 15:37:05","5":null,"dato":null,"6":null,"tabla":null,"7":"127","tarea_id":"127","8":"siti soluciones German: ciudadano, gerente","usr_ejec":"siti soluciones German: ciudadano, gerente"}
CargarDatos_234()
{"0":"380","id":"380","1":"226","wf_paso_id":"226","2":"442","wf_caso_85_seguimiento_id":"442","3":"11","core_usuario_id":"11","4":"2015-07-10 15:37:10","fecha_ejec":"2015-07-10 15:37:10","5":"2633","dato":"2633","6":"wf_documentoentradaadj_caso","tabla":"wf_documentoentradaadj_caso","7":"113","tarea_id":"113","8":"siti soluciones German: ciudadano, gerente","usr_ejec":"siti soluciones German: ciudadano, gerente"}
CargarDatos_226(2633)
{"0":"381","id":"381","1":"235","wf_paso_id":"235","2":"443","wf_caso_85_seguimiento_id":"443","3":"11","core_usuario_id":"11","4":"2015-07-10 15:37:16","fecha_ejec":"2015-07-10 15:37:16","5":null,"dato":null,"6":null,"tabla":null,"7":"128","tarea_id":"128","8":"siti soluciones German: ciudadano, gerente","usr_ejec":"siti soluciones German: ciudadano, gerente"}
CargarDatos_235()
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_85_seguimiento a
inner join (
select max(b0.id) as id,b0.wf_caso_85_id,b0.wf_tarea_id from wf_caso_85_seguimiento b0 where b0.wf_caso_85_id =? group by b0.wf_caso_85_id,b0.wf_tarea_id order by wf_caso_85_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":"439","id":"439","1":"98","wf_caso_85_id":"98","2":"89","wf_tarea_id":"89","3":null,"core_usuario_id":null,"4":"2015-07-10 15:35:48","fec_asig":"2015-07-10 15:35:48","5":"11","core_usuario_id_resol":"11","6":"2015-07-10 15:36:45","fec_resol":"2015-07-10 15:36:45","7":"89","wf_tarea_id_sig":"89","8":null,"usr_asig":null,"9":"siti soluciones German: ciudadano, gerente","usr_resol":"siti soluciones German: ciudadano, gerente"}
{"0":"440","id":"440","1":"98","wf_caso_85_id":"98","2":"95","wf_tarea_id":"95","3":"11","core_usuario_id":"11","4":"2015-07-10 15:36:45","fec_asig":"2015-07-10 15:36:45","5":"11","core_usuario_id_resol":"11","6":"2015-07-10 15:37:04","fec_resol":"2015-07-10 15:37:04","7":"95","wf_tarea_id_sig":"95","8":"siti soluciones German: ciudadano, gerente","usr_asig":"siti soluciones German: ciudadano, gerente","9":"siti soluciones German: ciudadano, gerente","usr_resol":"siti soluciones German: ciudadano, gerente"}
{"0":"441","id":"441","1":"98","wf_caso_85_id":"98","2":"127","wf_tarea_id":"127","3":"11","core_usuario_id":"11","4":"2015-07-10 15:37:04","fec_asig":"2015-07-10 15:37:04","5":"11","core_usuario_id_resol":"11","6":"2015-07-10 15:37:05","fec_resol":"2015-07-10 15:37:05","7":"127","wf_tarea_id_sig":"127","8":"siti soluciones German: ciudadano, gerente","usr_asig":"siti soluciones German: ciudadano, gerente","9":"siti soluciones German: ciudadano, gerente","usr_resol":"siti soluciones German: ciudadano, gerente"}
{"0":"442","id":"442","1":"98","wf_caso_85_id":"98","2":"113","wf_tarea_id":"113","3":"11","core_usuario_id":"11","4":"2015-07-10 15:37:05","fec_asig":"2015-07-10 15:37:05","5":"11","core_usuario_id_resol":"11","6":"2015-07-10 15:37:10","fec_resol":"2015-07-10 15:37:10","7":"113","wf_tarea_id_sig":"113","8":"siti soluciones German: ciudadano, gerente","usr_asig":"siti soluciones German: ciudadano, gerente","9":"siti soluciones German: ciudadano, gerente","usr_resol":"siti soluciones German: ciudadano, gerente"}
{"0":"443","id":"443","1":"98","wf_caso_85_id":"98","2":"128","wf_tarea_id":"128","3":"11","core_usuario_id":"11","4":"2015-07-10 15:37:10","fec_asig":"2015-07-10 15:37:10","5":"11","core_usuario_id_resol":"11","6":"2015-07-10 15:37:16","fec_resol":"2015-07-10 15:37:16","7":"128","wf_tarea_id_sig":"128","8":"siti soluciones German: ciudadano, gerente","usr_asig":"siti soluciones German: ciudadano, gerente","9":"siti soluciones German: ciudadano, gerente","usr_resol":"siti soluciones German: ciudadano, gerente"}
{"0":"444","id":"444","1":"98","wf_caso_85_id":"98","2":"160","wf_tarea_id":"160","3":"11","core_usuario_id":"11","4":"2015-07-10 15:37:16","fec_asig":"2015-07-10 15:37:16","5":null,"core_usuario_id_resol":null,"6":null,"fec_resol":null,"7":"160","wf_tarea_id_sig":"160","8":"siti soluciones German: ciudadano, gerente","usr_asig":"siti soluciones German: ciudadano, gerente","9":null,"usr_resol":null}
2015-07 10 15:37:19
cargar datos del sujeto(,,s,85,98)
select s.*, m.nombre as nom_muni, c.nom_cat,fec_caso
from wf_caso_85 w
inner join core_sujetoverificacion s on w.id=98 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:37:19
tabla dat adic
select tabla from core_sujetoverificaciontipo where id=1
2015-07 10 15:37:19
tabla :persona
SELECT * FROM persona where id=3
2015-07 10 15:37:19
Continuar(s,160,275,)
EjecutarTarea_160() Generar acto administrativo id_comp1223
11 11
ValidarUsuario(160):1
EjecutarPaso_275: form:26 , caso=98 id_comp 1223
Paso::Guardar(Caso:98)
Datos a guardar:
Array
(
[wf_proceso_id] => 85
[wf_paso_id] => 275
[wf_tarea_id] => 160
[wf_caso_id] => 98
[id] => 1223
[accion] => nextPaso
[reg] => s
[rta] => n
[cod_formulario2] => 26
[id_periodo] => 2015
[obs_ingreso] =>
[cod_bloque] => 27
[oid] =>
[oid_maestro] =>
[408] => 1
)
OID: 18
rta: 1 dato:18 tabla:sce.t26
CasoPaso:382
CargarDatos_275(18)
se carga 85_160_275_26_27_409
se carga 85_160_275_26_27_4081
SiguientePasoDe275: Funcion para ejecutar el siguiente paso
Condicion Tarea : 1 ==1
TerminarTarea(160,129)
Ultimo seg :444
Ultimo seg :445
EjecutarTarea_129() acto admin doc salida id_comp1223
11 11
ValidarUsuario(129):1
EjecutarPaso_237: form:21 , caso=98 id_comp 1223
Mostrar form
Retorno :
Array
(
[ret] => Ext.getCmp('comp_1223').removeAll();Ext.getCmp('comp_1223').add(new Ext.form.FormPanel({ title: 'Ingreso de datos' ,padding: 10,id:'frm_formulario_85_98',autoScroll:true ,labelAlign:'top',defaults: { anchor: '97%'} ,items: [new Ext.form.Hidden({name:'cod_formulario2',value:'21'}) ,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:'22'}) ,new Ext.form.Hidden({name :'oid',value:''}) ,new Ext.form.Hidden({name :'oid_maestro',value:''}) ,{value:'',xtype:'textfield' , maxLength:4,autoCreate:{ tag:'input',maxlength:'4'} ,allowBlank:false,maskRe:/^[0-9]$/,id:'398',fieldLabel:'* No. Resolución' },new Ext.form.DateField({fieldLabel:'* Fecha',name:'399',allowBlank:false,maskRe:/^[-_0-9]$/,format:FormatoFecha,renderer:Ext.util.Format.dateRenderer(FormatoFecha) }),{value:'',xtype:'textfield' , maxLength:255,autoCreate:{ tag:'input',maxlength:'255'} ,listeners:{ blur:function(){ this.setValue(this.getValue().toUpperCase()); } } ,allowBlank:false,id:'400',fieldLabel:'* Entidad' },{value:'',xtype:'textfield' , maxLength:30,autoCreate:{ tag:'input',maxlength:'30'} ,allowBlank:false,id:'328',fieldLabel:'* No. predial' },{value:'',xtype:'textfield' , maxLength:255,autoCreate:{ tag:'input',maxlength:'255'} ,allowBlank:false,id:'329',fieldLabel:'* Dirección' }, new Ext.form.TextArea({id:'401',allowBlank:false, fieldLabel:'* ArtÃculo y literal que le aplica',name:'401'}),{value:'',xtype:'textfield' , maxLength:4,autoCreate:{ tag:'input',maxlength:'4'} ,allowBlank:false,id:'402',fieldLabel:'* Concepto',maskRe:/^[0-9]$/ },{value:'',xtype:'textfield' , maxLength:10,autoCreate:{ tag:'input',maxlength:'10'} ,allowBlank:false,id:'403',fieldLabel:'* Impuesto predial',maskRe:/^[0-9]$/ },{value:'',xtype:'textfield' , maxLength:3,autoCreate:{ tag:'input',maxlength:'3'} ,allowBlank:false,id:'404',fieldLabel:'* Exoneración del',maskRe:/^[0-9]$/ },{value:'',xtype:'textfield' , maxLength:10,autoCreate:{ tag:'input',maxlength:'10'} ,allowBlank:false,id:'405',fieldLabel:'* Alumbrado Publico',maskRe:/^[0-9]$/ },{value:'',xtype:'textfield' , maxLength:10,autoCreate:{ tag:'input',maxlength:'10'} ,allowBlank:false,id:'406',fieldLabel:'* Contribucion Bomberos',maskRe:/^[0-9]$/ } ] ,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_85_98'); 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:'85',wf_paso_id:'237',wf_tarea_id:'129',wf_caso_id:'98',id:'1223',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_85_98').getForm().loadRecord(new Ext.data.Record({"cod_formulario":21,"oid_maestro":null,"cod_bloque":22,"398":null,"400":null,"328":null,"329":null,"402":null,"403":null,"404":null,"405":null,"406":null})); llamadaAJAX({url:'http://192.168.10.116/sisad/build/view/workflow/casos/casos_datosForm.php',mostrarMsg:false,params:{accion:'verifica',wf_paso_id:'237',cod_formulario:'21',cod_bloque:'22',wf_caso_id:'{"pro":"85","cas":"98"}'}}); }catch(e){alert(e);} } } }) );Ext.getCmp('comp_1223').doLayout();
[suc] => 1
)
fin 2015-07-10 15:37:19
/******************************************************************************************************/
2015-07-10 15:37:19TraerCaso(98,85,)
CargarCaso :98
2015-07 10 15:37:19
CargarDatos: Caso :98
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_85_seguimiento_id,wf_paso_id from wf_caso_85_pasos a1 group by wf_caso_85_seguimiento_id,wf_paso_id order by id
)a
inner join wf_caso_85_pasos p using(id,wf_caso_85_seguimiento_id)
inner join ( select max(id) as wf_caso_85_seguimiento_id,wf_caso_85_id,wf_tarea_id from wf_caso_85_seguimiento where wf_caso_85_id =? group by wf_caso_85_id,wf_tarea_id order by wf_caso_85_id,wf_caso_85_seguimiento_id ) b using(wf_caso_85_seguimiento_id)
left join usuarios u using(core_usuario_id)
{"0":"377","id":"377","1":"189","wf_paso_id":"189","2":"439","wf_caso_85_seguimiento_id":"439","3":"11","core_usuario_id":"11","4":"2015-07-10 15:36:45","fecha_ejec":"2015-07-10 15:36:45","5":"79","dato":"79","6":"sce.t20","tabla":"sce.t20","7":"89","tarea_id":"89","8":"siti soluciones German: ciudadano, gerente","usr_ejec":"siti soluciones German: ciudadano, gerente"}
CargarDatos_189(79)
se carga 85_89_189_20_21_3278
se carga 85_89_189_20_21_3262015-07-10
{"0":"378","id":"378","1":"209","wf_paso_id":"209","2":"440","wf_caso_85_seguimiento_id":"440","3":"11","core_usuario_id":"11","4":"2015-07-10 15:37:04","fecha_ejec":"2015-07-10 15:37:04","5":"6740","dato":"6740","6":"wf_documentoentradaadj_caso","tabla":"wf_documentoentradaadj_caso","7":"95","tarea_id":"95","8":"siti soluciones German: ciudadano, gerente","usr_ejec":"siti soluciones German: ciudadano, gerente"}
CargarDatos_209(6740)
{"0":"379","id":"379","1":"234","wf_paso_id":"234","2":"441","wf_caso_85_seguimiento_id":"441","3":"11","core_usuario_id":"11","4":"2015-07-10 15:37:05","fecha_ejec":"2015-07-10 15:37:05","5":null,"dato":null,"6":null,"tabla":null,"7":"127","tarea_id":"127","8":"siti soluciones German: ciudadano, gerente","usr_ejec":"siti soluciones German: ciudadano, gerente"}
CargarDatos_234()
{"0":"380","id":"380","1":"226","wf_paso_id":"226","2":"442","wf_caso_85_seguimiento_id":"442","3":"11","core_usuario_id":"11","4":"2015-07-10 15:37:10","fecha_ejec":"2015-07-10 15:37:10","5":"2633","dato":"2633","6":"wf_documentoentradaadj_caso","tabla":"wf_documentoentradaadj_caso","7":"113","tarea_id":"113","8":"siti soluciones German: ciudadano, gerente","usr_ejec":"siti soluciones German: ciudadano, gerente"}
CargarDatos_226(2633)
{"0":"381","id":"381","1":"235","wf_paso_id":"235","2":"443","wf_caso_85_seguimiento_id":"443","3":"11","core_usuario_id":"11","4":"2015-07-10 15:37:16","fecha_ejec":"2015-07-10 15:37:16","5":null,"dato":null,"6":null,"tabla":null,"7":"128","tarea_id":"128","8":"siti soluciones German: ciudadano, gerente","usr_ejec":"siti soluciones German: ciudadano, gerente"}
CargarDatos_235()
{"0":"382","id":"382","1":"275","wf_paso_id":"275","2":"444","wf_caso_85_seguimiento_id":"444","3":"11","core_usuario_id":"11","4":"2015-07-10 15:37:19","fecha_ejec":"2015-07-10 15:37:19","5":"18","dato":"18","6":"sce.t26","tabla":"sce.t26","7":"160","tarea_id":"160","8":"siti soluciones German: ciudadano, gerente","usr_ejec":"siti soluciones German: ciudadano, gerente"}
CargarDatos_275(18)
se carga 85_160_275_26_27_409
se carga 85_160_275_26_27_4081
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_85_seguimiento a
inner join (
select max(b0.id) as id,b0.wf_caso_85_id,b0.wf_tarea_id from wf_caso_85_seguimiento b0 where b0.wf_caso_85_id =? group by b0.wf_caso_85_id,b0.wf_tarea_id order by wf_caso_85_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":"439","id":"439","1":"98","wf_caso_85_id":"98","2":"89","wf_tarea_id":"89","3":null,"core_usuario_id":null,"4":"2015-07-10 15:35:48","fec_asig":"2015-07-10 15:35:48","5":"11","core_usuario_id_resol":"11","6":"2015-07-10 15:36:45","fec_resol":"2015-07-10 15:36:45","7":"89","wf_tarea_id_sig":"89","8":null,"usr_asig":null,"9":"siti soluciones German: ciudadano, gerente","usr_resol":"siti soluciones German: ciudadano, gerente"}
{"0":"440","id":"440","1":"98","wf_caso_85_id":"98","2":"95","wf_tarea_id":"95","3":"11","core_usuario_id":"11","4":"2015-07-10 15:36:45","fec_asig":"2015-07-10 15:36:45","5":"11","core_usuario_id_resol":"11","6":"2015-07-10 15:37:04","fec_resol":"2015-07-10 15:37:04","7":"95","wf_tarea_id_sig":"95","8":"siti soluciones German: ciudadano, gerente","usr_asig":"siti soluciones German: ciudadano, gerente","9":"siti soluciones German: ciudadano, gerente","usr_resol":"siti soluciones German: ciudadano, gerente"}
{"0":"441","id":"441","1":"98","wf_caso_85_id":"98","2":"127","wf_tarea_id":"127","3":"11","core_usuario_id":"11","4":"2015-07-10 15:37:04","fec_asig":"2015-07-10 15:37:04","5":"11","core_usuario_id_resol":"11","6":"2015-07-10 15:37:05","fec_resol":"2015-07-10 15:37:05","7":"127","wf_tarea_id_sig":"127","8":"siti soluciones German: ciudadano, gerente","usr_asig":"siti soluciones German: ciudadano, gerente","9":"siti soluciones German: ciudadano, gerente","usr_resol":"siti soluciones German: ciudadano, gerente"}
{"0":"442","id":"442","1":"98","wf_caso_85_id":"98","2":"113","wf_tarea_id":"113","3":"11","core_usuario_id":"11","4":"2015-07-10 15:37:05","fec_asig":"2015-07-10 15:37:05","5":"11","core_usuario_id_resol":"11","6":"2015-07-10 15:37:10","fec_resol":"2015-07-10 15:37:10","7":"113","wf_tarea_id_sig":"113","8":"siti soluciones German: ciudadano, gerente","usr_asig":"siti soluciones German: ciudadano, gerente","9":"siti soluciones German: ciudadano, gerente","usr_resol":"siti soluciones German: ciudadano, gerente"}
{"0":"443","id":"443","1":"98","wf_caso_85_id":"98","2":"128","wf_tarea_id":"128","3":"11","core_usuario_id":"11","4":"2015-07-10 15:37:10","fec_asig":"2015-07-10 15:37:10","5":"11","core_usuario_id_resol":"11","6":"2015-07-10 15:37:16","fec_resol":"2015-07-10 15:37:16","7":"128","wf_tarea_id_sig":"128","8":"siti soluciones German: ciudadano, gerente","usr_asig":"siti soluciones German: ciudadano, gerente","9":"siti soluciones German: ciudadano, gerente","usr_resol":"siti soluciones German: ciudadano, gerente"}
{"0":"444","id":"444","1":"98","wf_caso_85_id":"98","2":"160","wf_tarea_id":"160","3":"11","core_usuario_id":"11","4":"2015-07-10 15:37:16","fec_asig":"2015-07-10 15:37:16","5":"11","core_usuario_id_resol":"11","6":"2015-07-10 15:37:19","fec_resol":"2015-07-10 15:37:19","7":"160","wf_tarea_id_sig":"160","8":"siti soluciones German: ciudadano, gerente","usr_asig":"siti soluciones German: ciudadano, gerente","9":"siti soluciones German: ciudadano, gerente","usr_resol":"siti soluciones German: ciudadano, gerente"}
{"0":"445","id":"445","1":"98","wf_caso_85_id":"98","2":"129","wf_tarea_id":"129","3":"11","core_usuario_id":"11","4":"2015-07-10 15:37:19","fec_asig":"2015-07-10 15:37:19","5":null,"core_usuario_id_resol":null,"6":null,"fec_resol":null,"7":"129","wf_tarea_id_sig":"129","8":"siti soluciones German: ciudadano, gerente","usr_asig":"siti soluciones German: ciudadano, gerente","9":null,"usr_resol":null}
2015-07 10 15:37:19
cargar datos del sujeto(,,s,85,98)
select s.*, m.nombre as nom_muni, c.nom_cat,fec_caso
from wf_caso_85 w
inner join core_sujetoverificacion s on w.id=98 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:37:19
tabla dat adic
select tabla from core_sujetoverificaciontipo where id=1
2015-07 10 15:37:19
tabla :persona
SELECT * FROM persona where id=3
fin 2015-07-10 15:37:19
/******************************************************************************************************/
2015-07-10 15:38:18TraerCaso(98,85,)
CargarCaso :98
2015-07 10 15:38:18
CargarDatos: Caso :98
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_85_seguimiento_id,wf_paso_id from wf_caso_85_pasos a1 group by wf_caso_85_seguimiento_id,wf_paso_id order by id
)a
inner join wf_caso_85_pasos p using(id,wf_caso_85_seguimiento_id)
inner join ( select max(id) as wf_caso_85_seguimiento_id,wf_caso_85_id,wf_tarea_id from wf_caso_85_seguimiento where wf_caso_85_id =? group by wf_caso_85_id,wf_tarea_id order by wf_caso_85_id,wf_caso_85_seguimiento_id ) b using(wf_caso_85_seguimiento_id)
left join usuarios u using(core_usuario_id)
{"0":"377","id":"377","1":"189","wf_paso_id":"189","2":"439","wf_caso_85_seguimiento_id":"439","3":"11","core_usuario_id":"11","4":"2015-07-10 15:36:45","fecha_ejec":"2015-07-10 15:36:45","5":"79","dato":"79","6":"sce.t20","tabla":"sce.t20","7":"89","tarea_id":"89","8":"siti soluciones German: ciudadano, gerente","usr_ejec":"siti soluciones German: ciudadano, gerente"}
CargarDatos_189(79)
se carga 85_89_189_20_21_3278
se carga 85_89_189_20_21_3262015-07-10
{"0":"378","id":"378","1":"209","wf_paso_id":"209","2":"440","wf_caso_85_seguimiento_id":"440","3":"11","core_usuario_id":"11","4":"2015-07-10 15:37:04","fecha_ejec":"2015-07-10 15:37:04","5":"6740","dato":"6740","6":"wf_documentoentradaadj_caso","tabla":"wf_documentoentradaadj_caso","7":"95","tarea_id":"95","8":"siti soluciones German: ciudadano, gerente","usr_ejec":"siti soluciones German: ciudadano, gerente"}
CargarDatos_209(6740)
{"0":"379","id":"379","1":"234","wf_paso_id":"234","2":"441","wf_caso_85_seguimiento_id":"441","3":"11","core_usuario_id":"11","4":"2015-07-10 15:37:05","fecha_ejec":"2015-07-10 15:37:05","5":null,"dato":null,"6":null,"tabla":null,"7":"127","tarea_id":"127","8":"siti soluciones German: ciudadano, gerente","usr_ejec":"siti soluciones German: ciudadano, gerente"}
CargarDatos_234()
{"0":"380","id":"380","1":"226","wf_paso_id":"226","2":"442","wf_caso_85_seguimiento_id":"442","3":"11","core_usuario_id":"11","4":"2015-07-10 15:37:10","fecha_ejec":"2015-07-10 15:37:10","5":"2633","dato":"2633","6":"wf_documentoentradaadj_caso","tabla":"wf_documentoentradaadj_caso","7":"113","tarea_id":"113","8":"siti soluciones German: ciudadano, gerente","usr_ejec":"siti soluciones German: ciudadano, gerente"}
CargarDatos_226(2633)
{"0":"381","id":"381","1":"235","wf_paso_id":"235","2":"443","wf_caso_85_seguimiento_id":"443","3":"11","core_usuario_id":"11","4":"2015-07-10 15:37:16","fecha_ejec":"2015-07-10 15:37:16","5":null,"dato":null,"6":null,"tabla":null,"7":"128","tarea_id":"128","8":"siti soluciones German: ciudadano, gerente","usr_ejec":"siti soluciones German: ciudadano, gerente"}
CargarDatos_235()
{"0":"382","id":"382","1":"275","wf_paso_id":"275","2":"444","wf_caso_85_seguimiento_id":"444","3":"11","core_usuario_id":"11","4":"2015-07-10 15:37:19","fecha_ejec":"2015-07-10 15:37:19","5":"18","dato":"18","6":"sce.t26","tabla":"sce.t26","7":"160","tarea_id":"160","8":"siti soluciones German: ciudadano, gerente","usr_ejec":"siti soluciones German: ciudadano, gerente"}
CargarDatos_275(18)
se carga 85_160_275_26_27_409
se carga 85_160_275_26_27_4081
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_85_seguimiento a
inner join (
select max(b0.id) as id,b0.wf_caso_85_id,b0.wf_tarea_id from wf_caso_85_seguimiento b0 where b0.wf_caso_85_id =? group by b0.wf_caso_85_id,b0.wf_tarea_id order by wf_caso_85_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":"439","id":"439","1":"98","wf_caso_85_id":"98","2":"89","wf_tarea_id":"89","3":null,"core_usuario_id":null,"4":"2015-07-10 15:35:48","fec_asig":"2015-07-10 15:35:48","5":"11","core_usuario_id_resol":"11","6":"2015-07-10 15:36:45","fec_resol":"2015-07-10 15:36:45","7":"89","wf_tarea_id_sig":"89","8":null,"usr_asig":null,"9":"siti soluciones German: ciudadano, gerente","usr_resol":"siti soluciones German: ciudadano, gerente"}
{"0":"440","id":"440","1":"98","wf_caso_85_id":"98","2":"95","wf_tarea_id":"95","3":"11","core_usuario_id":"11","4":"2015-07-10 15:36:45","fec_asig":"2015-07-10 15:36:45","5":"11","core_usuario_id_resol":"11","6":"2015-07-10 15:37:04","fec_resol":"2015-07-10 15:37:04","7":"95","wf_tarea_id_sig":"95","8":"siti soluciones German: ciudadano, gerente","usr_asig":"siti soluciones German: ciudadano, gerente","9":"siti soluciones German: ciudadano, gerente","usr_resol":"siti soluciones German: ciudadano, gerente"}
{"0":"441","id":"441","1":"98","wf_caso_85_id":"98","2":"127","wf_tarea_id":"127","3":"11","core_usuario_id":"11","4":"2015-07-10 15:37:04","fec_asig":"2015-07-10 15:37:04","5":"11","core_usuario_id_resol":"11","6":"2015-07-10 15:37:05","fec_resol":"2015-07-10 15:37:05","7":"127","wf_tarea_id_sig":"127","8":"siti soluciones German: ciudadano, gerente","usr_asig":"siti soluciones German: ciudadano, gerente","9":"siti soluciones German: ciudadano, gerente","usr_resol":"siti soluciones German: ciudadano, gerente"}
{"0":"442","id":"442","1":"98","wf_caso_85_id":"98","2":"113","wf_tarea_id":"113","3":"11","core_usuario_id":"11","4":"2015-07-10 15:37:05","fec_asig":"2015-07-10 15:37:05","5":"11","core_usuario_id_resol":"11","6":"2015-07-10 15:37:10","fec_resol":"2015-07-10 15:37:10","7":"113","wf_tarea_id_sig":"113","8":"siti soluciones German: ciudadano, gerente","usr_asig":"siti soluciones German: ciudadano, gerente","9":"siti soluciones German: ciudadano, gerente","usr_resol":"siti soluciones German: ciudadano, gerente"}
{"0":"443","id":"443","1":"98","wf_caso_85_id":"98","2":"128","wf_tarea_id":"128","3":"11","core_usuario_id":"11","4":"2015-07-10 15:37:10","fec_asig":"2015-07-10 15:37:10","5":"11","core_usuario_id_resol":"11","6":"2015-07-10 15:37:16","fec_resol":"2015-07-10 15:37:16","7":"128","wf_tarea_id_sig":"128","8":"siti soluciones German: ciudadano, gerente","usr_asig":"siti soluciones German: ciudadano, gerente","9":"siti soluciones German: ciudadano, gerente","usr_resol":"siti soluciones German: ciudadano, gerente"}
{"0":"444","id":"444","1":"98","wf_caso_85_id":"98","2":"160","wf_tarea_id":"160","3":"11","core_usuario_id":"11","4":"2015-07-10 15:37:16","fec_asig":"2015-07-10 15:37:16","5":"11","core_usuario_id_resol":"11","6":"2015-07-10 15:37:19","fec_resol":"2015-07-10 15:37:19","7":"160","wf_tarea_id_sig":"160","8":"siti soluciones German: ciudadano, gerente","usr_asig":"siti soluciones German: ciudadano, gerente","9":"siti soluciones German: ciudadano, gerente","usr_resol":"siti soluciones German: ciudadano, gerente"}
{"0":"445","id":"445","1":"98","wf_caso_85_id":"98","2":"129","wf_tarea_id":"129","3":"11","core_usuario_id":"11","4":"2015-07-10 15:37:19","fec_asig":"2015-07-10 15:37:19","5":null,"core_usuario_id_resol":null,"6":null,"fec_resol":null,"7":"129","wf_tarea_id_sig":"129","8":"siti soluciones German: ciudadano, gerente","usr_asig":"siti soluciones German: ciudadano, gerente","9":null,"usr_resol":null}
2015-07 10 15:38:18
cargar datos del sujeto(,,s,85,98)
select s.*, m.nombre as nom_muni, c.nom_cat,fec_caso
from wf_caso_85 w
inner join core_sujetoverificacion s on w.id=98 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:38:18
tabla dat adic
select tabla from core_sujetoverificaciontipo where id=1
2015-07 10 15:38:18
tabla :persona
SELECT * FROM persona where id=3
2015-07 10 15:38:18
Continuar(s,129,237,)
EjecutarTarea_129() acto admin doc salida id_comp1223
11 11
ValidarUsuario(129):1
EjecutarPaso_237: form:21 , caso=98 id_comp 1223
Paso::Guardar(Caso:98)
Datos a guardar:
Array
(
[wf_proceso_id] => 85
[wf_paso_id] => 237
[wf_tarea_id] => 129
[wf_caso_id] => 98
[id] => 1223
[accion] => nextPaso
[reg] => s
[rta] => n
[cod_formulario2] => 21
[id_periodo] => 2015
[obs_ingreso] =>
[cod_bloque] => 22
[oid] =>
[oid_maestro] =>
[398] => 1221
[399] => 2015-07-17
[400] => DFGDSF
[328] => 123
[329] => 1231
[401] => sdasd
[402] => 2012
[403] => 2500
[404] => 0
[405] => 132
[406] => 213
)
OID: 6
rta: 1 dato:6 tabla:sce.t21
CasoPaso:383
CargarDatos_237(6)
se carga 85_129_237_21_22_406213
se carga 85_129_237_21_22_405132
se carga 85_129_237_21_22_4040
se carga 85_129_237_21_22_4032500
se carga 85_129_237_21_22_4022012
se carga 85_129_237_21_22_401sdasd
se carga 85_129_237_21_22_400DFGDSF
se carga 85_129_237_21_22_3992015-07-17
se carga 85_129_237_21_22_3981221
se carga 85_129_237_21_22_3291231
se carga 85_129_237_21_22_328123
SiguientePasoDe237: Funcion para ejecutar el siguiente paso
EjecutarPaso_257: docs:83 , caso=98 id_comp 1223
Mostrar docs
$tit_formato='CERTIFICADO EXCENCION DE IMPUESTOS';
$n=' WFSV_2 ';$a= ' WFSV_3 ';
$nom=$n.$a;
$ced=' WFSV_4 ';
$nres= ' 85_129_237_21_22_398 ';
$fecha =' 85_129_237_21_22_399 ';
$ent= ' 85_129_237_21_22_400 ';
$npre= ' 85_129_237_21_22_328 ';
$dir= ' 85_129_237_21_22_329 ';
$atri= ' 85_129_237_21_22_401 ';
$conc= ' 85_129_237_21_22_402 ';
$imp= ' 85_129_237_21_22_403 ';
$exon= ' 85_129_237_21_22_404 ';
$alum= ' 85_129_237_21_22_405 ';
$bomb= ' 85_129_237_21_22_406 ';
$f=split('-',$fecha);
if($f[1]==1)$f[1]='Enero';
if($f[1]==2)$f[1]='Febrero';
if($f[1]==3)$f[1]='Marzo';
if($f[1]==4)$f[1]='Abril';
if($f[1]==5)$f[1]='Mayo';
if($f[1]==6)$f[1]='Junio';
if($f[1]==7)$f[1]='Julio';
if($f[1]==8)$f[1]='Agosto';
if($f[1]==9)$f[1]='Septiembre';
if($f[1]==10)$f[1]='Octubre';
if($f[1]==11)$f[1]='Noviembre';
if($f[1]==12)$f[1]='Diciembre';
require_once($root.'/lib/tcpdf/config/lang/eng.php');
require_once($root.'/lib/tcpdf/tcpdf.php');
require_once($root.'/lib/num_letras.php');
//--------------------------------------------------------------------------
class MYPDF extends TCPDF {
//Page header
public function Header() {
// Logo
//echo str_replace('$root_js',$root_js,$CONFIG['CABECERA_FORMATOS_HTML']);
$image_file = K_PATH_IMAGES.'logo_alcaldia.jpg';
$htm='<table width="100%" height="5%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="100%" align="center"><img src="'.$image_file.'" alt="a" height="90" /></td>
</tr>
</table><br /><br /><br>';
$npag=$this->getAliasNbPages();
$this->writeHTMLCell($w = 0, $h = 0, $x = '', $y = '', $htm, $border = 0, $ln = 1, $fill = 0, $reseth = true, $align = 'top', $autopadding = true);
}
// Page footer
public function Footer() {
// Position at 15 mm from bottom
$this->SetY(-15);
// Set font
$this->SetFont('helvetica', 'I', 8);
// Page number
$this->Cell(0, 10, '', 0, false, 'C', 0, '', 0, false, 'T', 'M');
}
}
//--------------------------------------------------------------------------
// create new PDF document
$pdf = new MYPDF('p', 'mm', 'letter', true, 'UTF-8', false);
// set document information
$pdf->SetCreator(PDF_CREATOR);
$pdf->SetAuthor('Siti');
$pdf->SetTitle('CERTIFICADO VECINDAD');
$pdf->SetSubject('Certificado');
$pdf->SetKeywords('TCPDF, PDF, example, test, guide');
// set default header data
$pdf->SetHeaderData(PDF_HEADER_LOGO, PDF_HEADER_LOGO_WIDTH, PDF_HEADER_TITLE, PDF_HEADER_STRING);
// set header and footer fonts
$pdf->setHeaderFont(Array(PDF_FONT_NAME_MAIN, '', PDF_FONT_SIZE_MAIN));
$pdf->setFooterFont(Array(PDF_FONT_NAME_DATA, '', PDF_FONT_SIZE_DATA));
// set default monospaced font
$pdf->SetDefaultMonospacedFont(PDF_FONT_MONOSPACED);
// set margins
$pdf->SetMargins(PDF_MARGIN_LEFT, PDF_MARGIN_TOP, PDF_MARGIN_RIGHT);
$pdf->SetHeaderMargin(PDF_MARGIN_HEADER);
$pdf->SetFooterMargin(PDF_MARGIN_FOOTER);
// set auto page breaks
$pdf->SetAutoPageBreak(TRUE, PDF_MARGIN_BOTTOM);
// set image scale factor
$pdf->setImageScale(PDF_IMAGE_SCALE_RATIO);
//set some language-dependent strings
$pdf->setLanguageArray($l);
// ---------------------------------------------------------
// NOTE: 2D barcode algorithms must be implemented on 2dbarcode.php class file.
// set font
$pdf->SetFont('helvetica', '', 10);
// add a page
$pdf->AddPage();
// - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
$fils=4;
$cols=3;
$logo_empresa=$CONFIG['LOGO_EMPRESA'];
$codigo=$root_js.'build/view/common/marco/index.php?particular=001&accion=I&proc='.$CONFIG['PROCESO_STICKER'];
$izq=10+2;$der=10;$arr=10; $abj=10;
$sxp=$fils*$cols;
$tot=$rangoF-$rangoI+1;
$pags=ceil(($tot)/$sxp);
$anchoR=216-$izq-$der;
$altoR=279-$arr-$abj;
$anchoS=$anchoR/$cols;
$margenSV=4;
$margenSH=5;
$altoS=$altoR/$fils;
$altoImg=10;
$altoText=8;
$altoC=50;
// set style for barcode
$style = array(
'border' => 2,
'vpadding' => 'auto',
'hpadding' => 'auto',
'fgcolor' => array(0,0,0),
'bgcolor' => false, //array(255,255,255)
'module_width' => 1, // width of a single module in points
'module_height' => 1 // height of a single module in points
);
$pdf->SetFont('helvetica', '', 9, '', false);
$pdf->SetDefaultMonospacedFont(PDF_FONT_MONOSPACED);
$s=0;$p=1;$consc=$rangoI;
$y=$arr;
$x=$izq;
// create some HTML content
ob_start();
?>
<br /><br><br>
<table width="100%" border="0">
<tr>
<td style="text-align: center"><strong>RESOLUCION No. <?php echo $nres; ?><br>
<?php echo $f[2]." de ".$f[1]." de ".$f[0]?></strong><br><br><br></td>
</tr>
<tr>
<td style="text-align: center"><br><strong>POR MEDIO DE LA CUAL SE AUTORIZA EXENCION DEL IMPUESTO PREDIAL UNIFICADO</strong><br><br></td>
</tr>
<tr>
<td>La SubsecretarÃa de Ingresos de la SecretarÃa de Hacienda del Municipio de Pasto, en uso de sus atribuciones legales, y<br><br></td>
</tr>
<tr>
<td style="text-align: center"><strong>CONSIDERANDO:</strong></td>
</tr>
<tr>
<td><div align="justify"><p>Que, la <?php echo $ent; ?>, por intermedio de Representante Legal señor <?php echo $nom; ?>, identificado con cédula de ciudadanÃa No. <?php echo $ced; ?>, solicita se autorice exención del impuesto Predial Unificado, de conformidad a lo previsto en el Estatuto Tributario del Municipio de Pasto, para el inmueble identificado con código catastral No. <?php echo $npre; ?> ubicado en <?php echo $dir; ?>, para la vigencia <?php echo $conc; ?>.</p>
<p>Que el Estatuto Tributario del Municipio de Pasto Decreto 0265 del 29 de Abril de 2011 (Modificado por el Acuerdo No. 032 del 3 de diciembre de 2012), dispone: “<?php echo $atri; ?>â€</p>
<p>Que de conformidad a la norma mencionada, la cual no ha sido modificada y los documentos adjuntados como son Certificado de Tradición expedido por la Oficina de Instrumentos Públicos, en el cual consta la titularidad de dominio de la asociación, Certificación expedida por la Diócesis de Pasto, en la cual se reconoce a la comunidad religiosa y su representación legal y recibo predial expedido por el sistema SYSMAN de esta Secretaria; es procedente declarar la exención del impuesto predial unificado.<br><br>En mérito de lo expuesto,</p></div></td>
</tr>
<tr>
<td style="text-align: center"><strong>RESUELVE:<br></strong></td>
</tr>
<tr>
<td><div align="justify"><p><strong>ARTICULO PRIMERO.</strong> Autorizar la exención del impuesto Predial Unificado y los intereses que se causen por este concepto, a la <?php echo $ent; ?>, por intermedio de Representante Legal señor <?php echo $nom; ?>, identificado con cédula de ciudadanÃa No. <?php echo $ced; ?>, para el inmueble identificado con código catastral No. <?php echo $npre; ?> ubicado en <?php echo $dir; ?>, para la vigencia <?php echo $conc; ?>.<br><br>Por tal motivo se liquidará el impuesto predial de la siguiente manera:</p></div></td>
</tr>
<tr>
<td><br>
Predio Código Catastral No. <?php echo $npre; ?><br>
<table width="50%" border="1">
<tr>
<th width="50%" style="text-align: left" scope="row"><strong>Concepto</strong></th>
<td width="50%"><?php echo $conc; ?></td>
</tr>
<tr>
<th style="text-align: left" scope="row">Impuesto predial:</th>
<td><?php echo $imp; ?></td>
</tr>
<tr>
<th style="text-align: left" scope="row">Exención del:</th>
<td><?php echo $exon." %"; ?></td>
</tr>
<tr>
<th style="text-align: left" scope="row">Alumbrado Publico</th>
<td><?php echo $alum; ?></td>
</tr>
<tr>
<th style="text-align: left" scope="row">Contribución Bomberos:</th>
<td><?php echo $bomb; ?></td>
</tr>
<tr>
<th style="text-align: left" scope="row"><strong>Valor a cancelar</strong></th>
<td><strong><?php echo $imp-($imp*($exon/100))+$alum+$bomb; ?></strong></td>
</tr>
</table>
</td>
</tr>
<tr>
<td><div align="justify"><p><strong>ARTICULO SEGUNDO.</strong> Que la anterior exención no implica la exoneración del pago de la contribución de Bomberos, Alumbrado Público e intereses que se causen por estos conceptos, por lo tanto deberá cancelar el valor correspondiente, a la vigencia adeudada para proceder a descargar en el sistema si estos estuvieren establecidos para el predio en particular.</p>
<p>De igual forma no se registrará el descuento por pronto pago autorizado por la administración en el presente acto administrativo, el cual se hará efectivo al momento de descargar la presente Resolución en el sistema y el cual se encuentre vigente a la fecha de notificación.</p>
<p><strong>ARTICULO TERCERO.</strong> Esta resolución rige a partir de su ejecutoria y está vigente mientras dure la condición.</p></div><br></td>
</tr>
<tr>
<td style="text-align: center"><strong>NOTIFÃQUESE Y CUMPLASE:</strong></td>
</tr>
</table>
<br>
<?
$mes=date("F");
if ($mes=="January") $mes="Enero";
if ($mes=="February") $mes="Febrero";
if ($mes=="March") $mes="Marzo";
if ($mes=="April") $mes="Abril";
if ($mes=="May") $mes="Mayo";
if ($mes=="June") $mes="Junio";
if ($mes=="July") $mes="Julio";
if ($mes=="August") $mes="Agosto";
if ($mes=="September") $mes="Setiembre";
if ($mes=="October") $mes="Octubre";
if ($mes=="November") $mes="Noviembre";
if ($mes=="December") $mes="Diciembre";
$anio=date("Y");
$npag=$pdf->getAliasNbPages();
$lpag=convertir_a_letras($npag);
if($npag==1&&$lpag=='uno')$lpag='un';
?>
<br>
<?
$html=ob_get_clean();
// output the HTML content
$pdf->writeHTML($html, true, false,false,false);
// reset pointer to the last page
$pdf->lastPage();
//---
$pdf->AddPage();
ob_start();
?>
<table width="100%" border="0">
<tr>
<td colspan="2"><br><p style="text-align: center"><strong>JAIRO MARTINEZ CEBALLOS</strong><br>Subsecretaria de Ingresos</p></td>
</tr>
<tr>
<td colspan="2"><p>Proyecto <br>Abogada Cobro Persuasivo</p></td>
</tr>
<tr>
<td colspan="2"><br><br>
<strong><span style="text-align: center">DILIGENCIA DE NOTIFICACION PERSONAL</span></strong></td>
</tr>
<tr>
<td colspan="2"><br><div align="justify"><p>En San Juan de Pasto, a los <?php echo date('d')." dias del mes de ".$mes." de ".$anio?>, se presentó el (la) Señor (a) <?php echo $nom; ?>, identificado con cédula de ciudadanÃa No. <?php echo $ced; ?>, para notificarse personalmente de la Resolución No. <?php echo $nres; ?> del <?php echo $f[2]." de ".$f[1]." de ".$f[0]?>. Dentro de los cinco dÃas siguientes a esta diligencia puede interponer Recurso de Reposición ante la Subsecretaria de Ingresos y el de Apelación ante la Secretaria de Hacienda. <br><br>Se entrega copia de la providencia en <?php echo $lpag." (".$npag.")"; ?> folios.</p></div><br><br><br><br><br><br></td>
</tr>
<tr>
<td width="50%"><p style="text-align: center">________________________ <br> Notificado </p></td>
<td width="50%"><p style="text-align: center">____________________________<br>Notificador</p></td>
</tr>
<tr>
<td colspan="2"> </td>
</tr>
</table>
<?
$html=ob_get_clean();
// output the HTML content
$pdf->writeHTML($html, true, false,false,false);
// reset pointer to the last page
$pdf->lastPage();
//----
$nomdoc=md5(time()).'.pdf';
$pdf->Output($root."/tmp/".$nomdoc, 'F');
$url=$root_js.'tmp/'.$nomdoc;
TWFSV_4:98386390
TWFSV_3:siti soluciones
TWFSV_2:German
T85_129_237_21_22_406:213
T85_129_237_21_22_405:132
T85_129_237_21_22_404:0
T85_129_237_21_22_403:2500
T85_129_237_21_22_402:2012
T85_129_237_21_22_401:sdasd
T85_129_237_21_22_400:DFGDSF
T85_129_237_21_22_399:2015-07-17
T85_129_237_21_22_398:1221
T85_129_237_21_22_329:1231
T85_129_237_21_22_328:123
Retorno :
Array
(
[ret] => inicioComponente_WF_DocSalida({"id":"1223","caso_id":"98","proceso_id":85,"tit":"acto admin doc salida","tarea_id":129,"paso_id":257,"desc":"<strong>acto administrativo<\/strong>: exoneraci\u00f3n de impuestos","url":"<a href=\"http:\/\/192.168.10.116\/sisad\/tmp\/43f5ba640393269374d20f5266cf3e5b.pdf\" target=\"_blank\" >De clic aqui para descargar el archivo<\/a><\/div>"});
[suc] => 1
)
fin 2015-07-10 15:38:18
/******************************************************************************************************/
2015-07-10 15:38:35TraerCaso(98,85,)
CargarCaso :98
2015-07 10 15:38:35
CargarDatos: Caso :98
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_85_seguimiento_id,wf_paso_id from wf_caso_85_pasos a1 group by wf_caso_85_seguimiento_id,wf_paso_id order by id
)a
inner join wf_caso_85_pasos p using(id,wf_caso_85_seguimiento_id)
inner join ( select max(id) as wf_caso_85_seguimiento_id,wf_caso_85_id,wf_tarea_id from wf_caso_85_seguimiento where wf_caso_85_id =? group by wf_caso_85_id,wf_tarea_id order by wf_caso_85_id,wf_caso_85_seguimiento_id ) b using(wf_caso_85_seguimiento_id)
left join usuarios u using(core_usuario_id)
{"0":"377","id":"377","1":"189","wf_paso_id":"189","2":"439","wf_caso_85_seguimiento_id":"439","3":"11","core_usuario_id":"11","4":"2015-07-10 15:36:45","fecha_ejec":"2015-07-10 15:36:45","5":"79","dato":"79","6":"sce.t20","tabla":"sce.t20","7":"89","tarea_id":"89","8":"siti soluciones German: ciudadano, gerente","usr_ejec":"siti soluciones German: ciudadano, gerente"}
CargarDatos_189(79)
se carga 85_89_189_20_21_3278
se carga 85_89_189_20_21_3262015-07-10
{"0":"378","id":"378","1":"209","wf_paso_id":"209","2":"440","wf_caso_85_seguimiento_id":"440","3":"11","core_usuario_id":"11","4":"2015-07-10 15:37:04","fecha_ejec":"2015-07-10 15:37:04","5":"6740","dato":"6740","6":"wf_documentoentradaadj_caso","tabla":"wf_documentoentradaadj_caso","7":"95","tarea_id":"95","8":"siti soluciones German: ciudadano, gerente","usr_ejec":"siti soluciones German: ciudadano, gerente"}
CargarDatos_209(6740)
{"0":"379","id":"379","1":"234","wf_paso_id":"234","2":"441","wf_caso_85_seguimiento_id":"441","3":"11","core_usuario_id":"11","4":"2015-07-10 15:37:05","fecha_ejec":"2015-07-10 15:37:05","5":null,"dato":null,"6":null,"tabla":null,"7":"127","tarea_id":"127","8":"siti soluciones German: ciudadano, gerente","usr_ejec":"siti soluciones German: ciudadano, gerente"}
CargarDatos_234()
{"0":"380","id":"380","1":"226","wf_paso_id":"226","2":"442","wf_caso_85_seguimiento_id":"442","3":"11","core_usuario_id":"11","4":"2015-07-10 15:37:10","fecha_ejec":"2015-07-10 15:37:10","5":"2633","dato":"2633","6":"wf_documentoentradaadj_caso","tabla":"wf_documentoentradaadj_caso","7":"113","tarea_id":"113","8":"siti soluciones German: ciudadano, gerente","usr_ejec":"siti soluciones German: ciudadano, gerente"}
CargarDatos_226(2633)
{"0":"381","id":"381","1":"235","wf_paso_id":"235","2":"443","wf_caso_85_seguimiento_id":"443","3":"11","core_usuario_id":"11","4":"2015-07-10 15:37:16","fecha_ejec":"2015-07-10 15:37:16","5":null,"dato":null,"6":null,"tabla":null,"7":"128","tarea_id":"128","8":"siti soluciones German: ciudadano, gerente","usr_ejec":"siti soluciones German: ciudadano, gerente"}
CargarDatos_235()
{"0":"382","id":"382","1":"275","wf_paso_id":"275","2":"444","wf_caso_85_seguimiento_id":"444","3":"11","core_usuario_id":"11","4":"2015-07-10 15:37:19","fecha_ejec":"2015-07-10 15:37:19","5":"18","dato":"18","6":"sce.t26","tabla":"sce.t26","7":"160","tarea_id":"160","8":"siti soluciones German: ciudadano, gerente","usr_ejec":"siti soluciones German: ciudadano, gerente"}
CargarDatos_275(18)
se carga 85_160_275_26_27_409
se carga 85_160_275_26_27_4081
{"0":"383","id":"383","1":"237","wf_paso_id":"237","2":"445","wf_caso_85_seguimiento_id":"445","3":"11","core_usuario_id":"11","4":"2015-07-10 15:38:18","fecha_ejec":"2015-07-10 15:38:18","5":"6","dato":"6","6":"sce.t21","tabla":"sce.t21","7":"129","tarea_id":"129","8":"siti soluciones German: ciudadano, gerente","usr_ejec":"siti soluciones German: ciudadano, gerente"}
CargarDatos_237(6)
se carga 85_129_237_21_22_406213
se carga 85_129_237_21_22_405132
se carga 85_129_237_21_22_4040
se carga 85_129_237_21_22_4032500
se carga 85_129_237_21_22_4022012
se carga 85_129_237_21_22_401sdasd
se carga 85_129_237_21_22_400DFGDSF
se carga 85_129_237_21_22_3992015-07-17
se carga 85_129_237_21_22_3981221
se carga 85_129_237_21_22_3291231
se carga 85_129_237_21_22_328123
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_85_seguimiento a
inner join (
select max(b0.id) as id,b0.wf_caso_85_id,b0.wf_tarea_id from wf_caso_85_seguimiento b0 where b0.wf_caso_85_id =? group by b0.wf_caso_85_id,b0.wf_tarea_id order by wf_caso_85_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":"439","id":"439","1":"98","wf_caso_85_id":"98","2":"89","wf_tarea_id":"89","3":null,"core_usuario_id":null,"4":"2015-07-10 15:35:48","fec_asig":"2015-07-10 15:35:48","5":"11","core_usuario_id_resol":"11","6":"2015-07-10 15:36:45","fec_resol":"2015-07-10 15:36:45","7":"89","wf_tarea_id_sig":"89","8":null,"usr_asig":null,"9":"siti soluciones German: ciudadano, gerente","usr_resol":"siti soluciones German: ciudadano, gerente"}
{"0":"440","id":"440","1":"98","wf_caso_85_id":"98","2":"95","wf_tarea_id":"95","3":"11","core_usuario_id":"11","4":"2015-07-10 15:36:45","fec_asig":"2015-07-10 15:36:45","5":"11","core_usuario_id_resol":"11","6":"2015-07-10 15:37:04","fec_resol":"2015-07-10 15:37:04","7":"95","wf_tarea_id_sig":"95","8":"siti soluciones German: ciudadano, gerente","usr_asig":"siti soluciones German: ciudadano, gerente","9":"siti soluciones German: ciudadano, gerente","usr_resol":"siti soluciones German: ciudadano, gerente"}
{"0":"441","id":"441","1":"98","wf_caso_85_id":"98","2":"127","wf_tarea_id":"127","3":"11","core_usuario_id":"11","4":"2015-07-10 15:37:04","fec_asig":"2015-07-10 15:37:04","5":"11","core_usuario_id_resol":"11","6":"2015-07-10 15:37:05","fec_resol":"2015-07-10 15:37:05","7":"127","wf_tarea_id_sig":"127","8":"siti soluciones German: ciudadano, gerente","usr_asig":"siti soluciones German: ciudadano, gerente","9":"siti soluciones German: ciudadano, gerente","usr_resol":"siti soluciones German: ciudadano, gerente"}
{"0":"442","id":"442","1":"98","wf_caso_85_id":"98","2":"113","wf_tarea_id":"113","3":"11","core_usuario_id":"11","4":"2015-07-10 15:37:05","fec_asig":"2015-07-10 15:37:05","5":"11","core_usuario_id_resol":"11","6":"2015-07-10 15:37:10","fec_resol":"2015-07-10 15:37:10","7":"113","wf_tarea_id_sig":"113","8":"siti soluciones German: ciudadano, gerente","usr_asig":"siti soluciones German: ciudadano, gerente","9":"siti soluciones German: ciudadano, gerente","usr_resol":"siti soluciones German: ciudadano, gerente"}
{"0":"443","id":"443","1":"98","wf_caso_85_id":"98","2":"128","wf_tarea_id":"128","3":"11","core_usuario_id":"11","4":"2015-07-10 15:37:10","fec_asig":"2015-07-10 15:37:10","5":"11","core_usuario_id_resol":"11","6":"2015-07-10 15:37:16","fec_resol":"2015-07-10 15:37:16","7":"128","wf_tarea_id_sig":"128","8":"siti soluciones German: ciudadano, gerente","usr_asig":"siti soluciones German: ciudadano, gerente","9":"siti soluciones German: ciudadano, gerente","usr_resol":"siti soluciones German: ciudadano, gerente"}
{"0":"444","id":"444","1":"98","wf_caso_85_id":"98","2":"160","wf_tarea_id":"160","3":"11","core_usuario_id":"11","4":"2015-07-10 15:37:16","fec_asig":"2015-07-10 15:37:16","5":"11","core_usuario_id_resol":"11","6":"2015-07-10 15:37:19","fec_resol":"2015-07-10 15:37:19","7":"160","wf_tarea_id_sig":"160","8":"siti soluciones German: ciudadano, gerente","usr_asig":"siti soluciones German: ciudadano, gerente","9":"siti soluciones German: ciudadano, gerente","usr_resol":"siti soluciones German: ciudadano, gerente"}
{"0":"445","id":"445","1":"98","wf_caso_85_id":"98","2":"129","wf_tarea_id":"129","3":"11","core_usuario_id":"11","4":"2015-07-10 15:37:19","fec_asig":"2015-07-10 15:37:19","5":null,"core_usuario_id_resol":null,"6":null,"fec_resol":null,"7":"129","wf_tarea_id_sig":"129","8":"siti soluciones German: ciudadano, gerente","usr_asig":"siti soluciones German: ciudadano, gerente","9":null,"usr_resol":null}
2015-07 10 15:38:35
cargar datos del sujeto(,,s,85,98)
select s.*, m.nombre as nom_muni, c.nom_cat,fec_caso
from wf_caso_85 w
inner join core_sujetoverificacion s on w.id=98 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:38:35
tabla dat adic
select tabla from core_sujetoverificaciontipo where id=1
2015-07 10 15:38:35
tabla :persona
SELECT * FROM persona where id=3
2015-07 10 15:38:35
Continuar(s,129,257,)
EjecutarTarea_129() acto admin doc salida id_comp1223
11 11
ValidarUsuario(129):1
EjecutarPaso_257: docs:83 , caso=98 id_comp 1223
Paso::Guardar(Caso:98)
rta: 1 dato:153 tabla:core_upload
CasoPaso:384
CargarDatos_257(153)
SiguientePasoDe257: Funcion para ejecutar el siguiente paso
Condicion Tarea : true
TerminarTarea(129,131)
Ultimo seg :445
Ultimo seg :446
EjecutarTarea_131() certificado exitoso id_comp1223
11 11
ValidarUsuario(131):1
EjecutarPaso_236: corr:72 , caso=98 id_comp 1223
Mostrar corr
ob_start();
$ciud = mb_strtoupper( "{ WFSV_2 } { WFSV_3 }",'utf-8');
?>
<p>
Apreciado(a)<br>
<strong><?php echo htmlentities($ciud) ?></strong>
<p>
<p>El presente mensaje es una notificación para el caso No <strong><?php echo $id_caso; ?></strong> </p>
<?php $html=ob_get_clean();
TWFSV_3:siti soluciones
TWFSV_2:German
<br>Su solicitud de Exenciones de impuestos predial fue realizada exitosamente.Favor acercarse a la ventanilla correspondiente para hacer efectivo el acto administrativo para generar la excepción de impuesto correspondiente
{ WFSV_1 }
TWFSV_1:desarrollo4@siticol.com
Certificado exitoso en exenciones de impuestos predial
Retorno :
Array
(
[ret] => inicioComponente_WF_Correo({"id":"1223","caso_id":"98","proceso_id":85,"tit":"certificado exitoso","tarea_id":131,"paso_id":236,"desc":"<p>\nApreciado(a)<br>\n<strong>GERMAN SITI SOLUCIONES<\/strong>\n<p>\n<p>El presente mensaje es una notificación para el caso No <strong>98<\/strong> <\/p>\n<strong><br>Su solicitud de Exenciones de impuestos predial fue realizada exitosamente.Favor acercarse a la ventanilla correspondiente para hacer efectivo el acto administrativo para generar la excepci\u00f3n de impuesto correspondiente<\/strong> ","url":"<a href=\"#\" onclick=\" llamadaAJAX({\r\n\t\t\t\t\t\t\t\t\turl:'http:\/\/192.168.10.116\/sisad\/build\/view\/mail\/envio\/envio_l.php',\r\n\t\t\t\t\t\t\t\t\tmostrarMsg:true,\r\n\t\t\t\t\t\t\t\t\tparams:{accion:'envio2',destino:'desarrollo4@siticol.com ',asunto:'Certificado exitoso en exenciones de impuestos predial'},\r\n\t\t\t\t\t\t\t\t\tsuccess:function(result){\r\n\t\t\t\t\t\t\t\t\t\t\t\t\tif(result.success) \r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\tcrearMsg(action.result.message,'Informacion');\r\n\t\t\t\t\t\t\t\t\t\t\t\t\telse{\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\tcrearMsg(action.result.message,'Informacion');\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t}\r\n\t\t\t\t\t\t\t\t\t\t\t\t},\r\n\t\t\t\t\t\t\t\t});\" >De click aqui para volver a enviar el correo<\/a><\/div>"});
[suc] => 1
)
fin 2015-07-10 15:38:35
/******************************************************************************************************/
2015-07-10 15:38:40TraerCaso(98,85,)
CargarCaso :98
2015-07 10 15:38:40
CargarDatos: Caso :98
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_85_seguimiento_id,wf_paso_id from wf_caso_85_pasos a1 group by wf_caso_85_seguimiento_id,wf_paso_id order by id
)a
inner join wf_caso_85_pasos p using(id,wf_caso_85_seguimiento_id)
inner join ( select max(id) as wf_caso_85_seguimiento_id,wf_caso_85_id,wf_tarea_id from wf_caso_85_seguimiento where wf_caso_85_id =? group by wf_caso_85_id,wf_tarea_id order by wf_caso_85_id,wf_caso_85_seguimiento_id ) b using(wf_caso_85_seguimiento_id)
left join usuarios u using(core_usuario_id)
{"0":"377","id":"377","1":"189","wf_paso_id":"189","2":"439","wf_caso_85_seguimiento_id":"439","3":"11","core_usuario_id":"11","4":"2015-07-10 15:36:45","fecha_ejec":"2015-07-10 15:36:45","5":"79","dato":"79","6":"sce.t20","tabla":"sce.t20","7":"89","tarea_id":"89","8":"siti soluciones German: ciudadano, gerente","usr_ejec":"siti soluciones German: ciudadano, gerente"}
CargarDatos_189(79)
se carga 85_89_189_20_21_3278
se carga 85_89_189_20_21_3262015-07-10
{"0":"378","id":"378","1":"209","wf_paso_id":"209","2":"440","wf_caso_85_seguimiento_id":"440","3":"11","core_usuario_id":"11","4":"2015-07-10 15:37:04","fecha_ejec":"2015-07-10 15:37:04","5":"6740","dato":"6740","6":"wf_documentoentradaadj_caso","tabla":"wf_documentoentradaadj_caso","7":"95","tarea_id":"95","8":"siti soluciones German: ciudadano, gerente","usr_ejec":"siti soluciones German: ciudadano, gerente"}
CargarDatos_209(6740)
{"0":"379","id":"379","1":"234","wf_paso_id":"234","2":"441","wf_caso_85_seguimiento_id":"441","3":"11","core_usuario_id":"11","4":"2015-07-10 15:37:05","fecha_ejec":"2015-07-10 15:37:05","5":null,"dato":null,"6":null,"tabla":null,"7":"127","tarea_id":"127","8":"siti soluciones German: ciudadano, gerente","usr_ejec":"siti soluciones German: ciudadano, gerente"}
CargarDatos_234()
{"0":"380","id":"380","1":"226","wf_paso_id":"226","2":"442","wf_caso_85_seguimiento_id":"442","3":"11","core_usuario_id":"11","4":"2015-07-10 15:37:10","fecha_ejec":"2015-07-10 15:37:10","5":"2633","dato":"2633","6":"wf_documentoentradaadj_caso","tabla":"wf_documentoentradaadj_caso","7":"113","tarea_id":"113","8":"siti soluciones German: ciudadano, gerente","usr_ejec":"siti soluciones German: ciudadano, gerente"}
CargarDatos_226(2633)
{"0":"381","id":"381","1":"235","wf_paso_id":"235","2":"443","wf_caso_85_seguimiento_id":"443","3":"11","core_usuario_id":"11","4":"2015-07-10 15:37:16","fecha_ejec":"2015-07-10 15:37:16","5":null,"dato":null,"6":null,"tabla":null,"7":"128","tarea_id":"128","8":"siti soluciones German: ciudadano, gerente","usr_ejec":"siti soluciones German: ciudadano, gerente"}
CargarDatos_235()
{"0":"382","id":"382","1":"275","wf_paso_id":"275","2":"444","wf_caso_85_seguimiento_id":"444","3":"11","core_usuario_id":"11","4":"2015-07-10 15:37:19","fecha_ejec":"2015-07-10 15:37:19","5":"18","dato":"18","6":"sce.t26","tabla":"sce.t26","7":"160","tarea_id":"160","8":"siti soluciones German: ciudadano, gerente","usr_ejec":"siti soluciones German: ciudadano, gerente"}
CargarDatos_275(18)
se carga 85_160_275_26_27_409
se carga 85_160_275_26_27_4081
{"0":"383","id":"383","1":"237","wf_paso_id":"237","2":"445","wf_caso_85_seguimiento_id":"445","3":"11","core_usuario_id":"11","4":"2015-07-10 15:38:18","fecha_ejec":"2015-07-10 15:38:18","5":"6","dato":"6","6":"sce.t21","tabla":"sce.t21","7":"129","tarea_id":"129","8":"siti soluciones German: ciudadano, gerente","usr_ejec":"siti soluciones German: ciudadano, gerente"}
CargarDatos_237(6)
se carga 85_129_237_21_22_406213
se carga 85_129_237_21_22_405132
se carga 85_129_237_21_22_4040
se carga 85_129_237_21_22_4032500
se carga 85_129_237_21_22_4022012
se carga 85_129_237_21_22_401sdasd
se carga 85_129_237_21_22_400DFGDSF
se carga 85_129_237_21_22_3992015-07-17
se carga 85_129_237_21_22_3981221
se carga 85_129_237_21_22_3291231
se carga 85_129_237_21_22_328123
{"0":"384","id":"384","1":"257","wf_paso_id":"257","2":"445","wf_caso_85_seguimiento_id":"445","3":"11","core_usuario_id":"11","4":"2015-07-10 15:38:35","fecha_ejec":"2015-07-10 15:38:35","5":"153","dato":"153","6":"core_upload","tabla":"core_upload","7":"129","tarea_id":"129","8":"siti soluciones German: ciudadano, gerente","usr_ejec":"siti soluciones German: ciudadano, gerente"}
CargarDatos_257(153)
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_85_seguimiento a
inner join (
select max(b0.id) as id,b0.wf_caso_85_id,b0.wf_tarea_id from wf_caso_85_seguimiento b0 where b0.wf_caso_85_id =? group by b0.wf_caso_85_id,b0.wf_tarea_id order by wf_caso_85_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":"439","id":"439","1":"98","wf_caso_85_id":"98","2":"89","wf_tarea_id":"89","3":null,"core_usuario_id":null,"4":"2015-07-10 15:35:48","fec_asig":"2015-07-10 15:35:48","5":"11","core_usuario_id_resol":"11","6":"2015-07-10 15:36:45","fec_resol":"2015-07-10 15:36:45","7":"89","wf_tarea_id_sig":"89","8":null,"usr_asig":null,"9":"siti soluciones German: ciudadano, gerente","usr_resol":"siti soluciones German: ciudadano, gerente"}
{"0":"440","id":"440","1":"98","wf_caso_85_id":"98","2":"95","wf_tarea_id":"95","3":"11","core_usuario_id":"11","4":"2015-07-10 15:36:45","fec_asig":"2015-07-10 15:36:45","5":"11","core_usuario_id_resol":"11","6":"2015-07-10 15:37:04","fec_resol":"2015-07-10 15:37:04","7":"95","wf_tarea_id_sig":"95","8":"siti soluciones German: ciudadano, gerente","usr_asig":"siti soluciones German: ciudadano, gerente","9":"siti soluciones German: ciudadano, gerente","usr_resol":"siti soluciones German: ciudadano, gerente"}
{"0":"441","id":"441","1":"98","wf_caso_85_id":"98","2":"127","wf_tarea_id":"127","3":"11","core_usuario_id":"11","4":"2015-07-10 15:37:04","fec_asig":"2015-07-10 15:37:04","5":"11","core_usuario_id_resol":"11","6":"2015-07-10 15:37:05","fec_resol":"2015-07-10 15:37:05","7":"127","wf_tarea_id_sig":"127","8":"siti soluciones German: ciudadano, gerente","usr_asig":"siti soluciones German: ciudadano, gerente","9":"siti soluciones German: ciudadano, gerente","usr_resol":"siti soluciones German: ciudadano, gerente"}
{"0":"442","id":"442","1":"98","wf_caso_85_id":"98","2":"113","wf_tarea_id":"113","3":"11","core_usuario_id":"11","4":"2015-07-10 15:37:05","fec_asig":"2015-07-10 15:37:05","5":"11","core_usuario_id_resol":"11","6":"2015-07-10 15:37:10","fec_resol":"2015-07-10 15:37:10","7":"113","wf_tarea_id_sig":"113","8":"siti soluciones German: ciudadano, gerente","usr_asig":"siti soluciones German: ciudadano, gerente","9":"siti soluciones German: ciudadano, gerente","usr_resol":"siti soluciones German: ciudadano, gerente"}
{"0":"443","id":"443","1":"98","wf_caso_85_id":"98","2":"128","wf_tarea_id":"128","3":"11","core_usuario_id":"11","4":"2015-07-10 15:37:10","fec_asig":"2015-07-10 15:37:10","5":"11","core_usuario_id_resol":"11","6":"2015-07-10 15:37:16","fec_resol":"2015-07-10 15:37:16","7":"128","wf_tarea_id_sig":"128","8":"siti soluciones German: ciudadano, gerente","usr_asig":"siti soluciones German: ciudadano, gerente","9":"siti soluciones German: ciudadano, gerente","usr_resol":"siti soluciones German: ciudadano, gerente"}
{"0":"444","id":"444","1":"98","wf_caso_85_id":"98","2":"160","wf_tarea_id":"160","3":"11","core_usuario_id":"11","4":"2015-07-10 15:37:16","fec_asig":"2015-07-10 15:37:16","5":"11","core_usuario_id_resol":"11","6":"2015-07-10 15:37:19","fec_resol":"2015-07-10 15:37:19","7":"160","wf_tarea_id_sig":"160","8":"siti soluciones German: ciudadano, gerente","usr_asig":"siti soluciones German: ciudadano, gerente","9":"siti soluciones German: ciudadano, gerente","usr_resol":"siti soluciones German: ciudadano, gerente"}
{"0":"445","id":"445","1":"98","wf_caso_85_id":"98","2":"129","wf_tarea_id":"129","3":"11","core_usuario_id":"11","4":"2015-07-10 15:37:19","fec_asig":"2015-07-10 15:37:19","5":"11","core_usuario_id_resol":"11","6":"2015-07-10 15:38:35","fec_resol":"2015-07-10 15:38:35","7":"129","wf_tarea_id_sig":"129","8":"siti soluciones German: ciudadano, gerente","usr_asig":"siti soluciones German: ciudadano, gerente","9":"siti soluciones German: ciudadano, gerente","usr_resol":"siti soluciones German: ciudadano, gerente"}
{"0":"446","id":"446","1":"98","wf_caso_85_id":"98","2":"131","wf_tarea_id":"131","3":"11","core_usuario_id":"11","4":"2015-07-10 15:38:35","fec_asig":"2015-07-10 15:38:35","5":null,"core_usuario_id_resol":null,"6":null,"fec_resol":null,"7":"131","wf_tarea_id_sig":"131","8":"siti soluciones German: ciudadano, gerente","usr_asig":"siti soluciones German: ciudadano, gerente","9":null,"usr_resol":null}
2015-07 10 15:38:40
cargar datos del sujeto(,,s,85,98)
select s.*, m.nombre as nom_muni, c.nom_cat,fec_caso
from wf_caso_85 w
inner join core_sujetoverificacion s on w.id=98 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:38:40
tabla dat adic
select tabla from core_sujetoverificaciontipo where id=1
2015-07 10 15:38:40
tabla :persona
SELECT * FROM persona where id=3
2015-07 10 15:38:40
Continuar(s,131,236,)
EjecutarTarea_131() certificado exitoso id_comp1223
11 11
ValidarUsuario(131):1
EjecutarPaso_236: corr:72 , caso=98 id_comp 1223
Paso::Guardar(Caso:98)
rta: 1 dato: tabla:
CasoPaso:385
CargarDatos_236()
SiguientePasoDe236: Funcion para ejecutar el siguiente paso
TerminarTarea(131,)
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_1223').funcionInicial('n');
)
fin 2015-07-10 15:38:40
/******************************************************************************************************/