Dokumentace třídy Db::Plugins::DatabasePluginPostgres

Diagram dědičnosti pro třídu Db::Plugins::DatabasePluginPostgres:

Veřejné metody
	DatabasePluginPostgres (QObject *)
void	setDatabaseName (const QString &x) Q_DECL_OVERRIDE
void	setHostname (const QString &x) Q_DECL_OVERRIDE
void	setPort (int x) Q_DECL_OVERRIDE
void	setUserName (const QString &x) Q_DECL_OVERRIDE
void	setPassword (const QString &x) Q_DECL_OVERRIDE
void	changePassword (const QString &login, const QString &oldpassword, const QString &newpassword) Q_DECL_OVERRIDE
QList< Dbt::Users >	authenticate (const QString &login, const QString &password) Q_DECL_OVERRIDE
QList< Dbt::Users >	users (int id) Q_DECL_OVERRIDE
QList< Dbt::UsersCategories >	usersCategories (int id, int user, const QString &category) Q_DECL_OVERRIDE
QList< Dbt::Categories >	categories (const QString &id) Q_DECL_OVERRIDE
QList< Dbt::Categories >	categoriesToRoot (const QString &id) Q_DECL_OVERRIDE
QList< Dbt::Categories >	subcategories (const QString &id) Q_DECL_OVERRIDE
QList< Dbt::Categories >	siblingcategories (const QString &id) Q_DECL_OVERRIDE
QList< Dbt::CategoriesOverview >	categoriesOverview (const QStringList &statuses) Q_DECL_OVERRIDE
QList< Dbt::StatusOrder >	statusOrder (const QString &id) Q_DECL_OVERRIDE
QList< Dbt::Statuses >	statuses (const QString &) Q_DECL_OVERRIDE
QList< Dbt::Statuses >	statuses (const QString &, const QString &) Q_DECL_OVERRIDE
QList< Dbt::StatusTemplates >	statusTemplates (int id) Q_DECL_OVERRIDE
QList< Dbt::Tickets >	tickets (bool all) Q_DECL_OVERRIDE
QList< Dbt::Tickets >	tickets (int ticket, bool all) Q_DECL_OVERRIDE
QList< Dbt::Tickets >	tickets (const Dbt::Categories &, bool all) Q_DECL_OVERRIDE
QList< Dbt::TicketsVw >	ticketsVw (bool all) Q_DECL_OVERRIDE
QList< Dbt::TicketsVw >	ticketsVw (int ticket, bool all) Q_DECL_OVERRIDE
QList< Dbt::TicketsVw >	ticketsVw (const Dbt::Categories &, bool all) Q_DECL_OVERRIDE
QList< Dbt::TicketStatus >	ticketStatus (int id) Q_DECL_OVERRIDE
QList< Dbt::TicketStatus >	ticketStatus (int ticket, bool all) Q_DECL_OVERRIDE
QList< Dbt::TicketStatus >	ticketStatus (bool all) Q_DECL_OVERRIDE
QList< Dbt::TicketValues >	ticketValues (int id) Q_DECL_OVERRIDE
QList< Dbt::TicketValues >	ticketValues (int ticket, bool all) Q_DECL_OVERRIDE
QList< Dbt::TicketValues >	ticketValues (bool all) Q_DECL_OVERRIDE
QList< Dbt::TicketFiles >	ticketFiles (int id) Q_DECL_OVERRIDE
QList< Dbt::TicketFiles >	ticketFiles (int ticket, bool all) Q_DECL_OVERRIDE
QList< Dbt::TicketFiles >	ticketFiles (bool all) Q_DECL_OVERRIDE
QList< Dbt::TicketTimesheets >	ticketTimesheets (int id) Q_DECL_OVERRIDE
QList< Dbt::TicketTimesheets >	ticketTimesheets (int ticket, bool all) Q_DECL_OVERRIDE
QList< Dbt::TicketTimesheets >	ticketTimesheets (bool all) Q_DECL_OVERRIDE
QList< Dbt::TicketTimesheets >	runningTimesheets (int ticket) Q_DECL_OVERRIDE
QList< Dbt::TicketTimesheets >	startTimesheet (int ticket) Q_DECL_OVERRIDE
QList< Dbt::TicketTimesheets >	stopTimesheet (int ticket) Q_DECL_OVERRIDE
QList< Dbt::TicketTimesheets >	toggleTimesheet (int ticket) Q_DECL_OVERRIDE
QList< Dbt::ClientSettings >	clientSettings () Q_DECL_OVERRIDE
QList< Dbt::Overview >	overview (const QString &category, const QStringList &statuses) Q_DECL_OVERRIDE
QList< Dbt::Overview >	overview (const QString &overviewId) Q_DECL_OVERRIDE
QList< Dbt::OverviewList >	overviewList () Q_DECL_OVERRIDE
QList< Dbt::ServerInfo >	serverInfo () Q_DECL_OVERRIDE
template<typename T>
void	save (const QList< T > &list)
void	remove (const Dbt::Users &data) Q_DECL_OVERRIDE
void	remove (const Dbt::Categories &data) Q_DECL_OVERRIDE
void	remove (const Dbt::StatusOrder &data) Q_DECL_OVERRIDE
void	remove (const Dbt::Statuses &data) Q_DECL_OVERRIDE
void	remove (const Dbt::Tickets &data) Q_DECL_OVERRIDE
void	remove (const Dbt::TicketStatus &data) Q_DECL_OVERRIDE
void	remove (const Dbt::TicketValues &data) Q_DECL_OVERRIDE
void	remove (const Dbt::TicketFiles &data) Q_DECL_OVERRIDE
void	remove (const Dbt::TicketTimesheets &data) Q_DECL_OVERRIDE
void	remove (const Dbt::OverviewList &data) Q_DECL_OVERRIDE
QVariant	save (const Dbt::Users &data) Q_DECL_OVERRIDE
QVariant	save (const Dbt::Categories &data) Q_DECL_OVERRIDE
QVariant	save (const Dbt::StatusOrder &data) Q_DECL_OVERRIDE
QVariant	save (const Dbt::Statuses &data) Q_DECL_OVERRIDE
QVariant	save (const Dbt::Tickets &data) Q_DECL_OVERRIDE
QVariant	save (const Dbt::TicketsVw &data) Q_DECL_OVERRIDE
QVariant	save (const Dbt::TicketStatus &data) Q_DECL_OVERRIDE
QVariant	save (const Dbt::TicketValues &data) Q_DECL_OVERRIDE
QVariant	save (const Dbt::TicketFiles &data) Q_DECL_OVERRIDE
QVariant	save (const Dbt::TicketTimesheets &data) Q_DECL_OVERRIDE
QVariant	save (const Dbt::ServerInfo &data) Q_DECL_OVERRIDE
QVariant	save (const Dbt::AppendStatuses &data) Q_DECL_OVERRIDE
QList< Dbt::Departments >	departments (int department) Q_DECL_OVERRIDE
QList< Dbt::Doors >	doors (int door) Q_DECL_OVERRIDE
QList< Dbt::Employees >	employees (int employee) Q_DECL_OVERRIDE
QList< Dbt::EventTypes >	eventTypes (const QString &eventType) Q_DECL_OVERRIDE
QList< Dbt::Events >	events (int event, int employee=-1, const QDate &month=QDate(), int limit=-1, int offset=-1) Q_DECL_OVERRIDE
QList< Dbt::DepartmentHasManager >	departmentHasManager (const Dbt::DepartmentHasManager &) Q_DECL_OVERRIDE
QList< Dbt::DepartmentHasMember >	departmentHasMember (const Dbt::DepartmentHasMember &) Q_DECL_OVERRIDE
QList< Dbt::EmployeeCanOpenDoor >	employeeCanOpenDoor (const Dbt::EmployeeCanOpenDoor &) Q_DECL_OVERRIDE
QList< Dbt::EmployeeHasRfid >	employeeHasRfid (const Dbt::EmployeeHasRfid &) Q_DECL_OVERRIDE
QList< Dbt::Rfids >	rfids (int rfid) Q_DECL_OVERRIDE
QList< Dbt::Rfids >	rfidsById (const QString &rfidId) Q_DECL_OVERRIDE
QList< Dbt::Holidays >	holidays (const QDate &date) Q_DECL_OVERRIDE
QList< Dbt::WorkCalendar >	workCalendar (const QDate &period) Q_DECL_OVERRIDE
void	generateWorkCalendar (int year) Q_DECL_OVERRIDE
void	copyHolidays (int fromYear, int toYear) Q_DECL_OVERRIDE
QList< Dbt::Employees >	attendanceChecklist (const QDate &month) Q_DECL_OVERRIDE
QList< Dbt::AttendanceChecklist >	attendanceChecklist (int employee, const QDate &month) Q_DECL_OVERRIDE
QList< Dbt::AttendanceSummary >	attendanceSummary (int employee, const QDate &month) Q_DECL_OVERRIDE
QList< Dbt::AttendancePresent >	attendancePresent () Q_DECL_OVERRIDE
QList< Dbt::AttendanceRecent >	attendanceRecent (int employee) Q_DECL_OVERRIDE
Dbt::UserEmployeeAccess	canAccessAttendance (int employee) Q_DECL_OVERRIDE
virtual void	remove (const Dbt::Departments &data) Q_DECL_OVERRIDE
virtual void	remove (const Dbt::Doors &data) Q_DECL_OVERRIDE
virtual void	remove (const Dbt::Employees &data) Q_DECL_OVERRIDE
virtual void	remove (const Dbt::EventTypes &data) Q_DECL_OVERRIDE
virtual void	remove (const Dbt::Events &data) Q_DECL_OVERRIDE
virtual void	remove (const Dbt::DepartmentHasManager &data) Q_DECL_OVERRIDE
virtual void	remove (const Dbt::DepartmentHasMember &data) Q_DECL_OVERRIDE
virtual void	remove (const Dbt::EmployeeCanOpenDoor &data) Q_DECL_OVERRIDE
virtual void	remove (const Dbt::EmployeeHasRfid &data) Q_DECL_OVERRIDE
virtual void	remove (const Dbt::Rfids &data) Q_DECL_OVERRIDE
virtual void	remove (const Dbt::Holidays &data) Q_DECL_OVERRIDE
virtual void	remove (const Dbt::WorkCalendar &data) Q_DECL_OVERRIDE
virtual void	remove (const Dbt::AttendanceSummary &data) Q_DECL_OVERRIDE
QVariant	save (const Dbt::Departments &data) Q_DECL_OVERRIDE
QVariant	save (const Dbt::Employees &data) Q_DECL_OVERRIDE
QVariant	save (const Dbt::Doors &data) Q_DECL_OVERRIDE
QVariant	save (const Dbt::EventTypes &data) Q_DECL_OVERRIDE
QVariant	save (const Dbt::Events &data) Q_DECL_OVERRIDE
QVariant	save (const Dbt::Rfids &data) Q_DECL_OVERRIDE
QVariant	save (const Dbt::Holidays &data) Q_DECL_OVERRIDE
QVariant	save (const Dbt::WorkCalendar &data) Q_DECL_OVERRIDE
QVariant	save (const Dbt::DepartmentHasManager &data) Q_DECL_OVERRIDE
QVariant	save (const Dbt::EmployeeCanOpenDoor &data) Q_DECL_OVERRIDE
QVariant	save (const Dbt::DepartmentHasMember &data) Q_DECL_OVERRIDE
QVariant	save (const Dbt::EmployeeHasRfid &data) Q_DECL_OVERRIDE
QVariant	save (const Dbt::AttendanceSummary &data) Q_DECL_OVERRIDE
void	upgrade ()
bool	open () Q_DECL_OVERRIDE
bool	close () Q_DECL_OVERRIDE
void	begin () Q_DECL_OVERRIDE
void	commit () Q_DECL_OVERRIDE
Veřejné metody dědí se z Db::Plugins::DatabasePlugin
	DatabasePlugin (QObject *)
void	setAuthenticatedUser (const AuthenticatedUser *x)
virtual QString	connectionName () const
virtual QList< Dbt::Statuses >	statuses (const QString &category, const QStringList &prevstatuses)
virtual void	remove (const Dbt::UsersCategories &data)
virtual QVariant	save (const Dbt::UsersCategories &data)

Chráněné metody
void	createTemporaryTableTickets (int ticket, bool all=false)
QVariant	currval (const QString &sequence)
void	removeTicketsDetails (int ticket)
Chráněné metody dědí se z Db::Plugins::DatabasePlugin
int	userId () const
bool	userAuthenticated () const
QString	userLogin () const
QString	userLang () const

Privátní atributy
QString	m_databasename
QString	m_hostname
QString	m_username
QString	m_password
int	m_port
bool	m_temporaryTableTicketsCreated

Statické privátní atributy
static bool	m_upgraded = false

Další zděděné členy
Veřejné atributy dědí se z Db::Plugins::DatabasePlugin
const AuthenticatedUser *	m_authenticatedUser = nullptr
Chráněné atributy dědí se z Db::Plugins::DatabasePlugin
QSqlDatabase	m_db

Detailní popis

Definice je uvedena na řádku 19 v souboru database_plugin_postgres.h.

Dokumentace konstruktoru a destruktoru

DatabasePluginPostgres()

DatabasePluginPostgres::DatabasePluginPostgres

(

QObject *

parent

)

Definice je uvedena na řádku 34 v souboru database_plugin_postgres.cpp.

                                                              : Db::Plugins::DatabasePlugin(parent) {
    Q_ASSERT(parent != NULL);
    setObjectName("DatabasePluginPostgres");
    m_temporaryTableTicketsCreated = false;
}

~DatabasePluginPostgres()

DatabasePluginPostgres::~DatabasePluginPostgres

