new Diagrams

Merge branch 'main' into schnacke
Need to
2025-05-09 10:59:11 +02:00 · 2025-05-08 11:47:47 +02:00 · 2025-04-28 13:46:21 +02:00 · 2025-03-25 13:41:40 +01:00 · 2025-03-25 13:41:01 +01:00
63 changed files with 1194 additions and 736 deletions
--- a/.idea/dataSources.xml
+++ b/.idea/dataSources.xml
@@ -1,12 +0,0 @@
-<?xml version="1.0" encoding="UTF-8"?>
-<project version="4">
-  <component name="DataSourceManagerImpl" format="xml" multifile-model="true">
-    <data-source source="LOCAL" name="pyqcrm@bearybot.selfhost.co" uuid="ed28331b-481b-40e7-9295-d9cdae9fd4f2">
-      <driver-ref>mariadb</driver-ref>
-      <synchronize>true</synchronize>
-      <jdbc-driver>org.mariadb.jdbc.Driver</jdbc-driver>
-      <jdbc-url>jdbc:mariadb://bearybot.selfhost.co:8080/pyqcrm</jdbc-url>
-      <working-dir>$ProjectFileDir$</working-dir>
-    </data-source>
-  </component>
-</project>
--- a/.idea/inspectionProfiles/Project_Default.xml
+++ b/.idea/inspectionProfiles/Project_Default.xml
@@ -0,0 +1,6 @@
+<component name="InspectionProjectProfileManager">
+  <profile version="1.0">
+    <option name="myName" value="Project Default" />
+    <inspection_tool class="Eslint" enabled="true" level="WARNING" enabled_by_default="true" />
+  </profile>
+</component>
--- a/.idea/inspectionProfiles/profiles_settings.xml
+++ b/.idea/inspectionProfiles/profiles_settings.xml
@@ -0,0 +1,6 @@
+<component name="InspectionProjectProfileManager">
+  <settings>
+    <option name="USE_PROJECT_PROFILE" value="false" />
+    <version value="1.0" />
+  </settings>
+</component>
--- a/.idea/sqldialects.xml
+++ b/.idea/sqldialects.xml
@@ -1,6 +0,0 @@
-<?xml version="1.0" encoding="UTF-8"?>
-<project version="4">
-  <component name="SqlDialectMappings">
-    <file url="file://$PROJECT_DIR$/doc/db_schemer_v1.1-pyqcrm-202503171158_clean.sql" dialect="MariaDB" />
-  </component>
-</project>
--- a/Gui/AddNewOffer.qml
+++ b/Gui/AddNewOffer.qml
@@ -184,6 +184,23 @@ GridLayout
        Layout.fillWidth: true
        Layout.alignment: Qt.AlignVCenter
    }
+    Item
+    {
+        Layout.columnSpan: 2
+    }
+    //New Grid
+    Label
+    {
+        text: qsTr("Leistungen:")
+        Layout.alignment: Qt.AlignRight
+        font: Typography.h2
+
+
+    }
+    Item
+    {
+        Layout.columnSpan: 3
+    }



--- a/Gui/AdminUserConfig.qml
+++ b/Gui/AdminUserConfig.qml
@@ -51,6 +51,15 @@ GridLayout
        placeholderText: qsTr("Hier Passwort eingeben")
        Layout.fillWidth: true
        property string name: "PYQCRM_USER_PASS"
