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.StringUtil;
019    import org.opengion.hayabusa.db.AbstractDBType;
020    
021    /**
022     * 諠??讖溷勣莠区･ｭ驛ｨ蜷代￠縲∝刀逡ｪ諠??縺ｮ譁?ｭ怜?繧呈桶縺?ぜ縺ｮ縲√き繝ｩ繝?ｱ樊?繧貞ｮ夂ｾｩ縺励∪縺吶?
023     *
024     * 蜩∫分諠??縺ｯ縲?ｼ????灘刀逡ｪ諠??縺ｨ縺励※謇ｱ繧上ｌ縺ｾ縺吶?縺ｾ縺溘?縺昴ｌ縺槭ｌ縺ｮ繝輔ぅ繝ｼ繝ｫ繝峨↓縺翫＞縺ｦ縲?
025     * 菴ｿ逕ｨ蜿ｯ閭ｽ譁?ｭ?萓九∴縺ｰ縲ヽev譁?ｭ怜?縺ｮ蛻ｶ髯?縺ｪ縺ｩ繧定?諷ｮ縺励※縺?∪縺吶?
026     *
027     *   髮ｻ豌怜刀逡ｪ(1譯∫岼縺?D' 5譯∫岼縺?8'OR'9')縺ｯ縲∽ｸ?分譛?ｾ後?譯√ｒ?假ｾ具ｾ橸ｽｼ?橸ｽｮ?拔P
028     *   (ABCEFGHJKLMNPRSTUVWY)
029     *       笆｡笆｡笆｡-笆｡笆｡笆｡笆｡笆｡-笆｡笆｡笆?
030     *   讖滓｢ｰ蜩∫分(荳願ｨ倅ｻ･螟悶?蜩∫分)縺ｯ縲?0譯∫岼繧抵ｾ假ｾ具ｾ橸ｽｼ?橸ｽｮ?拔P縺吶ｋ縲?
031     *       笆｡笆｡笆｡-笆｡笆｡笆｡笆｡笆｡-笆｡笆?
032     *   (0123456789ABCEFGHJKLMNPRSTUVWY)
033     *
034     * 繧ｿ繧､繝励メ繧ｧ繝?け縺ｨ縺励※縲∽ｻ･荳九?譚｡莉ｶ繧貞愛螳壹＠縺ｾ縺吶?
035     * 繝ｻ譁?ｭ怜?髟ｷ縺ｯ縲。yte謠帷ｮ励〒縺ｮ譁?ｭ玲焚縺ｨ縺ｮ豈碑ｼ?
036     * 繝ｻ蜊願ｧ呈枚蟄怜?繝√ぉ繝?け縲?c &lt; 0x20 || c &gt; 0x7e 莉･螟悶?繧ｨ繝ｩ繝ｼ
037     * 繝ｻ譁?ｭ励ヱ繝ｩ繝｡繝ｼ繧ｿ縺ｮ 豁｣隕剰｡ｨ迴ｾ繝√ぉ繝?け
038     * 繝ｻ繧ｯ繝ｭ繧ｹ繧ｵ繧､繝医せ繧ｯ繝ｪ繝励ユ繧｣繝ｳ繧ｰ繝√ぉ繝?け
039     *
040     * @og.group 繝??繧ｿ螻樊?
041     *
042     * @version  4.0
043     * @author   Kazuhiko Hasegawa
044     * @since    JDK5.0,
045     */
046    public class DBType_PN extends AbstractDBType {
047            //* 縺薙?繝励Ο繧ｰ繝ｩ繝??VERSION譁?ｭ怜?繧定ｨｭ螳壹＠縺ｾ縺吶?       {@value} */
048            private static final String VERSION = "4.0.0.0 (2005/08/31)" ;
049    
050            private static final String DENKI_REV = "ABCEFGHJKLMNPRSTUVWY";
051            private static final String KIKAI_REV = "0123456789ABCEFGHJKLMNPRSTUVWY";
052    
053            /**
054             * 陬ｽ騾?刀逡ｪ縺ｮRev 繧?UP縺励◆譁?ｭ怜?繧定ｿ斐＠縺ｾ縺吶?
055             * 蠑墓焚縺?null 縲√ぞ繝ｭ譁?ｭ怜?("")縲√?蝣ｴ蜷医?,迚ｩ逅?噪蛻晄悄險ｭ螳壼?
056             * (String getDefault())縺ｮ蛟､繧定ｿ斐＠縺ｾ縺吶?
057             * 10譯∵悴貅??雉ｼ蜈･蜩?Z蜩∫分)縲ヽevUP縺ｧ縺阪↑縺??蜷医?,縺昴?縺ｾ縺ｾ縺ｮ蜩∫分繧定ｿ斐＠縺ｾ縺吶?
058             *
059             * 菴?＠縲?崕豌怜刀逡ｪ(1譯∫岼縺?D' 5譯∫岼縺?8'OR'9')縺ｯ縲∽ｸ?分譛?ｾ後?譯√ｒ?假ｾ具ｾ橸ｽｼ?橸ｽｮ?拔P
060             *       笆｡笆｡笆｡-笆｡笆｡笆｡笆｡笆｡-笆｡笆｡笆?
061             *       讖滓｢ｰ蜩∫分(荳願ｨ倅ｻ･螟悶?蜩∫分)縺ｯ縲?0譯∫岼繧抵ｾ假ｾ具ｾ橸ｽｼ?橸ｽｮ?拔P縺吶ｋ縲?
062             *       笆｡笆｡笆｡-笆｡笆｡笆｡笆｡笆｡-笆｡笆?
063             *
064             * @og.rev 2.1.3.0 (2002/12/12) RevUP 蟇ｾ雎｡縺ｧ縺ｪ縺?さ繝ｼ繝峨ｒRevUP縺吶ｋ蝣ｴ蜷医?荳榊?蜷亥ｯｾ蠢?
065             *
066             * @param       value   String蠑墓焚縺ｮ譁?ｭ怜?
067             *
068             * @return  String蠑墓焚縺ｮ譁?ｭ怜?繧抵ｼ具ｼ代＠縺滓枚蟄怜?
069             */
070            @Override
071            public String valueAdd( final String value ) {
072                    if( value == null || value.length() == 0 ) { return getDefault(); }
073                    if( value.length() < 10 || value.charAt(0) == 'Z' ) { return value; }
074    
075                    char[] ch = value.toCharArray();
076    
077                    // 髮ｻ豌怜刀逡ｪ縺ｮ蝣ｴ蜷?
078                    if( ch[0] == 'D' && ( ch[4] == '8' || ch[4] == '9' ) ) {
079                            if( value.length() < 11 ) { return value; }                          // 2002.07.12
080                            int pos = DENKI_REV.indexOf( (int)ch[10] );
081                            if( pos >= 0 ) { ch[10] = DENKI_REV.charAt( pos+1 ); }
082                            else {           ch[10] ++ ;                         }  // 2.1.3.0 霑ｽ蜉?
083                    }
084                    else {
085                            int pos = KIKAI_REV.indexOf( (int)ch[9] );
086                            if( pos >= 0 ) { ch[9] = KIKAI_REV.charAt( pos+1 ); }
087                            else {           ch[9] ++ ;                         }   // 2.1.3.0 霑ｽ蜉?
088                    }
089    
090                    return new String( ch );
091            }
092    
093            /**
094             * 繧ｨ繝?ぅ繧ｿ繝ｼ縺ｧ邱ｨ髮?＆繧後◆繝??繧ｿ繧堤匳骭ｲ縺吶ｋ蝣ｴ蜷医↓縲√ョ繝ｼ繧ｿ縺昴?繧ゅ?繧?
095             * 螟画鋤縺励※縲∝ｮ溽匳骭ｲ繝??繧ｿ繧剃ｽ懈?縺励∪縺吶?
096             * 繝??繧ｿ縺ｮ陦ｨ遉ｺ逕ｨ譁?ｭ怜?繧定ｿ斐＠縺ｾ縺吶?
097             * XXX-XXXXX-XXX 蠖｢蠑上〒蜈･蜉帙＆繧後◆諠??繧偵?XXXXXXXXXXX 蠖｢蠑上〒陦ｨ遉ｺ縺励∪縺吶?
098             * 繧ｫ繝?ヨ???繝ｼ繧ｹ繝亥ｯｾ遲悶〒縺吶?
099             *
100             * @og.rev 3.8.6.1 (2006/10/24) 譁ｰ隕剰ｿｽ蜉?
101             *
102             * @param       value   (荳?握縺ｫ邱ｨ髮?ョ繝ｼ繧ｿ縺ｨ縺励※逋ｻ骭ｲ縺輔ｌ縺溘ョ繝ｼ繧ｿ)
103             *
104             * @return  菫ｮ豁｣蠕後?譁?ｭ怜?(荳?握縺ｫ繝??繧ｿ繝吶?繧ｹ縺ｫ逋ｻ骭ｲ縺吶ｋ繝??繧ｿ)
105             */
106            @Override
107            public String valueSet( final String value ) {
108                    String newVal = StringUtil.rTrim( value );
109    
110                    if( newVal != null && newVal.indexOf( '-' ) >= 0 ) {
111                            newVal = StringUtil.replace( newVal,"-","" );
112                    }
113    
114                    return newVal;
115            }
116    }