"; /////////////////////////////////////////////////////////////////////// // Map For Sale Status Colors (Colours) //$var_StatusColorSale = '#33FF33'; //$var_StatusColorSold = '#FF0000'; //$var_StatusColorResv = '#FF00FF'; //$var_StatusColorInve = '#0000C0'; //$var_StatusColorCond = '#FFFF33'; /////////////////////////////////////////////////////////////////////// // used by customer/SitePlanPdf.php $arr_StatusCondition = array( 0 => '---------', 1 => 'For Sale', 2 => 'Sold', 3 => 'Reserved', 4 => 'Inventory', 5 => 'Condition', 6 => 'Pending', ); /////////////////////////////////////////////////////////////////////// // used by customer/SitePlanPdf.php /* $arr_StatusColor = array( 0 => array(0,0,0), //none - none #000000 1 => array(51,255,51), //green - for sale #33FF33 2 => array(255,0,0), //red - sold #FF0000 3 => array(255,0,255), //fuscia - reserved #FF00FF 4 => array(0,0,192), //blue - inventory #0000C0 5 => array(255,255,51), //yellow - condition #FFFF33 6 => array(255,255,51) //yellow - pending #FFFF33 ); */ /////////////////////////////////////////////////////////////////////// // used by customer/SitePlanPdf.php $arr_StatusColor = array( 0 => array(0,0,0), //none - none #000000 1 => hex2rgb($var_StatusColorSale), //green - for sale #33FF33 2 => hex2rgb($var_StatusColorSold), //red - sold #FF0000 3 => hex2rgb($var_StatusColorResv), //fuscia - reserved #FF00FF 4 => hex2rgb($var_StatusColorInve), //blue - inventory #0000C0 5 => hex2rgb($var_StatusColorCond), //yellow - condition #FFFF33 6 => hex2rgb($var_StatusColorCond) //yellow - pending #FFFF33 ); //print_r($arr_StatusColor); //die(); /////////////////////////////////////////////////////////////////////// // escape request strings $esc_Centre = mysqli_escape_string($dblink,$var_Centre); $esc_Phase = mysqli_escape_string($dblink,$var_Phase); $esc_Floor = mysqli_escape_string($dblink,$var_Floor); $esc_Type = mysqli_escape_string($dblink,$var_Type); /////////////////////////////////////////////////////////////////////// $sql_Floor = $var_Floor ? "AND col_DisplayFloor = '$esc_Floor'" : ""; $sql_Type = $var_Type ? "AND col_Type = '$esc_Type'" : ""; /////////////////////////////////////////////////////////////////////// //check to see if we have image for pdf $sql = " SELECT col_Type FROM tb_SiteMapGraphic WHERE col_Centre = '$esc_Centre' AND col_Phase = '$esc_Phase' $sql_Floor $sql_Type"; //echo "
118 $sql
"; $results = mysqli_query($dblink,$sql); while ($myrow = mysqli_fetch_array($results)) { //print_r($myrow); $var_Type = $myrow['col_Type']; if ($var_Type=='PDF') break; } /////////////////////////////////////////////////////////////////////// $esc_Type = mysqli_escape_string($dblink,$var_Type); $sql_Type = $var_Type ? "AND col_Type = '$esc_Type'" : ""; /////////////////////////////////////////////////////////////////////// //get map file image $sql = " SELECT col_SiteMapFileName, col_SiteMapCircleDiameter, col_PdfSiteMapCircleRadius, col_PdfSiteMapOrientation, col_SiteMapHeight, col_SiteMapWidth, col_PdfSiteMapHeight, col_PdfSiteMapWidth, col_Type FROM tb_SiteMapGraphic WHERE col_Centre = '$esc_Centre' AND col_Phase = '$esc_Phase' $sql_Floor $sql_Type"; //echo "
118 $sql
"; $results = mysqli_query($dblink,$sql); $myrow = mysqli_fetch_array($results); //print_r($myrow); $var_SiteMapCircleDiameter = $myrow['col_SiteMapCircleDiameter']; $var_SiteMapHeight = $myrow['col_SiteMapHeight']; $var_SiteMapWidth = $myrow['col_SiteMapWidth']; $var_Type = $myrow['col_Type']; $var_PdfSiteMapCircleRadius = $myrow['col_PdfSiteMapCircleRadius']; $var_PdfSiteMapOrientation = $myrow['col_PdfSiteMapOrientation']; $var_PdfSiteMapHeight = $myrow['col_PdfSiteMapHeight']; $var_PdfSiteMapWidth = $myrow['col_PdfSiteMapWidth']; $var_SiteMapFileName = $myrow['col_SiteMapFileName']; $var_PathFile = $var_SitePlanPdfPath.$var_SiteMapFileName; if ($var_PdfSiteMapOrientation!='P' && $var_PdfSiteMapOrientation!='L') $var_PdfSiteMapOrientation = 'L'; //echo "
o $var_PdfSiteMapOrientation"; /////////////////////////////////////////////////////////////////////// // PDFCreator init // create new PDF document //$pdf = new TCPDF(PDF_PAGE_ORIENTATION, PDF_UNIT, 'Letter', true, 'UTF-8', false); //$pdf = new TCPDF('L',PDF_UNIT,'Letter',true,'UTF-8',false); //$pdf = new TCPDF('P',PDF_UNIT,'Letter',true,'UTF-8',false); $pdf = new TCPDF($var_PdfSiteMapOrientation,PDF_UNIT,'Letter',true,'UTF-8',false); // set document information $pdf->SetCreator(PDF_CREATOR); $pdf->SetAuthor('BST'); $pdf->SetTitle('SiteMap PDF'); $pdf->SetSubject('SiteMap Subject'); $pdf->SetKeywords('SiteMap'); //set header data //$pdf->SetHeaderData(PDF_HEADER_LOGO, PDF_HEADER_LOGO_WIDTH, PDF_HEADER_TITLE, PDF_HEADER_STRING); // set header and footer fonts //$pdf->setHeaderFont(Array(PDF_FONT_NAME_MAIN, '', PDF_FONT_SIZE_MAIN)); //$pdf->setFooterFont(Array(PDF_FONT_NAME_DATA, '', PDF_FONT_SIZE_DATA)); // remove default header/footer $pdf->setPrintHeader(false); $pdf->setPrintFooter(false); // set default monospaced font $pdf->SetDefaultMonospacedFont(PDF_FONT_MONOSPACED); //set margins //$pdf->SetMargins(PDF_MARGIN_LEFT, PDF_MARGIN_TOP, PDF_MARGIN_RIGHT); $pdf->SetMargins(0,0,0); //set header footer height //$pdf->SetHeaderMargin(PDF_MARGIN_HEADER); //$pdf->SetFooterMargin(PDF_MARGIN_FOOTER); $pdf->SetHeaderMargin(0); $pdf->SetFooterMargin(0); //set auto page breaks //$pdf->SetAutoPageBreak(TRUE, PDF_MARGIN_BOTTOM); $pdf->SetAutoPageBreak(false,0); //set image scale factor //$pdf->setImageScale(PDF_IMAGE_SCALE_RATIO); //set some language-dependent strings //$pdf->setLanguageArray($l); // set font $pdf->SetFont('helvetica','',8); // set image scale factor $pdf->setImageScale(PDF_IMAGE_SCALE_RATIO); $pdf->setDisplayMode('fullpage','SinglePage','UseNone'); // add a page $pdf->AddPage(); /////////////////////////////////////////////////////////////////////// // set JPEG quality //$pdf->setJPEGQuality(75); $pdf->setJPEGQuality(500); /////////////////////////////////////////////////////////////////////// // get phases for map $str_Phase = ""; $var_BR = ""; $sql = " SELECT DISTINCT col_Phase FROM tb_SiteMapGraphic WHERE col_SiteMapFileName = '$var_SiteMapFileName' AND col_Centre = '$esc_Centre'"; $results = mysqli_query($dblink,$sql); while ($myrow = mysqli_fetch_array($results)) { $lst_Phase = $myrow['col_Phase']; $str_Phase .= $var_BR."'$lst_Phase'"; $var_BR = ","; } $str_Phase = $str_Phase ? "AND tb_LotCoordinate.col_Phase IN ($str_Phase)" : ""; /////////////////////////////////////////////////////////////////////// //set default pdf image size /////////////////////////////////////////////////////////////////////// //$var_PdfWidth = 300; //best look //$var_PdfHeght = 200; //best look //$var_PdfWidth = 300; //actual //$var_PdfHeght = 232; //actual //$var_PdfWidth = 300; //best fit //$var_PdfHeght = 210; //best fit //$radius = 0.5; //best fit $var_PdfWidth = 210; //best fit //portrait $var_PdfHeght = 300; //best fit $radius = 0.5; //best fit $var_PdfSiteMapWidth = $var_PdfSiteMapWidth ? $var_PdfSiteMapWidth : $var_PdfWidth; $var_PdfSiteMapHeight = $var_PdfSiteMapHeight ? $var_PdfSiteMapHeight : $var_PdfHeght; $var_PdfSiteMapCircleRadius = $var_PdfSiteMapCircleRadius ? $var_PdfSiteMapCircleRadius : $radius; //echo "
pw $var_PdfWidth ph $var_PdfHeght pr $radius"; //echo "
p2 $var_PdfSiteMapWidth ph $var_PdfSiteMapHeight pr $var_PdfSiteMapCircleRadius"; /////////////////////////////////////////////////////////////////////// //ratio = width/height $var_ImgRatio = $var_SiteMapWidth/$var_SiteMapHeight; //echo "
r $var_ImgRatio
"; /* if (($var_ImgRatio * $var_PdfHeght) > $var_PdfWidth) { //echo "
if
"; $var_PdfHeght = $var_PdfWidth/$var_ImgRatio; } else { //echo "
else
"; $var_ImgRatio = $var_SiteMapHeight/$var_SiteMapWidth; $var_PdfWidth = $var_PdfHeght/$var_ImgRatio; } */ //echo "
r $var_ImgRatio iw $var_PdfWidth ih $var_PdfHeght
"; //die(); /////////////////////////////////////////////////////////////////////// //draw image //$pdf->SetXY(0,0); $pdf->SetXY(0,0); //origin of site map on page $imgX = 0; $imgY = 0; //shift for circles to match visual location //$baseX = 0; //$baseY = 0; $baseX = -9; $baseY = -6; /////////////////////////////////////////////////////////////////////// //calculate image ratio //$ratioX = $var_SiteMapWidth ? $var_PdfWidth/$var_SiteMapWidth : 0; //$ratioY = $var_SiteMapHeight ? $var_PdfHeght/$var_SiteMapHeight: 0; $ratioX = $var_SiteMapWidth ? $var_PdfSiteMapWidth/$var_SiteMapWidth : 0; $ratioY = $var_SiteMapHeight ? $var_PdfSiteMapHeight/$var_SiteMapHeight: 0; //echo "
rx $ratioX ry $ratioY
"; /////////////////////////////////////////////////////////////////////// //$pdf->Image($1file,$2x,$3y,$4w,$5h,$6type,$7link,$8align,$9resize,$10dpi,$11pallign,$12ismask,$13imgmask,$14border,$15fitbox,$16hidden,$17fitonpage,$18alt,$19altimgs); //$pdf->Image($1file,$2x,$3y,$4w,$5h,$6type,$7link,$8align,$9resize,$10dpi,$11pallign,$12ismask,$13imgmask,$14border,$15fitbox,$16hidden,$17fitonpage); //$pdf->Image($var_PathFile,'','',$var_PdfWidth,$var_PdfHeght,'','','T',false,'','',false,false,0,false,false,false); // 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 //$pdf->Image($var_PathFile,$imgX,$imgY,$var_PdfWidth,$var_PdfHeght,'','','T',false,'','',false,false,0,false,false,false); //keep $pdf->Image($var_PathFile,$imgX,$imgY,$var_PdfSiteMapWidth,$var_PdfSiteMapHeight,'','','T',false,'','',false,false,0,false,false,false); //new //$pdf->Image($var_PathFile,$imgX,$imgY,$var_PdfWidth,$var_PdfHeght,'','','T',false,'','',false,false,0,true,false,false); //fitbox //$pdf->Image($var_PathFile,$imgX,$imgY,$var_PdfWidth,$var_PdfHeght,'','','T',false,'','',false,false,0,false,false,true); //fitpage /////////////////////////////////////////////////////////////////////// $sql_Floor2 = $var_Floor ? "AND tb_LotCoordinate.col_DisplayFloor = '$esc_Floor'" : ""; $sql_Type2 = $var_Type ? "AND tb_LotCoordinate.col_Type = '$esc_Type'" : ""; $sql = " SELECT tb_Lot.col_Lot, tb_Lot.col_SalesStatus, tb_LotCoordinate.col_DotX, tb_LotCoordinate.col_DotY FROM tb_LotCoordinate LEFT JOIN tb_Lot ON tb_LotCoordinate.col_Centre = tb_Lot.col_Centre AND tb_LotCoordinate.col_Phase = tb_Lot.col_Phase AND tb_LotCoordinate.col_Lot = tb_Lot.col_Lot WHERE tb_LotCoordinate.col_Centre = '$esc_Centre' $str_Phase $sql_Floor2 $sql_Type2 ORDER BY tb_Lot.col_Lot"; //echo "
321 ".$sql; $results = mysqli_query($dblink,$sql); /////////////////////////////////////////////////////////////////////// //plot dots while ($myrow = mysqli_fetch_array($results)) { //echo "

