微擎实现按距离由近到远推荐附近商户

admin

代码如下：

1. $pindex = max(1, intval($_GPC['page']));
   
2.     $psize = 15;
   
3.     $condition = " WHERE uniacid=:uniacid AND adcode=:adcode";
   
4.     $params = array(
   
5.         ':uniacid' => $_W['uniacid'],
   
6.         ':adcode' => $adcode
   
7.     );
   
8.     if (!empty(trim($_GPC['keyword']))) {
   
9.         $condition .= " AND name LIKE :keyword";
   
10.         $params[':keyword'] = "%".trim($_GPC['keyword'])."%";
    
11.     }
    
12.     // 数量
    
13.     $total = pdo_fetchcolumn('SELECT COUNT(*) FROM ' .tablename('new_hexiao_merchant'). $condition, $params);
    
14.     $condition .= ' ORDER BY distance ASC LIMIT ' . ($pindex - 1) * $psize . ',' . $psize;
    
15.     if ($total > 0) {
    
16.         // 商户
    
17.         $list = pdo_fetchall("SELECT *, (6371 * acos(cos(radians($lat)) * cos(radians(lat)) * cos(radians(lng) - radians($lng)) + sin(radians($lat)) * sin(radians(lat)))) AS distance FROM " .tablename('new_hexiao_merchant'). $condition, $params);
    
18.         foreach ($list as &$row) {
    
19.             $row['distance'] = number_format($row['distance'], 2);
    
20.         }
    
21.         unset($row);
    
22.     }
    
23.     // 页码
    
24.     $pages = diypager($total, $pindex, $psize);

复制代码

适合为用户推荐附近的加油站，自提点，商户等。