"""
mysite/                 <-- project directory
 |-- core/                        <-- app directory
 |    |-- management/
           +--__init__.py
 |    |    +-- commands/
                +-- __init__.py
 |    |         +-- sendreport
"""



from django.core.management.base import BaseCommand
from django.utils import timezone
from django.contrib import messages
from django.template.loader import get_template
from django.utils import timezone
from datetime import datetime
from django.conf import settings
import smtplib
from email.mime.text import MIMEText
from email.mime.multipart import MIMEMultipart
from django.core.mail import EmailMultiAlternatives
from models import Cart


class Command(BaseCommand):
    help = 'Daily report '

    def handle(self, *args, **kwargs):
        time = timezone.now().strftime('%X')
        date = datetime.now()
        cart = Cart.objects.filter(date=datetime.now())
        total_price = 0
        cart1 =
  Cart.objects.filter(date=datetime.now(), paid=True)

        total_cart = Cart.objects.filter(date=datetime.now(), paid=True).count()
        for i in cart1:
            total_price = total_price+i.price
            subject = "Daily Sales"
            from_email = settings.EMAIL_HOST_USER
            # Now we get the list of emails in a list
            form.
            to_email = ['gospeltruth18@gmail.com']
            #Opening a file in python, with closes the
            file when its done running
            with open(settings.BASE_DIR +
           "/templates/account/change_password_email.txt") as
           sign_up_email_txt_file:
           sign_up_message = sign_up_email_txt_file.read()
           message = EmailMultiAlternatives(subject=subject, body=sign_up_message,from_email=from_email, to=to_email )
           html_template =
 get_template("Administrator/dailyreport.html").render({'qs':cart1, 'total_cart':total_cart, 'total_price':total_price, 'date':date})
           message.attach_alternative(html_template, "text/html")
           message.send()
       self.stdout.write("report sent successful" )