2015-06 09 17:30:00  
Nuevo(87101017,1)
		Caso :460 
2015-06 09 17:30:00  
cargar datos del sujeto(,,s,70,460)
	
				select  s.*, m.nombre as nom_muni, c.nom_cat,fec_caso
				from  wf_caso_70 w
				inner join core_sujetoverificacion  s on w.id=460 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 09 17:30:00  
tabla dat adic
	select tabla from core_sujetoverificaciontipo where id=7
2015-06 09 17:30:00  
tabla :core_sujetoverificaciongeneral
	SELECT * FROM core_sujetoverificaciongeneral where id=87101017
		CasoSeguimiento :938 
	EjecutarTarea_140() Paso 1 - Radicación id_comp1075
				  1
		ValidarUsuario(140):1
			EjecutarPaso_226: form:55 , caso=460 id_comp 1075
				Mostrar form
 fin 2015-06-09  17:30:00
/******************************************************************************************************/

2015-06-11 14:28:27TraerCaso(460,70,)
 CargarCaso :460
2015-06 11 14:28:28  
CargarDatos: Caso :460
	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_70_seguimiento_id,wf_paso_id from wf_caso_70_pasos a1  group by wf_caso_70_seguimiento_id,wf_paso_id order by id
				)a
				inner join wf_caso_70_pasos p using(id,wf_caso_70_seguimiento_id)
				inner join ( select max(id) as wf_caso_70_seguimiento_id,wf_caso_70_id,wf_tarea_id from wf_caso_70_seguimiento where wf_caso_70_id =? group by wf_caso_70_id,wf_tarea_id order by wf_caso_70_id,wf_caso_70_seguimiento_id  ) b using(wf_caso_70_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_70_seguimiento a
				inner join (
				select max(b0.id) as id,b0.wf_caso_70_id,b0.wf_tarea_id from wf_caso_70_seguimiento b0  where b0.wf_caso_70_id =? group by b0.wf_caso_70_id,b0.wf_tarea_id order by wf_caso_70_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":"938","id":"938","1":"460","wf_caso_70_id":"460","2":"140","wf_tarea_id":"140","3":null,"core_usuario_id":null,"4":"2015-06-09 17:30:00","fec_asig":"2015-06-09 17:30:00","5":null,"core_usuario_id_resol":null,"6":null,"fec_resol":null,"7":"140","wf_tarea_id_sig":"140","8":null,"usr_asig":null,"9":null,"usr_resol":null}
2015-06 11 14:28:28  
cargar datos del sujeto(,,s,70,460)
	
				select  s.*, m.nombre as nom_muni, c.nom_cat,fec_caso
				from  wf_caso_70 w
				inner join core_sujetoverificacion  s on w.id=460 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 11 14:28:28  
tabla dat adic
	select tabla from core_sujetoverificaciontipo where id=7
2015-06 11 14:28:28  
tabla :core_sujetoverificaciongeneral
	SELECT * FROM core_sujetoverificaciongeneral where id=87101017
2015-06 11 14:28:28  
Continuar(,140,,s)
	EjecutarTarea_140() Paso 1 - Radicación id_comp1077
				  1
		ValidarUsuario(140):1
			EjecutarPaso_226: form:55 , caso=460 id_comp 1077
				Mostrar form
	Retorno :
	Array
	(
	    [ret] => Ext.getCmp('comp_1077').removeAll();Ext.getCmp('comp_1077').add(new Ext.form.FormPanel({ title: 'Pre-Radicación' ,padding: 10,id:'frm_formulario_70_460',autoScroll:true ,labelAlign:'top',defaults: { anchor: '70%'} ,items: [new Ext.form.Hidden({name:'cod_formulario2',value:'55'})  ,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:'64'})  ,new Ext.form.Hidden({name :'oid',value:''}) ,new Ext.form.Hidden({name :'oid_maestro',value:''}) ,new Ext.form.Hidden({name :'id_proy',id:'id_proy',value:'0'}) ,new Ext.form.Hidden({ value:'', id:'c370'}),new Ext.form.Hidden({ value:'2015-06-11 02:28:28 PM', id:'576'}),new Ext.form.Label({ text:'Fecha Ingreso: 2015-06-11 02:28:28 PM'}),new Ext.form.RadioGroup({columns:3,allowBlank:false,items:[ new Ext.form.Radio({name:'372',id:'372_1',inputValue:1,boxLabel:'Programa (Proyecto madre)',listeners:{check:function(cb, value){try{  new Ext.ToolTip({  target: '372_1',  html: 'Un programa es una manera de agrupar proyectos o acciones, que contribuyan de manera individual al cumplimiento de un objetivo, y que requiere la aplicación de todas las acciones de manera integral para el cumplimiento de dicho objetivo, generalmente sectorial.  DNP - “Notas sobre las diferentes aplicaciones de los conceptos de programa y proyecto de inversión”.',  title: 'Programa'  });   if (value){  Ext.getCmp('cod_bpi').setText('Codigo BPI: 2015-52-000-0298');       Ext.getCmp('cod_bpi').show();  Ext.getCmp('contenido').show();  Ext.getCmp('contenido').doLayout();  Ext.getCmp('628_').enable();  Ext.getCmp('628_').show();  Ext.getCmp('comb_subp').show();          /* Ext.getCmp('v_p1').enable();*/  Ext.getCmp('v_p1').show();  Ext.getCmp('v_p2').show();      Ext.getCmp('arch_dat').enable();   Ext.getCmp('arch_dat').show();      Ext.getCmp('per_ent').enable();   Ext.getCmp('per_ent').show();   Ext.getCmp('per_ent_tel_cel').enable();   Ext.getCmp('per_ent_tel_cel').show();   Ext.getCmp('per_ent_corr').enable();   Ext.getCmp('per_ent_corr').show();     Ext.getCmp('369').fieldLabel='Nombre programa';  Ext.getCmp('558').fieldLabel='Nombre persona responsable del programa';  Ext.getCmp('563').fieldLabel='Nombre persona que entrega el programa (Diligenciar únicamente cuando el programa proceda de una entidad diferente a la Gobernación de Nariño)';  Ext.getCmp('arch_dat').fieldLabel='Archivo .Dat';    var n=Ext.getCmp('369').getEl().dom;  var n1=n.parentNode.parentNode.firstChild;  n1.innerHTML='Nombre programa';      var n=Ext.getCmp('558').getEl().dom;  var n1=n.parentNode.parentNode.firstChild;  n1.innerHTML='Nombre persona responsable del programa';      var n=Ext.getCmp('563').getEl().dom;  var n1=n.parentNode.parentNode.firstChild;  n1.innerHTML='Nombre persona que entrega el programa (Diligenciar únicamente cuando el programa proceda de una entidad diferente a la Gobernación de Nariño)';      var n=Ext.getCmp('arch_dat').getEl().dom;  var n1=n.parentNode.parentNode.firstChild;  n1.innerHTML='Archivo .Dat';  /* Ext.getCmp('563').setValue("");   Ext.getCmp('564').setValue("");   Ext.getCmp('565').setValue("");   Ext.getCmp('566').setValue("");*/  /*Ext.getCmp('628').setHideLabel=false;*/   }/*Ext.getCmp('contenido').doLayout();*/ }catch(e){}}}}), new Ext.form.Radio({name:'372',id:'372_2',inputValue:2,boxLabel:'Proyecto',listeners:{check:function(cb, value){  try{new Ext.ToolTip({    target: '372_2',    html: 'Los proyectos de inversión pública contemplan actividades limitadas en el tiempo, que utilizan total o parcialmente recursos públicos, con el fin de crear, ampliar, mejorar o recuperar la capacidad de producción o provisión de bienes o servicios por parte del Estado. Decreto 2488 de 2010, art. 5.',    title: 'Proyecto'}); if (value){/*Ext.getCmp('v_p').enable(); */Ext.getCmp('contenido').show();Ext.getCmp('contenido').doLayout();Ext.getCmp('628_').setValue("");Ext.getCmp('comb_subp').hide();  Ext.getCmp('arch_dat').enable(); Ext.getCmp('arch_dat').show(); Ext.getCmp('cod_bpi').setText('Codigo BPI: 2015-52-000-0298'); Ext.getCmp('cod_bpi').show();   Ext.getCmp('v_p1').hide();  Ext.getCmp('v_p2').hide();  Ext.getCmp('per_ent').enable(); Ext.getCmp('per_ent').show(); Ext.getCmp('per_ent_tel_cel').enable(); Ext.getCmp('per_ent_tel_cel').show(); Ext.getCmp('per_ent_corr').enable(); Ext.getCmp('per_ent_corr').show();  Ext.getCmp('563').setValue(""); Ext.getCmp('564').setValue(""); Ext.getCmp('565').setValue(""); Ext.getCmp('566').setValue(""); var n=Ext.getCmp('369').getEl().dom; var n1=n.parentNode.parentNode.firstChild; n1.innerHTML='Nombre proyecto';  var n=Ext.getCmp('558').getEl().dom; var n1=n.parentNode.parentNode.firstChild; n1.innerHTML=' Nombre persona responsable del proyecto';  var n=Ext.getCmp('563').getEl().dom; var n1=n.parentNode.parentNode.firstChild; n1.innerHTML=' Nombre persona que entrega el proyecto (Diligenciar únicamente cuando el proyecto proceda de una entidad diferente a la Gobernación de Nariño)';  var n=Ext.getCmp('arch_dat').getEl().dom; var n1=n.parentNode.parentNode.firstChild; n1.innerHTML='Archivo .Dat'; }   }catch(e){}} }}) , new Ext.form.Radio({name:'372',id:'372_3',inputValue:3,boxLabel:'Proyecto de Desastre o Calamidad Publica',listeners:{check:function(cb, value){  try{ if (value) { /*Ext.getCmp('v_p').enable();*/ Ext.getCmp('contenido').show(); Ext.getCmp('contenido').doLayout(); Ext.getCmp('628_').setValue(""); Ext.getCmp('comb_subp').hide(); Ext.getCmp('cod_bpi').setText('Codigo BPI: 2015-52-000-0298'); Ext.getCmp('cod_bpi').show();  Ext.getCmp('v_p1').hide();  Ext.getCmp('v_p2').hide();  Ext.getCmp('arch_dat').hide();  Ext.getCmp('563').setValue("-");Ext.getCmp('per_ent').hide();Ext.getCmp('564').setValue("0");Ext.getCmp('565').setValue("0");Ext.getCmp('per_ent_tel_cel').hide();Ext.getCmp('566').setValue("-");Ext.getCmp('per_ent_corr').hide(); var n=Ext.getCmp('369').getEl().dom; var n1=n.parentNode.parentNode.firstChild; n1.innerHTML='Nombre proyecto de emergencia';  var n=Ext.getCmp('558').getEl().dom; var n1=n.parentNode.parentNode.firstChild; n1.innerHTML=' Nombre persona responsable del proyecto de emergencia';  var n=Ext.getCmp('arch_dat').getEl().dom; var n1=n.parentNode.parentNode.firstChild; n1.innerHTML=' ';  }new Ext.ToolTip({target: '372_3',html: 'Falta definicion de los proyectos de emergencia'});  }catch(e){}}}}) ],columns:3,fieldLabel:'Tipo',id:'372'}),/*new Ext.form.ComboBox({flex:1,listeners:{ select:function(){xajax_comprobar_campoOcultoSelect(this.getValue(),628);},afterrender:function(){ xajax_comprobar_campoOcultoSelect(this.getValue(),628); }},anchor:'100%',forceSelection:true,emptyText:'Seleccione una opción',editable:true,displayField:'valor',valueField:'id',triggerAction:'all',minChars:3,store:new Ext.data.Store({autoDestroy:true,url:$view_js+'carga_combo.php',autoSave:false,baseParams:{formulario:'55',id:'OID',et1:'txt_nom_proyecto'},autoLoad:false,reader:new Ext.data.JsonReader({totalProperty:'total',successProperty:'success',idProperty:'id',root:'data',messageProperty:'message'},[{name:'id'},{name:'valor'}])}),mode:'remote',queryParam:'nombre',pageSize:50,loadValor:function(val,data){if(data)this.getStore().loadData(data);else this.getStore().load();this.setValue(val);},id:'628',fieldLabel:' Para ingresar un subproyecto seleccione el programa' }),*//*new Ext.form.CompositeField({ fieldLabel:'Archivo .Dat', items:[]}),*/{            xtype:'fieldset',            padding: 20 ,labelAlign:'top',defaults: { anchor: '97%'},hidden:true,id:'contenido',                    items :[/*monica*/new Ext.form.RadioGroup({columns:2, items:[ new Ext.form.Radio({hidden:true,name:'v_p',id:'v_p1',inputValue:1,boxLabel:'Programa (Proyecto madre)',listeners:{check:function(cb, value){try{ if (value) Ext.getCmp('comb_subp').setDisabled(true);}catch(e){}}}}), new Ext.form.Radio({hidden:true,cheked:true,name:'v_p',id:'v_p2',inputValue:2,boxLabel:'Proyecto (Subproyecto)',listeners:{check:function(cb, value){  try{ if (value)Ext.getCmp('comb_subp').enable();}catch(e){}} }})  ],id:'372_99'}),/*monica*/{layout:'column',hidden:true,id:'comb_subp',disabled:true,border: false,items:[{columnWidth:1,layout: 'form',border: false,items: [ new Ext.form.ComboBox({    flex:1,listeners:{ select:function(combo,name){var codigos_bpi=[{"oid":"30","codigo":"30"},{"oid":"31","codigo":"31"},{"oid":"35","codigo":"35"},{"oid":"36","codigo":"36"},{"oid":"56","codigo":"56"},{"oid":"38","codigo":"38"},{"oid":"39","codigo":"39"},{"oid":"40","codigo":"40"},{"oid":"43","codigo":"43"},{"oid":"42","codigo":"42"},{"oid":"41","codigo":"41"},{"oid":"45","codigo":"45"},{"oid":"44","codigo":"44"},{"oid":"46","codigo":"46"},{"oid":"55","codigo":"55"},{"oid":"54","codigo":"54"},{"oid":"53","codigo":"53"},{"oid":"52","codigo":"52"},{"oid":"51","codigo":"51"},{"oid":"50","codigo":"50"},{"oid":"49","codigo":"49"},{"oid":"48","codigo":"48"},{"oid":"47","codigo":"47"},{"oid":"58","codigo":"58"},{"oid":"63","codigo":"63"},{"oid":"62","codigo":"62"},{"oid":"11","codigo":"2014-52-000-0141"},{"oid":"60","codigo":"60"},{"oid":"59","codigo":"59"},{"oid":"61","codigo":"61"},{"oid":"79","codigo":"79"},{"oid":"37","codigo":"37"},{"oid":"57","codigo":"57"},{"oid":"78","codigo":"78"},{"oid":"77","codigo":"77"},{"oid":"76","codigo":"76"},{"oid":"75","codigo":"75"},{"oid":"74","codigo":"74"},{"oid":"73","codigo":"73"},{"oid":"72","codigo":"72"},{"oid":"71","codigo":"71"},{"oid":"70","codigo":"70"},{"oid":"69","codigo":"69"},{"oid":"68","codigo":"68"},{"oid":"67","codigo":"67"},{"oid":"66","codigo":"66"},{"oid":"65","codigo":"65"},{"oid":"64","codigo":"64"},{"oid":"80","codigo":"80"},{"oid":"84","codigo":"84"},{"oid":"89","codigo":"2014-52-000-0089"},{"oid":"81","codigo":"81"},{"oid":"82","codigo":"82"},{"oid":"83","codigo":"2014-52-000-0083"},{"oid":"92","codigo":"2014-52-000-0092"},{"oid":"88","codigo":"2014-52-000-0088"},{"oid":"90","codigo":"2014-52-000-0090"},{"oid":"91","codigo":"2014-52-000-0091"},{"oid":"85","codigo":"2014-52-000-0085"},{"oid":"94","codigo":"2014-52-000-0094"},{"oid":"86","codigo":"2014-52-000-0086"},{"oid":"93","codigo":"2014-52-000-0093"},{"oid":"87","codigo":"2014-52-000-0087"},{"oid":"95","codigo":"2014-52-000-0095"},{"oid":"96","codigo":"2014-52-000-0096"},{"oid":"97","codigo":"2014-52-000-0097"},{"oid":"100","codigo":"2014-52-000-0100"},{"oid":"102","codigo":"2014-52-000-0102"},{"oid":"99","codigo":"2014-52-000-0099"},{"oid":"101","codigo":"2014-52-000-0101"},{"oid":"103","codigo":"2014-52-000-0103"},{"oid":"104","codigo":"2014-52-000-0104"},{"oid":"105","codigo":"2014-52-000-0105"},{"oid":"106","codigo":"2014-52-000-0106"},{"oid":"107","codigo":"2014-52-000-0107"},{"oid":"109","codigo":"2014-52-000-0109"},{"oid":"108","codigo":"2014-52-000-0108"},{"oid":"110","codigo":"2014-52-000-0110"},{"oid":"111","codigo":"2014-52-000-0111"},{"oid":"112","codigo":"2014-52-000-0112"},{"oid":"114","codigo":"2014-52-000-0114"},{"oid":"115","codigo":"2014-52-000-0115"},{"oid":"113","codigo":"2014-52-000-0113"},{"oid":"116","codigo":"2014-52-000-0116"},{"oid":"117","codigo":"2014-52-000-0117"},{"oid":"118","codigo":"2014-52-000-0118"},{"oid":"119","codigo":"2014-52-000-0119"},{"oid":"121","codigo":"2014-52-000-0121"},{"oid":"128","codigo":"2014-52-000-0128"},{"oid":"129","codigo":"2014-52-000-0129"},{"oid":"132","codigo":"2014-52-000-0132"},{"oid":"133","codigo":"2014-52-000-0133"},{"oid":"134","codigo":"2014-52-000-0134"},{"oid":"135","codigo":"2014-52-000-0135"},{"oid":"136","codigo":"2014-52-000-0136"},{"oid":"137","codigo":"2014-52-000-0137"},{"oid":"138","codigo":"2014-52-000-0138"},{"oid":"98","codigo":"2014-52-000-0098"},{"oid":"140","codigo":"2014-52-000-0140"},{"oid":"145","codigo":"2014-52-000-0145"},{"oid":"146","codigo":"2014-52-000-0146"},{"oid":"147","codigo":"2014-52-000-0147"},{"oid":"155","codigo":"2014-52-000-0155"},{"oid":"158","codigo":"2014-52-000-0158"},{"oid":"131","codigo":"2014-52-000-0131"},{"oid":"148","codigo":"2014-52-000-0141-02"},{"oid":"159","codigo":"2015-52-000-0159"},{"oid":"160","codigo":"2015-52-000-0160"},{"oid":"162","codigo":"2015-52-000-0162"},{"oid":"163","codigo":"2015-52-000-0163"},{"oid":"164","codigo":"2015-52-000-0164"},{"oid":"165","codigo":"2015-52-000-0165"},{"oid":"166","codigo":"2015-52-000-0166"},{"oid":"167","codigo":"2015-52-000-0167"},{"oid":"168","codigo":"2015-52-000-0168"},{"oid":"169","codigo":"2015-52-000-0169"},{"oid":"170","codigo":"2015-52-000-0170"},{"oid":"171","codigo":"2015-52-000-0171"},{"oid":"172","codigo":"2015-52-000-0172"},{"oid":"174","codigo":"2015-52-000-0174"},{"oid":"175","codigo":"2015-52-000-0175"},{"oid":"176","codigo":"2015-52-000-0176"},{"oid":"177","codigo":"2015-52-000-0177"},{"oid":"178","codigo":"2015-52-000-0178"},{"oid":"179","codigo":"2015-52-000-0179"},{"oid":"180","codigo":"2015-52-000-0180"},{"oid":"181","codigo":"2015-52-000-0181"},{"oid":"182","codigo":"2015-52-000-0182"},{"oid":"183","codigo":"2015-52-000-0183"},{"oid":"184","codigo":"2015-52-000-0184"},{"oid":"185","codigo":"2015-52-000-0185"},{"oid":"186","codigo":"2015-52-000-0186"},{"oid":"187","codigo":"2015-52-000-0187"},{"oid":"188","codigo":"2015-52-000-0188"},{"oid":"189","codigo":"2015-52-000-0189"},{"oid":"190","codigo":"2015-52-000-0190"},{"oid":"191","codigo":"2015-52-000-0191"},{"oid":"192","codigo":"2015-52-000-0192"},{"oid":"193","codigo":"2015-52-000-0193"},{"oid":"194","codigo":"2015-52-000-0194"},{"oid":"195","codigo":"2015-52-000-0195"},{"oid":"196","codigo":"2015-52-000-0196"},{"oid":"197","codigo":"2015-52-000-0197"},{"oid":"198","codigo":"2015-52-000-0198"},{"oid":"199","codigo":"2015-52-000-0199"},{"oid":"200","codigo":"2015-52-000-0200"},{"oid":"201","codigo":"2015-52-000-0201"},{"oid":"203","codigo":"2015-52-000-0202"},{"oid":"202","codigo":"2015-52-000-0202"},{"oid":"204","codigo":"2015-52-000-0204"},{"oid":"205","codigo":"2015-52-000-0205"},{"oid":"206","codigo":"2015-52-000-0206"},{"oid":"207","codigo":"2015-52-000-0207"},{"oid":"213","codigo":"2015-52-000-0213"},{"oid":"216","codigo":"2015-52-000-0216"},{"oid":"209","codigo":"2015-52-000-0209"},{"oid":"208","codigo":"2015-52-000-0208"},{"oid":"210","codigo":"2015-52-000-0210"},{"oid":"211","codigo":"2015-52-000-0211"},{"oid":"212","codigo":"2015-52-000-0212"},{"oid":"214","codigo":"2015-52-000-0214"},{"oid":"215","codigo":"2015-52-000-0215"},{"oid":"217","codigo":"2015-52-000-0217"},{"oid":"218","codigo":null},{"oid":"219","codigo":"2015-52-000-0219"},{"oid":"220","codigo":null},{"oid":"221","codigo":"2015-52-000-0221"},{"oid":"222","codigo":"2015-52-000-0222"},{"oid":"223","codigo":"2015-52-000-0223"},{"oid":"224","codigo":"2015-52-000-0224"},{"oid":"242","codigo":"2015-52-000-0242"},{"oid":"225","codigo":"2015-52-000-0225"},{"oid":"226","codigo":"2015-52-000-0226"},{"oid":"227","codigo":"2015-52-000-0227"},{"oid":"228","codigo":"2015-52-000-0228"},{"oid":"229","codigo":"2015-52-000-0229"},{"oid":"230","codigo":"2015-52-000-0230"},{"oid":"232","codigo":"2015-52-000-0232"},{"oid":"233","codigo":"2015-52-000-0233"},{"oid":"234","codigo":"2015-52-000-0234"},{"oid":"235","codigo":"2015-52-000-0235"},{"oid":"236","codigo":"2015-52-000-0236"},{"oid":"237","codigo":"2015-52-000-0237"},{"oid":"238","codigo":"2015-52-000-0238"},{"oid":"239","codigo":"2015-52-000-0239"},{"oid":"240","codigo":"2015-52-000-0240"},{"oid":"241","codigo":"2015-52-000-0241"},{"oid":"243","codigo":"2015-52-000-0242"},{"oid":"244","codigo":"2015-52-000-0244"},{"oid":"245","codigo":"2015-52-000-0245"},{"oid":"246","codigo":"2015-52-000-0246"},{"oid":"231","codigo":"2015-52-000-0231"},{"oid":"272","codigo":"2015-52-000-0272"},{"oid":"247","codigo":"2015-52-000-0247"},{"oid":"248","codigo":"2015-52-000-0247"},{"oid":"249","codigo":"2015-52-000-0248"},{"oid":"250","codigo":"2015-52-000-0250"},{"oid":"252","codigo":"2015-52-000-0252"},{"oid":"253","codigo":"2015-52-000-0253"},{"oid":"254","codigo":"2015-52-000-0254"},{"oid":"255","codigo":"2015-52-000-0255"},{"oid":"257","codigo":"2015-52-000-0257"},{"oid":"258","codigo":"2015-52-000-0258"},{"oid":"259","codigo":"2015-52-000-0259"},{"oid":"260","codigo":"2015-52-000-0260"},{"oid":"261","codigo":"2015-52-000-0261"},{"oid":"262","codigo":"2015-52-000-0262"},{"oid":"263","codigo":"2015-52-000-0263"},{"oid":"268","codigo":"2015-52-000-0268"},{"oid":"264","codigo":"2015-52-000-0264"},{"oid":"265","codigo":"2015-52-000-0265"},{"oid":"266","codigo":"2015-52-000-0266"},{"oid":"269","codigo":"2015-52-000-0269"},{"oid":"270","codigo":"2015-52-000-0270"},{"oid":"271","codigo":"2015-52-000-0271"},{"oid":"273","codigo":"2015-52-000-0273"},{"oid":"274","codigo":"2015-52-000-0274"},{"oid":"275","codigo":"2015-52-000-0275"},{"oid":"278","codigo":"2015-52-000-0278"},{"oid":"279","codigo":"2015-52-000-0279"},{"oid":"280","codigo":"2015-52-000-0280"},{"oid":"281","codigo":"2015-52-000-0281"},{"oid":"282","codigo":"2015-52-000-0282"},{"oid":"283","codigo":"2015-52-000-0283"},{"oid":"284","codigo":"2015-52-000-0284"},{"oid":"285","codigo":"2015-52-000-0285"},{"oid":"286","codigo":"2015-52-000-0286"},{"oid":"287","codigo":"2015-52-000-0287"},{"oid":"288","codigo":"2015-52-000-0288"},{"oid":"290","codigo":"2015-52-000-0290"},{"oid":"293","codigo":"2015-52-000-0293"},{"oid":"292","codigo":"2015-52-000-0292"},{"oid":"289","codigo":"2015-52-000-0289"},{"oid":"291","codigo":"2015-52-000-0291"},{"oid":"294","codigo":"2015-52-000-0294"},{"oid":"295","codigo":"2015-52-000-0295"},{"oid":"277","codigo":"2015-52-000-0276"},{"oid":"296","codigo":"2015-52-000-0296"},{"oid":"297","codigo":"2015-52-000-0297"}];for(var i=0;i<codigos_bpi.length;i++){if(codigos_bpi[i].oid==combo.getValue()){/*alert(codigos_bpi[i].codigo) ;*/Ext.getCmp('cod_bpi').setText('Codigo BPI: '+codigos_bpi[i].codigo+'-01');}}Ext.getCmp('cod_bpi').show();/*alert(combo.valueField+'-'+combo.getValue());var p=combo.getValue();*/xajax_comprobar_campoOcultoSelect(this.getValue(),628);/*Ext.getCmp('628').setValue(combo.getValue());*/},afterrender:function(){ xajax_comprobar_campoOcultoSelect(this.getValue(),628); }},anchor:'100%',forceSelection:true,emptyText:'Seleccione una opción',hidden:true/*,hideLabel:true*/,editable:true,displayField:'valor',valueField:'id'/*,disabled: true*/,triggerAction:'all',hiddenName:'628',minChars:3,store:new Ext.data.Store({autoDestroy:true,url:$view_js+'carga_combo.php',autoSave:false,baseParams:{formulario:'55',id:'OID',et1:'txt_nom_proyecto',rest1:'rbtn_tipo',adicional1:'codigo',val1:1}/*,et2:'txt_nom_proyecto'*/,autoLoad:false,reader:new Ext.data.JsonReader({totalProperty:'total',successProperty:'success',idProperty:'id',root:'data',messageProperty:'message'},[{name:'id'},{name:'valor'},'codigo'])}),mode:'remote',queryParam:'nombre',pageSize:50,loadValor:function(val,data){if(data)this.getStore().loadData(data);else this.getStore().load();this.setValue(val);},id:'628_',fieldLabel:' Para ingresar un subproyecto seleccione el programa' })]}]},new Ext.form.Hidden({ value:'2015-52-000-0298', id:'575'}),new Ext.form.Label({hidden:true,id:'cod_bpi', text:'Codigo BPI: 2015-52-000-0298',fieldLabel:''}), new Ext.form.CompositeField({ fieldLabel:'Archivo .Dat',hideLabel:true,hidden:true,id:'arch_dat', items:[ new Ext.form.Label({ text:'Cargue archivo . Dat: ',fieldLabel:'archi'}), new Ext.form.TextField({value:'No datos',readOnly:true,name:567,id:'inp_567' }),  new Ext.Button({hideLabel:true,tooltip:'Subir archivo .Dat',iconCls:'icon-attach',handler:function(){xajax_iniciarSubirArchivo('567');}}),  new Ext.Button({hideLabel:true,tooltip:'Borrar archivo .Dat',id:'btn_567',iconCls:'icon-remove',handler:function(){if(Ext.getCmp('inp_567').getValue()!= '' && Ext.getCmp('inp_567').getValue()!= null ){Ext.getCmp('369').setValue('');Ext.getCmp('id_proy').setValue(0);xajax_borrarArchivo('inp_567',Ext.getCmp('inp_567').setValue());}} }),{xtype:'button' ,text:'Validar archivo MGA',iconCls:'icon-application_get', anchor: '30%', handler:function(){ var ar=Ext.getCmp('inp_567').getValue(); var arr=ar; if(ar!= 'No datos' && ar!= null&&/.DAT/.test(arr.toUpperCase())){ Ext.getCmp('id_proy').setValue(0);       Ext.Ajax.request({url:$root_js+'archivos_gober/upload/sql_server.php?ar='+Ext.getCmp('inp_567').getValue()+'&id_proy='+Ext.getCmp('id_proy').getValue(), waitMsg:'Loading'    ,params:{accion:'guardar_pro'},success: function(result) {json=doJSON(result.responseText);if(json.success==true){Ext.getCmp('369').setValue(json.data[0].nomp.toUpperCase());Ext.getCmp('id_proy').setValue(json.data[0].id);Ext.getCmp('369').setReadOnly(true);} }   ,failure: function(result) {crearMsg(result.responseText+' '+this.status,'Falla');}  }); }else{ Ext.MessageBox.alert('Advertencia', 'Debe cargar un archivo .Dat'); } /*var wing;    wing=Ext.getCmp('comp__help');if(!wing){wing=crearVentana({ id:'comp__help',height: 220,width:564,modal:false,title:'Información del proyecto MGA'    ,modal:false,padding: 10,autoscroll:true,items:[{html:'<label>Por favor espere mientras  se carga la información.....</label><iframe src="'+$root_js+'archivos_gober/upload/sql_server.php?ar='+Ext.getCmp('inp_567').getValue()+'&id_proy='+Ext.getCmp('id_proy').getValue()+'"" width="100%" height="100%" frameborder=0 name="fram" id="fram" ></iframe>'}],bbar:[{text: 'Aceptar',iconCls: 'icon-accept',id:'btnacept',hidden:true,handler:function(){var txt3 = document.getElementById('fram');var txt=txt3.contentWindow.document.getElementById('id_pro').value;Ext.getCmp('id_proy').setValue(txt);Ext.Ajax.request({url:$root_js+'archivos_gober/consultas.php',params:{accion:'listar_pro',id:txt},success: function(result) {json=doJSON(result.responseText);if(json.success==true){Ext.getCmp('369').setValue(json.data[0].nomp);} }   ,failure: function(result) {crearMsg(result.responseText+' '+this.status,'Falla');}  });wing.close(); wing.destroy();}},{text: 'Cancelar',iconCls: 'icon-cancel',hidden:true,handler:function(){Ext.getCmp('comp__help').close();}}],listeners:{afterrender:function(){setTimeout(function(){settim();},800);      } }});}wing.show();*/} } ]}),  new Ext.form.CompositeField({ fieldLabel:'Documento MGA pdf',hideLabel:true, items:[ new Ext.form.Label({ text:'Documento MGA pdf: ',fieldLabel:'docu'}),  new Ext.form.TextField({value:'No datos',readOnly:true,name:811,id:'inp_811' }),  new Ext.Button({hideLabel:true,tooltip:'Subir archivo',iconCls:'icon-attach',handler:function(){xajax_iniciarSubirArchivo('811');}}),  new Ext.Button({hideLabel:true,tooltip:'Borrar archivo',id:'btn_811',iconCls:'icon-remove',handler:function(){if(Ext.getCmp('inp_811').getValue()!= '' && Ext.getCmp('inp_811').getValue()!= null )xajax_borrarArchivo('inp_811',Ext.getCmp('inp_811').setValue());} }) ]}),{value:'',xtype:'textfield' , maxLength:300,autoCreate:{ tag:'input',maxlength:'300'} ,listeners:{ blur:function(){ this.setValue(this.getValue().toUpperCase()); } } ,id:'369',fieldLabel:'Nombre Proyecto'},new Ext.form.ComboBox({fieldLabel:'Sector de inversión',anchor:'100%',forceSelection:true,emptyText:'Seleccione una opción',editable:true,displayField:'valor',valueField:'id',triggerAction:'all',minChars:3,store:new Ext.data.Store({autoDestroy:true,url:$view_js+"carga_comboQueryTabla.php",autoSave:false,baseParams:{'dqsl':'14', 'pro':'70', 'cas':'460'},autoLoad:false,reader:new Ext.data.JsonReader({totalProperty:'total',successProperty:'success',idProperty:'id',root:'data',messageProperty:'message'},[{name:'id'},{name:'valor'}])}),mode:'remote',queryParam:'nombre',pageSize:20,hiddenName:555,id:'inp_555',loadValor:function(val,data){this.getStore().loadData(data);this.setValue(val);}}),{ xtype:'hidden',id:'hdcampo630',value:'73'},{ xtype:'hidden',id:'630'}, new Ext.grid.EditorGridPanel({xtype:'editorgrid',store:new Ext.data.JsonStore({ fields:[{ name:'oid' },{ name:'select_municipio' }]}),columns:[new Ext.grid.RowNumberer({width:30}),{header:'Localización',dataIndex:'select_municipio',width:80,resizable:true,sortable:true,renderer:function(value,metaData,record,rowIndex,colIndex,store) {var combo = this.editor;var record = combo.findRecord(combo.valueField,value);return record ? record.get(combo.displayField):(record && record.data.select_municipio ?record.data.select_municipio:value );},editor:  new Ext.form.ComboBox({fieldLabel:'Localizacinón',anchor:'100%',forceSelection:true,emptyText:'Seleccione una opción',editable:true,displayField:'valor',valueField:'id',triggerAction:'all',minChars:3,store:new Ext.data.Store({autoDestroy:true,url:$view_js+"carga_comboQueryTabla.php",autoSave:false,baseParams:{'dqsl':'15', 'pro':'70', 'cas':'460','dep':'22'},autoLoad:true,reader:new Ext.data.JsonReader({totalProperty:'total',successProperty:'success',idProperty:'id',root:'data',messageProperty:'message'},[{name:'id'},{name:'valor'}])}),mode:'remote',queryParam:'nombre',pageSize:20/*,listeners:{specialkey: function(f,e){if (e.getKey() == e.ENTER ) {alert("holaa");}}}*/,hiddenName:631,id:'inp_631',loadValor:function(val,data){this.getStore().loadData(data);this.setValue(val);}})},{header:'Subregion',dataIndex:'select_municipiod',width:80,resizable:true,sortable:true,renderer:function (val,metaData,record,rowIndex,colIndex,store){var municipios=[{"zona":"Juanamb\u00fa","muni":"129"},{"zona":"Ex Provincia de Obando","muni":"433"},{"zona":"R\u00edo Mayo","muni":"462"},{"zona":"Guambuyaco","muni":"312"},{"zona":"Sanquianga","muni":"487"},{"zona":"Sanquianga","muni":"583"},{"zona":"R\u00edo Mayo","muni":"800"},{"zona":"P\u00ede de monte costero","muni":"748"},{"zona":"Centro","muni":"832"},{"zona":"Centro","muni":"594"},{"zona":"Centro","muni":"467"},{"zona":"Centro","muni":"1082"},{"zona":"Centro","muni":"966"},{"zona":"Centro","muni":"187"},{"zona":"Pac\u00edfico sur","muni":"1015"},{"zona":"Ex Provincia de Obando","muni":"437"},{"zona":"Ex Provincia de Obando","muni":"22"},{"zona":"Ex Provincia de Obando","muni":"255"},{"zona":"Ex Provincia de Obando","muni":"722"},{"zona":"Ex Provincia de Obando","muni":"684"},{"zona":"Ex Provincia de Obando","muni":"277"},{"zona":"Ex Provincia de Obando","muni":"695"},{"zona":"Ex Provincia de Obando","muni":"239"},{"zona":"Ex Provincia de Obando","muni":"356"},{"zona":"Ex Provincia de Obando","muni":"395"},{"zona":"Ex Provincia de Obando","muni":"264"},{"zona":"Ex Provincia de Obando","muni":"389"},{"zona":"Sabana","muni":"394"},{"zona":"Sabana","muni":"434"},{"zona":"Sabana","muni":"625"},{"zona":"Sabana","muni":"899"},{"zona":"Abades","muni":"786"},{"zona":"Abades","muni":"1104"},{"zona":"Abades","muni":"687"},{"zona":"Occidente","muni":"868"},{"zona":"Occidente","muni":"508"},{"zona":"Occidente","muni":"238"},{"zona":"Occidente","muni":"37"},{"zona":"Cordillera","muni":"265"},{"zona":"Cordillera","muni":"503"},{"zona":"Cordillera","muni":"679"},{"zona":"Cordillera","muni":"965"},{"zona":"Cordillera","muni":"322"},{"zona":"Juanamb\u00fa","muni":"58"},{"zona":"Juanamb\u00fa","muni":"489"},{"zona":"Juanamb\u00fa","muni":"857"},{"zona":"Juanamb\u00fa","muni":"837"},{"zona":"R\u00edo Mayo","muni":"20"},{"zona":"R\u00edo Mayo","muni":"98"},{"zona":"R\u00edo Mayo","muni":"231"},{"zona":"Pac\u00edfico sur","muni":"350"},{"zona":"Telemb\u00ed","muni":"83"},{"zona":"R\u00edo Mayo","muni":"323"},{"zona":"R\u00edo Mayo","muni":"852"},{"zona":"Guambuyaco","muni":"471"},{"zona":"Guambuyaco","muni":"325"},{"zona":"P\u00ede de monte costero","muni":"531"},{"zona":"Telemb\u00ed","muni":"526"},{"zona":"Telemb\u00ed","muni":"755"},{"zona":"Sanquianga","muni":"299"},{"zona":"Sanquianga","muni":"872"},{"zona":"Sanquianga","muni":"619"},{"zona":"Guambuyaco","muni":"939"},{"zona":"Sabana","muni":"1026"}];for(var i=0;i<municipios.length;i++){if(municipios[i].muni==record.get('select_municipio')){return municipios[i].zona;}} return '';}}],stripeRows:true,height:150,id:'630_73',title:'Localización',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(){/*xajax_iniciarPintarFormulario({cod_formulario2:'73',id_periodo:'2015',oid_maestro:Ext.getCmp("frm_formulario_70_460").getForm().findField("oid").getValue(),obs_ingreso:'73',contenedor_nuevo:'_73'},'n','','511','500');return false;*//*xajax_iniciarPintarFormulario({cod_formulario2:'72',id_periodo:'2015',oid_maestro:Ext.getCmp("frm_formulario_70_460").getForm().findField("oid").getValue(),obs_ingreso:'55',contenedor_nuevo:'_72'},'n','','511','500');*/var TopicRecord = Ext.data.Record.create({ name:'oid' },{ name:'select_municipio' });var myNewRecord = new TopicRecord({ oid:null ,select_municipio:''});var storegri = Ext.getCmp('630_73').getStore();storegri.add(myNewRecord);}},{iconCls:'icon-delete',tooltip:'Eliminar',text:'Eliminar',handler:function(){var grid = Ext.getCmp('630_73');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 });}}]}),new Ext.form.ComboBox({fieldLabel:'Resguardo Indígena',anchor:'50%',forceSelection:true,emptyText:'Seleccione una opción',editable:true,displayField:'valor',valueField:'id',triggerAction:'all',minChars:3,store:new Ext.data.Store({autoDestroy:true,url:$view_js+"carga_comboQueryTabla.php",autoSave:false,baseParams:{'dqsl':'16', 'pro':'70', 'cas':'460'},autoLoad:true,reader:new Ext.data.JsonReader({totalProperty:'total',successProperty:'success',idProperty:'id',root:'data',messageProperty:'message'},[{name:'id'},{name:'valor'}])}),listeners: {afterrender: function(combo){combo.loadValor('70',combo.getStore);}},mode:'remote',queryParam:'nombre',pageSize:20,hiddenName:557,id:'inp_557',loadValor:function(val,data){this.getStore().loadData(data);this.setValue(val);}}),new Ext.form.Hidden({name:'dep_id',id:'dep_id',value:''}) /*,new Ext.form.ComboBox({fieldLabel:'Dependencia',anchor:'100%',forceSelection:true,emptyText:'Seleccione una opción',editable:true,displayField:'valor',valueField:'id',triggerAction:'all',minChars:3,store:new Ext.data.Store({autoDestroy:true,url:$view_js+"carga_comboQueryTabla.php",autoSave:false,baseParams:{'dqsl':'8', 'pro':'70', 'cas':'460'},autoLoad:false,reader:new Ext.data.JsonReader({totalProperty:'total',successProperty:'success',idProperty:'id',root:'data',messageProperty:'message'},[{name:'id'},{name:'valor'}])}),mode:'remote',queryParam:'nombre',pageSize:20,hiddenName:371,id:'inp_371',loadValor:function(val,data){this.getStore().loadData(data);this.setValue(val);}})*//*,new Ext.form.CompositeField({ fieldLabel: 'Entidad Proponente',items:[{value:'',xtype:'textfield' , maxLength:100,autoCreate:{ tag:'input',maxlength:'100'},id:'370',readOnly:true,flex:1 },new Ext.Button({text:'Seleccionar entidad',hideLabel:true,tooltip:'Buscar entidad proponente',iconCls:'icon-help',handler:function(){var wing;    wing=Ext.getCmp('comp__arbol');if(!wing){wing=crearVentana({ id:'comp__arbol',height: 220,width:564,modal:false,title:'Entidad proponente'    ,modal:false,padding: 10,autoscroll:true,items:[new Ext.tree.TreePanel({autoScroll:true,animate:true,enableDD:false,containerScroll:true,border:false,region:'center',url:$view_js+'dependencia/documento.php?usu=',id:'id_Arbol' ,refresh:function(cad){selNode = this.getSelectionModel().getSelectedNode();if(selNode){if (cad=='mod'){if(selNode.isLeaf()){this.loader.load( selNode.parentNode );}else {if (selNode.parentNode.id!=0){this.loader.load( selNode.parentNode );}elsethis.getRootNode().reload();}}else if (cad=='del'){this.loader.load( selNode.parentNode );}else{if(selNode.isLeaf()){this.loader.load( selNode.parentNode );}else {this.loader.load( selNode );}}}else{this.root.reload();this.root.collapse(true, false);}},tbar:[{iconCls:'icon-add',text:'Nueva Dependencia',handler:function(){ var tree=Ext.getCmp('id_Arbol');var node= tree.getSelectionModel().getSelectedNode();if (node){ var accion='add'; var id=node.id; var padre=node.padre;var titles='';if(accion=='add'){titles='Agregar ';}if(accion=='mod' && hoja.leaf==false){titles='Modificar ';}var winc = Ext.getCmp('comp__emergente');if(!winc){winc=crearVentana({id:'comp__emergente',title:titles,width:400,height:170,iconCls:'icon-grid',shim:false,animCollapse:false,constrainHeader:true,layout:'fit',resizable:true,maximizable:false,modal:true,bbar:[{iconCls:'icon-disk',text:'Guardar',handler:function(){ var frm = Ext.getCmp('formger');var count=0;if(frm.getForm().isValid()){frm.getForm().submit({ success:function(form, action){var tree=Ext.getCmp('id_Arbol');tree.refresh(accion);Ext.MessageBox.alert('Informaci&oacute;n','Dependencia  adicionada correctamente');if(count==0 &&accion=='add'){var node= tree.getSelectionModel().getSelectedNode();node.expand();count++; }else{var node= tree.getNodeById(action.result.pad);node.expand();}},failure:function(form, action){   if(action.result.success==false) {Ext.MessageBox.alert('Advertencia','Dependencia  ya esta registrada');  }}});}else{Ext.MessageBox.alert('Advertencia',getErrorFields(frm.getForm()));}}}],items:[new Ext.form.FormPanel({id:'formger',url:$view_js+'dependencias/dependencias_l.php',items:[ {xtype:'hidden',name:'pad_dep',value:padre},{xtype:'hidden',name:'id',value:id},{xtype:'hidden',name:'accion',value:accion},{xtype:'textfield',name:'nom_dep',fieldLabel:'titulo',anchor:'100%',allowBlank:false},new Ext.form.RadioGroup({id:'myGroup',xtype: 'radiogroup',fieldLabel: 'estado',columns: 2,name: 'est_dep',items: [{boxLabel: 'Activo', name: 'est_dep' ,inputValue:'1', checked: true},{boxLabel: 'Inactivo', name: 'est_dep',inputValue:'0'}]})]})]});}if(accion=='mod' ){var formu=Ext.getCmp('form_');formu.load({params:{accion:'cargar',id:id},success: function(form, action){if(action.result.success){}}});}winc.show();}else{Ext.MessageBox.alert('Informaci&oacute;n','Debe seleccionar un elemento');}}}],bbar:[{text:'Expandir',tooltip:'Expandir todo',iconCls:'icon-email_go',handler:function(){var tree = Ext.getCmp('id_Arbol');  tree.getRootNode().expand(true);}},{text:'Colapsar',tooltip:'Colapsar todo',iconCls:'icon-information',handler:function(){var tree = Ext.getCmp('id_Arbol');tree.getRootNode().collapse(true);}}],loader:new Ext.tree.TreeLoader({dataUrl:$view_js+'dependencias/dependencias_l.php?usu=',baseParams:{accion:'nodosArbol'}}),root:{nodeType:'async',text:'Dependencias registradas',draggable:false,leaf: false,id:'0' ,expanded:true}})],bbar:[{text: 'Aceptar',iconCls: 'icon-accept',handler:function(){ var tree=Ext.getCmp('id_Arbol');var node= tree.getSelectionModel().getSelectedNode();if (node){   Ext.getCmp('370').setValue(node.text);Ext.getCmp('c370').setValue(node.id);}else{Ext.MessageBox.alert('Informaci&oacute;n','Debe seleccionar un elemento'); return;}wing.close(); wing.destroy();}}]});}wing.show();}})]})*/,{value:'',xtype:'textfield' , maxLength:100,autoCreate:{ tag:'input',maxlength:'100'} ,listeners:{ blur:function(){ this.setValue(this.getValue().toUpperCase()); } } ,id:'558',fieldLabel:'Nombre de la persona responsable del proyecto' },{value:'',xtype:'textfield' , maxLength:100,autoCreate:{ tag:'input',maxlength:'100'} ,listeners:{ blur:function(){ this.setValue(this.getValue().toUpperCase()); } } ,id:'559',fieldLabel:'Cargo' },{layout:'column',border: false,items:[{columnWidth:.5,layout: 'form',border: false,items: [{value:'',xtype:'numberfield',anchor:'-10',maxLength:15,autoCreate:{ tag:'input',maxlength:'15'} ,id:'560',fieldLabel:'Teléfono'}]},{columnWidth:.5,layout: 'form',border: false,items: [{value:'',xtype:'numberfield',anchor:'100%' , maxLength:15,autoCreate:{ tag:'input',maxlength:'15'} ,id:'561',fieldLabel:'Celular'}]}]},{value:'',xtype:'textfield' , maxLength:100,autoCreate:{ tag:'input',maxlength:'100'} ,allowBlank:false,id:'562',fieldLabel:'* Correo electrónico',vtype:'email' },{            xtype:'fieldset',            title: 'Datos de la persona que entrega o radica el proyecto (Diligenciar únicamente cuando el proyecto proceda de una entidad diferente a la Gobernación de Nariño)',            collapsible: true,            autoHeight:true,collapsed:true,            defaults: {width: 420},            defaultType: 'textfield',            items :[{value:'',xtype:'textfield' ,maxLength:100,autoCreate:{ tag:'input',maxlength:'100'} ,listeners:{ blur:function(){ this.setValue(this.getValue().toUpperCase()); } } ,id:'563',fieldLabel:'Nombre persona que entrega' },{                    xtype : 'compositefield',fieldLabel: ' ',                    items : [{xtype:'label',text:'Teléfono'},{value:'',xtype:'numberfield',flex:1,maxLength:15,autoCreate:{ tag:'input',maxlength:'15'} ,id:'564',fieldLabel:''},{xtype:'label',text:'Celular'},{value:'',xtype:'numberfield',flex:1,maxLength:15,autoCreate:{ tag:'input',maxlength:'15'} ,id:'565',fieldLabel:'* ' }]}/*{value:'',xtype:'numberfield',maxLength:15,autoCreate:{ tag:'input',maxlength:'15'} ,id:'564',fieldLabel:'Teléfono'},{value:'',xtype:'numberfield',maxLength:15,autoCreate:{ tag:'input',maxlength:'15'} ,id:'565',fieldLabel:'* Celular' }*/,{value:'',xtype:'textfield' , maxLength:100,autoCreate:{ tag:'input',maxlength:'100'} ,id:'566',fieldLabel:'* Correo electrónico' }/*{layout:'column',hidden:true,id:'per_ent',border: false,items:[{columnWidth:1,layout: 'form',border: false,items: [{value:'',xtype:'textfield' ,maxLength:100,autoCreate:{ tag:'input',maxlength:'100'} ,listeners:{ blur:function(){ this.setValue(this.getValue().toUpperCase()); } } ,id:'563',fieldLabel:'Nombre persona que entrega' }]}]},{layout:'column',hidden:true,id:'per_ent_tel_cel',border: false,items:[{columnWidth:.5,layout: 'form',border: false,items: [{value:'',xtype:'numberfield',anchor:'-10',maxLength:15,autoCreate:{ tag:'input',maxlength:'15'} ,id:'564',fieldLabel:'Teléfono'}]},{columnWidth:.5,layout: 'form',border: false,items: [{value:'',xtype:'numberfield',anchor:'-1',maxLength:15,autoCreate:{ tag:'input',maxlength:'15'} ,allowBlank:false,id:'565',fieldLabel:'* Celular' }]}]},{layout:'column',hidden:true,id:'per_ent_corr',border: false,items:[{columnWidth:1,layout: 'form',border: false,items: [{value:'',xtype:'textfield' , maxLength:100,autoCreate:{ tag:'input',maxlength:'100'} ,allowBlank:false,id:'566',fieldLabel:'* Correo electrónico' }]}]}*/]}/*, new Ext.grid.EditorGridPanel({xtype:'editorgrid',store:new Ext.data.JsonStore({ fields:[{ name:'oid' },{ name:'select_municipio' }]}),columns:[new Ext.grid.RowNumberer({width:30}),{header:'Municipio',dataIndex:'select_municipio',width:80,resizable:true,sortable:true,renderer:function(value,metaData,record,rowIndex,colIndex,store) {var combo = this.editor;var record = combo.findRecord(combo.valueField,value);return record ? record.get(combo.displayField):(record && record.data.select_municipio ?record.data.select_municipio:value );},editor:  new Ext.form.ComboBox({fieldLabel:'Municipio',anchor:'100%',forceSelection:true,emptyText:'Seleccione una opción',editable:true,displayField:'valor',valueField:'id',triggerAction:'all',minChars:3,store:new Ext.data.Store({autoDestroy:true,url:$view_js+"carga_comboQueryTabla.php",autoSave:false,baseParams:{'dqsl':'15', 'pro':'{', 'cas':'{','dep':'22'},autoLoad:true,reader:new Ext.data.JsonReader({totalProperty:'total',successProperty:'success',idProperty:'id',root:'data',messageProperty:'message'},[{name:'id'},{name:'valor'}])}),mode:'remote',queryParam:'nombre',pageSize:20,hiddenName:631,id:'inp_631',loadValor:function(val,data){this.getStore().loadData(data);this.setValue(val);}})},{header:'Subregion',dataIndex:'select_municipiod',width:80,resizable:true,sortable:true,renderer:function (val,metaData,record,rowIndex,colIndex,store){var municipios=[{"zona":"Juanamb\u00fa","muni":"129"},{"zona":"Ex Provincia de Obando","muni":"433"},{"zona":"R\u00edo Mayo","muni":"462"},{"zona":"Guambuyaco","muni":"312"},{"zona":"Sanquianga","muni":"487"},{"zona":"Sanquianga","muni":"583"},{"zona":"R\u00edo Mayo","muni":"800"},{"zona":"P\u00ede de monte costero","muni":"748"},{"zona":"Centro","muni":"832"},{"zona":"Centro","muni":"594"},{"zona":"Centro","muni":"467"},{"zona":"Centro","muni":"1082"},{"zona":"Centro","muni":"966"},{"zona":"Centro","muni":"187"},{"zona":"Pac\u00edfico sur","muni":"1015"},{"zona":"Ex Provincia de Obando","muni":"437"},{"zona":"Ex Provincia de Obando","muni":"22"},{"zona":"Ex Provincia de Obando","muni":"255"},{"zona":"Ex Provincia de Obando","muni":"722"},{"zona":"Ex Provincia de Obando","muni":"684"},{"zona":"Ex Provincia de Obando","muni":"277"},{"zona":"Ex Provincia de Obando","muni":"695"},{"zona":"Ex Provincia de Obando","muni":"239"},{"zona":"Ex Provincia de Obando","muni":"356"},{"zona":"Ex Provincia de Obando","muni":"395"},{"zona":"Ex Provincia de Obando","muni":"264"},{"zona":"Ex Provincia de Obando","muni":"389"},{"zona":"Sabana","muni":"394"},{"zona":"Sabana","muni":"434"},{"zona":"Sabana","muni":"625"},{"zona":"Sabana","muni":"899"},{"zona":"Abades","muni":"786"},{"zona":"Abades","muni":"1104"},{"zona":"Abades","muni":"687"},{"zona":"Occidente","muni":"868"},{"zona":"Occidente","muni":"508"},{"zona":"Occidente","muni":"238"},{"zona":"Occidente","muni":"37"},{"zona":"Cordillera","muni":"265"},{"zona":"Cordillera","muni":"503"},{"zona":"Cordillera","muni":"679"},{"zona":"Cordillera","muni":"965"},{"zona":"Cordillera","muni":"322"},{"zona":"Juanamb\u00fa","muni":"58"},{"zona":"Juanamb\u00fa","muni":"489"},{"zona":"Juanamb\u00fa","muni":"857"},{"zona":"Juanamb\u00fa","muni":"837"},{"zona":"R\u00edo Mayo","muni":"20"},{"zona":"R\u00edo Mayo","muni":"98"},{"zona":"R\u00edo Mayo","muni":"231"},{"zona":"Pac\u00edfico sur","muni":"350"},{"zona":"Telemb\u00ed","muni":"83"},{"zona":"R\u00edo Mayo","muni":"323"},{"zona":"R\u00edo Mayo","muni":"852"},{"zona":"Guambuyaco","muni":"471"},{"zona":"Guambuyaco","muni":"325"},{"zona":"P\u00ede de monte costero","muni":"531"},{"zona":"Telemb\u00ed","muni":"526"},{"zona":"Telemb\u00ed","muni":"755"},{"zona":"Sanquianga","muni":"299"},{"zona":"Sanquianga","muni":"872"},{"zona":"Sanquianga","muni":"619"},{"zona":"Guambuyaco","muni":"939"},{"zona":"Sabana","muni":"1026"}];for(var i=0;i<municipios.length;i++){if(municipios[i].muni==record.get('select_municipio')){return municipios[i].zona;}} return '';}}],stripeRows:true,height:150,id:'grd_localizacion',title:'Localizacion',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();}}}})*/,new Ext.form.ComboBox({typeAhead:true,/*fin introducir listener para campos ocultos*/triggerAction:'all',mode:'local',editable:false,emptyText:'Seleccione una opción',store:new Ext.data.ArrayStore({fields:['id', 'value'],data:[[1,'Departamento'],[2,'Sistema General de Regalias'] ]}),valueField:'id',displayField:'value',id:'inp_select_etapa',fieldLabel:'Etapa',hiddenName:'etapa',listeners:{ select:function(){/*xajax_comprobar_campoOcultoSelect(this.getValue(),546);*/try{Ext.getCmp('inp_373').reset();Ext.getCmp('inp_373').store.setBaseParam('gel_tipo_id',this.getValue());Ext.getCmp('inp_373').store.load();}catch(e){alert(e);}},afterrender:function(){ /*xajax_comprobar_campoOcultoSelect(this.getValue(),546);*/ }},}),new Ext.form.ComboBox({fieldLabel:'* Lista de Chequeo',anchor:'100%',forceSelection:true,emptyText:'Seleccione una opción',editable:false,displayField:'valor',valueField:'id',triggerAction:'all',minChars:3,allowBlank:false,store:new Ext.data.Store({autoDestroy:true,url:$view_js+"carga_comboQueryTabla.php",autoSave:false,baseParams:{'dqsl':'9', 'pro':'{', 'cas':'{'},autoLoad:false,reader:new Ext.data.JsonReader({totalProperty:'total',successProperty:'success',idProperty:'id',root:'data',messageProperty:'message'},[{name:'id'},{name:'valor'}])}),mode:'remote',queryParam:'nombre',pageSize:20,hiddenName:373,id:'inp_373',loadValor:function(val,data){this.getStore().loadData(data);this.setValue(val);},listeners:{ select:function(){ try{Ext.getCmp('inp_374').reset();Ext.getCmp('inp_374').store.setBaseParam('tipo_id',Ext.getCmp('inp_373').getValue());Ext.getCmp('inp_374').store.load();}catch(e){alert(e);}} }}),new Ext.form.ComboBox({fieldLabel:'* Tipo Lista',anchor:'100%',forceSelection:true,emptyText:'Seleccione una opción',editable:false,displayField:'valor',valueField:'id',triggerAction:'all',minChars:3,allowBlank:false,store:new Ext.data.Store({autoDestroy:true,url:$view_js+"carga_comboQueryTabla.php",autoSave:false,baseParams:{'dqsl':'10', 'pro':'{', 'cas':'{'},autoLoad:false,reader:new Ext.data.JsonReader({totalProperty:'total',successProperty:'success',idProperty:'id',root:'data',messageProperty:'message'},[{name:'id'},{name:'valor'}])}),mode:'remote',queryParam:'nombre',pageSize:20,hiddenName:374,id:'inp_374',loadValor:function(val,data){this.getStore().loadData(data);this.setValue(val);}})            ]        } ] ,prepararGrids:function(){/*buscar editorgrid - grilla id compuesto, id real, mas id formulario esclavo, separado _*/var grillasF=this.findByType('editorgrid');if(grillasF && grillasF!=''){for (i=0; i < grillasF.length; i++){var xstore=grillasF[i].getStore();if(xstore.getCount()>0){var data=new Array();var xxid=grillasF[i].getId().split('_');for (j=0; j < xstore.getCount(); j++){var xreco = xstore.getAt(j); var cont_dat_vac=0,cont_tot_vac=0; for(var elem in xreco.data){cont_tot_vac++;if( xreco.data[elem] ==null || xreco.data[elem]=='' ){cont_dat_vac++;}} if(cont_dat_vac < cont_tot_vac){data[data.length]=xreco.data;data[data.length-1]['form_master_escribir_xxx']=xxid[1];}}var xfinalfin=Ext.encode(data);Ext.getCmp(xxid[0]).setValue(xfinalfin);}}}/*grabar stores en hiddens*/},tbar:[{text:'Guardar',iconCls: 'icon-disk',handler: function(){ var form = Ext.getCmp('frm_formulario_70_460'); 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:'70',wf_paso_id:'226',wf_tarea_id:'140',wf_caso_id:'460',id:'1077',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{setTimeout(function(){Ext.getCmp('630_73').getView().refresh();},2000);   Ext.getCmp('frm_formulario_70_460').getForm().loadRecord(new Ext.data.Record({"cod_formulario":55,"oid_maestro":null,"cod_bloque":64,"369":null,"560":null,"558":null,"370":null,"559":null,"561":null,"562":null,"563":null,"564":null,"565":null,"566":null}));  llamadaAJAX({url:'http://192.168.10.116/sisad/build/view/workflow/casos/casos_datosForm.php',mostrarMsg:false,params:{accion:'verifica',wf_paso_id:'226',cod_formulario:'55',cod_bloque:'64',wf_caso_id:'{"pro":"70","cas":"460"}'}}); }catch(e){alert(e);} } }  }) );Ext.getCmp('comp_1077').doLayout();
	    [suc] => 1
	)
	
 fin 2015-06-11  14:28:28
