def loadDataset(self, dataSet): conn = sqlite3.connect('storage.db') # @UndefinedVariable conn.row_factory = sqlite3.Row # @UndefinedVariable cur = conn.cursor() sqlStr = self.parentView.getSql("fBrowser_getApplViews") for row in cur.execute(sqlStr, (dataSet["mainView"], )): item = {} fields = row.keys() for index in range(len(fields)): item[fields[index]] = row[index] dataSet["applviews"].append(dict2obj(item)) sqlStr = self.parentView.getSql("fBrowser_getViewFields") for row in cur.execute(sqlStr, (dataSet["mainView"], )): item = {} fields = row.keys() for index in range(len(fields)): item[fields[index]] = row[index] dataSet["viewfields"].append(dict2obj(item)) dataSet["userconfig"] = [] conn.close() dataSetInfo = [{ "infoName": "userconfig", "infoType": "table", "classAlias": "ui_userconfig", "filterStr": "employee_id=" + str(self.parentView.application.app_settings["employee_id"]) + " and (cfgroup='browserConfig' or section='" + dataSet["mainView"] + "') ", "orderStr": None }] conn = npiAdapter(self.parentView.application.app_settings["url"] + "/" + self.parentView.application.app_config["connection"] ["npi_service"]) response = conn.loadDataSet(self.parentView.getCredentials(), dataSetInfo) if response == "error": return else: for recordSetInfo in response: for record in recordSetInfo["recordSet"]: dataSet[recordSetInfo["infoName"]].append( dict2obj(record, "ui_" + recordSetInfo["infoName"])) dataSet["changeData"] = False
def initDataSet(self, _iniId=-1): dataSet = {} customerRow = dict2obj({"id":None, "custtype":None, "custnumber":None, "custname":None, "taxnumber":None,"account":None, "notax":0, "terms":0, "creditlimit":0, "discount":0, "notes":None, "inactive":0, "deleted":0}, "customer") customerRow.id = _iniId dataSet["customer"] = [] dataSet["customer"].append(customerRow) dataSet["groups"] = [] dataSet["deffield"] = [] dataSet["deffield_prop"] = [] dataSet["link"] = [] dataSet["_link"] = [] dataSet["fieldvalue"] = [] dataSet["_fieldvalue"] = [] dataSet["address"] = [] dataSet["_address"] = [] dataSet["contact"] = [] dataSet["_contact"] = [] dataSet["calendar_view"] = [] dataSet["changeData"] = False dataSet["fieldvalueId"] = 0 dataSet["addressId"] = 0 dataSet["contactId"] = 0 dataSet["linkId"] = 0 dataSet["deletedFlag"] = False dataSet["newCustnumber"] = "" return dataSet
def setConfig(self, dataSet, icfgroup, icfname, ivalue, iorderby=None, isection=None, deleteRow=False): for config in dataSet["userconfig"]: if config.section == isection and config.cfgroup == icfgroup and config.cfname == icfname: if deleteRow == False: config.cfvalue = ivalue config.orderby = iorderby else: dataSet["userconfig"].remove(config) dataSet["_userconfig"].append(config) return config = dict2obj({}, "ui_userconfig") config.employee_id = self.parentView.application.app_settings[ "employee_id"] config.section = isection config.cfgroup = icfgroup config.cfname = icfname config.cfvalue = ivalue config.orderby = iorderby dataSet["userconfig"].append(config)
def addFieldRow(self, dataSet, df, urlink = "", ct_id = 0, ct_desc = ""): fieldtype = self.parentView.getItemFromKey(dataSet["groups"], "id", self.parentView.getItemFromKey(dataSet["deffield"], "fieldname", df.fieldname).fieldtype).groupvalue if fieldtype in("urlink","notes","customer","tool","trans","transitem","transmovement","transpayment","product","project","employee","place"): wx.MessageBox("Sorry, but this fieldtype ("+fieldtype+") is not handled...", ":-(", wx.OK | wx.ICON_ERROR) return cf = dict2obj({"id":None, "fieldname":None, "ref_id":None, "value":None, "notes":None, "deleted":0},"fieldvalue") dataSet["fieldvalueId"] = dataSet["fieldvalueId"] + 1 cf.id = -dataSet["fieldvalueId"] cf.fieldname = df.fieldname cf.ref_id = dataSet["customer"][0].id cf.fieldtype = self.parentView.getItemFromKey(dataSet["groups"], "id", self.parentView.getItemFromKey(dataSet["deffield"], "fieldname", df.fieldname).fieldtype).groupvalue cf.description = self.parentView.getItemFromKey(dataSet["deffield"], "fieldname", df.fieldname).description cf.visible = bool(self.parentView.getItemFromKey(dataSet["deffield"], "fieldname", df.fieldname).visible) cf.readonly = bool(self.parentView.getItemFromKey(dataSet["deffield"], "fieldname", df.fieldname).visible) if cf.fieldtype=="bool": cf.value = "f" elif cf.fieldtype=="date": cf.value = date.strftime(date.today(),"%Y-%m-%d") elif cf.fieldtype in("integer", "float"): cf.value = "0" elif cf.fieldtype=="urlink": cf.value = urlink elif cf.fieldtype=="valuelist": cf.valuelist = self.parentView.getItemFromKey(dataSet["deffield"], "fieldname", df.fieldname).valuelist elif cf.fieldtype in("customer","tool","trans","transitem","transmovement","transpayment","product","project","employee","place"): cf.value = str(ct_id) cf.valuelist = ct_desc dataSet["fieldvalue"].append(cf) dataSet["changeData"] = True
def addCustomerGroups(self, dataSet, groups_id): for item in dataSet["link"]: if item.ref_id_2 == groups_id: return cg = dict2obj( { "id": None, "nervatype_1": None, "ref_id_1": None, "nervatype_2": None, "ref_id_2": None, "linktype": 0, "deleted": 0 }, "link") dataSet["linkId"] = dataSet["linkId"] + 1 cg.id = -dataSet["linkId"] cg.nervatype_1 = self.parentView.getItemFromKey2( dataSet["groups"], "groupname", "nervatype", "groupvalue", "customer").id cg.ref_id_1 = dataSet["customer"][0].id cg.nervatype_2 = self.parentView.getItemFromKey2( dataSet["groups"], "groupname", "nervatype", "groupvalue", "groups").id cg.ref_id_2 = groups_id cg.description = self.parentView.getItemFromKey( dataSet["groups"], "id", groups_id).groupvalue dataSet["link"].append(cg) dataSet["changeData"] = True
def addFieldRow(self, dataSet, df, urlink="", ct_id=0, ct_desc=""): fieldtype = self.parentView.getItemFromKey( dataSet["groups"], "id", self.parentView.getItemFromKey(dataSet["deffield"], "fieldname", df.fieldname).fieldtype).groupvalue if fieldtype in ("urlink", "notes", "customer", "tool", "trans", "transitem", "transmovement", "transpayment", "product", "project", "employee", "place"): wx.MessageBox( "Sorry, but this fieldtype (" + fieldtype + ") is not handled...", ":-(", wx.OK | wx.ICON_ERROR) return cf = dict2obj( { "id": None, "fieldname": None, "ref_id": None, "value": None, "notes": None, "deleted": 0 }, "fieldvalue") dataSet["fieldvalueId"] = dataSet["fieldvalueId"] + 1 cf.id = -dataSet["fieldvalueId"] cf.fieldname = df.fieldname cf.ref_id = dataSet["customer"][0].id cf.fieldtype = self.parentView.getItemFromKey( dataSet["groups"], "id", self.parentView.getItemFromKey(dataSet["deffield"], "fieldname", df.fieldname).fieldtype).groupvalue cf.description = self.parentView.getItemFromKey( dataSet["deffield"], "fieldname", df.fieldname).description cf.visible = bool( self.parentView.getItemFromKey(dataSet["deffield"], "fieldname", df.fieldname).visible) cf.readonly = bool( self.parentView.getItemFromKey(dataSet["deffield"], "fieldname", df.fieldname).visible) if cf.fieldtype == "bool": cf.value = "f" elif cf.fieldtype == "date": cf.value = date.strftime(date.today(), "%Y-%m-%d") elif cf.fieldtype in ("integer", "float"): cf.value = "0" elif cf.fieldtype == "urlink": cf.value = urlink elif cf.fieldtype == "valuelist": cf.valuelist = self.parentView.getItemFromKey( dataSet["deffield"], "fieldname", df.fieldname).valuelist elif cf.fieldtype in ("customer", "tool", "trans", "transitem", "transmovement", "transpayment", "product", "project", "employee", "place"): cf.value = str(ct_id) cf.valuelist = ct_desc dataSet["fieldvalue"].append(cf) dataSet["changeData"] = True
def addAddressRow(self, dataSet): addr = dict2obj({"id":None, "nervatype":None, "ref_id":None, "country":None, "state":None, "zipcode":None, "city":None, "street":None, "notes":None, "deleted":0},"address") dataSet["addressId"] = dataSet["addressId"] + 1 addr.id = -dataSet["addressId"] addr.nervatype = self.parentView.getItemFromKey2(dataSet["groups"], "groupname", "nervatype", "groupvalue", "customer").id addr.ref_id = dataSet["customer"][0].id dataSet["address"].append(addr) dataSet["changeData"] = True
def addContactRow(self, dataSet): cont = dict2obj({"id":None, "nervatype":None, "ref_id":None, "firstname":None, "surname":None, "status":None, "phone":None, "fax":None, "mobil":None, "email":None, "notes":None, "deleted":0},"contact") dataSet["contactId"] = dataSet["contactId"] + 1 cont.id = -dataSet["contactId"] cont.nervatype = self.parentView.getItemFromKey2(dataSet["groups"], "groupname", "nervatype", "groupvalue", "customer").id cont.ref_id = dataSet["customer"][0].id dataSet["contact"].append(cont) dataSet["changeData"] = True
def loadDataset(self, dataSet): conn = sqlite3.connect('storage.db') # @UndefinedVariable conn.row_factory = sqlite3.Row # @UndefinedVariable cur = conn.cursor() sqlStr = self.parentView.getSql("fBrowser_getApplViews") for row in cur.execute(sqlStr, (dataSet["mainView"],)): item = {}; fields = row.keys() for index in range(len(fields)): item[fields[index]] = row[index] dataSet["applviews"].append(dict2obj(item)) sqlStr = self.parentView.getSql("fBrowser_getViewFields") for row in cur.execute(sqlStr, (dataSet["mainView"],)): item = {}; fields = row.keys() for index in range(len(fields)): item[fields[index]] = row[index] dataSet["viewfields"].append(dict2obj(item)) dataSet["userconfig"] = [] conn.close() dataSetInfo = [{"infoName":"userconfig", "infoType":"table", "classAlias":"ui_userconfig", "filterStr":"employee_id="+str(self.parentView.application.app_settings["employee_id"])+ " and (cfgroup='browserConfig' or section='"+dataSet["mainView"]+"') ", "orderStr":None}] conn = npiAdapter(self.parentView.application.app_settings["url"]+"/"+ self.parentView.application.app_config["connection"]["npi_service"]) response = conn.loadDataSet(self.parentView.getCredentials(), dataSetInfo) if response=="error": return else: for recordSetInfo in response: for record in recordSetInfo["recordSet"]: dataSet[recordSetInfo["infoName"]].append(dict2obj(record,"ui_"+recordSetInfo["infoName"])) dataSet["changeData"] = False
def addCustomerGroups(self, dataSet, groups_id): for item in dataSet["link"]: if item.ref_id_2 == groups_id: return cg = dict2obj({"id":None, "nervatype_1":None, "ref_id_1":None, "nervatype_2":None, "ref_id_2":None, "linktype":0, "deleted":0},"link") dataSet["linkId"] = dataSet["linkId"] + 1 cg.id = -dataSet["linkId"] cg.nervatype_1 = self.parentView.getItemFromKey2(dataSet["groups"], "groupname", "nervatype", "groupvalue", "customer").id cg.ref_id_1 = dataSet["customer"][0].id cg.nervatype_2 = self.parentView.getItemFromKey2(dataSet["groups"], "groupname", "nervatype", "groupvalue", "groups").id cg.ref_id_2 = groups_id cg.description = self.parentView.getItemFromKey(dataSet["groups"], "id", groups_id).groupvalue dataSet["link"].append(cg) dataSet["changeData"] = True
def initDataSet(self, _iniId=-1): dataSet = {} customerRow = dict2obj( { "id": None, "custtype": None, "custnumber": None, "custname": None, "taxnumber": None, "account": None, "notax": 0, "terms": 0, "creditlimit": 0, "discount": 0, "notes": None, "inactive": 0, "deleted": 0 }, "customer") customerRow.id = _iniId dataSet["customer"] = [] dataSet["customer"].append(customerRow) dataSet["groups"] = [] dataSet["deffield"] = [] dataSet["deffield_prop"] = [] dataSet["link"] = [] dataSet["_link"] = [] dataSet["fieldvalue"] = [] dataSet["_fieldvalue"] = [] dataSet["address"] = [] dataSet["_address"] = [] dataSet["contact"] = [] dataSet["_contact"] = [] dataSet["calendar_view"] = [] dataSet["changeData"] = False dataSet["fieldvalueId"] = 0 dataSet["addressId"] = 0 dataSet["contactId"] = 0 dataSet["linkId"] = 0 dataSet["deletedFlag"] = False dataSet["newCustnumber"] = "" return dataSet
def setConfig(self, dataSet, icfgroup, icfname, ivalue, iorderby=None, isection=None, deleteRow=False): for config in dataSet["userconfig"]: if config.section==isection and config.cfgroup==icfgroup and config.cfname==icfname: if deleteRow==False: config.cfvalue = ivalue config.orderby = iorderby else: dataSet["userconfig"].remove(config) dataSet["_userconfig"].append(config) return config = dict2obj({},"ui_userconfig") config.employee_id = self.parentView.application.app_settings["employee_id"] config.section = isection config.cfgroup = icfgroup config.cfname = icfname config.cfvalue = ivalue config.orderby = iorderby dataSet["userconfig"].append(config)
def setFilterData(self): self.dg_filters.ClearGrid() dataField=["fieldlabel", "ftype", "fvalue"] headerText={"fieldlabel":self.getLocale("filter_fieldname_headerText"), "ftype":self.getLocale("filter_ftype_headerText"), "fvalue":self.getLocale("filter_fvalue_headerText")} filter_table = [] for citem in self.dataSet["userconfig"]: if citem.section == self.mainView and citem.cfgroup == self.sectionView and citem.cfname.startswith("filter_"): fitem = dict2obj(json.loads(citem.cfvalue)) fitem.citem = citem filter_table.append(fitem) stable = filterTable(dataField, headerText, self.filter_type, filter_table, self.setFilterSource) self.dg_filters.SetTable(stable, True) self.dg_filters.SetColSize(0, 150) self.dg_filters.SetColSize(1, 50) self.dg_filters.SetColSize(2, 160) self.dg_filters.ForceRefresh()
def addAddressRow(self, dataSet): addr = dict2obj( { "id": None, "nervatype": None, "ref_id": None, "country": None, "state": None, "zipcode": None, "city": None, "street": None, "notes": None, "deleted": 0 }, "address") dataSet["addressId"] = dataSet["addressId"] + 1 addr.id = -dataSet["addressId"] addr.nervatype = self.parentView.getItemFromKey2( dataSet["groups"], "groupname", "nervatype", "groupvalue", "customer").id addr.ref_id = dataSet["customer"][0].id dataSet["address"].append(addr) dataSet["changeData"] = True
def addContactRow(self, dataSet): cont = dict2obj( { "id": None, "nervatype": None, "ref_id": None, "firstname": None, "surname": None, "status": None, "phone": None, "fax": None, "mobil": None, "email": None, "notes": None, "deleted": 0 }, "contact") dataSet["contactId"] = dataSet["contactId"] + 1 cont.id = -dataSet["contactId"] cont.nervatype = self.parentView.getItemFromKey2( dataSet["groups"], "groupname", "nervatype", "groupvalue", "customer").id cont.ref_id = dataSet["customer"][0].id dataSet["contact"].append(cont) dataSet["changeData"] = True