void CProcessListTable::refresh()
{
if (isBlocked())
return;
setBlocked(true);
bool max_scroll = false;
int scroll = is_first ? 0 : verticalScrollBar()->value();
if (scroll >= verticalScrollBar()->maxValue() - 1 && scroll != 0)
max_scroll = true;
if (keepColumnWidth() && numCols() > 0)
for (int i = 0; i < numCols(); i++)
previous_columns_map.insert(i, CTable::OldColumn(horizontalHeader()->sectionSize(i), horizontalHeader()->label(i)));
clearCellWidget(currentRow(), currentColumn());
if (is_first)
ensureVisible(0, 0);
query()->freeResult();
setNumRows(0);
horizontalHeader()->setSortIndicator( -1 );
if (query()->exec(sql))
{
uint num_rows = qry->numRows();
uint num_fields = qry->numFields();
bool columns_ok = (keepColumnWidth() && previous_columns_map.count() == num_fields);
if (columns_ok)
for (uint i = 0; i < num_fields; i++)
columns_ok &= (previous_columns_map[i].label == query()->fields(i).name);
if (!columns_ok && keepColumnWidth())
previous_columns_map.clear();
setNumRows(num_rows);
setNumCols(num_fields);
if (is_first)
{
for (uint i = 0; i < num_fields; i++)
{
if (columns_ok && previous_columns_map[i].label == query()->fields(i).name)
horizontalHeader()->setLabel(i, qry->fields(i).name, previous_columns_map[i].size);
else
horizontalHeader()->setLabel(i, qry->fields(i).name);
setColumnReadOnly (i, (i != 0));
}
is_first = false;
}
if (hasProcessEvents())
qApp->processEvents();
else
updateScrollBars();
uint j = 0;
while (query()->next())
{
for (uint i = 0; i < num_fields; i++)
{
const char *val = query()->row(i) ? query()->row(i) : NULL_TEXT;
if (i == 0)
setItem (j, i, new CCheckTableItem(this, val));
else
setText(j, i, val);
}
j++;
}
if (!columns_ok)
for (j = 0; j < num_fields; j++)
adjustColumn(j);
if (max_scroll)
scroll = verticalScrollBar()->maxValue();
verticalScrollBar()->setValue(scroll);
}
setBlocked(false);
applyLastSort();
}
bool QTable::qt_invoke( int _id, QUObject* _o )
{
switch ( _id - staticMetaObject()->slotOffset() ) {
case 0: setNumRows((int)static_QUType_int.get(_o+1)); break;
case 1: setNumCols((int)static_QUType_int.get(_o+1)); break;
case 2: setShowGrid((bool)static_QUType_bool.get(_o+1)); break;
case 3: hideRow((int)static_QUType_int.get(_o+1)); break;
case 4: hideColumn((int)static_QUType_int.get(_o+1)); break;
case 5: showRow((int)static_QUType_int.get(_o+1)); break;
case 6: showColumn((int)static_QUType_int.get(_o+1)); break;
case 7: static_QUType_bool.set(_o,isRowHidden((int)static_QUType_int.get(_o+1))); break;
case 8: static_QUType_bool.set(_o,isColumnHidden((int)static_QUType_int.get(_o+1))); break;
case 9: setColumnWidth((int)static_QUType_int.get(_o+1),(int)static_QUType_int.get(_o+2)); break;
case 10: setRowHeight((int)static_QUType_int.get(_o+1),(int)static_QUType_int.get(_o+2)); break;
case 11: adjustColumn((int)static_QUType_int.get(_o+1)); break;
case 12: adjustRow((int)static_QUType_int.get(_o+1)); break;
case 13: setColumnStretchable((int)static_QUType_int.get(_o+1),(bool)static_QUType_bool.get(_o+2)); break;
case 14: setRowStretchable((int)static_QUType_int.get(_o+1),(bool)static_QUType_bool.get(_o+2)); break;
case 15: static_QUType_bool.set(_o,isColumnStretchable((int)static_QUType_int.get(_o+1))); break;
case 16: static_QUType_bool.set(_o,isRowStretchable((int)static_QUType_int.get(_o+1))); break;
case 17: setSorting((bool)static_QUType_bool.get(_o+1)); break;
case 18: swapRows((int)static_QUType_int.get(_o+1),(int)static_QUType_int.get(_o+2)); break;
case 19: swapRows((int)static_QUType_int.get(_o+1),(int)static_QUType_int.get(_o+2),(bool)static_QUType_bool.get(_o+3)); break;
case 20: swapColumns((int)static_QUType_int.get(_o+1),(int)static_QUType_int.get(_o+2)); break;
case 21: swapColumns((int)static_QUType_int.get(_o+1),(int)static_QUType_int.get(_o+2),(bool)static_QUType_bool.get(_o+3)); break;
case 22: swapCells((int)static_QUType_int.get(_o+1),(int)static_QUType_int.get(_o+2),(int)static_QUType_int.get(_o+3),(int)static_QUType_int.get(_o+4)); break;
case 23: setLeftMargin((int)static_QUType_int.get(_o+1)); break;
case 24: setTopMargin((int)static_QUType_int.get(_o+1)); break;
case 25: setCurrentCell((int)static_QUType_int.get(_o+1),(int)static_QUType_int.get(_o+2)); break;
case 26: clearSelection(); break;
case 27: clearSelection((bool)static_QUType_bool.get(_o+1)); break;
case 28: setColumnMovingEnabled((bool)static_QUType_bool.get(_o+1)); break;
case 29: setRowMovingEnabled((bool)static_QUType_bool.get(_o+1)); break;
case 30: setReadOnly((bool)static_QUType_bool.get(_o+1)); break;
case 31: setRowReadOnly((int)static_QUType_int.get(_o+1),(bool)static_QUType_bool.get(_o+2)); break;
case 32: setColumnReadOnly((int)static_QUType_int.get(_o+1),(bool)static_QUType_bool.get(_o+2)); break;
case 33: setDragEnabled((bool)static_QUType_bool.get(_o+1)); break;
case 34: static_QUType_bool.set(_o,dragEnabled()); break;
case 35: insertRows((int)static_QUType_int.get(_o+1)); break;
case 36: insertRows((int)static_QUType_int.get(_o+1),(int)static_QUType_int.get(_o+2)); break;
case 37: insertColumns((int)static_QUType_int.get(_o+1)); break;
case 38: insertColumns((int)static_QUType_int.get(_o+1),(int)static_QUType_int.get(_o+2)); break;
case 39: removeRow((int)static_QUType_int.get(_o+1)); break;
case 40: removeRows((const QMemArray<int>&)*((const QMemArray<int>*)static_QUType_ptr.get(_o+1))); break;
case 41: removeColumn((int)static_QUType_int.get(_o+1)); break;
case 42: removeColumns((const QMemArray<int>&)*((const QMemArray<int>*)static_QUType_ptr.get(_o+1))); break;
case 43: editCell((int)static_QUType_int.get(_o+1),(int)static_QUType_int.get(_o+2)); break;
case 44: editCell((int)static_QUType_int.get(_o+1),(int)static_QUType_int.get(_o+2),(bool)static_QUType_bool.get(_o+3)); break;
case 45: setRowLabels((const QStringList&)*((const QStringList*)static_QUType_ptr.get(_o+1))); break;
case 46: setColumnLabels((const QStringList&)*((const QStringList*)static_QUType_ptr.get(_o+1))); break;
case 47: columnWidthChanged((int)static_QUType_int.get(_o+1)); break;
case 48: rowHeightChanged((int)static_QUType_int.get(_o+1)); break;
case 49: columnIndexChanged((int)static_QUType_int.get(_o+1),(int)static_QUType_int.get(_o+2),(int)static_QUType_int.get(_o+3)); break;
case 50: rowIndexChanged((int)static_QUType_int.get(_o+1),(int)static_QUType_int.get(_o+2),(int)static_QUType_int.get(_o+3)); break;
case 51: columnClicked((int)static_QUType_int.get(_o+1)); break;
case 52: doAutoScroll(); break;
case 53: doValueChanged(); break;
case 54: updateGeometriesSlot(); break;
default:
return QScrollView::qt_invoke( _id, _o );
}
return TRUE;
}
/*!
*\~english
* Initialisation the widget on form loaded in engine.
*\~russian
* Инициализация виджета при загрузке в форму инжина.
*\~
*/
void
wDBTable::init(aDatabase *adb, aEngine *e )
{
aLog::print(aLog::Debug, tr("wDBTable init in engine "));
// printf("begin init wdbtable\n");
unsigned int countField,i;
aCfgItem o, own;
QString str, ctype;
QStringList lst,lstHead,lstWidth;
int tid;
aWidget *container = NULL;
t_doc = rcIcon( "t_doc.png" );
t_doc_d = rcIcon( "t_doc_d.png" );
t_doc_t = rcIcon( "t_doc_t.png" );
t_doc_m = rcIcon( "t_doc_m.png" );
t_doc_tm = rcIcon( "t_doc_tm.png" );
t_cat_e = rcIcon( "t_cat_e.png" );
t_cat_ed = rcIcon( "t_cat_ed.png" );
t_cat_g = rcIcon( "t_cat_g.png" );
t_cat_gd = rcIcon( "t_cat_gd.png" );
engine = e;
setConfirmDelete(true);
db = adb;
md = &adb->cfg;
tid = property("TableInd").toInt();
container = aWidget::parentContainer( this );
if ( !container )
{
aLog::print(aLog::Error, tr("wDBTable not in Ananas object container "));
return; //printf("!no wDBTable parent container\n");
}
else
{
o = md->objTable( container->getId(), tid );
if ( o.isNull() )
{
//debug_message("Table not found\n");
aLog::print(aLog::Error, tr("wDBTable init meta object not found "));
}
ctype = container->className();
aLog::print(aLog::Info, tr("wDBTable container type is %1 ").arg(ctype));
setContainerType(ctype);
}
//o = md->find(property("TableInd").toInt());
if ( o.isNull() )
{
aLog::print(aLog::Error, tr("wDBTable init meta object not found "));
return;
}
countField = numCols();
for(i=0; i<countField;i++)
{
removeColumn(0);
}
aSQLTable *tbl = NULL;
//printf("ctype = %s\n",( const char *) ctype );
if ( containerType() == "wDocument" )
{
QString flt;
flt = QString("idd=%1").arg(container->uid());
aLog::print(aLog::Info, tr("wDBTable filter is %1 ").arg(flt));
setFilter(flt);
//TODO: fix memory leak
tbl = new aSQLTable( o, adb );
// printf("new table ok\n");
// tbl->first();
}
if ( containerType() == "wCatalogue" ) {
tbl = container->table(); //new aSQLTable( o, adb );
setFilter(QString("idg=0"));
newDataId(0);
tbl->append( Q3SqlFieldInfo("system_icon") );
// tbl->setGenerated( "system_icon", false );
tbl->setCalculated("system_icon", true );
}
if ( containerType() == "wJournal" ) {
tbl = container->table(); //new aSQLTable( o, adb );
tbl->setMode( 0 );
tbl->append( Q3SqlFieldInfo( "system_icon" ) );
// tbl->setGenerated( "system_icon", false );
tbl->setCalculated( "system_icon", true );
// tbl->append( QSqlFieldInfo( "t1" ) );
// tbl->setGenerated( "t1", false );
// tbl->setCalculated("t1", true );
}
refresh();
cur->clear();
setSqlCursor(tbl,true);
refresh(RefreshColumns);
countField = numCols();
lst = property("DefIdList").toStringList();
lstHead = property("DefHeaders").toStringList();
lstWidth = property("ColWidth").toStringList();
for ( i = 0; i < countField; i++ )
{
//remove all columns in wDBTable, not in sql cursor
removeColumn( 0 );
QString s = sqlCursor()->fieldName(i);
// printf(">>>>s = %s\n",s.ascii());
// if(sqlCursor()->isCalculated(s))
// {
// if((s.left(7)=="text_uf" && lst.findIndex(s.mid(7))!=-1) || s == "system_icon")
// {
// continue;
// }
// not calculate field, if is not contents in wDBTable
// sqlCursor()->setCalculated(sqlCursor()->fieldName(i),false);
// }
}
if ( containerType() == "wJournal" ) {
addColumn( "system_icon", "", 20 );
setColumnReadOnly( 0, true );
if (md->objClass(*(container->getMDObject()))==md_journal && !((aDocJournal*) container->dataObject())->type() ) {
// we have common journal
// Insert journal system columns.
addColumn( "ddate", tr("Date"), 100 );
addColumn( "pnum", tr("Prefix"), 200 );
addColumn( "num", tr("Number"), 100 );
}
}
if ( containerType() == "wCatalogue" ) {
addColumn( "system_icon", "", 20 );
// printf("set column ro\n");
setColumnReadOnly( 0, true );
}
if ( containerType() == "wDocument" || containerType() == "wCatalogue" ) {
// Задаем сортировку по индентификатору в обратном порядке для
// табличной части документа
// чтобы при добавлении новых позиций в список строки не скакали
QSqlIndex pk = sqlCursor()->primaryIndex();
pk.setDescending( 0, false);
setSort( pk );
sqlCursor()->select();
sqlCursor()->first();
refresh();
}
//refresh(RefreshColumns);
if (md->objClass(*(container->getMDObject()))!=md_journal || ((aDocJournal*) container->dataObject())->type() ) {
// we have not common journal
for(i=0; i<lst.count();i++)
{
// assemble sql table field names
if ( containerType() == "wJournal" )
{
// str = journalFieldName(lst[i].toLong());
str = "uf"+QString::number(journalFieldId(lst[i].toLong()));
//printf(">>>>>>ss=%s\n",str.ascii());
}
else
{
str = "uf"+lst[i];
}
// add defined fields
addColumn(str,lstHead[i],lstWidth[i].toInt());
}
}
refresh(RefreshAll);
setWFieldEditor();
aLog::print(aLog::Debug, tr("wDBTable init in engine ok"));
}
