Subversion Repositories SmartDukaan

Rev

Rev 34453 | Rev 34709 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 34453 Rev 34498
Line 19... Line 19...
19 
				" where fofoId in (:fofoIds) " +
 19 
				" where fofoId in (:fofoIds) " +
20 
				" group by fofoId "),
 20 
				" group by fofoId "),
21 
 
 21 
 
22 
		@NamedQuery(name = "Loan.findBlockedLoans", query = "SELECT l FROM Loan l WHERE l.freeDays > 364"),
 22 
		@NamedQuery(name = "Loan.findBlockedLoans", query = "SELECT l FROM Loan l WHERE l.freeDays > 364"),
23 
 
 23 
 
24 
		@NamedQuery(name= "Loan.getDueLoansByFofoId", query = "SELECT new com.spice.profitmandi.dao.model.loan.TotalLoanAmountDueModel(ls.id, l.pendingAmount, SUM(ls.amount)) " +
 24 
		@NamedQuery(name= "Loan.getDueLoansByFofoId", query = "SELECT new com.spice.profitmandi.dao.model.loan.TotalLoanAmountDueModel(ls.loanId, l.pendingAmount, SUM(ls.amount)) " +
25 
				"FROM Loan l JOIN LoanStatement ls on ls.loanId=l.id " +
 25 
				"FROM Loan l JOIN LoanStatement ls on ls.loanId=l.id " +
26 
				"WHERE l.fofoId = :fofoId AND l.pendingAmount > 0 " +
 26 
				"WHERE l.fofoId = :fofoId AND l.pendingAmount > 0 " +
27 
				"GROUP BY ls.loanId")
 27 
				"GROUP BY ls.loanId")
28 
})
 28 
})
29 
 
 29