ubuntuusers.de

import QtQuick 2.7
import Lomiri.Components 1.3
import QtQuick.Layouts 1.3
import Qt.labs.folderlistmodel 2.1
import QtQuick.LocalStorage 2.0
import Qt.labs.platform 1.1
import Qt.labs.settings 1.0


Page {
    id: settingsPage

    property string currentDb: ""

    // --- Ersatz für UbuntuColors ---
    QtObject {
        id: ubuntucolors
        property color orange: "#E95420"
        property color lightGreen: "#68B723"
        property color suruGrey: "#AEA79F"
        property color darkGrey: "#333333"
    }
Settings {
        id: appSettings
         property string mycallsign: "n0call"
         property string myqth: "Kronos"
          property string currentDb: ""
          property string dbPfad:  "File://.local/share/portablelog.dl8aax/Databases/"
          
        } 
    Flickable {
        anchors.fill: parent
        contentHeight: columnContent.height + units.gu(4)
        clip: true

        Column {
            id: columnContent
            width: parent.width
            spacing: units.gu(2)
            anchors.margins: units.gu(2)

            Label {
                text: i18n.tr("Einstellungen")
                color: ubuntucolors.orange
                font.bold: true
                wrapMode: Text.WordWrap
            }

            TextField {
                id: callField
                placeholderText: "My Call"
                width: units.gu(13)
                text:  appSettings.mycallsign
                onTextChanged: appSettings.mycallsign = text
            }

            TextField {
                id: nameField
                placeholderText: "My Name"
                width: units.gu(13)
            }

            Rectangle {
                width: parent.width
                height: 3
                color: ubuntucolors.lightGreen
                opacity: 0.6
            }

          ComboButton {
    id: dbCombo
    text: currentDb === "" ? i18n.tr("Datenbank wählen") : currentDb
    expandedHeight: units.gu(25)

    model: ListModel { id: dbModel }

    delegate: ListItem {
        width: parent.width
        Label {
            text: name
            anchors.verticalCenter: parent.verticalCenter
        }

        onClicked: {
            if (name === i18n.tr("Neue Datenbank anlegen...")) {
                newDbOverlay.visible = true
            } else {
                appSettings.currentDb = name
                dbCombo.text = name
                currentDb = name
                dbCombo.expanded = false
                openDatabase(name)
            }
        }
    }

    Component.onCompleted: {
        console.log("📁 Lade Datenbanken aus:", dbFolder.folder, " ->", dbFolder.count, "Dateien")
        if (dbFolder.count > 0)
            loadDatabases()
    }
}
        }
    }

    Rectangle {
        id: newDbOverlay
        anchors.fill: parent
        color: "#000000AA"
        visible: false
        z: 100

        Rectangle {
            width: parent.width * 0.8
            height: units.gu(20)
            anchors.centerIn: parent
            radius: units.gu(1)
            color: ubuntucolors.suruGrey
            border.color: ubuntucolors.orange
            border.width: 2

            Column {
                anchors.fill: parent
                anchors.margins: units.gu(2)
                spacing: units.gu(2)
                Label {
                    text: i18n.tr("Neue Datenbank anlegen")
                    color: ubuntucolors.orange
                    font.bold: true
                }
                TextField {
                    id: newDbName
                    placeholderText: i18n.tr("z.B. mylog.sqlite")
                }
                Row {
                    spacing: units.gu(2)
                    Button {
                        text: i18n.tr("Erstellen")
                        color: ubuntucolors.orange
                        onClicked: {
                            if (newDbName.text.length > 0) {
                               
                                settingsPage.createDatabase(newDbName.text)
                                loadDatabases()
                                dbCombo.text = newDbName.text
                                dbCombo.selectedDatabase = newDbName.text
                            }
                            newDbOverlay.visible = false
                        }
                    }

                    Button {
                        text: i18n.tr("Abbrechen")
                        onClicked: newDbOverlay.visible = false
                    }
                }
            }
        }
    }

    // --- Datenbankfunktionen ---
    function loadDatabases() {
        dbModel.clear()
        dbModel.append({ "name": i18n.tr("Neue Datenbank anlegen...") })

        console.log("📁 Lade Datenbanken aus:", dbFolder.folder, " ->", dbFolder.count, "Dateien")

        for (var i = 0; i < dbFolder.count; i++) {
            var fn = dbFolder.get(i, "fileName")
            var displayName = fn.replace(".sqlite", "")
            dbModel.append({ "name": displayName })
        }

        if (currentDb !== "") {
            dbCombo.text = currentDb.replace(".sqlite", "")
            dbCombo.selectedDatabase = currentDb
        }
    }

    function openDatabase(fileName) {
        currentDb = fileName
        var db = LocalStorage.openDatabaseSync(fileName, "1.0", "PortableLog", 1000000)
        db.transaction(function(tx) {
            tx.executeSql(
                'CREATE TABLE IF NOT EXISTS log (' +
                'id INTEGER PRIMARY KEY AUTOINCREMENT, ' +
                'call TEXT, name TEXT, time TEXT, qrg TEXT, ' +
                'rst_sent TEXT, rst_rcvd TEXT, mode TEXT, ' +
                'reference TEXT, qth TEXT, qsl INTEGER)'
            )
        })
        console.log("✅ DB geöffnet / initialisiert:", fileName)
    }

    function createDatabase(name) {
        openDatabase(name)
    }

   FolderListModel {
    id: dbFolder
    folder: "file://" + StandardPaths.writableLocation(StandardPaths.AppDataLocation) + "/Databases"
    nameFilters: ["*.sqlite"]
    showDirs: false

    onCountChanged: {
        if (count > 0)
            settingsPage.loadDatabases()
    }

    Component.onCompleted: {
        console.log("🔍 Datenbankpfad:", folder)
        if (count > 0)
            settingsPage.loadDatabases()
    }
}
}