Shell Programming and Scripting

mysql> select * from kontak_group;
+-----------------------------+----------+-------------+-------------------------------+
| group_name                  | group_ID | sms_keyword | email_group                   |
+-----------------------------+----------+-------------+-------------------------------+
| IT Dev                      |        1 | IT          | it.patra@acme.com      |
| IR & Complain               |        2 | IRC         | irc.patra@acme.com     |
| Payroll & Travel Management |        3 | PTM         | ptm.patra@acme.com |
| Adm & Document              |        4 | ADM         | adm.patra@acme.com     |
| Business Support            |        5 | BS          | bs.patra@acme.com      |
+-----------------------------+----------+-------------+-------------------------------+

KRITERIA=$(mysql -u root --password=123456 smsd -e "select concat_ws ( '', group_concat(sms_keyword separator '|') ) from kontak_group")

CHECKER=$(mysql -u root --password=123456 smsd -e "SELECT ID, SenderNumber, TextDecoded FROM inbox ORDER BY ReceivingDateTime DESC LIMIT 1  \G" |egrep -w '$KRITERIA' 2> /dev/null)

SPAM=$(mysql -uroot -p123456 smsd -e "INSERT INTO inbox_spam SELECT * FROM inbox WHERE TextDecoded NOT regexp ( select concat_ws ( '', '^(', group_concat(sms_keyword separator '|'), ').*' ) from kontak_group)")

echo $CHECKER | grep ADM > /dev/null
if [ $? -eq 0 ]
then
	message=$message2
	for address in $ADMemails
        do
	      echo $message | mailx -s "$ADMSubject" -a From:$SENDER $EMAIL_ADDRESS
	done
	echo " email sent to ADM contacts"
else
	$SPAM
fi

echo $CHECKER | grep IRC > /dev/null
if [ $? -eq 0 ]
then
	message=$message2
	for address in $HCSemails
        do
	      echo $message | mailx -s "$IRCSubject" -a From:$SENDER $EMAIL_ADDRESS
	done
	echo " email sent to IRC contacts"
else
	$SPAM
fi

echo $CHECKER | grep PTM > /dev/null
if [ $? -eq 0 ]
then
	message=$message2
	for address in $PTMemails
        do
	      echo $message | mailx -s "$PTMSubject" -a From:$SENDER $EMAIL_ADDRESS
	done
	echo " email sent to PTM contacts"
else
	$SPAM
fi

echo $CHECKER | grep BS > /dev/null
if [ $? -eq 0 ]
then
	message=$message2
	for address in $BSemails
        do
	      echo $message | mailx -s "$BSSubject" -a From:$SENDER $EMAIL_ADDRESS
	done
	echo " email sent to BS contacts"
else
	$SPAM
fi

IRC
PTM
ADM
BS

CNT=0    # use to check if any of the group errors are found
for GRP in $(< file.txt)
do
     echo $CHECKER | grep $GRP > /dev/null
     if [ $? -eq 0 ]
     then
           CNT=$(($CNT + 1))
           case $GRP in 
           ADM)message=$message2;;
           IRC) message=$message2;;
	   PTM) message=$message2;;
            BS) message=$message2;;
           esac
           eval SUBJECT=\$${GRP}subject
           eval ADDLIST=\$${GRP}emails
           for EMAIL_ADDRESS in $ADDLIST
           do
	        echo $message | mailx -s "$SUBJECT" -a From:$SENDER $EMAIL_ADDRESS
	   done
           echo " email sent to $GRP contacts"
           break
    fi
done

if [ $CNT -eq 0 ]
then
      $SPAM
fi

           eval SUBJECT=\$${GRP}subject
           eval ADDLIST=\$${GRP}emails

           SUBJECT=$mysql_code_to_grab_GRP_email_subject
           ADDLIST=$mysql_code_to_grab_GRP_email_address_list

GRP_email_subject=$(mysql -uroot -p123456 smsd -e "SELECT email_subject FROM kontak_group")
GRP_email_address_list=$(mysql -uroot -p123456 smsd -e "SELECT email_group FROM kontak_group")

CNT=0    # use to check if any of the group errors are found
for GRP in $(< file.txt)
do
     echo $CHECKER | grep $GRP > /dev/null
     if [ $? -eq 0 ]
     then
           CNT=$(($CNT + 1))
           case $GRP in 
           ADM)message=$message2;;
           IRC) message=$message2;;
	   PTM) message=$message2;;
            BS) message=$message2;;
           esac
#          eval SUBJECT=\$${GRP}subject
	   SUBJECT=$GRP_email_subject
#          eval ADDLIST=\$${GRP}emails
	   ADDLIST=$GRP_email_address_list
           for EMAIL_ADDRESS in $ADDLIST
           do
	        echo $message | mailx -s "$SUBJECT" -a From:$SENDER $EMAIL_ADDRESS
	   done
           echo " email sent to $GRP contacts"
           break
    fi
done

if [ $CNT -eq 0 ]
then
      $SPAM
fi

          ADM)message=$message2;;
           IRC) message=$message2;;
	   PTM) message=$message2;;
            BS) message=$message2;;

$(mysql_code_to_grab_sms_keywords) > file.txt

...
...
      message="$(mysql_code_to_grab_message_for_GRP)"
...
...

CNT=0    # use to check if any of the group errors are found
for GRP in $((mysql --skip-column-names -uroot -p123456 smsd -e "SELECT sms_keyword FROM kontak_group") > sms_keyword.txt)
do

echo $CHECKER | grep $GRP > /dev/null
     if [ $? -eq 0 ]
     then
           CNT=$(($CNT + 1))
           case $GRP in 
           ADM)message=$message2;;
           IRC) message=$message2;;
	   PTM) message=$message2;;
            BS) message=$message2;;
           esac
#          eval SUBJECT=\$${GRP}subject
	   SUBJECT=$GRP_email_subject
#          eval ADDLIST=\$${GRP}emails
	   ADDLIST=$GRP_email_address_list
           for EMAIL_ADDRESS in $ADDLIST