def __setFilter__(self):
self.insertRow(0)
for idx, header in enumerate(self.columns):
if header in ['번호', '설정']:
item = QTableWidgetItem('')
item.setFlags(Qt.ItemIsEditable)
self.setItem(0, idx, item)
elif header == '개월수':
items = self.dataFrame[header].drop_duplicates().tolist()
i = 0
p = []
for item in items:
try:
items[i] = int(item)
except:
p.append(i)
i += 1
p.reverse()
for i in p:
items.pop(i)
items.sort()
items = ['전체'] + [str(item) for item in items]
CbxFilterInTable(idx, items, self)
elif header == '사업비':
items = self.dataFrame[header].drop_duplicates().tolist()
i = 0
p = []
for item in items:
item = item.replace(',', '')
try:
items[i] = int(item)
except:
p.append(i)
i += 1
p.reverse()
for i in p:
items.pop(i)
items.sort()
items = ['전체'] + [format(item, ',') for item in items]
CbxFilterInTable(idx, items, self)
else:
items = self.dataFrame[header].drop_duplicates().tolist()
if '' in items:
items.remove('')
items.sort()
items = ['전체'] + items
CbxFilterInTable(idx, items, self)
def __setFilter__(self):
self.insertRow(0)
for idx, header in enumerate(self.columns):
items = self.dataFrame[header].drop_duplicates().tolist()
if '' in items:
items.remove('')
items.sort()
items = ['전체'] + items
CbxFilterInTable(idx, items, self)
def __setFilter__(self):
self.insertRow(0)
for idx, header in enumerate(self.columns):
if idx == 0:
item = QTableWidgetItem('')
item.setFlags(Qt.ItemIsEditable)
self.setItem(0, idx, item)
elif idx == 7:
items = [
'전체'
] + self.dataFrame['적용상태_사업'].drop_duplicates().tolist()
CbxFilterInTable(idx, items, self)
else:
items = self.dataFrame[header].drop_duplicates().tolist()
if '' in items:
items.remove('')
items.sort()
items = ['전체'] + items
CbxFilterInTable(idx, items, self)
def __setFilter__(self):
self.insertRow(0)
for idx, header in enumerate(self.columns):
if header in ['수정한날짜', '비밀번호', '설정']:
item = QTableWidgetItem('')
item.setFlags(Qt.ItemIsEditable)
self.setItem(0, idx, item)
else:
items = ['전체'] + self.dataFrame[header].drop_duplicates().tolist()
CbxFilterInTable(idx, items, self)
def __setFilter__(self):
self.insertRow(0)
for idx, header in enumerate(self.columns):
if header in ['번호', '수정한날짜', '설정']:
item = QTableWidgetItem('')
item.setFlags(Qt.ItemIsEditable)
self.setItem(0, idx, item)
else:
items = self.dataFrame[header].tolist()
items.remove(items[0])
items.remove(items[-1])
items = ['전체'] + list(tuple(set(items)))
CbxFilterInTable(idx, items, self)
def __setFilter__(self):
self.insertRow(0)
for idx, header in enumerate(self.columns):
items = ['전체'] + self.dataFrame[header].drop_duplicates().tolist()
CbxFilterInTable(idx, items, self)
def __setFilter__(self):
self.insertRow(0)
for idx, header in enumerate(self.columns):
if header in ['비밀번호', '설정']:
item = QTableWidgetItem('')
item.setFlags(Qt.ItemIsEditable)
self.setItem(0, idx, item)
elif header == '주민등록번호':
items = self.dataFrame[header].drop_duplicates().tolist()
i = 0
p = []
for item in items:
item = item.replace('-', '')
try:
items[i] = int(item)
except:
p.append(i)
i += 1
p.reverse()
for i in p:
items.pop(i)
items.sort()
for i, item in enumerate(items):
if len(str(item)) != 7:
items[i] = '0' * (7 - len(str(item))) + str(item)
items = ['전체'] + [
f"{str(item)[:6]}-{str(item)[6]}" for item in items
]
CbxFilterInTable(idx, items, self)
elif header == '연락처':
items = self.dataFrame[header].drop_duplicates().tolist()
i = 0
p = []
for item in items:
item = item.replace('-', '')
try:
items[i] = int(item)
except:
p.append(i)
i += 1
p.reverse()
for i in p:
items.pop(i)
items.sort()
items = ['전체'] + [
f"0{str(item)[:2]}-{str(item)[2:6]}-{str(item)[6:]}"
for item in items
]
CbxFilterInTable(idx, items, self)
elif header == '과학기술인등록번호':
items = self.dataFrame[header].drop_duplicates().tolist()
i = 0
p = []
for item in items:
try:
items[i] = int(item)
except:
p.append(i)
i += 1
p.reverse()
for i in p:
items.pop(i)
items.sort()
items = ['전체'] + [str(item) for item in items]
CbxFilterInTable(idx, items, self)
else:
items = self.dataFrame[header].drop_duplicates().tolist()
if '' in items:
items.remove('')
items.sort()
items = ['전체'] + items
CbxFilterInTable(idx, items, self)