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.HashMap;
019    import java.util.HashSet;
020    import java.util.Map;
021    import java.util.Set;
022    
023    import org.opengion.fukurou.util.StringUtil;
024    
025    /**
026     * 繧ｨ繝?ぅ繝?ヨ險ｭ螳壽ュ蝣ｱ繧堤ｮ｡逅?☆繧九◆繧√?繝??繧ｿ邂｡逅?け繝ｩ繧ｹ縺ｧ縺吶?
027     * 縺薙％縺ｧ邂｡逅?＆繧後ｋ蜷?ヱ繝ｩ繝｡繝ｼ繧ｿ繝ｼ縺ｮ諢丞袖縺ｯ莉･荳九?騾壹ｊ縺ｧ縺吶?
028     * (蜷?う繝ｳ繝?ャ繧ｯ繧ｹ逡ｪ蜿ｷ縺ｯ縲∝?驛ｨ逧?↓邂｡逅?＆繧後※縺?ｋ繧､繝ｳ繝?ャ繧ｯ繧ｹ逡ｪ蜿ｷ繧呈э蜻ｳ縺励∪縺?
029     *
030     * 繝ｻ0:繧ｨ繝?ぅ繝?ヨ蜷?
031     *       縺薙?繧ｨ繝?ぅ繝?ヨ險ｭ螳壹が繝悶ず繧ｧ繧ｯ繝医?蜷咲ｧｰ縺ｧ縺吶?
032     * 繝ｻ1:陦ｨ遉ｺ繧ｫ繝ｩ繝?
033     *       陦ｨ遉ｺ蟇ｾ雎｡縺ｨ縺ｪ繧九き繝ｩ繝?ｸ?ｦｧ縺ｧ縺吶?繧ｫ繝ｳ繝槫玄蛻?ｊ縺ｧ謖?ｮ壹＠縺ｾ縺吶?
034     *       縺薙?荳?ｦｧ縺ｫ縺ｯ縲?撼陦ｨ遉ｺ縺ｮ繧ｫ繝ｩ繝?ｂ蜷医ｏ縺帙※邂｡逅?＆繧後?髱櫁｡ｨ遉ｺ繧ｫ繝ｩ繝?↓縺､縺?※縺ｯ縲?
035     *       繧ｫ繝ｩ繝?錐縺ｮ蜈磯?縺ｫ"!"繧偵▽縺代∪縺吶?
036     *       萓? AAA,!BBB,CCC 竍?AAA,CCC縺ｮ鬆?↓陦ｨ遉ｺ(BBB縺ｯ髱櫁｡ｨ遉ｺ)
037     * 繝ｻ2:髮?ｨ医き繝ｩ繝?
038     *       蜷??繧担UM縺吶ｋ蟇ｾ雎｡縺ｨ縺ｪ繧九き繝ｩ繝?〒縺吶?(繧ｫ繝ｳ繝槫玄蛻?ｊ縺ｧ隍?焚謖?ｮ壹′蜿ｯ閭ｽ)
039     *       縺薙％縺ｧ謖?ｮ壹＆繧後◆繧ｫ繝ｩ繝??謨ｰ蛟､蝙九〒縺ゅｋ蠢?ｦ√′縺ゅｊ縺ｾ縺吶?
040     *       SQL讒区枚縺ｫ縺翫￠繧九?SUM髢｢謨ｰ縺ｮ蠑墓焚縺ｨ縺励※謖?ｮ壹☆繧九き繝ｩ繝?↓逶ｸ蠖薙＠縺ｾ縺吶?
041     * 繝ｻ3:繧ｰ繝ｫ繝ｼ繝励き繝ｩ繝?
042     *       髮?ｨ医き繝ｩ繝??蜷??繧偵げ繝ｫ繝ｼ繝斐Φ繧ｰ縺吶ｋ縺溘ａ縺ｮ繧ｫ繝ｩ繝?〒縺吶?(繧ｫ繝ｳ繝槫玄蛻?ｊ縺ｧ隍?焚謖?ｮ壹′蜿ｯ閭ｽ)
043     *       SQL讒区枚縺ｫ縺翫￠繧九?GROUP BY縺ｫ謖?ｮ壹☆繧九き繝ｩ繝?↓逶ｸ蠖薙＠縺ｾ縺吶?
044     * 繝ｻ4:蟆剰ｨ医き繝ｩ繝?
045     *       髮?ｨ医き繝ｩ繝??蜷??縺ｫ蟇ｾ縺励?蟆剰ｨ郁｡後ｒ莉伜刈縺吶ｋ縺溘ａ縺ｮ繝悶Ξ繧､繧ｯ繧ｭ繝ｼ繧呈欠螳壹＠縺ｾ縺吶?(繧ｫ繝ｳ繝槫玄蛻?ｊ縺ｧ隍?焚謖?ｮ壹′蜿ｯ閭ｽ)
046     * 繝ｻ5:蜷郁ｨ医き繝ｩ繝?
047     *       髮?ｨ医き繝ｩ繝??蜷??縺ｫ蟇ｾ縺励?蜷郁ｨ郁｡後ｒ莉伜刈縺吶ｋ縺溘ａ縺ｮ繝悶Ξ繧､繧ｯ繧ｭ繝ｼ繧呈欠螳壹＠縺ｾ縺吶?(繧ｫ繝ｳ繝槫玄蛻?ｊ縺ｧ隍?焚謖?ｮ壹′蜿ｯ閭ｽ)
048     * 繝ｻ6:邱丞粋險医ヵ繝ｩ繧ｰ
049     *       髮?ｨ医き繝ｩ繝??蜷??縺ｫ蟇ｾ縺励?邱丞粋險郁｡後ｒ莉伜刈縺吶ｋ縺九←縺?°繧呈欠螳壹＠縺ｾ縺吶?(0莉･螟?霑ｽ蜉?☆繧?0:霑ｽ蜉?＠縺ｪ縺?
050     * 繝ｻ7:陦ｨ遉ｺ鬆?き繝ｩ繝?
051     *       繝??繧ｿ縺ｮ陦ｨ遉ｺ鬆?ｒ縺昴?鬆?分縺ｫ繧ｫ繝ｳ繝槫玄蛻?ｊ縺ｧ謖?ｮ壹＠縺ｾ縺吶?
052     *       繧ｫ繝ｩ繝?錐縺ｮ蜈磯?縺ｫ"!"繧偵▽縺代◆蝣ｴ蜷医?縲√◎縺ｮ繧ｫ繝ｩ繝??髯埼?縺ｧ陦ｨ遉ｺ縺輔ｌ縺ｾ縺吶?
053     *       SQL讒区枚縺ｫ縺翫￠繧九?orderby蜿･縺ｫ逶ｸ蠖薙＠縺ｾ縺吶?
054     * 繝ｻ8:蜈ｱ騾壹ヵ繝ｩ繧ｰ
055     *       縺薙?繧ｨ繝?ぅ繝?ヨ險ｭ螳壹が繝悶ず繧ｧ繧ｯ繝医′縲∝?騾?蜈ｨ繝ｦ繝ｼ繧ｶ繝ｼ蜈ｬ髢?繧ｨ繝?ぅ繝?ヨ縺九←縺?°繧?
056     *       謖?ｮ壹＠縺ｾ縺吶?(0莉･螟?蜈ｱ騾?0:蛟倶ｺｺ縺ｮ縺ｿ)
057     *
058     * @og.rev 5.3.6.0 (2011/06/01) 譁ｰ隕剰ｿｽ蜉?
059     *
060     * @version  5.0
061     * @author   Hiroki Nakamura
062     * @since    JDK6.0,
063     */
064    public class DBEditConfig {
065    
066            private static final int EDIT_KEY_NAME          = 0;
067            private static final int EDIT_KEY_VIEW          = 1;
068            private static final int EDIT_KEY_SUM           = 2;
069            private static final int EDIT_KEY_GROUP         = 3;
070            private static final int EDIT_KEY_SUBTOTAL      = 4;
071            private static final int EDIT_KEY_TOTAL         = 5;
072            private static final int EDIT_KEY_GRANDTOTAL= 6;
073            private static final int EDIT_KEY_ORDERBY       = 7;
074            private static final int EDIT_KEY_COMMON        = 8;
075    
076            private static final String[] EDIT_KEYS
077                    = { "NAME", "VIEW", "SUM", "GROUP", "SUBTOTAL", "TOTAL", "GRANDTOTAL", "ORDERBY", "COMMON" };
078    
079            private static final int EDIT_KEYS_LENGTH       = EDIT_KEYS.length;
080    
081            private final String[] editVals = new String[EDIT_KEYS_LENGTH];
082    
083            private int sumClmCount;
084            private int groupClmCount;
085            private int subTotalClmCount;
086            private int totalClmCount;
087            private final Map<String,String> orderMap = new HashMap<String,String>();
088            private String orderByDescClms;
089    
090            /**
091             * 繧ｳ繝ｳ繧ｹ繝医Λ繧ｯ繧ｿ
092             *
093             * 遨ｺ縺ｮ繧ｨ繝?ぅ繝?ヨ險ｭ螳壹が繝悶ず繧ｧ繧ｯ繝医ｒ讒狗ｯ峨＠縺ｾ縺吶?
094             */
095            public DBEditConfig() {
096            }
097    
098            /**
099             * 繧ｳ繝ｳ繧ｹ繝医Λ繧ｯ繧ｿ
100             *
101             * 蜷?ｨｮ繝代Λ繝｡繝ｼ繧ｿ繝ｼ繧呈欠螳壹＠縺ｦ繧ｨ繝?ぅ繝?ヨ險ｭ螳壹が繝悶ず繧ｧ繧ｯ繝医ｒ讒狗ｯ峨＠縺ｾ縺吶?
102             *
103             * @param editName 繧ｨ繝?ぅ繝?ヨ蜷咲ｧｰ
104             * @param viewClms 逕ｻ髱｢陦ｨ遉ｺ繧ｫ繝ｩ繝?
105             * @param sumClms 髮?ｨ医き繝ｩ繝?
106             * @param groupClms 繧ｰ繝ｫ繝ｼ繝励き繝ｩ繝?
107             * @param subTotalClms 蟆剰ｨ医き繝ｩ繝?
108             * @param totalClms 蜷郁ｨ医き繝ｩ繝?
109             * @param useGrandTotal 邱丞粋險郁｡後ｒ霑ｽ蜉?☆繧九°(1:霑ｽ蜉?☆繧?1莉･螟?霑ｽ蜉?＠縺ｪ縺?
110             * @param orderByClms 陦ｨ遉ｺ鬆?
111             * @param isCommon 蜈ｱ騾壹お繝?ぅ繝?ヨ縺九←縺?°(1:蜈ｱ騾?1莉･螟?蛟倶ｺｺ縺ｮ縺ｿ)
112             */
113            public DBEditConfig( final String editName, final String viewClms
114                                                    , final String sumClms, final String groupClms
115                                                    , final String subTotalClms, final String totalClms
116                                                    , final String useGrandTotal, final String orderByClms
117                                                    , final String isCommon ) {
118    
119                    editVals[EDIT_KEY_NAME]                 = editName;
120                    editVals[EDIT_KEY_VIEW]                 = viewClms;
121                    editVals[EDIT_KEY_SUM]                  = sumClms;
122                    editVals[EDIT_KEY_GROUP]                = groupClms;
123                    editVals[EDIT_KEY_SUBTOTAL]             = subTotalClms;
124                    editVals[EDIT_KEY_TOTAL]                = totalClms;
125                    editVals[EDIT_KEY_GRANDTOTAL]   = useGrandTotal;
126                    editVals[EDIT_KEY_ORDERBY]              = orderByClms;
127                    editVals[EDIT_KEY_COMMON]               = isCommon;
128    
129                    init();
130            }
131    
132            /**
133             * 繧ｳ繝ｳ繧ｹ繝医Λ繧ｯ繧ｿ
134             *
135             * 蜷?ｨｮ繝代Λ繝｡繝ｼ繧ｿ繝ｼ繧帝?蛻励〒謖?ｮ壹＠縺ｦ繧ｨ繝?ぅ繝?ヨ險ｭ螳壹が繝悶ず繧ｧ繧ｯ繝医ｒ讒狗ｯ峨＠縺ｾ縺吶?
136             * 蜷?ヱ繝ｩ繝｡繝ｼ繧ｿ縺ｮ驟榊?繧､繝ｳ繝?ャ繧ｯ繧ｹ縺ｯ縲＋@link #getEditKeys(String,String)}縺ｧ霑斐＆繧後ｋ
137             * 繧ｭ繝ｼ荳?ｦｧ縺ｮ驟榊?繧､繝ｳ繝?ャ繧ｯ繧ｹ縺ｨ荳??縺励∪縺吶?
138             * 蜷?ヱ繝ｩ繝｡繝ｼ繧ｿ繝ｼ縺ｮ諢丞袖縺ｫ縺､縺?※縺ｯ縲√け繝ｩ繧ｹ縺ｮJavadoc{@link DBEditConfig}繧貞盾辣ｧ縺励※荳九＆縺??
139             *
140             * @param editVals 險ｭ螳壼?(驟榊?)
141             * @see DBEditConfig
142             * @see #getEditKeys(String,String)
143             **/
144            public DBEditConfig( final String[] editVals ) {
145                    System.arraycopy( editVals, 0, this.editVals, 0, editVals.length );
146                    init();
147            }
148    
149            /**
150             * 繧ｨ繝?ぅ繝?ヨ險ｭ螳壹が繝悶ず繧ｧ繧ｯ繝井ｽ懈?譎ゅ?蛻晄悄蛹門?逅?〒縺吶?
151             * 繧ｳ繝ｳ繧ｹ繝医Λ繧ｯ繧ｿ縺ｮ蠑墓焚縺ｫ蝓ｺ縺･縺榊?驛ｨ螟画焚縺ｮ蛻晄悄險ｭ螳壹ｒ陦後＞縺ｾ縺吶?
152             */
153            private void init() {
154                    sumClmCount = StringUtil.csv2Array( editVals[EDIT_KEY_SUM] ).length;
155                    groupClmCount = StringUtil.csv2Array( editVals[EDIT_KEY_GROUP] ).length;
156                    subTotalClmCount = StringUtil.csv2Array( editVals[EDIT_KEY_SUBTOTAL] ).length;
157                    totalClmCount = StringUtil.csv2Array( editVals[EDIT_KEY_TOTAL] ).length;
158    
159                    if( editVals[EDIT_KEY_ORDERBY] != null ) {
160                            StringBuilder buf = new StringBuilder();
161                            String[] ary = StringUtil.csv2Array( editVals[EDIT_KEY_ORDERBY] );
162                            for( int i=0; i<ary.length ;i++ ) {
163                                    String str = ary[i];
164                                    if( str.startsWith( "!" ) ) {
165                                            str = str.substring( 1 );
166                                            if( buf.length() > 0 ) { buf.append( "," ); }
167                                            buf.append( str );
168                                    }
169                                    orderMap.put( str, String.valueOf( i+1 ) );
170                            }
171                            orderByDescClms = buf.toString();
172                    }
173                    else {
174                            orderByDescClms = null;
175                    }
176            }
177    
178            /**
179             * 繧ｭ繝ｼ驟榊?縺九ｉ逕ｻ髱｢ID縺ｨ繧ｨ繝?ぅ繝?ヨ蜷咲ｧｰ縺ｮ繝壹い縺ｮ荳?ｦｧ繧貞叙繧雁?縺励∪縺吶?
180             *
181             * 繧ｭ繝ｼ驟榊?縺九ｉ"EDIT_NAME_"縺ｧ蟋九∪繧九く繝ｼ繧呈､懃ｴ｢縺励?"EDIT_NAME_(逕ｻ髱｢ID)_(繧ｨ繝?ぅ繝?ヨ蜷?"
182             * 縺ｨ險?≧蠖｢蠑上↓蝓ｺ縺･縺阪?逕ｻ髱｢ID縺ｨ繧ｨ繝?ぅ繝?ヨ蜷咲ｧｰ縺ｮ繝壹い繧貞叙繧雁?縺励∪縺吶?
183             *
184             * 逕ｻ髱｢ID縺ｨ繧ｨ繝?ぅ繝?ヨ蜷咲ｧｰ縺ｯ驟榊?縺ｨ縺励※菫晏ｭ倥＆繧?繧､繝ｳ繝?ャ繧ｯ繧ｹ逡ｪ蜿ｷ縺ｯ 0:逕ｻ髱｢ID縲?:繧ｨ繝?ぅ繝?ヨ蜷?
185             * 縺昴?荳?ｦｧ縺後＆繧後ｉ縺ｫ驟榊?縺ｫ譬ｼ邏阪＆繧後※霑斐＆繧後∪縺吶?
186             *
187             * @param keys 繧ｭ繝ｼ驟榊?
188             *
189             * @return 逕ｻ髱｢ID縺ｨ繧ｨ繝?ぅ繝?ヨ蜷咲ｧｰ縺ｮ繝壹い縺ｮ荳?ｦｧ
190             */
191            public static String[][] getKeySet( final String[] keys ) {
192                    if( keys == null || keys.length == 0 ) { return null; }
193    
194                    Set<String[]> keySet = new HashSet<String[]>();
195                    for( String key : keys ) {
196                            if ( key != null && key.startsWith( "EDIT_NAME_" ) ) {
197                                    String guikeyEditName = key.substring( ( "EDIT_NAME_" ).length() );
198                                    if( guikeyEditName.indexOf( '_' ) >= 0 ) {
199                                            String guikey = guikeyEditName.substring( 0, guikeyEditName.indexOf( '_' ) );
200                                            String editName = guikeyEditName.substring( ( guikey + "_" ).length() );
201                                            if( guikey != null && guikey.length() > 0 && editName != null && editName.length() > 0 ) {
202                                                    String[] set = { guikey, editName };
203                                                    keySet.add( set );
204                                            }
205                                    }
206                            }
207                    }
208    //              return keySet.toArray( new String[0][] );
209                    return keySet.toArray( new String[keySet.size()][] );
210            }
211    
212            /**
213             * 逕ｻ髱｢ID縲√お繝?ぅ繝?ヨ蜷阪ｒ繧ｭ繝ｼ縺ｫ縲√お繝?ぅ繝?ヨ險ｭ螳壹が繝悶ず繧ｧ繧ｯ繝医?蜷?ｨｭ螳壼?縺ｮ
214             * 邂｡逅?く繝ｼ繧呈欠螳壹＠縺ｾ縺吶?
215             *
216             * 繧ｨ繝?ぅ繝?ヨ險ｭ螳壹が繝悶ず繧ｧ繧ｯ繝医〒邂｡逅?＆繧後ｋ蜷?く繝ｼ縺ｫ蟇ｾ縺励※縲?
217             * "EDIT_[KEY]_(逕ｻ髱｢ID)_(繧ｨ繝?ぅ繝?ヨ蜷?"縺ｨ縺?≧繧ｭ繝ｼ繧堤函謌舌＠縲√％繧後ｒ驟榊?縺ｫ縺励※霑斐＠縺ｾ縺吶?
218             *
219             * @param guikey 逕ｻ髱｢ID
220             * @param editName 繧ｨ繝?ぅ繝?ヨ蜷?
221             *
222             * @return 繧ｨ繝?ぅ繝?ヨ險ｭ螳壹ｒ邂｡逅?☆繧九◆繧√?繧ｭ繝ｼ荳?ｦｧ
223             */
224            public static String[] getEditKeys( final String guikey, final String editName ) {
225                    String[] rtn = new String[EDIT_KEYS_LENGTH];
226                    for( int i=0; i<EDIT_KEYS_LENGTH; i++ ) {
227                            rtn[i] = "EDIT_" + EDIT_KEYS[i] + "_" + guikey + "_" + editName;
228                    }
229                    return rtn;
230            }
231    
232            /**
233             * 繧ｨ繝?ぅ繝?ヨ險ｭ螳壹が繝悶ず繧ｧ繧ｯ繝医?蜷?ｨｭ螳壼?繧帝?蛻励↓縺励※霑斐＠縺ｾ縺吶?
234             *
235             * 驟榊?縺ｮ繧､繝ｳ繝?ャ繧ｯ繧ｹ逡ｪ蜿ｷ縺ｯ縲＋@link #getEditKeys(String,String)}縺ｧ逕滓?縺輔ｌ繧九く繝ｼ縺ｮ
236             * 繧､繝ｳ繝?ャ繧ｯ繧ｹ逡ｪ蜿ｷ縺ｨ荳??縺励∪縺吶?
237             *
238             * @return 繧ｨ繝?ぅ繝?ヨ險ｭ螳壹が繝悶ず繧ｧ繧ｯ繝医?險ｭ螳壼?荳?ｦｧ(驟榊?)
239             * @see #getEditKeys(String,String)
240             */
241            public String[] getEditVals() {
242                    String[] rtn = new String[editVals.length];
243                    System.arraycopy( editVals, 0, rtn, 0, editVals.length );
244                    return rtn;
245            }
246    
247            /**
248             * 繧ｨ繝?ぅ繝?ヨ蜷阪ｒ霑斐＠縺ｾ縺吶?
249             *
250             * @return 繧ｨ繝?ぅ繝?ヨ蜷?
251             */
252            public String getEditName() {
253                    return editVals[EDIT_KEY_NAME];
254            }
255    
256            /**
257             * 陦ｨ遉ｺ繧ｫ繝ｩ繝?錐縺ｮ荳?ｦｧ繧偵き繝ｳ繝槫玄蛻?ｊ縺ｧ霑斐＠縺ｾ縺吶?
258             * 髱櫁｡ｨ遉ｺ繧ｫ繝ｩ繝?↓縺､縺?※縺ｯ縲√き繝ｩ繝?錐縺ｮ蜈磯?縺ｫ"!"繧偵▽縺代※霑斐＆繧後∪縺吶?
259             * 萓? AAA,!BBB,CCC 竍?AAA,CCC縺ｮ鬆?↓陦ｨ遉ｺ(BBB縺ｯ髱櫁｡ｨ遉ｺ)
260             *
261             * @return 陦ｨ遉ｺ繧ｫ繝ｩ繝?錐荳?ｦｧ(繧ｫ繝ｳ繝槫玄蛻?ｊ)
262             */
263            public String getViewClms() {
264                    return editVals[EDIT_KEY_VIEW];
265            }
266            
267            /**
268             * 陦ｨ遉ｺ繧ｫ繝ｩ繝?CSV蠖｢蠑?繧偵メ繧ｧ繝?け縺励?螟画峩縺後≠繧後?縲∝渚譏?＠縺溘き繝ｩ繝?ｒ菴懈?縺励∪縺吶?
269             *
270             * 陦ｨ遉ｺ繧ｫ繝ｩ繝??縲∽ｸｦ縺ｳ鬆?ｄ髱櫁｡ｨ遉ｺ繝槭?繧ｫ繝ｼ(!)縺ｪ縺ｩ縺悟刈蜻ｳ縺輔ｌ縲√Θ繝ｼ繧ｶ繝ｼ縲∫判髱｢縺斐→縺ｫ
271             * 繝??繧ｿ繝吶?繧ｹ縺ｫ險倬鹸縺輔ｌ縺ｦ縺?∪縺吶?JSP繧ｽ繝ｼ繧ｹ繧剃ｿｮ豁｣縺励◆蝣ｴ蜷医?繝??繧ｿ繝吶?繧ｹ縺ｫ
272             * 譖ｸ縺崎ｾｼ縺ｾ繧後◆陦ｨ遉ｺ繧ｫ繝ｩ繝??縲∝渚譏?＆繧後↑縺?◆繧√?繧ｫ繝ｩ繝?∈謚樒判髱｢遲峨↓陦ｨ遉ｺ縺輔ｌ縺ｾ縺帙ｓ縲?
273             * 縺昴％縺ｧ縲√が繝ｪ繧ｸ繝翫Ν縺ｮ繧ｫ繝ｩ繝?↓霑ｽ蜉?＆繧後◆蝣ｴ蜷医?縲√き繝ｩ繝?ｒ豈碑ｼ?☆繧九％縺ｨ縺ｧ縲?
274             * 霑ｽ蜉??縺ｮ繧ｫ繝ｩ繝?ｒ縲?撼陦ｨ遉ｺ繧ｫ繝ｩ繝?→縺励※縲∝ｾ後ｍ縺ｫ霑ｽ險倥＠縺ｾ縺吶?
275             * 蜑企勁縺輔ｌ縺溷?蜷医?縲〃iewForm 縺ｧ隴ｦ蜻願｡ｨ遉ｺ縺吶ｋ縺薙→縺ｧ縲√Θ繝ｼ繧ｶ繝ｼ縺ｫ螟画峩繧剃ｿ?＠縺ｾ縺吶?
276             *
277             * @og.rev 5.8.2.0 (2014/12/05) JSP菫ｮ豁｣譎ゅ?霑ｽ蜉?き繝ｩ繝?ｯｾ蠢?
278             *
279             * @param       orgClms         繧ｪ繝ｪ繧ｸ繝翫Ν縺ｮ繧ｫ繝ｩ繝?CSV蠖｢蠑?
280             *
281             * @return      螟画峩蠕後?陦ｨ遉ｺ繧ｫ繝ｩ繝?CSV蠖｢蠑?
282             */
283            public String getViewClms( final String orgClms ) {
284                    String viewClms = editVals[EDIT_KEY_VIEW];
285    
286                    if( orgClms == null || orgClms.isEmpty() ) { return viewClms; }         // orgClms 縺後↑縺代ｌ縺ｰ縲」iewClms 繧定ｿ斐☆縲?
287                    // 蝓ｺ譛ｬ逧?↓縺ｯ縲∽ｸ｡閠??繧ｫ繝ｩ繝??縲∽ｸ??縺吶ｋ縺ｯ縺壹?
288                    String[] vclms = viewClms.split( "," );         // 陦ｨ遉ｺ鬆??髱櫁｡ｨ遉ｺ蜃ｦ逅?ｒ陦後▲縺溘き繝ｩ繝?
289                    String[] fclms = orgClms.split( "," );          // 蜈??縺ｮ陦ｨ遉ｺ蜿ｯ閭ｽ繧ｫ繝ｩ繝?☆縺ｹ縺ｦ(fullClms)
290    
291                    // 陦ｨ遉ｺ蜿ｯ閭ｽ繧ｫ繝ｩ繝?☆縺ｹ縺ｦ縺ｮ Set 繧剃ｽ懈?縺励∪縺吶?
292                    Set<String> fset = new HashSet<String>();
293                    for( int i=0; i<fclms.length; i++ ) {                // orgClms 繧担et 縺ｫ霑ｽ蜉?＠縺ｾ縺吶?
294                            fset.add( fclms[i] );
295                    }
296    
297                    // 髱櫁｡ｨ遉ｺ繧ｫ繝ｩ繝??蜀??陦ｨ遉ｺ蜿ｯ閭ｽ繧ｫ繝ｩ繝?↓蟄伜惠縺励↑縺??縺?￠縺ｮ Set 繧剃ｽ懈?縺励∪縺吶?        
298                    // 縺ｾ縺溘?陦ｨ遉ｺ蜿ｯ閭ｽ繧ｫ繝ｩ繝?°繧峨?鬆?分縺ｫ縲」iewClms 縺ｮ蛟､繧貞炎髯､縺励※縺?″縺ｾ縺吶?
299                    Set<String> vset = new HashSet<String>();
300                    StringBuilder vbuf = new StringBuilder();       // 譁ｰ縺励＞ viewClms 菴懈?逕ｨ
301                    for( int i=0; i<vclms.length; i++ ) {                // viewClms 繧担et 縺ｫ霑ｽ蜉?＠縺ｾ縺吶?
302                            String clm = vclms[i];
303                            if( clm == null || clm.isEmpty() ) { continue; }                        // 6.0.2.5 (2014/10/31) 貎懷惠繝舌げ??蜈磯?縺ｫ"," 縺梧擂繧九→繧｢繝吶Φ繝峨☆繧九?
304                            clm = clm.charAt(0) == '!' ? clm.substring(1) : clm ;           // 髱櫁｡ｨ遉ｺ縺ｮ (!) 縺ｯ蜑企勁縺励∪縺吶?
305                            if( fset.remove( clm ) ) {                              // fullSet 縺ｫ縺ゅｌ縺ｰ縲∝炎髯､縺吶ｋ縺ｨ縺ｨ繧ゅ↓縲∵眠viewClms繧剃ｽ懈?縺吶ｋ縲?
306                                    if( vbuf.length() > 0 ) { vbuf.append(','); }        // 譛??莉･髯阪?縲√き繝ｳ繝槭〒騾｣邨舌☆繧九?             // 6.0.2.5 (2014/10/31) char 繧?append 縺吶ｋ縲?
307                                    vbuf.append( vclms[i] );                        // append 縺吶ｋ縺ｮ縺ｯ縲?!) 莉倥?繧ｫ繝ｩ繝?
308                            }
309                            else {
310                                    vset.add( clm );                                        // fullSet 縺ｫ縺ｪ縺代ｌ縺ｰ縲」iewSet 縺ｫ霑ｽ蜉?
311                            }
312                    }
313    
314                    // 縺薙?谿ｵ髫弱〒縲’set縲」set 縺ｨ繧ゅ↓縲√◎繧後◇繧檎峡閾ｪ縺ｮ繧ｫ繝ｩ繝?′谿九▲縺ｦ縺?ｋ縲?
315                    // 縺ｩ縺｡繧峨ｂ縲∵ｮ九▲縺ｦ縺?↑縺代ｌ縺ｰ縲∵ｭ｣蟶ｸ縺ｪ縺ｮ縺ｧ縲」iewClms 繧定ｿ斐☆縲?
316                    if( vset.isEmpty() && fset.isEmpty() ) { return viewClms; }
317    
318                    // fullSet 縺ｫ繧ｫ繝ｩ繝?′谿九▲縺ｦ縺?ｌ縺ｰ縲?撼陦ｨ遉ｺ縺ｧ縲∵眠viewClms縺ｫ縲∬ｿｽ蜉?☆繧九?
319                    if( !fset.isEmpty() ) {
320                            String[] defClms = fset.toArray( new String[fset.size()] );
321                            for( int i=0; i<defClms.length; i++ ) {
322                                    if( vbuf.length() > 0 ) { vbuf.append(','); }        // 6.0.2.5 (2014/10/31) 譛??莉･髯阪?縲√き繝ｳ繝槭〒騾｣邨舌☆繧九?
323                                    vbuf.append('!').append( defClms[i] );                                          // 髱櫁｡ｨ遉ｺ繧ｫ繝ｩ繝?→縺励※縲∝ｾ後ｍ縺ｫ霑ｽ蜉?☆繧九?
324                            }
325                    }
326                    viewClms = vbuf.toString();
327    
328                    editVals[EDIT_KEY_VIEW] = viewClms;
329                    return viewClms;
330            }
331    
332            /**
333             * 髮?ｨ医き繝ｩ繝??荳?ｦｧ繧偵き繝ｳ繝槫玄蛻?ｊ縺ｧ霑斐＠縺ｾ縺吶?
334             *
335             * @return 髮?ｨ医き繝ｩ繝??荳?ｦｧ(繧ｫ繝ｳ繝槫玄蛻?
336             */
337            public String getSumClms() {
338                    return editVals[EDIT_KEY_SUM];
339            }
340    
341            /**
342             * 髮?ｨ亥?逅?ｒ陦後≧縺九←縺?°繧定ｿ斐＠縺ｾ縺吶?
343             * 縺薙ｌ縺ｯ縲?寔險医き繝ｩ繝?′謖?ｮ壹＆繧後※縺?ｋ縺九?縺ｨ蜷後§諢丞袖縺ｧ縺吶?
344             *
345             * @return true:蟇ｾ雎｡ false:髱槫ｯｾ雎｡
346             */
347            public boolean useSum() {
348                    return ( editVals[EDIT_KEY_SUM] != null && editVals[EDIT_KEY_SUM].length() > 0 );
349            }
350    
351            /**
352             * 謖?ｮ壹＆繧後◆繧ｫ繝ｩ繝?′髮?ｨ亥ｯｾ雎｡縺ｮ繧ｫ繝ｩ繝?°縺ｩ縺?°繧定ｿ斐＠縺ｾ縺吶?
353             *
354             * @param clm 繧ｫ繝ｩ繝?
355             *
356             * @return true:蟇ｾ雎｡ false:髱槫ｯｾ雎｡
357             */
358            public boolean isSumClm( final String clm ) {
359                    if( clm == null || editVals[EDIT_KEY_SUM] == null ) { return false; }
360                    return ( ( ","+editVals[EDIT_KEY_SUM]+"," ).indexOf( ","+clm+"," ) >= 0 );
361            }
362    
363            /**
364             * 髮?ｨ医き繝ｩ繝??繧ｫ繝ｩ繝?焚繧定ｿ斐＠縺ｾ縺吶?
365             *
366             * @return 髮?ｨ医き繝ｩ繝??繧ｫ繝ｩ繝?焚
367             */
368            public int getSumClmCount() {
369                    return sumClmCount;
370            }
371    
372            /**
373             * 繧ｰ繝ｫ繝ｼ繝励き繝ｩ繝??荳?ｦｧ繧偵き繝ｳ繝槫玄蛻?ｊ縺ｧ霑斐＠縺ｾ縺吶?
374             *
375             * @return 繧ｰ繝ｫ繝ｼ繝励き繝ｩ繝??荳?ｦｧ(繧ｫ繝ｳ繝槫玄蛻?
376             */
377            public String getGroupClms() {
378                    return editVals[EDIT_KEY_GROUP];
379            }
380    
381            /**
382             * 繧ｰ繝ｫ繝ｼ繝怜?逅?ｒ陦後≧縺九←縺?°繧定ｿ斐＠縺ｾ縺吶?
383             * 縺薙ｌ縺ｯ縲√げ繝ｫ繝ｼ繝励き繝ｩ繝?′謖?ｮ壹＆繧後※縺?ｋ縺九?縺ｨ蜷後§諢丞袖縺ｧ縺吶?
384             *
385             * @return true:蟇ｾ雎｡ false:髱槫ｯｾ雎｡
386             */
387            public boolean useGroup() {
388                    return ( editVals[EDIT_KEY_GROUP] != null && editVals[EDIT_KEY_GROUP].length() > 0 );
389            }
390    
391            /**
392             * 謖?ｮ壹＆繧後◆繧ｫ繝ｩ繝?′繧ｰ繝ｫ繝ｼ繝怜ｯｾ雎｡縺ｮ繧ｫ繝ｩ繝?°縺ｩ縺?°繧定ｿ斐＠縺ｾ縺吶?
393             *
394             * @param clm 繧ｫ繝ｩ繝?
395             *
396             * @return true:蟇ｾ雎｡ false:髱槫ｯｾ雎｡
397             */
398            public boolean isGroupClm( final String clm ) {
399                    if( clm == null || editVals[EDIT_KEY_GROUP] == null ) { return false; }
400                    return ( ( ","+editVals[EDIT_KEY_GROUP]+"," ).indexOf( ","+clm+"," ) >= 0 );
401            }
402    
403            /**
404             * 繧ｰ繝ｫ繝ｼ繝励き繝ｩ繝??繧ｫ繝ｩ繝?焚繧定ｿ斐＠縺ｾ縺吶?
405             *
406             * @return 繧ｰ繝ｫ繝ｼ繝励き繝ｩ繝??繧ｫ繝ｩ繝?焚
407             */
408            public int getGroupClmCount() {
409                    return groupClmCount;
410            }
411    
412            /**
413             * 蟆剰ｨ医き繝ｩ繝??荳?ｦｧ繧偵き繝ｳ繝槫玄蛻?ｊ縺ｧ霑斐＠縺ｾ縺吶?
414             *
415             * @return 蟆剰ｨ医き繝ｩ繝??荳?ｦｧ(繧ｫ繝ｳ繝槫玄蛻?
416             */
417            public String getSubTotalClms() {
418                    return editVals[EDIT_KEY_SUBTOTAL];
419            }
420    
421            /**
422             * 蟆剰ｨ亥?逅?ｒ陦後≧縺九←縺?°繧定ｿ斐＠縺ｾ縺吶?
423             * 縺薙ｌ縺ｯ縲∝ｰ剰ｨ医き繝ｩ繝?′謖?ｮ壹＆繧後※縺?ｋ縺九?縺ｨ蜷後§諢丞袖縺ｧ縺吶?
424             *
425             * @return true:蟇ｾ雎｡ false:髱槫ｯｾ雎｡
426             */
427            public boolean useSubTotal() {
428                    return ( editVals[EDIT_KEY_SUBTOTAL] != null && editVals[EDIT_KEY_SUBTOTAL].length() > 0 );
429            }
430    
431            /**
432             * 謖?ｮ壹＆繧後◆繧ｫ繝ｩ繝?′蟆剰ｨ亥ｯｾ雎｡縺ｮ繧ｫ繝ｩ繝?°縺ｩ縺?°繧定ｿ斐＠縺ｾ縺吶?
433             *
434             * @param clm 繧ｫ繝ｩ繝?
435             *
436             * @return true:蟇ｾ雎｡ false:髱槫ｯｾ雎｡
437             */
438            public boolean isSubTotalClm( final String clm ) {
439                    if( clm == null || editVals[EDIT_KEY_SUBTOTAL] == null ) { return false; }
440                    return ( ( ","+editVals[EDIT_KEY_SUBTOTAL]+"," ).indexOf( ","+clm+"," ) >= 0 );
441            }
442    
443            /**
444             * 蟆剰ｨ医き繝ｩ繝??繧ｫ繝ｩ繝?焚繧定ｿ斐＠縺ｾ縺吶?
445             *
446             * @return 繧ｰ繝ｫ繝ｼ繝励き繝ｩ繝??繧ｫ繝ｩ繝?焚
447             */
448            public int getSubTotalClmCount() {
449                    return subTotalClmCount;
450            }
451    
452            /**
453             * 蜷郁ｨ医き繝ｩ繝??荳?ｦｧ繧偵き繝ｳ繝槫玄蛻?ｊ縺ｧ霑斐＠縺ｾ縺吶?
454             *
455             * @return 蜷郁ｨ医き繝ｩ繝??荳?ｦｧ(繧ｫ繝ｳ繝槫玄蛻?
456             */
457            public String getTotalClms() {
458                    return editVals[EDIT_KEY_TOTAL];
459            }
460    
461            /**
462             * 蜷郁ｨ亥?逅?ｒ陦後≧縺九←縺?°繧定ｿ斐＠縺ｾ縺吶?
463             * 縺薙ｌ縺ｯ縲∝粋險医き繝ｩ繝?′謖?ｮ壹＆繧後※縺?ｋ縺九?縺ｨ蜷後§諢丞袖縺ｧ縺吶?
464             *
465             * @return true:蟇ｾ雎｡ false:髱槫ｯｾ雎｡
466             */
467            public boolean useTotal() {
468                    return ( editVals[EDIT_KEY_TOTAL] != null && editVals[EDIT_KEY_TOTAL].length() > 0 );
469            }
470    
471            /**
472             * 謖?ｮ壹＆繧後◆繧ｫ繝ｩ繝?′蜷郁ｨ亥ｯｾ雎｡縺ｮ繧ｫ繝ｩ繝?°縺ｩ縺?°繧定ｿ斐＠縺ｾ縺吶?
473             *
474             * @param clm 繧ｫ繝ｩ繝?
475             *
476             * @return true:蟇ｾ雎｡ false:髱槫ｯｾ雎｡
477             */
478            public boolean isTotalClm( final String clm ) {
479                    if( clm == null || editVals[EDIT_KEY_TOTAL] == null ) { return false; }
480                    return ( ( ","+editVals[EDIT_KEY_TOTAL]+"," ).indexOf( ","+clm+"," ) >= 0 );
481            }
482    
483            /**
484             * 蜷郁ｨ医き繝ｩ繝??繧ｫ繝ｩ繝?焚繧定ｿ斐＠縺ｾ縺吶?
485             *
486             * @return 繧ｰ繝ｫ繝ｼ繝励き繝ｩ繝??繧ｫ繝ｩ繝?焚
487             */
488            public int getTotalClmCount() {
489                    return totalClmCount;
490            }
491    
492            /**
493             * 邱丞粋險郁｡後ｒ莉伜刈縺吶ｋ縺九←縺?°繧定ｿ斐＠縺ｾ縺吶?
494             *
495             * @return true:蟇ｾ雎｡ false:髱槫ｯｾ雎｡
496             */
497            public boolean useGrandTotal() {
498                    return StringUtil.nval( editVals[EDIT_KEY_GRANDTOTAL], false );
499            }
500    
501            /**
502             * 陦ｨ遉ｺ鬆?き繝ｩ繝?ｒ繧ｫ繝ｳ繝槫玄蛻?ｊ縺ｧ霑斐＠縺ｾ縺吶?
503             * 繧ｫ繝ｩ繝??荳ｦ縺ｳ鬆?′陦ｨ遉ｺ鬆?→縺励※縺ｮ蜆ｪ蜈磯?縺ｫ縺ｪ繧翫∪縺吶?
504             * 縺ｾ縺溘?髯埼?縺ｧ陦ｨ遉ｺ縺吶ｋ繧ｫ繝ｩ繝?↓縺､縺?※縺ｯ縲√き繝ｩ繝?錐縺ｮ蜈磯?縺ｫ"!"縺御ｻ伜刈縺輔ｌ縺ｾ縺吶?
505             *
506             * @return 讓呎ｺ夜?繧ｫ繝ｩ繝??荳?ｦｧ(繧ｫ繝ｳ繝槫玄蛻?
507             */
508            public String getOrderByClms() {
509                    return editVals[EDIT_KEY_ORDERBY];
510            }
511    
512            /**
513             * 謖?ｮ壹＆繧後◆繧ｫ繝ｩ繝??陦ｨ遉ｺ鬆??蜆ｪ蜈育分蜿ｷ繧定ｿ斐＠縺ｾ縺吶?
514             * 謖?ｮ壹き繝ｩ繝?′讓呎ｺ悶→縺励※謖?ｮ壹＆繧後※縺?↑縺??蜷医?縲?"(繧ｼ繝ｭ繧ｹ繝医Μ繝ｳ繧ｰ)繧定ｿ斐＠縺ｾ縺吶?
515             *
516             * @param clm 繧ｫ繝ｩ繝?
517             *
518             * @return 陦ｨ遉ｺ鬆??蜆ｪ蜈育分蜿ｷ
519             */
520            public String getOrder( final String clm ) {
521                    if( clm == null || editVals[EDIT_KEY_ORDERBY] == null ) { return ""; }
522    
523                    String rtn = orderMap.get( clm );
524                    return ( rtn == null ? "" : rtn );
525            }
526    
527            /**
528             * 謖?ｮ壹＆繧後◆繧ｫ繝ｩ繝??陦ｨ遉ｺ鬆?欠螳壹′髯埼?縺ｧ縺ゅｋ縺九←縺?°繧定ｿ斐＠縺ｾ縺吶?
529             * 讓呎ｺ悶→謖?ｮ壹＆繧後※縺?↑縺??蜷医?縲’alse繧定ｿ斐＠縺ｾ縺吶?
530             *
531             * @param clm 繧ｫ繝ｩ繝?
532             *
533             * @return true:髯埼? false:譏??
534             */
535            public boolean isOrderByDesc( final String clm ) {
536                    if( clm == null || orderByDescClms == null ) { return false; }
537                    return ( ( ","+orderByDescClms+"," ).indexOf( ","+clm+"," ) >= 0 );
538            }
539    
540            /**
541             * 荳ｦ縺ｳ譖ｿ縺亥?逅?ｒ陦後≧縺九←縺?°繧定ｿ斐＠縺ｾ縺吶?
542             * 縺薙ｌ縺ｯ縲∬｡ｨ遉ｺ鬆?き繝ｩ繝?′謖?ｮ壹＆繧後※縺?ｋ縺九?縺ｨ蜷後§諢丞袖縺ｧ縺吶?
543             *
544             * @return true:蟇ｾ雎｡ false:髱槫ｯｾ雎｡
545             */
546            public boolean useOrderBy() {
547                    return ( editVals[EDIT_KEY_ORDERBY] != null && editVals[EDIT_KEY_ORDERBY].length() > 0 );
548            }
549    
550            /**
551             * 縺薙?繧ｨ繝?ぅ繝?ヨ險ｭ螳壹が繝悶ず繧ｧ繧ｯ繝医′縲∝?騾?蜈ｨ繝ｦ繝ｼ繧ｶ繝ｼ蜈ｬ髢?繧ｨ繝?ぅ繝?ヨ縺?
552             * 縺ｩ縺?°繧定ｿ斐＠縺ｾ縺吶?
553             *
554             * @return 0莉･螟?蜈ｱ騾?0:蛟倶ｺｺ縺ｮ縺ｿ
555             */
556            public boolean isCommon() {
557                    return StringUtil.nval( editVals[EDIT_KEY_COMMON], false );
558            }
559    }