#!/bin/bash
##############################################################
# システム名    ：eo顧客基幹システム
#
# サブシステム名：契約管理
#
# シェル名      ：番ポなし番号事前通知データ抽出
#
# 機能          ：まだ通知していない番ポなし番号のデータを抽出し、以下のファイルを作成する。
#・番ポなし番号事前通知抽出結果更新ファイル
#・番ポなし番号事前通知データ
#
#
# コマンド形式  ：EO22V0511D0.sh
#
# 実行環境      ：.../app/shl
#
# 終了ステータス：ゼロ以外異常
#
# 特記事項      ：特になし
#
# 変更履歴      ：変更日      変更者       障害／仕様変更No.
# v4.00         2012/08/27    FJ)井熊      新規作成
# v4.01         2012/11/26    FJ)井熊      【TAI-2012-0000135】サブシェル化対応
# v4.02         2013/01/23    FJ)井熊      【ST2-2013-0000220】ディレイド処理結果更新実装
# v5.00         2013/04/02    FJ)井熊      【ST3-2013-0000803】性能改善アンローダ化
# v5.01         2013/05/15    FJ)掛木      【000-2013-0000000】中間ファイルにタイムスタンプを付与する対応
# v5.02         2013/05/23    FJ)米谷      適用年月日の比較にRSLT_SYSDATEが使用されているのでRSLT_OPEDATEに修正
# v5.03         2013/05/22    FJ)米谷      【TAI-2013-0000026】日中バッチ運用日付の対応
# v6.00         2013/12/04    FJ)山裾      【OM-2013-0003051】性能改善対応（サービス契約とお客様のスキーマをモジュール内にて検索する）
# v11.00        2014/12/15    FJ)福岡      【OM-2013-0003918】適用年月日20991231対応
# v12.00        2015/01/30    FJ)西面      【OM-2014-0004066】住所変更中電話変更時絞込み対応
# v39.00        2018/08/21    FJ)西面      【OM-2018-0000788】電番事前通知出力不備
#
##############################################################

##############################################################
# 環境変数定義
##############################################################

#
#---ツール格納場所
#
G_TOOLSH=.

#
#---環境変数定義Shell呼び出し
#
. EOK010110J0.sh

#
#---ＪＯＢ名
#
JOBNAME=`basename $0 | sed -e "s/\.sh//g"`

#
#---サービス（業務プロセス）
#
SVC=$JOBNAME

#
#---OPD
#
DLYD_JOBNAME=$1
DLYD_FLG_FILE=$2
TIME_STR=$3
OPD=$4

#
#---業務で必要な変数定義
#
. EOK010410J0.sh 2
#. EOK010310J0.sh "BDATE"
#
#---運用日付取得
#
if [ "${OPD}" = "" ]; then
   . EOK010310J0.sh "NDATE"
   OPD=${RSLT_OPEDATE}
else
   RSLT_OPEDATE=${OPD}
fi


#000-2013-0000000 Delete Start
#FILE_KKIFM241=${MID_DIR_KK}/KKIFM241001.csv
#FILE_KKIFM242=${MID_DIR_KK}/KKIFM242001.csv
#000-2013-0000000 Delete End
#000-2013-0000000 Add Start
FILE_KKIFM241=${MID_DIR_KK}/KKIFM241001_${TIME_STR}.csv
FILE_KKIFM242=${MID_DIR_KK}/KKIFM242001_${TIME_STR}.csv
#000-2013-0000000 Add End
##############################################################
# 業務処理
##############################################################
sh ${G_TOOLSH}/EOK010210J0.sh CS00025I $JOBNAME

# v11.00 ADD START
MAX_OPEDATE=20991231
# v11.00 ADD END

#
#--- ファイル定義
#
SQLFILE=${SQL_DIR}/KK_U_KK0161_09.sql
MYSQLFILE=${SQL_DIR}/KK_U_KK0161_09_$JOBNAME.sql

#2013/12/04 OM-2013-0003051 Add Start
SQLFILE_KK0191=${SQL_DIR}/KK_U_KK0191_03.sql
MYSQLFILE_KK0191=${SQL_DIR}/KK_U_KK0191_03_$JOBNAME.sql

# v12.00 ADD START
SQLFILE_KK2101=${SQL_DIR}/KK_U_KK2101_02.sql
MYSQLFILE_KK2101=${SQL_DIR}/KK_U_KK2101_02_$JOBNAME.sql
# v12.00 ADD END

# OM-2018-0000788 ADD START
SQLFILE_KK2101_BANGOTUIKA=${SQL_DIR}/KK_U_KK2101_04.sql
MYSQLFILE_KK2101_BANGOTUIKA=${SQL_DIR}/KK_U_KK2101_04_$JOBNAME.sql
# OM-2018-0000788 ADD END

OUTFILE_KK0161=${MID_DIR_KK}/EO22V0511D0_KK0161_001.csv
OUTFILE_KK0161_SORT=${MID_DIR_KK}/EO22V0511D0_KK0161_002.csv
OUTFILE_KK0161_CRNT=${MID_DIR_KK}/EO22V0511D0_KK0161_003.csv
OUTFILE_KK0191=${MID_DIR_KK}/EO22V0511D0_KK0191_001.csv
OUTFILE_MERGE=${MID_DIR_KK}/EO22V0511D0_001.csv
OUTFILE_MERGE_SORT=${MID_DIR_KK}/EO22V0511D0_002.csv
# v12.00 ADD START
OUTFILE_KK0161_CRNT_BK=${MID_DIR_KK}/EO22V0511D0_KK0161_003_BK.csv
OUTFILE_KK2101=${MID_DIR_KK}/EO22V0511D0_KK2101_001.csv
# OM-2018-0000788 ADD START
OUTFILE_KK2101_BANGOTUIKA=${MID_DIR_KK}/EO22V0511D0_KK2101_002.csv
# OM-2018-0000788 ADD END
OUTFILE_KK0161_MERGE=${MID_DIR_KK}/EO22V0511D0_KK0161_004.csv
# v12.00 ADD END
# OM-2018-0000788 ADD START
OUTFILE_KK0161_CRNT_STA010=${MID_DIR_KK}/EO22V0511D0_KK0161_005.csv
OUTFILE_KK0161_CRNT_STA010_MERGE=${MID_DIR_KK}/EO22V0511D0_KK0161_006.csv
OUTFILE_BANGOTUIKA_MERGE=${MID_DIR_KK}/EO22V0511D0_003.csv
OUTFILE_BANGOTUIKA_MERGE_SORT=${MID_DIR_KK}/EO22V0511D0_004.csv
OUTFILE_LIST=${MID_DIR_KK}/EO22V0511D0_005.csv
# OM-2018-0000788 ADD END

DEFFILE=${G_TOOLSH}/util/def/KK_CM_0354.def
TMPDEFFILE=${ULD_WORK_DIR}/KK_CM_0354.tmp.${JOBNAME}.def
# v12.00 ADD START
DEFFILE_0537=${G_TOOLSH}/util/def/KK_CM_0537.def
TMPDEFFILE_0537=${ULD_WORK_DIR}/KK_CM_0537.tmp.${JOBNAME}.def
# v12.00 ADD END
# OM-2018-0000788 ADD START
DEFFILE_1009=${G_TOOLSH}/util/def/KK_CM_1009.def
TMPDEFFILE_1009=${ULD_WORK_DIR}/KK_CM_1009.tmp.${JOBNAME}.def
DEFFILE_1010=${G_TOOLSH}/util/def/KK_CM_1010.def
TMPDEFFILE_1010=${ULD_WORK_DIR}/KK_CM_1010.tmp.${JOBNAME}.def
# OM-2018-0000788 ADD END
#2013/12/04 OM-2013-0003051 Add End

#2013/12/04 OM-2013-0003051 Mod Start
OUTFILE1=${MID_DIR_KK}/KKIFM441001.csv
#OUTFILE1=${MID_DIR_KK}/KKFIM441001.csv
#OUTFILE2=${MID_DIR_KK}/KKFIM441002.csv
#2013/12/04 OM-2013-0003051 Mod End

#
#--- 各ファイルの存在チェックを行う
#
if [ ! -r $SQLFILE ]
then
    sh ${G_TOOLSH}/EOK010210J0.sh CS00002E $JOBNAME " File is nonexist($SQLFILE) "
    echo $JOBNAME " File is nonexist($SQLFILE) "
    exit ${G_RTN_ERROR}
fi

#2013/12/04 OM-2013-0003051 Add Start
if [ ! -r $SQLFILE_KK0191 ]
then
    sh ${G_TOOLSH}/EOK010210J0.sh CS00002E $JOBNAME " File is nonexist($SQLFILE_KK0191) "
    echo $JOBNAME " File is nonexist($SQLFILE_KK0191) "
    exit ${G_RTN_ERROR}
fi

# v12.00 ADD START
if [ ! -r $SQLFILE_KK2101 ]
then
    sh ${G_TOOLSH}/EOK010210J0.sh CS00002E $JOBNAME " File is nonexist($SQLFILE_KK2101) "
    echo $JOBNAME " File is nonexist($SQLFILE_KK2101) "
    exit ${G_RTN_ERROR}
fi
# v12.00 ADD END

# OM-2018-0000788 ADD START
if [ ! -r $SQLFILE_KK2101_BANGOTUIKA ]
then
    sh ${G_TOOLSH}/EOK010210J0.sh CS00002E $JOBNAME " File is nonexist($SQLFILE_KK2101_BANGOTUIKA) "
    echo $JOBNAME " File is nonexist($SQLFILE_KK2101_BANGOTUIKA) "
    exit ${G_RTN_ERROR}
fi
# OM-2018-0000788 ADD END
if [ ! -r $DEFFILE ]
then
    sh ${G_TOOLSH}/EOK010210J0.sh CS00002E $JOBNAME " File is nonexist($DEFFILE) "
    echo $JOBNAME " File is nonexist($DEFFILE) "
    exit ${G_RTN_ERROR}
fi
#2013/12/04 OM-2013-0003051 Add End

# v12.00 ADD START
if [ ! -r $DEFFILE_0537 ]
then
    sh ${G_TOOLSH}/EOK010210J0.sh CS00002E $JOBNAME " File is nonexist($DEFFILE_0537) "
    echo $JOBNAME " File is nonexist($DEFFILE_0537) "
    exit ${G_RTN_ERROR}
fi
# v12.00 ADD END

# OM-2018-0000788 ADD START
if [ ! -r $DEFFILE_1009 ]
then
    sh ${G_TOOLSH}/EOK010210J0.sh CS00002E $JOBNAME " File is nonexist($DEFFILE_1009) "
    echo $JOBNAME " File is nonexist($DEFFILE_1009) "
    exit ${G_RTN_ERROR}
fi

if [ ! -r $DEFFILE_1010 ]
then
    sh ${G_TOOLSH}/EOK010210J0.sh CS00002E $JOBNAME " File is nonexist($v) "
    echo $JOBNAME " File is nonexist($DEFFILE_1010) "
    exit ${G_RTN_ERROR}
fi
# OM-2018-0000788 ADD END

#
#--- アンロードファイルのクリアを行う
#
cat /dev/null > $OUTFILE1
cat /dev/null > $MYSQLFILE

rc=$?
if [ $rc -ne 0 ]
then
    sh ${G_TOOLSH}/EOK010210J0.sh CS00002E $JOBNAME " File cat error($OUTFILE1:rc=$rc) "
    echo $JOBNAME " File cat error($OUTFILE1:rc=$rc) "
    exit ${G_RTN_ERROR}
fi

#2013/12/04 OM-2013-0003051 Add Start
#
#--- アンロードファイル(KK0161)のクリアを行う
#
cat /dev/null > $OUTFILE_KK0161

rc=$?
if [ $rc -ne 0 ]
then
    sh ${G_TOOLSH}/EOK010210J0.sh CS00002E $JOBNAME " File cat error($OUTFILE_KK0161:rc=$rc) "
    echo $JOBNAME " File cat error($OUTFILE_KK0161:rc=$rc) "
    exit ${G_RTN_ERROR}
fi

#
#--- アンロードファイル(KK0161_SORT)のクリアを行う
#
cat /dev/null > $OUTFILE_KK0161_SORT

rc=$?
if [ $rc -ne 0 ]
then
    sh ${G_TOOLSH}/EOK010210J0.sh CS00002E $JOBNAME " File cat error($OUTFILE_KK0161_SORT:rc=$rc) "
    echo $JOBNAME " File cat error($OUTFILE_KK0161_SORT:rc=$rc) "
    exit ${G_RTN_ERROR}
fi

#
#--- アンロードファイル(KK0161_CRNT)のクリアを行う
#
cat /dev/null > $OUTFILE_KK0161_CRNT

rc=$?
if [ $rc -ne 0 ]
then
    sh ${G_TOOLSH}/EOK010210J0.sh CS00002E $JOBNAME " File cat error($OUTFILE_KK0161_CRNT:rc=$rc) "
    echo $JOBNAME " File cat error($OUTFILE_KK0161_CRNT:rc=$rc) "
    exit ${G_RTN_ERROR}
fi

#
#--- アンロードファイル(KK0191)のクリアを行う
#
cat /dev/null > $OUTFILE_KK0191

rc=$?
if [ $rc -ne 0 ]
then
    sh ${G_TOOLSH}/EOK010210J0.sh CS00002E $JOBNAME " File cat error($OUTFILE_KK0191:rc=$rc) "
    echo $JOBNAME " File cat error($OUTFILE_KK0191:rc=$rc) "
    exit ${G_RTN_ERROR}
fi

# v12.00 ADD START
#
#--- アンロードファイル(KK0161_CRNT_BK)のクリアを行う
#
cat /dev/null > $OUTFILE_KK0161_CRNT_BK

rc=$?
if [ $rc -ne 0 ]
then
    sh ${G_TOOLSH}/EOK010210J0.sh CS00002E $JOBNAME " File cat error($OUTFILE_KK0161_CRNT_BK:rc=$rc) "
    echo $JOBNAME " File cat error($OUTFILE_KK0161_CRNT_BK:rc=$rc) "
    exit ${G_RTN_ERROR}
