Редакция 256 | Только различия | Не учитывать пробелы | Содержимое файла | Авторство | Последнее изменение | Открыть журнал | RSS
| Редакция 256 | Редакция 257 | ||
|---|---|---|---|
| 1 | #include "mainwindow.h"
|
1 | #include "mainwindow.h"
|
| 2 | #include "ui_mainwindow.h"
|
2 | #include "ui_mainwindow.h"
|
| 3 | 3 | ||
| 4 | //ïðîâåðêà
|
4 | //ïðîâåðêà
|
| 5 | 5 | ||
| 6 | void MainWindow::getDatabaseData(){ |
6 | void MainWindow::getDatabaseData(){ |
| 7 | int list_count; |
7 | int list_count; |
| 8 | ui->treeWidget_2->clear(); |
8 | ui->treeWidget_2->clear(); |
| 9 | if (rootItems.isEmpty()) return; |
9 | if (rootItems.isEmpty()) return; |
| 10 | 10 | ||
| 11 | 11 | ||
| 12 | 12 | ||
| 13 | list_count = rootItems.count(); |
13 | list_count = rootItems.count(); |
| 14 | 14 | ||
| 15 | for (int i=0; i < list_count; i++){ |
15 | for (int i=0; i < list_count; i++){ |
| 16 | 16 | ||
| 17 | buildTree(rootItems.at(i)); |
17 | buildTree(rootItems.at(i)); |
| 18 | 18 | ||
| 19 | }
|
19 | }
|
| 20 | 20 | ||
| 21 | }
|
21 | }
|
| 22 | 22 | ||
| 23 | void MainWindow::buildTree(QTreeWidgetItem * model_item){ |
23 | void MainWindow::buildTree(QTreeWidgetItem * model_item){ |
| 24 | 24 | ||
| 25 | 25 | ||
| 26 | 26 | ||
| 27 | 27 | ||
| 28 | QString model_name;
|
28 | QString model_name;
|
| 29 | QString rootClassID;
|
29 | QString rootClassID;
|
| 30 | QString rootClassInctance;
|
30 | QString rootClassInctance;
|
| 31 | QFont font;
|
31 | QFont font;
|
| 32 | 32 | ||
| 33 | QTreeWidgetItem * item; |
33 | QTreeWidgetItem * item; |
| 34 | model_name = model_item->text(0); |
34 | model_name = model_item->text(0); |
| 35 | if (model_item->checkState(0) == false) return; |
35 | if (model_item->checkState(0) == false) return; |
| 36 | 36 | ||
| 37 | //ui->treeWidget_2->clear();
|
37 | //ui->treeWidget_2->clear();
|
| 38 | //font.setWeight(20);
|
38 | //font.setWeight(20);
|
| 39 | font.setItalic(true); |
39 | font.setItalic(true); |
| 40 | item = new QTreeWidgetItem (ui->treeWidget_2); |
40 | item = new QTreeWidgetItem (ui->treeWidget_2); |
| 41 | item->setFont(0, font); |
41 | item->setFont(0, font); |
| 42 | item->setText(0, model_name); |
42 | item->setText(0, model_name); |
| 43 | item->setTextColor(0, Qt::darkGreen); |
43 | item->setTextColor(0, Qt::darkGreen); |
| 44 | root_items_list << item; // çàíîñèì â ñïèñîê êîðíåâûõ èòåìîâ |
44 | root_items_list << item; // çàíîñèì â ñïèñîê êîðíåâûõ èòåìîâ |
| 45 | 45 | ||
| 46 | if (!(model_item->childCount() > 0)) return; |
46 | if (!(model_item->childCount() > 0)) return; |
| 47 | 47 | ||
| 48 | rootClassID = model_item->child(0)->text(1); |
48 | rootClassID = model_item->child(0)->text(1); |
| 49 | rootClassInctance = getClassInctance(rootClassID); |
49 | rootClassInctance = getClassInctance(rootClassID); |
| 50 | 50 | ||
| 51 | 51 | ||
| 52 | if (model_item->child(0)->checkState(0)) // åñëè â ìîäåëè êîðíåâîé êëàññ âûáðàí äëÿ îòîáðàæåíèÿ (ñòîèò ãàëî÷êà), òî |
52 | if (model_item->child(0)->checkState(0)) // åñëè â ìîäåëè êîðíåâîé êëàññ âûáðàí äëÿ îòîáðàæåíèÿ (ñòîèò ãàëî÷êà), òî |
| 53 | {
|
53 | {
|
| 54 | ///// QTreeWidgetItem * item_tmp;
|
54 | ///// QTreeWidgetItem * item_tmp;
|
| 55 | ///// item_tmp = new QTreeWidgetItem(item); // â äåðåâå, îòîáðàæàþùåì îáúåêòû êëàññîâ, ñîçäàåì íîâûé óçåë
|
55 | ///// item_tmp = new QTreeWidgetItem(item); // â äåðåâå, îòîáðàæàþùåì îáúåêòû êëàññîâ, ñîçäàåì íîâûé óçåë
|
| 56 | ///// item_tmp->setText(0, model_item->child(0)->text(0)); // ñ íàçâàíèåì êëàññà
|
56 | ///// item_tmp->setText(0, model_item->child(0)->text(0)); // ñ íàçâàíèåì êëàññà
|
| 57 | 57 | ||
| 58 | //showClassObjects(item_tmp, model_item->child(0)); // è âûâîäèì âñå îáúåêòû äàííîãî êëàññà
|
58 | //showClassObjects(item_tmp, model_item->child(0)); // è âûâîäèì âñå îáúåêòû äàííîãî êëàññà
|
| 59 | 59 | ||
| 60 | ///// showObjects(item_tmp, model_item->child(0), tr(""));
|
60 | ///// showObjects(item_tmp, model_item->child(0), tr(""));
|
| 61 | showObjects(item, model_item->child(0), tr("")); |
61 | showObjects(item, model_item->child(0), tr("")); |
| 62 | }
|
62 | }
|
| 63 | 63 | ||
| 64 | 64 | ||
| 65 | /*****************************************************/
|
65 | /*****************************************************/
|
| 66 | 66 | ||
| 67 | 67 | ||
| 68 | }
|
68 | }
|
| 69 | 69 | ||
| 70 | 70 | ||
| 71 | // ïîëó÷àåì èìÿ òàáëèöû - õðàíèëèùà îáúåêòîâ êëàññà
|
71 | // ïîëó÷àåì èìÿ òàáëèöû - õðàíèëèùà îáúåêòîâ êëàññà
|
| 72 | QString MainWindow::getClassInctance(QString class_id){ |
72 | QString MainWindow::getClassInctance(QString class_id){ |
| 73 | QSqlQuery q;
|
73 | QSqlQuery q;
|
| 74 | QString sql_str;
|
74 | QString sql_str;
|
| 75 | QString result;
|
75 | QString result;
|
| 76 | QString classInctance;
|
76 | QString classInctance;
|
| 77 | int field_inctance; |
77 | int field_inctance; |
| 78 | bool ok; |
78 | bool ok; |
| 79 | sql_str = tr("select * " |
79 | sql_str = tr("select * " |
| 80 | " from ListOfClasses where ListOfClasses.ID = '" //îïðåäåëèì êëàññû, äëÿ êîòîðûõ êîðíåâîé ÿâëÿåòñÿ êîíòåéíåðîì |
80 | " from ListOfClasses where ListOfClasses.ID = '" //îïðåäåëèì êëàññû, äëÿ êîòîðûõ êîðíåâîé ÿâëÿåòñÿ êîíòåéíåðîì |
| 81 | ); |
81 | ); |
| 82 | sql_str.append(class_id); |
82 | sql_str.append(class_id); |
| 83 | sql_str.append(tr("'")); |
83 | sql_str.append(tr("'")); |
| 84 | q.prepare(sql_str); |
84 | q.prepare(sql_str); |
| 85 | 85 | ||
| 86 | ok = q.exec(); |
86 | ok = q.exec(); |
| 87 | if (!ok) { |
87 | if (!ok) { |
| 88 | QMessageBox::critical( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå. |
88 | QMessageBox::critical( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå. |
| 89 | this, // Ðîäèòåëüñêèé âèäæåò. |
89 | this, // Ðîäèòåëüñêèé âèäæåò. |
| 90 | QObject::tr("Database Error"), // Çàãîëîâîê. |
90 | QObject::tr("Database Error"), // Çàãîëîâîê. |
| 91 | q.lastError().text()); // Òåêñò ñîîáùåíèÿ. |
91 | q.lastError().text()); // Òåêñò ñîîáùåíèÿ. |
| 92 | return result; |
92 | return result; |
| 93 | }
|
93 | }
|
| 94 | field_inctance = q.record().indexOf(tr("TableWhithInstance")); |
94 | field_inctance = q.record().indexOf(tr("TableWhithInstance")); |
| 95 | while(q.next()){ |
95 | while(q.next()){ |
| 96 | 96 | ||
| 97 | classInctance = q.value(field_inctance).toString(); |
97 | classInctance = q.value(field_inctance).toString(); |
| 98 | result.append(classInctance); |
98 | result.append(classInctance); |
| 99 | }
|
99 | }
|
| 100 | 100 | ||
| 101 | return result; |
101 | return result; |
| 102 | 102 | ||
| 103 | }
|
103 | }
|
| 104 | 104 | ||
| 105 | void MainWindow::showClassObjects(QTreeWidgetItem * parent_item, QTreeWidgetItem * model_item){ |
105 | void MainWindow::showClassObjects(QTreeWidgetItem * parent_item, QTreeWidgetItem * model_item){ |
| 106 | QString classID; // èäåíòèôèêàòîð êëàññà |
106 | QString classID; // èäåíòèôèêàòîð êëàññà |
| 107 | QString inctance; // èìÿ òàáëèöû, õðàíèëèùà |
107 | QString inctance; // èìÿ òàáëèöû, õðàíèëèùà |
| 108 | QSqlQuery q;
|
108 | QSqlQuery q;
|
| 109 | QString sql_str;
|
109 | QString sql_str;
|
| 110 | QString str_tmp;
|
110 | QString str_tmp;
|
| 111 | bool ok; |
111 | bool ok; |
| 112 | int field_ID; |
112 | int field_ID; |
| 113 | int i; |
113 | int i; |
| 114 | QIcon icon;
|
114 | QIcon icon;
|
| 115 | classID = model_item->text(1); |
115 | classID = model_item->text(1); |
| 116 | inctance = getClassInctance(classID); |
116 | inctance = getClassInctance(classID); |
| 117 | icon = model_item->icon(0); |
117 | icon = model_item->icon(0); |
| 118 | sql_str = tr("select * " |
118 | sql_str = tr("select * " |
| 119 | " from " //íàõîäèì âñå îáúåêòû êëàññà â òàáëèöå - õðàíèëèùå îáúåêòîâ êëàññà |
119 | " from " //íàõîäèì âñå îáúåêòû êëàññà â òàáëèöå - õðàíèëèùå îáúåêòîâ êëàññà |
| 120 | ); |
120 | ); |
| 121 | sql_str.append(inctance); |
121 | sql_str.append(inctance); |
| 122 | q.prepare(sql_str); |
122 | q.prepare(sql_str); |
| 123 | 123 | ||
| 124 | ok = q.exec(); |
124 | ok = q.exec(); |
| 125 | if (!ok) { |
125 | if (!ok) { |
| 126 | QMessageBox::critical( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå. |
126 | QMessageBox::critical( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå. |
| 127 | this, // Ðîäèòåëüñêèé âèäæåò. |
127 | this, // Ðîäèòåëüñêèé âèäæåò. |
| 128 | QObject::tr("Database Error"), // Çàãîëîâîê. |
128 | QObject::tr("Database Error"), // Çàãîëîâîê. |
| 129 | q.lastError().text()); // Òåêñò ñîîáùåíèÿ. |
129 | q.lastError().text()); // Òåêñò ñîîáùåíèÿ. |
| 130 | return; |
130 | return; |
| 131 | }
|
131 | }
|
| 132 | 132 | ||
| 133 | field_ID = q.record().indexOf(tr("ID")); |
133 | field_ID = q.record().indexOf(tr("ID")); |
| 134 | 134 | ||
| 135 | 135 | ||
| 136 | while(q.next()){ |
136 | while(q.next()){ |
| 137 | if (q.record().count() > 1) |
137 | if (q.record().count() > 1) |
| 138 | {
|
138 | {
|
| 139 | QString value_tmp;
|
139 | QString value_tmp;
|
| 140 | QString ID_tmp;
|
140 | QString ID_tmp;
|
| 141 | QTreeWidgetItem * itm; |
141 | QTreeWidgetItem * itm; |
| 142 | ID_tmp = q.value(field_ID).toString(); // îïðåäåëÿåì èäåíòèôèêàòîð îáúåêòà |
142 | ID_tmp = q.value(field_ID).toString(); // îïðåäåëÿåì èäåíòèôèêàòîð îáúåêòà |
| 143 | value_tmp = q.value(1).toString(); // îïðåäåëÿåì èìÿ îáúåêòà (äîëæíî õðàíèòüñÿ â ïåðâîì ïîëå) |
143 | value_tmp = q.value(1).toString(); // îïðåäåëÿåì èìÿ îáúåêòà (äîëæíî õðàíèòüñÿ â ïåðâîì ïîëå) |
| 144 | itm = new QTreeWidgetItem(parent_item); // äîáàâëÿåì â äåðåâî óçåë, ñîîòâåòñòâóþùèé îáúåêòó |
144 | itm = new QTreeWidgetItem(parent_item); // äîáàâëÿåì â äåðåâî óçåë, ñîîòâåòñòâóþùèé îáúåêòó |
| 145 | itm->setText(0, value_tmp); |
145 | itm->setText(0, value_tmp); |
| 146 | 146 | ||
| 147 | itm->setIcon(0, icon); |
147 | itm->setIcon(0, icon); |
| 148 | 148 | ||
| 149 | for (int i; i < model_item->childCount(); i++) // ïðîâåðÿåì, åñòü ëè ó êëàññà äî÷åðíèå êëàññû |
149 | for (int i; i < model_item->childCount(); i++) // ïðîâåðÿåì, åñòü ëè ó êëàññà äî÷åðíèå êëàññû |
| 150 | {
|
150 | {
|
| 151 | QTreeWidgetItem * model_item_tmp; // åñëè åñòü |
151 | QTreeWidgetItem * model_item_tmp; // åñëè åñòü |
| 152 | model_item_tmp = model_item->child(i); // îòîáðàæàåì îáúåêòû äî÷åðíèõ êëàññîâ |
152 | model_item_tmp = model_item->child(i); // îòîáðàæàåì îáúåêòû äî÷åðíèõ êëàññîâ |
| 153 | MainWindow::showObjectChildrens(ID_tmp, itm, model_item_tmp); |
153 | MainWindow::showObjectChildrens(ID_tmp, itm, model_item_tmp); |
| 154 | 154 | ||
| 155 | }
|
155 | }
|
| 156 | }
|
156 | }
|
| 157 | 157 | ||
| 158 | }
|
158 | }
|
| 159 | 159 | ||
| 160 | 160 | ||
| 161 | i++; |
161 | i++; |
| 162 | }
|
162 | }
|
| 163 | 163 | ||
| 164 | 164 | ||
| 165 | 165 | ||
| 166 | void MainWindow::showObjectChildrens(QString object_ID, QTreeWidgetItem * object_item, QTreeWidgetItem * model_item){ // îòîáðàçèì îáúåêòû êëàññîâà |
166 | void MainWindow::showObjectChildrens(QString object_ID, QTreeWidgetItem * object_item, QTreeWidgetItem * model_item){ // îòîáðàçèì îáúåêòû êëàññîâà |
| 167 | 167 | ||
| 168 | QString classID; // èäåíòèôèêàòîð êëàññà |
168 | QString classID; // èäåíòèôèêàòîð êëàññà |
| 169 | 169 | ||
| 170 | QString inctance; // èìÿ òàáëèöû, õðàíèëèùà |
170 | QString inctance; // èìÿ òàáëèöû, õðàíèëèùà |
| 171 | QSqlQuery q;
|
171 | QSqlQuery q;
|
| 172 | QString sql_str;
|
172 | QString sql_str;
|
| 173 | QString str_tmp;
|
173 | QString str_tmp;
|
| 174 | bool ok; |
174 | bool ok; |
| 175 | classID = model_item->text(1); |
175 | classID = model_item->text(1); |
| 176 | inctance = getClassInctance(classID); |
176 | inctance = getClassInctance(classID); |
| 177 | 177 | ||
| 178 | sql_str = tr("select * " |
178 | sql_str = tr("select * " |
| 179 | " from '" //íàõîäèì âñå îáúåêòû êëàññà â òàáëèöå - õðàíèëèùå îáúåêòîâ êëàññà |
179 | " from '" //íàõîäèì âñå îáúåêòû êëàññà â òàáëèöå - õðàíèëèùå îáúåêòîâ êëàññà |
| 180 | ); |
180 | ); |
| 181 | sql_str.append(inctance); |
181 | sql_str.append(inctance); |
| 182 | sql_str.append(tr("' where ")); |
182 | sql_str.append(tr("' where ")); |
| 183 | 183 | ||
| 184 | 184 | ||
| 185 | q.prepare(sql_str); |
185 | q.prepare(sql_str); |
| 186 | 186 | ||
| 187 | ok = q.exec(); |
187 | ok = q.exec(); |
| 188 | if (!ok) { |
188 | if (!ok) { |
| 189 | QMessageBox::critical( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå. |
189 | QMessageBox::critical( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå. |
| 190 | this, // Ðîäèòåëüñêèé âèäæåò. |
190 | this, // Ðîäèòåëüñêèé âèäæåò. |
| 191 | QObject::tr("Database Error"), // Çàãîëîâîê. |
191 | QObject::tr("Database Error"), // Çàãîëîâîê. |
| 192 | q.lastError().text()); // Òåêñò ñîîáùåíèÿ. |
192 | q.lastError().text()); // Òåêñò ñîîáùåíèÿ. |
| 193 | return; |
193 | return; |
| 194 | }
|
194 | }
|
| 195 | }
|
195 | }
|
| 196 | 196 | ||
| 197 | 197 | ||
| 198 | 198 | ||
| 199 | //
|
199 | //
|
| 200 | void MainWindow::showObjects(QTreeWidgetItem * parent_object_item, QTreeWidgetItem * model_item, QString filtr){ |
200 | void MainWindow::showObjects(QTreeWidgetItem * parent_object_item, QTreeWidgetItem * model_item, QString filtr){ |
| 201 | QString classID; // èäåíòèôèêàòîð êëàññà |
201 | QString classID; // èäåíòèôèêàòîð êëàññà |
| 202 | QString parentClassID; // èäåíòèôèêàòîð ðîäèòåëüñêîãî êëàññà |
202 | QString parentClassID; // èäåíòèôèêàòîð ðîäèòåëüñêîãî êëàññà |
| 203 | QString pointerField; // èìÿ ïîëÿ-óêàçàòåëÿ íà ðîäèòåëüñêèé êëàññ |
203 | QString pointerField; // èìÿ ïîëÿ-óêàçàòåëÿ íà ðîäèòåëüñêèé êëàññ |
| 204 | QString inctance; // èìÿ òàáëèöû, õðàíèëèùà |
204 | QString inctance; // èìÿ òàáëèöû, õðàíèëèùà |
| 205 | QString className; // èìÿ êëàññà |
205 | QString className; // èìÿ êëàññà |
| 206 | QString modelID; // èäåíòèôèêàòîð ìîäåëè |
206 | QString modelID; // èäåíòèôèêàòîð ìîäåëè |
| 207 | QString add_filtr; // äîïîëíèòåëüíûé ôèëüòð |
207 | QString add_filtr; // äîïîëíèòåëüíûé ôèëüòð |
| 208 | int field_ID; |
208 | int field_ID; |
| 209 | int icon_field_index; |
209 | int icon_field_index; |
| 210 | bool filtr_empty; |
210 | bool filtr_empty; |
| 211 | bool ok; |
211 | bool ok; |
| 212 | QSqlQuery q;
|
212 | QSqlQuery q;
|
| 213 | QString sql_str;
|
213 | QString sql_str;
|
| 214 | QString str_tmp;
|
214 | QString str_tmp;
|
| 215 | QTreeWidgetItem * title_item; |
215 | QTreeWidgetItem * title_item; |
| 216 | QFont font;
|
216 | QFont font;
|
| 217 | QIcon icon;
|
217 | QIcon icon;
|
| 218 | // font.setWeight(40);
|
218 | // font.setWeight(40);
|
| 219 | font.setBold(true); |
219 | font.setBold(true); |
| 220 | filtr_empty = filtr.isEmpty(); |
220 | filtr_empty = filtr.isEmpty(); |
| 221 | 221 | ||
| 222 | classID = model_item->text(1); |
222 | classID = model_item->text(1); |
| 223 | modelID = model_item->text(6); |
223 | modelID = model_item->text(6); |
| 224 | add_filtr = MainWindow::getFiltrString(modelID, classID); |
224 | add_filtr = MainWindow::getFiltrString(modelID, classID); |
| 225 | 225 | ||
| 226 | 226 | ||
| 227 | icon = model_item->icon(0); |
227 | icon = model_item->icon(0); |
| 228 | 228 | ||
| 229 | parentClassID = model_item->parent()->text(1); |
229 | parentClassID = model_item->parent()->text(1); |
| 230 | 230 | ||
| 231 | pointerField = getPointerFieldName(parentClassID, classID); |
231 | pointerField = getPointerFieldName(parentClassID, classID); |
| 232 | 232 | ||
| 233 | className = model_item->text(0); |
233 | className = model_item->text(0); |
| 234 | inctance = getClassInctance(classID); |
234 | inctance = getClassInctance(classID); |
| 235 | 235 | ||
| 236 | if (!model_item->checkState(0)) return; |
236 | if (!model_item->checkState(0)) return; |
| 237 | 237 | ||
| 238 | title_item = new QTreeWidgetItem(parent_object_item); |
238 | title_item = new QTreeWidgetItem(parent_object_item); |
| 239 | title_item->setFont(0, font); |
239 | title_item->setFont(0, font); |
| 240 | title_item->setText(0, className); |
240 | title_item->setText(0, className); |
| 241 | title_item->setText(1, tr("class")); |
241 | title_item->setText(1, tr("class")); |
| 242 | title_item->setText(2, classID); |
242 | title_item->setText(2, classID); |
| 243 | title_item->setText(3, inctance); |
243 | title_item->setText(3, inctance); |
| 244 | title_item->setText(4, pointerField); |
244 | title_item->setText(4, pointerField); |
| 245 | title_item->setText(5, add_filtr); // çàïîìíèì ôèëüòð äëÿ êëàññà â äåðåâå ñ äàííûìè |
245 | title_item->setText(5, add_filtr); // çàïîìíèì ôèëüòð äëÿ êëàññà â äåðåâå ñ äàííûìè |
| 246 | title_item->setTextColor(0, Qt::darkBlue); |
246 | title_item->setTextColor(0, Qt::darkBlue); |
| 247 | 247 | ||
| 248 | title_item->setIcon(0, icon); |
248 | title_item->setIcon(0, icon); |
| 249 | 249 | ||
| 250 | 250 | ||
| 251 | sql_str = tr("select * " |
251 | sql_str = tr("select * " |
| 252 | " from " //íàõîäèì âñå îáúåêòû êëàññà â òàáëèöå - õðàíèëèùå îáúåêòîâ êëàññà |
252 | " from " //íàõîäèì âñå îáúåêòû êëàññà â òàáëèöå - õðàíèëèùå îáúåêòîâ êëàññà |
| 253 | ); |
253 | ); |
| 254 | sql_str.append(inctance); |
254 | sql_str.append(inctance); |
| 255 | 255 | ||
| 256 | 256 | ||
| 257 | if (filtr.isEmpty() && (!add_filtr.isEmpty())) // ôèëüòð ïóñòîé, äîïîëíèòåëüíûé ôèëüòð íå ïóñòîé |
257 | if (filtr.isEmpty() && (!add_filtr.isEmpty())) // ôèëüòð ïóñòîé, äîïîëíèòåëüíûé ôèëüòð íå ïóñòîé |
| 258 | {
|
258 | {
|
| 259 | filtr.append(tr ("where ")); |
259 | filtr.append(tr ("where ")); |
| 260 | filtr.append(add_filtr); |
260 | filtr.append(add_filtr); |
| 261 | }
|
261 | }
|
| 262 | 262 | ||
| 263 | 263 | ||
| 264 | if (!filtr.isEmpty()) { // åñëè ôèëüòð íå ïóñòîé |
264 | if (!filtr.isEmpty()) { // åñëè ôèëüòð íå ïóñòîé |
| 265 | sql_str.append(tr(" ")); |
265 | sql_str.append(tr(" ")); |
| 266 | sql_str.append(filtr); // äîáàâëÿåì â çàïðîñ ôèëüòð |
266 | sql_str.append(filtr); // äîáàâëÿåì â çàïðîñ ôèëüòð |
| 267 | }
|
267 | }
|
| 268 | 268 | ||
| 269 | q.prepare(sql_str); |
269 | q.prepare(sql_str); |
| 270 | 270 | ||
| 271 | ok = q.exec(); |
271 | ok = q.exec(); |
| 272 | if (!ok) { |
272 | if (!ok) { |
| 273 | QString debug_str;
|
273 | QString debug_str;
|
| 274 | debug_str.append(tr("ôóí showObjects(): Database Error ")); |
274 | debug_str.append(tr("ôóí showObjects(): Database Error ")); |
| 275 | debug_str.append(tr(" õð: ")); |
275 | debug_str.append(tr(" õð: ")); |
| 276 | debug_str.append(inctance); |
276 | debug_str.append(inctance); |
| 277 | debug_str.append(tr(" ô: ")); |
277 | debug_str.append(tr(" ô: ")); |
| 278 | debug_str.append(filtr); |
278 | debug_str.append(filtr); |
| 279 | debug_str.append(q.lastError().text()); |
279 | debug_str.append(q.lastError().text()); |
| 280 | QMessageBox::critical( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå. |
280 | QMessageBox::critical( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå. |
| 281 | this, // Ðîäèòåëüñêèé âèäæåò. |
281 | this, // Ðîäèòåëüñêèé âèäæåò. |
| 282 | QObject::tr("ôóíêöèÿ showObjects(): Database Error"), // Çàãîëîâîê. |
282 | QObject::tr("ôóíêöèÿ showObjects(): Database Error"), // Çàãîëîâîê. |
| 283 | debug_str |
283 | debug_str |
| 284 | // q.lastError().text()
|
284 | // q.lastError().text()
|
| 285 | ); // Òåêñò ñîîáùåíèÿ. |
285 | ); // Òåêñò ñîîáùåíèÿ. |
| 286 | return; |
286 | return; |
| 287 | }
|
287 | }
|
| 288 | 288 | ||
| 289 | field_ID = q.record().indexOf(tr("ID")); |
289 | field_ID = q.record().indexOf(tr("ID")); |
| 290 | 290 | ||
| 291 | icon_field_index = q.record().indexOf(tr("Icon")); |
291 | icon_field_index = q.record().indexOf(tr("Icon")); |
| 292 | /*
|
292 | /*
|
| 293 | if (q.size() <= 0) return;
|
293 | if (q.size() <= 0) return;
|
| 294 | title_item = new QTreeWidgetItem(parent_object_item);
|
294 | title_item = new QTreeWidgetItem(parent_object_item);
|
| 295 | title_item->setFont(0, font);
|
295 | title_item->setFont(0, font);
|
| 296 | title_item->setText(0, className);
|
296 | title_item->setText(0, className);
|
| 297 | */
|
297 | */
|
| 298 | 298 | ||
| 299 | while(q.next()){ |
299 | while(q.next()){ |
| 300 | if (q.record().count() > 1) |
300 | if (q.record().count() > 1) |
| 301 | {
|
301 | {
|
| 302 | QString value_tmp;
|
302 | QString value_tmp;
|
| 303 | QString ID_tmp;
|
303 | QString ID_tmp;
|
| 304 | QTreeWidgetItem * itm; |
304 | QTreeWidgetItem * itm; |
| 305 | ID_tmp = q.value(field_ID).toString(); // îïðåäåëÿåì èäåíòèôèêàòîð îáúåêòà |
305 | ID_tmp = q.value(field_ID).toString(); // îïðåäåëÿåì èäåíòèôèêàòîð îáúåêòà |
| 306 | value_tmp = q.value(1).toString(); // îïðåäåëÿåì èìÿ îáúåêòà (äîëæíî õðàíèòüñÿ â ïåðâîì ïîëå) |
306 | value_tmp = q.value(1).toString(); // îïðåäåëÿåì èìÿ îáúåêòà (äîëæíî õðàíèòüñÿ â ïåðâîì ïîëå) |
| 307 | // itm = new QTreeWidgetItem(parent_object_item); // äîáàâëÿåì â äåðåâî óçåë, ñîîòâåòñòâóþùèé îáúåêòó
|
307 | // itm = new QTreeWidgetItem(parent_object_item); // äîáàâëÿåì â äåðåâî óçåë, ñîîòâåòñòâóþùèé îáúåêòó
|
| 308 | itm = new QTreeWidgetItem(title_item); // äîáàâëÿåì â äåðåâî óçåë, ñîîòâåòñòâóþùèé îáúåêòó |
308 | itm = new QTreeWidgetItem(title_item); // äîáàâëÿåì â äåðåâî óçåë, ñîîòâåòñòâóþùèé îáúåêòó |
| 309 | itm->setText(0, value_tmp); |
309 | itm->setText(0, value_tmp); |
| 310 | itm->setText(1, tr("object")); |
310 | itm->setText(1, tr("object")); |
| 311 | itm->setText(2, ID_tmp); |
311 | itm->setText(2, ID_tmp); |
| 312 | 312 | ||
| 313 | 313 | ||
| 314 | if (icon_field_index != -1){ // åñëè èìååòñÿ ïîëå ñ èêîíêàìè |
314 | if (icon_field_index != -1){ // åñëè èìååòñÿ ïîëå ñ èêîíêàìè |
| 315 | QVariant data;
|
315 | QVariant data;
|
| 316 | QByteArray bytes;
|
316 | QByteArray bytes;
|
| 317 | QPixmap pix;
|
317 | QPixmap pix;
|
| 318 | QIcon icn;
|
318 | QIcon icn;
|
| 319 | QMap <QString, QPixmap> pixmap_map; |
319 | QMap <QString, QPixmap> pixmap_map; |
| 320 | QList <QString> id_list; |
320 | QList <QString> id_list; |
| 321 | QList <QPixmap> pixmap_list; |
321 | QList <QPixmap> pixmap_list; |
| 322 | pixmap_map = MainWindow::getObjectsIcon(inctance); |
322 | pixmap_map = MainWindow::getObjectsIcon(inctance); |
| 323 | if (!pixmap_map.isEmpty()) { |
323 | if (!pixmap_map.isEmpty()) { |
| 324 | id_list = pixmap_map.keys(); |
324 | id_list = pixmap_map.keys(); |
| 325 | pixmap_list = pixmap_map.values(); |
325 | pixmap_list = pixmap_map.values(); |
| 326 | }
|
326 | }
|
| 327 | if (id_list.indexOf(ID_tmp) != -1) { |
327 | if (id_list.indexOf(ID_tmp) != -1) { |
| 328 | pix = pixmap_list.at(id_list.indexOf(ID_tmp)); |
328 | pix = pixmap_list.at(id_list.indexOf(ID_tmp)); |
| 329 | }
|
329 | }
|
| 330 | // data = q.record().value(icon_field_index);
|
330 | // data = q.record().value(icon_field_index);
|
| 331 | // bytes = q.record().value(icon_field_index).toByteArray();
|
331 | // bytes = q.record().value(icon_field_index).toByteArray();
|
| 332 | // if (data.isValid() && (!data.isNull())) {
|
332 | // if (data.isValid() && (!data.isNull())) {
|
| 333 | // if (!bytes.isEmpty()){
|
333 | // if (!bytes.isEmpty()){
|
| 334 | // pix.loadFromData(data.toByteArray());
|
334 | // pix.loadFromData(data.toByteArray());
|
| 335 | // pix.loadFromData(bytes);
|
335 | // pix.loadFromData(bytes);
|
| 336 | if (pix.height() > 128) pix = pix.scaledToHeight(128); |
336 | if (pix.height() > 128) pix = pix.scaledToHeight(128); |
| 337 | icn.addPixmap(pix); |
337 | icn.addPixmap(pix); |
| 338 | itm->setIcon(0, icn); |
338 | itm->setIcon(0, icn); |
| 339 | // }
|
339 | // }
|
| 340 | 340 | ||
| 341 | 341 | ||
| 342 | 342 | ||
| 343 | }
|
343 | }
|
| 344 | 344 | ||
| 345 | 345 | ||
| 346 | 346 | ||
| 347 | // itm->setIcon(0, icon);
|
347 | // itm->setIcon(0, icon);
|
| 348 | 348 | ||
| 349 | 349 | ||
| 350 | for (int i=0; i < model_item->childCount(); i++) // ïðîâåðÿåì, åñòü ëè ó êëàññà äî÷åðíèå êëàññû |
350 | for (int i=0; i < model_item->childCount(); i++) // ïðîâåðÿåì, åñòü ëè ó êëàññà äî÷åðíèå êëàññû |
| 351 | {
|
351 | {
|
| 352 | QTreeWidgetItem * model_item_tmp; // åñëè åñòü |
352 | QTreeWidgetItem * model_item_tmp; // åñëè åñòü |
| 353 | QString pointer_name;
|
353 | QString pointer_name;
|
| 354 | QString filtr_tmp;
|
354 | QString filtr_tmp;
|
| 355 | bool pointer_isEmpty; |
355 | bool pointer_isEmpty; |
| 356 | model_item_tmp = model_item->child(i); // îòîáðàæàåì îáúåêòû äî÷åðíèõ êëàññîâ |
356 | model_item_tmp = model_item->child(i); // îòîáðàæàåì îáúåêòû äî÷åðíèõ êëàññîâ |
| 357 | pointer_name = getPointerFieldName(classID, model_item->child(i)->text(1)); |
357 | pointer_name = getPointerFieldName(classID, model_item->child(i)->text(1)); |
| 358 | itm->setText(4, pointer_name); |
358 | itm->setText(4, pointer_name); |
| 359 | 359 | ||
| 360 | // title_item->setText(4, pointer_name);
|
360 | // title_item->setText(4, pointer_name);
|
| 361 | 361 | ||
| 362 | 362 | ||
| 363 | pointer_isEmpty = pointer_name.isEmpty(); |
363 | pointer_isEmpty = pointer_name.isEmpty(); |
| 364 | filtr_tmp = tr("where "); |
364 | filtr_tmp = tr("where "); |
| 365 | filtr_tmp.append(tr("`")); |
365 | filtr_tmp.append(tr("`")); |
| 366 | filtr_tmp.append(pointer_name); |
366 | filtr_tmp.append(pointer_name); |
| 367 | filtr_tmp.append(tr("` = '")); |
367 | filtr_tmp.append(tr("` = '")); |
| 368 | filtr_tmp.append(ID_tmp); |
368 | filtr_tmp.append(ID_tmp); |
| 369 | filtr_tmp.append(tr("'")); |
369 | filtr_tmp.append(tr("'")); |
| 370 | showObjects(itm, model_item_tmp, filtr_tmp); |
370 | showObjects(itm, model_item_tmp, filtr_tmp); |
| 371 | //MainWindow::showObjectChildrens(ID_tmp, itm, model_item_tmp);
|
371 | //MainWindow::showObjectChildrens(ID_tmp, itm, model_item_tmp);
|
| 372 | 372 | ||
| 373 | }
|
373 | }
|
| 374 | 374 | ||
| 375 | 375 | ||
| 376 | }
|
376 | }
|
| 377 | 377 | ||
| 378 | }
|
378 | }
|
| 379 | 379 | ||
| 380 | 380 | ||
| 381 | 381 | ||
| 382 | 382 | ||
| 383 | for (int i; i < model_item->childCount(); i++) // ïðîâåðÿåì, åñòü ëè ó êëàññà äî÷åðíèå êëàññû |
383 | for (int i; i < model_item->childCount(); i++) // ïðîâåðÿåì, åñòü ëè ó êëàññà äî÷åðíèå êëàññû |
| 384 | {
|
384 | {
|
| 385 | 385 | ||
| 386 | 386 | ||
| 387 | }
|
387 | }
|
| 388 | 388 | ||
| 389 | }
|
389 | }
|
| 390 | 390 | ||
| 391 | 391 | ||
| 392 | QString MainWindow::getPointerFieldName(QString parent_class_id, QString chield_class_id){ |
392 | QString MainWindow::getPointerFieldName(QString parent_class_id, QString chield_class_id){ |
| 393 | 393 | ||
| 394 | QSqlQuery q;
|
394 | QSqlQuery q;
|
| 395 | QString sql_str;
|
395 | QString sql_str;
|
| 396 | QString str_tmp;
|
396 | QString str_tmp;
|
| 397 | QString field;
|
397 | QString field;
|
| 398 | QString result;
|
398 | QString result;
|
| 399 | int field_name; |
399 | int field_name; |
| 400 | bool ok; |
400 | bool ok; |
| 401 | sql_str = tr("select * " |
401 | sql_str = tr("select * " |
| 402 | " from `DescriptionOfClasses` where `DescriptionOfClasses`.`FieldType` = 'pointer' and `DescriptionOfClasses`.`DefaultValue` = " //íàõîäèì âñå îáúåêòû êëàññà â òàáëèöå - õðàíèëèùå îáúåêòîâ êëàññà |
402 | " from `DescriptionOfClasses` where `DescriptionOfClasses`.`FieldType` = 'pointer' and `DescriptionOfClasses`.`DefaultValue` = " //íàõîäèì âñå îáúåêòû êëàññà â òàáëèöå - õðàíèëèùå îáúåêòîâ êëàññà |
| 403 | ); |
403 | ); |
| 404 | 404 | ||
| 405 | sql_str.append(tr("'")); |
405 | sql_str.append(tr("'")); |
| 406 | sql_str.append(parent_class_id); |
406 | sql_str.append(parent_class_id); |
| 407 | sql_str.append(tr("' ")); |
407 | sql_str.append(tr("' ")); |
| 408 | sql_str.append(tr(" and `DescriptionOfClasses`.`ClassIdentifer` = '")); |
408 | sql_str.append(tr(" and `DescriptionOfClasses`.`ClassIdentifer` = '")); |
| 409 | sql_str.append(chield_class_id); |
409 | sql_str.append(chield_class_id); |
| 410 | sql_str.append(tr("'")); |
410 | sql_str.append(tr("'")); |
| 411 | q.prepare(sql_str); |
411 | q.prepare(sql_str); |
| 412 | 412 | ||
| 413 | ok = q.exec(); |
413 | ok = q.exec(); |
| 414 | if (!ok) { |
414 | if (!ok) { |
| 415 | QMessageBox::critical( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå. |
415 | QMessageBox::critical( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå. |
| 416 | this, // Ðîäèòåëüñêèé âèäæåò. |
416 | this, // Ðîäèòåëüñêèé âèäæåò. |
| 417 | QObject::tr("Database Error"), // Çàãîëîâîê. |
417 | QObject::tr("Database Error"), // Çàãîëîâîê. |
| 418 | q.lastError().text()); // Òåêñò ñîîáùåíèÿ. |
418 | q.lastError().text()); // Òåêñò ñîîáùåíèÿ. |
| 419 | return result; |
419 | return result; |
| 420 | }
|
420 | }
|
| 421 | field_name = q.record().indexOf(tr("FieldName")); |
421 | field_name = q.record().indexOf(tr("FieldName")); |
| 422 | while(q.next()){ |
422 | while(q.next()){ |
| 423 | result = q.value(field_name).toString(); |
423 | result = q.value(field_name).toString(); |
| 424 | }
|
424 | }
|
| 425 | return result; |
425 | return result; |
| 426 | }
|
426 | }
|
| 427 | 427 | ||
| 428 | 428 | ||
| 429 | 429 | ||
| 430 | void MainWindow::on_treeWidget_2_itemClicked ( QTreeWidgetItem * item, int column ){ |
430 | void MainWindow::on_treeWidget_2_itemClicked ( QTreeWidgetItem * item, int column ){ |
| 431 | QString item_type; // òèï óçëà (èìÿ êëàññà èäè îáúåêò) |
431 | QString item_type; // òèï óçëà (èìÿ êëàññà èäè îáúåêò) |
| 432 | QString parent_object_id;
|
432 | QString parent_object_id;
|
| 433 | int i; |
433 | int i; |
| 434 | QTreeWidgetItem * parent_item; |
434 | QTreeWidgetItem * parent_item; |
| 435 | item_type = item->text(1); |
435 | item_type = item->text(1); |
| 436 | parent_item = item->parent(); |
436 | parent_item = item->parent(); |
| 437 | 437 | ||
| 438 | QString class_id; // èäåíòèôèêàòîð âûáðàííîãî êëàññà |
438 | QString class_id; // èäåíòèôèêàòîð âûáðàííîãî êëàññà |
| 439 | QString inctance;
|
439 | QString inctance;
|
| 440 | QString filtr_tmp;
|
440 | QString filtr_tmp;
|
| 441 | QMap <QString, QString> pointersList; |
441 | QMap <QString, QString> pointersList; |
| 442 | QStringList dateFieldList; // ñïèñîê èìåí ïîëåé ñ òèïîì "DATE" |
442 | QStringList dateFieldList; // ñïèñîê èìåí ïîëåé ñ òèïîì "DATE" |
| 443 | QStringList boolFieldList; // ñïèñîê èìåí ïîëåé ñ òèïîì "BOOL" |
443 | QStringList boolFieldList; // ñïèñîê èìåí ïîëåé ñ òèïîì "BOOL" |
| 444 | QStringList fileFieldList; // ñïèñîê èìåí ïîëåé, â êîòîðûõ õðàíÿòñÿ ôàéëû |
444 | QStringList fileFieldList; // ñïèñîê èìåí ïîëåé, â êîòîðûõ õðàíÿòñÿ ôàéëû |
| 445 | QString pointer_name; // ñïèñîê èìåí ïîëåé |
445 | QString pointer_name; // ñïèñîê èìåí ïîëåé |
| 446 | 446 | ||
| 447 | if (item_type == tr("object") || item_type == tr("class")){ |
447 | if (item_type == tr("object") || item_type == tr("class")){ |
| 448 | 448 | ||
| 449 | disconnect(sql_mogel, SIGNAL(dataChanged(QModelIndex,QModelIndex)), this, SLOT(on_sql_mogel_dataChanged(QModelIndex,QModelIndex))); |
449 | disconnect(sql_mogel, SIGNAL(dataChanged(QModelIndex,QModelIndex)), this, SLOT(on_sql_mogel_dataChanged(QModelIndex,QModelIndex))); |
| 450 | 450 | ||
| 451 | static QList<int> colomns_indexes; // ñïèñîê íîìåðîâ ñòîëáöîâ òàáëèöû ñ íåñòàíäàðòíûìè äåëåãàòàìè |
451 | static QList<int> colomns_indexes; // ñïèñîê íîìåðîâ ñòîëáöîâ òàáëèöû ñ íåñòàíäàðòíûìè äåëåãàòàìè |
| 452 | static QList<int> date_colomns_indexes; // ñïèñîê íîìåðîâ ñòîëáöîâ òàáëèöû ñ äåëåãàòàìè äëÿ òèïà "DATE" |
452 | static QList<int> date_colomns_indexes; // ñïèñîê íîìåðîâ ñòîëáöîâ òàáëèöû ñ äåëåãàòàìè äëÿ òèïà "DATE" |
| 453 | static QList <int> bool_colomns_indexes; // ñïèñîê íîìåðîâ ñòîëáöîâ òàáëèöû ñ äåëåãàòàìè äëÿ òèïà "BOOL" |
453 | static QList <int> bool_colomns_indexes; // ñïèñîê íîìåðîâ ñòîëáöîâ òàáëèöû ñ äåëåãàòàìè äëÿ òèïà "BOOL" |
| 454 | static QList <int> file_colomns_indexes; // ñïèñîê íîìåðîâ ñòîëáöîâ òàáëèöû, â êîòîðûõ õðàíÿòüñÿ ôàéëû |
454 | static QList <int> file_colomns_indexes; // ñïèñîê íîìåðîâ ñòîëáöîâ òàáëèöû, â êîòîðûõ õðàíÿòüñÿ ôàéëû |
| 455 | 455 | ||
| 456 | static QList<SpinBoxDelegate *> spin_delegate_list;// ñïèñîê óêàçàòåëåé íà íåñòàíäàðòíûå äåëåãàòû |
456 | static QList<SpinBoxDelegate *> spin_delegate_list;// ñïèñîê óêàçàòåëåé íà íåñòàíäàðòíûå äåëåãàòû |
| 457 | static int icon_index = -1; // èíäåêñ ñòîëáöà ñ èêîíêàìè |
457 | static int icon_index = -1; // èíäåêñ ñòîëáöà ñ èêîíêàìè |
| 458 | 458 | ||
| 459 | 459 | ||
| 460 | SpinBoxDelegate * spin_delegate_tmp; |
460 | SpinBoxDelegate * spin_delegate_tmp; |
| 461 | 461 | ||
| 462 | // Ñïåðâà "î÷èñòèì" òàáëèöó îò íåñòàíäàðòíûõ äåëåãàòîâ
|
462 | // Ñïåðâà "î÷èñòèì" òàáëèöó îò íåñòàíäàðòíûõ äåëåãàòîâ
|
| 463 | 463 | ||
| 464 | if (icon_index != -1) { |
464 | if (icon_index != -1) { |
| 465 | ui->tableView->setItemDelegateForColumn(icon_index, &standart_delegate); // è ïðèñâàèâàåì ñòàíäàðòíûé äåëåãàò |
465 | ui->tableView->setItemDelegateForColumn(icon_index, &standart_delegate); // è ïðèñâàèâàåì ñòàíäàðòíûé äåëåãàò |
| 466 | icon_index = -1; |
466 | icon_index = -1; |
| 467 | }
|
467 | }
|
| 468 | 468 | ||
| 469 | for (i=0; i < colomns_indexes.size(); i++){ // äëÿ âñåõ ïîëåé-óêàçàòåëåé: |
469 | for (i=0; i < colomns_indexes.size(); i++){ // äëÿ âñåõ ïîëåé-óêàçàòåëåé: |
| 470 | ui->tableView->setItemDelegateForColumn(colomns_indexes.at(i), &standart_delegate ); // è ïðèñâàèâàåì ñòàíäàðòíûé äåëåãàò |
470 | ui->tableView->setItemDelegateForColumn(colomns_indexes.at(i), &standart_delegate ); // è ïðèñâàèâàåì ñòàíäàðòíûé äåëåãàò |
| 471 | // ui->tableView->setItemDelegateForColumn(colomns_indexes.at(i), &picture_delegate);
|
471 | // ui->tableView->setItemDelegateForColumn(colomns_indexes.at(i), &picture_delegate);
|
| 472 | 472 | ||
| 473 | }
|
473 | }
|
| 474 | colomns_indexes.clear(); // î÷èùàåì ñïèñîê ñòîëáöîâ ñ íåñòàíäàðòíûìè äåëåãàòàìè |
474 | colomns_indexes.clear(); // î÷èùàåì ñïèñîê ñòîëáöîâ ñ íåñòàíäàðòíûìè äåëåãàòàìè |
| 475 | 475 | ||
| 476 | 476 | ||
| 477 | // "Î÷èñòèì" òàáëèöó îò äåëåãàòîâ äëÿ õðàíåíèÿ ôàéëîâ
|
477 | // "Î÷èñòèì" òàáëèöó îò äåëåãàòîâ äëÿ õðàíåíèÿ ôàéëîâ
|
| 478 | 478 | ||
| 479 | for (i=0; i < file_colomns_indexes.size(); i++){ // äëÿ âñåõ ïîëåé-óêàçàòåëåé: |
479 | for (i=0; i < file_colomns_indexes.size(); i++){ // äëÿ âñåõ ïîëåé-óêàçàòåëåé: |
| 480 | ui->tableView->setItemDelegateForColumn(file_colomns_indexes.at(i), &standart_delegate ); // è ïðèñâàèâàåì ñòàíäàðòíûé äåëåãàò |
480 | ui->tableView->setItemDelegateForColumn(file_colomns_indexes.at(i), &standart_delegate ); // è ïðèñâàèâàåì ñòàíäàðòíûé äåëåãàò |
| 481 | }
|
481 | }
|
| 482 | file_colomns_indexes.clear(); |
482 | file_colomns_indexes.clear(); |
| 483 | 483 | ||
| 484 | 484 | ||
| 485 | // "Î÷èñòèì" òàáëèöó îò äåëåãàòîâ äëÿ òèïà "DATE"
|
485 | // "Î÷èñòèì" òàáëèöó îò äåëåãàòîâ äëÿ òèïà "DATE"
|
| 486 | for (i=0; i < date_colomns_indexes.size(); i++){ // äëÿ âñåõ ïîëåé-óêàçàòåëåé: |
486 | for (i=0; i < date_colomns_indexes.size(); i++){ // äëÿ âñåõ ïîëåé-óêàçàòåëåé: |
| 487 | ui->tableView->setItemDelegateForColumn(date_colomns_indexes.at(i), &standart_delegate ); // è ïðèñâàèâàåì ñòàíäàðòíûé äåëåãàò |
487 | ui->tableView->setItemDelegateForColumn(date_colomns_indexes.at(i), &standart_delegate ); // è ïðèñâàèâàåì ñòàíäàðòíûé äåëåãàò |
| 488 | // ui->tableView->setItemDelegateForColumn(colomns_indexes.at(i), &picture_delegate);
|
488 | // ui->tableView->setItemDelegateForColumn(colomns_indexes.at(i), &picture_delegate);
|
| 489 | 489 | ||
| 490 | }
|
490 | }
|
| 491 | 491 | ||
| 492 | date_colomns_indexes.clear(); |
492 | date_colomns_indexes.clear(); |
| 493 | 493 | ||
| 494 | // "Î÷èñòèì" òàáëèöó îò äåëåãàòîâ äëÿ òèïà "BOOL"
|
494 | // "Î÷èñòèì" òàáëèöó îò äåëåãàòîâ äëÿ òèïà "BOOL"
|
| 495 | for (i=0; i < bool_colomns_indexes.size(); i++){ // äëÿ âñåõ ïîëåé-óêàçàòåëåé: |
495 | for (i=0; i < bool_colomns_indexes.size(); i++){ // äëÿ âñåõ ïîëåé-óêàçàòåëåé: |
| 496 | ui->tableView->setItemDelegateForColumn(bool_colomns_indexes.at(i), &standart_delegate ); // è ïðèñâàèâàåì ñòàíäàðòíûé äåëåãàò |
496 | ui->tableView->setItemDelegateForColumn(bool_colomns_indexes.at(i), &standart_delegate ); // è ïðèñâàèâàåì ñòàíäàðòíûé äåëåãàò |
| 497 | // ui->tableView->setItemDelegateForColumn(colomns_indexes.at(i), &picture_delegate);
|
497 | // ui->tableView->setItemDelegateForColumn(colomns_indexes.at(i), &picture_delegate);
|
| 498 | 498 | ||
| 499 | }
|
499 | }
|
| 500 | 500 | ||
| 501 | bool_colomns_indexes.clear(); |
501 | bool_colomns_indexes.clear(); |
| 502 | boolFieldsIndexes_global.clear(); |
502 | boolFieldsIndexes_global.clear(); |
| 503 | 503 | ||
| 504 | if (item_type == tr("object")) |
504 | if (item_type == tr("object")) |
| 505 | {
|
505 | {
|
| 506 | QString ID;
|
506 | QString ID;
|
| 507 | ui->pushButton->setEnabled(false); |
507 | ui->pushButton->setEnabled(false); |
| 508 | ui->pushButton_2->setEnabled(false); |
508 | ui->pushButton_2->setEnabled(false); |
| 509 | 509 | ||
| 510 | class_id = parent_item->text(2); |
510 | class_id = parent_item->text(2); |
| 511 | ID = item->text(2); |
511 | ID = item->text(2); |
| 512 | inctance = parent_item->text(3); |
512 | inctance = parent_item->text(3); |
| 513 | delete sql_mogel; |
513 | delete sql_mogel; |
| 514 | 514 | ||
| 515 | sql_mogel = new MyModel(); |
515 | sql_mogel = new MyModel(); |
| 516 | 516 | ||
| 517 | sql_mogel->setTable(inctance); |
517 | sql_mogel->setTable(inctance); |
| 518 | // sql_mogel->setEditStrategy(QSqlTableModel::OnFieldChange);
|
518 | // sql_mogel->setEditStrategy(QSqlTableModel::OnFieldChange);
|
| 519 | sql_mogel->setEditStrategy(QSqlTableModel::OnManualSubmit); |
519 | sql_mogel->setEditStrategy(QSqlTableModel::OnManualSubmit); |
| 520 | 520 | ||
| 521 | filtr_tmp.append(tr("`")); |
521 | filtr_tmp.append(tr("`")); |
| 522 | filtr_tmp.append(tr("ID")); |
522 | filtr_tmp.append(tr("ID")); |
| 523 | filtr_tmp.append(tr("`")); |
523 | filtr_tmp.append(tr("`")); |
| 524 | filtr_tmp.append(tr(" = '")); |
524 | filtr_tmp.append(tr(" = '")); |
| 525 | filtr_tmp.append(ID); |
525 | filtr_tmp.append(ID); |
| 526 | filtr_tmp.append(tr("'")); |
526 | filtr_tmp.append(tr("'")); |
| 527 | 527 | ||
| 528 | }
|
528 | }
|
| 529 | if (item_type == tr("class")) |
529 | if (item_type == tr("class")) |
| 530 | {
|
530 | {
|
| 531 | QString parent_object_id; // èäåíòèôèêàòîð ðîäèòåëüñêîãî îáúåêòà |
531 | QString parent_object_id; // èäåíòèôèêàòîð ðîäèòåëüñêîãî îáúåêòà |
| 532 | 532 | ||
| 533 | QString parent_class_inctance;
|
533 | QString parent_class_inctance;
|
| 534 | QString class_filter;
|
534 | QString class_filter;
|
| 535 | 535 | ||
| 536 | 536 | ||
| 537 | ui->pushButton->setEnabled(true); |
537 | ui->pushButton->setEnabled(true); |
| 538 | ui->pushButton_2->setEnabled(true); |
538 | ui->pushButton_2->setEnabled(true); |
| 539 | 539 | ||
| 540 | parent_object_id = parent_item->text(2); |
540 | parent_object_id = parent_item->text(2); |
| 541 | 541 | ||
| 542 | parentObject_id = parent_item->text(2); |
542 | parentObject_id = parent_item->text(2); |
| 543 | 543 | ||
| 544 | class_id = item->text(2); |
544 | class_id = item->text(2); |
| 545 | inctance = item->text(3); |
545 | inctance = item->text(3); |
| 546 | class_filter = item->text(5); |
546 | class_filter = item->text(5); |
| 547 | 547 | ||
| 548 | pointer_name = item->text(4); |
548 | pointer_name = item->text(4); |
| 549 | delete sql_mogel; |
549 | delete sql_mogel; |
| 550 | 550 | ||
| 551 | sql_mogel = new MyModel(); |
551 | sql_mogel = new MyModel(); |
| 552 | 552 | ||
| 553 | // sql_mogel = new QSqlTableModel(this);
|
553 | // sql_mogel = new QSqlTableModel(this);
|
| 554 | sql_mogel->setTable(inctance); |
554 | sql_mogel->setTable(inctance); |
| 555 | // sql_mogel->setEditStrategy(QSqlTableModel::OnFieldChange);
|
555 | // sql_mogel->setEditStrategy(QSqlTableModel::OnFieldChange);
|
| 556 | sql_mogel->setEditStrategy(QSqlTableModel::OnManualSubmit); |
556 | sql_mogel->setEditStrategy(QSqlTableModel::OnManualSubmit); |
| 557 | 557 | ||
| 558 | if (!parent_object_id.isEmpty()) |
558 | if (!parent_object_id.isEmpty()) |
| 559 | {
|
559 | {
|
| 560 | filtr_tmp.append(tr("`")); |
560 | filtr_tmp.append(tr("`")); |
| 561 | filtr_tmp.append(pointer_name); |
561 | filtr_tmp.append(pointer_name); |
| 562 | filtr_tmp.append(tr("`")); |
562 | filtr_tmp.append(tr("`")); |
| 563 | filtr_tmp.append(tr(" = '")); |
563 | filtr_tmp.append(tr(" = '")); |
| 564 | filtr_tmp.append(parent_object_id); |
564 | filtr_tmp.append(parent_object_id); |
| 565 | filtr_tmp.append(tr("'")); |
565 | filtr_tmp.append(tr("'")); |
| 566 | 566 | ||
| 567 | 567 | ||
| 568 | if (!class_filter.isEmpty()) // åñëè ôèëüòð äëÿ êëàññà íå ïóñòîé |
568 | if (!class_filter.isEmpty()) // åñëè ôèëüòð äëÿ êëàññà íå ïóñòîé |
| 569 | {
|
569 | {
|
| 570 | filtr_tmp.append(tr(" and ")); |
570 | filtr_tmp.append(tr(" and ")); |
| 571 | filtr_tmp.append(class_filter); // äîáàâèì è ôèëüòð äëÿ êëàññà (êîòîðûé óêàçûâàëè â äåðåâå ìîäåëåé) |
571 | filtr_tmp.append(class_filter); // äîáàâèì è ôèëüòð äëÿ êëàññà (êîòîðûé óêàçûâàëè â äåðåâå ìîäåëåé) |
| 572 | 572 | ||
| 573 | }
|
573 | }
|
| 574 | 574 | ||
| 575 | 575 | ||
| 576 | 576 | ||
| 577 | 577 | ||
| 578 | }
|
578 | }
|
| 579 | else if(!class_filter.isEmpty()) // åñëè ôèëüòð äëÿ êëàññà íå ïóñòîé, à ôèëüòð ïóñòîé |
579 | else if(!class_filter.isEmpty()) // åñëè ôèëüòð äëÿ êëàññà íå ïóñòîé, à ôèëüòð ïóñòîé |
| 580 | {
|
580 | {
|
| 581 | filtr_tmp.append(class_filter); // äîáàâèì è ôèëüòð äëÿ êëàññà (êîòîðûé óêàçûâàëè â äåðåâå ìîäåëåé) |
581 | filtr_tmp.append(class_filter); // äîáàâèì è ôèëüòð äëÿ êëàññà (êîòîðûé óêàçûâàëè â äåðåâå ìîäåëåé) |
| 582 | }
|
582 | }
|
| 583 | 583 | ||
| 584 | }
|
584 | }
|
| 585 | 585 | ||
| 586 | 586 | ||
| 587 | 587 | ||
| 588 | pointersList = getPointersList(class_id); // ïîëó÷àåì ñïèñîê ïîëåé-óêàçàòåëåé |
588 | pointersList = getPointersList(class_id); // ïîëó÷àåì ñïèñîê ïîëåé-óêàçàòåëåé |
| 589 | dateFieldList = getDataFieldList(class_id); // ïîëó÷àåì ñïèñîê ïîëåé c òèïîì "DATE" |
589 | dateFieldList = getDataFieldList(class_id); // ïîëó÷àåì ñïèñîê ïîëåé c òèïîì "DATE" |
| 590 | boolFieldList = getBoolFieldList(class_id); // ïîëó÷àåì ñïèñîê ïîëåé c òèïîì "BOOL" |
590 | boolFieldList = getBoolFieldList(class_id); // ïîëó÷àåì ñïèñîê ïîëåé c òèïîì "BOOL" |
| 591 | fileFieldList = getFileFieldList(class_id); // ïîëó÷àåì ñïèñîê ïîëåé, â êîòîðûõ õðàíÿòüñÿ ôàéëû |
591 | fileFieldList = getFileFieldList(class_id); // ïîëó÷àåì ñïèñîê ïîëåé, â êîòîðûõ õðàíÿòüñÿ ôàéëû |
| 592 | 592 | ||
| 593 | icon_index = getIconFieldIndex(inctance); // |
593 | icon_index = getIconFieldIndex(inctance); // |
| 594 | if (icon_index != -1) ui->tableView->setItemDelegateForColumn(icon_index, iconDelegate); |
594 | if (icon_index != -1) ui->tableView->setItemDelegateForColumn(icon_index, iconDelegate); |
| 595 | sql_mogel->setIconIndex(icon_index); |
595 | sql_mogel->setIconIndex(icon_index); |
| 596 | 596 | ||
| 597 | QMap <int, QString> pointersToModel; |
597 | QMap <int, QString> pointersToModel; |
| 598 | 598 | ||
| 599 | 599 | ||
| 600 | 600 | ||
| 601 | 601 | ||
| 602 | QMap <int, QString> filesFieldsToModel; |
602 | QMap <int, QString> filesFieldsToModel; |
| 603 | for (int i=0; i < fileFieldList.count(); i++){ // äëÿ âñåõ ïîëåé, õðàíÿùèõ ôàéëû |
603 | for (int i=0; i < fileFieldList.count(); i++){ // äëÿ âñåõ ïîëåé, õðàíÿùèõ ôàéëû |
| 604 | // static FileDelegate flDelegate;
|
604 | // static FileDelegate flDelegate;
|
| 605 | // static TimeEditDelegate dateDelegate("01.10.2010");
|
605 | // static TimeEditDelegate dateDelegate("01.10.2010");
|
| 606 | QString fileFieldName; // èìÿ ïîëÿ |
606 | QString fileFieldName; // èìÿ ïîëÿ |
| 607 | int fileFieldIndex; // |
607 | int fileFieldIndex; // |
| 608 | fileFieldName = fileFieldList.at(i); // îïðåäåëÿåì èìÿ ïîëÿ, õðàíÿùåãî ôàéë |
608 | fileFieldName = fileFieldList.at(i); // îïðåäåëÿåì èìÿ ïîëÿ, õðàíÿùåãî ôàéë |
| 609 | fileFieldIndex = sql_mogel->record().indexOf(fileFieldName); // îïðåäåëÿåì íîìåð ñòîëáöà â ìîäåëå |
609 | fileFieldIndex = sql_mogel->record().indexOf(fileFieldName); // îïðåäåëÿåì íîìåð ñòîëáöà â ìîäåëå |
| 610 | filesFieldsToModel.insert(fileFieldIndex, fileFieldName); |
610 | filesFieldsToModel.insert(fileFieldIndex, fileFieldName); |
| 611 | file_colomns_indexes.append(fileFieldIndex);// çàïîìíèì íîìåð ñòîëáöà ñ äåëåãàòîì äëÿ òèïà "file" |
611 | file_colomns_indexes.append(fileFieldIndex);// çàïîìíèì íîìåð ñòîëáöà ñ äåëåãàòîì äëÿ òèïà "file" |
| 612 | ui->tableView->setItemDelegateForColumn(fileFieldIndex, fileDelegate); |
612 | ui->tableView->setItemDelegateForColumn(fileFieldIndex, fileDelegate); |
| 613 | 613 | ||
| 614 | }
|
614 | }
|
| 615 | sql_mogel->setFilesFields(filesFieldsToModel);// ïåðåäàåì ìîäåëè ñâÿçàííûé ñïèñîê ñ íîìåðàìè è èìåíàìè ñòîëáöîâ, õðàíÿùèõ ôàéëû |
615 | sql_mogel->setFilesFields(filesFieldsToModel);// ïåðåäàåì ìîäåëè ñâÿçàííûé ñïèñîê ñ íîìåðàìè è èìåíàìè ñòîëáöîâ, õðàíÿùèõ ôàéëû |
| 616 | 616 | ||
| 617 | 617 | ||
| 618 | 618 | ||
| 619 | 619 | ||
| 620 | for (int i=0; i < dateFieldList.count(); i++){ // äëÿ âñåõ ïîëåé ñ òèïîì "DATA" |
620 | for (int i=0; i < dateFieldList.count(); i++){ // äëÿ âñåõ ïîëåé ñ òèïîì "DATA" |
| 621 | static MyDEDelegate dateDelegate; |
621 | static MyDEDelegate dateDelegate; |
| 622 | // static TimeEditDelegate dateDelegate("01.10.2010");
|
622 | // static TimeEditDelegate dateDelegate("01.10.2010");
|
| 623 | QString dateFieldName; // èìÿ ïîëÿ |
623 | QString dateFieldName; // èìÿ ïîëÿ |
| 624 | int dataFieldIndex; // |
624 | int dataFieldIndex; // |
| 625 | dateFieldName = dateFieldList.at(i); // îïðåäåëÿåì èìÿ ïîëÿ ñ òèïîì "DATA" |
625 | dateFieldName = dateFieldList.at(i); // îïðåäåëÿåì èìÿ ïîëÿ ñ òèïîì "DATA" |
| 626 | dataFieldIndex = sql_mogel->record().indexOf(dateFieldName); // îïðåäåëÿåì íîìåð ñòîëáöà â ìîäåëå |
626 | dataFieldIndex = sql_mogel->record().indexOf(dateFieldName); // îïðåäåëÿåì íîìåð ñòîëáöà â ìîäåëå |
| 627 | date_colomns_indexes.append(dataFieldIndex);// çàïîìíèì íîìåð ñòîëáöà ñ äåëåãàòîì äëÿ òèïà "DATA" |
627 | date_colomns_indexes.append(dataFieldIndex);// çàïîìíèì íîìåð ñòîëáöà ñ äåëåãàòîì äëÿ òèïà "DATA" |
| 628 | ui->tableView->setItemDelegateForColumn(dataFieldIndex, &dateDelegate); |
628 | ui->tableView->setItemDelegateForColumn(dataFieldIndex, &dateDelegate); |
| 629 | 629 | ||
| 630 | }
|
630 | }
|
| 631 | 631 | ||
| 632 | 632 | ||
| 633 | for (int i=0; i < boolFieldList.count(); i++){ // äëÿ âñåõ ïîëåé ñ òèïîì "BOOL" |
633 | for (int i=0; i < boolFieldList.count(); i++){ // äëÿ âñåõ ïîëåé ñ òèïîì "BOOL" |
| 634 | // // // // static MyDEDelegate dateDelegate;
|
634 | // // // // static MyDEDelegate dateDelegate;
|
| 635 | // static TimeEditDelegate dateDelegate("01.10.2010");
|
635 | // static TimeEditDelegate dateDelegate("01.10.2010");
|
| 636 | QString boolFieldName; // èìÿ ïîëÿ |
636 | QString boolFieldName; // èìÿ ïîëÿ |
| 637 | int boolFieldIndex; // |
637 | int boolFieldIndex; // |
| 638 | boolFieldName = boolFieldList.at(i); // îïðåäåëÿåì èìÿ ïîëÿ ñ òèïîì "BOOL" |
638 | boolFieldName = boolFieldList.at(i); // îïðåäåëÿåì èìÿ ïîëÿ ñ òèïîì "BOOL" |
| 639 | boolFieldIndex = sql_mogel->record().indexOf(boolFieldName); // îïðåäåëÿåì íîìåð ñòîëáöà â ìîäåëå |
639 | boolFieldIndex = sql_mogel->record().indexOf(boolFieldName); // îïðåäåëÿåì íîìåð ñòîëáöà â ìîäåëå |
| 640 | bool_colomns_indexes.append(boolFieldIndex);// çàïîìíèì íîìåð ñòîëáöà ñ òèïîì "DATA" |
640 | bool_colomns_indexes.append(boolFieldIndex);// çàïîìíèì íîìåð ñòîëáöà ñ òèïîì "DATA" |
| 641 | // ui->tableView->setItemDelegateForColumn(dataFieldIndex, &dateDelegate);
|
641 | // ui->tableView->setItemDelegateForColumn(dataFieldIndex, &dateDelegate);
|
| 642 | 642 | ||
| 643 | }
|
643 | }
|
| 644 | 644 | ||
| 645 | sql_mogel->setBooleansList(bool_colomns_indexes); |
645 | sql_mogel->setBooleansList(bool_colomns_indexes); |
| 646 | boolFieldsIndexes_global = bool_colomns_indexes; |
646 | boolFieldsIndexes_global = bool_colomns_indexes; |
| 647 | 647 | ||
| 648 | for (int i=0; i < spin_delegate_list.count(); i++){ // óäàëÿåì íåñòàíäàðòíûå äåëåãàòû |
648 | for (int i=0; i < spin_delegate_list.count(); i++){ // óäàëÿåì íåñòàíäàðòíûå äåëåãàòû |
| 649 | delete spin_delegate_list.at(i); |
649 | delete spin_delegate_list.at(i); |
| 650 | }
|
650 | }
|
| 651 | 651 | ||
| 652 | spin_delegate_list.clear(); // î÷èùàåì ñïèñîê óêàçàòåëåé íà íåñòàíäàðòíûå äåëåãàòû |
652 | spin_delegate_list.clear(); // î÷èùàåì ñïèñîê óêàçàòåëåé íà íåñòàíäàðòíûå äåëåãàòû |
| 653 | 653 | ||
| 654 | QStringList pointersNames;
|
654 | QStringList pointersNames;
|
| 655 | pointersNames = pointersList.keys(); //çäåñü ñïèñîê èìåí ïîëåé-óêàçàòåëåé íà ðîäèòåëüñêèå êëàññû |
655 | pointersNames = pointersList.keys(); //çäåñü ñïèñîê èìåí ïîëåé-óêàçàòåëåé íà ðîäèòåëüñêèå êëàññû |
| 656 | 656 | ||
| 657 | 657 | ||
| 658 | 658 | ||
| 659 | 659 | ||
| 660 | 660 | ||
| 661 | // ui->tableView->setItemDelegateForColumn(2, picture_delegate);
|
661 | // ui->tableView->setItemDelegateForColumn(2, picture_delegate);
|
| 662 | 662 | ||
| 663 | // ui->tableView->setRowHeight(1, 100);
|
663 | // ui->tableView->setRowHeight(1, 100);
|
| 664 | 664 | ||
| 665 | 665 | ||
| 666 | 666 | ||
| 667 | 667 | ||
| 668 | 668 | ||
| 669 | QStringList parentInctancesList = pointersList.values(); // çäåñü ñïèñîê ñîîòâåòñòâóþùèõ õðàíèëèù |
669 | QStringList parentInctancesList = pointersList.values(); // çäåñü ñïèñîê ñîîòâåòñòâóþùèõ õðàíèëèù |
| 670 | 670 | ||
| 671 | for (i=0; i < pointersNames.size(); i++){ // äëÿ âñåõ ïîëåé-óêàçàòåëåé: |
671 | for (i=0; i < pointersNames.size(); i++){ // äëÿ âñåõ ïîëåé-óêàçàòåëåé: |
| 672 | QString pointerName;
|
672 | QString pointerName;
|
| 673 | 673 | ||
| 674 | int pointerIndex; |
674 | int pointerIndex; |
| 675 | pointerName = pointersNames.at(i); // îïðåäåëÿåì èìÿ ïîëÿ-óêàçàòåëÿ |
675 | pointerName = pointersNames.at(i); // îïðåäåëÿåì èìÿ ïîëÿ-óêàçàòåëÿ |
| 676 | pointerIndex = sql_mogel->record().indexOf(pointerName); // îïðåäåëÿåì íîìåð ñòîëáöà â ìîäåëå |
676 | pointerIndex = sql_mogel->record().indexOf(pointerName); // îïðåäåëÿåì íîìåð ñòîëáöà â ìîäåëå |
| 677 | colomns_indexes.append(pointerIndex); // çàïîìíèì íîìåð ñòîëáöà ñ íåñòàíäàðòíûì äåëåãàòîì |
677 | colomns_indexes.append(pointerIndex); // çàïîìíèì íîìåð ñòîëáöà ñ íåñòàíäàðòíûì äåëåãàòîì |
| 678 | spin_delegate_tmp = new SpinBoxDelegate(); |
678 | spin_delegate_tmp = new SpinBoxDelegate(); |
| 679 | 679 | ||
| 680 | // // spinDelegate.setInctance(parentInctancesList.at(i)); // äåëåãàòó ïåðåäàåì èìÿ õðàíèëèùà îáúåêòîâ ðîäèòåëüñêîãî êëàññà
|
680 | // // spinDelegate.setInctance(parentInctancesList.at(i)); // äåëåãàòó ïåðåäàåì èìÿ õðàíèëèùà îáúåêòîâ ðîäèòåëüñêîãî êëàññà
|
| 681 | // // spinDelegate.getItems(); // ïðîñèì äåëåãàòà ñîñòàâèòü ñïèñîê îáúåêòîâ â õðàíèëèùå
|
681 | // // spinDelegate.getItems(); // ïðîñèì äåëåãàòà ñîñòàâèòü ñïèñîê îáúåêòîâ â õðàíèëèùå
|
| 682 | 682 | ||
| 683 | spin_delegate_tmp->setInctance(parentInctancesList.at(i)); |
683 | spin_delegate_tmp->setInctance(parentInctancesList.at(i)); |
| 684 | spin_delegate_tmp->getItems(); |
684 | spin_delegate_tmp->getItems(); |
| 685 | 685 | ||
| 686 | spin_delegate_list.append(spin_delegate_tmp); |
686 | spin_delegate_list.append(spin_delegate_tmp); |
| 687 | 687 | ||
| 688 | // // ui->tableView->setItemDelegateForColumn(pointerIndex, &spinDelegate); // è ïðèñâàèâàåì åãî ñîîòâåòñòâóþùåìó ñòîëáöó íàøåé òàáëèöû
|
688 | // // ui->tableView->setItemDelegateForColumn(pointerIndex, &spinDelegate); // è ïðèñâàèâàåì åãî ñîîòâåòñòâóþùåìó ñòîëáöó íàøåé òàáëèöû
|
| 689 | 689 | ||
| 690 | ui->tableView->setItemDelegateForColumn(pointerIndex, spin_delegate_tmp); |
690 | ui->tableView->setItemDelegateForColumn(pointerIndex, spin_delegate_tmp); |
| 691 | 691 | ||
| 692 | pointersToModel.insert(pointerIndex, parentInctancesList.at(i)); // ôîðìèðóåì ñïèñîê ñòîëáöîâ ñ óêàçàòåëÿìè |
692 | pointersToModel.insert(pointerIndex, parentInctancesList.at(i)); // ôîðìèðóåì ñïèñîê ñòîëáöîâ ñ óêàçàòåëÿìè |
| 693 | }
|
693 | }
|
| 694 | 694 | ||
| 695 | sql_mogel->setPointers(pointersToModel); // ïåðåäàåì ñïèñîê óêàçàòåëåé ìîäåëå |
695 | sql_mogel->setPointers(pointersToModel); // ïåðåäàåì ñïèñîê óêàçàòåëåé ìîäåëå |
| 696 | 696 | ||
| 697 | pointer_index = sql_mogel->record().indexOf(pointer_name); // ýòî ãëîáàëüíàÿ ïåðåìåííàÿ, íå òðîãàåì, íóæíà! :-) |
697 | pointer_index = sql_mogel->record().indexOf(pointer_name); // ýòî ãëîáàëüíàÿ ïåðåìåííàÿ, íå òðîãàåì, íóæíà! :-) |
| 698 | 698 | ||
| 699 | 699 | ||
| 700 | 700 | ||
| 701 | 701 | ||
| 702 | sql_mogel->setFilter(filtr_tmp); |
702 | sql_mogel->setFilter(filtr_tmp); |
| 703 | sql_mogel->setSort(1, Qt::AscendingOrder); |
703 | sql_mogel->setSort(1, Qt::AscendingOrder); |
| 704 | sql_mogel->select(); |
704 | sql_mogel->select(); |
| 705 | 705 | ||
| 706 | 706 | ||
| 707 | 707 | ||
| 708 | connect(sql_mogel, SIGNAL(dataChanged(QModelIndex,QModelIndex)), this, SLOT(on_sql_mogel_dataChanged(QModelIndex,QModelIndex))); |
708 | connect(sql_mogel, SIGNAL(dataChanged(QModelIndex,QModelIndex)), this, SLOT(on_sql_mogel_dataChanged(QModelIndex,QModelIndex))); |
| 709 | 709 | ||
| 710 | ui->tableView->setModel(sql_mogel); |
710 | ui->tableView->setModel(sql_mogel); |
| 711 | ui->tableView->hideColumn(0); |
711 | ui->tableView->hideColumn(0); |
| 712 | ui->tableView->resizeColumnsToContents(); |
712 | ui->tableView->resizeColumnsToContents(); |
| 713 | ui->tableView->resizeRowsToContents(); |
713 | ui->tableView->resizeRowsToContents(); |
| 714 | 714 | ||
| 715 | 715 | ||
| 716 | 716 | ||
| 717 | 717 | ||
| 718 | 718 | ||
| 719 | }
|
719 | }
|
| 720 | 720 | ||
| 721 | }
|
721 | }
|
| 722 | 722 | ||
| 723 | 723 | ||
| 724 | void MainWindow::on_pushButton_clicked(){ // íàæàòèå êíîïêè "äîáàâèòü ñòðîêó" |
724 | void MainWindow::on_pushButton_clicked(){ // íàæàòèå êíîïêè "äîáàâèòü ñòðîêó" |
| 725 | int row = sql_mogel->rowCount(); |
725 | int row = sql_mogel->rowCount(); |
| 726 | sql_mogel->insertRows(row, 1); |
726 | sql_mogel->insertRows(row, 1); |
| 727 | sql_mogel->setData(sql_mogel->index(row, 1), QVariant(tr("íå îïðåäåëåíî")), Qt::EditRole); // ïðèñâàèâàåì íîâîå çíà÷åíèå ïîëþ "èìÿ êëàññà" |
727 | sql_mogel->setData(sql_mogel->index(row, 1), QVariant(tr("íå îïðåäåëåíî")), Qt::EditRole); // ïðèñâàèâàåì íîâîå çíà÷åíèå ïîëþ "èìÿ êëàññà" |
| 728 | if (pointer_index > 0) { |
728 | if (pointer_index > 0) { |
| 729 | sql_mogel->setData(sql_mogel->index(row, pointer_index), QVariant(parentObject_id), Qt::EditRole); // ïðèñâàèâàåì íîâîå çíà÷åíèå ïîëþ "èìÿ êëàññà" |
729 | sql_mogel->setData(sql_mogel->index(row, pointer_index), QVariant(parentObject_id), Qt::EditRole); // ïðèñâàèâàåì íîâîå çíà÷åíèå ïîëþ "èìÿ êëàññà" |
| 730 | }
|
730 | }
|
| 731 | // sql_mogel->submitAll();
|
731 | // sql_mogel->submitAll();
|
| 732 | 732 | ||
| 733 | }
|
733 | }
|
| 734 | 734 | ||
| 735 | void MainWindow::on_pushButton_2_clicked(){ // íàæàòèå êíîïêè "Óäàëèòü âûäåëåííûå îáúåêòû" |
735 | void MainWindow::on_pushButton_2_clicked(){ // íàæàòèå êíîïêè "Óäàëèòü âûäåëåííûå îáúåêòû" |
| 736 | int i; |
736 | int i; |
| 737 | i++; |
737 | i++; |
| 738 | QModelIndex model_index;
|
738 | QModelIndex model_index;
|
| 739 | QItemSelectionModel *selectionModel = ui->tableView->selectionModel(); |
739 | QItemSelectionModel *selectionModel = ui->tableView->selectionModel(); |
| 740 | QModelIndexList indexes = selectionModel->selectedIndexes(); |
740 | QModelIndexList indexes = selectionModel->selectedIndexes(); |
| 741 | QList<int> selectedRows; |
741 | QList<int> selectedRows; |
| 742 | selectedRows.clear(); |
742 | selectedRows.clear(); |
| 743 | foreach (model_index, indexes){ // ñïèñîê âñåõ âûäåëåííûõ ñòðîê |
743 | foreach (model_index, indexes){ // ñïèñîê âñåõ âûäåëåííûõ ñòðîê |
| 744 | if (!selectedRows.contains(model_index.row()) && (model_index.column()==1)) selectedRows.append(model_index.row()); // îñòàâëÿåì â ñïèñêå òîëüêî âûáðàííûå â ïåðâîé êîëîíêå |
744 | if (!selectedRows.contains(model_index.row()) && (model_index.column()==1)) selectedRows.append(model_index.row()); // îñòàâëÿåì â ñïèñêå òîëüêî âûáðàííûå â ïåðâîé êîëîíêå |
| 745 | 745 | ||
| 746 | }
|
746 | }
|
| 747 | qSort(selectedRows.begin(),selectedRows.end(), qGreater<int>()); // ñîðòèðóåì â îáðàòíîì ïîðÿäêå |
747 | qSort(selectedRows.begin(),selectedRows.end(), qGreater<int>()); // ñîðòèðóåì â îáðàòíîì ïîðÿäêå |
| 748 | 748 | ||
| 749 | 749 | ||
| 750 | for (int m =0; m < selectedRows.size(); ++m){ |
750 | for (int m =0; m < selectedRows.size(); ++m){ |
| 751 | 751 | ||
| 752 | // ClassEditor::removeClass(selectedRows.at(m));
|
752 | // ClassEditor::removeClass(selectedRows.at(m));
|
| 753 | 753 | ||
| 754 | sql_mogel->removeRow(selectedRows.at(m)); |
754 | sql_mogel->removeRow(selectedRows.at(m)); |
| 755 | 755 | ||
| 756 | }
|
756 | }
|
| 757 | sql_mogel->submitAll(); |
757 | sql_mogel->submitAll(); |
| 758 | getDatabaseData(); |
758 | getDatabaseData(); |
| 759 | 759 | ||
| 760 | }
|
760 | }
|
| 761 | 761 | ||
| 762 | 762 | ||
| 763 | void MainWindow::on_pushButton_3_clicked(){ // íàæàòèå êíîïêè "Ïðèìåíèòü" |
763 | void MainWindow::on_pushButton_3_clicked(){ // íàæàòèå êíîïêè "Ïðèìåíèòü" |
| 764 | int i; |
764 | int i; |
| 765 | i++; |
765 | i++; |
| 766 | sql_mogel->submitAll(); |
766 | sql_mogel->submitAll(); |
| 767 | getDatabaseData(); |
767 | getDatabaseData(); |
| 768 | ui->pushButton_3->setEnabled(false); |
768 | ui->pushButton_3->setEnabled(false); |
| 769 | ui->pushButton_4->setEnabled(false); |
769 | ui->pushButton_4->setEnabled(false); |
| 770 | sql_mogel->select(); |
770 | sql_mogel->select(); |
| 771 | 771 | ||
| 772 | }
|
772 | }
|
| 773 | 773 | ||
| 774 | 774 | ||
| 775 | void MainWindow::on_pushButton_4_clicked(){ // íàæàòèå êíîïêè "Ñáðîñèòü èçìåíåíèÿ" |
775 | void MainWindow::on_pushButton_4_clicked(){ // íàæàòèå êíîïêè "Ñáðîñèòü èçìåíåíèÿ" |
| 776 | int i; |
776 | int i; |
| 777 | i++; |
777 | i++; |
| 778 | sql_mogel->select(); |
778 | sql_mogel->select(); |
| 779 | ui->pushButton_3->setEnabled(false); |
779 | ui->pushButton_3->setEnabled(false); |
| 780 | ui->pushButton_4->setEnabled(false); |
780 | ui->pushButton_4->setEnabled(false); |
| 781 | ui->tableView_2->resizeRowsToContents(); |
781 | ui->tableView_2->resizeRowsToContents(); |
| 782 | ui->tableView_2->resizeColumnsToContents(); |
782 | ui->tableView_2->resizeColumnsToContents(); |
| 783 | }
|
783 | }
|
| 784 | 784 | ||
| 785 | 785 | ||
| 786 | void MainWindow::on_pushButton_5_clicked(){// íàæàòèå êíîïêè "Äîáàâèòü ìîäåëü " |
786 | void MainWindow::on_pushButton_5_clicked(){// íàæàòèå êíîïêè "Äîáàâèòü ìîäåëü " |
| 787 | 787 | ||
| 788 | int i; |
788 | int i; |
| 789 | i++; |
789 | i++; |
| 790 | int row = model_for_ListModelsTable->rowCount(); |
790 | int row = model_for_ListModelsTable->rowCount(); |
| 791 | model_for_ListModelsTable->insertRows(row, 1); |
791 | model_for_ListModelsTable->insertRows(row, 1); |
| 792 | model_for_ListModelsTable->setData(model_for_ListModelsTable->index(row, 1), QVariant(tr("Íîâàÿ ìîäåëü")), Qt::EditRole); // ïðèñâàèâàåì íîâîå çíà÷åíèå ïîëþ "èìÿ êëàññà" |
792 | model_for_ListModelsTable->setData(model_for_ListModelsTable->index(row, 1), QVariant(tr("Íîâàÿ ìîäåëü")), Qt::EditRole); // ïðèñâàèâàåì íîâîå çíà÷åíèå ïîëþ "èìÿ êëàññà" |
| 793 | // model_for_ListModelsTable->setData(sql_mogel->index(row, pointer_index), QVariant(parentObject_id), Qt::EditRole); // ïðèñâàèâàåì íîâîå çíà÷åíèå ïîëþ "èìÿ êëàññà"
|
793 | // model_for_ListModelsTable->setData(sql_mogel->index(row, pointer_index), QVariant(parentObject_id), Qt::EditRole); // ïðèñâàèâàåì íîâîå çíà÷åíèå ïîëþ "èìÿ êëàññà"
|
| 794 | 794 | ||
| 795 | // sql_mogel->submitAll();
|
795 | // sql_mogel->submitAll();
|
| 796 | 796 | ||
| 797 | 797 | ||
| 798 | }
|
798 | }
|
| 799 | 799 | ||
| 800 | void MainWindow::on_pushButton_6_clicked(){// íàæàòèå êíîïêè "Óäàëèòü ìîäåëü " |
800 | void MainWindow::on_pushButton_6_clicked(){// íàæàòèå êíîïêè "Óäàëèòü ìîäåëü " |
| 801 | 801 | ||
| 802 | QModelIndex model_index;
|
802 | QModelIndex model_index;
|
| 803 | QItemSelectionModel *selectionModel = ui->tableView_2->selectionModel(); |
803 | QItemSelectionModel *selectionModel = ui->tableView_2->selectionModel(); |
| 804 | QModelIndexList indexes = selectionModel->selectedIndexes(); |
804 | QModelIndexList indexes = selectionModel->selectedIndexes(); |
| 805 | QList<int> selectedRows; |
805 | QList<int> selectedRows; |
| 806 | selectedRows.clear(); |
806 | selectedRows.clear(); |
| 807 | foreach (model_index, indexes){ // ñïèñîê âñåõ âûäåëåííûõ ñòðîê |
807 | foreach (model_index, indexes){ // ñïèñîê âñåõ âûäåëåííûõ ñòðîê |
| 808 | if (!selectedRows.contains(model_index.row()) && (model_index.column()==1)) selectedRows.append(model_index.row()); // îñòàâëÿåì â ñïèñêå òîëüêî âûáðàííûå â ïåðâîé êîëîíêå |
808 | if (!selectedRows.contains(model_index.row()) && (model_index.column()==1)) selectedRows.append(model_index.row()); // îñòàâëÿåì â ñïèñêå òîëüêî âûáðàííûå â ïåðâîé êîëîíêå |
| 809 | 809 | ||
| 810 | }
|
810 | }
|
| 811 | qSort(selectedRows.begin(),selectedRows.end(), qGreater<int>()); // ñîðòèðóåì â îáðàòíîì ïîðÿäêå |
811 | qSort(selectedRows.begin(),selectedRows.end(), qGreater<int>()); // ñîðòèðóåì â îáðàòíîì ïîðÿäêå |
| 812 | 812 | ||
| 813 | 813 | ||
| 814 | for (int m =0; m < selectedRows.size(); ++m){ |
814 | for (int m =0; m < selectedRows.size(); ++m){ |
| 815 | 815 | ||
| 816 | // ClassEditor::removeClass(selectedRows.at(m));
|
816 | // ClassEditor::removeClass(selectedRows.at(m));
|
| 817 | 817 | ||
| 818 | model_for_ListModelsTable->removeRow(selectedRows.at(m)); |
818 | model_for_ListModelsTable->removeRow(selectedRows.at(m)); |
| 819 | 819 | ||
| 820 | }
|
820 | }
|
| 821 | model_for_ListModelsTable->submitAll(); |
821 | model_for_ListModelsTable->submitAll(); |
| 822 | ui->pushButton_7->setEnabled(true); |
822 | ui->pushButton_7->setEnabled(true); |
| 823 | // getDatabaseData();
|
823 | // getDatabaseData();
|
| 824 | 824 | ||
| 825 | }
|
825 | }
|
| 826 | 826 | ||
| 827 | 827 | ||
| 828 | void MainWindow::on_pushButton_7_clicked(){// íàæàòèå êíîïêè "Ïðèìåíèòü" |
828 | void MainWindow::on_pushButton_7_clicked(){// íàæàòèå êíîïêè "Ïðèìåíèòü" |
| 829 | model_for_ListModelsTable->submitAll(); |
829 | model_for_ListModelsTable->submitAll(); |
| 830 | ui->pushButton_7->setEnabled(false); |
830 | ui->pushButton_7->setEnabled(false); |
| 831 | ui->pushButton_8->setEnabled(false); |
831 | ui->pushButton_8->setEnabled(false); |
| 832 | model_is_build = false; |
832 | model_is_build = false; |
| 833 | MainWindow::readModels(); |
833 | MainWindow::readModels(); |
| 834 | model_is_build = true; |
834 | model_is_build = true; |
| 835 | MainWindow::getDatabaseData(); |
835 | MainWindow::getDatabaseData(); |
| 836 | }
|
836 | }
|
| 837 | 837 | ||
| 838 | void MainWindow::on_pushButton_8_clicked(){// íàæàòèå êíîïêè "Îòìåíèòü" (íà âêëàäêå ìîäåëåé) |
838 | void MainWindow::on_pushButton_8_clicked(){// íàæàòèå êíîïêè "Îòìåíèòü" (íà âêëàäêå ìîäåëåé) |
| 839 | model_for_ListModelsTable->select(); |
839 | model_for_ListModelsTable->select(); |
| 840 | ui->pushButton_7->setEnabled(false); |
840 | ui->pushButton_7->setEnabled(false); |
| 841 | ui->pushButton_8->setEnabled(false); |
841 | ui->pushButton_8->setEnabled(false); |
| 842 | 842 | ||
| 843 | }
|
843 | }
|
| 844 | 844 | ||
| 845 | 845 | ||
| 846 | void MainWindow::on_pushButton_9_clicked()// íàæàòèå êíîïêè "Äîáàâèòü ôèëüòð" (íà âêëàäêå ìîäåëåé) |
846 | void MainWindow::on_pushButton_9_clicked()// íàæàòèå êíîïêè "Äîáàâèòü ôèëüòð" (íà âêëàäêå ìîäåëåé) |
| 847 | {
|
847 | {
|
| 848 | QString class_id;
|
848 | QString class_id;
|
| 849 | QString model_id;
|
849 | QString model_id;
|
| 850 | 850 | ||
| 851 | 851 | ||
| 852 | class_id = ui->treeWidget->currentItem()->text(1); |
852 | class_id = ui->treeWidget->currentItem()->text(1); |
| 853 | model_id = ui->treeWidget->currentItem()->text(6); |
853 | model_id = ui->treeWidget->currentItem()->text(6); |
| 854 | int row = filter_model->rowCount(); |
854 | int row = filter_model->rowCount(); |
| 855 | filter_model->insertRows(row, 1); |
855 | filter_model->insertRows(row, 1); |
| 856 | filter_model->setData(filter_model->index(row, 1), QVariant(model_id), Qt::EditRole); // ïðèñâàèâàåì íîâîå çíà÷åíèå ïîëþ "Model ID" |
856 | filter_model->setData(filter_model->index(row, 1), QVariant(model_id), Qt::EditRole); // ïðèñâàèâàåì íîâîå çíà÷åíèå ïîëþ "Model ID" |
| 857 | filter_model->setData(filter_model->index(row, 2), QVariant(class_id), Qt::EditRole); // ïðèñâàèâàåì íîâîå çíà÷åíèå ïîëþ "Class ID" |
857 | filter_model->setData(filter_model->index(row, 2), QVariant(class_id), Qt::EditRole); // ïðèñâàèâàåì íîâîå çíà÷åíèå ïîëþ "Class ID" |
| 858 | ui->pushButton_11->setEnabled(true); |
858 | ui->pushButton_11->setEnabled(true); |
| 859 | ui->pushButton_12->setEnabled(true); |
859 | ui->pushButton_12->setEnabled(true); |
| 860 | 860 | ||
| 861 | 861 | ||
| 862 | }
|
862 | }
|
| 863 | 863 | ||
| 864 | void MainWindow::on_pushButton_10_clicked()// íàæàòèå êíîïêè "Óäàëèòü ôèëüòð" (íà âêëàäêå ôèëüòðîâ) |
864 | void MainWindow::on_pushButton_10_clicked()// íàæàòèå êíîïêè "Óäàëèòü ôèëüòð" (íà âêëàäêå ôèëüòðîâ) |
| 865 | {
|
865 | {
|
| 866 | QModelIndex model_index;
|
866 | QModelIndex model_index;
|
| 867 | QItemSelectionModel *selectionModel = ui->tableView_3->selectionModel(); |
867 | QItemSelectionModel *selectionModel = ui->tableView_3->selectionModel(); |
| 868 | QModelIndexList indexes = selectionModel->selectedIndexes(); |
868 | QModelIndexList indexes = selectionModel->selectedIndexes(); |
| 869 | QList<int> selectedRows; |
869 | QList<int> selectedRows; |
| 870 | selectedRows.clear(); |
870 | selectedRows.clear(); |
| 871 | foreach (model_index, indexes){ // ñïèñîê âñåõ âûäåëåííûõ ñòðîê |
871 | foreach (model_index, indexes){ // ñïèñîê âñåõ âûäåëåííûõ ñòðîê |
| 872 | if (!selectedRows.contains(model_index.row()) /*&& (model_index.column()==1)*/) selectedRows.append(model_index.row()); // îñòàâëÿåì â ñïèñêå òîëüêî âûáðàííûå â ïåðâîé êîëîíêå |
872 | if (!selectedRows.contains(model_index.row()) /*&& (model_index.column()==1)*/) selectedRows.append(model_index.row()); // îñòàâëÿåì â ñïèñêå òîëüêî âûáðàííûå â ïåðâîé êîëîíêå |
| 873 | 873 | ||
| 874 | }
|
874 | }
|
| 875 | qSort(selectedRows.begin(),selectedRows.end(), qGreater<int>()); // ñîðòèðóåì â îáðàòíîì ïîðÿäêå |
875 | qSort(selectedRows.begin(),selectedRows.end(), qGreater<int>()); // ñîðòèðóåì â îáðàòíîì ïîðÿäêå |
| 876 | 876 | ||
| 877 | 877 | ||
| 878 | for (int m =0; m < selectedRows.size(); ++m){ |
878 | for (int m =0; m < selectedRows.size(); ++m){ |
| 879 | 879 | ||
| 880 | // ClassEditor::removeClass(selectedRows.at(m));
|
880 | // ClassEditor::removeClass(selectedRows.at(m));
|
| 881 | 881 | ||
| 882 | filter_model->removeRow(selectedRows.at(m)); |
882 | filter_model->removeRow(selectedRows.at(m)); |
| 883 | 883 | ||
| 884 | }
|
884 | }
|
| 885 | filter_model->submitAll(); |
885 | filter_model->submitAll(); |
| 886 | 886 | ||
| 887 | filter_model->sort(0,Qt::AscendingOrder); |
887 | filter_model->sort(0,Qt::AscendingOrder); |
| 888 | // getDatabaseData();
|
888 | // getDatabaseData();
|
| 889 | model_is_build = false; |
889 | model_is_build = false; |
| 890 | MainWindow::readModels(); |
890 | MainWindow::readModels(); |
| 891 | model_is_build = true; |
891 | model_is_build = true; |
| 892 | MainWindow::getDatabaseData(); |
892 | MainWindow::getDatabaseData(); |
| 893 | 893 | ||
| 894 | disconnect(filter_model, SIGNAL(dataChanged(QModelIndex,QModelIndex)), this, SLOT(on_filter_model_dataChanged(QModelIndex,QModelIndex))); |
894 | disconnect(filter_model, SIGNAL(dataChanged(QModelIndex,QModelIndex)), this, SLOT(on_filter_model_dataChanged(QModelIndex,QModelIndex))); |
| 895 | delete filter_model; |
895 | delete filter_model; |
| 896 | 896 | ||
| 897 | filter_model = new QSqlTableModel(); |
897 | filter_model = new QSqlTableModel(); |
| 898 | filter_model->setEditStrategy(QSqlTableModel::OnManualSubmit); |
898 | filter_model->setEditStrategy(QSqlTableModel::OnManualSubmit); |
| 899 | /// filter_model = new MyModel();
|
899 | /// filter_model = new MyModel();
|
| 900 | 900 | ||
| 901 | connect(filter_model, SIGNAL(dataChanged(QModelIndex,QModelIndex)), this, SLOT(on_filter_model_dataChanged(QModelIndex,QModelIndex))); |
901 | connect(filter_model, SIGNAL(dataChanged(QModelIndex,QModelIndex)), this, SLOT(on_filter_model_dataChanged(QModelIndex,QModelIndex))); |
| 902 | 902 | ||
| 903 | 903 | ||
| 904 | 904 | ||
| 905 | 905 | ||
| 906 | }
|
906 | }
|
| 907 | 907 | ||
| 908 | void MainWindow::on_pushButton_11_clicked()// íàæàòèå êíîïêè "Ïðèìåíèòü" (íà âêëàäêå ôèëüòðîâ) |
908 | void MainWindow::on_pushButton_11_clicked()// íàæàòèå êíîïêè "Ïðèìåíèòü" (íà âêëàäêå ôèëüòðîâ) |
| 909 | {
|
909 | {
|
| 910 | filter_model->submitAll(); |
910 | filter_model->submitAll(); |
| 911 | filter_model->sort(0,Qt::AscendingOrder); |
911 | filter_model->sort(0,Qt::AscendingOrder); |
| 912 | ui->pushButton_11->setEnabled(false); |
912 | ui->pushButton_11->setEnabled(false); |
| 913 | ui->pushButton_12->setEnabled(false); |
913 | ui->pushButton_12->setEnabled(false); |
| 914 | 914 | ||
| 915 | model_is_build = false; |
915 | model_is_build = false; |
| 916 | MainWindow::readModels(); |
916 | MainWindow::readModels(); |
| 917 | model_is_build = true; |
917 | model_is_build = true; |
| 918 | MainWindow::getDatabaseData(); |
918 | MainWindow::getDatabaseData(); |
| 919 | disconnect(filter_model, SIGNAL(dataChanged(QModelIndex,QModelIndex)), this, SLOT(on_filter_model_dataChanged(QModelIndex,QModelIndex))); |
919 | disconnect(filter_model, SIGNAL(dataChanged(QModelIndex,QModelIndex)), this, SLOT(on_filter_model_dataChanged(QModelIndex,QModelIndex))); |
| 920 | delete filter_model; |
920 | delete filter_model; |
| 921 | 921 | ||
| 922 | filter_model = new QSqlTableModel(); |
922 | filter_model = new QSqlTableModel(); |
| 923 | filter_model->setEditStrategy(QSqlTableModel::OnManualSubmit); |
923 | filter_model->setEditStrategy(QSqlTableModel::OnManualSubmit); |
| 924 | /// filter_model = new MyModel();
|
924 | /// filter_model = new MyModel();
|
| 925 | 925 | ||
| 926 | connect(filter_model, SIGNAL(dataChanged(QModelIndex,QModelIndex)), this, SLOT(on_filter_model_dataChanged(QModelIndex,QModelIndex))); |
926 | connect(filter_model, SIGNAL(dataChanged(QModelIndex,QModelIndex)), this, SLOT(on_filter_model_dataChanged(QModelIndex,QModelIndex))); |
| 927 | 927 | ||
| 928 | 928 | ||
| 929 | 929 | ||
| 930 | }
|
930 | }
|
| 931 | 931 | ||
| 932 | void MainWindow::on_pushButton_12_clicked()// íàæàòèå êíîïêè "Ñáðîñèòü èçìåíåíèÿ" (íà âêëàäêå ôèëüòðîâ) |
932 | void MainWindow::on_pushButton_12_clicked()// íàæàòèå êíîïêè "Ñáðîñèòü èçìåíåíèÿ" (íà âêëàäêå ôèëüòðîâ) |
| 933 | {
|
933 | {
|
| 934 | ui->tableView_3->setModel(filter_model); |
934 | ui->tableView_3->setModel(filter_model); |
| 935 | filter_model->select(); |
935 | filter_model->select(); |
| 936 | 936 | ||
| 937 | ui->pushButton_11->setEnabled(false); |
937 | ui->pushButton_11->setEnabled(false); |
| 938 | ui->pushButton_12->setEnabled(false); |
938 | ui->pushButton_12->setEnabled(false); |
| 939 | }
|
939 | }
|
| 940 | 940 | ||
| 941 | void MainWindow::on_pushButton_13_clicked()// íàæàòèå êíîïêè "Ñôîðìèðîâàòü êðàòêèé îò÷åò" (íà âêëàäêå îò÷åòîâ) |
941 | void MainWindow::on_pushButton_13_clicked()// íàæàòèå êíîïêè "Ñôîðìèðîâàòü êðàòêèé îò÷åò" (íà âêëàäêå îò÷åòîâ) |
| 942 | {
|
942 | {
|
| 943 | buildReport(false); |
943 | buildReport(false); |
| 944 | 944 | ||
| 945 | }
|
945 | }
|
| 946 | 946 | ||
| 947 | void MainWindow::on_pushButton_14_clicked()// íàæàòèå êíîïêè "Ñôîðìèðîâàòü ïîëíûé îò÷åò" (íà âêëàäêå îò÷åòîâ) |
947 | void MainWindow::on_pushButton_14_clicked()// íàæàòèå êíîïêè "Ñôîðìèðîâàòü ïîëíûé îò÷åò" (íà âêëàäêå îò÷åòîâ) |
| 948 | {
|
948 | {
|
| 949 | buildReport(true); |
949 | buildReport(true); |
| 950 | 950 | ||
| 951 | }
|
951 | }
|
| 952 | 952 | ||
| 953 | void MainWindow::on_pushButton_15_clicked()// íàæàòèå êíîïêè "Ïå÷àòü" (íà âêëàäêå îò÷åòîâ) |
953 | void MainWindow::on_pushButton_15_clicked()// íàæàòèå êíîïêè "Ïå÷àòü" (íà âêëàäêå îò÷åòîâ) |
| 954 | {
|
954 | {
|
| 955 | QPrinter printer;
|
955 | QPrinter printer;
|
| 956 | QPrintDialog *dlg = new QPrintDialog(&printer, this); |
956 | QPrintDialog *dlg = new QPrintDialog(&printer, this); |
| 957 | if (dlg->exec() !=QDialog::Accepted) return; |
957 | if (dlg->exec() !=QDialog::Accepted) return; |
| 958 | doc->print(&printer); |
958 | doc->print(&printer); |
| 959 | 959 | ||
| 960 | }
|
960 | }
|
| 961 | 961 | ||
| 962 | 962 | ||
| 963 | void MainWindow::on_pushButton_16_clicked()// íàæàòèå êíîïêè "Ïå÷àòü â PDF" (íà âêëàäêå îò÷åòîâ) |
963 | void MainWindow::on_pushButton_16_clicked()// íàæàòèå êíîïêè "Ïå÷àòü â PDF" (íà âêëàäêå îò÷åòîâ) |
| 964 | {
|
964 | {
|
| 965 | QString fileName = QFileDialog::getSaveFileName(this, "Export PDF", "", "PDF Files (*.pdf)"); |
965 | QString fileName = QFileDialog::getSaveFileName(this, "Export PDF", "", "PDF Files (*.pdf)"); |
| 966 | if(!fileName.isEmpty()){ |
966 | if(!fileName.isEmpty()){ |
| 967 | if (QFileInfo(fileName).suffix().isEmpty()) |
967 | if (QFileInfo(fileName).suffix().isEmpty()) |
| 968 | fileName.append(".pdf"); |
968 | fileName.append(".pdf"); |
| 969 | QPrinter printer(QPrinter::HighResolution); |
969 | QPrinter printer(QPrinter::HighResolution); |
| 970 | printer.setOutputFormat(QPrinter::PdfFormat); |
970 | printer.setOutputFormat(QPrinter::PdfFormat); |
| 971 | printer.setOutputFileName(fileName); |
971 | printer.setOutputFileName(fileName); |
| 972 | doc->print(&printer); |
972 | doc->print(&printer); |
| 973 | }
|
973 | }
|
| 974 | 974 | ||
| 975 | }
|
975 | }
|
| 976 | 976 | ||
| 977 | void MainWindow::on_pushButton_17_clicked()// íàæàòèå êíîïêè "Ýêñïîðò â OpenOffice" (íà âêëàäêå îò÷åòîâ) |
977 | void MainWindow::on_pushButton_17_clicked()// íàæàòèå êíîïêè "Ýêñïîðò â OpenOffice" (íà âêëàäêå îò÷åòîâ) |
| 978 | 978 | ||
| 979 | {
|
979 | {
|
| 980 | QString fileName = QFileDialog::getSaveFileName(this, "Export ODT", "", "OpenOffice document (*.odt)"); |
980 | QString fileName = QFileDialog::getSaveFileName(this, "Export ODT", "", "OpenOffice document (*.odt)"); |
| 981 | 981 | ||
| 982 | if(!fileName.isEmpty()){ |
982 | if(!fileName.isEmpty()){ |
| 983 | if (QFileInfo(fileName).suffix().isEmpty()) |
983 | if (QFileInfo(fileName).suffix().isEmpty()) |
| 984 | fileName.append(".odt"); |
984 | fileName.append(".odt"); |
| 985 | (bool)QTextDocumentWriter(fileName).write(doc); |
985 | (bool)QTextDocumentWriter(fileName).write(doc); |
| 986 | 986 | ||
| 987 | }
|
987 | }
|
| 988 | 988 | ||
| 989 | 989 | ||
| 990 | }
|
990 | }
|
| 991 | 991 | ||
| 992 | 992 | ||
| 993 | void MainWindow::on_pushButton_18_clicked()// âûïîëíèòü wmi çàïðîñ |
993 | void MainWindow::on_pushButton_18_clicked()// âûïîëíèòü wmi çàïðîñ |
| 994 | 994 | ||
| 995 | {
|
995 | {
|
| 996 | /*
|
996 | /*
|
| 997 | 997 | ||
| 998 | // QString program = tr(" wmic -U Àäìèíèñòðàòîð%Patr10t //192.168.0.135 \"select * from Win32_ComputerSystem\"");
|
998 | // QString program = tr(" wmic -U Àäìèíèñòðàòîð%Patr10t //192.168.0.135 \"select * from Win32_ComputerSystem\"");
|
| 999 | QString program = tr("wmic");
|
999 | QString program = tr("wmic");
|
| 1000 | QStringList arguments;
|
1000 | QStringList arguments;
|
| 1001 | 1001 | ||
| 1002 | // arguments << tr(" -U Àäìèíèñòðàòîð%Patr10t //192.168.0.135 \"select * from Win32_ComputerSystem\"");
|
1002 | // arguments << tr(" -U Àäìèíèñòðàòîð%Patr10t //192.168.0.135 \"select * from Win32_ComputerSystem\"");
|
| 1003 | // program.append(tr(" -U Àäìèíèñòðàòîð%Patr10t //192.168.0.135 \"select * from Win32_ComputerSystem\""));
|
1003 | // program.append(tr(" -U Àäìèíèñòðàòîð%Patr10t //192.168.0.135 \"select * from Win32_ComputerSystem\""));
|
| 1004 | program.append(tr(" -U admin --password=samba //192.168.0.101 \"select * from ")); //Win32_Product\""));
|
1004 | program.append(tr(" -U admin --password=samba //192.168.0.101 \"select * from ")); //Win32_Product\""));
|
| 1005 | program.append(ui->comboBox_2->currentText());
|
1005 | program.append(ui->comboBox_2->currentText());
|
| 1006 | program.append(tr("\""));
|
1006 | program.append(tr("\""));
|
| 1007 | 1007 | ||
| 1008 | int i;
|
1008 | int i;
|
| 1009 | i++;
|
1009 | i++;
|
| 1010 | wmiProcess.start(program);
|
1010 | wmiProcess.start(program);
|
| 1011 | */
|
1011 | */
|
| 1012 | 1012 | ||
| 1013 | TWmiVideoCard vCard;
|
1013 | TWmiVideoCard vCard;
|
| 1014 | 1014 | ||
| 1015 | 1015 | ||
| 1016 | 1016 | ||
| 1017 | vCard = MainWindow::getWmiVideoGard("192.168.0.11", tr("Àäìèíèñòðàòîð"), "!s-Leg01@Z"); |
1017 | vCard = MainWindow::getWmiVideoGard("192.168.0.11", tr("Àäìèíèñòðàòîð"), "!s-Leg01@Z"); |
| 1018 | int i; |
1018 | int i; |
| 1019 | i++; |
1019 | i++; |
| 1020 | 1020 | ||
| 1021 | 1021 | ||
| 1022 | 1022 | ||
| 1023 | }
|
1023 | }
|
| 1024 | 1024 | ||
| 1025 | 1025 | ||
| 1026 | void MainWindow::on_sql_mogel_dataChanged ( const QModelIndex & topLeft, const QModelIndex & bottomRight ){ // èçìåíèëè ñâîéñòâà îáúåêòà èëè äîáàâèëè íîâûé îáúåêò |
1026 | void MainWindow::on_sql_mogel_dataChanged ( const QModelIndex & topLeft, const QModelIndex & bottomRight ){ // èçìåíèëè ñâîéñòâà îáúåêòà èëè äîáàâèëè íîâûé îáúåêò |
| 1027 | int i; |
1027 | int i; |
| 1028 | i++; |
1028 | i++; |
| 1029 | 1029 | ||
| 1030 | if (sql_mogel->iconIndex() !=-1) { |
1030 | if (sql_mogel->iconIndex() !=-1) { |
| 1031 | ui->tableView->resizeColumnsToContents(); |
1031 | ui->tableView->resizeColumnsToContents(); |
| 1032 | ui->tableView->resizeRowsToContents(); |
1032 | ui->tableView->resizeRowsToContents(); |
| 1033 | }
|
1033 | }
|
| 1034 | 1034 | ||
| 1035 | if ((topLeft == bottomRight) && (boolFieldsIndexes_global.indexOf(topLeft.column()) != -1)) |
1035 | if ((topLeft == bottomRight) && (boolFieldsIndexes_global.indexOf(topLeft.column()) != -1)) |
| 1036 | {
|
1036 | {
|
| 1037 | ui->pushButton_3->setEnabled(false); |
1037 | ui->pushButton_3->setEnabled(false); |
| 1038 | ui->pushButton_4->setEnabled(false); |
1038 | ui->pushButton_4->setEnabled(false); |
| 1039 | return; |
1039 | return; |
| 1040 | }
|
1040 | }
|
| 1041 | 1041 | ||
| 1042 | 1042 | ||
| 1043 | ui->pushButton_3->setEnabled(true); |
1043 | ui->pushButton_3->setEnabled(true); |
| 1044 | ui->pushButton_4->setEnabled(true); |
1044 | ui->pushButton_4->setEnabled(true); |
| 1045 | 1045 | ||
| 1046 | }
|
1046 | }
|
| 1047 | 1047 | ||
| 1048 | void MainWindow::on_model_for_ListModelsTable_dataChanged ( const QModelIndex & topLeft, const QModelIndex & bottomRight ){ // èçìåíèëè ñâîéñòâà îáúåêòà èëè äîáàâèëè íîâûé îáúåêò |
1048 | void MainWindow::on_model_for_ListModelsTable_dataChanged ( const QModelIndex & topLeft, const QModelIndex & bottomRight ){ // èçìåíèëè ñâîéñòâà îáúåêòà èëè äîáàâèëè íîâûé îáúåêò |
| 1049 | 1049 | ||
| 1050 | ui->pushButton_7->setEnabled(true); |
1050 | ui->pushButton_7->setEnabled(true); |
| 1051 | ui->pushButton_8->setEnabled(true); |
1051 | ui->pushButton_8->setEnabled(true); |
| 1052 | }
|
1052 | }
|
| 1053 | 1053 | ||
| 1054 | 1054 | ||
| 1055 | 1055 | ||
| 1056 | 1056 | ||
| 1057 | void MainWindow::on_filter_model_dataChanged ( const QModelIndex & topLeft, const QModelIndex & bottomRight ) // èçìåíèëè ñâîéñòâà ôèëüòðà èëè äîáàâèëè íîâûé ôèëüòð |
1057 | void MainWindow::on_filter_model_dataChanged ( const QModelIndex & topLeft, const QModelIndex & bottomRight ) // èçìåíèëè ñâîéñòâà ôèëüòðà èëè äîáàâèëè íîâûé ôèëüòð |
| 1058 | 1058 | ||
| 1059 | {
|
1059 | {
|
| 1060 | ui->pushButton_11->setEnabled(true); |
1060 | ui->pushButton_11->setEnabled(true); |
| 1061 | ui->pushButton_12->setEnabled(true); |
1061 | ui->pushButton_12->setEnabled(true); |
| 1062 | }
|
1062 | }
|
| 1063 | 1063 | ||
| 1064 | 1064 | ||
| 1065 | 1065 | ||
| 1066 | 1066 | ||
| 1067 | 1067 | ||
| 1068 | // ïîëó÷àåì ñïèñîê âñåõ ïîëåé-óêàçàòåëåé, â êà÷åñòâå êëþ÷åé ïîëó÷èì èìåíà ïîëåé-óêàçàòåëåé
|
1068 | // ïîëó÷àåì ñïèñîê âñåõ ïîëåé-óêàçàòåëåé, â êà÷åñòâå êëþ÷åé ïîëó÷èì èìåíà ïîëåé-óêàçàòåëåé
|
| 1069 | // â êà÷åñòâå çíà÷åíèé ïîëó÷èì ñïèñîê òàáëèö-õðàíèëèù îáúåêòîâ ðîäèòåëüñêèõ êëàññîâ
|
1069 | // â êà÷åñòâå çíà÷åíèé ïîëó÷èì ñïèñîê òàáëèö-õðàíèëèù îáúåêòîâ ðîäèòåëüñêèõ êëàññîâ
|
| 1070 | 1070 | ||
| 1071 | QMap <QString, QString> MainWindow::getPointersList(QString class_id){ |
1071 | QMap <QString, QString> MainWindow::getPointersList(QString class_id){ |
| 1072 | QMap <QString, QString> result_map; |
1072 | QMap <QString, QString> result_map; |
| 1073 | QSqlQuery q;
|
1073 | QSqlQuery q;
|
| 1074 | QString sql_str;
|
1074 | QString sql_str;
|
| 1075 | QString str_tmp;
|
1075 | QString str_tmp;
|
| 1076 | QString field;
|
1076 | QString field;
|
| 1077 | QString result;
|
1077 | QString result;
|
| 1078 | int field_name, field_default_value; |
1078 | int field_name, field_default_value; |
| 1079 | bool ok; |
1079 | bool ok; |
| 1080 | sql_str = tr("select * " |
1080 | sql_str = tr("select * " |
| 1081 | " from `DescriptionOfClasses` where `DescriptionOfClasses`.`FieldType` = 'pointer' and `DescriptionOfClasses`.`ClassIdentifer` = " //íàõîäèì âñå îáúåêòû êëàññà â òàáëèöå - õðàíèëèùå îáúåêòîâ êëàññà |
1081 | " from `DescriptionOfClasses` where `DescriptionOfClasses`.`FieldType` = 'pointer' and `DescriptionOfClasses`.`ClassIdentifer` = " //íàõîäèì âñå îáúåêòû êëàññà â òàáëèöå - õðàíèëèùå îáúåêòîâ êëàññà |
| 1082 | ); |
1082 | ); |
| 1083 | 1083 | ||
| 1084 | sql_str.append(tr("'")); |
1084 | sql_str.append(tr("'")); |
| 1085 | sql_str.append(class_id); |
1085 | sql_str.append(class_id); |
| 1086 | sql_str.append(tr("' ")); |
1086 | sql_str.append(tr("' ")); |
| 1087 | // sql_str.append(tr(" and `DescriptionOfClasses`.`ClassIdentifer` = '"));
|
1087 | // sql_str.append(tr(" and `DescriptionOfClasses`.`ClassIdentifer` = '"));
|
| 1088 | // sql_str.append(chield_class_id);
|
1088 | // sql_str.append(chield_class_id);
|
| 1089 | // sql_str.append(tr("'"));
|
1089 | // sql_str.append(tr("'"));
|
| 1090 | q.prepare(sql_str); |
1090 | q.prepare(sql_str); |
| 1091 | 1091 | ||
| 1092 | ok = q.exec(); |
1092 | ok = q.exec(); |
| 1093 | if (!ok) { |
1093 | if (!ok) { |
| 1094 | QMessageBox::critical( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå. |
1094 | QMessageBox::critical( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå. |
| 1095 | this, // Ðîäèòåëüñêèé âèäæåò. |
1095 | this, // Ðîäèòåëüñêèé âèäæåò. |
| 1096 | QObject::tr("Database Error"), // Çàãîëîâîê. |
1096 | QObject::tr("Database Error"), // Çàãîëîâîê. |
| 1097 | q.lastError().text()); // Òåêñò ñîîáùåíèÿ. |
1097 | q.lastError().text()); // Òåêñò ñîîáùåíèÿ. |
| 1098 | return result_map; |
1098 | return result_map; |
| 1099 | }
|
1099 | }
|
| 1100 | field_name = q.record().indexOf(tr("FieldName")); |
1100 | field_name = q.record().indexOf(tr("FieldName")); |
| 1101 | field_default_value = q.record().indexOf(tr("DefaultValue")); |
1101 | field_default_value = q.record().indexOf(tr("DefaultValue")); |
| 1102 | while(q.next()){ |
1102 | while(q.next()){ |
| 1103 | QString pointerFieldName;
|
1103 | QString pointerFieldName;
|
| 1104 | QString parentClassID;
|
1104 | QString parentClassID;
|
| 1105 | QString parentClassInctance;
|
1105 | QString parentClassInctance;
|
| 1106 | 1106 | ||
| 1107 | pointerFieldName = q.value(field_name).toString(); |
1107 | pointerFieldName = q.value(field_name).toString(); |
| 1108 | parentClassID = q.value(field_default_value).toString(); |
1108 | parentClassID = q.value(field_default_value).toString(); |
| 1109 | parentClassInctance = getClassInctance(parentClassID); |
1109 | parentClassInctance = getClassInctance(parentClassID); |
| 1110 | result_map.insert(pointerFieldName, parentClassInctance); |
1110 | result_map.insert(pointerFieldName, parentClassInctance); |
| 1111 | 1111 | ||
| 1112 | 1112 | ||
| 1113 | }
|
1113 | }
|
| 1114 | 1114 | ||
| 1115 | return result_map; |
1115 | return result_map; |
| 1116 | }
|
1116 | }
|
| 1117 | 1117 | ||
| 1118 | 1118 | ||
| 1119 | 1119 | ||
| 1120 | 1120 | ||
| 1121 | 1121 | ||
| 1122 | QStringList MainWindow::getDataFieldList(QString class_id){ // ïîëó÷àåì ñïèñîê âñåõ ïîëåé c òèïîì "Äàòà", â êà÷åñòâå êëþ÷åé ïîëó÷èì èìåíà ïîëåé |
1122 | QStringList MainWindow::getDataFieldList(QString class_id){ // ïîëó÷àåì ñïèñîê âñåõ ïîëåé c òèïîì "Äàòà", â êà÷åñòâå êëþ÷åé ïîëó÷èì èìåíà ïîëåé |
| 1123 | // â êà÷åñòâå çíà÷åíèé ïîëó÷èì ñïèñîê òàáëèö-õðàíèëèù îáúåêòîâ ðîäèòåëüñêèõ êëàññîâ
|
1123 | // â êà÷åñòâå çíà÷åíèé ïîëó÷èì ñïèñîê òàáëèö-õðàíèëèù îáúåêòîâ ðîäèòåëüñêèõ êëàññîâ
|
| 1124 | 1124 | ||
| 1125 | QStringList result_str;
|
1125 | QStringList result_str;
|
| 1126 | QSqlQuery q;
|
1126 | QSqlQuery q;
|
| 1127 | QString sql_str;
|
1127 | QString sql_str;
|
| 1128 | QString str_tmp;
|
1128 | QString str_tmp;
|
| 1129 | QString field;
|
1129 | QString field;
|
| 1130 | QString result;
|
1130 | QString result;
|
| 1131 | int field_name, field_default_value; |
1131 | int field_name, field_default_value; |
| 1132 | bool ok; |
1132 | bool ok; |
| 1133 | sql_str = tr("select * " |
1133 | sql_str = tr("select * " |
| 1134 | " from `DescriptionOfClasses` where `DescriptionOfClasses`.`FieldType` = 'DATE' and `DescriptionOfClasses`.`ClassIdentifer` = " //íàõîäèì âñå îáúåêòû êëàññà â òàáëèöå - õðàíèëèùå îáúåêòîâ êëàññà |
1134 | " from `DescriptionOfClasses` where `DescriptionOfClasses`.`FieldType` = 'DATE' and `DescriptionOfClasses`.`ClassIdentifer` = " //íàõîäèì âñå îáúåêòû êëàññà â òàáëèöå - õðàíèëèùå îáúåêòîâ êëàññà |
| 1135 | ); |
1135 | ); |
| 1136 | 1136 | ||
| 1137 | sql_str.append(tr("'")); |
1137 | sql_str.append(tr("'")); |
| 1138 | sql_str.append(class_id); |
1138 | sql_str.append(class_id); |
| 1139 | sql_str.append(tr("' ")); |
1139 | sql_str.append(tr("' ")); |
| 1140 | // sql_str.append(tr(" and `DescriptionOfClasses`.`ClassIdentifer` = '"));
|
1140 | // sql_str.append(tr(" and `DescriptionOfClasses`.`ClassIdentifer` = '"));
|
| 1141 | // sql_str.append(chield_class_id);
|
1141 | // sql_str.append(chield_class_id);
|
| 1142 | // sql_str.append(tr("'"));
|
1142 | // sql_str.append(tr("'"));
|
| 1143 | q.prepare(sql_str); |
1143 | q.prepare(sql_str); |
| 1144 | 1144 | ||
| 1145 | ok = q.exec(); |
1145 | ok = q.exec(); |
| 1146 | if (!ok) { |
1146 | if (!ok) { |
| 1147 | QMessageBox::critical( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå. |
1147 | QMessageBox::critical( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå. |
| 1148 | this, // Ðîäèòåëüñêèé âèäæåò. |
1148 | this, // Ðîäèòåëüñêèé âèäæåò. |
| 1149 | QObject::tr("Database Error"), // Çàãîëîâîê. |
1149 | QObject::tr("Database Error"), // Çàãîëîâîê. |
| 1150 | q.lastError().text()); // Òåêñò ñîîáùåíèÿ. |
1150 | q.lastError().text()); // Òåêñò ñîîáùåíèÿ. |
| 1151 | return result_str; |
1151 | return result_str; |
| 1152 | }
|
1152 | }
|
| 1153 | field_name = q.record().indexOf(tr("FieldName")); |
1153 | field_name = q.record().indexOf(tr("FieldName")); |
| 1154 | // field_default_value = q.record().indexOf(tr("DefaultValue"));
|
1154 | // field_default_value = q.record().indexOf(tr("DefaultValue"));
|
| 1155 | while(q.next()){ |
1155 | while(q.next()){ |
| 1156 | QString DataFieldName;
|
1156 | QString DataFieldName;
|
| 1157 | 1157 | ||
| 1158 | DataFieldName = q.value(field_name).toString(); |
1158 | DataFieldName = q.value(field_name).toString(); |
| 1159 | result_str.append(DataFieldName); |
1159 | result_str.append(DataFieldName); |
| 1160 | 1160 | ||
| 1161 | 1161 | ||
| 1162 | }
|
1162 | }
|
| 1163 | 1163 | ||
| 1164 | return result_str; |
1164 | return result_str; |
| 1165 | }
|
1165 | }
|
| 1166 | 1166 | ||
| 1167 | 1167 | ||
| 1168 | 1168 | ||
| 1169 | int MainWindow::getIconFieldIndex(QString inctance){ // ïîëó÷àåì íîìåð ñòîëáöà ñ èêîíêàìè |
1169 | int MainWindow::getIconFieldIndex(QString inctance){ // ïîëó÷àåì íîìåð ñòîëáöà ñ èêîíêàìè |
| 1170 | 1170 | ||
| 1171 | QSqlQuery q;
|
1171 | QSqlQuery q;
|
| 1172 | bool ok; |
1172 | bool ok; |
| 1173 | int icon_field; |
1173 | int icon_field; |
| 1174 | QString sql_str;
|
1174 | QString sql_str;
|
| 1175 | sql_str = tr("select * from `"); //íàõîäèì âñå îáúåêòû êëàññà â òàáëèöå - õðàíèëèùå îáúåêòîâ êëàññà |
1175 | sql_str = tr("select * from `"); //íàõîäèì âñå îáúåêòû êëàññà â òàáëèöå - õðàíèëèùå îáúåêòîâ êëàññà |
| 1176 | sql_str.append(inctance); |
1176 | sql_str.append(inctance); |
| 1177 | sql_str.append(tr("`")); |
1177 | sql_str.append(tr("`")); |
| 1178 | q.prepare(sql_str); |
1178 | q.prepare(sql_str); |
| 1179 | 1179 | ||
| 1180 | ok = q.exec(); |
1180 | ok = q.exec(); |
| 1181 | if (!ok) { |
1181 | if (!ok) { |
| 1182 | QMessageBox::critical( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå. |
1182 | QMessageBox::critical( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå. |
| 1183 | this, // Ðîäèòåëüñêèé âèäæåò. |
1183 | this, // Ðîäèòåëüñêèé âèäæåò. |
| 1184 | QObject::tr("Database Error"), // Çàãîëîâîê. |
1184 | QObject::tr("Database Error"), // Çàãîëîâîê. |
| 1185 | q.lastError().text()); // Òåêñò ñîîáùåíèÿ. |
1185 | q.lastError().text()); // Òåêñò ñîîáùåíèÿ. |
| 1186 | 1186 | ||
| 1187 | return -1; |
1187 | return -1; |
| 1188 | }
|
1188 | }
|
| 1189 | 1189 | ||
| 1190 | icon_field = q.record().indexOf(tr("Icon")); |
1190 | icon_field = q.record().indexOf(tr("Icon")); |
| 1191 | return icon_field; |
1191 | return icon_field; |
| 1192 | 1192 | ||
| 1193 | 1193 | ||
| 1194 | }
|
1194 | }
|
| 1195 | 1195 | ||
| 1196 | 1196 | ||
| 1197 | QStringList MainWindow::getFileFieldList(QString class_id){ // ïîëó÷àåì ñïèñîê âñåõ ïîëåé, â êîòîðûõ õðàíÿòüñÿ ôàéëû |
1197 | QStringList MainWindow::getFileFieldList(QString class_id){ // ïîëó÷àåì ñïèñîê âñåõ ïîëåé, â êîòîðûõ õðàíÿòüñÿ ôàéëû |
| 1198 | QStringList result_str;
|
1198 | QStringList result_str;
|
| 1199 | QSqlQuery q;
|
1199 | QSqlQuery q;
|
| 1200 | QString sql_str;
|
1200 | QString sql_str;
|
| 1201 | bool ok; |
1201 | bool ok; |
| 1202 | int field_name, field_default_value; |
1202 | int field_name, field_default_value; |
| 1203 | sql_str = tr("select * " |
1203 | sql_str = tr("select * " |
| 1204 | " from `DescriptionOfClasses` where `DescriptionOfClasses`.`Comment` = 'file' and `DescriptionOfClasses`.`ClassIdentifer` = " //íàõîäèì âñå îáúåêòû êëàññà â òàáëèöå - õðàíèëèùå îáúåêòîâ êëàññà |
1204 | " from `DescriptionOfClasses` where `DescriptionOfClasses`.`Comment` = 'file' and `DescriptionOfClasses`.`ClassIdentifer` = " //íàõîäèì âñå îáúåêòû êëàññà â òàáëèöå - õðàíèëèùå îáúåêòîâ êëàññà |
| 1205 | ); |
1205 | ); |
| 1206 | sql_str.append(tr("'")); |
1206 | sql_str.append(tr("'")); |
| 1207 | sql_str.append(class_id); |
1207 | sql_str.append(class_id); |
| 1208 | sql_str.append(tr("' ")); |
1208 | sql_str.append(tr("' ")); |
| 1209 | q.prepare(sql_str); |
1209 | q.prepare(sql_str); |
| 1210 | 1210 | ||
| 1211 | ok = q.exec(); |
1211 | ok = q.exec(); |
| 1212 | if (!ok) { |
1212 | if (!ok) { |
| 1213 | QMessageBox::critical( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå. |
1213 | QMessageBox::critical( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå. |
| 1214 | this, // Ðîäèòåëüñêèé âèäæåò. |
1214 | this, // Ðîäèòåëüñêèé âèäæåò. |
| 1215 | QObject::tr("Database Error"), // Çàãîëîâîê. |
1215 | QObject::tr("Database Error"), // Çàãîëîâîê. |
| 1216 | q.lastError().text()); // Òåêñò ñîîáùåíèÿ. |
1216 | q.lastError().text()); // Òåêñò ñîîáùåíèÿ. |
| 1217 | return result_str; |
1217 | return result_str; |
| 1218 | }
|
1218 | }
|
| 1219 | 1219 | ||
| 1220 | field_name = q.record().indexOf(tr("FieldName")); |
1220 | field_name = q.record().indexOf(tr("FieldName")); |
| 1221 | // field_default_value = q.record().indexOf(tr("DefaultValue"));
|
1221 | // field_default_value = q.record().indexOf(tr("DefaultValue"));
|
| 1222 | while(q.next()){ |
1222 | while(q.next()){ |
| 1223 | QString FileFieldName;
|
1223 | QString FileFieldName;
|
| 1224 | 1224 | ||
| 1225 | FileFieldName = q.value(field_name).toString(); |
1225 | FileFieldName = q.value(field_name).toString(); |
| 1226 | result_str.append(FileFieldName); |
1226 | result_str.append(FileFieldName); |
| 1227 | 1227 | ||
| 1228 | 1228 | ||
| 1229 | }
|
1229 | }
|
| 1230 | 1230 | ||
| 1231 | return result_str; |
1231 | return result_str; |
| 1232 | 1232 | ||
| 1233 | }
|
1233 | }
|
| 1234 | 1234 | ||
| 1235 | 1235 | ||
| 1236 | 1236 | ||
| 1237 | QStringList MainWindow::getBoolFieldList(QString class_id){ // ïîëó÷àåì ñïèñîê âñåõ ïîëåé c òèïîì "bool" |
1237 | QStringList MainWindow::getBoolFieldList(QString class_id){ // ïîëó÷àåì ñïèñîê âñåõ ïîëåé c òèïîì "bool" |
| 1238 | 1238 | ||
| 1239 | QStringList result_str;
|
1239 | QStringList result_str;
|
| 1240 | QSqlQuery q;
|
1240 | QSqlQuery q;
|
| 1241 | QString sql_str;
|
1241 | QString sql_str;
|
| 1242 | QString str_tmp;
|
1242 | QString str_tmp;
|
| 1243 | QString field;
|
1243 | QString field;
|
| 1244 | QString result;
|
1244 | QString result;
|
| 1245 | int field_name, field_default_value; |
1245 | int field_name, field_default_value; |
| 1246 | bool ok; |
1246 | bool ok; |
| 1247 | sql_str = tr("select * " |
1247 | sql_str = tr("select * " |
| 1248 | " from `DescriptionOfClasses` where `DescriptionOfClasses`.`FieldType` = 'BOOL' and `DescriptionOfClasses`.`ClassIdentifer` = " //íàõîäèì âñå îáúåêòû êëàññà â òàáëèöå - õðàíèëèùå îáúåêòîâ êëàññà |
1248 | " from `DescriptionOfClasses` where `DescriptionOfClasses`.`FieldType` = 'BOOL' and `DescriptionOfClasses`.`ClassIdentifer` = " //íàõîäèì âñå îáúåêòû êëàññà â òàáëèöå - õðàíèëèùå îáúåêòîâ êëàññà |
| 1249 | ); |
1249 | ); |
| 1250 | 1250 | ||
| 1251 | sql_str.append(tr("'")); |
1251 | sql_str.append(tr("'")); |
| 1252 | sql_str.append(class_id); |
1252 | sql_str.append(class_id); |
| 1253 | sql_str.append(tr("' ")); |
1253 | sql_str.append(tr("' ")); |
| 1254 | // sql_str.append(tr(" and `DescriptionOfClasses`.`ClassIdentifer` = '"));
|
1254 | // sql_str.append(tr(" and `DescriptionOfClasses`.`ClassIdentifer` = '"));
|
| 1255 | // sql_str.append(chield_class_id);
|
1255 | // sql_str.append(chield_class_id);
|
| 1256 | // sql_str.append(tr("'"));
|
1256 | // sql_str.append(tr("'"));
|
| 1257 | q.prepare(sql_str); |
1257 | q.prepare(sql_str); |
| 1258 | 1258 | ||
| 1259 | ok = q.exec(); |
1259 | ok = q.exec(); |
| 1260 | if (!ok) { |
1260 | if (!ok) { |
| 1261 | QMessageBox::critical( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå. |
1261 | QMessageBox::critical( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå. |
| 1262 | this, // Ðîäèòåëüñêèé âèäæåò. |
1262 | this, // Ðîäèòåëüñêèé âèäæåò. |
| 1263 | QObject::tr("Database Error"), // Çàãîëîâîê. |
1263 | QObject::tr("Database Error"), // Çàãîëîâîê. |
| 1264 | q.lastError().text()); // Òåêñò ñîîáùåíèÿ. |
1264 | q.lastError().text()); // Òåêñò ñîîáùåíèÿ. |
| 1265 | return result_str; |
1265 | return result_str; |
| 1266 | }
|
1266 | }
|
| 1267 | field_name = q.record().indexOf(tr("FieldName")); |
1267 | field_name = q.record().indexOf(tr("FieldName")); |
| 1268 | // field_default_value = q.record().indexOf(tr("DefaultValue"));
|
1268 | // field_default_value = q.record().indexOf(tr("DefaultValue"));
|
| 1269 | while(q.next()){ |
1269 | while(q.next()){ |
| 1270 | QString DataFieldName;
|
1270 | QString DataFieldName;
|
| 1271 | 1271 | ||
| 1272 | DataFieldName = q.value(field_name).toString(); |
1272 | DataFieldName = q.value(field_name).toString(); |
| 1273 | result_str.append(DataFieldName); |
1273 | result_str.append(DataFieldName); |
| 1274 | 1274 | ||
| 1275 | 1275 | ||
| 1276 | }
|
1276 | }
|
| 1277 | 1277 | ||
| 1278 | return result_str; |
1278 | return result_str; |
| 1279 | }
|
1279 | }
|
| 1280 | 1280 | ||
| 1281 | 1281 | ||
| 1282 | 1282 | ||
| 1283 | 1283 | ||
| 1284 | 1284 | ||
| 1285 | // Ñ÷èòûâàåì íàñòðîéêè
|
1285 | // Ñ÷èòûâàåì íàñòðîéêè
|
| 1286 | 1286 | ||
| 1287 | void MainWindow::readSettings() |
1287 | void MainWindow::readSettings() |
| 1288 | {
|
1288 | {
|
| 1289 | QSettings settings("Trolltech", "Application Example"); |
1289 | QSettings settings("Trolltech", "Application Example"); |
| 1290 | baseName = settings.value("baseName", "an_db").toString(); |
1290 | baseName = settings.value("baseName", "an_db").toString(); |
| 1291 | userName = settings.value("userName", "an").toString(); |
1291 | userName = settings.value("userName", "an").toString(); |
| 1292 | password = settings.value("password", "393939").toString(); |
1292 | password = settings.value("password", "393939").toString(); |
| 1293 | tableName = settings.value("tableName", "inventar").toString(); |
1293 | tableName = settings.value("tableName", "inventar").toString(); |
| 1294 | hostName = settings.value("hostName", "server").toString(); |
1294 | hostName = settings.value("hostName", "server").toString(); |
| 1295 | // resize(size);
|
1295 | // resize(size);
|
| 1296 | // move(pos);tableName
|
1296 | // move(pos);tableName
|
| 1297 | }
|
1297 | }
|
| 1298 | 1298 | ||
| 1299 | 1299 | ||
| 1300 | void MainWindow::writeSettings() |
1300 | void MainWindow::writeSettings() |
| 1301 | {
|
1301 | {
|
| 1302 | QSettings settings("Trolltech", "Application Example"); |
1302 | QSettings settings("Trolltech", "Application Example"); |
| 1303 | settings.setValue("baseName", baseName); |
1303 | settings.setValue("baseName", baseName); |
| 1304 | settings.setValue("userName", userName); |
1304 | settings.setValue("userName", userName); |
| 1305 | settings.setValue("password", password); |
1305 | settings.setValue("password", password); |
| 1306 | settings.setValue("tableName", tableName); |
1306 | settings.setValue("tableName", tableName); |
| 1307 | settings.setValue("hostName", hostName); |
1307 | settings.setValue("hostName", hostName); |
| 1308 | }
|
1308 | }
|
| 1309 | 1309 | ||
| 1310 | 1310 | ||
| 1311 | 1311 | ||
| 1312 | void MainWindow::applySetting() |
1312 | void MainWindow::applySetting() |
| 1313 | {
|
1313 | {
|
| 1314 | bool ok; |
1314 | bool ok; |
| 1315 | baseName = setFrm.lineEdit->text(); |
1315 | baseName = setFrm.lineEdit->text(); |
| 1316 | userName = setFrm.lineEdit_2->text(); |
1316 | userName = setFrm.lineEdit_2->text(); |
| 1317 | password = setFrm.lineEdit_3->text(); |
1317 | password = setFrm.lineEdit_3->text(); |
| 1318 | // tableName = setFrm->lineEdit_4->text();
|
1318 | // tableName = setFrm->lineEdit_4->text();
|
| 1319 | hostName = setFrm.lineEdit_5->text(); |
1319 | hostName = setFrm.lineEdit_5->text(); |
| 1320 | writeSettings(); |
1320 | writeSettings(); |
| 1321 | 1321 | ||
| 1322 | 1322 | ||
| 1323 | ok=openDataBase(); |
1323 | ok=openDataBase(); |
| 1324 | if (!ok) return; |
1324 | if (!ok) return; |
| 1325 | // // // ui->treeWidget->clear(); // î÷èùàåì äåðåâî ñ ìîäåëüþ
|
1325 | // // // ui->treeWidget->clear(); // î÷èùàåì äåðåâî ñ ìîäåëüþ
|
| 1326 | 1326 | ||
| 1327 | // // // buildPreviewModel(tr("Ìîÿ ìîäåëü"), tr("1"));
|
1327 | // // // buildPreviewModel(tr("Ìîÿ ìîäåëü"), tr("1"));
|
| 1328 | 1328 | ||
| 1329 | model_is_build = false; |
1329 | model_is_build = false; |
| 1330 | 1330 | ||
| 1331 | class_list_map.clear(); // î÷èùàåì ñïèñîê êëàññîâ |
1331 | class_list_map.clear(); // î÷èùàåì ñïèñîê êëàññîâ |
| 1332 | rootItems.clear(); |
1332 | rootItems.clear(); |
| 1333 | models_items.clear(); |
1333 | models_items.clear(); |
| 1334 | 1334 | ||
| 1335 | disconnect(model_for_ListModelsTable, SIGNAL(dataChanged(QModelIndex,QModelIndex)), this, SLOT(on_model_for_ListModelsTable_dataChanged(QModelIndex,QModelIndex))); |
1335 | disconnect(model_for_ListModelsTable, SIGNAL(dataChanged(QModelIndex,QModelIndex)), this, SLOT(on_model_for_ListModelsTable_dataChanged(QModelIndex,QModelIndex))); |
| 1336 | delete model_for_ListModelsTable; |
1336 | delete model_for_ListModelsTable; |
| 1337 | 1337 | ||
| 1338 | initListModelsTablle(); |
1338 | initListModelsTablle(); |
| 1339 | 1339 | ||
| 1340 | connect(model_for_ListModelsTable, SIGNAL(dataChanged(QModelIndex,QModelIndex)), this, SLOT(on_model_for_ListModelsTable_dataChanged(QModelIndex,QModelIndex))); |
1340 | connect(model_for_ListModelsTable, SIGNAL(dataChanged(QModelIndex,QModelIndex)), this, SLOT(on_model_for_ListModelsTable_dataChanged(QModelIndex,QModelIndex))); |
| 1341 | 1341 | ||
| 1342 | ui->treeWidget->clear(); |
1342 | ui->treeWidget->clear(); |
| 1343 | initComboBox(); |
1343 | initComboBox(); |
| 1344 | // model_for_ListModelsTable->select();
|
1344 | // model_for_ListModelsTable->select();
|
| 1345 | MainWindow::readModels(); |
1345 | MainWindow::readModels(); |
| 1346 | 1346 | ||
| 1347 | 1347 | ||
| 1348 | 1348 | ||
| 1349 | // // // getDatabaseData();
|
1349 | // // // getDatabaseData();
|
| 1350 | // delete setFrm;
|
1350 | // delete setFrm;
|
| 1351 | 1351 | ||
| 1352 | 1352 | ||
| 1353 | model_is_build = true; |
1353 | model_is_build = true; |
| 1354 | getDatabaseData(); |
1354 | getDatabaseData(); |
| 1355 | setFrm.close(); |
1355 | setFrm.close(); |
| 1356 | }
|
1356 | }
|
| 1357 | 1357 | ||
| 1358 | 1358 | ||
| 1359 | void MainWindow::getSetting() |
1359 | void MainWindow::getSetting() |
| 1360 | {
|
1360 | {
|
| 1361 | // setFrm = new settingForm;
|
1361 | // setFrm = new settingForm;
|
| 1362 | // // // connect(setFrm.pushButton, SIGNAL(clicked()), this, SLOT(applySetting()));
|
1362 | // // // connect(setFrm.pushButton, SIGNAL(clicked()), this, SLOT(applySetting()));
|
| 1363 | setFrm.lineEdit->setText(baseName); |
1363 | setFrm.lineEdit->setText(baseName); |
| 1364 | setFrm.lineEdit_2->setText(userName); |
1364 | setFrm.lineEdit_2->setText(userName); |
| 1365 | setFrm.lineEdit_3->setText(password); |
1365 | setFrm.lineEdit_3->setText(password); |
| 1366 | // setFrm->lineEdit_4->setText(tableName);
|
1366 | // setFrm->lineEdit_4->setText(tableName);
|
| 1367 | setFrm.lineEdit_5->setText(hostName); |
1367 | setFrm.lineEdit_5->setText(hostName); |
| 1368 | setFrm.show(); |
1368 | setFrm.show(); |
| 1369 | 1369 | ||
| 1370 | 1370 | ||
| 1371 | 1371 | ||
| 1372 | }
|
1372 | }
|
| 1373 | 1373 | ||
| 1374 | 1374 | ||
| 1375 | 1375 | ||
| 1376 | 1376 | ||
| 1377 | void MainWindow::readModels(){ |
1377 | void MainWindow::readModels(){ |
| 1378 | 1378 | ||
| 1379 | int row = model_for_ListModelsTable->rowCount(); |
1379 | int row = model_for_ListModelsTable->rowCount(); |
| 1380 | QList <QTreeWidgetItem*> modelsItemsList; |
1380 | QList <QTreeWidgetItem*> modelsItemsList; |
| 1381 | QList <int> row_list; |
1381 | QList <int> row_list; |
| 1382 | modelsItemsList = models_items.values(); |
1382 | modelsItemsList = models_items.values(); |
| 1383 | 1383 | ||
| 1384 | row_list = models_items.keys(); |
1384 | row_list = models_items.keys(); |
| 1385 | 1385 | ||
| 1386 | 1386 | ||
| 1387 | 1387 | ||
| 1388 | rootItems.clear(); |
1388 | rootItems.clear(); |
| 1389 | root_items_list.clear(); |
1389 | root_items_list.clear(); |
| 1390 | ui->treeWidget->clear(); |
1390 | ui->treeWidget->clear(); |
| 1391 | for (int i=0; i < row; i++){ |
1391 | for (int i=0; i < row; i++){ |
| 1392 | QTreeWidgetItem * item_tmp; |
1392 | QTreeWidgetItem * item_tmp; |
| 1393 | QString modelName;
|
1393 | QString modelName;
|
| 1394 | QString model_id;
|
1394 | QString model_id;
|
| 1395 | 1395 | ||
| 1396 | bool enabled; |
1396 | bool enabled; |
| 1397 | 1397 | ||
| 1398 | 1398 | ||
| 1399 | 1399 | ||
| 1400 | //models_items.values();
|
1400 | //models_items.values();
|
| 1401 | // modelString =
|
1401 | // modelString =
|
| 1402 | 1402 | ||
| 1403 | modelName = model_for_ListModelsTable->data(model_for_ListModelsTable->index(i, 1)).toString(); |
1403 | modelName = model_for_ListModelsTable->data(model_for_ListModelsTable->index(i, 1)).toString(); |
| 1404 | model_id = model_for_ListModelsTable->data(model_for_ListModelsTable->index(i, 0)).toString(); |
1404 | model_id = model_for_ListModelsTable->data(model_for_ListModelsTable->index(i, 0)).toString(); |
| 1405 | 1405 | ||
| 1406 | enabled = model_for_ListModelsTable->data(model_for_ListModelsTable->index(i, 3)).toBool(); |
1406 | enabled = model_for_ListModelsTable->data(model_for_ListModelsTable->index(i, 3)).toBool(); |
| 1407 | item_tmp = new QTreeWidgetItem(ui->treeWidget); |
1407 | item_tmp = new QTreeWidgetItem(ui->treeWidget); |
| 1408 | item_tmp->setText(0, modelName); |
1408 | item_tmp->setText(0, modelName); |
| 1409 | item_tmp->setText(4, QVariant(i).toString()); // çàïèøåì â 4 êîëîíêó íîìåðñòðîêè ìîäåëè â òàáëèöå ìîäåëåé |
1409 | item_tmp->setText(4, QVariant(i).toString()); // çàïèøåì â 4 êîëîíêó íîìåðñòðîêè ìîäåëè â òàáëèöå ìîäåëåé |
| 1410 | item_tmp->setText(6, model_id); |
1410 | item_tmp->setText(6, model_id); |
| 1411 | if (enabled) item_tmp->setCheckState(0,Qt::Checked); |
1411 | if (enabled) item_tmp->setCheckState(0,Qt::Checked); |
| 1412 | else item_tmp->setCheckState(0,Qt::Unchecked); |
1412 | else item_tmp->setCheckState(0,Qt::Unchecked); |
| 1413 | 1413 | ||
| 1414 | root_items_list << item_tmp; |
1414 | root_items_list << item_tmp; |
| 1415 | 1415 | ||
| 1416 | rootItems.append(item_tmp); |
1416 | rootItems.append(item_tmp); |
| 1417 | 1417 | ||
| 1418 | models_items[i] =item_tmp ; |
1418 | models_items[i] =item_tmp ; |
| 1419 | 1419 | ||
| 1420 | 1420 | ||
| 1421 | modelString = model_for_ListModelsTable->data(model_for_ListModelsTable->index(i, 2)).toString(); |
1421 | modelString = model_for_ListModelsTable->data(model_for_ListModelsTable->index(i, 2)).toString(); |
| 1422 | if (modelString.isEmpty()) continue; |
1422 | if (modelString.isEmpty()) continue; |
| 1423 | else setupModelData(modelString.split(QString("\n")), item_tmp, i, model_id); // ñòðîèì ìîäåëü |
1423 | else setupModelData(modelString.split(QString("\n")), item_tmp, i, model_id); // ñòðîèì ìîäåëü |
| 1424 | 1424 | ||
| 1425 | }
|
1425 | }
|
| 1426 | 1426 | ||
| 1427 | }
|
1427 | }
|
| 1428 | 1428 | ||
| 1429 | 1429 | ||
| 1430 | 1430 | ||
| 1431 | 1431 | ||
| 1432 | QMap <QString, QPixmap> MainWindow::getClassesIcons(){ // ïîëó÷àåì ñïèñîê èêîíîê äëÿ êëàññîâ |
1432 | QMap <QString, QPixmap> MainWindow::getClassesIcons(){ // ïîëó÷àåì ñïèñîê èêîíîê äëÿ êëàññîâ |
| 1433 | // â êà÷åñòâå êëþ÷à ïîëó÷èì ID êëàññà, à â êà÷åñòâå çíà÷åíèé - èçîáðàæåíèÿ èêîíîê
|
1433 | // â êà÷åñòâå êëþ÷à ïîëó÷èì ID êëàññà, à â êà÷åñòâå çíà÷åíèé - èçîáðàæåíèÿ èêîíîê
|
| 1434 | 1434 | ||
| 1435 | QMap <QString, QPixmap> result_map; |
1435 | QMap <QString, QPixmap> result_map; |
| 1436 | QSqlQuery q;
|
1436 | QSqlQuery q;
|
| 1437 | QString sql_str;
|
1437 | QString sql_str;
|
| 1438 | QString str_tmp;
|
1438 | QString str_tmp;
|
| 1439 | QString field;
|
1439 | QString field;
|
| 1440 | QString result;
|
1440 | QString result;
|
| 1441 | int field_id, field_icon; |
1441 | int field_id, field_icon; |
| 1442 | bool ok; |
1442 | bool ok; |
| 1443 | sql_str = tr("select * " |
1443 | sql_str = tr("select * " |
| 1444 | " from `ListOfClasses` " //íàõîäèì âñå îáúåêòû êëàññà â òàáëèöå - õðàíèëèùå îáúåêòîâ êëàññà |
1444 | " from `ListOfClasses` " //íàõîäèì âñå îáúåêòû êëàññà â òàáëèöå - õðàíèëèùå îáúåêòîâ êëàññà |
| 1445 | ); |
1445 | ); |
| 1446 | 1446 | ||
| 1447 | q.prepare(sql_str); |
1447 | q.prepare(sql_str); |
| 1448 | 1448 | ||
| 1449 | ok = q.exec(); |
1449 | ok = q.exec(); |
| 1450 | if (!ok) { |
1450 | if (!ok) { |
| 1451 | QMessageBox::critical( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå. |
1451 | QMessageBox::critical( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå. |
| 1452 | this, // Ðîäèòåëüñêèé âèäæåò. |
1452 | this, // Ðîäèòåëüñêèé âèäæåò. |
| 1453 | QObject::tr("Database Error"), // Çàãîëîâîê. |
1453 | QObject::tr("Database Error"), // Çàãîëîâîê. |
| 1454 | q.lastError().text()); // Òåêñò ñîîáùåíèÿ. |
1454 | q.lastError().text()); // Òåêñò ñîîáùåíèÿ. |
| 1455 | return result_map; |
1455 | return result_map; |
| 1456 | }
|
1456 | }
|
| 1457 | field_id = q.record().indexOf(tr("ID")); |
1457 | field_id = q.record().indexOf(tr("ID")); |
| 1458 | field_icon = q.record().indexOf(tr("Icon")); |
1458 | field_icon = q.record().indexOf(tr("Icon")); |
| 1459 | while(q.next()){ |
1459 | while(q.next()){ |
| 1460 | QString classID;
|
1460 | QString classID;
|
| 1461 | QByteArray loadimage = q.value(field_icon).toByteArray(); |
1461 | QByteArray loadimage = q.value(field_icon).toByteArray(); |
| 1462 | classID = q.value(field_id).toString(); |
1462 | classID = q.value(field_id).toString(); |
| 1463 | if( !loadimage.isEmpty() ) |
1463 | if( !loadimage.isEmpty() ) |
| 1464 | {
|
1464 | {
|
| 1465 | QPixmap pixmap;
|
1465 | QPixmap pixmap;
|
| 1466 | pixmap.loadFromData(loadimage); |
1466 | pixmap.loadFromData(loadimage); |
| 1467 | result_map.insert(classID, pixmap); |
1467 | result_map.insert(classID, pixmap); |
| 1468 | 1468 | ||
| 1469 | }
|
1469 | }
|
| 1470 | else continue; |
1470 | else continue; |
| 1471 | 1471 | ||
| 1472 | 1472 | ||
| 1473 | 1473 | ||
| 1474 | }
|
1474 | }
|
| 1475 | 1475 | ||
| 1476 | return result_map; |
1476 | return result_map; |
| 1477 | 1477 | ||
| 1478 | 1478 | ||
| 1479 | }
|
1479 | }
|
| 1480 | 1480 | ||
| 1481 | 1481 | ||
| 1482 | 1482 | ||
| 1483 | 1483 | ||
| 1484 | QMap <QString, QPixmap> MainWindow::getObjectsIcon(QString inctance){ // ïîëó÷àåì ñïèñîê èêîíîê äëÿ îáúåêòîâ |
1484 | QMap <QString, QPixmap> MainWindow::getObjectsIcon(QString inctance){ // ïîëó÷àåì ñïèñîê èêîíîê äëÿ îáúåêòîâ |
| 1485 | // â êà÷åñòâå êëþ÷à ïîëó÷èì ID îáúåêòà, à â êà÷åñòâå çíà÷åíèé - èçîáðàæåíèÿ èêîíîê
|
1485 | // â êà÷åñòâå êëþ÷à ïîëó÷èì ID îáúåêòà, à â êà÷åñòâå çíà÷åíèé - èçîáðàæåíèÿ èêîíîê
|
| 1486 | QMap <QString, QPixmap> result_map; |
1486 | QMap <QString, QPixmap> result_map; |
| 1487 | QSqlQuery q;
|
1487 | QSqlQuery q;
|
| 1488 | QString sql_str;
|
1488 | QString sql_str;
|
| 1489 | QString str_tmp;
|
1489 | QString str_tmp;
|
| 1490 | int field_id, field_icon; |
1490 | int field_id, field_icon; |
| 1491 | bool ok; |
1491 | bool ok; |
| 1492 | sql_str = tr("select `ID`, `Icon` " |
1492 | sql_str = tr("select `ID`, `Icon` " |
| 1493 | " from `" //íàõîäèì âñå îáúåêòû êëàññà â òàáëèöå - õðàíèëèùå îáúåêòîâ êëàññà |
1493 | " from `" //íàõîäèì âñå îáúåêòû êëàññà â òàáëèöå - õðàíèëèùå îáúåêòîâ êëàññà |
| 1494 | ); |
1494 | ); |
| 1495 | sql_str.append(inctance); |
1495 | sql_str.append(inctance); |
| 1496 | sql_str.append(tr("`")); |
1496 | sql_str.append(tr("`")); |
| 1497 | 1497 | ||
| 1498 | q.prepare(sql_str); |
1498 | q.prepare(sql_str); |
| 1499 | 1499 | ||
| 1500 | ok = q.exec(); |
1500 | ok = q.exec(); |
| 1501 | if (!ok) { |
1501 | if (!ok) { |
| 1502 | QMessageBox::critical( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå. |
1502 | QMessageBox::critical( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå. |
| 1503 | this, // Ðîäèòåëüñêèé âèäæåò. |
1503 | this, // Ðîäèòåëüñêèé âèäæåò. |
| 1504 | QObject::tr("Database Error"), // Çàãîëîâîê. |
1504 | QObject::tr("Database Error"), // Çàãîëîâîê. |
| 1505 | q.lastError().text()); // Òåêñò ñîîáùåíèÿ. |
1505 | q.lastError().text()); // Òåêñò ñîîáùåíèÿ. |
| 1506 | return result_map; |
1506 | return result_map; |
| 1507 | }
|
1507 | }
|
| 1508 | 1508 | ||
| 1509 | field_id = q.record().indexOf(tr("ID")); |
1509 | field_id = q.record().indexOf(tr("ID")); |
| 1510 | field_icon = q.record().indexOf(tr("Icon")); |
1510 | field_icon = q.record().indexOf(tr("Icon")); |
| 1511 | 1511 | ||
| 1512 | while(q.next()){ |
1512 | while(q.next()){ |
| 1513 | QString objectID;
|
1513 | QString objectID;
|
| 1514 | QByteArray loadimage = q.value(field_icon).toByteArray(); |
1514 | QByteArray loadimage = q.value(field_icon).toByteArray(); |
| 1515 | objectID = q.value(field_id).toString(); |
1515 | objectID = q.value(field_id).toString(); |
| 1516 | if( !loadimage.isEmpty() ) |
1516 | if( !loadimage.isEmpty() ) |
| 1517 | {
|
1517 | {
|
| 1518 | QPixmap pixmap;
|
1518 | QPixmap pixmap;
|
| 1519 | pixmap.loadFromData(loadimage); |
1519 | pixmap.loadFromData(loadimage); |
| 1520 | result_map.insert(objectID, pixmap); |
1520 | result_map.insert(objectID, pixmap); |
| 1521 | 1521 | ||
| 1522 | }
|
1522 | }
|
| 1523 | else continue; |
1523 | else continue; |
| 1524 | 1524 | ||
| 1525 | 1525 | ||
| 1526 | 1526 | ||
| 1527 | }
|
1527 | }
|
| 1528 | return result_map; |
1528 | return result_map; |
| 1529 | }
|
1529 | }
|
| 1530 | 1530 | ||
| 1531 | 1531 | ||
| 1532 | 1532 | ||
| 1533 | 1533 | ||
| 1534 | QString MainWindow::getFiltrString(QString model_id, QString class_id){ // ïîëó÷àåì ñòðîêó-ôèëüòð äëÿ äàííîãî êëàññà äàííîé ìîäåëè |
1534 | QString MainWindow::getFiltrString(QString model_id, QString class_id){ // ïîëó÷àåì ñòðîêó-ôèëüòð äëÿ äàííîãî êëàññà äàííîé ìîäåëè |
| 1535 | 1535 | ||
| 1536 | QSqlQuery q;
|
1536 | QSqlQuery q;
|
| 1537 | QString sql_str;
|
1537 | QString sql_str;
|
| 1538 | QString result_str;
|
1538 | QString result_str;
|
| 1539 | sql_str = tr("select * from `Filters` where `Filters`.`Model_ID` = '"); |
1539 | sql_str = tr("select * from `Filters` where `Filters`.`Model_ID` = '"); |
| 1540 | sql_str.append(model_id); |
1540 | sql_str.append(model_id); |
| 1541 | sql_str.append(tr("' and `Filters`.`Class_ID` = '")); |
1541 | sql_str.append(tr("' and `Filters`.`Class_ID` = '")); |
| 1542 | sql_str.append(class_id); |
1542 | sql_str.append(class_id); |
| 1543 | sql_str.append(tr("' order by `Filters`.`ID`")); |
1543 | sql_str.append(tr("' order by `Filters`.`ID`")); |
| 1544 | bool ok; |
1544 | bool ok; |
| 1545 | ok = q.prepare(sql_str); |
1545 | ok = q.prepare(sql_str); |
| 1546 | ok = q.exec(); |
1546 | ok = q.exec(); |
| 1547 | 1547 | ||
| 1548 | if (!ok) { |
1548 | if (!ok) { |
| 1549 | QMessageBox::critical( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå. |
1549 | QMessageBox::critical( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå. |
| 1550 | this, // Ðîäèòåëüñêèé âèäæåò. |
1550 | this, // Ðîäèòåëüñêèé âèäæåò. |
| 1551 | QObject::tr("Database Error"), // Çàãîëîâîê. |
1551 | QObject::tr("Database Error"), // Çàãîëîâîê. |
| 1552 | q.lastError().text()); // Òåêñò ñîîáùåíèÿ. |
1552 | q.lastError().text()); // Òåêñò ñîîáùåíèÿ. |
| 1553 | return result_str; |
1553 | return result_str; |
| 1554 | }
|
1554 | }
|
| 1555 | result_str.clear(); |
1555 | result_str.clear(); |
| 1556 | while(q.next()){ |
1556 | while(q.next()){ |
| 1557 | QString Condition, FieldName, ConditionalSymbol, ValueForComparison, PostCondition;
|
1557 | QString Condition, FieldName, ConditionalSymbol, ValueForComparison, PostCondition;
|
| 1558 | Condition = q.record().value(3).toString(); |
1558 | Condition = q.record().value(3).toString(); |
| 1559 | FieldName = q.record().value(4).toString(); |
1559 | FieldName = q.record().value(4).toString(); |
| 1560 | ConditionalSymbol = q.record().value(5).toString(); |
1560 | ConditionalSymbol = q.record().value(5).toString(); |
| 1561 | ValueForComparison = q.record().value(6).toString(); |
1561 | ValueForComparison = q.record().value(6).toString(); |
| 1562 | PostCondition = q.record().value(7).toString(); |
1562 | PostCondition = q.record().value(7).toString(); |
| 1563 | 1563 | ||
| 1564 | 1564 | ||
| 1565 | result_str.append(Condition); |
1565 | result_str.append(Condition); |
| 1566 | result_str.append(tr(" `")); |
1566 | result_str.append(tr(" `")); |
| 1567 | result_str.append(FieldName); |
1567 | result_str.append(FieldName); |
| 1568 | result_str.append(tr("`")); |
1568 | result_str.append(tr("`")); |
| 1569 | result_str.append(ConditionalSymbol); |
1569 | result_str.append(ConditionalSymbol); |
| 1570 | 1570 | ||
| 1571 | if (!ValueForComparison.isEmpty()) { |
1571 | if (!ValueForComparison.isEmpty()) { |
| 1572 | result_str.append(tr("'")); |
1572 | result_str.append(tr("'")); |
| 1573 | result_str.append(ValueForComparison); |
1573 | result_str.append(ValueForComparison); |
| 1574 | result_str.append(tr("' ")); |
1574 | result_str.append(tr("' ")); |
| 1575 | }
|
1575 | }
|
| 1576 | result_str.append(PostCondition); |
1576 | result_str.append(PostCondition); |
| 1577 | 1577 | ||
| 1578 | 1578 | ||
| 1579 | }
|
1579 | }
|
| 1580 | 1580 | ||
| 1581 | 1581 | ||
| 1582 | return result_str; |
1582 | return result_str; |
| 1583 | 1583 | ||
| 1584 | }
|
1584 | }
|
| 1585 | 1585 | ||
| 1586 | 1586 | ||
| 1587 | void MainWindow::initWmiTree() { |
1587 | void MainWindow::initWmiTree() { |
| 1588 | 1588 | ||
| 1589 | QSqlQuery q;
|
1589 | QSqlQuery q;
|
| 1590 | QString sqlStr;
|
1590 | QString sqlStr;
|
| 1591 | QString classID;
|
1591 | QString classID;
|
| 1592 | QString inctance;
|
1592 | QString inctance;
|
| 1593 | int field_id; |
1593 | int field_id; |
| 1594 | bool ok; |
1594 | bool ok; |
| 1595 | int field_ip, field_user_name, field_password; |
1595 | int field_ip, field_user_name, field_password; |
| 1596 | 1596 | ||
| 1597 | 1597 | ||
| 1598 | sqlStr = tr("select * from `ListOfClasses` where `ListOfClasses`.`ClassName` = 'WmiHost'"); |
1598 | sqlStr = tr("select * from `ListOfClasses` where `ListOfClasses`.`ClassName` = 'WmiHost'"); |
| 1599 | ok = q.prepare(sqlStr); |
1599 | ok = q.prepare(sqlStr); |
| 1600 | ok = q.exec(); |
1600 | ok = q.exec(); |
| 1601 | if (!ok){ |
1601 | if (!ok){ |
| 1602 | QMessageBox::critical( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå. |
1602 | QMessageBox::critical( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå. |
| 1603 | this, // Ðîäèòåëüñêèé âèäæåò. |
1603 | this, // Ðîäèòåëüñêèé âèäæåò. |
| 1604 | QObject::tr("Database Error"), // Çàãîëîâîê. |
1604 | QObject::tr("Database Error"), // Çàãîëîâîê. |
| 1605 | q.lastError().text()); // Òåêñò ñîîáùåíèÿ. |
1605 | q.lastError().text()); // Òåêñò ñîîáùåíèÿ. |
| 1606 | return; |
1606 | return; |
| 1607 | }
|
1607 | }
|
| 1608 | 1608 | ||
| 1609 | field_id = q.record().indexOf(tr("ID")); |
1609 | field_id = q.record().indexOf(tr("ID")); |
| 1610 | if (field_id == -1) return; |
1610 | if (field_id == -1) return; |
| 1611 | else while (q.next()){ |
1611 | else while (q.next()){ |
| 1612 | classID = q.value(field_id).asString(); |
1612 | classID = q.value(field_id).asString(); |
| 1613 | 1613 | ||
| 1614 | }
|
1614 | }
|
| 1615 | 1615 | ||
| 1616 | inctance = MainWindow::getClassInctance(classID); |
1616 | inctance = MainWindow::getClassInctance(classID); |
| 1617 | if(inctance.isEmpty()) return; |
1617 | if(inctance.isEmpty()) return; |
| 1618 | sqlStr = tr("select * from `"); |
1618 | sqlStr = tr("select * from `"); |
| 1619 | sqlStr.append(inctance); |
1619 | sqlStr.append(inctance); |
| 1620 | sqlStr.append(tr("`")); |
1620 | sqlStr.append(tr("`")); |
| 1621 | ok = q.prepare(sqlStr); |
1621 | ok = q.prepare(sqlStr); |
| 1622 | ok = q.exec(); |
1622 | ok = q.exec(); |
| 1623 | if (!ok){ |
1623 | if (!ok){ |
| 1624 | QMessageBox::critical( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå. |
1624 | QMessageBox::critical( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå. |
| 1625 | this, // Ðîäèòåëüñêèé âèäæåò. |
1625 | this, // Ðîäèòåëüñêèé âèäæåò. |
| 1626 | QObject::tr("Database Error"), // Çàãîëîâîê. |
1626 | QObject::tr("Database Error"), // Çàãîëîâîê. |
| 1627 | q.lastError().text()); // Òåêñò ñîîáùåíèÿ. |
1627 | q.lastError().text()); // Òåêñò ñîîáùåíèÿ. |
| 1628 | return; |
1628 | return; |
| 1629 | }
|
1629 | }
|
| 1630 | 1630 | ||
| 1631 | 1631 | ||
| 1632 | 1632 | ||
| 1633 | field_id = q.record().indexOf(tr("ID")); |
1633 | field_id = q.record().indexOf(tr("ID")); |
| 1634 | field_ip = q.record().indexOf(tr("IP")); |
1634 | field_ip = q.record().indexOf(tr("IP")); |
| 1635 | field_user_name = q.record().indexOf(tr("Ëîãèí")); |
1635 | field_user_name = q.record().indexOf(tr("Ëîãèí")); |
| 1636 | field_password = q.record().indexOf(tr("Ïàðîëü")); |
1636 | field_password = q.record().indexOf(tr("Ïàðîëü")); |
| 1637 | 1637 | ||
| 1638 | while (q.next()){ |
1638 | while (q.next()){ |
| 1639 | QString ID_str, IP_str, user_name_str, password_str;
|
1639 | QString ID_str, IP_str, user_name_str, password_str;
|
| 1640 | QTreeWidgetItem * itm_tmp; |
1640 | QTreeWidgetItem * itm_tmp; |
| 1641 | IP_str = q.value(field_ip).asString(); |
1641 | IP_str = q.value(field_ip).asString(); |
| 1642 | user_name_str = q.value(field_user_name).asString(); |
1642 | user_name_str = q.value(field_user_name).asString(); |
| 1643 | password_str = q.value(field_password).asString(); |
1643 | password_str = q.value(field_password).asString(); |
| 1644 | 1644 | ||
| 1645 | itm_tmp = new QTreeWidgetItem(ui->treeWidget_3); |
1645 | itm_tmp = new QTreeWidgetItem(ui->treeWidget_3); |
| 1646 | itm_tmp->setText(0, IP_str); |
1646 | itm_tmp->setText(0, IP_str); |
| 1647 | itm_tmp->setCheckState(0, Qt::Checked ); |
1647 | itm_tmp->setCheckState(0, Qt::Checked ); |
| 1648 | 1648 | ||
| 1649 | 1649 | ||
| 1650 | 1650 | ||
| 1651 | 1651 | ||
| 1652 | 1652 | ||
| 1653 | TWmiVideoCard vCard;
|
1653 | TWmiVideoCard vCard;
|
| 1654 | TWmiMatherBoard mBoard;
|
1654 | TWmiMatherBoard mBoard;
|
| 1655 | TWmiProcessor processor;
|
1655 | TWmiProcessor processor;
|
| 1656 | QList<TWmiMemoryModul> memory_moduls; |
1656 | QList<TWmiMemoryModul> memory_moduls; |
| 1657 | QList<TWmiHDD> hdd_list; |
1657 | QList<TWmiHDD> hdd_list; |
| 1658 | QList<TWmiCDROM> cdrom_list; |
1658 | QList<TWmiCDROM> cdrom_list; |
| 1659 | QList<TWmiNetCard> netcadr_list; |
1659 | QList<TWmiNetCard> netcadr_list; |
| 1660 | - | ||
| - | 1660 | QList<TWmiSoundCard> soundcard_list; |
|
| 1661 | vCard = MainWindow::getWmiVideoGard(IP_str, user_name_str, password_str); |
1661 | vCard = MainWindow::getWmiVideoGard(IP_str, user_name_str, password_str); |
| 1662 | 1662 | ||
| 1663 | if (!vCard.name.isEmpty()) { |
1663 | if (!vCard.name.isEmpty()) { |
| 1664 | QTreeWidgetItem * itm_video; |
1664 | QTreeWidgetItem * itm_video; |
| 1665 | QTreeWidgetItem * itm_video_ram; |
1665 | QTreeWidgetItem * itm_video_ram; |
| 1666 | QTreeWidgetItem * itm_video_model; |
1666 | QTreeWidgetItem * itm_video_model; |
| 1667 | QTreeWidgetItem * itm_video_manufacturer; |
1667 | QTreeWidgetItem * itm_video_manufacturer; |
| 1668 | QString tmp_str;
|
1668 | QString tmp_str;
|
| 1669 | tmp_str = tr("Âèäåîêàðòà: "); |
1669 | tmp_str = tr("Âèäåîêàðòà: "); |
| 1670 | tmp_str.append(vCard.name); |
1670 | tmp_str.append(vCard.name); |
| 1671 | tmp_str.append(tr(" ")); |
1671 | tmp_str.append(tr(" ")); |
| 1672 | tmp_str.append(QVariant(vCard.video_ram/1024/1024).asString()); |
1672 | tmp_str.append(QVariant(vCard.video_ram/1024/1024).asString()); |
| 1673 | tmp_str.append(tr(" ÌÁò")); |
1673 | tmp_str.append(tr(" ÌÁò")); |
| 1674 | itm_video = new QTreeWidgetItem(itm_tmp); |
1674 | itm_video = new QTreeWidgetItem(itm_tmp); |
| 1675 | itm_video->setText(0, tmp_str); |
1675 | itm_video->setText(0, tmp_str); |
| 1676 | 1676 | ||
| 1677 | tmp_str = tr("Ïðîèçâîäèòåëü: "); |
1677 | tmp_str = tr("Ïðîèçâîäèòåëü: "); |
| 1678 | tmp_str.append(vCard.manufacturer); |
1678 | tmp_str.append(vCard.manufacturer); |
| 1679 | 1679 | ||
| 1680 | itm_video_manufacturer = new QTreeWidgetItem(itm_video); |
1680 | itm_video_manufacturer = new QTreeWidgetItem(itm_video); |
| 1681 | itm_video_manufacturer->setText(0, tmp_str); |
1681 | itm_video_manufacturer->setText(0, tmp_str); |
| 1682 | 1682 | ||
| 1683 | itm_video_ram = new QTreeWidgetItem(itm_video); |
1683 | itm_video_ram = new QTreeWidgetItem(itm_video); |
| 1684 | 1684 | ||
| 1685 | tmp_str = tr("Ìîäåëü: "); |
1685 | tmp_str = tr("Ìîäåëü: "); |
| 1686 | tmp_str.append(vCard.model); |
1686 | tmp_str.append(vCard.model); |
| 1687 | itm_video_model = new QTreeWidgetItem(itm_video); |
1687 | itm_video_model = new QTreeWidgetItem(itm_video); |
| 1688 | itm_video_model->setText(0, tmp_str); |
1688 | itm_video_model->setText(0, tmp_str); |
| 1689 | 1689 | ||
| 1690 | 1690 | ||
| 1691 | 1691 | ||
| 1692 | tmp_str = tr("Âèäåîïàìÿòü (Ìá): "); |
1692 | tmp_str = tr("Âèäåîïàìÿòü (Ìá): "); |
| 1693 | tmp_str.append(QVariant(vCard.video_ram /1048576).asString()); |
1693 | tmp_str.append(QVariant(vCard.video_ram /1048576).asString()); |
| 1694 | 1694 | ||
| 1695 | itm_video_ram->setText(0, tmp_str); |
1695 | itm_video_ram->setText(0, tmp_str); |
| 1696 | 1696 | ||
| 1697 | 1697 | ||
| 1698 | 1698 | ||
| 1699 | }
|
1699 | }
|
| 1700 | 1700 | ||
| 1701 | 1701 | ||
| 1702 | mBoard = MainWindow::getWmiMatherBoard(IP_str, user_name_str, password_str); |
1702 | mBoard = MainWindow::getWmiMatherBoard(IP_str, user_name_str, password_str); |
| 1703 | if (!mBoard.manufacturer.isEmpty()) { |
1703 | if (!mBoard.manufacturer.isEmpty()) { |
| 1704 | QTreeWidgetItem * itm_maherBoard; |
1704 | QTreeWidgetItem * itm_maherBoard; |
| 1705 | QTreeWidgetItem * itm_maherBoard_model; |
1705 | QTreeWidgetItem * itm_maherBoard_model; |
| 1706 | QTreeWidgetItem * itm_maherBoard_manufacturer; |
1706 | QTreeWidgetItem * itm_maherBoard_manufacturer; |
| 1707 | QString tmp_str;
|
1707 | QString tmp_str;
|
| 1708 | tmp_str = tr("Ìàòåðèíñêàÿ ïëàòà: "); |
1708 | tmp_str = tr("Ìàòåðèíñêàÿ ïëàòà: "); |
| 1709 | tmp_str.append(mBoard.manufacturer); |
1709 | tmp_str.append(mBoard.manufacturer); |
| 1710 | tmp_str.append( tr(" ")); |
1710 | tmp_str.append( tr(" ")); |
| 1711 | tmp_str.append(mBoard.model); |
1711 | tmp_str.append(mBoard.model); |
| 1712 | itm_maherBoard = new QTreeWidgetItem(itm_tmp); |
1712 | itm_maherBoard = new QTreeWidgetItem(itm_tmp); |
| 1713 | itm_maherBoard->setText(0, tmp_str); |
1713 | itm_maherBoard->setText(0, tmp_str); |
| 1714 | 1714 | ||
| 1715 | tmp_str = tr("Ïðîèçâîäèòåëü: "); |
1715 | tmp_str = tr("Ïðîèçâîäèòåëü: "); |
| 1716 | tmp_str.append(mBoard.manufacturer); |
1716 | tmp_str.append(mBoard.manufacturer); |
| 1717 | 1717 | ||
| 1718 | itm_maherBoard_manufacturer = new QTreeWidgetItem(itm_maherBoard); |
1718 | itm_maherBoard_manufacturer = new QTreeWidgetItem(itm_maherBoard); |
| 1719 | itm_maherBoard_manufacturer->setText(0, tmp_str); |
1719 | itm_maherBoard_manufacturer->setText(0, tmp_str); |
| 1720 | 1720 | ||
| 1721 | itm_maherBoard_model = new QTreeWidgetItem(itm_maherBoard); |
1721 | itm_maherBoard_model = new QTreeWidgetItem(itm_maherBoard); |
| 1722 | 1722 | ||
| 1723 | tmp_str = tr("Ìîäåëü: "); |
1723 | tmp_str = tr("Ìîäåëü: "); |
| 1724 | tmp_str.append(mBoard.model); |
1724 | tmp_str.append(mBoard.model); |
| 1725 | 1725 | ||
| 1726 | itm_maherBoard_model->setText(0, tmp_str); |
1726 | itm_maherBoard_model->setText(0, tmp_str); |
| 1727 | 1727 | ||
| 1728 | 1728 | ||
| 1729 | }
|
1729 | }
|
| 1730 | 1730 | ||
| 1731 | processor = MainWindow::getWmiProcessor(IP_str, user_name_str, password_str); |
1731 | processor = MainWindow::getWmiProcessor(IP_str, user_name_str, password_str); |
| 1732 | if (!processor.manufacturer.isEmpty()){ |
1732 | if (!processor.manufacturer.isEmpty()){ |
| 1733 | 1733 | ||
| 1734 | QTreeWidgetItem * itm_processor; |
1734 | QTreeWidgetItem * itm_processor; |
| 1735 | QTreeWidgetItem * itm_processor_manufacturer; |
1735 | QTreeWidgetItem * itm_processor_manufacturer; |
| 1736 | QTreeWidgetItem * itm_processor_clockSpeed; |
1736 | QTreeWidgetItem * itm_processor_clockSpeed; |
| 1737 | QTreeWidgetItem * itm_processor_socket; |
1737 | QTreeWidgetItem * itm_processor_socket; |
| 1738 | 1738 | ||
| 1739 | 1739 | ||
| 1740 | QString tmp_str;
|
1740 | QString tmp_str;
|
| 1741 | tmp_str = tr("Ïðîöåññîð: "); |
1741 | tmp_str = tr("Ïðîöåññîð: "); |
| 1742 | tmp_str.append(processor.name); |
1742 | tmp_str.append(processor.name); |
| 1743 | 1743 | ||
| 1744 | itm_processor = new QTreeWidgetItem(itm_tmp); |
1744 | itm_processor = new QTreeWidgetItem(itm_tmp); |
| 1745 | itm_processor->setText(0, tmp_str); |
1745 | itm_processor->setText(0, tmp_str); |
| 1746 | 1746 | ||
| 1747 | tmp_str = tr("Ïðîèçâîäèòåëü: "); |
1747 | tmp_str = tr("Ïðîèçâîäèòåëü: "); |
| 1748 | tmp_str.append(processor.manufacturer); |
1748 | tmp_str.append(processor.manufacturer); |
| 1749 | itm_processor_manufacturer = new QTreeWidgetItem(itm_processor); |
1749 | itm_processor_manufacturer = new QTreeWidgetItem(itm_processor); |
| 1750 | itm_processor_manufacturer->setText(0, tmp_str); |
1750 | itm_processor_manufacturer->setText(0, tmp_str); |
| 1751 | 1751 | ||
| 1752 | tmp_str = tr("×àñòîòà: "); |
1752 | tmp_str = tr("×àñòîòà: "); |
| 1753 | tmp_str.append(QVariant(processor.clockSpeed).asString()); |
1753 | tmp_str.append(QVariant(processor.clockSpeed).asString()); |
| 1754 | tmp_str.append(tr(" ÌÃö")); |
1754 | tmp_str.append(tr(" ÌÃö")); |
| 1755 | itm_processor_clockSpeed = new QTreeWidgetItem(itm_processor); |
1755 | itm_processor_clockSpeed = new QTreeWidgetItem(itm_processor); |
| 1756 | itm_processor_clockSpeed->setText(0, tmp_str); |
1756 | itm_processor_clockSpeed->setText(0, tmp_str); |
| 1757 | 1757 | ||
| 1758 | 1758 | ||
| 1759 | tmp_str = tr("Ñîêåò: "); |
1759 | tmp_str = tr("Ñîêåò: "); |
| 1760 | tmp_str.append(processor.socket); |
1760 | tmp_str.append(processor.socket); |
| 1761 | itm_processor_socket = new QTreeWidgetItem(itm_processor); |
1761 | itm_processor_socket = new QTreeWidgetItem(itm_processor); |
| 1762 | itm_processor_socket->setText(0, tmp_str); |
1762 | itm_processor_socket->setText(0, tmp_str); |
| 1763 | 1763 | ||
| 1764 | }
|
1764 | }
|
| 1765 | 1765 | ||
| 1766 | 1766 | ||
| 1767 | memory_moduls = MainWindow::getWmiRAM(IP_str, user_name_str, password_str); |
1767 | memory_moduls = MainWindow::getWmiRAM(IP_str, user_name_str, password_str); |
| 1768 | 1768 | ||
| 1769 | if (!memory_moduls.isEmpty()){ |
1769 | if (!memory_moduls.isEmpty()){ |
| 1770 | QTreeWidgetItem * itm_ram; |
1770 | QTreeWidgetItem * itm_ram; |
| 1771 | int sum_cap=0; |
1771 | int sum_cap=0; |
| 1772 | itm_ram = new QTreeWidgetItem(itm_tmp); |
1772 | itm_ram = new QTreeWidgetItem(itm_tmp); |
| 1773 | 1773 | ||
| 1774 | 1774 | ||
| 1775 | for (int i = 0; i < memory_moduls.count(); i++){ |
1775 | for (int i = 0; i < memory_moduls.count(); i++){ |
| 1776 | 1776 | ||
| 1777 | QTreeWidgetItem * itm_ram_modul; |
1777 | QTreeWidgetItem * itm_ram_modul; |
| 1778 | QTreeWidgetItem * itm_modul_bank; |
1778 | QTreeWidgetItem * itm_modul_bank; |
| 1779 | QTreeWidgetItem * itm_modul_cap; // îáúåì ïàìÿòè |
1779 | QTreeWidgetItem * itm_modul_cap; // îáúåì ïàìÿòè |
| 1780 | 1780 | ||
| 1781 | QString tmp_str;
|
1781 | QString tmp_str;
|
| 1782 | tmp_str = tr("Ìîäóëü ïàìÿòè: "); |
1782 | tmp_str = tr("Ìîäóëü ïàìÿòè: "); |
| 1783 | sum_cap = sum_cap + memory_moduls.at(i).capacity/1024/1024; |
1783 | sum_cap = sum_cap + memory_moduls.at(i).capacity/1024/1024; |
| 1784 | tmp_str.append(QVariant(memory_moduls.at(i).capacity/1024/1024).asString()); |
1784 | tmp_str.append(QVariant(memory_moduls.at(i).capacity/1024/1024).asString()); |
| 1785 | 1785 | ||
| 1786 | tmp_str.append(tr(" ÌÁò")); |
1786 | tmp_str.append(tr(" ÌÁò")); |
| 1787 | itm_ram_modul = new QTreeWidgetItem(itm_ram); |
1787 | itm_ram_modul = new QTreeWidgetItem(itm_ram); |
| 1788 | itm_ram_modul->setText(0, tmp_str); |
1788 | itm_ram_modul->setText(0, tmp_str); |
| 1789 | 1789 | ||
| 1790 | 1790 | ||
| 1791 | }
|
1791 | }
|
| 1792 | QString cap_str;
|
1792 | QString cap_str;
|
| 1793 | cap_str = tr("Îáúåì ïàìÿòè: "); |
1793 | cap_str = tr("Îáúåì ïàìÿòè: "); |
| 1794 | cap_str.append(QVariant(sum_cap).asString()); |
1794 | cap_str.append(QVariant(sum_cap).asString()); |
| 1795 | cap_str.append(tr(" ÌÁò")); |
1795 | cap_str.append(tr(" ÌÁò")); |
| 1796 | itm_ram->setText(0, cap_str); |
1796 | itm_ram->setText(0, cap_str); |
| 1797 | 1797 | ||
| 1798 | }
|
1798 | }
|
| 1799 | 1799 | ||
| 1800 | 1800 | ||
| 1801 | hdd_list = MainWindow::getWmiHDD(IP_str, user_name_str, password_str); |
1801 | hdd_list = MainWindow::getWmiHDD(IP_str, user_name_str, password_str); |
| 1802 | 1802 | ||
| 1803 | 1803 | ||
| 1804 | if (!hdd_list.isEmpty()){ |
1804 | if (!hdd_list.isEmpty()){ |
| 1805 | QTreeWidgetItem * itm_hdd_list; |
1805 | QTreeWidgetItem * itm_hdd_list; |
| 1806 | int sum_cap = 0; |
1806 | int sum_cap = 0; |
| 1807 | itm_hdd_list = new QTreeWidgetItem(itm_tmp); |
1807 | itm_hdd_list = new QTreeWidgetItem(itm_tmp); |
| 1808 | 1808 | ||
| 1809 | 1809 | ||
| 1810 | for (int i = 0; i < hdd_list.count(); i++){ |
1810 | for (int i = 0; i < hdd_list.count(); i++){ |
| 1811 | 1811 | ||
| 1812 | QTreeWidgetItem * itm_hdd; |
1812 | QTreeWidgetItem * itm_hdd; |
| 1813 | QTreeWidgetItem * itm_hdd_man; |
1813 | QTreeWidgetItem * itm_hdd_man; |
| 1814 | QTreeWidgetItem * itm_hdd_cap; |
1814 | QTreeWidgetItem * itm_hdd_cap; |
| 1815 | QTreeWidgetItem * itm_hdd_serNum; |
1815 | QTreeWidgetItem * itm_hdd_serNum; |
| 1816 | QTreeWidgetItem * itm_hdd_size; // îáúåì ïàìÿòè |
1816 | QTreeWidgetItem * itm_hdd_size; // îáúåì ïàìÿòè |
| 1817 | long size_lng; |
1817 | long size_lng; |
| 1818 | QString tmp_str;
|
1818 | QString tmp_str;
|
| 1819 | tmp_str = tr("Ƹñòêèé äèñê: "); |
1819 | tmp_str = tr("Ƹñòêèé äèñê: "); |
| 1820 | sum_cap = sum_cap + hdd_list.at(i).size/1000/1000; |
1820 | sum_cap = sum_cap + hdd_list.at(i).size/1000/1000; |
| 1821 | 1821 | ||
| 1822 | tmp_str.append(hdd_list.at(i).caption); |
1822 | tmp_str.append(hdd_list.at(i).caption); |
| 1823 | tmp_str.append(tr(" ")); |
1823 | tmp_str.append(tr(" ")); |
| 1824 | size_lng = hdd_list.at(i).size; |
1824 | size_lng = hdd_list.at(i).size; |
| 1825 | size_lng = size_lng/1000/1000; |
1825 | size_lng = size_lng/1000/1000; |
| 1826 | 1826 | ||
| 1827 | tmp_str.append(QVariant(int(size_lng)).asString()); |
1827 | tmp_str.append(QVariant(int(size_lng)).asString()); |
| 1828 | tmp_str.append(tr(" ÌÁò s/n: ")); |
1828 | tmp_str.append(tr(" ÌÁò s/n: ")); |
| 1829 | 1829 | ||
| 1830 | tmp_str.append(hdd_list.at(i).serialNumber); |
1830 | tmp_str.append(hdd_list.at(i).serialNumber); |
| 1831 | 1831 | ||
| 1832 | itm_hdd = new QTreeWidgetItem(itm_hdd_list); |
1832 | itm_hdd = new QTreeWidgetItem(itm_hdd_list); |
| 1833 | itm_hdd->setText(0, tmp_str); |
1833 | itm_hdd->setText(0, tmp_str); |
| 1834 | 1834 | ||
| 1835 | 1835 | ||
| 1836 | tmp_str = tr("Ìîäåëü: "); |
1836 | tmp_str = tr("Ìîäåëü: "); |
| 1837 | tmp_str.append((hdd_list.at(i).caption)); |
1837 | tmp_str.append((hdd_list.at(i).caption)); |
| 1838 | 1838 | ||
| 1839 | itm_hdd_cap = new QTreeWidgetItem(itm_hdd); |
1839 | itm_hdd_cap = new QTreeWidgetItem(itm_hdd); |
| 1840 | itm_hdd_cap->setText(0, tmp_str); |
1840 | itm_hdd_cap->setText(0, tmp_str); |
| 1841 | 1841 | ||
| 1842 | tmp_str = tr("Ïðîèçâîäèòåëü: "); |
1842 | tmp_str = tr("Ïðîèçâîäèòåëü: "); |
| 1843 | tmp_str.append((hdd_list.at(i).manufacturer)); |
1843 | tmp_str.append((hdd_list.at(i).manufacturer)); |
| 1844 | 1844 | ||
| 1845 | itm_hdd_man = new QTreeWidgetItem(itm_hdd); |
1845 | itm_hdd_man = new QTreeWidgetItem(itm_hdd); |
| 1846 | itm_hdd_man->setText(0, tmp_str); |
1846 | itm_hdd_man->setText(0, tmp_str); |
| 1847 | 1847 | ||
| 1848 | tmp_str = tr("Ðàçìåð äèñêà: "); |
1848 | tmp_str = tr("Ðàçìåð äèñêà: "); |
| 1849 | tmp_str.append(QVariant(int(size_lng)).asString()); |
1849 | tmp_str.append(QVariant(int(size_lng)).asString()); |
| 1850 | tmp_str.append(tr(" ÌÁò")); |
1850 | tmp_str.append(tr(" ÌÁò")); |
| 1851 | 1851 | ||
| 1852 | itm_hdd_size = new QTreeWidgetItem(itm_hdd); |
1852 | itm_hdd_size = new QTreeWidgetItem(itm_hdd); |
| 1853 | itm_hdd_size->setText(0, tmp_str); |
1853 | itm_hdd_size->setText(0, tmp_str); |
| 1854 | 1854 | ||
| 1855 | tmp_str = tr("Ñåðèéíûé íîìåð: "); |
1855 | tmp_str = tr("Ñåðèéíûé íîìåð: "); |
| 1856 | tmp_str.append((hdd_list.at(i).serialNumber)); |
1856 | tmp_str.append((hdd_list.at(i).serialNumber)); |
| 1857 | itm_hdd_serNum = itm_hdd_size = new QTreeWidgetItem(itm_hdd); |
1857 | itm_hdd_serNum = itm_hdd_size = new QTreeWidgetItem(itm_hdd); |
| 1858 | itm_hdd_serNum->setText(0, tmp_str); |
1858 | itm_hdd_serNum->setText(0, tmp_str); |
| 1859 | 1859 | ||
| 1860 | 1860 | ||
| 1861 | }
|
1861 | }
|
| 1862 | QString cap_str;
|
1862 | QString cap_str;
|
| 1863 | cap_str = tr("Îáùèé îáú¸ì äèñêîâîãî ïðîñòðàíñòâà: "); |
1863 | cap_str = tr("Îáùèé îáú¸ì äèñêîâîãî ïðîñòðàíñòâà: "); |
| 1864 | cap_str.append(QVariant(sum_cap).asString()); |
1864 | cap_str.append(QVariant(sum_cap).asString()); |
| 1865 | cap_str.append(tr(" ÌÁò")); |
1865 | cap_str.append(tr(" ÌÁò")); |
| 1866 | itm_hdd_list->setText(0, cap_str); |
1866 | itm_hdd_list->setText(0, cap_str); |
| 1867 | 1867 | ||
| 1868 | }
|
1868 | }
|
| 1869 | 1869 | ||
| 1870 | 1870 | ||
| 1871 | cdrom_list = MainWindow::getWmiCDROM(IP_str, user_name_str, password_str); |
1871 | cdrom_list = MainWindow::getWmiCDROM(IP_str, user_name_str, password_str); |
| 1872 | 1872 | ||
| 1873 | 1873 | ||
| 1874 | if (!cdrom_list.isEmpty()){ |
1874 | if (!cdrom_list.isEmpty()){ |
| 1875 | QTreeWidgetItem * itm_cdrom_list; |
1875 | QTreeWidgetItem * itm_cdrom_list; |
| 1876 | 1876 | ||
| 1877 | itm_cdrom_list = new QTreeWidgetItem(itm_tmp); |
1877 | itm_cdrom_list = new QTreeWidgetItem(itm_tmp); |
| 1878 | itm_cdrom_list->setText(0, tr("CD/DVD Ïðèâîäû:")); |
1878 | itm_cdrom_list->setText(0, tr("CD/DVD Ïðèâîäû:")); |
| 1879 | 1879 | ||
| 1880 | 1880 | ||
| 1881 | for (int i = 0; i < cdrom_list.count(); i++){ |
1881 | for (int i = 0; i < cdrom_list.count(); i++){ |
| 1882 | 1882 | ||
| 1883 | QTreeWidgetItem * itm_cdrom; |
1883 | QTreeWidgetItem * itm_cdrom; |
| 1884 | QTreeWidgetItem * itm_cdrom_man; |
1884 | QTreeWidgetItem * itm_cdrom_man; |
| 1885 | QTreeWidgetItem * itm_cdrom_cap; |
1885 | QTreeWidgetItem * itm_cdrom_cap; |
| 1886 | QString tmp_str;
|
1886 | QString tmp_str;
|
| 1887 | tmp_str = tr("Ïðèâîä: "); |
1887 | tmp_str = tr("Ïðèâîä: "); |
| 1888 | tmp_str.append(cdrom_list.at(i).name); |
1888 | tmp_str.append(cdrom_list.at(i).name); |
| 1889 | 1889 | ||
| 1890 | itm_cdrom = new QTreeWidgetItem(itm_cdrom_list); |
1890 | itm_cdrom = new QTreeWidgetItem(itm_cdrom_list); |
| 1891 | itm_cdrom->setText(0, tmp_str); |
1891 | itm_cdrom->setText(0, tmp_str); |
| 1892 | 1892 | ||
| 1893 | tmp_str = tr("Ìîäåëü: "); |
1893 | tmp_str = tr("Ìîäåëü: "); |
| 1894 | tmp_str.append(cdrom_list.at(i).name); |
1894 | tmp_str.append(cdrom_list.at(i).name); |
| 1895 | 1895 | ||
| 1896 | 1896 | ||
| 1897 | itm_cdrom_cap = new QTreeWidgetItem( itm_cdrom); |
1897 | itm_cdrom_cap = new QTreeWidgetItem( itm_cdrom); |
| 1898 | itm_cdrom_cap->setText(0, tmp_str); |
1898 | itm_cdrom_cap->setText(0, tmp_str); |
| 1899 | 1899 | ||
| 1900 | 1900 | ||
| 1901 | tmp_str = tr("Ïðîèçâîäèòåëü: "); |
1901 | tmp_str = tr("Ïðîèçâîäèòåëü: "); |
| 1902 | tmp_str.append(cdrom_list.at(i).manufacturer); |
1902 | tmp_str.append(cdrom_list.at(i).manufacturer); |
| 1903 | itm_cdrom_man = new QTreeWidgetItem( itm_cdrom); |
1903 | itm_cdrom_man = new QTreeWidgetItem( itm_cdrom); |
| 1904 | itm_cdrom_man->setText(0, tmp_str); |
1904 | itm_cdrom_man->setText(0, tmp_str); |
| 1905 | 1905 | ||
| 1906 | ui->treeWidget_3->expandItem( itm_cdrom_list); |
1906 | ui->treeWidget_3->expandItem( itm_cdrom_list); |
| 1907 | 1907 | ||
| 1908 | }
|
1908 | }
|
| 1909 | 1909 | ||
| 1910 | 1910 | ||
| 1911 | 1911 | ||
| 1912 | }
|
1912 | }
|
| 1913 | 1913 | ||
| 1914 | 1914 | ||
| 1915 | netcadr_list = MainWindow::getWmiNetCard(IP_str, user_name_str, password_str); |
1915 | netcadr_list = MainWindow::getWmiNetCard(IP_str, user_name_str, password_str); |
| 1916 | 1916 | ||
| 1917 | 1917 | ||
| 1918 | if (!netcadr_list.isEmpty()){ |
1918 | if (!netcadr_list.isEmpty()){ |
| 1919 | QTreeWidgetItem * itm_netCard_list; |
1919 | QTreeWidgetItem * itm_netCard_list; |
| 1920 | 1920 | ||
| 1921 | itm_netCard_list = new QTreeWidgetItem(itm_tmp); |
1921 | itm_netCard_list = new QTreeWidgetItem(itm_tmp); |
| 1922 | itm_netCard_list->setText(0, tr("Ñåòåâûå êàðòû:")); |
1922 | itm_netCard_list->setText(0, tr("Ñåòåâûå êàðòû:")); |
| 1923 | 1923 | ||
| 1924 | 1924 | ||
| 1925 | for (int i = 0; i < cdrom_list.count(); i++){ |
1925 | for (int i = 0; i < cdrom_list.count(); i++){ |
| 1926 | 1926 | ||
| 1927 | QTreeWidgetItem * itm_net_card; |
1927 | QTreeWidgetItem * itm_net_card; |
| 1928 | QTreeWidgetItem * itm_net_card_mac; |
1928 | QTreeWidgetItem * itm_net_card_mac; |
| 1929 | QTreeWidgetItem * itm_net_card_cap; |
1929 | QTreeWidgetItem * itm_net_card_cap; |
| 1930 | QString tmp_str;
|
1930 | QString tmp_str;
|
| 1931 | tmp_str = tr("Ñåòåâàÿ êàðòà: "); |
1931 | tmp_str = tr("Ñåòåâàÿ êàðòà: "); |
| 1932 | tmp_str.append(netcadr_list.at(i).caption); |
1932 | tmp_str.append(netcadr_list.at(i).caption); |
| 1933 | 1933 | ||
| 1934 | itm_net_card = new QTreeWidgetItem(itm_netCard_list); |
1934 | itm_net_card = new QTreeWidgetItem(itm_netCard_list); |
| 1935 | itm_net_card->setText(0, tmp_str); |
1935 | itm_net_card->setText(0, tmp_str); |
| 1936 | 1936 | ||
| 1937 | 1937 | ||
| 1938 | tmp_str = tr("Ìîäåëü: "); |
1938 | tmp_str = tr("Ìîäåëü: "); |
| 1939 | tmp_str.append(netcadr_list.at(i).caption); |
1939 | tmp_str.append(netcadr_list.at(i).caption); |
| 1940 | 1940 | ||
| 1941 | 1941 | ||
| 1942 | itm_net_card_cap = new QTreeWidgetItem(itm_net_card); |
1942 | itm_net_card_cap = new QTreeWidgetItem(itm_net_card); |
| 1943 | itm_net_card_cap->setText(0, tmp_str); |
1943 | itm_net_card_cap->setText(0, tmp_str); |
| 1944 | 1944 | ||
| 1945 | 1945 | ||
| 1946 | tmp_str = tr("MAC àäðåñ: "); |
1946 | tmp_str = tr("MAC àäðåñ: "); |
| 1947 | tmp_str.append(netcadr_list.at(i).MACAddress); |
1947 | tmp_str.append(netcadr_list.at(i).MACAddress); |
| 1948 | itm_net_card_mac = new QTreeWidgetItem(itm_net_card); |
1948 | itm_net_card_mac = new QTreeWidgetItem(itm_net_card); |
| 1949 | itm_net_card_mac->setText(0, tmp_str); |
1949 | itm_net_card_mac->setText(0, tmp_str); |
| 1950 | 1950 | ||
| 1951 | ui->treeWidget_3->expandItem( itm_netCard_list); |
1951 | ui->treeWidget_3->expandItem( itm_netCard_list); |
| 1952 | 1952 | ||
| 1953 | }
|
1953 | }
|
| 1954 | 1954 | ||
| - | 1955 | }
|
|
| - | 1956 | ||
| - | 1957 | soundcard_list = MainWindow::getWmiSoundCard(IP_str, user_name_str, password_str); |
|
| - | 1958 | ||
| - | 1959 | if (!soundcard_list.isEmpty()){ |
|
| - | 1960 | QTreeWidgetItem * itm_soundCard_list; |
|
| - | 1961 | ||
| - | 1962 | itm_soundCard_list = new QTreeWidgetItem(itm_tmp); |
|
| - | 1963 | itm_soundCard_list->setText(0, tr("Çâóêîâûå êàðòû:")); |
|
| - | 1964 | ||
| - | 1965 | ||
| - | 1966 | for (int i = 0; i < cdrom_list.count(); i++){ |
|
| - | 1967 | ||
| - | 1968 | QTreeWidgetItem * itm_sound_card; |
|
| - | 1969 | //QTreeWidgetItem * itm_net_card_mac;
|
|
| - | 1970 | //QTreeWidgetItem * itm_sou_card_cap;
|
|
| - | 1971 | QString tmp_str;
|
|
| - | 1972 | tmp_str = tr("Çâóêîâàÿ êàðòà: "); |
|
| - | 1973 | tmp_str.append(soundcard_list.at(i).caption); |
|
| - | 1974 | ||
| - | 1975 | itm_sound_card = new QTreeWidgetItem(itm_soundCard_list); |
|
| - | 1976 | itm_sound_card->setText(0, tmp_str); |
|
| 1955 | 1977 | ||
| 1956 | 1978 | ||
| 1957 | 1979 | ||
| 1958 | 1980 | ||
| - | 1981 | ui->treeWidget_3->expandItem( itm_soundCard_list); |
|
| - | 1982 | ||
| - | 1983 | }
|
|
| - | 1984 | ||
| - | 1985 | ||
| - | 1986 | ||
| 1959 | 1987 | ||
| 1960 | 1988 | ||
| 1961 | 1989 | ||
| 1962 | 1990 | ||
| - | 1991 | }
|
|
| - | 1992 | ||
| 1963 | ui->treeWidget_3->expandItem(itm_tmp); |
1993 | ui->treeWidget_3->expandItem(itm_tmp); |
| 1964 | // itm_tmp->setChildIndicatorPolicy(QTreeWidget::
|
1994 | // itm_tmp->setChildIndicatorPolicy(QTreeWidget::
|
| 1965 | int i; |
1995 | int i; |
| 1966 | i++; |
1996 | i++; |
| 1967 | 1997 | ||
| 1968 | }
|
- | |
| 1969 | - | ||
| 1970 | - | ||
| 1971 | 1998 | ||
| 1972 | } //while |
1999 | } //while |
| 1973 | 2000 | ||
| 1974 | 2001 | ||
| 1975 | 2002 | ||
| 1976 | }
|
2003 | }
|
| 1977 | 2004 | ||
| 1978 | 2005 | ||
| 1979 | 2006 | ||
| 1980 | 2007 | ||
| 1981 | 2008 | ||
| 1982 | 2009 | ||