void VirtualClusterLineEdit::sHandleCompleter()
{
if (!hasFocus())
return;
QString stripped = text().trimmed().toUpper();
if (stripped.isEmpty())
return;
int width = 0;
QSqlQueryModel* model = static_cast<QSqlQueryModel *>(_completer->model());
QTreeView * view = static_cast<QTreeView *>(_completer->popup());
_parsed = true;
XSqlQuery numQ;
numQ.prepare(_query + _numClause +
(_extraClause.isEmpty() || !_strict ? "" : " AND " + _extraClause) +
((_hasActive && ! _showInactive) ? _activeClause : "") +
QString(" ORDER BY %1 LIMIT 10;").arg(_numColName));
numQ.bindValue(":number", "^" + stripped);
numQ.exec();
if (numQ.first())
{
int numberCol = numQ.record().indexOf("number");
int nameCol = numQ.record().indexOf("name");
int descripCol = numQ.record().indexOf("description");
model->setQuery(numQ);
_completer->setCompletionPrefix(stripped);
for (int i = 0; i < model->columnCount(); i++)
{
if ( (i != numberCol) &&
(!_hasName || i != nameCol ) &&
(!_hasDescription || i != descripCol) )
{
view->hideColumn(i);
}
}
view->resizeColumnToContents(numberCol);
width += view->columnWidth(numberCol);
if (_hasName)
{
view->resizeColumnToContents(nameCol);
width += view->columnWidth(nameCol);
}
if (_hasDescription)
{
view->resizeColumnToContents(descripCol);
width += view->columnWidth(descripCol);
}
}
else
model->setQuery(QSqlQuery());
if (width > 350)
width = 350;
QRect rect;
rect.setHeight(height());
rect.setWidth(width);
rect.setBottomLeft(QPoint(0, height() - 2));
_completer->complete(rect);
_parsed = false;
}
void ItemLineEdit::sHandleCompleter()
{
if (!hasFocus())
return;
QString stripped = text().trimmed().toUpper();
if (stripped.isEmpty())
return;
int width = 0;
QSqlQueryModel* model = static_cast<QSqlQueryModel *>(_completer->model());
QTreeView * view = static_cast<QTreeView *>(_completer->popup());
_parsed = true;
XSqlQuery numQ;
if (_useQuery)
{
numQ.prepare(QString("SELECT * FROM (%1) data WHERE (item_number ~* :number) LIMIT 10")
.arg(QString(_sql)).remove(";"));
numQ.bindValue(":number", "^" + stripped);
}
else
{
QString pre( "SELECT DISTINCT item_id, item_number, "
"(item_descrip1 || ' ' || item_descrip2) AS itemdescrip, "
"item_upccode AS description " );
QStringList clauses;
clauses = _extraClauses;
clauses << "(item_number ~* :searchString OR item_upccode ~* :searchString)";
numQ.prepare(buildItemLineEditQuery(pre, clauses, QString::null, _type).replace(";"," ORDER BY item_number LIMIT 10;"));
numQ.bindValue(":searchString", QString(text().trimmed().toUpper()).prepend("^"));
}
numQ.exec();
if (numQ.first())
{
int numberCol = numQ.record().indexOf("item_number");
int descripCol = numQ.record().indexOf("itemdescrip");
model->setQuery(numQ);
_completer->setCompletionPrefix(stripped);
for (int i = 0; i < model->columnCount(); i++)
{
if ( (i == numberCol) ||
(i == descripCol) )
{
view->resizeColumnToContents(i);
width += view->columnWidth(i);
}
else
view->hideColumn(i);
}
}
else
model->setQuery(QSqlQuery());
if (width > 350)
width = 350;
QRect rect;
rect.setHeight(height());
rect.setWidth(width);
rect.setBottomLeft(QPoint(0, height() - 2));
_completer->complete(rect);
_parsed = false;
}
int TreeView::columnWidth(lua_State * L) // ( int column ) const : int
{
QTreeView* obj = QtObject<QTreeView>::check( L, 1);
Util::push( L, obj->columnWidth( Util::toInt( L, 2 ) ) );
return 1;
}