fi

#
#--- アンロードファイル(KK2101)のクリアを行う
#
cat /dev/null > $OUTFILE_KK2101

rc=$?
if [ $rc -ne 0 ]
then
    sh ${G_TOOLSH}/EOK010210J0.sh CS00002E $JOBNAME " File cat error($OUTFILE_KK2101:rc=$rc) "
    echo $JOBNAME " File cat error($OUTFILE_KK2101:rc=$rc) "
    exit ${G_RTN_ERROR}
fi

#
#--- アンロードファイル(KK0161)のクリアを行う
#
cat /dev/null > $OUTFILE_KK0161_MERGE

rc=$?
if [ $rc -ne 0 ]
then
    sh ${G_TOOLSH}/EOK010210J0.sh CS00002E $JOBNAME " File cat error($OUTFILE_KK0161_MERGE:rc=$rc) "
    echo $JOBNAME " File cat error($OUTFILE_KK0161_MERGE:rc=$rc) "
    exit ${G_RTN_ERROR}
fi
# v12.00 ADD END

# OM-2018-0000788 ADD START
#
#--- アンロードファイル(KK0161)のクリアを行う
#
cat /dev/null > $OUTFILE_KK0161_CRNT_STA010

rc=$?
if [ $rc -ne 0 ]
then
    sh ${G_TOOLSH}/EOK010210J0.sh CS00002E $JOBNAME " File cat error($OUTFILE_KK0161_CRNT_STA010:rc=$rc) "
    echo $JOBNAME " File cat error($OUTFILE_KK0161_CRNT_STA010:rc=$rc) "
    exit ${G_RTN_ERROR}
fi

#
#--- アンロードファイル(KK0161)のクリアを行う
#
cat /dev/null > $OUTFILE_KK0161_CRNT_STA010_MERGE

rc=$?
if [ $rc -ne 0 ]
then
    sh ${G_TOOLSH}/EOK010210J0.sh CS00002E $JOBNAME " File cat error($OUTFILE_KK0161_CRNT_STA010_MERGE:rc=$rc) "
    echo $JOBNAME " File cat error($OUTFILE_KK0161_CRNT_STA010_MERGE:rc=$rc) "
    exit ${G_RTN_ERROR}
fi

#
#--- アンロードファイル(KK2101)のクリアを行う
#
cat /dev/null > $OUTFILE_KK2101_BANGOTUIKA

rc=$?
if [ $rc -ne 0 ]
then
    sh ${G_TOOLSH}/EOK010210J0.sh CS00002E $JOBNAME " File cat error($OUTFILE_KK2101_BANGOTUIKA:rc=$rc) "
    echo $JOBNAME " File cat error($OUTFILE_KK2101_BANGOTUIKA:rc=$rc) "
    exit ${G_RTN_ERROR}
fi

#
#--- アンロードファイルのクリアを行う
#
cat /dev/null > $OUTFILE_BANGOTUIKA_MERGE

rc=$?
if [ $rc -ne 0 ]
then
    sh ${G_TOOLSH}/EOK010210J0.sh CS00002E $JOBNAME " File cat error($OUTFILE_BANGOTUIKA_MERGE:rc=$rc) "
    echo $JOBNAME " File cat error($OUTFILE_BANGOTUIKA_MERGE:rc=$rc) "
    exit ${G_RTN_ERROR}
fi

#
#--- アンロードファイルのクリアを行う
#
cat /dev/null > $OUTFILE_BANGOTUIKA_MERGE_SORT

rc=$?
if [ $rc -ne 0 ]
then
    sh ${G_TOOLSH}/EOK010210J0.sh CS00002E $JOBNAME " File cat error($OUTFILE_BANGOTUIKA_MERGE_SORT:rc=$rc) "
    echo $JOBNAME " File cat error($OUTFILE_BANGOTUIKA_MERGE_SORT:rc=$rc) "
    exit ${G_RTN_ERROR}
fi

#
#--- アンロードファイルのクリアを行う
#
cat /dev/null > $OUTFILE_LIST

rc=$?
if [ $rc -ne 0 ]
then
    sh ${G_TOOLSH}/EOK010210J0.sh CS00002E $JOBNAME " File cat error($OUTFILE_LIST:rc=$rc) "
    echo $JOBNAME " File cat error($OUTFILE_LIST:rc=$rc) "
    exit ${G_RTN_ERROR}
fi
# OM-2018-0000788 ADD END

#
#--- SQLファイル(KK0191)のクリアを行う
#
cat /dev/null > $MYSQLFILE_KK0191

