Some Assistance with the query PLEASE!!

$products = QueryBuilder::for(Product::class)
            ->allowedFilters(['name', 'user_id', AllowedFilter::scope('category')])
            ->allowedSorts('id')
            ->latest()
            ->whereRaw('(quantity - total_sold) > 0')
            ->get();
        return ProductCollection::collection($products);

From the above query i would like to query only the products left for sale. It works.

NOW I WOULD LIKE TO EXTEND :

Check if the product has been added  just in this week. and display it regardless if  it is available or not.

Hide unavailble only if its one week old.