OpenConcerto

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

svn://code.openconcerto.org/openconcerto

Rev

Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
177 ilm 1
/*
2
 * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS HEADER.
3
 *
4
 * Copyright 2011 OpenConcerto, by ILM Informatique. All rights reserved.
5
 *
6
 * The contents of this file are subject to the terms of the GNU General Public License Version 3
7
 * only ("GPL"). You may not use this file except in compliance with the License. You can obtain a
8
 * copy of the License at http://www.gnu.org/licenses/gpl-3.0.html See the License for the specific
9
 * language governing permissions and limitations under the License.
10
 *
11
 * When distributing the software, include this License Header Notice in each file.
12
 */
13
 
14
 package org.openconcerto.erp.generationDoc.provider;
15
 
16
import org.openconcerto.erp.generationDoc.SpreadSheetCellValueContext;
17
import org.openconcerto.erp.generationDoc.SpreadSheetCellValueProvider;
18
import org.openconcerto.erp.generationDoc.SpreadSheetCellValueProviderManager;
19
import org.openconcerto.sql.model.SQLBackgroundTableCache;
20
import org.openconcerto.sql.model.SQLRow;
21
import org.openconcerto.sql.model.SQLTable;
22
 
23
import java.util.List;
24
 
25
import com.ibm.icu.math.BigDecimal;
26
 
27
public class FichePayePlafondAProvider implements SpreadSheetCellValueProvider {
28
 
29
    @Override
30
    public Object getValue(SpreadSheetCellValueContext context) {
31
        SQLTable tableVar = context.getRow().getTable().getDBRoot().findTable("VARIABLE_PAYE");
32
        List<SQLRow> rows = SQLBackgroundTableCache.getInstance().getCacheForTable(tableVar).getRows();
33
        for (SQLRow sqlRow : rows) {
34
            if (sqlRow.getString("NOM").equals("PLAFOND_TRANCHE_A")) {
35
                return new BigDecimal(sqlRow.getFloat("VALEUR"));
36
            }
37
        }
38
        BigDecimal smic = new BigDecimal(3377);
39
        return smic;
40
    }
41
 
42
    public static void register() {
43
        SpreadSheetCellValueProviderManager.put("fichepaye.plafond", new FichePayePlafondAProvider());
44
    }
45
 
46
}