def load_org_list(self):
self.ids['scroll'].clear_widgets() #To clear list of orgs
query = f'''SELECT ORG_ID,NAME,REGISTRATION FROM ORG WHERE
ORG_ID IN (SELECT ORG_ID FROM CONTACT_ORG WHERE CONTACT_ID={globalvariables.var_userid}
AND MEMBER_FLAG='Y' AND STATUS='Y')'''
# run direct SQL
stmt = ibm_db.exec_immediate(connection.conn, query)
orglist = ibm_db.fetch_both(stmt)
item = TwoLineAvatarListItem()
if orglist is False:
self.ids['nogroupwarning'].pos_hint = {"x": 0.2, "y": 0.3}
self.ids['nogroupwarning'].font_size = '20sp'
self.ids[
'nogroupwarning'].text = """You have not joined any groups.
Your joined groups will show up here"""
else:
while (orglist):
file_found = download_org_image(str(orglist[0]))
if file_found == True:
image = ImageLeftWidget(source="resources/org/" +
str(orglist[0]) + ".png")
else:
image = ImageLeftWidget(source="resources/org/default.jpg")
item = TwoLineAvatarListItem(text=str(orglist[1]),
secondary_text=str(orglist[2]))
item.add_widget(image)
item.bind(on_release=self.row_press)
self.ids['scroll'].add_widget(item)
orglist = ibm_db.fetch_both(
stmt) #for incrementing rows inside while loop
def load_group_page(self):
ContentNavigationDrawer.populateNavDrawerValues(self)
self.ids['allorgscroll'].clear_widgets() #To clear list of orgs
query = f'''SELECT ORG_ID,NAME,REGISTRATION FROM ORG WHERE
ORG_ID IN (
SELECT ORG_ID FROM ORG
MINUS
SELECT ORG_ID FROM CONTACT_ORG WHERE CONTACT_ID = {globalvariables.var_userid}
AND STATUS='Y')'''
# run direct SQL
stmt = ibm_db.exec_immediate(connection.conn, query)
orglist = ibm_db.fetch_both(stmt)
item = TwoLineAvatarListItem()
while (orglist):
file_found = download_org_image(str(orglist[0]))
if file_found == True:
image = ImageLeftWidget(source="resources/org/" +
str(orglist[0]) + ".png")
else:
image = ImageLeftWidget(source="resources/org/default.jpg")
item = TwoLineAvatarListItem(text=str(orglist[1]),
secondary_text=str(orglist[2]))
item.add_widget(image)
item.bind(on_release=self.row_press)
self.ids['allorgscroll'].add_widget(item)
orglist = ibm_db.fetch_both(
stmt) #for incrementing rows inside while loop