2015-07-30 12:34:41TraerCaso(11644,59,)
CargarCaso :11644
2015-07 30 12:34:41
CargarDatos: Caso :11644
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_59_seguimiento_id,wf_paso_id from wf_caso_59_pasos a1 group by wf_caso_59_seguimiento_id,wf_paso_id order by id
)a
inner join wf_caso_59_pasos p using(id,wf_caso_59_seguimiento_id)
inner join ( select max(id) as wf_caso_59_seguimiento_id,wf_caso_59_id,wf_tarea_id from wf_caso_59_seguimiento where wf_caso_59_id =? group by wf_caso_59_id,wf_tarea_id order by wf_caso_59_id,wf_caso_59_seguimiento_id ) b using(wf_caso_59_seguimiento_id)
left join usuarios u using(core_usuario_id)
{"0":"115478","id":"115478","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"172","wf_paso_id":"172","4":"109430","wf_caso_59_seguimiento_id":"109430","5":"2015-01-13 17:25:46","fecha_ejec":"2015-01-13 17:25:46","6":"330200","dato":"330200","7":"sce.t2","tabla":"sce.t2","8":"1","core_usuario_id":"1","9":"105","tarea_id":"105","10":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_ejec":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
CargarDatos_172(330200)
se carga 59_105_172_2_2_81
se carga 59_105_172_2_2_10
{"0":"115479","id":"115479","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"174","wf_paso_id":"174","4":"109431","wf_caso_59_seguimiento_id":"109431","5":"2015-01-13 17:25:58","fecha_ejec":"2015-01-13 17:25:58","6":"104739","dato":"104739","7":"wf_documentoentradadatos","tabla":"wf_documentoentradadatos","8":"1","core_usuario_id":"1","9":"107","tarea_id":"107","10":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_ejec":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
CargarDatos_174(104739)
Documento 104739
Documento 104739
{"0":"115480","id":"115480","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"176","wf_paso_id":"176","4":"109431","wf_caso_59_seguimiento_id":"109431","5":"2015-01-13 17:26:03","fecha_ejec":"2015-01-13 17:26:03","6":"104740","dato":"104740","7":"wf_documentoentradadatos","tabla":"wf_documentoentradadatos","8":"1","core_usuario_id":"1","9":"107","tarea_id":"107","10":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_ejec":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
CargarDatos_176(104740)
Documento 104740
Documento 104740
{"0":"115481","id":"115481","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"175","wf_paso_id":"175","4":"109431","wf_caso_59_seguimiento_id":"109431","5":"2015-01-13 17:26:13","fecha_ejec":"2015-01-13 17:26:13","6":"104741","dato":"104741","7":"wf_documentoentradadatos","tabla":"wf_documentoentradadatos","8":"1","core_usuario_id":"1","9":"107","tarea_id":"107","10":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_ejec":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
CargarDatos_175(104741)
Documento 104741
Documento 104741
{"0":"115482","id":"115482","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"177","wf_paso_id":"177","4":"109432","wf_caso_59_seguimiento_id":"109432","5":"2015-01-13 17:26:43","fecha_ejec":"2015-01-13 17:26:43","6":"108083","dato":"108083","7":"sce.t4","tabla":"sce.t4","8":"1","core_usuario_id":"1","9":"109","tarea_id":"109","10":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_ejec":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
CargarDatos_177(108083)
se carga 59_109_177_4_5_752015-01-13
se carga 59_109_177_4_5_69gh
se carga 59_109_177_4_5_68
se carga 59_109_177_4_5_64Seleccione una opción
se carga 59_109_177_4_5_412015-01-13
se carga 59_109_177_4_5_406
se carga 59_109_177_4_5_396
se carga 59_109_177_4_5_241
se carga 59_109_177_4_5_226
se carga 59_109_177_4_5_216
{"0":"115483","id":"115483","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"182","wf_paso_id":"182","4":"109433","wf_caso_59_seguimiento_id":"109433","5":"2015-01-13 17:26:54","fecha_ejec":"2015-01-13 17:26:54","6":"109611","dato":"109611","7":"sce.t6","tabla":"sce.t6","8":"1","core_usuario_id":"1","9":"115","tarea_id":"115","10":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_ejec":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
CargarDatos_182(109611)
se carga 59_115_182_6_7_381
se carga 59_115_182_6_7_371
se carga 59_115_182_6_7_32
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_59_seguimiento a
inner join (
select max(b0.id) as id,b0.wf_caso_59_id,b0.wf_tarea_id from wf_caso_59_seguimiento b0 where b0.wf_caso_59_id =? group by b0.wf_caso_59_id,b0.wf_tarea_id order by wf_caso_59_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":"109430","id":"109430","1":"11644","wf_caso_59_id":"11644","2":"105","wf_tarea_id":"105","3":null,"core_usuario_id":null,"4":"2015-01-13 17:25:41","fec_asig":"2015-01-13 17:25:41","5":"2015-01-13 17:25:47","fec_resol":"2015-01-13 17:25:47","6":"105","wf_tarea_id_sig":"105","7":"1","core_usuario_id_resol":"1","8":null,"usr_asig":null,"9":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_resol":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
{"0":"109431","id":"109431","1":"11644","wf_caso_59_id":"11644","2":"107","wf_tarea_id":"107","3":"1","core_usuario_id":"1","4":"2015-01-13 17:25:47","fec_asig":"2015-01-13 17:25:47","5":"2015-01-13 17:26:13","fec_resol":"2015-01-13 17:26:13","6":"107","wf_tarea_id_sig":"107","7":"1","core_usuario_id_resol":"1","8":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_asig":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","9":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_resol":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
{"0":"109432","id":"109432","1":"11644","wf_caso_59_id":"11644","2":"109","wf_tarea_id":"109","3":"1","core_usuario_id":"1","4":"2015-01-13 17:26:13","fec_asig":"2015-01-13 17:26:13","5":"2015-01-13 17:26:43","fec_resol":"2015-01-13 17:26:43","6":"109","wf_tarea_id_sig":"109","7":"1","core_usuario_id_resol":"1","8":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_asig":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","9":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_resol":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
{"0":"109433","id":"109433","1":"11644","wf_caso_59_id":"11644","2":"115","wf_tarea_id":"115","3":"1","core_usuario_id":"1","4":"2015-01-13 17:26:43","fec_asig":"2015-01-13 17:26:43","5":null,"fec_resol":null,"6":"115","wf_tarea_id_sig":"115","7":null,"core_usuario_id_resol":null,"8":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_asig":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","9":null,"usr_resol":null}
2015-07 30 12:34:41
cargar datos del sujeto(,,s,59,11644)
select s.*, m.nombre as nom_muni, c.nom_cat,fec_caso
from wf_caso_59 w
inner join core_sujetoverificacion s on w.id=11644 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 30 12:34:41
tabla dat adic
select tabla from core_sujetoverificaciontipo where id=1
2015-07 30 12:34:41
tabla :core_sujetoverificacionstickerentrada
SELECT * FROM core_sujetoverificacionstickerentrada where id=11596
2015-07 30 12:34:41
Continuar(,115,182,s)
EjecutarTarea_115() Imp - Descargue id_comp1005
1 1
ValidarUsuario(115):1
SiguientePasoDe182: Funcion para ejecutar el siguiente paso
EjecutarPaso_192: docs:4 , caso=11644 id_comp 1005
Mostrar docs
$cod=' WFSV_72 ';
$tit_formato='Formato de Identificacion de Mercancia';
$ubicacion =' 59_115_182_6_7_37 ';
$pla_veh =' WFSV_73 ';
$fech_ing =' WFSV_74 ';
$hora_ing =' WFSV_75 ';
$carta_porte =' '.' 59_109_177_4_5_39 ';
$tipo_deposito=' 59_109_177_4_5_24 ';
$cliente=' 59_109_177_4_5_64 ';
$man_dian =' 59_109_177_4_5_40 ';
$fecha_dian=' { 59_109_177_4_5_75 } ';
$bultos =' 59_109_177_4_5_21 ';
$observaciones =' 59_115_182_6_7_32 ';
$peso_bruto=trim(' 59_109_177_4_5_22 ')*1;
$desc_mercancia=' 59_109_177_4_5_69 ';
//$tara_repeso=trim(' 59_116_184_8_9_44 ')*1;
require_once($root.'/lib/tcpdf/config/lang/eng.php');
require_once($root.'/lib/tcpdf/tcpdf.php');
// create new PDF document
$pdf = new TCPDF('l', 'mm', 'letter', true, 'UTF-8', false);
// set document information
$pdf->SetCreator(PDF_CREATOR);
$pdf->SetAuthor('SITI Ltda');
$pdf->setPrintHeader(false);
//set auto page breaks
//set image scale factor
$pdf->setImageScale(PDF_IMAGE_SCALE_RATIO);
//set some language-dependent strings
$pdf->setLanguageArray($l);
// ---------------------------------------------------------
// NOTE: 2D barcode algorithms must be implemented on 2dbarcode.php class file.
// set font
$pdf->SetFont('helvetica', '', 10);
// add a page
$pdf->AddPage();
// - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
$fils=4;
$cols=3;
$logo_empresa=$CONFIG['LOGO_EMPRESA'];
$codigo=$root_js.'build/view/common/marco/index.php?particular=001&accion=I&proc='.$CONFIG['PROCESO_STICKER'];
$izq=10+2;$der=10;$arr=10; $abj=10;
$pdf->SetMargins ( $izq,$arr,$der,true );
$pdf->SetAutoPageBreak(TRUE, $abj);
$pdf->setPrintHeader(false);
$sxp=$fils*$cols;
$tot=$rangoF-$rangoI+1;
$pags=ceil(($tot)/$sxp);
$anchoR=279-$izq-$der;
$altoR=216-$arr-$abj;
$anchoS=$anchoR/$cols;
$margenSV=2;
$margenSH=5;
$altoS=$altoR/$fils;
$altoImg=10;
$altoText=8;
$altoC=50;
// set style for barcode
$style = array(
'border' => 2,
'vpadding' => 'auto',
'hpadding' => 'auto',
'fgcolor' => array(0,0,0),
'bgcolor' => false, //array(255,255,255)
'module_width' => 1, // width of a single module in points
'module_height' => 1 // height of a single module in points
);
$pdf->SetFont('helvetica', '', 10, '', false);
$pdf->SetDefaultMonospacedFont(PDF_FONT_MONOSPACED);
$s=0;$p=1;$consc=$rangoI;
$y=(($altoR+$arr+$abj)/2);
$x=$izq;
$pdf->SetXY($x, $y);
//$pdf->Image($root.$logo_empresa, $x, $y+$altoImg, 0, $altoImg, 'PNG', '', 'center', true, 150, '', false, false, 0, false, false, false);
$pdf->SetXY($x+($anchoR-$altoC), $y+40);
// QRCODE,H : QR-CODE Best error correction
//($code,$type,$x = '',$y = '',$w = '',$h = '',$style = '',$align = '',$distort = false )
$pdf->write2DBarcode($codigo.'&sujeto='.trim($cod), 'QRCODE,Q', '', $y+44, $altoC, $altoC, $style, 'N');
//$pdf->Text($x+($anchoR-$altoC-10), $y+$altoC+$altoText,$cod );
//if($tipo_deposito=="Importación")
// {
$pdf->SetFont('helvetica', '', 30, '', false);
$pdf->Text($izq, $altoR+$arr-42,"Mercancía en Proceso de Nacionalización");
$pdf->SetFont('helvetica', '', 50, '', false);
$pdf->Text($izq, $altoR+$arr-28, $tipo_deposito );
// }
//else
// {
// $pdf->SetFont('helvetica', '', 60, '', false);
// $pdf->Text($izq, $altoR+$arr-45, $tipo_deposito );
// }
$pdf->SetFont('helvetica', '', 10, '', false);
$pdf->SetXY($x, $y);
// create some HTML content
ob_start();
echo str_replace('$root_js',$root_js,$CONFIG['CABECERA_FORMATOS_HTML']);
?>
Sticker: |
Vehiculo: |
Fecha Ingreso : |
Hora Ingreso: |
Ubicacion: |
No de Carta Porte:
|
Tipo de Deposito:
|
Cliente: '.substr( $vec[2],0,25) ?> |
No Manifiesto de Carga: |
Fecha: |
Bultos: |
Peso: |
Observaciones: '. $observaciones ?> |
$html=ob_get_clean();
// output the HTML content
$pdf->writeHTML($html, true, false,false,false);
// reset pointer to the last page
$pdf->lastPage();
$nomdoc=md5(time()).'.pdf';
$pdf->Output($root."/tmp/".$nomdoc, 'F');
$url=$root_js.'tmp/'.$nomdoc;
TWFSV_75:20:00:00
TWFSV_74:2014-09-18
TWFSV_73:JGL54
TWFSV_72:122
T59_116_184_8_9_44:
T59_115_182_6_7_37:Módulo A
T59_115_182_6_7_32:
T59_109_177_4_5_75:2015-01-13
T59_109_177_4_5_69:gh
T59_109_177_4_5_64:Seleccione una opción
T59_109_177_4_5_40:6
T59_109_177_4_5_39:6
T59_109_177_4_5_24:Importación
T59_109_177_4_5_22:6
T59_109_177_4_5_21:6
Retorno :
Array
(
[ret] => inicioComponente_WF_DocSalida({"id":"1005","caso_id":"11644","proceso_id":59,"tit":"Imp - Descargue","tarea_id":115,"paso_id":192,"desc":"Rotulo<\/strong>: Rotulo del la mercancia luego del descargue","url":"De clic aqui para descargar el archivo<\/a><\/div>"});
[suc] => 1
)
fin 2015-07-30 12:34:41
/******************************************************************************************************/
2015-07-30 12:34:56TraerCaso(11644,59,)
CargarCaso :11644
2015-07 30 12:34:56
CargarDatos: Caso :11644
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_59_seguimiento_id,wf_paso_id from wf_caso_59_pasos a1 group by wf_caso_59_seguimiento_id,wf_paso_id order by id
)a
inner join wf_caso_59_pasos p using(id,wf_caso_59_seguimiento_id)
inner join ( select max(id) as wf_caso_59_seguimiento_id,wf_caso_59_id,wf_tarea_id from wf_caso_59_seguimiento where wf_caso_59_id =? group by wf_caso_59_id,wf_tarea_id order by wf_caso_59_id,wf_caso_59_seguimiento_id ) b using(wf_caso_59_seguimiento_id)
left join usuarios u using(core_usuario_id)
{"0":"115478","id":"115478","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"172","wf_paso_id":"172","4":"109430","wf_caso_59_seguimiento_id":"109430","5":"2015-01-13 17:25:46","fecha_ejec":"2015-01-13 17:25:46","6":"330200","dato":"330200","7":"sce.t2","tabla":"sce.t2","8":"1","core_usuario_id":"1","9":"105","tarea_id":"105","10":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_ejec":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
CargarDatos_172(330200)
se carga 59_105_172_2_2_81
se carga 59_105_172_2_2_10
{"0":"115479","id":"115479","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"174","wf_paso_id":"174","4":"109431","wf_caso_59_seguimiento_id":"109431","5":"2015-01-13 17:25:58","fecha_ejec":"2015-01-13 17:25:58","6":"104739","dato":"104739","7":"wf_documentoentradadatos","tabla":"wf_documentoentradadatos","8":"1","core_usuario_id":"1","9":"107","tarea_id":"107","10":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_ejec":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
CargarDatos_174(104739)
Documento 104739
Documento 104739
{"0":"115480","id":"115480","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"176","wf_paso_id":"176","4":"109431","wf_caso_59_seguimiento_id":"109431","5":"2015-01-13 17:26:03","fecha_ejec":"2015-01-13 17:26:03","6":"104740","dato":"104740","7":"wf_documentoentradadatos","tabla":"wf_documentoentradadatos","8":"1","core_usuario_id":"1","9":"107","tarea_id":"107","10":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_ejec":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
CargarDatos_176(104740)
Documento 104740
Documento 104740
{"0":"115481","id":"115481","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"175","wf_paso_id":"175","4":"109431","wf_caso_59_seguimiento_id":"109431","5":"2015-01-13 17:26:13","fecha_ejec":"2015-01-13 17:26:13","6":"104741","dato":"104741","7":"wf_documentoentradadatos","tabla":"wf_documentoentradadatos","8":"1","core_usuario_id":"1","9":"107","tarea_id":"107","10":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_ejec":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
CargarDatos_175(104741)
Documento 104741
Documento 104741
{"0":"115482","id":"115482","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"177","wf_paso_id":"177","4":"109432","wf_caso_59_seguimiento_id":"109432","5":"2015-01-13 17:26:43","fecha_ejec":"2015-01-13 17:26:43","6":"108083","dato":"108083","7":"sce.t4","tabla":"sce.t4","8":"1","core_usuario_id":"1","9":"109","tarea_id":"109","10":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_ejec":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
CargarDatos_177(108083)
se carga 59_109_177_4_5_752015-01-13
se carga 59_109_177_4_5_69gh
se carga 59_109_177_4_5_68
se carga 59_109_177_4_5_64Seleccione una opción
se carga 59_109_177_4_5_412015-01-13
se carga 59_109_177_4_5_406
se carga 59_109_177_4_5_396
se carga 59_109_177_4_5_241
se carga 59_109_177_4_5_226
se carga 59_109_177_4_5_216
{"0":"115483","id":"115483","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"182","wf_paso_id":"182","4":"109433","wf_caso_59_seguimiento_id":"109433","5":"2015-01-13 17:26:54","fecha_ejec":"2015-01-13 17:26:54","6":"109611","dato":"109611","7":"sce.t6","tabla":"sce.t6","8":"1","core_usuario_id":"1","9":"115","tarea_id":"115","10":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_ejec":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
CargarDatos_182(109611)
se carga 59_115_182_6_7_381
se carga 59_115_182_6_7_371
se carga 59_115_182_6_7_32
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_59_seguimiento a
inner join (
select max(b0.id) as id,b0.wf_caso_59_id,b0.wf_tarea_id from wf_caso_59_seguimiento b0 where b0.wf_caso_59_id =? group by b0.wf_caso_59_id,b0.wf_tarea_id order by wf_caso_59_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":"109430","id":"109430","1":"11644","wf_caso_59_id":"11644","2":"105","wf_tarea_id":"105","3":null,"core_usuario_id":null,"4":"2015-01-13 17:25:41","fec_asig":"2015-01-13 17:25:41","5":"2015-01-13 17:25:47","fec_resol":"2015-01-13 17:25:47","6":"105","wf_tarea_id_sig":"105","7":"1","core_usuario_id_resol":"1","8":null,"usr_asig":null,"9":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_resol":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
{"0":"109431","id":"109431","1":"11644","wf_caso_59_id":"11644","2":"107","wf_tarea_id":"107","3":"1","core_usuario_id":"1","4":"2015-01-13 17:25:47","fec_asig":"2015-01-13 17:25:47","5":"2015-01-13 17:26:13","fec_resol":"2015-01-13 17:26:13","6":"107","wf_tarea_id_sig":"107","7":"1","core_usuario_id_resol":"1","8":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_asig":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","9":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_resol":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
{"0":"109432","id":"109432","1":"11644","wf_caso_59_id":"11644","2":"109","wf_tarea_id":"109","3":"1","core_usuario_id":"1","4":"2015-01-13 17:26:13","fec_asig":"2015-01-13 17:26:13","5":"2015-01-13 17:26:43","fec_resol":"2015-01-13 17:26:43","6":"109","wf_tarea_id_sig":"109","7":"1","core_usuario_id_resol":"1","8":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_asig":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","9":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_resol":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
{"0":"109433","id":"109433","1":"11644","wf_caso_59_id":"11644","2":"115","wf_tarea_id":"115","3":"1","core_usuario_id":"1","4":"2015-01-13 17:26:43","fec_asig":"2015-01-13 17:26:43","5":null,"fec_resol":null,"6":"115","wf_tarea_id_sig":"115","7":null,"core_usuario_id_resol":null,"8":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_asig":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","9":null,"usr_resol":null}
2015-07 30 12:34:56
cargar datos del sujeto(,,s,59,11644)
select s.*, m.nombre as nom_muni, c.nom_cat,fec_caso
from wf_caso_59 w
inner join core_sujetoverificacion s on w.id=11644 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 30 12:34:56
tabla dat adic
select tabla from core_sujetoverificaciontipo where id=1
2015-07 30 12:34:56
tabla :core_sujetoverificacionstickerentrada
SELECT * FROM core_sujetoverificacionstickerentrada where id=11596
2015-07 30 12:34:56
Continuar(s,115,192,)
EjecutarTarea_115() Imp - Descargue id_comp1005
1 1
ValidarUsuario(115):1
EjecutarPaso_192: docs:4 , caso=11644 id_comp 1005
Paso::Guardar(Caso:11644)
rta: 1 dato:11598 tabla:core_upload
CasoPaso:115484
CargarDatos_192(11598)
SiguientePasoDe192: Funcion para ejecutar el siguiente paso
Condicion Tarea : true
TerminarTarea(115,116)
Ultimo seg :109433
Ultimo seg :109434
EjecutarTarea_116() Imp - Repeso id_comp1005
1 1
ValidarUsuario(116):1
EjecutarPaso_184: form:8 , caso=11644 id_comp 1005
Mostrar form
Retorno :
Array
(
[ret] => Ext.getCmp('comp_1005').removeAll();Ext.getCmp('comp_1005').add(new Ext.form.FormPanel({ title: 'Información Re-Peso ' ,padding: 10,id:'frm_formulario_59_11644',autoScroll:true ,labelAlign:'top',defaults: { anchor: '97%'} ,items: [new Ext.form.Hidden({name:'cod_formulario2',value:'8'}) ,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:'9'}) ,new Ext.form.Hidden({name :'oid',value:''}) ,{value:'',xtype:'numberfield' , maxLength:8,autoCreate:{ tag:'input',maxlength:'8'} ,id:'43',fieldLabel:'Peso Bruto' },{value:'',xtype:'numberfield' , maxLength:8,autoCreate:{ tag:'input',maxlength:'8'} ,id:'44',fieldLabel:'Tara' },{value:'',xtype:'numberfield' , maxLength:8,autoCreate:{ tag:'input',maxlength:'8'} ,id:'45',fieldLabel:'Peso Neto' }, new Ext.form.TextArea({id:'46', fieldLabel:'Observaciones',name:'46'}) ] ,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_59_11644'); 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:'59',wf_paso_id:'184',wf_tarea_id:'116',wf_caso_id:'11644',id:'1005',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_59_11644').getForm().loadRecord(new Ext.data.Record({"cod_formulario":8,"cod_bloque":9,"43":null,"44":null,"45":null})); llamadaAJAX({url:'http://192.168.10.116/sisad/build/view/workflow/casos/casos_datosForm.php',mostrarMsg:false,params:{accion:'verifica',wf_paso_id:'184',cod_formulario:'8',cod_bloque:'9',wf_caso_id:'{"pro":"59","cas":"11644"}'}}); }catch(e){alert(e);}} } }) );Ext.getCmp('comp_1005').doLayout();
[suc] => 1
)
fin 2015-07-30 12:34:56
/******************************************************************************************************/
2015-07-30 12:34:57TraerCaso(11644,59,)
CargarCaso :11644
2015-07 30 12:34:57
CargarDatos: Caso :11644
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_59_seguimiento_id,wf_paso_id from wf_caso_59_pasos a1 group by wf_caso_59_seguimiento_id,wf_paso_id order by id
)a
inner join wf_caso_59_pasos p using(id,wf_caso_59_seguimiento_id)
inner join ( select max(id) as wf_caso_59_seguimiento_id,wf_caso_59_id,wf_tarea_id from wf_caso_59_seguimiento where wf_caso_59_id =? group by wf_caso_59_id,wf_tarea_id order by wf_caso_59_id,wf_caso_59_seguimiento_id ) b using(wf_caso_59_seguimiento_id)
left join usuarios u using(core_usuario_id)
{"0":"115478","id":"115478","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"172","wf_paso_id":"172","4":"109430","wf_caso_59_seguimiento_id":"109430","5":"2015-01-13 17:25:46","fecha_ejec":"2015-01-13 17:25:46","6":"330200","dato":"330200","7":"sce.t2","tabla":"sce.t2","8":"1","core_usuario_id":"1","9":"105","tarea_id":"105","10":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_ejec":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
CargarDatos_172(330200)
se carga 59_105_172_2_2_81
se carga 59_105_172_2_2_10
{"0":"115479","id":"115479","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"174","wf_paso_id":"174","4":"109431","wf_caso_59_seguimiento_id":"109431","5":"2015-01-13 17:25:58","fecha_ejec":"2015-01-13 17:25:58","6":"104739","dato":"104739","7":"wf_documentoentradadatos","tabla":"wf_documentoentradadatos","8":"1","core_usuario_id":"1","9":"107","tarea_id":"107","10":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_ejec":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
CargarDatos_174(104739)
Documento 104739
Documento 104739
{"0":"115480","id":"115480","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"176","wf_paso_id":"176","4":"109431","wf_caso_59_seguimiento_id":"109431","5":"2015-01-13 17:26:03","fecha_ejec":"2015-01-13 17:26:03","6":"104740","dato":"104740","7":"wf_documentoentradadatos","tabla":"wf_documentoentradadatos","8":"1","core_usuario_id":"1","9":"107","tarea_id":"107","10":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_ejec":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
CargarDatos_176(104740)
Documento 104740
Documento 104740
{"0":"115481","id":"115481","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"175","wf_paso_id":"175","4":"109431","wf_caso_59_seguimiento_id":"109431","5":"2015-01-13 17:26:13","fecha_ejec":"2015-01-13 17:26:13","6":"104741","dato":"104741","7":"wf_documentoentradadatos","tabla":"wf_documentoentradadatos","8":"1","core_usuario_id":"1","9":"107","tarea_id":"107","10":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_ejec":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
CargarDatos_175(104741)
Documento 104741
Documento 104741
{"0":"115482","id":"115482","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"177","wf_paso_id":"177","4":"109432","wf_caso_59_seguimiento_id":"109432","5":"2015-01-13 17:26:43","fecha_ejec":"2015-01-13 17:26:43","6":"108083","dato":"108083","7":"sce.t4","tabla":"sce.t4","8":"1","core_usuario_id":"1","9":"109","tarea_id":"109","10":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_ejec":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
CargarDatos_177(108083)
se carga 59_109_177_4_5_752015-01-13
se carga 59_109_177_4_5_69gh
se carga 59_109_177_4_5_68
se carga 59_109_177_4_5_64Seleccione una opción
se carga 59_109_177_4_5_412015-01-13
se carga 59_109_177_4_5_406
se carga 59_109_177_4_5_396
se carga 59_109_177_4_5_241
se carga 59_109_177_4_5_226
se carga 59_109_177_4_5_216
{"0":"115483","id":"115483","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"182","wf_paso_id":"182","4":"109433","wf_caso_59_seguimiento_id":"109433","5":"2015-01-13 17:26:54","fecha_ejec":"2015-01-13 17:26:54","6":"109611","dato":"109611","7":"sce.t6","tabla":"sce.t6","8":"1","core_usuario_id":"1","9":"115","tarea_id":"115","10":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_ejec":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
CargarDatos_182(109611)
se carga 59_115_182_6_7_381
se carga 59_115_182_6_7_371
se carga 59_115_182_6_7_32
{"0":"115484","id":"115484","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"192","wf_paso_id":"192","4":"109433","wf_caso_59_seguimiento_id":"109433","5":"2015-07-30 12:34:56","fecha_ejec":"2015-07-30 12:34:56","6":"11598","dato":"11598","7":"core_upload","tabla":"core_upload","8":"1","core_usuario_id":"1","9":"115","tarea_id":"115","10":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_ejec":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
CargarDatos_192(11598)
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_59_seguimiento a
inner join (
select max(b0.id) as id,b0.wf_caso_59_id,b0.wf_tarea_id from wf_caso_59_seguimiento b0 where b0.wf_caso_59_id =? group by b0.wf_caso_59_id,b0.wf_tarea_id order by wf_caso_59_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":"109430","id":"109430","1":"11644","wf_caso_59_id":"11644","2":"105","wf_tarea_id":"105","3":null,"core_usuario_id":null,"4":"2015-01-13 17:25:41","fec_asig":"2015-01-13 17:25:41","5":"2015-01-13 17:25:47","fec_resol":"2015-01-13 17:25:47","6":"105","wf_tarea_id_sig":"105","7":"1","core_usuario_id_resol":"1","8":null,"usr_asig":null,"9":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_resol":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
{"0":"109431","id":"109431","1":"11644","wf_caso_59_id":"11644","2":"107","wf_tarea_id":"107","3":"1","core_usuario_id":"1","4":"2015-01-13 17:25:47","fec_asig":"2015-01-13 17:25:47","5":"2015-01-13 17:26:13","fec_resol":"2015-01-13 17:26:13","6":"107","wf_tarea_id_sig":"107","7":"1","core_usuario_id_resol":"1","8":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_asig":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","9":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_resol":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
{"0":"109432","id":"109432","1":"11644","wf_caso_59_id":"11644","2":"109","wf_tarea_id":"109","3":"1","core_usuario_id":"1","4":"2015-01-13 17:26:13","fec_asig":"2015-01-13 17:26:13","5":"2015-01-13 17:26:43","fec_resol":"2015-01-13 17:26:43","6":"109","wf_tarea_id_sig":"109","7":"1","core_usuario_id_resol":"1","8":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_asig":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","9":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_resol":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
{"0":"109433","id":"109433","1":"11644","wf_caso_59_id":"11644","2":"115","wf_tarea_id":"115","3":"1","core_usuario_id":"1","4":"2015-01-13 17:26:43","fec_asig":"2015-01-13 17:26:43","5":"2015-07-30 12:34:56","fec_resol":"2015-07-30 12:34:56","6":"115","wf_tarea_id_sig":"115","7":"1","core_usuario_id_resol":"1","8":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_asig":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","9":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_resol":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
{"0":"109434","id":"109434","1":"11644","wf_caso_59_id":"11644","2":"116","wf_tarea_id":"116","3":"1","core_usuario_id":"1","4":"2015-07-30 12:34:56","fec_asig":"2015-07-30 12:34:56","5":null,"fec_resol":null,"6":"116","wf_tarea_id_sig":"116","7":null,"core_usuario_id_resol":null,"8":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_asig":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","9":null,"usr_resol":null}
2015-07 30 12:34:57
cargar datos del sujeto(,,s,59,11644)
select s.*, m.nombre as nom_muni, c.nom_cat,fec_caso
from wf_caso_59 w
inner join core_sujetoverificacion s on w.id=11644 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 30 12:34:57
tabla dat adic
select tabla from core_sujetoverificaciontipo where id=1
2015-07 30 12:34:57
tabla :core_sujetoverificacionstickerentrada
SELECT * FROM core_sujetoverificacionstickerentrada where id=11596
fin 2015-07-30 12:34:57
/******************************************************************************************************/
2015-07-30 12:35:08TraerCaso(11644,59,)
CargarCaso :11644
2015-07 30 12:35:08
CargarDatos: Caso :11644
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_59_seguimiento_id,wf_paso_id from wf_caso_59_pasos a1 group by wf_caso_59_seguimiento_id,wf_paso_id order by id
)a
inner join wf_caso_59_pasos p using(id,wf_caso_59_seguimiento_id)
inner join ( select max(id) as wf_caso_59_seguimiento_id,wf_caso_59_id,wf_tarea_id from wf_caso_59_seguimiento where wf_caso_59_id =? group by wf_caso_59_id,wf_tarea_id order by wf_caso_59_id,wf_caso_59_seguimiento_id ) b using(wf_caso_59_seguimiento_id)
left join usuarios u using(core_usuario_id)
{"0":"115478","id":"115478","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"172","wf_paso_id":"172","4":"109430","wf_caso_59_seguimiento_id":"109430","5":"2015-01-13 17:25:46","fecha_ejec":"2015-01-13 17:25:46","6":"330200","dato":"330200","7":"sce.t2","tabla":"sce.t2","8":"1","core_usuario_id":"1","9":"105","tarea_id":"105","10":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_ejec":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
CargarDatos_172(330200)
se carga 59_105_172_2_2_81
se carga 59_105_172_2_2_10
{"0":"115479","id":"115479","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"174","wf_paso_id":"174","4":"109431","wf_caso_59_seguimiento_id":"109431","5":"2015-01-13 17:25:58","fecha_ejec":"2015-01-13 17:25:58","6":"104739","dato":"104739","7":"wf_documentoentradadatos","tabla":"wf_documentoentradadatos","8":"1","core_usuario_id":"1","9":"107","tarea_id":"107","10":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_ejec":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
CargarDatos_174(104739)
Documento 104739
Documento 104739
{"0":"115480","id":"115480","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"176","wf_paso_id":"176","4":"109431","wf_caso_59_seguimiento_id":"109431","5":"2015-01-13 17:26:03","fecha_ejec":"2015-01-13 17:26:03","6":"104740","dato":"104740","7":"wf_documentoentradadatos","tabla":"wf_documentoentradadatos","8":"1","core_usuario_id":"1","9":"107","tarea_id":"107","10":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_ejec":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
CargarDatos_176(104740)
Documento 104740
Documento 104740
{"0":"115481","id":"115481","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"175","wf_paso_id":"175","4":"109431","wf_caso_59_seguimiento_id":"109431","5":"2015-01-13 17:26:13","fecha_ejec":"2015-01-13 17:26:13","6":"104741","dato":"104741","7":"wf_documentoentradadatos","tabla":"wf_documentoentradadatos","8":"1","core_usuario_id":"1","9":"107","tarea_id":"107","10":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_ejec":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
CargarDatos_175(104741)
Documento 104741
Documento 104741
{"0":"115482","id":"115482","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"177","wf_paso_id":"177","4":"109432","wf_caso_59_seguimiento_id":"109432","5":"2015-01-13 17:26:43","fecha_ejec":"2015-01-13 17:26:43","6":"108083","dato":"108083","7":"sce.t4","tabla":"sce.t4","8":"1","core_usuario_id":"1","9":"109","tarea_id":"109","10":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_ejec":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
CargarDatos_177(108083)
se carga 59_109_177_4_5_752015-01-13
se carga 59_109_177_4_5_69gh
se carga 59_109_177_4_5_68
se carga 59_109_177_4_5_64Seleccione una opción
se carga 59_109_177_4_5_412015-01-13
se carga 59_109_177_4_5_406
se carga 59_109_177_4_5_396
se carga 59_109_177_4_5_241
se carga 59_109_177_4_5_226
se carga 59_109_177_4_5_216
{"0":"115483","id":"115483","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"182","wf_paso_id":"182","4":"109433","wf_caso_59_seguimiento_id":"109433","5":"2015-01-13 17:26:54","fecha_ejec":"2015-01-13 17:26:54","6":"109611","dato":"109611","7":"sce.t6","tabla":"sce.t6","8":"1","core_usuario_id":"1","9":"115","tarea_id":"115","10":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_ejec":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
CargarDatos_182(109611)
se carga 59_115_182_6_7_381
se carga 59_115_182_6_7_371
se carga 59_115_182_6_7_32
{"0":"115484","id":"115484","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"192","wf_paso_id":"192","4":"109433","wf_caso_59_seguimiento_id":"109433","5":"2015-07-30 12:34:56","fecha_ejec":"2015-07-30 12:34:56","6":"11598","dato":"11598","7":"core_upload","tabla":"core_upload","8":"1","core_usuario_id":"1","9":"115","tarea_id":"115","10":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_ejec":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
CargarDatos_192(11598)
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_59_seguimiento a
inner join (
select max(b0.id) as id,b0.wf_caso_59_id,b0.wf_tarea_id from wf_caso_59_seguimiento b0 where b0.wf_caso_59_id =? group by b0.wf_caso_59_id,b0.wf_tarea_id order by wf_caso_59_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":"109430","id":"109430","1":"11644","wf_caso_59_id":"11644","2":"105","wf_tarea_id":"105","3":null,"core_usuario_id":null,"4":"2015-01-13 17:25:41","fec_asig":"2015-01-13 17:25:41","5":"2015-01-13 17:25:47","fec_resol":"2015-01-13 17:25:47","6":"105","wf_tarea_id_sig":"105","7":"1","core_usuario_id_resol":"1","8":null,"usr_asig":null,"9":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_resol":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
{"0":"109431","id":"109431","1":"11644","wf_caso_59_id":"11644","2":"107","wf_tarea_id":"107","3":"1","core_usuario_id":"1","4":"2015-01-13 17:25:47","fec_asig":"2015-01-13 17:25:47","5":"2015-01-13 17:26:13","fec_resol":"2015-01-13 17:26:13","6":"107","wf_tarea_id_sig":"107","7":"1","core_usuario_id_resol":"1","8":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_asig":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","9":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_resol":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
{"0":"109432","id":"109432","1":"11644","wf_caso_59_id":"11644","2":"109","wf_tarea_id":"109","3":"1","core_usuario_id":"1","4":"2015-01-13 17:26:13","fec_asig":"2015-01-13 17:26:13","5":"2015-01-13 17:26:43","fec_resol":"2015-01-13 17:26:43","6":"109","wf_tarea_id_sig":"109","7":"1","core_usuario_id_resol":"1","8":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_asig":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","9":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_resol":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
{"0":"109433","id":"109433","1":"11644","wf_caso_59_id":"11644","2":"115","wf_tarea_id":"115","3":"1","core_usuario_id":"1","4":"2015-01-13 17:26:43","fec_asig":"2015-01-13 17:26:43","5":"2015-07-30 12:34:56","fec_resol":"2015-07-30 12:34:56","6":"115","wf_tarea_id_sig":"115","7":"1","core_usuario_id_resol":"1","8":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_asig":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","9":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_resol":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
{"0":"109434","id":"109434","1":"11644","wf_caso_59_id":"11644","2":"116","wf_tarea_id":"116","3":"1","core_usuario_id":"1","4":"2015-07-30 12:34:56","fec_asig":"2015-07-30 12:34:56","5":null,"fec_resol":null,"6":"116","wf_tarea_id_sig":"116","7":null,"core_usuario_id_resol":null,"8":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_asig":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","9":null,"usr_resol":null}
2015-07 30 12:35:08
cargar datos del sujeto(,,s,59,11644)
select s.*, m.nombre as nom_muni, c.nom_cat,fec_caso
from wf_caso_59 w
inner join core_sujetoverificacion s on w.id=11644 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 30 12:35:08
tabla dat adic
select tabla from core_sujetoverificaciontipo where id=1
2015-07 30 12:35:08
tabla :core_sujetoverificacionstickerentrada
SELECT * FROM core_sujetoverificacionstickerentrada where id=11596
2015-07 30 12:35:08
Continuar(s,116,184,)
EjecutarTarea_116() Imp - Repeso id_comp1005
1 1
ValidarUsuario(116):1
EjecutarPaso_184: form:8 , caso=11644 id_comp 1005
Paso::Guardar(Caso:11644)
Datos a guardar:
Array
(
[wf_proceso_id] => 59
[wf_paso_id] => 184
[wf_tarea_id] => 116
[wf_caso_id] => 11644
[id] => 1005
[accion] => nextPaso
[reg] => s
[rta] => n
[cod_formulario2] => 8
[id_periodo] => 2015
[obs_ingreso] =>
[cod_bloque] => 9
[oid] =>
[43] => 200
[44] => 2
[45] => 202
[46] => ffff
)
OID: 111144
rta: 1 dato:111144 tabla:sce.t8
CasoPaso:115485
CargarDatos_184(111144)
se carga 59_116_184_8_9_46ffff
se carga 59_116_184_8_9_45202
se carga 59_116_184_8_9_442
se carga 59_116_184_8_9_43200
SiguientePasoDe184: Funcion para ejecutar el siguiente paso
EjecutarPaso_194: docs:11 , caso=11644 id_comp 1005
Mostrar docs
$tit_formato='FORMATO DE MOVIMIENTO DE BODEGA';
$cod=' WFSV_72 ';
$ubicacion =' 59_115_182_6_7_37 ';
$desc_mercancia=' 59_109_177_4_5_69 ';
$unidad=' 59_109_177_4_5_68 ';
$pla_veh =' WFSV_73 ';
$fech_ing =' WFSV_74 ';
$hora_ing =' WFSV_75 ';
$carta_porte =' 59_109_177_4_5_39 ';
$tipo_deposito=' 59_109_177_4_5_24 ';
$cliente=' 59_109_177_4_5_64 ';
$man_dian =' 59_109_177_4_5_40 ';
$fecha_dian=' { 59_109_177_4_5_75 } ';
$bultos =' 59_109_177_4_5_21 ';
$observaciones =' 59_115_182_6_7_32 ';
$peso_doc=' 59_109_177_4_5_22 ';
$peso_bruto=trim(' 59_116_184_8_9_43 ')*1;
$tara_repeso=trim(' 59_116_184_8_9_44 ')*1;
$peso=$peso_bruto-$tara_repeso;
$dep__=new ADODB_Active_Record('wf_caso_59_cons_carta_porte');
$dep__->Load("no_carta like '".trim($carta_porte)."' ");
$no_deposito=$dep__->consec;
require_once($root.'/lib/tcpdf/config/lang/eng.php');
require_once($root.'/lib/tcpdf/tcpdf.php');
// create new PDF document
$pdf = new TCPDF('p', 'mm', 'letter', true, 'UTF-8', false);
// set document information
$pdf->SetCreator(PDF_CREATOR);
$pdf->SetAuthor('SITI Ltda');
$pdf->setPrintHeader(false);
//set auto page breaks
//set image scale factor
$pdf->setImageScale(PDF_IMAGE_SCALE_RATIO);
//set some language-dependent strings
$pdf->setLanguageArray($l);
// ---------------------------------------------------------
// NOTE: 2D barcode algorithms must be implemented on 2dbarcode.php class file.
// set font
$pdf->SetFont('helvetica', '', 10);
// add a page
$pdf->AddPage();
// - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
$fils=4;
$cols=3;
$logo_empresa=$CONFIG['LOGO_EMPRESA'];
$codigo=$root_js.'build/view/common/marco/index.php?particular=001&accion=I&proc='.$CONFIG['PROCESO_STICKER'];
$izq=10+2;$der=10;$arr=10; $abj=10;
$pdf->SetMargins ( $izq,$arr,$der,true );
$pdf->SetAutoPageBreak(TRUE, $abj);
$pdf->setPrintHeader(false);
$sxp=$fils*$cols;
$tot=$rangoF-$rangoI+1;
$pags=ceil(($tot)/$sxp);
$anchoR=216-$izq-$der;
$altoR=279-$arr-$abj;
$anchoS=$anchoR/$cols;
$margenSV=2;
$margenSH=5;
$altoS=$altoR/$fils;
$altoImg=10;
$altoText=8;
$altoC=50;
// set style for barcode
$style = array(
'border' => 2,
'vpadding' => 'auto',
'hpadding' => 'auto',
'fgcolor' => array(0,0,0),
'bgcolor' => false, //array(255,255,255)
'module_width' => 1, // width of a single module in points
'module_height' => 1 // height of a single module in points
);
$pdf->SetFont('helvetica', '', 9, '', false);
$pdf->SetDefaultMonospacedFont(PDF_FONT_MONOSPACED);
$s=0;$p=1;$consc=$rangoI;
$y=$arr;
$x=$izq;
$pdf->SetXY($x, $y);
//$pdf->Image($root.$logo_empresa, $x, $y+$altoImg, 0, $altoImg, 'PNG', '', 'center', true, 150, '', false, false, 0, false, false, false);
$pdf->SetXY($x+($anchoR-$altoC), $y);
// QRCODE,H : QR-CODE Best error correction
//($code,$type,$x = '',$y = '',$w = '',$h = '',$style = '',$align = '',$distort = false )
$pdf->write2DBarcode($codigo.'&sujeto='.trim($cod), 'QRCODE,Q', '', $y+15, $altoC, $altoC, $style, 'N');
//$pdf->Text($x+($anchoR-$altoC-10), $y+$altoC+$altoText,$cod );
$pdf->SetXY($x, $y);
// create some HTML content
ob_start();
echo str_replace('$root_js',$root_js,$CONFIG['CABECERA_FORMATOS_HTML']);
?>
Sticker: |
Vehiculo: |
Fecha Ingreso : |
Hora Ingreso: |
Ubicacion: |
No Carta Porte:
|
T. Deposito:
|
Cliente: '.substr( $vec[2],0,25) ?> |
No Manifiesto de Carga: |
Fecha:
|
No Deposito:
|
U. Empaque:
|
Cantidad:
|
Peso: |
Descripción Mercancia: |
Firma Deposito |
Firma Cliente |
Elaborado por SITI Ltda - www.siticol.com
$html=ob_get_clean();
// output the HTML content
$pdf->writeHTML($html, true, false,false,false);
// reset pointer to the last page
$pdf->lastPage();
$nomdoc=md5(time()).'.pdf';
$pdf->Output($root."/tmp/".$nomdoc, 'F');
$url=$root_js.'tmp/'.$nomdoc;
TWFSV_75:20:00:00
TWFSV_74:2014-09-18
TWFSV_73:JGL54
TWFSV_72:122
T59_116_184_8_9_44:2
T59_116_184_8_9_43:200
T59_115_182_6_7_37:Módulo A
T59_115_182_6_7_32:
T59_109_177_4_5_75:2015-01-13
T59_109_177_4_5_69:gh
T59_109_177_4_5_68:
T59_109_177_4_5_64:Seleccione una opción
T59_109_177_4_5_40:6
T59_109_177_4_5_39:6
T59_109_177_4_5_24:Importación
T59_109_177_4_5_22:6
T59_109_177_4_5_21:6
Retorno :
Array
(
[ret] => inicioComponente_WF_DocSalida({"id":"1005","caso_id":"11644","proceso_id":59,"tit":"Imp - Repeso","tarea_id":116,"paso_id":194,"desc":"Movimiento Bodega<\/strong>: Movimiento Bodega","url":"De clic aqui para descargar el archivo<\/a><\/div>"});
[suc] => 1
)
fin 2015-07-30 12:35:09
/******************************************************************************************************/
2015-07-30 12:35:22TraerCaso(11644,59,)
CargarCaso :11644
2015-07 30 12:35:22
CargarDatos: Caso :11644
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_59_seguimiento_id,wf_paso_id from wf_caso_59_pasos a1 group by wf_caso_59_seguimiento_id,wf_paso_id order by id
)a
inner join wf_caso_59_pasos p using(id,wf_caso_59_seguimiento_id)
inner join ( select max(id) as wf_caso_59_seguimiento_id,wf_caso_59_id,wf_tarea_id from wf_caso_59_seguimiento where wf_caso_59_id =? group by wf_caso_59_id,wf_tarea_id order by wf_caso_59_id,wf_caso_59_seguimiento_id ) b using(wf_caso_59_seguimiento_id)
left join usuarios u using(core_usuario_id)
{"0":"115478","id":"115478","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"172","wf_paso_id":"172","4":"109430","wf_caso_59_seguimiento_id":"109430","5":"2015-01-13 17:25:46","fecha_ejec":"2015-01-13 17:25:46","6":"330200","dato":"330200","7":"sce.t2","tabla":"sce.t2","8":"1","core_usuario_id":"1","9":"105","tarea_id":"105","10":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_ejec":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
CargarDatos_172(330200)
se carga 59_105_172_2_2_81
se carga 59_105_172_2_2_10
{"0":"115479","id":"115479","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"174","wf_paso_id":"174","4":"109431","wf_caso_59_seguimiento_id":"109431","5":"2015-01-13 17:25:58","fecha_ejec":"2015-01-13 17:25:58","6":"104739","dato":"104739","7":"wf_documentoentradadatos","tabla":"wf_documentoentradadatos","8":"1","core_usuario_id":"1","9":"107","tarea_id":"107","10":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_ejec":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
CargarDatos_174(104739)
Documento 104739
Documento 104739
{"0":"115480","id":"115480","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"176","wf_paso_id":"176","4":"109431","wf_caso_59_seguimiento_id":"109431","5":"2015-01-13 17:26:03","fecha_ejec":"2015-01-13 17:26:03","6":"104740","dato":"104740","7":"wf_documentoentradadatos","tabla":"wf_documentoentradadatos","8":"1","core_usuario_id":"1","9":"107","tarea_id":"107","10":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_ejec":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
CargarDatos_176(104740)
Documento 104740
Documento 104740
{"0":"115481","id":"115481","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"175","wf_paso_id":"175","4":"109431","wf_caso_59_seguimiento_id":"109431","5":"2015-01-13 17:26:13","fecha_ejec":"2015-01-13 17:26:13","6":"104741","dato":"104741","7":"wf_documentoentradadatos","tabla":"wf_documentoentradadatos","8":"1","core_usuario_id":"1","9":"107","tarea_id":"107","10":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_ejec":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
CargarDatos_175(104741)
Documento 104741
Documento 104741
{"0":"115482","id":"115482","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"177","wf_paso_id":"177","4":"109432","wf_caso_59_seguimiento_id":"109432","5":"2015-01-13 17:26:43","fecha_ejec":"2015-01-13 17:26:43","6":"108083","dato":"108083","7":"sce.t4","tabla":"sce.t4","8":"1","core_usuario_id":"1","9":"109","tarea_id":"109","10":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_ejec":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
CargarDatos_177(108083)
se carga 59_109_177_4_5_752015-01-13
se carga 59_109_177_4_5_69gh
se carga 59_109_177_4_5_68
se carga 59_109_177_4_5_64Seleccione una opción
se carga 59_109_177_4_5_412015-01-13
se carga 59_109_177_4_5_406
se carga 59_109_177_4_5_396
se carga 59_109_177_4_5_241
se carga 59_109_177_4_5_226
se carga 59_109_177_4_5_216
{"0":"115483","id":"115483","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"182","wf_paso_id":"182","4":"109433","wf_caso_59_seguimiento_id":"109433","5":"2015-01-13 17:26:54","fecha_ejec":"2015-01-13 17:26:54","6":"109611","dato":"109611","7":"sce.t6","tabla":"sce.t6","8":"1","core_usuario_id":"1","9":"115","tarea_id":"115","10":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_ejec":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
CargarDatos_182(109611)
se carga 59_115_182_6_7_381
se carga 59_115_182_6_7_371
se carga 59_115_182_6_7_32
{"0":"115484","id":"115484","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"192","wf_paso_id":"192","4":"109433","wf_caso_59_seguimiento_id":"109433","5":"2015-07-30 12:34:56","fecha_ejec":"2015-07-30 12:34:56","6":"11598","dato":"11598","7":"core_upload","tabla":"core_upload","8":"1","core_usuario_id":"1","9":"115","tarea_id":"115","10":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_ejec":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
CargarDatos_192(11598)
{"0":"115485","id":"115485","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"184","wf_paso_id":"184","4":"109434","wf_caso_59_seguimiento_id":"109434","5":"2015-07-30 12:35:09","fecha_ejec":"2015-07-30 12:35:09","6":"111144","dato":"111144","7":"sce.t8","tabla":"sce.t8","8":"1","core_usuario_id":"1","9":"116","tarea_id":"116","10":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_ejec":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
CargarDatos_184(111144)
se carga 59_116_184_8_9_46ffff
se carga 59_116_184_8_9_45202
se carga 59_116_184_8_9_442
se carga 59_116_184_8_9_43200
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_59_seguimiento a
inner join (
select max(b0.id) as id,b0.wf_caso_59_id,b0.wf_tarea_id from wf_caso_59_seguimiento b0 where b0.wf_caso_59_id =? group by b0.wf_caso_59_id,b0.wf_tarea_id order by wf_caso_59_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":"109430","id":"109430","1":"11644","wf_caso_59_id":"11644","2":"105","wf_tarea_id":"105","3":null,"core_usuario_id":null,"4":"2015-01-13 17:25:41","fec_asig":"2015-01-13 17:25:41","5":"2015-01-13 17:25:47","fec_resol":"2015-01-13 17:25:47","6":"105","wf_tarea_id_sig":"105","7":"1","core_usuario_id_resol":"1","8":null,"usr_asig":null,"9":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_resol":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
{"0":"109431","id":"109431","1":"11644","wf_caso_59_id":"11644","2":"107","wf_tarea_id":"107","3":"1","core_usuario_id":"1","4":"2015-01-13 17:25:47","fec_asig":"2015-01-13 17:25:47","5":"2015-01-13 17:26:13","fec_resol":"2015-01-13 17:26:13","6":"107","wf_tarea_id_sig":"107","7":"1","core_usuario_id_resol":"1","8":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_asig":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","9":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_resol":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
{"0":"109432","id":"109432","1":"11644","wf_caso_59_id":"11644","2":"109","wf_tarea_id":"109","3":"1","core_usuario_id":"1","4":"2015-01-13 17:26:13","fec_asig":"2015-01-13 17:26:13","5":"2015-01-13 17:26:43","fec_resol":"2015-01-13 17:26:43","6":"109","wf_tarea_id_sig":"109","7":"1","core_usuario_id_resol":"1","8":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_asig":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","9":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_resol":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
{"0":"109433","id":"109433","1":"11644","wf_caso_59_id":"11644","2":"115","wf_tarea_id":"115","3":"1","core_usuario_id":"1","4":"2015-01-13 17:26:43","fec_asig":"2015-01-13 17:26:43","5":"2015-07-30 12:34:56","fec_resol":"2015-07-30 12:34:56","6":"115","wf_tarea_id_sig":"115","7":"1","core_usuario_id_resol":"1","8":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_asig":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","9":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_resol":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
{"0":"109434","id":"109434","1":"11644","wf_caso_59_id":"11644","2":"116","wf_tarea_id":"116","3":"1","core_usuario_id":"1","4":"2015-07-30 12:34:56","fec_asig":"2015-07-30 12:34:56","5":null,"fec_resol":null,"6":"116","wf_tarea_id_sig":"116","7":null,"core_usuario_id_resol":null,"8":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_asig":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","9":null,"usr_resol":null}
2015-07 30 12:35:22
cargar datos del sujeto(,,s,59,11644)
select s.*, m.nombre as nom_muni, c.nom_cat,fec_caso
from wf_caso_59 w
inner join core_sujetoverificacion s on w.id=11644 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 30 12:35:22
tabla dat adic
select tabla from core_sujetoverificaciontipo where id=1
2015-07 30 12:35:22
tabla :core_sujetoverificacionstickerentrada
SELECT * FROM core_sujetoverificacionstickerentrada where id=11596
2015-07 30 12:35:22
Continuar(s,116,194,)
EjecutarTarea_116() Imp - Repeso id_comp1005
1 1
ValidarUsuario(116):1
EjecutarPaso_194: docs:11 , caso=11644 id_comp 1005
Paso::Guardar(Caso:11644)
rta: 1 dato:11599 tabla:core_upload
CasoPaso:115486
CargarDatos_194(11599)
SiguientePasoDe194: Funcion para ejecutar el siguiente paso
Condicion Tarea : true
TerminarTarea(116,122)
Ultimo seg :109434
Ultimo seg :109435
EjecutarTarea_122() Imp - Salida Mercancia id_comp1005
1 1
ValidarUsuario(122):1
EjecutarPaso_193: proc:60 , caso=11644 id_comp 1005
Mostrar proc
verificarProceso(60,193)
conteo lista de subprocesos registrados : 0
conteo lista de datos xa registro : 1
hay subcasos registrados? : 1
ret? :
tipo_ejec : s
conteo casos registrados : 1
ret : Array
(
[id_caso] => 11540
[id_proc] => 60
[ini] =>
)
Retorno :
Array
(
[ret] => inicioComponente_WF_Proceso({"id":"1005","proceso_id":59,"caso_id":"11644","tarea_id":122,"paso_id":193});inicioComponente_WF('subp60_11540','next',60,{caso_id:11540,proceso_id:60});
[suc] => 1
)
fin 2015-07-30 12:35:22
/******************************************************************************************************/
2015-07-30 12:35:46TraerCaso(11644,59,)
CargarCaso :11644
2015-07 30 12:35:46
CargarDatos: Caso :11644
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_59_seguimiento_id,wf_paso_id from wf_caso_59_pasos a1 group by wf_caso_59_seguimiento_id,wf_paso_id order by id
)a
inner join wf_caso_59_pasos p using(id,wf_caso_59_seguimiento_id)
inner join ( select max(id) as wf_caso_59_seguimiento_id,wf_caso_59_id,wf_tarea_id from wf_caso_59_seguimiento where wf_caso_59_id =? group by wf_caso_59_id,wf_tarea_id order by wf_caso_59_id,wf_caso_59_seguimiento_id ) b using(wf_caso_59_seguimiento_id)
left join usuarios u using(core_usuario_id)
{"0":"115478","id":"115478","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"172","wf_paso_id":"172","4":"109430","wf_caso_59_seguimiento_id":"109430","5":"2015-01-13 17:25:46","fecha_ejec":"2015-01-13 17:25:46","6":"330200","dato":"330200","7":"sce.t2","tabla":"sce.t2","8":"1","core_usuario_id":"1","9":"105","tarea_id":"105","10":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_ejec":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
CargarDatos_172(330200)
se carga 59_105_172_2_2_81
se carga 59_105_172_2_2_10
{"0":"115479","id":"115479","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"174","wf_paso_id":"174","4":"109431","wf_caso_59_seguimiento_id":"109431","5":"2015-01-13 17:25:58","fecha_ejec":"2015-01-13 17:25:58","6":"104739","dato":"104739","7":"wf_documentoentradadatos","tabla":"wf_documentoentradadatos","8":"1","core_usuario_id":"1","9":"107","tarea_id":"107","10":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_ejec":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
CargarDatos_174(104739)
Documento 104739
Documento 104739
{"0":"115480","id":"115480","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"176","wf_paso_id":"176","4":"109431","wf_caso_59_seguimiento_id":"109431","5":"2015-01-13 17:26:03","fecha_ejec":"2015-01-13 17:26:03","6":"104740","dato":"104740","7":"wf_documentoentradadatos","tabla":"wf_documentoentradadatos","8":"1","core_usuario_id":"1","9":"107","tarea_id":"107","10":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_ejec":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
CargarDatos_176(104740)
Documento 104740
Documento 104740
{"0":"115481","id":"115481","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"175","wf_paso_id":"175","4":"109431","wf_caso_59_seguimiento_id":"109431","5":"2015-01-13 17:26:13","fecha_ejec":"2015-01-13 17:26:13","6":"104741","dato":"104741","7":"wf_documentoentradadatos","tabla":"wf_documentoentradadatos","8":"1","core_usuario_id":"1","9":"107","tarea_id":"107","10":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_ejec":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
CargarDatos_175(104741)
Documento 104741
Documento 104741
{"0":"115482","id":"115482","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"177","wf_paso_id":"177","4":"109432","wf_caso_59_seguimiento_id":"109432","5":"2015-01-13 17:26:43","fecha_ejec":"2015-01-13 17:26:43","6":"108083","dato":"108083","7":"sce.t4","tabla":"sce.t4","8":"1","core_usuario_id":"1","9":"109","tarea_id":"109","10":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_ejec":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
CargarDatos_177(108083)
se carga 59_109_177_4_5_752015-01-13
se carga 59_109_177_4_5_69gh
se carga 59_109_177_4_5_68
se carga 59_109_177_4_5_64Seleccione una opción
se carga 59_109_177_4_5_412015-01-13
se carga 59_109_177_4_5_406
se carga 59_109_177_4_5_396
se carga 59_109_177_4_5_241
se carga 59_109_177_4_5_226
se carga 59_109_177_4_5_216
{"0":"115483","id":"115483","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"182","wf_paso_id":"182","4":"109433","wf_caso_59_seguimiento_id":"109433","5":"2015-01-13 17:26:54","fecha_ejec":"2015-01-13 17:26:54","6":"109611","dato":"109611","7":"sce.t6","tabla":"sce.t6","8":"1","core_usuario_id":"1","9":"115","tarea_id":"115","10":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_ejec":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
CargarDatos_182(109611)
se carga 59_115_182_6_7_381
se carga 59_115_182_6_7_371
se carga 59_115_182_6_7_32
{"0":"115484","id":"115484","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"192","wf_paso_id":"192","4":"109433","wf_caso_59_seguimiento_id":"109433","5":"2015-07-30 12:34:56","fecha_ejec":"2015-07-30 12:34:56","6":"11598","dato":"11598","7":"core_upload","tabla":"core_upload","8":"1","core_usuario_id":"1","9":"115","tarea_id":"115","10":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_ejec":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
CargarDatos_192(11598)
{"0":"115485","id":"115485","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"184","wf_paso_id":"184","4":"109434","wf_caso_59_seguimiento_id":"109434","5":"2015-07-30 12:35:09","fecha_ejec":"2015-07-30 12:35:09","6":"111144","dato":"111144","7":"sce.t8","tabla":"sce.t8","8":"1","core_usuario_id":"1","9":"116","tarea_id":"116","10":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_ejec":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
CargarDatos_184(111144)
se carga 59_116_184_8_9_46ffff
se carga 59_116_184_8_9_45202
se carga 59_116_184_8_9_442
se carga 59_116_184_8_9_43200
{"0":"115486","id":"115486","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"194","wf_paso_id":"194","4":"109434","wf_caso_59_seguimiento_id":"109434","5":"2015-07-30 12:35:22","fecha_ejec":"2015-07-30 12:35:22","6":"11599","dato":"11599","7":"core_upload","tabla":"core_upload","8":"1","core_usuario_id":"1","9":"116","tarea_id":"116","10":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_ejec":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
CargarDatos_194(11599)
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_59_seguimiento a
inner join (
select max(b0.id) as id,b0.wf_caso_59_id,b0.wf_tarea_id from wf_caso_59_seguimiento b0 where b0.wf_caso_59_id =? group by b0.wf_caso_59_id,b0.wf_tarea_id order by wf_caso_59_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":"109430","id":"109430","1":"11644","wf_caso_59_id":"11644","2":"105","wf_tarea_id":"105","3":null,"core_usuario_id":null,"4":"2015-01-13 17:25:41","fec_asig":"2015-01-13 17:25:41","5":"2015-01-13 17:25:47","fec_resol":"2015-01-13 17:25:47","6":"105","wf_tarea_id_sig":"105","7":"1","core_usuario_id_resol":"1","8":null,"usr_asig":null,"9":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_resol":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
{"0":"109431","id":"109431","1":"11644","wf_caso_59_id":"11644","2":"107","wf_tarea_id":"107","3":"1","core_usuario_id":"1","4":"2015-01-13 17:25:47","fec_asig":"2015-01-13 17:25:47","5":"2015-01-13 17:26:13","fec_resol":"2015-01-13 17:26:13","6":"107","wf_tarea_id_sig":"107","7":"1","core_usuario_id_resol":"1","8":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_asig":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","9":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_resol":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
{"0":"109432","id":"109432","1":"11644","wf_caso_59_id":"11644","2":"109","wf_tarea_id":"109","3":"1","core_usuario_id":"1","4":"2015-01-13 17:26:13","fec_asig":"2015-01-13 17:26:13","5":"2015-01-13 17:26:43","fec_resol":"2015-01-13 17:26:43","6":"109","wf_tarea_id_sig":"109","7":"1","core_usuario_id_resol":"1","8":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_asig":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","9":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_resol":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
{"0":"109433","id":"109433","1":"11644","wf_caso_59_id":"11644","2":"115","wf_tarea_id":"115","3":"1","core_usuario_id":"1","4":"2015-01-13 17:26:43","fec_asig":"2015-01-13 17:26:43","5":"2015-07-30 12:34:56","fec_resol":"2015-07-30 12:34:56","6":"115","wf_tarea_id_sig":"115","7":"1","core_usuario_id_resol":"1","8":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_asig":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","9":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_resol":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
{"0":"109434","id":"109434","1":"11644","wf_caso_59_id":"11644","2":"116","wf_tarea_id":"116","3":"1","core_usuario_id":"1","4":"2015-07-30 12:34:56","fec_asig":"2015-07-30 12:34:56","5":"2015-07-30 12:35:22","fec_resol":"2015-07-30 12:35:22","6":"116","wf_tarea_id_sig":"116","7":"1","core_usuario_id_resol":"1","8":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_asig":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","9":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_resol":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
{"0":"109435","id":"109435","1":"11644","wf_caso_59_id":"11644","2":"122","wf_tarea_id":"122","3":"1","core_usuario_id":"1","4":"2015-07-30 12:35:22","fec_asig":"2015-07-30 12:35:22","5":null,"fec_resol":null,"6":"122","wf_tarea_id_sig":"122","7":null,"core_usuario_id_resol":null,"8":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_asig":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","9":null,"usr_resol":null}
2015-07 30 12:35:46
cargar datos del sujeto(,,s,59,11644)
select s.*, m.nombre as nom_muni, c.nom_cat,fec_caso
from wf_caso_59 w
inner join core_sujetoverificacion s on w.id=11644 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 30 12:35:46
tabla dat adic
select tabla from core_sujetoverificaciontipo where id=1
2015-07 30 12:35:46
tabla :core_sujetoverificacionstickerentrada
SELECT * FROM core_sujetoverificacionstickerentrada where id=11596
2015-07 30 12:35:46
Continuar(,122,193,)
EjecutarTarea_122() Imp - Salida Mercancia id_comp1005
1 1
ValidarUsuario(122):1
EjecutarPaso_193: proc:60 , caso=11644 id_comp 1005
Mostrar proc
verificarProceso(60,193)
conteo lista de subprocesos registrados : 1
hay subcasos registrados? : 1
ret? :
tipo_ejec : s
conteo casos registrados : 1
ret : Array
(
[id_caso] => 11540
[id_proc] => 60
[ini] =>
)
Retorno :
Array
(
[ret] => inicioComponente_WF_Proceso({"id":"1005","proceso_id":59,"caso_id":"11644","tarea_id":122,"paso_id":193});inicioComponente_WF('subp60_11540','next',60,{caso_id:11540,proceso_id:60});
[suc] => 1
)
fin 2015-07-30 12:35:46
/******************************************************************************************************/
2015-07-30 12:36:03TraerCaso(11644,59,)
CargarCaso :11644
2015-07 30 12:36:03
CargarDatos: Caso :11644
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_59_seguimiento_id,wf_paso_id from wf_caso_59_pasos a1 group by wf_caso_59_seguimiento_id,wf_paso_id order by id
)a
inner join wf_caso_59_pasos p using(id,wf_caso_59_seguimiento_id)
inner join ( select max(id) as wf_caso_59_seguimiento_id,wf_caso_59_id,wf_tarea_id from wf_caso_59_seguimiento where wf_caso_59_id =? group by wf_caso_59_id,wf_tarea_id order by wf_caso_59_id,wf_caso_59_seguimiento_id ) b using(wf_caso_59_seguimiento_id)
left join usuarios u using(core_usuario_id)
{"0":"115478","id":"115478","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"172","wf_paso_id":"172","4":"109430","wf_caso_59_seguimiento_id":"109430","5":"2015-01-13 17:25:46","fecha_ejec":"2015-01-13 17:25:46","6":"330200","dato":"330200","7":"sce.t2","tabla":"sce.t2","8":"1","core_usuario_id":"1","9":"105","tarea_id":"105","10":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_ejec":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
CargarDatos_172(330200)
se carga 59_105_172_2_2_81
se carga 59_105_172_2_2_10
{"0":"115479","id":"115479","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"174","wf_paso_id":"174","4":"109431","wf_caso_59_seguimiento_id":"109431","5":"2015-01-13 17:25:58","fecha_ejec":"2015-01-13 17:25:58","6":"104739","dato":"104739","7":"wf_documentoentradadatos","tabla":"wf_documentoentradadatos","8":"1","core_usuario_id":"1","9":"107","tarea_id":"107","10":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_ejec":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
CargarDatos_174(104739)
Documento 104739
Documento 104739
{"0":"115480","id":"115480","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"176","wf_paso_id":"176","4":"109431","wf_caso_59_seguimiento_id":"109431","5":"2015-01-13 17:26:03","fecha_ejec":"2015-01-13 17:26:03","6":"104740","dato":"104740","7":"wf_documentoentradadatos","tabla":"wf_documentoentradadatos","8":"1","core_usuario_id":"1","9":"107","tarea_id":"107","10":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_ejec":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
CargarDatos_176(104740)
Documento 104740
Documento 104740
{"0":"115481","id":"115481","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"175","wf_paso_id":"175","4":"109431","wf_caso_59_seguimiento_id":"109431","5":"2015-01-13 17:26:13","fecha_ejec":"2015-01-13 17:26:13","6":"104741","dato":"104741","7":"wf_documentoentradadatos","tabla":"wf_documentoentradadatos","8":"1","core_usuario_id":"1","9":"107","tarea_id":"107","10":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_ejec":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
CargarDatos_175(104741)
Documento 104741
Documento 104741
{"0":"115482","id":"115482","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"177","wf_paso_id":"177","4":"109432","wf_caso_59_seguimiento_id":"109432","5":"2015-01-13 17:26:43","fecha_ejec":"2015-01-13 17:26:43","6":"108083","dato":"108083","7":"sce.t4","tabla":"sce.t4","8":"1","core_usuario_id":"1","9":"109","tarea_id":"109","10":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_ejec":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
CargarDatos_177(108083)
se carga 59_109_177_4_5_752015-01-13
se carga 59_109_177_4_5_69gh
se carga 59_109_177_4_5_68
se carga 59_109_177_4_5_64Seleccione una opción
se carga 59_109_177_4_5_412015-01-13
se carga 59_109_177_4_5_406
se carga 59_109_177_4_5_396
se carga 59_109_177_4_5_241
se carga 59_109_177_4_5_226
se carga 59_109_177_4_5_216
{"0":"115483","id":"115483","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"182","wf_paso_id":"182","4":"109433","wf_caso_59_seguimiento_id":"109433","5":"2015-01-13 17:26:54","fecha_ejec":"2015-01-13 17:26:54","6":"109611","dato":"109611","7":"sce.t6","tabla":"sce.t6","8":"1","core_usuario_id":"1","9":"115","tarea_id":"115","10":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_ejec":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
CargarDatos_182(109611)
se carga 59_115_182_6_7_381
se carga 59_115_182_6_7_371
se carga 59_115_182_6_7_32
{"0":"115484","id":"115484","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"192","wf_paso_id":"192","4":"109433","wf_caso_59_seguimiento_id":"109433","5":"2015-07-30 12:34:56","fecha_ejec":"2015-07-30 12:34:56","6":"11598","dato":"11598","7":"core_upload","tabla":"core_upload","8":"1","core_usuario_id":"1","9":"115","tarea_id":"115","10":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_ejec":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
CargarDatos_192(11598)
{"0":"115485","id":"115485","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"184","wf_paso_id":"184","4":"109434","wf_caso_59_seguimiento_id":"109434","5":"2015-07-30 12:35:09","fecha_ejec":"2015-07-30 12:35:09","6":"111144","dato":"111144","7":"sce.t8","tabla":"sce.t8","8":"1","core_usuario_id":"1","9":"116","tarea_id":"116","10":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_ejec":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
CargarDatos_184(111144)
se carga 59_116_184_8_9_46ffff
se carga 59_116_184_8_9_45202
se carga 59_116_184_8_9_442
se carga 59_116_184_8_9_43200
{"0":"115486","id":"115486","1":null,"wf_caso_59_id":null,"2":null,"wf_tarea_id":null,"3":"194","wf_paso_id":"194","4":"109434","wf_caso_59_seguimiento_id":"109434","5":"2015-07-30 12:35:22","fecha_ejec":"2015-07-30 12:35:22","6":"11599","dato":"11599","7":"core_upload","tabla":"core_upload","8":"1","core_usuario_id":"1","9":"116","tarea_id":"116","10":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_ejec":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
CargarDatos_194(11599)
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_59_seguimiento a
inner join (
select max(b0.id) as id,b0.wf_caso_59_id,b0.wf_tarea_id from wf_caso_59_seguimiento b0 where b0.wf_caso_59_id =? group by b0.wf_caso_59_id,b0.wf_tarea_id order by wf_caso_59_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":"109430","id":"109430","1":"11644","wf_caso_59_id":"11644","2":"105","wf_tarea_id":"105","3":null,"core_usuario_id":null,"4":"2015-01-13 17:25:41","fec_asig":"2015-01-13 17:25:41","5":"2015-01-13 17:25:47","fec_resol":"2015-01-13 17:25:47","6":"105","wf_tarea_id_sig":"105","7":"1","core_usuario_id_resol":"1","8":null,"usr_asig":null,"9":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_resol":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
{"0":"109431","id":"109431","1":"11644","wf_caso_59_id":"11644","2":"107","wf_tarea_id":"107","3":"1","core_usuario_id":"1","4":"2015-01-13 17:25:47","fec_asig":"2015-01-13 17:25:47","5":"2015-01-13 17:26:13","fec_resol":"2015-01-13 17:26:13","6":"107","wf_tarea_id_sig":"107","7":"1","core_usuario_id_resol":"1","8":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_asig":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","9":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_resol":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
{"0":"109432","id":"109432","1":"11644","wf_caso_59_id":"11644","2":"109","wf_tarea_id":"109","3":"1","core_usuario_id":"1","4":"2015-01-13 17:26:13","fec_asig":"2015-01-13 17:26:13","5":"2015-01-13 17:26:43","fec_resol":"2015-01-13 17:26:43","6":"109","wf_tarea_id_sig":"109","7":"1","core_usuario_id_resol":"1","8":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_asig":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","9":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_resol":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
{"0":"109433","id":"109433","1":"11644","wf_caso_59_id":"11644","2":"115","wf_tarea_id":"115","3":"1","core_usuario_id":"1","4":"2015-01-13 17:26:43","fec_asig":"2015-01-13 17:26:43","5":"2015-07-30 12:34:56","fec_resol":"2015-07-30 12:34:56","6":"115","wf_tarea_id_sig":"115","7":"1","core_usuario_id_resol":"1","8":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_asig":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","9":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_resol":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
{"0":"109434","id":"109434","1":"11644","wf_caso_59_id":"11644","2":"116","wf_tarea_id":"116","3":"1","core_usuario_id":"1","4":"2015-07-30 12:34:56","fec_asig":"2015-07-30 12:34:56","5":"2015-07-30 12:35:22","fec_resol":"2015-07-30 12:35:22","6":"116","wf_tarea_id_sig":"116","7":"1","core_usuario_id_resol":"1","8":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_asig":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","9":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_resol":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
{"0":"109435","id":"109435","1":"11644","wf_caso_59_id":"11644","2":"122","wf_tarea_id":"122","3":"1","core_usuario_id":"1","4":"2015-07-30 12:35:22","fec_asig":"2015-07-30 12:35:22","5":null,"fec_resol":null,"6":"122","wf_tarea_id_sig":"122","7":null,"core_usuario_id_resol":null,"8":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_asig":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","9":null,"usr_resol":null}
2015-07 30 12:36:04
cargar datos del sujeto(,,s,59,11644)
select s.*, m.nombre as nom_muni, c.nom_cat,fec_caso
from wf_caso_59 w
inner join core_sujetoverificacion s on w.id=11644 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 30 12:36:04
tabla dat adic
select tabla from core_sujetoverificaciontipo where id=1
2015-07 30 12:36:04
tabla :core_sujetoverificacionstickerentrada
SELECT * FROM core_sujetoverificacionstickerentrada where id=11596
2015-07 30 12:36:04
Continuar(,122,,s)
EjecutarTarea_122() Imp - Salida Mercancia id_comp1005
1 1
ValidarUsuario(122):1
EjecutarPaso_193: proc:60 , caso=11644 id_comp 1005
Mostrar proc
verificarProceso(60,193)
conteo lista de subprocesos registrados : 1
hay subcasos registrados? : 1
ret? :
tipo_ejec : s
conteo casos registrados : 1
ret : Array
(
[id_caso] => 11540
[id_proc] => 60
[ini] =>
)
Retorno :
Array
(
[ret] => inicioComponente_WF_Proceso({"id":"1005","proceso_id":59,"caso_id":"11644","tarea_id":122,"paso_id":193});inicioComponente_WF('subp60_11540','next',60,{caso_id:11540,proceso_id:60});
[suc] => 1
)
fin 2015-07-30 12:36:04
/******************************************************************************************************/