2015-06 03 11:54:10 Nuevo(20348,1) Caso :172 2015-06 03 11:54:10 cargar datos del sujeto(,,s,80,172) select s.*, m.nombre as nom_muni, c.nom_cat,fec_caso from wf_caso_80 w inner join core_sujetoverificacion s on w.id=172 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 03 11:54:10 tabla dat adic select tabla from core_sujetoverificaciontipo where id=1 2015-06 03 11:54:10 tabla :persona SELECT * FROM persona where id=20348 CasoSeguimiento :716 EjecutarTarea_172() Ingreso Datos id_comp1130 133 ValidarUsuario(172):1 EjecutarPaso_318: form:100 , caso=172 id_comp 1130 Mostrar form fin 2015-06-03 11:54:10 /******************************************************************************************************/ 2015-06-03 11:54:10TraerCaso(172,80,) CargarCaso :172 2015-06 03 11:54:10 CargarDatos: Caso :172 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_80_seguimiento_id,wf_paso_id from wf_caso_80_pasos a1 group by wf_caso_80_seguimiento_id,wf_paso_id order by id )a inner join wf_caso_80_pasos p using(id,wf_caso_80_seguimiento_id) inner join ( select max(id) as wf_caso_80_seguimiento_id,wf_caso_80_id,wf_tarea_id from wf_caso_80_seguimiento where wf_caso_80_id =? group by wf_caso_80_id,wf_tarea_id order by wf_caso_80_id,wf_caso_80_seguimiento_id ) b using(wf_caso_80_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_80_seguimiento a inner join ( select max(b0.id) as id,b0.wf_caso_80_id,b0.wf_tarea_id from wf_caso_80_seguimiento b0 where b0.wf_caso_80_id =? group by b0.wf_caso_80_id,b0.wf_tarea_id order by wf_caso_80_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":"716","id":"716","1":"172","wf_caso_80_id":"172","2":"172","wf_tarea_id":"172","3":null,"core_usuario_id":null,"4":"2015-06-03 11:54:10","fec_asig":"2015-06-03 11:54:10","5":null,"core_usuario_id_resol":null,"6":null,"fec_resol":null,"7":"172","wf_tarea_id_sig":"172","8":null,"usr_asig":null,"9":null,"usr_resol":null} 2015-06 03 11:54:10 cargar datos del sujeto(,,s,80,172) select s.*, m.nombre as nom_muni, c.nom_cat,fec_caso from wf_caso_80 w inner join core_sujetoverificacion s on w.id=172 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 03 11:54:10 tabla dat adic select tabla from core_sujetoverificaciontipo where id=1 2015-06 03 11:54:10 tabla :persona SELECT * FROM persona where id=20348 fin 2015-06-03 11:54:10 /******************************************************************************************************/ 2015-06-03 11:54:12TraerCaso(172,80,) CargarCaso :172 2015-06 03 11:54:12 CargarDatos: Caso :172 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_80_seguimiento_id,wf_paso_id from wf_caso_80_pasos a1 group by wf_caso_80_seguimiento_id,wf_paso_id order by id )a inner join wf_caso_80_pasos p using(id,wf_caso_80_seguimiento_id) inner join ( select max(id) as wf_caso_80_seguimiento_id,wf_caso_80_id,wf_tarea_id from wf_caso_80_seguimiento where wf_caso_80_id =? group by wf_caso_80_id,wf_tarea_id order by wf_caso_80_id,wf_caso_80_seguimiento_id ) b using(wf_caso_80_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_80_seguimiento a inner join ( select max(b0.id) as id,b0.wf_caso_80_id,b0.wf_tarea_id from wf_caso_80_seguimiento b0 where b0.wf_caso_80_id =? group by b0.wf_caso_80_id,b0.wf_tarea_id order by wf_caso_80_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":"716","id":"716","1":"172","wf_caso_80_id":"172","2":"172","wf_tarea_id":"172","3":null,"core_usuario_id":null,"4":"2015-06-03 11:54:10","fec_asig":"2015-06-03 11:54:10","5":null,"core_usuario_id_resol":null,"6":null,"fec_resol":null,"7":"172","wf_tarea_id_sig":"172","8":null,"usr_asig":null,"9":null,"usr_resol":null} 2015-06 03 11:54:13 cargar datos del sujeto(,,s,80,172) select s.*, m.nombre as nom_muni, c.nom_cat,fec_caso from wf_caso_80 w inner join core_sujetoverificacion s on w.id=172 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 03 11:54:13 tabla dat adic select tabla from core_sujetoverificaciontipo where id=1 2015-06 03 11:54:13 tabla :persona SELECT * FROM persona where id=20348 2015-06 03 11:54:13 Continuar(s,172,318,) EjecutarTarea_172() Ingreso Datos id_comp1130 133 ValidarUsuario(172):1 EjecutarPaso_318: form:100 , caso=172 id_comp 1130 Paso::Guardar(Caso:172) Datos a guardar: Array ( [wf_proceso_id] => 80 [wf_paso_id] => 318 [wf_tarea_id] => 172 [wf_caso_id] => 172 [id] => 1130 [accion] => nextPaso [reg] => s [rta] => n [cod_formulario2] => 100 [id_periodo] => 2015 [obs_ingreso] => [cod_bloque] => 118 [oid] => [oid_maestro] => [753] => 1 ) OID: 146 rta: 1 dato:146 tabla:sce.t100 CasoPaso:576 CargarDatos_318(146) se carga 80_172_318_100_118_7531 SiguientePasoDe318: Funcion para ejecutar el siguiente paso Condicion Tarea : true TerminarTarea(172,173) Ultimo seg :716 Ultimo seg :717 EjecutarTarea_173() Inscripción id_comp1130 133 133 ValidarUsuario(173):1 EjecutarPaso_319: form:101 , caso=172 id_comp 1130 Mostrar form Retorno : Array ( [ret] => Ext.getCmp('comp_1130').removeAll();Ext.getCmp('comp_1130').add(new Ext.form.FormPanel({ title: 'General' ,padding: 10,id:'frm_formulario_80_172',autoScroll:true ,labelAlign:'top',defaults: { anchor: '97%'} ,items: [new Ext.form.Hidden({name:'cod_formulario2',value:'101'}) ,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:'119'}) ,new Ext.form.Hidden({name :'oid',value:''}) ,new Ext.form.Hidden({name :'oid_maestro',value:''}) ,new Ext.form.RadioGroup({columns:2,items:[ new Ext.form.Radio({name:'754',id:'754_1',inputValue:1,boxLabel:'Profesional independiente'}), new Ext.form.Radio({name:'754',id:'754_3',inputValue:3,boxLabel:'Objeto social diferente'}), new Ext.form.Radio({name:'754',id:'754_4',inputValue:4,boxLabel:'transporte especial de pacientes (ambulancias)'}), new Ext.form.Radio({name:'754',id:'754_2',inputValue:2,boxLabel:'instituciones prestadoras de Salud (IPS públicas y privadas)'}) ],columns:1,allowBlank:false,fieldLabel:'* Tipo de solicitud del tramite',id:'754'}) ] ,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_80_172'); 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:'80',wf_paso_id:'319',wf_tarea_id:'173',wf_caso_id:'172',id:'1130',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_80_172').getForm().loadRecord(new Ext.data.Record({"cod_formulario":101,"oid_maestro":null,"cod_bloque":119})); llamadaAJAX({url:'http://192.168.10.116/sisad/build/view/workflow/casos/casos_datosForm.php',mostrarMsg:false,params:{accion:'verifica',wf_paso_id:'319',cod_formulario:'101',cod_bloque:'119',wf_caso_id:'{"pro":"80","cas":"172"}'}}); }catch(e){alert(e);} } } }) );Ext.getCmp('comp_1130').doLayout(); [suc] => 1 ) fin 2015-06-03 11:54:13 /******************************************************************************************************/ 2015-06-03 11:54:14TraerCaso(172,80,) CargarCaso :172 2015-06 03 11:54:14 CargarDatos: Caso :172 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_80_seguimiento_id,wf_paso_id from wf_caso_80_pasos a1 group by wf_caso_80_seguimiento_id,wf_paso_id order by id )a inner join wf_caso_80_pasos p using(id,wf_caso_80_seguimiento_id) inner join ( select max(id) as wf_caso_80_seguimiento_id,wf_caso_80_id,wf_tarea_id from wf_caso_80_seguimiento where wf_caso_80_id =? group by wf_caso_80_id,wf_tarea_id order by wf_caso_80_id,wf_caso_80_seguimiento_id ) b using(wf_caso_80_seguimiento_id) left join usuarios u using(core_usuario_id) {"0":"576","id":"576","1":"318","wf_paso_id":"318","2":"716","wf_caso_80_seguimiento_id":"716","3":"133","core_usuario_id":"133","4":"2015-06-03 11:54:13","fecha_ejec":"2015-06-03 11:54:13","5":"146","dato":"146","6":"sce.t100","tabla":"sce.t100","7":"172","tarea_id":"172","8":"Pinchao German: ciudadano","usr_ejec":"Pinchao German: ciudadano"} CargarDatos_318(146) se carga 80_172_318_100_118_7531 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_80_seguimiento a inner join ( select max(b0.id) as id,b0.wf_caso_80_id,b0.wf_tarea_id from wf_caso_80_seguimiento b0 where b0.wf_caso_80_id =? group by b0.wf_caso_80_id,b0.wf_tarea_id order by wf_caso_80_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":"716","id":"716","1":"172","wf_caso_80_id":"172","2":"172","wf_tarea_id":"172","3":null,"core_usuario_id":null,"4":"2015-06-03 11:54:10","fec_asig":"2015-06-03 11:54:10","5":"133","core_usuario_id_resol":"133","6":"2015-06-03 11:54:13","fec_resol":"2015-06-03 11:54:13","7":"172","wf_tarea_id_sig":"172","8":null,"usr_asig":null,"9":"Pinchao German: ciudadano","usr_resol":"Pinchao German: ciudadano"} {"0":"717","id":"717","1":"172","wf_caso_80_id":"172","2":"173","wf_tarea_id":"173","3":"133","core_usuario_id":"133","4":"2015-06-03 11:54:13","fec_asig":"2015-06-03 11:54:13","5":null,"core_usuario_id_resol":null,"6":null,"fec_resol":null,"7":"173","wf_tarea_id_sig":"173","8":"Pinchao German: ciudadano","usr_asig":"Pinchao German: ciudadano","9":null,"usr_resol":null} 2015-06 03 11:54:14 cargar datos del sujeto(,,s,80,172) select s.*, m.nombre as nom_muni, c.nom_cat,fec_caso from wf_caso_80 w inner join core_sujetoverificacion s on w.id=172 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 03 11:54:14 tabla dat adic select tabla from core_sujetoverificaciontipo where id=1 2015-06 03 11:54:14 tabla :persona SELECT * FROM persona where id=20348 fin 2015-06-03 11:54:14 /******************************************************************************************************/ 2015-06-03 11:54:15TraerCaso(172,80,) CargarCaso :172 2015-06 03 11:54:15 CargarDatos: Caso :172 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_80_seguimiento_id,wf_paso_id from wf_caso_80_pasos a1 group by wf_caso_80_seguimiento_id,wf_paso_id order by id )a inner join wf_caso_80_pasos p using(id,wf_caso_80_seguimiento_id) inner join ( select max(id) as wf_caso_80_seguimiento_id,wf_caso_80_id,wf_tarea_id from wf_caso_80_seguimiento where wf_caso_80_id =? group by wf_caso_80_id,wf_tarea_id order by wf_caso_80_id,wf_caso_80_seguimiento_id ) b using(wf_caso_80_seguimiento_id) left join usuarios u using(core_usuario_id) {"0":"576","id":"576","1":"318","wf_paso_id":"318","2":"716","wf_caso_80_seguimiento_id":"716","3":"133","core_usuario_id":"133","4":"2015-06-03 11:54:13","fecha_ejec":"2015-06-03 11:54:13","5":"146","dato":"146","6":"sce.t100","tabla":"sce.t100","7":"172","tarea_id":"172","8":"Pinchao German: ciudadano","usr_ejec":"Pinchao German: ciudadano"} CargarDatos_318(146) se carga 80_172_318_100_118_7531 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_80_seguimiento a inner join ( select max(b0.id) as id,b0.wf_caso_80_id,b0.wf_tarea_id from wf_caso_80_seguimiento b0 where b0.wf_caso_80_id =? group by b0.wf_caso_80_id,b0.wf_tarea_id order by wf_caso_80_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":"716","id":"716","1":"172","wf_caso_80_id":"172","2":"172","wf_tarea_id":"172","3":null,"core_usuario_id":null,"4":"2015-06-03 11:54:10","fec_asig":"2015-06-03 11:54:10","5":"133","core_usuario_id_resol":"133","6":"2015-06-03 11:54:13","fec_resol":"2015-06-03 11:54:13","7":"172","wf_tarea_id_sig":"172","8":null,"usr_asig":null,"9":"Pinchao German: ciudadano","usr_resol":"Pinchao German: ciudadano"} {"0":"717","id":"717","1":"172","wf_caso_80_id":"172","2":"173","wf_tarea_id":"173","3":"133","core_usuario_id":"133","4":"2015-06-03 11:54:13","fec_asig":"2015-06-03 11:54:13","5":null,"core_usuario_id_resol":null,"6":null,"fec_resol":null,"7":"173","wf_tarea_id_sig":"173","8":"Pinchao German: ciudadano","usr_asig":"Pinchao German: ciudadano","9":null,"usr_resol":null} 2015-06 03 11:54:15 cargar datos del sujeto(,,s,80,172) select s.*, m.nombre as nom_muni, c.nom_cat,fec_caso from wf_caso_80 w inner join core_sujetoverificacion s on w.id=172 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 03 11:54:15 tabla dat adic select tabla from core_sujetoverificaciontipo where id=1 2015-06 03 11:54:15 tabla :persona SELECT * FROM persona where id=20348 2015-06 03 11:54:15 Continuar(s,173,319,) EjecutarTarea_173() Inscripción id_comp1130 133 133 ValidarUsuario(173):1 EjecutarPaso_319: form:101 , caso=172 id_comp 1130 Paso::Guardar(Caso:172) Datos a guardar: Array ( [wf_proceso_id] => 80 [wf_paso_id] => 319 [wf_tarea_id] => 173 [wf_caso_id] => 172 [id] => 1130 [accion] => nextPaso [reg] => s [rta] => n [cod_formulario2] => 101 [id_periodo] => 2015 [obs_ingreso] => [cod_bloque] => 119 [oid] => [oid_maestro] => [754] => 1 ) OID: 120 rta: 1 dato:120 tabla:sce.t101 CasoPaso:577 CargarDatos_319(120) se carga 80_173_319_101_119_7541 SiguientePasoDe319: Funcion para ejecutar el siguiente paso Condicion Tarea : 1 ==1 && 1 ==1 TerminarTarea(173,175) Ultimo seg :717 Ultimo seg :718 EjecutarTarea_175() adj_ins_prof_independiente id_comp1130 133 133 ValidarUsuario(175):1 EjecutarPaso_321: ladj:17 , caso=172 id_comp 1130 Mostrar ladj Retorno : Array ( [ret] => inicioComponente_WF_ladj({"tarea_id":175,"paso_id":321,"id":"1130","proceso_id":80,"caso_id":"172","sujeto_id":"20348","ladj":17}); [suc] => 1 ) fin 2015-06-03 11:54:15 /******************************************************************************************************/ 2015-06-03 11:54:44TraerCaso(172,80,) CargarCaso :172 2015-06 03 11:54:44 CargarDatos: Caso :172 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_80_seguimiento_id,wf_paso_id from wf_caso_80_pasos a1 group by wf_caso_80_seguimiento_id,wf_paso_id order by id )a inner join wf_caso_80_pasos p using(id,wf_caso_80_seguimiento_id) inner join ( select max(id) as wf_caso_80_seguimiento_id,wf_caso_80_id,wf_tarea_id from wf_caso_80_seguimiento where wf_caso_80_id =? group by wf_caso_80_id,wf_tarea_id order by wf_caso_80_id,wf_caso_80_seguimiento_id ) b using(wf_caso_80_seguimiento_id) left join usuarios u using(core_usuario_id) {"0":"576","id":"576","1":"318","wf_paso_id":"318","2":"716","wf_caso_80_seguimiento_id":"716","3":"133","core_usuario_id":"133","4":"2015-06-03 11:54:13","fecha_ejec":"2015-06-03 11:54:13","5":"146","dato":"146","6":"sce.t100","tabla":"sce.t100","7":"172","tarea_id":"172","8":"Pinchao German: ciudadano","usr_ejec":"Pinchao German: ciudadano"} CargarDatos_318(146) se carga 80_172_318_100_118_7531 {"0":"577","id":"577","1":"319","wf_paso_id":"319","2":"717","wf_caso_80_seguimiento_id":"717","3":"133","core_usuario_id":"133","4":"2015-06-03 11:54:15","fecha_ejec":"2015-06-03 11:54:15","5":"120","dato":"120","6":"sce.t101","tabla":"sce.t101","7":"173","tarea_id":"173","8":"Pinchao German: ciudadano","usr_ejec":"Pinchao German: ciudadano"} CargarDatos_319(120) se carga 80_173_319_101_119_7541 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_80_seguimiento a inner join ( select max(b0.id) as id,b0.wf_caso_80_id,b0.wf_tarea_id from wf_caso_80_seguimiento b0 where b0.wf_caso_80_id =? group by b0.wf_caso_80_id,b0.wf_tarea_id order by wf_caso_80_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":"716","id":"716","1":"172","wf_caso_80_id":"172","2":"172","wf_tarea_id":"172","3":null,"core_usuario_id":null,"4":"2015-06-03 11:54:10","fec_asig":"2015-06-03 11:54:10","5":"133","core_usuario_id_resol":"133","6":"2015-06-03 11:54:13","fec_resol":"2015-06-03 11:54:13","7":"172","wf_tarea_id_sig":"172","8":null,"usr_asig":null,"9":"Pinchao German: ciudadano","usr_resol":"Pinchao German: ciudadano"} {"0":"717","id":"717","1":"172","wf_caso_80_id":"172","2":"173","wf_tarea_id":"173","3":"133","core_usuario_id":"133","4":"2015-06-03 11:54:13","fec_asig":"2015-06-03 11:54:13","5":"133","core_usuario_id_resol":"133","6":"2015-06-03 11:54:15","fec_resol":"2015-06-03 11:54:15","7":"173","wf_tarea_id_sig":"173","8":"Pinchao German: ciudadano","usr_asig":"Pinchao German: ciudadano","9":"Pinchao German: ciudadano","usr_resol":"Pinchao German: ciudadano"} {"0":"718","id":"718","1":"172","wf_caso_80_id":"172","2":"175","wf_tarea_id":"175","3":"133","core_usuario_id":"133","4":"2015-06-03 11:54:15","fec_asig":"2015-06-03 11:54:15","5":null,"core_usuario_id_resol":null,"6":null,"fec_resol":null,"7":"175","wf_tarea_id_sig":"175","8":"Pinchao German: ciudadano","usr_asig":"Pinchao German: ciudadano","9":null,"usr_resol":null} 2015-06 03 11:54:44 cargar datos del sujeto(,,s,80,172) select s.*, m.nombre as nom_muni, c.nom_cat,fec_caso from wf_caso_80 w inner join core_sujetoverificacion s on w.id=172 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 03 11:54:44 tabla dat adic select tabla from core_sujetoverificaciontipo where id=1 2015-06 03 11:54:44 tabla :persona SELECT * FROM persona where id=20348 2015-06 03 11:54:44 Continuar(s,175,321,) EjecutarTarea_175() adj_ins_prof_independiente id_comp1130 133 133 ValidarUsuario(175):1 EjecutarPaso_321: ladj:17 , caso=172 id_comp 1130 Paso::Guardar(Caso:172) rta: 1 dato:1577 tabla:wf_documentoentradaadj_caso CasoPaso:578 CargarDatos_321(1577) SiguientePasoDe321: Funcion para ejecutar el siguiente paso Condicion Tarea : true TerminarTarea(175,196) Ultimo seg :718 Ultimo seg :719 EjecutarTarea_196() correo registro info id_comp1130 133 133 ValidarUsuario(196):1 EjecutarPaso_346: corr:56 , caso=172 id_comp 1130 Mostrar corr ob_start(); $ciud = mb_strtoupper( "{ WFSV_79 } { WFSV_80 }",'utf-8'); ?>

Apreciado(a)

El presente mensaje es una notificación para el caso No


{ WFSV_76 } TWFSV_76:desarrollo4@gmail.com Registro exitoso Retorno : Array ( [ret] => inicioComponente_WF_Correo({"id":"1130","caso_id":"172","proceso_id":80,"tit":"correo registro info","tarea_id":196,"paso_id":346,"desc":"

\r\nApreciado(a)
\r\nGERMAN PINCHAO<\/strong>\r\n

\r\n

El presente mensaje es una notificación para el caso No 172<\/strong> <\/p>\r\nSu registro de informaci\u00f3n para certificado de inscripci\u00f3n y novedades en el registro especial de prestadores de salud se realizo exitosamente.

<\/strong> ","url":"De click aqui para volver a enviar el correo<\/a><\/div>"}); [suc] => 1 ) fin 2015-06-03 11:54:44 /******************************************************************************************************/ 2015-06-03 11:54:50TraerCaso(172,80,) CargarCaso :172 2015-06 03 11:54:50 CargarDatos: Caso :172 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_80_seguimiento_id,wf_paso_id from wf_caso_80_pasos a1 group by wf_caso_80_seguimiento_id,wf_paso_id order by id )a inner join wf_caso_80_pasos p using(id,wf_caso_80_seguimiento_id) inner join ( select max(id) as wf_caso_80_seguimiento_id,wf_caso_80_id,wf_tarea_id from wf_caso_80_seguimiento where wf_caso_80_id =? group by wf_caso_80_id,wf_tarea_id order by wf_caso_80_id,wf_caso_80_seguimiento_id ) b using(wf_caso_80_seguimiento_id) left join usuarios u using(core_usuario_id) {"0":"576","id":"576","1":"318","wf_paso_id":"318","2":"716","wf_caso_80_seguimiento_id":"716","3":"133","core_usuario_id":"133","4":"2015-06-03 11:54:13","fecha_ejec":"2015-06-03 11:54:13","5":"146","dato":"146","6":"sce.t100","tabla":"sce.t100","7":"172","tarea_id":"172","8":"Pinchao German: ciudadano","usr_ejec":"Pinchao German: ciudadano"} CargarDatos_318(146) se carga 80_172_318_100_118_7531 {"0":"577","id":"577","1":"319","wf_paso_id":"319","2":"717","wf_caso_80_seguimiento_id":"717","3":"133","core_usuario_id":"133","4":"2015-06-03 11:54:15","fecha_ejec":"2015-06-03 11:54:15","5":"120","dato":"120","6":"sce.t101","tabla":"sce.t101","7":"173","tarea_id":"173","8":"Pinchao German: ciudadano","usr_ejec":"Pinchao German: ciudadano"} CargarDatos_319(120) se carga 80_173_319_101_119_7541 {"0":"578","id":"578","1":"321","wf_paso_id":"321","2":"718","wf_caso_80_seguimiento_id":"718","3":"133","core_usuario_id":"133","4":"2015-06-03 11:54:44","fecha_ejec":"2015-06-03 11:54:44","5":"1577","dato":"1577","6":"wf_documentoentradaadj_caso","tabla":"wf_documentoentradaadj_caso","7":"175","tarea_id":"175","8":"Pinchao German: ciudadano","usr_ejec":"Pinchao German: ciudadano"} CargarDatos_321(1577) 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_80_seguimiento a inner join ( select max(b0.id) as id,b0.wf_caso_80_id,b0.wf_tarea_id from wf_caso_80_seguimiento b0 where b0.wf_caso_80_id =? group by b0.wf_caso_80_id,b0.wf_tarea_id order by wf_caso_80_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":"716","id":"716","1":"172","wf_caso_80_id":"172","2":"172","wf_tarea_id":"172","3":null,"core_usuario_id":null,"4":"2015-06-03 11:54:10","fec_asig":"2015-06-03 11:54:10","5":"133","core_usuario_id_resol":"133","6":"2015-06-03 11:54:13","fec_resol":"2015-06-03 11:54:13","7":"172","wf_tarea_id_sig":"172","8":null,"usr_asig":null,"9":"Pinchao German: ciudadano","usr_resol":"Pinchao German: ciudadano"} {"0":"717","id":"717","1":"172","wf_caso_80_id":"172","2":"173","wf_tarea_id":"173","3":"133","core_usuario_id":"133","4":"2015-06-03 11:54:13","fec_asig":"2015-06-03 11:54:13","5":"133","core_usuario_id_resol":"133","6":"2015-06-03 11:54:15","fec_resol":"2015-06-03 11:54:15","7":"173","wf_tarea_id_sig":"173","8":"Pinchao German: ciudadano","usr_asig":"Pinchao German: ciudadano","9":"Pinchao German: ciudadano","usr_resol":"Pinchao German: ciudadano"} {"0":"718","id":"718","1":"172","wf_caso_80_id":"172","2":"175","wf_tarea_id":"175","3":"133","core_usuario_id":"133","4":"2015-06-03 11:54:15","fec_asig":"2015-06-03 11:54:15","5":"133","core_usuario_id_resol":"133","6":"2015-06-03 11:54:44","fec_resol":"2015-06-03 11:54:44","7":"175","wf_tarea_id_sig":"175","8":"Pinchao German: ciudadano","usr_asig":"Pinchao German: ciudadano","9":"Pinchao German: ciudadano","usr_resol":"Pinchao German: ciudadano"} {"0":"719","id":"719","1":"172","wf_caso_80_id":"172","2":"196","wf_tarea_id":"196","3":"133","core_usuario_id":"133","4":"2015-06-03 11:54:44","fec_asig":"2015-06-03 11:54:44","5":null,"core_usuario_id_resol":null,"6":null,"fec_resol":null,"7":"196","wf_tarea_id_sig":"196","8":"Pinchao German: ciudadano","usr_asig":"Pinchao German: ciudadano","9":null,"usr_resol":null} 2015-06 03 11:54:50 cargar datos del sujeto(,,s,80,172) select s.*, m.nombre as nom_muni, c.nom_cat,fec_caso from wf_caso_80 w inner join core_sujetoverificacion s on w.id=172 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 03 11:54:50 tabla dat adic select tabla from core_sujetoverificaciontipo where id=1 2015-06 03 11:54:50 tabla :persona SELECT * FROM persona where id=20348 2015-06 03 11:54:50 Continuar(s,196,346,) EjecutarTarea_196() correo registro info id_comp1130 133 133 ValidarUsuario(196):1 EjecutarPaso_346: corr:56 , caso=172 id_comp 1130 Paso::Guardar(Caso:172) rta: 1 dato: tabla: CasoPaso:579 CargarDatos_346() SiguientePasoDe346: Funcion para ejecutar el siguiente paso Condicion Tarea : 1==1 && 1 ==3 Condicion Tarea : 1==1 && 1 ==1 TerminarTarea(196,203) Ultimo seg :719 Ultimo seg :720 EjecutarTarea_203() verificacion_adj_ins_prof id_comp1130 133 ValidarUsuario(203): Retorno : Array ( [htm] => [suc] => 1 [ret] => crearMsg('Usted no puede ejecutar la tarea actual del proceso, Debe esperar a que un usuario con los privilegios adecuados la ejecute.','Información');Ext.getCmp('comp_1130').funcionInicial('n'); ) fin 2015-06-03 11:54:50 /******************************************************************************************************/