SmartGymManagementSystem/MaintenanceRecordRepository.java

package com.gym.repository;

import com.gym.model.MaintenanceRecord;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.stereotype.Repository;
import java.util.List;

@Repository
public interface MaintenanceRecordRepository extends JpaRepository<MaintenanceRecord, Long> {

    List<MaintenanceRecord> findByEquipmentIdOrderByMaintenanceDateDesc(Long equipmentId);

    List<MaintenanceRecord> findByEquipmentIdAndStatusOrderByMaintenanceDateDesc(Long equipmentId, String status);

    Long countByEquipmentId(Long equipmentId);
}