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.HybsDateUtil;
020    import org.opengion.hayabusa.db.DBTypeCheckUtil;
021    
022    import java.util.Calendar;
023    // import java.util.Locale;
024    // import java.text.DateFormat;
025    // import java.text.SimpleDateFormat;
026    
027    /**
028     * 譁?ｭ怜?縺ｮ譌･莉伜ｱ樊?(蟷ｴ/譛?譌･ 譎?蛻?遘?縺ｮ蜊願ｧ偵?譌･莉倥ｒ謇ｱ縺?ぜ縺ｮ縲√き繝ｩ繝?ｱ樊?繧貞ｮ夂ｾｩ縺励∪縺吶?
029     *
030     * yyyyMMddHHmmss 縺ｫ蟇ｾ蠢懊＠縺ｦ縺?ｋ蠢?ｦ√′縺ゅｊ縺ｾ縺吶?
031     * 縺溘□縺励?譌･莉倥?謨ｴ蜷域?繝√ぉ繝?け縺ｯ陦後＞縺ｾ縺帙ｓ縺後?valueAdd( String value )縺ｧ縺ｮ
032     * 譌･莉倥?蜉?ｮ玲凾縺ｫ縺ｯ縲∵ｭ｣蠑上↑譌･莉倥ョ繝ｼ繧ｿ縺ｫ縺ｦ蜉?ｮ励＠縺ｾ縺吶?
033     *
034     * 繧ｿ繧､繝励メ繧ｧ繝?け縺ｨ縺励※縲∽ｻ･荳九?譚｡莉ｶ繧貞愛螳壹＠縺ｾ縺吶?
035     * 繝ｻ譁?ｭ怜?髟ｷ縺ｯ縲∫峩謗･險育ｮ励〒譁?ｭ玲焚縺ｨ縺ｮ豈碑ｼ?
036     * 繝ｻ譌･莉倅ｽｿ逕ｨ譁?ｭ励メ繧ｧ繝?け縲?'0' &gt; c || '9' &lt; c)莉･螟悶?繧ｨ繝ｩ繝ｼ
037     * 繝ｻ譁?ｭ励ヱ繝ｩ繝｡繝ｼ繧ｿ縺ｮ 豁｣隕剰｡ｨ迴ｾ繝√ぉ繝?け
038     *
039     * @og.group 繝??繧ｿ螻樊?
040     *
041     * @version  4.0
042     * @author   Kazuhiko Hasegawa
043     * @since    JDK5.0,
044     */
045    public class DBType_YMDH extends DBType_YMD {
046            //* 縺薙?繝励Ο繧ｰ繝ｩ繝??VERSION譁?ｭ怜?繧定ｨｭ螳壹＠縺ｾ縺吶?       {@value} */
047            private static final String VERSION = "5.6.6.0 (2013/07/05)" ;
048    
049            /**
050             * String蠑墓焚縺ｮ譁?ｭ怜?繧抵ｼ具ｼ代＠縺滓枚蟄怜?繧定ｿ斐＠縺ｾ縺吶?
051             * 縺薙％縺ｧ縺ｯ縲【yyyMMddHHmmss 蠖｢蠑上?繝??繧ｿ縺ｫ縲∵律繧抵ｼ具ｼ代＠縺ｾ縺吶?
052             * 
053             * 蠑墓焚縺?null 縺ｮ蝣ｴ蜷医→縲√ぞ繝ｭ譁?ｭ怜?("")縺ｮ蝣ｴ蜷医?,迚ｩ逅?噪蛻晄悄險ｭ螳壼?(String getDefault())
054             * 縺ｮ蛟､繧定ｿ斐＠縺ｾ縺吶?
055             * 縺昴ｌ莉･螟悶?蝣ｴ蜷医?縲∵律莉倩ｨ育ｮ励ｒ陦後＞縲∵律繧貞刈邂励＠縺ｾ縺吶?繧医▲縺ｦ縲∝ｹｴ譛域律繝輔か繝ｼ繝槭ャ繝医↓
056             * 蜷医ｏ縺ｪ縺?ョ繝ｼ繧ｿ繧呈欠螳壹＠縺溷?蜷医?縲√お繝ｩ繝ｼ縺ｫ縺ｪ繧翫∪縺吶?縺ｧ縲√＃豕ｨ諢上￥縺?＆縺??
057             *
058             * @og.rev 3.6.0.0 (2004/09/17) 譌･縺ｮ蜉?ｮ励Ο繧ｸ繝?け縺ｮ隱､繧贋ｿｮ豁｣縲?roll 竍?add)
059             * @og.rev 5.5.7.2 (2012/10/09) HybsDateUtil 繧貞茜逕ｨ縺吶ｋ繧医≧縺ｫ菫ｮ豁｣縺励∪縺吶?
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                    Calendar cal = HybsDateUtil.getCalendar( value );
070                    cal.add( Calendar.DATE, 1 );            // 譌･縺ｫ縺｡繧抵ｼ第律蜉?ｮ励＠縺ｾ縺吶?
071    
072                    return HybsDateUtil.getDate( cal.getTimeInMillis() , "yyyyMMddHHmmss" );
073    
074    //              Calendar cal = Calendar.getInstance();
075    //
076    //              int year   = Integer.parseInt( value.substring( 0,4 ) );
077    //              int month  = Integer.parseInt( value.substring( 4,6 ) ) - 1;
078    //              int date   = Integer.parseInt( value.substring( 6,8 ) );
079    //              int hour   = Integer.parseInt( value.substring( 8,10 ) );
080    //              int minute = Integer.parseInt( value.substring( 10,12 ) );
081    //              int second = Integer.parseInt( value.substring( 12,14 ) );
082    //
083    //              cal.set( year,month,date,hour,minute,second );
084    //              cal.add( Calendar.DATE, 1 );            // 譌･縺ｫ縺｡繧抵ｼ第律蜉?ｮ励＠縺ｾ縺吶?
085    
086    //              DateFormat formatter = new SimpleDateFormat( "yyyyMMddHHmmss",Locale.JAPAN );
087    //              return formatter.format( cal.getTime() );
088            }
089    
090            /**
091             * String蠑墓焚縺ｮ譁?ｭ怜?縺ｫ縲∫ｬｬ?貞ｼ墓焚縺ｫ謖?ｮ壹?譁?ｭ怜?(謨ｰ蟄励?譌･莉倡ｭ?繧貞刈邂励＠縺ｦ霑斐＠縺ｾ縺吶?
092             *
093             * 縺薙％縺ｧ縺ｯ縲【yyyMMddHHmmss 蠖｢蠑上?繝??繧ｿ縺ｫ縲∝ｼ墓焚譁??譌･繧貞刈邂励＠縺ｾ縺吶?
094             *
095             * 縺薙? YMDH 縺ｯ縲∝ｼ墓焚縺ｫ縲∵律莉伜腰菴阪ｒ謖?ｮ壹〒縺阪∪縺吶?蜊倅ｽ阪?縲【yyyMMddHHmmss 蠖｢蠑上?
096             * ?第枚蟄励ｒ謖?ｮ壹＠縺ｾ縺吶?螟ｧ譁?ｭ励?蟆乗枚蟄励ｂ隴伜挨縺励∪縺吶?value="5M" 縺ｨ縺吶ｌ縺ｰ縲?ｼ輔°譛医?value="5m"
097             * 縺ｨ縺吶ｌ縺ｰ縲?ｼ募? 霑ｽ蜉?＠縺ｾ縺吶?
098             * 謖?ｮ壹＠縺ｪ縺??蜷医?縲∵律繧貞刈邂励＠縺ｾ縺吶?
099             * 
100             * 蠑墓焚縺?null 縺ｮ蝣ｴ蜷医→縲√ぞ繝ｭ譁?ｭ怜?("")縺ｮ蝣ｴ蜷医?,迚ｩ逅?噪蛻晄悄險ｭ螳壼?(String getDefault())
101             * 縺ｮ蛟､繧定ｿ斐＠縺ｾ縺吶?
102             * 縺昴ｌ莉･螟悶?蝣ｴ蜷医?縲∵律莉倩ｨ育ｮ励ｒ陦後＞縲∵律繧貞刈邂励＠縺ｾ縺吶?繧医▲縺ｦ縲∝ｹｴ譛域律繝輔か繝ｼ繝槭ャ繝医↓
103             * 蜷医ｏ縺ｪ縺?ョ繝ｼ繧ｿ繧呈欠螳壹＠縺溷?蜷医?縲√お繝ｩ繝ｼ縺ｫ縺ｪ繧翫∪縺吶?縺ｧ縲√＃豕ｨ諢上￥縺?＆縺??
104             *
105             * @og.rev 5.6.0.3 (2012/01/24) ADD 縺ｫ縲∝ｼ墓焚縺ｮ蛟､繧貞刈邂励☆繧区ｩ溯?繧定ｿｽ蜉?＠縺ｾ縺吶?
106             * @og.rev 5.6.1.0 (2013/02/01) 蜉?ｮ励☆繧句ｼ墓焚縺ｫ縲∵律莉伜腰菴?'y','M','d')繧呈欠螳壼庄閭ｽ縺ｫ縺励∪縺吶?
107             *
108             * @param   value  String蠑墓焚
109             * @param   add    蜉?ｮ励☆繧区律莉俶枚蟄怜?
110             *
111             * @return  蠑墓焚縺ｮ譁?ｭ怜?縺ｫ縲∵律莉倥ｒ蜉?ｮ励＠縺ｾ縺?
112             */
113            @Override
114            public String valueAdd( final String value,final String add ) {
115                    if( value == null || value.length() == 0 ) { return getDefault(); }
116    
117                    return HybsDateUtil.getDatePlus( value,add,Calendar.DATE,"yyyyMMddHHmmss" );
118    
119    //              int addSu = 1;  // 蛻晄悄蛟､(add 縺?null 繧?Empty 縺ｮ蝣ｴ蜷医?縲?ｼ具ｼ代→縺ｪ繧?
120    //              if( add != null && !add.isEmpty() ) {
121    //                      addSu = Integer.parseInt( add );
122    //              }
123    
124    //              Calendar cal = HybsDateUtil.getCalendar( value );
125    //              cal.add( Calendar.DATE, addSu );                // 譌･縺ｫ縺｡繧抵ｼ第律蜉?ｮ励＠縺ｾ縺吶?
126    
127    //              return HybsDateUtil.getDate( cal.getTimeInMillis() , "yyyyMMddHHmmss" );
128            }
129    
130            /**
131             * 繧ｨ繝?ぅ繧ｿ繝ｼ縺ｧ邱ｨ髮?＆繧後◆繝??繧ｿ繧堤匳骭ｲ縺吶ｋ蝣ｴ蜷医↓縲√ョ繝ｼ繧ｿ縺昴?繧ゅ?繧?
132             * 螟画鋤縺励※縲∝ｮ溽匳骭ｲ繝??繧ｿ繧剃ｽ懈?縺励∪縺吶?
133             * 縺薙?繝｡繧ｽ繝?ラ縺ｧ縺ｯ縲《izeX 縺ｨ辟｡髢｢菫ゅ↓ ?托ｼ斐こ繧ｿ縺ｮ YYYYMMDDHHMMS 蠖｢蠑上?
134             * 譌･莉倥ョ繝ｼ繧ｿ縺ｫ繝輔か繝ｼ繝槭ャ繝医↓邨ｱ荳?＠縺ｾ縺吶?
135             * 蠑墓焚縺?null 縺ｮ蝣ｴ蜷医→縲√ぞ繝ｭ譁?ｭ怜?("")縺ｮ蝣ｴ蜷医?,迚ｩ逅?噪蛻晄悄險ｭ螳壼?(String getDefault())
136             * 縺ｮ蛟､繧定ｿ斐＠縺ｾ縺吶?
137             *
138             * @og.rev 5.5.7.2 (2012/10/09) HybsDateUtil 繧貞茜逕ｨ縺吶ｋ繧医≧縺ｫ菫ｮ豁｣縺励∪縺吶?
139             * @og.rev 5.6.6.0 (2013/07/05) 譌･莉倥?譯∵焚遽?峇繧偵?8-14 譯√→縺励∪縺吶?
140             *
141             * @param       value   (荳?握縺ｫ邱ｨ髮?ョ繝ｼ繧ｿ縺ｨ縺励※逋ｻ骭ｲ縺輔ｌ縺溘ョ繝ｼ繧ｿ)
142             * @return  菫ｮ豁｣蠕後?譁?ｭ怜?(荳?握縺ｫ繝??繧ｿ繝吶?繧ｹ縺ｫ逋ｻ骭ｲ縺吶ｋ繝??繧ｿ)
143             */
144            @Override
145            public String valueSet( final String value ) {
146                    if( value == null || value.length() == 0 ) { return getDefault(); }
147    
148                    // 
149    //              return HybsDateUtil.parseDate( value,14 );
150                    return HybsDateUtil.parseDate( value,8,14 );
151    
152    //              String rtn = ( value == null ) ? "" : value.trim();
153    // 
154    //              int len = rtn.length() ;
155    //              if(      len == 6 ) { rtn = "20" + rtn + "000000" ; }
156    //              else if( len == 8 ) { rtn = rtn + "000000"; }
157    //              else if( rtn.startsWith( "0000" ) ) { rtn = "00000101000000"; }
158    //              else if( rtn.startsWith( "9999" ) ) { rtn = "99991231000000"; }
159    // 
160    //              return rtn;
161            }
162    
163            /**
164             * 繝??繧ｿ縺檎匳骭ｲ蜿ｯ閭ｽ縺九←縺?°繧偵メ繧ｧ繝?け縺励∪縺吶?
165             * 繝??繧ｿ縺後お繝ｩ繝ｼ縺ｮ蝣ｴ蜷医?縲√◎縺ｮ繧ｨ繝ｩ繝ｼ蜀?ｮｹ繧定ｿ斐＠縺ｾ縺吶?
166             *
167             * @og.rev 5.6.0.3 (2012/01/24) 譌･莉倥メ繧ｧ繝?け縺ｮ謨ｴ蜷域?縺ｾ縺ｧ蜷ｫ繧√◆繝√ぉ繝?け繧貞?繧後ｋ縲?
168             *
169             * @param   key         繧ｭ繝ｼ
170             * @param   value       蛟､
171             * @param   sizeX       謨ｴ謨ｰ驛ｨ蛻??譁?ｭ怜?縺ｮ髟ｷ縺?
172             * @param   sizeY       蟆第焚驛ｨ蛻??譁?ｭ怜?縺ｮ髟ｷ縺?
173             * @param   typeParam   dbType 繝代Λ繝｡繝ｼ繧ｿ
174             * @param   isStrict    蜴ｳ蟇?↓繝√ぉ繝?け縺吶ｋ縺九←縺?°[true:縺吶ｋ/false:讓呎ｺ也噪]
175             *
176             * @return  繧ｨ繝ｩ繝ｼ蜀?ｮｹ
177             */
178            @Override
179            public ErrorMessage valueCheck( final String key ,final String value ,
180                                                                            final int sizeX ,final int sizeY ,final String typeParam ,final boolean isStrict) {
181    
182                    ErrorMessage msg = new ErrorMessage();
183                    if( value == null || value.length() == 0 ) { return msg; }
184    
185                    int len = (sizeY == 0) ? sizeX : sizeX + sizeY + 1;
186                    // 5.2.2.0 (2010/11/01) 蜴ｳ蟇?↓繝√ぉ繝?け(isStrict=true)縺吶ｋ繝輔Λ繧ｰ繧定ｿｽ蜉?
187                    if( isStrict ) {
188                            if( len != value.length() ) {
189                                    // 譁?ｭ怜?縺ｮ髟ｷ縺輔′謖?ｮ壹?髟ｷ縺輔→逡ｰ縺ｪ繧翫∪縺吶?
190                                    msg.addMessage( 0,ErrorMessage.NG,"ERR0011", key,value, 
191                                                                                    String.valueOf( value.length() ), String.valueOf( len ) );
192                            }
193                    }
194                    else {
195                            if( len < value.length() ) {
196                                    // 譁?ｭ怜?縺ｮ髟ｷ縺輔′謖?ｮ壹?髟ｷ縺輔ｈ繧翫ｂ髟ｷ縺?〒縺吶?
197                                    msg.addMessage( 0,ErrorMessage.NG,"ERR0006",key,value,
198                                                                                    String.valueOf( value.length() ),String.valueOf( len ) );
199                            }
200                    }
201    
202                    // 5.6.0.3 (2012/01/24) 譁?ｭ励?遽?峇繝√ぉ繝?け
203                    String check = DBTypeCheckUtil.rangeCheck( value, '0', '9' );
204                    if( check != null ) {
205                            // 謖?ｮ壹?譁?ｭ嶺ｻ･螟悶?譁?ｭ励′菴ｿ繧上ｌ縺ｦ縺?∪縺吶?
206                            msg.addMessage( 0,ErrorMessage.NG,"ERR0009", key,check );
207                    }
208    
209                    // 5.6.0.3 (2012/01/24) 譌･莉俶枚蟄励?謨ｴ蜷域?繝√ぉ繝?け
210                    // "0000","9999" 縺ｧ蟋九∪繧区律莉倥?譛ｪ譚｡莉ｶ險ｱ蜿ｯ縲?
211                    check = DBTypeCheckUtil.ymdFormatCheck( value );
212                    if( check != null ) {
213                            // 謖?ｮ壹?譁?ｭ嶺ｻ･螟悶?譁?ｭ励′菴ｿ繧上ｌ縺ｦ縺?∪縺吶?
214                            msg.addMessage( 0,ErrorMessage.NG,"ERR0009", key,check );
215                    }
216    
217                    // 3.6.0.0 (2004/09/22) dbType 繝代Λ繝｡繝ｼ繧ｿ繧剃ｽｿ逕ｨ縺励◆繝槭ャ繝√メ繧ｧ繝?け
218                    check = DBTypeCheckUtil.matcheCheck( value,typeParam );
219                    if( check != null ) {
220                            // 謖?ｮ壹?譁?ｭ嶺ｻ･螟悶?譁?ｭ励′菴ｿ繧上ｌ縺ｦ縺?∪縺吶?
221                            msg.addMessage( 0,ErrorMessage.NG,"ERR0009", key,check );
222                    }
223    
224                    return msg;
225            }
226    }