initial merge of qt client

9 files changed, 491 insertions, 39 deletions

diff --git a/client/client.pro b/client/client.pro
index cd0990a..0de0a33 100644
--- a/client/client.pro
+++ b/client/client.pro
@@ -1,14 +1,23 @@
-QT += charts
+QT += core gui sql charts
 
 HEADERS += \
-    chart.h \
-    chartview.h
+    dbconnector.h \
+    main.h \
+    mainwindow.h
+#   chart.h \
+#   chartview.h
 
 SOURCES += \
+    dbconnector.cpp \
     main.cpp \
-    chart.cpp \
-    chartview.cpp
+    mainwindow.cpp
+#   chart.cpp \
+#   chartview.cpp
+
+
+FORMS += \
+    dbconnector.ui \
+    mainwindow.ui
 
-target.path = $$[QT_INSTALL_EXAMPLES]/charts/zoomlinechart
 INSTALLS += target
 CONFIG += force_debug_info
diff --git a/client/dbconnector.cpp b/client/dbconnector.cpp
new file mode 100644
index 0000000..5ed1efc
--- /dev/null
+++ b/client/dbconnector.cpp
@@ -0,0 +1,49 @@
+#include "dbconnector.h"
+#include "ui_dbconnector.h"
+#include "main.h"
+
+//#include "mainwindow.h"
+
+dbConnector::dbConnector(QWidget *parent) :
+    QDialog(parent),
+    ui(new Ui::dbConnector)
+{
+    ui->setupUi(this);
+}
+
+dbConnector::~dbConnector()
+{
+    delete ui;
+}
+
+void dbConnector::on_pushButton_cancel_clicked()
+{
+    dbConnector::~dbConnector();
+}
+
+void dbConnector::on_pushButton_login_clicked()
+{
+    QString hostname = ui->lineEdit_adress->text();
+    QString username = ui->lineEdit_username->text();
+    QString password = ui->lineEdit_password->text();
+    QString databaseName = "thecrapbox";
+
+//    QSqlDatabase db = MainWindow.loginDb(adress, username, password);
+
+//    QSqlDatabase db = QSqlDatabase::addDatabase("QMYSQL");
+//    return;
+    dbRef.setHostName(hostname);
+    dbRef.setUserName(username);
+    dbRef.setPassword(password);
+    dbRef.setDatabaseName("thecrapbox");
+
+    if(dbRef.open()){
+        QMessageBox::information(this, "Connection", "GREAT SUCCES!");
+    } else {
+        QMessageBox::warning(this, "No connection", "Failed to connect");
+    }
+}
+
+
+
+
diff --git a/client/dbconnector.h b/client/dbconnector.h
new file mode 100644
index 0000000..cd722eb
--- /dev/null
+++ b/client/dbconnector.h
@@ -0,0 +1,34 @@
+#pragma once
+
+#include <QDialog>
+
+#include <QMessageBox>
+//#include <QtSql>
+//#include <QSqlDatabase>
+
+//#include "database.h"
+
+namespace Ui {
+class dbConnector;
+}
+
+class dbConnector : public QDialog
+{
+    Q_OBJECT
+
+public:
+    explicit dbConnector(QWidget *parent = nullptr);
+    ~dbConnector();
+
+private slots:
+//    void on_pushButton_clicked();
+
+    void on_pushButton_cancel_clicked();
+
+    void on_pushButton_login_clicked();
+
+private:
+    Ui::dbConnector *ui;
+
+//    Database database;
+};
diff --git a/client/dbconnector.ui b/client/dbconnector.ui
new file mode 100644
index 0000000..21d241f
--- /dev/null
+++ b/client/dbconnector.ui
@@ -0,0 +1,141 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<ui version="4.0">
+ <class>dbConnector</class>
+ <widget class="QDialog" name="dbConnector">
+  <property name="geometry">
+   <rect>
+    <x>0</x>
+    <y>0</y>
+    <width>362</width>
+    <height>273</height>
+   </rect>
+  </property>
+  <property name="windowTitle">
+   <string>Dialog</string>
+  </property>
+  <widget class="QWidget" name="formLayoutWidget">
+   <property name="geometry">
+    <rect>
+     <x>60</x>
+     <y>60</y>
+     <width>241</width>
+     <height>173</height>
+    </rect>
+   </property>
+   <layout class="QFormLayout" name="formLayout">
+    <item row="0" column="0">
+     <widget class="QLabel" name="label_3">
+      <property name="text">
+       <string>Adress</string>
+      </property>
+     </widget>
+    </item>
+    <item row="0" column="1">
+     <widget class="QLineEdit" name="lineEdit_adress">
+      <property name="text">
+       <string>localhost</string>
+      </property>
+      <property name="placeholderText">
+       <string>Hostname/IP-Adress</string>
+      </property>
+     </widget>
+    </item>
+    <item row="1" column="0">
+     <widget class="QLabel" name="label_4">
+      <property name="text">
+       <string>Database</string>
+      </property>
+     </widget>
+    </item>
+    <item row="1" column="1">
+     <widget class="QLineEdit" name="lineEdit_database">
+      <property name="placeholderText">
+       <string>Database name</string>
+      </property>
+     </widget>
+    </item>
+    <item row="2" column="0" colspan="2">
+     <widget class="Line" name="line">
+      <property name="orientation">
+       <enum>Qt::Horizontal</enum>
+      </property>
+     </widget>
+    </item>
+    <item row="3" column="0">
+     <widget class="QLabel" name="label">
+      <property name="text">
+       <string>Username</string>
+      </property>
+     </widget>
+    </item>
+    <item row="3" column="1">
+     <widget class="QLineEdit" name="lineEdit_username">
+      <property name="text">
+       <string>root</string>
+      </property>
+      <property name="echoMode">
+       <enum>QLineEdit::PasswordEchoOnEdit</enum>
+      </property>
+      <property name="placeholderText">
+       <string>Username</string>
+      </property>
+     </widget>
+    </item>
+    <item row="4" column="0">
+     <widget class="QLabel" name="label_2">
+      <property name="text">
+       <string>Password</string>
+      </property>
+     </widget>
+    </item>
+    <item row="4" column="1">
+     <widget class="QLineEdit" name="lineEdit_password">
+      <property name="font">
+       <font>
+        <underline>false</underline>
+        <strikeout>false</strikeout>
+        <kerning>true</kerning>
+       </font>
+      </property>
+      <property name="text">
+       <string/>
+      </property>
+      <property name="echoMode">
+       <enum>QLineEdit::Password</enum>
+      </property>
+      <property name="placeholderText">
+       <string>Password</string>
+      </property>
+     </widget>
+    </item>
+    <item row="5" column="0">
+     <widget class="QLabel" name="connectLabel">
+      <property name="text">
+       <string>Connect</string>
+      </property>
+     </widget>
+    </item>
+    <item row="5" column="1">
+     <layout class="QHBoxLayout" name="horizontalLayout">
+      <item>
+       <widget class="QPushButton" name="pushButton_login">
+        <property name="text">
+         <string>Login</string>
+        </property>
+       </widget>
+      </item>
+      <item>
+       <widget class="QPushButton" name="pushButton_cancel">
+        <property name="text">
+         <string>Cancel</string>
+        </property>
+       </widget>
+      </item>
+     </layout>
+    </item>
+   </layout>
+  </widget>
+ </widget>
+ <resources/>
+ <connections/>
+</ui>
diff --git a/client/main.cpp b/client/main.cpp
index 28a3d91..84706bf 100644
--- a/client/main.cpp
+++ b/client/main.cpp
@@ -1,42 +1,33 @@
-/****************************************************************************
-**
-** Copyright (C) 2016 The Qt Company Ltd.
-** Contact: https://www.qt.io/licensing/
-**
-** This file is part of the Qt Charts module of the Qt Toolkit.
-**
-** $QT_BEGIN_LICENSE:GPL$
-** Commercial License Usage
-** Licensees holding valid commercial Qt licenses may use this file in
-** accordance with the commercial license agreement provided with the
-** Software or, alternatively, in accordance with the terms contained in
-** a written agreement between you and The Qt Company. For licensing terms
-** and conditions see https://www.qt.io/terms-conditions. For further
-** information use the contact form at https://www.qt.io/contact-us.
-**
-** GNU General Public License Usage
-** Alternatively, this file may be used under the terms of the GNU
-** General Public License version 3 or (at your option) any later version
-** approved by the KDE Free Qt Foundation. The licenses are as published by
-** the Free Software Foundation and appearing in the file LICENSE.GPL3
-** included in the packaging of this file. Please review the following
-** information to ensure the GNU General Public License requirements will
-** be met: https://www.gnu.org/licenses/gpl-3.0.html.
-**
-** $QT_END_LICENSE$
-**
-****************************************************************************/
-
-#include "chart.h"
-#include "chartview.h"
 #include <QtWidgets/QApplication>
 #include <QtWidgets/QMainWindow>
 #include <QtCore/QtMath>
 #include <QtCore/QRandomGenerator>
 #include <QtCharts/QLineSeries>
 #include <QtCharts/QValueAxis>
