Хранилища Subversion OpenInventory

Редакция

Редакция 14 | К новейшей редакции | Содержимое файла | Последнее изменение | Открыть журнал | RSS

Редакция Автор № строки Строка
6 pingvin 1
#include "mainwindowimpl.h"
2
//
3
MainWindowImpl::MainWindowImpl( QWidget * parent, Qt::WFlags f)
4
        : QMainWindow(parent, f)
5
{
6
 
7
 
8
 
9
        setupUi(this);
10
        fEnable_component_add = false; //    
11
        fEnable_naznachit_otvetstv = false;
12
        curr_task = no_task;
13
        readSettings();
14
        lineEdit->insert(baseName);
15
        metaDataAction = new QAction(tr(""), treeWidget);
16
        addMemoryAction = new QAction(tr("  "), treeWidget);
17
        MB_na_skladAction = new QAction(tr("  "), treeWidget);
18
        new_sotrydnikAction = new QAction(tr(" "), treeWidget);
19
        novoe_oborydovanieAction = new QAction(tr(" "), treeWidget);
20
        pereimenovat_otdelAction = new QAction(tr(" "), treeWidget);
21
        perevesti_sotrydnika_v_drygo1_otdelAction = new QAction(tr("   "), treeWidget);
22
        yvolit_sotrydnikaAction = new QAction(tr(" "), treeWidget);
23
        SpliterAction = new QAction(tr(""), treeWidget);
24
        naznachit_otvetstvennim_za_oborydovanieAction = new QAction(tr("   "), treeWidget);
25
        ystanovit_novie_complektyushieAction = new QAction(tr("  "), treeWidget);
26
        sozdat_otdelAction = new QAction(tr("  "), treeWidget);
27
 
28
        novaya_SYSTEM_BLOCK_na_skladAction = new QAction(tr("     "), treeWidget);
29
        novaya_MB_na_skladAction = new QAction(tr("     "), treeWidget);
30
        novaya_RAM_na_skladAction = new QAction(tr("     "),  treeWidget);
31
        novaya_CPU_na_skladAction = new QAction(tr("    "),  treeWidget);
32
        novaya_HDD_na_skladAction = new QAction(tr("    "),  treeWidget);
33
        novaya_CD_DVD_na_skladAction = new QAction(tr("    "),  treeWidget);
34
        novaya_VIDEO_na_skladAction = new QAction(tr("    "),  treeWidget);
35
        novaya_SoundCard_na_skladAction = new QAction(tr("     "),  treeWidget);
36
        novaya_LAN_na_skladAction = new QAction(tr("     "),  treeWidget);
37
        peredat_sys_block_pod_otveystvennostAction = new QAction(tr("     "),  treeWidget);
38
 
39
 
40
//      novaya_SoundCard_na_skladAction = new QAction(tr("     "),  treeWidget);
41
//      novaya_LAN_na_skladAction = new QAction(tr("     "),  treeWidget);
42
 
43
        insert_MB_to_system_blockAction = new QAction(tr("   "), treeWidget);
44
 
45
        treeWidget->addAction(metaDataAction);
46
        treeWidget->addAction(addMemoryAction);
47
 
48
 
49
        connect(insert_MB_to_system_blockAction, SIGNAL(triggered()), SLOT(insert_MB_to_system_block()));
50
        connect(novaya_MB_na_skladAction, SIGNAL(triggered()), SLOT(novaya_MB_na_sklad()));
51
        connect(novaya_RAM_na_skladAction, SIGNAL(triggered()), SLOT(novaya_RAM_na_sklad()));
52
        connect(novaya_CPU_na_skladAction, SIGNAL(triggered()), SLOT(novaya_CPU_na_sklad()));
53
        connect(novaya_HDD_na_skladAction, SIGNAL(triggered()), SLOT(novaya_HDD_na_sklad()));
54
        connect(novaya_CD_DVD_na_skladAction, SIGNAL(triggered()), SLOT(novaya_CD_DVD_na_sklad()));
55
        connect(novaya_VIDEO_na_skladAction, SIGNAL(triggered()), SLOT(novaya_VIDEO_na_sklad()));
56
        connect(novaya_SoundCard_na_skladAction, SIGNAL(triggered()), SLOT(novaya_SoundCard_na_sklad()));
57
        connect(novaya_LAN_na_skladAction, SIGNAL(triggered()), SLOT(novaya_LAN_na_sklad()));
58
        connect(novaya_SYSTEM_BLOCK_na_skladAction, SIGNAL(triggered()), SLOT(novaya_SYSTEM_BLOCK_na_sklad()));
59
 
60
        connect(peredat_sys_block_pod_otveystvennostAction, SIGNAL(triggered()), SLOT(peredat_sys_block_pod_otveystvennost()));
61
 
62
        connect(sozdat_otdelAction, SIGNAL(triggered()), SLOT(addNewOtdel()));
63
 
64
 
65
        connect(metaDataAction, SIGNAL(triggered()), SLOT(editTreeWidget()));
66
        connect(addMemoryAction, SIGNAL(triggered()), SLOT(addNewMemory()));
67
        connect(MB_na_skladAction, SIGNAL(triggered()), SLOT(move_to_sklad()));
68
        connect(new_sotrydnikAction, SIGNAL(triggered()), SLOT(new_sotrydnik()));
69
        connect(novoe_oborydovanieAction, SIGNAL(triggered()), SLOT(novoe_oborydovanie()));
70
        connect(pereimenovat_otdelAction, SIGNAL(triggered()), SLOT(pereimenovft_otdel()));
71
        connect(yvolit_sotrydnikaAction, SIGNAL(triggered()), SLOT(yvolit_sotrydnika()));
72
        connect(naznachit_otvetstvennim_za_oborydovanieAction, SIGNAL(triggered()), SLOT(naznachit_otvetstvennim_za_oborydovanie()));
73
        connect(ystanovit_novie_complektyushieAction, SIGNAL(triggered()), SLOT(ystanovit_novie_complektyushie()));
74
        treeWidget->setContextMenuPolicy(Qt::ActionsContextMenu);      
75
        connect(openBaseAct, SIGNAL(triggered()), this, SLOT(openBase()));
76
        connect(openMemoryTableAct, SIGNAL(triggered()), this, SLOT(openMemoryTable()));
77
        connect(getsettingAct, SIGNAL(triggered()), this, SLOT(getSetting()));
78
        connect(addStringAct, SIGNAL(triggered()), this, SLOT(addString()));
79
        connect(delStringAct, SIGNAL(triggered()), this, SLOT(delString()));
80
        connect(FiltrButton, SIGNAL(clicked()), this, SLOT(filter()));
81
        connect(hiddenButton, SIGNAL(clicked()), this, SLOT(hiddenRow()));
82
        connect(showButton, SIGNAL(clicked()), this, SLOT(showRow()));
83
        connect(appyButton, SIGNAL(clicked()), this, SLOT(dbUpdate()));
84
        connect(treeWidget, SIGNAL(itemActivated(QTreeWidgetItem *item, int column)), this, SLOT(dblClick(QTreeWidgetItem *item, int column)));
85
        connect(&addmemFrm, SIGNAL(componentAdd()), this, SLOT(refreshTree()));//   addmemFrm  treeWidget
86
        connect(&addotdelFrm, SIGNAL(componentAdd()), this, SLOT(refreshTree()));//   addotdelFrm  treeWidget
87
        connect(&addsotrydnikFrm, SIGNAL(componentAdd()), this, SLOT(refreshTree()));//   addsotFrm  treeWidget
88
        connect(&addsysblockFrm, SIGNAL(componentAdd()), this, SLOT(refreshTree()));//   addsysblockFrm  treeWidget
89
 
90
        connect(&addmemFrm, SIGNAL(formClose()), this, SLOT(on_addmemoryForm_formClose()));
91
        connect(&addotdelFrm, SIGNAL(formClose()), this, SLOT(on_addmemoryForm_formClose()));
92
        connect(&addsotrydnikFrm, SIGNAL(formClose()), this, SLOT(on_addmemoryForm_formClose()));
93
        connect(&addsysblockFrm, SIGNAL(formClose()), this, SLOT(on_addmemoryForm_formClose()));
94
 
95
        connect(&process, SIGNAL(readyReadStandardOutput()), this, SLOT(readStandartProcessOutput()));
96
 
97
        comp_icon.addFile("./pc.png");
98
/////   hdd_icon.addFile("./gnome-dev-harddisk.png");
99
        hdd_icon.addFile("./hdd5.png");
100
        memory_icon.addFile("./memory1.png");
101
        cd_dvd_icon.addFile("./cd_dvd3.png");
102
//      memory_icon.addFile("./gnome-dev-memory.png");
103
        matheboard_icon.addFile("./icon_motherboard.png");
104
        cpu_icon.addFile("./cpu3.png");
105
        vidio_card_icon.addFile("./vidiocard2.png");
106
        sound_card_icon.addFile("./soundcard1.png");
107
        lan_card_icon.addFile("./lan1.png");
108
        appyButton->setIcon(comp_icon);
109
/////    for (int i = 0; i < 10; ++i)
110
/////     items.append(new QTreeWidgetItem((QTreeWidget*)0, QStringList(QString("item: %1").arg(i))));
111
/////    treeWidget->insertTopLevelItems(0, items);
112
//////items.append(new QTreeWidgetItem((QTreeWidget*)0, QStringList(QString(tr(": %1")).arg(0))));
113
/////////items.append(new QTreeWidgetItem((QTreeWidget*)0, QStringList(QString(tr(":")))));
114
/////////items.append(new QTreeWidgetItem((QTreeWidget*)0, QStringList(QString(tr(":")))));
115
/////////treeWidget->insertTopLevelItems(0, items);
116
 
117
//->itm = new QTreeWidgetItem(treeWidget);
118
//->itm->setText(0, tr(""));
119
/////////itm->setText(1, "hello1");
120
//->QTreeWidgetItem *itm1 = new QTreeWidgetItem(itm);
121
//->itm1->setText(1, tr("M1"));
122
//->QTreeWidgetItem *itm1_1 = new QTreeWidgetItem(itm1);
123
//->itm1_1->setText(2, tr(""));
124
//->QTreeWidgetItem *itm1_2 = new QTreeWidgetItem(itm1);
125
//->itm1_2->setText(2, tr(""));
126
 
127
//->QTreeWidgetItem *itm2 = new QTreeWidgetItem(itm);
128
//->itm2->setText(1, tr("M2"));
129
//////treeWidget->insertTopLevelItem(new QTreeWidgetItem((QTreeWidget*)0, QStringList(QString(tr(":")))));
130
}
131
 
