2015-06 16 11:39:00 Nuevo(101,1) Caso :55 2015-06 16 11:39:00 cargar datos del sujeto(,,s,87,55) 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=55 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 16 11:39:00 tabla dat adic select tabla from core_sujetoverificaciontipo where id=1 2015-06 16 11:39:00 tabla :persona SELECT * FROM persona where id=101 CasoSeguimiento :199 EjecutarTarea_162() Tipo fromulario id_comp1229 51 ValidarUsuario(162):1 EjecutarPaso_277: form:33 , caso=55 id_comp 1229 Mostrar form fin 2015-06-16 11:39:00 /******************************************************************************************************/ 2015-06-16 11:39:01TraerCaso(55,87,) CargarCaso :55 2015-06 16 11:39:01 CargarDatos: Caso :55 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":"199","id":"199","1":"55","wf_caso_87_id":"55","2":"162","wf_tarea_id":"162","3":null,"core_usuario_id":null,"4":"2015-06-16 11:39:00","fec_asig":"2015-06-16 11:39:00","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 16 11:39:01 cargar datos del sujeto(,,s,87,55) 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=55 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 16 11:39:01 tabla dat adic select tabla from core_sujetoverificaciontipo where id=1 2015-06 16 11:39:01 tabla :persona SELECT * FROM persona where id=101 fin 2015-06-16 11:39:01 /******************************************************************************************************/ 2015-06-16 11:39:03TraerCaso(55,87,) CargarCaso :55 2015-06 16 11:39:03 CargarDatos: Caso :55 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":"199","id":"199","1":"55","wf_caso_87_id":"55","2":"162","wf_tarea_id":"162","3":null,"core_usuario_id":null,"4":"2015-06-16 11:39:00","fec_asig":"2015-06-16 11:39:00","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 16 11:39:03 cargar datos del sujeto(,,s,87,55) 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=55 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 16 11:39:03 tabla dat adic select tabla from core_sujetoverificaciontipo where id=1 2015-06 16 11:39:03 tabla :persona SELECT * FROM persona where id=101 2015-06 16 11:39:03 Continuar(s,162,277,) EjecutarTarea_162() Tipo fromulario id_comp1229 51 ValidarUsuario(162):1 EjecutarPaso_277: form:33 , caso=55 id_comp 1229 Paso::Guardar(Caso:55) Datos a guardar: Array ( [wf_proceso_id] => 87 [wf_paso_id] => 277 [wf_tarea_id] => 162 [wf_caso_id] => 55 [id] => 1229 [accion] => nextPaso [reg] => s [rta] => n [cod_formulario2] => 33 [id_periodo] => 2015 [obs_ingreso] => [cod_bloque] => 34 [oid] => [oid_maestro] => [451] => 3 ) OID: 55 rta: 1 dato:55 tabla:sce.t33 CasoPaso:225 CargarDatos_277(55) se carga 87_162_277_33_34_4513 SiguientePasoDe277: Funcion para ejecutar el siguiente paso Condicion Tarea : 3 ==1 Condicion Tarea : 3 ==2 Condicion Tarea : 3 ==3 TerminarTarea(162,165) Ultimo seg :199 Ultimo seg :200 EjecutarTarea_165() Concurso de trios id_comp1229 51 51 ValidarUsuario(165):1 EjecutarPaso_278: form:27 , caso=55 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_55',autoScroll:true ,labelAlign:'top',defaults: { anchor: '97%'} ,items: [new Ext.form.Hidden({name:'cod_formulario2',value:'27'}) ,new Ext.form.Hidden({name :'id_periodo',value:'2015'}) ,new Ext.form.Hidden({name :'obs_ingreso',value:''}) ,new Ext.form.Hidden({name:'cod_bloque',value:'28'}) ,new Ext.form.Hidden({name :'oid',value:''}) ,new Ext.form.Hidden({name :'oid_maestro',value:''}) ,new Ext.form.Hidden({ value:'2015-06-16', id:'410'}),{ xtype:'hidden',id:'hds411',disabled:true},new Ext.form.ComboBox({typeAhead:true,listeners:{ select:function(){xajax_comprobar_campoOcultoSelect(this.getValue(),411);},afterrender:function(){ xajax_comprobar_campoOcultoSelect(this.getValue(),411); }},/*fin introducir listener para campos ocultos*/triggerAction:'all',mode:'local',editable:false,emptyText:'Seleccione una opción',store:new Ext.data.ArrayStore({fields:['id', 'value'],data:[[1,'Profesional'],[2,'Veteranos'],[3,'Abierta'],[4,'Alternativa'] ]}),valueField:'id',displayField:'value',id:'inp_select_28_411',allowBlank:false,fieldLabel:'* Categoría',hiddenName:'411'}),{value:'',xtype:'textfield' , maxLength:60,autoCreate:{ tag:'input',maxlength:'60'} ,allowBlank:false,id:'412',fieldLabel:'* Nombre del trio' },{value:'',xtype:'textfield' , maxLength:60,autoCreate:{ tag:'input',maxlength:'60'} ,allowBlank:false,id:'413',fieldLabel:'* Dirección' },{value:'',xtype:'textfield' , maxLength:60,autoCreate:{ tag:'input',maxlength:'60'} ,listeners:{ blur:function(){ this.setValue(this.getValue().toUpperCase()); } } ,allowBlank:false,id:'414',fieldLabel:'* Ciudad' },{value:'',xtype:'numberfield' , maxLength:10,autoCreate:{ tag:'input',maxlength:'10'} ,id:'415',fieldLabel:'teléfono' },{value:'',xtype:'numberfield' , maxLength:10,autoCreate:{ tag:'input',maxlength:'10'} ,allowBlank:false,id:'416',fieldLabel:'* Celular' },{value:'',xtype:'textfield' , maxLength:60,autoCreate:{ tag:'input',maxlength:'60'} ,allowBlank:false,id:'417',fieldLabel:'* Correo electronico' },{ xtype:'hidden',id:'hdcampo422',value:'28'},{ xtype:'hidden',id:'422'}, new Ext.grid.EditorGridPanel({xtype:'editorgrid',store:new Ext.data.JsonStore({ fields:[{ name:'oid' },{ name:'txtnomt' },{ name:'txtcelt' },{ name:'txtcedt' }]}),columns:[new Ext.grid.RowNumberer({width:30}),{header:'Nombre',dataIndex:'txtnomt',width:80,resizable:true,sortable:true,editor:{value:'',xtype:'textfield' , maxLength:50 ,allowBlank:false}},{header:'Celular',dataIndex:'txtcelt',width:80,resizable:true,sortable:true,editor:{value:'',xtype:'numberfield' , maxLength:10 ,allowBlank:false}},{header:'Documento de identidad',dataIndex:'txtcedt',width:80,resizable:true,sortable:true,editor:{value:'',xtype:'numberfield' , maxLength:10 ,allowBlank:false}}],stripeRows:true,height:150,id:'422_28',title:'Integrantes',stateful:true,stateId:'grid',autoScroll:true,autoWidth:true,sm:new Ext.grid.RowSelectionModel({singleSelect:false}),anchor:'97%',viewConfig:{forceFit:true,showPreview: true,enableRowBody: false, getRowClass: function(record, rowIndex, rp, ds){ return 'fila-act-sin-pro';},listeners:{rowsinserted:function(view,row,info){this.refresh();},rowremoved:function(view,row,info){this.refresh();}}},tbar:[{iconCls:'icon-add',tooltip:'Agregar',text:'Agregar',handler:function(){var TopicRecord = Ext.data.Record.create({ name:'oid' },{ name:'txtnomt' },{ name:'txtcelt' },{ name:'txtcedt' });var myNewRecord = new TopicRecord({ oid:null ,txtnomt:'',txtcelt:'',txtcedt:''});var storegri = Ext.getCmp('422_28').getStore();storegri.add(myNewRecord);}},{iconCls:'icon-delete',tooltip:'Eliminar',text:'Eliminar',handler:function(){var grid = Ext.getCmp('422_28');var list = grid.getSelectionModel().getSelections();if (!list) {Ext.MessageBox.alert('Advertencia', 'Ningun item seleccionado');return false;}Ext.Msg.show({ title:'Advertencia de eliminacion', msg:'Esta seguro que desea eliminar los items seleccionados?', buttons:Ext.Msg.YESNO, animEl:'btnEl', fn:function(btn){ if (btn == 'yes'){grid.store.remove(list);} }, icon:Ext.MessageBox.QUESTION });}}]})/*fgp*/,{value:'',xtype:'textfield' , maxLength:60,autoCreate:{ tag:'input',maxlength:'60'} ,allowBlank:false,id:'423',fieldLabel:'* Director' },{value:'',xtype:'numberfield' , maxLength:10,autoCreate:{ tag:'input',maxlength:'10'} ,allowBlank:false,id:'424',fieldLabel:'* Documento de indentidad' },{value:'',xtype:'textfield' , maxLength:60,autoCreate:{ tag:'input',maxlength:'60'} ,allowBlank:false,id:'425',fieldLabel:'* Dirección' },{value:'',xtype:'numberfield' , maxLength:10,autoCreate:{ tag:'input',maxlength:'10'} ,allowBlank:false,id:'426',fieldLabel:'* teléfono' } ] ,prepararGrids:function(){/*buscar editorgrid - grilla id compuesto, id real, mas id formulario esclavo, separado _*/var grillasF=this.findByType('editorgrid');if(grillasF && grillasF!=''){for (i=0; i < grillasF.length; i++){var xstore=grillasF[i].getStore();if(xstore.getCount()>0){var data=new Array();var xxid=grillasF[i].getId().split('_');for (j=0; j < xstore.getCount(); j++){var xreco = xstore.getAt(j); var cont_dat_vac=0,cont_tot_vac=0; for(var elem in xreco.data){cont_tot_vac++;if( xreco.data[elem] ==null || xreco.data[elem]=='' ){cont_dat_vac++;}} if(cont_dat_vac < cont_tot_vac){data[data.length]=xreco.data;data[data.length-1]['form_master_escribir_xxx']=xxid[1];}}var xfinalfin=Ext.encode(data);Ext.getCmp(xxid[0]).setValue(xfinalfin);}}}/*grabar stores en hiddens*/},tbar:[{text:'Guardar',iconCls: 'icon-disk',handler: function(){ var form = Ext.getCmp('frm_formulario_87_55'); var f=form.getForm();if(f.isValid()){var band_f=true;try{band_f =form.Validar();}catch(e){}if(band_f){form.prepararGrids();f.submit({url:'http://192.168.10.116/sisad/build/view/'+'workflow/casos/casos_l.php',params:{wf_proceso_id:'87',wf_paso_id:'278',wf_tarea_id:'165',wf_caso_id:'55',id:'1229',accion:'nextPaso',reg:'s',rta:'n'},success:function(form, action){if(action.result.message) crearMsg(action.result.message,'Informacion');else if(action.result.execute){/*try{*/eval(action.result.execute);/*}catch(e){alert(e+'Se presentó un error , por favor cierre la pestaña del caso y continue el proceso desde la pestaña de resumen' );}*/}},failure: function(form, action) {switch (action.failureType) {case Ext.form.Action.CONNECT_FAILURE:Ext.Msg.alert('Error', 'No hay comunicacion con el servidor');break;case Ext.form.Action.SERVER_INVALID: Ext.Msg.alert('Error', action.result.message); break; }}});}}else{Ext.MessageBox.alert('Advertencia',getErrorFields(f));}} } ] ,listeners:{ afterrender:function(){ try{ Ext.getCmp('frm_formulario_87_55').getForm().loadRecord(new Ext.data.Record({"cod_formulario":27,"oid_maestro":null,"cod_bloque":28,"412":null,"413":null,"414":null,"415":null,"416":null,"417":null,"423":null,"424":null,"425":null,"426":null})); llamadaAJAX({url:'http://192.168.10.116/sisad/build/view/workflow/casos/casos_datosForm.php',mostrarMsg:false,params:{accion:'verifica',wf_paso_id:'278',cod_formulario:'27',cod_bloque:'28',wf_caso_id:'{"pro":"87","cas":"55"}'}}); }catch(e){alert(e);} } } }) );Ext.getCmp('comp_1229').doLayout(); [suc] => 1 ) fin 2015-06-16 11:39:03 /******************************************************************************************************/ 2015-06-16 11:39:04TraerCaso(55,87,) CargarCaso :55 2015-06 16 11:39:04 CargarDatos: Caso :55 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":"225","id":"225","1":"277","wf_paso_id":"277","2":"199","wf_caso_87_seguimiento_id":"199","3":"51","core_usuario_id":"51","4":"2015-06-16 11:39:03","fecha_ejec":"2015-06-16 11:39:03","5":"55","dato":"55","6":"sce.t33","tabla":"sce.t33","7":"162","tarea_id":"162","8":"Ruano Marcela: ciudadano","usr_ejec":"Ruano Marcela: ciudadano"} CargarDatos_277(55) se carga 87_162_277_33_34_4513 cargar datos de ejecucion de las tareas (las ultimas si el proceso tiene ciclos) select a.*, u.apellido||' '||u.nombre|| ': '||u.cargo as usr_asig , ur.apellido||' '||ur.nombre|| ': '||ur.cargo as usr_resol from wf_caso_87_seguimiento a inner join ( select max(b0.id) as id,b0.wf_caso_87_id,b0.wf_tarea_id from wf_caso_87_seguimiento b0 where b0.wf_caso_87_id =? group by b0.wf_caso_87_id,b0.wf_tarea_id order by wf_caso_87_id,id ) b using(id) left join usuarios u using(core_usuario_id) left join usuarios ur on ur.core_usuario_id=core_usuario_id_resol {"0":"199","id":"199","1":"55","wf_caso_87_id":"55","2":"162","wf_tarea_id":"162","3":null,"core_usuario_id":null,"4":"2015-06-16 11:39:00","fec_asig":"2015-06-16 11:39:00","5":"51","core_usuario_id_resol":"51","6":"2015-06-16 11:39:03","fec_resol":"2015-06-16 11:39:03","7":"162","wf_tarea_id_sig":"162","8":null,"usr_asig":null,"9":"Ruano Marcela: ciudadano","usr_resol":"Ruano Marcela: ciudadano"} {"0":"200","id":"200","1":"55","wf_caso_87_id":"55","2":"165","wf_tarea_id":"165","3":"51","core_usuario_id":"51","4":"2015-06-16 11:39:03","fec_asig":"2015-06-16 11:39:03","5":null,"core_usuario_id_resol":null,"6":null,"fec_resol":null,"7":"165","wf_tarea_id_sig":"165","8":"Ruano Marcela: ciudadano","usr_asig":"Ruano Marcela: ciudadano","9":null,"usr_resol":null} 2015-06 16 11:39:04 cargar datos del sujeto(,,s,87,55) 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=55 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 16 11:39:04 tabla dat adic select tabla from core_sujetoverificaciontipo where id=1 2015-06 16 11:39:04 tabla :persona SELECT * FROM persona where id=101 fin 2015-06-16 11:39:04 /******************************************************************************************************/ 2015-06-16 11:43:45TraerCaso(55,87,) CargarCaso :55 2015-06 16 11:43:45 CargarDatos: Caso :55 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":"225","id":"225","1":"277","wf_paso_id":"277","2":"199","wf_caso_87_seguimiento_id":"199","3":"51","core_usuario_id":"51","4":"2015-06-16 11:39:03","fecha_ejec":"2015-06-16 11:39:03","5":"55","dato":"55","6":"sce.t33","tabla":"sce.t33","7":"162","tarea_id":"162","8":"Ruano Marcela: ciudadano","usr_ejec":"Ruano Marcela: ciudadano"} CargarDatos_277(55) se carga 87_162_277_33_34_4513 cargar datos de ejecucion de las tareas (las ultimas si el proceso tiene ciclos) select a.*, u.apellido||' '||u.nombre|| ': '||u.cargo as usr_asig , ur.apellido||' '||ur.nombre|| ': '||ur.cargo as usr_resol from wf_caso_87_seguimiento a inner join ( select max(b0.id) as id,b0.wf_caso_87_id,b0.wf_tarea_id from wf_caso_87_seguimiento b0 where b0.wf_caso_87_id =? group by b0.wf_caso_87_id,b0.wf_tarea_id order by wf_caso_87_id,id ) b using(id) left join usuarios u using(core_usuario_id) left join usuarios ur on ur.core_usuario_id=core_usuario_id_resol {"0":"199","id":"199","1":"55","wf_caso_87_id":"55","2":"162","wf_tarea_id":"162","3":null,"core_usuario_id":null,"4":"2015-06-16 11:39:00","fec_asig":"2015-06-16 11:39:00","5":"51","core_usuario_id_resol":"51","6":"2015-06-16 11:39:03","fec_resol":"2015-06-16 11:39:03","7":"162","wf_tarea_id_sig":"162","8":null,"usr_asig":null,"9":"Ruano Marcela: ciudadano","usr_resol":"Ruano Marcela: ciudadano"} {"0":"200","id":"200","1":"55","wf_caso_87_id":"55","2":"165","wf_tarea_id":"165","3":"51","core_usuario_id":"51","4":"2015-06-16 11:39:03","fec_asig":"2015-06-16 11:39:03","5":null,"core_usuario_id_resol":null,"6":null,"fec_resol":null,"7":"165","wf_tarea_id_sig":"165","8":"Ruano Marcela: ciudadano","usr_asig":"Ruano Marcela: ciudadano","9":null,"usr_resol":null} 2015-06 16 11:43:45 cargar datos del sujeto(,,s,87,55) 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=55 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 16 11:43:45 tabla dat adic select tabla from core_sujetoverificaciontipo where id=1 2015-06 16 11:43:45 tabla :persona SELECT * FROM persona where id=101 2015-06 16 11:43:45 Continuar(s,165,278,) EjecutarTarea_165() Concurso de trios id_comp1229 51 51 ValidarUsuario(165):1 EjecutarPaso_278: form:27 , caso=55 id_comp 1229 Paso::Guardar(Caso:55) Datos a guardar: Array ( [wf_proceso_id] => 87 [wf_paso_id] => 278 [wf_tarea_id] => 165 [wf_caso_id] => 55 [id] => 1229 [accion] => nextPaso [reg] => s [rta] => n [cod_formulario2] => 27 [id_periodo] => 2015 [obs_ingreso] => [cod_bloque] => 28 [oid] => [oid_maestro] => [410] => 2015-06-16 [411] => 3 [412] => Siam [413] => palmares exprex [414] => PALMITA [415] => 325684 [416] => 1478596 [417] => myriabe [hdcampo422] => 28 [422] => [{"oid":null,"txtnomt":"james morales","txtcelt":2256214,"txtcedt":1785961478,"form_master_escribir_xxx":"28"}] [423] => maluma [424] => 598658 [425] => casa manzanares [426] => 895674 ) OID: 9 rta: 1 dato:9 tabla:sce.t27 CasoPaso:226 CargarDatos_278(9) se carga 87_165_278_27_28_426895674 se carga 87_165_278_27_28_425casa manzanares se carga 87_165_278_27_28_424598658 se carga 87_165_278_27_28_423maluma se carga 87_165_278_27_28_422Array se carga 87_165_278_27_28_417myriabe se carga 87_165_278_27_28_4161478596 se carga 87_165_278_27_28_415325684 se carga 87_165_278_27_28_414PALMITA se carga 87_165_278_27_28_413palmares exprex se carga 87_165_278_27_28_412Siam se carga 87_165_278_27_28_4113 se carga 87_165_278_27_28_4102015-06-16 SiguientePasoDe278: Funcion para ejecutar el siguiente paso EjecutarPaso_281: ladj:116 , caso=55 id_comp 1229 Mostrar ladj Retorno : Array ( [ret] => inicioComponente_WF_ladj({"tarea_id":165,"paso_id":281,"id":"1229","proceso_id":87,"caso_id":"55","sujeto_id":"101","ladj":116}); [suc] => 1 ) fin 2015-06-16 11:43:45 /******************************************************************************************************/ 2015-06-16 11:44:17TraerCaso(55,87,) CargarCaso :55 2015-06 16 11:44:17 CargarDatos: Caso :55 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":"225","id":"225","1":"277","wf_paso_id":"277","2":"199","wf_caso_87_seguimiento_id":"199","3":"51","core_usuario_id":"51","4":"2015-06-16 11:39:03","fecha_ejec":"2015-06-16 11:39:03","5":"55","dato":"55","6":"sce.t33","tabla":"sce.t33","7":"162","tarea_id":"162","8":"Ruano Marcela: ciudadano","usr_ejec":"Ruano Marcela: ciudadano"} CargarDatos_277(55) se carga 87_162_277_33_34_4513 {"0":"226","id":"226","1":"278","wf_paso_id":"278","2":"200","wf_caso_87_seguimiento_id":"200","3":"51","core_usuario_id":"51","4":"2015-06-16 11:43:45","fecha_ejec":"2015-06-16 11:43:45","5":"9","dato":"9","6":"sce.t27","tabla":"sce.t27","7":"165","tarea_id":"165","8":"Ruano Marcela: ciudadano","usr_ejec":"Ruano Marcela: ciudadano"} CargarDatos_278(9) se carga 87_165_278_27_28_426895674 se carga 87_165_278_27_28_425casa manzanares se carga 87_165_278_27_28_424598658 se carga 87_165_278_27_28_423maluma se carga 87_165_278_27_28_422Array se carga 87_165_278_27_28_417myriabe se carga 87_165_278_27_28_4161478596 se carga 87_165_278_27_28_415325684 se carga 87_165_278_27_28_414PALMITA se carga 87_165_278_27_28_413palmares exprex se carga 87_165_278_27_28_412Siam se carga 87_165_278_27_28_4113 se carga 87_165_278_27_28_4102015-06-16 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":"199","id":"199","1":"55","wf_caso_87_id":"55","2":"162","wf_tarea_id":"162","3":null,"core_usuario_id":null,"4":"2015-06-16 11:39:00","fec_asig":"2015-06-16 11:39:00","5":"51","core_usuario_id_resol":"51","6":"2015-06-16 11:39:03","fec_resol":"2015-06-16 11:39:03","7":"162","wf_tarea_id_sig":"162","8":null,"usr_asig":null,"9":"Ruano Marcela: ciudadano","usr_resol":"Ruano Marcela: ciudadano"} {"0":"200","id":"200","1":"55","wf_caso_87_id":"55","2":"165","wf_tarea_id":"165","3":"51","core_usuario_id":"51","4":"2015-06-16 11:39:03","fec_asig":"2015-06-16 11:39:03","5":null,"core_usuario_id_resol":null,"6":null,"fec_resol":null,"7":"165","wf_tarea_id_sig":"165","8":"Ruano Marcela: ciudadano","usr_asig":"Ruano Marcela: ciudadano","9":null,"usr_resol":null} 2015-06 16 11:44:17 cargar datos del sujeto(,,s,87,55) 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=55 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 16 11:44:17 tabla dat adic select tabla from core_sujetoverificaciontipo where id=1 2015-06 16 11:44:17 tabla :persona SELECT * FROM persona where id=101 2015-06 16 11:44:17 Continuar(s,165,281,) EjecutarTarea_165() Concurso de trios id_comp1229 51 51 ValidarUsuario(165):1 EjecutarPaso_281: ladj:116 , caso=55 id_comp 1229 Paso::Guardar(Caso:55) rta: 1 dato:6034 tabla:wf_documentoentradaadj_caso CasoPaso:227 CargarDatos_281(6034) SiguientePasoDe281: Funcion para ejecutar el siguiente paso EjecutarPaso_284: corr:104 , caso=55 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":"55","proceso_id":87,"tit":"Concurso de trios","tarea_id":165,"paso_id":284,"desc":"

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

