-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathsend_mail.sh
More file actions
122 lines (91 loc) · 5.28 KB
/
send_mail.sh
File metadata and controls
122 lines (91 loc) · 5.28 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
#!/bin/bash
BASE_PATH=/home/oracle/deepesh/dashboard
TEMPLATE_HTML=/home/oracle/deepesh/dashboard/template.html
Date=`date +'%Y%m%d'`
p_interval=8
sendTelegram()
{
curl -v -k --data-urlencode "parse_mode=HTML" --data-urlencode "disable_web_page_preview=true" --data-urlencode "text=$1" "https://api.telegram.org/bot579230376:AAH-9le4756dqdtXA6uvznxxbGV6EanZ-Zc/sendMessage?chat_id=-252646532"
}
DATE=`date +'%d %B %Y : %H' -d '1 hour ago'`
##############Email
#SUBJECT="UMB Dashboard "`date +'%d %B %Y'`
SUBJECT="Paypro Biller Report $DATE"
TO=deepesh.arora@spicelabs.in,deepak.budhiraja@spicelabs.in,inderjot.singh@spicelabs.in,harnek.singh@spicelabs.in,harsh.bansal@spicelabs.in
CC=rajesh.mahajan@spicelabs.in,ajendra.bisht@spicelabs.in,dfsproduct@spicelabs.in,techops.paypro@spicelabs.in
#######################Transaction table
echo "SUBJECT:: $SUBJECT"
cat $BASE_PATH/hreport_out.txt > $BASE_PATH/temp.data
#cat $BASE_PATH/temp.data
Q_HEADER=`cat $BASE_PATH/temp.data | tr -s " " | grep "^QUERYBILL|AGG" | sed -e 's/|/|/g' | head -1`
echo $Q_HEADER | awk -F '|' -v OFS='\n' '{for (i=2;i<=NF;i++)print "<th class=\"column100 column"i"\" data-column=\"column"i"\">"$i"</th>"}' |sed -e 's/\//\\\//g' | sed -e 's/"/\\"/g' | sed ':a;N;$!ba;s/\n//g' > $BASE_PATH/temp.header
QUERY_HEADER=`cat $BASE_PATH/temp.header`
cat $BASE_PATH/temp.data | grep -v "^QUERYBILL|AGG" | grep "QUERYBILL" > $BASE_PATH/data.txt
>$BASE_PATH/temp.rows
cat $BASE_PATH/data.txt| while read row
do
echo $row | grep "|FAIL|"
if [[ $? -eq 0 ]]
then
biller=`echo $row | awk -F '|' '{print $3}'`
aggr=`echo $row | awk -F '|' '{print $2}'`
fail=`echo $row | awk -F '|' '{print $5}'`
total=`cat $BASE_PATH/data.txt|grep QUERYBILL|grep "$aggr"|grep "$biller"|awk -F '|' '{SUM+=$5} END {print SUM}'`
per=$((fail*100/total))
if [[ $per -gt 10 && $fail -gt 10 ]]
then
echo "<tr class=\"row100\" bgcolor=\"\#FF0000\">" >> $BASE_PATH/temp.rows
else
echo "<tr class=\"row100\">" >> $BASE_PATH/temp.rows
fi
else
echo "<tr class=\"row100\">" >> $BASE_PATH/temp.rows
fi
echo $row | grep QUERYBILL | tr -s " " | awk -F '|' -v OFS='\n' '{for (i=2;i<=NF;i++)print "<td class=\"column100 column"i"\" data-column=\"column"i"\">"$i"</td>"}' >> $BASE_PATH/temp.rows
echo "</tr>" >> $BASE_PATH/temp.rows
done
#ROWS=`cat $BASE_PATH/temp.rows | sed -e 's/\//\\\//g'`
cat $BASE_PATH/temp.rows | sed -e 's/\//\\\//g' | sed -e 's/"/\\"/g' | sed ':a;N;$!ba;s/\n//g' > $BASE_PATH/temp2.rows
ROWS=`cat $BASE_PATH/temp2.rows`
#echo $ROWS
############################Users table
cat $BASE_PATH/hreport_out.txt > $BASE_PATH/temp.data
#cat $BASE_PATH/temp.data
P_HEADER=`cat $BASE_PATH/temp.data | tr -s " " | grep "^PAYBILL|AGG" | sed -e 's/|/|/g' | head -1`
echo $P_HEADER | awk -F '|' -v OFS='\n' '{for (i=2;i<=NF;i++)print "<th class=\"column100 column"i"\" data-column=\"column"i"\">"$i"</th>"}' |sed -e 's/\//\\\//g' | sed -e 's/"/\\"/g' | sed ':a;N;$!ba;s/\n//g' > $BASE_PATH/temp.header
PAY_HEADER=`cat $BASE_PATH/temp.header`
cat $BASE_PATH/temp.data | grep -v "^PAYBILL|AGG"|grep "PAYBILL" > $BASE_PATH/data.txt
>$BASE_PATH/temp.rows
cat $BASE_PATH/data.txt| while read row
do
echo $row | grep -v "|PASS|"
if [[ $? -eq 0 ]]
then
biller=`echo $row | awk -F '|' '{print $3}'`
aggr=`echo $row | awk -F '|' '{print $2}'`
fail=`echo $row | awk -F '|' '{print $5}'`
total=`cat $BASE_PATH/data.txt|grep PAYBILL|grep "$aggr"|grep "$biller"|awk -F '|' '{SUM+=$5} END {print SUM}'`
per=$((fail*100/total))
if [[ $per -gt 10 && $fail -gt 10 ]]
then
echo "<tr class=\"row100\" bgcolor=\"\#FF0000\">" >> $BASE_PATH/temp.rows
else
echo "<tr class=\"row100\">" >> $BASE_PATH/temp.rows
fi
else
echo "<tr class=\"row100\">" >> $BASE_PATH/temp.rows
fi
echo $row | grep PAYBILL | tr -s " " | awk -F '|' -v OFS='\n' '{for (i=2;i<=NF;i++)print "<td class=\"column100 column"i"\" data-column=\"column"i"\">"$i"</td>"}' >> $BASE_PATH/temp.rows
echo "</tr>" >> $BASE_PATH/temp.rows
done
#ROWS=`cat $BASE_PATH/temp.rows | sed -e 's/\//\\\//g'`
cat $BASE_PATH/temp.rows | sed -e 's/\//\\\//g' | sed -e 's/"/\\"/g' | sed ':a;N;$!ba;s/\n//g' > $BASE_PATH/temp2.rows
PAY=`cat $BASE_PATH/temp2.rows`
############################Creating HTML
#echo $ROWS
cat $TEMPLATE_HTML | sed -e "s/~~TRANSACTION_HEADER~~/$QUERY_HEADER/g"| sed -e "s/~~TRANSACTION_ROWS~~/$ROWS/g" | sed -e "s/~~USERS_HEADER~~/$PAY_HEADER/g"| sed -e "s/~~USERS_ROWS~~/$PAY/g" > $BASE_PATH/final.html
#cat $TEMPLATE_HTML | sed -e "s/~~ROWS~~/$ROWS/g"
#mutt -e "set content_type=text/html" "deepesh.arora@spicelabs.in" -s "$SUBJECT" < $BASE_PATH/final.html
#mutt -e "set content_type=text/html" "deepak.budhiraja@spicelabs.in" -s "UMB Dashboard" < $BASE_PATH/final.html
#mutt -e "set content_type=text/html" deepak.budhiraja@spicelabs.in,deepesh.arora@spicelabs.in,Mario.Widjaja@spicelabs.in,Ankit.Lalwani@spicelabs.in,Zulhans.Ramadhan@spicelabs.in -c inderjot.singh@spicelabs.in,amritpal.singh@spicelabs.in,ajeet.chauhan@spiceglobal.com,sameer.seth@spicedigital.in -s "UMB Dashboard" < $BASE_PATH/final.html
mutt -e "set content_type=text/html" $TO -c $CC -s "$SUBJECT" < $BASE_PATH/final.html