<?php

session_start();

include('db/db.php');

include('classes/User.php');

$us = new User();

$prepared_by = $us->getUserDetails();

$id = $_GET['id'];

$result = mysql_fetch_array(mysql_query("select * from savesearch where SearchID='$id'"))or die(mysql_error());

$set = unserialize($result['Param']);

$download = $set;

if(isset($download['results']['map']) || isset($download['map'])){

$map = isset($download['results']['map']) ? $download['results']['map'] : $download['map']; }

$map = file_get_contents($map);

$fp = fopen("$id.jpg",'w');

fwrite($fp,$map);

fclose($fp);

if($download['user_type']==2){

$address = isset($download['search']['address']) ? $download['search']['address']: "3101 West End Ave, Nashvelle TN 37203" ;

$bedrooms = isset($download['search']['bedrooms']) ? $download['search']['bedrooms'] : "3";

$bathrooms = isset($download['search']['bathrooms'])? $download['search']['bathrooms'] : "4";

$square_footage = isset($download['search']['square_footage']) ? $download['search']['square_footage'] : "2,455";

$stories = isset($download['search']['stories'])? $download['search']['stories'] : "1";

$lot_size = isset($download['search']['lot_size'])? $download['search']['lot_size']: "5,260";

$year_built = isset($download['search']['year_built'])? $download['search']['year_built']: "1991";

$pool = isset($download['search']['pool'])? $download['search']['pool']: "No";

$basement = isset($download['search']['basement'])? $download['search']['basement']: "No";

}else{

$address = isset($download['refineSearch']['address']) ? $download['refineSearch']['address']: "3101 West End Ave, Nashvelle TN 37203" ;

$bedrooms = isset($download['refineSearch']['bedrooms']) ? $download['refineSearch']['bedrooms'] : "3";

$bathrooms = isset($download['refineSearch']['bathrooms'])? $download['refineSearch']['bathrooms'] : "4";

$square_footage = isset($download['refineSearch']['square_footage']) ? $download['refineSearch']['square_footage'] : "2,455";

$stories = isset($download['refineSearch']['stories'])? $download['refineSearch']['stories'] : "1";

$lot_size = isset($download['refineSearch']['lot_size'])? $download['refineSearch']['lot_size']: "5,260";

$year_built = isset($download['refineSearch']['year_built'])? $download['refineSearch']['year_built']: "1991";

$pool = isset($download['refineSearch']['pool'])? $download['refineSearch']['pool']: "No";

$basement = isset($download['refineSearch']['basement'])? $download['refineSearch']['basement']: "No";

}

if(isset($download['results']['matchResult'])){

$match = $download['results']['matchResult'];

$matchResult = unserialize(urldecode($match));

$comps = array();

$not_comps = array();

foreach($matchResult as $key=>$detail){

if($user==2){

$comps[$key]=$detail;

$matchResult[$key]['utility'] = "Yes";

if(isset($_SESSION['results']['map']))

$_SESSION['results']['map'] = preg_replace("@color:$key\%@","color:blue%",$_SESSION['results']['map']);

if(isset($_SESSION['map']))

$_SESSION['map'] = preg_replace("@color:$key\%@","color:blue%",$_SESSION['map']);

}else{

if($download['results']['utilizes'][$key]=="Yes" ){

$comps[$key]=$detail;

$matchResult[$key]['utility'] = "Yes";

if(isset($download['results']['map']))

$download['results']['map'] = preg_replace("@color:$key\%@","color:blue%",$download['results']['map']);

if(isset($download['map']))

$download['map'] = preg_replace("@color:$key\%@","color:blue%",$download['map']);

}

else{

$reason = $_REQUEST['reasonRisk_'.$key.''];

$note = $_REQUEST['noteRisk_'.$key.''];

$detail['reason']=$reason;

$detail['note']=$note;

$not_comps[$key]=$detail;

$matchResult[$key]['utility'] = "No";

$matchResult[$key]['reason'] = $reason;

$matchResult[$key]['note'] = $note;

if(isset($download['results']['map']))

$download['results']['map'] = preg_replace("@color:$key\%@","color:pink%",$download['results']['map']);

if(isset($download['map']))

$download['map'] = preg_replace("@color:$key\%@","color:pink%",$download['map']);

}

}

}

$download['results']['matchResult'] = urlencode(serialize($matchResult));

//$us->updateSearch($address, 1, $download, $download['searchId']);

}

$download['sessionId'] = session_id();

$html = $html.'<style>

.btn-success { padding:6px 5px 6px 5px; }

#reportDiv { background-color:#60226b; width:156px; border-right:2px solid #fff;

border-left:2px solid #fff; }

#sideMenu { margin-left:9%; }

