PDF in PHP

  
// -------------------------  
    global $DBConnection1;  
  
	  
    // Create PDF Report File  
	class PDF extends FPDF  
	{  
		//Page header  
		function Header()  
		{  
		    //Logo  
		    $this->Image('LetterHeader.png',100,10,50,25);  
		    //Arial bold 10  
		    $this->SetFont('Arial','BI',10);  
		    //Move to the right  
		    $this->Cell(80,100);  
		    //Line break  
		    $this->Ln(1);  
		    //Title  
			$this->Cell(160,0,'A Church Name',0,1,'R');  
		    //Line break  
		    $this->Ln(3);  
//			$this->SetFont('Arial','B',10);  
		    $this->Cell(189,0,'Allegheny East Test',0,1,'R');  
		    //Line break  
		    $this->Ln(6);  
		    //Arial bold 15  
		    $this->SetFont('Arial','',8);  
		    $this->Cell(172.5,0,'6541 Munster Bill Rd',0,1,'R');  
		    //Line break  
		    $this->Ln(3);  
		    $this->Cell(165,0,'CityName, State',0,1,'R');  
		    //Line break  
		    $this->Ln(3);  
		    $this->Cell(158,0,'28880-8765',0,1,'R');  
		    //Line break  
		    $this->Ln(6);  
		    $this->Cell(175,0,'Telephone: 278-664-2269',0,1,'R');  
		    //Line break  
		    $this->Ln(3);  
		    $this->Cell(174,0,'Facsimile: 204-555-2067',0,1,'R');  
		    //Line break  
		    $this->Ln(3);  
		    $this->Cell(189.5,0,'Website: www.churchwebsite.com',0,1,'R');  
		    //Line break  
		    $this->Ln(5);  
  
		}  
  
		//Page footer  
		function Footer()  
		{  
		    //Position at 3.0 cm from bottom  
		    $this->SetY(-20);  
		    //Arial italic 8  
		    $this->SetFont('Arial','I',8);  
		    //Line break  
		    $this->Ln(5);  
		    //Page Footer   
		    $this->Cell(0,10,'**NOTE:  This is a receipt for a tax-deductible contribution for which the organization has',0,0,'L');  
		    //Line break  
		    $this->Ln(5);  
		    //Page Footer   
		    $this->Cell(0,10,'         provided no goods or services other than intangible religious benefits to the donor.',0,0,'L');  
		}  
	}  
  
	$pdf=new PDF();  
	$theyear = CCGetParam("Yr","2001");  
	$theperson = CCGetParam("ID",0);  
  
	$qry1 ="SELECT YEAR(to_date) AS Yr, person.pid, person.p_fullname, if((person.ptid=3),person.p_fullname,concat(person.p_lname,', ',person.p_fname)) as fullname, ".  
	       "person.p_address1, concat(person.p_city,',  ',person.p_state,'  ',person.p_zip_code) as address2, ".  
	       "UCASE(department.dep_name) as depname, SUM(titheandoffering.to_amount) AS Total ".  
		   "FROM person INNER JOIN titheandoffering ON (person.pid = titheandoffering.pid) ".  
		   "INNER JOIN department ON (titheandoffering.depid = department.depid) ";  
	$qryEnd = "GROUP BY YEAR(to_date), person.pid, fullname, depname ORDER BY fullname";   
	  
	if ($theperson == 0)   
	{  
	$WhereStatement ="WHERE YEAR(to_date) = ".$theyear." and (person.p_md = 0) AND (department.dep_tax_deduct = 1) ";  
	}  
	else  
	{  
	$WhereStatement ="WHERE person.pid= ".$theperson." and YEAR(to_date) = ".$theyear." and (person.p_md = 0) AND (department.dep_tax_deduct = 1) ";  
	}  
  
	// get Person Tithe and Offering  
	$db = new clsDBConnection1();  
	$qry= $qry1."".$WhereStatement."".$qryEnd;  
	$db->query($qry);  
    $prevnameid = 0;  
	$ttlsum = 0.00;   
  
	while ($db->next_record())  
	{  
		$nameid = $db->f("pid");  
		$name = $db->f("fullname");  
		$addr = $db->f("p_address1");  
		$addr2 = $db->f("address2");  
		if ($nameid <> $prevnameid)  
		{  
		    if ($prevnameid <> 0)  
			{  
				$pdf->Cell(30);  
				$pdf->Cell(40,0, "------------------------------------------",0,1,"L");  
				$pdf->Cell(120);  
				$pdf->Cell(10,0, "--------------------",0,1,"R");  
				$pdf->Ln(5);  
				$pdf->Cell(30);  
				$pdf->Cell(40,0, "GRAND TOTAL",0,1,"L");  
				$pdf->Cell(120);  
				$flt_ttlsum = sprintf("%01.2f",$ttlsum);   
				$pdf->Cell(10,0, "".$flt_ttlsum."",0,1,"R");  
			    $pdf->SetFont('Arial','I',8);  
			    $pdf->SetY(-40);  
				$pdf->Image('latouche.jpg',10,252,58);  
				$pdf->Ln(2);  
			    $pdf->Cell(0,10,'_______________________________________',0,0,'L');  
				$pdf->Ln(5);   
			    $pdf->Cell(0,10,'Olson LaTouche, Treasurer',0,0,'L');  
  
			}  
			  
			$pdf->AddPage();			  
			$pdf->SetFont('Arial','B',12);  
			$pdf->Cell(0,0, "Year ".$theyear, 0,1,'L');  
			$pdf->SetFont('Arial','',10);  
			$pdf->Ln(10);  
			$pdf->Cell(0,0, "".$name."", 0.1);  
			$pdf->Ln(5);  
			$pdf->Cell(0,0, "".$addr."", 0.1);  
			$pdf->Ln(5);  
			$pdf->Cell(0,0, "".$addr2."", 0.1);  
			$pdf->Ln(5);  
			$pdf->Ln(20);  
			$prevnameid = $nameid;  
			$ttlsum = 0;  
		}  
		  
		  
		$dep = $db->f("depname");  
		$ttl = $db->f("Total");  
		$ttlsum = $ttlsum + $ttl;  
		$pdf->Cell(30);  
		$pdf->Cell(40,0, "".$dep."",0,1,"L");  
		$pdf->Cell(120);  
		$pdf->Cell(10,0, "            ".$ttl."",0,1,"R");  
		$pdf->Ln(5);  
		  
	}  
	$pdf->Cell(30);  
	$pdf->Cell(40,0, "------------------------------------------",0,1,"L");  
	$pdf->Cell(120);  
	$pdf->Cell(10,0, "--------------------",0,1,"R");  
	$pdf->Ln(5);  
	$pdf->Cell(30);  
	$pdf->Cell(40,0, "GRAND TOTAL",0,1,"L");  
	$pdf->Cell(120);  
	$flt_ttlsum = sprintf("%01.2f",$ttlsum);   
	$pdf->Cell(10,0, "".$flt_ttlsum."",0,1,"R");  
    $pdf->SetFont('Arial','I',8);  
    $pdf->SetY(-40);  
	$pdf->Image('latouche.jpg',10,252,58);  
	$pdf->Ln(2);  
    $pdf->Cell(0,10,'_______________________________________',0,0,'L');  
	$pdf->Ln(5);   
    $pdf->Cell(0,10,'Olson LaTouche, Treasurer',0,0,'L');  
	$db->close();  
  
	$file = "hello.pdf" ;  
	$pdf->Output($file, "I");  
  
