void PringKvitok::SetDb(db *mdb) { myDB = mdb; ui->comboBox_groups->addItem("Выбрать все", "s_all"); ui->comboBox_groups->addItem("Снять все", "d_all"); QSqlQueryModel *groups = myDB->Query("SELECT * FROM groups WHERE id > 2"); for(int i = 0; i < groups->rowCount(); i++){ ui->comboBox_groups->addItem(groups->record(i).value("name").toString(), groups->record(i).value("id").toString()); } childsCheckBox_map.clear(); QString sql = "SELECT t0.id, t0.group_id, t0.fio, t1.name AS group_name, t0.ls FROM childs t0"; sql += " LEFT OUTER JOIN groups t1 ON t0.group_id = t1.id"; QSqlQueryModel *childs = myDB->Query(sql); for(int i = 0; i < childs->rowCount(); i++){ QString childs_id = childs->record(i).value("id").toString(); ui->tW->insertRow(ui->tW->rowCount()); ui->tW->setItem(ui->tW->rowCount() - 1, 1,new QTableWidgetItem(childs->record(i).value("fio").toString())); ui->tW->setItem(ui->tW->rowCount() - 1, 2,new QTableWidgetItem(childs->record(i).value("group_name").toString())); ui->tW->setItem(ui->tW->rowCount() - 1, 3,new QTableWidgetItem(childs_id)); ui->tW->setItem(ui->tW->rowCount() - 1, 4,new QTableWidgetItem(childs->record(i).value("group_id").toString())); ui->tW->setItem(ui->tW->rowCount() - 1, 5,new QTableWidgetItem(childs->record(i).value("ls").toString())); QCheckBox *cb = new QCheckBox(); cb->setText(childs_id); connect(cb , SIGNAL( toggled(bool) ), this, SLOT( on_childs_toggled(bool)) ); childsCheckBox_map[childs_id] = cb; ui->tW->setCellWidget(ui->tW->rowCount() - 1, 0, cb); } delete groups; delete childs; }
void mantenimientoTitulo::on_btmBuscar_clicked() { if(m_ui->btmTitulo->isChecked()) { QSqlQueryModel *model = new QSqlQueryModel(m_ui->titulos); model->setQuery("SELECT tituloObra, isbn FROM titulo WHERE tituloObra LIKE '%"+m_ui->busqueda->text()+"%';", QSqlDatabase::database("sibcues")); if (model->lastError().isValid()) qDebug() << model->lastError(); model->setHeaderData(0, Qt::Horizontal, QObject::tr("Titulo Material Bibliografico")); model->setHeaderData(1, Qt::Horizontal, QObject::tr("ISBN")); m_ui->titulos->setModel(model); connect(m_ui->titulos->selectionModel(), SIGNAL(currentRowChanged(QModelIndex,QModelIndex)), this, SLOT(on_titulos_activated(QModelIndex))); m_ui->labelTitulo->setText("Titulos: "+QString::number(model->rowCount())+" resultados."); } else { QSqlQueryModel *model = new QSqlQueryModel(m_ui->titulos); model->setQuery("SELECT titulo.tituloObra, titulo.isbn FROM obrade left join titulo on titulo.idTitulo=obrade.idTitulo left join autor on obrade.idAutor=autor.idAutor WHERE autor.nombreAutor LIKE '%"+m_ui->busqueda->text()+"%';", QSqlDatabase::database("sibcues")); if (model->lastError().isValid()) qDebug() << model->lastError(); model->setHeaderData(0, Qt::Horizontal, QObject::tr("Titulo Material Bibliografico")); model->setHeaderData(1, Qt::Horizontal, QObject::tr("ISBN")); m_ui->titulos->setModel(model); connect(m_ui->titulos->selectionModel(), SIGNAL(currentRowChanged(QModelIndex,QModelIndex)), this, SLOT(on_titulos_activated(QModelIndex))); m_ui->labelTitulo->setText("Titulos: "+QString::number(model->rowCount())+" resultados."); } }
/*! qso number sent for last qso in log */ int Log::lastNr() const { QSqlQueryModel m; #if QT_VERSION < 0x050000 m.setQuery("SELECT * FROM log where valid='true'", db); #else m.setQuery("SELECT * FROM log where valid=1", db); #endif while (m.canFetchMore()) { m.fetchMore(); } if (m.rowCount()) { QByteArray snt[MAX_EXCH_FIELDS]; snt[0] = m.record(m.rowCount() - 1).value(SQL_COL_SNT1).toByteArray(); snt[1] = m.record(m.rowCount() - 1).value(SQL_COL_SNT2).toByteArray(); snt[2] = m.record(m.rowCount() - 1).value(SQL_COL_SNT3).toByteArray(); snt[3] = m.record(m.rowCount() - 1).value(SQL_COL_SNT4).toByteArray(); bool ok = false; int nr = snt[nrField].toInt(&ok, 10); if (!ok) nr = 0; return(nr); } else { return(0); } }
ServiceBlock::ServiceBlock(int idC, QWidget *parent) : QDialog(parent), idCar(idC), ui(new Ui::ServiceBlock) { ui->setupUi(this); setCalendarColor(ui->deBegin->calendarWidget(),QColor(255,140,0)); setCalendarColor(ui->deEnd->calendarWidget(),QColor(255,140,0)); setCalendarColor(ui->deEvent->calendarWidget(),QColor(255,140,0)); setCalendarColor(ui->deGuarantee->calendarWidget(),QColor(255,140,0)); QSqlQueryModel * windTitle = new QSqlQueryModel(this); windTitle->setQuery(QString("SELECT Brand, Model, LicensePlate FROM car WHERE idCar = %1").arg(idCar)); this->setWindowTitle( QString("Naprawy - ") + windTitle->data(windTitle->index(windTitle->rowCount()-1,0)).toString() + QString(" ") + windTitle->data(windTitle->index(windTitle->rowCount()-1,1)).toString() + QString(" - ") + windTitle->data(windTitle->index(windTitle->rowCount()-1,2)).toString() ); connect(this,SIGNAL(saved()),this,SLOT(updateView()),Qt::DirectConnection); connect(this,SIGNAL(deleted()),this,SLOT(updateView())); // fill category combobox QStringList categoryList({QString("Silnik"),QString("Zawieszenie"),QString("Elektronika"), QString("Elektryka"),QString("Układ napędowy"),QString("Układ hamulcowy"), QString("Układ kierowniczy"),QString("Nadwozie")}); ui->cbCategory->addItems(categoryList); updateView(); isOpen = true; }
void DataBank::tableLoad(struct Table0 *t,unsigned int i) { QString name = "table"; name.append(QString::number(i ,10)); QString sql = QString("select * from '%1'").arg(name); if(!database.open()){ qDebug()<<"database database is error"; }else{ qDebug()<<"database database is ok"; } QSqlQueryModel model; model.setQuery(sql,database); for(int i = 0; i < model.rowCount(); ++i){ t->Nummber[i] = model.record(i).value("number").toInt(); t->Shendu[i] = model.record(i).value("shendu").toLongLong(); t->Jixing[i] = model.record(i).value("jixing").toInt(); t->Dianliu[i] = model.record(i).value("dianliu").toInt(); t->Maikuan[i] = model.record(i).value("maikuan").toInt(); t->Xiuzhi[i] = model.record(i).value("xiuzhi").toInt(); t->Jianxi[i] = model.record(i).value("jianxi").toInt(); t->Sudu[i] = model.record(i).value("sudu").toInt(); t->Shenggao[i] = model.record(i).value("shenggao").toInt(); t->Gongshi[i] = model.record(i).value("gongshi").toInt(); t->LV[i] = model.record(i).value("lv").toInt(); t->Gaoya[i] = model.record(i).value("gaoya").toInt(); t->PPP[i] = model.record(i).value("ppp").toInt(); t->WCLC[i] = model.record(i).value("wclc").toInt(); } database.close(); }
void Calendar::addEvent() { EventDialog dialog(this); dialog.setModal(true); if(dialog.exec() == QDialog::Accepted) { Event tmpEvent = dialog.getEvent(); qDebug() << tmpEvent.name(); if((!tmpEvent.name().isEmpty()) || (!tmpEvent.description().isEmpty())) { QSqlQueryModel check; check.setQuery("SELECT * FROM events WHERE date_time='" + tmpEvent.dateTime().toString(m_dateFormat) + "'", m_db); if(check.rowCount() == 0) { QSqlQuery insertion(m_db); insertion.prepare("INSERT INTO events(name, description, date_time) VALUES" "(?,?,?)"); insertion.addBindValue(tmpEvent.name()); insertion.addBindValue(tmpEvent.description()); insertion.addBindValue(tmpEvent.dateTime().toString(m_dateFormat)); insertion.exec(); qDebug() << "Pushed"; m_sqlTableModel->select(); } else { //Item with this date already exists QMessageBox::warning(this, tr("Calendar"), tr("Item with this date and time already exists.")); } } } }
void AdminPatients::on_pushButton_update_clicked() { QSqlQueryModel * model = new QSqlQueryModel(); QSqlQuery * qry = new QSqlQuery(mydb); qry->prepare("select name,surname from patients"); qry->exec(); model->setQuery(*qry); ui->tableView->setModel(model); QSqlQuery * qry1 = new QSqlQuery(mydb); QSqlQueryModel * model1 = new QSqlQueryModel(); qry1->prepare("select name, surname from patients where doctor is null "); qry1->exec(); model1->setQuery(*qry1); ui->tableView_noDoc->setModel(model1); QSqlQuery * qry2 = new QSqlQuery(mydb); QSqlQueryModel * model2 = new QSqlQueryModel(); qry2->prepare("select name, surname,doctor from patients where diagnose is null"); qry2->exec(); model2->setQuery(*qry2); ui->tableView_noDiag->setModel(model2); qDebug()<<(model->rowCount()); }
mantenimientoTitulo::mantenimientoTitulo(int idUnidad, QWidget *parent) : QDialog(parent), m_ui(new Ui::mantenimientoTitulo) { m_ui->setupUi(this); m_ui->btmTitulo->setChecked(true); Persistencia::Persistencia *servicioPersistencia=new Persistencia(idUnidad); QSqlQueryModel *model = new QSqlQueryModel(m_ui->titulos); model->setQuery("SELECT tituloObra, isbn FROM titulo;", QSqlDatabase::database("sibcues")); if (model->lastError().isValid()) qDebug() << model->lastError(); //model->setTable("titulo"); //model->select(); model->setHeaderData(0, Qt::Horizontal, QObject::tr("Titulo Material Bibliografico")); model->setHeaderData(1, Qt::Horizontal, QObject::tr("ISBN")); m_ui->titulos->setModel(model); m_ui->titulos->alternatingRowColors(); //m_ui->titulos->hideColumn(0); m_ui->titulos->horizontalHeader()->resizeSection(0, 350); m_ui->titulos->setSelectionMode(QAbstractItemView::SingleSelection); connect(m_ui->titulos->selectionModel(), SIGNAL(currentRowChanged(QModelIndex,QModelIndex)), this, SLOT(on_titulos_activated(QModelIndex))); m_ui->labelTitulo->setText("Titulos: "+QString::number(model->rowCount())+" resultados."); }
QSqlQueryModel * LazyWord::GetLibModel() //Get the Date which the user want to show by degree selected { GetSelect GS; //more see about class GetSelect int FS = GS.Select(show_StrangeBox->isChecked(),show_UnderstandBox->isChecked(),show_MasterBox->isChecked() ,show_AllBox->isChecked()); //qDebug("FO = %d,IO = %d",FS,IO); QSqlQueryModel * LibModel = new QSqlQueryModel; QString model = "select * from "; if( FS-4<=0 ) { if( FS-4!=0) { model = model + WordLibBox->currentText() + " where Familiar =" + QString::number(FS); } else { model = model + WordLibBox->currentText(); } } else { model = model + WordLibBox->currentText() + " where Familiar !=" + QString::number(FS-4); } LibModel->setQuery(model); CheckEnd = LibModel->rowCount(); return LibModel; }
bool DataBank::checkExists(unsigned int i) { bool bit = false; bool ok = false; if(!database.open()){ qDebug()<<"database database is error"; }else{ qDebug()<<"database database is ok"; } /*查询数据库中的所有表名*/ QSqlQueryModel model; model.setQuery("select name from sqlite_master where type='table'",database); for(int j = 0; j < model.rowCount(); ++j){ QString name = model.record(j).value("name").toString(); if((unsigned int)name.mid(5,2).toInt(&ok ,10) == i){ bit = true; } } database.close(); return bit; }
QVector<InternalPaymentItem *> ClinicInternalPayment::selectFromDB(QDate startDate, QDate endDate) { QVector<InternalPaymentItem *> result; if(myDB::connectDB()) { QString strClumn = "ChinicReceipt"; QVector<QString> Receipt = getDistinctFromDB(strClumn , strClinicChargeDetails); QSqlQueryModel *sqlModel = new QSqlTableModel; for(int i=0;i<Receipt.size();i++) { InternalPaymentItem *item = new InternalPaymentItem; item->m_strName = Receipt.at(i); QString startTime = startDate.toString("yyyy-MM-dd") + "T00:00:00"; QString endTime = endDate.toString("yyyy-MM-dd") + "T23:59:59"; sqlModel->setQuery("Select * from " + strClinicChargeDetails + " where "+ strClumn + "= \'" + item->m_strName + "\' and chargeid in (select id from cliniccharge where time between \'" + startTime + "\' and \'" + endTime + "\')"); for(int j = 0;j<sqlModel->rowCount();j++) { int nCount = sqlModel->record(j).value("ChargeItemCount").toInt(); double nPrice = sqlModel->record(j).value("ChargeItemPrice").toDouble(); item->m_dDueIncome += nCount*nPrice; } result.append(item); } } return result; }
void DetalleCompraVenta::populateCerealField() { QSqlQueryModel cereal; cereal.setQuery("SELECT cereal,id FROM cereales"); for(int i=0; i < cereal.rowCount(); i++) { //ui->grano->addItem( cereal.data(cereal.index(i,0)).toString(), QVariant( cereal.data(cereal.index(i,1)).toInt())); } }
MainWindow::MainWindow(QWidget *parent) : QMainWindow(parent), ui(new Ui::MainWindow) { ui->setupUi(this); // подключаемся к БД QSqlDatabase db = QSqlDatabase::addDatabase("QPSQL"); db.setHostName("localhost"); db.setDatabaseName("postgres"); db.setUserName("postgres"); db.setPassword("12321"); if(!db.open()) { QMessageBox::critical( this, tr("Ошибка подключения к БД"), tr("Не удалось подключиться к БД.\n") + db.lastError().text() ); return; } else QMessageBox::information( this, tr("Всё огонь"), tr("Успешное подключение к БД.") ); // создаём модель запроса и выполняем его в ней QSqlQueryModel *model = new QSqlQueryModel; // запрашиваем имена полей таблицы model->setQuery("SELECT column_name FROM information_schema.columns " "WHERE information_schema.columns.table_name = " "'ВАША_ТАБЛИЦА';"); // создаём модель для комбо-бокса по числу строк из модели запроса QStandardItemModel *model4combo = new QStandardItemModel(model->rowCount(), 1, this); // переносим данные из модели запроса в модель для комбо-бокса QModelIndex index; // индекс для навигации по модели запроса for (int i = 0; i < model4combo->rowCount(); i++) { index = model->index(i, 0, QModelIndex()); // создаём элемент для добавления в модель комбо-бокса QStandardItem* item = new QStandardItem(model->data(index).toString()); // расставляем флаги, чтобы каждый элемент модели бы чекуемым item->setFlags(Qt::ItemIsUserCheckable | Qt::ItemIsEnabled); item->setData(Qt::Checked, Qt::CheckStateRole); // добавляем элемент в модель для комбо-бокса model4combo->setItem(i, 0, item); } // назначаем комбо-боксу нашу модель ui->comboBox->setModel(model4combo); }
void DetalleCompraVenta::populateClienteField() { QSqlQueryModel cliente; cliente.setQuery ("SELECT nombre,cuit FROM cliente ORDER BY nombre"); for(int i=0; i < cliente.rowCount(); i++) { ui->cliente->addItem( cliente.data(cliente.index(i,0)).toString(), QVariant( cliente.data(cliente.index(i,1)).toDouble())); } }
Manager::Manager(QWidget *parent) : QMainWindow(parent), ui(new Ui::Manager) { ui->setupUi(this); progressBar = new QProgressBar(ui->statusbar); progressBar->setMaximumSize(250,40); ui->statusbar->addPermanentWidget(progressBar); setTabOrder(ui->lineEdit_band_name, ui->lineEdit_Album); setTabOrder(ui->lineEdit_Album, ui->lineEdit_price_min); setTabOrder(ui->lineEdit_price_min, ui->lineEdit_price_max); Database conn; QSqlQueryModel * model = new QSqlQueryModel(); conn.connOpen("Inventory"); QSqlQuery * qry = new QSqlQuery(conn.mydb); qry->prepare("SELECT * from Inventory"); qry->exec(); while(qry->next()) { newCatNum = qry->value(12).toInt(); } ++newCatNum; model->setQuery(*qry); ui->tableView_Master->setModel(model); Database conn1; conn1.connOpen("Inventory"); QSqlQuery * qry1 = new QSqlQuery(conn1.mydb); ui->comboBox_Type->addItem("Select a Type"); qry1->prepare("SELECT DISTINCT Type from Inventory"); qry1->exec(); while(qry1->next()) { ui->comboBox_Type->addItem(qry1->value(0).toString()); } QModelIndex index = ui->comboBox_Type->model()->index(0, 0); QVariant v(0); ui->comboBox_Type->model()->setData(index, v, Qt::UserRole - 1); conn.connClose(); conn1.connClose(); qDebug() << (model->rowCount()); }
void SingleWeatherParamWidget::onAirportChanged(QString apCode, QString pName){ //清空 QList<int> keyList = editHash.keys(); for(int key : keyList){ QList<QLineEdit *> editList = editHash[key]; for(QLineEdit *edit : editList){ edit->setText(""); } } //赋值 currentApCode = apCode; currentPName = pName; weatherParamSetupList.clear(); QString queryStr = QString("select * from weatherparamsetup where code = '%1' and planename = '%2' order by paramid") .arg(currentApCode) .arg(currentPName); QSqlQueryModel *plainModel = pgDb->queryModel(queryStr); int rowCount = plainModel->rowCount(); for(int i = 0;i < rowCount;i++){ WeatherParamSetup weatherParamSetup; weatherParamSetup.setCode(plainModel->record(i).value(0).toString()); weatherParamSetup.setPlaneName(plainModel->record(i).value(1).toString()); weatherParamSetup.setParamid(plainModel->record(i).value(2).toInt()); weatherParamSetup.setLimits(plainModel->record(i).value(3).toString()); bool isExist = false; for(WeatherParam weatherParam : weatherParamList){ if(weatherParam.id() == weatherParamSetup.paramid()){ isExist = true; break; } } if(isExist){ weatherParamSetupList.append(weatherParamSetup); } } delete plainModel; for(WeatherParamSetup weatherParamSetup : weatherParamSetupList){ int key = weatherParamSetup.paramid(); QString limitJson = weatherParamSetup.limits(); QList<QString> valueList = this->getDataFromJson(limitJson); QList<QLineEdit *> editList = editHash[key]; int valueCount = valueList.count(); int editCount = editList.count(); for(int i = 0;i < editCount;i++){ QLineEdit *edit = editList[i]; if(valueCount != editCount){ edit->setText(""); }else{ edit->setText(valueList[i]); } } } }
/** Chequea si existe un contrato de compra asociada al cliente para la carga realizada **/ bool AgregarCarga::chequearCompra(qlonglong cliente, int grano) { QSqlQueryModel compras; QString query = "SELECT * FROM compras WHERE cliente= " + QString::number(cliente) + " AND kilosconcretados-kilosentregados > 0 AND tipocereal = " + QString::number(grano); compras.setQuery(query); if(compras.rowCount() > 0) return true; else return false; }
AdminPatients::AdminPatients(QWidget *parent) : QDialog(parent), ui(new Ui::AdminPatients) { ui->setupUi(this); mydb = QSqlDatabase::addDatabase("QSQLITE"); mydb.setDatabaseName("F:/Documents/GitHub/KPIrepository/courses/prog_base_3/project/ClinicsManagementSystem/logininfo.db"); if(! mydb.open()) QMessageBox::information(this, tr("oops"),"Failed to open the database"); //to load the table QSqlQueryModel * model = new QSqlQueryModel(); QSqlQuery * qry = new QSqlQuery(mydb); qry->prepare("select name, surname from patients"); qry->exec(); model->setQuery(*qry); ui->tableView->setModel(model); QSqlQuery * qry1 = new QSqlQuery(mydb); QSqlQueryModel * model1 = new QSqlQueryModel(); qry1->prepare("select name, surname from patients where doctor is null"); qry1->exec(); model1->setQuery(*qry1); ui->tableView_noDoc->setModel(model1); QSqlQuery * qry2 = new QSqlQuery(mydb); QSqlQueryModel * model2 = new QSqlQueryModel(); qry2->prepare("select name, surname,doctor from patients where diagnose is null"); qry2->exec(); model2->setQuery(*qry2); ui->tableView_noDiag->setModel(model2); QSqlQueryModel * model3 = new QSqlQueryModel(); QSqlQuery * qry3 = new QSqlQuery(mydb); qry3->prepare("select surname from doctors"); qry3->exec(); model3->setQuery(*qry3); ui->comboBox->setModel(model3); qDebug()<<(model->rowCount()); }
void So2sdr::populateDupesheet() // populates dupe sheet. Needs to be called when switching bands // or first turning on the dupesheet { // if only one dupesheet is active, figure out which one it is bool oneactive=false; int nr=0; if (nDupesheet==1) { oneactive=true; for (int i=0;i<2;i++) { if (!dupesheet[i]) continue; if (dupesheet[i]->isVisible()) { nr=i; break; } } } for (int id=0;id<2;id++) { if (!dupesheet[id]) continue; int ib=id; if (oneactive) { if (nr!=id) continue; ib=activeRadio; } dupesheet[id]->Dupes0->clear(); dupesheet[id]->Dupes1->clear(); dupesheet[id]->Dupes2->clear(); dupesheet[id]->Dupes3->clear(); dupesheet[id]->Dupes4->clear(); dupesheet[id]->Dupes5->clear(); dupesheet[id]->Dupes6->clear(); dupesheet[id]->Dupes7->clear(); dupesheet[id]->Dupes8->clear(); dupesheet[id]->Dupes9->clear(); for (int i = 0; i < dsColumns; i++) { dupeCalls[id][i].clear(); dupeCallsKey[id][i].clear(); } QSqlQueryModel m; m.setQuery("SELECT * FROM log WHERE valid='true' and BAND=" + QString::number(band[ib]), mylog->db); while (m.canFetchMore()) { m.fetchMore(); } for (int i = 0; i < m.rowCount(); i++) { QByteArray tmp = m.record(i).value("call").toString().toAscii(); updateDupesheet(tmp,id); } dupesheet[id]->setWindowTitle("Dupesheet " + bandName[band[ib]]); } }
QVector<QString> ClinicInternalPayment::getDistinctFromDB(QString strColumn, QString strTable) { QVector<QString> vec; QSqlQueryModel *sqlModel = new QSqlTableModel; sqlModel->setQuery("SELECT distinct " + strColumn + " FROM " + strTable); for(int i = 0; i<sqlModel->rowCount();i++) { QSqlRecord record = sqlModel->record(i); QString strReceipt = record.value(strColumn).toString(); vec.append(strReceipt); } return vec; }
void shift_work::init_table() { QString date1 = ui->label_7->text(); QString date2 = ui->label_8->text(); QSqlQueryModel model; QSettings conf(public_sql::settings_ini_dir_file, QSettings::IniFormat); model_top = new QStandardItemModel(); model_rfb = new QStandardItemModel(); model_top->setHorizontalHeaderLabels(QStringList()<<tr("收款方式")<<tr("收款次数")<<tr("收款金额")<<tr("面额")); model_rfb->setHorizontalHeaderLabels(QStringList()<<tr("会员卡操作方式")<<tr("操作次数")<<tr("金额")); ui->tableView->setEditTriggers(QAbstractItemView::NoEditTriggers);ui->tableView->setModel(model_top); ui->tableView_2->setEditTriggers(QAbstractItemView::NoEditTriggers);ui->tableView_2->setModel(model_rfb); #if QT_VERSION >= QT_VERSION_CHECK(5,0,0) ui->tableView->horizontalHeader()->setSectionResizeMode(QHeaderView::Stretch); ui->tableView_2->horizontalHeader()->setSectionResizeMode(QHeaderView::Stretch); #else ui->tableView->horizontalHeader()->setResizeMode(QHeaderView::Stretch); ui->tableView_2->horizontalHeader()->setResizeMode(QHeaderView::Stretch); #endif model.setQuery(QString("Select a.ch_paymodeno , count( a.ch_paymodeno), sum( a.num_realamount), sum( a.num_face),IFNULL(c.vch_paymodename,a.ch_paymodeno) , IFNULL(c.ch_faceflag,'N') from cey_u_checkout_detail a , cey_u_checkout_master b ,cey_bt_paymode c where (c.ch_paymodeno =a.ch_paymodeno)and( a.ch_payno =b.ch_payno)and(b.ch_state ='Y') and(b.vch_operID ='%1')and(b.dt_operdate >= '%2' and b.dt_operdate <= '%3')Group by a.ch_paymodeno ,c.vch_paymodename , c.ch_faceflag having sum( a.num_realamount)> 0 or sum( a.num_payamount)> 0 Order by a.ch_paymodeno ,c.vch_paymodename , c.ch_faceflag").arg(n_func::gs_operid).arg(date1).arg(date2)); for(int i = 0; i < model.rowCount(); i++) { int row = model_top->rowCount(); model_top->setRowCount(row + 1); model_top->setItem(row,0,new QStandardItem(model.record(i).value(4).toString())); model_top->setItem(row,1,new QStandardItem(model.record(i).value(1).toString())); model_top->setItem(row,2,new QStandardItem(QString().sprintf("%0.2f",model.record(i).value(2).toFloat()))); model_top->setItem(row,3,new QStandardItem(QString().sprintf("%0.2f",model.record(i).value(3).toFloat()))); } model.setQuery(QString("select sum(num_deposit),count(*) from t_m_deposit where ch_deposit_mode='1' and dt_operdate >= '%1' and dt_operdate <= '%2' ") .arg(date1).arg(date2)); model_rfb->appendRow(QList<QStandardItem *>()<<new QStandardItem("充值")<< new QStandardItem(model.record(0).value(1).toString())<< new QStandardItem(kafue=model.record(0).value(0).toString())); model.setQuery(QString("select sum(num_realamount),count(*) from t_m_deposit where ch_deposit_mode='1' and dt_operdate >= '%1' and dt_operdate <= '%2' ") .arg(date1).arg(date2)); model_rfb->appendRow(QList<QStandardItem *>()<<new QStandardItem("充值实收")<< new QStandardItem(model.record(0).value(1).toString())<< new QStandardItem(kafue_realamount=model.record(0).value(0).toString())); model.setQuery(QString("select sum(num_deposit),count(*) from t_m_deposit where ch_deposit_mode='8' and dt_operdate >= '%1' and dt_operdate <= '%2' ") .arg(date1).arg(date2)); model_rfb->appendRow(QList<QStandardItem *>()<<new QStandardItem("取款")<< new QStandardItem(model.record(0).value(1).toString())<< new QStandardItem(card_fetch=model.record(0).value(0).toString())); model.setQuery(QString("select sum(num_deposit),count(*) from t_m_deposit where ch_deposit_mode='5' and dt_operdate >= '%1' and dt_operdate <= '%2' ") .arg(date1).arg(date2)); model_rfb->appendRow(QList<QStandardItem *>()<<new QStandardItem("退卡")<< new QStandardItem(model.record(0).value(1).toString())<< new QStandardItem(card_back=model.record(0).value(0).toString())); if(conf.value("w_sys_manage_cloudsync_basedataset/yun_start",false).toBool()){ w_sys_manage_cloudsync::member_r_f_b_info mrfb=w_sys_manage_cloudsync::get_yun_member_r_f_b(n_func::gs_operid, date1, date2); model_rfb->appendRow(QList<QStandardItem *>()<<new QStandardItem("充值(云)")<< new QStandardItem("")<< new QStandardItem(card_recharge_yun=mrfb.rechargeAmount)); model_rfb->appendRow(QList<QStandardItem *>()<<new QStandardItem("充值实收(云)")<< new QStandardItem("")<< new QStandardItem(card_recharge_realamount_yun=mrfb.realRechargeAmount)); model_rfb->appendRow(QList<QStandardItem *>()<<new QStandardItem("取款(云)")<< new QStandardItem("")<< new QStandardItem(card_fetch_yun=mrfb.withdrawalAmount)); model_rfb->appendRow(QList<QStandardItem *>()<<new QStandardItem("退卡(云)")<< new QStandardItem("")<< new QStandardItem(card_back_yun=mrfb.backCardAmount)); } }
void DetalleCompraVenta::populateLocalizacionField() { ui->localizacion->clear(); QSqlQuery query; query.prepare("SELECT id, lugar FROM localizacion WHERE _id = 1 OR cliente = :cliente"); query.bindValue(":cliente",ui->cliente->itemData(ui->cliente->currentIndex()).toLongLong()); query.exec(); QSqlQueryModel campos; campos.setQuery(query); for(int i=0; i < campos.rowCount(); i++) { ui->localizacion->addItem( campos.data(campos.index(i,1)).toString(), campos.data(campos.index(i,0)).toInt()); } }
void Manager::on_pushButton_Clear_clicked() { //Clearing Text Fields progressBar->setValue(0); ui->lineEdit_Album->clear(); ui->lineEdit_band_name->clear(); ui->lineEdit_price_max->clear(); ui->lineEdit_price_min->clear(); ui->label_results->clear(); Database conn; QSqlQueryModel * model = new QSqlQueryModel(); conn.connOpen("Inventory"); QSqlQuery * qry = new QSqlQuery(conn.mydb); progressBar->setValue(25); qry->prepare("SELECT * FROM Inventory"); qry->exec(); model->setQuery(*qry); ui->tableView_Master->setModel(model); ui->comboBox_Type->setCurrentIndex(0); progressBar->setValue(50); ui->checkBox_XS->setChecked(false); ui->checkBox_S->setChecked(false); ui->checkBox_M->setChecked(false); progressBar->setValue(75); ui->checkBox_L->setChecked(false); ui->checkBox_XL->setChecked(false); ui->checkBox_xxl->setChecked(false); progressBar->setValue(100); QGraphicsOpacityEffect* opacityEffect = new QGraphicsOpacityEffect(this); opacityEffect->setOpacity(1.0); ui->statusbar->setGraphicsEffect(opacityEffect); QPropertyAnimation* anim = new QPropertyAnimation(this); anim->setTargetObject(opacityEffect); anim->setPropertyName("opacity"); anim->setDuration(4000); anim->setStartValue(opacityEffect->opacity()); anim->setEndValue(0); anim->setEasingCurve(QEasingCurve::OutQuad); anim->start(QAbstractAnimation::DeleteWhenStopped); qDebug() << (model->rowCount()); }
void MultiWeatherParamWidget::initData(){ //初始化DB pgDb = new PgDataBase; //多要素 QString queryStr = QString("select * from weatherparam where choose_type = 1 and limit_type <> 0 order by id"); QSqlQueryModel *plainModel = pgDb->queryModel(queryStr); int rowCount = plainModel->rowCount(); for(int i = 0;i < rowCount;i++){ WeatherParam weatherParam; weatherParam.setId(plainModel->record(i).value(0).toInt()); weatherParam.setName(plainModel->record(i).value(1).toString()); weatherParam.setChoose_type(plainModel->record(i).value(2).toInt()); weatherParam.setLimit_type(plainModel->record(i).value(3).toInt()); weatherParamList.append(weatherParam); } delete plainModel; }
void DataBank::tableMake(LONG64 ideep,UNINT32 imaterial,UNINT32 iacreage,UNINT32 ieffect,UNINT32 iry ,UNINT32 iovc,UNINT32 ishape) { bool ok = false; QString sql = QString("select * from '%1'"); QString name = ""; if(imaterial == 0){ name = "cust"; }else{ name = "crst"; } name.append(QString::number(ishape,10)); sql.arg(name); if(!database.open()){ qDebug()<<"spark database is error"; }else{ qDebug()<<"spark database is ok"; } QSqlQueryModel model; model.setQuery(sql,database); for(int i = 0; i < model.rowCount(); ++i){ int id = model.record(i).value("h_area").toInt(); QString name = model.record(i).value("no").toString(); qDebug() << id << name; } /* QSqlQuery query(database); query.prepare("select * from cust0 where h_area > :value1 and l_area < :value2 and cnf = 0"); query.bindValue(":value1" ,2); query.bindValue(":value2" ,2); b = query.exec(); if(!b){ qDebug()<<"table is error"; }else{ qDebug()<<"table is ok"; while(query.next()){ qDebug()<<query.value(S_OFS).toString()<<query.value(PP).toString(); } } */ database.close(); }
void LoginDialog::on_pushButtonEnter_clicked() { QCryptographicHash hash(QCryptographicHash::Md5); hash.addData(ui->lineEditPassword->text().toUtf8()); QSqlQueryModel model; QSqlQuery query; query.prepare("Select * from users where username=:username and password=:password and status = 'A'"); query.bindValue(":username", ui->lineEditUsername->text().trimmed()); query.bindValue(":password", hash.result().toHex()); query.exec(); model.setQuery(query); if(model.rowCount() > 0){ emit loggedIn(); }else{ qDebug() << "Login Failed"; } }
Activity::Activity(QString courseID, QString activityName) { dbManager db; QSqlQueryModel* model = db.getActivityInfo(courseID, activityName); if (model != NULL) { activityID = model->record(0).value("activityID").toInt(); //actName = activityName; //actType = model->record(0).value("activityType").toString(); //dueDate = model->record(0).value("dueDateTime").toString(); //dueTime = model->record(0).value("dueDateTime").toString(); //pathToStdSubm = model->record(0).value("dueDateTime").toString(); //pathToSolnFile = model->record(0).value("dueDateTime").toString(); //actLanguage = model->record(0).value("dueDateTime").toString(); //bonusDays = model->record(0).value("dueDateTime").toString(); //penaltyDays = model->record(0).value("dueDateTime").toString(); //bonusPercentPerDay = model->record(0).value("dueDateTime").toString(); //penaltyPercentPerDay = model->record(0).value("dueDateTime").toString(); //rubric = model->record(0).value("dueDateTime").toString(); rubricChanged = false; delete model; } model = db.getRubric(QString::number(activityID)); if (model != NULL) { //int itemNum; //QString itemDescription; //int itemGrade; rubricItem_t rubricItem; rubric.clearRubric(); int rowcount = model->rowCount(); for (int i=0; i<rowcount; i++) { rubricItem.itemDescription = model->record(i).value("rubricItemText").toString(); rubricItem.itemNum = model->record(i).value("rubricItemNumber").toInt(); rubricItem.itemGrade = model->record(i).value("rubricItemValue").toInt(); rubricItem.itemID = model->record(i).value("rubricItemID").toInt(); rubric.addRubricItem_withID(rubricItem.itemNum,rubricItem.itemDescription, rubricItem.itemGrade, rubricItem.itemID); } } }
void PrepodMain::on_comboBox_2_currentIndexChanged(int index){ ui->comboBox->clear(); QSqlQueryModel model; QString s = QString("SELECT * FROM \"forkurator\" WHERE \"studGroupId\" = '%1' AND \"Kurator\"='%2' ").arg(groupIds.at(ui->comboBox_2->currentIndex())).arg(IDD); model.setQuery(s); studentsFio.clear(); studentsId.clear(); for (int i=0;i<model.rowCount();i++){ studentsFio<<model.record(i).value("FIO").toString(); studentsId<<model.record(i).value("id").toString(); } if (ui->comboBox->count()!=0) { ui->comboBox->clear(); } ui->comboBox->addItems(studentsFio); qDebug()<<studentsFio; }
//Ausleitung als csv-Datei void MainWindow::on_pushButton_clicked() { QSqlQueryModel *model = (QSqlQueryModel*)ui->listView->model(); QSqlRecord record = model->record(ui->listView->currentIndex().row()); QSqlField field_ID = record.field("ID"); DBank con; con.con_open(); QSqlQuery query(con.myDB); query.prepare("SELECT t.Vorname as Vorname, t.Nachname as Nachname, time(t.Endzeit-e.Startzeit, \"unixepoch\") from TEILNEHMER as t JOIN EVENT as e ON e.ID == t.EVENT_ID where e.ID = '"+field_ID.value().toString()+"' ORDER BY t.Endzeit ASC"); if(query.exec()) { QSqlQueryModel *model=new QSqlQueryModel(); model->setQuery(query); QString DB_Inhalt; int rows=model->rowCount(); int columns=model->columnCount(); for (int i = 0; i < rows; i++) { for (int j = 0; j < columns; j++) { DB_Inhalt += model->data(model->index(i,j)).toString(); DB_Inhalt += "; "; } DB_Inhalt += "\n"; } QString filename = QFileDialog::getSaveFileName(this,"Speichern unter","C://","All files (*.*);;ExcelFile(*.csv)"); QFile csvfile(filename); if(csvfile.open(QIODevice::WriteOnly|QIODevice::Truncate)) { QTextStream out(&csvfile); out<<DB_Inhalt; } csvfile.close(); } }
void QSqlQueryModel_snippets() { { //! [16] QSqlQueryModel *model = new QSqlQueryModel; model->setQuery("SELECT name, salary FROM employee"); model->setHeaderData(0, Qt::Horizontal, tr("Name")); model->setHeaderData(1, Qt::Horizontal, tr("Salary")); //! [17] QTableView *view = new QTableView; //! [17] //! [18] view->setModel(model); //! [18] //! [19] view->show(); //! [16] //! [19] //! [20] view->setEditTriggers(QAbstractItemView::NoEditTriggers); //! [20] } //! [21] QSqlQueryModel model; model.setQuery("SELECT * FROM employee"); int salary = model.record(4).value("salary").toInt(); //! [21] Q_UNUSED(salary); { //! [22] int salary = model.data(model.index(4, 2)).toInt(); //! [22] Q_UNUSED(salary); } for (int row = 0; row < model.rowCount(); ++row) { for (int col = 0; col < model.columnCount(); ++col) { qDebug() << model.data(model.index(row, col)); } } }