2015-06 30 17:21:53
Nuevo(58,1)
Caso :66
2015-06 30 17:21:53
cargar datos del sujeto(,,s,87,66)
select s.*, m.nombre as nom_muni, c.nom_cat,fec_caso
from wf_caso_87 w
inner join core_sujetoverificacion s on w.id=66 AND s.id =w.core_sujetoverificacion_id
inner join plan_municipio m on s.plan_municipio_id=m.id
inner join core_sujetocategoria c on s.core_sujetocategoria_id=c.id
2015-06 30 17:21:53
tabla dat adic
select tabla from core_sujetoverificaciontipo where id=1
2015-06 30 17:21:53
tabla :persona
SELECT * FROM persona where id=58
CasoSeguimiento :233
EjecutarTarea_162() Tipo fromulario id_comp1229
28
ValidarUsuario(162):1
EjecutarPaso_277: form:33 , caso=66 id_comp 1229
Mostrar form
fin 2015-06-30 17:21:53
/******************************************************************************************************/
2015-06-30 17:21:53TraerCaso(66,87,)
CargarCaso :66
2015-06 30 17:21:53
CargarDatos: Caso :66
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_87_seguimiento_id,wf_paso_id from wf_caso_87_pasos a1 group by wf_caso_87_seguimiento_id,wf_paso_id order by id
)a
inner join wf_caso_87_pasos p using(id,wf_caso_87_seguimiento_id)
inner join ( select max(id) as wf_caso_87_seguimiento_id,wf_caso_87_id,wf_tarea_id from wf_caso_87_seguimiento where wf_caso_87_id =? group by wf_caso_87_id,wf_tarea_id order by wf_caso_87_id,wf_caso_87_seguimiento_id ) b using(wf_caso_87_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_87_seguimiento a
inner join (
select max(b0.id) as id,b0.wf_caso_87_id,b0.wf_tarea_id from wf_caso_87_seguimiento b0 where b0.wf_caso_87_id =? group by b0.wf_caso_87_id,b0.wf_tarea_id order by wf_caso_87_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":"233","id":"233","1":"66","wf_caso_87_id":"66","2":"162","wf_tarea_id":"162","3":null,"core_usuario_id":null,"4":"2015-06-30 17:21:53","fec_asig":"2015-06-30 17:21:53","5":null,"core_usuario_id_resol":null,"6":null,"fec_resol":null,"7":"162","wf_tarea_id_sig":"162","8":null,"usr_asig":null,"9":null,"usr_resol":null}
2015-06 30 17:21:53
cargar datos del sujeto(,,s,87,66)
select s.*, m.nombre as nom_muni, c.nom_cat,fec_caso
from wf_caso_87 w
inner join core_sujetoverificacion s on w.id=66 AND s.id =w.core_sujetoverificacion_id
inner join plan_municipio m on s.plan_municipio_id=m.id
inner join core_sujetocategoria c on s.core_sujetocategoria_id=c.id
2015-06 30 17:21:53
tabla dat adic
select tabla from core_sujetoverificaciontipo where id=1
2015-06 30 17:21:53
tabla :persona
SELECT * FROM persona where id=58
fin 2015-06-30 17:21:53
/******************************************************************************************************/
2015-06-30 17:21:56TraerCaso(66,87,)
CargarCaso :66
2015-06 30 17:21:56
CargarDatos: Caso :66
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_87_seguimiento_id,wf_paso_id from wf_caso_87_pasos a1 group by wf_caso_87_seguimiento_id,wf_paso_id order by id
)a
inner join wf_caso_87_pasos p using(id,wf_caso_87_seguimiento_id)
inner join ( select max(id) as wf_caso_87_seguimiento_id,wf_caso_87_id,wf_tarea_id from wf_caso_87_seguimiento where wf_caso_87_id =? group by wf_caso_87_id,wf_tarea_id order by wf_caso_87_id,wf_caso_87_seguimiento_id ) b using(wf_caso_87_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_87_seguimiento a
inner join (
select max(b0.id) as id,b0.wf_caso_87_id,b0.wf_tarea_id from wf_caso_87_seguimiento b0 where b0.wf_caso_87_id =? group by b0.wf_caso_87_id,b0.wf_tarea_id order by wf_caso_87_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":"233","id":"233","1":"66","wf_caso_87_id":"66","2":"162","wf_tarea_id":"162","3":null,"core_usuario_id":null,"4":"2015-06-30 17:21:53","fec_asig":"2015-06-30 17:21:53","5":null,"core_usuario_id_resol":null,"6":null,"fec_resol":null,"7":"162","wf_tarea_id_sig":"162","8":null,"usr_asig":null,"9":null,"usr_resol":null}
2015-06 30 17:21:56
cargar datos del sujeto(,,s,87,66)
select s.*, m.nombre as nom_muni, c.nom_cat,fec_caso
from wf_caso_87 w
inner join core_sujetoverificacion s on w.id=66 AND s.id =w.core_sujetoverificacion_id
inner join plan_municipio m on s.plan_municipio_id=m.id
inner join core_sujetocategoria c on s.core_sujetocategoria_id=c.id
2015-06 30 17:21:56
tabla dat adic
select tabla from core_sujetoverificaciontipo where id=1
2015-06 30 17:21:56
tabla :persona
SELECT * FROM persona where id=58
2015-06 30 17:21:56
Continuar(s,162,277,)
EjecutarTarea_162() Tipo fromulario id_comp1229
28
ValidarUsuario(162):1
EjecutarPaso_277: form:33 , caso=66 id_comp 1229
Paso::Guardar(Caso:66)
Datos a guardar:
Array
(
[wf_proceso_id] => 87
[wf_paso_id] => 277
[wf_tarea_id] => 162
[wf_caso_id] => 66
[id] => 1229
[accion] => nextPaso
[reg] => s
[rta] => n
[cod_formulario2] => 33
[id_periodo] => 2015
[obs_ingreso] =>
[cod_bloque] => 34
[oid] =>
[oid_maestro] =>
[451] => 2
)
OID: 65
rta: 1 dato:65 tabla:sce.t33
CasoPaso:256
CargarDatos_277(65)
se carga 87_162_277_33_34_4512
SiguientePasoDe277: Funcion para ejecutar el siguiente paso
Condicion Tarea : 2 ==1
Condicion Tarea : 2 ==2
TerminarTarea(162,164)
Ultimo seg :233
Ultimo seg :234
EjecutarTarea_164() Concurso silvio leon españa id_comp1229
28 28
ValidarUsuario(164):1
EjecutarPaso_279: form:32 , caso=66 id_comp 1229
Mostrar form
Retorno :
Array
(
[ret] => Ext.getCmp('comp_1229').removeAll();Ext.getCmp('comp_1229').add(new Ext.form.FormPanel({ title: 'Ingreso de datos' ,padding: 10,id:'frm_formulario_87_66',autoScroll:true ,labelAlign:'top',defaults: { anchor: '97%'} ,items: [new Ext.form.Hidden({name:'cod_formulario2',value:'32'}) ,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:'33'}) ,new Ext.form.Hidden({name :'oid',value:''}) ,new Ext.form.Hidden({name :'oid_maestro',value:''}) ,new Ext.form.Hidden({ value:'2015-06-30', id:'448'}),{value:'',xtype:'textfield' , maxLength:120,autoCreate:{ tag:'input',maxlength:'120'} ,allowBlank:false,id:'449',fieldLabel:'* Titulo del proyecto' },{ xtype:'hidden',id:'hds450',disabled:true},new Ext.form.ComboBox({typeAhead:true,listeners:{ select:function(){xajax_comprobar_campoOcultoSelect(this.getValue(),450);if(this.getValue()==5){Ext.getCmp('452').setDisabled(false);}else{Ext.getCmp('452').setDisabled(true);Ext.getCmp('452').setValue('');}},afterrender:function(){ xajax_comprobar_campoOcultoSelect(this.getValue(),450); }},/*fin introducir listener para campos ocultos*/triggerAction:'all',mode:'local',editable:false,emptyText:'Seleccione una opción',store:new Ext.data.ArrayStore({fields:['id', 'value'],data:[[1,'Radio'],[2,'Prensa escrita'],[3,'Reportaje grafico'],[4,'Televisión'],[5,'Periodismo digital'],[6,'Caricatura'] ]}),valueField:'id',displayField:'value',id:'inp_select_33_450',allowBlank:false,fieldLabel:'* CategorÃa',hiddenName:'450'}),{value:'',xtype:'textfield' , maxLength:120,autoCreate:{ tag:'input',maxlength:'120'} ,allowBlank:false,id:'452',fieldLabel:'* Vinculo de internet',disabled:true } ] ,prepararGrids:function(){/*buscar editorgrid - grilla id compuesto, id real, mas id formulario esclavo, separado _*/var grillasF=this.findByType('editorgrid');if(grillasF && grillasF!=''){for (i=0; i < grillasF.length; i++){var xstore=grillasF[i].getStore();if(xstore.getCount()>0){var data=new Array();var xxid=grillasF[i].getId().split('_');for (j=0; j < xstore.getCount(); j++){var xreco = xstore.getAt(j); var cont_dat_vac=0,cont_tot_vac=0; for(var elem in xreco.data){cont_tot_vac++;if( xreco.data[elem] ==null || xreco.data[elem]=='' ){cont_dat_vac++;}} if(cont_dat_vac < cont_tot_vac){data[data.length]=xreco.data;data[data.length-1]['form_master_escribir_xxx']=xxid[1];}}var xfinalfin=Ext.encode(data);Ext.getCmp(xxid[0]).setValue(xfinalfin);}}}/*grabar stores en hiddens*/},tbar:[{text:'Guardar',iconCls: 'icon-disk',handler: function(){ var form = Ext.getCmp('frm_formulario_87_66'); 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:'87',wf_paso_id:'279',wf_tarea_id:'164',wf_caso_id:'66',id:'1229',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', 'No hay comunicacion con el servidor');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_87_66').getForm().loadRecord(new Ext.data.Record({"cod_formulario":32,"oid_maestro":null,"cod_bloque":33,"449":null,"452":null})); llamadaAJAX({url:'http://192.168.10.116/sisad/build/view/workflow/casos/casos_datosForm.php',mostrarMsg:false,params:{accion:'verifica',wf_paso_id:'279',cod_formulario:'32',cod_bloque:'33',wf_caso_id:'{"pro":"87","cas":"66"}'}}); }catch(e){alert(e);} } } }) );Ext.getCmp('comp_1229').doLayout();
[suc] => 1
)
fin 2015-06-30 17:21:56
/******************************************************************************************************/
2015-06-30 17:21:58TraerCaso(66,87,)
CargarCaso :66
2015-06 30 17:21:58
CargarDatos: Caso :66
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_87_seguimiento_id,wf_paso_id from wf_caso_87_pasos a1 group by wf_caso_87_seguimiento_id,wf_paso_id order by id
)a
inner join wf_caso_87_pasos p using(id,wf_caso_87_seguimiento_id)
inner join ( select max(id) as wf_caso_87_seguimiento_id,wf_caso_87_id,wf_tarea_id from wf_caso_87_seguimiento where wf_caso_87_id =? group by wf_caso_87_id,wf_tarea_id order by wf_caso_87_id,wf_caso_87_seguimiento_id ) b using(wf_caso_87_seguimiento_id)
left join usuarios u using(core_usuario_id)
{"0":"256","id":"256","1":"277","wf_paso_id":"277","2":"233","wf_caso_87_seguimiento_id":"233","3":"28","core_usuario_id":"28","4":"2015-06-30 17:21:56","fecha_ejec":"2015-06-30 17:21:56","5":"65","dato":"65","6":"sce.t33","tabla":"sce.t33","7":"162","tarea_id":"162","8":"fddf trfd: ciudadano","usr_ejec":"fddf trfd: ciudadano"}
CargarDatos_277(65)
se carga 87_162_277_33_34_4512
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_87_seguimiento a
inner join (
select max(b0.id) as id,b0.wf_caso_87_id,b0.wf_tarea_id from wf_caso_87_seguimiento b0 where b0.wf_caso_87_id =? group by b0.wf_caso_87_id,b0.wf_tarea_id order by wf_caso_87_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":"233","id":"233","1":"66","wf_caso_87_id":"66","2":"162","wf_tarea_id":"162","3":null,"core_usuario_id":null,"4":"2015-06-30 17:21:53","fec_asig":"2015-06-30 17:21:53","5":"28","core_usuario_id_resol":"28","6":"2015-06-30 17:21:56","fec_resol":"2015-06-30 17:21:56","7":"162","wf_tarea_id_sig":"162","8":null,"usr_asig":null,"9":"fddf trfd: ciudadano","usr_resol":"fddf trfd: ciudadano"}
{"0":"234","id":"234","1":"66","wf_caso_87_id":"66","2":"164","wf_tarea_id":"164","3":"28","core_usuario_id":"28","4":"2015-06-30 17:21:56","fec_asig":"2015-06-30 17:21:56","5":null,"core_usuario_id_resol":null,"6":null,"fec_resol":null,"7":"164","wf_tarea_id_sig":"164","8":"fddf trfd: ciudadano","usr_asig":"fddf trfd: ciudadano","9":null,"usr_resol":null}
2015-06 30 17:21:58
cargar datos del sujeto(,,s,87,66)
select s.*, m.nombre as nom_muni, c.nom_cat,fec_caso
from wf_caso_87 w
inner join core_sujetoverificacion s on w.id=66 AND s.id =w.core_sujetoverificacion_id
inner join plan_municipio m on s.plan_municipio_id=m.id
inner join core_sujetocategoria c on s.core_sujetocategoria_id=c.id
2015-06 30 17:21:58
tabla dat adic
select tabla from core_sujetoverificaciontipo where id=1
2015-06 30 17:21:58
tabla :persona
SELECT * FROM persona where id=58
fin 2015-06-30 17:21:58
/******************************************************************************************************/
2015-06-30 17:22:27TraerCaso(66,87,)
CargarCaso :66
2015-06 30 17:22:27
CargarDatos: Caso :66
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_87_seguimiento_id,wf_paso_id from wf_caso_87_pasos a1 group by wf_caso_87_seguimiento_id,wf_paso_id order by id
)a
inner join wf_caso_87_pasos p using(id,wf_caso_87_seguimiento_id)
inner join ( select max(id) as wf_caso_87_seguimiento_id,wf_caso_87_id,wf_tarea_id from wf_caso_87_seguimiento where wf_caso_87_id =? group by wf_caso_87_id,wf_tarea_id order by wf_caso_87_id,wf_caso_87_seguimiento_id ) b using(wf_caso_87_seguimiento_id)
left join usuarios u using(core_usuario_id)
{"0":"256","id":"256","1":"277","wf_paso_id":"277","2":"233","wf_caso_87_seguimiento_id":"233","3":"28","core_usuario_id":"28","4":"2015-06-30 17:21:56","fecha_ejec":"2015-06-30 17:21:56","5":"65","dato":"65","6":"sce.t33","tabla":"sce.t33","7":"162","tarea_id":"162","8":"fddf trfd: ciudadano","usr_ejec":"fddf trfd: ciudadano"}
CargarDatos_277(65)
se carga 87_162_277_33_34_4512
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_87_seguimiento a
inner join (
select max(b0.id) as id,b0.wf_caso_87_id,b0.wf_tarea_id from wf_caso_87_seguimiento b0 where b0.wf_caso_87_id =? group by b0.wf_caso_87_id,b0.wf_tarea_id order by wf_caso_87_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":"233","id":"233","1":"66","wf_caso_87_id":"66","2":"162","wf_tarea_id":"162","3":null,"core_usuario_id":null,"4":"2015-06-30 17:21:53","fec_asig":"2015-06-30 17:21:53","5":"28","core_usuario_id_resol":"28","6":"2015-06-30 17:21:56","fec_resol":"2015-06-30 17:21:56","7":"162","wf_tarea_id_sig":"162","8":null,"usr_asig":null,"9":"fddf trfd: ciudadano","usr_resol":"fddf trfd: ciudadano"}
{"0":"234","id":"234","1":"66","wf_caso_87_id":"66","2":"164","wf_tarea_id":"164","3":"28","core_usuario_id":"28","4":"2015-06-30 17:21:56","fec_asig":"2015-06-30 17:21:56","5":null,"core_usuario_id_resol":null,"6":null,"fec_resol":null,"7":"164","wf_tarea_id_sig":"164","8":"fddf trfd: ciudadano","usr_asig":"fddf trfd: ciudadano","9":null,"usr_resol":null}
2015-06 30 17:22:27
cargar datos del sujeto(,,s,87,66)
select s.*, m.nombre as nom_muni, c.nom_cat,fec_caso
from wf_caso_87 w
inner join core_sujetoverificacion s on w.id=66 AND s.id =w.core_sujetoverificacion_id
inner join plan_municipio m on s.plan_municipio_id=m.id
inner join core_sujetocategoria c on s.core_sujetocategoria_id=c.id
2015-06 30 17:22:27
tabla dat adic
select tabla from core_sujetoverificaciontipo where id=1
2015-06 30 17:22:27
tabla :persona
SELECT * FROM persona where id=58
2015-06 30 17:22:27
Continuar(s,164,279,)
EjecutarTarea_164() Concurso silvio leon españa id_comp1229
28 28
ValidarUsuario(164):1
EjecutarPaso_279: form:32 , caso=66 id_comp 1229
Paso::Guardar(Caso:66)
Datos a guardar:
Array
(
[wf_proceso_id] => 87
[wf_paso_id] => 279
[wf_tarea_id] => 164
[wf_caso_id] => 66
[id] => 1229
[accion] => nextPaso
[reg] => s
[rta] => n
[cod_formulario2] => 32
[id_periodo] => 2015
[obs_ingreso] =>
[cod_bloque] => 33
[oid] =>
[oid_maestro] =>
[448] => 2015-06-30
[449] => gdfhfdghdfghdfgh
[450] => 5
[452] => dfghfdghfghgh
)
OID: 34
rta: 1 dato:34 tabla:sce.t32
CasoPaso:257
CargarDatos_279(34)
se carga 87_164_279_32_33_452dfghfdghfghgh
se carga 87_164_279_32_33_4505
se carga 87_164_279_32_33_449gdfhfdghdfghdfgh
se carga 87_164_279_32_33_4482015-06-30
SiguientePasoDe279: Funcion para ejecutar el siguiente paso
Condicion Tarea : 5 ==1 || 5 ==4
Condicion Tarea : 5 ==2
Condicion Tarea : 5 ==3 || 5 ==6
Condicion Tarea : 5 ==5
TerminarTarea(164,194)
Ultimo seg :234
Ultimo seg :235
EjecutarTarea_194() adjunto periodismo digital id_comp1229
28 28
ValidarUsuario(194):1
EjecutarPaso_309: corr:112 , caso=66 id_comp 1229
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:fddf
TWFSV_2:trfd
<br>Su solicitud a Inscripción a eventos culturales del concurso Silvio León España en la categorÃa de periodismo digital se realizó con éxito y se encuentra en trámite
{ WFSV_1 }
TWFSV_1:desarrollo4@siticol.com
Registro exitoso periodismo digital
Retorno :
Array
(
[ret] => inicioComponente_WF_Correo({"id":"1229","caso_id":"66","proceso_id":87,"tit":"adjunto periodismo digital","tarea_id":194,"paso_id":309,"desc":"<p>\nApreciado(a)<br>\n<strong>TRFD FDDF<\/strong>\n<p>\n<p>El presente mensaje es una notificación para el caso No <strong>66<\/strong> <\/p>\n<strong><br>Su solicitud a Inscripci\u00f3n a eventos culturales del concurso Silvio Le\u00f3n Espa\u00f1a en la categor\u00eda de periodismo digital se realiz\u00f3 con \u00e9xito y 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 periodismo digital'},\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-06-30 17:22:27
/******************************************************************************************************/
2015-06-30 17:22:29TraerCaso(66,87,)
CargarCaso :66
2015-06 30 17:22:29
CargarDatos: Caso :66
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_87_seguimiento_id,wf_paso_id from wf_caso_87_pasos a1 group by wf_caso_87_seguimiento_id,wf_paso_id order by id
)a
inner join wf_caso_87_pasos p using(id,wf_caso_87_seguimiento_id)
inner join ( select max(id) as wf_caso_87_seguimiento_id,wf_caso_87_id,wf_tarea_id from wf_caso_87_seguimiento where wf_caso_87_id =? group by wf_caso_87_id,wf_tarea_id order by wf_caso_87_id,wf_caso_87_seguimiento_id ) b using(wf_caso_87_seguimiento_id)
left join usuarios u using(core_usuario_id)
{"0":"256","id":"256","1":"277","wf_paso_id":"277","2":"233","wf_caso_87_seguimiento_id":"233","3":"28","core_usuario_id":"28","4":"2015-06-30 17:21:56","fecha_ejec":"2015-06-30 17:21:56","5":"65","dato":"65","6":"sce.t33","tabla":"sce.t33","7":"162","tarea_id":"162","8":"fddf trfd: ciudadano","usr_ejec":"fddf trfd: ciudadano"}
CargarDatos_277(65)
se carga 87_162_277_33_34_4512
{"0":"257","id":"257","1":"279","wf_paso_id":"279","2":"234","wf_caso_87_seguimiento_id":"234","3":"28","core_usuario_id":"28","4":"2015-06-30 17:22:27","fecha_ejec":"2015-06-30 17:22:27","5":"34","dato":"34","6":"sce.t32","tabla":"sce.t32","7":"164","tarea_id":"164","8":"fddf trfd: ciudadano","usr_ejec":"fddf trfd: ciudadano"}
CargarDatos_279(34)
se carga 87_164_279_32_33_452dfghfdghfghgh
se carga 87_164_279_32_33_4505
se carga 87_164_279_32_33_449gdfhfdghdfghdfgh
se carga 87_164_279_32_33_4482015-06-30
cargar datos de ejecucion de las tareas (las ultimas si el proceso tiene ciclos)
select a.*, u.apellido||' '||u.nombre|| ': '||u.cargo as usr_asig , ur.apellido||' '||ur.nombre|| ': '||ur.cargo as usr_resol from
wf_caso_87_seguimiento a
inner join (
select max(b0.id) as id,b0.wf_caso_87_id,b0.wf_tarea_id from wf_caso_87_seguimiento b0 where b0.wf_caso_87_id =? group by b0.wf_caso_87_id,b0.wf_tarea_id order by wf_caso_87_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":"233","id":"233","1":"66","wf_caso_87_id":"66","2":"162","wf_tarea_id":"162","3":null,"core_usuario_id":null,"4":"2015-06-30 17:21:53","fec_asig":"2015-06-30 17:21:53","5":"28","core_usuario_id_resol":"28","6":"2015-06-30 17:21:56","fec_resol":"2015-06-30 17:21:56","7":"162","wf_tarea_id_sig":"162","8":null,"usr_asig":null,"9":"fddf trfd: ciudadano","usr_resol":"fddf trfd: ciudadano"}
{"0":"234","id":"234","1":"66","wf_caso_87_id":"66","2":"164","wf_tarea_id":"164","3":"28","core_usuario_id":"28","4":"2015-06-30 17:21:56","fec_asig":"2015-06-30 17:21:56","5":"28","core_usuario_id_resol":"28","6":"2015-06-30 17:22:27","fec_resol":"2015-06-30 17:22:27","7":"164","wf_tarea_id_sig":"164","8":"fddf trfd: ciudadano","usr_asig":"fddf trfd: ciudadano","9":"fddf trfd: ciudadano","usr_resol":"fddf trfd: ciudadano"}
{"0":"235","id":"235","1":"66","wf_caso_87_id":"66","2":"194","wf_tarea_id":"194","3":"28","core_usuario_id":"28","4":"2015-06-30 17:22:27","fec_asig":"2015-06-30 17:22:27","5":null,"core_usuario_id_resol":null,"6":null,"fec_resol":null,"7":"194","wf_tarea_id_sig":"194","8":"fddf trfd: ciudadano","usr_asig":"fddf trfd: ciudadano","9":null,"usr_resol":null}
2015-06 30 17:22:29
cargar datos del sujeto(,,s,87,66)
select s.*, m.nombre as nom_muni, c.nom_cat,fec_caso
from wf_caso_87 w
inner join core_sujetoverificacion s on w.id=66 AND s.id =w.core_sujetoverificacion_id
inner join plan_municipio m on s.plan_municipio_id=m.id
inner join core_sujetocategoria c on s.core_sujetocategoria_id=c.id
2015-06 30 17:22:29
tabla dat adic
select tabla from core_sujetoverificaciontipo where id=1
2015-06 30 17:22:29
tabla :persona
SELECT * FROM persona where id=58
2015-06 30 17:22:29
Continuar(s,194,309,)
EjecutarTarea_194() adjunto periodismo digital id_comp1229
28 28
ValidarUsuario(194):1
EjecutarPaso_309: corr:112 , caso=66 id_comp 1229
Paso::Guardar(Caso:66)
rta: 1 dato: tabla:
CasoPaso:258
CargarDatos_309()
SiguientePasoDe309: Funcion para ejecutar el siguiente paso
Condicion Tarea : true
TerminarTarea(194,175)
Ultimo seg :235
Ultimo seg :236
EjecutarTarea_175() Verificacion periodismo digital id_comp1229
28
ValidarUsuario(175):
Retorno :
Array
(
[htm] =>
[suc] => 1
[ret] => crearMsg('Usted no puede ejecutar la tarea actual del proceso, Debe esperar a que un usuario con los privilegios adecuados la ejecute.','Información');Ext.getCmp('comp_1229').funcionInicial('n');
)
fin 2015-06-30 17:22:29
/******************************************************************************************************/
2015-06-30 17:22:51TraerCaso(66,87,)
CargarCaso :66
2015-06 30 17:22:51
CargarDatos: Caso :66
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_87_seguimiento_id,wf_paso_id from wf_caso_87_pasos a1 group by wf_caso_87_seguimiento_id,wf_paso_id order by id
)a
inner join wf_caso_87_pasos p using(id,wf_caso_87_seguimiento_id)
inner join ( select max(id) as wf_caso_87_seguimiento_id,wf_caso_87_id,wf_tarea_id from wf_caso_87_seguimiento where wf_caso_87_id =? group by wf_caso_87_id,wf_tarea_id order by wf_caso_87_id,wf_caso_87_seguimiento_id ) b using(wf_caso_87_seguimiento_id)
left join usuarios u using(core_usuario_id)
{"0":"256","id":"256","1":"277","wf_paso_id":"277","2":"233","wf_caso_87_seguimiento_id":"233","3":"28","core_usuario_id":"28","4":"2015-06-30 17:21:56","fecha_ejec":"2015-06-30 17:21:56","5":"65","dato":"65","6":"sce.t33","tabla":"sce.t33","7":"162","tarea_id":"162","8":"fddf trfd: ciudadano","usr_ejec":"fddf trfd: ciudadano"}
CargarDatos_277(65)
se carga 87_162_277_33_34_4512
{"0":"257","id":"257","1":"279","wf_paso_id":"279","2":"234","wf_caso_87_seguimiento_id":"234","3":"28","core_usuario_id":"28","4":"2015-06-30 17:22:27","fecha_ejec":"2015-06-30 17:22:27","5":"34","dato":"34","6":"sce.t32","tabla":"sce.t32","7":"164","tarea_id":"164","8":"fddf trfd: ciudadano","usr_ejec":"fddf trfd: ciudadano"}
CargarDatos_279(34)
se carga 87_164_279_32_33_452dfghfdghfghgh
se carga 87_164_279_32_33_4505
se carga 87_164_279_32_33_449gdfhfdghdfghdfgh
se carga 87_164_279_32_33_4482015-06-30
{"0":"258","id":"258","1":"309","wf_paso_id":"309","2":"235","wf_caso_87_seguimiento_id":"235","3":"28","core_usuario_id":"28","4":"2015-06-30 17:22:29","fecha_ejec":"2015-06-30 17:22:29","5":null,"dato":null,"6":null,"tabla":null,"7":"194","tarea_id":"194","8":"fddf trfd: ciudadano","usr_ejec":"fddf trfd: ciudadano"}
CargarDatos_309()
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_87_seguimiento a
inner join (
select max(b0.id) as id,b0.wf_caso_87_id,b0.wf_tarea_id from wf_caso_87_seguimiento b0 where b0.wf_caso_87_id =? group by b0.wf_caso_87_id,b0.wf_tarea_id order by wf_caso_87_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":"233","id":"233","1":"66","wf_caso_87_id":"66","2":"162","wf_tarea_id":"162","3":null,"core_usuario_id":null,"4":"2015-06-30 17:21:53","fec_asig":"2015-06-30 17:21:53","5":"28","core_usuario_id_resol":"28","6":"2015-06-30 17:21:56","fec_resol":"2015-06-30 17:21:56","7":"162","wf_tarea_id_sig":"162","8":null,"usr_asig":null,"9":"fddf trfd: ciudadano","usr_resol":"fddf trfd: ciudadano"}
{"0":"234","id":"234","1":"66","wf_caso_87_id":"66","2":"164","wf_tarea_id":"164","3":"28","core_usuario_id":"28","4":"2015-06-30 17:21:56","fec_asig":"2015-06-30 17:21:56","5":"28","core_usuario_id_resol":"28","6":"2015-06-30 17:22:27","fec_resol":"2015-06-30 17:22:27","7":"164","wf_tarea_id_sig":"164","8":"fddf trfd: ciudadano","usr_asig":"fddf trfd: ciudadano","9":"fddf trfd: ciudadano","usr_resol":"fddf trfd: ciudadano"}
{"0":"235","id":"235","1":"66","wf_caso_87_id":"66","2":"194","wf_tarea_id":"194","3":"28","core_usuario_id":"28","4":"2015-06-30 17:22:27","fec_asig":"2015-06-30 17:22:27","5":"28","core_usuario_id_resol":"28","6":"2015-06-30 17:22:29","fec_resol":"2015-06-30 17:22:29","7":"194","wf_tarea_id_sig":"194","8":"fddf trfd: ciudadano","usr_asig":"fddf trfd: ciudadano","9":"fddf trfd: ciudadano","usr_resol":"fddf trfd: ciudadano"}
{"0":"236","id":"236","1":"66","wf_caso_87_id":"66","2":"175","wf_tarea_id":"175","3":null,"core_usuario_id":null,"4":"2015-06-30 17:22:29","fec_asig":"2015-06-30 17:22:29","5":null,"core_usuario_id_resol":null,"6":null,"fec_resol":null,"7":"175","wf_tarea_id_sig":"175","8":null,"usr_asig":null,"9":null,"usr_resol":null}
2015-06 30 17:22:51
cargar datos del sujeto(,,s,87,66)
select s.*, m.nombre as nom_muni, c.nom_cat,fec_caso
from wf_caso_87 w
inner join core_sujetoverificacion s on w.id=66 AND s.id =w.core_sujetoverificacion_id
inner join plan_municipio m on s.plan_municipio_id=m.id
inner join core_sujetocategoria c on s.core_sujetocategoria_id=c.id
2015-06 30 17:22:51
tabla dat adic
select tabla from core_sujetoverificaciontipo where id=1
2015-06 30 17:22:51
tabla :persona
SELECT * FROM persona where id=58
2015-06 30 17:22:51
Continuar(,175,,s)
EjecutarTarea_175() Verificacion periodismo digital id_comp1232
59
ValidarUsuario(175):1
EjecutarPaso_310: form:34 , caso=66 id_comp 1232
Mostrar form
Retorno :
Array
(
[ret] => Ext.getCmp('comp_1232').removeAll();Ext.getCmp('comp_1232').add(new Ext.form.FormPanel({ title: 'Verificar información' ,padding: 10,id:'frm_formulario_87_66',autoScroll:true ,labelAlign:'top',defaults: { anchor: '97%'} ,items: [new Ext.form.Hidden({name:'cod_formulario2',value:'34'}) ,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:'35'}) ,new Ext.form.Hidden({name :'oid',value:''}) ,new Ext.form.Hidden({name :'oid_maestro',value:''}) ,new Ext.form.Label({ html:'Url',id:'453',fieldLabel:'Copiar el vinculo de internet y pegarlo en la barra de navegación'}),new Ext.form.RadioGroup({columns:2,items:[ new Ext.form.Radio({name:'454',id:'454_1',inputValue:1,boxLabel:'Si'}), new Ext.form.Radio({name:'454',id:'454_2',inputValue:2,boxLabel:'No'}) ],columns:2,allowBlank:false,fieldLabel:'* Valido',id:'454',listeners:{change:function(){var cu=Ext.getCmp('454_2').getValue();var tx=Ext.getCmp('455');if(cu){tx.setDisabled(false);}else {tx.setDisabled(true);tx.setValue('');}}}}), new Ext.form.TextArea({id:'455',allowBlank:false, fieldLabel:'* Observación',name:'455',disabled:true}) ] ,prepararGrids:function(){/*buscar editorgrid - grilla id compuesto, id real, mas id formulario esclavo, separado _*/var grillasF=this.findByType('editorgrid');if(grillasF && grillasF!=''){for (i=0; i < grillasF.length; i++){var xstore=grillasF[i].getStore();if(xstore.getCount()>0){var data=new Array();var xxid=grillasF[i].getId().split('_');for (j=0; j < xstore.getCount(); j++){var xreco = xstore.getAt(j); var cont_dat_vac=0,cont_tot_vac=0; for(var elem in xreco.data){cont_tot_vac++;if( xreco.data[elem] ==null || xreco.data[elem]=='' ){cont_dat_vac++;}} if(cont_dat_vac < cont_tot_vac){data[data.length]=xreco.data;data[data.length-1]['form_master_escribir_xxx']=xxid[1];}}var xfinalfin=Ext.encode(data);Ext.getCmp(xxid[0]).setValue(xfinalfin);}}}/*grabar stores en hiddens*/},tbar:[{text:'Guardar',iconCls: 'icon-disk',handler: function(){ var form = Ext.getCmp('frm_formulario_87_66'); 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:'87',wf_paso_id:'310',wf_tarea_id:'175',wf_caso_id:'66',id:'1232',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', 'No hay comunicacion con el servidor');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_87_66').getForm().loadRecord(new Ext.data.Record({"cod_formulario":34,"oid_maestro":null,"cod_bloque":35})); llamadaAJAX({url:'http://192.168.10.116/sisad/build/view/workflow/casos/casos_datosForm.php',mostrarMsg:false,params:{accion:'verifica',wf_paso_id:'310',cod_formulario:'34',cod_bloque:'35',wf_caso_id:'{"pro":"87","cas":"66"}'}}); }catch(e){alert(e);} } } }) );Ext.getCmp('comp_1232').doLayout();
[suc] => 1
)
fin 2015-06-30 17:22:51
/******************************************************************************************************/
2015-06-30 17:22:51TraerCaso(66,87,)
CargarCaso :66
2015-06 30 17:22:51
CargarDatos: Caso :66
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_87_seguimiento_id,wf_paso_id from wf_caso_87_pasos a1 group by wf_caso_87_seguimiento_id,wf_paso_id order by id
)a
inner join wf_caso_87_pasos p using(id,wf_caso_87_seguimiento_id)
inner join ( select max(id) as wf_caso_87_seguimiento_id,wf_caso_87_id,wf_tarea_id from wf_caso_87_seguimiento where wf_caso_87_id =? group by wf_caso_87_id,wf_tarea_id order by wf_caso_87_id,wf_caso_87_seguimiento_id ) b using(wf_caso_87_seguimiento_id)
left join usuarios u using(core_usuario_id)
{"0":"256","id":"256","1":"277","wf_paso_id":"277","2":"233","wf_caso_87_seguimiento_id":"233","3":"28","core_usuario_id":"28","4":"2015-06-30 17:21:56","fecha_ejec":"2015-06-30 17:21:56","5":"65","dato":"65","6":"sce.t33","tabla":"sce.t33","7":"162","tarea_id":"162","8":"fddf trfd: ciudadano","usr_ejec":"fddf trfd: ciudadano"}
CargarDatos_277(65)
se carga 87_162_277_33_34_4512
{"0":"257","id":"257","1":"279","wf_paso_id":"279","2":"234","wf_caso_87_seguimiento_id":"234","3":"28","core_usuario_id":"28","4":"2015-06-30 17:22:27","fecha_ejec":"2015-06-30 17:22:27","5":"34","dato":"34","6":"sce.t32","tabla":"sce.t32","7":"164","tarea_id":"164","8":"fddf trfd: ciudadano","usr_ejec":"fddf trfd: ciudadano"}
CargarDatos_279(34)
se carga 87_164_279_32_33_452dfghfdghfghgh
se carga 87_164_279_32_33_4505
se carga 87_164_279_32_33_449gdfhfdghdfghdfgh
se carga 87_164_279_32_33_4482015-06-30
{"0":"258","id":"258","1":"309","wf_paso_id":"309","2":"235","wf_caso_87_seguimiento_id":"235","3":"28","core_usuario_id":"28","4":"2015-06-30 17:22:29","fecha_ejec":"2015-06-30 17:22:29","5":null,"dato":null,"6":null,"tabla":null,"7":"194","tarea_id":"194","8":"fddf trfd: ciudadano","usr_ejec":"fddf trfd: ciudadano"}
CargarDatos_309()
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_87_seguimiento a
inner join (
select max(b0.id) as id,b0.wf_caso_87_id,b0.wf_tarea_id from wf_caso_87_seguimiento b0 where b0.wf_caso_87_id =? group by b0.wf_caso_87_id,b0.wf_tarea_id order by wf_caso_87_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":"233","id":"233","1":"66","wf_caso_87_id":"66","2":"162","wf_tarea_id":"162","3":null,"core_usuario_id":null,"4":"2015-06-30 17:21:53","fec_asig":"2015-06-30 17:21:53","5":"28","core_usuario_id_resol":"28","6":"2015-06-30 17:21:56","fec_resol":"2015-06-30 17:21:56","7":"162","wf_tarea_id_sig":"162","8":null,"usr_asig":null,"9":"fddf trfd: ciudadano","usr_resol":"fddf trfd: ciudadano"}
{"0":"234","id":"234","1":"66","wf_caso_87_id":"66","2":"164","wf_tarea_id":"164","3":"28","core_usuario_id":"28","4":"2015-06-30 17:21:56","fec_asig":"2015-06-30 17:21:56","5":"28","core_usuario_id_resol":"28","6":"2015-06-30 17:22:27","fec_resol":"2015-06-30 17:22:27","7":"164","wf_tarea_id_sig":"164","8":"fddf trfd: ciudadano","usr_asig":"fddf trfd: ciudadano","9":"fddf trfd: ciudadano","usr_resol":"fddf trfd: ciudadano"}
{"0":"235","id":"235","1":"66","wf_caso_87_id":"66","2":"194","wf_tarea_id":"194","3":"28","core_usuario_id":"28","4":"2015-06-30 17:22:27","fec_asig":"2015-06-30 17:22:27","5":"28","core_usuario_id_resol":"28","6":"2015-06-30 17:22:29","fec_resol":"2015-06-30 17:22:29","7":"194","wf_tarea_id_sig":"194","8":"fddf trfd: ciudadano","usr_asig":"fddf trfd: ciudadano","9":"fddf trfd: ciudadano","usr_resol":"fddf trfd: ciudadano"}
{"0":"236","id":"236","1":"66","wf_caso_87_id":"66","2":"175","wf_tarea_id":"175","3":null,"core_usuario_id":null,"4":"2015-06-30 17:22:29","fec_asig":"2015-06-30 17:22:29","5":null,"core_usuario_id_resol":null,"6":null,"fec_resol":null,"7":"175","wf_tarea_id_sig":"175","8":null,"usr_asig":null,"9":null,"usr_resol":null}
2015-06 30 17:22:51
cargar datos del sujeto(,,s,87,66)
select s.*, m.nombre as nom_muni, c.nom_cat,fec_caso
from wf_caso_87 w
inner join core_sujetoverificacion s on w.id=66 AND s.id =w.core_sujetoverificacion_id
inner join plan_municipio m on s.plan_municipio_id=m.id
inner join core_sujetocategoria c on s.core_sujetocategoria_id=c.id
2015-06 30 17:22:51
tabla dat adic
select tabla from core_sujetoverificaciontipo where id=1
2015-06 30 17:22:51
tabla :persona
SELECT * FROM persona where id=58
fin 2015-06-30 17:22:51
/******************************************************************************************************/
2015-06-30 17:25:31TraerCaso(66,87,)
CargarCaso :66
2015-06 30 17:25:31
CargarDatos: Caso :66
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_87_seguimiento_id,wf_paso_id from wf_caso_87_pasos a1 group by wf_caso_87_seguimiento_id,wf_paso_id order by id
)a
inner join wf_caso_87_pasos p using(id,wf_caso_87_seguimiento_id)
inner join ( select max(id) as wf_caso_87_seguimiento_id,wf_caso_87_id,wf_tarea_id from wf_caso_87_seguimiento where wf_caso_87_id =? group by wf_caso_87_id,wf_tarea_id order by wf_caso_87_id,wf_caso_87_seguimiento_id ) b using(wf_caso_87_seguimiento_id)
left join usuarios u using(core_usuario_id)
{"0":"256","id":"256","1":"277","wf_paso_id":"277","2":"233","wf_caso_87_seguimiento_id":"233","3":"28","core_usuario_id":"28","4":"2015-06-30 17:21:56","fecha_ejec":"2015-06-30 17:21:56","5":"65","dato":"65","6":"sce.t33","tabla":"sce.t33","7":"162","tarea_id":"162","8":"fddf trfd: ciudadano","usr_ejec":"fddf trfd: ciudadano"}
CargarDatos_277(65)
se carga 87_162_277_33_34_4512
{"0":"257","id":"257","1":"279","wf_paso_id":"279","2":"234","wf_caso_87_seguimiento_id":"234","3":"28","core_usuario_id":"28","4":"2015-06-30 17:22:27","fecha_ejec":"2015-06-30 17:22:27","5":"34","dato":"34","6":"sce.t32","tabla":"sce.t32","7":"164","tarea_id":"164","8":"fddf trfd: ciudadano","usr_ejec":"fddf trfd: ciudadano"}
CargarDatos_279(34)
se carga 87_164_279_32_33_452dfghfdghfghgh
se carga 87_164_279_32_33_4505
se carga 87_164_279_32_33_449gdfhfdghdfghdfgh
se carga 87_164_279_32_33_4482015-06-30
{"0":"258","id":"258","1":"309","wf_paso_id":"309","2":"235","wf_caso_87_seguimiento_id":"235","3":"28","core_usuario_id":"28","4":"2015-06-30 17:22:29","fecha_ejec":"2015-06-30 17:22:29","5":null,"dato":null,"6":null,"tabla":null,"7":"194","tarea_id":"194","8":"fddf trfd: ciudadano","usr_ejec":"fddf trfd: ciudadano"}
CargarDatos_309()
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_87_seguimiento a
inner join (
select max(b0.id) as id,b0.wf_caso_87_id,b0.wf_tarea_id from wf_caso_87_seguimiento b0 where b0.wf_caso_87_id =? group by b0.wf_caso_87_id,b0.wf_tarea_id order by wf_caso_87_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":"233","id":"233","1":"66","wf_caso_87_id":"66","2":"162","wf_tarea_id":"162","3":null,"core_usuario_id":null,"4":"2015-06-30 17:21:53","fec_asig":"2015-06-30 17:21:53","5":"28","core_usuario_id_resol":"28","6":"2015-06-30 17:21:56","fec_resol":"2015-06-30 17:21:56","7":"162","wf_tarea_id_sig":"162","8":null,"usr_asig":null,"9":"fddf trfd: ciudadano","usr_resol":"fddf trfd: ciudadano"}
{"0":"234","id":"234","1":"66","wf_caso_87_id":"66","2":"164","wf_tarea_id":"164","3":"28","core_usuario_id":"28","4":"2015-06-30 17:21:56","fec_asig":"2015-06-30 17:21:56","5":"28","core_usuario_id_resol":"28","6":"2015-06-30 17:22:27","fec_resol":"2015-06-30 17:22:27","7":"164","wf_tarea_id_sig":"164","8":"fddf trfd: ciudadano","usr_asig":"fddf trfd: ciudadano","9":"fddf trfd: ciudadano","usr_resol":"fddf trfd: ciudadano"}
{"0":"235","id":"235","1":"66","wf_caso_87_id":"66","2":"194","wf_tarea_id":"194","3":"28","core_usuario_id":"28","4":"2015-06-30 17:22:27","fec_asig":"2015-06-30 17:22:27","5":"28","core_usuario_id_resol":"28","6":"2015-06-30 17:22:29","fec_resol":"2015-06-30 17:22:29","7":"194","wf_tarea_id_sig":"194","8":"fddf trfd: ciudadano","usr_asig":"fddf trfd: ciudadano","9":"fddf trfd: ciudadano","usr_resol":"fddf trfd: ciudadano"}
{"0":"236","id":"236","1":"66","wf_caso_87_id":"66","2":"175","wf_tarea_id":"175","3":null,"core_usuario_id":null,"4":"2015-06-30 17:22:29","fec_asig":"2015-06-30 17:22:29","5":null,"core_usuario_id_resol":null,"6":null,"fec_resol":null,"7":"175","wf_tarea_id_sig":"175","8":null,"usr_asig":null,"9":null,"usr_resol":null}
2015-06 30 17:25:31
cargar datos del sujeto(,,s,87,66)
select s.*, m.nombre as nom_muni, c.nom_cat,fec_caso
from wf_caso_87 w
inner join core_sujetoverificacion s on w.id=66 AND s.id =w.core_sujetoverificacion_id
inner join plan_municipio m on s.plan_municipio_id=m.id
inner join core_sujetocategoria c on s.core_sujetocategoria_id=c.id
2015-06 30 17:25:31
tabla dat adic
select tabla from core_sujetoverificaciontipo where id=1
2015-06 30 17:25:31
tabla :persona
SELECT * FROM persona where id=58
2015-06 30 17:25:31
Continuar(,175,,s)
EjecutarTarea_175() Verificacion periodismo digital id_comp1232
59
ValidarUsuario(175):1
EjecutarPaso_310: form:34 , caso=66 id_comp 1232
Mostrar form
Retorno :
Array
(
[ret] => Ext.getCmp('comp_1232').removeAll();Ext.getCmp('comp_1232').add(new Ext.form.FormPanel({ title: 'Verificar información' ,padding: 10,id:'frm_formulario_87_66',autoScroll:true ,labelAlign:'top',defaults: { anchor: '97%'} ,items: [new Ext.form.Hidden({name:'cod_formulario2',value:'34'}) ,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:'35'}) ,new Ext.form.Hidden({name :'oid',value:''}) ,new Ext.form.Hidden({name :'oid_maestro',value:''}) ,new Ext.form.Label({ html:'Url',id:'453',fieldLabel:'Copiar el vinculo de internet y pegarlo en la barra de navegación'}),new Ext.form.RadioGroup({columns:2,items:[ new Ext.form.Radio({name:'454',id:'454_1',inputValue:1,boxLabel:'Si'}), new Ext.form.Radio({name:'454',id:'454_2',inputValue:2,boxLabel:'No'}) ],columns:2,allowBlank:false,fieldLabel:'* Valido',id:'454',listeners:{change:function(){var cu=Ext.getCmp('454_2').getValue();var tx=Ext.getCmp('455');if(cu){tx.setDisabled(false);}else {tx.setDisabled(true);tx.setValue('');}}}}), new Ext.form.TextArea({id:'455',allowBlank:false, fieldLabel:'* Observación',name:'455',disabled:true}) ] ,prepararGrids:function(){/*buscar editorgrid - grilla id compuesto, id real, mas id formulario esclavo, separado _*/var grillasF=this.findByType('editorgrid');if(grillasF && grillasF!=''){for (i=0; i < grillasF.length; i++){var xstore=grillasF[i].getStore();if(xstore.getCount()>0){var data=new Array();var xxid=grillasF[i].getId().split('_');for (j=0; j < xstore.getCount(); j++){var xreco = xstore.getAt(j); var cont_dat_vac=0,cont_tot_vac=0; for(var elem in xreco.data){cont_tot_vac++;if( xreco.data[elem] ==null || xreco.data[elem]=='' ){cont_dat_vac++;}} if(cont_dat_vac < cont_tot_vac){data[data.length]=xreco.data;data[data.length-1]['form_master_escribir_xxx']=xxid[1];}}var xfinalfin=Ext.encode(data);Ext.getCmp(xxid[0]).setValue(xfinalfin);}}}/*grabar stores en hiddens*/},tbar:[{text:'Guardar',iconCls: 'icon-disk',handler: function(){ var form = Ext.getCmp('frm_formulario_87_66'); 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:'87',wf_paso_id:'310',wf_tarea_id:'175',wf_caso_id:'66',id:'1232',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', 'No hay comunicacion con el servidor');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_87_66').getForm().loadRecord(new Ext.data.Record({"cod_formulario":34,"oid_maestro":null,"cod_bloque":35})); llamadaAJAX({url:'http://192.168.10.116/sisad/build/view/workflow/casos/casos_datosForm.php',mostrarMsg:false,params:{accion:'verifica',wf_paso_id:'310',cod_formulario:'34',cod_bloque:'35',wf_caso_id:'{"pro":"87","cas":"66"}'}}); }catch(e){alert(e);} } } }) );Ext.getCmp('comp_1232').doLayout();
[suc] => 1
)
fin 2015-06-30 17:25:31
/******************************************************************************************************/
2015-06-30 17:25:31TraerCaso(66,87,)
CargarCaso :66
2015-06 30 17:25:31
CargarDatos: Caso :66
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_87_seguimiento_id,wf_paso_id from wf_caso_87_pasos a1 group by wf_caso_87_seguimiento_id,wf_paso_id order by id
)a
inner join wf_caso_87_pasos p using(id,wf_caso_87_seguimiento_id)
inner join ( select max(id) as wf_caso_87_seguimiento_id,wf_caso_87_id,wf_tarea_id from wf_caso_87_seguimiento where wf_caso_87_id =? group by wf_caso_87_id,wf_tarea_id order by wf_caso_87_id,wf_caso_87_seguimiento_id ) b using(wf_caso_87_seguimiento_id)
left join usuarios u using(core_usuario_id)
{"0":"256","id":"256","1":"277","wf_paso_id":"277","2":"233","wf_caso_87_seguimiento_id":"233","3":"28","core_usuario_id":"28","4":"2015-06-30 17:21:56","fecha_ejec":"2015-06-30 17:21:56","5":"65","dato":"65","6":"sce.t33","tabla":"sce.t33","7":"162","tarea_id":"162","8":"fddf trfd: ciudadano","usr_ejec":"fddf trfd: ciudadano"}
CargarDatos_277(65)
se carga 87_162_277_33_34_4512
{"0":"257","id":"257","1":"279","wf_paso_id":"279","2":"234","wf_caso_87_seguimiento_id":"234","3":"28","core_usuario_id":"28","4":"2015-06-30 17:22:27","fecha_ejec":"2015-06-30 17:22:27","5":"34","dato":"34","6":"sce.t32","tabla":"sce.t32","7":"164","tarea_id":"164","8":"fddf trfd: ciudadano","usr_ejec":"fddf trfd: ciudadano"}
CargarDatos_279(34)
se carga 87_164_279_32_33_452dfghfdghfghgh
se carga 87_164_279_32_33_4505
se carga 87_164_279_32_33_449gdfhfdghdfghdfgh
se carga 87_164_279_32_33_4482015-06-30
{"0":"258","id":"258","1":"309","wf_paso_id":"309","2":"235","wf_caso_87_seguimiento_id":"235","3":"28","core_usuario_id":"28","4":"2015-06-30 17:22:29","fecha_ejec":"2015-06-30 17:22:29","5":null,"dato":null,"6":null,"tabla":null,"7":"194","tarea_id":"194","8":"fddf trfd: ciudadano","usr_ejec":"fddf trfd: ciudadano"}
CargarDatos_309()
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_87_seguimiento a
inner join (
select max(b0.id) as id,b0.wf_caso_87_id,b0.wf_tarea_id from wf_caso_87_seguimiento b0 where b0.wf_caso_87_id =? group by b0.wf_caso_87_id,b0.wf_tarea_id order by wf_caso_87_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":"233","id":"233","1":"66","wf_caso_87_id":"66","2":"162","wf_tarea_id":"162","3":null,"core_usuario_id":null,"4":"2015-06-30 17:21:53","fec_asig":"2015-06-30 17:21:53","5":"28","core_usuario_id_resol":"28","6":"2015-06-30 17:21:56","fec_resol":"2015-06-30 17:21:56","7":"162","wf_tarea_id_sig":"162","8":null,"usr_asig":null,"9":"fddf trfd: ciudadano","usr_resol":"fddf trfd: ciudadano"}
{"0":"234","id":"234","1":"66","wf_caso_87_id":"66","2":"164","wf_tarea_id":"164","3":"28","core_usuario_id":"28","4":"2015-06-30 17:21:56","fec_asig":"2015-06-30 17:21:56","5":"28","core_usuario_id_resol":"28","6":"2015-06-30 17:22:27","fec_resol":"2015-06-30 17:22:27","7":"164","wf_tarea_id_sig":"164","8":"fddf trfd: ciudadano","usr_asig":"fddf trfd: ciudadano","9":"fddf trfd: ciudadano","usr_resol":"fddf trfd: ciudadano"}
{"0":"235","id":"235","1":"66","wf_caso_87_id":"66","2":"194","wf_tarea_id":"194","3":"28","core_usuario_id":"28","4":"2015-06-30 17:22:27","fec_asig":"2015-06-30 17:22:27","5":"28","core_usuario_id_resol":"28","6":"2015-06-30 17:22:29","fec_resol":"2015-06-30 17:22:29","7":"194","wf_tarea_id_sig":"194","8":"fddf trfd: ciudadano","usr_asig":"fddf trfd: ciudadano","9":"fddf trfd: ciudadano","usr_resol":"fddf trfd: ciudadano"}
{"0":"236","id":"236","1":"66","wf_caso_87_id":"66","2":"175","wf_tarea_id":"175","3":null,"core_usuario_id":null,"4":"2015-06-30 17:22:29","fec_asig":"2015-06-30 17:22:29","5":null,"core_usuario_id_resol":null,"6":null,"fec_resol":null,"7":"175","wf_tarea_id_sig":"175","8":null,"usr_asig":null,"9":null,"usr_resol":null}
2015-06 30 17:25:31
cargar datos del sujeto(,,s,87,66)
select s.*, m.nombre as nom_muni, c.nom_cat,fec_caso
from wf_caso_87 w
inner join core_sujetoverificacion s on w.id=66 AND s.id =w.core_sujetoverificacion_id
inner join plan_municipio m on s.plan_municipio_id=m.id
inner join core_sujetocategoria c on s.core_sujetocategoria_id=c.id
2015-06 30 17:25:31
tabla dat adic
select tabla from core_sujetoverificaciontipo where id=1
2015-06 30 17:25:31
tabla :persona
SELECT * FROM persona where id=58
fin 2015-06-30 17:25:31
/******************************************************************************************************/
2015-06-30 17:38:55TraerCaso(66,87,)
CargarCaso :66
2015-06 30 17:38:55
CargarDatos: Caso :66
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_87_seguimiento_id,wf_paso_id from wf_caso_87_pasos a1 group by wf_caso_87_seguimiento_id,wf_paso_id order by id
)a
inner join wf_caso_87_pasos p using(id,wf_caso_87_seguimiento_id)
inner join ( select max(id) as wf_caso_87_seguimiento_id,wf_caso_87_id,wf_tarea_id from wf_caso_87_seguimiento where wf_caso_87_id =? group by wf_caso_87_id,wf_tarea_id order by wf_caso_87_id,wf_caso_87_seguimiento_id ) b using(wf_caso_87_seguimiento_id)
left join usuarios u using(core_usuario_id)
{"0":"256","id":"256","1":"277","wf_paso_id":"277","2":"233","wf_caso_87_seguimiento_id":"233","3":"28","core_usuario_id":"28","4":"2015-06-30 17:21:56","fecha_ejec":"2015-06-30 17:21:56","5":"65","dato":"65","6":"sce.t33","tabla":"sce.t33","7":"162","tarea_id":"162","8":"fddf trfd: ciudadano","usr_ejec":"fddf trfd: ciudadano"}
CargarDatos_277(65)
se carga 87_162_277_33_34_4512
{"0":"257","id":"257","1":"279","wf_paso_id":"279","2":"234","wf_caso_87_seguimiento_id":"234","3":"28","core_usuario_id":"28","4":"2015-06-30 17:22:27","fecha_ejec":"2015-06-30 17:22:27","5":"34","dato":"34","6":"sce.t32","tabla":"sce.t32","7":"164","tarea_id":"164","8":"fddf trfd: ciudadano","usr_ejec":"fddf trfd: ciudadano"}
CargarDatos_279(34)
se carga 87_164_279_32_33_452dfghfdghfghgh
se carga 87_164_279_32_33_4505
se carga 87_164_279_32_33_449gdfhfdghdfghdfgh
se carga 87_164_279_32_33_4482015-06-30
{"0":"258","id":"258","1":"309","wf_paso_id":"309","2":"235","wf_caso_87_seguimiento_id":"235","3":"28","core_usuario_id":"28","4":"2015-06-30 17:22:29","fecha_ejec":"2015-06-30 17:22:29","5":null,"dato":null,"6":null,"tabla":null,"7":"194","tarea_id":"194","8":"fddf trfd: ciudadano","usr_ejec":"fddf trfd: ciudadano"}
CargarDatos_309()
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_87_seguimiento a
inner join (
select max(b0.id) as id,b0.wf_caso_87_id,b0.wf_tarea_id from wf_caso_87_seguimiento b0 where b0.wf_caso_87_id =? group by b0.wf_caso_87_id,b0.wf_tarea_id order by wf_caso_87_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":"233","id":"233","1":"66","wf_caso_87_id":"66","2":"162","wf_tarea_id":"162","3":null,"core_usuario_id":null,"4":"2015-06-30 17:21:53","fec_asig":"2015-06-30 17:21:53","5":"28","core_usuario_id_resol":"28","6":"2015-06-30 17:21:56","fec_resol":"2015-06-30 17:21:56","7":"162","wf_tarea_id_sig":"162","8":null,"usr_asig":null,"9":"fddf trfd: ciudadano","usr_resol":"fddf trfd: ciudadano"}
{"0":"234","id":"234","1":"66","wf_caso_87_id":"66","2":"164","wf_tarea_id":"164","3":"28","core_usuario_id":"28","4":"2015-06-30 17:21:56","fec_asig":"2015-06-30 17:21:56","5":"28","core_usuario_id_resol":"28","6":"2015-06-30 17:22:27","fec_resol":"2015-06-30 17:22:27","7":"164","wf_tarea_id_sig":"164","8":"fddf trfd: ciudadano","usr_asig":"fddf trfd: ciudadano","9":"fddf trfd: ciudadano","usr_resol":"fddf trfd: ciudadano"}
{"0":"235","id":"235","1":"66","wf_caso_87_id":"66","2":"194","wf_tarea_id":"194","3":"28","core_usuario_id":"28","4":"2015-06-30 17:22:27","fec_asig":"2015-06-30 17:22:27","5":"28","core_usuario_id_resol":"28","6":"2015-06-30 17:22:29","fec_resol":"2015-06-30 17:22:29","7":"194","wf_tarea_id_sig":"194","8":"fddf trfd: ciudadano","usr_asig":"fddf trfd: ciudadano","9":"fddf trfd: ciudadano","usr_resol":"fddf trfd: ciudadano"}
{"0":"236","id":"236","1":"66","wf_caso_87_id":"66","2":"175","wf_tarea_id":"175","3":null,"core_usuario_id":null,"4":"2015-06-30 17:22:29","fec_asig":"2015-06-30 17:22:29","5":null,"core_usuario_id_resol":null,"6":null,"fec_resol":null,"7":"175","wf_tarea_id_sig":"175","8":null,"usr_asig":null,"9":null,"usr_resol":null}
2015-06 30 17:38:55
cargar datos del sujeto(,,s,87,66)
select s.*, m.nombre as nom_muni, c.nom_cat,fec_caso
from wf_caso_87 w
inner join core_sujetoverificacion s on w.id=66 AND s.id =w.core_sujetoverificacion_id
inner join plan_municipio m on s.plan_municipio_id=m.id
inner join core_sujetocategoria c on s.core_sujetocategoria_id=c.id
2015-06 30 17:38:55
tabla dat adic
select tabla from core_sujetoverificaciontipo where id=1
2015-06 30 17:38:55
tabla :persona
SELECT * FROM persona where id=58
2015-06 30 17:38:55
Continuar(,175,,s)
EjecutarTarea_175() Verificacion periodismo digital id_comp1232
38
ValidarUsuario(175):1
EjecutarPaso_310: form:34 , caso=66 id_comp 1232
Mostrar form
Retorno :
Array
(
[ret] => Ext.getCmp('comp_1232').removeAll();Ext.getCmp('comp_1232').add(new Ext.form.FormPanel({ title: 'Verificar información' ,padding: 10,id:'frm_formulario_87_66',autoScroll:true ,labelAlign:'top',defaults: { anchor: '97%'} ,items: [new Ext.form.Hidden({name:'cod_formulario2',value:'34'}) ,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:'35'}) ,new Ext.form.Hidden({name :'oid',value:''}) ,new Ext.form.Hidden({name :'oid_maestro',value:''}) ,new Ext.form.Label({ html:'Url',id:'453',fieldLabel:'Copiar el vinculo de internet y pegarlo en la barra de navegación'}),new Ext.form.RadioGroup({columns:2,items:[ new Ext.form.Radio({name:'454',id:'454_1',inputValue:1,boxLabel:'Si'}), new Ext.form.Radio({name:'454',id:'454_2',inputValue:2,boxLabel:'No'}) ],columns:2,allowBlank:false,fieldLabel:'* Valido',id:'454',listeners:{change:function(){var cu=Ext.getCmp('454_2').getValue();var tx=Ext.getCmp('455');if(cu){tx.setDisabled(false);}else {tx.setDisabled(true);tx.setValue('');}}}}), new Ext.form.TextArea({id:'455',allowBlank:false, fieldLabel:'* Observación',name:'455',disabled:true}) ] ,prepararGrids:function(){/*buscar editorgrid - grilla id compuesto, id real, mas id formulario esclavo, separado _*/var grillasF=this.findByType('editorgrid');if(grillasF && grillasF!=''){for (i=0; i < grillasF.length; i++){var xstore=grillasF[i].getStore();if(xstore.getCount()>0){var data=new Array();var xxid=grillasF[i].getId().split('_');for (j=0; j < xstore.getCount(); j++){var xreco = xstore.getAt(j); var cont_dat_vac=0,cont_tot_vac=0; for(var elem in xreco.data){cont_tot_vac++;if( xreco.data[elem] ==null || xreco.data[elem]=='' ){cont_dat_vac++;}} if(cont_dat_vac < cont_tot_vac){data[data.length]=xreco.data;data[data.length-1]['form_master_escribir_xxx']=xxid[1];}}var xfinalfin=Ext.encode(data);Ext.getCmp(xxid[0]).setValue(xfinalfin);}}}/*grabar stores en hiddens*/},tbar:[{text:'Guardar',iconCls: 'icon-disk',handler: function(){ var form = Ext.getCmp('frm_formulario_87_66'); 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:'87',wf_paso_id:'310',wf_tarea_id:'175',wf_caso_id:'66',id:'1232',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', 'No hay comunicacion con el servidor');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_87_66').getForm().loadRecord(new Ext.data.Record({"cod_formulario":34,"oid_maestro":null,"cod_bloque":35})); llamadaAJAX({url:'http://192.168.10.116/sisad/build/view/workflow/casos/casos_datosForm.php',mostrarMsg:false,params:{accion:'verifica',wf_paso_id:'310',cod_formulario:'34',cod_bloque:'35',wf_caso_id:'{"pro":"87","cas":"66"}'}}); }catch(e){alert(e);} } } }) );Ext.getCmp('comp_1232').doLayout();
[suc] => 1
)
fin 2015-06-30 17:38:55
/******************************************************************************************************/
2015-06-30 17:38:55TraerCaso(66,87,)
CargarCaso :66
2015-06 30 17:38:55
CargarDatos: Caso :66
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_87_seguimiento_id,wf_paso_id from wf_caso_87_pasos a1 group by wf_caso_87_seguimiento_id,wf_paso_id order by id
)a
inner join wf_caso_87_pasos p using(id,wf_caso_87_seguimiento_id)
inner join ( select max(id) as wf_caso_87_seguimiento_id,wf_caso_87_id,wf_tarea_id from wf_caso_87_seguimiento where wf_caso_87_id =? group by wf_caso_87_id,wf_tarea_id order by wf_caso_87_id,wf_caso_87_seguimiento_id ) b using(wf_caso_87_seguimiento_id)
left join usuarios u using(core_usuario_id)
{"0":"256","id":"256","1":"277","wf_paso_id":"277","2":"233","wf_caso_87_seguimiento_id":"233","3":"28","core_usuario_id":"28","4":"2015-06-30 17:21:56","fecha_ejec":"2015-06-30 17:21:56","5":"65","dato":"65","6":"sce.t33","tabla":"sce.t33","7":"162","tarea_id":"162","8":"fddf trfd: ciudadano","usr_ejec":"fddf trfd: ciudadano"}
CargarDatos_277(65)
se carga 87_162_277_33_34_4512
{"0":"257","id":"257","1":"279","wf_paso_id":"279","2":"234","wf_caso_87_seguimiento_id":"234","3":"28","core_usuario_id":"28","4":"2015-06-30 17:22:27","fecha_ejec":"2015-06-30 17:22:27","5":"34","dato":"34","6":"sce.t32","tabla":"sce.t32","7":"164","tarea_id":"164","8":"fddf trfd: ciudadano","usr_ejec":"fddf trfd: ciudadano"}
CargarDatos_279(34)
se carga 87_164_279_32_33_452dfghfdghfghgh
se carga 87_164_279_32_33_4505
se carga 87_164_279_32_33_449gdfhfdghdfghdfgh
se carga 87_164_279_32_33_4482015-06-30
{"0":"258","id":"258","1":"309","wf_paso_id":"309","2":"235","wf_caso_87_seguimiento_id":"235","3":"28","core_usuario_id":"28","4":"2015-06-30 17:22:29","fecha_ejec":"2015-06-30 17:22:29","5":null,"dato":null,"6":null,"tabla":null,"7":"194","tarea_id":"194","8":"fddf trfd: ciudadano","usr_ejec":"fddf trfd: ciudadano"}
CargarDatos_309()
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_87_seguimiento a
inner join (
select max(b0.id) as id,b0.wf_caso_87_id,b0.wf_tarea_id from wf_caso_87_seguimiento b0 where b0.wf_caso_87_id =? group by b0.wf_caso_87_id,b0.wf_tarea_id order by wf_caso_87_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":"233","id":"233","1":"66","wf_caso_87_id":"66","2":"162","wf_tarea_id":"162","3":null,"core_usuario_id":null,"4":"2015-06-30 17:21:53","fec_asig":"2015-06-30 17:21:53","5":"28","core_usuario_id_resol":"28","6":"2015-06-30 17:21:56","fec_resol":"2015-06-30 17:21:56","7":"162","wf_tarea_id_sig":"162","8":null,"usr_asig":null,"9":"fddf trfd: ciudadano","usr_resol":"fddf trfd: ciudadano"}
{"0":"234","id":"234","1":"66","wf_caso_87_id":"66","2":"164","wf_tarea_id":"164","3":"28","core_usuario_id":"28","4":"2015-06-30 17:21:56","fec_asig":"2015-06-30 17:21:56","5":"28","core_usuario_id_resol":"28","6":"2015-06-30 17:22:27","fec_resol":"2015-06-30 17:22:27","7":"164","wf_tarea_id_sig":"164","8":"fddf trfd: ciudadano","usr_asig":"fddf trfd: ciudadano","9":"fddf trfd: ciudadano","usr_resol":"fddf trfd: ciudadano"}
{"0":"235","id":"235","1":"66","wf_caso_87_id":"66","2":"194","wf_tarea_id":"194","3":"28","core_usuario_id":"28","4":"2015-06-30 17:22:27","fec_asig":"2015-06-30 17:22:27","5":"28","core_usuario_id_resol":"28","6":"2015-06-30 17:22:29","fec_resol":"2015-06-30 17:22:29","7":"194","wf_tarea_id_sig":"194","8":"fddf trfd: ciudadano","usr_asig":"fddf trfd: ciudadano","9":"fddf trfd: ciudadano","usr_resol":"fddf trfd: ciudadano"}
{"0":"236","id":"236","1":"66","wf_caso_87_id":"66","2":"175","wf_tarea_id":"175","3":null,"core_usuario_id":null,"4":"2015-06-30 17:22:29","fec_asig":"2015-06-30 17:22:29","5":null,"core_usuario_id_resol":null,"6":null,"fec_resol":null,"7":"175","wf_tarea_id_sig":"175","8":null,"usr_asig":null,"9":null,"usr_resol":null}
2015-06 30 17:38:55
cargar datos del sujeto(,,s,87,66)
select s.*, m.nombre as nom_muni, c.nom_cat,fec_caso
from wf_caso_87 w
inner join core_sujetoverificacion s on w.id=66 AND s.id =w.core_sujetoverificacion_id
inner join plan_municipio m on s.plan_municipio_id=m.id
inner join core_sujetocategoria c on s.core_sujetocategoria_id=c.id
2015-06 30 17:38:55
tabla dat adic
select tabla from core_sujetoverificaciontipo where id=1
2015-06 30 17:38:55
tabla :persona
SELECT * FROM persona where id=58
fin 2015-06-30 17:38:55
/******************************************************************************************************/
2015-06-30 17:38:59TraerCaso(66,87,)
CargarCaso :66
2015-06 30 17:38:59
CargarDatos: Caso :66
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_87_seguimiento_id,wf_paso_id from wf_caso_87_pasos a1 group by wf_caso_87_seguimiento_id,wf_paso_id order by id
)a
inner join wf_caso_87_pasos p using(id,wf_caso_87_seguimiento_id)
inner join ( select max(id) as wf_caso_87_seguimiento_id,wf_caso_87_id,wf_tarea_id from wf_caso_87_seguimiento where wf_caso_87_id =? group by wf_caso_87_id,wf_tarea_id order by wf_caso_87_id,wf_caso_87_seguimiento_id ) b using(wf_caso_87_seguimiento_id)
left join usuarios u using(core_usuario_id)
{"0":"256","id":"256","1":"277","wf_paso_id":"277","2":"233","wf_caso_87_seguimiento_id":"233","3":"28","core_usuario_id":"28","4":"2015-06-30 17:21:56","fecha_ejec":"2015-06-30 17:21:56","5":"65","dato":"65","6":"sce.t33","tabla":"sce.t33","7":"162","tarea_id":"162","8":"fddf trfd: ciudadano","usr_ejec":"fddf trfd: ciudadano"}
CargarDatos_277(65)
se carga 87_162_277_33_34_4512
{"0":"257","id":"257","1":"279","wf_paso_id":"279","2":"234","wf_caso_87_seguimiento_id":"234","3":"28","core_usuario_id":"28","4":"2015-06-30 17:22:27","fecha_ejec":"2015-06-30 17:22:27","5":"34","dato":"34","6":"sce.t32","tabla":"sce.t32","7":"164","tarea_id":"164","8":"fddf trfd: ciudadano","usr_ejec":"fddf trfd: ciudadano"}
CargarDatos_279(34)
se carga 87_164_279_32_33_452dfghfdghfghgh
se carga 87_164_279_32_33_4505
se carga 87_164_279_32_33_449gdfhfdghdfghdfgh
se carga 87_164_279_32_33_4482015-06-30
{"0":"258","id":"258","1":"309","wf_paso_id":"309","2":"235","wf_caso_87_seguimiento_id":"235","3":"28","core_usuario_id":"28","4":"2015-06-30 17:22:29","fecha_ejec":"2015-06-30 17:22:29","5":null,"dato":null,"6":null,"tabla":null,"7":"194","tarea_id":"194","8":"fddf trfd: ciudadano","usr_ejec":"fddf trfd: ciudadano"}
CargarDatos_309()
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_87_seguimiento a
inner join (
select max(b0.id) as id,b0.wf_caso_87_id,b0.wf_tarea_id from wf_caso_87_seguimiento b0 where b0.wf_caso_87_id =? group by b0.wf_caso_87_id,b0.wf_tarea_id order by wf_caso_87_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":"233","id":"233","1":"66","wf_caso_87_id":"66","2":"162","wf_tarea_id":"162","3":null,"core_usuario_id":null,"4":"2015-06-30 17:21:53","fec_asig":"2015-06-30 17:21:53","5":"28","core_usuario_id_resol":"28","6":"2015-06-30 17:21:56","fec_resol":"2015-06-30 17:21:56","7":"162","wf_tarea_id_sig":"162","8":null,"usr_asig":null,"9":"fddf trfd: ciudadano","usr_resol":"fddf trfd: ciudadano"}
{"0":"234","id":"234","1":"66","wf_caso_87_id":"66","2":"164","wf_tarea_id":"164","3":"28","core_usuario_id":"28","4":"2015-06-30 17:21:56","fec_asig":"2015-06-30 17:21:56","5":"28","core_usuario_id_resol":"28","6":"2015-06-30 17:22:27","fec_resol":"2015-06-30 17:22:27","7":"164","wf_tarea_id_sig":"164","8":"fddf trfd: ciudadano","usr_asig":"fddf trfd: ciudadano","9":"fddf trfd: ciudadano","usr_resol":"fddf trfd: ciudadano"}
{"0":"235","id":"235","1":"66","wf_caso_87_id":"66","2":"194","wf_tarea_id":"194","3":"28","core_usuario_id":"28","4":"2015-06-30 17:22:27","fec_asig":"2015-06-30 17:22:27","5":"28","core_usuario_id_resol":"28","6":"2015-06-30 17:22:29","fec_resol":"2015-06-30 17:22:29","7":"194","wf_tarea_id_sig":"194","8":"fddf trfd: ciudadano","usr_asig":"fddf trfd: ciudadano","9":"fddf trfd: ciudadano","usr_resol":"fddf trfd: ciudadano"}
{"0":"236","id":"236","1":"66","wf_caso_87_id":"66","2":"175","wf_tarea_id":"175","3":null,"core_usuario_id":null,"4":"2015-06-30 17:22:29","fec_asig":"2015-06-30 17:22:29","5":null,"core_usuario_id_resol":null,"6":null,"fec_resol":null,"7":"175","wf_tarea_id_sig":"175","8":null,"usr_asig":null,"9":null,"usr_resol":null}
2015-06 30 17:38:59
cargar datos del sujeto(,,s,87,66)
select s.*, m.nombre as nom_muni, c.nom_cat,fec_caso
from wf_caso_87 w
inner join core_sujetoverificacion s on w.id=66 AND s.id =w.core_sujetoverificacion_id
inner join plan_municipio m on s.plan_municipio_id=m.id
inner join core_sujetocategoria c on s.core_sujetocategoria_id=c.id
2015-06 30 17:38:59
tabla dat adic
select tabla from core_sujetoverificaciontipo where id=1
2015-06 30 17:38:59
tabla :persona
SELECT * FROM persona where id=58
2015-06 30 17:38:59
Continuar(s,175,310,)
EjecutarTarea_175() Verificacion periodismo digital id_comp1232
38
ValidarUsuario(175):1
EjecutarPaso_310: form:34 , caso=66 id_comp 1232
Paso::Guardar(Caso:66)
Datos a guardar:
Array
(
[wf_proceso_id] => 87
[wf_paso_id] => 310
[wf_tarea_id] => 175
[wf_caso_id] => 66
[id] => 1232
[accion] => nextPaso
[reg] => s
[rta] => n
[cod_formulario2] => 34
[id_periodo] => 2015
[obs_ingreso] =>
[cod_bloque] => 35
[oid] =>
[oid_maestro] =>
[454] => 2
[455] => fhcjmgfjhgfhj
)
OID: 6
rta: 1 dato:6 tabla:sce.t34
CasoPaso:262
CargarDatos_310(6)
se carga 87_175_310_34_35_455fhcjmgfjhgfhj
se carga 87_175_310_34_35_4542
se carga 87_175_310_34_35_453
SiguientePasoDe310: Funcion para ejecutar el siguiente paso
Condicion Tarea : 2 == 1
Condicion Tarea : 2 == 2
TerminarTarea(175,192)
Ultimo seg :236
Ultimo seg :238
EjecutarTarea_192() Inscripcion NO exitosa periodismo digital id_comp1232
38 38
ValidarUsuario(192):1
EjecutarPaso_303: corr:120 , caso=66 id_comp 1232
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:fddf
TWFSV_2:trfd
<br>Su solicitud a Inscripción a eventos culturales del concurso Silvio León España en la categorÃa periodismo digital NO se realizó con éxito por los siguiente motivos:<br> { 87_175_310_34_35_454 } <br>Observaciones:<br> { 87_175_310_34_35_455 }
T87_175_310_34_35_455:fhcjmgfjhgfhj
T87_175_310_34_35_454:No
{ WFSV_1 }
TWFSV_1:desarrollo4@siticol.com
Inscripción NO exitosa en la categorÃa periodismo digital
Retorno :
Array
(
[ret] => inicioComponente_WF_Correo({"id":"1232","caso_id":"66","proceso_id":87,"tit":"Inscripcion NO exitosa periodismo digital","tarea_id":192,"paso_id":303,"desc":"<p>\nApreciado(a)<br>\n<strong>TRFD FDDF<\/strong>\n<p>\n<p>El presente mensaje es una notificación para el caso No <strong>66<\/strong> <\/p>\n<strong><br>Su solicitud a Inscripci\u00f3n a eventos culturales del concurso Silvio Le\u00f3n Espa\u00f1a en la categor\u00eda periodismo digital NO se realiz\u00f3 con \u00e9xito por los siguiente motivos:<br> No <br>Observaciones:<br> fhcjmgfjhgfhj<\/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:'Inscripci\u00f3n NO exitosa en la categor\u00eda periodismo digital'},\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-06-30 17:39:00
/******************************************************************************************************/
2015-06-30 17:39:26TraerCaso(66,87,)
CargarCaso :66
2015-06 30 17:39:26
CargarDatos: Caso :66
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_87_seguimiento_id,wf_paso_id from wf_caso_87_pasos a1 group by wf_caso_87_seguimiento_id,wf_paso_id order by id
)a
inner join wf_caso_87_pasos p using(id,wf_caso_87_seguimiento_id)
inner join ( select max(id) as wf_caso_87_seguimiento_id,wf_caso_87_id,wf_tarea_id from wf_caso_87_seguimiento where wf_caso_87_id =? group by wf_caso_87_id,wf_tarea_id order by wf_caso_87_id,wf_caso_87_seguimiento_id ) b using(wf_caso_87_seguimiento_id)
left join usuarios u using(core_usuario_id)
{"0":"256","id":"256","1":"277","wf_paso_id":"277","2":"233","wf_caso_87_seguimiento_id":"233","3":"28","core_usuario_id":"28","4":"2015-06-30 17:21:56","fecha_ejec":"2015-06-30 17:21:56","5":"65","dato":"65","6":"sce.t33","tabla":"sce.t33","7":"162","tarea_id":"162","8":"fddf trfd: ciudadano","usr_ejec":"fddf trfd: ciudadano"}
CargarDatos_277(65)
se carga 87_162_277_33_34_4512
{"0":"257","id":"257","1":"279","wf_paso_id":"279","2":"234","wf_caso_87_seguimiento_id":"234","3":"28","core_usuario_id":"28","4":"2015-06-30 17:22:27","fecha_ejec":"2015-06-30 17:22:27","5":"34","dato":"34","6":"sce.t32","tabla":"sce.t32","7":"164","tarea_id":"164","8":"fddf trfd: ciudadano","usr_ejec":"fddf trfd: ciudadano"}
CargarDatos_279(34)
se carga 87_164_279_32_33_452dfghfdghfghgh
se carga 87_164_279_32_33_4505
se carga 87_164_279_32_33_449gdfhfdghdfghdfgh
se carga 87_164_279_32_33_4482015-06-30
{"0":"258","id":"258","1":"309","wf_paso_id":"309","2":"235","wf_caso_87_seguimiento_id":"235","3":"28","core_usuario_id":"28","4":"2015-06-30 17:22:29","fecha_ejec":"2015-06-30 17:22:29","5":null,"dato":null,"6":null,"tabla":null,"7":"194","tarea_id":"194","8":"fddf trfd: ciudadano","usr_ejec":"fddf trfd: ciudadano"}
CargarDatos_309()
{"0":"262","id":"262","1":"310","wf_paso_id":"310","2":"236","wf_caso_87_seguimiento_id":"236","3":"38","core_usuario_id":"38","4":"2015-06-30 17:39:00","fecha_ejec":"2015-06-30 17:39:00","5":"6","dato":"6","6":"sce.t34","tabla":"sce.t34","7":"175","tarea_id":"175","8":"secretaria operador : gerente","usr_ejec":"secretaria operador : gerente"}
CargarDatos_310(6)
se carga 87_175_310_34_35_455fhcjmgfjhgfhj
se carga 87_175_310_34_35_4542
se carga 87_175_310_34_35_453
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_87_seguimiento a
inner join (
select max(b0.id) as id,b0.wf_caso_87_id,b0.wf_tarea_id from wf_caso_87_seguimiento b0 where b0.wf_caso_87_id =? group by b0.wf_caso_87_id,b0.wf_tarea_id order by wf_caso_87_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":"233","id":"233","1":"66","wf_caso_87_id":"66","2":"162","wf_tarea_id":"162","3":null,"core_usuario_id":null,"4":"2015-06-30 17:21:53","fec_asig":"2015-06-30 17:21:53","5":"28","core_usuario_id_resol":"28","6":"2015-06-30 17:21:56","fec_resol":"2015-06-30 17:21:56","7":"162","wf_tarea_id_sig":"162","8":null,"usr_asig":null,"9":"fddf trfd: ciudadano","usr_resol":"fddf trfd: ciudadano"}
{"0":"234","id":"234","1":"66","wf_caso_87_id":"66","2":"164","wf_tarea_id":"164","3":"28","core_usuario_id":"28","4":"2015-06-30 17:21:56","fec_asig":"2015-06-30 17:21:56","5":"28","core_usuario_id_resol":"28","6":"2015-06-30 17:22:27","fec_resol":"2015-06-30 17:22:27","7":"164","wf_tarea_id_sig":"164","8":"fddf trfd: ciudadano","usr_asig":"fddf trfd: ciudadano","9":"fddf trfd: ciudadano","usr_resol":"fddf trfd: ciudadano"}
{"0":"235","id":"235","1":"66","wf_caso_87_id":"66","2":"194","wf_tarea_id":"194","3":"28","core_usuario_id":"28","4":"2015-06-30 17:22:27","fec_asig":"2015-06-30 17:22:27","5":"28","core_usuario_id_resol":"28","6":"2015-06-30 17:22:29","fec_resol":"2015-06-30 17:22:29","7":"194","wf_tarea_id_sig":"194","8":"fddf trfd: ciudadano","usr_asig":"fddf trfd: ciudadano","9":"fddf trfd: ciudadano","usr_resol":"fddf trfd: ciudadano"}
{"0":"236","id":"236","1":"66","wf_caso_87_id":"66","2":"175","wf_tarea_id":"175","3":null,"core_usuario_id":null,"4":"2015-06-30 17:22:29","fec_asig":"2015-06-30 17:22:29","5":"38","core_usuario_id_resol":"38","6":"2015-06-30 17:39:00","fec_resol":"2015-06-30 17:39:00","7":"175","wf_tarea_id_sig":"175","8":null,"usr_asig":null,"9":"secretaria operador : gerente","usr_resol":"secretaria operador : gerente"}
{"0":"238","id":"238","1":"66","wf_caso_87_id":"66","2":"192","wf_tarea_id":"192","3":"38","core_usuario_id":"38","4":"2015-06-30 17:39:00","fec_asig":"2015-06-30 17:39:00","5":null,"core_usuario_id_resol":null,"6":null,"fec_resol":null,"7":"192","wf_tarea_id_sig":"192","8":"secretaria operador : gerente","usr_asig":"secretaria operador : gerente","9":null,"usr_resol":null}
2015-06 30 17:39:26
cargar datos del sujeto(,,s,87,66)
select s.*, m.nombre as nom_muni, c.nom_cat,fec_caso
from wf_caso_87 w
inner join core_sujetoverificacion s on w.id=66 AND s.id =w.core_sujetoverificacion_id
inner join plan_municipio m on s.plan_municipio_id=m.id
inner join core_sujetocategoria c on s.core_sujetocategoria_id=c.id
2015-06 30 17:39:26
tabla dat adic
select tabla from core_sujetoverificaciontipo where id=1
2015-06 30 17:39:26
tabla :persona
SELECT * FROM persona where id=58
2015-06 30 17:39:26
Continuar(,192,,s)
EjecutarTarea_192() Inscripcion NO exitosa periodismo digital id_comp1232
38 38
ValidarUsuario(192):1
EjecutarPaso_303: corr:120 , caso=66 id_comp 1232
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:fddf
TWFSV_2:trfd
<br>Su solicitud a Inscripción a eventos culturales del concurso Silvio León España en la categorÃa periodismo digital NO se realizó con éxito por los siguiente motivos:<br> { 87_175_310_34_35_454 } <br>Observaciones:<br> { 87_175_310_34_35_455 }
T87_175_310_34_35_455:fhcjmgfjhgfhj
T87_175_310_34_35_454:No
{ WFSV_1 }
TWFSV_1:desarrollo4@siticol.com
Inscripción NO exitosa en la categorÃa periodismo digital
Retorno :
Array
(
[ret] => inicioComponente_WF_Correo({"id":"1232","caso_id":"66","proceso_id":87,"tit":"Inscripcion NO exitosa periodismo digital","tarea_id":192,"paso_id":303,"desc":"<p>\nApreciado(a)<br>\n<strong>TRFD FDDF<\/strong>\n<p>\n<p>El presente mensaje es una notificación para el caso No <strong>66<\/strong> <\/p>\n<strong><br>Su solicitud a Inscripci\u00f3n a eventos culturales del concurso Silvio Le\u00f3n Espa\u00f1a en la categor\u00eda periodismo digital NO se realiz\u00f3 con \u00e9xito por los siguiente motivos:<br> No <br>Observaciones:<br> fhcjmgfjhgfhj<\/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:'Inscripci\u00f3n NO exitosa en la categor\u00eda periodismo digital'},\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-06-30 17:39:26
/******************************************************************************************************/
2015-06-30 17:43:09TraerCaso(66,87,)
CargarCaso :66
2015-06 30 17:43:09
CargarDatos: Caso :66
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_87_seguimiento_id,wf_paso_id from wf_caso_87_pasos a1 group by wf_caso_87_seguimiento_id,wf_paso_id order by id
)a
inner join wf_caso_87_pasos p using(id,wf_caso_87_seguimiento_id)
inner join ( select max(id) as wf_caso_87_seguimiento_id,wf_caso_87_id,wf_tarea_id from wf_caso_87_seguimiento where wf_caso_87_id =? group by wf_caso_87_id,wf_tarea_id order by wf_caso_87_id,wf_caso_87_seguimiento_id ) b using(wf_caso_87_seguimiento_id)
left join usuarios u using(core_usuario_id)
{"0":"256","id":"256","1":"277","wf_paso_id":"277","2":"233","wf_caso_87_seguimiento_id":"233","3":"28","core_usuario_id":"28","4":"2015-06-30 17:21:56","fecha_ejec":"2015-06-30 17:21:56","5":"65","dato":"65","6":"sce.t33","tabla":"sce.t33","7":"162","tarea_id":"162","8":"fddf trfd: ciudadano","usr_ejec":"fddf trfd: ciudadano"}
CargarDatos_277(65)
se carga 87_162_277_33_34_4512
{"0":"257","id":"257","1":"279","wf_paso_id":"279","2":"234","wf_caso_87_seguimiento_id":"234","3":"28","core_usuario_id":"28","4":"2015-06-30 17:22:27","fecha_ejec":"2015-06-30 17:22:27","5":"34","dato":"34","6":"sce.t32","tabla":"sce.t32","7":"164","tarea_id":"164","8":"fddf trfd: ciudadano","usr_ejec":"fddf trfd: ciudadano"}
CargarDatos_279(34)
se carga 87_164_279_32_33_452dfghfdghfghgh
se carga 87_164_279_32_33_4505
se carga 87_164_279_32_33_449gdfhfdghdfghdfgh
se carga 87_164_279_32_33_4482015-06-30
{"0":"258","id":"258","1":"309","wf_paso_id":"309","2":"235","wf_caso_87_seguimiento_id":"235","3":"28","core_usuario_id":"28","4":"2015-06-30 17:22:29","fecha_ejec":"2015-06-30 17:22:29","5":null,"dato":null,"6":null,"tabla":null,"7":"194","tarea_id":"194","8":"fddf trfd: ciudadano","usr_ejec":"fddf trfd: ciudadano"}
CargarDatos_309()
{"0":"262","id":"262","1":"310","wf_paso_id":"310","2":"236","wf_caso_87_seguimiento_id":"236","3":"38","core_usuario_id":"38","4":"2015-06-30 17:39:00","fecha_ejec":"2015-06-30 17:39:00","5":"6","dato":"6","6":"sce.t34","tabla":"sce.t34","7":"175","tarea_id":"175","8":"secretaria operador : gerente","usr_ejec":"secretaria operador : gerente"}
CargarDatos_310(6)
se carga 87_175_310_34_35_455fhcjmgfjhgfhj
se carga 87_175_310_34_35_4542
se carga 87_175_310_34_35_453
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_87_seguimiento a
inner join (
select max(b0.id) as id,b0.wf_caso_87_id,b0.wf_tarea_id from wf_caso_87_seguimiento b0 where b0.wf_caso_87_id =? group by b0.wf_caso_87_id,b0.wf_tarea_id order by wf_caso_87_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":"233","id":"233","1":"66","wf_caso_87_id":"66","2":"162","wf_tarea_id":"162","3":null,"core_usuario_id":null,"4":"2015-06-30 17:21:53","fec_asig":"2015-06-30 17:21:53","5":"28","core_usuario_id_resol":"28","6":"2015-06-30 17:21:56","fec_resol":"2015-06-30 17:21:56","7":"162","wf_tarea_id_sig":"162","8":null,"usr_asig":null,"9":"fddf trfd: ciudadano","usr_resol":"fddf trfd: ciudadano"}
{"0":"234","id":"234","1":"66","wf_caso_87_id":"66","2":"164","wf_tarea_id":"164","3":"28","core_usuario_id":"28","4":"2015-06-30 17:21:56","fec_asig":"2015-06-30 17:21:56","5":"28","core_usuario_id_resol":"28","6":"2015-06-30 17:22:27","fec_resol":"2015-06-30 17:22:27","7":"164","wf_tarea_id_sig":"164","8":"fddf trfd: ciudadano","usr_asig":"fddf trfd: ciudadano","9":"fddf trfd: ciudadano","usr_resol":"fddf trfd: ciudadano"}
{"0":"235","id":"235","1":"66","wf_caso_87_id":"66","2":"194","wf_tarea_id":"194","3":"28","core_usuario_id":"28","4":"2015-06-30 17:22:27","fec_asig":"2015-06-30 17:22:27","5":"28","core_usuario_id_resol":"28","6":"2015-06-30 17:22:29","fec_resol":"2015-06-30 17:22:29","7":"194","wf_tarea_id_sig":"194","8":"fddf trfd: ciudadano","usr_asig":"fddf trfd: ciudadano","9":"fddf trfd: ciudadano","usr_resol":"fddf trfd: ciudadano"}
{"0":"236","id":"236","1":"66","wf_caso_87_id":"66","2":"175","wf_tarea_id":"175","3":null,"core_usuario_id":null,"4":"2015-06-30 17:22:29","fec_asig":"2015-06-30 17:22:29","5":"38","core_usuario_id_resol":"38","6":"2015-06-30 17:39:00","fec_resol":"2015-06-30 17:39:00","7":"175","wf_tarea_id_sig":"175","8":null,"usr_asig":null,"9":"secretaria operador : gerente","usr_resol":"secretaria operador : gerente"}
{"0":"238","id":"238","1":"66","wf_caso_87_id":"66","2":"192","wf_tarea_id":"192","3":"38","core_usuario_id":"38","4":"2015-06-30 17:39:00","fec_asig":"2015-06-30 17:39:00","5":null,"core_usuario_id_resol":null,"6":null,"fec_resol":null,"7":"192","wf_tarea_id_sig":"192","8":"secretaria operador : gerente","usr_asig":"secretaria operador : gerente","9":null,"usr_resol":null}
2015-06 30 17:43:09
cargar datos del sujeto(,,s,87,66)
select s.*, m.nombre as nom_muni, c.nom_cat,fec_caso
from wf_caso_87 w
inner join core_sujetoverificacion s on w.id=66 AND s.id =w.core_sujetoverificacion_id
inner join plan_municipio m on s.plan_municipio_id=m.id
inner join core_sujetocategoria c on s.core_sujetocategoria_id=c.id
2015-06 30 17:43:09
tabla dat adic
select tabla from core_sujetoverificaciontipo where id=1
2015-06 30 17:43:09
tabla :persona
SELECT * FROM persona where id=58
2015-06 30 17:43:09
Continuar(s,192,303,)
EjecutarTarea_192() Inscripcion NO exitosa periodismo digital id_comp1232
38 38
ValidarUsuario(192):1
EjecutarPaso_303: corr:120 , caso=66 id_comp 1232
Paso::Guardar(Caso:66)
rta: 1 dato: tabla:
CasoPaso:263
CargarDatos_303()
SiguientePasoDe303: Funcion para ejecutar el siguiente paso
TerminarTarea(192,)
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_1232').funcionInicial('n');
)
fin 2015-06-30 17:43:09
/******************************************************************************************************/
2015-06-30 17:44:45TraerCaso(66,87,)
CargarCaso :66
2015-06 30 17:44:45
CargarDatos: Caso :66
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_87_seguimiento_id,wf_paso_id from wf_caso_87_pasos a1 group by wf_caso_87_seguimiento_id,wf_paso_id order by id
)a
inner join wf_caso_87_pasos p using(id,wf_caso_87_seguimiento_id)
inner join ( select max(id) as wf_caso_87_seguimiento_id,wf_caso_87_id,wf_tarea_id from wf_caso_87_seguimiento where wf_caso_87_id =? group by wf_caso_87_id,wf_tarea_id order by wf_caso_87_id,wf_caso_87_seguimiento_id ) b using(wf_caso_87_seguimiento_id)
left join usuarios u using(core_usuario_id)
{"0":"256","id":"256","1":"277","wf_paso_id":"277","2":"233","wf_caso_87_seguimiento_id":"233","3":"28","core_usuario_id":"28","4":"2015-06-30 17:21:56","fecha_ejec":"2015-06-30 17:21:56","5":"65","dato":"65","6":"sce.t33","tabla":"sce.t33","7":"162","tarea_id":"162","8":"fddf trfd: ciudadano","usr_ejec":"fddf trfd: ciudadano"}
CargarDatos_277(65)
se carga 87_162_277_33_34_4512
{"0":"257","id":"257","1":"279","wf_paso_id":"279","2":"234","wf_caso_87_seguimiento_id":"234","3":"28","core_usuario_id":"28","4":"2015-06-30 17:22:27","fecha_ejec":"2015-06-30 17:22:27","5":"34","dato":"34","6":"sce.t32","tabla":"sce.t32","7":"164","tarea_id":"164","8":"fddf trfd: ciudadano","usr_ejec":"fddf trfd: ciudadano"}
CargarDatos_279(34)
se carga 87_164_279_32_33_452dfghfdghfghgh
se carga 87_164_279_32_33_4505
se carga 87_164_279_32_33_449gdfhfdghdfghdfgh
se carga 87_164_279_32_33_4482015-06-30
{"0":"258","id":"258","1":"309","wf_paso_id":"309","2":"235","wf_caso_87_seguimiento_id":"235","3":"28","core_usuario_id":"28","4":"2015-06-30 17:22:29","fecha_ejec":"2015-06-30 17:22:29","5":null,"dato":null,"6":null,"tabla":null,"7":"194","tarea_id":"194","8":"fddf trfd: ciudadano","usr_ejec":"fddf trfd: ciudadano"}
CargarDatos_309()
{"0":"262","id":"262","1":"310","wf_paso_id":"310","2":"236","wf_caso_87_seguimiento_id":"236","3":"38","core_usuario_id":"38","4":"2015-06-30 17:39:00","fecha_ejec":"2015-06-30 17:39:00","5":"6","dato":"6","6":"sce.t34","tabla":"sce.t34","7":"175","tarea_id":"175","8":"secretaria operador : gerente","usr_ejec":"secretaria operador : gerente"}
CargarDatos_310(6)
se carga 87_175_310_34_35_455fhcjmgfjhgfhj
se carga 87_175_310_34_35_4542
se carga 87_175_310_34_35_453
{"0":"263","id":"263","1":"303","wf_paso_id":"303","2":"238","wf_caso_87_seguimiento_id":"238","3":"38","core_usuario_id":"38","4":"2015-06-30 17:43:09","fecha_ejec":"2015-06-30 17:43:09","5":null,"dato":null,"6":null,"tabla":null,"7":"192","tarea_id":"192","8":"secretaria operador : gerente","usr_ejec":"secretaria operador : gerente"}
CargarDatos_303()
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_87_seguimiento a
inner join (
select max(b0.id) as id,b0.wf_caso_87_id,b0.wf_tarea_id from wf_caso_87_seguimiento b0 where b0.wf_caso_87_id =? group by b0.wf_caso_87_id,b0.wf_tarea_id order by wf_caso_87_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":"233","id":"233","1":"66","wf_caso_87_id":"66","2":"162","wf_tarea_id":"162","3":null,"core_usuario_id":null,"4":"2015-06-30 17:21:53","fec_asig":"2015-06-30 17:21:53","5":"28","core_usuario_id_resol":"28","6":"2015-06-30 17:21:56","fec_resol":"2015-06-30 17:21:56","7":"162","wf_tarea_id_sig":"162","8":null,"usr_asig":null,"9":"fddf trfd: ciudadano","usr_resol":"fddf trfd: ciudadano"}
{"0":"234","id":"234","1":"66","wf_caso_87_id":"66","2":"164","wf_tarea_id":"164","3":"28","core_usuario_id":"28","4":"2015-06-30 17:21:56","fec_asig":"2015-06-30 17:21:56","5":"28","core_usuario_id_resol":"28","6":"2015-06-30 17:22:27","fec_resol":"2015-06-30 17:22:27","7":"164","wf_tarea_id_sig":"164","8":"fddf trfd: ciudadano","usr_asig":"fddf trfd: ciudadano","9":"fddf trfd: ciudadano","usr_resol":"fddf trfd: ciudadano"}
{"0":"235","id":"235","1":"66","wf_caso_87_id":"66","2":"194","wf_tarea_id":"194","3":"28","core_usuario_id":"28","4":"2015-06-30 17:22:27","fec_asig":"2015-06-30 17:22:27","5":"28","core_usuario_id_resol":"28","6":"2015-06-30 17:22:29","fec_resol":"2015-06-30 17:22:29","7":"194","wf_tarea_id_sig":"194","8":"fddf trfd: ciudadano","usr_asig":"fddf trfd: ciudadano","9":"fddf trfd: ciudadano","usr_resol":"fddf trfd: ciudadano"}
{"0":"236","id":"236","1":"66","wf_caso_87_id":"66","2":"175","wf_tarea_id":"175","3":null,"core_usuario_id":null,"4":"2015-06-30 17:22:29","fec_asig":"2015-06-30 17:22:29","5":"38","core_usuario_id_resol":"38","6":"2015-06-30 17:39:00","fec_resol":"2015-06-30 17:39:00","7":"175","wf_tarea_id_sig":"175","8":null,"usr_asig":null,"9":"secretaria operador : gerente","usr_resol":"secretaria operador : gerente"}
{"0":"238","id":"238","1":"66","wf_caso_87_id":"66","2":"192","wf_tarea_id":"192","3":"38","core_usuario_id":"38","4":"2015-06-30 17:39:00","fec_asig":"2015-06-30 17:39:00","5":"38","core_usuario_id_resol":"38","6":"2015-06-30 17:43:09","fec_resol":"2015-06-30 17:43:09","7":"192","wf_tarea_id_sig":"192","8":"secretaria operador : gerente","usr_asig":"secretaria operador : gerente","9":"secretaria operador : gerente","usr_resol":"secretaria operador : gerente"}
2015-06 30 17:44:45
cargar datos del sujeto(,,s,87,66)
select s.*, m.nombre as nom_muni, c.nom_cat,fec_caso
from wf_caso_87 w
inner join core_sujetoverificacion s on w.id=66 AND s.id =w.core_sujetoverificacion_id
inner join plan_municipio m on s.plan_municipio_id=m.id
inner join core_sujetocategoria c on s.core_sujetocategoria_id=c.id
2015-06 30 17:44:45
tabla dat adic
select tabla from core_sujetoverificaciontipo where id=1
2015-06 30 17:44:45
tabla :persona
SELECT * FROM persona where id=58
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 66; ?></strong> </p>
<?php $html=ob_get_clean();
TWFSV_3:fddf
TWFSV_2:trfd
<br>Su solicitud a Inscripción a eventos culturales del concurso Silvio León España en la categorÃa periodismo digital NO se realizó con éxito por los siguiente motivos:<br> { 87_175_310_34_35_454 } <br>Observaciones:<br> { 87_175_310_34_35_455 }
T87_175_310_34_35_455:fhcjmgfjhgfhj
T87_175_310_34_35_454:No
{ WFSV_1 }
TWFSV_1:desarrollo4@siticol.com
Inscripción NO exitosa en la categorÃa periodismo digital
fin 2015-06-30 17:44:45
/******************************************************************************************************/