#!/bin/ksh


#########################################################################
# Date:	25 June 2014							#
# Author : Raju Bolla							# 
# Email: raju.bolla@hp.com						#
# This script will Segregate data from CARRs Germany source files	#
# Germany Files For data load activities				#
# 									#
# Sustain will execute this Script as a last pre-load activty step	#
#									#
#########################################################################



#Function to check the return code of the command executed
chckRC()
	{
		if [ $1 -ne 0 ]
		then
				echo "$2" >/dev/null
				exit 1
		fi	
	}

##Copy Germany Files to GERMANY Folder
##Copy Germany Files to Greece Folder
#Bkp Path Germany Path
SOURCE_COMMON=$( echo "/pgrrappkg3/DataStage/CONSUMER_BI/datap5/WSLGER_WSLGREECE")
TARGET_GREECE=$( echo "/pgrrappkg3/DataStage/CONSUMER_BI/datap5/WSLGER") 
cd $SOURCE_COMMON
cp Crs_*Extract.txt $TARGET_GREECE/
cp Crs_*CTL.txt $TARGET_GREECE/
RC=$?
chckRC $RC "Aborted while executing Copy Germany Files to Greece Folder Part"
echo "Completed the execution of Copy Germany Files to Greece Folder Part" >/dev/null

cd $TARGET_GREECE
config_file_path=$( echo "/pgrrappkg3/DataStage/CONSUMER_BI/etlisp5/cfg")
if [[ -f $config_file_path/crt_extracts_branch_gswid_cntl ]]
then
        set -A FILENAME   $( cat $config_file_path/crt_extracts_branch_gswid_cntl | grep -v "^#" | awk '{ print $1 }')
        set -A COLPOS     $( cat $config_file_path/crt_extracts_branch_gswid_cntl | grep -v "^#" | awk '{ print $4 }')
        set -A CTLCOLPOS  $( cat $config_file_path/crt_extracts_branch_gswid_cntl | grep -v "^#" | awk '{ print $3 }')

	SOURCE_DIR=$( echo "/pgrrappkg3/DataStage/CONSUMER_BI/datap5/WSLGER")
	x=0
        while (( $x <  ${#FILENAME[*]}  ))
        do
                if [[ -f $SOURCE_DIR/${FILENAME[$x]} ]]
                then
                        MSG="Processing file $SOURCE_DIR/${FILENAME[$x]}:INFO"
                        echo $MSG;

                                PART1FILENAME=$( echo ${FILENAME[$x]} | awk -F"." '{ print $1 }')
                                PART2FILENAME=$( echo ${FILENAME[$x]} | awk -F"." '{ print $2 }')
                                NEWFILENAME=$( echo "$SOURCE_DIR/GERMANY_$PART1FILENAME.$PART2FILENAME")
				touch $NEWFILENAME
				##Reading GERMANY_Obligor_filter_ctl file
				##set -x
				if [[ -f $config_file_path/GERMANY_Obligor_filter_ctl ]]
				then 
					##this an if then else condition values for command_construction variable
					ifcondition_val=$( grep -v "^#" $config_file_path/GERMANY_Obligor_filter_ctl)
					command_construction=$( echo "cat $SOURCE_DIR/${FILENAME[$x]}  | awk -F\"|\" -v colpos=\"${COLPOS[$x]}\"  '{if ("$ifcondition_val") { print \$0 }}'  > $NEWFILENAME")
					##Executing cunstructed command with EVAL command
					eval $command_construction
                                	RC=$?
                                	if [[ $RC -ne 0 ]]
                                	then
                                        MSG="Error in creating file $NEWFILENAME:ALERT"
                                        echo $MSG;
                                        return -1
                                	else

                                        MSG="$NEWFILENAME file created:INFO"
                                        echo $MSG;
                                	fi
				fi
				##set +x

				##CTL File generation
				for CTL in $( echo ${CTLCOLPOS[$x]} | awk '{ FldCnt=split($0,Arr,"-"); print FldCnt }' )
				do
					CTLCTR=1
					DISPLAYVAL=""
					while (( $CTLCTR <= $CTL ))
					do
						VAL=$( echo ${CTLCOLPOS[$x]} | awk -v ctr="${CTLCTR}" '{ FldCnt=split($0,Arr,"-"); print Arr[ctr] }')
						if [[ $VAL = 0 ]];
						then
						    ROWCNT=$(cat $NEWFILENAME | wc -l ) 
						    DISPLAYVAL="$DISPLAYVAL""$ROWCNT|"
						else
						    SUMVAL=$(cat $NEWFILENAME | awk -F"|" -v val="${VAL}" ' 
										BEGIN { tot=0 } {tot=tot+$val } END { printf "%.2f",tot }')
						    DISPLAYVAL="$DISPLAYVAL""$SUMVAL|"
						fi
						CTLCTR=$(echo "$CTLCTR+1" | bc)
					done
					CTLNEWFILENAME=$( echo $NEWFILENAME 	| sed s/Extract/CTL/g )
					CTLORGFILENAME=$( echo ${FILENAME[$x]}	| sed s/Extract/CTL/g )
					if [[ -f $SOURCE_DIR/$CTLORGFILENAME ]]
					then
						cat $SOURCE_DIR/$CTLORGFILENAME | head -1  	> $CTLNEWFILENAME
					else
						echo "No header for CTL file found" 		> $CTLNEWFILENAME
						MSG="$CTLORGFILENAME file not found :WARN" 
						echo $MSG;
					fi		
					echo $DISPLAYVAL | sed s/\|$//g				>> $CTLNEWFILENAME
				done
                        MSG="Completed processing file ${FILENAME[$x]}"
                        echo $MSG;
                else
                        MSG="File not found $SOURCE_DIR/${FILENAME[$x]}. Proceeding to next file:WARN"
                        echo $MSG;
                fi
                x=$(echo "$x+1" | bc)
        done
else
  MSG="Invalid file $config_file_path/crt_extracts_branch_gswid_cntl:ALERT"
  echo $MSG;
fi;
## End of Generating Greece and Germany Files GREECE_* and Names

##Modifying Germany Data with Greece data and writing to Sed_*GREE
##Greece Files Path
cd $SOURCE_DIR
##Renaming file to Atcual name
for o in `ls -1 GERMANY_Crs_*_Extract.txt`
do
Actual_FILE_Name=`echo "$o" | sed -e 's/GERMANY\_//'`; ##Indetifying Extract File Name
mv $o $Actual_FILE_Name
RC=$?
chckRC $RC "Aborted while executing Renaming file to Atcual name Part"
echo "Completed the execution of Renaming file to Atcual name Part" >/dev/null
done;

##Renaming file to Atcual name
for p in `ls -1 GERMANY_Crs_*_CTL.txt`
do
Actual_FILE_Name=$( echo "$p" | sed -e 's/GERMANY\_//'); ##Indetifying Extract File Name
mv $p $Actual_FILE_Name
RC=$?
chckRC $RC "Aborted while executing Renaming file to Atcual name Part"
echo "Completed the execution of Renaming file to Atcual name Part" >/dev/null
done;
##set +x
###End of Script

cat GERMANY_Obligor_filter_ctl
##Obligor information file
##For new obligor for search contion add "&& $colpos !=xxxxxx" in format
##make sure all condition values in single line
$colpos != 228070 && $colpos != 228071 && $colpos != 228072 && $colpos != 228073 && $colpos != 228074 && $colpos != 228075 && $colpos != 228076 && $colpos != 228077 && $colpos != 228078 && $colpos != 228079 && $colpos != 228080 && $colpos != 228081 && $colpos != 228082 && $colpos != 228083 && $colpos != 228084 && $colpos != 228085 && $colpos != 228086 && $colpos != 228196 && $colpos != 228299

cat crt_extracts_branch_gsw_cntl

################################################################################
#
#  carrs_extracts_branch_gswid_cntl
#
################################################################################
#
# carrs_extracts_branch_cntl is a control file containing carrs extract file names
# and column position of Branch nbr in that extract file
#
################################################################################
#
# Column Definition:
# 1st Column     Carrs Extract file name
# 2nd Column     Colump position of "Branch Number"
# 4th Column     Colump position of "GSW ID or Obligor ID"
##############################################################################################################################################
#Carrs Extract File                                             Column Position     Control File column position	GSWID Column Possition
##############################################################################################################################################
Crs_Assessment_Extract.txt                                       4                     0-17					3
Crs_Involved_Party_Risk_Rating_Extract.txt                       4                        0					3
Crs_Model_Input_Extract.txt                                      7                     0-12					6			
Crs_Involved_Party_Watchlist_Extract.txt                         2                        0					1
Crs_Involved_Party_Default_Extract.txt                           2			0-9					1
Crs_AR_X_IP_Extract.txt                                          3                        0					4
Crs_Oprtnl_Risk_Assessment_Extract.txt                           4                        0					3
Crs_Financial_Resource_Item_Extract.txt                         11                      0-5					8
#Crs_County_Extract.txt                                           5                        0
#Crs_State_Extract.txt                                            4                        0
#Crs_City_Extract.txt                                             6                        0
Crs_Involved_Party_Involved_Party_Extract.txt                    6                        0					1
Crs_Customer_Obligor_Extract.txt                                 6                        0					15	
#Crs_Post_Addr_Extract.txt                                       13                        0
Crs_Involved_Party_Post_Address_Extract.txt	                 23                       0					3
#Crs_IP_Product_Plan_Grp_Rating_Extract.txt                       8                        0					1
Crs_Financial_Resource_Item_Hdr_Extract.txt                      8                        0					5
Crs_IP_Credit_Facility_Rating_Extract.txt                        2                     0-10					1
Crs_Txn_Ev_Dlr_Charges_Extract.txt                               1                     0-10					2

command_construction=$( echo "cat $SOURCE_DIR/${FILENAME[$x]}  | awk -F\"|\" -v colpos=\"${COLPOS[$x]}\"  '{if ("$ifcondition_val") { print \$0 }}'  > $NEWFILENAME")

cat GERMANY_Obligor_filter_ctl