2 Bacula(R) - The Network Backup Solution
4 Copyright (C) 2000-2015 Kern Sibbald
5 Copyright (C) 2007-2009 Free Software Foundation Europe e.V.
7 The original author of Bacula is Kern Sibbald, with contributions
8 from many others, a complete list can be found in the file AUTHORS.
10 You may use this file and others of this release according to the
11 license defined in the LICENSE file, which includes the Affero General
12 Public License, v3.0 ("AGPLv3") and some additional permissions and
13 terms pursuant to its AGPLv3 Section 7.
15 This notice must be preserved when any source code is
16 conveyed and/or propagated.
18 Bacula(R) is a registered trademark of Kern Sibbald.
24 * Dirk Bartley, March 2007
29 #include <QAbstractEventDispatcher>
31 #include "clients/clients.h"
33 #include "status/clientstat.h"
34 #include "util/fmtwidgetitem.h"
36 Clients::Clients() : Pages()
39 m_name = tr("Clients");
41 QTreeWidgetItem* thisitem = mainWin->getFromHash(this);
42 thisitem->setIcon(0,QIcon(QString::fromUtf8(":images/network-server.png")));
44 /* tableWidget, Storage Tree Tree Widget inherited from ui_client.h */
46 m_checkcurwidget = true;
48 m_firstpopulation = true;
49 /* add context sensitive menu items specific to this classto the page
50 * selector tree. m_contextActions is QList of QActions */
51 m_contextActions.append(actionRefreshClients);
60 * The main meat of the class!! The function that queries the director and
61 * creates the widgets with appropriate values.
63 void Clients::populateTable()
67 Freeze frz(*tableWidget); /* disable updating*/
69 QStringList headerlist = (QStringList() << tr("Client Name") << tr("File Retention")
70 << tr("Job Retention") << tr("AutoPrune") << tr("ClientId") << tr("Uname") );
72 int sortcol = headerlist.indexOf(tr("Client Name"));
73 Qt::SortOrder sortord = Qt::AscendingOrder;
74 if (tableWidget->rowCount()) {
75 sortcol = tableWidget->horizontalHeader()->sortIndicatorSection();
76 sortord = tableWidget->horizontalHeader()->sortIndicatorOrder();
79 m_checkcurwidget = false;
81 m_checkcurwidget = true;
83 tableWidget->setColumnCount(headerlist.count());
84 tableWidget->setHorizontalHeaderLabels(headerlist);
85 tableWidget->horizontalHeader()->setHighlightSections(false);
86 tableWidget->setRowCount(m_console->client_list.count());
87 tableWidget->verticalHeader()->hide();
88 tableWidget->setSelectionBehavior(QAbstractItemView::SelectRows);
89 tableWidget->setSelectionMode(QAbstractItemView::SingleSelection);
90 tableWidget->setSortingEnabled(false); /* rows move on insert if sorting enabled */
92 QString client_comsep("");
93 foreach (QString clientName, m_console->client_list){
95 client_comsep += "'" + clientName + "'";
99 client_comsep += ",'" + clientName + "'";
102 if (client_comsep != "") {
104 query += "SELECT Name, FileRetention, JobRetention, AutoPrune, ClientId, Uname"
106 " WHERE ClientId IN (SELECT MAX(ClientId) FROM Client WHERE";
107 query += " Name IN (" + client_comsep + ")";
108 query += " GROUP BY Name) ORDER BY Name";
111 if (mainWin->m_sqlDebug)
112 Pmsg1(000, "Clients query cmd : %s\n",query.toUtf8().data());
113 if (m_console->sql_cmd(query, results)) {
116 /* Iterate through the record returned from the query */
117 foreach (QString resultline, results) {
118 QStringList fieldlist = resultline.split("\t");
120 if (fieldlist.size() < 5) { // Uname is checked after
121 Pmsg1(0, "Unexpected line %s\n", resultline.toUtf8().data());
124 if (m_firstpopulation) {
125 settingsOpenStatus(fieldlist[0]);
128 TableItemFormatter item(*tableWidget, row);
130 /* Iterate through fields in the record */
131 QStringListIterator fld(fieldlist);
135 item.setTextFld(col++, fld.next());
138 item.setDurationFld(col++, fld.next());
141 item.setDurationFld(col++, fld.next());
144 item.setBoolFld(col++, fld.next());
147 item.setNumericFld(col++, fld.next());
151 item.setTextFld(col++, fld.next());
153 item.setTextFld(col++, "");
160 /* set default sorting */
161 tableWidget->sortByColumn(sortcol, sortord);
162 tableWidget->setSortingEnabled(true);
164 /* Resize rows and columns */
165 tableWidget->resizeColumnsToContents();
166 tableWidget->resizeRowsToContents();
169 int rcnt = tableWidget->rowCount();
170 int ccnt = tableWidget->columnCount();
171 for(int r=0; r < rcnt; r++) {
172 for(int c=0; c < ccnt; c++) {
173 QTableWidgetItem* item = tableWidget->item(r, c);
175 item->setFlags(Qt::ItemFlags(item->flags() & (~Qt::ItemIsEditable)));
179 m_firstpopulation = false;
183 * When the treeWidgetItem in the page selector tree is singleclicked, Make sure
184 * The tree has been populated.
186 void Clients::PgSeltreeWidgetClicked()
191 if (!isOnceDocked()) {
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(actionStatusClientWindow);
212 tableWidget->removeAction(actionPurgeJobs);
213 tableWidget->removeAction(actionPrune);
216 if (m_currentlyselected.length() != 0) {
217 /* set a hold variable to the client name in case the context sensitive
219 tableWidget->addAction(actionListJobsofClient);
220 tableWidget->addAction(actionStatusClientWindow);
221 tableWidget->addAction(actionPurgeJobs);
222 tableWidget->addAction(actionPrune);
228 * Setup a context menu
229 * Made separate from populate so that it would not create context menu over and
230 * over as the tree is repopulated.
232 void Clients::createContextMenu()
234 tableWidget->setContextMenuPolicy(Qt::ActionsContextMenu);
235 tableWidget->addAction(actionRefreshClients);
236 /* for the tableItemChanged to maintain m_currentJob */
237 connect(tableWidget, SIGNAL(
238 currentItemChanged(QTableWidgetItem *, QTableWidgetItem *)),
239 this, SLOT(tableItemChanged(QTableWidgetItem *, QTableWidgetItem *)));
241 /* connect to the action specific to this pages class */
242 connect(actionRefreshClients, SIGNAL(triggered()), this,
243 SLOT(populateTable()));
244 connect(actionListJobsofClient, SIGNAL(triggered()), this,
246 connect(actionStatusClientWindow, SIGNAL(triggered()), this,
247 SLOT(statusClientWindow()));
248 connect(actionPurgeJobs, SIGNAL(triggered()), this,
249 SLOT(consolePurgeJobs()));
250 connect(actionPrune, SIGNAL(triggered()), this,
255 * Function responding to actionListJobsofClient which calls mainwin function
256 * to create a window of a list of jobs of this client.
258 void Clients::showJobs()
260 QTreeWidgetItem *parentItem = mainWin->getFromHash(this);
261 mainWin->createPageJobList("", m_currentlyselected, "", "", parentItem);
265 * Function responding to actionListJobsofClient which calls mainwin function
266 * to create a window of a list of jobs of this client.
268 void Clients::consoleStatusClient()
270 QString cmd("status client=");
271 cmd += m_currentlyselected;
276 * Virtual function which is called when this page is visible on the stack
278 void Clients::currentStackItem()
282 /* Create the context menu for the client table */
287 * Function responding to actionPurgeJobs
289 void Clients::consolePurgeJobs()
291 if (QMessageBox::warning(this, "Bat",
292 tr("Are you sure you want to purge all jobs of client \"%1\" ?\n"
293 "The Purge command will delete associated Catalog database records from Jobs and"
294 " Volumes without considering the retention period. Purge works only on the"
295 " Catalog database and does not affect data written to Volumes. This command can"
296 " be dangerous because you can delete catalog records associated with current"
297 " backups of files, and we recommend that you do not use it unless you know what"
298 " you are doing.\n\n"
299 " Is there any way I can get you to click Cancel here? You really don't want to do"
301 "Press OK to proceed with the purge operation?").arg(m_currentlyselected),
302 QMessageBox::Ok | QMessageBox::Cancel,
304 == QMessageBox::Cancel) { return; }
306 QString cmd("purge jobs client=");
307 cmd += m_currentlyselected;
312 * Function responding to actionPrune
314 void Clients::prune()
316 new prunePage("", m_currentlyselected);
320 * Function responding to action to create new client status window
322 void Clients::statusClientWindow()
324 /* if one exists, then just set it current */
326 foreach(Pages *page, mainWin->m_pagehash) {
327 if (mainWin->currentConsole() == page->console()) {
328 if (page->name() == tr("Client Status %1").arg(m_currentlyselected)) {
335 QTreeWidgetItem *parentItem = mainWin->getFromHash(this);
336 new ClientStat(m_currentlyselected, parentItem);
341 * If first time, then check to see if there were status pages open the last time closed
344 void Clients::settingsOpenStatus(QString &client)
346 QSettings settings(m_console->m_dir->name(), "bat");
348 settings.beginGroup("OpenOnExit");
349 QString toRead = "ClientStatus_" + client;
350 if (settings.value(toRead) == 1) {
351 new ClientStat(client, mainWin->getFromHash(this));
353 mainWin->getFromHash(this)->setExpanded(true);