| Line 24... |
Line 24... |
| 24 |
# Get standard environment variables
|
24 |
# Get standard environment variables
|
| 25 |
PRGDIR=`dirname $(readlink -f "$PRG")`
|
25 |
PRGDIR=`dirname $(readlink -f "$PRG")`
|
| 26 |
PYTHON_DIR=${PRGDIR}/../PyProj/src/shop2020/utils
|
26 |
PYTHON_DIR=${PRGDIR}/../PyProj/src/shop2020/utils
|
| 27 |
|
27 |
|
| 28 |
DATE=`date +%Y-%b-%d`
|
28 |
DATE=`date +%Y-%b-%d`
|
| 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' OR c.coupon_code='SAHOLIC500') ORDER BY c.coupon_code, u.email;" > /tmp/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 IS NOT NULL AND c.coupon_code <> '') ORDER BY c.coupon_code, u.email;" > /tmp/carts_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;" > /tmp/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;" > /tmp/orders_with_coupon.${DATE}.csv
|
| 31 |
|
31 |
|
| 32 |
#Email the two report files.
|
32 |
#Email the two report files.
|
| 33 |
python ${PYTHON_DIR}/EmailAttachmentSender.py -t ${EMAIL} -s "Daily Promotion Update - Carts" -a /tmp/carts_with_coupon.${DATE}.csv
|
33 |
python ${PYTHON_DIR}/EmailAttachmentSender.py -t ${EMAIL} -s "Daily Promotion Update - Carts" -a /tmp/carts_with_coupon.${DATE}.csv
|
| 34 |
python ${PYTHON_DIR}/EmailAttachmentSender.py -t ${EMAIL} -s "Daily Promotion Update - Orders" -a /tmp/orders_with_coupon.${DATE}.csv
|
34 |
python ${PYTHON_DIR}/EmailAttachmentSender.py -t ${EMAIL} -s "Daily Promotion Update - Orders" -a /tmp/orders_with_coupon.${DATE}.csv
|