if ($selbst['wert'] == 3) { $x_alt = 2; } if ($selbst['wert'] == 4) { $x_alt = 1; } if (mysql_num_rows($selbst_neu_tmp) > 0 && mysql_num_rows($selbst_tmp) > 0) { //nur wenn zwei Eintraege vorhanden sind, macht ein Vergleich Sinn if ($x_alt == $x_neu) { //keine Veraenderung $pdf->MultiCell(4, 5, $x_alt, 'LT', 'C', 0, 0, '', '', false); $pdf->MultiCell(4, 5, $x_neu, 'TR', 'C', 0, 0, '', '', false); } if ($x_alt > $x_neu) { //Verbesserung $pdf->setFillColor(0, 255, 14); $pdf->MultiCell(4, 5, $x_alt, 'LT', 'C', 1, 0, '', '', false); $pdf->MultiCell(4, 0, $x_neu, 'TR', 'C', 1, 0, '', '', false); } if ($x_alt < $x_neu) { //Verschlechterung $pdf->setFillColor(255, 43, 0); $pdf->MultiCell(4, 5, $x_alt, 'LT', 'C', 1, 0, '', '', false); $pdf->MultiCell(4, 5, $x_neu, 'TR', 'C', 1, 0, '', '', false); } } else { //keine Veraenderung $pdf->MultiCell(4, 5, $x_alt, 'LT', 'C', 0, 0, '', '', false); $pdf->MultiCell(4, 5, $x_neu, 'TR', 'C', 0, 0, '', '', false); } $pdf->MultiCell(3, 5, '', '', 'C', 0, 0, '', '', false);
$pdf->MultiCell(10, 7, "No", 'TB', 'C', false, 0, '', '', false, 0, false, false, 7, 'M'); $pdf->MultiCell(15, 7, "No SO", 'TB', 'C', false, 0, '', '', false, 0, false, false, '', 'M'); $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++; }