2015-06 12 11:29:51  
Nuevo(65,1)
		Caso :85 
2015-06 12 11:29:51  
cargar datos del sujeto(,,s,85,85)
	
				select  s.*, m.nombre as nom_muni, c.nom_cat,fec_caso
				from  wf_caso_85 w
				inner join core_sujetoverificacion  s on w.id=85 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 12 11:29:51  
tabla dat adic
	select tabla from core_sujetoverificaciontipo where id=1
2015-06 12 11:29:51  
tabla :persona
	SELECT * FROM persona where id=65
		CasoSeguimiento :378 
	EjecutarTarea_89() Ingreso de datos id_comp1223
				  35
		ValidarUsuario(89):1
			EjecutarPaso_189: form:20 , caso=85 id_comp 1223
				Mostrar form
 fin 2015-06-12  11:29:52
/******************************************************************************************************/

2015-06-12 11:29:52TraerCaso(85,85,)
 CargarCaso :85
2015-06 12 11:29:52  
CargarDatos: Caso :85
	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_85_seguimiento_id,wf_paso_id from wf_caso_85_pasos a1  group by wf_caso_85_seguimiento_id,wf_paso_id order by id
				)a
				inner join wf_caso_85_pasos p using(id,wf_caso_85_seguimiento_id)
				inner join ( select max(id) as wf_caso_85_seguimiento_id,wf_caso_85_id,wf_tarea_id from wf_caso_85_seguimiento where wf_caso_85_id =? group by wf_caso_85_id,wf_tarea_id order by wf_caso_85_id,wf_caso_85_seguimiento_id  ) b using(wf_caso_85_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_85_seguimiento a
				inner join (
				select max(b0.id) as id,b0.wf_caso_85_id,b0.wf_tarea_id from wf_caso_85_seguimiento b0  where b0.wf_caso_85_id =? group by b0.wf_caso_85_id,b0.wf_tarea_id order by wf_caso_85_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":"378","id":"378","1":"85","wf_caso_85_id":"85","2":"89","wf_tarea_id":"89","3":null,"core_usuario_id":null,"4":"2015-06-12 11:29:51","fec_asig":"2015-06-12 11:29:51","5":null,"core_usuario_id_resol":null,"6":null,"fec_resol":null,"7":"89","wf_tarea_id_sig":"89","8":null,"usr_asig":null,"9":null,"usr_resol":null}
2015-06 12 11:29:52  
cargar datos del sujeto(,,s,85,85)
	
				select  s.*, m.nombre as nom_muni, c.nom_cat,fec_caso
				from  wf_caso_85 w
				inner join core_sujetoverificacion  s on w.id=85 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 12 11:29:52  
tabla dat adic
	select tabla from core_sujetoverificaciontipo where id=1
2015-06 12 11:29:52  
tabla :persona
	SELECT * FROM persona where id=65
 fin 2015-06-12  11:29:52
/******************************************************************************************************/

2015-06-12 11:31:52TraerCaso(85,85,)
 CargarCaso :85
2015-06 12 11:31:52  
CargarDatos: Caso :85
	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_85_seguimiento_id,wf_paso_id from wf_caso_85_pasos a1  group by wf_caso_85_seguimiento_id,wf_paso_id order by id
				)a
				inner join wf_caso_85_pasos p using(id,wf_caso_85_seguimiento_id)
				inner join ( select max(id) as wf_caso_85_seguimiento_id,wf_caso_85_id,wf_tarea_id from wf_caso_85_seguimiento where wf_caso_85_id =? group by wf_caso_85_id,wf_tarea_id order by wf_caso_85_id,wf_caso_85_seguimiento_id  ) b using(wf_caso_85_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_85_seguimiento a
				inner join (
				select max(b0.id) as id,b0.wf_caso_85_id,b0.wf_tarea_id from wf_caso_85_seguimiento b0  where b0.wf_caso_85_id =? group by b0.wf_caso_85_id,b0.wf_tarea_id order by wf_caso_85_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":"378","id":"378","1":"85","wf_caso_85_id":"85","2":"89","wf_tarea_id":"89","3":null,"core_usuario_id":null,"4":"2015-06-12 11:29:51","fec_asig":"2015-06-12 11:29:51","5":null,"core_usuario_id_resol":null,"6":null,"fec_resol":null,"7":"89","wf_tarea_id_sig":"89","8":null,"usr_asig":null,"9":null,"usr_resol":null}
2015-06 12 11:31:52  
cargar datos del sujeto(,,s,85,85)
	
				select  s.*, m.nombre as nom_muni, c.nom_cat,fec_caso
				from  wf_caso_85 w
				inner join core_sujetoverificacion  s on w.id=85 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 12 11:31:52  
tabla dat adic
	select tabla from core_sujetoverificaciontipo where id=1
2015-06 12 11:31:52  
tabla :persona
	SELECT * FROM persona where id=65
2015-06 12 11:31:52  
Continuar(s,89,189,)
	EjecutarTarea_89() Ingreso de datos id_comp1223
				  35
		ValidarUsuario(89):1
			EjecutarPaso_189: form:20 , caso=85 id_comp 1223
				Paso::Guardar(Caso:85)
					Datos a guardar:
						Array
						(
						    [wf_proceso_id] => 85
						    [wf_paso_id] => 189
						    [wf_tarea_id] => 89
						    [wf_caso_id] => 85
						    [id] => 1223
						    [accion] => nextPaso
						    [reg] => s
						    [rta] => n
						    [cod_formulario2] => 20
						    [id_periodo] => 2015
						    [obs_ingreso] => 
						    [cod_bloque] => 21
						    [oid] => 
						    [oid_maestro] => 
						    [326] => 2015-06-12
						    [327] => 5
						)
						
					OID: 68
					rta: 1 dato:68 tabla:sce.t20 
					CasoPaso:322
				CargarDatos_189(68)
							se carga 85_89_189_20_21_3275
							se carga 85_89_189_20_21_3262015-06-12
				SiguientePasoDe189: Funcion para ejecutar el siguiente paso 
			Condicion Tarea :  5 ==1
			Condicion Tarea :  5 ==2
			Condicion Tarea :  5 ==3
			Condicion Tarea :  5 ==4
			Condicion Tarea :  5 ==5
		TerminarTarea(89,98)
			Ultimo seg :378 
			Ultimo seg :379 
	EjecutarTarea_98() excep_impuesto_6 id_comp1223
				35  35
		ValidarUsuario(98):1
			EjecutarPaso_212: ladj:104 , caso=85 id_comp 1223
				Mostrar ladj
	Retorno :
	Array
	(
	    [ret] => inicioComponente_WF_ladj({"tarea_id":98,"paso_id":212,"id":"1223","proceso_id":85,"caso_id":"85","sujeto_id":"65","ladj":104});
	    [suc] => 1
	)
	
 fin 2015-06-12  11:31:52
/******************************************************************************************************/

2015-06-12 11:32:22TraerCaso(85,85,)
 CargarCaso :85
2015-06 12 11:32:22  
CargarDatos: Caso :85
	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_85_seguimiento_id,wf_paso_id from wf_caso_85_pasos a1  group by wf_caso_85_seguimiento_id,wf_paso_id order by id
				)a
				inner join wf_caso_85_pasos p using(id,wf_caso_85_seguimiento_id)
				inner join ( select max(id) as wf_caso_85_seguimiento_id,wf_caso_85_id,wf_tarea_id from wf_caso_85_seguimiento where wf_caso_85_id =? group by wf_caso_85_id,wf_tarea_id order by wf_caso_85_id,wf_caso_85_seguimiento_id  ) b using(wf_caso_85_seguimiento_id)
				left join  usuarios  u using(core_usuario_id)
			{"0":"322","id":"322","1":"189","wf_paso_id":"189","2":"378","wf_caso_85_seguimiento_id":"378","3":"35","core_usuario_id":"35","4":"2015-06-12 11:31:52","fecha_ejec":"2015-06-12 11:31:52","5":"68","dato":"68","6":"sce.t20","tabla":"sce.t20","7":"89","tarea_id":"89","8":"Pinchao German: ciudadano","usr_ejec":"Pinchao German: ciudadano"}
				CargarDatos_189(68)
							se carga 85_89_189_20_21_3275
							se carga 85_89_189_20_21_3262015-06-12
	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_85_seguimiento a
				inner join (
				select max(b0.id) as id,b0.wf_caso_85_id,b0.wf_tarea_id from wf_caso_85_seguimiento b0  where b0.wf_caso_85_id =? group by b0.wf_caso_85_id,b0.wf_tarea_id order by wf_caso_85_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":"378","id":"378","1":"85","wf_caso_85_id":"85","2":"89","wf_tarea_id":"89","3":null,"core_usuario_id":null,"4":"2015-06-12 11:29:51","fec_asig":"2015-06-12 11:29:51","5":"35","core_usuario_id_resol":"35","6":"2015-06-12 11:31:52","fec_resol":"2015-06-12 11:31:52","7":"89","wf_tarea_id_sig":"89","8":null,"usr_asig":null,"9":"Pinchao German: ciudadano","usr_resol":"Pinchao German: ciudadano"}
			{"0":"379","id":"379","1":"85","wf_caso_85_id":"85","2":"98","wf_tarea_id":"98","3":"35","core_usuario_id":"35","4":"2015-06-12 11:31:52","fec_asig":"2015-06-12 11:31:52","5":null,"core_usuario_id_resol":null,"6":null,"fec_resol":null,"7":"98","wf_tarea_id_sig":"98","8":"Pinchao German: ciudadano","usr_asig":"Pinchao German: ciudadano","9":null,"usr_resol":null}
2015-06 12 11:32:22  
cargar datos del sujeto(,,s,85,85)
	
				select  s.*, m.nombre as nom_muni, c.nom_cat,fec_caso
				from  wf_caso_85 w
				inner join core_sujetoverificacion  s on w.id=85 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 12 11:32:22  
tabla dat adic
	select tabla from core_sujetoverificaciontipo where id=1
2015-06 12 11:32:22  
tabla :persona
	SELECT * FROM persona where id=65
2015-06 12 11:32:22  
Continuar(s,98,212,)
	EjecutarTarea_98() excep_impuesto_6 id_comp1223
				35  35
		ValidarUsuario(98):1
			EjecutarPaso_212: ladj:104 , caso=85 id_comp 1223
				Paso::Guardar(Caso:85)
					rta: 1 dato:5907 tabla:wf_documentoentradaadj_caso 
					CasoPaso:323
				CargarDatos_212(5907)
				SiguientePasoDe212: Funcion para ejecutar el siguiente paso 
			Condicion Tarea : true
		TerminarTarea(98,127)
			Ultimo seg :379 
			Ultimo seg :380 
	EjecutarTarea_127() Notificación registro id_comp1223
				35  35
		ValidarUsuario(127):1
			EjecutarPaso_234: corr:64 , caso=85 id_comp 1223
				Mostrar corr
					ob_start();
					$ciud =  mb_strtoupper( "{ WFSV_2 } { WFSV_3 }",'utf-8');
					?>
					<p>
					Apreciado(a)<br>
					<strong><?php echo htmlentities($ciud) ?></strong>
					<p>
					<p>El presente mensaje es una notificaci&oacute;n para el caso No  <strong><?php echo $id_caso; ?></strong> </p>
					<?php  $html=ob_get_clean();  
					TWFSV_3:Pinchao
					TWFSV_2:German
					Su solitud de <b>Exenciones de impuestos predial</b> ha sido registrada exitosamente y ya se encuentra en trámite. 
					{ WFSV_1 }
					TWFSV_1:desarrollo4@siticol.com
					Registro exitoso
	Retorno :
	Array
	(
	    [ret] => inicioComponente_WF_Correo({"id":"1223","caso_id":"85","proceso_id":85,"tit":"Notificaci&oacute;n registro","tarea_id":127,"paso_id":234,"desc":"<p>\nApreciado(a)<br>\n<strong>GERMAN PINCHAO<\/strong>\n<p>\n<p>El presente mensaje es una notificaci&oacute;n para el caso No  <strong>85<\/strong> <\/p>\n<strong>Su solitud de <b>Exenciones de impuestos predial<\/b> ha sido registrada exitosamente y ya se encuentra en tr\u00e1mite. <\/strong> ","url":"<a href=\"#\" onclick=\" llamadaAJAX({\r\n\t\t\t\t\t\t\t\t\turl:'http:\/\/192.168.10.116\/sisad\/build\/view\/mail\/envio\/envio_l.php',\r\n\t\t\t\t\t\t\t\t\tmostrarMsg:true,\r\n\t\t\t\t\t\t\t\t\tparams:{accion:'envio2',destino:'desarrollo4@siticol.com',asunto:'Registro exitoso'},\r\n\t\t\t\t\t\t\t\t\tsuccess:function(result){\r\n\t\t\t\t\t\t\t\t\t\t\t\t\tif(result.success) \r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\tcrearMsg(action.result.message,'Informacion');\r\n\t\t\t\t\t\t\t\t\t\t\t\t\telse{\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\tcrearMsg(action.result.message,'Informacion');\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t}\r\n\t\t\t\t\t\t\t\t\t\t\t\t},\r\n\t\t\t\t\t\t\t\t});\" >De click aqui para volver a enviar el correo<\/a><\/div>"});
	    [suc] => 1
	)
	
 fin 2015-06-12  11:32:22
/******************************************************************************************************/

2015-06-12 11:32:40TraerCaso(85,85,)
 CargarCaso :85
2015-06 12 11:32:40  
CargarDatos: Caso :85
	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_85_seguimiento_id,wf_paso_id from wf_caso_85_pasos a1  group by wf_caso_85_seguimiento_id,wf_paso_id order by id
				)a
				inner join wf_caso_85_pasos p using(id,wf_caso_85_seguimiento_id)
				inner join ( select max(id) as wf_caso_85_seguimiento_id,wf_caso_85_id,wf_tarea_id from wf_caso_85_seguimiento where wf_caso_85_id =? group by wf_caso_85_id,wf_tarea_id order by wf_caso_85_id,wf_caso_85_seguimiento_id  ) b using(wf_caso_85_seguimiento_id)
				left join  usuarios  u using(core_usuario_id)
			{"0":"322","id":"322","1":"189","wf_paso_id":"189","2":"378","wf_caso_85_seguimiento_id":"378","3":"35","core_usuario_id":"35","4":"2015-06-12 11:31:52","fecha_ejec":"2015-06-12 11:31:52","5":"68","dato":"68","6":"sce.t20","tabla":"sce.t20","7":"89","tarea_id":"89","8":"Pinchao German: ciudadano","usr_ejec":"Pinchao German: ciudadano"}
				CargarDatos_189(68)
							se carga 85_89_189_20_21_3275
							se carga 85_89_189_20_21_3262015-06-12
			{"0":"323","id":"323","1":"212","wf_paso_id":"212","2":"379","wf_caso_85_seguimiento_id":"379","3":"35","core_usuario_id":"35","4":"2015-06-12 11:32:22","fecha_ejec":"2015-06-12 11:32:22","5":"5907","dato":"5907","6":"wf_documentoentradaadj_caso","tabla":"wf_documentoentradaadj_caso","7":"98","tarea_id":"98","8":"Pinchao German: ciudadano","usr_ejec":"Pinchao German: ciudadano"}
				CargarDatos_212(5907)
	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_85_seguimiento a
				inner join (
				select max(b0.id) as id,b0.wf_caso_85_id,b0.wf_tarea_id from wf_caso_85_seguimiento b0  where b0.wf_caso_85_id =? group by b0.wf_caso_85_id,b0.wf_tarea_id order by wf_caso_85_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":"378","id":"378","1":"85","wf_caso_85_id":"85","2":"89","wf_tarea_id":"89","3":null,"core_usuario_id":null,"4":"2015-06-12 11:29:51","fec_asig":"2015-06-12 11:29:51","5":"35","core_usuario_id_resol":"35","6":"2015-06-12 11:31:52","fec_resol":"2015-06-12 11:31:52","7":"89","wf_tarea_id_sig":"89","8":null,"usr_asig":null,"9":"Pinchao German: ciudadano","usr_resol":"Pinchao German: ciudadano"}
			{"0":"379","id":"379","1":"85","wf_caso_85_id":"85","2":"98","wf_tarea_id":"98","3":"35","core_usuario_id":"35","4":"2015-06-12 11:31:52","fec_asig":"2015-06-12 11:31:52","5":"35","core_usuario_id_resol":"35","6":"2015-06-12 11:32:22","fec_resol":"2015-06-12 11:32:22","7":"98","wf_tarea_id_sig":"98","8":"Pinchao German: ciudadano","usr_asig":"Pinchao German: ciudadano","9":"Pinchao German: ciudadano","usr_resol":"Pinchao German: ciudadano"}
			{"0":"380","id":"380","1":"85","wf_caso_85_id":"85","2":"127","wf_tarea_id":"127","3":"35","core_usuario_id":"35","4":"2015-06-12 11:32:22","fec_asig":"2015-06-12 11:32:22","5":null,"core_usuario_id_resol":null,"6":null,"fec_resol":null,"7":"127","wf_tarea_id_sig":"127","8":"Pinchao German: ciudadano","usr_asig":"Pinchao German: ciudadano","9":null,"usr_resol":null}
2015-06 12 11:32:40  
cargar datos del sujeto(,,s,85,85)
	
				select  s.*, m.nombre as nom_muni, c.nom_cat,fec_caso
				from  wf_caso_85 w
				inner join core_sujetoverificacion  s on w.id=85 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 12 11:32:40  
tabla dat adic
	select tabla from core_sujetoverificaciontipo where id=1
2015-06 12 11:32:40  
tabla :persona
	SELECT * FROM persona where id=65
2015-06 12 11:32:40  
Continuar(s,127,234,)
	EjecutarTarea_127() Notificación registro id_comp1223
				35  35
		ValidarUsuario(127):1
			EjecutarPaso_234: corr:64 , caso=85 id_comp 1223
				Paso::Guardar(Caso:85)
					rta: 1 dato: tabla: 
					CasoPaso:324
				CargarDatos_234()
				SiguientePasoDe234: Funcion para ejecutar el siguiente paso 
			Condicion Tarea :  5 ==1 
			Condicion Tarea :  5 ==2
			Condicion Tarea :  5 ==3
			Condicion Tarea :  5 ==4
			Condicion Tarea :  5 ==5
		TerminarTarea(127,115)
			Ultimo seg :380 
			Ultimo seg :381 
	EjecutarTarea_115() ver_excep_impuesto_6 id_comp1223
				  35
		ValidarUsuario(115):
	Retorno :
	Array
	(
	    [htm] => 
	    [suc] => 1
	    [ret] => crearMsg('Usted no puede ejecutar la tarea actual del proceso, Debe esperar a que un usuario con los privilegios adecuados la ejecute.','Informaci&oacute;n');Ext.getCmp('comp_1223').funcionInicial('n');
	)
	
 fin 2015-06-12  11:32:40
/******************************************************************************************************/

2015-07-02 07:44:15TraerCaso(85,85,)
 CargarCaso :85
2015-07 02 07:44:15  
CargarDatos: Caso :85
	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_85_seguimiento_id,wf_paso_id from wf_caso_85_pasos a1  group by wf_caso_85_seguimiento_id,wf_paso_id order by id
				)a
				inner join wf_caso_85_pasos p using(id,wf_caso_85_seguimiento_id)
				inner join ( select max(id) as wf_caso_85_seguimiento_id,wf_caso_85_id,wf_tarea_id from wf_caso_85_seguimiento where wf_caso_85_id =? group by wf_caso_85_id,wf_tarea_id order by wf_caso_85_id,wf_caso_85_seguimiento_id  ) b using(wf_caso_85_seguimiento_id)
				left join  usuarios  u using(core_usuario_id)
			{"0":"322","id":"322","1":"189","wf_paso_id":"189","2":"378","wf_caso_85_seguimiento_id":"378","3":"35","core_usuario_id":"35","4":"2015-06-12 11:31:52","fecha_ejec":"2015-06-12 11:31:52","5":"68","dato":"68","6":"sce.t20","tabla":"sce.t20","7":"89","tarea_id":"89","8":"Pinchao German: ciudadano","usr_ejec":"Pinchao German: ciudadano"}
				CargarDatos_189(68)
							se carga 85_89_189_20_21_3275
							se carga 85_89_189_20_21_3262015-06-12
			{"0":"323","id":"323","1":"212","wf_paso_id":"212","2":"379","wf_caso_85_seguimiento_id":"379","3":"35","core_usuario_id":"35","4":"2015-06-12 11:32:22","fecha_ejec":"2015-06-12 11:32:22","5":"5907","dato":"5907","6":"wf_documentoentradaadj_caso","tabla":"wf_documentoentradaadj_caso","7":"98","tarea_id":"98","8":"Pinchao German: ciudadano","usr_ejec":"Pinchao German: ciudadano"}
				CargarDatos_212(5907)
			{"0":"324","id":"324","1":"234","wf_paso_id":"234","2":"380","wf_caso_85_seguimiento_id":"380","3":"35","core_usuario_id":"35","4":"2015-06-12 11:32:40","fecha_ejec":"2015-06-12 11:32:40","5":null,"dato":null,"6":null,"tabla":null,"7":"127","tarea_id":"127","8":"Pinchao German: ciudadano","usr_ejec":"Pinchao German: ciudadano"}
				CargarDatos_234()
	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_85_seguimiento a
				inner join (
				select max(b0.id) as id,b0.wf_caso_85_id,b0.wf_tarea_id from wf_caso_85_seguimiento b0  where b0.wf_caso_85_id =? group by b0.wf_caso_85_id,b0.wf_tarea_id order by wf_caso_85_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":"378","id":"378","1":"85","wf_caso_85_id":"85","2":"89","wf_tarea_id":"89","3":null,"core_usuario_id":null,"4":"2015-06-12 11:29:51","fec_asig":"2015-06-12 11:29:51","5":"35","core_usuario_id_resol":"35","6":"2015-06-12 11:31:52","fec_resol":"2015-06-12 11:31:52","7":"89","wf_tarea_id_sig":"89","8":null,"usr_asig":null,"9":"Pinchao German: ciudadano","usr_resol":"Pinchao German: ciudadano"}
			{"0":"379","id":"379","1":"85","wf_caso_85_id":"85","2":"98","wf_tarea_id":"98","3":"35","core_usuario_id":"35","4":"2015-06-12 11:31:52","fec_asig":"2015-06-12 11:31:52","5":"35","core_usuario_id_resol":"35","6":"2015-06-12 11:32:22","fec_resol":"2015-06-12 11:32:22","7":"98","wf_tarea_id_sig":"98","8":"Pinchao German: ciudadano","usr_asig":"Pinchao German: ciudadano","9":"Pinchao German: ciudadano","usr_resol":"Pinchao German: ciudadano"}
			{"0":"380","id":"380","1":"85","wf_caso_85_id":"85","2":"127","wf_tarea_id":"127","3":"35","core_usuario_id":"35","4":"2015-06-12 11:32:22","fec_asig":"2015-06-12 11:32:22","5":"35","core_usuario_id_resol":"35","6":"2015-06-12 11:32:40","fec_resol":"2015-06-12 11:32:40","7":"127","wf_tarea_id_sig":"127","8":"Pinchao German: ciudadano","usr_asig":"Pinchao German: ciudadano","9":"Pinchao German: ciudadano","usr_resol":"Pinchao German: ciudadano"}
			{"0":"381","id":"381","1":"85","wf_caso_85_id":"85","2":"115","wf_tarea_id":"115","3":null,"core_usuario_id":null,"4":"2015-06-12 11:32:40","fec_asig":"2015-06-12 11:32:40","5":null,"core_usuario_id_resol":null,"6":null,"fec_resol":null,"7":"115","wf_tarea_id_sig":"115","8":null,"usr_asig":null,"9":null,"usr_resol":null}
2015-07 02 07:44:15  
cargar datos del sujeto(,,s,85,85)
	
				select  s.*, m.nombre as nom_muni, c.nom_cat,fec_caso
				from  wf_caso_85 w
				inner join core_sujetoverificacion  s on w.id=85 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 02 07:44:15  
tabla dat adic
	select tabla from core_sujetoverificaciontipo where id=1
2015-07 02 07:44:15  
tabla :persona
	SELECT * FROM persona where id=65
2015-07 02 07:44:15  
Continuar(,115,,s)
	EjecutarTarea_115() ver_excep_impuesto_6 id_comp1226
				  38
		ValidarUsuario(115):1
			EjecutarPaso_229: vadj:104 , caso=85 id_comp 1226
				Mostrar vadj
	Retorno :
	Array
	(
	    [ret] => inicioComponente_WF_vadj({"tarea_id":115,"paso_id":229,"id":"1226","proceso_id":85,"caso_id":"85","sujeto_id":"65","vadj":104});
	    [suc] => 1
	)
	
 fin 2015-07-02  07:44:16
/******************************************************************************************************/

2015-07-02 07:44:21TraerCaso(85,85,)
 CargarCaso :85
2015-07 02 07:44:21  
CargarDatos: Caso :85
	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_85_seguimiento_id,wf_paso_id from wf_caso_85_pasos a1  group by wf_caso_85_seguimiento_id,wf_paso_id order by id
				)a
				inner join wf_caso_85_pasos p using(id,wf_caso_85_seguimiento_id)
				inner join ( select max(id) as wf_caso_85_seguimiento_id,wf_caso_85_id,wf_tarea_id from wf_caso_85_seguimiento where wf_caso_85_id =? group by wf_caso_85_id,wf_tarea_id order by wf_caso_85_id,wf_caso_85_seguimiento_id  ) b using(wf_caso_85_seguimiento_id)
				left join  usuarios  u using(core_usuario_id)
			{"0":"322","id":"322","1":"189","wf_paso_id":"189","2":"378","wf_caso_85_seguimiento_id":"378","3":"35","core_usuario_id":"35","4":"2015-06-12 11:31:52","fecha_ejec":"2015-06-12 11:31:52","5":"68","dato":"68","6":"sce.t20","tabla":"sce.t20","7":"89","tarea_id":"89","8":"Pinchao German: ciudadano","usr_ejec":"Pinchao German: ciudadano"}
				CargarDatos_189(68)
							se carga 85_89_189_20_21_3275
							se carga 85_89_189_20_21_3262015-06-12
			{"0":"323","id":"323","1":"212","wf_paso_id":"212","2":"379","wf_caso_85_seguimiento_id":"379","3":"35","core_usuario_id":"35","4":"2015-06-12 11:32:22","fecha_ejec":"2015-06-12 11:32:22","5":"5907","dato":"5907","6":"wf_documentoentradaadj_caso","tabla":"wf_documentoentradaadj_caso","7":"98","tarea_id":"98","8":"Pinchao German: ciudadano","usr_ejec":"Pinchao German: ciudadano"}
				CargarDatos_212(5907)
			{"0":"324","id":"324","1":"234","wf_paso_id":"234","2":"380","wf_caso_85_seguimiento_id":"380","3":"35","core_usuario_id":"35","4":"2015-06-12 11:32:40","fecha_ejec":"2015-06-12 11:32:40","5":null,"dato":null,"6":null,"tabla":null,"7":"127","tarea_id":"127","8":"Pinchao German: ciudadano","usr_ejec":"Pinchao German: ciudadano"}
				CargarDatos_234()
	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_85_seguimiento a
				inner join (
				select max(b0.id) as id,b0.wf_caso_85_id,b0.wf_tarea_id from wf_caso_85_seguimiento b0  where b0.wf_caso_85_id =? group by b0.wf_caso_85_id,b0.wf_tarea_id order by wf_caso_85_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":"378","id":"378","1":"85","wf_caso_85_id":"85","2":"89","wf_tarea_id":"89","3":null,"core_usuario_id":null,"4":"2015-06-12 11:29:51","fec_asig":"2015-06-12 11:29:51","5":"35","core_usuario_id_resol":"35","6":"2015-06-12 11:31:52","fec_resol":"2015-06-12 11:31:52","7":"89","wf_tarea_id_sig":"89","8":null,"usr_asig":null,"9":"Pinchao German: ciudadano","usr_resol":"Pinchao German: ciudadano"}
			{"0":"379","id":"379","1":"85","wf_caso_85_id":"85","2":"98","wf_tarea_id":"98","3":"35","core_usuario_id":"35","4":"2015-06-12 11:31:52","fec_asig":"2015-06-12 11:31:52","5":"35","core_usuario_id_resol":"35","6":"2015-06-12 11:32:22","fec_resol":"2015-06-12 11:32:22","7":"98","wf_tarea_id_sig":"98","8":"Pinchao German: ciudadano","usr_asig":"Pinchao German: ciudadano","9":"Pinchao German: ciudadano","usr_resol":"Pinchao German: ciudadano"}
			{"0":"380","id":"380","1":"85","wf_caso_85_id":"85","2":"127","wf_tarea_id":"127","3":"35","core_usuario_id":"35","4":"2015-06-12 11:32:22","fec_asig":"2015-06-12 11:32:22","5":"35","core_usuario_id_resol":"35","6":"2015-06-12 11:32:40","fec_resol":"2015-06-12 11:32:40","7":"127","wf_tarea_id_sig":"127","8":"Pinchao German: ciudadano","usr_asig":"Pinchao German: ciudadano","9":"Pinchao German: ciudadano","usr_resol":"Pinchao German: ciudadano"}
			{"0":"381","id":"381","1":"85","wf_caso_85_id":"85","2":"115","wf_tarea_id":"115","3":null,"core_usuario_id":null,"4":"2015-06-12 11:32:40","fec_asig":"2015-06-12 11:32:40","5":null,"core_usuario_id_resol":null,"6":null,"fec_resol":null,"7":"115","wf_tarea_id_sig":"115","8":null,"usr_asig":null,"9":null,"usr_resol":null}
2015-07 02 07:44:21  
cargar datos del sujeto(,,s,85,85)
	
				select  s.*, m.nombre as nom_muni, c.nom_cat,fec_caso
				from  wf_caso_85 w
				inner join core_sujetoverificacion  s on w.id=85 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 02 07:44:21  
tabla dat adic
	select tabla from core_sujetoverificaciontipo where id=1
2015-07 02 07:44:21  
tabla :persona
	SELECT * FROM persona where id=65
2015-07 02 07:44:21  
Continuar(s,115,229,)
	EjecutarTarea_115() ver_excep_impuesto_6 id_comp1226
				  38
		ValidarUsuario(115):1
			EjecutarPaso_229: vadj:104 , caso=85 id_comp 1226
				Paso::Guardar(Caso:85)
					rta: 1 dato:2574 tabla:wf_documentoentradaadj_caso 
					CasoPaso:350
				CargarDatos_229(2574)
				SiguientePasoDe229: Funcion para ejecutar el siguiente paso 
			Condicion Tarea :  Si == "Si"
		TerminarTarea(115,128)
			Ultimo seg :381 
			Ultimo seg :412 
	EjecutarTarea_128() Notificación revision-radicación id_comp1226
				38  38
		ValidarUsuario(128):1
			EjecutarPaso_235: corr:71 , caso=85 id_comp 1226
				Mostrar corr
					ob_start();
					$ciud =  mb_strtoupper( "{ WFSV_2 } { WFSV_3 }",'utf-8');
					?>
					<p>
					Apreciado(a)<br>
					<strong><?php echo htmlentities($ciud) ?></strong>
					<p>
					<p>El presente mensaje es una notificaci&oacute;n para el caso No  <strong><?php echo $id_caso; ?></strong> </p>
					<?php  $html=ob_get_clean();  
					TWFSV_3:Pinchao
					TWFSV_2:German
					<br>Su solicitud de <b>Exenciones de impuestos predial</b> fue revisada y radicada.
					{ WFSV_1 } 
					TWFSV_1:myriabe123@gmail.com
					Revision y radicación en exenciones de impuestos predial
	Retorno :
	Array
	(
	    [ret] => inicioComponente_WF_Correo({"id":"1226","caso_id":"85","proceso_id":85,"tit":"Notificaci&oacute;n revision-radicaci&oacute;n","tarea_id":128,"paso_id":235,"desc":"<p>\nApreciado(a)<br>\n<strong>GERMAN PINCHAO<\/strong>\n<p>\n<p>El presente mensaje es una notificaci&oacute;n para el caso No  <strong>85<\/strong> <\/p>\n<strong><br>Su solicitud de <b>Exenciones de impuestos predial<\/b> fue revisada y radicada.<\/strong> ","url":"<a href=\"#\" onclick=\" llamadaAJAX({\r\n\t\t\t\t\t\t\t\t\turl:'http:\/\/192.168.10.116\/sisad\/build\/view\/mail\/envio\/envio_l.php',\r\n\t\t\t\t\t\t\t\t\tmostrarMsg:true,\r\n\t\t\t\t\t\t\t\t\tparams:{accion:'envio2',destino:'myriabe123@gmail.com ',asunto:'Revision y radicaci\u00f3n en exenciones de impuestos predial'},\r\n\t\t\t\t\t\t\t\t\tsuccess:function(result){\r\n\t\t\t\t\t\t\t\t\t\t\t\t\tif(result.success) \r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\tcrearMsg(action.result.message,'Informacion');\r\n\t\t\t\t\t\t\t\t\t\t\t\t\telse{\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\tcrearMsg(action.result.message,'Informacion');\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t}\r\n\t\t\t\t\t\t\t\t\t\t\t\t},\r\n\t\t\t\t\t\t\t\t});\" >De click aqui para volver a enviar el correo<\/a><\/div>"});
	    [suc] => 1
	)
	
 fin 2015-07-02  07:44:21
/******************************************************************************************************/

2015-07-02 07:44:24TraerCaso(85,85,)
 CargarCaso :85
2015-07 02 07:44:24  
CargarDatos: Caso :85
	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_85_seguimiento_id,wf_paso_id from wf_caso_85_pasos a1  group by wf_caso_85_seguimiento_id,wf_paso_id order by id
				)a
				inner join wf_caso_85_pasos p using(id,wf_caso_85_seguimiento_id)
				inner join ( select max(id) as wf_caso_85_seguimiento_id,wf_caso_85_id,wf_tarea_id from wf_caso_85_seguimiento where wf_caso_85_id =? group by wf_caso_85_id,wf_tarea_id order by wf_caso_85_id,wf_caso_85_seguimiento_id  ) b using(wf_caso_85_seguimiento_id)
				left join  usuarios  u using(core_usuario_id)
			{"0":"322","id":"322","1":"189","wf_paso_id":"189","2":"378","wf_caso_85_seguimiento_id":"378","3":"35","core_usuario_id":"35","4":"2015-06-12 11:31:52","fecha_ejec":"2015-06-12 11:31:52","5":"68","dato":"68","6":"sce.t20","tabla":"sce.t20","7":"89","tarea_id":"89","8":"Pinchao German: ciudadano","usr_ejec":"Pinchao German: ciudadano"}
				CargarDatos_189(68)
							se carga 85_89_189_20_21_3275
							se carga 85_89_189_20_21_3262015-06-12
			{"0":"323","id":"323","1":"212","wf_paso_id":"212","2":"379","wf_caso_85_seguimiento_id":"379","3":"35","core_usuario_id":"35","4":"2015-06-12 11:32:22","fecha_ejec":"2015-06-12 11:32:22","5":"5907","dato":"5907","6":"wf_documentoentradaadj_caso","tabla":"wf_documentoentradaadj_caso","7":"98","tarea_id":"98","8":"Pinchao German: ciudadano","usr_ejec":"Pinchao German: ciudadano"}
				CargarDatos_212(5907)
			{"0":"324","id":"324","1":"234","wf_paso_id":"234","2":"380","wf_caso_85_seguimiento_id":"380","3":"35","core_usuario_id":"35","4":"2015-06-12 11:32:40","fecha_ejec":"2015-06-12 11:32:40","5":null,"dato":null,"6":null,"tabla":null,"7":"127","tarea_id":"127","8":"Pinchao German: ciudadano","usr_ejec":"Pinchao German: ciudadano"}
				CargarDatos_234()
			{"0":"350","id":"350","1":"229","wf_paso_id":"229","2":"381","wf_caso_85_seguimiento_id":"381","3":"38","core_usuario_id":"38","4":"2015-07-02 07:44:21","fecha_ejec":"2015-07-02 07:44:21","5":"2574","dato":"2574","6":"wf_documentoentradaadj_caso","tabla":"wf_documentoentradaadj_caso","7":"115","tarea_id":"115","8":"secretaria operador : gerente","usr_ejec":"secretaria operador : gerente"}
				CargarDatos_229(2574)
	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_85_seguimiento a
				inner join (
				select max(b0.id) as id,b0.wf_caso_85_id,b0.wf_tarea_id from wf_caso_85_seguimiento b0  where b0.wf_caso_85_id =? group by b0.wf_caso_85_id,b0.wf_tarea_id order by wf_caso_85_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":"378","id":"378","1":"85","wf_caso_85_id":"85","2":"89","wf_tarea_id":"89","3":null,"core_usuario_id":null,"4":"2015-06-12 11:29:51","fec_asig":"2015-06-12 11:29:51","5":"35","core_usuario_id_resol":"35","6":"2015-06-12 11:31:52","fec_resol":"2015-06-12 11:31:52","7":"89","wf_tarea_id_sig":"89","8":null,"usr_asig":null,"9":"Pinchao German: ciudadano","usr_resol":"Pinchao German: ciudadano"}
			{"0":"379","id":"379","1":"85","wf_caso_85_id":"85","2":"98","wf_tarea_id":"98","3":"35","core_usuario_id":"35","4":"2015-06-12 11:31:52","fec_asig":"2015-06-12 11:31:52","5":"35","core_usuario_id_resol":"35","6":"2015-06-12 11:32:22","fec_resol":"2015-06-12 11:32:22","7":"98","wf_tarea_id_sig":"98","8":"Pinchao German: ciudadano","usr_asig":"Pinchao German: ciudadano","9":"Pinchao German: ciudadano","usr_resol":"Pinchao German: ciudadano"}
			{"0":"380","id":"380","1":"85","wf_caso_85_id":"85","2":"127","wf_tarea_id":"127","3":"35","core_usuario_id":"35","4":"2015-06-12 11:32:22","fec_asig":"2015-06-12 11:32:22","5":"35","core_usuario_id_resol":"35","6":"2015-06-12 11:32:40","fec_resol":"2015-06-12 11:32:40","7":"127","wf_tarea_id_sig":"127","8":"Pinchao German: ciudadano","usr_asig":"Pinchao German: ciudadano","9":"Pinchao German: ciudadano","usr_resol":"Pinchao German: ciudadano"}
			{"0":"381","id":"381","1":"85","wf_caso_85_id":"85","2":"115","wf_tarea_id":"115","3":null,"core_usuario_id":null,"4":"2015-06-12 11:32:40","fec_asig":"2015-06-12 11:32:40","5":"38","core_usuario_id_resol":"38","6":"2015-07-02 07:44:21","fec_resol":"2015-07-02 07:44:21","7":"115","wf_tarea_id_sig":"115","8":null,"usr_asig":null,"9":"secretaria operador : gerente","usr_resol":"secretaria operador : gerente"}
			{"0":"412","id":"412","1":"85","wf_caso_85_id":"85","2":"128","wf_tarea_id":"128","3":"38","core_usuario_id":"38","4":"2015-07-02 07:44:21","fec_asig":"2015-07-02 07:44:21","5":null,"core_usuario_id_resol":null,"6":null,"fec_resol":null,"7":"128","wf_tarea_id_sig":"128","8":"secretaria operador : gerente","usr_asig":"secretaria operador : gerente","9":null,"usr_resol":null}
2015-07 02 07:44:24  
cargar datos del sujeto(,,s,85,85)
	
				select  s.*, m.nombre as nom_muni, c.nom_cat,fec_caso
				from  wf_caso_85 w
				inner join core_sujetoverificacion  s on w.id=85 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 02 07:44:24  
tabla dat adic
	select tabla from core_sujetoverificaciontipo where id=1
2015-07 02 07:44:24  
tabla :persona
	SELECT * FROM persona where id=65
2015-07 02 07:44:24  
Continuar(s,128,235,)
	EjecutarTarea_128() Notificación revision-radicación id_comp1226
				38  38
		ValidarUsuario(128):1
			EjecutarPaso_235: corr:71 , caso=85 id_comp 1226
				Paso::Guardar(Caso:85)
					rta: 1 dato: tabla: 
					CasoPaso:351
				CargarDatos_235()
				SiguientePasoDe235: Funcion para ejecutar el siguiente paso 
			Condicion Tarea : true
		TerminarTarea(128,160)
			Ultimo seg :412 
			Ultimo seg :413 
	EjecutarTarea_160() Generar acto administrativo id_comp1226
				38  38
		ValidarUsuario(160):1
			EjecutarPaso_275: form:26 , caso=85 id_comp 1226
				Mostrar form
	Retorno :
	Array
	(
	    [ret] => Ext.getCmp('comp_1226').removeAll();Ext.getCmp('comp_1226').add(new Ext.form.FormPanel({ title: 'acto administrativo' ,padding: 10,id:'frm_formulario_85_85',autoScroll:true ,labelAlign:'top',defaults: { anchor: '97%'} ,items: [new Ext.form.Hidden({name:'cod_formulario2',value:'26'})  ,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:'27'})  ,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:'408',id:'408_1',inputValue:1,boxLabel:'Si'}), new Ext.form.Radio({name:'408',id:'408_2',inputValue:2,boxLabel:'No'}) ],columns:2,allowBlank:false,fieldLabel:'* Generar acto administrativo',id:'408',listeners:{change:function(){var c=Ext.getCmp('408_2').getValue();var obs=Ext.getCmp('409');if(c)obs.setDisabled(false);else obs.setDisabled(true);}}}), new Ext.form.TextArea({id:'409',allowBlank:false, fieldLabel:'* Observaciones',name:'409',disabled:true,listeners:{change:function(){if(/^\s*$/.test(this.getValue())){this.setValue('');}}}}) ] ,prepararGrids:function(){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);}}}},tbar:[{text:'Guardar',iconCls: 'icon-disk',handler: function(){ var form = Ext.getCmp('frm_formulario_85_85'); 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:'85',wf_paso_id:'275',wf_tarea_id:'160',wf_caso_id:'85',id:'1226',accion:'nextPaso',reg:'s',rta:'n'},success:function(form, action){if(action.result.message) crearMsg(action.result.message,'Informacion');else if(action.result.execute){/*try{*/eval(action.result.execute);/*}catch(e){alert(e+'Se presentó un error , por favor cierre la pesta&ntilde;a del caso y continue el proceso desde la pesta&ntilde;a de resumen' );}*/}},failure: function(form, action) {switch (action.failureType) {case Ext.form.Action.CONNECT_FAILURE:Ext.Msg.alert('Error', 'No hay comunicacion con el servidor');break;case Ext.form.Action.SERVER_INVALID:  Ext.Msg.alert('Error', action.result.message);  break;  }}});}}else{Ext.MessageBox.alert('Advertencia',getErrorFields(f));}} } ]  ,listeners:{ afterrender:function(){ try{   Ext.getCmp('frm_formulario_85_85').getForm().loadRecord(new Ext.data.Record({"cod_formulario":26,"oid_maestro":null,"cod_bloque":27}));  llamadaAJAX({url:'http://192.168.10.116/sisad/build/view/workflow/casos/casos_datosForm.php',mostrarMsg:false,params:{accion:'verifica',wf_paso_id:'275',cod_formulario:'26',cod_bloque:'27',wf_caso_id:'{"pro":"85","cas":"85"}'}}); }catch(e){alert(e);} } }  }) );Ext.getCmp('comp_1226').doLayout();
	    [suc] => 1
	)
	
 fin 2015-07-02  07:44:24
