package dst.ass1.jpa.model.impl;

import dst.ass1.jpa.model.*;
import dst.ass1.jpa.util.Constants;

import javax.persistence.*;
import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Collection;
import java.util.Date;

@Entity
@Table(name = Constants.T_COURSE)
@NamedQuery(name = Constants.Q_ONGOING_AND_FREE_PLATFORM_COURSES, query = "SELECT c" +
        " FROM " + Constants.T_COURSE + " c" +
        " JOIN c.coursePlatform cp " +
        " WHERE cp." + Constants.M_COURSEPLATFORM_NAME + " = :platformName " +
        " AND c." + Constants.M_COURSE_STATUS + " = dst.ass1.jpa.model.CourseStatus.ONGOING" +
        " AND c." + Constants.M_COURSE_CAPACITY + " > (SELECT count(*) FROM " + Constants.T_ENROLLMENT +
        " WHERE c = " + Constants.I_COURSE + " group by " + Constants.I_COURSE + ")"
)
public class Course implements ICourse {
    @Id
    @GeneratedValue
    private Long id;

    @Column
    private String name;

    @Column
    private Integer capacity;

    @Column
    private Boolean premium;

    @Column
    private BigDecimal cost;

    @Column
    private CourseStatus status;

    @Column
    private Date start;

    @Column
    private Date end;

    // FIXME: TESTS VS DB-MODEL? (optional = false)
    @ManyToOne(targetEntity = CoursePlatform.class)
    @JoinColumn(name = Constants.I_COURSEPLATFORM)
    private ICoursePlatform coursePlatform;

    // FIXME: TESTS VS DB-MODEL? (optional = false)
    @ManyToOne(targetEntity = Lecturer.class)
    @JoinColumn(name = Constants.I_LECTURER)
    private ILecturer lecturer;

    @OneToMany(targetEntity = Lesson.class, mappedBy = Constants.M_LESSON_COURSE)
    private Collection<ILesson> lessons = new ArrayList<>();

    @OneToOne(targetEntity = Metadata.class, optional = false, cascade = CascadeType.ALL)
    private IMetadata metadata;

    // FIXME: TESTS VS DB-MODEL?
    @OneToMany(targetEntity = Enrollment.class)
    private Collection<IEnrollment> enrollments = new ArrayList<>();


    @Override
    public Long getId() {
        return id;
    }

    @Override
    public void setId(Long id) {
        this.id = id;
    }

    @Override
    public String getName() {
        return name;
    }

    @Override
    public void setName(String name) {
        this.name = name;
    }

    @Override
    public Integer getCapacity() {
        return capacity;
    }

    @Override
    public void setCapacity(Integer capacity) {
        this.capacity = capacity;
    }

    @Override
    public Boolean getPremium() {
        return premium;
    }

    @Override
    public void setPremium(Boolean premium) {
        this.premium = premium;
    }

    @Override
    public BigDecimal getCost() {
        return cost;
    }

    @Override
    public void setCost(BigDecimal cost) {
        this.cost = cost;
    }

    @Override
    public CourseStatus getStatus() {
        return status;
    }

    @Override
    public void setStatus(CourseStatus status) {
        this.status = status;
    }

    @Override
    public Date getStart() {
        return start;
    }

    @Override
    public void setStart(Date start) {
        this.start = start;
    }

    @Override
    public Date getEnd() {
        return end;
    }

    @Override
    public void setEnd(Date end) {
        this.end = end;
    }

    @Override
    public ICoursePlatform getCoursePlatform() {
        return coursePlatform;
    }

    @Override
    public void setCoursePlatform(ICoursePlatform coursePlatform) {
        this.coursePlatform = coursePlatform;
    }

    @Override
    public ILecturer getLecturer() {
        return lecturer;
    }

    @Override
    public void setLecturer(ILecturer lecturer) {
        this.lecturer = lecturer;
    }

    @Override
    public Collection<ILesson> getLessons() {
        return lessons;
    }

    @Override
    public void setLessons(Collection<ILesson> lessons) {
        this.lessons = lessons;
    }

    @Override
    public void addLesson(ILesson lesson) {
        this.lessons.add(lesson);
    }

    @Override
    public IMetadata getMetadata() {
        return metadata;
    }

    @Override
    public void setMetadata(IMetadata metadata) {
        this.metadata = metadata;
    }

    @Override
    public Collection<IEnrollment> getEnrollments() {
        return enrollments;
    }

    @Override
    public void setEnrollments(Collection<IEnrollment> enrollments) {
        this.enrollments = enrollments;
    }

    @Override
    public void addEnrollment(IEnrollment enrollment) {
        this.enrollments.add(enrollment);
    }
}