void XLineEdit::focusOutEvent(QFocusEvent * event)
{
if (!_nullStr.isEmpty())
{
connect(this, SIGNAL(textChanged(QString)), this, SLOT(sHandleNullStr()));
sHandleNullStr();
}
QLineEdit::focusOutEvent(event);
}
void XLineEdit::setNullStr(const QString &text)
{
if (_nullStr == text )
return;
_nullStr = text;
sHandleNullStr();
if (!_nullStr.isEmpty())
connect(this, SIGNAL(textChanged(QString)), this, SLOT(sHandleNullStr()));
}
void CrmClusterLineEdit::silentSetId(const int pId)
{
if (DEBUG)
qDebug("VCLE %s::silentSetId(%d)", qPrintable(objectName()), pId);
if (pId == -1)
{
XLineEdit::clear();
_model = new QSqlQueryModel(this);
}
else
{
XSqlQuery idQ;
idQ.prepare(_query + _idClause + QString(";"));
idQ.bindValue(":id", pId);
idQ.exec();
if (idQ.first())
{
if (_completer)
static_cast<QSqlQueryModel* >(_completer->model())->setQuery(QSqlQuery());
_id = pId;
_valid = true;
_model->setQuery(idQ);
setText(idQ.value("number").toString());
if (_hasName)
_name = (idQ.value("name").toString());
if (_hasDescription)
_description = idQ.value("description").toString();
if (_hasActive)
setStrikeOut(!idQ.value("active").toBool());
if (_hasOwner)
_owner = idQ.value("owner").toString();
if (_hasAssignto)
_assignto = idQ.value("assignto").toString();
}
else if (idQ.lastError().type() != QSqlError::NoError)
QMessageBox::critical(this, tr("A System Error Occurred at %1::%2.")
.arg(__FILE__)
.arg(__LINE__),
idQ.lastError().databaseText());
}
_parsed = true;
sHandleNullStr();
emit parsed();
}
void VirtualClusterLineEdit::sParse()
{
if (DEBUG)
qDebug("VCLE %s::sParse() entered with _parsed %d and text() %s",
qPrintable(objectName()), _parsed, qPrintable(text()));
if (! _parsed)
{
QString stripped = text().trimmed().toUpper();
if (stripped.length() == 0)
{
_parsed = true;
setId(-1);
}
else
{
XSqlQuery numQ;
numQ.prepare(_query + _numClause +
(_extraClause.isEmpty() || !_strict ? "" : " AND " + _extraClause) +
((_hasActive && ! _showInactive) ? _activeClause : "" ) +
QString("ORDER BY %1 LIMIT 1;").arg(_numColName));
numQ.bindValue(":number", "^" + stripped);
numQ.exec();
if (numQ.first())
{
_valid = true;
setId(numQ.value("id").toInt());
if (_hasName)
_name = (numQ.value("name").toString());
if (_hasDescription)
_description = numQ.value("description").toString();
}
else
{
setId(-1);
if (numQ.lastError().type() != QSqlError::NoError)
QMessageBox::critical(this, tr("A System Error Occurred at %1::%2.")
.arg(__FILE__)
.arg(__LINE__),
numQ.lastError().databaseText());
}
}
emit valid(_valid);
emit parsed();
}
_parsed = true;
sHandleNullStr();
}
// TODO: can we get _recip_id and _recip_type using the inherited sParse()?
void QuoteLineEdit::sParse()
{
if (! _parsed)
{
QString stripped = text().trimmed().toUpper();
if (stripped.length() == 0)
{
_parsed = true;
setId(-1);
}
else
{
XSqlQuery numQ;
numQ.prepare(_query + _numClause +
(_extraClause.isEmpty() || !_strict ? "" : " AND " + _extraClause) +
QString(";"));
numQ.bindValue(":number", "^" + stripped);
numQ.exec();
if (numQ.first())
{
_valid = true;
setId(numQ.value("id").toInt());
if (_hasName)
_name = numQ.value("name").toString();
if (_hasDescription)
_description = numQ.value("description").toString();
_recip_id = numQ.value("recip_id").toInt();
_recip_type = numQ.value("recip_type").toString();
}
else
{
setId(-1);
if (numQ.lastError().type() != QSqlError::NoError)
QMessageBox::critical(this, tr("A System Error Occurred at %1::%2.")
.arg(__FILE__)
.arg(__LINE__),
numQ.lastError().databaseText());
}
}
emit valid(_valid);
emit parsed();
}
_parsed = true;
sHandleNullStr();
}
void XLineEdit::setText(const QVariant &pVariant)
{
if (pVariant.type() == QVariant::Double)
{
const QValidator *v = validator();
int prec = 0;
if (v && v->inherits("QDoubleValidator"))
prec = ((QDoubleValidator*)v)->decimals();
else if (v && v->inherits("QIntValidator"))
prec = 0;
QLineEdit::setText(formatNumber(pVariant.toDouble(), prec));
}
else
QLineEdit::setText(pVariant.toString());
sHandleNullStr();
}
