BrightSide Workbench Full Report + Source Code
PortfolioErrorsSet.java
Go to the documentation of this file.
1 /*
2  * TurrĂ³ i Cutiller Foundation. License notice.
3  * Copyright (C) 2011 Lluis TurrĂ³ Cutiller <http://www.turro.org/>
4  *
5  * This program is free software: you can redistribute it and/or modify
6  * it under the terms of the GNU Affero General Public License as published by
7  * the Free Software Foundation, either version 3 of the License, or
8  * (at your option) any later version.
9  *
10  * This program is distributed in the hope that it will be useful,
11  * but WITHOUT ANY WARRANTY; without even the implied warranty of
12  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
13  * GNU Affero General Public License for more details.
14  *
15  * You should have received a copy of the GNU Affero General Public License
16  * along with this program. If not, see <http://www.gnu.org/licenses/>.
17  */
18 package org.turro.financials.model.document;
19 
20 import java.util.HashSet;
21 import java.util.List;
22 import org.turro.financials.db.FinancialsPU;
23 import org.turro.financials.entity.Contract;
24 import org.turro.financials.entity.Document;
25 import org.turro.jpa.Dao;
26 
31 public class PortfolioErrorsSet extends HashSet<Document> {
32 
33  private Dao dao;
34 
35  public PortfolioErrorsSet() {
36  fillSet(null);
37  }
38 
39  public PortfolioErrorsSet(Contract contract) {
40  fillSet(contract);
41  }
42 
43  private void fillSet(Contract contract) {
44  dao = new FinancialsPU();
45  List<Document> l = dao.getResultList(
46  "select distinct dl.document from DocumentLine dl, DocumentWorkflow dw " +
47  "join dl.document dd " +
48  "join dd.ancestors da " +
49  "where dw.ancestor = da.ancestor.documentDefinition " +
50  "and dw.descendant = dd.documentDefinition " +
51  "and dw.lineType <> dl.lineType"
52  );
53  for(Document d : l) {
54  add(d);
55  }
56  }
57 
58 }
59