2015-07 29 12:11:01 Nuevo(3,1) Caso :73 2015-07 29 12:11:02 cargar datos del sujeto(,,s,87,73) select s.*, m.nombre as nom_muni, c.nom_cat,fec_caso from wf_caso_87 w inner join core_sujetoverificacion s on w.id=73 AND s.id =w.core_sujetoverificacion_id inner join plan_municipio m on s.plan_municipio_id=m.id inner join core_sujetocategoria c on s.core_sujetocategoria_id=c.id 2015-07 29 12:11:02 tabla dat adic select tabla from core_sujetoverificaciontipo where id=1 2015-07 29 12:11:02 tabla :persona SELECT * FROM persona where id=3 CasoSeguimiento :268 EjecutarTarea_162() Tipo fromulario id_comp1230 11 ValidarUsuario(162):1 EjecutarPaso_277: form:33 , caso=73 id_comp 1230 Mostrar form fin 2015-07-29 12:11:02 /******************************************************************************************************/ 2015-07-29 12:11:02TraerCaso(73,87,) CargarCaso :73 2015-07 29 12:11:02 CargarDatos: Caso :73 cargar datos de ejecucion de los ultimos pasos select p.*,b.wf_tarea_id as tarea_id, u.apellido||' '||u.nombre|| ': '||u.cargo as usr_ejec from (select max(id) as id, wf_caso_87_seguimiento_id,wf_paso_id from wf_caso_87_pasos a1 group by wf_caso_87_seguimiento_id,wf_paso_id order by id )a inner join wf_caso_87_pasos p using(id,wf_caso_87_seguimiento_id) inner join ( select max(id) as wf_caso_87_seguimiento_id,wf_caso_87_id,wf_tarea_id from wf_caso_87_seguimiento where wf_caso_87_id =? group by wf_caso_87_id,wf_tarea_id order by wf_caso_87_id,wf_caso_87_seguimiento_id ) b using(wf_caso_87_seguimiento_id) left join usuarios u using(core_usuario_id) Error : cargar datos de ejecucion de las tareas (las ultimas si el proceso tiene ciclos) select a.*, u.apellido||' '||u.nombre|| ': '||u.cargo as usr_asig , ur.apellido||' '||ur.nombre|| ': '||ur.cargo as usr_resol from wf_caso_87_seguimiento a inner join ( select max(b0.id) as id,b0.wf_caso_87_id,b0.wf_tarea_id from wf_caso_87_seguimiento b0 where b0.wf_caso_87_id =? group by b0.wf_caso_87_id,b0.wf_tarea_id order by wf_caso_87_id,id ) b using(id) left join usuarios u using(core_usuario_id) left join usuarios ur on ur.core_usuario_id=core_usuario_id_resol {"0":"268","id":"268","1":"73","wf_caso_87_id":"73","2":"162","wf_tarea_id":"162","3":null,"core_usuario_id":null,"4":"2015-07-29 12:11:02","fec_asig":"2015-07-29 12:11:02","5":null,"core_usuario_id_resol":null,"6":null,"fec_resol":null,"7":"162","wf_tarea_id_sig":"162","8":null,"usr_asig":null,"9":null,"usr_resol":null} 2015-07 29 12:11:02 cargar datos del sujeto(,,s,87,73) select s.*, m.nombre as nom_muni, c.nom_cat,fec_caso from wf_caso_87 w inner join core_sujetoverificacion s on w.id=73 AND s.id =w.core_sujetoverificacion_id inner join plan_municipio m on s.plan_municipio_id=m.id inner join core_sujetocategoria c on s.core_sujetocategoria_id=c.id 2015-07 29 12:11:02 tabla dat adic select tabla from core_sujetoverificaciontipo where id=1 2015-07 29 12:11:02 tabla :persona SELECT * FROM persona where id=3 fin 2015-07-29 12:11:02 /******************************************************************************************************/ 2015-07-29 12:11:10TraerCaso(73,87,) CargarCaso :73 2015-07 29 12:11:10 CargarDatos: Caso :73 cargar datos de ejecucion de los ultimos pasos select p.*,b.wf_tarea_id as tarea_id, u.apellido||' '||u.nombre|| ': '||u.cargo as usr_ejec from (select max(id) as id, wf_caso_87_seguimiento_id,wf_paso_id from wf_caso_87_pasos a1 group by wf_caso_87_seguimiento_id,wf_paso_id order by id )a inner join wf_caso_87_pasos p using(id,wf_caso_87_seguimiento_id) inner join ( select max(id) as wf_caso_87_seguimiento_id,wf_caso_87_id,wf_tarea_id from wf_caso_87_seguimiento where wf_caso_87_id =? group by wf_caso_87_id,wf_tarea_id order by wf_caso_87_id,wf_caso_87_seguimiento_id ) b using(wf_caso_87_seguimiento_id) left join usuarios u using(core_usuario_id) Error : cargar datos de ejecucion de las tareas (las ultimas si el proceso tiene ciclos) select a.*, u.apellido||' '||u.nombre|| ': '||u.cargo as usr_asig , ur.apellido||' '||ur.nombre|| ': '||ur.cargo as usr_resol from wf_caso_87_seguimiento a inner join ( select max(b0.id) as id,b0.wf_caso_87_id,b0.wf_tarea_id from wf_caso_87_seguimiento b0 where b0.wf_caso_87_id =? group by b0.wf_caso_87_id,b0.wf_tarea_id order by wf_caso_87_id,id ) b using(id) left join usuarios u using(core_usuario_id) left join usuarios ur on ur.core_usuario_id=core_usuario_id_resol {"0":"268","id":"268","1":"73","wf_caso_87_id":"73","2":"162","wf_tarea_id":"162","3":null,"core_usuario_id":null,"4":"2015-07-29 12:11:02","fec_asig":"2015-07-29 12:11:02","5":null,"core_usuario_id_resol":null,"6":null,"fec_resol":null,"7":"162","wf_tarea_id_sig":"162","8":null,"usr_asig":null,"9":null,"usr_resol":null} 2015-07 29 12:11:10 cargar datos del sujeto(,,s,87,73) select s.*, m.nombre as nom_muni, c.nom_cat,fec_caso from wf_caso_87 w inner join core_sujetoverificacion s on w.id=73 AND s.id =w.core_sujetoverificacion_id inner join plan_municipio m on s.plan_municipio_id=m.id inner join core_sujetocategoria c on s.core_sujetocategoria_id=c.id 2015-07 29 12:11:10 tabla dat adic select tabla from core_sujetoverificaciontipo where id=1 2015-07 29 12:11:10 tabla :persona SELECT * FROM persona where id=3 2015-07 29 12:11:10 Continuar(s,162,277,) EjecutarTarea_162() Tipo fromulario id_comp1230 11 ValidarUsuario(162):1 EjecutarPaso_277: form:33 , caso=73 id_comp 1230 Paso::Guardar(Caso:73) Datos a guardar: Array ( [wf_proceso_id] => 87 [wf_paso_id] => 277 [wf_tarea_id] => 162 [wf_caso_id] => 73 [id] => 1230 [accion] => nextPaso [reg] => s [rta] => n [cod_formulario2] => 33 [id_periodo] => 2015 [obs_ingreso] => [cod_bloque] => 34 [oid] => [oid_maestro] => [451] => 3 ) OID: 70 rta: 1 dato:70 tabla:sce.t33 CasoPaso:294 CargarDatos_277(70) se carga 87_162_277_33_34_4513 SiguientePasoDe277: Funcion para ejecutar el siguiente paso Condicion Tarea : 3 ==1 Condicion Tarea : 3 ==2 Condicion Tarea : 3 ==3 TerminarTarea(162,165) Ultimo seg :268 Ultimo seg :269 EjecutarTarea_165() Concurso de trios id_comp1230 11 11 ValidarUsuario(165):1 EjecutarPaso_278: form:27 , caso=73 id_comp 1230 Mostrar form Retorno : Array ( [ret] => Ext.getCmp('comp_1230').removeAll();Ext.getCmp('comp_1230').add(new Ext.form.FormPanel({ title: 'Ingreso de datos' ,padding: 10,id:'frm_formulario_87_73',autoScroll:true ,labelAlign:'top',defaults: { anchor: '97%'} ,items: [new Ext.form.Hidden({name:'cod_formulario2',value:'27'}) ,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:'28'}) ,new Ext.form.Hidden({name :'oid',value:''}) ,new Ext.form.Hidden({name :'oid_maestro',value:''}) ,new Ext.form.Hidden({ value:'2015-07-29', id:'410'}),{ xtype:'hidden',id:'hds411',disabled:true},new Ext.form.ComboBox({typeAhead:true,listeners:{ select:function(){xajax_comprobar_campoOcultoSelect(this.getValue(),411);},afterrender:function(){ xajax_comprobar_campoOcultoSelect(this.getValue(),411); }},/*fin introducir listener para campos ocultos*/triggerAction:'all',mode:'local',editable:false,emptyText:'Seleccione una opción',store:new Ext.data.ArrayStore({fields:['id', 'value'],data:[[1,'Profesional'],[2,'Veteranos'],[3,'Abierta'],[4,'Alternativa'] ]}),valueField:'id',displayField:'value',id:'inp_select_28_411',allowBlank:false,fieldLabel:'* Categoría',hiddenName:'411'}),{value:'',xtype:'textfield' , maxLength:60,autoCreate:{ tag:'input',maxlength:'60'} ,allowBlank:false,id:'412',fieldLabel:'* Nombre del trio' },{value:'',xtype:'textfield' , maxLength:60,autoCreate:{ tag:'input',maxlength:'60'} ,allowBlank:false,id:'413',fieldLabel:'* Dirección' },{value:'',xtype:'textfield' , maxLength:60,autoCreate:{ tag:'input',maxlength:'60'} ,listeners:{ blur:function(){ this.setValue(this.getValue().toUpperCase()); } } ,allowBlank:false,id:'414',fieldLabel:'* Ciudad' },{value:'',xtype:'textfield' , maxLength:10,autoCreate:{ tag:'input',maxlength:'10'} ,id:'415',fieldLabel:'teléfono',maskRe:/^[0-9]$/ },{value:'',xtype:'textfield' , maxLength:10,autoCreate:{ tag:'input',maxlength:'10'} ,allowBlank:false,id:'416',fieldLabel:'* Celular',maskRe:/^[0-9]$/ },{value:'',xtype:'textfield' , maxLength:60,autoCreate:{ tag:'input',maxlength:'60'} ,allowBlank:false,id:'417',fieldLabel:'* Correo electronico',vtype:'email' },{ xtype:'hidden',id:'hdcampo422',value:'28'},{ xtype:'hidden',id:'422'}, new Ext.grid.EditorGridPanel({xtype:'editorgrid',store:new Ext.data.JsonStore({ fields:[{ name:'oid' },{ name:'txtnomt' },{ name:'txtcelt' },{ name:'txtcedt' }]}),columns:[new Ext.grid.RowNumberer({width:30}),{header:'Nombre',dataIndex:'txtnomt',width:80,resizable:true,sortable:true,editor:{value:'',xtype:'textfield' , maxLength:50 ,allowBlank:false,maskRe:/^[a-z_A-Z_\s]$/, maxLength:60,autoCreate:{ tag:'input',maxlength:'60'}}},{header:'Celular',dataIndex:'txtcelt',width:80,resizable:true,sortable:true,editor:{value:'',xtype:'textfield' , maxLength:10 ,allowBlank:false,maskRe:/^[0-9]$/, maxLength:10,autoCreate:{ tag:'input',maxlength:'10'}}},{header:'Documento de identidad',dataIndex:'txtcedt',width:80,resizable:true,sortable:true,editor:{value:'',xtype:'textfield' , maxLength:10 ,allowBlank:false,maskRe:/^[0-9]$/, maxLength:10,autoCreate:{ tag:'input',maxlength:'10'}}}],stripeRows:true,height:150,id:'422_28',title:'Integrantes',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:'txtnomt' },{ name:'txtcelt' },{ name:'txtcedt' });var myNewRecord = new TopicRecord({ oid:null ,txtnomt:'',txtcelt:'',txtcedt:''});var storegri = Ext.getCmp('422_28').getStore();storegri.add(myNewRecord);}},{iconCls:'icon-delete',tooltip:'Eliminar',text:'Eliminar',handler:function(){var grid = Ext.getCmp('422_28');var list = grid.getSelectionModel().getSelections();if (!list) {Ext.MessageBox.alert('Advertencia', 'Ningun item seleccionado');return false;}Ext.Msg.show({ title:'Advertencia de eliminación', 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*/,{value:'',xtype:'textfield' , maxLength:60,autoCreate:{ tag:'input',maxlength:'60'} ,allowBlank:false,id:'423',fieldLabel:'* Director' },{value:'',xtype:'textfield' , maxLength:10,autoCreate:{ tag:'input',maxlength:'10'} ,allowBlank:false,id:'424',fieldLabel:'* Documento de identidad',maskRe:/^[0-9]$/ },{value:'',xtype:'textfield' , maxLength:60,autoCreate:{ tag:'input',maxlength:'60'} ,allowBlank:false,id:'425',fieldLabel:'* Dirección' },{value:'',xtype:'textfield' , maxLength:10,autoCreate:{ tag:'input',maxlength:'10'} ,allowBlank:false,id:'426',fieldLabel:'* teléfono',maskRe:/^[0-9]$/ } ] ,prepararGrids:function(){/*buscar editorgrid - grilla id compuesto, id real, mas id formulario esclavo, separado _*/var grillasF=this.findByType('editorgrid');if(grillasF && grillasF!=''){for (i=0; i < grillasF.length; i++){var xstore=grillasF[i].getStore();if(xstore.getCount()>0){var data=new Array();var xxid=grillasF[i].getId().split('_');for (j=0; j < xstore.getCount(); j++){var xreco = xstore.getAt(j); var cont_dat_vac=0,cont_tot_vac=0; for(var elem in xreco.data){cont_tot_vac++;if( xreco.data[elem] ==null || xreco.data[elem]=='' ){cont_dat_vac++;}} if(cont_dat_vac < cont_tot_vac){data[data.length]=xreco.data;data[data.length-1]['form_master_escribir_xxx']=xxid[1];}}var xfinalfin=Ext.encode(data);Ext.getCmp(xxid[0]).setValue(xfinalfin);}}}/*grabar stores en hiddens*/},tbar:[{text:'Guardar',iconCls: 'icon-disk',handler: function(){ var form = Ext.getCmp('frm_formulario_87_73'); var f=form.getForm();if(f.isValid()){var band_f=true;try{band_f =form.Validar();}catch(e){}if(band_f){form.prepararGrids();f.submit({url:'http://192.168.10.116/sisad/build/view/'+'workflow/casos/casos_l.php',params:{wf_proceso_id:'87',wf_paso_id:'278',wf_tarea_id:'165',wf_caso_id:'73',id:'1230',accion:'nextPaso',reg:'s',rta:'n'},success:function(form, action){if(action.result.message) crearMsg(action.result.message,'Informacion');else if(action.result.execute){/*try{*/eval(action.result.execute);/*}catch(e){alert(e+'Se presentó un error , por favor cierre la pestaña del caso y continue el proceso desde la pestaña de resumen' );}*/}},failure: function(form, action) {switch (action.failureType) {case Ext.form.Action.CONNECT_FAILURE:Ext.Msg.alert('Error', 'En este momento no hay comunicación con el servidor intente más tarde');break;case Ext.form.Action.SERVER_INVALID: Ext.Msg.alert('Error', action.result.message); break; }}});}}else{Ext.MessageBox.alert('Advertencia',getErrorFields(f));}} } ] ,listeners:{ afterrender:function(){ try{ Ext.getCmp('frm_formulario_87_73').getForm().loadRecord(new Ext.data.Record({"cod_formulario":27,"oid_maestro":null,"cod_bloque":28,"412":null,"413":null,"414":null,"415":null,"416":null,"417":null,"423":null,"424":null,"425":null,"426":null})); llamadaAJAX({url:'http://192.168.10.116/sisad/build/view/workflow/casos/casos_datosForm.php',mostrarMsg:false,params:{accion:'verifica',wf_paso_id:'278',cod_formulario:'27',cod_bloque:'28',wf_caso_id:'{"pro":"87","cas":"73"}'}}); }catch(e){alert(e);} } } }) );Ext.getCmp('comp_1230').doLayout(); [suc] => 1 ) fin 2015-07-29 12:11:10 /******************************************************************************************************/ 2015-07-29 12:11:10TraerCaso(73,87,) CargarCaso :73 2015-07 29 12:11:10 CargarDatos: Caso :73 cargar datos de ejecucion de los ultimos pasos select p.*,b.wf_tarea_id as tarea_id, u.apellido||' '||u.nombre|| ': '||u.cargo as usr_ejec from (select max(id) as id, wf_caso_87_seguimiento_id,wf_paso_id from wf_caso_87_pasos a1 group by wf_caso_87_seguimiento_id,wf_paso_id order by id )a inner join wf_caso_87_pasos p using(id,wf_caso_87_seguimiento_id) inner join ( select max(id) as wf_caso_87_seguimiento_id,wf_caso_87_id,wf_tarea_id from wf_caso_87_seguimiento where wf_caso_87_id =? group by wf_caso_87_id,wf_tarea_id order by wf_caso_87_id,wf_caso_87_seguimiento_id ) b using(wf_caso_87_seguimiento_id) left join usuarios u using(core_usuario_id) {"0":"294","id":"294","1":"277","wf_paso_id":"277","2":"268","wf_caso_87_seguimiento_id":"268","3":"11","core_usuario_id":"11","4":"2015-07-29 12:11:10","fecha_ejec":"2015-07-29 12:11:10","5":"70","dato":"70","6":"sce.t33","tabla":"sce.t33","7":"162","tarea_id":"162","8":"siti soluciones German: ciudadano, gerente","usr_ejec":"siti soluciones German: ciudadano, gerente"} CargarDatos_277(70) se carga 87_162_277_33_34_4513 cargar datos de ejecucion de las tareas (las ultimas si el proceso tiene ciclos) select a.*, u.apellido||' '||u.nombre|| ': '||u.cargo as usr_asig , ur.apellido||' '||ur.nombre|| ': '||ur.cargo as usr_resol from wf_caso_87_seguimiento a inner join ( select max(b0.id) as id,b0.wf_caso_87_id,b0.wf_tarea_id from wf_caso_87_seguimiento b0 where b0.wf_caso_87_id =? group by b0.wf_caso_87_id,b0.wf_tarea_id order by wf_caso_87_id,id ) b using(id) left join usuarios u using(core_usuario_id) left join usuarios ur on ur.core_usuario_id=core_usuario_id_resol {"0":"268","id":"268","1":"73","wf_caso_87_id":"73","2":"162","wf_tarea_id":"162","3":null,"core_usuario_id":null,"4":"2015-07-29 12:11:02","fec_asig":"2015-07-29 12:11:02","5":"11","core_usuario_id_resol":"11","6":"2015-07-29 12:11:10","fec_resol":"2015-07-29 12:11:10","7":"162","wf_tarea_id_sig":"162","8":null,"usr_asig":null,"9":"siti soluciones German: ciudadano, gerente","usr_resol":"siti soluciones German: ciudadano, gerente"} {"0":"269","id":"269","1":"73","wf_caso_87_id":"73","2":"165","wf_tarea_id":"165","3":"11","core_usuario_id":"11","4":"2015-07-29 12:11:10","fec_asig":"2015-07-29 12:11:10","5":null,"core_usuario_id_resol":null,"6":null,"fec_resol":null,"7":"165","wf_tarea_id_sig":"165","8":"siti soluciones German: ciudadano, gerente","usr_asig":"siti soluciones German: ciudadano, gerente","9":null,"usr_resol":null} 2015-07 29 12:11:10 cargar datos del sujeto(,,s,87,73) select s.*, m.nombre as nom_muni, c.nom_cat,fec_caso from wf_caso_87 w inner join core_sujetoverificacion s on w.id=73 AND s.id =w.core_sujetoverificacion_id inner join plan_municipio m on s.plan_municipio_id=m.id inner join core_sujetocategoria c on s.core_sujetocategoria_id=c.id 2015-07 29 12:11:10 tabla dat adic select tabla from core_sujetoverificaciontipo where id=1 2015-07 29 12:11:10 tabla :persona SELECT * FROM persona where id=3 fin 2015-07-29 12:11:10 /******************************************************************************************************/ 2015-07-29 12:14:00TraerCaso(73,87,) CargarCaso :73 2015-07 29 12:14:00 CargarDatos: Caso :73 cargar datos de ejecucion de los ultimos pasos select p.*,b.wf_tarea_id as tarea_id, u.apellido||' '||u.nombre|| ': '||u.cargo as usr_ejec from (select max(id) as id, wf_caso_87_seguimiento_id,wf_paso_id from wf_caso_87_pasos a1 group by wf_caso_87_seguimiento_id,wf_paso_id order by id )a inner join wf_caso_87_pasos p using(id,wf_caso_87_seguimiento_id) inner join ( select max(id) as wf_caso_87_seguimiento_id,wf_caso_87_id,wf_tarea_id from wf_caso_87_seguimiento where wf_caso_87_id =? group by wf_caso_87_id,wf_tarea_id order by wf_caso_87_id,wf_caso_87_seguimiento_id ) b using(wf_caso_87_seguimiento_id) left join usuarios u using(core_usuario_id) {"0":"294","id":"294","1":"277","wf_paso_id":"277","2":"268","wf_caso_87_seguimiento_id":"268","3":"11","core_usuario_id":"11","4":"2015-07-29 12:11:10","fecha_ejec":"2015-07-29 12:11:10","5":"70","dato":"70","6":"sce.t33","tabla":"sce.t33","7":"162","tarea_id":"162","8":"siti soluciones German: ciudadano, gerente","usr_ejec":"siti soluciones German: ciudadano, gerente"} CargarDatos_277(70) se carga 87_162_277_33_34_4513 cargar datos de ejecucion de las tareas (las ultimas si el proceso tiene ciclos) select a.*, u.apellido||' '||u.nombre|| ': '||u.cargo as usr_asig , ur.apellido||' '||ur.nombre|| ': '||ur.cargo as usr_resol from wf_caso_87_seguimiento a inner join ( select max(b0.id) as id,b0.wf_caso_87_id,b0.wf_tarea_id from wf_caso_87_seguimiento b0 where b0.wf_caso_87_id =? group by b0.wf_caso_87_id,b0.wf_tarea_id order by wf_caso_87_id,id ) b using(id) left join usuarios u using(core_usuario_id) left join usuarios ur on ur.core_usuario_id=core_usuario_id_resol {"0":"268","id":"268","1":"73","wf_caso_87_id":"73","2":"162","wf_tarea_id":"162","3":null,"core_usuario_id":null,"4":"2015-07-29 12:11:02","fec_asig":"2015-07-29 12:11:02","5":"11","core_usuario_id_resol":"11","6":"2015-07-29 12:11:10","fec_resol":"2015-07-29 12:11:10","7":"162","wf_tarea_id_sig":"162","8":null,"usr_asig":null,"9":"siti soluciones German: ciudadano, gerente","usr_resol":"siti soluciones German: ciudadano, gerente"} {"0":"269","id":"269","1":"73","wf_caso_87_id":"73","2":"165","wf_tarea_id":"165","3":"11","core_usuario_id":"11","4":"2015-07-29 12:11:10","fec_asig":"2015-07-29 12:11:10","5":null,"core_usuario_id_resol":null,"6":null,"fec_resol":null,"7":"165","wf_tarea_id_sig":"165","8":"siti soluciones German: ciudadano, gerente","usr_asig":"siti soluciones German: ciudadano, gerente","9":null,"usr_resol":null} 2015-07 29 12:14:01 cargar datos del sujeto(,,s,87,73) select s.*, m.nombre as nom_muni, c.nom_cat,fec_caso from wf_caso_87 w inner join core_sujetoverificacion s on w.id=73 AND s.id =w.core_sujetoverificacion_id inner join plan_municipio m on s.plan_municipio_id=m.id inner join core_sujetocategoria c on s.core_sujetocategoria_id=c.id 2015-07 29 12:14:01 tabla dat adic select tabla from core_sujetoverificaciontipo where id=1 2015-07 29 12:14:01 tabla :persona SELECT * FROM persona where id=3 2015-07 29 12:14:01 Continuar(,165,,s) EjecutarTarea_165() Concurso de trios id_comp1232 11 11 ValidarUsuario(165):1 EjecutarPaso_278: form:27 , caso=73 id_comp 1232 Mostrar form Retorno : Array ( [ret] => Ext.getCmp('comp_1232').removeAll();Ext.getCmp('comp_1232').add(new Ext.form.FormPanel({ title: 'Ingreso de datos' ,padding: 10,id:'frm_formulario_87_73',autoScroll:true ,labelAlign:'top',defaults: { anchor: '97%'} ,items: [new Ext.form.Hidden({name:'cod_formulario2',value:'27'}) ,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:'28'}) ,new Ext.form.Hidden({name :'oid',value:''}) ,new Ext.form.Hidden({name :'oid_maestro',value:''}) ,new Ext.form.Hidden({ value:'2015-07-29', id:'410'}),{ xtype:'hidden',id:'hds411',disabled:true},new Ext.form.ComboBox({typeAhead:true,listeners:{ select:function(){xajax_comprobar_campoOcultoSelect(this.getValue(),411);},afterrender:function(){ xajax_comprobar_campoOcultoSelect(this.getValue(),411); }},/*fin introducir listener para campos ocultos*/triggerAction:'all',mode:'local',editable:false,emptyText:'Seleccione una opción',store:new Ext.data.ArrayStore({fields:['id', 'value'],data:[[1,'Profesional'],[2,'Veteranos'],[3,'Abierta'],[4,'Alternativa'] ]}),valueField:'id',displayField:'value',id:'inp_select_28_411',allowBlank:false,fieldLabel:'* Categoría',hiddenName:'411'}),{value:'',xtype:'textfield' , maxLength:60,autoCreate:{ tag:'input',maxlength:'60'} ,allowBlank:false,id:'412',fieldLabel:'* Nombre del trio' },{value:'',xtype:'textfield' , maxLength:60,autoCreate:{ tag:'input',maxlength:'60'} ,allowBlank:false,id:'413',fieldLabel:'* Dirección' },{value:'',xtype:'textfield' , maxLength:60,autoCreate:{ tag:'input',maxlength:'60'} ,listeners:{ blur:function(){ this.setValue(this.getValue().toUpperCase()); } } ,allowBlank:false,id:'414',fieldLabel:'* Ciudad' },{value:'',xtype:'textfield' , maxLength:10,autoCreate:{ tag:'input',maxlength:'10'} ,id:'415',fieldLabel:'teléfono',maskRe:/^[0-9]$/ },{value:'',xtype:'textfield' , maxLength:10,autoCreate:{ tag:'input',maxlength:'10'} ,allowBlank:false,id:'416',fieldLabel:'* Celular',maskRe:/^[0-9]$/ },{value:'',xtype:'textfield' , maxLength:60,autoCreate:{ tag:'input',maxlength:'60'} ,allowBlank:false,id:'417',fieldLabel:'* Correo electronico',vtype:'email' },{ xtype:'hidden',id:'hdcampo422',value:'28'},{ xtype:'hidden',id:'422'}, new Ext.grid.EditorGridPanel({xtype:'editorgrid',store:new Ext.data.JsonStore({ fields:[{ name:'oid' },{ name:'txtnomt' },{ name:'txtcelt' },{ name:'txtcedt' }]}),columns:[new Ext.grid.RowNumberer({width:30}),{header:'Nombre',dataIndex:'txtnomt',width:80,resizable:true,sortable:true,editor:{value:'',xtype:'textfield' , maxLength:50 ,allowBlank:false,maskRe:/^[a-z_A-Z_\s]$/, maxLength:60,autoCreate:{ tag:'input',maxlength:'60'}}},{header:'Celular',dataIndex:'txtcelt',width:80,resizable:true,sortable:true,editor:{value:'',xtype:'textfield' , maxLength:10 ,allowBlank:false,maskRe:/^[0-9]$/, maxLength:10,autoCreate:{ tag:'input',maxlength:'10'}}},{header:'Documento de identidad',dataIndex:'txtcedt',width:80,resizable:true,sortable:true,editor:{value:'',xtype:'textfield' , maxLength:10 ,allowBlank:false,maskRe:/^[0-9]$/, maxLength:10,autoCreate:{ tag:'input',maxlength:'10'}}}],stripeRows:true,height:150,id:'422_28',title:'Integrantes',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:'txtnomt' },{ name:'txtcelt' },{ name:'txtcedt' });var myNewRecord = new TopicRecord({ oid:null ,txtnomt:'',txtcelt:'',txtcedt:''});var storegri = Ext.getCmp('422_28').getStore();storegri.add(myNewRecord);}},{iconCls:'icon-delete',tooltip:'Eliminar',text:'Eliminar',handler:function(){var grid = Ext.getCmp('422_28');var list = grid.getSelectionModel().getSelections();if (!list) {Ext.MessageBox.alert('Advertencia', 'Ningun item seleccionado');return false;}Ext.Msg.show({ title:'Advertencia de eliminación', 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*/,{value:'',xtype:'textfield' , maxLength:60,autoCreate:{ tag:'input',maxlength:'60'} ,allowBlank:false,id:'423',fieldLabel:'* Director' },{value:'',xtype:'textfield' , maxLength:10,autoCreate:{ tag:'input',maxlength:'10'} ,allowBlank:false,id:'424',fieldLabel:'* Documento de identidad',maskRe:/^[0-9]$/ },{value:'',xtype:'textfield' , maxLength:60,autoCreate:{ tag:'input',maxlength:'60'} ,allowBlank:false,id:'425',fieldLabel:'* Dirección' },{value:'',xtype:'textfield' , maxLength:10,autoCreate:{ tag:'input',maxlength:'10'} ,allowBlank:false,id:'426',fieldLabel:'* teléfono',maskRe:/^[0-9]$/ } ] ,prepararGrids:function(){/*buscar editorgrid - grilla id compuesto, id real, mas id formulario esclavo, separado _*/var grillasF=this.findByType('editorgrid');if(grillasF && grillasF!=''){for (i=0; i < grillasF.length; i++){var xstore=grillasF[i].getStore();if(xstore.getCount()>0){var data=new Array();var xxid=grillasF[i].getId().split('_');for (j=0; j < xstore.getCount(); j++){var xreco = xstore.getAt(j); var cont_dat_vac=0,cont_tot_vac=0; for(var elem in xreco.data){cont_tot_vac++;if( xreco.data[elem] ==null || xreco.data[elem]=='' ){cont_dat_vac++;}} if(cont_dat_vac < cont_tot_vac){data[data.length]=xreco.data;data[data.length-1]['form_master_escribir_xxx']=xxid[1];}}var xfinalfin=Ext.encode(data);Ext.getCmp(xxid[0]).setValue(xfinalfin);}}}/*grabar stores en hiddens*/},tbar:[{text:'Guardar',iconCls: 'icon-disk',handler: function(){ var form = Ext.getCmp('frm_formulario_87_73'); var f=form.getForm();if(f.isValid()){var band_f=true;try{band_f =form.Validar();}catch(e){}if(band_f){form.prepararGrids();f.submit({url:'http://192.168.10.116/sisad/build/view/'+'workflow/casos/casos_l.php',params:{wf_proceso_id:'87',wf_paso_id:'278',wf_tarea_id:'165',wf_caso_id:'73',id:'1232',accion:'nextPaso',reg:'s',rta:'n'},success:function(form, action){if(action.result.message) crearMsg(action.result.message,'Informacion');else if(action.result.execute){/*try{*/eval(action.result.execute);/*}catch(e){alert(e+'Se presentó un error , por favor cierre la pestaña del caso y continue el proceso desde la pestaña de resumen' );}*/}},failure: function(form, action) {switch (action.failureType) {case Ext.form.Action.CONNECT_FAILURE:Ext.Msg.alert('Error', 'En este momento no hay comunicación con el servidor intente más tarde');break;case Ext.form.Action.SERVER_INVALID: Ext.Msg.alert('Error', action.result.message); break; }}});}}else{Ext.MessageBox.alert('Advertencia',getErrorFields(f));}} } ] ,listeners:{ afterrender:function(){ try{ Ext.getCmp('frm_formulario_87_73').getForm().loadRecord(new Ext.data.Record({"cod_formulario":27,"oid_maestro":null,"cod_bloque":28,"412":null,"413":null,"414":null,"415":null,"416":null,"417":null,"423":null,"424":null,"425":null,"426":null})); llamadaAJAX({url:'http://192.168.10.116/sisad/build/view/workflow/casos/casos_datosForm.php',mostrarMsg:false,params:{accion:'verifica',wf_paso_id:'278',cod_formulario:'27',cod_bloque:'28',wf_caso_id:'{"pro":"87","cas":"73"}'}}); }catch(e){alert(e);} } } }) );Ext.getCmp('comp_1232').doLayout(); [suc] => 1 ) fin 2015-07-29 12:14:01 /******************************************************************************************************/ 2015-07-29 12:14:01TraerCaso(73,87,) CargarCaso :73 2015-07 29 12:14:01 CargarDatos: Caso :73 cargar datos de ejecucion de los ultimos pasos select p.*,b.wf_tarea_id as tarea_id, u.apellido||' '||u.nombre|| ': '||u.cargo as usr_ejec from (select max(id) as id, wf_caso_87_seguimiento_id,wf_paso_id from wf_caso_87_pasos a1 group by wf_caso_87_seguimiento_id,wf_paso_id order by id )a inner join wf_caso_87_pasos p using(id,wf_caso_87_seguimiento_id) inner join ( select max(id) as wf_caso_87_seguimiento_id,wf_caso_87_id,wf_tarea_id from wf_caso_87_seguimiento where wf_caso_87_id =? group by wf_caso_87_id,wf_tarea_id order by wf_caso_87_id,wf_caso_87_seguimiento_id ) b using(wf_caso_87_seguimiento_id) left join usuarios u using(core_usuario_id) {"0":"294","id":"294","1":"277","wf_paso_id":"277","2":"268","wf_caso_87_seguimiento_id":"268","3":"11","core_usuario_id":"11","4":"2015-07-29 12:11:10","fecha_ejec":"2015-07-29 12:11:10","5":"70","dato":"70","6":"sce.t33","tabla":"sce.t33","7":"162","tarea_id":"162","8":"siti soluciones German: ciudadano, gerente","usr_ejec":"siti soluciones German: ciudadano, gerente"} CargarDatos_277(70) se carga 87_162_277_33_34_4513 cargar datos de ejecucion de las tareas (las ultimas si el proceso tiene ciclos) select a.*, u.apellido||' '||u.nombre|| ': '||u.cargo as usr_asig , ur.apellido||' '||ur.nombre|| ': '||ur.cargo as usr_resol from wf_caso_87_seguimiento a inner join ( select max(b0.id) as id,b0.wf_caso_87_id,b0.wf_tarea_id from wf_caso_87_seguimiento b0 where b0.wf_caso_87_id =? group by b0.wf_caso_87_id,b0.wf_tarea_id order by wf_caso_87_id,id ) b using(id) left join usuarios u using(core_usuario_id) left join usuarios ur on ur.core_usuario_id=core_usuario_id_resol {"0":"268","id":"268","1":"73","wf_caso_87_id":"73","2":"162","wf_tarea_id":"162","3":null,"core_usuario_id":null,"4":"2015-07-29 12:11:02","fec_asig":"2015-07-29 12:11:02","5":"11","core_usuario_id_resol":"11","6":"2015-07-29 12:11:10","fec_resol":"2015-07-29 12:11:10","7":"162","wf_tarea_id_sig":"162","8":null,"usr_asig":null,"9":"siti soluciones German: ciudadano, gerente","usr_resol":"siti soluciones German: ciudadano, gerente"} {"0":"269","id":"269","1":"73","wf_caso_87_id":"73","2":"165","wf_tarea_id":"165","3":"11","core_usuario_id":"11","4":"2015-07-29 12:11:10","fec_asig":"2015-07-29 12:11:10","5":null,"core_usuario_id_resol":null,"6":null,"fec_resol":null,"7":"165","wf_tarea_id_sig":"165","8":"siti soluciones German: ciudadano, gerente","usr_asig":"siti soluciones German: ciudadano, gerente","9":null,"usr_resol":null} 2015-07 29 12:14:01 cargar datos del sujeto(,,s,87,73) select s.*, m.nombre as nom_muni, c.nom_cat,fec_caso from wf_caso_87 w inner join core_sujetoverificacion s on w.id=73 AND s.id =w.core_sujetoverificacion_id inner join plan_municipio m on s.plan_municipio_id=m.id inner join core_sujetocategoria c on s.core_sujetocategoria_id=c.id 2015-07 29 12:14:01 tabla dat adic select tabla from core_sujetoverificaciontipo where id=1 2015-07 29 12:14:01 tabla :persona SELECT * FROM persona where id=3 fin 2015-07-29 12:14:01 /******************************************************************************************************/ 2015-07-29 12:14:53TraerCaso(73,87,) CargarCaso :73 2015-07 29 12:14:53 CargarDatos: Caso :73 cargar datos de ejecucion de los ultimos pasos select p.*,b.wf_tarea_id as tarea_id, u.apellido||' '||u.nombre|| ': '||u.cargo as usr_ejec from (select max(id) as id, wf_caso_87_seguimiento_id,wf_paso_id from wf_caso_87_pasos a1 group by wf_caso_87_seguimiento_id,wf_paso_id order by id )a inner join wf_caso_87_pasos p using(id,wf_caso_87_seguimiento_id) inner join ( select max(id) as wf_caso_87_seguimiento_id,wf_caso_87_id,wf_tarea_id from wf_caso_87_seguimiento where wf_caso_87_id =? group by wf_caso_87_id,wf_tarea_id order by wf_caso_87_id,wf_caso_87_seguimiento_id ) b using(wf_caso_87_seguimiento_id) left join usuarios u using(core_usuario_id) {"0":"294","id":"294","1":"277","wf_paso_id":"277","2":"268","wf_caso_87_seguimiento_id":"268","3":"11","core_usuario_id":"11","4":"2015-07-29 12:11:10","fecha_ejec":"2015-07-29 12:11:10","5":"70","dato":"70","6":"sce.t33","tabla":"sce.t33","7":"162","tarea_id":"162","8":"siti soluciones German: ciudadano, gerente","usr_ejec":"siti soluciones German: ciudadano, gerente"} CargarDatos_277(70) se carga 87_162_277_33_34_4513 cargar datos de ejecucion de las tareas (las ultimas si el proceso tiene ciclos) select a.*, u.apellido||' '||u.nombre|| ': '||u.cargo as usr_asig , ur.apellido||' '||ur.nombre|| ': '||ur.cargo as usr_resol from wf_caso_87_seguimiento a inner join ( select max(b0.id) as id,b0.wf_caso_87_id,b0.wf_tarea_id from wf_caso_87_seguimiento b0 where b0.wf_caso_87_id =? group by b0.wf_caso_87_id,b0.wf_tarea_id order by wf_caso_87_id,id ) b using(id) left join usuarios u using(core_usuario_id) left join usuarios ur on ur.core_usuario_id=core_usuario_id_resol {"0":"268","id":"268","1":"73","wf_caso_87_id":"73","2":"162","wf_tarea_id":"162","3":null,"core_usuario_id":null,"4":"2015-07-29 12:11:02","fec_asig":"2015-07-29 12:11:02","5":"11","core_usuario_id_resol":"11","6":"2015-07-29 12:11:10","fec_resol":"2015-07-29 12:11:10","7":"162","wf_tarea_id_sig":"162","8":null,"usr_asig":null,"9":"siti soluciones German: ciudadano, gerente","usr_resol":"siti soluciones German: ciudadano, gerente"} {"0":"269","id":"269","1":"73","wf_caso_87_id":"73","2":"165","wf_tarea_id":"165","3":"11","core_usuario_id":"11","4":"2015-07-29 12:11:10","fec_asig":"2015-07-29 12:11:10","5":null,"core_usuario_id_resol":null,"6":null,"fec_resol":null,"7":"165","wf_tarea_id_sig":"165","8":"siti soluciones German: ciudadano, gerente","usr_asig":"siti soluciones German: ciudadano, gerente","9":null,"usr_resol":null} 2015-07 29 12:14:53 cargar datos del sujeto(,,s,87,73) select s.*, m.nombre as nom_muni, c.nom_cat,fec_caso from wf_caso_87 w inner join core_sujetoverificacion s on w.id=73 AND s.id =w.core_sujetoverificacion_id inner join plan_municipio m on s.plan_municipio_id=m.id inner join core_sujetocategoria c on s.core_sujetocategoria_id=c.id 2015-07 29 12:14:53 tabla dat adic select tabla from core_sujetoverificaciontipo where id=1 2015-07 29 12:14:53 tabla :persona SELECT * FROM persona where id=3 2015-07 29 12:14:53 Continuar(,165,,s) EjecutarTarea_165() Concurso de trios id_comp1232 11 11 ValidarUsuario(165):1 EjecutarPaso_278: form:27 , caso=73 id_comp 1232 Mostrar form Retorno : Array ( [ret] => Ext.getCmp('comp_1232').removeAll();Ext.getCmp('comp_1232').add(new Ext.form.FormPanel({ title: 'Ingreso de datos' ,padding: 10,id:'frm_formulario_87_73',autoScroll:true ,labelAlign:'top',defaults: { anchor: '97%'} ,items: [new Ext.form.Hidden({name:'cod_formulario2',value:'27'}) ,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:'28'}) ,new Ext.form.Hidden({name :'oid',value:''}) ,new Ext.form.Hidden({name :'oid_maestro',value:''}) ,new Ext.form.Hidden({ value:'2015-07-29', id:'410'}),{ xtype:'hidden',id:'hds411',disabled:true},new Ext.form.ComboBox({typeAhead:true,listeners:{ select:function(){xajax_comprobar_campoOcultoSelect(this.getValue(),411);},afterrender:function(){ xajax_comprobar_campoOcultoSelect(this.getValue(),411); }},/*fin introducir listener para campos ocultos*/triggerAction:'all',mode:'local',editable:false,emptyText:'Seleccione una opción',store:new Ext.data.ArrayStore({fields:['id', 'value'],data:[[1,'Profesional'],[2,'Veteranos'],[3,'Abierta'],[4,'Alternativa'] ]}),valueField:'id',displayField:'value',id:'inp_select_28_411',allowBlank:false,fieldLabel:'* Categoría',hiddenName:'411'}),{value:'',xtype:'textfield' , maxLength:60,autoCreate:{ tag:'input',maxlength:'60'} ,allowBlank:false,id:'412',fieldLabel:'* Nombre del trío' },{value:'',xtype:'textfield' , maxLength:60,autoCreate:{ tag:'input',maxlength:'60'} ,allowBlank:false,id:'413',fieldLabel:'* Dirección' },{value:'',xtype:'textfield' , maxLength:60,autoCreate:{ tag:'input',maxlength:'60'} ,listeners:{ blur:function(){ this.setValue(this.getValue().toUpperCase()); } } ,allowBlank:false,id:'414',fieldLabel:'* Ciudad' },{value:'',xtype:'textfield' , maxLength:10,autoCreate:{ tag:'input',maxlength:'10'} ,id:'415',fieldLabel:'teléfono',maskRe:/^[0-9]$/ },{value:'',xtype:'textfield' , maxLength:10,autoCreate:{ tag:'input',maxlength:'10'} ,allowBlank:false,id:'416',fieldLabel:'* Celular',maskRe:/^[0-9]$/ },{value:'',xtype:'textfield' , maxLength:60,autoCreate:{ tag:'input',maxlength:'60'} ,allowBlank:false,id:'417',fieldLabel:'* Correo electrónico',vtype:'email' },{ xtype:'hidden',id:'hdcampo422',value:'28'},{ xtype:'hidden',id:'422'}, new Ext.grid.EditorGridPanel({xtype:'editorgrid',store:new Ext.data.JsonStore({ fields:[{ name:'oid' },{ name:'txtnomt' },{ name:'txtcelt' },{ name:'txtcedt' }]}),columns:[new Ext.grid.RowNumberer({width:30}),{header:'Nombre',dataIndex:'txtnomt',width:80,resizable:true,sortable:true,editor:{value:'',xtype:'textfield' , maxLength:50 ,allowBlank:false,maskRe:/^[a-z_A-Z_\s]$/, maxLength:60,autoCreate:{ tag:'input',maxlength:'60'}}},{header:'Celular',dataIndex:'txtcelt',width:80,resizable:true,sortable:true,editor:{value:'',xtype:'textfield' , maxLength:10 ,allowBlank:false,maskRe:/^[0-9]$/, maxLength:10,autoCreate:{ tag:'input',maxlength:'10'}}},{header:'Documento de identidad',dataIndex:'txtcedt',width:80,resizable:true,sortable:true,editor:{value:'',xtype:'textfield' , maxLength:10 ,allowBlank:false,maskRe:/^[0-9]$/, maxLength:10,autoCreate:{ tag:'input',maxlength:'10'}}}],stripeRows:true,height:150,id:'422_28',title:'Integrantes',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:'txtnomt' },{ name:'txtcelt' },{ name:'txtcedt' });var myNewRecord = new TopicRecord({ oid:null ,txtnomt:'',txtcelt:'',txtcedt:''});var storegri = Ext.getCmp('422_28').getStore();storegri.add(myNewRecord);}},{iconCls:'icon-delete',tooltip:'Eliminar',text:'Eliminar',handler:function(){var grid = Ext.getCmp('422_28');var list = grid.getSelectionModel().getSelections();if (!list) {Ext.MessageBox.alert('Advertencia', 'Ningun item seleccionado');return false;}Ext.Msg.show({ title:'Advertencia de eliminación', 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*/,{value:'',xtype:'textfield' , maxLength:60,autoCreate:{ tag:'input',maxlength:'60'} ,allowBlank:false,id:'423',fieldLabel:'* Director' },{value:'',xtype:'textfield' , maxLength:10,autoCreate:{ tag:'input',maxlength:'10'} ,allowBlank:false,id:'424',fieldLabel:'* Documento de identidad',maskRe:/^[0-9]$/ },{value:'',xtype:'textfield' , maxLength:60,autoCreate:{ tag:'input',maxlength:'60'} ,allowBlank:false,id:'425',fieldLabel:'* Dirección' },{value:'',xtype:'textfield' , maxLength:10,autoCreate:{ tag:'input',maxlength:'10'} ,allowBlank:false,id:'426',fieldLabel:'* teléfono',maskRe:/^[0-9]$/ } ] ,prepararGrids:function(){/*buscar editorgrid - grilla id compuesto, id real, mas id formulario esclavo, separado _*/var grillasF=this.findByType('editorgrid');if(grillasF && grillasF!=''){for (i=0; i < grillasF.length; i++){var xstore=grillasF[i].getStore();if(xstore.getCount()>0){var data=new Array();var xxid=grillasF[i].getId().split('_');for (j=0; j < xstore.getCount(); j++){var xreco = xstore.getAt(j); var cont_dat_vac=0,cont_tot_vac=0; for(var elem in xreco.data){cont_tot_vac++;if( xreco.data[elem] ==null || xreco.data[elem]=='' ){cont_dat_vac++;}} if(cont_dat_vac < cont_tot_vac){data[data.length]=xreco.data;data[data.length-1]['form_master_escribir_xxx']=xxid[1];}}var xfinalfin=Ext.encode(data);Ext.getCmp(xxid[0]).setValue(xfinalfin);}}}/*grabar stores en hiddens*/},tbar:[{text:'Guardar',iconCls: 'icon-disk',handler: function(){ var form = Ext.getCmp('frm_formulario_87_73'); var f=form.getForm();if(f.isValid()){var band_f=true;try{band_f =form.Validar();}catch(e){}if(band_f){form.prepararGrids();f.submit({url:'http://192.168.10.116/sisad/build/view/'+'workflow/casos/casos_l.php',params:{wf_proceso_id:'87',wf_paso_id:'278',wf_tarea_id:'165',wf_caso_id:'73',id:'1232',accion:'nextPaso',reg:'s',rta:'n'},success:function(form, action){if(action.result.message) crearMsg(action.result.message,'Informacion');else if(action.result.execute){/*try{*/eval(action.result.execute);/*}catch(e){alert(e+'Se presentó un error , por favor cierre la pestaña del caso y continue el proceso desde la pestaña de resumen' );}*/}},failure: function(form, action) {switch (action.failureType) {case Ext.form.Action.CONNECT_FAILURE:Ext.Msg.alert('Error', 'En este momento no hay comunicación con el servidor intente más tarde');break;case Ext.form.Action.SERVER_INVALID: Ext.Msg.alert('Error', action.result.message); break; }}});}}else{Ext.MessageBox.alert('Advertencia',getErrorFields(f));}} } ] ,listeners:{ afterrender:function(){ try{ Ext.getCmp('frm_formulario_87_73').getForm().loadRecord(new Ext.data.Record({"cod_formulario":27,"oid_maestro":null,"cod_bloque":28,"412":null,"413":null,"414":null,"415":null,"416":null,"417":null,"423":null,"424":null,"425":null,"426":null})); llamadaAJAX({url:'http://192.168.10.116/sisad/build/view/workflow/casos/casos_datosForm.php',mostrarMsg:false,params:{accion:'verifica',wf_paso_id:'278',cod_formulario:'27',cod_bloque:'28',wf_caso_id:'{"pro":"87","cas":"73"}'}}); }catch(e){alert(e);} } } }) );Ext.getCmp('comp_1232').doLayout(); [suc] => 1 ) fin 2015-07-29 12:14:53 /******************************************************************************************************/ 2015-07-29 12:14:53TraerCaso(73,87,) CargarCaso :73 2015-07 29 12:14:53 CargarDatos: Caso :73 cargar datos de ejecucion de los ultimos pasos select p.*,b.wf_tarea_id as tarea_id, u.apellido||' '||u.nombre|| ': '||u.cargo as usr_ejec from (select max(id) as id, wf_caso_87_seguimiento_id,wf_paso_id from wf_caso_87_pasos a1 group by wf_caso_87_seguimiento_id,wf_paso_id order by id )a inner join wf_caso_87_pasos p using(id,wf_caso_87_seguimiento_id) inner join ( select max(id) as wf_caso_87_seguimiento_id,wf_caso_87_id,wf_tarea_id from wf_caso_87_seguimiento where wf_caso_87_id =? group by wf_caso_87_id,wf_tarea_id order by wf_caso_87_id,wf_caso_87_seguimiento_id ) b using(wf_caso_87_seguimiento_id) left join usuarios u using(core_usuario_id) {"0":"294","id":"294","1":"277","wf_paso_id":"277","2":"268","wf_caso_87_seguimiento_id":"268","3":"11","core_usuario_id":"11","4":"2015-07-29 12:11:10","fecha_ejec":"2015-07-29 12:11:10","5":"70","dato":"70","6":"sce.t33","tabla":"sce.t33","7":"162","tarea_id":"162","8":"siti soluciones German: ciudadano, gerente","usr_ejec":"siti soluciones German: ciudadano, gerente"} CargarDatos_277(70) se carga 87_162_277_33_34_4513 cargar datos de ejecucion de las tareas (las ultimas si el proceso tiene ciclos) select a.*, u.apellido||' '||u.nombre|| ': '||u.cargo as usr_asig , ur.apellido||' '||ur.nombre|| ': '||ur.cargo as usr_resol from wf_caso_87_seguimiento a inner join ( select max(b0.id) as id,b0.wf_caso_87_id,b0.wf_tarea_id from wf_caso_87_seguimiento b0 where b0.wf_caso_87_id =? group by b0.wf_caso_87_id,b0.wf_tarea_id order by wf_caso_87_id,id ) b using(id) left join usuarios u using(core_usuario_id) left join usuarios ur on ur.core_usuario_id=core_usuario_id_resol {"0":"268","id":"268","1":"73","wf_caso_87_id":"73","2":"162","wf_tarea_id":"162","3":null,"core_usuario_id":null,"4":"2015-07-29 12:11:02","fec_asig":"2015-07-29 12:11:02","5":"11","core_usuario_id_resol":"11","6":"2015-07-29 12:11:10","fec_resol":"2015-07-29 12:11:10","7":"162","wf_tarea_id_sig":"162","8":null,"usr_asig":null,"9":"siti soluciones German: ciudadano, gerente","usr_resol":"siti soluciones German: ciudadano, gerente"} {"0":"269","id":"269","1":"73","wf_caso_87_id":"73","2":"165","wf_tarea_id":"165","3":"11","core_usuario_id":"11","4":"2015-07-29 12:11:10","fec_asig":"2015-07-29 12:11:10","5":null,"core_usuario_id_resol":null,"6":null,"fec_resol":null,"7":"165","wf_tarea_id_sig":"165","8":"siti soluciones German: ciudadano, gerente","usr_asig":"siti soluciones German: ciudadano, gerente","9":null,"usr_resol":null} 2015-07 29 12:14:53 cargar datos del sujeto(,,s,87,73) select s.*, m.nombre as nom_muni, c.nom_cat,fec_caso from wf_caso_87 w inner join core_sujetoverificacion s on w.id=73 AND s.id =w.core_sujetoverificacion_id inner join plan_municipio m on s.plan_municipio_id=m.id inner join core_sujetocategoria c on s.core_sujetocategoria_id=c.id 2015-07 29 12:14:53 tabla dat adic select tabla from core_sujetoverificaciontipo where id=1 2015-07 29 12:14:53 tabla :persona SELECT * FROM persona where id=3 fin 2015-07-29 12:14:53 /******************************************************************************************************/