时间:2021-07-01 10:21:17 帮助过:8人阅读
$_BCACHE->cachesql('shopsearch', 'SELECT i.itemid,m.mapapimark,m.itemid FROM '.DB::table('shopitems').' i LEFT JOIN '.DB::table('shopmessage').' m ON i.itemid=m.itemid WHERE m.mapapimark!="" ', 0, 1, $tpp, 0, 'index', 'shop');
$multipage = $_SBLOCK['shopsearch_multipage'];
$resultcount = $_SBLOCK['shopsearch_listcount'];
foreach($_SBLOCK['shopsearch'] as $value) {
$value = $_BCACHE->getshopinfo($value['itemid']);
//商家坐标数据处理
$value['X_preg1'] = preg_replace('/\(/', '', $value['mapapimark']);//去除X坐标前面的括号
$value['storeX'] = preg_replace('/,(.*)/','',$value['X_preg1']);//去除Y坐标以及前面的逗号,只保留X坐标
$value['Y_preg1'] = preg_replace('/\)/', '', $value['mapapimark']);//去除Y坐标后面的括号
$value['storeY'] = preg_replace('/(.*),/', '',$value['Y_preg1']);//去除X坐标以及后面的逗号,只保留Y坐标
$value['juli'] = GetDistance($ClientY,$ClientX,$value['storeY'],$value['storeX'], 2);
$value['juli'] = round($value['juli'],2);
if($value['juli'] <= $Distance){
$shoplist[] = $value;
}
}