2 Bacula® - The Network Backup Solution
4 Copyright (C) 2007-2010 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.
30 #include <QAbstractEventDispatcher>
33 #include "mediaview.h"
34 #include "mediaedit/mediaedit.h"
35 #include "mediainfo/mediainfo.h"
36 #include "joblist/joblist.h"
37 #include "relabel/relabel.h"
39 #include "util/fmtwidgetitem.h"
41 MediaView::MediaView()
46 QTreeWidgetItem* thisitem = mainWin->getFromHash(this);
47 thisitem->setIcon(0,QIcon(QString::fromUtf8(":images/cartridge.png")));
48 connect(m_pbApply, SIGNAL(pressed()), this, SLOT(applyPushed()));
49 connect(m_pbEdit, SIGNAL(pressed()), this, SLOT(editPushed()));
50 connect(m_pbPurge, SIGNAL(pressed()), this, SLOT(purgePushed()));
51 connect(m_pbDelete, SIGNAL(pressed()), this, SLOT(deletePushed()));
52 connect(m_pbPrune, SIGNAL(pressed()), this, SLOT(prunePushed()));
53 connect(m_tableMedia, SIGNAL(itemDoubleClicked(QTableWidgetItem*)),
54 this, SLOT(showInfoForMedia(QTableWidgetItem *)));
56 /* mp_treeWidget, Storage Tree Tree Widget inherited from ui_medialist.h */
58 m_checkcurwidget = true;
62 void MediaView::showInfoForMedia(QTableWidgetItem * item)
64 QTreeWidgetItem* pageSelectorTreeWidgetItem = mainWin->getFromHash(this);
65 int row = item->row();
66 QString vol = m_tableMedia->item(row, 0)->text();
67 new MediaInfo(pageSelectorTreeWidgetItem, vol);
68 // connect(j, SIGNAL(destroyed()), this, SLOT(populateTree()));
71 MediaView::~MediaView()
75 void MediaView::applyPushed()
80 void MediaView::editPushed()
86 for(int i=0; i<sel.count(); i++) {
88 new MediaEdit(mainWin->getFromHash(this), cmd);
92 void MediaView::purgePushed()
94 if (QMessageBox::warning(this, "Bat",
95 tr("Are you sure you want to purge ?? !!!.\n"
96 "The Purge command will delete associated Catalog database records from Jobs and"
97 " Volumes without considering the retention period. Purge works only on the"
98 " Catalog database and does not affect data written to Volumes. This command can"
99 " be dangerous because you can delete catalog records associated with current"
100 " backups of files, and we recommend that you do not use it unless you know what"
102 "Press OK to proceed with the purge operation?"),
103 QMessageBox::Ok | QMessageBox::Cancel)
104 == QMessageBox::Cancel) { return; }
109 for(int i=0; i<lst.count(); i++) {
110 cmd = "purge volume=" + lst.at(i);
116 bool MediaView::getSelection(QStringList &list)
118 QList<QTableWidgetItem*> items = m_tableMedia->selectedItems();
119 QTableWidgetItem *it;
122 int nb = items.count();
126 tab = (int *) malloc (nb * sizeof(int));
127 memset(tab, 0, sizeof(int)*nb);
128 for (int i = 0; i < nb; ++i) {
129 row = items[i]->row();
132 it = m_tableMedia->item(row, 0);
133 list.append(it->text());
137 return list.count() > 0;
140 void MediaView::prunePushed()
146 for(int i=0; i<sel.count(); i++) {
147 cmd = "prune volume=" + sel.at(i);
153 void MediaView::deletePushed()
155 if (QMessageBox::warning(this, "Bat",
156 tr("Are you sure you want to delete?? !!!.\n"
157 "This delete command is used to delete a Volume record and all associated catalog"
158 " records that were created. This command operates only on the Catalog"
159 " database and has no effect on the actual data written to a Volume. This"
160 " command can be dangerous and we strongly recommend that you do not use"
161 " it unless you know what you are doing. All Jobs and all associated"
162 " records (File and JobMedia) will be deleted from the catalog."
163 "Press OK to proceed with delete operation.?"),
164 QMessageBox::Ok | QMessageBox::Cancel)
165 == QMessageBox::Cancel) { return; }
170 for(int i=0; i<lst.count(); i++) {
171 cmd = "delete volume=" + lst.at(i);
177 void MediaView::populateForm()
180 m_cbPool->addItem("");
181 m_cbPool->addItems(m_console->pool_list);
184 m_cbStatus->addItem("");
185 m_cbStatus->addItems(m_console->volstatus_list);
187 m_cbMediaType->clear();
188 m_cbMediaType->addItem("");
189 m_cbMediaType->addItems(m_console->mediatype_list);
191 m_cbLocation->clear();
192 m_cbLocation->addItem("");
193 m_cbLocation->addItems(m_console->location_list);
197 * If chkExpired button is checked, we can remove all non Expired
200 void MediaView::filterExipired(QStringList &list)
202 utime_t t, now = time(NULL);
203 QString resultline, stat, LastWritten;
204 QStringList fieldlist;
206 /* We should now in advance how many rows we will have */
207 if (m_chkExpired->isChecked()) {
208 for (int i=list.size() -1; i >= 0; i--) {
209 fieldlist = list.at(i).split("\t");
210 ASSERT(fieldlist.size() != 9);
211 LastWritten = fieldlist.at(7);
212 if (LastWritten == "") {
216 stat = fieldlist.at(8);
217 t = str_to_utime(LastWritten.toAscii().data());
218 t = t + stat.toULongLong();
228 * The main meat of the class!! The function that querries the director and
229 * creates the widgets with appropriate values.
231 void MediaView::populateTable()
235 QString stat, resultline, query;
237 QHash<QString, float> hash_size;
238 QStringList fieldlist, results;
245 Freeze frz(*m_tableMedia); /* disable updating*/
248 if (m_cbPool->currentText() != "") {
249 cmd = " Pool.Name = '" + m_cbPool->currentText() + "'";
253 if (m_cbStatus->currentText() != "") {
254 cmd = " Media.VolStatus = '" + m_cbStatus->currentText() + "'";
258 if (m_cbStatus->currentText() != "") {
259 cmd = " Media.VolStatus = '" + m_cbStatus->currentText() + "'";
263 if (m_cbMediaType->currentText() != "") {
264 cmd = " Media.MediaType = '" + m_cbMediaType->currentText() + "'";
268 if (m_cbLocation->currentText() != "") {
269 cmd = " Location.Location = '" + m_cbLocation->currentText() + "'";
273 if (m_textName->text() != "") {
274 cmd = " Media.VolumeName like '%" + m_textName->text() + "%'";
278 if (where.size() > 0) {
279 cmd = " WHERE " + where.join(" AND ");
285 "SELECT AVG(VolBytes) AS size, COUNT(1) as nb, "
286 "MediaType FROM Media "
287 "WHERE VolStatus IN ('Full', 'Used') "
288 "GROUP BY MediaType";
290 if (mainWin->m_sqlDebug) {
291 Pmsg1(000, "MediaView query cmd : %s\n",query.toUtf8().data());
293 if (m_console->sql_cmd(query, results)) {
294 foreach (resultline, results) {
295 fieldlist = resultline.split("\t");
296 if (fieldlist.at(1).toInt() >= 1) {
298 hash_size[fieldlist.at(2)]
299 = fieldlist.at(0).toFloat();
304 m_tableMedia->clearContents();
306 "SELECT VolumeName, InChanger, "
307 "Slot, MediaType, VolStatus, VolBytes, Pool.Name, "
308 "LastWritten, Media.VolRetention "
309 "FROM Media JOIN Pool USING (PoolId) "
310 "LEFT JOIN Location ON (Media.LocationId=Location.LocationId) "
312 " ORDER BY VolumeName LIMIT " + m_sbLimit->cleanText();
314 m_tableMedia->setSortingEnabled(false); /* Don't sort during insert */
316 if (mainWin->m_sqlDebug) {
317 Pmsg1(000, "MediaView query cmd : %s\n",query.toUtf8().data());
319 if (m_console->sql_cmd(query, results)) {
321 filterExipired(results);
322 m_tableMedia->setRowCount(results.size());
324 foreach (resultline, results) { // should have only one result
326 QString VolBytes, MediaType, LastWritten, VolStatus;
327 fieldlist = resultline.split("\t");
328 if (fieldlist.size() != 10) {
331 QStringListIterator fld(fieldlist);
332 TableItemFormatter mediaitem(*m_tableMedia, row);
335 mediaitem.setTextFld(index++, fld.next());
338 mediaitem.setInChanger(index++, fld.next());
341 MediaType = fld.next();
342 VolStatus = fld.next();
345 VolBytes = fld.next();
346 mediaitem.setBytesFld(index++, VolBytes);
350 if (hash_size.contains(MediaType) &&
351 hash_size[MediaType] != 0) {
352 usage = VolBytes.toLongLong() * 100 / hash_size[MediaType];
354 mediaitem.setPercent(index++, usage);
357 mediaitem.setVolStatusFld(index++, VolStatus);
360 mediaitem.setTextFld(index++, fld.next());
363 mediaitem.setTextFld(index++, MediaType);
365 LastWritten = fld.next();
367 if (LastWritten != "") {
368 stat = fld.next(); // VolUseDuration
369 t = str_to_utime(LastWritten.toAscii().data());
370 t = t + stat.toULongLong();
372 localtime_r(&ttime, &tm);
373 strftime(buf, sizeof(buf), "%Y-%m-%d %H:%M:%S", &tm);
377 mediaitem.setTextFld(index++, LastWritten);
380 mediaitem.setTextFld(index++, buf);
384 m_tableMedia->resizeColumnsToContents();
385 m_tableMedia->resizeRowsToContents();
386 m_tableMedia->verticalHeader()->hide();
387 m_tableMedia->setSortingEnabled(true);
390 m_tableMedia->setEditTriggers(QAbstractItemView::NoEditTriggers);
394 * When the treeWidgetItem in the page selector tree is singleclicked, Make sure
395 * The tree has been populated.
397 void MediaView::PgSeltreeWidgetClicked()
403 if (!isOnceDocked()) {
409 * Virtual function which is called when this page is visible on the stack
411 void MediaView::currentStackItem()
420 // * Called from the signal of the context sensitive menu to relabel!
422 // void MediaView::relabelVolume()
424 // setConsoleCurrent();
425 // new relabelDialog(m_console, m_currentVolumeName);
429 // * Called from the signal of the context sensitive menu to purge!
431 // void MediaView::allVolumesFromPool()
433 // QString cmd = "update volume AllFromPool=" + m_currentVolumeName;
434 // consoleCommand(cmd);
438 // void MediaView::allVolumes()
440 // QString cmd = "update volume allfrompools";
441 // consoleCommand(cmd);
446 // * Called from the signal of the context sensitive menu to purge!
448 // void MediaView::volumeFromPool()
450 // QTreeWidgetItem *currentItem = mp_treeWidget->currentItem();
451 // QTreeWidgetItem *parent = currentItem->parent();
452 // QString pool = parent->text(0);
454 // cmd = "update volume=" + m_currentVolumeName + " frompool=" + pool;
455 // consoleCommand(cmd);