database.h

Zobrazit dokumentaci tohoto souboru.

#ifndef _Database_H_
#define _Database_H_
 
#include <QObject>
#include <QVariant>
#include <QStringList>
#include <QDate>
#include "authenticateduser.h"
#include "dbt.h"
#include "database_plugin.h"
 
 
namespace Db {
 
struct PluginDescription {
    QString     name;
    QString     description;
    PluginDescription(const QString& n, const QString& d) { name=n; description=d; }
};

class Database : public QObject {
    Q_OBJECT
    Db::Plugins::DatabasePlugin *m_dbplugin;
 
  public:
 
   ~Database();
    static Database *instance(QObject *parent = nullptr);
    static Database *create(QObject *parent);
    static Database *create(QObject *parent, const AuthenticatedUser *u);
    bool isOpen() const { return m_isOpen; }
    QString     connectionName() const;
 
    void                                    changePassword(const QString& login, const QString& oldpassword, const QString& newpassword);
    QList<Dbt::Users>                       authenticate(const QString& user, const QString& password);
    QList<Dbt::Users>                       users(int id = -1);
    QList<Dbt::Categories>                  categories(const QString& id = QString());
    QList<Dbt::Categories>                  categoriesToRoot(const QString& id);
    QList<Dbt::Categories>                  subcategories(const QString& parent = QString());
    QList<Dbt::Categories>                  siblingcategories(const QString& parent = QString());
    QList<Dbt::UsersCategories>             usersCategories(int id = -1, int user = -1, const QString& category = QString());
    QList<Dbt::CategoriesOverview>          categoriesOverview(const QStringList& statuses);
    QList<Dbt::StatusOrder>                 statusOrder(const QString& id = QString());
    QList<Dbt::Statuses>                    statuses(const QString& id = QString());
    QList<Dbt::Statuses>                    statuses(const QString& category, const QString& prevStatus);
    QList<Dbt::Statuses>                    statuses(const QString& category, const QStringList& prevStatuses);
 
    QList<Dbt::StatusTemplates>             statusTemplates(int id = -1);
 
    QList<Dbt::Tickets>                     tickets(bool all = false);
    QList<Dbt::Tickets>                     tickets(int ticket = -1, bool all = false);
    QList<Dbt::Tickets>                     tickets(const Dbt::Categories& category, bool all = false);
 
    QList<Dbt::TicketsVw>                   ticketsVw(bool all = false);
    QList<Dbt::TicketsVw>                   ticketsVw(int ticket = -1, bool all = false);
    QList<Dbt::TicketsVw>                   ticketsVw(const Dbt::Categories& category, bool all = false);
 
    QList<Dbt::TicketStatus>                ticketStatus(int id);
    QList<Dbt::TicketStatus>                ticketStatus(bool all = false);
    QList<Dbt::TicketStatus>                ticketStatus(int ticket, bool all);
 
    QList<Dbt::TicketValues>                ticketValues(int id);
    QList<Dbt::TicketValues>                ticketValues(bool all = false);
    QList<Dbt::TicketValues>                ticketValues(int ticket, bool all);
 
    QList<Dbt::TicketFiles>                 ticketFiles(int id);
    QList<Dbt::TicketFiles>                 ticketFiles(bool all = false);
    QList<Dbt::TicketFiles>                 ticketFiles(int ticket, bool all);
 
    QList<Dbt::TicketTimesheets>            ticketTimesheets(int id);
    QList<Dbt::TicketTimesheets>            ticketTimesheets(bool all = false);
    QList<Dbt::TicketTimesheets>            ticketTimesheets(int ticket, bool all);
    QList<Dbt::TicketTimesheets>            runningTimesheets(int ticket = -1);
    QList<Dbt::TicketTimesheets>            startTimesheet(int ticket);
    QList<Dbt::TicketTimesheets>            stopTimesheet(int ticket);
    QList<Dbt::TicketTimesheets>            toggleTimesheet(int ticket);
 
    QList<Dbt::ClientSettings>              clientSettings();
    QList<Dbt::Overview>                    overview(const QString& category, const QStringList& statuses);
    QList<Dbt::Overview>                    overview(const QString& overviewId);
    QList<Dbt::OverviewList>                overviewList();
    QList<Dbt::ServerInfo>                  serverInfo();
 
    QList<Dbt::Departments>                 departments(int department = -1);
    QList<Dbt::Employees>                   employees(int employees = -1);
    QList<Dbt::Doors>                       doors(int door = -1);
    QList<Dbt::EventTypes>                  eventTypes(const QString& eventType = QString());
    QList<Dbt::Events>                      events(int event = -1,
                                                  int employee = -1,
                                                  const QDate& month = QDate(),
                                                  int limit = -1,
                                                  int offset = -1);
    QList<Dbt::Rfids>                       rfids(int rfid = -1);
    QList<Dbt::Rfids>                       rfidsById(const QString& rfidId);
    QList<Dbt::Holidays>                    holidays(const QDate& date = QDate());
    QList<Dbt::WorkCalendar>                workCalendar(const QDate& period = QDate());
    void                                    generateWorkCalendar(int year);
    void                                    copyHolidays(int fromYear, int toYear);
    QList<Dbt::EmployeeCanOpenDoor>         employeeCanOpenDoor(const Dbt::EmployeeCanOpenDoor&);
    QList<Dbt::EmployeeHasRfid>             employeeHasRfid(const Dbt::EmployeeHasRfid&);
    QList<Dbt::DepartmentHasMember>         departmentHasMember(const Dbt::DepartmentHasMember&);
    QList<Dbt::DepartmentHasManager>        departmentHasManager(const Dbt::DepartmentHasManager&);
 
    QList<Dbt::AttendanceChecklist>         attendanceChecklist(int employee, const QDate& month);
    QList<Dbt::Employees>                   attendanceChecklist(const QDate& month);
    QList<Dbt::AttendanceSummary>           attendanceSummary(int employee, const QDate& month);
    QList<Dbt::AttendancePresent>           attendancePresent();
    QList<Dbt::AttendanceRecent>            attendanceRecent(int employee);
 
    Dbt::UserEmployeeAccess                 canAccessAttendance(int employee);
 
    QVariant                                save(const Dbt::AttendanceSummary& data);
 
    template<typename T> QVariant save(const T& id) { return m_dbplugin->save(id); }
    template<typename T> void remove(const T& id) { m_dbplugin->remove(id); }
 
    void        begin();
    void        commit();
 
  signals:
    void    opened(bool);
 
  public slots:
    bool    open();
    void    close();
 
  private slots:
 
  private:
    static Database *m_instance;
    Database(QObject *parent);
    bool m_isOpen;
 
};
 
}
 
#endif