From 01879e2d0f951ff37ba56df695668d16548070a7 Mon Sep 17 00:00:00 2001
From: wumu <mayi@mayi.com>
Date: 星期五, 19 一月 2024 22:44:43 +0800
Subject: [PATCH] 0119
---
internal_system_v1/searchinfo.cpp | 55 +++++++++++++++++++++++++++++++++++++++++++++----------
1 files changed, 45 insertions(+), 10 deletions(-)
diff --git a/internal_system_v1/searchinfo.cpp b/internal_system_v1/searchinfo.cpp
index 4d2c9d9..95fb771 100644
--- a/internal_system_v1/searchinfo.cpp
+++ b/internal_system_v1/searchinfo.cpp
@@ -18,12 +18,14 @@
// ui->dateTimeEdit->hide();
// ui->dateTimeEdit_2->hide();
+ ui->dateEdit_end->setDate(QDate::currentDate());
+
m_model = new QStandardItemModel(this);
ui->tableView->setModel(m_model);
ui->tableView->verticalHeader()->setVisible(false); // 闅愯棌琛屽ご
m_model->setColumnCount(5);
QStringList labels;
- labels<<"ID"<<"鎸囨爣鍚嶇О"<<"浠ｇ爜"<<"鏁伴噺"<<"鍏徃缂栧彿";
+ labels<<"ID"<<"鎸囨爣鍚嶇О"<<"浠ｇ爜"<<"鏁伴噺"<<"鍏徃缂栧彿"<<"瀹¤鏃堕棿";
m_model->setHorizontalHeaderLabels(labels);
if(QSqlDatabase::contains("qt_sql_default_connection")){
m_db = QSqlDatabase::addDatabase("qt_sql_default_connection");
@@ -143,7 +145,8 @@
code TEXT,\
num INTEGER,\
evidences TEXT,\
- com_id INTEGER\
+ com_id INTEGER,\
+ time TEXT\
)").arg(tableName);
QSqlQuery query;
if(query.exec(sql))
@@ -161,7 +164,8 @@
kpi_name TEXT,\
code TEXT,\
num INTEGER,\
- com_id INTEGER\
+ com_id INTEGER,\
+ time TEXT\
)").arg(tableName);
QSqlQuery query;
if(query.exec(sql))
@@ -180,7 +184,8 @@
code TEXT,\
unit TEXT,\
num INTEGER,\
- com_id INTEGER\
+ com_id INTEGER,\
+ time TEXT\
)").arg(tableName);
QSqlQuery query;
if(query.exec(sql))
@@ -229,9 +234,9 @@
void SearchInfo::setLabels()
{
QStringList labels,labels2,labels3;
- labels<<"ID"<<"鎸囨爣鍚嶇О"<<"浠ｇ爜"<<"鏁伴噺"<<"鍏徃缂栧彿"<<" ";
- labels2<<"ID"<<"鎸囨爣鍚嶇О"<<"浠ｇ爜"<<"鍗曚綅"<<"鏁伴噺"<<"鍏徃缂栧彿";
- labels3<<"ID"<<"鎸囨爣鍚嶇О"<<"浠ｇ爜"<<"鏁伴噺"<<"浣愯瘉"<<"鍏徃缂栧彿";
+ labels<<"ID"<<"鎸囨爣鍚嶇О"<<"浠ｇ爜"<<"鏁伴噺"<<"鍏徃缂栧彿"<<"瀹¤鏃堕棿"<<" ";
+ labels2<<"ID"<<"鎸囨爣鍚嶇О"<<"浠ｇ爜"<<"鍗曚綅"<<"鏁伴噺"<<"鍏徃缂栧彿"<<"瀹¤鏃堕棿";
+ labels3<<"ID"<<"鎸囨爣鍚嶇О"<<"浠ｇ爜"<<"鏁伴噺"<<"浣愯瘉"<<"鍏徃缂栧彿"<<"瀹¤鏃堕棿";
m_labels["瀹¤椤圭洰"] = labels;
m_labels["鍐呭宸ヤ綔閲�"] = labels;
m_labels["闂閲戦"] = labels3;
@@ -248,6 +253,11 @@
QString item = ui->comboBox->currentText();
QString comName = ui->comboBox_company->currentText();
QString sql = QString("select * from %1 where com_id=%2").arg(m_itemAndTable[item]).arg(m_comInfo[comName]);
+ if(ui->checkBox->isChecked()){ // 鍕鹃�変箣鍚�
+ sql = QString("select * from %1 where com_id=%2 and time between '%3' and '%4'").arg(m_itemAndTable[item]).arg(m_comInfo[comName])
+ .arg(ui->dateEdit_begin->date().toString("yyyy-MM-dd"))
+ .arg(ui->dateEdit_end->date().toString("yyyy-MM-dd"));
+ }
qDebug()<<__FUNCTION__<<sql;
QSqlQuery query;
if(query.exec(sql)){
@@ -258,7 +268,7 @@
rowCnt++;
m_model->setRowCount(rowCnt);
qDebug()<<query.value(0).toInt();
- for(int i=0;i<6;++i){
+ for(int i=0;i<7;++i){
if(query.value(i).isValid()){
m_model->setItem(rowCnt-1,i,new QStandardItem(query.value(i).toString()));
}
@@ -403,7 +413,7 @@
}
//wb->dynamicCall("Save()"); // 鑻ユ枃浠跺凡瀛樺湪锛屽垯鐩存帴淇濆瓨
//wb->dynamicCall("SaveAs(const QString&)", str); // 淇濆瓨宸ヤ綔绨匡紝鑻ユ枃浠朵笉瀛樺湪锛屽垯甯﹀悕瀛椾繚瀛�
- if(ui->lineEdit_excel_save->text() > 1){
+ if(ui->lineEdit_excel_save->text().size() > 1){
wb->dynamicCall("SaveAs(const QString&)", ui->lineEdit_excel_save->text()); // 淇濆瓨宸ヤ綔绨匡紝鑻ユ枃浠朵笉瀛樺湪锛屽垯甯﹀悕瀛椾繚瀛�
qDebug()<<"淇濆瓨鍒版柊鏂囦欢涓�";
}else{
@@ -420,7 +430,7 @@
void SearchInfo::on_comboBox_currentIndexChanged(const QString &arg1)
{
- m_model->setHorizontalHeaderLabels(m_labels[arg1]);
+ m_model->setHorizontalHeaderLabels(m_labels[arg1]);
}
void SearchInfo::on_toolButton_seleceExcel_clicked()
@@ -435,3 +445,28 @@
QString newPath = paths.at(0)+"_"+ui->comboBox_company->currentText()+"."+paths.at(1);
ui->lineEdit_excel_save->setText(newPath);
}
+
+void SearchInfo::on_comboBox_company_currentIndexChanged(const QString &arg1)
+{
+ if(ui->lineEdit_excel_save->text().size() > 5){
+ QStringList paths = ui->label_excel_path->text().split(".");
+ QString newPath = paths.at(0)+"_"+arg1+"."+paths.at(1);
+ ui->lineEdit_excel_save->setText(newPath);
+ }
+}
+
+void SearchInfo::addComName(QString name)
+{
+ ui->comboBox_company->addItem(name);
+}
+
+void SearchInfo::on_checkBox_clicked()
+{
+ if(ui->checkBox->isChecked()){
+ ui->dateEdit_begin->setEnabled(true);
+ ui->dateEdit_end->setEnabled(true);
+ }else{
+ ui->dateEdit_begin->setEnabled(false);
+ ui->dateEdit_end->setEnabled(false);
+ }
+}
--
Gitblit v1.8.0