2015-06 23 10:09:11
Nuevo(101,1)
Caso :82
2015-06 23 10:09:11
cargar datos del sujeto(,,s,91,82)
select s.*, m.nombre as nom_muni, c.nom_cat,fec_caso
from wf_caso_91 w
inner join core_sujetoverificacion s on w.id=82 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 23 10:09:11
tabla dat adic
select tabla from core_sujetoverificaciontipo where id=1
2015-06 23 10:09:11
tabla :persona
SELECT * FROM persona where id=101
CasoSeguimiento :189
EjecutarTarea_197() Ingreso y verificacion de la organizacion id_comp1241
51
ValidarUsuario(197):1
EjecutarPaso_315: form:41 , caso=82 id_comp 1241
Mostrar form
fin 2015-06-23 10:09:11
/******************************************************************************************************/
2015-06-23 10:09:11TraerCaso(82,91,)
CargarCaso :82
2015-06 23 10:09:11
CargarDatos: Caso :82
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_91_seguimiento_id,wf_paso_id from wf_caso_91_pasos a1 group by wf_caso_91_seguimiento_id,wf_paso_id order by id
)a
inner join wf_caso_91_pasos p using(id,wf_caso_91_seguimiento_id)
inner join ( select max(id) as wf_caso_91_seguimiento_id,wf_caso_91_id,wf_tarea_id from wf_caso_91_seguimiento where wf_caso_91_id =? group by wf_caso_91_id,wf_tarea_id order by wf_caso_91_id,wf_caso_91_seguimiento_id ) b using(wf_caso_91_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_91_seguimiento a
inner join (
select max(b0.id) as id,b0.wf_caso_91_id,b0.wf_tarea_id from wf_caso_91_seguimiento b0 where b0.wf_caso_91_id =? group by b0.wf_caso_91_id,b0.wf_tarea_id order by wf_caso_91_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":"189","id":"189","1":"82","wf_caso_91_id":"82","2":"197","wf_tarea_id":"197","3":null,"core_usuario_id":null,"4":"2015-06-23 10:09:11","fec_asig":"2015-06-23 10:09:11","5":null,"core_usuario_id_resol":null,"6":null,"fec_resol":null,"7":"197","wf_tarea_id_sig":"197","8":null,"usr_asig":null,"9":null,"usr_resol":null}
2015-06 23 10:09:11
cargar datos del sujeto(,,s,91,82)
select s.*, m.nombre as nom_muni, c.nom_cat,fec_caso
from wf_caso_91 w
inner join core_sujetoverificacion s on w.id=82 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 23 10:09:11
tabla dat adic
select tabla from core_sujetoverificaciontipo where id=1
2015-06 23 10:09:11
tabla :persona
SELECT * FROM persona where id=101
fin 2015-06-23 10:09:11
/******************************************************************************************************/
2015-06-23 10:09:18TraerCaso(82,91,)
CargarCaso :82
2015-06 23 10:09:18
CargarDatos: Caso :82
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_91_seguimiento_id,wf_paso_id from wf_caso_91_pasos a1 group by wf_caso_91_seguimiento_id,wf_paso_id order by id
)a
inner join wf_caso_91_pasos p using(id,wf_caso_91_seguimiento_id)
inner join ( select max(id) as wf_caso_91_seguimiento_id,wf_caso_91_id,wf_tarea_id from wf_caso_91_seguimiento where wf_caso_91_id =? group by wf_caso_91_id,wf_tarea_id order by wf_caso_91_id,wf_caso_91_seguimiento_id ) b using(wf_caso_91_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_91_seguimiento a
inner join (
select max(b0.id) as id,b0.wf_caso_91_id,b0.wf_tarea_id from wf_caso_91_seguimiento b0 where b0.wf_caso_91_id =? group by b0.wf_caso_91_id,b0.wf_tarea_id order by wf_caso_91_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":"189","id":"189","1":"82","wf_caso_91_id":"82","2":"197","wf_tarea_id":"197","3":null,"core_usuario_id":null,"4":"2015-06-23 10:09:11","fec_asig":"2015-06-23 10:09:11","5":null,"core_usuario_id_resol":null,"6":null,"fec_resol":null,"7":"197","wf_tarea_id_sig":"197","8":null,"usr_asig":null,"9":null,"usr_resol":null}
2015-06 23 10:09:18
cargar datos del sujeto(,,s,91,82)
select s.*, m.nombre as nom_muni, c.nom_cat,fec_caso
from wf_caso_91 w
inner join core_sujetoverificacion s on w.id=82 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 23 10:09:18
tabla dat adic
select tabla from core_sujetoverificaciontipo where id=1
2015-06 23 10:09:18
tabla :persona
SELECT * FROM persona where id=101
2015-06 23 10:09:18
Continuar(s,197,315,)
EjecutarTarea_197() Ingreso y verificacion de la organizacion id_comp1241
51
ValidarUsuario(197):1
EjecutarPaso_315: form:41 , caso=82 id_comp 1241
Paso::Guardar(Caso:82)
Datos a guardar:
Array
(
[wf_proceso_id] => 91
[wf_paso_id] => 315
[wf_tarea_id] => 197
[wf_caso_id] => 82
[id] => 1241
[accion] => nextPaso
[reg] => s
[rta] => n
[cod_formulario2] => 41
[id_periodo] => 2015
[obs_ingreso] =>
[cod_bloque] => 42
[oid] =>
[oid_maestro] =>
[485] => 125
[486] => 1
)
OID: 80
rta: 1 dato:80 tabla:sce.t41
CasoPaso:146
CargarDatos_315(80)
se carga 91_197_315_41_42_4861
se carga 91_197_315_41_42_485125
SiguientePasoDe315: Funcion para ejecutar el siguiente paso
Condicion Tarea : true
TerminarTarea(197,198)
Ultimo seg :189
Ultimo seg :190
EjecutarTarea_198() Registro o actualizacion de datos id_comp1241
51 51
ValidarUsuario(198):1
EjecutarPaso_316: form:38 , caso=82 id_comp 1241
Mostrar form
Retorno :
Array
(
[ret] => Ext.getCmp('comp_1241').removeAll();Ext.getCmp('comp_1241').add(new Ext.form.FormPanel({ title: 'Ingreso de datos' ,padding: 10,id:'frm_formulario_91_82',autoScroll:true ,labelAlign:'top',defaults: { anchor: '97%'} ,items: [new Ext.form.Hidden({name:'cod_formulario2',value:'38'}) ,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:'39'}) ,new Ext.form.Hidden({name :'oid',id :'oid',value:''}) ,new Ext.form.Hidden({name :'oid_maestro',value:''}) ,{value:'',xtype:'textfield' , maxLength:60,autoCreate:{ tag:'input',maxlength:'60'} ,listeners:{ blur:function(){ this.setValue(this.getValue().toUpperCase()); } } ,allowBlank:false,id:'468',fieldLabel:'* Nombre de la organización' },{value:'',xtype:'textfield' , maxLength:60,autoCreate:{ tag:'input',maxlength:'60'} ,listeners:{ blur:function(){ this.setValue(this.getValue().toUpperCase()); } } ,allowBlank:false,id:'469',fieldLabel:'* Corregimiento' },{value:'',xtype:'textfield' , maxLength:60,autoCreate:{ tag:'input',maxlength:'60'} ,listeners:{ blur:function(){ this.setValue(this.getValue().toUpperCase()); } } ,allowBlank:false,id:'470',fieldLabel:'* Vereda' },new Ext.form.Hidden({ value:'2015-06-23', id:'471'}),{value:'',xtype:'textfield' , maxLength:15,autoCreate:{ tag:'input',maxlength:'15'} ,allowBlank:false,id:'472',fieldLabel:'* Nit-Rut',readOnly:true },{value:'',xtype:'textfield' , maxLength:60,autoCreate:{ tag:'input',maxlength:'60'} ,allowBlank:false,id:'473',fieldLabel:'* Personeria jurÃdica' },{value:'',xtype:'textfield' , maxLength:120,autoCreate:{ tag:'input',maxlength:'120'} ,allowBlank:false,id:'474',fieldLabel:'* Actividades principales' },{ xtype:'hidden',id:'hdcampo483',value:'39'},{ xtype:'hidden',id:'483'}, new Ext.grid.EditorGridPanel({xtype:'editorgrid',store:new Ext.data.JsonStore({ fields:[{ name:'oid' },{ name:'txtgcargo' },{ name:'txtnomcom' },{ name:'txtdociden' },{ name:'txtgtel' }]}),columns:[new Ext.grid.RowNumberer({width:30}),{header:'Cargo',dataIndex:'txtgcargo',width:80,resizable:true,sortable:true},{header:'Nombre completo',dataIndex:'txtnomcom',width:80,resizable:true,sortable:true,editor:{value:'',xtype:'textfield' , maxLength:50 ,allowBlank:false}},{header:'Documento de identificación',dataIndex:'txtdociden',width:80,resizable:true,sortable:true,editor:{value:'',xtype:'numberfield' , maxLength:10 ,allowBlank:false}},{header:'Teléfono',dataIndex:'txtgtel',width:80,resizable:true,sortable:true,editor:{value:'',xtype:'numberfield' , maxLength:10 ,allowBlank:false}}],stripeRows:true,height:150,id:'483_39',title:'Junta directiva',stateful:true,stateId:'grid',autoScroll:true,autoWidth:true,sm:new Ext.grid.RowSelectionModel({singleSelect:false}),anchor:'97%',viewConfig:{forceFit:true,showPreview: true,enableRowBody: false, getRowClass: function(record, rowIndex, rp, ds){ return 'fila-act-sin-pro';},listeners:{rowsinserted:function(view,row,info){this.refresh();},rowremoved:function(view,row,info){this.refresh();}}},tbar:[{iconCls:'icon-add',tooltip:'Agregar',text:'Agregar',handler:function(){var TopicRecord = Ext.data.Record.create({ name:'oid' },{ name:'txtgcargo' },{ name:'txtnomcom' },{ name:'txtdociden' },{ name:'txtgtel' });var myNewRecord = new TopicRecord({ oid:null ,txtgcargo:'',txtnomcom:'',txtdociden:'',txtgtel:''});var storegri = Ext.getCmp('483_39').getStore();storegri.add(myNewRecord);}},{iconCls:'icon-delete',tooltip:'Eliminar',text:'Eliminar',handler:function(){var grid = Ext.getCmp('483_39');var list = grid.getSelectionModel().getSelections();if (!list) {Ext.MessageBox.alert('Advertencia', 'Ningun item seleccionado');return false;}Ext.Msg.show({ title:'Advertencia de eliminacion', msg:'Esta seguro que desea eliminar los items seleccionados?', buttons:Ext.Msg.YESNO, animEl:'btnEl', fn:function(btn){ if (btn == 'yes'){grid.store.remove(list);} }, icon:Ext.MessageBox.QUESTION });}}]})/*fgp*/,{ xtype:'hidden',id:'hdcampo484',value:'40'},{ xtype:'hidden',id:'484'}, new Ext.grid.EditorGridPanel({xtype:'editorgrid',store:new Ext.data.JsonStore({ fields:[{ name:'oid' },{ name:'txtsnom' },{ name:'cmbsgen' },{ name:'cmbsgen_txt' },{ name:'txtsced' },{ name:'txtstel' }]}),columns:[new Ext.grid.RowNumberer({width:30}),{header:'Nombre completo',dataIndex:'txtsnom',width:80,resizable:true,sortable:true,editor:{value:'',xtype:'textfield' , maxLength:50 ,allowBlank:false}},{header:'Genero',dataIndex:'cmbsgen',width:80,resizable:true,sortable:true,renderer:function(value,metaData,record,rowIndex,colIndex,store) {var combo = this.editor;var record = combo.findRecord(combo.valueField,value);return record ? record.get(combo.displayField):(record && record.data.cmbsgen_txt ?record.data.cmbsgen_txt:value );},editor: new Ext.form.ComboBox({typeAhead:true,triggerAction:'all',mode:'local',editable:false,emptyText:'Seleccione una opción',store:new Ext.data.ArrayStore({fields:['id', 'value'],data:[[001,'Masculino'],[002,'Femenino']]}),valueField:'id',displayField:'value',id:'selgrid_480',allowBlank:false})},{header:'Documento de identificación',dataIndex:'txtsced',width:80,resizable:true,sortable:true,editor:{value:'',xtype:'numberfield' , maxLength:10 ,allowBlank:false}},{header:'Teléfono',dataIndex:'txtstel',width:80,resizable:true,sortable:true,editor:{value:'',xtype:'numberfield' , maxLength:10 ,allowBlank:false}}],stripeRows:true,height:150,id:'484_40',title:'Socios activos',stateful:true,stateId:'grid',autoScroll:true,autoWidth:true,sm:new Ext.grid.RowSelectionModel({singleSelect:false}),anchor:'97%',viewConfig:{forceFit:true,showPreview: true,enableRowBody: false, getRowClass: function(record, rowIndex, rp, ds){ return 'fila-act-sin-pro';},listeners:{rowsinserted:function(view,row,info){this.refresh();},rowremoved:function(view,row,info){this.refresh();}}},tbar:[{iconCls:'icon-add',tooltip:'Agregar',text:'Agregar',handler:function(){var TopicRecord = Ext.data.Record.create({ name:'oid' },{ name:'txtsnom' },{ name:'cmbsgen' },{ name:'txtsced' },{ name:'txtstel' });var myNewRecord = new TopicRecord({ oid:null ,txtsnom:'',cmbsgen:'',txtsced:'',txtstel:''});var storegri = Ext.getCmp('484_40').getStore();storegri.add(myNewRecord);}},{iconCls:'icon-delete',tooltip:'Eliminar',text:'Eliminar',handler:function(){var grid = Ext.getCmp('484_40');var list = grid.getSelectionModel().getSelections();if (!list) {Ext.MessageBox.alert('Advertencia', 'Ningun item seleccionado');return false;}Ext.Msg.show({ title:'Advertencia de eliminacion', msg:'Esta seguro que desea eliminar los items seleccionados?', buttons:Ext.Msg.YESNO, animEl:'btnEl', fn:function(btn){ if (btn == 'yes'){grid.store.remove(list);} }, icon:Ext.MessageBox.QUESTION });}}]})/*fgp*/,new Ext.form.RadioGroup({columns:2,items:[ new Ext.form.Radio({name:'488',id:'488_1',inputValue:1,boxLabel:'Presidente'}), new Ext.form.Radio({name:'488',id:'488_2',inputValue:2,boxLabel:'VIcepresidente'}), new Ext.form.Radio({name:'488',id:'488_3',inputValue:3,boxLabel:'Secretario(a)'}), new Ext.form.Radio({name:'488',id:'488_4',inputValue:4,boxLabel:'Tesorero'}) ],columns:4,allowBlank:false,fieldLabel:'',id:'488',hidden: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_91_82'); 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:'91',wf_paso_id:'316',wf_tarea_id:'198',wf_caso_id:'82',id:'1241',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_91_82').getForm().loadRecord(new Ext.data.Record({"cod_formulario":38,"oid_maestro":null,"cod_bloque":39,"468":null,"469":null,"470":null,"472":null,"473":null,"474":null})); llamadaAJAX({url:'http://192.168.10.116/sisad/build/view/workflow/casos/casos_datosForm.php',mostrarMsg:false,params:{accion:'verifica',wf_paso_id:'316',cod_formulario:'38',cod_bloque:'39',wf_caso_id:'{"pro":"91","cas":"82"}'}}); setTimeout(function(){ var nit=Ext.getCmp('472').getValue();var tper;var sujeto='51';if(Ext.getCmp('488_1').getValue())tper=1;if(Ext.getCmp('488_2').getValue())tper=2;if(Ext.getCmp('488_3').getValue())tper=3;if(Ext.getCmp('488_4').getValue())tper=4;Ext.Ajax.request({url:$root_js+'archivos_ventanilla/build/consulta/consulta.php',params:{accion:'cosulta_nit',nit:nit,tper:tper,sujeto:sujeto},success: function(result) {json=doJSON(result.responseText);if(json.success==true){/*Ext.getCmp('frm_formulario_91_82').getForm().loadRecord(new Ext.data.Record(json.data);*/Ext.getCmp('oid').setValue(json.data.oid);Ext.getCmp('468').setValue(json.data.txtorga);Ext.getCmp('469').setValue(json.data.txstcorreg);Ext.getCmp('470').setValue(json.data.txtvereda);Ext.getCmp('471').setValue(json.data.txtfecha);Ext.getCmp('473').setValue(json.data.txtperjur);Ext.getCmp('474').setValue(json.data.txtactpri);Ext.getCmp('483_39').getStore().loadData(json.data2);Ext.getCmp('484_40').getStore().loadData(json.data3); }else{var ce="";var j;/*=[{"txtgcargo":"Presidente"},{"txtgcargo":"Vicepresidente"},{"txtgcargo":"Secretario"},{"txtgcargo":"Tesorero"}]*/;if(tper==1)j=[json.data4,{"txtgcargo":"Vicepresidente"},{"txtgcargo":"Secretaria(o)"},{"txtgcargo":"Tesorero"}];if(tper==2)j=[{"txtgcargo":"Presidente"},json.data4,{"txtgcargo":"Secretaria(o)"},{"txtgcargo":"Tesorero"}];if(tper==3)j=[{"txtgcargo":"Presidente"},{"txtgcargo":"Vicepresidente"},json.data4,{"txtgcargo":"Tesorero"}];if(tper==4)j=[{"txtgcargo":"Presidente"},{"txtgcargo":"Vicepresidente"},{"txtgcargo":"Secretaria(o)"},json.data4];Ext.getCmp('483_39').getStore().loadData(j);}} ,failure: function(result) { } });},800);}catch(e){alert(e);} } } }) );Ext.getCmp('comp_1241').doLayout();
[suc] => 1
)
fin 2015-06-23 10:09:18
/******************************************************************************************************/
2015-06-23 10:09:19TraerCaso(82,91,)
CargarCaso :82
2015-06 23 10:09:19
CargarDatos: Caso :82
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_91_seguimiento_id,wf_paso_id from wf_caso_91_pasos a1 group by wf_caso_91_seguimiento_id,wf_paso_id order by id
)a
inner join wf_caso_91_pasos p using(id,wf_caso_91_seguimiento_id)
inner join ( select max(id) as wf_caso_91_seguimiento_id,wf_caso_91_id,wf_tarea_id from wf_caso_91_seguimiento where wf_caso_91_id =? group by wf_caso_91_id,wf_tarea_id order by wf_caso_91_id,wf_caso_91_seguimiento_id ) b using(wf_caso_91_seguimiento_id)
left join usuarios u using(core_usuario_id)
{"0":"146","id":"146","1":"315","wf_paso_id":"315","2":"189","wf_caso_91_seguimiento_id":"189","3":"51","core_usuario_id":"51","4":"2015-06-23 10:09:18","fecha_ejec":"2015-06-23 10:09:18","5":"80","dato":"80","6":"sce.t41","tabla":"sce.t41","7":"197","tarea_id":"197","8":"Ruano Marcela: ciudadano","usr_ejec":"Ruano Marcela: ciudadano"}
CargarDatos_315(80)
se carga 91_197_315_41_42_4861
se carga 91_197_315_41_42_485125
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_91_seguimiento a
inner join (
select max(b0.id) as id,b0.wf_caso_91_id,b0.wf_tarea_id from wf_caso_91_seguimiento b0 where b0.wf_caso_91_id =? group by b0.wf_caso_91_id,b0.wf_tarea_id order by wf_caso_91_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":"189","id":"189","1":"82","wf_caso_91_id":"82","2":"197","wf_tarea_id":"197","3":null,"core_usuario_id":null,"4":"2015-06-23 10:09:11","fec_asig":"2015-06-23 10:09:11","5":"51","core_usuario_id_resol":"51","6":"2015-06-23 10:09:18","fec_resol":"2015-06-23 10:09:18","7":"197","wf_tarea_id_sig":"197","8":null,"usr_asig":null,"9":"Ruano Marcela: ciudadano","usr_resol":"Ruano Marcela: ciudadano"}
{"0":"190","id":"190","1":"82","wf_caso_91_id":"82","2":"198","wf_tarea_id":"198","3":"51","core_usuario_id":"51","4":"2015-06-23 10:09:18","fec_asig":"2015-06-23 10:09:18","5":null,"core_usuario_id_resol":null,"6":null,"fec_resol":null,"7":"198","wf_tarea_id_sig":"198","8":"Ruano Marcela: ciudadano","usr_asig":"Ruano Marcela: ciudadano","9":null,"usr_resol":null}
2015-06 23 10:09:19
cargar datos del sujeto(,,s,91,82)
select s.*, m.nombre as nom_muni, c.nom_cat,fec_caso
from wf_caso_91 w
inner join core_sujetoverificacion s on w.id=82 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 23 10:09:19
tabla dat adic
select tabla from core_sujetoverificaciontipo where id=1
2015-06 23 10:09:19
tabla :persona
SELECT * FROM persona where id=101
fin 2015-06-23 10:09:19
/******************************************************************************************************/
2015-06-23 10:09:36TraerCaso(82,91,)
CargarCaso :82
2015-06 23 10:09:36
CargarDatos: Caso :82
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_91_seguimiento_id,wf_paso_id from wf_caso_91_pasos a1 group by wf_caso_91_seguimiento_id,wf_paso_id order by id
)a
inner join wf_caso_91_pasos p using(id,wf_caso_91_seguimiento_id)
inner join ( select max(id) as wf_caso_91_seguimiento_id,wf_caso_91_id,wf_tarea_id from wf_caso_91_seguimiento where wf_caso_91_id =? group by wf_caso_91_id,wf_tarea_id order by wf_caso_91_id,wf_caso_91_seguimiento_id ) b using(wf_caso_91_seguimiento_id)
left join usuarios u using(core_usuario_id)
{"0":"146","id":"146","1":"315","wf_paso_id":"315","2":"189","wf_caso_91_seguimiento_id":"189","3":"51","core_usuario_id":"51","4":"2015-06-23 10:09:18","fecha_ejec":"2015-06-23 10:09:18","5":"80","dato":"80","6":"sce.t41","tabla":"sce.t41","7":"197","tarea_id":"197","8":"Ruano Marcela: ciudadano","usr_ejec":"Ruano Marcela: ciudadano"}
CargarDatos_315(80)
se carga 91_197_315_41_42_4861
se carga 91_197_315_41_42_485125
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_91_seguimiento a
inner join (
select max(b0.id) as id,b0.wf_caso_91_id,b0.wf_tarea_id from wf_caso_91_seguimiento b0 where b0.wf_caso_91_id =? group by b0.wf_caso_91_id,b0.wf_tarea_id order by wf_caso_91_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":"189","id":"189","1":"82","wf_caso_91_id":"82","2":"197","wf_tarea_id":"197","3":null,"core_usuario_id":null,"4":"2015-06-23 10:09:11","fec_asig":"2015-06-23 10:09:11","5":"51","core_usuario_id_resol":"51","6":"2015-06-23 10:09:18","fec_resol":"2015-06-23 10:09:18","7":"197","wf_tarea_id_sig":"197","8":null,"usr_asig":null,"9":"Ruano Marcela: ciudadano","usr_resol":"Ruano Marcela: ciudadano"}
{"0":"190","id":"190","1":"82","wf_caso_91_id":"82","2":"198","wf_tarea_id":"198","3":"51","core_usuario_id":"51","4":"2015-06-23 10:09:18","fec_asig":"2015-06-23 10:09:18","5":null,"core_usuario_id_resol":null,"6":null,"fec_resol":null,"7":"198","wf_tarea_id_sig":"198","8":"Ruano Marcela: ciudadano","usr_asig":"Ruano Marcela: ciudadano","9":null,"usr_resol":null}
2015-06 23 10:09:36
cargar datos del sujeto(,,s,91,82)
select s.*, m.nombre as nom_muni, c.nom_cat,fec_caso
from wf_caso_91 w
inner join core_sujetoverificacion s on w.id=82 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 23 10:09:36
tabla dat adic
select tabla from core_sujetoverificaciontipo where id=1
2015-06 23 10:09:36
tabla :persona
SELECT * FROM persona where id=101
2015-06 23 10:09:36
Continuar(s,198,316,)
EjecutarTarea_198() Registro o actualizacion de datos id_comp1241
51 51
ValidarUsuario(198):1
EjecutarPaso_316: form:38 , caso=82 id_comp 1241
Paso::Guardar(Caso:82)
Datos a guardar:
Array
(
[wf_proceso_id] => 91
[wf_paso_id] => 316
[wf_tarea_id] => 198
[wf_caso_id] => 82
[id] => 1241
[accion] => nextPaso
[reg] => s
[rta] => n
[cod_formulario2] => 38
[id_periodo] => 2015
[obs_ingreso] =>
[cod_bloque] => 39
[oid] =>
[oid_maestro] =>
[468] => DS
[469] => CATAMBUCO
[470] => CENTRO
[471] => 2015-06-23
[472] => 125
[473] => 4578
[474] => dert
[hdcampo483] => 39
[483] => [{"oid":"","txtgcargo":"Presidente","txtnomcom":"Marcela Ruano","txtdociden":"5344308","txtgtel":"3122556647","form_master_escribir_xxx":"39"},{"oid":"","txtgcargo":"Vicepresidente","txtnomcom":"","txtdociden":"","txtgtel":"","form_master_escribir_xxx":"39"},{"oid":"","txtgcargo":"Secretaria(o)","txtnomcom":"","txtdociden":"","txtgtel":"","form_master_escribir_xxx":"39"},{"oid":"","txtgcargo":"Tesorero","txtnomcom":"","txtdociden":"","txtgtel":"","form_master_escribir_xxx":"39"}]
[hdcampo484] => 40
[484] =>
[488] => 1
)
OID: 9
rta: 1 dato:9 tabla:sce.t38
CasoPaso:147
CargarDatos_316(9)
se carga 91_198_316_38_39_4881
se carga 91_198_316_38_39_484
se carga 91_198_316_38_39_483Array
se carga 91_198_316_38_39_474dert
se carga 91_198_316_38_39_4734578
se carga 91_198_316_38_39_472125
se carga 91_198_316_38_39_4712015-06-23
se carga 91_198_316_38_39_470CENTRO
se carga 91_198_316_38_39_469CATAMBUCO
se carga 91_198_316_38_39_468DS
SiguientePasoDe316: Funcion para ejecutar el siguiente paso
EjecutarPaso_319: corr:123 , caso=82 id_comp 1241
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:Ruano
TWFSV_2:Marcela
Su solicitud de Registro y actualización de organizaciones se encuentra registrada con éxito y se encuentra en tramite. Si esta en la plataforma presione Continuar para seguir con el proceso de su solicitud.
{ WFSV_1 }
TWFSV_1:myriabe123@gmail.com
Registro exitoso en registro y actualización de organizaciones
Retorno :
Array
(
[ret] => inicioComponente_WF_Correo({"id":"1241","caso_id":"82","proceso_id":91,"tit":"Registro o actualizacion de datos","tarea_id":198,"paso_id":319,"desc":"<p>\nApreciado(a)<br>\n<strong>MARCELA RUANO<\/strong>\n<p>\n<p>El presente mensaje es una notificación para el caso No <strong>82<\/strong> <\/p>\n<strong>Su solicitud de Registro y actualizaci\u00f3n de organizaciones se encuentra registrada con \u00e9xito y se encuentra en tramite. Si esta en la plataforma presione Continuar para seguir con el proceso de su solicitud.<\/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:'myriabe123@gmail.com',asunto:'Registro exitoso en registro y actualizaci\u00f3n de organizaciones'},\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-23 10:09:37
/******************************************************************************************************/
2015-06-23 10:09:38TraerCaso(82,91,)
CargarCaso :82
2015-06 23 10:09:38
CargarDatos: Caso :82
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_91_seguimiento_id,wf_paso_id from wf_caso_91_pasos a1 group by wf_caso_91_seguimiento_id,wf_paso_id order by id
)a
inner join wf_caso_91_pasos p using(id,wf_caso_91_seguimiento_id)
inner join ( select max(id) as wf_caso_91_seguimiento_id,wf_caso_91_id,wf_tarea_id from wf_caso_91_seguimiento where wf_caso_91_id =? group by wf_caso_91_id,wf_tarea_id order by wf_caso_91_id,wf_caso_91_seguimiento_id ) b using(wf_caso_91_seguimiento_id)
left join usuarios u using(core_usuario_id)
{"0":"146","id":"146","1":"315","wf_paso_id":"315","2":"189","wf_caso_91_seguimiento_id":"189","3":"51","core_usuario_id":"51","4":"2015-06-23 10:09:18","fecha_ejec":"2015-06-23 10:09:18","5":"80","dato":"80","6":"sce.t41","tabla":"sce.t41","7":"197","tarea_id":"197","8":"Ruano Marcela: ciudadano","usr_ejec":"Ruano Marcela: ciudadano"}
CargarDatos_315(80)
se carga 91_197_315_41_42_4861
se carga 91_197_315_41_42_485125
{"0":"147","id":"147","1":"316","wf_paso_id":"316","2":"190","wf_caso_91_seguimiento_id":"190","3":"51","core_usuario_id":"51","4":"2015-06-23 10:09:37","fecha_ejec":"2015-06-23 10:09:37","5":"9","dato":"9","6":"sce.t38","tabla":"sce.t38","7":"198","tarea_id":"198","8":"Ruano Marcela: ciudadano","usr_ejec":"Ruano Marcela: ciudadano"}
CargarDatos_316(9)
se carga 91_198_316_38_39_4881
se carga 91_198_316_38_39_484
se carga 91_198_316_38_39_483Array
se carga 91_198_316_38_39_474dert
se carga 91_198_316_38_39_4734578
se carga 91_198_316_38_39_472125
se carga 91_198_316_38_39_4712015-06-23
se carga 91_198_316_38_39_470CENTRO
se carga 91_198_316_38_39_469CATAMBUCO
se carga 91_198_316_38_39_468DS
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_91_seguimiento a
inner join (
select max(b0.id) as id,b0.wf_caso_91_id,b0.wf_tarea_id from wf_caso_91_seguimiento b0 where b0.wf_caso_91_id =? group by b0.wf_caso_91_id,b0.wf_tarea_id order by wf_caso_91_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":"189","id":"189","1":"82","wf_caso_91_id":"82","2":"197","wf_tarea_id":"197","3":null,"core_usuario_id":null,"4":"2015-06-23 10:09:11","fec_asig":"2015-06-23 10:09:11","5":"51","core_usuario_id_resol":"51","6":"2015-06-23 10:09:18","fec_resol":"2015-06-23 10:09:18","7":"197","wf_tarea_id_sig":"197","8":null,"usr_asig":null,"9":"Ruano Marcela: ciudadano","usr_resol":"Ruano Marcela: ciudadano"}
{"0":"190","id":"190","1":"82","wf_caso_91_id":"82","2":"198","wf_tarea_id":"198","3":"51","core_usuario_id":"51","4":"2015-06-23 10:09:18","fec_asig":"2015-06-23 10:09:18","5":null,"core_usuario_id_resol":null,"6":null,"fec_resol":null,"7":"198","wf_tarea_id_sig":"198","8":"Ruano Marcela: ciudadano","usr_asig":"Ruano Marcela: ciudadano","9":null,"usr_resol":null}
2015-06 23 10:09:38
cargar datos del sujeto(,,s,91,82)
select s.*, m.nombre as nom_muni, c.nom_cat,fec_caso
from wf_caso_91 w
inner join core_sujetoverificacion s on w.id=82 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 23 10:09:38
tabla dat adic
select tabla from core_sujetoverificaciontipo where id=1
2015-06 23 10:09:38
tabla :persona
SELECT * FROM persona where id=101
2015-06 23 10:09:38
Continuar(s,198,319,)
EjecutarTarea_198() Registro o actualizacion de datos id_comp1241
51 51
ValidarUsuario(198):1
EjecutarPaso_319: corr:123 , caso=82 id_comp 1241
Paso::Guardar(Caso:82)
rta: 1 dato: tabla:
CasoPaso:148
CargarDatos_319()
SiguientePasoDe319: Funcion para ejecutar el siguiente paso
Condicion Tarea : true
TerminarTarea(198,200)
Ultimo seg :190
Ultimo seg :191
EjecutarTarea_200() Verificación de la infomacion id_comp1241
51
ValidarUsuario(200):
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_1241').funcionInicial('n');
)
fin 2015-06-23 10:09:38
/******************************************************************************************************/
2015-06-23 10:10:44TraerCaso(82,91,)
CargarCaso :82
2015-06 23 10:10:44
CargarDatos: Caso :82
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_91_seguimiento_id,wf_paso_id from wf_caso_91_pasos a1 group by wf_caso_91_seguimiento_id,wf_paso_id order by id
)a
inner join wf_caso_91_pasos p using(id,wf_caso_91_seguimiento_id)
inner join ( select max(id) as wf_caso_91_seguimiento_id,wf_caso_91_id,wf_tarea_id from wf_caso_91_seguimiento where wf_caso_91_id =? group by wf_caso_91_id,wf_tarea_id order by wf_caso_91_id,wf_caso_91_seguimiento_id ) b using(wf_caso_91_seguimiento_id)
left join usuarios u using(core_usuario_id)
{"0":"146","id":"146","1":"315","wf_paso_id":"315","2":"189","wf_caso_91_seguimiento_id":"189","3":"51","core_usuario_id":"51","4":"2015-06-23 10:09:18","fecha_ejec":"2015-06-23 10:09:18","5":"80","dato":"80","6":"sce.t41","tabla":"sce.t41","7":"197","tarea_id":"197","8":"Ruano Marcela: ciudadano","usr_ejec":"Ruano Marcela: ciudadano"}
CargarDatos_315(80)
se carga 91_197_315_41_42_4861
se carga 91_197_315_41_42_485125
{"0":"147","id":"147","1":"316","wf_paso_id":"316","2":"190","wf_caso_91_seguimiento_id":"190","3":"51","core_usuario_id":"51","4":"2015-06-23 10:09:37","fecha_ejec":"2015-06-23 10:09:37","5":"9","dato":"9","6":"sce.t38","tabla":"sce.t38","7":"198","tarea_id":"198","8":"Ruano Marcela: ciudadano","usr_ejec":"Ruano Marcela: ciudadano"}
CargarDatos_316(9)
se carga 91_198_316_38_39_4881
se carga 91_198_316_38_39_484
se carga 91_198_316_38_39_483Array
se carga 91_198_316_38_39_474dert
se carga 91_198_316_38_39_4734578
se carga 91_198_316_38_39_472125
se carga 91_198_316_38_39_4712015-06-23
se carga 91_198_316_38_39_470CENTRO
se carga 91_198_316_38_39_469CATAMBUCO
se carga 91_198_316_38_39_468DS
{"0":"148","id":"148","1":"319","wf_paso_id":"319","2":"190","wf_caso_91_seguimiento_id":"190","3":"51","core_usuario_id":"51","4":"2015-06-23 10:09:38","fecha_ejec":"2015-06-23 10:09:38","5":null,"dato":null,"6":null,"tabla":null,"7":"198","tarea_id":"198","8":"Ruano Marcela: ciudadano","usr_ejec":"Ruano Marcela: ciudadano"}
CargarDatos_319()
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_91_seguimiento a
inner join (
select max(b0.id) as id,b0.wf_caso_91_id,b0.wf_tarea_id from wf_caso_91_seguimiento b0 where b0.wf_caso_91_id =? group by b0.wf_caso_91_id,b0.wf_tarea_id order by wf_caso_91_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":"189","id":"189","1":"82","wf_caso_91_id":"82","2":"197","wf_tarea_id":"197","3":null,"core_usuario_id":null,"4":"2015-06-23 10:09:11","fec_asig":"2015-06-23 10:09:11","5":"51","core_usuario_id_resol":"51","6":"2015-06-23 10:09:18","fec_resol":"2015-06-23 10:09:18","7":"197","wf_tarea_id_sig":"197","8":null,"usr_asig":null,"9":"Ruano Marcela: ciudadano","usr_resol":"Ruano Marcela: ciudadano"}
{"0":"190","id":"190","1":"82","wf_caso_91_id":"82","2":"198","wf_tarea_id":"198","3":"51","core_usuario_id":"51","4":"2015-06-23 10:09:18","fec_asig":"2015-06-23 10:09:18","5":"51","core_usuario_id_resol":"51","6":"2015-06-23 10:09:38","fec_resol":"2015-06-23 10:09:38","7":"198","wf_tarea_id_sig":"198","8":"Ruano Marcela: ciudadano","usr_asig":"Ruano Marcela: ciudadano","9":"Ruano Marcela: ciudadano","usr_resol":"Ruano Marcela: ciudadano"}
{"0":"191","id":"191","1":"82","wf_caso_91_id":"82","2":"200","wf_tarea_id":"200","3":null,"core_usuario_id":null,"4":"2015-06-23 10:09:38","fec_asig":"2015-06-23 10:09:38","5":null,"core_usuario_id_resol":null,"6":null,"fec_resol":null,"7":"200","wf_tarea_id_sig":"200","8":null,"usr_asig":null,"9":null,"usr_resol":null}
2015-06 23 10:10:44
cargar datos del sujeto(,,s,91,82)
select s.*, m.nombre as nom_muni, c.nom_cat,fec_caso
from wf_caso_91 w
inner join core_sujetoverificacion s on w.id=82 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 23 10:10:44
tabla dat adic
select tabla from core_sujetoverificaciontipo where id=1
2015-06 23 10:10:44
tabla :persona
SELECT * FROM persona where id=101
2015-06 23 10:10:44
Continuar(,200,,s)
EjecutarTarea_200() Verificación de la infomacion id_comp1244
38
ValidarUsuario(200):1
EjecutarPaso_322: form:17 , caso=82 id_comp 1244
Mostrar form
Retorno :
Array
(
[ret] => Ext.getCmp('comp_1244').removeAll();Ext.getCmp('comp_1244').add(new Ext.form.FormPanel({ title: 'Aprobación' ,padding: 10,id:'frm_formulario_91_82',autoScroll:true ,labelAlign:'top',defaults: { anchor: '97%'} ,items: [new Ext.form.Hidden({name:'cod_formulario2',value:'17'}) ,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:'18'}) ,new Ext.form.Hidden({name :'oid',value:''}) ,new Ext.form.Hidden({name :'oid_maestro',value:''}) ,new Ext.form.RadioGroup({columns:2,items:[ new Ext.form.Radio({name:'319',id:'319_1',inputValue:1,boxLabel:'Si'}), new Ext.form.Radio({name:'319',id:'319_2',inputValue:2,boxLabel:'No'}) ],columns:2,allowBlank:false,fieldLabel:'* Aprobado',id:'319',listeners:{change:function(){var c=Ext.getCmp('319_2').getValue();var obs=Ext.getCmp('487');if(c){obs.setDisabled(false);}else {obs.setDisabled(true);}}}}), new Ext.form.TextArea({id:'487',allowBlank:false, fieldLabel:'* Observaciones',name:'487',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_91_82'); 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:'91',wf_paso_id:'322',wf_tarea_id:'200',wf_caso_id:'82',id:'1244',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_91_82').getForm().loadRecord(new Ext.data.Record({"cod_formulario":17,"oid_maestro":null,"cod_bloque":18})); llamadaAJAX({url:'http://192.168.10.116/sisad/build/view/workflow/casos/casos_datosForm.php',mostrarMsg:false,params:{accion:'verifica',wf_paso_id:'322',cod_formulario:'17',cod_bloque:'18',wf_caso_id:'{"pro":"91","cas":"82"}'}}); }catch(e){alert(e);} } } }) );Ext.getCmp('comp_1244').doLayout();
[suc] => 1
)
fin 2015-06-23 10:10:44
/******************************************************************************************************/
2015-06-23 10:10:45TraerCaso(82,91,)
CargarCaso :82
2015-06 23 10:10:45
CargarDatos: Caso :82
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_91_seguimiento_id,wf_paso_id from wf_caso_91_pasos a1 group by wf_caso_91_seguimiento_id,wf_paso_id order by id
)a
inner join wf_caso_91_pasos p using(id,wf_caso_91_seguimiento_id)
inner join ( select max(id) as wf_caso_91_seguimiento_id,wf_caso_91_id,wf_tarea_id from wf_caso_91_seguimiento where wf_caso_91_id =? group by wf_caso_91_id,wf_tarea_id order by wf_caso_91_id,wf_caso_91_seguimiento_id ) b using(wf_caso_91_seguimiento_id)
left join usuarios u using(core_usuario_id)
{"0":"146","id":"146","1":"315","wf_paso_id":"315","2":"189","wf_caso_91_seguimiento_id":"189","3":"51","core_usuario_id":"51","4":"2015-06-23 10:09:18","fecha_ejec":"2015-06-23 10:09:18","5":"80","dato":"80","6":"sce.t41","tabla":"sce.t41","7":"197","tarea_id":"197","8":"Ruano Marcela: ciudadano","usr_ejec":"Ruano Marcela: ciudadano"}
CargarDatos_315(80)
se carga 91_197_315_41_42_4861
se carga 91_197_315_41_42_485125
{"0":"147","id":"147","1":"316","wf_paso_id":"316","2":"190","wf_caso_91_seguimiento_id":"190","3":"51","core_usuario_id":"51","4":"2015-06-23 10:09:37","fecha_ejec":"2015-06-23 10:09:37","5":"9","dato":"9","6":"sce.t38","tabla":"sce.t38","7":"198","tarea_id":"198","8":"Ruano Marcela: ciudadano","usr_ejec":"Ruano Marcela: ciudadano"}
CargarDatos_316(9)
se carga 91_198_316_38_39_4881
se carga 91_198_316_38_39_484
se carga 91_198_316_38_39_483Array
se carga 91_198_316_38_39_474dert
se carga 91_198_316_38_39_4734578
se carga 91_198_316_38_39_472125
se carga 91_198_316_38_39_4712015-06-23
se carga 91_198_316_38_39_470CENTRO
se carga 91_198_316_38_39_469CATAMBUCO
se carga 91_198_316_38_39_468DS
{"0":"148","id":"148","1":"319","wf_paso_id":"319","2":"190","wf_caso_91_seguimiento_id":"190","3":"51","core_usuario_id":"51","4":"2015-06-23 10:09:38","fecha_ejec":"2015-06-23 10:09:38","5":null,"dato":null,"6":null,"tabla":null,"7":"198","tarea_id":"198","8":"Ruano Marcela: ciudadano","usr_ejec":"Ruano Marcela: ciudadano"}
CargarDatos_319()
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_91_seguimiento a
inner join (
select max(b0.id) as id,b0.wf_caso_91_id,b0.wf_tarea_id from wf_caso_91_seguimiento b0 where b0.wf_caso_91_id =? group by b0.wf_caso_91_id,b0.wf_tarea_id order by wf_caso_91_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":"189","id":"189","1":"82","wf_caso_91_id":"82","2":"197","wf_tarea_id":"197","3":null,"core_usuario_id":null,"4":"2015-06-23 10:09:11","fec_asig":"2015-06-23 10:09:11","5":"51","core_usuario_id_resol":"51","6":"2015-06-23 10:09:18","fec_resol":"2015-06-23 10:09:18","7":"197","wf_tarea_id_sig":"197","8":null,"usr_asig":null,"9":"Ruano Marcela: ciudadano","usr_resol":"Ruano Marcela: ciudadano"}
{"0":"190","id":"190","1":"82","wf_caso_91_id":"82","2":"198","wf_tarea_id":"198","3":"51","core_usuario_id":"51","4":"2015-06-23 10:09:18","fec_asig":"2015-06-23 10:09:18","5":"51","core_usuario_id_resol":"51","6":"2015-06-23 10:09:38","fec_resol":"2015-06-23 10:09:38","7":"198","wf_tarea_id_sig":"198","8":"Ruano Marcela: ciudadano","usr_asig":"Ruano Marcela: ciudadano","9":"Ruano Marcela: ciudadano","usr_resol":"Ruano Marcela: ciudadano"}
{"0":"191","id":"191","1":"82","wf_caso_91_id":"82","2":"200","wf_tarea_id":"200","3":null,"core_usuario_id":null,"4":"2015-06-23 10:09:38","fec_asig":"2015-06-23 10:09:38","5":null,"core_usuario_id_resol":null,"6":null,"fec_resol":null,"7":"200","wf_tarea_id_sig":"200","8":null,"usr_asig":null,"9":null,"usr_resol":null}
2015-06 23 10:10:45
cargar datos del sujeto(,,s,91,82)
select s.*, m.nombre as nom_muni, c.nom_cat,fec_caso
from wf_caso_91 w
inner join core_sujetoverificacion s on w.id=82 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 23 10:10:45
tabla dat adic
select tabla from core_sujetoverificaciontipo where id=1
2015-06 23 10:10:45
tabla :persona
SELECT * FROM persona where id=101
fin 2015-06-23 10:10:45
/******************************************************************************************************/
2015-06-23 10:10:47TraerCaso(82,91,)
CargarCaso :82
2015-06 23 10:10:47
CargarDatos: Caso :82
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_91_seguimiento_id,wf_paso_id from wf_caso_91_pasos a1 group by wf_caso_91_seguimiento_id,wf_paso_id order by id
)a
inner join wf_caso_91_pasos p using(id,wf_caso_91_seguimiento_id)
inner join ( select max(id) as wf_caso_91_seguimiento_id,wf_caso_91_id,wf_tarea_id from wf_caso_91_seguimiento where wf_caso_91_id =? group by wf_caso_91_id,wf_tarea_id order by wf_caso_91_id,wf_caso_91_seguimiento_id ) b using(wf_caso_91_seguimiento_id)
left join usuarios u using(core_usuario_id)
{"0":"146","id":"146","1":"315","wf_paso_id":"315","2":"189","wf_caso_91_seguimiento_id":"189","3":"51","core_usuario_id":"51","4":"2015-06-23 10:09:18","fecha_ejec":"2015-06-23 10:09:18","5":"80","dato":"80","6":"sce.t41","tabla":"sce.t41","7":"197","tarea_id":"197","8":"Ruano Marcela: ciudadano","usr_ejec":"Ruano Marcela: ciudadano"}
CargarDatos_315(80)
se carga 91_197_315_41_42_4861
se carga 91_197_315_41_42_485125
{"0":"147","id":"147","1":"316","wf_paso_id":"316","2":"190","wf_caso_91_seguimiento_id":"190","3":"51","core_usuario_id":"51","4":"2015-06-23 10:09:37","fecha_ejec":"2015-06-23 10:09:37","5":"9","dato":"9","6":"sce.t38","tabla":"sce.t38","7":"198","tarea_id":"198","8":"Ruano Marcela: ciudadano","usr_ejec":"Ruano Marcela: ciudadano"}
CargarDatos_316(9)
se carga 91_198_316_38_39_4881
se carga 91_198_316_38_39_484
se carga 91_198_316_38_39_483Array
se carga 91_198_316_38_39_474dert
se carga 91_198_316_38_39_4734578
se carga 91_198_316_38_39_472125
se carga 91_198_316_38_39_4712015-06-23
se carga 91_198_316_38_39_470CENTRO
se carga 91_198_316_38_39_469CATAMBUCO
se carga 91_198_316_38_39_468DS
{"0":"148","id":"148","1":"319","wf_paso_id":"319","2":"190","wf_caso_91_seguimiento_id":"190","3":"51","core_usuario_id":"51","4":"2015-06-23 10:09:38","fecha_ejec":"2015-06-23 10:09:38","5":null,"dato":null,"6":null,"tabla":null,"7":"198","tarea_id":"198","8":"Ruano Marcela: ciudadano","usr_ejec":"Ruano Marcela: ciudadano"}
CargarDatos_319()
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_91_seguimiento a
inner join (
select max(b0.id) as id,b0.wf_caso_91_id,b0.wf_tarea_id from wf_caso_91_seguimiento b0 where b0.wf_caso_91_id =? group by b0.wf_caso_91_id,b0.wf_tarea_id order by wf_caso_91_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":"189","id":"189","1":"82","wf_caso_91_id":"82","2":"197","wf_tarea_id":"197","3":null,"core_usuario_id":null,"4":"2015-06-23 10:09:11","fec_asig":"2015-06-23 10:09:11","5":"51","core_usuario_id_resol":"51","6":"2015-06-23 10:09:18","fec_resol":"2015-06-23 10:09:18","7":"197","wf_tarea_id_sig":"197","8":null,"usr_asig":null,"9":"Ruano Marcela: ciudadano","usr_resol":"Ruano Marcela: ciudadano"}
{"0":"190","id":"190","1":"82","wf_caso_91_id":"82","2":"198","wf_tarea_id":"198","3":"51","core_usuario_id":"51","4":"2015-06-23 10:09:18","fec_asig":"2015-06-23 10:09:18","5":"51","core_usuario_id_resol":"51","6":"2015-06-23 10:09:38","fec_resol":"2015-06-23 10:09:38","7":"198","wf_tarea_id_sig":"198","8":"Ruano Marcela: ciudadano","usr_asig":"Ruano Marcela: ciudadano","9":"Ruano Marcela: ciudadano","usr_resol":"Ruano Marcela: ciudadano"}
{"0":"191","id":"191","1":"82","wf_caso_91_id":"82","2":"200","wf_tarea_id":"200","3":null,"core_usuario_id":null,"4":"2015-06-23 10:09:38","fec_asig":"2015-06-23 10:09:38","5":null,"core_usuario_id_resol":null,"6":null,"fec_resol":null,"7":"200","wf_tarea_id_sig":"200","8":null,"usr_asig":null,"9":null,"usr_resol":null}
2015-06 23 10:10:47
cargar datos del sujeto(,,s,91,82)
select s.*, m.nombre as nom_muni, c.nom_cat,fec_caso
from wf_caso_91 w
inner join core_sujetoverificacion s on w.id=82 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 23 10:10:47
tabla dat adic
select tabla from core_sujetoverificaciontipo where id=1
2015-06 23 10:10:47
tabla :persona
SELECT * FROM persona where id=101
2015-06 23 10:10:47
Continuar(s,200,322,)
EjecutarTarea_200() Verificación de la infomacion id_comp1244
38
ValidarUsuario(200):1
EjecutarPaso_322: form:17 , caso=82 id_comp 1244
Paso::Guardar(Caso:82)
Datos a guardar:
Array
(
[wf_proceso_id] => 91
[wf_paso_id] => 322
[wf_tarea_id] => 200
[wf_caso_id] => 82
[id] => 1244
[accion] => nextPaso
[reg] => s
[rta] => n
[cod_formulario2] => 17
[id_periodo] => 2015
[obs_ingreso] =>
[cod_bloque] => 18
[oid] =>
[oid_maestro] =>
[319] => 1
)
OID: 136
rta: 1 dato:136 tabla:sce.t17
CasoPaso:149
CargarDatos_322(136)
se carga 91_200_322_17_18_487
se carga 91_200_322_17_18_3191
SiguientePasoDe322: Funcion para ejecutar el siguiente paso
Condicion Tarea : 1 ==1
TerminarTarea(200,201)
Ultimo seg :191
Ultimo seg :192
EjecutarTarea_201() Solicitud exitosa id_comp1244
38 38
ValidarUsuario(201):1
EjecutarPaso_320: corr:124 , caso=82 id_comp 1244
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:Ruano
TWFSV_2:Marcela
Su solicitud de Registro y actualización de organizaciones se realizó satisfactoriamente.
{ WFSV_1 }
TWFSV_1:myriabe123@gmail.com
Solicitud exitosa en registro y actualización de organizaciones
Retorno :
Array
(
[ret] => inicioComponente_WF_Correo({"id":"1244","caso_id":"82","proceso_id":91,"tit":"Solicitud exitosa","tarea_id":201,"paso_id":320,"desc":"<p>\nApreciado(a)<br>\n<strong>MARCELA RUANO<\/strong>\n<p>\n<p>El presente mensaje es una notificación para el caso No <strong>82<\/strong> <\/p>\n<strong>Su solicitud de Registro y actualizaci\u00f3n de organizaciones se realiz\u00f3 satisfactoriamente.<\/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:'myriabe123@gmail.com',asunto:'Solicitud exitosa en registro y actualizaci\u00f3n de organizaciones'},\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-23 10:10:47
/******************************************************************************************************/
2015-06-23 10:10:49TraerCaso(82,91,)
CargarCaso :82
2015-06 23 10:10:49
CargarDatos: Caso :82
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_91_seguimiento_id,wf_paso_id from wf_caso_91_pasos a1 group by wf_caso_91_seguimiento_id,wf_paso_id order by id
)a
inner join wf_caso_91_pasos p using(id,wf_caso_91_seguimiento_id)
inner join ( select max(id) as wf_caso_91_seguimiento_id,wf_caso_91_id,wf_tarea_id from wf_caso_91_seguimiento where wf_caso_91_id =? group by wf_caso_91_id,wf_tarea_id order by wf_caso_91_id,wf_caso_91_seguimiento_id ) b using(wf_caso_91_seguimiento_id)
left join usuarios u using(core_usuario_id)
{"0":"146","id":"146","1":"315","wf_paso_id":"315","2":"189","wf_caso_91_seguimiento_id":"189","3":"51","core_usuario_id":"51","4":"2015-06-23 10:09:18","fecha_ejec":"2015-06-23 10:09:18","5":"80","dato":"80","6":"sce.t41","tabla":"sce.t41","7":"197","tarea_id":"197","8":"Ruano Marcela: ciudadano","usr_ejec":"Ruano Marcela: ciudadano"}
CargarDatos_315(80)
se carga 91_197_315_41_42_4861
se carga 91_197_315_41_42_485125
{"0":"147","id":"147","1":"316","wf_paso_id":"316","2":"190","wf_caso_91_seguimiento_id":"190","3":"51","core_usuario_id":"51","4":"2015-06-23 10:09:37","fecha_ejec":"2015-06-23 10:09:37","5":"9","dato":"9","6":"sce.t38","tabla":"sce.t38","7":"198","tarea_id":"198","8":"Ruano Marcela: ciudadano","usr_ejec":"Ruano Marcela: ciudadano"}
CargarDatos_316(9)
se carga 91_198_316_38_39_4881
se carga 91_198_316_38_39_484
se carga 91_198_316_38_39_483Array
se carga 91_198_316_38_39_474dert
se carga 91_198_316_38_39_4734578
se carga 91_198_316_38_39_472125
se carga 91_198_316_38_39_4712015-06-23
se carga 91_198_316_38_39_470CENTRO
se carga 91_198_316_38_39_469CATAMBUCO
se carga 91_198_316_38_39_468DS
{"0":"148","id":"148","1":"319","wf_paso_id":"319","2":"190","wf_caso_91_seguimiento_id":"190","3":"51","core_usuario_id":"51","4":"2015-06-23 10:09:38","fecha_ejec":"2015-06-23 10:09:38","5":null,"dato":null,"6":null,"tabla":null,"7":"198","tarea_id":"198","8":"Ruano Marcela: ciudadano","usr_ejec":"Ruano Marcela: ciudadano"}
CargarDatos_319()
{"0":"149","id":"149","1":"322","wf_paso_id":"322","2":"191","wf_caso_91_seguimiento_id":"191","3":"38","core_usuario_id":"38","4":"2015-06-23 10:10:47","fecha_ejec":"2015-06-23 10:10:47","5":"136","dato":"136","6":"sce.t17","tabla":"sce.t17","7":"200","tarea_id":"200","8":"secretaria operador : gerente","usr_ejec":"secretaria operador : gerente"}
CargarDatos_322(136)
se carga 91_200_322_17_18_487
se carga 91_200_322_17_18_3191
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_91_seguimiento a
inner join (
select max(b0.id) as id,b0.wf_caso_91_id,b0.wf_tarea_id from wf_caso_91_seguimiento b0 where b0.wf_caso_91_id =? group by b0.wf_caso_91_id,b0.wf_tarea_id order by wf_caso_91_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":"189","id":"189","1":"82","wf_caso_91_id":"82","2":"197","wf_tarea_id":"197","3":null,"core_usuario_id":null,"4":"2015-06-23 10:09:11","fec_asig":"2015-06-23 10:09:11","5":"51","core_usuario_id_resol":"51","6":"2015-06-23 10:09:18","fec_resol":"2015-06-23 10:09:18","7":"197","wf_tarea_id_sig":"197","8":null,"usr_asig":null,"9":"Ruano Marcela: ciudadano","usr_resol":"Ruano Marcela: ciudadano"}
{"0":"190","id":"190","1":"82","wf_caso_91_id":"82","2":"198","wf_tarea_id":"198","3":"51","core_usuario_id":"51","4":"2015-06-23 10:09:18","fec_asig":"2015-06-23 10:09:18","5":"51","core_usuario_id_resol":"51","6":"2015-06-23 10:09:38","fec_resol":"2015-06-23 10:09:38","7":"198","wf_tarea_id_sig":"198","8":"Ruano Marcela: ciudadano","usr_asig":"Ruano Marcela: ciudadano","9":"Ruano Marcela: ciudadano","usr_resol":"Ruano Marcela: ciudadano"}
{"0":"191","id":"191","1":"82","wf_caso_91_id":"82","2":"200","wf_tarea_id":"200","3":null,"core_usuario_id":null,"4":"2015-06-23 10:09:38","fec_asig":"2015-06-23 10:09:38","5":"38","core_usuario_id_resol":"38","6":"2015-06-23 10:10:47","fec_resol":"2015-06-23 10:10:47","7":"200","wf_tarea_id_sig":"200","8":null,"usr_asig":null,"9":"secretaria operador : gerente","usr_resol":"secretaria operador : gerente"}
{"0":"192","id":"192","1":"82","wf_caso_91_id":"82","2":"201","wf_tarea_id":"201","3":"38","core_usuario_id":"38","4":"2015-06-23 10:10:47","fec_asig":"2015-06-23 10:10:47","5":null,"core_usuario_id_resol":null,"6":null,"fec_resol":null,"7":"201","wf_tarea_id_sig":"201","8":"secretaria operador : gerente","usr_asig":"secretaria operador : gerente","9":null,"usr_resol":null}
2015-06 23 10:10:49
cargar datos del sujeto(,,s,91,82)
select s.*, m.nombre as nom_muni, c.nom_cat,fec_caso
from wf_caso_91 w
inner join core_sujetoverificacion s on w.id=82 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 23 10:10:49
tabla dat adic
select tabla from core_sujetoverificaciontipo where id=1
2015-06 23 10:10:49
tabla :persona
SELECT * FROM persona where id=101
2015-06 23 10:10:49
Continuar(s,201,320,)
EjecutarTarea_201() Solicitud exitosa id_comp1244
38 38
ValidarUsuario(201):1
EjecutarPaso_320: corr:124 , caso=82 id_comp 1244
Paso::Guardar(Caso:82)
rta: 1 dato: tabla:
CasoPaso:150
CargarDatos_320()
SiguientePasoDe320: Funcion para ejecutar el siguiente paso
EjecutarPaso_328: docs:128 , caso=82 id_comp 1244
Mostrar docs
$tit_formato='REGISTRO Y ACTUALIZACIÓN DE ORGANIZACIONES';
$nombre= ' 91_198_316_38_39_468 ';
$coreej= ' 91_198_316_38_39_469 ';
$vereda= ' 91_198_316_38_39_470 ';
$fecha= ' 91_198_316_38_39_471 ';
$nit= ' 91_198_316_38_39_472 ';
$pers= ' 91_198_316_38_39_473 ';
$act= ' 91_198_316_38_39_474 ';
$tipo_per= ' 91_198_316_38_39_488 ';
$f=split("-",$fecha);
if ($f[1]==1) $f[1]="Enero";
if ($f[1]==2) $f[1]="Febrero";
if ($f[1]==3) $f[1]="Marzo";
if ($f[1]==4) $f[1]="Abril";
if ($f[1]==5) $f[1]="Mayo";
if ($f[1]==6) $f[1]="Junio";
if ($f[1]==7) $f[1]="Julio";
if ($f[1]==8) $f[1]="Agosto";
if ($f[1]==9) $f[1]="Setiembre";
if ($f[1]==10) $f[1]="Octubre";
if ($f[1]==11) $f[1]="Noviembre";
if ($f[1]==12) $f[1]="Diciembre";
require_once($root.'/lib/tcpdf/config/lang/eng.php');
require_once($root.'/lib/tcpdf/tcpdf.php');
//--------------------------------------------------------------------------
class MYPDF extends TCPDF {
//Page header
public function Header() {
// Logo
//echo str_replace('$root_js',$root_js,$CONFIG['CABECERA_FORMATOS_HTML']);
$cab=$CONFIG['CABECERA_REPORTES'];
$h="'".str_replace(array('$root_js','_LOGO_','_TITULO_','_CODFORM_','_VERSION_','_FECHAACTUAL_','border="1"'),
array($root_js,$root_js.$CONFIG['LOGO_REPORTES'],'BANCO DE PROGRAMAS Y PROYECTOS DE INVERSIÓN DEPARTAMENTAL',' BPI-FVR01',' 01',' 03-12-2014','border="1" bordercolor="#000000"'),
$cab)."'";
$image_file = K_PATH_IMAGES.'logo_alcaldia.jpg';
$htm='<table width="100%" height="5%" border="1" cellpadding="0" cellspacing="0">
<tr>
<td width="20%" rowspan="3" align="center"><img src="'.$image_file.'" alt="a" height="74" /></td>
<td colspan="4" align="center"><strong>PROCESO COMPETITIVIDAD Y PRODUCTIVIDAD</strong></td>
</tr>
<tr>
<td colspan="4" ><p><strong>NOMBRE DEL FORMATO:</strong><br>
<center>ACTUALIZACIÓN DE ORGANIZACIONES </center></p></td>
</tr>
<tr>
<td width="20%" align="center"><p><strong>VIGENCIA</strong><br>30-octubre- 13</p></td>
<td width="20%" align="center"><p><strong>VERSIÓN</strong><br>01</p></td>
<td width="20%" align="center"><p><strong>CÓDIGO</strong><br>CP-F-006</p></td>
<td width="20%" align="center"><strong>CONSECUTIVO</strong></td>
</tr>
</table>';
$this->writeHTMLCell($w = 0, $h = 0, $x = '', $y = '', $htm, $border = 0, $ln = 1, $fill = 0, $reseth = true, $align = 'top', $autopadding = true);
}
// Page footer
public function Footer() {
// Position at 15 mm from bottom
$this->SetY(-15);
// Set font
$this->SetFont('helvetica', 'I', 8);
// Page number
$this->Cell(0, 10, '', 0, false, 'C', 0, '', 0, false, 'T', 'M');
}
}
//--------------------------------------------------------------------------
// create new PDF document
$pdf = new MYPDF('p', 'mm', 'letter', true, 'UTF-8', false);
// set document information
$pdf->SetCreator(PDF_CREATOR);
$pdf->SetAuthor('Siti');
$pdf->SetTitle('REGISTRO Y ACTUALIZACIÓN DE ORGANIZACIONES');
$pdf->SetSubject('Certificado');
$pdf->SetKeywords('TCPDF, PDF, example, test, guide');
// set default header data
$pdf->SetHeaderData(PDF_HEADER_LOGO, PDF_HEADER_LOGO_WIDTH, PDF_HEADER_TITLE, PDF_HEADER_STRING);
// set header and footer fonts
$pdf->setHeaderFont(Array(PDF_FONT_NAME_MAIN, '', PDF_FONT_SIZE_MAIN));
$pdf->setFooterFont(Array(PDF_FONT_NAME_DATA, '', PDF_FONT_SIZE_DATA));
// set default monospaced font
$pdf->SetDefaultMonospacedFont(PDF_FONT_MONOSPACED);
// set margins
$pdf->SetMargins(PDF_MARGIN_LEFT, PDF_MARGIN_TOP, PDF_MARGIN_RIGHT);
$pdf->SetHeaderMargin(PDF_MARGIN_HEADER);
$pdf->SetFooterMargin(PDF_MARGIN_FOOTER);
// set auto page breaks
$pdf->SetAutoPageBreak(TRUE, PDF_MARGIN_BOTTOM);
// set image scale factor
$pdf->setImageScale(PDF_IMAGE_SCALE_RATIO);
//set some language-dependent strings
$pdf->setLanguageArray($l);
// ---------------------------------------------------------
// NOTE: 2D barcode algorithms must be implemented on 2dbarcode.php class file.
// set font
$pdf->SetFont('helvetica', '', 10);
// add a page
$pdf->AddPage();
// - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
$fils=4;
$cols=3;
$logo_empresa=$CONFIG['LOGO_EMPRESA'];
$codigo=$root_js.'build/view/common/marco/index.php?particular=001&accion=I&proc='.$CONFIG['PROCESO_STICKER'];
$izq=10+2;$der=10;$arr=10; $abj=10;
$sxp=$fils*$cols;
$tot=$rangoF-$rangoI+1;
$pags=ceil(($tot)/$sxp);
$anchoR=216-$izq-$der;
$altoR=279-$arr-$abj;
$anchoS=$anchoR/$cols;
$margenSV=2;
$margenSH=5;
$altoS=$altoR/$fils;
$altoImg=10;
$altoText=8;
$altoC=50;
// set style for barcode
$style = array(
'border' => 2,
'vpadding' => 'auto',
'hpadding' => 'auto',
'fgcolor' => array(0,0,0),
'bgcolor' => false, //array(255,255,255)
'module_width' => 1, // width of a single module in points
'module_height' => 1 // height of a single module in points
);
$pdf->SetFont('helvetica', '', 9, '', false);
$pdf->SetDefaultMonospacedFont(PDF_FONT_MONOSPACED);
$s=0;$p=1;$consc=$rangoI;
$y=$arr;
$x=$izq;
// create some HTML content
ob_start();
//echo str_replace('$root_js',$root_js,$CONFIG['CABECERA_FORMATOS_HTML']);
?>
<br /><br /><br /><br />
<table width="100%" border="1" cellpadding="0" cellspacing="0" bordercolor="#000000">
<tr>
<td width="25%"><strong>Nombre de la organización:</strong></td>
<td colspan="3"><? echo $nombre; ?></td>
</tr>
<tr>
<td><strong>Corregimiento:</strong></td>
<td width="25%"><? echo $coreej; ?></td>
<td width="25%"><strong>Vereda:</strong></td>
<td width="25%"><? echo $vereda; ?></td>
</tr>
<tr>
<td><strong>Fecha de actualización:</strong></td>
<td><? echo $f[2]." de ".$f[1]." de ".$f[0]; ?></td>
<td colspan="2"> </td>
</tr>
<tr>
<td><strong>Pesoneria JurÃdica</strong></td>
<td><? echo $pers; ?></td>
<td><strong>Nit-RUT:</strong></td>
<td><? echo $nit; ?></td>
</tr>
<tr>
<td><strong>Actividades Principales:</strong></td>
<td colspan="3"><? echo $act; ?></td>
</tr>
</table>
<table width="100%" border="1">
<tr>
<td colspan="4" align="center"><strong>JUNTA DIRECTIVA</strong></td>
</tr>
<tr>
<td width="25%" align="center"><strong>Cargo</strong></td>
<td width="25%" align="center"><strong>Nombres y Apellidos</strong></td>
<td width="25%" align="center"><strong>Documento de identidad</strong></td>
<td width="25%" align="center"><strong>Teléfono</strong></td>
</tr>
<?
if(is_array($this->V91_198_316_38_39_483) && count($this->V91_198_316_38_39_483)>0){
$c=0;
if(count($this->V91_198_316_38_39_483)==1){
?>
<tr>
<td height="29"> <?php echo $this->V91_198_316_38_39_483[$c]['txtgcargo']?></td>
<td align="center"><?php echo $this->V91_198_316_38_39_483[$c]['txtnomcom']?></td>
<td align="center"><?php echo $this->V91_198_316_38_39_483[$c]['txtdociden']?></td>
<td><?php echo $this->V91_198_316_38_39_483[$c]['txtgtel']; ?></td>
</tr>
<? }else{
$t=array();
while((floor(count($this->V91_198_316_38_39_483)/2))+1 !=$c){
?>
<tr>
<td> <?php echo $this->V91_198_316_38_39_483[$c]['txtgcargo']?></td>
<td><?php echo $this->V91_198_316_38_39_483[$c]['txtnomcom']?></td>
<td><?php echo $this->V91_198_316_38_39_483[$c]['txtdociden']?></td>
<td><?php echo $this->V91_198_316_38_39_483[$c]['txtgtel']; ?></td>
</tr>
<? $c++;
}
}
}
?>
</table>
<table width="100%" border="1">
<tr>
<td colspan="6" align="center"><strong>LISTADO DE SOCIOS ACTIVOS</strong></td>
</tr>
<tr>
<td width="10%" rowspan="2" align="center"><strong>No.</strong></td>
<td width="30%" rowspan="2" align="center"><strong>Nombres y Apellidos</strong></td>
<td width="20%" colspan="2" align="center"><strong>Genero</strong></td>
<td width="20%" rowspan="2" align="center"><strong>Documento de identidad</strong></td>
<td width="20%" rowspan="2" align="center"><strong>Teléfono</strong></td>
</tr>
<tr>
<td><strong>Femenino</strong></td>
<td><strong>Masculino</strong></td>
</tr>
<?
if(is_array($this->V91_198_316_38_39_484) && count($this->V91_198_316_38_39_484)>0){
$c=0;
if(count($this->V91_198_316_38_39_484)==1){
?>
<tr>
<td><? echo $c+1;?></td>
<td width="30%"><?php echo $this->V91_198_316_38_39_484[$c]['txtsnom']?></td>
<td><?php if($this->V91_198_316_38_39_484[$c]['cmbsgen']==2) echo "X";?></td>
<td><?php if($this->V91_198_316_38_39_484[$c]['cmbsgen']==1) echo "X";?></td>
<td><?php echo $this->V91_198_316_38_39_484[$c]['txtsced']?></td>
<td><?php echo $this->V91_198_316_38_39_484[$c]['txtstel']?></td>
</tr>
<?
}else{
$t=array();
while((floor(count($this->V91_198_316_38_39_484)/2))+1 !=$c){
?>
<tr>
<td><? echo $c+1; ?></td>
<td><?php echo $this->V91_198_316_38_39_484[$c]['txtsnom']?></td>
<td><?php if($this->V91_198_316_38_39_484[$c]['cmbsgen']==2) echo "X";?></td>
<td><?php if($this->V91_198_316_38_39_484[$c]['cmbsgen']==1) echo "X";?></td>
<td><?php echo $this->V91_198_316_38_39_484[$c]['txtsced']?></td>
<td><?php echo $this->V91_198_316_38_39_484[$c]['txtstel']?></td>
</tr>
<? $c++;
}
}
}
?>
</table>
<br />
<?
$mes=date("F");
if ($mes=="January") $mes="Enero";
if ($mes=="February") $mes="Febrero";
if ($mes=="March") $mes="Marzo";
if ($mes=="April") $mes="Abril";
if ($mes=="May") $mes="Mayo";
if ($mes=="June") $mes="Junio";
if ($mes=="July") $mes="Julio";
if ($mes=="August") $mes="Agosto";
if ($mes=="September") $mes="Setiembre";
if ($mes=="October") $mes="Octubre";
if ($mes=="November") $mes="Noviembre";
if ($mes=="December") $mes="Diciembre";
$anio=date("Y");
$html=ob_get_clean();
// output the HTML content
$pdf->writeHTML($html, true, false,false,false);
// reset pointer to the last page
$pdf->lastPage();//---
//----
$nomdoc=md5(time()).'.pdf';
$pdf->Output($root."/tmp/".$nomdoc, 'F');
$url=$root_js.'tmp/'.$nomdoc;
T91_198_316_38_39_488:Presidente
T91_198_316_38_39_484: <table width="99%" cellspacing="0"
border="0" class="x-grid3-row">
</table>
T91_198_316_38_39_484: <table width="99%" cellspacing="0"
border="0" class="x-grid3-row">
</table>
T91_198_316_38_39_484: <table width="99%" cellspacing="0"
border="0" class="x-grid3-row">
</table>
T91_198_316_38_39_484: <table width="99%" cellspacing="0"
border="0" class="x-grid3-row">
</table>
T91_198_316_38_39_484: <table width="99%" cellspacing="0"
border="0" class="x-grid3-row">
</table>
T91_198_316_38_39_484: <table width="99%" cellspacing="0"
border="0" class="x-grid3-row">
</table>
T91_198_316_38_39_484: <table width="99%" cellspacing="0"
border="0" class="x-grid3-row">
</table>
T91_198_316_38_39_484: <table width="99%" cellspacing="0"
border="0" class="x-grid3-row">
</table>
T91_198_316_38_39_484: <table width="99%" cellspacing="0"
border="0" class="x-grid3-row">
</table>
T91_198_316_38_39_484: <table width="99%" cellspacing="0"
border="0" class="x-grid3-row">
</table>
T91_198_316_38_39_484: <table width="99%" cellspacing="0"
border="0" class="x-grid3-row">
</table>
T91_198_316_38_39_484: <table width="99%" cellspacing="0"
border="0" class="x-grid3-row">
</table>
T91_198_316_38_39_484: <table width="99%" cellspacing="0"
border="0" class="x-grid3-row">
</table>
T91_198_316_38_39_484: <table width="99%" cellspacing="0"
border="0" class="x-grid3-row">
</table>
T91_198_316_38_39_483: <table width="99%" cellspacing="0"
border="0" class="x-grid3-row">
<tr>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;">Presidente</td>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;">Marcela Ruano</td>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;">5344308</td>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;">3122556647</td>
</tr>
<tr>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;">Vicepresidente</td>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;"> </td>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;"> </td>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;"> </td>
</tr>
<tr>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;">Secretaria(o)</td>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;"> </td>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;"> </td>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;"> </td>
</tr>
<tr>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;">Tesorero</td>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;"> </td>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;"> </td>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;"> </td>
</tr>
</table>
T91_198_316_38_39_483: <table width="99%" cellspacing="0"
border="0" class="x-grid3-row">
<tr>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;">Presidente</td>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;">Marcela Ruano</td>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;">5344308</td>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;">3122556647</td>
</tr>
<tr>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;">Vicepresidente</td>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;"> </td>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;"> </td>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;"> </td>
</tr>
<tr>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;">Secretaria(o)</td>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;"> </td>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;"> </td>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;"> </td>
</tr>
<tr>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;">Tesorero</td>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;"> </td>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;"> </td>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;"> </td>
</tr>
</table>
T91_198_316_38_39_483: <table width="99%" cellspacing="0"
border="0" class="x-grid3-row">
<tr>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;">Presidente</td>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;">Marcela Ruano</td>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;">5344308</td>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;">3122556647</td>
</tr>
<tr>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;">Vicepresidente</td>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;"> </td>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;"> </td>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;"> </td>
</tr>
<tr>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;">Secretaria(o)</td>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;"> </td>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;"> </td>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;"> </td>
</tr>
<tr>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;">Tesorero</td>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;"> </td>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;"> </td>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;"> </td>
</tr>
</table>
T91_198_316_38_39_483: <table width="99%" cellspacing="0"
border="0" class="x-grid3-row">
<tr>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;">Presidente</td>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;">Marcela Ruano</td>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;">5344308</td>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;">3122556647</td>
</tr>
<tr>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;">Vicepresidente</td>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;"> </td>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;"> </td>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;"> </td>
</tr>
<tr>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;">Secretaria(o)</td>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;"> </td>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;"> </td>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;"> </td>
</tr>
<tr>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;">Tesorero</td>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;"> </td>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;"> </td>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;"> </td>
</tr>
</table>
T91_198_316_38_39_483: <table width="99%" cellspacing="0"
border="0" class="x-grid3-row">
<tr>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;">Presidente</td>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;">Marcela Ruano</td>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;">5344308</td>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;">3122556647</td>
</tr>
<tr>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;">Vicepresidente</td>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;"> </td>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;"> </td>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;"> </td>
</tr>
<tr>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;">Secretaria(o)</td>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;"> </td>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;"> </td>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;"> </td>
</tr>
<tr>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;">Tesorero</td>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;"> </td>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;"> </td>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;"> </td>
</tr>
</table>
T91_198_316_38_39_483: <table width="99%" cellspacing="0"
border="0" class="x-grid3-row">
<tr>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;">Presidente</td>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;">Marcela Ruano</td>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;">5344308</td>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;">3122556647</td>
</tr>
<tr>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;">Vicepresidente</td>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;"> </td>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;"> </td>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;"> </td>
</tr>
<tr>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;">Secretaria(o)</td>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;"> </td>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;"> </td>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;"> </td>
</tr>
<tr>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;">Tesorero</td>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;"> </td>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;"> </td>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;"> </td>
</tr>
</table>
T91_198_316_38_39_483: <table width="99%" cellspacing="0"
border="0" class="x-grid3-row">
<tr>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;">Presidente</td>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;">Marcela Ruano</td>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;">5344308</td>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;">3122556647</td>
</tr>
<tr>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;">Vicepresidente</td>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;"> </td>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;"> </td>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;"> </td>
</tr>
<tr>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;">Secretaria(o)</td>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;"> </td>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;"> </td>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;"> </td>
</tr>
<tr>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;">Tesorero</td>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;"> </td>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;"> </td>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;"> </td>
</tr>
</table>
T91_198_316_38_39_483: <table width="99%" cellspacing="0"
border="0" class="x-grid3-row">
<tr>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;">Presidente</td>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;">Marcela Ruano</td>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;">5344308</td>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;">3122556647</td>
</tr>
<tr>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;">Vicepresidente</td>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;"> </td>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;"> </td>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;"> </td>
</tr>
<tr>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;">Secretaria(o)</td>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;"> </td>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;"> </td>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;"> </td>
</tr>
<tr>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;">Tesorero</td>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;"> </td>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;"> </td>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;"> </td>
</tr>
</table>
T91_198_316_38_39_483: <table width="99%" cellspacing="0"
border="0" class="x-grid3-row">
<tr>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;">Presidente</td>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;">Marcela Ruano</td>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;">5344308</td>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;">3122556647</td>
</tr>
<tr>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;">Vicepresidente</td>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;"> </td>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;"> </td>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;"> </td>
</tr>
<tr>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;">Secretaria(o)</td>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;"> </td>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;"> </td>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;"> </td>
</tr>
<tr>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;">Tesorero</td>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;"> </td>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;"> </td>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;"> </td>
</tr>
</table>
T91_198_316_38_39_483: <table width="99%" cellspacing="0"
border="0" class="x-grid3-row">
<tr>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;">Presidente</td>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;">Marcela Ruano</td>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;">5344308</td>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;">3122556647</td>
</tr>
<tr>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;">Vicepresidente</td>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;"> </td>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;"> </td>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;"> </td>
</tr>
<tr>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;">Secretaria(o)</td>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;"> </td>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;"> </td>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;"> </td>
</tr>
<tr>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;">Tesorero</td>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;"> </td>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;"> </td>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;"> </td>
</tr>
</table>
T91_198_316_38_39_483: <table width="99%" cellspacing="0"
border="0" class="x-grid3-row">
<tr>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;">Presidente</td>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;">Marcela Ruano</td>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;">5344308</td>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;">3122556647</td>
</tr>
<tr>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;">Vicepresidente</td>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;"> </td>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;"> </td>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;"> </td>
</tr>
<tr>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;">Secretaria(o)</td>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;"> </td>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;"> </td>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;"> </td>
</tr>
<tr>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;">Tesorero</td>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;"> </td>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;"> </td>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;"> </td>
</tr>
</table>
T91_198_316_38_39_483: <table width="99%" cellspacing="0"
border="0" class="x-grid3-row">
<tr>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;">Presidente</td>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;">Marcela Ruano</td>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;">5344308</td>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;">3122556647</td>
</tr>
<tr>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;">Vicepresidente</td>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;"> </td>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;"> </td>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;"> </td>
</tr>
<tr>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;">Secretaria(o)</td>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;"> </td>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;"> </td>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;"> </td>
</tr>
<tr>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;">Tesorero</td>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;"> </td>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;"> </td>
<td align="left" class="x-grid3-cell" style="font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size:12px;"> </td>
</tr>
</table>
T91_198_316_38_39_474:dert
T91_198_316_38_39_473:4578
T91_198_316_38_39_472:125
T91_198_316_38_39_471:2015-06-23
T91_198_316_38_39_470:CENTRO
T91_198_316_38_39_469:CATAMBUCO
T91_198_316_38_39_468:DS
Retorno :
Array
(
[ret] => inicioComponente_WF_DocSalida({"id":"1244","caso_id":"82","proceso_id":91,"tit":"Solicitud exitosa","tarea_id":201,"paso_id":328,"desc":"<strong>Registo y modificaci\u00f3n <\/strong>: ","url":"<a href=\"http:\/\/192.168.10.116\/sisad\/tmp\/ab58a238ea72183ef1a2e0b91294e254.pdf\" target=\"_blank\" >De clic aqui para descargar el archivo<\/a><\/div>"});
[suc] => 1
)
fin 2015-06-23 10:10:49
/******************************************************************************************************/
2015-06-23 10:10:52TraerCaso(82,91,)
CargarCaso :82
2015-06 23 10:10:52
CargarDatos: Caso :82
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_91_seguimiento_id,wf_paso_id from wf_caso_91_pasos a1 group by wf_caso_91_seguimiento_id,wf_paso_id order by id
)a
inner join wf_caso_91_pasos p using(id,wf_caso_91_seguimiento_id)
inner join ( select max(id) as wf_caso_91_seguimiento_id,wf_caso_91_id,wf_tarea_id from wf_caso_91_seguimiento where wf_caso_91_id =? group by wf_caso_91_id,wf_tarea_id order by wf_caso_91_id,wf_caso_91_seguimiento_id ) b using(wf_caso_91_seguimiento_id)
left join usuarios u using(core_usuario_id)
{"0":"146","id":"146","1":"315","wf_paso_id":"315","2":"189","wf_caso_91_seguimiento_id":"189","3":"51","core_usuario_id":"51","4":"2015-06-23 10:09:18","fecha_ejec":"2015-06-23 10:09:18","5":"80","dato":"80","6":"sce.t41","tabla":"sce.t41","7":"197","tarea_id":"197","8":"Ruano Marcela: ciudadano","usr_ejec":"Ruano Marcela: ciudadano"}
CargarDatos_315(80)
se carga 91_197_315_41_42_4861
se carga 91_197_315_41_42_485125
{"0":"147","id":"147","1":"316","wf_paso_id":"316","2":"190","wf_caso_91_seguimiento_id":"190","3":"51","core_usuario_id":"51","4":"2015-06-23 10:09:37","fecha_ejec":"2015-06-23 10:09:37","5":"9","dato":"9","6":"sce.t38","tabla":"sce.t38","7":"198","tarea_id":"198","8":"Ruano Marcela: ciudadano","usr_ejec":"Ruano Marcela: ciudadano"}
CargarDatos_316(9)
se carga 91_198_316_38_39_4881
se carga 91_198_316_38_39_484
se carga 91_198_316_38_39_483Array
se carga 91_198_316_38_39_474dert
se carga 91_198_316_38_39_4734578
se carga 91_198_316_38_39_472125
se carga 91_198_316_38_39_4712015-06-23
se carga 91_198_316_38_39_470CENTRO
se carga 91_198_316_38_39_469CATAMBUCO
se carga 91_198_316_38_39_468DS
{"0":"148","id":"148","1":"319","wf_paso_id":"319","2":"190","wf_caso_91_seguimiento_id":"190","3":"51","core_usuario_id":"51","4":"2015-06-23 10:09:38","fecha_ejec":"2015-06-23 10:09:38","5":null,"dato":null,"6":null,"tabla":null,"7":"198","tarea_id":"198","8":"Ruano Marcela: ciudadano","usr_ejec":"Ruano Marcela: ciudadano"}
CargarDatos_319()
{"0":"149","id":"149","1":"322","wf_paso_id":"322","2":"191","wf_caso_91_seguimiento_id":"191","3":"38","core_usuario_id":"38","4":"2015-06-23 10:10:47","fecha_ejec":"2015-06-23 10:10:47","5":"136","dato":"136","6":"sce.t17","tabla":"sce.t17","7":"200","tarea_id":"200","8":"secretaria operador : gerente","usr_ejec":"secretaria operador : gerente"}
CargarDatos_322(136)
se carga 91_200_322_17_18_487
se carga 91_200_322_17_18_3191
{"0":"150","id":"150","1":"320","wf_paso_id":"320","2":"192","wf_caso_91_seguimiento_id":"192","3":"38","core_usuario_id":"38","4":"2015-06-23 10:10:49","fecha_ejec":"2015-06-23 10:10:49","5":null,"dato":null,"6":null,"tabla":null,"7":"201","tarea_id":"201","8":"secretaria operador : gerente","usr_ejec":"secretaria operador : gerente"}
CargarDatos_320()
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_91_seguimiento a
inner join (
select max(b0.id) as id,b0.wf_caso_91_id,b0.wf_tarea_id from wf_caso_91_seguimiento b0 where b0.wf_caso_91_id =? group by b0.wf_caso_91_id,b0.wf_tarea_id order by wf_caso_91_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":"189","id":"189","1":"82","wf_caso_91_id":"82","2":"197","wf_tarea_id":"197","3":null,"core_usuario_id":null,"4":"2015-06-23 10:09:11","fec_asig":"2015-06-23 10:09:11","5":"51","core_usuario_id_resol":"51","6":"2015-06-23 10:09:18","fec_resol":"2015-06-23 10:09:18","7":"197","wf_tarea_id_sig":"197","8":null,"usr_asig":null,"9":"Ruano Marcela: ciudadano","usr_resol":"Ruano Marcela: ciudadano"}
{"0":"190","id":"190","1":"82","wf_caso_91_id":"82","2":"198","wf_tarea_id":"198","3":"51","core_usuario_id":"51","4":"2015-06-23 10:09:18","fec_asig":"2015-06-23 10:09:18","5":"51","core_usuario_id_resol":"51","6":"2015-06-23 10:09:38","fec_resol":"2015-06-23 10:09:38","7":"198","wf_tarea_id_sig":"198","8":"Ruano Marcela: ciudadano","usr_asig":"Ruano Marcela: ciudadano","9":"Ruano Marcela: ciudadano","usr_resol":"Ruano Marcela: ciudadano"}
{"0":"191","id":"191","1":"82","wf_caso_91_id":"82","2":"200","wf_tarea_id":"200","3":null,"core_usuario_id":null,"4":"2015-06-23 10:09:38","fec_asig":"2015-06-23 10:09:38","5":"38","core_usuario_id_resol":"38","6":"2015-06-23 10:10:47","fec_resol":"2015-06-23 10:10:47","7":"200","wf_tarea_id_sig":"200","8":null,"usr_asig":null,"9":"secretaria operador : gerente","usr_resol":"secretaria operador : gerente"}
{"0":"192","id":"192","1":"82","wf_caso_91_id":"82","2":"201","wf_tarea_id":"201","3":"38","core_usuario_id":"38","4":"2015-06-23 10:10:47","fec_asig":"2015-06-23 10:10:47","5":null,"core_usuario_id_resol":null,"6":null,"fec_resol":null,"7":"201","wf_tarea_id_sig":"201","8":"secretaria operador : gerente","usr_asig":"secretaria operador : gerente","9":null,"usr_resol":null}
2015-06 23 10:10:52
cargar datos del sujeto(,,s,91,82)
select s.*, m.nombre as nom_muni, c.nom_cat,fec_caso
from wf_caso_91 w
inner join core_sujetoverificacion s on w.id=82 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 23 10:10:52
tabla dat adic
select tabla from core_sujetoverificaciontipo where id=1
2015-06 23 10:10:52
tabla :persona
SELECT * FROM persona where id=101
2015-06 23 10:10:52
Continuar(s,201,328,)
EjecutarTarea_201() Solicitud exitosa id_comp1244
38 38
ValidarUsuario(201):1
EjecutarPaso_328: docs:128 , caso=82 id_comp 1244
Paso::Guardar(Caso:82)
rta: 1 dato:134 tabla:core_upload
CasoPaso:151
CargarDatos_328(134)
SiguientePasoDe328: Funcion para ejecutar el siguiente paso
TerminarTarea(201,)
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_1244').funcionInicial('n');
)
fin 2015-06-23 10:10:52
/******************************************************************************************************/