$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);