rc=$?
if [ $rc -ne 0 ]
then
    sh ${G_TOOLSH}/EOK010210J0.sh CS00002E $JOBNAME " File cat error($MYSQLFILE_KK0191:rc=$rc) "
    echo $JOBNAME " File cat error($MYSQLFILE_KK0191:rc=$rc) "
    exit ${G_RTN_ERROR}
fi

# v12.00 ADD START

cat /dev/null > $MYSQLFILE_KK2101

rc=$?
if [ $rc -ne 0 ]
then
    sh ${G_TOOLSH}/EOK010210J0.sh CS00002E $JOBNAME " File cat error($MYSQLFILE_KK2101:rc=$rc) "
    echo $JOBNAME " File cat error($MYSQLFILE_KK2101:rc=$rc) "
    exit ${G_RTN_ERROR}
fi

# v12.00 ADD END

#
#--- defファイルのクリアを行う
#
cat /dev/null > $TMPDEFFILE

rc=$?
if [ $rc -ne 0 ]
then
    sh ${G_TOOLSH}/EOK010210J0.sh CS00002E $JOBNAME " File cat error($TMPDEFFILE:rc=$rc) "
    echo $JOBNAME " File cat error($TMPDEFFILE:rc=$rc) "
    exit ${G_RTN_ERROR}
fi

# v12.00 ADD START
cat /dev/null > $TMPDEFFILE_0537

rc=$?
if [ $rc -ne 0 ]
then
    sh ${G_TOOLSH}/EOK010210J0.sh CS00002E $JOBNAME " File cat error($TMPDEFFILE_0537:rc=$rc) "
    echo $JOBNAME " File cat error($TMPDEFFILE_0537:rc=$rc) "
    exit ${G_RTN_ERROR}
fi
# v12.00 ADD END

#
#--- MERGEファイルのクリアを行う
#
cat /dev/null > $OUTFILE_MERGE

rc=$?
if [ $rc -ne 0 ]
then
    sh ${G_TOOLSH}/EOK010210J0.sh CS00002E $JOBNAME " File cat error($OUTFILE_MERGE:rc=$rc) "
    echo $JOBNAME " File cat error($OUTFILE_MERGE:rc=$rc) "
    exit ${G_RTN_ERROR}
fi

#
#--- MERGE(SORT)ファイルのクリアを行う
#
cat /dev/null > $OUTFILE_MERGE_SORT

rc=$?
if [ $rc -ne 0 ]
then
    sh ${G_TOOLSH}/EOK010210J0.sh CS00002E $JOBNAME " File cat error($OUTFILE_MERGE_SORT:rc=$rc) "
    echo $JOBNAME " File cat error($OUTFILE_MERGE_SORT:rc=$rc) "
    exit ${G_RTN_ERROR}
fi
#2013/12/04 OM-2013-0003051 Add End


#
#--- 運用日用SQLファイr作成
#
while read LINE
do
# v11.00 MOD START
# echo ${LINE/ZZZZZ/"'"$RSLT_OPEDATE"'"} >> $MYSQLFILE
  echo ${LINE/ZZZZZ/"'"$MAX_OPEDATE"'"} >> $MYSQLFILE
# v11.00 MOD END
done < $SQLFILE

#2013/12/04 OM-2013-0003051 Add Start
while read LINE
do
# v11.00 MOD START
# echo ${LINE/ZZZZZ/"'"$RSLT_OPEDATE"'"} >> $MYSQLFILE_KK0191
  echo ${LINE/ZZZZZ/"'"$MAX_OPEDATE"'"} >> $MYSQLFILE_KK0191
# v11.00 MOD END
done < $SQLFILE_KK0191
#2013/12/04 OM-2013-0003051 Add End

# v12.00 ADD START
while read LINE
do
  echo ${LINE/ZZZZZ/"'"$MAX_OPEDATE"'"} >> $MYSQLFILE_KK2101
done < $SQLFILE_KK2101
# v12.00 ADD END

# OM-2018-0000788 ADD START
while read LINE
do
  echo ${LINE/ZZZZZ/"'"$MAX_OPEDATE"'"} >> $MYSQLFILE_KK2101_BANGOTUIKA
done < $SQLFILE_KK2101_BANGOTUIKA
# OM-2018-0000788 ADD END

#
#--- UNLOAD処理
#
#2013/12/04 OM-2013-0003051 Mod Start
#sh ${G_TOOLSH}/EOKULD02.sh $MYSQLFILE $OUTFILE1 $JOBNAME
sh ${G_TOOLSH}/EOKULD02.sh $MYSQLFILE $OUTFILE_KK0161 $JOBNAME
#2013/12/04 OM-2013-0003051 Mod End
rm -f $MYSQLFILE

