Shell Programming and Scripting

Location.txt
Chennai,salem, tirupur,banglore, trichy,pondichery.

#!/bin/sh
for location in $(`cat /home/arun/location.txt`)
do
if [[ $store="chennai" || $store="banglore"]]
then
echo "execute 1st step for   $i";
comand
elif [[ $store ="salem" ||$store ="trichy"  || $store="pondichery" ]]
command
echo "execute 2nd step for  $i";
elif [[ $store ="tiruput" ]]
echo "execute 3rd step for $i";
command
fi
fi
fi
done

Input : 
chennai
salem 
banglore
trichy 
tripur

Chennai or Banglore -> Specific Oracle function wil be called.
Salem,Trichy,Pondi  -> specific oracle function will be called.
Tirupur                  -> Specific oracle function wiill be called.

while read location; do
  if [[ $location = "this" ]] || [[ $location = "that" ]]; then
    ..
  fi
done < "/home/arun/location.txt"

WHEN (LOCATION = 'CHENNAI' OR  LOCATION = 'BANGLORE')
ID:=GET_LOC.HIGHPRIORITY(Location,Sales)
              
WHEN (LOCATION = 'SALEM' OR  LOCATION = 'TRICHY' or LOCATION=Pondichery)

ID:=GET_LOC.MEDIUMPRORITY(Location,Sales)
               (:lOCATION, :SALES);

WHEN (LOCATION = 'TRIUPUR)

ID:=GET_LOC.LOWPRORITY(Location,Sales)
               (:lOCATION, :SALES);

cat function_check
chennai
salem
banglore
trichy
tripur
Punjab

cat function_check.ksh
chennai_blr () {
                                echo "you are in function of Chennai and Bangalore. here."
               }
Salem_Trichy_Pondi  () {
                                        echo "You are in function of Salem,Trichy,Pondi here."
                       }
Tirupur () {
                echo "you are in function of Tirupur."
           }
while read file
do
        if [[ "$file" == "chennai" || "$file" == "banglore" ]]
        then
                chennai_blr
        elif [[ "$file" == "salem" || "$file" == "trichy" || "$file" == "pondi" ]]
        then
                Salem_Trichy_Pondi
        elif [[ "$file" == "tripur" ]]
        then
                Tirupur
        else
                echo "You are out of chennai, blr, Salem_Trichy_Pondi and Tirupur, seems you are in $file"
        fi
done < "function_check"

 ./function_check.ksh
you are in function of Chennai and Bangalore. here.
You are in function of Salem,Trichy,Pondi here.
you are in function of Chennai and Bangalore. here.
You are in function of Salem,Trichy,Pondi here.
you are in function of Tirupur.
You are out of chennai, blr, Salem_Trichy_Pondi and Tirupur, seems you are in Punjab

 
CASE 1: 
(LOCATION = 'chennai'| LOCATION = 'Banglore')
:VALUE:=LOCATION_COUNT.CHENNAI_BANG
               (&LOCATION,&SALES);
case 2: 
(LOCATION ='SALEM'|LOCATION = 'TRICHY' |LOCATION = 'PONDI')
:VALUE:=LOCATION_COUNT.SAL_TRICHY_PONDI
               (&LOCATION,&SALES);
 
case 3:
(LOCATION = 'TIRUPUR')
:VALUE:=LOCATION_COUNT.GET_TIRUP
               (&LOCATION,&SALES);

cat function_check.ksh
chennai_blr () {
        VALUE=`sqlplus -S /NOLOG << EOF
        CONNECT dbs/passwd@dbtod
        SET head off
        SET serveroutput on
        select LOCATION_COUNT.CHENNAI_BANG
               (&LOCATION,&SALES) from dual;
        exit;
EOF
               }
 
Salem_Trichy_Pondi  () {
VALUE=`sqlplus -S /NOLOG << EOF
        CONNECT dbs/passwd@dbtod
        SET head off
        select :LOCATION_COUNT.SAL_TRICHY_PONDI
               (&LOCATION,&SALES) from dual;
        exit;
EOF`
 
     }
Tirupur () {
               VALUE=`sqlplus -S /NOLOG << EOF
        CONNECT dbs/passwd@dbtod
        SET head off
        select LOCATION_COUNT.GET_TIRUP
               (&LOCATION,&SALES); from dual;
        exit;
EOF`
           }
 
sales=1000;
while read location
do
        if [[ "$location" == "chennai" || "$location" == "banglore" ]]
        then
                chennai_blr
        elif [[ "$location" == "salem" || "$location" == "trichy" || "$location" == "pondi" ]]
        then
                Salem_Trichy_Pondi
        elif [[ "$location" == "tripur" ]]
        then
                Tirupur
        else
                echo "You are out of chennai, blr, Salem_Trichy_Pondi and Tirupur, seems you are in $file"
        fi
done < "function_check"

get_sales_info () {
  loc_code=$1
  sqlplus -S /NOLOG << EOF
  CONNECT dbs/passwd@dbtod
  SET head off
  select LOCATION_COUNT.$loc_code
     (&LOCATION,&SALES) from dual;
  exit;
EOF
}

while read location
do
  case $location in
    chennai|banglore)
      get_sales_info CHENNAI_BANG ;;
    salem|trichy|pondi)
      get_sales_info SAL_TRICHY_PONDI ;;
    tripur)
      get_sales_info TIRUP ;;
    *)
      echo "You are out of chennai, blr, Salem_Trichy_Pondi and Tirupur, seems you are in $location" ;;
  esac
done < "function_check"