/** 附近的商家*/
public functionget_near_business() {if (!$this->validate->validate(‘lng‘, [‘require‘,‘regex|-?((0|1?[0-7]?[0-9]?)(([.][0-9]{1,4})?)|180(([.][0]{1,4})?))‘])) { // 经度
$this->json->setErr(10001,‘缺少lng或lng格式不正确‘);
$this->json->Send();
}
if (!$this->validate->validate(‘lat‘, [‘require‘,‘regex|-?((0|[1-8]?[0-9]?)(([.][0-9]{1,4})?)|90(([.][0]{1,4})?))‘])) { // 纬度
$this->json->setErr(10001,‘缺少lat或lng格式不正确‘);
$this->json->Send();
}
if (!isset($_POST[‘page‘]) || $_POST[‘page‘] < 1) {
$_POST[‘page‘] = 1;
}
// 分页获取附近的商家信息
$sql_count = "SELECT id, `name`,( 6371 * acos (
cos ( radians(".$_POST[‘lat‘].") )
* cos( radians( lat ) )
* cos( radians( lng ) - radians(".$_POST[‘lng‘].") )
+ sin ( radians(".$_POST[‘lat‘].") )
* sin( radians( lat ) )
)
) AS distance
FROM tf_my_business
WHERE `status` = 1
HAVING distance < 10";
$count = count(M()->query($sql_count));
$hasPage = ceil($count / C(‘PAGE.LIMIT‘));
$hasPage = $hasPage ? $hasPage : 1;
if ($_POST[‘page‘] > $hasPage) {
$this->json->setErr(10002,‘页数有误‘);
$this->json->Send();
}
$limit = (($_POST[‘page‘] - 1) * C(‘PAGE.LIMIT‘)) . "," .C(‘PAGE.LIMIT‘);
$sql_list = "SELECT `id`,`name`,`info`,( 6371 * acos (
cos ( radians(".$_POST[‘lat‘].") )
* cos( radians( lat ) )
* cos( radians( lng ) - radians(".$_POST[‘lng‘].") )
+ sin ( radians(".$_POST[‘lat‘].") )
* sin( radians( lat ) )
)
) AS distance
FROM tf_my_business
WHERE `status` = 1
HAVING distance < 10
ORDER BY distance ASC
LIMIT ".$limit;
$datalist = M()->query($sql_list);
if ($datalist) {
// 处理datalist
$my_business_img_model = M(‘my_business_img‘);
foreach ($datalist as &$v) {
// 获取主图
$my_business_img_info = $my_business_img_model->where([‘m_b_id‘=>$v[‘id‘],‘type‘=>1,‘is_main‘=>1])->find();
$v[‘img‘] = $my_business_img_info[‘img‘];
if (strpos($v[‘img‘],‘cdn‘) === false) {
$v[‘img‘] = C(‘CDN.URI‘).$v[‘img‘];
}
}
$data[‘datalist‘] = $datalist;
$data[‘current_page‘] = $_POST[‘page‘];
$data[‘hasPage‘] = $hasPage;
$this->json->setErr(0,‘获取成功‘);
$this->json->setAttr(‘data‘,$data);
$this->json->Send();
} else {
$this->json->setErr(10003,‘暂无数据‘);
$this->json->Send();
}
}