"; //print_r($myrow); //echo "

"; $var_Lot = $myrow['col_Lot']; $var_DotX = $myrow['col_DotX']; $var_DotY = $myrow['col_DotY']; $var_Status = $myrow['col_SalesStatus']; $var_Status = substr($var_Status,0,9); //echo "
1lot $var_Lot raw dx $var_DotX dy $var_DotY
"; //check x y are not 0 if ($var_DotX && $var_DotY) { //adjust for map xy placement $var_DotX = $var_DotX + $baseX + $imgX; $var_DotY = $var_DotY + $baseY + $imgY; $plt_DotX = $var_DotX*$ratioX; $plt_DotY = $var_DotY*$ratioY; //echo "
2lot $var_Lot plot dx $plt_DotX dy $plt_DotY
"; $var_Index = array_search($var_Status,$arr_StatusCondition); $var_Color = $arr_StatusColor[$var_Index]; //$var_Color = $arr_StatusColor[0]; //$pdf->Circle(1x,2y,3r,4angstr,5angend,6style,7line_style,8fill_color,9nc) // 1 2 3 4 5 6 7 8 $pdf->Circle($plt_DotX,$plt_DotY,$var_PdfSiteMapCircleRadius,0,360,'F','',$var_Color); //condiftional //orange } } /////////////////////////////////////////////////////////////////////// // if we've gotten here, method is print, so lets do it. $var_Filename = str_replace(' ','',$var_Centre.$var_Phase.$var_Floor).".pdf"; $var_OutputFile = '_builder/'.$var_Filename; $var_OutputPath = $var_WOUploadDir.$var_OutputFile; /////////////////////////////////////////////////////////////////////// //output pdf $pdf->Output($var_OutputPath,'F'); //file $pdf->Output($var_OutputPath,'I'); //screen /////////////////////////////////////////////////////////////////////// ?>