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.daemon;
017    
018    import org.opengion.hayabusa.common.HybsSystem;
019    import org.opengion.hayabusa.common.HybsSystemException;
020    import org.opengion.hayabusa.report.GE50Access;
021    import org.opengion.hayabusa.report.ReportProcessing;
022    import org.opengion.fukurou.util.LogWriter;
023    import org.opengion.fukurou.util.StringUtil;
024    import org.opengion.fukurou.util.HybsTimerTask;
025    import org.opengion.fukurou.util.ApplicationInfo;
026    import org.opengion.fukurou.db.DBUtil;
027    
028    import java.util.Map;
029    import java.util.HashMap;
030    import java.util.Date;
031    
032    /**
033     * 縲舌Ξ繝昴?繝亥?蜉帙?蟶ｳ逾ｨ隕∵ｱゅユ繝ｼ繝悶Ν繧堤屮隕悶＠縺ｦ縲∝ｸｳ逾ｨ蜃ｦ逅??繝ｭ繧ｰ繝ｩ繝?ｒ蜻ｼ縺ｳ蜃ｺ縺励∪縺吶?
034     * 縺薙?繧ｯ繝ｩ繧ｹ縺ｯ縲？ybsTimerTask 繧堤ｶ呎価縺励◆ 繧ｿ繧､繝槭?繧ｿ繧ｹ繧ｯ繧ｯ繝ｩ繧ｹ縺ｧ縺吶?
035     * startDaemon() 縺後ち繧､繝槭?繧ｿ繧ｹ繧ｯ縺ｫ繧医▲縺ｦ縲∝他縺ｳ蜃ｺ縺輔ｌ縺ｾ縺吶?
036     *
037     * @og.rev 4.3.4.4 (2009/01/01) 繝励Λ繧ｰ繧､繝ｳ蛹?
038     * @og.group 繝??繝｢繝ｳ
039     *
040     * @version  4.0
041     * @author   Kazuhiko Hasegawa
042     * @since    JDK5.0,
043     */
044    public class Daemon_Report extends HybsTimerTask {
045            //* 縺薙?繝励Ο繧ｰ繝ｩ繝??VERSION譁?ｭ怜?繧定ｨｭ螳壹＠縺ｾ縺吶?       {@value} */
046            private static final String VERSION = "4.3.4.4 (2009/01/01)" ;
047    
048            // 3.7.0.0 (2005/01/18) 隍?焚蜷梧凾繝??繝｢繝ｳ譎ゅ?縲∝酔荳?ｸｳ逾ｨID縺ｯ蜃ｦ逅?〒縺阪↑縺??
049            // 螳溯｡御ｸｭ縺ｮ蟶ｳ逾ｨID 繧偵そ繝?ヨ縺吶ｋ縲《tatic Map
050            private static final Map<String,String> USE_LISTID = new HashMap<String,String>();
051    
052            // 3.8.5.0 (2006/03/06) EXCEL繧偵が繝ｼ繝励Φ縺吶ｋ繝輔ぃ繧､繝ｫ蜷阪↓隕∵ｱら分蜿ｷ繧剃ｽｿ縺??蜷医?縲》rue
053            private static final boolean EXCEL_NAME_USE_YKNO = HybsSystem.sysBool( "REPORT_EXCEL_NAME_USE_YKNO" );
054    
055            // 5.2.0.0 (2010/09/01) Ver4莠呈鋤繝｢繝ｼ繝牙ｯｾ蠢?
056            private static final String OUT_FILE = HybsSystem.sysBool( "VER4_COMPATIBLE_MODE" ) ? "OUTFILE" : "OUT_FILE";
057            private static final String OUT_DIR = HybsSystem.sysBool( "VER4_COMPATIBLE_MODE" ) ? "OUTDIR" : "OUT_DIR";
058    
059            // 3.7.0.0 (2005/01/18) GE53 縺ｫ DMN_GRP霑ｽ蜉?↓繧医ｋ縲∵､懃ｴ｢譚｡莉ｶ縺ｮ螟画峩
060            // 5.1.0.0 (2009/11/04) OUTDIR 竍?OUT_DIR , OUTFILE 竍?OUT_FILE
061            // 5.2.0.0 (2010/09/01) Ver4莠呈鋤繝｢繝ｼ繝牙ｯｾ蠢?
062            private static final String GE50_SELECT =
063    //              "SELECT A.SYSTEM_ID,A.YKNO,A.GROUPID,A.LISTID,A.JOKEN,A.OUT_DIR,A.OUT_FILE,A.USRSET" +
064                    "SELECT A.SYSTEM_ID,A.YKNO,A.GROUPID,A.LISTID,A.JOKEN,A."+OUT_DIR+",A."+OUT_FILE+",A.USRSET" +
065                    " FROM GE50 A,GE53 B" +
066                    " WHERE A.SYSTEM_ID = B.SYSTEM_ID" +
067                    " AND A.JOKEN = B.JOKEN" +
068                    " AND A.FGJ = '1'" +
069                    " AND B.FGJ = '1'" +
070                    " AND A.FGKAN = '1'" ;
071    
072            private ReportProcessing  rc    = null;
073    
074            //       3.5.4.9 (2004/02/25) 繝｡繝?そ繝ｼ繧ｸ蜃ｺ蜉帶凾縺ｮ繝ｫ繝ｼ繝励き繧ｦ繝ｳ繝?繧定ｿｽ蜉?
075            private int                     loopCnt         = 0;
076            private static final int LOOP_COUNTER = 24;             // 繧ｫ繧ｦ繝ｳ繧ｿ繧?4蝗槭↓險ｭ螳?
077    
078            // 3.7.0.0 (2005/01/18) GE53 縺ｫ DMN_GRP霑ｽ蜉?↓繧医ｋ縲∵､懃ｴ｢譚｡莉ｶ縺ｮ螟画峩
079            private String GE_SELECT = null;
080    
081            // 3.8.5.0 (2006/03/06) 繝励Μ繝ｳ繧ｿID縺後?蠑墓焚縺九ｉ貂｡縺輔ｌ繧句?蜷医?蟇ｾ蠢?
082            private String PRTID    = null;
083            // 3.8.5.0 (2006/03/06) 繝??繝｢繝ｳ蜷阪ｒ險ｭ螳壹＠縺ｾ縺吶?
084            private String DMN_NAME = null;
085            // 3.8.5.0 (2006/03/06) 繝?ヰ繝?げ逕ｨ縺ｮ繝輔Λ繧ｰ繧定ｿｽ蜉?＠縺ｾ縺吶?
086            private boolean debug = false;          // 蟆乗枚蟄励↓菫ｮ豁｣
087    
088            // 3.8.5.3 (2006/06/30) 繧ｿ繧､繝槭?繧ｿ繧ｹ繧ｯ縺後く繝｣繝ｳ繧ｻ繝ｫ縺輔ｌ縺溷?蜷医?蛛懈ｭ｢繝輔Λ繧ｰ
089            private boolean running = true;
090    
091            /** 繧ｳ繝阪け繧ｷ繝ｧ繝ｳ縺ｫ繧｢繝励Μ繧ｱ繝ｼ繧ｷ繝ｧ繝ｳ諠??繧定ｿｽ險倥☆繧九°縺ｩ縺?°謖?ｮ?*/
092            public static final boolean USE_DB_APPLICATION_INFO  = HybsSystem.sysBool( "USE_DB_APPLICATION_INFO" ) ;
093    
094            // 3.8.7.0 (2006/12/15) 繧｢繧ｯ繧ｻ繧ｹ繝ｭ繧ｰ蜿門ｾ励?轤ｺ,ApplicationInfo繧ｪ繝悶ず繧ｧ繧ｯ繝医ｒ險ｭ螳?
095            private ApplicationInfo appInfo;
096            private final String DBID = HybsSystem.sys( "RESOURCE_DBID" );          // 5.5.5.1 (2012/08/07) 繝ｪ繧ｽ繝ｼ繧ｹ邉ｻDBID 莉倥￠蠢倥ｌ蟇ｾ蠢?
097    
098            /**
099             * 縺薙?繧ｿ繧､繝槭?繧ｿ繧ｹ繧ｯ縺ｫ繧医▲縺ｦ蛻晄悄蛹悶＆繧後ｋ繧｢繧ｯ繧ｷ繝ｧ繝ｳ縺ｧ縺吶?
100             * 繝代Λ繝｡繝ｼ繧ｿ繧剃ｽｿ逕ｨ縺励◆蛻晄悄蛹悶ｒ陦後＞縺ｾ縺吶?
101             *
102             * @og.rev 3.6.0.7 (2004/11/12) 譁ｰ隕剰ｿｽ蜉?
103             * @og.rev 3.7.0.0 (2005/01/18) 蟶ｳ逾ｨ螳夂ｾｩ繝槭せ繧ｿ(GE54)繧貞盾辣ｧ縺吶ｋ繧医≧縺ｫ莉墓ｧ伜､画峩
104             * @og.rev 3.8.7.0 (2006/12/15) 繧｢繧ｯ繧ｻ繧ｹ繝ｭ繧ｰ蜿門ｾ励?轤ｺ,ApplicationInfo繧ｪ繝悶ず繧ｧ繧ｯ繝医ｒ險ｭ螳?
105             * @og.rev 4.0.1.0 (2007/12/19) GE50縺ｮ讀懃ｴ｢鬆?ｒ繧ｷ繧ｹ繝?Β繝ｪ繧ｽ繝ｼ繧ｹ縺ｧ險ｭ螳壼庄閭ｽ縺ｫ縺吶ｋ
106             */
107            @Override
108            public void initDaemon() {
109    
110                    // 3.7.0.0 (2005/01/18) GE50, GE54 縺ｮ USRUPD 縺ｫ縲√ョ繝ｼ繝｢繝ｳ蜷阪ｒ繧ｻ繝?ヨ縺励∪縺吶?
111                    // 3.7.1.1 (2005/05/31) GE50Access 繧剃ｽｿ逕ｨ縺励※縲．B逋ｻ骭ｲ繧定｡後＞縺ｾ縺吶?
112    
113                    // 3.8.5.0 (2006/03/06) 繝??繝｢繝ｳ蜷阪ｒ險ｭ螳壹＠縺ｾ縺吶?
114                    DMN_NAME = getName();
115    
116                    StringBuilder buf = new StringBuilder();
117                    buf.append( GE50_SELECT );
118    
119                    // SYSTEM_ID 縺ｯ縲∵欠螳壹′縺ｪ縺代ｌ縺ｰ縲∝?莉ｶ讀懃ｴ｢蟇ｾ雎｡縺ｫ縺ｪ繧翫∪縺吶?
120                    String systemId = getValue( "SYSTEM_ID" );
121                    if( ! StringUtil.isNull( systemId ) ) {
122    //              if( systemId != null && systemId.trim().length() > 0 ) {
123                            buf.append( " AND A.SYSTEM_ID='" ).append( systemId ).append( "'" );
124                    }
125    
126                    // 3.8.5.0 (2006/03/06) DMN_GRP 縺ｯ縲∝ｿ??謖?ｮ?
127                    // 5.1.9.0 (2010/08/01) Avoid if (x != y) ..; else ..;
128                    String dmnGroup = getValue( "DMN_GRP" );
129                    if( StringUtil.isNull( dmnGroup ) ) {
130                            String errMsg = "繝??繝｢繝ｳ繧ｰ繝ｫ繝ｼ繝励?蠢??謖?ｮ壹〒縺吶?" ;
131                            throw new HybsSystemException( errMsg );
132                    }
133                    else {
134                            buf.append( " AND B.DMN_GRP='" ).append( dmnGroup ).append( "'" );
135                    }
136    
137                    // 3.8.5.0 (2006/03/06) GE50 縺ｮ讀懃ｴ｢譚｡莉ｶ縺ｫ縲｀ODBASE 縺ｨ MODNO 繧剃ｽｿ逕ｨ縺吶ｋ縲?
138                    // 繝??繝｢繝ｳ襍ｷ蜍墓凾縺ｫ 譛?､ｧ謨ｰ(MODBASE)縺ｨ菴吶ｊ逡ｪ蜿ｷ(MODNO)繧呈ｸ｡縺励∪縺吶?
139                    // 譛?､ｧ謨ｰ(MODBASE)繧貞?縺ｫ縲∵､懃ｴ｢譎ゅ↓縲〆KNO縺ｮ菴吶ｊ繧呈ｱゅａ縲√％繧後′縲?
140                    // 蠑墓焚縺ｮ菴吶ｊ逡ｪ蜿ｷ(MODNO)縺ｨ荳??縺吶ｋ蝣ｴ蜷医?縺ｿ縲∝?逅?ｒ縺励∪縺吶?
141                    String modBase  = StringUtil.nval( getValue( "MODBASE" ),null );
142                    String modNo    = StringUtil.nval( getValue( "MODNO" ),null );
143                    if( modBase != null && modNo != null ) {
144                            buf.append( " AND MOD(A.YKNO," ).append( modBase ).append( ")=" ).append( modNo );
145                    }
146    
147                    // 3.8.5.0 (2006/03/06) PRTID 縺梧欠螳壹＆繧後※縺?ｌ縺ｰ縲√◎縺ｮ蛟､繧剃ｽｿ逕ｨ縺吶ｋ縲ゅ↑縺代ｌ縺ｰ NULL
148                    PRTID = StringUtil.nval( getValue( "PRTID" ), null );
149    
150                    // 3.8.5.0 (2006/03/06) PRT_GRP 縺梧欠螳壹＆繧後※縺?ｌ縺ｰ縲∵険蛻?擅莉ｶ讀懃ｴ｢譎ゅ↓菴ｿ逕ｨ縺吶ｋ縲?
151                    String prtGgrp = getValue( "PRT_GRP" );
152                    if( ! StringUtil.isNull( prtGgrp ) ) {
153    //              if( prtGgrp != null && prtGgrp.trim().length() > 0 ) {
154                            buf.append( " AND B.PRT_GRP='" ).append( prtGgrp ).append( "'" );
155                    }
156    
157    //              buf.append( " ORDER BY A.SYSTEM_ID,A.LISTID,A.GROUPID,A.YKNO
158                    buf.append( " ORDER BY " ); // 4.0.1.0 (2007/12/19)
159                    buf.append( HybsSystem.sys( "REPORT_DAEMON_ORDER_BY" ) );
160    
161                    GE_SELECT = buf.toString() ;
162    
163                    // 3.8.5.0 (2006/03/06) 繝?ヰ繝?げ逕ｨ縺ｮ繝輔Λ繧ｰ繧定ｿｽ蜉?＠縺ｾ縺吶?
164                    debug = StringUtil.nval( getValue( "DEBUG" ),debug ) ;
165    
166                    if( debug ) {
167                            System.out.println( "DMN_NAME=[" + DMN_NAME + "]" );
168                            System.out.println( "MODNO=[" + modNo + "]" );
169                            System.out.println( "QUERY=[" + GE_SELECT + "]" );
170                            System.out.println( "EXCEL_NAME_USE_YKNO=[" + EXCEL_NAME_USE_YKNO + "]" );
171                    }
172    
173                    // 3.8.7.0 (2006/12/15) 繧｢繧ｯ繧ｻ繧ｹ繝ｭ繧ｰ蜿門ｾ励?轤ｺ,ApplicationInfo繧ｪ繝悶ず繧ｧ繧ｯ繝医ｒ險ｭ螳?
174                    if( USE_DB_APPLICATION_INFO ) {
175                            appInfo = new ApplicationInfo();
176                            // 繝ｦ繝ｼ繧ｶ繝ｼID,IP繧｢繝峨Ξ繧ｹ,繝帙せ繝亥錐
177                            appInfo.setClientInfo( systemId,HybsSystem.HOST_ADRS,HybsSystem.HOST_NAME );
178                            // 逕ｻ髱｢ID,謫堺ｽ?繝励Ο繧ｰ繝ｩ繝?D
179                            appInfo.setModuleInfo( "ReportDaemon",PRTID,DMN_NAME );
180                    }
181                    else {
182                            appInfo = null;
183                    }
184            }
185    
186            /**
187             * 繧ｿ繧､繝槭?繧ｿ繧ｹ繧ｯ縺ｮ繝??繝｢繝ｳ蜃ｦ逅??髢句ｧ九?繧､繝ｳ繝医〒縺吶?
188             *
189             * @og.rev 3.5.2.0 (2003/10/20) vals 螟画焚繧偵?繝ｭ繝ｼ繧ｫ繝ｫ縺ｫ遘ｻ蜍?
190             * @og.rev 3.5.4.8 (2004/02/23) 繧ｿ繧､繝?せ繧ｿ繝ｳ繝励ｒ縲?ｼ托ｼ仙屓縺ｫ?大屓縺ｨ縺吶ｋ縲?
191             * @og.rev 3.6.0.0 (2004/09/17) 繧ｿ繧､繝?せ繧ｿ繝ｳ繝励ｒ縲?ｼ抵ｼ泌屓縺ｫ?大屓縺ｨ縺吶ｋ縲?
192             * @og.rev 3.6.1.0 (2005/01/05) tyr ??catch 繧?Exception 縺九ｉ Throwable 縺ｫ螟画峩縲?
193             * @og.rev 3.7.0.0 (2005/01/18) 隍?焚蜷梧凾繝??繝｢繝ｳ縺ｧ繧ゅ?蜷御ｸ?ｸｳ逾ｨID縺ｯ蜃ｦ逅?〒縺阪↑縺?ぜ縲√せ繧ｭ繝??縺励∪縺吶?
194             * @og.rev 3.7.0.4 (2005/03/18) 繧ｨ繝ｩ繝ｼ逋ｺ逕滓凾縺ｫ vals 縺?null 縺ｪ繧峨?HybsSystemException 繧?throw 縺吶ｋ縲?
195             * @og.rev 3.7.1.1 (2005/05/31) GE50Access 繧剃ｽｿ逕ｨ縺励※縲．B逋ｻ骭ｲ繧定｡後＞縺ｾ縺吶?
196             * @og.rev 3.8.0.0 (2005/06/07) EXCEL 蜿冶ｾｼ譎ゅ?螳梧?繝輔Λ繧ｰ縺ｯ縲：G_DBIN 縺ｨ縺励∪縺吶?
197             * @og.rev 3.8.0.0 (2005/06/07) rc.execute() 螳溯｡檎ｵ先棡繧?boolean 縺ｧ縺ｯ縺ｪ縺上?譁?ｭ怜?(FGKAN_XX)縺ｧ霑斐＠縺ｾ縺吶?
198             * @og.rev 3.8.5.0 (2006/03/06) EXCEL繝輔ぃ繧､繝ｫ蜷阪↓隕∵ｱら分蜿ｷ繧剃ｽｿ縺??蜷医?縲∝ｸｳ逾ｨID縺ｧ縺ｮ謗剃ｻ門宛蠕｡縺ｯ荳崎ｦ√?
199             * @og.rev 3.8.5.2 (2006/05/31) DEBUG 諠??縺ｮ蠑ｷ蛹?
200             * @og.rev 3.8.6.0 (2006/06/30) 繧ｿ繧､繝槭?繧ｿ繧ｹ繧ｯ縺後く繝｣繝ｳ繧ｻ繝ｫ縺輔ｌ縺溷?蜷医?蜃ｦ逅?ｒ霑ｽ蜉?running 繝輔Λ繧ｰ)
201             * @og.rev 3.8.7.0 (2006/12/15) 繧｢繧ｯ繧ｻ繧ｹ繝ｭ繧ｰ蜿門ｾ励?轤ｺ,ApplicationInfo繧ｪ繝悶ず繧ｧ繧ｯ繝医ｒ險ｭ螳?
202             * @og.rev 5.3.0.0 (2010/12/01) 繧ｨ繝ｩ繝ｼ繝上Φ繝峨Μ繝ｳ繧ｰ繧剃ｿｮ豁｣
203             * @og.rev 5.5.5.1 (2012/08/07) 繝ｪ繧ｽ繝ｼ繧ｹ邉ｻDBID 莉倥￠蠢倥ｌ蟇ｾ遲?
204             */
205            @Override
206            protected void startDaemon() {
207                    if( loopCnt % LOOP_COUNTER == 0 ) {
208                            loopCnt = 1;
209                            System.out.println();
210                            System.out.print( toString() + " " + new Date()  + " " );
211                    }
212                    else {
213                            System.out.print( "." );
214                            loopCnt++ ;
215                    }
216    
217                    // 3.7.1.1 (2005/05/31) GE50Access 繧剃ｽｿ逕ｨ縺励※縲．B逋ｻ骭ｲ繧定｡後＞縺ｾ縺吶?
218                    GE50Access ge50 = null ;
219    
220                    int row = 0;
221                    String[][] vals  = null;
222                    try {
223    //                      vals = DBUtil.dbExecute( GE_SELECT,null,appInfo );                      // 3.8.7.0 (2006/12/15)
224                            vals = DBUtil.dbExecute( GE_SELECT,null,appInfo, DBID );        // 5.5.5.1 (2012/08/07)
225                            if( vals != null && vals.length > 0 ) {
226    
227                                    // 3.7.1.1 (2005/05/31) GE50Access 繧剃ｽｿ逕ｨ縺励※縲．B逋ｻ骭ｲ繧定｡後＞縺ｾ縺吶?
228                                    // 豈主屓 繧ｪ繝悶ず繧ｧ繧ｯ繝医ｒ讒狗ｯ峨＠縺ｾ縺吶?逋ｻ骭ｲ譌･莉倥′蛻晄悄蛹悶＆繧後∪縺吶?
229                                    ge50 = new GE50Access( null,null,DMN_NAME ) ;           // 3.8.5.0 (2006/03/06)
230    
231                                    if( rc == null ) { rc = new ReportProcessing(); }
232                                    // 3.8.6.0 (2006/06/30) 繧ｿ繧､繝槭?繧ｿ繧ｹ繧ｯ縺後く繝｣繝ｳ繧ｻ繝ｫ縺輔ｌ縺溷?蜷医?蜃ｦ逅?ｒ霑ｽ蜉?running 繝輔Λ繧ｰ)
233                                    for( row=0; running && row<vals.length; row++ ) {
234                                            // 3.7.0.0 (2005/01/18) 菴ｿ逕ｨ荳ｭ縺ｮ蟶ｳ逾ｨID縺ｮ繝√ぉ繝?け縺ｨ縲∽ｽｿ逕ｨ譎ゅ?逋ｻ骭ｲ
235                                            String systemId = vals[row][0] ;
236                                            String ykno     = vals[row][1] ;
237                                            String listId   = vals[row][3] ;
238                                            // 3.8.5.0 (2006/03/06) EXCEL繝輔ぃ繧､繝ｫ蜷阪↓隕∵ｱら分蜿ｷ繧剃ｽｿ縺??蜷医?縲∝ｸｳ逾ｨID縺ｧ縺ｮ謗剃ｻ門宛蠕｡縺ｯ荳崎ｦ√?
239                                            if( ! EXCEL_NAME_USE_YKNO ) {
240                                                    synchronized( USE_LISTID ) {
241                                                            if( USE_LISTID.get( listId ) != null ) {
242                                                                    continue;       // 菴ｿ逕ｨ荳ｭ縺ｪ繧峨?鬟帙?縺吶?
243                                                            }
244                                                            else {
245                                                                    USE_LISTID.put( listId,"DUMMY" );
246                                                            }
247                                                    }
248                                            }
249    
250                                            // 繝?ヰ繝?げ諠??繧貞?蜉帙＠縺ｾ縺吶?
251                                            if( debug ) {
252                                                    System.out.println();
253                                                    System.out.print( "[" + DMN_NAME + "]:[" + ykno + "] START = " );
254                                                    System.out.println( new Date() );
255                                            }
256    
257                                            // 3.7.1.1 (2005/05/31) GE50Access 繧剃ｽｿ逕ｨ縺励※縲．B逋ｻ骭ｲ繧定｡後＞縺ｾ縺吶?
258                                            ge50.setSystemId( systemId );
259                                            ge50.setYkno( ykno );
260                                            ge50.updateGE50( GE50Access.FG_RUN );
261    
262                                            // system_id,ykno,groupid,listid,joken,outdir,outfile,usrset
263                                            rc.setSystemId( systemId     );
264                                            rc.setYkno(     ykno         );
265                                            rc.setGroupId(  vals[row][2] );
266                                            rc.setListId(   listId       );
267                                            rc.setJoken(    vals[row][4] );
268    //                                      rc.setPrtid(    PRTID        ); // 3.8.5.0 (2006/03/06) PRTID繧剃ｽｿ逕ｨ縺吶ｋ縲?
269                                            rc.setPrtId(    PRTID        ); // 4.3.4.4 (2009/01/01) 繝｡繧ｽ繝?ラ蜷榊､画峩
270                                            rc.setOutDir(   vals[row][5] );
271                                            rc.setOutFile(  vals[row][6] );
272                                            rc.setDebug(    debug        ); // 3.8.5.0 (2006/03/06) DEBUG繧定ｿｽ蜉??
273    
274                                            // 3.8.0.0 (2005/06/07) 螳溯｡檎ｵ先棡繧?boolean 縺ｧ縺ｯ縺ｪ縺上?譁?ｭ怜?(FGKAN_XX)縺ｧ霑斐＠縺ｾ縺吶?
275                                            String fgkan = rc.execute();
276                                            if( fgkan == null ) {
277                                                    fgkan = GE50Access.FG_ERR2 ;
278                                                    String errMsg = rc.getErrMsg();
279                                                    // 3.7.1.1 (2005/05/31) GE50Access 繧剃ｽｿ逕ｨ縺励※縲．B逋ｻ骭ｲ繧定｡後＞縺ｾ縺吶?
280                                                    ge50.insertErrorGE56( errMsg );
281                                            }
282    
283                                            // 3.7.1.1 (2005/05/31) GE50Access 繧剃ｽｿ逕ｨ縺励※縲．B逋ｻ骭ｲ繧定｡後＞縺ｾ縺吶?
284                                            ge50.updateGE50( fgkan );
285    
286                                            rc.clear();
287                                            // 3.8.5.0 (2006/03/06) EXCEL繝輔ぃ繧､繝ｫ蜷阪↓隕∵ｱら分蜿ｷ繧剃ｽｿ縺??蜷医?縲∝ｸｳ逾ｨID縺ｧ縺ｮ謗剃ｻ門宛蠕｡縺ｯ荳崎ｦ√?
288                                            if( ! EXCEL_NAME_USE_YKNO ) {
289                                                    // 3.7.0.0 (2005/01/18) 菴ｿ逕ｨ荳ｭ縺ｮ蟶ｳ逾ｨID縺ｮ蜑企勁
290                                                    synchronized( USE_LISTID ) {
291                                                            USE_LISTID.remove( listId );
292                                                    }
293                                            }
294    
295                                            // 繝?ヰ繝?げ諠??繧貞?蜉帙＠縺ｾ縺吶?
296                                            if( debug ) {
297                                                    System.out.println();
298                                                    System.out.print( "[" + DMN_NAME + "]:[" + ykno + "] END = " );
299                                                    System.out.println( new Date() );
300                                            }
301                                    }
302                            }
303                    }
304    //              catch( Throwable ex ) {         // 3.6.1.0 (2005/01/05)
305    //                      String errMsg = StringUtil.stringStackTrace( ex ) ;
306    //                      LogWriter.log( errMsg );
307    //
308    //                      // 3.7.1.1 (2005/05/31) GE50Access 繧剃ｽｿ逕ｨ縺励※縲．B逋ｻ骭ｲ繧定｡後＞縺ｾ縺吶?
309    //                      if( ge50 != null ) {
310    //                              ge50.insertErrorGE56( errMsg );
311    //                              ge50.updateGE50( GE50Access.FG_ERR1 );
312    //                      }
313    //
314    //                      // 3.7.0.4 (2005/03/18) vals 縺?null 縺ｪ繧峨?DB謗･邯壹お繝ｩ繝ｼ縺梧ｿ?字
315    //                      if( vals == null ) { throw new HybsSystemException( ex ); }
316    //
317    //                      if( ! EXCEL_NAME_USE_YKNO ) {
318    //                              // 3.7.0.0 (2005/01/18) 繧ｨ繝ｩ繝ｼ逋ｺ逕滓凾縺ｮ縲∽ｽｿ逕ｨ荳ｭ縺ｮ蟶ｳ逾ｨID縺ｮ蜑企勁
319    //                              synchronized( USE_LISTID ) {
320    //                                      USE_LISTID.remove( vals[row][3] );              // listId
321    //                              }
322    //                      }
323    //
324    //                      rc = null;
325    //              }
326                    // 5.3.0.0 (2010/12/01) 繧ｨ繝ｩ繝ｼ繝上Φ繝峨Μ繝ｳ繧ｰ繧剃ｿｮ豁｣
327                    catch( Throwable ex ) {         // 3.6.1.0 (2005/01/05)
328                            rc = null;
329    
330                            String errMsg = StringUtil.stringStackTrace( ex ) ;
331                            System.out.println( errMsg );
332                            LogWriter.log( errMsg );
333    
334                            if( ! EXCEL_NAME_USE_YKNO ) {
335                                    // 3.7.0.0 (2005/01/18) 繧ｨ繝ｩ繝ｼ逋ｺ逕滓凾縺ｮ縲∽ｽｿ逕ｨ荳ｭ縺ｮ蟶ｳ逾ｨID縺ｮ蜑企勁
336                                    synchronized( USE_LISTID ) {
337                                            USE_LISTID.remove( vals[row][3] );              // listId
338                                    }
339                            }
340    
341                            // 3.7.1.1 (2005/05/31) GE50Access 繧剃ｽｿ逕ｨ縺励※縲．B逋ｻ骭ｲ繧定｡後＞縺ｾ縺吶?
342                            if( ge50 != null ) {
343                                    ge50.insertErrorGE56( errMsg );
344                                    ge50.updateGE50( GE50Access.FG_ERR1 );
345                            }
346    
347                            // 3.7.0.4 (2005/03/18) vals 縺?null 縺ｪ繧峨?DB謗･邯壹お繝ｩ繝ｼ縺梧ｿ?字
348                            if( vals == null ) {
349                                    errMsg += "(vals == null)" ;
350                                    System.out.println( errMsg );
351                                    LogWriter.log( errMsg );
352                                    throw new HybsSystemException( ex );
353                            }
354                    }
355            }
356    
357            /**
358             * 縺薙?繧ｿ繧､繝槭?繧ｿ繧ｹ繧ｯ縺ｮcancel() 繝｡繧ｽ繝?ラ繧偵が繝ｼ繝舌?繝ｩ繧､繝峨＠縺ｾ縺吶?
359             * HybsTimerTaskManager#cancelTask( int ) 繧貞ｮ溯｡後＠縺ｾ縺吶?
360             *
361             * @og.rev 3.8.5.3 (2006/06/30) 譁ｰ隕剰ｿｽ蜉?
362             *
363             * @return      繧ｹ繧ｱ繧ｸ繝･繝ｼ繝ｫ縺輔ｌ縺ｦ縺?ｋ 1 蝗樔ｻ･荳雁ｮ溯｡後＆繧後↑縺??蜷医↓ true
364             * @see java.util.TimerTask#cancel()
365             */
366            @Override
367            public boolean cancel() {
368                    running = false;
369                    return super.cancel();
370            }
371    }