Редакция 128 | Редакция 158 | К новейшей редакции | Содержимое файла | Сравнить с предыдущей | Последнее изменение | Открыть журнал | RSS
Редакция | Автор | № строки | Строка |
---|---|---|---|
127 | pingvin | 1 | #include "mymodel.h" |
2 | |||
3 | MyModel::MyModel(QObject *parent) : |
||
4 | QSqlTableModel(parent) |
||
5 | { |
||
6 | setEditStrategy(QSqlTableModel::OnManualSubmit); |
||
7 | } |
||
8 | |||
9 | Qt::ItemFlags MyModel::flags( |
||
10 | const QModelIndex &index) const { |
||
11 | Qt::ItemFlags flags = QSqlTableModel::flags(index); |
||
12 | |||
13 | /*********************************************** |
||
14 | |||
15 | if ((index.column() != 3) && (index.column() != 0)) |
||
16 | flags |= Qt::ItemIsEditable; |
||
17 | //if (index.column() == 4) |
||
18 | // flags |= Qt::ItemIsUserCheckable; |
||
19 | else |
||
20 | { |
||
21 | if ((index.column() == 3) || (index.column() == 0)) flags &= ~Qt::ItemIsEditable; // |
||
22 | } |
||
23 | |||
24 | *************************************************/ |
||
25 | |||
26 | |||
27 | |||
28 | return flags; |
||
29 | } |
||
30 | |||
31 | |||
32 | bool MyModel::setData(const QModelIndex &index, const QVariant &value, int role) { |
||
33 | //// if (index.column()==3) return false; // |
||
34 | bool lResult = false; |
||
35 | |||
36 | /* |
||
37 | QString str_tmp; |
||
38 | if (index.column()==1) { // |
||
39 | str_tmp = value.toString(); // |
||
40 | str_tmp.append(tr(" instance")); |
||
41 | } |
||
42 | */ |
||
43 | /* |
||
44 | QString str_tmp; |
||
45 | if (index.column()==0) { // |
||
46 | str_tmp = value.toString(); // |
||
47 | str_tmp.append(tr("_instance")); |
||
48 | } |
||
49 | */ |
||
50 | lResult = QSqlTableModel::setData(index, value, role); |
||
51 | |||
52 | |||
53 | |||
54 | /*****************************************************8 |
||
55 | |||
56 | if (lResult) { |
||
57 | QModelIndex newindex; |
||
58 | QSqlRecord rec = record(index.row()); |
||
59 | |||
60 | rec.setValue(index.column(), value); |
||
61 | rec.setGenerated(index.column(), true); |
||
62 | |||
63 | |||
64 | |||
65 | lResult = updateRowInTable(index.row(), rec); |
||
66 | /// QSqlTableModel::setData(newindex, QVariant(str_tmp), Qt::EditRole); |
||
67 | |||
68 | |||
69 | } |
||
70 | **********************************************/ |
||
71 | |||
72 | |||
73 | |||
74 | |||
75 | return lResult; |
||
76 | |||
77 | |||
78 | |||
79 | |||
80 | |||
81 | } |
||
82 | |||
83 | |||
84 | |||
85 | QVariant MyModel::data(const QModelIndex &index, int role) const { |
||
86 | |||
87 | QVariant value = QSqlTableModel::data(index, role); |
||
128 | pingvin | 88 | QList <int> keys; |
89 | QStringList values; |
||
90 | keys = pointers_map.keys(); // |
||
91 | values = pointers_map.values(); // - |
||
92 | |||
93 | switch (role) { |
||
94 | case Qt::DisplayRole: |
||
95 | { |
||
96 | int index_of_list; |
||
97 | index_of_list = keys.indexOf(index.column()); |
||
98 | |||
99 | if (index_of_list == -1) return value; |
||
100 | else { |
||
129 | pingvin | 101 | QString parentInctance; |
102 | QSqlQuery q; |
||
103 | QString sql_str; |
||
104 | bool ok; |
||
105 | parentInctance = values.at(index_of_list); |
||
106 | sql_str = tr("select * from `"); |
||
107 | sql_str.append(parentInctance); |
||
108 | sql_str.append(tr("` ")); |
||
109 | sql_str.append(tr("where `ID` = ")); |
||
110 | sql_str.append(value.toString()); |
||
111 | q.prepare(sql_str); |
||
112 | ok = q.exec(); |
||
113 | |||
114 | if (ok) { |
||
115 | while(q.next()){ |
||
116 | QString object_name = q.value(1).toString(); |
||
117 | if (!object_name.isEmpty()) return object_name; |
||
118 | |||
119 | } |
||
120 | } |
||
128 | pingvin | 121 | int ii; |
122 | ii++; |
||
129 | pingvin | 123 | |
124 | |||
128 | pingvin | 125 | } |
126 | return value; |
||
127 | |||
128 | } |
||
129 | // if (index.column() == 1) |
||
130 | // return value.toString().prepend(tr(" ")); |
||
131 | |||
132 | |||
133 | case Qt::EditRole: return value; |
||
134 | // if (index.column() == 1) |
||
135 | // return value.toString().prepend(tr(" ")); |
||
136 | |||
127 | pingvin | 137 | case Qt::TextColorRole: |
138 | if(index.column() == 1) |
||
139 | return qVariantFromValue(QColor(Qt::blue)); |
||
140 | else |
||
141 | return value; |
||
142 | case Qt::TextAlignmentRole: return value; |
||
143 | case Qt::FontRole: |
||
144 | if(index.column() == 1) { |
||
145 | QFont font = QFont("Helvetica", 16, QFont::Bold); |
||
146 | return qVariantFromValue(font); |
||
147 | }else |
||
148 | return value; |
||
149 | |||
150 | case Qt::BackgroundColorRole: { |
||
151 | int a = (index.row() % 2) ? 14 : 0; |
||
152 | if(index.column() == 2) |
||
153 | return qVariantFromValue(QColor(220,240-a,230-a)); |
||
154 | else if(index.column() == 4) |
||
155 | return qVariantFromValue(QColor(200,220-a,255-a)); |
||
156 | else |
||
157 | return value; |
||
158 | } |
||
159 | |||
160 | |||
161 | |||
162 | case Qt::CheckStateRole: return value; |
||
163 | |||
164 | case Qt::SizeHintRole:return value; |
||
165 | |||
166 | } |
||
167 | return value; |
||
168 | } |
||
169 | |||
170 |