review-automation-server/analytics/background_job.py

from django.utils import timezone
from gauth.models import Location
from review.models import Review
from .send_email import send_email
from django.db.models import Count
from review.review_utils import get_bad_reviews


def send_email_bad_reviews():
    locations = Location.objects.all()
    for location in locations:
        reviews = get_bad_reviews(location.location_id, hours=6)
        total_reviews = reviews.count()
        if total_reviews > 0:
            to = [location.recipient_email if location.recipient_email else 'bt@bytetrek.com.bd']
            subject = f"A bad review has been post in {location.care_name}."
            message =f'''
            <img src="https://ercare24.com/wp-content/uploads/2016/07/signature-care-resized-e1462918690585.png" alt="Avatar" class="image" width=20% >
            <h1>Bad Review has been posted.</h1>
            <p>Hi there, </p>
            <p>There is {total_reviews} bad reviews has been posted in {location.care_name}.
            Please, response them ASAP.</p>
            <h4>Links: </h4>
            '''
            for r in reviews:
                link = r.location.review_site_url + '?reviewId='+r.review_id
                text = str(r.star_rating) + ' star review'
                message += f'<a href="{link}">{text}</a><br>'
            message += '<p>Regards,</p><p>Byte Trek Limited</p>'

            send_email(to_list=to, subject=subject, message=message)


def weekly_report(location_id):
    date = timezone.now() - timezone.timedelta(days=7)
    reviews = Review.objects.filter(location_id=location_id, create_time__gte=date)
    res = Review.objects.filter(create_time__gte=date, location_id=location_id).values('star_rating')\
        .annotate(total=Count('star_rating')).order_by('star_rating')
    # TODO:
    # make a table with reviews count and bad reviews and send mail to a particular email add.