Timesheets-Server
Timesheets server
Načítám...
Vyhledávám...
Nebylo nic nalezeno
database_plugin_postgres.h
Zobrazit dokumentaci tohoto souboru.
1
6#ifndef _DatabasePluginPostgres_H_
7#define _DatabasePluginPostgres_H_
8
9#include "database_plugin.h"
10#include "msqlquery.h"
11
12namespace Db {
13namespace Plugins {
14
15
19class DatabasePluginPostgres : public Db::Plugins::DatabasePlugin {
20 Q_OBJECT
21 public:
22 DatabasePluginPostgres(QObject *);
23 ~DatabasePluginPostgres();
24
25 void setDatabaseName(const QString& x) Q_DECL_OVERRIDE { m_databasename = x; }
26 void setHostname(const QString& x) Q_DECL_OVERRIDE { m_hostname = x; }
27 void setPort(int x) Q_DECL_OVERRIDE { m_port = x; }
28 void setUserName(const QString& x) Q_DECL_OVERRIDE { m_username = x; }
29 void setPassword(const QString& x) Q_DECL_OVERRIDE { m_password = x; }
30
31 void changePassword(const QString& login, const QString& oldpassword, const QString& newpassword) Q_DECL_OVERRIDE;
32 QList<Dbt::Users> authenticate(const QString& login, const QString& password) Q_DECL_OVERRIDE;
33 QList<Dbt::Users> users(int id) Q_DECL_OVERRIDE;
34 QList<Dbt::UsersCategories> usersCategories(int id, int user, const QString& category) Q_DECL_OVERRIDE;
35 QList<Dbt::Categories> categories(const QString& id) Q_DECL_OVERRIDE;
36 QList<Dbt::Categories> categoriesToRoot(const QString& id) Q_DECL_OVERRIDE;
37 QList<Dbt::Categories> subcategories(const QString& id) Q_DECL_OVERRIDE;
38 QList<Dbt::Categories> siblingcategories(const QString& id) Q_DECL_OVERRIDE;
39 QList<Dbt::CategoriesOverview> categoriesOverview(const QStringList& statuses) Q_DECL_OVERRIDE;
40 QList<Dbt::StatusOrder> statusOrder(const QString& id) Q_DECL_OVERRIDE;
41 QList<Dbt::Statuses> statuses(const QString&) Q_DECL_OVERRIDE;
42 QList<Dbt::Statuses> statuses(const QString&, const QString&) Q_DECL_OVERRIDE;
43
44 QList<Dbt::StatusTemplates> statusTemplates(int id) Q_DECL_OVERRIDE;
45 QList<Dbt::Tickets> tickets(bool all) Q_DECL_OVERRIDE;
46 QList<Dbt::Tickets> tickets(int ticket, bool all) Q_DECL_OVERRIDE;
47 QList<Dbt::Tickets> tickets(const Dbt::Categories&, bool all) Q_DECL_OVERRIDE;
48 QList<Dbt::TicketsVw> ticketsVw(bool all) Q_DECL_OVERRIDE;
49 QList<Dbt::TicketsVw> ticketsVw(int ticket, bool all) Q_DECL_OVERRIDE;
50 QList<Dbt::TicketsVw> ticketsVw(const Dbt::Categories&, bool all) Q_DECL_OVERRIDE;
51
52 QList<Dbt::TicketStatus> ticketStatus(int id) Q_DECL_OVERRIDE;
53 QList<Dbt::TicketStatus> ticketStatus(int ticket, bool all) Q_DECL_OVERRIDE;
54 QList<Dbt::TicketStatus> ticketStatus(bool all) Q_DECL_OVERRIDE;
55
56 QList<Dbt::TicketValues> ticketValues(int id) Q_DECL_OVERRIDE;
57 QList<Dbt::TicketValues> ticketValues(int ticket, bool all) Q_DECL_OVERRIDE;
58 QList<Dbt::TicketValues> ticketValues(bool all) Q_DECL_OVERRIDE;
59
60 QList<Dbt::TicketFiles> ticketFiles(int id) Q_DECL_OVERRIDE;
61 QList<Dbt::TicketFiles> ticketFiles(int ticket, bool all) Q_DECL_OVERRIDE;
62 QList<Dbt::TicketFiles> ticketFiles(bool all) Q_DECL_OVERRIDE;
63
64 QList<Dbt::TicketTimesheets> ticketTimesheets(int id) Q_DECL_OVERRIDE;
65 QList<Dbt::TicketTimesheets> ticketTimesheets(int ticket, bool all) Q_DECL_OVERRIDE;
66 QList<Dbt::TicketTimesheets> ticketTimesheets(bool all) Q_DECL_OVERRIDE;
67 QList<Dbt::TicketTimesheets> runningTimesheets(int ticket) Q_DECL_OVERRIDE;
68 QList<Dbt::TicketTimesheets> startTimesheet(int ticket) Q_DECL_OVERRIDE;
69 QList<Dbt::TicketTimesheets> stopTimesheet(int ticket) Q_DECL_OVERRIDE;
70 QList<Dbt::TicketTimesheets> toggleTimesheet(int ticket) Q_DECL_OVERRIDE;
71
72 QList<Dbt::ClientSettings> clientSettings() Q_DECL_OVERRIDE;
73 QList<Dbt::Overview> overview(const QString& category, const QStringList& statuses) Q_DECL_OVERRIDE;
74 QList<Dbt::Overview> overview(const QString& overviewId) Q_DECL_OVERRIDE;
75 QList<Dbt::OverviewList> overviewList() Q_DECL_OVERRIDE;
76 QList<Dbt::ServerInfo> serverInfo() Q_DECL_OVERRIDE;
77
78 template<typename T> void save(const QList<T>& list) {
79 QListIterator<T> iterator(list);
80 while (iterator.hasNext()) {
81 save(iterator.next());
82 }
83 }
84
85 void remove(const Dbt::Users& data) Q_DECL_OVERRIDE;
86 void remove(const Dbt::Categories& data) Q_DECL_OVERRIDE;
87 void remove(const Dbt::StatusOrder& data) Q_DECL_OVERRIDE;
88 void remove(const Dbt::Statuses& data) Q_DECL_OVERRIDE;
89 void remove(const Dbt::Tickets& data) Q_DECL_OVERRIDE;
90 void remove(const Dbt::TicketStatus& data) Q_DECL_OVERRIDE;
91 void remove(const Dbt::TicketValues& data) Q_DECL_OVERRIDE;
92 void remove(const Dbt::TicketFiles& data) Q_DECL_OVERRIDE;
93 void remove(const Dbt::TicketTimesheets& data) Q_DECL_OVERRIDE;
94 void remove(const Dbt::OverviewList& data) Q_DECL_OVERRIDE;
95
96
97 QVariant save(const Dbt::Users& data) Q_DECL_OVERRIDE;
98 QVariant save(const Dbt::Categories& data) Q_DECL_OVERRIDE;
99 QVariant save(const Dbt::StatusOrder& data) Q_DECL_OVERRIDE;
100 QVariant save(const Dbt::Statuses& data) Q_DECL_OVERRIDE;
101 QVariant save(const Dbt::Tickets& data) Q_DECL_OVERRIDE;
102 QVariant save(const Dbt::TicketsVw& data) Q_DECL_OVERRIDE;
103 QVariant save(const Dbt::TicketStatus& data) Q_DECL_OVERRIDE;
104 QVariant save(const Dbt::TicketValues& data) Q_DECL_OVERRIDE;
105 QVariant save(const Dbt::TicketFiles& data) Q_DECL_OVERRIDE;
106 QVariant save(const Dbt::TicketTimesheets& data) Q_DECL_OVERRIDE;
107 QVariant save(const Dbt::ServerInfo& data) Q_DECL_OVERRIDE;
108 QVariant save(const Dbt::AppendStatuses& data) Q_DECL_OVERRIDE;
109
110 // docházka
111 QList<Dbt::Departments> departments(int department) Q_DECL_OVERRIDE;
112 QList<Dbt::Doors> doors(int door) Q_DECL_OVERRIDE;
113 QList<Dbt::Employees> employess(int employee) Q_DECL_OVERRIDE;
114 QList<Dbt::EventTypes> eventTypes(const QString& eventType) Q_DECL_OVERRIDE;
115 QList<Dbt::Events> events(int event) Q_DECL_OVERRIDE;
116 QList<Dbt::DepartmentHasManager> departmentHasManager(const Dbt::DepartmentHasManager&) Q_DECL_OVERRIDE;
117 QList<Dbt::DepartmentHasMember> departmentHasMember(const Dbt::DepartmentHasMember&) Q_DECL_OVERRIDE;
118 QList<Dbt::EmployeeCanOpenDoor> employeeCanOpenDoor(const Dbt::EmployeeCanOpenDoor&) Q_DECL_OVERRIDE;
119 QList<Dbt::EmployeeHasRfid> employeeHasRfid(const Dbt::EmployeeHasRfid&) Q_DECL_OVERRIDE;
120
121 virtual void remove(const Dbt::Departments& data) Q_DECL_OVERRIDE;
122 virtual void remove(const Dbt::Doors& data) Q_DECL_OVERRIDE;
123 virtual void remove(const Dbt::Employees& data) Q_DECL_OVERRIDE;
124 virtual void remove(const Dbt::EventTypes& data) Q_DECL_OVERRIDE;
125 virtual void remove(const Dbt::Events& data) Q_DECL_OVERRIDE;
126 virtual void remove(const Dbt::DepartmentHasManager& data) Q_DECL_OVERRIDE;
127 virtual void remove(const Dbt::DepartmentHasMember& data) Q_DECL_OVERRIDE;
128 virtual void remove(const Dbt::EmployeeCanOpenDoor& data) Q_DECL_OVERRIDE;
129 virtual void remove(const Dbt::EmployeeHasRfid& data) Q_DECL_OVERRIDE;
130
131
132
133 void upgrade();
134 bool open() Q_DECL_OVERRIDE;
135 bool close() Q_DECL_OVERRIDE;
136 void begin() Q_DECL_OVERRIDE;
137 void commit() Q_DECL_OVERRIDE;
138
139 protected:
140 void createTemporaryTableTickets (int ticket, bool all = false);
141 QVariant currval(const QString& sequence);
142 void removeTicketsDetails(int ticket);
143
144 private:
145 QString m_databasename;
146 QString m_hostname;
147 QString m_username;
148 QString m_password;
149 int m_port;
150
151 static bool m_upgraded;
152 bool m_temporaryTableTicketsCreated;
153
154};
155
156}
157}
158
159#endif
160
database_plugin.h
Vygenerováno dne: po 21. říj 2024 11.54:45, pro projekt: Timesheets-Server, programem doxygen 1.12.0