/*******************************************************************************
* All Rights reserved,Copyright (c) K-Opticom
********************************************************************************
*＜プログラム内容＞
* システム名 ：eo顧客基幹システム
* モジュール名 ：JSYejbETU0041B013TPDA
* ソースファイル名：JSYejbETU0041B013TPDA.java
* 作成者 ：EK909306
* 日付 ：2011年06月29日
*＜機能概要＞
* 申込事業所別電話帳申込依頼件数取得テンプレートDBアクセス部品です。
*＜修正履歴＞
* バージョン 修正日 修正者 修正内容
* v3.00.00 2012/03/17 FJ)楠神 新規作成
* v3.00.01 2012/06/13 FJ)宮本 TAI-2012-0000054
* v4.00.00 2012/06/13 FJ)宮本 ANK-0398-00-00
* v4.00.01 2012/06/29 FJ)宮本 IT1-2012-0000871
* v4.00.02 2012/06/29 FJ)宮本 IT1-2012-0000872
* v4.00.03 2012/08/22 FJ)宮本 TAI-2012-0000093
* v4.00.04 2012/11/28 FJ)楠神 ST4-2012-0000113
* v48.00.00 2020/01/21 FJ)西窪 ANK-3507-00-00 TDIS連携の自動化対応
*
********************************************************************************/
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.ETU0041B013CBSMsg;
import eo.ejb.cbs.cbsmsg.ETU0041B013CBSMsg1List;
import eo.ejb.cbm.entity.TU0041ETMsg;
import eo.ejb.common.JTUModelCommon;
/**
*
* テンプレートDBアクセス部品 ETU0041B013_SQLF
* 入力された項目からSQL文を動的に組み立て、
* 検索結果をCBSMsgにセットします。
* @author FJ
*/
public class JSYejbETU0041B013TPDA extends CAANSQLFacility implements TemplateDBAccessHandler
{
/**
* コンストラクタ
*/
public JSYejbETU0041B013TPDA()
{
}
/**
* ETU0041B013_SQLF
* @param inMsg 入力値の格納されたCBSMsg
* @param inContext
* @return void
*/
public void invoke(CAANMsg inMsg, AgentDispatchContext inContext)
{
// コネクション
Connection con1 = null;
// プリペアステートメント
PreparedStatement pstmt = null;
// リザルトセット
ResultSet rsltQuery = null;
/********************
* SQL文の作成
********************/
try
{
//コネクション取得
con1 = JSYejbConnection.getConnection(TU0041ETMsg.getTableName());
// SQL文_基本部1
StringBuffer sql_Buff = new StringBuffer();
sql_Buff .append(" SELECT ")
.append(" CNTTABLE.MSKM_JIGSHO_NO, ")
.append(" CNTTABLE.MSKM_JIGSHONM, ")
.append(" CNTTABLE.SEND_UPPLNO, ")
.append(" CNTTABLE.ADD_CNT + CNTTABLE.CHG_CNT + CNTTABLE.DEL_CNT + CNTTABLE.AD_ERR_CNT AS SEND_CNT, ")
.append(" CNTTABLE.ADD_CNT, ")
.append(" CNTTABLE.CHG_CNT, ")
.append(" CNTTABLE.DEL_CNT, ")
.append(" CNTTABLE.AD_ERR_CNT, ")
.append(" CNTTABLE.SEND_ZUMI_CNT, ")
.append(" CNTTABLE.KOPT_RRK_MDGC_TELNO, ")
.append(" CNTTABLE.KOPT_RRK_MDGC_FAX_NO ")
.append(" FROM ")
.append(" (")
.append(" SELECT ")
.append(" MJ.MSKM_JIGSHO_NO, ")
.append(" MJ.MSKM_JIGSHONM, ")
.append(" MJ.SEND_UPPLNO, ")
.append(" ( ")
.append(" SELECT ")
.append(" COUNT(*) CNT ")
.append(" FROM ")
.append(" ( ")
.append(" SELECT ")
.append(" DNW_IN.DNWACHO_MSKM_NO, ")
.append(" DNW_IN.GENE_ADD_DTM, ")
.append(" DNW_IN.SVC_KEI_UCWK_NO, ")
.append(" DNW_IN.HJIN_EO_YKAE_SVKEI_NO, ")
.append(" DNW_IN.DNWACHOMSK_IDO_NAIYO_CD, ")
.append(" DNW_IN.KEISAI_SVC_STAYMD, ")
.append(" DNW_IN.BMP_UM ")
.append(" FROM ")
.append(" TU_T_DNWACHOMSK DNW_IN ")
.append(" WHERE ")
.append(" DNW_IN.DNWACHO_MSKM_STAT = '021' ")
.append(" AND DNW_IN.DNWACHOMSK_IDO_NAIYO_CD = '1' ")
//ANK-3507-00-00 MOD START
//.append(" AND DNW_IN.TDIS_INFO_CHK_FLG = '1' ")
.append(" AND DNW_IN.DATA_SEND_KH = '1' ")
//ANK-3507-00-00 MOD END
.append(" AND DNW_IN.AD_CHK_RSLT_CD = '0' ")
.append(" AND DNW_IN.GENE_ADD_DTM = ( ")
.append(" SELECT ")
.append(" MAX(DNW_GENE.GENE_ADD_DTM) ")
.append(" FROM ")
.append(" TU_T_DNWACHOMSK DNW_GENE ")
.append(" WHERE ")
.append(" DNW_GENE.DNWACHO_MSKM_NO = DNW_IN.DNWACHO_MSKM_NO ")
.append(" AND DNW_GENE.MK_FLG = '0' ")
.append(" ) ")
.append(" ) DNW ")
.append(" INNER JOIN ")
.append(" TU_T_DNWACHOMSK_NYO DNWN_NEW ")
.append(" ON ")
.append(" DNW.DNWACHO_MSKM_NO = DNWN_NEW.DNWACHO_MSKM_NO ")
.append(" AND DNW.GENE_ADD_DTM = DNWN_NEW.GENE_ADD_DTM ")
.append(" AND DNWN_NEW.DNWACHOMSK_NEW_OLD_FLG = '0' ")
.append(" AND DNWN_NEW.MK_FLG = '0' ")
.append(" LEFT OUTER JOIN ")
.append(" TU_T_BMP_KOJI BMP ")
.append(" ON ")
.append(" NVL(DNW.SVC_KEI_UCWK_NO, 'DUMMY') = NVL(BMP.SVC_KEI_UCWK_NO, 'DUMMY') ")
.append(" AND NVL(DNW.HJIN_EO_YKAE_SVKEI_NO, 'DUMMY') = NVL(BMP.HJIN_EO_YKAE_SVKEI_NO, 'DUMMY') ")
.append(" AND DNWN_NEW.NTT_TELNO = BMP.NTT_KEI_TEL_KAISEN_NO ")
.append(" AND DNW.BMP_UM = '1' ")
.append(" WHERE ")
.append(" ( ")
.append(" ( ")
.append(" DNW.BMP_UM = '1' ")
.append(" AND BMP.GENE_ADD_DTM = ( ")
.append(" SELECT ")
.append(" MAX(BMP_GENE.GENE_ADD_DTM) ")
.append(" FROM ")
.append(" TU_T_BMP_KOJI BMP_GENE ")
.append(" WHERE ")
.append(" BMP_GENE.BMP_KOJI_NO = BMP.BMP_KOJI_NO ")
.append(" AND BMP_GENE.MK_FLG = '0' ")
.append(" ) ")
.append(" AND BMP.BMP_KOJI_STAT IN('031', '032', '040', '050') ")
.append(" AND ( ")
// ANK 3507-00-00 MOD START
//.append(" ? >= SUBSTR(BMP.BMP_KOJI_FIX_YMDH,1,8) ")
//.append(" OR ? >= ( ")
.append(" ? >= ( ")
.append(" SELECT ")
//.append(" MAX(BUSDAY.TRGT_YMD) ")
.append(" MIN(BUSDAY.TRGT_YMD) ")
.append(" FROM ")
.append(" ZM_M_BUSIDAY_KANRI BUSDAY ")
.append(" WHERE ")
//.append(" BUSDAY.TRGT_YMD < SUBSTR(BMP.BMP_KOJI_FIX_YMDH,1,8) ")
.append(" BUSDAY.TRGT_YMD > SUBSTR(BMP.BMP_KOJI_FIX_YMDH,1,8) ")
// ANK 3507-00-00 MOD END
.append(" AND BUSDAY.BUSIDAY_FLG = '1' ")
.append(" AND BUSDAY.MK_FLG = '0' ")
.append(" ) ")
.append(" ) ")
.append(" ) ")
.append(" OR ( ")
.append(" DNW.BMP_UM = '0' ")
.append(" AND ? >= DNW.KEISAI_SVC_STAYMD ")
.append(" ) ")
.append(" ) ")
.append(" ) AS ADD_CNT, ")
.append(" ( ")
.append(" SELECT ")
.append(" COUNT(*) CNT ")
.append(" FROM ")
.append(" ( ")
.append(" SELECT ")
.append(" DNW_IN.DNWACHO_MSKM_NO, ")
.append(" DNW_IN.GENE_ADD_DTM, ")
.append(" DNW_IN.SVC_KEI_UCWK_NO, ")
.append(" DNW_IN.HJIN_EO_YKAE_SVKEI_NO, ")
.append(" DNW_IN.DNWACHOMSK_IDO_NAIYO_CD, ")
.append(" DNW_IN.KEISAI_SVC_STAYMD, ")
.append(" DNW_IN.BMP_UM ")
.append(" FROM ")
.append(" TU_T_DNWACHOMSK DNW_IN ")
.append(" WHERE ")
.append(" DNW_IN.DNWACHO_MSKM_STAT = '021' ")
.append(" AND DNW_IN.DNWACHOMSK_IDO_NAIYO_CD = '2' ")
//ANK-3507-00-00 MOD START
//.append(" AND DNW_IN.TDIS_INFO_CHK_FLG = '1' ")
.append(" AND DNW_IN.DATA_SEND_KH = '1' ")
//ANK-3507-00-00 MOD END
.append(" AND DNW_IN.AD_CHK_RSLT_CD = '0' ")
.append(" AND DNW_IN.GENE_ADD_DTM = ( ")
.append(" SELECT ")
.append(" MAX(DNW_GENE.GENE_ADD_DTM) ")
.append(" FROM ")
.append(" TU_T_DNWACHOMSK DNW_GENE ")
.append(" WHERE ")
.append(" DNW_GENE.DNWACHO_MSKM_NO = DNW_IN.DNWACHO_MSKM_NO ")
.append(" AND DNW_GENE.MK_FLG = '0' ")
.append(" ) ")
.append(" ) DNW ")
.append(" INNER JOIN ")
.append(" TU_T_DNWACHOMSK_NYO DNWN_NEW ")
.append(" ON ")
.append(" DNW.DNWACHO_MSKM_NO = DNWN_NEW.DNWACHO_MSKM_NO ")
.append(" AND DNW.GENE_ADD_DTM = DNWN_NEW.GENE_ADD_DTM ")
.append(" AND DNWN_NEW.DNWACHOMSK_NEW_OLD_FLG = '0' ")
.append(" AND DNWN_NEW.MK_FLG = '0' ")
.append(" LEFT OUTER JOIN ")
.append(" TU_T_BMP_KOJI BMP ")
.append(" ON ")
.append(" NVL(DNW.SVC_KEI_UCWK_NO, 'DUMMY') = NVL(BMP.SVC_KEI_UCWK_NO, 'DUMMY') ")
.append(" AND NVL(DNW.HJIN_EO_YKAE_SVKEI_NO, 'DUMMY') = NVL(BMP.HJIN_EO_YKAE_SVKEI_NO, 'DUMMY') ")
.append(" AND DNWN_NEW.NTT_TELNO = BMP.NTT_KEI_TEL_KAISEN_NO ")
.append(" AND DNW.BMP_UM = '1' ")
.append(" WHERE ")
.append(" ( ")
.append(" ( ")
.append(" DNW.BMP_UM = '1' ")
.append(" AND BMP.GENE_ADD_DTM = ( ")
.append(" SELECT ")
.append(" MAX(BMP_GENE.GENE_ADD_DTM) ")
.append(" FROM ")
.append(" TU_T_BMP_KOJI BMP_GENE ")
.append(" WHERE ")
.append(" BMP_GENE.BMP_KOJI_NO = BMP.BMP_KOJI_NO ")
.append(" AND BMP_GENE.MK_FLG = '0' ")
.append(" ) ")
.append(" AND BMP.BMP_KOJI_STAT IN('031', '032', '040', '050') ")
.append(" AND ( ")
// ANK 3507-00-00 MOD START
//.append(" ? >= SUBSTR(BMP.BMP_KOJI_FIX_YMDH,1,8) ")
//.append(" OR ? >= ( ")
.append(" ? >= ( ")
.append(" SELECT ")
//.append(" MAX(BUSDAY.TRGT_YMD) ")
.append(" MIN(BUSDAY.TRGT_YMD) ")
.append(" FROM ")
.append(" ZM_M_BUSIDAY_KANRI BUSDAY ")
.append(" WHERE ")
//.append(" BUSDAY.TRGT_YMD < SUBSTR(BMP.BMP_KOJI_FIX_YMDH,1,8) ")
.append(" BUSDAY.TRGT_YMD > SUBSTR(BMP.BMP_KOJI_FIX_YMDH,1,8) ")
// ANK 3507-00-00 MOD END
.append(" AND BUSDAY.BUSIDAY_FLG = '1' ")
.append(" AND BUSDAY.MK_FLG = '0' ")
.append(" ) ")
.append(" ) ")
.append(" ) ")
.append(" OR ( ")
.append(" DNW.BMP_UM = '0' ")
.append(" AND ? >= DNW.KEISAI_SVC_STAYMD ")
.append(" ) ")
.append(" ) ")
.append(" ) AS CHG_CNT, ")
.append(" ( ")
.append(" SELECT ")
.append(" COUNT(*) CNT ")
.append(" FROM ")
.append(" ( ")
.append(" SELECT ")
.append(" DNW_IN.DNWACHO_MSKM_NO, ")
.append(" DNW_IN.GENE_ADD_DTM, ")
.append(" DNW_IN.SVC_KEI_UCWK_NO, ")
.append(" DNW_IN.HJIN_EO_YKAE_SVKEI_NO, ")
.append(" DNW_IN.DNWACHOMSK_IDO_NAIYO_CD, ")
.append(" DNW_IN.KEISAI_SVC_STAYMD, ")
.append(" DNW_IN.BMP_UM ")
.append(" FROM ")
.append(" TU_T_DNWACHOMSK DNW_IN ")
.append(" WHERE ")
.append(" DNW_IN.DNWACHO_MSKM_STAT = '021' ")
.append(" AND DNW_IN.DNWACHOMSK_IDO_NAIYO_CD = '3' ")
//ANK-3507-00-00 MOD START
//.append(" AND DNW_IN.TDIS_INFO_CHK_FLG = '1' ")
.append(" AND DNW_IN.DATA_SEND_KH = '1' ")
//ANK-3507-00-00 MOD END
.append(" AND DNW_IN.AD_CHK_RSLT_CD = '0' ")
.append(" AND DNW_IN.GENE_ADD_DTM = ( ")
.append(" SELECT ")
.append(" MAX(DNW_GENE.GENE_ADD_DTM) ")
.append(" FROM ")
.append(" TU_T_DNWACHOMSK DNW_GENE ")
.append(" WHERE ")
.append(" DNW_GENE.DNWACHO_MSKM_NO = DNW_IN.DNWACHO_MSKM_NO ")
.append(" AND DNW_GENE.MK_FLG = '0' ")
.append(" ) ")
.append(" ) DNW ")
.append(" INNER JOIN ")
.append(" TU_T_DNWACHOMSK_NYO DNWN_OLD ")
.append(" ON ")
.append(" DNW.DNWACHO_MSKM_NO = DNWN_OLD.DNWACHO_MSKM_NO ")
.append(" AND DNW.GENE_ADD_DTM = DNWN_OLD.GENE_ADD_DTM ")
.append(" AND DNWN_OLD.DNWACHOMSK_NEW_OLD_FLG = '1' ")
.append(" AND DNWN_OLD.MK_FLG = '0' ")
.append(" LEFT OUTER JOIN ")
.append(" TU_T_BMP_KOJI BMP ")
.append(" ON ")
.append(" NVL(DNW.SVC_KEI_UCWK_NO, 'DUMMY') = NVL(BMP.SVC_KEI_UCWK_NO, 'DUMMY') ")
.append(" AND NVL(DNW.HJIN_EO_YKAE_SVKEI_NO, 'DUMMY') = NVL(BMP.HJIN_EO_YKAE_SVKEI_NO, 'DUMMY') ")
.append(" AND DNWN_OLD.NTT_TELNO = BMP.NTT_KEI_TEL_KAISEN_NO ")
.append(" AND DNW.BMP_UM = '1' ")
.append(" WHERE ")
.append(" ( ")
.append(" ( ")
.append(" DNW.BMP_UM = '1' ")
.append(" AND BMP.GENE_ADD_DTM = ( ")
.append(" SELECT ")
.append(" MAX(BMP_GENE.GENE_ADD_DTM) ")
.append(" FROM ")
.append(" TU_T_BMP_KOJI BMP_GENE ")
.append(" WHERE ")
.append(" BMP_GENE.BMP_KOJI_NO = BMP.BMP_KOJI_NO ")
.append(" AND BMP_GENE.MK_FLG = '0' ")
.append(" ) ")
.append(" AND BMP.BMP_KOJI_STAT IN('031', '032', '040', '050') ")
.append(" AND ( ")
// ANK 3507-00-00 MOD START
//.append(" ? >= SUBSTR(BMP.BMP_KOJI_FIX_YMDH,1,8) ")
//.append(" OR ? >= ( ")
.append(" ? >= ( ")
.append(" SELECT ")
//.append(" MAX(BUSDAY.TRGT_YMD) ")
.append(" MIN(BUSDAY.TRGT_YMD) ")
.append(" FROM ")
.append(" ZM_M_BUSIDAY_KANRI BUSDAY ")
.append(" WHERE ")
//.append(" BUSDAY.TRGT_YMD < SUBSTR(BMP.BMP_KOJI_FIX_YMDH,1,8) ")
.append(" BUSDAY.TRGT_YMD > SUBSTR(BMP.BMP_KOJI_FIX_YMDH,1,8) ")
// ANK 3507-00-00 MOD END
.append(" AND BUSDAY.BUSIDAY_FLG = '1' ")
.append(" AND BUSDAY.MK_FLG = '0' ")
.append(" ) ")
.append(" ) ")
.append(" ) ")
.append(" OR ( ")
.append(" DNW.BMP_UM = '0' ")
.append(" AND ? >= DNW.KEISAI_SVC_STAYMD ")
.append(" ) ")
.append(" ) ")
.append(" ) AS DEL_CNT, ")
.append(" ( ")
.append(" SELECT ")
.append(" COUNT(*) CNT ")
.append(" FROM ")
.append(" ( ")
.append(" SELECT ")
.append(" DNW_IN.DNWACHO_MSKM_NO, ")
.append(" DNW_IN.GENE_ADD_DTM, ")
.append(" DNW_IN.SVC_KEI_UCWK_NO, ")
.append(" DNW_IN.HJIN_EO_YKAE_SVKEI_NO, ")
.append(" DNW_IN.DNWACHOMSK_IDO_NAIYO_CD, ")
.append(" DNW_IN.KEISAI_SVC_STAYMD, ")
.append(" DNW_IN.BMP_UM ")
.append(" FROM ")
.append(" TU_T_DNWACHOMSK DNW_IN ")
.append(" WHERE ")
.append(" DNW_IN.DNWACHO_MSKM_STAT = '021' ")
//ANK-3507-00-00 MOD START
//.append(" AND DNW_IN.TDIS_INFO_CHK_FLG = '1' ")
.append(" AND DNW_IN.DATA_SEND_KH = '1' ")
//ANK-3507-00-00 MOD END
.append(" AND DNW_IN.AD_CHK_RSLT_CD = '1' ")
.append(" AND DNW_IN.GENE_ADD_DTM = ( ")
.append(" SELECT ")
.append(" MAX(DNW_GENE.GENE_ADD_DTM) ")
.append(" FROM ")
.append(" TU_T_DNWACHOMSK DNW_GENE ")
.append(" WHERE ")
.append(" DNW_GENE.DNWACHO_MSKM_NO = DNW_IN.DNWACHO_MSKM_NO ")
.append(" AND DNW_GENE.MK_FLG = '0' ")
.append(" ) ")
.append(" ) DNW ")
.append(" INNER JOIN ")
.append(" TU_T_DNWACHOMSK_NYO DNWN_NEW ")
.append(" ON ")
.append(" DNW.DNWACHO_MSKM_NO = DNWN_NEW.DNWACHO_MSKM_NO ")
.append(" AND DNW.GENE_ADD_DTM = DNWN_NEW.GENE_ADD_DTM ")
.append(" AND DNWN_NEW.DNWACHOMSK_NEW_OLD_FLG = '0' ")
.append(" AND DNWN_NEW.MK_FLG = '0' ")
.append(" INNER JOIN ")
.append(" TU_T_DNWACHOMSK_NYO DNWN_OLD ")
.append(" ON ")
.append(" DNW.DNWACHO_MSKM_NO = DNWN_OLD.DNWACHO_MSKM_NO ")
.append(" AND DNW.GENE_ADD_DTM = DNWN_OLD.GENE_ADD_DTM ")
.append(" AND DNWN_OLD.DNWACHOMSK_NEW_OLD_FLG = '1' ")
.append(" AND DNWN_OLD.MK_FLG = '0' ")
.append(" LEFT OUTER JOIN ")
.append(" TU_T_BMP_KOJI BMP ")
.append(" ON ")
.append(" NVL(DNW.SVC_KEI_UCWK_NO, 'DUMMY') = NVL(BMP.SVC_KEI_UCWK_NO, 'DUMMY') ")
.append(" AND NVL(DNW.HJIN_EO_YKAE_SVKEI_NO, 'DUMMY') = NVL(BMP.HJIN_EO_YKAE_SVKEI_NO, 'DUMMY') ")
.append(" AND DECODE(DNW.DNWACHOMSK_IDO_NAIYO_CD, 3, DNWN_OLD.NTT_TELNO, DNWN_NEW.NTT_TELNO) = BMP.NTT_KEI_TEL_KAISEN_NO ")
.append(" AND DNW.BMP_UM = '1' ")
.append(" WHERE ")
.append(" ( ")
.append(" ( ")
.append(" DNW.BMP_UM = '1' ")
.append(" AND BMP.GENE_ADD_DTM = ( ")
.append(" SELECT ")
.append(" MAX(BMP_GENE.GENE_ADD_DTM) ")
.append(" FROM ")
.append(" TU_T_BMP_KOJI BMP_GENE ")
.append(" WHERE ")
.append(" BMP_GENE.BMP_KOJI_NO = BMP.BMP_KOJI_NO ")
.append(" AND BMP_GENE.MK_FLG = '0' ")
.append(" ) ")
.append(" AND BMP.BMP_KOJI_STAT IN('031', '032', '040', '050') ")
.append(" AND ( ")
// ANK 3507-00-00 MOD START
//.append(" ? >= SUBSTR(BMP.BMP_KOJI_FIX_YMDH,1,8) ")
//.append(" OR ? >= ( ")
.append(" ? >= ( ")
.append(" SELECT ")
//.append(" MAX(BUSDAY.TRGT_YMD) ")
.append(" MIN(BUSDAY.TRGT_YMD) ")
.append(" FROM ")
.append(" ZM_M_BUSIDAY_KANRI BUSDAY ")
.append(" WHERE ")
//.append(" BUSDAY.TRGT_YMD < SUBSTR(BMP.BMP_KOJI_FIX_YMDH,1,8) ")
.append(" BUSDAY.TRGT_YMD > SUBSTR(BMP.BMP_KOJI_FIX_YMDH,1,8) ")
// ANK 3507-00-00 MOD END
.append(" AND BUSDAY.BUSIDAY_FLG = '1' ")
.append(" AND BUSDAY.MK_FLG = '0' ")
.append(" ) ")
.append(" ) ")
.append(" ) ")
.append(" OR ( ")
.append(" DNW.BMP_UM = '0' ")
.append(" AND ? >= DNW.KEISAI_SVC_STAYMD ")
.append(" ) ")
.append(" ) ")
.append(" ) AS AD_ERR_CNT, ")
.append(" ( ")
.append(" SELECT ")
.append(" COUNT(*) CNT ")
.append(" FROM ")
.append(" TU_T_DNWACHOMSK DNW ")
.append(" WHERE ")
.append(" DNW.DNWACHO_MSKM_YMD = ? ")
// ANK 3507-00-00 ADD START
.append(" AND DNW.DATA_SEND_KH = '1' ")
// ANK 3507-00-00 ADD END
.append(" AND DNW.GENE_ADD_DTM = ( ")
.append(" SELECT ")
.append(" MAX(DNW_GENE.GENE_ADD_DTM) ")
.append(" FROM ")
.append(" TU_T_DNWACHOMSK DNW_GENE ")
.append(" WHERE ")
.append(" DNW_GENE.DNWACHO_MSKM_NO = DNW.DNWACHO_MSKM_NO ")
.append(" AND DNW_GENE.MK_FLG = '0' ")
.append(" ) ")
.append(" ) AS SEND_ZUMI_CNT, ")
.append(" MJ.KOPT_RRK_MDGC_TELNO, ")
.append(" MJ.KOPT_RRK_MDGC_FAX_NO ")
.append(" FROM ")
.append(" TU_M_MSKM_JIGSHO MJ ")
.append(" WHERE ")
.append(" MJ.MSKM_JIGSHO_SBT_CD = '3' ")
.append(" AND MJ.MK_FLG = '0' ")
.append(") CNTTABLE");
//prepareStatementにSQL文をセット
pstmt = con1.prepareStatement(sql_Buff.toString());
//ログ出力(SQL文の出力)
JSYejbLog.outlog(inContext, JSYejbLog.DBACCESS, this.getClass(), sql_Buff);
//パラメータ設定用Index 初期化
int iIndex = 1;
String opeDate = JTUModelCommon.getOpeDate(inMsg, null);
// PreparedStatementの指定されたパラメータカラムに 指定された値を設定
if("1".equals(inMsg.getString(ETU0041B013CBSMsg.FUNC_CODE)))
{
// パラメータの設定(運用日付を指定)
CAANJDBCUtil.setParam(pstmt, iIndex++, opeDate);
CAANJDBCUtil.setParam(pstmt, iIndex++, opeDate);
CAANJDBCUtil.setParam(pstmt, iIndex++, opeDate);
CAANJDBCUtil.setParam(pstmt, iIndex++, opeDate);
CAANJDBCUtil.setParam(pstmt, iIndex++, opeDate);
CAANJDBCUtil.setParam(pstmt, iIndex++, opeDate);
CAANJDBCUtil.setParam(pstmt, iIndex++, opeDate);
CAANJDBCUtil.setParam(pstmt, iIndex++, opeDate);
// ANK 3507-00-00 DEL START
// CAANJDBCUtil.setParam(pstmt, iIndex++, opeDate);
// CAANJDBCUtil.setParam(pstmt, iIndex++, opeDate);
// CAANJDBCUtil.setParam(pstmt, iIndex++, opeDate);
// CAANJDBCUtil.setParam(pstmt, iIndex++, opeDate);
// ANK 3507-00-00 DEL END
// パラメータの設定(ＫＥＹ＿基準日を指定)
CAANJDBCUtil.setParam(pstmt, iIndex++, inMsg.getObject(ETU0041B013CBSMsg.KEY_STDARDYMD));
}
// ResultSetの取得
rsltQuery = pstmt.executeQuery();
// ETU0041B013CBSMsgの明細にセットする項目
String[] msgKeyList1 = {
ETU0041B013CBSMsg1List.MSKM_JIGSHO_NO
, ETU0041B013CBSMsg1List.MSKM_JIGSHONM
, ETU0041B013CBSMsg1List.SEND_UPPLNO
, ETU0041B013CBSMsg1List.SEND_CNT
, ETU0041B013CBSMsg1List.ADD_CNT
, ETU0041B013CBSMsg1List.CHG_CNT
, ETU0041B013CBSMsg1List.DEL_CNT
, ETU0041B013CBSMsg1List.AD_ERR_CNT
, ETU0041B013CBSMsg1List.SEND_ZUMI_CNT
, ETU0041B013CBSMsg1List.KOPT_RRK_MDGC_TELNO
, ETU0041B013CBSMsg1List.KOPT_RRK_MDGC_FAX_NO
};
// 明細に処理結果(ResultSet)をマッピング
CAANMsg[] outMsg1 = mapMessageList(rsltQuery, msgKeyList1, "eo.ejb.cbs.cbsmsg.ETU0041B013CBSMsg1List", 0);
/**
* 検索エラーフラグの設定
*/
// 一括検索の場合
// 検索件数が0件の場合、エラーフラグに"1"を設定して処理終了
if (0 == outMsg1.length)
{
inMsg.set(ETU0041B013CBSMsg.SEARCH_ERR_FLG, JPCModelConstant.SEARCH_ERR_FLG_ZERO);
inMsg.set(ETU0041B013CBSMsg.TOTAL_SEARCH_NUM, "0");
return;
}
// 一括検索の場合総検索件数の再設定を行う
inMsg.set(ETU0041B013CBSMsg.TOTAL_SEARCH_NUM, Integer.toString(outMsg1.length));
// inMsg(CBSMsg)に明細をセット
inMsg.set("ETU0041B013CBSMsg1List", outMsg1);
}
catch(SQLException e)
{
inMsg.set(ETU0041B013CBSMsg.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(ETU0041B013CBSMsg.STATUS, StatusCodes.FIND_DB_ERR);
throw new CAANRuntimeException(e);
}
}
}
}