2015-06 16 11:18:52  
Nuevo(101,1)
		Caso :50 
2015-06 16 11:18:52  
cargar datos del sujeto(,,s,87,50)
	
				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=50 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:18:52  
tabla dat adic
	select tabla from core_sujetoverificaciontipo where id=1
2015-06 16 11:18:52  
tabla :persona
	SELECT * FROM persona where id=101
		CasoSeguimiento :186 
	EjecutarTarea_162() Tipo fromulario id_comp1229
				  51
		ValidarUsuario(162):1
			EjecutarPaso_277: form:33 , caso=50 id_comp 1229
				Mostrar form
 fin 2015-06-16  11:18:52
/******************************************************************************************************/

2015-06-16 11:18:52TraerCaso(50,87,)
 CargarCaso :50
2015-06 16 11:18:52  
CargarDatos: Caso :50
	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":"186","id":"186","1":"50","wf_caso_87_id":"50","2":"162","wf_tarea_id":"162","3":null,"core_usuario_id":null,"4":"2015-06-16 11:18:52","fec_asig":"2015-06-16 11:18:52","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:18:52  
cargar datos del sujeto(,,s,87,50)
	
				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=50 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:18:52  
tabla dat adic
	select tabla from core_sujetoverificaciontipo where id=1
2015-06 16 11:18:52  
tabla :persona
	SELECT * FROM persona where id=101
 fin 2015-06-16  11:18:52
/******************************************************************************************************/

2015-06-16 11:18:57TraerCaso(50,87,)
 CargarCaso :50
2015-06 16 11:18:57  
CargarDatos: Caso :50
	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":"186","id":"186","1":"50","wf_caso_87_id":"50","2":"162","wf_tarea_id":"162","3":null,"core_usuario_id":null,"4":"2015-06-16 11:18:52","fec_asig":"2015-06-16 11:18:52","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:18:57  
cargar datos del sujeto(,,s,87,50)
	
				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=50 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:18:57  
tabla dat adic
	select tabla from core_sujetoverificaciontipo where id=1
2015-06 16 11:18:57  
tabla :persona
	SELECT * FROM persona where id=101
2015-06 16 11:18:57  
Continuar(s,162,277,)
	EjecutarTarea_162() Tipo fromulario id_comp1229
				  51
		ValidarUsuario(162):1
			EjecutarPaso_277: form:33 , caso=50 id_comp 1229
				Paso::Guardar(Caso:50)
					Datos a guardar:
						Array
						(
						    [wf_proceso_id] => 87
						    [wf_paso_id] => 277
						    [wf_tarea_id] => 162
						    [wf_caso_id] => 50
						    [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: 50
					rta: 1 dato:50 tabla:sce.t33 
					CasoPaso:213
				CargarDatos_277(50)
							se carga 87_162_277_33_34_4511
				SiguientePasoDe277: Funcion para ejecutar el siguiente paso 
			Condicion Tarea :  1 ==1
		TerminarTarea(162,163)
			Ultimo seg :186 
			Ultimo seg :187 
	EjecutarTarea_163() Concurso musica campesina id_comp1229
				51  51
		ValidarUsuario(163):1
			EjecutarPaso_280: form:29 , caso=50 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_50',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-16', 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' },{value:'',xtype:'numberfield' , maxLength:10,autoCreate:{ tag:'input',maxlength:'10'} ,allowBlank:false,id:'440',fieldLabel:'* Documento de identificación' },{value:'',xtype:'textfield' , maxLength:60,autoCreate:{ tag:'input',maxlength:'60'} ,allowBlank:false,id:'441',fieldLabel:'* Lugar deexpedición' },new Ext.form.DateField({fieldLabel:'* Fecha de nacimiento',name:'442',allowBlank:false,maskRe:/^[-_0-9]$/,format:FormatoFecha,renderer:Ext.util.Format.dateRenderer(FormatoFecha)  }),{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:'numberfield' , maxLength:10,autoCreate:{ tag:'input',maxlength:'10'} ,allowBlank:false,id:'445',fieldLabel:'* Teléfono' },{ 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}}],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:'',xtype:'textfield' , maxLength:50,autoCreate:{ tag:'input',maxlength:'50'} ,allowBlank:false}},{header:'Edad',dataIndex:'txtedad',width:80,resizable:true,sortable:true,editor:{value:'',xtype:'numberfield' , maxLength:2,autoCreate:{ tag:'input',maxlength:'2'} ,allowBlank:false}},{header:'Documento de indetidad',dataIndex:'txtdoci',width:80,resizable:true,sortable:true,editor:{value:'',xtype:'numberfield' , maxLength:10,autoCreate:{ tag:'input',maxlength:'10'} ,allowBlank:false}}],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 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*/ ] ,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_50'); 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:'50',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_50').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":"50"}'}}); }catch(e){alert(e);} } }  }) );Ext.getCmp('comp_1229').doLayout();
	    [suc] => 1
	)
	
 fin 2015-06-16  11:18:57
/******************************************************************************************************/

2015-06-16 11:18:57TraerCaso(50,87,)
 CargarCaso :50
