function mls_setshortname($shortname)
{
global $mls_shortname;
$mls_shortname = $shortname;
}
function mls_getshortname()
{
global $mls_shortname;
return $mls_shortname;
}
function mls_hasshortname()
{
$sname = mls_getshortname();
return (is_string($sname) && trim($sname) != '');
}
function get_mlsvar($variable='')
{
return mls_getvariable($variable);
}
function mls_getvariable($variable='')
{
$variables[images_limit]=10;
$variables['GAMLS-SFD'][images_limit] = 5;
$variables['GAMLS-SFA'][images_limit] = 5;
if(!$variable)
return $variables;
if(!$variables[$variable])
ddie("Invalid call to get_mlsvar($variable), invalid key:$variable");
$shortname = mls_getshortname();
if(isset($variables[$shortname][$variable])) //override with the specific setting for each MLS
$variables[$variable] = $variables[$shortname][$variable];
foreach($variables as $k=>$v) //any of the variables retrieved from here can be overridden in the query string
if(isset($_GET[$k]))
$variables[$k] = $_GET[$k];
if("".$variables[$variable].""==="")
ddie("Invalid get_mlsvar($variable), may not return '' ");
return $variables[$variable];
}
function mls_getquerydata()
{
global $mls_shortname;
if ($mls_shortname == 'GLVAR')
{
$querydata = array
(
'extidkey' => 'sysid',
'propidkey' => 'sysid',
'statuskey' => '242',
'propclass' => '1',
'maxupdate' => '3000', //the max number of properties to check for removal
'propquery' => array
(
'Date' => "(135=SINCEDATE+)",
'BeforeDate' => "(135=BEFOREDATE-)",
'ListingStatus' => '(242=|EA,ER,AU)',
'Property Subtype' => '(2452=|SFR)',
'ListPrice' => '(144=50000+)',
'Zip' => "(10=ZIPLIST)",
),
'officekey' => '1652',
'propexid_notlike' => 'man_nv%', //skip any external ids that look like this
);
if(false)
{
//hack to force return of only one MLS number without any other criteria for testing
//http://dev.rio.matraex.com/schedule/availableproperties_import.php?test3=1&runmls=1831&skip_imgdnl=1
//unset($querydata[propquery] );
/// unset($querydata[propquery]['Date']);
$querydata[propquery][listingid] = "(163=1356761)";
}
if(false)
{
//another hcack trying to find a property
//http://dev.rio.matraex.com/schedule/availableproperties_import.php?test3=1&runmls=1831&skip_imgdnl=1
unset($querydata[propquery] );
$querydata[propquery][price] = "(144=180000+)";
$querydata[propquery][price2] = "(144=190000-)";
}
if(false)
{
//another hcack trying to find a property
//http://dev.rio.matraex.com/schedule/availableproperties_import.php?test3=1&runmls=1831&skip_imgdnl=1
unset($querydata[propquery] );
$querydata[propquery][price] = "(2953=1896)";
//$querydata[propquery][price2] = "(144=190000-)";
}
}
else if ($mls_shortname == 'NEFMLS')
{
$querydata = array
(
'extidkey' => 'listid',
'propidkey' => 'LIST_1',
'statuskey' => 'LIST_15',
'propclass' => 'A',
'propquery' => array
(
'Date' => "(LIST_16=SINCEDATE+)",
'BeforeDate' => "(LIST_16=BEFOREDATE-)",
'ListingStatus' => '(LIST_15=B70IQH1IDA9)',
'Zip' => "(LIST_43=ZIPLIST)",
),
);
}
else if ($mls_shortname == 'MAAR')
{
$querydata = array
(
'extidkey' => 'mls#',
'propidkey' => 'L_ListingID',
'statuskey' => 'L_Status',
'propclass' => 'RE_1',
'propquery' => array
(
'ListingStatus' => '(L_Status=|1_0)',
'Date' => "(L_ListingDate=SINCEDATE+)",
'BeforeDate' => "(L_ListingDate=BEFOREDATE-)",
'Zip' => "(L_Zip=ZIPLIST)",
),
'headerinfo' => array
(
"RETS-Version" => "RETS/1.7.2",
'User-Agent' => 'RIOGenesisRETS/1.0',
),
);
}
else if ($mls_shortname == 'OLD_MAAR') //switched to new 4/18/2014
{
$querydata = array
(
'extidkey' => 'sysid',
'propidkey' => 'sysid',
'propclass' => '2',
'statuskey' => '45',
'propquery' => array
(
'Date' => "(41=SINCEDATE+)",
'BeforeDate' => "(41=BEFOREDATE-)",
'ListingStatus' => '(45=|ACT)',
'YearBuilt' => '(102=1900+)',
'PriceRange' => '(43=1+)',
'Zip' => "(103=ZIPLIST)",
),
'headerinfo' => array
(
"RETS-Version" => "RETS/1.7.2",
'User-Agent' => 'RIOGenesisRETS/1.0',
),
);
}
else if ($mls_shortname == 'BAKMLS')
{
$querydata = array
(
'extidkey' => 'listingrid',
'propidkey' => 'ListingRid',
'statuskey' => 'status',
'propclass' => 'RESI',
'propquery' => array
(
'ListingStatus' => '(Status=|A)',
'Date' => "(ListingDate=SINCEDATE+)",
'BeforeDate' => "(ListingDate=BEFOREDATE-)",
'Zip' => "(ZipCode=ZIPLIST)",
),
'headerinfo' => array
(
"RETS-Version" => "RETS/1.7.2",
'User-Agent' => 'RIOGenesisRETS',
),
);
}
else if ($mls_shortname == 'GNWR')
{
$querydata = array
(
'extidkey' => 'ml#',
'propidkey' => 'MLSNUM',
'statuskey' => 'status',
'propclass' => 'RES',
'usepost' => true,
//'skiphours' => '23,0', //skip 11pm and 12am hours for updates
'maxupdate' => '3000', //the max number of properties to check for removal
'propquery' => array
(
'ListingStatus' => '(LISTSTATUS=|ACT)',
'Date' => '(LISTDATE=SINCEDATE+)',
'BeforeDate' => "(LISTDATE=BEFOREDATE-)",
'Zip' => "(ZIPCODE=ZIPLIST)",
),
'imagetype' => 'PROPERTY',
'imageclass' => 'Photo',
'imageidkey' => 'MLSNUM',
'imagequery' => array
(
'PropID' => '(UID=PROPIDS)',
'Date' => '(MODIFIED=SINCEDATE+)',
'BeforeDate' => "(MODIFIED=BEFOREDATE-)",
),
'imagehandler' => 'tx_imagedownload',
'imagelocation' => 1,
'headerinfo' => array
(
'User-Agent' => 'RIOGenesisRETS',
"RETS-Version" => "RETS/1.7.2",
),
);
}
else if ($mls_shortname == 'GAMLS-SFD')
{
$querydata = array
(
'extidkey' => 'reinsightkey',
'propidkey' => 'REInsightKey',
'statuskey' => 'STAT',
'propclass' => 'SFD',
'maxupdate' => '6000',
'propquery' => array
(
'ListingStatus' => '(STAT=|A,N)',
'Date' => '(RECMODDATE=SINCEDATE+)',
'BeforeDate' => "(RECMODDATE=BEFOREDATE-)",
'Zip' => '(ZIP=ZIPLIST)',
),
'headerinfo' => array
(
'User-Agent' => 'RIOGenesisRETS',
),
);
}
else if ($mls_shortname == 'GAMLS-SFA')
{
$querydata = array
(
'extidkey' => 'reinsightkey',
'propidkey' => 'REInsightKey',
'statuskey' => 'STAT',
'propclass' => 'SFA',
'maxupdate' => '6000',
'propquery' => array
(
'ListingStatus' => '(MC=|A)',
'Date' => '(RECMODDATE=SINCEDATE+)',
'BeforeDate' => "(RECMODDATE=BEFOREDATE-)",
'Zip' => '(ZIP=ZIPLIST)',
),
'headerinfo' => array
(
'User-Agent' => 'RIOGenesisRETS',
),
);
}
else if ($mls_shortname == 'SWFLAMLS')
{
$querydata = array
(
'extidkey' => 'matrixuniqueid',
'propidkey' => 'matrix_unique_id',
'statuskey' => 'Status',
'propclass' => 'RES',
'propquery' => array
(
'ListingStatus' => '(Status=|A)',
'Date' => '(CreatedDate=SINCEDATE+)',
'BeforeDate' => "(CreatedDate=BEFOREDATE-)",
'Zip' => '(PostalCode=ZIPLIST)',
'YearBuilt' => '(YearBuilt=1990+)',
'ResidenceType' => '(OwnershipDesc=SINFAM)',
),
'headerinfo' => array
(
'User-Agent' => 'RIOGenesisRETS',
),
);
}
else if ($mls_shortname == 'RMLS')
{
$querydata = array
(
'extidkey' => 'listingid',
'propidkey' => 'ListingID',
'statuskey' => 'RetsStatus',
'propclass' => 'Residential',
'propquery' => array
(
'ListingStatus' => '(RetsStatus=|Active)',
'Date' => '(DateList=SINCEDATE+)',
//'Zip' => '(ZipCode=ZIPLIST)',
),
'headerinfo' => array
(
'User-Agent' => 'RIOGenesisRETS',
),
);
}
else if ($mls_shortname == 'GFLR')
{
$querydata = array
(
'extidkey' => 'sysid',
'propidkey' => 'sysid',
'statuskey' => '246',
'propclass' => '1',
'propquery' => array
(
'ListingStatus' => '(246=A)',
'County' => '(61=|BROWARD,DADE,OTHER,PALMBCH)', //the only four counties offered at the time, may want to double check to see if there are more added from tiem to tiem
//'YearBuilt' => '(314=1990+)',
//'BedMin' => '(25=3+)',
//'BedMax' => '(25=4-)',
//'PriceMin' => '(137=125000+)',
//'PriceMax' => '(137=325000-)',
'Date' => '(135=SINCEDATE+)',
'Zip' => '(10=ZIPLIST)',
//'BeforeDate' => "",
),
'headerinfo' => array
(
'User-Agent' => 'chWaRiS',
'User-Agent-Password' => 'fard8942',
"RETS-Version" => "RETS/1.7.2",
),
);
}
else if ($mls_shortname == 'ARMLS')
{
$querydata = array
(
'extidkey' => 'listid',
'propidkey' => 'LIST_1',
'statuskey' => 'LIST_15',
'propclass' => 'A',
'propquery' => array
(
'ListingStatus' => '(LIST_15=OV61GOJ13C0)',
'Date' => '(LIST_87=SINCEDATE+)',
'BeforeDate' => '(LIST_87=BEFOREDATE-)',
'Zip' => '(LIST_43=ZIPLIST)',
),
'headerinfo' => array
(
'User-Agent' => 'RIOGenesisRETS',
),
'preprocessfunc' => array
(
'staffidxmlszipcodelist' => 'mls_remapzipcodes',
),
);
}
else if ($mls_shortname == 'NTREIS')
{
$querydata = array
(
'extidkey' => 'matrixuniqueid',
'propidkey' => 'Matrix_Unique_ID',
'statuskey' => 'Status',
'propclass' => 'Listing',
'idxmlsurl' => 'http://matrixrets.ntreis.net/rets/login.ashx',
'propquery' => array
(
'ListingStatus' => '(Status=A)',
'Date' => '(MatrixModifiedDT=SINCEDATE+)',
'BeforeDate' => '(MatrixModifiedDT=BEFOREDATE-)',
'Zip' => '(PostalCode=ZIPLIST)',
'PropertyType' => '(PropertyType=RES)',
),
'headerinfo' => array
(
'User-Agent' => 'RIOGenesisRETS',
),
);
}
else if ($mls_shortname == 'OLD_NTREIS')
{
$querydata = array
(
'extidkey' => 'mls#',
'propidkey' => 'MLSNUM',
'statuskey' => 'LISTSTATUS',
'propclass' => 'RES',
'propquery' => array
(
'ListingStatus' => '(LISTSTATUS=ACT)',
'Date' => '(MODIFIED=SINCEDATE+)',
'BeforeDate' => '(MODIFIED=BEFOREDATE-)',
'Zip' => '(ZIPCODE=ZIPLIST)',
),
'headerinfo' => array
(
'User-Agent' => 'RIOGenesisRETS',
),
);
}
else if ($mls_shortname == 'DAYMLS')
{
$querydata = array
(
'extidkey' => 'listingid',
'propidkey' => 'ListingID',
'statuskey' => 'ListingStatus',
'propclass' => 'ResidentialProperty',
'propquery' => array
(
'ListingStatus' => '(ListingStatus=A)',
'Date' => '(ModificationTimestamp=SINCEDATE+)',
'BeforeDate' => '(ModificationTimestamp=BEFOREDATE-)',
'Zip' => '(PostalCode=ZIPLIST)',
),
'headerinfo' => array
(
'User-Agent' => 'RIOGenesisRETS',
),
);
}
else if ($mls_shortname == 'MIBOR')
{
$querydata = array
(
'propclass' => 'Listing',
'statuskey' => 'A',
'propidkey' => 'matrix_unique_id',
'extidkey' => 'matrix_unique_id',
'propquery' => array
(
'ListingPrice' => '(ListPrice=1+)',
'ListingStatus' => '(Status=A)',
'PropertyType' => '(PropertyType=RES)',
'TransactionType' => '(TransType=SALE)',
'Date' => '(ListingContractDate=SINCEDATE+)',
'BeforeDate' => '(ListingContractDate=BEFOREDATE-)',
'Zip' => '(ZipCode=ZIPLIST)',
),
'headerinfo' => array
(
'User-Agent' => 'RIOGenesisRETS',
),
);
}
else if ($mls_shortname == 'OLD_MIBOR')
{
$querydata = array
(
'propclass' => '2',
'statuskey' => '134',
'propidkey' => 'sysid',
'extidkey' => 'sysid',
'propquery' => array
(
'ListingPrice' => '(131=1+)',
'ListingStatus' => '(134=ACT)',
'Date' => '(123=SINCEDATE+)',
'BeforeDate' => '(123=BEFOREDATE-)',
'Zip' => '(312=ZIPLIST)',
),
'headerinfo' => array
(
'User-Agent' => 'RIOGenesisRETS',
),
);
}
else if ($mls_shortname == 'MFRMLS')
{
$querydata = array
(
'propclass' => 'Listing',
'statuskey' => 'Status',
'propidkey' => 'Matrix_Unique_ID',
'extidkey' => 'matrixuniqueid',
'idxmlsurl' => 'http://rets.mfrmls.com/contact/rets/login',
'usepost' => true,
'propquery' => array
(
'ListingStatus' => '(Status=|ACT)',
'PropertyType' => '(PropertyType=|RES)',
'ListingPrice' => '(ListPrice=1+)',
'Date' => '(StatusChangeTimestamp=SINCEDATE+)',
'BeforeDate' => '(StatusChangeTimestamp=BEFOREDATE-)',
'Zip' => '(PostalCode=ZIPLIST)',
),
'headerinfo' => array
(
'User-Agent' => 'RIOGenesisRETS/1.0',
),
);
}
else if ($mls_shortname == 'OLD_MFRMLS')
{
$querydata = array
(
'propclass' => '4',
'statuskey' => '178',
'extidkey' => 'sysid',
'propidkey' => 'sysid',
'propquery' => array
(
'ListingPrice' => '(176=1+)',
'ListingStatus' => '(178=ACT)',
'Date' => '(108=SINCEDATE+)',
'BeforeDate' => '(108=BEFOREDATE-)',
'Zip' => '(46=ZIPLIST)',
),
'headerinfo' => array
(
'User-Agent' => 'RIOGenesisRETS/1.0',
),
);
}
else if ($mls_shortname == 'FMLS')
{
$querydata = array
(
'propclass' => 'RES',
'statuskey' => 'STATUS',
'extidkey' => 'sysid',
'propidkey' => 'sysid',
'propquery' => array
(
'ListingPrice' => '(LISTPRICE=1+)',
'ListingStatus' => '(STATUS=ACT)',
'Date' => '(STATUSCHANGEDATE=SINCEDATE+)',
'BeforeDate' => '(STATUSCHANGEDATE=BEFOREDATE-)',
'Zip' => '(ZIPCODE=ZIPLIST)',
),
'headerinfo' => array
(
'User-Agent' => 'RioGenesis/1.0',
),
);
}
else if ($mls_shortname == 'NWMLS')
{
$querydata = array
(
'custom_getproperties' => 'mls_getproperties_nwmls',
'custom_getimages' => 'mls_getimages_nwmls',
'custom_getoffices' => 'mls_getoffices_nwmls',
'custom_getpropertystatus' => 'mls_getpropertystatus_nwmls',
'propclass' => '',
'statuskey' => '',
'extidkey' => 'LN',
'propidkey' => 'LN',
'propquery' => array
(
'ListingStatus' => 'A',
'Date' => 'SINCEDATET00:00:00',
'BeforeDate' => 'BEFOREDATET00:00:00',
'NowDate' => 'NOWDATET00:00:00',
'Zip' => 'ZIPLIST',
),
'propfilter' => array
(
'ListingNumber' => 'LN'
),
'headerinfo' => array
(
'User-Agent' => 'RIOGenesisRETS',
),
);
}
else
{
$querydata = array
(
'donotrun' => true,
'propclass' => '',
'statuskey' => '',
'extidkey' => '',
'propidkey' => '',
'propquery' => array
(
'ListingStatus' => '',
'Date' => '',
'BeforeDate' => "",
'Zip' => '',
),
'headerinfo' => array
(
'User-Agent' => 'RIOGenesisRETS',
),
);
}
return $querydata;
}
function mls_mappropertydata($records)
{
if ($records)
{
$pemap = mls_getdatamap(($_REQUEST[strictmap] > 0 || $_REQUEST[showmapping] > 0));
d(pemap, $pemap);
$pemap_function = $pemap[func];
unset($pemap[func]);
$pemap_mfunction = $pemap[mfunc];
unset($pemap[mfunc]);
if (gc_enabled())
gc_collect_cycles();
$properties = array();
d(Records, $records);
if ($_REQUEST[strictmap])
$errorcountmax = min($_REQUEST[strictmap], count($records));
foreach($records as $k=>$record)
{
$rarr=array();
foreach($pemap as $typ=>$columns)
{
foreach($columns as $column=>$match)
{
//I want to take not of the key if it exists
//even if it doesn't have any legitimate data with it
if(array_key_exists($match, $record))
{
$func = $pemap_function[$typ][$column][$match];
$mfunc = $pemap_mfunction[$typ][$column][$match];
if($_REQUEST[displaymappingtable])
$displaymapping[$typ][$column][$match]++;
if ($_REQUEST[showmapping])
$rarr[$typ][$column][] = '['.$match.']';
elseif (function_exists($func))
$rarr[$typ][$column] = $func($record[$match]);
elseif (function_exists($mfunc))
$rarr[$typ][$column] = $mfunc($record);
else
$rarr[$typ][$column] = $record[$match];
unset($mfunc,$func);
}
//find a match to $item and remove / replace the key with the selected item
//if we are running strict types
//and we didn't get a match on a column
if (($_REQUEST[displaymappingtable]||$_REQUEST[strictmap]) && !isset($rarr[$typ][$column]))
$missingfields[$typ][$column]++;
}
}
if ($_REQUEST[strictmap] > 0)
{
$errorcount++;
$proprecord['missing data'] = $missingfields;
$proprecord['mapped data'][$errorcount]['mapped'] = $rarr;
$proprecord['mapped data'][$errorcount]['data'] = $record;
if ($errorcount >= $errorcountmax || $_REQUEST[showmapping])
{
d('Field Data', $proprecord);
d(request,$_REQUEST);
ddie("strictmap");
}
}
unset($records[$k]);
$properties[$k]=$rarr;
unset($rarr);
$properties[$k][record]=$record;
if (gc_enabled())
gc_collect_cycles();
}
}
if($_REQUEST[displaymappingtable])
{
$out['mapping']['mapped'] = $displaymapping;
$out['mapping']['missing'] = $missingfields;
}
if ($_REQUEST[showmapping])
ddie('killed for showmapping argument to prevent bad data being put into database');
$out[properties] = $properties;
return $out;
}
function mls_getproperties_nwmls($mlsdata, $querydata, $filterdata='')
{
$query[startdate] = $querydata[Date];
$query[enddate] = ($querydata[BeforeDate])?$querydata[BeforeDate]:$querydata[NowDate];
$query[status] = $querydata[ListingStatus];
return mls_propertyquery_nwmls($mlsdata, implode('', $query), $filterdata);
}
function mls_connect_nwmls($mlsdata)
{
global $nwmls_client;
if (!$nwmls_client)
{
try
{
$queryWSDL = $mlsdata[staffidxmlsurl];
$creds = array('_login' => '', '_password' => '', 'trace' => 1);
$nwmls_client = new SoapClient($queryWSDL, $creds);
}
catch (Exception $ex)
{
developer_error("NWMLS Connection error:", "An exception was thrown while attempting to connect to NWMLS: ".print_r($ex, true));
unset($nwmls_client);
return false;
}
}
return $nwmls_client;
}
function mls_disconnect_nwmls()
{
global $nwmls_client;
unset($nwmls_client);
}
function mls_getpropertystatus_nwmls($mlsdata, $querydata, $propids)
{
$rval = array();
if ($propids)
{
if (!is_array($propids))
$propids = explode(',', $propids);
$rval = array();
$filter = "LN";
foreach ($propids as $propid)
{
$result = mls_propertyquery_nwmls($mlsdata, "A$propid", $filter);
$rval[] = $result[records];
}
}
return $rval;
}
function mls_propertyquery_nwmls($mlsdata, $querydata, $filterdata='')
{
if (is_array($querydata))
$querydata = implode($querydata);
//d(querydata, $querydata);
try
{
$client = mls_connect_nwmls($mlsdata);
$query['v_strXmlQuery'] =
'
'.$mlsdata[staffidxmlsusername].'
'.$mlsdata[staffidxmlspassword].'
StandardXML1_2
NWMLS
RESI
'.$querydata.'
'.$filterdata.'
';
$listingsXML = $client -> RetrieveListingData($query) -> RetrieveListingDataResult;
$proparray = parsexml_array($listingsXML);
if ($proparray[ResponseMessages])
developer_error("NWMLS ResponseMessages:", "An response message NWMLS: ".print_r($proparray[ResponseMessages], true));
$rval[records] = $proparray[Residential];
unset($proparray);
return $rval;
}
catch (Exception $ex)
{
d('Connection Exception', $ex);
return false;
}
}
function mls_getimages_nwmls($mlsdata, $propids)
{
global $tmp_imagedir, $nwmls_client;
d(mlsdata, $mlsdata);
d(propids, $propids);
if (!is_array($propids))
$propids = explode(',', $propids);
$imagequeryWSDL = 'http://images.idx.nwmls.com/imageservice/imagequery.asmx?WSDL';
$creds = array('_login' => '', '_password' => '', 'trace' => 1);
$client = new SoapClient($imagequeryWSDL, $creds);
d(client, $client);
$rval = array();
$image_limit = mls_getvariable('images_limit');
foreach ($propids as $propid)
{
$XMLQuery = '
'.$mlsdata[staffidxmlsusername].'
'.$mlsdata[staffidxmlspassword].'
'.$propid.'
NWMLS:EverNet:ImageData:1.0
';
d(xmlquery, $XMLQuery);
$params = array ('query' => $XMLQuery);
// catching the SOAP errors so the program doesn't stop abruptly
try
{
$fullstr = $client -> RetrieveImages($params) -> RetrieveImagesResult; ;
}
catch (Exception $e)
{
d("NWMLS soap exception", $e);
}
$array = parsexml_array($fullstr);
if (count($array['Images']['Image']) != 0)
{
// check to see if it is a one pic property
if ($array['Images'])
foreach ( $array['Images'] as $image )
{
$image_count = 0;
if ($image['ImageId'] > 0)
$imagearr = $array['Images'];
else
$imagearr = $array['Images']['Image'];
foreach ($imagearr as $image)
{
$data = base64_decode($image['BLOB']);
$imageid = $image['ImageOrder'];
$filename = "image_{$propid}_{$imageid}.jpg";
$picsize = strlen($data);
if (trim($image['ImageOrder']) != "" && $picsize > 0 && file_put_contents($tmp_imagedir.'/'.$filename, $data))
{
$rval[$propid][$imageid] = $filename;
$image_count++;
}
if ($image_limit <= $image_count)
break;
}
}
}
}
return $rval;
}
function mls_remapzipcodes($zipcodes)
{
$zipmap = mls_getzipcodemap();
if (isset($zipmap))
{
$tmp_codes = (is_array($zipcodes))?$zipcodes:explode(',', $zipcodes);
$mlscodes = array();
foreach ($tmp_codes as $code)
$mlscodes[] = ($zipmap[$code])?$zipmap[$code]:$code;
$mlscodes = implode(",", $mlscodes);
}
return $mlscodes;
}
function mls_getdatamap($showbasemap = 0)
{
global $mls_shortname;
/** If a field is added to one of the mls map sets below
* please make sure to add it to the base map as well **/
if ($showbasemap || !mls_hasshortname())
{
//can add to the array structure,
//but do not add mappings to this array
//these are intended to help debug future mls
$pemap[property][propertyassignmenttype] = '';
$pemap[property][propertylistingagent] = '';
$pemap[property][propertyaddress] = '';
$pemap[property][propertycity] = '';
$pemap[property][propertystate] = '';
$pemap[property][propertyzip] = '';
$pemap[property][propertycounty] = '';
$pemap[ext][propertyextensionparcelapn] = '';
$pemap[ext][propertyextensionmls] = '';
$pemap[ext][propertyextensiondaysonmarket] = '';
$pemap[ext][propertyextensionstatus] = '';
$pemap[ext][propertyextensionlistdate] = '';
$pemap[ext][propertyextensionlistprice] = '';
$pemap[ext][propertyextensionsubdivision] = '';
$pemap[ext][propertyextensiontype] = '';
$pemap[ext][propertyextensionbedrooms] = '';
$pemap[ext][propertyextensionbathrooms] = '';
$pemap[ext][propertyextensionsqft] = '';
$pemap[ext][propertyextensiongarage] = '';
$pemap[ext][propertyextensionyearbuilt] = '';
$pemap[ext][propertyextensioningroundpool] = '';
$pemap[ext][propertyextensionbasement] = '';
$pemap[ext][propertyextensionfinishedbasement] = '';
$pemap[ext][propertyextensionoccupancystatus] = '';
$pemap[ext][propertyextensionhoafeesforacqprops] = '';
$pemap[ext][propertyextension2012taxes] = '';
$pemap[ext][propertyextensionremarks] = '';
$pemap[ext][propertyextensionofficecode] = '';
$pemap[office][fulladdress] = '';
$pemap[office][officecode] = '';
$pemap[office][officename] = '';
$pemap[office][officephone] = '';
$pemap[office][desigbroker] = '';
$pemap[office][desigbrokercode] = '';
$pemap[office][designatedbrokername] = '';
}
if ($mls_shortname == 'GLVAR') //GLVAR: Nevada, Las Vegas
{
$pemap[property][propertyassignmenttype] = "shortsale";
$pemap[func][property][propertyassignmenttype]["shortsale"] = "assignmenttypeshortsalecheck"; //nv
$pemap[property][propertyaddress] = "publi_2861";
$pemap[property][propertycity] = "citytwn";
$pemap[property][propertycounty] = "county";
$pemap[property][propertyzip] = "zip";
$pemap[ext][propertyextensionparcelapn] = 'parcel#';
$pemap[ext][propertylistingagent] = "laname";
$pemap[ext][propertyextensionstatus] = 'stat';
$pemap[ext][propertyextensionlistdate] = "listdate";
$pemap[func][ext][propertyextensionlistdate]["listdate"] = "formatlistdate";
$pemap[ext][propertyextensionlistprice] = "listprice";
$pemap[ext][propertyextensionyearbuilt] = 'yearblt';
$pemap[ext][propertyextensiontype] = 'proptype';
$pemap[ext][propertyextensionoccupancystatus] = '';
$pemap[ext][propertyextensionbedrooms] = 'bdrs';
$pemap[ext][propertyextensionbathrooms] = 'bthstot';
$pemap[ext][propertyextensionsqft] = 'approxtotallivarea';
$pemap[ext][propertyextensiongarage] = 'garage';
$pemap[ext][propertyextensiondaysonmarket] = 'adom';
$pemap[func][ext][propertyextensiondaysonmarket]['adom'] = 'get_datefromnumberofdays';
$pemap[ext][propertyextensioningroundpool] = 'pvpool';
$pemap[ext][propertyextensionbasement] = "bldgdesc";
$pemap[func][ext][propertyextensionbasement]["bldgdesc"] = "mlsbasementcheck";
$pemap[ext][propertyextensionsubdivision] = "subdivision";
$pemap[ext][propertyextensionhoafeesforacqprops] = "assocfee";
$pemap[mfunc][ext][propertyextensionhoafeesforacqprops]["assocfee"] = "nv_importhoaannualfee";
$pemap[ext][propertyextensionofficecode] = "listofccode";
$pemap[ext][propertyextensionmls] = "ml#";
$pemap[ext][propertyextension2012taxes] = "taxes";
} //GLVAR: Nevada, Las Vegas
else if ($mls_shortname == 'NEFMLS') //NEFMLS: north east florida
{
$pemap[property][propertyassignmenttype] = "ownerapprpublicmktg";
$pemap[func][property][propertyassignmenttype]["ownerapprpublicmktg"] = "assignmenttypeshortsalecheck2"; //fl
$pemap[property][propertyaddress] = "housenbr";
$pemap[mfunc][property][propertyaddress]["housenbr"] = "get_fl_streetaddress";
$pemap[property][propertycity] = "city";
$pemap[property][propertycounty] = "county";
$pemap[property][propertystate] = "state";
$pemap[property][propertyzip] = "zip";
$pemap[ext][propertyextensionparcelapn] = 'parcelnbr';
$pemap[ext][propertylistingagent] = "listmbrname";
$pemap[ext][propertyextensionstatus] = 'status';
$pemap[ext][propertyextensionlistdate] = 'statuschan';
$pemap[ext][propertyextensionlistprice] = 'listprice';
$pemap[ext][propertyextensionyearbuilt] = 'yrbuilt';
$pemap[ext][propertyextensiontype] = 'type';
$pemap[ext][propertyextensionoccupancystatus] = 'occupancy';
$pemap[ext][propertyextensionbedrooms] = 'totalbr';
$pemap[ext][propertyextensionbathrooms] = 'totalbath';
$pemap[ext][propertyextensionsqft] = 'totalsqft';
$pemap[mfunc][ext][propertyextensiongarage]['garcarpt'] = 'get_garagetype';
$pemap[ext][propertyextensiondaysonmarket] = 'pictimestamp';
$pemap[func][ext][propertyextensiondaysonmarket]['pictimestamp'] = 'get_datefromnumberofdays';
$pemap[ext][propertyextensionremarks] = 'remark1';
$pemap[ext][propertyextensioningroundpool] = 'poolhottub';
$pemap[ext][propertyextensionsubdivision] = 'subdivisio';
$pemap[ext][propertyextensionhoafeesforacqprops] = "assessedva";
$pemap[mfunc][ext][propertyextensionhoafeesforacqprops]["assessedva"] = "fl_importhoaannualfee";
$pemap[ext][propertyextensionofficecode] = "listoffshort";
$pemap[ext][propertyextensionmls] = 'listingid';
$pemap[office][fulladdress] = "listoffaddy";
$pemap[office][officecode] = "listoffshort";
$pemap[office][officename] = "listofcname";
$pemap[office][officephone] = "listoffphone";
$pemap[office][desigbroker] = "listmbrshort";
$pemap[office][designatedbrokername] = "listmbrname";
} //NEFMLS: north east florida
else if ($mls_shortname == 'ARMLS')
{
$pemap[property][propertyassignmenttype] = "";
$pemap[property][propertyaddress] = "housenbr"; //housenbr,streetdirp,streetname,streetdirs,streetsuff
$pemap[mfunc][property][propertyaddress]["housenbr"] = "get_ar_streetaddress";
$pemap[property][propertycity] = "city";
$pemap[property][propertycounty] = "county";
$pemap[property][propertystate] = "state";
$pemap[property][propertyzip] = "zip";
$pemap[ext][propertyextensionparcelapn] = 'parcelnbr';
$pemap[ext][propertylistingagent] = "listmbrname";
$pemap[ext][propertyextensionstatus] = 'status';
$pemap[ext][propertyextensionlistdate] = 'timestamp';
$pemap[ext][propertyextensionlistprice] = 'listprice';
$pemap[ext][propertyextensionbasement] = 'basementyn';
$pemap[ext][propertyextensionyearbuilt] = 'yrbuilt';
$pemap[ext][propertyextensiontype] = 'booksec';
$pemap[ext][propertyextensionoccupancystatus] = '';
$pemap[ext][propertyextensionbedrooms] = 'totalbr';
$pemap[ext][propertyextensionbathrooms] = 'totalbath';
$pemap[ext][propertyextensionsqft] = 'totalsqft';
$pemap[ext][propertyextensiongarage] = 'garagespaces';
$pemap[ext][propertyextensiondaysonmarket] = 'pictimestamp';
$pemap[func][ext][propertyextensiondaysonmarket]['pictimestamp'] = 'get_datefromnumberofdays';
$pemap[ext][propertyextensionremarks] = 'remark1';
$pemap[ext][propertyextensionhoafeesforacqprops] = "hoafee";
$pemap[mfunc][ext][propertyextensionhoafeesforacqprops]["hoafee"] = "get_ar_importhoaannualfee";
$pemap[ext][propertyextensioningroundpool] = 'pool-private';
$pemap[mfunc][ext][propertyextensioningroundpool]['pool-private'] = 'get_ar_groundpool';
$pemap[ext][propertyextensionsubdivision] = '';
$pemap[ext][propertyextensionofficecode] = "listoffshort";
$pemap[ext][propertyextensionmls] = 'listingid';
$pemap[ext][propertyextension2012taxes]='taxes';
$pemap[office][fulladdress] = "listoffaddy";
$pemap[office][officecode] = "listoffshort";
$pemap[office][officename] = "listofcname";
$pemap[office][officephone] = "listoffphone";
$pemap[office][desigbroker] = "listmbrshort";
$pemap[office][designatedbrokername] = "listmbrname";
} //ARMLS: Arizon MLS
else if ($mls_shortname == 'NTREIS') //NTREIS: Dallas TX MLSD
{
$pemap[property][propertyassignmenttype] = "propertytype";
$pemap[property][propertyaddress] = "streetnumber";
$pemap[mfunc][property][propertyaddress]["streetnumber"] = 'get_dtx_streetaddress';
$pemap[property][propertycity] = "city";
$pemap[property][propertycounty] = "countyorparish";
$pemap[property][propertystate] = "stateorprovince";
$pemap[property][propertyzip] = "postalcode";
$pemap[ext][propertyextensionparcelapn] = 'parcelnumber';//'uid';
$pemap[ext][propertylistingagent] = "listagentfullname";
$pemap[ext][propertyextensionstatus] = 'status';
$pemap[ext][propertyextensionlistdate] = 'dateavailable';
$pemap[ext][propertyextensionlistprice] = 'listprice';
$pemap[ext][propertyextensionbasement] = '';
$pemap[ext][propertyextensionyearbuilt] = 'yearbuilt';
$pemap[ext][propertyextensiontype] = '';
$pemap[ext][propertyextensionoccupancystatus] = '';
$pemap[ext][propertyextensionbedrooms] = 'bedstotal';
$pemap[ext][propertyextensionbathrooms] = 'bathstotal';
$pemap[ext][propertyextensionsqft] = 'sqfttotal';
$pemap[ext][propertyextensiongarage] = 'garagelength';
$pemap[ext][propertyextensiondaysonmarket] = 'dateavailable';
$pemap[ext][propertyextensionremarks] = 'publicremarks';
$pemap[ext][propertyextensionhoafeesforacqprops] = "associationfee";
$pemap[mfunc][ext][propertyextensionhoafeesforacqprops]["associationfee"] = 'get_dtx_hoafees';
$pemap[ext][propertyextensioningroundpool] = 'poolyn';
$pemap[mfunc][ext][propertyextensioningroundpool]['poolyn'] = 'get_dtx_groundpool';
$pemap[ext][propertyextensionsubdivision] = 'subdivisionname';
$pemap[ext][propertyextensionofficecode] = "listofficemlsid";
$pemap[ext][propertyextensionmls] = 'mlsnumber';
$pemap[ext][propertyextension2012taxes]='';
$pemap[office][fulladdress] = "";
$pemap[office][officecode] = "listofficemlsid";
$pemap[office][officename] = "listofficename";
$pemap[office][officephone] = "";
$pemap[office][desigbroker] = "listagentfullname";
$pemap[office][designatedbrokername] = "listagentfullname";
} //NTREIS: Dallas TX MLS
else if ($mls_shortname == 'OLD_NTREIS') //NTREIS: Dallas TX MLSD
{
$pemap[property][propertyassignmenttype] = "";
$pemap[property][propertyaddress] = "st#";
$pemap[mfunc][property][propertyaddress]["st#"] = 'get_odtx_streetaddress';
$pemap[property][propertycity] = "city";
$pemap[property][propertycounty] = "county";
$pemap[property][propertystate] = "state";
$pemap[property][propertyzip] = "zipcode";
$pemap[ext][propertyextensionparcelapn] = 'parcelid';//'uid';
$pemap[ext][propertylistingagent] = "laid";
$pemap[ext][propertyextensionstatus] = 'status';
$pemap[ext][propertyextensionlistdate] = 'modified';
$pemap[ext][propertyextensionlistprice] = 'listpr';
$pemap[ext][propertyextensionbasement] = '';
$pemap[ext][propertyextensionyearbuilt] = 'yb';
$pemap[ext][propertyextensiontype] = '';
$pemap[ext][propertyextensionoccupancystatus] = '';
$pemap[ext][propertyextensionbedrooms] = 'beds';
$pemap[ext][propertyextensionbathrooms] = 'totbths';
$pemap[ext][propertyextensionsqft] = 'sqft';
$pemap[ext][propertyextensiongarage] = '#gar';
$pemap[ext][propertyextensiondaysonmarket] = 'modified';
$pemap[ext][propertyextensionremarks] = 'pubrmks';
$pemap[ext][propertyextensionhoafeesforacqprops] = "hoadues";
$pemap[mfunc][ext][propertyextensionhoafeesforacqprops]["hoadues"] = 'get_dtx_importhoaannualfee';
$pemap[ext][propertyextensioningroundpool] = 'poolonprop';
$pemap[ext][propertyextensionsubdivision] = 'subdivision';
$pemap[ext][propertyextensionofficecode] = "";
$pemap[ext][propertyextensionmls] = 'mls#';
$pemap[ext][propertyextension2012taxes]='';
$pemap[office][fulladdress] = "";
$pemap[office][officecode] = "locode";
$pemap[office][officename] = "officenam2";
$pemap[office][officephone] = "";
$pemap[office][desigbroker] = "laid";
$pemap[office][designatedbrokername] = "";
} //NTREIS: Dallas TX MLS
else if ($mls_shortname == 'MAAR') //MAAR: Tennessee
{
$pemap[property][propertyassignmenttype] = 'salestype';
$pemap[property][propertyaddress] = 'address';
//$pemap[mfunc][property][propertyaddress]['stname'] = "get_tn_streetaddress";
$pemap[property][propertycity] = "city";
$pemap[property][propertycounty] = "county";
$pemap[property][propertystate] = 'state';
$pemap[property][propertyzip] = "zip5";
$pemap[ext][propertyextensionparcelapn] = 'parcelid';
$pemap[ext][propertylistingagent] = 'la1firstnm';
$pemap[mfunc][ext][propertylistingagent]['la1firstnm'] = 'get_tn_propertylistingagent';
$pemap[ext][propertyextensionstatus] = 'status';
$pemap[ext][propertyextensionlistdate] = 'lstdate';
//$pemap[func][ext][propertyextensionlistdate]["listdate"] = "formatlistdate";
$pemap[ext][propertyextensionlistprice] = "listprice";
$pemap[ext][propertyextensionyearbuilt] = 'yearbuilt';
$pemap[ext][propertyextensiontype] = 'listngtype';
$pemap[ext][propertyextensionoccupancystatus] = '';
$pemap[ext][propertyextensionbedrooms] = 'bedrmsdown';
//$pemap[func][ext][propertyextensionbedrooms]['bedrooms'] = 'tn_gettotalbedrooms';
$pemap[ext][propertyextensionbathrooms] = 'fullbaths';
$pemap[ext][propertyextensionsqft] = 'aprxhtdsqf';
$pemap[ext][propertyextensiongarage] = 'prkngdsply';
$pemap[ext][propertyextensiondaysonmarket] = 'statusdetl';
$pemap[func][ext][propertyextensiondaysonmarket]['statusdetl'] = 'get_datefromnumberofdays';
$pemap[ext][propertyextensioningroundpool] = 'pooldescr';
$pemap[ext][propertyextensionsubdivision] = 'legalsubdi';
$pemap[ext][propertyextensionhoafeesforacqprops] = 'anassocfee';
$pemap[ext][propertyextensionofficecode] = 'listofc1';
//$pemap[mfunc][ext][propertyextensionofficecode]["listofficecode"] = 'get_tn_officecode';
$pemap[ext][propertyextensionmls]="mls#";
$pemap[ext][propertyextensionbasement] = '';
$pemap[ext][propertyextensionremarks] = 'premarks';
$pemap[ext][propertyextension2012taxes]='anlcitytax';
$pemap[mfunc][ext][propertyextension2012taxes]["anlcitytax"] = 'get_tn_2012taxes';
$pemap[office][officecode] = "listofc1";
//$pemap[mfunc][office][officecode]['listofficecode'] = "get_tn_officecode";
$pemap[office][officename] = "lo1ofcname";
$pemap[office][officephone] = "la1phon1ar";
$pemap[mfunc][office][officephone]["la1phon1ar"] = 'get_tn_officephone';
$pemap[office][desigbroker] = "agent";
$pemap[office][desigbrokercode] = "";
$pemap[office][designatedbrokername] = "";
} //MAAR: Tennessee
else if ($mls_shortname == 'OLD_MAAR') //OLD_MAAR: Tennessee
{
$pemap[property][propertyassignmenttype] = 'salestype';
$pemap[property][propertyaddress] = 'stname';
$pemap[mfunc][property][propertyaddress]['stname'] = "get_tn_streetaddress";
$pemap[property][propertycity] = "city";
$pemap[property][propertycounty] = "county";
$pemap[property][propertystate] = 'state';
$pemap[property][propertyzip] = "zip";
$pemap[ext][propertyextensionparcelapn] = 'parcelid';
$pemap[ext][propertylistingagent] = "listagentname";
$pemap[ext][propertyextensionstatus] = 'status';
$pemap[ext][propertyextensionlistdate] = "listdate";
$pemap[func][ext][propertyextensionlistdate]["listdate"] = "formatlistdate";
$pemap[ext][propertyextensionlistprice] = "listprice";
$pemap[ext][propertyextensionyearbuilt] = '';
$pemap[ext][propertyextensiontype] = 'type';
$pemap[ext][propertyextensionoccupancystatus] = '';
$pemap[ext][propertyextensionbedrooms] = 'br';
$pemap[ext][propertyextensionbathrooms] = 'totalbaths';
$pemap[ext][propertyextensionsqft] = 'sfrange';
$pemap[ext][propertyextensiongarage] = 'cvparking';
$pemap[ext][propertyextensiondaysonmarket] = 'dom';
$pemap[func][ext][propertyextensiondaysonmarket]['dom'] = 'get_datefromnumberofdays';
$pemap[ext][propertyextensioningroundpool] = 'pool';
$pemap[ext][propertyextensionsubdivision] = "subd";
$pemap[ext][propertyextensionhoafeesforacqprops] = "assocfee";
$pemap[ext][propertyextensionofficecode] = "listofficecode";
$pemap[mfunc][ext][propertyextensionofficecode]["listofficecode"] = 'get_tn_officecode';
$pemap[ext][propertyextensionmls]="mls#";
$pemap[ext][propertyextensionbasement] = "basementdim";
$pemap[ext][propertyextensionremarks] = 'remarks';
$pemap[ext][propertyextension2012taxes]="annualctytax";
//$pemap[mfunc][ext][propertyextension2012taxes]["annualctytax"] = 'get_tn2012taxes';
$pemap[office][officecode] = "listofficecode";
$pemap[mfunc][office][officecode]['listofficecode'] = "get_tn_officecode";
$pemap[office][officename] = "listofficename";
$pemap[office][officephone] = "listofficephone";
$pemap[office][desigbroker] = "listagentname";
$pemap[office][desigbrokercode] = "listingpublicid";
$pemap[office][designatedbrokername] = "listagentname";
} //OLD_MAAR: Tennessee
else if ($mls_shortname == 'BAKMLS') //BAKMLS: California
{
$pemap[property][propertyassignmenttype] = 'disclosures';
$pemap[property][propertyaddress] = 'streetnumber';
$pemap[mfunc][property][propertyaddress]["streetnumber"] = "get_ca_streetaddress";
$pemap[property][propertycity] = "city";
$pemap[property][propertycounty] = "county";
$pemap[property][propertystate] = "state";
$pemap[property][propertyzip] = "zip";
$pemap[ext][propertyextensionparcelapn] = '';
$pemap[ext][propertylistingagent] = "listingagtfullname";
$pemap[ext][propertyextensionstatus] = 'status';
$pemap[ext][propertyextensionlistdate] = "listingdate";
$pemap[func][ext][propertyextensionlistdate]["listingdate"] = "formatlistdate";
$pemap[ext][propertyextensionlistprice] = "listingprice";
$pemap[ext][propertyextensionyearbuilt] = 'yearbuilt';
$pemap[ext][propertyextensiontype] = 'propertysubtype1';
$pemap[mfunc][ext][propertyextensiontype]['propertytype'] = 'format_propertytype';
$pemap[ext][propertyextensionoccupancystatus] = '';
$pemap[ext][propertyextensionbedrooms] = 'bedrooms';
$pemap[ext][propertyextensionbathrooms] = 'bathrooms';
$pemap[ext][propertyextensionsqft] = 'squarefootage';
$pemap[ext][propertyextensiongarage] = 'parking';
$pemap[ext][propertyextensioningroundpool] = 'pooltype';
$pemap[ext][propertyextensionofficecode] = "listingofficenumber";
$pemap[mfunc][ext][propertyextensionofficecode]["listingofficenumber"] = 'get_ca_officecode';
$pemap[ext][propertyextensionmls]="listingnumber";
$pemap[ext][propertyextensionremarks] = 'marketingremark';
$pemap[office][officecode] = "listingofficenumber";
$pemap[mfunc][office][officecode]["listingofficenumber"] = 'get_ca_officecode';
$pemap[office][officename] = "listingofficename";
$pemap[office][desigbroker] = "listingagtfullname";
$pemap[office][desigbrokercode] = "listingagentmlsid";
$pemap[office][designatedbrokername] = "listingagtfullname";
} //BAKMLS: California
else if ($mls_shortname == 'GNWR') //GNWR: Texas
{
$pemap[property][propertyassignmenttype] = 'discl';
$pemap[func][property][propertyassignmenttype]['discl'] = 'get_tx_assignmenttype';
$pemap[property][propertyaddress] = 'stname';
$pemap[mfunc][property][propertyaddress]["stname"] = "get_tx_streetaddress";
$pemap[property][propertycity] = "city";
$pemap[property][propertycounty] = "county";
$pemap[property][propertystate] = "st";
$pemap[property][propertyzip] = "zip";
$pemap[ext][propertyextensionparcelapn] = 'taxid';
$pemap[ext][propertylistingagent] = "t_fullname";
$pemap[ext][propertyextensionstatus] = 'status';
$pemap[ext][propertyextensionlistdate] = "lstdate";
$pemap[func][ext][propertyextensionlistdate]["lstdate"] = "formatlistdate";
$pemap[ext][propertyextensionlistprice] = "lp";
$pemap[ext][propertyextensionyearbuilt] = 'yrblt';
$pemap[ext][propertyextensiontype] = 'proptype';
$pemap[ext][propertyextensionoccupancystatus] = '';
$pemap[ext][propertyextensionbedrooms] = 'beds';
$pemap[ext][propertyextensionbathrooms] = 'fb';
$pemap[ext][propertyextensionsqft] = 'bldgsf';
$pemap[ext][propertyextensiongarage] = 'gar#';
$pemap[ext][propertyextensiondaysonmarket] = 'lstdate';
$pemap[func][ext][propertyextensiondaysonmarket]['lstdate'] = 'get_datefromnumberofdays';
$pemap[ext][propertyextensioningroundpool] = 'prvtpool';
$pemap[ext][propertyextensionsubdivision] = "legalsub";
$pemap[ext][propertyextensionhoafeesforacqprops] = "mntfeeamt";
$pemap[mfunc][ext][propertyextensionhoafeesforacqprops]["mntfeeamt"] = "tx_importhoaannualfee";
$pemap[ext][propertyextensionofficecode] = "laid";
$pemap[ext][propertyextensionmls]="ml#";
$pemap[ext][propertyextension2012taxes]="taxes";
$pemap[ext][propertyextensionremarks] = 'pubrmrks';
$pemap[office][fulladdress] = "lcaddr";
$pemap[office][officecode] = "laid";
$pemap[office][officename] = "officename";
$pemap[office][officephone] = "list_phone";
$pemap[office][desigbroker] = "t_fullname";
$pemap[office][desigbrokercode] = "laid";
$pemap[office][designatedbrokername] = "t_fullname";
} //GNWR: Texas
else if ($mls_shortname == 'GAMLS-SFD' || $mls_shortname == 'GAMLS-SFA') //GAMLS: Georgia
{
$pemap[property][propertyassignmenttype] = '';
$pemap[property][propertyaddress] = 'str';
$pemap[mfunc][property][propertyaddress]["str"] = "get_ga_streetaddress";
$pemap[property][propertycity] = "city";
$pemap[property][propertycounty] = "cnty";
$pemap[func][property][propertycounty]["cnty"] = "get_ga_county";
$pemap[property][propertystate] = "state";
$pemap[property][propertyzip] = "zip";
$pemap[ext][propertyextensionparcelapn] = 'tid';
$pemap[ext][propertylistingagent] = "listagentname";
$pemap[ext][propertyextensionstatus] = 'stat';
$pemap[ext][propertyextensionlistdate] = "ld";
$pemap[ext][propertyextensionlistprice] = "lp";
$pemap[ext][propertyextensionyearbuilt] = 'yr';
$pemap[ext][propertyextensiontype] = '';
$pemap[ext][propertyextensionoccupancystatus] = 'sho';
$pemap[ext][propertyextensionbedrooms] = 'br';
$pemap[ext][propertyextensionbathrooms] = 'baf';
$pemap[mfunc][ext][propertyextensionbathrooms]['baf'] = 'get_ga_bathroom';
$pemap[ext][propertyextensionsqft] = 'sqft_tot';
$pemap[ext][propertyextensiongarage] = 'prk';
$pemap[ext][propertyextensiondaysonmarket] = 'ld';
$pemap[func][ext][propertyextensiondaysonmarket]['ld'] = 'get_datefromnumberofdays';
$pemap[ext][propertyextensioningroundpool] = '';
$pemap[ext][propertyextensionbasement] = "bsmt";
$pemap[ext][propertyextensionsubdivision] = "subd";
$pemap[ext][propertyextensionhoafeesforacqprops] = "";
$pemap[ext][propertyextensionofficecode] = "lb";
$pemap[ext][propertyextensionmls]="ln";
//$pemap[ext][propertyextensionmls]="reinsightkey";
$pemap[ext][propertyextension2012taxes]="tax";
//mfunc
$pemap[ext][propertyextensionremarks] = 'public_remarks';
$pemap[office][fulladdress] = "loadd1";
$pemap[mfunc][office][fulladdress]["loadd1"] = 'get_ga_officeaddress';
$pemap[office][officecode] = "lb";
$pemap[mfunc][office][officecode]["lb"] = '';
//mfunc
$pemap[office][officename] = "listofficename";
$pemap[office][officephone] = "lophone";
$pemap[office][desigbroker] = "listagentname";
$pemap[office][desigbrokercode] = "lb";
$pemap[office][designatedbrokername] = "listagentname";
} //GAMLS: Georgia
else if ($mls_shortname=='SWFLAMLS') //SWFLAMLS: Naples Florida
{
$pemap[property][propertyassignmenttype] = 'foreclosedreoyn';
$pemap[mfunc][property][propertyassignmenttype]['foreclosedreoyn'] = 'get_fln_propertyassignmenttype';
$pemap[property][propertyaddress] = 'fulladdress';
$pemap[property][propertycity] = "city";
$pemap[property][propertycounty] = "countyorparish";
$pemap[property][propertystate] = "stateorprovince";
$pemap[property][propertyzip] = "postalcode";
$pemap[ext][propertyextensionparcelapn] = 'parcelnumber';
$pemap[ext][propertylistingagent] = "listagentfullname";
$pemap[ext][propertyextensionstatus] = 'status';
$pemap[ext][propertyextensionlistdate] = "createddate";
$pemap[ext][propertyextensionlistprice] = "listprice";
$pemap[ext][propertyextensionyearbuilt] = 'yearbuilt';
$pemap[ext][propertyextensiontype] = 'ownershipdesc';
$pemap[ext][propertyextensionoccupancystatus] = '';
$pemap[ext][propertyextensionbedrooms] = 'bedstotal';
$pemap[ext][propertyextensionbathrooms] = 'bathstotal';
$pemap[ext][propertyextensionsqft] = 'totalarea';
$pemap[ext][propertyextensiongarage] = 'garagespaces';
$pemap[ext][propertyextensiondaysonmarket] = 'dom';
$pemap[func][ext][propertyextensiondaysonmarket]['dom'] = 'get_datefromnumberofdays';
$pemap[ext][propertyextensioningroundpool] = 'privatepoolyn';
$pemap[ext][propertyextensionbasement] = "";
$pemap[ext][propertyextensionsubdivision] = "subcondoname";
$pemap[ext][propertyextensionhoafeesforacqprops] = "hoafee";
$pemap[mfunc][ext][propertyextensionhoafeesforacqprops]["hoafee"] = 'get_fln_gethoafees';
$pemap[ext][propertyextensionofficecode] = "listofficemui";
$pemap[ext][propertyextensionmls]="mlsnumber";
$pemap[ext][propertyextension2012taxes]="taxes";
$pemap[ext][propertyextensionremarks] = 'propertyinformation';
$pemap[office][fulladdress] = "";
$pemap[office][officecode] = "listofficemui";
$pemap[office][officename] = "listofficename";
$pemap[office][officephone] = "listofficephone";
$pemap[office][desigbroker] = "listagentfullname";
$pemap[office][desigbrokercode] = "listagentmui";
$pemap[office][designatedbrokername] = "listagentfullname";
} //SWFLAMLS: Naples Florida
else if ($mls_shortname == 'RMLS') //RMLS: Oregon
{
$pemap[property][propertyassignmenttype] = '';
$pemap[property][propertyaddress] = 'fullstreetaddress';
$pemap[property][propertycity] = 'city';
$pemap[property][propertycounty] = 'county';
$pemap[property][propertystate] = 'state';
$pemap[property][propertyzip] = 'zipcode';
$pemap[ext][propertyextensionparcelapn] = 'taxid';
$pemap[ext][propertylistingagent] = 'listagentfullname';
$pemap[ext][propertyextensionstatus] = 'listingstatus';
$pemap[ext][propertyextensionlistdate] = 'datelist';
$pemap[ext][propertyextensionlistprice] = 'pricelist';
$pemap[ext][propertyextensionyearbuilt] = 'yearbuilt';
$pemap[ext][propertyextensiontype] = '';
$pemap[ext][propertyextensionoccupancystatus] = '';
$pemap[ext][propertyextensionbedrooms] = 'beds';
$pemap[ext][propertyextensionbathrooms] = 'bathstotal';
$pemap[ext][propertyextensionsqft] = 'sqftapproximatetotal';
$pemap[ext][propertyextensiongarage] = 'garagetype';
$pemap[ext][propertyextensiondaysonmarket] = 'daysonmarket';
$pemap[func][ext][propertyextensiondaysonmarket]['daysonmarket'] = 'get_datefromnumberofdays';
$pemap[ext][propertyextensioningroundpool] = '';
$pemap[ext][propertyextensionbasement] = 'basementfoundation';
$pemap[ext][propertyextensionsubdivision] = 'subdivision';
$pemap[ext][propertyextensionhoafeesforacqprops] = 'hoafee';
$pemap[mfunc][ext][propertyextensionhoafeesforacqprops]['hoafee'] = 'get_or_gethoafees';
$pemap[ext][propertyextensionofficecode] = 'listofficeid';
$pemap[ext][propertyextensionmls]='mlsnumber';
$pemap[ext][propertyextension2012taxes]='taxamount';
$pemap[ext][propertyextensionremarks] = 'remarkspublic';
$pemap[office][fulladdress] = '';
$pemap[office][officecode] = 'listofficeid';
$pemap[office][officename] = 'listofficename';
$pemap[office][officephone] = 'listagentphone';
$pemap[office][desigbroker] = 'listagentfullname';
$pemap[office][desigbrokercode] = 'listagentid';
$pemap[office][designatedbrokername] = 'listagentfullname';
} //RMLS: Oregon
else if ($mls_shortname == 'GFLR') //GFLR: Miami Florida
{
$pemap[property][propertyassignmenttype] = 'reo';
$pemap[mfunc][property][propertyassignmenttype]['reo'] = 'get_flr_getpropertyassignment';
$pemap[property][propertyaddress] = 'address';
$pemap[property][propertycity] = 'city';
$pemap[property][propertycounty] = 'ct';
$pemap[property][propertystate] = 'st';
$pemap[property][propertyzip] = 'zip';
$pemap[ext][propertyextensionparcelapn] = 'f#';
$pemap[ext][propertylistingagent] = 'ls';
$pemap[ext][propertyextensionstatus] = 'status';
$pemap[ext][propertyextensionlistdate] = 'statuschng';
$pemap[ext][propertyextensionlistprice] = 'lp$';
$pemap[ext][propertyextensionyearbuilt] = 'yr';
$pemap[ext][propertyextensiontype] = '';
$pemap[ext][propertyextensionoccupancystatus] = '';
$pemap[ext][propertyextensionbedrooms] = '#beds';
$pemap[ext][propertyextensionbathrooms] = '#fb';
$pemap[mfunc][ext][propertyextensionbathrooms]['#fb'] = 'get_fl_bathtotal';
$pemap[ext][propertyextensionsqft] = 'txsqft';
$pemap[ext][propertyextensiongarage] = '#gar';
$pemap[ext][propertyextensiondaysonmarket] = 'adom';
$pemap[func][ext][propertyextensiondaysonmarket]['adom'] = 'get_datefromnumberofdays';
$pemap[ext][propertyextensioningroundpool] = 'pool';
$pemap[ext][propertyextensionbasement] = '';
$pemap[ext][propertyextensionsubdivision] = 'sn';
$pemap[ext][propertyextensionhoafeesforacqprops] = 'fee';
$pemap[mfunc][ext][propertyextensionhoafeesforacqprops]['fee'] = 'get_flr_hoafees';
$pemap[ext][propertyextensionofficecode] = '';
$pemap[ext][propertyextensionmls]='ml#';
$pemap[ext][propertyextension2012taxes]='taxes$';
$pemap[ext][propertyextensionremarks] = 'rem';
$pemap[office][fulladdress] = '';
$pemap[office][officecode] = '';
$pemap[office][officename] = 'of';
$pemap[office][officephone] = 'oph';
$pemap[office][desigbroker] = 'ls';
$pemap[office][desigbrokercode] = 'lpid';
$pemap[office][designatedbrokername] = 'ls';
} //GFLR: Miami Florida
else if ($mls_shortname == 'DAYMLS') //DAYMLS: Daytona Florida
{
$pemap[property][propertyassignmenttype] = 'listingtype';
$pemap[property][propertyaddress] = 'streetname';
$pemap[mfunc][property][propertyaddress]['streetname'] = 'get_dfl_getstreetaddress';
$pemap[property][propertycity] = 'city';
$pemap[property][propertycounty] = 'county';
$pemap[property][propertystate] = 'stateorprovince';
$pemap[property][propertyzip] = 'postalcode';
$pemap[ext][propertyextensionparcelapn] = 'parcelnumber';
$pemap[ext][propertylistingagent] = '';
$pemap[ext][propertyextensionstatus] = 'listingstatus';
$pemap[ext][propertyextensionlistdate] = 'modificationtimestamp';
$pemap[ext][propertyextensionlistprice] = 'listprice';
$pemap[ext][propertyextensionyearbuilt] = 'yearbuilt';
$pemap[ext][propertyextensiontype] = '';
$pemap[ext][propertyextensionoccupancystatus] = 'showing';
$pemap[ext][propertyextensionbedrooms] = 'bedrooms';
$pemap[ext][propertyextensionbathrooms] = 'bathstotal';
$pemap[ext][propertyextensionsqft] = 'sqfttotal';
$pemap[ext][propertyextensiongarage] = 'parking';
$pemap[ext][propertyextensiondaysonmarket] = 'modificationtimestamp';
$pemap[ext][propertyextensioningroundpool] = 'pool';
$pemap[ext][propertyextensionbasement] = '';
$pemap[ext][propertyextensionsubdivision] = 'subdivision';
$pemap[ext][propertyextensionhoafeesforacqprops] = 'maintexpenses';
$pemap[ext][propertyextensionofficecode] = '';
$pemap[ext][propertyextensionmls]='listingid';
$pemap[ext][propertyextension2012taxes]='';
$pemap[ext][propertyextensionremarks] = 'publicremarks';
$pemap[office][fulladdress] = '';
$pemap[office][officecode] = '';
$pemap[office][officename] = '';
$pemap[office][officephone] = '';
$pemap[office][desigbroker] = '';
$pemap[office][desigbrokercode] = 'listingagentuid';
$pemap[office][designatedbrokername] = 'listingofficeuid';
} //DAYMLS: Daytona Florida
else if ($mls_shortname == 'MIBOR') //MIBOR: Indiana MLS
{
$pemap[property][propertyassignmenttype] = '';
$pemap[property][propertyaddress] = 'streetname';
$pemap[mfunc][property][propertyaddress]['streetname'] = 'get_ind_address';
$pemap[property][propertycity] = 'city';
$pemap[property][propertycounty] = 'countyorparish';
$pemap[property][propertystate] = 'stateorprovince';
$pemap[property][propertyzip] = 'zipcode';
$pemap[ext][propertyextensionparcelapn] = '';//'taxid';
$pemap[ext][propertylistingagent] = 'colistagentfullname';
$pemap[ext][propertyextensionstatus] = 'propertyextensionstatus';
$pemap[ext][propertyextensionlistdate] = 'dateavailable';
$pemap[ext][propertyextensionlistprice] = 'listprice';
$pemap[ext][propertyextensionyearbuilt] = 'yearbuilt';
$pemap[ext][propertyextensiontype] = '';
$pemap[ext][propertyextensionoccupancystatus] = '';
$pemap[ext][propertyextensionbedrooms] = 'bedstotal';
$pemap[ext][propertyextensionbathrooms] = 'bathstotal';
$pemap[ext][propertyextensionsqft] = 'sqfttotal';
$pemap[ext][propertyextensiongarage] = 'garage';
//$pemap[mfunc][ext][propertyextensiongarage]['garde_1309'] = 'get_ind_garage';
$pemap[ext][propertyextensiondaysonmarket] = '';
$pemap[ext][propertyextensioningroundpool] = '';
$pemap[ext][propertyextensionbasement] = 'basement';
//$pemap[mfunc][ext][propertyextensionbasement]['sfoptamt'] = 'get_ind_basement';//'sqftbasement';
$pemap[ext][propertyextensionfinishedbasement] = 'basementdescription';
//$pemap[mfunc][ext][propertyextensionbasement]['%optlvlfin'] = 'get_ind_basementfinished';
$pemap[ext][propertyextensionsubdivision] = 'subdivision';
$pemap[ext][propertyextensionhoafeesforacqprops] = 'mandatoryfee';
$pemap[mfunc][ext][propertyextensionhoafeesforacqprops]['mandatoryfee'] = 'get_ind_hoafees';
$pemap[ext][propertyextensionofficecode] = 'colistofficemlsid';
$pemap[ext][propertyextensionmls]='mlsnumber';
$pemap[ext][propertyextension2012taxes]='';
$pemap[ext][propertyextensionremarks] = 'agentremarks';
$pemap[office][fulladdress] = '';
$pemap[office][officecode] = 'colistofficemlsid';
$pemap[office][officename] = 'colistofficename';
$pemap[office][officephone] = 'colistagentdirectwor';
$pemap[office][desigbroker] = 'colistagentfullname';
$pemap[office][desigbrokercode] = 'colistagentmlsid';
$pemap[office][designatedbrokername] = 'colistagentfullname';
} //MIBOR: Indiana MLS
else if ($mls_shortname == 'OLD_MIBOR') //MIBOR: Indiana MLS
{
$pemap[property][propertyassignmenttype] = '';
$pemap[property][propertyaddress] = 'address';
$pemap[property][propertycity] = 'city';
$pemap[property][propertycounty] = 'countyname';
$pemap[property][propertystate] = 'state';
$pemap[property][propertyzip] = 'zip';
$pemap[ext][propertyextensionparcelapn] = 'cotaxid';//'taxid';
$pemap[ext][propertylistingagent] = 'lagtname';
$pemap[ext][propertyextensionstatus] = 'status';
$pemap[ext][propertyextensionlistdate] = 'lstdate';
$pemap[ext][propertyextensionlistprice] = 'lp';
$pemap[ext][propertyextensionyearbuilt] = 'yrblt';
$pemap[ext][propertyextensiontype] = '';
$pemap[ext][propertyextensionoccupancystatus] = 'physocc';
$pemap[ext][propertyextensionbedrooms] = '#bdrms';
$pemap[ext][propertyextensionbathrooms] = 'bthareas';
$pemap[ext][propertyextensionsqft] = 'totsf';//'mnsf';
$pemap[ext][propertyextensiongarage] = 'garde_1309';
$pemap[mfunc][ext][propertyextensiongarage]['garde_1309'] = 'get_ind_garage';
$pemap[ext][propertyextensiondaysonmarket] = 'cumulativedom';//'dom';
$pemap[ext][propertyextensioningroundpool] = '';
$pemap[ext][propertyextensionbasement] = 'sfoptamt';//'sqftbasement';
$pemap[mfunc][ext][propertyextensionbasement]['sfoptamt'] = 'get_ind_basement';//'sqftbasement';
$pemap[ext][propertyextensionfinishedbasement] = '%optlvlfin';//previously unmapped
$pemap[mfunc][ext][propertyextensionbasement]['%optlvlfin'] = 'get_ind_basementfinished';
$pemap[ext][propertyextensionsubdivision] = 'subdiv';
$pemap[ext][propertyextensionhoafeesforacqprops] = 'mandfee';
$pemap[mfunc][ext][propertyextensionhoafeesforacqprops]['mandfee'] = 'get_ind_hoafees';
$pemap[ext][propertyextensionofficecode] = 'loffice';
$pemap[ext][propertyextensionmls]='l#';
$pemap[ext][propertyextension2012taxes]='semitax';
$pemap[ext][propertyextensionremarks] = 'remarks';
$pemap[office][fulladdress] = '';
$pemap[office][officecode] = 'loffice';
$pemap[office][officename] = '';
$pemap[office][officephone] = 'lagtph#';
$pemap[office][desigbroker] = 'lagtname';
$pemap[office][desigbrokercode] = 'lagt';
$pemap[office][designatedbrokername] = 'lagtname';
} //MIBOR: Indiana MLS
else if ($mls_shortname == 'MFRMLS') //MFRMLS: Florida MLS
{
$pemap[property][propertyassignmenttype] = 'specialsaleprovision';
$pemap[property][propertyaddress] = 'address';
$pemap[mfunc][property][propertyaddress]['address'] = 'get_orl_streetaddress';
$pemap[property][propertycity] = 'streetcity';
$pemap[property][propertystate] = 'stateorprovince';
$pemap[property][propertyzip] = 'postalcode';
$pemap[property][propertycounty] = 'countyorparish';
$pemap[ext][propertylistingagent] = 'listagentfullname';
$pemap[ext][propertyextensionparcelapn] = 'parcelnumber';
$pemap[ext][propertyextensionmls] = 'mlsnumber';
$pemap[ext][propertyextensiondaysonmarket] = 'cdom';
$pemap[func][ext][propertyextensiondaysonmarket]['dcdomom'] = 'get_datefromnumberofdays';
$pemap[ext][propertyextensionstatus] = 'status';
$pemap[ext][propertyextensionlistdate] = '';
$pemap[ext][propertyextensionlistprice] = 'listprice';
$pemap[ext][propertyextensionsubdivision] = 'legalsubdivisionname';
$pemap[ext][propertyextensiontype] = 'propertytype';
$pemap[ext][propertyextensionbedrooms] = 'bedstotal';
$pemap[ext][propertyextensionbathrooms] = 'bathstotal';
//$pemap[mfunc][ext][propertyextensionbathrooms]['fullbaths'] = 'get_orl_bathrooms';
$pemap[ext][propertyextensionsqft] = 'sqfttotal';
$pemap[ext][propertyextensiongarage] = 'garagecarport';
$pemap[ext][propertyextensionyearbuilt] = 'yearbuilt';
$pemap[ext][propertyextensioningroundpool] = 'pool';
$pemap[ext][propertyextensionbasement] = '';
$pemap[ext][propertyextensionfinishedbasement] = '';
$pemap[ext][propertyextensionoccupancystatus] = '';
$pemap[ext][propertyextensionhoafeesforacqprops] = 'hoafee';
$pemap[mfunc][ext][propertyextensionhoafeesforacqprops]['hoafee'] = 'get_orl_hoafees';
$pemap[ext][propertyextension2012taxes] = 'taxes';
$pemap[ext][propertyextensionremarks] = 'publicremarksnew';
$pemap[ext][propertyextensionofficecode] = 'listofficemlsid';
$pemap[office][fulladdress] = '';
$pemap[office][officecode] = 'listofficemlsid';
$pemap[office][officename] = 'listofficename';
$pemap[office][officephone] = 'listofficephone';
$pemap[office][desigbroker] = 'listagentfullname';
$pemap[office][desigbrokercode] = 'listagentmlsid';
$pemap[office][designatedbrokername] = 'listagentfullname';
} //MFRMLS: Florida MLS
else if ($mls_shortname == 'OLD_MFRMLS') //MFRMLS: Florida MLS
{
$pemap[property][propertyassignmenttype] = '';
$pemap[property][propertyaddress] = 'address';
$pemap[property][propertycity] = 'city';
$pemap[property][propertystate] = 'stateid';
$pemap[property][propertyzip] = 'zipcode';
$pemap[property][propertycounty] = 'county';
$pemap[ext][propertylistingagent] = 'agentname';
$pemap[ext][propertyextensionparcelapn] = 'taxid';
$pemap[ext][propertyextensionmls] = 'mls#';
$pemap[ext][propertyextensiondaysonmarket] = 'cdom';
$pemap[ext][propertyextensionstatus] = 'status';
$pemap[ext][propertyextensionlistdate] = 'listingdate';
$pemap[ext][propertyextensionlistprice] = 'listprice';
$pemap[ext][propertyextensionsubdivision] = 'legalsubdivisionname';
$pemap[ext][propertyextensiontype] = '';
$pemap[ext][propertyextensionbedrooms] = 'beds';
$pemap[ext][propertyextensionbathrooms] = 'fullbaths';
$pemap[mfunc][ext][propertyextensionbathrooms]['fullbaths'] = 'get_orl_bathrooms';
$pemap[ext][propertyextensionsqft] = 'totalbldgsf';
$pemap[ext][propertyextensiongarage] = 'garagecarport';
$pemap[ext][propertyextensionyearbuilt] = 'yearbuilt';
$pemap[ext][propertyextensioningroundpool] = 'pool';
$pemap[ext][propertyextensionbasement] = '';
$pemap[ext][propertyextensionfinishedbasement] = '';
$pemap[ext][propertyextensionoccupancystatus] = '';
$pemap[ext][propertyextensionhoafeesforacqprops] = 'hoafee';
$pemap[mfunc][ext][propertyextensionhoafeesforacqprops]['hoafee'] = 'get_orl_hoafees';
$pemap[ext][propertyextension2012taxes] = 'taxes';
$pemap[ext][propertyextensionremarks] = 'publicremarksxp';
$pemap[ext][propertyextensionofficecode] = 'officeid#';
$pemap[office][fulladdress] = '';
$pemap[office][officecode] = 'officeid#';
$pemap[office][officename] = 'officename';
$pemap[office][officephone] = '';
$pemap[office][desigbroker] = 'agentname';
$pemap[office][desigbrokercode] = 'agentid';
$pemap[office][designatedbrokername] = 'agentname';
} //MFRMLS: Florida MLS
else if ($mls_shortname == 'FMLS') //FMLS: Georgia MLS
{
$pemap[property][propertyassignmenttype] = '';
$pemap[property][propertyaddress] = 'address';
$pemap[property][propertycity] = 'city';
$pemap[property][propertycounty] = 'county';
$pemap[property][propertystate] = 'state';
$pemap[property][propertyzip] = 'zip';
$pemap[ext][propertyextensionparcelapn] = '';
$pemap[ext][propertylistingagent] = 'listagentname';
$pemap[ext][propertyextensionstatus] = 'status';
$pemap[ext][propertyextensionlistdate] = 'modified';
$pemap[ext][propertyextensionlistprice] = 'lp';
$pemap[ext][propertyextensionyearbuilt] = 'yrblt';
$pemap[ext][propertyextensiontype] = '';
$pemap[ext][propertyextensionoccupancystatus] = '';
$pemap[ext][propertyextensionbedrooms] = 'totbeds';
$pemap[ext][propertyextensionbathrooms] = 'totfb';
$pemap[mfunc][ext][propertyextensionbathrooms]['totfb'] = 'get_fga_bathrooms';
$pemap[ext][propertyextensionsqft] = 'squarefootage';
$pemap[ext][propertyextensiongarage] = '';
$pemap[ext][propertyextensiondaysonmarket] = 'modified';
$pemap[ext][propertyextensioningroundpool] = 'pool';
$pemap[ext][propertyextensionbasement] = 'basementdesc';
$pemap[mfunc][ext][propertyextensionbasement]['basementdesc'] = 'get_fga_basement';
$pemap[ext][propertyextensionsubdivision] = 'subdcomplex';
$pemap[ext][propertyextensionhoafeesforacqprops] = 'asscfee';
$pemap[ext][propertyextensionofficecode] = 'listingofficecode';
$pemap[ext][propertyextensionmls]='fmls#';
$pemap[ext][propertyextension2012taxes]='taxes';
$pemap[ext][propertyextensionremarks] = 'publicremarks-consumerview';
$pemap[office][fulladdress] = '';
$pemap[office][officecode] = 'listingofficecode';
$pemap[office][officename] = 'listofficename';
$pemap[office][officephone] = 'listofficephone';
$pemap[office][desigbroker] = 'listagentname';
$pemap[office][desigbrokercode] = 'listagentid';
$pemap[office][designatedbrokername] = 'listagentname';
} //FMLS: Georgia MLS
else if ($mls_shortname == 'NWMLS')
{
$pemap[property][propertyassignmenttype] = 'BREO';
$pemap[func][property][propertyassignmenttype]['BREO'] = 'get_wa_assignmenttype';
$pemap[property][propertylistingagent] = '';
$pemap[property][propertyaddress] = 'HSN';
$pemap[mfunc][property][propertyaddress]['HSN'] = 'get_wa_propertyaddress';
$pemap[property][propertycity] = 'CIT';
$pemap[property][propertystate] = 'STA';
$pemap[property][propertyzip] = 'ZIP';
$pemap[property][propertycounty] = 'COU';
$pemap[ext][propertyextensionparcelapn] = 'TAX';
$pemap[ext][propertyextensionmls] = 'LN';
$pemap[ext][propertyextensiondaysonmarket] = 'CDOM';
$pemap[ext][propertyextensionstatus] = 'ST';
$pemap[ext][propertyextensionlistdate] = 'LD';
$pemap[ext][propertyextensionlistprice] = 'LP';
$pemap[ext][propertyextensionsubdivision] = 'DSR';
$pemap[ext][propertyextensiontype] = 'PTYP';
$pemap[ext][propertyextensionbedrooms] = 'BR';
$pemap[ext][propertyextensionbathrooms] = 'BTH';
$pemap[ext][propertyextensionsqft] = 'ASF';
$pemap[ext][propertyextensiongarage] = 'GAR';
$pemap[ext][propertyextensionyearbuilt] = 'YBT';
$pemap[ext][propertyextensioningroundpool] = '';
$pemap[ext][propertyextensionbasement] = 'VEW'; //place holder to just map a N back to the DB
$pemap[func][ext][propertyextensionbasement]['VEW'] = 'get_wa_basement'; //place holder to just map a N back to the DB
$pemap[ext][propertyextensionfinishedbasement] = 'VEW';
$pemap[func][ext][propertyextensionfinishedbasement]['VEW'] = 'get_wa_basement'; //place holder to just map a N back to the DB
$pemap[ext][propertyextensionoccupancystatus] = 'VEW';
$pemap[func][ext][propertyextensionoccupancystatus]['VEW'] = 'get_wa_occupancy';
$pemap[ext][propertyextensionhoafeesforacqprops] = 'HOD';
$pemap[mfunc][ext][propertyextensionhoafeesforacqprops]['HOD'] = 'get_wa_hoafees';
$pemap[ext][propertyextension2012taxes] = 'TX';
$pemap[ext][propertyextensionremarks] = 'MR';
$pemap[ext][propertyextensionofficecode] = '';
$pemap[office][fulladdress] = '';
$pemap[office][officecode] = '';
$pemap[office][officename] = '';
$pemap[office][officephone] = '';
$pemap[office][desigbroker] = '';
$pemap[office][desigbrokercode] = '';
$pemap[office][designatedbrokername] = '';
}
else if ($mls_shortname)
{
$pemap[property][propertyassignmenttype] = '';
$pemap[property][propertyaddress] = '';
$pemap[property][propertycity] = '';
$pemap[property][propertycounty] = '';
$pemap[property][propertystate] = '';
$pemap[property][propertyzip] = '';
$pemap[ext][propertyextensionparcelapn] = '';
$pemap[ext][propertylistingagent] = '';
$pemap[ext][propertyextensionstatus] = '';
$pemap[ext][propertyextensionlistdate] = '';
$pemap[ext][propertyextensionlistprice] = '';
$pemap[ext][propertyextensionyearbuilt] = '';
$pemap[ext][propertyextensiontype] = '';
$pemap[ext][propertyextensionoccupancystatus] = '';
$pemap[ext][propertyextensionbedrooms] = '';
$pemap[ext][propertyextensionbathrooms] = '';
$pemap[ext][propertyextensionsqft] = '';
$pemap[ext][propertyextensiongarage] = '';
$pemap[ext][propertyextensiondaysonmarket] = '';
$pemap[ext][propertyextensioningroundpool] = '';
$pemap[ext][propertyextensionbasement] = '';
$pemap[ext][propertyextensionsubdivision] = '';
$pemap[ext][propertyextensionhoafeesforacqprops] = '';
$pemap[ext][propertyextensionofficecode] = '';
$pemap[ext][propertyextensionmls]='';
$pemap[ext][propertyextension2012taxes]='';
$pemap[ext][propertyextensionremarks] = '';
$pemap[office][fulladdress] = '';
$pemap[office][officecode] = '';
$pemap[office][officename] = '';
$pemap[office][officephone] = '';
$pemap[office][desigbroker] = '';
$pemap[office][desigbrokercode] = '';
$pemap[office][designatedbrokername] = '';
}
return $pemap;
}
function mls_getimagehandler()
{
$querydata = mls_getquerydata();
$querydata['imagehandler'] = trim($querydata['imagehandler']);
return ($querydata['imagehandler'] != '')?$querydata['imagehandler']:false;
}
function mls_downloadimage($fromurl, $todir)
{
$ch = curl_init($fromurl);
curl_setopt($ch, CURLOPT_HEADER, 0);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
curl_setopt($ch, CURLOPT_BINARYTRANSFER, 1);
$rawdata=curl_exec($ch);
curl_close($ch);
if(file_exists($todir)){
unlink($todir);
}
$fp = fopen($todir,'x');
$r = fwrite($fp, $rawdata);
fclose($fp);
return $r;
}
/* mapping function area - start */
function formatlistdate($date)
{
return date("m/d/Y", strtotime($date));
}
function mlsbasementcheck($val)
{
if(strstr($val,base))
return "Y";
return "N";
}
function assignmenttypeshortsalecheck($val)
{
if(strstr($val,'Y'))// check to see if it has a 'y' for yes, if so, then this is a Short Sale, otherwise it is a REO
return "SHORT SALE";
return "REO";
}
function assignmenttypeshortsalecheck2($val)
{
//d(shortsale,$val);
if(stristr($val,'Short Sale'))// check to see if it has a 'Short Sale', if so, then this is a Short Sale, otherwise it is a REO
return "SHORT SALE";
return "REO";
}
function nv_importhoaannualfee($val)
{
return formathoaannualfee($val[assocfee], $val[assocfeepaymenttype]);
}
function get_ar_importhoaannualfee($val)
{
//hoafee,hoapaid(freq),hoa2fee,hoa2paid(freq)
return formathoaannualfee($val['hoafee'], $val['hoapaid(freq)'])+formathoaannualfee($val['hoa2fee'], $val['hoa2paid(freq)']);
}
function get_ar_groundpool($val)
{
if (stristr($val['pool-private'],'pool - private'))
return 'Y';
else if (stristr($val['pool-private'],'no pool'))
return 'N';
}
function fl_importhoaannualfee($val)
{
return formathoaannualfee($val[assessedva], $val[permbookms]);
}
function tn_gettotalbedrooms($val)
{
return $val[fullbaths]+($val[halfbaths]*(0.5));
}
function tx_importhoaannualfee($val)
{
return formathoaannualfee($val[mntfeeamt], $val[maintenancefeepaymentschedule]);
}
function formathoaannualfee($fee, $type)
{
$basefee = db_number($fee);
switch (trim(strtolower($type))){
case "monthly payment":
case "monthly":
case "month":
case "mo":
return ($basefee*12);
case "quarterly payment":
case "quarterly":
case "quart":
case 'qtr':
return ($basefee*4);
case "semi-annual payment":
case "semi annually":
case "semiannual":
case "semia":
case '6mo':
return ($basefee*2);
default:
return $basefee;
}
}
function get_tn_streetaddress($record)
{
$address = array();
$address[] = $record['st#'];
$address[] = $record[streetdir];
$address[] = $record[postdir];
$address[] = $record[stname];
$address[] = $record[stsuffix];
return combine_arraystrings($address);
}
function get_ca_streetaddress($record)
{
$address = array();
$address[] = $record[streetnumber];
$address[] = $record[streetnumbermodifier];
$address[] = $record[streetdirection];
$address[] = $record[streetpostdirection];
$address[] = $record[streetname];
$address[] = $record[streetsuffix];
return combine_arraystrings($address);
}
function get_ar_streetaddress($record)
{
$address = array();
$address[] = $record[housenbr];
$address[] = $record[streetdirp];
$address[] = $record[streetname];
$address[] = $record[streetdirs];
$address[] = $record[streetsuff];
return combine_arraystrings($address);
}
function get_fl_streetaddress($record)
{
$address = array();
$address[] = $record[housenbr];
$address[] = $record[streetdirp];
$address[] = $record[streetname];
$address[] = $record[streetdirs];
$address[] = $record[streetsuff];
return combine_arraystrings($address);
}
function get_tx_assignmenttype($record)
{
if(stristr($record, 'foreclosure'))
return 'foreclosure';
elseif(stristr($record, 'shortsale') || stristr($record, 'short sale'))
return 'short sale';
return '';
}
function get_dtx_importhoaannualfee($record)
{
return formathoaannualfee($record[hoadues], $record[hoafreq]);
}
function get_wa_propertyaddress($record)
{
$address = array();
$address[] = $record['HSN'];
$address[] = $record['DRP'];
$address[] = $record['STR'];
$address[] = $record['SSUF'];
$address[] = $record['DRS'];
return combine_arraystrings($address);
}
function get_wa_hoafees($record)
{
return formathoaannualfee($record[HOD], 'monthly');
}
function get_wa_basement($record)
{
return 'N';
}
function get_wa_occupancy($record)
{
return 'Vacant';
}
function get_wa_assignmenttype($record)
{
if ($record[BREO] == 'Y')
return 'REO';
else if ($record[BREO] == 'N')
return 'Equity Sale';
return $record[BREO];
}
function get_dtx_streetaddress($record)
{
$address = array();
$address[] = $record['streetnumber'];
$address[] = $record['streetdirprefix'];
$address[] = $record['streetdirsuffix'];
$address[] = $record['streetname'];
$address[] = $record['streetsuffix'];
return combine_arraystrings($address);
}
function get_dtx_groundpool($record)
{
return (trim($record[poolyn]) == 1)?'Y':'N';
}
function get_dtx_hoafees($record)
{
return formathoaannualfee($record[associationfee], $record[associationfeefrequenc]);
}
function get_odtx_streetaddress($record)
{
$address = array();
$address[] = $record['st#'];
$address[] = $record['strdir'];
$address[] = $record['strdirsuffix'];
$address[] = $record['stname'];
$address[] = $record['sttype'];
return combine_arraystrings($address);
}
function get_tx_streetaddress($record)
{
$address = array();
$address[] = $record[stnum];
$address[] = $record[stdir];
$address[] = $record[stname];
return combine_arraystrings($address);
}
function get_ga_streetaddress($record)
{
$address = array();
$address[] = $record[stn];
$address[] = $record[str];
return combine_arraystrings($address);
}
function get_ga_county($record)
{
if (trim($record) == 'De Kalb')
return 'DeKalb';
return $record;
}
function get_ga_officeaddress($record)
{
$address = array();
$address[] = $record[loadd1];
$address[] = $record[loadd2];
$address[] = $record[locity];
$address[] = $record[lostate];
$address[] = $record[lozip];
return combine_arraystrings($address);
}
function get_garagetype($record)
{
$garage = array();
$garage[] = $record[attdet];
$garage[] = $record[garcarpt];
return combine_arraystrings($garage);
}
function combine_arraystrings($arrstr, $delim = ' ')
{
foreach ($arrstr as $key => $val)
if (!$val) unset($arrstr[$key]);
return implode($delim, $arrstr);
}
function format_propertytype($record)
{
return $record[propertytype].' - '.$record[propertysubtype1];
}
function get_tn_officecode($record)
{
return $record[listofficecode].'-'.$record[listingpublicid];
}
function get_tn_officephone($record)
{
return $record[la1phon1ar].$record[la1phn1nbr];
}
function get_tn_2012taxes($record)
{
return db_number($record[anlcitytax])+db_number($record[annlcotax]);
}
function get_tn_propertylistingagent($record)
{
return $record[la1firstnm]." ".$record[la1lastnam];
}
function get_ca_officecode($record)
{
return $record[listingofficenumber].'-'.$record[listingagentmlsid];
}
function get_daysonmarket($record)
{
$nowtime = strtotime(date('Y-m-d'));
$thentime = strtotime(get_daysonmarketdate($record));
$datediff = ceil(abs($nowtime - $thentime) / 86400);
return $datediff;
}
function get_fln_propertyassignmenttype($record)
{
if ($record[foreclosedreoyn])
return 'REO';
return ($record[potentialshortsaleyn])?"Short Sale":"";
}
function get_fln_gethoafees($record)
{
return formathoaannualfee($record[hoafee], $record[hoafeefreq])+formathoaannualfee($record[masterhoafee], $record[masterhoafeefreq]);
}
function get_or_gethoafees($record)
{
return formathoaannualfee($record[hoafee], $record[hoapaymentfreq])+formathoaannualfee($record[hoafee2], $record[hoapaymentfreq2]);
}
function get_daysonmarketdate($record)
{
if ($record)
{
$record = explode('T', $record);
$thentime = $record[0];
}
else
$thentime = date('Y-m-d');
return $thentime;
}
function get_fga_basement($record)
{
return (trim($record['basementdesc']) != '')?'Y':'N';
}
function get_fga_bathrooms($record)
{
return db_number($record['totfb'])+(.5*$record['tothb']);
}
function get_ga_bathrooms($record)
{
return (1*$record['baf'])+(.5*$record['bah']);
}
function tx_imagedownload($image)
{
global $tmp_imagedir;
$fromurl = $image['Location'];
$propertyid = $image['Content-ID'];
$imageid = $image['Object-ID'];
$imagename = "image_{$propertyid}_{$imageid}.jpg";
$todir = "{$tmp_imagedir}/{$imagename}";
if (mls_downloadimage($fromurl, $todir))
$retval[$propertyid][$imageid] = $imagename;
return ($retval)?$retval:false;
}
function get_fl_bathtotal($records)
{
return $records['#fb']+($records['#hb']*.5);
}
function get_flr_hoafees($records)
{
if (strtolower($records['toa']) == 'homeowners')
return formathoaannualfee($records['fee'], $records['feepd']);
return;
}
function get_ind_hoafees($records)
{
return formathoaannualfee($records['mandfee'], $records['mndfeepd']);
}
function get_ind_address($records)
{
$address = array();
$address[] = $records[streetnumber];
$address[] = $records[streetdirprefix];
$address[] = $records[streetname];
$address[] = $records[streetdirsuffix];
$address[] = $records[streetsuffix];
return combine_arraystrings($address);
}
function get_orl_streetaddress($records)
{
if ($address = $records[address])
return $address;
$address = array();
$address[] = $records[streetnumber];
$address[] = $records[streetdirprefix];
$address[] = $records[streetname];
$address[] = $records[streetdirsuffix];
$address[] = $records[streetsuffix];
return combine_arraystrings($address);
}
function get_orl_hoafees($records)
{
return formathoaannualfee($records['hoafee'], $records['hoapaymentschedule']);
}
function get_orl_bathrooms($records)
{
return db_number($records['fullbaths'])+ (.5*db_number($records['halfbaths']));
}
function get_ind_basement($records)
{
return (trim($records['sfoptamt']) != '')?'Y':'N';
}
function get_ind_garage($records)
{
//some of the values are comma separated, I am ending
//up using the first no zero value I get, zero otherwise
foreach (explode(',', $records['garde_1309']) as $type)
{
switch (trim($type))
{
case "1CarAttach":
case "1CarDetach":
$rval = '1';
break;
case "2CarAttach":
case "2CarDetach":
$rval = '2';
break;
case "3CarAttach":
case "3CarDetach":
$rval = '3';
break;
case "4+CarAttch":
case "4+CarDet":
case "MultipleGarages":
$rval = '4+';
break;
//left the ones below so it could be
//seen which were getting skipped
case "1CarBltIn":
case "1CarCarprt":
case "2CarBltIn":
case "2CarCarprt":
case "3CarBltIn":
case "3CarCarprt":
case "4+CarBltIn":
case "None":
case "Other":
case "TANDEM":
default:
}
//d("HERE $type ".++$cnt." $rval");
if (trim($rval) != '')
return $rval;
}
return '0';
}
function get_ind_basementfinished($records)
{
return (db_number($records['%optlvlfin']) > 0)?'Y':'N';
}
function get_flr_getpropertyassignment($records)
{
if (strtolower($record[reo]) == 'y')
return 'REO';
return (strtolower($record[ssl]) == 'y')?"Short Sale":"";
}
function get_dfl_getstreetaddress($record)
{
$address = array();
$address[] = $record[streetnumber];
$address[] = $record[streetdirectionsuffix];
$address[] = $record[streetname];
return combine_arraystrings($address);
}
/* mapping function area - end */
function mls_getzipcodemap()
{
global $mls_shortname;
if ($mls_shortname == 'ARMLS')
{
$zipmap['86442'] = 'OW54TF1GIGR';
$zipmap['85019'] = 'OW542DCL8WT';
$zipmap['85018'] = 'OW542DCK6YU';
$zipmap['85017'] = 'OW542DCJ4FX';
$zipmap['85016'] = 'OW542DCI0DK';
$zipmap['85015'] = 'OW542DCGSKI';
$zipmap['85014'] = 'OW542DCFSF5';
$zipmap['85013'] = 'OW542DCENCK';
$zipmap['85012'] = 'OW542DCDIN9';
$zipmap['85011'] = 'OW54KGOSL9U';
$zipmap['85010'] = 'OW54KGMYG1H';
$zipmap['85009'] = 'OW542DCCEI3';
$zipmap['85008'] = 'OW542DCB7WX';
$zipmap['85007'] = 'OW542DCA66W';
$zipmap['85006'] = 'OW542DC8URY';
$zipmap['85005'] = 'OW54KGL08TA';
$zipmap['85004'] = 'OW542DC7OT9';
$zipmap['85003'] = 'OW542DC6LJJ';
$zipmap['85002'] = 'OW54KGJ5CFF';
$zipmap['85001'] = 'OW54KGHB432';
$zipmap['85000'] = 'OW542DC5KCU';
$zipmap['84351'] = 'OW542DC4G7A';
$zipmap['84248'] = 'OW542DC38KI';
$zipmap['84243'] = 'OW542DC25RE';
$zipmap['84242'] = 'OW542DC10GM';
$zipmap['83935'] = 'OW542DBZZBB';
$zipmap['83574'] = 'OW542DBYYAN';
$zipmap['83550'] = 'OW542DBXVE2';
$zipmap['83293'] = 'OW542DBWORS';
$zipmap['82521'] = 'OW542DBVGSO';
$zipmap['82326'] = 'OW542DBUISP';
$zipmap['82014'] = 'OW542DBTAA1';
$zipmap['78746'] = 'OW542DBS9J4';
$zipmap['78735'] = 'OW542DBR6MV';
$zipmap['58296'] = 'OW542DBNYZK';
$zipmap['58202'] = 'OW542DBMT67';
$zipmap['37320'] = 'OW542DBLOWF';
$zipmap['35035'] = 'OW542DBKM90';
$zipmap['33196'] = 'OW542DBJKTZ';
$zipmap['33176'] = 'OW542DBJ3GX';
$zipmap['33033'] = 'OW542DBHX8E';
$zipmap['29212'] = 'OW542DBGVL0';
$zipmap['25705'] = 'OW542DBFSU1';
$zipmap['15351'] = 'OW542DBEODJ';
$zipmap['3000'] = 'OW542DBDJ82'; //as defined by ARMLS
$zipmap['0'] = 'OW542DBBRCX'; //as defined by ARMLS
$zipmap['85068'] = 'OW54KJPG2M1';
$zipmap['85067'] = 'OW54KJL9Z8L';
$zipmap['85066'] = 'OW54KITCPA2';
$zipmap['85065'] = 'OW54KILBV4Q';
$zipmap['85064'] = 'OW54KIGIM41';
$zipmap['85063'] = 'OW54KIASVGI';
$zipmap['85062'] = 'OW54KI7KJED';
$zipmap['85061'] = 'OW542DDH7P1';
$zipmap['85060'] = 'OW54KI4KMRX';
$zipmap['85057'] = 'OW542DDG7W4';
$zipmap['85056'] = 'OW542DDF8Z6';
$zipmap['85055'] = 'OW54KI228JT';
$zipmap['85054'] = 'OW542DDE59T';
$zipmap['85053'] = 'OW542DDD50G';
$zipmap['85051'] = 'OW542DDBY0Z';
$zipmap['85050'] = 'OW542DDAVXF';
$zipmap['85049'] = 'OW542DD9PY3';
$zipmap['85048'] = 'OW542DD8NAJ';
$zipmap['85046'] = 'OW54KHZTZ1P';
$zipmap['85045'] = 'OW542DD7KU9';
$zipmap['85044'] = 'OW542DD6F04';
$zipmap['85043'] = 'OW542DD5ECI';
$zipmap['85042'] = 'OW542DD48PX';
$zipmap['85041'] = 'OW542DD3395';
$zipmap['85040'] = 'OW542DD1ZLE';
$zipmap['85039'] = 'OW54KH6JX01';
$zipmap['85038'] = 'OW54KH3NI87';
$zipmap['85037'] = 'OW542DD0VWZ';
$zipmap['85036'] = 'OW54KH0IS1N';
$zipmap['85035'] = 'OW542DCZUDB';
$zipmap['85034'] = 'OW542DCYRDM';
$zipmap['85033'] = 'OW542DCXLVA';
$zipmap['85032'] = 'OW542DCWHWH';
$zipmap['85031'] = 'OW542DCVC7R';
$zipmap['85030'] = 'OW54KGXC7DL';
$zipmap['85029'] = 'OW542DCUA94';
$zipmap['85028'] = 'OW542DCT1SQ';
$zipmap['85027'] = 'OW542DCS0IT';
$zipmap['85026'] = 'OW54KGTS9AK';
$zipmap['85025'] = 'OW54KGQZVQ2';
$zipmap['85024'] = 'OW542DCQTEL';
$zipmap['85023'] = 'OW542DCPSVU';
$zipmap['85022'] = 'OW542DCOM29';
$zipmap['85021'] = 'OW542DCNIPD';
$zipmap['85020'] = 'OW542DCMGWW';
$zipmap['85178'] = 'UB5EZMJD795';
$zipmap['85173'] = 'UB5EZRQNPBL';
$zipmap['85172'] = 'UB5EZRK2LWA';
$zipmap['85147'] = 'UB5EZRG5BV9';
$zipmap['85145'] = 'UB5EZRCES8M';
$zipmap['85143'] = 'UB5EZR93JKA';
$zipmap['85142'] = 'UB5EZQ266S6';
$zipmap['85141'] = 'UB5EZPROFWZ';
$zipmap['85140'] = 'UB5EZPVAL1L';
$zipmap['85139'] = 'UB5EZPMPME2';
$zipmap['85138'] = 'UB5EZPITB9V';
$zipmap['85137'] = 'UB5EZOQF12J';
$zipmap['85135'] = 'UB5EZOMN75J';
$zipmap['85132'] = 'UB5EZOHMLD8';
$zipmap['85131'] = 'UB5EZODI25H';
$zipmap['85130'] = 'UB5EZN56V9U';
$zipmap['85128'] = 'UB5EZO8XJIH';
$zipmap['85127'] = 'UB5EZO59T5B';
$zipmap['85123'] = 'UB5EZMREDJH';
$zipmap['85122'] = 'UB5EZN0H7BA';
$zipmap['85121'] = 'UB5EZMWM9NF';
$zipmap['85120'] = 'UB5EZME5FR2';
$zipmap['85119'] = 'UB5EZG5H8O7';
$zipmap['85118'] = 'UB5EZG1K42H';
$zipmap['85117'] = 'UB5EZFXMAAC';
$zipmap['85099'] = 'OW54KLLF4B8';
$zipmap['85098'] = 'OW54KLIV0WG';
$zipmap['85096'] = 'OW542DDMTA5';
$zipmap['85087'] = 'OW542DDLRTE';
$zipmap['85086'] = 'OW542DDKO8R';
$zipmap['85085'] = 'OW542DDJHK9';
$zipmap['85083'] = 'OW542DDIEGK';
$zipmap['85082'] = 'OW54KLG8WQG';
$zipmap['85080'] = 'OW54KLE9T4Q';
$zipmap['85079'] = 'OW54KLBPXED';
$zipmap['85078'] = 'OW54KL8K6RR';
$zipmap['85077'] = 'OW54KKHSIHA';
$zipmap['85076'] = 'OW54KKF0M8W';
$zipmap['85075'] = 'OW54KKCDEV0';
$zipmap['85074'] = 'OW54KK9NCTA';
$zipmap['85073'] = 'OW54KK718JF';
$zipmap['85072'] = 'OW54KK4XUQ5';
$zipmap['85071'] = 'OW54KK263P6';
$zipmap['85070'] = 'OW54KJZVESX';
$zipmap['85069'] = 'OW54KJT4W5V';
$zipmap['85241'] = 'OW5U65BHE3X';
$zipmap['85240'] = 'OW542DEN3XZ';
$zipmap['85239'] = 'OW542DEM1ST';
$zipmap['85238'] = 'OW542DEL164';
$zipmap['85237'] = 'OW542DEJT7W';
$zipmap['85236'] = 'OW542DEIOZ1';
$zipmap['85235'] = 'OW542DEHMNW';
$zipmap['85234'] = 'OW542DEGLPF';
$zipmap['85233'] = 'OW542DEFHPO';
$zipmap['85232'] = 'OW542DEEE63';
$zipmap['85231'] = 'OW542DED9GX';
$zipmap['85230'] = 'OW54TFJ2DH0';
$zipmap['85228'] = 'OW542DEC57W';
$zipmap['85227'] = 'OW542DEB16V';
$zipmap['85226'] = 'OW542DE9XMC';
$zipmap['85225'] = 'OW542DE8US5';
$zipmap['85224'] = 'OW542DE7R3H';
$zipmap['85223'] = 'OW542DE6MCR';
$zipmap['85222'] = 'OW542DE5HTA';
$zipmap['85221'] = 'OW54TCEU27P';
$zipmap['85220'] = 'OW542DE4CZ7';
$zipmap['85219'] = 'OW542DE39H5';
$zipmap['85218'] = 'OW542DE266B';
$zipmap['85217'] = 'OW54TBUCBIR';
$zipmap['85216'] = 'OW54IJACWVP';
$zipmap['85215'] = 'OW542DE14LJ';
$zipmap['85214'] = 'OWBV4KWKBPI';
$zipmap['85213'] = 'OW542DDZZ5Q';
$zipmap['85212'] = 'OW542DDYW96';
$zipmap['85211'] = 'OWBV4KTBMCJ';
$zipmap['85210'] = 'OW542DDXSKB';
$zipmap['85209'] = 'OW542DDWQ14';
$zipmap['85208'] = 'OW542DDVIM9';
$zipmap['85207'] = 'OW542DDUG36';
$zipmap['85206'] = 'OW542DDTF2E';
$zipmap['85205'] = 'OW542DDSB95';
$zipmap['85204'] = 'OW542DDRAGI';
$zipmap['85203'] = 'OW542DDQ73Q';
$zipmap['85202'] = 'OW542DDP1GT';
$zipmap['85201'] = 'OW542DDNX4Z';
$zipmap['85194'] = 'UB5EZO13EDM';
$zipmap['85193'] = 'UB5EZNWZHHV';
$zipmap['85192'] = 'UB5EZS0QZBA';
$zipmap['85191'] = 'UB5EZRWFPF4';
$zipmap['85190'] = 'UB5EZMNTGB1';
$zipmap['85290'] = 'OW54TC5YDK2';
$zipmap['85289'] = 'OW542DFO00X';
$zipmap['85287'] = 'OW5U6GZRTEY';
$zipmap['85286'] = 'OW542DFN3BI';
$zipmap['85285'] = 'OW5U6GWPC5J';
$zipmap['85284'] = 'OW542DFLWNR';
$zipmap['85283'] = 'OW542DFKRKY';
$zipmap['85282'] = 'OW542DFJNZU';
$zipmap['85281'] = 'OW542DFIK4T';
$zipmap['85280'] = 'OW542DFHIRG';
$zipmap['85279'] = 'OW5U63BXQQS';
$zipmap['85278'] = 'OW54TC0OCMX';
$zipmap['85277'] = 'OW54IJJMU0G';
$zipmap['85275'] = 'OW54IJG4U87';
$zipmap['85274'] = 'OW54IJDUAPU';
$zipmap['85273'] = 'OW542DFGBOO';
$zipmap['85272'] = 'OW542DFF6ZS';
$zipmap['85271'] = 'OW5U6CB5FGG';
$zipmap['85269'] = 'OW54TXQB1QG';
$zipmap['85268'] = 'OW542DFE41C';
$zipmap['85267'] = 'OW5U6C8E28E';
$zipmap['85266'] = 'OW542DFCW9Y';
$zipmap['85264'] = 'OW542DF747G';
$zipmap['85263'] = 'OW542DF601Q';
$zipmap['85262'] = 'OW542DF4YOW';
$zipmap['85261'] = 'OW5U6C4PWQ2';
$zipmap['85260'] = 'OW542DF3UN1';
$zipmap['85259'] = 'OW542DF2PIT';
$zipmap['85258'] = 'OW542DF1Q82';
$zipmap['85257'] = 'OW542DF0LCW';
$zipmap['85256'] = 'OW5U6C0ZGHX';
$zipmap['85255'] = 'OW542DEZEH3';
$zipmap['85254'] = 'OW542DEYALG';
$zipmap['85253'] = 'OW542DEX5Z8';
$zipmap['85252'] = 'OW5U68QNEK3';
$zipmap['85251'] = 'OW542DEW1WL';
$zipmap['85250'] = 'OW542DEUXQM';
$zipmap['85249'] = 'OW542DETU91';
$zipmap['85248'] = 'OW542DESQ85';
$zipmap['85247'] = 'OW542DERN69';
$zipmap['85246'] = 'OW54TITTQDD';
$zipmap['85245'] = 'OW5U6723GOQ';
$zipmap['85244'] = 'OW542DEQI7A';
$zipmap['85243'] = 'OW542DEPGIH';
$zipmap['85242'] = 'OW542DEOD1H';
$zipmap['85341'] = 'OW54TM7HZRW';
$zipmap['85340'] = 'OW542DGU5RJ';
$zipmap['85339'] = 'OW542DGT0EK';
$zipmap['85338'] = 'OW542DGS0IC';
$zipmap['85337'] = 'OW542DGQTES';
$zipmap['85336'] = 'OW54TXWP9OM';
$zipmap['85335'] = 'OW542DGPOTW';
$zipmap['85334'] = 'OW542DGOLQW';
$zipmap['85333'] = 'OW542DGNGTA';
$zipmap['85332'] = 'OW542DGMDDS';
$zipmap['85331'] = 'OW542DGL95N';
$zipmap['85329'] = 'OW542DGK50D';
$zipmap['85328'] = 'OW54TJ1QRXQ';
$zipmap['85327'] = 'OW542DGIZIK';
$zipmap['85326'] = 'OW542DGHUIO';
$zipmap['85325'] = 'OW542DGH057';
$zipmap['85324'] = 'OW542DGFWDI';
$zipmap['85323'] = 'OW542DGET0X';
$zipmap['85322'] = 'OW542DGDPW9';
$zipmap['85321'] = 'OW542DGCMHR';
$zipmap['85320'] = 'OW542DGBJ7R';
$zipmap['85318'] = 'OW54F1N7UC7';
$zipmap['85316'] = 'OW542DGAFF9';
$zipmap['85313'] = 'OW542DG9BDT';
$zipmap['85312'] = 'OW54TYUCVXX';
$zipmap['85311'] = 'OW54TYSA7KU';
$zipmap['85310'] = 'OW542DG87YO';
$zipmap['85309'] = 'OW542DG75Y7';
$zipmap['85308'] = 'OW542DG619B';
$zipmap['85307'] = 'OW542DG4XYL';
$zipmap['85306'] = 'OW542DG3TQY';
$zipmap['85305'] = 'OW542DG2Q6U';
$zipmap['85304'] = 'OW542DG1MGF';
$zipmap['85303'] = 'OW542DG0MNY';
$zipmap['85302'] = 'OW542DFZFO3';
$zipmap['85301'] = 'OW542DFYD78';
$zipmap['85299'] = 'OW542DFX7N0';
$zipmap['85298'] = 'OW542DFW45D';
$zipmap['85297'] = 'OW542DFUZPC';
$zipmap['85296'] = 'OW542DFTXA3';
$zipmap['85295'] = 'OW542DFSWUW';
$zipmap['85294'] = 'OW542DFRQZ0';
$zipmap['85293'] = 'OW542DFRCWB';
$zipmap['85292'] = 'OW542DFQBYZ';
$zipmap['85291'] = 'OW542DFP3YZ';
$zipmap['85392'] = 'OW542DHQ858';
$zipmap['85390'] = 'OW542DHP5AK';
$zipmap['85388'] = 'OW542DHO3N9';
$zipmap['85387'] = 'OW542DHMVNO';
$zipmap['85385'] = 'OW5U6562SWI';
$zipmap['85383'] = 'OW542DHLSCT';
$zipmap['85382'] = 'OW542DHKLBE';
$zipmap['85381'] = 'OW542DHJKXO';
$zipmap['85380'] = 'OW5U652MS1C';
$zipmap['85379'] = 'OW542DHIEHY';
$zipmap['85378'] = 'OW542DHHBVW';
$zipmap['85377'] = 'OW542DHG7L9';
$zipmap['85376'] = 'OW5U6FCCABV';
$zipmap['85375'] = 'OW542DHF2FD';
$zipmap['85374'] = 'OW542DHDYMX';
$zipmap['85373'] = 'OW542DHCU64';
$zipmap['85372'] = 'OW542DHBQ57';
$zipmap['85371'] = 'OW5U66KQSJK';
$zipmap['85369'] = 'OW5U6K1SUV1';
$zipmap['85367'] = 'OW5U6NJMUX8';
$zipmap['85366'] = 'OW5U6JYZP77';
$zipmap['85365'] = 'OW54TN8A7EK';
$zipmap['85364'] = 'OW5U6JORWE2';
$zipmap['85363'] = 'OW542DHAK5R';
$zipmap['85362'] = 'OW542DH9HW1';
$zipmap['85361'] = 'OW542DH8F1G';
$zipmap['85360'] = 'OW542DH7C4H';
$zipmap['85359'] = 'OW5U66WOE4W';
$zipmap['85358'] = 'OW542DH69H9';
$zipmap['85357'] = 'OW542DH54HH';
$zipmap['85356'] = 'OW5U6ID97ST';
$zipmap['85355'] = 'OW542DH3ZHM';
$zipmap['85354'] = 'OW542DH2Y95';
$zipmap['85353'] = 'OW542DH1QT9';
$zipmap['85352'] = 'OW5U6GR3CKB';
$zipmap['85351'] = 'OW542DH0LDI';
$zipmap['85350'] = 'OW5U6EYAH6V';
$zipmap['85349'] = 'OW5U68HZV1U';
$zipmap['85348'] = 'OW542DGZGYA';
$zipmap['85347'] = 'OW542DGYHTO';
$zipmap['85346'] = 'OW5U66TJZOB';
$zipmap['85345'] = 'OW542DGXM9A';
$zipmap['85344'] = 'OWBUQXP9NCS';
$zipmap['85343'] = 'OW542DGWGN7';
$zipmap['85342'] = 'OW542DGVD47';
$zipmap['85618'] = 'OW542DIE0K4';
$zipmap['85617'] = 'OW54TKLFT4L';
$zipmap['85616'] = 'OW542DID0PV';
$zipmap['85615'] = 'OW542DIBTD4';
$zipmap['85614'] = 'OW54TMCMEYQ';
$zipmap['85613'] = 'OW54TXFC03A';
$zipmap['85611'] = 'OW54TFFUJRH';
$zipmap['85610'] = 'OW542DIASS2';
$zipmap['85609'] = 'OW54TPIEK8J';
$zipmap['85608'] = 'OW5U61QWHAN';
$zipmap['85607'] = 'OW542DI9S27';
$zipmap['85606'] = 'OW54TJS5EXT';
$zipmap['85605'] = 'OW54TDE80W1';
$zipmap['85603'] = 'OW54TD880W3';
$zipmap['85602'] = 'OW542DI8NOD';
$zipmap['85601'] = 'OW54TC9DSBJ';
$zipmap['85554'] = 'OW542DI6QQB';
$zipmap['85553'] = 'OW542DI5KWN';
$zipmap['85552'] = 'OW542DI4GYL';
$zipmap['85551'] = 'OW5U6EVO3QY';
$zipmap['85550'] = 'OW5U68C8G04';
$zipmap['85548'] = 'OW5U689BUF0';
$zipmap['85547'] = 'OW5U64ZJZ74';
$zipmap['85546'] = 'OW542DI3GTX';
$zipmap['85545'] = 'OW542DI2AY5';
$zipmap['85544'] = 'OW542DI13PR';
$zipmap['85543'] = 'OW542DHZZJO';
$zipmap['85542'] = 'OW5U658LQJK';
$zipmap['85541'] = 'OW542DHZPXI';
$zipmap['85540'] = 'OW5U63KLL3W';
$zipmap['85539'] = 'OW542DHZ2UO';
$zipmap['85536'] = 'OW54TXSNF1X';
$zipmap['85535'] = 'OW5U61ZWUOR';
$zipmap['85534'] = 'OW5U61WJ27H';
$zipmap['85533'] = 'OW542DHY160';
$zipmap['85532'] = 'OW542DHWY3C';
$zipmap['85531'] = 'OW54TGK3RSL';
$zipmap['85530'] = 'OWBUQANKLIP';
$zipmap['85502'] = 'OW54TYWODNM';
$zipmap['85501'] = 'OW542DHVUY6';
$zipmap['85441'] = 'OW542DHUQM1';
$zipmap['85431'] = 'OW54WIJL5NH';
$zipmap['85401'] = 'OW542DHTM1N';
$zipmap['85396'] = 'OW542DHSJ76';
$zipmap['85395'] = 'OW542DHRCT4';
$zipmap['85706'] = 'OW542DIOZAD';
$zipmap['85705'] = 'OW542DINVF4';
$zipmap['85704'] = 'OW542DIMS77';
$zipmap['85703'] = 'OW54S6KPD9H';
$zipmap['85702'] = 'OW54S6IFBN0';
$zipmap['85701'] = 'OW54S6F0M8X';
$zipmap['85671'] = 'OW5UCFJPJIY';
$zipmap['85670'] = 'OW54TXI1WKX';
$zipmap['85662'] = 'OW5U63ZOMRV';
$zipmap['85658'] = 'OW54TN3A2DL';
$zipmap['85655'] = 'OW5U61TU635';
$zipmap['85654'] = 'OW5U67EAIPQ';
$zipmap['85653'] = 'OW542DILNS2';
$zipmap['85652'] = 'OW54TKG467B';
$zipmap['85651'] = 'OW542DIL77W';
$zipmap['85650'] = 'OW5U6DIY09D';
$zipmap['85648'] = 'OW5U63XBQH7';
$zipmap['85646'] = 'OW542DIKFIY';
$zipmap['85645'] = 'OW5U6I4T3AI';
$zipmap['85644'] = 'OW54TBQORTS';
$zipmap['85643'] = 'OW542DIJAIB';
$zipmap['85642'] = 'OW54TBN7GD1';
$zipmap['85641'] = 'OW542DII61X';
$zipmap['85640'] = 'OW54TBJR69W';
$zipmap['85639'] = 'OW5U6I27PWP';
$zipmap['85638'] = 'OW542DIHSKQ';
$zipmap['85637'] = 'OW54TZ57AR1';
$zipmap['85636'] = 'OW5U6DG5DF6';
$zipmap['85635'] = 'OW5U6DCVD2Q';
$zipmap['85634'] = 'OW54TM0EK6U';
$zipmap['85633'] = 'OW5U68NHK6P';
$zipmap['85632'] = 'OW54TVGONIJ';
$zipmap['85631'] = 'OW5U68KVDXF';
$zipmap['85630'] = 'OW5U6F2M1FR';
$zipmap['85629'] = 'OW542DIHDP6';
$zipmap['85628'] = 'OW542DIH17N';
$zipmap['85627'] = 'OW542DIGNH7';
$zipmap['85626'] = 'OW5U65KB9A3';
$zipmap['85625'] = 'OW542DIG7HM';
$zipmap['85624'] = 'OW54TLVQDP8';
$zipmap['85623'] = 'OW542DIF5RX';
$zipmap['85622'] = 'OW54TUCH3S3';
$zipmap['85621'] = 'OW5U625W6XL';
$zipmap['85620'] = 'OW5U63PBRVT';
$zipmap['85619'] = 'OW5U63N389D';
$zipmap['85751'] = 'OW54SEKDBG5';
$zipmap['85750'] = 'OW542DJ4QFJ';
$zipmap['85749'] = 'OW542DJ3ICS';
$zipmap['85748'] = 'OW54SEHY4I3';
$zipmap['85747'] = 'OW54SDO1A8G';
$zipmap['85746'] = 'OW542DJ2EKS';
$zipmap['85745'] = 'OW542DJ1CAA';
$zipmap['85744'] = 'OW54SDK81IP';
$zipmap['85743'] = 'OW542DJ09HS';
$zipmap['85742'] = 'OW542DIZXXF';
$zipmap['85741'] = 'OW54SCUC64X';
$zipmap['85740'] = 'OW54SCRSBY4';
$zipmap['85739'] = 'OW542DIYX36';
$zipmap['85738'] = 'OW54SBJRL1D';
$zipmap['85737'] = 'OW542DIXSQE';
$zipmap['85736'] = 'OW542DIWPDK';
$zipmap['85735'] = 'OW54SBCDDP5';
$zipmap['85734'] = 'OW54SB9MSUZ';
$zipmap['85733'] = 'OW54SB7DG9Z';
$zipmap['85732'] = 'OW54SB52OUU';
$zipmap['85731'] = 'OW54SACFSA6';
$zipmap['85730'] = 'OW542DIVNV7';
$zipmap['85729'] = 'OW54SA6WDCM';
$zipmap['85728'] = 'OW54SA3Q2EW';
$zipmap['85727'] = 'OW54SA11SWR';
$zipmap['85726'] = 'OW54S9XV22N';
$zipmap['85725'] = 'OW54S9VM9JE';
$zipmap['85724'] = 'OW54S9TC86E';
$zipmap['85723'] = 'OW54S9Q80P4';
$zipmap['85722'] = 'OW54S9NVM4P';
$zipmap['85721'] = 'OW54S9L7EVX';
$zipmap['85720'] = 'OW54S9HB671';
$zipmap['85719'] = 'OW54S9ETTEF';
$zipmap['85718'] = 'OW54S8MXHLJ';
$zipmap['85717'] = 'OW54S8KEWYF';
$zipmap['85716'] = 'OW542DIUHJ1';
$zipmap['85715'] = 'OW54S8EHKCE';
$zipmap['85714'] = 'OW54S8BLB2H';
$zipmap['85713'] = 'OW542DITCUI';
$zipmap['85712'] = 'OW542DISBFR';
$zipmap['85711'] = 'OW542DIR7G7';
$zipmap['85710'] = 'OW542DIQ3SG';
$zipmap['85709'] = 'OW54S7WMCL0';
$zipmap['85708'] = 'OW54S7SCSNP';
$zipmap['85707'] = 'OW54S71EYN2';
$zipmap['86022'] = 'OW54TFDDCFR';
$zipmap['86021'] = 'OW54TJZ9VTL';
$zipmap['86020'] = 'OW54TFBAWQH';
$zipmap['86018'] = 'OW542DJY9K0';
$zipmap['86017'] = 'OW542DJX7B7';
$zipmap['86016'] = 'OW542DJW0BC';
$zipmap['86015'] = 'OW542DJUWQP';
$zipmap['86011'] = 'OW5U637R8GI';
$zipmap['86005'] = '15B31AMQ46WG';
$zipmap['86004'] = 'OW542DJTTPR';
$zipmap['86003'] = 'OW5U62GRQEO';
$zipmap['86002'] = 'OW5U62E921V';
$zipmap['86001'] = 'OW542DJSQNI';
$zipmap['85942'] = 'OW5U6ESIFUD';
$zipmap['85941'] = 'OW5U6IGIBXJ';
$zipmap['85940'] = 'OW542DJROHY';
$zipmap['85939'] = 'OW542DJQIQ4';
$zipmap['85938'] = 'OW542DJPC9S';
$zipmap['85937'] = 'OW542DJOC7E';
$zipmap['85936'] = 'OW5U6F8O5KM';
$zipmap['85935'] = 'OW542DJN405';
$zipmap['85934'] = 'OW542DJLOPH';
$zipmap['85933'] = 'OW542DJKKN5';
$zipmap['85932'] = 'OW542DJJG0Q';
$zipmap['85931'] = 'OW542DJIQB4';
$zipmap['85930'] = 'OW54TNBYG0L';
$zipmap['85929'] = 'OW542DJHLEU';
$zipmap['85928'] = 'OW542DJGJ2R';
$zipmap['85927'] = 'OW542DJFE3P';
$zipmap['85926'] = 'OW54TX7X3WK';
$zipmap['85925'] = 'OW542DJE9SY';
$zipmap['85924'] = 'OW542DJD5F9';
$zipmap['85923'] = 'OW542DJC4CY';
$zipmap['85922'] = 'OW542DJB1L4';
$zipmap['85920'] = 'OW542DJ9UD9';
$zipmap['85912'] = 'OW5U6IS4F1J';
$zipmap['85911'] = 'OW54TIY16IR';
$zipmap['85902'] = 'OW542DJ8PWM';
$zipmap['85901'] = 'OW542DJ7MJN';
$zipmap['85777'] = 'OWBVA85511W';
$zipmap['85775'] = 'OWBVABKGWB0';
$zipmap['85757'] = 'OW542DJ6J3R';
$zipmap['85755'] = 'OW542DJ5DK9';
$zipmap['85754'] = 'OWBVA7ZD410';
$zipmap['85752'] = 'OW54SEN6JWX';
$zipmap['86324'] = 'OW542DKLDYE';
$zipmap['86323'] = 'OW542DKKB67';
$zipmap['86322'] = 'OW542DKJ655';
$zipmap['86321'] = 'OW54TCCAFUC';
$zipmap['86320'] = 'OW542DKI0EH';
$zipmap['86315'] = '12EH4CWBWR57';
$zipmap['86314'] = 'OW542DKGX68';
$zipmap['86313'] = 'OW5U66O05O1';
$zipmap['86312'] = 'OW5UC2KO60Y';
$zipmap['86305'] = 'OW542DKFRP0';
$zipmap['86304'] = 'OW542DKER2Q';
$zipmap['86303'] = 'OW542DKDJLR';
$zipmap['86302'] = 'OW5U66QB7UF';
$zipmap['86301'] = 'OW542DKCG5V';
$zipmap['86268'] = 'OW542DKBBEI';
$zipmap['86260'] = 'OW542DKA9AS';
$zipmap['86258'] = 'OW542DK953U';
$zipmap['86235'] = 'OW542DK80LJ';
$zipmap['86205'] = 'OW542DK7019';
$zipmap['86204'] = 'OW542DK5W8V';
$zipmap['86086'] = 'OW542DK5F9W';
$zipmap['86054'] = 'OW5U6D7H7RP';
$zipmap['86053'] = 'OW54TQCHHPV';
$zipmap['86052'] = 'OW54TX1D1CU';
$zipmap['86047'] = 'OW542DK4DNL';
$zipmap['86046'] = 'OW542DK3AH4';
$zipmap['86045'] = 'OW542DK27UU';
$zipmap['86044'] = 'OW5U66ZAPKD';
$zipmap['86043'] = 'OW54TNSP6BF';
$zipmap['86042'] = 'OW5U62BA7WO';
$zipmap['86040'] = 'OW542DK1JYM';
$zipmap['86039'] = 'OW54TLECD91';
$zipmap['86038'] = 'OW542DK0HB5';
$zipmap['86036'] = 'OW54TN5RYKU';
$zipmap['86035'] = 'OW54TLP0HEJ';
$zipmap['86034'] = 'OW54TPC9LK3';
$zipmap['86033'] = 'OW54TGOPWMB';
$zipmap['86032'] = 'OW54TPKLRFM';
$zipmap['86031'] = 'OW54TP7AHWX';
$zipmap['86030'] = 'OW54TVVXFHD';
$zipmap['86029'] = 'OW54TVQ2HVJ';
$zipmap['86028'] = 'OW54TVNK8RB';
$zipmap['86025'] = 'OW54TVKPPPV';
$zipmap['86024'] = 'OW542DJZCU3';
$zipmap['86023'] = 'OW5U6I7CTFL';
$zipmap['86441'] = 'OW5U61NL1L7';
$zipmap['86440'] = 'OW542DL58C7';
$zipmap['86439'] = 'OW54TEZG726';
$zipmap['86438'] = 'OW5U6IXRX5W';
$zipmap['86437'] = 'OW54TSOC8I0';
$zipmap['86436'] = 'OW54TYZ1Y59';
$zipmap['86435'] = 'OW5U6FFF32L';
$zipmap['86434'] = 'OW54TYPMF5K';
$zipmap['86433'] = 'OW5U6429ND3';
$zipmap['86432'] = 'OW54TLS6KSV';
$zipmap['86431'] = 'OW54WG49BWI';
$zipmap['86430'] = 'OW54TDSQ7HX';
$zipmap['86429'] = 'OW54TDOTVM1';
$zipmap['86427'] = 'OW54TDM3JLM';
$zipmap['86426'] = 'OW54TDIEFHR';
$zipmap['86413'] = 'OW54TR7BSMY';
$zipmap['86412'] = 'OW54TSHVT5L';
$zipmap['86411'] = 'OW54TR1PXMJ';
$zipmap['86409'] = 'OW542DL4522';
$zipmap['86406'] = 'OW542DL2ZUI';
$zipmap['86405'] = 'OW54TUMK103';
$zipmap['86404'] = 'OW542DL1V5L';
$zipmap['86403'] = 'OW54TUJWK5L';
$zipmap['86402'] = 'OW54TQQSDTX';
$zipmap['86401'] = 'OW54TQO34FC';
$zipmap['86364'] = 'OWBVAMT4FZC';
$zipmap['86351'] = 'OW542DL0U96';
$zipmap['86343'] = 'OW542DKZOOP';
$zipmap['86342'] = 'OW54TSYXK42';
$zipmap['86341'] = 'OW5U6D4YRJI';
$zipmap['86340'] = 'OW5U6CE7XVT';
$zipmap['86339'] = 'OW542DKYML4';
$zipmap['86338'] = 'OW542DKXIOF';
$zipmap['86337'] = 'OW542DKWIBQ';
$zipmap['86336'] = 'OW542DKVC8B';
$zipmap['86335'] = 'OW542DKUAZA';
$zipmap['86334'] = 'OW542DKT4W4';
$zipmap['86333'] = 'OW542DKS3JE';
$zipmap['86332'] = 'OW542DKQVUF';
$zipmap['86331'] = 'OW54TPFT5O0';
$zipmap['86330'] = 'OW54TP9HER4';
$zipmap['86329'] = 'OW542DKPT3F';
$zipmap['86327'] = 'OW542DKOPV5';
$zipmap['86326'] = 'OW542DKNKXT';
$zipmap['86325'] = 'OW542DKMJ38';
$zipmap['96740'] = 'OW542DLL9IQ';
$zipmap['96353'] = 'OW542DLK7TJ';
$zipmap['95338'] = 'OW542DLJ778';
$zipmap['89327'] = 'OW542DLI4RK';
$zipmap['89297'] = 'OW542DLFS90';
$zipmap['87420'] = 'OWBURF9OYGW';
$zipmap['87401'] = 'OWBV9OIRZ1S';
$zipmap['86601'] = 'OW542DL695J';
$zipmap['86556'] = 'OW54TIPTV66';
$zipmap['86547'] = 'OW54TIKP23U';
$zipmap['86545'] = 'OW54TICPYZH';
$zipmap['86544'] = 'OW5U6GTK0QL';
$zipmap['86540'] = 'OW5U63SEA45';
$zipmap['86538'] = 'OW54TI3QCNR';
$zipmap['86535'] = 'OW54TKNSSPH';
$zipmap['86520'] = 'OW54TDBUFMZ';
$zipmap['86515'] = 'OW5U6IJ527W';
$zipmap['86514'] = 'OW54TNKJ04N';
$zipmap['86512'] = 'OW5U68F2HBN';
$zipmap['86511'] = 'OW54TKJ2H3I';
$zipmap['86510'] = 'OW5U65HO5XY';
$zipmap['86508'] = 'OW54TM9POZH';
$zipmap['86507'] = 'OW54TGUM6CZ';
$zipmap['86506'] = 'OW54TVZL9AG';
$zipmap['86505'] = 'OW54TK3TMG0';
$zipmap['86504'] = 'OW54TXARJKQ';
$zipmap['86503'] = 'OW54TGS2LVB';
$zipmap['86502'] = 'OW54TGMOF0D';
$zipmap['86446'] = 'OW54TF6ZT47';
$zipmap['86445'] = 'OW54TSRJ3QR';
$zipmap['86444'] = 'OW54TNI6RH2';
$zipmap['86443'] = 'OWBV9UL0PI1';
}
return $zipmap;
}
?>