<?php
/**
+-----------------------------------------------------------------------------------------------------------------------
 * 模型层：系统-区域 模型类
+-----------------------------------------------------------------------------------------------------------------------
 *
 * PHP version 7
 *
 * @category  App\Models\System
 * @package   App\Models\System
 * @author    Richer <yangzi1028@163.com>
 * @date      2021年1月26日17:53:22
 * @copyright 2020-2022 Richer (http://www.Richer.com/)
 * @license   http://www.Richer.com/ License
 * @link      http://www.Richer.com/
 */
namespace App\Models\System;

use App\Models\BaseModel;
use App\Models\Lock\Lock;
use App\Models\Smoke\Smoke;
use App\Models\Traits\AreaTrait;
use App\Models\User\Tenant;
use Encore\Admin\Auth\Database\Administrator;
use Encore\Admin\Traits\ModelTree;
use Illuminate\Database\Eloquent\Relations\hasMany;
use Illuminate\Database\Eloquent\Relations\HasOne;
use Illuminate\Support\Arr;
use Illuminate\Support\Facades\Cache;
use Illuminate\Support\Facades\DB;

/**
 * Class Area
 *
 * @category  App\Models\System
 * @package   App\Models\System
 * @author    Richer <yangzi1028@163.com>
 * @date      2021年1月26日17:53:22
 * @copyright 2020-2022 Richer (http://www.Richer.com/)
 * @license   http://www.Richer.com/ License
 * @link      http://www.Richer.com/
 */
class Area extends BaseModel
{

    //
    // 指定数据库表
    const TABLE = 'system_areas';
    protected $table = self::TABLE;

    // 指定对象显示名称：方便系统统一查询和做其他处理
    const OBJ_NAME      = 'system-area';
    const OBJ_NAME_ZH   = '区域';

    const LEVEL_VILLAGE   = 1;
    const LEVEL_GROUP = 2;
    const LEVEL_BUILDING    = 3;
    const LEVEL_ROOM       = 4;

    const VILLAGE   = 'village';
    const GROUP         = 'group';
    const BUILDING    = 'building';
    const ROOM       = 'room';

    const VILLAGE_ZH      = '社区/村';
    const GROUP_ZH    = '小区/小组';
    const BUILDING_ZH       = '楼栋';
    const ROOM_ZH          = '房间';



    /**
     * The attributes that are mass assignable.
     *
     * @var array
     */
    protected $fillable = [
        'admin_id', 'pid','level',  'title','pcode', 'code', 'code','phone', 'address','path'
    ];

    /**
     * 访问器被附加到模型数组的形式。
     *
     * @var array
     */
//    protected $appends = ['username','password', 'gid','ggid', 'village_id','group_id','building_id'];

    /**
     *
     */
    public static function boot()
    {
        parent::boot();

        // 删除
        static::deleted(function ($model) {
            // 删除关联
            AreaTrait::deleteArea($model);
        });
    }

    /**
     * @return \Illuminate\Database\Eloquent\Relations\BelongsTo
     */
    public function admin()
    {
        return $this->belongsTo(Administrator::class);
    }

    /**
     * 属于哪个用户
     *
     * @return mixed
     */
    public function parent()
    {
        return $this->belongsTo(Area::class, 'pid');
    }

    /**
     * @return HasMany
     */
    public function rooms(): HasMany
    {
        return $this->hasMany(Area::class, 'pid', 'id');
    }

    /**
     * 获取gid
     *
     * @param $value
     * @return mixed
     */
    public function getGidAttribute($value)
    {
        $id     = $this->id;
        $pid    = $this->pid;
        $level  = $this->level;
        $path   = $this->path;

        $gid = 0;
        switch ($level) {
            case Area::LEVEL_BUILDING:
                $gid = trim(str_replace(','.$pid.',', '', $path), ',');
                break;
            case Area::LEVEL_ROOM:
                $gid = Arr::last(explode(',', trim(str_replace(','.$pid.',', '', $path), ',')));
                break;
        }
        return $gid;
    }

    /**
     * 获取gid
     *
     * @param $value
     * @return mixed
     */
    public function getGgidAttribute($value)
    {
        $id     = $this->id;
        $pid    = $this->pid;
        $level  = $this->level;
        $path   = $this->path;
        $ggid = 0;
        switch ($level) {
            case Area::LEVEL_ROOM:
                $ggid = Arr::first(explode(',', trim($path, ',')));
                break;
        }
        return $ggid;
    }

    /**
     * 获取 village_id
     *
     * @return mixed
     */
    public function getVillageIdAttribute()
    {
        $path   = $this->path;
        $paths  = array_filter(explode(',', $path));
        $level  = $this->level;
        switch ($level) {
            case self::LEVEL_VILLAGE:
                return $this->id;
            default:
                return Arr::first($paths);
        }
    }

    /**
     * 获取 group_id
     *
     * @return mixed
     */
    public function getGroupIdAttribute()
    {
        $path   = $this->path;
        $paths  = array_filter(explode(',', $path));
        $level  = $this->level;
        switch ($level) {
            case self::LEVEL_VILLAGE:
                return 0;
            case self::LEVEL_GROUP:
                return $this->id;
            default:
                return Arr::first(array_slice($paths, 1));
        }
    }

