0) {
$wp_aem_properties_ids = $wpdb->get_results("SELECT * FROM ".AEM_PLUGIN_DB_Table." WHERE id = '".$_GET['id']."' LIMIT 1", ARRAY_A);
if(count($wp_aem_properties_ids) > 0) {
$wp_aem_properties_id = $wp_aem_properties_ids[0]['id'];
}
}
/**
* ----------------------------------------------------------------------------------------------------------------------
* Process >> Add Property
* ----------------------------------------------------------------------------------------------------------------------
*/
if($_POST['action'] == 'update' && $_POST['wp_aem_properties_id'] > 0 || isset($_POST['submit_add_photos'])) {
$error = 0;
if(!isset($_POST['Listing']['MLS']['value']) || empty($_POST['Listing']['MLS']['value']) || $_POST['Listing']['MLS']['value'] <= 0) {
//$error++;
}
if(!isset($_POST['Listing']['Address']['value']) || empty($_POST['Listing']['Address']['value'])) {
$error++;
}
// check if no duplicate on the database
$add_mlsid_listings = $wpdb->get_results("SELECT * FROM ".AEM_PLUGIN_DB_Table." WHERE id != '".$_POST['wp_aem_properties_id']."' AND MLS = '".$_POST['Listing']['MLS']['value']."' AND address = '".$_POST['Listing']['Address']['value']."' LIMIT 1", ARRAY_A);
if(count($add_mlsid_listings) > 0) { $error++; }
//echo ''; print_r($add_mlsid_listings); echo '
'; exit();
if($error == 0) {
// set & clean the POST_Listing details
$_POST_Listing = $_POST['Listing'];
$_POST_Listing['MLS']['value'] = stripslashes($_POST['Listing']['MLS']['value']);
$_POST_Listing['Title']['value'] = stripslashes($_POST['Listing']['Title']['value']);
$_POST_Listing['Address']['value'] = stripslashes($_POST['Listing']['Address']['value']);
$_POST_Listing['Bedrooms']['value'] = stripslashes($_POST['Listing']['Bedrooms']['value']);
$_POST_Listing['Bathrooms']['value'] = stripslashes($_POST['Listing']['Bathrooms']['value']);
$_POST_Listing['PropertyType']['value'] = stripslashes($_POST['Listing']['PropertyType']['value']);
$_POST_Listing['Neighborhood']['value'] = stripslashes($_POST['Listing']['Neighborhood']['value']);
$_POST_Listing['Description']['value'] = stripslashes($_POST['content']);
$_POST_Listing['ListingPrice']['value'] = stripslashes($_POST['Listing']['ListingPrice']['value']);
$_POST_Listing['SellingPrice']['value'] = stripslashes($_POST['Listing']['SellingPrice']['value']);
$_POST_Listing['SoldDate']['value'] = stripslashes($_POST['Listing']['SoldDate']['value']);
$_POST_Listing['ListingAgent']['value'] = stripslashes($_POST['Listing']['ListingAgent']['value']);
$_POST_Listing['ListingOffice']['value'] = stripslashes($_POST['Listing']['ListingOffice']['value']);
$_POST_Listing['Status']['value'] = stripslashes($_POST['Listing']['Status']['value']);
$_POST_Listing['PrimaryDetails']['CrossStreet']['value'] = stripslashes($_POST['Listing']['PrimaryDetails']['CrossStreet']['value']);
$_POST_Listing['PrimaryDetails']['ApproximateSqFt']['value'] = stripslashes($_POST['Listing']['PrimaryDetails']['ApproximateSqFt']['value']);
$_POST_Listing['PrimaryDetails']['PricePerSqFt']['value'] = stripslashes($_POST['Listing']['PrimaryDetails']['PricePerSqFt']['value']);
$_POST_Listing['PrimaryDetails']['YearBuilt']['value'] = stripslashes($_POST['Listing']['PrimaryDetails']['YearBuilt']['value']);
$_POST_Listing['PrimaryDetails']['TotalRooms']['value'] = stripslashes($_POST['Listing']['PrimaryDetails']['TotalRooms']['value']);
$_POST_Listing['PrimaryDetails']['HOADues']['value'] = stripslashes($_POST['Listing']['PrimaryDetails']['HOADues']['value']);
$_POST_Listing['AdditionalDetails']['Parking']['value'] = stripslashes($_POST['Listing']['AdditionalDetails']['Parking']['value']);
$_POST_Listing['AdditionalDetails']['Type']['value'] = stripslashes($_POST['Listing']['AdditionalDetails']['Type']['value']);
$_POST_Listing['AdditionalDetails']['Style']['value'] = stripslashes($_POST['Listing']['AdditionalDetails']['Style']['value']);
$_POST_Listing['AdditionalDetails']['Floors']['value'] = stripslashes($_POST['Listing']['AdditionalDetails']['Floors']['value']);
$_POST_Listing['AdditionalDetails']['BathTypeIncludes']['value'] = stripslashes($_POST['Listing']['AdditionalDetails']['BathTypeIncludes']['value']);
$_POST_Listing['AdditionalDetails']['Kitchen']['value'] = stripslashes($_POST['Listing']['AdditionalDetails']['Kitchen']['value']);
$_POST_Listing['AdditionalDetails']['DiningRoom']['value'] = stripslashes($_POST['Listing']['AdditionalDetails']['DiningRoom']['value']);
$_POST_Listing['AdditionalDetails']['LivingRoom']['value'] = stripslashes($_POST['Listing']['AdditionalDetails']['LivingRoom']['value']);
$_POST_Listing['AdditionalDetails']['HeatingCoolingSystem']['value']= stripslashes($_POST['Listing']['AdditionalDetails']['HeatingCoolingSystem']['value']);
$_POST_Listing['AdditionalDetails']['LaundryAppliances']['value'] = stripslashes($_POST['Listing']['AdditionalDetails']['LaundryAppliances']['value']);
$_POST_Listing['AdditionalDetails']['SpecialFeatures']['value'] = stripslashes($_POST['Listing']['AdditionalDetails']['SpecialFeatures']['value']);
$_POST_Listing['AdditionalDetails']['CommonAreas']['value'] = stripslashes($_POST['Listing']['AdditionalDetails']['CommonAreas']['value']);
$_POST_Listing['AdditionalDetails']['Transportation']['value'] = stripslashes($_POST['Listing']['AdditionalDetails']['Transportation']['value']);
$_POST_Listing['AdditionalDetails']['Shopping']['value'] = stripslashes($_POST['Listing']['AdditionalDetails']['Shopping']['value']);
$_POST_Listing['Comment']['value'] = stripslashes($_POST['Listing']['Comment']['value']);
#echo ''; print_r($_POST_Listing); echo '
'; exit(); // for testing only
$removePhotos = $_POST['removedPhoto'];
$_POST_Listing['Photos']['Photo'] = array();
if(count($_POST['Listing']['Photos']['Photo']) > 0) {
foreach($_POST['Listing']['Photos']['Photo'] as $listing_photos_key => $listing_photos_val) {
#echo "
listing_photos_key: $listing_photos_key = ".$_POST['removedPhoto'][$listing_photos_key];
if(isset($_POST['removedPhoto'][$listing_photos_key])) {
// don't add photo
} else {
$_POST['Listing']['Photos']['Photo'][$listing_photos_key]['ThumbnailURL'] = $_POST['Listing']['Photos']['Photo'][$listing_photos_key]['URL'];
$_POST_Listing['Photos']['Photo'][] = $_POST['Listing']['Photos']['Photo'][$listing_photos_key];
}
}
}
if(count($_POST['images']) > 0) {
foreach($_POST['images'] as $image_url) {
if($image_url!= "") {
$_POST_Listing['Photos']['Photo'][] = array('URL' => array('value' => $image_url), 'ThumbnailURL' => array('value' => $image_url));;
}
}
}
#echo ""; print_r($_POST_Listing); echo "
"; exit();
$POST_Listing = base64_encode(serialize($_POST_Listing));
if($POST_Listing == '') { $error++; }
if($error == 0) {
$sql = "UPDATE ".AEM_PLUGIN_DB_Table." SET
MLS = '".aem_clean($_POST['Listing']['MLS']['value'])."',
Title = '".aem_clean($_POST['Listing']['Title']['value'])."',
URL = '".aem_clean($_POST['Listing']['URL']['value'])."',
DefaultImageURL = '".aem_clean($_POST['Listing']['Photos']['Photo'][$_POST['DefaultImage']]['URL']['value'])."',
DefaultThumbnailURL = '".aem_clean($_POST['Listing']['Photos']['Photo'][$_POST['DefaultImage']]['ThumbnailURL']['value'])."',
PropertyType = '".aem_clean($_POST['Listing']['PropertyType']['value'])."',
Address = '".aem_clean($_POST['Listing']['Address']['value'])."',
Bedrooms = '".aem_clean($_POST['Listing']['Bedrooms']['value'])."',
Bathrooms = '".aem_clean($_POST['Listing']['Bathrooms']['value'])."',
ListingPrice = '".aem_clean($_POST['Listing']['ListingPrice']['value'])."',
ListingDate = '".aem_clean($_POST['Listing']['ListingDate']['value'])."',
SellingPrice = '".aem_clean($_POST['Listing']['SellingPrice']['value'])."',
SoldDate = '".aem_clean($_POST['Listing']['SoldDate']['value'])."',
Status = '".aem_clean($_POST['Listing']['Status']['value'])."',
Description = '".aem_clean($_POST['content'])."',
ListingAgent = '".aem_clean($_POST['Listing']['ListingAgent']['value'])."',
ListingOffice = '".aem_clean($_POST['Listing']['ListingOffice']['value'])."',
Represented = '".aem_clean($_POST['Listing']['Represented']['value'])."',
Comment = '".aem_clean($_POST['Listing']['Comment']['value'])."',
full_property_details = '".$POST_Listing."',
date_updated = CURDATE()
WHERE id = '".aem_clean($_POST['wp_aem_properties_id'])."'
LIMIT 1";
$update = $wpdb->query($sql);
#echo ''; print_r($_POST_Listing); echo '
';
#echo '
SQL: '.$sql.'
';
//exit();
echo '';
echo 'Property Successfully Updated.';
echo '
';
echo 'Failed Updating Property.';
echo '
';
echo 'Failed Updating Property.';
echo '
"; print_r($mlsid_listings); echo "";
$mlsid_listing_db = unserialize(base64_decode($mlsid_listings[0]['full_property_details']));
$MLSID = $mlsid_listings[0]['MLS'];
$mlsid_listing = unserialize(base64_decode($mlsid_listings[0]['full_property_details']));
#echo ""; print_r($mlsid_listing); echo "
";
}
if(isset($_POST['submit_get_mlsid_details']) && $_POST['MLSID'] > 0) {
// set & parse the xml
$xml_query_url = "property?mlsid=".$_POST['MLSID'];
$xml_url = $wp_plugin_aem_params['plugin_aem_option_xml_parser'].urlencode($xml_query_url.'&apikey='.$wp_plugin_aem_params['plugin_aem_option_api_key']);
// open the xml url
if ($f = @fopen($xml_url, 'r')) {
$xml = '';
while (!feof($f)) {
$xml .= fgets($f, 4096);
}
fclose($f);
$arr = xml2array($xml);
//print_r($arr);
if (sizeof($arr) == 1 && $arr["Listing"]){
if (array_key_exists("MLS", $arr["Listing"])) {
$mlsid_listing = $arr["Listing"];
} else {
$mlsid_listing = $arr["Listing"];
}
#echo ""; print_r($mlsid_listing); echo "
";
echo '';
echo 'Property details successfully retrieved. Click the \'Update\' button to save & update the property details.';
echo '
';
echo 'Failed retrieving property details. MLSID doesn\'t exists';
echo '
Property Not Found.