2015-06 16 11:18:57  
CargarDatos: Caso :50
	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":"213","id":"213","1":"277","wf_paso_id":"277","2":"186","wf_caso_87_seguimiento_id":"186","3":"51","core_usuario_id":"51","4":"2015-06-16 11:18:57","fecha_ejec":"2015-06-16 11:18:57","5":"50","dato":"50","6":"sce.t33","tabla":"sce.t33","7":"162","tarea_id":"162","8":"Ruano Marcela: ciudadano","usr_ejec":"Ruano Marcela: ciudadano"}
				CargarDatos_277(50)
							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":"186","id":"186","1":"50","wf_caso_87_id":"50","2":"162","wf_tarea_id":"162","3":null,"core_usuario_id":null,"4":"2015-06-16 11:18:52","fec_asig":"2015-06-16 11:18:52","5":"51","core_usuario_id_resol":"51","6":"2015-06-16 11:18:57","fec_resol":"2015-06-16 11:18:57","7":"162","wf_tarea_id_sig":"162","8":null,"usr_asig":null,"9":"Ruano Marcela: ciudadano","usr_resol":"Ruano Marcela: ciudadano"}
			{"0":"187","id":"187","1":"50","wf_caso_87_id":"50","2":"163","wf_tarea_id":"163","3":"51","core_usuario_id":"51","4":"2015-06-16 11:18:57","fec_asig":"2015-06-16 11:18:57","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 16 11:18:57  
cargar datos del sujeto(,,s,87,50)
	
				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=50 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:18:57  
tabla dat adic
	select tabla from core_sujetoverificaciontipo where id=1
2015-06 16 11:18:57  
tabla :persona
	SELECT * FROM persona where id=101
 fin 2015-06-16  11:18:57
/******************************************************************************************************/

2015-06-16 11:32:42TraerCaso(50,87,)
 CargarCaso :50
2015-06 16 11:32:42  
CargarDatos: Caso :50
	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":"213","id":"213","1":"277","wf_paso_id":"277","2":"186","wf_caso_87_seguimiento_id":"186","3":"51","core_usuario_id":"51","4":"2015-06-16 11:18:57","fecha_ejec":"2015-06-16 11:18:57","5":"50","dato":"50","6":"sce.t33","tabla":"sce.t33","7":"162","tarea_id":"162","8":"Ruano Marcela: ciudadano","usr_ejec":"Ruano Marcela: ciudadano"}
				CargarDatos_277(50)
							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":"186","id":"186","1":"50","wf_caso_87_id":"50","2":"162","wf_tarea_id":"162","3":null,"core_usuario_id":null,"4":"2015-06-16 11:18:52","fec_asig":"2015-06-16 11:18:52","5":"51","core_usuario_id_resol":"51","6":"2015-06-16 11:18:57","fec_resol":"2015-06-16 11:18:57","7":"162","wf_tarea_id_sig":"162","8":null,"usr_asig":null,"9":"Ruano Marcela: ciudadano","usr_resol":"Ruano Marcela: ciudadano"}
			{"0":"187","id":"187","1":"50","wf_caso_87_id":"50","2":"163","wf_tarea_id":"163","3":"51","core_usuario_id":"51","4":"2015-06-16 11:18:57","fec_asig":"2015-06-16 11:18:57","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 16 11:32:42  
cargar datos del sujeto(,,s,87,50)
	
				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=50 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:32:42  
tabla dat adic
	select tabla from core_sujetoverificaciontipo where id=1
2015-06 16 11:32:42  
tabla :persona
	SELECT * FROM persona where id=101
2015-06 16 11:32:42  
Continuar(s,163,280,)
	EjecutarTarea_163() Concurso musica campesina id_comp1229
				51  51
		ValidarUsuario(163):1
			EjecutarPaso_280: form:29 , caso=50 id_comp 1229
				Paso::Guardar(Caso:50)
					Datos a guardar:
						Array
						(
						    [wf_proceso_id] => 87
						    [wf_paso_id] => 280
						    [wf_tarea_id] => 163
						    [wf_caso_id] => 50
						    [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-16
						    [433] => 2
						    [434] => GENOY
						    [435] => LA PLAYA
						    [436] => GUAMATAN
						    [439] => JAMES FIGUEROA
						    [440] => 1096548732
						    [441] => PASTO
						    [442] => 2030-10-30
						    [443] => Bogota
						    [444] => mz g cs 33
						    [445] => 7201245
						    [hdcampo446] => 31
						    [446] => [{"oid":"","txttit":"noche de luna","txtritmo":"pop","form_master_escribir_xxx":"31"},{"oid":"","txttit":"lenguaje de piel","txtritmo":"pop","form_master_escribir_xxx":"31"}]
						    [hdcampo447] => 30
						    [447] => [{"oid":null,"txtnomi":"Milena Cifuentes","txtedad":22,"txtdoci":1054475,"form_master_escribir_xxx":"30"}]
						)
						
					OID: 16
					rta: 1 dato:16 tabla:sce.t29 
					CasoPaso:214
				CargarDatos_280(16)
							se carga 87_163_280_29_32_447Array
							se carga 87_163_280_29_32_446Array
							se carga 87_163_280_29_32_4457201245
							se carga 87_163_280_29_32_444mz g cs 33
							se carga 87_163_280_29_32_443Bogota
							se carga 87_163_280_29_32_4422030-10-30
							se carga 87_163_280_29_32_441PASTO
							se carga 87_163_280_29_32_4401096548732
							se carga 87_163_280_29_32_439JAMES FIGUEROA
							se carga 87_163_280_29_32_438
							se carga 87_163_280_29_32_437
							se carga 87_163_280_29_32_436GUAMATAN
							se carga 87_163_280_29_32_435LA PLAYA
							se carga 87_163_280_29_32_434GENOY
							se carga 87_163_280_29_32_4332
							se carga 87_163_280_29_32_4322015-06-16
				SiguientePasoDe280: Funcion para ejecutar el siguiente paso 
			EjecutarPaso_282: ladj:117 , caso=50 id_comp 1229
				Mostrar ladj
	Retorno :
	Array
	(
	    [ret] => inicioComponente_WF_ladj({"tarea_id":163,"paso_id":282,"id":"1229","proceso_id":87,"caso_id":"50","sujeto_id":"101","ladj":117});
	    [suc] => 1
	)
	
 fin 2015-06-16  11:32:42
/******************************************************************************************************/

2015-06-16 11:33:22TraerCaso(50,87,)
 CargarCaso :50
2015-06 16 11:33:22  
CargarDatos: Caso :50
	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":"213","id":"213","1":"277","wf_paso_id":"277","2":"186","wf_caso_87_seguimiento_id":"186","3":"51","core_usuario_id":"51","4":"2015-06-16 11:18:57","fecha_ejec":"2015-06-16 11:18:57","5":"50","dato":"50","6":"sce.t33","tabla":"sce.t33","7":"162","tarea_id":"162","8":"Ruano Marcela: ciudadano","usr_ejec":"Ruano Marcela: ciudadano"}
				CargarDatos_277(50)
							se carga 87_162_277_33_34_4511
			{"0":"214","id":"214","1":"280","wf_paso_id":"280","2":"187","wf_caso_87_seguimiento_id":"187","3":"51","core_usuario_id":"51","4":"2015-06-16 11:32:42","fecha_ejec":"2015-06-16 11:32:42","5":"16","dato":"16","6":"sce.t29","tabla":"sce.t29","7":"163","tarea_id":"163","8":"Ruano Marcela: ciudadano","usr_ejec":"Ruano Marcela: ciudadano"}
				CargarDatos_280(16)
							se carga 87_163_280_29_32_447Array
							se carga 87_163_280_29_32_446Array
							se carga 87_163_280_29_32_4457201245
							se carga 87_163_280_29_32_444mz g cs 33
							se carga 87_163_280_29_32_443Bogota
							se carga 87_163_280_29_32_4422030-10-30
							se carga 87_163_280_29_32_441PASTO
							se carga 87_163_280_29_32_4401096548732
							se carga 87_163_280_29_32_439JAMES FIGUEROA
							se carga 87_163_280_29_32_438
							se carga 87_163_280_29_32_437
							se carga 87_163_280_29_32_436GUAMATAN
							se carga 87_163_280_29_32_435LA PLAYA
							se carga 87_163_280_29_32_434GENOY
							se carga 87_163_280_29_32_4332
							se carga 87_163_280_29_32_4322015-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":"186","id":"186","1":"50","wf_caso_87_id":"50","2":"162","wf_tarea_id":"162","3":null,"core_usuario_id":null,"4":"2015-06-16 11:18:52","fec_asig":"2015-06-16 11:18:52","5":"51","core_usuario_id_resol":"51","6":"2015-06-16 11:18:57","fec_resol":"2015-06-16 11:18:57","7":"162","wf_tarea_id_sig":"162","8":null,"usr_asig":null,"9":"Ruano Marcela: ciudadano","usr_resol":"Ruano Marcela: ciudadano"}
			{"0":"187","id":"187","1":"50","wf_caso_87_id":"50","2":"163","wf_tarea_id":"163","3":"51","core_usuario_id":"51","4":"2015-06-16 11:18:57","fec_asig":"2015-06-16 11:18:57","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 16 11:33:22  
cargar datos del sujeto(,,s,87,50)
	
				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=50 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:33:22  
tabla dat adic
	select tabla from core_sujetoverificaciontipo where id=1
2015-06 16 11:33:22  
tabla :persona
	SELECT * FROM persona where id=101
2015-06 16 11:33:22  
Continuar(s,163,282,)
	EjecutarTarea_163() Concurso musica campesina id_comp1229
				51  51
		ValidarUsuario(163):1
			EjecutarPaso_282: ladj:117 , caso=50 id_comp 1229
				Paso::Guardar(Caso:50)
					rta: 1 dato:6015 tabla:wf_documentoentradaadj_caso 
					CasoPaso:215
				CargarDatos_282(6015)
				SiguientePasoDe282: Funcion para ejecutar el siguiente paso 
			EjecutarPaso_283: corr:102 , caso=50 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 tramite .
					{ WFSV_1 }
					TWFSV_1:myriabe123@gmail.com
					Registro exitoso música campesina
	Retorno :
	Array
	(
	    [ret] => inicioComponente_WF_Correo({"id":"1229","caso_id":"50","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>50<\/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 tramite .<\/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-16  11:33:22
/******************************************************************************************************/

2015-06-16 11:33:32TraerCaso(50,87,)
 CargarCaso :50
2015-06 16 11:33:32  
CargarDatos: Caso :50
	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":"213","id":"213","1":"277","wf_paso_id":"277","2":"186","wf_caso_87_seguimiento_id":"186","3":"51","core_usuario_id":"51","4":"2015-06-16 11:18:57","fecha_ejec":"2015-06-16 11:18:57","5":"50","dato":"50","6":"sce.t33","tabla":"sce.t33","7":"162","tarea_id":"162","8":"Ruano Marcela: ciudadano","usr_ejec":"Ruano Marcela: ciudadano"}
				CargarDatos_277(50)
							se carga 87_162_277_33_34_4511
			{"0":"214","id":"214","1":"280","wf_paso_id":"280","2":"187","wf_caso_87_seguimiento_id":"187","3":"51","core_usuario_id":"51","4":"2015-06-16 11:32:42","fecha_ejec":"2015-06-16 11:32:42","5":"16","dato":"16","6":"sce.t29","tabla":"sce.t29","7":"163","tarea_id":"163","8":"Ruano Marcela: ciudadano","usr_ejec":"Ruano Marcela: ciudadano"}
				CargarDatos_280(16)
							se carga 87_163_280_29_32_447Array
							se carga 87_163_280_29_32_446Array
							se carga 87_163_280_29_32_4457201245
							se carga 87_163_280_29_32_444mz g cs 33
							se carga 87_163_280_29_32_443Bogota
							se carga 87_163_280_29_32_4422030-10-30
							se carga 87_163_280_29_32_441PASTO
							se carga 87_163_280_29_32_4401096548732
							se carga 87_163_280_29_32_439JAMES FIGUEROA
							se carga 87_163_280_29_32_438
							se carga 87_163_280_29_32_437
							se carga 87_163_280_29_32_436GUAMATAN
							se carga 87_163_280_29_32_435LA PLAYA
							se carga 87_163_280_29_32_434GENOY
							se carga 87_163_280_29_32_4332
							se carga 87_163_280_29_32_4322015-06-16
			{"0":"215","id":"215","1":"282","wf_paso_id":"282","2":"187","wf_caso_87_seguimiento_id":"187","3":"51","core_usuario_id":"51","4":"2015-06-16 11:33:22","fecha_ejec":"2015-06-16 11:33:22","5":"6015","dato":"6015","6":"wf_documentoentradaadj_caso","tabla":"wf_documentoentradaadj_caso","7":"163","tarea_id":"163","8":"Ruano Marcela: ciudadano","usr_ejec":"Ruano Marcela: ciudadano"}
				CargarDatos_282(6015)
	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":"186","id":"186","1":"50","wf_caso_87_id":"50","2":"162","wf_tarea_id":"162","3":null,"core_usuario_id":null,"4":"2015-06-16 11:18:52","fec_asig":"2015-06-16 11:18:52","5":"51","core_usuario_id_resol":"51","6":"2015-06-16 11:18:57","fec_resol":"2015-06-16 11:18:57","7":"162","wf_tarea_id_sig":"162","8":null,"usr_asig":null,"9":"Ruano Marcela: ciudadano","usr_resol":"Ruano Marcela: ciudadano"}
			{"0":"187","id":"187","1":"50","wf_caso_87_id":"50","2":"163","wf_tarea_id":"163","3":"51","core_usuario_id":"51","4":"2015-06-16 11:18:57","fec_asig":"2015-06-16 11:18:57","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 16 11:33:32  
cargar datos del sujeto(,,s,87,50)
	
				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=50 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:33:32  
tabla dat adic
	select tabla from core_sujetoverificaciontipo where id=1
2015-06 16 11:33:32  
tabla :persona
	SELECT * FROM persona where id=101
2015-06 16 11:33:32  
Continuar(s,163,283,)
	EjecutarTarea_163() Concurso musica campesina id_comp1229
				51  51
		ValidarUsuario(163):1
			EjecutarPaso_283: corr:102 , caso=50 id_comp 1229
				Paso::Guardar(Caso:50)
					rta: 1 dato: tabla: 
					CasoPaso:216
				CargarDatos_283()
				SiguientePasoDe283: Funcion para ejecutar el siguiente paso 
			Condicion Tarea : true
		TerminarTarea(163,168)
			Ultimo seg :187 
			Ultimo seg :188 
	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-16  11:33:32
/******************************************************************************************************/

2015-06-30 17:48:47TraerCaso(50,87,)
 CargarCaso :50
2015-06 30 17:48:47  
CargarDatos: Caso :50
	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":"213","id":"213","1":"277","wf_paso_id":"277","2":"186","wf_caso_87_seguimiento_id":"186","3":"51","core_usuario_id":"51","4":"2015-06-16 11:18:57","fecha_ejec":"2015-06-16 11:18:57","5":"50","dato":"50","6":"sce.t33","tabla":"sce.t33","7":"162","tarea_id":"162","8":"Ruano Marcela: ciudadano","usr_ejec":"Ruano Marcela: ciudadano"}
				CargarDatos_277(50)
							se carga 87_162_277_33_34_4511
			{"0":"214","id":"214","1":"280","wf_paso_id":"280","2":"187","wf_caso_87_seguimiento_id":"187","3":"51","core_usuario_id":"51","4":"2015-06-16 11:32:42","fecha_ejec":"2015-06-16 11:32:42","5":"16","dato":"16","6":"sce.t29","tabla":"sce.t29","7":"163","tarea_id":"163","8":"Ruano Marcela: ciudadano","usr_ejec":"Ruano Marcela: ciudadano"}
				CargarDatos_280(16)
							se carga 87_163_280_29_32_447Array
							se carga 87_163_280_29_32_446Array
							se carga 87_163_280_29_32_4457201245
							se carga 87_163_280_29_32_444mz g cs 33
							se carga 87_163_280_29_32_443Bogota
							se carga 87_163_280_29_32_4422030-10-30
							se carga 87_163_280_29_32_441PASTO
							se carga 87_163_280_29_32_4401096548732
							se carga 87_163_280_29_32_439JAMES FIGUEROA
							se carga 87_163_280_29_32_438
							se carga 87_163_280_29_32_437
							se carga 87_163_280_29_32_436GUAMATAN
							se carga 87_163_280_29_32_435LA PLAYA
							se carga 87_163_280_29_32_434GENOY
							se carga 87_163_280_29_32_4332
							se carga 87_163_280_29_32_4322015-06-16
			{"0":"215","id":"215","1":"282","wf_paso_id":"282","2":"187","wf_caso_87_seguimiento_id":"187","3":"51","core_usuario_id":"51","4":"2015-06-16 11:33:22","fecha_ejec":"2015-06-16 11:33:22","5":"6015","dato":"6015","6":"wf_documentoentradaadj_caso","tabla":"wf_documentoentradaadj_caso","7":"163","tarea_id":"163","8":"Ruano Marcela: ciudadano","usr_ejec":"Ruano Marcela: ciudadano"}
				CargarDatos_282(6015)
			{"0":"216","id":"216","1":"283","wf_paso_id":"283","2":"187","wf_caso_87_seguimiento_id":"187","3":"51","core_usuario_id":"51","4":"2015-06-16 11:33:32","fecha_ejec":"2015-06-16 11:33:32","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":"186","id":"186","1":"50","wf_caso_87_id":"50","2":"162","wf_tarea_id":"162","3":null,"core_usuario_id":null,"4":"2015-06-16 11:18:52","fec_asig":"2015-06-16 11:18:52","5":"51","core_usuario_id_resol":"51","6":"2015-06-16 11:18:57","fec_resol":"2015-06-16 11:18:57","7":"162","wf_tarea_id_sig":"162","8":null,"usr_asig":null,"9":"Ruano Marcela: ciudadano","usr_resol":"Ruano Marcela: ciudadano"}
			{"0":"187","id":"187","1":"50","wf_caso_87_id":"50","2":"163","wf_tarea_id":"163","3":"51","core_usuario_id":"51","4":"2015-06-16 11:18:57","fec_asig":"2015-06-16 11:18:57","5":"51","core_usuario_id_resol":"51","6":"2015-06-16 11:33:32","fec_resol":"2015-06-16 11:33:32","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":"188","id":"188","1":"50","wf_caso_87_id":"50","2":"168","wf_tarea_id":"168","3":null,"core_usuario_id":null,"4":"2015-06-16 11:33:32","fec_asig":"2015-06-16 11:33:32","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-06 30 17:48:47  
cargar datos del sujeto(,,s,87,50)
	
				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=50 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:48:47  
tabla dat adic
	select tabla from core_sujetoverificaciontipo where id=1
2015-06 30 17:48:47  
tabla :persona
	SELECT * FROM persona where id=101
2015-06 30 17:48:47  
Continuar(,168,,s)
	EjecutarTarea_168() Verificacion musica campesina id_comp1232
				  59
		ValidarUsuario(168):1
			EjecutarPaso_287: vadj:117 , caso=50 id_comp 1232
				Mostrar vadj
	Retorno :
	Array
	(
	    [ret] => inicioComponente_WF_vadj({"tarea_id":168,"paso_id":287,"id":"1232","proceso_id":87,"caso_id":"50","sujeto_id":"101","vadj":117});
	    [suc] => 1
	)
	
 fin 2015-06-30  17:48:47
/******************************************************************************************************/

2015-06-30 17:49:50TraerCaso(50,87,)
 CargarCaso :50
2015-06 30 17:49:50  
CargarDatos: Caso :50
	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":"213","id":"213","1":"277","wf_paso_id":"277","2":"186","wf_caso_87_seguimiento_id":"186","3":"51","core_usuario_id":"51","4":"2015-06-16 11:18:57","fecha_ejec":"2015-06-16 11:18:57","5":"50","dato":"50","6":"sce.t33","tabla":"sce.t33","7":"162","tarea_id":"162","8":"Ruano Marcela: ciudadano","usr_ejec":"Ruano Marcela: ciudadano"}
				CargarDatos_277(50)
							se carga 87_162_277_33_34_4511
			{"0":"214","id":"214","1":"280","wf_paso_id":"280","2":"187","wf_caso_87_seguimiento_id":"187","3":"51","core_usuario_id":"51","4":"2015-06-16 11:32:42","fecha_ejec":"2015-06-16 11:32:42","5":"16","dato":"16","6":"sce.t29","tabla":"sce.t29","7":"163","tarea_id":"163","8":"Ruano Marcela: ciudadano","usr_ejec":"Ruano Marcela: ciudadano"}
				CargarDatos_280(16)
							se carga 87_163_280_29_32_447Array
							se carga 87_163_280_29_32_446Array
							se carga 87_163_280_29_32_4457201245
							se carga 87_163_280_29_32_444mz g cs 33
							se carga 87_163_280_29_32_443Bogota
							se carga 87_163_280_29_32_4422030-10-30
							se carga 87_163_280_29_32_441PASTO
							se carga 87_163_280_29_32_4401096548732
							se carga 87_163_280_29_32_439JAMES FIGUEROA
							se carga 87_163_280_29_32_438
							se carga 87_163_280_29_32_437
							se carga 87_163_280_29_32_436GUAMATAN
							se carga 87_163_280_29_32_435LA PLAYA
							se carga 87_163_280_29_32_434GENOY
							se carga 87_163_280_29_32_4332
							se carga 87_163_280_29_32_4322015-06-16
			{"0":"215","id":"215","1":"282","wf_paso_id":"282","2":"187","wf_caso_87_seguimiento_id":"187","3":"51","core_usuario_id":"51","4":"2015-06-16 11:33:22","fecha_ejec":"2015-06-16 11:33:22","5":"6015","dato":"6015","6":"wf_documentoentradaadj_caso","tabla":"wf_documentoentradaadj_caso","7":"163","tarea_id":"163","8":"Ruano Marcela: ciudadano","usr_ejec":"Ruano Marcela: ciudadano"}
				CargarDatos_282(6015)
			{"0":"216","id":"216","1":"283","wf_paso_id":"283","2":"187","wf_caso_87_seguimiento_id":"187","3":"51","core_usuario_id":"51","4":"2015-06-16 11:33:32","fecha_ejec":"2015-06-16 11:33:32","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":"186","id":"186","1":"50","wf_caso_87_id":"50","2":"162","wf_tarea_id":"162","3":null,"core_usuario_id":null,"4":"2015-06-16 11:18:52","fec_asig":"2015-06-16 11:18:52","5":"51","core_usuario_id_resol":"51","6":"2015-06-16 11:18:57","fec_resol":"2015-06-16 11:18:57","7":"162","wf_tarea_id_sig":"162","8":null,"usr_asig":null,"9":"Ruano Marcela: ciudadano","usr_resol":"Ruano Marcela: ciudadano"}
			{"0":"187","id":"187","1":"50","wf_caso_87_id":"50","2":"163","wf_tarea_id":"163","3":"51","core_usuario_id":"51","4":"2015-06-16 11:18:57","fec_asig":"2015-06-16 11:18:57","5":"51","core_usuario_id_resol":"51","6":"2015-06-16 11:33:32","fec_resol":"2015-06-16 11:33:32","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":"188","id":"188","1":"50","wf_caso_87_id":"50","2":"168","wf_tarea_id":"168","3":null,"core_usuario_id":null,"4":"2015-06-16 11:33:32","fec_asig":"2015-06-16 11:33:32","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-06 30 17:49:50  
cargar datos del sujeto(,,s,87,50)
	
				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=50 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:49:50  
tabla dat adic
	select tabla from core_sujetoverificaciontipo where id=1
2015-06 30 17:49:50  
tabla :persona
	SELECT * FROM persona where id=101
2015-06 30 17:49:50  
Continuar(,168,,s)
	EjecutarTarea_168() Verificacion musica campesina id_comp1232
				  59
		ValidarUsuario(168):1
			EjecutarPaso_287: vadj:117 , caso=50 id_comp 1232
				Mostrar vadj
	Retorno :
	Array
	(
	    [ret] => inicioComponente_WF_vadj({"tarea_id":168,"paso_id":287,"id":"1232","proceso_id":87,"caso_id":"50","sujeto_id":"101","vadj":117});
	    [suc] => 1
	)
	
 fin 2015-06-30  17:49:50
/******************************************************************************************************/

2015-07-01 12:50:06TraerCaso(50,87,)
 CargarCaso :50
2015-07 01 12:50:06  
CargarDatos: Caso :50
	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":"213","id":"213","1":"277","wf_paso_id":"277","2":"186","wf_caso_87_seguimiento_id":"186","3":"51","core_usuario_id":"51","4":"2015-06-16 11:18:57","fecha_ejec":"2015-06-16 11:18:57","5":"50","dato":"50","6":"sce.t33","tabla":"sce.t33","7":"162","tarea_id":"162","8":"Ruano Marcela: ciudadano","usr_ejec":"Ruano Marcela: ciudadano"}
				CargarDatos_277(50)
							se carga 87_162_277_33_34_4511
			{"0":"214","id":"214","1":"280","wf_paso_id":"280","2":"187","wf_caso_87_seguimiento_id":"187","3":"51","core_usuario_id":"51","4":"2015-06-16 11:32:42","fecha_ejec":"2015-06-16 11:32:42","5":"16","dato":"16","6":"sce.t29","tabla":"sce.t29","7":"163","tarea_id":"163","8":"Ruano Marcela: ciudadano","usr_ejec":"Ruano Marcela: ciudadano"}
				CargarDatos_280(16)
							se carga 87_163_280_29_32_447Array
							se carga 87_163_280_29_32_446Array
							se carga 87_163_280_29_32_4457201245
							se carga 87_163_280_29_32_444mz g cs 33
							se carga 87_163_280_29_32_443Bogota
							se carga 87_163_280_29_32_4422030-10-30
							se carga 87_163_280_29_32_441PASTO
							se carga 87_163_280_29_32_4401096548732
							se carga 87_163_280_29_32_439JAMES FIGUEROA
							se carga 87_163_280_29_32_438
							se carga 87_163_280_29_32_437
							se carga 87_163_280_29_32_436GUAMATAN
							se carga 87_163_280_29_32_435LA PLAYA
							se carga 87_163_280_29_32_434GENOY
							se carga 87_163_280_29_32_4332
							se carga 87_163_280_29_32_4322015-06-16
			{"0":"215","id":"215","1":"282","wf_paso_id":"282","2":"187","wf_caso_87_seguimiento_id":"187","3":"51","core_usuario_id":"51","4":"2015-06-16 11:33:22","fecha_ejec":"2015-06-16 11:33:22","5":"6015","dato":"6015","6":"wf_documentoentradaadj_caso","tabla":"wf_documentoentradaadj_caso","7":"163","tarea_id":"163","8":"Ruano Marcela: ciudadano","usr_ejec":"Ruano Marcela: ciudadano"}
				CargarDatos_282(6015)
			{"0":"216","id":"216","1":"283","wf_paso_id":"283","2":"187","wf_caso_87_seguimiento_id":"187","3":"51","core_usuario_id":"51","4":"2015-06-16 11:33:32","fecha_ejec":"2015-06-16 11:33:32","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":"186","id":"186","1":"50","wf_caso_87_id":"50","2":"162","wf_tarea_id":"162","3":null,"core_usuario_id":null,"4":"2015-06-16 11:18:52","fec_asig":"2015-06-16 11:18:52","5":"51","core_usuario_id_resol":"51","6":"2015-06-16 11:18:57","fec_resol":"2015-06-16 11:18:57","7":"162","wf_tarea_id_sig":"162","8":null,"usr_asig":null,"9":"Ruano Marcela: ciudadano","usr_resol":"Ruano Marcela: ciudadano"}
			{"0":"187","id":"187","1":"50","wf_caso_87_id":"50","2":"163","wf_tarea_id":"163","3":"51","core_usuario_id":"51","4":"2015-06-16 11:18:57","fec_asig":"2015-06-16 11:18:57","5":"51","core_usuario_id_resol":"51","6":"2015-06-16 11:33:32","fec_resol":"2015-06-16 11:33:32","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":"188","id":"188","1":"50","wf_caso_87_id":"50","2":"168","wf_tarea_id":"168","3":null,"core_usuario_id":null,"4":"2015-06-16 11:33:32","fec_asig":"2015-06-16 11:33:32","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:50:06  
cargar datos del sujeto(,,s,87,50)
	
				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=50 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:50:06  
tabla dat adic
	select tabla from core_sujetoverificaciontipo where id=1
2015-07 01 12:50:06  
tabla :persona
	SELECT * FROM persona where id=101
2015-07 01 12:50:06  
Continuar(,168,,s)
	EjecutarTarea_168() Verificacion musica campesina id_comp1232
				  59
		ValidarUsuario(168):1
			EjecutarPaso_287: vadj:117 , caso=50 id_comp 1232
				Mostrar vadj
	Retorno :
	Array
	(
	    [ret] => inicioComponente_WF_vadj({"tarea_id":168,"paso_id":287,"id":"1232","proceso_id":87,"caso_id":"50","sujeto_id":"101","vadj":117});
	    [suc] => 1
	)
	
 fin 2015-07-01  12:50:06
/******************************************************************************************************/

2015-07-01 12:50:13TraerCaso(50,87,)
 CargarCaso :50
2015-07 01 12:50:13  
CargarDatos: Caso :50
	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":"213","id":"213","1":"277","wf_paso_id":"277","2":"186","wf_caso_87_seguimiento_id":"186","3":"51","core_usuario_id":"51","4":"2015-06-16 11:18:57","fecha_ejec":"2015-06-16 11:18:57","5":"50","dato":"50","6":"sce.t33","tabla":"sce.t33","7":"162","tarea_id":"162","8":"Ruano Marcela: ciudadano","usr_ejec":"Ruano Marcela: ciudadano"}
				CargarDatos_277(50)
							se carga 87_162_277_33_34_4511
			{"0":"214","id":"214","1":"280","wf_paso_id":"280","2":"187","wf_caso_87_seguimiento_id":"187","3":"51","core_usuario_id":"51","4":"2015-06-16 11:32:42","fecha_ejec":"2015-06-16 11:32:42","5":"16","dato":"16","6":"sce.t29","tabla":"sce.t29","7":"163","tarea_id":"163","8":"Ruano Marcela: ciudadano","usr_ejec":"Ruano Marcela: ciudadano"}
				CargarDatos_280(16)
							se carga 87_163_280_29_32_447Array
							se carga 87_163_280_29_32_446Array
							se carga 87_163_280_29_32_4457201245
							se carga 87_163_280_29_32_444mz g cs 33
							se carga 87_163_280_29_32_443Bogota
							se carga 87_163_280_29_32_4422030-10-30
							se carga 87_163_280_29_32_441PASTO
							se carga 87_163_280_29_32_4401096548732
							se carga 87_163_280_29_32_439JAMES FIGUEROA
							se carga 87_163_280_29_32_438
							se carga 87_163_280_29_32_437
							se carga 87_163_280_29_32_436GUAMATAN
							se carga 87_163_280_29_32_435LA PLAYA
							se carga 87_163_280_29_32_434GENOY
							se carga 87_163_280_29_32_4332
							se carga 87_163_280_29_32_4322015-06-16
			{"0":"215","id":"215","1":"282","wf_paso_id":"282","2":"187","wf_caso_87_seguimiento_id":"187","3":"51","core_usuario_id":"51","4":"2015-06-16 11:33:22","fecha_ejec":"2015-06-16 11:33:22","5":"6015","dato":"6015","6":"wf_documentoentradaadj_caso","tabla":"wf_documentoentradaadj_caso","7":"163","tarea_id":"163","8":"Ruano Marcela: ciudadano","usr_ejec":"Ruano Marcela: ciudadano"}
				CargarDatos_282(6015)
			{"0":"216","id":"216","1":"283","wf_paso_id":"283","2":"187","wf_caso_87_seguimiento_id":"187","3":"51","core_usuario_id":"51","4":"2015-06-16 11:33:32","fecha_ejec":"2015-06-16 11:33:32","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":"186","id":"186","1":"50","wf_caso_87_id":"50","2":"162","wf_tarea_id":"162","3":null,"core_usuario_id":null,"4":"2015-06-16 11:18:52","fec_asig":"2015-06-16 11:18:52","5":"51","core_usuario_id_resol":"51","6":"2015-06-16 11:18:57","fec_resol":"2015-06-16 11:18:57","7":"162","wf_tarea_id_sig":"162","8":null,"usr_asig":null,"9":"Ruano Marcela: ciudadano","usr_resol":"Ruano Marcela: ciudadano"}
			{"0":"187","id":"187","1":"50","wf_caso_87_id":"50","2":"163","wf_tarea_id":"163","3":"51","core_usuario_id":"51","4":"2015-06-16 11:18:57","fec_asig":"2015-06-16 11:18:57","5":"51","core_usuario_id_resol":"51","6":"2015-06-16 11:33:32","fec_resol":"2015-06-16 11:33:32","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":"188","id":"188","1":"50","wf_caso_87_id":"50","2":"168","wf_tarea_id":"168","3":null,"core_usuario_id":null,"4":"2015-06-16 11:33:32","fec_asig":"2015-06-16 11:33:32","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:50:13  
cargar datos del sujeto(,,s,87,50)
	
				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=50 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:50:13  
tabla dat adic
	select tabla from core_sujetoverificaciontipo where id=1
2015-07 01 12:50:13  
tabla :persona
	SELECT * FROM persona where id=101
2015-07 01 12:50:13  
Continuar(,168,,s)
	EjecutarTarea_168() Verificacion musica campesina id_comp1232
				  38
		ValidarUsuario(168):1
			EjecutarPaso_287: vadj:117 , caso=50 id_comp 1232
				Mostrar vadj
	Retorno :
	Array
	(
	    [ret] => inicioComponente_WF_vadj({"tarea_id":168,"paso_id":287,"id":"1232","proceso_id":87,"caso_id":"50","sujeto_id":"101","vadj":117});
	    [suc] => 1
	)
	
 fin 2015-07-01  12:50:13
/******************************************************************************************************/

2015-07-01 12:50:17TraerCaso(50,87,)
 CargarCaso :50
2015-07 01 12:50:17  
CargarDatos: Caso :50
	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":"213","id":"213","1":"277","wf_paso_id":"277","2":"186","wf_caso_87_seguimiento_id":"186","3":"51","core_usuario_id":"51","4":"2015-06-16 11:18:57","fecha_ejec":"2015-06-16 11:18:57","5":"50","dato":"50","6":"sce.t33","tabla":"sce.t33","7":"162","tarea_id":"162","8":"Ruano Marcela: ciudadano","usr_ejec":"Ruano Marcela: ciudadano"}
				CargarDatos_277(50)
							se carga 87_162_277_33_34_4511
			{"0":"214","id":"214","1":"280","wf_paso_id":"280","2":"187","wf_caso_87_seguimiento_id":"187","3":"51","core_usuario_id":"51","4":"2015-06-16 11:32:42","fecha_ejec":"2015-06-16 11:32:42","5":"16","dato":"16","6":"sce.t29","tabla":"sce.t29","7":"163","tarea_id":"163","8":"Ruano Marcela: ciudadano","usr_ejec":"Ruano Marcela: ciudadano"}
				CargarDatos_280(16)
							se carga 87_163_280_29_32_447Array
							se carga 87_163_280_29_32_446Array
							se carga 87_163_280_29_32_4457201245
							se carga 87_163_280_29_32_444mz g cs 33
							se carga 87_163_280_29_32_443Bogota
							se carga 87_163_280_29_32_4422030-10-30
							se carga 87_163_280_29_32_441PASTO
							se carga 87_163_280_29_32_4401096548732
							se carga 87_163_280_29_32_439JAMES FIGUEROA
							se carga 87_163_280_29_32_438
							se carga 87_163_280_29_32_437
							se carga 87_163_280_29_32_436GUAMATAN
							se carga 87_163_280_29_32_435LA PLAYA
							se carga 87_163_280_29_32_434GENOY
							se carga 87_163_280_29_32_4332
							se carga 87_163_280_29_32_4322015-06-16
			{"0":"215","id":"215","1":"282","wf_paso_id":"282","2":"187","wf_caso_87_seguimiento_id":"187","3":"51","core_usuario_id":"51","4":"2015-06-16 11:33:22","fecha_ejec":"2015-06-16 11:33:22","5":"6015","dato":"6015","6":"wf_documentoentradaadj_caso","tabla":"wf_documentoentradaadj_caso","7":"163","tarea_id":"163","8":"Ruano Marcela: ciudadano","usr_ejec":"Ruano Marcela: ciudadano"}
				CargarDatos_282(6015)
			{"0":"216","id":"216","1":"283","wf_paso_id":"283","2":"187","wf_caso_87_seguimiento_id":"187","3":"51","core_usuario_id":"51","4":"2015-06-16 11:33:32","fecha_ejec":"2015-06-16 11:33:32","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":"186","id":"186","1":"50","wf_caso_87_id":"50","2":"162","wf_tarea_id":"162","3":null,"core_usuario_id":null,"4":"2015-06-16 11:18:52","fec_asig":"2015-06-16 11:18:52","5":"51","core_usuario_id_resol":"51","6":"2015-06-16 11:18:57","fec_resol":"2015-06-16 11:18:57","7":"162","wf_tarea_id_sig":"162","8":null,"usr_asig":null,"9":"Ruano Marcela: ciudadano","usr_resol":"Ruano Marcela: ciudadano"}
			{"0":"187","id":"187","1":"50","wf_caso_87_id":"50","2":"163","wf_tarea_id":"163","3":"51","core_usuario_id":"51","4":"2015-06-16 11:18:57","fec_asig":"2015-06-16 11:18:57","5":"51","core_usuario_id_resol":"51","6":"2015-06-16 11:33:32","fec_resol":"2015-06-16 11:33:32","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":"188","id":"188","1":"50","wf_caso_87_id":"50","2":"168","wf_tarea_id":"168","3":null,"core_usuario_id":null,"4":"2015-06-16 11:33:32","fec_asig":"2015-06-16 11:33:32","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:50:17  
cargar datos del sujeto(,,s,87,50)
	
				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=50 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:50:17  
tabla dat adic
	select tabla from core_sujetoverificaciontipo where id=1
2015-07 01 12:50:17  
tabla :persona
	SELECT * FROM persona where id=101
2015-07 01 12:50:17  
Continuar(s,168,287,)
	EjecutarTarea_168() Verificacion musica campesina id_comp1232
				  59
		ValidarUsuario(168):1
			EjecutarPaso_287: vadj:117 , caso=50 id_comp 1232
				Paso::Guardar(Caso:50)
					rta: 1 dato:2548 tabla:wf_documentoentradaadj_caso 
					CasoPaso:282
				CargarDatos_287(2548)
				SiguientePasoDe287: Funcion para ejecutar el siguiente paso 
			Condicion Tarea :  Si =="Si"
		TerminarTarea(168,169)
			Ultimo seg :188 
			Ultimo seg :257 
	EjecutarTarea_169() Inscripcion exitosa musica campesina id_comp1232
				59  59
		ValidarUsuario(169):1
			EjecutarPaso_291: corr:107 , caso=50 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":"50","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>50<\/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:50:17
/******************************************************************************************************/

2015-07-01 12:50:27TraerCaso(50,87,)
 CargarCaso :50
2015-07 01 12:50:27  
CargarDatos: Caso :50
	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":"213","id":"213","1":"277","wf_paso_id":"277","2":"186","wf_caso_87_seguimiento_id":"186","3":"51","core_usuario_id":"51","4":"2015-06-16 11:18:57","fecha_ejec":"2015-06-16 11:18:57","5":"50","dato":"50","6":"sce.t33","tabla":"sce.t33","7":"162","tarea_id":"162","8":"Ruano Marcela: ciudadano","usr_ejec":"Ruano Marcela: ciudadano"}
				CargarDatos_277(50)
							se carga 87_162_277_33_34_4511
			{"0":"214","id":"214","1":"280","wf_paso_id":"280","2":"187","wf_caso_87_seguimiento_id":"187","3":"51","core_usuario_id":"51","4":"2015-06-16 11:32:42","fecha_ejec":"2015-06-16 11:32:42","5":"16","dato":"16","6":"sce.t29","tabla":"sce.t29","7":"163","tarea_id":"163","8":"Ruano Marcela: ciudadano","usr_ejec":"Ruano Marcela: ciudadano"}
				CargarDatos_280(16)
							se carga 87_163_280_29_32_447Array
							se carga 87_163_280_29_32_446Array
							se carga 87_163_280_29_32_4457201245
							se carga 87_163_280_29_32_444mz g cs 33
							se carga 87_163_280_29_32_443Bogota
							se carga 87_163_280_29_32_4422030-10-30
							se carga 87_163_280_29_32_441PASTO
							se carga 87_163_280_29_32_4401096548732
							se carga 87_163_280_29_32_439JAMES FIGUEROA
							se carga 87_163_280_29_32_438
							se carga 87_163_280_29_32_437
							se carga 87_163_280_29_32_436GUAMATAN
							se carga 87_163_280_29_32_435LA PLAYA
							se carga 87_163_280_29_32_434GENOY
							se carga 87_163_280_29_32_4332
							se carga 87_163_280_29_32_4322015-06-16
			{"0":"215","id":"215","1":"282","wf_paso_id":"282","2":"187","wf_caso_87_seguimiento_id":"187","3":"51","core_usuario_id":"51","4":"2015-06-16 11:33:22","fecha_ejec":"2015-06-16 11:33:22","5":"6015","dato":"6015","6":"wf_documentoentradaadj_caso","tabla":"wf_documentoentradaadj_caso","7":"163","tarea_id":"163","8":"Ruano Marcela: ciudadano","usr_ejec":"Ruano Marcela: ciudadano"}
				CargarDatos_282(6015)
			{"0":"216","id":"216","1":"283","wf_paso_id":"283","2":"187","wf_caso_87_seguimiento_id":"187","3":"51","core_usuario_id":"51","4":"2015-06-16 11:33:32","fecha_ejec":"2015-06-16 11:33:32","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":"282","id":"282","1":"287","wf_paso_id":"287","2":"188","wf_caso_87_seguimiento_id":"188","3":"59","core_usuario_id":"59","4":"2015-07-01 12:50:17","fecha_ejec":"2015-07-01 12:50:17","5":"2548","dato":"2548","6":"wf_documentoentradaadj_caso","tabla":"wf_documentoentradaadj_caso","7":"168","tarea_id":"168","8":"bb pp: gerente","usr_ejec":"bb pp: gerente"}
				CargarDatos_287(2548)
	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":"186","id":"186","1":"50","wf_caso_87_id":"50","2":"162","wf_tarea_id":"162","3":null,"core_usuario_id":null,"4":"2015-06-16 11:18:52","fec_asig":"2015-06-16 11:18:52","5":"51","core_usuario_id_resol":"51","6":"2015-06-16 11:18:57","fec_resol":"2015-06-16 11:18:57","7":"162","wf_tarea_id_sig":"162","8":null,"usr_asig":null,"9":"Ruano Marcela: ciudadano","usr_resol":"Ruano Marcela: ciudadano"}
			{"0":"187","id":"187","1":"50","wf_caso_87_id":"50","2":"163","wf_tarea_id":"163","3":"51","core_usuario_id":"51","4":"2015-06-16 11:18:57","fec_asig":"2015-06-16 11:18:57","5":"51","core_usuario_id_resol":"51","6":"2015-06-16 11:33:32","fec_resol":"2015-06-16 11:33:32","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":"188","id":"188","1":"50","wf_caso_87_id":"50","2":"168","wf_tarea_id":"168","3":null,"core_usuario_id":null,"4":"2015-06-16 11:33:32","fec_asig":"2015-06-16 11:33:32","5":"59","core_usuario_id_resol":"59","6":"2015-07-01 12:50:17","fec_resol":"2015-07-01 12:50:17","7":"168","wf_tarea_id_sig":"168","8":null,"usr_asig":null,"9":"bb pp: gerente","usr_resol":"bb pp: gerente"}
			{"0":"257","id":"257","1":"50","wf_caso_87_id":"50","2":"169","wf_tarea_id":"169","3":"59","core_usuario_id":"59","4":"2015-07-01 12:50:17","fec_asig":"2015-07-01 12:50:17","5":null,"core_usuario_id_resol":null,"6":null,"fec_resol":null,"7":"169","wf_tarea_id_sig":"169","8":"bb pp: gerente","usr_asig":"bb pp: gerente","9":null,"usr_resol":null}
2015-07 01 12:50:27  
cargar datos del sujeto(,,s,87,50)
	
				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=50 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:50:27  
tabla dat adic
	select tabla from core_sujetoverificaciontipo where id=1
2015-07 01 12:50:27  
tabla :persona
	SELECT * FROM persona where id=101
2015-07 01 12:50:27  
Continuar(s,168,287,)
	EjecutarTarea_168() Verificacion musica campesina id_comp1232
				59  38
		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:50:27
/******************************************************************************************************/