/*******************************************************************************
* All Rights reserved,Copyright (c) K-Opticom
********************************************************************************
*＜プログラム内容＞
* システム名 ：eo顧客基幹システム
* モジュール名 ：JSYejbECN0021A002TPDA
* ソースファイル名：JSYejbECN0021A002TPDA.java
* 作成者 ：EK909411
* 日付 ：2011年09月29日
*＜機能概要＞
* SQLFacility
* テンプレートDBアクセス部品です。
*＜修正履歴＞
* バージョン 修正日 修正者 修正内容
* ｖ1.00.00
* ｖ4.00.00 2012/12/04 富士通)味岡 ST1-2012-0001018:SYSDATE使用箇所を運用日付使用に置き換え
* ｖ10.00.00 2014/7/11 富士通)横田 ANK-2136-00-00:PCソフト使い放題サービスの導入
* ｖ20.00.00 2015/11/26 富士通)中嶋 ANK-2565-00-00:クレジットカード番号預かりサービス導入（Step3：預かり番号化）
*
********************************************************************************/
package eo.ejb.cbs.sqlf;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.text.ParseException;
import com.fujitsu.futurity.model.base.CAANJDBCUtil;
import com.fujitsu.futurity.model.base.CAANMsg;
import com.fujitsu.futurity.model.base.CAANRuntimeException;
import com.fujitsu.futurity.model.base.CAANSQLFacility;
import com.fujitsu.futurity.model.ejb.common.JSYejbConnection;
import com.fujitsu.futurity.model.ejb.common.JSYejbLog;
import com.fujitsu.futurity.model.ejb.common.StatusCodes;
import com.fujitsu.futurity.model.ejb.common.fw.AgentDispatchContext;
import com.fujitsu.futurity.model.ejb.common.fw.TemplateDBAccessHandler;
import eo.common.constant.JPCModelConstant;
import eo.ejb.cbm.entity.CN0021ETMsg;
import eo.ejb.cbs.cbsmsg.ECN0021A002CBSMsg;
import eo.ejb.cbs.cbsmsg.ECN0021A002CBSMsg1List;
import eo.ejb.cbs.cbsmsg.ECN0111B003CBSMsg;
import eo.ejb.common.JCCModelCommon;
import eo.ejb.common.JCNModelCommon;
/**
*
* テンプレートDBアクセス部品 ECN0021A002_SQLF
* 入力された項目からSQL文を動的に組み立て、
* 検索結果をCBSMsgにセットします。
*/
public class JSYejbECN0021A002TPDA extends CAANSQLFacility implements TemplateDBAccessHandler{
/**
* コンストラクタ
*/
public JSYejbECN0021A002TPDA() {
}
/**
* ECN0021A002_SQLF
* @param inMsg 入力値の格納されたCBSMsg
* @return void
*/
public void invoke(CAANMsg inMsg,AgentDispatchContext inContext){
// コネクション
Connection con1 = null;
// プリペアステートメント
PreparedStatement pstmt = null;
// リザルトセット
ResultSet rsltQuery = null;
/********************
* SQL文の作成
********************/
try{
//コネクション取得
con1 = JSYejbConnection.getConnection(CN0021ETMsg.getTableName());
// SQL文_基本部1
StringBuffer sql_Buff = new StringBuffer();
sql_Buff.append(" SELECT ")
.append(" CN0021_01.CONT_KEI_NO, ")
.append(" CN0021_01.SYSID, ")
.append(" CN0021_01.CONT_SVC_CD, ")
.append(" CN0021_01.CONT_CD, ")
.append(" CN0021_01.CONT_OUT_CD, ")
.append(" CN0021_01.CONT_NM, ")
.append(" CN0021_01.CONT_SBT_CD, ")
.append(" CN0021_01.CONT_KEI_STA_DTM, ")
.append(" CN0021_01.CONT_KEI_END_DTM, ")
.append(" CN0021_01.CONT_PAYWAY_CD, ")
.append(" CN0021_01.CRECARD_ID, ")
.append(" CN0021_01.ISP_KSSAI_SVC_KEI_NO, ")
.append(" CN0021_01.SUPPLIER, ")
.append(" CN0021_01.CONT_KEI_STAT_CD, ")
.append(" CN0021_01.TAXAREA, ")
.append(" CN0021_01.CHOICETICKT_USE_PSB_CNT, ")
.append(" CN0021_01.CONT_KEI_KEIZOKU_CNT, ")
.append(" CN0021_01.CONT_BUY_CNT, ")
.append(" CN0021_01.CONT_TANKA, ")
.append(" CN0021_01.CONT_KEI_SBT_CD, ")
.append(" CN0021_01.KEI_PSBSU, ")
.append(" CN0021_01.HIKEIZOKU_FLG, ")
.append(" CN0021_01.CONT_KEI_YRYO_MRYO_FLG, ")
.append(" CN0021_01.CHRG_FORM_CD, ")
.append(" CN0021_01.OLD_LIMIT, ")
.append(" CN0021_01.USE_PSB_USER_SBT_CD, ")
.append(" CN0021_01.RNKSAKI_CD, ")
.append(" CN0021_01.RNKSAKI_CONT_SKBT_ID, ")
.append(" CN0021_01.CONT_SONZAI_FLG, ")
.append(" CN0021_01.KEI_JI_SYSID, ")
.append(" CN0021_01.KEI_JI_MMB_SBT_CD, ")
.append(" CN0021_01.DSL_JI_MMB_SBT_CD, ")
.append(" CN0021_01.KEI_TRAN_YMD, ")
.append(" CN0031_01.TRENDMICRO_CEREAL_NO, ")
.append(" CN0031_01.REDIRECT_URL, ")
.append(" CN0031_01.VIRUSBUSTER_ID, ")
.append(" CN0031_01.DSL_IF_SEND_FLG, ")
// ANK-2136-00-00 2014/7/11 MOD START
.append(" CN0031_01.HANYO_KMK_NM, ")
// ANK-2136-00-00 2014/7/11 MOD END
.append(" CN0031_01.HANYO_VALUE, ")
.append(" CN0071_CN0081_03.CONT_CHRG_STAT, ")
.append(" CN0071_CN0081_03.CONT_CAMPAIGN_ID, ")
.append(" CN0071_CN0081_03.CONT_CAMPAIGN_NM, ")
.append(" CN0071_CN0081_03.CONT_CMP_TG_MMB_BUNRUI_CD, ")
.append(" CN0071_CN0081_03.CONT_CHOKI_WRIB_MON_CNT, ")
.append(" CN0071_CN0081_03.CONT_CAMPAIGN_FORM_CD, ")
.append(" CN0071_CN0081_03.CONT_CAMPAIGN_WRIB_RT, ")
.append(" CN0071_CN0081_03.CONT_CAMPAIGN_WRIB_AMNT, ")
.append(" CN0071_CN0081_03.PLMIN_DIV, ")
.append(" CN0071_CN0081_03.CRECARD_ID AS CHRG_CRECARD_ID, ")
.append(" CN0071_CN0081_03.ISP_SVC_KEI_NO AS CHRG_ISP_SVC_KEI_NO, ")
.append(" CN0071_CN0081_03.CHRG_TRGT_YM, ")
.append(" CN0071_CN0081_03.CHRG_STAT_CD, ")
.append(" CN0071_CN0081_03.CHRG_JTN_MEMBER_SBT_CD, ")
.append(" CN0071_CN0081_03.CHRG_AMNT, ")
.append(" CN0071_CN0081_03.CONT_TANKA AS CHRG_CONT_TANKA, ")
.append(" CN0071_CN0081_03.TAX_RT, ")
.append(" CN0071_CN0081_03.CONT_BUY_CNT AS CHRG_CONT_BUY_CNT, ")
.append(" CN0071_CN0081_03.CHRG_TRAN_YMD, ")
.append(" CN0091_05.CONTCHRGTESEI_STAT, ")
.append(" CN0091_05.CONTCHRGTESEI_DIV, ")
.append(" CN0091_05.PLMIN_DIV AS TESEI_PLMIN_DIV, ")
.append(" CN0091_05.CHRG_TEISE_YMD, ")
.append(" CN0091_05.CHRG_TEISE_RSN_DIV, ")
.append(" CN0091_05.CHRG_JTN_TAX_RT, ")
.append(" CN0091_05.SALES_GEN_AMNT, ")
.append(" CN0091_05.COMPENSATION, ")
.append(" CN0091_05.CONTCHRGTESEI_KSSAI_SEIYMD, ")
.append(" CN0091_05.CHRG_TEISE_RSN_MEMO, ")
.append(" CN0091_05.TEISE_TRAN_YMD, ")
.append(" CN0101_07.CONTJIGYO_CRECA_STAT, ")
.append(" CN0101_07.CRECARD_JIGYO_CD, ")
.append(" CN0101_07.CRECARD_COMP_CD, ")
.append(" CN0101_07.CRECARD_NO, ")
.append(" CN0101_08.CONTJIGYO_CRECA_STAT AS CHRG_CONTJIGYO_CRECA_STAT, ")
.append(" CN0101_08.CRECARD_JIGYO_CD AS CHRG_CRECARD_JIGYO_CD, ")
.append(" CN0101_08.CRECARD_COMP_CD AS CHRG_CRECARD_COMP_CD, ")
.append(" CN0101_08.CRECARD_NO AS CHRG_CRECARD_NO, ")
.append(" CASE ")
// ST1-2012-0001018 2012/12/04 n.ajioka START
// .append(" WHEN CN0021_01.CONT_KEI_STAT_CD = '0' AND (CN0021_01.CONT_KEI_END_DTM >= TO_CHAR(SYSDATE, 'yyyyMMddhhmmss')) THEN ")
.append(" WHEN CN0021_01.CONT_KEI_STAT_CD = '0' AND (CN0021_01.CONT_KEI_END_DTM >= ?) THEN ")
.append(" '契約中' ")
// .append(" WHEN CN0021_01.CONT_KEI_STAT_CD = '0' AND (CN0021_01.CONT_KEI_END_DTM < TO_CHAR(SYSDATE, 'yyyyMMddhhmmss')) THEN ")
.append(" WHEN CN0021_01.CONT_KEI_STAT_CD = '0' AND (CN0021_01.CONT_KEI_END_DTM < ?) THEN ")
.append(" '契約終了' ")
// ST1-2012-0001018 2012/12/04 n.ajioka END
.append(" ELSE ")
.append(" ZM0171_01.CD_DIV_NM ")
.append(" END AS CONT_KEI_STAT_CD_NM, ")
.append(" ZM0171_02.CD_DIV_NM AS TAXAREA_NM, ")
.append(" ZM0171_03.CD_DIV_NM AS CHRG_TEISE_RSN_DIV_NM, ")
// ｖ20.00.00 MOD START
// .append(" CN0041_01.CONT_SVC_NM ")
.append(" CN0041_01.CONT_SVC_NM, ")
.append(" CN0101_07.CRECARD_YK_KIGEN, ")
.append(" CN0101_07.CRECARD_NO_AZKRI_ID, ")
.append(" CN0101_08.CRECARD_YK_KIGEN AS CHRG_CRECARD_YK_KIGEN, ")
.append(" CN0101_08.CRECARD_NO_AZKRI_ID AS CHRG_CRECARD_NO_AZKRI_ID ")
// ｖ20.00.00 MOD END
.append(" FROM ")
.append(" CN_T_CONT_KEI CN0021_01 LEFT JOIN CN_T_CONT_KEI_HUKA CN0031_01 ON ")
.append(" CN0021_01.CONT_KEI_NO = CN0031_01.CONT_KEI_NO AND CN0031_01.MK_FLG='0' LEFT JOIN ")
.append(" (SELECT ")
.append(" CN0071_CN0081_02.CONT_KEI_NO, ")
.append(" CN0071_CN0081_02.CONT_KEI_NO_SEQ, ")
.append(" CN0071_CN0081_02.CONT_KEI_TEISE_SEQ, ")
.append(" CN0071_CN0081_02.CONT_CHRG_STAT, ")
.append(" CN0071_CN0081_02.SYSID, ")
.append(" CN0071_CN0081_02.CONT_SVC_CD, ")
.append(" CN0071_CN0081_02.CONT_CD, ")
.append(" CN0071_CN0081_02.CONT_OUT_CD, ")
.append(" CN0071_CN0081_02.CONT_CAMPAIGN_ID, ")
.append(" CN0071_CN0081_02.CONT_CAMPAIGN_NM, ")
.append(" CN0071_CN0081_02.CONT_CMP_TG_MMB_BUNRUI_CD, ")
.append(" CN0071_CN0081_02.CONT_CHOKI_WRIB_MON_CNT, ")
.append(" CN0071_CN0081_02.CONT_CAMPAIGN_FORM_CD, ")
.append(" CN0071_CN0081_02.CONT_CAMPAIGN_WRIB_RT, ")
.append(" CN0071_CN0081_02.CONT_CAMPAIGN_WRIB_AMNT, ")
.append(" CN0071_CN0081_02.PLMIN_DIV, ")
.append(" CN0071_CN0081_02.CRECARD_ID, ")
.append(" CN0071_CN0081_02.ISP_SVC_KEI_NO, ")
.append(" CN0071_CN0081_02.CHRG_TRGT_YM, ")
.append(" CN0071_CN0081_02.CHRG_STAT_CD, ")
.append(" CN0071_CN0081_02.CHRG_JTN_MEMBER_SBT_CD, ")
.append(" CN0071_CN0081_02.CHRG_AMNT, ")
.append(" CN0071_CN0081_02.CONT_TANKA, ")
.append(" CN0071_CN0081_02.TAX_RT, ")
.append(" CN0071_CN0081_02.CONT_BUY_CNT, ")
.append(" CN0071_CN0081_02.KSSAI_SEIYMD, ")
.append(" CN0071_CN0081_02.CHRG_TRAN_YMD, ")
.append(" CN0071_CN0081_02.MK_FLG ")
.append(" FROM ")
.append(" (SELECT ")
.append(" CN0071_CN0081_01.CONT_KEI_NO, ")
.append(" CN0071_CN0081_01.CONT_KEI_NO_SEQ, ")
.append(" CN0071_CN0081_01.CONT_KEI_TEISE_SEQ, ")
.append(" CN0071_CN0081_01.CONT_CHRG_STAT, ")
.append(" CN0071_CN0081_01.SYSID, ")
.append(" CN0071_CN0081_01.CONT_SVC_CD, ")
.append(" CN0071_CN0081_01.CONT_CD, ")
.append(" CN0071_CN0081_01.CONT_OUT_CD, ")
.append(" CN0071_CN0081_01.CONT_CAMPAIGN_ID, ")
.append(" CN0071_CN0081_01.CONT_CAMPAIGN_NM, ")
.append(" CN0071_CN0081_01.CONT_CMP_TG_MMB_BUNRUI_CD, ")
.append(" CN0071_CN0081_01.CONT_CHOKI_WRIB_MON_CNT, ")
.append(" CN0071_CN0081_01.CONT_CAMPAIGN_FORM_CD, ")
.append(" CN0071_CN0081_01.CONT_CAMPAIGN_WRIB_RT, ")
.append(" CN0071_CN0081_01.CONT_CAMPAIGN_WRIB_AMNT, ")
.append(" CN0071_CN0081_01.PLMIN_DIV, ")
.append(" CN0071_CN0081_01.CRECARD_ID, ")
.append(" CN0071_CN0081_01.ISP_SVC_KEI_NO, ")
.append(" CN0071_CN0081_01.CHRG_TRGT_YM, ")
.append(" CN0071_CN0081_01.CHRG_STAT_CD, ")
.append(" CN0071_CN0081_01.CHRG_JTN_MEMBER_SBT_CD, ")
.append(" CN0071_CN0081_01.CHRG_AMNT, ")
.append(" CN0071_CN0081_01.CONT_TANKA, ")
.append(" CN0071_CN0081_01.TAX_RT, ")
.append(" CN0071_CN0081_01.CONT_BUY_CNT, ")
.append(" CN0071_CN0081_01.KSSAI_SEIYMD, ")
.append(" CN0071_CN0081_01.CHRG_TRAN_YMD, ")
.append(" CN0071_CN0081_01.MK_FLG ")
.append(" FROM ")
.append(" (SELECT ")
.append(" CN0071_04.CONT_KEI_NO AS CONT_KEI_NO, ")
.append(" CN0071_04.CONT_KEI_NO_SEQ AS CONT_KEI_NO_SEQ, ")
.append(" CN0071_04.CONT_KEI_TEISE_SEQ AS CONT_KEI_TEISE_SEQ, ")
.append(" CN0071_04.CONT_CRECARD_CHRG_STAT AS CONT_CHRG_STAT, ")
.append(" CN0071_04.SYSID AS SYSID, ")
.append(" CN0071_04.CONT_SVC_CD AS CONT_SVC_CD, ")
.append(" CN0071_04.CONT_CD AS CONT_CD, ")
.append(" CN0071_04.CONT_OUT_CD AS CONT_OUT_CD, ")
.append(" CN0071_04.CONT_CAMPAIGN_ID AS CONT_CAMPAIGN_ID, ")
.append(" CN0071_04.CONT_CAMPAIGN_NM AS CONT_CAMPAIGN_NM, ")
.append(" CN0071_04.CONT_CMP_TG_MMB_BUNRUI_CD AS CONT_CMP_TG_MMB_BUNRUI_CD, ")
.append(" CN0071_04.CONT_CHOKI_WRIB_MON_CNT AS CONT_CHOKI_WRIB_MON_CNT, ")
.append(" CN0071_04.CONT_CAMPAIGN_FORM_CD AS CONT_CAMPAIGN_FORM_CD, ")
.append(" CN0071_04.CONT_CAMPAIGN_WRIB_RT AS CONT_CAMPAIGN_WRIB_RT, ")
.append(" CN0071_04.CONT_CAMPAIGN_WRIB_AMNT AS CONT_CAMPAIGN_WRIB_AMNT, ")
.append(" CN0071_04.PLMIN_DIV AS PLMIN_DIV, ")
.append(" CN0071_04.CRECARD_ID AS CRECARD_ID, ")
.append(" NULL AS ISP_SVC_KEI_NO, ")
.append(" CN0071_04.CHRG_TRGT_YM AS CHRG_TRGT_YM, ")
.append(" CN0071_04.CHRG_STAT_CD AS CHRG_STAT_CD, ")
.append(" CN0071_04.CHRG_JTN_MEMBER_SBT_CD AS CHRG_JTN_MEMBER_SBT_CD, ")
.append(" CN0071_04.CHRG_AMNT AS CHRG_AMNT, ")
.append(" CN0071_04.CONT_TANKA AS CONT_TANKA, ")
.append(" CN0071_04.TAX_RT AS TAX_RT, ")
.append(" CN0071_04.CONT_BUY_CNT AS CONT_BUY_CNT, ")
.append(" CN0071_04.CRECARD_KSSAI_SEIYMD AS KSSAI_SEIYMD, ")
.append(" CN0071_04.CHRG_TRAN_YMD AS CHRG_TRAN_YMD, ")
.append(" CN0071_04.MK_FLG AS MK_FLG ")
.append(" FROM ")
.append(" (SELECT ")
.append(" CN0071_02.CONT_KEI_NO, ")
.append(" CN0071_02.CONT_KEI_NO_SEQ, ")
.append(" CN0071_02.CONT_KEI_TEISE_SEQ ")
.append(" FROM ")
.append(" (SELECT ")
.append(" CN0071_01.CONT_KEI_NO, ")
.append(" CN0071_01.CONT_KEI_NO_SEQ, ")
.append(" CN0071_01.CONT_KEI_TEISE_SEQ ")
.append(" FROM ")
.append(" CN_T_CONT_CRECA_CHRG CN0071_01 ")
.append(" WHERE ")
.append(" CN0071_01.CONT_KEI_NO = ? AND ")
.append(" CN0071_01.MK_FLG='0' AND ")
// ST1-2012-0001018 2012/12/04 n.ajioka START
// .append(" CN0071_01.CHRG_TRGT_YM <= TO_CHAR(SYSDATE,'yyyyMM') AND ")
.append(" CN0071_01.CHRG_TRGT_YM <= ? ")
// .append(" CN0071_01.CHRG_TRGT_YM >= TO_CHAR(ADD_MONTHS(SYSDATE,-6),'yyyyMM') ")
// .append(" CN0071_01.CHRG_TRGT_YM >= ? ")
// ST1-2012-0001018 2012/12/04 n.ajioka END
.append(" GROUP BY ")
.append(" CN0071_01.CONT_KEI_NO, ")
.append(" CN0071_01.CONT_KEI_NO_SEQ, ")
.append(" CN0071_01.CONT_KEI_TEISE_SEQ ")
.append(" ORDER BY ")
.append(" CN0071_01.CONT_KEI_NO_SEQ DESC, ")
.append(" CN0071_01.CONT_KEI_TEISE_SEQ DESC ")
.append(" ) CN0071_02 ")
.append(" WHERE ")
.append(" ROWNUM='1' ")
.append(" ) CN0071_03 LEFT JOIN CN_T_CONT_CRECA_CHRG CN0071_04 ON ")
.append(" CN0071_03.CONT_KEI_NO = CN0071_04.CONT_KEI_NO AND ")
.append(" CN0071_03.CONT_KEI_NO_SEQ = CN0071_04.CONT_KEI_NO_SEQ AND ")
.append(" CN0071_03.CONT_KEI_TEISE_SEQ = CN0071_04.CONT_KEI_TEISE_SEQ ")
.append(" UNION ALL ")
.append(" SELECT ")
.append(" CN0081_04.CONT_KEI_NO AS CONT_KEI_NO, ")
.append(" CN0081_04.CONT_KEI_NO_SEQ AS CONT_KEI_NO_SEQ, ")
.append(" CN0081_04.CONT_KEI_TEISE_SEQ AS CONT_KEI_TEISE_SEQ, ")
.append(" CN0081_04.CONT_ISP_CHRG_STAT AS CONT_CHRG_STAT, ")
.append(" CN0081_04.SYSID AS SYSID, ")
.append(" CN0081_04.CONT_SVC_CD AS CONT_SVC_CD, ")
.append(" CN0081_04.CONT_CD AS CONT_CD, ")
.append(" CN0081_04.CONT_OUT_CD AS CONT_OUT_CD, ")
.append(" CN0081_04.CONT_CAMPAIGN_ID AS CONT_CAMPAIGN_ID, ")
.append(" CN0081_04.CONT_CAMPAIGN_NM AS CONT_CAMPAIGN_NM, ")
.append(" CN0081_04.CONT_CMP_TG_MMB_BUNRUI_CD AS CONT_CMP_TG_MMB_BUNRUI_CD, ")
.append(" CN0081_04.CONT_CHOKI_WRIB_MON_CNT AS CONT_CHOKI_WRIB_MON_CNT, ")
.append(" CN0081_04.CONT_CAMPAIGN_FORM_CD AS CONT_CAMPAIGN_FORM_CD, ")
.append(" CN0081_04.CONT_CAMPAIGN_WRIB_RT AS CONT_CAMPAIGN_WRIB_RT, ")
.append(" CN0081_04.CONT_CAMPAIGN_WRIB_AMNT AS CONT_CAMPAIGN_WRIB_AMNT, ")
.append(" CN0081_04.PLMIN_DIV AS PLMIN_DIV, ")
.append(" NULL AS ISP_SVC_KEI_NO, ")
.append(" CN0081_04.ISP_KSSAI_SVC_KEI_NO AS ISP_SVC_KEI_NO, ")
.append(" CN0081_04.CHRG_TRGT_YM AS CHRG_TRGT_YM, ")
.append(" CN0081_04.CHRG_STAT_CD AS CHRG_STAT_CD, ")
.append(" CN0081_04.CHRG_JTN_MEMBER_SBT_CD AS CHRG_JTN_MEMBER_SBT_CD, ")
.append(" CN0081_04.CHRG_AMNT AS CHRG_AMNT, ")
.append(" CN0081_04.CONT_TANKA AS CONT_TANKA, ")
.append(" CN0081_04.TAX_RT AS TAX_RT, ")
.append(" CN0081_04.CONT_BUY_CNT AS CONT_BUY_CNT, ")
.append(" CN0081_04.ISP_KSSAI_SEIYMD AS KSSAI_SEIYMD, ")
.append(" CN0081_04.CHRG_TRAN_YMD AS CHRG_TRAN_YMD, ")
.append(" CN0081_04.MK_FLG AS MK_FLG ")
.append(" FROM ")
.append(" (SELECT ")
.append(" CN0081_02.CONT_KEI_NO, ")
.append(" CN0081_02.CONT_KEI_NO_SEQ, ")
.append(" CN0081_02.CONT_KEI_TEISE_SEQ ")
.append(" FROM ")
.append(" (SELECT ")
.append(" CN0081_01.CONT_KEI_NO, ")
.append(" CN0081_01.CONT_KEI_NO_SEQ, ")
.append(" CN0081_01.CONT_KEI_TEISE_SEQ ")
.append(" FROM ")
.append(" CN_T_CONT_ISP_CHRG CN0081_01 ")
.append(" WHERE ")
.append(" CN0081_01.CONT_KEI_NO = ? AND ")
.append(" CN0081_01.MK_FLG='0' AND ")
// ST1-2012-0001018 2012/12/04 n.ajioka START
// .append(" CN0081_01.CHRG_TRGT_YM <= TO_CHAR(SYSDATE,'yyyyMM') AND ")
.append(" CN0081_01.CHRG_TRGT_YM <= ? ")
// .append(" CN0081_01.CHRG_TRGT_YM >= TO_CHAR(ADD_MONTHS(SYSDATE,-6),'yyyyMM') ")
// .append(" CN0081_01.CHRG_TRGT_YM >= ? ")
// ST1-2012-0001018 2012/12/04 n.ajioka END
.append(" GROUP BY ")
.append(" CN0081_01.CONT_KEI_NO, ")
.append(" CN0081_01.CONT_KEI_NO_SEQ, ")
.append(" CN0081_01.CONT_KEI_TEISE_SEQ ")
.append(" ORDER BY ")
.append(" CN0081_01.CONT_KEI_NO_SEQ DESC, ")
.append(" CN0081_01.CONT_KEI_TEISE_SEQ DESC ")
.append(" ) CN0081_02 ")
.append(" WHERE ")
.append(" ROWNUM='1' ")
.append(" ) CN0081_03 LEFT JOIN CN_T_CONT_ISP_CHRG CN0081_04 ON ")
.append(" CN0081_03.CONT_KEI_NO = CN0081_04.CONT_KEI_NO AND ")
.append(" CN0081_03.CONT_KEI_NO_SEQ = CN0081_04.CONT_KEI_NO_SEQ AND ")
.append(" CN0081_03.CONT_KEI_TEISE_SEQ= CN0081_04.CONT_KEI_TEISE_SEQ ")
.append(" ) CN0071_CN0081_01 ")
.append(" ORDER BY CN0071_CN0081_01.CONT_KEI_NO_SEQ DESC, ")
.append(" CN0071_CN0081_01.CONT_KEI_TEISE_SEQ DESC ")
.append(" )CN0071_CN0081_02 ")
.append(" WHERE ")
.append(" ROWNUM = '1' ")
.append(" ) CN0071_CN0081_03 ON ")
.append(" CN0071_CN0081_03.CONT_KEI_NO = CN0021_01.CONT_KEI_NO AND ")
.append(" CN0071_CN0081_03.CONT_KEI_NO_SEQ = CN0021_01.CONT_KEI_KEIZOKU_CNT LEFT JOIN ")
.append(" (SELECT ")
.append(" CN0091_04.CONT_KEI_NO, ")
.append(" CN0091_04.CONT_KEI_NO_SEQ, ")
.append(" CN0091_04.CONT_CHRG_TEISE_SEQ, ")
.append(" CN0091_04.CONTCHRGTESEI_STAT, ")
.append(" CN0091_04.CONTCHRGTESEI_DIV, ")
.append(" CN0091_04.SYSID, ")
.append(" CN0091_04.CONT_SVC_CD, ")
.append(" CN0091_04.CONT_CD, ")
.append(" CN0091_04.CONT_OUT_CD, ")
.append(" CN0091_04.PLMIN_DIV, ")
.append(" CN0091_04.CHRG_TEISE_YMD, ")
.append(" CN0091_04.CHRG_TEISE_RSN_DIV, ")
.append(" CN0091_04.CHRG_JTN_TAX_RT, ")
.append(" CN0091_04.SALES_GEN_AMNT, ")
.append(" CN0091_04.COMPENSATION, ")
.append(" CN0091_04.CONT_PAYWAY_CD, ")
.append(" CN0091_04.CRECARD_ID, ")
.append(" CN0091_04.CHRG_TRGT_YM, ")
.append(" CN0091_04.ISP_KSSAI_SVC_KEI_NO, ")
.append(" CN0091_04.CONTCHRGTESEI_KSSAI_SEIYMD, ")
.append(" CN0091_04.CHRG_TEISE_RSN_MEMO, ")
.append(" CN0091_04.TEISE_TRAN_YMD, ")
.append(" CN0091_04.MK_FLG ")
.append(" FROM ")
.append(" (SELECT ")
.append(" CN0091_02.CONT_KEI_NO, ")
.append(" CN0091_02.CONT_KEI_NO_SEQ, ")
.append(" CN0091_02.CONT_CHRG_TEISE_SEQ ")
.append(" FROM ")
.append(" (SELECT ")
.append(" CN0091_01.CONT_KEI_NO, ")
.append(" CN0091_01.CONT_KEI_NO_SEQ, ")
.append(" CN0091_01.CONT_CHRG_TEISE_SEQ ")
.append(" FROM ")
.append(" CN_T_CONTCHRGTESEI CN0091_01 ")
.append(" WHERE ")
.append(" CN0091_01.CONT_KEI_NO = ? AND ")
.append(" CN0091_01.MK_FLG='0' AND ")
// ST1-2012-0001018 2012/12/04 n.ajioka START
// .append(" CN0091_01.CHRG_TRGT_YM <= TO_CHAR(SYSDATE,'yyyyMM') AND ")
.append(" CN0091_01.CHRG_TRGT_YM <= ? ")
// .append(" CN0091_01.CHRG_TRGT_YM >= TO_CHAR(ADD_MONTHS(SYSDATE,-6),'yyyyMM') ")
// .append(" CN0091_01.CHRG_TRGT_YM >= ? ")
// ST1-2012-0001018 2012/12/04 n.ajioka END
.append(" GROUP BY ")
.append(" CN0091_01.CONT_KEI_NO, ")
.append(" CN0091_01.CONT_KEI_NO_SEQ, ")
.append(" CN0091_01.CONT_CHRG_TEISE_SEQ ")
.append(" ORDER BY ")
.append(" CN0091_01.CONT_KEI_NO_SEQ DESC, ")
.append(" CN0091_01.CONT_CHRG_TEISE_SEQ DESC ")
.append(" ) CN0091_02 ")
.append(" WHERE ")
.append(" ROWNUM='1' ")
.append(" ) CN0091_03 LEFT JOIN CN_T_CONTCHRGTESEI CN0091_04 ON ")
.append(" CN0091_03.CONT_KEI_NO = CN0091_04.CONT_KEI_NO AND ")
.append(" CN0091_03.CONT_KEI_NO_SEQ = CN0091_04.CONT_KEI_NO_SEQ AND ")
.append(" CN0091_03.CONT_CHRG_TEISE_SEQ = CN0091_04.CONT_CHRG_TEISE_SEQ ")
.append(" ) CN0091_05 ON ")
.append(" CN0021_01.CONT_KEI_NO = CN0091_05.CONT_KEI_NO AND ")
.append(" CN0071_CN0081_03.CHRG_TRGT_YM = CN0091_05.CHRG_TRGT_YM AND ")
.append(" CN0091_05.MK_FLG='0' LEFT JOIN ")
.append(" (SELECT ")
.append(" CN0101_03.CRECARD_ID, ")
.append(" CN0101_03.CHRG_TRGT_YM, ")
.append(" CN0101_03.CONTJIGYO_CRECA_STAT, ")
.append(" CN0101_03.SYSID, ")
.append(" CN0101_03.CRECARD_JIGYO_CD, ")
.append(" CN0101_03.CRECARD_COMP_CD, ")
// ｖ20.00.00 MOD START
// .append(" CN0101_03.CRECARD_NO ")
.append(" CN0101_03.CRECARD_NO, ")
.append(" CN0101_03.CRECARD_YK_KIGEN, ")
.append(" CN0101_03.CRECARD_NO_AZKRI_ID ")
// ｖ20.00.00 MOD END
.append(" FROM ")
.append(" ( ")
.append(" SELECT ")
.append(" CN0101_01.CRECARD_ID, ")
.append(" MAX(CN0101_01.CHRG_TRGT_YM) AS GR_CHRG_TRGT_YM ")
.append(" FROM ")
.append(" CN_T_CONTJIGYO_CRECA CN0101_01 ")
.append(" WHERE ")
.append(" CN0101_01.CRECARD_ID = ")
.append(" (SELECT ")
.append(" CN0021_02.CRECARD_ID ")
.append(" FROM ")
.append(" CN_T_CONT_KEI CN0021_02 ")
.append(" WHERE ")
.append(" CN0021_02.CONT_KEI_NO = ? ")
.append(" ) AND ")
// ST1-2012-0001018 2012/12/04 n.ajioka START
// .append(" CN0101_01.CHRG_TRGT_YM <= TO_CHAR(SYSDATE,'yyyyMM') AND ")
.append(" CN0101_01.CHRG_TRGT_YM <= ? AND ")
// .append(" CN0101_01.CHRG_TRGT_YM >= TO_CHAR(ADD_MONTHS(SYSDATE,-6),'yyyyMM') AND ")
// .append(" CN0101_01.CHRG_TRGT_YM >= ? AND ")
// ST1-2012-0001018 2012/12/04 n.ajioka END
.append(" CN0101_01.MK_FLG = '0' ")
.append(" GROUP BY ")
.append(" CN0101_01.CRECARD_ID ")
.append(" ) CN0101_02 LEFT JOIN CN_T_CONTJIGYO_CRECA CN0101_03 ON ")
.append(" CN0101_02.CRECARD_ID = CN0101_03.CRECARD_ID AND ")
.append(" CN0101_02.GR_CHRG_TRGT_YM = CN0101_03.CHRG_TRGT_YM ")
.append(" ) CN0101_07 ON ")
.append(" CN0021_01.CRECARD_ID = CN0101_07.CRECARD_ID LEFT JOIN ")
.append(" (SELECT ")
.append(" CN0101_06.CRECARD_ID, ")
.append(" CN0101_06.CHRG_TRGT_YM, ")
.append(" CN0101_06.CONTJIGYO_CRECA_STAT, ")
.append(" CN0101_06.SYSID, ")
.append(" CN0101_06.CRECARD_JIGYO_CD, ")
.append(" CN0101_06.CRECARD_COMP_CD, ")
// ｖ20.00.00 MOD START
// .append(" CN0101_06.CRECARD_NO ")
.append(" CN0101_06.CRECARD_NO, ")
.append(" CN0101_06.CRECARD_YK_KIGEN, ")
.append(" CN0101_06.CRECARD_NO_AZKRI_ID ")
// ｖ20.00.00 MOD END
.append(" FROM ")
.append(" (SELECT ")
.append(" CN0101_04.CRECARD_ID, ")
.append(" MAX(CN0101_04.CHRG_TRGT_YM) AS GR_CHRG_TRGT_YM ")
.append(" FROM ")
.append(" CN_T_CONTJIGYO_CRECA CN0101_04 ")
.append(" WHERE ")
.append(" CN0101_04.CRECARD_ID = ")
.append(" (SELECT ")
.append(" CN0071_08.CRECARD_ID ")
.append(" FROM ")
.append(" (SELECT ")
.append(" CN0071_06.CONT_KEI_NO, ")
.append(" CN0071_06.CONT_KEI_NO_SEQ, ")
.append(" CN0071_06.CONT_KEI_TEISE_SEQ ")
.append(" FROM ")
.append(" (SELECT ")
.append(" CN0071_05.CONT_KEI_NO, ")
.append(" CN0071_05.CONT_KEI_NO_SEQ, ")
.append(" CN0071_05.CONT_KEI_TEISE_SEQ ")
.append(" FROM ")
.append(" CN_T_CONT_CRECA_CHRG CN0071_05 ")
.append(" WHERE ")
.append(" CN0071_05.CONT_KEI_NO = ? AND ")
// ST1-2012-0001018 2012/12/04 n.ajioka START
// .append(" CN0071_05.CHRG_TRGT_YM <= TO_CHAR(SYSDATE,'yyyyMM') AND ")
.append(" CN0071_05.CHRG_TRGT_YM <= ? AND ")
// .append(" CN0071_05.CHRG_TRGT_YM >= TO_CHAR(ADD_MONTHS(SYSDATE,-6),'yyyyMM') AND ")
// .append(" CN0071_05.CHRG_TRGT_YM >= ? AND ")
// ST1-2012-0001018 2012/12/04 n.ajioka END
.append(" CN0071_05.MK_FLG ='0' ")
.append(" GROUP BY ")
.append(" CN0071_05.CONT_KEI_NO, ")
.append(" CN0071_05.CONT_KEI_NO_SEQ, ")
.append(" CN0071_05.CONT_KEI_TEISE_SEQ ")
.append(" ORDER BY ")
.append(" CN0071_05.CONT_KEI_NO_SEQ DESC, ")
.append(" CN0071_05.CONT_KEI_TEISE_SEQ DESC ")
.append(" ) CN0071_06 ")
.append(" WHERE ")
.append(" ROWNUM='1' ")
.append(" ) CN0071_07 LEFT JOIN CN_T_CONT_CRECA_CHRG CN0071_08 ON ")
.append(" CN0071_07.CONT_KEI_NO = CN0071_08.CONT_KEI_NO AND ")
.append(" CN0071_07.CONT_KEI_NO_SEQ = CN0071_08.CONT_KEI_NO_SEQ AND ")
.append(" CN0071_07.CONT_KEI_TEISE_SEQ = CN0071_08.CONT_KEI_TEISE_SEQ ")
.append(" ) AND ")
// ST1-2012-0001018 2012/12/04 n.ajioka START
// .append(" CN0101_04.CHRG_TRGT_YM <= TO_CHAR(SYSDATE,'yyyyMM') AND ")
.append(" CN0101_04.CHRG_TRGT_YM <= ? AND ")
// .append(" CN0101_04.CHRG_TRGT_YM >= TO_CHAR(ADD_MONTHS(SYSDATE,-6),'yyyyMM') AND ")
// .append(" CN0101_04.CHRG_TRGT_YM >= ? AND ")
// ST1-2012-0001018 2012/12/04 n.ajioka START
.append(" CN0101_04.MK_FLG = '0' ")
.append(" GROUP BY ")
.append(" CN0101_04.CRECARD_ID, ")
.append(" CN0101_04.MK_FLG ")
.append(" ) CN0101_05 LEFT JOIN CN_T_CONTJIGYO_CRECA CN0101_06 ON ")
.append(" CN0101_05.CRECARD_ID = CN0101_06.CRECARD_ID AND ")
.append(" CN0101_05.GR_CHRG_TRGT_YM = CN0101_06.CHRG_TRGT_YM ")
.append(" ) CN0101_08 ON ")
.append(" CN0071_CN0081_03.CRECARD_ID = CN0101_08.CRECARD_ID ")
.append(" LEFT JOIN ZM_M_CD_NM_KANRI ZM0171_01 ON ")
.append(" ZM0171_01.CD_SBT_CD = 'CD00516' AND ")
.append(" CN0021_01.CONT_KEI_STAT_CD = ZM0171_01.CD_DIV AND ")
// ST1-2012-0001018 2012/12/04 n.ajioka START
// .append(" ZM0171_01.CD_TSTAYMD <= TO_CHAR(SYSDATE, 'yyyyMMdd') AND ")
.append(" ZM0171_01.CD_TSTAYMD <= ? AND ")
// .append(" ZM0171_01.CD_TENDYMD >= TO_CHAR(SYSDATE, 'yyyyMMdd') AND ")
.append(" ZM0171_01.CD_TENDYMD >= ? AND ")
.append(" ZM0171_01.MK_FLG = '0' LEFT JOIN ZM_M_CD_NM_KANRI ZM0171_02 ON ")
.append(" ZM0171_02.CD_SBT_CD = 'CD00350' AND ")
.append(" CN0021_01.TAXAREA = ZM0171_02.CD_DIV AND ")
// .append(" ZM0171_02.CD_TSTAYMD <= TO_CHAR(SYSDATE, 'yyyyMMdd') AND ")
.append(" ZM0171_02.CD_TSTAYMD <= ? AND ")
// .append(" ZM0171_02.CD_TENDYMD >= TO_CHAR(SYSDATE, 'yyyyMMdd') AND ")
.append(" ZM0171_02.CD_TENDYMD >= ? AND ")
.append(" ZM0171_02.MK_FLG = '0' LEFT JOIN ZM_M_CD_NM_KANRI ZM0171_03 ON ")
.append(" ZM0171_03.CD_SBT_CD = 'CD00511' AND ")
.append(" CN0091_05.CHRG_TEISE_RSN_DIV = ZM0171_03.CD_DIV AND ")
// .append(" ZM0171_03.CD_TSTAYMD <= TO_CHAR(SYSDATE, 'yyyyMMdd') AND ")
.append(" ZM0171_03.CD_TSTAYMD <= ? AND ")
// .append(" ZM0171_03.CD_TENDYMD >= TO_CHAR(SYSDATE, 'yyyyMMdd') AND ")
.append(" ZM0171_03.CD_TENDYMD >= ? AND ")
.append(" ZM0171_03.MK_FLG = '0' LEFT JOIN CN_M_CONT_SVC CN0041_01 ON ")
.append(" CN0021_01.CONT_SVC_CD = CN0041_01.CONT_SVC_CD AND ")
// .append(" CN0041_01.CONT_SVC_TSTAYMD <= TO_CHAR(SYSDATE, 'yyyyMMdd') AND ")
.append(" CN0041_01.CONT_SVC_TSTAYMD <= ? AND ")
// .append(" CN0041_01.CONT_SVC_TENDYMD >= TO_CHAR(SYSDATE, 'yyyyMMdd') ");
.append(" CN0041_01.CONT_SVC_TENDYMD >= ? ");
// ST1-2012-0001018 2012/12/04 n.ajioka END
// SQL文_個別部1
if ( "1".equals( inMsg.getObject(ECN0021A002CBSMsg.FUNC_CODE).toString() ) ) {
sql_Buff.append(" WHERE ")
.append(" CN0021_01.CONT_KEI_NO = ? AND ")
.append(" CN0021_01.MK_FLG='0' ");
}
//prepareStatementにSQL文をセット
pstmt = con1.prepareStatement(sql_Buff.toString());
//ログ出力(SQL文の出力)
JSYejbLog.outlog(inContext, JSYejbLog.DBACCESS, this.getClass(), sql_Buff);
// PreparedStatementの指定されたパラメータカラムに 指定された値を設定
if ( "1".equals( inMsg.getString(ECN0021A002CBSMsg.FUNC_CODE) ) ) {
// ST1-2012-0001018 2012/12/04 n.ajioka START
// パラメータの設定(ＫＥＹ＿コンテンツ契約番号を指定)
// CAANJDBCUtil.setParam(pstmt, 1, inMsg.getObject(ECN0021A002CBSMsg.KEY_CONT_KEI_NO));
// /* ++++++++++ v1.00.00 変更開始 ++++++++++ */
// CAANJDBCUtil.setParam(pstmt, 2, inMsg.getObject(ECN0021A002CBSMsg.KEY_CONT_KEI_NO));
// CAANJDBCUtil.setParam(pstmt, 3, inMsg.getObject(ECN0021A002CBSMsg.KEY_CONT_KEI_NO));
// CAANJDBCUtil.setParam(pstmt, 4, inMsg.getObject(ECN0021A002CBSMsg.KEY_CONT_KEI_NO));
// CAANJDBCUtil.setParam(pstmt, 5, inMsg.getObject(ECN0021A002CBSMsg.KEY_CONT_KEI_NO));
// CAANJDBCUtil.setParam(pstmt, 6, inMsg.getObject(ECN0021A002CBSMsg.KEY_CONT_KEI_NO));
// /* ++++++++++ v1.00.00 変更終了 ++++++++++ */
// バインド変数格納用の年月を取得
String strYmd = JCNModelCommon.addMonth(JCNModelCommon.getOpeDate(inMsg), -6);
String strYm = strYmd.substring(0, 6);
// 1.パラメータの設定(運用日付14桁を設定)
CAANJDBCUtil.setParam(pstmt, 1, JCNModelCommon.getOpeDateTime(inMsg, null));
// 2.パラメータの設定(運用日付14桁を設定)
CAANJDBCUtil.setParam(pstmt, 2, JCNModelCommon.getOpeDateTime(inMsg, null));
// 3.パラメータの設定(ＫＥＹ＿コンテンツ契約番号を指定)
CAANJDBCUtil.setParam(pstmt, 3, inMsg.getObject(ECN0021A002CBSMsg.KEY_CONT_KEI_NO));
// 4.パラメータの設定(運用年月を指定)
CAANJDBCUtil.setParam(pstmt, 4, JCNModelCommon.getOpeDate(inMsg).substring(0, 6));
// 5.パラメータの設定(運用年月の半年前を指定)
// CAANJDBCUtil.setParam(pstmt, 5, strYm);
// 6.パラメータの設定(ＫＥＹ＿コンテンツ契約番号を指定)
CAANJDBCUtil.setParam(pstmt, 5, inMsg.getObject(ECN0021A002CBSMsg.KEY_CONT_KEI_NO));
// 7.パラメータの設定(運用年月を指定)
CAANJDBCUtil.setParam(pstmt, 6, JCNModelCommon.getOpeDate(inMsg).substring(0, 6));
// 8.パラメータの設定(運用年月の半年前を指定)
// CAANJDBCUtil.setParam(pstmt, 8, strYm);
// 9.パラメータの設定(ＫＥＹ＿コンテンツ契約番号を指定)
CAANJDBCUtil.setParam(pstmt, 7, inMsg.getObject(ECN0021A002CBSMsg.KEY_CONT_KEI_NO));
// 10.パラメータの設定(運用年月を指定)
CAANJDBCUtil.setParam(pstmt, 8, JCNModelCommon.getOpeDate(inMsg).substring(0, 6));
// 11.パラメータの設定(運用年月の半年前を指定)
// CAANJDBCUtil.setParam(pstmt, 11, strYm);
// 12.パラメータの設定(ＫＥＹ＿コンテンツ契約番号を指定)
CAANJDBCUtil.setParam(pstmt, 9, inMsg.getObject(ECN0021A002CBSMsg.KEY_CONT_KEI_NO));
// 13.パラメータの設定(運用年月を指定)
CAANJDBCUtil.setParam(pstmt, 10, JCNModelCommon.getOpeDate(inMsg).substring(0, 6));
// 14.パラメータの設定(運用年月の半年前を指定)
// CAANJDBCUtil.setParam(pstmt, 14, strYm);
// 15.パラメータの設定(ＫＥＹ＿コンテンツ契約番号を指定)
CAANJDBCUtil.setParam(pstmt, 11, inMsg.getObject(ECN0021A002CBSMsg.KEY_CONT_KEI_NO));
// 16.パラメータの設定(運用年月を指定)
CAANJDBCUtil.setParam(pstmt, 12, JCNModelCommon.getOpeDate(inMsg).substring(0, 6));
// 17.パラメータの設定(運用年月の半年前を指定)
// CAANJDBCUtil.setParam(pstmt, 17, strYm);
// 18.パラメータの設定(運用年月を指定)
CAANJDBCUtil.setParam(pstmt, 13, JCNModelCommon.getOpeDate(inMsg).substring(0, 6));
// 19.パラメータの設定(運用年月の半年前を指定)
// CAANJDBCUtil.setParam(pstmt, 19, strYm);
// 20.パラメータの設定(運用年月日を指定)
CAANJDBCUtil.setParam(pstmt, 14, JCNModelCommon.getOpeDate(inMsg));
// 21.パラメータの設定(運用年月日を指定)
CAANJDBCUtil.setParam(pstmt, 15, JCNModelCommon.getOpeDate(inMsg));
// 22.パラメータの設定(運用年月日を指定)
CAANJDBCUtil.setParam(pstmt, 16, JCNModelCommon.getOpeDate(inMsg));
// 23.パラメータの設定(運用年月日を指定)
CAANJDBCUtil.setParam(pstmt, 17, JCNModelCommon.getOpeDate(inMsg));
// 24.パラメータの設定(運用年月日を指定)
CAANJDBCUtil.setParam(pstmt, 18, JCNModelCommon.getOpeDate(inMsg));
// 25.パラメータの設定(運用年月日を指定)
CAANJDBCUtil.setParam(pstmt, 19, JCNModelCommon.getOpeDate(inMsg));
// 26.パラメータの設定(運用年月日を指定)
CAANJDBCUtil.setParam(pstmt, 20, JCNModelCommon.getOpeDate(inMsg));
// 27.パラメータの設定(運用年月日を指定)
CAANJDBCUtil.setParam(pstmt, 21, JCNModelCommon.getOpeDate(inMsg));
// 28.パラメータの設定(ＫＥＹ＿コンテンツ契約番号を指定)
CAANJDBCUtil.setParam(pstmt, 22, inMsg.getObject(ECN0021A002CBSMsg.KEY_CONT_KEI_NO));
// ST1-2012-0001018 2012/12/04 n.ajioka END
}
// ResultSetの取得
rsltQuery = pstmt.executeQuery();
// ECN0021A002CBSMsgの明細にセットする項目
String[] msgKeyList1 = {
ECN0021A002CBSMsg1List.CONT_KEI_NO
, ECN0021A002CBSMsg1List.SYSID
, ECN0021A002CBSMsg1List.CONT_SVC_CD
, ECN0021A002CBSMsg1List.CONT_CD
, ECN0021A002CBSMsg1List.CONT_OUT_CD
, ECN0021A002CBSMsg1List.CONT_NM
, ECN0021A002CBSMsg1List.CONT_SBT_CD
, ECN0021A002CBSMsg1List.CONT_KEI_STA_DTM
, ECN0021A002CBSMsg1List.CONT_KEI_END_DTM
, ECN0021A002CBSMsg1List.CONT_PAYWAY_CD
, ECN0021A002CBSMsg1List.CRECARD_ID
, ECN0021A002CBSMsg1List.ISP_KSSAI_SVC_KEI_NO
, ECN0021A002CBSMsg1List.SUPPLIER
, ECN0021A002CBSMsg1List.CONT_KEI_STAT_CD
, ECN0021A002CBSMsg1List.TAXAREA
, ECN0021A002CBSMsg1List.CHOICETICKT_USE_PSB_CNT
, ECN0021A002CBSMsg1List.CONT_KEI_KEIZOKU_CNT
, ECN0021A002CBSMsg1List.CONT_BUY_CNT
, ECN0021A002CBSMsg1List.CONT_TANKA
, ECN0021A002CBSMsg1List.CONT_KEI_SBT_CD
, ECN0021A002CBSMsg1List.KEI_PSBSU
, ECN0021A002CBSMsg1List.HIKEIZOKU_FLG
, ECN0021A002CBSMsg1List.CONT_KEI_YRYO_MRYO_FLG
, ECN0021A002CBSMsg1List.CHRG_FORM_CD
, ECN0021A002CBSMsg1List.OLD_LIMIT
, ECN0021A002CBSMsg1List.USE_PSB_USER_SBT_CD
, ECN0021A002CBSMsg1List.RNKSAKI_CD
, ECN0021A002CBSMsg1List.RNKSAKI_CONT_SKBT_ID
, ECN0021A002CBSMsg1List.CONT_SONZAI_FLG
, ECN0021A002CBSMsg1List.KEI_JI_SYSID
, ECN0021A002CBSMsg1List.KEI_JI_MMB_SBT_CD
, ECN0021A002CBSMsg1List.DSL_JI_MMB_SBT_CD
, ECN0021A002CBSMsg1List.KEI_TRAN_YMD
, ECN0021A002CBSMsg1List.TRENDMICRO_CEREAL_NO
, ECN0021A002CBSMsg1List.REDIRECT_URL
, ECN0021A002CBSMsg1List.VIRUSBUSTER_ID
, ECN0021A002CBSMsg1List.DSL_IF_SEND_FLG
, ECN0021A002CBSMsg1List.HANYO_KMK_NM
, ECN0021A002CBSMsg1List.HANYO_VALUE
, ECN0021A002CBSMsg1List.CONT_CHRG_STAT
, ECN0021A002CBSMsg1List.CONT_CAMPAIGN_ID
, ECN0021A002CBSMsg1List.CONT_CAMPAIGN_NM
, ECN0021A002CBSMsg1List.CONT_CMP_TG_MMB_BUNRUI_CD
, ECN0021A002CBSMsg1List.CONT_CHOKI_WRIB_MON_CNT
, ECN0021A002CBSMsg1List.CONT_CAMPAIGN_FORM_CD
, ECN0021A002CBSMsg1List.CONT_CAMPAIGN_WRIB_RT
, ECN0021A002CBSMsg1List.CONT_CAMPAIGN_WRIB_AMNT
, ECN0021A002CBSMsg1List.PLMIN_DIV
, ECN0021A002CBSMsg1List.CHRG_CRECARD_ID
, ECN0021A002CBSMsg1List.CHRG_ISP_KSSAI_SVC_KEI_NO
, ECN0021A002CBSMsg1List.CHRG_TRGT_YM
, ECN0021A002CBSMsg1List.CHRG_STAT_CD
, ECN0021A002CBSMsg1List.CHRG_JTN_MEMBER_SBT_CD
, ECN0021A002CBSMsg1List.CHRG_AMNT
, ECN0021A002CBSMsg1List.CHRG_CONT_TANKA
, ECN0021A002CBSMsg1List.TAX_RT
, ECN0021A002CBSMsg1List.CHRG_CONT_BUY_CNT
, ECN0021A002CBSMsg1List.CHRG_TRAN_YMD
, ECN0021A002CBSMsg1List.CONTCHRGTESEI_STAT
, ECN0021A002CBSMsg1List.CONTCHRGTESEI_DIV
, ECN0021A002CBSMsg1List.TESEI_PLMIN_DIV
, ECN0021A002CBSMsg1List.CHRG_TEISE_YMD
, ECN0021A002CBSMsg1List.CHRG_TEISE_RSN_DIV
, ECN0021A002CBSMsg1List.CHRG_JTN_TAX_RT
, ECN0021A002CBSMsg1List.SALES_GEN_AMNT
, ECN0021A002CBSMsg1List.COMPENSATION
, ECN0021A002CBSMsg1List.CONTCHRGTESEI_KSSAI_SEIYMD
, ECN0021A002CBSMsg1List.CHRG_TEISE_RSN_MEMO
, ECN0021A002CBSMsg1List.TEISE_TRAN_YMD
, ECN0021A002CBSMsg1List.CONTJIGYO_CRECA_STAT
, ECN0021A002CBSMsg1List.CRECARD_JIGYO_CD
, ECN0021A002CBSMsg1List.CRECARD_COMP_CD
, ECN0021A002CBSMsg1List.CRECARD_NO
, ECN0021A002CBSMsg1List.CHRG_CONTJIGYO_CRECA_STAT
, ECN0021A002CBSMsg1List.CHRG_CRECARD_JIGYO_CD
, ECN0021A002CBSMsg1List.CHRG_CRECARD_COMP_CD
, ECN0021A002CBSMsg1List.CHRG_CRECARD_NO
, ECN0021A002CBSMsg1List.CONT_KEI_STAT_CD_NM
, ECN0021A002CBSMsg1List.TAXAREA_NM
, ECN0021A002CBSMsg1List.CHRG_TEISE_RSN_DIV_NM
, ECN0021A002CBSMsg1List.CONT_SVC_NM
// ｖ20.00.00 ADD START
, ECN0021A002CBSMsg1List.CRECARD_YK_KIGEN
, ECN0021A002CBSMsg1List.CRECARD_NO_AZKRI_ID
, ECN0021A002CBSMsg1List.CHRG_CRECARD_YK_KIGEN
, ECN0021A002CBSMsg1List.CHRG_CRECARD_NO_AZKRI_ID
// ｖ20.00.00 ADD END
};
// 明細に処理結果(ResultSet)をマッピング
CAANMsg[] outMsg1 = mapMessageList(rsltQuery,msgKeyList1,"eo.ejb.cbs.cbsmsg.ECN0021A002CBSMsg1List",0);
/* ++++++++++ v1.00.00 変更開始 ++++++++++ */
// 検索件数が0件の場合、エラーフラグに"1"を設定して処理終了
if (0 == outMsg1.length)
{
inMsg.set(ECN0021A002CBSMsg.SEARCH_ERR_FLG, JPCModelConstant.SEARCH_ERR_FLG_ZERO);
return;
}
/* ++++++++++ v1.0.0 追加終了 ++++++++++ */
// クレジットカード番号を復号化
if (null != outMsg1[0].getString(ECN0021A002CBSMsg1List.CRECARD_NO) && !outMsg1[0].getString(ECN0021A002CBSMsg1List.CRECARD_NO).isEmpty())
{
outMsg1[0].set(ECN0021A002CBSMsg1List.CRECARD_NO, JCCModelCommon.getDecryptResult(inMsg, inContext, outMsg1[0].getString(ECN0021A002CBSMsg1List.CRECARD_NO)));
}
if (null != outMsg1[0].getString(ECN0021A002CBSMsg1List.CHRG_CRECARD_NO) && !outMsg1[0].getString(ECN0021A002CBSMsg1List.CHRG_CRECARD_NO).isEmpty())
{
outMsg1[0].set(ECN0021A002CBSMsg1List.CHRG_CRECARD_NO, JCCModelCommon.getDecryptResult(inMsg, inContext, outMsg1[0].getString(ECN0021A002CBSMsg1List.CHRG_CRECARD_NO)));
}
// inMsg(CBSMsg)に明細をセット
inMsg.set("ECN0021A002CBSMsg1List", outMsg1);
} catch(SQLException e) {
inMsg.set(ECN0021A002CBSMsg.STATUS, StatusCodes.FIND_DB_ERR);
throw new CAANRuntimeException(e);
} catch(ParseException e) {
inMsg.set(ECN0111B003CBSMsg.STATUS, StatusCodes.FIND_DB_ERR);
throw new CAANRuntimeException(e);
} finally {
// 資源の解放
try{
if(rsltQuery != null){
rsltQuery.close();
}
if(pstmt != null){
pstmt.close();
}
if(con1 != null){
closeConnection(con1);
}
}catch(SQLException e){
inMsg.set(ECN0021A002CBSMsg.STATUS, StatusCodes.FIND_DB_ERR);
throw new CAANRuntimeException(e);
}
}
}
}