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 java.util.HashMap;
019    import java.util.Locale;
020    import java.util.Map;
021    
022    import org.opengion.fukurou.db.DBUtil;
023    import org.opengion.fukurou.util.ApplicationInfo;
024    import org.opengion.fukurou.util.StringUtil;
025    import org.opengion.hayabusa.common.HybsSystem;
026    
027    /**
028     * 繝??繧ｿ繝ｭ繝ｼ繝ｫ縺ｯ縲√ョ繝ｼ繧ｿ縺ｸ縺ｮ繧｢繧ｯ繧ｻ繧ｹ讓ｩ髯舌ｒ邂｡逅?☆繧九け繝ｩ繧ｹ縺ｧ縺吶?
029     *
030     * 繝??繧ｿ繝ｭ繝ｼ繝ｫ諠??縺ｯ縲√ョ繝ｼ繧ｿ繝ｭ繝ｼ繝ｫ繝槭せ繧ｿ(GEA06)縺ｧ邂｡逅?＆繧後∪縺吶?
031     *
032     * 縺ゅｋ繝ｦ繝ｼ繧ｶ繝ｼ縺ｮ繝??繧ｿ繝ｭ繝ｼ繝ｫ諠??縺ｫ蟇ｾ縺励※縺ｲ繧ゅ▽縺上ョ繝ｼ繧ｿ繝ｭ繝ｼ繝ｫ繝槭せ繧ｿ縺ｮ
033     * 繧ｫ繝ｩ繝??譚｡莉ｶ蛟､縲∵擅莉ｶ蠑上?荳?ｦｧ縺ｫ蟇ｾ縺励※縲√き繝ｩ繝?腰菴阪↓譚｡莉ｶ蠑上ｒ讒狗ｯ峨＠縺ｾ縺吶?
034     *
035     * 縺薙?繧ｯ繝ｩ繧ｹ縺ｧ縺ｯ縲√う繝ｳ繧ｹ繧ｿ繝ｳ繧ｹ菴懈?譎ゅ↓繝??繧ｿ繝ｭ繝ｼ繝ｫ繝槭せ繧ｿ縺ｮDB繧堤峩謗･讀懃ｴ｢縺励※縺?∪縺吶?
036     * 縺薙?縺溘ａ縲√ョ繝ｼ繧ｿ螟画峩譎ゅ?螟画峩蜀?ｮｹ繧呈ｬ｡蝗槭Ο繧ｰ繧､繝ｳ譎ゅ°繧牙渚譏?＆縺帙ｋ縺溘ａ縲?
037     * 閾ｪ霄ｫ縺ｮ繧ｪ繝悶ず繧ｧ繧ｯ繝医く繝｣繝?す繝･縺ｯ菫晄戟縺励※縺?∪縺帙ｓ縲?
038     *
039     * 縺ｾ縺溘?蜷?擅莉ｶ蠑上↓縺､縺?※縲?縺､縺ｮ繧ｫ繝ｩ繝?↓蟇ｾ縺励※隍?焚縺ｮ譚｡莉ｶ蠑上′驕ｩ逕ｨ縺輔ｌ繧句?蜷医?
040     * 譚｡莉ｶ蠑上′"="縺ｾ縺溘?"LIKE"縺?￠縺ｮ蝣ｴ蜷医?縲?OR"邨仙粋縺輔ｌ縺ｾ縺吶?
041     * "!="蜿翫?"NOT LIKE"譚｡莉ｶ縺?縺､縺ｧ繧ょ性縺ｾ繧後ｋ蝣ｴ蜷医?縲?AND"邨仙粋縺輔ｌ縺ｾ縺吶?
042     *
043     * 繝??繧ｿ繝ｭ繝ｼ繝ｫ縺君ULL縺ｮ蝣ｴ蜷医?蜈ｨ繝??繧ｿ縺ｸ縺ｮ繧｢繧ｯ繧ｻ繧ｹ蜿ｯ閭ｽ縺ｨ縺ｪ繧翫?譚｡莉ｶ蠑上→縺励※縺ｯ縲?
044     *  "LIKE '%'" 縺御ｻ伜刈縺輔ｌ縺ｾ縺吶?
045     * 縺ｾ縺溘?'--'縺ｮ蝣ｴ蜷医?蜈ｨ繝??繧ｿ縺ｸ縺ｮ繧｢繧ｯ繧ｻ繧ｹ縺御ｸ榊庄閭ｽ縺ｨ縺ｪ繧翫?譚｡莉ｶ蠑上→縺励※縺ｯ縲?
046     *  "NOT LIKE '%'" 縺御ｻ伜刈縺輔ｌ縺ｾ縺吶?
047     * 繝ｦ繝ｼ繧ｶ繝ｼ縺ｮ繝??繧ｿ繝ｭ繝ｼ繝ｫ縺梧欠螳壹＆繧後※縺?ｋ縺ｫ繧る未繧上ｉ縺壹?繝??繧ｿ繝ｭ繝ｼ繝ｫ縺ｮ讀懃ｴ｢縺後〒縺阪↑縺?
048     * 蝣ｴ蜷医?縲∝?遖∵ｭ｢縺ｫ縺ｪ繧翫∪縺吶?
049     *
050     * 讀懃ｴ｢譚｡莉ｶ繧貞叙蠕励☆繧矩圀縺ｫ縲√ユ繝ｼ繝悶Ν蜷榊処縺ｯ縲√ユ繝ｼ繝悶Ν蜷阪?蛻･蜷阪′謖?ｮ壹＆繧後◆蝣ｴ蜷医?
051     * 譚｡莉ｶ縺ｮ蜿門ｾ励☆繧矩圀縺ｫ縺ｯ縲√ユ繝ｼ繝悶Ν蜷阪?辟｡隕悶＆繧後∪縺吶′縲∬ｿ斐＆繧後ｋ譚｡莉ｶ縺ｫ縺ｯ縲√ユ繝ｼ繝悶Ν蜷?
052     * 縺ｯ莉伜刈縺輔ｌ縺溽憾諷九↓縺ｪ繧翫∪縺吶?
053     *
054     * 萓?
055     *  ABC(=)              BCD(=)          竍?(CLM = 'ABC' or CLM = 'BCD' )
056     *  ABC(=)              BCD(LIKE)       竍?(CLM = 'ABC' or CLM like 'BCD%' )
057     *  ABC(=)              BCD(!=)         竍?(CLM = 'ABC' and CLM != 'BCD' )
058     *  ABC(LIKE)   BCD(LIKE)       竍?(CLM like 'ABC%' or CLM like 'BCD%' )
059     *  ABC(LIKE)   BCD(!=)         竍?(CLM like 'ABC%' and CLM != 'BCD' )
060     *  ABC(LIKE)   BCD(!=)         竍?(CLM != 'ABC' and CLM != 'BCD' )
061     *  ABC(=)              BCD(=)          竍?(A.CLM = 'ABC' or A.CLM = 'BCD' ) 窶ｻ {&#064;SEC.A.CLM}縺ｧ繧｢繧ｯ繧ｻ繧ｹ
062     *
063     * @og.rev 4.4.0.0 (2009/08/02) 譁ｰ隕丈ｽ懈?
064     * @og.group 繝ｪ繧ｽ繝ｼ繧ｹ邂｡逅?
065     *
066     * @version  4.0
067     * @author   Hiroki Nakamura
068     * @since    JDK5.0,
069     */
070    public final class DataRole {
071            private static final String QUERY_GEA06_SELECT
072                                            = "select CLM, CVALUE, VALCDTN from GEA06"
073                                                    + " where SYSTEM_ID = ? and DROLE = ? and FGJ = '1'";
074    
075            private static final int IDX_CLM        = 0;
076            private static final int IDX_CVALUE     = 1;
077            private static final int IDX_VALCDTN= 2;
078    
079            private static final DataRole FULL_ACCESS_DATAROLE_OBJ = new DataRole( true ) ;
080            private static final DataRole FULL_DENY_DATAROLE_OBJ = new DataRole( false ) ;
081    
082            private static final String FULL_ACCESS_CONDITION = null ;
083            private static final String FULL_DENY_CONDITION = " NOT LIKE '%'" ;
084            private static final String FULL_DENY_DROLES_KEY = "--";
085    
086            private final Map<String,String> cdtnMap = new HashMap<String,String>( HybsSystem.BUFFER_SMALL );
087    
088            private final String                    droles ;                // 繝??繧ｿ繝ｭ繝ｼ繝ｫ繧ｺ
089            private final String                    systemId ;              // 繧ｷ繧ｹ繝?ΒID
090            private final ApplicationInfo   appInfo ;
091            private final String DBID = HybsSystem.sys( "RESOURCE_DBID" );          // 5.5.5.1 (2012/08/07) 繝ｪ繧ｽ繝ｼ繧ｹ邉ｻDBID 莉倥￠蠢倥ｌ蟇ｾ蠢?
092    
093            private boolean         isFullAcess             = false;
094            private boolean         isFullDeny              = false;
095    
096            /**
097             * 蝗ｺ螳壹ョ繝ｼ繧ｿ繝ｭ繝ｼ繝ｫ(蜈ｨ繧｢繧ｯ繧ｻ繧ｹ蜿ｯ or 蜈ｨ繧｢繧ｯ繧ｻ繧ｹ荳榊庄)縺ｮ繧､繝ｳ繧ｹ繧ｿ繝ｳ繧ｹ繧堤函謌舌＠縺ｾ縺吶?
098             *
099             * @param isFull true:蜈ｨ繧｢繧ｯ繧ｻ繧ｹ蜿ｯ false:蜈ｨ繧｢繧ｯ繧ｻ繧ｹ荳榊庄
100             */
101            private DataRole( final boolean isFull ) {
102                    droles = null;
103                    systemId = null;
104                    appInfo = null;
105    
106                    if( isFull )    { isFullAcess = true; }
107                    else                    { isFullDeny = true; }
108            }
109    
110            /**
111             * 繝ｭ繝ｼ繝ｫ譁?ｭ怜?縺九ｉ縲√ョ繝ｼ繧ｿ繝ｭ繝ｼ繝ｫ繝槭せ繧ｿ(GEA05)繧呈､懃ｴ｢縺励?繧ｫ繝ｩ繝?腰菴阪?
112             * 譚｡莉ｶ蠑上ｒ逕滓?縺励∪縺吶?
113             *
114             * @param droles "|"縺ｧ蛹ｺ蛻?ｉ繧後◆ 繝??繧ｿ繝ｭ繝ｼ繝ｫ譁?ｭ怜?
115             * @param systemId 繧ｷ繧ｹ繝?ΒID
116             * @param appInfo 謗･邯壽ュ蝣ｱ
117             */
118            private DataRole( final String droles,final String systemId, final ApplicationInfo appInfo ) {
119                    this.droles = droles ;          // 繝??繧ｿ繝ｭ繝ｼ繝ｫ繧ｺ
120                    this.systemId = systemId;       // 繧ｷ繧ｹ繝?ΒID
121                    this.appInfo = appInfo ;
122    
123                    if( appInfo != null ) {
124                            appInfo.setModuleInfo( "DataRole",null,"CreateInstance" );
125                    }
126    
127                    String[] drole = StringUtil.csv2Array( droles, '|' );
128                    if( drole == null || drole.length == 0 ) {
129                            isFullAcess = true;
130                            return;
131                    }
132                    else {
133                            makeConditionMap( drole );
134                    }
135            }
136    
137            /**
138             * 繝ｭ繝ｼ繝ｫ譁?ｭ怜?縺九ｉ縲√ョ繝ｼ繧ｿ繝ｭ繝ｼ繝ｫ繝槭せ繧ｿ(GEA05)繧呈､懃ｴ｢縺励?繧ｫ繝ｩ繝?腰菴阪?
139             * 譚｡莉ｶ蠑上ｒ逕滓?縺励∪縺吶?
140             *
141             * @og.rev 5.5.5.1 (2012/08/07) 繝ｪ繧ｽ繝ｼ繧ｹ邉ｻDBID 莉倥￠蠢倥ｌ蟇ｾ遲?
142             *
143             * @param drole 繝??繧ｿ繝ｭ繝ｼ繝ｫ譁?ｭ怜?縺ｮ驟榊?
144             */
145            private void makeConditionMap( final String[] drole ) {
146    //              String[][] vals = null;
147                    String clm = null;
148                    String cvalue =null;
149                    String valcdtn = null;
150                    for( int i=0; i<drole.length; i++ ) {
151                            String[] args = new String[] { systemId, drole[i] };
152    //                      String[][] vals = DBUtil.dbExecute( QUERY_GEA06_SELECT,args,appInfo );
153                            String[][] vals = DBUtil.dbExecute( QUERY_GEA06_SELECT,args,appInfo, DBID );    // 5.5.5.1 (2012/08/07)
154                            for( int j=0; j<vals.length; j++ ) {
155                                    clm = vals[j][IDX_CLM];
156                                    cvalue = vals[j][IDX_CVALUE];
157                                    valcdtn = vals[j][IDX_VALCDTN];
158    
159                                    String cdtn = cdtnMap.get( clm );
160                                    if( cdtn == null ) { cdtn = ""; }
161                                    else if( "=".equals( valcdtn ) || "LIKE".equalsIgnoreCase( valcdtn ) ) {
162                                            cdtn += " or ";
163                                    }
164                                    else {
165                                            cdtn += " and ";
166                                    }
167                                    cdtn += clm + " " + valcdtn + " '" + cvalue;
168                                    if( valcdtn.toUpperCase( Locale.JAPAN ).indexOf( "LIKE" ) >= 0 ) {
169                                            cdtn += "%";
170                                    }
171                                    cdtn += "'";
172    
173                                    if( cdtn.indexOf( " and " ) >= 0 ) { cdtn = cdtn.replace( " or ", "and" ); }
174    
175                                    cdtnMap.put( clm, cdtn );
176                            }
177                    }
178            }
179    
180            /**
181             * 繝ｭ繝ｼ繝ｫ譁?ｭ怜?縺九ｉ縲√ョ繝ｼ繧ｿ繝ｭ繝ｼ繝ｫ繝槭せ繧ｿ(GEA05)繧呈､懃ｴ｢縺励?繧ｫ繝ｩ繝?腰菴阪?
182             * 譚｡莉ｶ蠑上ｒ逕滓?縺励∪縺吶?
183             *
184             * @param       droles  "|"縺ｧ蛹ｺ蛻?ｉ繧後◆ 繝??繧ｿ繝ｭ繝ｼ繝ｫ譁?ｭ怜?
185             * @param systemId 繧ｷ繧ｹ繝?ΒID
186             * @param appInfo 謗･邯壽ュ蝣ｱ
187             *
188             * @return 繝??繧ｿ繝ｭ繝ｼ繝ｫ繧ｪ繝悶ず繧ｧ繧ｯ繝?
189             */
190            public static DataRole newInstance( final String droles, final String systemId, final ApplicationInfo appInfo ) {
191                    if( droles == null || droles.length() == 0 ) {
192                            return FULL_ACCESS_DATAROLE_OBJ;
193                    }
194                    else if( FULL_DENY_DROLES_KEY.equals( droles ) ) {
195                            return FULL_DENY_DATAROLE_OBJ;
196                    }
197    
198    //              DataRole dataRole = new DataRole( droles, systemId, appInfo );
199    //              return dataRole;
200                    return new DataRole( droles, systemId, appInfo );
201            }
202    
203            /**
204             * 繝ｭ繝ｼ繝ｫ繧ｺ繧定ｿ斐＠縺ｾ縺吶?
205             *
206             * @return 繝ｭ繝ｼ繝ｫ繧ｺ譁?ｭ怜?
207             */
208            public String getDataRoles() { return droles; }
209    
210            /**
211             * 繝ｭ繝ｼ繝ｫ繧ｺ繧定ｿ斐＠縺ｾ縺吶?
212             *
213             * @og.rev 4.4.0.1 (2009/08/08) 繝??繝悶ΝID縺御ｻ伜刈縺輔ｌ縺ｦ縺?ｋ蝣ｴ蜷医?譚｡莉ｶ繧定ｿｽ蜉?
214             *
215             * @param clm 繧ｫ繝ｩ繝?錐
216             *
217             * @return 繝ｭ繝ｼ繝ｫ繧ｺ譁?ｭ怜?
218             */
219            public String getCondition( final String clm ) {
220                    if( isFullAcess ) { return FULL_ACCESS_CONDITION; }
221                    if( isFullDeny ) { return "(" + clm + FULL_DENY_CONDITION + ")"; }
222    
223                    String rtn = null;
224                    if( clm.indexOf( '.' ) >= 0 ) {
225                            String clmTmp = clm.substring( clm.lastIndexOf( '.' ) + 1 );
226                            rtn = cdtnMap.get( clmTmp );
227                            if( rtn == null || rtn.length() == 0 ) {
228                                    return "(" + clm + FULL_DENY_CONDITION + ")";
229                            }
230                            return "(" + rtn.replace( clmTmp, clm ) + ")";
231                    }
232                    else {
233                            rtn = cdtnMap.get( clm );
234                            if( rtn == null || rtn.length() == 0 ) {
235                                    return "(" + clm + FULL_DENY_CONDITION + ")";
236                            }
237                            return "(" + rtn + ")";
238                    }
239            }
240    
241            /** 繧ｪ繝悶ず繧ｧ繧ｯ繝医?隴伜挨蟄舌→縺励※?瑚ｩｳ邏ｰ縺ｪ繝ｦ繝ｼ繧ｶ繝ｼ諠??繧定ｿ斐＠縺ｾ縺吶?
242             *
243             * @return  隧ｳ邏ｰ縺ｪ逕ｻ髱｢諠??
244             */
245            @Override
246            public String toString() {
247                    StringBuilder rtn = new StringBuilder( HybsSystem.BUFFER_MIDDLE );
248                    rtn.append( "droles  : " ).append( droles ).append( HybsSystem.CR );
249                    return rtn.toString();
250            }
251    }