Widget::Widget(QWidget *parent) :
QWidget(parent),
ui(new Ui::Widget)
{
ui->setupUi(this);
setFixedSize(750, 500);
ui->stackedWidget->setCurrentIndex(0);
QSqlQueryModel *typeModel = new QSqlQueryModel(this);
typeModel->setQuery("select name from type");
ui->sellTypeComboBox->setModel(typeModel);
QSplitter *splitter = new QSplitter(ui->managePage);
splitter->resize(700, 360);
splitter->move(0, 50);
splitter->addWidget(ui->toolBox);
splitter->addWidget(ui->dailyList);
splitter->setStretchFactor(0, 1);
splitter->setStretchFactor(1, 1);
on_sellCancelBtn_clicked();
}
QSqlQueryModel * DatabaseHandler::getCloseObjects(census * obj) {
QSqlQueryModel * model = new QSqlQueryModel;
QString qstr = "SELECT sync_id FROM sync_utm32 WHERE cam" + obj->camera + "_id='"
+ obj->image + "'";
QSqlQuery query(qstr);
int sync_id;
if (query.next())
sync_id = query.value(0).toInt();
else {
qDebug() << qstr;
return model;
}
query.clear();
QStringList sidList = QStringList() << QString::number(sync_id-1) << QString::number(sync_id)
<< QString::number(sync_id+1);
qstr = "SELECT cam, img FROM image_properties WHERE sync_id IN (" +sidList.join(",")+ ")";
query.exec(qstr);
QStringList condList;
while(query.next()) {
condList.append("(cam='" + query.value(0).toString()
+ "' AND img='" +query.value(1).toString()+ "')");
}
/*
* TODO: Add distance comparison
*/
qstr = "SELECT rcns_id, cam, img, ux, uy, tp, "
"ST_Distance( (SELECT ST_SetSRID(ST_Point(ux,uy),32632) FROM raw_census "
"where rcns_id=" + QString::number(obj->id) + ") "
", ST_SetSRID(ST_Point(ux,uy),32632) ) as dist FROM raw_census "
"WHERE (" + condList.join(" OR ") + ") AND rcns_id!=" + QString::number(obj->id) +
" AND session='" + obj->session + "' ORDER BY dist";
qDebug() << qstr;
model->setQuery(qstr);
model->setHeaderData(0, Qt::Horizontal, "Object Id");
model->setHeaderData(1, Qt::Horizontal, "Kamera");
model->setHeaderData(2, Qt::Horizontal, "Bildnummer");
model->setHeaderData(3, Qt::Horizontal, "UTM X");
model->setHeaderData(4, Qt::Horizontal, "UTM Y");
model->setHeaderData(5, Qt::Horizontal, "Vorsortierung");
model->setHeaderData(6, Qt::Horizontal, "Entfernung in m");
return model;
}
estore::estore(QWidget *parent) :
QDialog(parent),
ui(new Ui::estore)
{
ui->setupUi(this);
setFixedSize(670,290);
setWindowTitle("商城");
QSqlQueryModel *mode = new QSqlQueryModel(ui->tableView); //建立一个Model
mode->setQuery("select * from commodity") ;
mode->setHeaderData(0,Qt::Horizontal,QObject::tr("编号"));
mode->setHeaderData(1,Qt::Horizontal,QObject::tr("名称"));
mode->setHeaderData(2,Qt::Horizontal,QObject::tr("描述"));
mode->setHeaderData(3,Qt::Horizontal,QObject::tr("原价"));
mode->setHeaderData(4,Qt::Horizontal,QObject::tr("售价"));
mode->setHeaderData(5,Qt::Horizontal,QObject::tr("种类"));
mode->setHeaderData(6,Qt::Horizontal,QObject::tr("数量"));
mode->setHeaderData(7,Qt::Horizontal,QObject::tr("折扣"));
mode->setHeaderData(8,Qt::Horizontal,QObject::tr("出版社/品牌"));
mode->setHeaderData(9,Qt::Horizontal,QObject::tr("ISBN/材料/类别"));
mode->setHeaderData(10,Qt::Horizontal,QObject::tr("日期"));
mode->setHeaderData(11,Qt::Horizontal,QObject::tr("页数/型号/重量"));
ui->tableView->setModel(mode);
}
QList<int> DataBank::listTable()
{
QList<int> list;
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 i = 0; i < model.rowCount(); ++i){
QString name = model.record(i).value("name").toString();
list.append(name.mid(5,2).toInt(&ok ,10));
}
database.close();
return list;
}
DashboardWindow::DashboardWindow(QWidget *parent, bool isRelative, QString ID) :
QWidget(parent),
ui(new Ui::DashboardWindow)
{
ui->setupUi(this);
//qDebug() << ID;
m_RelativeID = ID;
if (isRelative)
{
//qDebug() << "Is relative";
ui->stackedWidget->setCurrentIndex(1);
on_pushButton_overview_clicked();
ui->pushButton_overview->setChecked(1);
}
else {
ui->stackedWidget->setCurrentIndex(0);
QSqlQueryModel *model = new QSqlQueryModel;
QString query = "SELECT COUNT(*) FROM INMATE";
model->setQuery(query);
ui->txtInmateCount->setText("Number of inmates: " + model->data(model->index(0, 0)).toString());
query = "SELECT COUNT(*) FROM RE_LATIVE";
model->setQuery(query);
ui->txtRelativeCount->setText("Number of relatives: " + model->data(model->index(0, 0)).toString());
query = "SELECT COUNT(*) FROM OFFICER";
model->setQuery(query);
ui->txtOfficerCount->setText("Number of officers: " + model->data(model->index(0, 0)).toString());
}
}
QSqlQueryModel *DatabaseManager::getPrestable(int idtransaccion,QWidget* parentWidget)
{
QSqlQueryModel *model = new QSqlQueryModel(parentWidget);
if(!db.open()){ QMessageBox::critical(0,"Database Error",db.lastError().text()); return model; }
QSqlQuery preQuery;
preQuery.exec(QString("SELECT * FROM transacciones WHERE idtransaccion = '%1' LIMIT 1;"
).arg(idtransaccion));
if(!preQuery.next())
{
//There is a record in the table with this same information
qDebug() << "Transaction does not exist";
return model;
}
//TODO what the hell is going on here?
model->setQuery(QString("SELECT marca,modelo,observaciones,idserie,dimension FROM prestables right join balanzas on prestables.balanzas_idbalanza = balanzas.idbalanza where idprestable = (select transacciones.prestables_idprestable from transacciones where idtransaccion = '2');"));
// model->setQuery(QString("SELECT * FROM transacciones;"));
bool ret = true;
if(ret)
{
qDebug() << "Row count" << model->rowCount();
return model;
}
else
{
qDebug() << model->lastError().text();
return model;
}
}
void SqlItemView::setModel(QAbstractItemModel * model)
{
m_model = model;
QSqlQueryModel * t = qobject_cast<QSqlQueryModel *>(model);
if (!t) { return; }
QSqlRecord rec(t->record());
if (scrollWidget->widget())
{
delete scrollWidget->takeWidget();
}
QWidget * layoutWidget = new QWidget(scrollWidget);
m_gridLayout = new QGridLayout(layoutWidget);
QString tmp("%1:");
for (int i = 0; i < rec.count(); ++i)
{
m_gridLayout->addWidget(
new QLabel(tmp.arg(rec.fieldName(i)), layoutWidget), i, 0);
QTextEdit * w = new QTextEdit(layoutWidget);
w->setReadOnly(false);
w->setAcceptRichText(false);
int mh = QFontMetrics(w->currentFont()).lineSpacing();
w->setMinimumHeight(mh);
w->setSizePolicy(QSizePolicy::Expanding,
QSizePolicy::MinimumExpanding);
m_gridLayout->addWidget(w, i, 1);
m_gridLayout->setRowMinimumHeight(i, mh);
connect(w, SIGNAL(textChanged()),
this, SLOT(textChanged()));
}
scrollWidget->setWidget(layoutWidget);
m_count = rec.count();
}
void EvictionWindow::on_searchBtn_clicked()
{
DataBase db;
db.connectionOpen();
QSqlQuery query;
QString searchText = ui->searchEdit->text();
if(searchText == ""){
query.prepare("select * from clients");
} else if(ui->searchType->currentText() == "Номеру комнаты") {
query.prepare("select * from clients where roomNumber=" + searchText);
} else if(ui->searchType->currentText() == "Имени") {
query.prepare("select * from clients where firstName like '%" + searchText + "%'");
} else if(ui->searchType->currentText() == "Фамилии") {
query.prepare("select * from clients where lastName like '%" + searchText + "%'");
} else if(ui->searchType->currentText() == "Паспорту") {
query.prepare("select * from clients where passport like '%" + searchText + "%'");
}
query.exec();
QSqlQueryModel * model = new QSqlQueryModel();
model->setQuery(query);
model->QSqlQueryModel::setHeaderData(0, Qt::Horizontal, "ID");
model->QSqlQueryModel::setHeaderData(1, Qt::Horizontal, "Имя");
model->QSqlQueryModel::setHeaderData(2, Qt::Horizontal, "Фамилия");
model->QSqlQueryModel::setHeaderData(3, Qt::Horizontal, "Паспорт");
model->QSqlQueryModel::setHeaderData(4, Qt::Horizontal, "Количество дней");
model->QSqlQueryModel::setHeaderData(5, Qt::Horizontal, "Дата посления");
model->QSqlQueryModel::setHeaderData(6, Qt::Horizontal, "№ комнаты");
model->QSqlQueryModel::setHeaderData(7, Qt::Horizontal, "Тип комнаты");
ui->tableView->setModel(model);
ui->tableView->resizeColumnToContents(4);
ui->tableView->resizeColumnToContents(5);
db.connectionClose();
}
void pandasoft::Principal()
{
ui->error->hide();
ui->error0->hide();
ui->usuario->setStyleSheet("background-color: none;");
ui->clave->setStyleSheet("background-color: none;");
if(ui->usuario->text().isEmpty()||ui->clave->text().isEmpty()){
if(ui->usuario->text().isEmpty()){
ui->error->show();
ui->usuario->setStyleSheet("background-color: red;");
}
if(ui->clave->text().isEmpty()){
ui->error->show();
ui->clave->setStyleSheet("background-color: red;");
}
}
else {
QSqlQueryModel model;
QString consulta="select Nombre, Ap, Am, Rol from Usuario where (Nombre='"+ui->usuario->text()+"' and Contrasena='"+ui->clave->text()+"' )";
model.setQuery(consulta);
if(model.record(0).value("Rol").toString()==""){
ui->error0->show();
}else{
QString rol = model.record(0).value("Rol").toString();
rolusu=rol;
QString usuario = model.record(0).value("Nombre").toString()+" "+model.record(0).value("Ap").toString()+" "+model.record(0).value("Am").toString();
this->setWindowTitle("Principal");
ui->pandasoftstackedWidget->setCurrentIndex(1);
ui->menubar->show();
if(rolusu=="1"){
ui->menuMenu_Gerente->setEnabled(false);
ui->cabecera->setText("Bienvenido Usuario: "+usuario+" Rol : Jefe de Almacen");
}else{
ui->cabecera->setText("Bienvenido Usuario: "+usuario+" Rol : Gerente");
}
}
ui->alertalista->setEnabled(false);
QString alerta="select Nombre from Producto where Cantidad<Lim_stock";
model.setQuery(alerta);
ui->alertalista->setText(model.record(0).value("Nombre").toString());
}
}
//点击音乐库按钮
void MusicWindow::store_Show()
{
QSqlQueryModel *model = new QSqlQueryModel;
model->setQuery("select * from music_songs");
model->setHeaderData(0, Qt::Horizontal, tr("The name of songs"));
model->setHeaderData(1, Qt::Horizontal, tr("The number of mark"));
ui->storeView->setModel(model);
ui->storeView->horizontalHeader()->setDefaultAlignment(Qt::AlignCenter); //表头居中
ui->storeView->setColumnWidth(0, 355);//设置固定列宽
ui->storeView->setColumnWidth(1, 355);
titlePalette = ui->storeButton->palette();
titlePalette.setColor(QPalette::ButtonText, Qt::red);
ui->storeButton->setPalette(titlePalette);
titlePalette.setColor(QPalette::ButtonText,Qt::white);
ui->browserButton->setPalette(titlePalette);
ui->favoriteButton->setPalette(titlePalette);
ui->webView->hide();
ui->favoriteView->hide();
ui->storeView->show();
}
void viewActivityAllCourses::on_comboBox_currentIndexChanged()
{
QSqlQuery qry;
QString courseid,course;
course = ui->comboBox->currentText();
qry.exec("select courseID from Courses where courseName='"+course+"'");
while(qry.next()){
courseid = qry.value(0).toString();
}
//activity table
QSqlQueryModel * modal = new QSqlQueryModel();
QSqlQuery qry2;//= new QSqlQuery(conn2.mydb);
qry2.prepare("select activityname from activity where courseid='"+courseid+"'");
qry2.exec();
modal->setQuery(qry2);
ui->tableView->setModel(modal);
}
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()));
}
}
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]);
}
}
}
}
QSqlQueryModel * DatabaseHandler::getImageObjects(census * obj) {
QSqlQueryModel * model = new QSqlQueryModel;
QString qstr = "SELECT rcns_id, tp, ux, uy, max(censor), count(*) FROM view_census WHERE cam='" +
obj->camera + "' AND img='" + obj->image + "' AND session='"
+ obj->session + "' AND (censor>0 OR censor IS NULL) GROUP BY rcns_id, tp, ux, uy ORDER BY rcns_id";
qDebug() << qstr;
model->setQuery(qstr);
model->setHeaderData(0, Qt::Horizontal, "Objekt Id");
model->setHeaderData(1, Qt::Horizontal, "Typ");
model->setHeaderData(2, Qt::Horizontal, "UTM X");
model->setHeaderData(3, Qt::Horizontal, "UTM Y");
model->setHeaderData(4, Qt::Horizontal, "Highest censor");
model->setHeaderData(5, Qt::Horizontal, "Censor count");
return model;
}
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]]);
}
}
void frmClients::on_tableView_clicked(const QModelIndex &index)
{
ui->ClientTabs->setVisible(true);
ui->FIOEdit->setDisabled(true);
ui->Nom_Edit->setDisabled(true);
ui->dateEdit->setDisabled(true);
ui->InfoEdit->setDisabled(true);
ui->Pol->setDisabled(true);
ui->OtkudaEdit->setDisabled(true);
QModelIndex ID = ui->tableView->model()->index(index.row(),3);
IDClients = ID.data().toInt();
frm->UpdateClients(IDClients);
QSqlQuery query;
query.prepare("SELECT FIO, nom_tel, Date_R, info, pol FROM Clients WHERE Clients.ID = :ID");
query.bindValue(":ID",IDClients);
query.exec();
while (query.next()){
ui->FIOEdit->setText(query.value(0).toString());
ui->Nom_Edit->setText(query.value(1).toString());
ui->dateEdit->setDateCalendar(QDate::fromString(query.value(2).toString(),"dd.MM.yyyy"));
ui->InfoEdit->setText(query.value(3).toString());
ui->Pol->setCurrentIndex(query.value(4).toInt());
}
query.prepare("SELECT "
" Clients_history.DATE_USLUGI, "
" USLUGI.NAME, "
" SUM(Clients_history.SUMMA) AS SUMMA, "
" Clients_history.NUMBER "
"FROM CLIENTS_HISTORY INNER JOIN USLUGI ON CLIENTS_HISTORY.ID_USLUGA = USLUGI.ID "
"WHERE Clients_history.ID_CLIENT = :ID "
"GROUP BY"
" Clients_history.DATE_USLUGI, "
" USLUGI.NAME, "
" Clients_history.NUMBER "
"ORDER BY "
" Clients_history.NUMBER");
query.bindValue(":ID",IDClients);
query.exec();
qDebug() << query.lastError();
QSqlQueryModel *model = new QSqlQueryModel;
model->setQuery(query);
model->setHeaderData(0,Qt::Horizontal,QObject::tr("Дата"));
model->setHeaderData(1,Qt::Horizontal,QObject::tr("Услуга"));
model->setHeaderData(2,Qt::Horizontal,QObject::tr("Сумма"));
model->setHeaderData(3,Qt::Horizontal,QObject::tr("Ном. док."));
ui->tClient_history->setModel(model);
ui->tClient_history->horizontalHeader()->setResizeMode(QHeaderView::Stretch);
}
void AdminDialog::on_pushButton_2_clicked()
{
QString date = QDate::currentDate().toString("yyyy-MM-dd");
QSqlQueryModel *model = new QSqlQueryModel;
QString sql = "select boid,bid,rid,overbor,botime,retime from borrow where isreturn=0 and retime<'"+date+"';";
model->setQuery(sql);
model->setHeaderData(0,Qt::Horizontal,"借阅编号");
model->setHeaderData(1,Qt::Horizontal,"图书编号");
model->setHeaderData(2,Qt::Horizontal,"读者编号");
model->setHeaderData(3,Qt::Horizontal,"剩余续借次数");
model->setHeaderData(4,Qt::Horizontal,"借阅时间");
model->setHeaderData(5,Qt::Horizontal,"应还时间");
ui->tv3->setModel(model);
}
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 MainWindow::on_buttonOpenCom_clicked(){
QSqlQueryModel *trackModel = (QSqlQueryModel*)ui->comboTrack->model();
QSqlQueryModel *vehicleModel = (QSqlQueryModel*)ui->comboVehicle->model();
if(ui->comboPortName->count()>0){
if(ui->comboTrack->currentIndex()!=-1){
if(ui->comboVehicle->currentIndex()!=-1){
if(!ui->newRaceNameText->text().trimmed().isEmpty()){
if(gsm->open(ui->comboPortName->currentText())){
logConsole->addToLog(LogConsole::INFO, "Porta seriale aperta correttamente");
ui->mainPanel->setCurrentIndex(1);
ui->menuFile->setEnabled(false);
ui->menuRecorder->setEnabled(true);
ui->menuSommario->setEnabled(true);
ui->menuImpostazioni->setEnabled(false);
recordingSession->startNew(
ui->newRaceNameText->text(),
ui->raceDescText->toPlainText(),
trackModel->data(trackModel->index(ui->comboTrack->currentIndex(),0)).toInt(),
vehicleModel->data(vehicleModel->index(ui->comboTrack->currentIndex(),0)).toInt()
);
showMaximized();
recordingViews->setup();
}else{
QMessageBox::critical(this, "Errore", gsm->getSerial()->errorString());
logConsole->addToLog(LogConsole::ERRORS, gsm->getSerial()->errorString());
}
}else{
QMessageBox::critical(this, "Errore", "Il nome della gara non può essere vuoto!");
}
}else{
QMessageBox::critical(this, "Errore", "Nessun veicolo selezionato!");
logConsole->addToLog(LogConsole::ERRORS, "Nessun veicolo selezionato!");
}
}else{
QMessageBox::critical(this, "Errore", "Nessun circuito selezionato!");
logConsole->addToLog(LogConsole::ERRORS, "Nessuna circuito selezionato!");
}
}else{
QMessageBox::critical(this, "Errore", "Impossibile trovare un dispositivo di ricezione!");
logConsole->addToLog(LogConsole::ERRORS, "Impossibile trovare un dispositivo di ricezione!");
}
}
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 Browser::exec()
{
QSqlQueryModel *model = new QSqlQueryModel(table);
model->setQuery(QSqlQuery(sqlEdit->toPlainText(), connectionWidget->currentDatabase()));
table->setModel(model);
if (model->lastError().type() != QSqlError::NoError)
emit statusMessage(model->lastError().text());
else if (model->query().isSelect())
emit statusMessage(tr("Query OK."));
else
emit statusMessage(tr("Query OK, number of affected rows: %1").arg(
model->query().numRowsAffected()));
updateActions();
}
frmConfigurar_terminal::frmConfigurar_terminal(QWidget *parent) :
QDialog(parent),
ui(new Ui::frmConfigurar_terminal)
{
ui->setupUi(this);
QSqlQueryModel *series = new QSqlQueryModel(this);
series->setQuery("select serie from series",Configuracion_global->empresaDB);
ui->cboserie->setModel(series);
QSqlQueryModel *users = new QSqlQueryModel(this);
users->setQuery("select nombre from usuarios",Configuracion_global->groupDB);
ui->cboUsuarioActivo->setModel(users);
QSqlQueryModel *cajas = new QSqlQueryModel(this);
cajas->setQuery("select desc_caja from cajas",Configuracion_global->empresaDB);
ui->cbocaja->setModel(cajas);
}
//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 L_TAB::on_pushButton_clicked()
{
QSqlQueryModel *model = new QSqlQueryModel();
model->setQuery("SELECT * FROM settings");
tableView->setFocus();
QModelIndex index = tableView->currentIndex();
QSqlRecord record;
record = model->record(index.row());
model->setQuery("DELETE FROM settings WHERE table_name = '"
+record.value("table_name").toString()
+"'");
model->setQuery("DROP FUNCTION add_to_log_"
+record.value("table_name").toString()
+"() CASCADE");
model->setQuery("SELECT * FROM settings");
tableView->setModel(model);
}
void BairesWindow::runQuery(QString queryString) {
QSqlQueryModel *model = new QSqlQueryModel(ui.resultsTable);
QSqlQuery q(queryString, db);
model->setQuery(q);
if (model->lastError().type() != QSqlError::NoError) {
qDebug() << model->lastError().text();
qDebug() << tr("Query Error.");
} else if (model->query().isSelect())
qDebug() << tr("Query OK");
else
qDebug() << tr("Query OK, number of affected rows: %1").arg(model->query().numRowsAffected());
ui.resultsTable->setModel(model);
ui.resultsTable->horizontalHeader()->setStretchLastSection(true);
ui.resultsTable->horizontalHeader()->setSectionResizeMode(QHeaderView::Stretch);
}
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;
}
// Function to deleting record from table
bool creatordialog::delete_record(QSqlRelationalTableModel* rmodel)
{
int row_to_delete;
QModelIndexList selectedList = ui->tableView_CREATOR_1->selectionModel()->selectedRows();
for( int i=0; i<selectedList.count(); i++)
{
row_to_delete=selectedList.at(i).row();
}
if(selectedList.isEmpty())
{
QMessageBox::information(this,"Informacja","Nie zaznaczono wiersza do usunięcia.");
return false;
}
QSqlQueryModel model;
model.setQuery("SELECT * FROM "+relational_table_2+"");
int id_first = model.data(model.index(row_to_delete, 0)).toInt();
int id_second = model.data(model.index(row_to_delete, 1)).toInt();
QSqlQuery query;
if(relational_table_2=="Maszyny_has_Daneosobowe") {
query.prepare("Delete from Maszyny_has_Daneosobowe where idMaszyny_MaszynyDaneosobowe=:first_id and idDaneosobowe_MaszynyDaneosobowe=:second_id");
}
else if(relational_table_2=="Maszyny_has_Czesci") {
query.prepare("Delete from Maszyny_has_Czesci where idMaszyny_MaszynyCzesci=:first_id and idCzesci_MaszynyCzesci=:second_id");
}
query.bindValue(":first_id", id_first);
query.bindValue(":second_id", id_second);
if(query.exec())
{
QMessageBox::information(this,"Informacja","USUNIĘTO");
rmodel->select();
count=false;
return true;
}
else
{
QMessageBox::information(this,"Informacja",query.lastError().text());
return false;
}
}
void discount_dispose::on_pushButton_13_clicked()//确定
{
this->close();
if(n_func::gs_operid != "0000")
{
QSqlQueryModel model;
model.setQuery(QString("Select int_discount from cey_sys_operator where vch_operID ='%1' and ch_flag = 'Y' ").arg(n_func::gs_operid));
int operdis = model.record(0).value(0).toInt();
if(operdis > ui->lineEdit->text().toInt())
{
if(0==lds_messagebox::warning(this, tr("消息提示"),tr("指定操作员没有该折扣权限!"),tr("确认"),tr("取消")))
{
power_oper oper;
/*oper.exec();*/backheader::static_dialogexec(oper, tr("权限核实"));
if(oper.btn_t_f == true)
{
if(oper.operid != "0000")
{
model.clear();
model.setQuery(QString("Select int_discount from cey_sys_operator where vch_operID ='%1' and ch_flag = 'Y' ").arg(oper.operid));
int zhe = model.record(0).value(0).toInt();
if(zhe > ui->lineEdit->text().toInt())
{
;
lds_messagebox::warning(this, tr("消息提示"),tr("指定操作员没有该折扣权限!"));
return;
}
}
}
else
{
return;
}
}
else
{
return;
}
}
}
zhekouzhi = ui->lineEdit->text().toFloat();
btn_t_f = true;
}
void LoginDialog::login()
{
if (QSqlDatabase::database().open()) // megpróbáljuk megnyitni az adatbázis-kapcsolatot
{
QSqlQueryModel* model = new QSqlQueryModel();
model->setQuery("select user_id, name, password, level from user where user_id = '" + userNameEdit->text() + "' and password = '******'");
// lekérdezés model a megadott adatokra
if (model->rowCount() > 0 &&
model->index(0, 0).data() == userNameEdit->text() &&
model->index(0, 2).data() == userPasswordEdit->text())
// ha sikerült a bejelentkeztetés
{
QMessageBox::information(this,
trUtf8("Sikeres bejelentkezés!"),
trUtf8("Üdvözöljük, ") + model->index(0, 1).data().toString());
mainWindow = new MainWindow(model->index(0, 3).data().toInt());
mainWindow->show(); // megnyitjuk a főablakot
delete model;
close(); // és bezárjuk a bejelentkeztető ablakot
}
else
{
QMessageBox::information(this,
trUtf8("Sikertelen bejelentkezés!"),
trUtf8("Kérem ellenőrizze a felhasználónevet és a jelszót!"));
delete model;
}
}
else
{
QMessageBox::information(this,
trUtf8("Sikertelen bejelentkezés!"),
trUtf8("Az adatbázis nem elérhető!\nLépjen kapcsolatba az adminisztrátorral!"));
}
}
bool QueryHolder::runQuery(IDataSource::DatasourceMode mode)
{
m_mode = mode;
QSqlDatabase db = QSqlDatabase::database(m_connectionName);
if (!db.isValid()) {
setLastError(QObject::tr("Invalid connection! %1").arg(m_connectionName));
return false;
}
if (!m_prepared){
extractParams();
if (!m_prepared) return false;
}
if (!m_query){
m_query = new QSqlQuery(db);
m_query->prepare(m_preparedSQL);
}
fillParams(m_query);
m_query->exec();
QSqlQueryModel *model = new QSqlQueryModel;
model->setQuery(*m_query);
while (model->canFetchMore())
model->fetchMore();
if (model->lastError().isValid()){
if (m_dataSource)
m_dataSource.clear();
setLastError(model->lastError().text());
delete model;
return false;
} else setLastError("");
setDatasource(IDataSource::Ptr(new ModelToDataSource(model,true)));
return true;
}
