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

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

Veřejné metody
	DatabasePluginFotomon (QObject *)
template<typename T>
void	save (const QList< T > &list)
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::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::UsersCategories >	usersCategories (int id, int user, const QString &category) 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 &id) 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::Rfids >	rfids (int rfid) Q_DECL_OVERRIDE
QList< Dbt::Rfids >	rfidsById (const QString &rfidId) 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
void	remove (const Dbt::Tickets &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
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 QList< Dbt::ServerInfo >	serverInfo ()
virtual QList< Dbt::Departments >	departments (int department)
virtual QList< Dbt::Doors >	doors (int door)
virtual QList< Dbt::Employees >	employees (int employee)
virtual QList< Dbt::EventTypes >	eventTypes (const QString &eventType)
virtual QList< Dbt::Events >	events (int event, int employee=-1, const QDate &month=QDate(), int limit=-1, int offset=-1)
virtual QList< Dbt::DepartmentHasManager >	departmentHasManager (const Dbt::DepartmentHasManager &)
virtual QList< Dbt::DepartmentHasMember >	departmentHasMember (const Dbt::DepartmentHasMember &)
virtual QList< Dbt::EmployeeCanOpenDoor >	employeeCanOpenDoor (const Dbt::EmployeeCanOpenDoor &)
virtual QList< Dbt::EmployeeHasRfid >	employeeHasRfid (const Dbt::EmployeeHasRfid &)
virtual QList< Dbt::Holidays >	holidays (const QDate &date)
virtual QList< Dbt::WorkCalendar >	workCalendar (const QDate &period)
virtual void	generateWorkCalendar (int year)
virtual void	copyHolidays (int fromYear, int toYear)
virtual QList< Dbt::AttendanceChecklist >	attendanceChecklist (int employee, const QDate &month)
virtual QList< Dbt::Employees >	attendanceChecklist (const QDate &month)
virtual QList< Dbt::AttendanceSummary >	attendanceSummary (int employee, const QDate &month)
virtual QList< Dbt::AttendancePresent >	attendancePresent ()
virtual QList< Dbt::AttendanceRecent >	attendanceRecent (int employee)
virtual Dbt::UserEmployeeAccess	canAccessAttendance (int employee)
virtual void	remove (const Dbt::Users &data)
virtual void	remove (const Dbt::UsersCategories &data)
virtual void	remove (const Dbt::Categories &data)
virtual void	remove (const Dbt::StatusOrder &data)
virtual void	remove (const Dbt::Statuses &data)
virtual void	remove (const Dbt::TicketStatus &data)
virtual void	remove (const Dbt::OverviewList &data)
virtual void	remove (const Dbt::Departments &data)
virtual void	remove (const Dbt::Doors &data)
virtual void	remove (const Dbt::Employees &data)
virtual void	remove (const Dbt::EventTypes &data)
virtual void	remove (const Dbt::Events &data)
virtual void	remove (const Dbt::DepartmentHasManager &data)
virtual void	remove (const Dbt::DepartmentHasMember &data)
virtual void	remove (const Dbt::EmployeeCanOpenDoor &data)
virtual void	remove (const Dbt::EmployeeHasRfid &data)
virtual void	remove (const Dbt::Rfids &data)
virtual void	remove (const Dbt::Holidays &data)
virtual void	remove (const Dbt::WorkCalendar &data)
virtual void	remove (const Dbt::AttendanceSummary &data)
virtual QVariant	save (const Dbt::Users &data)
virtual QVariant	save (const Dbt::UsersCategories &data)
virtual QVariant	save (const Dbt::Categories &data)
virtual QVariant	save (const Dbt::StatusOrder &data)
virtual QVariant	save (const Dbt::Statuses &data)
virtual QVariant	save (const Dbt::ServerInfo &data)
virtual QVariant	save (const Dbt::AppendStatuses &data)
virtual QVariant	save (const Dbt::Departments &data)
virtual QVariant	save (const Dbt::Doors &data)
virtual QVariant	save (const Dbt::Employees &data)
virtual QVariant	save (const Dbt::EventTypes &data)
virtual QVariant	save (const Dbt::Events &data)
virtual QVariant	save (const Dbt::DepartmentHasManager &data)
virtual QVariant	save (const Dbt::DepartmentHasMember &data)
virtual QVariant	save (const Dbt::EmployeeCanOpenDoor &data)
virtual QVariant	save (const Dbt::EmployeeHasRfid &data)
virtual QVariant	save (const Dbt::Rfids &data)
virtual QVariant	save (const Dbt::Holidays &data)
virtual QVariant	save (const Dbt::WorkCalendar &data)
virtual QVariant	save (const Dbt::AttendanceSummary &data)

Privátní metody
void	createTemporaryTableCategories ()
void	createTemporaryTableTickets (int ticket, bool all)
QVariant	currval (const QString &sequence)

Statické privátní metody
static QString	parentCategoryKey (const QVariant &type, const QVariant &system, const QVariant &category, int parent_type)
static QString	categoryKey (const QVariant &type, const QVariant &system, const QVariant &category, int parent_type)
static QByteArray	fileContent (const QString &filename)
static QString	suffixFromType (const QString &type)

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

Další zděděné členy
Veřejné atributy dědí se z Db::Plugins::DatabasePlugin
const AuthenticatedUser *	m_authenticatedUser = nullptr
Chráněné metody dědí se z Db::Plugins::DatabasePlugin
int	userId () const
bool	userAuthenticated () const
QString	userLogin () const
QString	userLang () const
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_fotomon.h.

Dokumentace konstruktoru a destruktoru

DatabasePluginFotomon()

DatabasePluginFotomon::DatabasePluginFotomon

(

QObject *

parent

)

Definice je uvedena na řádku 26 v souboru database_plugin_fotomon.cpp.

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

~DatabasePluginFotomon()

DatabasePluginFotomon::~DatabasePluginFotomon

(

)

Definice je uvedena na řádku 21 v souboru database_plugin_fotomon.cpp.

                                              {
    close();
}

Dokumentace členských funkcí

authenticate()

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

virtual

Implementuje Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 90 v souboru database_plugin_fotomon.cpp.

                                                                                                 {
    QString md5 = QString::fromUtf8(QCryptographicHash::hash(password.toUtf8(), QCryptographicHash::Md5).toHex());
    QList<Dbt::Users> list;
    MSqlQuery q(m_db);
    q.prepare(R"X(
        select "user", login, name, language
            from users
            where password = :password
              and login = :login
              and is_active
              and not is_deleted
            ;
        )X");
    q.bindValue(":login", login);
    q.bindValue(":password", md5);
    q.exec();
    while (q.next()) {
        int i=0;
        Dbt::Users x;

begin()

void DatabasePluginFotomon::begin ( )

virtual

Implementuje Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 58 v souboru database_plugin_fotomon.cpp.

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

categories()

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

virtual

Implementuje Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 274 v souboru database_plugin_fotomon.cpp.

                                                                                                                                        {
    Q_UNUSED(category);
    if (parent_type == 1) { 
        return QString();
        }
 
    if (parent_type == 2) {
        return QString(R"'({"type":%1})'")
            .arg(type.toInt())
            ;
        }
 
    if (parent_type == 3) {
        return QString(R"'({"type":%1,"system":%2})'")
            .arg(type.toInt())
            .arg(system.toInt())
            ;

categoriesOverview()

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

virtual

Implementuje Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 1062 v souboru database_plugin_fotomon.cpp.

                                                       :id;)'");
    q.bindValue(":id", id.id);
    q.exec();
}
 

categoriesToRoot()

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

virtual

Implementuje Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 267 v souboru database_plugin_fotomon.cpp.

                          {
        return QString(R"'({"type":%1,"system":%2,"category":%3})'")

categoryKey()

QString DatabasePluginFotomon::categoryKey ( const QVariant & type, const QVariant & system, const QVariant & category, int parent_type )

staticprivate

Definice je uvedena na řádku 203 v souboru database_plugin_fotomon.cpp.

                 :lang", userLang());   
    q.exec();
 
    // Vybere všechny kombinace záznamů typ-system
    q.prepare("insert into timesheet_categories (type, system, category, description, parent_type) "
            " select distinct on (tt.type, s.system) tt.type, s.system, null, s.description, 2 "
            " from tickets_categories_types_systems tt, systems s "
            " where s.show_on_panel and s.show_on_web "
            " and s.system in (select system from users_systems where \"user\" = :user); "
            );
    q.bindValue(":user", userId());
    q.exec();
 
    // Vybere všechny kombinace záznamů typ-system-kategorie, kde EXISTUJE záznam typ-system
    q.prepare("insert into timesheet_categories (type, system, category, description, parent_type) "
            " select tt.type, s.system, tc.category, tc.formal_description->>:lang, 3 "
            " from tickets_categories_types_systems tt, systems s, tickets_categories tc "
            " where tt.system = s.system "
            " and tc.category = tt.category "
            " and s.show_on_panel and s.show_on_web "
            " and s.system in (select system from users_systems where \"user\" = :user); "
            );
    q.bindValue(":lang", userLang());
    q.bindValue(":user", userId());
    q.exec();
 
    // Vybere všechny kombinace záznamů typ-system-kategorie, kde NEEXISTUJE záznam typ-system
    q.prepare("insert into timesheet_categories (type, system, category, description, parent_type) "
            " select tt.type, s.system, tc.category, tc.formal_description->>:lang, 4 "
            " from systems s, tickets_types tt, tickets_categories tc "
            " where s.show_on_panel and s.show_on_web "

changePassword()

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

virtual

Implementuje Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 83 v souboru database_plugin_fotomon.cpp.

                                                                                                                       {
    Q_UNUSED(login);
    Q_UNUSED(oldpassword);
    Q_UNUSED(newpassword);
}

clientSettings()

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

virtual

Implementuje Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 1039 v souboru database_plugin_fotomon.cpp.

                     :name", data.name + suffix);
        q.bindValue(":type", data.type);
        q.bindValue(":size", info.size());
        q.exec();
 
        q.prepare(R"'(
            insert into tickets_files (ticket, file) select :ticket, currval('files_file_seq');
            )'");
        q.bindValue(":ticket", data.ticket);
        q.exec();
 
        QVariant rc = currval("files_file_seq");
        PDEBUG << "insert files" << rc.toInt() << data.ticket;
        return rc;
        }
 
    Q_UNREACHABLE();
    return QVariant();
}
 
 

close()

bool DatabasePluginFotomon::close ( )

virtual

Implementuje Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 52 v souboru database_plugin_fotomon.cpp.

                                  {
    m_db.close();
    return true;
}

commit()

void DatabasePluginFotomon::commit ( )

virtual

Implementuje Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 64 v souboru database_plugin_fotomon.cpp.

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

createTemporaryTableCategories()

void DatabasePluginFotomon::createTemporaryTableCategories ( )

private

Definice je uvedena na řádku 148 v souboru database_plugin_fotomon.cpp.

                       :ticket1 <= 0 or :ticket2 = t.ticket)
                  and (ts.closed is null or not ts.closed)
            ),
        users_systems as (
            select us.system 
                from users_systems us, users u, systems s
                where u."user" = :user 
                  and u."user" = us."user"
                  and us.system = s.system
                  and s.show_on_web and s.show_on_panel
                  and u.is_active and not u.is_deleted
            )
        insert into temporary_tickets (ticket, type, system, category, date, "user", description)
        select t.ticket, t.type, t.system, t.category, t.date, t."user", 
            case when description = '' then formal_description->0->'description'->>:lang else description end as description
        from tickets t, users u
        where u."user" = t."user"
          and t.ticket in (select ticket from active_tickets)
          and t.system in (select system from users_systems)
              and (:ticket3 <= 0 or :ticket4 = t.ticket)
        )'");
    q.bindValue(":user", userId());
    q.bindValue(":lang", userLang());
    q.bindValue(":ticket1", ticket);
    q.bindValue(":ticket2", ticket);
    q.bindValue(":ticket3", ticket);
    q.bindValue(":ticket4", ticket);
    q.exec();
}
 
 
void DatabasePluginFotomon::createTemporaryTableCategories() {
    MSqlQuery q(m_db);
 
    q.exec("create temporary table timesheet_categories "
            "(type int, system int, category int, description text, parent_type int)"
            ";");
 
    // Vybere všechny typy knih

createTemporaryTableTickets()

void DatabasePluginFotomon::createTemporaryTableTickets ( int ticket, bool all )

private

Definice je uvedena na řádku 130 v souboru database_plugin_fotomon.cpp.

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

currval()

QVariant DatabasePluginFotomon::currval ( const QString & sequence )

private

Definice je uvedena na řádku 70 v souboru database_plugin_fotomon.cpp.

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

fileContent()

QByteArray DatabasePluginFotomon::fileContent ( const QString & filename )

staticprivate

Definice je uvedena na řádku 786 v souboru database_plugin_fotomon.cpp.

                              :user
              and :id = tt.id
            ;
        )'");
    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();

