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.query;
017    
018    import org.opengion.hayabusa.common.HybsSystem;
019    import org.opengion.hayabusa.db.DBConstValue;
020    
021    /**
022     * 繝??繧ｿ繝吶?繧ｹ逋ｻ骭ｲ譎ゅ↓縲∝崋螳壼?繧ｫ繝ｩ繝??險ｭ螳壹ｒ陦後≧諠??繧堤ｮ｡逅?☆繧九け繝ｩ繧ｹ縺ｧ縺吶?
023     * 縺薙?繧ｯ繝ｩ繧ｹ縺ｯ縲｀ICS邉ｻ縺ｮ邂｡逅?け繝ｩ繧ｹ縺ｧ縺吶?
024     * 蜈ｷ菴鍋噪縺ｫ縺ｯ縲?
025     *     蜑企勁?鯉ｾ暦ｽｸ??    DeleteFlg   0:騾壼ｸｸ 1:蜑企勁
026     *     逋ｻ骭ｲ譌･譎?    EntryDate
027     *     譖ｴ譁ｰ譌･譎?    RenewDate
028     * 縺ｪ縺ｩ縺ｮ諠??繧偵?INSERT縲ゞPDATE 縺ｮ迥ｶ豕√↓蠢懊§縺ｦ謠蝉ｾ帙＠縺ｾ縺吶?
029     * INSERT 縺ｫ縺ｯ縲∫匳骭ｲ譌･譎ゅ?譖ｴ譁ｰ譌･譎ゅ↓繧ょ?繧偵そ繝?ヨ縺励∪縺吶?
030     * 縺薙ｌ縺ｯ縲ゞPDATE 縺輔ｌ縺滓律莉倥ｄ譎ょ綾縺ｧ縲∽ｸ?ｦｧ讀懃ｴ｢縺ｧ縺阪ｋ繧医≧縺ｫ縺吶ｋ轤ｺ縺ｧ縲?
031     * null 縺ｫ縺励※縺翫￥縺ｨ縲！S NULL 縺ｧ蝠上＞蜷医ｏ縺帙ｋ蠢?ｦ√′縺ゅｊ縺ｾ縺吶?
032     * INSERT 繝??繧ｿ縺?￠蜿門?縺吝?蜷医?縲仝HERE EntryDate = RenewDate 縺ｨ縺励∪縺吶?
033     *
034     * 繧ｳ繝ｳ繧ｹ繝医Λ繧ｯ繧ｿ繝ｼ縺ｧ縺ｯ縲√ユ繝ｼ繝悶Ν蜷阪?繝ｦ繝ｼ繧ｶ繝ｼID,逕ｻ髱｢ID 繧貞女縺大叙繧翫∪縺吶?
035     * 逋ｻ骭ｲ譎ょ綾縺ｯ縲√％縺ｮ繧ｪ繝悶ず繧ｧ繧ｯ繝医′逕滓?縺輔ｌ縺滓凾髢薙ｒ騾壼ｸｸ縺ｯ菴ｿ逕ｨ縺励∪縺吶?
036     * 繝??繝悶Ν蜷阪ｒ貂｡縺吶?縺ｯ縲√Ρ繝ｼ繧ｯ縺ｪ縺ｩ縲√ユ繝ｼ繝悶Ν蜊倅ｽ阪↓蜃ｦ逅?☆繧九き繝ｩ繝?′
037     * 逡ｰ縺ｪ繧九?縺ｧ縲√◎繧後∈縺ｮ蟇ｾ蠢懊〒縺吶?
038     * 蜃ｦ逅?′邁｡邏?喧縺ｧ縺阪ｋ繧医≧縺ｫ縲√Ν繝ｼ繝ｫ繧定ｦ丞ｮ壹☆縺ｹ縺阪〒縺吶?
039     *
040     * @og.rev 5.6.2.1 (2013/03/08) 譁ｰ隕剰ｿｽ蜉?
041     * @og.group 繝??繧ｿ逋ｻ骭ｲ
042     *
043     * @version  4.0
044     * @author   Kazuhiko Hasegawa
045     * @since    JDK5.0,
046     */
047    public class DBConstValue_MICS implements DBConstValue {
048            private static final String[] MSTR_INSKEYS =
049                    new String[] { "DELETEFLG","ENTRYDATE","RENEWDATE" };
050    
051            private static final String[] MSTR_UPDKEYS =
052                    new String[] { "RENEWDATE" };
053    
054            private static final String[] MSTR_LOGDELKEYS = // 4.3.7.0 (2009/06/01)
055                    new String[] { "DELETEFLG","RENEWDATE" };
056    
057            private static final String[] ZERO = new String[0] ;
058    
059            private String[] insKeys = ZERO;
060            private String[] insVals = ZERO;
061    
062            private String[] updKeys = ZERO;
063            private String[] updVals = ZERO;
064    
065            private String[] logDelKeys = ZERO; // 4.3.7.0 (2009/06/01)
066            private String[] logDelVals = ZERO; // 4.3.7.0 (2009/06/01)
067    
068            /**
069             * 蛻晄悄蛹匁ュ蝣ｱ繧定ｨｭ螳壹＠縺ｾ縺吶?
070             *
071             * @param       table   繝??繝悶Ν蜷?
072             * @param       user    繝ｦ繝ｼ繧ｶ繝ｼID
073             * @param       gamen   逕ｻ髱｢ID
074             */
075            public void init( final String table, final String user, final String gamen ) {
076                    init( table, user, gamen, "" );
077            }
078    
079            /**
080             * 蛻晄悄蛹匁ュ蝣ｱ繧定ｨｭ螳壹＠縺ｾ縺吶?
081             *
082             * @param       table   繝??繝悶Ν蜷?
083             * @param       user    繝ｦ繝ｼ繧ｶ繝ｼID
084             * @param       gamen   逕ｻ髱｢ID
085             * @param       pgamen  隕ｪ逕ｻ髱｢ID
086             */
087            public void init( final String table, final String user, final String gamen, final String pgamen ) {
088                    if( isUseClm( table ) ) {
089                                                                            // TIMESTAMP蝙九↑縺ｮ縺ｧ '2009-12-22 16:06:32' 蠖｢蠑上↓縺吶ｋ縲?
090                            String timestamp = "'" + HybsSystem.getDate( "yyyy-MM-dd HH:mm:ss" ) + "'" ;
091    
092                            insKeys = MSTR_INSKEYS;
093                            insVals = new String[] {
094                                                             "'0'"                  // DeleteFlg
095                                                            ,timestamp              // EntryDate
096                                                            ,timestamp              // RenewDate
097                            };
098    
099                            updKeys = MSTR_UPDKEYS;
100                            updVals = new String[] {
101                                                             timestamp              // RenewDate
102                            };
103    
104                            // 4.3.7.0 (2009/06/01)
105                            logDelKeys = MSTR_LOGDELKEYS;
106                            logDelVals = new String[] {
107                                                             "'1'"                  // DeleteFlg
108                                                            ,timestamp              // RenewDate
109                            };
110                    }
111            }
112    
113            /**
114             * 繧､繝ｳ繧ｵ繝ｼ繝医☆繧句?蜷医?繧ｭ繝ｼ驟榊?繧定ｿ斐＠縺ｾ縺吶?
115             *
116             * 謖?ｮ壹?蛟､縺後↑縺代ｌ縺ｰ縲?聞縺輔ぞ繝ｭ驟榊?繧定ｿ斐＠縺ｾ縺吶?
117             *
118             * @return      繧､繝ｳ繧ｵ繝ｼ繝医☆繧句?蜷医?蛟､驟榊?(髱柤ull)
119             */
120            public String[] getInsertKeys() {
121                    return insKeys.clone();
122            }
123    
124            /**
125             * 繧､繝ｳ繧ｵ繝ｼ繝医☆繧句?蜷医?蛟､驟榊?繧定ｿ斐＠縺ｾ縺吶?
126             *
127             * 謖?ｮ壹?蛟､縺後↑縺代ｌ縺ｰ縲?聞縺輔ぞ繝ｭ驟榊?繧定ｿ斐＠縺ｾ縺吶?
128             *
129             * @return      繧､繝ｳ繧ｵ繝ｼ繝医☆繧句?蜷医?蛟､驟榊?(髱柤ull)
130             */
131            public String[] getInsertVals() {
132                    return insVals.clone();
133            }
134    
135            /**
136             *繧｢繝??繝??繝医☆繧句?蜷医?繧ｭ繝ｼ驟榊?繧定ｿ斐＠縺ｾ縺吶?
137             *
138             * 謖?ｮ壹?蛟､縺後↑縺代ｌ縺ｰ縲?聞縺輔ぞ繝ｭ驟榊?繧定ｿ斐＠縺ｾ縺吶?
139             *
140             * @return      繧｢繝??繝??繝医☆繧句?蜷医?繧ｭ繝ｼ驟榊?(髱柤ull)
141             */
142            public String[] getUpdateKeys() {
143                    return updKeys.clone();
144            }
145    
146            /**
147             * 繧｢繝??繝??繝医☆繧句?蜷医?蛟､驟榊?繧定ｿ斐＠縺ｾ縺吶?
148             *
149             * 謖?ｮ壹?蛟､縺後↑縺代ｌ縺ｰ縲?聞縺輔ぞ繝ｭ驟榊?繧定ｿ斐＠縺ｾ縺吶?
150             *
151             * @return      繧｢繝??繝??繝医☆繧句?蜷医?繧ｭ繝ｼ驟榊?(髱柤ull)
152             */
153            public String[] getUpdateVals() {
154                    return updVals.clone();
155            }
156    
157            /**
158             * 繝?Μ繝ｼ繝?隲也炊蜑企勁) 縺吶ｋ蝣ｴ蜷医?繧ｭ繝ｼ驟榊?繧定ｿ斐＠縺ｾ縺吶?
159             *
160             * 謖?ｮ壹?蛟､縺後↑縺代ｌ縺ｰ縲?聞縺輔ぞ繝ｭ驟榊?繧定ｿ斐＠縺ｾ縺吶?
161             *
162             * @return      繝?Μ繝ｼ繝医☆繧句?蜷医?繧ｭ繝ｼ驟榊?(髱柤ull)
163             */
164            public String[] getLogicalDeleteKeys() {
165                    return logDelKeys.clone();
166            }
167    
168            /**
169             * 繝?Μ繝ｼ繝?隲也炊蜑企勁) 縺吶ｋ蝣ｴ蜷医?蛟､驟榊?繧定ｿ斐＠縺ｾ縺吶?
170             *
171             * 謖?ｮ壹?蛟､縺後↑縺代ｌ縺ｰ縲?聞縺輔ぞ繝ｭ驟榊?繧定ｿ斐＠縺ｾ縺吶?
172             *
173             * @return      繝?Μ繝ｼ繝医☆繧句?蜷医?繧ｭ繝ｼ驟榊?(髱柤ull)
174             */
175            public String[] getLogicalDeleteVals() {
176                    return logDelVals.clone();
177            }
178    
179            /**
180             * 繧ｫ繝ｩ繝?ｒ霑斐☆縺九←縺?°繧呈ｱｺ繧√ｋ繝ｭ繧ｸ繝?け
181             *
182             * 繝??繝悶Ν蜷阪ｈ繧翫?繝ｭ繧ｸ繝?け逧?↓蟆弱″蜃ｺ縺励∪縺吶?
183             *
184             * @param       table   繝??繝悶Ν蜷?
185             *
186             * @return      繧ｫ繝ｩ繝?ｒ霑斐☆縺九←縺?°(true:繧ｫ繝ｩ繝?ｒ逕滓?/false:繧ｫ繝ｩ繝??逕滓?縺励↑縺?
187             */
188            private boolean isUseClm( final String table ) {
189                    boolean flag = ( table != null ) ;
190    
191                    return flag ;
192            }
193    }