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.text.DateFormat;
019    // import java.text.SimpleDateFormat;
020    // import java.util.Locale;
021    import java.util.Calendar;
022    
023    import org.opengion.fukurou.model.NativeType;
024    import org.opengion.fukurou.util.ErrorMessage;
025    import org.opengion.fukurou.util.HybsDateUtil;
026    import org.opengion.hayabusa.common.HybsSystemException;
027    import org.opengion.hayabusa.db.AbstractDBType;
028    import org.opengion.hayabusa.db.DBTypeCheckUtil;
029    
030    /**
031     * 譁?ｭ怜?縺ｮ譌･莉伜ｱ樊?(蟷ｴ/譛?譌･)縺ｮ蜊願ｧ偵?譌･莉倥ｒ謇ｱ縺?ぜ縺ｮ縲√き繝ｩ繝?ｱ樊?繧貞ｮ夂ｾｩ縺励∪縺吶?
032     *
033     * yyyyMMdd 縺ｫ蟇ｾ蠢懊＠縺ｦ縺?ｋ蠢?ｦ√′縺ゅｊ縺ｾ縺吶?
034     * 縺溘□縺励?譌･莉倥?謨ｴ蜷域?繝√ぉ繝?け縺ｯ陦後＞縺ｾ縺帙ｓ縺後?valueAdd( String value )縺ｫ繧医ｋ
035     * 譌･莉倥?蜉?ｮ玲凾縺ｫ縺ｯ豁｣蠑上↑譌･莉倥〒蜉?ｮ励＆繧後∪縺吶?
036     *
037     * 繧ｿ繧､繝励メ繧ｧ繝?け縺ｨ縺励※縲∽ｻ･荳九?譚｡莉ｶ繧貞愛螳壹＠縺ｾ縺吶?
038     * 繝ｻ譁?ｭ怜?髟ｷ縺ｯ縲∫峩謗･險育ｮ励〒譁?ｭ玲焚縺ｨ縺ｮ豈碑ｼ?
039     * 繝ｻ譌･莉倅ｽｿ逕ｨ譁?ｭ励メ繧ｧ繝?け縲?'0' &gt; c || '9' &lt; c)莉･螟悶?繧ｨ繝ｩ繝ｼ
040     * 繝ｻ譁?ｭ励ヱ繝ｩ繝｡繝ｼ繧ｿ縺ｮ 豁｣隕剰｡ｨ迴ｾ繝√ぉ繝?け
041     *
042     * @og.group 繝??繧ｿ螻樊?
043     *
044     * @version  4.0
045     * @author   Kazuhiko Hasegawa
046     * @since    JDK5.0,
047     */
048    public class DBType_YMD extends AbstractDBType {
049            //* 縺薙?繝励Ο繧ｰ繝ｩ繝??VERSION譁?ｭ怜?繧定ｨｭ螳壹＠縺ｾ縺吶?       {@value} */
050            private static final String VERSION = "5.6.6.0 (2013/07/05)" ;
051    
052            /**
053             * NATIVE縺ｮ蝙九?隴伜挨繧ｳ繝ｼ繝峨ｒ霑斐＠縺ｾ縺吶?
054             *
055             * @og.rev 3.5.4.7 (2004/02/06) 譁ｰ隕丈ｽ懈?
056             * @og.rev 4.1.1.2 (2008/02/28) Enum蝙?fukurou.model.NativeType)縺ｫ螟画峩
057             *
058             * @return  NATIVE縺ｮ蝙九?隴伜挨繧ｳ繝ｼ繝?DBType 縺ｧ隕丞ｮ?
059             * @see org.opengion.fukurou.model.NativeType
060             */
061            @Override
062            public NativeType getNativeType() {
063                    return NativeType.CALENDAR;
064            }
065    
066            /**
067             * 蜊願ｧ偵せ繝壹?繧ｹ縺ｧ蝗ｺ螳夐聞(蜊願ｧ呈鋤邂励?謨ｰ)縺ｫ螟画鋤縺励◆譁?ｭ怜?繧定ｿ斐＠縺ｾ縺吶?
068             * 縺ｪ縺翫?繧ｨ繝ｩ繝ｼ繝√ぉ繝?け縺ｯ陦後ｏ繧後∪縺帙ｓ縲?
069             * 螳溯｡悟燕縺ｫ縲∝ｿ?★ valueCheck( String value ,int len ) 縺瑚｡後ｏ繧後ｋ蠢?ｦ√′縺ゅｊ縺ｾ縺吶?
070             *
071             * @og.rev 3.5.4.5 (2004/01/23) 繧ｨ繝ｳ繧ｳ繝ｼ繝画欠螳壹↓螟画峩縺励∪縺吶?
072             *
073             * @param   value    ?ｦ?ｩ?ｬ?ｬ蝓九ａ縺吶ｋ譁?ｭ怜?
074             * @param   sizeX    謨ｴ謨ｰ驛ｨ蛻??譁?ｭ怜?縺ｮ髟ｷ縺?
075             * @param   sizeY    蟆第焚驛ｨ蛻??譁?ｭ怜?縺ｮ髟ｷ縺?
076             * @param   encode   蝗ｺ螳夐聞縺ｧ螟画鋤縺吶ｋ譁?ｭ励お繝ｳ繧ｳ繝ｼ繝?
077             *
078             * @return  ?ｦ?ｩ?ｬ?ｬ蝓九ａ縺励◆譁ｰ縺励＞譁?ｭ怜?
079             */
080            @Override
081            public String valueFill( final String value ,final int sizeX ,final int sizeY,final String encode ) {
082                    if( value != null && value.length() >= sizeX ) {
083                            return value.substring( 0, sizeX );
084                    }
085    
086                    String errMsg = "謖?ｮ壽枚蟄励′荳肴ｭ｣縺ｧ縺吶?value=[" + value + "] length=[" + sizeX + "]";
087                    throw new HybsSystemException( errMsg );
088            }
089    
090            /**
091             * String蠑墓焚縺ｮ譁?ｭ怜?繧抵ｼ具ｼ代＠縺滓枚蟄怜?繧定ｿ斐＠縺ｾ縺吶?
092             * 縺薙％縺ｧ縺ｯ縲【yyyMMdd 蠖｢蠑上?繝??繧ｿ縺ｫ縲?ｼ具ｼ?縺吶ｋ縺ｮ縺ｧ縲∵律繧抵ｼ具ｼ代＠縺ｾ縺吶?
093             * 
094             * 蠑墓焚縺?null 縺ｮ蝣ｴ蜷医→縲√ぞ繝ｭ譁?ｭ怜?("")縺ｮ蝣ｴ蜷医?,迚ｩ逅?噪蛻晄悄險ｭ螳壼?(String getDefault())
095             * 縺ｮ蛟､繧定ｿ斐＠縺ｾ縺吶?
096             * 縺昴ｌ莉･螟悶?蝣ｴ蜷医?縲∵律莉倩ｨ育ｮ励ｒ陦後＞縲∵律繧貞刈邂励＠縺ｾ縺吶?繧医▲縺ｦ縲∝ｹｴ譛域律繝輔か繝ｼ繝槭ャ繝医↓
097             * 蜷医ｏ縺ｪ縺?ョ繝ｼ繧ｿ繧呈欠螳壹＠縺溷?蜷医?縲√お繝ｩ繝ｼ縺ｫ縺ｪ繧翫∪縺吶?縺ｧ縲√＃豕ｨ諢上￥縺?＆縺??
098             *
099             * @og.rev 3.6.0.0 (2004/09/17) 譌･縺ｮ蜉?ｮ励Ο繧ｸ繝?け縺ｮ隱､繧贋ｿｮ豁｣縲?roll 竍?add)
100             * @og.rev 5.5.7.2 (2012/10/09) HybsDateUtil 繧貞茜逕ｨ縺吶ｋ繧医≧縺ｫ菫ｮ豁｣縺励∪縺吶?
101             *
102             * @param       value   String蠑墓焚縺ｮ譁?ｭ怜?
103             *
104             * @return  String蠑墓焚縺ｮ譁?ｭ怜?繧抵ｼ具ｼ代＠縺滓枚蟄怜?
105             */
106            @Override
107            public String valueAdd( final String value ) {
108                    if( value == null || value.length() == 0 ) { return getDefault(); }
109    
110                    return HybsDateUtil.getDatePlus( value , 1 );
111    
112    //              Calendar cal = Calendar.getInstance();
113    // 
114    //              int year  = Integer.parseInt( value.substring( 0,4 ) );
115    //              int month = Integer.parseInt( value.substring( 4,6 ) ) - 1;
116    //              int date  = Integer.parseInt( value.substring( 6,8 ) );
117    // 
118    //              cal.set( year,month,date );
119    //              cal.add( Calendar.DATE, 1 );            // 譌･縺ｫ縺｡繧抵ｼ第律蜉?ｮ励＠縺ｾ縺吶?
120    // 
121    //              DateFormat formatter = new SimpleDateFormat( "yyyyMMdd",Locale.JAPAN );
122    //              return formatter.format( cal.getTime() );
123            }
124    
125            /**
126             * String蠑墓焚縺ｮ譁?ｭ怜?縺ｫ縲∫ｬｬ?貞ｼ墓焚縺ｫ謖?ｮ壹?譁?ｭ怜?(謨ｰ蟄励?譌･莉倡ｭ?繧貞刈邂励＠縺ｦ霑斐＠縺ｾ縺吶?
127             *
128             * 縺薙％縺ｧ縺ｯ縲【yyyMMdd 蠖｢蠑上?繝??繧ｿ縺ｫ縲∵律莉倥ｒ蜉?ｮ励＠縺ｾ縺吶?
129             *
130             * 縺薙? YMD 縺ｯ縲∝ｼ墓焚縺ｫ縲∵律莉伜腰菴阪ｒ謖?ｮ壹〒縺阪∪縺吶?蜊倅ｽ阪?縲【yyyMMdd 蠖｢蠑上?
131             * ?第枚蟄励ｒ謖?ｮ壹＠縺ｾ縺吶?螟ｧ譁?ｭ励?蟆乗枚蟄励ｂ隴伜挨縺励∪縺吶?value="5M" 縺ｨ縺吶ｌ縺ｰ縲?ｼ輔°譛医?value="5d"
132             * 縺ｨ縺吶ｌ縺ｰ縲?ｼ墓律 霑ｽ蜉?＠縺ｾ縺吶?
133             * 謖?ｮ壹＠縺ｪ縺??蜷医?縲∵律繧貞刈邂励＠縺ｾ縺吶?
134             * 
135             * 蠑墓焚縺?null 縺ｮ蝣ｴ蜷医→縲√ぞ繝ｭ譁?ｭ怜?("")縺ｮ蝣ｴ蜷医?,迚ｩ逅?噪蛻晄悄險ｭ螳壼?(String getDefault())
136             * 縺ｮ蛟､繧定ｿ斐＠縺ｾ縺吶?
137             * 縺昴ｌ莉･螟悶?蝣ｴ蜷医?縲∵律莉倩ｨ育ｮ励ｒ陦後＞縲∵律繧貞刈邂励＠縺ｾ縺吶?繧医▲縺ｦ縲∝ｹｴ譛域律繝輔か繝ｼ繝槭ャ繝医↓
138             * 蜷医ｏ縺ｪ縺?ョ繝ｼ繧ｿ繧呈欠螳壹＠縺溷?蜷医?縲√お繝ｩ繝ｼ縺ｫ縺ｪ繧翫∪縺吶?縺ｧ縲√＃豕ｨ諢上￥縺?＆縺??
139             *
140             * @og.rev 5.6.0.3 (2012/01/24) ADD 縺ｫ縲∝ｼ墓焚縺ｮ蛟､繧貞刈邂励☆繧区ｩ溯?繧定ｿｽ蜉?＠縺ｾ縺吶?
141             * @og.rev 5.6.1.0 (2013/02/01) 蜉?ｮ励☆繧句ｼ墓焚縺ｫ縲∵律莉伜腰菴?'y','M','d')繧呈欠螳壼庄閭ｽ縺ｫ縺励∪縺吶?
142             *
143             * @param   value  String蠑墓焚
144             * @param   add    蜉?ｮ励☆繧区律莉俶枚蟄怜?(蜊倅ｽ阪→縺励※縲【,M,d 繧呈欠螳壹〒縺阪∪縺?
145             *
146             * @return  蠑墓焚縺ｮ譁?ｭ怜?縺ｫ縲∵律莉倥ｒ蜉?ｮ励＠縺ｾ縺?
147             */
148            @Override
149            public String valueAdd( final String value,final String add ) {
150                    if( value == null || value.length() == 0 ) { return getDefault(); }
151    
152                    return HybsDateUtil.getDatePlus( value,add,Calendar.DATE,"yyyyMMdd" );
153    
154    //              int addSu = 1;  // 蛻晄悄蛟､(add 縺?null 繧?Empty 縺ｮ蝣ｴ蜷医?縲?ｼ具ｼ代→縺ｪ繧?
155    //              if( add != null && !add.isEmpty() ) {
156    //                      addSu = Integer.parseInt( add );
157    //              }
158    
159    //              return HybsDateUtil.getDatePlus( value , addSu );
160            }
161    
162            /**
163             * 繧ｨ繝?ぅ繧ｿ繝ｼ縺ｧ邱ｨ髮?＆繧後◆繝??繧ｿ繧堤匳骭ｲ縺吶ｋ蝣ｴ蜷医↓縲√ョ繝ｼ繧ｿ縺昴?繧ゅ?繧?
164             * 螟画鋤縺励※縲∝ｮ溽匳骭ｲ繝??繧ｿ繧剃ｽ懈?縺励∪縺吶?
165             * 縺薙?繝｡繧ｽ繝?ラ縺ｧ縺ｯ縲《izeX 縺ｨ辟｡髢｢菫ゅ↓ ?倥こ繧ｿ縺ｮ yyyyMMdd 蠖｢蠑上?
166             * 譌･莉倥ョ繝ｼ繧ｿ縺ｫ繝輔か繝ｼ繝槭ャ繝医↓邨ｱ荳?＠縺ｾ縺吶?
167             * 蠑墓焚縺?null 縺ｮ蝣ｴ蜷医→縲√ぞ繝ｭ譁?ｭ怜?("")縺ｮ蝣ｴ蜷医?,迚ｩ逅?噪蛻晄悄險ｭ螳壼?(String getDefault())
168             * 縺ｮ蛟､繧定ｿ斐＠縺ｾ縺吶?
169             *
170             * @og.rev 5.5.7.2 (2012/10/09) HybsDateUtil 繧貞茜逕ｨ縺吶ｋ繧医≧縺ｫ菫ｮ豁｣縺励∪縺吶?
171             * @og.rev 5.6.6.0 (2013/07/05) parseDate 繧呈隼騾?＠縲∵律莉倥?譯∵焚謖?ｮ壹ｒ蜴ｳ蟇?↓蛻､螳壹＠縺ｾ縺吶?
172             *
173             * @param       value   (荳?握縺ｫ邱ｨ髮?ョ繝ｼ繧ｿ縺ｨ縺励※逋ｻ骭ｲ縺輔ｌ縺溘ョ繝ｼ繧ｿ)
174             * @return  菫ｮ豁｣蠕後?譁?ｭ怜?(荳?握縺ｫ繝??繧ｿ繝吶?繧ｹ縺ｫ逋ｻ骭ｲ縺吶ｋ繝??繧ｿ)
175             */
176            @Override
177            public String valueSet( final String value ) {
178                    if( value == null || value.length() == 0 ) { return getDefault(); }
179    
180                    return HybsDateUtil.parseDate( value , 8 );             // 荳崎ｦ√↑險伜捷遲峨ｒ蜑企勁縺励?譯∵焚繧偵◎繧阪∴繧九?
181    
182    //              String rtn = ( value == null ) ? "" : value.trim();
183    // 
184    //              if( rtn.length() == 6 ) { rtn = "20" + rtn ; }
185    //              else if( rtn.length() > 8 ) { rtn = rtn.substring(0,8) ; }
186    //              else if( rtn.startsWith( "0000" ) ) { rtn = "00000101"; }
187    //              else if( rtn.startsWith( "9999" ) ) { rtn = "99991231"; }
188    // 
189    //              return rtn;
190            }
191    
192            /**
193             * 繝??繧ｿ縺檎匳骭ｲ蜿ｯ閭ｽ縺九←縺?°繧偵メ繧ｧ繝?け縺励∪縺吶?
194             * 繝??繧ｿ縺後お繝ｩ繝ｼ縺ｮ蝣ｴ蜷医?縲√◎縺ｮ繧ｨ繝ｩ繝ｼ蜀?ｮｹ繧定ｿ斐＠縺ｾ縺吶?
195             *
196             * @og.rev 3.6.0.0 (2004/09/22) dbType 繝代Λ繝｡繝ｼ繧ｿ繧貞ｼ墓焚縺ｫ霑ｽ蜉?
197             * @og.rev 5.2.2.0 (2010/11/01) 蜴ｳ蟇?↓繝√ぉ繝?け(isStrict=true)縺吶ｋ繝輔Λ繧ｰ繧定ｿｽ蜉?
198             * @og.rev 5.6.0.3 (2012/01/24) 譌･莉倥メ繧ｧ繝?け縺ｮ謨ｴ蜷域?縺ｾ縺ｧ蜷ｫ繧√◆繝√ぉ繝?け繧貞?繧後ｋ縲?
199             *
200             * @param   key         繧ｭ繝ｼ
201             * @param   value       蛟､
202             * @param   sizeX       謨ｴ謨ｰ驛ｨ蛻??譁?ｭ怜?縺ｮ髟ｷ縺?
203             * @param   sizeY       蟆第焚驛ｨ蛻??譁?ｭ怜?縺ｮ髟ｷ縺?
204             * @param   typeParam   dbType 繝代Λ繝｡繝ｼ繧ｿ
205             * @param   isStrict    蜴ｳ蟇?↓繝√ぉ繝?け縺吶ｋ縺九←縺?°[true:縺吶ｋ/false:讓呎ｺ也噪]
206             *
207             * @return  繧ｨ繝ｩ繝ｼ蜀?ｮｹ
208             */
209    //      public ErrorMessage valueCheck( final String key ,final String value ,
210    //                                                                      final int sizeX ,final int sizeY ,final String param ) {
211            @Override
212            public ErrorMessage valueCheck( final String key ,final String value ,
213                                                                            final int sizeX ,final int sizeY ,final String typeParam ,final boolean isStrict) {
214    
215                    ErrorMessage msg = new ErrorMessage();
216                    if( value == null || value.length() == 0 ) { return msg; }
217    
218                    int len = (sizeY == 0) ? sizeX : sizeX + sizeY + 1;
219                    // 5.2.2.0 (2010/11/01) 蜴ｳ蟇?↓繝√ぉ繝?け(isStrict=true)縺吶ｋ繝輔Λ繧ｰ繧定ｿｽ蜉?
220                    if( isStrict ) {
221                            if( len != value.length() ) {
222                                    // 譁?ｭ怜?縺ｮ髟ｷ縺輔′謖?ｮ壹?髟ｷ縺輔→逡ｰ縺ｪ繧翫∪縺吶?
223                                    msg.addMessage( 0,ErrorMessage.NG,"ERR0011", key,value, 
224                                                                                    String.valueOf( value.length() ), String.valueOf( len ) );
225                            }
226                    }
227                    else {
228                            if( len < value.length() ) {
229                                    // 譁?ｭ怜?縺ｮ髟ｷ縺輔′謖?ｮ壹?髟ｷ縺輔ｈ繧翫ｂ髟ｷ縺?〒縺吶?
230                                    msg.addMessage( 0,ErrorMessage.NG,"ERR0006",key,value,
231                                                                                    String.valueOf( value.length() ),String.valueOf( len ) );
232                            }
233                    }
234    
235    //              StringBuilder val = new StringBuilder();
236    //              boolean isError = false;
237    //              for( int i=0; i<value.length(); i++ ) {
238    //                      char ch = value.charAt( i );
239    //                      if( ('0' > ch || '9' < ch) ) {
240    //                              val.append( "<span class=\"NG\">" ).append( ch ).append( "</span>" );
241    //                              isError = true;
242    //                      }
243    //                      else {
244    //                              val.append( ch );
245    //                      }
246    //              }
247    //              if( isError ) {
248    //                      // 謖?ｮ壹?譁?ｭ嶺ｻ･螟悶?譁?ｭ励′菴ｿ繧上ｌ縺ｦ縺?∪縺吶?
249    //                      msg.addMessage( 0,ErrorMessage.NG,"ERR0009", key,val.toString() );
250    //              }
251    
252                    // 5.6.0.3 (2012/01/24) 譁?ｭ励?遽?峇繝√ぉ繝?け
253                    String check = DBTypeCheckUtil.rangeCheck( value, '0', '9' );
254                    if( check != null ) {
255                            // 謖?ｮ壹?譁?ｭ嶺ｻ･螟悶?譁?ｭ励′菴ｿ繧上ｌ縺ｦ縺?∪縺吶?
256                            msg.addMessage( 0,ErrorMessage.NG,"ERR0009", key,check );
257                    }
258    
259                    // 5.6.0.3 (2012/01/24) 譌･莉俶枚蟄励?謨ｴ蜷域?繝√ぉ繝?け
260                    // "0000","9999" 縺ｧ蟋九∪繧区律莉倥?譛ｪ譚｡莉ｶ險ｱ蜿ｯ縲?
261                    check = DBTypeCheckUtil.ymdFormatCheck( value );
262                    if( check != null ) {
263                            // 謖?ｮ壹?譁?ｭ嶺ｻ･螟悶?譁?ｭ励′菴ｿ繧上ｌ縺ｦ縺?∪縺吶?
264                            msg.addMessage( 0,ErrorMessage.NG,"ERR0009", key,check );
265                    }
266    
267                    // 3.6.0.0 (2004/09/22) dbType 繝代Λ繝｡繝ｼ繧ｿ繧剃ｽｿ逕ｨ縺励◆繝槭ャ繝√メ繧ｧ繝?け
268                    check = DBTypeCheckUtil.matcheCheck( value,typeParam );
269                    if( check != null ) {
270                            // 謖?ｮ壹?譁?ｭ嶺ｻ･螟悶?譁?ｭ励′菴ｿ繧上ｌ縺ｦ縺?∪縺吶?
271                            msg.addMessage( 0,ErrorMessage.NG,"ERR0009", key,check );
272                    }
273    
274                    return msg;
275            }
276    }