\n

El presente mensaje es una notificación para el caso No 55<\/strong> <\/p>\nSu solicitud de Inscripci\u00f3n a eventos culturales en el concurso de tr\u00edos se realiz\u00f3 con \u00e9xito y se encuentra en tramite .<\/strong> ","url":"De click aqui para volver a enviar el correo<\/a><\/div>"}); [suc] => 1 ) fin 2015-06-16 11:44:17 /******************************************************************************************************/ 2015-06-16 11:44:23TraerCaso(55,87,) CargarCaso :55 2015-06 16 11:44:23 CargarDatos: Caso :55 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":"225","id":"225","1":"277","wf_paso_id":"277","2":"199","wf_caso_87_seguimiento_id":"199","3":"51","core_usuario_id":"51","4":"2015-06-16 11:39:03","fecha_ejec":"2015-06-16 11:39:03","5":"55","dato":"55","6":"sce.t33","tabla":"sce.t33","7":"162","tarea_id":"162","8":"Ruano Marcela: ciudadano","usr_ejec":"Ruano Marcela: ciudadano"} CargarDatos_277(55) se carga 87_162_277_33_34_4513 {"0":"226","id":"226","1":"278","wf_paso_id":"278","2":"200","wf_caso_87_seguimiento_id":"200","3":"51","core_usuario_id":"51","4":"2015-06-16 11:43:45","fecha_ejec":"2015-06-16 11:43:45","5":"9","dato":"9","6":"sce.t27","tabla":"sce.t27","7":"165","tarea_id":"165","8":"Ruano Marcela: ciudadano","usr_ejec":"Ruano Marcela: ciudadano"} CargarDatos_278(9) se carga 87_165_278_27_28_426895674 se carga 87_165_278_27_28_425casa manzanares se carga 87_165_278_27_28_424598658 se carga 87_165_278_27_28_423maluma se carga 87_165_278_27_28_422Array se carga 87_165_278_27_28_417myriabe se carga 87_165_278_27_28_4161478596 se carga 87_165_278_27_28_415325684 se carga 87_165_278_27_28_414PALMITA se carga 87_165_278_27_28_413palmares exprex se carga 87_165_278_27_28_412Siam se carga 87_165_278_27_28_4113 se carga 87_165_278_27_28_4102015-06-16 {"0":"227","id":"227","1":"281","wf_paso_id":"281","2":"200","wf_caso_87_seguimiento_id":"200","3":"51","core_usuario_id":"51","4":"2015-06-16 11:44:17","fecha_ejec":"2015-06-16 11:44:17","5":"6034","dato":"6034","6":"wf_documentoentradaadj_caso","tabla":"wf_documentoentradaadj_caso","7":"165","tarea_id":"165","8":"Ruano Marcela: ciudadano","usr_ejec":"Ruano Marcela: ciudadano"} CargarDatos_281(6034) 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":"199","id":"199","1":"55","wf_caso_87_id":"55","2":"162","wf_tarea_id":"162","3":null,"core_usuario_id":null,"4":"2015-06-16 11:39:00","fec_asig":"2015-06-16 11:39:00","5":"51","core_usuario_id_resol":"51","6":"2015-06-16 11:39:03","fec_resol":"2015-06-16 11:39:03","7":"162","wf_tarea_id_sig":"162","8":null,"usr_asig":null,"9":"Ruano Marcela: ciudadano","usr_resol":"Ruano Marcela: ciudadano"} {"0":"200","id":"200","1":"55","wf_caso_87_id":"55","2":"165","wf_tarea_id":"165","3":"51","core_usuario_id":"51","4":"2015-06-16 11:39:03","fec_asig":"2015-06-16 11:39:03","5":null,"core_usuario_id_resol":null,"6":null,"fec_resol":null,"7":"165","wf_tarea_id_sig":"165","8":"Ruano Marcela: ciudadano","usr_asig":"Ruano Marcela: ciudadano","9":null,"usr_resol":null} 2015-06 16 11:44:23 cargar datos del sujeto(,,s,87,55) 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=55 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 16 11:44:23 tabla dat adic select tabla from core_sujetoverificaciontipo where id=1 2015-06 16 11:44:23 tabla :persona SELECT * FROM persona where id=101 2015-06 16 11:44:23 Continuar(s,165,284,) EjecutarTarea_165() Concurso de trios id_comp1229 51 51 ValidarUsuario(165):1 EjecutarPaso_284: corr:104 , caso=55 id_comp 1229 Paso::Guardar(Caso:55) rta: 1 dato: tabla: CasoPaso:228 CargarDatos_284() SiguientePasoDe284: Funcion para ejecutar el siguiente paso Condicion Tarea : true TerminarTarea(165,166) Ultimo seg :200 Ultimo seg :201 EjecutarTarea_166() Verificacion trios id_comp1229 51 ValidarUsuario(166): 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-16 11:44:23 /******************************************************************************************************/ 2015-06-26 11:46:38TraerCaso(55,87,) CargarCaso :55 2015-06 26 11:46:38 CargarDatos: Caso :55 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":"225","id":"225","1":"277","wf_paso_id":"277","2":"199","wf_caso_87_seguimiento_id":"199","3":"51","core_usuario_id":"51","4":"2015-06-16 11:39:03","fecha_ejec":"2015-06-16 11:39:03","5":"55","dato":"55","6":"sce.t33","tabla":"sce.t33","7":"162","tarea_id":"162","8":"Ruano Marcela: ciudadano","usr_ejec":"Ruano Marcela: ciudadano"} CargarDatos_277(55) se carga 87_162_277_33_34_4513 {"0":"226","id":"226","1":"278","wf_paso_id":"278","2":"200","wf_caso_87_seguimiento_id":"200","3":"51","core_usuario_id":"51","4":"2015-06-16 11:43:45","fecha_ejec":"2015-06-16 11:43:45","5":"9","dato":"9","6":"sce.t27","tabla":"sce.t27","7":"165","tarea_id":"165","8":"Ruano Marcela: ciudadano","usr_ejec":"Ruano Marcela: ciudadano"} CargarDatos_278(9) se carga 87_165_278_27_28_426895674 se carga 87_165_278_27_28_425casa manzanares se carga 87_165_278_27_28_424598658 se carga 87_165_278_27_28_423maluma se carga 87_165_278_27_28_422Array se carga 87_165_278_27_28_417myriabe se carga 87_165_278_27_28_4161478596 se carga 87_165_278_27_28_415325684 se carga 87_165_278_27_28_414PALMITA se carga 87_165_278_27_28_413palmares exprex se carga 87_165_278_27_28_412Siam se carga 87_165_278_27_28_4113 se carga 87_165_278_27_28_4102015-06-16 {"0":"227","id":"227","1":"281","wf_paso_id":"281","2":"200","wf_caso_87_seguimiento_id":"200","3":"51","core_usuario_id":"51","4":"2015-06-16 11:44:17","fecha_ejec":"2015-06-16 11:44:17","5":"6034","dato":"6034","6":"wf_documentoentradaadj_caso","tabla":"wf_documentoentradaadj_caso","7":"165","tarea_id":"165","8":"Ruano Marcela: ciudadano","usr_ejec":"Ruano Marcela: ciudadano"} CargarDatos_281(6034) {"0":"228","id":"228","1":"284","wf_paso_id":"284","2":"200","wf_caso_87_seguimiento_id":"200","3":"51","core_usuario_id":"51","4":"2015-06-16 11:44:23","fecha_ejec":"2015-06-16 11:44:23","5":null,"dato":null,"6":null,"tabla":null,"7":"165","tarea_id":"165","8":"Ruano Marcela: ciudadano","usr_ejec":"Ruano Marcela: ciudadano"} CargarDatos_284() 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":"199","id":"199","1":"55","wf_caso_87_id":"55","2":"162","wf_tarea_id":"162","3":null,"core_usuario_id":null,"4":"2015-06-16 11:39:00","fec_asig":"2015-06-16 11:39:00","5":"51","core_usuario_id_resol":"51","6":"2015-06-16 11:39:03","fec_resol":"2015-06-16 11:39:03","7":"162","wf_tarea_id_sig":"162","8":null,"usr_asig":null,"9":"Ruano Marcela: ciudadano","usr_resol":"Ruano Marcela: ciudadano"} {"0":"200","id":"200","1":"55","wf_caso_87_id":"55","2":"165","wf_tarea_id":"165","3":"51","core_usuario_id":"51","4":"2015-06-16 11:39:03","fec_asig":"2015-06-16 11:39:03","5":"51","core_usuario_id_resol":"51","6":"2015-06-16 11:44:23","fec_resol":"2015-06-16 11:44:23","7":"165","wf_tarea_id_sig":"165","8":"Ruano Marcela: ciudadano","usr_asig":"Ruano Marcela: ciudadano","9":"Ruano Marcela: ciudadano","usr_resol":"Ruano Marcela: ciudadano"} {"0":"201","id":"201","1":"55","wf_caso_87_id":"55","2":"166","wf_tarea_id":"166","3":null,"core_usuario_id":null,"4":"2015-06-16 11:44:23","fec_asig":"2015-06-16 11:44:23","5":null,"core_usuario_id_resol":null,"6":null,"fec_resol":null,"7":"166","wf_tarea_id_sig":"166","8":null,"usr_asig":null,"9":null,"usr_resol":null} 2015-06 26 11:46:39 cargar datos del sujeto(,,s,87,55) 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=55 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 26 11:46:39 tabla dat adic select tabla from core_sujetoverificaciontipo where id=1 2015-06 26 11:46:39 tabla :persona SELECT * FROM persona where id=101 2015-06 26 11:46:39 Continuar(,166,,s) EjecutarTarea_166() Verificacion trios id_comp1232 38 ValidarUsuario(166):1 EjecutarPaso_286: vadj:116 , caso=55 id_comp 1232 Mostrar vadj Retorno : Array ( [ret] => inicioComponente_WF_vadj({"tarea_id":166,"paso_id":286,"id":"1232","proceso_id":87,"caso_id":"55","sujeto_id":"101","vadj":116}); [suc] => 1 ) fin 2015-06-26 11:46:39 /******************************************************************************************************/ 2015-06-26 11:47:14TraerCaso(55,87,) CargarCaso :55 2015-06 26 11:47:14 CargarDatos: Caso :55 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":"225","id":"225","1":"277","wf_paso_id":"277","2":"199","wf_caso_87_seguimiento_id":"199","3":"51","core_usuario_id":"51","4":"2015-06-16 11:39:03","fecha_ejec":"2015-06-16 11:39:03","5":"55","dato":"55","6":"sce.t33","tabla":"sce.t33","7":"162","tarea_id":"162","8":"Ruano Marcela: ciudadano","usr_ejec":"Ruano Marcela: ciudadano"} CargarDatos_277(55) se carga 87_162_277_33_34_4513 {"0":"226","id":"226","1":"278","wf_paso_id":"278","2":"200","wf_caso_87_seguimiento_id":"200","3":"51","core_usuario_id":"51","4":"2015-06-16 11:43:45","fecha_ejec":"2015-06-16 11:43:45","5":"9","dato":"9","6":"sce.t27","tabla":"sce.t27","7":"165","tarea_id":"165","8":"Ruano Marcela: ciudadano","usr_ejec":"Ruano Marcela: ciudadano"} CargarDatos_278(9) se carga 87_165_278_27_28_426895674 se carga 87_165_278_27_28_425casa manzanares se carga 87_165_278_27_28_424598658 se carga 87_165_278_27_28_423maluma se carga 87_165_278_27_28_422Array se carga 87_165_278_27_28_417myriabe se carga 87_165_278_27_28_4161478596 se carga 87_165_278_27_28_415325684 se carga 87_165_278_27_28_414PALMITA se carga 87_165_278_27_28_413palmares exprex se carga 87_165_278_27_28_412Siam se carga 87_165_278_27_28_4113 se carga 87_165_278_27_28_4102015-06-16 {"0":"227","id":"227","1":"281","wf_paso_id":"281","2":"200","wf_caso_87_seguimiento_id":"200","3":"51","core_usuario_id":"51","4":"2015-06-16 11:44:17","fecha_ejec":"2015-06-16 11:44:17","5":"6034","dato":"6034","6":"wf_documentoentradaadj_caso","tabla":"wf_documentoentradaadj_caso","7":"165","tarea_id":"165","8":"Ruano Marcela: ciudadano","usr_ejec":"Ruano Marcela: ciudadano"} CargarDatos_281(6034) {"0":"228","id":"228","1":"284","wf_paso_id":"284","2":"200","wf_caso_87_seguimiento_id":"200","3":"51","core_usuario_id":"51","4":"2015-06-16 11:44:23","fecha_ejec":"2015-06-16 11:44:23","5":null,"dato":null,"6":null,"tabla":null,"7":"165","tarea_id":"165","8":"Ruano Marcela: ciudadano","usr_ejec":"Ruano Marcela: ciudadano"} CargarDatos_284() 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":"199","id":"199","1":"55","wf_caso_87_id":"55","2":"162","wf_tarea_id":"162","3":null,"core_usuario_id":null,"4":"2015-06-16 11:39:00","fec_asig":"2015-06-16 11:39:00","5":"51","core_usuario_id_resol":"51","6":"2015-06-16 11:39:03","fec_resol":"2015-06-16 11:39:03","7":"162","wf_tarea_id_sig":"162","8":null,"usr_asig":null,"9":"Ruano Marcela: ciudadano","usr_resol":"Ruano Marcela: ciudadano"} {"0":"200","id":"200","1":"55","wf_caso_87_id":"55","2":"165","wf_tarea_id":"165","3":"51","core_usuario_id":"51","4":"2015-06-16 11:39:03","fec_asig":"2015-06-16 11:39:03","5":"51","core_usuario_id_resol":"51","6":"2015-06-16 11:44:23","fec_resol":"2015-06-16 11:44:23","7":"165","wf_tarea_id_sig":"165","8":"Ruano Marcela: ciudadano","usr_asig":"Ruano Marcela: ciudadano","9":"Ruano Marcela: ciudadano","usr_resol":"Ruano Marcela: ciudadano"} {"0":"201","id":"201","1":"55","wf_caso_87_id":"55","2":"166","wf_tarea_id":"166","3":null,"core_usuario_id":null,"4":"2015-06-16 11:44:23","fec_asig":"2015-06-16 11:44:23","5":null,"core_usuario_id_resol":null,"6":null,"fec_resol":null,"7":"166","wf_tarea_id_sig":"166","8":null,"usr_asig":null,"9":null,"usr_resol":null} 2015-06 26 11:47:14 cargar datos del sujeto(,,s,87,55) 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=55 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 26 11:47:14 tabla dat adic select tabla from core_sujetoverificaciontipo where id=1 2015-06 26 11:47:14 tabla :persona SELECT * FROM persona where id=101 2015-06 26 11:47:14 Continuar(s,166,286,) EjecutarTarea_166() Verificacion trios id_comp1232 38 ValidarUsuario(166):1 EjecutarPaso_286: vadj:116 , caso=55 id_comp 1232 Paso::Guardar(Caso:55) rta: 1 dato:2442 tabla:wf_documentoentradaadj_caso CasoPaso:237 CargarDatos_286(2442) SiguientePasoDe286: Funcion para ejecutar el siguiente paso Condicion Tarea : Si =="Si" TerminarTarea(166,170) Ultimo seg :201 Ultimo seg :210 EjecutarTarea_170() Inscripcion exitosa trios id_comp1232 38 38 ValidarUsuario(170):1 EjecutarPaso_290: corr:108 , caso=55 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

