workHour/app/Model/Item.php

<?php

namespace App\Model;

use App\Traits\HasCustomFields;

class Item extends DataScopeBaseModel
{
    protected $table = "item"; //指定表
    const CREATED_AT = 'crt_time';
    const UPDATED_AT = 'upd_time';
    protected $dateFormat = 'U';
    const employee_column = "crt_id";
    const table_column = "item_employee";
    const table_id_column = "item_id";

    public static $field = ['title','id','code','start_time','end_time','mark','crt_id','crt_time','state','budget','charge_id','item_attribute','field','is_review_required','review_id','priority_id'];
    public static $report_field_1 = ['title','id','code','start_time','end_time','mark','budget','field'];

    const TYPE_MINUS_TWO = -2;
    const TYPE_MINUS_ONE = -1;
    const TYPE_ONE = 1;
    const TYPE_TWO = 2;
    const TYPE_THREE = 3;
    const State_Type = [
        self::TYPE_MINUS_ONE => '审核中',
        self::TYPE_MINUS_TWO => '已超期',
        self::TYPE_ONE => '待开始',
        self::TYPE_TWO => '进行中',
        self::TYPE_THREE => '已完成',
    ];

    const Attr_TYPE_ONE = 1;
    const Attr_TYPE_TWO = 2;
    const Item_Attribute = [
        self::TYPE_ONE => '自主开发',
        self::TYPE_TWO => '合作开发',
    ];

    // 引入自定义字段预加载关系
    use HasCustomFields;

    // 作用域 里面关联了客户自定义的表头数据 列表页需要 :: withCustomData($user) 这个是预加载
    public function scopeWithCustomData($query, $user)
    {
        $top_depart_id = $user['top_depart_id'];

        return $query->with(['customFields' => function ($subQuery) use ($top_depart_id) {
            $subQuery->where('top_depart_id', $top_depart_id)
                ->where('table_name', $this->table)
                ->where('del_time', 0);
        }]);
    }
}