2015-07-30 12:32:00TraerCaso(5,63,)
CargarCaso :5
2015-07 30 12:32:00
CargarDatos: Caso :5
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_63_seguimiento_id,wf_paso_id from wf_caso_63_pasos a1 group by wf_caso_63_seguimiento_id,wf_paso_id order by id
)a
inner join wf_caso_63_pasos p using(id,wf_caso_63_seguimiento_id)
inner join ( select max(id) as wf_caso_63_seguimiento_id,wf_caso_63_id,wf_tarea_id from wf_caso_63_seguimiento where wf_caso_63_id =? group by wf_caso_63_id,wf_tarea_id order by wf_caso_63_id,wf_caso_63_seguimiento_id ) b using(wf_caso_63_seguimiento_id)
left join usuarios u using(core_usuario_id)
{"0":"5","id":"5","1":null,"wf_caso_63_id":null,"2":null,"wf_tarea_id":null,"3":"180","wf_paso_id":"180","4":"8","wf_caso_63_seguimiento_id":"8","5":"2014-09-11 10:33:58","fecha_ejec":"2014-09-11 10:33:58","6":"2","dato":"2","7":"sce.t7","tabla":"sce.t7","8":"1","core_usuario_id":"1","9":"113","tarea_id":"113","10":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_ejec":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
CargarDatos_180(2)
se carga 63_113_180_7_8_35125
se carga 63_113_180_7_8_34120
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_63_seguimiento a
inner join (
select max(b0.id) as id,b0.wf_caso_63_id,b0.wf_tarea_id from wf_caso_63_seguimiento b0 where b0.wf_caso_63_id =? group by b0.wf_caso_63_id,b0.wf_tarea_id order by wf_caso_63_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":"8","id":"8","1":"5","wf_caso_63_id":"5","2":"113","wf_tarea_id":"113","3":null,"core_usuario_id":null,"4":"2014-09-09 09:30:44","fec_asig":"2014-09-09 09:30:44","5":"2014-09-11 10:33:58","fec_resol":"2014-09-11 10:33:58","6":"113","wf_tarea_id_sig":"113","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":"9","id":"9","1":"5","wf_caso_63_id":"5","2":"114","wf_tarea_id":"114","3":"1","core_usuario_id":"1","4":"2014-09-11 10:33:58","fec_asig":"2014-09-11 10:33:58","5":null,"fec_resol":null,"6":"114","wf_tarea_id_sig":"114","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:32:00
cargar datos del sujeto(,,s,63,5)
select s.*, m.nombre as nom_muni, c.nom_cat,fec_caso
from wf_caso_63 w
inner join core_sujetoverificacion s on w.id=5 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:32:00
tabla dat adic
select tabla from core_sujetoverificaciontipo where id=7
2015-07 30 12:32:00
tabla :core_sujetoverificaciongeneral
SELECT * FROM core_sujetoverificaciongeneral where id=11587
2015-07 30 12:32:00
Continuar(,114,,s)
EjecutarTarea_114() Descarga de Archivo id_comp1012
1 1
ValidarUsuario(114):1
EjecutarPaso_181: docs:3 , caso=5 id_comp 1012
Mostrar docs
$rangoI= 63_113_180_7_8_34 ;
$rangoF= 63_113_180_7_8_35 ;
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');
//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=R&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=8;
$altoText=8;
$altoC=$altoS-$altoImg-$altoText-$margenSV;//altostic-alto inmg-alto texto-espaciomargen
if(($altoC+$margenSH)>$anchoS){
$altoC=$anchoS-$margenSH;
}else{
$margenSH=$anchoS-$altoC;
}
// 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
);
$s=0;$p=1;$consc=$rangoI;
for($f=0;$s<$tot ;$f++){
$y=($f*$altoS)+$arr+($margenSV/2);
for($c=0;$c<$cols && $s<$tot ;$c++,$s++,$consc++){
$cod=date('Ym').str_pad($consc,4,'0',STR_PAD_LEFT);
if(validarCodigo($cod)){
$x=$c*$anchoS+$izq;
// Image($file, $x='', $y='', $w=0, $h=0, $type='', $link='', $align='', $resize=false, $dpi=300, $palign='', $ismask=false, $imgmask=false, $border=0, $fitbox=false, $hidden=false, $fitonpage=false)
$pdf->Image($root.$logo_empresa, $x+($margenSH/2)+3, $y, 0, $altoImg-1, 'PNG', '', 'center', true, 150, '', false, false, 0, false, false, false);
$pdf->SetXY($x+($margenSH/2), $y+$altoImg);
// 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', '', '', $altoC, $altoC, $style, 'N');
$pdf->Text($x+12+($margenSH/2), $y+$altoC+$altoText,$cod );
}else{
//die("El codigo ".$cod." ya esta registrado");
$c--;$s--;$tot--;
}
}
if($f==$fils-1 && $s<$tot){
$pdf->AddPage();
$f=-1;
}
}
//Close and output PDF document
$nomdoc=md5(time()).'.pdf';
$pdf->Output($root."/tmp/".$nomdoc, 'F');
$url=$root_js.'tmp/'.$nomdoc;
function validarCodigo($cod){
$obj=new ADODB_Active_Record("core_sujetoverificacionstickerentrada");
$obj->load('id_sticker=?',array($cod));
if(isset($obj->id) && $obj->id!='') return false;
return true;
}
T63_113_180_7_8_35:125
T63_113_180_7_8_34:120
fin 2015-07-30 12:32:00
/******************************************************************************************************/
2015-07-30 12:33:30TraerCaso(5,63,)
CargarCaso :5
2015-07 30 12:33:30
CargarDatos: Caso :5
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_63_seguimiento_id,wf_paso_id from wf_caso_63_pasos a1 group by wf_caso_63_seguimiento_id,wf_paso_id order by id
)a
inner join wf_caso_63_pasos p using(id,wf_caso_63_seguimiento_id)
inner join ( select max(id) as wf_caso_63_seguimiento_id,wf_caso_63_id,wf_tarea_id from wf_caso_63_seguimiento where wf_caso_63_id =? group by wf_caso_63_id,wf_tarea_id order by wf_caso_63_id,wf_caso_63_seguimiento_id ) b using(wf_caso_63_seguimiento_id)
left join usuarios u using(core_usuario_id)
{"0":"5","id":"5","1":null,"wf_caso_63_id":null,"2":null,"wf_tarea_id":null,"3":"180","wf_paso_id":"180","4":"8","wf_caso_63_seguimiento_id":"8","5":"2014-09-11 10:33:58","fecha_ejec":"2014-09-11 10:33:58","6":"2","dato":"2","7":"sce.t7","tabla":"sce.t7","8":"1","core_usuario_id":"1","9":"113","tarea_id":"113","10":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente","usr_ejec":"Mor\u00e1n Silva Gelber: Jefe de Logistica, Gerente"}
CargarDatos_180(2)
se carga 63_113_180_7_8_35125
se carga 63_113_180_7_8_34120
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_63_seguimiento a
inner join (
select max(b0.id) as id,b0.wf_caso_63_id,b0.wf_tarea_id from wf_caso_63_seguimiento b0 where b0.wf_caso_63_id =? group by b0.wf_caso_63_id,b0.wf_tarea_id order by wf_caso_63_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":"8","id":"8","1":"5","wf_caso_63_id":"5","2":"113","wf_tarea_id":"113","3":null,"core_usuario_id":null,"4":"2014-09-09 09:30:44","fec_asig":"2014-09-09 09:30:44","5":"2014-09-11 10:33:58","fec_resol":"2014-09-11 10:33:58","6":"113","wf_tarea_id_sig":"113","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":"9","id":"9","1":"5","wf_caso_63_id":"5","2":"114","wf_tarea_id":"114","3":"1","core_usuario_id":"1","4":"2014-09-11 10:33:58","fec_asig":"2014-09-11 10:33:58","5":null,"fec_resol":null,"6":"114","wf_tarea_id_sig":"114","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:33:31
cargar datos del sujeto(,,s,63,5)
select s.*, m.nombre as nom_muni, c.nom_cat,fec_caso
from wf_caso_63 w
inner join core_sujetoverificacion s on w.id=5 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:33:31
tabla dat adic
select tabla from core_sujetoverificaciontipo where id=7
2015-07 30 12:33:31
tabla :core_sujetoverificaciongeneral
SELECT * FROM core_sujetoverificaciongeneral where id=11587
2015-07 30 12:33:31
Continuar(,114,,s)
EjecutarTarea_114() Descarga de Archivo id_comp1012
1 1
ValidarUsuario(114):1
EjecutarPaso_181: docs:3 , caso=5 id_comp 1012
Mostrar docs
$rangoI= 63_113_180_7_8_34 ;
$rangoF= 63_113_180_7_8_35 ;
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');
//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=R&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=8;
$altoText=8;
$altoC=$altoS-$altoImg-$altoText-$margenSV;//altostic-alto inmg-alto texto-espaciomargen
if(($altoC+$margenSH)>$anchoS){
$altoC=$anchoS-$margenSH;
}else{
$margenSH=$anchoS-$altoC;
}
// 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
);
$s=0;$p=1;$consc=$rangoI;
for($f=0;$s<$tot ;$f++){
$y=($f*$altoS)+$arr+($margenSV/2);
for($c=0;$c<$cols && $s<$tot ;$c++,$s++,$consc++){
$cod=date('Ym').str_pad($consc,4,'0',STR_PAD_LEFT);
if(validarCodigo($cod)){
$x=$c*$anchoS+$izq;
// Image($file, $x='', $y='', $w=0, $h=0, $type='', $link='', $align='', $resize=false, $dpi=300, $palign='', $ismask=false, $imgmask=false, $border=0, $fitbox=false, $hidden=false, $fitonpage=false)
$pdf->Image($root.$logo_empresa, $x+($margenSH/2)+3, $y, 0, $altoImg-1, 'PNG', '', 'center', true, 150, '', false, false, 0, false, false, false);
$pdf->SetXY($x+($margenSH/2), $y+$altoImg);
// 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', '', '', $altoC, $altoC, $style, 'N');
$pdf->Text($x+12+($margenSH/2), $y+$altoC+$altoText,$cod );
}else{
//die("El codigo ".$cod." ya esta registrado");
$c--;$s--;$tot--;
}
}
if($f==$fils-1 && $s<$tot){
$pdf->AddPage();
$f=-1;
}
}
//Close and output PDF document
$nomdoc=md5(time()).'.pdf';
$pdf->Output($root."/tmp/".$nomdoc, 'F');
$url=$root_js.'tmp/'.$nomdoc;
function validarCodigo($cod){
$obj=new ADODB_Active_Record("core_sujetoverificacionstickerentrada");
$obj->load('id_sticker=?',array($cod));
if(isset($obj->id) && $obj->id!='') return false;
return true;
}
T63_113_180_7_8_35:125
T63_113_180_7_8_34:120
fin 2015-07-30 12:33:31
/******************************************************************************************************/