-
Notifications
You must be signed in to change notification settings - Fork 0
/
searchBars.py
57 lines (44 loc) · 1.99 KB
/
searchBars.py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
from veriCekmeFonksiyonlar import *
# Hasta arama barı
def patients_searchBar(searchentry,self):
search_text = searchentry.get_text()
self.cursor.execute("SELECT * FROM patients")
list_Patients = self.cursor.fetchall()
tc_Number = list()
for i in range(len(list_Patients)):
tc_Number.append(list_Patients[i][1])
self.listmodel.clear()
hasta_vericekme_query(self)
for j in range(len(tc_Number)):
if search_text in str(tc_Number[j]):
self.listmodel.append(self.hasta_listesi[j])
# İlaç arama barı
def medicines_searchBar(searchentry,self):
search_text = searchentry.get_text()
self.cursor.execute("SELECT NAME FROM medicines")
list_MedicineNames = self.cursor.fetchall()
self.ilac_listmodel.clear()
ilac_vericekme_query(self)
for j in range(len(list_MedicineNames)):
if search_text in str(list_MedicineNames[j]).lower():
self.ilac_listmodel.append(self.ilac_listesi[j])
# Fabrika ilaç arama barı
def medicines_searchBar2(searchentry,self):
search_text = searchentry.get_text()
self.cursor.execute("SELECT NAME FROM medicines")
list_MedicineNames = self.cursor.fetchall()
self.facilac_listmodel.clear()
facilac_vericekme_query(self,None)
for j in range(len(list_MedicineNames)):
if search_text in str(list_MedicineNames[j]).lower():
self.facilac_listmodel.append(self.facilac_listesi[j])
# Fabrika arama barı
def factory_SearchBar(searchentry,self):
search_text = searchentry.get_text()
self.cursor.execute("SELECT NAME FROM factories")
list_factoryNames = self.cursor.fetchall()
self.factories_listmodel.clear()
fabrika_vericekme_query(self)
for j in range(len(list_factoryNames)):
if search_text in str(list_factoryNames[j]):
self.factories_listmodel.append(self.fabrika_listesi[j])