001    /*
002     * Copyright (c) 2009 The openGion Project.
003     *
004     * Licensed under the Apache License, Version 2.0 (the "License");
005     * you may not use this file except in compliance with the License.
006     * You may obtain a copy of the License at
007     *
008     *     http://www.apache.org/licenses/LICENSE-2.0
009     *
010     * Unless required by applicable law or agreed to in writing, software
011     * distributed under the License is distributed on an "AS IS" BASIS,
012     * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND,
013     * either express or implied. See the License for the specific language
014     * governing permissions and limitations under the License.
015     */
016    package org.opengion.plugin.column;
017    
018    import org.opengion.fukurou.util.ErrorMessage;
019    import org.opengion.fukurou.util.StringUtil;
020    import org.opengion.hayabusa.db.AbstractDBType;
021    import org.opengion.hayabusa.db.DBTypeCheckUtil;
022    
023    /**
024     * 蜊願ｧ呈焚蟄励? NUMBER 繧呈桶縺?ぜ縺ｮ縲√き繝ｩ繝?ｱ樊?繧貞ｮ夂ｾｩ縺励∪縺吶?
025     *
026     * '0' ??'9' ,'-' ,'.',',' 縺ｧ縺ｮ縺ｿ讒区?縺輔ｌ縺ｦ縺?ｋ譁?ｭ怜梛繧ｫ繝ｩ繝?ｱ樊?繧貞ｮ夂ｾｩ縺励∪縺吶?
027     * S9 縺ｨ逡ｰ縺ｪ繧翫?繧ｫ繝ｳ繝?,'縺悟性縺ｾ繧後※縺?※繧?OK 縺ｨ縺励?繝??繧ｿ縺九ｉ繧ょ叙繧企勁縺阪∪縺帙ｓ縲?
028     *
029     * 繧ｿ繧､繝励メ繧ｧ繝?け縺ｨ縺励※縲∽ｻ･荳九?譚｡莉ｶ繧貞愛螳壹＠縺ｾ縺吶?
030     * 繝ｻ?撰ｽ橸ｼ吶?繝槭う繝翫せ(-)縲∝ｰ乗焚轤ｹ(.)縺翫ｈ縺ｳ繧ｫ繝ｳ繝?,)繧定ｨｱ蜿ｯ
031     * 繝ｻ譁?ｭ怜?縺ｮ髟ｷ縺輔メ繧ｧ繝?け
032     * 繝ｻ蟆乗焚轤ｹ縺ｮ菴咲ｽｮ繝√ぉ繝?け
033     * 繝ｻ隨ｦ蜿ｷ縺ｮ菴咲ｽｮ繝√ぉ繝?け
034     * 繝ｻ譁?ｭ励ヱ繝ｩ繝｡繝ｼ繧ｿ縺ｮ 豁｣隕剰｡ｨ迴ｾ繝√ぉ繝?け
035     *
036     * @og.group 繝??繧ｿ螻樊?
037     *
038     * @version  4.0
039     * @author       Kazuhiko Hasegawa
040     * @since    JDK5.0,
041     */
042    public class DBType_X9 extends AbstractDBType {
043            //* 縺薙?繝励Ο繧ｰ繝ｩ繝??VERSION譁?ｭ怜?繧定ｨｭ螳壹＠縺ｾ縺吶?       {@value} */
044            private static final String VERSION = "5.2.2.0 (2010/11/01)" ;
045    
046            /**
047             * 蜊願ｧ抵ｼ先枚蟄励?蝗ｺ螳夐聞縺ｧFILL蝓九ａ縺輔ｌ縺滓枚蟄怜?繧定ｿ斐＠縺ｾ縺吶?
048             * 縺ｪ縺翫?繧ｨ繝ｩ繝ｼ繝√ぉ繝?け縺ｯ陦後ｏ繧後∪縺帙ｓ縲?
049             * 螳溯｡悟燕縺ｫ縲∝ｿ?★ valueCheck( String value ,int len ) 縺瑚｡後ｏ繧後ｋ蠢?ｦ√′縺ゅｊ縺ｾ縺吶?
050             *
051             * @og.rev 3.5.4.5 (2004/01/23) 繧ｨ繝ｳ繧ｳ繝ｼ繝画欠螳壹↓螟画峩縺励∪縺吶?
052             *
053             * @param       value    ?ｦ?ｩ?ｬ?ｬ蝓九ａ縺吶ｋ譁?ｭ怜?
054             * @param       sizeX    謨ｴ謨ｰ驛ｨ蛻??譁?ｭ怜?縺ｮ髟ｷ縺?
055             * @param       sizeY    蟆第焚驛ｨ蛻??譁?ｭ怜?縺ｮ髟ｷ縺?
056             * @param       encode   繧ｨ繝ｳ繧ｳ繝ｼ繝画欠螳?
057             *
058             * @return      ?ｦ?ｩ?ｬ?ｬ蝓九ａ縺励◆譁ｰ縺励＞譁?ｭ怜?
059             */
060            @Override
061            public String valueFill( final String value ,final int sizeX ,final int sizeY,final String encode ) {
062                    int len = (sizeY == 0) ? sizeX : sizeX + sizeY + 1;
063    
064                    // 豕ｨ諢?繝槭う繝翫せ險伜捷縺ｮ蜃ｦ逅?′縺ｾ縺?〒縺吶?
065                    return StringUtil.intFill( value,len );
066            }
067    
068            /**
069             * String蠑墓焚縺ｮ譁?ｭ怜?繧抵ｼ具ｼ代＠縺滓枚蟄怜?繧定ｿ斐＠縺ｾ縺吶?
070             * 縺薙ｌ縺ｯ縲∵枚蟄怜梛謨ｰ蟄励ち繧､繝励?蝣ｴ蜷医?, 繝槭う繝翫せ縲√き繝ｳ繝槭?繝斐Μ繧ｪ繝峨ｒ驕ｿ縺代※縲?
071             * +1 縺励∪縺吶?(譯∽ｸ翫′繧翫ｂ縺ゅｊ)
072             * 繝??繧ｿ縺ｮ蛟､縺後?繝槭う繝翫せ縺ｮ蝣ｴ蜷医?縲∫ｵ先棡逧?↓繝槭う繝翫せ縺励※縺?″縺ｾ縺吶?
073             * 繧ｫ繝ｳ繝樒ｷｨ髮?12,345,678 縺ｪ縺ｩ)縺後≠繧句?蜷医↓縲∵｡∽ｸ翫′繧翫＠縺ｦ繧ゅ?繧ｫ繝ｳ繝槭?霑ｽ蜉?＆繧後∪縺帙ｓ縲?
074             * 繝槭う繝翫せ譎ゅ?譯∽ｸ翫′繧翫↓縺ｯ縲∝ｯｾ蠢懊＠縺ｦ縺?∪縺吶?
075             * 蠑墓焚縺?null 縺ｮ蝣ｴ蜷医→縲√ぞ繝ｭ譁?ｭ怜?("")縺ｮ蝣ｴ蜷医?,迚ｩ逅?噪蛻晄悄險ｭ螳壼?(String getDefault())
076             * 縺ｮ蛟､繧定ｿ斐＠縺ｾ縺吶?
077             *
078             * @param       value   String蠑墓焚縺ｮ譁?ｭ怜?
079             *
080             * @return      String蠑墓焚縺ｮ譁?ｭ怜?繧抵ｼ具ｼ代＠縺滓枚蟄怜?
081             */
082            @Override
083            public String valueAdd( final String value ) {
084                    if( value == null || value.length() == 0 ) { return getDefault(); }
085                    char[] chs = value.toCharArray() ;
086                    boolean over = false;
087                    for( int i=chs.length-1; i>=0; i-- ) {
088                            if( chs[i] == '-' || chs[i] == '.' || chs[i] == ',' ) { continue; }
089                            if( chs[i] == '9' ) { chs[i] = '0'; over = true; }
090                            else { chs[i]++; over = false; break; }
091                    }
092                    if( over ) {
093                            char[] chs2 = new char[ chs.length + 1 ];
094                            System.arraycopy( chs,0,chs2,1,chs.length );
095                            if( chs[0] == '-' ) {
096                                    chs2[0] = '-';
097                                    chs2[1] = '1';
098                            }
099                            else {
100                                    chs2[0] = '1';
101                            }
102                            chs = chs2;
103                    }
104                    return new String( chs );
105            }
106    
107            /**
108             * 繧ｨ繝?ぅ繧ｿ繝ｼ縺ｧ邱ｨ髮?＆繧後◆繝??繧ｿ繧堤匳骭ｲ縺吶ｋ蝣ｴ蜷医↓縲√ョ繝ｼ繧ｿ縺昴?繧ゅ?繧?
109             * 螟画鋤縺励※縲∝ｮ溽匳骭ｲ繝??繧ｿ繧剃ｽ懈?縺励∪縺吶?
110             * 萓九∴縺ｰ,螟ｧ譁?ｭ励?縺ｿ縺ｮ繝輔ぅ繝ｼ繝ｫ繝峨↑繧峨?螟ｧ譁?ｭ怜喧縺励∪縺吶?
111             * 螳溽匳骭ｲ繝??繧ｿ縺ｮ菴懈?縺ｯ縲．BType 繧ｪ繝悶ず繧ｧ繧ｯ繝医ｒ蛻ｩ逕ｨ縺励∪縺吶?縺ｧ,
112             * 縺薙ｌ縺ｨ Editor 縺ｨ縺後い繝ｳ繝槭ャ繝√?蝣ｴ蜷医?縲√≧縺ｾ縺上ョ繝ｼ繧ｿ螟画鋤
113             * 縺輔ｌ縺ｪ縺?庄閭ｽ諤ｧ縺後≠繧翫∪縺吶?縺ｧ縲∵ｳｨ諢城｡倥＞縺ｾ縺吶?
114             *
115             * @og.rev 3.3.3.0 (2003/07/09) 蜑榊ｾ後?繧ｹ繝壹?繧ｹ繧貞叙繧企勁縺?※縺翫￥縲?
116             * @og.rev 3.3.3.1 (2003/07/18) 蠕後ｍ繧ｹ繝壹?繧ｹ繧貞叙繧企勁縺上?(StringUtil#rTrim)
117             *
118             * @param       value   (荳?握縺ｫ邱ｨ髮?ョ繝ｼ繧ｿ縺ｨ縺励※逋ｻ骭ｲ縺輔ｌ縺溘ョ繝ｼ繧ｿ)
119             *
120             * @return      菫ｮ豁｣蠕後?譁?ｭ怜?(荳?握縺ｫ繝??繧ｿ繝吶?繧ｹ縺ｫ逋ｻ骭ｲ縺吶ｋ繝??繧ｿ)
121             */
122            @Override
123            public String valueSet( final String value ) {
124                    return StringUtil.rTrim( value ) ;
125            }
126    
127            /**
128             * 繝??繧ｿ縺檎匳骭ｲ蜿ｯ閭ｽ縺九←縺?°繧偵メ繧ｧ繝?け縺励∪縺吶?
129             * 繝??繧ｿ縺後お繝ｩ繝ｼ縺ｮ蝣ｴ蜷医?縲√◎縺ｮ繧ｨ繝ｩ繝ｼ蜀?ｮｹ繧定ｿ斐＠縺ｾ縺吶?
130             * 險ｱ蜿ｯ縺吶ｋ譁?ｭ励?縲?-9 縺ｮ謨ｰ蟄励?繝槭う繝翫せ(-) 縲∝ｰ乗焚轤ｹ(.)縺ｧ縺吶?
131             * 蟆乗焚轤ｹ縺ｮ菴咲ｽｮ繝√ぉ繝?け縺ｯ陦後＞縺ｾ縺帙ｓ縲?
132             *
133             * @og.rev 2.3.1.4 (2003/02/18) 螻樊?繝√ぉ繝?け繧貞ｼｷ蛹悶＠縺溘?
134             * @og.rev 3.6.0.0 (2004/09/22) 繝√ぉ繝?け鬆?岼縺ｯ縲∵焚蟄励ｒ險ｱ蜿ｯ縺吶ｋ譁?ｭ怜?縺ｨ縺吶ｋ縲?
135             * @og.rev 3.6.0.0 (2004/09/22) dbType 繝代Λ繝｡繝ｼ繧ｿ繧貞ｼ墓焚縺ｫ霑ｽ蜉?
136             * @og.rev 5.2.2.0 (2010/11/01) 蜴ｳ蟇?↓繝√ぉ繝?け(isStrict=true)縺吶ｋ繝輔Λ繧ｰ繧定ｿｽ蜉?
137             *
138             * @param   key         繧ｭ繝ｼ
139             * @param   value       蛟､
140             * @param   sizeX       謨ｴ謨ｰ驛ｨ蛻??譁?ｭ怜?縺ｮ髟ｷ縺?
141             * @param   sizeY       蟆第焚驛ｨ蛻??譁?ｭ怜?縺ｮ髟ｷ縺?
142             * @param   typeParam   dbType 繝代Λ繝｡繝ｼ繧ｿ
143             * @param   isStrict    蜴ｳ蟇?↓繝√ぉ繝?け縺吶ｋ縺九←縺?°[true:縺吶ｋ/false:讓呎ｺ也噪]
144             *
145             * @return  繧ｨ繝ｩ繝ｼ蜀?ｮｹ
146             */
147    //      public ErrorMessage valueCheck( final String key ,final String value ,
148    //                                                                      final int sizeX ,final int sizeY ,final String param ) {
149            @Override
150            public ErrorMessage valueCheck( final String key ,final String value ,
151                                                                            final int sizeX ,final int sizeY ,final String typeParam ,final boolean isStrict) {
152    
153                    ErrorMessage msg = new ErrorMessage();
154                    if( value == null || value.length() == 0 ) { return msg; }
155    
156                    // 繝√ぉ繝?け逕ｨ縺ｮvalue 繧堤畑諢上＠縺ｾ縺吶?繧ｫ繝ｳ繝?,)繧貞叙繧企勁縺?※縺翫￥轤ｺ縺ｧ縺吶?
157                    String tmpValue = StringUtil.deleteChar(value,',' );
158                    String check;
159    
160                    // 3.6.0.0 (2004/09/22) 繝√ぉ繝?け蜀?ｮｹ螟画峩
161                    check = DBTypeCheckUtil.decimalFormatCheck( tmpValue );
162                    if( check != null ) {
163                            // 謖?ｮ壹?譁?ｭ嶺ｻ･螟悶?譁?ｭ励′菴ｿ繧上ｌ縺ｦ縺?∪縺吶?
164                            msg.addMessage( 0,ErrorMessage.NG,"ERR0009", key,check );
165                    }
166    
167                    check = DBTypeCheckUtil.decimalCodeCheck( tmpValue );
168                    if( check != null ) {
169                            // 隨ｦ蜿ｷ縺ｮ菴咲ｽｮ縺御ｸ肴ｭ｣縺ｧ縺吶?
170                            msg.addMessage( 0, ErrorMessage.NG, "ERR0023", key, check );
171                    }
172    
173                    // 3.6.0.0 (2004/09/22) 霑ｽ蜉?
174                    check = DBTypeCheckUtil.decimalPointCheck( tmpValue );
175                    if( check != null ) {
176                            // 蟆乗焚轤ｹ縺ｮ菴咲ｽｮ縺御ｸ肴ｭ｣縺ｧ縺吶?
177                            msg.addMessage( 0, ErrorMessage.NG, "ERR0024", key, check );
178                    }
179    
180                    // 3.6.0.0 (2004/09/22) dbType 繝代Λ繝｡繝ｼ繧ｿ繧剃ｽｿ逕ｨ縺励◆繝槭ャ繝√メ繧ｧ繝?け
181                    check = DBTypeCheckUtil.matcheCheck( tmpValue,typeParam );
182                    if( check != null ) {
183                            // 謖?ｮ壹?譁?ｭ嶺ｻ･螟悶?譁?ｭ励′菴ｿ繧上ｌ縺ｦ縺?∪縺吶?
184                            msg.addMessage( 0,ErrorMessage.NG,"ERR0009", key,check );
185                    }
186    
187                    return msg;
188            }
189    }