public function printEtiquetes($idL)
{
$config = sfTCPDFPluginConfigHandler::loadConfig();
//create new PDF document (document units are set by default to millimeters)
$pdf = new sfTCPDF(PDF_PAGE_ORIENTATION, PDF_UNIT, PDF_PAGE_FORMAT, true);
// set document information
$pdf->SetCreator('Intranet CCG');
$pdf->SetAuthor('Intranet CCG');
$pdf->SetTitle('Llistat de mailing postal');
$pdf->SetSubject("Llistat correu");
$pdf->SetFont('helvetica', '', 8);
$pdf->SetMargins(0, 0, 0, 0);
$pdf->setPrintHeader(false);
$pdf->setAutoPageBreak(false);
//Consultem tots els usuaris de la llista que volem imprimir.
$fila = 1;
$columna = 1;
$pagina = 1;
$pdf->AddPage();
$OL = LlistesPeer::retrieveByPK($idL);
foreach ($OL->getUsuarisllistess() as $UL) {
$OU = $UL->getUsuaris();
$text = "<br><br><br> <b>" . $OU->getNomComplet() . "</b>";
$text .= "<br> " . $OU->getAdreca();
$text .= "<br> " . $OU->getCodiPostal() . ' - ' . $OU->getPoblacioString();
if ($fila == 9) {
$pdf->AddPage();
$fila = 1;
}
if ($columna == 1 && $fila == 1) {
$pdf->MultiCell(70, 37, $text, 1, 'L', 0, 0, 0, 0, true, 0, true, true, 0);
$columna++;
} elseif ($columna == 1 && $fila != 1) {
$pdf->MultiCell(70, 37, $text, 1, 'L', 0, 0, '', '', true, 0, true, true, 0);
$columna++;
} elseif ($columna == 2) {
$pdf->MultiCell(70, 37, $text, 1, 'L', 0, 0, '', '', true, 0, true, true, 0);
$columna++;
} elseif ($columna == 3) {
$pdf->MultiCell(70, 37, $text, 1, 'L', 0, 1, '', '', true, 0, true, true, 0);
$columna = 1;
$fila++;
}
}
$pdf->Output();
return sfView::NONE;
}
