$satuan = $bar->satuan; $jumlah = $bar->jumlah; $namabarang = ''; $strv = "select namabarang from " . $dbname . ".log_5masterbarang where kodebarang='" . $bar->kodebarang . "'"; $resv = mysql_query($strv); while ($barv = mysql_fetch_object($resv)) { $namabarang = $barv->namabarang; } $pdf->Cell(8, 5, $no, 1, 0, 'L', 1); $pdf->Cell(30, 5, $kodebarang, 1, 0, 'L', 1); $pdf->Cell(100, 5, $namabarang, 1, 0, 'L', 1); $pdf->Cell(20, 5, $satuan, 1, 0, 'L', 1); $pdf->Cell(20, 5, number_format($jumlah, 2, '.', ','), 1, 1, 'R', 1); } //footer================================ $pdf->Cell(20, 4, $_SESSION['lang']['catatan'], 0, 0, 'L'); $pdf->Cell(40, 4, ": " . $keterangan, 0, 1, 'L'); $pdf->Ln(); //get user; $namakaryawan = namakaryawan($dbname, $conn, $userid); $pdf->Cell(20, 4, $_SESSION['lang']['dbuat_oleh'], 0, 0, 'L'); $pdf->Cell(40, 4, ": " . $namakaryawan, 0, 1, 'L'); //get posted by if ($posted != '') { $posted = namakaryawan($dbname, $conn, $posted); } else { $posted = ''; } $pdf->Cell(20, 4, $_SESSION['lang']['posted'], 0, 0, 'L'); $pdf->Cell(40, 4, ": " . $posted, 0, 1, 'L'); $pdf->Output();
$res = mysql_query($str); $no = 0; while ($bar = mysql_fetch_object($res)) { $no += 1; $kodebarang = $bar->kodebarang; $satuan = $bar->satuan; $jumlah = $bar->jumlah; $namabarang = ''; $strv = "select namabarang from " . $dbname . ".log_5masterbarang where kodebarang='" . $bar->kodebarang . "'"; $resv = mysql_query($strv); while ($barv = mysql_fetch_object($resv)) { $namabarang = $barv->namabarang; } $pdf->Cell(8, 5, $no, 1, 0, 'L', 1); $pdf->Cell(30, 5, $kodebarang, 1, 0, 'L', 1); $pdf->Cell(100, 5, $namabarang, 1, 0, 'L', 1); $pdf->Cell(20, 5, $satuan, 1, 0, 'L', 1); $pdf->Cell(20, 5, number_format($jumlah, 2, '.', ','), 1, 1, 'R', 1); } //footer================================ $dtpenerima = namakaryawan($dbname, $conn, $penerima); $dtpengetahui = namakaryawan($dbname, $conn, $pengetahui); $pdf->Ln(); $pdf->Cell(52, 10, $_SESSION['lang']['diperiksa'] . ",", 0, 0, 'C', 0); $pdf->Cell(65, 10, " ", 0, 0, 'C', 0); $pdf->Cell(52, 10, $_SESSION['lang']['diterima'] . ",", 0, 1, 'C', 0); $pdf->ln(10); $pdf->Cell(52, 10, $dtpengetahui, 0, 0, 'C', 0); $pdf->Cell(65, 10, " ", 0, 0, 'C', 0); $pdf->Cell(52, 10, $dtpenerima, 0, 1, 'C', 0); $pdf->Output();