Shell Programming and Scripting

#!/bin/ksh

#[[ -f ./.profile ]] && . ./.profile 2>/dev/null

if test -f '.profile'; then . ./.profile; fi;

#. .profile

LOG_DIR=/app/rpx/jobs/scripts/just/logs
  sendEmail()
    {
        pzCType="$1"; pzTitle="$2"; pzMsg="$3"; pzFrom="$4"; pzTo="$5"; pzFiles="$6"; pzReplyTo="$7"
        (
          echo "From: $pzFrom\nTo: $pzTo\nSubject: $pzTitle${pzReplyTo:+\nReply-To: $pzReplyTo}"

              [[ -n "$pzCType" ]] && echo "Content-Type: $pzCType"

              echo
               echo "$pzMsg"
                  [[ -n "$pzFiles" ]] &&
                  echo &&
                  for pzFile in $pzFiles
                  do
                    [[ -f "$pzFile" ]] && uuencode "$pzFile" "$pzFile"
                  done

                ) | mail "$pzTo"
          }

## all pending subscriber .

`pending=sqlplus -s pag_app/abcdef@prpx1-vip.unix.gsm=1900.org:7779/prpx.unix.gsm1900.org <<EOF
set pagesize 0;
SET LINESIZE 180;
SET MARKUP HTML ON SPOOL ON PREFORMAT OFF ENTMAP ON -
HEAD "<TITLE>Pending</TITLE> -
<STYLE types='text/css'> -
<!-- BODY {background: #FFFFC6}--> -
</STYLE>" -
BODY "TEXT='#FF00Ff'" -
TABLE "WIDTH='90%' BORDER='5'"

SPOOL report.html

select msisdn,status_changed_time,rate_plan_id,status from subscriber where status = 'P' and status_changed_time < sysdate order b
y status_changed_time  desc;

SPOOL OFF
EOF`

activating=`sqlplus -s pag_app/abcdef@prpx1-vip.unix.gsm1900.org:7779/prpx.unix.gsm1900.org <<EOF
set feedback off;
set heading off;
set trimspool on;
set pagesize 0;
SET LINESIZE 180;

select msisdn,status_changed_time,rate_plan_id,status from subscriber where status = 'I' and status_changed_time < sysdate order b
y status_changed_time  desc;
EOF`

final="Pending
$pending

Activating
$activating"

sendEmail '' "Pending_Activating" "$final" 'ankit.gupta92@gmail.com' 'ankit.gupta92@gmail.com' " " ' '

echo $final > $LOG_DIR/pending_`date +%d%m%y`.log

`pending=sqlplus -s pag_app/abcdef@prpx1-vip.unix.gsm=1900.org:7779/prpx.unix.gsm1900.org <<EOF

pending=`sqlplus -s pag_app/abcdef@prpx1-vip.unix.gsm=1900.org:7779/prpx.unix.gsm1900.org <<EOF