Subversion Repositories SmartDukaan

package com.spice.profitmandi.dao.entity.transaction;

import com.spice.profitmandi.dao.model.DailyStatementModel;

import javax.persistence.*;
import java.math.BigDecimal;
import java.time.LocalDate;
import java.time.LocalDateTime;
import java.time.temporal.ChronoUnit;
import java.util.List;
import java.util.Objects;

@Entity
@Table(name = "transaction.loan")
@NamedQueries({
                @NamedQuery(name = "Loan.getLoansCountWithFofoID", query = "select new com.spice.profitmandi.dao.model.LoanCountByFofoIdModel(" +
                                " cast(fofoId as int), count(id))" +
                                " from Loan " +
                                " where fofoId in (:fofoIds) " +
                                " group by fofoId "),

                @NamedQuery(name = "Loan.findBlockedLoans", query = "SELECT l FROM Loan l WHERE l.freeDays > 364"),

                @NamedQuery(name= "Loan.getDueLoansByFofoId", query = "SELECT new com.spice.profitmandi.dao.model.loan.TotalLoanAmountDueModel(ls.id, l.pendingAmount, SUM(ls.amount)) " +
                                "FROM Loan l JOIN LoanStatement ls on ls.loanId=l.id " +
                                "WHERE l.fofoId = :fofoId AND l.pendingAmount > 0 " +
                                "GROUP BY ls.loanId")
})

public class Loan {

        @Id
        @Column(name = "id", unique = true, updatable = false)
        @GeneratedValue(strategy = GenerationType.IDENTITY)
        private int id;

        @Column(name = "fofo_id")
        private int fofoId;

        @Column(name = "interest_rate")
        private BigDecimal interestRate;

        @Column(name = "intial_amount")
        private BigDecimal intialAmount;

        @Column(name = "pending_amount")
        private BigDecimal pendingAmount;

        @Column(name = "created_on")
        private LocalDateTime createdOn;

        @Column(name = "settled_on")
        private LocalDateTime settledOn;

        @Column(name = "due_date")
        private LocalDateTime dueDate;

        @Column(name = "interest_accured")
        private BigDecimal interestAccrued;

        @Column(name = "interest_paid")
        private BigDecimal interestPaid;

        @Column(name = "free_days")
        private int freeDays;

        @Transient
        private boolean loanStatus;

        @Transient
        private BigDecimal totalPending;

        public long getDays() {
                return ChronoUnit.DAYS.between(this.getCreatedOn().toLocalDate(), LocalDateTime.now()) + 1;
        }

        public boolean isDue() {
                return this.getSettledOn()==null && !this.getDueDate().toLocalDate().isBefore(LocalDate.now());
        }

        public boolean isOverdue() {
                return this.getSettledOn()==null && this.getDueDate().toLocalDate().isBefore(LocalDate.now()) &&
                                !this.getDueDate().plusDays(15).toLocalDate().isBefore(LocalDate.now());
        }

        public boolean isDefault() {
                return this.getSettledOn()==null && this.getDueDate().plusDays(15).toLocalDate().isBefore(LocalDate.now());
        }

        @Transient
        private List<DailyStatementModel> dailyStatementModel;

        public int getId() {
                return id;
        }

        public void setId(int id) {
                this.id = id;
        }

        public BigDecimal getTotalPending() {
                return totalPending;
        }

        public void setTotalPending(BigDecimal totalPending) {
                this.totalPending = totalPending;
        }

        public int getFofoId() {
                return fofoId;
        }

        public void setFofoId(int fofoId) {
                this.fofoId = fofoId;
        }

        public BigDecimal getInterestRate() {
                return interestRate;
        }

        public void setInterestRate(BigDecimal interestRate) {
                this.interestRate = interestRate;
        }

        public BigDecimal getIntialAmount() {
                return intialAmount;
        }

        public void setIntialAmount(BigDecimal intialAmount) {
                this.intialAmount = intialAmount;
        }

        public BigDecimal getPendingAmount() {
                return pendingAmount;
        }

        public void setPendingAmount(BigDecimal pendingAmount) {
                this.pendingAmount = pendingAmount;
        }

        public LocalDateTime getCreatedOn() {
                return createdOn;
        }

        public void setCreatedOn(LocalDateTime createdOn) {
                this.createdOn = createdOn;
        }

        public LocalDateTime getDueDate() {
                return dueDate;
        }

        public void setDueDate(LocalDateTime dueDate) {
                this.dueDate = dueDate;
        }

        public BigDecimal getInterestAccrued() {
                return interestAccrued;
        }

        public void setInterestAccrued(BigDecimal interestAccrued) {
                this.interestAccrued = interestAccrued;
        }

        public BigDecimal getInterestPaid() {
                return interestPaid;
        }

        public void setInterestPaid(BigDecimal interestPaid) {
                this.interestPaid = interestPaid;
        }

        public int getFreeDays() {
                return freeDays;
        }

        public void setFreeDays(int freeDays) {
                this.freeDays = freeDays;
        }

        public List<DailyStatementModel> getDailyStatementModel() {
                return dailyStatementModel;
        }

        public void setDailyStatementModel(List<DailyStatementModel> dailyStatementModel) {
                this.dailyStatementModel = dailyStatementModel;
        }

        public boolean isLimit() {
                return this.getFreeDays() >= 365;
        }

        @Override
        public String toString() {
                return "Loan{" +
                                "id=" + id +
                                ", fofoId=" + fofoId +
                                ", interestRate=" + interestRate +
                                ", intialAmount=" + intialAmount +
                                ", pendingAmount=" + pendingAmount +
                                ", createdOn=" + createdOn +
                                ", settledOn=" + settledOn +
                                ", dueDate=" + dueDate +
                                ", interestAccrued=" + interestAccrued +
                                ", interestPaid=" + interestPaid +
                                ", freeDays=" + freeDays +
                                ", loanStatus=" + loanStatus +
                                ", totalPending=" + totalPending +
                                ", dailyStatementModel=" + dailyStatementModel +
                                '}';
        }

        @Override
        public boolean equals(Object o) {
                if (this == o) return true;
                if (o == null || getClass() != o.getClass()) return false;
                Loan loan = (Loan) o;
                return id == loan.id && fofoId == loan.fofoId && freeDays == loan.freeDays && loanStatus == loan.loanStatus && Objects.equals(interestRate, loan.interestRate) && Objects.equals(intialAmount, loan.intialAmount) && Objects.equals(pendingAmount, loan.pendingAmount) && Objects.equals(createdOn, loan.createdOn) && Objects.equals(settledOn, loan.settledOn) && Objects.equals(dueDate, loan.dueDate) && Objects.equals(interestAccrued, loan.interestAccrued) && Objects.equals(interestPaid, loan.interestPaid) && Objects.equals(totalPending, loan.totalPending) && Objects.equals(dailyStatementModel, loan.dailyStatementModel);
        }

        @Override
        public int hashCode() {
                return Objects.hash(id, fofoId, interestRate, intialAmount, pendingAmount, createdOn, settledOn, dueDate, interestAccrued, interestPaid, freeDays, loanStatus, totalPending, dailyStatementModel);
        }

        public LocalDateTime getSettledOn() {
                return settledOn;
        }

        public void setSettledOn(LocalDateTime settledOn) {
                this.settledOn = settledOn;
        }

        public boolean isLoanStatus() {
                return loanStatus;
        }

        public void setLoanStatus(boolean loanStatus) {
                this.loanStatus = loanStatus;
        }

}