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.view;
017    
018    import java.io.Serializable;
019    import java.util.Arrays;
020    import java.util.Comparator;
021    import java.util.LinkedHashSet;
022    import java.util.Set;
023    import java.util.TreeSet;
024    
025    import org.opengion.fukurou.util.StringUtil;
026    import org.opengion.hayabusa.common.HybsSystem;
027    import org.opengion.hayabusa.common.HybsSystemException;
028    import org.opengion.hayabusa.db.DBColumn;
029    import org.opengion.hayabusa.db.DBColumnConfig;
030    import org.opengion.hayabusa.db.DBTableModel;
031    import org.opengion.hayabusa.db.DBTableModelSorter;
032    import org.opengion.hayabusa.db.DBTableModelUtil;
033    import org.opengion.hayabusa.db.Selection;
034    import org.opengion.hayabusa.html.CrossMap;
035    import org.opengion.hayabusa.html.ViewCrossTableParam;
036    import org.opengion.hayabusa.resource.CodeData;
037    import org.opengion.hayabusa.resource.ResourceManager;
038    
039    /**
040     * 繧ｯ繝ｭ繧ｹ髮?ｨ医ユ繝ｼ繝悶Ν菴懈?繧ｯ繝ｩ繧ｹ縺ｧ縺吶?
041     *
042     *   select dept.dname,emp.deptno,substrb(job,1,2) as X,job,mgr,sum(sal),count(*)
043     *   from emp,dept
044     *   where emp.deptno = dept.deptno
045     *   group by dept.dname,emp.deptno,cube(job,mgr)
046     *   order by emp.deptno,job,mgr;
047     *
048     *   HEAD1   ?壹?繝?ム繝ｼ縲ょ燕谿ｵ縺ｨ蜷後§繝??繧ｿ縺ｯ陦ｨ遉ｺ縺輔○縺ｪ縺??
049     *   HEAD2   ?壹く繝ｼ繝悶Ξ繧､繧ｯ縺輔○繧九き繝ｩ繝??縺ｾ縺溘?蜑肴ｮｵ縺ｨ蜷後§繝??繧ｿ縺ｯ陦ｨ遉ｺ縺輔○縺ｪ縺??
050     *   HEAD3   ?壹く繝ｼ繝悶Ξ繧､繧ｯ縺輔○縺ｪ縺?き繝ｩ繝??縺ｾ縺溘?蜑肴ｮｵ縺ｨ蜷後§繝??繧ｿ縺ｧ繧り｡ｨ遉ｺ縺輔○繧九?
051     *   ROW     ?夊｡後ョ繝ｼ繧ｿ縺ｮ繝倥ャ繝??縺ｫ縺ｪ繧九き繝ｩ繝?
052     *   COL     ?壼?繝??繧ｿ縺ｮ繝倥ャ繝??縺ｫ縺ｪ繧九き繝ｩ繝??荳玖ｨ倥?SUM1,SUM2縺ｮ荳｡譁ｹ縺ｮ繝倥ャ繝??縺ｫ縺ｪ繧九?
053     *   SUM1    ?壼?繝??繧ｿ縺ｮ蛟､縺ｫ縺ｪ繧九き繝ｩ繝??
054     *   SUM2    ?壼?繝??繧ｿ縺ｮ蛟､縺ｫ縺ｪ繧九き繝ｩ繝??
055     *
056     *   SUM繧ｫ繝ｩ繝??謨ｰ縲√く繝ｼ繝悶Ξ繧､繧ｯ縺ｮ繧ｫ繝ｩ繝?錐縲√げ繝ｫ繝ｼ繝怜喧縺吶ｋ繧ｫ繝ｩ繝?錐繧?
057     *   謖?ｮ壹☆繧九％縺ｨ縺ｧ縲√％繧後ｉ縺ｮ繧ｯ繝ｭ繧ｹ髮?ｨ育ｵ先棡縺ｮ陦ｨ遉ｺ譁ｹ豕輔ｒ謖?ｮ壹＠縺ｾ縺吶?
058     *
059     *   breakColumn    = "DEPTNO"             繧ｭ繝ｼ繝悶Ξ繧､繧ｯ縺ｮ繧ｫ繝ｩ繝?錐
060     *   noGroupColumns = "X"                  繧ｰ繝ｫ繝ｼ繝怜喧縺吶ｋ繧ｫ繝ｩ繝?錐
061     *   sumNumber      = "2"                  SUM繧ｫ繝ｩ繝??謨ｰ
062     *   cubeXColumn    = "JOB"                CUBE險育ｮ励??代▽逶ｮ(X)繧ｫ繝ｩ繝?ｒ謖?ｮ?
063     *   cubeYColumn    = "MGR"                CUBE險育ｮ励??偵▽逶ｮ(Y)繧ｫ繝ｩ繝?ｒ謖?ｮ?
064     *   cubeSortType   = "NUMBER"             CUBE Y 縺ｮ蛻励?繝?ム繝ｼ縺ｮ繧ｽ繝ｼ繝域婿豕輔ｒ謖?ｮ?
065     *   gokeiSortDir   = "false"              蜷郁ｨ医き繝ｩ繝??繧ｽ繝ｼ繝域婿蜷代ｒ謖?ｮ?蛻晄悄蛟､:繧ｽ繝ｼ繝医＠縺ｪ縺?
066     *   shokeiLabel    = "SHOKEI"             蛻怜ｰ剰ｨ医?繧ｫ繝ｩ繝?↓陦ｨ遉ｺ縺吶ｋ繝ｩ繝吶ΝID
067     *   gokeiLabel     = "GOKEI"              蛻怜粋險医?繧ｫ繝ｩ繝?↓陦ｨ遉ｺ縺吶ｋ繝ｩ繝吶ΝID
068     *   useHeaderColumn= "false"              繝倥ャ繝??繧ｫ繝ｩ繝?↓繝ｬ繝ｳ繝?Λ繝ｼ縲√お繝?ぅ繧ｿ繝ｼ繧帝←逕ｨ縺吶ｋ縺九ｒ謖?ｮ?
069     *   useClassAdd    = "false"              蜷??諠??縺ｮclass螻樊?縺ｫ縲√き繝ｩ繝?錐縺ｪ縺ｩ繧剃ｻ倅ｸ弱☆繧九°縺ｩ縺?°繧呈欠螳?
070     *   useHeaderResource = "false"           繝倥ャ繝??陦ｨ遉ｺ縺ｫ繝ｩ繝吶Ν繝ｪ繧ｽ繝ｼ繧ｹ繧貞茜逕ｨ縺吶ｋ縺?
071     *
072     *   蜷?き繝ｩ繝??螻樊?(HEAD,SUM遲?繧定ｪ崎ｭ倥☆繧区婿豕?
073     *
074     *     HEAD1 HEAD2 HEAD3 ROW COL SUM1 SUM2 縺ｨ縺?≧荳ｦ縺ｳ繧定ｪ崎ｭ倥☆繧区婿豕輔?縲?
075     *     螟壽焚縺ｮ蜑肴署譚｡莉ｶ繧貞茜逕ｨ縺励※縲∝?譚･繧九□縺大ｰ代↑縺?ヱ繝ｩ繝｡繝ｼ繧ｿ縺ｧ閾ｪ蜍戊ｪ崎ｭ?
076     *     縺輔○縺ｦ縺?∪縺吶?
077     *     闍･蟷ｲ逅?ｧ｣縺励↓縺上＞縺九ｂ縺励ｌ縺ｾ縺帙ｓ縺後?諷｣繧後※縺上□縺輔＞縲?
078     *
079     *     蜑肴署譚｡莉ｶ??
080     *       ROW,COL 縺ｯ縲∝ｿ?★?大?縺壹▽蟄伜惠縺吶ｋ縲?
081     *       HEAD鄒､縲ヽOW,COL,SUM鄒､ 縺ｨ縺?≧荳ｦ縺ｳ縺ｫ縺ｪ縺｣縺ｦ縺?ｋ縲?
082     *       SUM鄒､縺ｮ謨ｰ縺ｯ縲√ヱ繝ｩ繝｡繝ｼ繧ｿ縺ｧ謖?ｮ壹☆繧九?
083     *     險育ｮ玲婿豕包ｼ?
084     *       HEAD謨ｰ=繧ｫ繝ｩ繝?焚(7)-SUM謨ｰ(2)-1(ROW,COL蛻? ????蛟?(0 ??3)
085     *       ROW繧｢繝峨Ξ繧ｹ?拂ubeXColumn 險ｭ螳?                      (3)      窶ｻ 繧｢繝峨Ξ繧ｹ縺ｯ?舌°繧牙ｧ九∪繧狗ぜ
086     *       COL繧｢繝峨Ξ繧ｹ?拂ubeYColumn 險ｭ螳?                      (4)
087     *       SUM繧｢繝峨Ξ繧ｹ?扎EAD謨ｰ?具ｼ???繧ｫ繝ｩ繝?焚(7)-1            (5 ??6)
088     *
089     * @og.rev 3.5.4.0 (2003/11/25) 譁ｰ隕丈ｽ懈?
090     * @og.group 逕ｻ髱｢陦ｨ遉ｺ
091     *
092     * @version  4.0
093     * @author       Kazuhiko Hasegawa
094     * @since    JDK5.0,
095     */
096    public class ViewForm_HTMLCrossTable extends ViewForm_HTMLTable {
097            //* 縺薙?繝励Ο繧ｰ繝ｩ繝??VERSION譁?ｭ怜?繧定ｨｭ螳壹＠縺ｾ縺吶?       {@value} */
098            private static final String VERSION = "5.5.5.0 (2012/07/28)" ;
099    
100            private String[] groupByData = null;
101            private String[] groupByCls  = null;
102    
103            // 3.5.4.8 (2004/02/23) 讖溯?謾ｹ蝟?
104            private int             rowClmNo        = -1;                   // ROW繧ｫ繝ｩ繝??繧ｫ繝ｩ繝?分蜿ｷ
105            private int             colClmNo        = -1;                   // CLM繧ｫ繝ｩ繝??繧ｫ繝ｩ繝?分蜿ｷ
106            private int             headCount       = 0;                    // HEAD繧ｫ繝ｩ繝??謨ｰ
107            private int             sumCount        = 1;                    // 蜷郁ｨ医き繝ｩ繝??謨ｰ
108            private int             breakClmNo      = -1;                   // 繝悶Ξ繝ｼ繧ｯ縺吶ｋ繧ｫ繝ｩ繝??繧ｫ繝ｩ繝?分蜿ｷ
109            private boolean[]       noGroupClm = null;              // 繧ｰ繝ｫ繝ｼ繝怜喧縺吶ｋ/縺励↑縺??繝輔Λ繧ｰ驟榊?
110            private String          shokeiLabel  = "蟆剰ｨ?;   // 蛻怜ｰ剰ｨ医?繧ｫ繝ｩ繝?↓陦ｨ遉ｺ縺吶ｋ繝ｩ繝吶ΝID
111            private String          gokeiLabel   = "蜷郁ｨ?;   // 蛻怜粋險医?繧ｫ繝ｩ繝?↓陦ｨ遉ｺ縺吶ｋ繝ｩ繝吶ΝID
112            private String          gokeiSortDir = null;    // 蛻怜粋險医?繧ｫ繝ｩ繝?ｒ繧ｽ繝ｼ繝医☆繧区婿蜷?
113    
114            // 3.5.6.3 (2004/07/12) 繧ｽ繝ｼ繝域婿蠑充STRING,NUMBER,LOAD]
115            private String          cubeSortType = "LOAD";
116    
117            private DBTableModel table2             = null;
118            private boolean          firstStep      = true;
119    
120            private String[]        clmKeys         = null;                         // 髮?ｨ磯Κ縺ｮ繧ｫ繝ｩ繝?く繝ｼ(髮?ｨ医き繝ｩ繝?′隍?焚縺ｧ繧ゆｸ?▽)縺ｮ驟榊?
121            private String[]        clsAdd          = null;                         // 5.2.2.0 (2010/11/01) class螻樊?縺ｫ莉倅ｸ弱＆繧後ｋ繧ｫ繝ｩ繝?く繝ｼ
122    
123            private String          noDisplayKeys           = null;         // 3.7.0.4 (2005/03/18)
124            private String          columnDisplayKeys       = null;         // 5.2.2.0 (2010/11/01)
125    
126            private boolean         firstClmGokei           = false;        // 5.0.0.3 (2009/09/22)
127            private boolean         useHeaderColumn         = false;        // 5.2.2.0 (2010/11/01)
128            private boolean         useClassAdd                     = false;        // 5.2.2.0 (2010/11/01) class螻樊?縺ｫ繧ｫ繝ｩ繝?く繝ｼ繧定ｿｽ蜉?☆繧九°縺ｩ縺?°
129            private boolean         useHeaderResource       = false;        // 5.5.5.0 (2012/07/28)
130            private String          headerCode                      = null;         // 5.5.5.0 (2012/07/28)
131            
132            /**
133             * 蛻晄悄蛹悶＠縺ｾ縺吶?
134             * 縺薙％縺ｧ縺ｯ縲∝?驛ｨ縺ｧ菴ｿ逕ｨ縺輔ｌ縺ｦ縺?ｋ繧ｭ繝｣繝?す繝･繧偵け繝ｪ繧｢縺励?
135             * 譁ｰ縺励＞繝｢繝?Ν(DBTableModel)縺ｨ險?ｪ?lang) 繧貞?縺ｫ蜀?Κ繝??繧ｿ繧貞?讒狗ｯ峨＠縺ｾ縺吶?
136             * 縺溘□縺励?險ｭ螳壽ュ蝣ｱ縺ｯ縲∽ｻ･蜑阪?迥ｶ諷九′縺昴?縺ｾ縺ｾ繧ｭ繝ｼ繝励＆繧後※縺?∪縺吶?
137             *
138             * @og.rev 3.5.4.8 (2004/02/23) paramInit 繝｡繧ｽ繝?ラ縺ｧ縲∝?譛溷喧繧定｡後＞縺ｾ縺吶?
139             * @og.rev 3.5.6.1 (2004/06/25) lang 險?ｪ槭さ繝ｼ繝?螻樊?繧貞炎髯､縺励∪縺吶?
140             *
141             * @param       table   DBTableModel繧ｪ繝悶ず繧ｧ繧ｯ繝?
142             */
143            @Override
144            public void init( final DBTableModel table ) {
145                    table2          = table;
146                    firstStep       = true;
147            }
148    
149            /**
150             * 蜀?ｮｹ繧偵け繝ｪ繧｢(蛻晄悄蛹?縺励∪縺吶?
151             *
152             * @og.rev 3.5.6.3 (2004/07/12) cubeSortType , gokeiSortDir 螻樊?繧定ｿｽ蜉?＠縺ｾ縺吶?
153             * @og.rev 3.7.0.4 (2005/03/18) noDisplayKeys 螻樊?繧定ｿｽ蜉?＠縺ｾ縺吶?
154             * @og.rev 3.7.1.1 (2005/05/31) shokeiLabel,gokeiLabel 縺ｮ蛻晄悄蛟､螟画峩
155             * @og.rev 5.2.2.0 (2010/11/01) columnDisplayKeys縲…lsAdd縲「seClassAdd 螻樊?繧定ｿｽ蜉?＠縺ｾ縺?
156             * @og.rev 5.5.5.0 (2012/07/20) useHeaderResource霑ｽ蜉?
157             */
158            @Override
159            public void clear() {
160                    super.clear();
161                    groupByData = null;
162                    groupByCls  = null;
163                    rowClmNo        = -1;                   // ROW繧ｫ繝ｩ繝??繧ｫ繝ｩ繝?分蜿ｷ
164                    colClmNo        = -1;                   // CLM繧ｫ繝ｩ繝??繧ｫ繝ｩ繝?分蜿ｷ
165                    headCount       = 0;                    // HEAD繧ｫ繝ｩ繝??謨ｰ
166                    sumCount        = 1;                    // 蜷郁ｨ医き繝ｩ繝??謨ｰ
167                    breakClmNo      = -1;                   // 繝悶Ξ繝ｼ繧ｯ縺吶ｋ繧ｫ繝ｩ繝??繧ｫ繝ｩ繝?分蜿ｷ
168                    noGroupClm      = null;                 // 繧ｰ繝ｫ繝ｼ繝怜喧縺吶ｋ/縺励↑縺??繝輔Λ繧ｰ驟榊?
169                    table2          = null;
170                    firstStep       = true;
171                    clmKeys         = null;
172                    clsAdd          = null;                 // 5.2.2.0 (2010/11/01)
173                    shokeiLabel     = "蟆剰ｨ?;                // 蛻怜ｰ剰ｨ医?繧ｫ繝ｩ繝?↓陦ｨ遉ｺ縺吶ｋ繝ｩ繝吶ΝID
174                    gokeiLabel      = "蜷郁ｨ?;                // 蛻怜粋險医?繧ｫ繝ｩ繝?↓陦ｨ遉ｺ縺吶ｋ繝ｩ繝吶ΝID
175                    cubeSortType = "LOAD";          // 3.5.6.3 (2004/07/12)
176                    gokeiSortDir = null;            // 3.5.6.3 (2004/07/12) 蛻怜粋險医?繧ｫ繝ｩ繝?ｒ繧ｽ繝ｼ繝医☆繧区婿蜷?
177                    noDisplayKeys           = null; // 3.7.0.4 (2005/03/18)
178                    columnDisplayKeys       = null; // 5.2.2.0 (2010/11/01)
179                    firstClmGokei           = false;        // 5.2.2.0 (2010/11/01)
180                    useHeaderColumn         = false;        // 5.2.2.0 (2010/11/01)
181                    useClassAdd                     = false;        // 5.2.2.0 (2010/11/01)
182                    useHeaderResource       = false;        // 5.5.5.0 (2012/07/20)
183                    headerCode                      = null;         // 5.5.5.0 (2012/07/28)
184            }
185    
186            /**
187             * DBTableModel 縺九ｉ HTML譁?ｭ怜?繧剃ｽ懈?縺励※霑斐＠縺ｾ縺吶?
188             * startNo(陦ｨ遉ｺ髢句ｧ倶ｽ咲ｽｮ)縺九ｉ縲｝ageSize(陦ｨ遉ｺ莉ｶ謨ｰ)縺ｾ縺ｧ縺ｮView譁?ｭ怜?繧剃ｽ懈?縺励∪縺吶?
189             * 陦ｨ遉ｺ谿九ｊ繝??繧ｿ縺?pageSize 莉･荳九?蝣ｴ蜷医?,谿九ｊ縺ｮ繝??繧ｿ繧偵☆縺ｹ縺ｦ蜃ｺ蜉帙＠縺ｾ縺吶?
190             *
191             * @og.rev 3.5.5.0 (2004/03/12) No 谺?◎縺ｮ繧ゅ?縺ｮ菴懈?蛻､譁ｭ繝ｭ繧ｸ繝?け繧定ｿｽ蜉?
192             * @og.rev 3.5.6.1 (2004/06/25) lang 險?ｪ槭さ繝ｼ繝?螻樊?繧貞炎髯､縺励∪縺吶?
193             * @og.rev 3.5.6.4 (2004/07/16) 繝倥ャ繝??縺ｨ繝懊ョ繧｣繝ｼ驛ｨ繧谷avaScript縺ｧ蛻?屬
194             * @og.rev 3.7.0.4 (2005/03/18) setNoDisplay 繝｡繧ｽ繝?ラ繧定ｿｽ蜉?
195             * @og.rev 4.3.1.0 (2008/09/08) 邱ｨ髮?｡後?縺ｿ繧定｡ｨ遉ｺ縺吶ｋ螻樊?(isSkipNoEdit)霑ｽ蜉?
196             * @og.rev 5.0.0.3 (2009/09/22) 蜷郁ｨ亥?繧団ube縺ｮ蜈磯?縺ｫ蜃ｺ縺帙ｋ繧医≧縺ｫ縺吶ｋ
197             * @og.rev 5.1.0.0 (2009/11/04) 竊代〒蜷郁ｨ亥?縺瑚､?焚繧ｫ繝ｩ繝?ｭ伜惠縺吶ｋ蝣ｴ蜷医↓豁｣縺励￥陦ｨ遉ｺ縺輔ｌ縺ｪ縺?ヰ繧ｰ繧剃ｿｮ豁｣
198             * @og.rev 5.2.2.0 (2010/11/01) setColumnDisplay 繝｡繧ｽ繝?ラ繧定ｿｽ蜉?
199             *
200             * @param  startNo        陦ｨ遉ｺ髢句ｧ倶ｽ咲ｽｮ
201             * @param  pageSize   陦ｨ遉ｺ莉ｶ謨ｰ
202             *
203             * @return      DBTableModel縺九ｉ菴懈?縺輔ｌ縺?HTML譁?ｭ怜?
204             */
205            @Override
206            public String create( final int startNo, final int pageSize )  {
207                    if( firstStep ) {
208                            paramInit( table2 );
209                            super.init( makeCrossTable(table2) );
210                            super.setNoDisplay( noDisplayKeys ) ;                           // 3.7.0.4 (2005/03/18)
211                            super.setColumnDisplay( columnDisplayKeys ) ;           // 5.2.2.0 (2010/11/01)
212                            markerSet( this );              // 3.5.6.4 (2004/07/16)
213                            firstStep = false;
214                    }
215    
216                    if( getRowCount() == 0 ) { return ""; } // 證ｫ螳壼?鄂ｮ
217    
218                    int clmCnt = getColumnCount();  // 3.5.5.7 (2004/05/10)
219    
220                    headerLine       = null;
221    
222                    int lastNo = getLastNo( startNo, pageSize );
223                    int blc = getBackLinkCount();
224                    String backData = null;
225    
226                    StringBuilder out = new StringBuilder( HybsSystem.BUFFER_LARGE );
227    
228                    out.append( getCountForm( startNo,pageSize ) );
229                    out.append( getHeader() );
230    
231                    String ckboxTD = "  <td class=\"" + ViewCrossTableParam.HEADER1 + "\">";
232    
233                    out.append("<tbody>").append( HybsSystem.CR );
234                    int bgClrCnt = 0;
235                    boolean shokei;
236                    for( int row=startNo; row<lastNo; row++ ) {
237    //                      if( isSkip( row ) ) { continue; }               // 3.5.3.1 (2003/10/31)
238                            if( isSkip( row ) || isSkipNoEdit( row ) ) { continue; } // 4.3.1.0 (2008/09/08)
239                            // 繧ｭ繝ｼ繝悶Ξ繧､繧ｯ譎ゅ?繝倥ャ繝??險ｭ螳?
240                            if( breakClmNo >= 0 ) {
241                                    String val = getValue( row,breakClmNo );
242                                    if( backData == null ) {        // 繧ｭ繝ｼ繝悶Ξ繧､繧ｯ縺ｮ蛻晄悄繝??繧ｿ險ｭ螳壹?
243                                            backData = val;
244                                    }
245                                    else {
246                                            if( ! backData.equals( val ) ) {
247                                                    backData = val;
248                                                    out.append( getHeadLine() );
249                                            }
250                                    }
251                            }
252                            // 蟆剰ｨ医?繝?ム繝ｼ譎ゅ?繧ｯ繝ｩ繧ｹ險ｭ螳?
253                            String val2 = getValue( row,rowClmNo );
254                            if( val2.length() == 0 ) {
255                                    shokei = true;
256                                    out.append("<tr class=\"").append( ViewCrossTableParam.SHOKEI ).append("\">");
257                            }
258                            else {
259                                    shokei = false;
260                                    out.append("<tr").append( getBgColorCycleClass( bgClrCnt++ ) ).append(">");
261                            }
262                            out.append( HybsSystem.CR );
263                            // 3.5.5.0 (2004/03/12) No 谺?◎縺ｮ繧ゅ?縺ｮ菴懈?蛻､譁ｭ霑ｽ蜉?
264                            if( isNumberDisplay() ) {
265                                    out.append( makeCheckbox( ckboxTD, row, blc ) ).append( HybsSystem.CR );
266                            }
267                            for(int column = 0; column < clmCnt; column++) {
268                                    if( isColumnDisplay( column ) ) {
269                                            if( column < headCount-1 ) {         // CUBE縺ｧ縺ｯ縺ｪ縺?｡後?繝?ム繝ｼ驛ｨ
270                                                    String val = getGroupData( column,getRendererValue(row,column) );
271                                                    out.append("  <td class=\"").append( groupByCls[column] ).append("\">");
272                                                    out.append( val );
273                                            }
274                                            else if( column == headCount-1 ) {      // 繝倥ャ繝??縺ｮ譛?ｾ悟ｰｾ
275                                                    if( shokei ) {
276                                                            out.append("  <td class=\"").append( ViewCrossTableParam.SHOKEI ).append("\">");
277                                                            out.append( shokeiLabel );
278                                                    }
279                                                    else {
280                                                            if( breakClmNo > 0 ) {       // 繝倥ャ繝??縺後≠繧句?蜷?
281                                                                    out.append("  <td class=\"").append( groupByCls[column-1] ).append("\">");
282                                                            }
283                                                            else {
284                                                                    out.append("  <td class=\"").append( ViewCrossTableParam.HEADER1 ).append("\">");
285                                                            }
286                                                            out.append( getRendererValue(row,column) );
287                                                    }
288                                            }
289                                            // else if( column >= clmCnt-sumCount ) {    // CUBE縺ｮ譛?ｵゅき繝ｩ繝?蛻怜粋險?
290                                            else if( column >= clmCnt-sumCount && ! firstClmGokei ) {    // 5.0.0.3 (2009/09/22) CUBE縺ｮ譛?ｵゅき繝ｩ繝?蛻怜粋險?
291                                                    out.append("  <td class=\"").append( ViewCrossTableParam.SHOKEI ).append("\">");
292                                                    out.append( getRendererValue(row,column) );
293                                            }
294    //                                      else if( column == headCount && firstClmGokei ) {               // 5.0.0.3 (2009/09/22) CUBE縺ｮ蜈磯?繧ｫ繝ｩ繝?蛻怜粋險?
295                                            else if( column >= headCount && column < headCount + sumCount && firstClmGokei ) {                // 5.1.0.0 (2009/11/04)
296                                                            out.append("  <td class=\"").append( ViewCrossTableParam.SHOKEI ).append("\">");
297    //                                                      out.append( getRendererValue(row,clmCnt-sumCount) );
298                                                            out.append( getRendererValue(row,clmCnt-sumCount+(column-headCount)) ); // 5.1.0.0 (2009/11/04)
299                                            }
300                                            else {          // 繧ｫ繝ｩ繝?SUM蛻?
301                                                    if( useClassAdd && clsAdd[column] != null ) {
302                                                            out.append("  <td class=\"").append( clsAdd[column] ).append("\">");
303                                                    }
304                                                    else {
305                                                            out.append("  <td>");
306                                                    }
307                                                    if( firstClmGokei ){
308    //                                                      out.append( getRendererValue(row,column-1) ); // 蜷郁ｨ郁｡後ｒ蜈磯?縺ｫ蜃ｺ縺吶→1縺､縺壹ｌ繧?
309                                                            out.append( getRendererValue(row,column-sumCount) ); // 5.1.0.0 (2009/11/04)
310                                                    }
311                                                    else{
312                                                            out.append( getRendererValue(row,column) );
313                                                    }
314                                            }
315                                            out.append("</td>").append( HybsSystem.CR );
316                                    }
317                            }
318                            out.append("</tr>").append( HybsSystem.CR );
319                    }
320                    out.append("</tbody>").append( HybsSystem.CR );
321                    out.append("</table>").append( HybsSystem.CR );
322    
323                    out.append( getScrollBarEndDiv() );     // 3.8.0.3 (2005/07/15)
324                    return out.toString();
325            }
326    
327            /**
328             * 繝代Λ繝｡繝ｼ繧ｿ蜀?ｮｹ繧貞?譛溷喧縺励∪縺吶?
329             *
330             * @og.rev 3.5.4.8 (2004/02/23) 譁ｰ隕丈ｽ懈?
331             * @og.rev 3.5.6.3 (2004/07/12) 蛻励?繝?ム繝ｼ縺ｮ繧ｽ繝ｼ繝域婿豕輔ｒ謖?ｮ?
332             * @og.rev 5.0.0.3 (2009/09/22) 蜷郁ｨ郁｡後ｒCUBE縺ｮ蜈磯?縺ｫ謖√▲縺ｦ縺上ｋ縺溘ａ縺ｮ繝輔Λ繧ｰ霑ｽ蜉?
333             * @og.rev 5.2.2.0 (2010/11/01) useHeaderColumn,useClassAdd 螻樊?縺ｮ霑ｽ蜉?
334             *
335             * @param       table   蜈･蜉帙ｂ縺ｨ縺ｮ DBTableModel繧ｪ繝悶ず繧ｧ繧ｯ繝?
336             */
337            private void paramInit( final DBTableModel table ) {
338                    String breakColumn              = getParam( ViewCrossTableParam.BREAK_COLUMN_KEY     , null );
339                    String noGroupColumns   = getParam( ViewCrossTableParam.NO_GROUP_COLUMNS_KEY , null );
340                    String sumNumber                = getParam( ViewCrossTableParam.SUM_NUMBER_KEY       , null );
341                    shokeiLabel                             = getParam( ViewCrossTableParam.SHOKEI_LABEL_KEY     , shokeiLabel );
342                    gokeiLabel                              = getParam( ViewCrossTableParam.GOKEI_LABEL_KEY      , gokeiLabel );
343                    String cubeXColumn              = getParam( ViewCrossTableParam.CUBE_X_COLUMN_KEY    , null );  // CUBE險育ｮ励??代▽逶ｮ(X)繧ｫ繝ｩ繝?ｒ謖?ｮ?
344                    String cubeYColumn              = getParam( ViewCrossTableParam.CUBE_Y_COLUMN_KEY    , null );  // CUBE險育ｮ励??偵▽逶ｮ(Y)繧ｫ繝ｩ繝?ｒ謖?ｮ?
345                    cubeSortType                    = getParam( ViewCrossTableParam.CUBE_SORT_TYPE_KEY   , "LOAD" );        // 3.5.6.3 (2004/07/12)
346                    gokeiSortDir                    = getParam( ViewCrossTableParam.GOKEI_SORT_DIR_KEY   , null );  // 3.5.6.3 (2004/07/12)
347                    firstClmGokei                   = StringUtil.nval( getParam( ViewCrossTableParam.FIRST_CLM_GOKEI_KEY , null ), false);  // 5.0.0.3 (2009/09/22)
348                    useHeaderColumn                 = StringUtil.nval( getParam( ViewCrossTableParam.USE_HEADER_COLUMN   , null ), false);  // 5.2.2.0 (2010/11/01)
349                    useClassAdd                             = StringUtil.nval( getParam( ViewCrossTableParam.USE_CLASS_ADD       , null ), false);  // 5.2.2.0 (2010/11/01)
350                    useHeaderResource               = StringUtil.nval( getParam( ViewCrossTableParam.USE_HEADER_RSC      , null ), false);  // 5.5.5.0 (2012/07/20)
351                    headerCode                              = getParam( ViewCrossTableParam.HEADER_CODE_KEY     , null );   // 5.5.5.0 (2012/07/28)
352                    
353                    if( sumNumber != null ) {
354                            sumCount = Integer.parseInt( sumNumber );
355                    }
356    
357                    // HEAD謨ｰ=繧ｫ繝ｩ繝?焚-SUM謨ｰ-1(COL蛻? ROW 縺ｯ縲？EAD縺ｫ蜷ｫ縺ｿ縺ｾ縺吶?
358                    headCount = table.getColumnCount() - sumCount - 1;
359    
360                    // 3.5.5.9 (2004/06/07)
361                    if( cubeXColumn != null ) {
362                            rowClmNo = table.getColumnNo( cubeXColumn );
363                    }
364                    else {
365                            rowClmNo = headCount-1;                 // ROW繧ｫ繝ｩ繝??繧ｫ繝ｩ繝?分蜿ｷ
366                    }
367    
368                    // 3.5.5.9 (2004/06/07)
369                    if( cubeYColumn != null ) {
370                            colClmNo = table.getColumnNo( cubeYColumn );
371                    }
372                    else {
373                            colClmNo = headCount;           // CLM繧ｫ繝ｩ繝??繧ｫ繝ｩ繝?分蜿ｷ
374                    }
375    
376                    if( breakColumn != null ) {
377                            breakClmNo = table.getColumnNo( breakColumn );
378                    }
379    
380                    groupByData = new String[headCount];
381                    groupByCls  = new String[headCount];
382                    Arrays.fill( groupByCls,ViewCrossTableParam.HEADER2 );          // 螟峨〒縺ゅｋ縺後?譛??縺ｫ蜈･繧梧崛縺医′逋ｺ逕溘☆繧狗ぜ縲?
383    
384                    noGroupClm    = new boolean[headCount];         // 繧ｰ繝ｫ繝ｼ繝怜喧縺吶ｋ/縺励↑縺??繝輔Λ繧ｰ驟榊?
385                    Arrays.fill( noGroupClm,false );
386    
387                    if( noGroupColumns != null ) {
388                            String[] gClms = StringUtil.csv2Array( noGroupColumns );
389                            for( int i=0; i<gClms.length; i++ ) {
390                                    noGroupClm[table.getColumnNo( gClms[i] )] = true;
391                            }
392                    }
393    
394                    if( ! "true".equalsIgnoreCase( gokeiSortDir ) &&
395                            ! "false".equalsIgnoreCase( gokeiSortDir ) ) {
396                                    gokeiSortDir = null;
397                    }
398            }
399    
400            /**
401             * CUBE縺ｧ縺ｯ縺ｪ縺?｡後?繝?ム繝ｼ驛ｨ縺ｮ蛟､縺悟燕縺ｨ蜷後§縺ｪ繧峨?縲√ぞ繝ｭ譁?ｭ怜?繧定ｿ斐＠縺ｾ縺吶?
402             *
403             * @param       clm     繧ｫ繝ｩ繝?分蜿ｷ
404             * @param       val     豈碑ｼ?☆繧句?
405             *
406             * @return      蜑阪→蜷後§縺ｪ繧?""繧偵?逡ｰ縺ｪ繧句?蜷医?縲∝ｼ墓焚縺ｮ val 繧定ｿ斐＠縺ｾ縺吶?
407             */
408            private String getGroupData( final int clm,final String val ) {
409                    if( noGroupClm[clm] ) { return val; }
410    
411                    if( val.equals( groupByData[clm] )) {
412                            return "";
413                    }
414                    else {
415                            groupByData[clm] = val;
416                            groupByCls[clm] = ( groupByCls[clm].equals( ViewCrossTableParam.HEADER1 )) ? ViewCrossTableParam.HEADER2 : ViewCrossTableParam.HEADER1 ;
417                            return val;
418                    }
419            }
420    
421            /**
422             * 驕ｸ謚樒畑縺ｮ繝√ぉ繝?け繝懊ャ繧ｯ繧ｹ縺ｨ陦檎分蜿ｷ縺ｨ螟画峩繧ｿ繧､繝?A,C,D)繧定｡ｨ遉ｺ縺励∪縺吶?
423             *
424             * @param  ckboxTD 繝√ぉ繝?け繝懊ャ繧ｯ繧ｹ縺ｮ繧ｿ繧ｰ(繝槭Ν繝√き繝ｩ繝?凾縺ｮrowspan蟇ｾ蠢?
425             * @param  row   陦檎分蜿ｷ
426             * @param  blc   繝舌ャ繧ｯ繝ｩ繧､繝ｳ繧ｫ繧ｦ繝ｳ繝?蜈磯?縺ｸ謌ｻ繧九Μ繝ｳ繧ｯ髢馴囈)
427             *
428             * @return      td繧ｿ繧ｰ縺ｧ蝗ｲ縺ｾ繧後◆繝√ぉ繝?け繝懊ャ繧ｯ繧ｹ縺ｮHTML譁?ｭ怜?
429             */
430            @Override
431            protected String makeCheckbox( final String ckboxTD,final int row,final int blc ) {
432                    StringBuilder out = new StringBuilder( HybsSystem.BUFFER_MIDDLE );
433    
434                    out.append( ckboxTD ).append("</td>");
435                    out.append( ckboxTD ).append("</td>");
436                    out.append( ckboxTD );
437                    // 3.5.1.0 (2003/10/03) No繧ｫ繝ｩ繝?↓縲］umberType 螻樊?繧定ｿｽ蜉?
438                    if( blc != 0 && (row+1) % blc == 0 ) {
439                            out.append( "<a href=\"#top\">" ).append( (row+1) ).append(  "</a>" );
440                    } else {
441                            out.append( (row+1) );
442                    }
443                    out.append("</td>");
444    
445                    return out.toString();
446            }
447    
448            /**
449             * 繝倥ャ繝??郢ｰ繧願ｿ斐＠驛ｨ繧偵?getTableHead()繝｡繧ｽ繝?ラ縺九ｉ蛻?屬縲?
450             *
451             * @og.rev 3.5.4.5 (2004/01/23) 螳溯｣?ｒgetHeadLine( String thTag )縺ｫ遘ｻ蜍?
452             * @og.rev 3.5.5.0 (2004/03/12) No 谺?◎縺ｮ繧ゅ?縺ｮ菴懈?蛻､譁ｭ繝ｭ繧ｸ繝?け繧定ｿｽ蜉?
453             * @og.rev 5.0.0.3 (2009/09/17) 蜷郁ｨ郁｡後ｒ蜃ｺ蜉帙☆繧倶ｽ咲ｽｮ繧断irstClmGokei縺ｧ螟峨∴繧?
454             * @og.rev 5.2.2.0 (2010/11/01) 髮?ｨ磯Κ縺ｮ ColumnDisplay/NoDisplay 蟇ｾ蠢?
455             * @og.rev 5.5.5.0 (2012/07/28) useHeaderResource蛻ｩ逕ｨ譎ゅ?繝倥ャ繝??繝ｩ繝吶Ν/繧ｳ繝ｼ繝峨Μ繧ｽ繝ｼ繧ｹ蟇ｾ蠢?
456             *
457             * @return      繝??繝悶Ν縺ｮ繧ｿ繧ｰ譁?ｭ怜?
458             */
459            @Override
460            protected String getHeadLine() {
461                    if( headerLine != null ) { return headerLine; }         // 繧ｭ繝｣繝?す繝･繧定ｿ斐☆縲?
462    
463                    String rowspan = "";
464                    if( sumCount > 1 ) { rowspan = " rowspan=\"2\""; }
465    
466                    String thTag = "<th" + rowspan;
467    
468                    StringBuilder buf = new StringBuilder( HybsSystem.BUFFER_MIDDLE );
469    
470                    buf.append("<tr").append( rowspan ).append(" class=\"row_h\"").append(" >").append( HybsSystem.CR );
471    
472                    // 3.5.5.0 (2004/03/12) No 谺?◎縺ｮ繧ゅ?縺ｮ菴懈?蛻､譁ｭ霑ｽ蜉?
473                    if( isNumberDisplay() ) {
474                            buf.append( thTag ).append(" colspan='3'>").append( getNumberHeader() ).append("</th>");
475                    }
476    
477                    buf.append( HybsSystem.CR );
478                    // 繝倥ャ繝??驛ｨ蛻??縲√◎縺ｮ縺ｾ縺ｾ陦ｨ遉ｺ縺励∪縺吶?
479                    for(int column = 0; column < headCount; column++) {
480                            if( isColumnDisplay( column ) ) {
481                                    buf.append( thTag ).append(">");
482                                    buf.append( getColumnLabel(column) );
483                                    buf.append("</th>").append( HybsSystem.CR );
484                            }
485                    }
486    
487                    // 繝倥ャ繝??驛ｨ蛻?荳頑ｮｵ)縺ｯ縲√き繝ｩ繝??蛻励ｒ蛻ｩ逕ｨ縺励∪縺吶?
488                    String colspan = "";
489                    if( sumCount > 1 ) { colspan = " colspan='" + sumCount + "'"; }
490    
491                    // 5.2.2.0 (2010/11/01) 髮?ｨ磯Κ縺ｮ ColumnDisplay/NoDisplay 蟇ｾ蠢?
492    //              String gokeiClm = "<th" + colspan + ">" + temp + "</th>" + HybsSystem.CR ;
493                    String gokeiClm = null;
494                    if( isColumnDisplay( headCount+(clmKeys.length-1)*sumCount ) ) {
495                            String temp = clmKeys[clmKeys.length-1];
496                            if( temp == null || temp.length() == 0 ) {
497                                    temp = gokeiLabel;
498                            }
499    
500                            gokeiClm = "<th" + colspan + ">" + temp + "</th>" + HybsSystem.CR ;
501                    }
502    
503                    // 5.2.2.0 (2010/11/01) 譛?ｾ後?繧ｫ繝ｩ繝?′縲∝粋險郁｡後?
504                    // 5.0.0.3 (2009/09/22) firstClmGokei 縺?true縺ｮ蝣ｴ蜷医?cube縺ｮ蜈磯?縺ｫ蜃ｺ縺吶ｈ縺?↓縺励∪縺吶?
505    //              if( firstClmGokei && isColumnDisplay( headCount+clmKeys.length-1 ) ) {
506                    if( firstClmGokei && gokeiClm != null ) {
507                            buf.append( gokeiClm );
508                    }
509    
510    //              // 5.0.0.3 (2009/09/22) true縺ｮ蝣ｴ蜷医?cube縺ｮ蜈磯?縺ｫ蜃ｺ縺吶ｈ縺?↓縺励∪縺吶?
511    //              if( firstClmGokei ){
512    //                      String temp = clmKeys[clmKeys.length-1];
513    //                      if( temp == null || temp.length() == 0 ) {
514    //                              temp = gokeiLabel;
515    //                      }
516    //                      buf.append( "<th").append( colspan ).append( ">" );
517    //                      buf.append( temp );
518    //                      buf.append("</th>").append( HybsSystem.CR );
519    //              }
520    
521                    // 3.7.0.4 (2005/03/18) 繧ｫ繝ｩ繝??蛻励?縲√き繝ｩ繝?分蜿ｷ縺ｨ蛻･迚ｩ
522                    ResourceManager resource = getResourceManager();
523                    Selection selection = null;
524                    if( headerCode != null && headerCode.length() > 0 && resource != null ){
525                            DBColumn clmTmp = resource.getDBColumn( headerCode );
526                            //selection = new Selection_CODE(resource.getCodeData( headerCode )); code逶ｴ縺ｮ蝣ｴ蜷?
527                            if ( clmTmp != null ){
528                                    selection = clmTmp.getSelection();
529                            }
530                    }
531                    for( int keyNo = 0; keyNo < clmKeys.length-1; keyNo++ ) {
532                            // 5.2.2.0 (2010/11/01) ColumnDisplay/NoDisplay 蟇ｾ蠢?
533                            if( isColumnDisplay( headCount+keyNo ) ) {
534                                    buf.append( "<th").append( colspan ).append( ">" );
535                                    if( headerCode != null && headerCode.length() > 0 && selection != null ){
536                                            buf.append( selection.getValueLabel( clmKeys[keyNo] ) );
537                                    }
538                                    else if( useHeaderResource && useHeaderColumn ){ // 5.5.5.0 (2012/07/28) 繝倥ャ繝??繝ｪ繧ｽ繝ｼ繧ｹ蟇ｾ蠢?
539                                            buf.append( getColumnLabel(headCount+keyNo) );
540                                    }
541                                    else{
542                                            buf.append( clmKeys[keyNo] );
543                                    }
544                                    buf.append("</th>").append( HybsSystem.CR );
545                            }
546                    }
547    
548                    // 5.2.2.0 (2010/11/01) 譛?ｾ後?繧ｫ繝ｩ繝?′縲∝粋險郁｡後?
549                    // 5.0.0.3 (2009/09/22) firstClmGokei 縺?true縺ｮ蝣ｴ蜷医?cube縺ｮ蜈磯?縺ｫ蜃ｺ縺吶ｈ縺?↓縺励∪縺吶?
550    //              if( ! firstClmGokei && isColumnDisplay( headCount+clmKeys.length-1 ) ) {
551                    if( ! firstClmGokei && gokeiClm != null ) {
552                            buf.append( gokeiClm );
553                    }
554    
555                    // 3.5.6.2 (2004/07/05) makeCrossTable( DBTableModel table ) 縺ｫ遘ｻ蜍?
556                    // 譛?ｵゅき繝ｩ繝?蛻?縺君ULL(遨ｺ譁?ｭ怜?)縺ｮ蝣ｴ蜷医?蛻怜粋險医〒縺吶?
557    //              if( ! firstClmGokei ){ // 5.0.0.3 (2009/09/22) false縺ｮ蝣ｴ蜷医?譛?ｵょ?縺ｫ蜃ｺ縺?
558    //                      String temp = clmKeys[clmKeys.length-1];
559    //                      if( temp == null || temp.length() == 0 ) {
560    //                              temp = gokeiLabel;
561    //                      }
562    //                      buf.append( "<th").append( colspan ).append( ">" );
563    //                      buf.append( temp );
564    //                      buf.append("</th>").append( HybsSystem.CR );
565    //              }
566    
567                    buf.append("</tr>").append( HybsSystem.CR );
568    
569                    if( sumCount > 1 ) {
570                            buf.append("<tr").append(" class=\"row_h\"").append(" >").append( HybsSystem.CR );
571                            int clmCnt = getColumnCount();  // 3.5.5.7 (2004/05/10)
572                            for(int column = headCount; column < clmCnt; column++) {
573                                    if( isColumnDisplay( column ) ) {
574                                            buf.append( "<th>");
575                                            buf.append( getColumnLabel(column) );
576                                            buf.append("</th>").append( HybsSystem.CR );
577                                    }
578                            }
579                            buf.append("</tr>").append( HybsSystem.CR );
580                    }
581    
582                    headerLine = buf.toString();
583                    return headerLine;
584            }
585    
586            /**
587             * 繧ｯ繝ｭ繧ｹ髮?ｨ育ｵ先棡縺ｮ DBTableModel繧ｪ繝悶ず繧ｧ繧ｯ繝医ｒ菴懈?縺励∪縺吶?
588             *
589             * @og.rev 3.5.4.8 (2004/02/23) paramInit 繝｡繧ｽ繝?ラ縺ｧ縲∝?譛溷喧繧定｡後＞縺ｾ縺吶?
590             * @og.rev 3.5.6.3 (2004/07/12) 蛻励?繝?ム繝ｼ縺ｮ繧ｽ繝ｼ繝亥庄蜷ｦ縺ｮ謖?ｮ壹ｒ霑ｽ蜉?
591             * @og.rev 4.0.0.0 (2007/11/27) 繝倥ャ繝??繧ｫ繝ｩ繝??繧ｨ繝?ぅ繧ｿ繝ｼ縲√Ξ繝ｳ繝?Λ繝ｼ驕ｩ逕ｨ蟇ｾ蠢?
592             * @og.rev 4.3.5.7 (2008/03/22) 竊代Μ繧ｽ繝ｼ繧ｹ縺悟ｭ伜惠縺励↑縺??蜷医?縲√Λ繝吶Ν縺ｮ縺ｿ蜈･繧梧崛縺?
593             * @og.rev 5.2.2.0 (2010/11/01) useHeaderColumn,useClassAdd 螻樊?縺ｮ霑ｽ蜉?
594             *
595             * @param       table   蜈･蜉帙ｂ縺ｨ縺ｮ DBTableModel繧ｪ繝悶ず繧ｧ繧ｯ繝?
596             *
597             * @return      DBTableModel繧ｪ繝悶ず繧ｧ繧ｯ繝?
598             */
599            private DBTableModel makeCrossTable( final DBTableModel table ) {
600                    Set<String> clmData = gatSortAlgorithmSet();
601    
602                    // 蛻励?繧ｭ繝ｼ縺ｨ縺ｪ繧九き繝ｩ繝??蛟､繧貞叙蠕励＠縺ｾ縺吶?
603                    int rowCnt = table.getRowCount();               // 3.5.5.7 (2004/05/10)
604                    for( int row=0; row<rowCnt; row++ ) {
605                            String clm = table.getValue( row,colClmNo );
606                            if( clm.length() > 0 ) { clmData.add( clm ); }
607                    }
608                    // 繧ｼ繝ｭ繧ｹ繝医Μ繝ｳ繧ｰ縺ｯ縲∝粋險郁｡後↓縺ｪ繧翫∪縺吶?縺ｧ縲∵怙蠕後↓霑ｽ蜉?＠縺ｾ縺吶?
609    
610                    // 3.5.6.3 (2004/07/12) 繧ｼ繝ｭ繧ｹ繝医Μ繝ｳ繧ｰ縺ｯ縲∝粋險郁｡後↓縺ｪ繧翫∪縺吶?縺ｧ縲∵怙蠕後↓霑ｽ蜉?＠縺ｾ縺吶?
611    //              clmKeys = new String[ clmData.size() + 1 ];
612    //              clmKeys = clmData.toArray( clmKeys ) ;
613                    clmKeys = clmData.toArray( new String[clmData.size() + 1] ) ;
614    
615                    clmKeys[clmKeys.length-1] = "" ;
616    
617                    int numberOfColumns =  headCount + clmKeys.length * sumCount ;
618    
619                    DBTableModel tableImpl = DBTableModelUtil.newDBTable();
620                    tableImpl.init( numberOfColumns );
621    
622                    // 繝倥ャ繝??繧ｫ繝ｩ繝?ROW繝??繧ｿ蜷ｫ繧?縺ｯ縲√◎縺ｮ縺ｾ縺ｾ縲∬ｨｭ螳壹＠縺ｾ縺吶?
623                    for(int column=0; column<headCount; column++) {
624                            tableImpl.setDBColumn( column,table.getDBColumn(column) );
625                    }
626    
627                    // 蛻玲ュ蝣ｱ縺ｯ縲∝粋險亥?縺ｮ繧ｫ繝ｩ繝?ｮ夂ｾｩ繧剃ｽｿ逕ｨ縺励∪縺吶?
628                    DBColumn[] dbColumn = new DBColumn[sumCount];
629                    for( int i=0; i<sumCount; i++ ) {
630                            dbColumn[i] = table.getDBColumn(headCount + 1 + i);
631                    }
632    
633                    // 蛻玲ュ蝣ｱ縺ｯ縲∝?縺ｮ蜷榊燕繧偵き繝ｩ繝??蛟､縺ｫ螟峨∴縺ｦ縲∝粋險医き繝ｩ繝??縺ｮ繧ｳ繝斐?諠??繧定ｨｭ螳壹＠縺ｾ縺吶?
634    
635                    int sumId = 0;
636                    ResourceManager resource = getResourceManager();
637                    useHeaderColumn = useHeaderColumn && resource != null ; // 5.2.2.0 (2010/11/01)
638    
639                    // 5.2.2.0 (2010/11/01) useClassAdd 螻樊?縺ｮ霑ｽ蜉?
640    
641                    clsAdd = new String[numberOfColumns];
642    
643                    // 蛻玲ュ蝣ｱ繧ｫ繝ｩ繝??縲√?繝?ム繝ｼ蛻?↓蜑ｲ繧雁ｽ薙※繧峨ｌ繧狗ぜ縲?幕蟋九′縲”eadCount 縺九ｉ縺ｫ縺ｪ繧翫∪縺吶?
644                    for(int column=headCount; column<numberOfColumns; column++) {
645                            DBColumn dbClm = dbColumn[sumId];
646                            String clmKey  = clmKeys[ (column-headCount)/sumCount ];
647    
648                            // 5.2.2.0 (2010/11/01) useClassAdd 螻樊?縺ｮ霑ｽ蜉?
649                            if( useClassAdd ) {
650                                     // 窶ｻ 迚ｹ谿雁ｯｾ蠢懶ｼ喞ss縺ｪ縺ｩ縺ｧ謖?ｮ壹〒縺阪ｋID繧ГLASS螻樊?縺ｯ縲∝?鬆ｭ譁?ｭ励′謨ｰ蟄励?蝣ｴ蜷医?縲?
651                                     // 辟｡蜉ｹ縺ｫ縺ｪ繧翫∪縺吶?(縺､縺ｾ繧翫?蜉ｹ縺阪∪縺帙ｓ縲?
652                                     // 陦ｨ遉ｺ繝倥ャ繝??縺ｯ縲∝ｹｴ譛医ｄ縲∫､ｾ蜩｡逡ｪ蜿ｷ(謨ｰ蟄?縺ｪ縺ｩ縺ｮ繧ｱ繝ｼ繧ｹ繧ゅ≠繧翫∪縺吶?縺昴％縺ｧ縲∝?鬆ｭ縺梧焚蟄励?
653                                     // 蝣ｴ蜷医?縲?x"(蟆乗枚蟄励?x)繧定?蜍慕噪縺ｫ鬆ｭ縺ｫ霑ｽ蜉?＠縺ｾ縺吶?
654                                    StringBuilder buf = new StringBuilder();
655                                    if( clmKey != null && clmKey.length() > 0 ) {
656                                            char ch = clmKey.charAt(0);
657                                            if( ch >= '0' && ch <= '9' ) {
658                                                    buf.append( "x" );
659                                            }
660                                            buf.append( clmKey );
661                                    }
662    
663                                    String nm = dbClm.getName();
664                                    if( nm != null && nm.length() > 0 ) {
665                                            buf.append( " " );
666                                            char ch = nm.charAt(0);
667                                            if( ch >= '0' && ch <= '9' ) {
668                                                    buf.append( "x" );
669                                            }
670                                            buf.append( nm );
671                                    }
672                                    clsAdd[column] = buf.toString();
673                            }
674    
675                            // 4.0.0.0 (2007/11/27)
676    //                      if( resource != null && "true".equalsIgnoreCase( getParam( "useHeaderColumn", null ) ) ) {
677                            // 5.2.2.0 (2010/11/01) 蜃ｦ逅?ｦ狗峩縺励?useHeaderColumn 縺ｮ蜑榊?縺励→縲《etName 蟇ｾ蠢?
678                            if( useHeaderColumn ) {
679    //                              String clmKey = clmKeys[ (column-headCount)/sumCount ]; // 5.2.2.0 (2010/11/01) 荳翫↓遘ｻ蜍?
680                                    DBColumn clmTmp = resource.getDBColumn( clmKey );
681                                    if( clmTmp == null ) {
682    //                                      tableImpl.setDBColumn( column,dbColumn[sumId] ); }
683                                            DBColumnConfig dbCfg2 = dbClm.getConfig();
684                                            if( clmKey != null && clmKey.length() > 0 ) {        // 5.2.2.0 (2010/11/01)
685                                                    dbCfg2.setName( clmKey );
686                                                    dbCfg2.setLabelData( resource.getLabelData( clmKey ) );
687                                            }
688                                            else {
689                                                    dbCfg2.setLabelData( resource.getLabelData( gokeiLabel ) );
690                                            }
691                                            dbClm = new DBColumn( dbCfg2 );
692    //                                      tableImpl.setDBColumn( column, new DBColumn( dbCfg2 ) );
693                                    }
694                                    else {
695    //                                      tableImpl.setDBColumn( column,dbClm );
696                                            dbClm = clmTmp;
697                                    }
698                            }
699    //                      else {
700    //                              tableImpl.setDBColumn( column,dbColumn[sumId] );
701    //                      }
702    
703                            tableImpl.setDBColumn( column,dbClm );
704    
705                            sumId++;
706                            if( sumId % sumCount == 0 ) {
707                                    sumId = 0;
708                            }
709                    }
710    
711                    // 繧ｯ繝ｭ繧ｹ髮?ｨ医ョ繝ｼ繧ｿ縺ｮ菴懈?
712                    CrossMap cross = new CrossMap( clmKeys,headCount,sumCount );
713                    for( int row=0; row<rowCnt; row++ ) {
714                            String[] data = table.getValues( row );
715                            cross.add( data );
716                    }
717    
718                    // 繝??繧ｿ驛ｨ縺ｮ險ｭ螳?
719                    int size = cross.getSize();
720                    for( int row=0; row<size; row++ ) {
721                            tableImpl.addValues( cross.get( row ), row );
722                    }
723    
724                    tableImpl.resetModify();
725    
726                    final DBTableModel model ;
727                    if( gokeiSortDir != null ) {
728                            DBTableModelSorter temp = new DBTableModelSorter();
729                            temp.setModel( tableImpl );
730    
731                            boolean direction = Boolean.valueOf( gokeiSortDir ).booleanValue();
732                            temp.sortByColumn( numberOfColumns-1,direction );
733                            model = temp ;
734                    }
735                    else {
736                            model = tableImpl;
737                    }
738                    return model ;
739            }
740    
741            /**
742             * 蛻励?繝?ム繝ｼ縺ｮ繧ｽ繝ｼ繝域婿豕輔↓蠢懊§縺溘?Set繧ｪ繝悶ず繧ｧ繧ｯ繝医ｒ霑斐＠縺ｾ縺吶?
743             * 縺薙％縺ｧ縺ｯ縲¨UMBER , STRING , LOAD 縺ｮ?鍋ｨｮ鬘樒畑諢上＠縺ｦ縺?∪縺吶?
744             *
745             * @og.rev 3.5.6.3 (2004/07/12) 譁ｰ隕丈ｽ懈?
746             *
747             * @return      繧ｽ繝ｼ繝域婿豕輔↓蠢懊§縺欖et繧ｪ繝悶ず繧ｧ繧ｯ繝?
748             */
749            private Set<String> gatSortAlgorithmSet() {
750                    final Set<String> rtnSet ;
751    
752                    if( "LOAD".equalsIgnoreCase( cubeSortType ) ) {
753                            rtnSet = new LinkedHashSet<String>();
754                    }
755                    else if( "NUMBER".equalsIgnoreCase( cubeSortType ) ) {
756                            rtnSet = new TreeSet<String>( numberSort );
757                    }
758                    else if( "STRING".equalsIgnoreCase( cubeSortType ) ) {
759                            rtnSet = new TreeSet<String>();
760                    }
761                    else {
762                            String errMsg = "cubeSortType 縺ｯ縲¨UMBER,STRING,LOAD 莉･螟匁欠螳壹〒縺阪∪縺帙ｓ縲? +
763                                                            "  cubeSortType=[" + cubeSortType + "]";
764                            throw new HybsSystemException( errMsg );
765                    }
766    
767                    return rtnSet ;
768            }
769    
770            /**
771             * 陦ｨ遉ｺ荳榊庄繧ｫ繝ｩ繝?錐繧偵?繧ｫ繝ｳ繝槫玄蛻?ｊ縺ｧ荳弱∴縺ｾ縺吶?
772             * 萓具ｼ?OYA,KO,HJO,SU,DYSET,DYUPD"
773             * null 繧剃ｸ弱∴縺溷?蜷医?,縺ｪ縺ｫ繧ゅ＠縺ｾ縺帙ｓ縲?
774             *
775             * 豕ｨ諢擾ｼ壹％縺ｮ繧ｯ繝ｩ繧ｹ縺ｧ縺ｯ縲．BTableModel 繧剃ｽ懊ｊ逶ｴ縺吶ち繧､繝溘Φ繧ｰ縺後?
776             * create 繝｡繧ｽ繝?ラ螳溯｡梧凾縺ｧ縺吶?(繝代Λ繝｡繝ｼ繧ｿ縺ｮ蛻晄悄蛹悶′蠢?ｦ√↑轤ｺ)
777             * 繧医▲縺ｦ縲√％縺ｮ繝｡繧ｽ繝?ラ縺ｯ縲∝?譛溘′邨ゆｺ?ｾ後↓縲∝?繧ｻ繝?ヨ縺励∪縺吶?
778             *
779             * @og.rev 3.7.0.4 (2005/03/18) 譁ｰ隕丈ｽ懈?
780             *
781             * @param       columnName      繧ｫ繝ｩ繝?錐
782             */
783            @Override
784            public void setNoDisplay( final String columnName ) {
785                    noDisplayKeys = columnName;
786            }
787    
788            /**
789             * 陦ｨ遉ｺ蜿ｯ閭ｽ繧ｫ繝ｩ繝?錐繧偵?繧ｫ繝ｳ繝槫玄蛻?ｊ縺ｧ荳弱∴縺ｾ縺吶?
790             * 萓具ｼ?OYA,KO,HJO,SU,DYSET,DYUPD"
791             * setColumnDisplay( int column,boolean rw ) 縺ｮ邁｡譏鍋沿縺ｧ縺吶?
792             * null 繧剃ｸ弱∴縺溷?蜷医?,縺ｪ縺ｫ繧ゅ＠縺ｾ縺帙ｓ縲?
793             * 縺ｾ縺溘?蜈ｨ繧ｫ繝ｩ繝?↓縺､縺?※縲∵怏蜉ｹ縺ｫ縺吶ｋ蝣ｴ蜷医?縲…olumnName="*" 繧定ｨｭ螳壹＠縺ｾ縺吶?
794             *
795             * @og.rev 5.2.2.0 (2010/11/01) 譁ｰ隕剰ｿｽ蜉?
796             *
797             * @param       columnName      繧ｫ繝ｩ繝?錐
798             */
799            @Override
800            public void setColumnDisplay( final String columnName ) {
801                    columnDisplayKeys = columnName;
802            }
803    
804            /**
805             * NUMBER 繧ｽ繝ｼ繝域ｩ溯?(謨ｴ謨ｰ髯仙ｮ? 蜀?Κ繧ｯ繝ｩ繧ｹ
806             * 縺薙ｌ縺ｯ騾壼ｸｸ縺ｮ繧ｽ繝ｼ繝医〒縺ｯ縺ｪ縺上?繝倥ャ繝??縺ｫ菴ｿ縺?Λ繝吶Ν縺ｮ繧ｽ繝ｼ繝医↑縺ｮ縺ｧ縲?
807             * 謨ｴ謨ｰ縺ｮ縺ｿ縺ｨ髯仙ｮ壹＠縺ｾ縺吶?螳滓焚縺ｮ蝣ｴ蜷医?縲∵｡∝粋繧上○(蟆乗焚轤ｹ莉･荳九?譯∵焚)
808             * 縺輔ｌ縺ｦ縺?ｋ縺ｨ縺?≧蜑肴署縺ｧ縺吶?
809             *
810             * @og.rev 3.5.6.3 (2004/07/12) 譁ｰ隕丈ｽ懈?
811             *
812             */
813            private static final Comparator<String> numberSort = new NumberComparator();
814    
815            private static class NumberComparator implements Comparator<String>,Serializable {
816                    private static final long serialVersionUID = 4000 ;     // 4.0.0 (2005/01/31)
817    
818                    public int compare( final String s1, final String s2 ) {
819                            if( s1.length() > s2.length() )      { return 1;  }
820                            else if( s1.length() < s2.length() ) { return -1; }
821                            else {
822                                    return s1.compareTo( s2 );
823                            }
824                    }
825            }
826    
827            /**
828             * 陦ｨ遉ｺ鬆?岼縺ｮ邱ｨ髮?荳ｦ縺ｳ譖ｿ縺?縺悟庄閭ｽ縺九←縺?°繧定ｿ斐＠縺ｾ縺?
829             *
830             * @og.rev 5.1.6.0 (2010/05/01) 譁ｰ隕剰ｿｽ蜉?
831             *
832             * @return      陦ｨ遉ｺ鬆?岼縺ｮ邱ｨ髮?荳ｦ縺ｳ譖ｿ縺?縺悟庄閭ｽ縺九←縺?°(false:荳榊庄閭ｽ)
833             */
834            @Override
835            public boolean isEditable() {
836                    return false;
837            }
838    }