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.resource;
017    
018    import org.opengion.hayabusa.common.HybsSystem;
019    import org.opengion.hayabusa.common.SystemManager;
020    import org.opengion.fukurou.db.DBUtil;
021    import org.opengion.fukurou.util.Cleanable;
022    import org.opengion.fukurou.util.ApplicationInfo;
023    
024    import java.util.Map;
025    import java.util.WeakHashMap;
026    
027    /**
028     * 莠区･ｭ謇?CDJGS) , 蟷ｴ譛?YYYYMM) 縺ｫ蟇ｾ蠢懊＠縺滉ｼ第律繧ｫ繝ｬ繝ｳ繝?ョ繝ｼ繧ｿ繧剃ｽ懈?縺吶ｋ繝輔ぃ繧ｯ繝医Μ繧ｯ繝ｩ繧ｹ縺ｧ縺吶?
029     *
030     * 繧ｫ繝ｬ繝ｳ繝?ョ繝ｼ繧ｿ縺ｯ縲?ｼ第律(DY1)?橸ｼ難ｼ第律(DY31)縺ｾ縺ｧ縺ｮ譌･莉倥￠谺?↓蟇ｾ縺励※縲?:蟷ｳ譌･ 1:莨第律 縺ｨ縺?≧
031     * 繝??繧ｿ繧呈戟縺｣縺ｦ縺?∪縺吶?螳滄圀縺ｫ縺ｯ縲∝?驛ｨ縺ｧ縺ｯ true:蟷ｳ譌･ false:莨第律 縺ｨ縺?≧謖√■譁ｹ繧偵＠縺ｾ縺吶?
032     * (繧ｫ繝ｬ繝ｳ繝?ｼ､?｢縺ｯ縲∵枚蟄怜?縺ｧ縺吶′縲∝?驛ｨ縺ｧ謖√▽蝣ｴ蜷医?縲∵焚蟄励〒邂｡逅?＠縺ｦ縺?∪縺吶?)
033     *
034     * 騾壼ｸｸ縺ｮ繧ｫ繝ｬ繝ｳ繝?〒縺ｯ縲∵怦豈弱↓縲??呈怦縺ｯ縲∝ｹｴ縺ｫ繧医▲縺ｦ)譛?､ｧ譌･莉倥￠縺悟､峨ｏ繧翫∪縺吶?
035     * 縺薙ｌ縺ｯ縲√き繝ｬ繝ｳ繝?ョ繝ｼ繧ｿ繧ｯ繝ｩ繧ｹ縺ｨ縺励※縺ｯ縲?1 繧定ｨｭ螳壹＠縺ｦ縺翫″縺ｾ縺吶?
036     *
037     * 繧ｫ繝ｬ繝ｳ繝?ョ繝ｼ繧ｿ縺ｫ縺ｯ縲?ｼ薙▽縺ｮ繝ｬ繝吶Ν縺ｮ繧ｪ繝悶ず繧ｧ繧ｯ繝井ｽ懈?譁ｹ豕輔′驕ｩ逕ｨ縺輔ｌ縺ｾ縺吶?
038     * 莉悶?繝ｪ繧ｽ繝ｼ繧ｹ縺ｮ?薙▽縺ｮ繝ｬ繝吶Ν縺ｨ縺ｯ逡ｰ縺ｪ繧翫?繧ｨ繝ｳ繧ｸ繝ｳ繝ｪ繧ｽ繝ｼ繧ｹ縺九ｉ縺ｮ隱ｭ縺ｿ蜿悶ｊ縺ｯ
039     * 蟄伜惠縺励↑縺上?隨ｬ?斐?譁ｹ豕輔′蜉?ｏ縺｣縺滉ｺ九↓繧医ｊ縲?ｼ薙▽縺ｮ譁ｹ豕輔↓縺ｪ縺｣縺ｦ縺?∪縺吶?
040     *
041     * 縺ｾ縺壹?隱ｭ霎ｼ繝輔Λ繧ｰ(FGLOAD)='1'縺ｮ繧ｫ繝ｬ繝ｳ繝?ョ繝ｼ繧ｿ縺ｯ縲√％縺ｮCalendarFactory繧ｪ繝悶ず繧ｧ繧ｯ繝医′
042     * 讒狗ｯ峨＆繧後◆譎ゅ↓縲√☆縺ｹ縺ｦ繧ｭ繝｣繝?す繝･縺ｨ縺励※蜀?Κ繝｡繝｢繝ｪ縺ｫ隱ｭ縺ｿ蜿悶ｊ縺ｾ縺吶?
043     * 隱ｭ霎ｼ繝輔Λ繧ｰ縺後?'1' 莉･螟悶?繝??繧ｿ縺ｯ縲∝?譛溯ｵｷ蜍墓凾縺ｫ縺ｯ縲√Γ繝｢繝ｪ縺ｫ繧ｭ繝｣繝?す繝･縺輔ｌ縺?
044     * 螳滄圀縺ｫ菴ｿ逕ｨ縺輔ｌ繧九∪縺ｧ縲√が繝悶ず繧ｧ繧ｯ繝医′菴懈?縺輔ｌ縺ｾ縺帙ｓ縲?
045     * 繧ｫ繝ｬ繝ｳ繝??蝣ｴ蜷医?驕主悉縺ｮ菴ｿ逕ｨ縺輔ｌ繧句庄閭ｽ諤ｧ縺御ｽ弱＞繝??繧ｿ縺ｾ縺ｧ縲√く繝｣繝?す繝･縺励↑縺?ｧ倥↓縲?
046     * 縺薙?繝輔Λ繧ｰ繧剃ｽｿ逕ｨ縺励※縲√Γ繝｢繝ｪ縺ｮ遽?ｴ?ｒ蝗ｳ繧九％縺ｨ縺悟庄閭ｽ縺ｫ縺ｪ繧翫∪縺吶?
047     *
048     * 隱ｭ霎ｼ繝輔Λ繧ｰ(FGLOAD)閾ｪ蜍戊ｨｭ螳壽ｩ溯?繧剃ｽｿ逕ｨ縺吶ｌ縺ｰ縲∬ｪｭ縺ｿ蜿悶▲縺溘Λ繝吶Ν繝??繧ｿ縺ｫ蟇ｾ縺励※縲?
049     * 隱ｭ霎ｼ繝輔Λ繧ｰ(FGLOAD)縺ｫ '1' 繧定?蜍慕噪縺ｫ繧ｻ繝?ヨ縺励∪縺吶?縺薙?讖溯?縺ｫ繧医ｊ縲∽ｸ?ｺｦ縺ｧ繧?
050     * 隱ｭ縺ｿ蜿悶▲縺溘％縺ｨ縺後≠繧九ョ繝ｼ繧ｿ縺ｫ '1' 繧剃ｻ倥￠縲∵ｬ｡蝗櫁ｵｷ蜍墓凾縺ｫ縺ｯ縲√Γ繝｢繝ｪ繧ｭ繝｣繝?す繝･縺輔○繧?
051     * 莠九→縲∽ｸ?ｺｦ繧りｪｭ縺ｿ蜿悶▲縺ｦ縺?↑縺?ョ繝ｼ繧ｿ繧貞愛蛻･縺励※縲√ョ繝ｼ繧ｿ蜑企勁遲峨?繝｡繝ｳ繝?リ繝ｳ繧ｹ縺ｫ
052     * 菴ｿ逕ｨ縺吶ｋ縺薙→縺悟庄閭ｽ縺ｧ縺吶?
053     * 繧ｫ繝ｬ繝ｳ繝?↓髯仙ｮ壹☆繧後?縲∝ｽ馴擇菴ｿ逕ｨ縺輔ｌ縺ｪ縺??縺ｮ繧ｫ繝ｬ繝ｳ繝??大ｹｴ蛻?↑縺ｩ)繧堤匳骭ｲ縺吶ｋ譎ゅ↓縲?
054     * 隱ｭ霎ｼ繝輔Λ繧ｰ(FGLOAD)='0' 縺ｫ縺励※縺翫￠縺ｰ縲∝ｮ滄圀縺ｫ隱ｭ縺ｿ蜿悶ｉ繧後ｋ縺ｾ縺ｧ縲√Γ繝｢繝ｪ繧ｭ繝｣繝?す繝･
055     * 縺輔ｌ縺ｪ縺?◆繧√?縺輔ｉ縺ｫ繝｡繝｢繝ｪ蜉ｹ邇?′蜷台ｸ翫＠縺ｾ縺吶?
056     *
057     * ?偵▽繧√?譁ｹ豕輔?縲√く繝｣繝?す繝･縺ｫ蟄伜惠縺励↑縺??蜷医?縲?ｼ､?｢縺九ｉ隱ｭ縺ｿ蜿悶ｊ縺ｾ縺吶?
058     *
059     * ?薙▽繧√?縲√き繝ｬ繝ｳ繝?音譛峨?譁ｹ豕輔〒縲?ｼ､?｢縺ｫ繝??繧ｿ縺悟ｭ伜惠縺励↑縺??蜷医?險ｭ螳壹〒縺吶?
060     * 縺薙ｌ縺ｯ縲√き繝ｬ繝ｳ繝?ユ繝ｼ繝悶Ν譛ｪ險ｭ螳壽凾縺ｧ繧ゅ?繧ｫ繝ｬ繝ｳ繝?→縺励※菴ｿ逕ｨ縺ｧ縺阪ｋ繧医≧縺ｫ
061     * 閾ｪ蜍慕噪縺ｫ繧ｫ繝ｬ繝ｳ繝?ョ繝ｼ繧ｿ繧剃ｽ懈?縺励∪縺吶?譌･譖懈律繧剃ｼ第律縺ｨ縺励※閾ｪ蜍戊ｨｭ螳壹＠縺ｾ縺吶?
062     *
063     * @og.rev 3.6.0.0 (2004/09/17) 譁ｰ隕丈ｽ懈?
064     * @og.group 繝ｪ繧ｽ繝ｼ繧ｹ邂｡逅?
065     *
066     * @version  4.0
067     * @author   Kazuhiko Hasegawa
068     * @since    JDK5.0,
069     */
070    public final class CalendarFactory {
071            private static final Map<String,CalendarData> pool = new WeakHashMap<String,CalendarData>();                                // 4.0.0 (2005/01/31)
072            private static final Map<String,CalendarQuery> queryClassPool = new WeakHashMap<String,CalendarQuery>();            // 4.0.0 (2005/01/31)
073            // 4.0.0.0 PG繧ｫ繝ｬ繝ｳ繝??縺ｮ蛻晄悄險ｭ螳壹ｒ繧ｷ繧ｹ繝?Β繝ｪ繧ｽ繝ｼ繧ｹ縺ｫ螟画峩
074    //      private static final CalendarData PG_CALENDAR_DATA = new CalendarPGData();
075            private static CalendarData pgCalData = null;
076            private static final String PG_CALENDAR_DATA_CLASS = HybsSystem.sys( "DEFAULT_CALENDAR_CLASS");
077            private static final Object lock = new Object();
078    
079            // 繧ｫ繝ｬ繝ｳ繝?ｼ､?｢縺ｮ謗･邯壼?繧偵?蜿門ｾ励＠縺ｾ縺吶?
080            private static final String DBID  = HybsSystem.sys( "RESOURCE_CALENDAR_DBID" );
081    
082            // 繧ｫ繝ｬ繝ｳ繝?ｼ､?｢繧剃ｽｿ逕ｨ縺吶ｋ縺九←縺?°繧呈欠螳壹＠縺ｾ縺吶?(莠呈鋤繝｢繝ｼ繝?
083            private static boolean useDB = HybsSystem.sysBool( "USE_CALENDAR_DATABASE" );
084    
085            // 3.8.7.0 (2006/12/15) 繧｢繧ｯ繧ｻ繧ｹ繝ｭ繧ｰ蜿門ｾ励?轤ｺ,ApplicationInfo繧ｪ繝悶ず繧ｧ繧ｯ繝医ｒ險ｭ螳?
086            private static final ApplicationInfo appInfo;
087    
088            // 4.0.0 (2005/01/31) Cleanable 繧､繝ｳ繧ｿ繝ｼ繝輔ぉ繝ｼ繧ｹ縺ｫ繧医ｋ蛻晄悄蛹門?逅?
089            static {
090                    Cleanable clr = new Cleanable() {
091                            public void clear() {
092                                    CalendarFactory.clear();
093                            }
094                    };
095    
096                    SystemManager.addCleanable( clr );
097    
098                    /** 繧ｳ繝阪け繧ｷ繝ｧ繝ｳ縺ｫ繧｢繝励Μ繧ｱ繝ｼ繧ｷ繝ｧ繝ｳ諠??繧定ｿｽ險倥☆繧九°縺ｩ縺?°謖?ｮ?*/
099                    boolean USE_DB_APPLICATION_INFO  = HybsSystem.sysBool( "USE_DB_APPLICATION_INFO" ) ;
100    
101                    // 3.8.7.0 (2006/12/15) 繧｢繧ｯ繧ｻ繧ｹ繝ｭ繧ｰ蜿門ｾ励?轤ｺ,ApplicationInfo繧ｪ繝悶ず繧ｧ繧ｯ繝医ｒ險ｭ螳?
102                    if( USE_DB_APPLICATION_INFO ) {
103                            String SYSTEM_ID = HybsSystem.sys( "SYSTEM_ID" );
104                            appInfo = new ApplicationInfo();
105                            // 繝ｦ繝ｼ繧ｶ繝ｼID,IP繧｢繝峨Ξ繧ｹ,繝帙せ繝亥錐
106                            appInfo.setClientInfo( SYSTEM_ID,HybsSystem.HOST_ADRS,HybsSystem.HOST_NAME );
107                            // 逕ｻ髱｢ID,謫堺ｽ?繝励Ο繧ｰ繝ｩ繝?D
108                            appInfo.setModuleInfo( "CalendarFactory",null,null );
109                    }
110                    else {
111                            appInfo = null;
112                    }
113            }
114    
115            /**
116             * 繧ｳ繝ｳ繧ｹ繝医Λ繧ｯ繧ｿ
117             * 繝輔ぃ繧ｯ繝医Μ繧ｯ繝ｩ繧ｹ縺ｮ轤ｺ縲｝rivate 蛹悶＠縺ｦ縺?∪縺吶?
118             *
119             */
120            private CalendarFactory() { }
121    
122            /**
123             * CalendarData 繧ｪ繝悶ず繧ｧ繧ｯ繝医ｒ蜿門ｾ励＠縺ｾ縺吶?
124             * 菴懈?縺励◆CalendarData繧ｪ繝悶ず繧ｧ繧ｯ繝医??悟?驛ｨ縺ｫ繝励?繝ｫ縺励※縺翫″?悟酔縺倥Μ繧ｽ繝ｼ繧ｹ隕∵ｱゅ′
125             * 縺ゅ▲縺溘→縺阪??後?繝ｼ繝ｫ縺ｮ CalendarData繧定ｿ斐＠縺ｾ縺吶?
126             * ?､?｢縺ｫ繝??繧ｿ縺悟ｭ伜惠縺励↑縺??蜷医?縲∬?蜍輔〒繧ｫ繝ｬ繝ｳ繝?ｒ菴懈?縺励∪縺吶?
127             *
128             * @og.rev 3.8.7.0 (2006/12/15) 繧｢繧ｯ繧ｻ繧ｹ繝ｭ繧ｰ蜿門ｾ励?轤ｺ,ApplicationInfo繧ｪ繝悶ず繧ｧ繧ｯ繝医ｒ險ｭ螳?
129             * @og.rev 4.0.0.0 (2007/08/29) 繧ｫ繝ｬ繝ｳ繝??繝??繝悶Ν縺悟ｭ伜惠縺励↑縺??蜷医?繝?ヵ繧ｩ繝ｫ繝医?繧ｫ繝ｬ繝ｳ繝??繝??繧ｿ繧偵す繧ｹ繝?Β繝ｪ繧ｽ繝ｼ繧ｹ縺ｧ險ｭ螳壹☆繧?
130             *
131             * @param       cls     CalendarQuery繧ｪ繝悶ず繧ｧ繧ｯ繝医ｒ蜷咲ｧｰ繧呈欠螳壹＠縺ｾ縺吶?
132             * @param       arg1    繝??繧ｿ繝吶?繧ｹ讀懃ｴ｢譎ゅ?隨ｬ?大ｼ墓焚
133             * @param       arg2    繝??繧ｿ繝吶?繧ｹ讀懃ｴ｢譎ゅ?隨ｬ?貞ｼ墓焚
134             * @param       arg3    繝??繧ｿ繝吶?繧ｹ讀懃ｴ｢譎ゅ?隨ｬ?灘ｼ墓焚
135             * @param       arg4    繝??繧ｿ繝吶?繧ｹ讀懃ｴ｢譎ゅ?隨ｬ?泌ｼ墓焚
136             *
137             * @return      CalendarData繧ｪ繝悶ず繧ｧ繧ｯ繝?
138             */
139            public static CalendarData getCalendarData( final String cls,final String arg1,final String arg2,final String arg3,final String arg4 ) {
140    
141                    // 4.0.0.0 PG繧ｫ繝ｬ繝ｳ繝??縺ｮ蛻晄悄險ｭ螳壹ｒ繧ｷ繧ｹ繝?Β繝ｪ繧ｽ繝ｼ繧ｹ縺ｫ螟画峩
142                    synchronized( lock ) {
143                            if(pgCalData == null) {
144                                    pgCalData = (CalendarData)HybsSystem.newInstance(PG_CALENDAR_DATA_CLASS);
145                            }
146                    }
147    
148    //              if( ! useDB || cls == null ) { return PG_CALENDAR_DATA; }
149                    if( ! useDB || cls == null ) { return pgCalData; }
150    
151                    CalendarData calData ;
152    
153                    String key = cls + ":" + arg1 + ":" + arg2 + ":" + arg3 + ":" + arg4 ;
154                    synchronized( lock ) {
155                            calData = pool.get( key ) ;
156                    }
157    
158                    if( calData == null ) {
159                            CalendarQuery query ;
160                            synchronized( lock ) {
161                                    query = queryClassPool.get( cls );
162                                    if( query == null ) {
163                                            String queryClass = HybsSystem.sys( "CalendarQuery_" + cls );
164                                            query = (CalendarQuery)HybsSystem.newInstance( queryClass );
165                                            queryClassPool.put( cls,query );
166                                    }
167                            }
168    
169                            String[] args = query.checkArgment( arg1,arg2,arg3,arg4 );
170                            String[][] vals = DBUtil.dbExecute( query.getQuery(),args,appInfo,DBID );       // 3.8.7.0 (2006/12/15)
171                            boolean  isFlat = query.isFlatTable();
172    
173                            if( vals != null && vals.length > 0 ) {
174                                    calData = new CalendarDBData( vals,isFlat );
175                                    // 螳悟?蜷梧悄縺ｧ縺ｯ縺ｪ縺??DB蜃ｦ逅?ｸｭ縺ｫ蛻･縺ｫ繧?B蜃ｦ逅?ｒ陦後＞縲?
176                                    // 蜈医↓ put 縺輔ｌ縺溘→縺励※繧ゅ?蜷御ｸ?く繝ｼ縺ｫ蜷後§螻樊?縺ｮ繧ｪ繝悶ず繧ｧ繧ｯ繝医ｒ
177                                    // 逋ｻ骭ｲ縺吶ｋ縺?￠縺ｪ縺ｮ縺ｧ縲∝ｮ溯ｳｪ逧?↑蝠城｡後?逋ｺ逕溘＠縺ｪ縺??
178                                    // 縺薙ｌ縺後?List 縺ｪ縺ｩ縺ｮ鬆?ｺ上′髢｢菫ゅ☆繧九→縲√％縺ｮ繧ｳ繝ｼ繝峨?菴ｿ縺医↑縺??
179                                    synchronized( lock ) {
180                                            pool.put( key,calData );
181                                    }
182                            }
183                            else {
184                                    // 繧ｫ繝ｬ繝ｳ繝?ユ繝ｼ繝悶Ν縺ｫ繝??繧ｿ縺悟ｭ伜惠縺励↑縺??蜷医?
185                                    // 4.0.0.0 PG繧ｫ繝ｬ繝ｳ繝??縺ｮ蛻晄悄險ｭ螳壹ｒ繧ｷ繧ｹ繝?Β繝ｪ繧ｽ繝ｼ繧ｹ縺ｫ螟画峩
186    //                              calData = PG_CALENDAR_DATA;
187                                    calData = pgCalData;
188                            }
189                    }
190                    return calData ;
191            }
192    
193            /**
194             * 繧ｭ繝｣繝?す繝･(繝励?繝ｫ)縺九ｉ縲√☆縺ｹ縺ｦ縺ｮ繧ｪ繝悶ず繧ｧ繧ｯ繝医ｒ繧ｯ繝ｪ繧｢縺励∪縺吶?
195             *
196             */
197            public static void clear() {
198                    synchronized( lock ) {
199                            pool.clear();
200                            queryClassPool.clear();
201                            useDB = HybsSystem.sysBool( "USE_CALENDAR_DATABASE" );
202                    }
203            }
204    }