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 = "5.7.3.2 (2014/02/28)" ;
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             * @og.rev 5.7.3.2 (2014/02/28) GE53縺ｮ讀懃ｴ｢譚｡莉ｶ菫ｮ豁｣
107             */
108            @Override
109            public void initDaemon() {
110    
111                    // 3.7.0.0 (2005/01/18) GE50, GE54 縺ｮ USRUPD 縺ｫ縲√ョ繝ｼ繝｢繝ｳ蜷阪ｒ繧ｻ繝?ヨ縺励∪縺吶?
112                    // 3.7.1.1 (2005/05/31) GE50Access 繧剃ｽｿ逕ｨ縺励※縲．B逋ｻ骭ｲ繧定｡後＞縺ｾ縺吶?
113    
114                    // 3.8.5.0 (2006/03/06) 繝??繝｢繝ｳ蜷阪ｒ險ｭ螳壹＠縺ｾ縺吶?
115                    DMN_NAME = getName();
116    
117                    StringBuilder buf = new StringBuilder();
118                    buf.append( GE50_SELECT );
119    
120                    // SYSTEM_ID 縺ｯ縲∵欠螳壹′縺ｪ縺代ｌ縺ｰ縲∝?莉ｶ讀懃ｴ｢蟇ｾ雎｡縺ｫ縺ｪ繧翫∪縺吶?
121                    String systemId = getValue( "SYSTEM_ID" );
122                    if( ! StringUtil.isNull( systemId ) ) {
123    //              if( systemId != null && systemId.trim().length() > 0 ) {
124                            buf.append( " AND A.SYSTEM_ID='" ).append( systemId ).append( "'" );
125                    }
126    
127                    // 3.8.5.0 (2006/03/06) DMN_GRP 縺ｯ縲∝ｿ??謖?ｮ?
128                    // 5.1.9.0 (2010/08/01) Avoid if (x != y) ..; else ..;
129                    String dmnGroup = getValue( "DMN_GRP" );
130                    if( StringUtil.isNull( dmnGroup ) ) {
131                            String errMsg = "繝??繝｢繝ｳ繧ｰ繝ｫ繝ｼ繝励?蠢??謖?ｮ壹〒縺吶?" ;
132                            throw new HybsSystemException( errMsg );
133                    }
134                    else {
135                            buf.append( " AND B.DMN_GRP='" ).append( dmnGroup ).append( "'" );
136                    }
137    
138                    // 3.8.5.0 (2006/03/06) GE50 縺ｮ讀懃ｴ｢譚｡莉ｶ縺ｫ縲｀ODBASE 縺ｨ MODNO 繧剃ｽｿ逕ｨ縺吶ｋ縲?
139                    // 繝??繝｢繝ｳ襍ｷ蜍墓凾縺ｫ 譛?､ｧ謨ｰ(MODBASE)縺ｨ菴吶ｊ逡ｪ蜿ｷ(MODNO)繧呈ｸ｡縺励∪縺吶?
140                    // 譛?､ｧ謨ｰ(MODBASE)繧貞?縺ｫ縲∵､懃ｴ｢譎ゅ↓縲〆KNO縺ｮ菴吶ｊ繧呈ｱゅａ縲√％繧後′縲?
141                    // 蠑墓焚縺ｮ菴吶ｊ逡ｪ蜿ｷ(MODNO)縺ｨ荳??縺吶ｋ蝣ｴ蜷医?縺ｿ縲∝?逅?ｒ縺励∪縺吶?
142                    String modBase  = StringUtil.nval( getValue( "MODBASE" ),null );
143                    String modNo    = StringUtil.nval( getValue( "MODNO" ),null );
144                    if( modBase != null && modNo != null ) {
145                            buf.append( " AND MOD(A.YKNO," ).append( modBase ).append( ")=" ).append( modNo );
146                    }
147    
148                    // 3.8.5.0 (2006/03/06) PRTID 縺梧欠螳壹＆繧後※縺?ｌ縺ｰ縲√◎縺ｮ蛟､繧剃ｽｿ逕ｨ縺吶ｋ縲ゅ↑縺代ｌ縺ｰ NULL
149                    PRTID = StringUtil.nval( getValue( "PRTID" ), null );
150    
151                    // 3.8.5.0 (2006/03/06) PRT_GRP 縺梧欠螳壹＆繧後※縺?ｌ縺ｰ縲∵険蛻?擅莉ｶ讀懃ｴ｢譎ゅ↓菴ｿ逕ｨ縺吶ｋ縲?
152                    String prtGgrp = getValue( "PRT_GRP" );
153                    if( ! StringUtil.isNull( prtGgrp ) ) {
154    //              if( prtGgrp != null && prtGgrp.trim().length() > 0 ) {
155    //                      buf.append( " AND B.PRT_GRP='" ).append( prtGgrp ).append( "'" );
156                            buf.append( " AND B.PRTID='" ).append( prtGgrp ).append( "'" ); // 5.7.3.2 (2014/02/28) GE53縺ｧ縺ｯPRTID縺ｫPRI_GRP縺梧欠螳壹＆繧後※縺?ｋ
157                    }
158    
159    //              buf.append( " ORDER BY A.SYSTEM_ID,A.LISTID,A.GROUPID,A.YKNO
160                    buf.append( " ORDER BY " ); // 4.0.1.0 (2007/12/19)
161                    buf.append( HybsSystem.sys( "REPORT_DAEMON_ORDER_BY" ) );
162    
163                    GE_SELECT = buf.toString() ;
164    
165                    // 3.8.5.0 (2006/03/06) 繝?ヰ繝?げ逕ｨ縺ｮ繝輔Λ繧ｰ繧定ｿｽ蜉?＠縺ｾ縺吶?
166                    debug = StringUtil.nval( getValue( "DEBUG" ),debug ) ;
167    
168                    if( debug ) {
169                            System.out.println( "DMN_NAME=[" + DMN_NAME + "]" );
170                            System.out.println( "MODNO=[" + modNo + "]" );
171                            System.out.println( "QUERY=[" + GE_SELECT + "]" );
172                            System.out.println( "EXCEL_NAME_USE_YKNO=[" + EXCEL_NAME_USE_YKNO + "]" );
173                    }
174    
175                    // 3.8.7.0 (2006/12/15) 繧｢繧ｯ繧ｻ繧ｹ繝ｭ繧ｰ蜿門ｾ励?轤ｺ,ApplicationInfo繧ｪ繝悶ず繧ｧ繧ｯ繝医ｒ險ｭ螳?
176                    if( USE_DB_APPLICATION_INFO ) {
177                            appInfo = new ApplicationInfo();
178                            // 繝ｦ繝ｼ繧ｶ繝ｼID,IP繧｢繝峨Ξ繧ｹ,繝帙せ繝亥錐
179                            appInfo.setClientInfo( systemId,HybsSystem.HOST_ADRS,HybsSystem.HOST_NAME );
180                            // 逕ｻ髱｢ID,謫堺ｽ?繝励Ο繧ｰ繝ｩ繝?D
181                            appInfo.setModuleInfo( "ReportDaemon",PRTID,DMN_NAME );
182                    }
183                    else {
184                            appInfo = null;
185                    }
186            }
187    
188            /**
189             * 繧ｿ繧､繝槭?繧ｿ繧ｹ繧ｯ縺ｮ繝??繝｢繝ｳ蜃ｦ逅??髢句ｧ九?繧､繝ｳ繝医〒縺吶?
190             *
191             * @og.rev 3.5.2.0 (2003/10/20) vals 螟画焚繧偵?繝ｭ繝ｼ繧ｫ繝ｫ縺ｫ遘ｻ蜍?
192             * @og.rev 3.5.4.8 (2004/02/23) 繧ｿ繧､繝?せ繧ｿ繝ｳ繝励ｒ縲?ｼ托ｼ仙屓縺ｫ?大屓縺ｨ縺吶ｋ縲?
193             * @og.rev 3.6.0.0 (2004/09/17) 繧ｿ繧､繝?せ繧ｿ繝ｳ繝励ｒ縲?ｼ抵ｼ泌屓縺ｫ?大屓縺ｨ縺吶ｋ縲?
194             * @og.rev 3.6.1.0 (2005/01/05) tyr ??catch 繧?Exception 縺九ｉ Throwable 縺ｫ螟画峩縲?
195             * @og.rev 3.7.0.0 (2005/01/18) 隍?焚蜷梧凾繝??繝｢繝ｳ縺ｧ繧ゅ?蜷御ｸ?ｸｳ逾ｨID縺ｯ蜃ｦ逅?〒縺阪↑縺?ぜ縲√せ繧ｭ繝??縺励∪縺吶?
196             * @og.rev 3.7.0.4 (2005/03/18) 繧ｨ繝ｩ繝ｼ逋ｺ逕滓凾縺ｫ vals 縺?null 縺ｪ繧峨?HybsSystemException 繧?throw 縺吶ｋ縲?
197             * @og.rev 3.7.1.1 (2005/05/31) GE50Access 繧剃ｽｿ逕ｨ縺励※縲．B逋ｻ骭ｲ繧定｡後＞縺ｾ縺吶?
198             * @og.rev 3.8.0.0 (2005/06/07) EXCEL 蜿冶ｾｼ譎ゅ?螳梧?繝輔Λ繧ｰ縺ｯ縲：G_DBIN 縺ｨ縺励∪縺吶?
199             * @og.rev 3.8.0.0 (2005/06/07) rc.execute() 螳溯｡檎ｵ先棡繧?boolean 縺ｧ縺ｯ縺ｪ縺上?譁?ｭ怜?(FGKAN_XX)縺ｧ霑斐＠縺ｾ縺吶?
200             * @og.rev 3.8.5.0 (2006/03/06) EXCEL繝輔ぃ繧､繝ｫ蜷阪↓隕∵ｱら分蜿ｷ繧剃ｽｿ縺??蜷医?縲∝ｸｳ逾ｨID縺ｧ縺ｮ謗剃ｻ門宛蠕｡縺ｯ荳崎ｦ√?
201             * @og.rev 3.8.5.2 (2006/05/31) DEBUG 諠??縺ｮ蠑ｷ蛹?
202             * @og.rev 3.8.6.0 (2006/06/30) 繧ｿ繧､繝槭?繧ｿ繧ｹ繧ｯ縺後く繝｣繝ｳ繧ｻ繝ｫ縺輔ｌ縺溷?蜷医?蜃ｦ逅?ｒ霑ｽ蜉?running 繝輔Λ繧ｰ)
203             * @og.rev 3.8.7.0 (2006/12/15) 繧｢繧ｯ繧ｻ繧ｹ繝ｭ繧ｰ蜿門ｾ励?轤ｺ,ApplicationInfo繧ｪ繝悶ず繧ｧ繧ｯ繝医ｒ險ｭ螳?
204             * @og.rev 5.3.0.0 (2010/12/01) 繧ｨ繝ｩ繝ｼ繝上Φ繝峨Μ繝ｳ繧ｰ繧剃ｿｮ豁｣
205             * @og.rev 5.5.5.1 (2012/08/07) 繝ｪ繧ｽ繝ｼ繧ｹ邉ｻDBID 莉倥￠蠢倥ｌ蟇ｾ遲?
206             * @og.rev 5.7.0.4 (2013/11/29) listId繧竪E50Access縺ｫ貂｡縺吶ｈ縺?↓縺吶ｋ
207             */
208            @Override
209            protected void startDaemon() {
210                    if( loopCnt % LOOP_COUNTER == 0 ) {
211                            loopCnt = 1;
212                            System.out.println();
213                            System.out.print( toString() + " " + new Date()  + " " );
214                    }
215                    else {
216                            System.out.print( "." );
217                            loopCnt++ ;
218                    }
219    
220                    // 3.7.1.1 (2005/05/31) GE50Access 繧剃ｽｿ逕ｨ縺励※縲．B逋ｻ骭ｲ繧定｡後＞縺ｾ縺吶?
221                    GE50Access ge50 = null ;
222    
223                    int row = 0;
224                    String[][] vals  = null;
225                    try {
226    //                      vals = DBUtil.dbExecute( GE_SELECT,null,appInfo );                      // 3.8.7.0 (2006/12/15)
227                            vals = DBUtil.dbExecute( GE_SELECT,null,appInfo, DBID );        // 5.5.5.1 (2012/08/07)
228                            if( vals != null && vals.length > 0 ) {
229    
230                                    // 3.7.1.1 (2005/05/31) GE50Access 繧剃ｽｿ逕ｨ縺励※縲．B逋ｻ骭ｲ繧定｡後＞縺ｾ縺吶?
231                                    // 豈主屓 繧ｪ繝悶ず繧ｧ繧ｯ繝医ｒ讒狗ｯ峨＠縺ｾ縺吶?逋ｻ骭ｲ譌･莉倥′蛻晄悄蛹悶＆繧後∪縺吶?
232                                    ge50 = new GE50Access( null,null,DMN_NAME ) ;           // 3.8.5.0 (2006/03/06)
233    
234                                    if( rc == null ) { rc = new ReportProcessing(); }
235                                    // 3.8.6.0 (2006/06/30) 繧ｿ繧､繝槭?繧ｿ繧ｹ繧ｯ縺後く繝｣繝ｳ繧ｻ繝ｫ縺輔ｌ縺溷?蜷医?蜃ｦ逅?ｒ霑ｽ蜉?running 繝輔Λ繧ｰ)
236                                    for( row=0; running && row<vals.length; row++ ) {
237                                            // 3.7.0.0 (2005/01/18) 菴ｿ逕ｨ荳ｭ縺ｮ蟶ｳ逾ｨID縺ｮ繝√ぉ繝?け縺ｨ縲∽ｽｿ逕ｨ譎ゅ?逋ｻ骭ｲ
238                                            String systemId = vals[row][0] ;
239                                            String ykno     = vals[row][1] ;
240                                            String listId   = vals[row][3] ;
241                                            // 3.8.5.0 (2006/03/06) EXCEL繝輔ぃ繧､繝ｫ蜷阪↓隕∵ｱら分蜿ｷ繧剃ｽｿ縺??蜷医?縲∝ｸｳ逾ｨID縺ｧ縺ｮ謗剃ｻ門宛蠕｡縺ｯ荳崎ｦ√?
242                                            if( ! EXCEL_NAME_USE_YKNO ) {
243                                                    synchronized( USE_LISTID ) {
244                                                            if( USE_LISTID.get( listId ) != null ) {
245                                                                    continue;       // 菴ｿ逕ｨ荳ｭ縺ｪ繧峨?鬟帙?縺吶?
246                                                            }
247                                                            else {
248                                                                    USE_LISTID.put( listId,"DUMMY" );
249                                                            }
250                                                    }
251                                            }
252    
253                                            // 繝?ヰ繝?げ諠??繧貞?蜉帙＠縺ｾ縺吶?
254                                            if( debug ) {
255                                                    System.out.println();
256                                                    System.out.print( "[" + DMN_NAME + "]:[" + ykno + "] START = " );
257                                                    System.out.println( new Date() );
258                                            }
259    
260                                            // 3.7.1.1 (2005/05/31) GE50Access 繧剃ｽｿ逕ｨ縺励※縲．B逋ｻ骭ｲ繧定｡後＞縺ｾ縺吶?
261                                            ge50.setSystemId( systemId );
262                                            ge50.setYkno( ykno );
263                                            ge50.updateGE50( GE50Access.FG_RUN );
264                                            
265                                            ge50.setListId( listId ); // 5.7.0.4 (2013/11/29)
266    
267                                            // system_id,ykno,groupid,listid,joken,outdir,outfile,usrset
268                                            rc.setSystemId( systemId     );
269                                            rc.setYkno(     ykno         );
270                                            rc.setGroupId(  vals[row][2] );
271                                            rc.setListId(   listId       );
272                                            rc.setJoken(    vals[row][4] );
273    //                                      rc.setPrtid(    PRTID        ); // 3.8.5.0 (2006/03/06) PRTID繧剃ｽｿ逕ｨ縺吶ｋ縲?
274                                            rc.setPrtId(    PRTID        ); // 4.3.4.4 (2009/01/01) 繝｡繧ｽ繝?ラ蜷榊､画峩
275                                            rc.setOutDir(   vals[row][5] );
276                                            rc.setOutFile(  vals[row][6] );
277                                            rc.setDebug(    debug        ); // 3.8.5.0 (2006/03/06) DEBUG繧定ｿｽ蜉??
278    
279                                            // 3.8.0.0 (2005/06/07) 螳溯｡檎ｵ先棡繧?boolean 縺ｧ縺ｯ縺ｪ縺上?譁?ｭ怜?(FGKAN_XX)縺ｧ霑斐＠縺ｾ縺吶?
280                                            String fgkan = rc.execute();
281                                            if( fgkan == null ) {
282                                                    fgkan = GE50Access.FG_ERR2 ;
283                                                    String errMsg = rc.getErrMsg();
284                                                    // 3.7.1.1 (2005/05/31) GE50Access 繧剃ｽｿ逕ｨ縺励※縲．B逋ｻ骭ｲ繧定｡後＞縺ｾ縺吶?
285                                                    ge50.insertErrorGE56( errMsg );
286                                            }
287    
288                                            // 3.7.1.1 (2005/05/31) GE50Access 繧剃ｽｿ逕ｨ縺励※縲．B逋ｻ骭ｲ繧定｡後＞縺ｾ縺吶?
289                                            ge50.updateGE50( fgkan );
290    
291                                            rc.clear();
292                                            // 3.8.5.0 (2006/03/06) EXCEL繝輔ぃ繧､繝ｫ蜷阪↓隕∵ｱら分蜿ｷ繧剃ｽｿ縺??蜷医?縲∝ｸｳ逾ｨID縺ｧ縺ｮ謗剃ｻ門宛蠕｡縺ｯ荳崎ｦ√?
293                                            if( ! EXCEL_NAME_USE_YKNO ) {
294                                                    // 3.7.0.0 (2005/01/18) 菴ｿ逕ｨ荳ｭ縺ｮ蟶ｳ逾ｨID縺ｮ蜑企勁
295                                                    synchronized( USE_LISTID ) {
296                                                            USE_LISTID.remove( listId );
297                                                    }
298                                            }
299    
300                                            // 繝?ヰ繝?げ諠??繧貞?蜉帙＠縺ｾ縺吶?
301                                            if( debug ) {
302                                                    System.out.println();
303                                                    System.out.print( "[" + DMN_NAME + "]:[" + ykno + "] END = " );
304                                                    System.out.println( new Date() );
305                                            }
306                                    }
307                            }
308                    }
309    //              catch( Throwable ex ) {         // 3.6.1.0 (2005/01/05)
310    //                      String errMsg = StringUtil.stringStackTrace( ex ) ;
311    //                      LogWriter.log( errMsg );
312    //
313    //                      // 3.7.1.1 (2005/05/31) GE50Access 繧剃ｽｿ逕ｨ縺励※縲．B逋ｻ骭ｲ繧定｡後＞縺ｾ縺吶?
314    //                      if( ge50 != null ) {
315    //                              ge50.insertErrorGE56( errMsg );
316    //                              ge50.updateGE50( GE50Access.FG_ERR1 );
317    //                      }
318    //
319    //                      // 3.7.0.4 (2005/03/18) vals 縺?null 縺ｪ繧峨?DB謗･邯壹お繝ｩ繝ｼ縺梧ｿ?字
320    //                      if( vals == null ) { throw new HybsSystemException( ex ); }
321    //
322    //                      if( ! EXCEL_NAME_USE_YKNO ) {
323    //                              // 3.7.0.0 (2005/01/18) 繧ｨ繝ｩ繝ｼ逋ｺ逕滓凾縺ｮ縲∽ｽｿ逕ｨ荳ｭ縺ｮ蟶ｳ逾ｨID縺ｮ蜑企勁
324    //                              synchronized( USE_LISTID ) {
325    //                                      USE_LISTID.remove( vals[row][3] );              // listId
326    //                              }
327    //                      }
328    //
329    //                      rc = null;
330    //              }
331                    // 5.3.0.0 (2010/12/01) 繧ｨ繝ｩ繝ｼ繝上Φ繝峨Μ繝ｳ繧ｰ繧剃ｿｮ豁｣
332                    catch( Throwable ex ) {         // 3.6.1.0 (2005/01/05)
333                            rc = null;
334    
335                            String errMsg = StringUtil.stringStackTrace( ex ) ;
336                            System.out.println( errMsg );
337                            LogWriter.log( errMsg );
338    
339                            if( ! EXCEL_NAME_USE_YKNO ) {
340                                    // 3.7.0.0 (2005/01/18) 繧ｨ繝ｩ繝ｼ逋ｺ逕滓凾縺ｮ縲∽ｽｿ逕ｨ荳ｭ縺ｮ蟶ｳ逾ｨID縺ｮ蜑企勁
341                                    synchronized( USE_LISTID ) {
342                                            USE_LISTID.remove( vals[row][3] );              // listId
343                                    }
344                            }
345    
346                            // 3.7.1.1 (2005/05/31) GE50Access 繧剃ｽｿ逕ｨ縺励※縲．B逋ｻ骭ｲ繧定｡後＞縺ｾ縺吶?
347                            if( ge50 != null ) {
348                                    ge50.insertErrorGE56( errMsg );
349                                    ge50.updateGE50( GE50Access.FG_ERR1 );
350                            }
351    
352                            // 3.7.0.4 (2005/03/18) vals 縺?null 縺ｪ繧峨?DB謗･邯壹お繝ｩ繝ｼ縺梧ｿ?字
353                            if( vals == null ) {
354                                    errMsg += "(vals == null)" ;
355                                    System.out.println( errMsg );
356                                    LogWriter.log( errMsg );
357                                    throw new HybsSystemException( ex );
358                            }
359                    }
360            }
361    
362            /**
363             * 縺薙?繧ｿ繧､繝槭?繧ｿ繧ｹ繧ｯ縺ｮcancel() 繝｡繧ｽ繝?ラ繧偵が繝ｼ繝舌?繝ｩ繧､繝峨＠縺ｾ縺吶?
364             * HybsTimerTaskManager#cancelTask( int ) 繧貞ｮ溯｡後＠縺ｾ縺吶?
365             *
366             * @og.rev 3.8.5.3 (2006/06/30) 譁ｰ隕剰ｿｽ蜉?
367             *
368             * @return      繧ｹ繧ｱ繧ｸ繝･繝ｼ繝ｫ縺輔ｌ縺ｦ縺?ｋ 1 蝗樔ｻ･荳雁ｮ溯｡後＆繧後↑縺??蜷医↓ true
369             * @see java.util.TimerTask#cancel()
370             */
371            @Override
372            public boolean cancel() {
373                    running = false;
374                    return super.cancel();
375            }
376    }