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
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
|
extends ItemList
class_name Database
const DATABASE_FILE_PATH: String = "user://database.csv"
const DATE_SEPARATOR: String = "-"
const DATE_FORMAT: String = "%04d-%02d-%02d"
const ENTRY_PROTOTYPE: Dictionary = {
"process_id": "",
"surgery_id": "",
"place": "",
"date": "",
"date_year": 0,
"date_month": 0,
"date_day": 0,
"anesthetic": "",
"first_assistant": "",
"type": "",
"sub_type": "",
"sub_sub_type": "",
"pathology": "",
"intervention": "",
"is_urgency": false,
"notes": "",
}
var db: Array
var staged_idx: int
onready var delete_button: Button = get_node("actions/delete")
onready var edit_button: Button = get_node("actions/edit")
onready var add_button: Button = get_node("actions/add")
onready var stage: Stage = get_node("/root/main/stage")
func _init():
staged_idx = -1
load_database()
store_database() # @DAM Only for testing.
# @DAM WIP
#func _notification(what: int):
# if what == MainLoop.NOTIFICATION_WM_GO_BACK_REQUEST:
# clear_selection()
func _ready():
self.connect("nothing_selected", self, "clear_selection")
delete_button.connect("pressed", self, "delete_action")
edit_button.connect("pressed", self, "edit_action")
add_button.connect("pressed", self, "add_action")
stage.connect("save", self, "save")
stage.connect("discard", self, "discard")
for it in db:
self.add_item(get_entry_view(it))
func get_entry_view(database_entry: Dictionary) -> String:
return "%6s | %6s | %s" % [database_entry.process_id, database_entry.surgery_id, get_entry_date(database_entry)]
func clear_selection():
unselect_all()
func delete_action():
var selected_entries_idx := self.get_selected_items()
if selected_entries_idx.size() == 0:
return
assert(selected_entries_idx.size() == 1, "Multiple selected items not supported.")
var selected_idx = selected_entries_idx[0]
db.remove(selected_idx)
self.remove_item(selected_idx)
store_database()
func edit_action():
var selected_entries_idx := self.get_selected_items()
if selected_entries_idx.size() == 0:
return
assert(selected_entries_idx.size() == 1, "Multiple selected items not supported.")
staged_idx = selected_entries_idx[0]
self.visible = false
stage.visible = true
stage.set_stage(db[staged_idx])
func add_action():
self.visible = false
stage.visible = true
var staged := instance_entry()
stage.set_stage(staged)
func save(database_entry: Dictionary):
database_entry = instance_entry(database_entry) # @DAM Maybe we could not be creating endless dictionaries?
if staged_idx >= 0:
db[staged_idx] = database_entry
set_item_text(staged_idx, get_entry_view(database_entry))
else:
db.append(database_entry)
add_item(get_entry_view(database_entry))
store_database()
staged_idx = -1
self.visible = true
func discard():
staged_idx = -1
self.visible = true
func load_database(file_path: String = DATABASE_FILE_PATH):
var file := File.new()
file.open(file_path, File.READ_WRITE)
var headers: PoolStringArray
var is_first_line := true
# while database_file.eof_reached() == false:
while file.get_position() < file.get_len():
var csv_entry := file.get_csv_line()
if is_first_line:
is_first_line = false
headers = csv_entry
continue
var entry = ENTRY_PROTOTYPE.duplicate(true)
for idx in headers.size():
var field_name := headers[idx]
var field_value := csv_entry[idx]
match field_name:
"date_year", "date_month", "date_day":
entry[field_name] = int(field_value)
"is_urgency":
entry[field_name] = true if field_value.strip_edges().to_lower() == "true" else false
_:
entry[field_name] = field_value
db.append(entry)
return
db = [
instance_entry({
"process_id": "000001",
"surgery_id": "100000",
"place": "central",
"date": "2020-01-31",
}),
instance_entry({
"process_id": "000002",
"surgery_id": "200000",
"place": "central",
"date": "2020-02-31",
}),
instance_entry({
"process_id": "000003",
"surgery_id": "300000",
"place": "central",
"date": "2020-03-31",
}),
instance_entry({
"process_id": "000004",
"surgery_id": "400000",
"place": "central",
"date": "2020-04-31",
}),
instance_entry({
"process_id": "000012",
"surgery_id": "210000",
"place": "central",
"date": "2020-12-31",
}),
]
func store_database(file_path: String = DATABASE_FILE_PATH):
var file := File.new()
file.open(file_path, File.WRITE)
var header := PoolStringArray(ENTRY_PROTOTYPE.keys())
file.store_csv_line(header)
var entry := PoolStringArray()
for it in db:
file.store_csv_line(it.values())
file.close()
static func instance_entry(params: Dictionary = {}) -> Dictionary:
var new_entry := ENTRY_PROTOTYPE.duplicate(true)
new_entry.process_id = params.get("process_id", "")
new_entry.surgery_id = params.get("surgery_id", "")
new_entry.place = params.get("place", "")
var today = OS.get_date()
new_entry.date_year = params.get("date_year", today.year)
new_entry.date_month = params.get("date_month", today.month)
new_entry.date_day = params.get("date_day", today.day)
new_entry.date = params.get("date", get_entry_date(new_entry))
new_entry.anesthetic = params.get("anesthetic", "")
new_entry.first_assistant = params.get("first_assistant", "")
new_entry.type = params.get("type", "")
new_entry.sub_type = params.get("sub_type", "")
new_entry.sub_sub_type = params.get("sub_sub_type", "")
new_entry.pathology = params.get("pathology", "")
new_entry.intervention = params.get("intervention", "")
new_entry.is_urgency = params.get("is_urgency", false)
new_entry.notes = params.get("notes", "")
return new_entry
static func get_entry_date(entry: Dictionary) -> String:
return DATE_FORMAT % [entry.date_year, entry.date_month, entry.date_day]
static func set_entry_date(entry: Dictionary, date: String):
date = date.strip_edges().replace(" ", DATE_SEPARATOR).replace("/", DATE_SEPARATOR).replace("\\", DATE_SEPARATOR)
var year_month_idx := date.find(DATE_SEPARATOR)
var month_day_idx := date.find(DATE_SEPARATOR, year_month_idx + 1)
entry.date = date
entry.date_year = int(date.substr(0, year_month_idx))
entry.date_month = int(date.substr(year_month_idx + 1, month_day_idx - year_month_idx - 1))
entry.date_day = int(date.substr(month_day_idx + 1))
|
