php - 在 Laravel 中需要帮助 manimum 和 laravel 中的最大用户输入

Question

我遇到了一个问题，我想在 laravel 或 mysql 中获取过滤器数据，稍后我将转换为 laravel，那就是我想从
实际介于 80 到 150 之间（由用户选择）
和在数据库（mysql）中，我只有最小值是 80，最大值是 200

但是通过使用以下代码，它只返回给定最小值的最大值

    $product = product::join('tire_brands', 'product.brand', '=', 'tire_brands.id')
    ->join('speedrating','product.speedrating','=','speedrating.id')
    ->where($whereData)
    ->when(!empty($category), function ($query) use ($category) {
        return $query->whereIn('itemtype', $category);
    })
    ->when(!empty($speedrating), function ($query) use ($speedrating) {
        return $query->whereIn('speedrating', $speedrating);
    })
    ->when(!empty($tirebrands), function ($query) use ($tirebrands) {
        return $query->whereIn('brand', $tirebrands);
    })
    ->when(!empty($minwarrenty) && !empty($maxwarrenty), function ($query) use ($minwarrenty,$maxwarrenty) {
        return $query->whereBetween('warrenty', [$minwarrenty, $maxwarrenty]);
    })
    ->when(!empty($minimum_load) && !empty($maximum_load), function ($query) use ($minimum_load,$maximum_load) {
         return $query->whereBetween('maxload', [$minimum_load, $maximum_load]);
    })
    ->when(!empty($curroff), function ($query) use ($curroff) {
        return $query->whereIn('curr_offerid', $curroff);;
    })
    ->when(!empty($sidewal), function ($query) use ($sidewal) {
        return $query->whereIn('sidewall_id', $sidewal);;
    })
    ->when(!empty($tyrtyp), function ($query) use ($tyrtyp) {
        return $query->whereIn('tyretype_id', $tyrtyp);;
    })
    ->get(['product.id','product.name as pronam',
     'tire_brands.name as brand', 'sku','slug','warrenty','speedrating','itemtype',
    'product.image','product.video','speedrating.name as speedrating','touring']);

    return $product;

我究竟做错了什么？

标签： phpmysqllaravel