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<co;i++) {var r = g.getStore().getAt(i);  if(r.data.txtnomi&&r.data.txtedad&&r.data.txtdoci){   sw=1;  }else{Ext.MessageBox.alert('Advertencia', 'Debe ingresar toda la información de los integrantes');sw=0;co=-99999999;   }}}else{    Ext.MessageBox.alert('Advertencia', 'Debe ingresar los integrantes');   }if(gr.data.txttit&&gr.data.txtritmo&&grr.data.txttit&&grr.data.txtritmo){sw2=1;}else{    Ext.MessageBox.alert('Advertencia', 'Debe ingresar la información de los temas inéditos');   }      if(sw==1&&sw2==1){    var form = Ext.getCmp('frm_formulario_87_60'); 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:'280',wf_tarea_id:'163',wf_caso_id:'60',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&ntilde;a del caso y continue el proceso desde la pesta&ntilde;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_60').getForm().loadRecord(new Ext.data.Record({"cod_formulario":29,"oid_maestro":null,"cod_bloque":32,"434":null,"435":null,"436":null,"439":null,"440":null,"441":null,"443":null,"444":null,"445":null})); Ext.getCmp('446_31').getStore().loadData([{"txttit":""},{"txtritmo":""}]); llamadaAJAX({url:'http://192.168.10.116/sisad/build/view/workflow/casos/casos_datosForm.php',mostrarMsg:false,params:{accion:'verifica',wf_paso_id:'280',cod_formulario:'29',cod_bloque:'32',wf_caso_id:'{"pro":"87","cas":"60"}'}}); }catch(e){alert(e);} } }  }) );Ext.getCmp('comp_1229').doLayout();
	    [suc] => 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');
					?>
					<p>
					Apreciado(a)<br>
					<strong><?php echo htmlentities($ciud) ?></strong>
					<p>
					<p>El presente mensaje es una notificaci&oacute;n para el caso No  <strong><?php echo $id_caso; ?></strong> </p>
					<?php  $html=ob_get_clean();  
					TWFSV_3:Ruano
					TWFSV_2:Marcela
					Su solicitud de Inscripción a eventos culturales en el concurso de Música campesina se realizó con éxito y se encuentra en trámite .
					{ WFSV_1 }
					TWFSV_1:myriabe123@gmail.com
					Registro exitoso música campesina
	Retorno :
	Array
	(
	    [ret] => inicioComponente_WF_Correo({"id":"1229","caso_id":"60","proceso_id":87,"tit":"Concurso musica campesina","tarea_id":163,"paso_id":283,"desc":"<p>\nApreciado(a)<br>\n<strong>MARCELA RUANO<\/strong>\n<p>\n<p>El presente mensaje es una notificaci&oacute;n para el caso No  <strong>60<\/strong> <\/p>\n<strong>Su 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":"<a href=\"#\" onclick=\" llamadaAJAX({\r\n\t\t\t\t\t\t\t\t\turl:'http:\/\/192.168.10.116\/sisad\/build\/view\/mail\/envio\/envio_l.php',\r\n\t\t\t\t\t\t\t\t\tmostrarMsg:true,\r\n\t\t\t\t\t\t\t\t\tparams:{accion:'envio2',destino:'myriabe123@gmail.com',asunto:'Registro exitoso m\u00fasica campesina'},\r\n\t\t\t\t\t\t\t\t\tsuccess:function(result){\r\n\t\t\t\t\t\t\t\t\t\t\t\t\tif(result.success) \r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\tcrearMsg(action.result.message,'Informacion');\r\n\t\t\t\t\t\t\t\t\t\t\t\t\telse{\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\tcrearMsg(action.result.message,'Informacion');\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t}\r\n\t\t\t\t\t\t\t\t\t\t\t\t},\r\n\t\t\t\t\t\t\t\t});\" >De click aqui para volver a enviar el correo<\/a><\/div>"});
	    [suc] => 1
	)
	
 fin 2015-06-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&oacute;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');
					?>
					<p>
					Apreciado(a)<br>
					<strong><?php echo htmlentities($ciud) ?></strong>
					<p>
					<p>El presente mensaje es una notificaci&oacute;n para el caso No  <strong><?php echo $id_caso; ?></strong> </p>
					<?php  $html=ob_get_clean();  
					TWFSV_3:Ruano
					TWFSV_2:Marcela
					<br>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":"<p>\nApreciado(a)<br>\n<strong>MARCELA RUANO<\/strong>\n<p>\n<p>El presente mensaje es una notificaci&oacute;n para el caso No  <strong>60<\/strong> <\/p>\n<strong><br>Su inscripci\u00f3n a eventos culturales en m\u00fasica campesina se realiz\u00f3 con \u00e9xito.<\/strong> ","url":"<a href=\"#\" onclick=\" llamadaAJAX({\r\n\t\t\t\t\t\t\t\t\turl:'http:\/\/192.168.10.116\/sisad\/build\/view\/mail\/envio\/envio_l.php',\r\n\t\t\t\t\t\t\t\t\tmostrarMsg:true,\r\n\t\t\t\t\t\t\t\t\tparams:{accion:'envio2',destino:'myriabe123@gmail.com ',asunto:'Inscripci\u00f3n exitosa en la categor\u00eda m\u00fasica campesina'},\r\n\t\t\t\t\t\t\t\t\tsuccess:function(result){\r\n\t\t\t\t\t\t\t\t\t\t\t\t\tif(result.success) \r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\tcrearMsg(action.result.message,'Informacion');\r\n\t\t\t\t\t\t\t\t\t\t\t\t\telse{\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\tcrearMsg(action.result.message,'Informacion');\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t}\r\n\t\t\t\t\t\t\t\t\t\t\t\t},\r\n\t\t\t\t\t\t\t\t});\" >De click aqui para volver a enviar el correo<\/a><\/div>"});
	    [suc] => 1
	)
	
 fin 2015-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&oacute;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&oacute;n');Ext.getCmp('comp_1232').funcionInicial('n');
	)
	
 fin 2015-07-01  13:11:00
/******************************************************************************************************/