$sql_rev = "SELECT * FROM intranet_drawings_revision WHERE revision_drawing = '{$drawing_id}' ORDER BY revision_letter DESC LIMIT 1";
$result_rev = mysql_query($sql_rev, $conn) or die(mysql_error());
$array_rev = mysql_fetch_array($result_rev);
if ($array_rev['revision_letter'] != NULL) {
$revision_letter = strtoupper($array_rev['revision_letter']);
} else {
$revision_letter = " - ";
}
if ($array_rev['revision_date'] != NULL) {
$revision_date = TimeFormat($array_rev['revision_date']);
} elseif ($drawing_date > 0) {
$revision_date = TimeFormat($drawing_date);
} else {
$revision_date = " - ";
}
if ($pdf->GetStringWidth($drawing_title) > 100) {
$drawing_title = substr($drawing_title, 0, 80) . "...";
}
$sql_issued = "SELECT issue_id FROM intranet_drawings_issued WHERE issue_drawing = '{$drawing_id}' LIMIT 1";
$result_issued = mysql_query($sql_issued, $conn) or die(mysql_error());
if (mysql_num_rows($result_issued) > 0) {
$pdf->SetTextColor(0, 0, 0);
} else {
$pdf->SetTextColor(150, 150, 150);
$not_issued = "*Drawings shown in light grey have not yet been issued.";
$drawing_number = $drawing_number . "*";
}
$link = $pref_location . "/public_drawing_issue.php?drawing_id=" . $drawing_id . "&hash=" . md5($drawing_number);
if ($current_drawing != $drawing_id) {
$pdf->Cell(25, 4.5, $drawing_number, $border, 0, L, $fill, $link);
$pdf->Cell(10, 4.5, $paper_size, $border, 0, L, $fill);
}
$pdf->AddFont($format_font, '', $format_font_2);
$pdf->SetXY(10, 175);
$pdf->SetTextColor(0, 0, 0);
$pdf->SetFillColor(220, 220, 220);
$pdf->SetFont('Helvetica', '', 18);
$pdf->MultiCell(0, 10, $settings_companyname, 0, L);
$pdf->SetFont('Helvetica', 'B', 32);
$pdf->MultiCell(0, 20, 'Quality Management System', 0, L);
$pdf->SetFont($format_font, '', 14);
$printed_date = "Current at " . date("g.ia, jS F Y", time());
$pdf->MultiCell(0, 25, '', 0, L);
$pdf->MultiCell(0, 8, $printed_date, 0, L);
$pdf->SetLineWidth(0.1);
$pdf->SetFont($format_font, '', 11);
$width = $pdf->GetStringWidth($printed_date) + 20;
if ($s1 != NULL or $s2 != NULL) {
$pdf->MultiCell(0, 8, $section, T, L);
}
$sql = "SELECT * FROM intranet_qms {$s1} {$s2} ORDER BY qms_toc1, qms_toc2, qms_toc3, qms_toc4";
$result = mysql_query($sql, $conn) or die(mysql_error());
while ($array = mysql_fetch_array($result)) {
$qms_id = $array['qms_id'];
$qms_toc1 = $array['qms_toc1'];
$qms_toc2 = $array['qms_toc2'];
$qms_toc3 = $array['qms_toc3'];
$qms_toc4 = $array['qms_toc4'];
$qms_type = $array['qms_type'];
$qms_text = strip_tags($array['qms_text']);
$qms_timestamp = $array['qms_timestamp'];
$qms_date = date("d M Y", $qms_timestamp);
