def setVariables(self):
self.sql = Sql(self.opts["mf"].dbm, ["wagltf"],
prog=self.__class__.__name__)
if self.sql.error:
return
gc = GetCtl(self.opts["mf"])
wagctl = gc.getCtl("wagctl", self.opts["conum"])
if not wagctl:
return
lir = wagctl["ctw_i_date"]
self.fromad = wagctl["ctw_emadd"]
t = time.localtime()
self.sysdtw = (t[0] * 10000) + (t[1] * 100) + t[2]
if lir:
fy = int(lir / 10000)
fm = int(lir / 100) - (fy * 100) + 1
if fm == 13:
fy = fy + 1
fm = 1
self.sdate = (fy * 100) + fm
else:
self.sdate = 0
self.edate = int(self.sysdtw / 100)
self.totind = "N"
return True
def setVariables(self):
gc = GetCtl(self.opts["mf"])
cshctl = gc.getCtl("cshctl", self.opts["conum"])
if not cshctl:
return
self.glint = cshctl["ccc_glint"]
self.fromad = cshctl["ccc_emadd"]
if self.glint == "Y":
tabs = ["genmst"]
else:
tabs = ["cshmst"]
tabs.extend(["cshcnt", "cshana"])
self.sql = Sql(self.opts["mf"].dbm,
tables=tabs,
prog=self.__class__.__name__)
if self.sql.error:
return
self.dte = self.sql.getRec("cshcnt",
cols=["max(cct_date)"],
where=[("cct_cono", "=", self.opts["conum"])
],
limit=1)[0]
self.denoms = (("R200", 200), ("R100", 100), ("R50", 50), ("R20", 20),
("R10", 10), ("R5", 5), ("R2", 2), ("R1", 1),
("C50", .5), ("C20", .2), ("C10", .1), ("C5", .05),
("C2", .02), ("C1", .01))
return True
def setVariables(self):
gc = GetCtl(self.opts["mf"])
ctlmst = gc.getCtl("ctlmst", self.opts["conum"])
if not ctlmst:
return
mods = ctlmst["ctm_modules"]
self.genleg = False
for x in range(0, len(mods), 2):
if mods[x:x + 2] == "GL":
self.genleg = True
break
tabs = ["assctl", "chglog"]
if self.genleg:
tabs.extend(["ctlctl", "genmst"])
self.sql = Sql(self.opts["mf"].dbm, tabs, prog=self.__class__.__name__)
if self.sql.error:
return
self.acc = self.sql.getRec("assctl",
where=[("cta_cono", "=", self.opts["conum"])
],
limit=1)
if not self.acc:
self.new = True
self.acc = [self.opts["conum"], "N", "N", 0, "", ""]
else:
self.new = False
if self.genleg:
self.ctl = [["ass_sls", "Sale of Assets", 0]]
ctlctl = gc.getCtl("ctlctl", self.opts["conum"])
if not ctlctl:
return
for num, ctl in enumerate(self.ctl):
if ctl[0] in ctlctl:
self.ctl[num][2] = ctlctl[ctl[0]]
return True
def setVariables(self):
self.sql = Sql(self.opts["mf"].dbm, ["drsact", "drstyp", "drsmst"],
prog=self.__class__.__name__)
if self.sql.error:
return
gc = GetCtl(self.opts["mf"])
drsctl = gc.getCtl("drsctl", self.opts["conum"])
if not drsctl:
return
self.fromad = drsctl["ctd_emadd"]
t = time.localtime()
self.sysdtw = (t[0] * 10000) + (t[1] * 100) + t[2]
self.sysdtd = "%i/%02i/%02i" % (t[0], t[1], t[2])
self.sysdttm = "(Printed on: %i/%02i/%02i at %02i:%02i)" % \
(t[0], t[1], t[2], t[3], t[4])
self.colsh = [
"Chn", "Acc-Num", "Name", "Address", "Code", "Tel-Number",
"Fax-Number", "Contact Details", "Deliver", "Rep", "Act", "Typ",
"P", "Rft", "C-Limit"
]
self.forms = [("UI", 3), ("NA", 7), ("NA", 30), ("NA", 30), ("NA", 4),
("NA", 12), ("NA", 12), ("NA", 40), ("Na", 7), ("Na", 3),
("UA", 3), ("UA", 3), ("UI", 1), ("UI", 3), ("UI", 3),
("UI", 7)]
return True
def setVariables(self):
self.sql = Sql(self.opts["mf"].dbm, ["strgrp", "strloc", "strmf1"],
prog=self.__class__.__name__)
if self.sql.error:
return
gc = GetCtl(self.opts["mf"])
strctl = gc.getCtl("strctl", self.opts["conum"])
if not strctl:
return
self.locs = strctl["cts_locs"]
slsctl = gc.getCtl("slsctl", self.opts["conum"])
if not slsctl:
return
self.fromad = slsctl["ctv_emadd"]
t = time.localtime()
self.sysdtw = (t[0] * 10000) + (t[1] * 100) + t[2]
self.sysdttm = "(Printed on: %i/%02i/%02i at %02i:%02i) %6s" % (
t[0], t[1], t[2], t[3], t[4], self.__class__.__name__)
self.colsh = [[
"", "", "", "", ["*********** Month to Date **********", 4, 7],
["*********** Year To Date ***********", 8, 11]
]]
self.colsh.append([
"Grp", "Product-Code", "Description", "U.O.I", "Quantity", "Value",
"Profit", "Prft-%", "Quantity", "Value", "Profit", "Prft-%"
])
self.forms = [("UA", 3), ("NA", 20), ("NA", 30), ("NA", 10), ("SI", 9),
("SI", 9), ("SI", 9), ("SD", 7.2), ("SI", 9), ("SI", 9),
("SI", 9), ("SD", 7.2)]
self.stot = [0] * 6
self.gtot = [0] * 6
return True
def setVariables(self):
# Create SQL Object
self.sql = Sql(self.opts["mf"].dbm, [
"assgrp", "crsmst", "ctlctl", "ctlmst", "ctlvmf", "drsmst",
"drschn", "genint", "genmst", "genrcc", "rtlprm"
],
prog=self.__class__.__name__)
if self.sql.error:
return
# Check for Intercompany Facility
if not self.sql.getRec("ctlmst",
cols=["count(*)"],
where=[("ctm_cono", "<>", self.opts["conum"])],
limit=1)[0]:
self.incoac = False
else:
itg = self.sql.getRec("genint",
cols=["cti_inco"],
where=[("cti_cono", "=", self.opts["conum"])
])
if itg:
self.incoac = [self.opts["conum"]]
[self.incoac.append(coy[0]) for coy in itg]
else:
self.incoac = False
#
self.gc = GetCtl(self.opts["mf"])
return True
def setVariables(self):
self.sql = Sql(self.opts["mf"].dbm, [
"genmst", "gentrn", "lonctl", "lonmf1", "lonmf2", "lonrte",
"lontrn"
],
prog=self.__class__.__name__)
if self.sql.error:
return
self.gc = GetCtl(self.opts["mf"])
lonctl = self.gc.getCtl("lonctl", self.opts["conum"])
if not lonctl:
return
self.glint = lonctl["cln_glint"]
self.drate = lonctl["cln_drte"]
self.crate = lonctl["cln_crte"]
self.lastd = lonctl["cln_last"]
if self.glint == "Y":
ctlctl = self.gc.getCtl("ctlctl", self.opts["conum"])
if not ctlctl:
return
if self.gc.chkRec(self.opts["conum"], ctlctl, ["lon_ctl"]):
return
self.glctl = (ctlctl["lon_ctl"], ctlctl["int_rec"],
ctlctl["int_pay"])
else:
self.glctl = None
t = time.localtime()
self.sysdtw = (t[0] * 10000) + (t[1] * 100) + t[2]
return True
def setVariables(self):
self.sql = Sql(
self.opts["mf"].dbm,
["ctlvmf", "drschn", "drsmst", "drsrcm", "drsrct", "genmst"],
prog=self.__class__.__name__)
if self.sql.error:
return
self.gc = GetCtl(self.opts["mf"])
ctlmst = self.gc.getCtl("ctlmst", self.opts["conum"])
if not ctlmst:
return
self.taxdf = ctlmst["ctm_taxdf"]
if not self.taxdf:
self.taxdf = "N"
drsctl = self.gc.getCtl("drsctl", self.opts["conum"])
if not drsctl:
return
self.glint = drsctl["ctd_glint"]
self.chains = drsctl["ctd_chain"]
self.glac = 0
if self.glint == "Y":
ctlctl = self.gc.getCtl("ctlctl", self.opts["conum"])
if not ctlctl:
return
ctls = ["drs_ctl", "vat_ctl", "dis_all"]
if self.gc.chkRec(self.opts["conum"], ctlctl, ctls):
return
self.s_per = int(self.opts["period"][1][0] / 100)
self.e_per = int(self.opts["period"][2][0] / 100)
return True
def setVariables(self):
self.sql = Sql(self.opts["mf"].dbm,
"strtrn",
prog=self.__class__.__name__)
if self.sql.error:
return
gc = GetCtl(self.opts["mf"])
strctl = gc.getCtl("strctl", self.opts["conum"])
if not strctl:
return
self.fromad = strctl["cts_emadd"]
t = time.localtime()
self.sysdtw = (t[0] * 10000) + (t[1] * 100) + t[2]
self.sysdttm = "(Printed on: %i/%02i/%02i at %02i:%02i)" % \
(t[0], t[1], t[2], t[3], t[4])
self.colsh = [
"TP", "BatchNo", "Grp", "Product-Code", "L", "Reference", "Date",
"Remarks", "Acc-Num", "Quantity", "Cost-Value", "Sale-Value"
]
self.forms = [("UI", 2, False, False, True), ("Na", 7), ("UA", 3),
("NA", 20), ("UA", 1), ("Na", 9), ("D1", 10), ("NA", 30),
("NA", 7), ("SD", 13.2), ("SD", 13.2), ("SD", 13.2)]
self.curdt = int(self.sysdtw / 100)
self.gcnt = [0] * (len(sttrtp) + 1)
self.gqty = [0] * (len(sttrtp) + 1)
self.gcst = [0] * (len(sttrtp) + 1)
self.gsel = [0] * (len(sttrtp) + 1)
self.totind = "N"
return True
def setVariables(self):
gc = GetCtl(self.opts["mf"])
assctl = gc.getCtl("assctl", self.opts["conum"])
if not assctl:
return
self.glint = assctl["cta_glint"]
self.rordp = assctl["cta_rordp"]
self.lastp = assctl["cta_lastp"]
self.sper = int(self.opts["period"][1][0] / 100)
self.eper = int(self.opts["period"][2][0] / 100)
yr = int(self.lastp / 100)
mt = (self.lastp % 100) + 1
if mt > 12:
yr += 1
mt = 1
self.curdt = (yr * 100) + mt
if self.curdt > self.eper:
self.curdt = self.eper
t = time.localtime()
self.sysdtw = (t[0] * 10000) + (t[1] * 100) + t[2]
tabs = ["assctl", "assgrp", "assmst", "assdep", "asstrn", "gentrn"]
self.sql = Sql(self.opts["mf"].dbm, tabs, prog=self.__class__.__name__)
if self.sql.error:
return
chk = self.sql.getRec("asstrn",
where=[("ast_cono", "=", self.opts["conum"]),
("ast_mtyp", "=", 4),
("ast_curdt", ">", self.eper)])
if chk:
if not self.args:
showError(self.opts["mf"].body, "Period Error",
"Depreciation Has Already Been Raised in "\
"the Next Financial Period")
return
return True
def setVariables(self):
self.tables = (("ctlnot", "not_key"), ("drsdel", "del_code"),
("ctlvtf", "vtt_cono", "vtt_acno", "vtt_styp"),
("drsmst", "drm_cono", "drm_chain", "drm_acno",
"drm_delivery"), ("drsrct", "dct_cono", "dct_chain",
"dct_acno"),
("drstrn", "drt_cono", "drt_chain", "drt_acno"),
("drsage", "dra_cono", "dra_chain",
"dra_acno"), ("genrcc", "grc_cono", "grc_achn",
"grc_adrs"), ("slsiv1", "si1_cono",
"si1_chain", "si1_acno"),
("strmf1", "st1_cono", "st1_chn_excl",
"st1_acc_excl"), ("strtrn", "stt_cono", "stt_chain",
"stt_acno", "stt_styp"))
tabs = ["drschn"]
for tab in self.tables:
tabs.append(tab[0])
self.sql = Sql(self.opts["mf"].dbm, tabs, prog=self.__class__.__name__)
if self.sql.error:
return
gc = GetCtl(self.opts["mf"])
drsctl = gc.getCtl("drsctl", self.opts["conum"])
if not drsctl:
return
self.chains = drsctl["ctd_chain"]
self.autogen = "N"
return True
def setVariables(self):
self.sql = Sql(self.opts["mf"].dbm, ["assgrp", "assmst", "asstrn"],
prog=self.__class__.__name__)
if self.sql.error:
return
self.gc = GetCtl(self.opts["mf"])
assctl = self.gc.getCtl("assctl", self.opts["conum"])
if not assctl:
return
self.rordp = assctl["cta_rordp"]
self.fromad = assctl["cta_emadd"]
t = time.localtime()
self.sysdtw = (t[0] * 10000) + (t[1] * 100) + t[2]
self.sysdtd = "%i/%02i/%02i" % (t[0], t[1], t[2])
self.sysdttm = "(Printed on: %i/%02i/%02i at %02i:%02i) %6s" % (
t[0], t[1], t[2], t[3], t[4], self.__class__.__name__)
self.sper = int(self.opts["period"][1][0] / 100)
self.eper = int(self.opts["period"][2][0] / 100)
self.head = "%03u %-30s" % (self.opts["conum"], self.opts["conam"])
self.colsh = [
"Code", "Description", "Purch-Date", "Cost-Price", "Accum-Dep",
"Opening-Bal", "Purchases", "Improvements", "Write-Offs",
"Depreciation", "Sales", "Profit/Loss", "Closing-Bal"
]
self.forms = [("Na", 7), ("NA", 30), ("d1", 10)] + [("SD", 13.2)] * 10
self.stot = [0, 0, 0, 0, 0, 0, 0, 0, 0, 0]
self.gtot = [0, 0, 0, 0, 0, 0, 0, 0, 0, 0]
self.oldgrp = ""
return True
def setVariables(self):
self.sql = Sql(self.opts["mf"].dbm,
["genmst", "gentrn", "wagmst", "waglmf", "wagltf"],
prog=self.__class__.__name__)
if self.sql.error:
return
self.col = self.sql.waglmf_col
gc = GetCtl(self.opts["mf"])
wagctl = gc.getCtl("wagctl", self.opts["conum"])
if not wagctl:
return
self.glint = wagctl["ctw_glint"]
if self.glint == "Y":
ctlctl = gc.getCtl("ctlctl", self.opts["conum"])
if not ctlctl:
return
ctls = ["wag_slc", "wag_sli"]
if gc.chkRec(self.opts["conum"], ctlctl, ctls):
return
self.glctls = (ctlctl["wag_slc"], ctlctl["wag_sli"])
else:
self.glctls = None
self.batchHeader()
if not self.bh.batno:
return
t = time.localtime()
self.sysdtw = (t[0] * 10000) + (t[1] * 100) + t[2]
return True
def setVariables(self):
self.tables = (
("ctlnot", "not_key"),
("slsiv2", "si2_cono", "si2_group", "si2_code"),
("slsiv3", "si3_cono", "si3_rgroup", "si3_rcode"),
("strmf1", "st1_cono", "st1_group", "st1_code"),
("strmf2", "st2_cono", "st2_group", "st2_code"),
("strpot", "pot_cono", "pot_group", "pot_code"),
("strprc", "stp_cono", "stp_group", "stp_code"),
("strrcp", "srr_cono", "srr_group", "srr_code"),
("strrcp", "srr_cono", "srr_rgroup", "srr_rcode"),
("strtrn", "stt_cono", "stt_group", "stt_code"),
("strvar", "stv_cono", "stv_group", "stv_code"))
tabs = ["strgrp"]
for tab in self.tables:
if not tabs.count(tab[0]):
tabs.append(tab[0])
self.sql = Sql(self.opts["mf"].dbm, tabs, prog=self.__class__.__name__)
if self.sql.error:
return
gc = GetCtl(self.opts["mf"])
crsctl = gc.getCtl("crsctl", self.opts["conum"])
if not crsctl:
return
return True
def setVariables(self):
self.sql = Sql(self.opts["mf"].dbm, [
"gentrn", "strmf1", "strmf2", "strgmu", "strcmu", "strprc",
"strtrn"
],
prog=self.__class__.__name__)
if self.sql.error:
return
gc = GetCtl(self.opts["mf"])
strctl = gc.getCtl("strctl", self.opts["conum"])
if not strctl:
return
self.glint = strctl["cts_glint"]
self.locs = strctl["cts_locs"]
self.plevs = strctl["cts_plevs"]
if self.glint == "Y":
ctlctl = gc.getCtl("ctlctl", self.opts["conum"])
if not ctlctl:
return
ctls = ["stk_soh", "stk_susp"]
if gc.chkRec(self.opts["conum"], ctlctl, ctls):
return
self.stk_soh = ctlctl["stk_soh"]
self.stk_susp = ctlctl["stk_susp"]
t = time.localtime()
self.sysdtw = (t[0] * 10000) + (t[1] * 100) + t[2]
return True
def setVariables(self):
self.sql = Sql(self.opts["mf"].dbm, ["lontrn"],
prog=self.__class__.__name__)
if self.sql.error:
return
gc = GetCtl(self.opts["mf"])
lonctl = gc.getCtl("lonctl", self.opts["conum"])
if not lonctl:
return
self.fromad = lonctl["cln_emadd"]
t = time.localtime()
self.sysdttm = "(Printed on: %i/%02i/%02i at %02i:%02i)" % \
(t[0], t[1], t[2], t[3], t[4])
self.head = "%03u %-30s" % (self.opts["conum"], self.opts["conam"])
self.colsh = ["TP", "BatchNo", "Acc-Num", "Ln", "Reference",
"Trans-Date", "Remarks", "Debits", "Credits"]
self.forms = [("UI", 2), ("NA", 7), ("UA", 7), ("UI", 2),
("Na", 9), ("D1", 10), ("NA", 30), ("SD", 13.2), ("SD", 13.2)]
self.sper = int(self.opts["period"][1][0] / 100)
self.eper = int(self.opts["period"][2][0] / 100)
self.gqt = [0,0,0,0,0]
self.gam = [0,0,0,0,0]
self.prtrtp = copyList(lntrtp)
self.prtrtp[3] = ("DRI", "Debit Interest")
self.prtrtp.append(("CRI", "Credit Interest"))
self.totind = "N"
return True
def setVariables(self):
self.sql = Sql(
self.opts["mf"].dbm,
["genmst", "gentrn", "wagedc", "wagmst", "waglmf", "wagltf"],
prog=self.__class__.__name__)
if self.sql.error:
return
self.gc = GetCtl(self.opts["mf"])
wagctl = self.gc.getCtl("wagctl", self.opts["conum"])
if not wagctl:
return
self.glint = wagctl["ctw_glint"]
if self.glint == "Y":
ctlctl = self.gc.getCtl("ctlctl", self.opts["conum"])
if not ctlctl:
return
if self.gc.chkRec(self.opts["conum"], ctlctl, ["wag_slc"]):
return
self.slnctl = ctlctl["wag_slc"]
self.bh = Batches(self.opts["mf"],
self.opts["conum"],
self.opts["conam"],
self.opts["period"],
"SLN",
2,
glint=self.glint)
self.bh.doBatchHeader()
if not self.bh.batno:
return
t = time.localtime()
self.sysdtw = (t[0] * 10000) + (t[1] * 100) + t[2]
return True
def setVariables(self):
gc = GetCtl(self.opts["mf"])
lonctl = gc.getCtl("lonctl", self.opts["conum"])
if not lonctl:
return
glint = lonctl["cln_glint"]
tab = ["lonctl", "lonmf2", "lontrn"]
if glint == "Y":
ctlctl = gc.getCtl("ctlctl", self.opts["conum"])
if not ctlctl:
return
ctls = ["lon_ctl", "int_rec", "int_pay"]
if gc.chkRec(self.opts["conum"], ctlctl, ctls):
return
self.glctl = (
ctlctl["lon_ctl"], ctlctl["int_rec"], ctlctl["int_pay"])
tab.append("gentrn")
else:
self.glctl = None
self.sql = Sql(self.opts["mf"].dbm, tables=tab,
prog=self.__class__.__name__)
if self.sql.error:
return
t = time.localtime()
self.sysdtw = (t[0] * 10000) + (t[1] * 100) + t[2]
yr = int(self.sysdtw / 10000)
mt = (int(self.sysdtw / 100) % 100) - 1
self.lme = mthendDate((yr * 10000) + (mt * 100) + 1)
return True
def setVariables(self):
self.tit = ("%03i %s" % (self.opts["conum"], self.opts["conam"]),
"Bookings Manager Audit Trail (%s)" %
self.__class__.__name__)
self.sql = Sql(self.opts["mf"].dbm,
["ctlmst", "bkmmst", "bkmtrn", "bkmcon"],
prog=self.__class__.__name__)
if self.sql.error:
return
gc = GetCtl(self.opts["mf"])
bkmctl = gc.getCtl("bkmctl", self.opts["conum"])
if not bkmctl:
return
self.fromad = bkmctl["cbk_emadd"]
t = time.localtime()
self.sysdtw = (t[0] * 10000) + (t[1] * 100) + t[2]
self.sysdttm = "(Printed on: %i/%02i/%02i at %02i:%02i) %6s" % (
t[0], t[1], t[2], t[3], t[4], self.__class__.__name__)
self.colsh = [
"TP", "BatchNo", "Book-Num", "Name", "Reference", "Date", "Debits",
"Credits", "Tax-Amount", "T", "Remarks"
]
self.forms = [("UI", 2, False, False, True), ("Na", 7),
("NA", 8, False, False, True), ("NA", 30), ("Na", 9),
("D1", 10), ("SD", 13.2), ("SD", 13.2), ("SD", 13.2),
("UA", 1), ("NA", 30)]
self.gqt = [0] * (len(bktrtp) + 1)
self.gdr = [0] * (len(bktrtp) + 1)
self.gcr = [0] * (len(bktrtp) + 1)
self.gvt = [0] * (len(bktrtp) + 1)
self.totind = "N"
return True
def setVariables(self):
self.sql = Sql(self.opts["mf"].dbm, [
"ctlvmf", "drschn", "drsmst", "genmst", "strgrp", "strloc",
"strmf1", "strmf2", "strgmu", "strcmu", "strrcp", "strtrn",
"struoi"
],
prog=self.__class__.__name__)
if self.sql.error:
return
gc = GetCtl(self.opts["mf"])
strctl = gc.getCtl("strctl", self.opts["conum"])
if not strctl:
return
self.glint = strctl["cts_glint"]
self.plevs = strctl["cts_plevs"]
self.automu = strctl["cts_automu"]
if strctl["cts_locs"] == "Y":
self.locs = self.sql.getRec("strloc",
cols=["count(*)"],
where=[("srl_cono", "=",
self.opts["conum"])],
limit=1)[0]
else:
self.locs = 1
t = time.localtime()
self.sysdtw = (t[0] * 10000) + (t[1] * 100) + t[2]
self.per_from = 0
self.per_to = 0
return True
def setVariables(self):
self.sql = Sql(self.opts["mf"].dbm, ["ctlmst", "rtlmst", "rtltrn"],
prog=self.__class__.__name__)
if self.sql.error:
return
gc = GetCtl(self.opts["mf"])
rtlctl = gc.getCtl("rtlctl", self.opts["conum"])
if not rtlctl:
return
self.fromad = rtlctl["ctr_emadd"]
t = time.localtime()
self.sysdtw = (t[0] * 10000) + (t[1] * 100) + t[2]
self.sysdttm = "(Printed on: %i/%02i/%02i at %02i:%02i)" % \
(t[0], t[1], t[2], t[3], t[4])
self.colsh = [
"TP", "BatchNo", "Prm-Cod", "Acc-Num", "Name", "Reference", "Date",
"Debits", "Credits", "Tax-Amount", "T", "Remarks"
]
self.forms = [("UI", 2, False, False, True), ("Na", 7), ("NA", 7),
("NA", 7), ("NA", 30), ("Na", 9), ("D1", 10),
("SD", 13.2), ("SD", 13.2), ("SD", 13.2), ("UA", 1),
("NA", 30)]
self.s_per = int(self.opts["period"][1][0] / 100)
self.e_per = int(self.opts["period"][2][0] / 100)
self.gqt = [0] * (len(rttrtp) + 1)
self.gdr = [0] * (len(rttrtp) + 1)
self.gcr = [0] * (len(rttrtp) + 1)
self.gvt = [0] * (len(rttrtp) + 1)
self.totind = "N"
return True
def setVariables(self):
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"]
self.sql = Sql(self.opts["mf"].dbm, [
"ctlmst", "bwlclb", "bwlflf", "bwlflm", "bwlflo", "bwltab",
"bwlfls", "bwlflt"
],
prog=self.__class__.__name__)
if self.sql.error:
return
acc = self.sql.getRec("bwlclb",
where=[("bcc_code", "=", self.opts["conum"])])
if not acc:
self.sql.insRec("bwlclb",
data=[self.opts["conum"], self.opts["conam"]])
self.opts["mf"].dbm.commitDbase()
self.reprint = False
self.fmat = 0
self.date = 0
self.skip = 0
return True
def setVariables(self):
self.tit = ("%03i %s" % (self.opts["conum"], self.opts["conam"]),
"Members Category Changes (%s)" % self.__class__.__name__)
self.sql = Sql(self.opts["mf"].dbm,
["chglog", "memcat", "memctc", "memmst"],
prog=self.__class__.__name__)
if self.sql.error:
return
gc = GetCtl(self.opts["mf"])
memctl = gc.getCtl("memctl", self.opts["conum"])
if not memctl:
return
self.fromad = memctl["mcm_emadd"]
t = time.localtime()
self.sysdtw = (t[0] * 10000) + (t[1] * 100) + t[2]
self.sysdttm = "(Printed on: %i/%02i/%02i at %02i:%02i)" % \
(t[0], t[1], t[2], t[3], t[4])
self.head = "%03u %-30s" % (self.opts["conum"], self.opts["conam"])
self.colsh = [
"Mem-No", "Titles", "Inits", "Surname", "Actions", "Category",
"Action-Dte", "Operator", "Start-Date", " End-Date", "Last-Date"
]
self.forms = [("UI", 6), ("NA", 6), ("NA", 5), ("NA", 30), ("UA", 7),
("NA", 30), ("D1", 10), ("NA", 20), ("d1", 10),
("d1", 10), ("d1", 10)]
self.ctyp = (("All", "A"), ("New", "N"), ("Updated", "U"), ("Deleted",
"D"))
self.catg = (("All", "X"), ("Fees", "A"), ("Main", "B"),
("Sports", "C"), ("Debentures", "D"))
return True
def setVariables(self):
gc = GetCtl(self.opts["mf"])
ctlsys = gc.getCtl("ctlsys")
if not ctlsys:
return
self.dep = ctlsys["sys_gl_dep"]
self.dig = ctlsys["sys_gl_dig"]
self.sql = Sql(self.opts["mf"].dbm, ["genmst", "genrpt"],
prog=self.__class__.__name__)
if self.sql.error:
return
self.genrpt_fd = self.sql.genrpt_dic
self.genrpt_cl = self.sql.genrpt_col
self.pags = ["","Q","H","L","G","S","T","U","C","P"]
self.head = ["glr_desc", "glr_high", "glr_ffeed", "glr_ignore"]
self.ledger = [
"glr_from", "glr_to", "glr_high", "glr_obal", "glr_accum",
"glr_print", "glr_norm", "glr_acbal", "glr_ignore",
"glr_store", "glr_snum1", "glr_acstr"]
self.group = [
"glr_group", "glr_desc", "glr_from", "glr_to", "glr_high",
"glr_obal", "glr_accum", "glr_print", "glr_norm", "glr_acbal",
"glr_ignore", "glr_store", "glr_snum1", "glr_acstr", "glr_label"]
self.store = [
"glr_desc", "glr_high", "glr_print", "glr_norm", "glr_acbal",
"glr_clear", "glr_snum1", "glr_strper"]
self.total = [
"glr_desc", "glr_high", "glr_total", "glr_print", "glr_norm",
"glr_clear", "glr_store", "glr_snum1", "glr_acstr", "glr_label"]
self.uline = ["glr_high", "glr_uline"]
self.calc = [
"glr_desc", "glr_high", "glr_cbase", "glr_ctype", "glr_snum2",
"glr_camnt", "glr_snum3"]
self.percent = ["glr_desc", "glr_high", "glr_snum1", "glr_snum2"]
return True
def setVariables(self):
self.sql = Sql(self.opts["mf"].dbm, ["strgrp", "strloc", "strmf1"],
prog=self.__class__.__name__)
if self.sql.error:
return
gc = GetCtl(self.opts["mf"])
drsctl = gc.getCtl("drsctl", self.opts["conum"])
if not drsctl:
self.chnstr = "N"
else:
self.chnstr = drsctl["ctd_chain"]
strctl = gc.getCtl("strctl", self.opts["conum"])
if not strctl:
return
self.locs = strctl["cts_locs"]
slsctl = gc.getCtl("slsctl", self.opts["conum"])
if not slsctl:
return
self.fromad = slsctl["ctv_emadd"]
t = time.localtime()
self.sysdtw = (t[0] * 10000) + (t[1] * 100) + t[2]
self.sysdttm = "(Printed on: %i/%02i/%02i at %02i:%02i) %6s" % (
t[0], t[1], t[2], t[3], t[4], self.__class__.__name__)
self.forms = [("UA", 3), ("NA", 20), ("NA", 30),
("NA", 10)] + [("SI", 10)] * 12
self.stots = [0] * 12
self.gtots = [0] * 12
self.mchart = []
self.tipe = None
return True
def setVariables(self):
self.sql = Sql(self.opts["mf"].dbm, [
"ctlvrf", "strloc", "strgrp", "strgmu", "strcmu", "strprc",
"strmf1", "strmf2", "strtrn"
],
prog=self.__class__.__name__)
if self.sql.error:
return
gc = GetCtl(self.opts["mf"])
strctl = gc.getCtl("strctl", self.opts["conum"])
if not strctl:
return
self.locs = strctl["cts_locs"]
self.plevs = strctl["cts_plevs"]
self.fromad = strctl["cts_emadd"]
t = time.localtime()
self.sysdtw = (t[0] * 10000) + (t[1] * 100) + t[2]
self.sysdtd = "%i/%02i/%02i" % (t[0], t[1], t[2])
self.sysdttm = "(Printed on: %i/%02i/%02i at %02i:%02i) %6s" % (
t[0], t[1], t[2], t[3], t[4], self.__class__.__name__)
self.stot = [0] * 6
self.gtot = [0] * 6
self.pdfnam = getModName(self.opts["mf"].rcdic["wrkdir"],
self.__class__.__name__,
self.opts["conum"],
ext="pdf")
return True
def setVariables(self):
self.sql = Sql(self.opts["mf"].dbm,
["strloc", "strgrp", "strmf1", "strtrn"],
prog=self.__class__.__name__)
if self.sql.error:
return
gc = GetCtl(self.opts["mf"])
strctl = gc.getCtl("strctl", self.opts["conum"])
if not strctl:
return
self.locs = strctl["cts_locs"]
self.fromad = strctl["cts_emadd"]
t = time.localtime()
self.sysdtw = (t[0] * 10000) + (t[1] * 100) + t[2]
self.sysdtd = "%i/%02i/%02i" % (t[0], t[1], t[2])
self.sysdttm = "(Printed on: %i/%02i/%02i at %02i:%02i) %6s" % (
t[0], t[1], t[2], t[3], t[4], self.__class__.__name__)
self.colsh = [
"Grp", "Product-Code", "Description", "U.O.I", "Qty-Balance",
"Val-Balance"
]
self.forms = [("UA", 3), ("NA", 20), ("NA", 30), ("NA", 10),
("SD", 12.2), ("SD", 12.2)]
self.gtot = 0
return True
def setVariables(self):
self.sql = Sql(self.opts["mf"].dbm, [
"ctlmst", "memctk", "memmst", "memadd", "memkon", "memctc",
"memctk"
],
prog=self.__class__.__name__)
if self.sql.error:
return
gc = GetCtl(self.opts["mf"])
ctlsys = gc.getCtl("ctlsys")
if not ctlsys:
return
self.smtp = []
for fld in ("msvr", "mprt", "msec", "maut", "mnam", "mpwd"):
self.smtp.append(ctlsys["sys_%s" % fld])
if not self.smtp[0]:
showError(self.opts["mf"].body, "SMTP Error",
"There is NO SMTP Server in the System Record!")
return
ctlmst = gc.getCtl("ctlmst", self.opts["conum"])
if not ctlmst:
return
self.fadd = ctlmst["ctm_email"]
if not self.fadd:
showError(self.opts["mf"].body, "From Error",
"There is NO Email Address on the Company Record!")
return
memctl = gc.getCtl("memctl", self.opts["conum"])
if not memctl:
return
return True
def setVariables(self):
self.tables = (("bwldrt", "bdt_cono", "bdt_tab", "bdt_team1",
"bdt_team2", "bdt_team3"), ("bwlent", "bce_cono",
"bce_scod"),
("bwlflm", "bfm_cono", "bfm_captain"),
("bwlflt", "bft_cono", "bft_skip", "bft_player"),
("bwlgme", "bcg_cono", "bcg_scod",
"bcg_ocod"), ("bwltab", "btb_cono", "btb_tab"))
tabs = []
for tab in self.tables:
if tab[0] not in tabs:
tabs.append(tab[0])
self.sql = Sql(self.opts["mf"].dbm, tabs, 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.mlint = bwlctl["ctb_mlint"]
self.samen = bwlctl["ctb_samen"]
if self.mlint == "Y" and self.samen == "Y":
return
self.mstart = bwlctl["ctb_mstart"]
self.fstart = bwlctl["ctb_fstart"]
self.nstart = bwlctl["ctb_nstart"]
return True
def setVariables(self):
gc = GetCtl(self.opts["mf"])
wagctl = gc.getCtl("wagctl", self.opts["conum"])
if not wagctl:
return
self.fromad = wagctl["ctw_emadd"]
return True
