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