xiaoshan/application/common/model/OfflineShopModel.php

<?php

namespace app\common\model;

use think\Db;
use think\Model;

/**
 * 群组
 */
class OfflineShopModel extends BaseModel
{
    // 表名
    protected $name = 'offline_shop';

    // 自动写入时间戳字段
    protected $autoWriteTimestamp = 'int';

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

    protected int $is_status_search = 1;// 默认使用 status = 1 筛选
    protected int $is_delete_search = 0;// 默认使用 is_delete = 0 筛选

    /**
     * 默认查询字段
     *
     * @var array|string[]
     */
    public array $select = [
        '*'
    ];

    public function searchTypeIdAttribute($query, $value, array $params)
    {
        if (empty($value)) {
            return $query;
        }
        return $query->where('type_id', $value);
    }

    public function searchKeywordAttribute($query, $value, array $params)
    {
        if (empty($value)) {
            return $query;
        }
        return $query->where('name|keyword','like', "%{$value}%");
    }

    public function searchCityAttribute($query, $value, array $params)
    {
        if (empty($value)) {
            return $query;
        }
        return $query->where('city','like', "%{$value}%");
    }

    public function searchTypeIdsAttribute($query, $value, array $params)
    {
        if (empty($value)) {
            return $query;
        }
        return $query->whereRaw("FIND_IN_SET({$value},`type_ids`)");
    }

    public function searchDistanceAttribute($query, $value, array $params)
    {
        if (empty($value)) {
            return $query;
        }
        return $query->having("distance < {$value}");
    }
}