class bc3100(object):
def __init__(self, **opts):
self.opts = opts
if self.setVariables():
self.mainProcess()
self.opts["mf"].startLoop()
def setVariables(self):
self.sql = Sql(self.opts["mf"].dbm, ["bwlcmp", "bwlgme", "bwltab",
"bwltyp", "bwlpts", "bwlent"], prog=self.__class__.__name__)
if self.sql.error:
return
gc = GetCtl(self.opts["mf"])
bwlctl = gc.getCtl("bwlctl", self.opts["conum"])
if not bwlctl:
return
self.fromad = bwlctl["ctb_emadd"]
return True
def mainProcess(self):
com = {
"stype": "R",
"tables": ("bwlcmp",),
"cols": (
("bcm_code", "", 0, "Cod"),
("bcm_name", "", 0, "Name", "Y")),
"where": [("bcm_cono", "=", self.opts["conum"])]}
gme = {
"stype": "R",
"tables": ("bwlgme",),
"cols": (("bcg_game", "", 0, "GC"),),
"where": [("bcg_cono", "=", self.opts["conum"])],
"whera": [("T", "bcg_ccod", 0, 0)],
"group": "bcg_game"}
r1s = (("Yes", "Y"), ("No", "N"))
fld = (
(("T",0,0,0),"I@bcm_code",0,"","",
0,"N",self.doCmpCod,com,None,None),
(("T",0,0,0),"ONA",30,""),
(("T",0,1,0),"IUI",2,"Last Game","",
0,"N",self.doLstGam,gme,None,("efld",)),
(("T",0,2,0),("IRB",r1s),0,"Game Report","",
"N","N",self.doGamRep,None,None,None),
(("T",0,3,0),("IRB",r1s),0,"Session Prizes","",
"N","N",self.doSesPrz,None,None,None),
(("T",0,4,0),("IRB",r1s),0,"Session Prizes by Group","",
"N","N",self.doSesGrp,None,None,None))
tnd = ((self.doEnd,"y"),)
txt = (self.doExit,)
self.df = TartanDialog(self.opts["mf"], tops=False,
eflds=fld, tend=tnd, txit=txt, view=("N","V"), mail=("B","N"))
def doCmpCod(self, frt, pag, r, c, p, i, w):
chk = self.sql.getRec("bwlcmp", where=[("bcm_cono", "=",
self.opts["conum"]), ("bcm_code", "=", w)], limit=1)
if not chk:
return "Invalid Competition Code"
self.ccod = w
self.cdes = chk[self.sql.bwlcmp_col.index("bcm_name")]
self.ctyp = chk[self.sql.bwlcmp_col.index("bcm_type")]
self.poff = chk[self.sql.bwlcmp_col.index("bcm_poff")]
chk = self.sql.getRec("bwltyp", where=[("bct_cono", "=",
self.opts["conum"]), ("bct_code", "=", self.ctyp)], limit=1)
self.cfmat = chk[self.sql.bwltyp_col.index("bct_cfmat")]
self.tsize = chk[self.sql.bwltyp_col.index("bct_tsize")]
if self.cfmat == "R":
games = self.sql.getRec("bwlgme", cols=["count(*)"],
where=[("bcg_cono", "=", self.opts["conum"]),
("bcg_ccod", "=", self.ccod), ("bcg_game", "=", 1)],
group="bcg_group")
self.games = 0
for gme in games:
if gme[0] > self.games:
self.games = gme[0]
self.games -= 1
elif self.cfmat in ("D", "K"):
self.games = self.sql.getRec("bwlgme", cols=["count(*)"],
where=[("bcg_cono", "=", self.opts["conum"]),
("bcg_ccod", "=", self.ccod), ("bcg_game", "=", 1)],
limit=1)[0] - 1
else:
self.games = chk[self.sql.bwltyp_col.index("bct_games")]
self.groups = chk[self.sql.bwltyp_col.index("bct_groups")]
self.grgame = chk[self.sql.bwltyp_col.index("bct_grgame")]
col = ["bcg_game", "bcg_aflag", "sum(bcg_sfor)",
"sum(bcg_sagt)", "sum(bcg_points)"]
game = self.sql.getRec("bwlgme", cols=col, where=[("bcg_cono",
"=", self.opts["conum"]), ("bcg_ccod", "=", self.ccod)],
group="bcg_game, bcg_aflag", order="bcg_game")
self.lgame = 0
for g in game:
if not g[1] and not g[2] and not g[3] and not g[4]:
break
self.lgame = g[0]
if not self.lgame:
return "Knockout or No Completed Games"
self.df.loadEntry(frt, pag, p+1, data=self.cdes)
self.df.loadEntry(frt, pag, p+2, data=self.lgame)
def doLstGam(self, frt, pag, r, c, p, i, w):
if not w:
chk = self.sql.getRec("bwlgme", cols=["bcg_game",
"sum(bcg_points)"], where=[("bcg_cono", "=",
self.opts["conum"]), ("bcg_ccod", "=", self.ccod)],
group="bcg_game", order="bcg_game")
game = 0
for g in chk:
if g[1]:
game = g[0]
else:
break
if not game:
return "No Completed Games"
self.df.loadEntry(frt, pag, p, data=game)
else:
game = w
chk = self.sql.getRec("bwlgme", cols=["count(*)"],
where=[("bcg_cono", "=", self.opts["conum"]), ("bcg_ccod",
"=", self.ccod), ("bcg_game", "=", game), ("bcg_aflag",
"=", "A")], group="bcg_aflag", limit=1)
if chk and chk[0]:
return "Game Abandoned"
chk = self.sql.getRec("bwlgme", where=[("bcg_cono", "=",
self.opts["conum"]), ("bcg_ccod", "=", self.ccod), ("bcg_game",
"=", game), ("bcg_aflag", "in", ("", "D"))])
if not chk:
return "Invalid Game Number"
ptyp = chk[0][self.sql.bwlgme_col.index("bcg_type")]
pts = self.sql.getRec("bwlpts", where=[("bcp_cono",
"=", self.opts["conum"]), ("bcp_code", "=", self.ctyp),
("bcp_ptyp", "=", ptyp)], limit=1)
self.ponly = pts[self.sql.bwlpts_col.index("bcp_p_only")]
non = []
for ck in chk:
scod = ck[self.sql.bwlgme_col.index("bcg_scod")]
ocod = ck[self.sql.bwlgme_col.index("bcg_ocod")]
if scod > 900000 or ocod > 900000:
continue
if self.ponly == "Y":
fors = ck[self.sql.bwlgme_col.index("bcg_points")]
agts = self.sql.getRec("bwlgme",
cols=["bcg_points"], where=[("bcg_cono", "=",
self.opts["conum"]), ("bcg_ccod", "=", self.ccod),
("bcg_game", "=", game), ("bcg_scod", "=", ocod)],
limit=1)[0]
else:
fors = ck[self.sql.bwlgme_col.index("bcg_sfor")]
agts = ck[self.sql.bwlgme_col.index("bcg_sagt")]
if not fors and not agts:
if scod not in non:
non.append(scod)
if non:
return "%s Result(s) Not Yet Entered" % int(len(non) / 2)
self.pgame = w
if self.pgame == 1:
self.gamrep = "N"
self.df.loadEntry(frt, pag, p+1, data=self.gamrep)
if self.pgame < self.games:
self.sesp = "N"
self.sesg = "N"
self.df.loadEntry(frt, pag, p+1, data=self.sesp)
self.df.loadEntry(frt, pag, p+2, data=self.sesg)
return "sk3"
return "sk1"
if self.cfmat in ("D", "K", "R") or self.pgame < self.lgame:
self.df.topf[0][3][5] = "N"
else:
self.df.topf[0][3][5] = "Y"
def doGamRep(self, frt, pag, r, c, p, i, w):
self.gamrep = w
if self.cfmat in ("D", "K", "R") or self.pgame < self.lgame:
self.sesp = "N"
self.sesg = "N"
self.df.loadEntry(frt, pag, p+1, data=self.sesp)
self.df.loadEntry(frt, pag, p+2, data=self.sesg)
return "sk2"
def doSesPrz(self, frt, pag, r, c, p, i, w):
self.sesp = w
if self.sesp == "N" or self.groups == "N":
self.sesg = "N"
self.df.loadEntry(frt, pag, p+1, data=self.sesg)
return "sk1"
def doSesGrp(self, frt, pag, r, c, p, i, w):
self.sesg = w
def doEnd(self):
self.df.closeProcess()
chk = self.sql.getRec("bwlgme", cols=["bcg_group", "bcg_scod"],
where=[("bcg_cono", "=", self.opts["conum"]), ("bcg_ccod", "=",
self.ccod), ("bcg_game", "=", self.pgame)], order="bcg_group")
if chk[0][0] and self.cfmat == "R":
groups = "Y"
else:
groups = self.groups
self.grps = {}
for rec in chk:
if rec[0] not in self.grps:
self.grps[rec[0]] = [[rec[1]], [], []]
else:
self.grps[rec[0]][0].append(rec[1])
self.keys = list(self.grps.keys())
self.keys.sort()
self.fpdf = MyFpdf(name=self.__class__.__name__, head=65)
self.lastg = None
for g in self.keys:
self.pageHeading()
if self.gamrep == "Y":
self.doReport("G", g)
if g == 0 and len(chk) > 20:
self.pageHeading()
self.doReport("M", g)
if self.pgame == self.games:
# Enter Prizes
for key in self.keys:
if self.cfmat == "R" and groups == "Y":
self.grps[key][1] = 0
else:
self.doPrizes(key)
# Match Winners & Summary
self.gqty = len(self.keys)
self.wins = {}
self.allp = []
self.swin = []
self.where = [
("bcg_cono", "=", self.opts["conum"]),
("bcg_ccod", "=", self.ccod),
("bcg_game", "<=", self.pgame),
("btb_cono=bcg_cono",),
("btb_tab=bcg_scod",)]
for grp in range(self.gqty):
if groups == "Y":
gcod = grp + 1
else:
gcod = grp
whr = copyList(self.where)
whr.append(("bcg_group", "=", gcod))
col = [
"bcg_scod", "btb_surname", "btb_names",
"sum(bcg_a_sfor) as sfor",
"sum(bcg_a_sagt) as sagt",
"sum(bcg_a_sfor - bcg_a_sagt) as agg",
"sum(bcg_a_points) as pts"]
recs = self.sql.getRec(tables=["bwlgme", "bwltab"], cols=col,
where=whr, group="bcg_scod, btb_surname, btb_names",
order="pts desc, agg desc, sagt asc")
if not recs:
continue
self.wins[gcod] = []
for x in range(self.grps[gcod][1]):
self.allp.append(recs[x][0])
if recs[x][2]:
nam = "%s, %s" % (recs[x][1], recs[x][2].split()[0])
else:
nam = recs[x][1]
self.wins[gcod].append(nam)
if self.cfmat == "R" and groups == "Y":
self.swin.append(self.grps[gcod][0][0])
if self.sesp == "Y":
self.pageHeading("S")
self.doSesWin()
else:
for grp in self.wins:
if self.wins[grp]:
self.pageHeading("S")
break
self.doMatchWin()
pdfnam = getModName(self.opts["mf"].rcdic["wrkdir"],
self.__class__.__name__, "report", ext="pdf")
self.fpdf.output(pdfnam, "F")
if self.df.repeml[1] == "Y":
if not self.df.repeml[2]:
col = ["btb_mail"]
whr = [
("bce_cono", "=", self.opts["conum"]),
("bce_ccod", "=", self.ccod),
("btb_cono=bce_cono",),
("btb_tab=bce_scod",),
("btb_mail", "<>", "")]
recs = self.sql.getRec(tables=["bwlent", "bwltab"], cols=col,
where=whr)
self.df.repeml[2] = []
for rec in recs:
self.df.repeml[2].append(rec[0])
head = "%s - Results after game %s" % (self.cdes, self.pgame)
doPrinter(mf=self.opts["mf"], conum=self.opts["conum"], pdfnam=pdfnam,
header=head, repprt=self.df.repprt, fromad=self.fromad,
repeml=self.df.repeml)
if self.pgame == self.lgame and self.cfmat == "R" and \
groups == "Y" and not self.poff:
ok = askQuestion(self.opts["mf"].body, "Play-Offs",
"Must a Play-Off Draw be Created and/or Printed?",
default="yes")
if ok == "yes":
self.doSecEnd()
self.opts["mf"].closeLoop()
def doReport(self, rtyp, grp):
whr = [
("bcg_cono", "=", self.opts["conum"]),
("bcg_ccod", "=", self.ccod),
("btb_tab=bcg_scod",)]
col = ["bcg_scod", "btb_surname", "btb_names"]
if rtyp == "G":
whr.extend([
("bcg_scod", "in", self.grps[grp][0]),
("bcg_game", "=", self.pgame)])
col.extend([
"sum(bcg_sfor) as sfor",
"sum(bcg_sagt) as sagt",
"sum(bcg_sfor - bcg_sagt) as agg",
"sum(bcg_points) as pts"])
else:
whr.extend([
("bcg_scod", "in", self.grps[grp][0]),
("bcg_game", "<=", self.pgame)])
if self.pgame <= self.grgame:
col.extend([
"sum(bcg_sfor) as sfor",
"sum(bcg_sagt) as sagt",
"sum(bcg_sfor - bcg_sagt) as agg",
"sum(bcg_points) as pts"])
else:
col.extend([
"sum(bcg_a_sfor) as sfor",
"sum(bcg_a_sagt) as sagt",
"sum(bcg_a_sfor - bcg_a_sagt) as agg",
"sum(bcg_a_points) as pts"])
recs = self.sql.getRec(tables=["bwlgme", "bwltab"], cols=col,
where=whr, group="btb_tab, btb_surname, btb_names",
order="pts desc, agg desc, sagt asc")
if not recs:
return
self.groupHeading(rtyp, grp)
if self.cfmat == "X":
tms = {"H": [0, 0, 0, 0], "V": [0, 0, 0, 0]}
for num, (scod,snam,fnam,sfor,sagt,agg,pts) in enumerate(recs):
if fnam:
nam = "%s, %s" % (snam.upper(), fnam.split()[0].upper())
else:
nam = snam.upper()
a = CCD(num+1, "UI", 3)
b = CCD(nam, "NA", 30)
c = CCD(sfor, "SD", 7.1)
d = CCD(sagt, "SD", 7.1)
e = CCD(agg, "SD", 7.1)
f = CCD(pts, "SD", 7.1)
self.printLine(a.disp, b.disp, c.disp, d.disp, e.disp, f.disp)
if self.cfmat == "X":
tm = self.sql.getRec("bwlent", cols=["bce_tcod"],
where=[("bce_cono", "=", self.opts["conum"]),
("bce_ccod", "=", self.ccod), ("bce_scod", "=", scod)],
limit=1)
tms[tm[0]][0] = float(ASD(tms[tm[0]][0]) + ASD(c.work))
tms[tm[0]][1] = float(ASD(tms[tm[0]][1]) + ASD(d.work))
tms[tm[0]][2] = float(ASD(tms[tm[0]][2]) + ASD(e.work))
tms[tm[0]][3] = float(ASD(tms[tm[0]][3]) + ASD(f.work))
self.pglin += 1
if self.cfmat == "X":
cwth = self.fpdf.cwth
self.fpdf.drawText()
self.fpdf.drawText("Match Summary", font=["courier", "B", 18])
self.fpdf.setFont(style="B")
self.fpdf.drawText()
self.fpdf.drawText("Home", w=cwth * 32, border="TLRB",
align="C", fill=1, ln=0)
self.fpdf.drawText("Visitors", w=cwth * 32, border="TLRB",
align="C", fill=1, ln=1)
x = self.fpdf.get_x()
y = self.fpdf.get_y()
for tm in ("H", "V"):
self.fpdf.drawText("+For", x=x, y=y, w=cwth * 8, h=8,
border="TLRB", align="C", fill=1)
val = CCD(tms[tm][0], "SD", 7.1)
self.fpdf.drawText(val.disp, x=x, w=cwth * 8, h=8,
border="TLRB", align="C", fill=0)
x += (cwth * 8)
self.fpdf.drawText("-Agt", x=x, y=y, w=cwth * 8, h=8,
border="TLRB", align="C", fill=1)
val = CCD(tms[tm][1], "SD", 7.1)
self.fpdf.drawText(val.disp, x=x, w=cwth * 8, h=8,
border="TLRB", align="C", fill=0)
x += (cwth * 8)
self.fpdf.drawText("=Dif", x=x, y=y, w=cwth * 8, h=8,
border="TLRB", align="C", fill=1)
val = CCD(tms[tm][2], "SD", 7.1)
self.fpdf.drawText(val.disp, x=x, w=cwth * 8, h=8,
border="TLRB", align="C", fill=0)
x += (cwth * 8)
self.fpdf.drawText("Pts", x=x, y=y, w=cwth * 8, h=8,
border="TLRB", align="C", fill=1)
val = CCD(tms[tm][3], "SD", 7.1)
self.fpdf.drawText(val.disp, x=x, w=cwth * 8, h=8,
border="TLRB", align="C", fill=0)
x += (cwth * 8)
def doSesWin(self):
# Session Winners
sess = {}
for gme in range(1, self.games + 1):
col = [
"bcg_scod", "btb_surname", "btb_names",
"sum(bcg_sfor) as sfor",
"sum(bcg_sagt) as sagt",
"sum(bcg_sfor - bcg_sagt) as agg",
"sum(bcg_points) as pts"]
whr = copyList(self.where)
whr.append(("bcg_game", "=", gme))
grp = "bcg_scod, btb_surname, btb_names"
odr = "pts desc, agg desc, sagt asc"
if self.sesg == "Y" and gme > self.grgame:
col.append("bcg_group")
grp = "bcg_group, %s" % grp
odr = "bcg_group, %s" % odr
recs = self.sql.getRec(tables=["bwlgme", "bwltab"],
cols=col, where=whr, group=grp, order=odr)
done = None
for rec in recs:
if len(rec) == 7:
gpc = 0
else:
gpc = rec[7]
if gpc == done:
continue
ign = False
if self.ponly == "Y" and not rec[6]:
break
if self.ponly == "N" and (not rec[3] and not rec[4]):
break
for grp in range(self.gqty):
if rec[0] in self.allp:
ign = True
break
if not ign:
self.allp.append(rec[0])
if gme not in sess:
sess[gme] = {}
if rec[2]:
nam = "%s, %s" % (rec[1], rec[2].split()[0])
else:
nam = rec[1]
sess[gme][gpc] = nam
done = gpc
mess = "Session Winners"
self.fpdf.setFont(style="B", size=14)
self.fpdf.drawText(mess, align="C", border="TLRB", fill=1)
self.fpdf.drawText("Ses", w=12, border="TLRB", fill=1, ln=0)
if self.sesg == "Y":
self.fpdf.drawText("Grp", w=12, border="TLRB", fill=1, ln=0)
self.fpdf.drawText("Name", border="TLRB", fill=1)
self.fpdf.setFont()
for gme in range(1, self.games + 1):
stxt = str("%3s" % gme)
if gme not in sess:
self.fpdf.drawText(stxt, w=12, border="TLRB", ln=0)
if self.sesg == "Y":
self.fpdf.drawText("", w=12, border="TLRB", ln=0)
self.fpdf.drawText("* No Valid Winner or Abandoned *",
border="TLRB")
continue
grps = list(sess[gme].keys())
grps.sort()
for grp in grps:
gtxt = "%3s" % chr(64 + grp)
self.fpdf.drawText(stxt, w=12, border="TLRB", ln=0)
if self.sesg == "Y":
self.fpdf.drawText(gtxt, w=12, border="TLRB", ln=0)
self.fpdf.drawText(sess[gme][grp], border="TLRB")
self.fpdf.drawText()
def doMatchWin(self):
for num, gcod in enumerate(self.keys):
if self.wins[gcod]:
if gcod:
if self.cfmat == "R":
mess = "Match Winners - Section %s" % chr(64 + gcod)
else:
mess = "Match Winners - Group %s" % chr(64 + gcod)
else:
mess = "Match Winners"
self.fpdf.setFont(style="B", size=14)
self.fpdf.drawText(mess, align="C", border="TLRB", fill=1)
self.fpdf.drawText("Pos", w=12, border="TLRB", fill=1,
ln=0)
self.fpdf.drawText("Name", border="TLRB", fill=1)
self.fpdf.setFont()
for n, s in enumerate(self.wins[gcod]):
ptxt = "%3s" % (n + 1)
self.fpdf.drawText(ptxt, w=12, border="TLRB", ln=0)
self.fpdf.drawText(s, border="TLRB")
if not num % 2:
ly = self.fpdf.get_y()
if num % 2 and self.fpdf.get_y() > ly:
ly = self.fpdf.get_y()
self.fpdf.drawText()
place = ["1st", "2nd", "3rd"]
for x in range(4, 21):
place.append("%sth" % x)
if self.tsize == 2:
ppos = ("Skip", "Lead")
elif self.tsize == 3:
ppos = ("Skip", "Second", "Lead")
elif self.tsize == 4:
ppos = ("Skip", "Third", "Second", "Lead")
for gcod in self.keys:
if not self.grps[gcod][2]:
continue
for num, skp in enumerate(self.wins[gcod]):
self.fpdf.add_page()
self.fpdf.setFont(style="B", size=24)
self.fpdf.drawText(self.cdes, h=10, align="C")
self.fpdf.drawText()
self.fpdf.setFont(style="B", size=18)
if gcod:
self.fpdf.drawText("GROUP %s" % chr(64 + gcod),
h=10, align="C")
self.fpdf.drawText()
self.fpdf.drawText("%s Prize R%s - %s" % (place[num],
self.grps[gcod][2][num], skp), h=10, align="C")
self.fpdf.setFont(style="B", size=16)
for pos in ppos:
self.fpdf.drawText()
self.fpdf.drawText()
self.fpdf.drawText("%s's Name" % pos, w=50, h=8,
border="TLRB", ln=0, fill=1)
self.fpdf.drawText("", h=8, border="TLRB")
self.fpdf.drawText("Bank Name", w=50, h=8,
border="TLRB", ln=0, fill=1)
self.fpdf.drawText("", h=8, border="TLRB")
self.fpdf.drawText("Branch Name", w=50, h=8,
border="TLRB", ln=0, fill=1)
self.fpdf.drawText("", h=8, border="TLRB")
self.fpdf.drawText("Branch Code", w=50, h=8,
border="TLRB", ln=0, fill=1)
self.fpdf.drawText("", h=8, border="TLRB")
self.fpdf.drawText("Account Number", w=50, h=8,
border="TLRB", ln=0, fill=1)
self.fpdf.drawText("", h=8, border="TLRB")
self.fpdf.drawText()
self.fpdf.setFont(style="B", size=18)
self.fpdf.drawText("Congratulations and Well Done!", h=10,
align="C")
def pageHeading(self, htyp=None):
self.fpdf.add_page()
head = "%s - %s" % (self.opts["conam"], self.cdes)
self.fpdf.drawText(head, font=["courier", "B", 18], align="C")
if htyp == "S":
self.fpdf.drawText()
self.fpdf.drawText("Match Summary", font=["courier", "B", 16],
align="C")
self.fpdf.drawText()
self.pglin = 4
else:
self.pglin = 1
def groupHeading(self, rtyp, group):
self.fpdf.drawText(font=["courier", "B", 18], align="C")
if rtyp == "G":
head = "Results for Game Number: %s" % self.pgame
else:
head = "Match Standings After Game Number: %s" % self.pgame
if group:
if self.cfmat == "R":
head += " for Section: %s" % chr(64 + group)
else:
head += " for Group: %s" % chr(64 + group)
self.fpdf.drawText(head, font=["courier", "B", 16], align="C")
self.fpdf.drawText()
self.fpdf.setFont(style="B")
self.printLine("Pos", "%-30s" % "Name", " +For ", " -Agt ",
" =Dif ", " Pts ", fill=1)
self.fpdf.setFont()
self.pglin += 4
def printLine(self, a, b, c, d, e, f, fill=0):
x = 10
w = self.fpdf.get_string_width("X"*len(a)) + 1
self.fpdf.drawText(a, x=x, w=w, border="TLB", fill=fill, ln=0)
x += w
w = self.fpdf.get_string_width("X"*len(b)) + 1
self.fpdf.drawText(b, x=x, w=w, border="TLB", fill=fill, ln=0)
x += w
w = self.fpdf.get_string_width("X"*len(c)) + 1
self.fpdf.drawText(c, x=x, w=w, border="TLB", fill=fill, ln=0)
x += w
w = self.fpdf.get_string_width("X"*len(d)) + 1
self.fpdf.drawText(d, x=x, w=w, border="TLB", fill=fill, ln=0)
x += w
w = self.fpdf.get_string_width("X"*len(e)) + 1
self.fpdf.drawText(e, x=x, w=w, border="TLB", fill=fill, ln=0)
x += w
w = self.fpdf.get_string_width("X"*len(f)) + 1
self.fpdf.drawText(f, x=x, w=w, border="TLRB", fill=fill)
def doPrizes(self, grp):
self.przgrp = grp
if grp:
if self.cfmat == "R":
tit = "Prizes for Section %s" % chr(64 + grp)
else:
tit = "Prizes for Group %s" % chr(64 + grp)
else:
tit = "Prizes for Match"
r1s = (("Yes", "Y"), ("No", "N"))
fld = (
(("T",0,0,0),"IUI",2,"Number of Prizes","",
3,"N",self.doPrzNum,None,None,("efld",)),
(("T",0,1,0),("IRB",r1s),0,"EFT Forms","",
"N","N",self.doPrzEft,None,None,None),
(("T",0,2,0),"IUI",5,"1st Prize","",
0,"N",self.doPrzAmt,None,None,None),
(("T",0,3,0),"IUI",5,"2nd Prize","",
0,"N",self.doPrzAmt,None,None,None),
(("T",0,4,0),"IUI",5,"3rd Prize","",
0,"N",self.doPrzAmt,None,None,None),
(("T",0,5,0),"IUI",5,"4th Prize","",
0,"N",self.doPrzAmt,None,None,None),
(("T",0,6,0),"IUI",5,"5th Prize","",
0,"N",self.doPrzAmt,None,None,None),
(("T",0,7,0),"IUI",5,"6th Prize","",
0,"N",self.doPrzAmt,None,None,None),
(("T",0,8,0),"IUI",5,"7th Prize","",
0,"N",self.doPrzAmt,None,None,None),
(("T",0,9,0),"IUI",5,"8th Prize","",
0,"N",self.doPrzAmt,None,None,None),
(("T",0,10,0),"IUI",5,"9th Prize","",
0,"N",self.doPrzAmt,None,None,None),
(("T",0,11,0),"IUI",5,"10th Prize","",
0,"N",self.doPrzAmt,None,None,None))
tnd = ((self.doPrzEnd,"n"),)
self.pz = TartanDialog(self.opts["mf"], tops=True, title=tit,
eflds=fld, tend=tnd, txit=None)
for x in range(10):
self.pz.setWidget(self.pz.topLabel[0][2+x], state="hide")
self.pz.setWidget(self.pz.topEntry[0][2+x], state="hide")
self.pz.mstFrame.wait_window()
def doPrzNum(self, frt, pag, r, c, p, i, w):
if not w and self.cfmat != "R":
ok = askQuestion(self.opts["mf"].body, "Prizes",
"Are You Sure that there are No Prizes?", default="no")
if ok == "no":
return "Invalid Number od Prizes"
self.prznum = w
if not self.prznum:
self.przeft = []
self.pz.loadEntry(frt, pag, p+1, data="N")
return "nd"
def doPrzEft(self, frt, pag, r, c, p, i, w):
if w == "N":
self.przeft = []
return "nd"
self.przeft = [0, 0, 0, 0, 0, 0, 0, 0, 0, 0]
for x in range(self.prznum):
self.pz.setWidget(self.pz.topLabel[0][2+x], state="show")
self.pz.setWidget(self.pz.topEntry[0][2+x], state="show")
for x in range(self.prznum, 10):
self.pz.setWidget(self.pz.topLabel[0][2+x], state="hide")
self.pz.setWidget(self.pz.topEntry[0][2+x], state="hide")
def doPrzAmt(self, frt, pag, r, c, p, i, w):
self.przeft[p-2] = w
if p == self.prznum + 1:
return "nd"
def doPrzEnd(self):
self.grps[self.przgrp][1] = self.prznum
self.grps[self.przgrp][2] = self.przeft
self.pz.closeProcess()
def doSecEnd(self):
ccod = getNextCode(self.sql, "bwlcmp", "bcm_code",
where=[("bcm_cono", "=", self.opts["conum"])], last=999)
self.sql.updRec("bwlcmp", cols=["bcm_poff"], data=[ccod],
where=[("bcm_cono", "=", self.opts["conum"]),
("bcm_code", "=", self.ccod)])
cdes = self.cdes + " Play-Off"
t = time.localtime()
cdte = ((t[0] * 10000) + (t[1] * 100) + t[2])
self.sql.insRec("bwlcmp", data=[self.opts["conum"],
ccod, cdes, cdte, 0, ""])
for skp in self.swin:
self.sql.insRec("bwlent", data=[self.opts["conum"],
ccod, skp, 0, "Y", ""])
callModule(self.opts["mf"], self.df, "bc2050", coy=[self.opts["conum"],
self.opts["conam"]], args=ccod)
def doExit(self):
self.df.closeProcess()
self.opts["mf"].closeLoop()
class bs3010(object):
def __init__(self, **opts):
self.opts = opts
if self.setVariables():
self.mainProcess()
self.opts["mf"].startLoop()
def setVariables(self):
self.sql = Sql(self.opts["mf"].dbm, ["bksmst", "bksaut", "bksown"],
prog=self.__class__.__name__)
if self.sql.error:
return
t = time.localtime()
self.curdt = time.strftime("%Y-%m", t)
self.image = os.path.join(self.opts["mf"].rcdic["wrkdir"], "books.png")
if not os.path.exists(self.image):
getImage("books", fle=self.image)
if not os.path.exists(self.image):
self.image = None
return True
def mainProcess(self):
lst = {
"stype": "R",
"tables": ("bksmst", ),
"cols": (("bmf_mnth", "", 0, "Month"), ),
"where": [("bmf_cono", "=", self.opts["conum"])],
"group": "bmf_mnth",
"order": "bmf_mnth"
}
r1s = (("All", "A"), ("Current", "C"), ("Removed", "R"))
r2s = (("Title", "T"), ("Date", "D"), ("Author", "A"), ("Owner", "O"))
fld = ((("T", 0, 0, 0), "ID2", 7, "Last Meeting", "", "", "N",
self.doLast, lst, None, ("efld", )),
(("T", 0, 1, 0), ("IRB", r1s), 0, "Status", "", "A", "N",
self.doStatus, None, None, None),
(("T", 0, 2, 0), ("IRB", r2s), 0, "Order", "", "T", "N",
self.doOrder, None, None, None))
tnd = ((self.doEnd, "y"), )
txt = (self.doExit, )
self.df = TartanDialog(self.opts["mf"],
tops=False,
eflds=fld,
tend=tnd,
txit=txt,
view=("N", "V"),
mail=("B", "Y"))
def doLast(self, frt, pag, r, c, p, i, w):
self.last = w
self.new = False
def doStatus(self, frt, pag, r, c, p, i, w):
self.status = w
def doOrder(self, frt, pag, r, c, p, i, w):
self.order = w
def doEnd(self):
self.df.closeProcess()
if self.df.repeml[1] == "Y":
if not self.df.repeml[2]:
owns = self.sql.getRec("bksown",
cols=["bof_mail"],
where=[("bof_mail", "<>", ""),
("bof_stat", "=", "C")])
adds = None
for own in owns:
if not adds:
adds = own[0]
else:
adds = "%s,%s" % (adds, own[0])
self.df.repeml[2] = adds
if not self.df.repeml[3]:
self.df.repeml[3] = """Dear Member
Attached please find the latest list of books.
All books which came onto the list at the last meeting are highlighted and, if available, a precis will be printed at the end.
Thanks and Regards.
"""
tab = ["bksmst", "bksaut", "bksown"]
col = [
"bmf_stat", "bmf_titl", "bmf_code", "baf_snam", "baf_fnam",
"bmf_mnth", "bof_fnam", "bof_snam"
]
odr = ""
if self.status == "C":
whr = [("bmf_stat", "=", "C")]
elif self.status == "R":
whr = [("bmf_stat", "=", "X")]
else:
whr = []
odr = "bmf_stat"
whr.extend([("baf_code=bmf_auth", ), ("bof_code=bmf_ownr", )])
if self.order == "T":
if odr:
odr = "%s, bmf_titl" % odr
else:
odr = "bmf_titl"
elif self.order == "D":
if odr:
odr = "%s, bmf_mnth, bmf_titl" % odr
else:
odr = "bmf_mnth, bmf_titl"
elif self.order == "A":
if odr:
odr = "%s, baf_snam, baf_fnam, bmf_titl" % odr
else:
odr = "baf_snam, baf_fnam, bmf_titl"
elif self.order == "O":
if odr:
odr = "%s, bmf_ownr, bmf_titl" % odr
else:
odr = "bmf_ownr, bmf_titl"
recs = self.sql.getRec(tables=tab, cols=col, where=whr, order=odr)
if not recs:
showError(self.opts["mf"].body, "Selection Error",
"No Records Selected")
self.opts["mf"].closeLoop()
return
self.fpdf = MyFpdf(name="bs3010", head=90, auto=True)
self.fpdf.header = self.pageHeading
self.stat = recs[0][0]
self.fpdf.add_page()
new = []
for rec in recs:
stat = CCD(rec[0], "UA", 1).disp
if stat != self.stat:
self.stat = stat
self.fpdf.add_page()
titl = CCD(rec[1], "NA", 30).disp
code = CCD(rec[2], "UI", 4).disp
auth = CCD("%s, %s" % (rec[3], rec[4]), "NA", 30).disp
mnth = CCD(rec[5], "D2", 7).disp
ownr = CCD("%s %s" % (rec[6], rec[7][0]), "NA", 12).disp
if rec[5] < self.last:
fill = 0
else:
new.append([auth, titl])
fill = 1
self.fpdf.drawText("%1s %30s %4s %30s %7s %10s" %
(stat, titl, code, auth, mnth, ownr),
h=5,
fill=fill)
if new:
sp = SplashScreen(
self.opts["mf"].body,
"Preparing Summary of New Books ... Please Wait")
self.new = True
self.fpdf.add_page()
for book in new:
try:
if self.fpdf.get_y() > 260:
self.fpdf.add_page()
desc = self.getDesc(book)
if desc:
w = self.fpdf.cwth * 9
desc = desc.rstrip().encode("latin-1",
"ignore").decode(
"latin-1", "ignore")
self.fpdf.drawText(w=w, txt="Title: ", font="B", ln=0)
self.fpdf.drawText(txt=book[1].rstrip(), font="I")
self.fpdf.drawText(w=w, txt="Author: ", font="B", ln=0)
self.fpdf.drawText(txt=book[0].rstrip(), font="I")
self.fpdf.drawText(w=w,
txt="Details: ",
font="B",
ln=0)
self.fpdf.drawText(txt=desc, font="I", ctyp="M")
if book != new[-1]:
self.fpdf.drawText()
except:
pass
sp.closeSplash()
pdfnam = getModName(self.opts["mf"].rcdic["wrkdir"],
self.__class__.__name__,
self.opts["conum"],
ext="pdf")
self.fpdf.output(pdfnam, "F")
head = "Book List as at %s" % (self.curdt)
doPrinter(mf=self.opts["mf"],
conum=self.opts["conum"],
pdfnam=pdfnam,
header=head,
repprt=self.df.repprt,
repeml=self.df.repeml)
self.opts["mf"].closeLoop()
def pageHeading(self, new=False):
self.fpdf.setFont("Arial", "B", 15)
x = self.fpdf.get_x()
if self.image:
self.fpdf.image(self.image, 11, 10, 15, 20)
self.fpdf.image(self.image, 185, 10, 15, 20)
self.fpdf.cell(20)
self.fpdf.set_x(x)
self.fpdf.cell(0, 10, self.opts["conam"], "TLR", 1, "C")
if self.new:
txt = "Summary of New Books"
elif self.stat == "C":
txt = "Current Books as at %s" % self.curdt
else:
txt = "Removed Books as at %s" % self.curdt
self.fpdf.cell(0, 10, txt, "LRB", 1, "C")
self.fpdf.ln(8)
self.fpdf.setFont(style="B")
if not self.new:
self.fpdf.cell(
0, 5, "%-1s %-30s %-4s %-30s %-7s %-12s" %
("S", "Title", "Code", "Author", "Mth-Rec", "Owner"), "B")
self.fpdf.ln(5)
def getDesc(self, book):
auth = book[0].strip().lower()
titl = book[1].strip().lower().replace(",", "")
if titl[:4] == "the ":
titl = titl[4:]
elif titl[-4:] == " the":
titl = titl[:-4]
get = requests.get("https://www.googleapis.com/books/v1/volumes?q="\
"{intitle:'%s'+inauthor:'%s'" % (titl, auth), timeout=5)
if get.status_code == 200 and get.json()["totalItems"]:
ok = False
for item in get.json()["items"]:
tita = titl.lower().\
replace("the ","").replace(", the", "")
titb = item["volumeInfo"]["title"].lower().\
replace("the ","").replace(", the", "")
if titb.count(tita):
if "description" in item["volumeInfo"]:
ok = True
break
if ok:
return item["volumeInfo"]["description"]
def doExit(self):
self.df.closeProcess()
self.opts["mf"].closeLoop()
class bc3020(object):
def __init__(self, **opts):
self.opts = opts
if self.setVariables():
self.mainProcess()
self.opts["mf"].startLoop()
def setVariables(self):
self.sql = Sql(self.opts["mf"].dbm, ["bwldrm", "bwldrt", "bwltab"],
prog=self.__class__.__name__)
if self.sql.error:
return
gc = GetCtl(self.opts["mf"])
bwlctl = gc.getCtl("bwlctl", self.opts["conum"])
if not bwlctl:
return
self.nstart = bwlctl["ctb_nstart"]
self.fromad = bwlctl["ctb_emadd"]
t = time.localtime()
self.sysdt = time.strftime("%d %B %Y %H:%M:%S", t)
self.curdt = time.strftime("%Y-%m", t)
self.image = os.path.join(self.opts["mf"].rcdic["wrkdir"], "bowls.png")
if not os.path.exists(self.image):
getImage("bowls", fle=self.image)
if not os.path.exists(self.image):
self.image = None
self.drawn = "Y"
self.bounce = "N"
self.teams = "N"
return True
def mainProcess(self):
r1s = (("Yes", "Y"), ("No", "N"))
fld = ((("T", 0, 0, 0), "Id2", 7, "Starting Period", "", "", "N",
self.doStartPeriod, None, None, ("efld", )),
(("T", 0, 1, 0), "Id2", 7, "Ending Period", "", "", "N",
self.doEndPeriod, None, None,
("efld", )), (("T", 0, 2, 0), ("IRB", r1s), 0, "All Tabs", "",
"Y", "N", self.doTabs, None, None, None),
(("T", 0, 3, 0), ("ICB", "Tabs-In"), 0, "Draw Types", "",
self.drawn, "N", self.doType, None, None,
None), (("T", 0, 3, 0), ("ICB", "Bounce"), 0, "", "",
self.bounce, "N", self.doType, None, None, None),
(("T", 0, 3, 0), ("ICB", "Teams"), 0, "", "", self.teams, "N",
self.doType, None, None,
None), (("T", 0, 4, 0), ("IRB", r1s), 0, "Totals Only", "",
"N", "N", self.doTots, None, None, None))
tnd = ((self.doEnd, "y"), )
txt = (self.doExit, )
self.df = TartanDialog(self.opts["mf"],
tops=False,
eflds=fld,
tend=tnd,
txit=txt,
view=("N", "V"),
mail=("Y", "Y"))
def doStartPeriod(self, frt, pag, r, c, p, i, w):
if w:
self.start = CCD((w * 100) + 1, "D1", 7)
else:
self.start = CCD(0, "UI", 1)
def doEndPeriod(self, frt, pag, r, c, p, i, w):
if w:
self.end = CCD(mthendDate((w * 100) + 1), "D1", 7)
else:
self.end = CCD(0, "d1", 7)
self.end.disp = self.curdt
def doTabs(self, frt, pag, r, c, p, i, w):
self.whole = w
def doType(self, frt, pag, r, c, p, i, w):
if p == 3:
self.drawn = w
elif p == 4:
self.bounce = w
else:
self.teams = w
def doTots(self, frt, pag, r, c, p, i, w):
self.tots = w
def doEnd(self):
self.df.closeProcess()
dat = []
tps = []
if self.drawn == "Y":
tps.extend(["B", "D"])
if self.bounce == "Y":
tps.append("A")
if self.teams == "Y":
tps.append("C")
where = [("bdt_cono", "=", self.opts["conum"]),
("bdt_tab", "<", self.nstart), ("bdt_flag", "in", tps)]
if self.start.work:
where.append(("bdt_date", ">=", self.start.work))
if self.end.work:
where.append(("bdt_date", "<=", self.end.work))
whr = copyList(where)
if self.whole == "N":
tab = []
rec = getSingleRecords(self.opts["mf"],
"bwldrt", ("bdt_tab", "bdt_name"),
head=["X", "Tab-No", "Name"],
where=whr,
group="bdt_tab, bdt_name",
order="bdt_name",
selcol="bdt_name")
if not rec:
self.opts["mf"].closeLoop()
return
for r in rec:
tab.append(r[1])
whr.append(("bdt_tab", "in", tab))
odr = "bdt_name, bdt_date"
rec = self.sql.getRec("bwldrt", where=whr, order=odr)
c = self.sql.bwldrt_col
l = ""
self.dic = {}
for r in rec:
dte = CCD(r[c.index("bdt_date")], "D1", 10)
tim = r[c.index("bdt_time")]
bdm = self.sql.getRec("bwldrm",
where=[("bdm_cono", "=", self.opts["conum"]),
("bdm_date", "=", dte.work),
("bdm_time", "=", tim)],
limit=1)
if bdm[self.sql.bwldrm_col.index("bdm_dhist")] == "N":
continue
self.clash = ""
side = [["", ""], ["", ""], ["", ""], ["", ""]]
self.tab = r[c.index("bdt_tab")]
if self.tab not in self.dic:
self.dic[self.tab] = []
nam = self.getName(self.tab)
pos = (0 - (r[c.index("bdt_pos")] - 4))
side[pos] = ["", nam]
for x in range(1, 4):
tm = self.getName(r[c.index("bdt_team%s" % x)])
if not tm:
continue
if self.clash:
cl = "X"
else:
cl = ""
pos = (0 - (r[c.index("bdt_pos%s" % x)] - 4))
side[pos] = [cl, tm]
if self.tab != l:
if l:
dat.append([])
d = [nam]
else:
d = [""]
d.extend([dte.disp, side[0], side[1], side[2], side[3]])
dat.append(d)
l = self.tab
self.fpdf = MyFpdf(name=self.__class__.__name__, head=120, auto=True)
self.fpdf.header = self.pageHeading
if self.tots == "N":
# Print teams
self.heading = "main"
self.fpdf.add_page()
cwth = self.fpdf.get_string_width("X")
for d in dat:
if not d:
self.fpdf.drawText(txt="", w=0, h=5, border=0, ln=1)
else:
self.fpdf.cell(w=cwth * 21, h=5, txt=d[0], border=0, ln=0)
self.fpdf.cell(w=cwth * 11, h=5, txt=d[1], border=0, ln=0)
if d[2][0]:
self.fpdf.cell(w=cwth * 21,
h=5,
txt=d[2][1],
border=1,
ln=0)
else:
self.fpdf.cell(w=cwth * 21,
h=5,
txt=d[2][1],
border=0,
ln=0)
if d[3][0]:
self.fpdf.cell(w=cwth * 21,
h=5,
txt=d[3][1],
border=1,
ln=0)
else:
self.fpdf.cell(w=cwth * 21,
h=5,
txt=d[3][1],
border=0,
ln=0)
if d[4][0]:
self.fpdf.cell(w=cwth * 21,
h=5,
txt=d[4][1],
border=1,
ln=0)
else:
self.fpdf.cell(w=cwth * 21,
h=5,
txt=d[4][1],
border=0,
ln=0)
if d[5][0]:
self.fpdf.cell(w=cwth * 21,
h=5,
txt=d[5][1],
border=1,
ln=1)
else:
self.fpdf.cell(w=cwth * 21,
h=5,
txt=d[5][1],
border=0,
ln=1)
if self.whole == "Y" or self.tots == "Y":
# Print top attendees
self.heading = "summary"
whr = copyList(where)
whr.append(("bdt_tab", "<", self.nstart))
self.cnt = self.sql.getRec("bwldrt",
cols=["count(*) as count", "bdt_tab"],
where=whr,
group="bdt_tab",
order="count desc, bdt_name")
while self.cnt:
self.fpdf.add_page()
if len(self.cnt) < 26:
left = copyList(self.cnt)
self.cnt = []
right = []
else:
left = self.cnt[:25]
self.cnt = self.cnt[25:]
if len(self.cnt) < 26:
right = copyList(self.cnt)
self.cnt = []
else:
right = self.cnt[:25]
self.cnt = self.cnt[25:]
left = left + (25 - len(left)) * [["", ""]]
right = right + (25 - len(right)) * [["", ""]]
self.fpdf.set_font("Arial", "", 15)
cwth = self.fpdf.get_string_width("X")
for x in range(25):
if left[x][1]:
left[x][1] = self.getName(left[x][1], cls=False)
if right[x][1]:
right[x][1] = self.getName(right[x][1], cls=False)
self.fpdf.cell(cwth * 5, 8, "%5s " % left[x][0], 0, 0, "R")
self.fpdf.cell(cwth * 24, 8, left[x][1], 0, 0, "L")
self.fpdf.cell(cwth * 5, 8, "%5s " % right[x][0], 0, 0,
"R")
self.fpdf.cell(cwth * 20, 8, right[x][1], 0, 1, "L")
pdfnam = getModName(self.opts["mf"].rcdic["wrkdir"],
self.__class__.__name__,
self.opts["conum"],
ext="pdf")
self.fpdf.output(pdfnam, "F")
head = "Tabs Draw Summary for the period %s to %s" % (self.start.disp,
self.end.disp)
doPrinter(mf=self.opts["mf"],
conum=self.opts["conum"],
pdfnam=pdfnam,
header=head,
repprt=self.df.repprt,
fromad=self.fromad,
repeml=self.df.repeml)
self.opts["mf"].closeLoop()
def getName(self, tab, cls=True):
self.clash = False
if not tab:
return ""
rec = self.sql.getRec("bwltab",
cols=["btb_surname", "btb_names", "btb_rate1"],
where=[("btb_tab", "=", tab)],
limit=1)
if not rec:
return "VISITOR, A"
if rec[1]:
nam = "%s, %s" % (rec[0], rec[1][0])
else:
nam = rec[0]
nam = nam.replace("VAN DER", "V D")
nam = nam.replace("JANSE VAN", "J V")
if cls:
if tab in self.dic[self.tab]:
self.clash = True
self.dic[self.tab].append(tab)
return nam
def pageHeading(self):
self.fpdf.setFont("Arial", "B", 15)
if os.path.isfile(self.image):
self.fpdf.image(self.image, 10, 10, 15, 11)
self.fpdf.cell(20)
x = self.fpdf.get_x()
self.fpdf.cell(0, 10, self.opts["conam"], "TLR", 1, "C")
self.fpdf.set_x(x)
if self.heading == "main":
self.fpdf.cell(0, 10, "Tabs-In for the period %s to %s" % \
(self.start.disp, self.end.disp), "LRB", 1, "C")
self.fpdf.ln(8)
self.fpdf.setFont(style="B")
self.fpdf.cell(0, 5, "%-20s %-10s %-20s %-20s %-20s %-20s" % \
("Member", " Date", "Skip", "Third", "Second", "Lead"), "B")
self.fpdf.ln(5)
else:
self.fpdf.cell(0, 10, "Top Attendees for the period "\
"%s to %s" % (self.start.disp, self.end.disp),
"LRB", 0, "C")
self.fpdf.ln(15)
self.fpdf.cell(
0, 5,
"%5s %-50s %5s %-30s" % ("Count", "Member", "Count", "Member"),
"B")
self.fpdf.ln(10)
def doExit(self):
self.df.closeProcess()
self.opts["mf"].closeLoop()
