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.TagBuffer;
028    
029    /**
030     * 繧ｫ繝ｩ繝??邱ｨ髮?ヱ繝ｩ繝｡繝ｼ繧ｿ繝ｼ縺ｮ?ｳ?ｱ?ｬ譁??螳溯｡檎ｵ先棡繧医ｊ縲‥atalist繧剃ｽ懈?縺励※
031     * 蜈･蜉帛?陬懊→縺ｪ繧九ョ繝ｼ繧ｿ繝ｪ繧ｹ繝医ｒ螳夂ｾｩ縺吶ｋ邱ｨ髮?畑繧ｨ繝?ぅ繧ｿ繝ｼ繧ｯ繝ｩ繧ｹ縺ｧ縺吶?
032     * datalist 縺ｯ縲？TML5 縺九ｉ謗｡逕ｨ縺輔ｌ縺溘ち繧ｰ縺ｧ縺吶?
033     *
034     * 邱ｨ髮?ヱ繝ｩ繝｡繝ｼ繧ｿ縺ｫ縺ｯ縲‥atalist繧剃ｽ懈?縺吶ｋ縺溘ａ縺ｮ縲ヾQL譁?ｒ險倩ｿｰ縺励∪縺吶?
035     * 縺薙?SQL譁??縲《elect KEY,LABEL from xx ?･?･?･ 縺ｨ縺?≧讒区枚縺ｧ縲゜EY驛ｨ蛻?→LABEL驛ｨ蛻?′
036     * 驕ｸ謚槭＆繧後∪縺吶?
037     * datalist 閾ｪ霄ｫ縺後?HTML5縺九ｉ縺ｮ譁ｰ讖溯?縺ｪ縺ｮ縺ｧ縲∫樟譎らせ縺ｧ縺ｯ縲√％繧御ｻ･荳翫?讖溯?縺ｯ縺ゅｊ縺ｾ縺帙ｓ縲?
038     * 蟆?擂逧?↓縲．BMENU 縺ｪ縺ｩ縺ｨ蜷梧ｧ倥↓縲∫ｬｬ荳峨き繝ｩ繝?ｻ･髯阪ｒ蛻ｩ逕ｨ蜿ｯ閭ｽ縺ｫ縺ｪ繧九→諤昴＞縺ｾ縺吶?縺ｧ縲?
039     * 莉翫?菴ｿ繧上↑縺?〒縺上□縺輔＞縲ゑｼ亥ｰ?擂縺ｮ讖溯?霑ｽ蜉?凾縺ｫ莠呈鋤諤ｧ蝠城｡後ｒ蠑輔″襍ｷ縺薙☆縺九ｂ縺励ｌ縺ｾ縺帙ｓ縺ｮ縺ｧ??
040     *
041     * 蜈･蜉帙ヵ繧｣繝ｼ繝ｫ繝峨→datalist繧ｿ繧ｰ縺ｨ縺ｮ髢｢菫ゆｻ倥?縲√き繝ｩ繝?D縺ｫ縲?繧ｫ繝ｩ繝?D.sel" 縺ｧ邨舌?縺､縺代∪縺吶?
042     *
043     * &lt;input name="繧ｫ繝ｩ繝?D" list="繧ｫ繝ｩ繝?D.sel" /&gt;
044     * &lt;div style="display:none;"&gt;
045     *   &lt;datalist id="繧ｫ繝ｩ繝?D.sel"&gt;
046     *     &lt;option value="KEY1"&gt;LABEL1&lt;/option&gt;
047     *     &lt;option value="KEY2"&gt;LABEL2&lt;/option&gt;
048     *     &lt;option value="KEY3"&gt;LABEL3&lt;/option&gt;
049     *   &lt;/datalist&gt;
050     * &lt;/div&gt;
051     *
052     * div繧ｿ繧ｰ縺ｯ縲？TML5 髱槫ｯｾ蠢懊ヶ繝ｩ繧ｦ繧ｶ繧剃ｽｿ逕ｨ縺励◆蝣ｴ蜷医?datalist 縺ｮ option 縺後◎縺ｮ縺ｾ縺ｾ
053     * 繝?く繧ｹ繝医→縺励※隕九∴縺ｦ縺励∪縺??繧帝∩縺代ｋ縺溘ａ縺ｧ縺吶?
054     *
055     * 荳?ｦｧ陦ｨ蜃ｺ蜉帶凾縺ｮ getValue( int ,String ) 蜃ｦ逅?〒縺ｯ縲ヾelection 繧ｪ繝悶ず繧ｧ繧ｯ繝医?
056     * 繧ｭ繝｣繝?す繝･讖溯?繧貞茜逕ｨ縺励※縲∝酔荳?election 繧ｪ繝悶ず繧ｧ繧ｯ繝医?髢薙?縲‥atalist 縺ｯ縲?
057     * ?大ｺｦ縺励°縲∝?蜉帙＠縺ｪ縺?ｧ倥↓蛻ｶ蠕｡縺励※縺?∪縺吶?縺薙ｌ縺ｫ繧医ｊ縲∝?譛峨?datalist 繧剃ｽｿ逕ｨ縺吶ｋ轤ｺ縲?
058     * HTML縺ｮ蜃ｺ蜉帙ョ繝ｼ繧ｿ驥上ｒ謚代∴繧九％縺ｨ縺悟庄閭ｽ縺ｫ縺ｪ繧翫∪縺吶?
059     * (繧ｭ繝｣繝?す繝･繧貞茜逕ｨ縺励↑縺?→?托ｼ撰ｼ占｡悟?蜉帙☆繧九→?托ｼ撰ｼ仙?縺ｮdatalist繧貞?蜉帙☆繧倶ｺ九↓縺ｪ繧翫∪縺吶?)
060     * (蜷梧ｧ倥?讖溯?繧呈戟縺､ INDBMENU 縺ｧ縺ｯ縲∬｡後＃縺ｨ縺ｫ繝励Ν繝?え繝ｳ繝??繧ｿ繧剃ｽ懈?縺励※縺?∪縺吶?)
061     * 縺溘□縺励?陦悟腰菴阪↓SQL縺ｮ譚｡莉ｶ繧貞､峨∴繧区ｩ溯?(AAA:BBB:CCC:DDD蠑墓焚)縺梧欠螳壹＆繧後◆蝣ｴ蜷医?縲?
062     * 陦後＃縺ｨ縺ｫ蜃ｺ蜉帙＠縺ｾ縺吶?
063     *
064     * 蜷?き繝ｩ繝??蛟､(value蛟､)縺ｫ縲、AA:BBB:CCC:DDD 縺ｨ縺?≧蛟､繧定ｨｭ螳壹〒縺阪∪縺吶?縺薙ｌ縺ｯ縲?
065     * $1,$2,$3,$4 縺ｫ蜑ｲ繧雁ｽ薙※縺ｪ縺翫＠縺ｦ縲＿UERY繧貞ｮ溯｡後＠縺ｾ縺吶?縺ｾ縺溘?$1 縺ｯ縲∵悽譚･縺ｮ蛟､縺ｨ縺励※縲?
066     * 繝｡繝九Η繝ｼ縺ｮ蛻晄悄蛟､險ｭ螳夂ｭ峨↓菴ｿ逕ｨ縺励∪縺吶?荳願ｨ倥?萓九〒縺ｯ縲、AA 縺悟?縺ｧ縲√◎繧御ｻ･髯阪?縲?
067     * 蠑墓焚縺ｫ縺ｪ繧翫∪縺吶?
068     * 蜿医?$C縺ｫ縺ｯ閾ｪ蛻??霄ｫ縺ｮ繧ｫ繝ｩ繝?錐繧貞牡繧雁ｽ薙※縺ｾ縺吶?
069     * 縺薙?讖溯?繧剃ｽｿ逕ｨ縺吶ｌ縺ｰ縲∝虚逧?Γ繝九Η繝ｼ繧定｡後＃縺ｨ縺ｫ譚｡莉ｶ繧貞､峨∴縺ｦ菴懈?縺吶ｋ縺薙→縺?
070     * 蜿ｯ閭ｽ縺ｫ縺ｪ繧翫∪縺吶?
071     * 萓具ｼ嘖elect KEY,LABEL from xx where KUBUN='$2' and CDK='$3'
072     * 縺輔ｉ縺ｫ縲∝?縺ｮ譁?ｭ怜?"AAA:BBB:CCC:DDD"縺ｯ縲?0 縺ｫ蜑ｲ繧雁ｽ薙※繧峨ｌ縺ｾ縺吶?蜑ｲ繧雁ｽ薙※縺後↑縺?
073     * 螟画焚縺ｯ縲?"(繧ｼ繝ｭ譁?ｭ怜?)縺ｨ縺励※縲∵桶繧上ｌ縺ｾ縺吶?
074     *
075     * 繧ｫ繝ｩ繝??陦ｨ遉ｺ縺ｫ蠢?ｦ√↑螻樊?縺ｯ, DBColumn 繧ｪ繝悶ず繧ｧ繧ｯ繝?繧医ｊ蜿悶ｊ蜃ｺ縺励∪縺吶?
076     * 縺薙?繧ｯ繝ｩ繧ｹ縺ｯ縲．BColumn 繧ｪ繝悶ず繧ｧ繧ｯ繝域ｯ弱↓?代▽菴懈?縺輔ｌ縺ｾ縺吶?
077     *
078     * @og.rev 5.7.4.3 (2014/03/28) 譁ｰ隕丈ｽ懈?
079     * @og.group 繝??繧ｿ邱ｨ髮?HTML5)
080     *
081     * @version  4.0
082     * @author       Kazuhiko Hasegawa
083     * @since    JDK5.0,
084     */
085    public class Editor_DATALIST extends AbstractEditor {
086            //* 縺薙?繝励Ο繧ｰ繝ｩ繝??VERSION譁?ｭ怜?繧定ｨｭ螳壹＠縺ｾ縺吶?       {@value} */
087            private static final String VERSION = "5.7.6.2 (2014/05/16)" ;
088    
089            // 5.7.5.0 (2014/04/04) datalist 菴ｿ逕ｨ譎ゅ?縲‥isplay:none 縺ｫ縺励※縲？TML5譛ｪ蟇ｾ蠢懊?繝悶Λ繧ｦ繧ｶ縺ｫ蛯吶∴繧九?
090            private static final String DIV1 = "<div style=\"display:none;\">" ;
091            private static final String DIV2 = "</div>" ;
092    
093            private final String query ;
094            private final String dbid ;
095            private final String lang ;
096    
097            private Selection bkSel= null;  // 5.7.5.0 (2014/04/04) Selection 繧ｪ繝悶ず繧ｧ繧ｯ繝医?繧ｭ繝｣繝?す繝･讖溯?
098    
099            /**
100             * 繝?ヵ繧ｩ繝ｫ繝医さ繝ｳ繧ｹ繝医Λ繧ｯ繧ｿ繝ｼ縲?
101             * 縺薙?繧ｳ繝ｳ繧ｹ繝医Λ繧ｯ繧ｿ繝ｼ縺ｧ縲∝渕譛ｬ繧ｪ繝悶ず繧ｧ繧ｯ繝医ｒ菴懈?縺励∪縺吶?
102             *
103             */
104            public Editor_DATALIST() {
105            //      super();
106                    query   = null;
107                    dbid    = null;
108                    lang    = null;
109            }
110    
111            /**
112             * 繧ｳ繝ｳ繧ｹ繝医Λ繧ｯ繧ｿ繝ｼ縲?
113             *
114             * @param       clm     DBColumn繧ｪ繝悶ず繧ｧ繧ｯ繝?
115             */
116            private Editor_DATALIST( final DBColumn clm ) {
117                    super( clm );
118                    tagBuffer.add( XHTMLTag.inputAttri( attributes ) );
119    
120                    query           = clm.getEditorParam();
121                    dbid            = clm.getDbid();
122                    lang            = clm.getLang();                        // 4.0.0 (2006/11/15)
123    
124                    // 3.5.5.9 (2004/06/07)
125                    if( query == null || query.length() == 0 ) {
126                            String errMsg = "DATALIST Editor 縺ｧ縺ｯ縲∫ｷｨ髮?ヱ繝ｩ繝｡繝ｼ繧ｿ縺ｯ蠢??縺ｧ縺吶?"
127                                            + " name=[" + name + "]" + HybsSystem.CR ;
128                            throw new HybsSystemException( errMsg );
129                    }
130            }
131    
132            /**
133             * 蜷?が繝悶ず繧ｧ繧ｯ繝医°繧芽?蛻??繧､繝ｳ繧ｹ繧ｿ繝ｳ繧ｹ繧定ｿ斐＠縺ｾ縺吶?
134             * 閾ｪ蛻??霄ｫ繧偵く繝｣繝?す繝･縺吶ｋ縺ｮ縺九?譁ｰ縺溘↓菴懈?縺吶ｋ縺ｮ縺九?縲∝推繧ｵ繝悶け繝ｩ繧ｹ縺ｮ螳溯｣?↓
135             * 縺ｾ縺九＆繧後∪縺吶?
136             *
137             * @param       clm     DBColumn繧ｪ繝悶ず繧ｧ繧ｯ繝?
138             *
139             * @return      CellEditor繧ｪ繝悶ず繧ｧ繧ｯ繝?
140             */
141            public CellEditor newInstance( final DBColumn clm ) {
142                    return new Editor_DATALIST( clm );
143            }
144    
145            /**
146             * 繝??繧ｿ縺ｮ邱ｨ髮?畑譁?ｭ怜?繧定ｿ斐＠縺ｾ縺吶?
147             *
148             * 縺薙％縺ｧ縺ｯ縲、AA:BBB:CCC:DDD 縺ｨ縺?≧蛟､繧偵?$1,$2,$3,$4 縺ｫ蜑ｲ繧雁ｽ薙※縺ｪ縺翫＠縺ｦ縲?
149             * QUERY繧貞ｮ溯｡後＠縺ｾ縺吶?縺ｾ縺溘?$1 縺ｯ縲∵悽譚･縺ｮ蛟､縺ｨ縺励※縲√Γ繝九Η繝ｼ縺ｮ蛻晄悄蛟､險ｭ螳夂ｭ峨↓
150             * 菴ｿ逕ｨ縺励∪縺吶?荳願ｨ倥?萓九〒縺ｯ縲、AA 縺悟?縺ｧ縲√◎繧御ｻ･髯阪?縲∝ｼ墓焚縺ｫ縺ｪ繧翫∪縺吶?
151             * 縺輔ｉ縺ｫ縲∝?縺ｮ譁?ｭ怜?"AAA:BBB:CCC:DDD"縺ｯ縲?0 縺ｫ蜑ｲ繧雁ｽ薙※繧峨ｌ縺ｾ縺吶?蜑ｲ繧雁ｽ薙※縺後↑縺?
152             * 螟画焚縺ｯ縲?"(繧ｼ繝ｭ譁?ｭ怜?)縺ｨ縺励※縲∵桶繧上ｌ縺ｾ縺吶?
153             * 蜿医?$C縺ｫ縺ｯ閾ｪ蛻??霄ｫ縺ｮ繧ｫ繝ｩ繝?錐繧貞牡繧雁ｽ薙※縺ｾ縺吶?
154             *
155             * @og.rev 5.7.5.0 (2014/04/04) datalist 菴ｿ逕ｨ譎ゅ?縲‥isplay:none 縺ｫ縺励※縲？TML5譛ｪ蟇ｾ蠢懊?繝悶Λ繧ｦ繧ｶ縺ｫ蛯吶∴繧九?
156             * @og.rev 5.7.6.2 (2014/05/16) list螻樊?縺ｨid螻樊?縺ｮ邨舌?縺､縺阪ｒ縲］ame+".sel" 縺ｫ螟画峩
157             *
158             * @param       value 蜈･蜉帛?
159             *
160             * @return      繝??繧ｿ縺ｮ邱ｨ髮?畑譁?ｭ怜?
161             */
162            @Override
163            public String getValue( final String value ) {
164                    // input 繧ｿ繧ｰ縺ｮ菴懈?
165                    TagBuffer intag = new TagBuffer( "input" );
166                    intag.add( "name"    , name );
167                    if( attributes.get( "id" ) == null || attributes.get( "id" ).length() == 0 ) {
168                            intag.add( "id"      , name );
169                    }
170    //              intag.add( "list"    , "dl_" + name );          // datalist繧ｿ繧ｰ縺ｨ縺ｮ髢｢菫ゆｻ倥￠繧九◆繧√?繧ｭ繝ｼ繝ｯ繝ｼ繝?
171                    intag.add( "list"    , name + ".sel" );         // datalist繧ｿ繧ｰ縺ｨ縺ｮ髢｢菫ゆｻ倥￠繧九◆繧√?繧ｭ繝ｼ繝ｯ繝ｼ繝?
172                    intag.add( "value"   , value );
173                    intag.add( "size"    , size1 );
174                    intag.add( tagBuffer.makeTag() );
175                    intag.add( optAttr );
176    
177                    // datalist 繧ｿ繧ｰ縺ｮ菴懈?
178                    TagBuffer dltag = new TagBuffer( "datalist" );
179    //              dltag.add( "id"    , "dl_" + name );                    // input繧ｿ繧ｰ縺ｨ縺ｮ髢｢菫ゆｻ倥￠繧九◆繧√?繧ｭ繝ｼ繝ｯ繝ｼ繝?
180                    dltag.add( "id"    , name + ".sel" );                   // input繧ｿ繧ｰ縺ｨ縺ｮ髢｢菫ゆｻ倥￠繧九◆繧√?繧ｭ繝ｼ繝ｯ繝ｼ繝?
181    
182                    dltag = getOption( dltag,value,false );                 // 繧ｭ繝｣繝?す繝･縺ｯ菴ｿ逕ｨ縺励↑縺??
183    
184                    // display:none 縺ｯ縲‥atalist 縺ｮ option縺ｮBODY驛ｨ縺後?HTML5 莉･螟悶〒縺ｯ陦ｨ遉ｺ縺輔ｌ縺ｦ縺励∪縺??繧帝亟縺舌◆繧√?
185                    return intag.makeTag()  + HybsSystem.CR +
186                                    DIV1 + dltag.makeTag() + DIV2 + HybsSystem.CR;
187            }
188    
189            /**
190             * name螻樊?繧貞､峨∴縺溘?繝??繧ｿ陦ｨ遉ｺ/邱ｨ髮?畑縺ｮHTML譁?ｭ怜?繧剃ｽ懈?縺励∪縺吶?
191             * 繝??繝悶Ν荳翫? name 縺ｫ 陦檎分蜿ｷ繧剃ｻ伜刈縺励※縲∝錐蜑浩陦檎分蜿ｷ 縺ｧ逋ｻ骭ｲ縺吶ｋ繧ｭ繝ｼ繧剃ｽ懈?縺?
192             * 繝ｪ繧ｯ繧ｨ繧ｹ繝域ュ蝣ｱ繧抵ｼ代▽豈弱?繝輔ぅ繝ｼ繝ｫ繝峨〒蜃ｦ逅?〒縺阪∪縺吶?
193             *
194             * 縺薙％縺ｧ縺ｯ縲、AA:BBB:CCC:DDD 縺ｨ縺?≧蛟､繧偵?$1,$2,$3,$4 縺ｫ蜑ｲ繧雁ｽ薙※縺ｪ縺翫＠縺ｦ縲?
195             * QUERY繧貞ｮ溯｡後＠縺ｾ縺吶?縺ｾ縺溘?$1 縺ｯ縲∵悽譚･縺ｮ蛟､縺ｨ縺励※縲√Γ繝九Η繝ｼ縺ｮ蛻晄悄蛟､險ｭ螳夂ｭ峨↓
196             * 菴ｿ逕ｨ縺励∪縺吶?荳願ｨ倥?萓九〒縺ｯ縲、AA 縺悟?縺ｧ縲√◎繧御ｻ･髯阪?縲∝ｼ墓焚縺ｫ縺ｪ繧翫∪縺吶?
197             * 縺輔ｉ縺ｫ縲∝?縺ｮ譁?ｭ怜?"AAA:BBB:CCC:DDD"縺ｯ縲?0 縺ｫ蜑ｲ繧雁ｽ薙※繧峨ｌ縺ｾ縺吶?蜑ｲ繧雁ｽ薙※縺後↑縺?
198             * 螟画焚縺ｯ縲?"(繧ｼ繝ｭ譁?ｭ怜?)縺ｨ縺励※縲∵桶繧上ｌ縺ｾ縺吶?
199             * 蜿医?$C縺ｫ縺ｯ閾ｪ蛻??霄ｫ縺ｮ繧ｫ繝ｩ繝?錐繧貞牡繧雁ｽ薙※縺ｾ縺吶?
200             *
201             * @og.rev 5.7.5.0 (2014/04/04) datalist 菴ｿ逕ｨ譎ゅ?縲‥isplay:none 縺ｫ縺励※縲？TML5譛ｪ蟇ｾ蠢懊?繝悶Λ繧ｦ繧ｶ縺ｫ蛯吶∴繧九?
202             * @og.rev 5.7.5.0 (2014/04/04) Selection 繧ｪ繝悶ず繧ｧ繧ｯ繝医?繧ｭ繝｣繝?す繝･讖溯?
203             * @og.rev 5.7.6.2 (2014/05/16) list螻樊?縺ｨid螻樊?縺ｮ邨舌?縺､縺阪ｒ縲］ame+".sel" 縺ｫ螟画峩
204             *
205             * @param       row   陦檎分蜿ｷ
206             * @param       value 蜈･蜉帛?
207             *
208             * @return      繝??繧ｿ陦ｨ遉ｺ/邱ｨ髮?畑縺ｮ譁?ｭ怜?
209             */
210            @Override
211            public String getValue( final int row,final String value ) {
212                    String name2 = name + HybsSystem.JOINT_STRING + row ;
213    
214                    // 5.7.5.0 (2014/04/04) Selection 繧ｪ繝悶ず繧ｧ繧ｯ繝医?繧ｭ繝｣繝?す繝･讖溯? (true:菴ｿ逕ｨ蜿ｯ閭ｽ)
215                    boolean useSelCache = value != null && value.indexOf( ':' ) < 0 ;
216    
217                    String listId = useSelCache ? name : name2;             // 繧ｭ繝｣繝?す繝･繧剃ｽｿ逕ｨ縺吶ｋ蝣ｴ蜷医?縲∝?騾壹? name 繧剃ｽｿ縺??
218    
219                    // input 繧ｿ繧ｰ縺ｮ菴懈?
220                    TagBuffer intag = new TagBuffer( "input" );
221                    intag.add( "name"    , name2 );
222                    if( attributes.get( "id" ) == null || attributes.get( "id" ).length() == 0 ) {
223                            intag.add( "id"      , name2 );
224                    }
225    //              intag.add( "list"    , "dl_" + listId );                // datalist繧ｿ繧ｰ縺ｨ縺ｮ髢｢菫ゆｻ倥￠繧九◆繧√?繧ｭ繝ｼ繝ｯ繝ｼ繝?
226                    intag.add( "list"    , listId + ".sel" );               // datalist繧ｿ繧ｰ縺ｨ縺ｮ髢｢菫ゆｻ倥￠繧九◆繧√?繧ｭ繝ｼ繝ｯ繝ｼ繝?
227                    intag.add( "value"   , value );
228                    intag.add( "size"    , size2 );
229                    intag.add( tagBuffer.makeTag() );
230                    intag.add( optAttr );
231    
232                    // datalist 繧ｿ繧ｰ縺ｮ菴懈?
233                    TagBuffer dltag = new TagBuffer( "datalist" );
234    //              dltag.add( "id"    , "dl_" + listId );                  // input繧ｿ繧ｰ縺ｨ縺ｮ髢｢菫ゆｻ倥￠繧九◆繧√?繧ｭ繝ｼ繝ｯ繝ｼ繝?
235                    dltag.add( "id"    , listId + ".sel" );                 // input繧ｿ繧ｰ縺ｨ縺ｮ髢｢菫ゆｻ倥￠繧九◆繧√?繧ｭ繝ｼ繝ｯ繝ｼ繝?
236    
237                    dltag = getOption( dltag,value,useSelCache );
238    
239                    // 繧ｭ繝｣繝?す繝･縺悟柑縺上→縲“etOption 縺ｮ謌ｻ繧雁?縺ｯ縲］ull 縺ｫ縺ｪ繧九?
240                    if( dltag != null ) {
241                            return intag.makeTag( row,value ) + HybsSystem.CR +
242                                            DIV1 + dltag.makeTag( row,value ) + DIV2 + HybsSystem.CR ;
243                    }
244                    else {
245                            return intag.makeTag( row,value ) + HybsSystem.CR ;
246                    }
247            }
248    
249            /**
250             * 蛻晄悄蛟､縺碁∈謚樊ｸ医∩縺ｮ 驕ｸ謚櫁い(繧ｪ繝励す繝ｧ繝ｳ)繧探agBuffer 縺ｫ蜿肴丐縺励∪縺吶?
251             * 縺薙?繧ｪ繝励す繝ｧ繝ｳ縺ｯ縲∝ｼ墓焚縺ｮ蛟､繧貞?譛溷?縺ｨ縺吶ｋ繧ｪ繝励す繝ｧ繝ｳ繧ｿ繧ｰ菴懈?縺励?TagBuffer
252             * 縺ｫ蛟､繧定ｨｭ螳壹＠縺ｦ霑斐＠縺ｾ縺吶?
253             *
254             * 隨ｬ?灘ｼ墓焚縺ｯ縲ヾelection 繧ｪ繝悶ず繧ｧ繧ｯ繝医?繧ｭ繝｣繝?す繝･讖溯?繧剃ｽｿ逕ｨ縺吶ｋ縺九←縺?°謖?ｮ壹＠縺ｾ縺吶?
255             * true 縺ｧ縲∽ｽｿ逕ｨ縺吶ｋ莠九ｒ蜑肴署縺ｫ縲√メ繧ｧ繝?け繧定｡後＞縺ｾ縺吶?
256             * DBMENU 縺ｪ縺ｩ縲∽ｻ悶?繝｡繧ｽ繝?ラ縺ｧ縺ｯ縲√Λ繝吶Ν(遏ｭ)縺ｮ菴ｿ逕ｨ譛臥┌縺ｨ縺励※菴ｿ逕ｨ縺励※縺?ｋ縺溘ａ縲∫焚縺ｪ繧翫∪縺吶?
257             *
258             * 縺薙％縺ｧ縺ｯ縲、AA:BBB:CCC:DDD 縺ｨ縺?≧蛟､繧偵?$1,$2,$3,$4 縺ｫ蜑ｲ繧雁ｽ薙※縺ｪ縺翫＠縺ｦ縲?
259             * QUERY繧貞ｮ溯｡後＠縺ｾ縺吶?縺ｾ縺溘?$1 縺ｯ縲∵悽譚･縺ｮ蛟､縺ｨ縺励※縲√Γ繝九Η繝ｼ縺ｮ蛻晄悄蛟､險ｭ螳夂ｭ峨↓
260             * 菴ｿ逕ｨ縺励∪縺吶?荳願ｨ倥?萓九〒縺ｯ縲、AA 縺悟?縺ｧ縲√◎繧御ｻ･髯阪?縲∝ｼ墓焚縺ｫ縺ｪ繧翫∪縺吶?
261             * 縺輔ｉ縺ｫ縲∝?縺ｮ譁?ｭ怜?"AAA:BBB:CCC:DDD"縺ｯ縲?0 縺ｫ蜑ｲ繧雁ｽ薙※繧峨ｌ縺ｾ縺吶?蜑ｲ繧雁ｽ薙※縺後↑縺?
262             * 螟画焚縺ｯ縲?"(繧ｼ繝ｭ譁?ｭ怜?)縺ｨ縺励※縲∵桶繧上ｌ縺ｾ縺吶?
263             * 蜿医?$C縺ｫ縺ｯ閾ｪ蛻??霄ｫ縺ｮ繧ｫ繝ｩ繝?錐繧貞牡繧雁ｽ薙※縺ｾ縺吶?
264             *
265             * @param       buf    繧ｿ繧ｰ譁?ｭ怜?縺ｮ繝舌ャ繝輔ぃ繝ｼ
266             * @param       value  驕ｸ謚槭＆繧後※縺?ｋ蛟､
267             * @param   useSelCache Selection 繧ｪ繝悶ず繧ｧ繧ｯ繝医?繧ｭ繝｣繝?す繝･讖溯?繧剃ｽｿ逕ｨ縺吶ｋ縺九←縺?°縲?
268             *
269             * @return      繧ｪ繝励す繝ｧ繝ｳ繧ｿ繧ｰ
270             */
271            private TagBuffer getOption( final TagBuffer buf,final String value,final boolean useSelCache ) {
272    
273                    StringFormat format = new StringFormat( query, value, name );
274                    String newQuery = format.format();
275                    String newValue = format.getValue();
276    
277                    Selection selection = SelectionFactory.newDBSelection( newQuery, dbid, lang );
278    
279                    if( useSelCache ) {
280                            if( selection == bkSel ) { return null; }
281                            bkSel = selection ;
282                    }
283    
284                    buf.setBody( selection.getOption( newValue, false ) );
285    
286                    return buf;
287            }
288    }