1 #ifndef _BIBLIOTEQ_MISC_FUNCTIONS_H_
2 #define _BIBLIOTEQ_MISC_FUNCTIONS_H_
4 #include <QGraphicsItem>
5 #include <QSqlDatabase>
8 #include <QTableWidget>
16 static const int CREATE_USER = 100;
17 static const int DELETE_USER = 200;
18 static const int UPDATE_USER = 300;
19 static QImage getImage(
const QString &,
22 const QSqlDatabase &);
23 static QList<QPair<QString, QString> > getLocations(
const QSqlDatabase &,
25 static QList<int> selectedRows(QTableWidget *);
26 static QMap<QString, qint64> getItemsReservedCounts(
const QSqlDatabase &,
29 static QString getAbstractInfo(
const QString &,
31 const QSqlDatabase &);
32 static QString getAvailability(
const QString &,
36 static QString getColumnString(
const QTableWidget *,
39 static QString getColumnString(
const QTableWidget *,
const int,
const int);
40 static QString getMemberName(
const QSqlDatabase &,
43 static QString getOID(
const QString &,
47 static QString getRoles(
const QSqlDatabase &,
const QString &, QString &);
48 static QString getTotalReserved(
const QSqlDatabase &,
51 static QString imageFormatGuess(
const QByteArray &bytes);
52 static QStringList getBookBindingTypes(
const QSqlDatabase &, QString &);
53 static QStringList getCDFormats(
const QSqlDatabase &, QString &);
54 static QStringList getDVDAspectRatios(
const QSqlDatabase &, QString &);
55 static QStringList getDVDRatings(
const QSqlDatabase &, QString &);
56 static QStringList getDVDRegions(
const QSqlDatabase &, QString &);
57 static QStringList getGreyLiteratureTypes(
const QSqlDatabase &db,
59 static QStringList getLanguages(
const QSqlDatabase &, QString &);
60 static QStringList getLocations(
const QSqlDatabase &,
63 static QStringList getMinimumDays(
const QSqlDatabase &, QString &);
64 static QStringList getMonetaryUnits(
const QSqlDatabase &, QString &);
65 static QStringList getReservedItems(
const QString &,
68 static QStringList getVideoGamePlatforms(
const QSqlDatabase &, QString &);
69 static QStringList getVideoGameRatings(
const QSqlDatabase &, QString &);
70 static bool dnt(
const QSqlDatabase &,
const QString &, QString &);
71 static bool getMemberMatch(
const QString &,
75 static bool hasMemberExpired(
const QSqlDatabase &,
78 static bool hasUnaccentExtension(
const QSqlDatabase &);
79 static bool isBookRead(
const QSqlDatabase &,
81 static bool isCheckedOut(
const QSqlDatabase &,
85 static bool isCopyAvailable(
const QSqlDatabase &,
90 static bool isCopyCheckedOut(
const QSqlDatabase &,
95 static bool isGnome(
void);
96 static bool isRequested(
const QSqlDatabase &,
100 static bool userExists(
const QString &,
const QSqlDatabase &, QString &);
101 static int getColumnNumber(
const QTableWidget *,
const QString &);
102 static int getMaxCopyNumber(
const QSqlDatabase &,
106 static int getMinimumDays(
const QSqlDatabase &,
const QString &, QString &);
107 static int maximumReserved(
const QSqlDatabase &,
110 static int sqliteQuerySize(
const QString &,
111 #
if (QT_VERSION < QT_VERSION_CHECK(6, 0, 0))
112 const QMap<QString, QVariant> &,
114 const QVariantList &,
116 const QSqlDatabase &,
120 static int sqliteQuerySize(
const QString &,
121 const QSqlDatabase &,
125 static qint64 bookAccessionNumber(
const QSqlDatabase &);
126 static qint64 getSqliteUniqueId(
const QSqlDatabase &, QString &);
127 static void DBAccount(
const QString &,
128 const QSqlDatabase &,
131 const QString & =
"");
132 static void center(QWidget *, QMainWindow *);
133 static void createInitialCopies(QString
const &,
135 const QSqlDatabase &,
138 static void exportPhotographs(
const QSqlDatabase &,
141 const QList<QGraphicsItem *> &,
143 static void exportPhotographs(
const QSqlDatabase &,
149 static void grantPrivs(
const QString &,
151 const QSqlDatabase &,
153 static void hideAdminFields(QMainWindow *,
const QString &);
154 static void highlightWidget(QWidget *,
const QColor &);
155 static void revokeAll(
const QString &,
const QSqlDatabase &, QString &);
156 static void savePassword(
const QString &,
157 const QSqlDatabase &,
160 static void saveQuantity(
const QSqlDatabase &,
165 static void setBookRead(
const QSqlDatabase &,
const bool,
const quint64);
166 static void setRole(
const QSqlDatabase &, QString &,
const QString &);
167 static void updateColumn(QTableWidget *,
171 static void updateColumnColor(QTableWidget *,