// -------------------------  
//End Custom Code  

  
> // -------------------------  
>    global $DBConnection1;  
>  
>  
>    // Create PDF Report File  
> class PDF extends FPDF  
> {  
> //Page header  
> function Header()  
> {  
>     //Logo  
>     $this->Image('LetterHeader.png',100,10,50,25);  
>     //Arial bold 10  
>     $this->SetFont('Arial','BI',10);  
>     //Move to the right  
>     $this->Cell(80,100);  
>     //Line break  
>     $this->Ln(1);  
>     //Title  
> $this->Cell(160,0,'A Church Name',0,1,'R');  
>     //Line break  
>     $this->Ln(3);  
> // $this->SetFont('Arial','B',10);  
>     $this->Cell(189,0,'Allegheny East Test',0,1,'R');  
>     //Line break  
>     $this->Ln(6);  
>     //Arial bold 15  
>     $this->SetFont('Arial','',8);  
>     $this->Cell(172.5,0,'6541 Munster Bill Rd',0,1,'R');  
>     //Line break  
>     $this->Ln(3);  
>     $this->Cell(165,0,'CityName, State',0,1,'R');  
>     //Line break  
>     $this->Ln(3);  
>     $this->Cell(158,0,'28880-8765',0,1,'R');  
>     //Line break  
>     $this->Ln(6);  
>     $this->Cell(175,0,'Telephone: 278-664-2269',0,1,'R');  
>     //Line break  
>     $this->Ln(3);  
>     $this->Cell(174,0,'Facsimile: 204-555-2067',0,1,'R');  
>     //Line break  
>     $this->Ln(3);  
>     $this->Cell(189.5,0,'Website: www.churchwebsite.com',0,1,'R');  
>     //Line break  
>     $this->Ln(5);  
>  
> }  
>  
> //Page footer  
> function Footer()  
> {  
>     //Position at 3.0 cm from bottom  
>     $this->SetY(-20);  
>     //Arial italic 8  
>     $this->SetFont('Arial','I',8);  
>     //Line break  
>     $this->Ln(5);  
>     //Page Footer  
>     $this->Cell(0,10,'**NOTE:  This is a receipt for a tax-deductible  
> contribution for which the organization has',0,0,'L');  
>     //Line break  
>     $this->Ln(5);  
>     //Page Footer  
>     $this->Cell(0,10,'         provided no goods or services other than  
> intangible religious benefits to the donor.',0,0,'L');  
> }  
> }  
>  
> $pdf=new PDF();  
> $theyear = CCGetParam("Yr","2001");  
> $theperson = CCGetParam("ID",0);  
>  
> $qry1 ="SELECT YEAR(to_date) AS Yr, person.pid, person.p_fullname,  
> if((person.ptid=3),person.p_fullname,concat(person.p_lname,',   
> ',person.p_fname))  
> as fullname, ".  
>        "person.p_address1, concat(person.p_city,',  ',person.p_state,'  
> ',person.p_zip_code) as address2, ".  
>        "UCASE(department.dep_name) as depname,   
> SUM(titheandoffering.to_amount)  
> AS Total ".  
>    "FROM person INNER JOIN titheandoffering ON (person.pid =  
> titheandoffering.pid) ".  
>    "INNER JOIN department ON (titheandoffering.depid = department.depid)   
> ";  
> $qryEnd = "GROUP BY YEAR(to_date), person.pid, fullname, depname ORDER BY  
> fullname";  
>  
> if ($theperson == 0)  
> {  
> $WhereStatement ="WHERE YEAR(to_date) = ".$theyear." and (person.p_md = 0)   
> AND  
> (department.dep_tax_deduct = 1) ";  
> }  
> else  
> {  
> $WhereStatement ="WHERE person.pid= ".$theperson." and YEAR(to_date) =  
> ".$theyear." and (person.p_md = 0) AND (department.dep_tax_deduct = 1) ";  
> }  
>  
> // get Person Tithe and Offering  
> $db = new clsDBConnection1();  
> $qry= $qry1."".$WhereStatement."".$qryEnd;  
> $db->query($qry);  
>    $prevnameid = 0;  
> $ttlsum = 0.00;  
>  
> while ($db->next_record())  
> {  
> $nameid = $db->f("pid");  
> $name = $db->f("fullname");  
> $addr = $db->f("p_address1");  
> $addr2 = $db->f("address2");  
> if ($nameid <> $prevnameid)  
> {  
>     if ($prevnameid <> 0)  
> {  
> $pdf->Cell(30);  
> $pdf->Cell(40,0, "------------------------------------------",0,1,"L");  
> $pdf->Cell(120);  
> $pdf->Cell(10,0, "--------------------",0,1,"R");  
> $pdf->Ln(5);  
> $pdf->Cell(30);  
> $pdf->Cell(40,0, "GRAND TOTAL",0,1,"L");  
> $pdf->Cell(120);  
> $flt_ttlsum = sprintf("%01.2f",$ttlsum);  
> $pdf->Cell(10,0, "".$flt_ttlsum."",0,1,"R");  
>     $pdf->SetFont('Arial','I',8);  
>     $pdf->SetY(-40);  
> $pdf->Image('latouche.jpg',10,252,58);  
> $pdf->Ln(2);  
>     $pdf->Cell(0,10,'_______________________________________',0,0,'L');  
> $pdf->Ln(5);  
>     $pdf->Cell(0,10,'Olson LaTouche, Treasurer',0,0,'L');  
>  
> }  
>  
> $pdf->AddPage();  
> $pdf->SetFont('Arial','B',12);  
> $pdf->Cell(0,0, "Year ".$theyear, 0,1,'L');  
> $pdf->SetFont('Arial','',10);  
> $pdf->Ln(10);  
> $pdf->Cell(0,0, "".$name."", 0.1);  
> $pdf->Ln(5);  
> $pdf->Cell(0,0, "".$addr."", 0.1);  
> $pdf->Ln(5);  
> $pdf->Cell(0,0, "".$addr2."", 0.1);  
> $pdf->Ln(5);  
> $pdf->Ln(20);  
> $prevnameid = $nameid;  
> $ttlsum = 0;  
> }  
>  
>  
> $dep = $db->f("depname");  
> $ttl = $db->f("Total");  
> $ttlsum = $ttlsum + $ttl;  
> $pdf->Cell(30);  
> $pdf->Cell(40,0, "".$dep."",0,1,"L");  
> $pdf->Cell(120);  
> $pdf->Cell(10,0, "            ".$ttl."",0,1,"R");  
> $pdf->Ln(5);  
>  
> }  
> $pdf->Cell(30);  
> $pdf->Cell(40,0, "------------------------------------------",0,1,"L");  
> $pdf->Cell(120);  
> $pdf->Cell(10,0, "--------------------",0,1,"R");  
> $pdf->Ln(5);  
> $pdf->Cell(30);  
> $pdf->Cell(40,0, "GRAND TOTAL",0,1,"L");  
> $pdf->Cell(120);  
> $flt_ttlsum = sprintf("%01.2f",$ttlsum);  
> $pdf->Cell(10,0, "".$flt_ttlsum."",0,1,"R");  
>    $pdf->SetFont('Arial','I',8);  
>    $pdf->SetY(-40);  
> $pdf->Image('latouche.jpg',10,252,58);  
> $pdf->Ln(2);  
>    $pdf->Cell(0,10,'_______________________________________',0,0,'L');  
> $pdf->Ln(5);  
>    $pdf->Cell(0,10,'Olson LaTouche, Treasurer',0,0,'L');  
> $db->close();  
>  
> $file = "hello.pdf" ;  
> $pdf->Output($file, "I");  
>  
> // -------------------------  
> //End Custom Code  
> 

Quote ckroon:

Hi Gena, you wouldn't have a sample code you code post for us newbs would you?
I am having trouble with the sql formatting.

Quote ckroon:

I am trying to the pdf to display a table with three database fields: lastname, firstname, and grade.
I suck at writing SQL so I was trying to pull it out of a grid I had made on a previous CCS page.
But the formatting is all wrong.
If I had a sample one to look at I think it would help.

  
  
//-----------------PDF output here--------------------------------------------------------------------------          
        // make a new pdf object  
$pdf = & new Cezpdf();  
$pdf->ezSetCmMargins(1,1,2,1); //ezSetCmMargins(top,bottom,left,right)  
// select the font  
$pdf->selectFont('./fonts/Helvetica');  
  
$pdf->ezStartPageNumbers(28.35 * 20 ,28.35,10,'left','',1); //ezStartPageNumbers(x,y,size,[pos],[pattern],[num])  
  
$X = 28.35 * 2 ; // cm 57;  
$pdf->addJpegFromFile("Images/logo_pdf.jpg",$X,700+39,142); // addJpegFromFile(imgFileName,x,y,w,[h])   
  
$pdf->addInfo("Title","Invoice " . $order_invoice); //Title, Author, Subject, Keywords, Creator  
$pdf->addInfo("Author","MSoft");  
$pdf->addInfo("Subject","Order " . $order_number);  
$pdf->addInfo("Keywords","");  
$pdf->addInfo("Creator","MSoft");  
  
  
$title = "INVOICE " . $order_invoice . " of " . GetInvoiceDate();  
$titleOrd = "Order " . $order_number . " of " . GetOrderDate();  
$title = $title . "\n" . " (" . $titleOrd .")";  
//customer and bill info  
$pdf->ezSetY(730);  
  $a = GetUserData();  
  $ivacase = $a['IVAcase'];  
  $i =0;  
  $data1[$i]['CustomerInfo']  = $a['CustomerInfo'];  
  $data1[$i]['BillingInfo']   = $a['BillingInfo'];  
    
  $cols1 = array('CustomerInfo'=>'Customer Information',  
                'BillingInfo'=>'Billing Information')   ;  
                
  $OrderY = $pdf->ezTable($data1,$cols1,'Customer',  
          array('xPos'=>$X,  
                'showHeadings'=>1,  
                'shaded'=>0,  
                'xOrientation'=>'right',  
                'width'=>18 * 28.35,  
                'cols'=>array(  
                     'CustomerInfo'=>array('justification'=>'right', 'width'=>9 * 28.35),  
                     'BillingInfo'=>array('justification'=>'right', 'width'=>9 * 28.35)  
                          )  
             ));    
//customer and bill info - finish  
  
$pdf->ezstream(array("Content-Disposition"=> "MsoftInvoice" . $order_invoice)); //filename here  
  
  
//-----------------PDF output here--------------------------------------------------------------------------