rc=$?
if [ $rc -ne 0 ]
then
    sh ${G_TOOLSH}/EOK010210J0.sh CS00002E $JOBNAME " UNLOAD Error($SVC unload:rc=$rc) " 
    echo $JOBNAME " UNLOAD Error($SVC unload:rc=$rc) "
    exit ${G_RTN_ERROR}
fi

#2013/12/04 OM-2013-0003051 Delete Start
#
#---ＳＯＲＴ
#
#bsort -s -z124 -0.12asca,1.10ascr,2.19ascr -Tflt -t, -p "3.3asc.eq.'\"2\"',4.3asc.eq.'\"0\"',1.10asc.le.'\"${RSLT_OPEDATE}\"'" -o ${OUTFILE2} ${OUTFILE1}

#rm -f ${OUTFILE1}

#rc=$?
#if [ $rc -ne 0 ]
#then
#    sh ${G_TOOLSH}/EOK010210J0.sh CS00002E $JOBNAME " SORT Error($SVC sort:rc=$rc) "
#    echo $JOBNAME " SORT Error($SVC sort:rc=$rc) "
#    exit ${G_RTN_ERROR}
#fi
#2013/12/04 OM-2013-0003051 Delete End

#2013/12/04 OM-2013-0003051 Add Start
#
#--- キー項目(予約適用コード,無効フラグ)でデータを抽出
# 抽出条件
#    無効フラグ = '0'
#    予約適用コード = '2'
#    予約適用年月日 <= 処理日
# v11.00 MOD START
#bsortex -sort key=0.12asc,2.25asc -record recform=txtcsv -input file=${OUTFILE_KK0161} reclen=2000 include="3.1asc.eq.'0',4.1asc.eq.'2',5.8asc.le.'${RSLT_OPEDATE}'" -output file=${OUTFILE_KK0161_SORT}
bsortex -sort key=0.12asc,2.25asc -record recform=txtcsv -input file=${OUTFILE_KK0161} reclen=2000 include="3.1asc.eq.'0',4.1asc.eq.'2',5.8asc.le.'${MAX_OPEDATE}'" -output file=${OUTFILE_KK0161_SORT}
# v11.00 MOD END

#
#--- マージ（キー項目[サービス契約内訳番号,世代登録年月日時分秒と予約適用年月日の文字列連結]のカレントレコード（一番下のレコード）のみを残す）
bsortex -merge key=0.12asc -record recform=txtcsv -input file=${OUTFILE_KK0161_SORT} reclen=2000 -summary suppress last -output file=${OUTFILE_KK0161_CRNT}

#
#--- UNLOAD処理(KK0191)
#
sh ${G_TOOLSH}/EOKULD02.sh $MYSQLFILE_KK0191 $OUTFILE_KK0191 $JOBNAME
rm -f $MYSQLFILE_KK0191

rc=$?
if [ $rc -ne 0 ]
then
    sh ${G_TOOLSH}/EOK010210J0.sh CS00002E $JOBNAME " UNLOAD Error($SVC unload:rc=$rc) " 
    echo $JOBNAME " UNLOAD Error($SVC unload:rc=$rc) "
    exit ${G_RTN_ERROR}
fi

# v12.00 ADD START
#
#--- UNLOAD処理(KK2101)
#
sh ${G_TOOLSH}/EOKULD02.sh $MYSQLFILE_KK2101 $OUTFILE_KK2101 $JOBNAME
rm -f $MYSQLFILE_KK2101

rc=$?
if [ $rc -ne 0 ]
then
    sh ${G_TOOLSH}/EOK010210J0.sh CS00002E $JOBNAME " UNLOAD Error($SVC unload:rc=$rc) " 
    echo $JOBNAME " UNLOAD Error($SVC unload:rc=$rc) "
    exit ${G_RTN_ERROR}
fi

cp -p -f ${OUTFILE_KK0161_CRNT} ${OUTFILE_KK0161_CRNT_BK}

#
#--- 環境変数の設定を行う（出力ファイル情報の設定）
#
export ZTLTMPDIR=${ULD_WORK_DIR}
export ZTLOUTFILE=${OUTFILE_KK0161_MERGE}

#
#--- 定義ファイル環境変数設定処理
#
cat ${DEFFILE_0537} > ${TMPDEFFILE_0537}
sed -i -e s@'${MID_DIR_KK}'@${MID_DIR_KK}@g ${TMPDEFFILE_0537}

#
#--- ファイルマッチング処理　※元のＳＱＬのＪＯＩＮ
#
${G_TOOLSH}/util/bin/ZTLMAT01 ${TMPDEFFILE_0537}

