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     * 繧ｫ繝ｩ繝??邱ｨ髮?ヱ繝ｩ繝｡繝ｼ繧ｿ繝ｼ縺ｮ?ｳ?ｱ?ｬ譁??螳溯｡檎ｵ先棡繧医ｊ縲√?繝ｫ繝?え繝ｳ繝｡繝九Η繝ｼ繧剃ｽ懈?縺励※
032     * 邱ｨ髮?☆繧句?蜷医↓菴ｿ逕ｨ縺吶ｋ繧ｨ繝?ぅ繧ｿ繝ｼ繧ｯ繝ｩ繧ｹ縺ｧ縺吶?
033     *
034     * 邱ｨ髮?ヱ繝ｩ繝｡繝ｼ繧ｿ縺ｫ縺ｯ縲√?繝ｫ繝?え繝ｳ繝｡繝九Η繝ｼ繧剃ｽ懈?縺吶ｋ縺溘ａ縺ｮ縲ヾQL譁?ｒ險倩ｿｰ縺励∪縺吶?
035     * 縺薙?SQL譁??縲《elect KEY,LABEL from xx ?･?･?･ 縺ｨ縺?≧讒区枚縺ｧ縲゜EY驛ｨ蛻?→LABEL驛ｨ蛻?′
036     * 驕ｸ謚槭＆繧後∪縺吶?<del>迴ｾ譎らせ縺ｧ縺ｯ縲√◎繧御ｻ･髯阪?讀懃ｴ｢邨先棡縺ｯ辟｡隕悶＆繧後∪縺吶′縲∝ｰ?擂逧?↑諡｡蠑ｵ縺?
037     * 縺ゅｋ縺溘ａ縲∵､懃ｴ｢縺ｯ縲゜EY縺ｨLABEL縺ｮ?偵▽縺ｫ縺励※縺上□縺輔＞縲?/del>
038     * 隨ｬ荳?き繝ｩ繝??繧ｭ繝ｼ縲∫ｬｬ莠後き繝ｩ繝??繝ｩ繝吶Ν縺ｧ縺薙??偵▽縺ｯ蠢??縺ｧ縺吶?隨ｬ荳峨き繝ｩ繝??遏ｭ邵ｮ繝ｩ繝吶Ν縲?
039     * 隨ｬ蝗帙き繝ｩ繝??繧ｰ繝ｫ繝ｼ繝?optgroup)縲∫ｬｬ莠斐き繝ｩ繝??濶ｲ莉倥￠遲峨↓菴ｿ縺?け繝ｩ繧ｹ縺ｧ縺吶?
040     * 遏ｭ邵ｮ繝ｩ繝吶Ν縺瑚ｨｭ螳壹＆繧後※縺?ｋ蝣ｴ蜷医?荳?ｦｧ縺ｧ縺薙?繧ｨ繝?ぅ繧ｿ縺碁←逕ｨ縺輔ｌ繧九→遏ｭ邵ｮ繝ｩ繝吶Ν陦ｨ遉ｺ繧?
041     * 縺励◆荳翫〒繝槭え繧ｹ繧ｪ繝ｼ繝舌?譎ゅ?繝??繝ｫ繝√ャ繝励〒騾壼ｸｸ縺ｮ繝ｩ繝吶Ν繧定｡ｨ遉ｺ縺励∪縺吶?<br/>
042     *
043     * 蜷?き繝ｩ繝??蛟､(value蛟､)縺ｫ縲、AA:BBB:CCC:DDD 縺ｨ縺?≧蛟､繧定ｨｭ螳壹〒縺阪∪縺吶?縺薙ｌ縺ｯ縲?
044     * $1,$2,$3,$4 縺ｫ蜑ｲ繧雁ｽ薙※縺ｪ縺翫＠縺ｦ縲＿UERY繧貞ｮ溯｡後＠縺ｾ縺吶?縺ｾ縺溘?$1 縺ｯ縲∵悽譚･縺ｮ蛟､縺ｨ縺励※縲?
045     * 繝｡繝九Η繝ｼ縺ｮ蛻晄悄蛟､險ｭ螳夂ｭ峨↓菴ｿ逕ｨ縺励∪縺吶?荳願ｨ倥?萓九〒縺ｯ縲、AA 縺悟?縺ｧ縲√◎繧御ｻ･髯阪?縲?
046     * 蠑墓焚縺ｫ縺ｪ繧翫∪縺吶?
047     * 蜿医?$C縺ｫ縺ｯ閾ｪ蛻??霄ｫ縺ｮ繧ｫ繝ｩ繝?錐繧貞牡繧雁ｽ薙※縺ｾ縺吶?
048     * 縺薙?讖溯?繧剃ｽｿ逕ｨ縺吶ｌ縺ｰ縲∝虚逧?Γ繝九Η繝ｼ繧定｡後＃縺ｨ縺ｫ譚｡莉ｶ繧貞､峨∴縺ｦ菴懈?縺吶ｋ縺薙→縺?
049     * 蜿ｯ閭ｽ縺ｫ縺ｪ繧翫∪縺吶?
050     * 萓具ｼ嘖elect KEY,LABEL from xx where KUBUN='$2' and CDK='$3'
051     * 縺輔ｉ縺ｫ縲∝?縺ｮ譁?ｭ怜?"AAA:BBB:CCC:DDD"縺ｯ縲?0 縺ｫ蜑ｲ繧雁ｽ薙※繧峨ｌ縺ｾ縺吶?蜑ｲ繧雁ｽ薙※縺後↑縺?
052     * 螟画焚縺ｯ縲?"(繧ｼ繝ｭ譁?ｭ怜?)縺ｨ縺励※縲∵桶繧上ｌ縺ｾ縺吶?
053     *
054     * 邱ｨ髮?ヱ繝ｩ繝｡繝ｼ繧ｿ縺ｫ"SEQ"縺ｨ險倩ｿｰ縺吶ｋ縺薙→縺ｧ豁｣譁ｹ蜷代↓縺励°驕ｸ縺ｹ縺ｪ縺?す繝ｼ繧ｯ繝｡繝九Η繝ｼ繧貞ｮ溽樟縺ｧ縺阪∪縺吶?
055     * 縺薙ｌ縺ｫ繧医ｊ縲√す繝ｼ繧ｱ繝ｳ繧ｹ縺ｫ繧ｹ繝??繧ｿ繧ｹ繧帝?縺ｫ謖吶￡縺ｦ縺?￥繧医≧縺ｪ縲√?繝ｫ繝?え繝ｳ繝｡繝九Η繝ｼ
056     * 繧剃ｽ懈?縺吶ｋ縺薙→縺悟?譚･縺ｾ縺吶?(騾?↓謌ｻ繧後↑縺?Γ繝九Η繝ｼ)
057     *
058     * 繧ｫ繝ｩ繝??陦ｨ遉ｺ縺ｫ蠢?ｦ√↑螻樊?縺ｯ, DBColumn 繧ｪ繝悶ず繧ｧ繧ｯ繝?繧医ｊ蜿悶ｊ蜃ｺ縺励∪縺吶?
059     * 縺薙?繧ｯ繝ｩ繧ｹ縺ｯ縲．BColumn 繧ｪ繝悶ず繧ｧ繧ｯ繝域ｯ弱↓?代▽菴懈?縺輔ｌ縺ｾ縺吶?
060     *
061     * @og.rev 3.2.3.0 (2003/06/06) 譁ｰ隕丈ｽ懈?
062     * @og.rev 3.4.0.1 (2003/09/03) ?､?｢讀懃ｴ｢繧偵Μ繧｢繝ｫ繧ｿ繧､繝?↓螟画峩縲?
063     * @og.rev 4.3.6.0 (2009/04/01) eventColumn蟇ｾ蠢?
064     * @og.rev 5.4.3.6 (2012/01/19) 繧ｳ繝｡繝ｳ繝亥､画峩
065     * @og.group 繝??繧ｿ邱ｨ髮?
066     *
067     * @version  4.0
068     * @author       Kazuhiko Hasegawa
069     * @since    JDK5.0,
070     */
071    public class Editor_DBMENU extends AbstractEditor {
072            //* 縺薙?繝励Ο繧ｰ繝ｩ繝??VERSION譁?ｭ怜?繧定ｨｭ螳壹＠縺ｾ縺吶?       {@value} */
073            private static final String VERSION = "5.5.1.0 (2012/04/03)" ;
074    
075            private final String query ;
076            private final String dbid ;
077            private final String lang ;                             // 4.0.0 (2006/11/15)
078            private final boolean addNoValue ;              // 3.5.5.7 (2004/05/10)
079            private final boolean seqFlag ;                 // 3.6.0.6 (2004/10/22)
080            private final String useSLabel ;        // 5.5.1.0 (2012/04/03)
081    
082            /**
083             * 繝?ヵ繧ｩ繝ｫ繝医さ繝ｳ繧ｹ繝医Λ繧ｯ繧ｿ繝ｼ縲?
084             * 縺薙?繧ｳ繝ｳ繧ｹ繝医Λ繧ｯ繧ｿ繝ｼ縺ｧ縲∝渕譛ｬ繧ｪ繝悶ず繧ｧ繧ｯ繝医ｒ菴懈?縺励∪縺吶?
085             *
086             * @og.rev 3.4.0.1 (2003/09/03) 蛻晄悄蛟､縺ｧQUERY譁?ｒ繧ｭ繝ｼ繝励☆繧九?
087             * @og.rev 3.6.0.6 (2004/10/22) 繧ｷ繝ｼ繧ｱ繝ｳ繧ｹ繧｢繧ｯ繧ｻ繧ｹ讖溯?(seqFlag)繧定ｿｽ蜉?＠縺ｾ縺?
088             * @og.rev 5.5.1.0 (2012/04/03) Slabel蟇ｾ蠢?
089             *
090             */
091            public Editor_DBMENU() {
092                    // 4.3.4.4 (2009/01/01)
093    //              super();
094                    query   = null;
095                    dbid    = null;
096                    lang    = null;                 // 4.0.0 (2006/11/15)
097                    addNoValue = false;             // 3.5.5.7 (2004/05/10)
098                    seqFlag    = false;             // 3.6.0.6 (2004/10/22)
099                    useSLabel = "auto";             // 5.5.1.0 (2012/04/03)
100            }
101    
102            /**
103             * 繧ｳ繝ｳ繧ｹ繝医Λ繧ｯ繧ｿ繝ｼ縲?
104             *
105             * @og.rev 3.3.1.1 (2003/07/03) name , attributes 螻樊?繧?final 縺ｫ縺吶ｋ縲?
106             * @og.rev 3.4.0.1 (2003/09/03) 邯呎価縺ｮ隕ｪ蜈??螟画峩縺ｫ莨ｴ縺?ｮ溯｣??遘ｻ蜍輔?
107             * @og.rev 3.5.5.7 (2004/05/10) addNoValue 螻樊?繧定ｿｽ蜉?＠縺ｾ縺吶?
108             * @og.rev 3.5.5.9 (2004/06/07) editorParam 螻樊?縺?null 縺ｮ蝣ｴ蜷医?縲√お繝ｩ繝ｼ縺ｨ縺励∪縺吶?
109             * @og.rev 3.5.6.0 (2004/06/18) XHTMLTag 縺ｮ 蜀?Κ驟榊? SELECT_KEY 繧帝國阡ｽ縺励∪縺吶?
110             * @og.rev 3.6.0.6 (2004/10/22) 繧ｷ繝ｼ繧ｱ繝ｳ繧ｹ繧｢繧ｯ繧ｻ繧ｹ讖溯?(seqFlag)繧定ｿｽ蜉?＠縺ｾ縺?
111             * @og.rev 5.1.7.0 (2010/06/01) 蜍慕噪繝励Ν繝?え繝ｳ螳溯｣?ｦ狗峩縺?
112             * @og.rev 5.5.1.0 (2012/04/03) Slabel蟇ｾ蠢?
113             *
114             * @param       clm     DBColumn繧ｪ繝悶ず繧ｧ繧ｯ繝?
115             */
116            private Editor_DBMENU( final DBColumn clm ) {
117            //      super( clm );
118                    name            = clm.getName();
119                    addNoValue      = clm.isAddNoValue() ;          // 3.5.5.7 (2004/05/10)
120                    query           = clm.getEditorParam();
121                    dbid            = clm.getDbid();
122                    lang            = clm.getLang();                        // 4.0.0 (2006/11/15)
123                    seqFlag         = false;                // 3.6.0.6 (2004/10/22)
124    //              eventColumn = clm.getEventColumn(); // 4.3.6.0 (2009/04/01)
125    //              eventURL        = clm.getEventURL();    // 4.3.6.0 (2009/04/01)
126    //              editor          = clm.getEditor();              // 4.3.6.0 (2009/04/01)
127                    useSLabel = clm.getUseSLabel() ;        // 5.5.1.0 (2012/04/03)
128    
129                    // 3.5.5.9 (2004/06/07)
130                    if( query == null || query.length() == 0 ) {
131                            String errMsg = "DBMENU Editor 縺ｧ縺ｯ縲∫ｷｨ髮?ヱ繝ｩ繝｡繝ｼ繧ｿ縺ｯ蠢??縺ｧ縺吶?"
132                                            + " name=[" + name + "]" + HybsSystem.CR ;
133                            throw new HybsSystemException( errMsg );
134                    }
135    
136                    String  disabled = clm.isWritable() ? null : "disabled" ;
137    
138                    attributes = new Attributes();
139                    attributes.set( "disabled"      ,disabled );
140    
141                    attributes.addAttributes( clm.getEditorAttributes() );
142                    optAttr = attributes.get( "optionAttributes" );
143                    tagBuffer.add( XHTMLTag.selectAttri( attributes ) );
144            }
145    
146            /**
147             * 蜷?が繝悶ず繧ｧ繧ｯ繝医°繧芽?蛻??繧､繝ｳ繧ｹ繧ｿ繝ｳ繧ｹ繧定ｿ斐＠縺ｾ縺吶?
148             * 閾ｪ蛻??霄ｫ繧偵く繝｣繝?す繝･縺吶ｋ縺ｮ縺九?譁ｰ縺溘↓菴懈?縺吶ｋ縺ｮ縺九?縲∝推繧ｵ繝悶け繝ｩ繧ｹ縺ｮ螳溯｣?↓
149             * 縺ｾ縺九＆繧後∪縺吶?
150             *
151             * @param       clm     DBColumn繧ｪ繝悶ず繧ｧ繧ｯ繝?
152             *
153             * @return      CellEditor繧ｪ繝悶ず繧ｧ繧ｯ繝?
154             */
155            public CellEditor newInstance( final DBColumn clm ) {
156                    return new Editor_DBMENU( clm );
157            }
158    
159            /**
160             * 繝??繧ｿ縺ｮ邱ｨ髮?畑譁?ｭ怜?繧定ｿ斐＠縺ｾ縺吶?
161             *
162             * 縺薙％縺ｧ縺ｯ縲、AA:BBB:CCC:DDD 縺ｨ縺?≧蛟､繧偵?$1,$2,$3,$4 縺ｫ蜑ｲ繧雁ｽ薙※縺ｪ縺翫＠縺ｦ縲?
163             * QUERY繧貞ｮ溯｡後＠縺ｾ縺吶?縺ｾ縺溘?$1 縺ｯ縲∵悽譚･縺ｮ蛟､縺ｨ縺励※縲√Γ繝九Η繝ｼ縺ｮ蛻晄悄蛟､險ｭ螳夂ｭ峨↓
164             * 菴ｿ逕ｨ縺励∪縺吶?荳願ｨ倥?萓九〒縺ｯ縲、AA 縺悟?縺ｧ縲√◎繧御ｻ･髯阪?縲∝ｼ墓焚縺ｫ縺ｪ繧翫∪縺吶?
165             * 縺輔ｉ縺ｫ縲∝?縺ｮ譁?ｭ怜?"AAA:BBB:CCC:DDD"縺ｯ縲?0 縺ｫ蜑ｲ繧雁ｽ薙※繧峨ｌ縺ｾ縺吶?蜑ｲ繧雁ｽ薙※縺後↑縺?
166             * 螟画焚縺ｯ縲?"(繧ｼ繝ｭ譁?ｭ怜?)縺ｨ縺励※縲∵桶繧上ｌ縺ｾ縺吶?
167             * 蜿医?$C縺ｫ縺ｯ閾ｪ蛻??霄ｫ縺ｮ繧ｫ繝ｩ繝?錐繧貞牡繧雁ｽ薙※縺ｾ縺吶?
168             *
169             * @og.rev 3.4.0.1 (2003/09/03) 繝ｪ繧｢繝ｫ繧ｿ繧､繝?〒蛟､繧剃ｽ懈?縺吶ｋ讒倥↓螟画峩縲?
170             * @og.rev 3.5.5.5 (2004/04/23) 譁ｰ隕上↓ Attributes 繧ｪ繝悶ず繧ｧ繧ｯ繝医ｒ菴懈?縺吶ｋ譁ｹ蠑上ｒ豁｢繧√∪縺吶?
171             * @og.rev 4.3.7.2 (2009/06/15) 螻樊?縺ｧid縺悟?蜉帙＆繧後ｋ蝣ｴ蜷医?縲（d繧貞?蜉帙＠縺ｪ縺?
172             * @og.rev 5.1.3.0 (2010/02/01) 荳?ｦｧ陦ｨ遉ｺ縺ｮ縺ｿ縺ｧ縲√ヤ繝ｼ繝ｫ繝√ャ繝苓｡ｨ遉ｺ繧定｡後≧縲?
173             * @og.rev 5.1.7.0 (2010/06/01) 蜍慕噪繝励Ν繝?え繝ｳ螳溯｣?ｦ狗峩縺?
174             * @og.rev 5.5.1.0 (2012/04/03) Slabel蟇ｾ蠢?
175             *
176             * @param       value 蜈･蜉帛?
177             *
178             * @return      繝??繧ｿ縺ｮ邱ｨ髮?畑譁?ｭ怜?
179             */
180            @Override
181            public String getValue( final String value ) {
182    //              final boolean uslbl = !"true".equals(useSLabel) ? false : true; // 5.5.1.0 (2012/04/03)
183                    final boolean uslbl = "true".equalsIgnoreCase( useSLabel );             // 5.5.1.0 (2012/04/03)
184    
185                    TagBuffer tag = new TagBuffer( "select" );
186                    tag.add( "name"    , name );
187                    if( attributes.get( "id" ) == null || attributes.get( "id" ).length() == 0 ) { // 4.3.7.2 (2009/06/15)
188                            tag.add( "id"      , name ); // 4.3.6.0 (2009/04/01)
189                    }
190                    tag.add( tagBuffer.makeTag() );
191                    tag.add( optAttr );             // 3.5.5.8 (2004/05/20)
192    
193                    // 5.1.3.0 (2010/02/01)
194    //              tag = getOption( tag,value );
195    //              tag = getOption( tag,value,false );
196                    tag = getOption( tag,value,uslbl ); // 5.5.1.0 (2012/04/03)
197    
198                    return tag.makeTag();
199    //              return tag.makeTag() + createEventColumnJS( name, editor, -1, eventURL ); // 4.3.6.0 (2009/04/01)
200            }
201    
202            /**
203             * name螻樊?繧貞､峨∴縺溘?繝??繧ｿ陦ｨ遉ｺ/邱ｨ髮?畑縺ｮHTML譁?ｭ怜?繧剃ｽ懈?縺励∪縺吶?
204             * 繝??繝悶Ν荳翫? name 縺ｫ 陦檎分蜿ｷ繧剃ｻ伜刈縺励※縲∝錐蜑浩陦檎分蜿ｷ 縺ｧ逋ｻ骭ｲ縺吶ｋ繧ｭ繝ｼ繧剃ｽ懈?縺?
205             * 繝ｪ繧ｯ繧ｨ繧ｹ繝域ュ蝣ｱ繧抵ｼ代▽豈弱?繝輔ぅ繝ｼ繝ｫ繝峨〒蜃ｦ逅?〒縺阪∪縺吶?
206             *
207             * 縺薙％縺ｧ縺ｯ縲、AA:BBB:CCC:DDD 縺ｨ縺?≧蛟､繧偵?$1,$2,$3,$4 縺ｫ蜑ｲ繧雁ｽ薙※縺ｪ縺翫＠縺ｦ縲?
208             * QUERY繧貞ｮ溯｡後＠縺ｾ縺吶?縺ｾ縺溘?$1 縺ｯ縲∵悽譚･縺ｮ蛟､縺ｨ縺励※縲√Γ繝九Η繝ｼ縺ｮ蛻晄悄蛟､險ｭ螳夂ｭ峨↓
209             * 菴ｿ逕ｨ縺励∪縺吶?荳願ｨ倥?萓九〒縺ｯ縲、AA 縺悟?縺ｧ縲√◎繧御ｻ･髯阪?縲∝ｼ墓焚縺ｫ縺ｪ繧翫∪縺吶?
210             * 縺輔ｉ縺ｫ縲∝?縺ｮ譁?ｭ怜?"AAA:BBB:CCC:DDD"縺ｯ縲?0 縺ｫ蜑ｲ繧雁ｽ薙※繧峨ｌ縺ｾ縺吶?蜑ｲ繧雁ｽ薙※縺後↑縺?
211             * 螟画焚縺ｯ縲?"(繧ｼ繝ｭ譁?ｭ怜?)縺ｨ縺励※縲∵桶繧上ｌ縺ｾ縺吶?
212             * 蜿医?$C縺ｫ縺ｯ閾ｪ蛻??霄ｫ縺ｮ繧ｫ繝ｩ繝?錐繧貞牡繧雁ｽ薙※縺ｾ縺吶?
213             *
214             * @og.rev 2.0.0.3 (2002/09/26) optionAttributes 螻樊?縺ｫ "$i" 繧剃ｽｿ縺?→縺昴?陦梧焚縺ｫ鄂ｮ縺肴鋤繧区ｩ溯?繧定ｿｽ蜉??
215             * @og.rev 3.4.0.1 (2003/09/03) 繝ｪ繧｢繝ｫ繧ｿ繧､繝?〒蛟､繧剃ｽ懈?縺吶ｋ讒倥↓螟画峩縲?
216             * @og.rev 3.5.5.0 (2004/03/12) 蜷榊燕縺ｨ陦檎分蜿ｷ縺ｮ蛹ｺ蛻?ｊ險伜捷("__")繧偵?HybsSystem.JOINT_STRING  縺ｫ螟画峩縲?
217             * @og.rev 3.5.5.5 (2004/04/23) 譁ｰ隕上↓ Attributes 繧ｪ繝悶ず繧ｧ繧ｯ繝医ｒ菴懈?縺吶ｋ譁ｹ蠑上ｒ豁｢繧√∪縺吶?
218             * @og.rev 4.3.7.2 (2009/06/15) 螻樊?縺ｧid縺悟?蜉帙＆繧後ｋ蝣ｴ蜷医?縲（d繧貞?蜉帙＠縺ｪ縺?
219             * @og.rev 5.1.3.0 (2010/02/01) 荳?ｦｧ陦ｨ遉ｺ縺ｮ縺ｿ縺ｧ縲√ヤ繝ｼ繝ｫ繝√ャ繝苓｡ｨ遉ｺ繧定｡後≧縲?
220             * @og.rev 5.1.7.0 (2010/06/01) 蜍慕噪繝励Ν繝?え繝ｳ螳溯｣?ｦ狗峩縺?
221             * @og.rev 5.5.1.0 (2012/04/03) Slabel蟇ｾ蠢?
222             *
223             * @param       row   陦檎分蜿ｷ
224             * @param       value 蜈･蜉帛?
225             *
226             * @return      繝??繧ｿ陦ｨ遉ｺ/邱ｨ髮?畑縺ｮ譁?ｭ怜?
227             */
228            @Override
229            public String getValue( final int row,final String value ) {
230    //              final boolean uslbl = ("auto".equals(useSLabel) || "true".equals(useSLabel) ) ? true : false; // 5.5.1.0 (2012/04/03)
231                    final boolean uslbl = "auto".equalsIgnoreCase( useSLabel ) || "true".equalsIgnoreCase( useSLabel );             // 5.5.1.0 (2012/04/03)
232    
233                    TagBuffer tag = new TagBuffer( "select" );
234                    String newName = name + HybsSystem.JOINT_STRING + row; // 4.3.6.0 (2009/04/01)
235                    //tag.add( "name"    , name + HybsSystem.JOINT_STRING + row );
236                    tag.add( "name", newName ); // 4.3.6.0 (2009/04/01)
237                    if( attributes.get( "id" ) == null || attributes.get( "id" ).length() == 0 ) { // 4.3.7.2 (2009/06/15)
238                            tag.add( "id"    , newName ); // 4.3.6.0 (2009/04/01)
239                    }
240                    tag.add( tagBuffer.makeTag() );
241                    tag.add( optAttr );             // 3.5.5.8 (2004/05/20)
242    
243                    // 5.1.3.0 (2010/02/01)
244    //              tag = getOption( tag,value );
245    //              tag = getOption( tag,value,true );
246                    tag = getOption( tag,value,uslbl );
247    
248                    return tag.makeTag();
249    //              return tag.makeTag() + createEventColumnJS( name, editor, row, eventURL ); // 4.3.6.0 (2009/04/01)
250            }
251    
252            /**
253             * 蛻晄悄蛟､縺碁∈謚樊ｸ医∩縺ｮ 驕ｸ謚櫁い(繧ｪ繝励す繝ｧ繝ｳ)繧探agBuffer 縺ｫ蜿肴丐縺励∪縺吶?
254             * 縺薙?繧ｪ繝励す繝ｧ繝ｳ縺ｯ縲∝ｼ墓焚縺ｮ蛟､繧貞?譛溷?縺ｨ縺吶ｋ繧ｪ繝励す繝ｧ繝ｳ繧ｿ繧ｰ菴懈?縺励?TagBuffer
255             * 縺ｫ蛟､繧定ｨｭ螳壹＠縺ｦ霑斐＠縺ｾ縺吶?
256             *
257             * 縺薙％縺ｧ縺ｯ縲、AA:BBB:CCC:DDD 縺ｨ縺?≧蛟､繧偵?$1,$2,$3,$4 縺ｫ蜑ｲ繧雁ｽ薙※縺ｪ縺翫＠縺ｦ縲?
258             * QUERY繧貞ｮ溯｡後＠縺ｾ縺吶?縺ｾ縺溘?$1 縺ｯ縲∵悽譚･縺ｮ蛟､縺ｨ縺励※縲√Γ繝九Η繝ｼ縺ｮ蛻晄悄蛟､險ｭ螳夂ｭ峨↓
259             * 菴ｿ逕ｨ縺励∪縺吶?荳願ｨ倥?萓九〒縺ｯ縲、AA 縺悟?縺ｧ縲√◎繧御ｻ･髯阪?縲∝ｼ墓焚縺ｫ縺ｪ繧翫∪縺吶?
260             * 縺輔ｉ縺ｫ縲∝?縺ｮ譁?ｭ怜?"AAA:BBB:CCC:DDD"縺ｯ縲?0 縺ｫ蜑ｲ繧雁ｽ薙※繧峨ｌ縺ｾ縺吶?蜑ｲ繧雁ｽ薙※縺後↑縺?
261             * 螟画焚縺ｯ縲?"(繧ｼ繝ｭ譁?ｭ怜?)縺ｨ縺励※縲∵桶繧上ｌ縺ｾ縺吶?
262             * 蜿医?$C縺ｫ縺ｯ閾ｪ蛻??霄ｫ縺ｮ繧ｫ繝ｩ繝?錐繧貞牡繧雁ｽ薙※縺ｾ縺吶?
263             *
264             * @og.rev 3.5.5.7 (2004/05/10) getOption( String value )縺ｮ蟒?ｭ｢繧貞女縺代※縲∵眠隕丈ｽ懈?
265             * @og.rev 3.6.0.6 (2004/10/22) 繧ｷ繝ｼ繧ｱ繝ｳ繧ｹ繧｢繧ｯ繧ｻ繧ｹ讖溯?(seqFlag)繧定ｿｽ蜉?＠縺ｾ縺?
266             * @og.rev 4.0.0.0 (2006/11/15) SelectionFactory 縺ｫ lang 螻樊?繧定ｿｽ蜉?＠縺ｾ縺吶?
267             * @og.rev 4.3.4.0 (2008/12/01) $C縺ｮ繧ｫ繝ｩ繝?錐鄂ｮ謠帙∴繧定ｿｽ蜉?
268             * @og.rev 5.1.3.0 (2010/02/01) 荳?ｦｧ陦ｨ遉ｺ縺ｮ縺ｿ縺ｧ縲√ヤ繝ｼ繝ｫ繝√ャ繝苓｡ｨ遉ｺ繧定｡後≧縲?
269             *
270             * @param       buf    繧ｿ繧ｰ譁?ｭ怜?縺ｮ繝舌ャ繝輔ぃ繝ｼ
271             * @param       value  驕ｸ謚槭＆繧後※縺?ｋ蛟､
272             * @param   useShortLabel 繝ｩ繝吶Ν(遏ｭ)繧偵?繝ｼ繧ｹ縺ｨ縺励◆繧ｪ繝励す繝ｧ繝ｳ陦ｨ遉ｺ繧定｡後≧縺九←縺?°縲?
273             *
274             * @return      繧ｪ繝励す繝ｧ繝ｳ繧ｿ繧ｰ
275             */
276            private TagBuffer getOption( final TagBuffer buf,final String value,final boolean useShortLabel ) {
277    
278                    // StringFormat format = new StringFormat( query,value);
279                    StringFormat format = new StringFormat( query, value, name ); // 4.3.4.0 (2008/12/01)
280                    String newQuery = format.format();
281                    String newValue = format.getValue();
282    
283                    Selection selection = SelectionFactory.newDBSelection( newQuery, dbid, lang );
284                    boolean useMultiSelect = selection.useMultiSelect();
285                    if( useMultiSelect ) {
286                            buf.add( "onkeydown", "setKeySelect(this);" );
287                    }
288    
289                    if( addNoValue ) {
290                            // 5.1.3.0 (2010/02/01)
291    //                      buf.setBody( Selection.NO_VALUE_OPTION + selection.getOption( newValue, seqFlag ) );
292                            buf.setBody( Selection.NO_VALUE_OPTION + selection.getOption( newValue, seqFlag, useShortLabel ) );
293                    }
294                    else {
295                            // 5.1.3.0 (2010/02/01)
296    //                      buf.setBody( selection.getOption( newValue, seqFlag ) );
297                            buf.setBody( selection.getOption( newValue, seqFlag, useShortLabel ) );
298                    }
299    
300                    return buf;
301            }
302    }