2015-07 29 18:16:00 Nuevo(20497,1) Caso :200 2015-07 29 18:16:00 cargar datos del sujeto(,,s,80,200) select s.*, m.nombre as nom_muni, c.nom_cat,fec_caso from wf_caso_80 w inner join core_sujetoverificacion s on w.id=200 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 18:16:00 tabla dat adic select tabla from core_sujetoverificaciontipo where id=1 2015-07 29 18:16:00 tabla :persona SELECT * FROM persona where id=20497 CasoSeguimiento :853 EjecutarTarea_172() Ingreso Datos id_comp1130 133 ValidarUsuario(172):1 EjecutarPaso_318: form:100 , caso=200 id_comp 1130 Mostrar form fin 2015-07-29 18:16:00 /******************************************************************************************************/ 2015-07-29 18:16:00TraerCaso(200,80,) CargarCaso :200 2015-07 29 18:16:00 CargarDatos: Caso :200 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_80_seguimiento_id,wf_paso_id from wf_caso_80_pasos a1 group by wf_caso_80_seguimiento_id,wf_paso_id order by id )a inner join wf_caso_80_pasos p using(id,wf_caso_80_seguimiento_id) inner join ( select max(id) as wf_caso_80_seguimiento_id,wf_caso_80_id,wf_tarea_id from wf_caso_80_seguimiento where wf_caso_80_id =? group by wf_caso_80_id,wf_tarea_id order by wf_caso_80_id,wf_caso_80_seguimiento_id ) b using(wf_caso_80_seguimiento_id) left join usuarios u using(core_usuario_id) where tabla not in ('sce.t53') 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_80_seguimiento a inner join ( select max(b0.id) as id,b0.wf_caso_80_id,b0.wf_tarea_id from wf_caso_80_seguimiento b0 where b0.wf_caso_80_id =? group by b0.wf_caso_80_id,b0.wf_tarea_id order by wf_caso_80_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":"853","id":"853","1":"200","wf_caso_80_id":"200","2":"172","wf_tarea_id":"172","3":null,"core_usuario_id":null,"4":"2015-07-29 18:16:00","fec_asig":"2015-07-29 18:16:00","5":null,"core_usuario_id_resol":null,"6":null,"fec_resol":null,"7":"172","wf_tarea_id_sig":"172","8":null,"usr_asig":null,"9":null,"usr_resol":null} 2015-07 29 18:16:00 cargar datos del sujeto(,,s,80,200) select s.*, m.nombre as nom_muni, c.nom_cat,fec_caso from wf_caso_80 w inner join core_sujetoverificacion s on w.id=200 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 18:16:00 tabla dat adic select tabla from core_sujetoverificaciontipo where id=1 2015-07 29 18:16:00 tabla :persona SELECT * FROM persona where id=20497 fin 2015-07-29 18:16:00 /******************************************************************************************************/ 2015-07-29 18:16:03TraerCaso(200,80,) CargarCaso :200 2015-07 29 18:16:03 CargarDatos: Caso :200 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_80_seguimiento_id,wf_paso_id from wf_caso_80_pasos a1 group by wf_caso_80_seguimiento_id,wf_paso_id order by id )a inner join wf_caso_80_pasos p using(id,wf_caso_80_seguimiento_id) inner join ( select max(id) as wf_caso_80_seguimiento_id,wf_caso_80_id,wf_tarea_id from wf_caso_80_seguimiento where wf_caso_80_id =? group by wf_caso_80_id,wf_tarea_id order by wf_caso_80_id,wf_caso_80_seguimiento_id ) b using(wf_caso_80_seguimiento_id) left join usuarios u using(core_usuario_id) where tabla not in ('sce.t53') 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_80_seguimiento a inner join ( select max(b0.id) as id,b0.wf_caso_80_id,b0.wf_tarea_id from wf_caso_80_seguimiento b0 where b0.wf_caso_80_id =? group by b0.wf_caso_80_id,b0.wf_tarea_id order by wf_caso_80_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":"853","id":"853","1":"200","wf_caso_80_id":"200","2":"172","wf_tarea_id":"172","3":null,"core_usuario_id":null,"4":"2015-07-29 18:16:00","fec_asig":"2015-07-29 18:16:00","5":null,"core_usuario_id_resol":null,"6":null,"fec_resol":null,"7":"172","wf_tarea_id_sig":"172","8":null,"usr_asig":null,"9":null,"usr_resol":null} 2015-07 29 18:16:03 cargar datos del sujeto(,,s,80,200) select s.*, m.nombre as nom_muni, c.nom_cat,fec_caso from wf_caso_80 w inner join core_sujetoverificacion s on w.id=200 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 18:16:03 tabla dat adic select tabla from core_sujetoverificaciontipo where id=1 2015-07 29 18:16:03 tabla :persona SELECT * FROM persona where id=20497 2015-07 29 18:16:03 Continuar(s,172,318,) EjecutarTarea_172() Ingreso Datos id_comp1130 133 ValidarUsuario(172):1 EjecutarPaso_318: form:100 , caso=200 id_comp 1130 Paso::Guardar(Caso:200) Datos a guardar: Array ( [wf_proceso_id] => 80 [wf_paso_id] => 318 [wf_tarea_id] => 172 [wf_caso_id] => 200 [id] => 1130 [accion] => nextPaso [reg] => s [rta] => n [cod_formulario2] => 100 [id_periodo] => 2015 [obs_ingreso] => [cod_bloque] => 118 [oid] => [oid_maestro] => [753] => 2 ) OID: 172 rta: 1 dato:172 tabla:sce.t100 CasoPaso:698 CargarDatos_318(172) se carga 80_172_318_100_118_7532 SiguientePasoDe318: Funcion para ejecutar el siguiente paso Condicion Tarea : true TerminarTarea(172,173) Ultimo seg :853 Ultimo seg :854 EjecutarTarea_173() Inscripción id_comp1130 133 133 ValidarUsuario(173):1 EjecutarPaso_319: form:101 , caso=200 id_comp 1130 Mostrar form Retorno : Array ( [ret] => Ext.getCmp('comp_1130').removeAll();Ext.getCmp('comp_1130').add(new Ext.form.FormPanel({ title: 'General' ,padding: 10,id:'frm_formulario_80_200',autoScroll:true ,labelAlign:'top',defaults: { anchor: '97%'} ,items: [new Ext.form.Hidden({name:'cod_formulario2',value:'101'}) ,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:'119'}) ,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:'754',id:'754_1',inputValue:1,boxLabel:'Profesional independiente'}), new Ext.form.Radio({name:'754',id:'754_3',inputValue:3,boxLabel:'Objeto social diferente'}), new Ext.form.Radio({name:'754',id:'754_4',inputValue:4,boxLabel:'Transporte especial de pacientes (ambulancias)'}), new Ext.form.Radio({name:'754',id:'754_2',inputValue:2,boxLabel:'Instituciones prestadoras de Salud (IPS públicas y privadas)'}) ],columns:1,allowBlank:false,fieldLabel:'* Tipo de solicitud del trámite',id:'754'}) ] ,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_80_200'); 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:'80',wf_paso_id:'319',wf_tarea_id:'173',wf_caso_id:'200',id:'1130',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_80_200').getForm().loadRecord(new Ext.data.Record({"cod_formulario":101,"oid_maestro":null,"cod_bloque":119})); llamadaAJAX({url:'http://192.168.10.116/sisad/build/view/workflow/casos/casos_datosForm.php',mostrarMsg:false,params:{accion:'verifica',wf_paso_id:'319',cod_formulario:'101',cod_bloque:'119',wf_caso_id:'{"pro":"80","cas":"200"}'}}); }catch(e){alert(e);} } } }) );Ext.getCmp('comp_1130').doLayout(); [suc] => 1 ) fin 2015-07-29 18:16:04 /******************************************************************************************************/ 2015-07-29 18:16:04TraerCaso(200,80,) CargarCaso :200 2015-07 29 18:16:04 CargarDatos: Caso :200 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_80_seguimiento_id,wf_paso_id from wf_caso_80_pasos a1 group by wf_caso_80_seguimiento_id,wf_paso_id order by id )a inner join wf_caso_80_pasos p using(id,wf_caso_80_seguimiento_id) inner join ( select max(id) as wf_caso_80_seguimiento_id,wf_caso_80_id,wf_tarea_id from wf_caso_80_seguimiento where wf_caso_80_id =? group by wf_caso_80_id,wf_tarea_id order by wf_caso_80_id,wf_caso_80_seguimiento_id ) b using(wf_caso_80_seguimiento_id) left join usuarios u using(core_usuario_id) where tabla not in ('sce.t53') {"0":"698","id":"698","1":"318","wf_paso_id":"318","2":"853","wf_caso_80_seguimiento_id":"853","3":"133","core_usuario_id":"133","4":"2015-07-29 18:16:03","fecha_ejec":"2015-07-29 18:16:03","5":"172","dato":"172","6":"sce.t100","tabla":"sce.t100","7":"172","tarea_id":"172","8":"anonimo anonimo: ciudadano","usr_ejec":"anonimo anonimo: ciudadano"} CargarDatos_318(172) se carga 80_172_318_100_118_7532 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_80_seguimiento a inner join ( select max(b0.id) as id,b0.wf_caso_80_id,b0.wf_tarea_id from wf_caso_80_seguimiento b0 where b0.wf_caso_80_id =? group by b0.wf_caso_80_id,b0.wf_tarea_id order by wf_caso_80_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":"853","id":"853","1":"200","wf_caso_80_id":"200","2":"172","wf_tarea_id":"172","3":null,"core_usuario_id":null,"4":"2015-07-29 18:16:00","fec_asig":"2015-07-29 18:16:00","5":"133","core_usuario_id_resol":"133","6":"2015-07-29 18:16:04","fec_resol":"2015-07-29 18:16:04","7":"172","wf_tarea_id_sig":"172","8":null,"usr_asig":null,"9":"anonimo anonimo: ciudadano","usr_resol":"anonimo anonimo: ciudadano"} {"0":"854","id":"854","1":"200","wf_caso_80_id":"200","2":"173","wf_tarea_id":"173","3":"133","core_usuario_id":"133","4":"2015-07-29 18:16:04","fec_asig":"2015-07-29 18:16:04","5":null,"core_usuario_id_resol":null,"6":null,"fec_resol":null,"7":"173","wf_tarea_id_sig":"173","8":"anonimo anonimo: ciudadano","usr_asig":"anonimo anonimo: ciudadano","9":null,"usr_resol":null} 2015-07 29 18:16:04 cargar datos del sujeto(,,s,80,200) select s.*, m.nombre as nom_muni, c.nom_cat,fec_caso from wf_caso_80 w inner join core_sujetoverificacion s on w.id=200 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 18:16:04 tabla dat adic select tabla from core_sujetoverificaciontipo where id=1 2015-07 29 18:16:04 tabla :persona SELECT * FROM persona where id=20497 fin 2015-07-29 18:16:04 /******************************************************************************************************/ 2015-07-29 18:16:07TraerCaso(200,80,) CargarCaso :200 2015-07 29 18:16:07 CargarDatos: Caso :200 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_80_seguimiento_id,wf_paso_id from wf_caso_80_pasos a1 group by wf_caso_80_seguimiento_id,wf_paso_id order by id )a inner join wf_caso_80_pasos p using(id,wf_caso_80_seguimiento_id) inner join ( select max(id) as wf_caso_80_seguimiento_id,wf_caso_80_id,wf_tarea_id from wf_caso_80_seguimiento where wf_caso_80_id =? group by wf_caso_80_id,wf_tarea_id order by wf_caso_80_id,wf_caso_80_seguimiento_id ) b using(wf_caso_80_seguimiento_id) left join usuarios u using(core_usuario_id) where tabla not in ('sce.t53') {"0":"698","id":"698","1":"318","wf_paso_id":"318","2":"853","wf_caso_80_seguimiento_id":"853","3":"133","core_usuario_id":"133","4":"2015-07-29 18:16:03","fecha_ejec":"2015-07-29 18:16:03","5":"172","dato":"172","6":"sce.t100","tabla":"sce.t100","7":"172","tarea_id":"172","8":"anonimo anonimo: ciudadano","usr_ejec":"anonimo anonimo: ciudadano"} CargarDatos_318(172) se carga 80_172_318_100_118_7532 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_80_seguimiento a inner join ( select max(b0.id) as id,b0.wf_caso_80_id,b0.wf_tarea_id from wf_caso_80_seguimiento b0 where b0.wf_caso_80_id =? group by b0.wf_caso_80_id,b0.wf_tarea_id order by wf_caso_80_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":"853","id":"853","1":"200","wf_caso_80_id":"200","2":"172","wf_tarea_id":"172","3":null,"core_usuario_id":null,"4":"2015-07-29 18:16:00","fec_asig":"2015-07-29 18:16:00","5":"133","core_usuario_id_resol":"133","6":"2015-07-29 18:16:04","fec_resol":"2015-07-29 18:16:04","7":"172","wf_tarea_id_sig":"172","8":null,"usr_asig":null,"9":"anonimo anonimo: ciudadano","usr_resol":"anonimo anonimo: ciudadano"} {"0":"854","id":"854","1":"200","wf_caso_80_id":"200","2":"173","wf_tarea_id":"173","3":"133","core_usuario_id":"133","4":"2015-07-29 18:16:04","fec_asig":"2015-07-29 18:16:04","5":null,"core_usuario_id_resol":null,"6":null,"fec_resol":null,"7":"173","wf_tarea_id_sig":"173","8":"anonimo anonimo: ciudadano","usr_asig":"anonimo anonimo: ciudadano","9":null,"usr_resol":null} 2015-07 29 18:16:07 cargar datos del sujeto(,,s,80,200) select s.*, m.nombre as nom_muni, c.nom_cat,fec_caso from wf_caso_80 w inner join core_sujetoverificacion s on w.id=200 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 18:16:07 tabla dat adic select tabla from core_sujetoverificaciontipo where id=1 2015-07 29 18:16:07 tabla :persona SELECT * FROM persona where id=20497 2015-07 29 18:16:07 Continuar(s,173,319,) EjecutarTarea_173() Inscripción id_comp1130 133 133 ValidarUsuario(173):1 EjecutarPaso_319: form:101 , caso=200 id_comp 1130 Paso::Guardar(Caso:200) Datos a guardar: Array ( [wf_proceso_id] => 80 [wf_paso_id] => 319 [wf_tarea_id] => 173 [wf_caso_id] => 200 [id] => 1130 [accion] => nextPaso [reg] => s [rta] => n [cod_formulario2] => 101 [id_periodo] => 2015 [obs_ingreso] => [cod_bloque] => 119 [oid] => [oid_maestro] => [754] => 3 ) OID: 144 rta: 1 dato:144 tabla:sce.t101 CasoPaso:699 CargarDatos_319(144) se carga 80_173_319_101_119_7543 SiguientePasoDe319: Funcion para ejecutar el siguiente paso Condicion Tarea : 3 ==1 && 2 ==1 Condicion Tarea : 3 ==2 && 2 ==1 Condicion Tarea : 3 ==3 && 2 ==1 Condicion Tarea : 2 ==2 TerminarTarea(173,174) Ultimo seg :854 Ultimo seg :855 EjecutarTarea_174() Novedad id_comp1130 133 133 ValidarUsuario(174):1 EjecutarPaso_320: form:102 , caso=200 id_comp 1130 Mostrar form Retorno : Array ( [ret] => Ext.getCmp('comp_1130').removeAll();Ext.getCmp('comp_1130').add(new Ext.form.FormPanel({ title: 'General' ,padding: 10,id:'frm_formulario_80_200',autoScroll:true ,labelAlign:'top',defaults: { anchor: '97%'} ,items: [new Ext.form.Hidden({name:'cod_formulario2',value:'102'}) ,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:'120'}) ,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:'755',id:'755_1',inputValue:1,boxLabel:'Novedades del prestador'}), new Ext.form.Radio({name:'755',id:'755_2',inputValue:2,boxLabel:'Novedades de la sede'}), new Ext.form.Radio({name:'755',id:'755_3',inputValue:3,boxLabel:'Novedades de servicio'}), new Ext.form.Radio({name:'755',id:'755_4',inputValue:4,boxLabel:'Novedades de capacidad instalada'}) ],columns:1,allowBlank:false,fieldLabel:'* Tipo de novedad',id:'755'}) ] ,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_80_200'); 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:'80',wf_paso_id:'320',wf_tarea_id:'174',wf_caso_id:'200',id:'1130',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_80_200').getForm().loadRecord(new Ext.data.Record({"cod_formulario":102,"oid_maestro":null,"cod_bloque":120})); llamadaAJAX({url:'http://192.168.10.116/sisad/build/view/workflow/casos/casos_datosForm.php',mostrarMsg:false,params:{accion:'verifica',wf_paso_id:'320',cod_formulario:'102',cod_bloque:'120',wf_caso_id:'{"pro":"80","cas":"200"}'}}); }catch(e){alert(e);} } } }) );Ext.getCmp('comp_1130').doLayout(); [suc] => 1 ) fin 2015-07-29 18:16:08 /******************************************************************************************************/ 2015-07-29 18:16:08TraerCaso(200,80,) CargarCaso :200 2015-07 29 18:16:08 CargarDatos: Caso :200 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_80_seguimiento_id,wf_paso_id from wf_caso_80_pasos a1 group by wf_caso_80_seguimiento_id,wf_paso_id order by id )a inner join wf_caso_80_pasos p using(id,wf_caso_80_seguimiento_id) inner join ( select max(id) as wf_caso_80_seguimiento_id,wf_caso_80_id,wf_tarea_id from wf_caso_80_seguimiento where wf_caso_80_id =? group by wf_caso_80_id,wf_tarea_id order by wf_caso_80_id,wf_caso_80_seguimiento_id ) b using(wf_caso_80_seguimiento_id) left join usuarios u using(core_usuario_id) where tabla not in ('sce.t53') {"0":"698","id":"698","1":"318","wf_paso_id":"318","2":"853","wf_caso_80_seguimiento_id":"853","3":"133","core_usuario_id":"133","4":"2015-07-29 18:16:03","fecha_ejec":"2015-07-29 18:16:03","5":"172","dato":"172","6":"sce.t100","tabla":"sce.t100","7":"172","tarea_id":"172","8":"anonimo anonimo: ciudadano","usr_ejec":"anonimo anonimo: ciudadano"} CargarDatos_318(172) se carga 80_172_318_100_118_7532 {"0":"699","id":"699","1":"319","wf_paso_id":"319","2":"854","wf_caso_80_seguimiento_id":"854","3":"133","core_usuario_id":"133","4":"2015-07-29 18:16:08","fecha_ejec":"2015-07-29 18:16:08","5":"144","dato":"144","6":"sce.t101","tabla":"sce.t101","7":"173","tarea_id":"173","8":"anonimo anonimo: ciudadano","usr_ejec":"anonimo anonimo: ciudadano"} CargarDatos_319(144) se carga 80_173_319_101_119_7543 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_80_seguimiento a inner join ( select max(b0.id) as id,b0.wf_caso_80_id,b0.wf_tarea_id from wf_caso_80_seguimiento b0 where b0.wf_caso_80_id =? group by b0.wf_caso_80_id,b0.wf_tarea_id order by wf_caso_80_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":"853","id":"853","1":"200","wf_caso_80_id":"200","2":"172","wf_tarea_id":"172","3":null,"core_usuario_id":null,"4":"2015-07-29 18:16:00","fec_asig":"2015-07-29 18:16:00","5":"133","core_usuario_id_resol":"133","6":"2015-07-29 18:16:04","fec_resol":"2015-07-29 18:16:04","7":"172","wf_tarea_id_sig":"172","8":null,"usr_asig":null,"9":"anonimo anonimo: ciudadano","usr_resol":"anonimo anonimo: ciudadano"} {"0":"854","id":"854","1":"200","wf_caso_80_id":"200","2":"173","wf_tarea_id":"173","3":"133","core_usuario_id":"133","4":"2015-07-29 18:16:04","fec_asig":"2015-07-29 18:16:04","5":"133","core_usuario_id_resol":"133","6":"2015-07-29 18:16:08","fec_resol":"2015-07-29 18:16:08","7":"173","wf_tarea_id_sig":"173","8":"anonimo anonimo: ciudadano","usr_asig":"anonimo anonimo: ciudadano","9":"anonimo anonimo: ciudadano","usr_resol":"anonimo anonimo: ciudadano"} {"0":"855","id":"855","1":"200","wf_caso_80_id":"200","2":"174","wf_tarea_id":"174","3":"133","core_usuario_id":"133","4":"2015-07-29 18:16:08","fec_asig":"2015-07-29 18:16:08","5":null,"core_usuario_id_resol":null,"6":null,"fec_resol":null,"7":"174","wf_tarea_id_sig":"174","8":"anonimo anonimo: ciudadano","usr_asig":"anonimo anonimo: ciudadano","9":null,"usr_resol":null} 2015-07 29 18:16:08 cargar datos del sujeto(,,s,80,200) select s.*, m.nombre as nom_muni, c.nom_cat,fec_caso from wf_caso_80 w inner join core_sujetoverificacion s on w.id=200 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 18:16:08 tabla dat adic select tabla from core_sujetoverificaciontipo where id=1 2015-07 29 18:16:08 tabla :persona SELECT * FROM persona where id=20497 fin 2015-07-29 18:16:08 /******************************************************************************************************/ 2015-07-29 18:16:10TraerCaso(200,80,) CargarCaso :200 2015-07 29 18:16:10 CargarDatos: Caso :200 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_80_seguimiento_id,wf_paso_id from wf_caso_80_pasos a1 group by wf_caso_80_seguimiento_id,wf_paso_id order by id )a inner join wf_caso_80_pasos p using(id,wf_caso_80_seguimiento_id) inner join ( select max(id) as wf_caso_80_seguimiento_id,wf_caso_80_id,wf_tarea_id from wf_caso_80_seguimiento where wf_caso_80_id =? group by wf_caso_80_id,wf_tarea_id order by wf_caso_80_id,wf_caso_80_seguimiento_id ) b using(wf_caso_80_seguimiento_id) left join usuarios u using(core_usuario_id) where tabla not in ('sce.t53') {"0":"698","id":"698","1":"318","wf_paso_id":"318","2":"853","wf_caso_80_seguimiento_id":"853","3":"133","core_usuario_id":"133","4":"2015-07-29 18:16:03","fecha_ejec":"2015-07-29 18:16:03","5":"172","dato":"172","6":"sce.t100","tabla":"sce.t100","7":"172","tarea_id":"172","8":"anonimo anonimo: ciudadano","usr_ejec":"anonimo anonimo: ciudadano"} CargarDatos_318(172) se carga 80_172_318_100_118_7532 {"0":"699","id":"699","1":"319","wf_paso_id":"319","2":"854","wf_caso_80_seguimiento_id":"854","3":"133","core_usuario_id":"133","4":"2015-07-29 18:16:08","fecha_ejec":"2015-07-29 18:16:08","5":"144","dato":"144","6":"sce.t101","tabla":"sce.t101","7":"173","tarea_id":"173","8":"anonimo anonimo: ciudadano","usr_ejec":"anonimo anonimo: ciudadano"} CargarDatos_319(144) se carga 80_173_319_101_119_7543 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_80_seguimiento a inner join ( select max(b0.id) as id,b0.wf_caso_80_id,b0.wf_tarea_id from wf_caso_80_seguimiento b0 where b0.wf_caso_80_id =? group by b0.wf_caso_80_id,b0.wf_tarea_id order by wf_caso_80_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":"853","id":"853","1":"200","wf_caso_80_id":"200","2":"172","wf_tarea_id":"172","3":null,"core_usuario_id":null,"4":"2015-07-29 18:16:00","fec_asig":"2015-07-29 18:16:00","5":"133","core_usuario_id_resol":"133","6":"2015-07-29 18:16:04","fec_resol":"2015-07-29 18:16:04","7":"172","wf_tarea_id_sig":"172","8":null,"usr_asig":null,"9":"anonimo anonimo: ciudadano","usr_resol":"anonimo anonimo: ciudadano"} {"0":"854","id":"854","1":"200","wf_caso_80_id":"200","2":"173","wf_tarea_id":"173","3":"133","core_usuario_id":"133","4":"2015-07-29 18:16:04","fec_asig":"2015-07-29 18:16:04","5":"133","core_usuario_id_resol":"133","6":"2015-07-29 18:16:08","fec_resol":"2015-07-29 18:16:08","7":"173","wf_tarea_id_sig":"173","8":"anonimo anonimo: ciudadano","usr_asig":"anonimo anonimo: ciudadano","9":"anonimo anonimo: ciudadano","usr_resol":"anonimo anonimo: ciudadano"} {"0":"855","id":"855","1":"200","wf_caso_80_id":"200","2":"174","wf_tarea_id":"174","3":"133","core_usuario_id":"133","4":"2015-07-29 18:16:08","fec_asig":"2015-07-29 18:16:08","5":null,"core_usuario_id_resol":null,"6":null,"fec_resol":null,"7":"174","wf_tarea_id_sig":"174","8":"anonimo anonimo: ciudadano","usr_asig":"anonimo anonimo: ciudadano","9":null,"usr_resol":null} 2015-07 29 18:16:10 cargar datos del sujeto(,,s,80,200) select s.*, m.nombre as nom_muni, c.nom_cat,fec_caso from wf_caso_80 w inner join core_sujetoverificacion s on w.id=200 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 18:16:10 tabla dat adic select tabla from core_sujetoverificaciontipo where id=1 2015-07 29 18:16:10 tabla :persona SELECT * FROM persona where id=20497 2015-07 29 18:16:10 Continuar(s,174,320,) EjecutarTarea_174() Novedad id_comp1130 133 133 ValidarUsuario(174):1 EjecutarPaso_320: form:102 , caso=200 id_comp 1130 Paso::Guardar(Caso:200) Datos a guardar: Array ( [wf_proceso_id] => 80 [wf_paso_id] => 320 [wf_tarea_id] => 174 [wf_caso_id] => 200 [id] => 1130 [accion] => nextPaso [reg] => s [rta] => n [cod_formulario2] => 102 [id_periodo] => 2015 [obs_ingreso] => [cod_bloque] => 120 [oid] => [oid_maestro] => [755] => 2 ) OID: 77 rta: 1 dato:77 tabla:sce.t102 CasoPaso:700 CargarDatos_320(77) se carga 80_174_320_102_120_7552 SiguientePasoDe320: Funcion para ejecutar el siguiente paso Condicion Tarea : 2 ==1 Condicion Tarea : 2 ==2 TerminarTarea(174,179) Ultimo seg :855 Ultimo seg :856 EjecutarTarea_179() Novedades de la Sede id_comp1130 133 133 ValidarUsuario(179):1 EjecutarPaso_325: form:105 , caso=200 id_comp 1130 Mostrar form Retorno : Array ( [ret] => Ext.getCmp('comp_1130').removeAll();Ext.getCmp('comp_1130').add(new Ext.form.FormPanel({ title: 'General' ,padding: 10,id:'frm_formulario_80_200',autoScroll:true ,labelAlign:'top',defaults: { anchor: '97%'} ,items: [new Ext.form.Hidden({name:'cod_formulario2',value:'105'}) ,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:'122'}) ,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:'757',id:'757_1',inputValue:1,boxLabel:'Apertura de la sede'}), new Ext.form.Radio({name:'757',id:'757_2',inputValue:2,boxLabel:'Cierre de sede'}), new Ext.form.Radio({name:'757',id:'757_3',inputValue:3,boxLabel:'Cambio de domicilio'}), new Ext.form.Radio({name:'757',id:'757_4',inputValue:4,boxLabel:'Cambio de nomenclatura'}), new Ext.form.Radio({name:'757',id:'757_5',inputValue:5,boxLabel:'Cambio de sede principal'}), new Ext.form.Radio({name:'757',id:'757_6',inputValue:6,boxLabel:'Cambio de datos de contacto (Incluye datos de teléfono, fax y correo electrónico)'}), new Ext.form.Radio({name:'757',id:'757_7',inputValue:7,boxLabel:'Cambio de director, gerente o responsable'}), new Ext.form.Radio({name:'757',id:'757_8',inputValue:8,boxLabel:'Cambio de nombre de la sede, que no implique cambio de razón social'}), new Ext.form.Radio({name:'757',id:'757_9',inputValue:9,boxLabel:'Cambio de horario de atención'}) ],columns:1,allowBlank:false,fieldLabel:'* Novedades de la sede',id:'757'}) ] ,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_80_200'); 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:'80',wf_paso_id:'325',wf_tarea_id:'179',wf_caso_id:'200',id:'1130',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_80_200').getForm().loadRecord(new Ext.data.Record({"cod_formulario":105,"oid_maestro":null,"cod_bloque":122})); llamadaAJAX({url:'http://192.168.10.116/sisad/build/view/workflow/casos/casos_datosForm.php',mostrarMsg:false,params:{accion:'verifica',wf_paso_id:'325',cod_formulario:'105',cod_bloque:'122',wf_caso_id:'{"pro":"80","cas":"200"}'}}); }catch(e){alert(e);} } } }) );Ext.getCmp('comp_1130').doLayout(); [suc] => 1 ) fin 2015-07-29 18:16:10 /******************************************************************************************************/ 2015-07-29 18:16:11TraerCaso(200,80,) CargarCaso :200 2015-07 29 18:16:11 CargarDatos: Caso :200 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_80_seguimiento_id,wf_paso_id from wf_caso_80_pasos a1 group by wf_caso_80_seguimiento_id,wf_paso_id order by id )a inner join wf_caso_80_pasos p using(id,wf_caso_80_seguimiento_id) inner join ( select max(id) as wf_caso_80_seguimiento_id,wf_caso_80_id,wf_tarea_id from wf_caso_80_seguimiento where wf_caso_80_id =? group by wf_caso_80_id,wf_tarea_id order by wf_caso_80_id,wf_caso_80_seguimiento_id ) b using(wf_caso_80_seguimiento_id) left join usuarios u using(core_usuario_id) where tabla not in ('sce.t53') {"0":"698","id":"698","1":"318","wf_paso_id":"318","2":"853","wf_caso_80_seguimiento_id":"853","3":"133","core_usuario_id":"133","4":"2015-07-29 18:16:03","fecha_ejec":"2015-07-29 18:16:03","5":"172","dato":"172","6":"sce.t100","tabla":"sce.t100","7":"172","tarea_id":"172","8":"anonimo anonimo: ciudadano","usr_ejec":"anonimo anonimo: ciudadano"} CargarDatos_318(172) se carga 80_172_318_100_118_7532 {"0":"699","id":"699","1":"319","wf_paso_id":"319","2":"854","wf_caso_80_seguimiento_id":"854","3":"133","core_usuario_id":"133","4":"2015-07-29 18:16:08","fecha_ejec":"2015-07-29 18:16:08","5":"144","dato":"144","6":"sce.t101","tabla":"sce.t101","7":"173","tarea_id":"173","8":"anonimo anonimo: ciudadano","usr_ejec":"anonimo anonimo: ciudadano"} CargarDatos_319(144) se carga 80_173_319_101_119_7543 {"0":"700","id":"700","1":"320","wf_paso_id":"320","2":"855","wf_caso_80_seguimiento_id":"855","3":"133","core_usuario_id":"133","4":"2015-07-29 18:16:10","fecha_ejec":"2015-07-29 18:16:10","5":"77","dato":"77","6":"sce.t102","tabla":"sce.t102","7":"174","tarea_id":"174","8":"anonimo anonimo: ciudadano","usr_ejec":"anonimo anonimo: ciudadano"} CargarDatos_320(77) se carga 80_174_320_102_120_7552 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_80_seguimiento a inner join ( select max(b0.id) as id,b0.wf_caso_80_id,b0.wf_tarea_id from wf_caso_80_seguimiento b0 where b0.wf_caso_80_id =? group by b0.wf_caso_80_id,b0.wf_tarea_id order by wf_caso_80_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":"853","id":"853","1":"200","wf_caso_80_id":"200","2":"172","wf_tarea_id":"172","3":null,"core_usuario_id":null,"4":"2015-07-29 18:16:00","fec_asig":"2015-07-29 18:16:00","5":"133","core_usuario_id_resol":"133","6":"2015-07-29 18:16:04","fec_resol":"2015-07-29 18:16:04","7":"172","wf_tarea_id_sig":"172","8":null,"usr_asig":null,"9":"anonimo anonimo: ciudadano","usr_resol":"anonimo anonimo: ciudadano"} {"0":"854","id":"854","1":"200","wf_caso_80_id":"200","2":"173","wf_tarea_id":"173","3":"133","core_usuario_id":"133","4":"2015-07-29 18:16:04","fec_asig":"2015-07-29 18:16:04","5":"133","core_usuario_id_resol":"133","6":"2015-07-29 18:16:08","fec_resol":"2015-07-29 18:16:08","7":"173","wf_tarea_id_sig":"173","8":"anonimo anonimo: ciudadano","usr_asig":"anonimo anonimo: ciudadano","9":"anonimo anonimo: ciudadano","usr_resol":"anonimo anonimo: ciudadano"} {"0":"855","id":"855","1":"200","wf_caso_80_id":"200","2":"174","wf_tarea_id":"174","3":"133","core_usuario_id":"133","4":"2015-07-29 18:16:08","fec_asig":"2015-07-29 18:16:08","5":"133","core_usuario_id_resol":"133","6":"2015-07-29 18:16:10","fec_resol":"2015-07-29 18:16:10","7":"174","wf_tarea_id_sig":"174","8":"anonimo anonimo: ciudadano","usr_asig":"anonimo anonimo: ciudadano","9":"anonimo anonimo: ciudadano","usr_resol":"anonimo anonimo: ciudadano"} {"0":"856","id":"856","1":"200","wf_caso_80_id":"200","2":"179","wf_tarea_id":"179","3":"133","core_usuario_id":"133","4":"2015-07-29 18:16:10","fec_asig":"2015-07-29 18:16:10","5":null,"core_usuario_id_resol":null,"6":null,"fec_resol":null,"7":"179","wf_tarea_id_sig":"179","8":"anonimo anonimo: ciudadano","usr_asig":"anonimo anonimo: ciudadano","9":null,"usr_resol":null} 2015-07 29 18:16:11 cargar datos del sujeto(,,s,80,200) select s.*, m.nombre as nom_muni, c.nom_cat,fec_caso from wf_caso_80 w inner join core_sujetoverificacion s on w.id=200 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 18:16:11 tabla dat adic select tabla from core_sujetoverificaciontipo where id=1 2015-07 29 18:16:11 tabla :persona SELECT * FROM persona where id=20497 fin 2015-07-29 18:16:11 /******************************************************************************************************/ 2015-07-29 18:16:17TraerCaso(200,80,) CargarCaso :200 2015-07 29 18:16:17 CargarDatos: Caso :200 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_80_seguimiento_id,wf_paso_id from wf_caso_80_pasos a1 group by wf_caso_80_seguimiento_id,wf_paso_id order by id )a inner join wf_caso_80_pasos p using(id,wf_caso_80_seguimiento_id) inner join ( select max(id) as wf_caso_80_seguimiento_id,wf_caso_80_id,wf_tarea_id from wf_caso_80_seguimiento where wf_caso_80_id =? group by wf_caso_80_id,wf_tarea_id order by wf_caso_80_id,wf_caso_80_seguimiento_id ) b using(wf_caso_80_seguimiento_id) left join usuarios u using(core_usuario_id) where tabla not in ('sce.t53') {"0":"698","id":"698","1":"318","wf_paso_id":"318","2":"853","wf_caso_80_seguimiento_id":"853","3":"133","core_usuario_id":"133","4":"2015-07-29 18:16:03","fecha_ejec":"2015-07-29 18:16:03","5":"172","dato":"172","6":"sce.t100","tabla":"sce.t100","7":"172","tarea_id":"172","8":"anonimo anonimo: ciudadano","usr_ejec":"anonimo anonimo: ciudadano"} CargarDatos_318(172) se carga 80_172_318_100_118_7532 {"0":"699","id":"699","1":"319","wf_paso_id":"319","2":"854","wf_caso_80_seguimiento_id":"854","3":"133","core_usuario_id":"133","4":"2015-07-29 18:16:08","fecha_ejec":"2015-07-29 18:16:08","5":"144","dato":"144","6":"sce.t101","tabla":"sce.t101","7":"173","tarea_id":"173","8":"anonimo anonimo: ciudadano","usr_ejec":"anonimo anonimo: ciudadano"} CargarDatos_319(144) se carga 80_173_319_101_119_7543 {"0":"700","id":"700","1":"320","wf_paso_id":"320","2":"855","wf_caso_80_seguimiento_id":"855","3":"133","core_usuario_id":"133","4":"2015-07-29 18:16:10","fecha_ejec":"2015-07-29 18:16:10","5":"77","dato":"77","6":"sce.t102","tabla":"sce.t102","7":"174","tarea_id":"174","8":"anonimo anonimo: ciudadano","usr_ejec":"anonimo anonimo: ciudadano"} CargarDatos_320(77) se carga 80_174_320_102_120_7552 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_80_seguimiento a inner join ( select max(b0.id) as id,b0.wf_caso_80_id,b0.wf_tarea_id from wf_caso_80_seguimiento b0 where b0.wf_caso_80_id =? group by b0.wf_caso_80_id,b0.wf_tarea_id order by wf_caso_80_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":"853","id":"853","1":"200","wf_caso_80_id":"200","2":"172","wf_tarea_id":"172","3":null,"core_usuario_id":null,"4":"2015-07-29 18:16:00","fec_asig":"2015-07-29 18:16:00","5":"133","core_usuario_id_resol":"133","6":"2015-07-29 18:16:04","fec_resol":"2015-07-29 18:16:04","7":"172","wf_tarea_id_sig":"172","8":null,"usr_asig":null,"9":"anonimo anonimo: ciudadano","usr_resol":"anonimo anonimo: ciudadano"} {"0":"854","id":"854","1":"200","wf_caso_80_id":"200","2":"173","wf_tarea_id":"173","3":"133","core_usuario_id":"133","4":"2015-07-29 18:16:04","fec_asig":"2015-07-29 18:16:04","5":"133","core_usuario_id_resol":"133","6":"2015-07-29 18:16:08","fec_resol":"2015-07-29 18:16:08","7":"173","wf_tarea_id_sig":"173","8":"anonimo anonimo: ciudadano","usr_asig":"anonimo anonimo: ciudadano","9":"anonimo anonimo: ciudadano","usr_resol":"anonimo anonimo: ciudadano"} {"0":"855","id":"855","1":"200","wf_caso_80_id":"200","2":"174","wf_tarea_id":"174","3":"133","core_usuario_id":"133","4":"2015-07-29 18:16:08","fec_asig":"2015-07-29 18:16:08","5":"133","core_usuario_id_resol":"133","6":"2015-07-29 18:16:10","fec_resol":"2015-07-29 18:16:10","7":"174","wf_tarea_id_sig":"174","8":"anonimo anonimo: ciudadano","usr_asig":"anonimo anonimo: ciudadano","9":"anonimo anonimo: ciudadano","usr_resol":"anonimo anonimo: ciudadano"} {"0":"856","id":"856","1":"200","wf_caso_80_id":"200","2":"179","wf_tarea_id":"179","3":"133","core_usuario_id":"133","4":"2015-07-29 18:16:10","fec_asig":"2015-07-29 18:16:10","5":null,"core_usuario_id_resol":null,"6":null,"fec_resol":null,"7":"179","wf_tarea_id_sig":"179","8":"anonimo anonimo: ciudadano","usr_asig":"anonimo anonimo: ciudadano","9":null,"usr_resol":null} 2015-07 29 18:16:17 cargar datos del sujeto(,,s,80,200) select s.*, m.nombre as nom_muni, c.nom_cat,fec_caso from wf_caso_80 w inner join core_sujetoverificacion s on w.id=200 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 18:16:17 tabla dat adic select tabla from core_sujetoverificaciontipo where id=1 2015-07 29 18:16:17 tabla :persona SELECT * FROM persona where id=20497 2015-07 29 18:16:17 Continuar(s,179,325,) EjecutarTarea_179() Novedades de la Sede id_comp1130 133 133 ValidarUsuario(179):1 EjecutarPaso_325: form:105 , caso=200 id_comp 1130 Paso::Guardar(Caso:200) Datos a guardar: Array ( [wf_proceso_id] => 80 [wf_paso_id] => 325 [wf_tarea_id] => 179 [wf_caso_id] => 200 [id] => 1130 [accion] => nextPaso [reg] => s [rta] => n [cod_formulario2] => 105 [id_periodo] => 2015 [obs_ingreso] => [cod_bloque] => 122 [oid] => [oid_maestro] => [757] => 4 ) OID: 9 rta: 1 dato:9 tabla:sce.t105 CasoPaso:701 CargarDatos_325(9) se carga 80_179_325_105_122_7574 SiguientePasoDe325: Funcion para ejecutar el siguiente paso Condicion Tarea : 3 ==1 && 2 ==2 && 4 ==1 Condicion Tarea : 3 ==2 && 2 ==2 && 4 ==1 Condicion Tarea : 3 ==4 && 2 ==2 && 4 ==1 Condicion Tarea : 3 ==3 && 2 ==2 && 4 ==1 Condicion Tarea : 3 ==1 && 2 ==2 && 4 ==2 Condicion Tarea : 3 ==2 && 2 ==2 && 4 ==2 Condicion Tarea : 3 ==3 && 2 ==2 && 4 ==2 Condicion Tarea : 3 ==4 && 2 ==2 && 4 ==2 Condicion Tarea : 3 ==1 && 2 ==2 && 4 ==3 Condicion Tarea : 3 ==2 && 2 ==2 && 4 ==3 Condicion Tarea : 3 ==3 && 2 ==2 && 4 ==3 Condicion Tarea : 3 ==4 && 2 ==2 && 4 ==3 Condicion Tarea : 3 ==1 && 2 ==2 && 4 ==4 Condicion Tarea : 3 ==2 && 2 ==2 && 4 ==4 Condicion Tarea : 3 ==3 && 2 ==2 && 4 ==4 TerminarTarea(179,187) Ultimo seg :856 Ultimo seg :857 EjecutarTarea_187() Adj_grupo03N id_comp1130 133 133 ValidarUsuario(187):1 EjecutarPaso_333: ladj:3 , caso=200 id_comp 1130 Mostrar ladj Retorno : Array ( [ret] => inicioComponente_WF_ladj({"tarea_id":187,"paso_id":333,"id":"1130","proceso_id":80,"caso_id":"200","sujeto_id":"20497","ladj":3}); [suc] => 1 ) fin 2015-07-29 18:16:17 /******************************************************************************************************/ 2015-07-29 18:16:29TraerCaso(200,80,) CargarCaso :200 2015-07 29 18:16:29 CargarDatos: Caso :200 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_80_seguimiento_id,wf_paso_id from wf_caso_80_pasos a1 group by wf_caso_80_seguimiento_id,wf_paso_id order by id )a inner join wf_caso_80_pasos p using(id,wf_caso_80_seguimiento_id) inner join ( select max(id) as wf_caso_80_seguimiento_id,wf_caso_80_id,wf_tarea_id from wf_caso_80_seguimiento where wf_caso_80_id =? group by wf_caso_80_id,wf_tarea_id order by wf_caso_80_id,wf_caso_80_seguimiento_id ) b using(wf_caso_80_seguimiento_id) left join usuarios u using(core_usuario_id) where tabla not in ('sce.t53') {"0":"698","id":"698","1":"318","wf_paso_id":"318","2":"853","wf_caso_80_seguimiento_id":"853","3":"133","core_usuario_id":"133","4":"2015-07-29 18:16:03","fecha_ejec":"2015-07-29 18:16:03","5":"172","dato":"172","6":"sce.t100","tabla":"sce.t100","7":"172","tarea_id":"172","8":"anonimo anonimo: ciudadano","usr_ejec":"anonimo anonimo: ciudadano"} CargarDatos_318(172) se carga 80_172_318_100_118_7532 {"0":"699","id":"699","1":"319","wf_paso_id":"319","2":"854","wf_caso_80_seguimiento_id":"854","3":"133","core_usuario_id":"133","4":"2015-07-29 18:16:08","fecha_ejec":"2015-07-29 18:16:08","5":"144","dato":"144","6":"sce.t101","tabla":"sce.t101","7":"173","tarea_id":"173","8":"anonimo anonimo: ciudadano","usr_ejec":"anonimo anonimo: ciudadano"} CargarDatos_319(144) se carga 80_173_319_101_119_7543 {"0":"700","id":"700","1":"320","wf_paso_id":"320","2":"855","wf_caso_80_seguimiento_id":"855","3":"133","core_usuario_id":"133","4":"2015-07-29 18:16:10","fecha_ejec":"2015-07-29 18:16:10","5":"77","dato":"77","6":"sce.t102","tabla":"sce.t102","7":"174","tarea_id":"174","8":"anonimo anonimo: ciudadano","usr_ejec":"anonimo anonimo: ciudadano"} CargarDatos_320(77) se carga 80_174_320_102_120_7552 {"0":"701","id":"701","1":"325","wf_paso_id":"325","2":"856","wf_caso_80_seguimiento_id":"856","3":"133","core_usuario_id":"133","4":"2015-07-29 18:16:17","fecha_ejec":"2015-07-29 18:16:17","5":"9","dato":"9","6":"sce.t105","tabla":"sce.t105","7":"179","tarea_id":"179","8":"anonimo anonimo: ciudadano","usr_ejec":"anonimo anonimo: ciudadano"} CargarDatos_325(9) se carga 80_179_325_105_122_7574 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_80_seguimiento a inner join ( select max(b0.id) as id,b0.wf_caso_80_id,b0.wf_tarea_id from wf_caso_80_seguimiento b0 where b0.wf_caso_80_id =? group by b0.wf_caso_80_id,b0.wf_tarea_id order by wf_caso_80_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":"853","id":"853","1":"200","wf_caso_80_id":"200","2":"172","wf_tarea_id":"172","3":null,"core_usuario_id":null,"4":"2015-07-29 18:16:00","fec_asig":"2015-07-29 18:16:00","5":"133","core_usuario_id_resol":"133","6":"2015-07-29 18:16:04","fec_resol":"2015-07-29 18:16:04","7":"172","wf_tarea_id_sig":"172","8":null,"usr_asig":null,"9":"anonimo anonimo: ciudadano","usr_resol":"anonimo anonimo: ciudadano"} {"0":"854","id":"854","1":"200","wf_caso_80_id":"200","2":"173","wf_tarea_id":"173","3":"133","core_usuario_id":"133","4":"2015-07-29 18:16:04","fec_asig":"2015-07-29 18:16:04","5":"133","core_usuario_id_resol":"133","6":"2015-07-29 18:16:08","fec_resol":"2015-07-29 18:16:08","7":"173","wf_tarea_id_sig":"173","8":"anonimo anonimo: ciudadano","usr_asig":"anonimo anonimo: ciudadano","9":"anonimo anonimo: ciudadano","usr_resol":"anonimo anonimo: ciudadano"} {"0":"855","id":"855","1":"200","wf_caso_80_id":"200","2":"174","wf_tarea_id":"174","3":"133","core_usuario_id":"133","4":"2015-07-29 18:16:08","fec_asig":"2015-07-29 18:16:08","5":"133","core_usuario_id_resol":"133","6":"2015-07-29 18:16:10","fec_resol":"2015-07-29 18:16:10","7":"174","wf_tarea_id_sig":"174","8":"anonimo anonimo: ciudadano","usr_asig":"anonimo anonimo: ciudadano","9":"anonimo anonimo: ciudadano","usr_resol":"anonimo anonimo: ciudadano"} {"0":"856","id":"856","1":"200","wf_caso_80_id":"200","2":"179","wf_tarea_id":"179","3":"133","core_usuario_id":"133","4":"2015-07-29 18:16:10","fec_asig":"2015-07-29 18:16:10","5":"133","core_usuario_id_resol":"133","6":"2015-07-29 18:16:17","fec_resol":"2015-07-29 18:16:17","7":"179","wf_tarea_id_sig":"179","8":"anonimo anonimo: ciudadano","usr_asig":"anonimo anonimo: ciudadano","9":"anonimo anonimo: ciudadano","usr_resol":"anonimo anonimo: ciudadano"} {"0":"857","id":"857","1":"200","wf_caso_80_id":"200","2":"187","wf_tarea_id":"187","3":"133","core_usuario_id":"133","4":"2015-07-29 18:16:17","fec_asig":"2015-07-29 18:16:17","5":null,"core_usuario_id_resol":null,"6":null,"fec_resol":null,"7":"187","wf_tarea_id_sig":"187","8":"anonimo anonimo: ciudadano","usr_asig":"anonimo anonimo: ciudadano","9":null,"usr_resol":null} 2015-07 29 18:16:29 cargar datos del sujeto(,,s,80,200) select s.*, m.nombre as nom_muni, c.nom_cat,fec_caso from wf_caso_80 w inner join core_sujetoverificacion s on w.id=200 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 18:16:29 tabla dat adic select tabla from core_sujetoverificaciontipo where id=1 2015-07 29 18:16:29 tabla :persona SELECT * FROM persona where id=20497 2015-07 29 18:16:29 Continuar(s,187,333,) EjecutarTarea_187() Adj_grupo03N id_comp1130 133 133 ValidarUsuario(187):1 EjecutarPaso_333: ladj:3 , caso=200 id_comp 1130 Paso::Guardar(Caso:200) rta: 1 dato:2533 tabla:wf_documentoentradaadj_caso CasoPaso:702 CargarDatos_333(2533) SiguientePasoDe333: Funcion para ejecutar el siguiente paso Condicion Tarea : true TerminarTarea(187,196) Ultimo seg :857 Ultimo seg :858 EjecutarTarea_196() correo registro info id_comp1130 133 133 ValidarUsuario(196):1 EjecutarPaso_346: corr:56 , caso=200 id_comp 1130 Mostrar corr ob_start(); $ciud = mb_strtoupper( "{ WFSV_79 } { WFSV_80 }",'utf-8'); ?>
Apreciado(a)
El presente mensaje es una notificación para el caso No