<?php

namespace app\admin\model;

use think\Model;


class Item extends Model
{

    

    

    // 表名
    protected $name = 'item';
    
    // 自动写入时间戳字段
    protected $autoWriteTimestamp = 'integer';

    // 定义时间戳字段名
    protected $createTime = 'createtime';
    protected $updateTime = 'updatetime';
    protected $deleteTime = false;

    // 追加属性
    protected $append = [
        'campus_text',
        'ronda_text',
        'radar_text',
    ];

    public function getCampusTextAttr($value,$data){
        $campus = explode(',',$data['campus_ids']);
        $title = [];
        foreach ($campus as $k){
            $title[] = db('campus')->where('id',$k)->value('title');
        }
        $value = implode(',',$title);
        return $value;
    }

    public function getRondaTextAttr($value,$data){
        $ronda = explode(',',$data['ronda_ids']);
        $title = [];
        foreach ($ronda as $k){
            $title[] = db('ronda')->where('id',$k)->value('title');
        }
        $value = implode(',',$title);
        return $value;
    }

    public function getRadarTextAttr($value,$data){
        $radar = explode(',',$data['radar_ids']);
        $title = [];
        foreach ($radar as $k){
            $title[] = db('radar')->where('id',$k)->value('title');
        }
        $value = implode(',',$title);
        return $value;
    }

    public function campus()
    {
        return $this->belongsTo('Campus', 'campus_ids', 'id', [], 'LEFT')->setEagerlyType(0);
    }


    public function ronda()
    {
        return $this->belongsTo('Ronda', 'ronda_ids', 'id', [], 'LEFT')->setEagerlyType(0);
    }


    public function radar()
    {
        return $this->belongsTo('Radar', 'radar_ids', 'id', [], 'LEFT')->setEagerlyType(0);
    }


    public function user()
    {
        return $this->belongsTo('User', 'user_id', 'id', [], 'LEFT')->setEagerlyType(0);
    }
}