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             * @param       value   String蠑墓焚縺ｮ譁?ｭ怜?
060             *
061             * @return  String蠑墓焚縺ｮ譁?ｭ怜?繧抵ｼ具ｼ代＠縺滓枚蟄怜?
062             */
063            @Override
064            public String valueAdd( final String value ) {
065                    if( value == null || value.length() == 0 ) { return getDefault(); }
066    
067                    int hour = Integer.parseInt( value.substring( 0,2 ) );
068    
069                    // 蜈磯?縺ｫ 00 繧剃ｻ伜刈縺吶ｋ轤ｺ縺ｫ縲∵焚蟄励? 100 繧貞刈邂励＠縺ｦ縺?ｋ縲?
070                    if( hour < 24 ) { hour = 101 + hour; }
071                    else                    { hour = 100; }
072    
073                    String rtn = hour + value.substring( 2 );
074    
075                    return rtn.substring( 1 );
076            }
077    
078            /**
079             * String蠑墓焚縺ｮ譁?ｭ怜?縺ｫ縲∫ｬｬ?貞ｼ墓焚縺ｫ謖?ｮ壹?譁?ｭ怜?(謨ｰ蟄励?譌･莉倡ｭ?繧貞刈邂励＠縺ｦ霑斐＠縺ｾ縺吶?
080             *
081             * 縺薙％縺ｧ縺ｯ縲？Hmmss 蠖｢蠑上?繝??繧ｿ縺ｫ縲∵凾髢薙ｒ蜉?ｮ励＠縺ｾ縺吶?
082             *
083             * 縺薙? HMS 縺ｯ縲∝ｼ墓焚縺ｫ縲∵律莉伜腰菴阪ｒ謖?ｮ壹〒縺阪∪縺吶?蜊倅ｽ阪?縲？Hmmss 蠖｢蠑上?
084             * ?第枚蟄励ｒ謖?ｮ壹＠縺ｾ縺吶?螟ｧ譁?ｭ励?蟆乗枚蟄励ｂ隴伜挨縺励∪縺吶?value="5H" 縺ｨ縺吶ｌ縺ｰ縲?ｼ墓凾髢薙?value="5m"
085             * 縺ｨ縺吶ｌ縺ｰ縲?ｼ募? 霑ｽ蜉?＠縺ｾ縺吶?
086             * 謖?ｮ壹＠縺ｪ縺??蜷医?縲∵凾繧貞刈邂励＠縺ｾ縺吶?
087             *
088             * 縺薙％縺ｮ繝??繧ｿ縺ｯ縲∵凾髢薙′郢ｰ繧願ｶ翫＠縺ｦ繧ゅ?譌･莉倥↓蠖ｱ髻ｿ縺励∪縺帙ｓ縲?
089             * 縺ｾ縺溘??抵ｼ疲凾髢薙ｒ雜?∴縺溷?蜷医?縲?0 譎ゅ↓謌ｻ繧翫∪縺吶?
090             *
091             * @og.rev 5.6.0.3 (2012/01/24) ADD 縺ｫ縲∝ｼ墓焚縺ｮ蛟､繧貞刈邂励☆繧区ｩ溯?繧定ｿｽ蜉?＠縺ｾ縺吶?
092             * @og.rev 5.6.1.0 (2013/02/01) 蜉?ｮ励☆繧句ｼ墓焚縺ｫ縲∵律莉伜腰菴?'H','m','s')繧呈欠螳壼庄閭ｽ縺ｫ縺励∪縺吶?
093             *
094             * @param   value  String蠑墓焚
095             * @param   add    蜉?ｮ励☆繧区凾髢捺枚蟄怜?(蜊倅ｽ堺ｻ倥″:['H','m','s'])
096             *
097             * @return  蠑墓焚縺ｮ譁?ｭ怜?縺ｫ譎る俣繧貞刈邂励＠縺ｾ縺吶?
098             */
099            @Override
100            public String valueAdd( final String value,final String add ) {
101                    if( value == null || value.length() == 0 ) { return getDefault(); }
102    
103                    // 譌･莉俶枚蟄怜?縺ｫ繝?Α繝ｼ縺ｮ蟷ｴ譛域律繧定ｿｽ蜉?＠縺ｦ縺翫￥縲?
104                    return HybsDateUtil.getDatePlus( ("20100101" + value),add,Calendar.HOUR_OF_DAY,"HHmmss" );
105    
106    //              int addSu = 1;
107    //              if( add != null && !add.isEmpty() ) {
108    //                      addSu = Integer.parseInt( add );
109    //              }
110    
111    //              int hour = Integer.parseInt( value.substring( 0,2 ) ) + addSu;
112    
113                    // 蜈磯?縺ｫ 00 繧剃ｻ伜刈縺吶ｋ轤ｺ縺ｫ縲∵焚蟄励? 100 繧貞刈邂励＠縺ｦ縺?ｋ縲ゅ∪縺溘?24譎る俣繧定ｶ?∴繧句?蜷医?縲?0 縺ｫ謌ｻ繧九?
114    //              String rtn = ( 100 + ( hour % 24 ) ) + value.substring( 2 );            // 蠕後ｍ縺ｯ縲｀MSS縺ｮ蛻?
115                    //           ~~~~~~~~~~~~~~~~~~~~~~~   ~~~~~~~~~~~~~~~~~~~~
116                    //           謨ｰ蟄鈴Κ蛻?                 MMSS縺ｮ譁?ｭ怜?驛ｨ蛻?
117    
118                    // 蜈磯?譁?ｭ怜?繧貞炎髯､縺吶ｋ縲?
119    //              return rtn.substring( 1 );
120            }
121    
122            /**
123             * 繧ｨ繝?ぅ繧ｿ繝ｼ縺ｧ邱ｨ髮?＆繧後◆繝??繧ｿ繧堤匳骭ｲ縺吶ｋ蝣ｴ蜷医↓縲√ョ繝ｼ繧ｿ縺昴?繧ゅ?繧?
124             * 螟画鋤縺励※縲∝ｮ溽匳骭ｲ繝??繧ｿ繧剃ｽ懈?縺励∪縺吶?
125             * 萓九∴縺ｰ,螟ｧ譁?ｭ励?縺ｿ縺ｮ繝輔ぅ繝ｼ繝ｫ繝峨↑繧峨?螟ｧ譁?ｭ怜喧縺励∪縺吶?
126             * 螳溽匳骭ｲ繝??繧ｿ縺ｮ菴懈?縺ｯ縲．BType 繧ｪ繝悶ず繧ｧ繧ｯ繝医ｒ蛻ｩ逕ｨ縺励∪縺吶?縺ｧ,
127             * 縺薙ｌ縺ｨ Editor 縺ｨ縺後い繝ｳ繝槭ャ繝√?蝣ｴ蜷医?縲√≧縺ｾ縺上ョ繝ｼ繧ｿ螟画鋤
128             * 縺輔ｌ縺ｪ縺?庄閭ｽ諤ｧ縺後≠繧翫∪縺吶?縺ｧ縲∵ｳｨ諢城｡倥＞縺ｾ縺吶?
129             *
130             * @param       value   (荳?握縺ｫ邱ｨ髮?ョ繝ｼ繧ｿ縺ｨ縺励※逋ｻ骭ｲ縺輔ｌ縺溘ョ繝ｼ繧ｿ)
131             *
132             * @return  菫ｮ豁｣蠕後?譁?ｭ怜?(荳?握縺ｫ繝??繧ｿ繝吶?繧ｹ縺ｫ逋ｻ骭ｲ縺吶ｋ繝??繧ｿ)
133             */
134            @Override
135            public String valueSet( final String value ) {
136                    if( value == null || value.length() == 0 ) { return ""; }
137                    return StringUtil.lTrim0( StringUtil.deleteChar( value,':' ) );
138            }
139    
140            /**
141             * 繝??繧ｿ縺檎匳骭ｲ蜿ｯ閭ｽ縺九←縺?°繧偵メ繧ｧ繝?け縺励∪縺吶?
142             * 繝??繧ｿ縺後お繝ｩ繝ｼ縺ｮ蝣ｴ蜷医?縲√◎縺ｮ繧ｨ繝ｩ繝ｼ蜀?ｮｹ繧定ｿ斐＠縺ｾ縺吶?
143             *
144             * @og.rev 5.2.3.6 (2012/01/20) 謨ｰ蛟､縺ｮ縺ｿ縺ｫ髯仙ｮ壹☆繧九◆繧√↓霑ｽ蜉?
145             * @og.rev 5.6.0.3 (2012/01/24) ADD 縺ｫ縲∝ｼ墓焚縺ｮ蛟､繧貞刈邂励☆繧区ｩ溯?繧定ｿｽ蜉?＠縺ｾ縺吶?
146             *
147             * @param   key         繧ｭ繝ｼ
148             * @param   value       蛟､
149             * @param   sizeX       謨ｴ謨ｰ驛ｨ蛻??譁?ｭ怜?縺ｮ髟ｷ縺?
150             * @param   sizeY       蟆第焚驛ｨ蛻??譁?ｭ怜?縺ｮ髟ｷ縺?
151             * @param   typeParam   dbType 繝代Λ繝｡繝ｼ繧ｿ
152             * @param   isStrict    蜴ｳ蟇?↓繝√ぉ繝?け縺吶ｋ縺九←縺?°[true:縺吶ｋ/false:讓呎ｺ也噪]
153             *
154             * @return  繧ｨ繝ｩ繝ｼ蜀?ｮｹ
155             */
156            @Override
157            public ErrorMessage valueCheck( final String key ,final String value ,
158                                                                            final int sizeX ,final int sizeY ,final String typeParam ,final boolean isStrict) {
159                    String checkVal = valueSet(value); // ?壹?蠢ｵ縺ｮ縺溘ａ螟悶＠縺ｦ縺翫￥
160    
161                    ErrorMessage msg = new ErrorMessage();
162                    if( checkVal == null || checkVal.length() == 0 ) { return msg; }
163    
164                    int len = (sizeY == 0) ? sizeX : sizeX + sizeY + 1;
165                    if( isStrict ) {
166                            if( len != checkVal.length() ) {
167                                    // 譁?ｭ怜?縺ｮ髟ｷ縺輔′謖?ｮ壹?髟ｷ縺輔→逡ｰ縺ｪ繧翫∪縺吶?
168                                    msg.addMessage( 0,ErrorMessage.NG,"ERR0011", key,value, String.valueOf( value.length() ), String.valueOf( len ) );
169                            }
170                    }
171                    else {
172                            if( len < checkVal.length() ) {
173                                    // 譁?ｭ怜?縺ｮ髟ｷ縺輔′謖?ｮ壹?髟ｷ縺輔ｈ繧翫ｂ髟ｷ縺?〒縺吶?
174                                    msg.addMessage( 0,ErrorMessage.NG,"ERR0006",key,value,
175                                                                                    String.valueOf( value.length() ),String.valueOf( len ) );
176                            }
177                    }
178    
179    //              StringBuilder val = new StringBuilder();
180    //              boolean isError = false;
181    //              for( int i=0; i<checkVal.length(); i++ ) {
182    //                      char ch = checkVal.charAt( i );
183    //                      if( ('0' > ch || '9' < ch) ) {
184    //                              val.append( "<span class=\"NG\">" ).append( ch ).append( "</span>" );
185    //                              isError = true;
186    //                      }
187    //                      else {
188    //                              val.append( ch );
189    //                      }
190    //              }
191    //              if( isError ) {
192    //                      // 謖?ｮ壹?譁?ｭ嶺ｻ･螟悶?譁?ｭ励′菴ｿ繧上ｌ縺ｦ縺?∪縺吶?
193    //                      msg.addMessage( 0,ErrorMessage.NG,"ERR0009", key,val.toString() );
194    //              }
195    
196                    // 5.6.0.3 (2012/01/24) 譁?ｭ励?遽?峇繝√ぉ繝?け
197                    String check = DBTypeCheckUtil.rangeCheck( checkVal, '0', '9' );
198                    if( check != null ) {
199                            // 謖?ｮ壹?譁?ｭ嶺ｻ･螟悶?譁?ｭ励′菴ｿ繧上ｌ縺ｦ縺?∪縺吶?
200                            msg.addMessage( 0,ErrorMessage.NG,"ERR0009", key,check );
201                    }
202    
203                    // 5.6.0.3 (2012/01/24) 譎ょ?遘偵?謨ｴ蜷域?繝√ぉ繝?け
204                    check = DBTypeCheckUtil.hmsFormatCheck( checkVal );
205                    if( check != null ) {
206                            // 謖?ｮ壹?譁?ｭ嶺ｻ･螟悶?譁?ｭ励′菴ｿ繧上ｌ縺ｦ縺?∪縺吶?
207                            msg.addMessage( 0,ErrorMessage.NG,"ERR0009", key,check );
208                    }
209    
210                    // 3.6.0.0 (2004/09/22) dbType 繝代Λ繝｡繝ｼ繧ｿ繧剃ｽｿ逕ｨ縺励◆繝槭ャ繝√メ繧ｧ繝?け
211                    check = DBTypeCheckUtil.matcheCheck( checkVal,typeParam );
212                    if( check != null ) {
213                            // 謖?ｮ壹?譁?ｭ嶺ｻ･螟悶?譁?ｭ励′菴ｿ繧上ｌ縺ｦ縺?∪縺吶?
214                            msg.addMessage( 0,ErrorMessage.NG,"ERR0009", key,check );
215                    }
216    
217                    return msg;
218            }
219    }