+        color: acceptableInput ? "black" : "red"
+        ToolTip.visible: hovered && !acceptableInput
+        ToolTip.text: "Passwort muss mind. 12 Zeichen lang sein und Groß-, Kleinbuchstaben, Zahlen sowie Sonderzeichen (!@#$%^&*()_+-=) enthalten."
+
+        validator: RegularExpressionValidator {
+                    regularExpression: /^(?=.*[a-z])(?=.*[A-Z])(?=.*\d)(?=.*[!@#$%^&*()_+\-=]).{12,}$/
+                }
+
+
    }
    Label
    {
--- a/Gui/Employees/AddApplicant.qml
+++ b/Gui/Employees/AddApplicant.qml
@@ -6,6 +6,13 @@ ColumnLayout {
    anchors.fill: parent
    spacing: Dimensions.l

+    Component.onCompleted: {
+        employee_model.addedNewEmployee.connect(successful => {
+            if (successful)
+                contentStack.pop();
+        });
+    }
+
    ApplicantForm {
        id: applicantForm

@@ -29,8 +36,7 @@ ColumnLayout {
            text: qsTr("Speichern")

            onClicked: {
-                applicantModel.createApplicant(applicantForm.value);
-                contentStack.pop();
+                employee_model.addApplicant(applicantForm.value);
            }
        }
    }
--- a/Gui/Employees/AddEmployee.qml
+++ b/Gui/Employees/AddEmployee.qml
@@ -46,7 +46,7 @@ ColumnLayout {
            Layout.fillWidth: true
            Layout.horizontalStretchFactor: 1

-            EmployeePersonalData {
+            ApplicantPersonalData {
                id: personalData

                implicitWidth: parent.width
@@ -61,14 +61,14 @@ ColumnLayout {
                Layout.alignment: Qt.AlignTop
                implicitWidth: parent.width

-                EmployeeBankData {
+                ApplicantBankData {
                    id: bankAccount

                }
-                EmployeeNationalInsurance {
+                ApplicantNationalInsurance {
                    id: nationalInsurance
                }
-                EmployeeVarious {
+                ApplicantVarious {
                    id: applicantVarious

                }
--- a/Gui/Employees/ApplicantBankData.qml
+++ b/Gui/Employees/ApplicantBankData.qml
--- a/Gui/Employees/ApplicantForm.qml
+++ b/Gui/Employees/ApplicantForm.qml
@@ -6,31 +6,19 @@ import TeroStyle
 ColumnLayout {
    readonly property int fieldM: 235
    readonly property int fieldS: 110
-    readonly property bool valid: emailAddress.acceptableInput && firstName.acceptableInput && houseNumber.acceptableInput && lastName.acceptableInput && mobileNumber.acceptableInput && phoneNumber.acceptableInput && salutation.acceptableInput&& street.acceptableInput && title.acceptableInput && zipCode.acceptableInput
+    readonly property bool valid: city.acceptableInput && email.acceptableInput && firstname.acceptableInput && lastname.acceptableInput && mobile.acceptableInput && phone.acceptableInput && postcode.acceptableInput && formofaddress.acceptableInput && title.acceptableInput
    readonly property var value: QtObject {
-        readonly property string emailAddress: emailAddress.text ?? ""
-        readonly property string firstName: firstName.text ?? ""
-        readonly property string houseNumber: houseNumber.text ?? ""
-        readonly property string lastName: lastName.text ?? ""
-        readonly property string mobileNumber: mobileNumber.text ?? ""
-        readonly property string phoneNumber: phoneNumber.text ?? ""
-        readonly property string salutation: salutation.text ?? ""
-        readonly property string street: street.text ?? ""
+        readonly property string city: (city.editText ? city.editText : city.currentText) ?? ""
+        readonly property string email: email.text
+        readonly property string firstname: firstname.text
+        readonly property string formofaddress: formofaddress.currentText ?? ""
+        readonly property string houseno: houseno.text ?? ""
+        readonly property string lastname: lastname.text
+        readonly property string mobile: mobile.text
+        readonly property string phone: phone.text
+        readonly property string postcode: (postcode.editText ? postcode.editText : postcode.currentText) ?? ""
+        readonly property string street: (street.editText ? street.editText : street.currentText) ?? ""
        readonly property string title: title.currentText
-        readonly property int zipCode: zipCode.currentIndex
-    }
-
-    function setValue(value) {
-        title.currentIndex = value.title ?? 0;
-        firstName.text = value.firstName ?? "";
-        lastName.text = value.lastName ?? "";
-        street.text = value.street ?? "";
-        houseNumber.text = value.houseNumber ?? "";
-        zipCode.currentIndex = value.zipCode ?? -1;
-        phoneNumber.text = value.phoneNumber ?? "";
-        mobileNumber.text = value.mobileNumber ?? "";
-        emailAddress.text = value.emailAddress ?? "";
-        salutation.text = value.salutation ?? 0;
    }

    spacing: Dimensions.l
@@ -60,13 +48,13 @@ ColumnLayout {
                onCurrentTextChanged: {
                    switch (title.currentIndex) {
                    case 1:
-                        salutation.text = "Sehr geehrter Herr ";
+                        formofaddress.text = "Sehr geehrter Herr ";
                        break;
                    case 2:
-                        salutation.text = "Sehr geehrte Frau ";
+                        formofaddress.text = "Sehr geehrte Frau ";
                        break;
                    default:
-                        salutation.text = "Guten Tag ";
+                        formofaddress.text = "Guten Tag ";
                    }
                }
            }
@@ -76,7 +64,7 @@ ColumnLayout {
            mandatory: true

            TextField {
-                id: firstName
+                id: firstname

                implicitWidth: fieldM
                placeholderText: qsTr("Max")
@@ -90,7 +78,7 @@ ColumnLayout {
            mandatory: true

            TextField {
-                id: lastName
+                id: lastname

                implicitWidth: fieldM
                placeholderText: qsTr("Mustermann")
@@ -104,30 +92,39 @@ ColumnLayout {
        spacing: Dimensions.m

        Field {
-            label: qsTr("Straße")
-
-            TextField {
            id: street

+            label: qsTr("Straße")
+            mandatory: true
+
+            TextField {
                implicitWidth: fieldM
                placeholderText: qsTr("Musterstraße")
+
+                validator: NotEmptyValidator {
+                }
            }
        }
        Field {
+            id: houseno
+            mandatory: true
+
            label: qsTr("Hausnummer")

            TextField {
-                id: houseNumber
-
                implicitWidth: fieldS
                placeholderText: qsTr("1a")
+
+                validator: NotEmptyValidator {
+                }
            }
        }
        Field {
            label: qsTr("PLZ")
+            mandatory: true

            ComboBox {
-                id: zipCode
+                id: postcode

                currentIndex: -1
                editable: true
@@ -136,11 +133,14 @@ ColumnLayout {
                textRole: "display"

                onActivated: currentValue
-                onCurrentIndexChanged: city.currentIndex = zipCode.currentIndex
+                onCurrentIndexChanged: city.currentIndex = postcode.currentIndex
+
+                validator: NotEmptyValidator {}
            }
        }
        Field {
            label: qsTr("Ort")
+            mandatory: true

            ComboBox {
                id: city
@@ -150,6 +150,9 @@ ColumnLayout {
                implicitWidth: fieldM
                model: address_model
                textRole: "city"
+
+                validator: NotEmptyValidator {
+                }
            }
        }
    }
@@ -170,7 +173,7 @@ ColumnLayout {
            label: qsTr("Telefonnummer")

            TextField {
-                id: phoneNumber
+                id: phone

                implicitWidth: fieldM
                placeholderText: "+49 1234 567890"
@@ -183,7 +186,7 @@ ColumnLayout {
            label: qsTr("Mobil")

            TextField {
-                id: mobileNumber
+                id: mobile

                implicitWidth: fieldM
                placeholderText: "+49 123 4567891011"
@@ -196,7 +199,7 @@ ColumnLayout {
            label: qsTr("E-Mail Adresse")

            TextField {
-                id: emailAddress
+                id: email

                implicitWidth: fieldM
                placeholderText: "tero@example.org"
@@ -209,7 +212,7 @@ ColumnLayout {
            label: qsTr("Briefanrede")

            TextField {
-                id: salutation
+                id: formofaddress

                implicitWidth: fieldM
            }
--- a/Gui/Employees/ApplicantNationalInsurance.qml
+++ b/Gui/Employees/ApplicantNationalInsurance.qml
--- a/Gui/Employees/ApplicantPersonalData.qml
+++ b/Gui/Employees/ApplicantPersonalData.qml
--- a/Gui/Employees/ApplicantVarious.qml
+++ b/Gui/Employees/ApplicantVarious.qml
--- a/Gui/Employees/EmployeeDetails.qml
+++ b/Gui/Employees/EmployeeDetails.qml
@@ -1,34 +1,27 @@
 import QtQuick
 import QtQuick.Controls
 import QtQuick.Layouts
-import TeroStyle

-ColumnLayout {
-    property int row: -1
+Item
+{
+    property int selectedEmployee: -1
+    id: emDet
+    ColumnLayout
+    {
+        Label
+        {
+            text: qsTr("Ausgewählter Mitarbeiter " + selectedEmployee)
+        }

-    anchors.fill: parent
-    spacing: Dimensions.l
-
-    onRowChanged: {
-        if (row !== -1) {
-            applicantForm.setValue(applicantModel.applicant(row))
+        Button
+        {
+            text: qsTr("Mitarbeiter zeigen")
+            onClicked: contentStack.pop()
        }
    }

-    ApplicantForm {
-        id: applicantForm
-
-        Layout.alignment: Qt.AlignTop
-        Layout.fillHeight: true
-        Layout.verticalStretchFactor: 1
-    }
-
-    RowLayout {
-        spacing: Dimensions.l
-
-        Button {
-            text: qsTr("Als Mitarbeiter:in Einstellen")
-            icon.source: "qrc:/images/InboxArrowDown.svg"
-        }
+    Component.onCompleted:
+    {
+        employee_model.onRowClicked(selectedEmployee)
    }
 }
--- a/Gui/Employees/EmployeesTable.qml
+++ b/Gui/Employees/EmployeesTable.qml
@@ -12,9 +12,6 @@ ColumnLayout {
        spacing: Dimensions.l

        SearchBar {
-            onSubmitted: (query) => {
-                applicantModel.searchQuery = query
-            }
        }
        QuickFilter {
            model: ListModel {
@@ -95,7 +92,7 @@ ColumnLayout {
            Layout.fillHeight: true
            Layout.fillWidth: true
            columnSpacing: 2
-            model: applicantModel
+            model: employee_model
            resizableColumns: true
            rowSpacing: 2
            selectionBehavior: TableView.SelectRows
@@ -127,7 +124,9 @@ ColumnLayout {
                    hoverEnabled: true

                    onClicked: {
-                        contentStack.push("EmployeeDetails.qml", { row });
+                        contentStack.push("EmployeeDetails.qml", {
+                            selectedEmployee: row
+                        });
                    }
                    onEntered: {
                        employeesTable.selectionModel.select(employeesTable.model.index(row, 0), ItemSelectionModel.SelectCurrent | ItemSelectionModel.Rows);
--- a/Gui/ObjectsTable.qml
+++ b/Gui/ObjectsTable.qml
@@ -45,23 +45,18 @@ ColumnLayout
                    selected: true
                }
                ListElement {
-                    name: "Interessent"
-                    text: qsTr("Interessent")
+                    name: "Aktiv"
+                    text: qsTr("Aktiv")
                    selected: false
                }
                ListElement {
-                    name: "Kunde"
-                    text: qsTr("Kunde")
+                    name: "Ehemalig"
+                    text: qsTr("Ehemalig")
                    selected: false
                }
                ListElement {
-                    name: "Lieferant"
-                    text: qsTr("Lieferant")
-                    selected: false
-                }
-                ListElement {
-                    name: "Erledigt"
-                    text: qsTr("Erledigt")
+                    name: "Angebote"
+                    text: qsTr("Angebote")
                    selected: false
                }
            }
--- a/Gui/OffersTable.qml
+++ b/Gui/OffersTable.qml
@@ -3,35 +3,38 @@ import QtQuick.Layouts
 import QtQuick.Controls
 import Qt.labs.qmlmodels

-ColumnLayout {
-    function viewOffers(criterion) {
+ColumnLayout
+{
+    anchors.fill: parent
+    spacing: Dimensions.l
+    function viewOffers(criterion)
+    {
        //offer_model.viewCriterion(criterion)
    }

-    anchors.fill: parent
-    spacing: Dimensions.l
-
-    RowLayout {
+    RowLayout
+    {
        Layout.fillWidth: true
        spacing: Dimensions.l
-
-        SearchBar {
+        SearchBar
+        {
            id: searchBar
-
        }
        QuickFilter {
            model: ListModel {
                ListElement {
                    name: "Alle"
-                    selected: true
                    text: qsTr("Alle")
+                    selected: true
                }
-                ListElement {
+                ListElement
+                {
                    name: "Offen"
-                    selected: false
                    text: qsTr("Offen")
+                    selected: false
                }
-                ListElement {
+                ListElement
+                {
                    name: "Abgeschlossen"
                    selected: false
                    text: qsTr("Abgeschlossen")
@@ -47,20 +50,18 @@ ColumnLayout {
                business_model.viewCriterion(name);
            }
        }
-        Button {
+        Button
+        {
            id: addOfferBtn
-
+            text: qsTr("Angebote Hinzufügen")
+            icon.source: "qrc:/images/PlusCircle.svg"
            Layout.alignment: Qt.AlignRight
            flat: true
-            icon.source: "qrc:/images/PlusCircle.svg"
-            text: qsTr("Angebote Hinzufügen")
-
-            onClicked: contentStack.push("AddOffer.qml")
+            onClicked: appLoader.source = "AddOffer.qml"
        }
    }
    Item {
        id: spacer
-
        Layout.fillHeight: true
    }
 }
--- a/Gui/OffersTable.qml.orig
+++ b/Gui/OffersTable.qml.orig
@@ -0,0 +1,87 @@
+import QtQuick
+import QtQuick.Layouts
+import QtQuick.Controls
+import Qt.labs.qmlmodels
+
+ColumnLayout {
+    function viewOffers(criterion) {
+    //offer_model.viewCriterion(criterion)
+    }
+
+    anchors.fill: parent
+    spacing: Dimensions.l
+
+    RowLayout {
+        Layout.fillWidth: true
+        spacing: Dimensions.l
+
+        SearchBar {
+            id: searchBar
+
+        }
+<<<<<<< HEAD
+        QuickFilter
+        {
+            onSelectedChanged: (name) =>
+                               {
+                business_model.viewCriterion(name)
+            }
+
+            model: ListModel
+            {
+                ListElement
+                {
+=======
+        QuickFilter {
+            model: ListModel {
+                ListElement {
+>>>>>>> main
+                    name: "Alle"
+                    selected: true
+                    text: qsTr("Alle")
+                }
+                ListElement {
+                    name: "Offen"
+                    selected: false
+                    text: qsTr("Offen")
+                }
+<<<<<<< HEAD
+                ListElement
+                {
+                    name: "Abgesagt"
+                    text: qsTr("Abgesagt")
+=======
+                ListElement {
+                    name: "Abgeschlossen"
+                    selected: false
+                    text: qsTr("Abgeschlossen")
+                }
+                ListElement {
+                    name: "Erledigt"
+>>>>>>> main
+                    selected: false
+                    text: qsTr("Erledigt")
+                }
+            }
+
+            onSelectedChanged: name => {
+                business_model.viewCriterion(name);
+            }
+        }
+        Button {
+            id: addOfferBtn
+
+            Layout.alignment: Qt.AlignRight
+            flat: true
+            icon.source: "qrc:/images/PlusCircle.svg"
+            text: qsTr("Angebote Hinzufügen")
+
+            onClicked: contentStack.push("AddOffer.qml")
+        }
+    }
+    Item {
+        id: spacer
+
+        Layout.fillHeight: true
+    }
+}
--- a/TeroStyle/SearchBar.qml
+++ b/TeroStyle/SearchBar.qml
@@ -4,23 +4,11 @@ import QtQuick.Layouts


 TextField {
-    id: field
-
-    signal submitted(query: string)
-
    Layout.preferredWidth: 300
    placeholderText: qsTr("Suche")

-    Keys.onReturnPressed: {
-        field.submitted(field.text);
-    }
-
    Button {
        icon.source: "qrc:/images/MagnifyingGlass.svg"
        isFieldButton: true
-
-        onClicked: {
-            field.submitted(field.text)
-        }
    }
 }
--- a/doc/Aktivitätsdiagramm_Offer.drawio
+++ b/doc/Aktivitätsdiagramm_Offer.drawio
@@ -0,0 +1,135 @@
+<mxfile host="app.diagrams.net" agent="Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36" version="27.0.1">
+  <diagram name="Seite-1" id="Gl2dKcRXzwIEfQ6TcyUq">
+    <mxGraphModel dx="1425" dy="763" grid="1" gridSize="10" guides="1" tooltips="1" connect="1" arrows="1" fold="1" page="1" pageScale="1" pageWidth="827" pageHeight="1169" math="0" shadow="0">
+      <root>
+        <mxCell id="0" />
+        <mxCell id="1" parent="0" />
+        <mxCell id="GylxGBc_4kwvuqjtwPvo-1" value="" style="ellipse;html=1;shape=startState;fillColor=#000000;strokeColor=#ff0000;" vertex="1" parent="1">
+          <mxGeometry x="50" y="80" width="30" height="30" as="geometry" />
+        </mxCell>
+        <mxCell id="GylxGBc_4kwvuqjtwPvo-2" value="" style="edgeStyle=orthogonalEdgeStyle;html=1;verticalAlign=bottom;endArrow=open;endSize=8;strokeColor=#ff0000;rounded=0;" edge="1" source="GylxGBc_4kwvuqjtwPvo-1" parent="1">
+          <mxGeometry relative="1" as="geometry">
+            <mxPoint x="170" y="95" as="targetPoint" />
+          </mxGeometry>
+        </mxCell>
+        <mxCell id="GylxGBc_4kwvuqjtwPvo-3" value="addOffer" style="rounded=1;whiteSpace=wrap;html=1;" vertex="1" parent="1">
+          <mxGeometry x="170" y="65" width="120" height="60" as="geometry" />
+        </mxCell>
+        <mxCell id="GylxGBc_4kwvuqjtwPvo-4" value="" style="endArrow=classic;html=1;rounded=0;exitX=1;exitY=0.5;exitDx=0;exitDy=0;" edge="1" parent="1" source="GylxGBc_4kwvuqjtwPvo-3" target="GylxGBc_4kwvuqjtwPvo-5">
+          <mxGeometry width="50" height="50" relative="1" as="geometry">
+            <mxPoint x="220" y="210" as="sourcePoint" />
+            <mxPoint x="380" y="95" as="targetPoint" />
+          </mxGeometry>
+        </mxCell>
+        <mxCell id="GylxGBc_4kwvuqjtwPvo-5" value="enterData" style="rounded=1;whiteSpace=wrap;html=1;" vertex="1" parent="1">
+          <mxGeometry x="354" y="65" width="120" height="60" as="geometry" />
+        </mxCell>
+        <mxCell id="GylxGBc_4kwvuqjtwPvo-6" value="" style="endArrow=classic;html=1;rounded=0;exitX=0.5;exitY=1;exitDx=0;exitDy=0;entryX=0.5;entryY=0;entryDx=0;entryDy=0;" edge="1" parent="1" source="GylxGBc_4kwvuqjtwPvo-11" target="GylxGBc_4kwvuqjtwPvo-12">
+          <mxGeometry width="50" height="50" relative="1" as="geometry">
+            <mxPoint x="220" y="210" as="sourcePoint" />
+            <mxPoint x="270" y="160" as="targetPoint" />
+          </mxGeometry>
+        </mxCell>
+        <mxCell id="GylxGBc_4kwvuqjtwPvo-8" value="" style="endArrow=open;dashed=1;html=1;rounded=0;endFill=0;exitX=1;exitY=0.5;exitDx=0;exitDy=0;" edge="1" parent="1" source="GylxGBc_4kwvuqjtwPvo-5">
+          <mxGeometry width="50" height="50" relative="1" as="geometry">
+            <mxPoint x="500" y="110" as="sourcePoint" />
+            <mxPoint x="540" y="95" as="targetPoint" />
+          </mxGeometry>
+        </mxCell>
+        <mxCell id="GylxGBc_4kwvuqjtwPvo-9" value="OfferData" style="rounded=0;whiteSpace=wrap;html=1;" vertex="1" parent="1">
+          <mxGeometry x="540" y="65" width="120" height="60" as="geometry" />
+        </mxCell>
+        <mxCell id="GylxGBc_4kwvuqjtwPvo-10" value="" style="endArrow=open;dashed=1;html=1;rounded=0;endFill=0;exitX=0.5;exitY=1;exitDx=0;exitDy=0;" edge="1" parent="1" source="GylxGBc_4kwvuqjtwPvo-9">
+          <mxGeometry width="50" height="50" relative="1" as="geometry">
+            <mxPoint x="484" y="105" as="sourcePoint" />
+            <mxPoint x="600" y="180" as="targetPoint" />
+          </mxGeometry>
+        </mxCell>
+        <mxCell id="GylxGBc_4kwvuqjtwPvo-11" value="ValidateData" style="rounded=1;whiteSpace=wrap;html=1;" vertex="1" parent="1">
+          <mxGeometry x="540" y="180" width="120" height="60" as="geometry" />
+        </mxCell>
+        <mxCell id="GylxGBc_4kwvuqjtwPvo-12" value="" style="rhombus;whiteSpace=wrap;html=1;" vertex="1" parent="1">
+          <mxGeometry x="560" y="290" width="80" height="80" as="geometry" />
+        </mxCell>
+        <mxCell id="GylxGBc_4kwvuqjtwPvo-13" value="" style="endArrow=classic;html=1;rounded=0;exitX=1;exitY=0.5;exitDx=0;exitDy=0;entryX=0.5;entryY=0;entryDx=0;entryDy=0;" edge="1" parent="1" source="GylxGBc_4kwvuqjtwPvo-12" target="GylxGBc_4kwvuqjtwPvo-5">
+          <mxGeometry width="50" height="50" relative="1" as="geometry">
+            <mxPoint x="450" y="360" as="sourcePoint" />
+            <mxPoint x="500" y="310" as="targetPoint" />
+            <Array as="points">
+              <mxPoint x="720" y="330" />
+              <mxPoint x="720" y="30" />
+              <mxPoint x="414" y="30" />
+            </Array>
+          </mxGeometry>
+        </mxCell>
+        <mxCell id="GylxGBc_4kwvuqjtwPvo-14" value="[data not valid]" style="text;html=1;align=center;verticalAlign=middle;whiteSpace=wrap;rounded=0;" vertex="1" parent="1">
+          <mxGeometry x="630" y="300" width="90" height="30" as="geometry" />
+        </mxCell>
+        <mxCell id="GylxGBc_4kwvuqjtwPvo-15" value="saveData" style="rounded=1;whiteSpace=wrap;html=1;" vertex="1" parent="1">
+          <mxGeometry x="354" y="300" width="120" height="60" as="geometry" />
+        </mxCell>
+        <mxCell id="GylxGBc_4kwvuqjtwPvo-16" value="" style="endArrow=classic;html=1;rounded=0;entryX=1;entryY=0.5;entryDx=0;entryDy=0;exitX=0;exitY=0.5;exitDx=0;exitDy=0;" edge="1" parent="1" source="GylxGBc_4kwvuqjtwPvo-12" target="GylxGBc_4kwvuqjtwPvo-15">
+          <mxGeometry width="50" height="50" relative="1" as="geometry">
+            <mxPoint x="450" y="360" as="sourcePoint" />
+            <mxPoint x="500" y="310" as="targetPoint" />
+          </mxGeometry>
+        </mxCell>
+        <mxCell id="GylxGBc_4kwvuqjtwPvo-18" value="" style="rhombus;whiteSpace=wrap;html=1;" vertex="1" parent="1">
+          <mxGeometry x="190" y="290" width="80" height="80" as="geometry" />
+        </mxCell>
+        <mxCell id="GylxGBc_4kwvuqjtwPvo-19" value="" style="endArrow=classic;html=1;rounded=0;exitX=0;exitY=0.5;exitDx=0;exitDy=0;entryX=1;entryY=0.5;entryDx=0;entryDy=0;" edge="1" parent="1" source="GylxGBc_4kwvuqjtwPvo-15" target="GylxGBc_4kwvuqjtwPvo-18">
+          <mxGeometry width="50" height="50" relative="1" as="geometry">
+            <mxPoint x="450" y="360" as="sourcePoint" />
+            <mxPoint x="500" y="310" as="targetPoint" />
+          </mxGeometry>
+        </mxCell>
+        <mxCell id="GylxGBc_4kwvuqjtwPvo-20" value="" style="endArrow=classic;html=1;rounded=0;entryX=0.5;entryY=1;entryDx=0;entryDy=0;exitX=0.5;exitY=0;exitDx=0;exitDy=0;" edge="1" parent="1" source="GylxGBc_4kwvuqjtwPvo-18" target="GylxGBc_4kwvuqjtwPvo-21">
+          <mxGeometry width="50" height="50" relative="1" as="geometry">
+            <mxPoint x="450" y="360" as="sourcePoint" />
+            <mxPoint x="500" y="310" as="targetPoint" />
+          </mxGeometry>
+        </mxCell>
+        <mxCell id="GylxGBc_4kwvuqjtwPvo-21" value="ErrorMessage" style="rounded=1;whiteSpace=wrap;html=1;" vertex="1" parent="1">
+          <mxGeometry x="170" y="160" width="120" height="60" as="geometry" />
+        </mxCell>
+        <mxCell id="GylxGBc_4kwvuqjtwPvo-22" value="" style="endArrow=classic;html=1;rounded=0;exitX=1;exitY=0.5;exitDx=0;exitDy=0;" edge="1" parent="1" source="GylxGBc_4kwvuqjtwPvo-21">
+          <mxGeometry width="50" height="50" relative="1" as="geometry">
+            <mxPoint x="450" y="360" as="sourcePoint" />
+            <mxPoint x="370" y="190" as="targetPoint" />
+            <Array as="points" />
+          </mxGeometry>
+        </mxCell>
+        <mxCell id="GylxGBc_4kwvuqjtwPvo-23" value="successMessage" style="rounded=1;whiteSpace=wrap;html=1;" vertex="1" parent="1">
+          <mxGeometry x="170" y="460" width="120" height="60" as="geometry" />
+        </mxCell>
+        <mxCell id="GylxGBc_4kwvuqjtwPvo-24" value="" style="endArrow=classic;html=1;rounded=0;exitX=0.5;exitY=1;exitDx=0;exitDy=0;" edge="1" parent="1" source="GylxGBc_4kwvuqjtwPvo-18" target="GylxGBc_4kwvuqjtwPvo-23">
+          <mxGeometry width="50" height="50" relative="1" as="geometry">
+            <mxPoint x="450" y="360" as="sourcePoint" />
+            <mxPoint x="500" y="310" as="targetPoint" />
+          </mxGeometry>
+        </mxCell>
+        <mxCell id="GylxGBc_4kwvuqjtwPvo-25" value="" style="ellipse;html=1;shape=endState;fillColor=#000000;strokeColor=#ff0000;" vertex="1" parent="1">
+          <mxGeometry x="215" y="585" width="30" height="30" as="geometry" />
+        </mxCell>
+        <mxCell id="GylxGBc_4kwvuqjtwPvo-26" value="" style="endArrow=classic;html=1;rounded=0;exitX=0.5;exitY=1;exitDx=0;exitDy=0;entryX=0.5;entryY=0;entryDx=0;entryDy=0;" edge="1" parent="1" source="GylxGBc_4kwvuqjtwPvo-23" target="GylxGBc_4kwvuqjtwPvo-25">
+          <mxGeometry width="50" height="50" relative="1" as="geometry">
+            <mxPoint x="450" y="360" as="sourcePoint" />
+            <mxPoint x="500" y="310" as="targetPoint" />
+          </mxGeometry>
+        </mxCell>
+        <mxCell id="GylxGBc_4kwvuqjtwPvo-27" value="[data valid]" style="text;html=1;align=center;verticalAlign=middle;whiteSpace=wrap;rounded=0;" vertex="1" parent="1">
+          <mxGeometry x="480" y="300" width="70" height="30" as="geometry" />
+        </mxCell>
+        <mxCell id="GylxGBc_4kwvuqjtwPvo-28" value="[error saving]" style="text;html=1;align=center;verticalAlign=middle;whiteSpace=wrap;rounded=0;rotation=-90;" vertex="1" parent="1">
+          <mxGeometry x="205" y="250" width="85" height="30" as="geometry" />
+        </mxCell>
+        <mxCell id="GylxGBc_4kwvuqjtwPvo-29" value="[saving]" style="text;html=1;align=center;verticalAlign=middle;whiteSpace=wrap;rounded=0;rotation=-90;" vertex="1" parent="1">
+          <mxGeometry x="205" y="400" width="85" height="30" as="geometry" />
+        </mxCell>
+        <mxCell id="GylxGBc_4kwvuqjtwPvo-33" value="" style="verticalLabelPosition=bottom;verticalAlign=top;html=1;shape=mxgraph.flowchart.or;" vertex="1" parent="1">
+          <mxGeometry x="370" y="170" width="40" height="40" as="geometry" />
+        </mxCell>
+      </root>
+    </mxGraphModel>
+  </diagram>
+</mxfile>
--- a/doc/Dienstleistung-ER-Diagramm.drawio
+++ b/doc/Dienstleistung-ER-Diagramm.drawio
@@ -0,0 +1,103 @@
+<mxfile host="app.diagrams.net" modified="2020-06-30T06:41:58.039Z" agent="5.0 (Macintosh; Intel Mac OS X 10_14_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/83.0.4103.116 Safari/537.36" etag="eN_aVuXlrJnozz_3bGs0" version="13.3.5">
+  <diagram id="R2lEEEUBdFMjLlhIrx00" name="Page-1">
+    <mxGraphModel dx="1223" dy="797" grid="1" gridSize="10" guides="1" tooltips="1" connect="1" arrows="1" fold="1" page="1" pageScale="1" pageWidth="850" pageHeight="1100" math="0" shadow="0" extFonts="Permanent Marker^https://fonts.googleapis.com/css?family=Permanent+Marker">
+      <root>
+        <mxCell id="0" />
+        <mxCell id="1" parent="0" />
+        <mxCell id="C-vyLk0tnHw3VtMMgP7b-1" value="" style="edgeStyle=entityRelationEdgeStyle;endArrow=ERzeroToMany;startArrow=ERone;endFill=1;startFill=0;" parent="1" source="C-vyLk0tnHw3VtMMgP7b-24" target="C-vyLk0tnHw3VtMMgP7b-6" edge="1">
+          <mxGeometry width="100" height="100" relative="1" as="geometry">
+            <mxPoint x="340" y="720" as="sourcePoint" />
+            <mxPoint x="440" y="620" as="targetPoint" />
+          </mxGeometry>
+        </mxCell>
+        <mxCell id="C-vyLk0tnHw3VtMMgP7b-12" value="" style="edgeStyle=entityRelationEdgeStyle;endArrow=ERzeroToMany;startArrow=ERone;endFill=1;startFill=0;" parent="1" source="C-vyLk0tnHw3VtMMgP7b-3" target="C-vyLk0tnHw3VtMMgP7b-17" edge="1">
+          <mxGeometry width="100" height="100" relative="1" as="geometry">
+            <mxPoint x="400" y="180" as="sourcePoint" />
+            <mxPoint x="460" y="205" as="targetPoint" />
+          </mxGeometry>
+        </mxCell>
+        <mxCell id="C-vyLk0tnHw3VtMMgP7b-2" value="Orders" style="shape=table;startSize=30;container=1;collapsible=1;childLayout=tableLayout;fixedRows=1;rowLines=0;fontStyle=1;align=center;resizeLast=1;" parent="1" vertex="1">
+          <mxGeometry x="450" y="120" width="250" height="130" as="geometry" />
+        </mxCell>
+        <mxCell id="C-vyLk0tnHw3VtMMgP7b-3" value="" style="shape=partialRectangle;collapsible=0;dropTarget=0;pointerEvents=0;fillColor=none;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;top=0;left=0;right=0;bottom=1;" parent="C-vyLk0tnHw3VtMMgP7b-2" vertex="1">
+          <mxGeometry y="30" width="250" height="30" as="geometry" />
+        </mxCell>
+        <mxCell id="C-vyLk0tnHw3VtMMgP7b-4" value="PK" style="shape=partialRectangle;overflow=hidden;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;fontStyle=1;" parent="C-vyLk0tnHw3VtMMgP7b-3" vertex="1">
+          <mxGeometry width="30" height="30" as="geometry" />
+        </mxCell>
+        <mxCell id="C-vyLk0tnHw3VtMMgP7b-5" value="order_id int NOT NULL " style="shape=partialRectangle;overflow=hidden;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;align=left;spacingLeft=6;fontStyle=5;" parent="C-vyLk0tnHw3VtMMgP7b-3" vertex="1">
+          <mxGeometry x="30" width="220" height="30" as="geometry" />
+        </mxCell>
+        <mxCell id="C-vyLk0tnHw3VtMMgP7b-6" value="" style="shape=partialRectangle;collapsible=0;dropTarget=0;pointerEvents=0;fillColor=none;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;top=0;left=0;right=0;bottom=0;" parent="C-vyLk0tnHw3VtMMgP7b-2" vertex="1">
+          <mxGeometry y="60" width="250" height="30" as="geometry" />
+        </mxCell>
+        <mxCell id="C-vyLk0tnHw3VtMMgP7b-7" value="FK1" style="shape=partialRectangle;overflow=hidden;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;" parent="C-vyLk0tnHw3VtMMgP7b-6" vertex="1">
+          <mxGeometry width="30" height="30" as="geometry" />
+        </mxCell>
+        <mxCell id="C-vyLk0tnHw3VtMMgP7b-8" value="customer_id int NOT NULL" style="shape=partialRectangle;overflow=hidden;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;align=left;spacingLeft=6;" parent="C-vyLk0tnHw3VtMMgP7b-6" vertex="1">
+          <mxGeometry x="30" width="220" height="30" as="geometry" />
+        </mxCell>
+        <mxCell id="C-vyLk0tnHw3VtMMgP7b-9" value="" style="shape=partialRectangle;collapsible=0;dropTarget=0;pointerEvents=0;fillColor=none;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;top=0;left=0;right=0;bottom=0;" parent="C-vyLk0tnHw3VtMMgP7b-2" vertex="1">
+          <mxGeometry y="90" width="250" height="30" as="geometry" />
+        </mxCell>
+        <mxCell id="C-vyLk0tnHw3VtMMgP7b-10" value="" style="shape=partialRectangle;overflow=hidden;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;" parent="C-vyLk0tnHw3VtMMgP7b-9" vertex="1">
+          <mxGeometry width="30" height="30" as="geometry" />
+        </mxCell>
+        <mxCell id="C-vyLk0tnHw3VtMMgP7b-11" value="order_date date NOT NULL" style="shape=partialRectangle;overflow=hidden;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;align=left;spacingLeft=6;" parent="C-vyLk0tnHw3VtMMgP7b-9" vertex="1">
+          <mxGeometry x="30" width="220" height="30" as="geometry" />
+        </mxCell>
+        <mxCell id="C-vyLk0tnHw3VtMMgP7b-13" value="Shipments" style="shape=table;startSize=30;container=1;collapsible=1;childLayout=tableLayout;fixedRows=1;rowLines=0;fontStyle=1;align=center;resizeLast=1;" parent="1" vertex="1">
+          <mxGeometry x="450" y="280" width="250" height="130" as="geometry" />
+        </mxCell>
+        <mxCell id="C-vyLk0tnHw3VtMMgP7b-14" value="" style="shape=partialRectangle;collapsible=0;dropTarget=0;pointerEvents=0;fillColor=none;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;top=0;left=0;right=0;bottom=1;" parent="C-vyLk0tnHw3VtMMgP7b-13" vertex="1">
+          <mxGeometry y="30" width="250" height="30" as="geometry" />
+        </mxCell>
+        <mxCell id="C-vyLk0tnHw3VtMMgP7b-15" value="PK" style="shape=partialRectangle;overflow=hidden;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;fontStyle=1;" parent="C-vyLk0tnHw3VtMMgP7b-14" vertex="1">
+          <mxGeometry width="30" height="30" as="geometry" />
+        </mxCell>
+        <mxCell id="C-vyLk0tnHw3VtMMgP7b-16" value="shipment_id int NOT NULL " style="shape=partialRectangle;overflow=hidden;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;align=left;spacingLeft=6;fontStyle=5;" parent="C-vyLk0tnHw3VtMMgP7b-14" vertex="1">
+          <mxGeometry x="30" width="220" height="30" as="geometry" />
+        </mxCell>
+        <mxCell id="C-vyLk0tnHw3VtMMgP7b-17" value="" style="shape=partialRectangle;collapsible=0;dropTarget=0;pointerEvents=0;fillColor=none;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;top=0;left=0;right=0;bottom=0;" parent="C-vyLk0tnHw3VtMMgP7b-13" vertex="1">
+          <mxGeometry y="60" width="250" height="30" as="geometry" />
+        </mxCell>
+        <mxCell id="C-vyLk0tnHw3VtMMgP7b-18" value="FK1" style="shape=partialRectangle;overflow=hidden;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;" parent="C-vyLk0tnHw3VtMMgP7b-17" vertex="1">
+          <mxGeometry width="30" height="30" as="geometry" />
+        </mxCell>
+        <mxCell id="C-vyLk0tnHw3VtMMgP7b-19" value="order_id int NOT NULL" style="shape=partialRectangle;overflow=hidden;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;align=left;spacingLeft=6;" parent="C-vyLk0tnHw3VtMMgP7b-17" vertex="1">
+          <mxGeometry x="30" width="220" height="30" as="geometry" />
+        </mxCell>
+        <mxCell id="C-vyLk0tnHw3VtMMgP7b-20" value="" style="shape=partialRectangle;collapsible=0;dropTarget=0;pointerEvents=0;fillColor=none;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;top=0;left=0;right=0;bottom=0;" parent="C-vyLk0tnHw3VtMMgP7b-13" vertex="1">
+          <mxGeometry y="90" width="250" height="30" as="geometry" />
+        </mxCell>
+        <mxCell id="C-vyLk0tnHw3VtMMgP7b-21" value="" style="shape=partialRectangle;overflow=hidden;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;" parent="C-vyLk0tnHw3VtMMgP7b-20" vertex="1">
+          <mxGeometry width="30" height="30" as="geometry" />
+        </mxCell>
+        <mxCell id="C-vyLk0tnHw3VtMMgP7b-22" value="shipment_date date NOT NULL" style="shape=partialRectangle;overflow=hidden;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;align=left;spacingLeft=6;" parent="C-vyLk0tnHw3VtMMgP7b-20" vertex="1">
+          <mxGeometry x="30" width="220" height="30" as="geometry" />
+        </mxCell>
+        <mxCell id="C-vyLk0tnHw3VtMMgP7b-23" value="Customers" style="shape=table;startSize=30;container=1;collapsible=1;childLayout=tableLayout;fixedRows=1;rowLines=0;fontStyle=1;align=center;resizeLast=1;" parent="1" vertex="1">
+          <mxGeometry x="120" y="120" width="250" height="100" as="geometry" />
+        </mxCell>
+        <mxCell id="C-vyLk0tnHw3VtMMgP7b-24" value="" style="shape=partialRectangle;collapsible=0;dropTarget=0;pointerEvents=0;fillColor=none;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;top=0;left=0;right=0;bottom=1;" parent="C-vyLk0tnHw3VtMMgP7b-23" vertex="1">
+          <mxGeometry y="30" width="250" height="30" as="geometry" />
+        </mxCell>
+        <mxCell id="C-vyLk0tnHw3VtMMgP7b-25" value="PK" style="shape=partialRectangle;overflow=hidden;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;fontStyle=1;" parent="C-vyLk0tnHw3VtMMgP7b-24" vertex="1">
+          <mxGeometry width="30" height="30" as="geometry" />
+        </mxCell>
+        <mxCell id="C-vyLk0tnHw3VtMMgP7b-26" value="customer_id int NOT NULL " style="shape=partialRectangle;overflow=hidden;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;align=left;spacingLeft=6;fontStyle=5;" parent="C-vyLk0tnHw3VtMMgP7b-24" vertex="1">
+          <mxGeometry x="30" width="220" height="30" as="geometry" />
+        </mxCell>
+        <mxCell id="C-vyLk0tnHw3VtMMgP7b-27" value="" style="shape=partialRectangle;collapsible=0;dropTarget=0;pointerEvents=0;fillColor=none;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;top=0;left=0;right=0;bottom=0;" parent="C-vyLk0tnHw3VtMMgP7b-23" vertex="1">
+          <mxGeometry y="60" width="250" height="30" as="geometry" />
+        </mxCell>
+        <mxCell id="C-vyLk0tnHw3VtMMgP7b-28" value="" style="shape=partialRectangle;overflow=hidden;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;" parent="C-vyLk0tnHw3VtMMgP7b-27" vertex="1">
+          <mxGeometry width="30" height="30" as="geometry" />
+        </mxCell>
+        <mxCell id="C-vyLk0tnHw3VtMMgP7b-29" value="customer_name char(50) NOT NULL" style="shape=partialRectangle;overflow=hidden;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;align=left;spacingLeft=6;" parent="C-vyLk0tnHw3VtMMgP7b-27" vertex="1">
+          <mxGeometry x="30" width="220" height="30" as="geometry" />
+        </mxCell>
+      </root>
+    </mxGraphModel>
+  </diagram>
+</mxfile>
--- a/doc/Klassendiagramm.drawio
+++ b/doc/Klassendiagramm.drawio
@@ -1,6 +1,6 @@
 <mxfile host="Electron" agent="Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) draw.io/25.0.2 Chrome/128.0.6613.186 Electron/32.2.5 Safari/537.36" version="25.0.2">
  <diagram id="C5RBs43oDa-KdzZeNtuy" name="Page-1">
-    <mxGraphModel dx="2963" dy="1707" grid="1" gridSize="10" guides="1" tooltips="1" connect="1" arrows="1" fold="1" page="1" pageScale="1" pageWidth="827" pageHeight="1169" math="0" shadow="0">
+    <mxGraphModel dx="1185" dy="683" grid="1" gridSize="10" guides="1" tooltips="1" connect="1" arrows="1" fold="1" page="1" pageScale="1" pageWidth="827" pageHeight="1169" math="0" shadow="0">
      <root>
        <mxCell id="WIyWlLk6GJQsqaUBKTNV-0" />
        <mxCell id="WIyWlLk6GJQsqaUBKTNV-1" parent="WIyWlLk6GJQsqaUBKTNV-0" />
@@ -290,8 +290,8 @@
            <mxPoint x="250" y="530" as="sourcePoint" />
            <mxPoint x="300" y="480" as="targetPoint" />
            <Array as="points">
-              <mxPoint x="440" y="383" />
-              <mxPoint x="440" y="468" />
+              <mxPoint x="450" y="383" />
+              <mxPoint x="450" y="468" />
            </Array>
          </mxGeometry>
        </mxCell>
@@ -307,8 +307,8 @@
            <mxPoint x="270" y="530" as="sourcePoint" />
            <mxPoint x="320" y="480" as="targetPoint" />
            <Array as="points">
-              <mxPoint x="430" y="406" />
-              <mxPoint x="430" y="698" />
+              <mxPoint x="440" y="406" />
+              <mxPoint x="440" y="700" />
            </Array>
          </mxGeometry>
        </mxCell>
@@ -323,9 +323,9 @@
            <mxPoint x="270" y="530" as="sourcePoint" />
            <mxPoint x="470" y="940" as="targetPoint" />
            <Array as="points">
-              <mxPoint x="410" y="423" />
-              <mxPoint x="410" y="600" />
-              <mxPoint x="410" y="940" />
+              <mxPoint x="430" y="420" />
+              <mxPoint x="430" y="600" />
+              <mxPoint x="430" y="940" />
            </Array>
          </mxGeometry>
        </mxCell>
@@ -389,25 +389,25 @@
        <mxCell id="v96xPLQoPeUk4bUV2WaN-99" value="+ instance(): connection" style="text;strokeColor=none;fillColor=none;align=left;verticalAlign=top;spacingLeft=4;spacingRight=4;overflow=hidden;rotatable=0;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;whiteSpace=wrap;html=1;" parent="v96xPLQoPeUk4bUV2WaN-96" vertex="1">
          <mxGeometry y="58" width="170" height="32" as="geometry" />
        </mxCell>
-        <mxCell id="6xiAvg-kEoilwsfhhM0o-0" value="PyqcrmFlags" style="swimlane;fontStyle=1;align=center;verticalAlign=top;childLayout=stackLayout;horizontal=1;startSize=26;horizontalStack=0;resizeParent=1;resizeParentMax=0;resizeLast=0;collapsible=1;marginBottom=0;whiteSpace=wrap;html=1;" vertex="1" parent="WIyWlLk6GJQsqaUBKTNV-1">
+        <mxCell id="6xiAvg-kEoilwsfhhM0o-0" value="PyqcrmFlags" style="swimlane;fontStyle=1;align=center;verticalAlign=top;childLayout=stackLayout;horizontal=1;startSize=26;horizontalStack=0;resizeParent=1;resizeParentMax=0;resizeLast=0;collapsible=1;marginBottom=0;whiteSpace=wrap;html=1;" parent="WIyWlLk6GJQsqaUBKTNV-1" vertex="1">
          <mxGeometry x="870" y="340" width="170" height="150" as="geometry" />
        </mxCell>
-        <mxCell id="6xiAvg-kEoilwsfhhM0o-1" value="&lt;div&gt;ADMIN: enum&lt;/div&gt;&lt;div&gt;USER: enum&lt;/div&gt;" style="text;strokeColor=none;fillColor=none;align=left;verticalAlign=top;spacingLeft=4;spacingRight=4;overflow=hidden;rotatable=0;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;whiteSpace=wrap;html=1;" vertex="1" parent="6xiAvg-kEoilwsfhhM0o-0">
+        <mxCell id="6xiAvg-kEoilwsfhhM0o-1" value="&lt;div&gt;ADMIN: enum&lt;/div&gt;&lt;div&gt;USER: enum&lt;/div&gt;" style="text;strokeColor=none;fillColor=none;align=left;verticalAlign=top;spacingLeft=4;spacingRight=4;overflow=hidden;rotatable=0;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;whiteSpace=wrap;html=1;" parent="6xiAvg-kEoilwsfhhM0o-0" vertex="1">
          <mxGeometry y="26" width="170" height="44" as="geometry" />
        </mxCell>
-        <mxCell id="6xiAvg-kEoilwsfhhM0o-2" value="" style="line;strokeWidth=1;fillColor=none;align=left;verticalAlign=middle;spacingTop=-1;spacingLeft=3;spacingRight=3;rotatable=0;labelPosition=right;points=[];portConstraint=eastwest;strokeColor=inherit;" vertex="1" parent="6xiAvg-kEoilwsfhhM0o-0">
+        <mxCell id="6xiAvg-kEoilwsfhhM0o-2" value="" style="line;strokeWidth=1;fillColor=none;align=left;verticalAlign=middle;spacingTop=-1;spacingLeft=3;spacingRight=3;rotatable=0;labelPosition=right;points=[];portConstraint=eastwest;strokeColor=inherit;" parent="6xiAvg-kEoilwsfhhM0o-0" vertex="1">
          <mxGeometry y="70" width="170" height="80" as="geometry" />
        </mxCell>
-        <mxCell id="6xiAvg-kEoilwsfhhM0o-3" value="PyqcrmAppliEmpyFlags" style="swimlane;fontStyle=1;align=center;verticalAlign=top;childLayout=stackLayout;horizontal=1;startSize=26;horizontalStack=0;resizeParent=1;resizeParentMax=0;resizeLast=0;collapsible=1;marginBottom=0;whiteSpace=wrap;html=1;" vertex="1" parent="WIyWlLk6GJQsqaUBKTNV-1">
+        <mxCell id="6xiAvg-kEoilwsfhhM0o-3" value="PyqcrmAppliEmpyFlags" style="swimlane;fontStyle=1;align=center;verticalAlign=top;childLayout=stackLayout;horizontal=1;startSize=26;horizontalStack=0;resizeParent=1;resizeParentMax=0;resizeLast=0;collapsible=1;marginBottom=0;whiteSpace=wrap;html=1;" parent="WIyWlLk6GJQsqaUBKTNV-1" vertex="1">
          <mxGeometry x="870" y="170" width="170" height="140" as="geometry" />
        </mxCell>
-        <mxCell id="6xiAvg-kEoilwsfhhM0o-4" value="&lt;div&gt;ALL: enum&lt;/div&gt;&lt;div&gt;APPLICANT: enum&lt;/div&gt;&lt;div&gt;EMPLOYEE; enum&lt;/div&gt;" style="text;strokeColor=none;fillColor=none;align=left;verticalAlign=top;spacingLeft=4;spacingRight=4;overflow=hidden;rotatable=0;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;whiteSpace=wrap;html=1;" vertex="1" parent="6xiAvg-kEoilwsfhhM0o-3">
+        <mxCell id="6xiAvg-kEoilwsfhhM0o-4" value="&lt;div&gt;ALL: enum&lt;/div&gt;&lt;div&gt;APPLICANT: enum&lt;/div&gt;&lt;div&gt;EMPLOYEE; enum&lt;/div&gt;" style="text;strokeColor=none;fillColor=none;align=left;verticalAlign=top;spacingLeft=4;spacingRight=4;overflow=hidden;rotatable=0;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;whiteSpace=wrap;html=1;" parent="6xiAvg-kEoilwsfhhM0o-3" vertex="1">
          <mxGeometry y="26" width="170" height="64" as="geometry" />
        </mxCell>
-        <mxCell id="6xiAvg-kEoilwsfhhM0o-5" value="" style="line;strokeWidth=1;fillColor=none;align=left;verticalAlign=middle;spacingTop=-1;spacingLeft=3;spacingRight=3;rotatable=0;labelPosition=right;points=[];portConstraint=eastwest;strokeColor=inherit;" vertex="1" parent="6xiAvg-kEoilwsfhhM0o-3">
+        <mxCell id="6xiAvg-kEoilwsfhhM0o-5" value="" style="line;strokeWidth=1;fillColor=none;align=left;verticalAlign=middle;spacingTop=-1;spacingLeft=3;spacingRight=3;rotatable=0;labelPosition=right;points=[];portConstraint=eastwest;strokeColor=inherit;" parent="6xiAvg-kEoilwsfhhM0o-3" vertex="1">
          <mxGeometry y="90" width="170" height="50" as="geometry" />
        </mxCell>
-        <mxCell id="6xiAvg-kEoilwsfhhM0o-6" value="" style="endArrow=none;html=1;rounded=0;exitX=0.25;exitY=1;exitDx=0;exitDy=0;entryX=0.25;entryY=0;entryDx=0;entryDy=0;" edge="1" parent="WIyWlLk6GJQsqaUBKTNV-1" source="v96xPLQoPeUk4bUV2WaN-89" target="v96xPLQoPeUk4bUV2WaN-40">
+        <mxCell id="6xiAvg-kEoilwsfhhM0o-6" value="" style="endArrow=none;html=1;rounded=0;exitX=0.25;exitY=1;exitDx=0;exitDy=0;entryX=0.25;entryY=0;entryDx=0;entryDy=0;" parent="WIyWlLk6GJQsqaUBKTNV-1" source="v96xPLQoPeUk4bUV2WaN-89" target="v96xPLQoPeUk4bUV2WaN-40" edge="1">
          <mxGeometry width="50" height="50" relative="1" as="geometry">
            <mxPoint x="420" y="900" as="sourcePoint" />
            <mxPoint x="470" y="850" as="targetPoint" />
@@ -417,7 +417,7 @@
            </Array>
          </mxGeometry>
        </mxCell>
-        <mxCell id="6xiAvg-kEoilwsfhhM0o-7" value="" style="endArrow=none;html=1;rounded=0;exitX=0.5;exitY=0;exitDx=0;exitDy=0;entryX=0.5;entryY=1;entryDx=0;entryDy=0;" edge="1" parent="WIyWlLk6GJQsqaUBKTNV-1" source="v96xPLQoPeUk4bUV2WaN-48" target="v96xPLQoPeUk4bUV2WaN-93">
+        <mxCell id="6xiAvg-kEoilwsfhhM0o-7" value="" style="endArrow=none;html=1;rounded=0;exitX=0.5;exitY=0;exitDx=0;exitDy=0;entryX=0.5;entryY=1;entryDx=0;entryDy=0;" parent="WIyWlLk6GJQsqaUBKTNV-1" source="v96xPLQoPeUk4bUV2WaN-48" target="v96xPLQoPeUk4bUV2WaN-93" edge="1">
          <mxGeometry width="50" height="50" relative="1" as="geometry">
            <mxPoint x="420" y="900" as="sourcePoint" />
            <mxPoint x="470" y="850" as="targetPoint" />
@@ -427,7 +427,7 @@
            </Array>
          </mxGeometry>
        </mxCell>
-        <mxCell id="6xiAvg-kEoilwsfhhM0o-8" value="" style="endArrow=none;html=1;rounded=0;exitX=0.25;exitY=1;exitDx=0;exitDy=0;entryX=0.75;entryY=0;entryDx=0;entryDy=0;" edge="1" parent="WIyWlLk6GJQsqaUBKTNV-1" source="v96xPLQoPeUk4bUV2WaN-93" target="v96xPLQoPeUk4bUV2WaN-40">
+        <mxCell id="6xiAvg-kEoilwsfhhM0o-8" value="" style="endArrow=none;html=1;rounded=0;exitX=0.25;exitY=1;exitDx=0;exitDy=0;entryX=0.75;entryY=0;entryDx=0;entryDy=0;" parent="WIyWlLk6GJQsqaUBKTNV-1" source="v96xPLQoPeUk4bUV2WaN-93" target="v96xPLQoPeUk4bUV2WaN-40" edge="1">
          <mxGeometry width="50" height="50" relative="1" as="geometry">
            <mxPoint x="420" y="900" as="sourcePoint" />
            <mxPoint x="470" y="850" as="targetPoint" />
@@ -437,7 +437,7 @@
            </Array>
          </mxGeometry>
        </mxCell>
-        <mxCell id="6xiAvg-kEoilwsfhhM0o-9" value="" style="endArrow=none;html=1;rounded=0;entryX=0.75;entryY=1;entryDx=0;entryDy=0;exitX=0.25;exitY=0;exitDx=0;exitDy=0;" edge="1" parent="WIyWlLk6GJQsqaUBKTNV-1" source="v96xPLQoPeUk4bUV2WaN-48" target="v96xPLQoPeUk4bUV2WaN-89">
+        <mxCell id="6xiAvg-kEoilwsfhhM0o-9" value="" style="endArrow=none;html=1;rounded=0;entryX=0.75;entryY=1;entryDx=0;entryDy=0;exitX=0.25;exitY=0;exitDx=0;exitDy=0;" parent="WIyWlLk6GJQsqaUBKTNV-1" source="v96xPLQoPeUk4bUV2WaN-48" target="v96xPLQoPeUk4bUV2WaN-89" edge="1">
          <mxGeometry width="50" height="50" relative="1" as="geometry">
            <mxPoint x="420" y="900" as="sourcePoint" />
            <mxPoint x="470" y="850" as="targetPoint" />
@@ -447,42 +447,77 @@
            </Array>
          </mxGeometry>
        </mxCell>
-        <mxCell id="6xiAvg-kEoilwsfhhM0o-10" value="" style="endArrow=none;html=1;rounded=0;entryX=1;entryY=0.5;entryDx=0;entryDy=0;exitX=0;exitY=0.5;exitDx=0;exitDy=0;" edge="1" parent="WIyWlLk6GJQsqaUBKTNV-1" source="v96xPLQoPeUk4bUV2WaN-78" target="v96xPLQoPeUk4bUV2WaN-97">
+        <mxCell id="6xiAvg-kEoilwsfhhM0o-10" value="" style="endArrow=none;html=1;rounded=0;entryX=1;entryY=0.5;entryDx=0;entryDy=0;exitX=0;exitY=0.5;exitDx=0;exitDy=0;" parent="WIyWlLk6GJQsqaUBKTNV-1" source="v96xPLQoPeUk4bUV2WaN-78" target="v96xPLQoPeUk4bUV2WaN-97" edge="1">
          <mxGeometry width="50" height="50" relative="1" as="geometry">
            <mxPoint x="600" y="440" as="sourcePoint" />
            <mxPoint x="650" y="390" as="targetPoint" />
          </mxGeometry>
        </mxCell>
-        <mxCell id="6xiAvg-kEoilwsfhhM0o-11" value="" style="endArrow=none;html=1;rounded=0;exitX=1.001;exitY=0.102;exitDx=0;exitDy=0;exitPerimeter=0;entryX=-0.002;entryY=0.624;entryDx=0;entryDy=0;entryPerimeter=0;" edge="1" parent="WIyWlLk6GJQsqaUBKTNV-1" source="6xiAvg-kEoilwsfhhM0o-0" target="v96xPLQoPeUk4bUV2WaN-80">
+        <mxCell id="6xiAvg-kEoilwsfhhM0o-11" value="" style="endArrow=none;html=1;rounded=0;exitX=1.001;exitY=0.102;exitDx=0;exitDy=0;exitPerimeter=0;entryX=-0.002;entryY=0.624;entryDx=0;entryDy=0;entryPerimeter=0;" parent="WIyWlLk6GJQsqaUBKTNV-1" source="6xiAvg-kEoilwsfhhM0o-0" target="v96xPLQoPeUk4bUV2WaN-80" edge="1">
          <mxGeometry width="50" height="50" relative="1" as="geometry">
            <mxPoint x="600" y="440" as="sourcePoint" />
            <mxPoint x="650" y="390" as="targetPoint" />
          </mxGeometry>
        </mxCell>
-        <mxCell id="6xiAvg-kEoilwsfhhM0o-12" value="" style="endArrow=none;html=1;rounded=0;entryX=1;entryY=0.5;entryDx=0;entryDy=0;exitX=-0.001;exitY=0.316;exitDx=0;exitDy=0;exitPerimeter=0;" edge="1" parent="WIyWlLk6GJQsqaUBKTNV-1" source="v96xPLQoPeUk4bUV2WaN-80" target="6xiAvg-kEoilwsfhhM0o-4">
+        <mxCell id="6xiAvg-kEoilwsfhhM0o-12" value="" style="endArrow=none;html=1;rounded=0;entryX=1;entryY=0.5;entryDx=0;entryDy=0;exitX=-0.001;exitY=0.316;exitDx=0;exitDy=0;exitPerimeter=0;" parent="WIyWlLk6GJQsqaUBKTNV-1" source="v96xPLQoPeUk4bUV2WaN-80" target="6xiAvg-kEoilwsfhhM0o-4" edge="1">
          <mxGeometry width="50" height="50" relative="1" as="geometry">
            <mxPoint x="600" y="440" as="sourcePoint" />
            <mxPoint x="650" y="390" as="targetPoint" />
          </mxGeometry>
        </mxCell>
-        <mxCell id="6xiAvg-kEoilwsfhhM0o-13" value="Vermasseln" style="swimlane;fontStyle=1;align=center;verticalAlign=top;childLayout=stackLayout;horizontal=1;startSize=26;horizontalStack=0;resizeParent=1;resizeParentMax=0;resizeLast=0;collapsible=1;marginBottom=0;whiteSpace=wrap;html=1;" vertex="1" parent="WIyWlLk6GJQsqaUBKTNV-1">
+        <mxCell id="6xiAvg-kEoilwsfhhM0o-13" value="Vermasseln" style="swimlane;fontStyle=1;align=center;verticalAlign=top;childLayout=stackLayout;horizontal=1;startSize=26;horizontalStack=0;resizeParent=1;resizeParentMax=0;resizeLast=0;collapsible=1;marginBottom=0;whiteSpace=wrap;html=1;" parent="WIyWlLk6GJQsqaUBKTNV-1" vertex="1">
          <mxGeometry x="1350" y="40" width="170" height="140" as="geometry" />
        </mxCell>
-        <mxCell id="6xiAvg-kEoilwsfhhM0o-14" value="&lt;div&gt;&lt;br&gt;&lt;/div&gt;&lt;div&gt;&lt;br&gt;&lt;/div&gt;" style="text;strokeColor=none;fillColor=none;align=left;verticalAlign=top;spacingLeft=4;spacingRight=4;overflow=hidden;rotatable=0;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;whiteSpace=wrap;html=1;" vertex="1" parent="6xiAvg-kEoilwsfhhM0o-13">
+        <mxCell id="6xiAvg-kEoilwsfhhM0o-14" value="&lt;div&gt;&lt;br&gt;&lt;/div&gt;&lt;div&gt;&lt;br&gt;&lt;/div&gt;" style="text;strokeColor=none;fillColor=none;align=left;verticalAlign=top;spacingLeft=4;spacingRight=4;overflow=hidden;rotatable=0;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;whiteSpace=wrap;html=1;" parent="6xiAvg-kEoilwsfhhM0o-13" vertex="1">
          <mxGeometry y="26" width="170" height="24" as="geometry" />
        </mxCell>
-        <mxCell id="6xiAvg-kEoilwsfhhM0o-15" value="" style="line;strokeWidth=1;fillColor=none;align=left;verticalAlign=middle;spacingTop=-1;spacingLeft=3;spacingRight=3;rotatable=0;labelPosition=right;points=[];portConstraint=eastwest;strokeColor=inherit;" vertex="1" parent="6xiAvg-kEoilwsfhhM0o-13">
+        <mxCell id="6xiAvg-kEoilwsfhhM0o-15" value="" style="line;strokeWidth=1;fillColor=none;align=left;verticalAlign=middle;spacingTop=-1;spacingLeft=3;spacingRight=3;rotatable=0;labelPosition=right;points=[];portConstraint=eastwest;strokeColor=inherit;" parent="6xiAvg-kEoilwsfhhM0o-13" vertex="1">
          <mxGeometry y="50" width="170" height="8" as="geometry" />
        </mxCell>
-        <mxCell id="6xiAvg-kEoilwsfhhM0o-16" value="+ oscarVermasseln()&lt;div&gt;+ entschluesseln()&lt;/div&gt;&lt;div&gt;-&amp;nbsp; vermasslungsKobold()&lt;/div&gt;&lt;div&gt;+ userPasswordHash&lt;/div&gt;&lt;div&gt;&lt;br&gt;&lt;/div&gt;" style="text;strokeColor=none;fillColor=none;align=left;verticalAlign=top;spacingLeft=4;spacingRight=4;overflow=hidden;rotatable=0;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;whiteSpace=wrap;html=1;" vertex="1" parent="6xiAvg-kEoilwsfhhM0o-13">
+        <mxCell id="6xiAvg-kEoilwsfhhM0o-16" value="+ oscarVermasseln()&lt;div&gt;+ entschluesseln()&lt;/div&gt;&lt;div&gt;-&amp;nbsp; vermasslungsKobold()&lt;/div&gt;&lt;div&gt;+ userPasswordHash&lt;/div&gt;&lt;div&gt;&lt;br&gt;&lt;/div&gt;" style="text;strokeColor=none;fillColor=none;align=left;verticalAlign=top;spacingLeft=4;spacingRight=4;overflow=hidden;rotatable=0;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;whiteSpace=wrap;html=1;" parent="6xiAvg-kEoilwsfhhM0o-13" vertex="1">
          <mxGeometry y="58" width="170" height="82" as="geometry" />
        </mxCell>
-        <mxCell id="6xiAvg-kEoilwsfhhM0o-17" value="" style="endArrow=none;html=1;rounded=0;entryX=0;entryY=0.5;entryDx=0;entryDy=0;exitX=1;exitY=0.5;exitDx=0;exitDy=0;" edge="1" parent="WIyWlLk6GJQsqaUBKTNV-1" source="v96xPLQoPeUk4bUV2WaN-78" target="6xiAvg-kEoilwsfhhM0o-14">
+        <mxCell id="6xiAvg-kEoilwsfhhM0o-17" value="" style="endArrow=none;html=1;rounded=0;entryX=0;entryY=0.5;entryDx=0;entryDy=0;exitX=1;exitY=0.5;exitDx=0;exitDy=0;" parent="WIyWlLk6GJQsqaUBKTNV-1" source="v96xPLQoPeUk4bUV2WaN-78" target="6xiAvg-kEoilwsfhhM0o-14" edge="1">
          <mxGeometry width="50" height="50" relative="1" as="geometry">
            <mxPoint x="800" y="530" as="sourcePoint" />
            <mxPoint x="850" y="480" as="targetPoint" />
          </mxGeometry>
        </mxCell>
+        <mxCell id="oFnCSLyNU9wu8QDSkbbI-1" value="OfferDAO" style="swimlane;fontStyle=1;align=center;verticalAlign=top;childLayout=stackLayout;horizontal=1;startSize=26;horizontalStack=0;resizeParent=1;resizeParentMax=0;resizeLast=0;collapsible=1;marginBottom=0;whiteSpace=wrap;html=1;" vertex="1" parent="WIyWlLk6GJQsqaUBKTNV-1">
+          <mxGeometry x="460" y="1169" width="160" height="170" as="geometry" />
+        </mxCell>
+        <mxCell id="oFnCSLyNU9wu8QDSkbbI-3" value="" style="line;strokeWidth=1;fillColor=none;align=left;verticalAlign=middle;spacingTop=-1;spacingLeft=3;spacingRight=3;rotatable=0;labelPosition=right;points=[];portConstraint=eastwest;strokeColor=inherit;" vertex="1" parent="oFnCSLyNU9wu8QDSkbbI-1">
+          <mxGeometry y="26" width="160" height="54" as="geometry" />
+        </mxCell>
+        <mxCell id="oFnCSLyNU9wu8QDSkbbI-4" value="+ addOffer()&lt;div&gt;+ getOffer()&lt;/div&gt;&lt;div&gt;+ deleteOffer()&lt;/div&gt;&lt;div&gt;+ updateOffer()&lt;/div&gt;" style="text;strokeColor=none;fillColor=none;align=left;verticalAlign=top;spacingLeft=4;spacingRight=4;overflow=hidden;rotatable=0;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;whiteSpace=wrap;html=1;" vertex="1" parent="oFnCSLyNU9wu8QDSkbbI-1">
+          <mxGeometry y="80" width="160" height="90" as="geometry" />
+        </mxCell>
+        <mxCell id="oFnCSLyNU9wu8QDSkbbI-5" value="OfferModel" style="swimlane;fontStyle=1;align=center;verticalAlign=top;childLayout=stackLayout;horizontal=1;startSize=26;horizontalStack=0;resizeParent=1;resizeParentMax=0;resizeLast=0;collapsible=1;marginBottom=0;whiteSpace=wrap;html=1;" vertex="1" parent="WIyWlLk6GJQsqaUBKTNV-1">
+          <mxGeometry x="650" y="1169" width="160" height="250" as="geometry" />
+        </mxCell>
+        <mxCell id="oFnCSLyNU9wu8QDSkbbI-7" value="" style="line;strokeWidth=1;fillColor=none;align=left;verticalAlign=middle;spacingTop=-1;spacingLeft=3;spacingRight=3;rotatable=0;labelPosition=right;points=[];portConstraint=eastwest;strokeColor=inherit;" vertex="1" parent="oFnCSLyNU9wu8QDSkbbI-5">
+          <mxGeometry y="26" width="160" height="54" as="geometry" />
+        </mxCell>
+        <mxCell id="oFnCSLyNU9wu8QDSkbbI-8" value="&lt;div&gt;+ addOffer()&lt;/div&gt;&lt;div&gt;+ deleteOffer()&lt;/div&gt;&lt;div&gt;+ updateOffer()&lt;br&gt;&lt;div&gt;-&amp;nbsp; refreshView()&lt;/div&gt;&lt;div&gt;-&amp;nbsp; getData()&lt;/div&gt;&lt;div&gt;+ rowCount()&lt;/div&gt;&lt;div&gt;+ columnCount()&lt;/div&gt;&lt;div&gt;+ viewCriterion()&lt;/div&gt;&lt;div&gt;+ data()&lt;/div&gt;&lt;div&gt;+ headerData()&lt;/div&gt;&lt;div&gt;+ onRowClicked()&lt;/div&gt;&lt;/div&gt;" style="text;strokeColor=none;fillColor=none;align=left;verticalAlign=top;spacingLeft=4;spacingRight=4;overflow=hidden;rotatable=0;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;whiteSpace=wrap;html=1;" vertex="1" parent="oFnCSLyNU9wu8QDSkbbI-5">
+          <mxGeometry y="80" width="160" height="170" as="geometry" />
+        </mxCell>
+        <mxCell id="oFnCSLyNU9wu8QDSkbbI-9" value="" style="endArrow=none;html=1;rounded=0;" edge="1" parent="WIyWlLk6GJQsqaUBKTNV-1">
+          <mxGeometry width="50" height="50" relative="1" as="geometry">
+            <mxPoint x="620" y="1210" as="sourcePoint" />
+            <mxPoint x="650" y="1210" as="targetPoint" />
+          </mxGeometry>
+        </mxCell>
+        <mxCell id="oFnCSLyNU9wu8QDSkbbI-10" value="" style="endArrow=none;html=1;rounded=0;exitX=0.865;exitY=1;exitDx=0;exitDy=0;exitPerimeter=0;endFill=0;" edge="1" parent="WIyWlLk6GJQsqaUBKTNV-1" source="_OjnZrDktrtFcgEA-KSX-16">
+          <mxGeometry width="50" height="50" relative="1" as="geometry">
+            <mxPoint x="760" y="800" as="sourcePoint" />
+            <mxPoint x="460" y="1210" as="targetPoint" />
+            <Array as="points">
+              <mxPoint x="167" y="450" />
+              <mxPoint x="420" y="450" />
+              <mxPoint x="420" y="1210" />
+            </Array>
+          </mxGeometry>
+        </mxCell>
      </root>
    </mxGraphModel>
  </diagram>
--- a/doc/Sequenzdiagramm_Angebote_Auftrag.drawio
+++ b/doc/Sequenzdiagramm_Angebote_Auftrag.drawio
@@ -0,0 +1,184 @@
+<mxfile host="app.diagrams.net" agent="Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36" version="26.2.14">
+  <diagram name="Seite-1" id="Wrq0Xm_iZAiwaSdTmyxs">
+    <mxGraphModel dx="1425" dy="763" grid="1" gridSize="10" guides="1" tooltips="1" connect="1" arrows="1" fold="1" page="1" pageScale="1" pageWidth="827" pageHeight="1169" math="0" shadow="0">
+      <root>
+        <mxCell id="0" />
+        <mxCell id="1" parent="0" />
+        <mxCell id="t-EcJqArzlBj0utZR-UU-21" value="" style="rounded=0;whiteSpace=wrap;html=1;fillColor=none;" vertex="1" parent="1">
+          <mxGeometry x="60" y="240" width="360" height="210" as="geometry" />
+        </mxCell>
+        <mxCell id="t-EcJqArzlBj0utZR-UU-1" value="Andre" style="shape=umlActor;verticalLabelPosition=bottom;verticalAlign=top;html=1;outlineConnect=0;" vertex="1" parent="1">
+          <mxGeometry x="70" y="150" width="20" height="60" as="geometry" />
+        </mxCell>
+        <mxCell id="t-EcJqArzlBj0utZR-UU-2" value="UI" style="rounded=1;whiteSpace=wrap;html=1;" vertex="1" parent="1">
+          <mxGeometry x="140" y="150" width="120" height="60" as="geometry" />
+        </mxCell>
+        <mxCell id="t-EcJqArzlBj0utZR-UU-3" value="OFFER" style="rounded=1;whiteSpace=wrap;html=1;" vertex="1" parent="1">
+          <mxGeometry x="340" y="150" width="120" height="60" as="geometry" />
+        </mxCell>
+        <mxCell id="t-EcJqArzlBj0utZR-UU-4" value="CONTRACT" style="rounded=1;whiteSpace=wrap;html=1;" vertex="1" parent="1">
+          <mxGeometry x="540" y="150" width="120" height="60" as="geometry" />
+        </mxCell>
+        <mxCell id="t-EcJqArzlBj0utZR-UU-6" value="" style="endArrow=none;dashed=1;html=1;rounded=0;entryX=0.317;entryY=0.9;entryDx=0;entryDy=0;entryPerimeter=0;" edge="1" parent="1" target="t-EcJqArzlBj0utZR-UU-22">
+          <mxGeometry width="50" height="50" relative="1" as="geometry">
+            <mxPoint x="80" y="950" as="sourcePoint" />
+            <mxPoint x="80" y="450" as="targetPoint" />
+          </mxGeometry>
+        </mxCell>
+        <mxCell id="t-EcJqArzlBj0utZR-UU-7" value="" style="endArrow=none;dashed=1;html=1;rounded=0;" edge="1" parent="1">
+          <mxGeometry width="50" height="50" relative="1" as="geometry">
+            <mxPoint x="200" y="960" as="sourcePoint" />
+            <mxPoint x="200" y="240" as="targetPoint" />
+          </mxGeometry>
+        </mxCell>
+        <mxCell id="t-EcJqArzlBj0utZR-UU-8" value="" style="endArrow=none;dashed=1;html=1;rounded=0;" edge="1" parent="1">
+          <mxGeometry width="50" height="50" relative="1" as="geometry">
+            <mxPoint x="400" y="960" as="sourcePoint" />
+            <mxPoint x="400" y="240" as="targetPoint" />
+          </mxGeometry>
+        </mxCell>
+        <mxCell id="t-EcJqArzlBj0utZR-UU-9" value="" style="endArrow=none;dashed=1;html=1;rounded=0;" edge="1" parent="1">
+          <mxGeometry width="50" height="50" relative="1" as="geometry">
+            <mxPoint x="600" y="960" as="sourcePoint" />
+            <mxPoint x="600" y="240" as="targetPoint" />
+          </mxGeometry>
+        </mxCell>
+        <mxCell id="t-EcJqArzlBj0utZR-UU-10" value="" style="endArrow=classic;html=1;rounded=0;" edge="1" parent="1">
+          <mxGeometry width="50" height="50" relative="1" as="geometry">
+            <mxPoint x="80" y="300" as="sourcePoint" />
+            <mxPoint x="200" y="300" as="targetPoint" />
+          </mxGeometry>
+        </mxCell>
+        <mxCell id="t-EcJqArzlBj0utZR-UU-11" value="addOffer(data)" style="text;html=1;align=center;verticalAlign=middle;resizable=0;points=[];autosize=1;strokeColor=none;fillColor=none;" vertex="1" parent="1">
+          <mxGeometry x="90" y="270" width="100" height="30" as="geometry" />
+        </mxCell>
+        <mxCell id="t-EcJqArzlBj0utZR-UU-12" value="" style="endArrow=classic;html=1;rounded=0;" edge="1" parent="1">
+          <mxGeometry width="50" height="50" relative="1" as="geometry">
+            <mxPoint x="200" y="300" as="sourcePoint" />
+            <mxPoint x="400" y="300" as="targetPoint" />
+          </mxGeometry>
+        </mxCell>
+        <mxCell id="t-EcJqArzlBj0utZR-UU-14" value="addOffer(data)" style="text;html=1;align=center;verticalAlign=middle;resizable=0;points=[];autosize=1;strokeColor=none;fillColor=none;" vertex="1" parent="1">
+          <mxGeometry x="250" y="270" width="100" height="30" as="geometry" />
+        </mxCell>
+        <mxCell id="t-EcJqArzlBj0utZR-UU-16" value="" style="endArrow=none;dashed=1;html=1;rounded=0;startArrow=classic;startFill=1;" edge="1" parent="1">
+          <mxGeometry width="50" height="50" relative="1" as="geometry">
+            <mxPoint x="80" y="420" as="sourcePoint" />
+            <mxPoint x="200" y="420" as="targetPoint" />
+          </mxGeometry>
+        </mxCell>
+        <mxCell id="t-EcJqArzlBj0utZR-UU-22" value="alt" style="text;html=1;align=center;verticalAlign=middle;whiteSpace=wrap;rounded=0;" vertex="1" parent="1">
+          <mxGeometry x="60" y="240" width="60" height="30" as="geometry" />
+        </mxCell>
+        <mxCell id="t-EcJqArzlBj0utZR-UU-23" value="" style="endArrow=none;html=1;rounded=0;entryX=1;entryY=0;entryDx=0;entryDy=0;exitX=-0.001;exitY=0.132;exitDx=0;exitDy=0;exitPerimeter=0;" edge="1" parent="1" source="t-EcJqArzlBj0utZR-UU-21" target="t-EcJqArzlBj0utZR-UU-22">
+          <mxGeometry width="50" height="50" relative="1" as="geometry">
+            <mxPoint x="90" y="270" as="sourcePoint" />
+            <mxPoint x="300" y="330" as="targetPoint" />
+            <Array as="points">
+              <mxPoint x="120" y="268" />
+            </Array>
+          </mxGeometry>
+        </mxCell>
+        <mxCell id="t-EcJqArzlBj0utZR-UU-25" value="" style="endArrow=none;dashed=1;html=1;rounded=0;entryX=-0.004;entryY=0.475;entryDx=0;entryDy=0;entryPerimeter=0;exitX=0.995;exitY=0.478;exitDx=0;exitDy=0;exitPerimeter=0;dashPattern=8 8;strokeWidth=2;" edge="1" parent="1" source="t-EcJqArzlBj0utZR-UU-21" target="t-EcJqArzlBj0utZR-UU-21">
+          <mxGeometry width="50" height="50" relative="1" as="geometry">
+            <mxPoint x="600" y="380.0033333333333" as="sourcePoint" />
+            <mxPoint x="480" y="446.67" as="targetPoint" />
+          </mxGeometry>
+        </mxCell>
+        <mxCell id="t-EcJqArzlBj0utZR-UU-26" value="" style="endArrow=classic;html=1;rounded=0;" edge="1" parent="1">
+          <mxGeometry width="50" height="50" relative="1" as="geometry">
+            <mxPoint x="80" y="390" as="sourcePoint" />
+            <mxPoint x="200" y="390" as="targetPoint" />
+          </mxGeometry>
+        </mxCell>
+        <mxCell id="t-EcJqArzlBj0utZR-UU-27" value="addOffer(data)" style="text;html=1;align=center;verticalAlign=middle;resizable=0;points=[];autosize=1;strokeColor=none;fillColor=none;" vertex="1" parent="1">
+          <mxGeometry x="90" y="360" width="100" height="30" as="geometry" />
+        </mxCell>
+        <mxCell id="t-EcJqArzlBj0utZR-UU-28" value="wrongData" style="text;html=1;align=center;verticalAlign=middle;resizable=0;points=[];autosize=1;strokeColor=none;fillColor=none;" vertex="1" parent="1">
+          <mxGeometry x="100" y="390" width="80" height="30" as="geometry" />
+        </mxCell>
+        <mxCell id="t-EcJqArzlBj0utZR-UU-29" value="" style="endArrow=none;dashed=1;html=1;rounded=0;startArrow=classic;startFill=1;" edge="1" parent="1">
+          <mxGeometry width="50" height="50" relative="1" as="geometry">
+            <mxPoint x="80" y="330" as="sourcePoint" />
+            <mxPoint x="400" y="330" as="targetPoint" />
+          </mxGeometry>
+        </mxCell>
+        <mxCell id="t-EcJqArzlBj0utZR-UU-31" value="offerAdded" style="text;html=1;align=center;verticalAlign=middle;whiteSpace=wrap;rounded=0;" vertex="1" parent="1">
+          <mxGeometry x="220" y="300" width="60" height="30" as="geometry" />
+        </mxCell>
+        <mxCell id="t-EcJqArzlBj0utZR-UU-32" value="" style="endArrow=classic;html=1;rounded=0;" edge="1" parent="1">
+          <mxGeometry width="50" height="50" relative="1" as="geometry">
+            <mxPoint x="80" y="540" as="sourcePoint" />
+            <mxPoint x="200" y="540" as="targetPoint" />
+          </mxGeometry>
+        </mxCell>
+        <mxCell id="t-EcJqArzlBj0utZR-UU-33" value="addContract(data)" style="text;html=1;align=center;verticalAlign=middle;resizable=0;points=[];autosize=1;strokeColor=none;fillColor=none;" vertex="1" parent="1">
+          <mxGeometry x="80" y="510" width="120" height="30" as="geometry" />
+        </mxCell>
+        <mxCell id="t-EcJqArzlBj0utZR-UU-34" value="" style="endArrow=classic;html=1;rounded=0;exitX=0.982;exitY=0.986;exitDx=0;exitDy=0;exitPerimeter=0;" edge="1" parent="1" source="t-EcJqArzlBj0utZR-UU-33">
+          <mxGeometry width="50" height="50" relative="1" as="geometry">
+            <mxPoint x="250" y="380" as="sourcePoint" />
+            <mxPoint x="400" y="540" as="targetPoint" />
+          </mxGeometry>
+        </mxCell>
+        <mxCell id="t-EcJqArzlBj0utZR-UU-35" value="addOffer(data)" style="text;html=1;align=center;verticalAlign=middle;whiteSpace=wrap;rounded=0;" vertex="1" parent="1">
+          <mxGeometry x="250" y="510" width="60" height="30" as="geometry" />
+        </mxCell>
+        <mxCell id="t-EcJqArzlBj0utZR-UU-36" value="" style="endArrow=none;dashed=1;html=1;rounded=0;startArrow=classic;startFill=1;" edge="1" parent="1">
+          <mxGeometry width="50" height="50" relative="1" as="geometry">
+            <mxPoint x="200" y="580" as="sourcePoint" />
+            <mxPoint x="400" y="580" as="targetPoint" />
+          </mxGeometry>
+        </mxCell>
+        <mxCell id="t-EcJqArzlBj0utZR-UU-37" value="offer(data)" style="text;html=1;align=center;verticalAlign=middle;whiteSpace=wrap;rounded=0;" vertex="1" parent="1">
+          <mxGeometry x="260" y="550" width="60" height="30" as="geometry" />
+        </mxCell>
+        <mxCell id="t-EcJqArzlBj0utZR-UU-38" value="" style="endArrow=classic;html=1;rounded=0;" edge="1" parent="1">
+          <mxGeometry width="50" height="50" relative="1" as="geometry">
+            <mxPoint x="200" y="610" as="sourcePoint" />
+            <mxPoint x="600" y="610" as="targetPoint" />
+          </mxGeometry>
+        </mxCell>
+        <mxCell id="t-EcJqArzlBj0utZR-UU-40" value="addContract(data)" style="text;html=1;align=center;verticalAlign=middle;whiteSpace=wrap;rounded=0;" vertex="1" parent="1">
+          <mxGeometry x="360" y="580" width="190" height="30" as="geometry" />
+        </mxCell>
+        <mxCell id="t-EcJqArzlBj0utZR-UU-41" value="" style="endArrow=none;dashed=1;html=1;rounded=0;startArrow=classic;startFill=1;" edge="1" parent="1">
+          <mxGeometry width="50" height="50" relative="1" as="geometry">
+            <mxPoint x="80" y="650" as="sourcePoint" />
+            <mxPoint x="600" y="650" as="targetPoint" />
+          </mxGeometry>
+        </mxCell>
+        <mxCell id="t-EcJqArzlBj0utZR-UU-42" value="contractAdded()" style="text;html=1;align=center;verticalAlign=middle;whiteSpace=wrap;rounded=0;" vertex="1" parent="1">
+          <mxGeometry x="290" y="620" width="60" height="30" as="geometry" />
+        </mxCell>
+        <mxCell id="t-EcJqArzlBj0utZR-UU-44" value="" style="endArrow=classic;html=1;rounded=0;" edge="1" parent="1">
+          <mxGeometry width="50" height="50" relative="1" as="geometry">
+            <mxPoint x="80" y="720" as="sourcePoint" />
+            <mxPoint x="200" y="720" as="targetPoint" />
+          </mxGeometry>
+        </mxCell>
+        <mxCell id="t-EcJqArzlBj0utZR-UU-45" value="offerAccept(data)" style="text;html=1;align=center;verticalAlign=middle;resizable=0;points=[];autosize=1;strokeColor=none;fillColor=none;" vertex="1" parent="1">
+          <mxGeometry x="80" y="690" width="120" height="30" as="geometry" />
+        </mxCell>
+        <mxCell id="t-EcJqArzlBj0utZR-UU-46" value="" style="endArrow=classic;html=1;rounded=0;" edge="1" parent="1">
+          <mxGeometry width="50" height="50" relative="1" as="geometry">
+            <mxPoint x="200" y="720" as="sourcePoint" />
+            <mxPoint x="600" y="720" as="targetPoint" />
+          </mxGeometry>
+        </mxCell>
+        <mxCell id="t-EcJqArzlBj0utZR-UU-47" value="addContract(data)" style="text;html=1;align=center;verticalAlign=middle;whiteSpace=wrap;rounded=0;" vertex="1" parent="1">
+          <mxGeometry x="280" y="690" width="60" height="30" as="geometry" />
+        </mxCell>
+        <mxCell id="t-EcJqArzlBj0utZR-UU-49" value="" style="endArrow=none;dashed=1;html=1;rounded=0;startArrow=classic;startFill=1;" edge="1" parent="1">
+          <mxGeometry width="50" height="50" relative="1" as="geometry">
+            <mxPoint x="80" y="770" as="sourcePoint" />
+            <mxPoint x="600" y="770" as="targetPoint" />
+          </mxGeometry>
+        </mxCell>
+        <mxCell id="t-EcJqArzlBj0utZR-UU-50" value="contractAdded()" style="text;html=1;align=center;verticalAlign=middle;whiteSpace=wrap;rounded=0;" vertex="1" parent="1">
+          <mxGeometry x="290" y="740" width="60" height="30" as="geometry" />
+        </mxCell>
+      </root>
+    </mxGraphModel>
+  </diagram>
+</mxfile>
--- a/doc/datenbank.drawio
+++ b/doc/datenbank.drawio
@@ -1,6 +1,6 @@
 <mxfile host="Electron" agent="Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) draw.io/25.0.2 Chrome/128.0.6613.186 Electron/32.2.5 Safari/537.36" version="25.0.2">
  <diagram name="Seite-1" id="krh1Wum05D0y0HCIq7V8">
-    <mxGraphModel dx="3267" dy="1406" grid="1" gridSize="10" guides="1" tooltips="1" connect="1" arrows="1" fold="1" page="1" pageScale="1" pageWidth="827" pageHeight="1169" math="0" shadow="0">
+    <mxGraphModel dx="2555" dy="996" grid="1" gridSize="10" guides="1" tooltips="1" connect="1" arrows="1" fold="1" page="1" pageScale="1" pageWidth="827" pageHeight="1169" math="0" shadow="0">
      <root>
        <mxCell id="0" />
        <mxCell id="1" parent="0" />
@@ -78,35 +78,6 @@
        <mxCell id="Ya_982ONw7_15APAzA8q-34" value="1" style="resizable=0;html=1;whiteSpace=wrap;align=right;verticalAlign=bottom;" parent="1" connectable="0" vertex="1">
          <mxGeometry x="535" y="180.00000000000006" as="geometry" />
        </mxCell>
-        <mxCell id="Ya_982ONw7_15APAzA8q-81" value="servicedesc" style="shape=table;startSize=30;container=1;collapsible=1;childLayout=tableLayout;fixedRows=1;rowLines=0;fontStyle=1;align=center;resizeLast=1;html=1;" parent="1" vertex="1">
-          <mxGeometry x="1410" y="249" width="180" height="90" as="geometry" />
-        </mxCell>
-        <mxCell id="Ya_982ONw7_15APAzA8q-82" value="" style="shape=tableRow;horizontal=0;startSize=0;swimlaneHead=0;swimlaneBody=0;fillColor=none;collapsible=0;dropTarget=0;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;top=0;left=0;right=0;bottom=1;" parent="Ya_982ONw7_15APAzA8q-81" vertex="1">
-          <mxGeometry y="30" width="180" height="30" as="geometry" />
-        </mxCell>
-        <mxCell id="Ya_982ONw7_15APAzA8q-83" value="PK" style="shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;fontStyle=1;overflow=hidden;whiteSpace=wrap;html=1;" parent="Ya_982ONw7_15APAzA8q-82" vertex="1">
-          <mxGeometry width="30" height="30" as="geometry">
-            <mxRectangle width="30" height="30" as="alternateBounds" />
-          </mxGeometry>
-        </mxCell>
-        <mxCell id="Ya_982ONw7_15APAzA8q-84" value="servicedescid" style="shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;align=left;spacingLeft=6;fontStyle=5;overflow=hidden;whiteSpace=wrap;html=1;" parent="Ya_982ONw7_15APAzA8q-82" vertex="1">
-          <mxGeometry x="30" width="150" height="30" as="geometry">
-            <mxRectangle width="150" height="30" as="alternateBounds" />
-          </mxGeometry>
-        </mxCell>
-        <mxCell id="Ya_982ONw7_15APAzA8q-85" value="" style="shape=tableRow;horizontal=0;startSize=0;swimlaneHead=0;swimlaneBody=0;fillColor=none;collapsible=0;dropTarget=0;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;top=0;left=0;right=0;bottom=0;" parent="Ya_982ONw7_15APAzA8q-81" vertex="1">
-          <mxGeometry y="60" width="180" height="30" as="geometry" />
-        </mxCell>
-        <mxCell id="Ya_982ONw7_15APAzA8q-86" value="" style="shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;editable=1;overflow=hidden;whiteSpace=wrap;html=1;" parent="Ya_982ONw7_15APAzA8q-85" vertex="1">
-          <mxGeometry width="30" height="30" as="geometry">
-            <mxRectangle width="30" height="30" as="alternateBounds" />
-          </mxGeometry>
-        </mxCell>
-        <mxCell id="Ya_982ONw7_15APAzA8q-87" value="description" style="shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;align=left;spacingLeft=6;overflow=hidden;whiteSpace=wrap;html=1;" parent="Ya_982ONw7_15APAzA8q-85" vertex="1">
-          <mxGeometry x="30" width="150" height="30" as="geometry">
-            <mxRectangle width="150" height="30" as="alternateBounds" />
-          </mxGeometry>
-        </mxCell>
        <mxCell id="Ya_982ONw7_15APAzA8q-105" value="" style="endArrow=none;html=1;rounded=0;exitX=1;exitY=1;exitDx=0;exitDy=0;entryX=0;entryY=0.5;entryDx=0;entryDy=0;" parent="1" source="wp44KSVxnTE4gDC1YKSh-240" edge="1">
          <mxGeometry width="50" height="50" relative="1" as="geometry">
            <mxPoint x="560" y="163" as="sourcePoint" />
@@ -147,7 +118,7 @@
          </mxGeometry>
        </mxCell>
        <mxCell id="Ya_982ONw7_15APAzA8q-176" value="offer" style="shape=table;startSize=30;container=1;collapsible=1;childLayout=tableLayout;fixedRows=1;rowLines=0;fontStyle=1;align=center;resizeLast=1;html=1;" parent="1" vertex="1">
-          <mxGeometry x="900" y="880" width="180" height="120" as="geometry" />
+          <mxGeometry x="900" y="880" width="180" height="90" as="geometry" />
        </mxCell>
        <mxCell id="Ya_982ONw7_15APAzA8q-177" value="" style="shape=tableRow;horizontal=0;startSize=0;swimlaneHead=0;swimlaneBody=0;fillColor=none;collapsible=0;dropTarget=0;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;top=0;left=0;right=0;bottom=1;" parent="Ya_982ONw7_15APAzA8q-176" vertex="1">
          <mxGeometry y="30" width="180" height="30" as="geometry" />
@@ -162,76 +133,26 @@
            <mxRectangle width="150" height="30" as="alternateBounds" />
          </mxGeometry>
        </mxCell>
-        <mxCell id="Ya_982ONw7_15APAzA8q-180" value="" style="shape=tableRow;horizontal=0;startSize=0;swimlaneHead=0;swimlaneBody=0;fillColor=none;collapsible=0;dropTarget=0;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;top=0;left=0;right=0;bottom=0;" parent="Ya_982ONw7_15APAzA8q-176" vertex="1">
-          <mxGeometry y="60" width="180" height="30" as="geometry" />
-        </mxCell>
-        <mxCell id="Ya_982ONw7_15APAzA8q-181" value="FK" style="shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;editable=1;overflow=hidden;whiteSpace=wrap;html=1;" parent="Ya_982ONw7_15APAzA8q-180" vertex="1">
-          <mxGeometry width="30" height="30" as="geometry">
-            <mxRectangle width="30" height="30" as="alternateBounds" />
-          </mxGeometry>
-        </mxCell>
-        <mxCell id="Ya_982ONw7_15APAzA8q-182" value="jobdetailid" style="shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;align=left;spacingLeft=6;overflow=hidden;whiteSpace=wrap;html=1;" parent="Ya_982ONw7_15APAzA8q-180" vertex="1">
-          <mxGeometry x="30" width="150" height="30" as="geometry">
-            <mxRectangle width="150" height="30" as="alternateBounds" />
-          </mxGeometry>
-        </mxCell>
-        <mxCell id="Ya_982ONw7_15APAzA8q-205" value="offers" style="shape=table;startSize=30;container=1;collapsible=1;childLayout=tableLayout;fixedRows=1;rowLines=0;fontStyle=1;align=center;resizeLast=1;html=1;" parent="1" vertex="1">
-          <mxGeometry x="900" y="720" width="180" height="120" as="geometry" />
-        </mxCell>
-        <mxCell id="Ya_982ONw7_15APAzA8q-206" value="" style="shape=tableRow;horizontal=0;startSize=0;swimlaneHead=0;swimlaneBody=0;fillColor=none;collapsible=0;dropTarget=0;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;top=0;left=0;right=0;bottom=1;" parent="Ya_982ONw7_15APAzA8q-205" vertex="1">
-          <mxGeometry y="30" width="180" height="30" as="geometry" />
-        </mxCell>
-        <mxCell id="Ya_982ONw7_15APAzA8q-207" value="" style="shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;fontStyle=1;overflow=hidden;whiteSpace=wrap;html=1;" parent="Ya_982ONw7_15APAzA8q-206" vertex="1">
-          <mxGeometry width="30" height="30" as="geometry">
-            <mxRectangle width="30" height="30" as="alternateBounds" />
-          </mxGeometry>
-        </mxCell>
-        <mxCell id="Ya_982ONw7_15APAzA8q-208" value="" style="shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;align=left;spacingLeft=6;fontStyle=5;overflow=hidden;whiteSpace=wrap;html=1;" parent="Ya_982ONw7_15APAzA8q-206" vertex="1">
-          <mxGeometry x="30" width="150" height="30" as="geometry">
-            <mxRectangle width="150" height="30" as="alternateBounds" />
-          </mxGeometry>
-        </mxCell>
-        <mxCell id="Ya_982ONw7_15APAzA8q-209" value="" style="shape=tableRow;horizontal=0;startSize=0;swimlaneHead=0;swimlaneBody=0;fillColor=none;collapsible=0;dropTarget=0;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;top=0;left=0;right=0;bottom=0;" parent="Ya_982ONw7_15APAzA8q-205" vertex="1">
-          <mxGeometry y="60" width="180" height="30" as="geometry" />
-        </mxCell>
-        <mxCell id="Ya_982ONw7_15APAzA8q-210" value="FK" style="shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;editable=1;overflow=hidden;whiteSpace=wrap;html=1;" parent="Ya_982ONw7_15APAzA8q-209" vertex="1">
-          <mxGeometry width="30" height="30" as="geometry">
-            <mxRectangle width="30" height="30" as="alternateBounds" />
-          </mxGeometry>
-        </mxCell>
-        <mxCell id="Ya_982ONw7_15APAzA8q-211" value="offerid" style="shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;align=left;spacingLeft=6;overflow=hidden;whiteSpace=wrap;html=1;" parent="Ya_982ONw7_15APAzA8q-209" vertex="1">
-          <mxGeometry x="30" width="150" height="30" as="geometry">
-            <mxRectangle width="150" height="30" as="alternateBounds" />
-          </mxGeometry>
-        </mxCell>
-        <mxCell id="Ya_982ONw7_15APAzA8q-212" value="" style="shape=tableRow;horizontal=0;startSize=0;swimlaneHead=0;swimlaneBody=0;fillColor=none;collapsible=0;dropTarget=0;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;top=0;left=0;right=0;bottom=0;" parent="Ya_982ONw7_15APAzA8q-205" vertex="1">
-          <mxGeometry y="90" width="180" height="30" as="geometry" />
-        </mxCell>
-        <mxCell id="Ya_982ONw7_15APAzA8q-213" value="FK" style="shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;editable=1;overflow=hidden;whiteSpace=wrap;html=1;" parent="Ya_982ONw7_15APAzA8q-212" vertex="1">
-          <mxGeometry width="30" height="30" as="geometry">
-            <mxRectangle width="30" height="30" as="alternateBounds" />
-          </mxGeometry>
-        </mxCell>
-        <mxCell id="Ya_982ONw7_15APAzA8q-214" value="contractid" style="shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;align=left;spacingLeft=6;overflow=hidden;whiteSpace=wrap;html=1;" parent="Ya_982ONw7_15APAzA8q-212" vertex="1">
-          <mxGeometry x="30" width="150" height="30" as="geometry">
-            <mxRectangle width="150" height="30" as="alternateBounds" />
-          </mxGeometry>
-        </mxCell>
-        <mxCell id="Ya_982ONw7_15APAzA8q-220" value="" style="endArrow=none;html=1;rounded=0;entryX=1;entryY=0.5;entryDx=0;entryDy=0;exitX=0;exitY=1;exitDx=0;exitDy=0;exitPerimeter=0;" parent="1" target="Ya_982ONw7_15APAzA8q-209" edge="1">
+        <mxCell id="Ya_982ONw7_15APAzA8q-220" value="" style="endArrow=none;html=1;rounded=0;entryX=1;entryY=0.5;entryDx=0;entryDy=0;exitX=0;exitY=1;exitDx=0;exitDy=0;exitPerimeter=0;" parent="1" target="BsNFRahTXGiPdYppKmQY-26" edge="1">
          <mxGeometry width="50" height="50" relative="1" as="geometry">
            <mxPoint x="1150.9999999999995" y="669.9999999999998" as="sourcePoint" />
-            <mxPoint x="1004.9100000000002" y="790" as="targetPoint" />
+            <mxPoint x="1080" y="725" as="targetPoint" />
            <Array as="points">
              <mxPoint x="1150" y="725" />
              <mxPoint x="1110" y="725" />
-              <mxPoint x="1110" y="795" />
+              <mxPoint x="1110" y="781" />
            </Array>
          </mxGeometry>
        </mxCell>
-        <mxCell id="Ya_982ONw7_15APAzA8q-221" value="" style="endArrow=none;html=1;rounded=0;exitX=0.5;exitY=0;exitDx=0;exitDy=0;" parent="1" source="Ya_982ONw7_15APAzA8q-176" target="Ya_982ONw7_15APAzA8q-212" edge="1">
+        <mxCell id="Ya_982ONw7_15APAzA8q-221" value="" style="endArrow=none;html=1;rounded=0;exitX=0;exitY=0.5;exitDx=0;exitDy=0;entryX=0;entryY=0.5;entryDx=0;entryDy=0;" parent="1" source="Ya_982ONw7_15APAzA8q-177" target="BsNFRahTXGiPdYppKmQY-23" edge="1">
          <mxGeometry width="50" height="50" relative="1" as="geometry">
            <mxPoint x="1000" y="860" as="sourcePoint" />
-            <mxPoint x="1080" y="840" as="targetPoint" />
+            <mxPoint x="990" y="820" as="targetPoint" />
+            <Array as="points">
+              <mxPoint x="870" y="925" />
+              <mxPoint x="870" y="840" />
+              <mxPoint x="870" y="751" />
+            </Array>
          </mxGeometry>
        </mxCell>
        <mxCell id="Ya_982ONw7_15APAzA8q-256" value="" style="shape=tableRow;horizontal=0;startSize=0;swimlaneHead=0;swimlaneBody=0;fillColor=none;collapsible=0;dropTarget=0;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;top=0;left=0;right=0;bottom=0;" parent="1" vertex="1">
@@ -353,18 +274,10 @@
            <mxPoint x="15" y="41" as="offset" />
          </mxGeometry>
        </mxCell>
-        <mxCell id="Ya_982ONw7_15APAzA8q-276" value="1" style="resizable=0;html=1;whiteSpace=wrap;align=right;verticalAlign=bottom;" parent="1" connectable="0" vertex="1">
-          <mxGeometry x="1331" y="815" as="geometry">
-            <mxPoint x="12" y="-46" as="offset" />
-          </mxGeometry>
-        </mxCell>
-        <mxCell id="Ya_982ONw7_15APAzA8q-277" value="1" style="resizable=0;html=1;whiteSpace=wrap;align=right;verticalAlign=bottom;" parent="1" connectable="0" vertex="1">
-          <mxGeometry x="1410" y="765" as="geometry" />
-        </mxCell>
        <mxCell id="Ya_982ONw7_15APAzA8q-278" value="" style="endArrow=none;html=1;rounded=0;exitX=0;exitY=0.5;exitDx=0;exitDy=0;" parent="1" source="Ya_982ONw7_15APAzA8q-245" edge="1">
          <mxGeometry width="50" height="50" relative="1" as="geometry">
            <mxPoint x="1150" y="960" as="sourcePoint" />
-            <mxPoint x="1240" y="760" as="targetPoint" />
+            <mxPoint x="1240" y="730" as="targetPoint" />
            <Array as="points">
              <mxPoint x="1130" y="955" />
              <mxPoint x="1130" y="810" />
@@ -372,9 +285,6 @@
            </Array>
          </mxGeometry>
        </mxCell>
-        <mxCell id="Ya_982ONw7_15APAzA8q-279" value="1" style="resizable=0;html=1;whiteSpace=wrap;align=right;verticalAlign=bottom;" parent="1" connectable="0" vertex="1">
-          <mxGeometry x="1240" y="780" as="geometry" />
-        </mxCell>
        <mxCell id="Ya_982ONw7_15APAzA8q-280" value="N" style="resizable=0;html=1;whiteSpace=wrap;align=right;verticalAlign=bottom;" parent="1" connectable="0" vertex="1">
          <mxGeometry x="1130" y="940" as="geometry">
            <mxPoint x="15" y="41" as="offset" />
@@ -582,7 +492,7 @@
          </mxGeometry>
        </mxCell>
        <mxCell id="RGG-I-Th0KsJHSMTwLBq-57" value="service" style="shape=table;startSize=30;container=1;collapsible=1;childLayout=tableLayout;fixedRows=1;rowLines=0;fontStyle=1;align=center;resizeLast=1;html=1;" parent="1" vertex="1">
-          <mxGeometry x="1400" y="50" width="180" height="150" as="geometry" />
+          <mxGeometry x="1400" y="50" width="180" height="120" as="geometry" />
        </mxCell>
        <mxCell id="RGG-I-Th0KsJHSMTwLBq-58" value="" style="shape=tableRow;horizontal=0;startSize=0;swimlaneHead=0;swimlaneBody=0;fillColor=none;collapsible=0;dropTarget=0;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;top=0;left=0;right=0;bottom=1;" parent="RGG-I-Th0KsJHSMTwLBq-57" vertex="1">
          <mxGeometry y="30" width="180" height="30" as="geometry" />
@@ -597,23 +507,10 @@
            <mxRectangle width="150" height="30" as="alternateBounds" />
          </mxGeometry>
        </mxCell>
-        <mxCell id="RGG-I-Th0KsJHSMTwLBq-61" value="" style="shape=tableRow;horizontal=0;startSize=0;swimlaneHead=0;swimlaneBody=0;fillColor=none;collapsible=0;dropTarget=0;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;top=0;left=0;right=0;bottom=0;" parent="RGG-I-Th0KsJHSMTwLBq-57" vertex="1">
+        <mxCell id="RGG-I-Th0KsJHSMTwLBq-64" value="" style="shape=tableRow;horizontal=0;startSize=0;swimlaneHead=0;swimlaneBody=0;fillColor=none;collapsible=0;dropTarget=0;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;top=0;left=0;right=0;bottom=0;" parent="RGG-I-Th0KsJHSMTwLBq-57" vertex="1">
          <mxGeometry y="60" width="180" height="30" as="geometry" />
        </mxCell>
-        <mxCell id="RGG-I-Th0KsJHSMTwLBq-62" value="" style="shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;editable=1;overflow=hidden;whiteSpace=wrap;html=1;" parent="RGG-I-Th0KsJHSMTwLBq-61" vertex="1">
-          <mxGeometry width="30" height="30" as="geometry">
-            <mxRectangle width="30" height="30" as="alternateBounds" />
-          </mxGeometry>
-        </mxCell>
-        <mxCell id="RGG-I-Th0KsJHSMTwLBq-63" value="servicetypeid" style="shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;align=left;spacingLeft=6;overflow=hidden;whiteSpace=wrap;html=1;" parent="RGG-I-Th0KsJHSMTwLBq-61" vertex="1">
-          <mxGeometry x="30" width="150" height="30" as="geometry">
-            <mxRectangle width="150" height="30" as="alternateBounds" />
-          </mxGeometry>
-        </mxCell>
-        <mxCell id="RGG-I-Th0KsJHSMTwLBq-64" value="" style="shape=tableRow;horizontal=0;startSize=0;swimlaneHead=0;swimlaneBody=0;fillColor=none;collapsible=0;dropTarget=0;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;top=0;left=0;right=0;bottom=0;" parent="RGG-I-Th0KsJHSMTwLBq-57" vertex="1">
-          <mxGeometry y="90" width="180" height="30" as="geometry" />
-        </mxCell>
-        <mxCell id="RGG-I-Th0KsJHSMTwLBq-65" value="" style="shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;editable=1;overflow=hidden;whiteSpace=wrap;html=1;" parent="RGG-I-Th0KsJHSMTwLBq-64" vertex="1">
+        <mxCell id="RGG-I-Th0KsJHSMTwLBq-65" value="FK" style="shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;editable=1;overflow=hidden;whiteSpace=wrap;html=1;" parent="RGG-I-Th0KsJHSMTwLBq-64" vertex="1">
          <mxGeometry width="30" height="30" as="geometry">
            <mxRectangle width="30" height="30" as="alternateBounds" />
          </mxGeometry>
@@ -624,9 +521,9 @@
          </mxGeometry>
        </mxCell>
        <mxCell id="RGG-I-Th0KsJHSMTwLBq-67" value="" style="shape=tableRow;horizontal=0;startSize=0;swimlaneHead=0;swimlaneBody=0;fillColor=none;collapsible=0;dropTarget=0;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;top=0;left=0;right=0;bottom=0;" parent="RGG-I-Th0KsJHSMTwLBq-57" vertex="1">
-          <mxGeometry y="120" width="180" height="30" as="geometry" />
+          <mxGeometry y="90" width="180" height="30" as="geometry" />
        </mxCell>
-        <mxCell id="RGG-I-Th0KsJHSMTwLBq-68" value="" style="shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;editable=1;overflow=hidden;whiteSpace=wrap;html=1;" parent="RGG-I-Th0KsJHSMTwLBq-67" vertex="1">
+        <mxCell id="RGG-I-Th0KsJHSMTwLBq-68" value="FK" style="shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;editable=1;overflow=hidden;whiteSpace=wrap;html=1;" parent="RGG-I-Th0KsJHSMTwLBq-67" vertex="1">
          <mxGeometry width="30" height="30" as="geometry">
            <mxRectangle width="30" height="30" as="alternateBounds" />
          </mxGeometry>
@@ -636,19 +533,19 @@
            <mxRectangle width="150" height="30" as="alternateBounds" />
          </mxGeometry>
        </mxCell>
-        <mxCell id="RGG-I-Th0KsJHSMTwLBq-70" value="" style="endArrow=none;html=1;rounded=0;entryX=1;entryY=0.5;entryDx=0;entryDy=0;exitX=1;exitY=0.5;exitDx=0;exitDy=0;" parent="1" source="RGG-I-Th0KsJHSMTwLBq-61" target="Ya_982ONw7_15APAzA8q-69" edge="1">
+        <mxCell id="RGG-I-Th0KsJHSMTwLBq-70" value="" style="endArrow=none;html=1;rounded=0;entryX=1;entryY=0.5;entryDx=0;entryDy=0;exitX=1;exitY=0.5;exitDx=0;exitDy=0;" parent="1" source="BsNFRahTXGiPdYppKmQY-7" target="Ya_982ONw7_15APAzA8q-69" edge="1">
          <mxGeometry width="50" height="50" relative="1" as="geometry">
-            <mxPoint x="1340" y="150" as="sourcePoint" />
+            <mxPoint x="1580" y="125" as="sourcePoint" />
            <mxPoint x="1390" y="100" as="targetPoint" />
            <Array as="points">
-              <mxPoint x="1640" y="125" />
-              <mxPoint x="1640" y="433" />
+              <mxPoint x="1610" y="324" />
+              <mxPoint x="1610" y="433" />
            </Array>
          </mxGeometry>
        </mxCell>
-        <mxCell id="RGG-I-Th0KsJHSMTwLBq-71" value="" style="endArrow=none;html=1;rounded=0;exitX=1;exitY=0.5;exitDx=0;exitDy=0;entryX=1;entryY=0.5;entryDx=0;entryDy=0;" parent="1" source="Ya_982ONw7_15APAzA8q-82" target="RGG-I-Th0KsJHSMTwLBq-64" edge="1">
+        <mxCell id="RGG-I-Th0KsJHSMTwLBq-71" value="" style="endArrow=none;html=1;rounded=0;exitX=1;exitY=0.5;exitDx=0;exitDy=0;entryX=1;entryY=0.5;entryDx=0;entryDy=0;" parent="1" target="RGG-I-Th0KsJHSMTwLBq-67" edge="1">
          <mxGeometry width="50" height="50" relative="1" as="geometry">
-            <mxPoint x="1290" y="260" as="sourcePoint" />
+            <mxPoint x="1590" y="294" as="sourcePoint" />
            <mxPoint x="1340" y="210" as="targetPoint" />
            <Array as="points">
              <mxPoint x="1610" y="294" />
@@ -661,7 +558,7 @@
            <mxPoint x="1020" y="130" as="sourcePoint" />
            <mxPoint x="1308" y="84" as="targetPoint" />
            <Array as="points">
-              <mxPoint x="1360" y="185" />
+              <mxPoint x="1360" y="155" />
              <mxPoint x="1360" y="65" />
            </Array>
          </mxGeometry>
@@ -735,13 +632,13 @@
        <mxCell id="5CqAkLydmV_yxfNIBBfD-14" value="" style="shape=tableRow;horizontal=0;startSize=0;swimlaneHead=0;swimlaneBody=0;fillColor=none;collapsible=0;dropTarget=0;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;top=0;left=0;right=0;bottom=0;" parent="1" vertex="1">
          <mxGeometry x="1160" y="690" width="180" height="30" as="geometry" />
        </mxCell>
-        <mxCell id="5CqAkLydmV_yxfNIBBfD-17" value="" style="endArrow=none;html=1;rounded=0;entryX=1;entryY=0.5;entryDx=0;entryDy=0;exitX=1;exitY=0.5;exitDx=0;exitDy=0;" parent="1" source="5CqAkLydmV_yxfNIBBfD-2" edge="1">
+        <mxCell id="5CqAkLydmV_yxfNIBBfD-17" value="" style="endArrow=none;html=1;rounded=0;entryX=1;entryY=0.5;entryDx=0;entryDy=0;exitX=1;exitY=0.5;exitDx=0;exitDy=0;" parent="1" source="5CqAkLydmV_yxfNIBBfD-2" edge="1" target="HT5lYA2dYPyrPS9nyiQT-178">
          <mxGeometry width="50" height="50" relative="1" as="geometry">
            <mxPoint x="1190" y="820" as="sourcePoint" />
            <mxPoint x="1330.9999999999995" y="684.9999999999998" as="targetPoint" />
            <Array as="points">
              <mxPoint x="1360" y="433" />
-              <mxPoint x="1360" y="685" />
+              <mxPoint x="1360" y="625" />
            </Array>
          </mxGeometry>
        </mxCell>
@@ -1066,7 +963,7 @@
          </mxGeometry>
        </mxCell>
        <mxCell id="5CqAkLydmV_yxfNIBBfD-100" value="date" style="shape=partialRectangle;connectable=0;fillColor=none;top=0;left=1;bottom=0;right=0;align=left;spacingLeft=6;overflow=hidden;whiteSpace=wrap;html=1;" parent="1" vertex="1">
-          <mxGeometry x="930" y="970" width="150" height="30" as="geometry">
+          <mxGeometry x="930" y="940" width="150" height="30" as="geometry">
            <mxRectangle width="150" height="30" as="alternateBounds" />
          </mxGeometry>
        </mxCell>
@@ -1177,13 +1074,13 @@
            <mxRectangle width="150" height="30" as="alternateBounds" />
          </mxGeometry>
        </mxCell>
-        <mxCell id="-nb5psitBYwo0NIamKds-33" value="" style="endArrow=none;html=1;rounded=0;exitX=0;exitY=0.5;exitDx=0;exitDy=0;" parent="1" edge="1" source="Ya_982ONw7_15APAzA8q-260">
+        <mxCell id="-nb5psitBYwo0NIamKds-33" value="" style="endArrow=none;html=1;rounded=0;exitX=0;exitY=0.5;exitDx=0;exitDy=0;entryX=1;entryY=0.5;entryDx=0;entryDy=0;" parent="1" source="Ya_982ONw7_15APAzA8q-260" edge="1" target="HT5lYA2dYPyrPS9nyiQT-181">
          <mxGeometry width="50" height="50" relative="1" as="geometry">
            <mxPoint x="1420" y="740.0000000000001" as="sourcePoint" />
            <mxPoint x="1330" y="740" as="targetPoint" />
            <Array as="points">
-              <mxPoint x="1370" y="835" />
-              <mxPoint x="1370" y="740" />
+              <mxPoint x="1360" y="835" />
+              <mxPoint x="1360" y="655" />
            </Array>
          </mxGeometry>
        </mxCell>
@@ -1658,28 +1555,28 @@
            <mxRectangle width="150" height="30" as="alternateBounds" />
          </mxGeometry>
        </mxCell>
-        <mxCell id="7H4gm8Qbcmcg-KG3YoOF-27" value="" style="shape=tableRow;horizontal=0;startSize=0;swimlaneHead=0;swimlaneBody=0;fillColor=none;collapsible=0;dropTarget=0;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;top=0;left=0;right=0;bottom=0;" vertex="1" parent="AkoRetE9dPsFytqfa5Kx-27">
+        <mxCell id="7H4gm8Qbcmcg-KG3YoOF-27" value="" style="shape=tableRow;horizontal=0;startSize=0;swimlaneHead=0;swimlaneBody=0;fillColor=none;collapsible=0;dropTarget=0;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;top=0;left=0;right=0;bottom=0;" parent="AkoRetE9dPsFytqfa5Kx-27" vertex="1">
          <mxGeometry y="60" width="180" height="30" as="geometry" />
        </mxCell>
-        <mxCell id="7H4gm8Qbcmcg-KG3YoOF-28" value="" style="shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;editable=1;overflow=hidden;whiteSpace=wrap;html=1;" vertex="1" parent="7H4gm8Qbcmcg-KG3YoOF-27">
+        <mxCell id="7H4gm8Qbcmcg-KG3YoOF-28" value="" style="shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;editable=1;overflow=hidden;whiteSpace=wrap;html=1;" parent="7H4gm8Qbcmcg-KG3YoOF-27" vertex="1">
          <mxGeometry width="30" height="30" as="geometry">
            <mxRectangle width="30" height="30" as="alternateBounds" />
          </mxGeometry>
        </mxCell>
-        <mxCell id="7H4gm8Qbcmcg-KG3YoOF-29" value="addressid" style="shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;align=left;spacingLeft=6;overflow=hidden;whiteSpace=wrap;html=1;" vertex="1" parent="7H4gm8Qbcmcg-KG3YoOF-27">
+        <mxCell id="7H4gm8Qbcmcg-KG3YoOF-29" value="addressid" style="shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;align=left;spacingLeft=6;overflow=hidden;whiteSpace=wrap;html=1;" parent="7H4gm8Qbcmcg-KG3YoOF-27" vertex="1">
          <mxGeometry x="30" width="150" height="30" as="geometry">
            <mxRectangle width="150" height="30" as="alternateBounds" />
          </mxGeometry>
        </mxCell>
-        <mxCell id="7H4gm8Qbcmcg-KG3YoOF-21" value="" style="shape=tableRow;horizontal=0;startSize=0;swimlaneHead=0;swimlaneBody=0;fillColor=none;collapsible=0;dropTarget=0;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;top=0;left=0;right=0;bottom=0;" vertex="1" parent="AkoRetE9dPsFytqfa5Kx-27">
+        <mxCell id="7H4gm8Qbcmcg-KG3YoOF-21" value="" style="shape=tableRow;horizontal=0;startSize=0;swimlaneHead=0;swimlaneBody=0;fillColor=none;collapsible=0;dropTarget=0;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;top=0;left=0;right=0;bottom=0;" parent="AkoRetE9dPsFytqfa5Kx-27" vertex="1">
          <mxGeometry y="90" width="180" height="30" as="geometry" />
        </mxCell>
-        <mxCell id="7H4gm8Qbcmcg-KG3YoOF-22" value="" style="shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;editable=1;overflow=hidden;whiteSpace=wrap;html=1;" vertex="1" parent="7H4gm8Qbcmcg-KG3YoOF-21">
+        <mxCell id="7H4gm8Qbcmcg-KG3YoOF-22" value="" style="shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;editable=1;overflow=hidden;whiteSpace=wrap;html=1;" parent="7H4gm8Qbcmcg-KG3YoOF-21" vertex="1">
          <mxGeometry width="30" height="30" as="geometry">
            <mxRectangle width="30" height="30" as="alternateBounds" />
          </mxGeometry>
        </mxCell>
-        <mxCell id="7H4gm8Qbcmcg-KG3YoOF-23" value="houseid" style="shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;align=left;spacingLeft=6;overflow=hidden;whiteSpace=wrap;html=1;" vertex="1" parent="7H4gm8Qbcmcg-KG3YoOF-21">
+        <mxCell id="7H4gm8Qbcmcg-KG3YoOF-23" value="houseid" style="shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;align=left;spacingLeft=6;overflow=hidden;whiteSpace=wrap;html=1;" parent="7H4gm8Qbcmcg-KG3YoOF-21" vertex="1">
          <mxGeometry x="30" width="150" height="30" as="geometry">
            <mxRectangle width="150" height="30" as="alternateBounds" />
          </mxGeometry>
@@ -1697,7 +1594,7 @@
            <mxRectangle width="150" height="30" as="alternateBounds" />
          </mxGeometry>
        </mxCell>
-        <mxCell id="AkoRetE9dPsFytqfa5Kx-45" value="" style="endArrow=none;html=1;rounded=0;exitX=-0.002;exitY=0.678;exitDx=0;exitDy=0;exitPerimeter=0;" parent="1" edge="1" source="HT5lYA2dYPyrPS9nyiQT-315">
+        <mxCell id="AkoRetE9dPsFytqfa5Kx-45" value="" style="endArrow=none;html=1;rounded=0;exitX=-0.002;exitY=0.678;exitDx=0;exitDy=0;exitPerimeter=0;" parent="1" source="HT5lYA2dYPyrPS9nyiQT-315" edge="1">
          <mxGeometry width="50" height="50" relative="1" as="geometry">
            <mxPoint x="600" y="710" as="sourcePoint" />
            <mxPoint x="480" y="510" as="targetPoint" />
@@ -2215,7 +2112,7 @@
          <mxGeometry x="1151" y="550" width="180" height="210" as="geometry" />
        </mxCell>
        <mxCell id="HT5lYA2dYPyrPS9nyiQT-171" value="contract" style="shape=table;startSize=30;container=1;collapsible=1;childLayout=tableLayout;fixedRows=1;rowLines=0;fontStyle=1;align=center;resizeLast=1;html=1;" parent="HT5lYA2dYPyrPS9nyiQT-190" vertex="1">
-          <mxGeometry width="180" height="210" as="geometry" />
+          <mxGeometry width="180" height="180" as="geometry" />
        </mxCell>
        <mxCell id="HT5lYA2dYPyrPS9nyiQT-172" value="" style="shape=tableRow;horizontal=0;startSize=0;swimlaneHead=0;swimlaneBody=0;fillColor=none;collapsible=0;dropTarget=0;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;top=0;left=0;right=0;bottom=1;" parent="HT5lYA2dYPyrPS9nyiQT-171" vertex="1">
          <mxGeometry y="30" width="180" height="30" as="geometry" />
@@ -2230,21 +2127,8 @@
            <mxRectangle width="150" height="30" as="alternateBounds" />
          </mxGeometry>
        </mxCell>
-        <mxCell id="HT5lYA2dYPyrPS9nyiQT-175" value="" style="shape=tableRow;horizontal=0;startSize=0;swimlaneHead=0;swimlaneBody=0;fillColor=none;collapsible=0;dropTarget=0;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;top=0;left=0;right=0;bottom=0;" parent="HT5lYA2dYPyrPS9nyiQT-171" vertex="1">
-          <mxGeometry y="60" width="180" height="30" as="geometry" />
-        </mxCell>
-        <mxCell id="HT5lYA2dYPyrPS9nyiQT-176" value="FK" style="shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;editable=1;overflow=hidden;whiteSpace=wrap;html=1;" parent="HT5lYA2dYPyrPS9nyiQT-175" vertex="1">
-          <mxGeometry width="30" height="30" as="geometry">
-            <mxRectangle width="30" height="30" as="alternateBounds" />
-          </mxGeometry>
-        </mxCell>
-        <mxCell id="HT5lYA2dYPyrPS9nyiQT-177" value="jobdetailid" style="shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;align=left;spacingLeft=6;overflow=hidden;whiteSpace=wrap;html=1;" parent="HT5lYA2dYPyrPS9nyiQT-175" vertex="1">
-          <mxGeometry x="30" width="150" height="30" as="geometry">
-            <mxRectangle width="150" height="30" as="alternateBounds" />
-          </mxGeometry>
-        </mxCell>
        <mxCell id="HT5lYA2dYPyrPS9nyiQT-178" value="" style="shape=tableRow;horizontal=0;startSize=0;swimlaneHead=0;swimlaneBody=0;fillColor=none;collapsible=0;dropTarget=0;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;top=0;left=0;right=0;bottom=0;" parent="HT5lYA2dYPyrPS9nyiQT-171" vertex="1">
-          <mxGeometry y="90" width="180" height="30" as="geometry" />
+          <mxGeometry y="60" width="180" height="30" as="geometry" />
        </mxCell>
        <mxCell id="HT5lYA2dYPyrPS9nyiQT-179" value="" style="shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;editable=1;overflow=hidden;whiteSpace=wrap;html=1;" parent="HT5lYA2dYPyrPS9nyiQT-178" vertex="1">
          <mxGeometry width="30" height="30" as="geometry">
@@ -2257,7 +2141,7 @@
          </mxGeometry>
        </mxCell>
        <mxCell id="HT5lYA2dYPyrPS9nyiQT-181" value="" style="shape=tableRow;horizontal=0;startSize=0;swimlaneHead=0;swimlaneBody=0;fillColor=none;collapsible=0;dropTarget=0;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;top=0;left=0;right=0;bottom=0;" parent="HT5lYA2dYPyrPS9nyiQT-171" vertex="1">
-          <mxGeometry y="120" width="180" height="30" as="geometry" />
+          <mxGeometry y="90" width="180" height="30" as="geometry" />
        </mxCell>
        <mxCell id="HT5lYA2dYPyrPS9nyiQT-182" value="FK" style="shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;editable=1;overflow=hidden;whiteSpace=wrap;html=1;" parent="HT5lYA2dYPyrPS9nyiQT-181" vertex="1">
          <mxGeometry width="30" height="30" as="geometry">
@@ -2277,11 +2161,6 @@
            <mxRectangle width="30" height="30" as="alternateBounds" />
          </mxGeometry>
        </mxCell>
-        <mxCell id="HT5lYA2dYPyrPS9nyiQT-186" value="startdate" style="shape=partialRectangle;connectable=0;fillColor=none;top=0;left=1;bottom=0;right=0;align=left;spacingLeft=6;overflow=hidden;whiteSpace=wrap;html=1;" parent="HT5lYA2dYPyrPS9nyiQT-184" vertex="1">
-          <mxGeometry x="30" width="150" height="30" as="geometry">
-            <mxRectangle width="150" height="30" as="alternateBounds" />
-          </mxGeometry>
-        </mxCell>
        <mxCell id="HT5lYA2dYPyrPS9nyiQT-187" value="" style="shape=tableRow;horizontal=0;startSize=0;swimlaneHead=0;swimlaneBody=0;fillColor=none;collapsible=0;dropTarget=0;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;top=0;left=0;right=0;bottom=0;" parent="HT5lYA2dYPyrPS9nyiQT-190" vertex="1">
          <mxGeometry y="180" width="180" height="30" as="geometry" />
        </mxCell>
@@ -2290,11 +2169,19 @@
            <mxRectangle width="30" height="30" as="alternateBounds" />
          </mxGeometry>
        </mxCell>
-        <mxCell id="HT5lYA2dYPyrPS9nyiQT-189" value="enddate" style="shape=partialRectangle;connectable=0;fillColor=none;top=0;left=1;bottom=0;right=0;align=left;spacingLeft=6;overflow=hidden;whiteSpace=wrap;html=1;" parent="HT5lYA2dYPyrPS9nyiQT-187" vertex="1">
-          <mxGeometry x="30" width="150" height="30" as="geometry">
+        <mxCell id="HT5lYA2dYPyrPS9nyiQT-186" value="startdate" style="shape=partialRectangle;connectable=0;fillColor=none;top=0;left=1;bottom=0;right=0;align=left;spacingLeft=6;overflow=hidden;whiteSpace=wrap;html=1;" parent="HT5lYA2dYPyrPS9nyiQT-190" vertex="1">
+          <mxGeometry x="30" y="120" width="150" height="30" as="geometry">
            <mxRectangle width="150" height="30" as="alternateBounds" />
          </mxGeometry>
        </mxCell>
+        <mxCell id="HT5lYA2dYPyrPS9nyiQT-189" value="enddate" style="shape=partialRectangle;connectable=0;fillColor=none;top=0;left=1;bottom=0;right=0;align=left;spacingLeft=6;overflow=hidden;whiteSpace=wrap;html=1;" parent="HT5lYA2dYPyrPS9nyiQT-190" vertex="1">
+          <mxGeometry x="30" y="150" width="150" height="30" as="geometry">
+            <mxRectangle width="150" height="30" as="alternateBounds" />
+          </mxGeometry>
+        </mxCell>
+        <mxCell id="Ya_982ONw7_15APAzA8q-279" value="1" style="resizable=0;html=1;whiteSpace=wrap;align=right;verticalAlign=bottom;" parent="HT5lYA2dYPyrPS9nyiQT-190" connectable="0" vertex="1">
+          <mxGeometry x="90" y="200" as="geometry" />
+        </mxCell>
        <mxCell id="HT5lYA2dYPyrPS9nyiQT-197" value="" style="group" parent="1" vertex="1" connectable="0">
          <mxGeometry x="870" y="20" width="180" height="211" as="geometry" />
        </mxCell>
@@ -3275,7 +3162,7 @@
            </Array>
          </mxGeometry>
        </mxCell>
-        <mxCell id="7H4gm8Qbcmcg-KG3YoOF-1" value="" style="endArrow=none;html=1;rounded=0;exitX=1;exitY=0.5;exitDx=0;exitDy=0;entryX=0;entryY=0.5;entryDx=0;entryDy=0;" edge="1" parent="1" source="HT5lYA2dYPyrPS9nyiQT-199" target="HT5lYA2dYPyrPS9nyiQT-348">
+        <mxCell id="7H4gm8Qbcmcg-KG3YoOF-1" value="" style="endArrow=none;html=1;rounded=0;exitX=1;exitY=0.5;exitDx=0;exitDy=0;entryX=0;entryY=0.5;entryDx=0;entryDy=0;" parent="1" source="HT5lYA2dYPyrPS9nyiQT-199" target="HT5lYA2dYPyrPS9nyiQT-348" edge="1">
          <mxGeometry width="50" height="50" relative="1" as="geometry">
            <mxPoint x="-266" y="560" as="sourcePoint" />
            <mxPoint x="414" y="1158" as="targetPoint" />
@@ -3285,7 +3172,7 @@
            </Array>
          </mxGeometry>
        </mxCell>
-        <mxCell id="7H4gm8Qbcmcg-KG3YoOF-2" value="" style="endArrow=none;html=1;rounded=0;exitX=1;exitY=0.5;exitDx=0;exitDy=0;entryX=0;entryY=1;entryDx=0;entryDy=0;" edge="1" parent="1" source="HT5lYA2dYPyrPS9nyiQT-366" target="HT5lYA2dYPyrPS9nyiQT-417">
+        <mxCell id="7H4gm8Qbcmcg-KG3YoOF-2" value="" style="endArrow=none;html=1;rounded=0;exitX=1;exitY=0.5;exitDx=0;exitDy=0;entryX=0;entryY=1;entryDx=0;entryDy=0;" parent="1" source="HT5lYA2dYPyrPS9nyiQT-366" target="HT5lYA2dYPyrPS9nyiQT-417" edge="1">
          <mxGeometry width="50" height="50" relative="1" as="geometry">
            <mxPoint x="200" y="1110" as="sourcePoint" />
            <mxPoint x="500" y="880" as="targetPoint" />
@@ -3409,7 +3296,7 @@
            <mxRectangle width="150" height="30" as="alternateBounds" />
          </mxGeometry>
        </mxCell>
-        <mxCell id="7H4gm8Qbcmcg-KG3YoOF-3" value="" style="endArrow=none;html=1;rounded=0;exitX=0;exitY=0.5;exitDx=0;exitDy=0;entryX=0.994;entryY=0.967;entryDx=0;entryDy=0;entryPerimeter=0;" edge="1" parent="1" source="HT5lYA2dYPyrPS9nyiQT-388" target="HT5lYA2dYPyrPS9nyiQT-418">
+        <mxCell id="7H4gm8Qbcmcg-KG3YoOF-3" value="" style="endArrow=none;html=1;rounded=0;exitX=0;exitY=0.5;exitDx=0;exitDy=0;entryX=0.994;entryY=0.967;entryDx=0;entryDy=0;entryPerimeter=0;" parent="1" source="HT5lYA2dYPyrPS9nyiQT-388" target="HT5lYA2dYPyrPS9nyiQT-418" edge="1">
          <mxGeometry width="50" height="50" relative="1" as="geometry">
            <mxPoint x="1360" y="290" as="sourcePoint" />
            <mxPoint x="1360" y="180" as="targetPoint" />
@@ -3421,7 +3308,7 @@
            </Array>
          </mxGeometry>
        </mxCell>
-        <mxCell id="7H4gm8Qbcmcg-KG3YoOF-4" value="" style="endArrow=none;html=1;rounded=0;exitX=0;exitY=0.5;exitDx=0;exitDy=0;entryX=0;entryY=0.5;entryDx=0;entryDy=0;" edge="1" parent="1" source="HT5lYA2dYPyrPS9nyiQT-2" target="HT5lYA2dYPyrPS9nyiQT-36">
+        <mxCell id="7H4gm8Qbcmcg-KG3YoOF-4" value="" style="endArrow=none;html=1;rounded=0;exitX=0;exitY=0.5;exitDx=0;exitDy=0;entryX=0;entryY=0.5;entryDx=0;entryDy=0;" parent="1" source="HT5lYA2dYPyrPS9nyiQT-2" target="HT5lYA2dYPyrPS9nyiQT-36" edge="1">
          <mxGeometry width="50" height="50" relative="1" as="geometry">
            <mxPoint x="-300" y="1470" as="sourcePoint" />
            <mxPoint x="-250" y="1420" as="targetPoint" />
@@ -3431,13 +3318,13 @@
            </Array>
          </mxGeometry>
        </mxCell>
-        <mxCell id="7H4gm8Qbcmcg-KG3YoOF-5" value="" style="endArrow=none;html=1;rounded=0;exitX=1;exitY=0.5;exitDx=0;exitDy=0;" edge="1" parent="1" source="HT5lYA2dYPyrPS9nyiQT-30">
+        <mxCell id="7H4gm8Qbcmcg-KG3YoOF-5" value="" style="endArrow=none;html=1;rounded=0;exitX=1;exitY=0.5;exitDx=0;exitDy=0;" parent="1" source="HT5lYA2dYPyrPS9nyiQT-30" edge="1">
          <mxGeometry width="50" height="50" relative="1" as="geometry">
            <mxPoint x="-300" y="1110" as="sourcePoint" />
            <mxPoint x="-560" y="1215" as="targetPoint" />
          </mxGeometry>
        </mxCell>
-        <mxCell id="7H4gm8Qbcmcg-KG3YoOF-6" value="" style="endArrow=none;html=1;rounded=0;exitX=0;exitY=0.5;exitDx=0;exitDy=0;" edge="1" parent="1" source="HT5lYA2dYPyrPS9nyiQT-253">
+        <mxCell id="7H4gm8Qbcmcg-KG3YoOF-6" value="" style="endArrow=none;html=1;rounded=0;exitX=0;exitY=0.5;exitDx=0;exitDy=0;" parent="1" source="HT5lYA2dYPyrPS9nyiQT-253" edge="1">
          <mxGeometry width="50" height="50" relative="1" as="geometry">
            <mxPoint x="-300" y="1110" as="sourcePoint" />
            <mxPoint x="-380" y="1230" as="targetPoint" />
@@ -3447,13 +3334,13 @@
            </Array>
          </mxGeometry>
        </mxCell>
-        <mxCell id="7H4gm8Qbcmcg-KG3YoOF-7" value="" style="endArrow=none;html=1;rounded=0;exitX=1;exitY=0.5;exitDx=0;exitDy=0;" edge="1" parent="1" source="HT5lYA2dYPyrPS9nyiQT-276">
+        <mxCell id="7H4gm8Qbcmcg-KG3YoOF-7" value="" style="endArrow=none;html=1;rounded=0;exitX=1;exitY=0.5;exitDx=0;exitDy=0;" parent="1" source="HT5lYA2dYPyrPS9nyiQT-276" edge="1">
          <mxGeometry width="50" height="50" relative="1" as="geometry">
            <mxPoint x="-590" y="1130" as="sourcePoint" />
            <mxPoint x="-560" y="1060" as="targetPoint" />
          </mxGeometry>
        </mxCell>
-        <mxCell id="7H4gm8Qbcmcg-KG3YoOF-8" value="" style="endArrow=none;html=1;rounded=0;exitX=1;exitY=0.5;exitDx=0;exitDy=0;entryX=-0.006;entryY=0.924;entryDx=0;entryDy=0;entryPerimeter=0;" edge="1" parent="1" source="Ya_982ONw7_15APAzA8q-301" target="HT5lYA2dYPyrPS9nyiQT-253">
+        <mxCell id="7H4gm8Qbcmcg-KG3YoOF-8" value="" style="endArrow=none;html=1;rounded=0;exitX=1;exitY=0.5;exitDx=0;exitDy=0;entryX=-0.006;entryY=0.924;entryDx=0;entryDy=0;entryPerimeter=0;" parent="1" source="Ya_982ONw7_15APAzA8q-301" target="HT5lYA2dYPyrPS9nyiQT-253" edge="1">
          <mxGeometry width="50" height="50" relative="1" as="geometry">
            <mxPoint x="-590" y="1130" as="sourcePoint" />
            <mxPoint x="-540" y="1080" as="targetPoint" />
@@ -3463,7 +3350,7 @@
            </Array>
          </mxGeometry>
        </mxCell>
-        <mxCell id="7H4gm8Qbcmcg-KG3YoOF-9" value="" style="endArrow=none;html=1;rounded=0;entryX=0;entryY=0.5;entryDx=0;entryDy=0;" edge="1" parent="1" target="HT5lYA2dYPyrPS9nyiQT-289">
+        <mxCell id="7H4gm8Qbcmcg-KG3YoOF-9" value="" style="endArrow=none;html=1;rounded=0;entryX=0;entryY=0.5;entryDx=0;entryDy=0;" parent="1" target="HT5lYA2dYPyrPS9nyiQT-289" edge="1">
          <mxGeometry width="50" height="50" relative="1" as="geometry">
            <mxPoint x="-380" y="299" as="sourcePoint" />
            <mxPoint x="330" y="420" as="targetPoint" />
@@ -3473,13 +3360,13 @@
            </Array>
          </mxGeometry>
        </mxCell>
-        <mxCell id="7H4gm8Qbcmcg-KG3YoOF-30" value="" style="endArrow=none;html=1;rounded=0;entryX=1;entryY=0.5;entryDx=0;entryDy=0;" edge="1" parent="1" target="HT5lYA2dYPyrPS9nyiQT-312">
+        <mxCell id="7H4gm8Qbcmcg-KG3YoOF-30" value="" style="endArrow=none;html=1;rounded=0;entryX=1;entryY=0.5;entryDx=0;entryDy=0;" parent="1" target="HT5lYA2dYPyrPS9nyiQT-312" edge="1">
          <mxGeometry width="50" height="50" relative="1" as="geometry">
            <mxPoint x="790" y="685" as="sourcePoint" />
            <mxPoint x="760" y="540" as="targetPoint" />
          </mxGeometry>
        </mxCell>
-        <mxCell id="7H4gm8Qbcmcg-KG3YoOF-31" value="" style="endArrow=none;html=1;rounded=0;exitX=0;exitY=0.5;exitDx=0;exitDy=0;" edge="1" parent="1" source="AkoRetE9dPsFytqfa5Kx-31">
+        <mxCell id="7H4gm8Qbcmcg-KG3YoOF-31" value="" style="endArrow=none;html=1;rounded=0;exitX=0;exitY=0.5;exitDx=0;exitDy=0;" parent="1" source="AkoRetE9dPsFytqfa5Kx-31" edge="1">
          <mxGeometry width="50" height="50" relative="1" as="geometry">
            <mxPoint x="790" y="850" as="sourcePoint" />
            <mxPoint x="250" y="870" as="targetPoint" />
@@ -3489,7 +3376,7 @@
            </Array>
          </mxGeometry>
        </mxCell>
-        <mxCell id="7H4gm8Qbcmcg-KG3YoOF-32" value="" style="endArrow=none;html=1;rounded=0;entryX=0;entryY=0.5;entryDx=0;entryDy=0;" edge="1" parent="1" target="7H4gm8Qbcmcg-KG3YoOF-21">
+        <mxCell id="7H4gm8Qbcmcg-KG3YoOF-32" value="" style="endArrow=none;html=1;rounded=0;entryX=0;entryY=0.5;entryDx=0;entryDy=0;" parent="1" target="7H4gm8Qbcmcg-KG3YoOF-21" edge="1">
          <mxGeometry width="50" height="50" relative="1" as="geometry">
            <mxPoint x="480" y="720" as="sourcePoint" />
            <mxPoint x="530" y="470" as="targetPoint" />
@@ -3500,6 +3387,103 @@
            </Array>
          </mxGeometry>
        </mxCell>
+        <mxCell id="BsNFRahTXGiPdYppKmQY-3" value="servicedesc" style="shape=table;startSize=30;container=1;collapsible=1;childLayout=tableLayout;fixedRows=1;rowLines=0;fontStyle=1;align=center;resizeLast=1;html=1;" vertex="1" parent="1">
+          <mxGeometry x="1410" y="249" width="180" height="120" as="geometry" />
+        </mxCell>
+        <mxCell id="BsNFRahTXGiPdYppKmQY-4" value="" style="shape=tableRow;horizontal=0;startSize=0;swimlaneHead=0;swimlaneBody=0;fillColor=none;collapsible=0;dropTarget=0;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;top=0;left=0;right=0;bottom=1;" vertex="1" parent="BsNFRahTXGiPdYppKmQY-3">
+          <mxGeometry y="30" width="180" height="30" as="geometry" />
+        </mxCell>
+        <mxCell id="BsNFRahTXGiPdYppKmQY-5" value="PK" style="shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;fontStyle=1;overflow=hidden;whiteSpace=wrap;html=1;" vertex="1" parent="BsNFRahTXGiPdYppKmQY-4">
+          <mxGeometry width="30" height="30" as="geometry">
+            <mxRectangle width="30" height="30" as="alternateBounds" />
+          </mxGeometry>
+        </mxCell>
+        <mxCell id="BsNFRahTXGiPdYppKmQY-6" value="servicedescid" style="shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;align=left;spacingLeft=6;fontStyle=5;overflow=hidden;whiteSpace=wrap;html=1;" vertex="1" parent="BsNFRahTXGiPdYppKmQY-4">
+          <mxGeometry x="30" width="150" height="30" as="geometry">
+            <mxRectangle width="150" height="30" as="alternateBounds" />
+          </mxGeometry>
+        </mxCell>
+        <mxCell id="BsNFRahTXGiPdYppKmQY-7" value="" style="shape=tableRow;horizontal=0;startSize=0;swimlaneHead=0;swimlaneBody=0;fillColor=none;collapsible=0;dropTarget=0;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;top=0;left=0;right=0;bottom=0;" vertex="1" parent="BsNFRahTXGiPdYppKmQY-3">
+          <mxGeometry y="60" width="180" height="30" as="geometry" />
+        </mxCell>
+        <mxCell id="BsNFRahTXGiPdYppKmQY-8" value="FK" style="shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;editable=1;overflow=hidden;whiteSpace=wrap;html=1;" vertex="1" parent="BsNFRahTXGiPdYppKmQY-7">
+          <mxGeometry width="30" height="30" as="geometry">
+            <mxRectangle width="30" height="30" as="alternateBounds" />
+          </mxGeometry>
+        </mxCell>
+        <mxCell id="BsNFRahTXGiPdYppKmQY-9" value="servicetypeid" style="shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;align=left;spacingLeft=6;overflow=hidden;whiteSpace=wrap;html=1;" vertex="1" parent="BsNFRahTXGiPdYppKmQY-7">
+          <mxGeometry x="30" width="150" height="30" as="geometry">
+            <mxRectangle width="150" height="30" as="alternateBounds" />
+          </mxGeometry>
+        </mxCell>
+        <mxCell id="BsNFRahTXGiPdYppKmQY-10" value="" style="shape=tableRow;horizontal=0;startSize=0;swimlaneHead=0;swimlaneBody=0;fillColor=none;collapsible=0;dropTarget=0;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;top=0;left=0;right=0;bottom=0;" vertex="1" parent="BsNFRahTXGiPdYppKmQY-3">
+          <mxGeometry y="90" width="180" height="30" as="geometry" />
+        </mxCell>
+        <mxCell id="BsNFRahTXGiPdYppKmQY-11" value="" style="shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;editable=1;overflow=hidden;whiteSpace=wrap;html=1;" vertex="1" parent="BsNFRahTXGiPdYppKmQY-10">
+          <mxGeometry width="30" height="30" as="geometry">
+            <mxRectangle width="30" height="30" as="alternateBounds" />
+          </mxGeometry>
+        </mxCell>
+        <mxCell id="BsNFRahTXGiPdYppKmQY-12" value="description" style="shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;align=left;spacingLeft=6;overflow=hidden;whiteSpace=wrap;html=1;" vertex="1" parent="BsNFRahTXGiPdYppKmQY-10">
+          <mxGeometry x="30" width="150" height="30" as="geometry">
+            <mxRectangle width="150" height="30" as="alternateBounds" />
+          </mxGeometry>
+        </mxCell>
+        <mxCell id="BsNFRahTXGiPdYppKmQY-16" value="offers" style="shape=table;startSize=30;container=1;collapsible=1;childLayout=tableLayout;fixedRows=1;rowLines=0;fontStyle=1;align=center;resizeLast=1;html=1;" vertex="1" parent="1">
+          <mxGeometry x="900" y="645" width="180" height="151" as="geometry" />
+        </mxCell>
+        <mxCell id="BsNFRahTXGiPdYppKmQY-17" value="" style="shape=tableRow;horizontal=0;startSize=0;swimlaneHead=0;swimlaneBody=0;fillColor=none;collapsible=0;dropTarget=0;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;top=0;left=0;right=0;bottom=1;" vertex="1" parent="BsNFRahTXGiPdYppKmQY-16">
+          <mxGeometry y="30" width="180" height="30" as="geometry" />
+        </mxCell>
+        <mxCell id="BsNFRahTXGiPdYppKmQY-18" value="" style="shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;fontStyle=1;overflow=hidden;whiteSpace=wrap;html=1;" vertex="1" parent="BsNFRahTXGiPdYppKmQY-17">
+          <mxGeometry width="30" height="30" as="geometry">
+            <mxRectangle width="30" height="30" as="alternateBounds" />
+          </mxGeometry>
+        </mxCell>
+        <mxCell id="BsNFRahTXGiPdYppKmQY-19" value="" style="shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;align=left;spacingLeft=6;fontStyle=5;overflow=hidden;whiteSpace=wrap;html=1;" vertex="1" parent="BsNFRahTXGiPdYppKmQY-17">
+          <mxGeometry x="30" width="150" height="30" as="geometry">
+            <mxRectangle width="150" height="30" as="alternateBounds" />
+          </mxGeometry>
+        </mxCell>
+        <mxCell id="BsNFRahTXGiPdYppKmQY-20" value="" style="shape=tableRow;horizontal=0;startSize=0;swimlaneHead=0;swimlaneBody=0;fillColor=none;collapsible=0;dropTarget=0;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;top=0;left=0;right=0;bottom=0;" vertex="1" parent="BsNFRahTXGiPdYppKmQY-16">
+          <mxGeometry y="60" width="180" height="31" as="geometry" />
+        </mxCell>
+        <mxCell id="BsNFRahTXGiPdYppKmQY-21" value="FK" style="shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;editable=1;overflow=hidden;whiteSpace=wrap;html=1;" vertex="1" parent="BsNFRahTXGiPdYppKmQY-20">
+          <mxGeometry width="30" height="31" as="geometry">
+            <mxRectangle width="30" height="31" as="alternateBounds" />
+          </mxGeometry>
+        </mxCell>
+        <mxCell id="BsNFRahTXGiPdYppKmQY-22" value="jobdetailid" style="shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;align=left;spacingLeft=6;overflow=hidden;whiteSpace=wrap;html=1;" vertex="1" parent="BsNFRahTXGiPdYppKmQY-20">
+          <mxGeometry x="30" width="150" height="31" as="geometry">
+            <mxRectangle width="150" height="31" as="alternateBounds" />
+          </mxGeometry>
+        </mxCell>
+        <mxCell id="BsNFRahTXGiPdYppKmQY-23" value="" style="shape=tableRow;horizontal=0;startSize=0;swimlaneHead=0;swimlaneBody=0;fillColor=none;collapsible=0;dropTarget=0;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;top=0;left=0;right=0;bottom=0;" vertex="1" parent="BsNFRahTXGiPdYppKmQY-16">
+          <mxGeometry y="91" width="180" height="30" as="geometry" />
+        </mxCell>
+        <mxCell id="BsNFRahTXGiPdYppKmQY-24" value="" style="shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;editable=1;overflow=hidden;whiteSpace=wrap;html=1;" vertex="1" parent="BsNFRahTXGiPdYppKmQY-23">
+          <mxGeometry width="30" height="30" as="geometry">
+            <mxRectangle width="30" height="30" as="alternateBounds" />
+          </mxGeometry>
+        </mxCell>
+        <mxCell id="BsNFRahTXGiPdYppKmQY-25" value="offerid" style="shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;align=left;spacingLeft=6;overflow=hidden;whiteSpace=wrap;html=1;" vertex="1" parent="BsNFRahTXGiPdYppKmQY-23">
+          <mxGeometry x="30" width="150" height="30" as="geometry">
+            <mxRectangle width="150" height="30" as="alternateBounds" />
+          </mxGeometry>
+        </mxCell>
+        <mxCell id="BsNFRahTXGiPdYppKmQY-26" value="" style="shape=tableRow;horizontal=0;startSize=0;swimlaneHead=0;swimlaneBody=0;fillColor=none;collapsible=0;dropTarget=0;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;top=0;left=0;right=0;bottom=0;" vertex="1" parent="BsNFRahTXGiPdYppKmQY-16">
+          <mxGeometry y="121" width="180" height="30" as="geometry" />
+        </mxCell>
+        <mxCell id="BsNFRahTXGiPdYppKmQY-27" value="" style="shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;editable=1;overflow=hidden;whiteSpace=wrap;html=1;" vertex="1" parent="BsNFRahTXGiPdYppKmQY-26">
+          <mxGeometry width="30" height="30" as="geometry">
+            <mxRectangle width="30" height="30" as="alternateBounds" />
+          </mxGeometry>
+        </mxCell>
+        <mxCell id="BsNFRahTXGiPdYppKmQY-28" value="contractid" style="shape=partialRectangle;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;align=left;spacingLeft=6;overflow=hidden;whiteSpace=wrap;html=1;" vertex="1" parent="BsNFRahTXGiPdYppKmQY-26">
+          <mxGeometry x="30" width="150" height="30" as="geometry">
+            <mxRectangle width="150" height="30" as="alternateBounds" />
+          </mxGeometry>
+        </mxCell>
      </root>
    </mxGraphModel>
  </diagram>
--- a/docker-compose.yml
+++ b/docker-compose.yml
@@ -1,14 +0,0 @@
-services:
-  mariadb:
-    image: mariadb:latest
-    volumes:
-      - mariadb:/var/lib/mysql
-    ports:
-      - 127.0.0.1:8000:3306
-    environment:
-      MARIADB_ROOT_PASSWORD: pyqcrm
-      MARIADB_USER: pyqcrm
-      MARIADB_PASSWORD: pyqcrm
-      MARIADB_DATABASE: pyqcrm
-volumes:
-  mariadb:
--- a/images/InboxArrowDown.svg
+++ b/images/InboxArrowDown.svg
@@ -1,4 +0,0 @@
-<svg fill="currentColor" viewBox="0 0 24 24" xmlns="http://www.w3.org/2000/svg" aria-hidden="true" data-slot="icon">
-  <path clip-rule="evenodd" fill-rule="evenodd" d="M5.478 5.559A1.5 1.5 0 0 1 6.912 4.5H9A.75.75 0 0 0 9 3H6.912a3 3 0 0 0-2.868 2.118l-2.411 7.838a3 3 0 0 0-.133.882V18a3 3 0 0 0 3 3h15a3 3 0 0 0 3-3v-4.162c0-.299-.045-.596-.133-.882l-2.412-7.838A3 3 0 0 0 17.088 3H15a.75.75 0 0 0 0 1.5h2.088a1.5 1.5 0 0 1 1.434 1.059l2.213 7.191H17.89a3 3 0 0 0-2.684 1.658l-.256.513a1.5 1.5 0 0 1-1.342.829h-3.218a1.5 1.5 0 0 1-1.342-.83l-.256-.512a3 3 0 0 0-2.684-1.658H3.265l2.213-7.191Z"></path>
-  <path clip-rule="evenodd" fill-rule="evenodd" d="M12 2.25a.75.75 0 0 1 .75.75v6.44l1.72-1.72a.75.75 0 1 1 1.06 1.06l-3 3a.75.75 0 0 1-1.06 0l-3-3a.75.75 0 0 1 1.06-1.06l1.72 1.72V3a.75.75 0 0 1 .75-.75Z"></path>
-</svg>
--- a/lib/Config.py
+++ b/lib/Config.py
@@ -1,19 +0,0 @@
-from typing import TypedDict
-
-
-class EncryptionConfig(TypedDict):
-    ENCRYPTION_KEY_VALID: str
-    ENCRYPTION_KEY: str
-
-
-class DatabaseConfig(TypedDict):
-    DB_HOST: str
-    DB_USER: str
-    DB_PASS: str
-    DB_NAME: str
-    DB_PORT: str
-
-
-class Config(TypedDict):
-    database: DatabaseConfig
-    pyqcrm: EncryptionConfig
--- a/lib/ConfigLoader.py
+++ b/lib/ConfigLoader.py
@@ -1,28 +1,27 @@
 # This Python file uses the following encoding: utf-8
-import os
-from base64 import b64encode
-from pathlib import Path
-from typing import Optional
-from urllib.parse import urlparse
-
 import toml
-from Crypto.Random import get_random_bytes
-from PySide6.QtCore import QObject, Slot, Signal
-from peewee import OperationalError
 from platformdirs import user_config_dir
-
-from .Config import Config, DatabaseConfig
+from pathlib import Path
+from PySide6.QtCore import QObject, Slot, Signal
+from .Vermasseln import Vermasseln
+import shutil
+from urllib.parse import urlparse
+from .DB.DbManager import DbManager
+import os
+from Crypto.Random import get_random_bytes
+from base64 import b64encode
 from .DB.UserManager import UserManager
 from .PyqcrmFlags import PyqcrmFlags
-from .Vermasseln import Vermasseln
-from .domain.BaseModel import init_database_from_config
+
+


 class ConfigLoader(QObject):
-    __config: Optional[Config] = None
+    __config = None
    __version = "0.1-alpha"
    __check_enc_key = True

+
    dbConnectionError = Signal(str, bool)
    adminUserError = Signal(str, bool)
    adminNotAsvailable = Signal()
@@ -32,6 +31,7 @@ class ConfigLoader(QObject):

    def __init__(self):
        super().__init__()
+        # print(f"In {__file__} file, __init__()")
        self.config_dir = user_config_dir() + '/pyqcrm'
        config_dir = Path(self.config_dir)
        if config_dir.exists():
@@ -41,11 +41,13 @@ class ConfigLoader(QObject):
        else:
            config_dir.mkdir(0o750, True, True)

-    @Slot(dict, result=bool)
-    def setConfig(self, app_config: Config):
+
+    @Slot(dict, result = bool)
+    def setConfig(self, app_config):
+        # print(f"In {__file__} file, setConfig()")
        if not self.__config:
            base_conf = self.__initializeConfig()
-        conf = self._is_db_connectable(app_config['database'])
+            conf = self.__checkDbConnection(app_config)
            app_config = toml.dumps(app_config)
            if  conf:
                app_config = base_conf + app_config
@@ -56,48 +58,52 @@ class ConfigLoader(QObject):
                    self.configurationReady.emit()

    def __initializeConfig(self):
+        # print(f"In {__file__} file, __initializeConfig()")
        self.__encrypt_key = b64encode(get_random_bytes(32)).decode("utf-8")
        conf = f"[pyqcrm]\nVERSION = \"{self.__version}\"\n"
        conf = conf + f"ENCRYPTION_KEY_VALID = \"No\"\n"
        conf = conf + f"ENCRYPTION_KEY = \"{self.__encrypt_key}\"\n\n"
        return conf

-    def _is_db_connectable(self, config: DatabaseConfig):
-        try:
-            init_database_from_config(config)
+    def __checkDbConnection(self, db_config):
+        # print(f"In {__file__} file, __checkDbConnection()")
+        con = DbManager(db_config['database']).getConnection()
+        if con:
            self.dbConnectionError.emit("Connection OK", True)
            return True
-        except OperationalError as e:
+        else:
            self.dbConnectionError.emit("Connection fehlgeschlagen", False)
        return False

+
    def __saveConfig(self):
        # print(f"In {__file__} file, saveConfig()")
        try:
-            with open(self.config_dir + '/pyqcrm.toml', 'w') as f:
+            with open (self.config_dir + '/pyqcrm.toml', 'w') as f:
                # print(self.__config)
                config = Vermasseln().oscarVermasseln(toml.dumps(self.__config))
                f.write(config)
        except FileNotFoundError:
            print("Konnte die Konfiguration nicht speichern.")

+
    def __checkAdminUser(self):
        # print(f"In {__file__} file, __checkAdminUser()")
        result = UserManager().checkAdmin()
        if not result:
-            # if not result[0][0] == 1:
+            #if not result[0][0] == 1:
            self.adminUserError.emit("Kein Admin vorhanden", False)
            return False
        else:
            self.adminUserError.emit("Admin vorhanden", True)
        return True

-    @Slot(dict, result=bool)
+    @Slot(dict, result= bool)
    def addAdminUser(self, user_config):
        # print(f"In {__file__} file, addAdminUser()")
        admin = UserManager(user_config["user"], PyqcrmFlags.ADMIN).createUser()
        if not admin:
-            # self.adminNotAvailable.emit()
+            #self.adminNotAvailable.emit()
            self.adminUserError.emit("Benutzername nich verfügbar", False)
        else:
            self.__config['pyqcrm']['ENCRYPTION_KEY_VALID'] = 'Yes'
@@ -105,6 +111,7 @@ class ConfigLoader(QObject):
            self.backupEncryptionKey.emit()
        return admin

+
    @Slot(str, str)
    def __saveData(self, recovery_file, recovery_password, data):
        # print(f"In {__file__} file, __saveData()")
@@ -114,7 +121,7 @@ class ConfigLoader(QObject):
        rf = Vermasseln().oscarVermasseln(rf, local)
        rec_file = urlparse(recovery_file)
        if os.name == "nt":
-            rec_file = rec_file[1:]
+            rec_file = rec_file [1:]
        else:
            rec_file = rec_file.path + ".pyqrec"
        try:
@@ -129,7 +136,7 @@ class ConfigLoader(QObject):
        rec_file = urlparse(recovery_file)
        rec_file = rec_file.path
        if os.name == "nt":
-            rec_file = rec_file[1:]
+            rec_file = rec_file [1:]
        try:
            ek = self.__parseImport(rec_file, recovery_password)

@@ -158,6 +165,7 @@ class ConfigLoader(QObject):
            else:
                return None

+
    def __invalidateEncryptionKey(self):
        # print(f"In {__file__} file, __invalidateEncryptionKey()")
        self.__config['pyqcrm']['ENCRYPTION_KEY_VALID'] = 'No'
@@ -192,9 +200,15 @@ class ConfigLoader(QObject):
        except Exception as e:
            print(str(e))

+
+
+
+
+
    def __configLoad(self):
+        # print(f"In {__file__} file, __configLoad()")
        try:
-            with open(self.config_dir + '/pyqcrm.toml', 'r') as f:
+            with open (self.config_dir + '/pyqcrm.toml', 'r') as f:
                config = f.read()
                self.__config = toml.loads(Vermasseln().entschluesseln(config))
                self.configurationReady.emit()
@@ -202,11 +216,17 @@ class ConfigLoader(QObject):
            print("Konnte die Konfiguration nicht laden.")
        except TypeError:
            print(f"Invalid Configuration: {__file__}")
+        except Exception as e:
+            print(str(e))

-    def get_config(self) -> Optional[Config]:
+
+    def getConfig(self):
+        # print(f"In {__file__} file, getConfig()")
+        # print(self.__config)
        return self.__config

-    def __setRecoveryPassword(self, key, salt=None):
+    def __setRecoveryPassword(self, key, salt = None):
+        # print(f"In {__file__} file, __setRecoveryPassword()")
        key = Vermasseln.userPasswordHash(key, salt)
        return key.split("$")

@@ -219,28 +239,29 @@ class ConfigLoader(QObject):

    @Slot(str, str)
    def backupConfig(self, filename, password):
-        conf_file = toml.dumps(self.get_config())
+        conf_file = toml.dumps(self.getConfig())
        self.__saveData(filename, password, conf_file)

+
    @Slot(dict)
-    def saveDbConf(self, db=None):
+    def saveDbConf(self, db = None):
        self.__config.update(db)
        self.__saveConfig()

-    @Slot(result=dict)
+    @Slot(result = dict)
    def getDbConf(self):
        try:
-            return self.__config['database'] if self.__config is not None else None
+            return self.__config['database']
        except KeyError as ex:
            print(f"Missing database configuration: {ex}")
            return None

    @Slot(dict)
-    def saveCompanyInfo(self, company=None):
+    def saveCompanyInfo(self, company = None):
        self.__config.update(company)
        self.__saveConfig()

-    @Slot(result=dict)
+    @Slot(result = dict)
    def getCompanyInfo(self):
        try:
            return self.__config['company']
@@ -249,11 +270,11 @@ class ConfigLoader(QObject):
            return None

    @Slot(dict)
-    def saveMiscConf(self, misc_conf=None):
+    def saveMiscConf(self, misc_conf = None):
        self.__config.update(misc_conf)
        self.__saveConfig()

-    @Slot(result=bool)
+    @Slot(result = bool)
    def systray(self):
        try:
            return self.__config['misc']['SYSTRAY']
@@ -261,7 +282,9 @@ class ConfigLoader(QObject):
            print(f"Missing configuration: {ex}")
            return False

+
    @Slot(str, str)
    def backupEncryptkey(self, filename, password):
        encrypt_key = self.__config['pyqcrm']['ENCRYPTION_KEY']
        self.__saveData(filename, password, encrypt_key)
+
--- a/lib/DB/AddressDAO.py
+++ b/lib/DB/AddressDAO.py
@@ -1,26 +1,27 @@
-import json
-
+from .DbManager import DbManager
 import mariadb
-
-from lib.domain.BaseModel import database
+import json


 class AddressDAO:
    __cur = None
-
    def __init__(self):
-        self.__con = database.connection()
+        #print(f"*** File: {__file__}, init()")
+        self.__con = DbManager().getConnection()

        if self.__con:
            self.__cur = self.__con.cursor()

+
+
+
    def __importPlz(self):
        with open("pfad zur datei", "r") as plz:
            postcodes = json.load(plz)
            irgendwas = ""
            try:
                for i in postcodes:
-                    test = i["plz_name"].split(",")
+                    test =i["plz_name"].split(",")
                    for town in test:
                        if "u.a" in town:
                            town = town[:-4]
@@ -28,12 +29,12 @@ class AddressDAO:
                        if town:
                            print(f"PROCESSING {i['name']} {town}")
                            self.__cur.callproc("addZipCodes", (i["name"], town, irgendwas,))
-                # self.__cur.callproc("addZipCodes", ("56271", "Kleinmaischeid", irgendwas,))
+                #self.__cur.callproc("addZipCodes", ("56271", "Kleinmaischeid", irgendwas,))
            except mariadb.OperationalError as e:
                print(f"Database Error: {e}")
            finally:
                self.__con.commit()
-                print("FINISHED")  #
+                print("FINISHED")#

    def __importCountry(self):
        with open("pfad zur datei", "r") as country:
@@ -54,17 +55,18 @@ class AddressDAO:

                    print(i[4], i[3], i[2], i[8], i[7])

-                    self.__cur.execute(
-                        "INSERT INTO country (country, countryshort, nationality, iso2, iso3) VALUES (%s, %s, %s, %s, %s)",
-                        (i[4], i[3], i[2], i[8], i[7]))
+                    self.__cur.execute("INSERT INTO country (country, countryshort, nationality, iso2, iso3) VALUES (%s, %s, %s, %s, %s)", (i[4], i[3], i[2], i[8], i[7]))
                    old = i[4]
            except mariadb.OperationalError as e:
                print(f"Database Error: {e}")
            finally:
                self.__con.commit()
-                print("FINISHED")  #
+                print("FINISHED")#

-    def getAddressData(self, all=True, zipcode=None):
+
+
+
+    def getAddressData(self, all = True, zipcode = None):
        try:
            if self.__cur:
                self.__cur.callproc("getAddress", (all, zipcode,))
@@ -74,3 +76,5 @@ class AddressDAO:
                return None
        except mariadb.Error as e:
            print(str(e))
+
+
--- a/lib/DB/AddressModel.py
+++ b/lib/DB/AddressModel.py
@@ -2,19 +2,18 @@ from PySide6.QtCore import QAbstractListModel, Qt, Slot, QModelIndex
 from .AddressDAO import AddressDAO
 from ..PyqcrmDataRoles import PyqcrmDataRoles

-
 class AddressModel(QAbstractListModel):

    def __init__(self):
        super().__init__()
        self.__address_data = AddressDAO().getAddressData()

-    def rowCount(self, parent=QModelIndex()):
+    def rowCount(self, parent = QModelIndex()):
        return len(self.__address_data)

-    def data(self, index, role=Qt.ItemDataRole.DisplayRole):
+    def data(self, index, role = Qt.DisplayRole):
        row = index.row()
-        if role == Qt.ItemDataRole.DisplayRole:
+        if role == Qt.DisplayRole:
            data = self.__address_data[row][2]
            return data
        elif role == PyqcrmDataRoles.CITY_ROLE:
@@ -24,11 +23,20 @@ class AddressModel(QAbstractListModel):

    def roleNames(self):
        return {
-            Qt.ItemDataRole.DisplayRole: b"display",
+            Qt.DisplayRole: b"display",
            PyqcrmDataRoles.CITY_ROLE: b"city",
        }

+    def setData(self):
+        pass
+
    @Slot(bool, str)
    def getAddresses(self, all, zipcode):
        data = AddressDAO().getAddressData(all, zipcode)
        return data
+
+
+
+
+
+
--- a/lib/DB/ApplicantModel.py
+++ b/lib/DB/ApplicantModel.py
@@ -1,91 +0,0 @@
-import uuid
-from typing import List, Callable, Any
-
-from PySide6.QtCore import QModelIndex, Qt, QAbstractTableModel, Slot, Property, Signal
-from PySide6.QtQml import QJSValue
-from peewee import Select
-
-from lib.domain.Applicant import Applicant
-
-COLUMNS: list[Callable[[Applicant], Any]] = [
-    lambda applicant: applicant.first_name,
-    lambda applicant: applicant.last_name,
-    lambda applicant: applicant.zip_code.zip_code or None,
-    lambda applicant: applicant.zip_code.town.town if applicant.zip_code.id is not None else None
-]
-
-COLUMN_NAMES = ["Vorname", "Nachname", "PLZ", "Ort"]
-
-
-class ApplicantModel(QAbstractTableModel):
-    _applicants: Select
-    _search_query: str = ""
-    search_query_changed = Signal(str)
-
-    def __init__(self) -> None:
-        super().__init__()
-        self._query_applicants()
-
-    def rowCount(self, /, parent=...):
-        return len(self._applicants)
-
-    def columnCount(self, /, parent=...):
-        return len(COLUMNS)
-
-    def data(self, index: QModelIndex, role: int = Qt.ItemDataRole.DisplayRole):
-        if role == Qt.ItemDataRole.DisplayRole:
-            applicant = self._applicants[index.row()]
-            return COLUMNS[index.column()](applicant)
-        return None
-
-    @Property(str, notify=search_query_changed)
-    def searchQuery(self):
-        return self._search_query
-
-    @searchQuery.setter
-    def searchQuery(self, value: str):
-        self._search_query = value
-        self._query_applicants()
-
-    @Slot(int, result=dict)
-    def applicant(self, row) -> dict:
-        applicant = Applicant.get_by_id(self._applicants[row].id)
-        return {
-            'title': applicant.title,
-            "firstName": applicant.first_name,
-            "lastName": applicant.last_name,
-            "street": applicant.street,
-            "houseNumber": applicant.house_number,
-            "zipCode": applicant.zip_code_id,
-            "phoneNumber": applicant.phone_number,
-            "mobileNumber": applicant.mobile_number,
-            "emailAddress": applicant.email_address,
-            "salutation": applicant.salutation
-        }
-
-    @Slot(QJSValue)
-    def createApplicant(self, values: QJSValue):
-        applicant = Applicant()
-        applicant.id = uuid.uuid4()
-        applicant.title = values.property("title").toInt()
-        applicant.first_name = values.property("firstName").toString()
-        applicant.last_name = values.property("lastName").toString()
-        applicant.street = values.property("street").toString() or None
-        applicant.house_number = values.property("houseNumber").toString() or None
-        if values.property("zipCode").toInt() != -1:
-            applicant.zip_code = values.property("zipCode").toInt()
-        applicant.phone_number = values.property("phoneNumber").toString() or None
-        applicant.mobile_number = values.property("mobileNumber").toString() or None
-        applicant.email_address = values.property("emailAddress").toString() or None
-        applicant.salutation = values.property("salutation").toString() or None
-        applicant.save(force_insert=True)
-        self._query_applicants()
-
-    def headerData(self, section: int, orientation: Qt.Orientation, role: int = Qt.ItemDataRole.DisplayRole):
-        if role == Qt.ItemDataRole.DisplayRole:
-            return COLUMN_NAMES[section]
-        return None
-
-    def _query_applicants(self):
-        self._applicants = Applicant.select_table_data(self._search_query)
-        self.layoutChanged.emit()
--- a/lib/DB/BTypeDAO.py
+++ b/lib/DB/BTypeDAO.py
@@ -1,20 +1,20 @@
-from lib.domain.BaseModel import database
+from .DbManager import DbManager


 class BTypeDAO:
    __cur = None
-
    def __init__(self):
-        self.__con = database.connection()
+        #print(f"*** File: {__file__}, init()")
+        self.__con = DbManager().getConnection()
        if self.__con:
            self.__cur = self.__con.cursor()

    def getBType(self):
        try:
            if self.__cur:
-                self.__cur.callproc("getBtype", (None, None,))
+                self.__cur.callproc("getBtype", (None, None, ))
                data = self.__cur.fetchall()
-                return data
+                return(data)
            else:
                return None
        except mariadb.Error as e:
--- a/lib/DB/BusinessDAO.py
+++ b/lib/DB/BusinessDAO.py
@@ -1,7 +1,7 @@
+from .DbManager import DbManager
 import json
 import mariadb
 from PySide6.QtCore import QObject, Signal
-from lib.domain.BaseModel import database


 class BusinessDAO(QObject):
@@ -12,11 +12,11 @@ class BusinessDAO(QObject):

    def __init__(self):
        super().__init__()
-        self.__con = database.connection()
+        self.__con = DbManager().getConnection()
        if self.__con:
            self.__cur = self.__con.cursor()

-    def getBusiness(self, enc_key, criterion="Alle"):
+    def getBusiness(self, enc_key, criterion = "Alle"):
        try:
            if self.__cur:
                self.__cur.callproc("getCustomerView", (enc_key, criterion,))
@@ -27,14 +27,14 @@ class BusinessDAO(QObject):
        except mariadb.Error as e:
            print(str(e))

-    def getOneBusiness(self, business_id, enc_key=None):
+    def getOneBusiness(self, business_id, enc_key = None):
        try:
            if self.__cur:
                self.__cur.callproc("getCustomer", (business_id, enc_key,))
-                # self.__all_cols = [desc[0] for desc in self.__cur.description]
-                return self.__cur.fetchall()  # , self.__all_cols
+                #self.__all_cols = [desc[0] for desc in self.__cur.description]
+                return  self.__cur.fetchall() #, self.__all_cols
            else:
-                return None  # , None
+                return None #, None
        except mariadb.Error as e:
            print(str(e))

@@ -47,3 +47,10 @@ class BusinessDAO(QObject):

        except mariadb.Error as e:
            print(str(e))
+
+
+
+
+
+
+
--- a/lib/DB/BusinessModel.py
+++ b/lib/DB/BusinessModel.py
@@ -73,7 +73,7 @@ class BusinessModel(QAbstractTableModel):
        super().__init__()
        self.__business_dao = BusinessDAO()
        self.__business_dao.newBusinessAdded.connect(self.__refreshView)
-        self.__conf = ConfigLoader().get_config()
+        self.__conf = ConfigLoader().getConfig()
        self.__key = self.__conf['pyqcrm']['ENCRYPTION_KEY']
        self.__getData()

--- a/lib/DB/ContactDAO.py
+++ b/lib/DB/ContactDAO.py
@@ -1,9 +1,7 @@
-import json
-
-import mariadb
+from .DbManager import DbManager
 from PySide6.QtCore import QObject, Signal
-
-from lib.domain.BaseModel import database
+import json
+import mariadb


 class ContactDAO(QObject):
@@ -11,7 +9,8 @@ class ContactDAO(QObject):

    def __init__(self):
        super().__init__()
-        self.__con = database.connection()
+        #print(f"*** File: {__file__}, __init__()")
+        self.__con = DbManager().getConnection()
        if self.__con:
            self.__cur = self.__con.cursor()

--- a/lib/DB/ContactModel.py
+++ b/lib/DB/ContactModel.py
@@ -14,7 +14,7 @@ class ContactModel(QObject):
        super().__init__()
        # print(f"*** File: {__file__}, __init__()")
        #self.logger = logging.getLogger()
-        self.__conf = ConfigLoader().get_config()
+        self.__conf = ConfigLoader().getConfig()
        self.__key = self.__conf['pyqcrm']['ENCRYPTION_KEY']
        self.__contact_dao = ContactDAO()
        self.__contact_dao.newObjectContactAdded.connect(self.objectContactAdded)
--- a/lib/DB/DbManager.py
+++ b/lib/DB/DbManager.py
@@ -0,0 +1,46 @@
+import mariadb
+
+class DbManager():
+    __connection = None
+    __con_param = None
+    __dbmanager = None
+
+    def __new__(cls, dbconf = None):
+
+        if cls.__dbmanager is None:
+            cls.__dbmanager = super(DbManager, cls).__new__(cls)
+            cls.__dbmanager.__initializeConfig(dbconf)
+
+        return cls.__dbmanager
+
+    def getConnection(cls):
+            #print(f"DB Manager: {cls.__dbmanager}")
+            #print(f"DB Connection: {cls.__connection}")
+            try:
+                if not cls.__connection  or not cls.__connection.ping():
+                    cls.__failure_notified = False
+                    cls.__connection = mariadb.connect(**cls.__con_param)
+            except mariadb.InterfaceError as e:
+                cls.__connection = mariadb.connect(**cls.__con_param)
+                print(f"DbManager Connection (INTERFACE ERROR): {e}..reconnecting...")
+            except mariadb.Error as e:
+                if '(110)' in str(e):
+                    print(f"File: {__file__}\n      Database connection timed out (Check connection parameters or server running): {e}")
+                elif '(138)' in str(e):
+                    print(f"File: {__file__}\n      Database connection timed out (Check connection parameters or server running - initial handshake): {e}")
+                else:
+                    print(f"File: {__file__}\n      Database connection error: {e}")
+                cls.__connection = None
+
+            return cls.__connection
+
+    def __initializeConfig(cls, dbconf):
+        cls.__con_param = { 'user': dbconf['DB_USER'], 'password': dbconf['DB_PASS'],
+                      'port': int (dbconf['DB_PORT']), 'host': dbconf['DB_HOST'],
+                      'database': dbconf['DB_NAME'], 'connect_timeout': 5, 'autocommit': True,
+                    }
+
+
+
+
+
--- a/lib/DB/EmployeeDAO.py
+++ b/lib/DB/EmployeeDAO.py
@@ -1,41 +1,45 @@
+from .DbManager import DbManager
 import json
-
+import mariadb
 from PySide6.QtCore import QObject, Signal

-from lib.domain.BaseModel import database
-

 class EmployeeDAO(QObject):
    newEmployeeAdded = Signal(bool)

+    __cur = None
+    __all_cols = None
+
    def __init__(self):
        super().__init__()
-        self._connection = database.connection()
+        self.__con = DbManager().getConnection()
+        if self.__con:
+            self.__cur = self.__con.cursor()

    def getEmployees(self, enc_key, criterion="Alle", processed=False, fired=False, every_state=True):
-        cursor = self._connection.cursor()
        try:
-            cursor.callproc("getEmployeeTable", (criterion, processed, fired, every_state, enc_key,))
-            all_cols = [desc[0] for desc in cursor.description]
-            result = cursor.fetchall(), all_cols
-            return result
-        finally:
-            cursor.close()
+            if self.__cur:
+                self.__cur.callproc("getEmployeeTable", (criterion, processed, fired, every_state, enc_key,))
+                self.__all_cols = [desc[0] for desc in self.__cur.description]
+                return self.__cur.fetchall(), self.__all_cols
+            else:
+                return None, None
+        except mariadb.Error as e:
+            print(str(e))

-    def fetchApplicant(self, employee_id, enc_key=None) -> dict:
-        cursor = self._connection.cursor(dictionary=True)
+    def getEmployee(self, employee_id, enc_key=None):
        try:
-            cursor.callproc("getApplicant", (employee_id, enc_key))
-            it = cursor.fetchone()
-            return it
-        finally:
-            cursor.close()
+            if self.__cur:
+                self.__cur.callproc("getEmployee", (employee_id, enc_key,))
+                # self.__all_cols = [desc[0] for desc in self.__cur.description]
+                return self.__cur.fetchall()  # , self.__all_cols
+            else:
+                return None
+        except mariadb.Error as e:
+            print(str(e))

-    def addApplicant(self, data, enc_key, applicant=True):
-        cursor = self._connection.cursor()
-        try:
-            cursor.callproc("addApplicant", (json.dumps(data), applicant, enc_key,))
-            self._connection.commit()
+    def addEmployee(self, data, enc_key, applicant=True):
+        if self.__cur:
+            self.__cur.callproc("addApplicant", (json.dumps(data), applicant, enc_key,))
+            self.__con.commit()
            self.newEmployeeAdded.emit(True)
-        finally:
-            cursor.close()
--- a/lib/DB/EmployeeModel.py
+++ b/lib/DB/EmployeeModel.py
@@ -1,7 +1,10 @@
-from PySide6.QtCore import QAbstractTableModel, QModelIndex, Qt, Slot, Signal
+import json
+
+from PySide6.QtCore import QAbstractTableModel, QModelIndex, Qt, Slot, Signal, QJsonDocument
 from PySide6.QtQml import QJSValue

 from .EmployeeDAO import EmployeeDAO
+# from ..PyqcrmFlags import PyqcrmFlags, PyqcrmAppliEmpyFlags
 from ..ConfigLoader import ConfigLoader
 import re

@@ -10,6 +13,7 @@ class EmployeeModel(QAbstractTableModel):
    addedNewEmployee = Signal(bool)
    __data = None
    __employee_dao = None
+    __visible_index = None
    __visible_columns = None
    __col_name = ""
    __col_skip = 2
@@ -19,7 +23,7 @@ class EmployeeModel(QAbstractTableModel):
        super().__init__()
        self.__employee_dao = EmployeeDAO()
        self.__employee_dao.newEmployeeAdded.connect(self.__refreshView)
-        self.__conf = ConfigLoader().get_config()
+        self.__conf = ConfigLoader().getConfig()
        self.__key = self.__conf['pyqcrm']['ENCRYPTION_KEY']
        self.__getData()

@@ -28,11 +32,11 @@ class EmployeeModel(QAbstractTableModel):
        if 'worklicense' in new_employee:
            new_employee['worklicense'] = int(new_employee['worklicense'])
            new_employee['residencetype'] = int(new_employee['residencetype'])
-        self.__employee_dao.addApplicant(new_employee, self.__key, False)
+        self.__employee_dao.addEmployee(new_employee, self.__key, False)

    @Slot(QJSValue)
    def addApplicant(self, applicant: QJSValue):
-        self.__employee_dao.addApplicant({
+        self.__employee_dao.addEmployee({
            "city": applicant.property("city").toString(),
            "email": applicant.property("email").toString(),
            "firstname": applicant.property("firstname").toString(),
@@ -71,21 +75,35 @@ class EmployeeModel(QAbstractTableModel):
        self.__col_skip = 2
        self.__getData(criterion, criterion == 'Erledigt', False, criterion == 'Alle')

-    def data(self, index, role=Qt.ItemDataRole.DisplayRole):
-        if role == Qt.ItemDataRole.DisplayRole:
+    def data(self, index, role=Qt.DisplayRole):
+        if role == Qt.DisplayRole:
            row = self.__data[index.row()]
            applicant_col = index.column() + self.__col_skip
-            tr = row[applicant_col]
+            tr = row[
+                applicant_col]  # if type(row[index.column() + 2]) is str else str(row[index.column() + 2], "utf-8")
            if applicant_col == 2 and self.__everyone:
                tr = 'Ja' if tr == 1 else 'Nein'
            else:
                if tr:
                    tr = re.sub("Keine Angabe ", "", tr)
+            # print(f"Data: {tr}")
+            # return row[index.column() + 2]
            return tr
        return None

-    def headerData(self, section, orientation, role=Qt.ItemDataRole.DisplayRole):
-        if orientation == Qt.Orientation.Horizontal and role == Qt.ItemDataRole.DisplayRole:
+    def headerData(self, section, orientation, role=Qt.DisplayRole):
+        if orientation == Qt.Horizontal and role == Qt.DisplayRole:
            self.__col_name = self.__visible_columns[section + self.__col_skip]
            return self.__col_name
        return super().headerData(section, orientation, role)
+
+    @Slot(int)
+    def onRowClicked(self, row):
+        # print(self.__data)
+        print(f"Selected table row: {row}, corresponding DB ID: {self.__data[row][0]}")
+        # if not self.__employee_dict['employee'] or self.__data[row][0] != self.__employee_dict['employee']['id']:
+        # self.__employee = self.__employee_dao.getEmployee(self.__data[row][0], self.__key)
+        # print(self.__business)
+        # self.__getEmployeeInfo()
+        # self.__getContactInfo()
+        # print(self.__business_dict)
--- a/lib/DB/ObjectDAO.py
+++ b/lib/DB/ObjectDAO.py
@@ -1,14 +1,17 @@
+from .DbManager import DbManager
 import json
 import mariadb
 from PySide6.QtCore import QObject, Signal
-from lib.domain.BaseModel import database
+# from ..PyqcrmFlags import PyqcrmAppliEmpyFlags
+

 class ObjectDAO(QObject):
    newObjectAdded = Signal(bool, int)

    def __init__(self):
        super().__init__()
-        self.__con = database.connection()
+        #print(f"*** File: {__file__}, __init__()")
+        self.__con = DbManager().getConnection()
        if self.__con:
            self.__cur = self.__con.cursor()

--- a/lib/DB/ObjectModel.py
+++ b/lib/DB/ObjectModel.py
@@ -22,7 +22,7 @@ class ObjectModel(QAbstractTableModel):
        super().__init__()
        self.__object_dao = ObjectDAO()
        self.__object_dao.newObjectAdded.connect(self.__refreshView)
-        self.__conf = ConfigLoader().get_config()
+        self.__conf = ConfigLoader().getConfig()
        self.__key = self.__conf['pyqcrm']['ENCRYPTION_KEY']
        self.__object_dao.newObjectAdded.connect(self.objectAdded)
        self.__getData()
--- a/lib/DB/UserDAO.py
+++ b/lib/DB/UserDAO.py
@@ -1,21 +1,20 @@
 # This Python file uses the following encoding: utf-8
+from .DbManager import DbManager
 from ..PyqcrmFlags import PyqcrmFlags
 import mariadb
 from PySide6.QtCore import QObject, Signal
-from lib.domain.BaseModel import database
-

 class UserDAO(QObject):
    noDbConnection = Signal(str)
    __cursor = None
-
    def __init__(self):
+        #print(f"*** File: {__file__}, init()")
        super().__init__()
-        self.__con = database.connection()
+        self.__con = DbManager().getConnection()
        if self.__con:
            self.__cur = self.__con.cursor()

-    def createUser(self, username, password, info, role=PyqcrmFlags.USER):
+    def createUser(self, username, password, info, role= PyqcrmFlags.USER):
        user_created = False
        try:
            if self.__cur:
@@ -40,3 +39,6 @@ class UserDAO(QObject):
        except mariadb.Error as e:
            print(str(e))
            self.noDbConnection.emit(str(e))
+
+
+
--- a/lib/DB/UserManager.py
+++ b/lib/DB/UserManager.py
@@ -1,28 +1,35 @@
-from PySide6.QtCore import Slot, QObject, Signal
-
-from lib.domain.BaseModel import database
-from .UserDAO import UserDAO
+from .DbManager import DbManager
 from ..PyqcrmFlags import PyqcrmFlags
 from ..Vermasseln import Vermasseln
+#from PySide6.QtMultimedia import QMediaPlayer, QAudioOutput : Not working well with Nuitka
+import soundfile as sf
+import sounddevice as sd
+from .UserDAO import UserDAO
+from PySide6.QtCore import Slot, QObject, Signal, QUrl, QFile
+import tempfile
+


 class UserManager(QObject):
+
    loginOkay = Signal()
    noDbConnection = Signal(str)

-    def __init__(self, user_config=None, role=None):
+    def __init__(self, user_config = None, role = None):
        super().__init__()
-        self.__con = database.connection()
+        self.__con = DbManager().getConnection()
        self.__user_dao = UserDAO()
        self.__user_dao.noDbConnection.connect(self.noDbConnection)
        if self.__con:
            self.__cur = self.__con.cursor()
            if user_config and role:
+
                self.__username = user_config["PYQCRM_USER"]
                self.__password = user_config["PYQCRM_USER_PASS"]
                self.__info = user_config["PYQCRM_USER_INFO"]
                self.__role = role if role == PyqcrmFlags.ADMIN else 0

+
    def createUser(self):
        self.__hashPassword()
        user_created = self.__user_dao.createUser(self.__username, self.__password, self.__info, self.__role)
@@ -57,6 +64,25 @@ class UserManager(QObject):
        user = self.__user_dao.getUser(username)
        if user:
            self.__checkPassword(password, user[2])
+        else:
+            fail_src = ":/sounds/fail2c.ogg"
+            with tempfile.NamedTemporaryFile(suffix='.ogg') as ogg_file:
+                failure_sound = QFile(fail_src)
+                if not failure_sound.open(QFile.ReadOnly):
+                    print(f"Failed to open resource file: {fail_src}")
+                else:
+                    ogg_file.write(failure_sound.readAll())
+                    ogg_path = ogg_file.name
+                    fail, samplerate = sf.read(ogg_path)
+                    sd.play(fail, samplerate)
+
+            ### Not working with Nuitka
+            # player = QMediaPlayer(self)
+            # audioOutput = QAudioOutput(self)
+            # player.setAudioOutput(audioOutput)
+            # player.setSource(QUrl("qrc:/sounds/fail2c.ogg"))
+            # audioOutput.setVolume(150)
+            # player.play()

    def __checkPassword(self, password, hash_password):
        pw_list = hash_password.split("$")
@@ -64,3 +90,6 @@ class UserManager(QObject):
        hash_pw = Vermasseln.userPasswordHash(password, pw_list[0])
        if hash_password == hash_pw:
            self.loginOkay.emit()
+
+
+
--- a/lib/Vermasseln.py
+++ b/lib/Vermasseln.py
@@ -2,6 +2,7 @@
 from Crypto.Cipher import AES
 from base64 import b64encode, b64decode
 import platform
+import bcrypt
 from Crypto.Hash import SHA256, SHA3_512
 from Crypto.Protocol.KDF import PBKDF2
 from Crypto.Random import get_random_bytes
--- a/lib/domain/Applicant.py
+++ b/lib/domain/Applicant.py
@@ -1,44 +0,0 @@
-from peewee import CharField, UUIDField, SmallIntegerField, TextField, ForeignKeyField, JOIN
-
-from lib.domain.Town import Town
-from lib.domain.BaseModel import BaseModel
-from lib.domain.ZipCode import ZipCode
-
-
-class Applicant(BaseModel):
-    class Meta:
-        table_name = "applicants"
-
-    id = UUIDField(primary_key=True)
-    title = SmallIntegerField(default=0)
-    first_name = CharField(null=False)
-    last_name = CharField(null=False)
-    street = CharField()
-    house_number = CharField()
-    zip_code = ForeignKeyField(ZipCode, column_name="zip_code", null=True)
-    phone_number = CharField()
-    mobile_number = CharField()
-    email_address = CharField()
-    salutation = TextField(null=False)
-
-    @classmethod
-    def select_table_data(cls, search_query: str):
-        return (
-            Applicant
-            .select(
-                Applicant.id,
-                Applicant.first_name,
-                Applicant.last_name,
-                ZipCode.id,
-                ZipCode.zip_code,
-                Town.town
-            )
-            .join(ZipCode, join_type="LEFT JOIN")
-            .join(Town, join_type="LEFT JOIN")
-            .where(
-                (Applicant.first_name.contains(search_query)) |
-                (Applicant.last_name.contains(search_query)) |
-                (ZipCode.zip_code.contains(search_query)) |
-                (Town.town.contains(search_query))
-            )
-        )
--- a/lib/domain/BaseModel.py
+++ b/lib/domain/BaseModel.py
@@ -1,22 +0,0 @@
-from peewee import Model, MySQLDatabase
-
-from lib.Config import DatabaseConfig
-
-database: MySQLDatabase = MySQLDatabase(None)
-
-
-def init_database_from_config(config: DatabaseConfig):
-    database.init(
-        host=config['DB_HOST'],
-        user=config['DB_USER'],
-        password=config['DB_PASS'],
-        database=config['DB_NAME'],
-        port=int(config['DB_PORT']),
-        connect_timeout=5,
-    )
-    database.connect()
-
-
-class BaseModel(Model):
-    class Meta:
-        database = database
--- a/lib/domain/Country.py
+++ b/lib/domain/Country.py
@@ -1,14 +0,0 @@
-from peewee import AutoField, CharField
-
-from lib.domain.BaseModel import BaseModel
-
-
-class Country(BaseModel):
-    class Meta:
-        table_name = "country"
-    id = AutoField(column_name="countryid")
-    name = CharField(max_length=200, unique=True)
-    name_short = CharField(max_length=100, column_name="countryshort")
-    nationality = CharField(max_length=100)
-    iso2 = CharField(max_length=2, unique=True)
-    iso3 = CharField(max_length=3, unique=True)
--- a/lib/domain/Town.py
+++ b/lib/domain/Town.py
@@ -1,12 +0,0 @@
-from peewee import AutoField, CharField, ForeignKeyField
-
-from lib.domain.BaseModel import BaseModel
-from lib.domain.Country import Country
-
-
-class Town(BaseModel):
-    class Meta:
-        table_name = "address"
-    id = AutoField(column_name="addressid")
-    town = CharField(max_length=50, column_name="city")
-    country = ForeignKeyField(Country, column_name="countryid",  backref="towns")
--- a/lib/domain/ZipCode.py
+++ b/lib/domain/ZipCode.py
@@ -1,13 +0,0 @@
-from peewee import AutoField, CharField, ForeignKeyField
-
-from lib.domain.BaseModel import BaseModel
-from lib.domain.Town import Town
-
-
-class ZipCode(BaseModel):
-    class Meta:
-        table_name = "postcode"
-
-    id = AutoField(column_name="postcodeid")
-    zip_code = CharField(max_length=15, column_name="postcode")
-    town = ForeignKeyField(Town, backref="zip_codes", column_name="addressid")
--- a/main.py
+++ b/main.py
@@ -1,35 +1,44 @@
 # # !/home/linuxero/proj/tero/pyqcrm/.qtcreator/venv-3.13.1/bin/python3
 import os
 import sys
-# noinspection PyUnresolvedReferences
-import rc_pyqcrm
-# noinspection PyUnresolvedReferences
-import rc_qml
-
-from PySide6.QtCore import QIODevice
-from PySide6.QtGui import QGuiApplication, QIcon
+import logging
 from PySide6.QtNetwork import QLocalServer, QLocalSocket
-from PySide6.QtQml import QQmlApplicationEngine
 from PySide6.QtWidgets import QSystemTrayIcon
-
+from PySide6.QtGui import QGuiApplication, QIcon
+from PySide6.QtQml import QQmlApplicationEngine
+from PySide6.QtCore import QIODevice
 from lib.ConfigLoader import ConfigLoader
-from lib.DB.AddressModel import AddressModel
-from lib.DB.ApplicantModel import ApplicantModel
-from lib.DB.BTypeModel import BTypeModel
 from lib.DB.BusinessModel import BusinessModel
+import rc_pyqcrm
+import rc_qml
+from lib.DB.DbManager import DbManager
+from lib.DB.UserManager import UserManager
+from lib.DB.AddressModel import AddressModel
+from lib.DB.BTypeModel import BTypeModel
 from lib.DB.ContactModel import ContactModel
 from lib.DB.EmployeeModel import EmployeeModel
 from lib.DB.ObjectModel import ObjectModel
-from lib.DB.UserManager import UserManager
 from lib.Printers import Printers
-from lib.domain.BaseModel import database, init_database_from_config

 os.environ['QML_XHR_ALLOW_FILE_READ'] = '1'

+
+# [pyqcrm]
+# program-name=""
+# version=
+
+# [database]
+# server=""
+# port=
+# user=""
+# password=""
+# name=""
+# type=""
+
+
 bad_config = False
 db_con = False
 address_model = None
-applicant_model = None
 business_model = None
 business_type = None
 contact_model = None
@@ -40,17 +49,17 @@ user = None


 def initializeProgram():
-    global address_model, applicant_model, bad_config, business_model, user, business_type, contact_model, employee_model, object_model, db_con, printers
+    print(f"In {__file__} file, initializeProgram()")
+    global address_model, bad_config, business_model, user, business_type, contact_model, employee_model, object_model, db_con, printers
    if not bad_config:
-        init_database_from_config(config.get_config()['database'])
-
+        dbconf = config.getConfig()['database']
+        DbManager(dbconf)
        printers = Printers()
-        if not database.is_closed():
+        if DbManager().getConnection():
            db_con = True
            user = UserManager()
            business_model = BusinessModel()
            address_model = AddressModel()
-            applicant_model = ApplicantModel()
            business_type = BTypeModel()
            contact_model = ContactModel()
            employee_model = EmployeeModel()
@@ -65,11 +74,11 @@ def configReady():


 def publishContext():
-    global engine, address_model, applicant_model, bad_config, business_model, user, business_type, contact_model, object_model, employee_model, printers
+    # print(f"In {__file__} file, publishContext()")
+    global engine, address_model, bad_config, business_model, user, business_type, contact_model, object_model, employee_model, printers
    engine.rootContext().setContextProperty("loggedin_user", user)
    engine.rootContext().setContextProperty("business_model", business_model)
    engine.rootContext().setContextProperty("address_model", address_model)
-    engine.rootContext().setContextProperty("applicantModel", applicant_model)
    engine.rootContext().setContextProperty("business_type", business_type)
    engine.rootContext().setContextProperty("contact_model", contact_model)
    engine.rootContext().setContextProperty("employee_model", employee_model)
@@ -96,7 +105,7 @@ if __name__ == "__main__":

    qml_file = "qrc:/Gui/main.qml"

-    icon = QIcon("qrc:/images/tero.jpg")
+    icon = QIcon(":/images/tero.jpg")
    app.setWindowIcon(icon)

    tray = QSystemTrayIcon()
@@ -105,7 +114,7 @@ if __name__ == "__main__":

    config = ConfigLoader()

-    if not config.get_config():
+    if not config.getConfig():
        bad_config = True
        config.configurationReady.connect(configReady)
    else:
--- a/pyqcrm.pyproject
+++ b/pyqcrm.pyproject
@@ -7,6 +7,7 @@
        "lib/DB/BusinessModel.py",
        "pyqcrm.qrc",
        "qml.qrc",
+        "lib/DB/DbManager.py",
        "lib/DB/UserManager.py",
        "lib/PyqcrmFlags.py",
        "lib/DB/UserDAO.py",
--- a/pyqcrm.qrc
+++ b/pyqcrm.qrc
@@ -9,7 +9,6 @@
        <file>images/ChevronDown.svg</file>
        <file>images/Funnel.svg</file>
        <file>images/Identification-Outline.svg</file>
-        <file>images/InboxArrowDown.svg</file>
        <file>images/MagnifyingGlass.svg</file>
        <file>images/Newspaper-Outline.svg</file>
        <file>images/Phone.svg</file>
@@ -20,8 +19,14 @@
        <file>images/UserCircle.svg</file>
        <file>images/UserGroup-Outline.svg</file>
        <file>images/Wallet-Outline.svg</file>
+        <file>sounds/error.ogg</file>
+        <file>sounds/fail2c.ogg</file>
+        <file>sounds/puzzerr.ogg</file>
+        <file>sounds/sysnotify.ogg</file>
+        <file>sounds/wrong.ogg</file>
        <file>fonts/RobotoCondensed.otf</file>
        <file>README</file>
        <file>LICENSE</file>
+        <file>images/tero.jpg</file>
    </qresource>
 </RCC>
--- a/qml.qrc
+++ b/qml.qrc
@@ -39,11 +39,11 @@
        <file>Gui/OffersTable.qml</file>
        <file>Gui/Employees/AddApplicant.qml</file>
        <file>Gui/Employees/AddEmployee.qml</file>
+        <file>Gui/Employees/ApplicantPersonalData.qml</file>
+        <file>Gui/Employees/ApplicantBankData.qml</file>
        <file>Gui/Employees/ApplicantForm.qml</file>
-        <file>Gui/Employees/EmployeePersonalData.qml</file>
-        <file>Gui/Employees/EmployeeBankData.qml</file>
-        <file>Gui/Employees/EmployeeNationalInsurance.qml</file>
-        <file>Gui/Employees/EmployeeVarious.qml</file>
+        <file>Gui/Employees/ApplicantNationalInsurance.qml</file>
+        <file>Gui/Employees/ApplicantVarious.qml</file>
        <file>Gui/Employees/EmployeeDetails.qml</file>
        <file>Gui/Employees/EmployeesTable.qml</file>
        <file>Gui/Employees/qmldir</file>
--- a/requirements.txt
+++ b/requirements.txt
@@ -3,8 +3,7 @@ platformdirs
 pycryptodome
 psutil
 toml
+mariadb
 soundfile
 sounddevice
 reportlab
-peewee
-pymysql
--- a/sounds/error.aac
+++ b/sounds/error.aac
--- a/sounds/error.ac3
+++ b/sounds/error.ac3
--- a/sounds/error.mp3
+++ b/sounds/error.mp3
--- a/sounds/error.ogg
+++ b/sounds/error.ogg
--- a/sounds/error.wav
+++ b/sounds/error.wav
--- a/sounds/fail2c.ogg
+++ b/sounds/fail2c.ogg
--- a/sounds/puzzerr.ogg
+++ b/sounds/puzzerr.ogg
--- a/sounds/sysnotify.ogg
+++ b/sounds/sysnotify.ogg
--- a/sounds/wrong.ogg
+++ b/sounds/wrong.ogg
Author	SHA256	Message	Date
Daniel Stoppek	3ff830b3e2	new Diagrams	2025-05-09 10:59:11 +02:00
Daniel Stoppek	2dab5883e2	Merge branch 'main' into schnacke	2025-05-08 11:47:47 +02:00
Daniel Stoppek	0ee3a5f8b3	Need to	2025-04-28 13:46:21 +02:00
Daniel Stoppek	0e397619f4	Merge branch 'main' into schnacke merge main	2025-03-25 13:41:40 +01:00
Daniel Stoppek	d4ed18aaf9	filter names changed	2025-03-25 13:41:01 +01:00