<?php
include_once "lib/common.lib.php";
require_once "lib/main.php";
require_once "lib/dbmysql.class.php";

error_reporting(0);
date_default_timezone_set('America/Denver');

ini_set('max_execution_time', 30000);
$db = new DbMySQL("localhost", "corbizrealestate", "corbizrealestate", "WAotraUcM5M8aA");
if(!$db->connect()){
	header('HTTP/1.0 500 Internal Server Error');
	exit;
}
$base_ctext = "";
$objClient = new MongoClient("mongodb://dsh7.crimeaonline.net:27017");
$objDb = $objClient->selectDB('rrestated_production');
$objCollectionHouses = $objDb->selectCollection('houses');



$sql = "SELECT count(*) as houses_count FROM houses WHERE ID not in (select house_id from houses_spintext) and Ownership=1 and Status=1";
$houses_count = $db->select_row($sql);

echo "HOUSES for UPDATE:".$houses_count['houses_count']."\n";
$processing = 1000;

echo $iterations_number = ceil($houses_count['houses_count'] / $processing);
$i=0;

for ($iteration = 0; $iteration < $iterations_number; $iteration++) {
	$sql = "SELECT * FROM houses WHERE ID not in (select house_id from houses_spintext) and Ownership=1 and Status=1 order by ID desc LIMIT ".($iteration * $processing).",".$processing;
		
	$houses = $db->select($sql);
	foreach($houses as $key=>$house){
		//echo "<pre>";
		//print_r($house);
		//echo "</pre>";
		$house_mongo = $objCollectionHouses->findOne(array('_id' => new MongoId($house['ExternalID'])));
		//echo "<pre>";
		//print_r($house_mongo);
		//echo "</pre>";
		
		
		$sql = "select * from images where AssignID='".$house['ID']."' and Active = 1";
		$images = $db->select_row($sql);
		
		$sql = "select * from houses_types ht inner join types t on t.ID=ht.Type_ID where ht.House_ID='".$house['ID']."'";
		$houses_type = $db->select_row($sql);
		
	    if($house['Ownership']==1){
	    	$type = '{Residential property|Residential real estate}';
	    }else{
	    	$type = '{Commercial property|Commercial real estate}';
	    }
	    if($house['Status']==1){
	    	$house['market_status'] = "For Sale";
	    }else{
	    	$house['market_status'] = "For Rent";
	    }
	    if($house['Status']==2&&$house['Ownership']==2){
	    	$house['market_status'] = "For Lease";
	    }
	    $agent_info = unserialize($house['AgentsInfo']);
	    //print_r($agent_info);
	    if($house['Price']){
		$base_text = "<h3 id=\"listing-title2\">{Realty Listing|Listing|Real Estate Listing|".$houses_type['Name']." ".$houses_type['details']."|Property listing} in ".$house['City']." on ".$house['Address']." {facts|info|description|details|data|review}</h3>
		<p>{Real estate listing|Property|Listing|".$houses_type['Name']." ".$houses_type['details']."} was {recorded|added|listed|placed|proposed} ".$house['market_status']." on www.corbizrealestate.com {from|at} {".date_format(date_create($house['DateAdded']), 'm/d/Y')."|".date_format(date_create($house['DateAdded']), 'M d/Y H:i:s')."}.";
		$base_text .= " {This|Current|Selected} ".$houses_type['Name']." ".$houses_type['details']." listing was updated on the {site|web site} on {".date_format(date_create($house['DateUpdated']), 'M d/Y H:i:s')."|".date_format(date_create($house['DateUpdated']), 'D M d/Y H:i:s')."}.
		The status of the {listing|".$houses_type['Name']." ".$houses_type['details']."} is ".$house['market_status']." that {allows of|means that} any {prospective|future|expected} {clients|customers|buyers|consumers} can {send inquiry|ask} about this {property|listing}. 
		The {value|cost|price} of the {property|".$houses_type['details']."|listing} is $".$house['Price'].".";
		if(count($images)==0){
			$base_text .=" This {listing|property|".$houses_type['Name']." ".$houses_type['details']."|realty} doesn't {contains|haves|includes} {pictures|images|pics|photos} assigned to it. ";
		}
		if(count($images)==1){
			$base_text .=" This {listing|property|house|home|realty} {contains| haves|includes} a one {picture|image|pic|photo} assigned to it {and} for {additional|extra|fresh|more|new|other} {pictures|images|pics|photos} you can email or {call|telephone} listing {agent|owner}. ";
		}
		if(count($images)>1){
			$base_text .=" Current {listing|property|house|home|realty} {contains|haves|includes} ".count($images)." {pictures|images|pics|photos} assigned to it {and} for {additional|extra|fresh|more|new|other} {pictures|images|pics|photos} you can email or {call|telephone} listing {agent|owner}. ";
		}
		$base_text .="</p>";
	    }
		$base_text .="<h4>{Property|Listing|Realty|Listing|".$houses_type['Name']." ".$houses_type['details']."} {Geographic Location|Geo Location|Placement}</h4> ";
		$base_text .="<p>The {property|realty|listing|".$houses_type['Name']." ".$houses_type['details']."} {address|location|placement} are: <strong>".$house['Address'].", ".$house['City'].", ".$house['State']." ".$house['Zip'].".</strong>
		You can {check|review|see} {Google StreetView and Map|StreetView or Map|Map above|StreetView and Google Map|StreetView above} to get {More|Full|Complete} {info|details|facts|information} about ".$houses_type['Name']." ".$houses_type['details']." {Geographic Location|Geo Location|Placement}.</p> ";
		
		
		if($house['YearBuilt']){
			$base_text .="<h4>{Historical|built in} {facts|data|details|info|information}</h4> ";
			$base_text .="<p>The  {property|listing|<strong>".$houses_type['Name']." ".$houses_type['details']."</strong>|".$houses_type['Name']." ".$houses_type['details']."} was built {way back|} in ".$house['YearBuilt'].".</p> "; 
		}
        
		$base_rtext =" ";
		if($house['Beds']||$house['Baths']||$house['Rooms']){
		    
			$base_text .="<h4>{Number|Amount|Quantity} of rooms and Living area {information|info|details}</h4> ";
			$base_text .="<p>";
		
			if($house['Rooms']){
				$base_rtext .="The {home|house} {provides|gives|contains from} {".convertNumber($house['Rooms'])."|".$house['Rooms']."} {large|big|commodious|great} and  spacious rooms for the {byers|clients|customers}. ";
			}
			if(!$house['Beds']){
				$base_rtext = "This {".$houses_type['Name']." ".$houses_type['details']."|property|realty} unit {comes|gets|includes|provides} with {".$house['Baths']."|".convertNumber($house['Baths'])."} {bathrooms|toilets}. ";
			}
			if(!$house['Baths']){
				$base_rtext = "This {".$houses_type['Name']." ".$houses_type['details']."|property|realty} unit {comes|gets|includes|provides} with {".$house['Beds']."|".convertNumber($house['Beds'])."}  {bedrooms|beds}. ";
			}
			if($house['Beds']&&$house['Baths']){
				$base_rtext = "This {".$houses_type['Name']." ".$houses_type['details']."|property|realty} unit {comes|gets|includes|provides} with {".$house['Beds']."|".convertNumber($house['Beds'])."}  bedrooms {and|plus} {".$house['Baths']."|".convertNumber($house['Baths'])."} {bathrooms|toilets}. "; 
			}
		}
		$base_text = $base_text.$base_rtext;
		
		if($house['BuildingSize']&&$house['BuildingSize']!=0){
			$base_text .="The total {square foot|sqft|SF|sf|sq/ft} area of the {property|realty|listing} is ".$house['BuildingSize'].". ";
		}
		if($house['LivingArea']&&$house['LivingArea']!=0){
			$base_text .="The {square foot|sqft|SF|sf|sq/ft} of living area is ".$house['LivingArea'].". ";
		}
		if($house['ParkingAvailable']){
			$base_text .="The {property|listing|".$houses_type['Name']." ".$houses_type['details']."} {provides|gives} ".$house['ParkingAvailable']." parking service with ".convertNumber($house['ParkingSpaces'])." {space|room|area}  for parking  {cars|vehicles|autos}. ";
		}
		if($house['Garage']){
			$base_text .="The {property|listing|".$houses_type['Name']." ".$houses_type['details']."} {includes|provides|gives} Garage space: ".$house['Garage'].". ";
		}
		$base_text .="</p>";
		$base_ctext = "";
		$base_text .="<h4>{Agent|Realtor|Real estate agent|Property agent} contact {information|info|details}</h4>";
		$base_text .='<p class="agent_info">';
		if($house['Contact']){
			$base_ctext =" If you {are interested in following up|want to follow up} more on this {listing|property|house|home|realty|family unit}, you can {contact|get in touch|meet|communicate} the {broker|agent|realtor|real estate agent} by the following contact phone number: ".$house['Contact'].". ";
		}
		if(isset($agent_info[0])){
			if(($agent_info[0]&&$agent_info[0]['Name'])&&($agent_info[0]['CompanyName']||$house['Contact']||$agent_info[0]['Phone']||$agent_info[0]['Email'])){
				$base_ctext ="If you {are interested in following up|want to follow up|know} more on this {listing|property|house|home|realty|family unit}, you can {contact|get in touch|meet|communicate} with ".$agent_info[0]['Name']." by the following contact info: ".$agent_info[0]['Phone']." ".$agent_info[0]['CompanyName'].". ";
			}
		}
		$base_text .=" You will surely {find|discover} the all your {queries|questions} are answered by  {broker|agent|realtor|real estate agent} {and|plus} they will {assist|help|collaborate} you in {inspecting|reviewing} the {property|home|house|estate|asset|realty|listing} as well as closing the deal if you {wish|want|desire} to proceed.";
		
		$base_text = $base_text." ".$base_ctext."</p>";
		
		$spin_text = spin($base_text);
		$sql = "insert ignore into houses_spintext set house_id='".$house['ID']."', spin_text='".mysql_escape_string($spin_text)."'";
		echo "insert spin for house:".$house['ID']."\n";
		$db->query($sql);
	}
	
}


?>