rc=$?
if [ $rc -ne 0 ]
then
    sh ${G_TOOLSH}/EOK010210J0.sh CS00002E $JOBNAME " MATCHING UTIL Error($SVC util:rc=$rc) " 
    echo $JOBNAME " MATCHING UTIL Error($SVC util:rc=$rc) "
    sh ${G_TOOLSH}/EOK010210J0.sh CS00028I $JOBNAME
    sh ${G_TOOLSH}/EOK010210J0.sh CS00026I $JOBNAME
    exit ${G_RTN_ERROR}
fi


# v12.00 ADD END

#
#--- 環境変数の設定を行う（出力ファイル情報の設定）
#
export ZTLTMPDIR=${ULD_WORK_DIR}
export ZTLOUTFILE=${OUTFILE_MERGE}

#
#--- 定義ファイル環境変数設定処理
#
cat ${DEFFILE} > ${TMPDEFFILE}
sed -i -e s@'${MID_DIR_KK}'@${MID_DIR_KK}@g ${TMPDEFFILE}

#
#--- ファイルマッチング処理　※元のＳＱＬのＪＯＩＮ
#
${G_TOOLSH}/util/bin/ZTLMAT01 ${TMPDEFFILE}

rc=$?
if [ $rc -ne 0 ]
then
    sh ${G_TOOLSH}/EOK010210J0.sh CS00002E $JOBNAME " MATCHING UTIL Error($SVC util:rc=$rc) " 
    echo $JOBNAME " MATCHING UTIL Error($SVC util:rc=$rc) "
    sh ${G_TOOLSH}/EOK010210J0.sh CS00028I $JOBNAME
    sh ${G_TOOLSH}/EOK010210J0.sh CS00026I $JOBNAME
    exit ${G_RTN_ERROR}
fi

#
#--- キー項目(サービス契約番号)でデータをソート
#
bsortex -sort key=0.10asc -record recform=txtcsv -input file=${OUTFILE_MERGE} reclen=2000 -output file=${OUTFILE_MERGE_SORT}

# OM-2018-0000788 ADD START
#
#--- UNLOAD処理(KK2101)
#
sh ${G_TOOLSH}/EOKULD02.sh $MYSQLFILE_KK2101_BANGOTUIKA $OUTFILE_KK2101_BANGOTUIKA $JOBNAME
rm -f $MYSQLFILE_KK2101_BANGOTUIKA

rc=$?
if [ $rc -ne 0 ]
then
    sh ${G_TOOLSH}/EOK010210J0.sh CS00002E $JOBNAME " UNLOAD Error($SVC unload:rc=$rc) " 
    echo $JOBNAME " UNLOAD Error($SVC unload:rc=$rc) "
    exit ${G_RTN_ERROR}
fi

#
#--- キー項目(サービス契約内訳ステータス)でデータを抽出
# 抽出条件
#    サービス契約内訳ステータス='010'
#    
bsortex -sort key=0.12asc,1.29asc -record recform=txtcsv -input file=${OUTFILE_KK0161_CRNT} reclen=2000 include="6.3asc.eq.'010'" -output file=${OUTFILE_KK0161_CRNT_STA010}

#
#--- 環境変数の設定を行う（出力ファイル情報の設定）
#
export ZTLTMPDIR=${ULD_WORK_DIR}
export ZTLOUTFILE=${OUTFILE_KK0161_CRNT_STA010_MERGE}

#
#--- 定義ファイル環境変数設定処理
#
cat ${DEFFILE_1009} > ${TMPDEFFILE_1009}
sed -i -e s@'${MID_DIR_KK}'@${MID_DIR_KK}@g ${TMPDEFFILE_1009}

#
#--- ファイルマッチング処理　※元のＳＱＬのＪＯＩＮ
#
${G_TOOLSH}/util/bin/ZTLMAT01 ${TMPDEFFILE_1009}

rc=$?
if [ $rc -ne 0 ]
then
    sh ${G_TOOLSH}/EOK010210J0.sh CS00002E $JOBNAME " MATCHING UTIL Error($SVC util:rc=$rc) " 
    echo $JOBNAME " MATCHING UTIL Error($SVC util:rc=$rc) "
    sh ${G_TOOLSH}/EOK010210J0.sh CS00028I $JOBNAME
    sh ${G_TOOLSH}/EOK010210J0.sh CS00026I $JOBNAME
    exit ${G_RTN_ERROR}
fi

#
#--- 環境変数の設定を行う（出力ファイル情報の設定）
#
export ZTLTMPDIR=${ULD_WORK_DIR}
export ZTLOUTFILE=${OUTFILE_BANGOTUIKA_MERGE}

#
#--- 定義ファイル環境変数設定処理
#
cat ${DEFFILE_1010} > ${TMPDEFFILE_1010}
sed -i -e s@'${MID_DIR_KK}'@${MID_DIR_KK}@g ${TMPDEFFILE_1010}

#
#--- ファイルマッチング処理　※元のＳＱＬのＪＯＩＮ
#
${G_TOOLSH}/util/bin/ZTLMAT01 ${TMPDEFFILE_1010}