132
MainWindowImpl::~MainWindowImpl()
133
{
134
        db.close();
135
//      delete setFrm;
136
}
137
 
138
 
139
void MainWindowImpl::delString()
140
{
141
        QModelIndex index;
142
        int column, row;
143
        QSqlRecord record;
144
        index=view.currentIndex();
145
        column=view.currentIndex().column();
146
        row=view.currentIndex().row();
147
        record = model->record(row);
148
        int UserNameIndex = record.indexOf(tr(""));
149
        QString ls_UserName=record.value(UserNameIndex).toString();
150
        model->removeRows(row, 1);
151
}
152
 
153
//
154
void MainWindowImpl::openBase()
155
{
156
        lineEdit->insert(tr("  "));
157
//      db = new QSqlDatabase("QMYSQL");
158
        db = QSqlDatabase::addDatabase("QMYSQL");
159
        pdb = &db;
160
        raportFrm.pdb = &db;
161
//      db->addDatabase("QMYSQL");
162
//db = QSqlDatabase::addDatabase("QSQLITE");
163
        pdb->setHostName(hostName);
164
        pdb->setDatabaseName(baseName);
165
        pdb->setUserName(userName);
166
        pdb->setPassword(password);
167
        bool ok = pdb->open();
168
        if (!ok) {
169
                                QMessageBox::critical( //     .
170
                                                                                this,                      //  .
171
                                                                                QObject::tr("Database Error"),   // .  
172
                                                                                pdb->lastError().text());          //  .
173
                         }
174
        if (ok)  
175
        {lineEdit-> insert(tr("  "));
176
        }
177
        else {lineEdit-> insert(tr(" .  : "));
178
                  lineEdit-> insert(pdb->lastError().text());
179
                 }
180
//      QSqlQuery q;
181
//      q.prepare(tr("set NAMES cp1251"));
182
 
183
//      ok = q.exec();
184
        model = new QSqlTableModel();
185
        model->setTable(tableName);
186
 
187
        model->setEditStrategy(QSqlTableModel::OnFieldChange);
188
//      model->setEditStrategy(QSqlTableModel::OnManualSubmit);
189
        model->setSort(0, Qt::AscendingOrder);
190
        model->select();
191
//      model->setHeaderData(0, Qt::Horizontal,
192
//                              QObject::tr("\n"));
193
//      model->setHeaderData(1, Qt::Horizontal,
194
//                             QObject::tr(""));
195
//      model->setHeaderData(2, Qt::Horizontal,
196
//                             QObject::tr("IP "));
197
//      model->setHeaderData(3, Qt::Horizontal,
198
//                             QObject::tr("\n"));
199
//      model->setHeaderData(4, Qt::Horizontal,
200
//                             QObject::tr("\n"));
201
//      view = new QTableView();
202
        view.setModel(model);
203
        view.setAlternatingRowColors(true);
204
//      view->resizeRowsToContents();
205
        view.resizeColumnsToContents();
206
        view.show();
207
        initTreeWidget();
208
}
209
 
210
void MainWindowImpl::openMemoryTable()
211
{
212
        memory_model = new QSqlTableModel();
213
        memory_model->setTable(tr(""));
214
//      memory_model->setTable(tableName);
215
        memory_model->setEditStrategy(QSqlTableModel::OnFieldChange);
216
//      model->setEditStrategy(QSqlTableModel::OnManualSubmit);
217
        memory_model->setSort(0, Qt::AscendingOrder);
218
        memory_model->select();
219
        tableView->setModel(memory_model);
220
        tableView->setAlternatingRowColors(true);
221
        tableView->resizeColumnsToContents();
222
        tableView->show();
223
/////   memory_view.setModel(memory_model);
224
/////   memory_view.setAlternatingRowColors(true);
225
//      view->resizeRowsToContents();
226
/////           memory_view.resizeColumnsToContents();
227
/////   memory_view.show();
228
}
229
 
230
 
231
void MainWindowImpl::applySetting()
232
{
233
        int i;
234
        i=5;
235
        lineEdit->insert(tr(" !"));
236
        baseName = setFrm->lineEdit->text();
237
        userName = setFrm->lineEdit_2->text();
238
        password = setFrm->lineEdit_3->text();
239
        tableName = setFrm->lineEdit_4->text();
240
        hostName = setFrm->lineEdit_5->text();
241
        i+=1;
242
        writeSettings();
243
        setFrm->close();
244
        delete setFrm;
245
}
246
 
247
void MainWindowImpl::writeSettings()
248
{
249
        QSettings settings("Trolltech", "Application Example");
250
        settings.setValue("baseName", baseName);
251
        settings.setValue("userName", userName);
252
        settings.setValue("password", password);
253
        settings.setValue("tableName", tableName);
254
        settings.setValue("hostName", hostName);
255
}
256
 
257
 
258
void MainWindowImpl::readSettings()
259
{
260
        QSettings settings("Trolltech", "Application Example");
261
        baseName = settings.value("baseName", "an_db").toString();
262
        userName = settings.value("userName", "an").toString();
263
        password = settings.value("password", "393939").toString();
264
        tableName = settings.value("tableName", "inventar").toString();
265
        hostName = settings.value("hostName", "server").toString();
266
//     resize(size);
267
//     move(pos);tableName
268
}
269
 
270
void MainWindowImpl::getSetting()
271
{
272
        setFrm = new settingForm;
273
        connect(setFrm->pushButton, SIGNAL(clicked()), this, SLOT(applySetting()));
274
        setFrm->lineEdit->setText(baseName);
275
        setFrm->lineEdit_2->setText(userName);
276
        setFrm->lineEdit_3->setText(password);
277
        setFrm->lineEdit_4->setText(tableName);
278
        setFrm->lineEdit_5->setText(hostName);
279
        setFrm->show();
280
 
281
 
282
 
283
}
284
 
285
 
