szcollect_admin2/application/api/controller/Area.php

<?php

// +----------------------------------------------------------------------
// | ThinkAdmin
// +----------------------------------------------------------------------
// | 版权所有 2014~2019 广州楚才信息科技有限公司 [ http://www.cuci.cc ]
// +----------------------------------------------------------------------
// | 官方网站: http://demo.thinkadmin.top
// +----------------------------------------------------------------------
// | 开源协议 ( https://mit-license.org )
// +----------------------------------------------------------------------
// | gitee 代码仓库：https://gitee.com/zoujingli/ThinkAdmin
// | github 代码仓库：https://github.com/zoujingli/ThinkAdmin
// +----------------------------------------------------------------------

namespace app\api\controller;

use app\common\controller\Api;
use library\File;
use think\Db;
/**
 * @title 地址库
 * @controller Area
 * @group common
 */
class Area extends Base
{
    /**
     * @title 获取省市区
     * @desc 获取省市区
     * @author QC
     * @url /api/Area/getAllArea
     * @method GET
     * @tag 省市区
     */
    public function getAllArea(){
        $area_set = Db::table('platform_set')->where('name','all_area')->find();
        if(!empty($area_set) && $area_set['content']) {
           $list = json_decode($area_set['content'],true);
        }else{
            $field=['id','pid','shortname','name'];
            $list=Db::table('store_area')->where('pid',0)->field($field)->select();
            foreach ($list as $k=>&$v){
                $v['children']= Db::table('store_area')->where('pid',$v['id'])->field($field)->select();
                if(!empty($v['children'])){
                    foreach ($v['children'] as $kk=>&$vv){
                        $vv['children']=Db::table('store_area')->where('pid',$vv['id'])->field($field)->select();
                    }
                }
            }
            if(!empty($area_set)){
                Db::table('platform_set')->where('name','all_area')->update(['content'=>json_encode($list)]);
            }else{
                Db::table('platform_set')->insert(['name'=>'all_area','content'=>json_encode($list)]);
            }
        }
        $this->success('获取成功',$list);
    }

    /**
     * @title 获取下级地区
     * @desc 获取下级地区
     * @author QC
     * @url /api/Area/getChildrenArea
     * @method GET
     * @param  name:id type:int  default:1 desc:省id或市id
     */
    public function getChildrenArea()
    {
        $field=['id','pid','shortname','name'];
        $list=Db::table('store_area')->where('pid',$this->request->get('id'))->field($field)->select();
        $this->success('获取成功',$list);
    }

    /**
     * 获取定位城市
     */
    public function getCity(){
        $list=Db::table('store_area')->where('level',2)->field('first')->group('first')->order('first asc')->select();
        $field=['id','pid','shortname','name','first'];
        foreach ($list as $k=>&$v){
            $v['list']=Db::table('store_area')->where('level',2)->where('first',$v['first'])->field($field)->select();
        }
        $hot=Db::table('store_area')->whereIn('id',[2,802,1965])->field($field)->select();
        $history=Db::table('store_area')->whereIn('id',[2,802,1965])->field($field)->select();
        array_unshift($list,['first'=>'历史','list'=>$history],['first'=>'热门城市','list'=>$hot]);
        $this->success('获取成功',$list);
    }

    /**
     * @title 通过省市区id返回具体地址信息
     * @desc 通过省市区id返回具体地址信息
     * @author QC
     * @url /api/Area/getCity
     * @method GET
     * @tag 省市区
     */
    public function get_area($province_id,$city_id,$county_id){
        $province = '';
        if(!empty($province_id)){
            $quarters = Db::name('store_area')->field('name')->where('id',$province_id)->find();
            $province = $quarters['name'];
        }
        $city = '';
        if(!empty($city_id)){
            $quarters = Db::name('store_area')->field('name')->where('id',$city_id)->find();
            $city = $quarters['name'];
        }
        $county = '';
        if(!empty($county_id)){
            $quarters = Db::name('store_area')->field('name')->where('id',$county_id)->find();
            $county = $quarters['name'];
        }
        return $province.$city.$county;
    }
    /**
     * 通过省市区名称返回省市区id
     */
    public function get_area_id($province = '',$city = '',$county = ''){
        $province_id = '';
        if(!empty($province)){
            $province_id = Db::name('store_area')->where('name',$province)->value('id');
        }
        $city_id = '';
        if(!empty($city)){
            $city_id = Db::name('store_area')->where('name',$city)->value('id');
        }
        $county_id = '';
        if(!empty($county)){
            $county_id = Db::name('store_area')->where('name',$county)->value('id');
        }
        return $province_id.$city_id.$county_id;
    }
    /**
     * 通过id获取名称
     */
    public function get_name($id){
        $quarters = Db::name('store_area')->field('name')->where('id',$id)->find();
        return $quarters['name'];
    }
    /**
     * 通过省/市的ID获取所有县区ID
     * $type 1代表省 2代表市
     */
    public function get_county_id($id,$type=1){
        $county_id_str = '';
        if($type == 1){
            $city_id_arr = Db::name('store_area')->field('id')->where('pid',$id)->column('id');
            foreach ($city_id_arr as $value){
                $county_id_arr = Db::name('store_area')->field('id')->where('pid',$value)->column('id');
                $county_id_str .= implode(',',$county_id_arr).',';
            }
        }else{
            $county_id_arr = Db::name('store_area')->field('id')->where('pid',$id)->column('id');
            $county_id_str .= implode(',',$county_id_arr).',';
        }
        return substr($county_id_str,0,strlen($county_id_str)-1);
    }
    /**
     * 通过省的ID获取所有市的ID
     */
    public function get_city_id($id){
        $city_id_arr = Db::name('store_area')->field('id')->where('pid',$id)->column('id');
        return implode(',',$city_id_arr);
    }
    /**
     * 通过市的ID获取省的ID
     */
    public function get_province_id($id){
        $province_id = Db::name('store_area')->field('id')->where('id',$id)->value('pid');
        return $province_id;
    }
}