(

)

Definice je uvedena na řádku 29 v souboru database_plugin_postgres.cpp.

                                                {
    close();
}

Dokumentace členských funkcí

attendanceChecklist() [1/2]

QList< Dbt::Employees > DatabasePluginPostgres::attendanceChecklist ( const QDate & month )

virtual

Reimplementuje stejnojmenný prvek z Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 2601 v souboru database_plugin_postgres.cpp.

                           :key1 or :key2 = '')X");
    q.bindValue(":key1", ((eventType.isNull()) ? QString("") : eventType));
    q.bindValue(":key2", ((eventType.isNull()) ? QString("") : eventType));
    q.exec();
    while (q.next()) {
        Dbt::EventTypes x;
        int i=0;
        x.event_type            = q.value(i++).toString();
        x.description           = q.value(i++).toString();
        x.end_state             = q.value(i++).toBool();
        x.passage               = q.value(i++).toBool();
        x.arrival               = q.value(i++).toBool();
        x.vacation              = q.value(i++).toBool();
        x.sick_leave            = q.value(i++).toBool();
        x.compensatory_leave    = q.value(i++).toBool();
        x.business_trip         = q.value(i++).toBool();
        x.break_time            = q.value(i++).toBool();
        x.unpaid_leave          = q.value(i++).toBool();
        x.sick_care             = q.value(i++).toBool();
        x.doctor                = q.value(i++).toBool();
        x.paid_obstacle         = q.value(i++).toBool();
        list << x;
        }
    return list;
}

attendanceChecklist() [2/2]

QList< Dbt::AttendanceChecklist > DatabasePluginPostgres::attendanceChecklist ( int employee, const QDate & month )

virtual

Reimplementuje stejnojmenný prvek z Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 2629 v souboru database_plugin_postgres.cpp.

                           :key1 or :key2 <= 0) 
            and (:employee <= 0 or employee = :employee))X");
    if (month.isValid()) {
        sql += QStringLiteral(" and date >= :date_from and date < :date_to");
        }
    sql += QStringLiteral(" order by date");
    if (limit > 0) { sql += QStringLiteral(" limit :limit"); }
    if (offset > 0) { sql += QStringLiteral(" offset :offset"); }
    sql += QStringLiteral(";");
 
    q.prepare(sql);
    q.bindValue(":key1", event);
    q.bindValue(":key2", event);
    q.bindValue(":employee", employee);
    if (month.isValid()) {
        QDateTime from(QDate(month.year(), month.month(), 1), QTime(0,0,0));
        QDateTime to = from.addMonths(1);
        q.bindValue(":date_from", from);
        q.bindValue(":date_to", to);
    }
    if (limit > 0) q.bindValue(":limit", limit);
    if (offset > 0) q.bindValue(":offset", offset);
    q.exec();
    while (q.next()) {
        Dbt::Events x;
        int i=0;
        x.event             = q.value(i++).toInt();
        x.date              = q.value(i++).toDateTime();
        x.event_type        = q.value(i++).toString();
        x.event_description = q.value(i++).toString();
        x.employee          = q.value(i++).toInt();
        x.firstname         = q.value(i++).toString();
        x.surname           = q.value(i++).toString();
        x.valid             = q.value(i++).toBool();
        x.user_edited       = q.value(i++).toInt();
        x.user_edited_name  = q.value(i++).toString();
        x.error             = q.value(i++).toString();
        x.note              = q.value(i++).toString();
        list << x;
        }
    return list;
}
 
QList<Dbt::DepartmentHasManager> DatabasePluginPostgres::departmentHasManager(const Dbt::DepartmentHasManager& p) { 
    MSqlQuery q(m_db);
    QList<Dbt::DepartmentHasManager> list; 
    q.prepare(R"'(select department, "user" from attendance.department_has_manager
        where (department = :key11 or :key12 <= 0)
          and ("user" = :key21 or :key22 <= 0);
        )'");
    q.bindValue(":key11", p.department);
    q.bindValue(":key12", p.department);
    q.bindValue(":key21", p.user);
    q.bindValue(":key22", p.user);
    q.exec();
    while (q.next()) {
        Dbt::DepartmentHasManager x;
        int i=0;
        x.department    = q.value(i++).toInt();
        x.user          = q.value(i++).toInt();
        list << x;
        }
    return list;
}
 
