How to Open a New Dialog when a Row is Clicked..?

[jaafari]

Screenshot from 2014-04-03 20:51:24new.jpg

Hello world!!

i am in new in Qt not only Qt but i am new programing and i come over here to get an answer for my question that is:

i am developing a program with a relationalship until now everything is ok -and- -by Qt- is easy to learn and understand becuase there are a lot of tutorials about everything.. so what i want to do now is.. when i click or select a row in my table then click a button another dialog should be opend and it should display only rows that have the same code in the column.. any idea please?

[ChrisW67]

Connect your edit button clicked() signal to a slot. In the slot get the currentIndex() of the view, which tells you which row the table's current cell is in. (You could also use the view's selection if it allows only one row). You then use that to access the data from your model for your dialog.

[jaafari]

Hello!

connect(ui->editButton, SIGNAL(clicked()), this, SLOT(editDel()));

connect(ui->editButton, SIGNAL(clicked()), this, SLOT(editDel()));

To copy to clipboard, switch view to plain text mode 

void MyForm::editDel()
{
//code:
}

void MyForm::editDel()
{
//code:
}

To copy to clipboard, switch view to plain text mode 

my friend thanks for repling... as i said i am new to programing langouages can you please tell me what to do and explain the code.. thanx

[ChrisW67]

It depends quite a bit on what the dialog should do. Here is the sort of thing I meant:

void MyForm::editDel()
{
  const QModelIndex index = ui->tableView->currentIndex();
  if (index.isValid()) {  // i.e. there is a current index
    MyDialog dialog(ui->tableView->model(), index.row(), this);
    dialog.exec();
  }
}

void MyForm::editDel()
{
  const QModelIndex index = ui->tableView->currentIndex();
  if (index.isValid()) {  // i.e. there is a current index
    MyDialog dialog(ui->tableView->model(), index.row(), this);
    dialog.exec();
  }
}

To copy to clipboard, switch view to plain text mode 

where I assumed a customised, single purpose dialog that takes a model and row at construction. That is, its constructor looks like:

class MyDialog: public QDialog 
{
  Q_OBJECT
public:
  MyDialog(QAbstractItemModel *model, int row, QWidget *p = 0);
...
};

class MyDialog: public QDialog 
{
  Q_OBJECT
public:
  MyDialog(QAbstractItemModel *model, int row, QWidget *p = 0);
...
};

To copy to clipboard, switch view to plain text mode 

[jaafari]

Hello!

i actually added the code to my forms but i do not know what should be changed.. so i got errors..

please help thanks

---

Added after 17 minutes:

should i put all the code?

[jaafari]

can anyone give me an exampl how to do that in both cpp files & h files ....please help

[ChrisW67]

You already have an example for launching a dialog. If you want to display the same model but filter the rows to show only those containing a certain value then you can use QSortFilterProxyModel on top of the main model.

[jaafari]

My Code:


cpp.file

Deliveries::Deliveries(QWidget *parent) :
    QDialog(parent),
    ui(new Ui::Deliveries)
{
 
ui->setupUi(this);
 
//-------------- connection settings-------------
 Login conn;
                if(!conn.connOpen())
                    ui->label_deliveries_statut->setText("Failed to open the database");
                    else
                    ui->label_deliveries_statut->setText("Connected....");
//-------------- connection settings-------------
 
 deliveryModel = new QSqlRelationalTableModel(this);
        deliveryModel->setTable("deliveries");
        deliveryModel->select();
 
        deliveryModel->setRelation(deliveryModel->fieldIndex("supplierid"),     QSqlRelation("suppliers","id","name"));
        deliveryModel->setRelation(deliveryModel->fieldIndex("productid"),      QSqlRelation("products","id","name"));
        deliveryModel->setRelation(deliveryModel->fieldIndex("tva"),            QSqlRelation("tva","unity","type"));
        deliveryModel->setRelation(deliveryModel->fieldIndex("departmentid"),   QSqlRelation("department","id","name"));
        deliveryModel->setRelation(deliveryModel->fieldIndex("deliverycodeid"), QSqlRelation("deliverycode","id","code"));
 
        deliveryModel->setEditStrategy(QSqlRelationalTableModel::OnManualSubmit);
 
 
 
 ui->deliveryView->setModel(deliveryModel);
 
          ui->deliveryView->setItemDelegate(new QSqlRelationalDelegate(this));
          ui->deliveryView->setAlternatingRowColors(true);
          ui->deliveryView->setCornerButtonEnabled(true);
 
          ui->deliveryView->setSelectionMode(QAbstractItemView::SingleSelection);
           ui->deliveryView->setSelectionBehavior(QAbstractItemView::SelectRows);
           ui->deliveryView->setSortingEnabled(true);
           ui->deliveryView->setEditTriggers(QAbstractItemView::NoEditTriggers);
         ui->deliveryView->horizontalHeader()->setStretchLastSection(true);
           ui->deliveryView->resizeColumnsToContents();
          ui->deliveryView->setCurrentIndex(deliveryModel->index(0, 0));
 
           ui->deliveryView->setColumnHidden(0/*Deliveries_Id*/, true);
 
 
           connect(ui->editButton, SIGNAL(clicked()), this, SLOT(editDel()));
 
}
 
