2 Bacula® - The Network Backup Solution
4 Copyright (C) 2007-2009 Free Software Foundation Europe e.V.
6 The main author of Bacula is Kern Sibbald, with contributions from
7 many others, a complete list can be found in the file AUTHORS.
8 This program is Free Software; you can redistribute it and/or
9 modify it under the terms of version two of the GNU General Public
10 License as published by the Free Software Foundation and included
13 This program is distributed in the hope that it will be useful, but
14 WITHOUT ANY WARRANTY; without even the implied warranty of
15 MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
16 General Public License for more details.
18 You should have received a copy of the GNU General Public License
19 along with this program; if not, write to the Free Software
20 Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA
23 Bacula® is a registered trademark of Kern Sibbald.
24 The licensor of Bacula is the Free Software Foundation Europe
25 (FSFE), Fiduciary Program, Sumatrastrasse 25, 8006 Zürich,
26 Switzerland, email:ftf@fsfeurope.org.
34 * Dirk Bartley, March 2007
39 #include <QAbstractEventDispatcher>
41 #include "clients/clients.h"
43 #include "status/clientstat.h"
44 #include "util/fmtwidgetitem.h"
49 m_name = tr("Clients");
51 QTreeWidgetItem* thisitem = mainWin->getFromHash(this);
52 thisitem->setIcon(0,QIcon(QString::fromUtf8(":images/network-server.png")));
54 /* tableWidget, Storage Tree Tree Widget inherited from ui_client.h */
56 m_checkcurwidget = true;
58 m_firstpopulation = true;
59 /* add context sensitive menu items specific to this classto the page
60 * selector tree. m_contextActions is QList of QActions */
61 m_contextActions.append(actionRefreshClients);
71 * The main meat of the class!! The function that querries the director and
72 * creates the widgets with appropriate values.
74 void Clients::populateTable()
78 Freeze frz(*tableWidget); /* disable updating*/
80 QStringList headerlist = (QStringList() << tr("Client Name") << tr("File Retention")
81 << tr("Job Retention") << tr("AutoPrune") << tr("ClientId") << tr("Uname") );
83 int sortcol = headerlist.indexOf(tr("Client Name"));
84 Qt::SortOrder sortord = Qt::AscendingOrder;
85 if (tableWidget->rowCount()) {
86 sortcol = tableWidget->horizontalHeader()->sortIndicatorSection();
87 sortord = tableWidget->horizontalHeader()->sortIndicatorOrder();
90 m_checkcurwidget = false;
92 m_checkcurwidget = true;
94 tableWidget->setColumnCount(headerlist.count());
95 tableWidget->setHorizontalHeaderLabels(headerlist);
96 tableWidget->horizontalHeader()->setHighlightSections(false);
97 tableWidget->setRowCount(m_console->client_list.count());
98 tableWidget->verticalHeader()->hide();
99 tableWidget->setSelectionBehavior(QAbstractItemView::SelectRows);
100 tableWidget->setSelectionMode(QAbstractItemView::SingleSelection);
101 tableWidget->setSortingEnabled(false); /* rows move on insert if sorting enabled */
103 QString client_comsep("");
104 foreach (QString clientName, m_console->client_list){
106 client_comsep += "'" + clientName + "'";
110 client_comsep += ",'" + clientName + "'";
113 if (client_comsep != "") {
115 query += "SELECT Name, FileRetention, JobRetention, AutoPrune, ClientId, Uname"
117 " WHERE ClientId IN (SELECT MAX(ClientId) FROM Client WHERE";
118 query += " Name IN (" + client_comsep + ")";
119 query += " GROUP BY Name) ORDER BY Name";
122 if (mainWin->m_sqlDebug)
123 Pmsg1(000, "Clients query cmd : %s\n",query.toUtf8().data());
124 if (m_console->sql_cmd(query, results)) {
127 /* Iterate through the record returned from the query */
128 foreach (QString resultline, results) {
129 QStringList fieldlist = resultline.split("\t");
131 if (m_firstpopulation) {
132 m_firstpopulation = false;
133 settingsOpenStatus(fieldlist[0]);
136 TableItemFormatter item(*tableWidget, row);
138 /* Iterate through fields in the record */
139 QStringListIterator fld(fieldlist);
143 item.setTextFld(col++, fld.next());
146 item.setDurationFld(col++, fld.next());
149 item.setDurationFld(col++, fld.next());
152 item.setBoolFld(col++, fld.next());
155 item.setNumericFld(col++, fld.next());
158 item.setTextFld(col++, fld.next());
164 /* set default sorting */
165 tableWidget->sortByColumn(sortcol, sortord);
166 tableWidget->setSortingEnabled(true);
168 /* Resize rows and columns */
169 tableWidget->resizeColumnsToContents();
170 tableWidget->resizeRowsToContents();
173 int rcnt = tableWidget->rowCount();
174 int ccnt = tableWidget->columnCount();
175 for(int r=0; r < rcnt; r++) {
176 for(int c=0; c < ccnt; c++) {
177 QTableWidgetItem* item = tableWidget->item(r, c);
179 item->setFlags(Qt::ItemFlags(item->flags() & (~Qt::ItemIsEditable)));
186 * When the treeWidgetItem in the page selector tree is singleclicked, Make sure
187 * The tree has been populated.
189 void Clients::PgSeltreeWidgetClicked()
197 * Added to set the context menu policy based on currently active treeWidgetItem
198 * signaled by currentItemChanged
200 void Clients::tableItemChanged(QTableWidgetItem *currentwidgetitem, QTableWidgetItem *previouswidgetitem )
202 /* m_checkcurwidget checks to see if this is during a refresh, which will segfault */
203 if (m_checkcurwidget) {
204 int currentRow = currentwidgetitem->row();
205 QTableWidgetItem *currentrowzeroitem = tableWidget->item(currentRow, 0);
206 m_currentlyselected = currentrowzeroitem->text();
208 /* The Previous item */
209 if (previouswidgetitem) { /* avoid a segfault if first time */
210 tableWidget->removeAction(actionListJobsofClient);
211 tableWidget->removeAction(actionStatusClientInConsole);
212 tableWidget->removeAction(actionStatusClientWindow);
213 tableWidget->removeAction(actionPurgeJobs);
214 tableWidget->removeAction(actionPrune);
217 if (m_currentlyselected.length() != 0) {
218 /* set a hold variable to the client name in case the context sensitive
220 tableWidget->addAction(actionListJobsofClient);
221 tableWidget->addAction(actionStatusClientInConsole);
222 tableWidget->addAction(actionStatusClientWindow);
223 tableWidget->addAction(actionPurgeJobs);
224 tableWidget->addAction(actionPrune);
230 * Setup a context menu
231 * Made separate from populate so that it would not create context menu over and
232 * over as the tree is repopulated.
234 void Clients::createContextMenu()
236 tableWidget->setContextMenuPolicy(Qt::ActionsContextMenu);
237 tableWidget->addAction(actionRefreshClients);
238 /* for the tableItemChanged to maintain m_currentJob */
239 connect(tableWidget, SIGNAL(
240 currentItemChanged(QTableWidgetItem *, QTableWidgetItem *)),
241 this, SLOT(tableItemChanged(QTableWidgetItem *, QTableWidgetItem *)));
243 /* connect to the action specific to this pages class */
244 connect(actionRefreshClients, SIGNAL(triggered()), this,
245 SLOT(populateTable()));
246 connect(actionListJobsofClient, SIGNAL(triggered()), this,
248 connect(actionStatusClientInConsole, SIGNAL(triggered()), this,
249 SLOT(consoleStatusClient()));
250 connect(actionStatusClientWindow, SIGNAL(triggered()), this,
251 SLOT(statusClientWindow()));
252 connect(actionPurgeJobs, SIGNAL(triggered()), this,
253 SLOT(consolePurgeJobs()));
254 connect(actionPrune, SIGNAL(triggered()), this,
259 * Function responding to actionListJobsofClient which calls mainwin function
260 * to create a window of a list of jobs of this client.
262 void Clients::showJobs()
264 QTreeWidgetItem *parentItem = mainWin->getFromHash(this);
265 mainWin->createPageJobList("", m_currentlyselected, "", "", parentItem);
269 * Function responding to actionListJobsofClient which calls mainwin function
270 * to create a window of a list of jobs of this client.
272 void Clients::consoleStatusClient()
274 QString cmd("status client=");
275 cmd += m_currentlyselected;
280 * Virtual function which is called when this page is visible on the stack
282 void Clients::currentStackItem()
286 /* Create the context menu for the client table */
291 * Function responding to actionPurgeJobs
293 void Clients::consolePurgeJobs()
295 if (QMessageBox::warning(this, "Bat",
296 tr("Are you sure you want to purge all jobs of client \"%1\" ?\n"
297 "The Purge command will delete associated Catalog database records from Jobs and"
298 " Volumes without considering the retention period. Purge works only on the"
299 " Catalog database and does not affect data written to Volumes. This command can"
300 " be dangerous because you can delete catalog records associated with current"
301 " backups of files, and we recommend that you do not use it unless you know what"
302 " you are doing.\n\n"
303 " Is there any way I can get you to click Cancel here? You really don't want to do"
305 "Press OK to proceed with the purge operation?").arg(m_currentlyselected),
306 QMessageBox::Ok | QMessageBox::Cancel,
308 == QMessageBox::Cancel) { return; }
310 QString cmd("purge jobs client=");
311 cmd += m_currentlyselected;
316 * Function responding to actionPrune
318 void Clients::prune()
320 new prunePage("", m_currentlyselected);
324 * Function responding to action to create new client status window
326 void Clients::statusClientWindow()
328 /* if one exists, then just set it current */
330 foreach(Pages *page, mainWin->m_pagehash) {
331 if (mainWin->currentConsole() == page->console()) {
332 if (page->name() == tr("Client Status %1").arg(m_currentlyselected)) {
339 QTreeWidgetItem *parentItem = mainWin->getFromHash(this);
340 new ClientStat(m_currentlyselected, parentItem);
345 * If first time, then check to see if there were status pages open the last time closed
348 void Clients::settingsOpenStatus(QString &client)
350 QSettings settings(m_console->m_dir->name(), "bat");
352 settings.beginGroup("OpenOnExit");
353 QString toRead = "ClientStatus_" + client;
354 if (settings.value(toRead) == 1) {
355 Pmsg1(000, "Do open Client Status window for : %s\n", client.toUtf8().data());
356 new ClientStat(client, mainWin->getFromHash(this));
358 mainWin->getFromHash(this)->setExpanded(true);
360 Pmsg1(000, "Do NOT open Client Status window for : %s\n", client.toUtf8().data());