/*******************************************************************************
* All Rights reserved,Copyright (c) K-Opticom
********************************************************************************
*＜プログラム内容＞
* システム名 ：eo顧客基幹システム
* モジュール名 ：JSYejbECN0021B002TPDA
* ソースファイル名：JSYejbECN0021B002TPDA.java
* 作成者 ：EK908988
* 日付 ：2011年08月03日
*＜機能概要＞
* SQLFacility
* テンプレートDBアクセス部品です。
*＜修正履歴＞
* バージョン 修正日 修正者 修正内容
* ｖ1.00.00
* ｖ4.00.00 2012/12/04 富士通)味岡 ST1-2012-0001018:SYSDATE使用箇所を運用日付使用に置き換え
* ｖ4.00.00 2013/03/02 富士通)味岡 ST1-2013-0000457:クレジットカードIDとISP決済サービス契約番号の参照先を変更(コンテンツ契約→クレカ or ISP)
* ｖ8.00.00 2013/12/19 富士通)山口 ANK-1585-00-00 :050電話番号の取得を追加
* ｖ20.00.00 2015/11/16 富士通)清原 ANK-2565-00-00 :クレジットカード番号預かりサービス導入（Step3：預かり番号化）
* v20.00.01 2015/12/17 FJ)頼経 【ANK-2663-00-00】LalaCALL 代理店対応(STNet・テレビトクシマ)
* v58.00.00 2022/04/07 FJ)北村 【ANK-3846-00-00】クリアパス→ペイジェント移行
* v58.00.01 2022/08/01 FJ)中原 【IT2-2022-0000006】請求月に対する決済ＩＤが表示されない
*
********************************************************************************/
package eo.ejb.cbs.sqlf;
import com.fujitsu.futurity.model.base.CAANMsg;
import com.fujitsu.futurity.model.base.CAANSQLFacility;
import com.fujitsu.futurity.model.base.CAANRuntimeException;
import com.fujitsu.futurity.model.base.CAANJDBCUtil;
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.TemplateDBAccessHandler;
import com.fujitsu.futurity.model.ejb.common.fw.AgentDispatchContext;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import eo.common.constant.JPCModelConstant;
import eo.ejb.cbs.cbsmsg.ECN0021B002CBSMsg;
import eo.ejb.cbs.cbsmsg.ECN0021B002CBSMsg1List;
import eo.ejb.cbm.entity.CN0021ETMsg;
import eo.ejb.common.JCCModelCommon;
import eo.ejb.common.JCNModelCommon;
/**
*
* テンプレートDBアクセス部品 ECN0021B002_SQLF
* 入力された項目からSQL文を動的に組み立て、
* 検索結果をCBSMsgにセットします。
*/
public class JSYejbECN0021B002TPDA extends CAANSQLFacility implements TemplateDBAccessHandler{
/**
* コンストラクタ
*/
public JSYejbECN0021B002TPDA() {
}
/**
* ECN0021B002_SQLF
* @param inMsg 入力値の格納されたCBSMsg
* @return void
*/
public void invoke(CAANMsg inMsg,AgentDispatchContext inContext){
// コネクション
Connection con1 = null;
// プリペアステートメント
PreparedStatement pstmt = null;
PreparedStatement pstmtCnt = null;
// リザルトセット
ResultSet rsltQuery = null;
ResultSet rsltQueryCnt = null;
/********************
* SQL文の作成
********************/
try{
//コネクション取得
con1 = JSYejbConnection.getConnection(CN0021ETMsg.getTableName());
/* ++++++++++ v1.00.00 追加開始 ++++++++++ */
StringBuffer sql_cnt_Buff = new StringBuffer();
sql_cnt_Buff.append(" SELECT ")
.append(" COUNT(*) AS CNT ")
.append(" FROM ")
.append(" ( ");
// SQL文_個別部1
if ("1".equals(inMsg.getObject(ECN0021B002CBSMsg.FUNC_CODE).toString()))
{
sql_cnt_Buff.append(" SELECT ")
.append(" 1 ")
.append(" FROM ( ")
.append(" SELECT ")
.append(" CRECHRG02.CONT_KEI_NO AS CONT_KEI_NO, ")
.append(" CRECHRG02.CONT_KEI_NO_SEQ AS CONT_KEI_NO_SEQ, ")
.append(" MAX(CRECHRG02.CONT_KEI_TEISE_SEQ) CONT_KEI_TEISE_SEQ ")
.append(" FROM ")
.append(" CN_T_CONT_CRECA_CHRG CRECHRG02 ")
.append(" WHERE ")
.append(" CRECHRG02.SYSID = ? AND ")
.append(" CRECHRG02.CHRG_TRGT_YM = ? AND ")
.append(" CRECHRG02.CONT_CRECARD_CHRG_STAT = '001' AND ")
.append(" CRECHRG02.MK_FLG = '0' ")
.append(" GROUP BY ")
.append(" CONT_KEI_NO, ")
.append(" CONT_KEI_NO_SEQ ")
.append(" ) CRECAMAX01 ")
.append(" INNER JOIN CN_T_CONT_CRECA_CHRG CRECHRG01 ")
.append(" ON (CRECHRG01.SYSID = ? AND ")
.append(" CRECHRG01.CHRG_TRGT_YM = ? AND ")
.append(" CRECHRG01.CONT_CRECARD_CHRG_STAT = '001' AND ")
.append(" CRECHRG01.CONT_KEI_NO = CRECAMAX01.CONT_KEI_NO AND ")
.append(" CRECHRG01.CONT_KEI_NO_SEQ = CRECAMAX01.CONT_KEI_NO_SEQ AND ")
.append(" CRECHRG01.CONT_KEI_TEISE_SEQ = CRECAMAX01.CONT_KEI_TEISE_SEQ AND ")
.append(" CRECHRG01.MK_FLG = '0') ")
.append(" INNER JOIN CN_T_CONT_KEI KEI01 ")
.append(" ON (KEI01.CONT_KEI_NO = CRECHRG01.CONT_KEI_NO AND ")
.append(" KEI01.MK_FLG = '0') ")
.append(" LEFT OUTER JOIN CN_M_CONT_SVC CNSVC01 ON CRECHRG01.CONT_SVC_CD = CNSVC01.CONT_SVC_CD ")
.append(" UNION ALL ")
.append(" SELECT ")
.append(" 1 ")
.append(" FROM( ")
.append(" SELECT ")
.append(" ISPCHRG02.CONT_KEI_NO AS CONT_KEI_NO, ")
.append(" ISPCHRG02.CONT_KEI_NO_SEQ AS CONT_KEI_NO_SEQ, ")
.append(" MAX(ISPCHRG02.CONT_KEI_TEISE_SEQ) CONT_KEI_TEISE_SEQ ")
.append(" FROM ")
.append(" CN_T_CONT_ISP_CHRG ISPCHRG02 ")
.append(" WHERE ")
.append(" ISPCHRG02.SYSID = ? AND ")
.append(" ISPCHRG02.CHRG_TRGT_YM = ? AND ")
.append(" ISPCHRG02.CONT_ISP_CHRG_STAT = '001' AND ")
.append(" ISPCHRG02.MK_FLG = '0' ")
.append(" GROUP BY ")
.append(" CONT_KEI_NO, ")
.append(" CONT_KEI_NO_SEQ ")
.append(" ) ISPMAX01 ")
.append(" INNER JOIN CN_T_CONT_ISP_CHRG ISPCHRG01 ")
.append(" ON (ISPCHRG01.SYSID = ? AND ")
.append(" ISPCHRG01.CHRG_TRGT_YM = ? AND ")
.append(" ISPCHRG01.CONT_ISP_CHRG_STAT = '001' AND ")
.append(" ISPCHRG01.CONT_KEI_NO = ISPMAX01.CONT_KEI_NO AND ")
.append(" ISPCHRG01.CONT_KEI_NO_SEQ = ISPMAX01.CONT_KEI_NO_SEQ AND ")
.append(" ISPCHRG01.CONT_KEI_TEISE_SEQ = ISPMAX01.CONT_KEI_TEISE_SEQ AND ")
.append(" ISPCHRG01.MK_FLG = '0') ")
.append(" INNER JOIN CN_T_CONT_KEI KEI02 ")
.append(" ON (KEI02.CONT_KEI_NO = ISPCHRG01 .CONT_KEI_NO) ")
.append(" LEFT OUTER JOIN CN_M_CONT_SVC CNSVC02 ON ISPCHRG01.CONT_SVC_CD = CNSVC02.CONT_SVC_CD ")
.append(" UNION ALL ")
.append(" SELECT ")
.append(" 1 ")
.append(" FROM ( ")
.append(" SELECT ")
.append(" CRECHRG03.CONT_KEI_NO AS CONT_KEI_NO, ")
.append(" CRECHRG03.CONT_KEI_NO_SEQ AS CONT_KEI_NO_SEQ, ")
.append(" MAX(CRECHRG03.CONT_KEI_TEISE_SEQ) CONT_KEI_TEISE_SEQ ")
.append(" FROM ")
.append(" CN_T_CONT_CRECA_CHRG CRECHRG03 ")
.append(" WHERE ")
.append(" CRECHRG03.SYSID = ? AND ")
.append(" CRECHRG03.CHRG_TRGT_YM = ? AND ")
.append(" CRECHRG03.CONT_CRECARD_CHRG_STAT = '001' AND ")
.append(" CRECHRG03.MK_FLG = '0' ")
.append(" GROUP BY ")
.append(" CONT_KEI_NO, ")
.append(" CONT_KEI_NO_SEQ ")
.append(" ) CRECAMAX02 ")
.append(" INNER JOIN CN_T_CONT_CRECA_CHRG CRECHRG04 ")
.append(" ON (CRECHRG04.SYSID = ? AND ")
.append(" CRECHRG04.CHRG_TRGT_YM = ? AND ")
.append(" CRECHRG04.CONT_CRECARD_CHRG_STAT = '001' AND ")
.append(" CRECHRG04.CONT_KEI_NO = CRECAMAX02.CONT_KEI_NO AND ")
.append(" CRECHRG04.CONT_KEI_NO_SEQ = CRECAMAX02.CONT_KEI_NO_SEQ AND ")
.append(" CRECHRG04.CONT_KEI_TEISE_SEQ = CRECAMAX02.CONT_KEI_TEISE_SEQ AND ")
.append(" CRECHRG04.MK_FLG = '0') ")
.append(" INNER JOIN CN_T_CONT_KEI KEI03 ")
.append(" ON (KEI03.CONT_KEI_NO = CRECHRG04.CONT_KEI_NO AND ")
.append(" KEI03.MK_FLG = '0') ")
.append(" INNER JOIN ( ")
.append(" SELECT ")
.append(" TESEI02.CONT_KEI_NO AS CONT_KEI_NO, ")
.append(" TESEI02.CONT_KEI_NO_SEQ AS CONT_KEI_NO_SEQ, ")
.append(" TESEI02.CHRG_JTN_TAX_RT AS CHRG_JTN_TAX_RT, ")
.append(" SUM(TESEI02.SALES_GEN_AMNT) AS SALES_GEN_AMNT, ")
.append(" SUM(TESEI02.COMPENSATION) AS COMPENSATION, ")
.append(" MAX(TESEI02.CONT_CHRG_TEISE_SEQ) AS CONT_CHRG_TEISE_SEQ ")
.append(" FROM ")
.append(" CN_T_CONTCHRGTESEI TESEI02 ")
.append(" WHERE ")
.append(" TESEI02.SYSID = ? AND ")
.append(" SUBSTR(TESEI02.CHRG_TEISE_YMD, 1, 6) = ? AND ")
.append(" TESEI02.CONTCHRGTESEI_STAT ='001' AND ")
.append(" TESEI02.MK_FLG = '0' ")
.append(" GROUP BY ")
.append(" TESEI02.CONT_KEI_NO, ")
.append(" TESEI02.CONT_KEI_NO_SEQ, ")
.append(" TESEI02.CHRG_JTN_TAX_RT ")
.append(" ) TESEI01_SUM ")
.append(" ON (TESEI01_SUM.CONT_KEI_NO = CRECHRG04.CONT_KEI_NO AND ")
.append(" TESEI01_SUM.CONT_KEI_NO_SEQ = CRECHRG04.CONT_KEI_NO_SEQ) ")
.append(" INNER JOIN CN_T_CONTCHRGTESEI TESEI01 ")
.append(" ON (TESEI01.CONT_KEI_NO = TESEI01_SUM.CONT_KEI_NO AND ")
.append(" TESEI01.CONT_KEI_NO_SEQ = TESEI01_SUM.CONT_KEI_NO_SEQ AND ")
.append(" TESEI01.CONT_CHRG_TEISE_SEQ = TESEI01_SUM.CONT_CHRG_TEISE_SEQ) ")
.append(" LEFT OUTER JOIN CN_M_CONT_SVC CNSVC03 ON TESEI01.CONT_SVC_CD = CNSVC03.CONT_SVC_CD ")
.append(" UNION ALL ")
.append(" SELECT ")
.append(" 1")
.append(" FROM ( ")
.append(" SELECT ")
.append(" ISPCHRG03.CONT_KEI_NO AS CONT_KEI_NO, ")
.append(" ISPCHRG03.CONT_KEI_NO_SEQ AS CONT_KEI_NO_SEQ, ")
.append(" MAX(ISPCHRG03.CONT_KEI_TEISE_SEQ) CONT_KEI_TEISE_SEQ ")
.append(" FROM ")
.append(" CN_T_CONT_ISP_CHRG ISPCHRG03 ")
.append(" WHERE ")
.append(" ISPCHRG03.SYSID = ? AND ")
.append(" ISPCHRG03.CHRG_TRGT_YM = ? AND ")
.append(" ISPCHRG03.CONT_ISP_CHRG_STAT = '001' AND ")
.append(" ISPCHRG03.MK_FLG = '0' ")
.append(" GROUP BY ")
.append(" CONT_KEI_NO, ")
.append(" CONT_KEI_NO_SEQ ")
.append(" ) CRECAMAX02 ")
.append(" INNER JOIN CN_T_CONT_ISP_CHRG ISPCHRG02 ")
.append(" ON (ISPCHRG02.SYSID = ? AND ")
.append(" ISPCHRG02.CHRG_TRGT_YM = ? AND ")
.append(" ISPCHRG02.CONT_ISP_CHRG_STAT = '001' AND ")
.append(" ISPCHRG02.CONT_KEI_NO = CRECAMAX02.CONT_KEI_NO AND ")
.append(" ISPCHRG02.CONT_KEI_NO_SEQ = CRECAMAX02.CONT_KEI_NO_SEQ AND ")
.append(" ISPCHRG02.CONT_KEI_TEISE_SEQ = CRECAMAX02.CONT_KEI_TEISE_SEQ AND ")
.append(" ISPCHRG02.MK_FLG = '0') ")
.append(" INNER JOIN CN_T_CONT_KEI KEI04 ")
.append(" ON (KEI04.CONT_KEI_NO = ISPCHRG02.CONT_KEI_NO AND ")
.append(" KEI04.MK_FLG = '0') ")
.append(" INNER JOIN ( ")
.append(" SELECT ")
.append(" TESEI04.CONT_KEI_NO AS CONT_KEI_NO, ")
.append(" TESEI04.CONT_KEI_NO_SEQ AS CONT_KEI_NO_SEQ, ")
.append(" TESEI04.CHRG_JTN_TAX_RT AS CHRG_JTN_TAX_RT, ")
.append(" SUM(TESEI04.SALES_GEN_AMNT) AS SALES_GEN_AMNT, ")
.append(" SUM(TESEI04.COMPENSATION) AS COMPENSATION, ")
.append(" MAX(TESEI04.CONT_CHRG_TEISE_SEQ) AS CONT_CHRG_TEISE_SEQ ")
.append(" FROM ")
.append(" CN_T_CONTCHRGTESEI TESEI04 ")
.append(" WHERE ")
.append(" TESEI04.SYSID = ? AND ")
.append(" SUBSTR(TESEI04.CHRG_TEISE_YMD, 1, 6) = ? AND ")
.append(" TESEI04.CONTCHRGTESEI_STAT ='001' AND ")
.append(" TESEI04.MK_FLG = '0' ")
.append(" GROUP BY ")
.append(" TESEI04.CONT_KEI_NO, ")
.append(" TESEI04.CONT_KEI_NO_SEQ, ")
.append(" TESEI04.CHRG_JTN_TAX_RT ")
.append(" ) TESEI03_SUM ")
.append(" ON (TESEI03_SUM.CONT_KEI_NO = ISPCHRG02.CONT_KEI_NO AND ")
.append(" TESEI03_SUM.CONT_KEI_NO_SEQ = ISPCHRG02.CONT_KEI_NO_SEQ) ")
.append(" INNER JOIN CN_T_CONTCHRGTESEI TESEI03 ")
.append(" ON (TESEI03.CONT_KEI_NO = TESEI03_SUM.CONT_KEI_NO AND ")
.append(" TESEI03.CONT_KEI_NO_SEQ = TESEI03_SUM.CONT_KEI_NO_SEQ AND ")
.append(" TESEI03.CONT_CHRG_TEISE_SEQ = TESEI03_SUM.CONT_CHRG_TEISE_SEQ) ")
.append(" LEFT OUTER JOIN CN_M_CONT_SVC CNSVC04 ON TESEI03.CONT_SVC_CD = CNSVC04.CONT_SVC_CD ")
.append(" ) ");
}
//prepareStatementにSQL文をセット
pstmtCnt = con1.prepareStatement(sql_cnt_Buff.toString());
//ログ出力(SQL文の出力)
JSYejbLog.outlog(inContext, JSYejbLog.DBACCESS, this.getClass(), sql_cnt_Buff);
// PreparedStatementの指定されたパラメータカラムに 指定された値を設定
if ("1".equals(inMsg.getString(ECN0021B002CBSMsg.FUNC_CODE)))
{
int index = 1;
// パラメータの設定(ＫＥＹ＿ＳＹＳＩＤを指定)
CAANJDBCUtil.setParam(pstmtCnt, index++, inMsg.getObject(ECN0021B002CBSMsg.KEY_SYSID));
// パラメータの設定(ＫＥＹ＿課金対象年月を指定)
CAANJDBCUtil.setParam(pstmtCnt, index++, inMsg.getObject(ECN0021B002CBSMsg.KEY_CHRG_TRGT_YM));
// パラメータの設定(ＫＥＹ＿ＳＹＳＩＤを指定)
CAANJDBCUtil.setParam(pstmtCnt, index++, inMsg.getObject(ECN0021B002CBSMsg.KEY_SYSID));
// パラメータの設定(ＫＥＹ＿課金対象年月を指定)
CAANJDBCUtil.setParam(pstmtCnt, index++, inMsg.getObject(ECN0021B002CBSMsg.KEY_CHRG_TRGT_YM));
// パラメータの設定(ＫＥＹ＿ＳＹＳＩＤを指定)
CAANJDBCUtil.setParam(pstmtCnt, index++, inMsg.getObject(ECN0021B002CBSMsg.KEY_SYSID));
// パラメータの設定(ＫＥＹ＿課金対象年月を指定)
CAANJDBCUtil.setParam(pstmtCnt, index++, inMsg.getObject(ECN0021B002CBSMsg.KEY_CHRG_TRGT_YM));
// パラメータの設定(ＫＥＹ＿ＳＹＳＩＤを指定)
CAANJDBCUtil.setParam(pstmtCnt, index++, inMsg.getObject(ECN0021B002CBSMsg.KEY_SYSID));
// パラメータの設定(ＫＥＹ＿課金対象年月を指定)
CAANJDBCUtil.setParam(pstmtCnt, index++, inMsg.getObject(ECN0021B002CBSMsg.KEY_CHRG_TRGT_YM));
// パラメータの設定(ＫＥＹ＿ＳＹＳＩＤを指定)
CAANJDBCUtil.setParam(pstmtCnt, index++, inMsg.getObject(ECN0021B002CBSMsg.KEY_SYSID));
// パラメータの設定(ＫＥＹ＿課金対象年月を指定)
CAANJDBCUtil.setParam(pstmtCnt, index++, inMsg.getObject(ECN0021B002CBSMsg.KEY_CHRG_TRGT_YM));
// パラメータの設定(ＫＥＹ＿ＳＹＳＩＤを指定)
CAANJDBCUtil.setParam(pstmtCnt, index++, inMsg.getObject(ECN0021B002CBSMsg.KEY_SYSID));
// パラメータの設定(ＫＥＹ＿課金対象年月を指定)
CAANJDBCUtil.setParam(pstmtCnt, index++, inMsg.getObject(ECN0021B002CBSMsg.KEY_CHRG_TRGT_YM));
// パラメータの設定(ＫＥＹ＿ＳＹＳＩＤを指定)
CAANJDBCUtil.setParam(pstmtCnt, index++, inMsg.getObject(ECN0021B002CBSMsg.KEY_SYSID));
// パラメータの設定(ＫＥＹ＿課金対象年月を指定)
CAANJDBCUtil.setParam(pstmtCnt, index++, inMsg.getObject(ECN0021B002CBSMsg.KEY_CHRG_TRGT_YM));
// パラメータの設定(ＫＥＹ＿ＳＹＳＩＤを指定)
CAANJDBCUtil.setParam(pstmtCnt, index++, inMsg.getObject(ECN0021B002CBSMsg.KEY_SYSID));
// パラメータの設定(ＫＥＹ＿課金対象年月を指定)
CAANJDBCUtil.setParam(pstmtCnt, index++, inMsg.getObject(ECN0021B002CBSMsg.KEY_CHRG_TRGT_YM));
// パラメータの設定(ＫＥＹ＿ＳＹＳＩＤを指定)
CAANJDBCUtil.setParam(pstmtCnt, index++, inMsg.getObject(ECN0021B002CBSMsg.KEY_SYSID));
// パラメータの設定(ＫＥＹ＿課金対象年月を指定)
CAANJDBCUtil.setParam(pstmtCnt, index++, inMsg.getObject(ECN0021B002CBSMsg.KEY_CHRG_TRGT_YM));
// パラメータの設定(ＫＥＹ＿ＳＹＳＩＤを指定)
CAANJDBCUtil.setParam(pstmtCnt, index++, inMsg.getObject(ECN0021B002CBSMsg.KEY_SYSID));
// パラメータの設定(ＫＥＹ＿課金対象年月を指定)
CAANJDBCUtil.setParam(pstmtCnt, index++, inMsg.getObject(ECN0021B002CBSMsg.KEY_CHRG_TRGT_YM));
}
// ResultSetの取得
rsltQueryCnt = pstmtCnt.executeQuery();
// EZM0161B010CBSMsgの明細にセットする項目
String[] msgKeyListCnt = {
ECN0021B002CBSMsg.TOTAL_SEARCH_NUM
};
// 検索結果取得
rsltQueryCnt.next();
mapMessage(rsltQueryCnt, msgKeyListCnt, inMsg);
// 検索件数が0件の場合、エラーフラグに"1"を設定して処理終了
if (0 == (Integer.parseInt(inMsg.getString(ECN0021B002CBSMsg.TOTAL_SEARCH_NUM))))
{
inMsg.set(ECN0021B002CBSMsg.SEARCH_ERR_FLG, JPCModelConstant.SEARCH_ERR_FLG_ZERO);
return;
}
// 検索件数が最大検索件数を超えた場合、エラーフラグに"2"を設定して処理終了
if (Integer.parseInt(inMsg.getString(ECN0021B002CBSMsg.MAX_SEARCH_NUM))
< (Integer.parseInt(inMsg.getString(ECN0021B002CBSMsg.TOTAL_SEARCH_NUM))))
{
inMsg.set(ECN0021B002CBSMsg.SEARCH_ERR_FLG, JPCModelConstant.SEARCH_ERR_FLG_OVERMAX);
return;
}
/* ++++++++++ v1.00.00 追加終了 ++++++++++ */
// SQL文_基本部1
StringBuffer sql_Buff = new StringBuffer();
sql_Buff.append(" SELECT ")
.append(" RESULT.CONT_KEI_NO, ")
.append(" RESULT.CONT_KEI_NO_SEQ, ")
.append(" RESULT.CONT_CHRG_TEISE_SEQ, ")
.append(" RESULT.CONT_SVC_CD, ")
.append(" RESULT.CONT_SVC_NM, ")
.append(" RESULT.CONT_CD, ")
.append(" RESULT.CONT_OUT_CD, ")
.append(" RESULT.CONT_NM, ")
.append(" RESULT.CONT_CAMPAIGN_ID, ")
.append(" RESULT.CONT_CAMPAIGN_NM, ")
.append(" RESULT.CONT_PAYWAY_CD, ")
.append(" RESULT.CRECARD_COMP_CD, ")
.append(" RESULT.CRECARD_COMP_NM, ")
.append(" RESULT.CRECARD_ID, ")
.append(" RESULT.CRECARD_NO, ")
.append(" RESULT.ISP_KSSAI_SVC_KEI_NO, ")
.append(" RESULT.PLMIN_DIV, ")
.append(" RESULT.CHRG_AMNT, ")
.append(" RESULT.CONT_TANKA, ")
.append(" RESULT.TAXAREA, ")
.append(" RESULT.TAX_RT, ")
.append(" RESULT.CONT_BUY_CNT, ")
.append(" RESULT.CONTCHRGTESEI_DIV, ")
.append(" RESULT.CONTCHRGTESEI_DIV_NM, ")
.append(" RESULT.SALES_GEN_AMNT, ")
.append(" RESULT.COMPENSATION, ")
.append(" RESULT.RECORD_KBN, ")
.append(" RESULT.CHRG_STAT_CD, ")
.append(" RESULT.SEIKY_KEI_NO ")
.append(" ,( ")
.append(" SELECT CN0331.N_050_TELNO ")
.append(" FROM CN_T_CONT_KEI_UCWK CN0331 ")
.append(" INNER JOIN CN_T_CONT_KEI_HUKA CN0031 ")
.append(" ON CN0331.CONT_KEI_NO = CN0031.N_050APL_DAIHYO_CNKNO ")
.append(" WHERE CN0331.SYSID = ? ")
.append(" AND CN0331.GENE_ADD_DTM = ( ")
.append(" SELECT MAX(CN0331_SUB.GENE_ADD_DTM) ")
.append(" FROM CN_T_CONT_KEI_UCWK CN0331_SUB ")
.append(" WHERE CN0331_SUB.CONT_KEI_UCWK_NO = CN0331.CONT_KEI_UCWK_NO ")
.append(" AND CN0331_SUB.SYSID = CN0331.SYSID ")
.append(" AND CN0331_SUB.MK_FLG = '0' ")
.append(" ) ")
.append(" AND CN0331.MK_FLG = '0' ")
.append(" AND CN0031.CONT_KEI_NO = RESULT.CONT_KEI_NO ")
.append(" AND CN0031.MK_FLG = '0' ")
//v20.0.0 Mod Start
// .append(" ) AS N_050_TELNO ")
.append(" ) AS N_050_TELNO, ")
.append(" RESULT.CRECARD_YK_KIGEN, ")
// ANK-2663-00-00 MOD START
// .append(" RESULT.CRECARD_NO_AZKRI_ID ")
.append(" RESULT.CRECARD_NO_AZKRI_ID, ")
// ANK-3846-00-00 MOD START
// .append(" RESULT.SUPPLIER ")
.append(" RESULT.SUPPLIER, ")
.append(" RESULT.KSSAI_ID ")
// ANK-3846-00-00 MOD END
// ANK-2663-00-00 MOD END
//v20.0.0 Mod End
.append(" FROM ")
.append(" ( ");
// SQL文_個別部1
if ( "1".equals( inMsg.getObject(ECN0021B002CBSMsg.FUNC_CODE).toString() ) ) {
sql_Buff.append(" SELECT ")
.append(" CRECHRG01.CONT_KEI_NO AS CONT_KEI_NO, ")
.append(" CRECHRG01.CONT_KEI_NO_SEQ AS CONT_KEI_NO_SEQ, ")
.append(" CRECHRG01.CONT_KEI_TEISE_SEQ AS CONT_CHRG_TEISE_SEQ, ")
.append(" CRECHRG01.CONT_SVC_CD AS CONT_SVC_CD, ")
.append(" CNSVC01.CONT_SVC_NM AS CONT_SVC_NM, ")
.append(" CRECHRG01.CONT_CD AS CONT_CD, ")
.append(" CRECHRG01.CONT_OUT_CD AS CONT_OUT_CD, ")
.append(" KEI01.CONT_NM AS CONT_NM, ")
.append(" CRECHRG01.CONT_CAMPAIGN_ID AS CONT_CAMPAIGN_ID, ")
.append(" CRECHRG01.CONT_CAMPAIGN_NM AS CONT_CAMPAIGN_NM, ")
.append(" KEI01.CONT_PAYWAY_CD AS CONT_PAYWAY_CD, ")
.append(" CRECA03.CRECARD_COMP_CD AS CRECARD_COMP_CD, ")
.append(" CRECA03.CRECARD_COMP_ALI AS CRECARD_COMP_NM, ")
.append(" CRECA03.CRECARD_ID AS CRECARD_ID, ")
.append(" CRECA03.CRECARD_NO AS CRECARD_NO, ")
.append(" '' AS ISP_KSSAI_SVC_KEI_NO, ")
.append(" CRECHRG01.PLMIN_DIV AS PLMIN_DIV, ")
.append(" CRECHRG01.CHRG_AMNT AS CHRG_AMNT, ")
.append(" CRECHRG01.CONT_TANKA AS CONT_TANKA, ")
.append(" KEI01.TAXAREA AS TAXAREA, ")
.append(" CRECHRG01.TAX_RT AS TAX_RT, ")
.append(" CRECHRG01.CONT_BUY_CNT AS CONT_BUY_CNT, ")
.append(" '' AS CONTCHRGTESEI_DIV, ")
.append(" '' AS CONTCHRGTESEI_DIV_NM, ")
.append(" NULL AS SALES_GEN_AMNT, ")
.append(" NULL AS COMPENSATION, ")
.append(" '1' AS RECORD_KBN, ")
.append(" CRECHRG01.CHRG_STAT_CD AS CHRG_STAT_CD, ")
//v20.0.0 Mod Start
// .append(" '' AS SEIKY_KEI_NO ")
.append(" '' AS SEIKY_KEI_NO, ")
.append(" CRECA03.CRECARD_YK_KIGEN AS CRECARD_YK_KIGEN, ")
// ANK-2663-00-00 MOD START
// .append(" CRECA03.CRECARD_NO_AZKRI_ID AS CRECARD_NO_AZKRI_ID ")
.append(" CRECA03.CRECARD_NO_AZKRI_ID AS CRECARD_NO_AZKRI_ID, ")
// ANK-3846-00-00 MOD START
// .append(" KEI01.SUPPLIER AS SUPPLIER ")
.append(" KEI01.SUPPLIER AS SUPPLIER, ")
.append(" CRECA03.KSSAI_ID AS KSSAI_ID ")
// ANK-3846-00-00 MOD END
// ANK-2663-00-00 MOD END
//v20.0.0 Mod End
.append(" FROM ( ")
.append(" SELECT ")
.append(" CRECHRG02.CONT_KEI_NO AS CONT_KEI_NO, ")
.append(" CRECHRG02.CONT_KEI_NO_SEQ AS CONT_KEI_NO_SEQ, ")
.append(" MAX(CRECHRG02.CONT_KEI_TEISE_SEQ) CONT_KEI_TEISE_SEQ ")
.append(" FROM ")
.append(" CN_T_CONT_CRECA_CHRG CRECHRG02 ")
.append(" WHERE ")
.append(" CRECHRG02.SYSID = ? AND ")
.append(" CRECHRG02.CHRG_TRGT_YM = ? AND ")
.append(" CRECHRG02.CONT_CRECARD_CHRG_STAT = '001' AND ")
.append(" CRECHRG02.MK_FLG = '0' ")
.append(" GROUP BY ")
.append(" CONT_KEI_NO, ")
.append(" CONT_KEI_NO_SEQ ")
.append(" ) CRECAMAX01 ")
.append(" INNER JOIN CN_T_CONT_CRECA_CHRG CRECHRG01 ")
.append(" ON (CRECHRG01.SYSID = ? AND ")
.append(" CRECHRG01.CHRG_TRGT_YM = ? AND ")
.append(" CRECHRG01.CONT_CRECARD_CHRG_STAT = '001' AND ")
.append(" CRECHRG01.CONT_KEI_NO = CRECAMAX01.CONT_KEI_NO AND ")
.append(" CRECHRG01.CONT_KEI_NO_SEQ = CRECAMAX01.CONT_KEI_NO_SEQ AND ")
.append(" CRECHRG01.CONT_KEI_TEISE_SEQ = CRECAMAX01.CONT_KEI_TEISE_SEQ AND ")
.append(" CRECHRG01.MK_FLG = '0') ")
.append(" INNER JOIN CN_T_CONT_KEI KEI01 ")
.append(" ON (KEI01.CONT_KEI_NO = CRECHRG01.CONT_KEI_NO AND ")
.append(" KEI01.MK_FLG = '0') ")
.append(" LEFT OUTER JOIN CN_M_CONT_SVC CNSVC01 ON CRECHRG01.CONT_SVC_CD = CNSVC01.CONT_SVC_CD ")
.append(" LEFT OUTER JOIN ( ")
.append(" SELECT ")
.append(" COMP01.CRECARD_COMP_ALI, ")
.append(" COMP01.CRECARD_COMP_CD, ")
.append(" CRECA04.CRECARD_NO, ")
//v20.0.0 Mod Start
// .append(" CRECA04.CRECARD_ID ")
.append(" CRECA04.CRECARD_ID, ")
.append(" CRECA04.CRECARD_YK_KIGEN, ")
// ANK-3846-00-00 MOD START
// .append(" CRECA04.CRECARD_NO_AZKRI_ID ")
.append(" CRECA04.CRECARD_NO_AZKRI_ID, ")
.append(" CRECA04.KSSAI_ID ")
// ANK-3846-00-00 MOD END
//v20.0.0 Mod End
.append(" FROM ")
.append(" KK_M_CRECARD_COMP COMP01, ")
.append(" ( ")
.append(" SELECT ")
.append(" CRECA02.CRECARD_NO AS CRECARD_NO, ")
.append(" CRECA02.CRECARD_ID AS CRECARD_ID, ")
.append(" CRECA02.CRECARD_JIGYO_CD AS CRECARD_JIGYO_CD, ")
.append(" CRECA02.CRECARD_COMP_CD AS CRECARD_COMP_CD, ")
//v20.0.0 Mod Start
// .append(" CRECA02.CHRG_TRGT_YM AS CHRG_TRGT_YM ")
.append(" CRECA02.CHRG_TRGT_YM AS CHRG_TRGT_YM, ")
.append(" CRECA02.CRECARD_YK_KIGEN AS CRECARD_YK_KIGEN, ")
// ANK-3846-00-00 MOD START
// .append(" CRECA02.CRECARD_NO_AZKRI_ID AS CRECARD_NO_AZKRI_ID ")
.append(" CRECA02.CRECARD_NO_AZKRI_ID AS CRECARD_NO_AZKRI_ID, ")
// IT2-2022-0000006 MOD START
// .append(" CRECA02.KSSAI_ID AS KSSAI_ID ")
.append(" CRECA12.KSSAI_ID AS KSSAI_ID ")
// IT2-2022-0000006 MOD END
// ANK-3846-00-00 MOD END
//v20.0.0 Mod End
.append(" FROM CN_T_CONTJIGYO_CRECA CRECA02 ")
.append(" INNER JOIN ( ")
.append(" SELECT ")
.append(" CRECA01.CRECARD_ID AS CRECARD_ID, ")
.append(" MAX(CRECA01.CHRG_TRGT_YM) AS CHRG_TRGT_YM ")
.append(" FROM ")
.append(" CN_T_CONTJIGYO_CRECA CRECA01 ")
.append(" WHERE ")
.append(" CRECA01.CHRG_TRGT_YM <= ? ")
.append(" GROUP BY ")
.append(" CRECARD_ID) CRECA ")
.append(" ON CRECA.CRECARD_ID = CRECA02.CRECARD_ID AND CRECA02.CHRG_TRGT_YM = CRECA.CHRG_TRGT_YM ")
// IT2-2022-0000006 ADD START
.append(" INNER JOIN ( ")
.append(" SELECT ")
.append(" CRECA11.CRECARD_ID AS CRECARD_ID, ")
.append(" CRECA11.KSSAI_ID AS KSSAI_ID ")
.append(" FROM ")
.append(" CN_T_CONTJIGYO_CRECA CRECA11 ")
.append(" WHERE ")
.append(" CRECA11.CHRG_TRGT_YM = ? ")
.append(" GROUP BY ")
.append(" CRECARD_ID ")
.append(" ,KSSAI_ID ")
.append(" ) CRECA12 ")
.append(" ON CRECA12.CRECARD_ID = CRECA02.CRECARD_ID ")
// IT2-2022-0000006 ADD END
.append(" ) CRECA04 ")
.append(" WHERE ")
.append(" CRECA04.CRECARD_JIGYO_CD = COMP01.CRECARD_JIGYO_CD AND ")
.append(" CRECA04.CRECARD_COMP_CD = COMP01.CRECARD_COMP_CD ")
.append(" ) CRECA03 ")
.append(" ON CRECA03.CRECARD_ID = CRECHRG01.CRECARD_ID ")
.append(" UNION ALL ")
.append(" SELECT ")
.append(" ISPCHRG01.CONT_KEI_NO AS CONT_KEI_NO, ")
.append(" ISPCHRG01.CONT_KEI_NO_SEQ AS CONT_KEI_NO_SEQ, ")
.append(" ISPCHRG01.CONT_KEI_TEISE_SEQ AS CONT_CHRG_TEISE_SEQ, ")
.append(" ISPCHRG01.CONT_SVC_CD AS CONT_SVC_CD, ")
.append(" CNSVC02.CONT_SVC_NM AS CONT_SVC_NM, ")
.append(" ISPCHRG01.CONT_CD AS CONT_CD, ")
.append(" ISPCHRG01.CONT_OUT_CD AS CONT_OUT_CD, ")
.append(" KEI02.CONT_NM AS CONT_NM, ")
.append(" ISPCHRG01.CONT_CAMPAIGN_ID AS CONT_CAMPAIGN_ID, ")
.append(" ISPCHRG01.CONT_CAMPAIGN_NM AS CONT_CAMPAIGN_NM, ")
.append(" KEI02.CONT_PAYWAY_CD AS CONT_PAYWAY_CD, ")
.append(" '' AS CRECARD_COMP_CD, ")
.append(" '' AS CRECARD_COMP_NM, ")
.append(" '' AS CRECARD_ID, ")
.append(" '' AS CRECARD_NO, ")
.append(" ISPCHRG01.ISP_KSSAI_SVC_KEI_NO AS ISP_KSSAI_SVC_KEI_NO, ")
.append(" ISPCHRG01.PLMIN_DIV AS PLMIN_DIV, ")
.append(" ISPCHRG01.CHRG_AMNT AS CHRG_AMNT, ")
.append(" ISPCHRG01.CONT_TANKA AS CONT_TANKA, ")
.append(" KEI02.TAXAREA AS TAXAREA, ")
.append(" ISPCHRG01.TAX_RT AS TAX_RT, ")
.append(" ISPCHRG01.CONT_BUY_CNT AS CONT_BUY_CNT, ")
.append(" '' AS CONTCHRGTESEI_DIV, ")
.append(" '' AS CONTCHRGTESEI_DIV_NM, ")
.append(" NULL AS SALES_GEN_AMNT, ")
.append(" NULL AS COMPENSATION, ")
.append(" '1' AS RECORD_KBN, ")
.append(" ISPCHRG01.CHRG_STAT_CD AS CHRG_STAT_CD, ")
//v20.0.0 Mod Start
// .append(" KAKINS.SEIKY_KEI_NO AS SEIKY_KEI_NO ")
.append(" KAKINS.SEIKY_KEI_NO AS SEIKY_KEI_NO, ")
.append(" '' AS CRECARD_YK_KIGEN, ")
// ANK-2663-00-00 MOD START
// .append(" '' AS CRECARD_NO_AZKRI_ID ")
.append(" '' AS CRECARD_NO_AZKRI_ID, ")
// ANK-3846-00-00 MOD START
// .append(" KEI02.SUPPLIER AS SUPPLIER ")
.append(" KEI02.SUPPLIER AS SUPPLIER, ")
.append(" '' AS KSSAI_ID ")
// ANK-3846-00-00 MOD END
// ANK-2663-00-00 MOD END
//v20.0.0 Mod End
.append(" FROM( ")
.append(" SELECT ")
.append(" ISPCHRG02.CONT_KEI_NO AS CONT_KEI_NO, ")
.append(" ISPCHRG02.CONT_KEI_NO_SEQ AS CONT_KEI_NO_SEQ, ")
.append(" MAX(ISPCHRG02.CONT_KEI_TEISE_SEQ) CONT_KEI_TEISE_SEQ ")
.append(" FROM ")
.append(" CN_T_CONT_ISP_CHRG ISPCHRG02 ")
.append(" WHERE ")
.append(" ISPCHRG02.SYSID = ? AND ")
.append(" ISPCHRG02.CHRG_TRGT_YM = ? AND ")
.append(" ISPCHRG02.CONT_ISP_CHRG_STAT = '001' AND ")
.append(" ISPCHRG02.MK_FLG = '0' ")
.append(" GROUP BY ")
.append(" CONT_KEI_NO, ")
.append(" CONT_KEI_NO_SEQ ")
.append(" ) ISPMAX01 ")
.append(" INNER JOIN CN_T_CONT_ISP_CHRG ISPCHRG01 ")
.append(" ON (ISPCHRG01.SYSID = ? AND ")
.append(" ISPCHRG01.CHRG_TRGT_YM = ? AND ")
.append(" ISPCHRG01.CONT_ISP_CHRG_STAT = '001' AND ")
.append(" ISPCHRG01.CONT_KEI_NO = ISPMAX01.CONT_KEI_NO AND ")
.append(" ISPCHRG01.CONT_KEI_NO_SEQ = ISPMAX01.CONT_KEI_NO_SEQ AND ")
.append(" ISPCHRG01.CONT_KEI_TEISE_SEQ = ISPMAX01.CONT_KEI_TEISE_SEQ AND ")
.append(" ISPCHRG01.MK_FLG = '0') ")
.append(" INNER JOIN CN_T_CONT_KEI KEI02 ")
.append(" ON (KEI02.CONT_KEI_NO = ISPCHRG01 .CONT_KEI_NO) ")
.append(" LEFT OUTER JOIN CN_M_CONT_SVC CNSVC02 ON ISPCHRG01.CONT_SVC_CD = CNSVC02.CONT_SVC_CD ")
.append(" LEFT OUTER JOIN KK_T_KAKINS KAKINS ")
.append(" ON (KAKINS.SVC_KEI_NO = KEI02.ISP_KSSAI_SVC_KEI_NO AND ")
.append(" KAKINS.KAKINS_TSTAYMD <= ? AND ")
.append(" KAKINS.KAKINS_TENDYMD >= ? AND ")
.append(" KAKINS.MK_FLG = '0' AND ")
.append(" KEI02.MK_FLG = '0') ")
.append(" UNION ALL ")
.append(" SELECT ")
.append(" TESEI01.CONT_KEI_NO AS CONT_KEI_NO, ")
.append(" TESEI01.CONT_KEI_NO_SEQ AS CONT_KEI_NO_SEQ, ")
.append(" TESEI01.CONT_CHRG_TEISE_SEQ AS CONT_CHRG_TEISE_SEQ, ")
.append(" TESEI01.CONT_SVC_CD AS CONT_SVC_CD, ")
.append(" CNSVC03.CONT_SVC_NM AS CONT_SVC_NM, ")
.append(" TESEI01.CONT_CD AS CONT_CD, ")
.append(" TESEI01.CONT_OUT_CD AS CONT_OUT_CD, ")
.append(" KEI03.CONT_NM AS CONT_NM, ")
.append(" '' AS CONT_CAMPAIGN_ID, ")
.append(" '' AS CONT_CAMPAIGN_NM, ")
.append(" TESEI01.CONT_PAYWAY_CD AS CONT_PAYWAY_CD, ")
.append(" CRECA07.CRECARD_COMP_CD AS CRECARD_COMP_CD, ")
.append(" CRECA07.CRECARD_COMP_ALI AS CRECARD_COMP_NM, ")
.append(" TESEI01.CRECARD_ID AS CRECARD_ID, ")
.append(" CRECA07.CRECARD_NO AS CRECARD_NO, ")
.append(" '' AS ISP_KSSAI_SVC_KEI_NO, ")
.append(" TESEI01.PLMIN_DIV AS PLMIN_DIV, ")
.append(" NULL AS CHRG_AMNT, ")
.append(" NULL AS CONT_TANKA, ")
.append(" KEI03.TAXAREA AS TAXAREA, ")
.append(" TESEI01.CHRG_JTN_TAX_RT AS TAX_RT, ")
.append(" NULL AS CONT_BUY_CNT, ")
.append(" TESEI01.CONTCHRGTESEI_DIV AS CONTCHRGTESEI_DIV, ")
.append(" KANRI01.CD_DIV_NM AS CONTCHRGTESEI_DIV_NM, ")
.append(" TESEI01_SUM.SALES_GEN_AMNT AS SALES_GEN_AMNT, ")
.append(" TESEI01_SUM.COMPENSATION AS COMPENSATION, ")
.append(" '2' AS RECORD_KBN, ")
.append(" CRECHRG04.CHRG_STAT_CD AS CHRG_STAT_CD, ")
//v20.0.0 Mod Start
// .append(" '' AS SEIKY_KEI_NO ")
.append(" '' AS SEIKY_KEI_NO, ")
.append(" CRECA07.CRECARD_YK_KIGEN AS CRECARD_YK_KIGEN, ")
// ANK-2663-00-00 MOD START
// .append(" CRECA07.CRECARD_NO_AZKRI_ID AS CRECARD_NO_AZKRI_ID ")
.append(" CRECA07.CRECARD_NO_AZKRI_ID AS CRECARD_NO_AZKRI_ID, ")
// ANK-3846-00-00 MOD START
// .append(" KEI03.SUPPLIER AS SUPPLIER ")
.append(" KEI03.SUPPLIER AS SUPPLIER, ")
.append(" CRECA07.KSSAI_ID AS KSSAI_ID ")
// ANK-3846-00-00 MOD END
// ANK-2663-00-00 MOD END
//v20.0.0 Mod End
.append(" FROM ( ")
.append(" SELECT ")
.append(" CRECHRG03.CONT_KEI_NO AS CONT_KEI_NO, ")
.append(" CRECHRG03.CONT_KEI_NO_SEQ AS CONT_KEI_NO_SEQ, ")
.append(" MAX(CRECHRG03.CONT_KEI_TEISE_SEQ) CONT_KEI_TEISE_SEQ ")
.append(" FROM ")
.append(" CN_T_CONT_CRECA_CHRG CRECHRG03 ")
.append(" WHERE ")
.append(" CRECHRG03.SYSID = ? AND ")
.append(" CRECHRG03.CHRG_TRGT_YM = ? AND ")
.append(" CRECHRG03.CONT_CRECARD_CHRG_STAT = '001' AND ")
.append(" CRECHRG03.MK_FLG = '0' ")
.append(" GROUP BY ")
.append(" CONT_KEI_NO, ")
.append(" CONT_KEI_NO_SEQ ")
.append(" ) CRECAMAX02 ")
.append(" INNER JOIN CN_T_CONT_CRECA_CHRG CRECHRG04 ")
.append(" ON (CRECHRG04.SYSID = ? AND ")
.append(" CRECHRG04.CHRG_TRGT_YM = ? AND ")
.append(" CRECHRG04.CONT_CRECARD_CHRG_STAT = '001' AND ")
.append(" CRECHRG04.CONT_KEI_NO = CRECAMAX02.CONT_KEI_NO AND ")
.append(" CRECHRG04.CONT_KEI_NO_SEQ = CRECAMAX02.CONT_KEI_NO_SEQ AND ")
.append(" CRECHRG04.CONT_KEI_TEISE_SEQ = CRECAMAX02.CONT_KEI_TEISE_SEQ AND ")
.append(" CRECHRG04.MK_FLG = '0') ")
.append(" INNER JOIN CN_T_CONT_KEI KEI03 ")
.append(" ON (KEI03.CONT_KEI_NO = CRECHRG04.CONT_KEI_NO AND ")
.append(" KEI03.MK_FLG = '0') ")
.append(" INNER JOIN ( ")
.append(" SELECT ")
.append(" TESEI02.CONT_KEI_NO AS CONT_KEI_NO, ")
.append(" TESEI02.CONT_KEI_NO_SEQ AS CONT_KEI_NO_SEQ, ")
.append(" TESEI02.CHRG_JTN_TAX_RT AS CHRG_JTN_TAX_RT, ")
.append(" SUM(TESEI02.SALES_GEN_AMNT) AS SALES_GEN_AMNT, ")
.append(" SUM(TESEI02.COMPENSATION) AS COMPENSATION, ")
.append(" MAX(TESEI02.CONT_CHRG_TEISE_SEQ) AS CONT_CHRG_TEISE_SEQ ")
.append(" FROM ")
.append(" CN_T_CONTCHRGTESEI TESEI02 ")
.append(" WHERE ")
.append(" TESEI02.SYSID = ? AND ")
.append(" SUBSTR(TESEI02.CHRG_TEISE_YMD, 1, 6) = ? AND ")
.append(" TESEI02.CONTCHRGTESEI_STAT ='001' AND ")
.append(" TESEI02.MK_FLG = '0' ")
.append(" GROUP BY ")
.append(" TESEI02.CONT_KEI_NO, ")
.append(" TESEI02.CONT_KEI_NO_SEQ, ")
.append(" TESEI02.CHRG_JTN_TAX_RT ")
.append(" ) TESEI01_SUM ")
.append(" ON (TESEI01_SUM.CONT_KEI_NO = CRECHRG04.CONT_KEI_NO AND ")
.append(" TESEI01_SUM.CONT_KEI_NO_SEQ = CRECHRG04.CONT_KEI_NO_SEQ) ")
.append(" INNER JOIN CN_T_CONTCHRGTESEI TESEI01 ")
.append(" ON (TESEI01.CONT_KEI_NO = TESEI01_SUM.CONT_KEI_NO AND ")
.append(" TESEI01.CONT_KEI_NO_SEQ = TESEI01_SUM.CONT_KEI_NO_SEQ AND ")
.append(" TESEI01.CONT_CHRG_TEISE_SEQ = TESEI01_SUM.CONT_CHRG_TEISE_SEQ) ")
.append(" LEFT OUTER JOIN CN_M_CONT_SVC CNSVC03 ON TESEI01.CONT_SVC_CD = CNSVC03.CONT_SVC_CD ")
.append(" LEFT OUTER JOIN ( ")
.append(" SELECT ")
.append(" COMP02.CRECARD_COMP_ALI, ")
.append(" COMP02.CRECARD_COMP_CD, ")
.append(" CRECA08.CRECARD_NO, ")
//v20.0.0 Mod Start
// .append(" CRECA08.CRECARD_ID ")
.append(" CRECA08.CRECARD_ID, ")
.append(" CRECA08.CRECARD_YK_KIGEN, ")
// ANK-3846-00-00 MOD START
// .append(" CRECA08.CRECARD_NO_AZKRI_ID ")
.append(" CRECA08.CRECARD_NO_AZKRI_ID, ")
.append(" CRECA08.KSSAI_ID ")
// ANK-3846-00-00 MOD END
//v20.0.0 Mod End
.append(" FROM ")
.append(" KK_M_CRECARD_COMP COMP02, ")
.append(" ( ")
.append(" SELECT ")
.append(" CRECA06.CRECARD_NO AS CRECARD_NO, ")
.append(" CRECA06.CRECARD_ID AS CRECARD_ID, ")
.append(" CRECA06.CRECARD_JIGYO_CD AS CRECARD_JIGYO_CD, ")
.append(" CRECA06.CRECARD_COMP_CD AS CRECARD_COMP_CD, ")
//v20.0.0 Mod Start
// .append(" CRECA06.CHRG_TRGT_YM AS CHRG_TRGT_YM ")
.append(" CRECA06.CHRG_TRGT_YM AS CHRG_TRGT_YM, ")
.append(" CRECA06.CRECARD_YK_KIGEN AS CRECARD_YK_KIGEN, ")
// ANK-3846-00-00 MOD START
// .append(" CRECA06.CRECARD_NO_AZKRI_ID AS CRECARD_NO_AZKRI_ID ")
.append(" CRECA06.CRECARD_NO_AZKRI_ID AS CRECARD_NO_AZKRI_ID, ")
// IT2-2022-0000006 ADD START
// .append(" CRECA06.KSSAI_ID AS KSSAI_ID ")
.append(" CRECA13.KSSAI_ID AS KSSAI_ID ")
// IT2-2022-0000006 ADD START
// ANK-3846-00-00 MOD END
//v20.0.0 Mod End
.append(" FROM CN_T_CONTJIGYO_CRECA CRECA06 ")
.append(" INNER JOIN ( ")
.append(" SELECT ")
.append(" CRECA05.CRECARD_ID AS CRECARD_ID, ")
.append(" MAX(CRECA05.CHRG_TRGT_YM) AS CHRG_TRGT_YM ")
.append(" FROM ")
.append(" CN_T_CONTJIGYO_CRECA CRECA05 ")
.append(" WHERE ")
.append(" CRECA05.CHRG_TRGT_YM <= ? ")
.append(" GROUP BY ")
.append(" CRECARD_ID) CRECA ")
.append(" ON CRECA.CRECARD_ID = CRECA06.CRECARD_ID AND CRECA06.CHRG_TRGT_YM = CRECA.CHRG_TRGT_YM ")
// IT2-2022-0000006 ADD START
.append(" INNER JOIN ( ")
.append(" SELECT ")
.append(" CRECA15.CRECARD_ID AS CRECARD_ID, ")
.append(" CRECA15.KSSAI_ID AS KSSAI_ID ")
.append(" FROM ")
.append(" CN_T_CONTJIGYO_CRECA CRECA15 ")
.append(" WHERE ")
.append(" CRECA15.CHRG_TRGT_YM = ? ")
.append(" GROUP BY ")
.append(" CRECARD_ID ")
.append(" ,KSSAI_ID ")
.append(" ) CRECA13 ")
.append(" ON CRECA13.CRECARD_ID = CRECA06.CRECARD_ID ")
// IT2-2022-0000006 ADD END
.append(" ) CRECA08 ")
.append(" WHERE ")
.append(" CRECA08.CRECARD_JIGYO_CD = COMP02.CRECARD_JIGYO_CD AND ")
.append(" CRECA08.CRECARD_COMP_CD = COMP02.CRECARD_COMP_CD ")
.append(" ) CRECA07 ")
.append(" ON CRECA07.CRECARD_ID = TESEI01.CRECARD_ID ")
.append(" LEFT OUTER JOIN ZM_M_CD_NM_KANRI KANRI01 ")
.append(" ON (KANRI01.CD_DIV = TESEI01.CONTCHRGTESEI_DIV AND ")
.append(" KANRI01.CD_SBT_CD = 'CD00510' AND ")
.append(" KANRI01.MK_FLG = '0') ")
.append(" UNION ALL ")
.append(" SELECT ")
.append(" TESEI03.CONT_KEI_NO AS CONT_KEI_NO, ")
.append(" TESEI03.CONT_KEI_NO_SEQ AS CONT_KEI_NO_SEQ, ")
.append(" TESEI03.CONT_CHRG_TEISE_SEQ AS CONT_CHRG_TEISE_SEQ, ")
.append(" TESEI03.CONT_SVC_CD AS CONT_SVC_CD, ")
.append(" CNSVC04.CONT_SVC_NM AS CONT_SVC_NM, ")
.append(" TESEI03.CONT_CD AS CONT_CD, ")
.append(" TESEI03.CONT_OUT_CD AS CONT_OUT_CD, ")
.append(" KEI04.CONT_NM AS CONT_NM, ")
.append(" '' AS CONT_CAMPAIGN_ID, ")
.append(" '' AS CONT_CAMPAIGN_NM, ")
.append(" TESEI03.CONT_PAYWAY_CD AS CONT_PAYWAY_CD, ")
.append(" '' AS CRECARD_COMP_CD, ")
.append(" '' AS CRECARD_COMP_NM, ")
.append(" '' AS CRECARD_ID, ")
.append(" '' AS CRECARD_NO, ")
.append(" TESEI03.ISP_KSSAI_SVC_KEI_NO AS ISP_KSSAI_SVC_KEI_NO, ")
.append(" TESEI03.PLMIN_DIV AS PLMIN_DIV, ")
.append(" NULL AS CHRG_AMNT, ")
.append(" NULL AS CONT_TANKA, ")
.append(" KEI04.TAXAREA AS TAXAREA, ")
.append(" TESEI03.CHRG_JTN_TAX_RT AS TAX_RT, ")
.append(" NULL AS CONT_BUY_CNT, ")
.append(" TESEI03.CONTCHRGTESEI_DIV AS CONTCHRGTESEI_DIV, ")
.append(" KANRI02.CD_DIV_NM AS CONTCHRGTESEI_DIV_NM, ")
.append(" TESEI03_SUM.SALES_GEN_AMNT AS SALES_GEN_AMNT, ")
.append(" TESEI03_SUM.COMPENSATION AS COMPENSATION, ")
.append(" '2' AS RECORD_KBN, ")
.append(" ISPCHRG02.CHRG_STAT_CD AS CHRG_STAT_CD, ")
//v20.0.0 Mod Start
// .append(" '' AS SEIKY_KEI_NO ")
.append(" '' AS SEIKY_KEI_NO, ")
.append(" '' AS CRECARD_YK_KIGEN, ")
// ANK-2663-00-00 MOD START
// .append(" '' AS CRECARD_NO_AZKRI_ID ")
.append(" '' AS CRECARD_NO_AZKRI_ID, ")
// ANK-3846-00-00 MOD START
// .append(" KEI04.SUPPLIER AS SUPPLIER ")
.append(" KEI04.SUPPLIER AS SUPPLIER, ")
.append(" '' AS KSSAI_ID ")
// ANK-3846-00-00 MOD END
// ANK-2663-00-00 MOD END
//v20.0.0 Mod End
.append(" FROM ( ")
.append(" SELECT ")
.append(" ISPCHRG03.CONT_KEI_NO AS CONT_KEI_NO, ")
.append(" ISPCHRG03.CONT_KEI_NO_SEQ AS CONT_KEI_NO_SEQ, ")
.append(" MAX(ISPCHRG03.CONT_KEI_TEISE_SEQ) CONT_KEI_TEISE_SEQ ")
.append(" FROM ")
.append(" CN_T_CONT_ISP_CHRG ISPCHRG03 ")
.append(" WHERE ")
.append(" ISPCHRG03.SYSID = ? AND ")
.append(" ISPCHRG03.CHRG_TRGT_YM = ? AND ")
.append(" ISPCHRG03.CONT_ISP_CHRG_STAT = '001' AND ")
.append(" ISPCHRG03.MK_FLG = '0' ")
.append(" GROUP BY ")
.append(" CONT_KEI_NO, ")
.append(" CONT_KEI_NO_SEQ ")
.append(" ) CRECAMAX02 ")
.append(" INNER JOIN CN_T_CONT_ISP_CHRG ISPCHRG02 ")
.append(" ON (ISPCHRG02.SYSID = ? AND ")
.append(" ISPCHRG02.CHRG_TRGT_YM = ? AND ")
.append(" ISPCHRG02.CONT_ISP_CHRG_STAT = '001' AND ")
.append(" ISPCHRG02.CONT_KEI_NO = CRECAMAX02.CONT_KEI_NO AND ")
.append(" ISPCHRG02.CONT_KEI_NO_SEQ = CRECAMAX02.CONT_KEI_NO_SEQ AND ")
.append(" ISPCHRG02.CONT_KEI_TEISE_SEQ = CRECAMAX02.CONT_KEI_TEISE_SEQ AND ")
.append(" ISPCHRG02.MK_FLG = '0') ")
.append(" INNER JOIN CN_T_CONT_KEI KEI04 ")
.append(" ON (KEI04.CONT_KEI_NO = ISPCHRG02.CONT_KEI_NO AND ")
.append(" KEI04.MK_FLG = '0') ")
.append(" INNER JOIN ( ")
.append(" SELECT ")
.append(" TESEI04.CONT_KEI_NO AS CONT_KEI_NO, ")
.append(" TESEI04.CONT_KEI_NO_SEQ AS CONT_KEI_NO_SEQ, ")
.append(" TESEI04.CHRG_JTN_TAX_RT AS CHRG_JTN_TAX_RT, ")
.append(" SUM(TESEI04.SALES_GEN_AMNT) AS SALES_GEN_AMNT, ")
.append(" SUM(TESEI04.COMPENSATION) AS COMPENSATION, ")
.append(" MAX(TESEI04.CONT_CHRG_TEISE_SEQ) AS CONT_CHRG_TEISE_SEQ ")
.append(" FROM ")
.append(" CN_T_CONTCHRGTESEI TESEI04 ")
.append(" WHERE ")
.append(" TESEI04.SYSID = ? AND ")
.append(" SUBSTR(TESEI04.CHRG_TEISE_YMD, 1, 6) = ? AND ")
.append(" TESEI04.CONTCHRGTESEI_STAT ='001' AND ")
.append(" TESEI04.MK_FLG = '0' ")
.append(" GROUP BY ")
.append(" TESEI04.CONT_KEI_NO, ")
.append(" TESEI04.CONT_KEI_NO_SEQ, ")
.append(" TESEI04.CHRG_JTN_TAX_RT ")
.append(" ) TESEI03_SUM ")
.append(" ON (TESEI03_SUM.CONT_KEI_NO = ISPCHRG02.CONT_KEI_NO AND ")
.append(" TESEI03_SUM.CONT_KEI_NO_SEQ = ISPCHRG02.CONT_KEI_NO_SEQ) ")
.append(" INNER JOIN CN_T_CONTCHRGTESEI TESEI03 ")
.append(" ON (TESEI03.CONT_KEI_NO = TESEI03_SUM.CONT_KEI_NO AND ")
.append(" TESEI03.CONT_KEI_NO_SEQ = TESEI03_SUM.CONT_KEI_NO_SEQ AND ")
.append(" TESEI03.CONT_CHRG_TEISE_SEQ = TESEI03_SUM.CONT_CHRG_TEISE_SEQ) ")
.append(" LEFT OUTER JOIN CN_M_CONT_SVC CNSVC04 ON TESEI03.CONT_SVC_CD = CNSVC04.CONT_SVC_CD ")
.append(" LEFT OUTER JOIN ZM_M_CD_NM_KANRI KANRI02 ")
.append(" ON (KANRI02.CD_DIV = TESEI03.CONTCHRGTESEI_DIV AND ")
.append(" KANRI02.CD_SBT_CD = 'CD00510' AND ")
.append(" KANRI02.MK_FLG = '0') ")
.append(" )RESULT ")
.append(" ORDER BY ")
.append(" RESULT.ISP_KSSAI_SVC_KEI_NO, ")
.append(" TO_NUMBER(RESULT.CRECARD_COMP_CD), ")
.append(" RESULT.CRECARD_NO, ")
.append(" TO_NUMBER(RESULT.CONT_SVC_CD), ")
.append(" TO_NUMBER(RESULT.CONT_CD), ")
.append(" TO_NUMBER(RESULT.CONT_KEI_NO), ")
.append(" TO_NUMBER(RESULT.RECORD_KBN) ");
}
//prepareStatementにSQL文をセット
pstmt = con1.prepareStatement(sql_Buff.toString());
//ログ出力(SQL文の出力)
JSYejbLog.outlog(inContext, JSYejbLog.DBACCESS, this.getClass(), sql_Buff);
// PreparedStatementの指定されたパラメータカラムに 指定された値を設定
int index = 1;
// パラメータの設定(ＫＥＹ＿ＳＹＳＩＤを指定)
CAANJDBCUtil.setParam(pstmt, index++, inMsg.getObject(ECN0021B002CBSMsg.KEY_SYSID));
if ( "1".equals( inMsg.getString(ECN0021B002CBSMsg.FUNC_CODE) ) ) {
// パラメータの設定(ＫＥＹ＿ＳＹＳＩＤを指定)
CAANJDBCUtil.setParam(pstmt, index++, inMsg.getObject(ECN0021B002CBSMsg.KEY_SYSID));
// パラメータの設定(ＫＥＹ＿課金対象年月を指定)
CAANJDBCUtil.setParam(pstmt, index++, inMsg.getObject(ECN0021B002CBSMsg.KEY_CHRG_TRGT_YM));
/* ++++++++++ v1.00.00 追加開始 ++++++++++ */
// パラメータの設定(ＫＥＹ＿ＳＹＳＩＤを指定)
CAANJDBCUtil.setParam(pstmt, index++, inMsg.getObject(ECN0021B002CBSMsg.KEY_SYSID));
// パラメータの設定(ＫＥＹ＿課金対象年月を指定)
CAANJDBCUtil.setParam(pstmt, index++, inMsg.getObject(ECN0021B002CBSMsg.KEY_CHRG_TRGT_YM));
// パラメータの設定(ＫＥＹ＿運用日付(年月日)を指定)
// ST1-2012-0001018 2012/12/04 n.ajioka START
// CAANJDBCUtil.setParam(pstmt, index++, JCNModelCommon.getSysDate());
CAANJDBCUtil.setParam(pstmt, index++, JCNModelCommon.getOpeDate(inMsg));
// ST1-2012-0001018 2012/12/04 n.ajioka END
// IT2-2022-0000006 ADD START
// パラメータの設定(ＫＥＹ＿課金対象年月を指定)
CAANJDBCUtil.setParam(pstmt, index++, inMsg.getObject(ECN0021B002CBSMsg.KEY_CHRG_TRGT_YM));
// IT2-2022-0000006 ADD END
// パラメータの設定(ＫＥＹ＿ＳＹＳＩＤを指定)
CAANJDBCUtil.setParam(pstmt, index++, inMsg.getObject(ECN0021B002CBSMsg.KEY_SYSID));
// パラメータの設定(ＫＥＹ＿課金対象年月を指定)
CAANJDBCUtil.setParam(pstmt, index++, inMsg.getObject(ECN0021B002CBSMsg.KEY_CHRG_TRGT_YM));
// パラメータの設定(ＫＥＹ＿ＳＹＳＩＤを指定)
CAANJDBCUtil.setParam(pstmt, index++, inMsg.getObject(ECN0021B002CBSMsg.KEY_SYSID));
// パラメータの設定(ＫＥＹ＿課金対象年月を指定)
CAANJDBCUtil.setParam(pstmt, index++, inMsg.getObject(ECN0021B002CBSMsg.KEY_CHRG_TRGT_YM));
// パラメータの設定(ＫＥＹ＿課金対象年月を指定)
CAANJDBCUtil.setParam(pstmt, index++, inMsg.getObject(ECN0021B002CBSMsg.KEY_CHRG_TRGT_YM));
// パラメータの設定(ＫＥＹ＿課金対象年月を指定)
CAANJDBCUtil.setParam(pstmt, index++, inMsg.getObject(ECN0021B002CBSMsg.KEY_CHRG_TRGT_YM));
// パラメータの設定(ＫＥＹ＿ＳＹＳＩＤを指定)
CAANJDBCUtil.setParam(pstmt, index++, inMsg.getObject(ECN0021B002CBSMsg.KEY_SYSID));
// パラメータの設定(ＫＥＹ＿課金対象年月を指定)
CAANJDBCUtil.setParam(pstmt, index++, inMsg.getObject(ECN0021B002CBSMsg.KEY_CHRG_TRGT_YM));
// パラメータの設定(ＫＥＹ＿ＳＹＳＩＤを指定)
CAANJDBCUtil.setParam(pstmt, index++, inMsg.getObject(ECN0021B002CBSMsg.KEY_SYSID));
// パラメータの設定(ＫＥＹ＿課金対象年月を指定)
CAANJDBCUtil.setParam(pstmt, index++, inMsg.getObject(ECN0021B002CBSMsg.KEY_CHRG_TRGT_YM));
// パラメータの設定(ＫＥＹ＿ＳＹＳＩＤを指定)
CAANJDBCUtil.setParam(pstmt, index++, inMsg.getObject(ECN0021B002CBSMsg.KEY_SYSID));
// パラメータの設定(ＫＥＹ＿課金対象年月を指定)
CAANJDBCUtil.setParam(pstmt, index++, inMsg.getObject(ECN0021B002CBSMsg.KEY_CHRG_TRGT_YM));
// パラメータの設定(ＫＥＹ＿運用日付(年月日)を指定)
// ST1-2012-0001018 2012/12/04 n.ajioka START
// CAANJDBCUtil.setParam(pstmt, index++, JCNModelCommon.getSysDate());
CAANJDBCUtil.setParam(pstmt, index++, JCNModelCommon.getOpeDate(inMsg));
// ST1-2012-0001018 2012/12/04 n.ajioka END
// IT2-2022-0000006 ADD START
// パラメータの設定(ＫＥＹ＿課金対象年月を指定)
CAANJDBCUtil.setParam(pstmt, index++, inMsg.getObject(ECN0021B002CBSMsg.KEY_CHRG_TRGT_YM));
// IT2-2022-0000006 ADD END
// パラメータの設定(ＫＥＹ＿ＳＹＳＩＤを指定)
CAANJDBCUtil.setParam(pstmt, index++, inMsg.getObject(ECN0021B002CBSMsg.KEY_SYSID));
// パラメータの設定(ＫＥＹ＿課金対象年月を指定)
CAANJDBCUtil.setParam(pstmt, index++, inMsg.getObject(ECN0021B002CBSMsg.KEY_CHRG_TRGT_YM));
// パラメータの設定(ＫＥＹ＿ＳＹＳＩＤを指定)
CAANJDBCUtil.setParam(pstmt, index++, inMsg.getObject(ECN0021B002CBSMsg.KEY_SYSID));
// パラメータの設定(ＫＥＹ＿課金対象年月を指定)
CAANJDBCUtil.setParam(pstmt, index++, inMsg.getObject(ECN0021B002CBSMsg.KEY_CHRG_TRGT_YM));
// パラメータの設定(ＫＥＹ＿ＳＹＳＩＤを指定)
CAANJDBCUtil.setParam(pstmt, index++, inMsg.getObject(ECN0021B002CBSMsg.KEY_SYSID));
// パラメータの設定(ＫＥＹ＿課金対象年月を指定)
CAANJDBCUtil.setParam(pstmt, index++, inMsg.getObject(ECN0021B002CBSMsg.KEY_CHRG_TRGT_YM));
/* ++++++++++ v1.00.00 追加終了 ++++++++++ */
}
// ResultSetの取得
rsltQuery = pstmt.executeQuery();
// ECN0021B002CBSMsgの明細にセットする項目
String[] msgKeyList1 = {
ECN0021B002CBSMsg1List.CONT_KEI_NO
, ECN0021B002CBSMsg1List.CONT_KEI_NO_SEQ
, ECN0021B002CBSMsg1List.CONT_CHRG_TEISE_SEQ
, ECN0021B002CBSMsg1List.CONT_SVC_CD
, ECN0021B002CBSMsg1List.CONT_SVC_NM
, ECN0021B002CBSMsg1List.CONT_CD
, ECN0021B002CBSMsg1List.CONT_OUT_CD
, ECN0021B002CBSMsg1List.CONT_NM
, ECN0021B002CBSMsg1List.CONT_CAMPAIGN_ID
, ECN0021B002CBSMsg1List.CONT_CAMPAIGN_NM
, ECN0021B002CBSMsg1List.CONT_PAYWAY_CD
, ECN0021B002CBSMsg1List.CRECARD_COMP_CD
, ECN0021B002CBSMsg1List.CRECARD_COMP_NM
, ECN0021B002CBSMsg1List.CRECARD_ID
, ECN0021B002CBSMsg1List.CRECARD_NO
, ECN0021B002CBSMsg1List.ISP_KSSAI_SVC_KEI_NO
, ECN0021B002CBSMsg1List.PLMIN_DIV
, ECN0021B002CBSMsg1List.CHRG_AMNT
, ECN0021B002CBSMsg1List.CONT_TANKA
, ECN0021B002CBSMsg1List.TAXAREA
, ECN0021B002CBSMsg1List.TAX_RT
, ECN0021B002CBSMsg1List.CONT_BUY_CNT
, ECN0021B002CBSMsg1List.CONTCHRGTESEI_DIV
, ECN0021B002CBSMsg1List.CONTCHRGTESEI_DIV_NM
, ECN0021B002CBSMsg1List.SALES_GEN_AMNT
, ECN0021B002CBSMsg1List.COMPENSATION
, ECN0021B002CBSMsg1List.RECORD_KBN
, ECN0021B002CBSMsg1List.CHRG_STAT_CD
, ECN0021B002CBSMsg1List.SEIKY_KEI_NO
, ECN0021B002CBSMsg1List.N_050_TELNO
//v20.0.0 Add Start
, ECN0021B002CBSMsg1List.CRECARD_YK_KIGEN
, ECN0021B002CBSMsg1List.CRECARD_NO_AZKRI_ID
//v20.0.0 Add End
// ANK-2663-00-00 ADD START
, ECN0021B002CBSMsg1List.SUPPLIER
// ANK-2663-00-00 ADD END
// ANK-3846-00-00 ADD START
, ECN0021B002CBSMsg1List.KSSAI_ID
// ANK-3846-00-00 ADD END
};
// 明細に処理結果(ResultSet)をマッピング
CAANMsg[] outMsg1 = mapMessageList(rsltQuery,msgKeyList1,"eo.ejb.cbs.cbsmsg.ECN0021B002CBSMsg1List",0);
// クレジットカード番号を復号化
for (int i = 0; i < outMsg1.length; i++)
{
if (null != outMsg1[i].getString(ECN0021B002CBSMsg1List.CRECARD_NO) && !outMsg1[i].getString(ECN0021B002CBSMsg1List.CRECARD_NO).isEmpty())
{
outMsg1[i].set(ECN0021B002CBSMsg1List.CRECARD_NO, JCCModelCommon.getDecryptResult(inMsg, inContext, outMsg1[i].getString(ECN0021B002CBSMsg1List.CRECARD_NO)));
}
}
// inMsg(CBSMsg)に明細をセット
inMsg.set("ECN0021B002CBSMsg1List", outMsg1);
} catch(SQLException e) {
inMsg.set(ECN0021B002CBSMsg.STATUS, StatusCodes.FIND_DB_ERR);
throw new CAANRuntimeException(e);
} finally {
// 資源の解放
try{
if(rsltQuery != null){
rsltQuery.close();
}
if(pstmt != null){
pstmt.close();
}
if(rsltQueryCnt != null){
rsltQueryCnt.close();
}
if(pstmtCnt != null){
pstmtCnt.close();
}
if(con1 != null){
closeConnection(con1);
}
}catch(SQLException e){
inMsg.set(ECN0021B002CBSMsg.STATUS, StatusCodes.FIND_DB_ERR);
throw new CAANRuntimeException(e);
}
}
}
}