com.github.mygreen.cellformatter.ConditionNumberFormatter Maven / Gradle / Ivy

Go to download
Show more of this group Show more artifacts with this name
Show all versions of excel-cellformatter Show documentation
Excelのセルの書式を解析してフォーマットするライブラリ。
There is a newer version: 0.12
package com.github.mygreen.cellformatter;

import java.util.List;
import java.util.Locale;
import java.util.concurrent.CopyOnWriteArrayList;

import com.github.mygreen.cellformatter.callback.Callback;
import com.github.mygreen.cellformatter.number.FormattedNumber;
import com.github.mygreen.cellformatter.number.NumberFactory;
import com.github.mygreen.cellformatter.term.NumberTerm;
import com.github.mygreen.cellformatter.term.Term;
import com.github.mygreen.cellformatter.tokenizer.Token;


/**
 * 数値のフォーマッタ
 * @version 0.5
 * @author T.TSUCHIE
 *
 */
public class ConditionNumberFormatter extends ConditionFormatter {
    
    /**
     * 各書式の項
     */
    private List> terms = new CopyOnWriteArrayList<>();
    
    /**
     * フォーマット対象の数値を作成する
     */
    private NumberFactory numberFactory;
    
    public ConditionNumberFormatter(final String pattern) {
        super(pattern);
    }
    
    @Override
    public FormatterType getType() {
        return FormatterType.Number;
    }
    
    @Override
    public boolean isMatch(final CommonCell cell) {
        if(!cell.isNumber()) {
            return false;
        }
        
        final double value = cell.getNumberCellValue();
        return getOperator().isMatch(value);
    }
    
    @SuppressWarnings({"unchecked", "rawtypes"})
    @Override
    public CellFormatResult format(final CommonCell cell, final Locale runtimeLocale) {
        
        final double number = cell.getNumberCellValue();
        final FormattedNumber numObj = numberFactory.create(number);
        
        final StringBuilder sb = new StringBuilder();
        if(getOperator().equals(ConditionOperator.ALL) && numObj.isNegative()) {
            //条件がALLの時に符号を付ける。
            sb.append("-");
        }
        
        for(Term term : terms) {
            sb.append(term.format(numObj, getLocale(), runtimeLocale));
        }
        
        //TODO: 項目ごとに特殊条件の処理を行う。
        
        // 特殊条件の処理を行う。
        String value = sb.toString();
        for(Callback callback : getCallbacks()) {
            
            final Locale locale;
            if(getLocale() != null) {
                locale = getLocale().getLocale();
            } else {
                locale = runtimeLocale;
            }
            
            if(!callback.isApplicable(locale)) {
                continue;
            }
            
            value = callback.call(number, value, locale);
        }
        
        final CellFormatResult result = new CellFormatResult();
        result.setValue(number);
        result.setText(value);
        result.setTextColor(getColor());
        result.setSectionPattern(getPattern());
        result.setCellType(FormatCellType.Number);
        
        return result;
    }
    
    /**
     * フォーマットの項を追加する。
     * @param term
     */
    public void addTerm(final Term term) {
        this.terms.add(term);
    }
    
    /**
     * フォーマットの項を全て取得する。
     * @return
     */
    public List> getTerms() {
        return terms;
    }
    
    /**
     * 記号用の項の中で、指定した記号を含むかどうか。
     * @param symbol
     * @return
     */
    public boolean containsSymbolTerm(Token.Symbol symbol) {
        
        for(Term term : terms) {
            if(!(term instanceof NumberTerm.SymbolTerm)) {
                continue;
            }
            
            final NumberTerm.SymbolTerm symbolTerm = (NumberTerm.SymbolTerm) term;
            if(symbolTerm.getToken().equals(symbol)) {
                return true;
            }
        }
        
        return false;
        
    }
    
    public NumberFactory getNumberFactory() {
        return numberFactory;
    }
    
    public void setNumberFactory(NumberFactory numberFactory) {
        this.numberFactory = numberFactory;
    }
}