path: root/logic/database.gd

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 selected_idx: int
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():
	selected_idx = -1
	staged_idx = -1
	load_database()
	store_database() # @DAM Only for testing.


func _ready():
	self.connect("item_selected", self, "item_selected")
	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 _notification(what: int):
	if what == MainLoop.NOTIFICATION_WM_GO_BACK_REQUEST:
		if selected_idx >= 0:
			clear_selection()
		else:
			get_tree().quit()


# @DAM Testing
#var last_event
#var bypass: bool = false
#func _gui_input(event: InputEvent):
#	if bypass == false:
#		if event is InputEventScreenTouch && event.is_pressed():
#			accept_event()
#			last_event = event
#		elif event is InputEventScreenTouch && event.is_pressed() == false:
#			bypass = true
#			get_tree().input_event(event)
#			bypass = false
#	else:
#		var x = 3


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 item_selected(index: int):
	if selected_idx >= 0:
		set_item_text(selected_idx, get_entry_view(db[selected_idx]))
	selected_idx = index
	set_item_text(selected_idx, "> " + get_entry_view(db[selected_idx]) + " <")
	


func clear_selection():
	if selected_idx >= 0:
		set_item_text(selected_idx, get_entry_view(db[selected_idx]))
	selected_idx = -1
	unselect_all()


func delete_action():
	if selected_idx < 0:
		return
	
	db.remove(selected_idx)
	self.remove_item(selected_idx)
	store_database()


func edit_action():
	if selected_idx < 0:
		return
	
	staged_idx = selected_idx
	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: 								# @DAM Why this?
	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)
	
	fake_database()
	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))  # @DAM We should store only one version of the date.
	
	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))


func fake_database():
	db.resize(0)
	for idx in range(50):
		var date_year = 1 + int(float(idx) / 365.0)
		var date_month = idx % 12
		var date_day = idx % 365
		db.append(instance_entry({
			"process_id": "%06d" % idx,
			"surgery_id": "s%05d" % idx,
			"date": "%04d-%02d-%02d" % [date_year, date_month, date_day]
		}))







# @DAM Testing.
export(float) var drag_threshold = 5

onready var touch_enabled = OS.has_touchscreen_ui_hint()
onready var v_scroll = get_v_scroll()

var dragging = false
var pressed = false
var last_event
# must be _input, as _gui_input has bugs, with no touch.pressed = false events
# see: https://github.com/godotengine/godot/issues/16761
func _gui_input(event):
	
	if event is InputEventScreenDrag:
		self.v_scroll.value -= event.relative.y
	
	return
	if not visible:
		return

	if not touch_enabled:
		return

	if event is InputEventScreenDrag:
		accept_event()
		if event.speed == Vector2():
			# we're on a device and speed is broken
			# see: https://github.com/godotengine/godot/issues/3623
			event.speed = event.relative
		if abs(event.speed.y) >= drag_threshold:
			# scroll the list
			dragging = true
			v_scroll.value -= event.relative.y
		return

	if event is InputEventScreenTouch:
		if event.index == 0:
			accept_event()
			if dragging && event.pressed == false:
				# prints("end drag")
				dragging = false
				pressed = false
			else:
				if event.pressed && pressed == false:
					# prints("touch start")
					pressed = true
					accept_event()
					# TODO: prevent select highlight
				elif !event.pressed && pressed == true:
					# prints("touch end and accept")
					pressed = false
					var ev = InputEventAction.new()
					ev.action = "ui_accept"
					ev.pressed = true
					Input.parse_input_event(ev)