+#include <QApplication>
+#include <QMessageBox>
+#include <iostream>
+#include <stdio.h>
+
+#include "chart.h"
+#include "chartview.h"
+#include "mainwindow.h"
+#include "main.h"
+#include "ui_mainwindow.h"
 
-QT_CHARTS_USE_NAMESPACE
+QSqlDatabase dbRef = QSqlDatabase();
+
+int main(int argc, char *argv[])
+{
+    QApplication a(argc, argv);
+    MainWindow w;
+    dbRef = QSqlDatabase::addDatabase("QMYSQL");
+
+    w.show();
+    return a.exec();
+}
+
+/* QT_CHARTS_USE_NAMESPACE
 
 int main(int argc, char *argv[])
 {
@@ -69,4 +60,4 @@ int main(int argc, char *argv[])
     window.show();
 
     return a.exec();
-}
+} */
diff --git a/client/main.h b/client/main.h
new file mode 100644
index 0000000..010f2e6
--- /dev/null
+++ b/client/main.h
@@ -0,0 +1,8 @@
+#pragma once
+
+#include <QSql>
+#include <QSqlDatabase>
+
+int main(int argc, char *argv[]);
+extern QSqlDatabase dbRef;
+
diff --git a/client/mainwindow.cpp b/client/mainwindow.cpp
new file mode 100644
index 0000000..955307e
--- /dev/null
+++ b/client/mainwindow.cpp
@@ -0,0 +1,50 @@
+#include <QSqlDatabase>
+
+#include "mainwindow.h"
+#include "ui_mainwindow.h"
+#include "main.h"
+
+MainWindow::MainWindow(QWidget *parent)
+    : QMainWindow(parent)
+    , ui(new Ui::MainWindow)
+{
+//    db = QSqlDatabase::addDatabase("QMYSQL");
+    ui->setupUi(this);
+}
+
+MainWindow::~MainWindow()
+{
+    dbRef.close();
+    delete ui;
+}
+
+void MainWindow::on_actionAbout_triggered()
+{
+    QMessageBox::warning(this, "Oops..", "Task Failed succesfully ;)");
+}
+
+
+void MainWindow::on_pushButton_clicked()
+{
+//    dbRef = QSqlDatabase::addDatabase("QMYSQL");
+//    dbRef.setHostName("localhost");
+//    dbRef.setUserName("root");
+//    dbRef.setPassword("Ab12345!");
+//    dbRef.setDatabaseName("thecrapbox");
+
+    if(dbRef.open()){
+        QMessageBox::information(this, "Connection", "GREAT SUCCES!");
+        pQueryModel = new QSqlQueryModel();
+        pQueryModel->setQuery("SELECT * FROM opleiding;");
+        ui->tableView->setModel(pQueryModel);
+    } else {
+        QMessageBox::warning(this, "No connection", "Failed to connect");
+    }
+}
+
+void MainWindow::on_actionConnection_triggered()
+{
+    _dbConenctor = new dbConnector(this);
+    _dbConenctor->show();
+}
+
diff --git a/client/mainwindow.h b/client/mainwindow.h
new file mode 100644
index 0000000..1e73657
--- /dev/null
+++ b/client/mainwindow.h
@@ -0,0 +1,42 @@
+#pragma once
+
+#include <QMainWindow>
+
+//#include "database.h"
+#include "dbconnector.h"
+
+#include <QMessageBox>
+#include <QtSql>
+#include <QSqlDatabase>
+#include "main.h"
+
+
+QT_BEGIN_NAMESPACE
+namespace Ui { class MainWindow; }
+QT_END_NAMESPACE
+
+class MainWindow : public QMainWindow
+{
+    Q_OBJECT
+
+public:
+    MainWindow(QWidget *parent = nullptr);
+    ~MainWindow();
+
+private slots:
+    void on_actionAbout_triggered();
+
+    void on_pushButton_clicked();
+
+    void on_actionConnection_triggered();
+
+private:
+    Ui::MainWindow *ui;
+
+    dbConnector *_dbConenctor;
+//    QSqlDatabase db;
+
+    QSqlQueryModel *pQueryModel;
+
+//    Database database;
+};
diff --git a/client/mainwindow.ui b/client/mainwindow.ui
new file mode 100644
index 0000000..f827c85
--- /dev/null
+++ b/client/mainwindow.ui
@@ -0,0 +1,128 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<ui version="4.0">
+ <class>MainWindow</class>
+ <widget class="QMainWindow" name="MainWindow">
+  <property name="geometry">
+   <rect>
+    <x>0</x>
+    <y>0</y>
+    <width>800</width>
+    <height>600</height>
+   </rect>
+  </property>
+  <property name="windowTitle">
+   <string>MainWindow</string>
+  </property>
+  <widget class="QWidget" name="centralwidget">
+   <widget class="QPushButton" name="pushButton">
+    <property name="enabled">
+     <bool>true</bool>
+    </property>
+    <property name="geometry">
+     <rect>
+      <x>310</x>
+      <y>0</y>
+      <width>121</width>
+      <height>41</height>
+     </rect>
+    </property>
+    <property name="text">
+     <string>DoesSomething</string>
+    </property>
+   </widget>
+   <widget class="QWidget" name="verticalLayoutWidget">
+    <property name="geometry">
+     <rect>
+      <x>-10</x>
+      <y>40</y>
+      <width>801</width>
+      <height>401</height>
+     </rect>
+    </property>
+    <layout class="QVBoxLayout" name="verticalLayout">
+     <item>
+      <widget class="QTableView" name="tableView"/>
+     </item>
+    </layout>
+   </widget>
+  </widget>
+  <widget class="QMenuBar" name="menubar">
+   <property name="geometry">
+    <rect>
+     <x>0</x>
+     <y>0</y>
+     <width>800</width>
+     <height>21</height>
+    </rect>
+   </property>
+   <widget class="QMenu" name="menuAbouy">
+    <property name="title">
+     <string>Home</string>
+    </property>
+    <addaction name="actionAbout"/>
+    <addaction name="actionRefresh"/>
+   </widget>
+   <widget class="QMenu" name="menuTEMP">
+    <property name="title">
+     <string>TEMP</string>
+    </property>
+    <addaction name="actionLOAD"/>
+    <addaction name="actionQuerry"/>
+   </widget>
+   <widget class="QMenu" name="menuDatabase">
+    <property name="title">
+     <string>Database</string>
+    </property>
+    <addaction name="actionConnection"/>
+    <addaction name="actionDisconnenct"/>
+    <addaction name="actionStatus"/>
+   </widget>
+   <addaction name="menuAbouy"/>
+   <addaction name="menuTEMP"/>
+   <addaction name="menuDatabase"/>
+  </widget>
+  <widget class="QStatusBar" name="statusbar"/>
+  <action name="actionAbout">
+   <property name="text">
+    <string>About</string>
+   </property>
+  </action>
+  <action name="actionRefresh">
+   <property name="text">
+    <string>Refresh</string>
+   </property>
+  </action>
+  <action name="actionLOAD">
+   <property name="text">
+    <string>Load</string>
+   </property>
+  </action>
+  <action name="actionQuerry">
+   <property name="text">
+    <string>Query</string>
+   </property>
+  </action>
+  <action name="actionConnection">
+   <property name="text">
+    <string>Connect</string>
+   </property>
+  </action>
+  <action name="actionDisconnenct">
+   <property name="text">
+    <string>Disconnenct</string>
+   </property>
+  </action>
+  <action name="actionQuerry_2">
+   <property name="text">
+    <string>Querry</string>
+   </property>
+  </action>
+  <action name="actionStatus">
+   <property name="text">
+    <string>Status</string>
+   </property>
+  </action>
+ </widget>
+ <resources/>
+ <connections/>
+</ui>