";
///////////////////////////////////////////////////////////////////////
// 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
///////////////////////////////////////////////////////////////////////
?>