input,textarea,select { border:1px solid #cfcfcf;}

#pageContent { overflow-x:hidden;}

#backBtn { font-size:11px; padding:2px 2px 2px 2px; }

.box-3 {

position:relative;overflow:hidden;

width:400px;height:200px;border:1px dashed #0C0;text-align:center;margin:5px;float:left;

}

body{

font-family: \'Helvetica Neue\';

}

.borderless td, .borderless th {

border: none;

}

#map_wrapper {

height: 400px;

}

#map_canvas {

width: 90%;

height: 100%;

}

th{ font-size:12px; height:30px;}

td{ font-size:12px; height:30px;}

#comps{ }

#comps td{ font-size:12px; height:30px; }

#ucomps{ }

#ucomps td{ font-size:12px; height:30px; }

.headAddress { font-family: \'Helvetica Neue\'; font-size:16px; }

.headAdd { font-family: \'Helvetica Neue\'; font-size:14px; }

#graph td{ height:5px;}

</style>

<form action="convert2.php" method="post" id="conv" name="conv">

<div id="content">

<div id="aclogo"></div>

<div class="row" id="repAddress">

<div class="col-sm-7" >

<span style="font-size:12px; font-weight:bold; color:#6a6a6a;" class="headAddress">'.$address.'</span>

<span style="font-size:12px; color:#6a6a6a;" class="headAdd"><br/>

'.$bedrooms.' Bd | '.$bathrooms.' Ba | '.$square_footage.' Sq Ft<br/>

'. $stories.' Stories | Lot Size '.$lot_size.'<br/>

'. 'Pool '.$pool.' | Basement '.$basement.'<br/>

Built '.$year_built.'

</span>

</div>

<div id="repBy" class="col-sm-5" >

<span style="font-size:12px; font-weight:bold; color:#6a6a6a;" class="headAddress">Report Prepared By</span>

<span style="font-size:12px; color:#6a6a6a;"><br/>

'.$prepared_by['Name'].'<br/>

'.$prepared_by['Address'].'<br/>

<a href="">'.$prepared_by['UserName'].'</a>

</span>

</div>

</div>

<span id="repClose"></span>

<div class="row">

<div class="col-sm-6">

</div>

<div class="col-sm-6">

<span style="font-size:12px; font-weight:bold; color:#6a6a6a; padding-left:30px;"></span>

</div>

</div>

<br>

<div class="row">

<div class="col-sm-7">

<table id="graph">

<tr>

<td style="width:25px; height:5px;background-color:#A689B6;">&nbsp;</td><td>&nbsp;Subject Property&nbsp;</td>

<td style="width:25px; height:5px;background-color:#99BEFD;">&nbsp;</td><td>&nbsp;Potential Comparable Sales Used &nbsp;</td>

<td style="width:25px; height:5px;background-color:#F5635B;">&nbsp;</td><td>&nbsp;Potential Comparable Sales Not Used &nbsp;</td>

</tr></table>

<br/>

</div>

</div>

<div class="row">

<div class="col-sm-12" >

<table><tr><td style="width:40%;">

<div>

<span id="mp">

<img src="'.$id.'.jpg" width="400"/>

</div>

</td>

<td style="width:40%;" valign="top">

<h3>Final Search Parameters</h3>

<table>

<tr><td> Square Footage</td><td> +/- 10%</td></tr>

<tr><td>Radius</td><td> &lt; 1 Mile </td></tr>

<tr><td>Age</td><td>+/- 5 Years</td></tr>

<tr><td>Lot Size</td><td>+/- 100%</td></tr>

<tr><td>Stories</td><td>2</td></tr>

<tr><td> Date of Sale</td><td> &lt; 1 Year </td></tr>

</table>

</td></tr></table>

</div></div>

<div id="break"><br/><br/></div>';

if(count($comps)>0){

$html = $html.'<div class="row">

<div class="col-sm-12" >

<h3 style="">Potential Comparable Sales Used</span>

<table class="table table-striped" id="comps">

<thead>

<tr rowspan="2">

<th colspan="11" style="border:none;"></th>

<th colspan="2" style="border:none;">Public Record Match</th>

<th style="border:none;"></th>

</tr>

<tr>

<th>Address</th>

<th>Distance</th>

<th>Bd/Ba</th>

<th>SF</th>

<th>Yr</th>

<th>Lot</th>

<th>Stories</th>

<th>Pool</th>

<th>Bsmnt</th>

<th>Date Sold</th>

<th>Amount</th>

<th>Sales $</th>

<th>Sales Date</th>

<th>Concessions</th>

</tr>

</thead>

<tbody>

';

$odd=1;

foreach($comps as $key=>$detail){

if($odd%2==0){ $color= "#ffffff;";}else{ $color= "#f6f6f6;";}

$odd++;

$html = $html.'

<tr style="background:'.$color.'">

<td>'.$key.'. '.$detail['address'].'</td>

<td>'.$detail['distance'].'miles</td>

<td>'.$detail['bedsBaths'].'</td>

<td>'.$detail['sq_size'].' </td>

<td>'.$detail['year_built'].'</td>

<td>'.$detail['lot_size'].'</td>

<td>'.$detail['stories'].'</td>

<td>'.$detail['pool'].'</td>

<td>'.$detail['basement'].'</td>

<td>'.$detail['dateSold'].'</td>

<td>$'.$detail['amount'].'</td>

<td>'.$detail['dy'].'</td>

<td>'.$detail['ay'].'</td>

<td></td>

</tr>';

}

$html = $html.'

</tbody>

</table>

</div>

</div>';

}

$html = $html.'<div id="break"></div>';

if(count($not_comps)>0){

$html = $html.'

<div class="row">

<div class="col-sm-12" >

<h3>Potential Comparable Sales Not Used</h3>

<table class="table table-striped" id="ucomps">

<thead>

<tr rowspan="2">

<th colspan="11" style="border:none;"></th>

<th colspan="2" style="border:none;">Public Record Match</th>

<th style="border:none;"></th>

</tr>

<tr>

<th>Address</th>

<th>Distance</th>

<th>Bd/Ba</th>

<th>SF</th>

<th>Yr</th>

<th>Lot</th>

<th>Stories</th>

<th>Pool</th>

<th>Bsmnt</th>

<th>Date Sold</th>

<th>Amount</th>

<th>Sales $</th>

<th>Sales Date</th>

<th>Concessions</th>

</tr>

</thead>

<tbody>';

$odd=1;

foreach($not_comps as $key=>$detail){

if($download['results']['utilizes'][$key]=="No"){

$detail['reason'] = $download['results']['reasonRisk_'.$key.''];

$detail['note'] = $download['results']['noteRisk_'.$key.''];

}

if($detail['reason']==1){ $detail['reason'] = "Poor Condition of Subject/Good Condition of Comp"; } else{ $detail['reason']="None"; }

if($detail['note']==1){ $detail['note'] = "I didn't use this property because"; } else{ $detail['note']="None"; }

if($odd%2==0){ $color= "#ffffff;";}else{ $color= "#f6f6f6;";}

$odd++;

$html = $html.' <tr style="background:'.$color.'">

<td>'.$key.'. '.$detail['address'].'</td>

<td>'.$detail['distance'].' Miles</td>

<td>'.$detail['bedsBaths'].'</td>

<td>'.$detail['sq_size'].' sqft</td>

<td>'.$detail['year_built'].'</td>

<td>'.$detail['lot_size'].'</td>

<td>'.$detail['stories'].'</td>

<td>'.$detail['pool'].'</td>

<td>'.$detail['basement'].'</td>

<td>'.$detail['dateSold'].'</td>

<td>$'.$detail['amount'].'</td>

<td>'.$detail['dy'].'</td>

<td>'.$detail['ay'].'</td>

<td></td>

</tr>

<tr style="background:'.$color.'">

<td colspan="14" ><span style="color:red;">'.$detail['reason'].'</span> &nbsp;&nbsp; &nbsp; <span style="color:red;">Notes: '.$detail['note'].'</span></td>

</tr>';

}

$html = $html.'

</tbody>

</table>

</div>

</div>

</div>';

}

$html = $html.'

</form>';

include("dompdf/dompdf_config.inc.php");

$html = preg_replace("@id=\"aclogo\">.*?</div>@is", 'id="aclogo"><img src="css/images/main_logo.jpg" width="200" class="img-responsive" alt="Logo" id="main_logo" style="padding-left:0px;"></div>',$html);

$html = preg_replace("@id=\"ad1\s*class.*?\"\s*style.*?\"@is",'',$html);

$html = str_replace('style="padding:20px 80px 0px 30px;"',"",$html);

$html = preg_replace("@repAddress\">@is",'id="repAddress"><table style="width:100%;"><tr><td>',$html);

$html = preg_replace("@</div>\s*<div id=\"repBy\".*?>@is",'</div></td><td>',$html);

$html = preg_replace("@<span id=\"repClose\"></span>@","</td></tr></table>",$html);

$html = $html;

$dompdf = new DOMPDF();

$dompdf->set_base_path(realpath(APPLICATION_PATH . 'css/bootstrap.css'));

$dompdf->set_base_path(realpath(APPLICATION_PATH . 'css/bootstrap-theme.css'));

$dompdf->set_base_path(realpath(APPLICATION_PATH . 'css/style.css'));

$dompdf->load_html($html);

$dompdf->render();

$dompdf->stream("$id.pdf");

?>