Error: Invoice Number is Not Set
\n"); return; } // // Check that this is a valid invoice number // $query = "select * from invoice_header where record_num = $invoice_num $swhere"; $results = db_query($query); if (db_num_rows($results) == 0) { echo("Error: Invoice Number Not Found
\n"); return; } $invoice = db_fetch_array($results); $school_num = $invoice['school_num']; // // Get school record // $query = "select * from schools where record_num = '$school_num'"; $results = db_query($query); if (db_num_rows($results) == 0) { echo("Error: School Not Found - $school_num
\n"); return; } $school = db_fetch_array($results); extract($invoice); extract($school); $school_name = trim($school_name); $invoice_total = $total; $balance_owing = $invoice_total - $amount_paid; $companyHeader = "EZS Software Inc. (Hot Lunches)"; $companyName = "EZS Software Inc."; if ($invoice_date < '2015-10-01') { $companyName = "Hot Lunches Online"; $companyHeader = "Hot Lunches Online"; } // // Initialize the PDF // $document_font = $school_record['document_font']; if (strlen($document_font) == 0) $document_font = "Helvetica"; $document_font_weight = ""; $document_text_color = "#000000"; $document_font_size = 10; $start_row = 55; $max_rows = 240; $left_col = 15; $date_col = 121; $amount_col = 145; $num_col = 150; $col = $left_col; $row = $start_row; $incr = 4; // // Setup the PDF libraries // require("tcpdf/config/lang/eng.php"); require("tcpdf/tcpdf.php"); $logo_url = $school_record['logo_url']; $logo_image = "images/" . $school_record['logo_image']; $logo_row = $max_rows + 5; class PDF extends TCPDF { function Header() { global $incr, $document_font, $document_font_size, $balance_owing, $companyName, $companyHeader; // Print the form $this->SetTextColor(0,0,0); $this->SetFillColor(hexdec("dd"),hexdec("dd"),hexdec("dd")); $this->SetLineWidth(0.3); $this->SetDrawColor(0,0,0); // Header image $this->Image("images/document-header.jpg",0,0,220); // Heading Text $this->SetFont($document_font,"B",$document_font_size + 3); $left_col = 13; $right_col = 105; $width = $right_col - $left_col; $text_row = 35; $this->SetXY($left_col,$text_row); $title_text = "INVOICE"; if ($balance_owing <= 0) $title_text = "RECEIPT"; $this->Cell($width,$incr + 2,$title_text,'0',0,'C',false,'',1); // Form Text $this->SetFont($document_font,"B",$document_font_size + 1); // Customer Box $left_col = 13; $right_col = 110; $top_row = 47; $middle_row = $top_row + 7; $bottom_row = $top_row + 35; // Draw Box $this->printBox($left_col,$top_row,$right_col,$bottom_row); // Middle Line $this->Line($left_col,$middle_row,$right_col,$middle_row); // Add Heading Text $this->SetXY($left_col + 1,$top_row + 1); $width = $right_col - $left_col - 2; $this->Cell($width,$incr + 1,"Customer",'0',0,'L',false,'',1); // Date and Invoice # Box $left_col = 120; $right_col = 200; $top_row = 47; $middle_row = $top_row + 7; $bottom_row = $top_row + 14; // Draw Box $this->printBox($left_col,$top_row,$right_col,$bottom_row); // Middle Line $this->Line($left_col,$middle_row,$right_col,$middle_row); // Add Heading Text $this->SetXY($left_col + 1,$top_row + 1); $width = $right_col - $left_col - 2; $this->Cell($width,$incr + 1,"Date",'0',0,'L',false,'',1); // Middle vertical line $center_col = $left_col + 40; $this->Line($center_col,$top_row,$center_col,$bottom_row); $this->SetXY($center_col + 1,$top_row + 1); $this->Cell($width,$incr + 1,"Invoice #",'0',0,'L',false,'',1); // Mailing Address $this->SetFont($document_font,"B",$document_font_size + 2); $left_col = 122; $row = 64; $this->SetXY($left_col,$row); $this->Cell($width,$incr + 1,$companyHeader,'0',0,'L',false,'',1); $this->SetFont($document_font,"B",$document_font_size + 1); $row += $incr; $this->SetXY($left_col,$row); $this->Cell($width,$incr + 1,"c/o 981 Noons Creek Close",'0',0,'L',false,'',1); $row += $incr; $this->SetXY($left_col,$row); $this->Cell($width,$incr + 1,"Port Moody, BC",'0',0,'L',false,'',1); $row += $incr; $this->SetXY($left_col,$row); $this->Cell($width,$incr + 1,"V3H 4J5",'0',0,'L',false,'',1); $this->SetFont($document_font,"B",$document_font_size + 1); // Due Date and Contact Person Boxes $left_col = 13; $right_col = 200; $top_row = 85; $middle_row = $top_row + 7; $bottom_row = $top_row + 14; // Draw Box $this->printBox($left_col,$top_row,$right_col,$bottom_row); // Middle Line $this->Line($left_col,$middle_row,$right_col,$middle_row); // Add Heading Text $this->SetXY($left_col + 1,$top_row + 1); $width = $right_col - $left_col - 2; $this->Cell($width,$incr + 1,"Due Date",'0',0,'L',false,'',1); // First vertical line $center_col = $left_col + 50; $this->Line($center_col,$top_row,$center_col,$bottom_row); $this->SetXY($center_col + 1,$top_row + 1); $this->Cell($width,$incr + 1,"Contact Person",'0',0,'L',false,'',1); // Second vertical line $center_col = $left_col + 140; $this->Line($center_col,$top_row,$center_col,$bottom_row); $this->SetXY($center_col + 1,$top_row + 1); $this->Cell($width,$incr + 1,"Next Renewal",'0',0,'L',false,'',1); // Main Item Box $left_col = 13; $right_col = 200; $top_row = 103; $middle_row = $top_row + 7; $bottom_row = $top_row + 140; // Draw Box $this->printBox($left_col,$top_row,$right_col,$bottom_row); // Middle Line $this->Line($left_col,$middle_row,$right_col,$middle_row); // Add Heading Text $this->SetXY($left_col + 1,$top_row + 1); $width = $right_col - $left_col - 2; $this->Cell($width,$incr + 1,"Description",'0',0,'L',false,'',1); // Totals horizontal line $line_row = $top_row + 112; $this->Line($left_col,$line_row,$right_col,$line_row); // First vertical line $center_col = $left_col + 140; $this->Line($center_col,$top_row,$center_col,$bottom_row); $this->SetXY($center_col + 1,$top_row + 1); $this->Cell(30,$incr + 1,"Amount",'0',0,'R',false,'',1); // Footer message $this->SetXY($left_col,244); if ($balance_owing > 0) { $this->MultiCell(200,$incr,"Thank You for Your Business\nPlease Make Checks Payable to \"$companyName\"",'0','C',false,1,'','',true,0,false,true); } else { $this->MultiCell(200,$incr,"Thank You for Your Business\n\"$companyName\"",'0','C',false,1,'','',true,0,false,true); } $this->SetFont($document_font,"B",$document_font_size); $this->SetXY($left_col,257); $this->MultiCell(200,$incr,"981 Noons Creek Close, Port Moody, BC, Canada V3H 4J5\nGST # 80267 2329",'0','C',false,1,'','',true,0,false,true); } function printBox($left,$top,$right,$bottom) { // Top Line $this->Line($left,$top,$right,$top); // Bottom Line $this->Line($left,$bottom,$right,$bottom); // Left Line $this->Line($left,$top,$left,$bottom); // Right Line $this->Line($right,$top,$right,$bottom); } function Footer() { global $incr, $left_col, $title_width, $max_rows, $document_font, $document_font_size, $document_name, $logo_image, $logo_url, $logo_row; return; // Print the date $this->SetFont($document_font,"",$document_font_size - 1); $this->SetXY($left_col,$logo_row); $date = dateString('datetime'); $this->Cell($title_width,$incr - 1,"$document_name: $date",'0',1,'R'); $this->SetXY(20,$logo_row + 9); $this->SetFont($document_font,"B",$document_font_size); $this->Cell($title_width,$incr,$logo_url,'0',1,'L'); } } $pdf= new PDF('P', 'mm', 'Letter', true, 'UTF-8', false); // set default monospaced font $pdf->SetDefaultMonospacedFont(PDF_FONT_MONOSPACED); //set margins $pdf->SetMargins(PDF_MARGIN_LEFT, PDF_MARGIN_TOP, PDF_MARGIN_RIGHT); //set auto page breaks $pdf->SetAutoPageBreak(TRUE, PDF_MARGIN_BOTTOM); //set image scale factor $pdf->setImageScale(PDF_IMAGE_SCALE_RATIO); $font_red = hexdec("00"); $font_green = hexdec("00"); $font_blue = hexdec("00"); $pdf->SetTextColor($font_red,$font_green,$font_blue); $pdf->SetFont($document_font,"",$document_font_size); $pdf->addPage(); $pdf->SetFont($document_font,"B",$document_font_size); // // Output school name and address // $name = $pac_name; if (strlen($bill_to_address) == 0) $bill_to_address = $address; if (strlen($bill_to_city) == 0) $bill_to_city = $city; if (strlen($bill_to_province) == 0) $bill_to_province = $province; if (strlen($bill_to_postal) == 0) $bill_to_postal = $postal; $pdf->SetXY($col,$row); $pdf->Cell(0,5,$name,0,1,"L",0); $row += $incr; $pdf->SetXY($col,$row); $pdf->Cell(0,5,$bill_to_address,0,1,"L",0); $row += $incr; $pdf->SetXY($col,$row); $pdf->Cell(0,5,"$bill_to_city, $bill_to_province",0,1,"L",0); $row += $incr; $pdf->SetXY($col,$row); $pdf->Cell(0,5,$bill_to_postal,0,1,"L",0); // // Invoice date and number // $col = $date_col; $row = $start_row; $pdf->SetXY($col,$row); $inv_date = date("M j, Y",strtotime($invoice_date)); $pdf->Cell(0,5,$inv_date,0,1,"L",0); $inv_num = sprintf("%06d-HL",$invoice_num + 500); $col = $date_col + 42; $pdf->SetXY($col,$row); $pdf->Cell(18,5,$inv_num,0,1,"R",0); // // Due date, etc... // $col = $left_col; $row = $start_row + 38; $pdf->SetXY($col,$row); $due_date = date("M j, Y",strtotime($due_date)); $due_date = "Due on Receipt"; $pdf->Cell(0,5,$due_date,0,1,"L",0); // Get contact name $contact_name = db_getVal("SELECT contact_name FROM school_contact_list WHERE school_num = $school_num AND sequence = 1"); $col = 64; $pdf->SetXY($col,$row); $pdf->Cell(0,5,$contact_name,0,1,"L",0); $renewal = date("M j, Y",strtotime($renewal_date)); $col = $amount_col + 10; $pdf->SetXY($col,$row); $pdf->Cell(0,5,$renewal,0,1,"L",0); // // Invoice line items // $query = "select * from invoice_items where invoice_num = $invoice_num order by sequence"; $results = db_query($query); if (db_num_rows($results)) { $row = $start_row + 56; $total = 0; while ($invoice_item = db_fetch_array($results)) { extract($invoice_item); $col = $left_col; $pdf->SetXY($col,$row); $pdf->Cell(138,5,$description,0,1,"L",false,'',1); if (isset($amount) && $amount != 0.00) { $col = $amount_col; $pdf->SetXY($col,$row); if ($amount > 0) $amt = $school_record['currency_symbol'] . number_format($amount,2); else $amt = "- $currencySymbol" . number_format(abs($amount),2); $pdf->Cell(40,5,$amt,0,1,"R",0); } $total += $amount; $row += $incr + 2; } // Print School Info $pdf->SetFont($document_font,"B",$document_font_size - 1); $row += $incr + 1; $col = $left_col + 5; $pdf->SetXY($col,$row); $pdf->Cell(0,5,$school_name,0,1,"L",0); $row += $incr + 1; $pdf->SetXY($col,$row); $pdf->Cell(0,5,$url,0,1,"L",0); $row += $incr + 1; $pdf->SetXY($col,$row); $pdf->Cell(0,5,$pac_name,0,1,"L",0); if ($include_school_names == 'Y' && $school['reseller'] != 'hotlunch') { $reseller = $school['reseller']; $results = db_query("SELECT school_name FROM schools WHERE status = 'Active' AND reseller = '$reseller' ORDER BY school_name"); $scount = 0; $names = ""; $row += $incr + 1; $col = $left_col + 10; $pdf->SetFont($document_font,"",$document_font_size - 2); while ($r = db_fetch_assoc($results)) { $name = $r['school_name']; if (strlen($names) > 0) $names .= ", "; $names .= $name; $scount++; if ($scount > 1) { $pdf->SetXY($col,$row); $pdf->Cell(0,5,$names,0,1,"L",0); $names = ""; $row += $incr; $scount = 0; } } if ($scount > 0) { $pdf->SetXY($col,$row); $pdf->Cell(0,5,$names,0,1,"L",0); $names = ""; } } // Print message $row += $incr * 3; $col = $left_col + 5; $pdf->SetXY($col,$row); $pdf->SetFont($document_font,"B",$document_font_size - 2); $today = date("Y-m-d",time()); $msg = "Please Note Our Address:\n - 981 Noons Creek Close, Port Moody, BC, V3H 4J5"; $pdf->MultiCell(120, $incr, $msg, '0','L',false); // Print totals $row = 220; $col = 120; if ($charge_gst == 'Y') { $row = 216; $pdf->SetXY($col,$row); $pdf->SetFont($document_font,"B",$document_font_size); $pdf->Cell(40,5,"SubTotal :",0,1,"L",0); $pdf->SetXY($amount_col,$row); $pdf->Cell(40,5,$currencySymbol . number_format($total,2),0,1,"R",0); $row += $incr * 1.1; $pdf->SetXY($col,$row); $pdf->Cell(40,5,$tax_code . " :",0,1,"L",0); $pdf->SetXY($amount_col,$row); $pdf->Cell(40,5,$currencySymbol . number_format($gst,2),0,1,"R",0); $row += $incr * 1.5; } $pdf->SetXY($col,$row); $pdf->SetFont($document_font,"B",$document_font_size); $pdf->Cell(40,5,"TOTAL :",0,1,"L",0); $pdf->SetXY($amount_col,$row); $pdf->Cell(40,5,$currencySymbol . number_format($total + $gst,2),0,1,"R",0); if ($amount_paid > 0) { $row += $incr * 1.5; $pdf->SetXY($col,$row); $pdf->SetFont($document_font,"B",$document_font_size); $pdf->Cell(40,5,"Payments :",0,1,"L",0); $pdf->SetXY($amount_col,$row); $pdf->Cell(40,5,"- " . $currencySymbol . number_format($amount_paid,2),0,1,"R",0); $row += $incr * 1.1; $pdf->SetXY($col,$row); $pdf->SetFont($document_font,"B",$document_font_size); $pdf->Cell(40,5,"BALANCE :",0,1,"L",0); $pdf->SetXY($amount_col,$row); $balance = ($total + $gst) - $amount_paid; if ($balance < 0) { $pdf->Cell(40,5,"- " . $currencySymbol . number_format($balance,2),0,1,"R",0); } else { $pdf->Cell(40,5,$currencySymbol . number_format($balance,2),0,1,"R",0); } } } // Output the completed PDF $file_name = str_replace("/","-",$school_name); $file_name = normalizeString($inv_num . "." . $file_name . ".pdf"); if ($balance_owing <= 0) $file_name = normalizeString($inv_num . "-receipt-$school_name.pdf"); header('Pragma: public'); header('Expires: 0'); header('Cache-Control: must-revalidate, post-check=0, pre-check=0'); header('Cache-Control: private',false); header('Content-type: application/pdf'); header("Content-Disposition: attachment; filename=$file_name"); header('Content-Transfer-Encoding: binary'); if (file_exists("invoices/$file_name")) unlink("invoices/$file_name"); $pdf->Output("invoices/$file_name","F"); $pdf->Output("$file_name","D"); return; ?>