Subversion Repositories SmartDukaan

#!/bin/bash

DATE=`date +%Y-%b-%d`
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
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

#Email the two report files.
python ../PyProj/src/shop2020/utils/EmailAttachmentSender.py -tvarun.gupta@shop2020.in -s"Daily Promotion Update - Carts" -a carts_with_coupon.${DATE}.csv
python ../PyProj/src/shop2020/utils/EmailAttachmentSender.py -tvarun.gupta@shop2020.in -s"Daily Promotion Update - Orders" -a orders_with_coupon.${DATE}.csv