rc=$?
if [ $rc -ne 0 ]
then
    sh ${G_TOOLSH}/EOK010210J0.sh CS00002E $JOBNAME " MATCHING UTIL Error($SVC util:rc=$rc) " 
    echo $JOBNAME " MATCHING UTIL Error($SVC util:rc=$rc) "
    sh ${G_TOOLSH}/EOK010210J0.sh CS00028I $JOBNAME
    sh ${G_TOOLSH}/EOK010210J0.sh CS00026I $JOBNAME
    exit ${G_RTN_ERROR}
fi

#
#--- ファイルソート
#
bsortex -sort key=0.10asc -record recform=txtcsv -input file=${OUTFILE_BANGOTUIKA_MERGE} reclen=2000 -output file=${OUTFILE_BANGOTUIKA_MERGE_SORT}

#
#--- データ結合
#
bsortex -merge key=0.10asc -record recform=txtcsv -input file=${OUTFILE_MERGE_SORT},${OUTFILE_BANGOTUIKA_MERGE_SORT} reclen=500 -output file=${OUTFILE_LIST}
# OM-2018-0000788 ADD END

#
#--- マージ（キー項目[サービス契約番号]のカレントレコード（一番下のレコード）のみを残す）
# OM-2018-0000788 MOD START
#bsortex -merge key=0.10asc -record recform=txtcsv -input file=${OUTFILE_MERGE_SORT} reclen=2000 -summary suppress last -output file=${OUTFILE1}
bsortex -merge key=0.10asc -record recform=txtcsv -input file=${OUTFILE_LIST} reclen=2000 -summary suppress last -output file=${OUTFILE1}
# OM-2018-0000788 MOD END

#2013/12/04 OM-2013-0003051 Add End

#
#---終端文字列付与
#
#2013/12/04 OM-2013-0003051 Mod Start
#if [ -e $OUTFILE2 ] ; then
#  echo "\"END\"" >> $OUTFILE2
#  if [ $? -eq 0 ] ; then
#    echo '終端文字列付与完了'
#  fi
#fi
if [ -e $OUTFILE1 ] ; then
  echo "\"END\"" >> $OUTFILE1
  if [ $? -eq 0 ] ; then
    echo '終端文字列付与完了'
  fi
fi
#2013/12/04 OM-2013-0003051 Mod End


#
#---パラメタ定義
#

P1="OPD=$OPD,"
P2="SVCCTL=JBSbatMultiServiceControl,"
P3="JOB=EO22V0511D0,"
P4="IND1=KKIFM441.def,"
#2013/12/04 OM-2013-0003051 Mod Start
#P5="INF1=${OUTFILE2},"
P5="INF1=${OUTFILE1},"
#2013/12/04 OM-2013-0003051 Mod End
P6="IND2=,"
P7="INF2=,"
P8="OTD1=KKIFM241.def,"
P9="OTF1=${FILE_KKIFM241},"
P10="OTD2=KKIFM242.def,"
P11="OTF2=${FILE_KKIFM242},"
P12="TABLENAME=,"
P13="SQLKEY=,"
P14="SQLPARAM=,"
P15="ERRFILE=,"
P16="RECOVERY=,"
P17="BREAKPTN=,"
P18="FREE=${DLYD_JOBNAME};${DLYD_FLG_FILE}"
PARA="$P1$P2$P3$P4$P5$P6$P7$P8$P9$P10$P11$P12$P13$P14$P15$P16$P17$P18"

#
#---ＡＰＬ起動
#

java ${JAVA_OPTION} -jar ${JAR_DIR}/koptBatch.jar $PARA

rc=$?
ERR_FLG=0
if [ $rc -ne 0 ]
then
   if [ $rc -ne 4 ]
   then
       if [ $rc -ne 8 ]
       then
           #ERROR時：生成ファイル削除
           if [ -e $FILE_KKIFM241 ]
           then
             rm -f $FILE_KKIFM241
           fi
           if [ -e $FILE_KKIFM242 ]
           then
             rm -f $FILE_KKIFM242
           fi
           if [ $rc -ne 127 ]
           then
              sh ${G_TOOLSH}/EOK010210J0.sh CS00002E $JOBNAME " PROGRAM Error($SVC program:rc=$rc) "
              echo $JOBNAME " PROGRAM Error($SVC program:rc=$rc) "
              exit ${G_RTN_ERROR}
           fi
       fi
    fi
    ERR_FLG=1
fi

#
#--- ジョブの終了メッセージを出力する
#
sh ${G_TOOLSH}/EOK010210J0.sh CS00028I $JOBNAME
sh ${G_TOOLSH}/EOK010210J0.sh CS00026I $JOBNAME

exit $rc