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 java.util.Calendar;
019    
020    import org.opengion.fukurou.util.ErrorMessage;
021    import org.opengion.fukurou.util.StringUtil;
022    import org.opengion.hayabusa.db.AbstractDBType;
023    import org.opengion.hayabusa.db.DBTypeCheckUtil;
024    import org.opengion.fukurou.util.HybsDateUtil;
025    
026    /**
027     * 譁?ｭ怜?縺ｮ譎る俣螻樊?(譎?蛻?遘?縺ｮ蜊願ｧ偵?譎る俣繧呈桶縺?ぜ縺ｮ縲√き繝ｩ繝?ｱ樊?繧貞ｮ夂ｾｩ縺励∪縺吶?
028     *
029     * HHmmss 縺ｫ蟇ｾ蠢懊＠縺ｦ縺?ｋ蠢?ｦ√′縺ゅｊ縺ｾ縺吶?
030     * (HHmm縺ｮ繝??繧ｿ縺ｧ繧ょ茜逕ｨ蜿ｯ閭ｽ縺ｧ縺?
031     * 縺溘□縺励?譌･莉倥?謨ｴ蜷域?繝√ぉ繝?け縺ｯ陦後＞縺ｾ縺帙ｓ縺後?valueAdd( String value )縺ｧ縺ｮ
032     * 譌･莉倥?蜉?ｮ玲凾縺ｫ縺ｯ縲∵ｭ｣蠑上↑譌･莉倥ョ繝ｼ繧ｿ縺ｫ縺ｦ蜉?ｮ励＠縺ｾ縺吶?
033     *
034     * 繧ｿ繧､繝励メ繧ｧ繝?け縺ｨ縺励※縲∽ｻ･荳九?譚｡莉ｶ繧貞愛螳壹＠縺ｾ縺吶?
035     * 繝ｻ譁?ｭ怜?髟ｷ縺ｯ縲∫峩謗･險育ｮ励〒譁?ｭ玲焚縺ｨ縺ｮ豈碑ｼ?
036     * 繝ｻ譌･莉倅ｽｿ逕ｨ譁?ｭ励メ繧ｧ繝?け縲?'0' &gt; c || '9' &lt; c)莉･螟悶?繧ｨ繝ｩ繝ｼ
037     * 繝ｻ譁?ｭ励ヱ繝ｩ繝｡繝ｼ繧ｿ縺ｮ 豁｣隕剰｡ｨ迴ｾ繝√ぉ繝?け
038     *
039     * @og.group 繝??繧ｿ螻樊?
040     * @og.rev 5.4.3.6 (2012/01/20)  繧ｿ繧､繝励メ繧ｧ繝?け縺梧栢縺代※縺?ｋ縺ｮ縺ｧ霑ｽ蜉?
041     *
042     * @version  4.0
043     * @author   Kazuhiko Hasegawa
044     * @since    JDK5.0,
045     */
046    public class DBType_HMS extends AbstractDBType {
047            //* 縺薙?繝励Ο繧ｰ繝ｩ繝??VERSION譁?ｭ怜?繧定ｨｭ螳壹＠縺ｾ縺吶?       {@value} */
048            private static final String VERSION = "5.6.1.0 (2013/02/01)" ;
049    
050            /**
051             * String蠑墓焚縺ｮ譁?ｭ怜?繧抵ｼ具ｼ代＠縺滓枚蟄怜?繧定ｿ斐＠縺ｾ縺吶?
052             * 縺薙ｌ縺ｯ縲∬恭蟄励?蝣ｴ蜷?A,B,C 縺ｪ縺ｩ)縺ｯ縲。,C,D 縺ｮ繧医≧縺ｫ,譛?ｵよ｡√?譁?ｭ励さ繝ｼ繝峨ｒ
053             * ?具ｼ?縺励∪縺吶?
054             * 譁?ｭ怜?縺梧焚蟄励ち繧､繝励?蝣ｴ蜷医?, 謨ｰ蟄励↓螟画鋤縺励※縲?1 縺励∪縺吶?(譯∽ｸ翫′繧翫ｂ縺ゅｊ)
055             * 豺ｷ蝨ｨ繧ｿ繧､繝励?蝣ｴ蜷医?,譛?ｾ後?譯√□縺代ｒ遒ｺ隱阪＠縺ｦ ?具ｼ代＠縺ｾ縺吶?
056             * 蠑墓焚縺?null 縺ｮ蝣ｴ蜷医→縲√ぞ繝ｭ譁?ｭ怜?("")縺ｮ蝣ｴ蜷医?,迚ｩ逅?噪蛻晄悄險ｭ螳壼?(String getDefault())
057             * 縺ｮ蛟､繧定ｿ斐＠縺ｾ縺吶?
058             * 
059             * @og.rev 5.8.6.1 (2015/04/17)
060             *
061             * @param       value   String蠑墓焚縺ｮ譁?ｭ怜?
062             *
063             * @return  String蠑墓焚縺ｮ譁?ｭ怜?繧抵ｼ具ｼ代＠縺滓枚蟄怜?
064             */
065            @Override
066            public String valueAdd( final String value ) {
067                    if( value == null || value.length() == 0 ) { return getDefault(); }
068    
069    //              int hour = Integer.parseInt( value.substring( 0,2 ) );
070    //
071    //              // 蜈磯?縺ｫ 00 繧剃ｻ伜刈縺吶ｋ轤ｺ縺ｫ縲∵焚蟄励? 100 繧貞刈邂励＠縺ｦ縺?ｋ縲?
072    //              if( hour < 24 ) { hour = 101 + hour; }
073    //              else                    { hour = 100; }
074    //
075    //              String rtn = hour + value.substring( 2 );
076    //
077    //              return rtn.substring( 1 );
078                    
079                    // 5.8.6.1 (2015/04/10) ?疲｡√ｈ繧雁ｰ上＆縺?→HHmm縲√◎繧御ｻ･螟悶?縲？Hmmss
080                    final boolean isHM = value.length() <= 4 ;
081    
082                    //                        HHmm    HHmmss
083                    final int hms = ( isHM ? 10100 : 1010000 ) + Integer.parseInt( value );
084    
085                    // 蜈??蠖｢蠑上↓貅匁侠縺励※霑斐☆縲?
086                    return String.valueOf( hms ).substring( 1 );
087            }
088    
089            /**
090             * String蠑墓焚縺ｮ譁?ｭ怜?縺ｫ縲∫ｬｬ?貞ｼ墓焚縺ｫ謖?ｮ壹?譁?ｭ怜?(謨ｰ蟄励?譌･莉倡ｭ?繧貞刈邂励＠縺ｦ霑斐＠縺ｾ縺吶?
091             *
092             * 縺薙％縺ｧ縺ｯ縲？Hmmss 蠖｢蠑上?繝??繧ｿ縺ｫ縲∵凾髢薙ｒ蜉?ｮ励＠縺ｾ縺吶?
093             *
094             * 縺薙? HMS 縺ｯ縲∝ｼ墓焚縺ｫ縲∵律莉伜腰菴阪ｒ謖?ｮ壹〒縺阪∪縺吶?蜊倅ｽ阪?縲？Hmmss 蠖｢蠑上?
095             * ?第枚蟄励ｒ謖?ｮ壹＠縺ｾ縺吶?螟ｧ譁?ｭ励?蟆乗枚蟄励ｂ隴伜挨縺励∪縺吶?value="5H" 縺ｨ縺吶ｌ縺ｰ縲?ｼ墓凾髢薙?value="5m"
096             * 縺ｨ縺吶ｌ縺ｰ縲?ｼ募? 霑ｽ蜉?＠縺ｾ縺吶?
097             * 謖?ｮ壹＠縺ｪ縺??蜷医?縲∵凾繧貞刈邂励＠縺ｾ縺吶?
098             *
099             * 縺薙％縺ｮ繝??繧ｿ縺ｯ縲∵凾髢薙′郢ｰ繧願ｶ翫＠縺ｦ繧ゅ?譌･莉倥↓蠖ｱ髻ｿ縺励∪縺帙ｓ縲?
100             * 縺ｾ縺溘??抵ｼ疲凾髢薙ｒ雜?∴縺溷?蜷医?縲?0 譎ゅ↓謌ｻ繧翫∪縺吶?
101             *
102             * @og.rev 5.6.0.3 (2012/01/24) ADD 縺ｫ縲∝ｼ墓焚縺ｮ蛟､繧貞刈邂励☆繧区ｩ溯?繧定ｿｽ蜉?＠縺ｾ縺吶?
103             * @og.rev 5.6.1.0 (2013/02/01) 蜉?ｮ励☆繧句ｼ墓焚縺ｫ縲∵律莉伜腰菴?'H','m','s')繧呈欠螳壼庄閭ｽ縺ｫ縺励∪縺吶?
104             * @og.rev 5.8.6.1 (2015/04/17) 譯∵焚蜿ｯ螟牙ｯｾ蠢?
105             *
106             * @param   value  String蠑墓焚
107             * @param   add    蜉?ｮ励☆繧区凾髢捺枚蟄怜?(蜊倅ｽ堺ｻ倥″:['H','m','s'])
108             *
109             * @return  蠑墓焚縺ｮ譁?ｭ怜?縺ｫ譎る俣繧貞刈邂励＠縺ｾ縺吶?
110             */
111            @Override
112            public String valueAdd( final String value,final String add ) {
113                    if( value == null || value.length() == 0 ) { return getDefault(); }
114    
115                    // 譌･莉俶枚蟄怜?縺ｫ繝?Α繝ｼ縺ｮ蟷ｴ譛域律繧定ｿｽ蜉?＠縺ｦ縺翫￥縲?
116    //              return HybsDateUtil.getDatePlus( ("20100101" + value),add,Calendar.HOUR_OF_DAY,"HHmmss" );
117    
118    //              int addSu = 1;
119    //              if( add != null && !add.isEmpty() ) {
120    //                      addSu = Integer.parseInt( add );
121    //              }
122    
123    //              int hour = Integer.parseInt( value.substring( 0,2 ) ) + addSu;
124    
125                    // 蜈磯?縺ｫ 00 繧剃ｻ伜刈縺吶ｋ轤ｺ縺ｫ縲∵焚蟄励? 100 繧貞刈邂励＠縺ｦ縺?ｋ縲ゅ∪縺溘?24譎る俣繧定ｶ?∴繧句?蜷医?縲?0 縺ｫ謌ｻ繧九?
126    //              String rtn = ( 100 + ( hour % 24 ) ) + value.substring( 2 );            // 蠕後ｍ縺ｯ縲｀MSS縺ｮ蛻?
127                    //           ~~~~~~~~~~~~~~~~~~~~~~~   ~~~~~~~~~~~~~~~~~~~~
128                    //           謨ｰ蟄鈴Κ蛻?                 MMSS縺ｮ譁?ｭ怜?驛ｨ蛻?
129    
130                    // 蜈磯?譁?ｭ怜?繧貞炎髯､縺吶ｋ縲?
131    //              return rtn.substring( 1 );
132                    
133                    // 5.8.6.1 (2015/04/10) ?疲｡√ｈ繧雁ｰ上＆縺?→HHmm縲√◎繧御ｻ･螟悶?縲？Hmmss
134                    final boolean isHM = value.length() <= 4 ;
135    
136                    // 窶ｻ yyyymmd + 1HHmmss 縺ｧ縲∵律莉倥ョ繝ｼ繧ｿ縺ｮ繝?Α繝ｼ縺ｮ蟷ｴ譛域律繧定ｿｽ蜉?
137                    final int hms = 1000000 + Integer.parseInt( isHM ? value + "00" : value );
138    
139                    // 蜈??蠖｢蠑上↓貅匁侠縺励※霑斐☆縲?
140                    return HybsDateUtil.getDatePlus( ( "2010010" + hms ),add,Calendar.HOUR_OF_DAY, isHM ? "HHmm" : "HHmmss" );
141            }
142    
143            /**
144             * 繧ｨ繝?ぅ繧ｿ繝ｼ縺ｧ邱ｨ髮?＆繧後◆繝??繧ｿ繧堤匳骭ｲ縺吶ｋ蝣ｴ蜷医↓縲√ョ繝ｼ繧ｿ縺昴?繧ゅ?繧?
145             * 螟画鋤縺励※縲∝ｮ溽匳骭ｲ繝??繧ｿ繧剃ｽ懈?縺励∪縺吶?
146             * 萓九∴縺ｰ,螟ｧ譁?ｭ励?縺ｿ縺ｮ繝輔ぅ繝ｼ繝ｫ繝峨↑繧峨?螟ｧ譁?ｭ怜喧縺励∪縺吶?
147             * 螳溽匳骭ｲ繝??繧ｿ縺ｮ菴懈?縺ｯ縲．BType 繧ｪ繝悶ず繧ｧ繧ｯ繝医ｒ蛻ｩ逕ｨ縺励∪縺吶?縺ｧ,
148             * 縺薙ｌ縺ｨ Editor 縺ｨ縺後い繝ｳ繝槭ャ繝√?蝣ｴ蜷医?縲√≧縺ｾ縺上ョ繝ｼ繧ｿ螟画鋤
149             * 縺輔ｌ縺ｪ縺?庄閭ｽ諤ｧ縺後≠繧翫∪縺吶?縺ｧ縲∵ｳｨ諢城｡倥＞縺ｾ縺吶?
150             * 
151             * 5.8.6.1 (2015/04/17) 譯∵焚蜿ｯ螟牙ｯｾ蠢?
152             *
153             * @param       value   (荳?握縺ｫ邱ｨ髮?ョ繝ｼ繧ｿ縺ｨ縺励※逋ｻ骭ｲ縺輔ｌ縺溘ョ繝ｼ繧ｿ)
154             *
155             * @return  菫ｮ豁｣蠕後?譁?ｭ怜?(荳?握縺ｫ繝??繧ｿ繝吶?繧ｹ縺ｫ逋ｻ骭ｲ縺吶ｋ繝??繧ｿ)
156             */
157            @Override
158            public String valueSet( final String value ) {
159                    if( value == null || value.length() == 0 ) { return ""; }
160    //              return StringUtil.lTrim0( StringUtil.deleteChar( value,':' ) );
161                    // 5.8.6. (2015/04/03) ?疲｡√ｈ繧雁ｰ上＆縺?→HHmm縲√◎繧御ｻ･螟悶?縲？Hmmss
162                    final String val = StringUtil.deleteChar( value,':' );
163                    final boolean isHM = val.length() <= 4 ;
164    
165                    // 5.8.6.1 (2015/04/17) try-catch
166                    try{
167                            //                        HHmm    HHmmss
168                            final int hms = ( isHM ? 10000 : 1000000 ) + Integer.parseInt( val );
169            
170                            // 蜈??蠖｢蠑上↓貅匁侠縺励※霑斐☆縲?
171                            return String.valueOf( hms ).substring( 1 );
172                    }
173                    catch( NumberFormatException ex ) {
174                            return val;             
175                    }
176            }
177    
178            /**
179             * 繝??繧ｿ縺檎匳骭ｲ蜿ｯ閭ｽ縺九←縺?°繧偵メ繧ｧ繝?け縺励∪縺吶?
180             * 繝??繧ｿ縺後お繝ｩ繝ｼ縺ｮ蝣ｴ蜷医?縲√◎縺ｮ繧ｨ繝ｩ繝ｼ蜀?ｮｹ繧定ｿ斐＠縺ｾ縺吶?
181             *
182             * @og.rev 5.2.3.6 (2012/01/20) 謨ｰ蛟､縺ｮ縺ｿ縺ｫ髯仙ｮ壹☆繧九◆繧√↓霑ｽ蜉?
183             * @og.rev 5.6.0.3 (2012/01/24) ADD 縺ｫ縲∝ｼ墓焚縺ｮ蛟､繧貞刈邂励☆繧区ｩ溯?繧定ｿｽ蜉?＠縺ｾ縺吶?
184             *
185             * @param   key         繧ｭ繝ｼ
186             * @param   value       蛟､
187             * @param   sizeX       謨ｴ謨ｰ驛ｨ蛻??譁?ｭ怜?縺ｮ髟ｷ縺?
188             * @param   sizeY       蟆第焚驛ｨ蛻??譁?ｭ怜?縺ｮ髟ｷ縺?
189             * @param   typeParam   dbType 繝代Λ繝｡繝ｼ繧ｿ
190             * @param   isStrict    蜴ｳ蟇?↓繝√ぉ繝?け縺吶ｋ縺九←縺?°[true:縺吶ｋ/false:讓呎ｺ也噪]
191             *
192             * @return  繧ｨ繝ｩ繝ｼ蜀?ｮｹ
193             */
194            @Override
195            public ErrorMessage valueCheck( final String key ,final String value ,
196                                                                            final int sizeX ,final int sizeY ,final String typeParam ,final boolean isStrict) {
197                    String checkVal = valueSet(value); // ?壹?蠢ｵ縺ｮ縺溘ａ螟悶＠縺ｦ縺翫￥
198    
199                    ErrorMessage msg = new ErrorMessage();
200                    if( checkVal == null || checkVal.length() == 0 ) { return msg; }
201    
202                    int len = (sizeY == 0) ? sizeX : sizeX + sizeY + 1;
203                    if( isStrict ) {
204                            if( len != checkVal.length() ) {
205                                    // 譁?ｭ怜?縺ｮ髟ｷ縺輔′謖?ｮ壹?髟ｷ縺輔→逡ｰ縺ｪ繧翫∪縺吶?
206                                    msg.addMessage( 0,ErrorMessage.NG,"ERR0011", key,value, String.valueOf( value.length() ), String.valueOf( len ) );
207                            }
208                    }
209                    else {
210                            if( len < checkVal.length() ) {
211                                    // 譁?ｭ怜?縺ｮ髟ｷ縺輔′謖?ｮ壹?髟ｷ縺輔ｈ繧翫ｂ髟ｷ縺?〒縺吶?
212                                    msg.addMessage( 0,ErrorMessage.NG,"ERR0006",key,value,
213                                                                                    String.valueOf( value.length() ),String.valueOf( len ) );
214                            }
215                    }
216    
217    //              StringBuilder val = new StringBuilder();
218    //              boolean isError = false;
219    //              for( int i=0; i<checkVal.length(); i++ ) {
220    //                      char ch = checkVal.charAt( i );
221    //                      if( ('0' > ch || '9' < ch) ) {
222    //                              val.append( "<span class=\"NG\">" ).append( ch ).append( "</span>" );
223    //                              isError = true;
224    //                      }
225    //                      else {
226    //                              val.append( ch );
227    //                      }
228    //              }
229    //              if( isError ) {
230    //                      // 謖?ｮ壹?譁?ｭ嶺ｻ･螟悶?譁?ｭ励′菴ｿ繧上ｌ縺ｦ縺?∪縺吶?
231    //                      msg.addMessage( 0,ErrorMessage.NG,"ERR0009", key,val.toString() );
232    //              }
233    
234                    // 5.6.0.3 (2012/01/24) 譁?ｭ励?遽?峇繝√ぉ繝?け
235                    String check = DBTypeCheckUtil.rangeCheck( checkVal, '0', '9' );
236                    if( check != null ) {
237                            // 謖?ｮ壹?譁?ｭ嶺ｻ･螟悶?譁?ｭ励′菴ｿ繧上ｌ縺ｦ縺?∪縺吶?
238                            msg.addMessage( 0,ErrorMessage.NG,"ERR0009", key,check );
239                    }
240    
241                    // 5.6.0.3 (2012/01/24) 譎ょ?遘偵?謨ｴ蜷域?繝√ぉ繝?け
242                    check = DBTypeCheckUtil.hmsFormatCheck( checkVal );
243                    if( check != null ) {
244                            // 謖?ｮ壹?譁?ｭ嶺ｻ･螟悶?譁?ｭ励′菴ｿ繧上ｌ縺ｦ縺?∪縺吶?
245                            msg.addMessage( 0,ErrorMessage.NG,"ERR0009", key,check );
246                    }
247    
248                    // 3.6.0.0 (2004/09/22) dbType 繝代Λ繝｡繝ｼ繧ｿ繧剃ｽｿ逕ｨ縺励◆繝槭ャ繝√メ繧ｧ繝?け
249                    check = DBTypeCheckUtil.matcheCheck( checkVal,typeParam );
250                    if( check != null ) {
251                            // 謖?ｮ壹?譁?ｭ嶺ｻ･螟悶?譁?ｭ励′菴ｿ繧上ｌ縺ｦ縺?∪縺吶?
252                            msg.addMessage( 0,ErrorMessage.NG,"ERR0009", key,check );
253                    }
254    
255                    return msg;
256            }
257    }