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 ?>
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:
Observaciones:
 
 
 
 
 
Firma Deposito Firma Cliente

 
Elaborado por SITI Ltda - www.siticol.com
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 /******************************************************************************************************/