OpenConcerto

Dépôt officiel du code source de l'ERP OpenConcerto
sonarqube

svn://code.openconcerto.org/openconcerto

Rev

Rev 177 | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 177 Rev 180
Line 21... Line 21...
21 
import org.openconcerto.sql.view.list.BaseSQLTableModelColumn;
 21 
import org.openconcerto.sql.view.list.BaseSQLTableModelColumn;
22 
import org.openconcerto.sql.view.list.SQLTableModelSource;
 22 
import org.openconcerto.sql.view.list.SQLTableModelSource;
23 
import org.openconcerto.utils.CollectionUtils;
 23 
import org.openconcerto.utils.CollectionUtils;
24 
 
 24 
 
25 
import java.util.ArrayList;
 25 
import java.util.ArrayList;
- 
 
 26 
import java.util.Collection;
26 
import java.util.List;
 27 
import java.util.List;
27 
import java.util.Set;
 28 
import java.util.Set;
28 
 
 29 
 
29 
public class ReglerMontantSQLElement extends ComptaSQLConfElement {
 30 
public class ReglerMontantSQLElement extends ComptaSQLConfElement {
30 
 
 31 
 
Line 49... Line 50...
49 
    }
 50 
    }
50 
 
 51 
 
51 
    @Override
 52 
    @Override
52 
    protected void _initTableSource(SQLTableModelSource res) {
 53 
    protected void _initTableSource(SQLTableModelSource res) {
53 
        super._initTableSource(res);
 54 
        super._initTableSource(res);
- 
 
 55 
 
- 
 
 56 
        final BaseSQLTableModelColumn racColFact = new BaseSQLTableModelColumn("Factures associées", String.class) {
- 
 
 57 
            @Override
- 
 
 58 
            protected Object show_(SQLRowAccessor r) {
- 
 
 59 
 
- 
 
 60 
                Collection<? extends SQLRowAccessor> l = r.getReferentRows(r.getTable().getTable("REGLER_MONTANT_ELEMENT"));
- 
 
 61 
                String s = "";
- 
 
 62 
                for (SQLRowAccessor sqlRowAccessor : l) {
- 
 
 63 
                    if (!sqlRowAccessor.isForeignEmpty("ID_MOUVEMENT_ECHEANCE")) {
- 
 
 64 
                        SQLRowAccessor rMvt = sqlRowAccessor.getForeign("ID_MOUVEMENT_ECHEANCE");
- 
 
 65 
                        if (!rMvt.isForeignEmpty("ID_PIECE")) {
- 
 
 66 
                            SQLRowAccessor rP = rMvt.getForeign("ID_PIECE");
- 
 
 67 
                            s += (s.trim().length() > 0 ? ", " : "") + rP.getString("NOM");
- 
 
 68 
                        }
- 
 
 69 
                    }
- 
 
 70 
                }
- 
 
 71 
 
- 
 
 72 
                return s;
- 
 
 73 
            }
- 
 
 74 
 
- 
 
 75 
            @Override
- 
 
 76 
            public Set<FieldPath> getPaths() {
- 
 
 77 
                Path p = new Path(getTable());
- 
 
 78 
                Path p2 = p.add(p.getLast().getTable("REGLER_MONTANT_ELEMENT"));
- 
 
 79 
                Path p3 = p2.add(p2.getLast().getField("ID_MOUVEMENT_ECHEANCE"));
- 
 
 80 
                Path p4 = p3.add(p3.getLast().getField("ID_PIECE"));
- 
 
 81 
                return CollectionUtils.createSet(new FieldPath(p4, "NOM"));
- 
 
 82 
            }
- 
 
 83 
        };
- 
 
 84 
 
- 
 
 85 
        res.getColumns().add(racColFact);
- 
 
 86 
 
54 
        final BaseSQLTableModelColumn racCol = new BaseSQLTableModelColumn("Report échéance", Boolean.class) {
 87 
        final BaseSQLTableModelColumn racCol = new BaseSQLTableModelColumn("Report échéance", Boolean.class) {
55 
            @Override
 88 
            @Override
56 
            protected Object show_(SQLRowAccessor r) {
 89 
            protected Object show_(SQLRowAccessor r) {
57 
 
 90 
 
58 
                return !r.getForeign("ID_MODE_REGLEMENT").getBoolean("COMPTANT");
 91 
                return !r.getForeign("ID_MODE_REGLEMENT").getBoolean("COMPTANT");