/sh/auto_billing_DEMO.sh930907bk
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