xyzshop/data/model/area.model.php

<?php
/**
 * 地区模型
 *
 
 */
defined('InShopNC') or exit('Access Invalid!');

class areaModel extends Model {

    public function __construct() {
        parent::__construct('area');
    }

    /**
     * 获取地址列表
     *
     * @return mixed
     */
    public function getAreaList($condition = [], $fields = '*', $group = '') {
        return $this->where($condition)->field($fields)->limit(false)->group($group)->select();
    }

    /**
     * 获取地址详情
     *
     * @return mixed
     */
    public function getAreaInfo($condition = [], $fileds = '*') {
        return $this->where($condition)->field($fileds)->find();
    }

    /**
     * 获取一级地址（省级）名称数组
     *
     * @return array 键为id 值为名称字符串
     */
    public function getTopLevelAreas() {

        // 对象属性中有数据则返回
        if ($this->cachedTopLevelAreas !== null)
            return $this->cachedTopLevelAreas;

        // 缓存中有数据则返回
        $arr = [];
        if ($arr = rkcache('area_toplevelareas')) {
            $this->cachedTopLevelAreas = $arr;
            return $arr;
        }

        $data = $this->getCache();
        foreach ($data['children'][0] as $i) {
            $arr[$i] = $data['name'][$i];
        }

        wkcache('area_toplevelareas', $arr);
        $this->cachedTopLevelAreas = $arr;
        return $arr;
    }

    /**
     * 获取获取市级id对应省级id的数组
     *
     * @return array 键为市级id 值为省级id
     */
    public function getCityProvince() {

        // 对象属性中有数据则返回
        if ($this->cachedCityProvince !== null)
            return $this->cachedCityProvince;

        // 缓存中有数据则返回
        $arr = [];
        if ($arr = rkcache('area_cityprovince')) {
            $this->cachedCityProvince = $arr;
            return $arr;
        }

        // 生成数据
        $data = $this->getCache();
        foreach ($data['parent'] as $k => $v) {
            if ($v && $data['parent'][$v] == 0) {
                $arr[$k] = $v;
            }
        }

        wkcache('area_cityprovince', $arr);
        $this->cachedCityProvince = $arr;

        return $arr;
    }

    /**
     * 获取地区缓存
     *
     * @return array
     */
    public function getAreas() {
        return $this->getCache();
    }

    /**
     * 获取全部地区名称数组
     *
     * @return array 键为id 值为名称字符串
     */
    public function getAreaNames() {
        $data = $this->getCache();

        return $data['name'];
    }

    /**
     * 获取用于前端js使用的全部地址数组
     *
     * @return array
     */
    public function getAreaArrayForJson() {
        $data = $this->getCache();

        $arr = [];
        foreach ($data['children'] as $k => $v) {
            foreach ($v as $vv) {
                $arr[$k][] = [$vv, $data['name'][$vv]];
            }
        }

        return $arr;
    }

    /**
     * 获取地区数组 格式如下
     * array(
     *   'name' => array(
     *     '地区id' => '地区名称',
     *     // ..
     *   ),
     *   'parent' => array(
     *     '子地区id' => '父地区id',
     *     // ..
     *   ),
     *   'children' => array(
     *     '父地区id' => array(
     *       '子地区id 1',
     *       '子地区id 2',
     *       // ..
     *     ),
     *     // ..
     *   ),
     *   'region' => array(array(
     *     '华北区' => array(
     *       '省级id 1',
     *       '省级id 2',
     *       // ..
     *     ),
     *     // ..
     *   ),
     * )
     *
     * @return array
     */
    protected function getCache() {
        // 对象属性中有数据则返回
        if ($this->cachedData !== null)
            return $this->cachedData;

        // 缓存中有数据则返回
        if ($data = rkcache('area')) {
            $this->cachedData = $data;
            return $data;
        }

        // 查库
        $data = array();
        $area_all_array = $this->limit(false)->select();
        foreach ((array) $area_all_array as $a) {
            $data['name'][$a['area_id']] = $a['area_name'];
            $data['parent'][$a['area_id']] = $a['area_parent_id'];
            $data['children'][$a['area_parent_id']][] = $a['area_id'];

            if ($a['area_deep'] == 1 && $a['area_region'])
                $data['region'][$a['area_region']][] = $a['area_id'];
        }

        wkcache('area', $data);
        $this->cachedData = $data;

        return $data;
    }

    /**
     * 格式化地址, 返回格式化字符串, 省\t市\t区
     * @return string
     */
    public function formatAddress($address) {
       $topLevelAreas = $this->getTopLevelAreas();
       $cityProvince = $this->getCityProvince();
       $areaNames = $this->getAreaNames();

        // 过滤空格等各种不可见字符
        $address = trim($address);// 首先去掉头尾空格
        $address = preg_replace('/\s(?=\s)/', '', $address);// 接着去掉两个空格以上的
        $address = preg_replace('/[\n\r\t]/', '', $address);// 最后将非空格替换为没空格

       // 省
       foreach ($topLevelAreas as $key => $topValue) {
            $topLevelLen = strlen($topValue);

            // 匹配不到省, 跳过
            $ret = strncmp($address, $topValue, $topLevelLen);
            if ($ret != 0) continue;

            $topLevelLen = mb_strlen($topValue);
            // 市
            foreach ($cityProvince as $cityValue => $parent) {
                if ($parent != $key) continue;

                $cityValue = $areaNames[$cityValue];
                $cityLen = mb_strlen($cityValue);

                $tmp = mb_substr($address, $topLevelLen, $cityLen);
                // 匹配不到省, 跳过
                if (strcmp($tmp, $cityValue) != 0) continue;

                // 地区
                $tmp = mb_substr($address, $topLevelLen+$cityLen, NULL);
                return "{$topValue}\t{$cityValue}\t{$tmp}";
            }
       }

       return null;
    }

    protected $cachedData;  // 地区表缓存
    protected $cachedTopLevelAreas;   // 省名字缓存
    protected $cachedCityProvince;    // 市id缓存
}