Содержимое файла | Последнее изменение | Открыть журнал | RSS
Редакция | Автор | № строки | Строка |
---|---|---|---|
6 | pingvin | 1 | #include "raportform.h" |
2 | ///#include "mainwindowimpl.h" |
||
3 | |||
4 | #define ENTER cursor->insertBlock(); |
||
5 | // place your code here |
||
6 | /////raportForm::raportForm( QWidget * parent, Qt::WFlags f) |
||
7 | ///// : QMainWindow(parent, f) |
||
8 | raportForm::raportForm() |
||
9 | ///// : QMainWindow(parent, f) |
||
10 | : QMainWindow() |
||
11 | { |
||
12 | setupUi(this); |
||
13 | connect(printAction, SIGNAL(triggered()), this, SLOT(on_print_raport())); |
||
14 | connect(printPdfAction, SIGNAL(triggered()), this, SLOT(on_print_raport_to_pdf())); |
||
15 | |||
16 | |||
17 | |||
18 | } |
||
19 | |||
20 | |||
21 | |||
22 | raportForm::~raportForm() |
||
23 | { |
||
24 | |||
25 | } |
||
26 | |||
27 | void raportForm::create_raport() |
||
28 | { |
||
29 | |||
30 | // raportForm::textEdit.setText('1'); |
||
31 | // textEdit.setText("hello!"); |
||
32 | |||
33 | } |
||
34 | |||
35 | |||
36 | |||
37 | |||
38 | |||
39 | |||
40 | void raportForm::on_pushButton_clicked() |
||
41 | { |
||
42 | /* |
||
43 | textEdit->setText(tr("")); |
||
44 | document = textEdit->document(); |
||
45 | cursor = new QTextCursor(document); |
||
46 | cursor->movePosition(QTextCursor::Start); |
||
47 | QTextCharFormat format(cursor->charFormat()); |
||
48 | //format.setFontFamily("Courier"); |
||
49 | format.setFontFamily("Arial"); |
||
50 | //format.setFontItalic(false); |
||
51 | |||
52 | format.setFontWeight(QFont::Normal); |
||
53 | QTextCharFormat boldFormat = format; |
||
54 | boldFormat.setFontWeight(QFont::Bold); |
||
55 | //boldFormat.setFontItalic(true); |
||
56 | //// cursor->insertText(tr("1"), boldFormat); |
||
57 | //// cursor->insertBlock(); |
||
58 | //// cursor->insertText(tr(""), format); |
||
59 | ENTER |
||
60 | |||
61 | int fieldName, fieldID; |
||
62 | // QTreeWidgetItem *otdelItem; |
||
63 | bool ok; |
||
64 | //ok= pdb->isOpen(); |
||
65 | QSqlQuery q; |
||
66 | ok = q.prepare(tr("select * from otdeli"));// |
||
67 | QString otdel, otdel_id, user_name; |
||
68 | ok = q.exec(); |
||
69 | fieldName = q.record().indexOf(tr("")); |
||
70 | fieldID = q.record().indexOf(tr("")); |
||
71 | while (q.next()){ |
||
72 | otdel = q.value(fieldName).toString(); |
||
73 | otdel_id = q.value(fieldID).toString(); |
||
74 | cursor->insertText(otdel, format); |
||
75 | ENTER |
||
76 | |||
77 | // otdelItem = new QTreeWidgetItem(addmemoryForm::treeWidget); |
||
78 | // otdelItem->setText(0, otdel); |
||
79 | // addmemoryForm::SotrydnikiOtdela(otdel_id, otdelItem); |
||
80 | } |
||
81 | // print_raport(); |
||
82 | // print_raport_to_pdf(); |
||
83 | QList<TOtdel> otdel_list_local; |
||
84 | |||
85 | otdel_list_local = get_otdel_list(); |
||
86 | QString otdel_name; |
||
87 | |||
88 | for (int i = 0; i < otdel_list_local.size(); ++i) { |
||
89 | otdel_name = otdel_list_local.at(i).name; |
||
90 | cursor->insertText(otdel_name, format); |
||
91 | ENTER |
||
92 | otdel_id = otdel_list_local.at(i).ID; |
||
93 | cursor->insertText(otdel_id, format); |
||
94 | ENTER |
||
95 | } |
||
96 | */ |
||
97 | bild_raport(); |
||
98 | |||
99 | |||
100 | |||
101 | |||
102 | } |
||
103 | |||
104 | |||
105 | |||
106 | void raportForm::print_raport() |
||
107 | { |
||
108 | QTextDocument *document = textEdit->document(); |
||
109 | QPrinter printer; |
||
110 | |||
111 | QPrintDialog *dlg = new QPrintDialog(&printer, this); |
||
112 | if (dlg->exec() != QDialog::Accepted) |
||
113 | return; |
||
114 | |||
115 | document->print(&printer); |
||
116 | } |
||
117 | |||
118 | void raportForm::print_raport_to_pdf() |
||
119 | { |
||
120 | |||
121 | QString fileName = QFileDialog::getSaveFileName(this, "Export PDF", |
||
122 | QString(), "*.pdf"); |
||
123 | if (!fileName.isEmpty()) { |
||
124 | if (QFileInfo(fileName).suffix().isEmpty()) |
||
125 | fileName.append(".pdf"); |
||
126 | QPrinter printer(QPrinter::HighResolution); |
||
127 | printer.setOutputFormat(QPrinter::PdfFormat); |
||
128 | printer.setOutputFileName(fileName); |
||
129 | textEdit->document()->print(&printer); |
||
130 | } |
||
131 | } |
||
132 | |||
133 | |||
134 | /* |
||
135 | QStringList raportForm::get_otgel_list() |
||
136 | { |
||
137 | |||
138 | struct otdel otdel_tmp; |
||
139 | int fieldName, fieldID; |
||
140 | QString int_otdel_id; |
||
141 | QStringList tmp; |
||
142 | // QTreeWidgetItem *otdelItem; |
||
143 | QSqlQuery q(tr("select * from "));// |
||
144 | QString otdel, otdel_id; |
||
145 | fieldName = q.record().indexOf(tr("")); |
||
146 | fieldID = q.record().indexOf(tr("")); |
||
147 | otdel_list.clear(); // |
||
148 | while (q.next()){ |
||
149 | otdel = q.value(fieldName).toString(); |
||
150 | tmp.append(otdel); |
||
151 | int_otdel_id = q.value(fieldID).toString(); |
||
152 | otdel_tmp.name = otdel; |
||
153 | otdel_tmp.ID = int_otdel_id; |
||
154 | otdel_list.append(otdel_tmp); |
||
155 | // otdel_id = q.value(fieldID).toString(); |
||
156 | // otdelItem = new QTreeWidgetItem(addmemoryForm::treeWidget); |
||
157 | // otdelItem->setText(0, otdel); |
||
158 | // addmemoryForm::SotrydnikiOtdela(otdel_id, otdelItem); |
||
159 | |||
160 | } |
||
161 | return tmp; |
||
162 | } |
||
163 | */ |
||
164 | |||
165 | |||
166 | TSibgipro raportForm::get_sibgipro(){ |
||
167 | // TOtdel otdel_tmp; |
||
168 | TSibgipro sibgipro_tmp; |
||
169 | // int fieldName, fieldID; |
||
170 | // QVariant int_otdel_id; |
||
171 | // QStringList tmp; |
||
172 | // bool ok; |
||
173 | //ok= pdb->isOpen(); |
||
174 | // QSqlQuery q; |
||
175 | // ok = q.prepare(tr("select * from "));// |
||
176 | // QString otdel, otdel_id; |
||
177 | // ok = q.exec(); |
||
178 | // if (!ok) { |
||
179 | // QMessageBox::critical( // . |
||
180 | // this, // . |
||
181 | // QObject::tr("Database Error"), // . |
||
182 | // pdb->lastError().text()); // . |
||
183 | // } |
||
184 | // fieldName = q.record().indexOf(tr("")); |
||
185 | // fieldID = q.record().indexOf(tr("")); |
||
186 | // while (q.next()){ |
||
187 | // otdel = q.value(fieldName).toString(); |
||
188 | // otdel_id = q.value(fieldID).toString(); |
||
189 | // int_otdel_id = q.value(fieldID); |
||
190 | // otdel_tmp.name = otdel; |
||
191 | // otdel_tmp.ID = int_otdel_id; |
||
192 | // sibgipro_tmp.otdel_list.append(otdel_tmp); |
||
193 | // } |
||
194 | sibgipro_tmp.otdel_list = get_otdel_list(); |
||
195 | return sibgipro_tmp; |
||
196 | } |
||
197 | |||
198 | QList<TOtdel> raportForm::get_otdel_list(){ |
||
199 | TOtdel otdel_tmp; |
||
200 | QList<TOtdel> otdel_list_rtrn; |
||
201 | int fieldName, fieldID; |
||
202 | QString int_otdel_id; |
||
203 | QStringList tmp; |
||
204 | bool ok; |
||
205 | |||
206 | |||
207 | |||
208 | //ok= pdb->isOpen(); |
||
209 | QSqlQuery q; |
||
210 | ok = q.prepare(tr("select * from otdeli"));// |
||
211 | QString otdel, otdel_id; |
||
212 | ok = q.exec(); |
||
213 | |||
214 | if (!ok) { |
||
215 | QMessageBox::critical( // . |
||
216 | this, // . |
||
217 | QObject::tr("Database Error"), // . |
||
218 | pdb->lastError().text()); // . |
||
219 | } |
||
220 | |||
221 | fieldName = q.record().indexOf(tr("")); |
||
222 | fieldID = q.record().indexOf(tr("")); |
||
223 | |||
224 | while (q.next()){ |
||
225 | otdel = q.value(fieldName).toString(); |
||
226 | otdel_id = q.value(fieldID).toString(); |
||
227 | int_otdel_id = q.value(fieldID).toString(); |
||
228 | otdel_tmp.name = otdel; |
||
229 | otdel_tmp.ID = int_otdel_id; |
||
230 | otdel_tmp.user_list = get_user_list(int_otdel_id); |
||
231 | otdel_list_rtrn.append(otdel_tmp); |
||
232 | } |
||
233 | |||
234 | return otdel_list_rtrn; |
||
235 | } |
||
236 | |||
237 | QList<TUser> raportForm::get_user_list(QString otdel_ID) |
||
238 | { |
||
239 | TUser user_tmp; |
||
240 | QList<TUser> user_list_rtrn; |
||
241 | |||
242 | int field_fio_sotrydnika, field_id_sotrydnika; |
||
243 | QString fio_sotrydnika_otdela, id_sotrydnika_otdela, oboryd; |
||
244 | QSqlQuery qsotrydnikiOtdela; |
||
245 | QString sqlQueryString; |
||
246 | QTreeWidgetItem *treeItem_sotrydnika; |
||
247 | sqlQueryString = tr("select , from sotrydniki where _="); |
||
248 | sqlQueryString.append(otdel_ID); |
||
249 | qsotrydnikiOtdela.prepare(sqlQueryString); |
||
250 | qsotrydnikiOtdela.exec(); |
||
251 | field_fio_sotrydnika = qsotrydnikiOtdela.record().indexOf(tr("")); |
||
252 | field_id_sotrydnika = qsotrydnikiOtdela.record().indexOf(tr("")); |
||
253 | while (qsotrydnikiOtdela.next()) |
||
254 | { |
||
255 | QList <TSystemBlock> sys_block_list_tmp; |
||
256 | QString id_user; |
||
257 | // fio_sotrydnika_otdela = qsotrydnikiOtdela.value(field_fio_sotrydnika).toString(); |
||
258 | // id_sotrydnika_otdela = qsotrydnikiOtdela.value(field_id_sotrydnika).toString(); |
||
259 | user_tmp.name = qsotrydnikiOtdela.value(field_fio_sotrydnika).toString(); |
||
260 | id_user = qsotrydnikiOtdela.value(field_id_sotrydnika).toString(); |
||
261 | user_tmp.ID = id_user; |
||
262 | // user_list_rtrn.append(user_tmp); |
||
263 | sys_block_list_tmp = get_sys_block_list(id_user); |
||
264 | user_tmp.system_block_list = sys_block_list_tmp; |
||
265 | // treeItem_sotrydnika = new QTreeWidgetItem(itemOtdela); |
||
266 | // treeItem_sotrydnika->setText(1, fio_sotrydnika_otdela ); |
||
267 | user_list_rtrn.append(user_tmp); |
||
268 | } |
||
269 | return user_list_rtrn; |
||
270 | } |
||
271 | |||
272 | |||
273 | void raportForm::bild_raport(){ |
||
274 | TSibgipro sgshm; |
||
275 | QList <TOtdel> sgshm_otdel_list; |
||
276 | QString otdel_name, otdel_id, user_name; |
||
277 | document = textEdit->document(); |
||
278 | cursor = new QTextCursor(document); |
||
279 | cursor->movePosition(QTextCursor::Start); |
||
280 | QTextCharFormat format(cursor->charFormat()); |
||
281 | //format.setFontFamily("Courier"); |
||
282 | format.setFontFamily("Arial"); |
||
283 | //format.setFontItalic(false); |
||
284 | |||
285 | format.setFontWeight(QFont::Normal); |
||
286 | QTextCharFormat boldFormat = format; |
||
287 | boldFormat.setFontWeight(QFont::Bold); |
||
288 | |||
289 | QTextCharFormat italicFormat = format; |
||
290 | //format.setFontFamily("Courier"); |
||
291 | // format.setFontFamily("Arial"); |
||
292 | italicFormat.setFontItalic(true); |
||
293 | |||
294 | |||
295 | |||
296 | sgshm = get_sibgipro(); |
||
297 | sgshm_otdel_list = sgshm.otdel_list; |
||
298 | |||
299 | |||
300 | for (int i = 0; i < sgshm_otdel_list.size(); ++i) { |
||
301 | otdel_name = sgshm_otdel_list.at(i).name; |
||
302 | |||
303 | ///// cursor->insertText(otdel_name, boldFormat); |
||
304 | ///// ENTER |
||
305 | otdel_id = sgshm_otdel_list.at(i).ID; |
||
306 | ///// cursor->insertText(otdel_id, format); |
||
307 | ///// ENTER |
||
308 | |||
309 | for (int m = 0; m < sgshm_otdel_list.at(i).user_list.size(); ++m) |
||
310 | { |
||
311 | QString sys_id, sys_inv_num, sys_ser_num; |
||
312 | // int k_tmp; |
||
313 | user_name = sgshm_otdel_list.at(i).user_list.at(m).name; |
||
314 | cursor->insertText(otdel_name, format); |
||
315 | ENTER |
||
316 | cursor->insertText(user_name, boldFormat); |
||
317 | ENTER |
||
318 | // k_tmp = ; |
||
319 | for (int k = 0; k < sgshm_otdel_list.at(i).user_list.at(m).system_block_list.size(); ++k) |
||
320 | { |
||
321 | |||
322 | sys_id = sgshm_otdel_list.at(i).user_list.at(m).system_block_list.at(k).ID; |
||
323 | sys_inv_num = sgshm_otdel_list.at(i).user_list.at(m).system_block_list.at(k).inv_num; |
||
324 | sys_ser_num = sgshm_otdel_list.at(i).user_list.at(m).system_block_list.at(k).ser_num; |
||
325 | cursor->insertText(tr(" :"), format); |
||
326 | // ENTER |
||
327 | cursor->insertText(tr(" . : "), italicFormat); |
||
328 | cursor->insertText(sys_inv_num, format); |
||
329 | cursor->insertText(tr(" . : "), italicFormat); |
||
330 | cursor->insertText(sys_ser_num, format); |
||
331 | |||
332 | ENTER |
||
333 | for (int l = 0; l < sgshm_otdel_list.at(i).user_list.at(m).system_block_list.at(k).mb_list.size(); ++l) |
||
334 | { |
||
335 | QString mb_proizvoditel, mb_model; |
||
336 | mb_proizvoditel = sgshm_otdel_list.at(i).user_list.at(m).system_block_list.at(k).mb_list.at(l).proizvoditel; |
||
337 | mb_model = sgshm_otdel_list.at(i).user_list.at(m).system_block_list.at(k).mb_list.at(l).model; |
||
338 | cursor->insertText(tr(" : "), format); |
||
339 | cursor->insertText(mb_proizvoditel, format); |
||
340 | cursor->insertText(tr(" "), format); |
||
341 | cursor->insertText(mb_model, format); |
||
342 | ENTER |
||
343 | } |
||
344 | |||
345 | for (int l = 0; l < sgshm_otdel_list.at(i).user_list.at(m).system_block_list.at(k).cpu_list.size(); ++l) |
||
346 | { |
||
347 | QString cpu_proizvoditel, cpu_model, cpu_fqr; |
||
348 | cpu_proizvoditel = sgshm_otdel_list.at(i).user_list.at(m).system_block_list.at(k).cpu_list.at(l).proizvoditel; |
||
349 | cpu_model = sgshm_otdel_list.at(i).user_list.at(m).system_block_list.at(k).cpu_list.at(l).model; |
||
350 | cpu_fqr = sgshm_otdel_list.at(i).user_list.at(m).system_block_list.at(k).cpu_list.at(l).fqr; |
||
351 | cursor->insertText(tr(" : "), format); |
||
352 | cursor->insertText(cpu_proizvoditel, format); |
||
353 | cursor->insertText(tr(" "), format); |
||
354 | cursor->insertText(cpu_model, format); |
||
355 | cursor->insertText(tr(" "), format); |
||
356 | cursor->insertText(cpu_fqr, format); |
||
357 | cursor->insertText(tr(" "), format); |
||
358 | ENTER |
||
359 | } |
||
360 | |||
361 | |||
362 | for (int l = 0; l < sgshm_otdel_list.at(i).user_list.at(m).system_block_list.at(k).memory_list.size(); ++l) |
||
363 | { |
||
364 | QString memory_proizvoditel, memory_tip, memory_obem; |
||
365 | memory_proizvoditel = sgshm_otdel_list.at(i).user_list.at(m).system_block_list.at(k).memory_list.at(l).proizvoditel; |
||
366 | memory_tip = sgshm_otdel_list.at(i).user_list.at(m).system_block_list.at(k).memory_list.at(l).tip; |
||
367 | memory_obem = sgshm_otdel_list.at(i).user_list.at(m).system_block_list.at(k).memory_list.at(l).obem; |
||
368 | cursor->insertText(tr(" : "), format); |
||
369 | cursor->insertText(memory_proizvoditel, format); |
||
370 | cursor->insertText(tr(" "), format); |
||
371 | cursor->insertText(memory_tip, format); |
||
372 | cursor->insertText(tr(" "), format); |
||
373 | cursor->insertText(memory_obem, format); |
||
374 | cursor->insertText(tr(" "), format); |
||
375 | ENTER |
||
376 | } |
||
377 | |||
378 | for (int l = 0; l < sgshm_otdel_list.at(i).user_list.at(m).system_block_list.at(k).harddisc_list.size(); ++l) |
||
379 | { |
||
380 | QString hdd_proizvoditel, hdd_model, hdd_obem; |
||
381 | hdd_proizvoditel = sgshm_otdel_list.at(i).user_list.at(m).system_block_list.at(k).harddisc_list.at(l).proizvoditel; |
||
382 | hdd_model = sgshm_otdel_list.at(i).user_list.at(m).system_block_list.at(k).harddisc_list.at(l).model; |
||
383 | hdd_obem = sgshm_otdel_list.at(i).user_list.at(m).system_block_list.at(k).harddisc_list.at(l).obem; |
||
384 | cursor->insertText(tr(" : "), format); |
||
385 | cursor->insertText(hdd_proizvoditel, format); |
||
386 | cursor->insertText(tr(" "), format); |
||
387 | cursor->insertText(hdd_model, format); |
||
388 | cursor->insertText(tr(" "), format); |
||
389 | cursor->insertText(hdd_obem, format); |
||
390 | cursor->insertText(tr(" "), format); |
||
391 | ENTER |
||
392 | } |
||
393 | |||
394 | for (int l = 0; l < sgshm_otdel_list.at(i).user_list.at(m).system_block_list.at(k).privod_list.size(); ++l) |
||
395 | { |
||
396 | QString privod_proizvoditel, privod_model, privod_ID, privod_speed, privod_inv_num, privod_ser_num, privod_tip; |
||
397 | privod_proizvoditel = sgshm_otdel_list.at(i).user_list.at(m).system_block_list.at(k).privod_list.at(l).proizvoditel; |
||
398 | privod_model = sgshm_otdel_list.at(i).user_list.at(m).system_block_list.at(k).privod_list.at(l).model; |
||
399 | privod_speed = sgshm_otdel_list.at(i).user_list.at(m).system_block_list.at(k).privod_list.at(l).speed; |
||
400 | privod_tip = sgshm_otdel_list.at(i).user_list.at(m).system_block_list.at(k).privod_list.at(l).tip; |
||
401 | cursor->insertText(tr(" : "), format); |
||
402 | cursor->insertText(privod_tip, format); |
||
403 | cursor->insertText(tr(" "), format); |
||
404 | cursor->insertText(privod_proizvoditel, format); |
||
405 | cursor->insertText(tr(" "), format); |
||
406 | cursor->insertText(privod_model, format); |
||
407 | cursor->insertText(tr(" "), format); |
||
408 | cursor->insertText(privod_speed, format); |
||
409 | //cursor->insertText(tr(" "), format); |
||
410 | ENTER |
||
411 | } |
||
412 | |||
413 | for (int l = 0; l < sgshm_otdel_list.at(i).user_list.at(m).system_block_list.at(k).videocard_list.size(); ++l) |
||
414 | { |
||
415 | QString videocard_proizvoditel, videocard_model, videocard_ID, videocard_ram_size, videocard_inv_num, videocard_ser_num, videocard_interfeis; |
||
416 | videocard_proizvoditel = sgshm_otdel_list.at(i).user_list.at(m).system_block_list.at(k).videocard_list.at(l).proizvoditel; |
||
417 | videocard_model = sgshm_otdel_list.at(i).user_list.at(m).system_block_list.at(k).videocard_list.at(l).model; |
||
418 | videocard_ram_size = sgshm_otdel_list.at(i).user_list.at(m).system_block_list.at(k).videocard_list.at(l).memory_value; |
||
419 | videocard_inv_num = sgshm_otdel_list.at(i).user_list.at(m).system_block_list.at(k).videocard_list.at(l).inv_num; |
||
420 | videocard_ser_num = sgshm_otdel_list.at(i).user_list.at(m).system_block_list.at(k).videocard_list.at(l).ser_num; |
||
421 | videocard_interfeis = sgshm_otdel_list.at(i).user_list.at(m).system_block_list.at(k).videocard_list.at(l).interfeis; |
||
422 | cursor->insertText(tr(" : "), format); |
||
423 | cursor->insertText(videocard_interfeis, format); |
||
424 | cursor->insertText(tr(" "), format); |
||
425 | cursor->insertText(videocard_proizvoditel, format); |
||
426 | cursor->insertText(tr(" "), format); |
||
427 | cursor->insertText(videocard_model, format); |
||
428 | cursor->insertText(tr(" "), format); |
||
429 | cursor->insertText(videocard_ram_size, format); |
||
430 | cursor->insertText(tr(" "), format); |
||
431 | // cursor->insertText(privod_speed, format); |
||
432 | cursor->insertText(tr(" M"), format); |
||
433 | ENTER |
||
434 | } |
||
435 | |||
436 | for (int l = 0; l < sgshm_otdel_list.at(i).user_list.at(m).system_block_list.at(k).soundcard_list.size(); ++l) |
||
437 | { |
||
438 | QString soundcard_proizvoditel, soundcard_model, soundcard_ID, soundcard_ram_size, soundcard_inv_num, soundcard_ser_num, soundcard_interfeis; |
||
439 | soundcard_proizvoditel = sgshm_otdel_list.at(i).user_list.at(m).system_block_list.at(k).soundcard_list.at(l).proizvoditel; |
||
440 | soundcard_model = sgshm_otdel_list.at(i).user_list.at(m).system_block_list.at(k).soundcard_list.at(l).model; |
||
441 | // soundcard_ram_size = sgshm_otdel_list.at(i).user_list.at(m).system_block_list.at(k).videocard_list.at(l).memory_value; |
||
442 | soundcard_inv_num = sgshm_otdel_list.at(i).user_list.at(m).system_block_list.at(k).soundcard_list.at(l).inv_num; |
||
443 | soundcard_ser_num = sgshm_otdel_list.at(i).user_list.at(m).system_block_list.at(k).soundcard_list.at(l).ser_num; |
||
444 | // soundcard_interfeis = sgshm_otdel_list.at(i).user_list.at(m).system_block_list.at(k).videocard_list.at(l).interfeis; |
||
445 | cursor->insertText(tr(" : "), format); |
||
446 | cursor->insertText(soundcard_proizvoditel, format); |
||
447 | cursor->insertText(tr(" "), format); |
||
448 | // cursor->insertText(videocard_proizvoditel, format); |
||
449 | // cursor->insertText(tr(" "), format); |
||
450 | cursor->insertText(soundcard_model, format); |
||
451 | cursor->insertText(tr(" "), format); |
||
452 | // cursor->insertText(videocard_ram_size, format); |
||
453 | // cursor->insertText(tr(" "), format); |
||
454 | // cursor->insertText(privod_speed, format); |
||
455 | // cursor->insertText(tr(" M"), format); |
||
456 | ENTER |
||
457 | } |
||
458 | |||
459 | for (int l = 0; l < sgshm_otdel_list.at(i).user_list.at(m).system_block_list.at(k).lancard_list.size(); ++l) |
||
460 | { |
||
461 | QString lancard_proizvoditel, lancard_model, lancard_ID, lancard_ram_size, lancard_inv_num, lancard_ser_num, landcard_interfeis; |
||
462 | lancard_proizvoditel = sgshm_otdel_list.at(i).user_list.at(m).system_block_list.at(k).lancard_list.at(l).proizvoditel; |
||
463 | lancard_model = sgshm_otdel_list.at(i).user_list.at(m).system_block_list.at(k).lancard_list.at(l).model; |
||
464 | // soundcard_ram_size = sgshm_otdel_list.at(i).user_list.at(m).system_block_list.at(k).videocard_list.at(l).memory_value; |
||
465 | lancard_inv_num = sgshm_otdel_list.at(i).user_list.at(m).system_block_list.at(k).lancard_list.at(l).inv_num; |
||
466 | lancard_ser_num = sgshm_otdel_list.at(i).user_list.at(m).system_block_list.at(k).lancard_list.at(l).ser_num; |
||
467 | // soundcard_interfeis = sgshm_otdel_list.at(i).user_list.at(m).system_block_list.at(k).videocard_list.at(l).interfeis; |
||
468 | cursor->insertText(tr(" : "), format); |
||
469 | cursor->insertText(lancard_proizvoditel, format); |
||
470 | cursor->insertText(tr(" "), format); |
||
471 | // cursor->insertText(videocard_proizvoditel, format); |
||
472 | // cursor->insertText(tr(" "), format); |
||
473 | cursor->insertText(lancard_model, format); |
||
474 | cursor->insertText(tr(" "), format); |
||
475 | // cursor->insertText(videocard_ram_size, format); |
||
476 | // cursor->insertText(tr(" "), format); |
||
477 | // cursor->insertText(privod_speed, format); |
||
478 | // cursor->insertText(tr(" M"), format); |
||
479 | ENTER |
||
480 | } |
||
481 | |||
482 | |||
483 | |||
484 | |||
485 | } |
||
486 | |||
487 | ENTER |
||
488 | ENTER |
||
489 | |||
490 | |||
491 | } |
||
492 | |||
493 | |||
494 | ENTER |
||
495 | } |
||
496 | } |
||
497 | |||
498 | |||
499 | QList<TSystemBlock> raportForm::get_sys_block_list(QString id_otv_lica) |
||
500 | { |
||
501 | QList<TSystemBlock> sys_block_list_rtrn; |
||
502 | TSystemBlock sys_block_tmp; |
||
503 | QString result, prResult; |
||
504 | QVariant data_tmp; |
||
505 | QString sqlQueryText; |
||
506 | QString serial_num, inventar_num, proizvoditel, model, system_block_id; |
||
507 | QSqlQuery quer; |
||
508 | QString MB_information, Memory_information, CPU_information, HDD_information, CD_DVD_information, Vidio_information; |
||
509 | QString Sound_card_information, Lan_card_information; |
||
510 | int field_serialNum, field_inventarNum, field_proizvoditel, field_model, field_system_block_id, field_data_pokypki; |
||
511 | // QSqlQuery qns(tr("SET NAMES utf8"));// |
||
512 | QTreeWidgetItem *itemSysBlock; |
||
513 | // sqlQueryText.reserve(300); |
||
514 | sqlQueryText = tr("select system_blocks._, system_blocks._, system_blocks._, system_blocks." |
||
515 | " from system_blocks" |
||
516 | " where system_blocks.__ ="); |
||
517 | sqlQueryText.append(id_otv_lica); |
||
518 | // sqlQueryText.append(tr(" AND _.__ = _.")); |
||
519 | quer.prepare(sqlQueryText); |
||
520 | // quer.prepare(tr("select _._, _._,_., _. from _,_ where _.__ = 4 AND _.__ = _.;")); |
||
521 | quer.exec(); |
||
522 | field_serialNum = quer.record().indexOf(tr("_")); |
||
523 | field_inventarNum = quer.record().indexOf(tr("_")); |
||
524 | field_system_block_id = quer.record().indexOf(tr("")); |
||
525 | // field_proizvoditel = quer.record().indexOf(tr("")); |
||
526 | // field_model = quer.record().indexOf(tr("")); |
||
527 | while(quer.next()){ |
||
528 | QList <TMatheboard> mb_list_tmp; |
||
529 | QList <TMemory> memory_list_tmp; |
||
530 | QList<TCpu> cpu_list_tmp; |
||
531 | QList<THarddisc> harddisc_list_tmp; |
||
532 | QList<TPrivod> privod_list_tmp; |
||
533 | QList<TVideocard> videocard_list_tmp; |
||
534 | QList<TSoundcard> soundcard_list_tmp; |
||
535 | QList<TLancard> lancard_list_tmp; |
||
536 | system_block_id = quer.value(field_system_block_id).toString(); // |
||
537 | sys_block_tmp.ID = system_block_id; |
||
538 | prResult = ""; |
||
539 | serial_num = quer.value(field_serialNum).toString(); |
||
540 | sys_block_tmp.ser_num = serial_num; |
||
541 | inventar_num = quer.value(field_inventarNum).toString(); |
||
542 | sys_block_tmp.inv_num = inventar_num; |
||
543 | mb_list_tmp = get_matheboard_list(system_block_id); |
||
544 | sys_block_tmp.mb_list = mb_list_tmp; |
||
545 | memory_list_tmp = get_memory_list(system_block_id); |
||
546 | sys_block_tmp.memory_list = memory_list_tmp; |
||
547 | cpu_list_tmp = get_cpu_list(system_block_id); |
||
548 | sys_block_tmp.cpu_list = cpu_list_tmp; |
||
549 | harddisc_list_tmp = get_harddisc_list(system_block_id); |
||
550 | sys_block_tmp.harddisc_list = harddisc_list_tmp; |
||
551 | privod_list_tmp = get_privod_list(system_block_id); |
||
552 | sys_block_tmp.privod_list = privod_list_tmp; |
||
553 | videocard_list_tmp = get_videocard_list(system_block_id); |
||
554 | sys_block_tmp.videocard_list = videocard_list_tmp; |
||
555 | soundcard_list_tmp = get_soundcard_list(system_block_id); |
||
556 | sys_block_tmp.soundcard_list = soundcard_list_tmp; |
||
557 | lancard_list_tmp = get_lancard_list(system_block_id); |
||
558 | sys_block_tmp.lancard_list = lancard_list_tmp; |
||
559 | |||
560 | sys_block_list_rtrn.append(sys_block_tmp); |
||
561 | } |
||
562 | return sys_block_list_rtrn; |
||
563 | } |
||
564 | |||
565 | |||
566 | QList<TMatheboard> raportForm::get_matheboard_list(QString id_system_block) |
||
567 | { |
||
568 | TMatheboard matheboard_tmp; |
||
569 | QList<TMatheboard> mb_list_rtrn; |
||
570 | QString result, tmp; |
||
571 | QString MB_proizvoditel, MB_model, MB_identifikator, MB_serial_num, MB_inventar_num; |
||
572 | QString MatheBoardSqlQueryText; |
||
573 | QSqlQuery MatheBoardQuery; |
||
574 | int field_proizvoditel, field_model, field_identifikator, field_serial_num, field_inventar_num; |
||
575 | QTreeWidgetItem *itemMB, *itmMB_block; |
||
576 | MatheBoardSqlQueryText = tr("select * " |
||
577 | " from matheboards where matheboards.__ = " |
||
578 | ); |
||
579 | MatheBoardSqlQueryText.append(id_system_block); |
||
580 | MatheBoardQuery.prepare(MatheBoardSqlQueryText); |
||
581 | MatheBoardQuery.exec(); |
||
582 | field_identifikator = MatheBoardQuery.record().indexOf(tr("")); |
||
583 | field_proizvoditel = MatheBoardQuery.record().indexOf(tr("")); |
||
584 | field_model = MatheBoardQuery.record().indexOf(tr("")); |
||
585 | field_serial_num = MatheBoardQuery.record().indexOf(tr("_")); |
||
586 | field_inventar_num = MatheBoardQuery.record().indexOf(tr("_")); |
||
587 | |||
588 | |||
589 | while(MatheBoardQuery.next()){ |
||
590 | tmp = ""; |
||
591 | MB_identifikator = MatheBoardQuery.value(field_identifikator).toString(); |
||
592 | MB_proizvoditel = MatheBoardQuery.value(field_proizvoditel).toString(); |
||
593 | MB_model = MatheBoardQuery.value(field_model).toString(); |
||
594 | MB_serial_num = MatheBoardQuery.value(field_serial_num).toString(); |
||
595 | MB_inventar_num = MatheBoardQuery.value(field_inventar_num).toString(); |
||
596 | |||
597 | matheboard_tmp.ID = MB_identifikator; |
||
598 | matheboard_tmp.proizvoditel = MB_proizvoditel; |
||
599 | matheboard_tmp.model = MB_model; |
||
600 | matheboard_tmp.ser_num = MB_serial_num; |
||
601 | matheboard_tmp.inv_num = MB_inventar_num; |
||
602 | |||
603 | mb_list_rtrn.append(matheboard_tmp); |
||
604 | |||
605 | /* if (MB_proizvoditel != "") { |
||
606 | // tmp.append(tr("MB: ")); |
||
607 | tmp.append(MB_proizvoditel); |
||
608 | } |
||
609 | if (MB_model != "") {tmp.append(tr(" ")); |
||
610 | tmp.append(MB_model); |
||
611 | tmp.append(tr(" "));} |
||
612 | result.append(tmp); |
||
613 | |||
614 | itemMB = new QTreeWidgetItem(itemSysBlock); |
||
615 | itemMB->setIcon(4, matheboard_icon); |
||
616 | itemMB->setText(4, tmp); |
||
617 | itemMB->setText(12, MB_identifikator); |
||
618 | itemMB->setText(13, id_systemBlock); |
||
619 | itemMB->setText(14, id_otvetstvennogo_lica); |
||
620 | itemMB->setText(2, tr(" ")); |
||
621 | itemMB->setText(3, MB_inventar_num); |
||
622 | if (id_systemBlock !="1") itemSysBlock->setText(5, tmp); |
||
623 | */ |
||
624 | } |
||
625 | return mb_list_rtrn; |
||
626 | } |
||
627 | |||
628 | QList<TMemory> raportForm::get_memory_list(QString id_system_block) |
||
629 | { |
||
630 | TMemory memory_tmp; |
||
631 | QList <TMemory> memory_list_rtrn; |
||
632 | QString result, tmp; |
||
633 | QString Memiry_id, Memory_proizvoditel, Memory_type, Memory_obem, Memory_inventar_num, Memory_serial_num; |
||
634 | QString MemorySqlQueryText; |
||
635 | QSqlQuery MemoryQuery; |
||
636 | int field_proizvoditel, field_type, field_obem, field_id, field_inventar_num, field_sereal_num; |
||
637 | // QTreeWidgetItem *itemMemory, *itemMemory_block; |
||
638 | MemorySqlQueryText = tr("select memory.* " |
||
639 | " from memory where memory.__ = " |
||
640 | ); |
||
641 | MemorySqlQueryText.append(id_system_block); |
||
642 | MemoryQuery.prepare(MemorySqlQueryText); |
||
643 | MemoryQuery.exec(); |
||
644 | field_id = MemoryQuery.record().indexOf(tr("")); |
||
645 | field_proizvoditel = MemoryQuery.record().indexOf(tr("")); |
||
646 | field_type = MemoryQuery.record().indexOf(tr("")); |
||
647 | field_obem = MemoryQuery.record().indexOf(tr("")); |
||
648 | field_inventar_num = MemoryQuery.record().indexOf(tr("_")); |
||
649 | field_sereal_num = MemoryQuery.record().indexOf(tr("_")); |
||
650 | |||
651 | while(MemoryQuery.next()){ |
||
652 | // tmp = tr("RAM: "); |
||
653 | tmp = tr(""); |
||
654 | Memiry_id = MemoryQuery.value(field_id).toString(); |
||
655 | Memory_proizvoditel = MemoryQuery.value(field_proizvoditel).toString(); |
||
656 | Memory_type = MemoryQuery.value(field_type).toString(); |
||
657 | Memory_obem = MemoryQuery.value(field_obem).toString(); |
||
658 | Memory_inventar_num = MemoryQuery.value(field_inventar_num).toString(); |
||
659 | Memory_serial_num = MemoryQuery.value(field_sereal_num).toString(); |
||
660 | memory_tmp.ID = Memiry_id; |
||
661 | memory_tmp.proizvoditel = Memory_proizvoditel; |
||
662 | memory_tmp.obem = Memory_obem; |
||
663 | memory_tmp.tip = Memory_type; |
||
664 | memory_tmp.inv_num = Memory_inventar_num; |
||
665 | memory_tmp.ser_num = Memory_serial_num; |
||
666 | //// if (Memory_proizvoditel != "") { |
||
667 | //// tmp.append(Memory_proizvoditel);} |
||
668 | /* |
||
669 | if (Memory_type != "") {tmp.append(tr(" ")); |
||
670 | tmp.append(Memory_type); |
||
671 | tmp.append(tr(" "));} |
||
672 | if (Memory_obem != "") {tmp.append(tr(" ")); |
||
673 | tmp.append(Memory_obem); |
||
674 | tmp.append(tr("MB; "));} |
||
675 | result.append(tmp); |
||
676 | */ |
||
677 | memory_list_rtrn.append(memory_tmp); |
||
678 | } |
||
679 | return memory_list_rtrn; |
||
680 | } |
||
681 | |||
682 | |||
683 | QList<TCpu> raportForm::get_cpu_list(QString id_system_block) |
||
684 | { |
||
685 | TCpu cpu_tmp; |
||
686 | QList <TCpu> cpu_list_rtrn; |
||
687 | QString CPU_id, CPU_proizvoditel, CPU_slot, CPU_fqr, CPU_inventar_num, CPU_serial_num, CPU_model; |
||
688 | QString CpuSqlQueryText; |
||
689 | QSqlQuery CpuQuery; |
||
690 | int field_id, field_proizvoditel, field_slot, field_fqr, field_inventar_num, field_serial_num, field_model; |
||
691 | CpuSqlQueryText = tr("select processors.* " |
||
692 | " from processors where processors.__ = " |
||
693 | ); |
||
694 | CpuSqlQueryText.append(id_system_block); |
||
695 | CpuQuery.prepare(CpuSqlQueryText); |
||
696 | CpuQuery.exec(); |
||
697 | field_id = CpuQuery.record().indexOf(tr("")); |
||
698 | field_proizvoditel = CpuQuery.record().indexOf(tr("")); |
||
699 | field_slot = CpuQuery.record().indexOf(tr("")); |
||
700 | field_fqr = CpuQuery.record().indexOf(tr("")); |
||
701 | field_inventar_num = CpuQuery.record().indexOf(tr("_")); |
||
702 | field_serial_num = CpuQuery.record().indexOf(tr("_")); |
||
703 | field_model = CpuQuery.record().indexOf(tr("")); |
||
704 | |||
705 | while(CpuQuery.next()){ |
||
706 | CPU_id = CpuQuery.value(field_id).toString(); |
||
707 | CPU_proizvoditel = CpuQuery.value(field_proizvoditel).toString(); |
||
708 | CPU_slot = CpuQuery.value(field_slot).toString(); |
||
709 | CPU_fqr = CpuQuery.value(field_fqr).toString(); |
||
710 | CPU_inventar_num = CpuQuery.value(field_inventar_num).toString(); |
||
711 | CPU_serial_num = CpuQuery.value(field_serial_num).toString(); |
||
712 | CPU_model = CpuQuery.value(field_model).toString(); |
||
713 | |||
714 | cpu_tmp.ID = CPU_id; |
||
715 | cpu_tmp.proizvoditel = CPU_proizvoditel; |
||
716 | cpu_tmp.slot = CPU_slot; |
||
717 | cpu_tmp.fqr = CPU_fqr; |
||
718 | cpu_tmp.inv_num = CPU_inventar_num; |
||
719 | cpu_tmp.ser_num = CPU_serial_num; |
||
720 | cpu_tmp.model = CPU_model; |
||
721 | cpu_list_rtrn.append(cpu_tmp); |
||
722 | } |
||
723 | return cpu_list_rtrn; |
||
724 | } |
||
725 | |||
726 | QList<THarddisc> raportForm::get_harddisc_list(QString id_system_block) |
||
727 | { |
||
728 | QList<THarddisc> harddisc_list_rtrn; |
||
729 | THarddisc harddisc_tmp; |
||
730 | QString result, tmp; |
||
731 | QString HDD_id, HDD_proizvoditel, HDD_interfeis, HDD_obem, HDD_inventar_num, HDD_serial_num; |
||
732 | QString HDDSqlQueryText; |
||
733 | QSqlQuery HDDQuery; |
||
734 | int field_id, field_proizvoditel, field_interfeis, field_obem, field_inventar_num, field_serial_num; |
||
735 | HDDSqlQueryText = tr("select harddiscs.* " |
||
736 | " from harddiscs where harddiscs.__ = " |
||
737 | ); |
||
738 | HDDSqlQueryText.append(id_system_block); |
||
739 | HDDQuery.prepare(HDDSqlQueryText); |
||
740 | HDDQuery.exec(); |
||
741 | field_id = HDDQuery.record().indexOf(tr("")); |
||
742 | field_proizvoditel = HDDQuery.record().indexOf(tr("")); |
||
743 | field_interfeis = HDDQuery.record().indexOf(tr("")); |
||
744 | field_obem = HDDQuery.record().indexOf(tr("")); |
||
745 | field_inventar_num = HDDQuery.record().indexOf(tr("_")); |
||
746 | field_serial_num = HDDQuery.record().indexOf(tr("_")); |
||
747 | |||
748 | while(HDDQuery.next()){ |
||
749 | // tmp = tr("HDD: "); |
||
750 | tmp = tr(""); |
||
751 | HDD_id = HDDQuery.value(field_id).toString(); |
||
752 | HDD_proizvoditel = HDDQuery.value(field_proizvoditel).toString(); |
||
753 | HDD_interfeis = HDDQuery.value(field_interfeis).toString(); |
||
754 | HDD_obem = HDDQuery.value(field_obem).toString(); |
||
755 | HDD_inventar_num = HDDQuery.value(field_inventar_num).toString(); |
||
756 | HDD_serial_num = HDDQuery.value(field_serial_num).toString(); |
||
757 | harddisc_tmp.ID = HDD_id; |
||
758 | harddisc_tmp.proizvoditel = HDD_proizvoditel; |
||
759 | harddisc_tmp.interfeis = HDD_interfeis; |
||
760 | harddisc_tmp.obem = HDD_obem; |
||
761 | harddisc_tmp.inv_num = HDD_inventar_num; |
||
762 | harddisc_tmp.ser_num = HDD_serial_num; |
||
763 | harddisc_list_rtrn.append(harddisc_tmp); |
||
764 | } |
||
765 | |||
766 | // if (result!="") itemSysBlock->setIcon(7, hdd_icon); |
||
767 | // if (id_systemBlock !="1") itemSysBlock->setText(7, result); |
||
768 | return harddisc_list_rtrn; |
||
769 | |||
770 | } |
||
771 | |||
772 | |||
773 | QList<TPrivod> raportForm::get_privod_list(QString id_system_block) |
||
774 | { |
||
775 | TPrivod privod_tmp; |
||
776 | QList<TPrivod> privod_list_rtrn; |
||
777 | QString result, tmp; |
||
778 | QString CD_DVD_id, CD_DVD_proizvoditel, CD_DVD_type, CD_DVD_speed, CD_DVD_serial_num, CD_DVD_inventar_num; |
||
779 | QString CD_DVD_SqlQueryText; |
||
780 | QSqlQuery CD_DVD_Query; |
||
781 | int field_id, field_proizvoditel, field_type, field_speed, field_serial_num, field_inventar_num; |
||
782 | QTreeWidgetItem *item_CD_DVD; |
||
783 | QTreeWidgetItem *item_CD_DVD_block; |
||
784 | CD_DVD_SqlQueryText = tr("select cd_dvd.* " |
||
785 | " from cd_dvd where cd_dvd.__ = " |
||
786 | ); |
||
787 | CD_DVD_SqlQueryText.append(id_system_block); |
||
788 | CD_DVD_Query.prepare(CD_DVD_SqlQueryText); |
||
789 | CD_DVD_Query.exec(); |
||
790 | field_id = CD_DVD_Query.record().indexOf(tr("")); |
||
791 | field_proizvoditel = CD_DVD_Query.record().indexOf(tr("")); |
||
792 | field_type = CD_DVD_Query.record().indexOf(tr("")); |
||
793 | field_speed = CD_DVD_Query.record().indexOf(tr("")); |
||
794 | field_inventar_num = CD_DVD_Query.record().indexOf(tr("_")); |
||
795 | field_serial_num = CD_DVD_Query.record().indexOf(tr("_")); |
||
796 | |||
797 | /* |
||
798 | if (id_otvetstvennogo_lica == "1" && id_systemBlock == "1"){ |
||
799 | item_CD_DVD_block = new QTreeWidgetItem(itemSysBlock); |
||
800 | item_CD_DVD_block->setText(2, tr("")); |
||
801 | item_CD_DVD_block->setText(14, id_otvetstvennogo_lica); |
||
802 | } |
||
803 | */ |
||
804 | |||
805 | while(CD_DVD_Query.next()){ |
||
806 | // tmp = tr("CD/DVD: "); |
||
807 | tmp = tr(""); |
||
808 | CD_DVD_id = CD_DVD_Query.value(field_id).toString(); |
||
809 | CD_DVD_proizvoditel = CD_DVD_Query.value(field_proizvoditel).toString(); |
||
810 | CD_DVD_type = CD_DVD_Query.value(field_type).toString(); |
||
811 | CD_DVD_speed = CD_DVD_Query.value(field_speed).toString(); |
||
812 | CD_DVD_serial_num = CD_DVD_Query.value(field_serial_num).toString(); |
||
813 | CD_DVD_inventar_num = CD_DVD_Query.value(field_inventar_num).toString(); |
||
814 | |||
815 | privod_tmp.ID = CD_DVD_id; |
||
816 | privod_tmp.proizvoditel = CD_DVD_proizvoditel; |
||
817 | privod_tmp.tip = CD_DVD_type; |
||
818 | privod_tmp.speed = CD_DVD_speed; |
||
819 | privod_tmp.inv_num = CD_DVD_inventar_num; |
||
820 | privod_tmp.ser_num = CD_DVD_serial_num; |
||
821 | privod_list_rtrn.append(privod_tmp); |
||
822 | /* |
||
823 | |||
824 | if (CD_DVD_type != "") { |
||
825 | tmp.append(CD_DVD_type);} |
||
826 | if (CD_DVD_proizvoditel != "") {tmp.append(tr(" ")); |
||
827 | tmp.append(CD_DVD_proizvoditel); |
||
828 | tmp.append(tr(" "));} |
||
829 | if (CD_DVD_speed != "") {tmp.append(tr(" ")); |
||
830 | tmp.append(CD_DVD_speed); |
||
831 | tmp.append(tr(" "));} |
||
832 | result.append(tmp); |
||
833 | |||
834 | if (id_otvetstvennogo_lica == "1" && id_systemBlock == "1"){ |
||
835 | item_CD_DVD = new QTreeWidgetItem(item_CD_DVD_block); |
||
836 | } |
||
837 | else item_CD_DVD = new QTreeWidgetItem(itemSysBlock); |
||
838 | |||
839 | item_CD_DVD->setText(2, tr("")); |
||
840 | item_CD_DVD->setText(12, CD_DVD_id); |
||
841 | item_CD_DVD->setText(13, id_systemBlock); |
||
842 | item_CD_DVD->setText(14, id_otvetstvennogo_lica); |
||
843 | item_CD_DVD->setIcon(4, cd_dvd_icon); |
||
844 | item_CD_DVD->setText(4, tmp); |
||
845 | item_CD_DVD->setText(3, CD_DVD_inventar_num); |
||
846 | */ |
||
847 | } |
||
848 | |||
849 | // if (id_systemBlock !="1") itemSysBlock->setText(8, result); |
||
850 | return privod_list_rtrn; |
||
851 | |||
852 | } |
||
853 | |||
854 | |||
855 | QList<TVideocard> raportForm::get_videocard_list(QString id_system_block) |
||
856 | { |
||
857 | QList<TVideocard> videocard_list_rtrn; |
||
858 | TVideocard videocard_tmp; |
||
859 | QString result, tmp; |
||
860 | QString Vidio_id, Vidio_proizvoditel, Vidio_model, Vidio_interfeis, Vidio_ram, Vidio_inventar_num, Vidio_sereal_num; |
||
861 | QString Vidio_SqlQueryText; |
||
862 | QSqlQuery Vidio_Query; |
||
863 | int field_id, field_proizvoditel, field_model, field_interfeis, field_ram, field_inventar_num, field_sereal_num; |
||
864 | QTreeWidgetItem *item_Vidio, *item_Vidio_block; |
||
865 | Vidio_SqlQueryText = tr("select videocards.* " |
||
866 | " from videocards where videocards.__ = " |
||
867 | ); |
||
868 | Vidio_SqlQueryText.append(id_system_block); |
||
869 | Vidio_Query.prepare(Vidio_SqlQueryText); |
||
870 | Vidio_Query.exec(); |
||
871 | field_id = Vidio_Query.record().indexOf(tr("")); |
||
872 | field_proizvoditel = Vidio_Query.record().indexOf(tr("")); |
||
873 | field_model = Vidio_Query.record().indexOf(tr("")); |
||
874 | field_interfeis = Vidio_Query.record().indexOf(tr("")); |
||
875 | field_ram = Vidio_Query.record().indexOf(tr("")); |
||
876 | field_inventar_num = Vidio_Query.record().indexOf(tr("_")); |
||
877 | field_sereal_num = Vidio_Query.record().indexOf(tr("_")); |
||
878 | |||
879 | |||
880 | /* |
||
881 | if (id_otvetstvennogo_lica == "1" && id_systemBlock == "1"){ |
||
882 | item_Vidio_block = new QTreeWidgetItem(itemSysBlock); |
||
883 | item_Vidio_block->setText(2, tr("")); |
||
884 | item_Vidio_block->setText(14, id_otvetstvennogo_lica); |
||
885 | } |
||
886 | */ |
||
887 | |||
888 | |||
889 | while(Vidio_Query.next()){ |
||
890 | // tmp = tr("CD/DVD: "); |
||
891 | tmp = tr(""); |
||
892 | Vidio_id = Vidio_Query.value(field_id).toString(); |
||
893 | Vidio_proizvoditel = Vidio_Query.value(field_proizvoditel).toString(); |
||
894 | Vidio_model = Vidio_Query.value(field_model).toString(); |
||
895 | Vidio_interfeis = Vidio_Query.value(field_interfeis).toString(); |
||
896 | Vidio_ram = Vidio_Query.value(field_ram).toString(); |
||
897 | Vidio_inventar_num = Vidio_Query.value(field_inventar_num).toString(); |
||
898 | Vidio_sereal_num = Vidio_Query.value(field_sereal_num).toString(); |
||
899 | |||
900 | |||
901 | videocard_tmp.ID = Vidio_id; |
||
902 | videocard_tmp.proizvoditel = Vidio_proizvoditel; |
||
903 | videocard_tmp.interfeis = Vidio_interfeis; |
||
904 | videocard_tmp.model = Vidio_model; |
||
905 | videocard_tmp.memory_value = Vidio_ram; |
||
906 | videocard_tmp.inv_num = Vidio_inventar_num; |
||
907 | videocard_tmp.ser_num = Vidio_sereal_num; |
||
908 | |||
909 | videocard_list_rtrn.append(videocard_tmp); |
||
910 | |||
911 | /* |
||
912 | if (Vidio_interfeis != "") {tmp.append(tr(" ")); |
||
913 | tmp.append(Vidio_interfeis);} |
||
914 | if (Vidio_proizvoditel != "") {tmp.append(tr(" ")); |
||
915 | tmp.append(Vidio_proizvoditel);} |
||
916 | if (Vidio_model != "") {tmp.append(tr(" ")); |
||
917 | tmp.append(Vidio_model);} |
||
918 | |||
919 | if (Vidio_ram !=""){tmp.append(tr(" ")); |
||
920 | tmp.append(Vidio_ram); |
||
921 | tmp.append(tr(" Mb")); |
||
922 | |||
923 | } |
||
924 | result.append(tmp); |
||
925 | |||
926 | if (id_otvetstvennogo_lica == "1" && id_systemBlock == "1"){ |
||
927 | item_Vidio = new QTreeWidgetItem(item_Vidio_block); |
||
928 | } |
||
929 | else item_Vidio = new QTreeWidgetItem(itemSysBlock); |
||
930 | |||
931 | |||
932 | // item_Vidio = new QTreeWidgetItem(itemSysBlock); |
||
933 | |||
934 | item_Vidio->setText(2, tr("")); |
||
935 | item_Vidio->setText(12, Vidio_id); |
||
936 | item_Vidio->setText(13, id_systemBlock); |
||
937 | item_Vidio->setText(14, id_otvetstvennogo_lica); |
||
938 | item_Vidio->setIcon(4, vidio_card_icon); |
||
939 | item_Vidio->setText(4, tmp); |
||
940 | item_Vidio->setText(3, Vidio_inventar_num); |
||
941 | */ |
||
942 | } |
||
943 | // if (id_systemBlock !="1") itemSysBlock->setText(9, result); |
||
944 | return videocard_list_rtrn; |
||
945 | } |
||
946 | |||
947 | QList<TSoundcard> raportForm::get_soundcard_list(QString id_system_block) |
||
948 | { |
||
949 | TSoundcard soundcard_tmp; |
||
950 | QList<TSoundcard> soundcard_list_rtrn; |
||
951 | QString result, tmp; |
||
952 | QString Sound_card_id, Sound_card_proizvoditel, Sound_card_model, Sound_card_inventar_num, Sound_card_serial_num; |
||
953 | QString Sound_card_SqlQueryText; |
||
954 | QSqlQuery Sound_card_Query; |
||
955 | int field_id, field_proizvoditel, field_model, field_inventar_num, field_serial_num; |
||
956 | QTreeWidgetItem *item_Sound_card, *item_Sound_card_block; |
||
957 | Sound_card_SqlQueryText = tr("select soundcards.* " |
||
958 | " from soundcards where soundcards.__ = " |
||
959 | ); |
||
960 | Sound_card_SqlQueryText.append(id_system_block); |
||
961 | Sound_card_Query.prepare(Sound_card_SqlQueryText); |
||
962 | Sound_card_Query.exec(); |
||
963 | field_id = Sound_card_Query.record().indexOf(tr("")); |
||
964 | field_proizvoditel = Sound_card_Query.record().indexOf(tr("")); |
||
965 | field_model = Sound_card_Query.record().indexOf(tr("")); |
||
966 | field_inventar_num = Sound_card_Query.record().indexOf(tr("_")); |
||
967 | field_serial_num = Sound_card_Query.record().indexOf(tr("_")); |
||
968 | |||
969 | /* |
||
970 | if (id_otvetstvennogo_lica == "1" && id_systemBlock == "1"){ |
||
971 | item_Sound_card_block = new QTreeWidgetItem(itemSysBlock); |
||
972 | item_Sound_card_block->setText(2, tr(" ")); |
||
973 | item_Sound_card_block->setText(14, id_otvetstvennogo_lica); |
||
974 | } |
||
975 | */ |
||
976 | while(Sound_card_Query.next()){ |
||
977 | // tmp = tr("CD/DVD: "); |
||
978 | tmp = tr(""); |
||
979 | Sound_card_id = Sound_card_Query.value(field_id).toString(); |
||
980 | Sound_card_proizvoditel = Sound_card_Query.value(field_proizvoditel).toString(); |
||
981 | Sound_card_model = Sound_card_Query.value(field_model).toString(); |
||
982 | Sound_card_inventar_num = Sound_card_Query.value(field_inventar_num).toString(); |
||
983 | Sound_card_serial_num = Sound_card_Query.value(field_serial_num).toString(); |
||
984 | |||
985 | soundcard_tmp.ID = Sound_card_id; |
||
986 | soundcard_tmp.proizvoditel = Sound_card_proizvoditel; |
||
987 | soundcard_tmp.model = Sound_card_model; |
||
988 | soundcard_tmp.inv_num = Sound_card_inventar_num; |
||
989 | soundcard_tmp.ser_num = Sound_card_serial_num; |
||
990 | |||
991 | soundcard_list_rtrn.append(soundcard_tmp); |
||
992 | // Vidio_interfeis = Vidio_Query.value(field_interfeis).toString(); |
||
993 | // Vidio_ram = Vidio_Query.value(field_ram).toString(); |
||
994 | |||
995 | /* |
||
996 | if (Sound_card_proizvoditel != "") {tmp.append(tr(" ")); |
||
997 | tmp.append(Sound_card_proizvoditel);} |
||
998 | |||
999 | if (Sound_card_model != "") {tmp.append(tr(" ")); |
||
1000 | tmp.append(Sound_card_model);} |
||
1001 | |||
1002 | /// if (Vidio_ram !=""){tmp.append(tr(" ")); |
||
1003 | /// tmp.append(Vidio_ram); |
||
1004 | /// tmp.append(tr(" Mb")); |
||
1005 | |||
1006 | /// } |
||
1007 | result.append(tmp); |
||
1008 | |||
1009 | if (id_otvetstvennogo_lica == "1" && id_systemBlock == "1"){ |
||
1010 | item_Sound_card = new QTreeWidgetItem(item_Sound_card_block); |
||
1011 | } |
||
1012 | else item_Sound_card = new QTreeWidgetItem(itemSysBlock); |
||
1013 | |||
1014 | |||
1015 | // item_Sound_card = new QTreeWidgetItem(itemSysBlock); |
||
1016 | |||
1017 | |||
1018 | item_Sound_card->setText(2, tr(" ")); |
||
1019 | item_Sound_card->setText(12, Sound_card_id); |
||
1020 | item_Sound_card->setText(13, id_systemBlock); |
||
1021 | item_Sound_card->setText(14, id_otvetstvennogo_lica); |
||
1022 | item_Sound_card->setIcon(4, sound_card_icon); |
||
1023 | item_Sound_card->setText(4, tmp); |
||
1024 | item_Sound_card->setText(3, Sound_card_inventar_num); |
||
1025 | */ |
||
1026 | } |
||
1027 | // if (id_systemBlock !="1") itemSysBlock->setText(10, result); |
||
1028 | return soundcard_list_rtrn; |
||
1029 | |||
1030 | } |
||
1031 | |||
1032 | QList<TLancard> raportForm::get_lancard_list(QString id_system_block) |
||
1033 | { |
||
1034 | |||
1035 | TLancard lancard_tmp; |
||
1036 | QList<TLancard> lancard_list_rtrn; |
||
1037 | QString result, tmp; |
||
1038 | QString Lan_card_id, Lan_card_proizvoditel, Lan_card_model, Lan_speed, Lan_inventar_num, Lan_serial_num; |
||
1039 | QString Lan_card_SqlQueryText; |
||
1040 | QSqlQuery Lan_card_Query; |
||
1041 | int field_id, field_proizvoditel, field_model, field_speed, field_serial_num, field_inventar_num; |
||
1042 | QTreeWidgetItem *item_Lan_card, *item_Lan_card_block; |
||
1043 | Lan_card_SqlQueryText = tr("select lancards.* " |
||
1044 | " from lancards where lancards.__ = " |
||
1045 | ); |
||
1046 | Lan_card_SqlQueryText.append(id_system_block); |
||
1047 | Lan_card_Query.prepare(Lan_card_SqlQueryText); |
||
1048 | Lan_card_Query.exec(); |
||
1049 | field_id = Lan_card_Query.record().indexOf(tr("")); |
||
1050 | field_proizvoditel = Lan_card_Query.record().indexOf(tr("")); |
||
1051 | field_model = Lan_card_Query.record().indexOf(tr("")); |
||
1052 | field_speed = Lan_card_Query.record().indexOf(tr("__")); |
||
1053 | field_serial_num = Lan_card_Query.record().indexOf(tr("_")); |
||
1054 | field_inventar_num = Lan_card_Query.record().indexOf(tr("_")); |
||
1055 | |||
1056 | /* |
||
1057 | if (id_otvetstvennogo_lica == "1" && id_systemBlock == "1"){ |
||
1058 | item_Lan_card_block = new QTreeWidgetItem(itemSysBlock); |
||
1059 | item_Lan_card_block->setText(2, tr(" ")); |
||
1060 | item_Lan_card_block->setText(14, id_otvetstvennogo_lica); |
||
1061 | } |
||
1062 | */ |
||
1063 | while(Lan_card_Query.next()){ |
||
1064 | // tmp = tr("CD/DVD: "); |
||
1065 | tmp = tr(""); |
||
1066 | Lan_card_id = Lan_card_Query.value(field_id).toString(); |
||
1067 | Lan_card_proizvoditel = Lan_card_Query.value(field_proizvoditel).toString(); |
||
1068 | Lan_card_model = Lan_card_Query.value(field_model).toString(); |
||
1069 | Lan_speed = Lan_card_Query.value(field_speed).toString(); |
||
1070 | Lan_inventar_num = Lan_card_Query.value(field_inventar_num).toString(); |
||
1071 | Lan_serial_num = Lan_card_Query.value(field_serial_num).toString(); |
||
1072 | |||
1073 | lancard_tmp.ID = Lan_card_id; |
||
1074 | lancard_tmp.proizvoditel = Lan_card_proizvoditel; |
||
1075 | lancard_tmp.model = Lan_card_model; |
||
1076 | lancard_tmp.speed = Lan_speed; |
||
1077 | lancard_tmp.ser_num = Lan_serial_num; |
||
1078 | lancard_tmp.inv_num = Lan_inventar_num; |
||
1079 | |||
1080 | lancard_list_rtrn.append(lancard_tmp); |
||
1081 | // Vidio_interfeis = Vidio_Query.value(field_interfeis).toString(); |
||
1082 | // Vidio_ram = Vidio_Query.value(field_ram).toString(); |
||
1083 | |||
1084 | /* |
||
1085 | if (Lan_card_proizvoditel != "") {tmp.append(tr(" ")); |
||
1086 | tmp.append(Lan_card_proizvoditel);} |
||
1087 | |||
1088 | if (Lan_card_model != "") {tmp.append(tr(" ")); |
||
1089 | tmp.append(Lan_card_model);} |
||
1090 | |||
1091 | if (Lan_speed != "") {tmp.append(tr(" ")); |
||
1092 | tmp.append(Lan_speed); |
||
1093 | tmp.append(tr(" Mbit"));} |
||
1094 | |||
1095 | |||
1096 | /// if (Vidio_ram !=""){tmp.append(tr(" ")); |
||
1097 | /// tmp.append(Vidio_ram); |
||
1098 | /// tmp.append(tr(" Mb")); |
||
1099 | |||
1100 | /// } |
||
1101 | result.append(tmp); |
||
1102 | |||
1103 | if (id_otvetstvennogo_lica == "1" && id_systemBlock == "1"){ |
||
1104 | item_Lan_card = new QTreeWidgetItem(item_Lan_card_block); |
||
1105 | } |
||
1106 | else item_Lan_card = new QTreeWidgetItem(itemSysBlock); |
||
1107 | |||
1108 | // item_Lan_card = new QTreeWidgetItem(itemSysBlock); |
||
1109 | |||
1110 | |||
1111 | item_Lan_card->setText(2, tr(" ")); |
||
1112 | item_Lan_card->setText(12, Lan_card_id); |
||
1113 | item_Lan_card->setText(13, id_systemBlock); |
||
1114 | item_Lan_card->setText(14, id_otvetstvennogo_lica); |
||
1115 | item_Lan_card->setIcon(4, lan_card_icon); |
||
1116 | item_Lan_card->setText(4, tmp); |
||
1117 | item_Lan_card->setText(3, Lan_inventar_num); |
||
1118 | */ |
||
1119 | } |
||
1120 | // if (id_systemBlock !="1") itemSysBlock->setText(11, result); |
||
1121 | return lancard_list_rtrn; |
||
1122 | |||
1123 | } |
||
1124 | |||
1125 | void raportForm::on_print_raport() |
||
1126 | { |
||
1127 | print_raport(); |
||
1128 | } |
||
1129 | |||
1130 | void raportForm::on_print_raport_to_pdf() |
||
1131 | { |
||
1132 | print_raport_to_pdf(); |
||
1133 | } |
||
1134 |