$this->Cell($w[0], 6, $row[0], 'LR', 0, 'L', $fill);
$this->Cell($w[1], 6, $row[1], 'LR', 0, 'L', $fill);
$this->Cell($w[2], 6, $row[2], 'LR', 0, 'L', $fill);
$this->Cell($w[3], 6, $row[3], 'LR', 0, 'L', $fill);
$this->Cell($w[4], 6, $row[4], 'LR', 0, 'L', $fill);
$this->Cell($w[5], 6, number_format($row[5]), 'LR', 0, 'R', $fill);
$this->Ln();
$fill = !$fill;
}
$this->Cell(array_sum($w), 0, '', 'T');
}
}
require_once 'connect.php';
$query = "select\n C.ComponentReference,\n C.ComponentValue,\n C.ComponentPartNumber,\n C.ComponentManufacturer,\n C.ComponentFootPrint,\n IFNULL(I.quantity,0) AS quantity\n from \n Inventory as I\n Right Join\n Component as C\n ON\n C.ComponentID = I.ComponentID\n ";
$stmt = $conn->prepare($query);
if ($stmt->execute()) {
$stmt->setFetchMode(PDO::FETCH_ASSOC);
}
while ($result = $stmt->fetch()) {
$data[] = array($result['ComponentReference'], $result['ComponentValue'], $result['ComponentPartNumber'], $result['ComponentManufacturer'], $result['ComponentFootPrint'], $result['quantity']);
}
date_default_timezone_set('America/Los_Angeles');
$pdf = new myPDF('L', 'mm', 'Letter');
$date = date("m/d/Y h:i A");
$pdf->date = $date;
$header = array('Reference', 'Value', 'Part Number', 'Manufacturer', 'Foot Print', 'Quantity On Hand');
$pdf->AliasNbPages();
$pdf->AddPage();
$pdf->BuildTable($header, $data);
$pdf->Output();
$conn = null;
