$format_bg_g = "220";
$format_bg_b = "220";
$format_ln_r = "220";
$format_ln_g = "220";
$format_ln_b = "220";
$current_date = TimeFormat(time());
$proj_id = CleanUp($_GET[proj_id]);
// Begin creating the page
//Page Title
$sql_proj = "SELECT * FROM intranet_projects WHERE proj_id = {$proj_id} LIMIT 1";
$result_proj = mysql_query($sql_proj, $conn) or die(mysql_error());
$array_proj = mysql_fetch_array($result_proj);
$proj_num = $array_proj['proj_num'];
$proj_name = $array_proj['proj_name'];
$sheet_title = "Project Checklist";
$pdf->SetXY(10, 45);
$pdf->SetFont($format_font, '', 24);
$pdf->SetTextColor(0, 0, 0);
$pdf->SetDrawColor(0, 0, 0);
$pdf->Cell(0, 10, $sheet_title);
$pdf->SetXY(10, 55);
$pdf->SetFont($format_font, '', 14);
$sheet_subtitle = $proj_num . " " . $proj_name;
$sheet_date = "Current at " . $current_date;
$pdf->Cell(0, 7.5, $sheet_subtitle, 0, 1, L, 0);
$pdf->Cell(0, 7.5, $sheet_date, 0, 1, L, 0);
$pdf->SetXY(10, 70);
$pdf->SetLineWidth(0.5);
$sql_checklist = "SELECT * FROM intranet_project_checklist_items LEFT JOIN intranet_project_checklist ON checklist_item = item_id AND checklist_project = {$proj_id} WHERE checklist_required != 1 ORDER BY item_group, item_order, checklist_date DESC, item_name";
$result_checklist = mysql_query($sql_checklist, $conn) or die(mysql_error());
$y = $pdf->GetY() + 10;
$contact_address_print = $contact_address_print . "\n" . $contact_address;
}
if ($contact_city) {
$contact_address_print = $contact_address_print . "\n" . $contact_city;
}
if ($contact_county) {
$contact_address_print = $contact_address_print . "\n" . $contact_county;
}
if ($contact_postcode) {
$contact_address_print = $contact_address_print . "\n" . $contact_postcode;
}
if ($country_printable_name) {
$contact_address_print = $contact_address_print . "\n" . $country_printable_name;
}
//Invoice Title
$pdf->SetXY(10, 45);
$pdf->SetFont($format_font, '', 26);
$pdf->SetTextColor(0, 0, 0);
$pdf->Cell(0, 10, $invoice_ref_print);
//Invoice Title
$pdf->SetXY(10, 55);
$pdf->SetFont($format_font, '', 20);
$pdf->SetTextColor(0, 0, 0);
$pdf->Cell(0, 10, $invoice_project_print);
//Invoice Date
$pdf->SetXY(10, 62);
$pdf->SetFont($format_font, '', 20);
$pdf->SetTextColor(0, 0, 0);
$pdf->Cell(0, 10, $invoice_date_print);
//Heading Titles Heading
$pdf->SetFont($format_font, '', 9);
if ($user_usertype_current <= 3) {
header("Location: index2.php");
}
// Use FDPI to get the template
define('FPDF_FONTPATH', 'fpdf/font/');
require 'fpdf/fpdi.php';
$pdf = new fpdi();
$pagecount = $pdf->setSourceFile("pdf/template.pdf");
$tplidx = $pdf->ImportPage(1);
$pdf->addPage();
$pdf->useTemplate($tplidx, 0, 0, 210, 297);
$pdf->AddFont($format_font, '', $format_font_2);
// Begin creating the page
//Page Title
$sheet_title = "Verified Expenses, " . date("j F Y, g:i a", $ts_expense_verified);
$pdf->SetXY(10, 45);
$pdf->SetFont($format_font, '', 26);
$pdf->SetTextColor(200, 200, 200);
$pdf->Cell(0, 10, $sheet_title);
$pdf->SetXY(10, 55);
$pdf->SetFont($format_font, '', 12);
// Columnn Headings
$pdf->SetTextColor(220, 220, 220);
$pdf->SetFont($format_font, '', 8);
$pdf->Cell(10, 4, "ID", 0, 0, L, 0);
$pdf->Cell(20, 4, "Date", 0, 0, L, 0);
$pdf->Cell(15, 4, "Project", 0, 0, L, 0);
$pdf->Cell(55, 4, "Description", 0, 0, L, 0);
$pdf->Cell(20, 4, "Date Verified", 0, 0, L, 0);
$pdf->Cell(25, 4, "Invoice (ID)", 0, 0, L, 0);
$pdf->Cell(15, 4, "Net.", 0, 0, R, 0);
$format_bg_g = "220";
$format_bg_b = "220";
$format_ln_r = "220";
$format_ln_g = "220";
$format_ln_b = "220";
$current_date = TimeFormat(time());
$proj_id = CleanUp($_GET[proj_id]);
// Begin creating the page
//Page Title
$sql_proj = "SELECT * FROM intranet_projects WHERE proj_id = {$proj_id} LIMIT 1";
$result_proj = mysql_query($sql_proj, $conn) or die(mysql_error());
$array_proj = mysql_fetch_array($result_proj);
$proj_num = $array_proj['proj_num'];
$proj_name = $array_proj['proj_name'];
$sheet_title = "Drawing Schedule";
$pdf->SetXY(10, 45);
$pdf->SetFont($format_font, '', 24);
$pdf->SetTextColor(150, 150, 150);
$pdf->SetDrawColor(150, 150, 150);
$pdf->Cell(0, 10, $sheet_title);
$pdf->SetXY(10, 55);
$pdf->SetFont($format_font, '', 14);
$sheet_subtitle = $proj_num . " " . $proj_name . ", printed " . $current_date;
$pdf->Cell(0, 10, $sheet_subtitle, 0, 1, L, 0);
$pdf->SetXY(10, 60);
$pdf->SetLineWidth(0.5);
// And now the list of drawings issued
unset($current_drawing);
//$sql_drawings = "SELECT * FROM intranet_drawings_issued, intranet_drawings LEFT JOIN intranet_drawings_revision ON revision_drawing = drawing_id WHERE issue_set = $set_id AND issue_drawing = drawing_id ORDER BY drawing_number";
$sql_drawings = "SELECT * FROM intranet_drawings, intranet_drawings_scale, intranet_drawings_paper WHERE drawing_project = {$proj_id} AND drawing_scale = scale_id AND drawing_paper = paper_id order by drawing_number";
$result_drawings = mysql_query($sql_drawings, $conn) or die(mysql_error());
$user_name_first = $array_project['user_name_first'];
$user_name_second = $array_project['user_name_second'];
if ($blog_type == "phone") {
$blog_type_view = "Telephone Call";
} elseif ($blog_type == "filenote") {
$blog_type_view = "File Note";
} elseif ($blog_type == "meeting") {
$blog_type_view = "Meeting Note";
} elseif ($blog_type == "email") {
$blog_type_view = "Email Message";
} else {
$blog_type_view = NULL;
$type = 0;
}
$blog_type_view = $blog_type_view . " - " . $user_name_first . " " . $user_name_second;
$pdf->SetXY(10, 45);
$pdf->SetFont($format_font, '', 14);
$pdf->SetTextColor(200, 200, 200);
$sheet_subtitle = $proj_num . " " . $proj_name . ", " . TimeFormat($blog_date);
$pdf->Cell(0, 7.5, $sheet_subtitle, 0, 1, L, 0);
$pdf->Cell(0, 7.5, $blog_type_view, 0, 1, L, 0);
$pdf->SetFont($format_font, '', 24);
$pdf->SetTextColor(150, 150, 150);
$pdf->MultiCell(0, 8, $blog_title, 0, L);
$pdf->SetXY(40, 85);
$pdf->SetFont($format_font, '', 11);
$pdf->SetTextColor(0, 0, 0);
$pdf->MultiCell(0, 5, $blog_text, 0, L);
// and send to output
$file_name = $proj_num . "_" . Date("Y", $blog_date) . "-" . Date("m", $blog_date) . "-" . Date("d", $blog_date) . "_" . $blog_type . ".pdf";
$pdf->Output($file_name, I);
if ($_GET[s1] > 0) {
$s1 = intval($_GET[s1]);
$section = "Section " . $_GET[s1] . " only - " . $qms_firstpage;
$s1 = " WHERE qms_toc1 = {$s1} ";
} else {
unset($s1);
}
if ($_GET[s2] > 0) {
$s2 = intval($_GET[s2]);
$section = "Section " . $_GET[s1] . "." . $_GET[s2] . " only - " . $qms_firstpage;
$s2 = " AND qms_toc2 = {$s2} ";
} else {
unset($s2);
}
$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);
$address_go = $address_go . "\n" . $company_county;
} elseif ($contact_county != NULL) {
$address_go = $address_go . "\n" . $contact_county;
}
if ($company_postcode != NULL) {
$address_go = $address_go . ", " . $company_postcode;
} elseif ($contact_postcode != NULL) {
$address_go = $address_go . "\n" . $contact_postcode;
}
if ($company_name != NULL) {
$company_name_inc = $company_name . "\n";
} else {
unset($company_name_inc);
}
// Set current x and y
$pdf->SetXY($x, $y);
// Print Border if requested
if ($_POST[borders] == "1") {
$pdf->SetDrawColor(200, 200, 200);
$pdf->Cell($label_c, $label_d, '', 1);
$pdf->SetDrawColor(0, 0, 0);
}
// Print Address
$cell_width = $label_c - $cell_margin_left - $cell_margin_left;
$cell_x = $x + $cell_margin_left;
$cell_y = $y + $cell_margin_top;
if ($_POST[marketing] == 0 and $contact_include == 3) {
$pdf->SetTextColor(0, 0, 200);
} elseif ($_POST[marketing] == 0 and $contact_include == 2 and $contact_email != NULL) {
$address_go = $contact_namefirst . " " . $contact_namesecond . "\n" . $company_name_inc . $contact_email;
} elseif ($_POST[marketing] == 2 and $contact_include == 2) {
// Use FDPI to get the template
define('FPDF_FONTPATH', 'fpdf/font/');
require 'fpdf/fpdi.php';
$pdf = new fpdi();
$pagecount = $pdf->setSourceFile("pdf/template.pdf");
$tplidx = $pdf->ImportPage(1);
$pdf->addPage();
$pdf->useTemplate($tplidx, 0, 0, 210, 297);
$pdf->AddFont($format_font, '', $format_font_2);
// Begin creating the page
$project_counter = 1;
$page_count = 1;
$month_count = 1;
$x = 10;
$y = 50;
$pdf->SetXY($x, $y);
// Reset all the counters
$invoice_value_novat_month_all = 0;
$invoice_value_vat_month_all = 0;
$invoice_value_novat_total_all = 0;
$invoice_value_vat_total_all = 0;
$thismonth = 0;
$thisyear = 0;
$invoice_year_novat = 0;
$invoice_year_vat = 0;
$total_12month_novat = array("0", "0", "0", "0", "0", "0", "0", "0", "0", "0", "0", "0");
$total_12month_vat = array("0", "0", "0", "0", "0", "0", "0", "0", "0", "0", "0", "0");
//Page Title
$sheet_title = "Invoice Summary, " . date("j F Y", time());
$pdf->SetXY(10, 45);
$pdf->SetFont($format_font, '', 26);
$set_reason = $array_set['set_reason'];
$set_method = $array_set['set_method'];
$set_format = $array_set['set_format'];
$set_comment = $array_set['set_comment'];
$set_checked = $array_set['set_checked'];
if ($set_checked > 0) {
$sql_set_checked = "SELECT user_initials FROM intranet_user_details WHERE user_id = {$set_checked} LIMIT 1";
$result_set_checked = mysql_query($sql_set_checked, $conn) or die(mysql_error());
$array_set_checked = mysql_fetch_array($result_set_checked);
$user_checked_initials = $array_set_checked['user_initials'];
} else {
$user_checked_initials = "None";
}
$user_name = $array_set['user_initials'];
$sheet_title = "Drawing Issue Sheet";
$pdf->SetXY(10, 45);
$pdf->SetFont($format_font, '', 24);
$pdf->SetTextColor(0, 0, 0);
$pdf->SetDrawColor(0, 0, 0);
$pdf->Cell(0, 10, $sheet_title);
$pdf->SetXY(10, 55);
$pdf->SetFont($format_font, '', 14);
$sheet_subtitle = $proj_num . " " . $proj_name . ", " . $set_date;
$pdf->Cell(0, 10, $sheet_subtitle, 0, 1, L, 0);
$pdf->SetXY(10, 70);
$pdf->SetDrawColor(0, 0, 0);
$pdf->SetFont("Helvetica", 'B', 8);
$pdf->Cell(40, 5, "Purpose of Issue", 0, 0, L, 0);
$pdf->Cell(30, 5, "Method of Issue", 0, 0, L, 0);
$pdf->Cell(30, 5, "Format", 0, 0, L, 0);
$pdf->Cell(30, 5, "Issued By", 0, 0, L, 0);
$user_prop_multiplier = $user_prop / $user_prop_target;
} else {
$user_prop_multiplier = 1;
}
$this_user = $user_timesheet_hours * $user_prop_multiplier * $user_user_rate * (1 - $user_prop);
$weekly_cost = $weekly_cost + $this_user;
//$array_total_cost[] = $this_user; //remove
//$print = $user_id . ": " . round ($this_user); $pdf->Cell(15,4,$print,1,0); // remove
}
//$weekly_cost = array_sum($array_total_cost); //remove
return $weekly_cost;
}
//$test = StaffCost($current_time,"");
$x = 0;
$y = $pdf->GetY() + 5;
$pdf->SetXY($x, $y);
//$pdf->MultiCell(0,5,$test);
$pdf->SetFont('Helvetica', 'B', 6);
$pdf->Cell(0, 5, '', 0, 1, L);
$pdf->Cell(40, 5, "Target Staff Costs", 0, 0, L);
$pdf->SetFont('Helvetica', '', 6);
$beginweek = BeginWeek($current_time);
while ($x <= 220) {
$x = $x + $colwidth;
$total = "£" . number_format(StaffCost($beginweek, "target"));
$pdf->Cell($colwidth, 3, $total, 0, 0, R);
$beginweek = $beginweek + 604800;
}
if ($pdf->GetY() > 170) {
$pdf->addPage(L);
DrawGrid();
