$branchInfo=Db::name('Branch')->where('b_id','250')->find();

        $map['p.cate_id']=array('eq',5);

        $map['b.lng']=array('neq','');

        $map['b.lat']=array('neq','');

        $map['b.b_id']=array('neq',250);

        $branchGoodsList=Db::name('BranchStock')->alias('s')->field("s.s_id,s.s_stock,p.p_name,p.p_code,p.p_size,p.p_color,b.*,(6378.138 * 2 * asin(sqrt(pow(sin((lat * pi() / 180 - ".$branchInfo['lat']." * pi() / 180) / 2),2) + cos(lat * pi() / 180) * cos(".$branchInfo['lat']." * pi() / 180) * pow(sin((lng * pi() / 180 - ".$branchInfo['lng']." * pi() / 180) / 2),2))) * 1000) as distance")->join('think_products p','s.g_id=p.p_id','LEFT')->join('think_branch b','s.b_id=b.b_id','LEFT')->group('s.b_id')->where($map)->order('distance')->select();

        foreach($branchGoodsList as $k=>$v){

            $branchGoodsList[$k]['distance']=round($v['distance']/1000,2).'Km';

        }