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 u.email, u.communication_email, pt.coupon_code, pt.transaction_id, pt.applied_on FROM promotiontracker pt, user u WHERE u.id = pt.user_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