OpenConcerto

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

svn://code.openconcerto.org/openconcerto

Rev

Rev 182 | Show entire file | Regard whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 182 Rev 185
Line 21... Line 21...
21 
import org.openconcerto.ql.LabelCreator;
 21 
import org.openconcerto.ql.LabelCreator;
22 
import org.openconcerto.ql.QLPrinter;
 22 
import org.openconcerto.ql.QLPrinter;
23 
import org.openconcerto.sql.Configuration;
 23 
import org.openconcerto.sql.Configuration;
24 
import org.openconcerto.sql.element.SQLComponent;
 24 
import org.openconcerto.sql.element.SQLComponent;
25 
import org.openconcerto.sql.model.FieldPath;
 25 
import org.openconcerto.sql.model.FieldPath;
- 
 
 26 
import org.openconcerto.sql.model.SQLRow;
26 
import org.openconcerto.sql.model.SQLRowAccessor;
 27 
import org.openconcerto.sql.model.SQLRowAccessor;
27 
import org.openconcerto.sql.model.SQLRowValues;
 28 
import org.openconcerto.sql.model.SQLRowValues;
28 
import org.openconcerto.sql.model.Where;
 29 
import org.openconcerto.sql.model.Where;
29 
import org.openconcerto.sql.model.graph.Path;
 30 
import org.openconcerto.sql.model.graph.Path;
30 
import org.openconcerto.sql.preferences.SQLPreferences;
 31 
import org.openconcerto.sql.preferences.SQLPreferences;
Line 95... Line 96...
95 
        } catch (Exception e) {
 96 
        } catch (Exception e) {
96 
            e.printStackTrace();
 97 
            e.printStackTrace();
97 
        }
 98 
        }
98 
    }
 99 
    }
99 
 
 100 
 
- 
 
 101 
    @Override
- 
 
 102 
    public String getDescription(SQLRow fromRow) {
- 
 
 103 
        return fromRow.getString("CODE") + " " + fromRow.getString("NOM");
- 
 
 104 
    }
- 
 
 105 
 
100 
    public void printLabel(SQLRowAccessor row, String qlPrinterProperty) {
 106 
    public void printLabel(SQLRowAccessor row, String qlPrinterProperty) {
101 
        final LabelCreator c = new LabelCreator(720);
 107 
        final LabelCreator c = new LabelCreator(720);
102 
        c.setLeftMargin(10);
 108 
        c.setLeftMargin(10);
103 
        c.setTopMargin(10);
 109 
        c.setTopMargin(10);
104 
        c.setDefaultFont(new Font("Verdana", Font.PLAIN, 50));
 110 
        c.setDefaultFont(new Font("Verdana", Font.PLAIN, 50));
Line 190... Line 196...
190 
    }
 196 
    }
191 
 
 197 
 
192 
    @Override
 198 
    @Override
193 
    protected void _initTableSource(SQLTableModelSource res) {
 199 
    protected void _initTableSource(SQLTableModelSource res) {
194 
        super._initTableSource(res);
 200 
        super._initTableSource(res);
195 
 
 - 
 
- 
 
 201 
        addCommercialFilter(res, getTable().getField("ID_COMMERCIAL"));
196 
        res.getColumns().add(new BaseSQLTableModelColumn(getDirectory().getTranslator().getLabelFor(getTable().getField("CATEGORIES")), String.class) {
 202 
        res.getColumns().add(new BaseSQLTableModelColumn(getDirectory().getTranslator().getLabelFor(getTable().getField("CATEGORIES")), String.class) {
197 
 
 203 
 
198 
            @Override
 204 
            @Override
199 
            protected Object show_(SQLRowAccessor r) {
 205 
            protected Object show_(SQLRowAccessor r) {
200 
 
 206 
 
Line 212... Line 218...
212 
    }
 218 
    }
213 
 
 219 
 
214 
    @Override
 220 
    @Override
215 
    protected void _initComboRequest(ComboSQLRequest req) {
 221 
    protected void _initComboRequest(ComboSQLRequest req) {
216 
        super._initComboRequest(req);
 222 
        super._initComboRequest(req);
- 
 
 223 
        addCommercialFilterCombo(req, getTable().getField("ID_COMMERCIAL"));
217 
        req.setWhere(new Where(getTable().getField("OBSOLETE"), "=", Boolean.FALSE));
 224 
        req.putWhere("Obsolete", new Where(getTable().getField("OBSOLETE"), "=", Boolean.FALSE));
218 
    }
 225 
    }
219 
 
 226 
 
220 
    /*
 227 
    /*
221 
     * (non-Javadoc)
 228 
     * (non-Javadoc)
222 
     *
229 
     *