286
void MainWindowImpl::addString()
287
{
288
        QString query_begin=(tr("INSERT INTO "));
289
//      QString query_end=(tr(" VALUES(' ',' ',' ',' ',default)"));
290
        QString query_end=(tr(" VALUES()"));
291
        query_begin.append(tableName);
292
        query_begin.append(query_end);
293
        QSqlQuery query;
294
        query.prepare(query_begin);
295
//      query.prepare(tr("INSERT INTO inventar VALUES(' ',' ',' ',' ',default)"));
296
//      query.bindValue(":tab", "inventar");
297
//       if (!query.execBatch())
298
//              qDebug() << query.lastError();
299
        query.exec();
300
        model->select();
301
//      view->close();
302
        view.setModel(model);
303
        //view->show();
304
        lineEdit->insert(tr(" !"));
305
}
306
 
307
//   
308
void MainWindowImpl::filter()
309
{
310
//      int i;
311
//      i++;
312
        model->setFilter(tr("=''"));
313
        model->select();
314
//      view->close();
315
        view.setModel(model);
316
}
317
//TEST CVS gh
318
void MainWindowImpl::hiddenRow()
319
{
320
        int n;
321
        for(n=0;n<20;n++) view.setRowHidden(n,true);
322
}
323
 
324
 
325
void MainWindowImpl::showRow()
326
{
327
        int n;
328
        for(n=0;n<20;n++) view.setRowHidden(n,false);
329
}
330
 
331
void MainWindowImpl::dbUpdate()
332
{
333
        model->submitAll();
334
        addString();
335
}
336
 
337
 
338
void  MainWindowImpl::novaya_MB_na_sklad(){
339
        addmemFrm.tabWidget->setCurrentIndex(3);
340
        addmemFrm.pushButton->setEnabled(true);
341
        addmemFrm.show();
342
        addmemFrm.label_7->setText(tr(" "));
343
        addNewMemory(tr(" "));
344
 
345
 
346
}
347
 
348
void  MainWindowImpl::novaya_HDD_na_sklad(){
349
        addmemFrm.tabWidget->setCurrentIndex(1);
350
        addmemFrm.pushButton->setEnabled(true);
351
        addmemFrm.show();
352
        addmemFrm.label_7->setText(tr(" "));
353
        addNewMemory(tr(" "));
354
 
355
 
356
}
357
 
358
 
359
void  MainWindowImpl::novaya_CD_DVD_na_sklad(){
360
        addmemFrm.tabWidget->setCurrentIndex(4);
361
        addmemFrm.pushButton->setEnabled(true);
362
        addmemFrm.show();
363
        addmemFrm.label_7->setText(tr(" "));
364
        addNewMemory(tr(" "));
365
 
366
 
367
}
368
 
369
void  MainWindowImpl::novaya_VIDEO_na_sklad(){
370
        addmemFrm.tabWidget->setCurrentIndex(5);
371
        addmemFrm.pushButton->setEnabled(true);
372
        addmemFrm.show();
373
        addmemFrm.label_7->setText(tr(" "));
374
        addNewMemory(tr(" "));
375
 
376
 
377
}
378
 
379
 
380
void  MainWindowImpl::novaya_RAM_na_sklad(){
381
        addmemFrm.tabWidget->setCurrentIndex(0);
382
        addmemFrm.pushButton->setEnabled(true);
383
        addmemFrm.show();
384
        addmemFrm.label_7->setText(tr(" "));
385
        addNewMemory(tr(" "));
386
 
387
 
388
}
389
 
390
 
391
void  MainWindowImpl::novaya_SoundCard_na_sklad(){
392
        addmemFrm.tabWidget->setCurrentIndex(6);
393
        addmemFrm.pushButton->setEnabled(true);
394
        addmemFrm.show();
395
        addmemFrm.label_7->setText(tr(" "));
396
        addNewMemory(tr(" "));
397
 
398
 
399
}
400
 
401
void  MainWindowImpl::novaya_LAN_na_sklad(){
402
        addmemFrm.tabWidget->setCurrentIndex(7);
403
        addmemFrm.pushButton->setEnabled(true);
404
        addmemFrm.show();
405
        addmemFrm.label_7->setText(tr(" "));
406
        addNewMemory(tr(" "));
407
}
408
 
409
 
410
 
411
 
412
void  MainWindowImpl::novaya_CPU_na_sklad(){
413
        addmemFrm.tabWidget->setCurrentIndex(2);
414
        addmemFrm.pushButton->setEnabled(true);
415
        addmemFrm.show();
416
        addmemFrm.label_7->setText(tr(" "));
417
        addNewMemory(tr(" "));
418
 
419
 
420
}
421
 
422
void  MainWindowImpl::peredat_sys_block_pod_otveystvennost(){
423
 
424
        QMessageBox::information( //     .
425
                                                                                this,                      //  .
426
                                                                                QObject::tr("  "),   // .  
427
//                                                                              db.lastError().text());          //  .
428
                                                                                tr("   (  ),      ."));
429
        fEnable_naznachit_otvetstv = true;
430
        curr_sys_block_id = treeWidget-> currentItem ()->text(12);
431
}
432
 
433
 
434
 
435
void MainWindowImpl::on_treeWidget_itemClicked(QTreeWidgetItem *item, int column)
436
{
437
        QString tmp;
438
        tmp = item->text(3);
439
        if (tmp !=""){
440
                addmemFrm.pushButton->setEnabled(true);
441
                }
442
        else addmemFrm.pushButton->setEnabled(false);
443
        addmemFrm.label_7->setText(tmp);
444
}
445
 
446
 
447
 
448
void MainWindowImpl::editTreeWidget()
449
{
450
        QString inventar_num;
451
        QTreeWidgetItem * currItem;
452
        int currColomn;
453
        int top_item_index;
454
        lineEdit->insert(tr(""));
455
        currItem = treeWidget->currentItem ();
456
        top_item_index = treeWidget->indexOfTopLevelItem(currItem);
457
        currColomn = treeWidget->currentColumn();
458
        MainWindowImpl::on_treeWidget_itemClicked(currItem, 3); //    
459
//      inventar_num = tr(".: ");
460
        inventar_num.append(currItem ->text(3));
461
        if (currColomn == 1){
462
                addmemFrm.tabWidget->setCurrentIndex(4);
463
                addmemFrm.show();
464
        };
465
        if (inventar_num == "") return;
466
        lineEdit->insert(currItem ->text(currColomn));
467
        switch(currColomn)
468
        {
469
                case 1://
470
                {
471
                addmemFrm.tabWidget->setCurrentIndex(4);
472
                addmemFrm.show();
473
 
474
                }
475
                break;
476
 
477
 
478
                case 4: //
479
                {
480
                addmemFrm.tabWidget->setCurrentIndex(2);
481
                addmemFrm.show();
482
                }  
483
                break;
484
 
485
                case 5: // 
486
                {
487
                addmemFrm.tabWidget->setCurrentIndex(3);
488
                addmemFrm.show();
489
                }  
490
                break;
491
 
492
                case 6: //
493
                {
494
                addmemFrm.tabWidget->setCurrentIndex(0);
495
                addNewMemory(inventar_num);
496
//              addmemFrm.show();
497
                }  
498
                break;
499
 
500
                case 7: //
501
                {
502
                addmemFrm.tabWidget->setCurrentIndex(1);
503
                addmemFrm.show();      
504
                }
505
                break;
506
 
507
 
508
                case 2: break;
509
                defaul: break;
510
        }
511
        addmemFrm.treeWidget->clear();
512
//      addmemFrm.initTreeWidgrt();
513
}
514
 
515
void MainWindowImpl::initTreeWidget()// 
516
{
517
        QStringList treeHeaders;//  treeWidget
518
        treeWidget->setColumnCount(15);
519
        treeHeaders << tr("")                                     //0  
520
                                << tr("")                               //1  
521
                                << tr("")                       //2  
522
                                << tr("")                   //3  
523
                                << tr("")                                      //4  
524
                                << tr("")                                      //5  
525
                                << tr("")                                         //6  
526
                                << tr("")                                      //7  
527
                                << tr("")                                         //8  
528
                                << tr("")                                     //9  
529
                                << tr(" ")                         //10 
530
                                << tr(" ")                          //11 
531
                                << tr("")                          //12 
532
                                << tr("  ")  //13 
533
                                << tr("ID  "); //14 
534
        treeWidget->setHeaderLabels(QStringList (treeHeaders));
535
//      treeWidget->setColumnHidden(2, true);
536
//      treeWidget->setColumnHidden(12, true);
537
//      treeWidget->setColumnHidden(13, true);
538
        treeWidget->clear();
539
        addOtdels();
540
        treeWidget->sortItems(0, Qt::AscendingOrder);
541
}
542
 
