forked from doublechaintech/scm-biz-suite
-
Notifications
You must be signed in to change notification settings - Fork 0
/
projectname
31 lines (21 loc) · 1.44 KB
/
projectname
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
retailscm-biz-suite
cat stat.sql | sed 's/__end__/'"$(selectedDate)"'/g' > today.sql
mysql -uroot -p0254891276 -h 127.0.0.1 moyi < today.sql > today.log
cat stat7.sql | sed 's/__end__/'"$(selectedDate)"'/g' > today.sql
echo "last 7 daysi -------------------------------------------------" >> today.log
mysql -uroot -p0254891276 -h 127.0.0.1 moyi < today.sql >> today.log
cat stat28.sql | sed 's/__end__/'"$(selectedDate)"'/g' > today.sql
echo "last 28 days -------------------------------------------------" >> today.log
mysql -uroot -p0254891276 -h 127.0.0.1 moyi < today.sql >> today.log
cat stat30.sql | sed 's/__end__/'"$(selectedDate)"'/g' > today.sql
echo "last 30 days ------------------------------------------------" >> today.log
mysql -uroot -p0254891276 -h 127.0.0.1 moyi < today.sql >> today.log
cat stat31.sql | sed 's/__end__/'"$(selectedDate)"'/g' > today.sql
echo "last 31 days -----------------------------------------------" >> today.log
mysql -uroot -p0254891276 -h 127.0.0.1 moyi < today.sql >> today.log
./mails [email protected] "DAILY REPORT OF $(selectedDate)" @today.log
./mails [email protected] "DAILY REPORT OF $(selectedDate)" @today.log
./mails [email protected] "DAILY REPORT OF $(selectedDate)" @today.log
./mails [email protected] "DAILY REPORT OF $(selectedDate)" @today.log
./mails [email protected] "DAILY REPORT OF $(selectedDate)" @today.log
./mails [email protected] "DAILY REPORT OF $(selectedDate)" @today.log