package com.grash.repository;

import com.grash.model.PartConsumption;
import org.springframework.data.jpa.repository.JpaRepository;

import java.util.Collection;
import java.util.Date;
import java.util.List;

public interface PartConsumptionRepository extends JpaRepository<PartConsumption, Long> {
    Collection<PartConsumption> findByCompany_Id(Long id);

    Collection<PartConsumption> findByWorkOrder_Id(Long id);

    Collection<PartConsumption> findByPart_Id(Long id);

    Collection<PartConsumption> findByCreatedAtBetweenAndCompany_Id(Date
                                                                            date1, Date date2, Long companyId);


    Collection<PartConsumption> findByWorkOrder_IdAndPart_Id(Long workOrderId, Long partId);

    Collection<PartConsumption> findByCompany_IdAndCreatedAtBetween(Long id, Date start, Date end);

    List<PartConsumption> findByWorkOrder_IdIn(List<Long> ids);
}