crm/app/model/CustomerNotVisit.php

<?php

namespace app\model;

use think\Model;

class CustomerNotVisit extends Model
{
    /**
     * 关联员工
     *
     * @return BelongsTo
     */
    public function employee()
    {
        return $this->belongsTo(Employee::class, 'employee_id');
    }

    /**
     * 关联设计师
     * @return BelongsTo
     */
    public function designer()
    {
        return $this->belongsTo(Employee::class, 'employee_id');
    }

    /**
     * 关联客户
     * 
     * @return BelongsTo
     */
    public function customer()
    {
        return $this->belongsTo(Customer::class, 'customer_id');
    }

    /**
     * 关联部门
     */
    public function org()
    {
        return $this->belongsTo(Org::class, 'org_id');
    }

    /**
     * 状态属性获取
     */
    public function getStateAttr($value)
    {
        $states = [
            '待确认' => [0, '待确认', '0'],
            '未到访' => [1, '未到访', '1'],
            '已到店' => [2, '已到访', '确认到店', '确定到店', '已到店', '2'],
            '已到场' => [3, '确定到场', '确认到场', '已到场', '3'],
            '已量房' => [4, '已量房', '确定量房', '确认量房', '4'],
            '已交定' => [5, '定金', '交定', '已交定', '5'],
            '已签单' => [6, '签单', '已签单', '6'],
            '无效' => [7, '无效', '7']
        ];

        foreach ($states as $k => $arr) {
            if (in_array($value, $arr)) return $k;
        }

        return $value;
    }

    /**
     * 格式化时间
     */
    public function getAddtimeAttr($value)
    {
        return date('Y-n-j', strtotime($value));
    }
}