public $tree_parent = 'parent_id';

    use SoftDelete;

// 获取系统配置
system_config('site_name');
\app\model\SystemConfig::fetchCache('site_name');

// 获取系统字典
system_dict('config_tab');
\app\model\SystemDict::fetchCache('config_tab');

// 相同条件的OR查询
User::where('username|mobile', 'xxxxx')->select();
User::where('username|mobile', 'like', 'test%')->select();

// 不同条件的OR查询
User::where('status', 1)->where(function ($query) use($username, $mobile) {
    $query->whereOr([['username', '=', $username], ['mobile', '=', $mobile]]);
})->select();

// 不同组条件的OR查询
User::where('status', 1)->where(function ($query) use($username, $mobile) {
    $query->whereOr([
        [
            ['username', '=', $username],
        ],
        [
            ['mobile', '<>', ''],
            ['mobile', '=', $mobile],
        ],
    ]);
})->select();
// SELECT * FROM `gen_user` WHERE (  `status` = 1  AND (  ( `username` = 'liux' )  OR ( `mobile` <> '' AND `mobile` = '13012345678' ) ) ) AND `gen_user`.`delete_time` = '0'

// 树形数据结构字段
public $tree_parent = 'parent_id';

// 关联用户总数
public function getUserCountAttr($value, $data)
{
    return $this->users()->count();
}

// 关联用户
public function users()
{
    return $this->hasMany(User::class, 'group_id');
}

// ,分隔转数组
public function getUserIdsAttr($value, $data)
{
    return $value ? array_map(fn($value) => intval($value), explode(',', $value)) : [];
}
// 数组存,分隔字符串
public function setUserIdsAttr($value, $data)
{
    return is_array($value) ? implode(',', $value) : $value;
}

// 时间格式化
protected function getStarttimeAttr($value)
{
    return $value ? date('Y-m-d H:i:s', $value) : '';
}
protected function setStarttimeAttr($value)
{
    return is_numeric($value) ? $value : strtotime($value);
}

// 城市名模糊搜索
public function searchCitynameAttr($query, $value, $data)
{
    if (!empty($value)) {
        $query->whereLike('cityname', '%' . $value . '%');
    }
}

// 绑定信息模糊搜索
public function searchBindInfoAttr($query, $value, $data)
{
    if (!empty($value)) {
        $query->where('bind_name|bind_mobile', 'like', '%' . $value . '%');
    }
}

// 价格区间搜索器
public function searchPriceAttr($query, $value, $data)
{
    empty($value) || $query->whereBetween('price', $value[0], $value[1]);
}

// 关联用户搜索器
public function searchUserAttr($query, $value, $data)
{
    $map = $this->parseSearch('user', json_decode($value, true));
    empty($map) || $query->whereIn('user_id', function (&$sq) use ($map) {
        $sq = (new User())->db()->alias('user');
        $sq->field('id')->where($map);
    });
}

// 关联用户搜索器
public function searchUserAttr($query, $value, $data)
{
    $map = $this->parseSearch('user', json_decode($value, true));
    empty($map) || $query->whereExists(function (&$sq) use ($map, $query) {
        $sq = (new User())->db()->alias('user');
        $sq->whereExp('id', '=' . $query->getTable() . '.user_id')->where($map);
    });
}

// 关联定单搜索器(自动别名)
public function searchOrderAttr($query, $value, $data)
{
    $value = json_decode($value, true);
    $map = $this->parseSearch('order', $value);
    empty($map) || $query->whereExists(function (&$sq) use ($value, $map) {
        $sq = (new Order())->db()->alias('order');
        empty($value['sellerUser']) || $sq->join('user sellerUser', 'order.seller_user_id=sellerUser.id');
        $sq->whereExp('order.id', '=' . $this->db()->getTable() . '.order_id')->where($map);
    });
}

// 关联定单搜索器(定义别名)
public function searchOrderAttr($query, $value, $data)
{
    $value = json_decode($value, true);
    $map = $this->parseSearch('order', $value, ['order' => 'o', 'order.sellerUser' => 'u']);
    empty($map) || $query->whereExists(function (&$sq) use ($value, $map) {
        $sq = (new Order())->db()->alias('o');
        empty($value['sellerUser']) || $sq->join('user u', 'o.seller_user_id=u.id');
        $sq->whereExp('o.id', '=' . $this->db()->getTable() . '.order_id')->where($map);
    });
}

// 情景1：必选，单一字段验证唯一表记录
protected $rule = [
    'goods_id|商品' => 'require|checkModelUnique:\\app\\model\\H5Goods',
];

// 情景2：条件必选，多个字段验证唯一表记录
protected $rule = [
    'goods_id|商品' => 'requireIf:type,goods|checkModelUnique:\\app\\model\\H5Carousel,goods_id^company_id',
];

protected $json = ['user_ids'];
protected $jsonAssoc = true;

public function getUserIdsAttr($value, $data)
{
    return json_decode($value) ?: [];
}
public function setUserIdsAttr($value, $data)
{
    return is_array($value) ? json_encode($value) : '[]';
}