makeeducationals.py

#!/usr/bin/env python3
""" Make the 'Congratulations!' slide and the list of award-winners."""

# This is a standard skeleton to use in creating a new program in the TMSTATS suite.

import tmutil, sys, os, datetime, subprocess, codecs
import tmglobals, tmparms
from awardinfo import Awardinfo 
myglobals = tmglobals.tmglobals()


### Insert classes and functions here.  The main program begins in the "if" statement below.

awards = {}
knownawards = Awardinfo.lookup
awardorder = ['DTM', 1, 'CL', 'CC', 2, 'ALB', 'ACB', 3, 'ALS', 'ACS', 4, 'ACG', 5]


class Award:
    def __init__(self, membername, award, clubname, awarddate):
        self.membername = membername
        self.award = award
        self.clubname = clubname
        self.awarddate = awarddate
        self.key = self.membername.lower() + ';' + self.clubname + ';' + repr(self.awarddate)
        try:
            self.level = Awardinfo.levels[award]
        except KeyError:
            sys.stderr.write('Ignoring unknown "%s" award for %s\n' % (award, self.key))
            return

        if self.level == 0:
            # Old award
            if award not in awards:
                awards[award] = []
            awards[award].append(self)
        else:
            if self.level not in awards:
                awards[self.level] = []
            awards[self.level].append(self)
 

    def show(self):
        if self.level == 0:
            return '<tr class="awardline"><td class="awardmember" width="48%%">'+ str(self.membername) +'</td><td class="awardclub" width="48%">' + str(self.clubname) + '</td></tr>\n' 
        else:
            return '<tr class="awardline"><td class="awardmember" width="35%%">'+ str(self.membername) +'</td><td class="awardclub" width="35%">' + str(self.clubname) + '</td><td class="pathname" width="25%">' + Awardinfo.paths[self.award] + '</td></tr>\n' 

def printawards(awards, knownawards, k):
    if k in awards:
        if isinstance(k, int):
            outfile.write('[et_pb_toggle title="Pathways Level %d (%d)" open="off" use_border_color="off" border_color="#ffffff" border_style="solid" open_toggle_text_color="#000000" closed_toggle_text_color="#000001"]\n' % (k, len(awards[k])))
        else:
            outfile.write('[et_pb_toggle title="%s (%d)" open="off" use_border_color="off" border_color="#ffffff" border_style="solid" open_toggle_text_color="#000000" closed_toggle_text_color="#000001"]\n' % (knownawards[k], len(awards[k])))
        outfile.write('<table>\n')
        #print '<tr><td class="awardname" colspan="2">%s</td></tr>\n' % knownawards[k]
        for each in sorted(awards[k], key=lambda x:x.key):
            outfile.write(each.show())
        outfile.write('</table>\n')
        outfile.write('[/et_pb_toggle]\n')


def makeCongratulations(count, district, timing, parms):
    # Now, create the "Congratulations" slide

    cmd = ['convert']
    cmd.append(parms.baseslide)
    cmd.append('-quality')
    cmd.append('50')
    cmd.append('-font')
    cmd.append('Helvetica-Bold')
    cmd.append('-pointsize')
    cmd.append('26')
    cmd.append('-fill')
    cmd.append('black')
    line1 = 100
    left = 380
    shadow = 2
    spacing = 32
    line = line1
    texts = ["Congratulations to the %d District %s" % (count, district),
             "members who achieved one or more of their",
             "educational goals %s." % (timing,),
             "",
             "Will you be recognized next?"]
    for t in texts:
        cmd.append('-draw')
        cmd.append('"text %d,%d \'%s\'"' % (left+shadow, line+shadow, t))
        line += spacing
    line = line1 + shadow
    cmd.append('-fill')
    cmd.append('white')
    for t in texts:
        cmd.append('-draw')
        cmd.append('"text %d,%d \'%s\'"' % (left, line, t))
        line += spacing
    cmd.append(parms.prefix + '.jpg')

    return cmd

if __name__ == "__main__":



    # Handle parameters
    parms = tmparms.tmparms()
    parms.add_argument('--quiet', '-q', action='count')
    group = parms.parser.add_mutually_exclusive_group()
    group.add_argument('--since', type=str, default='30',
            help='How long ago or first date to look for awards.')
    group.add_argument('--lastmonth', action='store_true',
            help='If specified, looks at the previous month')
    parms.add_argument('--include-hpl', action='store_true',
            help='If specified, include HPL awards.  Normally, they are excluded.')
    parms.add_argument('--prefix', type=str, default='recentawards',
            help='Filename prefix for the .jpg and .html files created by this program (default: %(default)s)')
    parms.add_argument('--baseslide', type=str, default='ed-achieve-base.png',
            help='Slide to use as the base for the "Congratulations" slide')

    # Do global setup
    myglobals.setup(parms)
    conn = myglobals.conn
    curs = myglobals.curs

    

    # Your main program begins here.
    outfile = open(parms.prefix + '.html', 'w')

    clauses = []
    # Figure out the timeframe for the queries.
    today = datetime.datetime.today()

    if parms.lastmonth:
        month = today.month - 1
        year = today.year
        if month <= 0:
            month = 12
            year = year - 1
        clauses.append('MONTH(awarddate) = %d' % month)
        timestamp = 'during ' + datetime.date(year, month, 1).strftime('%B, %Y')

    else:
        firstdate = datetime.datetime.strptime(tmutil.cleandate(parms.since), '%Y-%m-%d')
        clauses.append("awarddate >= '%s'" % firstdate.strftime('%Y-%m-%d'))
        timestamp = 'since {d:%B} {d.day}, {d.year}'.format(d=firstdate)


    if not parms.include_hpl:
        clauses.append('award != "LDREXC"')

    if parms.district:
        clauses.append('district = %s' % parms.district)

    ### Bypass 'name unavailable'
    clauses.append('membername NOT LIKE "%unavailable%"')

    curs.execute("SELECT COUNT(DISTINCT membername) FROM awards WHERE " + ' AND '.join(clauses))
    count = curs.fetchone()[0]

    curs.execute("SELECT membername, award, clubname, awarddate FROM awards WHERE " + ' AND '.join(clauses))
    for (membername, award, clubname, awarddate) in curs.fetchall():
        Award(membername, award, clubname, awarddate)



    outfile.write('<h3>Member Educationals %s</h3>\n' % timestamp)
    outfile.write('<p>Congratulations to the following Toastmasters for reaching one or more of their educational goals %s.  Will we see YOUR name here next?</p>\n' % timestamp)
    outfile.write('<p>Achievements not shown here can be found on the Toastmasters International <a href="http://reports.toastmasters.org/reports/dprReports.cfm?r=3&d=%s&s=Date&sortOrder=1" target="_new">Educational Achievements Report</a>.</p>\n' % (parms.district))
    outfile.write('<p>Click on an award title to show the names of Toastmasters who have earned that award.</p>\n')

    # And now print the awards themselves.

    outfile.write('<div class="awardstable">\n')
    for k in awardorder:
        printawards(awards, knownawards, k)
    outfile.write('</div>\n')


    #cmd = makeCongratulations(count, parms.district, timestamp, parms)
    #subprocess.call(' '.join(cmd),shell=True)