Displaying Results

Hi Shawn

Thanks for posting!

My first though here is to just have two different record sets (using getRecords).  One will be just for the checkboxed listings and then one for there rest.  This way, you can have the distance search incorrporated as well as keeping the checkboxed items at the top and the rest below. 

Do you think that would work? 

Hi Ross!

I think that is how i have it set up right now. But I actually need everything all mixed together. 

- Shawn

Hi,

Im just wondering if anyone else had any thoughts on this. I've been looking at it more, and I am pretty stumped.

Hi shawnpatoka,

I think it's more difficult and complicated to have to deal with merging and sorting the two recordsets. If you can get away with it (and it seems like you can in this case,) you may find it easier to use a single getRecords() call and split the list apart by skipping over records using IF and CONTINUE. Here's an example of what I mean:

<?php header('Content-type: text/html; charset=utf-8'); ?>
<?php require_once "cmsAdmin/lib/viewer_functions.php"; ?>
<?php if (!@$GLOBALS['GEOCODER_PLUGIN']) { die("You must activate the Geocoder plugin before you can access this page."); } ?>
<?php

  $kmOrMiles = 'miles'; // can be 'miles' or 'km'

  // set default values
  if (!array_key_exists('fromAddress', $_REQUEST)) { $_REQUEST['fromAddress'] = '10001'; }      // this is the default address/postalcode if none entered
  if (!@$_REQUEST['maxDistance'])                  { $_REQUEST['maxDistance'] = '50000'; } // this will include all results

  // get coordinates
  list($myLat, $myLng) = geocodeAddress( @$_REQUEST['fromAddress'] );

  // error checking
  $errorsAndAlerts = '';
  if (@$_REQUEST['search']) {
    if     (!@$_REQUEST['fromAddress']) { $errorsAndAlerts .= "No address entered!<br/>\n"; }
    elseif (!$myLat || !$myLng)         { $errorsAndAlerts .= "We couldn't determine your location, please try again!<br/>\n"; }
  }

  // get records
  $addressRecords = array();
  if ($myLat && $myLng) {
    $maxDist = floatval(@$_REQUEST['maxDistance']);
    list($addressRecords, $addressMetaData) = getRecords(array(
      'tableName'     => 'participating_bars',
      'addSelectExpr' => geocoder_getSelectExprForDistance($myLat, $myLng, '_distance', $kmOrMiles), // adds '_distance' field to output records
      'where'         => geocoder_getWhereForDistanceWithin($myLat, $myLng, $maxDist, $kmOrMiles),   // optimization: remove results outside of minimum bounding rectangle
      'having'        => "_distance <= " . $maxDist, // only show results within max distance
      'orderBy'       => 'ISNULL(_distance), _distance', // sort nearest records first -and- unknown or undefined distances last
    ));
  }

?>

List in order by distance:
<ul>
  <?php foreach ($addressRecords as $record): ?>
    <li><?php echo htmlencode($record['title']) ?></li>
  <?php endforeach ?>
</ul>

List in order of stars:
<ul>

  <!-- first, only list platinums by skipping over everything that doesn't have the 'platinum' field checked -->
  <?php foreach ($addressRecords as $record): ?>
    <?php if (!$record['platinum']) { continue; } ?>
    <li><?php echo htmlencode($record['title']) ?></li>
  <?php endforeach ?>

  <!-- next, only list golds by skipping over everything that doesn't have the 'gold' field checked -->
  <?php foreach ($addressRecords as $record): ?>
    <?php if (!$record['gold']) { continue; } ?>
    <li><?php echo htmlencode($record['title']) ?></li>
  <?php endforeach ?>

  <!-- next, only list silvers by skipping over everything that doesn't have the 'silver' field checked -->
  <?php foreach ($addressRecords as $record): ?>
    <?php if (!$record['silver']) { continue; } ?>
    <li><?php echo htmlencode($record['title']) ?></li>
  <?php endforeach ?>

  <!-- finally, list everything else by skipping over everything that has either the 'platinum', 'gold', or 'silver' field checked -->
  <?php foreach ($addressRecords as $record): ?>
    <?php if ($record['platinum'] || $record['gold'] || $record['silver']) { continue; } ?>
    <li><?php echo htmlencode($record['title']) ?></li>
  <?php endforeach ?>

</ul>


Does that help?

Hi Chris, 

Thanks for helping me out! I really appreciate it.

But with your bottom example, that would essentially group the starred items on top and the rest below? The 'Silver' , 'Gold' ,and 'Platinum' are basically just names for templates. 'Platinum' results would link to a.php(then the record link), 'Gold' results would link to b.php(then the record link), and Silver would link to c.php(then the record link).    But when someone types in their zip code on the homepage, the results should be in order by distance, not if they are a starred listing or not. That's where i think it would get hard, because some of the results should not be links and some should link to a.php(then the record link), some should link to b.php(then the record link), and some c.php(then the record link).

Your top one would be ideal, but how could i get certain ones to link to certain templates, and some not link anywhere?

Let me know if this makes sense or not, or if Im just explaining it weird lol.

Thanks again!

Hi,

I'm not on my regular computer to test it out, but that does look like it should work.

thank you guys very much! I really appreciate it.