#!/bin/bash
##############################################################
# システム名    ：eo顧客基幹システム
#
# サブシステム名：請求収納
#
# シェル名      ：当月請求情報反映
#
# 機能          ：督促対象請求契約情報、督促対象請求情報（強制窓口フラグ付）をマージし督促対象請求契約情報（当月請求反映済）を作成、ソートする
#
#　　SORT順
#　　　請求契約番号（昇順）
#
#
# コマンド形式  ：EO6010325J0.sh
#
# 実行環境      ：.../app/shl
#
# 終了ステータス：ゼロ以外異常
#
# 特記事項      ：特になし
#
# 変更履歴      ：変更日      変更者       障害／仕様変更No.
# v6.00           2014/02/01  FJ）小掠     【OM-2014-0000172】,【OM-2014-0000176】対応 新規作成
#
##############################################################

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

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

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

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

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

#
#---OPD
#
OPD=$1

#---ワークファイル削除モード
WK_RM=true


#-------------------------------------------------------------
#--- 1.督促対象請求契約情報
#-------------------------------------------------------------
CSVFILE_CH048_001=${MID_DIR_CH}/CHIFM048004.csv
CSVFILE_CH048_001_WK=${MID_DIR_CH}/CHIFM048004_001WK.csv
#INNERT JOIN
CSVFILE_CH048_001_MC_WK=${MID_DIR_CH}/CHIFM048004_MC_001WK.csv
#LEFT JOIN フラグ用に１番目に項目増えている
CSVFILE_CH048_002_MC_WK=${MID_DIR_CH}/CHIFM048004_MC_002WK.csv
# 
CSVFILE_CH048_003_MC_WK=${MID_DIR_CH}/CHIFM048004_MC_003WK.csv

#-------------------------------------------------------------
#--- 2.仮収納債権内訳情報
#-------------------------------------------------------------
CSVFILE_CH228_002=${MID_DIR_CH}/CHIFM228001.csv

#-------------------------------------------------------------
#--- 3.定義ファイル
#-------------------------------------------------------------
MC_CH_CM_0120_DEF=${G_TOOLSH}/util/def/CH_CM_0120.def
MC_CH_CM_0120_DEF_WK1=${G_TOOLSH}/util/def/CH_CM_0120_WK1.def
MC_CH_CM_0122_DEF=${G_TOOLSH}/util/def/CH_CM_0122.def
MC_CH_CM_0122_DEF_WK1=${G_TOOLSH}/util/def/CH_CM_0122_WK1.def

#-------------------------------------------------------------
#--- 4.出力
#-------------------------------------------------------------
OUTFILE_WRK=${MID_DIR_CH}/CHIFM048008_WRK.csv
OUTFILE=${MID_DIR_CH}/CHIFM048008.csv


#
#---業務で必要な変数定義
#
#xxx=xxxxxxx
#---マッチング処理でLeftjoinがNULL時に"を付けなくする（マッチング使用時は必須）
export ZTLQUOTES=''
##############################################################
# 業務処理
##############################################################
sh ${G_TOOLSH}/EOK010210J0.sh CS00025I $JOBNAME

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

P1="OPD=,"
P2="SVCCTL=,"
P3="JOB=EO6010325J0,"
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

#-------------------------------------------------------------------------------
#- 
#-------------------------------------------------------------------------------
#LFにする
bsortex \
  -sort key="0.10asca" \
  -record recform=txtcsv \
  -input  reclen=2700 \
          file=${CSVFILE_CH048_001} \
  -output file=${CSVFILE_CH048_001_WK} linedlmt=lf
rc=$?
if [ $rc -ne 0 ]
then
    sh ${G_TOOLSH}/EOK010210J0.sh CS00002E $JOBNAME " nkf Error(${OUTFILE}.csv:rc=$rc) "
    echo $JOBNAME " nkf Error(${OUTFILE}.csv:rc=$rc) "
    exit ${G_RTN_ERROR}
fi

#- マッチング定義更新
cp -f ${MC_CH_CM_0120_DEF} ${MC_CH_CM_0120_DEF_WK1}
sed -i -e "s%:IN1_CH0048%${CSVFILE_CH048_001_WK}%"  ${MC_CH_CM_0120_DEF_WK1}
sed -i -e "s%:IN1_CH0228%${CSVFILE_CH228_002}%"  ${MC_CH_CM_0120_DEF_WK1}

#- マッチング定義更新
cp -f ${MC_CH_CM_0122_DEF} ${MC_CH_CM_0122_DEF_WK1}
sed -i -e "s%:IN1_CH0048%${CSVFILE_CH048_001_WK}%"  ${MC_CH_CM_0122_DEF_WK1}
sed -i -e "s%:IN1_CH0228%${CSVFILE_CH228_002}%"  ${MC_CH_CM_0122_DEF_WK1}

#
#- マッチング
#
ZTLOUTFILE=${CSVFILE_CH048_001_MC_WK}
export ZTLOUTFILE
${G_TOOLSH}/util/bin/ZTLMAT01 ${MC_CH_CM_0120_DEF_WK1}

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

#
#- マッチング
#
ZTLOUTFILE=${CSVFILE_CH048_002_MC_WK}
export ZTLOUTFILE
${G_TOOLSH}/util/bin/ZTLMAT01 ${MC_CH_CM_0122_DEF_WK1}

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

#--- CHIFM048に存在する分のみ抽出
bsortex \
  -sort key="0.10asc" \
  -record recform=txtcsv \
  -input reclen=2700 \
   include="0.1asc.lt.'0'" \
          file=${CSVFILE_CH048_002_MC_WK} \
  -output file=${CSVFILE_CH048_003_MC_WK} reconst=1.END

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

#--- マージ
bsortex \
	-sort key="0.10asca"  -record recform=txtflt \
	-input reclen=2700 file=${CSVFILE_CH048_001_MC_WK},${CSVFILE_CH048_003_MC_WK} \
	-output file=${OUTFILE}

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

#ワーク削除
if [ $WK_RM = "true" ]
then
    rm -f ${MC_CH_CM_0120_DEF_WK1}
    rm -f ${MC_CH_CM_0122_DEF_WK1}
    rm -f ${CSVFILE_CH048_001_WK}
    rm -f ${CSVFILE_CH048_001_MC_WK}
    rm -f ${CSVFILE_CH048_002_MC_WK}
    rm -f ${CSVFILE_CH048_003_MC_WK}
    rm -f ${OUTFILE_WRK}
fi

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

exit ${G_RTN_NORMAL}