Subversion Repositories SmartDukaan

from email import encoders

from email.mime.audio import MIMEAudio

from email.mime.base import MIMEBase

from email.mime.image import MIMEImage

from email.mime.multipart import MIMEMultipart

from email.mime.text import MIMEText

import mimetypes

import os

import re

import smtplib

import csv

import MySQLdb

from dtr.storage import DataService

from dtr.storage.DataService import Users

from elixir import *

from sqlalchemy.orm.exc import NoResultFound, MultipleResultsFound

from sqlalchemy.sql import func

from sqlalchemy.sql.expression import and_, or_, desc, not_, distinct, cast, \

    between

import datetime

from datetime import date,timedelta

class Email:

    """

    This class handles the creation and sending of email messages

    via SMTP.  This class also handles attachments and can send

    HTML messages.  The code comes from various places around

    the net and from my own brain.

    """

    def __init__(self, smtpServer):

        """

        Create a new empty email message object.

        @param smtpServer: The address of the SMTP server

        @type smtpServer: String

        """

        self._textBody = None

        self._htmlBody = None

        self._subject = ""

        self._smtpServer = smtpServer

        self._reEmail = re.compile("^([\\w \\._]+\\<[a-z0-9!#$%&'*+/=?^_`{|}~-]+(?:\\.[a-z0-9!#$%&'*+/=?^_`{|}~-]+)*@(?:[a-z0-9](?:[a-z0-9-]*[a-z0-9])?\\.)+[a-z0-9](?:[a-z0-9-]*[a-z0-9])?\\>|[a-z0-9!#$%&'*+/=?^_`{|}~-]+(?:\\.[a-z0-9!#$%&'*+/=?^_`{|}~-]+)*@(?:[a-z0-9](?:[a-z0-9-]*[a-z0-9])?\\.)+[a-z0-9](?:[a-z0-9-]*[a-z0-9])?)$")

        self.clearRecipients()

        self.clearAttachments()

    def send(self):

        """

        Send the email message represented by this object.

        """

        # Validate message

        if self._textBody is None and self._htmlBody is None:

            raise Exception("Error! Must specify at least one body type (HTML or Text)")

        if len(self._to) == 0:

            raise Exception("Must specify at least one recipient")

        # Create the message part

        if self._textBody is not None and self._htmlBody is None:

            msg = MIMEText(self._textBody, "plain")

        elif self._textBody is None and self._htmlBody is not None:

            msg = MIMEText(self._htmlBody, "html")

        else:

            msg = MIMEMultipart("alternative")

            msg.attach(MIMEText(self._textBody, "plain"))

            msg.attach(MIMEText(self._htmlBody, "html"))

        # Add attachments, if any

        if len(self._attach) != 0:

            tmpmsg = msg

            msg = MIMEMultipart()

            msg.attach(tmpmsg)

        for fname,attachname in self._attach:

            if not os.path.exists(fname):

                print "File '%s' does not exist.  Not attaching to email." % fname

                continue

            if not os.path.isfile(fname):

                print "Attachment '%s' is not a file.  Not attaching to email." % fname

                continue

            # Guess at encoding type

            ctype, encoding = mimetypes.guess_type(fname)

            if ctype is None or encoding is not None:

                # No guess could be made so use a binary type.

                ctype = 'application/octet-stream'

            maintype, subtype = ctype.split('/', 1)

            if maintype == 'text':

                fp = open(fname)

                attach = MIMEText(fp.read(), _subtype=subtype)

                fp.close()

            elif maintype == 'image':

                fp = open(fname, 'rb')

                attach = MIMEImage(fp.read(), _subtype=subtype)

                fp.close()

            elif maintype == 'audio':

                fp = open(fname, 'rb')

                attach = MIMEAudio(fp.read(), _subtype=subtype)

                fp.close()

            else:

                fp = open(fname, 'rb')

                attach = MIMEBase(maintype, subtype)

                attach.set_payload(fp.read())

                fp.close()

                # Encode the payload using Base64

                encoders.encode_base64(attach)

            # Set the filename parameter

            if attachname is None:

                filename = os.path.basename(fname)

            else:

                filename = attachname

            attach.add_header('Content-Disposition', 'attachment', filename=filename)

            msg.attach(attach)

        # Some header stuff

        msg['Subject'] = self._subject

        msg['From'] = self._from

        msg['To'] = ", ".join(self._to)

        msg.preamble = "You need a MIME enabled mail reader to see this message"

        # Send message

        msg = msg.as_string()

        server = smtplib.SMTP(self._smtpServer)

        server.sendmail(self._from, self._to, msg)

        server.quit()

    def setSubject(self, subject):

        """

        Set the subject of the email message.

        """

        self._subject = subject

    def setFrom(self, address):

        """

        Set the email sender.

        """

        if not self.validateEmailAddress(address):

            raise Exception("Invalid email address '%s'" % address)

        self._from = address

    def clearRecipients(self):

        """

        Remove all currently defined recipients for

        the email message.

        """

        self._to = []

    def addRecipient(self, address):

        """

        Add a new recipient to the email message.

        """

        if not self.validateEmailAddress(address):

            raise Exception("Invalid email address '%s'" % address)

        self._to.append(address)

    def setTextBody(self, body):

        """

        Set the plain text body of the email message.

        """

        self._textBody = body

    def setHtmlBody(self, body):

        """

        Set the HTML portion of the email message.

        """

        self._htmlBody = body

    def clearAttachments(self):

        """

        Remove all file attachments.

        """

        self._attach = []

    def addAttachment(self, fname, attachname=None):

        """

        Add a file attachment to this email message.

        @param fname: The full path and file name of the file

                      to attach.

        @type fname: String

        @param attachname: This will be the name of the file in

                           the email message if set.  If not set

                           then the filename will be taken from

                           the fname parameter above.

        @type attachname: String

        """

        if fname is None:

            return

        self._attach.append( (fname, attachname) )

    def validateEmailAddress(self, address):

        """

        Validate the specified email address.

        @return: True if valid, False otherwise

        @rtype: Boolean

        """

        if self._reEmail.search(address) is None:

            return False

        return True