/******************************************************************************************************/

2015-06-11 14:28:28TraerCaso(460,70,)
 CargarCaso :460
2015-06 11 14:28:28  
CargarDatos: Caso :460
	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_70_seguimiento_id,wf_paso_id from wf_caso_70_pasos a1  group by wf_caso_70_seguimiento_id,wf_paso_id order by id
				)a
				inner join wf_caso_70_pasos p using(id,wf_caso_70_seguimiento_id)
				inner join ( select max(id) as wf_caso_70_seguimiento_id,wf_caso_70_id,wf_tarea_id from wf_caso_70_seguimiento where wf_caso_70_id =? group by wf_caso_70_id,wf_tarea_id order by wf_caso_70_id,wf_caso_70_seguimiento_id  ) b using(wf_caso_70_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_70_seguimiento a
				inner join (
				select max(b0.id) as id,b0.wf_caso_70_id,b0.wf_tarea_id from wf_caso_70_seguimiento b0  where b0.wf_caso_70_id =? group by b0.wf_caso_70_id,b0.wf_tarea_id order by wf_caso_70_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":"938","id":"938","1":"460","wf_caso_70_id":"460","2":"140","wf_tarea_id":"140","3":null,"core_usuario_id":null,"4":"2015-06-09 17:30:00","fec_asig":"2015-06-09 17:30:00","5":null,"core_usuario_id_resol":null,"6":null,"fec_resol":null,"7":"140","wf_tarea_id_sig":"140","8":null,"usr_asig":null,"9":null,"usr_resol":null}
2015-06 11 14:28:28  
cargar datos del sujeto(,,s,70,460)
	
				select  s.*, m.nombre as nom_muni, c.nom_cat,fec_caso
				from  wf_caso_70 w
				inner join core_sujetoverificacion  s on w.id=460 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 11 14:28:28  
tabla dat adic
	select tabla from core_sujetoverificaciontipo where id=7
2015-06 11 14:28:28  
tabla :core_sujetoverificaciongeneral
	SELECT * FROM core_sujetoverificaciongeneral where id=87101017
 fin 2015-06-11  14:28:28
/******************************************************************************************************/