| Line 1... |
Line 1... |
| 1 |
#!/bin/bash
|
1 |
#!/bin/bash
|
| 2 |
|
2 |
|
| - |
|
3 |
if [ $# -ne 1 ]
|
| - |
|
4 |
then
|
| - |
|
5 |
echo "Usage: $0 <email>"
|
| - |
|
6 |
exit 1
|
| - |
|
7 |
fi
|
| - |
|
8 |
|
| - |
|
9 |
EMAIL=$1
|
| - |
|
10 |
|
| - |
|
11 |
# resolve links - $0 may be a softlink
|
| - |
|
12 |
PRG="$0"
|
| - |
|
13 |
|
| - |
|
14 |
while [ -h "$PRG" ]; do
|
| - |
|
15 |
ls=`ls -ld "$PRG"`
|
| - |
|
16 |
link=`expr "$ls" : '.*-> \(.*\)$'`
|
| - |
|
17 |
if expr "$link" : '/.*' > /dev/null; then
|
| - |
|
18 |
PRG="$link"
|
| - |
|
19 |
else
|
| - |
|
20 |
PRG=`dirname "$PRG"`/"$link"
|
| - |
|
21 |
fi
|
| - |
|
22 |
done
|
| - |
|
23 |
|
| - |
|
24 |
# Get standard environment variables
|
| - |
|
25 |
PRGDIR=`dirname $(readlink -f "$PRG")`
|
| - |
|
26 |
PYTHON_DIR=${PRGDIR}/../PyProj/src/shop2020/utils
|
| - |
|
27 |
|
| 3 |
DATE=`date +%Y-%b-%d`
|
28 |
DATE=`date +%Y-%b-%d`
|
| 4 |
mysql -uroot -pshop2020 user -e "SELECT u.email, u.communication_email, c.coupon_code, c.total_price, c.discounted_price FROM user u, cart c WHERE u.active_cart_id = c.id AND (c.coupon_code='SAHOLIC5' OR c.coupon_code='SAHOLIC1500');" > carts_with_coupon.${DATE}.csv
|
29 |
mysql -uroot -pshop2020 user -e "SELECT u.email, u.communication_email, c.coupon_code, c.total_price, c.discounted_price FROM user u, cart c WHERE u.active_cart_id = c.id AND (c.coupon_code='SAHOLIC5' OR c.coupon_code='SAHOLIC1500');" > carts_with_coupon.${DATE}.csv
|
| 5 |
mysql -uroot -pshop2020 user -e "SELECT o.id AS order_id, u.email, u.communication_email, pt.coupon_code, pt.transaction_id, pt.applied_on FROM user.promotiontracker pt, user.user u, transaction.order o WHERE u.id = pt.user_id AND o.transaction_id = pt.transaction_id;" > orders_with_coupon.${DATE}.csv
|
30 |
mysql -uroot -pshop2020 user -e "SELECT o.id AS order_id, u.email, u.communication_email, pt.coupon_code, pt.transaction_id, pt.applied_on FROM user.promotiontracker pt, user.user u, transaction.order o WHERE u.id = pt.user_id AND o.transaction_id = pt.transaction_id;" > orders_with_coupon.${DATE}.csv
|
| 6 |
|
31 |
|
| 7 |
#Email the two report files.
|
32 |
#Email the two report files.
|
| 8 |
python ../PyProj/src/shop2020/utils/EmailAttachmentSender.py -tvarun.gupta@shop2020.in -s"Daily Promotion Update - Carts" -a carts_with_coupon.${DATE}.csv
|
33 |
python ${PYTHON_DIR}/EmailAttachmentSender.py -t ${EMAIL} -s "Daily Promotion Update - Carts" -a carts_with_coupon.${DATE}.csv
|
| 9 |
python ../PyProj/src/shop2020/utils/EmailAttachmentSender.py -tvarun.gupta@shop2020.in -s"Daily Promotion Update - Orders" -a orders_with_coupon.${DATE}.csv
|
34 |
python ${PYTHON_DIR}/EmailAttachmentSender.py -t ${EMAIL} -s "Daily Promotion Update - Orders" -a orders_with_coupon.${DATE}.csv
|