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.Attributes;
019    import org.opengion.fukurou.util.XHTMLTag;
020    
021    import org.opengion.hayabusa.common.HybsSystem;
022    import org.opengion.hayabusa.common.HybsSystemException;
023    
024    import org.opengion.hayabusa.db.AbstractEditor;
025    import org.opengion.hayabusa.db.CellEditor;
026    import org.opengion.hayabusa.db.DBColumn;
027    import org.opengion.hayabusa.db.DBColumnConfig;
028    import org.opengion.hayabusa.resource.ResourceFactory;
029    import org.opengion.hayabusa.resource.ResourceManager;
030    import org.opengion.hayabusa.resource.LabelData;
031    
032    import java.util.Locale ;
033    
034    /**
035     * 蜍慕噪繧ｫ繝ｩ繝??Entry繧ｫ繝ｩ繝?ｒ邱ｨ髮?☆繧句?蜷医↓菴ｿ逕ｨ縺吶ｋ繧ｨ繝?ぅ繧ｿ繝ｼ繧ｯ繝ｩ繧ｹ縺ｧ縺吶?
036     *
037     * Editor_ENTCLM 縺ｯ縲・ditor_EntryColumn 縺ｮ逡･縺ｧ縲・ditor_COLUMN.java 繧?
038     * 蠑ｷ蛹悶＠縺溷ｽ｢縺ｧ菴懈?縺励∪縺吶?
039     * 縺薙ｌ縺ｯ縲∝ｼ墓焚縺ｮ蛟､繧偵く繝ｼ縺ｫ縲．BColumn 繧貞虚逧?↓菴懈?縺吶ｋ讖溯?縺ｫ縺ｪ繧翫∪縺吶?
040     *
041     * Editor_COLUMN 縺ｨ縺ｮ驕輔＞縺ｯ縲√％縺｡繧峨?縲∬｡後〒縺ｯ縺ｪ縺上?Entry蠖｢蠑上?繧ｫ繝ｩ繝?ｒ
042     * 菴懈?縺吶ｋ縺ｨ縺薙ｍ縺ｧ縺吶?縺､縺ｾ繧翫?陦檎分蜿ｷ縺ｯ縲?未菫ゅ≠繧翫∪縺帙ｓ縲?
043     * 騾壼ｸｸ縺ｯ縲√き繝ｩ繝?錐__陦檎分蜿ｷ 繧偵く繝ｼ縺ｨ縺吶ｋ繝?く繧ｹ繝医ヵ繧｣繝ｼ繝ｫ繝峨↑縺ｩ繧?
044     * 蜃ｺ蜉帙＠縺ｾ縺吶′縲・ditor_ENTCLM 縺ｯ縲∝錐蜑阪◎縺ｮ繧ゅ?繧偵く繝ｼ縺ｨ縺吶ｋ
045     * 繝?く繧ｹ繝医ヵ繧｣繝ｼ繝ｫ繝峨↑縺ｩ繧貞?蜉帙＠縺ｾ縺吶?
046     * 縺ゅ→縲√き繝ｩ繝?ｼ墓焚(:縺ｧ蛹ｺ蛻?ｉ繧後◆蛟､)縺御ｽｿ縺医∪縺吶?
047     * 騾壼ｸｸ縺ｯ縲∝?(Value)縺ｫ縲√き繝ｩ繝?錐縺ｮ縺ｿ繧偵そ繝?ヨ縺励∪縺吶′縲√さ繝ｭ繝ｳ(:)縺ｧ縲?
048     * 蛹ｺ蛻?▲縺ｦ繝代Λ繝｡繝ｼ繧ｿ繧呈ｸ｡縺帙∪縺吶?
049     *
050     * 繧ｫ繝ｩ繝?錐:蛟､:must:Length:Label:Editor:DBType:EditParam 縺ｮ鬆?分縺ｧ縺吶?
051     *
052     * 繧ｳ繝ｭ繝ｳ縺ｮ謨ｰ縺?￠蛻?屬縺励∪縺吶′縲∵焚縺ｯ蟆代↑縺上※繧り憶縺?′荳ｦ縺ｳ鬆??縲∝ｿ??縺ｧ縺吶?
053     *
054     * 騾壼ｸｸ縲√％縺ｮ縺ｾ縺ｾ縺ｧ縺ｯ縲√Μ繧ｽ繝ｼ繧ｹ縺ｫ蟄伜惠縺吶ｋ縺薙→縺悟燕謠舌〒縺吶′縲?
055     * 邱ｨ髮?ヱ繝ｩ繝｡繝ｼ繧ｿ縺ｫ縲ヾAVE=TRUE 縺ｨ縺?≧繧ｭ繝ｼ繝ｯ繝ｼ繝峨ｒ繧ｻ繝?ヨ縺吶ｋ縺ｨ縲?
056     * 蛟九?縺ｫ菴懈?縺励◆蛟､繧貞?縺ｫ縲ヽesourceManager 縺ｫ縲∝虚逧?↓菴懈?縺励◆
057     * LabelData 繧定ｿｽ蜉?☆繧区ｩ溯?繧呈戟縺溘○縺ｾ縺吶?
058     * 縺薙?縲´abelData 縺ｯ縲??蟶ｸ縺ｮLabelDataLoader縺ｮ繝励?繝ｫ縺ｧ縺ｯ縺ｪ縺上?
059     * ResourceManager縺ｧ縲∝?蛻･縺ｫ邂｡逅?＆繧後ｋ縺溘ａ縲∫音谿翫↑譁ｹ豕輔ｒ菴ｿ繧上↑縺?→
060     * 蛟､繧貞叙繧雁?縺吶％縺ｨ縺ｯ縺ｧ縺阪∪縺帙ｓ縲?
061     * 縺薙?繧ｭ繝｣繝?す繝･縺輔ｌ縺溘Λ繝吶Ν繧堤畑縺?ｋ縺薙→縺ｧ縲…olumnCheck縺ｮ繧ｨ繝ｩ繝ｼ繝｡繝?そ繝ｼ繧ｸ
062     * 縺ｮ繝ｩ繝吶Ν繧貞虚逧?↓譖ｸ縺肴鋤縺医◆繝ｩ繝吶Ν縺ｧ陦ｨ遉ｺ縺吶ｋ縺薙→縺後〒縺阪∪縺吶?
063     *
064     * 縺輔ｉ縺ｫ縲∫ｷｨ髮?ヱ繝ｩ繝｡繝ｼ繧ｿ縺ｫ縲＿UERY=繝ｻ繝ｻ繝ｻ繝ｻ 縺ｨ縺?≧繧ｭ繝ｼ繝ｯ繝ｼ繝峨ｒ
065     * 繧ｻ繝?ヨ縺吶ｋ縺ｨ縲√◎縺ｮSQL蛻?ｒ螳溯｡後＠縺ｦ縲√さ繝ｼ繝峨Μ繧ｽ繝ｼ繧ｹ繧剃ｽ懈?縺励∪縺吶?
066     * 縺薙■繧峨?縲ヾAVE=TRUE 縺ｮ蝣ｴ蜷医?縺ｿ螳溯｡後＆繧後?繧ｳ繝ｼ繝峨Μ繧ｽ繝ｼ繧ｹ縺ｮ繧ｭ繝｣繝?す繝･縺ｫ
067     * 繧ｻ繝?ヨ縺輔ｌ縺ｾ縺吶?
068     *
069     * 縺薙?繧ｨ繝?ぅ繧ｿ縺ｯeventColumn縺ｫ蟇ｾ蠢懊＠縺ｦ縺?∪縺帙ｓ縲?
070     *
071     * 繧ｫ繝ｩ繝??陦ｨ遉ｺ縺ｫ蠢?ｦ√↑螻樊?縺ｯ, DBColumn 繧ｪ繝悶ず繧ｧ繧ｯ繝?繧医ｊ蜿悶ｊ蜃ｺ縺励∪縺吶?
072     * 縺薙?繧ｯ繝ｩ繧ｹ縺ｯ縲．BColumn 繧ｪ繝悶ず繧ｧ繧ｯ繝域ｯ弱↓?代▽菴懈?縺輔ｌ縺ｾ縺吶?
073     * @og.group 繝??繧ｿ邱ｨ髮?
074     *
075     * @og.rev 5.4.2.2 (2011/12/14) 譁ｰ隕剰ｿｽ蜉??
076     *
077     * @version  4.0
078     * @author       Kazuhiko Hasegawa
079     * @since    JDK5.0,
080     */
081    public class Editor_ENTCLM extends AbstractEditor {
082            //* 縺薙?繝励Ο繧ｰ繝ｩ繝??VERSION譁?ｭ怜?繧定ｨｭ螳壹＠縺ｾ縺吶?       {@value} */
083            private static final String VERSION = "5.4.3.4 (2012/01/12)" ;
084    
085            private final String    lang ;
086            private final boolean   isSave ;
087            private final String    codeQuery ;
088            private final boolean   addNoValue ;            // 5.4.2.3 (2011/12/22)
089    
090            /**
091             * 繝?ヵ繧ｩ繝ｫ繝医さ繝ｳ繧ｹ繝医Λ繧ｯ繧ｿ繝ｼ縲?
092             * 縺薙?繧ｳ繝ｳ繧ｹ繝医Λ繧ｯ繧ｿ繝ｼ縺ｧ縲∝渕譛ｬ繧ｪ繝悶ず繧ｧ繧ｯ繝医ｒ菴懈?縺励∪縺吶?
093             *
094             * @og.rev 5.4.2.3 (2011/12/22) addNoValue 螻樊?繧定ｿｽ蜉?＠縺ｾ縺吶?
095             */
096            public Editor_ENTCLM() {
097    //              super();
098                    lang            = null;
099                    isSave          = false;
100                    codeQuery       = null;
101                    addNoValue      = false;                // 5.4.2.3 (2011/12/22)
102            }
103    
104            /**
105             * 繝?ヵ繧ｩ繝ｫ繝医さ繝ｳ繧ｹ繝医Λ繧ｯ繧ｿ繝ｼ縲?
106             *
107             * @og.rev 5.4.2.3 (2011/12/22) addNoValue 螻樊?繧定ｿｽ蜉?＠縺ｾ縺吶?
108             *
109             * @param       clm     DBColumn繧ｪ繝悶ず繧ｧ繧ｯ繝?
110             */
111            private Editor_ENTCLM( final DBColumn clm ) {
112            //      super( clm );
113                    name = clm.getName();           // 縺薙％縺ｧ縺?≧蜷榊燕縺ｯ縲√が繝ｪ繧ｸ繝翫Ν縺ｪ縺ｮ縺ｧ縲∝虚逧?↓菴懈?縺吶ｋ縺ｨ縺阪↓縺ｯ菴ｿ逕ｨ縺励↑縺??
114                    lang = clm.getLang();
115                    addNoValue = clm.isAddNoValue() ;               // 5.4.2.3 (2011/12/22)
116    
117                    String orgParam = clm.getEditorParam();
118                    if( orgParam != null ) {
119                            String upParam = orgParam.toUpperCase(Locale.JAPAN);
120                            // 邱ｨ髮?ヱ繝ｩ繝｡繝ｼ繧ｿ縺ｫ縲ヾAVE=TRUE 縺ｨ縺?≧繧ｭ繝ｼ繝ｯ繝ｼ繝峨′縺ゅｋ縺九←縺?°縺ｮ繝√ぉ繝?け
121                            isSave = ( upParam.indexOf( "SAVE=TRUE" ) >= 0 );
122    
123                            // QUERY= 縺ｮ繧ｭ繝ｼ繝ｯ繝ｼ繝峨′縺ゅｌ縺ｰ縲√さ繝ｼ繝峨Μ繧ｽ繝ｼ繧ｹ縺ｮ讀懃ｴ｢逕ｨSQL縺ｨ縺ｪ繧九?(繝代Λ繝｡繝ｼ繧ｿ縺ｮ谿九ｊ縺吶∋縺ｦ)
124                            int adrs = upParam.indexOf( "QUERY=" );
125                            codeQuery = ( adrs >= 0 ) ? orgParam.substring( adrs+6,orgParam.length() ) : null;
126                    }
127                    else {
128                            isSave    = false;
129                            codeQuery = null;
130                    }
131            }
132    
133            /**
134             * 蜷?が繝悶ず繧ｧ繧ｯ繝医°繧芽?蛻??繧､繝ｳ繧ｹ繧ｿ繝ｳ繧ｹ繧定ｿ斐＠縺ｾ縺吶?
135             * 閾ｪ蛻??霄ｫ繧偵く繝｣繝?す繝･縺吶ｋ縺ｮ縺九?譁ｰ縺溘↓菴懈?縺吶ｋ縺ｮ縺九?縲∝推繧ｵ繝悶け繝ｩ繧ｹ縺ｮ螳溯｣?↓
136             * 縺ｾ縺九＆繧後∪縺吶?
137             *
138             * @param       clm     DBColumn繧ｪ繝悶ず繧ｧ繧ｯ繝?
139             *
140             * @return      CellEditor繧ｪ繝悶ず繧ｧ繧ｯ繝?
141             */
142            public CellEditor newInstance( final DBColumn clm ) {
143                    return new Editor_ENTCLM( clm );
144            }
145    
146            /**
147             * 繝??繧ｿ縺ｮ邱ｨ髮?畑譁?ｭ怜?繧定ｿ斐＠縺ｾ縺吶?
148             *
149             * 騾壼ｸｸ縺ｯ縲∝?(Value)縺ｫ縲√き繝ｩ繝?錐縺ｮ縺ｿ繧偵そ繝?ヨ縺励∪縺吶′縲√さ繝ｭ繝ｳ(:)縺ｧ縲?
150             * 蛹ｺ蛻?▲縺ｦ繝代Λ繝｡繝ｼ繧ｿ繧呈ｸ｡縺帙∪縺吶?
151             *
152             * 繧ｫ繝ｩ繝?錐:蛟､:must:Length:Label:Editor:DBType:EditParam 縺ｮ鬆?分縺ｧ縺吶?
153             *
154             * 繧ｳ繝ｭ繝ｳ縺ｮ謨ｰ縺?￠蛻?屬縺励∪縺吶′縲∵焚縺ｯ蟆代↑縺上※繧り憶縺?′荳ｦ縺ｳ鬆??縲∝ｿ??縺ｧ縺吶?
155             *
156             * @og.rev 5.4.2.3 (2011/12/22) addNoValue 螻樊?繧定ｿｽ蜉?＠縺ｾ縺吶?
157             * @og.rev 5.4.3.4 (2012/01/12) official 繝輔Λ繧ｰ繧偵そ繝?ヨ縺励∪縺吶?繝代Λ繝｡繝ｼ繧ｿ縺ｫ繝ｩ繝吶Ν霑ｽ蜉?
158             *
159             * @param       value 蜈･蜉帛?
160             *
161             * @return      繝??繧ｿ縺ｮ陦ｨ遉ｺ逕ｨ譁?ｭ怜?
162             */
163            @Override
164            public String getValue( final String value ) {
165                    // 蜈磯?譁?ｭ励′ 繧ｳ繝ｭ繝ｳ(:)縺ｮ蝣ｴ蜷医?縲√き繝ｩ繝?錐縺檎怐逡･縺輔ｌ縺ｦ縺?ｋ縺ｮ縺ｧ縲√お繝ｩ繝ｼ
166                    if( value == null || value.isEmpty() || value.charAt(0) == ':'  ) {
167                            String errMsg = "謖?ｮ壹?繧ｫ繝ｩ繝??蛟､縺瑚ｨｭ螳壹＆繧後※縺?∪縺帙ｓ縲?
168                                                    + HybsSystem.CR
169                                                    + "  name=[" + name + "]"
170                                                    + "  value=[" + value + "]";
171                            throw new HybsSystemException( errMsg );
172                    }
173    
174                    ResourceManager resource = ResourceFactory.newInstance( lang ) ;
175                    String[] vals = value.split( ":" , 8 );         // ?伜?蜑ｲ縺励∪縺吶?
176    
177                    String key    = vals[0];                                                                        // 驟榊??舌?縲√き繝ｩ繝?錐
178                    String val    = (vals.length >= 2) ? vals[1] : null;         // 驟榊??代?縲∝?
179                    String must   = (vals.length >= 3) ? vals[2] : null;         // 驟榊??偵?縲［ust
180                    String len    = (vals.length >= 4) ? vals[3] : null;         // 驟榊??薙?縲´ength
181                    String lbl    = (vals.length >= 5) ? vals[4] : null;         // 驟榊??斐?縲´abel
182                    String edit   = (vals.length >= 6) ? vals[5] : null;         // 驟榊??輔?縲・ditor
183                    String dbtype = (vals.length >= 7) ? vals[6] : null;         // 驟榊??悶?縲．BType
184                    String edPrm  = (vals.length >= 8) ? vals[7] : null;         // 驟榊??励?縲・ditParam
185    
186                    boolean isMust = "1".equalsIgnoreCase( must ) || "true".equalsIgnoreCase( must ) ;      // must縺瑚ｨｭ螳壹＆繧後※縺?ｋ縺九←縺?°
187                    // 繧ｭ繝ｼ縺ｫ蟇ｾ蠢懊☆繧汽BColumn縺後↑縺代ｌ縺ｰ縲］ull 縺瑚ｿ斐＆繧後ｋ縲?
188                    DBColumn dbColumn = resource.getDBColumn( key );
189    
190                    // DBColumnConfig 縺ｧ蛟､縺ｮ繧ｻ繝?ヨ
191                    DBColumnConfig config = (dbColumn != null) ? dbColumn.getConfig() : new DBColumnConfig( key );
192    
193                    // 5.4.3.4 (2012/01/12) official 繝輔Λ繧ｰ繧偵そ繝?ヨ縺励∪縺吶?
194                    config.setOfficial( true );
195    
196                    // 5.4.2.3 (2011/12/22) addNoValue 螻樊?繧定ｿｽ蜉?
197                    config.setAddNoValue( addNoValue );
198    
199                    String mstChStr = "";
200                    if( isMust ) {                  // 驟榊??偵?縲［ust
201                            Attributes editAttri = config.getEditorAttributes();
202                            if( editAttri == null ) { editAttri = new Attributes(); }
203                            editAttri.add( "class","must" );
204                            config.setEditorAttributes( editAttri );
205    
206                            // must 謖?ｮ壹?蝣ｴ蜷医↓縲√メ繧ｧ繝?け逕ｨ縺ｮhidden 繧剃ｽ懈?縺励∪縺吶?
207                            mstChStr = XHTMLTag.hidden( HybsSystem.MUST_KEY + "must", key );
208                    }
209                    if( len != null && !len.isEmpty() ) {                   // 驟榊??薙?縲´ength
210                            config.setMaxlength( len );
211                    }
212                    // 5.4.3.4 (2012/01/12) 繝代Λ繝｡繝ｼ繧ｿ縺ｫ繝ｩ繝吶Ν霑ｽ蜉?
213                    if( lbl != null && !lbl.isEmpty() ) {                   // 驟榊??斐?縲´abel
214                            LabelData labelData = resource.getLabelData( lbl ) ;
215                            config.setLabelData( labelData );
216    //                      if( isSave ) {  // isSave 縺?true 縺ｧ縲√そ繝ｼ繝悶☆繧九?
217    ////                    resource.setLabelData( key,labelData );
218    //                              resource.setLabel( key,lbl );
219    //                      }
220                    }
221                    if( edit != null && !edit.isEmpty() ) {                 // 驟榊??輔?縲・ditor
222                            config.setEditor( edit );
223                    }
224                    if( dbtype != null && !dbtype.isEmpty() ) {             // 驟榊??悶?縲．BType
225                            config.setDbType( dbtype );
226                    }
227                    if( edPrm != null && !edPrm.isEmpty() ) {               // 驟榊??励?縲・ditParam
228                            config.setEditorParam( edPrm );
229                    }
230    
231                    // 蜍慕噪縺ｪ繧ｳ繝ｼ繝峨Μ繧ｽ繝ｼ繧ｹ縺ｮ菴懈?
232                    if( codeQuery != null && isSave ) {
233                            config.setCodeData( resource.getCodeData( key,codeQuery ) );
234                    }
235    
236                    dbColumn = new DBColumn( config );
237                    if( isSave ) {  // isSave 縺?true 縺ｧ縲√そ繝ｼ繝悶☆繧九?
238                            resource.setDBColumn( key,dbColumn );
239                    }
240    
241                    // val 縺ｨ must 縺ｯ縲√く繝｣繝?す繝･縺輔ｌ縺?DBColumn 縺ｨ蛻･縺ｫ縲∵ｯ主屓逡ｰ縺ｪ繧九こ繝ｼ繧ｹ繧呈Φ螳壹＠縺ｾ縺吶?
242                    return dbColumn.getEditorValue( val ) + mstChStr;
243            }
244    
245            /**
246             * 縺薙?繧ｯ繝ｩ繧ｹ縺ｧ縺ｯ縲・ntry蠖｢蠑上?邱ｨ髮?畑縺ｮ譁?ｭ怜?繧剃ｽ懈?縺励∪縺吶?
247             * 繧医▲縺ｦ縲∬｡檎分蜿ｷ繧剃ｻ伜刈縺励∪縺帙ｓ縲?
248             *
249             * @param       row   陦檎分蜿ｷ
250             * @param       value 蜈･蜉帛?
251             *
252             * @return      繝??繧ｿ陦ｨ遉ｺ/邱ｨ髮?畑縺ｮ譁?ｭ怜?
253             */
254            @Override
255            public String getValue( final int row,final String value ) {
256                    return getValue( value );
257            }
258    }