Php 按制造商、型号和年份范围判断数据的存在性

为了确保捕捉到任何类型的重叠，您需要调整逻辑以考虑所有可能的重叠场景:

1. 用户的自年在任何现有范围内.
2. 用户今年的时间在任何现有范围内.
3. 用户的范围完全包含现有范围.
4. 现有的范围完全涵盖了用户的范围.

以下是您如何调整查询以涵盖所有这些情况:

$has_range = PartsList::where('make', $request->make)
    ->where('model', $request->model)
    ->where(function ($query) use ($request) {
        // Case 1: User's fromyear is within an existing range.
        $query->where(function($q) use ($request) {
            $q->where('fromyear', '<=', $request->fromyear)
              ->where('toyear', '>=', $request->fromyear);
        })
        // Case 2: User's toyear is within an existing range.
        ->orWhere(function($q) use ($request) {
            $q->where('fromyear', '<=', $request->toyear)
              ->where('toyear', '>=', $request->toyear);
        })
        // Case 3: User's range encompasses an existing range.
        ->orWhere(function($q) use ($request) {
            $q->where('fromyear', '>=', $request->fromyear)
              ->where('toyear', '<=', $request->toyear);
        })
        // Case 4: An existing range encompasses the user's range (this might actually be redundant given the first two checks, but added for clarity).
        ->orWhere(function($q) use ($request) {
            $q->where('fromyear', '<=', $request->fromyear)
              ->where('toyear', '>=', $request->toyear);
        });
    })
    ->exists();

if ($has_range) {
    $msg = 'The year range already exists for this make and model.';
}