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.hayabusa.common.HybsSystem;
019    import org.opengion.hayabusa.common.HybsSystemException;
020    import org.opengion.hayabusa.db.AbstractEditor;
021    import org.opengion.hayabusa.db.CellEditor;
022    import org.opengion.hayabusa.db.DBColumn;
023    import org.opengion.hayabusa.db.Selection;
024    import org.opengion.hayabusa.db.SelectionFactory;
025    import org.opengion.fukurou.util.StringFormat;
026    import org.opengion.fukurou.util.XHTMLTag;
027    import org.opengion.fukurou.util.Attributes;
028    import org.opengion.fukurou.util.TagBuffer;
029    
030    /**
031     * INDBMENU 繧ｨ繝?ぅ繧ｿ繝ｼ縺ｯ縲√き繝ｩ繝??陦ｨ遉ｺ繝代Λ繝｡繝ｼ繧ｿ繝ｼ縺ｮ?ｳ?ｱ?ｬ譁?ｒ螳溯｡檎ｵ先棡繧医ｊ縲?
032     * 菴懈?縺励◆繝励Ν繝?え繝ｳ繝｡繝九Η繝ｼ縺ｨ縲√ユ繧ｭ繧ｹ繝医ヵ繧｣繝ｼ繝ｫ繝峨↓繧医ｋ蜈･蜉帙?荳｡譁ｹ繧偵し繝昴?繝医☆繧九?
033     * 邱ｨ髮?↓菴ｿ逕ｨ縺吶ｋ繧ｯ繝ｩ繧ｹ縺ｧ縺吶?
034     *
035     * JavaScript 縺ｫ繧医ｊ繝?く繧ｹ繝医ヵ繧｣繝ｼ繝ｫ繝峨→繝｡繝九Η繝ｼ(繧ｳ繝ｳ繝懊?繝?け繧ｹ)繧帝㍾縺ｭ蜷医ｏ縺帙※
036     * 陦ｨ遉ｺ縺励※縺翫″縲√Γ繝九Η繝ｼ縺ｧ驕ｸ謚槭＠縺溷?繧偵?繝?く繧ｹ繝医ヵ繧｣繝ｼ繝ｫ繝峨↓險ｭ螳壹＠縺ｦ縺?∪縺吶?
037     * 縺薙?繧ｨ繝?ぅ繧ｿ繧剃ｽｿ逕ｨ縺吶ｋ縺ｫ縺ｯ縲）sp/common/inputMenu.js 繧剃ｺ医ａ菴ｿ逕ｨ縺ｧ縺阪ｋ繧医≧縺ｫ
038     * 險ｭ螳壹＠縺ｦ縺翫￥蠢?ｦ√′縺ゅｊ縺ｾ縺吶?
039     *
040     * 縺薙?繧ｨ繝?ぅ繧ｿ縺ｯeventColumn縺ｫ蟇ｾ蠢懊＠縺ｦ縺?∪縺帙ｓ縲?
041     *
042     *  繧ｫ繝ｩ繝??陦ｨ遉ｺ縺ｫ蠢?ｦ√↑螻樊?縺ｯ, DBColumn 繧ｪ繝悶ず繧ｧ繧ｯ繝?繧医ｊ蜿悶ｊ蜃ｺ縺励∪縺吶?
043     * 縺薙?繧ｯ繝ｩ繧ｹ縺ｯ縲．BColumn 繧ｪ繝悶ず繧ｧ繧ｯ繝域ｯ弱↓?代▽菴懈?縺輔ｌ縺ｾ縺吶?
044     *
045     * @og.rev 3.5.6.2 (2004/07/05) 譁ｰ隕丈ｽ懈?
046     * @og.group 繝??繧ｿ邱ｨ髮?
047     *
048     * @version  4.0
049     * @author       Kazuhiko Hasegawa
050     * @since    JDK5.0,
051     */
052    public class Editor_INDBMENU extends AbstractEditor {
053            //* 縺薙?繝励Ο繧ｰ繝ｩ繝??VERSION譁?ｭ怜?繧定ｨｭ螳壹＠縺ｾ縺吶?       {@value} */
054            private static final String VERSION = "5.6.3.0 (2013/04/01)" ;
055    
056            private static final String SEL1 = "<script type=\"text/javascript\">makeInputMenu('" ;
057            private static final String SEL2 = "');</script>" ;
058    
059            private final String query ;
060            private final String dbid ;
061            private final String lang ;                             // 4.0.0 (2006/11/15)
062            private final boolean addNoValue ;              // 3.5.5.7 (2004/05/10)
063            private final boolean seqFlag ;                 // 3.6.0.6 (2004/10/22)
064            private final TagBuffer selTagBuffer = new TagBuffer() ;
065    
066            /**
067             * 繝?ヵ繧ｩ繝ｫ繝医さ繝ｳ繧ｹ繝医Λ繧ｯ繧ｿ繝ｼ縲?
068             * 縺薙?繧ｳ繝ｳ繧ｹ繝医Λ繧ｯ繧ｿ繝ｼ縺ｧ縲∝渕譛ｬ繧ｪ繝悶ず繧ｧ繧ｯ繝医ｒ菴懈?縺励∪縺吶?
069             *
070             * @og.rev 3.6.0.6 (2004/10/22) 繧ｷ繝ｼ繧ｱ繝ｳ繧ｹ繧｢繧ｯ繧ｻ繧ｹ讖溯?(seqFlag)繧定ｿｽ蜉?＠縺ｾ縺?
071             */
072            public Editor_INDBMENU() {
073                    // 4.3.4.4 (2009/01/01)
074    //              super();
075                    query   = null;
076                    dbid    = null;
077                    lang    = null;                 // 4.0.0 (2006/11/15)
078                    addNoValue = false;             // 3.5.5.7 (2004/05/10)
079                    seqFlag    = false;             // 3.6.0.6 (2004/10/22)
080                    name    = null;                 // 4.3.4.0 (2008/12/01)
081            }
082    
083            /**
084             * 繧ｳ繝ｳ繧ｹ繝医Λ繧ｯ繧ｿ繝ｼ縲?
085             *
086             * @og.rev 3.6.0.6 (2004/10/22) 繧ｷ繝ｼ繧ｱ繝ｳ繧ｹ繧｢繧ｯ繧ｻ繧ｹ讖溯?(seqFlag)繧定ｿｽ蜉?＠縺ｾ縺?
087             * @og.rev 4.0.0.0 (2006/11/24) TextField蛻??螻樊?險ｭ螳?
088             * @og.rev 5.6.3.0 (2013/04/01) 繝励Ν繝?え繝ｳ縺ｮonChange縺ｮ險ｭ螳壼?謇?ｒ螟画峩
089             *
090             * @param       clm     DBColumn繧ｪ繝悶ず繧ｧ繧ｯ繝?
091             */
092            private Editor_INDBMENU( final DBColumn clm ) {
093                    super( clm );
094                    tagBuffer.add( XHTMLTag.inputAttri( attributes ) );
095    
096                    addNoValue      = clm.isAddNoValue() ;          // 3.5.5.7 (2004/05/10)
097                    query           = clm.getEditorParam();
098                    dbid            = clm.getDbid();
099                    lang            = clm.getLang();                        // 4.0.0 (2006/11/15)
100                    seqFlag         = false;                // 3.6.0.6 (2004/10/22)
101                    name            = clm.getName(); //4.3.4.0 (2008/12/01)
102    
103                    if( query == null || query.length() == 0 ) {
104                            String errMsg = "DBMENU Editor 縺ｧ縺ｯ縲∫ｷｨ髮?ヱ繝ｩ繝｡繝ｼ繧ｿ縺ｯ蠢??縺ｧ縺吶?"
105                                            + " name=[" + name + "]" + HybsSystem.CR ;
106                            throw new HybsSystemException( errMsg );
107                    }
108    
109                    String  disabled = clm.isWritable() ? null : "disabled" ;
110    
111                    Attributes selAttri = new Attributes();
112                    selAttri.set( "disabled"        ,disabled );
113    //              selAttri.set( "onChange" ,"selChanged(this);" );        // INDBMENU 迚ｹ譛峨?JavaScript
114    
115                    selAttri.addAttributes( clm.getEditorAttributes() );
116                    
117                    selAttri.set( "onChange" ,"selChanged(this);" );        // INDBMENU 迚ｹ譛峨?JavaScript 5.6.3.0 (2013/03/01) 蝣ｴ謇?､画峩
118                    
119                    selTagBuffer.add( XHTMLTag.selectAttri( selAttri ) );
120            }
121    
122            /**
123             * 蜷?が繝悶ず繧ｧ繧ｯ繝医°繧芽?蛻??繧､繝ｳ繧ｹ繧ｿ繝ｳ繧ｹ繧定ｿ斐＠縺ｾ縺吶?
124             * 閾ｪ蛻??霄ｫ繧偵く繝｣繝?す繝･縺吶ｋ縺ｮ縺九?譁ｰ縺溘↓菴懈?縺吶ｋ縺ｮ縺九?縲∝推繧ｵ繝悶け繝ｩ繧ｹ縺ｮ螳溯｣?↓
125             * 縺ｾ縺九＆繧後∪縺吶?
126             *
127             * @param       clm     DBColumn繧ｪ繝悶ず繧ｧ繧ｯ繝?
128             *
129             * @return      CellEditor繧ｪ繝悶ず繧ｧ繧ｯ繝?
130             */
131            public CellEditor newInstance( final DBColumn clm ) {
132                    return new Editor_INDBMENU( clm );
133            }
134    
135            /**
136             * 繝??繧ｿ縺ｮ邱ｨ髮?畑譁?ｭ怜?繧定ｿ斐＠縺ｾ縺吶?
137             *
138             * 縺薙％縺ｧ縺ｯ縲、AA:BBB:CCC:DDD 縺ｨ縺?≧蛟､繧偵?$1,$2,$3,$4 縺ｫ蜑ｲ繧雁ｽ薙※縺ｪ縺翫＠縺ｦ縲?
139             * QUERY繧貞ｮ溯｡後＠縺ｾ縺吶?縺ｾ縺溘?$1 縺ｯ縲∵悽譚･縺ｮ蛟､縺ｨ縺励※縲√Γ繝九Η繝ｼ縺ｮ蛻晄悄蛟､險ｭ螳夂ｭ峨↓
140             * 菴ｿ逕ｨ縺励∪縺吶?荳願ｨ倥?萓九〒縺ｯ縲、AA 縺悟?縺ｧ縲√◎繧御ｻ･髯阪?縲∝ｼ墓焚縺ｫ縺ｪ繧翫∪縺吶?
141             * 縺輔ｉ縺ｫ縲∝?縺ｮ譁?ｭ怜?"AAA:BBB:CCC:DDD"縺ｯ縲?0 縺ｫ蜑ｲ繧雁ｽ薙※繧峨ｌ縺ｾ縺吶?蜑ｲ繧雁ｽ薙※縺後↑縺?
142             * 螟画焚縺ｯ縲?"(繧ｼ繝ｭ譁?ｭ怜?)縺ｨ縺励※縲∵桶繧上ｌ縺ｾ縺吶?
143             *
144             * @og.rev 3.8.5.3 (2006/06/30) 菴咲ｽｮ繧堤ｵｶ蟇ｾ菴咲ｽｮ謖?ｮ?position:absolute;)
145             * @og.rev 4.3.7.2 (2009/06/15) 螻樊?縺ｧid縺悟?蜉帙＆繧後ｋ蝣ｴ蜷医?縲（d繧貞?蜉帙＠縺ｪ縺?
146             *
147             * @param       value 蜈･蜉帛?
148             *
149             * @return      繝??繧ｿ縺ｮ邱ｨ髮?畑譁?ｭ怜?
150             */
151            @Override
152            public String getValue( final String value ) {
153    
154                    // input 繧ｿ繧ｰ縺ｮ菴懈?
155                    TagBuffer intag = new TagBuffer( "input" );
156                    intag.add( "name"    , name );
157                    if( attributes.get( "id" ) == null || attributes.get( "id" ).length() == 0 ) { // 4.3.7.2 (2009/06/15)
158                            intag.add( "id"      , name );          // INDBMENU 迚ｹ譛峨?JavaScript逕ｨ縺ｮ繧ｭ繝ｼ
159                    }
160                    intag.add( "value"   , value );
161                    intag.add( "size"    , size1 );
162                    intag.add( tagBuffer.makeTag() );
163                    intag.add( optAttr );
164    
165                    // select 繧ｿ繧ｰ縺ｮ菴懈?
166                    TagBuffer seltag = new TagBuffer( "select" );
167                    seltag.add( "id"      , name + ".sel" );        // INDBMENU 迚ｹ譛峨?JavaScript逕ｨ縺ｮ繧ｭ繝ｼ
168                    seltag.add( "style"   , "position:absolute;" ); // 3.8.5.3 (2006/06/30) 菴咲ｽｮ繧堤ｵｶ蟇ｾ菴咲ｽｮ謖?ｮ?
169                    seltag.add( selTagBuffer.makeTag() );
170                    seltag.add( optAttr );
171    
172                    seltag = getOption( seltag,value );
173    
174                    return intag.makeTag() + HybsSystem.CR +
175                                    seltag.makeTag() + HybsSystem.CR +
176                                    SEL1 + name + SEL2;
177            }
178    
179            /**
180             * name螻樊?繧貞､峨∴縺溘?繝??繧ｿ陦ｨ遉ｺ/邱ｨ髮?畑縺ｮHTML譁?ｭ怜?繧剃ｽ懈?縺励∪縺吶?
181             * 繝??繝悶Ν荳翫? name 縺ｫ 陦檎分蜿ｷ繧剃ｻ伜刈縺励※縲∝錐蜑浩陦檎分蜿ｷ 縺ｧ逋ｻ骭ｲ縺吶ｋ繧ｭ繝ｼ繧剃ｽ懈?縺?
182             * 繝ｪ繧ｯ繧ｨ繧ｹ繝域ュ蝣ｱ繧抵ｼ代▽豈弱?繝輔ぅ繝ｼ繝ｫ繝峨〒蜃ｦ逅?〒縺阪∪縺吶?
183             *
184             * 縺薙％縺ｧ縺ｯ縲、AA:BBB:CCC:DDD 縺ｨ縺?≧蛟､繧偵?$1,$2,$3,$4 縺ｫ蜑ｲ繧雁ｽ薙※縺ｪ縺翫＠縺ｦ縲?
185             * QUERY繧貞ｮ溯｡後＠縺ｾ縺吶?縺ｾ縺溘?$1 縺ｯ縲∵悽譚･縺ｮ蛟､縺ｨ縺励※縲√Γ繝九Η繝ｼ縺ｮ蛻晄悄蛟､險ｭ螳夂ｭ峨↓
186             * 菴ｿ逕ｨ縺励∪縺吶?荳願ｨ倥?萓九〒縺ｯ縲、AA 縺悟?縺ｧ縲√◎繧御ｻ･髯阪?縲∝ｼ墓焚縺ｫ縺ｪ繧翫∪縺吶?
187             * 縺輔ｉ縺ｫ縲∝?縺ｮ譁?ｭ怜?"AAA:BBB:CCC:DDD"縺ｯ縲?0 縺ｫ蜑ｲ繧雁ｽ薙※繧峨ｌ縺ｾ縺吶?蜑ｲ繧雁ｽ薙※縺後↑縺?
188             * 螟画焚縺ｯ縲?"(繧ｼ繝ｭ譁?ｭ怜?)縺ｨ縺励※縲∵桶繧上ｌ縺ｾ縺吶?
189             *
190             * @og.rev 3.8.5.1 (2006/04/28) makeInputMenu 蜻ｼ縺ｳ蜃ｺ縺玲凾縺ｮ蠑墓焚險倩ｿｰ繝溘せ繧剃ｿｮ豁｣
191             * @og.rev 3.8.5.3 (2006/06/30) 菴咲ｽｮ繧堤ｵｶ蟇ｾ菴咲ｽｮ謖?ｮ?position:absolute;)
192             * @og.rev 4.3.7.2 (2009/06/15) 螻樊?縺ｧid縺悟?蜉帙＆繧後ｋ蝣ｴ蜷医?縲（d繧貞?蜉帙＠縺ｪ縺?
193             *
194             * @param       row   陦檎分蜿ｷ
195             * @param       value 蜈･蜉帛?
196             *
197             * @return      繝??繧ｿ陦ｨ遉ｺ/邱ｨ髮?畑縺ｮ譁?ｭ怜?
198             */
199            @Override
200            public String getValue( final int row,final String value ) {
201    
202                    String name2 = name + HybsSystem.JOINT_STRING + row ;
203    
204                    // input 繧ｿ繧ｰ縺ｮ菴懈?
205                    TagBuffer intag = new TagBuffer( "input" );
206                    intag.add( "name"    , name2 );
207                    if( attributes.get( "id" ) == null || attributes.get( "id" ).length() == 0 ) { // 4.3.7.2 (2009/06/15)
208                            intag.add( "id"      , name2 );         // INDBMENU 迚ｹ譛峨?JavaScript逕ｨ縺ｮ繧ｭ繝ｼ
209                    }
210                    intag.add( "value"   , value );
211                    intag.add( "size"    , size2 );
212                    intag.add( tagBuffer.makeTag() );
213                    intag.add( optAttr );
214    
215                    // select 繧ｿ繧ｰ縺ｮ菴懈?
216                    TagBuffer seltag = new TagBuffer( "select" );
217                    seltag.add( "id"      , name2 + ".sel" );               // INDBMENU 迚ｹ譛峨?JavaScript逕ｨ縺ｮ繧ｭ繝ｼ
218                    seltag.add( "style"   , "position:absolute;" ); // 3.8.5.3 (2006/06/30) 菴咲ｽｮ繧堤ｵｶ蟇ｾ菴咲ｽｮ謖?ｮ?
219                    seltag.add( selTagBuffer.makeTag() );
220                    seltag.add( optAttr );
221    
222                    seltag = getOption( seltag,value );
223    
224                    return intag.makeTag( row,value ) + HybsSystem.CR +
225                                    seltag.makeTag( row,value ) + HybsSystem.CR +
226                                    SEL1 + name2 + SEL2;
227            }
228    
229            /**
230             * 蛻晄悄蛟､縺碁∈謚樊ｸ医∩縺ｮ 驕ｸ謚櫁い(繧ｪ繝励す繝ｧ繝ｳ)繧探agBuffer 縺ｫ蜿肴丐縺励∪縺吶?
231             * 縺薙?繧ｪ繝励す繝ｧ繝ｳ縺ｯ縲∝ｼ墓焚縺ｮ蛟､繧貞?譛溷?縺ｨ縺吶ｋ繧ｪ繝励す繝ｧ繝ｳ繧ｿ繧ｰ菴懈?縺励?TagBuffer
232             * 縺ｫ蛟､繧定ｨｭ螳壹＠縺ｦ霑斐＠縺ｾ縺吶?
233             *
234             * 縺薙％縺ｧ縺ｯ縲、AA:BBB:CCC:DDD 縺ｨ縺?≧蛟､繧偵?$1,$2,$3,$4 縺ｫ蜑ｲ繧雁ｽ薙※縺ｪ縺翫＠縺ｦ縲?
235             * QUERY繧貞ｮ溯｡後＠縺ｾ縺吶?縺ｾ縺溘?$1 縺ｯ縲∵悽譚･縺ｮ蛟､縺ｨ縺励※縲√Γ繝九Η繝ｼ縺ｮ蛻晄悄蛟､險ｭ螳夂ｭ峨↓
236             * 菴ｿ逕ｨ縺励∪縺吶?荳願ｨ倥?萓九〒縺ｯ縲、AA 縺悟?縺ｧ縲√◎繧御ｻ･髯阪?縲∝ｼ墓焚縺ｫ縺ｪ繧翫∪縺吶?
237             * 縺輔ｉ縺ｫ縲∝?縺ｮ譁?ｭ怜?"AAA:BBB:CCC:DDD"縺ｯ縲?0 縺ｫ蜑ｲ繧雁ｽ薙※繧峨ｌ縺ｾ縺吶?蜑ｲ繧雁ｽ薙※縺後↑縺?
238             * 螟画焚縺ｯ縲?"(繧ｼ繝ｭ譁?ｭ怜?)縺ｨ縺励※縲∵桶繧上ｌ縺ｾ縺吶?
239             * 蜿医?$C縺ｫ縺ｯ閾ｪ蛻??霄ｫ縺ｮ繧ｫ繝ｩ繝?錐繧貞牡繧雁ｽ薙※縺ｾ縺吶?
240             *
241             * @og.rev 3.5.5.7 (2004/05/10) getOption( String value )縺ｮ蟒?ｭ｢繧貞女縺代※縲∵眠隕丈ｽ懈?
242             * @og.rev 3.6.0.6 (2004/10/22) 繧ｷ繝ｼ繧ｱ繝ｳ繧ｹ繧｢繧ｯ繧ｻ繧ｹ讖溯?(seqFlag)繧定ｿｽ蜉?＠縺ｾ縺?
243             * @og.rev 4.0.0.0 (2006/11/15) SelectionFactory 縺ｫ lang 螻樊?繧定ｿｽ蜉?＠縺ｾ縺吶?
244             * @og.rev 4.3.4.0 (2008/12/01) $C蟇ｾ蠢?
245             *
246             * @param       buf  蜿肴丐縺輔○繧亀agBuffer繧ｪ繝悶ず繧ｧ繧ｯ繝?
247             * @param       value 驕ｸ謚槭＆繧後※縺?ｋ蛟､
248             *
249             * @return      繧ｪ繝励す繝ｧ繝ｳ繧ｿ繧ｰ
250             */
251            private TagBuffer getOption( final TagBuffer buf,final String value ) {
252    
253                    // StringFormat format = new StringFormat( query,value );
254                    StringFormat format = new StringFormat( query, value, name ); // 4.3.4.0 (2008/12/01)
255                    String newQuery = format.format();
256                    String newValue = format.getValue();
257    
258                    Selection selection = SelectionFactory.newDBSelection( newQuery, dbid, lang );
259    
260                    if( addNoValue ) {
261                            buf.setBody( Selection.NO_VALUE_OPTION + selection.getOption( newValue, seqFlag ) );
262                    }
263                    else {
264                            buf.setBody( selection.getOption( newValue, seqFlag ) );
265                    }
266    
267                    return buf;
268            }
269    }