#!/bin/ksh Trackfile=`date "+%Y%m%d"` echo $Trackfile esc="" RED="${esc}[31m"; GREEN="${esc}[32m"; YELLOW="${esc}[33m" BLUE="${esc}[34m" NORMAL="${esc}[0m"; HEADING="${esc}[1;37;44m" BOLD="${esc}[1m" UNDERLINE="${esc}[4m" WHITE='\e[0;37m'; #UI=`id -u` export UI=`id -u` echo $UI s=`tput smso` b=`tput bold` p=`tput rmso` bold='tput smso' offbold='tput rmso' ############################################################################################################### while true do clear print "\n" print "\n" print "\n" tput clear; #print $RED"\t\t\t\t\t DATE :" print $RED"\t\t\t\t\t\t\t `date`" print "\n" #echo $GREEN"#############################################################################################################" #print $GREEN"\t\t\t #### #### ###### ##### # ###### # # #### # ## ### ##### ##### ####" #print $GREEN"\t\t\t # # # # # # # # # # # # # # # # # # # # #" #print $GREEN"\t\t\t # # #### #### # # #### # # #### # # # ##### # # #### # #" #print $GREEN"\t\t\t # # # # # # # # # # # # # # # # # # # #" #print $GREEN"\t\t\t # # #### # # ##### ##### ###### ### # ##### ### # # ##### ##### # #" #print $GREEN"\t\t\t############################################################################################################" print $BOLD$GREEN"\t\t\t\t\t***** ***** ******* **** **** * * * ***** *****" print $BOLD$GREEN"\t\t\t\t\t* * * * * * * * * * * * * " print $BOLD$GREEN"\t\t\t\t\t**** ***** * * * * * * ** **** *****" print $BOLD$GREEN"\t\t\t\t\t* * * * * * * * * ** * *" print $BOLD$GREEN"\t\t\t\t\t* * ***** * **** **** ****** ** ***** *****" cd $HOME/Application/Exec/Run stty echo trap "echo CTRL-C cannot be used " 2 trap "echo CTRL-Z cannot be used " 20 print "\n" tput rev tput sgr0 # print "---------------------------------------------------------------------------------------" print "\n" print $YELLOW"\t\t\t\t\t\t 1] PASSWORD CHANGE 2] EOD_BOD " print $YELLOW"\t\t\t\t\t\t \t\t\t " print $YELLOW"\t\t\t\t\t\t 3] FILE UPLOAD STATUS 4] ORDER SVR RESTART " print $YELLOW"\t\t\t\t\t\t \t\t\t " print $YELLOW"\t\t\t\t\t\t 5] BRODCAST STATUS 6] " print $YELLOW"\t\t\t\t\t\t \t\t\t " print $YELLOW"\t\t\t\t\t\t\t 0) GO TO COMMAND PROMPT \t\t" tput sgr0 printf "\n" print "\n" print "\n" echo " " tput cup 25 10 print "\n" print "\n" print "\t\t\t\t\t\t Enter Choice [ 1 - 6 ] : \c\c" read OPTION print "---------------------------------------------------------------------------------------" case "$OPTION" in 1) clear while true do clear # Move cursor to screen location X,Y (top left is 0,0) UpdateFlag=0 # Set reverse video mode # Set reverse video mode mysql -h $MYSQL_HOST -u presql -ppresql -D $MYSQL_SCHEMA -e "select EAM_EXM_EXCH_ID AS EXCHANGE ,EAM_EXCH_USER_ID AS 'USER ID' ,EAM_BROKER_ID AS 'BROKER ID' ,EAM_BOX_ID AS 'PRIMARY BOX ID',EAM_BOX_ID_SEC AS 'SECONDARY BOX ID',EAM_SEGMENT AS SEGMENT ,EAM_VERSION_NO AS VERSION, aes_decrypt(EAM_OLD_PASSWORD,'rupee123') AS OLD_PASSWORD , aes_decrypt(EAM_NEW_PASSWORD,'rupee123') AS NEW_PASSWORD from EXCH_ADMINISTRATION_MASTER ; " tput rev echo "PASSWORD RESET" tput sgr0 print "\n" print "\t\t\t1) NSE CM" print "\n" print "\t\t\t2) NSE FO" print "\n" print "\t\t\t3) NSE CURRENCY" print "\n" print "\t\t\t4) BSE CM" print "\n" print "\t\t\t5) MCX COMM" print "\n" print "\t\t\t0) PREVIOUS MENU" print "\n" # Set bold mode tput bold print "\t\t\tEnter your choice [1-4] " read OPTION case "$OPTION" in 1) print "\t\t\tEnter Your Reset Password : " read reset_string print "\t\t\tEnter Your New Password : " read new_pwd_string print "\t\t\tEnter Your UserID : " read NewUserId print "\t\t\tEnter Your Primary Box : " read PrimBox print "\t\t\tEnter Your Secondary Box : " read SecBox exchange="NSE" segment='E' echo ":$NewUserId:" UpdateFlag=1 ;; 2) print "\t\t\tEnter Your Reset Password : " read reset_string print "\t\t\tEnter Your New Password : " read new_pwd_string print "\t\t\tEnter Your UserID : " read NewUserId print "\t\t\tEnter Your Primary Box : " read PrimBox print "\t\t\tEnter Your Secondary Box : " read SecBox exchange="NSE" segment='D' UpdateFlag=1 ;; 3) print "\t\t\tEnter Your Reset Password : " read reset_string print "\t\t\tEnter Your New Password : " read new_pwd_string print "\t\t\tEnter Your UserID : " read NewUserId print "\t\t\tEnter Your Primary Box : " read PrimBox print "\t\t\tEnter Your Secondary Box : " read SecBox exchange="NSE" segment='C' UpdateFlag=1 ;; 4) print "\t\t\tEnter Your Reset Password : " read reset_string print "\t\t\tEnter Your New Password : " read new_pwd_string print "\t\t\tEnter Your UserID : " read NewUserId print "\t\t\tEnter Your Primary Box : " read PrimBox print "\t\t\tEnter Your Secondary Box : " read SecBox exchange="BSE" segment='E' UpdateFlag=1 ;; 0) break ;; *) print "\n" print "\t\tInvalid Option.... Please Press ENTER to continue" read key0 ;; esac if test $UpdateFlag -eq 1 ;then echo " ENTER KEY TO UNLOCK " stty -echo read passwd stty echo if test "$passwd " = "justdoit "; then mysql -h $MYSQL_HOST -u $MYSQL_USER -p$PASS -D $MYSQL_SCHEMA -e "update EXCH_ADMINISTRATION_MASTER set EAM_OLD_PASSWORD = IF ( '$reset_string' = '',EAM_OLD_PASSWORD , aes_encrypt('$reset_string','rupee123')) , EAM_NEW_PASSWORD = IF ( '$new_pwd_string' = '',EAM_NEW_PASSWORD , aes_encrypt('$new_pwd_string','rupee123')),EAM_EXCH_USER_ID = IF('$NewUserId' = '',EAM_EXCH_USER_ID,'$NewUserId'),EAM_BOX_ID = IF('$PrimBox' = '',EAM_BOX_ID,'$PrimBox'),EAM_BOX_ID_SEC = IF('$SecBox' = '',EAM_BOX_ID_SEC,'$SecBox') where EAM_EXM_EXCH_ID = '$exchange' AND EAM_SEGMENT = '$segment';" else echo " Wrong Password ....." fi; fi; done;; ######################################################################################################## 2) clear while true do clear mysql -h $MYSQL_HOST -u presql -ppresql -D $MYSQL_SCHEMA -e "select BP_EXCH_ID,BP_SEGMENT,BP_BATCH_NAME,BP_MODE,BP_SCHEDULE_TIME,BP_LAST_RUN_DATE,BP_NEXT_SCHEDULE_DATE,BP_REMARKS,BP_DATE,BP_UPDATED_BY from BATCH_PROCESS WHERE BP_BATCH_NAME='EOD_BOD';" print "\t\t\t" echo -e $BOLD$UNDERLINE"\t\t\t EOD_BOD" echo $NORMAL"" # print "\n" # print "\n" print "\n" print "\t\t\t1) CHECK EXCH MARKET MASTER" print "\n" print "\t\t\t2) UPDATE MARKET CLOSE [*]" print "\n" print "\t\t\t3) UPDATE MARKET OPEN" print "\n" print "\t\t\t4) CALL PR_COMEODBODAUTOMATIC()" print "\n" print "\t\t\t5) SELECT * FROM EQ ORDERS" print "\n" print "\t\t\t6) SELECT * FROM DRV ORDERS" print "\n" print "\t\t\t7) SELECT * FROM COMM ORDERS" print "\n" print "\t\t\t0) PREVIOUS MENU" print "\n" print "\n" print "\t\t\t Enter Choice : \c" read OPTION_10 case "$OPTION_10" in 1) clear mysql -h $MYSQL_HOST -u presql -ppresql -D $MYSQL_SCHEMA -e "select EMM_MKT_TYPE,EMM_EXM_EXCH_ID,EMM_EXCH_SEG,EMM_MKT_TYPE_NO,EMM_MKT_DESCRIPTION,EMM_STATUS,EMM_EXCH_MKT_START_DATE_TIME from EXCH_MKT_MASTER;" print "Please Press ENTER to continue..............\c" sleep 3 ; read key4 echo $NORMAL"" ;; 2) clear echo "$date" sleep 5 mysql -h $MYSQL_HOST -u presql -ppresql -D $MYSQL_SCHEMA -e "set SQL_SAFE_UPDATES=0;" mysql -h $MYSQL_HOST -u presql -ppresql -D $MYSQL_SCHEMA -e "UPDATE EXCH_MKT_MASTER SET EMM_STATUS='2';" mysql -h $MYSQL_HOST -u presql -ppresql -D $MYSQL_SCHEMA -e "select EMM_MKT_TYPE,EMM_EXM_EXCH_ID,EMM_EXCH_SEG,EMM_MKT_TYPE_NO,EMM_MKT_DESCRIPTION,EMM_STATUS,EMM_EXCH_MKT_START_DATE_TIME from EXCH_MKT_MASTER;" print "Please Press ENTER to continue..............\c" sleep 3 ; read key4 echo $NORMAL"" ;; 3) clear mysql -h $MYSQL_HOST -u presql -ppresql -D $MYSQL_SCHEMA -e "set SQL_SAFE_UPDATES=0;" mysql -h $MYSQL_HOST -u presql -ppresql -D $MYSQL_SCHEMA -e "UPDATE EXCH_MKT_MASTER SET EMM_STATUS='1';" mysql -h $MYSQL_HOST -u presql -ppresql -D $MYSQL_SCHEMA -e "select EMM_MKT_TYPE,EMM_EXM_EXCH_ID,EMM_EXCH_SEG,EMM_MKT_TYPE_NO,EMM_MKT_DESCRIPTION,EMM_STATUS,EMM_EXCH_MKT_START_DATE_TIME from EXCH_MKT_MASTER;" print "Please Press ENTER to continue..............\c" sleep 3 ; read key4 echo $NORMAL"" ;; 4) clear mysql -h $MYSQL_HOST -u presql -ppresql -D $MYSQL_SCHEMA -e "Call PR_COMEODBODAUTOMATIC()" print "Please Press ENTER to continue..............\c" sleep 3 ; read key4 echo $NORMAL"" ;; 5) clear mysql -h $MYSQL_HOST -u presql -ppresql -D $MYSQL_SCHEMA -e "select EQ_ORDER_NO,EQ_LEG_NO,EQ_SERIAL_NO,EQ_SCRIP_CODE,EQ_SYMBOL,EQ_EXCH_ID,EQ_SEGMENT,EQ_ENTITY_ID,EQ_EXCH_ORDER_NO,EQ_CLIENT_ID,EQ_BUY_SELL_IND,EQ_MSG_CODE,EQ_ORD_STATUS,EQ_INTERNAL_ENTRY_DATE,EQ_EXCH_ORDER_TIME,EQ_LOC_CODE from EQ_ORDERS;" mysql -h $MYSQL_HOST -u presql -ppresql -D $MYSQL_SCHEMA -e "select count(*) EQ_ORDER_NO from EQ_ORDERS;" print "Please Press ENTER to continue..............\c" sleep 3 ; read key4 echo $NORMAL"" ;; 6) clear mysql -h $MYSQL_HOST -u presql -ppresql -D $MYSQL_SCHEMA -e "select DRV_ORDER_NO,DRV_SERIAL_NO,DRV_MULTILEG_ORD_TYPE,DRV_LEG_NO,DRV_SYMBOL,DRV_SCRIP_CODE,DRV_EXCH_ID,DRV_SEGMENT,DRV_ENTITY_ID,DRV_EXCH_ORDER_NO,DRV_CLIENT_ID,DRV_BUY_SELL_IND,DRV_MSG_CODE,DRV_STATUS,DRV_INTERNAL_ENTRY_DATE from DRV_ORDERS;" mysql -h $MYSQL_HOST -u presql -ppresql -D $MYSQL_SCHEMA -e "select count(*) DRV_ORDER_NO from DRV_ORDERS;" print "Please Press ENTER to continue..............\c" sleep 3 ; read key4 echo $NORMAL"" ;; 7) clear mysql -h $MYSQL_HOST -u presql -ppresql -D $MYSQL_SCHEMA -e "select COMM_ORDER_NO,COMM_SERIAL_NO,COMM_MULTILEG_ORD_TYPE,COMM_LEG_NO,COMM_SCRIP_CODE,COMM_EXCH_ID,COMM_SEGMENT,COMM_ENTITY_ID,COMM_EXCH_ORDER_NO,COMM_CLIENT_ID,COMM_BUY_SELL_IND,COMM_MSG_CODE,COMM_STATUS,COMM_INTERNAL_ENTRY_DATE,COMM_INSTRUMENT_NAME from COMM_ORDERS;" mysql -h $MYSQL_HOST -u presql -ppresql -D $MYSQL_SCHEMA -e "select count(*) COMM_ORDER_NO from COMM_ORDERS;" print "Please Press ENTER to continue..............\c" sleep 3 ; read key4 echo $NORMAL"" ;; 0) break;; *) print "\n" print "\t\tInvalid Option.... Please Press ENTER to continue" read key0 ;; esac done;; ######################################################################################################################### 3) clear mysql -h $MYSQL_HOST -u presql -ppresql -D $MYSQL_SCHEMA -e "select * from RMS_PROCESS_LOG ORDER BY PROCESS_DATE DESC;" print "Please Press ENTER to continue..............\c" sleep 3 ; read key4 echo $NORMAL"" ;; ########################################################################################################## 4) clear cd $HOME/Application/Exec/MonitoringTools/ ./Ord_svr.sh print "Please Press ENTER to continue..............\c" read key4 echo $NORMAL"" clear ;; ############################################################################################################################## 5) clear cd $HOME/Application/Exec/MonitoringTools/ ./Broadcast_New.sh print "Please Press ENTER to continue..............\c" read key4 echo $NORMAL"" clear ;; ################################################################################################################################ 6) clear print "\n" print "Please Press ENTER to continue..............\c" read key4 echo $NORMAL"" ;; ############################################################################################################################### 7) clear echo $NORMAL"" print "\n\t\t\t\t\tPlease Press ENTER to continue" read key2 clear ;; ################################################################################################################################ 8) clear print "\n" print "Please Press ENTER to continue..............\c" read key4 echo $NORMAL"" ;; ############################################################################################################################### 0) echo `date` WARNING...................... Input Got to go in Command Prompt >> $HOME/Application/Exec/MonitoringTools/Log/log.InputTrack_$Trackfile echo " ENTER KEY TO UNLOCK " stty -echo read passwd stty echo if test "$passwd " = "rsdevteam "; then clear; echo $NORMAL"" exit ; clear; echo $NORMAL"" fi; ;; 99) ExitProcess;; *) echo `date` Invalid Option.... >> $HOME/Application/Exec/MonitoringTools/Log/log.InputTrack_$Trackfile print "\t\tInvalid Option.... Please Press ENTER to continue" read key2 echo $NORMAL"" esac trap 2 trap 20 done;