#!/bin/bash
. ~/.bashrc
time=$(date "+%Y-%m-%d %H:%M:%S")
echo "${time}"
f_day=`date +%Y%m01`
echo ${f_day}
sed "s/F_DAY/${f_day}/g" t_bi_cost_sql > t_bi_cost.sql
cat t_bi_cost.sql | gp_rd_h > PAY_TO_HY_DEPT_FEE.CSV
sed -i '$d' PAY_TO_HY_DEPT_FEE.CSV
#指定所要上传文件的日期
currentDay=`date +"%Y%m%d"`
#指定对端FTP服务器的用户名和密码
USERNAME=dyptest
PASSWD="dyp1992"
#指定目标FTP服务器的IP
IP=*.*.*.*
#上传文件到FTP服务器
ftp -ivn <<EOF
open $IP
user $USERNAME $PASSWD
put PAY_TO_HY_DEPT_FEE.CSV
quit
EOF
#判定文件是否上传成功
[ $? -eq 0 ] && echo "Upload $currentDay's files to romote FTP server successful." >> ./upload_file.log || echo "Upload files failed, please check." >> ./upload_file.log
tail ./upload_file.log
echo "ftp-upload.sh done"