Subversion Repositories SmartDukaan

Rev

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

Rev 34212 Rev 34453
Line 17... Line 17...
17 
				" cast(fofoId as int), count(id))" +
 17 
				" cast(fofoId as int), count(id))" +
18 
				" from Loan " +
 18 
				" from Loan " +
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 
 
- 
 
 24 
		@NamedQuery(name= "Loan.getDueLoansByFofoId", query = "SELECT new com.spice.profitmandi.dao.model.loan.TotalLoanAmountDueModel(ls.id, l.pendingAmount, SUM(ls.amount)) " +
- 
 
 25 
				"FROM Loan l JOIN LoanStatement ls on ls.loanId=l.id " +
- 
 
 26 
				"WHERE l.fofoId = :fofoId AND l.pendingAmount > 0 " +
- 
 
 27 
				"GROUP BY ls.loanId")
23 
})
 28 
})
24 
 
 29 
 
25 
public class Loan {
 30 
public class Loan {
26 
 
 31 
 
27 
	@Id
 32 
	@Id