open()

bool DatabasePluginFotomon::open ( )

virtual

Implementuje Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 33 v souboru database_plugin_fotomon.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 Fotomon";
        PDEBUG << m_db.lastError().text();
        return false;
        }
 
    return true;
}

overview() [1/2]

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

virtual

Implementuje Db::Plugins::DatabasePlugin.

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

overview() [2/2]

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

virtual

Implementuje Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 1076 v souboru database_plugin_fotomon.cpp.

                     {
        int i=0;

overviewList()

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

virtual

Implementuje Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 1083 v souboru database_plugin_fotomon.cpp.

parentCategoryKey()

QString DatabasePluginFotomon::parentCategoryKey ( const QVariant & type, const QVariant & system, const QVariant & category, int parent_type )

staticprivate

Definice je uvedena na řádku 237 v souboru database_plugin_fotomon.cpp.

                 :user", userId());
    q.bindValue(":lang", userLang());
    q.exec();
 
}
 
 
QString DatabasePluginFotomon::categoryKey(const QVariant& type, const QVariant& system, const QVariant& category, int parent_type) {
    if (parent_type == 1) { 
        return QString(R"'({"type":%1})'")
            .arg(type.toInt())
            ;
        }
 
    if (parent_type == 2) {
        return QString(R"'({"type":%1,"system":%2})'")
            .arg(type.toInt())
            .arg(system.toInt())
            ;
        }
 
    if (parent_type == 3) {
        return QString(R"'({"type":%1,"system":%2,"category":%3})'")
            .arg(type.toInt())

remove() [1/4]

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

virtual

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

Definice je uvedena na řádku 925 v souboru database_plugin_fotomon.cpp.

remove() [2/4]

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

virtual

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

Definice je uvedena na řádku 570 v souboru database_plugin_fotomon.cpp.

                     :system", system);
        q.bindValue(":category", category);
        q.bindValue(":date", data.date);
        q.bindValue(":price", data.price);
        q.bindValue(":description", data.description);
        q.bindValue(":user", data.user);

remove() [3/4]

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

virtual

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

Definice je uvedena na řádku 778 v souboru database_plugin_fotomon.cpp.

                                                                         {
    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

remove() [4/4]

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

virtual

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

Definice je uvedena na řádku 1022 v souboru database_plugin_fotomon.cpp.

                     :date", data.date);
        q.bindValue(":name", data.name + suffix);
        q.bindValue(":type", data.type);
        q.bindValue(":size", info.size());
        q.bindValue(":fileid", data.id);
        q.bindValue(":ticket", data.ticket);

rfids()

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

virtual

Implementuje Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 1088 v souboru database_plugin_fotomon.cpp.

rfidsById()

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

virtual

Implementuje Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 1093 v souboru database_plugin_fotomon.cpp.

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

runningTimesheets()

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

virtual

Implementuje Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 715 v souboru database_plugin_fotomon.cpp.

                         :status
                where note = :id
            )'").arg((description2=="") ? "null" : QString("'%1'").arg(QString::fromUtf8(description2)) ) );
        q.bindValue(":id", data.id);

save() [1/7]

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

virtual

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

Definice je uvedena na řádku 861 v souboru database_plugin_fotomon.cpp.

                                {
        q.prepare(R"'(
            insert into ticket_timesheets (ticket, "user", date_from, date_to)
                values (:ticket, :user, :date_from, :date_to)
            )'");
        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 currval("ticket_timesheets_id_seq");
        }
 
    Q_UNREACHABLE();
    return QVariant();
}
 
 
void DatabasePluginFotomon::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();
}
 
 
QByteArray DatabasePluginFotomon::fileContent(const QString& filename) {
    QByteArray content;
    QDir dir(MSETTINGS->dbFilesDirectory());
    QString fullfilename = dir.absoluteFilePath(filename);
    QFile file(fullfilename);
    if (file.open(QIODevice::ReadOnly)) {
        content = file.readAll();
        file.close();
        }
    return content;
}
 
 
QList<Dbt::TicketFiles> DatabasePluginFotomon::ticketFiles(int ticket, bool all) {
    createTemporaryTableTickets(ticket, all);
    QList<Dbt::TicketFiles> list;
    MSqlQuery q(m_db);
 
    q.prepare(R"'(
        select f.file, f.upload_date, tf.ticket, f.origname, f.filetype, f.filename
            from temporary_tickets t, tickets_files tf, files f
            where t.ticket = tf.ticket
              and tf.file = f.file;
            ;
        )'");
    q.exec();
    while (q.next()) {
        int i=0;
        Dbt::TicketFiles x;
        x.id        = q.value(i++).toInt();

save() [2/7]

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

virtual

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

Definice je uvedena na řádku 493 v souboru database_plugin_fotomon.cpp.

                                                                                   {
    return ticketsVw(-1, all);
}
 
 
QList<Dbt::TicketsVw> DatabasePluginFotomon::ticketsVw(bool all) {
    Q_UNUSED(all);
    return ticketsVw(-1, all);
}
 
 
QList<Dbt::TicketsVw> DatabasePluginFotomon::ticketsVw(int ticket, bool all) {
    createTemporaryTableTickets(ticket, all);
    QList<Dbt::Tickets> list1;
    QList<Dbt::TicketsVw> list;
    MSqlQuery q(m_db);
 
    q.prepare(R"X(select ticket, type, system, category, date, description, "user" from temporary_tickets;)X");
    q.exec();
    while (q.next()) {
        Dbt::TicketsVw x;
        int i=0;
        x.ticket = q.value(i++);
        QVariant type = q.value(i++);
        QVariant system = q.value(i++);
        QVariant category = q.value(i++);
        x.category = categoryKey(type, system, category, 3);
        x.date = q.value(i++).toDateTime();
        x.description = q.value(i++).toString();
        x.user = q.value(i++).toInt();
        list1 << x;
        }
    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;
}
 
 

save() [3/7]

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

virtual

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

Definice je uvedena na řádku 623 v souboru database_plugin_fotomon.cpp.

                                                       {
    MSqlQuery q(m_db);
    q.prepare(R"'(delete from tickets where ticket = :id;)'");
    q.bindValue(":id", id.ticket);
    q.exec();
}
 
 
QList<Dbt::TicketStatus> DatabasePluginFotomon::ticketStatus(int ticket, bool all) {
    createTemporaryTableTickets(ticket, all);
    QList<Dbt::TicketStatus> list;
    MSqlQuery q(m_db);
 
    q.prepare(R"'(
        select tn.note, tn.ticket, t."user", tn.date, tn.status,
                case when tn.description != '' then tn.description else tn.formal_description->0->'description'->>'cs' end as description, 
                tn.formal_description,
                ts.description, ts.color
            from tickets_notes tn, temporary_tickets t, tickets_status ts
            where tn.ticket = t.ticket
              and ts.status = tn.status
              and (:ticket1 <= 0 or :ticket2 = t.ticket)
            ;
        )'");
    q.bindValue(":user", userId());
    q.bindValue(":lang", userLang());   
    q.bindValue(":ticket1", ticket);
    q.bindValue(":ticket2", ticket);
    q.exec();
    while (q.next()) {
        Dbt::TicketStatus x;
        int i=0;
        x.id            = q.value(i++).toInt();
        x.ticket        = q.value(i++).toInt();

save() [4/7]

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

virtual

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

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

                                {
        q.prepare(R"'(
            update tickets set
                type = :type,
                system = :system,
                category = :category,
                date = :date,
                price = :price,
                description = :description,
               "user" = :user
                where ticket = :ticket

save() [5/7]

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

virtual

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

Definice je uvedena na řádku 739 v souboru database_plugin_fotomon.cpp.

                     :status", data.status);
        q.exec();
 
        return currval("tickets_notes_note_seq");
        }
 
    Q_UNREACHABLE();
    return QVariant();
}
 
 
QList<Dbt::TicketTimesheets> DatabasePluginFotomon::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
            ;
        )'");
    q.bindValue(":user", userId());
    q.bindValue(":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;
}

save() [6/7]

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

virtual

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

Definice je uvedena na řádku 981 v souboru database_plugin_fotomon.cpp.

                                                               {
    MSqlQuery q(m_db);
 
    bool found = false;
    q.prepare(R"'(select file from tickets_files where file = :file and ticket = :ticket;)'");
    q.bindValue(":id", data.id);
    q.bindValue(":ticket", data.ticket);
    q.exec();
    found = q.next();
 
    // Save file
    QString suffix = suffixFromType(data.type);
    QString webalizedName = QString("ta%1-%2%3")
        .arg(data.ticket.toInt())
        .arg(QUuid::createUuid().toString().remove(QChar('{')).remove(QChar('}')))
        .arg(suffix)
        ;
    QDir dir(MSETTINGS->dbFilesDirectory());
    QString filename = dir.absoluteFilePath(webalizedName);
    QFile file(filename);
    if (file.open(QIODevice::WriteOnly)) {
        file.write(data.content);   
        file.close();
        }
    QFileInfo info(filename);
    PDEBUG << webalizedName << filename << info.fileName();
 
    if (found) {
        PDEBUG << "update files" << data.id << data.ticket;
        q.prepare(R"'(
            update files set 
                filename = :filename,
                upload_date = :date,
                origname = :name,
                filetype = :type,
                filesize = :size
                where file = :fileid

save() [7/7]

template<typename T>

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

inline

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

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

setDatabaseName()

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

inlinevirtual

Implementuje Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 32 v souboru database_plugin_fotomon.h.

{ m_databasename = x; }

setHostname()

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

inlinevirtual

Implementuje Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 33 v souboru database_plugin_fotomon.h.

{ m_hostname = x; }

setPassword()

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

inlinevirtual

Implementuje Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 36 v souboru database_plugin_fotomon.h.

{ m_password = x; }

setPort()

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

inlinevirtual

Implementuje Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 34 v souboru database_plugin_fotomon.h.

{ m_port = x; }

setUserName()

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

inlinevirtual

Implementuje Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 35 v souboru database_plugin_fotomon.h.

{ m_username = x; }

siblingcategories()

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

virtual

Implementuje Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 308 v souboru database_plugin_fotomon.cpp.

                                                                              {

startTimesheet()

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

virtual

Implementuje Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 721 v souboru database_plugin_fotomon.cpp.

                     :date", data.date);
        q.bindValue(":description", data.description);
        q.bindValue(":status", data.status);
        q.exec();

statuses() [1/2]

QList< Dbt::Statuses > DatabasePluginFotomon::statuses ( const QString & category, const QString & prevstatus )

virtual

Implementuje Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 371 v souboru database_plugin_fotomon.cpp.

                     {
        Dbt::StatusOrder x;
        QVariant type = q.value(0);
        QVariant system = q.value(1);

statuses() [2/2]

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

virtual

Implementuje Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 347 v souboru database_plugin_fotomon.cpp.

                                                                               {
    Q_UNUSED(id);
    QList<Dbt::Categories> list;
    return list;
}
 
 
QList<Dbt::StatusOrder> DatabasePluginFotomon::statusOrder(const QString& id) {
    Q_UNUSED(id);
    createTemporaryTableCategories();
 
    QList<Dbt::StatusOrder> list;
    MSqlQuery q(m_db);
 
    q.exec("select c.type, c.system, c.category, c.description, c.parent_type, "
        " s.status_from, s.status_to "

statusOrder()

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

virtual

Implementuje Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 315 v souboru database_plugin_fotomon.cpp.

                                                                        {
    Q_UNUSED(id);
    createTemporaryTableCategories();
 
    QList<Dbt::Categories> list;
    MSqlQuery q(m_db);
 
    q.exec("select type, system, category, description, parent_type from timesheet_categories;");
    while (q.next()) {
        Dbt::Categories x;
        QVariant type = q.value(0);
        QVariant system = q.value(1);
        QVariant category = q.value(2);
        QVariant description = q.value(3);
        int parent_type = q.value(4).toInt();
 
        x.category          =       categoryKey(type, system, category, parent_type);
        x.parent_category   = parentCategoryKey(type, system, category, parent_type);
        x.description       = description.toString();
        list << x;
        }
 
    PDEBUG << "pocet kategorii" << list.size();
    return list;
}
 

statusTemplates()

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

virtual

Implementuje Db::Plugins::DatabasePlugin.

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

                                                                    {
    Q_UNUSED(id);
    QList<Dbt::Statuses> list;
    MSqlQuery q(m_db);
 
    q.prepare("select ts.status, ts.formal_description->>:lang, ts.abbreviation, ts.color "
        " from tickets_status ts "
        ";");
    q.bindValue(":lang", userLang());   
    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();
        list << x;
        }
 

stopTimesheet()

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

virtual

Implementuje Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 727 v souboru database_plugin_fotomon.cpp.

                                {
        QByteArray description2 = JSON::json(data.description2);
        if (description2 == "{}") { description2 = ""; }

subcategories()

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

virtual

Implementuje Db::Plugins::DatabasePlugin.

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

                          {
        return QString(R"'({"type":%1,"system":%2})'")
            .arg(type.toInt())
            .arg(system.toInt())
            ;

suffixFromType()

QString DatabasePluginFotomon::suffixFromType ( const QString & type )

staticprivate

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

                          :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);

ticketFiles() [1/3]

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

virtual

Implementuje Db::Plugins::DatabasePlugin.

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

                         :ticket,

ticketFiles() [2/3]

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

virtual

Implementuje Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 823 v souboru database_plugin_fotomon.cpp.

                                                                           {
    Q_UNUSED(ticket);
    return QList<Dbt::TicketTimesheets>();
}
 
 
QList<Dbt::TicketTimesheets>  DatabasePluginFotomon::toggleTimesheet(int ticket) {
    Q_UNUSED(ticket);
    return QList<Dbt::TicketTimesheets>();
}
 
 
QVariant DatabasePluginFotomon::save(const Dbt::TicketTimesheets& data) {
    MSqlQuery q(m_db);
 
    bool found = false;
    if (!data.created) {
        q.prepare(R"'(select 1 from ticket_timesheets where id = :id;)'");
        q.bindValue(":id", data.id);
        q.exec();
        found = q.next();
        }

ticketFiles() [3/3]

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

virtual

Implementuje Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 799 v souboru database_plugin_fotomon.cpp.

                                                                           {
    return ticketTimesheets(-1, all);
}
 
 
QList<Dbt::TicketTimesheets>  DatabasePluginFotomon::runningTimesheets(int ticket) {
    Q_UNUSED(ticket);
    return QList<Dbt::TicketTimesheets>();
}
 
 
QList<Dbt::TicketTimesheets>  DatabasePluginFotomon::startTimesheet(int ticket) {
    Q_UNUSED(ticket);
    return QList<Dbt::TicketTimesheets>();

tickets() [1/3]

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

virtual

Implementuje Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 414 v souboru database_plugin_fotomon.cpp.

                                                                                                     {

tickets() [2/3]

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

virtual

Implementuje Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 443 v souboru database_plugin_fotomon.cpp.

                 :id2", id);
    q.bindValue(":lang", userLang());
    q.exec();

tickets() [3/3]

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

virtual

Implementuje Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 419 v souboru database_plugin_fotomon.cpp.

                                                                       {
    MSqlQuery q(m_db);
    QList<Dbt::StatusTemplates> list;
 
    /* Too large document :-(
    createTemporaryTableCategories();
    q.prepare(R"X(select t.note_template, t.status, c.category, t.code, t.title->>:lang, t.description
        from timesheet_categories c, tickets_notes_templates t
        where c.type = t.type
          and (t.note_template = :id1 or 0 > :id2)
        )X");
    */
 
    q.prepare(R"X(select note_template, status, null, code, title->>:lang, description
        from tickets_notes_templates
        where note_template = :id1 or 0 > :id2;
        )X");
 

ticketStatus() [1/3]

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

virtual

Implementuje Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 610 v souboru database_plugin_fotomon.cpp.

                         { x.id = 0; }
        list << x;
        }
    return list;

ticketStatus() [2/3]

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

virtual

Implementuje Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 616 v souboru database_plugin_fotomon.cpp.

                                                             {
    MSqlQuery q(m_db);
    q.begin();
    int ticket = save(dynamic_cast<const Dbt::Tickets&>(data)).toInt();

ticketStatus() [3/3]

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

virtual

Implementuje Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 578 v souboru database_plugin_fotomon.cpp.

                                {
        q.prepare(R"'(
            insert into tickets (type, system, category, date, price, description, "user")
                        values (:type, :system, :category, :date, :price, :description, :user);
            )'");
        q.bindValue(":type", type);
        q.bindValue(":system", system);
        q.bindValue(":category", 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()) {

ticketsVw() [1/3]

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

virtual

Implementuje Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 453 v souboru database_plugin_fotomon.cpp.

ticketsVw() [2/3]

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

virtual

Implementuje Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 448 v souboru database_plugin_fotomon.cpp.

ticketsVw() [3/3]

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

virtual

Implementuje Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 459 v souboru database_plugin_fotomon.cpp.

                                                         {
    return tickets(-1, all);
}
 
 
QList<Dbt::Tickets> DatabasePluginFotomon::tickets(int ticket, bool all) {
    PDEBUG;
    createTemporaryTableTickets(ticket, all);
    QList<Dbt::Tickets> list;
    MSqlQuery q(m_db);
 
    q.prepare(R"X(select ticket, type, system, 1, date, description from temporary_tickets;)X");
    q.exec();
    while (q.next()) {
        Dbt::Tickets x;
        int i=0;
        x.ticket = q.value(i++);
        QVariant type = q.value(i++);
        QVariant system = q.value(i++);
        QVariant category = q.value(i++);
        x.category = categoryKey(type, system, category, 3);
        x.date = q.value(i++).toDateTime();
        x.description = q.value(i++).toString();
        list << x;
        }
    return list;
}
 
 

ticketTimesheets() [1/3]

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

virtual

Implementuje Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 710 v souboru database_plugin_fotomon.cpp.

                         :ticket,
               "user" = :user,
                date = :date,

ticketTimesheets() [2/3]

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

virtual

Implementuje Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 689 v souboru database_plugin_fotomon.cpp.

                                                                {
    MSqlQuery q(m_db);
 
    bool found = false;
    if (!data.created) {
        q.prepare(R"'(select 1 from tickets_notes where note = :id;)'");
        q.bindValue(":id", data.id);
        q.exec();
        found = q.next();
        }
 
    if (!data.created && found) {
        QByteArray description2 = JSON::json(data.description2);
        if (description2 == "{}") { description2 = ""; }

ticketTimesheets() [3/3]

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

virtual

Implementuje Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 667 v souboru database_plugin_fotomon.cpp.

                                                                   {
    Q_UNUSED(all);
    return ticketStatus(-1, all);
}
 
 

ticketValues() [1/3]

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

virtual

Implementuje Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 976 v souboru database_plugin_fotomon.cpp.

                             { return ".png"; }
    if (type == "image/jpeg") { return ".jpeg"; }
    if (type == "image/gif") { return ".gif"; }

ticketValues() [2/3]

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

virtual

Implementuje Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 954 v souboru database_plugin_fotomon.cpp.

                                                                 {
    return ticketFiles(-1, all);
}
 

ticketValues() [3/3]

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

virtual

Implementuje Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 933 v souboru database_plugin_fotomon.cpp.

                                                               {
    QList<Dbt::TicketFiles> list;
    MSqlQuery q(m_db);
 
    q.prepare(R"'(
        select f.file, f.upload_date, tf.ticket, f.origname, f.filetype, f.filename
            from tickets_files tf, files f, users u, tickets t, users_categories uc
            where f.file = :id
              and tf.file = f.file
              and t.ticket = tf.ticket
              and t.category = uc.category
              and t."user" = :user
            ;
        )'");
    q.bindValue(":id", id);
    q.bindValue(":user", userId());

toggleTimesheet()

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

virtual

Implementuje Db::Plugins::DatabasePlugin.

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

                        :ticket, :user, :date, :description, :status, %1)
            )'").arg((description2=="") ? "null" : QString("'%1'").arg(QString::fromUtf8(description2)) ) );
        q.bindValue(":user", data.user);
        q.bindValue(":ticket", data.ticket);

users()

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

virtual

Implementuje Db::Plugins::DatabasePlugin.

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

                                                   {
    Q_UNUSED(id);
    QList<Dbt::Users> list;
    MSqlQuery q(m_db);
    q.prepare(R"X(select "user", login, name, language from users where is_active and not is_deleted;)X");
    q.exec();
    while (q.next()) {
        int i=0;
        Dbt::Users x;

usersCategories()

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

virtual

Implementuje Db::Plugins::DatabasePlugin.

Definice je uvedena na řádku 1030 v souboru database_plugin_fotomon.cpp.

                {
        q.prepare(R"'(
            insert into files (filename, upload_date, origname, filetype, filesize)
                 values (:filename, :date, :name, :type, :sizeticket);
            )'");

Dokumentace datových členů

m_databasename

QString Db::Plugins::DatabasePluginFotomon::m_databasename

private

Definice je uvedena na řádku 115 v souboru database_plugin_fotomon.h.

m_hostname

QString Db::Plugins::DatabasePluginFotomon::m_hostname

private

Definice je uvedena na řádku 116 v souboru database_plugin_fotomon.h.

m_password

QString Db::Plugins::DatabasePluginFotomon::m_password

private

Definice je uvedena na řádku 118 v souboru database_plugin_fotomon.h.

m_port

int Db::Plugins::DatabasePluginFotomon::m_port

private

Definice je uvedena na řádku 119 v souboru database_plugin_fotomon.h.

m_temporaryTableTicketsCreated

bool Db::Plugins::DatabasePluginFotomon::m_temporaryTableTicketsCreated

private

Definice je uvedena na řádku 114 v souboru database_plugin_fotomon.h.

m_username

QString Db::Plugins::DatabasePluginFotomon::m_username

private

Definice je uvedena na řádku 117 v souboru database_plugin_fotomon.h.

---

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

• database/fotomon/database_plugin_fotomon.h
• database/fotomon/database_plugin_fotomon.cpp