543
void MainWindowImpl::addOtdels()
544
{
545
        int fieldName, fieldID;
546
        QTreeWidgetItem *otdelItem;
547
        QSqlQuery q(tr("select * from otdeli"));//   
548
        QString otdel, otdel_id;
549
        fieldName = q.record().indexOf(tr(""));
550
        fieldID = q.record().indexOf(tr(""));
551
        while (q.next()){
552
                otdel = q.value(fieldName).toString();
553
                otdel_id = q.value(fieldID).toString();
554
                otdelItem = new QTreeWidgetItem(treeWidget);
555
                if (otdel == tr("")) { otdelItem->setText(0, otdel);
556
                        otdelItem->setText(2, tr(""));
557
                        otdelItem->setText(12, otdel_id);
558
                        SotrydnikiOtdela(otdel_id, otdelItem);
559
                        continue;
560
                         }
561
                otdelItem->setText(0, otdel);
562
                otdelItem->setText(2, tr(""));
563
                otdelItem->setText(12, otdel_id);
564
                SotrydnikiOtdela(otdel_id, otdelItem);
565
        }
566
}
567
 
568
 
569
void MainWindowImpl::SotrydnikiOtdela(QString id_otdela, QTreeWidgetItem * itemOtdela) //    
570
{
571
        int field_fio_sotrydnika, field_id_sotrydnika;
572
        int kolichestvo_sotrudnikov=0;
573
        QString fio_sotrydnika_otdela, id_sotrydnika_otdela, oboryd;
574
        QSqlQuery qsotrydnikiOtdela;
575
        QString sqlQueryString;
576
        QTreeWidgetItem *treeItem_sotrydnika;
577
        sqlQueryString = tr("select ,  from sotrydniki where _=");
578
        sqlQueryString.append(id_otdela);
579
        qsotrydnikiOtdela.prepare(sqlQueryString);
580
        qsotrydnikiOtdela.exec();
581
        field_fio_sotrydnika = qsotrydnikiOtdela.record().indexOf(tr(""));
582
        field_id_sotrydnika = qsotrydnikiOtdela.record().indexOf(tr(""));
583
        while (qsotrydnikiOtdela.next())
584
        {
585
                fio_sotrydnika_otdela = qsotrydnikiOtdela.value(field_fio_sotrydnika).toString();
586
                id_sotrydnika_otdela = qsotrydnikiOtdela.value(field_id_sotrydnika).toString();
587
 
588
 
589
                treeItem_sotrydnika = new QTreeWidgetItem(itemOtdela);
590
                treeItem_sotrydnika->setText(1, fio_sotrydnika_otdela );
591
                treeItem_sotrydnika->setText(2, tr(""));
592
                treeItem_sotrydnika->setText(14, id_sotrydnika_otdela );
593
                if (id_sotrydnika_otdela == "1"){
594
                        itm_sklad_system_blocks = new QTreeWidgetItem(treeItem_sotrydnika);
595
                        itm_sklad_system_blocks->setText(2, tr(" "));
596
                        itm_sklad_orgtehnika = new QTreeWidgetItem(treeItem_sotrydnika);
597
                        itm_sklad_orgtehnika->setText(2, tr(""));
598
                        itm_sklad_orgtehnika_printers =  new QTreeWidgetItem(itm_sklad_orgtehnika);
599
                        itm_sklad_orgtehnika_printers->setText(2, tr(""));
600
                        itm_sklad_orgtehnika_mfy =   new QTreeWidgetItem(itm_sklad_orgtehnika);
601
                        itm_sklad_orgtehnika_mfy->setText(2, tr(""));
602
                        itm_sklad_komplectyushie = new QTreeWidgetItem(treeItem_sotrydnika);
603
                        itm_sklad_komplectyushie->setText(2, tr(""));
604
                        itm_sklad_orgtehnika_scaners = new QTreeWidgetItem(itm_sklad_orgtehnika);
605
                        itm_sklad_orgtehnika_scaners->setText(2, tr(""));
606
                        itm_sklad_rashodniki = new QTreeWidgetItem(treeItem_sotrydnika);
607
                        itm_sklad_rashodniki->setText(2, tr(" "));
608
                }
609
                oboryd = oborydovanie(id_sotrydnika_otdela, treeItem_sotrydnika);
610
//              treeItem_sotrydnika->setText(3, oboryd );
611
                ++kolichestvo_sotrudnikov;
612
        }
613
        itemOtdela->setText(13, QVariant(kolichestvo_sotrudnikov).toString());
614
}
615
 
616
QString MainWindowImpl::oborydovanie(QString id_sotrydnika, QTreeWidgetItem * itemSotrydnika){
617
        QString result, prResult;
618
        QString sqlQueryText;
619
        QString serial_num, inventar_num, proizvoditel, model, system_block_id;
620
        QSqlQuery quer;
621
        QString MB_information, Memory_information, CPU_information, HDD_information, CD_DVD_information, Vidio_information;
622
        QString Sound_card_information, Lan_card_information;
623
        int field_serialNum, field_inventarNum, field_proizvoditel, field_model, field_system_block_id;
624
//      QSqlQuery qns(tr("SET NAMES utf8"));//   
625
        QTreeWidgetItem *itemSysBlock;
626
//      sqlQueryText.reserve(300);
627
        sqlQueryText = tr("select system_blocks._, system_blocks._, system_blocks."
628
        " from system_blocks"
629
        " where system_blocks.__ =");
630
        sqlQueryText.append(id_sotrydnika);
631
//      sqlQueryText.append(tr(" AND _.__ = _."));
632
        quer.prepare(sqlQueryText);
633
//      quer.prepare(tr("select _._, _._,_., _. from _,_ where _.__ = 4 AND _.__ = _.;"));
634
        quer.exec();
635
        field_serialNum = quer.record().indexOf(tr("_"));
636
        field_inventarNum = quer.record().indexOf(tr("_"));
637
        field_system_block_id = quer.record().indexOf(tr(""));
638
//      field_proizvoditel = quer.record().indexOf(tr(""));
639
//      field_model = quer.record().indexOf(tr(""));
640
        while(quer.next()){
641
        system_block_id = quer.value(field_system_block_id).toString();                                 //  
642
        prResult = ""; 
643
        serial_num = quer.value(field_serialNum).toString();
644
        inventar_num = quer.value(field_inventarNum).toString();
645
////    if (serial_num != "") {prResult.append(tr("s/n: "));
646
////            prResult.append(serial_num);}
647
        if (inventar_num != "") {
648
////    prResult.append(tr(" .: "));
649
        prResult.append(inventar_num);
650
////    prResult.append(tr(" "));
651
}
652
 
653
//      result.append(q.value(field_proizvoditel).toString());
654
//      result.append(tr(" "));
655
//      result.append(q.value(field_model).toString());
656
 
657
 
658
 
659
 
660
 
661
//      if (id_sotrydnika == "1" & system_block_id == "1") itemSysBlock->setText(2, tr(""));//   
662
        if (id_sotrydnika == "1" && system_block_id == "1") itemSysBlock = itm_sklad_komplectyushie;//   
663
        else if (id_sotrydnika == "1" ){
664
                itemSysBlock = new QTreeWidgetItem(itm_sklad_system_blocks); //   
665
                itemSysBlock->setText(2, tr(" "));
666
                itemSysBlock->setIcon(3, comp_icon);
667
                if (system_block_id !="") itemSysBlock->setText(12, system_block_id);  
668
                if (id_sotrydnika !="") itemSysBlock->setText(14, id_sotrydnika);
669
        }
670
 
671
        else {
672
                itemSysBlock = new QTreeWidgetItem(itemSotrydnika);
673
                itemSysBlock->setText(2, tr(" "));
674
                itemSysBlock->setIcon(3, comp_icon);
675
                if (system_block_id !="") itemSysBlock->setText(12, system_block_id);  
676
                if (id_sotrydnika !="") itemSysBlock->setText(14, id_sotrydnika);
677
 
678
                }
679
 
680
        MB_information = addMatheBoardInformation (id_sotrydnika, system_block_id, itemSysBlock);               //    
681
////    prResult.append(MB_information);
682
        Memory_information = addMemoryInformation(id_sotrydnika, system_block_id, itemSysBlock);                //   
683
////    prResult.append(Memory_information);
684
        CPU_information = addCpuInformation(id_sotrydnika, system_block_id, itemSysBlock);
685
////    prResult.append(CPU_information);
686
        HDD_information = addHDDInformation(id_sotrydnika, system_block_id, itemSysBlock);
687
////    prResult.append(HDD_information);
688
        CD_DVD_information = add_CD_DVD_Information(id_sotrydnika, system_block_id, itemSysBlock);
689
////    prResult.append(CD_DVD_information);
690
        Vidio_information = add_Vidio_Information(id_sotrydnika, system_block_id, itemSysBlock);
691
        Sound_card_information = add_Sound_Card_Information(id_sotrydnika, system_block_id, itemSysBlock);
692
        Lan_card_information = add_Lan_Card_Information(id_sotrydnika, system_block_id, itemSysBlock);
693
        if (system_block_id != "1"){
694
 
695
                itemSysBlock->setText(3, prResult);      
696
                result.append(prResult);
697
}
698
 
699
 
700
        }
701
        return result;
702
}
703
 