    /**
     * 获取 group_id
     *
     * @return mixed
     */
    public function getBuildingIdAttribute()
    {
        $path   = $this->path;
        $paths  = array_filter(explode(',', $path));
        $level  = $this->level;
        switch ($level) {
            case self::LEVEL_GROUP:
                return $this->id;
            case self::LEVEL_ROOM:
                return $this->pid;
            default:
                return Arr::first(array_slice($paths, 2));
        }
    }
//
//    /**
//     * 获取管理端用户名
//     *
//     * @param $value
//     * @return mixed
//     */
//    public function getUsernameAttribute($value)
//    {
//        $admin = $this->admin;
//        if ($admin) {
//            return $admin->username;
//        }
//        return '';
//    }
//
//    /**
//     * 获取管理端用户名
//     *
//     * @param $value
//     * @return mixed
//     */
//    public function getPasswordAttribute($value)
//    {
//        $admin = $this->admin;
//        if ($admin) {
//            return $admin->password;
//        }
//        return '';
//    }

    /**
     * 生成每个级别的code
     * @param int $level
     * @param string $pcode
     * @return string
     */
    public static function generateCode($level = 1, $pcode = '')
    {
        // $redis = Redis::connection("serial_number");
        $cache_key      = self::OBJ_NAME .'-'.$level.'-'.$pcode ;
        $serial_number  = Cache::get($cache_key);
        $prefix_zeros   = 12;
        if (!$serial_number) {
            $query = Area::where('level', $level);
            if ($pcode) {
                $query->where('pcode', $pcode);
            }
            $area = $query->orderByDesc('code')->first();


            if ($area) {
                $serial_number = intval(rtrim_zero($area->code));
            } else {
                switch ($level) {
                    case self::LEVEL_VILLAGE:
                        $serial_number = 110;
                        break;
                    case self::LEVEL_GROUP:
                    case self::LEVEL_BUILDING:
                    case self::LEVEL_ROOM:
                        $serial_number = rtrim_zero($pcode) . 110;
                        break;
                }
            }
        }

//        switch ($level) {
//            case self::LEVEL_VILLAGE:
//                $prefix_zeros   = 8;
//                break;
//            case self::LEVEL_GROUP:
//                $prefix_zeros   = 8;
//                break;
//            case self::LEVEL_BUILDING:
//                $prefix_zeros   = 8;
//                break;
//            case self::LEVEL_ROOM:
//                $prefix_zeros   = 8;
//                break;
//        }

//        dump($serial_number);

        $serial_number++;


//        $code = str_pad(1,$prefix_zeros,"0",STR_PAD_RIGHT);
        $code =  sprintf("%-0{$prefix_zeros}s", $serial_number);
//        dump($code);
//        dd($serial_number);


        Cache::add($cache_key, $serial_number);

        return $code;
    }

    /**
     * 生成每个级别的code
     * @param int $level
     * @return array
     */
    public static function getParent($level = 1)
    {
        $models  = Area::where('level', $level)->get(['id','code','title', 'path']);//->pluck('title', 'code')->toArray();
        return $models;
    }

    /**
     * 生成每个级别的code
     * @param int $level
     * @return array
     */
    public static function getSelectOptionsByLevel($level = 1)
    {
        return Area::where('level', $level)->get(['id','code','title'])->pluck('title', 'id')->toArray();
    }

    /**
     * 根据区域的code获取区域的的代码集：主要为laravel-admin select组件使用
     *
     * @param string $code code
     * @return array
     */
    public static function getSelectOptionsByPid($code = '')
    {
        $list = self::where('pid', $code)->get(['id','title']);
//        $options[0] = '全部';
        $options = [];
        foreach ($list as $vo) {
            $options[$vo->id] = $vo->title;
        }
        return $options;
    }

    /**
     * 根据区域的code获取区域的的代码集：主要为laravel-admin select组件使用
     *
     * @param string $code code
     * @return array
     */
    public static function getSelectOptions($code = '')
    {
        $list = self::where('pid', $code)->get(['id','title']);
//        $options[0] = '全部';
        $options = [];
        foreach ($list as $vo) {
            $options[$vo->id] = $vo->title;
        }
        return $options;
    }

    /**
     * @return hasMany
     */
    public function children(): hasMany
    {
        return $this->hasMany(Area::class, 'pid', 'id');
    }

    /**
     * @return hasMany
     */
    public function allChildren()
    {
        return $this->children()->with('allChildren');
    }

    /**
     * @return hasMany
     */
    public function allParent()
    {
        return $this->parent()->with('allParent');
    }

    /**
     * 生成每个级别的code
     * @param int $level
     * @return array
     */
    public static function getParents($level = 1)
    {
        $models  = Area::where('level', $level)->get(['id','code','title', 'path']);//->pluck('title', 'code')->toArray();
        return $models;
    }

    /**
     * @return HasOne
     */
    public function lock(): HasOne
    {
        return $this->hasOne(Lock::class, 'room_id');
    }

    /**
     * @return HasOne
     */
    public function smoke(): HasOne
    {
        return $this->hasOne(Smoke::class, 'room_id');
    }

    /**
     * @return HasMany
     */
    public function tenants(): HasMany
    {
        return $this->hasMany(Tenant::class, 'room_id');
    }
}