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縲√◎繧御ｻ･螟悶?YYYYMM01縺ｨ螟画鋤縺励∪縺吶?
034     *
035     * YYYYMM01 縺ｾ縺溘?縲?0000XXXX , 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_YM01 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 = "00000000" ;    // 繝??繧ｿ縺ｮ繝?ヵ繧ｩ繝ｫ繝亥?
057    
058            /**
059             * 繝?ヵ繧ｩ繝ｫ繝医さ繝ｳ繧ｹ繝医Λ繧ｯ繧ｿ繝ｼ
060             *
061             * @og.rev 4.0.0.0 (2005/01/31) type 蟒?ｭ｢
062             */
063            public DBType_YM01() {
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             *
115             * @og.rev 3.6.0.0 (2004/09/17) 譛医?蜉?ｮ励Ο繧ｸ繝?け縺ｮ隱､繧贋ｿｮ豁｣縲?roll 竍?add)
116             * @og.rev 5.5.7.2 (2012/10/09) HybsDateUtil 繧貞茜逕ｨ縺吶ｋ繧医≧縺ｫ菫ｮ豁｣縺励∪縺吶?
117             *
118             * @param       value   String蠑墓焚縺ｮ譁?ｭ怜?
119             *
120             * @return  String蠑墓焚縺ｮ譁?ｭ怜?繧抵ｼ具ｼ代＠縺滓枚蟄怜?
121             */
122            @Override
123            public String valueAdd( final String value ) {
124                    if( value == null || value.length() == 0 ) { return getDefault(); }
125                    if( value.startsWith( "0000" ) || value.startsWith( "9999" ) ) { return value; }
126    
127                    return HybsDateUtil.getMonthPlus( value , 1 ) + "01";           // 5.5.7.2 (2012/10/09) HybsDateUtil 繧貞茜逕ｨ
128    
129    //              Calendar cal = Calendar.getInstance();
130    // 
131    //              int year  = Integer.parseInt( value.substring( 0,4 ) );
132    //              int month = Integer.parseInt( value.substring( 4,6 ) ) - 1;
133    //              int date  = Integer.parseInt( value.substring( 6,8 ) );
134    // 
135    //              cal.set( year,month,date );
136    //              cal.add( Calendar.MONTH, 1 );           // 譛医ｒ?代Ω譛亥刈邂励＠縺ｾ縺吶?
137    // 
138    //              DateFormat formatter = new SimpleDateFormat( "yyyyMMdd",Locale.JAPAN );
139    //              return formatter.format( cal.getTime() );
140            }
141    
142            /**
143             * 蜈･蜉帙ョ繝ｼ繧ｿ縺ｮ謨ｴ蜷域?繧貞粋繧上○縺溽ｵ先棡繧定ｿ斐＠縺ｾ縺吶?
144             * 縺薙％縺ｧ縺ｯ縲∵律莉倥ョ繝ｼ繧ｿ縺ｫ蜷ｫ縺ｾ繧後ｋ繝輔か繝ｼ繝槭ャ繝域枚蟄怜?繧貞炎髯､縺励?謨ｰ蟄励□縺代?
145             * 譁?ｭ怜?繧剃ｽ懈?縺励?YYYYMM 蠖｢蠑上?蜈磯??匁枚蟄???"01" 縺ｮ繝??繧ｿ繧剃ｽ懈?縺励∪縺吶?
146             * 縺薙?繝｡繧ｽ繝?ラ縺ｧ縺ｯ縲∵律莉俶ｬ??縲∝ｿ?★ "01" 縺ｫ縺ｪ繧翫∪縺吶?
147             * 螳溽匳骭ｲ繝??繧ｿ縺ｮ菴懈?縺ｯ縲．BType 繧ｪ繝悶ず繧ｧ繧ｯ繝医ｒ蛻ｩ逕ｨ縺励∪縺吶?縺ｧ,
148             * 縺薙ｌ縺ｨ Editor 縺ｨ縺後い繝ｳ繝槭ャ繝√?蝣ｴ蜷医?縲√≧縺ｾ縺上ョ繝ｼ繧ｿ螟画鋤
149             * 縺輔ｌ縺ｪ縺?庄閭ｽ諤ｧ縺後≠繧翫∪縺吶?縺ｧ縲∵ｳｨ諢城｡倥＞縺ｾ縺吶?
150             *
151             * @og.rev 3.3.3.0 (2003/07/09) 蜑榊ｾ後?繧ｹ繝壹?繧ｹ繧貞叙繧企勁縺?※縺翫￥縲?
152             * @og.rev 4.3.3.4 (2008/12/01) 0000 or 9999 譎ゅ?繝舌げ菫ｮ豁｣
153             * @og.rev 5.5.7.2 (2012/10/09) HybsDateUtil 繧貞茜逕ｨ縺吶ｋ繧医≧縺ｫ菫ｮ豁｣縺励∪縺吶?
154             * @og.rev 5.6.6.0 (2013/07/05) parseDate 繧呈隼騾?＠縲∵律莉倥?譯∵焚謖?ｮ壹ｒ蜴ｳ蟇?↓蛻､螳壹＠縺ｾ縺吶?
155             *
156             * @param       value   (荳?握縺ｫ邱ｨ髮?ョ繝ｼ繧ｿ縺ｨ縺励※逋ｻ骭ｲ縺輔ｌ縺溘ョ繝ｼ繧ｿ)
157             *
158             * @return  菫ｮ豁｣蠕後?譁?ｭ怜?(荳?握縺ｫ繝??繧ｿ繝吶?繧ｹ縺ｫ逋ｻ骭ｲ縺吶ｋ繝??繧ｿ)
159             */
160            @Override
161            public String valueSet( final String value ) {
162                    if( value == null || value.length() == 0 ) { return getDefault(); }
163    
164                    return HybsDateUtil.parseDate( value , 6 ) + "01";              // 荳崎ｦ√↑險伜捷遲峨ｒ蜑企勁縺励?譯∵焚繧偵◎繧阪∴繧九?
165    
166    //              if( value == null ) { return null; }
167    //              String rtn = StringUtil.rTrim( value );                 // 3.3.3.1 (2003/07/18)
168    //              if( rtn.length() >= 6 ) {
169    //                      rtn = rtn.substring( 0,6 );
170    // //                   if(      rtn.startsWith( "0000" ) ) { rtn = "000001"; }
171    // //                   else if( rtn.startsWith( "9999" ) ) { rtn = "999912"; }
172    //                      if(      rtn.startsWith( "0000" ) ) { rtn = "00000101"; }
173    //                      else if( rtn.startsWith( "9999" ) ) { rtn = "99991231"; }
174    //                      else                                { rtn += "01"; }
175    //              }
176    //              return rtn;
177            }
178    
179            /**
180             * 繝??繧ｿ縺檎匳骭ｲ蜿ｯ閭ｽ縺九←縺?°繧偵メ繧ｧ繝?け縺励∪縺吶?
181             * 繝??繧ｿ縺後お繝ｩ繝ｼ縺ｮ蝣ｴ蜷医?縲√◎縺ｮ繧ｨ繝ｩ繝ｼ蜀?ｮｹ繧定ｿ斐＠縺ｾ縺吶?
182             * valueSet( String ) 縺吶ｋ莉･蜑阪?譁?ｭ励↓縺､縺?※縺ｯ,謨ｴ蜷域?縺ｯ菫晁ｨｼ縺励※縺?∪縺帙ｓ縲?
183             *
184             * @og.rev 3.6.0.0 (2004/09/22) dbType 繝代Λ繝｡繝ｼ繧ｿ繧貞ｼ墓焚縺ｫ霑ｽ蜉?
185             * @og.rev 5.2.2.0 (2010/11/01) 蜴ｳ蟇?↓繝√ぉ繝?け(isStrict=true)縺吶ｋ繝輔Λ繧ｰ繧定ｿｽ蜉?
186             * @og.rev 5.6.0.3 (2012/01/24) 譌･莉倥メ繧ｧ繝?け縺ｮ謨ｴ蜷域?縺ｾ縺ｧ蜷ｫ繧√◆繝√ぉ繝?け繧貞?繧後ｋ縲?
187             *
188             * @param   key         繧ｿ繧ｰ縺ｮ繧ｭ繝ｼ(繧ｫ繝ｩ繝?D)
189             * @param   value       繝√ぉ繝?け縺吶ｋ蛟､
190             * @param   sizeX       謨ｴ謨ｰ驛ｨ蛻??譁?ｭ怜?縺ｮ髟ｷ縺?
191             * @param   sizeY       蟆第焚驛ｨ蛻??譁?ｭ怜?縺ｮ髟ｷ縺?
192             * @param   typeParam   dbType 繝代Λ繝｡繝ｼ繧ｿ
193             * @param   isStrict    蜴ｳ蟇?↓繝√ぉ繝?け縺吶ｋ縺九←縺?°[true:縺吶ｋ/false:讓呎ｺ也噪]
194             *
195             * @return  繧ｨ繝ｩ繝ｼ蜀?ｮｹ
196             */
197    //      public ErrorMessage valueCheck( final String key ,final String value ,
198    //                                                                      final int sizeX ,final int sizeY ,final String param ) {
199            @Override
200            public ErrorMessage valueCheck( final String key ,final String value ,
201                                                                            final int sizeX ,final int sizeY ,final String typeParam ,final boolean isStrict) {
202    
203                    ErrorMessage msg = new ErrorMessage();
204                    if( value == null || value.length() == 0 ) { return msg; }
205    
206                    int len = (sizeY == 0) ? sizeX : sizeX + sizeY + 1;
207                    // 5.2.2.0 (2010/11/01) 蜴ｳ蟇?↓繝√ぉ繝?け(isStrict=true)縺吶ｋ繝輔Λ繧ｰ繧定ｿｽ蜉?
208                    if( isStrict ) {
209                            if( len != value.length() ) {
210                                    // 譁?ｭ怜?縺ｮ髟ｷ縺輔′謖?ｮ壹?髟ｷ縺輔→逡ｰ縺ｪ繧翫∪縺吶?
211                                    msg.addMessage( 0,ErrorMessage.NG,"ERR0011", key,value, String.valueOf( value.length() ), String.valueOf( len ) );
212                            }
213                    }
214                    else {
215                            if( len < value.length() ) {
216                                    // 譁?ｭ怜?縺ｮ髟ｷ縺輔′謖?ｮ壹?髟ｷ縺輔ｈ繧翫ｂ髟ｷ縺?〒縺吶?
217                                    msg.addMessage( 0,ErrorMessage.NG,"ERR0006",key,value,
218                                                                                    String.valueOf( value.length() ),String.valueOf( len ) );
219                            }
220                    }
221    
222    //              StringBuilder val = new StringBuilder();
223    //              boolean isError = false;
224    //              for( int i=0; i<value.length(); i++ ) {
225    //                      char ch = value.charAt( i );
226    //                      if( ('0' > ch || '9' < ch) ) {
227    //                              val.append( "<span class=\"NG\">" ).append( ch ).append( "</span>" );
228    //                              isError = true;
229    //                      }
230    //                      else {
231    //                              val.append( ch );
232    //                      }
233    //              }
234    //              if( isError ) {
235    //                      // 謖?ｮ壹?譁?ｭ嶺ｻ･螟悶?譁?ｭ励′菴ｿ繧上ｌ縺ｦ縺?∪縺吶?
236    //                      msg.addMessage( 0,ErrorMessage.NG,"ERR0009", key,val.toString() );
237    //              }
238    
239                    // 5.6.0.3 (2012/01/24) 譁?ｭ励?遽?峇繝√ぉ繝?け
240                    String check = DBTypeCheckUtil.rangeCheck( value, '0', '9' );
241                    if( check != null ) {
242                            // 謖?ｮ壹?譁?ｭ嶺ｻ･螟悶?譁?ｭ励′菴ｿ繧上ｌ縺ｦ縺?∪縺吶?
243                            msg.addMessage( 0,ErrorMessage.NG,"ERR0009", key,check );
244                    }
245    
246                    // 5.6.0.3 (2012/01/24) 譌･莉俶枚蟄励?謨ｴ蜷域?繝√ぉ繝?け
247                    // "0000","9999" 縺ｧ蟋九∪繧区律莉倥?譛ｪ譚｡莉ｶ險ｱ蜿ｯ縲?
248                    check = DBTypeCheckUtil.ymdFormatCheck( value );
249                    if( check != null ) {
250                            // 謖?ｮ壹?譁?ｭ嶺ｻ･螟悶?譁?ｭ励′菴ｿ繧上ｌ縺ｦ縺?∪縺吶?
251                            msg.addMessage( 0,ErrorMessage.NG,"ERR0009", key,check );
252                    }
253    
254                    // 3.6.0.0 (2004/09/22) dbType 繝代Λ繝｡繝ｼ繧ｿ繧剃ｽｿ逕ｨ縺励◆繝槭ャ繝√メ繧ｧ繝?け
255                    check = DBTypeCheckUtil.matcheCheck( value,typeParam );
256                    if( check != null ) {
257                            // 謖?ｮ壹?譁?ｭ嶺ｻ･螟悶?譁?ｭ励′菴ｿ繧上ｌ縺ｦ縺?∪縺吶?
258                            msg.addMessage( 0,ErrorMessage.NG,"ERR0009", key,check );
259                    }
260    
261                    return msg;
262            }
263    }