/******************************************************************************************************/

2015-07-02 07:44:24TraerCaso(85,85,)
 CargarCaso :85
2015-07 02 07:44:24  
CargarDatos: Caso :85
	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_85_seguimiento_id,wf_paso_id from wf_caso_85_pasos a1  group by wf_caso_85_seguimiento_id,wf_paso_id order by id
				)a
				inner join wf_caso_85_pasos p using(id,wf_caso_85_seguimiento_id)
				inner join ( select max(id) as wf_caso_85_seguimiento_id,wf_caso_85_id,wf_tarea_id from wf_caso_85_seguimiento where wf_caso_85_id =? group by wf_caso_85_id,wf_tarea_id order by wf_caso_85_id,wf_caso_85_seguimiento_id  ) b using(wf_caso_85_seguimiento_id)
				left join  usuarios  u using(core_usuario_id)
			{"0":"322","id":"322","1":"189","wf_paso_id":"189","2":"378","wf_caso_85_seguimiento_id":"378","3":"35","core_usuario_id":"35","4":"2015-06-12 11:31:52","fecha_ejec":"2015-06-12 11:31:52","5":"68","dato":"68","6":"sce.t20","tabla":"sce.t20","7":"89","tarea_id":"89","8":"Pinchao German: ciudadano","usr_ejec":"Pinchao German: ciudadano"}
				CargarDatos_189(68)
							se carga 85_89_189_20_21_3275
							se carga 85_89_189_20_21_3262015-06-12
			{"0":"323","id":"323","1":"212","wf_paso_id":"212","2":"379","wf_caso_85_seguimiento_id":"379","3":"35","core_usuario_id":"35","4":"2015-06-12 11:32:22","fecha_ejec":"2015-06-12 11:32:22","5":"5907","dato":"5907","6":"wf_documentoentradaadj_caso","tabla":"wf_documentoentradaadj_caso","7":"98","tarea_id":"98","8":"Pinchao German: ciudadano","usr_ejec":"Pinchao German: ciudadano"}
				CargarDatos_212(5907)
			{"0":"324","id":"324","1":"234","wf_paso_id":"234","2":"380","wf_caso_85_seguimiento_id":"380","3":"35","core_usuario_id":"35","4":"2015-06-12 11:32:40","fecha_ejec":"2015-06-12 11:32:40","5":null,"dato":null,"6":null,"tabla":null,"7":"127","tarea_id":"127","8":"Pinchao German: ciudadano","usr_ejec":"Pinchao German: ciudadano"}
				CargarDatos_234()
			{"0":"350","id":"350","1":"229","wf_paso_id":"229","2":"381","wf_caso_85_seguimiento_id":"381","3":"38","core_usuario_id":"38","4":"2015-07-02 07:44:21","fecha_ejec":"2015-07-02 07:44:21","5":"2574","dato":"2574","6":"wf_documentoentradaadj_caso","tabla":"wf_documentoentradaadj_caso","7":"115","tarea_id":"115","8":"secretaria operador : gerente","usr_ejec":"secretaria operador : gerente"}
				CargarDatos_229(2574)
			{"0":"351","id":"351","1":"235","wf_paso_id":"235","2":"412","wf_caso_85_seguimiento_id":"412","3":"38","core_usuario_id":"38","4":"2015-07-02 07:44:24","fecha_ejec":"2015-07-02 07:44:24","5":null,"dato":null,"6":null,"tabla":null,"7":"128","tarea_id":"128","8":"secretaria operador : gerente","usr_ejec":"secretaria operador : gerente"}
				CargarDatos_235()
	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_85_seguimiento a
				inner join (
				select max(b0.id) as id,b0.wf_caso_85_id,b0.wf_tarea_id from wf_caso_85_seguimiento b0  where b0.wf_caso_85_id =? group by b0.wf_caso_85_id,b0.wf_tarea_id order by wf_caso_85_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":"378","id":"378","1":"85","wf_caso_85_id":"85","2":"89","wf_tarea_id":"89","3":null,"core_usuario_id":null,"4":"2015-06-12 11:29:51","fec_asig":"2015-06-12 11:29:51","5":"35","core_usuario_id_resol":"35","6":"2015-06-12 11:31:52","fec_resol":"2015-06-12 11:31:52","7":"89","wf_tarea_id_sig":"89","8":null,"usr_asig":null,"9":"Pinchao German: ciudadano","usr_resol":"Pinchao German: ciudadano"}
			{"0":"379","id":"379","1":"85","wf_caso_85_id":"85","2":"98","wf_tarea_id":"98","3":"35","core_usuario_id":"35","4":"2015-06-12 11:31:52","fec_asig":"2015-06-12 11:31:52","5":"35","core_usuario_id_resol":"35","6":"2015-06-12 11:32:22","fec_resol":"2015-06-12 11:32:22","7":"98","wf_tarea_id_sig":"98","8":"Pinchao German: ciudadano","usr_asig":"Pinchao German: ciudadano","9":"Pinchao German: ciudadano","usr_resol":"Pinchao German: ciudadano"}
			{"0":"380","id":"380","1":"85","wf_caso_85_id":"85","2":"127","wf_tarea_id":"127","3":"35","core_usuario_id":"35","4":"2015-06-12 11:32:22","fec_asig":"2015-06-12 11:32:22","5":"35","core_usuario_id_resol":"35","6":"2015-06-12 11:32:40","fec_resol":"2015-06-12 11:32:40","7":"127","wf_tarea_id_sig":"127","8":"Pinchao German: ciudadano","usr_asig":"Pinchao German: ciudadano","9":"Pinchao German: ciudadano","usr_resol":"Pinchao German: ciudadano"}
			{"0":"381","id":"381","1":"85","wf_caso_85_id":"85","2":"115","wf_tarea_id":"115","3":null,"core_usuario_id":null,"4":"2015-06-12 11:32:40","fec_asig":"2015-06-12 11:32:40","5":"38","core_usuario_id_resol":"38","6":"2015-07-02 07:44:21","fec_resol":"2015-07-02 07:44:21","7":"115","wf_tarea_id_sig":"115","8":null,"usr_asig":null,"9":"secretaria operador : gerente","usr_resol":"secretaria operador : gerente"}
			{"0":"412","id":"412","1":"85","wf_caso_85_id":"85","2":"128","wf_tarea_id":"128","3":"38","core_usuario_id":"38","4":"2015-07-02 07:44:21","fec_asig":"2015-07-02 07:44:21","5":"38","core_usuario_id_resol":"38","6":"2015-07-02 07:44:24","fec_resol":"2015-07-02 07:44:24","7":"128","wf_tarea_id_sig":"128","8":"secretaria operador : gerente","usr_asig":"secretaria operador : gerente","9":"secretaria operador : gerente","usr_resol":"secretaria operador : gerente"}
			{"0":"413","id":"413","1":"85","wf_caso_85_id":"85","2":"160","wf_tarea_id":"160","3":"38","core_usuario_id":"38","4":"2015-07-02 07:44:24","fec_asig":"2015-07-02 07:44:24","5":null,"core_usuario_id_resol":null,"6":null,"fec_resol":null,"7":"160","wf_tarea_id_sig":"160","8":"secretaria operador : gerente","usr_asig":"secretaria operador : gerente","9":null,"usr_resol":null}
2015-07 02 07:44:24  
cargar datos del sujeto(,,s,85,85)
	
				select  s.*, m.nombre as nom_muni, c.nom_cat,fec_caso
				from  wf_caso_85 w
				inner join core_sujetoverificacion  s on w.id=85 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 02 07:44:24  
tabla dat adic
	select tabla from core_sujetoverificaciontipo where id=1
2015-07 02 07:44:24  
tabla :persona
	SELECT * FROM persona where id=65
 fin 2015-07-02  07:44:24
/******************************************************************************************************/