void ItemFormatterBase::setBytesFld(int index, const QString &fld)
{
qint64 qfld = fld.trimmed().toLongLong();
QString msg;
switch (cnvFlag) {
case BYTES_CONVERSION_NONE:
msg = QString::number(qfld);
break;
case BYTES_CONVERSION_IEC:
msg = convertBytesIEC(qfld);
break;
case BYTES_CONVERSION_SI:
msg = convertBytesSI(qfld);
break;
default:
msg = " ";
break;
}
setNumericFld(index, msg, QVariant(qfld));
}
/*
* Populate the text in the window
*/
void MediaInfo::populateForm()
{
utime_t t;
time_t ttime;
QString stat, LastWritten;
struct tm tm;
char buf[256];
QString query =
"SELECT MediaId, VolumeName, Pool.Name, MediaType, FirstWritten,"
"LastWritten, VolMounts, VolBytes, Media.Enabled,"
"Location.Location, VolStatus, RecyclePool.Name, Media.Recycle, "
"VolReadTime/1000000, VolWriteTime/1000000, Media.VolUseDuration, "
"Media.MaxVolJobs, Media.MaxVolFiles, Media.MaxVolBytes, "
"Media.VolRetention,InChanger,Slot "
"FROM Media JOIN Pool USING (PoolId) LEFT JOIN Pool AS RecyclePool "
"ON (Media.RecyclePoolId=RecyclePool.PoolId) "
"LEFT JOIN Location ON (Media.LocationId=Location.LocationId) "
"WHERE Media.VolumeName='" + m_mediaName + "'";
if (mainWin->m_sqlDebug) {
Pmsg1(000, "MediaInfo query cmd : %s\n",query.toUtf8().data());
}
QStringList results;
if (m_console->sql_cmd(query, results)) {
QString resultline;
QStringList fieldlist;
foreach (resultline, results) { // should have only one result
fieldlist = resultline.split("\t");
QStringListIterator fld(fieldlist);
m_mediaId = fld.next();
label_VolumeName->setText(fld.next());
label_Pool->setText(fld.next());
label_MediaType->setText(fld.next());
label_FirstWritten->setText(fld.next());
LastWritten = fld.next();
label_LastWritten->setText(LastWritten);
// label_VolFiles->setText(fld.next());
label_VolMounts->setText(fld.next());
label_VolBytes->setText(convertBytesSI(fld.next().toULongLong()));
label_Enabled->setPixmap(QPixmap(":/images/inflag" + fld.next() + ".png"));
label_Location->setText(fld.next());
label_VolStatus->setText(fld.next());
label_RecyclePool->setText(fld.next());
chkbox_Recycle->setCheckState(fld.next().toInt()?Qt::Checked:Qt::Unchecked);
edit_utime(fld.next().toULongLong(), buf, sizeof(buf));
label_VolReadTime->setText(QString(buf));
edit_utime(fld.next().toULongLong(), buf, sizeof(buf));
label_VolWriteTime->setText(QString(buf));
edit_utime(fld.next().toULongLong(), buf, sizeof(buf));
label_VolUseDuration->setText(QString(buf));
label_MaxVolJobs->setText(fld.next());
label_MaxVolFiles->setText(fld.next());
label_MaxVolBytes->setText(fld.next());
stat = fld.next();
edit_utime(stat.toULongLong(), buf, sizeof(buf));
label_VolRetention->setText(QString(buf));
if (LastWritten != "") {
t = str_to_utime(LastWritten.toAscii().data());
t = t + stat.toULongLong();
ttime = t;
localtime_r(&ttime, &tm);
strftime(buf, sizeof(buf), "%Y-%m-%d %H:%M:%S", &tm);
label_Expire->setText(QString(buf));
}
label_Online->setPixmap(QPixmap(":/images/inflag"+fld.next()+".png"));
// label_VolFiles->setText(fld.next());
// label_VolErrors->setText(fld.next());
// stat=fld.next();
// jobstatus_to_ascii_gui(stat[0].toAscii(), buf, sizeof(buf));
// stat = buf;
//
}
