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.hayabusa.db;
017    
018    import java.util.LinkedHashMap;
019    import java.util.Map;
020    
021    import org.opengion.fukurou.db.DBUtil;
022    import org.opengion.fukurou.util.ApplicationInfo;
023    import org.opengion.hayabusa.common.HybsSystem;
024    import org.opengion.hayabusa.resource.ResourceFactory;
025    import org.opengion.hayabusa.resource.ResourceManager;
026    
027    /**
028     * 繝??繧ｿ縺ｮ繧ｳ繝ｼ繝画ュ蝣ｱ繧貞叙繧頑桶縺?け繝ｩ繧ｹ縺ｧ縺吶?
029     *
030     * 繧ｳ繝ｼ繝峨?繧ｭ繝ｼ縺ｨ繝ｩ繝吶Ν縺ｮ諠??縺九ｉ縲？TML縺ｮ繝｡繝九Η繝ｼ繧?Μ繧ｹ繝医ｒ菴懈?縺吶ｋ縺溘ａ縺ｮ 繧ｪ繝励す繝ｧ繝ｳ
031     * 繧ｿ繧ｰ繧剃ｽ懈?縺励◆繧翫?荳弱∴繧峨ｌ縺溘く繝ｼ繧偵ｂ縺ｨ縺ｫ縲√メ繧ｧ繝?け貂医∩縺ｮ繧ｪ繝励す繝ｧ繝ｳ繧ｿ繧ｰ繧剃ｽ懈?縺励◆繧?
032     * 縺励∪縺吶?
033     * QUERY縺ｮ縺昴ｌ縺槭ｌ縺ｮ繧ｫ繝ｩ繝??縲∽ｻ･荳九?諢丞袖繧呈戟縺｡縺ｾ縺吶?
034     *  隨ｬ?代き繝ｩ繝?蠢??) : 繝ｩ繧ｸ繧ｪ繝懊ち繝ｳ縺ｮ繧ｭ繝ｼ(蛟､)
035     *  隨ｬ?偵き繝ｩ繝?      : 繝ｩ繝吶Ν(謖?ｮ壹＆繧後↑縺??蜷医?縲√Λ繝吶Ν繝ｪ繧ｽ繝ｼ繧ｹ縺ｮ遏ｭ邵ｮ繝ｩ繝吶Ν繧剃ｽｿ逕ｨ縺励∪縺?
036     *  隨ｬ?薙き繝ｩ繝?      : 繧ｯ繝ｩ繧ｹ 縺昴?繧ｪ繝励す繝ｧ繝ｳ縺ｫ濶ｲ縺･縺代↑縺ｩ繧定｡後≧轤ｺ縺ｮ謖?ｮ壹＠縺ｾ縺吶?
037     *                     NULL(縺ｾ縺溘?縲√ぞ繝ｭ譁?ｭ怜?)縺ｮ蝣ｴ蜷医?縲?←逕ｨ縺輔ｌ縺ｾ縺帙ｓ縲?
038     *  隨ｬ?斐き繝ｩ繝?      : 縺薙?蛟､縺ｯ'false'蜿医?'0'縺ｧ縺ゅｋ蝣ｴ蜷医↓縺昴?繝ｩ繧ｸ繧ｪ繝懊ち繝ｳ繧帝∈謚樔ｸ榊庄縺ｫ縺励∪縺吶?
039     *                     NULL(縺ｾ縺溘?縲√ぞ繝ｭ譁?ｭ怜?)縺ｮ蝣ｴ蜷医?縲?∈謚槫庄閭ｽ縺ｫ縺ｪ繧翫∪縺吶?
040     *
041     * @og.group 驕ｸ謚槭ョ繝ｼ繧ｿ蛻ｶ蠕｡
042     *
043     * @version  4.0
044     * @author   Hiroki Nakamura
045     * @since    JDK5.0,
046     */
047    public class Selection_DBRADIO implements Selection {
048            private final long              DB_CACHE_TIME                   = (long)HybsSystem.sysInt( "DB_CACHE_TIME" ) ;
049    
050            private final boolean   isClass ;                       // 繧ｯ繧ｨ繝ｪ縺ｧ繧ｯ繝ｩ繧ｹ螻樊?縺梧欠螳壹＆繧後※縺?ｋ縺九←縺?°
051            private final boolean   isDisable ;                     // 繧ｯ繧ｨ繝ｪ縺ｧ驕ｸ謚樔ｸ榊庄螻樊?縺梧欠螳壹＆繧後※縺?ｋ縺九←縺?°
052            private final long              createTime ;            // 繧ｭ繝｣繝?す繝･縺ｮ遐ｴ譽?ち繧､繝溘Φ繧ｰ繧定ｨ医ｋ縺溘ａ縺ｮ菴懈?譎る俣
053    
054            private final Map<String,Integer> map  ;
055    
056    //      private final String[]  value   ;               // 蛟､           // 5.1.9.0 (2010/08/01) 蟒?ｭ｢
057            private final String[]  label   ;               // 繝ｩ繝吶Ν
058            private final String[]  cls     ;               // 繧ｯ繝ｩ繧ｹ
059            private final String[]  disabled ;              // 繝ｩ繧ｸ繧ｪ蜊倅ｽ阪?disable
060    
061            private static final int VAL            = 0;
062            private static final int LBL            = 1;
063            private static final int CLS            = 2;
064            private static final int DISABLED       = 3;
065    
066            private static final ApplicationInfo appInfo;
067            static {
068                    /** 繧ｳ繝阪け繧ｷ繝ｧ繝ｳ縺ｫ繧｢繝励Μ繧ｱ繝ｼ繧ｷ繝ｧ繝ｳ諠??繧定ｿｽ險倥☆繧九°縺ｩ縺?°謖?ｮ?*/
069                    boolean USE_DB_APPLICATION_INFO  = HybsSystem.sysBool( "USE_DB_APPLICATION_INFO" ) ;
070    
071                    // 3.8.7.0 (2006/12/15) 繧｢繧ｯ繧ｻ繧ｹ繝ｭ繧ｰ蜿門ｾ励?轤ｺ,ApplicationInfo繧ｪ繝悶ず繧ｧ繧ｯ繝医ｒ險ｭ螳?
072                    if( USE_DB_APPLICATION_INFO ) {
073                            String SYSTEM_ID = HybsSystem.sys( "SYSTEM_ID" );
074                            appInfo = new ApplicationInfo();
075                            // 繝ｦ繝ｼ繧ｶ繝ｼID,IP繧｢繝峨Ξ繧ｹ,繝帙せ繝亥錐
076                            appInfo.setClientInfo( SYSTEM_ID,HybsSystem.HOST_ADRS,HybsSystem.HOST_NAME );
077                            // 逕ｻ髱｢ID,謫堺ｽ?繝励Ο繧ｰ繝ｩ繝?D
078                            appInfo.setModuleInfo( "Selection_DBRADIO",null,null );
079                    }
080                    else {
081                            appInfo = null;
082                    }
083            }
084    
085            /**
086             * 繧ｳ繝ｳ繧ｹ繝医Λ繧ｯ繧ｿ繝ｼ
087             *
088             * ?､?｢讀懃ｴ｢逕ｨ縺ｮ?ｳ?ｱ?ｬ譁?ｒ荳弱∴縺ｦ縲∝?譛溷喧縺励∪縺吶?
089             * SQL譁??縲゜EY,SNAME縺ｧ縲ヾNAME縺瑚ｨｭ螳壹＆繧後※縺ｪ縺??蜷医?縲´NAME繧剃ｽｿ逕ｨ縺励∪縺吶?
090             * LNAME 縺ｯ縲??蟶ｸ縺ｮ蛟､繧定ｿ斐☆蝣ｴ蜷医↓縲ヾNAME 縺ｯ縲∽ｸ?ｦｧ陦ｨ遉ｺ縺ｮ蛟､繧定ｿ斐☆蝣ｴ蜷医↓菴ｿ逕ｨ縺励∪縺吶?
091             * 迚ｹ蛻･縺ｫ縲゜EY 縺ｮ縺ｿ縺ｮ蝣ｴ蜷医?縲〕ang 縺ｫ蝓ｺ縺･縺?ResourceManager 縺九ｉ?暦ｾ搾ｾ橸ｾ吶ｒ蜿門ｾ励＠縺ｾ縺吶?
092             * 縺溘□縺励?縺昴?蝣ｴ蜷医?縲√が繝ｼ繝翫?(SYSTEM_ID)縺ｯ驕ｸ縺ｹ縺ｾ縺帙ｓ縲?
093             *
094             * @og.rev 5.1.9.0 (2010/08/01) String[] value 蟒?ｭ｢
095             *
096             * @param       newQuery        DB讀懃ｴ｢(SQL)譁?ｭ怜?
097             * @param dbid  繝??繧ｿ繝吶?繧ｹ謗･邯壼?ID
098             * @param lang  繝ｪ繧ｽ繝ｼ繧ｹ繧剃ｽｿ逕ｨ縺吶ｋ蝣ｴ蜷医?險?ｪ?
099             */
100            public Selection_DBRADIO( final String newQuery,final String dbid,final String lang ) {
101    
102                    String[][] cols = DBUtil.dbExecute( newQuery,null,appInfo,dbid );
103                    int count = cols.length;
104    
105    //              value   = new String[count];                    // 5.1.9.0 (2010/08/01) K.H
106                    label   = new String[count];
107                    cls             = new String[count];
108                    disabled= new String[count];
109                    map             = new LinkedHashMap<String,Integer>(count);
110    
111                    int len = ( count > 0 ) ? cols[0].length : 0 ;
112                    isClass = ( len > CLS );             // >= 3 縺ｨ蜷梧э;
113                    isDisable = ( len > DISABLED );      // >= 4 縺ｨ蜷梧э;
114    
115                    boolean useLabelData = false ;
116                    ResourceManager resource = null;
117                    if( len == 1 ) {
118                            useLabelData = true;
119                            resource = ResourceFactory.newInstance( lang );
120                    }
121    
122                    for( int i=0; i<count; i++ ) {
123    //                      value[i] = cols[i][VAL];
124                            String value = cols[i][VAL];
125                            if( useLabelData ) {
126    //                              label[i] = resource.getShortLabel( value[i] );
127                                    label[i] = resource.getShortLabel( value );
128                            }
129                            else {
130                                    label[i] = cols[i][LBL];
131                            }
132    
133                            if( isClass ) {
134                                    cls[i] = cols[i][CLS];
135                            }
136                            if( isDisable ) {
137                                    disabled[i] = cols[i][DISABLED];
138                            }
139    
140    //                      map.put( value[i], Integer.valueOf( i ) );
141                            map.put( value, Integer.valueOf( i ) );
142                    }
143    
144                    createTime = System.currentTimeMillis() ;
145            }
146    
147            /**
148             * 蛻晄悄蛟､縺碁∈謚樊ｸ医∩縺ｮ 驕ｸ謚櫁い(繧ｪ繝励す繝ｧ繝ｳ)繧定ｿ斐＠縺ｾ縺吶?
149             * 縺薙?繧ｪ繝励す繝ｧ繝ｳ縺ｯ縲∝ｼ墓焚縺ｮ蛟､繧貞?譛溷?縺ｨ縺吶ｋ繧ｪ繝励す繝ｧ繝ｳ繧ｿ繧ｰ繧定ｿ斐＠縺ｾ縺吶?
150             * 窶ｻ 縺薙?繧ｯ繝ｩ繧ｹ縺ｧ縺ｯ螳溯｣?＆繧後※縺?∪縺帙ｓ縲?
151             *
152             * @param       selectValue     驕ｸ謚槭＆繧後※縺?ｋ蛟､
153             * @param       seqFlag         繧ｷ繝ｼ繧ｱ繝ｳ繧ｹ繧｢繧ｯ繧ｻ繧ｹ讖溯?縺ｮ謖?ｮ?
154             *
155             * @return  繧ｪ繝励す繝ｧ繝ｳ繧ｿ繧ｰ
156             */
157            public String getOption( final String selectValue,final boolean seqFlag ) {
158                    String errMsg = "縺薙?繧ｯ繝ｩ繧ｹ縺ｧ縺ｯ螳溯｣?＆繧後※縺?∪縺帙ｓ縲?;
159                    throw new UnsupportedOperationException( errMsg );
160            }
161    
162            /**
163             * 蛻晄悄蛟､縺碁∈謚樊ｸ医∩縺ｮ 驕ｸ謚櫁い(繧ｪ繝励す繝ｧ繝ｳ)繧定ｿ斐＠縺ｾ縺吶?
164             * 縺薙?繧ｪ繝励す繝ｧ繝ｳ縺ｯ縲∝ｼ墓焚縺ｮ蛟､繧貞?譛溷?縺ｨ縺吶ｋ繧ｪ繝励す繝ｧ繝ｳ繧ｿ繧ｰ繧定ｿ斐＠縺ｾ縺吶?
165             * 窶ｻ 縺薙?繧ｯ繝ｩ繧ｹ縺ｧ縺ｯ螳溯｣?＆繧後※縺?∪縺帙ｓ縲?
166             *
167             * @og.rev 5.1.3.0 (2010/02/01) 霑ｽ蜉?
168             *
169             * @param   selectValue  驕ｸ謚槭＆繧後※縺?ｋ蛟､
170             * @param       seqFlag         繧ｷ繝ｼ繧ｱ繝ｳ繧ｹ繧｢繧ｯ繧ｻ繧ｹ讖溯?縺ｮ謖?ｮ?
171             * @param       useShortLabel   遏ｭ繝ｩ繝吶Ν縺ｮ謖?ｮ?
172             *
173             * @return  繧ｪ繝励す繝ｧ繝ｳ繧ｿ繧ｰ
174             */
175            public String getOption( final String selectValue,final boolean seqFlag, final boolean useShortLabel ) {
176                    String errMsg = "縺薙?繧ｯ繝ｩ繧ｹ縺ｧ縺ｯ螳溯｣?＆繧後※縺?∪縺帙ｓ縲?;
177                    throw new UnsupportedOperationException( errMsg );
178            }
179    
180            /**
181             * 蛻晄悄蛟､縺碁∈謚樊ｸ医∩縺ｮ 驕ｸ謚櫁い(繧ｪ繝励す繝ｧ繝ｳ)繧定ｿ斐＠縺ｾ縺吶?
182             * 縺薙?繧ｪ繝励す繝ｧ繝ｳ縺ｯ縲∝ｼ墓焚縺ｮ蛟､繧貞?譛溷?縺ｨ縺吶ｋ繧ｪ繝励す繝ｧ繝ｳ繧ｿ繧ｰ繧定ｿ斐＠縺ｾ縺吶?
183             *
184             * @param   name         繝ｩ繧ｸ繧ｪ縺ｮ name
185             * @param   selectValue  驕ｸ謚槭＆繧後※縺?ｋ蛟､
186             * @param   useLabel     繝ｩ繝吶Ν陦ｨ遉ｺ縺ｮ譛臥┌ [true:譛?false:辟｡]
187             *
188             * @return  繧ｪ繝励す繝ｧ繝ｳ繧ｿ繧ｰ
189             */
190            public String getRadio( final String name,final String selectValue,final boolean useLabel ) {
191                    String inputTag = "<input type=\"radio\" name=\"" + name + "\" value=\"" ;
192                    StringBuilder buf = new StringBuilder( HybsSystem.BUFFER_LARGE );
193                    for( Map.Entry<String, Integer> e : map.entrySet() ) {
194                            String val = e.getKey();        // Ver 5.0.0.0 value 竍?val
195                            int valIdx = e.getValue().intValue();
196                            if( useLabel ) {
197                                    buf.append( "<label" );
198                                    if( isClass && cls[valIdx] != null && cls[valIdx].length() > 0 ) {
199                                            buf.append( " class=\"" ).append( cls[valIdx] ).append( "\"" );
200                                    }
201                                    buf.append(  ">" );
202                            }
203                            buf.append( inputTag ).append( val ).append( "\"" );
204                            if( val.equals( selectValue ) ) {
205                                    buf.append( " checked=\"checked\"" );
206                            }
207    
208                            if( isDisable && disabled[valIdx] != null && disabled[valIdx].length() > 0 ) {
209                                    if( "false".equalsIgnoreCase( disabled[valIdx] ) || "0".equals( disabled[valIdx] ) ) {
210                                            buf.append( " disabled=\"disabled\"" );
211                                    }
212                            }
213    
214                            buf.append( "/>" );
215                            if( useLabel ) { buf.append( label[valIdx] ).append( "</label>" ); }
216                    }
217                    return buf.toString();
218            }
219    
220            /**
221             * 驕ｸ謚櫁い(value)縺ｫ蟇ｾ縺吶ｋ繝ｩ繝吶Ν繧定ｿ斐＠縺ｾ縺吶?
222             * 驕ｸ謚櫁い(value)縺後?蟄伜惠縺励↑縺九▲縺溷?蜷医?縲?∈謚櫁い縺昴?繧ゅ?繧定ｿ斐＠縺ｾ縺吶?
223             * getValueLabel( XX ) 縺ｯ縲“etValueLabel( XX,false ) 縺ｨ蜷後§縺ｧ縺吶?
224             *
225             * @param   selectValue 驕ｸ謚櫁い縺ｮ蛟､
226             *
227             * @return  驕ｸ謚櫁い縺ｮ繝ｩ繝吶Ν
228             * @see     #getValueLabel( String,boolean )
229             */
230            public String getValueLabel( final String selectValue ) {
231                    return getValueLabel( selectValue,false );
232            }
233    
234            /**
235             * 驕ｸ謚櫁い(value)縺ｫ蟇ｾ縺吶ｋ繝ｩ繝吶Ν繧定ｿ斐＠縺ｾ縺吶?
236             * 驕ｸ謚櫁い(value)縺後?蟄伜惠縺励↑縺九▲縺溷?蜷医?縲?∈謚櫁い縺昴?繧ゅ?繧定ｿ斐＠縺ｾ縺吶?
237             * 縺薙?繝｡繧ｽ繝?ラ縺ｧ縺ｯ縲∫洒邵ｮ繝ｩ繝吶Ν繧定ｿ斐☆縺九←縺?°繧呈欠螳壹☆繧九ヵ繝ｩ繧ｰ繧呈欠螳壹＠縺ｾ縺吶?
238             * getValueLabel( XX,false ) 縺ｯ縲“etValueLabel( XX ) 縺ｨ蜷後§縺ｧ縺吶?
239             *
240             * @param       selectValue     驕ｸ謚櫁い縺ｮ蛟､
241             * @param       flag    遏ｭ邵ｮ繝ｩ繝吶Ν繧剃ｽｿ逕ｨ縺吶ｋ [true:菴ｿ逕ｨ縺吶ｋ/false:縺励↑縺Ь
242             *
243             * @return  驕ｸ謚櫁い縺ｮ繝ｩ繝吶Ν
244             * @see     #getValueLabel( String )
245             */
246            public String getValueLabel( final String selectValue,final boolean flag ) {
247                    // 繝槭ャ繝√☆繧九い繝峨Ξ繧ｹ繧呈爾縺吶?
248                    Integer sel = map.get( selectValue );
249    
250                    if( sel == null ) {
251                            return selectValue;
252                    }
253                    else {
254                            return label[sel.intValue()] ;
255                    }
256            }
257    
258            /**
259             * 驕ｸ謚櫁い(value)縺ｫ蟇ｾ縺吶ｋ繝ｩ繝吶Ν繧定ｿ斐＠縺ｾ縺吶?
260             * 驕ｸ謚櫁い(value)縺後?蟄伜惠縺励↑縺九▲縺溷?蜷医?縲?∈謚櫁い縺昴?繧ゅ?繧定ｿ斐＠縺ｾ縺吶?
261             * getValueLabel( XX ) 縺ｯ縲“etValueLabel( XX,false ) 縺ｨ蜷後§縺ｧ縺吶?
262             *
263             * @param   selectValue 驕ｸ謚櫁い縺ｮ蛟､
264             *
265             * @return  驕ｸ謚櫁い縺ｮ繝ｩ繝吶Ν
266             * @see     #getValueLabel( String,boolean )
267             */
268            public String getRadioLabel( final String selectValue ) {
269    
270                    StringBuilder rtn = new StringBuilder( HybsSystem.BUFFER_MIDDLE );
271                    for( Map.Entry<String, Integer> e : map.entrySet() ) {
272                            String val = e.getKey();        // Ver 5.0.0.0 value 竍?val
273                            if( val.equals( selectValue ) ) {
274                                    rtn.append( "笳? );
275                            }
276                            else {
277                                    rtn.append( "縲? );
278                            }
279                    }
280    
281                    return rtn.toString();
282            }
283    
284            /***
285             * 繝槭Ν繝√?繧ｭ繝ｼ繧ｻ繝ｬ繧ｯ繝医ｒ菴ｿ逕ｨ縺吶ｋ縺九←縺?°繧定ｿ斐＠縺ｾ縺吶?
286             * true?壻ｽｿ逕ｨ縺吶ｋ縲Ｇalse:菴ｿ逕ｨ縺励↑縺?縺ｧ縺吶?
287             * 縺溘□縺励?螳滄圀縺ｫ菴ｿ逕ｨ縺吶ｋ縺九←縺?°縺ｯ縲？TML蜃ｺ蜉帶凾縺ｫ豎ｺ繧√ｋ縺薙→縺悟?譚･縺ｾ縺吶?
288             * 縺薙％縺ｧ縺ｯ縲ゞSE_MULTI_KEY_SELECT 縺?true 縺ｧ縲ゞSE_SIZE(=20)莉･荳翫?蝣ｴ蜷医↓
289             * true 繧定ｿ斐＠縺ｾ縺吶?
290             *
291             * @return  驕ｸ謚槭Μ繧ｹ繝医〒縲√?繝ｫ繝√?繧ｭ繝ｼ繧ｻ繝ｬ繧ｯ繝医ｒ菴ｿ逕ｨ縺吶ｋ縺九←縺?°(true:菴ｿ逕ｨ縺吶ｋ)
292             */
293            public boolean useMultiSelect() {
294                    return false;
295            }
296    
297            /**
298             * 繧ｪ繝悶ず繧ｧ繧ｯ繝医?繧ｭ繝｣繝?す繝･縺梧凾髢灘?繧後°縺ｩ縺?°繧定ｿ斐＠縺ｾ縺吶?
299             * 繧ｭ繝｣繝?す繝･縺梧凾髢灘?繧?辟｡蜉ｹ)縺ｧ縺ゅｌ縺ｰ縲》rue 繧偵?譛牙柑縺ｧ縺ゅｌ縺ｰ縲?
300             * false 繧定ｿ斐＠縺ｾ縺吶?
301             *
302             * @return  繧ｭ繝｣繝?す繝･縺梧凾髢灘?繧後↑繧?true
303             */
304            public boolean isTimeOver() {
305                    return ( System.currentTimeMillis() - createTime > DB_CACHE_TIME ) ;
306            }
307    }