利用sendEmail工具发送查询mysql结果

#!/bin/bash

#filename=sendemail.sh
SENDM=/usr/local/bin/sendEmail
SMTP='smtp.163.com'
User='test@163.com'
Password='test'
From='test@163.com'
To="$1"
Subject_utf8="$2"
Body_utf8="$3"
File="$4"
Subject_gb2312=`iconv -t UTF-8 -f GB2312 << EOF
$Subject_utf8
EOF`
[ $? -eq 0 ] && Subject="$Subject_gb2312" || Subject="$Subject_utf8"
Body_gb2312=`iconv -t UTF-8 -f GB2312 << EOF
$Body_utf8
EOF`
[ $? -eq 0 ] && Body="$Body_gb2312" || Body="$Body_utf8"
#${SENDM} -s "$SMTP" -f "$From" -t "$To" -u "$Subject" -m "$Body" -a ${File} -o message-content-type=text -o message-charset=utf8
${SENDM} -s "$SMTP" -xu "$User" -xp "$Password" -f "$From" -t "$To" -u "$Subject" -m "$Body" -a ${File} -o message-content-type=text -o message-charset=utf8 -o tls=n

#!/bin/bash

#filename=11day.sh
TIME=`date -d "-1 day" +%Y-%m-%d`
MYSQL=`which mysql`
USER=opstest
PWD='test'
PAT=/opt/product/sendEmail/sendEmail.sh
MLIST="18666666666@139.com,zhangsan@163.com"
$MYSQL -h192.168.1.101 -u$USER -p$PWD dccp -e "
SELECT 
  a.visit_day'日期',
  COUNT(terminal_sid)'日首页pv',
  COUNT(DISTINCT terminal_sid)'日首页uv'
FROM dccp_visit_special_log a
WHERE a.page_id = 'DAYCONTENT'
  AND a.visit_day=LEFT(DATE_SUB(NOW(),INTERVAL 1 DAY),10);


SELECT 
  a.visit_day'日期',
  COUNT(DISTINCT mobile)'日登录用户数'
FROM dccp_visit_special_log a
  WHERE a.page_id = 'DAYCONTENT'
  AND a.visit_day=LEFT(DATE_SUB(NOW(),INTERVAL 1 DAY),10);
" > /opt/product/sendEmail/${TIME}-11day.txt
File=/opt/product/sendEmail/${TIME}-11day.txt
echo "*****(${TIME}-11day)......11数据详见附件" | ${PAT} ${MLIST} "${TIME}-11day" -a ${File}
rm -f /opt/product/sendEmail/${TIME}-11day.txt