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.db.DBUtil;
019    import org.opengion.fukurou.util.ApplicationInfo;
020    import org.opengion.hayabusa.common.HybsSystem;
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.fukurou.util.StringFormat;
025    
026    /**
027     * MULTIQUERY 繝ｬ繝ｳ繝?Λ繝ｼ縺ｯ縲∬｡ｨ遉ｺ繝代Λ繝｡繝ｼ繧ｿ縺ｧ謖?ｮ壹＆繧後◆ SQL譁??螳溯｡檎ｵ先棡繧定｡ｨ遉ｺ縺吶ｋ繧ｯ繝ｩ繧ｹ縺ｧ縺吶?
028     *
029     * 隍?焚莉ｶ縺ｮ繝??繧ｿ縺悟叙蠕励＆繧後◆蝣ｴ蜷医?蜷?ョ繝ｼ繧ｿ縺ｯ縲《pan繧ｿ繧ｰ縺ｧ蝗ｲ繧上ｌ縺ｦ霑斐＆繧後∪縺吶?
030     *  <span>蛟､1</span><span>蛟､2</span><span>蛟､3</span>
031     *
032     * 隨ｬ2繧ｫ繝ｩ繝?ｒ謖?ｮ壹＠縺溷?蜷医?縺昴?蛟､縺ｯ縲《pan繧ｿ繧ｰ縺ｮclass螻樊?縺ｨ縺励※莉伜刈縺輔ｌ縺ｾ縺吶?
033     *
034     * 縺ｾ縺溘?SQL譁??謖?ｮ壹↓縺ｯ縲∝?縺ｮValue 繧偵?$1 縺ｨ縺励※菴ｿ逕ｨ蜿ｯ閭ｽ縺ｧ縺吶?
035     * ($C縺ｧ閾ｪ霄ｫ縺ｮ繧ｫ繝ｩ繝?錐繧貞盾辣ｧ縺吶ｋ縺薙→繧ょ庄閭ｽ縺ｧ縺?
036     *
037     * 繧ｫ繝ｩ繝??陦ｨ遉ｺ縺ｫ蠢?ｦ√↑螻樊?縺ｯ, DBColumn 繧ｪ繝悶ず繧ｧ繧ｯ繝?繧医ｊ蜿悶ｊ蜃ｺ縺励∪縺吶?
038     * 縺薙?繧ｯ繝ｩ繧ｹ縺ｯ縲．BColumn 繧ｪ繝悶ず繧ｧ繧ｯ繝域ｯ弱↓?代▽菴懈?縺輔ｌ縺ｾ縺吶?
039     *
040     * @og.rev 5.1.8.0 (2010/07/01) 譁ｰ隕剰ｿｽ蜉?
041     * @og.group 繝??繧ｿ陦ｨ遉ｺ
042     *
043     * @version  5.0
044     * @author   Hiroki Nakamura
045     * @since    JDK5.0,
046     */
047    public class Renderer_MULTIQUERY extends AbstractRenderer {
048            //* 縺薙?繝励Ο繧ｰ繝ｩ繝??VERSION譁?ｭ怜?繧定ｨｭ螳壹＠縺ｾ縺吶?       {@value} */
049            private static final String VERSION = "5.7.9.0 (2014/08/08)" ;
050    
051            private final String query;
052            private final String dbid;
053            private final String name;
054    
055            /** 繧ｳ繝阪け繧ｷ繝ｧ繝ｳ縺ｫ繧｢繝励Μ繧ｱ繝ｼ繧ｷ繝ｧ繝ｳ諠??繧定ｿｽ險倥☆繧九°縺ｩ縺?°謖?ｮ?*/
056            public static final boolean USE_DB_APPLICATION_INFO  = HybsSystem.sysBool( "USE_DB_APPLICATION_INFO" ) ;
057    
058            private final ApplicationInfo appInfo;
059            private static final String SYSTEM_ID  = HybsSystem.sys( "SYSTEM_ID" ) ;
060    
061            /**
062             * 繝?ヵ繧ｩ繝ｫ繝医さ繝ｳ繧ｹ繝医Λ繧ｯ繧ｿ繝ｼ縲?
063             * 縺薙?繧ｳ繝ｳ繧ｹ繝医Λ繧ｯ繧ｿ繝ｼ縺ｧ縲∝渕譛ｬ繧ｪ繝悶ず繧ｧ繧ｯ繝医ｒ菴懈?縺励∪縺吶?
064             */
065            public Renderer_MULTIQUERY() {
066                    query   = null;
067                    dbid    = null;
068                    appInfo = makeApplicationInfo( null );
069                    name    = null;
070            }
071    
072            /**
073             * 繝?ヵ繧ｩ繝ｫ繝医さ繝ｳ繧ｹ繝医Λ繧ｯ繧ｿ繝ｼ縲?
074             *
075             * @param       clm     DBColumn繧ｪ繝悶ず繧ｧ繧ｯ繝?
076             */
077            private Renderer_MULTIQUERY( final DBColumn clm ) {
078                    query = clm.getRendererParam();
079                    dbid  = clm.getDbid();
080                    appInfo = makeApplicationInfo( clm.getName() );
081                    name  = clm.getName();
082            }
083    
084            /**
085             * 繧｢繧ｯ繧ｻ繧ｹ繝ｭ繧ｰ蜿門ｾ励?轤ｺ,ApplicationInfo繧ｪ繝悶ず繧ｧ繧ｯ繝医ｒ菴懈?縺励∪縺吶?
086             *
087             * @param       name    繧ｪ繝悶ず繧ｧ繧ｯ繝?
088             *
089             * @return      ApplicationInfo繧ｪ繝悶ず繧ｧ繧ｯ繝?
090             */
091            private ApplicationInfo makeApplicationInfo( final String name ) {
092                    ApplicationInfo infoTemp = null;
093    
094                    if( USE_DB_APPLICATION_INFO ) {
095                            infoTemp = new ApplicationInfo();
096                            // 繝ｦ繝ｼ繧ｶ繝ｼID,IP繧｢繝峨Ξ繧ｹ,繝帙せ繝亥錐
097                            infoTemp.setClientInfo( SYSTEM_ID,HybsSystem.HOST_ADRS,HybsSystem.HOST_NAME );
098                            // 逕ｻ髱｢ID,謫堺ｽ?繝励Ο繧ｰ繝ｩ繝?D
099                            infoTemp.setModuleInfo( "Renderer_MULTIQUERY",null,name );
100                    }
101    
102                    return infoTemp ;
103            }
104    
105            /**
106             * 蜷?が繝悶ず繧ｧ繧ｯ繝医°繧芽?蛻??繧､繝ｳ繧ｹ繧ｿ繝ｳ繧ｹ繧定ｿ斐＠縺ｾ縺吶?
107             * 閾ｪ蛻??霄ｫ繧偵く繝｣繝?す繝･縺吶ｋ縺ｮ縺九?譁ｰ縺溘↓菴懈?縺吶ｋ縺ｮ縺九?縲∝推繧ｵ繝悶け繝ｩ繧ｹ縺ｮ螳溯｣?↓
108             * 縺ｾ縺九＆繧後∪縺吶?
109             *
110             * @param       clm     DBColumn繧ｪ繝悶ず繧ｧ繧ｯ繝?
111             *
112             * @return      CellRenderer繧ｪ繝悶ず繧ｧ繧ｯ繝?
113             */
114            public CellRenderer newInstance( final DBColumn clm ) {
115                    return new Renderer_MULTIQUERY( clm );
116            }
117    
118            /**
119             * 繝??繧ｿ縺ｮ陦ｨ遉ｺ逕ｨ譁?ｭ怜?繧定ｿ斐＠縺ｾ縺吶?
120             *
121             * 縺薙％縺ｧ縺ｯ縲、AA:BBB:CCC:DDD 縺ｨ縺?≧蛟､繧偵?$1,$2,$3,$4 縺ｫ蜑ｲ繧雁ｽ薙※縺ｪ縺翫＠縺ｦ縲?
122             * QUERY繧貞ｮ溯｡後＠縺ｾ縺吶?縺ｾ縺溘?$1 縺ｯ縲∵悽譚･縺ｮ蛟､縺ｨ縺励※縲√Γ繝九Η繝ｼ縺ｮ蛻晄悄蛟､險ｭ螳夂ｭ峨↓
123             * 菴ｿ逕ｨ縺励∪縺吶?荳願ｨ倥?萓九〒縺ｯ縲、AA 縺悟?縺ｧ縲√◎繧御ｻ･髯阪?縲∝ｼ墓焚縺ｫ縺ｪ繧翫∪縺吶?
124             * 縺輔ｉ縺ｫ縲∝?縺ｮ譁?ｭ怜?"AAA:BBB:CCC:DDD"縺ｯ縲?0 縺ｫ蜑ｲ繧雁ｽ薙※繧峨ｌ縺ｾ縺吶?蜑ｲ繧雁ｽ薙※縺後↑縺?
125             * 螟画焚縺ｯ縲?"(繧ｼ繝ｭ譁?ｭ怜?)縺ｨ縺励※縲∵桶繧上ｌ縺ｾ縺吶?
126             * 蜿医?$C縺ｫ縺ｯ閾ｪ蛻??霄ｫ縺ｮ繧ｫ繝ｩ繝?錐繧貞牡繧雁ｽ薙※縺ｾ縺吶?
127             *
128             * 隍?焚莉ｶ縺ｮ繝??繧ｿ縺悟叙蠕励＆繧後◆蝣ｴ蜷医?蜷?ョ繝ｼ繧ｿ縺ｯ縲《pan繧ｿ繧ｰ縺ｧ蝗ｲ繧上ｌ縺ｦ霑斐＆繧後∪縺吶?
129             *  <span>蛟､1</span><span>蛟､2</span><span>蛟､3</span>
130             *  隨ｬ2繧ｫ繝ｩ繝?ｒ謖?ｮ壹＠縺溷?蜷医?縺昴?蛟､縺ｯ縲《pan繧ｿ繧ｰ縺ｮclass螻樊?縺ｨ縺励※莉伜刈縺輔ｌ縺ｾ縺?
131             *
132             * @og.rev 5.7.9.0 (2014/08/08) DBUtil.dbExecute 螳溯｡梧凾繧ｨ繝ｩ繝ｼ繧貞屓驕ｿ
133             *
134             * @param   value 蜈･蜉帛?
135             *
136             * @return  繝??繧ｿ縺ｮ陦ｨ遉ｺ逕ｨ譁?ｭ怜?
137             */
138            @Override
139            public String getValue( final String value ) {
140                    StringFormat format = new StringFormat( query, value, name );
141                    String str = format.format();
142    
143                    // 5.7.9.0 (2014/08/08) DBUtil.dbExecute 螳溯｡梧凾繧ｨ繝ｩ繝ｼ繧貞屓驕ｿ
144                    String rtnVal = (value == null) ? "" : value ;          // 譛ｬ譚･縲＿UERY縺ｧ螟画鋤縺吶∋縺阪□縺後?蜈??蛟､繧定ｨｭ螳壹☆繧九?
145                    try {
146                            String[][] rtn = DBUtil.dbExecute( str, null, appInfo, dbid );
147    
148    //                      String val = "";
149                            if( rtn != null && rtn.length > 0 && rtn[0] != null && rtn[0].length > 0 ) {
150                                    boolean isUseClass = false;
151                                    if( rtn[0].length > 1 ) {
152                                            isUseClass = true;
153                                    }
154                                    StringBuilder buf = new StringBuilder();
155                                    for( int i=0; i<rtn.length; i++ ) {
156                                            buf.append( "<span" );
157                                            if( isUseClass ) {
158                                                    buf.append( " class=\"" ).append( rtn[i][1] ).append( "\"" );
159                                            }
160                                            buf.append( ">" ).append( rtn[i][0] ).append( "</span>" );
161                                    }
162    //                              val = buf.toString();
163                                    rtnVal = buf.toString();
164                            }
165                    }
166                    catch( RuntimeException ex ) {
167                            String errMsg = "SQL譁??蜃ｦ逅?↓螟ｱ謨励＠縺ｾ縺励◆縲? + HybsSystem.CR
168                                                                    + "query=" + query + " , inValue=" + value + " , name=" + name
169                                                                    + HybsSystem.CR
170                                                                    + ex.getMessage() ;
171                            System.err.println( errMsg );
172                    }
173    
174    //              return val;
175                    return rtnVal;
176            }
177    }