704
QString MainWindowImpl::addMatheBoardInformation(QString id_otvetstvennogo_lica, QString id_systemBlock, QTreeWidgetItem * itemSysBlock)
705
{
706
        QString result, tmp;
707
        QString MB_proizvoditel, MB_model, MB_identifikator, MB_serial_num, MB_inventar_num;
708
        QString MatheBoardSqlQueryText;
709
        QSqlQuery MatheBoardQuery;
710
        int field_proizvoditel, field_model, field_identifikator, field_serial_num, field_inventar_num;
711
        QTreeWidgetItem *itemMB, *itmMB_block;
712
        MatheBoardSqlQueryText = tr("select * "
713
        " from matheboards where matheboards.__ = "
714
        );
715
        MatheBoardSqlQueryText.append(id_systemBlock);
716
        MatheBoardQuery.prepare(MatheBoardSqlQueryText);
717
        MatheBoardQuery.exec();
718
        field_identifikator = MatheBoardQuery.record().indexOf(tr(""));
719
        field_proizvoditel = MatheBoardQuery.record().indexOf(tr(""));
720
        field_model = MatheBoardQuery.record().indexOf(tr(""));
721
        field_serial_num = MatheBoardQuery.record().indexOf(tr("_"));
722
        field_inventar_num = MatheBoardQuery.record().indexOf(tr("_"));
723
 
724
        if (id_otvetstvennogo_lica == "1" && id_systemBlock == "1"){
725
                itmMB_block = new QTreeWidgetItem(itm_sklad_komplectyushie);
726
                itmMB_block->setText(2, tr(" "));
727
//              itmMB_block->setIcon(3, matheboard_icon);
728
                }
729
 
730
        while(MatheBoardQuery.next()){
731
                tmp = "";
732
                MB_identifikator = MatheBoardQuery.value(field_identifikator).toString();
733
                MB_proizvoditel = MatheBoardQuery.value(field_proizvoditel).toString();
734
                MB_model = MatheBoardQuery.value(field_model).toString();
735
                MB_serial_num = MatheBoardQuery.value(field_serial_num).toString();
736
                MB_inventar_num = MatheBoardQuery.value(field_inventar_num).toString();
737
 
738
        if (MB_proizvoditel != "") {
739
//              tmp.append(tr("MB: "));
740
                tmp.append(MB_proizvoditel);
741
                }
742
        if (MB_model != "") {tmp.append(tr(" "));
743
        tmp.append(MB_model);
744
        tmp.append(tr(" "));}
745
        result.append(tmp);
746
        if (id_otvetstvennogo_lica == "1" && id_systemBlock == "1") {itemMB = new QTreeWidgetItem(itmMB_block);
747
        }
748
        else itemMB = new QTreeWidgetItem(itemSysBlock);
749
        itemMB->setIcon(4, matheboard_icon);
750
        itemMB->setText(4, tmp);
751
        itemMB->setText(12, MB_identifikator);
752
        itemMB->setText(13, id_systemBlock);
753
        itemMB->setText(14, id_otvetstvennogo_lica);
754
        itemMB->setText(2, tr(" "));
755
        itemMB->setText(3, MB_inventar_num);
756
        if (id_systemBlock !="1") itemSysBlock->setText(5, tmp);
757
 
758
                }
759
        return result;
760
}
761
 
762
 
763
QString MainWindowImpl::addMemoryInformation(QString id_otvetstvennogo_lica, QString id_systemBlock, QTreeWidgetItem * itemSysBlock)
764
{
765
        QString result, tmp;
766
        QString Memiry_id, Memory_proizvoditel, Memory_type, Memory_obem, Memory_inventar_num, Memory_serial_num;
767
        QString MemorySqlQueryText;
768
        QSqlQuery MemoryQuery;
769
        int field_proizvoditel, field_type, field_obem, field_id, field_inventar_num, field_sereal_num;
770
        QTreeWidgetItem *itemMemory, *itemMemory_block;
771
        MemorySqlQueryText = tr("select memory.* "
772
        " from memory where memory.__ = "
773
        );
774
        MemorySqlQueryText.append(id_systemBlock);
775
        MemoryQuery.prepare(MemorySqlQueryText);
776
        MemoryQuery.exec();
777
        field_id = MemoryQuery.record().indexOf(tr(""));
778
        field_proizvoditel = MemoryQuery.record().indexOf(tr(""));
779
        field_type = MemoryQuery.record().indexOf(tr(""));
780
        field_obem = MemoryQuery.record().indexOf(tr(""));
781
        field_inventar_num = MemoryQuery.record().indexOf(tr("_"));
782
        field_sereal_num = MemoryQuery.record().indexOf(tr("_"));
783
                if (id_otvetstvennogo_lica == "1" && id_systemBlock == "1"){
784
                itemMemory_block = new QTreeWidgetItem(itm_sklad_komplectyushie);
785
                itemMemory_block->setText(2, tr(" "));
786
        }
787
        while(MemoryQuery.next()){
788
//              tmp = tr("RAM: ");
789
                tmp = tr("");
790
                Memiry_id = MemoryQuery.value(field_id).toString();
791
                Memory_proizvoditel = MemoryQuery.value(field_proizvoditel).toString();
792
                Memory_type = MemoryQuery.value(field_type).toString();
793
                Memory_obem = MemoryQuery.value(field_obem).toString();
794
                Memory_inventar_num = MemoryQuery.value(field_inventar_num).toString();
795
                Memory_serial_num = MemoryQuery.value(field_sereal_num).toString();
796
////    if (Memory_proizvoditel != "") {
797
////            tmp.append(Memory_proizvoditel);}
798
        if (Memory_type != "") {tmp.append(tr(" "));
799
        tmp.append(Memory_type);
800
        tmp.append(tr(" "));}
801
        if (Memory_obem != "") {tmp.append(tr(" "));
802
        tmp.append(Memory_obem);
803
        tmp.append(tr("MB; "));}
804
        result.append(tmp);
805
        if (id_otvetstvennogo_lica == "1" && id_systemBlock == "1"){
806
                itemMemory = new QTreeWidgetItem(itemMemory_block);
807
        }
808
        else itemMemory = new QTreeWidgetItem(itemSysBlock);
809
        itemMemory->setIcon(4, memory_icon);
810
        itemMemory->setText(4, tmp);
811
 
812
        itemMemory->setText(2, tr(" "));
813
        itemMemory->setText(12, Memiry_id);
814
        itemMemory->setText(13, id_systemBlock);
815
        itemMemory->setText(14, id_otvetstvennogo_lica);
816
        itemMemory->setText(3, Memory_inventar_num);
817
 
818
                }
819
        if (id_systemBlock !="1") itemSysBlock->setText(6, result);
820
        return result;
821
}
822
 
