$checklist_item = intval(trim($checklist_item, "#"));
if ($proj_id > 0 and $checklist_item > 0) {
$sql_checklist_date = "SELECT checklist_date FROM intranet_project_checklist WHERE checklist_project = {$proj_id} AND checklist_item = {$checklist_item} ORDER BY checklist_date DESC LIMIT 1";
$result_checklist_date = mysql_query($sql_checklist_date, $conn) or die(mysql_error());
$array_checklist_date = mysql_fetch_array($result_checklist_date);
if ($array_checklist_date['checklist_date'] != "0000-00-00") {
$output = strtotime($array_checklist_date['checklist_date']);
$output = date("j F Y", $output);
}
return $output;
}
}
$pagecount = $pdf->setSourceFile("pdf/template.pdf");
$tplidx = $pdf->ImportPage(1);
$pdf->addPage();
$pdf->SetMargins(10, 15, 10);
$pdf->useTemplate($tplidx, 0, 0, 210, 297);
if ($settings_pdffont != NULL) {
$format_font = $settings_pdffont;
$format_font_2 = $settings_pdffont . ".php";
} else {
$format_font = "franklingothicbook";
$format_font_2 = "franklingothicbook.php";
}
if ($_GET[s1] > 0) {
$s1 = intval($_GET[s1]);
$s2 = intval($_GET[s2]);
$sql_firstpage = "SELECT qms_text FROM intranet_qms WHERE qms_toc1 = {$s1} AND qms_toc2 = {$s2}";
$result_firstpage = mysql_query($sql_firstpage, $conn) or die(mysql_error());
$array_firstpage = mysql_fetch_array($result_firstpage);
$qms_firstpage = strip_tags($array_firstpage['qms_text']);
} else {
$import_template = NULL;
}
if ($import_template == "1") {
$pdf->setSourceFile("library/background.pdf");
$tplidx = $pdf->ImportPage(1);
}
// Now add the first page
$pdf->addPage();
if ($import_template == "1") {
$pdf->useTemplate($tplidx, 0, 0, 210, 297);
}
$pdf->AddFont('century', '', 'Century.php');
$pdf->AddFont('franklingothicbook', '', 'franklingothicbook.php');
$pdf->AddFont('gillsans', '', 'gillsans.php');
$pdf->SetMargins(0, 0);
$pdf->SetAutoPageBreak("no");
// Create the sheet header
$pdf->SetFont("arial", '', $label_j);
$label_print_date = $label_title . ", created " . date("jS M y", time());
$label_url = "http://labelstudio.redcitrus.com";
$pdf->SetFontSize(8);
$pdf->SetTextColor(190, 190, 190);
$pdf->Cell(0, 5, $label_print_date, 0, 1, L, 0, $label_url);
$pdf->SetFont($font, '', $label_j);
$pdf->SetTextColor(0, 0, 0);
$pdf->SetFontSize($label_j);
if ($_GET[labeltype] != NULL) {
$labeltype = $_GET[labeltype];
} else {
$labeltype = 1;
