DataTableWidget.cpp 20 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530
  1. #include "DataTableWidget.h"
  2. #include "DataTableItemDelegate.h"
  3. #include "ProjectManager.h"
  4. #include <dbService/CNodeDataService.h>
  5. #include <dbService/ClassSet.h>
  6. #include <dbService/NodeMatrixService.h>
  7. #include <dbService/SchemeInfoService.h>
  8. #include <Widgets/Button.h>
  9. #include <QBoxLayout>
  10. #include <QTabWidget>
  11. #include <QLabel>
  12. #include <QTableView>
  13. #include <QTableWidget>
  14. #include <QAbstractItemModel>
  15. #include <QStandardItemModel>
  16. #include <QStandardItem>
  17. #include <QHeaderView>
  18. #include <QDebug>
  19. static const char *kDataTabName = "tabName";
  20. DataTableItemModel::DataTableItemModel(QObject *parent) : QStandardItemModel(parent) { }
  21. QVariant DataTableItemModel::data(const QModelIndex &index, int role) const
  22. {
  23. QVariant value = QStandardItemModel::data(index, role);
  24. if (Qt::TextAlignmentRole == role) {
  25. value = Qt::AlignCenter;
  26. }
  27. return value;
  28. }
  29. DataTableWidget::DataTableWidget(SchemePlanManager::SchemeProcessInfo process, QWidget *parent)
  30. : QWidget(parent), m_process(process)
  31. {
  32. m_mind1 = new CMind(this);
  33. m_mind2 = new CMind(this);
  34. initWidget();
  35. initLayout();
  36. connectSignalsAndSlots();
  37. m_comboDelegate = new DataTableComboDelegate(this);
  38. }
  39. SchemePlanManager::SchemeProcessInfo DataTableWidget::process() const
  40. {
  41. return m_process;
  42. }
  43. void DataTableWidget::initWidget()
  44. {
  45. m_dataTab = new QTabWidget(this);
  46. m_dataTab->setTabPosition(QTabWidget::South);
  47. m_pageLab = new QLabel(this);
  48. m_previous = new PushButton("上一级指标", this);
  49. m_next = new PushButton("下一级指标", this);
  50. }
  51. void DataTableWidget::initLayout()
  52. {
  53. m_layout = new QVBoxLayout(this);
  54. m_layout->addWidget(m_dataTab);
  55. m_pageLayout = new QHBoxLayout();
  56. m_layout->addLayout(m_pageLayout);
  57. m_pageLayout->setSpacing(10);
  58. m_pageLayout->addStretch();
  59. m_pageLayout->addWidget(m_previous);
  60. m_pageLayout->addWidget(m_pageLab);
  61. m_pageLayout->addWidget(m_next);
  62. m_pageLayout->addStretch();
  63. }
  64. void DataTableWidget::connectSignalsAndSlots()
  65. {
  66. connect(m_previous, &PushButton::clicked, this, &DataTableWidget::slotPrevious);
  67. connect(m_next, &PushButton::clicked, this, &DataTableWidget::slotNext);
  68. connect(m_dataTab, &QTabWidget::currentChanged, this, &DataTableWidget::slotTabCurrentChanged);
  69. }
  70. void DataTableWidget::setupModels()
  71. {
  72. // 按照脑图层级创建各个表的 models
  73. m_models.clear();
  74. QList<CNodeData> hHeaders;
  75. QList<CNodeData> vHeaders;
  76. for (int i = 1; i < m_mind1->levels(); i++) {
  77. QList<DataTableItemModel *> modelList;
  78. // 方案优选和综合效能的评估数据采集页面只有一级, 不用切换页面
  79. // 方案优选显示指标量纲和指标类型
  80. // 综合效能显示指标类型
  81. if (m_process.type == SchemePlanManager::ImportEvalData
  82. && (m_process.indexType == ProjectManager::OptimalIndex
  83. || m_process.indexType == ProjectManager::EfficiencyIndex)) {
  84. DataTableItemModel *model = new DataTableItemModel(this);
  85. int hIndex = -1;
  86. QStandardItem *item = new QStandardItem("指标量纲");
  87. model->setHorizontalHeaderItem(++hIndex, item);
  88. vHeaders = m_mind1->leaves();
  89. for (int j = 0; j < vHeaders.count(); j++) {
  90. CNodeData node = vHeaders[j];
  91. QStandardItem *item = new QStandardItem();
  92. item->setEditable(false);
  93. item->setText(node.dimension);
  94. model->setItem(j, hIndex, item);
  95. }
  96. if (m_process.indexType == ProjectManager::OptimalIndex) {
  97. QStandardItem *item = new QStandardItem("指标类型");
  98. model->setHorizontalHeaderItem(++hIndex, item);
  99. for (int k = 0; k < vHeaders.count(); k++) {
  100. CNodeData node = vHeaders[k];
  101. QStandardItem *item = new QStandardItem();
  102. // item->setEditable(false);
  103. item->setText("效益型");
  104. model->setItem(k, hIndex, item);
  105. }
  106. }
  107. updateModel(model, hHeaders, vHeaders, hIndex);
  108. hIndex += hHeaders.size();
  109. QList<SchemaEval *> schemeList;
  110. if (m_process.indexType == ProjectManager::EfficiencyIndex) {
  111. SchemeInfoService().QuerySchemeInfoByEngineerId(&schemeList, m_process.projectId, 1);
  112. }
  113. if (m_process.indexType == ProjectManager::OptimalIndex) {
  114. SchemeInfoService().QuerySchemeInfoByEngineerId(&schemeList, m_process.projectId, 0);
  115. }
  116. if (schemeList.count() > 0) {
  117. for (SchemaEval *scheme : schemeList) {
  118. QStandardItem *item = new QStandardItem(scheme->name);
  119. model->setHorizontalHeaderItem(++hIndex, item);
  120. for (QString indexValue : scheme->valueStr.split(";")) {
  121. QStringList indexAndValue = indexValue.split(":");
  122. if (indexAndValue.size() < 2) {
  123. continue;
  124. }
  125. for (int l = 0; l < model->rowCount(); l++) {
  126. QStandardItem *hHeader = model->verticalHeaderItem(l);
  127. if (hHeader->text() == indexAndValue.first()) {
  128. QStandardItem *item = new QStandardItem(indexAndValue.last());
  129. model->setItem(l, hIndex, item);
  130. }
  131. }
  132. }
  133. }
  134. }
  135. modelList.append(model);
  136. m_models[i] = modelList;
  137. break;
  138. }
  139. QList<CNodeData> nodes = m_mind1->nodesInLevel(i);
  140. for (int j = 0; j < nodes.count(); j++) {
  141. CNodeData node = nodes[j];
  142. DataTableItemModel *model = new DataTableItemModel(this);
  143. if (m_process.type == SchemePlanManager::ImportWeightData) {
  144. hHeaders = m_mind1->subNodes(node);
  145. if (m_process.dSource == SchemePlanManager::FromExpert) {
  146. vHeaders = hHeaders;
  147. }
  148. }
  149. if (m_process.type == SchemePlanManager::ImportEvalData) {
  150. if (m_process.indexType == ProjectManager::TechIndex) {
  151. hHeaders = m_mind1->subNodes(node);
  152. vHeaders = m_mind2->leaves();
  153. }
  154. }
  155. model->setProperty(kDataTabName, node.name);
  156. updateModel(model, hHeaders, vHeaders);
  157. modelList.append(model);
  158. }
  159. m_models[i] = modelList;
  160. }
  161. setCurrentPage(1);
  162. addTestMesureData();
  163. }
  164. void DataTableWidget::setupTabWidget()
  165. {
  166. m_dataTab->clear();
  167. QList<DataTableItemModel *> list = m_models[m_currentPage];
  168. for (int j = 0; j < list.size(); j++) {
  169. DataTableItemModel *model = list[j];
  170. QTableView *t = new QTableView(m_dataTab);
  171. t->setAlternatingRowColors(m_mind2->nodeList().count() > 0);
  172. t->horizontalHeader()->setSectionResizeMode(QHeaderView::Stretch);
  173. t->horizontalHeader()->setStyleSheet("QHeaderView::section{background:rgb(244,244,244);color: black;}");
  174. t->verticalHeader()->setStyleSheet("QHeaderView::section{background:rgb(244,244,244);color: black;}");
  175. t->verticalHeader()->setDefaultAlignment(Qt::AlignCenter);
  176. t->setSelectionMode(QAbstractItemView::SingleSelection);
  177. t->setModel(model);
  178. m_dataTab->addTab(t, model->property(kDataTabName).toString());
  179. if (m_process.type == SchemePlanManager::ImportEvalData
  180. && m_process.indexType == ProjectManager::OptimalIndex) {
  181. t->setItemDelegateForColumn(1, m_comboDelegate);
  182. }
  183. }
  184. }
  185. int DataTableWidget::currentPage() const
  186. {
  187. return m_currentPage;
  188. }
  189. void DataTableWidget::setCurrentPage(int p)
  190. {
  191. if (p < 1 || p > m_models.size()) {
  192. return;
  193. }
  194. m_currentPage = p;
  195. m_previous->setEnabled(p > 1);
  196. m_next->setEnabled(p < m_models.size());
  197. setupTabWidget();
  198. m_pageLab->setText(QString("共 %1 页, 当前第 %2 页").arg(m_models.size()).arg(p));
  199. }
  200. void DataTableWidget::updateCurrentTable()
  201. {
  202. return;
  203. int c = m_dataTab->currentIndex();
  204. QTableView *table = (QTableView *)m_dataTab->widget(c);
  205. if (table == nullptr || table->model() == nullptr || m_isSettingTable) {
  206. return;
  207. }
  208. QStandardItemModel *model = (QStandardItemModel *)table->model();
  209. /// 设置顶部水平方向标题
  210. int hIndex = -1;
  211. int dimensionIndex = -1; // 量纲所在列
  212. int typeIndex = -1; // 指标类型所在列
  213. // 指标
  214. CNodeData n = m_mind1->nodesInLevel(m_currentPage)[c];
  215. QList<CNodeData> hList = m_mind1->subNodes(n);
  216. // 以下情况需要显示指标
  217. // 导入权重分析数据
  218. // 导入需求分析评估的评估数据
  219. if (m_process.type == SchemePlanManager::ImportWeightData || m_process.indexType == ProjectManager::TechIndex) {
  220. for (CNodeData node : hList) {
  221. QStandardItem *item = new QStandardItem(node.name);
  222. item->setToolTip(node.remark);
  223. model->setHorizontalHeaderItem(++hIndex, item);
  224. }
  225. }
  226. // 导入方案优选评估或效能评估的评估数据时, 需要显示量纲
  227. if (m_process.type == SchemePlanManager::ImportEvalData
  228. && (m_process.indexType == ProjectManager::OptimalIndex
  229. || m_process.indexType == ProjectManager::EfficiencyIndex)) {
  230. QStandardItem *item = new QStandardItem("指标量纲");
  231. model->setHorizontalHeaderItem(++hIndex, item);
  232. dimensionIndex = hIndex;
  233. }
  234. // 导入方案优选评估的评估数据时, 需要显示指标类型
  235. if (m_process.type == SchemePlanManager::ImportEvalData && m_process.indexType == ProjectManager::OptimalIndex) {
  236. QStandardItem *item = new QStandardItem("指标类型");
  237. model->setHorizontalHeaderItem(++hIndex, item);
  238. typeIndex = hIndex;
  239. }
  240. /// 设置左侧垂直方向标题
  241. QList<CNodeData> vList;
  242. // 导入权重分析的专家数据时, 显示指标
  243. if (m_process.type == SchemePlanManager::ImportWeightData && m_process.dSource == SchemePlanManager::FromExpert) {
  244. vList = hList;
  245. }
  246. // 导入评估数据时, 显示最后一级指标
  247. if (m_process.type == SchemePlanManager::ImportEvalData) {
  248. if (m_process.indexType == ProjectManager::TechIndex) {
  249. vList = m_mind2->leaves();
  250. } else {
  251. vList = m_mind1->leaves();
  252. }
  253. }
  254. for (int i = 0; i < vList.count(); i++) {
  255. CNodeData node = vList[i];
  256. QStandardItem *item = new QStandardItem(QString(" %1 ").arg(node.name));
  257. item->setToolTip(node.remark);
  258. model->setVerticalHeaderItem(i, item);
  259. table->setRowHeight(i, 35);
  260. }
  261. /// 填充量纲和指标类型
  262. for (int i = 0; i < vList.count(); i++) {
  263. CNodeData vNode = vList[i];
  264. QStandardItem *d = new QStandardItem();
  265. d->setData(Qt::AlignCenter, Qt::TextAlignmentRole); // 单元格文字居中
  266. if (dimensionIndex >= 0) {
  267. d->setText(vNode.dimension);
  268. model->setItem(i, dimensionIndex, d);
  269. }
  270. if (typeIndex >= 0) {
  271. model->setItem(i, typeIndex, d);
  272. table->setItemDelegateForColumn(typeIndex, m_comboDelegate);
  273. }
  274. table->setRowHeight(i, 35);
  275. }
  276. /// 填充单元格
  277. if (m_process.type == SchemePlanManager::ImportWeightData) {
  278. if (m_process.dSource == SchemePlanManager::FromExpert) {
  279. for (int i = 0; i < vList.count(); i++) {
  280. CNodeData vNode = vList[i];
  281. for (int j = 0; j < hList.count(); j++) {
  282. CNodeData hNode = hList[j];
  283. QStandardItem *item = new QStandardItem();
  284. item->setData(Qt::AlignCenter, Qt::TextAlignmentRole); // 单元格文字居中
  285. item->setBackground(QBrush(QColor("white")));
  286. for (NodeMatrixInfo *info : m_data) {
  287. if (info->abscissa.toInt() == hNode.id && info->ordinate.toInt() == vNode.id) {
  288. item->setText(info->nodeValue);
  289. model->setItem(i, j, item);
  290. break;
  291. }
  292. }
  293. }
  294. table->setRowHeight(i, 35);
  295. }
  296. } else if (m_process.dSource == SchemePlanManager::FromMeasurement) {
  297. int row = model->rowCount();
  298. for (int j = 0; j < hList.count(); j++) {
  299. CNodeData hNode = hList[j];
  300. QStandardItem *item = new QStandardItem();
  301. item->setData(Qt::AlignCenter, Qt::TextAlignmentRole); // 单元格文字居中
  302. item->setBackground(QBrush(QColor("white")));
  303. for (NodeMatrixInfo *info : m_data) {
  304. if (info->abscissa.toInt() == hNode.id) {
  305. item->setText(info->nodeValue);
  306. model->setItem(row, j, item);
  307. break;
  308. }
  309. }
  310. }
  311. }
  312. } else if (m_process.type == SchemePlanManager::ImportEvalData) {
  313. if (m_process.indexType == ProjectManager::TechIndex) {
  314. for (int i = 0; i < vList.count(); i++) {
  315. CNodeData vNode = vList[i];
  316. for (int j = 0; j < hList.count(); j++) {
  317. CNodeData hNode = hList[j];
  318. QStandardItem *item = new QStandardItem();
  319. item->setData(Qt::AlignCenter, Qt::TextAlignmentRole); // 单元格文字居中
  320. item->setBackground(QBrush(QColor("white")));
  321. for (NodeMatrixInfo *info : m_data) {
  322. if (info->abscissa.toInt() == hNode.id && info->ordinate.toInt() == vNode.id) {
  323. item->setText(info->nodeValue);
  324. model->setItem(i, j, item);
  325. break;
  326. }
  327. }
  328. }
  329. table->setRowHeight(i, 35);
  330. }
  331. }
  332. }
  333. }
  334. void DataTableWidget::setSchemeList(const QList<SchemaEval *> &list) { }
  335. void DataTableWidget::addScheme(SchemaEval *scheme)
  336. {
  337. if (m_process.type == SchemePlanManager::ImportEvalData && m_process.indexType == ProjectManager::EfficiencyIndex) {
  338. }
  339. if (m_models.count() <= 0 || m_models[1].count() <= 0) {
  340. return;
  341. }
  342. DataTableItemModel *model = m_models[1].first();
  343. QStandardItem *item = new QStandardItem(scheme->name);
  344. model->setHorizontalHeaderItem(model->columnCount(), item);
  345. }
  346. QTabWidget *DataTableWidget::tabWidget() const
  347. {
  348. return m_dataTab;
  349. }
  350. CMind *DataTableWidget::mind1() const
  351. {
  352. return m_mind1;
  353. }
  354. CMind *DataTableWidget::mind2() const
  355. {
  356. return m_mind2;
  357. }
  358. void DataTableWidget::setNodeMatrixData(QList<NodeMatrixInfo *> data)
  359. {
  360. m_data = data;
  361. // 加载来自专家的权重分析数据
  362. if (m_process.type == SchemePlanManager::ImportWeightData && m_process.dSource == SchemePlanManager::FromExpert) {
  363. for (NodeMatrixInfo *info : data) {
  364. for (QList<DataTableItemModel *> modelList : m_models.values()) {
  365. for (DataTableItemModel *model : modelList) {
  366. for (int r = 0; r < model->rowCount(); r++) {
  367. QStandardItem *rHeader = model->verticalHeaderItem(r);
  368. for (int c = 0; c < model->columnCount(); c++) {
  369. QStandardItem *cHeader = model->horizontalHeaderItem(c);
  370. if (cHeader->text() == info->abscissa && rHeader->text() == info->ordinate) {
  371. QStandardItem *item = new QStandardItem();
  372. item->setText(info->nodeValue);
  373. item->setEditable(false);
  374. model->setItem(r, c, item);
  375. }
  376. }
  377. }
  378. }
  379. }
  380. }
  381. }
  382. // 加载技术重要度的评估数据
  383. if (m_process.type == SchemePlanManager::ImportEvalData && m_process.indexType == ProjectManager::TechIndex) {
  384. for (NodeMatrixInfo *info : data) {
  385. for (QList<DataTableItemModel *> modelList : m_models.values()) {
  386. for (DataTableItemModel *model : modelList) {
  387. for (int r = 0; r < model->rowCount(); r++) {
  388. QStandardItem *rHeader = model->verticalHeaderItem(r);
  389. for (int c = 0; c < model->columnCount(); c++) {
  390. QStandardItem *cHeader = model->horizontalHeaderItem(c);
  391. if (cHeader->text() == info->abscissa && rHeader->text() == info->ordinate) {
  392. QStandardItem *item = new QStandardItem();
  393. item->setText(info->nodeValue);
  394. model->setItem(r, c, item);
  395. }
  396. }
  397. }
  398. }
  399. }
  400. }
  401. }
  402. }
  403. void DataTableWidget::addTestMesureData()
  404. {
  405. bool rightPage = (m_process.type == SchemePlanManager::ImportWeightData
  406. && m_process.indexType == ProjectManager::OptimalIndex);
  407. bool rightProj = m_process.projectId == 126;
  408. if (!rightPage || !rightProj) {
  409. return;
  410. }
  411. double data[120] = { 4.1, 0.04, 0.19, 0.01, 0.36, 0.05, 3.9, 0.08, 0.38, 0.18, 0.19, 0.04, 5.9, 0.07, 0.23,
  412. 0.04, 0.36, 0.07, 4.9, 0.23, 1.03, 0.3, 1.4, 0.09, 4, 0.14, 0.57, 0.11, 1.12, 0.05,
  413. 6.1, 0.23, 1.19, 0.47, 0.93, 0.07, 8.2, 0.21, 0.88, 0.2, 0.97, 0.1, 6.5, 0.13, 0.8,
  414. 0.26, 0.52, 0.09, 7.5, 0.16, 1.28, 0.88, 0.8, 0.12, 6.8, 0.04, 0.17, 0.02, 0.24, 0.11,
  415. 7.4, 0.05, 0.33, 0.06, 0.39, 0.1, 5.7, 0.08, 0.6, 0.47, 0.46, 0.08, 2.4, 0.14, 0.23,
  416. 0.04, 0.94, 0.02, 2.2, 0.24, 0.35, 0.06, 1.78, 0.02, 1.9, 0.11, 0.3, 0.1, 0.5, 0.04,
  417. 1.8, 0.06, 0.28, 0.1, 0.29, 0.03, 15.9, 0.2, 1.05, 0.21, 1.84, 0.12, 18.9, 0.09, 0.82,
  418. 0.34, 0.58, 0.36, 18.8, 0.12, 0.8, 0.39, 0.76, 0.26, 16.8, 0.27, 1.74, 1.51, 1.78, 0.32 };
  419. DataTableItemModel *model = m_models[1].first();
  420. for (int i = 0; i < 120; i++) {
  421. QString text = QString("%1").arg(data[i]);
  422. QStandardItem *item = new QStandardItem(text);
  423. item->setEditable(false);
  424. model->setItem(i / 6, i % 6, item);
  425. }
  426. }
  427. void DataTableWidget::updateModel(DataTableItemModel *model, QList<CNodeData> &hHeaders, QList<CNodeData> &vHeaders,
  428. int hStart, int vStart)
  429. {
  430. for (int i = 0; i < hHeaders.size(); i++) {
  431. CNodeData node = hHeaders[i];
  432. QStandardItem *item = new QStandardItem(node.name);
  433. item->setToolTip(node.remark);
  434. model->setHorizontalHeaderItem(i + hStart, item);
  435. }
  436. for (int i = 0; i < vHeaders.size(); i++) {
  437. CNodeData node = vHeaders[i];
  438. QStandardItem *item = new QStandardItem(node.name);
  439. item->setToolTip(node.remark);
  440. model->setVerticalHeaderItem(i + vStart, item);
  441. }
  442. }
  443. void DataTableWidget::slotPrevious()
  444. {
  445. setCurrentPage(m_currentPage - 1);
  446. }
  447. void DataTableWidget::slotNext()
  448. {
  449. setCurrentPage(m_currentPage + 1);
  450. }
  451. void DataTableWidget::slotTabCurrentChanged(int c)
  452. {
  453. Q_UNUSED(c)
  454. updateCurrentTable();
  455. }