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    
021    import org.opengion.hayabusa.db.AbstractRenderer;
022    import org.opengion.hayabusa.db.CellRenderer;
023    import org.opengion.hayabusa.db.DBColumn;
024    import org.opengion.hayabusa.db.Selection;
025    import org.opengion.hayabusa.db.SelectionFactory;
026    import org.opengion.fukurou.util.StringFormat;
027    
028    /**
029     * DBMENU 繝ｬ繝ｳ繝?Λ繝ｼ縺ｯ縲∬｡ｨ遉ｺ繝代Λ繝｡繝ｼ繧ｿ縺ｧ謖?ｮ壹＆繧後◆ SQL譁?ｒ螳溯｡後＠縲?
030     * 繝励Ν繝?え繝ｳ繝｡繝九Η繝ｼ縺ｧ陦ｨ遉ｺ縺吶ｋ蝣ｴ蜷医↓菴ｿ逕ｨ縺吶ｋ繧ｯ繝ｩ繧ｹ縺ｧ縺吶?
031     *
032     *  繧ｫ繝ｩ繝??陦ｨ遉ｺ縺ｫ蠢?ｦ√↑螻樊?縺ｯ, DBColumn 繧ｪ繝悶ず繧ｧ繧ｯ繝?繧医ｊ蜿悶ｊ蜃ｺ縺励∪縺吶?
033     * 縺薙?繧ｯ繝ｩ繧ｹ縺ｯ縲．BColumn 繧ｪ繝悶ず繧ｧ繧ｯ繝域ｯ弱↓?代▽菴懈?縺輔ｌ縺ｾ縺吶?
034     *
035     * @og.rev 3.2.3.0 (2003/06/06) 譁ｰ隕丈ｽ懈?
036     * @og.rev 3.4.0.1 (2003/09/03) ?､?｢讀懃ｴ｢繧偵Μ繧｢繝ｫ繧ｿ繧､繝?↓螟画峩縲?
037     * @og.rev 3.5.4.2 (2003/12/15) 邯呎価蜈?け繝ｩ繧ｹ繧偵?Editor_DBMENU 縺九ｉ AbstractRenderer 縺ｫ螟画峩縲?
038     * @og.group 繝??繧ｿ陦ｨ遉ｺ
039     *
040     * @version  4.0
041     * @author   Kazuhiko Hasegawa
042     * @since    JDK5.0,
043     */
044    public class Renderer_DBMENU extends AbstractRenderer {
045            //* 縺薙?繝励Ο繧ｰ繝ｩ繝??VERSION譁?ｭ怜?繧定ｨｭ螳壹＠縺ｾ縺吶?       {@value} */
046            private static final String VERSION = "5.6.2.3 (2013/03/22)" ;
047    
048            private final String query ;
049            private final String dbid ;
050            private final String lang ;                             // 4.0.0 (2006/11/15)
051            private final String name  ;
052            private final String useSLabel ;                // 5.5.1.0 (2012/04/03)
053            private final String noDisplayVal ;             // 5.6.2.3 (2013/03/22)
054    
055            /**
056             * 繝?ヵ繧ｩ繝ｫ繝医さ繝ｳ繧ｹ繝医Λ繧ｯ繧ｿ繝ｼ縲?
057             * 縺薙?繧ｳ繝ｳ繧ｹ繝医Λ繧ｯ繧ｿ繝ｼ縺ｧ縲∝渕譛ｬ繧ｪ繝悶ず繧ｧ繧ｯ繝医ｒ菴懈?縺励∪縺吶?
058             *
059             * @og.rev 3.4.0.2 (2003/09/05) 繧ｯ繝ｩ繧ｹ蜀?Κ隕狗峩縺励?query 縺ｮ final 蛹?
060             * @og.rev 3.5.4.2 (2003/12/15) name , query 螟画焚繧偵?蛻晄悄險ｭ螳壹＠縺ｦ縺翫″縺ｾ縺吶?
061             * @og.rev 5.6.2.3 (2013/03/22) noDisplayVal 螟画焚蛻晄悄蛹?
062             *
063             */
064            public Renderer_DBMENU() {
065                    query   = null;                 // 3.5.4.2 (2003/12/15)
066                    dbid    = null;
067                    lang    = null;                 // 4.0.0 (2006/11/15)
068                    name    = null;                 // 3.5.4.2 (2003/12/15)
069                    useSLabel        = "auto";              // 5.5.1.0 (2012/04/03)
070                    noDisplayVal = null;            // 5.5.1.0 (2012/04/03)
071            }
072    
073            /**
074             * 繝?ヵ繧ｩ繝ｫ繝医さ繝ｳ繧ｹ繝医Λ繧ｯ繧ｿ繝ｼ縲?
075             *
076             * @og.rev 3.3.1.1 (2003/07/03) CodeSelection 縺ｮ險ｭ螳壹↓縺翫＞縺ｦ縲√ヰ繧ｰ菫ｮ豁｣縲?
077             * @og.rev 3.4.0.1 (2003/09/03) 邯呎価縺ｮ隕ｪ蜈??螟画峩縺ｫ莨ｴ縺?ｮ溯｣??遘ｻ蜍輔?
078             * @og.rev 3.5.4.2 (2003/12/15) 邯呎価蜈?け繝ｩ繧ｹ繧偵?Editor_DBMENU 縺九ｉ AbstractRenderer 縺ｫ螟画峩縲?
079             * @og.rev 3.5.5.9 (2004/06/07) editorParam 螻樊?縺?null 縺ｮ蝣ｴ蜷医?縲√お繝ｩ繝ｼ縺ｨ縺励∪縺吶?
080             * @og.rev 5.6.2.3 (2013/03/22) noDisplayVal 螟画焚霑ｽ蜉?
081             *
082             * @param       clm     DBColumn繧ｪ繝悶ず繧ｧ繧ｯ繝?
083             */
084            private Renderer_DBMENU( final DBColumn clm ) {
085                    name    = clm.getName();
086                    query   = clm.getRendererParam();
087                    dbid    = clm.getDbid();
088                    lang    = clm.getLang();                                // 4.0.0 (2006/11/15)
089                    useSLabel        = clm.getUseSLabel() ;         // 5.5.1.0 (2012/04/03)
090                    noDisplayVal = clm.getNoDisplayVal();   // 5.6.2.3 (2013/03/22)
091    
092                    // 3.5.5.9 (2004/06/07)
093                    if( query == null || query.length() == 0 ) {
094                            String errMsg = "DBMENU Renderer 縺ｧ縺ｯ縲∬｡ｨ遉ｺ繝代Λ繝｡繝ｼ繧ｿ縺ｯ蠢??縺ｧ縺吶?"
095                                            + " name=[" + name + "]" + HybsSystem.CR ;
096                            throw new HybsSystemException( errMsg );
097                    }
098            }
099    
100            /**
101             * 蜷?が繝悶ず繧ｧ繧ｯ繝医°繧芽?蛻??繧､繝ｳ繧ｹ繧ｿ繝ｳ繧ｹ繧定ｿ斐＠縺ｾ縺吶?
102             * 閾ｪ蛻??霄ｫ繧偵く繝｣繝?す繝･縺吶ｋ縺ｮ縺九?譁ｰ縺溘↓菴懈?縺吶ｋ縺ｮ縺九?縲∝推繧ｵ繝悶け繝ｩ繧ｹ縺ｮ螳溯｣?↓
103             * 縺ｾ縺九＆繧後∪縺吶?
104             *
105             * @param       clm     DBColumn繧ｪ繝悶ず繧ｧ繧ｯ繝?
106             *
107             * @return      CellRenderer繧ｪ繝悶ず繧ｧ繧ｯ繝?
108             */
109            public CellRenderer newInstance( final DBColumn clm ) {
110                    return new Renderer_DBMENU( clm );
111            }
112    
113            /**
114             * 繝??繧ｿ縺ｮ陦ｨ遉ｺ逕ｨ譁?ｭ怜?繧定ｿ斐＠縺ｾ縺吶?
115             *
116             * 縺薙％縺ｧ縺ｯ縲、AA:BBB:CCC:DDD 縺ｨ縺?≧蛟､繧偵?$1,$2,$3,$4 縺ｫ蜑ｲ繧雁ｽ薙※縺ｪ縺翫＠縺ｦ縲?
117             * QUERY繧貞ｮ溯｡後＠縺ｾ縺吶?縺ｾ縺溘?$1 縺ｯ縲∵悽譚･縺ｮ蛟､縺ｨ縺励※縲√Γ繝九Η繝ｼ縺ｮ蛻晄悄蛟､險ｭ螳夂ｭ峨↓
118             * 菴ｿ逕ｨ縺励∪縺吶?荳願ｨ倥?萓九〒縺ｯ縲、AA 縺悟?縺ｧ縲√◎繧御ｻ･髯阪?縲∝ｼ墓焚縺ｫ縺ｪ繧翫∪縺吶?
119             * 縺輔ｉ縺ｫ縲∝?縺ｮ譁?ｭ怜?"AAA:BBB:CCC:DDD"縺ｯ縲?0 縺ｫ蜑ｲ繧雁ｽ薙※繧峨ｌ縺ｾ縺吶?蜑ｲ繧雁ｽ薙※縺後↑縺?
120             * 螟画焚縺ｯ縲?"(繧ｼ繝ｭ譁?ｭ怜?)縺ｨ縺励※縲∵桶繧上ｌ縺ｾ縺吶?
121             *
122             * @og.rev 3.4.0.1 (2003/09/03) ?､?｢讀懃ｴ｢繧偵Μ繧｢繝ｫ繧ｿ繧､繝?↓螟画峩縲?
123             * @og.rev 3.4.0.2 (2003/09/05) AAA:BBB:CCC:DDD 縺ｨ縺?≧蛟､繧偵?$1,$2,$3,$4 縺ｫ蜑ｲ繧雁ｽ薙※縺ｾ縺吶?
124             * @og.rev 3.5.4.2 (2003/12/15) makeCodeSelection 繝｡繧ｽ繝?ラ繧?CodeSelection繧ｯ繝ｩ繧ｹ縺ｫ螟画峩縲?
125             * @og.rev 3.5.5.7 (2004/05/10) SelectionFactory 繧剃ｽｿ逕ｨ縺励※縲√が繝悶ず繧ｧ繧ｯ繝井ｽ懈?
126             * @og.rev 4.0.0.0 (2006/11/15) SelectionFactory 縺ｫ lang 螻樊?繧定ｿｽ蜉?＠縺ｾ縺吶?
127             * @og.rev 4.3.4.0 (2008/12/01) $C縺ｮ繧ｫ繝ｩ繝?錐鄂ｮ謠帙∴繧定ｿｽ蜉?
128             * @og.rev 5.5.1.0 (2012/04/03) Slabel蟇ｾ蠢懊?"auto"縺ｯ縲’alse 縺ｫ縺ｪ繧翫∪縺吶?
129             * @og.rev 5.6.2.3 (2013/03/22) noDisplayVal 螟画焚霑ｽ蜉?
130             *
131             * @param   value 蜈･蜉帛?
132             *
133             * @return  繝??繧ｿ縺ｮ陦ｨ遉ｺ逕ｨ譁?ｭ怜?
134             */
135            @Override
136            public String getValue( final String value ) {
137                    // 5.6.2.3 (2013/03/22) noDisplayVal 螟画焚霑ｽ蜉?
138                    if( noDisplayVal != null && noDisplayVal.equalsIgnoreCase( value ) ) { return "" ; }
139    
140                    // StringFormat format = new StringFormat( query,value);
141                    StringFormat format = new StringFormat( query, value, name ); // 4.3.4.0 (2008/12/01)
142                    String newQuery = format.format();
143                    String newValue = format.getValue();
144    
145                    Selection selection = SelectionFactory.newDBSelection( newQuery,dbid,lang );
146    //              final boolean uslbl = !"true".equals(useSLabel) ? false : true; // 5.5.1.0 (2012/04/03)
147                    final boolean uslbl = "true".equalsIgnoreCase( useSLabel );             // 5.5.1.0 (2012/04/03)
148    //              return selection.getValueLabel( newValue );
149                    return selection.getValueLabel( newValue,uslbl );
150            }
151    
152            /**
153             * name螻樊?繧貞､峨∴縺溘?繝??繧ｿ陦ｨ遉ｺ/邱ｨ髮?畑縺ｮHTML譁?ｭ怜?繧剃ｽ懈?縺励∪縺吶?
154             * 繝??繝悶Ν荳翫? name 縺ｫ 陦檎分蜿ｷ繧剃ｻ伜刈縺励※縲∝錐蜑浩陦檎分蜿ｷ 縺ｧ逋ｻ骭ｲ縺吶ｋ繧ｭ繝ｼ繧剃ｽ懈?縺?
155             * 繝ｪ繧ｯ繧ｨ繧ｹ繝域ュ蝣ｱ繧抵ｼ代▽豈弱?繝輔ぅ繝ｼ繝ｫ繝峨〒蜃ｦ逅?〒縺阪∪縺吶?
156             *
157             * @og.rev 4.0.0.0 (2005/11/30) 荳?ｦｧ陦ｨ遉ｺ縺ｧ縺ｯ縲∫洒邵ｮ繝ｩ繝吶Ν繧剃ｽｿ逕ｨ縺励∪縺吶?
158             * @og.rev 4.0.0.0 (2006/11/15) SelectionFactory 縺ｫ lang 螻樊?繧定ｿｽ蜉?＠縺ｾ縺吶?
159             * @og.rev 4.3.4.0 (2008/12/01) $C縺ｮ繧ｫ繝ｩ繝?錐鄂ｮ謠帙∴繧定ｿｽ蜉?
160             * @og.rev 5.5.1.0 (2012/04/03) Slabel蟇ｾ蠢懊?"auto"縺ｯ縲》rue 縺ｫ縺ｪ繧翫∪縺吶?
161             * @og.rev 5.6.2.3 (2013/03/22) noDisplayVal 螟画焚霑ｽ蜉?
162             *
163             * @param   row   陦檎分蜿ｷ
164             * @param   value 蜈･蜉帛?
165             *
166             * @return  繝??繧ｿ陦ｨ遉ｺ/邱ｨ髮?畑縺ｮ譁?ｭ怜?
167             */
168            @Override
169            public String getValue( final int row,final String value ) {
170                    // 5.6.2.3 (2013/03/22) noDisplayVal 螟画焚霑ｽ蜉?
171                    if( noDisplayVal != null && noDisplayVal.equalsIgnoreCase( value ) ) { return "" ; }
172    
173                    // StringFormat format = new StringFormat( query,value);
174                    StringFormat format = new StringFormat( query, value, name ); // 4.3.4.0 (2008/12/01)
175                    String newQuery = format.format();
176                    String newValue = format.getValue();
177    
178                    Selection selection = SelectionFactory.newDBSelection( newQuery,dbid,lang );
179    //              final boolean uslbl = ("auto".equals(useSLabel) || "true".equals(useSLabel) ) ? true : false; // 5.5.1.0 (2012/04/03)
180                    final boolean uslbl = "auto".equalsIgnoreCase( useSLabel ) || "true".equalsIgnoreCase( useSLabel );             // 5.5.1.0 (2012/04/03)
181    //              return selection.getValueLabel( newValue,true );
182                    return selection.getValueLabel( newValue,uslbl );
183            }
184    }