2015-06 30 17:02:35 Nuevo(101,1) Caso :60 2015-06 30 17:02:35 cargar datos del sujeto(,,s,87,60) 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=60 AND s.id =w.core_sujetoverificacion_id inner join plan_municipio m on s.plan_municipio_id=m.id inner join core_sujetocategoria c on s.core_sujetocategoria_id=c.id 2015-06 30 17:02:35 tabla dat adic select tabla from core_sujetoverificaciontipo where id=1 2015-06 30 17:02:35 tabla :persona SELECT * FROM persona where id=101 CasoSeguimiento :216 EjecutarTarea_162() Tipo fromulario id_comp1229 51 ValidarUsuario(162):1 EjecutarPaso_277: form:33 , caso=60 id_comp 1229 Mostrar form fin 2015-06-30 17:02:35 /******************************************************************************************************/ 2015-06-30 17:02:35TraerCaso(60,87,) CargarCaso :60 2015-06 30 17:02:35 CargarDatos: Caso :60 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":"216","id":"216","1":"60","wf_caso_87_id":"60","2":"162","wf_tarea_id":"162","3":null,"core_usuario_id":null,"4":"2015-06-30 17:02:35","fec_asig":"2015-06-30 17:02:35","5":null,"core_usuario_id_resol":null,"6":null,"fec_resol":null,"7":"162","wf_tarea_id_sig":"162","8":null,"usr_asig":null,"9":null,"usr_resol":null} 2015-06 30 17:02:35 cargar datos del sujeto(,,s,87,60) 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=60 AND s.id =w.core_sujetoverificacion_id inner join plan_municipio m on s.plan_municipio_id=m.id inner join core_sujetocategoria c on s.core_sujetocategoria_id=c.id 2015-06 30 17:02:35 tabla dat adic select tabla from core_sujetoverificaciontipo where id=1 2015-06 30 17:02:35 tabla :persona SELECT * FROM persona where id=101 fin 2015-06-30 17:02:35 /******************************************************************************************************/ 2015-06-30 17:02:38TraerCaso(60,87,) CargarCaso :60 2015-06 30 17:02:38 CargarDatos: Caso :60 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":"216","id":"216","1":"60","wf_caso_87_id":"60","2":"162","wf_tarea_id":"162","3":null,"core_usuario_id":null,"4":"2015-06-30 17:02:35","fec_asig":"2015-06-30 17:02:35","5":null,"core_usuario_id_resol":null,"6":null,"fec_resol":null,"7":"162","wf_tarea_id_sig":"162","8":null,"usr_asig":null,"9":null,"usr_resol":null} 2015-06 30 17:02:38 cargar datos del sujeto(,,s,87,60) 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=60 AND s.id =w.core_sujetoverificacion_id inner join plan_municipio m on s.plan_municipio_id=m.id inner join core_sujetocategoria c on s.core_sujetocategoria_id=c.id 2015-06 30 17:02:38 tabla dat adic select tabla from core_sujetoverificaciontipo where id=1 2015-06 30 17:02:38 tabla :persona SELECT * FROM persona where id=101 2015-06 30 17:02:38 Continuar(s,162,277,) EjecutarTarea_162() Tipo fromulario id_comp1229 51 ValidarUsuario(162):1 EjecutarPaso_277: form:33 , caso=60 id_comp 1229 Paso::Guardar(Caso:60) Datos a guardar: Array ( [wf_proceso_id] => 87 [wf_paso_id] => 277 [wf_tarea_id] => 162 [wf_caso_id] => 60 [id] => 1229 [accion] => nextPaso [reg] => s [rta] => n [cod_formulario2] => 33 [id_periodo] => 2015 [obs_ingreso] => [cod_bloque] => 34 [oid] => [oid_maestro] => [451] => 1 ) OID: 59 rta: 1 dato:59 tabla:sce.t33 CasoPaso:243 CargarDatos_277(59) se carga 87_162_277_33_34_4511 SiguientePasoDe277: Funcion para ejecutar el siguiente paso Condicion Tarea : 1 ==1 TerminarTarea(162,163) Ultimo seg :216 Ultimo seg :217 EjecutarTarea_163() Concurso musica campesina id_comp1229 51 51 ValidarUsuario(163):1 EjecutarPaso_280: form:29 , caso=60 id_comp 1229 Mostrar form Retorno : Array ( [ret] => Ext.getCmp('comp_1229').removeAll();Ext.getCmp('comp_1229').add(new Ext.form.FormPanel({ title: 'Ingreso de datos' ,padding: 10,id:'frm_formulario_87_60',autoScroll:true ,labelAlign:'top',defaults: { anchor: '97%'} ,items: [new Ext.form.Hidden({name:'cod_formulario2',value:'29'}) ,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:'32'}) ,new Ext.form.Hidden({name :'oid',value:''}) ,new Ext.form.Hidden({name :'oid_maestro',value:''}) ,new Ext.form.Hidden({ value:'2015-06-30', id:'432'}),new Ext.form.Label({ style:{ 'font-weight':'bold' } , text:'Agrupación musical',id:'438',fieldLabel:''}),new Ext.form.RadioGroup({columns:2,items:[ new Ext.form.Radio({name:'433',id:'433_1',inputValue:1,boxLabel:'Tradicional'}), new Ext.form.Radio({name:'433',id:'433_2',inputValue:2,boxLabel:'Nuevas tendencias'}) ],columns:2,allowBlank:false,fieldLabel:'* Categoria',id:'433'}),{value:'',xtype:'textfield' , maxLength:60,autoCreate:{ tag:'input',maxlength:'60'} ,allowBlank:false,id:'434',fieldLabel:'* Corregimiento de origen' },{value:'',xtype:'textfield' , maxLength:60,autoCreate:{ tag:'input',maxlength:'60'} ,allowBlank:false,id:'435',fieldLabel:'* Vereda' },{value:'',xtype:'textfield' , maxLength:60,autoCreate:{ tag:'input',maxlength:'60'} ,allowBlank:false,id:'436',fieldLabel:'* Corregimiento donde participarán' },new Ext.form.Label({ style:{ 'font-weight':'bold' } , text:'Compositor',id:'437',fieldLabel:''}),{value:'',xtype:'textfield' , maxLength:60,autoCreate:{ tag:'input',maxlength:'60'} ,allowBlank:false,id:'439',fieldLabel:'* Nombre completo',maskRe:/^[a-z_A-Z\s]$/ },{value:'',xtype:'textfield' , maxLength:10,autoCreate:{ tag:'input',maxlength:'10'} ,allowBlank:false,id:'440',fieldLabel:'* Documento de identificación',maskRe:/^[0-9]$/ },{value:'',xtype:'textfield' , maxLength:60,autoCreate:{ tag:'input',maxlength:'60'} ,allowBlank:false,id:'441',fieldLabel:'* Lugar de expedición',maskRe:/^[a-z_A-Z\s_()]$/ },new Ext.form.DateField({fieldLabel:'* Fecha de nacimiento',name:'442',allowBlank:false,maskRe:/^[-_0-9]$/,format:FormatoFecha,renderer:Ext.util.Format.dateRenderer(FormatoFecha) ,listeners:{'change': function() { var fecha= new Date('2010-06-30'); if(this.getValue()>=fecha){Ext.Msg.alert('Advertencia','La fecha es incorrecta debe ser menor a la fecha ingresada ');this.setValue('');} }} }),{value:'',xtype:'textfield' , maxLength:60,autoCreate:{ tag:'input',maxlength:'60'} ,allowBlank:false,id:'443',fieldLabel:'* Lugar de nacimiento' },{value:'',xtype:'textfield' , maxLength:60,autoCreate:{ tag:'input',maxlength:'60'} ,allowBlank:false,id:'444',fieldLabel:'* Domicilio' },{value:'',xtype:'textfield' , maxLength:10,autoCreate:{ tag:'input',maxlength:'10'} ,allowBlank:false,id:'445',fieldLabel:'* Teléfono',maskRe:/^[0-9]$/ },{ xtype:'hidden',id:'hdcampo446',value:'31'},{ xtype:'hidden',id:'446'}, new Ext.grid.EditorGridPanel({xtype:'editorgrid',store:new Ext.data.JsonStore({ fields:[{ name:'oid' },{ name:'txttit' },{ name:'txtritmo' }]}),columns:[new Ext.grid.RowNumberer({width:30}),{header:'Titulo',dataIndex:'txttit',width:80,resizable:true,sortable:true,editor:{value:'',xtype:'textfield' , maxLength:50,autoCreate:{ tag:'input',maxlength:'50'} ,allowBlank:false}},{header:'Ritmo',dataIndex:'txtritmo',width:80,resizable:true,sortable:true,editor:{value:'',xtype:'textfield' , maxLength:50,autoCreate:{ tag:'input',maxlength:'50'} ,allowBlank:false,maskRe:/^[a-z_A-Z\s_()]$/}}],stripeRows:true,height:150,id:'446_31',title:'Temas inéditos a interpretar (maximo 5 minutos)',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();},afterrender:function(){var j;/*=[{"txtgcargo":"Presidente"},{"txtgcargo":"Vicepresidente"},{"txtgcargo":"Secretario"},{"txtgcargo":"Tesorero"}]*/;}}},tbar:[]})/*fgp*/,{ xtype:'hidden',id:'hdcampo447',value:'30'},{ xtype:'hidden',id:'447'}, new Ext.grid.EditorGridPanel({xtype:'editorgrid',store:new Ext.data.JsonStore({ fields:[{ name:'oid' },{ name:'txtnomi' },{ name:'txtedad' },{ name:'txtdoci' }]}),columns:[new Ext.grid.RowNumberer({width:30}),{header:'Nombre',dataIndex:'txtnomi',width:80,resizable:true,sortable:true,editor:{value:'',maskRe:/^[a-z_A-Z\s]$/,xtype:'textfield' , maxLength:50,autoCreate:{ tag:'input',maxlength:'50'} ,allowBlank:false}},{header:'Edad',dataIndex:'txtedad',width:80,resizable:true,sortable:true,editor:{value:'',xtype:'textfield' , maxLength:2,autoCreate:{ tag:'input',maxlength:'2'} ,allowBlank:false,maskRe:/^[0-9]$/}},{header:'Documento de identificación',dataIndex:'txtdoci',width:80,resizable:true,sortable:true,editor:{value:'',xtype:'textfield' , maxLength:10,autoCreate:{ tag:'input',maxlength:'10'} ,allowBlank:false,maskRe:/^[0-9]$/}}],stripeRows:true,height:150,id:'447_30',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:'txtnomi' },{ name:'txtedad' },{ name:'txtdoci' });var myNewRecord = new TopicRecord({ oid:null ,txtnomi:'',txtedad:'',txtdoci:''});var storegri = Ext.getCmp('447_30').getStore();storegri.add(myNewRecord);}},{iconCls:'icon-delete',tooltip:'Eliminar',text:'Eliminar',handler:function(){var grid = Ext.getCmp('447_30');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*/ ] ,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 gr=Ext.getCmp('446_31').getStore().getAt(0);var grr=Ext.getCmp('446_31').getStore().getAt(1);var g=Ext.getCmp('447_30');var sw=0;var sw2=0;var co=g.getStore().getCount();if(g.getStore().getCount()>0){for(i=0;i 1 ) fin 2015-06-30 17:02:38 /******************************************************************************************************/ 2015-06-30 17:02:39TraerCaso(60,87,) CargarCaso :60 2015-06 30 17:02:39 CargarDatos: Caso :60 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":"243","id":"243","1":"277","wf_paso_id":"277","2":"216","wf_caso_87_seguimiento_id":"216","3":"51","core_usuario_id":"51","4":"2015-06-30 17:02:38","fecha_ejec":"2015-06-30 17:02:38","5":"59","dato":"59","6":"sce.t33","tabla":"sce.t33","7":"162","tarea_id":"162","8":"Ruano Marcela: ciudadano","usr_ejec":"Ruano Marcela: ciudadano"} CargarDatos_277(59) se carga 87_162_277_33_34_4511 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":"216","id":"216","1":"60","wf_caso_87_id":"60","2":"162","wf_tarea_id":"162","3":null,"core_usuario_id":null,"4":"2015-06-30 17:02:35","fec_asig":"2015-06-30 17:02:35","5":"51","core_usuario_id_resol":"51","6":"2015-06-30 17:02:38","fec_resol":"2015-06-30 17:02:38","7":"162","wf_tarea_id_sig":"162","8":null,"usr_asig":null,"9":"Ruano Marcela: ciudadano","usr_resol":"Ruano Marcela: ciudadano"} {"0":"217","id":"217","1":"60","wf_caso_87_id":"60","2":"163","wf_tarea_id":"163","3":"51","core_usuario_id":"51","4":"2015-06-30 17:02:38","fec_asig":"2015-06-30 17:02:38","5":null,"core_usuario_id_resol":null,"6":null,"fec_resol":null,"7":"163","wf_tarea_id_sig":"163","8":"Ruano Marcela: ciudadano","usr_asig":"Ruano Marcela: ciudadano","9":null,"usr_resol":null} 2015-06 30 17:02:39 cargar datos del sujeto(,,s,87,60) 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=60 AND s.id =w.core_sujetoverificacion_id inner join plan_municipio m on s.plan_municipio_id=m.id inner join core_sujetocategoria c on s.core_sujetocategoria_id=c.id 2015-06 30 17:02:39 tabla dat adic select tabla from core_sujetoverificaciontipo where id=1 2015-06 30 17:02:39 tabla :persona SELECT * FROM persona where id=101 fin 2015-06-30 17:02:39 /******************************************************************************************************/ 2015-06-30 17:08:26TraerCaso(60,87,) CargarCaso :60 2015-06 30 17:08:26 CargarDatos: Caso :60 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":"243","id":"243","1":"277","wf_paso_id":"277","2":"216","wf_caso_87_seguimiento_id":"216","3":"51","core_usuario_id":"51","4":"2015-06-30 17:02:38","fecha_ejec":"2015-06-30 17:02:38","5":"59","dato":"59","6":"sce.t33","tabla":"sce.t33","7":"162","tarea_id":"162","8":"Ruano Marcela: ciudadano","usr_ejec":"Ruano Marcela: ciudadano"} CargarDatos_277(59) se carga 87_162_277_33_34_4511 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":"216","id":"216","1":"60","wf_caso_87_id":"60","2":"162","wf_tarea_id":"162","3":null,"core_usuario_id":null,"4":"2015-06-30 17:02:35","fec_asig":"2015-06-30 17:02:35","5":"51","core_usuario_id_resol":"51","6":"2015-06-30 17:02:38","fec_resol":"2015-06-30 17:02:38","7":"162","wf_tarea_id_sig":"162","8":null,"usr_asig":null,"9":"Ruano Marcela: ciudadano","usr_resol":"Ruano Marcela: ciudadano"} {"0":"217","id":"217","1":"60","wf_caso_87_id":"60","2":"163","wf_tarea_id":"163","3":"51","core_usuario_id":"51","4":"2015-06-30 17:02:38","fec_asig":"2015-06-30 17:02:38","5":null,"core_usuario_id_resol":null,"6":null,"fec_resol":null,"7":"163","wf_tarea_id_sig":"163","8":"Ruano Marcela: ciudadano","usr_asig":"Ruano Marcela: ciudadano","9":null,"usr_resol":null} 2015-06 30 17:08:26 cargar datos del sujeto(,,s,87,60) 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=60 AND s.id =w.core_sujetoverificacion_id inner join plan_municipio m on s.plan_municipio_id=m.id inner join core_sujetocategoria c on s.core_sujetocategoria_id=c.id 2015-06 30 17:08:26 tabla dat adic select tabla from core_sujetoverificaciontipo where id=1 2015-06 30 17:08:26 tabla :persona SELECT * FROM persona where id=101 2015-06 30 17:08:26 Continuar(s,163,280,) EjecutarTarea_163() Concurso musica campesina id_comp1229 51 51 ValidarUsuario(163):1 EjecutarPaso_280: form:29 , caso=60 id_comp 1229 Paso::Guardar(Caso:60) Datos a guardar: Array ( [wf_proceso_id] => 87 [wf_paso_id] => 280 [wf_tarea_id] => 163 [wf_caso_id] => 60 [id] => 1229 [accion] => nextPaso [reg] => s [rta] => n [cod_formulario2] => 29 [id_periodo] => 2015 [obs_ingreso] => [cod_bloque] => 32 [oid] => [oid_maestro] => [432] => 2015-06-30 [433] => 1 [434] => genoy [435] => centro [436] => la playa [439] => Myriam [440] => 1085917448 [441] => Ipiales [442] => 2010-06-24 [443] => Ipiales [444] => casa 2 [445] => 478512 [hdcampo446] => 31 [446] => [{"oid":"","txttit":"las mañanitas","txtritmo":"folclorico","form_master_escribir_xxx":"31"},{"oid":"","txttit":"los cenizales","txtritmo":"folclorico","form_master_escribir_xxx":"31"}] [hdcampo447] => 30 [447] => [{"oid":null,"txtnomi":"Jose Valencia","txtedad":"0","txtdoci":"1258796","form_master_escribir_xxx":"30"}] ) OID: 17 rta: 1 dato:17 tabla:sce.t29 CasoPaso:244 CargarDatos_280(17) se carga 87_163_280_29_32_447Array se carga 87_163_280_29_32_446Array se carga 87_163_280_29_32_445478512 se carga 87_163_280_29_32_444casa 2 se carga 87_163_280_29_32_443Ipiales se carga 87_163_280_29_32_4422010-06-24 se carga 87_163_280_29_32_441Ipiales se carga 87_163_280_29_32_4401085917448 se carga 87_163_280_29_32_439Myriam se carga 87_163_280_29_32_438 se carga 87_163_280_29_32_437 se carga 87_163_280_29_32_436la playa se carga 87_163_280_29_32_435centro se carga 87_163_280_29_32_434genoy se carga 87_163_280_29_32_4331 se carga 87_163_280_29_32_4322015-06-30 SiguientePasoDe280: Funcion para ejecutar el siguiente paso EjecutarPaso_282: ladj:117 , caso=60 id_comp 1229 Mostrar ladj Retorno : Array ( [ret] => inicioComponente_WF_ladj({"tarea_id":163,"paso_id":282,"id":"1229","proceso_id":87,"caso_id":"60","sujeto_id":"101","ladj":117}); [suc] => 1 ) fin 2015-06-30 17:08:27 /******************************************************************************************************/ 2015-06-30 17:09:22TraerCaso(60,87,) CargarCaso :60 2015-06 30 17:09:22 CargarDatos: Caso :60 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":"243","id":"243","1":"277","wf_paso_id":"277","2":"216","wf_caso_87_seguimiento_id":"216","3":"51","core_usuario_id":"51","4":"2015-06-30 17:02:38","fecha_ejec":"2015-06-30 17:02:38","5":"59","dato":"59","6":"sce.t33","tabla":"sce.t33","7":"162","tarea_id":"162","8":"Ruano Marcela: ciudadano","usr_ejec":"Ruano Marcela: ciudadano"} CargarDatos_277(59) se carga 87_162_277_33_34_4511 {"0":"244","id":"244","1":"280","wf_paso_id":"280","2":"217","wf_caso_87_seguimiento_id":"217","3":"51","core_usuario_id":"51","4":"2015-06-30 17:08:27","fecha_ejec":"2015-06-30 17:08:27","5":"17","dato":"17","6":"sce.t29","tabla":"sce.t29","7":"163","tarea_id":"163","8":"Ruano Marcela: ciudadano","usr_ejec":"Ruano Marcela: ciudadano"} CargarDatos_280(17) se carga 87_163_280_29_32_447Array se carga 87_163_280_29_32_446Array se carga 87_163_280_29_32_445478512 se carga 87_163_280_29_32_444casa 2 se carga 87_163_280_29_32_443Ipiales se carga 87_163_280_29_32_4422010-06-24 se carga 87_163_280_29_32_441Ipiales se carga 87_163_280_29_32_4401085917448 se carga 87_163_280_29_32_439Myriam se carga 87_163_280_29_32_438 se carga 87_163_280_29_32_437 se carga 87_163_280_29_32_436la playa se carga 87_163_280_29_32_435centro se carga 87_163_280_29_32_434genoy se carga 87_163_280_29_32_4331 se carga 87_163_280_29_32_4322015-06-30 cargar datos de ejecucion de las tareas (las ultimas si el proceso tiene ciclos) select a.*, u.apellido||' '||u.nombre|| ': '||u.cargo as usr_asig , ur.apellido||' '||ur.nombre|| ': '||ur.cargo as usr_resol from wf_caso_87_seguimiento a inner join ( select max(b0.id) as id,b0.wf_caso_87_id,b0.wf_tarea_id from wf_caso_87_seguimiento b0 where b0.wf_caso_87_id =? group by b0.wf_caso_87_id,b0.wf_tarea_id order by wf_caso_87_id,id ) b using(id) left join usuarios u using(core_usuario_id) left join usuarios ur on ur.core_usuario_id=core_usuario_id_resol {"0":"216","id":"216","1":"60","wf_caso_87_id":"60","2":"162","wf_tarea_id":"162","3":null,"core_usuario_id":null,"4":"2015-06-30 17:02:35","fec_asig":"2015-06-30 17:02:35","5":"51","core_usuario_id_resol":"51","6":"2015-06-30 17:02:38","fec_resol":"2015-06-30 17:02:38","7":"162","wf_tarea_id_sig":"162","8":null,"usr_asig":null,"9":"Ruano Marcela: ciudadano","usr_resol":"Ruano Marcela: ciudadano"} {"0":"217","id":"217","1":"60","wf_caso_87_id":"60","2":"163","wf_tarea_id":"163","3":"51","core_usuario_id":"51","4":"2015-06-30 17:02:38","fec_asig":"2015-06-30 17:02:38","5":null,"core_usuario_id_resol":null,"6":null,"fec_resol":null,"7":"163","wf_tarea_id_sig":"163","8":"Ruano Marcela: ciudadano","usr_asig":"Ruano Marcela: ciudadano","9":null,"usr_resol":null} 2015-06 30 17:09:22 cargar datos del sujeto(,,s,87,60) 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=60 AND s.id =w.core_sujetoverificacion_id inner join plan_municipio m on s.plan_municipio_id=m.id inner join core_sujetocategoria c on s.core_sujetocategoria_id=c.id 2015-06 30 17:09:22 tabla dat adic select tabla from core_sujetoverificaciontipo where id=1 2015-06 30 17:09:22 tabla :persona SELECT * FROM persona where id=101 2015-06 30 17:09:22 Continuar(s,163,282,) EjecutarTarea_163() Concurso musica campesina id_comp1229 51 51 ValidarUsuario(163):1 EjecutarPaso_282: ladj:117 , caso=60 id_comp 1229 Paso::Guardar(Caso:60) rta: 1 dato:6497 tabla:wf_documentoentradaadj_caso CasoPaso:245 CargarDatos_282(6497) SiguientePasoDe282: Funcion para ejecutar el siguiente paso EjecutarPaso_283: corr:102 , caso=60 id_comp 1229 Mostrar corr ob_start(); $ciud = mb_strtoupper( "{ WFSV_2 } { WFSV_3 }",'utf-8'); ?>