823
 
824
QString MainWindowImpl::addCpuInformation(QString id_otvetstvennogo_lica, QString id_systemBlock, QTreeWidgetItem * itemSysBlock)
825
{
826
        QString result, tmp;
827
        QString CPU_id, CPU_proizvoditel, CPU_slot, CPU_fqr, CPU_inventar_num, CPU_serial_num;
828
        QString CpuSqlQueryText;
829
        QSqlQuery CpuQuery;
830
        int field_id, field_proizvoditel, field_slot, field_fqr, field_inventar_num, field_serial_num;
831
        QTreeWidgetItem *itemCpu, *itemCpu_block;
832
        CpuSqlQueryText = tr("select processors.* "
833
        " from processors where processors.__ = "
834
        );
835
        CpuSqlQueryText.append(id_systemBlock);
836
        CpuQuery.prepare(CpuSqlQueryText);
837
        CpuQuery.exec();
838
        field_id = CpuQuery.record().indexOf(tr(""));
839
        field_proizvoditel = CpuQuery.record().indexOf(tr(""));
840
        field_slot = CpuQuery.record().indexOf(tr(""));
841
        field_fqr = CpuQuery.record().indexOf(tr(""));
842
        field_inventar_num = CpuQuery.record().indexOf(tr("_"));
843
        field_serial_num = CpuQuery.record().indexOf(tr("_"));
844
 
845
        if (id_otvetstvennogo_lica == "1" && id_systemBlock == "1"){
846
                itemCpu_block = new QTreeWidgetItem(itemSysBlock);
847
                itemCpu_block->setText(2, tr(""));
848
                itemCpu_block->setText(14, id_otvetstvennogo_lica);
849
        }
850
 
851
 
852
        while(CpuQuery.next()){
853
//              tmp = tr("CPU: ");
854
        tmp = tr("");
855
                CPU_id = CpuQuery.value(field_id).toString();
856
                CPU_proizvoditel = CpuQuery.value(field_proizvoditel).toString();
857
                CPU_slot = CpuQuery.value(field_slot).toString();
858
                CPU_fqr = CpuQuery.value(field_fqr).toString();
859
                CPU_inventar_num =  CpuQuery.value(field_inventar_num).toString();
860
                CPU_serial_num = CpuQuery.value(field_serial_num).toString();
861
 
862
        if (CPU_proizvoditel != "") {
863
                tmp.append(CPU_proizvoditel);}
864
//      if (CPU_slot != "") {tmp.append(tr(" "));
865
//      tmp.append(CPU_slot);
866
//      tmp.append(tr(" "));}
867
        if (CPU_fqr != "") {tmp.append(tr(" "));
868
        tmp.append(CPU_fqr);
869
        tmp.append(tr("MGz "));}
870
        result.append(tmp);
871
        if (id_otvetstvennogo_lica == "1" && id_systemBlock == "1"){
872
                itemCpu = new QTreeWidgetItem(itemCpu_block);
873
        }
874
        else itemCpu = new QTreeWidgetItem(itemSysBlock);
875
 
876
 
877
//      itemCpu = new QTreeWidgetItem(itemSysBlock);
878
        itemCpu->setText(2, tr(""));
879
        itemCpu->setText(12, CPU_id);
880
        itemCpu->setText(13, id_systemBlock);
881
        itemCpu->setText(14, id_otvetstvennogo_lica);
882
 
883
        itemCpu->setIcon(4, cpu_icon);
884
        itemCpu->setText(4, tmp);
885
 
886
        itemCpu->setText(3, CPU_inventar_num);
887
                }
888
        if (id_systemBlock !="1") itemSysBlock->setText(4, tmp);
889
        return result;
890
}
891
 
892
QString MainWindowImpl::addHDDInformation(QString id_otvetstvennogo_lica, QString id_systemBlock, QTreeWidgetItem * itemSysBlock)
893
{
894
        QString result, tmp;
895
        QString HDD_id, HDD_proizvoditel, HDD_interfeis, HDD_obem, HDD_inventar_num, HDD_serial_num;
896
        QString HDDSqlQueryText;
897
        QSqlQuery HDDQuery;
898
        int field_id, field_proizvoditel, field_interfeis, field_obem, field_inventar_num, field_serial_num;
899
        QTreeWidgetItem *itemHDD;
900
        QTreeWidgetItem *itemHDD_block;
901
        HDDSqlQueryText = tr("select harddiscs.* "
902
        " from harddiscs where harddiscs.__ = "
903
        );
904
        HDDSqlQueryText.append(id_systemBlock);
905
        HDDQuery.prepare(HDDSqlQueryText);
906
        HDDQuery.exec();
907
        field_id = HDDQuery.record().indexOf(tr(""));
908
        field_proizvoditel = HDDQuery.record().indexOf(tr(""));
909
        field_interfeis = HDDQuery.record().indexOf(tr(""));
910
        field_obem = HDDQuery.record().indexOf(tr(""));
911
        field_inventar_num = HDDQuery.record().indexOf(tr("_"));
912
        field_serial_num = HDDQuery.record().indexOf(tr("_"));
913
 
914
        if (id_otvetstvennogo_lica == "1" && id_systemBlock == "1"){
915
                itemHDD_block = new QTreeWidgetItem(itemSysBlock);
916
                itemHDD_block->setText(2, tr(""));
917
                itemHDD_block->setText(14, id_otvetstvennogo_lica);
918
        }
919
 
920
 
921
        while(HDDQuery.next()){
922
//              tmp = tr("HDD: ");
923
                tmp = tr("");
924
                HDD_id = HDDQuery.value(field_id).toString();
925
                HDD_proizvoditel = HDDQuery.value(field_proizvoditel).toString();
926
                HDD_interfeis = HDDQuery.value(field_interfeis).toString();
927
                HDD_obem = HDDQuery.value(field_obem).toString();
928
                HDD_inventar_num =  HDDQuery.value(field_inventar_num).toString();
929
                HDD_serial_num = HDDQuery.value(field_serial_num).toString();
930
        if (HDD_proizvoditel != "") {
931
                tmp.append(HDD_proizvoditel);}
932
        if (HDD_interfeis != "") {tmp.append(tr(" "));
933
        tmp.append(HDD_interfeis);
934
        tmp.append(tr(" "));}
935
        if (HDD_obem != "") {tmp.append(tr(" "));
936
        tmp.append(HDD_obem);
937
        tmp.append(tr("GB; "));}
938
        result.append(tmp);
939
 
940
        if (id_otvetstvennogo_lica == "1" && id_systemBlock == "1"){
941
                itemHDD  = new QTreeWidgetItem(itemHDD_block);
942
        }
943
        else itemHDD  = new QTreeWidgetItem(itemSysBlock);
944
 
945
 
946
//      itemHDD = new QTreeWidgetItem(itemSysBlock);
947
 
948
        itemHDD->setText(2, tr(" "));
949
        itemHDD->setText(12, HDD_id);
950
        itemHDD->setText(13, id_systemBlock);
951
        itemHDD->setText(14, id_otvetstvennogo_lica);
952
 
953
        itemHDD->setIcon(4, hdd_icon);
954
        itemHDD->setText(4, tmp);
955
        itemHDD->setText(3, HDD_inventar_num);
956
                }
957
//      if (result!="") itemSysBlock->setIcon(7, hdd_icon);
958
        if (id_systemBlock !="1") itemSysBlock->setText(7, result);
959
        return result;
960
}
961
 
