foreach (tampilData($stmt3) as $grid1) { $pdf->MultiCell(10, 7, $i, 0, 'C', false, 0, '', '', false, 0, false, false, 7, 'TB'); $pdf->MultiCell(20, 6, $grid1['no_so'], 0, 'C', false, 0, '', '', false, 0, false, false, '', 'M'); $pdf->MultiCell(20, 6, $grid1['no_seri_produk'], 0, 'C', false, 0, '', '', false, 0, false, false, '', 'M'); $pdf->MultiCell(40, 6, $grid1['nama_produk'], 0, 'C', false, 0, '', '', false, 0, false, false, '', 'M'); $pdf->MultiCell(22, 6, number_format($grid1['harga'], 2, ',', '.'), 0, 'C', false, 0, '', '', false, 0, false, false, '', 'M'); $pdf->MultiCell(5, 6, "x", 0, 'C', false, 0, '', '', false, 0, false, false, '', 'M'); $pdf->MultiCell(17, 6, $grid1['persentase'], 0, 'C', false, 0, '', '', false, 0, false, false, '', 'M'); $pdf->MultiCell(5, 6, "x", 0, 'C', false, 0, '', '', false, 0, false, false, '', 'M'); $pdf->MultiCell(7, 6, $grid1['quantity'], 0, 'C', false, 0, '', '', false, 0, false, false, '', 'M'); $pdf->MultiCell(5, 6, "=", 0, 'C', false, 0, '', '', false, 0, false, false, '', 'M'); $pdf->MultiCell(25, 6, number_format($grid1['komisi'], 2, ',', '.'), 0, 'C', false, 1, '', '', false, 0, false, false, '', 'M'); $i++; } $stmt2 = "select sum(komisi) as total from komisi where no_nis_sales = '{$nis}' AND cabang = '{$cabang}' AND tanggal_so BETWEEN '{$begin}' AND '{$end}'"; foreach (tampilData($stmt2) as $total) { } $pdf->SetFont('helvetica', 'BI', 7); $pdf->MultiCell(151, 7, "Total Komisi", 'TB', 'C', false, 0, '', '', false, 0, false, false, 7, 'TB'); $pdf->MultiCell(25, 6, number_format($total['total'], 2, ',', '.'), 'TB', 'C', false, 1, '', '', false, 0, false, false, '', 'M'); $pdf->MultiCell(15, 7, "Terbilang", 0, 'L', false, 0, '', '', false, 0, false, false, 7, 'T'); $pdf->MultiCell(175, 7, ": " . terbilang($total['total'], 4) . " rupiah", 0, 'L', false, 0, '', '', false, 0, false, false, '', 'M'); $pdf->setXY($pdf->getX(), $pdf->getY() + 10); $pdf->Line(0, $pdf->getY(), 215, $pdf->getY()); $pdf->setXY($pdf->getX(), $pdf->getY() + 10); $y = 297 - $pdf->getY(); if ($y <= 40) { $pdf->AddPage(); } } $pdf->Output($cabang . " - " . $dataCabang['nama_cabang'] . " (" . $begin . " s.d " . $end . ")-KOMISI.pdf", 'I');
} else { if (isset($columns['from'])) { $time_width += $pdf->GetStringWidth(strftime($timeformat, $row['time_in'])); } else { $time_width += $pdf->GetStringWidth(strftime($timeformat, $row['time_out'])); } } $max_time_width = max($max_time_width, $time_width); } $max_time_width += 10; $max_money_width += 10; $widths = $pdf->columnWidths($max_time_width, $max_money_width); $pdf->printRows($customer[$project_id], $widths); if (isset($columns['wage']) && isset($columns['dec_time'])) { $pdf->ln(); $pdf->WriteHtmlCell($widths[0] + $widths[1] + $widths[2], 6, $pdf->getX(), $pdf->getY(), $pdf->timespan($pdf->timeSum), '', 0, 0, true, 'R'); $pdf->ln(); $pdf->WriteHtmlCell($widths[0] + $widths[1], 6, $pdf->getX(), $pdf->getY(), $kga['lang']['export_extension']['finalamount'] . ':', '', 0, 0, true, 'R'); $pdf->WriteHtmlCell($widths[2], 6, $pdf->getX(), $pdf->getY(), $pdf->money($pdf->moneySum), '', 0, 0, true, 'R'); } else { if (isset($columns['wage'])) { $pdf->ln(); $pdf->WriteHtmlCell($widths[0] + $widths[1], 6, $pdf->getX(), $pdf->getY(), $kga['lang']['export_extension']['finalamount'] . ':', '', 0, 0, true, 'R'); $pdf->WriteHtmlCell($widths[2], 6, $pdf->getX(), $pdf->getY(), $pdf->money($pdf->moneySum), '', 0, 0, true, 'R'); } else { if (isset($columns['dec_time'])) { $pdf->ln(); $pdf->WriteHtmlCell($widths[0] + $widths[1], 6, $pdf->getX(), $pdf->getY(), $kga['lang']['export_extension']['finalamount'] . ':', '', 0, 0, true, 'R'); $pdf->WriteHtmlCell($widths[2], 6, $pdf->getX(), $pdf->getY(), $pdf->timespan($pdf->timeSum), '', 0, 0, true, 'R'); } }
$pdf->MultiCell(20, 7, "Tgl SO", 'TB', 'C', false, 0, '', '', false, 0, false, false, '', 'M'); $pdf->MultiCell(30, 7, "No Seri", 'TB', 'C', false, 0, '', '', false, 0, false, false, '', 'M'); $pdf->MultiCell(30, 7, "Nama Produk", 'TB', 'C', false, 0, '', '', false, 0, false, false, '', 'M'); $pdf->MultiCell(15, 7, "Quantity", 'TB', 'C', false, 0, '', '', false, 0, false, false, '', 'M'); $pdf->MultiCell(20, 7, "NIS", 'TB', 'C', false, 0, '', '', false, 0, false, false, '', 'M'); $pdf->MultiCell(50, 7, "Nama Sales", 'TB', 'C', false, 0, '', '', false, 0, false, false, '', 'M'); $pdf->MultiCell(50, 7, "Nama Qustomer", 'TB', 'C', false, 0, '', '', false, 0, false, false, '', 'M'); $pdf->MultiCell(25, 7, "Telp", 'TB', 'C', false, 1, '', '', false, 0, false, false, '', 'M'); $pdf->SetFont('helvetica', '', 7); $i = 1; foreach (tampilData($stmt) as $grid) { $pdf->setXY(15, 55 + 7 * ($i - 1)); if ($i % 2 == 0) { $pdf->setFillColor(198, 200, 198); } else { $pdf->setFillColor(231, 232, 231); } $pdf->MultiCell(10, 7, $i, 0, 'C', true, 0, '', '', false, 0, false, false, '', 'M'); $pdf->MultiCell(15, 7, $grid['no_so'], 0, 'C', true, 0, '', '', false, 0, false, false, '', 'M'); $pdf->MultiCell(20, 7, $grid['tanggal_so'], 0, 'C', true, 0, '', '', false, 0, false, false, '', 'M'); $pdf->MultiCell(30, 7, $grid['no_seri_produk'], 0, 'C', true, 0, '', '', false, 0, false, false, '', 'M'); $pdf->MultiCell(30, 7, $grid['nama_produk'], 0, 'C', true, 0, '', '', false, 0, false, false, '', 'M'); $pdf->MultiCell(15, 7, $grid['quantity'], 0, 'C', true, 0, '', '', false, 0, false, false, '', 'M'); $pdf->MultiCell(20, 7, $grid['no_nis_sales'], 0, 'C', true, 0, '', '', false, 0, false, false, '', 'M'); $pdf->MultiCell(50, 7, $grid['nama_sales'], 0, 'C', true, 0, '', '', false, 0, false, false, '', 'M'); $pdf->MultiCell(50, 7, $grid['nama_customer'], 0, 'C', true, 0, '', '', false, 0, false, false, '', 'M'); $pdf->MultiCell(25, 7, $grid['telp_customer'], 0, 'C', true, 1, '', '', false, 0, false, false, '', 'M'); $i++; } $pdf->Line($pdf->getX() - 14.5, $pdf->getY() + 3, 280, $pdf->getY() + 3); $pdf->Output('example_001.pdf', 'I');
$pdf->SetFont('helvetica', '', 7); $pdf->setXY(15, 40); $pdf->Cell(0, 0, 'Periode ' . $begin . ' - ' . $end, 0, 2, 'L', 0, '', ''); $pdf->SetFont('helvetica', 'B', 7); $pdf->setXY(15, 45); $pdf->MultiCell(10, 7, "No", 'TB', 'C', false, 0, '', '', false, 0, false, false, 7, 'M'); $pdf->MultiCell(30, 7, "NIS", 'TB', 'C', false, 0, '', '', false, 0, false, false, '', 'M'); $pdf->MultiCell(60, 7, "Nama Sales", 'TB', 'C', false, 0, '', '', false, 0, false, false, '', 'M'); $pdf->MultiCell(20, 7, "Jumlah SO", 'TB', 'C', false, 0, '', '', false, 0, false, false, '', 'M'); $pdf->MultiCell(30, 7, "Komisi", 'TB', 'C', false, 1, '', '', false, 0, false, false, '', 'M'); $pdf->SetFont('helvetica', '', 7); $i = 1; foreach (tampilData($stmt) as $grid) { $pdf->setXY(15, 55 + 7 * ($i - 1)); if ($i % 2 == 0) { $pdf->setFillColor(198, 200, 198); } else { $pdf->setFillColor(231, 232, 231); } $pdf->MultiCell(10, 7, $i, 0, 'C', true, 0, '', '', false, 0, false, false, '', 'M'); $pdf->MultiCell(30, 7, $grid['nis'], 0, 'C', true, 0, '', '', false, 0, false, false, '', 'M'); $pdf->MultiCell(60, 7, $grid['nama'], 0, 'C', true, 0, '', '', false, 0, false, false, '', 'M'); $pdf->MultiCell(20, 7, $grid['total_so'], 0, 'C', true, 0, '', '', false, 0, false, false, '', 'M'); $pdf->MultiCell(30, 7, number_format($grid['komisi'], 2, ',', '.'), 0, 'C', true, 1, '', '', false, 0, false, false, '', 'M'); $i++; } $pdf->setXY($pdf->getX() - 14.5, $pdf->getY() + 3); $pdf->SetFont('helvetica', 'B', 7); $pdf->MultiCell(120, 7, 'TOTAL', 'TB', 'C', false, 0, '', '', false, 0, false, false, '', 'M'); $pdf->MultiCell(30, 7, number_format($total['total'], 2, ',', '.'), 'TB', 'C', false, 0, '', '', false, 0, false, false, '', 'M'); $pdf->Output('Laporan_Komisi_Sales.pdf', 'I');