QSortFilterProxyModel how to use it in this exampl?

Attachment 10300Attachment 10302
Attachment 10301

hello guys!
i am new here! in this exampl that i found in a Qt book i want to make some changes the exampl shows tow tables in one form.. one is for the partments the other one is for employees.. when the user clicks on the department row it filters and shows the employees that are belongs to that department.. what i want to do now is to make some changes in the code so i want to show the employees in another dialog.. when i dubleclick a row of a department or if that is not posable i have to use pushbutton to show employees of that department in the other dialog.. i do not know where to put the code of QSortFilterProxyModel also dont know what to put in the signals and slot or C++ i am new here sorry for my bad english..


please help thanx :p

Quote:

---

Originally Posted by jaafari

what i want to do now is to make some changes in the code so i want to show the employees in another dialog.. when i dubleclick a row of a department

---

The view has a doubleClicked() signal.
The rest works like with the button for which you've already got a solution in http://www.qtcentre.org/threads/5868...Row-is-Clicked

Quote:

---

Originally Posted by jaafari

i do not know where to put the code of QSortFilterProxyModel

---

Since you move the second table view to the dialog, you also move its model, in this case its model is the filter model.

Cheers,
_

mainform.cpp

Code:

---

departmentModel = new QSqlRelationalTableModel(this);
        departmentModel->setTable("department");
        departmentModel->setRelation(Department_LocationId, QSqlRelation("location", "id", "name"));
        departmentModel->setSort(Department_Name, Qt::AscendingOrder);
        departmentModel->setHeaderData(Department_Name, Qt::Horizontal,
                                       tr("Dept."));
        departmentModel->setHeaderData(Department_LocationId,
                                       Qt::Horizontal, tr("Location"));
        departmentModel->select();
 
departmentView = new QTableView;
        ui->departmentView->setModel(departmentModel);
        ui->departmentView->setSelectionBehavior(QAbstractItemView::SelectRows);
        ui->departmentView->setSelectionMode(QAbstractItemView::SingleSelection);
        ui->departmentView->setEditTriggers(QAbstractItemView::NoEditTriggers);
        //ui->departmentView->setItemDelegate(new QSqlRelationalDelegate(this));
        ui->departmentView->setSelectionMode(QAbstractItemView::SingleSelection);                        
        ui->departmentView->setSelectionBehavior(QAbstractItemView::SelectRows);
        ui->departmentView->setColumnHidden(Department_Id, true);
        ui->departmentView->resizeColumnsToContents();
        ui->departmentView->horizontalHeader()->setStretchLastSection(true);
        ui->departmentView->setCurrentIndex(departmentModel->index(0, 0));
//-------------------------------------------------------
 connect(ui->editButton, SIGNAL(clicked()),
                this, SLOT(editEmployees()));
//--------------------------------------------------------
 
void MainForm::editEmployees()
{
const QModelIndex index = ui->departmentView->currentIndex();
if (index.isValid()) { 
EmployeeForm employeeform(ui->departmentView->model(), index.row(), this);
employeeform.exec();
}
}

---

employeeform.h

Code:

---

class EmployeeForm : public QDialog
{
    Q_OBJECT
 
public:
 explicit EmployeeForm(QAbstractItemModel *model, int row, QWidget *p = 0);
    ~EmployeeForm();

---

employeeform.cpp

Code:

---

employeeModel = new QSqlRelationalTableModel(this);
    employeeModel->setTable("employee");
    employeeModel->setRelation(Employee_DepartmentId,
            QSqlRelation("department", "id", "name"));
    employeeModel->setSort(Employee_Name, Qt::AscendingOrder);
    employeeModel->setHeaderData(Employee_Name, Qt::Horizontal,
                                 tr("Name"));
    employeeModel->setHeaderData(Employee_Extension, Qt::Horizontal,
                                 tr("Ext."));
    employeeModel->setHeaderData(Employee_Email, Qt::Horizontal,
                                 tr("Email"));
 
    employeeProxy= new QSortFilterProxyModel(this);
    employeeProxy->setSourceModel(employeeModel);
    employeeProxy->setFilterCaseSensitivity(Qt::CaseInsensitive);
    employeeProxy->setFilterKeyColumn(-1);
    employeeProxy->setDynamicSortFilter(true);
 
 
 
  employeeView = new QTableView;
    ui->employeeView->setModel(employeeProxy);
   // ui->employeeView->setSelectionMode(QAbstractItemView::SingleSelection);
    ui->employeeView->setSelectionBehavior(QAbstractItemView::SelectRows);
   // ui->employeeView->setEditTriggers(QAbstractItemView::NoEditTriggers);
    ui->employeeView->horizontalHeader()->setStretchLastSection(true);
    ui->employeeView->setColumnHidden(Employee_Id, true);
    ui->employeeView->setColumnHidden(Employee_DepartmentId, true);
    ui->employeeView->setColumnHidden(Employee_StartDate, true);

---

i build and run the the program without any error.. when i click button it closes and shows this--->

Quote:

---

The program has unexpectedly finished.
/pach/../projects/QtProjects/staffmanager exited with code 0

---

any help??
:p:p:p