#!/bin/bash
##############################################################
# システム名    ：eo顧客基幹システム
#
# サブシステム名：契約管理
#
# シェル名      ：複数機器・オプションへのＣＰ追加対象集約処理
#
# 機能          ：(1)～(9)の各判定で、キャンペーンの値引き対象とする料金プランであるが、
#                 割引サービス対象契約がないレコードを集約し、１ファイルにする。
#
# コマンド形式  ：EO2E501K0J0.sh
#
# 実行環境      ：.../app/shl
#
# 終了ステータス：ゼロ以外異常
#
# 特記事項      ：特になし
#
# 変更履歴      ：変更日      変更者       障害／仕様変更No.
# v7.00         ：2013/11/07  FJ)西面      【ANK-1578-00-00】
# v8.00         ：2014/01/28  FJ)三宅      【ANK-1710-00-00】
# v9.00         ：2014/06/05  FJ)三宅      【TAI-2014-0000019】
# v22.00        ：2016/01/19  FJ)有本      【OM-2016-0000115】 性能改善
# v50.00.00       2020/07/29  FJ)塩津      ANK-3889-00-00   機器単位キャンペーン対応（機器サービス開始日の開始契機導入）
##############################################################

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

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

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

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

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

#
#---業務で必要な変数定義
#
#xxx=xxxxxxx
##############################################################
# 業務処理
##############################################################
sh ${G_TOOLSH}/EOK010210J0.sh CS00025I $JOBNAME

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

P1="OPD=,"
P2="SVCCTL=,"
P3="JOB=EO2E501K0J0,"
P4="IND1=,"
P5="INF1=,"
P6="IND2=,"
P7="INF2=,"
P8="OTD1=,"
P9="OTF1=,"
P10="OTD2=,"
P11="OTF2=,"
P12="TABLENAME=,"
P13="SQLKEY=,"
P14="SQLPARAM=,"
P15="ERRFILE=,"
P16="RECOVERY=,"
P17="BREAKPTN=,"
P18="FREE="
PARA="$P1$P2$P3$P4$P5$P6$P7$P8$P9$P10$P11$P12$P13$P14$P15$P16$P17$P18"

sh ${G_TOOLSH}/EOK010210J0.sh CS00027I $JOBNAME

#
#--- ファイル定義
#
# v9.00 MOD Start
#SVC_KEI_UCWK_02=${MID_DIR_KK}/EO2E50180J0_OUT.csv
#OP_SVC_KEI_03=${MID_DIR_KK}/EO2E501A0J0_OUT.csv
#OP_SVC_KEI_04=${MID_DIR_KK}/EO2E501B0J0_OUT.csv
#SBOP_SVC_KEI_05=${MID_DIR_KK}/EO2E501D0J0_OUT.csv
#SBOP_SVC_KEI_06=${MID_DIR_KK}/EO2E501E0J0_OUT.csv
#KKTK_SVC_KEI_07=${MID_DIR_KK}/EO2E501G0J0_OUT.csv
#KKTK_SVC_KEI_08=${MID_DIR_KK}/EO2E501H0J0_OUT.csv
#KKTK_SVC_KEI_09=${MID_DIR_KK}/EO2E501J0J0_OUT.csv
#KKOP_SVC_KEI_10=${MID_DIR_KK}/EO2E501N0J0_OUT.csv
SVC_KEI_UCWK_02=${LOC_DIR_KK}/EO2E50180J0_OUT.csv
OP_SVC_KEI_03=${LOC_DIR_KK}/EO2E501A0J0_OUT.csv
OP_SVC_KEI_04=${LOC_DIR_KK}/EO2E501B0J0_OUT.csv
SBOP_SVC_KEI_05=${LOC_DIR_KK}/EO2E501D0J0_OUT.csv
SBOP_SVC_KEI_06=${LOC_DIR_KK}/EO2E501E0J0_OUT.csv
KKTK_SVC_KEI_07=${LOC_DIR_KK}/EO2E501G0J0_OUT.csv
KKTK_SVC_KEI_08=${LOC_DIR_KK}/EO2E501H0J0_OUT.csv
KKTK_SVC_KEI_09=${LOC_DIR_KK}/EO2E501J0J0_OUT.csv
KKOP_SVC_KEI_10=${LOC_DIR_KK}/EO2E501N0J0_OUT.csv
# v9.00 MOD End
# v8.00 start
# v9.00 MOD Start
#SEIOPSVC_KEI_11=${MID_DIR_KK}/EO2E501R0J0_OUT.csv
SEIOPSVC_KEI_11=${LOC_DIR_KK}/EO2E501R0J0_OUT.csv
# v9.00 MOD End
# v8.00 end

