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.report;
017    
018    import org.opengion.hayabusa.common.HybsSystem;
019    import org.opengion.hayabusa.db.DBTableModelUtil;
020    import org.opengion.hayabusa.db.DBTableModel;
021    import org.opengion.hayabusa.resource.ResourceFactory;
022    import org.opengion.hayabusa.resource.ResourceManager;
023    import org.opengion.fukurou.util.StringUtil;
024    import org.opengion.fukurou.util.FileUtil;
025    import org.opengion.fukurou.util.ApplicationInfo;
026    import org.opengion.fukurou.db.DBUtil;
027    
028    import java.io.File;
029    
030    /**
031     * 縲舌Ξ繝昴?繝亥?蜉帙?DBTableModel繧ｪ繝悶ず繧ｧ繧ｯ繝医ｒ繝ｬ繝昴?繝亥ｽ｢蠑上↓霑秘ｄ縺吶ｋ繧ｿ繧ｰ繝ｪ繝悶け繝ｩ繧ｹ縺ｧ縺吶?
032     * 縺薙?繧ｪ繝悶ず繧ｧ繧ｯ繝医↓縲?繝??繧ｿ(DBTableModel)縺ｨ縲√さ繝ｳ繝医Ο繝ｼ繝ｩ(DBTableReport 繧ｯ繝ｩ繧ｹ)繧剃ｸ弱∴縺ｦ縲?
033     * 螟夜Κ縺九ｉ繧ｳ繝ｳ繝医Ο繝ｼ繝ｫ縺吶ｋ縺薙→縺ｧ縲∝推遞ｮ蠖｢蠑上〒 繝??繧ｿ(DBTableModel)繧定｡ｨ遉ｺ縺輔○繧九％縺ｨ縺?
034     * 蜿ｯ閭ｽ縺ｧ縺吶?
035     *
036     * @og.group 蟶ｳ逾ｨ繧ｷ繧ｹ繝?Β
037     *
038     * @version  4.0
039     * @author   Kazuhiko Hasegawa
040     * @since    JDK5.0,
041     */
042    public class ReportConverter {
043    
044            private static final String CR     = HybsSystem.CR ;
045    
046            private final StringBuilder errMsg = new StringBuilder();
047    
048            // DBTableReport 縺ｫ蟇ｾ縺励※險ｭ螳壹☆繧区ュ蝣ｱ
049            private String[]        headerKeys              = null;   // 蝗ｺ螳夐Κ縺ｮ key 驛ｨ蛻?ｒ謖?ｮ壹☆繧九?繧ｫ繝ｳ繝槭〒隍?焚謖?ｮ壹〒縺阪ｋ縲?
050            private String[]        headerVals              = null;   // 蝗ｺ螳夐Κ縺ｮ key 縺ｫ蟇ｾ蠢懊☆繧句?繧呈欠螳壹☆繧九?
051            private String[]        footerKeys              = null;   // 郢ｰ繧願ｿ斐＠驛ｨ縺ｮ邨ゆｺ?ｾ後↓陦ｨ遉ｺ縺吶ｋ key 驛ｨ蛻?ｒ謖?ｮ壹☆繧九?繧ｫ繝ｳ繝槭〒隍?焚謖?ｮ壹〒縺阪ｋ縲?
052            private String[]        footerVals              = null;   // 郢ｰ繧願ｿ斐＠驛ｨ縺ｮ邨ゆｺ?ｾ後↓陦ｨ遉ｺ縺吶ｋ key 縺ｫ蟇ｾ縺吶ｋ蛟､繧呈欠螳壹☆繧九?
053            private boolean         pageEndCut              = false;  // 繝懊ョ繧｣繝ｼ驛ｨ(郢ｰ繧願ｿ斐＠驛ｨ)縺後↑縺上↑縺｣縺溘→縺阪↓縲√◎繧御ｻ･髯阪?繝壹?繧ｸ繧貞?蜉帙☆繧九°謖?ｮ壹☆繧九?
054            private File            templateFile    = null;         // 3.8.0.0 (2005/06/07)
055            private File            firstTemplateFile = null;       // 3.8.0.0 (2005/06/07)
056            private DBTableModel    table           = null;
057            private ResourceManager resource        = null;         // 4.0.0 (2005/01/31)
058    
059            // 蜿励￠貂｡縺怜､画焚
060            private final String    SYSTEM_ID       ;
061            private final String    YKNO            ;
062            private final String    LISTID          ;
063            private final String    HTML_DIR        ;
064            private final String    LANG            ;
065            private final boolean   DEBUG           ;       // 3.8.5.0 (2006/03/06) 繝?ヰ繝?げ逕ｨ縺ｮ繝輔Λ繧ｰ繧定ｿｽ蜉?
066    
067            // GE54 蟶ｳ逾ｨ螳夂ｾｩ繝槭せ繧ｿ
068            private String          modelDIR        = null;
069            private String          modelFILE       = null;
070            private String          hSQL            = null;
071            private String          fSQL            = null;
072            private String          bSQL            = null;
073            private boolean         fgLOCAL         = false;        // 0:譛ｪ菴ｿ逕ｨ 1:菴ｿ逕ｨ 4.0.0 (2005/01/31)
074            private boolean         fgDIRECT        = false;        // 0:譛ｪ菴ｿ逕ｨ 1:菴ｿ逕ｨ 4.0.0 (2005/01/31)
075    
076            // GE54 縺ｮ蟶ｳ逾ｨ螳夂ｾｩ諠??繧貞叙蠕励☆繧鬼QL譁?〒縺吶?
077            // 4.0.0 (2005/01/31) 蜈ｱ譛?system_id 繧偵?閠??
078            private static final String GE54_SELECT =
079                    "SELECT MODELDIR,MODELFILE,FGCUT,HSQL,FSQL,BSQL,FGLOCAL,FGDIRECT,SYSTEM_ID" +   // 4.0.0 (2005/01/31)
080                    " FROM GE54" +
081                    " WHERE FGJ = '1'" +
082                    " AND  SYSTEM_ID IN (?,'**')" +
083                    " AND  LISTID = ?" ;
084    
085            private static final int GE54_MODELDIR  = 0;
086            private static final int GE54_MODELFILE = 1;
087            private static final int GE54_FGCUT             = 2;
088            private static final int GE54_HSQL              = 3;
089            private static final int GE54_FSQL              = 4;
090            private static final int GE54_BSQL              = 5;
091            private static final int GE54_FGLOCAL   = 6;
092            private static final int GE54_FGDIRECT  = 7;
093            private static final int GE54_SYSTEM_ID = 8;
094    
095            /** 繧ｳ繝阪け繧ｷ繝ｧ繝ｳ縺ｫ繧｢繝励Μ繧ｱ繝ｼ繧ｷ繝ｧ繝ｳ諠??繧定ｿｽ險倥☆繧九°縺ｩ縺?°謖?ｮ?*/
096            public static final boolean USE_DB_APPLICATION_INFO  = HybsSystem.sysBool( "USE_DB_APPLICATION_INFO" ) ;
097    
098            // 3.8.7.0 (2006/12/15) 繧｢繧ｯ繧ｻ繧ｹ繝ｭ繧ｰ蜿門ｾ励?轤ｺ,ApplicationInfo繧ｪ繝悶ず繧ｧ繧ｯ繝医ｒ險ｭ螳?
099            private final ApplicationInfo appInfo;
100            private final String DBID = HybsSystem.sys( "RESOURCE_DBID" );          // 5.5.5.1 (2012/08/07) 繝ｪ繧ｽ繝ｼ繧ｹ邉ｻDBID 莉倥￠蠢倥ｌ蟇ｾ蠢?
101    
102            /**
103             * 繧ｳ繝ｳ繧ｹ繝医Λ繧ｯ繧ｿ繝ｼ
104             * 蠑墓焚繧貞女縺代→縺｣縺ｦ縲√う繝ｳ繧ｹ繧ｿ繝ｳ繧ｹ繧剃ｽ懈?縺励∪縺吶?
105             *
106             * @og.rev 3.0.0.4 (2003/02/26) FGRUN 縺?PRT 縺ｮ縺ｿ縺ｮ縺ｨ縺阪??勲ODELFILE 縺ｮ縺ｿ繧ｻ繝?ヨ縺励※邨ゆｺ?☆繧九?
107             * @og.rev 3.8.0.0 (2005/06/07) FGRUN縺ｯ?御ｽｿ逕ｨ縺励↑縺?
108             * @og.rev 3.8.7.0 (2006/12/15) 繧｢繧ｯ繧ｻ繧ｹ繝ｭ繧ｰ蜿門ｾ励?轤ｺ,ApplicationInfo繧ｪ繝悶ず繧ｧ繧ｯ繝医ｒ險ｭ螳?
109             *
110             * @param system_id 繧ｷ繧ｹ繝?ΒID
111             * @param ykno 隕∵ｱら分蜿ｷ
112             * @param listId 蟶ｳ逾ｨID
113             * @param tempDir 蜃ｺ蜉帙ョ繧｣繝ｬ繧ｯ繝医Μ
114             * @param lang 險?ｪ?
115             * @param debug 繝?ヰ繝?げ繝輔Λ繧ｰ險?ｪ?
116             */
117            public ReportConverter( final String system_id, final String ykno, final String listId,
118                                                             final String tempDir,final String lang,final boolean debug ) {
119                    SYSTEM_ID       = system_id;
120                    YKNO            = ykno;
121                    LISTID          = listId;
122                    HTML_DIR        = tempDir;
123                    LANG            = lang;
124                    DEBUG           = debug;
125    
126                    // 3.8.7.0 (2006/12/15) 繧｢繧ｯ繧ｻ繧ｹ繝ｭ繧ｰ蜿門ｾ励?轤ｺ,ApplicationInfo繧ｪ繝悶ず繧ｧ繧ｯ繝医ｒ險ｭ螳?
127                    if( USE_DB_APPLICATION_INFO ) {
128                            appInfo = new ApplicationInfo();
129                            // 繝ｦ繝ｼ繧ｶ繝ｼID,IP繧｢繝峨Ξ繧ｹ,繝帙せ繝亥錐
130                            appInfo.setClientInfo( SYSTEM_ID,HybsSystem.HOST_ADRS,HybsSystem.HOST_NAME );
131                            // 逕ｻ髱｢ID,謫堺ｽ?繝励Ο繧ｰ繝ｩ繝?D
132                            appInfo.setModuleInfo( "ReportConverter",YKNO,LISTID );
133                    }
134                    else {
135                            appInfo = null;
136                    }
137            }
138    
139            /**
140             * 螟画鋤蜃ｦ逅?ｒ螳溯｡後＠縺ｾ縺吶?
141             *
142             * @og.rev 3.0.0.4 (2003/02/26) FGRUN 縺?PRT 縺ｮ縺ｿ縺ｮ縺ｨ縺阪??勲ODELFILE 縺ｮ縺ｿ繧ｻ繝?ヨ縺励※邨ゆｺ?☆繧九?
143             * @og.rev 3.5.4.9 (2004/02/25) 蟄伜惠繝√ぉ繝?け繧ｨ繝ｩ繝ｼ(蜴溷屏荳肴?)縺ｮ證ｫ螳壼ｯｾ蠢?
144             * @og.rev 3.8.0.0 (2005/06/07) initialDataSet() 繧?ReportProcessing 蛛ｴ縺ｧ蜻ｼ縺ｳ蜃ｺ縺励∪縺吶?
145             *
146             * @return 邨先棡 [true:豁｣蟶ｸ/false:逡ｰ蟶ｸ]
147             */
148            public boolean execute() {
149                    System.out.print( "ReportConverter Started ... " );
150                    boolean flag = true;
151    
152                    try {
153                            // 髮帛ｽ｢繝輔ぃ繧､繝ｫ縺ｮ繝√ぉ繝?け
154                            // 3.8.0.0 (2005/06/07) 蟄伜惠繝√ぉ繝?け縺ｯ縲：ileUtil.checkFile 縺ｧ陦後≧縲?
155                            if( flag ) {
156                                    System.out.print( "MDL CK," );
157                                    templateFile = FileUtil.checkFile( modelDIR, modelFILE + ".html" );
158                                    flag = ( templateFile != null ) ;               // 繝√ぉ繝?け縺ｮ邨先棡縺?null 縺ｪ繧峨?隕九▽縺九ｉ縺ｪ縺九▲縺溘?
159    
160                                    if( !flag ) {
161                                            errMsg.append( "ModelFile Not Found Error !" ).append( CR );
162                                            errMsg.append( "MODELDIR=" ).append( modelDIR ).append( CR );
163                                            errMsg.append( "MODELFILE=" ).append( modelFILE + ".html" ).append( CR );
164                                    }
165                            }
166    
167                            // 繝輔ぃ繝ｼ繧ｹ繝医?繝ｼ繧ｸ髮帛ｽ｢繝輔ぃ繧､繝ｫ縺ｮ繝√ぉ繝?け(縺ｪ縺上※繧り憶縺?
168                            // 3.8.0.0 (2005/06/07) 蟄伜惠繝√ぉ繝?け縺ｯ縲：ileUtil.checkFile 縺ｧ陦後≧縲?
169                            if( flag ) {
170                                    // 繝√ぉ繝?け縺ｯ縲?ｼ大屓縺ｮ縺ｿ陦後≧縲?
171                                    firstTemplateFile = FileUtil.checkFile( modelDIR, modelFILE + "_FIRST.html",1 );
172                            }
173    
174                            // 繝倥ャ繝?ｼ後ヵ繝?ち, 繝懊ョ繧｣繝ｼ驛ｨ縺ｮ SQL 繧貞ｮ溯｡後＠縺ｾ縺吶?
175                            if( flag ) {
176    //                              flag = getHeaderFooter();
177                                    flag = isHeaderFooter();
178                                    if( flag ) { System.out.print( "HF SQL," ); }
179                            }
180    
181                            // 蟶ｳ逾ｨ螟画鋤蜃ｦ逅?ｒ螳溯｡後＠縺ｾ縺吶?
182                            if( flag ) {
183                                    flag = reportRun();
184                                    if( flag ) { System.out.print( "RPT RUN," ); }
185                            }
186                    }
187                    catch ( RuntimeException ex ) {
188                            errMsg.append( "ReportConverter Execute Exception Error!" ).append( CR );
189                            errMsg.append( "==============================" ).append( CR );
190                            errMsg.append( StringUtil.stringStackTrace( ex ) ) ;
191                            errMsg.append( CR ) ;
192                            flag = false;
193                    }
194    
195                    System.out.println( "End." );
196                    return flag ;
197            }
198    
199            /**
200             * 蛻晄悄繝??繧ｿ繧ｻ繝?ヨ繧定｡後＞縺ｾ縺吶?
201             * 縺薙％縺ｧ縺ｯ縲；E54 繝??繝悶Ν繧医ｊ蠢?ｦ√↑諠??繧貞叙蠕励＠縺ｾ縺吶?
202             *
203             * @og.rev 3.8.0.0 (2005/06/07) initialDataSet() 繧?ReportProcessing 蛛ｴ縺ｧ蜻ｼ縺ｳ蜃ｺ縺励∪縺吶?
204             * @og.rev 3.8.7.0 (2006/12/15) 繧｢繧ｯ繧ｻ繧ｹ繝ｭ繧ｰ蜿門ｾ励?轤ｺ,ApplicationInfo繧ｪ繝悶ず繧ｧ繧ｯ繝医ｒ險ｭ螳?
205             * @og.rev 4.0.0.0 (2005/01/31) 繝ｭ繝ｼ繧ｫ繝ｫ繝ｪ繧ｽ繝ｼ繧ｹ繝輔Λ繧ｰ縺ｨ繝?う繝ｬ繧ｯ繝医い繧ｯ繧ｻ繧ｹ繝輔Λ繧ｰ繧定ｿｽ蜉?
206             * @og.rev 5.5.5.1 (2012/08/07) 繝ｪ繧ｽ繝ｼ繧ｹ邉ｻDBID 莉倥￠蠢倥ｌ蟇ｾ遲?
207             *
208             * @return 邨先棡 [true:豁｣蟶ｸ/false:逡ｰ蟶ｸ]
209             */
210            public boolean initialDataSet() {
211                    String[] args = new String[] { SYSTEM_ID,LISTID };
212                    // modeldir,modelfile,fgcut,hsql,fsql,bsql,fglocal,fgdirect,system_id
213    //              String[][] vals = DBUtil.dbExecute( GE54_SELECT,args,appInfo );                         // 3.8.7.0 (2006/12/15)
214                    String[][] vals = DBUtil.dbExecute( GE54_SELECT,args,appInfo, DBID );           // 5.5.5.1 (2012/08/07)
215                    if( vals == null || vals.length == 0 ) {
216                            errMsg.append( "Data does not exist in GE54 table." ).append( CR );
217                            errMsg.append( "==============================" ).append( CR );
218                            errMsg.append( "SYSTEM_ID=[" ).append( SYSTEM_ID ).append( "] , " );
219                            errMsg.append( "LISTID=["    ).append( LISTID    ).append( "]" );
220                            errMsg.append( CR );
221                            return false;
222                    }
223    
224                    int row = 0;
225                    // 讀懃ｴ｢邨先棡縺瑚､?焚蟶ｰ縺｣縺溘→縺阪?SYSTEM_ID 縺?謖?ｮ壹＆繧後※縺?ｋ譁ｹ縺ｮ繝??繧ｿ(陦?繧呈治逕ｨ縺吶ｋ縲?
226                    for( int i=0; i<vals.length; i++ ) {
227                            if( SYSTEM_ID.equalsIgnoreCase( vals[i][GE54_SYSTEM_ID] ) ) { row = i; break; }
228                    }
229    
230                    modelDIR        = StringUtil.nval( vals[row][GE54_MODELDIR],modelDIR );
231                    modelFILE       = StringUtil.nval( vals[row][GE54_MODELFILE],modelFILE );
232                    pageEndCut      = StringUtil.nval( vals[row][GE54_FGCUT],pageEndCut );  // boolean 繧ｿ繧､繝?
233    
234                    if( DEBUG ) {
235                            System.out.println( "MODELDIR   = [" + modelDIR   + "]" );
236                            System.out.println( "MODELFILE  = [" + modelFILE  + "]" );
237                            System.out.println( "pageEndCut = [" + pageEndCut + "]" );
238                    }
239    
240                    hSQL = StringUtil.nval( vals[row][GE54_HSQL],hSQL );
241                    fSQL = StringUtil.nval( vals[row][GE54_FSQL],fSQL );
242                    bSQL = StringUtil.nval( vals[row][GE54_BSQL],bSQL );
243                    if( bSQL == null || bSQL.length() == 0 ) {
244                            errMsg.append( "Body SQL Columns does not exist in GE54 table." ).append( CR );
245                            errMsg.append( "==============================" ).append( CR );
246                            errMsg.append( "SYSTEM_ID=[" ).append( SYSTEM_ID ).append( "] , " );
247                            errMsg.append( "LISTID=["    ).append( LISTID    ).append( "] " );
248                            errMsg.append( CR );
249                            return false;
250                    }
251    
252                    // 4.0.0 (2005/01/31) 繝ｭ繝ｼ繧ｫ繝ｫ繝ｪ繧ｽ繝ｼ繧ｹ繝輔Λ繧ｰ縺ｨ繝?う繝ｬ繧ｯ繝医い繧ｯ繧ｻ繧ｹ繝輔Λ繧ｰ繧定ｿｽ蜉?
253                    fgLOCAL = ( vals[row][GE54_FGLOCAL]  != null && vals[row][GE54_FGLOCAL].trim().equals( "1" ) ) ? true : false ;
254                    fgDIRECT= ( vals[row][GE54_FGDIRECT] != null && vals[row][GE54_FGDIRECT].trim().equals( "1" ) ) ? true : false ;
255    
256                    return true;
257            }
258    
259            /**
260             * 繝倥ャ繝??繝輔ャ繧ｿ繝ｼ諠??縺ｮ蜿門ｾ励ｒ陦後＞縺ｾ縺吶?
261             * GE54 縺ｮ HSQL,FSQL,BSQL 縺ｮ繧ｳ繝槭Φ繝峨ｒ螳溯｡後＠縺ｦ縲√ョ繝ｼ繧ｿ繧貞叙蠕励＠縺ｾ縺吶?
262             * 繝倥ャ繝??諠??縲√ヵ繝?ち繝ｼ諠??縺後↑縺上※繧ら焚蟶ｸ縺ｨ縺ｯ蛻､譁ｭ縺輔ｌ縺ｾ縺帙ｓ縺後?
263             * 繝懊ョ繧｣諠??縺悟ｭ伜惠縺励↑縺??蜷医?縲√お繝ｩ繝ｼ縺ｨ縺ｪ繧翫∪縺吶?
264             *
265             * @og.rev 3.0.0.1 (2003/02/14) 繝倥ャ繝??縲√ヵ繝?ち繝ｼ諠??縺?null 縺ｮ縺ｨ縺阪?蜃ｦ逅?ｿｽ蜉??
266             * @og.rev 3.0.1.3 (2003/03/11) 讀懃ｴ｢譎ゅ?譛?､ｧ莉ｶ謨ｰ縺ｧ縺ｮ謇薙■蛻?ｊ繧偵お繝ｩ繝ｼ縺ｨ縺吶ｋ縲?
267             * @og.rev 3.8.7.0 (2006/12/15) 繧｢繧ｯ繧ｻ繧ｹ繝ｭ繧ｰ蜿門ｾ励?轤ｺ,ApplicationInfo繧ｪ繝悶ず繧ｧ繧ｯ繝医ｒ險ｭ螳?
268             * @og.rev 4.0.0.0 (2005/01/31) lang 竍?ResourceManager 縺ｸ螟画峩 , 繝｡繧ｽ繝?ラ蜷榊､画峩
269             *
270             * @return 邨先棡 [true:豁｣蟶ｸ/false:逡ｰ蟶ｸ]
271             */
272    //      private boolean getHeaderFooter() {
273            private boolean isHeaderFooter() {
274                    // 4.0.0 (2005/01/31) FGLOCAL 謖?ｮ壽凾縺ｯ縲ヾYSTEM_ID 繧呈欠螳壹＠縺ｦ繝ｪ繧ｽ繝ｼ繧ｹ菴懈?
275                    if( fgLOCAL ) {
276                            // 繝ｭ繝ｼ繧ｫ繝ｫ繝ｪ繧ｽ繝ｼ繧ｹ謖?ｮ壽凾縺ｯ縲ヾYSTEM_ID,LANG 繧剃ｽｿ逕ｨ縺励∪縺吶?蜈郁ｪｭ縺ｿ縺ｯ縲∽ｽｿ逕ｨ縺励∪縺帙ｓ縲?
277                            resource = ResourceFactory.newInstance( SYSTEM_ID,LANG,false ); // 4.0.0 (2005/01/31)
278                    }
279                    else {
280                            // 蠕捺擂縺ｨ莠呈鋤諤ｧ縺ｮ縺ゅｋ繝｢繝ｼ繝?繝ｭ繝ｼ繧ｫ繝ｫ繝ｪ繧ｽ繝ｼ繧ｹ縺ｯ菴ｿ逕ｨ縺励↑縺??
281                            resource = ResourceFactory.newInstance( LANG ); // 4.0.0 (2005/01/31)
282                    }
283    
284                    // 4.0.0 (2005/01/31) FGDIRECT 謖?ｮ壽凾縺ｯ縲『here 譚｡莉ｶ縺ｯ縲］ull 縺ｫ縺ｪ繧翫∪縺吶?
285                    String[] where = ( fgDIRECT ) ? null : new String[] { SYSTEM_ID , YKNO } ;
286    
287                    // 繝倥ャ繝??諠??縺ｮ蜿門ｾ?
288                    DBTableModel header = DBTableModelUtil.makeDBTable( hSQL, where, resource, appInfo );           // 3.8.7.0 (2006/12/15)
289                    if( header != null && header.getRowCount() > 0 ) {
290                            headerKeys              = header.getNames();
291                            Object[] obj    = header.getValues(0);
292                            headerVals              = new String[obj.length];
293                            for( int i=0; i<obj.length; i++ ) {
294                                    headerVals[i] = obj[i].toString().trim();
295                            }
296                    }
297    
298                    // 繝輔ャ繧ｿ繝ｼ諠??縺ｮ蜿門ｾ?
299                    DBTableModel footer = DBTableModelUtil.makeDBTable( fSQL, where, resource ,appInfo );           // 3.8.7.0 (2006/12/15)
300                    if( footer != null && footer.getRowCount() > 0 ) {
301                            footerKeys              = footer.getNames();
302                            Object[] obj    = footer.getValues(0);
303                            footerVals              = new String[obj.length];
304                            for( int i=0; i<obj.length; i++ ) {
305                                    footerVals[i] = obj[i].toString().trim();
306                            }
307                    }
308    
309                    // 繝懊ョ繧｣繝ｼ諠??縺ｮ蜿門ｾ?
310                    table = DBTableModelUtil.makeDBTable( bSQL, where, resource ,appInfo );         // 3.8.7.0 (2006/12/15)
311                    if( table.getRowCount() <= 0 ) {
312                            errMsg.append( "Database Body row count is Zero." ).append( CR );
313                            errMsg.append( "==============================" ).append( CR );
314                            errMsg.append( bSQL );
315                            errMsg.append( CR );
316                            return false;
317                    }
318                    // 3.0.1.3 (2003/03/11) 讀懃ｴ｢譎ゅ?譛?､ｧ莉ｶ謨ｰ縺ｧ縺ｮ謇薙■蛻?ｊ繧偵お繝ｩ繝ｼ縺ｨ縺吶ｋ縲?
319                    if( table.isOverflow() ) {
320                            errMsg.append( "Database is Overflow. [" );
321                            errMsg.append( table.getRowCount() );
322                            errMsg.append( "]" ).append( CR ).append( CR );
323                            errMsg.append( "==============================" ).append( CR );
324                            errMsg.append( "Check SystemParameter Data in DB_MAX_ROW_COUNT Overflow" );
325                            errMsg.append( CR );
326                            return false;
327                    }
328    
329                    return true;
330            }
331    
332            /**
333             * 螳滄圀縺ｮ繝ｬ繝昴?繝亥､画鋤蜃ｦ逅?ｒ陦後＞縺ｾ縺吶?
334             *
335             * @og.rev 3.5.4.3 (2004/01/05) HTMLDBTableReport 縺ｮ繧ｯ繝ｩ繧ｹ蜷榊､画峩縲?
336             * @og.rev 3.6.0.0 (2004/09/17) 繝｡繧ｽ繝?ラ蜷阪?螟画峩縲ＴetInputFile 竍?setTemplateFile
337             * @og.rev 3.6.1.0 (2005/01/05) 蟶ｳ逾ｨ?ｩ?､(LISTID)繧偵そ繝?ヨ縺励∪縺吶?
338             * @og.rev 3.8.5.1 (2006/04/28) setOutputFileKey 縺ｮ莉｣繧上ｊ縺ｫ縲《etYkno 繧剃ｽｿ逕ｨ縺励∪縺吶?
339             * @og.rev 4.0.0.0 (2005/01/31) lang 竍?ResourceManager 縺ｸ螟画峩
340             *
341             * @return 邨先棡 [true:豁｣蟶ｸ/false:逡ｰ蟶ｸ]
342             */
343            private boolean reportRun() {
344                    DBTableReport report = new DBTableReport_HTML();
345    
346                    report.setDBTableModel( table );
347                    report.setTemplateFile( templateFile );                         // 3.6.0.0 (2004/09/17)
348                    report.setFirstTemplateFile( firstTemplateFile );       // 3.6.0.0 (2004/09/17)
349                    report.setOutputDir( HTML_DIR );
350                    report.setOutputFileKey( YKNO );        // 隕∵ｱら分蜿ｷ繧偵ヵ繧｡繧､繝ｫ蜷阪→縺励※菴ｿ逕ｨ縺励∪縺吶?
351                    report.setYkno( YKNO );                                                         // 3.8.5.1 (2006/04/28)
352                    report.setHeaderKeys( headerKeys );
353                    report.setHeaderVals( headerVals );
354                    report.setFooterKeys( footerKeys );
355                    report.setFooterVals( footerVals );
356                    report.setPageEndCut( pageEndCut );
357                    report.setResourceManager( resource );          // 4.0.0 (2005/01/31)
358                    report.setListId( LISTID );             // 3.6.1.0 (2005/01/05)
359                    report.writeReport();
360    
361                    return true;
362            }
363    
364            /**
365             * modelFILE 繧定ｿ斐＠縺ｾ縺吶?
366             *
367             * @return modelFILE蜷?
368             */
369            public String modelFile() {
370                    return modelFILE ;
371            }
372    
373            /**
374             * 繧ｨ繝ｩ繝ｼ縺悟ｭ伜惠縺励◆蝣ｴ蜷医↓縲√お繝ｩ繝ｼ繝｡繝?そ繝ｼ繧ｸ繧定ｿ斐＠縺ｾ縺吶?
375             *
376             * @return 繧ｨ繝ｩ繝ｼ繝｡繝?そ繝ｼ繧ｸ String
377             */
378            public String getErrMsg() {
379                    return errMsg.toString();
380            }
381    }