inicioComponente_WF_Correo({"id":"1232","caso_id":"55","proceso_id":87,"tit":"Inscripcion exitosa trios","tarea_id":170,"paso_id":290,"desc":"

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

\n

El presente mensaje es una notificación para el caso No 55<\/strong> <\/p>\nSu inscripci\u00f3n a eventos culturales en concurso internacional de tr\u00edos se realiz\u00f3 con \u00e9xito, favor acercarse a la ventanilla correspondiente con los documento respectivos en f\u00edsico.<\/strong> ","url":"De click aqui para volver a enviar el correo<\/a><\/div>"}); [suc] => 1 ) fin 2015-06-26 11:47:15 /******************************************************************************************************/ 2015-06-26 11:47:17TraerCaso(55,87,) CargarCaso :55 2015-06 26 11:47:17 CargarDatos: Caso :55 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":"225","id":"225","1":"277","wf_paso_id":"277","2":"199","wf_caso_87_seguimiento_id":"199","3":"51","core_usuario_id":"51","4":"2015-06-16 11:39:03","fecha_ejec":"2015-06-16 11:39:03","5":"55","dato":"55","6":"sce.t33","tabla":"sce.t33","7":"162","tarea_id":"162","8":"Ruano Marcela: ciudadano","usr_ejec":"Ruano Marcela: ciudadano"} CargarDatos_277(55) se carga 87_162_277_33_34_4513 {"0":"226","id":"226","1":"278","wf_paso_id":"278","2":"200","wf_caso_87_seguimiento_id":"200","3":"51","core_usuario_id":"51","4":"2015-06-16 11:43:45","fecha_ejec":"2015-06-16 11:43:45","5":"9","dato":"9","6":"sce.t27","tabla":"sce.t27","7":"165","tarea_id":"165","8":"Ruano Marcela: ciudadano","usr_ejec":"Ruano Marcela: ciudadano"} CargarDatos_278(9) se carga 87_165_278_27_28_426895674 se carga 87_165_278_27_28_425casa manzanares se carga 87_165_278_27_28_424598658 se carga 87_165_278_27_28_423maluma se carga 87_165_278_27_28_422Array se carga 87_165_278_27_28_417myriabe se carga 87_165_278_27_28_4161478596 se carga 87_165_278_27_28_415325684 se carga 87_165_278_27_28_414PALMITA se carga 87_165_278_27_28_413palmares exprex se carga 87_165_278_27_28_412Siam se carga 87_165_278_27_28_4113 se carga 87_165_278_27_28_4102015-06-16 {"0":"227","id":"227","1":"281","wf_paso_id":"281","2":"200","wf_caso_87_seguimiento_id":"200","3":"51","core_usuario_id":"51","4":"2015-06-16 11:44:17","fecha_ejec":"2015-06-16 11:44:17","5":"6034","dato":"6034","6":"wf_documentoentradaadj_caso","tabla":"wf_documentoentradaadj_caso","7":"165","tarea_id":"165","8":"Ruano Marcela: ciudadano","usr_ejec":"Ruano Marcela: ciudadano"} CargarDatos_281(6034) {"0":"228","id":"228","1":"284","wf_paso_id":"284","2":"200","wf_caso_87_seguimiento_id":"200","3":"51","core_usuario_id":"51","4":"2015-06-16 11:44:23","fecha_ejec":"2015-06-16 11:44:23","5":null,"dato":null,"6":null,"tabla":null,"7":"165","tarea_id":"165","8":"Ruano Marcela: ciudadano","usr_ejec":"Ruano Marcela: ciudadano"} CargarDatos_284() {"0":"237","id":"237","1":"286","wf_paso_id":"286","2":"201","wf_caso_87_seguimiento_id":"201","3":"38","core_usuario_id":"38","4":"2015-06-26 11:47:15","fecha_ejec":"2015-06-26 11:47:15","5":"2442","dato":"2442","6":"wf_documentoentradaadj_caso","tabla":"wf_documentoentradaadj_caso","7":"166","tarea_id":"166","8":"secretaria operador : gerente","usr_ejec":"secretaria operador : gerente"} CargarDatos_286(2442) 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":"199","id":"199","1":"55","wf_caso_87_id":"55","2":"162","wf_tarea_id":"162","3":null,"core_usuario_id":null,"4":"2015-06-16 11:39:00","fec_asig":"2015-06-16 11:39:00","5":"51","core_usuario_id_resol":"51","6":"2015-06-16 11:39:03","fec_resol":"2015-06-16 11:39:03","7":"162","wf_tarea_id_sig":"162","8":null,"usr_asig":null,"9":"Ruano Marcela: ciudadano","usr_resol":"Ruano Marcela: ciudadano"} {"0":"200","id":"200","1":"55","wf_caso_87_id":"55","2":"165","wf_tarea_id":"165","3":"51","core_usuario_id":"51","4":"2015-06-16 11:39:03","fec_asig":"2015-06-16 11:39:03","5":"51","core_usuario_id_resol":"51","6":"2015-06-16 11:44:23","fec_resol":"2015-06-16 11:44:23","7":"165","wf_tarea_id_sig":"165","8":"Ruano Marcela: ciudadano","usr_asig":"Ruano Marcela: ciudadano","9":"Ruano Marcela: ciudadano","usr_resol":"Ruano Marcela: ciudadano"} {"0":"201","id":"201","1":"55","wf_caso_87_id":"55","2":"166","wf_tarea_id":"166","3":null,"core_usuario_id":null,"4":"2015-06-16 11:44:23","fec_asig":"2015-06-16 11:44:23","5":"38","core_usuario_id_resol":"38","6":"2015-06-26 11:47:15","fec_resol":"2015-06-26 11:47:15","7":"166","wf_tarea_id_sig":"166","8":null,"usr_asig":null,"9":"secretaria operador : gerente","usr_resol":"secretaria operador : gerente"} {"0":"210","id":"210","1":"55","wf_caso_87_id":"55","2":"170","wf_tarea_id":"170","3":"38","core_usuario_id":"38","4":"2015-06-26 11:47:15","fec_asig":"2015-06-26 11:47:15","5":null,"core_usuario_id_resol":null,"6":null,"fec_resol":null,"7":"170","wf_tarea_id_sig":"170","8":"secretaria operador : gerente","usr_asig":"secretaria operador : gerente","9":null,"usr_resol":null} 2015-06 26 11:47:17 cargar datos del sujeto(,,s,87,55) 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=55 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 26 11:47:17 tabla dat adic select tabla from core_sujetoverificaciontipo where id=1 2015-06 26 11:47:17 tabla :persona SELECT * FROM persona where id=101 2015-06 26 11:47:17 Continuar(s,170,290,) EjecutarTarea_170() Inscripcion exitosa trios id_comp1232 38 38 ValidarUsuario(170):1 EjecutarPaso_290: corr:108 , caso=55 id_comp 1232 Paso::Guardar(Caso:55) rta: 1 dato: tabla: CasoPaso:238 CargarDatos_290() SiguientePasoDe290: Funcion para ejecutar el siguiente paso TerminarTarea(170,) Retorno : Array ( [htm] => [suc] => 1 [ret] => crearMsg('El proceso ha terminado exitosamente, si considera que no debe ser asi Comuniquese con el administrador del sistema','Información');Ext.getCmp('comp_1232').funcionInicial('n'); ) fin 2015-06-26 11:47:17 /******************************************************************************************************/