Russian Qt Forum

CREATE TABLE anketa
(
  id bigserial NOT NULL,
  productid integer,
  serialnumber text,
  firstname text,
  lastname text,
  email text,
  phone text,
  dilerid integer,
  credate timestamp without time zone,
  "version" text,
  "comment" text,
  validdate date,
  ordern text,
  activateevery integer DEFAULT 0,
  company text,
  CONSTRAINT fkdid FOREIGN KEY (dilerid)
      REFERENCES diler (id) MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE NO ACTION,
  CONSTRAINT fkproductid FOREIGN KEY (productid)
      REFERENCES product (id) MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE NO ACTION
)
WITH (
  OIDS=FALSE
);






CREATE TABLE product
(
  "name" text NOT NULL,
  "comment" text,
  id serial NOT NULL,
  CONSTRAINT id PRIMARY KEY (id)
)
WITH (
  OIDS=FALSE
);





CREATE TABLE diler
(
  id bigserial NOT NULL,
  "name" text,
  "comment" text,
  CONSTRAINT dilerid PRIMARY KEY (id)
)
WITH (
  OIDS=FALSE
);

    editAnketaModel->setTable("anketa");
    //берем только нашу анкету
    editAnketaModel->setFilter("anketa.id ="+QString::number(anketaid));
    editAnketaModel->setRelation(editAnketaModel->fieldIndex("productid"),QSqlRelation("product","id","name"));
    editAnketaModel->setRelation(editAnketaModel->fieldIndex("dilerid"),QSqlRelation("diler","id","name"));
    // editAnketaModel->setHeaderData(7,Qt::Horizontal,"diler");
    editAnketaModel->select();
    ui->tableView->setModel(editAnketaModel);
    //создаем модель продукта
    QSqlTableModel   *productRelationModel=editAnketaModel->relationModel(1);
    ui->EditProductProduct->setModel(productRelationModel);
    ui->EditProductProduct->setModelColumn(productRelationModel->fieldIndex("name"));
    
    
    //создаем  модель партнера
    QSqlTableModel   *dilerRelationModel=editAnketaModel->relationModel(7);
    ui->EditProductDiler->setModel(dilerRelationModel);
    ui->EditProductDiler->setModelColumn(dilerRelationModel->fieldIndex("name"));
    
    
    
    
    
    mapper->setSubmitPolicy(QDataWidgetMapper::AutoSubmit);
    mapper->setModel(editAnketaModel);
    mapper->setItemDelegate( new QSqlRelationalDelegate(this));
    
    mapper->addMapping(ui->EditProductProduct,1);
    mapper->addMapping(ui->EditProductDiler,7);
    
    mapper->addMapping(ui->EditProductSerial,2);
    mapper->addMapping(ui->EditProductFirstname,3);
    mapper->addMapping(ui->EditProductLastName,4);
    mapper->addMapping(ui->EditProductEmail,5);
    mapper->addMapping(ui->EditProductPhone,6);
    
    mapper->addMapping(ui->EditProductVersion,9);
    mapper->addMapping(ui->EditProductComment,10);
    mapper->addMapping(ui->EditProductValidDate,11);
    mapper->addMapping(ui->EditProductOrder,12);
    mapper->addMapping(ui->EditProductActEvery,13);
    mapper->addMapping(ui->EditProductCompany,14);
    
    mapper->setCurrentIndex(0);