Deliveries::~Deliveries()
{
    delete ui;
}
 
void Deliveries::editDel()
{
const QModelIndex index = ui->deliveryView->currentIndex();
if (index.isValid()) { // i.e. there is a current index
Dialog dialog(ui->deliveryView->deliveryModel(), index.row(), this);
dialog.exec();
}
}

Deliveries::Deliveries(QWidget *parent) :
    QDialog(parent),
    ui(new Ui::Deliveries)
{

ui->setupUi(this);

//-------------- connection settings-------------
 Login conn;
                if(!conn.connOpen())
                    ui->label_deliveries_statut->setText("Failed to open the database");
                    else
                    ui->label_deliveries_statut->setText("Connected....");
//-------------- connection settings-------------

 deliveryModel = new QSqlRelationalTableModel(this);
        deliveryModel->setTable("deliveries");
        deliveryModel->select();

        deliveryModel->setRelation(deliveryModel->fieldIndex("supplierid"),     QSqlRelation("suppliers","id","name"));
        deliveryModel->setRelation(deliveryModel->fieldIndex("productid"),      QSqlRelation("products","id","name"));
        deliveryModel->setRelation(deliveryModel->fieldIndex("tva"),            QSqlRelation("tva","unity","type"));
        deliveryModel->setRelation(deliveryModel->fieldIndex("departmentid"),   QSqlRelation("department","id","name"));
        deliveryModel->setRelation(deliveryModel->fieldIndex("deliverycodeid"), QSqlRelation("deliverycode","id","code"));

        deliveryModel->setEditStrategy(QSqlRelationalTableModel::OnManualSubmit);



 ui->deliveryView->setModel(deliveryModel);
        
          ui->deliveryView->setItemDelegate(new QSqlRelationalDelegate(this));
          ui->deliveryView->setAlternatingRowColors(true);
          ui->deliveryView->setCornerButtonEnabled(true);

          ui->deliveryView->setSelectionMode(QAbstractItemView::SingleSelection);
           ui->deliveryView->setSelectionBehavior(QAbstractItemView::SelectRows);
           ui->deliveryView->setSortingEnabled(true);
           ui->deliveryView->setEditTriggers(QAbstractItemView::NoEditTriggers);
         ui->deliveryView->horizontalHeader()->setStretchLastSection(true);
           ui->deliveryView->resizeColumnsToContents();
          ui->deliveryView->setCurrentIndex(deliveryModel->index(0, 0));

           ui->deliveryView->setColumnHidden(0/*Deliveries_Id*/, true);
           

           connect(ui->editButton, SIGNAL(clicked()), this, SLOT(editDel()));

}

Deliveries::~Deliveries()
{
    delete ui;
}

void Deliveries::editDel()
{
const QModelIndex index = ui->deliveryView->currentIndex();
if (index.isValid()) { // i.e. there is a current index
Dialog dialog(ui->deliveryView->deliveryModel(), index.row(), this);
dialog.exec();
}
}

To copy to clipboard, switch view to plain text mode 

header.file

namespace Ui {
class Deliveries;
 
}
 
class Deliveries : public QDialog
{
    Q_OBJECT
 
public:
    explicit Deliveries(QWidget *parent = 0);
    ~Deliveries();
private slots:
    void updateDel();
 
private:
    Ui::Deliveries *ui;
 
 
    QSqlRelationalTableModel *deliveryModel;
 
};
 
#endif // DELIVERIES_H

namespace Ui {
class Deliveries;

}

class Deliveries : public QDialog
{
    Q_OBJECT
    
public:
    explicit Deliveries(QWidget *parent = 0);
    ~Deliveries();
private slots:
    void updateDel();
   
private:
    Ui::Deliveries *ui;

   
    QSqlRelationalTableModel *deliveryModel;
  
};

#endif // DELIVERIES_H

To copy to clipboard, switch view to plain text mode 

i do not know what next...

[jaafari]

where should i use QSortFilterProxyModel in my dialog.cpp or in myForm.cpp ??

[ChrisW67]

Assuming the Dialog displays everything in the model you pass it, you want to filter that before you give it to the Dialog constructor. Create a QSortFilterProxyModel, set its filter, and pas that to the Dialog.