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