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++;
}
