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.TagBuffer;
020    import org.opengion.fukurou.util.XHTMLTag;
021    import org.opengion.hayabusa.common.HybsSystem;
022    import org.opengion.hayabusa.common.HybsSystemException;
023    import org.opengion.hayabusa.db.AbstractEditor;
024    import org.opengion.hayabusa.db.CellEditor;
025    import org.opengion.hayabusa.db.DBColumn;
026    import org.opengion.hayabusa.db.Selection;
027    import org.opengion.hayabusa.db.SelectionFactory;
028    import org.opengion.fukurou.util.StringFormat;
029    
030    /**
031     * DBRADIO 繧ｨ繝?ぅ繧ｿ繝ｼ縺ｯ縲√き繝ｩ繝??邱ｨ髮?ヱ繝ｩ繝｡繝ｼ繧ｿ繝ｼ縺ｮSQL譁??螳溯｡檎ｵ先棡繧医ｊ縲∝虚逧?↓繝ｩ繧ｸ繧ｪ繝懊ち繝ｳ繧?
032     * 菴懈?縺励※邱ｨ髮?☆繧句?蜷医↓菴ｿ逕ｨ縺吶ｋ繧ｨ繝?ぅ繧ｿ繝ｼ繧ｯ繝ｩ繧ｹ縺ｧ縺吶?
033     *
034     * 邱ｨ髮?ヱ繝ｩ繝｡繝ｼ繧ｿ縺ｫ縺ｯ縲√Λ繧ｸ繧ｪ繝懊ち繝ｳ繧剃ｽ懈?縺吶ｋ縺溘ａ縺ｮ縲ヾQL譁?ｒ險倩ｿｰ縺励∪縺吶?
035     * 縺薙?SQL譁??縲《elect KEY,LABEL from xx ?･?･?･ 縺ｨ縺?≧讒区枚縺ｧ縲゜EY驛ｨ蛻?→LABEL驛ｨ蛻?′
036     * 驕ｸ謚槭＆繧後∪縺吶?蜷?き繝ｩ繝??諢丞袖縺ｯ谺｡縺ｮ繧医≧縺ｫ縺ｪ繧翫∪縺吶?
037     *  隨ｬ?代き繝ｩ繝?蠢??) : 繝ｩ繧ｸ繧ｪ繝懊ち繝ｳ縺ｮ繧ｭ繝ｼ(蛟､)
038     *  隨ｬ?偵き繝ｩ繝?      : 繝ｩ繝吶Ν(謖?ｮ壹＆繧後↑縺??蜷医?縲√Λ繝吶Ν繝ｪ繧ｽ繝ｼ繧ｹ縺ｮ遏ｭ邵ｮ繝ｩ繝吶Ν繧剃ｽｿ逕ｨ縺励∪縺?
039     *  隨ｬ?薙き繝ｩ繝?      : 繧ｯ繝ｩ繧ｹ 縺昴?繧ｪ繝励す繝ｧ繝ｳ縺ｫ濶ｲ縺･縺代↑縺ｩ繧定｡後≧轤ｺ縺ｮ謖?ｮ壹＠縺ｾ縺吶?
040     *                     NULL(縺ｾ縺溘?縲√ぞ繝ｭ譁?ｭ怜?)縺ｮ蝣ｴ蜷医?縲?←逕ｨ縺輔ｌ縺ｾ縺帙ｓ縲?
041     *  隨ｬ?斐き繝ｩ繝?      : 縺薙?蛟､縺ｯ'false'蜿医?'0'縺ｧ縺ゅｋ蝣ｴ蜷医↓縺昴?繝ｩ繧ｸ繧ｪ繝懊ち繝ｳ繧帝∈謚樔ｸ榊庄縺ｫ縺励∪縺吶?
042     *                     NULL(縺ｾ縺溘?縲√ぞ繝ｭ譁?ｭ怜?)縺ｮ蝣ｴ蜷医?縲?∈謚槫庄閭ｽ縺ｫ縺ｪ繧翫∪縺吶?
043     *
044     * 蜷?き繝ｩ繝??蛟､(value蛟､)縺ｫ縲、AA:BBB:CCC:DDD 縺ｨ縺?≧蛟､繧定ｨｭ螳壹〒縺阪∪縺吶?縺薙ｌ縺ｯ縲?
045     * $1,$2,$3,$4 縺ｫ蜑ｲ繧雁ｽ薙※縺ｪ縺翫＠縺ｦ縲＿UERY繧貞ｮ溯｡後＠縺ｾ縺吶?縺ｾ縺溘?$1 縺ｯ縲∵悽譚･縺ｮ蛟､縺ｨ縺励※縲?
046     * 繝｡繝九Η繝ｼ縺ｮ蛻晄悄蛟､險ｭ螳夂ｭ峨↓菴ｿ逕ｨ縺励∪縺吶?荳願ｨ倥?萓九〒縺ｯ縲、AA 縺悟?縺ｧ縲√◎繧御ｻ･髯阪?縲?
047     * 蠑墓焚縺ｫ縺ｪ繧翫∪縺吶?
048     * 蜿医?$C縺ｫ縺ｯ閾ｪ蛻??霄ｫ縺ｮ繧ｫ繝ｩ繝?錐繧貞牡繧雁ｽ薙※縺ｾ縺吶?
049     * 縺薙?讖溯?繧剃ｽｿ逕ｨ縺吶ｌ縺ｰ縲∝虚逧?Γ繝九Η繝ｼ繧定｡後＃縺ｨ縺ｫ譚｡莉ｶ繧貞､峨∴縺ｦ菴懈?縺吶ｋ縺薙→縺?
050     * 蜿ｯ閭ｽ縺ｫ縺ｪ繧翫∪縺吶?
051     * 萓具ｼ嘖elect KEY,LABEL from xx where KUBUN='$2' and CDK='$3'
052     * 縺輔ｉ縺ｫ縲∝?縺ｮ譁?ｭ怜?"AAA:BBB:CCC:DDD"縺ｯ縲?0 縺ｫ蜑ｲ繧雁ｽ薙※繧峨ｌ縺ｾ縺吶?蜑ｲ繧雁ｽ薙※縺後↑縺?
053     * 螟画焚縺ｯ縲?"(繧ｼ繝ｭ譁?ｭ怜?)縺ｨ縺励※縲∵桶繧上ｌ縺ｾ縺吶?
054     *
055     * 縺薙?繧ｨ繝?ぅ繧ｿ縺ｯeventColumn縺ｫ蟇ｾ蠢懊＠縺ｦ縺?∪縺帙ｓ縲?
056     *
057     *  繧ｫ繝ｩ繝??陦ｨ遉ｺ縺ｫ蠢?ｦ√↑螻樊?縺ｯ, DBColumn 繧ｪ繝悶ず繧ｧ繧ｯ繝?繧医ｊ蜿悶ｊ蜃ｺ縺励∪縺吶?
058     * 縺薙?繧ｯ繝ｩ繧ｹ縺ｯ縲．BColumn 繧ｪ繝悶ず繧ｧ繧ｯ繝域ｯ弱↓?代▽菴懈?縺輔ｌ縺ｾ縺吶?
059     *
060     * @og.rev 4.3.3.6 (2008/11/15) 譁ｰ隕丈ｽ懈?
061     * @og.group 繝??繧ｿ邱ｨ髮?
062     *
063     * @version  4.0
064     * @author       Hiroki Nakamura
065     * @since    JDK5.0,
066     */
067    public class Editor_DBRADIO extends AbstractEditor {
068            //* 縺薙?繝励Ο繧ｰ繝ｩ繝??VERSION譁?ｭ怜?繧定ｨｭ螳壹＠縺ｾ縺吶?       {@value} */
069            private static final String VERSION = "4.3.4.0 (2008/12/01)" ;
070    
071            private final String query ;
072            private final String dbid ;
073            private final String lang;
074            private final boolean writable ;
075    
076            /**
077             * 繝?ヵ繧ｩ繝ｫ繝医さ繝ｳ繧ｹ繝医Λ繧ｯ繧ｿ繝ｼ縲?
078             * 縺薙?繧ｳ繝ｳ繧ｹ繝医Λ繧ｯ繧ｿ繝ｼ縺ｧ縲∝渕譛ｬ繧ｪ繝悶ず繧ｧ繧ｯ繝医ｒ菴懈?縺励∪縺吶?
079             *
080             */
081            public Editor_DBRADIO() {
082                    // 4.3.4.4 (2009/01/01)
083    //              super();
084                    query   = null;
085                    dbid    = null;
086                    lang    = null;
087                    writable  = false;
088            }
089    
090            /**
091             * 繧ｳ繝ｳ繧ｹ繝医Λ繧ｯ繧ｿ繝ｼ縲?
092             *
093             * @param       clm     DBColumn繧ｪ繝悶ず繧ｧ繧ｯ繝?
094             */
095            private Editor_DBRADIO( final DBColumn clm ) {
096                    name  = clm.getName();
097                    dbid = clm.getDbid();
098                    lang = clm.getLang();
099    
100                    query = clm.getEditorParam();
101                    if( query == null || query.length() == 0 ) {
102                            String errMsg = "DBRADIO Editor 縺ｧ縺ｯ縲∫ｷｨ髮?ヱ繝ｩ繝｡繝ｼ繧ｿ縺ｯ蠢??縺ｧ縺吶?"
103                                            + " name=[" + name + "]" + HybsSystem.CR ;
104                            throw new HybsSystemException( errMsg );
105                    }
106    
107                    writable = clm.isWritable();
108    
109                    attributes = new Attributes();
110                    attributes.addAttributes( clm.getEditorAttributes() );
111    
112                    attributes.add( "class","RADIO" );
113                    tagBuffer.add( XHTMLTag.inputAttri( attributes ) );
114    
115                    optAttr = attributes.get( "optionAttributes" );
116            }
117    
118            /**
119             * 蜷?が繝悶ず繧ｧ繧ｯ繝医°繧芽?蛻??繧､繝ｳ繧ｹ繧ｿ繝ｳ繧ｹ繧定ｿ斐＠縺ｾ縺吶?
120             * 閾ｪ蛻??霄ｫ繧偵く繝｣繝?す繝･縺吶ｋ縺ｮ縺九?譁ｰ縺溘↓菴懈?縺吶ｋ縺ｮ縺九?縲∝推繧ｵ繝悶け繝ｩ繧ｹ縺ｮ螳溯｣?↓
121             * 縺ｾ縺九＆繧後∪縺吶?
122             *
123             * @param       clm     DBColumn繧ｪ繝悶ず繧ｧ繧ｯ繝?
124             *
125             * @return      CellEditor繧ｪ繝悶ず繧ｧ繧ｯ繝?
126             */
127            public CellEditor newInstance( final DBColumn clm ) {
128                    return new Editor_DBRADIO( clm );
129            }
130    
131            /**
132             * 繝??繧ｿ縺ｮ邱ｨ髮?畑譁?ｭ怜?繧定ｿ斐＠縺ｾ縺吶?
133             *
134             * @og.rev 4.3.4.0 (2008/12/01) $C縺ｮ繧ｫ繝ｩ繝?錐鄂ｮ謠帙∴繧定ｿｽ蜉?
135             *
136             * @param       value 蜈･蜉帛?
137             *
138             * @return      繝??繧ｿ縺ｮ邱ｨ髮?畑譁?ｭ怜?
139             */
140            @Override
141            public String getValue( final String value ) {
142                    // StringFormat format = new StringFormat( query,value);
143                    StringFormat format = new StringFormat( query, value, name ); // 4.3.4.0 (2008/12/01)
144                    String newQuery = format.format();
145                    String newValue = format.getValue();
146                    Selection selection = SelectionFactory.newDBRadioSelection( newQuery,dbid,lang );
147    
148                    final String radio ;
149                    if( writable ) {
150                            radio = selection.getRadio( name,newValue,true );
151                    }
152                    else {
153                            radio = selection.getValueLabel( newValue );
154                    }
155    
156                    TagBuffer tag = new TagBuffer( "pre" );
157                    tag.add( tagBuffer.makeTag() );
158                    tag.add( optAttr );
159                    tag.setBody( radio );
160    
161                    return tag.makeTag();
162            }
163    
164            /**
165             * name螻樊?繧貞､峨∴縺溘?繝??繧ｿ陦ｨ遉ｺ/邱ｨ髮?畑縺ｮHTML譁?ｭ怜?繧剃ｽ懈?縺励∪縺吶?
166             * 繝??繝悶Ν荳翫? name 縺ｫ 陦檎分蜿ｷ繧剃ｻ伜刈縺励※縲∝錐蜑浩陦檎分蜿ｷ 縺ｧ逋ｻ骭ｲ縺吶ｋ繧ｭ繝ｼ繧剃ｽ懈?縺?
167             * 繝ｪ繧ｯ繧ｨ繧ｹ繝域ュ蝣ｱ繧抵ｼ代▽豈弱?繝輔ぅ繝ｼ繝ｫ繝峨〒蜃ｦ逅?〒縺阪∪縺吶?
168             *
169             * @og.rev 4.3.4.0 (2008/12/01) $C縺ｮ繧ｫ繝ｩ繝?錐鄂ｮ謠帙∴繧定ｿｽ蜉?
170             *
171             * @param       row   陦檎分蜿ｷ
172             * @param       value 蜈･蜉帛?
173             *
174             * @return      繝??繧ｿ陦ｨ遉ｺ/邱ｨ髮?畑縺ｮ譁?ｭ怜?
175             */
176            @Override
177            public String getValue( final int row,final String value ) {
178                    // StringFormat format = new StringFormat( query,value);
179                    StringFormat format = new StringFormat( query, value, name ); // 4.3.4.0 (2008/12/01)
180                    String newQuery = format.format();
181                    String newValue = format.getValue();
182                    Selection selection = SelectionFactory.newDBRadioSelection( newQuery,dbid,lang );
183    
184                    final String radio ;
185                    if( writable ) {
186                            radio = selection.getRadio( name + HybsSystem.JOINT_STRING + row,newValue,true );
187                    }
188                    else {
189                            radio = selection.getRadioLabel( newValue );
190                    }
191    
192                    TagBuffer tag = new TagBuffer( "pre" );
193                    tag.add( tagBuffer.makeTag() );
194                    tag.setBody( radio );
195                    tag.add( optAttr );
196    
197                    return tag.makeTag( row,value );
198            }
199    }