source: src/main/java/com/example/fooddeliverysystem/repository/OrderRepository.java

package com.example.fooddeliverysystem.repository;

import com.example.fooddeliverysystem.model.Consumer;
import com.example.fooddeliverysystem.model.Deliver;
import com.example.fooddeliverysystem.model.Order;
import com.example.fooddeliverysystem.model.SalePlace;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.query.Procedure;
import org.springframework.stereotype.Repository;

import java.util.List;

@Repository
public interface OrderRepository extends JpaRepository<Order, Long> {

    List<Order> findAllBySalePlaceAndOrderStatus(SalePlace salePlace, String orderStatus);

    List<Order> findAllByOrderStatus(String status);

    List<Order> findAllByOrderStatusAndDeliver(String status, Deliver deliver);

    List<Order> findAllByConsumer(Consumer consumer);
}