Php Pdf Add-ons

<?php

// @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@

// System Section : PDF Report Generation

// Title : Section 2.1 About the Property

// Author : Jerry Quinnell 

// Date : Jan 2017

// Change Log : 6/2/17 - Check no text and issue warning in report and error page at the end

// Change Log : 6/2/17 - Enhance - pictures 1/2 width or full width as per surveyors pref

// 				16/3   - Changed echos to error_log to help debugging

// CH200717 - Check for any XX's left in template paragraphs by mistake

// CH231017 - 2.1 Data Splat cos Session vars used - taken them all out and changed $sqltext[$k] = trim($jqdata);

// Completely re-written in DEC17 to encompass all three seciton 3 sections

// CHXMAS17 - Added ROWSPAN to cure picture and caption on same page

// CH030119 - Put in picture not found check - inserts white error blank jpg in its place 

// @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@

// session_start();

ob_start(); // Required to use the header redirect down below

$prrn = $_SESSION['prrn'];

$hbbsid = $_SESSION['user'];

// @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@

//                      Get product data

// @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@

// $type is set in PDF0-AACONTROL.php

for ($section = 21; $section < 23; $section++){

//	echo ("<br>Section=" . $section);

	$query  = "SELECT * FROM DBxyz

	$result = $connection->query($query);

	if (!$result) die ("<br><br>Database access failed: " . $conn->error);

	while($rs = $result->fetch_array(MYSQLI_ASSOC)) {	

		$elementdesc = $rs["elementdesc"];

		$rating = $rs["rating"];

		$dbfield = $rs["dbfield"];

		$count = $rs["elecount"];				

		$labels[1] =  $rs["f1"];

		$labels[2] =  $rs["f2"];

		$labels[3] =  $rs["f3"];

		$labels[4] =  $rs["f4"];

		$labels[5] =  $rs["f5"];

		$labels[6] =  $rs["f6"];

		$labels[7] =  $rs["f7"];

		$labels[8] =  $rs["f8"];

		$labels[9] =  $rs["f9"];

		$labels[10] =  $rs["f10"];

		$labels[11] =  $rs["f11"];

		$labels[12] =  $rs["f12"];

		$labels[13] =  $rs["f13"];

		$labels[14] =  $rs["f14"];

		$labels[15] =  $rs["f15"];	   

		$headertext[1] = $rs["headertext1"];	   

		$headertext[2] = $rs["headertext2"];	   

		$headertext[3] = $rs["headertext3"];	   

		$watermark = $rs["watermark"];		

	}

// @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@

//                      Get Reportdata2

// @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@	

	$query  = "SELECT * FROM reportdata2 WHERE datarecord='" . $prrn . "'";

	$result = $connection->query($query);

	if (!$result) die ("<br>Database access failed: " . $connection->error);

	while($rs = $result->fetch_array(MYSQLI_ASSOC)) {    // Only one record obtained

		for ($i = 0; $i < $count; $i++) {

			$k = $i + 1;

			$rid = $dbfield . $k;

			$jqdata = $rs[$rid] . ' ';

			if ($rs[$rid] == 'undefined') {

				$jqdata = "";

			}

			$sqltext[$k] = trim($jqdata); 	// CH231017 - 2.1 Data Splat cos Session vars used			

		}

	}

// ------------------------------------------------------------------------------------------------------------------------					

// Colour code decoding text - it comes to us with text delimited by #colour# to start the string then ends with ##

// We swap the ## bits to <colour> and </colour> using special characters as str_replace wont put in the '<' '/>' bits

// then we decode the string from the codes to HMTLchars		

// ------------------------------------------------------------------------------------------------------------------------

	for ($i = 1; $i < $count+1; $i++) {

		$sqltext[$i] = str_replace('#red#','&lt;red&gt;',$sqltext[$i]);  	// Swaps the #red# to a <red>

		$sqltext[$i]= str_replace('##','&lt;/red&gt;',$sqltext[$i]);		// Swaps the ## to a </red>

		$sqltext[$i] = html_entity_decode($sqltext[$i]);					// Decode to visible html chars for the PDF bit to work

	}

// -----------------------------------------Colour code ends --------------------------------------------------------------

// @@@@@@@@@@@@@@@@@@ Process Pictures now - use Function GetPix defined in hbbsreport1 to get this elements pictures and captions.

$repimages = array();   // To contain the filenames

$repcaption = array();  // To contain the captions

$repwidth = array();  	// To contain the picture wdith (for portrait or landscape)		// CH6/2/17

$pixpos = array();  	// To contain the picture wdith (for portrait or landscape)		// CH6/2/17

//$dir = 'PRRN' . $prrn . '/'; // build the folder name

$dir = 'PRRN' . $prrn . $hbbsid .'/'; // build the folder name

$query  = "SELECT * FROM db

$result = $connection->query($query);

if (!$result) die ("Database access failed: " . $connection>error);

while($rs = $result->fetch_array(MYSQLI_ASSOC)) {	

	$file = $rs["filename"]; // Build filename			

	$repimages[] = $dir . $file;  								// yes we need the picture so save the original uploaded filename (which doesnt change in its lifetime) in the array

	$repcaption[] = $rs["pixcap"]; 								// yes we need the picture so save the caption which does get change by the users in the array

	$pixpos[] = $rs["pixpos"]; 									// yes we need the picture so save the caption which does get change by the users in the array

//	error_log('filename=' . $dir . $file . ' : caption=' . $rs["pixcap"]);

} // While

$elepixno = count($repimages);

//error_log('pix count=' . $elepixno);

for ($i=0; $i<$elepixno; $i++) {     

	if (@getimagesize($repimages[$i])) { // CH030119 Is the image present ? - Process if YES, error log msg if NO (System error basically)

	   	$size = getimagesize($repimages[$i]); // CH6/2/17 

		$width = $size[0]; 							// CH6/2/17

		$height = $size[1];							// CH6/2/17

		$aspect = $height /	$width; 				// CH6/2/17

		if ($prefpixwidth == 1){	

			if ($aspect >= 1) $repwidth[$i] = 50;	// CH6/2/17 Portrait

			else $repwidth[$i] = 70;				// CH6/2/17 Landscape

		}

		else {

			if ($aspect >= 1) $repwidth[$i] = 85; 	// CH6/2/17 Portrait

			else $repwidth[$i] = 130;				// CH6/2/17 Landscape

		}				// CH6/2/17 Landscape			

	}

	else { // CH030119 - Put in picture not found check - inserts white error blank jpg in its place 

			$reportmsg = $reportmsg . '- Section 2 - Picture Not found - Database Mismatch advise Skyline Tech Support: ' . $repimages[$i] . '

'; // Put this on next line to create a line break <br> equivalent   // CH070218 - put the fullstop inbetween the section element $substring number - for the error report

			$repimages[$i]= 'images/skypixnotfound.jpg';  // CH030119  Put in the white NOT FOUND IMAGE instead

			$repwidth[$i]=  55;  						  // CH030119  Set the repwidth as otherwise array element will generate 'Undefined Offset' warning in PHP log

	} // If @getimagesize

 } // For Loop

// ----------------------------- END of GET PICTURES -----------------------------------

// @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ PDF CODE START @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@

$oTable->SetStyle( "red", $oPdf->getDefaultFontName(), "", 9, "255,0,0" );

$oTable->SetStyle( "blue", $oPdf->getDefaultFontName(), "", 9, "0,0,255" );

// $oTable->SetStyle( "red", $oPdf->getDefaultFontName(), B=Bold I=Italic U=Underline, Fontsize, Color array );

$oTable->initialize( array( 24,78,78 ) );

$aRow = array();

$aRow[ 0 ] = array(	'TYPE' => 'IMAGE','FILE' =>  $logo,	'WIDTH' => 16,'PADDING_BOTTOM' => 5,'VERTICAL_ALIGN' => 'T');

$aRow[ 1 ] = array(	'TEXT' => 'Section 2	Property information

' . $elementdesc ,'TEXT_TYPE' => 'B',	'TEXT_COLOR' => $white,'BACKGROUND_COLOR' => $colour,'TEXT_ALIGN' => 'L','TEXT_SIZE' => '10','COLSPAN' => 2,);

$oTable->addRow( $aRow );

if ($section == 22) {

	$text = "This section is a summary of matters that are of particular interest but you should consider ALL information contained in this report.";

	$aRow[ 0 ] = array(	'TEXT' => $text,'TEXT_ALIGN' => 'L','COLSPAN' => 3,'TEXT_SIZE' => 9,'PADDING_LEFT' => 2,'PADDING_RIGHT' => 2,'PADDING_TOP' =>2,'PADDING_BOTTOM' => 5,'BORDER_TYPE' => 'LRTB');

	$oTable->addRow( $aRow );

}

for($i=1;$i<$count+1;$i++) { 

	if ($i==$count && $sqltext[$i] == "") continue;  // If last field = Miscellaneous and there's no text then dont print the line - skip to next field (which is techinically the end)

	if (strpos(strtoupper($sqltext[$i]), 'XX') !== false) {		// CH200717 - Check for any XX's left in template paragraphs by mistake

		$reportmsg = $reportmsg . '- Section ' . substr($section,0,1) . '.' . substr($section,1) .  ' - XXs left in Field : ' . $labels[$i] . '

'; // Put this on next line to create a line break <br> equivalent

	}

	if (strpos(strtoupper($sqltext[$i]), '%20') !== false) {		// CH200717 - Check for any %20's left in template paragraphs by mistake

		$reportmsg = $reportmsg . '- Section ' . substr($section,0,1) . '.' .  substr($section,1) .  ' - %20s are present due to a data error - go back and hit SAVE DATA twice to remove them -Field - : ' . $labels[$i] .  '

'; // Put this on next line to create a line break <br> equivalent

	}

	if ($sqltext[$i] == "") {

		$sqltext[$i] = 'YOU MUST ENTER SOME TEXT INTO THIS FIELD';

		$reportmsg = $reportmsg . '- Section ' . substr($section,0,1) . '.' . substr($section,1) .  ' - Missing Text in Field : ' . $labels[$i] . '

'; // Put this on next line to create a line break <br> equivalent

		$textcolour = array (255,0,0); // Red Text

	}

	else {

		if (strtoupper($sqltext[$i]) == "NO ISSUE NOTED BY SURVEYOR") 	$textcolour = array (135,206,235); // Light Blue Text

		else $textcolour = array (0,0,0); // Black Text

	}

	$aRow = array();

    $aRow[ 0 ] = array('TEXT' => $labels[$i],'TEXT_TYPE' => 'B','PADDING_LEFT' => 2,'PADDING_RIGHT' => 2,

    'PADDING_TOP' => 5,'PADDING_BOTTOM' => 5,'VERTICAL_ALIGN' => 'T','TEXT_ALIGN' => 'L','TEXT_SIZE' => 7,'TEXT_TYPE' => 'B','BORDER_TYPE' => 'LRTB');

	$aRow[ 1 ] = array('TEXT' => $sqltext[$i],'TEXT_COLOR' => $textcolour, 'TEXT_ALIGN' => 'L','TEXT_SIZE' => 9,

	'PADDING_LEFT' => 2,'PADDING_RIGHT' => 2,'PADDING_TOP' =>5,'PADDING_BOTTOM' => 5,'BORDER_TYPE' => 'LRTB','COLSPAN' => 2,);

    $oTable->addRow( $aRow );

// Any pictures now ?  

	$subelecnt = 0; 							// Reset Picture count for this sub element

    for ($j=0; $j<$elepixno; $j++) {			// Loop round the number of pix found for the whole of section 2 - could be none but a max of 2.

		$subele = $pixpos[$j];  				// Get the sub element - 1 -12 in section 2.1

		if ($subele == $i) {					// if chars 3 and 4 of the pic filename equals the sub section 1-12 then insert the picture

			$subelecnt = $subelecnt + 1;		// add 1 to element pix count = max of two allowed

			if ($subelecnt < 12) {				// CH16/3 - changed from max of 2 to 12 - If picture 1 - 12 then allow thru - max of 12 allowed

				$aRow = array();

				$aRow[ 0 ] = array('ROWSPAN' => 2, 'TEXT' => ' ','BORDER_TYPE' => 'LRB',);  // CHXMAS17 - Added ROWSPAN to cure picture and caption on same page

//				$aRow[ 0 ] = array( 'TEXT' => ' ','BORDER_TYPE' => 'LR',);

				$aRow[ 1 ] = array(	'TYPE' => 'IMAGE',	'FILE' => $repimages[$j], 'WIDTH' => $repwidth[$j], 'BORDER_TYPE' => 'LRB','ALIGN' => 'C', 'COLSPAN' => 2);

				$oTable->addRow( $aRow );				

				$aRow = array();

				$aRow[ 0 ] = array(	'TEXT' => ' ',	'BORDER_TYPE'  => 'LRB', );

				$aRow[ 1 ] = array(	'TEXT' => $repcaption[$j], 'TEXT_SIZE' => 8,	'BORDER_TYPE' => 'LR','ALIGN' => 'C', 	'COLSPAN' => 2,);

				$oTable->addRow( $aRow );				

				if (strpos(strtoupper($repcaption[$j]), 'XX') !== false) {		// CH131117 - Check for any XX's left in template paragraphs by mistake

					$reportmsg = $reportmsg . '- Section ' . substr($section,0,1) . '.' . substr($section,1) .  ' - XXs left in Picture Caption : ' .$repcaption[$j] . '

'; // Put this on next line to create a line break <br> equivalent

				}

			}

		}

	}

}

$oTable->close();

if ($section != 22) $oPdf->AddPage(); // Dont throw a page on last section

} // for $section

$connection->close();	

//echo "<br> Before 2.1.2 NEW Table Close";

ob_end_clean();