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> employees(int employee) Q_DECL_OVERRIDE;
114 QList<Dbt::EventTypes> eventTypes(const QString& eventType) Q_DECL_OVERRIDE;
115 QList<Dbt::Events> events(int event,
116 int employee = -1,
117 const QDate& month = QDate(),
118 int limit = -1,
119 int offset = -1) Q_DECL_OVERRIDE;
120 QList<Dbt::DepartmentHasManager> departmentHasManager(const Dbt::DepartmentHasManager&) Q_DECL_OVERRIDE;
121 QList<Dbt::DepartmentHasMember> departmentHasMember(const Dbt::DepartmentHasMember&) Q_DECL_OVERRIDE;
122 QList<Dbt::EmployeeCanOpenDoor> employeeCanOpenDoor(const Dbt::EmployeeCanOpenDoor&) Q_DECL_OVERRIDE;
123 QList<Dbt::EmployeeHasRfid> employeeHasRfid(const Dbt::EmployeeHasRfid&) Q_DECL_OVERRIDE;
124 QList<Dbt::Rfids> rfids(int rfid) Q_DECL_OVERRIDE;
125 QList<Dbt::Rfids> rfidsById(const QString& rfidId) Q_DECL_OVERRIDE;
126 QList<Dbt::Holidays> holidays(const QDate& date) Q_DECL_OVERRIDE;
127 QList<Dbt::WorkCalendar> workCalendar(const QDate& period) Q_DECL_OVERRIDE;
128 void generateWorkCalendar(int year) Q_DECL_OVERRIDE;
129 void copyHolidays(int fromYear, int toYear) Q_DECL_OVERRIDE;
130 QList<Dbt::Employees> attendanceChecklist(const QDate& month) Q_DECL_OVERRIDE;
131 QList<Dbt::AttendanceChecklist> attendanceChecklist(int employee, const QDate& month) Q_DECL_OVERRIDE;
132 QList<Dbt::AttendanceSummary> attendanceSummary(int employee, const QDate& month) Q_DECL_OVERRIDE;
133 QList<Dbt::AttendancePresent> attendancePresent() Q_DECL_OVERRIDE;
134 QList<Dbt::AttendanceRecent> attendanceRecent(int employee) Q_DECL_OVERRIDE;
135 Dbt::UserEmployeeAccess canAccessAttendance(int employee) Q_DECL_OVERRIDE;
136
137 virtual void remove(const Dbt::Departments& data) Q_DECL_OVERRIDE;
138 virtual void remove(const Dbt::Doors& data) Q_DECL_OVERRIDE;
139 virtual void remove(const Dbt::Employees& data) Q_DECL_OVERRIDE;
140 virtual void remove(const Dbt::EventTypes& data) Q_DECL_OVERRIDE;
141 virtual void remove(const Dbt::Events& data) Q_DECL_OVERRIDE;
142 virtual void remove(const Dbt::DepartmentHasManager& data) Q_DECL_OVERRIDE;
143 virtual void remove(const Dbt::DepartmentHasMember& data) Q_DECL_OVERRIDE;
144 virtual void remove(const Dbt::EmployeeCanOpenDoor& data) Q_DECL_OVERRIDE;
145 virtual void remove(const Dbt::EmployeeHasRfid& data) Q_DECL_OVERRIDE;
146 virtual void remove(const Dbt::Rfids& data) Q_DECL_OVERRIDE;
147 virtual void remove(const Dbt::Holidays& data) Q_DECL_OVERRIDE;
148 virtual void remove(const Dbt::WorkCalendar& data) Q_DECL_OVERRIDE;
149 virtual void remove(const Dbt::AttendanceSummary& data) Q_DECL_OVERRIDE;
150
151 QVariant save(const Dbt::Departments& data) Q_DECL_OVERRIDE;
152 QVariant save(const Dbt::Employees& data) Q_DECL_OVERRIDE;
153 QVariant save(const Dbt::Doors& data) Q_DECL_OVERRIDE;
154 QVariant save(const Dbt::EventTypes& data) Q_DECL_OVERRIDE;
155 QVariant save(const Dbt::Events& data) Q_DECL_OVERRIDE;
156 QVariant save(const Dbt::Rfids& data) Q_DECL_OVERRIDE;
157 QVariant save(const Dbt::Holidays& data) Q_DECL_OVERRIDE;
158 QVariant save(const Dbt::WorkCalendar& data) Q_DECL_OVERRIDE;
159 QVariant save(const Dbt::DepartmentHasManager& data) Q_DECL_OVERRIDE;
160 QVariant save(const Dbt::EmployeeCanOpenDoor& data) Q_DECL_OVERRIDE;
161 QVariant save(const Dbt::DepartmentHasMember& data) Q_DECL_OVERRIDE;
162 QVariant save(const Dbt::EmployeeHasRfid& data) Q_DECL_OVERRIDE;
163 QVariant save(const Dbt::AttendanceSummary& data) Q_DECL_OVERRIDE;
164
165
166 void upgrade();
167 bool open() Q_DECL_OVERRIDE;
168 bool close() Q_DECL_OVERRIDE;
169 void begin() Q_DECL_OVERRIDE;
170 void commit() Q_DECL_OVERRIDE;
171
172 protected:
173 void createTemporaryTableTickets (int ticket, bool all = false);
174 QVariant currval(const QString& sequence);
175 void removeTicketsDetails(int ticket);
176
177 private:
178 QString m_databasename;
179 QString m_hostname;
180 QString m_username;
181 QString m_password;
182 int m_port;
183
184 static bool m_upgraded;
185 bool m_temporaryTableTicketsCreated;
186
187};
188
189}
190}
191
192#endif
database_plugin.h
Dbt::Employees
Zaměstnanec používaný v REST API.
Definition dbt.h:507
Vygenerováno dne: , pro projekt: Timesheets-Server, programem doxygen 1.15.0