Apreciado(a)

El presente mensaje es una notificación para el caso No

inicioComponente_WF_Correo({"id":"1229","caso_id":"60","proceso_id":87,"tit":"Concurso musica campesina","tarea_id":163,"paso_id":283,"desc":"

\nApreciado(a)
\nMARCELA RUANO<\/strong>\n

\n

El presente mensaje es una notificación para el caso No 60<\/strong> <\/p>\nSu solicitud de Inscripci\u00f3n a eventos culturales en el concurso de M\u00fasica campesina se realiz\u00f3 con \u00e9xito y se encuentra en tr\u00e1mite .<\/strong> ","url":"De click aqui para volver a enviar el correo<\/a><\/div>"}); [suc] => 1 ) fin 2015-06-30 17:09:22 /******************************************************************************************************/ 2015-06-30 17:09:29TraerCaso(60,87,) CargarCaso :60 2015-06 30 17:09:29 CargarDatos: Caso :60 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":"243","id":"243","1":"277","wf_paso_id":"277","2":"216","wf_caso_87_seguimiento_id":"216","3":"51","core_usuario_id":"51","4":"2015-06-30 17:02:38","fecha_ejec":"2015-06-30 17:02:38","5":"59","dato":"59","6":"sce.t33","tabla":"sce.t33","7":"162","tarea_id":"162","8":"Ruano Marcela: ciudadano","usr_ejec":"Ruano Marcela: ciudadano"} CargarDatos_277(59) se carga 87_162_277_33_34_4511 {"0":"244","id":"244","1":"280","wf_paso_id":"280","2":"217","wf_caso_87_seguimiento_id":"217","3":"51","core_usuario_id":"51","4":"2015-06-30 17:08:27","fecha_ejec":"2015-06-30 17:08:27","5":"17","dato":"17","6":"sce.t29","tabla":"sce.t29","7":"163","tarea_id":"163","8":"Ruano Marcela: ciudadano","usr_ejec":"Ruano Marcela: ciudadano"} CargarDatos_280(17) se carga 87_163_280_29_32_447Array se carga 87_163_280_29_32_446Array se carga 87_163_280_29_32_445478512 se carga 87_163_280_29_32_444casa 2 se carga 87_163_280_29_32_443Ipiales se carga 87_163_280_29_32_4422010-06-24 se carga 87_163_280_29_32_441Ipiales se carga 87_163_280_29_32_4401085917448 se carga 87_163_280_29_32_439Myriam se carga 87_163_280_29_32_438 se carga 87_163_280_29_32_437 se carga 87_163_280_29_32_436la playa se carga 87_163_280_29_32_435centro se carga 87_163_280_29_32_434genoy se carga 87_163_280_29_32_4331 se carga 87_163_280_29_32_4322015-06-30 {"0":"245","id":"245","1":"282","wf_paso_id":"282","2":"217","wf_caso_87_seguimiento_id":"217","3":"51","core_usuario_id":"51","4":"2015-06-30 17:09:22","fecha_ejec":"2015-06-30 17:09:22","5":"6497","dato":"6497","6":"wf_documentoentradaadj_caso","tabla":"wf_documentoentradaadj_caso","7":"163","tarea_id":"163","8":"Ruano Marcela: ciudadano","usr_ejec":"Ruano Marcela: ciudadano"} CargarDatos_282(6497) 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":"216","id":"216","1":"60","wf_caso_87_id":"60","2":"162","wf_tarea_id":"162","3":null,"core_usuario_id":null,"4":"2015-06-30 17:02:35","fec_asig":"2015-06-30 17:02:35","5":"51","core_usuario_id_resol":"51","6":"2015-06-30 17:02:38","fec_resol":"2015-06-30 17:02:38","7":"162","wf_tarea_id_sig":"162","8":null,"usr_asig":null,"9":"Ruano Marcela: ciudadano","usr_resol":"Ruano Marcela: ciudadano"} {"0":"217","id":"217","1":"60","wf_caso_87_id":"60","2":"163","wf_tarea_id":"163","3":"51","core_usuario_id":"51","4":"2015-06-30 17:02:38","fec_asig":"2015-06-30 17:02:38","5":null,"core_usuario_id_resol":null,"6":null,"fec_resol":null,"7":"163","wf_tarea_id_sig":"163","8":"Ruano Marcela: ciudadano","usr_asig":"Ruano Marcela: ciudadano","9":null,"usr_resol":null} 2015-06 30 17:09:29 cargar datos del sujeto(,,s,87,60) 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=60 AND s.id =w.core_sujetoverificacion_id inner join plan_municipio m on s.plan_municipio_id=m.id inner join core_sujetocategoria c on s.core_sujetocategoria_id=c.id 2015-06 30 17:09:29 tabla dat adic select tabla from core_sujetoverificaciontipo where id=1 2015-06 30 17:09:29 tabla :persona SELECT * FROM persona where id=101 2015-06 30 17:09:29 Continuar(s,163,283,) EjecutarTarea_163() Concurso musica campesina id_comp1229 51 51 ValidarUsuario(163):1 EjecutarPaso_283: corr:102 , caso=60 id_comp 1229 Paso::Guardar(Caso:60) rta: 1 dato: tabla: CasoPaso:246 CargarDatos_283() SiguientePasoDe283: Funcion para ejecutar el siguiente paso Condicion Tarea : true TerminarTarea(163,168) Ultimo seg :217 Ultimo seg :218 EjecutarTarea_168() Verificacion musica campesina id_comp1229 51 ValidarUsuario(168): Retorno : Array ( [htm] => [suc] => 1 [ret] => crearMsg('Usted no puede ejecutar la tarea actual del proceso, Debe esperar a que un usuario con los privilegios adecuados la ejecute.','Información');Ext.getCmp('comp_1229').funcionInicial('n'); ) fin 2015-06-30 17:09:29 /******************************************************************************************************/ 2015-07-01 12:58:02TraerCaso(60,87,) CargarCaso :60 2015-07 01 12:58:02 CargarDatos: Caso :60 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":"243","id":"243","1":"277","wf_paso_id":"277","2":"216","wf_caso_87_seguimiento_id":"216","3":"51","core_usuario_id":"51","4":"2015-06-30 17:02:38","fecha_ejec":"2015-06-30 17:02:38","5":"59","dato":"59","6":"sce.t33","tabla":"sce.t33","7":"162","tarea_id":"162","8":"Ruano Marcela: ciudadano","usr_ejec":"Ruano Marcela: ciudadano"} CargarDatos_277(59) se carga 87_162_277_33_34_4511 {"0":"244","id":"244","1":"280","wf_paso_id":"280","2":"217","wf_caso_87_seguimiento_id":"217","3":"51","core_usuario_id":"51","4":"2015-06-30 17:08:27","fecha_ejec":"2015-06-30 17:08:27","5":"17","dato":"17","6":"sce.t29","tabla":"sce.t29","7":"163","tarea_id":"163","8":"Ruano Marcela: ciudadano","usr_ejec":"Ruano Marcela: ciudadano"} CargarDatos_280(17) se carga 87_163_280_29_32_447Array se carga 87_163_280_29_32_446Array se carga 87_163_280_29_32_445478512 se carga 87_163_280_29_32_444casa 2 se carga 87_163_280_29_32_443Ipiales se carga 87_163_280_29_32_4422010-06-24 se carga 87_163_280_29_32_441Ipiales se carga 87_163_280_29_32_4401085917448 se carga 87_163_280_29_32_439Myriam se carga 87_163_280_29_32_438 se carga 87_163_280_29_32_437 se carga 87_163_280_29_32_436la playa se carga 87_163_280_29_32_435centro se carga 87_163_280_29_32_434genoy se carga 87_163_280_29_32_4331 se carga 87_163_280_29_32_4322015-06-30 {"0":"245","id":"245","1":"282","wf_paso_id":"282","2":"217","wf_caso_87_seguimiento_id":"217","3":"51","core_usuario_id":"51","4":"2015-06-30 17:09:22","fecha_ejec":"2015-06-30 17:09:22","5":"6497","dato":"6497","6":"wf_documentoentradaadj_caso","tabla":"wf_documentoentradaadj_caso","7":"163","tarea_id":"163","8":"Ruano Marcela: ciudadano","usr_ejec":"Ruano Marcela: ciudadano"} CargarDatos_282(6497) {"0":"246","id":"246","1":"283","wf_paso_id":"283","2":"217","wf_caso_87_seguimiento_id":"217","3":"51","core_usuario_id":"51","4":"2015-06-30 17:09:29","fecha_ejec":"2015-06-30 17:09:29","5":null,"dato":null,"6":null,"tabla":null,"7":"163","tarea_id":"163","8":"Ruano Marcela: ciudadano","usr_ejec":"Ruano Marcela: ciudadano"} CargarDatos_283() 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":"216","id":"216","1":"60","wf_caso_87_id":"60","2":"162","wf_tarea_id":"162","3":null,"core_usuario_id":null,"4":"2015-06-30 17:02:35","fec_asig":"2015-06-30 17:02:35","5":"51","core_usuario_id_resol":"51","6":"2015-06-30 17:02:38","fec_resol":"2015-06-30 17:02:38","7":"162","wf_tarea_id_sig":"162","8":null,"usr_asig":null,"9":"Ruano Marcela: ciudadano","usr_resol":"Ruano Marcela: ciudadano"} {"0":"217","id":"217","1":"60","wf_caso_87_id":"60","2":"163","wf_tarea_id":"163","3":"51","core_usuario_id":"51","4":"2015-06-30 17:02:38","fec_asig":"2015-06-30 17:02:38","5":"51","core_usuario_id_resol":"51","6":"2015-06-30 17:09:29","fec_resol":"2015-06-30 17:09:29","7":"163","wf_tarea_id_sig":"163","8":"Ruano Marcela: ciudadano","usr_asig":"Ruano Marcela: ciudadano","9":"Ruano Marcela: ciudadano","usr_resol":"Ruano Marcela: ciudadano"} {"0":"218","id":"218","1":"60","wf_caso_87_id":"60","2":"168","wf_tarea_id":"168","3":null,"core_usuario_id":null,"4":"2015-06-30 17:09:29","fec_asig":"2015-06-30 17:09:29","5":null,"core_usuario_id_resol":null,"6":null,"fec_resol":null,"7":"168","wf_tarea_id_sig":"168","8":null,"usr_asig":null,"9":null,"usr_resol":null} 2015-07 01 12:58:02 cargar datos del sujeto(,,s,87,60) 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=60 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 01 12:58:02 tabla dat adic select tabla from core_sujetoverificaciontipo where id=1 2015-07 01 12:58:02 tabla :persona SELECT * FROM persona where id=101 2015-07 01 12:58:02 Continuar(,168,,s) EjecutarTarea_168() Verificacion musica campesina id_comp1232 59 ValidarUsuario(168):1 EjecutarPaso_287: vadj:117 , caso=60 id_comp 1232 Mostrar vadj Retorno : Array ( [ret] => inicioComponente_WF_vadj({"tarea_id":168,"paso_id":287,"id":"1232","proceso_id":87,"caso_id":"60","sujeto_id":"101","vadj":117}); [suc] => 1 ) fin 2015-07-01 12:58:02 /******************************************************************************************************/ 2015-07-01 12:58:08TraerCaso(60,87,) CargarCaso :60 2015-07 01 12:58:08 CargarDatos: Caso :60 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":"243","id":"243","1":"277","wf_paso_id":"277","2":"216","wf_caso_87_seguimiento_id":"216","3":"51","core_usuario_id":"51","4":"2015-06-30 17:02:38","fecha_ejec":"2015-06-30 17:02:38","5":"59","dato":"59","6":"sce.t33","tabla":"sce.t33","7":"162","tarea_id":"162","8":"Ruano Marcela: ciudadano","usr_ejec":"Ruano Marcela: ciudadano"} CargarDatos_277(59) se carga 87_162_277_33_34_4511 {"0":"244","id":"244","1":"280","wf_paso_id":"280","2":"217","wf_caso_87_seguimiento_id":"217","3":"51","core_usuario_id":"51","4":"2015-06-30 17:08:27","fecha_ejec":"2015-06-30 17:08:27","5":"17","dato":"17","6":"sce.t29","tabla":"sce.t29","7":"163","tarea_id":"163","8":"Ruano Marcela: ciudadano","usr_ejec":"Ruano Marcela: ciudadano"} CargarDatos_280(17) se carga 87_163_280_29_32_447Array se carga 87_163_280_29_32_446Array se carga 87_163_280_29_32_445478512 se carga 87_163_280_29_32_444casa 2 se carga 87_163_280_29_32_443Ipiales se carga 87_163_280_29_32_4422010-06-24 se carga 87_163_280_29_32_441Ipiales se carga 87_163_280_29_32_4401085917448 se carga 87_163_280_29_32_439Myriam se carga 87_163_280_29_32_438 se carga 87_163_280_29_32_437 se carga 87_163_280_29_32_436la playa se carga 87_163_280_29_32_435centro se carga 87_163_280_29_32_434genoy se carga 87_163_280_29_32_4331 se carga 87_163_280_29_32_4322015-06-30 {"0":"245","id":"245","1":"282","wf_paso_id":"282","2":"217","wf_caso_87_seguimiento_id":"217","3":"51","core_usuario_id":"51","4":"2015-06-30 17:09:22","fecha_ejec":"2015-06-30 17:09:22","5":"6497","dato":"6497","6":"wf_documentoentradaadj_caso","tabla":"wf_documentoentradaadj_caso","7":"163","tarea_id":"163","8":"Ruano Marcela: ciudadano","usr_ejec":"Ruano Marcela: ciudadano"} CargarDatos_282(6497) {"0":"246","id":"246","1":"283","wf_paso_id":"283","2":"217","wf_caso_87_seguimiento_id":"217","3":"51","core_usuario_id":"51","4":"2015-06-30 17:09:29","fecha_ejec":"2015-06-30 17:09:29","5":null,"dato":null,"6":null,"tabla":null,"7":"163","tarea_id":"163","8":"Ruano Marcela: ciudadano","usr_ejec":"Ruano Marcela: ciudadano"} CargarDatos_283() 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":"216","id":"216","1":"60","wf_caso_87_id":"60","2":"162","wf_tarea_id":"162","3":null,"core_usuario_id":null,"4":"2015-06-30 17:02:35","fec_asig":"2015-06-30 17:02:35","5":"51","core_usuario_id_resol":"51","6":"2015-06-30 17:02:38","fec_resol":"2015-06-30 17:02:38","7":"162","wf_tarea_id_sig":"162","8":null,"usr_asig":null,"9":"Ruano Marcela: ciudadano","usr_resol":"Ruano Marcela: ciudadano"} {"0":"217","id":"217","1":"60","wf_caso_87_id":"60","2":"163","wf_tarea_id":"163","3":"51","core_usuario_id":"51","4":"2015-06-30 17:02:38","fec_asig":"2015-06-30 17:02:38","5":"51","core_usuario_id_resol":"51","6":"2015-06-30 17:09:29","fec_resol":"2015-06-30 17:09:29","7":"163","wf_tarea_id_sig":"163","8":"Ruano Marcela: ciudadano","usr_asig":"Ruano Marcela: ciudadano","9":"Ruano Marcela: ciudadano","usr_resol":"Ruano Marcela: ciudadano"} {"0":"218","id":"218","1":"60","wf_caso_87_id":"60","2":"168","wf_tarea_id":"168","3":null,"core_usuario_id":null,"4":"2015-06-30 17:09:29","fec_asig":"2015-06-30 17:09:29","5":null,"core_usuario_id_resol":null,"6":null,"fec_resol":null,"7":"168","wf_tarea_id_sig":"168","8":null,"usr_asig":null,"9":null,"usr_resol":null} 2015-07 01 12:58:08 cargar datos del sujeto(,,s,87,60) 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=60 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 01 12:58:08 tabla dat adic select tabla from core_sujetoverificaciontipo where id=1 2015-07 01 12:58:08 tabla :persona SELECT * FROM persona where id=101 2015-07 01 12:58:08 Continuar(,168,,s) EjecutarTarea_168() Verificacion musica campesina id_comp1232 38 ValidarUsuario(168):1 EjecutarPaso_287: vadj:117 , caso=60 id_comp 1232 Mostrar vadj Retorno : Array ( [ret] => inicioComponente_WF_vadj({"tarea_id":168,"paso_id":287,"id":"1232","proceso_id":87,"caso_id":"60","sujeto_id":"101","vadj":117}); [suc] => 1 ) fin 2015-07-01 12:58:08 /******************************************************************************************************/ 2015-07-01 12:58:34TraerCaso(60,87,) CargarCaso :60 2015-07 01 12:58:34 CargarDatos: Caso :60 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":"243","id":"243","1":"277","wf_paso_id":"277","2":"216","wf_caso_87_seguimiento_id":"216","3":"51","core_usuario_id":"51","4":"2015-06-30 17:02:38","fecha_ejec":"2015-06-30 17:02:38","5":"59","dato":"59","6":"sce.t33","tabla":"sce.t33","7":"162","tarea_id":"162","8":"Ruano Marcela: ciudadano","usr_ejec":"Ruano Marcela: ciudadano"} CargarDatos_277(59) se carga 87_162_277_33_34_4511 {"0":"244","id":"244","1":"280","wf_paso_id":"280","2":"217","wf_caso_87_seguimiento_id":"217","3":"51","core_usuario_id":"51","4":"2015-06-30 17:08:27","fecha_ejec":"2015-06-30 17:08:27","5":"17","dato":"17","6":"sce.t29","tabla":"sce.t29","7":"163","tarea_id":"163","8":"Ruano Marcela: ciudadano","usr_ejec":"Ruano Marcela: ciudadano"} CargarDatos_280(17) se carga 87_163_280_29_32_447Array se carga 87_163_280_29_32_446Array se carga 87_163_280_29_32_445478512 se carga 87_163_280_29_32_444casa 2 se carga 87_163_280_29_32_443Ipiales se carga 87_163_280_29_32_4422010-06-24 se carga 87_163_280_29_32_441Ipiales se carga 87_163_280_29_32_4401085917448 se carga 87_163_280_29_32_439Myriam se carga 87_163_280_29_32_438 se carga 87_163_280_29_32_437 se carga 87_163_280_29_32_436la playa se carga 87_163_280_29_32_435centro se carga 87_163_280_29_32_434genoy se carga 87_163_280_29_32_4331 se carga 87_163_280_29_32_4322015-06-30 {"0":"245","id":"245","1":"282","wf_paso_id":"282","2":"217","wf_caso_87_seguimiento_id":"217","3":"51","core_usuario_id":"51","4":"2015-06-30 17:09:22","fecha_ejec":"2015-06-30 17:09:22","5":"6497","dato":"6497","6":"wf_documentoentradaadj_caso","tabla":"wf_documentoentradaadj_caso","7":"163","tarea_id":"163","8":"Ruano Marcela: ciudadano","usr_ejec":"Ruano Marcela: ciudadano"} CargarDatos_282(6497) {"0":"246","id":"246","1":"283","wf_paso_id":"283","2":"217","wf_caso_87_seguimiento_id":"217","3":"51","core_usuario_id":"51","4":"2015-06-30 17:09:29","fecha_ejec":"2015-06-30 17:09:29","5":null,"dato":null,"6":null,"tabla":null,"7":"163","tarea_id":"163","8":"Ruano Marcela: ciudadano","usr_ejec":"Ruano Marcela: ciudadano"} CargarDatos_283() 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":"216","id":"216","1":"60","wf_caso_87_id":"60","2":"162","wf_tarea_id":"162","3":null,"core_usuario_id":null,"4":"2015-06-30 17:02:35","fec_asig":"2015-06-30 17:02:35","5":"51","core_usuario_id_resol":"51","6":"2015-06-30 17:02:38","fec_resol":"2015-06-30 17:02:38","7":"162","wf_tarea_id_sig":"162","8":null,"usr_asig":null,"9":"Ruano Marcela: ciudadano","usr_resol":"Ruano Marcela: ciudadano"} {"0":"217","id":"217","1":"60","wf_caso_87_id":"60","2":"163","wf_tarea_id":"163","3":"51","core_usuario_id":"51","4":"2015-06-30 17:02:38","fec_asig":"2015-06-30 17:02:38","5":"51","core_usuario_id_resol":"51","6":"2015-06-30 17:09:29","fec_resol":"2015-06-30 17:09:29","7":"163","wf_tarea_id_sig":"163","8":"Ruano Marcela: ciudadano","usr_asig":"Ruano Marcela: ciudadano","9":"Ruano Marcela: ciudadano","usr_resol":"Ruano Marcela: ciudadano"} {"0":"218","id":"218","1":"60","wf_caso_87_id":"60","2":"168","wf_tarea_id":"168","3":null,"core_usuario_id":null,"4":"2015-06-30 17:09:29","fec_asig":"2015-06-30 17:09:29","5":null,"core_usuario_id_resol":null,"6":null,"fec_resol":null,"7":"168","wf_tarea_id_sig":"168","8":null,"usr_asig":null,"9":null,"usr_resol":null} 2015-07 01 12:58:34 cargar datos del sujeto(,,s,87,60) 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=60 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 01 12:58:34 tabla dat adic select tabla from core_sujetoverificaciontipo where id=1 2015-07 01 12:58:34 tabla :persona SELECT * FROM persona where id=101 2015-07 01 12:58:34 Continuar(,168,,s) EjecutarTarea_168() Verificacion musica campesina id_comp1232 38 ValidarUsuario(168):1 EjecutarPaso_287: vadj:117 , caso=60 id_comp 1232 Mostrar vadj Retorno : Array ( [ret] => inicioComponente_WF_vadj({"tarea_id":168,"paso_id":287,"id":"1232","proceso_id":87,"caso_id":"60","sujeto_id":"101","vadj":117}); [suc] => 1 ) fin 2015-07-01 12:58:34 /******************************************************************************************************/ 2015-07-01 12:58:35TraerCaso(60,87,) CargarCaso :60 2015-07 01 12:58:35 CargarDatos: Caso :60 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":"243","id":"243","1":"277","wf_paso_id":"277","2":"216","wf_caso_87_seguimiento_id":"216","3":"51","core_usuario_id":"51","4":"2015-06-30 17:02:38","fecha_ejec":"2015-06-30 17:02:38","5":"59","dato":"59","6":"sce.t33","tabla":"sce.t33","7":"162","tarea_id":"162","8":"Ruano Marcela: ciudadano","usr_ejec":"Ruano Marcela: ciudadano"} CargarDatos_277(59) se carga 87_162_277_33_34_4511 {"0":"244","id":"244","1":"280","wf_paso_id":"280","2":"217","wf_caso_87_seguimiento_id":"217","3":"51","core_usuario_id":"51","4":"2015-06-30 17:08:27","fecha_ejec":"2015-06-30 17:08:27","5":"17","dato":"17","6":"sce.t29","tabla":"sce.t29","7":"163","tarea_id":"163","8":"Ruano Marcela: ciudadano","usr_ejec":"Ruano Marcela: ciudadano"} CargarDatos_280(17) se carga 87_163_280_29_32_447Array se carga 87_163_280_29_32_446Array se carga 87_163_280_29_32_445478512 se carga 87_163_280_29_32_444casa 2 se carga 87_163_280_29_32_443Ipiales se carga 87_163_280_29_32_4422010-06-24 se carga 87_163_280_29_32_441Ipiales se carga 87_163_280_29_32_4401085917448 se carga 87_163_280_29_32_439Myriam se carga 87_163_280_29_32_438 se carga 87_163_280_29_32_437 se carga 87_163_280_29_32_436la playa se carga 87_163_280_29_32_435centro se carga 87_163_280_29_32_434genoy se carga 87_163_280_29_32_4331 se carga 87_163_280_29_32_4322015-06-30 {"0":"245","id":"245","1":"282","wf_paso_id":"282","2":"217","wf_caso_87_seguimiento_id":"217","3":"51","core_usuario_id":"51","4":"2015-06-30 17:09:22","fecha_ejec":"2015-06-30 17:09:22","5":"6497","dato":"6497","6":"wf_documentoentradaadj_caso","tabla":"wf_documentoentradaadj_caso","7":"163","tarea_id":"163","8":"Ruano Marcela: ciudadano","usr_ejec":"Ruano Marcela: ciudadano"} CargarDatos_282(6497) {"0":"246","id":"246","1":"283","wf_paso_id":"283","2":"217","wf_caso_87_seguimiento_id":"217","3":"51","core_usuario_id":"51","4":"2015-06-30 17:09:29","fecha_ejec":"2015-06-30 17:09:29","5":null,"dato":null,"6":null,"tabla":null,"7":"163","tarea_id":"163","8":"Ruano Marcela: ciudadano","usr_ejec":"Ruano Marcela: ciudadano"} CargarDatos_283() 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":"216","id":"216","1":"60","wf_caso_87_id":"60","2":"162","wf_tarea_id":"162","3":null,"core_usuario_id":null,"4":"2015-06-30 17:02:35","fec_asig":"2015-06-30 17:02:35","5":"51","core_usuario_id_resol":"51","6":"2015-06-30 17:02:38","fec_resol":"2015-06-30 17:02:38","7":"162","wf_tarea_id_sig":"162","8":null,"usr_asig":null,"9":"Ruano Marcela: ciudadano","usr_resol":"Ruano Marcela: ciudadano"} {"0":"217","id":"217","1":"60","wf_caso_87_id":"60","2":"163","wf_tarea_id":"163","3":"51","core_usuario_id":"51","4":"2015-06-30 17:02:38","fec_asig":"2015-06-30 17:02:38","5":"51","core_usuario_id_resol":"51","6":"2015-06-30 17:09:29","fec_resol":"2015-06-30 17:09:29","7":"163","wf_tarea_id_sig":"163","8":"Ruano Marcela: ciudadano","usr_asig":"Ruano Marcela: ciudadano","9":"Ruano Marcela: ciudadano","usr_resol":"Ruano Marcela: ciudadano"} {"0":"218","id":"218","1":"60","wf_caso_87_id":"60","2":"168","wf_tarea_id":"168","3":null,"core_usuario_id":null,"4":"2015-06-30 17:09:29","fec_asig":"2015-06-30 17:09:29","5":null,"core_usuario_id_resol":null,"6":null,"fec_resol":null,"7":"168","wf_tarea_id_sig":"168","8":null,"usr_asig":null,"9":null,"usr_resol":null} 2015-07 01 12:58:35 cargar datos del sujeto(,,s,87,60) 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=60 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 01 12:58:35 tabla dat adic select tabla from core_sujetoverificaciontipo where id=1 2015-07 01 12:58:35 tabla :persona SELECT * FROM persona where id=101 2015-07 01 12:58:35 Continuar(,168,,s) EjecutarTarea_168() Verificacion musica campesina id_comp1232 59 ValidarUsuario(168):1 EjecutarPaso_287: vadj:117 , caso=60 id_comp 1232 Mostrar vadj Retorno : Array ( [ret] => inicioComponente_WF_vadj({"tarea_id":168,"paso_id":287,"id":"1232","proceso_id":87,"caso_id":"60","sujeto_id":"101","vadj":117}); [suc] => 1 ) fin 2015-07-01 12:58:35 /******************************************************************************************************/ 2015-07-01 12:58:48TraerCaso(60,87,) CargarCaso :60 2015-07 01 12:58:48 CargarDatos: Caso :60 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":"243","id":"243","1":"277","wf_paso_id":"277","2":"216","wf_caso_87_seguimiento_id":"216","3":"51","core_usuario_id":"51","4":"2015-06-30 17:02:38","fecha_ejec":"2015-06-30 17:02:38","5":"59","dato":"59","6":"sce.t33","tabla":"sce.t33","7":"162","tarea_id":"162","8":"Ruano Marcela: ciudadano","usr_ejec":"Ruano Marcela: ciudadano"} CargarDatos_277(59) se carga 87_162_277_33_34_4511 {"0":"244","id":"244","1":"280","wf_paso_id":"280","2":"217","wf_caso_87_seguimiento_id":"217","3":"51","core_usuario_id":"51","4":"2015-06-30 17:08:27","fecha_ejec":"2015-06-30 17:08:27","5":"17","dato":"17","6":"sce.t29","tabla":"sce.t29","7":"163","tarea_id":"163","8":"Ruano Marcela: ciudadano","usr_ejec":"Ruano Marcela: ciudadano"} CargarDatos_280(17) se carga 87_163_280_29_32_447Array se carga 87_163_280_29_32_446Array se carga 87_163_280_29_32_445478512 se carga 87_163_280_29_32_444casa 2 se carga 87_163_280_29_32_443Ipiales se carga 87_163_280_29_32_4422010-06-24 se carga 87_163_280_29_32_441Ipiales se carga 87_163_280_29_32_4401085917448 se carga 87_163_280_29_32_439Myriam se carga 87_163_280_29_32_438 se carga 87_163_280_29_32_437 se carga 87_163_280_29_32_436la playa se carga 87_163_280_29_32_435centro se carga 87_163_280_29_32_434genoy se carga 87_163_280_29_32_4331 se carga 87_163_280_29_32_4322015-06-30 {"0":"245","id":"245","1":"282","wf_paso_id":"282","2":"217","wf_caso_87_seguimiento_id":"217","3":"51","core_usuario_id":"51","4":"2015-06-30 17:09:22","fecha_ejec":"2015-06-30 17:09:22","5":"6497","dato":"6497","6":"wf_documentoentradaadj_caso","tabla":"wf_documentoentradaadj_caso","7":"163","tarea_id":"163","8":"Ruano Marcela: ciudadano","usr_ejec":"Ruano Marcela: ciudadano"} CargarDatos_282(6497) {"0":"246","id":"246","1":"283","wf_paso_id":"283","2":"217","wf_caso_87_seguimiento_id":"217","3":"51","core_usuario_id":"51","4":"2015-06-30 17:09:29","fecha_ejec":"2015-06-30 17:09:29","5":null,"dato":null,"6":null,"tabla":null,"7":"163","tarea_id":"163","8":"Ruano Marcela: ciudadano","usr_ejec":"Ruano Marcela: ciudadano"} CargarDatos_283() 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":"216","id":"216","1":"60","wf_caso_87_id":"60","2":"162","wf_tarea_id":"162","3":null,"core_usuario_id":null,"4":"2015-06-30 17:02:35","fec_asig":"2015-06-30 17:02:35","5":"51","core_usuario_id_resol":"51","6":"2015-06-30 17:02:38","fec_resol":"2015-06-30 17:02:38","7":"162","wf_tarea_id_sig":"162","8":null,"usr_asig":null,"9":"Ruano Marcela: ciudadano","usr_resol":"Ruano Marcela: ciudadano"} {"0":"217","id":"217","1":"60","wf_caso_87_id":"60","2":"163","wf_tarea_id":"163","3":"51","core_usuario_id":"51","4":"2015-06-30 17:02:38","fec_asig":"2015-06-30 17:02:38","5":"51","core_usuario_id_resol":"51","6":"2015-06-30 17:09:29","fec_resol":"2015-06-30 17:09:29","7":"163","wf_tarea_id_sig":"163","8":"Ruano Marcela: ciudadano","usr_asig":"Ruano Marcela: ciudadano","9":"Ruano Marcela: ciudadano","usr_resol":"Ruano Marcela: ciudadano"} {"0":"218","id":"218","1":"60","wf_caso_87_id":"60","2":"168","wf_tarea_id":"168","3":null,"core_usuario_id":null,"4":"2015-06-30 17:09:29","fec_asig":"2015-06-30 17:09:29","5":null,"core_usuario_id_resol":null,"6":null,"fec_resol":null,"7":"168","wf_tarea_id_sig":"168","8":null,"usr_asig":null,"9":null,"usr_resol":null} 2015-07 01 12:58:48 cargar datos del sujeto(,,s,87,60) 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=60 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 01 12:58:48 tabla dat adic select tabla from core_sujetoverificaciontipo where id=1 2015-07 01 12:58:48 tabla :persona SELECT * FROM persona where id=101 2015-07 01 12:58:48 Continuar(s,168,287,) EjecutarTarea_168() Verificacion musica campesina id_comp1232 38 ValidarUsuario(168):1 EjecutarPaso_287: vadj:117 , caso=60 id_comp 1232 Paso::Guardar(Caso:60) rta: 1 dato:2556 tabla:wf_documentoentradaadj_caso CasoPaso:285 CargarDatos_287(2556) SiguientePasoDe287: Funcion para ejecutar el siguiente paso Condicion Tarea : Si =="Si" TerminarTarea(168,169) Ultimo seg :218 Ultimo seg :260 EjecutarTarea_169() Inscripcion exitosa musica campesina id_comp1232 38 38 ValidarUsuario(169):1 EjecutarPaso_291: corr:107 , caso=60 id_comp 1232 Mostrar corr ob_start(); $ciud = mb_strtoupper( "{ WFSV_2 } { WFSV_3 }",'utf-8'); ?>