962
QString MainWindowImpl::add_CD_DVD_Information(QString id_otvetstvennogo_lica, QString id_systemBlock, QTreeWidgetItem * itemSysBlock)
963
{
964
        QString result, tmp;
965
        QString CD_DVD_id, CD_DVD_proizvoditel, CD_DVD_type, CD_DVD_speed, CD_DVD_serial_num, CD_DVD_inventar_num;
966
        QString CD_DVD_SqlQueryText;
967
        QSqlQuery CD_DVD_Query;
968
        int field_id, field_proizvoditel, field_type, field_speed, field_serial_num, field_inventar_num;
969
        QTreeWidgetItem *item_CD_DVD;
970
        QTreeWidgetItem *item_CD_DVD_block;
971
        CD_DVD_SqlQueryText = tr("select cd_dvd.* "
972
        " from cd_dvd where cd_dvd.__ = "
973
        );
974
        CD_DVD_SqlQueryText.append(id_systemBlock);
975
        CD_DVD_Query.prepare(CD_DVD_SqlQueryText);
976
        CD_DVD_Query.exec();
977
        field_id = CD_DVD_Query.record().indexOf(tr(""));
978
        field_proizvoditel = CD_DVD_Query.record().indexOf(tr(""));
979
        field_type = CD_DVD_Query.record().indexOf(tr(""));
980
        field_speed = CD_DVD_Query.record().indexOf(tr(""));
981
        field_inventar_num = CD_DVD_Query.record().indexOf(tr("_"));
982
        field_serial_num = CD_DVD_Query.record().indexOf(tr("_"));
983
 
984
        if (id_otvetstvennogo_lica == "1" && id_systemBlock == "1"){
985
                item_CD_DVD_block = new QTreeWidgetItem(itemSysBlock);
986
                item_CD_DVD_block->setText(2, tr(""));
987
                item_CD_DVD_block->setText(14, id_otvetstvennogo_lica);
988
        }
989
 
990
 
991
        while(CD_DVD_Query.next()){
992
//              tmp = tr("CD/DVD: ");
993
        tmp = tr("");
994
                CD_DVD_id = CD_DVD_Query.value(field_id).toString();
995
                CD_DVD_proizvoditel = CD_DVD_Query.value(field_proizvoditel).toString();
996
                CD_DVD_type = CD_DVD_Query.value(field_type).toString();
997
                CD_DVD_speed = CD_DVD_Query.value(field_speed).toString();
998
                CD_DVD_serial_num = CD_DVD_Query.value(field_serial_num).toString();
999
                CD_DVD_inventar_num = CD_DVD_Query.value(field_inventar_num).toString();
1000
 
1001
        if (CD_DVD_type != "") {
1002
                tmp.append(CD_DVD_type);}
1003
        if (CD_DVD_proizvoditel != "") {tmp.append(tr(" "));
1004
        tmp.append(CD_DVD_proizvoditel);
1005
        tmp.append(tr(" "));}
1006
        if (CD_DVD_speed != "") {tmp.append(tr(" "));
1007
        tmp.append(CD_DVD_speed);
1008
        tmp.append(tr(" "));}
1009
        result.append(tmp);
1010
 
1011
if (id_otvetstvennogo_lica == "1" && id_systemBlock == "1"){
1012
                item_CD_DVD  = new QTreeWidgetItem(item_CD_DVD_block);
1013
        }
1014
        else item_CD_DVD = new QTreeWidgetItem(itemSysBlock);
1015
 
1016
        item_CD_DVD->setText(2, tr(""));
1017
        item_CD_DVD->setText(12, CD_DVD_id);
1018
        item_CD_DVD->setText(13, id_systemBlock);
1019
        item_CD_DVD->setText(14, id_otvetstvennogo_lica);
1020
        item_CD_DVD->setIcon(4, cd_dvd_icon);
1021
        item_CD_DVD->setText(4, tmp);
1022
        item_CD_DVD->setText(3, CD_DVD_inventar_num);
1023
                }
1024
        if (id_systemBlock !="1") itemSysBlock->setText(8, result);
1025
        return result;
1026
}
1027
 
1028
QString MainWindowImpl::add_Vidio_Information(QString id_otvetstvennogo_lica, QString id_systemBlock, QTreeWidgetItem * itemSysBlock){
1029
 
1030
        QString result, tmp;
1031
        QString Vidio_id, Vidio_proizvoditel, Vidio_model, Vidio_interfeis, Vidio_ram, Vidio_inventar_num, Vidio_sereal_num;
1032
        QString Vidio_SqlQueryText;
1033
        QSqlQuery Vidio_Query;
1034
        int field_id, field_proizvoditel, field_model, field_interfeis, field_ram, field_inventar_num, field_sereal_num;
1035
        QTreeWidgetItem *item_Vidio, *item_Vidio_block;
1036
        Vidio_SqlQueryText = tr("select videocards.* "
1037
        " from videocards where videocards.__ = "
1038
        );
1039
        Vidio_SqlQueryText.append(id_systemBlock);
1040
        Vidio_Query.prepare(Vidio_SqlQueryText);
1041
        Vidio_Query.exec();
1042
        field_id = Vidio_Query.record().indexOf(tr(""));
1043
        field_proizvoditel = Vidio_Query.record().indexOf(tr(""));
1044
        field_model = Vidio_Query.record().indexOf(tr(""));
1045
        field_interfeis  = Vidio_Query.record().indexOf(tr(""));
1046
        field_ram = Vidio_Query.record().indexOf(tr(""));
1047
        field_inventar_num = Vidio_Query.record().indexOf(tr("_"));
1048
        field_sereal_num = Vidio_Query.record().indexOf(tr("_"));
1049
 
1050
        if (id_otvetstvennogo_lica == "1" && id_systemBlock == "1"){
1051
                item_Vidio_block = new QTreeWidgetItem(itemSysBlock);
1052
                item_Vidio_block->setText(2, tr(""));
1053
                item_Vidio_block->setText(14, id_otvetstvennogo_lica);
1054
        }
1055
 
1056
 
1057
 
1058
        while(Vidio_Query.next()){
1059
//              tmp = tr("CD/DVD: ");
1060
        tmp = tr("");
1061
                Vidio_id = Vidio_Query.value(field_id).toString();
1062
                Vidio_proizvoditel = Vidio_Query.value(field_proizvoditel).toString();
1063
                Vidio_model = Vidio_Query.value(field_model).toString();
1064
                Vidio_interfeis = Vidio_Query.value(field_interfeis).toString();
1065
                Vidio_ram = Vidio_Query.value(field_ram).toString();
1066
                Vidio_inventar_num = Vidio_Query.value(field_inventar_num).toString();
1067
                Vidio_sereal_num =  Vidio_Query.value(field_sereal_num).toString();
1068
        if (Vidio_interfeis != "") {tmp.append(tr(" "));
1069
        tmp.append(Vidio_interfeis);}
1070
        if (Vidio_proizvoditel != "") {tmp.append(tr(" "));
1071
        tmp.append(Vidio_proizvoditel);}
1072
        if (Vidio_model != "") {tmp.append(tr(" "));
1073
                tmp.append(Vidio_model);}
1074
 
1075
        if (Vidio_ram !=""){tmp.append(tr(" "));
1076
        tmp.append(Vidio_ram);
1077
        tmp.append(tr(" Mb"));
1078
 
1079
        }
1080
        result.append(tmp);
1081
 
1082
        if (id_otvetstvennogo_lica == "1" && id_systemBlock == "1"){
1083
                item_Vidio  = new QTreeWidgetItem(item_Vidio_block);
1084
        }
1085
        else item_Vidio = new QTreeWidgetItem(itemSysBlock);
1086
 
1087
 
1088
//      item_Vidio = new QTreeWidgetItem(itemSysBlock);
1089
 
1090
        item_Vidio->setText(2, tr(""));
1091
        item_Vidio->setText(12, Vidio_id);
1092
        item_Vidio->setText(13, id_systemBlock);
1093
        item_Vidio->setText(14, id_otvetstvennogo_lica);
1094
        item_Vidio->setIcon(4, vidio_card_icon);
1095
        item_Vidio->setText(4, tmp);
1096
        item_Vidio->setText(3, Vidio_inventar_num);
1097
                }
1098
        if (id_systemBlock !="1") itemSysBlock->setText(9, result);
1099
        return result;
1100
}
1101
 
1102
 
