Master/detail presentation

[cia.michele]

Happy new Year to everybody!
Thanks a lot Numbat for your solution! It's exactly what I want obtain. But I've yet a question: I see in this example it is used some for loop and strings to fill the columns... how I can link the view to a gerarchical model? (I think to QSQLRelationalModel)
By this, I'll have an indipendent widget that I can simply put on my form ad use it simply passing on it the model of my data.

Thanks for your help!

I'll show you, if you want how I'll use this.

Michele

[cia.michele]

Goodmorning to all.
I'm working with the example of numbat (thanks a lot for this!) it's exaclty what I need!! But... working on it I've see this example use string constants to populate two level grid and all the sistem of "frozen column" is based over a single model.

I've this problem now: I'd like to use this view with an SQL model. The most simple way is read all row and column of two QSqlTableModel (one for the first level and one for the second level) and set the strings into the treeview (using the tecnic showed by numbat), but i'd like to make something better.

I'd like to create an SQL model then inglobe the two different Role and in which every item has different parent if need. I'd like to create ad QSqlTreeModel or something like this.

I try to do this but my experience on QT is non enought and I loose myself.

Does anybody any ideas of how can I create a model the can populate the grid? I thought to pass two tables and two fields to something like "select()" method of QSqlTableModel and use it as base... but I don't know which this cause.

Have you got any ideas and some time to try to create it togheter?

Thanks a lot for your time!

Michele

[cia.michele]

I've resolve the question adding a method that implements the code of the numbat's example:

void HGrid::setMasterSlaveModel(QSqlTableModel *master, QSqlTableModel *slave, QString fieldmaster, QString fieldslave)
{
    // Our master can have any number of columns.
     QStandardItemModel * m = new QStandardItemModel();
     QStandardItem *parentItem = m->invisibleRootItem();
 
  //Scorro il model principale per riga
     for (int i=0; i< master->rowCount();i++){
 
         //Leggo il record corrente del model
         QSqlRecord rec = master->record(i);
         //Creo una lista di colonne
         QList<QStandardItem*> colsFatt;
 
         //Scorro tutte le colonne
         for (int j=0; j<master->columnCount();++j){
 
             //Aggiungo i dati delle colonne alla lista
             colsFatt.push_back(new QStandardItem(rec.value(j).toString()));
         }
 
         //Aggiungo la lista dei dati delle colonne al model
         parentItem->appendRow(colsFatt);
 
         //Creo un elemento fittizio per aggiungere i dati di secondo livello
         QStandardItem * ph = new QStandardItem( "Placeholder");
         colsFatt.at(0)->appendRow(ph);
         ph->setFlags(Qt::NoItemFlags);
 
         QStandardItemModel * m2 = new QStandardItemModel;
         slave->setFilter(QString("%1=%2").arg(fieldslave).arg(rec.value(fieldmaster).toInt()));
         for (int k = 0; k < slave->rowCount(); k++)
         {
             QList<QStandardItem*> colsDett;
             QSqlRecord recDett = slave->record(k);
             for (int x = 0; x < slave->columnCount(); ++x)
             {
                 colsDett.push_back(new QStandardItem(recDett.value(x).toString()));
             }
             m2->invisibleRootItem()->appendRow(colsDett);
         }
         m->setData(ph->index(), QVariant(QMetaType::type("QAbstractItemModel*"), &m2), ChildModelRole);
    }
 
    this->setModel(m);
}

void HGrid::setMasterSlaveModel(QSqlTableModel *master, QSqlTableModel *slave, QString fieldmaster, QString fieldslave)
{
    // Our master can have any number of columns.
     QStandardItemModel * m = new QStandardItemModel();
     QStandardItem *parentItem = m->invisibleRootItem();

  //Scorro il model principale per riga
     for (int i=0; i< master->rowCount();i++){

         //Leggo il record corrente del model
         QSqlRecord rec = master->record(i);
         //Creo una lista di colonne
         QList<QStandardItem*> colsFatt;

         //Scorro tutte le colonne
         for (int j=0; j<master->columnCount();++j){

             //Aggiungo i dati delle colonne alla lista
             colsFatt.push_back(new QStandardItem(rec.value(j).toString()));
         }

         //Aggiungo la lista dei dati delle colonne al model
         parentItem->appendRow(colsFatt);

         //Creo un elemento fittizio per aggiungere i dati di secondo livello
         QStandardItem * ph = new QStandardItem( "Placeholder");
         colsFatt.at(0)->appendRow(ph);
         ph->setFlags(Qt::NoItemFlags);

         QStandardItemModel * m2 = new QStandardItemModel;
         slave->setFilter(QString("%1=%2").arg(fieldslave).arg(rec.value(fieldmaster).toInt()));
         for (int k = 0; k < slave->rowCount(); k++)
         {
             QList<QStandardItem*> colsDett;
             QSqlRecord recDett = slave->record(k);
             for (int x = 0; x < slave->columnCount(); ++x)
             {
                 colsDett.push_back(new QStandardItem(recDett.value(x).toString()));
             }
             m2->invisibleRootItem()->appendRow(colsDett);
         }
         m->setData(ph->index(), QVariant(QMetaType::type("QAbstractItemModel*"), &m2), ChildModelRole);
    }

    this->setModel(m);
}

To copy to clipboard, switch view to plain text mode 

But I don't like it so much. Is there any smarter solution? Have you got any ideas?

Thanks a lot for your time.

Michele

[cia.michele]

And, with this structure, how can I show images on the first column (of both the QTreeView). One image for the items of firts level (first QTreeview) and an other for the items of internal QTreeview (second level).

Have you got any idea?

Thank a lot for your time

Michele