0917 统计内存库话单数量脚本

#!/usr/bin/ksh

curworkdir="./RentStatus2"
datenow=`date +%Y%m%d000000`

if [ ! -d ${curworkdir} ]; then
  mkdir ${curworkdir}
fi

PRERENTORDERNUMS=`echo "select * from SEVENT_FLOW_CTRL where EXETIME = '${datenow}'" | mdsql | sed '4p' -n | awk -F \| '{print $12}'`
RENTEDORDERNUMS=`echo "select * from SEVENT_FLOW_CTRL where EXETIME = '${datenow}'" | mdsql | sed '4p' -n | awk -F \| '{print $13}'`

if [ "X" = "X$PRERENTORDERNUMS" -o "X0" = "X$PRERENTORDERNUMS" ]; then
  echo -1 > $curworkdir/RentStatus.txt
else
  echo "$RENTEDORDERNUMS|$PRERENTORDERNUMS" > $curworkdir/RentStatus.txt
fi

echo "Get Rent Record Success."

 

num=`echo "select * from sysdb.mdsp_t_zeroprod;" |sqlplus userdb/userdb@USERDB| sed '16p' -n | awk -F'|' '{print $1}'`