OUTFILE=${MID_DIR_KK}/KKIFM549001.csv

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

if [ ! -r $OP_SVC_KEI_03 ]
then
    sh ${G_TOOLSH}/EOK010210J0.sh CS00002E $JOBNAME " File is nonexist($OP_SVC_KEI_03) "
    echo $JOBNAME " File is nonexist($OP_SVC_KEI_03) "
    sh ${G_TOOLSH}/EOK010210J0.sh CS00028I $JOBNAME
    sh ${G_TOOLSH}/EOK010210J0.sh CS00026I $JOBNAME
    exit ${G_RTN_ERROR}
fi

if [ ! -r $OP_SVC_KEI_04 ]
then
    sh ${G_TOOLSH}/EOK010210J0.sh CS00002E $JOBNAME " File is nonexist($OP_SVC_KEI_04) "
    echo $JOBNAME " File is nonexist($OP_SVC_KEI_04) "
    sh ${G_TOOLSH}/EOK010210J0.sh CS00028I $JOBNAME
    sh ${G_TOOLSH}/EOK010210J0.sh CS00026I $JOBNAME
    exit ${G_RTN_ERROR}
fi

if [ ! -r $SBOP_SVC_KEI_05 ]
then
    sh ${G_TOOLSH}/EOK010210J0.sh CS00002E $JOBNAME " File is nonexist($SBOP_SVC_KEI_05) "
    echo $JOBNAME " File is nonexist($SBOP_SVC_KEI_05) "
    sh ${G_TOOLSH}/EOK010210J0.sh CS00028I $JOBNAME
    sh ${G_TOOLSH}/EOK010210J0.sh CS00026I $JOBNAME
    exit ${G_RTN_ERROR}
fi

if [ ! -r $SBOP_SVC_KEI_06 ]
then
    sh ${G_TOOLSH}/EOK010210J0.sh CS00002E $JOBNAME " File is nonexist($SBOP_SVC_KEI_06) "
    echo $JOBNAME " File is nonexist($SBOP_SVC_KEI_06) "
    sh ${G_TOOLSH}/EOK010210J0.sh CS00028I $JOBNAME
    sh ${G_TOOLSH}/EOK010210J0.sh CS00026I $JOBNAME
    exit ${G_RTN_ERROR}
fi

if [ ! -r $KKTK_SVC_KEI_07 ]
then
    sh ${G_TOOLSH}/EOK010210J0.sh CS00002E $JOBNAME " File is nonexist($KKTK_SVC_KEI_07) "
    echo $JOBNAME " File is nonexist($KKTK_SVC_KEI_07) "
    sh ${G_TOOLSH}/EOK010210J0.sh CS00028I $JOBNAME
    sh ${G_TOOLSH}/EOK010210J0.sh CS00026I $JOBNAME
    exit ${G_RTN_ERROR}
fi

if [ ! -r $KKTK_SVC_KEI_08 ]
then
    sh ${G_TOOLSH}/EOK010210J0.sh CS00002E $JOBNAME " File is nonexist($KKTK_SVC_KEI_08) "
    echo $JOBNAME " File is nonexist($KKTK_SVC_KEI_08) "
    sh ${G_TOOLSH}/EOK010210J0.sh CS00028I $JOBNAME
    sh ${G_TOOLSH}/EOK010210J0.sh CS00026I $JOBNAME
    exit ${G_RTN_ERROR}
fi

if [ ! -r $KKTK_SVC_KEI_09 ]
then
    sh ${G_TOOLSH}/EOK010210J0.sh CS00002E $JOBNAME " File is nonexist($KKTK_SVC_KEI_09) "
    echo $JOBNAME " File is nonexist($KKTK_SVC_KEI_09) "
    sh ${G_TOOLSH}/EOK010210J0.sh CS00028I $JOBNAME
    sh ${G_TOOLSH}/EOK010210J0.sh CS00026I $JOBNAME
    exit ${G_RTN_ERROR}
