Limit a Geocoder multi pin map to a radius from a visitor entered Zip/Postal code

Thanks for the thorough response Daniel,

I'll implement this first thing in the morning.

Jerry Kornbluth

Hi Daniel,

Got everything working as it should and added some MySQL where arguments to exclude admin and junior admin records from being included in the map.

I’m still stuck on one issue, and that is excluding records that have not been updated in 6 months from being included in the search results.

I’ve been doing this successfully as part of a foreach loop with if statements but can’t figure out how to translate the concept to MySQL

Here’s what I’m up to in the MySQL at the moment:

// get records
list($myRecords, $myMetaData) = getRecords(array(
'tableName' => $GLOBALS['GEOCODER_SAMPLE_TABLENAME'],
'where' => " (isAdmin = '0' OR isAdmin = '') AND (notAdmin = '0' OR notAdmin = '')",


) + $geoOptions); // geoOptions WILL NOT override the above options

And here’s how I’ve been handling the exclusions in the foreach situation.

<?php foreach ($myRecords as $record): ?>
<?php
$updateUnixTime = strtotime( $record['updatedDate'] ); // seconds since 1970
$sixMonths = time() - (180*60*60*24) ;
$sixMonthsGone = $updateUnixTime > $sixMonths;

?>
<?php if(@$_REQUEST['save'] && !$record['isAdmin'] == ‘1' && !$record['notAdmin'] == '1' && ( $sixMonthsGone) ):?>
<br />
Display the valid record information here.

<?php endif ?>

<?php endforeach ?>

I know it's asking a lot, but could you offer some of your expert guidance on this?

Thanks,

Jerry Kornbluth

Hey Jerry,

It sounds like you're asking how to exclude the older records within the WHERE clause, rather than skipping them with PHP? If that's the case, you can do so relatively easily, as you can use comparison operators on datetime values in MySQL so long as it's the right format ("yyyy-mm-dd hh:mm:ss"). This format can be produced in PHP with the date() function format "Y-m-t H:i:s".

Also, a helpful tidbit is that strtotime() can use relative date formats (http://php.net/manual/en/datetime.formats.relative.php), so you can use things like strtotime( "6 months ago" ); to save yourself some math.

Putting that all together will give you something like this:

$sixMonthsAgo = strtotime( '6 months ago' );

// get records
list($myRecords, $myMetaData) = getRecords(array(
  'tableName' => $GLOBALS['GEOCODER_SAMPLE_TABLENAME'],
  'where' => " (isAdmin = '0' OR isAdmin = '') AND (notAdmin = '0' OR notAdmin = '') AND updatedDate > '" . date('Y-m-t H:i:s', $sixMonthsAgo) . "'", 
) + $geoOptions); // geoOptions WILL NOT override the above options

Hope that helps!

Cheers,

Wow! Thanks Daniel,

So this will look at all the records updatedDate field and if the date is more than 6 months old not include that record in the list?

Seems really easy (when you know what you're doing!)...

Jerry Kornbluth

Hey Jerry,

I'd make sure to do some thorough testing to make sure that it's limiting the records appropriately, but yes that's the idea!

Glad to help.