html格式发送邮件是什么,发送html格式邮件

1.使用工具sendEmail

参照博客 http://my.oschina.net/forrest420/blog/609874

下载安装sendEmail-v1.56

2.shell脚本如下:

#!/usr/bin/env bash

export LANG=zh_CN.UTF-8

EXE_DATE=`date -d "-1 day" +%Y-%m-%d`

EXE_MONTH=`date -d "-1 day" +%Y-%m`

[ "$#" -ne 0 ] && EXE_DATE=$1

[ "$#" -gt 1 ] && EXE_MONTH=$2

echo "EXE_DATE is ${EXE_DATE},EXE_MONTH is ${EXE_MONTH}"

current_bin_path="`dirname "$0"`"

oneProject_every_day_output_file=${current_bin_path}/oneProject_process_every_day.txt

oneProject_total_output_file=${current_bin_path}/oneProject_process_unitl_today.txt

oneProject_mail_output_file=${current_bin_path}/oneProject_mail.txt

#mysql_utf8文件的内容为:

#mysql -hxxx -uyyy -pzzz -Pqqqq -Dwwww --default-character-set=utf8 -N -e

EXE_SQL_PROD="`cat /etc/xxx/mysql_utf8 ` "

#计算每天的进度值process_of_every_day,截止到今日凌晨的总进度值process_of_today

get_day_of_month=`date -d "${EXE_DATE} -0 day" +%d`

get_month_of_year=`date -d "${EXE_DATE} -0 day" +%m`

get_year=`date -d "${EXE_DATE} -0 day" +%Y`

days_in_month=`cal ${get_month_of_year} ${get_year} | awk 'NF{out=$NF;}END{print out}'`

process_of_every_day=`gawk -v x=100 -v y=${days_in_month} 'BEGIN{printf "%.2f\n",x/y}'`

process_of_today=`gawk -v x=${process_of_every_day} -v y=${get_day_of_month} 'BEGIN{printf "%.2f\n",x*y}'`

echo "process_of_every_day is ${process_of_every_day},process_of_today is ${process_of_today}"

#导出oneProject每天的数据到文件中

sql="select day as '日期',

round(act_sale) as '交易额',

'${process_of_every_day}%' as '时间进度',

allcustomer as '顾客数',

ordernum as '订单数',

round(act_sale/ordernum) as '客单价',

concat(round((ordernum/uv)*100,2),'%') as '转化率',

pv as '点击量',

uv as '点击用户数',

concat(round(secondjumprate*100,2),'%') as '二跳率'

from aaa.bbb

where day between '${EXE_MONTH}-01' and '${EXE_DATE}' and

xxx='oneProject'

"

echo "sql is ${sql}"

${EXE_SQL_PROD} "${sql}" > ${oneProject_every_day_output_file}

#导出oneProject每天的数据到文件中 oneProject总计

sql="select '总计' as '日期',

round(sum(act_sale)) as '交易额',

'${process_of_today}%' as '时间进度',

sum(allcustomer) as '顾客数',

sum(ordernum) as '订单数',

round(sum(act_sale)/sum(ordernum)) as '客单价',

concat(round((sum(ordernum)/sum(uv))*100,2),'%') as '转化率',

sum(pv) as '点击量',

sum(uv) as '点击用户数',

concat(round(sum(secondjumprate*uv)/sum(uv)*100,2),'%') as '二跳率'

from aaa.bbb

where day between '${EXE_MONTH}-01' and '${EXE_DATE}' and

xxx='oneProject'

"

echo "sql is ${sql}"

${EXE_SQL_PROD} "${sql}" > ${oneProject_total_output_file}

#拼装HTML格式文本

head_style="

.table {

border-collapse: collapse;background-color: #fff;

font-size:14px;

}

.table-bordered th,

.table-bordered td {

border: 1px solid #000;

}

.table-bordered th{background:#00b0f4;}

.table-bordered .td_color1{background:#79da4c;}

"

echo "${head_style}" > ${oneProject_mail_output_file}

echo "Hi all~~
电商oneProject数据如下~
" >> ${oneProject_mail_output_file}

echo "

#写入HTML TABLE列头

oneProject_title="日期,交易额,时间进度,顾客数,订单数,客单价,转化率,点击量,点击用户数,二跳率"

head_str=`echo ${oneProject_title} |awk -F ',' '{print ""$1""$2""$3""$4""$5""$6""$7""$8""$9""$10"

"}'`

echo "${head_str}" >> ${oneProject_mail_output_file}

#日期,交易额,时间进度,顾客数,订单数,客单价,转化率,点击量,点击用户数,二跳率

cat ${oneProject_every_day_output_file} |while read record

do

day_var=`echo ${record} |awk '{print $1}'`

get_week=`date -d "${day_var} -0 day" +%w`

if [ ${get_week} -eq 6 ] || [ ${get_week} -eq 0 ];then

content_str=`echo ${record} |awk '{print "

"$1""$2""$3""$4""$5""$6""$7""$8""$9""$10""}'`

echo "${content_str}" >> ${oneProject_mail_output_file}

else

content_str=`echo ${record} |awk '{print "

"$1""$2""$3""$4""$5""$6""$7""$8""$9""$10""}'`

echo "${content_str}" >> ${oneProject_mail_output_file}

fi

done

#当月总计

cat ${oneProject_total_output_file} |while read record

do

content_str=`echo ${record} |awk '{print "

"$1""$2""$3""$4""$5""$6""$7""$8""$9""$10""}'`

echo "${content_str}" >> ${oneProject_mail_output_file}

done

echo "


" >> ${oneProject_mail_output_file}

echo "" >> ${oneProject_mail_output_file}

#发送邮件

mail_subject="电商oneProject${get_month_of_year}月1日-${get_month_of_year}月${get_day_of_month}日"

mail_from="qqqq@xxx.com"

mail_cc="bbbbb@cccc.com"

mail_to="bbbbb@cccc.com"

mail_bcc="bbbbb@cccc.com"

mail_content=`cat ${oneProject_mail_output_file}`

/..../sendEmail-v1.56/sendEmail -f "${mail_from}" -t "${mail_to}" -cc ${mail_cc} -bcc ${mail_bcc} -u "${mail_subject}" -m "${mail_content}" -o message-content-type=text/html -o message-charset=utf-8

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值