2015-07-28 16:33:16TraerCaso(16997,71,)
CargarCaso :16997
2015-07 28 16:33:16
CargarDatos: Caso :16997
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_71_seguimiento_id,wf_paso_id from wf_caso_71_pasos a1 group by wf_caso_71_seguimiento_id,wf_paso_id order by id
)a
inner join wf_caso_71_pasos p using(id,wf_caso_71_seguimiento_id)
inner join ( select max(id) as wf_caso_71_seguimiento_id,wf_caso_71_id,wf_tarea_id from wf_caso_71_seguimiento where wf_caso_71_id =? group by wf_caso_71_id,wf_tarea_id order by wf_caso_71_id,wf_caso_71_seguimiento_id ) b using(wf_caso_71_seguimiento_id)
left join usuarios u using(core_usuario_id)
{"0":"153452","id":"153452","1":"261","wf_paso_id":"261","2":"74686","wf_caso_71_seguimiento_id":"74686","3":"194","core_usuario_id":"194","4":"2015-01-10 13:12:20","fecha_ejec":"2015-01-10 13:12:20","5":null,"dato":null,"6":null,"tabla":null,"7":"190","tarea_id":"190","8":"OCAMPO AREVALO GERMAN EMILIO: Medicos CRUE","usr_ejec":"OCAMPO AREVALO GERMAN EMILIO: Medicos CRUE"}
CargarDatos_261()
{"0":"153453","id":"153453","1":"259","wf_paso_id":"259","2":"74686","wf_caso_71_seguimiento_id":"74686","3":"194","core_usuario_id":"194","4":"2015-01-10 13:14:10","fecha_ejec":"2015-01-10 13:14:10","5":"117253884","dato":"117253884","6":"sce.t4","tabla":"sce.t4","7":"190","tarea_id":"190","8":"OCAMPO AREVALO GERMAN EMILIO: Medicos CRUE","usr_ejec":"OCAMPO AREVALO GERMAN EMILIO: Medicos CRUE"}
CargarDatos_259(117253884)
se carga 71_190_259_4_27_4812
se carga 71_190_259_4_27_4805 HORAS
se carga 71_190_259_4_27_47958
se carga 71_190_259_4_27_10643187875743
se carga 71_190_259_4_27_1063DANIELA DEL CARMEN
se carga 71_190_259_4_27_1062LOPEZ
se carga 71_190_259_4_27_10611004472023
se carga 71_190_259_4_27_10601
{"0":"153454","id":"153454","1":"260","wf_paso_id":"260","2":"74686","wf_caso_71_seguimiento_id":"74686","3":"194","core_usuario_id":"194","4":"2015-01-10 13:24:44","fecha_ejec":"2015-01-10 13:24:44","5":"117436319","dato":"117436319","6":"sce.t1","tabla":"sce.t1","7":"190","tarea_id":"190","8":"OCAMPO AREVALO GERMAN EMILIO: Medicos CRUE","usr_ejec":"OCAMPO AREVALO GERMAN EMILIO: Medicos CRUE"}
CargarDatos_260(117436319)
se carga 71_190_260_1_1_55RNAT DE 40 SEMANAS, SEXO: MASCULINO, PARTO NORMAL HACE 5 HORAS, EN EL MOMENTO NO SUCCIONA, PESO:3100 GR, TALLA:50, GLUCOMETRIA: 100 MG/DL, PERMANECE MUY DORMIDO Y NO SUCCIONA, MADRE CON PEZONES INVERTIDOS, RIESGO DE HIPOGLICEMIA
se carga 71_190_260_1_1_54SUCCION NULA DEL RECIEN NACIDO
se carga 71_190_260_1_1_516229
se carga 71_190_260_1_1_5053
se carga 71_190_260_1_1_493
se carga 71_190_260_1_1_49196
se carga 71_190_260_1_1_49014/15
se carga 71_190_260_1_1_4954578
se carga 71_190_260_1_1_4892
se carga 71_190_260_1_1_48837
se carga 71_190_260_1_1_48741
se carga 71_190_260_1_1_486100
se carga 71_190_260_1_1_485
se carga 71_190_260_1_1_478COMFAMILIAR
se carga 71_190_260_1_1_477NEONATOS BASICO
se carga 71_190_260_1_1_475DR. JORGE MUÑOZ
{"0":"153518","id":"153518","1":"263","wf_paso_id":"263","2":"74714","wf_caso_71_seguimiento_id":"74714","3":"194","core_usuario_id":"194","4":"2015-01-11 15:13:45","fecha_ejec":"2015-01-11 15:13:45","5":null,"dato":null,"6":null,"tabla":null,"7":"192","tarea_id":"192","8":"OCAMPO AREVALO GERMAN EMILIO: Medicos CRUE","usr_ejec":"OCAMPO AREVALO GERMAN EMILIO: Medicos CRUE"}
CargarDatos_263()
{"0":"153519","id":"153519","1":"264","wf_paso_id":"264","2":"74714","wf_caso_71_seguimiento_id":"74714","3":"194","core_usuario_id":"194","4":"2015-01-11 15:14:18","fecha_ejec":"2015-01-11 15:14:18","5":null,"dato":null,"6":"wf_registrollamada","tabla":"wf_registrollamada","7":"192","tarea_id":"192","8":"OCAMPO AREVALO GERMAN EMILIO: Medicos CRUE","usr_ejec":"OCAMPO AREVALO GERMAN EMILIO: Medicos CRUE"}
CargarDatos_264()
{"0":"153520","id":"153520","1":"265","wf_paso_id":"265","2":"74715","wf_caso_71_seguimiento_id":"74715","3":"194","core_usuario_id":"194","4":"2015-01-11 15:14:20","fecha_ejec":"2015-01-11 15:14:20","5":null,"dato":null,"6":null,"tabla":null,"7":"194","tarea_id":"194","8":"OCAMPO AREVALO GERMAN EMILIO: Medicos CRUE","usr_ejec":"OCAMPO AREVALO GERMAN EMILIO: Medicos CRUE"}
CargarDatos_265()
{"0":"153521","id":"153521","1":"269","wf_paso_id":"269","2":"74715","wf_caso_71_seguimiento_id":"74715","3":"194","core_usuario_id":"194","4":"2015-01-11 15:15:15","fecha_ejec":"2015-01-11 15:15:15","5":"117436335","dato":"117436335","6":"sce.t6","tabla":"sce.t6","7":"194","tarea_id":"194","8":"OCAMPO AREVALO GERMAN EMILIO: Medicos CRUE","usr_ejec":"OCAMPO AREVALO GERMAN EMILIO: Medicos CRUE"}
CargarDatos_269(117436335)
se carga 71_194_269_6_31_500CANCELA LA REMISION NO ERA PERTINENTE, DIO SALIDA, EL BEBE YA SE ESTA AMAMANTANDO NORMALMENTE<br>
se carga 71_194_269_6_31_499DR. JORGE MUÑOZ
se carga 71_194_269_6_31_49854578
{"0":"153522","id":"153522","1":"266","wf_paso_id":"266","2":"74716","wf_caso_71_seguimiento_id":"74716","3":"194","core_usuario_id":"194","4":"2015-01-11 15:15:18","fecha_ejec":"2015-01-11 15:15:18","5":null,"dato":null,"6":null,"tabla":null,"7":"195","tarea_id":"195","8":"OCAMPO AREVALO GERMAN EMILIO: Medicos CRUE","usr_ejec":"OCAMPO AREVALO GERMAN EMILIO: Medicos CRUE"}
CargarDatos_266()
{"0":"153523","id":"153523","1":"267","wf_paso_id":"267","2":"74716","wf_caso_71_seguimiento_id":"74716","3":"194","core_usuario_id":"194","4":"2015-01-11 15:15:31","fecha_ejec":"2015-01-11 15:15:31","5":null,"dato":null,"6":"wf_registrollamada","tabla":"wf_registrollamada","7":"195","tarea_id":"195","8":"OCAMPO AREVALO GERMAN EMILIO: Medicos CRUE","usr_ejec":"OCAMPO AREVALO GERMAN EMILIO: Medicos CRUE"}
CargarDatos_267()
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_71_seguimiento a
inner join (
select max(b0.id) as id,b0.wf_caso_71_id,b0.wf_tarea_id from wf_caso_71_seguimiento b0 where b0.wf_caso_71_id =? group by b0.wf_caso_71_id,b0.wf_tarea_id order by wf_caso_71_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":"74686","id":"74686","1":"16997","wf_caso_71_id":"16997","2":"190","wf_tarea_id":"190","3":null,"core_usuario_id":null,"4":"2015-01-10 13:12:20","fec_asig":"2015-01-10 13:12:20","5":"194","core_usuario_id_resol":"194","6":"2015-01-11 15:13:28","fec_resol":"2015-01-11 15:13:28","7":"190","wf_tarea_id_sig":"190","8":null,"usr_asig":null,"9":"OCAMPO AREVALO GERMAN EMILIO: Medicos CRUE","usr_resol":"OCAMPO AREVALO GERMAN EMILIO: Medicos CRUE"}
{"0":"74714","id":"74714","1":"16997","wf_caso_71_id":"16997","2":"192","wf_tarea_id":"192","3":"194","core_usuario_id":"194","4":"2015-01-11 15:13:28","fec_asig":"2015-01-11 15:13:28","5":"194","core_usuario_id_resol":"194","6":"2015-01-11 15:14:18","fec_resol":"2015-01-11 15:14:18","7":"192","wf_tarea_id_sig":"192","8":"OCAMPO AREVALO GERMAN EMILIO: Medicos CRUE","usr_asig":"OCAMPO AREVALO GERMAN EMILIO: Medicos CRUE","9":"OCAMPO AREVALO GERMAN EMILIO: Medicos CRUE","usr_resol":"OCAMPO AREVALO GERMAN EMILIO: Medicos CRUE"}
{"0":"74715","id":"74715","1":"16997","wf_caso_71_id":"16997","2":"194","wf_tarea_id":"194","3":"194","core_usuario_id":"194","4":"2015-01-11 15:14:18","fec_asig":"2015-01-11 15:14:18","5":"194","core_usuario_id_resol":"194","6":"2015-01-11 15:15:15","fec_resol":"2015-01-11 15:15:15","7":"194","wf_tarea_id_sig":"194","8":"OCAMPO AREVALO GERMAN EMILIO: Medicos CRUE","usr_asig":"OCAMPO AREVALO GERMAN EMILIO: Medicos CRUE","9":"OCAMPO AREVALO GERMAN EMILIO: Medicos CRUE","usr_resol":"OCAMPO AREVALO GERMAN EMILIO: Medicos CRUE"}
{"0":"74716","id":"74716","1":"16997","wf_caso_71_id":"16997","2":"195","wf_tarea_id":"195","3":"194","core_usuario_id":"194","4":"2015-01-11 15:15:15","fec_asig":"2015-01-11 15:15:15","5":"194","core_usuario_id_resol":"194","6":"2015-01-11 15:15:31","fec_resol":"2015-01-11 15:15:31","7":"195","wf_tarea_id_sig":"195","8":"OCAMPO AREVALO GERMAN EMILIO: Medicos CRUE","usr_asig":"OCAMPO AREVALO GERMAN EMILIO: Medicos CRUE","9":"OCAMPO AREVALO GERMAN EMILIO: Medicos CRUE","usr_resol":"OCAMPO AREVALO GERMAN EMILIO: Medicos CRUE"}
{"0":"74717","id":"74717","1":"16997","wf_caso_71_id":"16997","2":"196","wf_tarea_id":"196","3":"194","core_usuario_id":"194","4":"2015-01-11 15:15:31","fec_asig":"2015-01-11 15:15:31","5":null,"core_usuario_id_resol":null,"6":null,"fec_resol":null,"7":"196","wf_tarea_id_sig":"196","8":"OCAMPO AREVALO GERMAN EMILIO: Medicos CRUE","usr_asig":"OCAMPO AREVALO GERMAN EMILIO: Medicos CRUE","9":null,"usr_resol":null}
2015-07 28 16:33:18
cargar datos del sujeto(,,s,71,16997)
select s.*, m.nombre as nom_muni, c.nom_cat,fec_caso
from wf_caso_71 w
inner join core_sujetoverificacion s on w.id=16997 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 28 16:33:18
tabla dat adic
select tabla from core_sujetoverificaciontipo where id=6
2015-07 28 16:33:18
tabla :core_sujetoverificacion_paciente
SELECT * FROM core_sujetoverificacion_paciente where id=0
2015-07 28 16:33:18
Continuar(n,,,)
EjecutarTarea_196() Terminación id_comp391
194 1
ValidarUsuario(196):1
EjecutarPaso_270: form:20 , caso=16997 id_comp 391
Mostrar form
Retorno :
Array
(
[ret] => Ext.getCmp('comp_391').removeAll();Ext.getCmp('comp_391').add(new Ext.form.FormPanel({ title: 'General' ,padding: 10,id:'frm_formulario_71_16997',autoScroll:true ,labelAlign:'top',defaults: { anchor: '97%'} ,items: [new Ext.form.Hidden({name:'cod_formulario2',value:'20'}) ,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:'49'}) ,new Ext.form.Hidden({name :'oid',value:''}) ,new Ext.form.RadioGroup({columns:2,items:[ new Ext.form.Radio({name:'577',id:'577_1',inputValue:1,boxLabel:'Terminar'}), new Ext.form.Radio({name:'577',id:'577_2',inputValue:2,boxLabel:'Cancelar'}) ],columns:2,fieldLabel:'Terminar',id:'577'}) ] ,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_71_16997'); 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:'71',wf_paso_id:'270',wf_tarea_id:'196',wf_caso_id:'16997',id:'391',accion:'nextPaso',reg:'s',rta:'n'},success:function(form, action){if(action.result.message) crearMsg(action.result.message,'Informacion');else if(action.result.execute){/*try{*/eval(action.result.execute);/*}catch(e){alert(e+'Se presentó un error , por favor cierre la pestaña del caso y continue el proceso desde la pestaña de resumen' );}*/}},failure: function(form, action) {switch (action.failureType) {case Ext.form.Action.CONNECT_FAILURE:Ext.Msg.alert('Error', 'No hay comunicacion con el servidor');break;case Ext.form.Action.SERVER_INVALID: Ext.Msg.alert('Error', action.result.message); break; }}});}}else{Ext.MessageBox.alert('Advertencia',getErrorFields(f));}} } ] ,listeners:{ afterrender:function(){ try{ Ext.getCmp('frm_formulario_71_16997').getForm().loadRecord(new Ext.data.Record({"cod_formulario":20,"cod_bloque":49})); llamadaAJAX({url:'http://192.168.10.116/sisad/build/view/workflow/casos/casos_datosForm.php',mostrarMsg:false,params:{accion:'verifica',wf_paso_id:'270',cod_formulario:'20',cod_bloque:'49',wf_caso_id:'{"pro":"71","cas":"16997"}'}}); }catch(e){alert(e);}} } }) );Ext.getCmp('comp_391').doLayout();
[suc] => 1
)
fin 2015-07-28 16:33:18
/******************************************************************************************************/