fi

if [ ! -r $KKOP_SVC_KEI_10 ]
then
    sh ${G_TOOLSH}/EOK010210J0.sh CS00002E $JOBNAME " File is nonexist($KKOP_SVC_KEI_10) "
    echo $JOBNAME " File is nonexist($KKOP_SVC_KEI_10) "
    sh ${G_TOOLSH}/EOK010210J0.sh CS00028I $JOBNAME
    sh ${G_TOOLSH}/EOK010210J0.sh CS00026I $JOBNAME
    exit ${G_RTN_ERROR}
fi

# v8.00 start
if [ ! -r $SEIOPSVC_KEI_11 ]
then
    sh ${G_TOOLSH}/EOK010210J0.sh CS00002E $JOBNAME " File is nonexist($SEIOPSVC_KEI_11) "
    echo $JOBNAME " File is nonexist($SEIOPSVC_KEI_11) "
    sh ${G_TOOLSH}/EOK010210J0.sh CS00028I $JOBNAME
    sh ${G_TOOLSH}/EOK010210J0.sh CS00026I $JOBNAME
    exit ${G_RTN_ERROR}
fi
# v8.00 end

#
#--- 出力ファイルを初期化する
#
cat /dev/null > $OUTFILE

#
#--- CP追加対象ファイルをすべて結合する
#
cat ${SVC_KEI_UCWK_02} >> ${OUTFILE}
cat ${OP_SVC_KEI_03} >> ${OUTFILE}
cat ${OP_SVC_KEI_04} >> ${OUTFILE}
cat ${SBOP_SVC_KEI_05} >> ${OUTFILE}
cat ${SBOP_SVC_KEI_06} >> ${OUTFILE}
cat ${KKTK_SVC_KEI_07} >> ${OUTFILE}
cat ${KKTK_SVC_KEI_08} >> ${OUTFILE}
cat ${KKTK_SVC_KEI_09} >> ${OUTFILE}
cat ${KKOP_SVC_KEI_10} >> ${OUTFILE}
# v8.00 start
cat ${SEIOPSVC_KEI_11} >> ${OUTFILE}
# v8.00 end