Apreciado(a)

El presente mensaje es una notificación para el caso No

Su inscripción a eventos culturales en música campesina se realizó con éxito. { WFSV_1 } TWFSV_1:myriabe123@gmail.com Inscripción exitosa en la categoría música campesina Retorno : Array ( [ret] => inicioComponente_WF_Correo({"id":"1232","caso_id":"60","proceso_id":87,"tit":"Inscripcion exitosa musica campesina","tarea_id":169,"paso_id":291,"desc":"

\nApreciado(a)
\nMARCELA RUANO<\/strong>\n

\n

El presente mensaje es una notificación para el caso No 60<\/strong> <\/p>\n
Su inscripci\u00f3n a eventos culturales en m\u00fasica campesina se realiz\u00f3 con \u00e9xito.<\/strong> ","url":"
De click aqui para volver a enviar el correo<\/a><\/div>"}); [suc] => 1 ) fin 2015-07-01 12:58:48 /******************************************************************************************************/ 2015-07-01 12:59:42TraerCaso(60,87,) CargarCaso :60 2015-07 01 12:59:42 CargarDatos: Caso :60 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":"243","id":"243","1":"277","wf_paso_id":"277","2":"216","wf_caso_87_seguimiento_id":"216","3":"51","core_usuario_id":"51","4":"2015-06-30 17:02:38","fecha_ejec":"2015-06-30 17:02:38","5":"59","dato":"59","6":"sce.t33","tabla":"sce.t33","7":"162","tarea_id":"162","8":"Ruano Marcela: ciudadano","usr_ejec":"Ruano Marcela: ciudadano"} CargarDatos_277(59) se carga 87_162_277_33_34_4511 {"0":"244","id":"244","1":"280","wf_paso_id":"280","2":"217","wf_caso_87_seguimiento_id":"217","3":"51","core_usuario_id":"51","4":"2015-06-30 17:08:27","fecha_ejec":"2015-06-30 17:08:27","5":"17","dato":"17","6":"sce.t29","tabla":"sce.t29","7":"163","tarea_id":"163","8":"Ruano Marcela: ciudadano","usr_ejec":"Ruano Marcela: ciudadano"} CargarDatos_280(17) se carga 87_163_280_29_32_447Array se carga 87_163_280_29_32_446Array se carga 87_163_280_29_32_445478512 se carga 87_163_280_29_32_444casa 2 se carga 87_163_280_29_32_443Ipiales se carga 87_163_280_29_32_4422010-06-24 se carga 87_163_280_29_32_441Ipiales se carga 87_163_280_29_32_4401085917448 se carga 87_163_280_29_32_439Myriam se carga 87_163_280_29_32_438 se carga 87_163_280_29_32_437 se carga 87_163_280_29_32_436la playa se carga 87_163_280_29_32_435centro se carga 87_163_280_29_32_434genoy se carga 87_163_280_29_32_4331 se carga 87_163_280_29_32_4322015-06-30 {"0":"245","id":"245","1":"282","wf_paso_id":"282","2":"217","wf_caso_87_seguimiento_id":"217","3":"51","core_usuario_id":"51","4":"2015-06-30 17:09:22","fecha_ejec":"2015-06-30 17:09:22","5":"6497","dato":"6497","6":"wf_documentoentradaadj_caso","tabla":"wf_documentoentradaadj_caso","7":"163","tarea_id":"163","8":"Ruano Marcela: ciudadano","usr_ejec":"Ruano Marcela: ciudadano"} CargarDatos_282(6497) {"0":"246","id":"246","1":"283","wf_paso_id":"283","2":"217","wf_caso_87_seguimiento_id":"217","3":"51","core_usuario_id":"51","4":"2015-06-30 17:09:29","fecha_ejec":"2015-06-30 17:09:29","5":null,"dato":null,"6":null,"tabla":null,"7":"163","tarea_id":"163","8":"Ruano Marcela: ciudadano","usr_ejec":"Ruano Marcela: ciudadano"} CargarDatos_283() {"0":"285","id":"285","1":"287","wf_paso_id":"287","2":"218","wf_caso_87_seguimiento_id":"218","3":"38","core_usuario_id":"38","4":"2015-07-01 12:58:48","fecha_ejec":"2015-07-01 12:58:48","5":"2556","dato":"2556","6":"wf_documentoentradaadj_caso","tabla":"wf_documentoentradaadj_caso","7":"168","tarea_id":"168","8":"secretaria operador : gerente","usr_ejec":"secretaria operador : gerente"} CargarDatos_287(2556) 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":"216","id":"216","1":"60","wf_caso_87_id":"60","2":"162","wf_tarea_id":"162","3":null,"core_usuario_id":null,"4":"2015-06-30 17:02:35","fec_asig":"2015-06-30 17:02:35","5":"51","core_usuario_id_resol":"51","6":"2015-06-30 17:02:38","fec_resol":"2015-06-30 17:02:38","7":"162","wf_tarea_id_sig":"162","8":null,"usr_asig":null,"9":"Ruano Marcela: ciudadano","usr_resol":"Ruano Marcela: ciudadano"} {"0":"217","id":"217","1":"60","wf_caso_87_id":"60","2":"163","wf_tarea_id":"163","3":"51","core_usuario_id":"51","4":"2015-06-30 17:02:38","fec_asig":"2015-06-30 17:02:38","5":"51","core_usuario_id_resol":"51","6":"2015-06-30 17:09:29","fec_resol":"2015-06-30 17:09:29","7":"163","wf_tarea_id_sig":"163","8":"Ruano Marcela: ciudadano","usr_asig":"Ruano Marcela: ciudadano","9":"Ruano Marcela: ciudadano","usr_resol":"Ruano Marcela: ciudadano"} {"0":"218","id":"218","1":"60","wf_caso_87_id":"60","2":"168","wf_tarea_id":"168","3":null,"core_usuario_id":null,"4":"2015-06-30 17:09:29","fec_asig":"2015-06-30 17:09:29","5":"38","core_usuario_id_resol":"38","6":"2015-07-01 12:58:48","fec_resol":"2015-07-01 12:58:48","7":"168","wf_tarea_id_sig":"168","8":null,"usr_asig":null,"9":"secretaria operador : gerente","usr_resol":"secretaria operador : gerente"} {"0":"260","id":"260","1":"60","wf_caso_87_id":"60","2":"169","wf_tarea_id":"169","3":"38","core_usuario_id":"38","4":"2015-07-01 12:58:48","fec_asig":"2015-07-01 12:58:48","5":null,"core_usuario_id_resol":null,"6":null,"fec_resol":null,"7":"169","wf_tarea_id_sig":"169","8":"secretaria operador : gerente","usr_asig":"secretaria operador : gerente","9":null,"usr_resol":null} 2015-07 01 12:59:42 cargar datos del sujeto(,,s,87,60) 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=60 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 01 12:59:42 tabla dat adic select tabla from core_sujetoverificaciontipo where id=1 2015-07 01 12:59:42 tabla :persona SELECT * FROM persona where id=101 2015-07 01 12:59:42 Continuar(s,168,287,) EjecutarTarea_168() Verificacion musica campesina id_comp1232 38 59 ValidarUsuario(168): Retorno : Array ( [htm] => [suc] => 1 [ret] => crearMsg('Usted no puede ejecutar la tarea actual del proceso, Debe esperar a que un usuario con los privilegios adecuados la ejecute.','Información');Ext.getCmp('comp_1232').funcionInicial('n'); ) fin 2015-07-01 12:59:42 /******************************************************************************************************/ 2015-07-01 13:11:00TraerCaso(60,87,) CargarCaso :60 2015-07 01 13:11:00 CargarDatos: Caso :60 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":"243","id":"243","1":"277","wf_paso_id":"277","2":"216","wf_caso_87_seguimiento_id":"216","3":"51","core_usuario_id":"51","4":"2015-06-30 17:02:38","fecha_ejec":"2015-06-30 17:02:38","5":"59","dato":"59","6":"sce.t33","tabla":"sce.t33","7":"162","tarea_id":"162","8":"Ruano Marcela: ciudadano","usr_ejec":"Ruano Marcela: ciudadano"} CargarDatos_277(59) se carga 87_162_277_33_34_4511 {"0":"244","id":"244","1":"280","wf_paso_id":"280","2":"217","wf_caso_87_seguimiento_id":"217","3":"51","core_usuario_id":"51","4":"2015-06-30 17:08:27","fecha_ejec":"2015-06-30 17:08:27","5":"17","dato":"17","6":"sce.t29","tabla":"sce.t29","7":"163","tarea_id":"163","8":"Ruano Marcela: ciudadano","usr_ejec":"Ruano Marcela: ciudadano"} CargarDatos_280(17) se carga 87_163_280_29_32_447Array se carga 87_163_280_29_32_446Array se carga 87_163_280_29_32_445478512 se carga 87_163_280_29_32_444casa 2 se carga 87_163_280_29_32_443Ipiales se carga 87_163_280_29_32_4422010-06-24 se carga 87_163_280_29_32_441Ipiales se carga 87_163_280_29_32_4401085917448 se carga 87_163_280_29_32_439Myriam se carga 87_163_280_29_32_438 se carga 87_163_280_29_32_437 se carga 87_163_280_29_32_436la playa se carga 87_163_280_29_32_435centro se carga 87_163_280_29_32_434genoy se carga 87_163_280_29_32_4331 se carga 87_163_280_29_32_4322015-06-30 {"0":"245","id":"245","1":"282","wf_paso_id":"282","2":"217","wf_caso_87_seguimiento_id":"217","3":"51","core_usuario_id":"51","4":"2015-06-30 17:09:22","fecha_ejec":"2015-06-30 17:09:22","5":"6497","dato":"6497","6":"wf_documentoentradaadj_caso","tabla":"wf_documentoentradaadj_caso","7":"163","tarea_id":"163","8":"Ruano Marcela: ciudadano","usr_ejec":"Ruano Marcela: ciudadano"} CargarDatos_282(6497) {"0":"246","id":"246","1":"283","wf_paso_id":"283","2":"217","wf_caso_87_seguimiento_id":"217","3":"51","core_usuario_id":"51","4":"2015-06-30 17:09:29","fecha_ejec":"2015-06-30 17:09:29","5":null,"dato":null,"6":null,"tabla":null,"7":"163","tarea_id":"163","8":"Ruano Marcela: ciudadano","usr_ejec":"Ruano Marcela: ciudadano"} CargarDatos_283() {"0":"285","id":"285","1":"287","wf_paso_id":"287","2":"218","wf_caso_87_seguimiento_id":"218","3":"38","core_usuario_id":"38","4":"2015-07-01 12:58:48","fecha_ejec":"2015-07-01 12:58:48","5":"2556","dato":"2556","6":"wf_documentoentradaadj_caso","tabla":"wf_documentoentradaadj_caso","7":"168","tarea_id":"168","8":"secretaria operador : gerente","usr_ejec":"secretaria operador : gerente"} CargarDatos_287(2556) 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":"216","id":"216","1":"60","wf_caso_87_id":"60","2":"162","wf_tarea_id":"162","3":null,"core_usuario_id":null,"4":"2015-06-30 17:02:35","fec_asig":"2015-06-30 17:02:35","5":"51","core_usuario_id_resol":"51","6":"2015-06-30 17:02:38","fec_resol":"2015-06-30 17:02:38","7":"162","wf_tarea_id_sig":"162","8":null,"usr_asig":null,"9":"Ruano Marcela: ciudadano","usr_resol":"Ruano Marcela: ciudadano"} {"0":"217","id":"217","1":"60","wf_caso_87_id":"60","2":"163","wf_tarea_id":"163","3":"51","core_usuario_id":"51","4":"2015-06-30 17:02:38","fec_asig":"2015-06-30 17:02:38","5":"51","core_usuario_id_resol":"51","6":"2015-06-30 17:09:29","fec_resol":"2015-06-30 17:09:29","7":"163","wf_tarea_id_sig":"163","8":"Ruano Marcela: ciudadano","usr_asig":"Ruano Marcela: ciudadano","9":"Ruano Marcela: ciudadano","usr_resol":"Ruano Marcela: ciudadano"} {"0":"218","id":"218","1":"60","wf_caso_87_id":"60","2":"168","wf_tarea_id":"168","3":null,"core_usuario_id":null,"4":"2015-06-30 17:09:29","fec_asig":"2015-06-30 17:09:29","5":"38","core_usuario_id_resol":"38","6":"2015-07-01 12:58:48","fec_resol":"2015-07-01 12:58:48","7":"168","wf_tarea_id_sig":"168","8":null,"usr_asig":null,"9":"secretaria operador : gerente","usr_resol":"secretaria operador : gerente"} {"0":"260","id":"260","1":"60","wf_caso_87_id":"60","2":"169","wf_tarea_id":"169","3":"38","core_usuario_id":"38","4":"2015-07-01 12:58:48","fec_asig":"2015-07-01 12:58:48","5":null,"core_usuario_id_resol":null,"6":null,"fec_resol":null,"7":"169","wf_tarea_id_sig":"169","8":"secretaria operador : gerente","usr_asig":"secretaria operador : gerente","9":null,"usr_resol":null} 2015-07 01 13:11:00 cargar datos del sujeto(,,s,87,60) 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=60 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 01 13:11:00 tabla dat adic select tabla from core_sujetoverificaciontipo where id=1 2015-07 01 13:11:00 tabla :persona SELECT * FROM persona where id=101 2015-07 01 13:11:00 Continuar(s,168,287,) EjecutarTarea_168() Verificacion musica campesina id_comp1232 38 59 ValidarUsuario(168): Retorno : Array ( [htm] => [suc] => 1 [ret] => crearMsg('Usted no puede ejecutar la tarea actual del proceso, Debe esperar a que un usuario con los privilegios adecuados la ejecute.','Información');Ext.getCmp('comp_1232').funcionInicial('n'); ) fin 2015-07-01 13:11:00 /******************************************************************************************************/