auto_billing_DEMO.sh930907bk

/sh/auto_billing_DEMO.sh930907bk

http://cport.googlecode.com/
Korn Shell | 217 lines | 143 code | 18 blank | 56 comment | 17 complexity | a40275eb0f0643c3cccd0886082ac86a MD5 | raw file

#! /bin/ksh
. /osms_d1/ratedata/.profile
today=$(gawk 'BEGIN {printf("%s\n",strftime("%Y%m%d",systime()))}');
exec 1>$BILLING/DEMO/auto_billing$today.log
exec 2>$BILLING/DEMO/auto_billing$today.err
cd /osms_d1/ratedata/BILLING/DEMO 
echo "cd /osms_d1/ratedata/BILLING/DEMO" 

if [[ $1 = auto ]]; then
   today=$(gawk 'BEGIN {printf("%s\n",strftime("%Y%m%d",systime()))}');
elif (( $#!=4 )); then
   echo "***********************************************************************"
   echo "*  Author: Jack Fang                                                  *"
   echo "*                                                                     *"
   echo "*  Auto billing                                                       *"
   echo "*  auto_billing.sh billing_period billing_cycle billing_mode onestop  *"
   echo "*  auto_billing.sh 200110 02 1 nostop/stop                            *"
   echo "*                                                                     *"
   echo "*                                                                     *"
   echo "***********************************************************************"
   exit
elif (( $#==4 )); then
   billing_period=$1
   billing_cycle=$2
   billing_mode=$3
   onestop=$4
   if [[  $billing_mode -gt 5 || $billing_mode -lt 1  ]]; then
      echo billing_period is $billing_period
      echo billing_cycle is $billing_cycle
      echo billing_mode is $billing_mode
      echo "billing_mode ERROR!!"
      echo onestop is $onestop
      exit
   fi
   if [[ "$onestop" != "stop" && "$onestop" != "nostop" ]]; then
      echo "onestop is" $onestop "no definition ERROR!!"
      exit;
   fi
fi
echo billing_period is $billing_period
echo billing_cycle is $billing_cycle
echo billing_mode is $billing_mode
echo onestop is $onestop

function auto_exit {
   onestop=$1
   if [[ $onestop = stop ]]; then
     echo stop
     exit;
   elif [[ $onestop = nostop ]]; then
     echo nostop and continue next step
   else
     echo "no definition";
   exit;
   fi
}

##echo "sqlplus fibills/billsdemo@demo @auto_pre.sql "$billing_period" "$billing_cycle" "
##sqlplus fibills/billsdemo@demo @auto_pre.sql $billing_period $billing_cycle
##echo "auto_pre.sql END"

ProcPhoneMsg.sh Phone_Msg.txt PhoneFile.txt "!!DEMO TEST!!"

###====================================================================#
###                                                                    #
###            STEP 1 : billing CHG_GEN process                        #
###                                                                    #
###====================================================================#
if [[ $billing_mode -eq 1 ]]; then
echo "chg_gen $billing_cycle 1>chg_gen"$billing_period"bc"$billing_cycle".log \
2>chg_gen"$billing_period"bc"$billing_cycle".err"
$BIN/chg_gen $billing_cycle 1>chg_gen"$billing_period"bc"$billing_cycle".log \
2>chg_gen"$billing_period"bc"$billing_cycle".err
ProcPhoneMsg.sh Phone_Msg.txt PhoneFile.txt "DEMO STEP1 END"
 auto_exit $onestop;
fi
#
###====================================================================#
###                                                                    #
###            STEP 2 : billing CHG_REC process                        #
###                                                                    #
###====================================================================#
if [[ $billing_mode -le 2 ]]; then
echo "chg_rec $billing_cycle 1>chg_rec"$billing_period"bc"$billing_cycle".log \
2>chg_rec"$billing_period"bc"$billing_cycle".err"
$BIN/chg_rec $billing_cycle 1>chg_rec"$billing_period"bc"$billing_cycle".log \
2>chg_rec"$billing_period"bc"$billing_cycle".err
ProcPhoneMsg.sh Phone_Msg.txt PhoneFile.txt "DEMO STEP2 END"
 auto_exit $onestop;
fi
#
###====================================================================#
###                                                                    #
###            STEP 3 : billing BILL_GEN process                       #
###                                                                    #
###====================================================================#
if [[ $billing_mode -le 3 ]]; then
echo "bill_gen $billing_cycle 1>bill_gen"$billing_period"bc"$billing_cycle".log \
2>bill_gen"$billing_period"bc"$billing_cycle".err"
$BIN/bill_gen $billing_cycle 1>bill_gen"$billing_period"bc"$billing_cycle".log \
2>bill_gen"$billing_period"bc"$billing_cycle".err
ProcPhoneMsg.sh Phone_Msg.txt PhoneFile.txt "DEMO STEP3 END"
 auto_exit $onestop;
fi
#
###====================================================================#
###                                                                    #
###            STEP 4 : billing GUI_GEN process                        #
###                                                                    #
###====================================================================#
if [[ $billing_mode -le 4 ]]; then
echo "gui_gen $billing_cycle 1>gui_gen"$billing_period"bc"$billing_cycle".log \
2>gui_gen"$billing_period"bc"$billing_cycle".err"
$BIN/gui_gen $billing_cycle 1>gui_gen"$billing_period"bc"$billing_cycle".log \
2>gui_gen"$billing_period"bc"$billing_cycle".err
ProcPhoneMsg.sh Phone_Msg.txt PhoneFile.txt "DEMO STEP4 END"
 auto_exit $onestop;
fi
#
###====================================================================#
###                                                                    #
###            STEP 5 : billing renew_mbl process                      #
###                                                                    #
###====================================================================#
if [[ $billing_mode -le 5 ]]; then
echo "renew_mbl $billing_cycle 1>renew_mbl"$billing_period"bc"$billing_cycle".log \
2>renew_mbl"$billing_period"bc"$billing_cycle".err"
$BIN/renew_mbl $billing_cycle 1>renew_mbl"$billing_period"bc"$billing_cycle".log \
2>renew_mbl"$billing_period"bc"$billing_cycle".err
ProcPhoneMsg.sh Phone_Msg.txt PhoneFile.txt "DEMO STEP5 END"
 auto_exit $onestop;
fi
#
###====================================================================#
###                                                                    #
###            STEP 6 : osmsbill.pc process                            #
###                                                                    #
###====================================================================#
cnt=`sqlplus -s "fibills/billsdemo@demo" <<END
set pagesize 0 feedback off verify off heading off echo off
select count(*) from cw_tb_billing_cycle_his
where billing_period = '$billing_period'
and billing_cycle = '$billing_cycle'
and prod_cde = '5PRT'
and comp_status = 'Y';
exit;
END`
if (( $cnt==1 )); then
   echo "successful"

####    2003/01/21 no update start line   ######
# ProcPhoneMsg.sh Phone_Msg.txt PhoneFile.txt "Update CDR_INDIC_ORG=Y !!"
# sqlplus -s "fibills/billsdemo@demo" <<END
# update cw_tb_subscr_mbl set CDR_INDIC_ORG = 'Y' where billing_cycle = '$billing_cycle'
#   and subscr_nbr not in ( select REP_SUBSCR_NBR from cw_tb_centrex_master ) ;
# COMMIT;
# exit;
# END
####    2003/01/21 no update end line  ######

   echo "osmsbill $billing_cycle $billing_period G\
 1>osmsbill"$today".log 2>osmsbill"$today".err"
   ProcPhoneMsg.sh Phone_Msg.txt PhoneFile.txt "DEMO osmsbill.pc Begin!!"
   $BIN/osmsbill $billing_cycle $billing_period G\
 1>osmsbill$today.log 2>osmsbill$today.err
   ProcPhoneMsg.sh Phone_Msg.txt PhoneFile.txt "DEMO osmsbill.pc END!!"

#
##
###   2003/03/14 add get_sample    ###
ProcPhoneMsg.sh Phone_Msg.txt PhoneFile.txt "DEMO Update CDR_INDIC_ORG=Y !!"

sqlplus -s "fibills/billsdemo@demo" <<END
update cw_tb_subscr_mbl set CDR_INDIC_ORG = 'Y' where billing_cycle = '$billing_cycle'
   and subscr_nbr not in ( select REP_SUBSCR_NBR from cw_tb_centrex_master ) ;
COMMIT;
exit;
END

ProcPhoneMsg.sh Phone_Msg.txt PhoneFile.txt "get_sample start !!"

cd /osms_d1/ratedata/BILLING/DEMO/tmp/
/usr/bin/cd /osms_d1/ratedata/BILLING/DEMO/tmp/
echo "get sample for billing check START!!"
/usr/bin/date
###   get_sample   ### 
/osms_d1/ratedata/BILLING/DEMO/tmp/get_sample_subscr.sh  $billing_period $billing_cycle  1>get_sample"$billing_period"bc"$billing_cycle".log  2>get_sample"$billing_period"bc"$billing_cycle".err
echo "get sample for billing check END!!"
/usr/bin/date

cnt_cust01 samp"$billing_period"_bc"$billing_cycle"_*.txt.dtl 1>cnt"$billing_period"bc"$billing_cycle".txt

cd /osms_d1/ratedata/BILLING/DEMO/
/usr/bin/cd /osms_d1/ratedata/BILLING/DEMO/
ProcPhoneMsg.sh Phone_Msg.txt PhoneFile.txt "DEMO get_sample END !!"
###
##
#   

else 
   echo "osmsbill.pc fail!!"
   ProcPhoneMsg.sh Phone_Msg.txt PhoneFile.txt "DEMO billing steps ERROR!!"
fi
echo "auto_billing_DEMO END!!"



###  20030615 add invoice_autovoid   ###
sqlplus "fibills/billsdemo@demo" <<END
prompt running 'CW_PC_INVOICE_AUTOVOID'
begin
CW_PC_INVOICE_AUTOVOID('','','','FMB','A');
end;
/
exit;
END