QList<Dbt::DepartmentHasMember> DatabasePluginPostgres::departmentHasMember(const Dbt::DepartmentHasMember& p) { 
    MSqlQuery q(m_db);
    QList<Dbt::DepartmentHasMember> list; 

attendancePresent()

QList< Dbt::AttendancePresent > DatabasePluginPostgres::attendancePresent ( )

virtual

Reimplementuje stejnojmenný prvek z Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 2800 v souboru database_plugin_postgres.cpp.

                                                                       {
    MSqlQuery q(m_db);
    QList<Dbt::Rfids> list;
    q.prepare(R"'(
        select r.rfid, r.rfid_id, r.valid, r.note,
               coalesce(ehr.employee, 0) as employee,
               coalesce(e.firstname, '') as firstname,
               coalesce(e.surname, '') as surname
          from attendance.rfids r
          left join attendance.employee_has_rfid ehr using (rfid)
          left join attendance.employees e on (e.employee = ehr.employee)
         where r.rfid_id = :rfid_id;
        )'");
    q.bindValue(":rfid_id", rfidId);
    q.exec();
    while (q.next()) {
        Dbt::Rfids x;
        int i=0;
        x.rfid    = q.value(i++).toInt();
        x.rfid_id = q.value(i++).toString();

attendanceRecent()

QList< Dbt::AttendanceRecent > DatabasePluginPostgres::attendanceRecent ( int employee )

virtual

Reimplementuje stejnojmenný prvek z Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 2828 v souboru database_plugin_postgres.cpp.

                                                                     {
    MSqlQuery q(m_db);
    QList<Dbt::Holidays> list;
    if (date.isValid()) {
        q.prepare(R"'(select date, description from attendance.holidays where date = :d;)'");
        q.bindValue(":d", date);
    } else {
        q.prepare(R"'(select date, description from attendance.holidays order by date desc;)'");
    }
    q.exec();
    while (q.next()) {
        Dbt::Holidays x;
        int i=0;
        x.date = q.value(i++).toDate();
        x.description = q.value(i++).toString();
        list << x;
    }
    return list;
}
 

attendanceSummary()

QList< Dbt::AttendanceSummary > DatabasePluginPostgres::attendanceSummary ( int employee, const QDate & month )

virtual

Reimplementuje stejnojmenný prvek z Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 2716 v souboru database_plugin_postgres.cpp.

                 :key11", p.department);
    q.bindValue(":key12", p.department);
    q.bindValue(":key21", p.employee);
    q.bindValue(":key22", p.employee);
    q.exec();
    while (q.next()) {
        Dbt::DepartmentHasMember x;
        int i=0;
        x.department    = q.value(i++).toInt();
        x.employee      = q.value(i++).toInt();
        list << x;
        }
    return list;
}
 
QList<Dbt::EmployeeCanOpenDoor> DatabasePluginPostgres::employeeCanOpenDoor(const Dbt::EmployeeCanOpenDoor& p) { 
    MSqlQuery q(m_db);
    QList<Dbt::EmployeeCanOpenDoor> list; 
    q.prepare(R"'(select door, employee from attendance.employee_can_open_door
        where (door = :key11 or :key12 <= 0)
          and (employee = :key21 or :key22 <= 0);
        )'");
    q.bindValue(":key11", p.door);
    q.bindValue(":key12", p.door);
    q.bindValue(":key21", p.employee);
    q.bindValue(":key22", p.employee);
    q.exec();
    while (q.next()) {
        Dbt::EmployeeCanOpenDoor x;
        int i=0;
        x.door      = q.value(i++).toInt();
        x.employee  = q.value(i++).toInt();
        list << x;
        }
    return list;
}
 
QList<Dbt::EmployeeHasRfid> DatabasePluginPostgres::employeeHasRfid(const Dbt::EmployeeHasRfid& p) {
    MSqlQuery q(m_db);
    QList<Dbt::EmployeeHasRfid> list; 
    q.prepare(R"'(select employee, rfid from attendance.employee_has_rfid
        where (employee = :key11 or :key12 <= 0)
          and (rfid = :key21 or :key22 <= 0);
        )'");
    q.bindValue(":key11", p.employee);
    q.bindValue(":key12", p.employee);

authenticate()

QList< Dbt::Users > DatabasePluginPostgres::authenticate ( const QString & login, const QString & password )

virtual

Implementuje Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 158 v souboru database_plugin_postgres.cpp.

                                                                                                  {
    QString md5 = QString::fromUtf8(QCryptographicHash::hash(password.toUtf8(), QCryptographicHash::Md5).toHex());
    QList<Dbt::Users> list;
    MSqlQuery q(m_db);
    q.prepare("select \"user\", login, name, lang, enabled, admin from users where login = :login and password = :password and enabled;");
    q.bindValue(":login", login);
    q.bindValue(":password", md5);
    q.exec();
    while (q.next()) {
        int i=0;
        Dbt::Users x;
        x.user          = q.value(i++).toInt();
        x.login         = q.value(i++).toString();
        x.name          = q.value(i++).toString();
        x.lang          = q.value(i++).toString();
        x.enabled       = q.value(i++).toBool();
        x.admin         = q.value(i++).toBool();
        list << x;
        }
 
    return list;
}

begin()

void DatabasePluginPostgres::begin ( )

virtual

Implementuje Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 117 v souboru database_plugin_postgres.cpp.

                                   {
    MSqlQuery q(m_db);
    q.exec("begin;");
}

canAccessAttendance()

Dbt::UserEmployeeAccess DatabasePluginPostgres::canAccessAttendance ( int employee )

virtual

Reimplementuje stejnojmenný prvek z Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 2584 v souboru database_plugin_postgres.cpp.

                                                                                { 
    MSqlQuery q(m_db);
    QList<Dbt::EventTypes> list; 

categories()

QList< Dbt::Categories > DatabasePluginPostgres::categories ( const QString & id )

virtual

Implementuje Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 398 v souboru database_plugin_postgres.cpp.

                    :department, :user)
        )'");
    q.bindValue(":department", data.department);
    q.bindValue(":user", data.user);
    q.exec();
    return QVariant();
}
 
QVariant DatabasePluginPostgres::save(const Dbt::DepartmentHasMember& data) {
    MSqlQuery q(m_db);
    q.prepare(R"'(
        insert into attendance.department_has_member (department, employee)
            values (:department, :employee)
        )'");
    q.bindValue(":department", data.department);
    q.bindValue(":employee", data.employee);
    q.exec();
    return QVariant();
}
 
QVariant DatabasePluginPostgres::save(const Dbt::EmployeeHasRfid& data) {
    MSqlQuery q(m_db);

categoriesOverview()

QList< Dbt::CategoriesOverview > DatabasePluginPostgres::categoriesOverview ( const QStringList & statuses )

virtual

Implementuje Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 1685 v souboru database_plugin_postgres.cpp.

                     :id", data.id);
        q.bindValue(":ticket", data.ticket);
        q.bindValue(":user", data.user);
        q.bindValue(":date", data.date);
        q.bindValue(":name", data.name);
        // q.bindValue(":value", JSON::json(data.value));
        q.exec();
        return QVariant(data.id);
        }
 
    if (data.created || !found) {
        q.prepare(QString(R"'(
            insert into ticket_values (ticket, "user", date, name, value)
                select :ticket, :user, :date, :name, '%1'
                where not exists (select 1 from ticket_values where id = :id);
            )'").arg(QString::fromUtf8(JSON::json(data.value))));
        q.bindValue(":id", data.id);
        q.bindValue(":ticket", data.ticket);
        q.bindValue(":user", data.user);
        q.bindValue(":date", data.date);
        q.bindValue(":name", data.name);
        // q.bindValue(":value", JSON::json(data.value));
        q.exec();
 
        return currval("ticket_values_id_seq");
        }
 
    Q_UNREACHABLE();
    qFatal("Should not happen");
    return QVariant();
}

categoriesToRoot()

QList< Dbt::Categories > DatabasePluginPostgres::categoriesToRoot ( const QString & id )

virtual

Implementuje Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 423 v souboru database_plugin_postgres.cpp.

                    :rfid, :employee)
            on conflict (rfid) do update set employee = excluded.employee
        )'");
    q.bindValue(":rfid", data.rfid);
    q.bindValue(":employee", data.employee);
    q.exec();
    return QVariant();
}
 
 
QVariantList pgArrayToVariantList(const QVariant& input) {
    QStringList x = input.toString().replace("{", "").replace("}", "").split(",");
    QVariantList list;
    for (int i=0; i<x.size(); i++) {
        list << x[i];
        }
    return list;
}
 
 
QList<Dbt::Categories> DatabasePluginPostgres::categories(const QString& id) {
    QList<Dbt::Categories> list;
    MSqlQuery q(m_db);
 
    q.prepare(R"'(
        select c.category, c.parent_category, c.description, c.price, ux.users, categories_tree_description(c.category) as description_tree
        from categories c, users u 

changePassword()

void DatabasePluginPostgres::changePassword ( const QString & login, const QString & oldpassword, const QString & newpassword )

virtual

Implementuje Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 129 v souboru database_plugin_postgres.cpp.

                                                                                                                        {
    PDEBUG;
    QString md5new = QString::fromUtf8(QCryptographicHash::hash(newpassword.toUtf8(), QCryptographicHash::Md5).toHex());
    QString md5old = QString::fromUtf8(QCryptographicHash::hash(oldpassword.toUtf8(), QCryptographicHash::Md5).toHex());
    QList<Dbt::Users> list;
    MSqlQuery q(m_db);
    q.prepare(R"'(select true from users where "user" = :userid and admin)'");
    q.bindValue(":userid", userId());
    q.exec();
    bool admin = q.next();
 
    if (admin) {
        // admin can change password for other users
        PDEBUG << "admin";
        q.prepare("update users set password = :newpassword where login = :login;");
      } else {
        // non-privileged user can change it's own password only, must know the old password
        PDEBUG << "not admin";
        q.prepare("update users set password = :newpassword where login = :login and password = :oldpassword and enabled;");
        }
    q.bindValue(":userid", userId());
    q.bindValue(":login", login);
    q.bindValue(":newpassword", md5new);
    q.bindValue(":oldpassword", md5old);
    q.exec();
    return;
}

clientSettings()

QList< Dbt::ClientSettings > DatabasePluginPostgres::clientSettings ( )

virtual

Implementuje Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 301 v souboru database_plugin_postgres.cpp.

                               {
        q.prepare(R"'(delete from users_categories where category = ?;)'");
        q.bindValue(0, category);
        q.exec();
        }
 
    for (int i=0; i<data.users.size(); i++) {
        q.prepare(R"string(
            insert into users_categories ("user", category) values (?, ?) on conflict do nothing;
            )string");
        q.bindValue(0, data.users[i].toInt());
        q.bindValue(1, category);
        q.exec();
        }
 
    q.commit();
 
    return category;
}
 
 

close()

bool DatabasePluginPostgres::close ( )

virtual

Implementuje Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 111 v souboru database_plugin_postgres.cpp.

                                   {
    m_db.close();
    return true;
}

commit()

void DatabasePluginPostgres::commit ( )

virtual

Implementuje Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 123 v souboru database_plugin_postgres.cpp.

                                    {
    MSqlQuery q(m_db);
    q.exec("commit;");
}

copyHolidays()

void DatabasePluginPostgres::copyHolidays ( int fromYear, int toYear )

virtual

Reimplementuje stejnojmenný prvek z Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 2192 v souboru database_plugin_postgres.cpp.

                 :userid", userId());
    q.exec();
    q.prepare(R"'(
            select 'DETAIL' as type, x.depth, x.category, x.description, x.price, x.time, x.tickets_count, x.ordering
                from xxx x

createTemporaryTableTickets()

void DatabasePluginPostgres::createTemporaryTableTickets ( int ticket, bool all = false )

protected

Definice je uvedena na řádku 618 v souboru database_plugin_postgres.cpp.

                     :id1", data.user);
        q.bindValue(":login", data.login);
        q.bindValue(":name", data.name);
        q.bindValue(":lang", data.lang);
        q.bindValue(":enabled", data.enabled);
        q.bindValue(":admin", data.admin);
        q.exec();
        return QVariant(data.user);
      } else {
 
        q.prepare(R"'(
            insert into users (login, name, lang, enabled, admin)
                select :login, :name, :lang, :enabled, :admin
                where not exists (select 1 from users where "user" = :id1);
            )'");
        q.bindValue(":id1", data.user);
        q.bindValue(":login", data.login);
        q.bindValue(":name", data.name);
        q.bindValue(":lang", data.lang);
        q.bindValue(":enabled", data.enabled);
        q.bindValue(":admin", data.admin);
        q.exec();

currval()

QVariant DatabasePluginPostgres::currval ( const QString & sequence )

protected

Definice je uvedena na řádku 213 v souboru database_plugin_postgres.cpp.

                                                                {
    MSqlQuery q(m_db);
    QVariant cv;
    q.prepare(R"'(select currval(:sequence);)'");
    q.bindValue(":sequence", sequence);
    q.exec();
    if (q.next()) {

departmentHasManager()

QList< Dbt::DepartmentHasManager > DatabasePluginPostgres::departmentHasManager ( const Dbt::DepartmentHasManager & p )

virtual

Reimplementuje stejnojmenný prvek z Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 2023 v souboru database_plugin_postgres.cpp.

                                {
        q.prepare(R"'(
            update ticket_files set
                ticket = :ticket,
                date = :date,
               "user" = :user,
                name = :name,
                type = :type,
                content = :content
                where id = :id
            )'");
        q.bindValue(":id", data.id);
        q.bindValue(":ticket", data.ticket);
        q.bindValue(":user", data.user);
        q.bindValue(":date", data.date);

departmentHasMember()

QList< Dbt::DepartmentHasMember > DatabasePluginPostgres::departmentHasMember ( const Dbt::DepartmentHasMember & p )

virtual

Reimplementuje stejnojmenný prvek z Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 2042 v souboru database_plugin_postgres.cpp.

                     :type", data.type);
        q.bindValue(":content", data.content);
        q.exec();
        return QVariant(data.id);
        }
 
    if (data.created || !found) {
        q.prepare(R"'(
            insert into ticket_files (ticket, "user", date, name, type, content)
                values (:ticket, :user, :date, :name, :type, :content);
            )'");
        q.bindValue(":id", data.id);
        q.bindValue(":ticket", data.ticket);
        q.bindValue(":user", data.user);
        q.bindValue(":date", data.date);
        q.bindValue(":name", data.name);
        q.bindValue(":type", data.type);
        q.bindValue(":content", data.content);

departments()

QList< Dbt::Departments > DatabasePluginPostgres::departments ( int department )

virtual

Reimplementuje stejnojmenný prvek z Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 1886 v souboru database_plugin_postgres.cpp.

                           :abbreviation,
            color = :color,
            closed = :closed,
            can_be_run = :can_be_run,
            ignored = :ignored
            where status = :status
        )'");
    q.bindValue(":description", data.description);
    q.bindValue(":abbreviation", data.abbreviation);
    q.bindValue(":color", data.color);
    q.bindValue(":closed", data.closed);
    q.bindValue(":can_be_run", data.can_be_run);
    q.bindValue(":ignored", data.ignored);
    q.bindValue(":status", data.status);
    q.exec();
 
    q.prepare(R"'(

doors()

QList< Dbt::Doors > DatabasePluginPostgres::doors ( int door )

virtual

Reimplementuje stejnojmenný prvek z Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 1905 v souboru database_plugin_postgres.cpp.

                                                                    :status2);
        )'");
    q.bindValue(":status1", data.status);
    q.bindValue(":description", data.description);
    q.bindValue(":abbreviation", data.abbreviation);
    q.bindValue(":color", data.color);
    q.bindValue(":closed", data.closed);
    q.bindValue(":can_be_run", data.can_be_run);
    q.bindValue(":ignored", data.ignored);
    q.bindValue(":status2", data.status);
    q.exec();
 
    q.prepare(R"'(
        delete from status_order
            where previous_status = :status
        )'");

employeeCanOpenDoor()

QList< Dbt::EmployeeCanOpenDoor > DatabasePluginPostgres::employeeCanOpenDoor ( const Dbt::EmployeeCanOpenDoor & p )

virtual

Reimplementuje stejnojmenný prvek z Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 2061 v souboru database_plugin_postgres.cpp.

                                                            {
    MSqlQuery q(m_db);
    q.prepare(R"'(delete from ticket_files where id = :id;)'");
    q.bindValue(":id", id.id);
    q.exec();
}
 
 
QList<Dbt::UsersCategories> DatabasePluginPostgres::usersCategories(int id, int user, const QString& category) {
    QList<Dbt::UsersCategories> list;

employeeHasRfid()

QList< Dbt::EmployeeHasRfid > DatabasePluginPostgres::employeeHasRfid ( const Dbt::EmployeeHasRfid & p )

virtual

Reimplementuje stejnojmenný prvek z Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 2080 v souboru database_plugin_postgres.cpp.

                         {
        q.exec();
        while (q.next()) {  
            int i=0; 
            Dbt::UsersCategories x; 
            x.id = q.value(i++).toInt();
            x.user = q.value(i++).toInt();
            x.category = q.value(i++).toString();
            list << x;
            }
        return list;
        };
 
    if (id > 0) {
        q.prepare(R"'(select id, "user", category from users_categories where id = :id)'");
        q.bindValue(":id", id);
        return retvals();
        }

employees()

QList< Dbt::Employees > DatabasePluginPostgres::employees ( int employee )

virtual

Reimplementuje stejnojmenný prvek z Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 1922 v souboru database_plugin_postgres.cpp.

                                           {
        q.prepare(R"'(
            insert into status_order (previous_status, next_status)
                values (:previous_status, :next_status);
            )'");
        q.bindValue(":previous_status", data.status);
        q.bindValue(":next_status", data.next[i].status);
        q.exec();
        }
 
    commit();
 
    return QVariant(data.status);
}
 
 
QList<Dbt::StatusTemplates> DatabasePluginPostgres::statusTemplates(int id) {
    Q_UNUSED(id);
    MSqlQuery q(m_db);
    QList<Dbt::StatusTemplates> list;
    return list;
}
 
 

events()

QList< Dbt::Events > DatabasePluginPostgres::events ( int event, int employee = -1, const QDate & month = QDate(), int limit = -1, int offset = -1 )

virtual

Reimplementuje stejnojmenný prvek z Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 1978 v souboru database_plugin_postgres.cpp.

                         :id
              and t.ticket = f.ticket
              and t.category = uc.category
              and u."user" = f."user"
            ;
        )'");
    q.bindValue(":id", id);
    q.bindValue(":user", userId());
    q.exec();
    while (q.next()) {
        int i=0;
        Dbt::TicketFiles x;
        x.id        = q.value(i++).toInt();
        x.user      = q.value(i++).toInt();
        x.date      = q.value(i++).toDateTime();
        x.ticket    = q.value(i++).toInt();
        x.name      = q.value(i++).toString();
        x.type      = q.value(i++).toString();
        x.content   = q.value(i++).toByteArray();
        list << x;
        }
 
    return list;
}
 
 
QList<Dbt::TicketFiles> DatabasePluginPostgres::ticketFiles(bool all) {
    return ticketFiles(-1, all);
}
 
 
QVariant DatabasePluginPostgres::save(const Dbt::TicketFiles& data) {
    MSqlQuery q(m_db);
 
    bool found = false;
    if (!data.created) {
        q.prepare(R"'(select 1 from ticket_files where id = :id;)'");
        q.bindValue(":id", data.id);

eventTypes()

QList< Dbt::EventTypes > DatabasePluginPostgres::eventTypes ( const QString & eventType )

virtual

Reimplementuje stejnojmenný prvek z Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 1949 v souboru database_plugin_postgres.cpp.

                     {
        int i=0;
        Dbt::TicketFiles x;
        x.id        = q.value(i++).toInt();
        x.user      = q.value(i++).toInt();
        x.date      = q.value(i++).toDateTime();
        x.ticket    = q.value(i++).toInt();
        x.name      = q.value(i++).toString();
        x.type      = q.value(i++).toString();
        x.content   = q.value(i++).toByteArray();
        list << x;
        }
 
    return list;
}
 
 

generateWorkCalendar()

void DatabasePluginPostgres::generateWorkCalendar ( int year )

virtual

Reimplementuje stejnojmenný prvek z Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 2185 v souboru database_plugin_postgres.cpp.

holidays()

QList< Dbt::Holidays > DatabasePluginPostgres::holidays ( const QDate & date )

virtual

Reimplementuje stejnojmenný prvek z Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 2142 v souboru database_plugin_postgres.cpp.

                                   :userid
                ),
            x_statuses as (
                select *
                    from statuses
                    where status in (%1)
                    and not ignored
                ),
            x_tickets as (

open()

bool DatabasePluginPostgres::open ( )

virtual

Implementuje Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 41 v souboru database_plugin_postgres.cpp.

                                  {
    m_db = QSqlDatabase::addDatabase("QPSQL", QUuid::createUuid().toString().toUtf8());
 
    m_db.setDatabaseName ( m_databasename );
    m_db.setHostName     ( m_hostname     );
    m_db.setPort         ( m_port         );
    m_db.setUserName     ( m_username     );
    m_db.setPassword     ( m_password     );
 
    if (!m_db.open()) {
        PDEBUG << "Cannot connect to database Postgres";
        PDEBUG << m_db.lastError().text();
        return false;
        }
 
    upgrade();
 
    return true;
}

overview() [1/2]

QList< Dbt::Overview > DatabasePluginPostgres::overview ( const QString & category, const QStringList & statuses )

virtual

Implementuje Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 1718 v souboru database_plugin_postgres.cpp.

                                                             {
    MSqlQuery q(m_db);
    q.prepare(R"'(delete from ticket_values where id = :id;)'");
    q.bindValue(":id", id.id);
    q.exec();
}
 
 
QList<Dbt::Statuses> DatabasePluginPostgres::statuses(const QString& id) {
    QList<Dbt::Statuses> list;
    MSqlQuery q(m_db);
    if (id.isEmpty() || id == "") {
        q.prepare(R"'(
            select s.status, s.description, s.abbreviation, s.color, s.closed, s.can_be_run, s.ignored, 
                   n.status, n.description, n.abbreviation, n.color, n.closed, n.can_be_run, n.ignored 
            from statuses s 
            left join status_order o on (s.status = o.previous_status) 
            left join statuses n on (o.next_status = n.status)
            order by s.status, n.status
            )'");
      } else {
        q.prepare(R"'(
            select s.status, s.description, s.abbreviation, s.color, s.closed, s.can_be_run, s.ignored, 
                   n.status, n.description, n.abbreviation, n.color, n.closed, n.can_be_run, n.ignored 
            from statuses s 
            left join status_order o on (s.status = o.previous_status) 
            left join statuses n on (o.next_status = n.status)
            where (:id = s.status)
            order by s.status, n.status

overview() [2/2]

QList< Dbt::Overview > DatabasePluginPostgres::overview ( const QString & overviewId )

virtual

Implementuje Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 1749 v souboru database_plugin_postgres.cpp.

                 :id", id);
    q.exec();
    Dbt::Statuses x;
    while (q.next()) {
        int i=0;
        if (!x.status.isEmpty() && x.status != q.value(0).toString()) {
            list << x;
            x.clear();
            }
        x.status = q.value(i++).toString();
        x.description = q.value(i++).toString();
        x.abbreviation = q.value(i++).toString();
        x.color = q.value(i++).toString();
        x.closed = q.value(i++).toBool();
        x.can_be_run = q.value(i++).toBool();
        x.ignored = q.value(i++).toBool();
        x.can_have_next = true; 
        if (!q.value(i).isNull()) {
            Dbt::Statuses n;
            n.status = q.value(i++).toString();
            n.description = q.value(i++).toString();
            n.abbreviation = q.value(i++).toString();
            n.color = q.value(i++).toString();
            n.closed = q.value(i++).toBool();
            n.can_be_run = q.value(i++).toBool();
            n.ignored = q.value(i++).toBool();
            x.next << n;
            }
        }
    if (!x.status.isEmpty()) {
        list << x;
        }
    return list;
}
 
 
QList<Dbt::Statuses> DatabasePluginPostgres::statuses(const QString& category, const QString& previousStatus) {
    if ((category.isEmpty() || category == "") && 
        (previousStatus.isEmpty() || previousStatus == "")) { return statuses(QString()); }
    int categoryi = category.toInt();
    MSqlQuery q(m_db);
    QString ps = (previousStatus.isEmpty()) ? "0" : previousStatus;
    auto results = [&q]() {
        QList<Dbt::Statuses> list;
        q.exec();
        while (q.next()) {
            Dbt::Statuses x;
            int i=0;
            x.status = q.value(i++).toString();
            x.description = q.value(i++).toString();
            x.abbreviation = q.value(i++).toString();
            x.color = q.value(i++).toString();
            x.closed = q.value(i++).toBool();
            x.can_be_run = q.value(i++).toBool();
            x.ignored = q.value(i++).toBool();
            list << x;
            }
        return list;
        };
 
    bool findNullCategory = (category.isEmpty() || category == "");
    if (!findNullCategory) {
        q.prepare(R"'(select 1 from status_order where category = :category;)'");
        q.bindValue(":category", categoryi);
        q.exec();
        findNullCategory = !q.next();
        }
 
    if (findNullCategory && (previousStatus.isEmpty() || previousStatus == "")) {
        q.prepare(R"'(
            select s.status, s.description, s.abbreviation, s.color, s.closed, s.can_be_run, s.ignored
            from statuses s, status_order o
            where s.status = o.next_status
            and (o.previous_status is null or o.previous_status = '')
            and (o.category is null);
            )'");
        return results();
        }
 
    if (findNullCategory) {
        q.prepare(R"'(
            select s.status, s.description, s.abbreviation, s.color, s.closed, s.can_be_run, s.ignored
            from statuses s, status_order o
            where s.status = o.next_status
            and o.previous_status = :previous_status
            and (o.category is null);
            )'");
        q.bindValue(":previous_status", ps);
        return results();
        }
 
    if (!findNullCategory && (previousStatus.isEmpty() || previousStatus == "")) {

overviewList()

QList< Dbt::OverviewList > DatabasePluginPostgres::overviewList ( )

virtual

Implementuje Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 1843 v souboru database_plugin_postgres.cpp.

                             :category;
            )'");
        q.bindValue(":category", categoryi);
        return results();
        }
 
 
    if (!findNullCategory) {
        q.prepare(R"'(
            select s.status, s.description, s.abbreviation, s.color, s.closed, s.can_be_run, s.ignored
            from statuses s, status_order o
            where s.status = o.next_status
            and o.previous_status = :previous_status
            and o.category = :category;
            )'");
        q.bindValue(":previous_status", ps);
        q.bindValue(":category", categoryi);
        return results();
        }
 
    return QList<Dbt::Statuses>();
 
}
 
 
void DatabasePluginPostgres::remove(const Dbt::Statuses& id) {
    MSqlQuery q(m_db);
    q.prepare(R"'(delete from statuses where status = :id;)'");
    q.bindValue(":id", id.status);
    q.exec();
}

remove() [1/23]

void DatabasePluginPostgres::remove ( const Dbt::AttendanceSummary & data )

virtual

Reimplementuje stejnojmenný prvek z Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 2289 v souboru database_plugin_postgres.cpp.

remove() [2/23]

void DatabasePluginPostgres::remove ( const Dbt::Categories & data )

virtual

Reimplementuje stejnojmenný prvek z Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 205 v souboru database_plugin_postgres.cpp.

                                                           {
    MSqlQuery q(m_db);

remove() [3/23]

void DatabasePluginPostgres::remove ( const Dbt::DepartmentHasManager & data )

virtual

Reimplementuje stejnojmenný prvek z Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 2236 v souboru database_plugin_postgres.cpp.

                             :category
              and statuses = )'" + statusesX );
    q.bindValue(":category", category);
    q.exec();
    if (q.next()) { 
        list = overview(q.value(0).toString());
        return list;

remove() [4/23]

void DatabasePluginPostgres::remove ( const Dbt::DepartmentHasMember & data )

virtual

Reimplementuje stejnojmenný prvek z Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 2244 v souboru database_plugin_postgres.cpp.

                                                                             :key, :category, " + statusesX + ");");
    q.bindValue(":key", rnds);
    q.bindValue(":category", category);
    q.exec();

remove() [5/23]

void DatabasePluginPostgres::remove ( const Dbt::Departments & data )

virtual

Reimplementuje stejnojmenný prvek z Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 2200 v souboru database_plugin_postgres.cpp.

                     {
        int i=0;

remove() [6/23]

void DatabasePluginPostgres::remove ( const Dbt::Doors & data )

virtual

Reimplementuje stejnojmenný prvek z Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 2208 v souboru database_plugin_postgres.cpp.

remove() [7/23]

void DatabasePluginPostgres::remove ( const Dbt::EmployeeCanOpenDoor & data )

virtual

Reimplementuje stejnojmenný prvek z Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 2252 v souboru database_plugin_postgres.cpp.

                                                                             {
    QList<Dbt::Overview> list;

remove() [8/23]

void DatabasePluginPostgres::remove ( const Dbt::EmployeeHasRfid & data )

virtual

Reimplementuje stejnojmenný prvek z Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 2260 v souboru database_plugin_postgres.cpp.

remove() [9/23]

void DatabasePluginPostgres::remove ( const Dbt::Employees & data )

virtual

Reimplementuje stejnojmenný prvek z Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 2215 v souboru database_plugin_postgres.cpp.

remove() [10/23]

void DatabasePluginPostgres::remove ( const Dbt::Events & data )

virtual

Reimplementuje stejnojmenný prvek z Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 2229 v souboru database_plugin_postgres.cpp.

remove() [11/23]

void DatabasePluginPostgres::remove ( const Dbt::EventTypes & data )

virtual

Reimplementuje stejnojmenný prvek z Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 2222 v souboru database_plugin_postgres.cpp.

                                                                                                        {
    QString statusesX;
    QStringList statusesL;
    for (int i=0; i<statuses.size(); i++) {
        statusesL << "'" + statuses[i] + "'";
        }

remove() [12/23]

void DatabasePluginPostgres::remove ( const Dbt::Holidays & data )

virtual

Reimplementuje stejnojmenný prvek z Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 2275 v souboru database_plugin_postgres.cpp.

remove() [13/23]

void DatabasePluginPostgres::remove ( const Dbt::OverviewList & data )

virtual

Reimplementuje stejnojmenný prvek z Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 1878 v souboru database_plugin_postgres.cpp.

                                                             {
    MSqlQuery q(m_db);
 
    begin();
    q.prepare(R"'(

remove() [14/23]

void DatabasePluginPostgres::remove ( const Dbt::Rfids & data )

virtual

Reimplementuje stejnojmenný prvek z Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 2268 v souboru database_plugin_postgres.cpp.

                 :key", overviewId.toUpper());
    q.exec();
    if (!q.next()) { return list; }
    overview.category.category          =      q.value(0).toString();
    overview.category.parent_category   = null(q.value(1).toString());

remove() [15/23]

void DatabasePluginPostgres::remove ( const Dbt::Statuses & data )

virtual

Reimplementuje stejnojmenný prvek z Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 1472 v souboru database_plugin_postgres.cpp.

remove() [16/23]

void DatabasePluginPostgres::remove ( const Dbt::StatusOrder & data )

virtual

Reimplementuje stejnojmenný prvek z Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 579 v souboru database_plugin_postgres.cpp.

                                                      {
    MSqlQuery q(m_db);

remove() [17/23]

void DatabasePluginPostgres::remove ( const Dbt::TicketFiles & data )

virtual

Reimplementuje stejnojmenný prvek z Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 1626 v souboru database_plugin_postgres.cpp.

                                                                  {
    QList<Dbt::TicketValues> list;
    MSqlQuery q(m_db);

remove() [18/23]

void DatabasePluginPostgres::remove ( const Dbt::Tickets & data )

virtual

Reimplementuje stejnojmenný prvek z Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 733 v souboru database_plugin_postgres.cpp.

remove() [19/23]

void DatabasePluginPostgres::remove ( const Dbt::TicketStatus & data )

virtual

Reimplementuje stejnojmenný prvek z Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 882 v souboru database_plugin_postgres.cpp.

remove() [20/23]

void DatabasePluginPostgres::remove ( const Dbt::TicketTimesheets & data )

virtual

Reimplementuje stejnojmenný prvek z Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 1260 v souboru database_plugin_postgres.cpp.

remove() [21/23]

void DatabasePluginPostgres::remove ( const Dbt::TicketValues & data )

virtual

Reimplementuje stejnojmenný prvek z Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 1358 v souboru database_plugin_postgres.cpp.

                                                                           {
    QList<Dbt::TicketTimesheets> list;
    MSqlQuery q(m_db);
 

remove() [22/23]

void DatabasePluginPostgres::remove ( const Dbt::Users & data )

virtual

Reimplementuje stejnojmenný prvek z Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 501 v souboru database_plugin_postgres.cpp.

                                                                            {
    QList<Dbt::Categories> list;

remove() [23/23]

void DatabasePluginPostgres::remove ( const Dbt::WorkCalendar & data )

virtual

Reimplementuje stejnojmenný prvek z Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 2282 v souboru database_plugin_postgres.cpp.

                                                                                    :key)
 

removeTicketsDetails()

void DatabasePluginPostgres::removeTicketsDetails ( int ticket )

protected

Definice je uvedena na řádku 811 v souboru database_plugin_postgres.cpp.

rfids()

QList< Dbt::Rfids > DatabasePluginPostgres::rfids ( int rfid )

virtual

Implementuje Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 2099 v souboru database_plugin_postgres.cpp.

                                                   {
        q.prepare(R"'(select id, "user", category from users_categories where "user" = :user)'");
        q.bindValue(":user", user);
        return retvals();
        }
 
    if (id <= 0 && category.isEmpty() && user <= 0) {
        q.prepare(R"'(select id, "user", category from users_categories)'");
        return retvals();
        }
 
    if (id <= 0 && !category.isEmpty() && user > 0) {
        q.prepare(R"'(select id, "user", category from users_categories where "user" = :user and category = :category)'");
        q.bindValue(":user", user);
        q.bindValue(":category", category);
        return retvals();
        }
 
    if (id <= 0 && !category.isEmpty() && user <= 0) {
        q.prepare(R"'(select id, "user", category from users_categories where category = :category)'");
        q.bindValue(":category", category);

rfidsById()

QList< Dbt::Rfids > DatabasePluginPostgres::rfidsById ( const QString & rfidId )

virtual

Implementuje Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 2121 v souboru database_plugin_postgres.cpp.

                                                                                                   {
    QString statusesX;
    QStringList statusesL;
    for (int i=0; i<statuses.size(); i++) {
        statusesL << "'" + statuses[i] + "'";
        }
    statusesL.sort();
    statusesX = statusesL.join(",");
 
    QList<Dbt::CategoriesOverview> list;
    MSqlQuery q(m_db);
    q.prepare(QString(R"'(
            with recursive tree as (

runningTimesheets()

QList< Dbt::TicketTimesheets > DatabasePluginPostgres::runningTimesheets ( int ticket )

virtual

Implementuje Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 1010 v souboru database_plugin_postgres.cpp.

                                                                    {
    return ticketStatus(-1, all);
}
 
 
QList<Dbt::TicketStatus> DatabasePluginPostgres::ticketStatus(int id) {
    QList<Dbt::TicketStatus> list;
    MSqlQuery q(m_db);
 
    q.prepare(R"'(

save() [1/26]

QVariant DatabasePluginPostgres::save ( const Dbt::AppendStatuses & data )

virtual

Reimplementuje stejnojmenný prvek z Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 931 v souboru database_plugin_postgres.cpp.

                     :category", data.category);
        q.bindValue(":date", data.date);
        q.bindValue(":price", data.price);
        q.bindValue(":description", data.description);
        q.bindValue(":user", data.user);
        q.exec();
        return currval("tickets_ticket_seq");
        }
 
    Q_UNREACHABLE();
    qFatal("Should not happen");
    return QVariant();
 
}
 
 
template<typename T>
QList<T> remapTicket(const QList<T>& input, int ticket) {
    QList<T> list;
    QListIterator<T> iterator(input);
    while (iterator.hasNext()) {
        T x = iterator.next();
        x.ticket = ticket;
        if (ticket <= 0) { x.id = 0; }
        list << x;
        }
    return list;
}
 

save() [2/26]

QVariant DatabasePluginPostgres::save ( const Dbt::AttendanceSummary & data )

virtual

Reimplementuje stejnojmenný prvek z Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 2764 v souboru database_plugin_postgres.cpp.

                 :key22", p.rfid);
    q.exec();
    while (q.next()) {
        Dbt::EmployeeHasRfid x;
        int i=0;
        x.employee  = q.value(i++).toInt();
        x.rfid      = q.value(i++).toInt();
        list << x;
        }
    return list;
}
 
QList<Dbt::Rfids> DatabasePluginPostgres::rfids(int rfid) {
    MSqlQuery q(m_db);
    QList<Dbt::Rfids> list;
    q.prepare(R"'(
        select r.rfid, r.rfid_id, r.valid, r.note,
               coalesce(ehr.employee, 0) as employee,
               coalesce(e.firstname, '') as firstname,
               coalesce(e.surname, '') as surname
          from attendance.rfids r
          left join attendance.employee_has_rfid ehr using (rfid)
          left join attendance.employees e on (e.employee = ehr.employee)
         where r.rfid = :key1 or :key2 <= 0;
        )'");
    q.bindValue(":key1", rfid);
    q.bindValue(":key2", rfid);
    q.exec();
    while (q.next()) {
        Dbt::Rfids x;
        int i=0;
        x.rfid    = q.value(i++).toInt();
        x.rfid_id = q.value(i++).toString();
        x.valid   = q.value(i++).toBool();
        x.note    = q.value(i++).toString();

save() [3/26]

QVariant DatabasePluginPostgres::save ( const Dbt::Categories & data )

virtual

Reimplementuje stejnojmenný prvek z Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 226 v souboru database_plugin_postgres.cpp.

                                                               {
    MSqlQuery q(m_db);
 
    QVariant parent_category = (data.parent_category.toInt() > 0) 
                             ?  data.parent_category.toInt()
                             : QVariant();
 
    QVariant        category = (data.category.toInt() > 0) 
                             ?  data.category.toInt()
                             : QVariant(QVariant::Int);
 
    if (parent_category.toInt() == category.toInt()) {
        parent_category = QVariant();
        }
 
    // TODO: Kontrola, aby nešlo založit novou kategorii v nadřízené kategorii bez přístupu
 
    q.begin();
 
    q.prepare(R"'(select 1 from categories where category = :category;)'");
    q.bindValue(":category", data.category.toInt());
    q.exec();
    bool exists = q.next();
    if (exists && ! parent_category.isNull()) {
        q.prepare(R"'(
            update categories set
                parent_category = ?,
                description = ?,
                price = ?
                where category = ?
            )'");
        q.bindValue(0, parent_category);
        q.bindValue(1, data.description);
        q.bindValue(2, data.price);
        q.bindValue(3, category.toInt());
        q.exec();
        }
 
    if (exists && parent_category.isNull()) {
        q.prepare(R"'(
            update categories set
                description = ?,
                price = ?
                where category = ?
            )'");
        q.bindValue(0, data.description);
        q.bindValue(1, data.price);
        q.bindValue(2, category.toInt());
        q.exec();
        }
 
    if (!exists) {
        q.prepare(R"string(
            insert into categories (parent_category, description, price) values (?, ?, ?);
            )string");
        q.bindValue(0, parent_category);
        q.bindValue(1, data.description);
        q.bindValue(2, data.price);
        q.exec();
        category = currval("categories_category_seq");
        // insert permission for creator
        q.prepare(R"string(
            insert into users_categories ("user", category) values (?, ?) on conflict do nothing;
            )string");
        q.bindValue(0, userId());
        q.bindValue(1, category);
        q.exec();
        }
 

save() [4/26]

QVariant DatabasePluginPostgres::save ( const Dbt::DepartmentHasManager & data )

virtual

Reimplementuje stejnojmenný prvek z Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 360 v souboru database_plugin_postgres.cpp.

                                                               {

save() [5/26]

QVariant DatabasePluginPostgres::save ( const Dbt::DepartmentHasMember & data )

virtual

Reimplementuje stejnojmenný prvek z Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 369 v souboru database_plugin_postgres.cpp.

                   :name,
            description = :description
            ;
        )'");
    q.bindValue(":name", data.name);

save() [6/26]

QVariant DatabasePluginPostgres::save ( const Dbt::Departments & data )

virtual

Reimplementuje stejnojmenný prvek z Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 2298 v souboru database_plugin_postgres.cpp.

                 :key", overviewId.toUpper());
    q.exec();
 
    q.prepare(R"'(insert into overview_statuses_tmp select unnest(statuses) from overview_params where key = :key;)'");
    q.bindValue(":key", overviewId.toUpper());
    q.exec();
 
    q.exec(R"'(
            with
            ticket_last_status as not materialized (
                select t.ticket, tl.status, st.description
                    from tickets t
                    left join lateral (select tn.ticket, tn.status
                                from  ticket_status tn, statuses s
                                where tn.ticket = t.ticket
                                  and tn.status = s.status
                                  and not s.ignored
                                order by ticket, date desc
                                limit 1
                                ) tl using (ticket)
                    left join statuses st on (st.status = tl.status)
                ),

save() [7/26]

QVariant DatabasePluginPostgres::save ( const Dbt::Doors & data )

virtual

Reimplementuje stejnojmenný prvek z Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 2370 v souboru database_plugin_postgres.cpp.

                     {
        if (q.value(2).toInt() == -1) {
            Dbt::Overview::TicketsSum s;
            s.ticket      = q.value(0).toInt();
            s.description = q.value(1).toString();
            s.duration    = q.value(5).toDouble();
            s.price       = q.value(6).toDouble();
            s.status      = q.value(7).toString();
            overview.ticketsSum << s;
            continue;
            }
        if (q.value(2).toInt() == -2) {
            Dbt::Overview::StatusSum s;
            s.duration    = q.value(5).toDouble();
            s.price       = q.value(6).toDouble();
            s.status      = q.value(7).toString();
            overview.statusSum << s;

save() [8/26]

QVariant DatabasePluginPostgres::save ( const Dbt::EmployeeCanOpenDoor & data )

virtual

Reimplementuje stejnojmenný prvek z Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 351 v souboru database_plugin_postgres.cpp.

                     {
        Dbt::ServerInfo x;
        int i = 0;

save() [9/26]

QVariant DatabasePluginPostgres::save ( const Dbt::EmployeeHasRfid & data )

virtual

Reimplementuje stejnojmenný prvek z Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 378 v souboru database_plugin_postgres.cpp.

                                                                        {
    MSqlQuery q(m_db);
    q.prepare(R"'(

save() [10/26]

QVariant DatabasePluginPostgres::save ( const Dbt::Employees & data )

virtual

Reimplementuje stejnojmenný prvek z Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 2326 v souboru database_plugin_postgres.cpp.

save() [11/26]

QVariant DatabasePluginPostgres::save ( const Dbt::Events & data )

virtual

Reimplementuje stejnojmenný prvek z Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 2449 v souboru database_plugin_postgres.cpp.

                     {
        if (q.value(2).toInt() == -1) {
            overview.sum.duration    = q.value(6).toDouble();
            overview.sum.price       = q.value(7).toDouble();
            continue;
            }
        int i = 0;
        Dbt::Overview::Days t;
        t.ticket        = q.value(i++).toInt();
        t.description   = q.value(i++).toString();
        t.user          = q.value(i++).toInt();
        t.user_name     = q.value(i++).toString();
        t.hour_price    = q.value(i++).toDouble();
        t.date          = q.value(i++).toDateTime();
        t.duration      = q.value(i++).toDouble();
        t.price         = q.value(i++).toDouble();
        overview.days << t;
        }
 
    list << overview;
    return list;
}
 
 
QList<Dbt::OverviewList> DatabasePluginPostgres::overviewList() {
    MSqlQuery q(m_db);
    QList<Dbt::OverviewList> list;
 
    QList<Dbt::Statuses> statusesList = statuses(QString());
    QHash<QString, Dbt::Statuses> statusesHash;
    for (int i=0; i<statusesList.size(); i++) {
        const Dbt::Statuses& item = statusesList[i];
        statusesHash[item.status] = item;
        }
 
    q.exec(R"'(
        select o.key, o.statuses, c.category, c.parent_category, c.description, c.price 
            from overview_params o
            left join categories c using (category)

save() [12/26]

QVariant DatabasePluginPostgres::save ( const Dbt::EventTypes & data )

virtual

Reimplementuje stejnojmenný prvek z Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 2396 v souboru database_plugin_postgres.cpp.

                                      {
            Dbt::Overview::UserSum s;
            s.user_name   = q.value(3).toString();
            s.duration    = q.value(5).toDouble();
            s.price       = q.value(6).toDouble();
            overview.userSum << s;
            continue;
            }
 
        int i = 0;
        Dbt::Overview::Tickets t;
        t.ticket        = q.value(i++).toInt();
        t.description   = q.value(i++).toString();
        t.user          = q.value(i++).toInt();
        t.user_name     = q.value(i++).toString();
        t.hour_price    = q.value(i++).toDouble();
        t.duration      = q.value(i++).toDouble();
        t.price         = q.value(i++).toDouble();
        t.status        = q.value(i++).toString();
        overview.tickets << t;
        }
 
    q.exec(R"'(
            with
            ticket_last_status as not materialized (
                select t.ticket, tl.status
                    from tickets t
                    left join lateral (select tn.ticket, tn.status
                                from  ticket_status tn, statuses s
                                where tn.ticket = t.ticket
                                  and tn.status = s.status
                                  and not s.ignored
                                order by ticket, date desc
                                limit 1
                                ) tl using (ticket)
                ),
            ticket_timesheets_sum as not materialized (
                select ticket, "user", date_to::date as date, sum(date_to - date_from) as duration
                    from ticket_timesheets
                    group by ticket, "user", date_to::date
                )
 
            select t.ticket, t.description, t."user", u.name, t.price as hour_price, ts.date, to_hours(ts.duration), round(to_hours(ts.duration) * t.price)
                from tickets t
                left join users u using ("user")
                left join ticket_last_status ls using (ticket)
                left join ticket_timesheets_sum ts using (ticket, "user")
                left join categories c using (category)
                where ls.status in (select status from overview_statuses_tmp)
                and category in (select category from overview_categories_tmp)

save() [13/26]

QVariant DatabasePluginPostgres::save ( const Dbt::Holidays & data )

virtual

Reimplementuje stejnojmenný prvek z Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 2547 v souboru database_plugin_postgres.cpp.

                                                      {
    MSqlQuery q(m_db);
    QList<Dbt::Doors> list; 
    q.prepare(R"'(select door, description from attendance.doors where door = :key1 or :key2 <= 0;)'");
    q.bindValue(":key1", door);
    q.bindValue(":key2", door);
    q.exec();
    while (q.next()) {
        Dbt::Doors x;
        int i=0;
        x.door          = q.value(i++).toInt();
        x.description   = q.value(i++).toString();
        list << x;
        }
    return list;

save() [14/26]

QVariant DatabasePluginPostgres::save ( const Dbt::Rfids & data )

virtual

Reimplementuje stejnojmenný prvek z Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 2497 v souboru database_plugin_postgres.cpp.

                     {
        int i=0;
        Dbt::OverviewList x;
        x.key = q.value(i++).toString();
 
        QStringList statuses = q.value(i++).toString().replace("{","").replace("}","").split(",");
        for (int i=0; i<statuses.size(); i++) {
            x.statuses << statusesHash[statuses[i]];
            }
 
        Dbt::Categories c;
        c.category          = q.value(i++).toString();
        c.parent_category   = q.value(i++).toString();
        c.description       = q.value(i++).toString();
        c.price             = q.value(i++).toDouble();
        x.category = c;
 
        list << x;
        }
 
    return list;
}
 
void DatabasePluginPostgres::remove(const Dbt::OverviewList& x) {
    MSqlQuery q(m_db);
    q.prepare(R"'(delete from overview_params where key = :key;)'");
    q.bindValue(":key", x.key);
    q.exec();
}
 
 
QList<Dbt::Departments> DatabasePluginPostgres::departments(int department) { 
    MSqlQuery q(m_db);
    QList<Dbt::Departments> list;
    q.prepare(R"'(select department, abbr, description from attendance.departments where department = :key1 or :key2 <= 0;)'");
    q.bindValue(":key1", department);
    q.bindValue(":key2", department);
    q.exec();
    while (q.next()) {
        Dbt::Departments x;
        int i=0;
        x.department    = q.value(i++).toInt();
        x.abbr          = q.value(i++).toString();
        x.description   = q.value(i++).toString();
        list << x;
        }
    return list;
}

save() [15/26]

QVariant DatabasePluginPostgres::save ( const Dbt::ServerInfo & data )

virtual

Reimplementuje stejnojmenný prvek z Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 340 v souboru database_plugin_postgres.cpp.

                                                        {

save() [16/26]

QVariant DatabasePluginPostgres::save ( const Dbt::Statuses & data )

virtual

Reimplementuje stejnojmenný prvek z Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 1480 v souboru database_plugin_postgres.cpp.

                              :user
              and :ticket = t.ticket
            ;
        )'");
    q.bindValue(":user", userId());
    q.bindValue(":ticket", ticket);
    q.exec();
    if (!q.next()) {
        return list;
        }
 
    // Zkontroluj, jestli je ticket dostupný pro uživatele a je běžící
    q.prepare(R"'(
        select tt.id 
            from ticket_timesheets tt, tickets t, users_categories uc
            where t.ticket = tt.ticket
              and t.category = uc.category
              and uc."user" = :user
              and :ticket = tt.ticket
              and tt.date_to is null
            ;
        )'");
    q.bindValue(":user", userId());
    q.bindValue(":ticket", ticket);
    q.setForwardOnly(false);
    q.exec();
    bool found = (q.size() == 1);
    int id = (found) ? q.next(), q.value(0).toInt() : 0;
 
    if (!found) {
        // Vložit timesheet
        q.prepare(R"'(

save() [17/26]

QVariant DatabasePluginPostgres::save ( const Dbt::StatusOrder & data )

virtual

Reimplementuje stejnojmenný prvek z Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 587 v souboru database_plugin_postgres.cpp.

                 :id", userId());
    q.exec();
    if (!q.next()) { return; }
 
    q.prepare(R"'(delete from users where "user" = :id;)'");
    q.bindValue(":id", id.user);
    q.exec();
}
 
 
QVariant DatabasePluginPostgres::save(const Dbt::Users& data) {
    MSqlQuery q(m_db);
 
    q.prepare(R"'(select 1 from users where "user" = :id and admin and enabled;)'");
    q.bindValue(":id", userId());
    q.exec();
    if (!q.next()) { return QVariant(); }
 
 
    q.prepare(R"'(select 1 from users where "user" = :id;)'");
    q.bindValue(":id", data.user);
    q.exec();
    if (q.next()) { 
        q.prepare(R"'(
            update users set
                login = :login,
                name = :name,
                lang = :lang,
                enabled = :enabled,

save() [18/26]

QVariant DatabasePluginPostgres::save ( const Dbt::TicketFiles & data )

virtual

Reimplementuje stejnojmenný prvek z Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 1584 v souboru database_plugin_postgres.cpp.

                     :date_to", data.date_to);
        q.exec();
 
        return currval("ticket_timesheets_id_seq");
        }
 
    Q_UNREACHABLE();
    return QVariant();
}
 
 
void DatabasePluginPostgres::remove(const Dbt::TicketTimesheets& id) {
    MSqlQuery q(m_db);
    q.prepare(R"'(delete from ticket_timesheets where id = :id;)'");
    q.bindValue(":id", id.id);
    q.exec();
}
 
 
QList<Dbt::TicketValues> DatabasePluginPostgres::ticketValues(int ticket, bool all) {
    createTemporaryTableTickets(ticket, all);
    QList<Dbt::TicketValues> list;
    MSqlQuery q(m_db);
    q.prepare(R"'(
        select tv.id, tt.ticket, tv.name, tv.value, tv."user", tv.date
            from temporary_tickets tt, ticket_values tv
            where tt.ticket = tv.ticket
            ;
        )'");
    q.exec();
    while (q.next()) {
        int i=0;
        Dbt::TicketValues x;
        x.id            = q.value(i++).toInt();
        x.ticket        = q.value(i++).toInt();
        x.name          = q.value(i++).toString();
        x.value         = JSON::data(q.value(i++).toByteArray());
        x.user          = q.value(i++).toInt();
        x.date          = q.value(i++).toDateTime();
        list << x;

save() [19/26]

QVariant DatabasePluginPostgres::save ( const Dbt::Tickets & data )

virtual

Reimplementuje stejnojmenný prvek z Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 741 v souboru database_plugin_postgres.cpp.

                                 :user
                  and (:ticket1 <= 0 or :ticket2 = t.ticket)
            ;
            )'");
      } else {
        PDEBUG << "Vybiram pouze otevrene" << ticket;
        q.prepare(R"'(
            with
            ending_status as (
                select status from statuses where closed
                ),
            ticket_last_status as (
                select t.ticket, tl.status
                    from tickets t
                    left join lateral (select tn.ticket, tn.status from ticket_status tn where tn.ticket = t.ticket order by ticket, date desc limit 1) tl using (ticket)
                ),
            closed_tickets as (
                select distinct ts.ticket from ticket_last_status ts, ending_status es where ts.status = es.status
                ),
            active_tickets as (
                select t1.ticket from tickets t1 where t1.ticket not in (select ticket from closed_tickets)
                )
 
            insert into temporary_tickets (ticket, category, date, price, description, "user")
            select t.ticket, t.category, t.date, t.price, t.description, t."user"
                from tickets t, users_categories uc
                where t.ticket in (select ticket from active_tickets)
                  and uc."user" = :user
                  and t.category = uc.category
                  and (:ticket1 <= 0 or :ticket2 = t.ticket)
            ;
            )'");
        }
    q.bindValue(":user", userId());

save() [20/26]

QVariant DatabasePluginPostgres::save ( const Dbt::TicketStatus & data )

virtual

Reimplementuje stejnojmenný prvek z Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 890 v souboru database_plugin_postgres.cpp.

                                                     :id;)'");
    q.bindValue(":id", id.ticket);
    q.exec();
}
 
 
QVariant DatabasePluginPostgres::save(const Dbt::Tickets& data) {
    MSqlQuery q(m_db);
 
    bool found = false;
    if (!data.created) {
        q.prepare(R"'(select 1 from tickets where ticket = :ticket;)'");
        q.bindValue(":ticket", data.ticket);
        q.exec();
        found = q.next();
        }
 
    if (!data.created && found) {
        q.prepare(R"'(
            update tickets set
                category = :category,
                date = :date,
                price = :price,
                description = :description,
               "user" = :user
                where ticket = :ticket
            )'");
        q.bindValue(":category", data.category);
        q.bindValue(":date", data.date);
        q.bindValue(":price", data.price);
        q.bindValue(":description", data.description);
        q.bindValue(":user", data.user);
        q.bindValue(":ticket", data.ticket);
        q.exec();
        return QVariant(data.ticket);
        }
 
    if (data.created || !found) {
        q.prepare(R"'(

save() [21/26]

QVariant DatabasePluginPostgres::save ( const Dbt::TicketsVw & data )

virtual

Reimplementuje stejnojmenný prvek z Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 796 v souboru database_plugin_postgres.cpp.

                                                                      {
    createTemporaryTableTickets(ticket, all);
    QList<Dbt::Tickets> list;
    MSqlQuery q(m_db);
 
    q.prepare(R"'(
        select ticket, category, date, price, description, "user"
            from temporary_tickets ;
        )'");
    q.exec();
    while (q.next()) {
        Dbt::Tickets x;
        int i=0;

save() [22/26]

QVariant DatabasePluginPostgres::save ( const Dbt::TicketTimesheets & data )

virtual

Reimplementuje stejnojmenný prvek z Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 1222 v souboru database_plugin_postgres.cpp.

                 :ticket", ticket);
    q.exec();
    while (q.next()) {
        int i=0;
        Dbt::TicketTimesheets x;
        x.id            = q.value(i++).toInt();
        x.ticket        = q.value(i++).toInt();
        x.user          = q.value(i++).toInt();
        x.date_from     = q.value(i++).toDateTime();
        x.date_to       = q.value(i++).toDateTime();
        list << x;
        }
    return list;
}
 
 
QList<Dbt::TicketTimesheets> DatabasePluginPostgres::ticketTimesheets(int id) {
    QList<Dbt::TicketTimesheets> list;
    MSqlQuery q(m_db);
    q.prepare(R"'(
        select tt.id, tt.ticket, tt."user", tt.date_from, tt.date_to
            from ticket_timesheets tt, tickets t, users_categories uc
            where t.ticket = tt.ticket
              and t.category = uc.category
              and uc."user" = :user
              and :id = tt.id
            order by tt.date_from
            ;
        )'");
    q.bindValue(":user", userId());
    q.bindValue(":id", id);
    q.exec();
    while (q.next()) {
        int i=0;
        Dbt::TicketTimesheets x;
        x.id            = q.value(i++).toInt();

save() [23/26]

QVariant DatabasePluginPostgres::save ( const Dbt::TicketValues & data )

virtual

Reimplementuje stejnojmenný prvek z Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 1316 v souboru database_plugin_postgres.cpp.

                 :user", userId());
    q.bindValue(":ticket", ticket);
    q.exec();
    if (q.next()) {
        return list;
        }
 
    // Zkontroluj, jestli je ticket dostupný pro uživatele a existující
    q.prepare(R"'(
        select 1 
            from tickets t, users_categories uc
            where t.category = uc.category
              and uc."user" = :user
              and :ticket = t.ticket
            ;
        )'");
    q.bindValue(":user", userId());
    q.bindValue(":ticket", ticket);
    q.exec();
    if (!q.next()) {
        return list;
        }
 
    // Vložit timesheet
    q.prepare(R"'(
        insert into ticket_timesheets (ticket, "user", date_from) 
            values (:ticket, :user, now())
        )'");
    q.bindValue(":user", userId());
    q.bindValue(":ticket", ticket);
    q.exec();
    QVariant id = currval("ticket_timesheets_id_seq").toInt();
    if (id.isNull() || !id.isValid()) {
        return list;
        }
 
    list = ticketTimesheets(id.toInt());

save() [24/26]

QVariant DatabasePluginPostgres::save ( const Dbt::Users & data )

virtual

Reimplementuje stejnojmenný prvek z Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 515 v souboru database_plugin_postgres.cpp.

                :id1 <= 0 and c.parent_category is null) or :id2 = c.parent_category)
          and u."user" = :user and (u.admin or u."user" in (select "user" from users_categories uc where uc.category = c.category))
            ;
        )'");
    q.bindValue(":user", userId());
    q.bindValue(":id1", id.toInt());
    q.bindValue(":id2", id.toInt());
    q.exec();
    while (q.next()) {
        int i=0;
        Dbt::Categories x;
        x.category = q.value(i++).toString();
        x.parent_category = null(q.value(i++).toString());
        x.description = q.value(i++).toString();
        x.price = q.value(i++).toDouble();
        x.users = pgArrayToVariantList(q.value(i++));
        x.description_tree = q.value(i++).toString();
        list << x;
        }
 
    return list;
}
 
 
QList<Dbt::Categories> DatabasePluginPostgres::siblingcategories(const QString& id) {
    QList<Dbt::Categories> list;
    MSqlQuery q(m_db);
 
    q.prepare(R"'(
        with recursive tree as (
            select category, parent_category
                from categories where category = :id
            union all
            select c.category, c.parent_category
                from tree t, categories c

save() [25/26]

QVariant DatabasePluginPostgres::save ( const Dbt::WorkCalendar & data )

virtual

Reimplementuje stejnojmenný prvek z Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 2564 v souboru database_plugin_postgres.cpp.

                                                                  {
    MSqlQuery q(m_db);
    QList<Dbt::Employees> list;
    q.prepare(R"'(select e.employee, e.firstname, e.surname, e.active, e."user", coalesce(u.login, '') as login,
                         e.work_hours_mode, e.rounding_interval,
                         e.saturdays_paid, e.sundays_paid, e.auto_breaks, e.overtime_paid
                    from attendance.employees e
                    left join users u on (u."user" = e."user")
                   where e.employee = :key1 or :key2 <= 0;)'");
    q.bindValue(":key1", employee);
    q.bindValue(":key2", employee);
    q.exec();
    while (q.next()) {
        Dbt::Employees x;
        int i=0;
        x.employee  = q.value(i++).toInt();
        x.firstname = q.value(i++).toString();
        x.surname   = q.value(i++).toString();

save() [26/26]

template<typename T>

void Db::Plugins::DatabasePluginPostgres::save ( const QList< T > & list )

inline

Definice je uvedena na řádku 78 v souboru database_plugin_postgres.h.

                                                         {
        QListIterator<T> iterator(list);
        while (iterator.hasNext()) {
            save(iterator.next());
            }
        }

serverInfo()

QList< Dbt::ServerInfo > DatabasePluginPostgres::serverInfo ( )

virtual

Reimplementuje stejnojmenný prvek z Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 324 v souboru database_plugin_postgres.cpp.

                     {
        Dbt::ClientSettings x;
        int i = 0;
        x.multiple_timesheets = q.value(i++).toBool(); 
        x.show_price = q.value(i++).toBool(); 
        x.can_change_category = q.value(i++).toBool(); 

setDatabaseName()

void Db::Plugins::DatabasePluginPostgres::setDatabaseName ( const QString & x )

inlinevirtual

Implementuje Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 25 v souboru database_plugin_postgres.h.

{ m_databasename = x; }

setHostname()

void Db::Plugins::DatabasePluginPostgres::setHostname ( const QString & x )

inlinevirtual

Implementuje Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 26 v souboru database_plugin_postgres.h.

{ m_hostname = x; }

setPassword()

void Db::Plugins::DatabasePluginPostgres::setPassword ( const QString & x )

inlinevirtual

Implementuje Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 29 v souboru database_plugin_postgres.h.

{ m_password = x; }

setPort()

void Db::Plugins::DatabasePluginPostgres::setPort ( int x )

inlinevirtual

Implementuje Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 27 v souboru database_plugin_postgres.h.

{ m_port = x; }

setUserName()

void Db::Plugins::DatabasePluginPostgres::setUserName ( const QString & x )

inlinevirtual

Implementuje Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 28 v souboru database_plugin_postgres.h.

{ m_username = x; }

siblingcategories()

QList< Dbt::Categories > DatabasePluginPostgres::siblingcategories ( const QString & id )

virtual

Implementuje Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 477 v souboru database_plugin_postgres.cpp.

              :id = c.category
          and u."user" = :user and (u.admin or u."user" in (select "user" from users_categories uc where uc.category = c.category))
          ;
        )'");
    for (;;) {
        q.bindValue(":user", userId());
        q.bindValue(":id", xid);
        q.exec();
        bool found = q.next();
        PDEBUG << xid << found;
        if (!found) { return list; }
        int i=0;
        Dbt::Categories x;
        x.category = q.value(i++).toString();
        x.parent_category = null(q.value(i++).toString());

startTimesheet()

QList< Dbt::TicketTimesheets > DatabasePluginPostgres::startTimesheet ( int ticket )

virtual

Implementuje Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 1032 v souboru database_plugin_postgres.cpp.

                          :id
              and t.ticket = ts.ticket
              and t.category = uc.category
              and u."user" = ts."user"
              and ts.status = s.status
        )'");
    q.bindValue(":id", id);
    q.bindValue(":user", userId());
    q.exec();
    while (q.next()) {
        Dbt::TicketStatus x;
        int i=0;
        x.id            = q.value(i++).toInt();
        x.ticket        = q.value(i++).toInt();
        x.user          = q.value(i++).toInt();
        x.date          = q.value(i++).toDateTime();
        x.description   = q.value(i++).toString();
        x.status        = q.value(i++).toString();
        x.status_color  = q.value(i++).toString();
        x.status_description = q.value(i++).toString();
        x.status_closed = q.value(i++).toBool();
        x.status_can_be_run = q.value(i++).toBool();
        x.status_ignored    = q.value(i++).toBool();
        list << x;
        }
    return list;
}
 
 
 
void DatabasePluginPostgres::remove(const Dbt::TicketStatus& id) {
    MSqlQuery q(m_db);
    q.prepare(R"'(delete from ticket_status where id = :id;)'");
    q.bindValue(":id", id.id);
    q.exec();

statuses() [1/2]

QList< Dbt::Statuses > DatabasePluginPostgres::statuses ( const QString & id )

virtual

Implementuje Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 1366 v souboru database_plugin_postgres.cpp.

                              :user
              and :ticket = tt.ticket
              and tt.date_to is null
            ;
        )'");
    q.bindValue(":user", userId());
    q.bindValue(":ticket", ticket);
    q.setForwardOnly(false);
    q.exec();
    if (q.size() != 1) {
        q.commit();
        return list;
        }
    q.next();
    int id = q.value(0).toInt();
 
    // Ukončit timesheet
    q.prepare(R"'(
        update ticket_timesheets set date_to = now() where id = :id;
        )'");
    q.bindValue(":id", id);
    q.exec();
 
    list = ticketTimesheets(ticket, true);
 
    int remove_secs = 10;
    int round2_mins = 5;
    int round5_mins = 5;
    int join_mins = 5;
    int remove_singles_mins = 3;
 
    // step 1 - remove timesheets shorter than ...
    for (int i=list.size()-1; i>=0; i--) {
        Dbt::TicketTimesheets& x = list[i];
        if (x.date_from.secsTo(x.date_to) > remove_secs) { continue; }
        list.removeAt(i);
        }

statuses() [2/2]

QList< Dbt::Statuses > DatabasePluginPostgres::statuses ( const QString & category, const QString & previousStatus )

virtual

Implementuje Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 1410 v souboru database_plugin_postgres.cpp.

                                         {
        Dbt::TicketTimesheets& x = list[i];
        int secs;
        secs = x.date_from.secsTo(x.date_to);
        secs = secs / (round2_mins * 60) + ( (secs % (round2_mins*60)) ? 1 : 0);
        secs = secs * (round2_mins * 60);
        x.date_to = x.date_from.addSecs(secs);
        }
 
    // step3 - join overlapinng records
    for (int i=list.size()-1; i>=1; i--) {
        Dbt::TicketTimesheets& x0 = list[i-1];
        Dbt::TicketTimesheets& x1 = list[i];
 
        if (x0.date_to < x1.date_from) { continue; }
        x0.date_to = x1.date_to;
        list.removeAt(i);
        }
 
    // step4 - join near records
    for (int i=list.size()-1; i>=1; i--) {
        Dbt::TicketTimesheets& x0 = list[i-1];
        Dbt::TicketTimesheets& x1 = list[i];
        if (x0.date_to.addSecs(join_mins*60) < x1.date_from) { continue; }
        x0.date_to = x1.date_to;
        list.removeAt(i);
        }
 
    // step5  - round timetracks to ...
    for (int i=list.size()-1; i>=0; i--) {
        Dbt::TicketTimesheets& x = list[i];
        int secs;
        secs = x.date_from.secsTo(x.date_to);
        secs = secs + (round5_mins * 60) -1;
        secs = secs / (round5_mins * 60);
        secs = secs * (round5_mins * 60);
        x.date_to = x.date_from.addSecs(secs);
        }
 
    // step6 - remove short single records
    for (int i=list.size()-1; i>=0; i--) {
        Dbt::TicketTimesheets& x = list[i];
        int secs = x.date_from.secsTo(x.date_to);
        if (secs <= 0) { continue; }
        if (secs >= remove_singles_mins * 60) { continue; }
        list.removeAt(i);
        }
 
    q.prepare(R"'(delete from ticket_timesheets where ticket = :ticket;)'");
    q.bindValue(":ticket", ticket);
    q.exec();
 
    q.prepare(R"'(insert into ticket_timesheets (ticket, "user", date_from, date_to) 
            values (:ticket, :user, :date_from, :date_to);
        )'");
    for (int i=0; i<list.size(); i++) {
        Dbt::TicketTimesheets& x = list[i];
        q.bindValue(":ticket", ticket);
        q.bindValue(":user", userId());
        q.bindValue(":date_from", x.date_from);

statusOrder()

QList< Dbt::StatusOrder > DatabasePluginPostgres::statusOrder ( const QString & id )

virtual

Implementuje Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 556 v souboru database_plugin_postgres.cpp.

                         :user and (u.admin or u."user" in (select "user" from users_categories uc where uc.category = c.category))
          and c.category not in (select category from tree)
            ;
        )'");
    q.bindValue(":user", userId());
    q.bindValue(":id",   id.toInt());
    q.exec();
    while (q.next()) {
        int i=0;
        Dbt::Categories x;
        x.category = q.value(i++).toString();
        x.parent_category = null(q.value(i++).toString());
        x.description = q.value(i++).toString();
        x.price = q.value(i++).toDouble();
        x.users = pgArrayToVariantList(q.value(i++));
        x.description_tree = q.value(i++).toString();
        list << x;

statusTemplates()

QList< Dbt::StatusTemplates > DatabasePluginPostgres::statusTemplates ( int id )

virtual

Implementuje Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 1522 v souboru database_plugin_postgres.cpp.

                     :user", userId());
        q.bindValue(":ticket", ticket);
        q.exec();
        QVariant newid = currval("ticket_timesheets_id_seq");
        if (newid.isNull() || !newid.isValid()) {

stopTimesheet()

QList< Dbt::TicketTimesheets > DatabasePluginPostgres::stopTimesheet ( int ticket )

virtual

Implementuje Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 1069 v souboru database_plugin_postgres.cpp.

                                                                 {
    MSqlQuery q(m_db);
 
    bool found = false;
    if (!data.created) {
        q.prepare(R"'(select 1 from ticket_status where id = :id;)'");
        q.bindValue(":id", data.id);
        q.exec();
        found = q.next();
        }
 
    if (!data.created && found) {
        q.prepare(R"'(
            update ticket_status set
                ticket = :ticket,
               "user" = :user,
                date = :date,
                description = :description,
                status = :status
                where id = :id
            )'");
        q.bindValue(":id", data.id);
        q.bindValue(":user", data.user);
        q.bindValue(":ticket", data.ticket);
        q.bindValue(":date", data.date);
        q.bindValue(":description", data.description);
        q.bindValue(":status", data.status);
        q.exec();
        return QVariant(data.id);
        }
 
    if (data.created || !found) {
        q.prepare(R"'(
            insert into ticket_status (ticket, "user", date, description, status)
                values (:ticket, :user, :date, :description, :status)
            )'");
        q.bindValue(":user", data.user);
        q.bindValue(":ticket", data.ticket);
        q.bindValue(":date", data.date);
        q.bindValue(":description", data.description);
        q.bindValue(":status", data.status);
        q.exec();
 
        return currval("ticket_status_id_seq");
        }
 
    Q_UNREACHABLE();
    qFatal("Should not happen");
    return QVariant();
}
 
 
QVariant DatabasePluginPostgres::save(const Dbt::AppendStatuses& data) {
    PDEBUG << data.toMap();
 
    QString statusesX;
    QStringList statusesL;
    for (int i=0; i<data.recent_status.size(); i++) {
        statusesL << "'" + data.recent_status[i].toString() + "'";
        }
    statusesL.sort();
    statusesX = statusesL.join(",");
 
    QString categoriesX;
    QStringList categoriesL;
    for (int i=0; i<data.categories.size(); i++) {
        categoriesL << "'" + data.categories[i].toString() + "'";
        }
    categoriesL.sort();
    categoriesX = categoriesL.join(",");
 
    MSqlQuery q(m_db);
    q.prepare(QString(R"'(
            with
 
            -- select statuses
            x_statuses as (
                select * from statuses
                where status in (%1)
                  and not ignored
                ),
 
            -- select new status, if possible
            x_newstatuses as (
                select distinct s.*
                 from statuses s, status_order o
                where status = :status
                  and s.status = o.next_status
                  and o.previous_status in (select status from x_statuses)
                ),
 
            -- select current user
            x_users as (
                select *
                    from users
                    where "user" = :userid
                ),
 
            -- select valid categories
            x_categories as (
                select c.*
                    from categories c, x_users u
                    where c.category in (%2)

subcategories()

QList< Dbt::Categories > DatabasePluginPostgres::subcategories ( const QString & id )

virtual

Implementuje Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 452 v souboru database_plugin_postgres.cpp.

                         :user and (u.admin or u."user" in (select "user" from users_categories uc where uc.category = c.category))
            ;
        )'");
    q.bindValue(":user", userId());
    q.bindValue(":id1", id.toInt());
    q.bindValue(":id2", id.toInt());
    q.exec();
    while (q.next()) {
        int i=0;
        Dbt::Categories x;
        x.category = q.value(i++).toString();
        x.parent_category = null(q.value(i++).toString());
        x.description = q.value(i++).toString();
        x.price = q.value(i++).toDouble();
        x.users = pgArrayToVariantList(q.value(i++));
        x.description_tree = q.value(i++).toString();
        list << x;
        }
 
    return list;
}
 
 

ticketFiles() [1/3]

QList< Dbt::TicketFiles > DatabasePluginPostgres::ticketFiles ( bool all )

virtual

Implementuje Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 1579 v souboru database_plugin_postgres.cpp.

                        :ticket, :user, :date_from, :date_to)
            )'");
        q.bindValue(":user", data.user);

ticketFiles() [2/3]

QList< Dbt::TicketFiles > DatabasePluginPostgres::ticketFiles ( int id )

virtual

Implementuje Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 1554 v souboru database_plugin_postgres.cpp.

                                {
        q.prepare(R"'(
            update ticket_timesheets set
                ticket = :ticket,
               "user" = :user,
                date_from = :date_from,
                date_to = :date_to
                where id = :id
            )'");
        q.bindValue(":id", data.id);
        q.bindValue(":user", data.user);
        q.bindValue(":ticket", data.ticket);
        q.bindValue(":date_from", data.date_from);
        q.bindValue(":date_to", data.date_to);
        q.exec();
        return QVariant(data.id);
        }
 
    if (data.created || !found) {

ticketFiles() [3/3]

QList< Dbt::TicketFiles > DatabasePluginPostgres::ticketFiles ( int ticket, bool all )

virtual

Implementuje Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 1530 v souboru database_plugin_postgres.cpp.

               {
        // Ukončit timesheet
        q.prepare(R"'(
            update ticket_timesheets set date_to = now() where id = :id;
            )'");
        q.bindValue(":id", id);
        q.exec();
        }
 
    list = ticketTimesheets(id);
    return list;
}
 
 
QVariant DatabasePluginPostgres::save(const Dbt::TicketTimesheets& data) {
    MSqlQuery q(m_db);
 
    bool found = false;
    if (!data.created) {

tickets() [1/3]

QList< Dbt::Tickets > DatabasePluginPostgres::tickets ( bool all )

virtual

Implementuje Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 643 v souboru database_plugin_postgres.cpp.

tickets() [2/3]

QList< Dbt::Tickets > DatabasePluginPostgres::tickets ( const Dbt::Categories & category, bool all )

virtual

Implementuje Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 670 v souboru database_plugin_postgres.cpp.

                                                            {
    MSqlQuery q(m_db);
    q.prepare(R"'(delete from status_order where id = :id;)'");
    q.bindValue(":id", id.id);
    q.exec();
}
 
 
QVariant DatabasePluginPostgres::save(const Dbt::StatusOrder& data) {
    MSqlQuery q(m_db);
 
    q.prepare(R"'(select 1 from status_order where id = :id;)'");
    q.bindValue(":id", data.id);
    q.exec();
    if (q.next()) {

tickets() [3/3]

QList< Dbt::Tickets > DatabasePluginPostgres::tickets ( int ticket, bool all )

virtual

Implementuje Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 648 v souboru database_plugin_postgres.cpp.

                                                                           {
    QList<Dbt::StatusOrder> list;
    MSqlQuery q(m_db);
 
    q.prepare(R"'(
        select id, category, previous_status, next_status from status_order
        where (:id1 <= 0 or :id2 = id);
        )'");
    q.bindValue(":id1", id.toInt());
    q.bindValue(":id2", id.toInt());
    q.exec();
    while (q.next()) {
        int i = 0;
        Dbt::StatusOrder x;
        x.id                = q.value(i++).toInt();
        x.category          = q.value(i++);
        x.previous_status   = q.value(i++);
        x.next_status       = q.value(i++);

ticketStatus() [1/3]

QList< Dbt::TicketStatus > DatabasePluginPostgres::ticketStatus ( bool all )

virtual

Implementuje Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 848 v souboru database_plugin_postgres.cpp.

                                                              {
    return ticketsVw(-1, all);

ticketStatus() [2/3]

QList< Dbt::TicketStatus > DatabasePluginPostgres::ticketStatus ( int id )

virtual

Implementuje Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 853 v souboru database_plugin_postgres.cpp.

                                                                          {
    QList<Dbt::Tickets> list1 = tickets(ticket,all);
    QList<Dbt::TicketsVw> list;
    MSqlQuery q(m_db);
    for (int i=0; i<list1.size(); i++) {
        Dbt::TicketsVw x = list1[i];
        x.timesheets = ticketTimesheets(list1[i].ticket.toInt(), all);
        x.statuses = ticketStatus(list1[i].ticket.toInt(), all);
        x.values = ticketValues(list1[i].ticket.toInt(), all);
        x.files = ticketFiles(list1[i].ticket.toInt(), all);
        list << x;
        }
 
    return list;
}
 
 
QList<Dbt::TicketsVw> DatabasePluginPostgres::ticketsVw(const Dbt::Categories& category, bool all) {
    QList<Dbt::Tickets> list1 = tickets(category, all);
    QList<Dbt::TicketsVw> list;
    MSqlQuery q(m_db);
    for (int i=0; i<list1.size(); i++) {
        Dbt::TicketsVw x = list1[i];
        x.timesheets = ticketTimesheets(list1[i].ticket.toInt(), true);
        x.statuses = ticketStatus(list1[i].ticket.toInt(), true);

ticketStatus() [3/3]

QList< Dbt::TicketStatus > DatabasePluginPostgres::ticketStatus ( int ticket, bool all )

virtual

Implementuje Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 820 v souboru database_plugin_postgres.cpp.

                                                                                         {
    createTemporaryTableTickets(-1, all);
    QList<Dbt::Tickets> list;
    MSqlQuery q(m_db);
 
    q.prepare(R"'(
        select ticket, category, date, price, description, "user"
            from temporary_tickets 
           where category = :category;
        )'");
    q.bindValue(":category", category.category);
    q.exec();
    while (q.next()) {
        Dbt::Tickets x;
        int i=0;
        x.ticket        = q.value(i++);
        x.category      = q.value(i++);
        x.date          = q.value(i++).toDateTime();
        x.price         = q.value(i++).toDouble();
        x.description   = q.value(i++).toString();
        x.user          = q.value(i++).toInt();
        list << x;
        }
    return list;
}

ticketsVw() [1/3]

QList< Dbt::TicketsVw > DatabasePluginPostgres::ticketsVw ( bool all )

virtual

Implementuje Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 694 v souboru database_plugin_postgres.cpp.

                                  :previous_status,
                next_status = :next_status
                where id = :id

ticketsVw() [2/3]

QList< Dbt::TicketsVw > DatabasePluginPostgres::ticketsVw ( const Dbt::Categories & category, bool all )

virtual

Implementuje Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 716 v souboru database_plugin_postgres.cpp.

                                                                             {
    if (m_temporaryTableTicketsCreated) { return; }
    m_temporaryTableTicketsCreated = true;
    MSqlQuery q(m_db);
    q.exec(R"'(
        create temporary table temporary_tickets (
            ticket      int,

ticketsVw() [3/3]

QList< Dbt::TicketsVw > DatabasePluginPostgres::ticketsVw ( int ticket, bool all )

virtual

Implementuje Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 699 v souboru database_plugin_postgres.cpp.

                     :previous_status", data.previous_status);
        q.bindValue(":next_status", data.next_status);
        q.bindValue(":id", data.id);
        q.exec();
        return QVariant(data.id);
 
      } else {
 
        q.prepare(R"'(
            insert into status_order (category, previous_status, next_status)
                select :category, :previous_status, :next_status
            )'");
        q.bindValue(":category", data.category);
        q.bindValue(":previous_status", data.previous_status);
        q.bindValue(":next_status", data.next_status);

ticketTimesheets() [1/3]

QList< Dbt::TicketTimesheets > DatabasePluginPostgres::ticketTimesheets ( bool all )

virtual

Implementuje Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 1005 v souboru database_plugin_postgres.cpp.

ticketTimesheets() [2/3]

QList< Dbt::TicketTimesheets > DatabasePluginPostgres::ticketTimesheets ( int id )

virtual

Implementuje Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 984 v souboru database_plugin_postgres.cpp.

                                                                                {
    createTemporaryTableTickets(ticket, all);
    QList<Dbt::TicketStatus> list;
    MSqlQuery q(m_db);
 
    q.prepare(R"'(
        select ts.id, ts.ticket, ts."user", ts.date, ts.description, ts.status, s.color, s.description, s.closed, s.can_be_run, s.ignored
            from temporary_tickets t, ticket_status ts, statuses s
            where t.ticket = ts.ticket
              and ts.status = s.status
              and t.ticket = :ticket
        )'");
    q.bindValue(":ticket", ticket);
    q.exec();
    while (q.next()) {
        Dbt::TicketStatus x;
        int i=0;

ticketTimesheets() [3/3]

QList< Dbt::TicketTimesheets > DatabasePluginPostgres::ticketTimesheets ( int ticket, bool all )

virtual

Implementuje Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 963 v souboru database_plugin_postgres.cpp.

                                                            {
    MSqlQuery q(m_db);
    q.exec(QString(R"'(delete from ticket_timesheets where ticket = %1;)'").arg(ticket));
    q.exec(QString(R"'(delete from ticket_status where ticket = %1;)'").arg(ticket));
    q.exec(QString(R"'(delete from ticket_values where ticket = %1;)'").arg(ticket));

ticketValues() [1/3]

QList< Dbt::TicketValues > DatabasePluginPostgres::ticketValues ( bool all )

virtual

Implementuje Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 1311 v souboru database_plugin_postgres.cpp.

ticketValues() [2/3]

QList< Dbt::TicketValues > DatabasePluginPostgres::ticketValues ( int id )

virtual

Implementuje Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 1289 v souboru database_plugin_postgres.cpp.

                     {
        int i=0;
        Dbt::TicketTimesheets x;
        x.id            = q.value(i++).toInt();
        x.ticket        = q.value(i++).toInt();
        x.user          = q.value(i++).toInt();
        x.date_from     = q.value(i++).toDateTime();
        x.date_to       = q.value(i++).toDateTime();
        list << x;
        }
    return list;
}
 
 
QList<Dbt::TicketTimesheets> DatabasePluginPostgres::startTimesheet(int ticket) {
    QList<Dbt::TicketTimesheets> list;
    MSqlQuery q(m_db);
 
    // Zkontroluj, jestli je ticket dostupný pro uživatele a je zastavený

ticketValues() [3/3]

QList< Dbt::TicketValues > DatabasePluginPostgres::ticketValues ( int ticket, bool all )

virtual

Implementuje Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 1268 v souboru database_plugin_postgres.cpp.

                                                                            {
    return ticketTimesheets(-1, all);
}
 
 
QList<Dbt::TicketTimesheets> DatabasePluginPostgres::runningTimesheets(int ticket) {
    QList<Dbt::TicketTimesheets> list;
    MSqlQuery q(m_db);
    q.prepare(R"'(
        select tt.id, tt.ticket, tt."user", tt.date_from, tt.date_to
            from ticket_timesheets tt, tickets t, users_categories uc
            where t.ticket = tt.ticket
              and t.category = uc.category
              and uc."user" = :user
              and tt.date_to is null
              and (:ticket1 = tt.ticket or :ticket2 <= 0)
            ;
        )'");
    q.bindValue(":user", userId());

toggleTimesheet()

QList< Dbt::TicketTimesheets > DatabasePluginPostgres::toggleTimesheet ( int ticket )

virtual

Implementuje Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 1175 v souboru database_plugin_postgres.cpp.

                                       :description, n.status
                from x_tickets t, x_users u, x_newstatuses n
 
        )'").arg(statusesX).arg(categoriesX));
    q.bindValue(":user", data.status);
    q.bindValue(":status", data.status);
    q.bindValue(":description", data.description);
    q.bindValue(":userid", userId());
    PDEBUG << q.lastBoundQuery();
    q.exec();
 
    return QVariant();
}
 
 
QList<Dbt::TicketTimesheets> DatabasePluginPostgres::ticketTimesheets(int ticket, bool all) {
    createTemporaryTableTickets(ticket, all);
    QList<Dbt::TicketTimesheets> list;
    MSqlQuery q(m_db);
    q.prepare(R"'(
        select tt.id, tt.ticket, tt."user", tt.date_from, tt.date_to
            from temporary_tickets t, ticket_timesheets tt
            where t.ticket = tt.ticket
              and t.ticket = :ticket
              order by tt.date_from -- must be sorted!

upgrade()

void DatabasePluginPostgres::upgrade

(

)

Definice je uvedena na řádku 62 v souboru database_plugin_postgres.cpp.

                                     {
    if (m_upgraded) { return; }
    PDEBUG;
    m_upgraded = true;
    MSqlQuery q(m_db);
    for (int version=0; version < 1000; version++) {
        MSqlQuery qx(m_db);
        qx.prepare("select * from version where version = :version");
        qx.bindValue(":version", version);
        qx.exec();
        if (qx.next()) {
            continue;
            }
 
        QString patchname = QString(":/postgres/patch.%1.sql").arg(version, 3, 10, QChar('0'));
        QFile file(patchname);
        if (!file.open(QIODevice::ReadOnly)) {
            continue;
            }
 
        PDEBUG << "aplying db patch " << patchname;
 
        while (!file.atEnd()) {
            QByteArray command;
            QByteArray line;
            do  {
                line = file.readLine();
                command += line;
                } while (!line.contains(";") && !file.atEnd());
            command = command.trimmed();
            if (command.isEmpty()) { continue; }
            MSqlQuery q(m_db);
            if (!q.exec(QString::fromUtf8(command))) {
                QSqlError e = q.lastError();
                if (e.type() != QSqlError::NoError) {
                    PDEBUG << q.lastQuery();
                    PDEBUG << e.databaseText();
                    PDEBUG << e.driverText();
                    return;
                    }
                }
            }
 
        }
 
    return;
}

users()

QList< Dbt::Users > DatabasePluginPostgres::users ( int id )

virtual

Implementuje Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 182 v souboru database_plugin_postgres.cpp.

                                                    {
    QList<Dbt::Users> list;
    MSqlQuery q(m_db);
    q.prepare(R"'(
        select "user", login, name, lang, enabled, admin 
            from users 
            where (:id1 <= 0 or :id2 = "user");
        )'");
    q.bindValue(":id1", id);
    q.bindValue(":id2", id);
    q.exec();
    while (q.next()) {
        int i=0;
        Dbt::Users x;
        x.user          = q.value(i++).toInt();
        x.login         = q.value(i++).toString();
        x.name          = q.value(i++).toString();
        x.lang          = q.value(i++).toString();
        x.enabled       = q.value(i++).toBool();
        x.admin         = q.value(i++).toBool();
        list << x;

usersCategories()

QList< Dbt::UsersCategories > DatabasePluginPostgres::usersCategories ( int id, int user, const QString & category )

virtual

Implementuje Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 1634 v souboru database_plugin_postgres.cpp.

                            :user
              and :id = tv.id
            ;
        )'");
    q.bindValue(":id", id);
    q.bindValue(":user", userId());
    q.exec();
    while (q.next()) {
        int i=0;
        Dbt::TicketValues x;
        x.id            = q.value(i++).toInt();
        x.ticket        = q.value(i++).toInt();
        x.date          = q.value(i++).toDateTime();
        x.name          = q.value(i++).toString();
        x.value         = JSON::data(q.value(i++).toByteArray());
        x.user          = q.value(i++).toInt();
        list << x;
        }
    return list;
}
 
 
QList<Dbt::TicketValues> DatabasePluginPostgres::ticketValues(bool all) {
    return ticketValues(-1, all);
}
 
 
QVariant DatabasePluginPostgres::save(const Dbt::TicketValues& data) {
    MSqlQuery q(m_db);
 
    bool found = false;
    if (!data.created) {
        q.prepare(R"'(select 1 from ticket_values where id = :id;)'");
        q.bindValue(":id", data.id);
        q.exec();
        found = q.next();
        }
 
    if (!data.created && found) {
        q.prepare(QString(R"'(
            update ticket_values set
                ticket = :ticket,
               "user" = :user,
                date = :date,
                name = :name,

workCalendar()

QList< Dbt::WorkCalendar > DatabasePluginPostgres::workCalendar ( const QDate & period )

virtual

Reimplementuje stejnojmenný prvek z Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 2162 v souboru database_plugin_postgres.cpp.

Dokumentace datových členů

m_databasename

QString Db::Plugins::DatabasePluginPostgres::m_databasename

private

Definice je uvedena na řádku 178 v souboru database_plugin_postgres.h.

m_hostname

QString Db::Plugins::DatabasePluginPostgres::m_hostname

private

Definice je uvedena na řádku 179 v souboru database_plugin_postgres.h.

m_password

QString Db::Plugins::DatabasePluginPostgres::m_password

private

Definice je uvedena na řádku 181 v souboru database_plugin_postgres.h.

m_port

int Db::Plugins::DatabasePluginPostgres::m_port

private

Definice je uvedena na řádku 182 v souboru database_plugin_postgres.h.

m_temporaryTableTicketsCreated

bool Db::Plugins::DatabasePluginPostgres::m_temporaryTableTicketsCreated

private

Definice je uvedena na řádku 185 v souboru database_plugin_postgres.h.

m_upgraded

bool DatabasePluginPostgres::m_upgraded = false

staticprivate

Definice je uvedena na řádku 184 v souboru database_plugin_postgres.h.

m_username

QString Db::Plugins::DatabasePluginPostgres::m_username

private

Definice je uvedena na řádku 180 v souboru database_plugin_postgres.h.

---

Dokumentace pro tuto třídu byla vygenerována z následujících souborů:

• database/postgres/database_plugin_postgres.h
• database/postgres/database_plugin_postgres.cpp