| 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 |
@NamedQuery(name = "Loan.getLoansForSettlement", query = "SELECT l FROM Loan l join UserWallet uw on uw.userId=l.fofoId WHERE uw.amount > 0 and l.freeDays < 365 and l.settledOn is null"),
|
23 |
@NamedQuery(name = "Loan.getLoansForSettlement", query = "SELECT l FROM Loan l join UserWallet uw on uw.userId=l.fofoId WHERE uw.amount > 0 and l.freeDays < 365 and l.settledOn is null"),
|
| - |
|
24 |
@NamedQuery(name = "Loan.getStateWiseLoan", query = "SELECT l FROM Loan l join FofoStore fs on fs.id=l.fofoId join AST ast on ast.id = fs.astId join State st on st.id= ast.stateId WHERE st.name = :stateName and l.pendingAmount > 0 and l.settledOn is null"),
|
| 24 |
|
25 |
|
| 25 |
@NamedQuery(name = "Loan.getDueLoansByFofoId", query = "SELECT new com.spice.profitmandi.dao.model.loan.TotalLoanAmountDueModel(ls.loanId, l.pendingAmount, SUM(ls.amount)) " +
|
26 |
@NamedQuery(name = "Loan.getDueLoansByFofoId", query = "SELECT new com.spice.profitmandi.dao.model.loan.TotalLoanAmountDueModel(ls.loanId, l.pendingAmount, SUM(ls.amount)) " +
|
| 26 |
"FROM Loan l JOIN LoanStatement ls on ls.loanId=l.id " +
|
27 |
"FROM Loan l JOIN LoanStatement ls on ls.loanId=l.id " +
|
| 27 |
"WHERE l.fofoId = :fofoId AND l.pendingAmount > 0 " +
|
28 |
"WHERE l.fofoId = :fofoId AND l.pendingAmount > 0 " +
|
| 28 |
"GROUP BY ls.loanId")
|
29 |
"GROUP BY ls.loanId")
|