Редакция 226 | Содержимое файла | Сравнить с предыдущей | Последнее изменение | Открыть журнал | RSS
Редакция | Автор | № строки | Строка |
---|---|---|---|
123 | pingvin | 1 | |
2 | |||
3 | ** Copyright (C) 2010 Nokia Corporation and/or its subsidiary(-ies). |
||
4 | ** All rights reserved. |
||
5 | ** Contact: Nokia Corporation (qt-info@nokia.com) |
||
6 | ** |
||
7 | ** This file is part of the examples of the Qt Toolkit. |
||
8 | ** |
||
9 | ** $QT_BEGIN_LICENSE:LGPL$ |
||
10 | ** Commercial Usage |
||
11 | ** Licensees holding valid Qt Commercial licenses may use this file in |
||
12 | ** accordance with the Qt Commercial License Agreement provided with the |
||
13 | ** Software or, alternatively, in accordance with the terms contained in |
||
14 | ** a written agreement between you and Nokia. |
||
15 | ** |
||
16 | ** GNU Lesser General Public License Usage |
||
17 | ** Alternatively, this file may be used under the terms of the GNU Lesser |
||
18 | ** General Public License version 2.1 as published by the Free Software |
||
19 | ** Foundation and appearing in the file LICENSE.LGPL included in the |
||
20 | ** packaging of this file. Please review the following information to |
||
21 | ** ensure the GNU Lesser General Public License version 2.1 requirements |
||
22 | ** will be met: http://www.gnu.org/licenses/old-licenses/lgpl-2.1.html. |
||
23 | ** |
||
24 | ** In addition, as a special exception, Nokia gives you certain additional |
||
25 | ** rights. These rights are described in the Nokia Qt LGPL Exception |
||
26 | ** version 1.1, included in the file LGPL_EXCEPTION.txt in this package. |
||
27 | ** |
||
28 | ** GNU General Public License Usage |
||
29 | ** Alternatively, this file may be used under the terms of the GNU |
||
30 | ** General Public License version 3.0 as published by the Free Software |
||
31 | ** Foundation and appearing in the file LICENSE.GPL included in the |
||
32 | ** packaging of this file. Please review the following information to |
||
33 | ** ensure the GNU General Public License version 3.0 requirements will be |
||
34 | ** met: http://www.gnu.org/copyleft/gpl.html. |
||
35 | ** |
||
36 | ** If you have questions regarding the use of this file, please contact |
||
37 | ** Nokia at qt-info@nokia.com. |
||
38 | ** $QT_END_LICENSE$ |
||
39 | ** |
||
40 | ****************************************************************************/ |
||
41 | |||
42 | /* |
||
43 | |||
44 | |||
45 | A delegate that allows the user to change integer values from the model |
||
46 | |||
47 | */ |
||
48 | |||
49 | #include <QtGui> |
||
50 | |||
51 | #include "delegate.h" |
||
52 | |||
53 | |||
54 | |||
55 | |||
56 | : QItemDelegate(parent) |
||
57 | { |
||
58 | } |
||
59 | //! [0] |
||
60 | |||
61 | void SpinBoxDelegate::setInctance(QString newInctance){ |
||
62 | |||
126 | pingvin | 63 | } |
64 | |||
65 | void SpinBoxDelegate::getItems(){ |
||
66 | |||
67 | QSqlQuery q; |
||
68 | QString query_str; |
||
69 | bool ok; |
||
70 | |||
71 | if (SpinBoxDelegate::inctance.isEmpty()) |
||
72 | |||
73 | items.clear(); |
||
74 | return; |
||
75 | } |
||
76 | |||
77 | query_str = tr("select * from `"); |
||
78 | |||
79 | query_str.append( tr("`")); |
||
80 | |||
81 | q.prepare(query_str); |
||
82 | |||
83 | |||
84 | |||
85 | |||
86 | |||
87 | |||
88 | |||
89 | |||
90 | |||
91 | QString error_str; |
||
92 | error_str = tr(" "); |
||
93 | error_str.append(inctance); |
||
94 | QMessageBox::critical( // . |
||
95 | this, // . |
||
96 | QObject::tr("Database Error"), // . |
||
97 | q.lastError().text()); // . |
||
98 | // tr(" ")); // . |
||
99 | |||
100 | */ |
||
101 | |||
102 | return; |
||
103 | } |
||
104 | |||
105 | |||
106 | |||
107 | |||
108 | while(q.next()){ |
||
129 | pingvin | 109 | |
126 | pingvin | 110 | QString ID; |
111 | |||
112 | ID = q.value(0).toString(); // ID |
||
113 | Name = q.value(1).toString(); // Name |
||
114 | items.insert(ID, Name); |
||
115 | } |
||
116 | |||
117 | |||
118 | |||
119 | |||
120 | |||
121 | |||
122 | |||
123 | |||
123 | pingvin | 124 | const QStyleOptionViewItem &/* option */, |
125 | const QModelIndex &/* index */) const |
||
126 | { |
||
127 | //QSpinBox *editor = new QSpinBox(parent); |
||
128 | //editor->setMinimum(0); |
||
129 | //editor->setMaximum(100); |
||
130 | QStringList ID_list; |
||
131 | QStringList Name_list; |
||
126 | pingvin | 132 | |
133 | // getItems(); |
||
134 | |||
135 | |||
136 | |||
137 | |||
138 | |||
139 | |||
140 | |||
141 | |||
142 | QComboBox *editor = new QComboBox(parent); |
||
143 | |||
123 | pingvin | 144 | /* |
126 | pingvin | 145 | |
146 | editor->addItem("1"); |
||
123 | pingvin | 147 | editor->addItem("2"); |
148 | editor->addItem("3"); |
||
149 | editor->addItem("4"); |
||
150 | editor->addItem("5"); |
||
151 | editor->addItem("6"); |
||
152 | editor->addItem("7"); |
||
153 | editor->addItem("8"); |
||
154 | editor->addItem("9"); |
||
155 | */ |
||
156 | |||
126 | pingvin | 157 | // editor->addItem("0"); |
123 | pingvin | 158 | |
126 | pingvin | 159 | editor->addItems(Name_list); |
160 | |||
161 | return editor; |
||
179 | pingvin | 162 | } |
123 | pingvin | 163 | //! [1] |
164 | |||
165 | //! [2] |
||
166 | |||
167 | const QModelIndex &index) const |
||
168 | { |
||
169 | // int value = index.model()->data(index, Qt::EditRole).toInt(); |
||
170 | |||
171 | // QSpinBox *spinBox = static_cast<QSpinBox*>(editor); |
||
172 | |||
173 | QString value = index.model()->data(index, Qt::EditRole).toString(); |
||
174 | |||
175 | QComboBox *comboBox = static_cast<QComboBox*>(editor); |
||
136 | pingvin | 176 | |
123 | pingvin | 177 | QStringList ID_list; |
126 | pingvin | 178 | |
179 | int curr_index; |
||
180 | |||
181 | ID_list = items.keys(); |
||
182 | |||
183 | |||
184 | curr_index = ID_list.indexOf(value); |
||
185 | |||
186 | comboBox->setCurrentIndex(curr_index); |
||
136 | pingvin | 187 | /**************************************************** |
126 | pingvin | 188 | if (value == "0") comboBox->setCurrentIndex(0); |
189 | if (value == "1") comboBox->setCurrentIndex(1); |
||
123 | pingvin | 190 | if (value == "2") comboBox->setCurrentIndex(2); |
191 | if (value == "3") comboBox->setCurrentIndex(3); |
||
192 | if (value == "4") comboBox->setCurrentIndex(4); |
||
193 | if (value == "5") comboBox->setCurrentIndex(5); |
||
194 | if (value == "6") comboBox->setCurrentIndex(6); |
||
195 | if (value == "7") comboBox->setCurrentIndex(7); |
||
196 | if (value == "8") comboBox->setCurrentIndex(8); |
||
197 | if (value == "9") comboBox->setCurrentIndex(9); |
||
198 | ******************************************************/ |
||
199 | comboBox->setEditable(false); |
||
126 | pingvin | 200 | |
179 | pingvin | 201 | |
123 | pingvin | 202 | |
203 | |||
204 | } |
||
205 | |||
206 | |||
207 | //! [3] |
||
208 | |||
209 | const QModelIndex &index) const |
||
210 | { |
||
211 | // QSpinBox *spinBox = static_cast<QSpinBox*>(editor); |
||
212 | // spinBox->interpretText(); |
||
213 | // int value = spinBox->value(); |
||
214 | |||
215 | // model->setData(index, value, Qt::EditRole); |
||
216 | |||
217 | QStringList Name_list; |
||
126 | pingvin | 218 | |
219 | QComboBox *comboBox = static_cast<QComboBox*>(editor); |
||
123 | pingvin | 220 | |
221 | currIndex = comboBox->currentIndex(); |
||
222 | if (currIndex==-1) return; |
||
223 | // QString value = comboBox->itemText(currIndex); |
||
136 | pingvin | 224 | |
126 | pingvin | 225 | ID_list = items.keys(); |
226 | |||
227 | |||
228 | QString value = ID_list.at(currIndex); |
||
229 | |||
230 | } |
||
123 | pingvin | 231 | //! [3] |
232 | |||
233 | //! [4] |
||
234 | |||
235 | const QStyleOptionViewItem &option, const QModelIndex &/* index */) const |
||
236 | { |
||
237 | editor->setGeometry(option.rect); |
||
238 | } |
||
239 | |||
240 | |||
219 | pingvin | 241 | |
242 | |||
243 | |||
244 | |||
245 | |||
246 | |||
247 | |||
248 | |||
249 | |||
250 | |||
251 | |||
252 | : QItemDelegate(parent) |
||
253 | { |
||
254 | } |
||
255 | //! [0] |
||
256 | |||
257 | void FilterSpinBoxDelegate::setClassID(QString newClassID){ |
||
258 | |||
259 | } |
||
260 | |||
261 | void FilterSpinBoxDelegate::getItems(){ |
||
262 | |||
263 | QSqlQuery q; |
||
264 | QString query_str; |
||
265 | bool ok; |
||
266 | |||
267 | if (FilterSpinBoxDelegate::class_id.isEmpty()) |
||
268 | |||
269 | items.clear(); |
||
270 | return; |
||
271 | } |
||
272 | |||
273 | query_str = tr("select * from `DescriptionOfClasses` where `ClassIdentifer` = '"); |
||
274 | |||
275 | query_str.append( tr("'")); |
||
276 | |||
277 | q.prepare(query_str); |
||
278 | |||
279 | |||
280 | |||
281 | |||
282 | |||
283 | |||
284 | |||
285 | |||
286 | |||
287 | QString error_str; |
||
288 | error_str = tr(" "); |
||
289 | error_str.append(inctance); |
||
290 | QMessageBox::critical( // . |
||
291 | this, // . |
||
292 | QObject::tr("Database Error"), // . |
||
293 | q.lastError().text()); // . |
||
294 | // tr(" ")); // . |
||
295 | |||
296 | */ |
||
297 | |||
298 | return; |
||
299 | } |
||
300 | |||
301 | |||
302 | |||
303 | |||
304 | while(q.next()){ |
||
305 | |||
306 | QString ID; |
||
307 | |||
308 | ID = q.value(0).toString(); // ID |
||
309 | Name = q.value(1).toString(); // Name |
||
310 | items.insert(ID, Name); |
||
311 | } |
||
312 | |||
313 | |||
314 | |||
315 | |||
316 | |||
317 | |||
318 | |||
319 | |||
320 | const QStyleOptionViewItem &/* option */, |
||
321 | const QModelIndex &/* index */) const |
||
322 | { |
||
323 | //QSpinBox *editor = new QSpinBox(parent); |
||
324 | //editor->setMinimum(0); |
||
325 | //editor->setMaximum(100); |
||
326 | QStringList ID_list; |
||
327 | QStringList Name_list; |
||
328 | |||
329 | // getItems(); |
||
330 | |||
331 | |||
332 | |||
333 | |||
334 | |||
335 | |||
336 | |||
337 | |||
338 | QComboBox *editor = new QComboBox(parent); |
||
339 | |||
340 | /* |
||
341 | |||
342 | editor->addItem("1"); |
||
343 | editor->addItem("2"); |
||
344 | editor->addItem("3"); |
||
345 | editor->addItem("4"); |
||
346 | editor->addItem("5"); |
||
347 | editor->addItem("6"); |
||
348 | editor->addItem("7"); |
||
349 | editor->addItem("8"); |
||
350 | editor->addItem("9"); |
||
351 | */ |
||
352 | |||
353 | // editor->addItem("0"); |
||
354 | |||
355 | editor->addItems(Name_list); |
||
356 | |||
357 | return editor; |
||
358 | } |
||
359 | //! [1] |
||
360 | |||
361 | //! [2] |
||
362 | |||
363 | const QModelIndex &index) const |
||
364 | { |
||
365 | // int value = index.model()->data(index, Qt::EditRole).toInt(); |
||
366 | |||
367 | // QSpinBox *spinBox = static_cast<QSpinBox*>(editor); |
||
368 | |||
369 | QString value = index.model()->data(index, Qt::EditRole).toString(); |
||
370 | |||
371 | QComboBox *comboBox = static_cast<QComboBox*>(editor); |
||
372 | |||
373 | QStringList ID_list; |
||
374 | |||
375 | int curr_index; |
||
376 | |||
377 | ID_list = items.keys(); |
||
378 | |||
379 | |||
380 | curr_index = ID_list.indexOf(value); |
||
381 | |||
382 | comboBox->setCurrentIndex(curr_index); |
||
383 | /**************************************************** |
||
384 | if (value == "0") comboBox->setCurrentIndex(0); |
||
385 | if (value == "1") comboBox->setCurrentIndex(1); |
||
386 | if (value == "2") comboBox->setCurrentIndex(2); |
||
387 | if (value == "3") comboBox->setCurrentIndex(3); |
||
388 | if (value == "4") comboBox->setCurrentIndex(4); |
||
389 | if (value == "5") comboBox->setCurrentIndex(5); |
||
390 | if (value == "6") comboBox->setCurrentIndex(6); |
||
391 | if (value == "7") comboBox->setCurrentIndex(7); |
||
392 | if (value == "8") comboBox->setCurrentIndex(8); |
||
393 | if (value == "9") comboBox->setCurrentIndex(9); |
||
394 | ******************************************************/ |
||
395 | comboBox->setEditable(false); |
||
396 | |||
397 | |||
398 | |||
399 | |||
400 | } |
||
401 | |||
402 | |||
403 | //! [3] |
||
404 | |||
405 | const QModelIndex &index) const |
||
406 | { |
||
407 | // QSpinBox *spinBox = static_cast<QSpinBox*>(editor); |
||
408 | // spinBox->interpretText(); |
||
409 | // int value = spinBox->value(); |
||
410 | |||
411 | // model->setData(index, value, Qt::EditRole); |
||
412 | |||
413 | QStringList Name_list; |
||
414 | |||
415 | QComboBox *comboBox = static_cast<QComboBox*>(editor); |
||
416 | |||
417 | currIndex = comboBox->currentIndex(); |
||
418 | if (currIndex==-1) return; |
||
419 | // QString value = comboBox->itemText(currIndex); |
||
420 | |||
421 | ID_list = items.keys(); |
||
422 | |||
423 | |||
424 | // QString value = ID_list.at(currIndex); |
||
425 | |||
426 | model->setData(index, value, Qt::EditRole); |
||
427 | } |
||
428 | //! [3] |
||
429 | |||
430 | //! [4] |
||
431 | |||
123 | pingvin | 432 | const QStyleOptionViewItem &option, const QModelIndex &/* index */) const |
219 | pingvin | 433 | { |
434 | editor->setGeometry(option.rect); |
||
435 | } |
||
436 | |||
437 | |||
438 | |||
439 | |||
440 | |||
441 | |||
442 | |||
443 | |||
444 | |||
445 | |||
446 | |||
447 | |||
448 | : QItemDelegate(parent) |
||
449 | { |
||
450 | } |
||
451 | //! [0] |
||
452 | |||
453 | void FilterConditionDelegate::setClassID(QString newClassID){ |
||
454 | |||
455 | } |
||
456 | |||
457 | |||
458 | |||
459 | |||
460 | |||
461 | const QStyleOptionViewItem &/* option */, |
||
462 | const QModelIndex &/* index */) const |
||
463 | { |
||
464 | QStringList Name_list; |
||
465 | |||
466 | Name_list = items; |
||
467 | |||
468 | QComboBox *editor = new QComboBox(parent); |
||
469 | |||
470 | /* |
||
471 | |||
472 | editor->addItem("1"); |
||
473 | editor->addItem("2"); |
||
474 | editor->addItem("3"); |
||
475 | editor->addItem("4"); |
||
476 | editor->addItem("5"); |
||
477 | editor->addItem("6"); |
||
478 | editor->addItem("7"); |
||
479 | editor->addItem("8"); |
||
480 | editor->addItem("9"); |
||
481 | */ |
||
482 | |||
483 | // editor->addItem("0"); |
||
484 | |||
485 | editor->addItems(Name_list); |
||
486 | |||
487 | return editor; |
||
488 | } |
||
489 | //! [1] |
||
490 | |||
491 | //! [2] |
||
492 | |||
493 | const QModelIndex &index) const |
||
494 | { |
||
495 | // int value = index.model()->data(index, Qt::EditRole).toInt(); |
||
496 | |||
497 | // QSpinBox *spinBox = static_cast<QSpinBox*>(editor); |
||
498 | |||
499 | QString value = index.model()->data(index, Qt::EditRole).toString(); |
||
500 | |||
501 | QComboBox *comboBox = static_cast<QComboBox*>(editor); |
||
502 | |||
503 | //QStringList ID_list; |
||
504 | |||
505 | int curr_index; |
||
506 | |||
507 | //ID_list = items.keys(); |
||
508 | |||
509 | |||
510 | curr_index = items.indexOf(value); |
||
511 | |||
512 | comboBox->setCurrentIndex(curr_index); |
||
513 | /**************************************************** |
||
514 | if (value == "0") comboBox->setCurrentIndex(0); |
||
515 | if (value == "1") comboBox->setCurrentIndex(1); |
||
516 | if (value == "2") comboBox->setCurrentIndex(2); |
||
517 | if (value == "3") comboBox->setCurrentIndex(3); |
||
518 | if (value == "4") comboBox->setCurrentIndex(4); |
||
519 | if (value == "5") comboBox->setCurrentIndex(5); |
||
520 | if (value == "6") comboBox->setCurrentIndex(6); |
||
521 | if (value == "7") comboBox->setCurrentIndex(7); |
||
522 | if (value == "8") comboBox->setCurrentIndex(8); |
||
523 | if (value == "9") comboBox->setCurrentIndex(9); |
||
524 | ******************************************************/ |
||
525 | comboBox->setEditable(false); |
||
526 | |||
527 | |||
528 | |||
529 | |||
530 | } |
||
531 | |||
532 | |||
533 | //! [3] |
||
534 | |||
535 | const QModelIndex &index) const |
||
536 | { |
||
537 | // QSpinBox *spinBox = static_cast<QSpinBox*>(editor); |
||
538 | // spinBox->interpretText(); |
||
539 | // int value = spinBox->value(); |
||
540 | |||
541 | // model->setData(index, value, Qt::EditRole); |
||
542 | |||
543 | QStringList Name_list; |
||
544 | |||
545 | QComboBox *comboBox = static_cast<QComboBox*>(editor); |
||
546 | |||
547 | currIndex = comboBox->currentIndex(); |
||
548 | if (currIndex==-1) return; |
||
549 | // QString value = comboBox->itemText(currIndex); |
||
550 | |||
551 | // ID_list = items.keys(); |
||
552 | |||
553 | |||
554 | // QString value = ID_list.at(currIndex); |
||
555 | |||
556 | model->setData(index, value, Qt::EditRole); |
||
557 | } |
||
558 | //! [3] |
||
559 | |||
560 | //! [4] |
||
561 | |||
562 | const QStyleOptionViewItem &option, const QModelIndex &/* index */) const |
||
563 | { |
||
564 | editor->setGeometry(option.rect); |
||
565 | } |
||
566 | |||
567 | |||
568 | |||
569 | |||
570 | |||
571 | |||
572 | |||
573 | |||
574 | |||
575 | |||
576 | |||
577 | |||
224 | pingvin | 578 | { |
579 | } |
||
580 | //! [0] |
||
581 | |||
582 | void FilterValueDelegate::setClassID(QString newClassID){ |
||
583 | |||
584 | } |
||
585 | |||
586 | |||
587 | |||
588 | |||
589 | |||
225 | pingvin | 590 | |
591 | |||
592 | |||
593 | |||
594 | |||
595 | |||
596 | QString result; |
||
597 | QString classInctance; |
||
598 | int field_inctance; |
||
599 | bool ok; |
||
600 | sql_str = tr("select * " |
||
601 | " from ListOfClasses where ListOfClasses.ID = '" // , |
||
602 | ); |
||
603 | sql_str.append(class_id); |
||
604 | sql_str.append(tr("'")); |
||
605 | q.prepare(sql_str); |
||
606 | |||
607 | ok = q.exec(); |
||
608 | |||
609 | if (!ok) return result; |
||
610 | |||
611 | /* |
||
612 | |||
613 | QMessageBox::critical( // . |
||
614 | this, // . |
||
615 | QObject::tr("Database Error"), // . |
||
616 | q.lastError().text()); // . |
||
617 | return result; |
||
618 | } |
||
619 | |||
620 | */ |
||
621 | |||
622 | |||
623 | |||
624 | |||
625 | |||
626 | |||
627 | |||
628 | classInctance = q.value(field_inctance).toString(); |
||
629 | |||
630 | } |
||
631 | |||
632 | return result; |
||
633 | |||
634 | |||
635 | |||
636 | |||
637 | |||
638 | |||
639 | |||
640 | |||
641 | |||
642 | |||
643 | |||
226 | pingvin | 644 | |
225 | pingvin | 645 | } |
646 | |||
647 | QMap<QString, QString> FilterValueDelegate::getItems(QString inctance){ // - |
||
648 | |||
227 | pingvin | 649 | QString sql_str; |
650 | QStringList keys_list; |
||
651 | QStringList values_list; |
||
652 | QMap<QString, QString> result_map; |
||
653 | |||
654 | |||
225 | pingvin | 655 | |
226 | pingvin | 656 | |
657 | |||
658 | |||
227 | pingvin | 659 | sql_str.append(inctance); |
660 | sql_str.append(tr("`")); |
||
661 | ok = q.prepare(sql_str); |
||
662 | ok = q.exec(); |
||
663 | if(!ok) return result_map; |
||
664 | while (q.next()){ |
||
665 | QString key_tmp; |
||
666 | QString value_tmp; |
||
667 | |||
668 | key_tmp = q.record().value(0).asString(); // id |
||
226 | pingvin | 669 | |
227 | pingvin | 670 | |
671 | value_tmp = q.record().value(1).asString(); // |
||
226 | pingvin | 672 | |
227 | pingvin | 673 | result_map.insert(key_tmp, value_tmp); |
674 | |||
675 | |||
676 | |||
677 | |||
678 | |||
679 | |||
680 | |||
681 | |||
682 | |||
683 | |||
684 | |||
685 | } |
||
686 | |||
687 | |||
688 | |||
689 | |||
690 | |||
691 | |||
224 | pingvin | 692 | const QStyleOptionViewItem &/* option */, |
693 | const QModelIndex &/* index */) const |
||
694 | { |
||
695 | QStringList Name_list; |
||
696 | |||
697 | Name_list = items; |
||
698 | |||
699 | QComboBox *editor = new QComboBox(parent); |
||
700 | |||
701 | /* |
||
702 | |||
703 | editor->addItem("1"); |
||
704 | editor->addItem("2"); |
||
705 | editor->addItem("3"); |
||
706 | editor->addItem("4"); |
||
707 | editor->addItem("5"); |
||
708 | editor->addItem("6"); |
||
709 | editor->addItem("7"); |
||
710 | editor->addItem("8"); |
||
711 | editor->addItem("9"); |
||
712 | */ |
||
713 | |||
714 | // editor->addItem("0"); |
||
715 | |||
716 | // // // editor->addItems(Name_list); |
||
717 | |||
718 | return editor; |
||
225 | pingvin | 719 | } |
224 | pingvin | 720 | //! [1] |
721 | |||
722 | |||
723 | |||
225 | pingvin | 724 | |
725 | |||
726 | |||
226 | pingvin | 727 | const QAbstractItemModel * model = index.model(); |
728 | |||
729 | TField field_result; |
||
225 | pingvin | 730 | |
226 | pingvin | 731 | QString sql_str; |
732 | bool ok; |
||
733 | |||
734 | |||
225 | pingvin | 735 | |
736 | |||
226 | pingvin | 737 | field_result.FieldName = index.model()->data(model->index(index.row(),4), Qt::EditRole).toString(); |
738 | field_result.ClassIdentifer = index.model()->data(model->index(index.row(),2), Qt::EditRole).toString(); |
||
739 | |||
740 | sql_str = tr("select * from `DescriptionOfClasses` where `ClassIdentifer` = '"); |
||
225 | pingvin | 741 | |
226 | pingvin | 742 | sql_str.append(tr("' and `FieldName` = '")); |
743 | sql_str.append(field_result.FieldName); |
||
744 | sql_str.append(tr("'")); |
||
745 | |||
746 | ok = q.prepare(sql_str); |
||
225 | pingvin | 747 | |
226 | pingvin | 748 | if(!ok) return field_result; |
225 | pingvin | 749 | |
226 | pingvin | 750 | ok = q.exec(); |
751 | |||
752 | if(!ok) return field_result; |
||
753 | |||
754 | int ID_index = q.record().indexOf(tr("ID")); |
||
755 | |||
756 | int FieldAlias_index = q.record().indexOf(tr("FieldAlias")); |
||
757 | |||
758 | int FieldType_index = q.record().indexOf(tr("FieldType")); |
||
759 | |||
760 | int DefaultValue_index = q.record().indexOf(tr("DefaultValue")); |
||
761 | |||
762 | int Comment_index = q.record().indexOf(tr("Comment")); |
||
763 | |||
764 | |||
765 | |||
766 | |||
767 | |||
768 | field_result.FieldAlias = q.value(FieldAlias_index).asString(); |
||
769 | field_result.FieldType = q.value(FieldType_index).asString(); |
||
770 | field_result.DefaultValue = q.value(DefaultValue_index).asString(); |
||
771 | field_result.Comment = q.value(Comment_index).asString(); |
||
772 | } |
||
773 | |||
774 | return field_result; |
||
775 | |||
776 | |||
777 | |||
778 | |||
779 | |||
780 | |||
781 | |||
782 | |||
783 | |||
784 | |||
785 | |||
224 | pingvin | 786 | const QModelIndex &index) const |
787 | { |
||
788 | // int value = index.model()->data(index, Qt::EditRole).toInt(); |
||
789 | |||
790 | // QSpinBox *spinBox = static_cast<QSpinBox*>(editor); |
||
791 | |||
792 | |||
793 | |||
794 | |||
795 | |||
796 | |||
797 | |||
798 | |||
799 | QComboBox *comboBox = static_cast<QComboBox*>(editor); |
||
800 | QString inctance; // |
||
801 | QString fieldName;// |
||
225 | pingvin | 802 | QSqlQuery q; |
803 | QString sql_str; |
||
804 | QStringList itemsList; |
||
805 | bool ok; |
||
806 | TField Field; |
||
807 | |||
226 | pingvin | 808 | Field = getField(index); |
224 | pingvin | 809 | |
226 | pingvin | 810 | |
225 | pingvin | 811 | |
812 | |||
227 | pingvin | 813 | QMap<QString, QString> items_map; |
814 | QStringList items_list; |
||
815 | |||
816 | parent_inctance = getClassInctanc(Field.DefaultValue);// - |
||
226 | pingvin | 817 | |
227 | pingvin | 818 | items_list = items_map.values(); |
819 | |||
820 | comboBox->addItems(items_list); |
||
226 | pingvin | 821 | |
227 | pingvin | 822 | return; |
823 | |||
824 | |||
226 | pingvin | 825 | |
826 | |||
227 | pingvin | 827 | |
828 | |||
829 | |||
830 | |||
831 | |||
225 | pingvin | 832 | |
833 | |||
834 | |||
835 | sql_str = tr("select `"); |
||
836 | sql_str.append(fieldName); |
||
837 | sql_str.append(tr("` from `")); |
||
838 | sql_str.append(inctance); |
||
839 | sql_str.append(tr("`")); |
||
840 | ok = q.prepare(sql_str); |
||
841 | ok = q.exec(); |
||
842 | |||
843 | while(q.next()){ |
||
844 | |||
845 | tmp_str = q.record().value(fieldName).asString(); |
||
846 | itemsList.append(tmp_str); |
||
847 | FilterValueDelegate::items.append(tmp_str); |
||
848 | } |
||
849 | if(!itemsList.isEmpty()) { |
||
850 | comboBox->addItems(itemsList); |
||
851 | items = itemsList; // |
||
852 | } |
||
853 | |||
854 | } |
||
855 | |||
856 | |||
857 | |||
858 | |||
859 | |||
860 | |||
861 | |||
224 | pingvin | 862 | int curr_index; |
863 | |||
864 | //ID_list = items.keys(); |
||
865 | |||
866 | |||
867 | curr_index = itemsList.indexOf(value); |
||
868 | |||
225 | pingvin | 869 | comboBox->setCurrentIndex(curr_index); |
224 | pingvin | 870 | /**************************************************** |
871 | if (value == "0") comboBox->setCurrentIndex(0); |
||
872 | if (value == "1") comboBox->setCurrentIndex(1); |
||
873 | if (value == "2") comboBox->setCurrentIndex(2); |
||
874 | if (value == "3") comboBox->setCurrentIndex(3); |
||
875 | if (value == "4") comboBox->setCurrentIndex(4); |
||
876 | if (value == "5") comboBox->setCurrentIndex(5); |
||
877 | if (value == "6") comboBox->setCurrentIndex(6); |
||
878 | if (value == "7") comboBox->setCurrentIndex(7); |
||
879 | if (value == "8") comboBox->setCurrentIndex(8); |
||
880 | if (value == "9") comboBox->setCurrentIndex(9); |
||
881 | ******************************************************/ |
||
882 | comboBox->setEditable(true); |
||
883 | |||
225 | pingvin | 884 | |
224 | pingvin | 885 | |
886 | |||
887 | } |
||
888 | |||
889 | |||
890 | //! [3] |
||
891 | |||
892 | const QModelIndex &index) const |
||
893 | { |
||
894 | // QSpinBox *spinBox = static_cast<QSpinBox*>(editor); |
||
895 | // spinBox->interpretText(); |
||
896 | // int value = spinBox->value(); |
||
897 | |||
898 | // model->setData(index, value, Qt::EditRole); |
||
899 | |||
900 | QComboBox *comboBox = static_cast<QComboBox*>(editor); |
||
225 | pingvin | 901 | |
224 | pingvin | 902 | currIndex = comboBox->currentIndex(); |
227 | pingvin | 903 | |
224 | pingvin | 904 | if (currIndex==-1) return; |
227 | pingvin | 905 | |
224 | pingvin | 906 | QString new_value = comboBox->itemText(currIndex); |
907 | |||
227 | pingvin | 908 | QString curr_value = model->data(index, Qt::EditRole).toString();// |
909 | |||
910 | |||
911 | |||
912 | |||
913 | |||
914 | |||
915 | |||
916 | |||
917 | |||
918 | |||
919 | |||
920 | |||
921 | Field = getField(index); |
||
922 | |||
923 | if(Field.FieldType==tr("pointer")){ |
||
924 | |||
925 | QMap<QString, QString> items_map; |
||
926 | QStringList keys_list; // ID |
||
927 | QStringList values_list; // |
||
928 | |||
929 | |||
930 | |||
931 | |||
932 | |||
933 | keys_list = items_map.keys(); |
||
934 | values_list = items_map.values(); |
||
935 | |||
936 | if( values_list.indexOf(new_value)!=-1){ // |
||
937 | |||
938 | QString new_key = keys_list.at(values_list.indexOf(new_value)); // |
||
939 | |||
940 | return; |
||
941 | } |
||
942 | |||
943 | |||
944 | |||
945 | |||
946 | |||
947 | |||
948 | |||
949 | |||
950 | |||
951 | |||
952 | |||
953 | |||
954 | |||
955 | |||
956 | |||
957 | |||
958 | |||
959 | |||
960 | |||
224 | pingvin | 961 | |
962 | // QString value = ID_list.at(currIndex); |
||
963 | |||
964 | model->setData(index, new_value, Qt::EditRole); |
||
227 | pingvin | 965 | |
966 | |||
225 | pingvin | 967 | |
968 | |||
224 | pingvin | 969 | |
225 | pingvin | 970 | |
971 | |||
972 | |||
973 | |||
974 | |||
975 | |||
976 | |||
977 | |||
224 | pingvin | 978 | //! [4] |
979 | |||
219 | pingvin | 980 | const QStyleOptionViewItem &option, const QModelIndex &/* index */) const |
224 | pingvin | 981 | { |
982 | editor->setGeometry(option.rect); |
||
983 | } |
||
984 | |||
985 | |||
986 | |||
987 | |||
988 | |||
989 | |||
990 | |||
991 | |||
992 | |||
993 | |||
994 | |||
995 | |||
996 | |||
997 | |||
998 | |||
999 | |||
1000 | |||
1001 | bool calpopup, |
||
123 | pingvin | 1002 | QObject *parent) |
1003 | : QItemDelegate(parent), |
||
1004 | m_calpopup(calpopup) { |
||
1005 | } |
||
1006 | |||
1007 | QWidget *MyDEDelegate::createEditor( |
||
1008 | |||
1009 | const QStyleOptionViewItem& /* option */, |
||
1010 | const QModelIndex& /* index */) const { |
||
1011 | QDateEdit *editor = new QDateEdit(parent); |
||
1012 | editor->setCalendarPopup(m_calpopup); |
||
1013 | editor->installEventFilter(const_cast<MyDEDelegate*>(this)); |
||
1014 | return editor; |
||
1015 | } |
||
1016 | |||
1017 | void MyDEDelegate::setEditorData( |
||
1018 | |||
1019 | const QModelIndex &index) const { |
||
1020 | QDate value = index.model()->data( |
||
1021 | index, Qt::EditRole).toDate(); |
||
1022 | QDateEdit *de = static_cast<QDateEdit*>(editor); |
||
1023 | de->setDate(value); |
||
1024 | } |
||
1025 | |||
1026 | void MyDEDelegate::setModelData( |
||
1027 | |||
1028 | QAbstractItemModel *model, |
||
1029 | const QModelIndex& index) const { |
||
1030 | QDateEdit *de = static_cast<QDateEdit*>(editor); |
||
1031 | de->interpretText(); |
||
1032 | QDate value = de->date(); |
||
1033 | model->setData(index, value); |
||
1034 | } |
||
1035 | |||
1036 | void MyDEDelegate::updateEditorGeometry( |
||
1037 | |||
1038 | const QStyleOptionViewItem &option, |
||
1039 | const QModelIndex& /* index */) const { |
||
1040 | |||
1041 | |||
169 | pingvin | 1042 | |
1043 | |||
1044 | |||
123 | pingvin | 1045 | |
1046 | |||
138 | pingvin | 1047 | |
1048 | |||
1049 | |||
1050 | |||
1051 | |||
1052 | } |
||
1053 | |||
1054 | void CPictureDelegate::paint(QPainter *painter, const QStyleOptionViewItem &option, const QModelIndex &index) const |
||
1055 | |||
1056 | m_pxPicture.fill( QColor(Qt::white) ); |
||
1057 | |||
1058 | const QAbstractItemModel * model = index.model(); |
||
1059 | |||
1060 | |||
1061 | if ( !sFileName.isEmpty() ) |
||
1062 | |||
1063 | else { |
||
1064 | //QItemDelegate::paint(painter, option, index); |
||
1065 | return; |
||
1066 | } |
||
1067 | |||
1068 | QPalette::ColorGroup cg = (option.state & QStyle::State_Enabled) ? |
||
1069 | |||
1070 | QPalette::Disabled; |
||
1071 | |||
1072 | if (option.state & QStyle::State_Selected) |
||
1073 | |||
1074 | |||
1075 | int nX = option.rect.x() + ( ( option.rect.width() - m_pxPicture.rect().width() ) / 2 ); |
||
1076 | |||
1077 | painter->drawPixmap( nX, nY, m_pxPicture ); |
||
1078 | |||
1079 | |||
1080 | |||
1081 | |||
1082 | /* |
||
1083 | |||
1084 | painter->setPen(option.palette.color(QPalette::Mid)); |
||
1085 | painter->drawLine(option.rect.bottomLeft(), option.rect.bottomRight()); |
||
1086 | painter->drawLine(option.rect.topRight(), option.rect.bottomRight()); |
||
1087 | painter->setPen(pen); |
||
1088 | */ |
||
1089 | } |
||
1090 | |||
1091 | |||
158 | pingvin | 1092 | |
1093 | |||
1094 | |||
1095 | |||
1096 | { |
||
1097 | int datetime = index.model()->data(index, Qt::DisplayRole).toInt(); |
||
1098 | |||
1099 | QString indexvalue = ""; |
||
1100 | |||
1101 | if (datetime > 0) |
||
1102 | |||
1103 | QDateTime dateTime2 = QDateTime(); |
||
1104 | dateTime2.setTime_t(datetime); |
||
1105 | indexvalue = dateTime2.toString(this->timeformat); |
||
1106 | } |
||
1107 | else |
||
1108 | { |
||
1109 | indexvalue = tr("Date not set"); |
||
1110 | } |
||
1111 | |||
1112 | Q_ASSERT(index.isValid()); |
||
1113 | |||
1114 | QStyleOptionViewItemV3 opt = setOptions(index, option); |
||
1115 | |||
1116 | const QStyleOptionViewItemV2 *v2 = qstyleoption_cast<const QStyleOptionViewItemV2 *>(&option); |
||
1117 | |||
1118 | : QStyleOptionViewItemV2::ViewItemFeatures(QStyleOptionViewItemV2::None); |
||
1119 | const QStyleOptionViewItemV3 *v3 = qstyleoption_cast<const QStyleOptionViewItemV3 *>(&option); |
||
1120 | opt.locale = v3 ? v3->locale : QLocale(); |
||
1121 | opt.widget = v3 ? v3->widget : 0; |
||
1122 | |||
1123 | // prepare |
||
1124 | |||
1125 | |||
1126 | painter->setClipRect(opt.rect); |
||
1127 | |||
1128 | // get the data and the rectangles |
||
1129 | |||
1130 | |||
1131 | QPixmap pixmap; |
||
1132 | |||
1133 | value = index.data(Qt::DecorationRole); |
||
1134 | |||
1135 | QString text; |
||
1136 | |||
1137 | value = index.data(Qt::DisplayRole); |
||
1138 | if (value.isValid()) { |
||
1139 | text = indexvalue; |
||
1140 | displayRect = textRectangle(painter, option.rect, opt.font, text); |
||
1141 | } |
||
1142 | |||
1143 | QRect checkRect; |
||
1144 | |||
1145 | value = index.data(Qt::CheckStateRole); |
||
1146 | if (value.isValid()) { |
||
1147 | checkState = static_cast<Qt::CheckState>(value.toInt()); |
||
1148 | checkRect = check(opt, opt.rect, value); |
||
1149 | } |
||
1150 | |||
1151 | // do the layout |
||
1152 | |||
1153 | // draw the item |
||
1154 | |||
1155 | drawBackground(painter, opt, index); |
||
1156 | |||
1157 | drawDecoration(painter, opt, decorationRect, pixmap); |
||
1158 | drawDisplay(painter, opt, displayRect, text); |
||
1159 | drawFocus(painter, opt, displayRect); |
||
1160 | |||
1161 | // done |
||
1162 | |||
1163 | } |
||
1164 | |||
1165 | |||
180 | pingvin | 1166 | |
1167 | |||
1168 | |||
1169 | |||
1170 | |||
1171 | |||
1172 | } |
||
1173 | |||
1174 | |||
1175 | |||
1176 | |||
1177 | |||
1178 | |||
1179 | |||
1180 | const QModelIndex & /* index */) const |
||
1181 | { |
||
1182 | |||
1183 | IconForm *editor = new IconForm(parent); |
||
1184 | |||
1185 | return editor; |
||
1186 | |||
1187 | } |
||
1188 | |||
1189 | |||
1190 | |||
1191 | |||
1192 | |||
1193 | |||
1194 | { |
||
1195 | |||
1196 | |||
1197 | |||
1198 | |||
1199 | QVariant currentImage = model->data(index,0); |
||
1200 | QByteArray bytes = currentImage.toByteArray(); |
||
1201 | if (currentImage.isValid()) { |
||
1202 | m_pxPicture.loadFromData(bytes); |
||
1203 | } |
||
1204 | else { |
||
1205 | //QItemDelegate::paint(painter, option, index); |
||
1206 | |||
1207 | |||
1208 | |||
1209 | |||
1210 | icnFrm->setPixmap(m_pxPicture); |
||
1211 | // tblView->setRowHeight(index.row(), icnFrm->geometry().height()); |
||
1212 | } |
||
1213 | |||
1214 | |||
1215 | |||
1216 | |||
1217 | |||
1218 | |||
1219 | QAbstractItemModel *model, |
||
1220 | const QModelIndex& index) const { |
||
1221 | IconForm *icnFrm = static_cast<IconForm*>(editor); |
||
1222 | if (!(icnFrm->dataIsChanged())) return; |
||
1223 | |||
1224 | m_pxPicture = icnFrm->pixmap(); |
||
1225 | |||
1226 | QByteArray bytes; |
||
1227 | QBuffer buffer(&bytes); |
||
1228 | buffer.open(QIODevice::WriteOnly); |
||
1229 | currentImage.save(&buffer, "PNG"); |
||
1230 | |||
1231 | |||
1232 | |||
1233 | |||
1234 | |||
1235 | |||
1236 | // int widht = m_pxPicture.width(); |
||
1237 | |||
1238 | // tblView->setRowHeight(index.row(), heigh + 10); |
||
1239 | // model->submitAll(); |
||
1240 | |||
1241 | |||
1242 | |||
1243 | |||
1244 | |||
1245 | |||
1246 | |||
1247 | |||
1248 | |||
1249 | |||
1250 | |||
1251 | const QStyleOptionViewItem &option, |
||
1252 | const QModelIndex& /* index */) const { |
||
1253 | |||
1254 | |||
1255 | |||
1256 | |||
1257 | |||
1258 | editor->setGeometry(option.rect); |
||
1259 | |||
1260 | |||
1261 | |||
1262 | |||
1263 | |||
1264 | |||
1265 | |||
1266 | |||
1267 | |||
1268 | |||
1269 | |||
1270 | const QAbstractItemModel * model = index.model(); |
||
1271 | |||
1272 | |||
1273 | QVariant currentImage = model->data(index,0); |
||
1274 | |||
1275 | |||
1276 | |||
1277 | |||
1278 | // image.loadFromData(bytes); |
||
1279 | |||
1280 | |||
1281 | |||
1282 | |||
1283 | |||
1284 | } |
||
1285 | |||
1286 | //QItemDelegate::paint(painter, option, index); |
||
1287 | return; |
||
1288 | } |
||
1289 | |||
1290 | |||
1291 | |||
1292 | |||
1293 | |||
1294 | |||
1295 | |||
1296 | if ( !sFileName.isEmpty() ) |
||
1297 | |||
1298 | else { |
||
1299 | //QItemDelegate::paint(painter, option, index); |
||
1300 | return; |
||
1301 | } |
||
1302 | */ |
||
1303 | |||
1304 | |||
1305 | |||
1306 | |||
205 | pingvin | 1307 | |
1308 | |||
1309 | |||
180 | pingvin | 1310 | QPalette::Disabled; |
1311 | |||
1312 | if (option.state & QStyle::State_Selected) |
||
1313 | |||
1314 | |||
1315 | |||
1316 | |||
1317 | |||
1318 | |||
205 | pingvin | 1319 | |
1320 | |||
180 | pingvin | 1321 | // painter->setRenderHint(QPainter::Antialiasing); |
1322 | painter->drawPixmap( nX, nY, m_pxPicture ); |
||
205 | pingvin | 1323 | |
180 | pingvin | 1324 | // drawFocus(painter, option, option.rect.adjusted(0, 0, -1, -1)); // since we draw the grid ourselves |
1325 | |||
1326 | /* |
||
1327 | |||
1328 | painter->setPen(option.palette.color(QPalette::Mid)); |
||
1329 | painter->drawLine(option.rect.bottomLeft(), option.rect.bottomRight()); |
||
1330 | painter->drawLine(option.rect.topRight(), option.rect.bottomRight()); |
||
1331 | painter->setPen(pen); |
||
1332 | */ |
||
1333 | } |
||
1334 | |||
1335 | |||
1336 | |||
1337 | |||
1338 | } |
||
1339 | |||
1340 | |||
201 | pingvin | 1341 | |
1342 | |||
1343 | |||
1344 | |||
1345 | |||
1346 | |||
1347 | |||
1348 | |||
1349 | } |
||
1350 | |||
1351 | |||
1352 | |||
1353 | |||
1354 | |||
1355 | |||
1356 | |||
1357 | const QModelIndex & /* index */) const |
||
1358 | { |
||
1359 | |||
1360 | FileForm *editor = new FileForm(parent); |
||
1361 | |||
1362 | return editor; |
||
1363 | |||
1364 | } |
||
1365 | |||
1366 | |||
1367 | |||
1368 | |||
1369 | |||
1370 | |||
1371 | { |
||
1372 | |||
1373 | |||
1374 | |||
1375 | |||
1376 | QVariant currentData = model->data(index,Qt::EditRole); |
||
1377 | |||
202 | pingvin | 1378 | // QVariant currentData = QSqlTableModel::data(index, 0); |
1379 | |||
1380 | if (currentData.isValid()) flFrm->setData(bytes); |
||
201 | pingvin | 1381 | else return; |
1382 | |||
1383 | } |
||
1384 | |||
1385 | |||
1386 | |||
1387 | |||
1388 | |||
1389 | |||
1390 | QAbstractItemModel *model, |
||
1391 | const QModelIndex& index) const { |
||
1392 | FileForm *flFrm = static_cast<FileForm*>(editor); |
||
1393 | if (!(flFrm->dataIsChanged())) return; |
||
1394 | |||
1395 | m_Data = flFrm->data(); |
||
1396 | |||
1397 | model->setData(index, QVariant (m_Data), Qt::EditRole); |
||
1398 | |||
1399 | } |
||
1400 | |||
1401 | QVariant val_null; |
||
1402 | model->setData(index, val_null, Qt::EditRole); |
||
1403 | |||
1404 | } |
||
1405 | |||
1406 | |||
1407 | |||
1408 | |||
1409 | |||
1410 | |||
1411 | |||
1412 | |||
1413 | |||
1414 | const QStyleOptionViewItem &option, |
||
1415 | const QModelIndex& /* index */) const { |
||
1416 | |||
1417 | |||
1418 | |||
1419 | |||
1420 | |||
1421 | editor->setGeometry(option.rect); |
||
1422 | |||
1423 |