Added Houseno inte ApplicantPersonalData

Gui/ApplicantPersonalData.qml

@@ -5,7 +5,7 @@ import QtQuick.Layouts
 GridLayout
 {
     id: personalData
-    columns: 2
+    columns: 4
 
     Label
     {
@@ -20,6 +20,7 @@ GridLayout
         model: [qsTr("Herr"), qsTr("Frau")]
         onCurrentTextChanged: briefAnrede.text = title.currentText === "Herr"? "Sehr geehrter " +
                                                                                title.currentText: "Sehr geehrte " + title.currentText
+        Layout.columnSpan: 3
     }
     Label
     {
@@ -33,7 +34,7 @@ GridLayout
         placeholderText: "Pflichtfeld"
         placeholderTextColor: "red"
         onTextChanged: checkFields()
-
+        Layout.columnSpan: 3
     }
     Label
     {
@@ -47,7 +48,7 @@ GridLayout
         placeholderText: "Pflichtfeld"
         placeholderTextColor: "red"
         onTextChanged: checkFields()
-
+        Layout.columnSpan: 3
     }
     Label
     {
@@ -60,56 +61,69 @@ GridLayout
         Layout.fillWidth: true
         placeholderTextColor: "red"
 
+    }
+    Label
+    {
+        text: qsTr("Nr.")
+        Layout.alignment: Qt.AlignRight
+    }
+    TextField
+    {
+        property string name: "houseno"
+        id: houseno
+        Layout.fillWidth: true
+        placeholderTextColor: "red"
+
     }
     Label
     {
         text: qsTr("PLZ")
         Layout.alignment: Qt.AlignRight
     }
-    RowLayout
+
+    ComboBox
     {
-        ComboBox
+        id: postcode
+        Layout.fillWidth: true
+        editable: true
+        onCurrentTextChanged: checkFields()
+        onEditTextChanged: checkFields()
+        onActivated: currentValue
+        model: address_model
+        textRole: "display"
+        popup.height: 300
+        popup.y: postcode.y + 5 - (postcode.height * 2)
+        currentIndex: -1
+        onCurrentIndexChanged: city.currentIndex = postcode.currentIndex
+        validator: RegularExpressionValidator
         {
-            id: postcode
+            regularExpression: /([0-9]{1,5})/
-            Layout.fillWidth: true
-            editable: true
-            onCurrentTextChanged: checkFields()
-            onEditTextChanged: checkFields()
-            onActivated: currentValue
-            model: address_model
-            textRole: "display"
-            popup.height: 300
-            popup.y: postcode.y + 5 - (postcode.height * 2)
-            currentIndex: -1
-            onCurrentIndexChanged: city.currentIndex = postcode.currentIndex
-            validator: RegularExpressionValidator
-            {
-                regularExpression: /([0-9]{1,5})/
-            }
         }
 
-
-        Label
-        {
-            text: qsTr("Ort")
-            Layout.alignment: Qt.AlignRight
-
-        }
-        ComboBox
-        {
-            id: city
-            Layout.fillWidth: true
-            editable: true
-            onEditTextChanged: checkFields()
-            onCurrentTextChanged: checkFields()
-            model: address_model
-            textRole: "city"
-            popup.height: 300
-            popup.y: postcode.y + 5 - (postcode.height * 2)
-            currentIndex: -1
-
-        }
     }
+
+
+    Label
+    {
+        text: qsTr("Ort")
+        Layout.alignment: Qt.AlignRight
+
+    }
+    ComboBox
+    {
+        id: city
+        Layout.fillWidth: true
+        editable: true
+        onEditTextChanged: checkFields()
+        onCurrentTextChanged: checkFields()
+        model: address_model
+        textRole: "city"
+        popup.height: 300
+        popup.y: postcode.y + 5 - (postcode.height * 2)
+        currentIndex: -1
+
+    }
+
     Label
     {
         text: qsTr("Telefonnummer")
@@ -120,6 +134,7 @@ GridLayout
         id: phonenumber
         Layout.fillWidth: true
         placeholderTextColor: "red"
+        Layout.columnSpan: 3
     }
     Label
     {
@@ -131,6 +146,7 @@ GridLayout
         id: cellphone
         Layout.fillWidth: true
         placeholderTextColor: "red"
+        Layout.columnSpan: 3
     }
     Label
     {
@@ -142,6 +158,7 @@ GridLayout
         id: email
         Layout.fillWidth: true
         placeholderTextColor: "red"
+        Layout.columnSpan: 3
     }
     Label
     {
@@ -156,6 +173,7 @@ GridLayout
         editable: false
         model: [qsTr("ledig"), qsTr("verheiratet"), qsTr("verwitwet"), qsTr("geschieden")]
         visible: radio.children[1].checked
+        Layout.columnSpan: 3
     }
     Label
     {
@@ -169,6 +187,7 @@ GridLayout
         Layout.fillWidth: true
         visible: radio.children[1].checked
         placeholderTextColor: "red"
+        Layout.columnSpan: 3
     }
     Label
     {
@@ -182,6 +201,7 @@ GridLayout
         Layout.fillWidth: true
         visible: radio.children[1].checked
         placeholderTextColor: "red"
+        Layout.columnSpan: 3
     }
     Label
     {
@@ -195,6 +215,7 @@ GridLayout
         Layout.fillWidth: true
         visible: radio.children[1].checked
         placeholderTextColor: "red"
+        Layout.columnSpan: 3
     }
     Label
     {
@@ -208,6 +229,7 @@ GridLayout
         Layout.fillWidth: true
         visible: radio.children[1].checked
         placeholderTextColor: "red"
+        Layout.columnSpan: 3
     }
     Label
     {
@@ -219,12 +241,13 @@ GridLayout
         id: briefAnrede
         Layout.fillWidth: true
         placeholderTextColor: "red"
+        Layout.columnSpan: 3
     }
 
     Item
     {
         Layout.fillHeight: true
-        Layout.columnSpan: 2
+        Layout.columnSpan: 4
     }
     function checkPersonalField()
     {

lib/DB/AddressDAO.py

@@ -14,9 +14,11 @@ class AddressDAO:
 
 
 
+
     def __importPlz(self):
-        with open("import json filepath here", "r") as plz:
+        with open("pfad zur datei", "r") as plz:
             postcodes = json.load(plz)
+            irgendwas = ""
             try:
                 for i in postcodes:
                     test =i["plz_name"].split(",")
@@ -26,7 +28,8 @@ class AddressDAO:
                         town = town.strip()
                         if town:
                             print(f"PROCESSING {i['name']} {town}")
-                            self.__cur.callproc("addZipCodes", (i["name"], town,))
+                            self.__cur.callproc("addZipCodes", (i["name"], town, irgendwas,))
+                #self.__cur.callproc("addZipCodes", ("56271", "Kleinmaischeid", irgendwas,))
             except mariadb.OperationalError as e:
                 print(f"Database Error: {e}")
             finally:
@@ -34,7 +37,7 @@ class AddressDAO:
                 print("FINISHED")#
 
     def __importCountry(self):
-        with open("/home/dstoppek/Downloads/staaten.json", "r") as country:
+        with open("pfad zur datei", "r") as country:
             countries = json.load(country)
             old = ""
             try: