import System
import System.Text
from System import *
from System.Text import *
from System.Collections import *

class testscript(object):
    def Run(self, m):
        days = 7

        fmt = '<tr><td align="left">{0}</td><td align="left">{1:n0}</td></tr>\r\n'
        fmt0 = '<tr><td colspan="2">{0}\r\n'
        fmt1 = '<tr><td colspan="2"><H2>{0}\r\n</H2>'
        #fmt = '{0,28}:{1,10:n0}\r\n'
        #fmt0 = '{0}\r\n'
        sb = StringBuilder()

        sb.AppendLine('<table cellspacing="5" class="grid">')
        sb.AppendFormat(fmt1, "Weekly Birthday List", " ")
        sb.AppendFormat(fmt0, String.Format("The following people have birthdays in the next {0} days:", days+1))

        sb.AppendFormat(fmt, " ", '\r\n')
        sb.AppendFormat(fmt, " ", '\r\n')

        people = m.QueryList("testquery")
        i=0
        for person in people:
            i = i+1
            sb.AppendFormat(fmt0,  String.Format("- {0} - " , i))

            if person.TitleCode is None:
                sb.AppendFormat(fmt, person.Name, " ")
            else:
                sb.AppendFormat(fmt0, person.TitleCode + " " + person.Name, " ")

            if person.PrimaryAddress != "" and  person.PrimaryAddress is not None:
                sb.AppendFormat(fmt, person.PrimaryAddress , person.PrimaryAddress2 )

            if person.CityStateZip5!= "" and person.CityStateZip5 is not None:
                sb.AppendFormat(fmt, person.CityStateZip5, "" )

            if person.HomePhone != "" and person.HomePhone is not None:
                sb.AppendFormat(fmt0, person.HomePhone.ToString() + " (h)", " ")

            if person.CellPhone != "" and person.CellPhone is not None:
                sb.AppendFormat(fmt0, person.CellPhone.ToString()  + " (c)", " ")

            if person.EmailAddress != "" and person.EmailAddress is not None:
                sb.AppendFormat(fmt, person.EmailAddress,"" )

            if person.EmailAddress2 != "" and person.EmailAddress2 is not None:
                sb.AppendFormat(fmt, person.EmailAddress2, "" )

            if person.BirthDate != "" and person.BirthDate is not None:
                sb.AppendFormat(fmt, "Birthday: " + person.BirthMonth.ToString()  + "/" + person.BirthDay.ToString() , "" )

            sb.AppendFormat(fmt, " ", '\r\n')

        sb.AppendLine('</table>')
        return sb.ToString()