if __name__ == "__main__":

    # Run some tests

    DataService.initialize(db_hostname="localhost")

    currentTime = datetime.datetime.date(datetime.datetime.now())

    previousDay = datetime.datetime(currentTime.year,currentTime.month, currentTime.day, 0, 0)- timedelta(days=1)

    mTo = session.query(Users.email).filter(Users.mobile_number == None).filter(Users.created >= previousDay).all()

    #mTo = ["manish.sharma@shop2020.in", "manas.kapoor@shop2020.in"]

    mFrom = "ProfitMandi<help@profitmandi.com>"

    #print mTo

    #mTo = ["manish.sharma@shop2020.in", "sandeep.sachdeva@shop2020.in", "chaitnaya.vats@shop2020.in", "manoj.kumar@shop2020.in", "chandan.kumar@shop2020.in", "khushal.bhatia@shop2020.in", "yukti.jain@shop2020.in", "ankush.dhingra@shop2020.in", "rajneesh.arora@shop2020.in", "kshitij.sood@shop2020.in", "anikendra.das@shop2020.in"]

    for receipient in mTo:

        m = Email('localhost')

        m.setFrom(mFrom)

        print receipient[0]

        m.addRecipient(receipient[0])

        #print receipient

        message="""

<html>

    <body>

    <pre>		

    Dear Customer,

Thanks for showing your interest in Profitmandi android App.

This app is useful for frequent buyers of mobiles, tabs ad related products. Profitmandi recommends the most profitable online deals.

Only users having an invite code can use this app.

Request you to please provide your contact no so that we can get in touch with you and activate you on this app.

Regards,

Profitmandi Team

+91-8826894203

</pre>

    </body>

    </html>"""

        m.setSubject("ProfitMandi")

        m.setTextBody(None)

        m.setHtmlBody(message)

        m.send()

    if session.is_active:

        print "session is active. closing it."

        session.close()