2 Bacula® - The Network Backup Solution
4 Copyright (C) 2007-2008 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 /* add context sensitive menu items specific to this classto the page
59 * selector tree. m_contextActions is QList of QActions */
60 m_contextActions.append(actionRefreshClients);
70 * The main meat of the class!! The function that querries the director and
71 * creates the widgets with appropriate values.
73 void Clients::populateTable()
77 Freeze frz(*tableWidget); /* disable updating*/
79 QStringList headerlist = (QStringList() << tr("Client Name") << tr("File Retention")
80 << tr("Job Retention") << tr("AutoPrune") << tr("ClientId") << tr("Uname") );
82 int sortcol = headerlist.indexOf(tr("Client Name"));
83 Qt::SortOrder sortord = Qt::AscendingOrder;
84 if (tableWidget->rowCount()) {
85 sortcol = tableWidget->horizontalHeader()->sortIndicatorSection();
86 sortord = tableWidget->horizontalHeader()->sortIndicatorOrder();
89 m_checkcurwidget = false;
91 m_checkcurwidget = true;
93 tableWidget->setColumnCount(headerlist.count());
94 tableWidget->setHorizontalHeaderLabels(headerlist);
95 tableWidget->horizontalHeader()->setHighlightSections(false);
96 tableWidget->setRowCount(m_console->client_list.count());
97 tableWidget->verticalHeader()->hide();
98 tableWidget->setSelectionBehavior(QAbstractItemView::SelectRows);
99 tableWidget->setSelectionMode(QAbstractItemView::SingleSelection);
100 tableWidget->setSortingEnabled(false); /* rows move on insert if sorting enabled */
102 QString client_comsep("");
103 foreach (QString clientName, m_console->client_list){
105 client_comsep += "'" + clientName + "'";
109 client_comsep += ",'" + clientName + "'";
112 if (client_comsep != "") {
114 query += "SELECT Name, FileRetention, JobRetention, AutoPrune, ClientId, Uname"
116 " WHERE ClientId IN (SELECT MAX(ClientId) FROM Client WHERE";
117 query += " Name IN (" + client_comsep + ")";
118 query += " GROUP BY Name) ORDER BY Name";
121 if (mainWin->m_sqlDebug)
122 Pmsg1(000, "Clients query cmd : %s\n",query.toUtf8().data());
123 if (m_console->sql_cmd(query, results)) {
126 /* Iterate through the record returned from the query */
127 foreach (QString resultline, results) {
128 QStringList fieldlist = resultline.split("\t");
130 TableItemFormatter item(*tableWidget, row);
132 /* Iterate through fields in the record */
133 QStringListIterator fld(fieldlist);
137 item.setTextFld(col++, fld.next());
140 item.setDurationFld(col++, fld.next());
143 item.setDurationFld(col++, fld.next());
146 item.setBoolFld(col++, fld.next());
149 item.setNumericFld(col++, fld.next());
152 item.setTextFld(col++, fld.next());
158 /* set default sorting */
159 tableWidget->sortByColumn(sortcol, sortord);
160 tableWidget->setSortingEnabled(true);
162 /* Resize rows and columns */
163 tableWidget->resizeColumnsToContents();
164 tableWidget->resizeRowsToContents();
167 int rcnt = tableWidget->rowCount();
168 int ccnt = tableWidget->columnCount();
169 for(int r=0; r < rcnt; r++) {
170 for(int c=0; c < ccnt; c++) {
171 QTableWidgetItem* item = tableWidget->item(r, c);
172 item->setFlags(Qt::ItemFlags(item->flags() & (~Qt::ItemIsEditable)));
178 * When the treeWidgetItem in the page selector tree is singleclicked, Make sure
179 * The tree has been populated.
181 void Clients::PgSeltreeWidgetClicked()
189 * Added to set the context menu policy based on currently active treeWidgetItem
190 * signaled by currentItemChanged
192 void Clients::tableItemChanged(QTableWidgetItem *currentwidgetitem, QTableWidgetItem *previouswidgetitem )
194 /* m_checkcurwidget checks to see if this is during a refresh, which will segfault */
195 if (m_checkcurwidget) {
196 int currentRow = currentwidgetitem->row();
197 QTableWidgetItem *currentrowzeroitem = tableWidget->item(currentRow, 0);
198 m_currentlyselected = currentrowzeroitem->text();
200 /* The Previous item */
201 if (previouswidgetitem) { /* avoid a segfault if first time */
202 tableWidget->removeAction(actionListJobsofClient);
203 tableWidget->removeAction(actionStatusClientInConsole);
204 tableWidget->removeAction(actionStatusClientWindow);
205 tableWidget->removeAction(actionPurgeJobs);
206 tableWidget->removeAction(actionPrune);
209 if (m_currentlyselected.length() != 0) {
210 /* set a hold variable to the client name in case the context sensitive
212 tableWidget->addAction(actionListJobsofClient);
213 tableWidget->addAction(actionStatusClientInConsole);
214 tableWidget->addAction(actionStatusClientWindow);
215 tableWidget->addAction(actionPurgeJobs);
216 tableWidget->addAction(actionPrune);
222 * Setup a context menu
223 * Made separate from populate so that it would not create context menu over and
224 * over as the tree is repopulated.
226 void Clients::createContextMenu()
228 tableWidget->setContextMenuPolicy(Qt::ActionsContextMenu);
229 tableWidget->addAction(actionRefreshClients);
230 /* for the tableItemChanged to maintain m_currentJob */
231 connect(tableWidget, SIGNAL(
232 currentItemChanged(QTableWidgetItem *, QTableWidgetItem *)),
233 this, SLOT(tableItemChanged(QTableWidgetItem *, QTableWidgetItem *)));
235 /* connect to the action specific to this pages class */
236 connect(actionRefreshClients, SIGNAL(triggered()), this,
237 SLOT(populateTable()));
238 connect(actionListJobsofClient, SIGNAL(triggered()), this,
240 connect(actionStatusClientInConsole, SIGNAL(triggered()), this,
241 SLOT(consoleStatusClient()));
242 connect(actionStatusClientWindow, SIGNAL(triggered()), this,
243 SLOT(statusClientWindow()));
244 connect(actionPurgeJobs, SIGNAL(triggered()), this,
245 SLOT(consolePurgeJobs()));
246 connect(actionPrune, SIGNAL(triggered()), this,
251 * Function responding to actionListJobsofClient which calls mainwin function
252 * to create a window of a list of jobs of this client.
254 void Clients::showJobs()
256 QTreeWidgetItem *parentItem = mainWin->getFromHash(this);
257 mainWin->createPageJobList("", m_currentlyselected, "", "", parentItem);
261 * Function responding to actionListJobsofClient which calls mainwin function
262 * to create a window of a list of jobs of this client.
264 void Clients::consoleStatusClient()
266 QString cmd("status client=");
267 cmd += m_currentlyselected;
272 * Virtual function which is called when this page is visible on the stack
274 void Clients::currentStackItem()
278 /* Create the context menu for the client table */
283 * Function responding to actionPurgeJobs
285 void Clients::consolePurgeJobs()
287 if (QMessageBox::warning(this, "Bat",
288 tr("Are you sure you want to purge all jobs of client \"%1\" ?\n"
289 "The Purge command will delete associated Catalog database records from Jobs and"
290 " Volumes without considering the retention period. Purge works only on the"
291 " Catalog database and does not affect data written to Volumes. This command can"
292 " be dangerous because you can delete catalog records associated with current"
293 " backups of files, and we recommend that you do not use it unless you know what"
294 " you are doing.\n\n"
295 " Is there any way I can get you to click Cancel here? You really don't want to do"
297 "Press OK to proceed with the purge operation?").arg(m_currentlyselected),
298 QMessageBox::Ok | QMessageBox::Cancel,
300 == QMessageBox::Cancel) { return; }
302 QString cmd("purge jobs client=");
303 cmd += m_currentlyselected;
308 * Function responding to actionPrune
310 void Clients::prune()
312 new prunePage("", m_currentlyselected);
316 * Function responding to action to create new client status window
318 void Clients::statusClientWindow()
320 QTreeWidgetItem *parentItem = mainWin->getFromHash(this);
321 new ClientStat(m_currentlyselected, parentItem);