コード例 #1
0
$sqlparag .= "\t      inner join db_tipodoc on db08_codigo  = db03_tipodoc               ";
$sqlparag .= "        inner join db_paragrafo on db04_idparag = db02_idparag             ";
$sqlparag .= "  where db03_tipodoc = 1017                                                ";
$sqlparag .= "    and db03_instit = " . db_getsession("DB_instit") . " order by db04_ordem ";
$resparag = db_query($sqlparag);
if (pg_numrows($resparag) != 0) {
    db_fieldsmemory($resparag, 0);
    $head1 = $db02_texto;
}
$pdf->Open();
// abre o relatorio
$pdf->AliasNbPages();
// gera alias para as paginas
$pdf->AddPage();
// adiciona uma pagina
$pdf->SetAutoPageBreak('on', 0);
$pdf->SetTextColor(0, 0, 0);
$pdf->SetFillColor(255);
if (isset($cadrecibo) && $cadrecibo == 't') {
    $pdf->settopmargin(1);
    $pdf->SetFont('Arial', 'B', 12);
    $pdf->Image('imagens/files/Brasao.png', 20, 10, 15);
    $pdf->sety(15);
    $pdf->setfont('Arial', 'B', 18);
    $pdf->Multicell(0, 8, $nomeinst, 0, "C", 0);
    // prefeitura
}
$y = $pdf->gety();
$pdf->sety($y);
$result = $cldb_docparag->sql_record($cldb_docparag->sql_query("", "", "db_docparag.*,db02_texto,db02_descr,db02_espaca,db02_alinha,db02_inicia", "db04_ordem", " db03_tipodoc = {$codtipodoc} "));
$numrows = $cldb_docparag->numrows;