# v9.00 ADD Start
# 不要ファイルを削除
rm -f ${LOC_DIR_KK}/EO2E50110J0_KK0451_cnt.csv
rm -f ${LOC_DIR_KK}/EO2E50120J0_KK0841_cnt.csv
rm -f ${LOC_DIR_KK}/EO2E50130J0_KK0481_cnt.csv
rm -f ${LOC_DIR_KK}/EO2E50140J0_KK0081_cnt.csv
rm -f ${LOC_DIR_KK}/EO2E50150J0_KK0851_cnt.csv
rm -f ${LOC_DIR_KK}/EO2E50150J0_KK0851_03_cnt.csv
rm -f ${LOC_DIR_KK}/EO2E50160J0_OUT.csv
rm -f ${LOC_DIR_KK}/EO2E50170J0_KK0161_cnt.csv
rm -f ${LOC_DIR_KK}/EO2E50180J0_OUT.csv
rm -f ${LOC_DIR_KK}/EO2E50190J0_KK0351_cnt.csv
rm -f ${LOC_DIR_KK}/EO2E501A0J0_OUT.csv
rm -f ${LOC_DIR_KK}/EO2E501B0J0_OUT.csv
rm -f ${LOC_DIR_KK}/EO2E501C0J0_KK0401_cnt.csv
rm -f ${LOC_DIR_KK}/EO2E501D0J0_OUT.csv
rm -f ${LOC_DIR_KK}/EO2E501E0J0_OUT.csv
rm -f ${LOC_DIR_KK}/EO2E501F0J0_KK0341_cnt.csv
rm -f ${LOC_DIR_KK}/EO2E501F0J0_KK0341_cnt_TMP.csv
#ANK-3889-00-00 ADD START
rm -f ${LOC_DIR_KK}/EO2E501F0J0_KK0341_cnt2.csv
rm -f ${LOC_DIR_KK}/EO2E50160J0_KK2371_out.csv
rm -f ${LOC_DIR_KK}/EO2E50160J0_KK2371_trg.csv
rm -f ${LOC_DIR_KK}/EO2E50160J0_tmp1.csv
rm -f ${LOC_DIR_KK}/EO2E50160J0_tmp2.csv
rm -f ${LOC_DIR_KK}/EO2E50160J0_tmpsort1.csv
rm -f ${LOC_DIR_KK}/EO2E50160J0_tmpsort2.csv
rm -f ${LOC_DIR_KK}/EO2E50160J0_LIST.csv
rm -f ${LOC_DIR_KK}/EO2E501G0J0_KK2371_trg.csv
rm -f ${LOC_DIR_KK}/EO2E501G0J0_tmp1.csv
rm -f ${LOC_DIR_KK}/EO2E501G0J0_tmp2.csv
rm -f ${LOC_DIR_KK}/EO2E501G0J0_tmpsort1.csv
rm -f ${LOC_DIR_KK}/EO2E501G0J0_tmpsort2.csv
rm -f ${LOC_DIR_KK}/EO2E501G0J0_LIST.csv
rm -f ${LOC_DIR_KK}/EO2E501H0J0_KK2371_trg.csv
rm -f ${LOC_DIR_KK}/EO2E501H0J0_tmp1.csv
rm -f ${LOC_DIR_KK}/EO2E501H0J0_tmp2.csv
rm -f ${LOC_DIR_KK}/EO2E501H0J0_tmpsort1.csv
rm -f ${LOC_DIR_KK}/EO2E501H0J0_tmpsort2.csv
rm -f ${LOC_DIR_KK}/EO2E501H0J0_LIST.csv
rm -f ${LOC_DIR_KK}/EO2E501J0J0_KK2371_trg.csv
rm -f ${LOC_DIR_KK}/EO2E501J0J0_tmp1.csv
rm -f ${LOC_DIR_KK}/EO2E501J0J0_tmp2.csv
rm -f ${LOC_DIR_KK}/EO2E501J0J0_tmpsort1.csv
rm -f ${LOC_DIR_KK}/EO2E501J0J0_tmpsort2.csv
rm -f ${LOC_DIR_KK}/EO2E501J0J0_LIST.csv
#ANK-3889-00-00 ADD END
# OM-2016-0000115 性能改善 2016/01/19 有本 DEL START
#rm -f ${LOC_DIR_KK}/EO2E501F0J0_KK0341_cnt_SRT.csv
# OM-2016-0000115 性能改善 2016/01/19 有本 DEL END
rm -f ${LOC_DIR_KK}/EO2E501F1J0_KK0241.csv
rm -f ${LOC_DIR_KK}/EO2E501G0J0_OUT.csv
rm -f ${LOC_DIR_KK}/EO2E501H0J0_OUT.csv
rm -f ${LOC_DIR_KK}/EO2E501J0J0_OUT.csv
rm -f ${LOC_DIR_KK}/EO2E501M0J0_KK2811_cnt.csv
rm -f ${LOC_DIR_KK}/EO2E501N0J0_OUT.csv
rm -f ${LOC_DIR_KK}/EO2E501P0J0_KK0441_UNL.csv
# OM-2016-0000115 性能改善 2016/01/19 有本 DEL START
#rm -f ${LOC_DIR_KK}/EO2E501P0J0_KK0441_SRT.csv
# OM-2016-0000115 性能改善 2016/01/19 有本 DEL END
rm -f ${LOC_DIR_KK}/EO2E501P0J0_KK0441.csv
# OM-2016-0000115 性能改善 2016/01/19 有本 DEL START
#rm -f ${LOC_DIR_KK}/EO2E501Q0J0_KK0321_UNL.csv
# OM-2016-0000115 性能改善 2016/01/19 有本 DEL END
rm -f ${LOC_DIR_KK}/EO2E501Q0J0_KK0321_SRT.csv
rm -f ${LOC_DIR_KK}/EO2E501Q0J0_KK0321.csv
rm -f ${LOC_DIR_KK}/EO2E501R0J0_OUT.csv
# v9.00 ADD End

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

exit ${G_RTN_NORMAL}