1103
QString MainWindowImpl::add_Sound_Card_Information(QString id_otvetstvennogo_lica, QString id_systemBlock, QTreeWidgetItem * itemSysBlock){
1104
 
1105
 
1106
        QString result, tmp;
1107
        QString Sound_card_id, Sound_card_proizvoditel, Sound_card_model, Sound_card_inventar_num, Sound_card_serial_num;
1108
        QString Sound_card_SqlQueryText;
1109
        QSqlQuery Sound_card_Query;
1110
        int field_id, field_proizvoditel, field_model, field_inventar_num, field_serial_num;
1111
        QTreeWidgetItem *item_Sound_card, *item_Sound_card_block;
1112
        Sound_card_SqlQueryText = tr("select soundcards.* "
1113
        " from soundcards where soundcards.__ = "
1114
        );
1115
        Sound_card_SqlQueryText.append(id_systemBlock);
1116
        Sound_card_Query.prepare(Sound_card_SqlQueryText);
1117
        Sound_card_Query.exec();
1118
        field_id = Sound_card_Query.record().indexOf(tr(""));
1119
        field_proizvoditel = Sound_card_Query.record().indexOf(tr(""));
1120
        field_model = Sound_card_Query.record().indexOf(tr(""));
1121
        field_inventar_num =  Sound_card_Query.record().indexOf(tr("_"));
1122
        field_serial_num = Sound_card_Query.record().indexOf(tr("_"));
1123
 
1124
 
1125
        if (id_otvetstvennogo_lica == "1" && id_systemBlock == "1"){
1126
                item_Sound_card_block = new QTreeWidgetItem(itemSysBlock);
1127
                item_Sound_card_block->setText(2, tr(" "));
1128
                item_Sound_card_block->setText(14, id_otvetstvennogo_lica);
1129
        }
1130
 
1131
        while(Sound_card_Query.next()){
1132
//              tmp = tr("CD/DVD: ");
1133
        tmp = tr("");
1134
                Sound_card_id = Sound_card_Query.value(field_id).toString();
1135
                Sound_card_proizvoditel = Sound_card_Query.value(field_proizvoditel).toString();
1136
                Sound_card_model = Sound_card_Query.value(field_model).toString();
1137
                Sound_card_inventar_num = Sound_card_Query.value(field_inventar_num).toString();
1138
                Sound_card_serial_num = Sound_card_Query.value(field_serial_num).toString();
1139
 
1140
//              Vidio_interfeis = Vidio_Query.value(field_interfeis).toString();
1141
//              Vidio_ram = Vidio_Query.value(field_ram).toString();
1142
        if (Sound_card_proizvoditel != "") {tmp.append(tr(" "));
1143
        tmp.append(Sound_card_proizvoditel);}
1144
 
1145
        if (Sound_card_model != "") {tmp.append(tr(" "));
1146
                tmp.append(Sound_card_model);}
1147
 
1148
///     if (Vidio_ram !=""){tmp.append(tr(" "));
1149
///     tmp.append(Vidio_ram);
1150
///     tmp.append(tr(" Mb"));
1151
 
1152
///     }
1153
        result.append(tmp);
1154
 
1155
        if (id_otvetstvennogo_lica == "1" && id_systemBlock == "1"){
1156
                item_Sound_card  = new QTreeWidgetItem(item_Sound_card_block);
1157
        }
1158
        else item_Sound_card = new QTreeWidgetItem(itemSysBlock);
1159
 
1160
 
1161
//      item_Sound_card = new QTreeWidgetItem(itemSysBlock);
1162
 
1163
 
1164
        item_Sound_card->setText(2, tr(" "));
1165
        item_Sound_card->setText(12, Sound_card_id);
1166
        item_Sound_card->setText(13, id_systemBlock);
1167
        item_Sound_card->setText(14, id_otvetstvennogo_lica);
1168
        item_Sound_card->setIcon(4, sound_card_icon);
1169
        item_Sound_card->setText(4, tmp);
1170
        item_Sound_card->setText(3, Sound_card_inventar_num);
1171
                }
1172
        if (id_systemBlock !="1") itemSysBlock->setText(10, result);
1173
        return result; 
1174
 
1175
}
1176
 
1177
QString MainWindowImpl::add_Lan_Card_Information(QString id_otvetstvennogo_lica, QString id_systemBlock, QTreeWidgetItem * itemSysBlock){
1178
 
1179
 
1180
        QString result, tmp;
1181
        QString Lan_card_id, Lan_card_proizvoditel, Lan_card_model, Lan_speed, Lan_inventar_num, Lan_serial_num;
1182
        QString Lan_card_SqlQueryText;
1183
        QSqlQuery Lan_card_Query;
1184
        int field_id, field_proizvoditel, field_model, field_speed, field_serial_num, field_inventar_num;
1185
        QTreeWidgetItem *item_Lan_card, *item_Lan_card_block;
1186
        Lan_card_SqlQueryText = tr("select lancards.* "
1187
        " from lancards where lancards.__ = "
1188
        );
1189
        Lan_card_SqlQueryText.append(id_systemBlock);
1190
        Lan_card_Query.prepare(Lan_card_SqlQueryText);
1191
        Lan_card_Query.exec();
1192
        field_id = Lan_card_Query.record().indexOf(tr(""));
1193
        field_proizvoditel = Lan_card_Query.record().indexOf(tr(""));
1194
        field_model = Lan_card_Query.record().indexOf(tr(""));
1195
        field_speed = Lan_card_Query.record().indexOf(tr("__"));
1196
        field_serial_num = Lan_card_Query.record().indexOf(tr("_"));
1197
        field_inventar_num = Lan_card_Query.record().indexOf(tr("_"));
1198
 
1199
        if (id_otvetstvennogo_lica == "1" && id_systemBlock == "1"){
1200
                item_Lan_card_block = new QTreeWidgetItem(itemSysBlock);
1201
                item_Lan_card_block->setText(2, tr(" "));
1202
                item_Lan_card_block->setText(14, id_otvetstvennogo_lica);
1203
        }
1204
 
1205
        while(Lan_card_Query.next()){
1206
//              tmp = tr("CD/DVD: ");
1207
        tmp = tr("");
1208
                Lan_card_id = Lan_card_Query.value(field_id).toString();
1209
                Lan_card_proizvoditel = Lan_card_Query.value(field_proizvoditel).toString();
1210
                Lan_card_model = Lan_card_Query.value(field_model).toString();
1211
                Lan_speed = Lan_card_Query.value(field_speed).toString();
1212
                Lan_inventar_num =  Lan_card_Query.value(field_inventar_num).toString();
1213
                Lan_serial_num = Lan_card_Query.value(field_serial_num).toString();
1214
 
1215
 
1216
//              Vidio_interfeis = Vidio_Query.value(field_interfeis).toString();
1217
//              Vidio_ram = Vidio_Query.value(field_ram).toString();
1218
        if (Lan_card_proizvoditel != "") {tmp.append(tr(" "));
1219
        tmp.append(Lan_card_proizvoditel);}
1220
 
1221
        if (Lan_card_model != "") {tmp.append(tr(" "));
1222
                tmp.append(Lan_card_model);}
1223
 
1224
        if (Lan_speed != "") {tmp.append(tr(" "));
1225
                tmp.append(Lan_speed);
1226
                tmp.append(tr(" Mbit"));}
1227
 
1228
///     if (Vidio_ram !=""){tmp.append(tr(" "));
1229
///     tmp.append(Vidio_ram);
1230
///     tmp.append(tr(" Mb"));
1231
 
1232
///     }
1233
        result.append(tmp);
1234
 
1235
        if (id_otvetstvennogo_lica == "1" && id_systemBlock == "1"){
1236
                item_Lan_card  = new QTreeWidgetItem(item_Lan_card_block);
1237
        }
1238
        else item_Lan_card = new QTreeWidgetItem(itemSysBlock);
1239
 
1240
//      item_Lan_card = new QTreeWidgetItem(itemSysBlock);
1241
 
1242
 
1243
        item_Lan_card->setText(2, tr(" "));
1244
        item_Lan_card->setText(12, Lan_card_id);
1245
        item_Lan_card->setText(13, id_systemBlock);
1246
        item_Lan_card->setText(14, id_otvetstvennogo_lica);
1247
        item_Lan_card->setIcon(4, lan_card_icon);
1248
        item_Lan_card->setText(4, tmp);
1249
        item_Lan_card->setText(3, Lan_inventar_num);
1250
                }
1251
        if (id_systemBlock !="1") itemSysBlock->setText(11, result);
1252
        return result; 
1253
 
1254
}
1255
 
1256
void MainWindowImpl::refreshTree(){
1257
 
1258
        initTreeWidget();
1259
}
1260
 
1261
int MainWindowImpl::select_system_block(){
1262
        return 1;
1263
}
1264
 
1265